Balloon Loan Calculator
Payments sized like a long loan, but the rest comes due early in one big check. See the payment, the balloon, the date it lands, and the interest along the way.
Ben / Reviewed Sep 27, 2026 / v2.0.0
Results
Showing the numbers you calculated- Balloon payment
- $226,040.65
- Due 08/01/2033 · 90.42% of the loan
- Regular payment
- $1,580.17
- Principal + interest
- Total due on the balloon date
- $227,620.82
- Last regular payment + balloon
- Payments before the balloon
- 84
- Interest paid
- $108,774.93
- Through the balloon date
- Principal paid down
- $23,959.35
- By the regular payments
- Total paid
- $358,774.93
- Including the balloon
- Interest if fully amortized
- $318,861.58
- Same loan, no balloon
Balloon schedule
Swipe the table sideways to see all 7 columns.
| # | Date | Payment | Interest | Principal | Balloon | Balance |
|---|---|---|---|---|---|---|
| 1 | 09/01/2026 | $1,580.17 | $1,354.17 | $226.00 | $0.00 | $249,774.00 |
| 2 | 10/01/2026 | $1,580.17 | $1,352.94 | $227.23 | $0.00 | $249,546.77 |
| 3 | 11/01/2026 | $1,580.17 | $1,351.71 | $228.46 | $0.00 | $249,318.31 |
| 4 | 12/01/2026 | $1,580.17 | $1,350.47 | $229.70 | $0.00 | $249,088.61 |
| 5 | 01/01/2027 | $1,580.17 | $1,349.23 | $230.94 | $0.00 | $248,857.67 |
| 6 | 02/01/2027 | $1,580.17 | $1,347.98 | $232.19 | $0.00 | $248,625.48 |
| 7 | 03/01/2027 | $1,580.17 | $1,346.72 | $233.45 | $0.00 | $248,392.03 |
| 8 | 04/01/2027 | $1,580.17 | $1,345.46 | $234.71 | $0.00 | $248,157.32 |
| 9 | 05/01/2027 | $1,580.17 | $1,344.19 | $235.98 | $0.00 | $247,921.34 |
| 10 | 06/01/2027 | $1,580.17 | $1,342.91 | $237.26 | $0.00 | $247,684.08 |
| 11 | 07/01/2027 | $1,580.17 | $1,341.62 | $238.55 | $0.00 | $247,445.53 |
| 12 | 08/01/2027 | $1,580.17 | $1,340.33 | $239.84 | $0.00 | $247,205.69 |
| 13 | 09/01/2027 | $1,580.17 | $1,339.03 | $241.14 | $0.00 | $246,964.55 |
| 14 | 10/01/2027 | $1,580.17 | $1,337.72 | $242.45 | $0.00 | $246,722.10 |
| 15 | 11/01/2027 | $1,580.17 | $1,336.41 | $243.76 | $0.00 | $246,478.34 |
| 16 | 12/01/2027 | $1,580.17 | $1,335.09 | $245.08 | $0.00 | $246,233.26 |
| 17 | 01/01/2028 | $1,580.17 | $1,333.76 | $246.41 | $0.00 | $245,986.85 |
| 18 | 02/01/2028 | $1,580.17 | $1,332.43 | $247.74 | $0.00 | $245,739.11 |
| 19 | 03/01/2028 | $1,580.17 | $1,331.09 | $249.08 | $0.00 | $245,490.03 |
| 20 | 04/01/2028 | $1,580.17 | $1,329.74 | $250.43 | $0.00 | $245,239.60 |
| 21 | 05/01/2028 | $1,580.17 | $1,328.38 | $251.79 | $0.00 | $244,987.81 |
| 22 | 06/01/2028 | $1,580.17 | $1,327.02 | $253.15 | $0.00 | $244,734.66 |
| 23 | 07/01/2028 | $1,580.17 | $1,325.65 | $254.52 | $0.00 | $244,480.14 |
| 24 | 08/01/2028 | $1,580.17 | $1,324.27 | $255.90 | $0.00 | $244,224.24 |
Annual summary
Swipe the table sideways to see all 5 columns.
| Year | Payments | Interest | Principal (incl. balloon) | Year-end balance |
|---|---|---|---|---|
| 2026 | $6,320.68 | $5,409.29 | $911.39 | $249,088.61 |
| 2027 | $18,962.04 | $16,106.69 | $2,855.35 | $246,233.26 |
| 2028 | $18,962.04 | $15,915.48 | $3,046.56 | $243,186.70 |
| 2029 | $18,962.04 | $15,711.44 | $3,250.60 | $239,936.10 |
| 2030 | $18,962.04 | $15,493.72 | $3,468.32 | $236,467.78 |
| 2031 | $18,962.04 | $15,261.46 | $3,700.58 | $232,767.20 |
| 2032 | $18,962.04 | $15,013.61 | $3,948.43 | $228,818.77 |
| 2033 | $238,682.01 | $9,863.24 | $228,818.77 | $0.00 |
Suggested journal entries
Suggested entries for your records — adjust account names to your chart of accounts.
| Account | Debit | Credit |
|---|---|---|
| 08/01/2026 — Record the loan | ||
| Cash | $250,000.00 | |
| Notes payable | $250,000.00 | |
| Totals | $250,000.00 | $250,000.00 |
| 09/01/2026 — Payment #1 (each regular payment follows its row on the schedule) | ||
| Interest expense | $1,354.17 | |
| Notes payable | $226.00 | |
| Cash | $1,580.17 | |
| Totals | $1,580.17 | $1,580.17 |
| 08/01/2033 — Final payment + balloon (payment #84) | ||
| Interest expense | $1,226.30 | |
| Notes payable | $226,394.52 | |
| Cash | $227,620.82 | |
| Totals | $227,620.82 | $227,620.82 |
What this does
A balloon loan borrows the payment from a long loan — say 30 years — but makes the whole remaining balance due much sooner, like year 5 or 7. This shows the regular payment, how big the balloon is, the day it lands, and what you pay in interest before then.
It's common in commercial real estate, seller financing, and some business loans. It's not a trick, but it is a date you want circled on the calendar.
How the math works
The regular payment is the normal level payment for the full amortization term:
Payment = P × r ÷ (1 − (1 + r)^−n) (n = amortization term in payments)
Then the schedule runs payment by payment — interest on the balance, the rest to principal — but stops at the balloon date. Whatever's left is the balloon, due with that last regular payment.
Pick "interest only" and every payment is just the interest, so the balloon is the entire original loan.
The balloon is big because early payments are mostly interest. On a 30-year amortization, seven years of payments only knock off a small slice of the principal.
Check my math: a worked example
Borrow $250,000 at 6.50%, amortized over 30 years, with the balloon due after 7 years (paid monthly).
- The payment is sized for 360 payments: $1,580.17.
- You make 84 payments, the last on 08/01/2033.
- Those payments cover $108,774.93 of interest and $23,959.35 of principal.
- The balloon is $226,040.65 — 90.42% of what you borrowed.
- So the check due on 08/01/2033 is $227,620.82 (the last regular payment plus the balloon).
For comparison, the same loan fully paid off over 30 years would cost $318,861.58 in interest. The balloon version costs less interest only because you hand back the principal sooner — you still need the cash (or a refinance) to do it.
These numbers come straight from the calculator using its example inputs — if the math ever changes, this example changes with it.
Mistakes I see a lot
- Planning to refinance without a backup. Rates and lending standards can change a lot in 5–7 years.
- Forgetting the last regular payment is due on top of the balloon.
- Booking a balloon due within 12 months as long-term debt. Once it's due within a year, it's a current liability.
- Comparing the payment to a regular loan's and calling it cheaper. The payment matches a 30-year loan; the difference is the big check at the end.
Questions people ask
- Is the balloon paid on the same day as the last payment?
- Here, yes — the balloon is due with the last regular payment, which is how most balloon notes read. Check your note; some state a separate maturity date.
- Why is interest-only's balloon the entire loan?
- Interest-only payments never touch principal, so after the last one you still owe exactly what you borrowed.
- What happens if I can't pay the balloon?
- Usually you refinance, sell the asset, or negotiate an extension with the lender. Missing it is a default, so start working on it a year or more ahead.
- Does the spreadsheet recalculate?
- Yes. The payment, the schedule, the balloon, the annual summary, and the journal entries are all formulas off the Inputs sheet.
Assumptions and limits
- The regular payment is sized as if the loan ran the full amortization term (or is interest only, if you pick that).
- The balloon is whatever principal is left after the last regular payment, due on that same date. The final check is that payment plus the balloon.
- Fixed rate; the payment and each period's interest are rounded to the cent, like a lender.
- Payments are end-of-period. The first one is one period after the loan starts unless you enter a date.
- No refinancing, extension, fees, or prepayment penalties — how you'll pay the balloon is up to you (and worth planning early).
Disclaimer: Educational and planning use only. Results depend on what you enter and may not match your lender, your tax return, or professional accounting treatment. Informational content + opinions only — not tax/legal advice.