Coffee Shop Business Plan & Financial Model
Turn seats, menu prices and staff into 36 months of covers, profit, break-even and cash.
$6.30Regular price $9-30%$9Buy now
1 / 8
Airbnb Business Plan & Financial Model
Turn units, nightly rates and seasons into 36 months of occupancy, profit and cash.
$6.30Regular price $9-30%$9
Fall Sale: 30% off at checkout, ends Nov 15.
–Days––Hours––Min––SecAn Airbnb calculator and short-term rental business plan in one spreadsheet, for Airbnb and Vrbo rentals, guest houses, B&Bs and small hotels. Enter your units, nightly rate, occupancy ramp, cleaning fees, platform commission and running costs, and it builds a 36-month model on the real nights in each month, with occupancy tax kept out of your revenue. The dashboard shows occupancy, ADR, RevPAR, profit and your break-even occupancy.
Format: Excel + Google Sheets · PDF guide
License: Personal & Business
Made for you if…
- You are buying, renting or converting a property to run as an Airbnb, Vrbo rental, guest house or B&B
- You want to know what occupancy you need to cover the mortgage before you commit
- You need an income and profit projection for your lender, partner or business plan
What you’ll get done
- See your break-even occupancy for every month, and which seasons lose money
- Know your ADR, RevPAR, platform commission and profit for each year
- Find out how much cash you need to get through your first slow season
What’s inside
- 01Blank financial model (.xlsx) that opens in Excel and Google Sheets
- 02Example file filled in for a 4-unit vacation rental in a US lake town, opening May 2027
- 03Tabs: Dashboard (12 key numbers, revenue vs costs and cash charts, Year 1-3 columns, cost breakdown, occupancy vs break-even), Assumptions, 36-month Monthly model, Annual summary (P&L)
- 0411-page PDF guide, including how to open it in Google Sheets
- 05Prints on US Letter paper
Try the free version
Run the numbers with the Airbnb Calculator
Check whether a short-term rental pays before you buy, lease or list it. The Airbnb Business Plan & Financial Model keeps it going month after month.
Open the free tool
Goes well with
Salon Business Plan & Financial Model
See how many appointments you need to break even, and your first three years of profit.
$6.30Regular price $9-30%$9Buy now
Small Business Planner & Goal Tracker
Goals, sales, cash and weekly priorities for a business of one, in a sheet and on paper.
$6.30Regular price $9-30%$9Buy now
Frequently Asked Questions
Does it work in Google Sheets?
Yes. Your PDF guide has a link that makes your own Google Sheets copy in one click, with no upload needed. It also works in Excel 2019 or later and Microsoft 365.
Does it work for a B&B, guest house or small hotel?
Yes. Count each room as a unit and use the breakfast and bar lines for food and drink sales, each with its own cost. Set the platform share to the share of bookings that come through Airbnb, Vrbo or Booking.com.
How does it handle occupancy tax and Airbnb fees?
Occupancy or tourist tax is shown as collected from guests and paid on, never as your revenue. Platform commission is its own line, worked out on the share of bookings that come through platforms, with a separate payment fee for direct bookings.
Is it a download or a subscription?
A one-time download. You pay once and keep the files.