How to Model an Airbnb Deal Before You Sign
Share
Nobody signs a lease expecting to lose money. The hosts who do lose money ran the numbers in their head, in a good mood, using the best month they'd seen on a screenshot. The fix costs an evening: model the deal on paper, at honest numbers, before anything is signed. Here's the shape of that model.
Start with all-in monthly cost, not rent
Rent is the headline, not the total. Add utilities, internet, insurance, software, supplies, and — the one everyone forgets — furnishing amortization. If setup costs $12,000 and you're on a 3-year lease, that's $333 every month whether you book a single night or not. Your real monthly nut is usually 25–40% above rent.
Find your break-even occupancy
Divide the all-in monthly cost by your realistic ADR (from your winter comp set, not your summer dreams) and you get the nights you must sell to break even. Now the deal has a shape: break-even at 11 nights a month is a resilient deal; break-even at 22 nights is a prayer with a lease attached.
Run The Floor Test
Now re-run the whole model at worst-case numbers: slowest-month occupancy, winter ADR, an extra maintenance line. If the deal still covers its costs at the floor — or comes close enough that a good month buys back the gap — it deserves your signature. If the floor version bleeds badly, the summer version was a mirage. A deal you wouldn't sign at its floor is a deal you shouldn't sign at all.
Then — and only then — look at upside
Upside modeling comes last, and in two flavors: an aggressive multi-year scaling case and a conservative one. The gap between those two lines is your actual risk, in dollars, on one page. Most people find the conservative case still worth doing — which is exactly what you want to know before committing to three years of rent.
Get the spreadsheets: the Financial Modeling Kit
Three ready-to-use models — the per-deal profit calculator with break-even and a go/no-go rating, plus aggressive and conservative 3-year scaling models. Excel and Google Sheets. $47.
Educational content — projections are illustrations, not predictions. See our Earnings Disclaimer.