DealSheet

Subject-To Existing Mortgage Cash-Flow & Entry Fee Calculator

Taking over an existing 3.25% to 4.25% fixed-rate mortgage can create strong monthly cash flow when entry fees and arrears stay disciplined relative to equity.

Subject-To Entry Basis
Entry Cash = Cash to Seller + Arrears + Closing Costs + Rehab
Calibration Deals:
DSCR Coverage
1.28x
>= 1.25x Pass
Monthly Cash Flow
+$360
+$4,318/yr
Cap Rate
6.09%
NOI $19,492/yr
70% Flip MAO
$225,500
$94,500 over
Cash-on-Cash
7.58%
Cash In $57,000
1% Rule / GRM
0.83%
GRM 10.1x

Deal Assumptions

$
$
$
$

7x7 Interest Rate vs Vacancy Stress Matrix

22/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%
2.00%
2.50%
3.00%
3.50%
4.00%
4.50%
5.00%

Annual Operating Statement & Debt Service

Gross Scheduled Income
$31,800
Effective Gross Income
$30,210
Operating Expenses
-$10,718
Net Operating Income
$19,492
Monthly Debt (P&I)
$1,264.51
Total Cash Required
$57,000

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

Reference Scenario Benchmarks

Scenario Inputs Result Underwriting Note
3.25% Existing Note $280k Bal / $2,650 Rent DSCR ~1.45x Low interest rate drives rapid principal paydown
4.50% Existing Note $280k Bal / $2,650 Rent DSCR ~1.22x Verify escrow tax and insurance adjustments
High Entry Fee Caution 22% Cash Entry Compressed CoC Compare against conventional DSCR alternative

Field Verification Checklist

  • 1 Verify exact principal, interest, tax, and insurance escrow statements before closing.
  • 2 Consult licensed real estate counsel regarding due-on-sale clauses, title insurance, and third-party loan servicing.
  • 3 Keep liquid reserves equal to 6 months of PITI payments.

Related Underwriting Guides