DealSheet

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.25x

Click any scenario cell to inspect exact monthly cash flow and lender coverage. Emerald cells clear both positive cash flow and your DSCR bar.

Rate \ Vac0%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.

Related Underwriting Guides