Calculating a Balloon Balance at Maturity

What a Balloon Balance Measures

A loan may have installments that do not fully repay it by its contractual maturity. The unpaid amount at that date is the balloon balance. It is not necessarily a separate charge or a newly calculated loan: it is the residual obligation left after the loan proceeds and all payments have been valued at the maturity date.

To calculate that residual, keep the loan’s interest rate, payment dates, and contractual maturity fixed. The payment amounts may vary: a borrower might make an extra principal payment, pay different installments after a change, or make a final installment smaller than the amount needed to clear the loan. The key is to account for interest on each amount for the correct length of time.

Definition: Suppose a loan advances principal $L$ at time 0, has a constant effective interest rate $i$ per payment period, and matures after $n$ periods. Let $C_k$ be the total payment made at the end of period $k$, including any extra principal payment on that date. Assuming no fees or other cash flows, the balloon balance $B_n$ is the residual amount owed immediately after the payment at maturity: $$ B_n=L(1+i)^n-\sum_{k=1}^{n}C_k(1+i)^{n-k}. $$

This model treats each payment as occurring at the end of a period. If there is no payment in a period, use $C_k=0$; if an installment and an extra payment occur on the same date, add them to form $C_k$. A payment at maturity is included and therefore reduces the balance dollar for dollar at that date. The formula assumes the same rate applies throughout the loan and that all dates are expressed in the matching period units.

Why the Accumulation Formula Works

At maturity, the original loan would have grown to $L(1+i)^n$ if no payments had been made. A payment $C_k$ made at the end of period $k$ would have grown to $C_k(1+i)^{n-k}$ by the end of period $n$. Subtracting the maturity-date value of every payment from the maturity-date value of the original loan leaves exactly the amount still owed.

\text{maturity value of loan} - \text{maturity value of payments} = \text{residual at maturity}.

The same result follows from a balance recurrence. If $B_0=L$, then immediately after payment $k$,

B_k=B_{k-1}(1+i)-C_k.

Repeatedly substitute this recurrence. The first balance becomes $B_1=L(1+i)-C_1$; the next is $B_2=L(1+i)^2-C_1(1+i)-C_2$. Continuing through period $n$ gives $B_n=L(1+i)^n-\sum_{k=1}^{n}C_k(1+i)^{n-k}$, as stated. This also provides a practical independent check on a calculation.

Important: The balloon is the residual after the maturity-date payment. If the contract calls for a final regular installment and a separate balloon payment, include the regular installment among the $C_k$ values first; the residual is the additional amount needed to clear the loan.

Calculating a Balloon After an Extra Payment

First combine payments made on the same date. Then either accumulate every cash flow to maturity or update the balance period by period. The accumulation approach is compact for an equation of value; the recurrence approach makes the changing balance visible.

Worked Example: An Extra Principal Payment Before Maturity

A borrower receives a loan of $10,000. The effective annual interest rate is 10%, and the loan matures at the end of year 3. The borrower pays $3,000 at the end of each of years 1, 2, and 3, and also makes an extra $500 principal payment at the end of year 2. Find the balloon balance immediately after the year-3 installment.

Method: accumulate all cash flows to maturity. The annual rate and annual payment dates match, so $i=0.10$, $n=3$, and the period-end payments are $C_1=3000$, $C_2=3500$, and $C_3=3000$. The extra payment is combined with the year-2 installment.

Accumulate the original loan for three years:

$$ 10000(1.10)^3=10000(1.331)=13310. $$

Accumulate each payment from its payment date to year 3:

\begin{aligned} C_1(1.10)^{3-1}&=3000(1.21)=3630,\\ C_2(1.10)^{3-2}&=3500(1.10)=3850,\\ C_3(1.10)^{3-3}&=3000(1)=3000. \end{aligned}

The maturity value of all payments is $3630+3850+3000=10480$. Therefore,

$$ B_3=13310-10480=2830. $$

Check by recurrence. After year 1, the balance is $10000(1.10)-3000=8000$. After year 2, it is $8000(1.10)-3500=5300$. After year 3, it is $5300(1.10)-3000=2830$. The recurrence agrees, so the balloon balance is $2,830.00.

Common mistake avoided: subtracting the payments from the original principal without allowing for interest would give $10000-3000-3500-3000=500$. That is not the maturity balance: it ignores interest accruing on the unpaid loan and on earlier payments before maturity.

Unequal Installments and Changed Payment Amounts

A payment schedule does not need to be level. Once every cash flow is assigned to its correct date, the same equation applies. A changed installment is entered at its actual amount, and any extra payment on that date is added to it. The original contractual maturity remains the valuation date in this calculation.

Worked Example: Installments Change During the Loan

A loan of $20,000 carries an effective annual rate of 5% and has a four-year contractual term. Payments are $6,000 at the end of years 1 and 2, then $4,000 at the end of years 3 and 4. In addition, the borrower pays $1,000 extra at the end of year 2. Calculate the balloon due after the scheduled year-4 payment.

Method: value every payment at year 4. The year-2 cash flow is $6000+1000=7000$, so the payment sequence is $C_1=6000$, $C_2=7000$, $C_3=4000$, and $C_4=4000$. Here $L=20000$, $i=0.05$, and $n=4$.

