DealSheet

Duplex House Hack & Post-Move-Out DSCR Calculator

Smart house-hackers underwrite a duplex twice: first for reduced monthly living cost today, and second at full two-unit market rent after moving out.

Stabilized Full-Duplex NOI
Stabilized NOI = (Unit A Rent + Unit B Rent) x (1 - Vacancy) - Operating Expenses
Calibration Deals:
DSCR Coverage
1.17x
Below 1.25x
Monthly Cash Flow
+$317
+$3,806/yr
Cap Rate
8.41%
NOI $26,503/yr
70% Flip MAO
$227,500
$87,500 over
Cash-on-Cash
9.71%
Cash In $39,200
1% Rule / GRM
1.08%
GRM 7.7x

Deal Assumptions

$
$
$
$

7x7 Interest Rate vs Vacancy Stress Matrix

11/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.00%
5.50%
6.00%
6.50%
7.00%
7.50%
8.00%

Annual Operating Statement & Debt Service

Gross Scheduled Income
$40,800
Effective Gross Income
$38,760
Operating Expenses
-$12,257
Net Operating Income
$26,503
Monthly Debt (P&I)
$1,891.46
Total Cash Required
$39,200

Educational mathematical modeling worksheet only; not financial, tax, lending, or legal advice.

Reference Scenario Benchmarks

Scenario Inputs Result Underwriting Note
Owner-Occupied Yr 1 1 Unit Rented ($1,700) Offsets ~65% PITI Lowers personal housing cost dramatically
Stabilized Yr 2 (Both Rented) 2 Units ($3,400/mo) DSCR 1.18x-1.28x Check full-rent self-sufficiency before buying
Value-Add Cosmetic Turn +$250/unit Rent Lift +$6,000/yr Gross Pushes stabilized duplex over 1.25x threshold

Field Verification Checklist

  • 1 Confirm whether water, sewer, and trash are separately metered or landlord-paid in your operating budget.
  • 2 Include mortgage insurance (PMI/MIP) inside monthly carrying costs when putting less than 20% down.
  • 3 Run the full 2-unit pro-forma with an 8% property management line item even if self-managing in Year 1.

Related Underwriting Guides