Why a Balloon Payment Needs a Precisely Timed Balance
A balloon payment is a final payment that clears the remaining loan balance at a specified date. The amount depends not only on the interest rate and earlier payments, but also on the exact point in the payment sequence when the balance is measured. If an ordinary installment is due on the balloon date, decide whether it is paid before the balloon; omitting or double-counting that installment changes the answer.
This tutorial uses two equivalent methods: accumulate the loan and subtract accumulated payments, or value the payments still due at the balloon date. Both methods require the same interest assumptions and payment timing. All examples assume that payments are credited immediately when made, there are no fees or penalties, and the stated rates apply over the stated periods.
Two Equivalent Ways to Find the Balloon
First fix the timing convention. Let \(L\) be the original loan at time 0, and let \(C_k\) be a payment made at time \(t_k\). Suppose the effective annual rate during year \(j\) is \(i_j\). Define \(A(s,t)\) as the accumulation factor from time \(s\) to time \(t\); for integer-year dates, it is the product of the annual accumulation factors in the intervening years. For example, \(A(0,3)=(1+i_1)(1+i_2)(1+i_3)\).
Let \(B_T^+\) denote the balance immediately after all ordinary payments due at \(T\) have been credited. The retrospective balance equation is:
The sum includes payments made exactly at \(T\). Each such payment has accumulation factor \(A(T,T)=1\), so it is subtracted once, without interest. If the balloon is paid after those ordinary payments, the balloon equals \(B_T^+\).
The prospective method instead values the remaining payments at time \(T\). If the payments still due after the ordinary installment at \(T\) are \(D_r\) at times \(u_r>T\), then:
If the balloon itself is the only payment still due, the prospective value is simply the balloon. If a scheduled installment is due at \(T\), it is not part of the post-installment prospective balance: it has already been paid. To value the debt immediately before that installment, include it in the prospective sum.
Why the Two Balance Methods Agree
The retrospective formula follows from carrying each transaction to the same date. The original loan grows from time 0 to \(T\); a payment made at \(t_k\) reduces the balance then, and the reduction accumulates only from \(t_k\) to \(T\). Subtracting every such accumulated reduction leaves the amount owed just after payments at \(T\).
The prospective formula is equivalent because the amount remaining at \(T\) is exactly the value at \(T\) of the future payments that discharge the debt. To see the equivalence in a constant-rate model, let \(v=1/(1+i)\), and suppose all payments are at integer-year dates. The loan equation at time 0 is \(L=\sum_k C_kv^{t_k}+B_T^+v^T\), where payments through \(T\) include any installment due at \(T\). Multiply by \((1+i)^T\): the terms for payments through \(T\) become \(C_k(1+i)^{T-t_k}\), and the balloon becomes \(B_T^+\). Rearranging gives the retrospective equation. Thus both methods express the same cash flows at a common date.
State whether an ordinary installment at \(T\) is credited before the balloon. Use “before” and “after” consistently.
For a retrospective calculation, carry the loan and each payment to \(T\). For a prospective calculation, value payments remaining after the point in the payment sequence being considered.
With changing rates, accumulate each cash flow only over the years after its date, applying each year’s rate in sequence.
Confirm that a payment at \(T\) is included exactly once, then compare the balance with the value of the remaining cash flows at \(T\).
Worked Calculations
The examples use annual effective rates and year-end payments. Amounts are carried without intermediate rounding and reported to the nearest cent.
Worked Example: Balloon Added After the Final Scheduled Installment
A loan of $15,000 charges an effective annual interest rate of 8%. The borrower makes scheduled payments of $4,000 at the ends of years 1, 2, and 3. Immediately after the year-3 installment is credited, the borrower pays a balloon that clears the loan. Find the balloon. Assume no other transactions.
Method. Use the retrospective balance just after the year-3 installment. The payment at year 3 is included because it is credited before the balloon.
Accumulate the loan: \(15{,}000(1.08)^3=15{,}000(1.259712)=18{,}895.68\).
Accumulate the year-1 payment two years: \(4{,}000(1.08)^2=4{,}000(1.1664)=4{,}665.60\). Accumulate the year-2 payment one year: \(4{,}000(1.08)=4{,}320.00\). The year-3 payment is already at the valuation date, so its value is $4,000.00.
Check and trap avoided. The original loan equation is \(15{,}000=4{,}000v+4{,}000v^2+(4{,}000+B_3^+)v^3\), where \(v=1/1.08\). Multiplying through by \(1.08^3\) reproduces the balance equation above. The balloon is $5,910.08. Excluding the year-3 installment would overstate it by $4,000.
Worked Example: Unequal Payment Dates and an Installment on the Balloon Date
A $12,000 loan earns an effective annual rate of 5%. Payments of $3,000 at year 1 and $2,000 at year 3 have been credited. At year 4, an ordinary $1,000 installment is due and will be credited before the balloon. Find the balloon paid immediately after that installment. Assume no other payments.
Method. Accumulate each transaction to year 4. The payment dates are not equally spaced, so use each payment’s actual time from year 4.
The original loan accumulates for four years:
The year-1 payment accumulates for three years: \(3{,}000(1.05)^3=3{,}000(1.157625)=3{,}472.875\). The year-3 payment accumulates for one year: \(2{,}000(1.05)=2{,}100\). The year-4 installment is subtracted at its payment-date value, $1,000.
Check and trap avoided. At year 4, the balance just before the ordinary installment is $9,013.20. Crediting the installment leaves \(9{,}013.20-1{,}000=8{,}013.20\), which is the balloon. A common wrong calculation sums only payments with \(t_k<4\); that gives $9,013.20 and mistakenly reports the pre-installment balance as the balloon. The required balloon is $8,013.20.
Worked Example: Balloon Under Changing Annual Rates
A $10,000 loan earns 6% effective interest in year 1 and 8% effective interest in each of years 2 and 3. Payments of $2,000 at the end of year 1 and $1,000 at the end of year 2 are credited. There is no scheduled installment at year 3; the borrower pays a full payoff balloon then. Find the balloon. Assume the stated rates apply only to their specified years.
Method. Accumulate the balance year by year. A payment reduces the balance at its stated date, so it earns no interest for earlier periods and accrues interest only in later years.
At the end of year 1, before the payment, the debt is \(10{,}000(1.06)=10{,}600\). After the $2,000 payment, the balance is \(10{,}600-2{,}000=8{,}600\).
During year 2, that balance grows at 8% to \(8{,}600(1.08)=9{,}288\). After the $1,000 payment, the balance is \(9{,}288-1{,}000=8{,}288\).
During year 3, the balance grows at 8% to \(8{,}288(1.08)=8{,}951.04\). Therefore, the required balloon is $8,951.04.
Check and trap avoided. The retrospective calculation is \(10{,}000(1.06)(1.08)^2-2{,}000(1.08)^2-1{,}000(1.08)=8{,}951.04\). The year-1 payment accrues at 8% for years 2 and 3; the year-2 payment accrues at 8% for year 3 only. Applying those later rates to the original loan, but not to the prior payments, would overstate the balance.
Common Timing and Modeling Errors
Most errors in balloon problems come from a mismatch between the balance definition and the cash-flow equation. Before calculating, identify whether the balloon is paid before or after any ordinary installment at the same date. If the installment is credited first, include it in the retrospective subtraction and leave it out of the prospective sum of payments still due.
- Dropping a payment at \(T\). A sum over payments with \(t_k<T\) describes a balance before the payment at \(T\), not after it. Use \(t_k\leq T\) for the post-installment balance.
- Counting the same installment twice. Do not subtract an installment at \(T\) and also include it as a future payment in a post-installment prospective balance.
- Giving a payment the wrong accumulation period. A payment at \(t_k\) accumulates from \(t_k\) to \(T\), not from time 0. Under changing rates, use only the rates that apply after \(t_k\).
- Mixing dates in an equation of value. Accumulate or discount every amount to one common date before adding or comparing it.
Check Your Understanding
For each problem, assume no fees or other transactions and use the stated effective rates. Round dollar amounts to the nearest cent.
- A $5,000 loan earns 5% effective interest annually. A $1,000 payment is credited at the end of year 1; the full payoff balloon is due at the end of year 2. Find the balloon. (Answer: $4,462.50)
- A $6,000 loan earns 4% annually. Payments of $1,000 at year 1 and $600 at year 2 are credited; the year-2 payment is made before the balloon. Find the balloon immediately after that payment. (Answer: $4,849.60)
- A $9,000 loan earns 3% in year 1 and 5% in year 2. A $1,500 payment is credited at the end of year 1, and the balloon is due at the end of year 2. Find the balloon. (Answer: $8,158.50)
- A $7,000 loan earns 6% effective interest annually. Payments of $1,200 at year 1 and $800 at year 2 are credited, and the balloon is due at year 3. Find the balloon. (Answer: $6,140.79)
- A $10,000 loan earns 5% annually. Payments of $2,000 at year 1 and $1,000 at year 2 are credited, with the year-2 payment made before the balloon. Find the balloon. State the error in excluding the year-2 payment from the balance calculation. (Answer: $7,925.00; excluding it gives the pre-installment balance, $8,925.00.)