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.