How to Model an Airbnb Deal Before You Sign

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.

Get the Financial Modeling Kit →

Educational content — projections are illustrations, not predictions. See our Earnings Disclaimer.

Back to blog
Host Smarter — Guides & Insights

Knowledge that pays for itself.

What we've learned setting up rentals across New England, written down so you profit from it.

Why Most Hosts Lose Money in Jan–Feb (and What Strong Operators Do Instead)

The slow season doesn't surprise anyone — it arrives on schedule every year. The difference between red and...

Midterm Rentals: Filling Units When Tourism Dies

Travel nurses, relocations, and insurance placements book 30+ day stays year-round — through different chan...

Last-Minute Discounts: The Exact Tiers

An empty night expires worthless at midnight. The stepped discount schedule — from 8% at four weeks out to ...

Free Download

The Beginner's Arbitrage Roadmap

The free guide that maps the whole journey — from zero to your first unit, and what changes at 3–4 and 5+ units.

  • The 15-step first-unit launch sequence
  • The Beginner → Advanced progression (1–2, 3–4, 5+ units)
  • The deal-review worksheet we use on every unit

No spam. Unsubscribe anytime. Educational content — see our Earnings Disclaimer.