{"product_id":"airbnb-pricing-occupancy-calculator","title":"Airbnb Pricing Calculator Spreadsheet – Nightly Rate, Occupancy, Break-Even \u0026 Revenue Forecast Template, Excel \u0026 Google Sheets, No Canva","description":"\u003cp\u003e\u003cstrong\u003ePricing \u0026amp; Occupancy Calculator\u003c\/strong\u003e – 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eNo Canva, no add-ons.\u003c\/strong\u003e Works in Excel, Google Sheets (free) and Numbers. Yellow cells are inputs, grey cells are protected formulas.\u003c\/p\u003e\n\u003ch3\u003e5 sheets inside\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003ePricing Calculator\u003c\/strong\u003e – 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 \u0026amp; occupancy, projected annual profit, what-if box.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eOccupancy Tracker\u003c\/strong\u003e – 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.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRate Calendar\u003c\/strong\u003e – pick a season per month from a dropdown; weekday and weekend rates fill in automatically; add minimum stay and local events.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eComp Analysis\u003c\/strong\u003e – log up to 10 nearby listings; see average and median nightly rates and your position versus the market.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRead Me\u003c\/strong\u003e – how to use, definitions (ADR, RevPAR, break-even), Google Sheets notes.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eFiles you receive\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003ePricing-Occupancy-Calculator.xlsx – editable workbook\u003c\/li\u003e\n\u003cli\u003ePricing-Occupancy-Calculator.pdf – printable overview of every sheet\u003c\/li\u003e\n\u003cli\u003eSTART-HERE-How-to-Edit.pdf\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eHow it works\u003c\/h3\u003e\n\u003col\u003e\n\u003cli\u003eDownload the ZIP after checkout.\u003c\/li\u003e\n\u003cli\u003eOpen the .xlsx in Excel, or upload it to Google Drive and open with Google Sheets.\u003c\/li\u003e\n\u003cli\u003eType your numbers into the yellow cells. Everything else updates instantly.\u003c\/li\u003e\n\u003cli\u003eUse the Rate Calendar to set your prices on Airbnb, VRBO and your direct-booking site.\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003ch3\u003eFAQ\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eDoes it work in Google Sheets?\u003c\/strong\u003e Yes – formulas, dropdowns and colour rules all work after upload.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eMultiple properties?\u003c\/strong\u003e Duplicate the file (or the sheets) per property.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eIs this bookkeeping?\u003c\/strong\u003e No – for income and expense tracking see our Host Income \u0026amp; Expense Tracker. This workbook is for setting rates and forecasting.\u003c\/p\u003e\n\u003cp\u003e\u003cem\u003eLicense:\u003c\/em\u003e 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.\u003c\/p\u003e","brand":"Welcome Desk Co.","offers":[{"title":"Default Title","offer_id":67842058256636,"sku":null,"price":4.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0829\/2358\/5788\/files\/pricing-occupancy-calculator__01-hero.jpg?v=1792600321","url":"https:\/\/hello.welcomedeskco.shop\/products\/airbnb-pricing-occupancy-calculator","provider":"Welcome Desk Co.","version":"1.0","type":"link"}