Skip to content
SheetModel
Real EstateE-commerceConstructionB2B SaaSWorkforceAbout
Real Estate 3 Excel tabs included 10 min read Updated Jan 2026

Airbnb & short-term rental revenue projection

Model seasonality month by month, then see turnover costs, platform fees, NOI and cash flow — and download the 365-day Excel projection with a cleaning cost matrix.

Months modelled
12
Typical STR opex ratio
35–50%
Turnover cost per stay
$90–160
Advertisement
Advertisement

Why a single occupancy number destroys STR projections

Almost every short-term rental projection you will see online uses one occupancy figure — "assume 65% occupancy" — multiplied by 365 nights. That single assumption can be wrong by 40% in a seasonal market and it hides the most important operational fact about short-term rentals: your costs are event-driven, not nightly.

A beach market that runs 92% occupancy in July and 38% in January is not a 65%-occupancy business. It is a business that funds eight months of debt service from three months of revenue. The seasonality calendar in this tool exists so you can see the cash trough, not just the annual average.

  • RevPAR (revenue per available night) is the STR equivalent of cap rate — it combines rate and occupancy into one comparable number.
  • Peak-season ADR premium is real: the same unit often earns 60–90% more per night in high season.
  • Minimum-stay rules in peak season reduce turnover cost but cap total nights; model both, not one.

Turnover economics: the cost line everyone forgets

Every stay ends with a turnover: cleaning, laundry, restocking, and a maintenance walk-through. At a 3.4-night average stay, a 70%-occupancy year produces roughly 75 turnovers. At $110 of cleaner cost each, that is $8,250 — a number that does not appear anywhere in a traditional rental analysis.

The nuance is that hosts charge a cleaning fee, so cleaning is partially revenue-neutral. The mistake is treating the cleaning fee as pure profit or ignoring it entirely. The model separates cleaning revenue from cleaning cost and shows you the net turnover contribution, which is usually thinner than hosts assume once supplies and laundry are included.

Net turnover contributionlive formula
Turns      = Nights booked ÷ Average stay length
Margin     = Turns × (Cleaning fee − Cleaner cost)
Net        = Margin − Supplies − Laundry & restock
In the workbook, column D of the Cleaning & Turnover tab divides nights by your average stay length and multiplies through — change the average stay and every month re-books.
Advertisement

The STR cost stack versus a long-term rental

Short-term rentals have a materially different cost structure to a twelve-month lease, and underwriting them with a landlord expense template will produce a number that is too optimistic.

Cost line comparison — long-term rental vs short-term rental
Cost lineLong-term rentalShort-term rental
Vacancy allowance5–8%30–45% (seasonal)
Property management8–10% of rent15–25% of revenue
InsuranceLandlord / DP-3STR endorsement, 20–40% higher
UtilitiesTenant paidHost paid, $200–400/month
FurnishingNone$15,000–45,000 upfront
CleaningNone (tenant)$90–160 per turnover
Supplies & consumablesNone$60–120/month

Platform fees, direct bookings and the host fee trap

Airbnb’s host-only fee structure typically lands between 14% and 16% of the accommodation subtotal. Vrbo charges a percentage to the guest, which shifts the maths but not the total cost of distribution. Booking.com charges commission on the total including cleaning fees, which quietly erodes the turnover margin you calculated earlier.

The strategic answer is a direct-booking channel: repeat guests who book direct cost you a payment processing fee (2.9%) instead of a platform fee (15%). Most hosts who build a modest direct channel in year two see blended distribution costs fall 400–600 basis points, which on a $60,000 revenue base is $2,400–3,600 of pure margin. The model lets you test that by lowering the platform fee percentage while keeping ADR flat.

  • Model platform fees on accommodation revenue, not on gross revenue including cleaning.
  • Direct bookings move the effective fee from ~15% to ~3% — worth modelling as a scenario.
  • Channel mix changes cancellation exposure: platform bookings carry more last-minute cancellations.

Regulation: underwrite the permit, not just the property

The most common reason an STR projection fails is not occupancy — it is a permit that cannot be renewed. Many US cities cap non-owner-occupied permits, require a minimum one-year waiting period, or restrict short stays in specific zones or buildings.

Before underwriting, verify three things: that the property is in an STR-eligible zone, that permits are currently available (not waitlisted), and that the HOA or condo declaration does not prohibit rentals under 30 days. A single restrictive covenant can turn a 7% cash-on-cash STR into a 4% long-term rental overnight.

How to use this tool

  1. Set your ADR from real comparable listings. Pull the nightly rate from five active listings in the same building or street. Use the median, not the highest, and adjust for differences in bedrooms, views and amenities.
  2. Set occupancy for each of the twelve months. Drag each month’s slider. If you do not know the seasonality curve yet, start with market data and then apply your own local knowledge — ski, snowbird and beach markets behave very differently.
  3. Enter turnover and operating costs. Enter cleaning fee charged, cleaner cost, supplies, utilities, STR insurance and the furnishing budget. These determine whether the property survives its own cost stack.
  4. Download and stress-test the workbook. Download the .xlsx, then reduce peak-season occupancy by 15% and raise the platform fee by 3 points. If the deal still cash-flows, it is robust.

What is inside the download

A 12-month seasonality calendar with editable occupancy rates, a turnover cost matrix that treats cleaning fees as revenue and cleaner invoices as cost, and a monthly P&L with annual return metrics.

  • Seasonality Calendar — a separate worksheet in str-revenue-projection.xlsx.
  • Cleaning & Turnover — a separate worksheet in str-revenue-projection.xlsx.
  • P&L Statement — a separate worksheet in str-revenue-projection.xlsx.

Where these defaults come from

Every pre-filled value in the calculator above is listed below with its basis. None of it is proprietary to us — we do not run primary research. Statutory figures come from the regulator, fee schedules from the vendor that charges them, ranges from published industry surveys, and conventions are labelled as rules of thumb. When you have your own numbers, replace the default: the workbook formulas do not care where an input came from.

DefaultValue usedBasisSource
STR platform / host feeHost-only fee model. Direct bookings replace this with a ~3% payment processing cost.14–16%Vendor rate cardNo authoritative source — industry convention
Stabilised STR occupancyLeisure markets; urban business-travel markets often run higher on weeknights. New listings underperform for 60–90 days.55–70%Market surveyAirDNAShort-term rental market dataCited by name · link pending verification
STR insurance premium vs landlord policyRequires a business-activity endorsement; some carriers restrict by occupancy type.+20–40%Market surveyNo authoritative source — industry convention
Cleaning cost per turnoverDependent on unit size, market labour rates and whether laundry is in-house.$90–160Rule of thumbNo authoritative source — industry convention
Investor mortgage rate (default)Illustrative only. Investor loans typically price above the homeowner survey rate by 50–150 bps. Replace with your lender’s quote.6.75%Market surveyFreddie MacPrimary Mortgage Market SurveyCited by name · link pending verification

Full source registry, verification status and review cadence: data sources & methodology.

Frequently asked questions

A well-priced, professionally photographed listing in a leisure market typically stabilises at 55–70% annual occupancy. Urban business-travel markets often run 65–80% on weeknights with softer weekends. New listings usually underperform the market average for the first 60–90 days while they accumulate reviews — model month 1 at 60% of your stabilised occupancy.

Software that pairs with this model

These are the platforms our models are designed to work alongside, chosen because their pricing or data appears in the model itself. Some links are affiliate links — they cost you nothing, and they never influence a formula, a default value or a result.

Related models