Airbnb / Short Term Rental Calculator Spreadsheet
Will that short term rental actually make money after cleaning, platform fees, and the slow months? This spreadsheet answers with your numbers, then runs the same house as a normal long term rental side by side so you can see which use of the property wins.
Break-even occupancy: the booking rate below which the property loses money at your nightly rate. If a listing needs 70 percent occupancy year round to break even, you are not buying a rental, you are buying a job with a mortgage. This model computes it automatically.
What the spreadsheet does
- Revenue after reality. Nightly rate, occupancy, average length of stay, platform fees, cleaning per stay. Gross revenue is easy; this shows what survives.
- Monthly cash flow and the grade. Every operating cost, then an A to F deal grade against a published rubric with the bands printed on the Assumptions tab.
- Break-even occupancy. How bad a season you can survive, computed, not guessed.
- STR versus long term, side by side. The same property run as a normal rental. Sometimes the boring answer wins, and it is better to know before you furnish six bedrooms.
- Permits and rules checklist. The local questions that kill STR deals, wired to the dashboard: any No stops the grade.
- Seven tabs: Dashboard, Start Here, Inputs, Assumptions, STR Analysis, Permits and Rules, STR vs Long-Term.
Not for you if
- You want revenue projections pulled from market data automatically. You bring the rate and occupancy estimates, ideally from real comps in your market; the model brings honest arithmetic. Averages sold by data vendors run high for new operators.
- You want a tool that assumes 90 percent occupancy. The defaults here are conservative on purpose.
- You need dynamic pricing or channel management. This is buy-or-do-not-buy math, not operations software.
Short Term Rental Revenue Model, $18
Instant download on Etsy. Excel and Google Sheets, no subscription, yours forever.
Buy on Etsy, $18Analyzing long term rentals too? The ten tab Investor Model at $49 covers the long term side in full depth: grade, walk-away price, five year projection, BRRRR, and a three deal comparison. Thirty day money-back guarantee.
Check the long term case first, free
A short term rental that fails as a long term rental has no floor under it. The free DealGauge grader scores the property as a plain rental in about ninety seconds, no signup. If it grades well both ways, you have options, and options are worth money.
Common questions
What is break-even occupancy?
The booking rate below which the property loses money at your nightly rate and cost structure. It tells you how bad a season you can survive, and the model computes it automatically.
Does it work for Airbnb and Vrbo style rentals?
Yes. It is platform neutral: you enter the rate, occupancy, length of stay, platform fee, and cleaning cost, so it fits any platform or direct bookings.
Does it check local rules?
It includes a permits and rules checklist wired to the dashboard: any No stops the grade. It is a checklist, not legal advice. Verify with your city before buying.
Does it work in Google Sheets?
Yes. File then Import then Upload, and every formula carries over. It opens natively in Excel too.
Is this a subscription?
No. One purchase, yours forever.
General information and educational content only, not investment, tax, or legal advice. Airbnb and Vrbo are trademarks of their respective owners; DealGauge is not affiliated with or endorsed by either. Short term rental regulations vary by city and change often. Verify every figure and every rule before purchasing any property.