DealSheet

Seller Finance Amortization & 5 / 7 / 10-Year Balloon Calculator

Seller financing lets buyers trade a fair purchase price for flexible interest rates and down payments, provided the balloon maturity leaves ample equity for refinancing.

Balloon Payoff Check
Balloon Payoff = Exact Remaining Amortized Principal Balance at Month (Balloon Years x 12)
Calibration Deals:
DSCR Coverage
1.52x
>= 1.25x Pass
Monthly Cash Flow
+$1,343
+$16,116/yr
Cap Rate
9.05%
NOI $47,069/yr
70% Flip MAO
$376,000
$144,000 over
Cash-on-Cash
14.70%
Cash In $109,600
Year 7 Balloon
$394,412
5.75% Seller Note

Deal Assumptions

$
$
$
$

7x7 Interest Rate vs Vacancy Stress Matrix

43/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%
4.25%
4.75%
5.25%
5.75%
6.25%
6.75%
7.25%

Annual Operating Statement & Debt Service

Gross Scheduled Income
$67,200
Effective Gross Income
$63,840
Operating Expenses
-$16,771
Net Operating Income
$47,069
Monthly Debt (P&I)
$2,579.39
Total Cash Required
$109,600

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

Reference Scenario Benchmarks

Scenario Inputs Result Underwriting Note
5-Year Balloon (5.75%) $442k Note / 30yr Amort $408,900 Payoff Short refi window; needs value-add equity
7-Year Balloon (5.75%) $442k Note / 30yr Amort $392,700 Payoff Standard investor cushion for rate cycles
10-Year Balloon (5.75%) $442k Note / 30yr Amort $364,200 Payoff Substantial principal paydown before exit

Field Verification Checklist

  • 1 Always verify your exit refinance LTV at the balloon date assuming flat conservative appreciation.
  • 2 Negotiate at least a 7-year balloon window or a 2-year extension option to avoid rate-cycle traps.
  • 3 Model closing costs and property insurance naming the seller as mortgagee cleanly.

Related Underwriting Guides