Airbnb / STR Profit Calculator

Find out if a short-term rental really profits after cleaning, platform fees, and furnishing.

Nightly rates look great until cleaning, platform fees, supplies, and a furnishing bill show up. This calculator models the whole year so you can see real profit, return on your cash, and the occupancy you need just to break even.

Set nightly rate and occupancy for each month in a 12-month seasonality table. Then add the average stay length, the cleaning fee you charge and what cleaning costs you, supplies, host platform fee %, co-host %, utilities, internet, software, permits, insurance, HOA, and financing.

You get:

• A month-by-month P&L (nights booked, revenue, fees, operating costs, debt service, cash flow)
• - Annual NOI and cash flow
• - Cash-on-cash ROI on your full startup cash, including furnishing and setup
• - Payback period
• - Break-even occupancy, plus your cushion above it

Warning flags call out thin margins.

What's inside: How to use, Inputs, Monthly P&L, and Results tabs, with a fictional sample cabin. Yellow inputs, gray formulas, no macros.

It works in Excel and Google Sheets. It's an instant download (.xlsx). This is an educational worksheet, not investment or tax advice.

Tags: airbnb calculator, short term rental, str calculator, airbnb spreadsheet, vrbo, rental income calculator, break even occupancy, google sheets