The original principal accumulated to year 4 is

$$ 20000(1.05)^4=20000(1.21550625)=24310.125. $$

The four payments accumulated to year 4 are

\begin{aligned} 6000(1.05)^3&=6000(1.157625)=6945.75,\\ 7000(1.05)^2&=7000(1.1025)=7717.50,\\ 4000(1.05)&=4200,\\ 4000(1)&=4000. \end{aligned}

Their total maturity value is $6945.75+7717.50+4200+4000=22863.25$. Thus,

$$ B_4=24310.125-22863.25=1446.875. $$

Check by recurrence. After year 1, the balance is $20000(1.05)-6000=15000$. After year 2, it is $15000(1.05)-7000=8750$. After year 3, it is $8750(1.05)-4000=5187.50$. After year 4, it is $5187.50(1.05)-4000=1446.875$. The results agree; rounded to cents only at the final step, the balloon is $1,446.88.

Common mistake avoided: treating the extra $1,000 as if it were paid at year 4 would understate its effect. A year-2 payment reduces the year-4 obligation by its accumulated value, $1000(1.05)^2=$1,102.50$, not by just $1,000.

Match the Rate to the Payment Period

The exponent counts periods at the rate used in the formula. If payments are semiannual, for example, the rate in the recurrence must be the effective rate per half-year, not an annual rate applied once per payment. When a nominal rate is quoted with a compounding frequency matching the payment frequency, divide by that frequency to obtain the periodic rate.

Worked Example: Semiannual Payments at a Nominal Rate

A $30,000 loan has a nominal annual rate of 6% convertible semiannually and a contractual maturity of three years. The borrower pays $6,000 at the end of each of the first two half-years, $5,000 at the end of each of the next two half-years, $2,000 at the end of the fifth half-year, and $7,000 at maturity. Find the balloon balance after the final payment.

Method: use the half-year balance recurrence. The nominal rate is convertible twice per year, so the effective rate per half-year is $i^{(2)}/2=0.06/2=0.03$. Three years contain $n=6$ half-year periods. The payments, in order, are $C_1=6000$, $C_2=6000$, $C_3=5000$, $C_4=5000$, $C_5=2000$, and $C_6=7000$.

Apply $B_k=B_{k-1}(1.03)-C_k$ at each date:

\begin{aligned} B_1&=30000(1.03)-6000=24900,\\ B_2&=24900(1.03)-6000=25647-6000=19647,\\ B_3&=19647(1.03)-5000=20236.41-5000=15236.41,\\ B_4&=15236.41(1.03)-5000=15693.5023-5000=10693.5023,\\ B_5&=10693.5023(1.03)-2000=11014.307369-2000=9014.307369,\\ B_6&=9014.307369(1.03)-7000=9284.73659007-7000=2284.73659007. \end{aligned}

The balance is positive after the final $7,000 payment. Rounding only the final result to cents gives a balloon of $2,284.74.

Common mistake avoided: using 6% as the rate for each half-year would overstate the interest. The quoted nominal annual rate converts to 3% per half-year, and there are six—not three—payment periods. As a check, the final recurrence uses the year-3 balance before payment, $9014.307369(1.03)=9284.73659007$, then subtracts the maturity payment of $7,000.

Interpretation and Exam Traps

A positive $B_n$ is the additional amount required at maturity to clear the obligation under the stated assumptions. If $B_n=0$, the payments exactly amortize the loan by maturity. If $B_n<0$, the assumed payments exceed the amount needed to repay it; this signals an overpayment or an inconsistent payment schedule, rather than a positive balloon due from the borrower.

A reliable calculation keeps three details explicit: the date each payment occurs, the rate per period, and whether the final scheduled payment has already been subtracted. For a payment $C_k$ at the end of period $k$, the exponent to maturity is $n-k$, not $n-k+1$. At maturity the exponent is zero because the payment does not earn interest after it is made.

These calculations are aligned with the SOA Exam FM (Financial Mathematics) syllabus. On an exam-style problem, a useful final check is to compute the balance both by accumulation to maturity and by the period-by-period recurrence whenever time permits.

Check Your Understanding

For each problem, calculate the residual immediately after the payment at the stated maturity. Use the stated effective rate per payment period.

A $5,000 loan accrues interest at an effective annual rate of 4% for three years. Payments of $1,800 are made at the end of years 1 and 2, and $1,000 at the end of year 3. Find the balloon. (Answer: $805.44)
A $12,000 loan has an effective quarterly rate of 2% and matures after four quarters. The borrower pays $2,500 at the end of each quarter and an additional $400 at the end of quarter 2. Find the balloon after the quarter-4 payment. (Answer: $2,269.01)
A $18,000 loan has an effective annual rate of 5% and a three-year term. Payments are $5,000 at the end of year 1, $6,000 at the end of year 2, and $5,000 at the end of year 3. Find the balloon. (Answer: $4,024.75)
A $25,000 loan accrues interest at an effective annual rate of 4% for five years. Payments are $6,000 at the end of years 1 and 2, followed by $4,500 at the end of each of years 3, 4, and 5. Calculate the balloon after the final installment. (Answer: $2,600.79)

What You'll Learn