DealSheet

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

Related Underwriting Guides