← Back to Buying a business

Tools / Buying a business

Working out financing terms / Downloadable software

Seller Note +
Bank Loan Payment Lab.

Bring both loans into the same calculation. See the monthly payments, what remains after your income, and the balances that could come due later.

Buy Payment Lab — $5 ↗

One-time purchase · Offline browser application + opening guide

Trace the payments and each balloon date
Cedar Laundry: fictional bank and seller loans with different balloon years.

When this helps.

You have a particular business and are discussing how the purchase would be financed. The bank and seller may offer different rates, repayment schedules, and dates when the remaining balance becomes due.

Try the proposed terms together. Change one assumption to see its effect before taking questions back to the seller, lender, or your advisers.

Bring the proposed terms.

  • The purchase price, your down payment toward that price, and annual owner cash flow (SDE).
  • The bank-loan amount, fixed interest rate, and amortization period.
  • The seller-note amount, fixed interest rate, and amortization period.
  • An optional early balloon year for each loan.
  • Your target annual income and the monthly cushion you want left after debt and that income.

What you receive.

  • The Payment Lab HTML application and a plain-English quick-start guide.
  • Individual loan payments and combined monthly and annual debt service.
  • Cash flow after debt, after your income, and against your selected cushion.
  • Debt coverage, cash-on-cash calculation, and checks that the purchase funding adds up.
  • Each balloon balance with its own due year.
  • A financing summary with the assumptions and results, ready to copy and keep.

Read payments and balloons together.

Amortization determines the scheduled monthly payment. An earlier balloon date leaves a balance to pay or refinance in that year. A low monthly payment does not remove that obligation.

The tool shows each balloon separately. Their combined balance may span different years; it is not one payment due on a single date. The monthly figures do not include balloon payments or model what replacement financing would cost.

Keep the scope clear.

This is a fixed-rate, monthly-amortization scenario for one bank loan and one seller note. Purchase funding excludes closing costs, fees, taxes, and working capital. It does not model interest-only periods, payment holidays, changing rates, or changing earnings over time.

The screening labels use the tool’s stated rules. They are not lender approval or a recommendation to buy. Confirm the figures, omitted costs, and actual financing terms before relying on the results.

Open it and keep the summary.

Extract the ZIP and open seller-note-bank-loan-payment-lab.html in your desktop browser. It works offline without Excel, installation, or a product account. Load example supplies fictional figures to try first.

Entries are not saved between sessions. Use Copy financing summary and paste it into a document you keep before closing or reloading. Show summary text lets you select and copy manually. The summary cannot be imported to restore the calculator.

Payment Lab / Worked example

Read the monthly payments and the dates.

Monthly payments and later balances answer different questions. Follow both before comparing the financing terms.

01 / The terms

Reconcile the purchase funding first.

A $300,000 purchase is funded by $60,000 down, a $180,000 bank loan and a $60,000 seller note. Both loans use 10-year amortization, but the balances become due earlier.

Bank terms
$180,000 · 8% · balloon in year 7
Seller terms
$60,000 · 6% · balloon in year 4
Scheduled bank / seller payments
$2,184 / $666 monthly
Purchase funding gap
$0
Annual SDE / owner income target
$100,000 / $48,000
Monthly cushion target
$1,500
The funding check covers the purchase price. Closing costs, fees, taxes and working capital need separate provision.

Fictional fixed-rate monthly-amortization scenario. Balloons exclude fees and refinancing costs.

Keep your open draft?

Continuing will discard your unsaved changes. You can return to the draft and save or download it first.