5-Year Rental Property IRR & Total Equity Projection Guide
Cash-on-Cash only captures Year-1 cash flow; 5-Year IRR captures all four wealth engines together: cash flow, principal amortization, rent growth, and net resale equity.
Internal Rate of Return (NPV = 0)
0 = -InitialCash + Sum(CF_t / (1 + IRR)^t) + NetExitProceeds / (1 + IRR)^5
Calibration Deals:
DSCR Coverage
1.23x
Below 1.25x
Monthly Cash Flow
+$340
+$4,084/yr
Cap Rate
7.66%
NOI $21,829/yr
70% Flip MAO
$201,500
$83,500 over
Cash-on-Cash
5.27%
Cash In $77,550
1% Rule / GRM
1.02%
GRM 8.2x
Deal Assumptions
$
$
$
$
7x7 Interest Rate vs Vacancy Stress Matrix
17/49 cells pass DSCR >= 1.25xClick any scenario cell to inspect exact monthly cash flow and lender coverage. Emerald cells clear both positive cash flow and your DSCR bar.
| Rate \ Vac | 0% | 3% | 5% | 8% | 10% | 15% | 20% |
|---|---|---|---|---|---|---|---|
| 5.25% | |||||||
| 5.75% | |||||||
| 6.25% | |||||||
| 6.75% | |||||||
| 7.25% | |||||||
| 7.75% | |||||||
| 8.25% |
Annual Operating Statement & Debt Service
- Gross Scheduled Income
- $34,800
- Effective Gross Income
- $33,060
- Operating Expenses
- -$11,231
- Net Operating Income
- $21,829
- Monthly Debt (P&I)
- $1,478.80
- Total Cash Required
- $77,550
Educational mathematical modeling worksheet only; not financial, tax, lending, or legal advice.
Reference Scenario Benchmarks
| Scenario | Inputs | Result | Underwriting Note |
|---|---|---|---|
| Conservative 2% Growth | Low Appreciation + 5% CoC | 11%-14% 5-Yr IRR | Driven primarily by cash flow and loan paydown |
| Baseline 3% Growth | Standard Buy & Hold | 15%-19% 5-Yr IRR | Balanced levered equity compounding |
| Value-Add BRRRR | Forced Equity + Low Cash In | 22%+ 5-Yr IRR | Early equity capture accelerates IRR sharply |
Field Verification Checklist
- 1 Always deduct realistic 6% to 8% exit selling costs from Year-5 projected sale value.
- 2 Do not inflate annual appreciation above long-term inflation (2.5% to 3.5%) to manufacture artificial IRR.
- 3 Pair 5-Year IRR with Year-1 DSCR so liquidity stays safe while waiting for long-term equity.