Airbnb / STR Acquisition & Underwriting Model

You found the property. The bank wants numbers. This model is how you get them right.

Built for investors buying (or refinancing) a short-term rental in the US — with the underwriting logic DSCR lenders actually use, not a generic "rental calculator".

What it calculates for your deal:

• DSCR the way lenders compute it — stabilized basis, with your ramp-up kept separate (most templates get this wrong)
• Cash-on-Cash return year by year, on your real cash in
• 5-year IRR with exit assumptions you control
• Break-even occupancy — the single number that tells you how much cushion you really have
• 36-month cash flow with seasonal ADR & occupancy (12 monthly inputs, not one fake average)
• Sensitivity matrix — ADR ±20% × occupancy ±20% on both Cash-on-Cash and DSCR, color-coded

What's inside:

• 10-sheet Excel workbook (works in Google Sheets too — no macros, no add-ins, no links)
• START HERE sheet: your first pro forma in 10 minutes, only yellow cells to fill
• Deal, financing (DSCR loan vs conventional, interest-only option), revenue and expense inputs — all editable, all visible
• Dashboard with KPI cards and charts, formatted to share with your lender or partners
• Benchmarks sheet with sourced 2025-26 ADR / occupancy / expense ranges by market type, plus how to pull YOUR market's data free from AirDNA / Rabbu
• 13-page PDF guide: sheet-by-sheet walkthrough, how lenders read your DSCR, FAQ

Why this one: every formula in this workbook is machine-verified — the full calculation graph is recomputed by three independent engines (including Excel itself) before release. Models that balance to the cent, every time.

Educational planning tool — not financial, investment or legal advice. Verify your market data and consult your professionals before purchasing real estate.