Airbnb Pricing Calculator Spreadsheet – Nightly Rate, Occupancy, Break-Even & Revenue Forecast Template, Excel & Google Sheets, No Canva

Pricing & Occupancy Calculator – a spreadsheet that answers the question every host asks: “what should I charge, and how many nights do I need to book to make money?” Enter your base rate, season multipliers, fees and fixed costs; the workbook returns weekday/weekend rates per season, projected annual revenue, break-even occupancy and profit – and lets you test a price change before you touch your live listing.

No Canva, no add-ons. Works in Excel, Google Sheets (free) and Numbers. Yellow cells are inputs, grey cells are protected formulas.

5 sheets inside

• Pricing Calculator – base rate, weekend premium, cleaning fee, platform fee, 4 seasons with multipliers, revenue per season, annual gross and net payout, ADR, RevPAR, fixed-cost table, break-even nights & occupancy, projected annual profit, what-if box.
• Occupancy Tracker – 12 months of available / blocked / booked nights, occupancy %, revenue, ADR and RevPAR with colour alerts (under 50% orange, 70%+ green) and a target-months counter.
• Rate Calendar – pick a season per month from a dropdown; weekday and weekend rates fill in automatically; add minimum stay and local events.
• Comp Analysis – log up to 10 nearby listings; see average and median nightly rates and your position versus the market.
• Read Me – how to use, definitions (ADR, RevPAR, break-even), Google Sheets notes.

Files you receive

• Pricing-Occupancy-Calculator.xlsx – editable workbook
• Pricing-Occupancy-Calculator.pdf – printable overview of every sheet
• START-HERE-How-to-Edit.pdf

How it works

1. Download the ZIP after checkout.
2. Open the .xlsx in Excel, or upload it to Google Drive and open with Google Sheets.
3. Type your numbers into the yellow cells. Everything else updates instantly.
4. Use the Rate Calendar to set your prices on Airbnb, VRBO and your direct-booking site.

FAQ

Does it work in Google Sheets? Yes – formulas, dropdowns and colour rules all work after upload.

Multiple properties? Duplicate the file (or the sheets) per property.

Is this bookkeeping? No – for income and expense tracking see our Host Income & Expense Tracker. This workbook is for setting rates and forecasting.

License: personal and single-business use; do not resell. Not financial advice. Airbnb and VRBO are trademarks of their owners and are not affiliated with this product.