How to stress-test short-term rental income in your city using occupancy shocks and market comps to decide between Airbnb and long-term leasing

How to stress-test short-term rental income in your city using occupancy shocks and market comps to decide between Airbnb and long-term leasing

I often get asked whether a property makes more sense as a short-term rental (Airbnb) or a long-term lease. The intuitive answer—“it depends”—isn't very helpful. What I find useful, and what I’ll walk you through here, is a reproducible stress-test approach that combines occupancy shocks and market comps to give a clearer, data-driven recommendation for your city and your property.

Why you need a stress test, not a fantasy budget

Owners frequently rely on optimistic averages: peak-season nightly rates, best-case occupancy, and zero downtime. That’s dangerous. Short-term rentals (STRs) are volatile—seasonality, platform changes, regulation, and macro shocks (think pandemics or travel downturns) hit occupancy first. Long-term leases are steadier but often yield lower nominal income. A stress test forces you to compare outcomes under adverse but plausible scenarios so you can decide which model fits your risk tolerance and cashflow needs.

Three pillars of my stress-test framework

I use three inputs to model STR performance and compare it to long-term leasing:

  • Baseline market comps — current average nightly rate, typical occupancy, and long-term rents from market data sources.
  • Occupancy shock scenarios — percentage drops in occupancy to simulate downturns (mild, moderate, severe).
  • Cost overlays — operating costs, platform fees, vacancy buffers, and capex for short-term vs long-term setups.
  • Step 1 — Gather reliable comps

    Start local and be specific. For STRs I use AirDNA, AllTheRooms, or Mashvisor to extract:

  • Average daily rate (ADR) for comparable properties (same bedroom count, neighborhood).
  • Average occupancy rate by month (seasonality matters).
  • Revenue per available rental (RevPAR) or monthly revenue estimates.
  • For long-term comps I check Zillow, Rentometer, or local listings to obtain current market rent for a comparable unit. Also note recent lease concessions or landlord-paid utilities that change effective rent.

    Step 2 — Build a realistic expense model

    STRs have higher operational costs. In my models I include:

  • Platform fees (Airbnb/VRBO — typically 3% to 15% depending on host model).
  • Cleaning turnover costs per stay.
  • Management fees (if using a co-host or property manager — commonly 20–30% of revenue, but can be lower with local operators).
  • Higher utilities, replenishment (toiletries, linen), supplies, and guest-facing insurance.
  • Maintenance reserve and periodic capex (furniture refresh every 3–5 years).
  • For long-term leases: landlord-paid utilities (if any), lower maintenance turnover, periodic repainting and minor repairs. Management fees for long-term are typically lower (8–12% if using a property manager).

    Step 3 — Define occupancy shock scenarios

    I model at least three scenarios for occupancy:

  • Baseline: current market occupancy (12-month average).
  • Mild shock: 20–30% drop in occupancy (short off-season or minor travel slow-down).
  • Severe shock: 50%+ drop (pandemic-like, regulatory clampdown, or multi-month travel freeze).
  • Apply these shocks to monthly occupancies rather than a single annual number to capture seasonality. For example, a 30% drop in high-season occupancy yields a different revenue loss than the same drop in low-season months.

    Step 4 — Run the revenue and cashflow comparison

    Create a simple monthly P&L for both strategies over a 12- to 24-month horizon. Key rows should include:

  • Gross rental revenue (nightly rate × occupied nights for STR; monthly rent × 12 for long-term).
  • Platform/agent fees.
  • Operating expenses (cleaning, utilities, supplies).
  • Maintenance & capex reserve.
  • Net operating income before financing.
  • Below is a compact example table you can copy into a spreadsheet and populate with local numbers. Replace the sample numbers with your comps.

    STR (Baseline)STR (Severe shock -50%)Long-term Lease
    Avg nightly rate$150$150-
    Avg occupancy (nights/month)189-
    Gross monthly revenue$2,700$1,350$1,800
    Platform & booking fees$270 (10%)$135$0
    Cleaning & turnover$300$150$50
    Utilities$200$200$100
    Mgmt fees$540 (20%)$270$180 (10%)
    Maintenance reserve$150$150$75
    Net monthly income$1,240$445$1,395

    In this sample, the long-term lease is more resilient under a severe occupancy shock. But baseline STR income is higher—hence the importance of deciding whether you can tolerate downside volatility.

    Step 5 — Evaluate downside protection and financing

    Lenders and your personal cashflow needs matter. STR lenders often underwrite using lower occupancies or cap rates, increasing debt service. If you have a mortgage, run a debt-service coverage test under each scenario. Ask: in the severe shock scenario, can I cover mortgage, insurance, and taxes for X months without dipping into reserves?

    Step 6 — Consider non-revenue impacts

    Short-term rentals come with extra time and liability costs that aren't always obvious:

  • Local regulation risk: some cities cap STR nights or require licensing—check local zoning and recent council votes.
  • Insurance: STR-specific policies or endorsements may be pricier than standard landlord insurance.
  • Wear & tear: frequent guest turnover accelerates depreciation and replacement costs.
  • Neighbourhood relations: complaints can trigger fines or revocation of licenses.
  • These qualitative factors should reduce the effective upside you assume in STR models.

    When STR wins vs when long-term wins

    STR is typically preferable when:

  • You're in a high-demand, tourism-driven micro-market with strong seasonality but high peak ADRs (e.g., coastal towns, ski resorts).
  • Occupancy remains relatively stable historically, and regulation risk is low.
  • You have the capital and operational bandwidth to manage higher variability and turnovers.
  • Long-term is typically preferable when:

  • Your market shows weak STR occupancy or aggressive regulation.
  • Transaction and management costs for STRs eat too much of the upside.
  • You prioritize predictability—stable monthly cashflow—or you cannot withstand prolonged vacancies.
  • Practical tips and tools I use

    For fast, defensible analysis:

  • Use AirDNA or Mashvisor for STR comps; validate with local listing searches on Airbnb and VRBO.
  • Use Rentometer and Zillow Rentals for long-term comps—check recent rents, not advertised ones only.
  • Automate the sensitivity analysis: create a simple spreadsheet where you can slide occupancy +/- 10/20/50% and instantly see net income changes.
  • Talk to two local property managers—one STR specialist and one long-term manager—to get realistic fee structures and operational insights.
  • Factor taxes: short-term rental income can trigger different tax treatments (sales tax, transient occupancy tax). Consult a local CPA.
  • How I operationalize this for clients

    When I advise investors, I run the STR vs long-term model with at least 12 months of monthly granularity and three shock scenarios. I present a quick payoff matrix—expected net income vs worst-case net income—and overlay a risk-adjusted preference. If a property delivers high upside but the downside breaches our 3–6 month liquidity threshold, we usually recommend long-term or a hybrid approach (block long-term during low season and STR in high season, if regulations allow).

    If you want, I can produce a simple spreadsheet template pre-filled with formulas and the sample table above so you can plug in your city’s comps and run the scenarios yourself.


    You should also check the following news:

    Personal Finance

    How to use case 6qr to déduire une pension alimentaire de ses impôts

    26/05/2026

    I often get questions from readers about the practical side of taxes and family obligations: can you déduire une pension alimentaire de ses impôts,...

    Read more...
    How to use case 6qr to déduire une pension alimentaire de ses impôts
    Portfolio Strategies

    How to build an options collar around dividend ETFs to boost yield while limiting downside — sizing, costs and rebalancing rules

    11/05/2026

    I often use option collars around dividend ETFs when I want to increase current yield without exposing the portfolio to unlimited downside. A...

    Read more...
    How to build an options collar around dividend ETFs to boost yield while limiting downside — sizing, costs and rebalancing rules