Interest Rate vs Vacancy 2D Stress-Test Calculator
Single-point spreadsheets look reassuring until rates climb 0.75% before refinance closing and a tenant moves out mid-winter. A 7x7 stress grid exposes thin deals instantly.
Dual-Shock Sensitivity
Grid(Rate_i, Vacancy_j) -> Monthly Cash Flow & DSCR across 49 Scenarios
Calibration Deals:
Post-Refi DSCR
1.33x
>= 1.25x Pass
Monthly Cash Flow
+$565
+$6,780/yr
Cap Rate
11.43%
NOI $27,438/yr
70% Flip MAO
$203,500
$36,500 over
Cash Left in Deal
$39,788
Refi Net $252,281
1% Rule / GRM
1.46%
GRM 5.7x
Deal Assumptions
$
$
$
$
7x7 Interest Rate vs Vacancy Stress Matrix
26/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.50% | |||||||
| 6.00% | |||||||
| 6.50% | |||||||
| 7.00% | |||||||
| 7.50% | |||||||
| 8.00% | |||||||
| 8.50% |
Annual Operating Statement & Debt Service
- Gross Scheduled Income
- $42,000
- Effective Gross Income
- $39,900
- Operating Expenses
- -$12,462
- Net Operating Income
- $27,438
- Monthly Debt (P&I)
- $1,277.38
- Total Cash Required
- $93,200
Educational mathematical modeling worksheet only; not financial, tax, lending, or legal advice.
Reference Scenario Benchmarks
| Scenario | Inputs | Result | Underwriting Note |
|---|---|---|---|
| Fragile Deal | < 15/49 Passing Cells | High Refi Risk | Single 0.50% rate move breaks coverage |
| Balanced Underwrite | 22-32/49 Passing Cells | Moderate Cushion | Survives typical rate or vacancy bumps |
| Fortress Cash Flow | 35+/49 Passing Cells | High Resilience | Clears 1.25x DSCR even at +1.0% rate shock |
Field Verification Checklist
- 1 Check the cell at Base Rate +1.0% and 10% Vacancy before closing a BRRRR bridge loan.
- 2 Confirm break-even vacancy sits comfortably above your neighborhood historical turnover rate.
- 3 Attach the 7x7 matrix inside your Lender One-Pager PDF to demonstrate underwriting discipline.