Kitchen island with bar seating in a Somerville rental

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
Go Deeper

The playbooks behind the posts.

Every post previews one system. The playbooks are the full version — step by step, written down, yours the moment checkout completes.

Coming soon

New Listing Launch Checklist

$22

The exact pre-launch sequence for a five-star first impression.

View Playbook
Coming soon

Pricing & Occupancy Playbook

$57

The Launch Ladder, discount tiers, and weekly pricing cadence.

View Playbook
Coming soon

Midterm Rental (MTR) Playbook

$57

Fill 30+ day stays: travel nurses, relocations, corporate housing.

View Playbook
Coming soon

Financial Modeling Kit

$47

Three spreadsheets to model any deal before you sign.

View Playbook

Digital downloads, PDF and spreadsheet. Priced like a decision, not a course. See all playbooks →

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.

Cozy bedroom with green bedding in a Somerville rental

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...

Bedroom in a Cambridge triplex rental

Midterm Rentals: Filling Units When Tourism Dies

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

Bedroom with layered bedding in a Somerville condo

Last-Minute Discounts: The Exact Tiers

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