Five years out. Three scenarios. Sign the offer. 5-year property-level pro forma for Airbnb / STR investors with IRR, equity multiple, and exit value across conservative / base / aggressive cases. Excel + Google Sheets. The 1-year deal analyzer tells you whether the property cash-flows. The 5-year pro forma tells you whether the property makes you wealthy. They answer different questions — and serious operators run both before writing any offer. This is the long-horizon view: revenue growth, expense inflation, debt amortization year-by-year, depreciation, exit value at year 5. Outputs IRR, equity multiple, and cumulative cash flow across three scenarios so you know what range of outcomes the deal can produce — not just a single number. WHAT’S INCLUDED 📋 Property + Acquisition · Purchase price, closing costs, rehab, total cash invested · Acquisition basis tracking (feeds depreciation) 📋 Year-1 Inputs · Stabilized year-1 revenue + expenses (typically pulled from ACQ-001) 📋 Growth Assumptions · Annual revenue growth %, expense inflation %, market appreciation % · Pre-loaded with reasonable defaults (3-5% revenue, 3% expense) 📋 Financing · Loan terms, interest rate, amortization schedule (auto-builds 5-year debt service) 📋 5-Year Pro Forma Matrix · Revenue, expenses, debt service, depreciation, cash flow per year · Cumulative cash flow + payback timing 📋 Exit Assumptions · Year-5 sale price (cap rate × stabilized NOI, OR % appreciation from purchase) · Selling costs, capital gains tax estimate, depreciation recapture 📋 Three-Scenario Output (Conservative / Base / Aggressive) · IRR per scenario · Equity multiple per scenario · Total return per scenario 📋 Pro Forma Summary Print · Send to your DSCR / commercial lender — IRR + EM is their language · Save in deal folder as the basis for measuring actual-vs-projected
Related
- Aspiring Host Bundle
- 3-Property Side-by-Side Comparison
- Refi-or-Sell Decision Matrix
- The Cash-Flow Forecaster
- STR vs LTR Yield Comparison
- Seller-Finance Offer Calculator
Get the workbook
Format: Excel .xlsx + how-to PDF. Excel 2016+, Excel 365, Google Sheets compatible. Instant download after checkout. 14-day refund, no questions. Lifetime updates within v1.