How the calculator works
Nights available are your units times 365 days, divided by 12 for an average month. Occupancy turns them into booked nights, and your average stay turns booked nights into stays, which is what drives cleaning costs.
Revenue is your nightly rate on every booked night plus the cleaning fee on every stay. From that come the platform fee, any management fee, cleaning and supplies per stay, and your fixed monthly costs.
Platform fees
Since late 2025 most Airbnb hosts pay a single host-only service fee, commonly 15.5% of the booking, instead of the older split fee of about 3%. Check the fee shown in your own Airbnb account and enter it. If you also take direct bookings, use a blended rate.
Occupancy and lodging taxes you collect from guests are passed on to the city or state, so they are not part of your revenue here.
Break-even occupancy
Break-even occupancy is the share of nights you must book to cover your fixed costs. If it is above what similar listings in your area achieve, the numbers are too tight: raise the rate, cut fixed costs, or look at a different property.
The formulas behind it
Every result cell is a plain spreadsheet formula, so you can check the math or rebuild it yourself.
| Cell | Result | Formula |
|---|---|---|
| B14 | Nights available per month | =B2*365/12 |
| B15 | Nights booked | =B14*B4% |
| B16 | Stays per month | =B15/B5 |
| B17 | Booking revenue | =B15*B3+B16*B6 |
| B18 | Platform & management fees | =B17*(B9%+B10%) |
| B19 | Cleaning & supplies | =B16*(B7+B8) |
| B20 | Monthly profit | =B17-B18-B19-B11 |
| B21 | Yearly profit | =B20*12 |
| B22 | RevPAR (room revenue per available night) | =B3*B4% |
| B23 | Break-even occupancy | =B11/(B14*(B3*(1-B9%-B10%)+(B6*(1-B9%-B10%)-B7-B8)/B5)) |