Run your rentals before they run you. Break-even occupancy calculator for Airbnb and STR hosts. Returns the one number that matters and stress-tests it against ADR shifts. Editable Excel. Insurance jumped $1,400 this year. The cleaner just bumped to $185 a turnover. Your platform commission is still 15%. You have no idea what occupancy you now need to hit to break even — and you won’t know until December when the books close. This calculator returns one number: the occupancy percent below which you are losing money. Then it shows the math behind it, then it stress-tests the answer across six occupancy scenarios and three ADR scenarios so you can see what actually breaks the property. Three tabs. One property. Twenty minutes of inputs. Done. WHAT’S INCLUDED Excel workbook (3 tabs): - Start — the answer lives here. Property name, break-even occupancy %, equivalent booked nights/year, your current occupancy (manual entry), margin gauge (✅ above break-even / ⚠ below) - Calculator — one-page input panel. 7 revenue assumptions, 10 annual fixed costs, 4 per-turnover variable costs, 3 per-month recurring costs, 11 calculated outputs ending in the break-even % readout - Sensitivity — 6×3 grid: occupancy 30/40/50/60/70/80% × ADR -10% / current / +10%. Each cell shows annual net cash flow at that scenario, color-coded red/parchment/gold The calculator splits costs the way an underwriter splits costs: fixed vs variable per turnover vs recurring per month. Cleaning fee charged to the guest is netted against cleaning cost paid — most templates double-count or miss it entirely.
Related
- Cost-to-Launch Calculator
- Commission / Split Calculator for Co-Hosts
- Cleaning Fee Optimizer
- Rental Arbitrage Analyzer
- Listing SEO Audit
- The RevPAR Dashboard
What's inside
- Airbnb and VRBO hosts who want one number, not a 40-tab pro forma
- Hosts who just got a cost increase (insurance, cleaner, mortgage refi) and need to re-run the math today
- New hosts evaluating whether a property they already own is structurally profitable
- Hosts using the STR Deal Analyzer (ACQ-001) on a new acquisition who want to sanity-check the underwriting estimate
- Anyone who has ever said "I'll figure it out at tax time" and then figured out it was too late
Get the workbook
Format: Excel .xlsx + how-to PDF. Excel 2016+, Excel 365, Google Sheets compatible. Instant download after checkout. 14-day refund, no questions. Lifetime updates within v1.