Balloon Loan Calculator
Monthly payment and final balloon payment from price, down payment, fees, residual value, APR and term.
| Month | Payment | Principal | Interest | Balance |
|---|
Formulas:
- Amount financed:
price + fees − down payment. - Monthly payment:
PMT = (financed − residual × (1 + r)−n) × r / (1 − (1 + r)−n)(r = APR / 12,n = term in months; atr = 0,(financed − residual) / n). - Final balloon payment:
PMT + residual. Total cost:PMT × n + residual. Total interest:total cost − financed. - Versus full amortization: monthly
fullPMT − PMT, interestballoon interest − full interest.
How a balloon loan works
What the residual value is
The residual is the contracted value of the asset at the end of the term, fixed by the lender up front. Because you only amortize financed − residual, the monthly payment is lower than a plain amortizing loan. At the end you either pay the residual in one balloon payment, refinance it, or return the asset (common with car residual-value plans such as Japan's zanka-settei loans). On new cars over 5 years the residual typically lands at 30–50% of the price; used cars and longer terms get lower residuals.
Lower monthly, higher total — always
Because principal retires slower, a balloon loan always accrues more interest than a full amortization at the same rate and term. Financed $31,900 at 5.5% for 60 months with a $10,500 residual: $456.89 a month (versus $609.33 fully amortizing), but total interest $6,013.39 versus $4,659.62 — a $1,353.77 premium. Decide with both numbers in front of you, not just the monthly.
Your three options at the end of the term
(1) Pay the balloon in cash and keep the asset, (2) refinance the residual into a new loan, or (3) return the asset and walk away (then excess mileage or damage charges may apply). Read the residual and the return conditions before signing — the residual is fixed in the contract, but condition and mileage clauses decide what returning really costs.
Reading the schedule
Each month: interest = starting balance × (APR / 12); principal = monthly payment − interest; balance = previous balance − principal. The final month adds the residual to the payment and the balance drops to zero — the balance line in the chart falls off a cliff at month n. That cliff is the balloon.
Balloon loan math in Excel and on the TI-84
Put the residual in the future-value slot of the PMT function:
- Excel monthly payment: financed $31,900, residual $10,500, 5.5% APR, 60 months →
=PMT(5.5%/12, 60, -31900, 10500)= $456.89. - Excel total cost and interest:
=PMT(5.5%/12, 60, -31900, 10500)*60 + 10500= $37,913.39; subtract the financed amount for total interest $6,013.39. - TI-84 TVM Solver:
APPS→1:Finance…→1:TVM Solver…, enterN = 60,I% = 5.5,PV = -31900,FV = 10500,P/Y = 12,C/Y = 12, solvePMTwithALPHA ENTER(SOLVE) → -456.89 (negative because it is an outflow). - Comparison (full amortization): set
FV = 0and re-solve → -609.33. The $152.44 gap is what the balloon trims off each month.
Worked examples
Example 1: $35,000 car, $3,500 down, $400 fees, $10,500 residual (30%), 5.5% APR, 60 months
price = 35000, downPayment = 3500, fees = 400, residual = 10500, apr = 5.5, months = 60. Financed: $31,900. Monthly payment: $456.89, final balloon: $10,956.89, total interest: $6,013.39, total cost: $37,913.39. Fully amortizing: $609.33 monthly, $4,659.62 interest — the balloon is $152.44 lighter per month, $1,353.77 heavier overall.
Example 2: 50% residual, no fees, 6.9% APR, 72 months
Financed: $31,500 with a $17,500 residual. residual = 17500, apr = 6.9, months = 72. Monthly payment: $338.64, final balloon: $17,838.64, total interest: $10,382.04, total cost: $41,882.04. Full amortization would run $535.53 a month with $7,058.33 interest — raising the residual and stretching the term roughly doubles the interest premium.
Example 3: 0% promotion with a balloon, 60 months
apr = 0: the payment degenerates to (financed − residual) / n = (31,500 − 10,500) / 60 = $350.00. Final balloon: $10,850.00, total interest: $0, total cost: $31,500.00 — exactly the amount financed. With no interest, a balloon is purely a postponement of cash.
Related tools
The balloon loan calculator answers "what do I pay monthly and at the end?" Related questions:
- "I want a plain car loan with tax, trade-in and fees" — the Auto Loan Calculator builds the financed amount from tax, trade-in equity, negative equity and fees, then amortizes it fully.
- "I'd rather save up the balloon instead of refinancing it" — the Savings Goal Calculator works backwards from the balloon amount to a monthly saving.
- "Compare full amortization shapes" — the Loan Calculator (equal payments) and Fixed-Principal Loan Calculator show the two non-balloon alternatives.
FAQ
How is the monthly payment of a balloon loan calculated?
Compute financed = price + fees − down payment, then PMT = (financed − residual × (1 + r)−n) × r / (1 − (1 + r)−n) with r = APR / 12 and n = months. At r = 0 it is (financed − residual) / n. The final payment adds the residual on top of the monthly payment.
Balloon loan or full amortization — which is cheaper?
On total cost, full amortization always wins at the same rate and term, because principal retires faster. The balloon loan trades a lower monthly payment for higher total interest. Compare both numbers — this tool prints the difference automatically.
What happens at the end of a balloon loan?
Three usual options: pay the residual in cash and keep the asset, refinance the residual, or return the asset (excess-mileage or damage charges may apply). The residual is fixed in the contract — check the return conditions before signing.
What if the residual equals or exceeds the amount financed?
The payment would be zero or negative, so there is nothing to amortize — this calculator shows an error. Keep the residual below the amount financed.
What does the total cost include?
Monthly payment × term + residual (the final balloon). It includes principal and interest. Insurance, taxes, maintenance, and any end-of-term settlement charges are not included.