Skip to content
Spryhand

Airbnb & Short-Term Rentals

Airbnb Profit Calculator

See what a short-term rental actually clears across a full year — after platform fees, turnover costs and the months nobody books — and whether it beats letting the place long-term.

Delivery
Instant download
Purchase
One-time payment
Format
  • Google Sheets
  • Excel
Updated
August 2026
$5.90Buy on Etsy
Sample preview — illustrative data

Net profit for the year

$16,743

Break-even occupancy

29.9%

ItemYear
  • Gross revenue$42,761
  • Platform fees-$2,566
  • Cleaning cost-$3,929
  • Fixed costs-$17,832

Sample data preview of the Airbnb Profit Calculator spreadsheet, shown for illustration only.

What this spreadsheet does

Nightly rate, occupancy, cleaning fees, platform fees and utilities all affect real profit, and estimating them separately misses how they interact.

What you can do with it

  • Estimate profit before listing a new property
  • Test how a rate change affects monthly profit
  • Find the occupancy rate needed to break even

What's included

Sheet tabs

  • Instructions
  • Profit Summary
  • 12-Month Projection
  • Operating Costs
  • Assumptions

Features

  • A full 12-month projection with its own occupancy for every month
  • Turnovers worked out from occupancy and average stay length, so cleaning costs move with bookings
  • Itemised operating costs, each flagged for whether you'd still pay it with a long-term tenant
  • Annual net profit, margin and net per booked night
  • Break-even occupancy from contribution per night, with a guard for a property that can't reach it
  • Best and worst month named automatically
  • A side-by-side comparison against letting the place long-term

How it works

  1. 1Enter your nightly rate, average stay length, cleaning fees and platform cut on the Assumptions tab
  2. 2List your real monthly costs on Operating Costs, marking which ones a long-term tenant wouldn't change
  3. 3Set each month's occupancy on the 12-Month Projection tab, then read the Profit Summary

Who it's for

Hosts and prospective hosts estimating whether a property will be profitable.

Frequently asked questions

Does this account for platform fees?

Yes. Platform fees, cleaning costs and utilities are all separate inputs so profit reflects real operating costs.

Can I model more than one property?

The projection is set up for one property. Duplicate the workbook to model another — keeping them separate is also what stops one strong listing hiding a weak one.

What is break-even occupancy?

The occupancy at which an average month covers its costs and nothing more. It's worked out from your contribution per booked night, so cleaning and consumables scale with bookings rather than being held fixed. If your contribution per night is negative, the sheet says the property can't break even at any occupancy instead of printing a percentage.

Does it handle a month where the place is closed?

Yes. Set that month's occupancy to 0% and turnovers, cleaning and consumables all fall away while your fixed costs are still charged — so the month shows the real loss and the annual total stays honest.

How does it compare short-letting to a normal tenancy?

On the Operating Costs tab you mark which costs you'd still pay with a long-term tenant. The summary then puts your annual net next to what the property would clear as a long let. It's money only — it doesn't price your time.

Complete the setup

The rest of the tools this one was built to sit beside.

Similar tools

The same kind of tool, for a different job.