Why Early Settlement Needs Its Own Calculation
Paying off a loan before its final scheduled payment can eliminate future installments, but the amount due is not necessarily just the outstanding principal. A contract may add a prepayment penalty, a fixed administrative charge, or both. Interest may also have accrued since the most recent installment date. The settlement calculation therefore depends on the date, the loan’s balance at that date, and the exact wording of the penalty provision.
A useful comparison is between the settlement amount paid now and the value, at the same date, of continuing the scheduled payments. The comparison must use a stated valuation rate. At the contractual loan rate, the outstanding balance at a payment date equals the present value of the remaining installments. A penalty increases the payoff above that equivalent value. At a different valuation rate, the comparison can change.
Balance, Penalty, and Settlement Amount
Suppose a loan has level end-of-period payments of \(R\), an effective rate \(i\) per payment period, and \(m\) payments remaining. Immediately after an installment date, the balance on a fully amortizing loan is the present value of those remaining payments. If the contract specifies a penalty \(P\) and a separate fee \(F\), then the settlement amount at that date is
where \(B\) is the balance on the settlement date. If a quoted balance already includes accrued interest or a fee, that component must not be added again.
Penalty terms vary. For example, a contract might charge a fixed amount, a percentage of the balance, or the lesser of a percentage and a stated cap. The penalty base might be the principal balance, the balance including accrued interest, or another amount defined in the contract. Always translate the contract into a calculation before substituting numbers.
Why the Balance Equals the Value of the Remaining Payments
The balance formula is an equation of value: the balance at the settlement date is equivalent, at the contractual loan rate, to the future installments. This explains why a comparison must put both choices at the same date and use a consistent valuation rate.
There are \(m\) installments remaining, paid at the ends of periods 1 through \(m\).
At effective rate \(i\) per period, the present value of the payment at time \(k\) is \(R(1+i)^{-k}\).
The sum is \(R\sum_{k=1}^{m}(1+i)^{-k}=R a_{\overline{m}|}\), which is the outstanding balance when the loan is amortized according to those payments.
Thus, with no penalty or additional charge, paying the balance now and continuing the scheduled payments have equal value at the contractual rate. If a penalty is added, the settlement amount exceeds that balance by the penalty and any other charges. This equivalence does not mean that early payoff is always the cheaper choice: if the borrower uses a different opportunity or comparison rate, the value of the future payments may differ.
Worked Example: Percentage Penalty at an Installment Date
A hypothetical loan is repaid by six end-of-month installments of $1,000. Its effective monthly interest rate is 1%, equivalent to a nominal annual rate of 12% convertible monthly. Immediately after the second installment, the borrower settles the loan. The contract charges a penalty of 3% of the outstanding balance and no other fee. Find the settlement amount and compare it with the value of continuing the installments at the contractual rate.
Method. Find the balance immediately after the second installment by valuing the four remaining installments. Then apply the penalty to that balance. This avoids applying the penalty to the original loan amount.
The discount factor per month is \(v=1/1.01\). Four payments remain, so
The penalty is 3% of the balance:
Therefore the settlement amount is
At the contractual monthly rate, the value of continuing the four installments is \(1{,}000a_{\overline{4}|}=\$3{,}901.97\). The settlement is $117.06 higher, exactly the penalty after rounding. The calculation checks because the difference between the settlement and the continuation value is the specified penalty.
Settling Between Installment Dates
A settlement between installments may require interest to accrue from the last installment date to the settlement date. The accrual convention must come from the loan terms. For example, a contract may specify simple prorating within a payment period, a fractional-period compound factor, or a particular day-count convention. These are not interchangeable.
Once the accrued balance is determined under the stated convention, apply the penalty to the base specified in the contract. For a fair comparison, value all future installments at the settlement date using the same time convention and an explicitly stated comparison rate.
Worked Example: Settlement Partway Through a Monthly Period
Immediately after an installment, a hypothetical loan has eight monthly payments of $1,000 remaining, with an effective monthly rate of 1%. Settlement occurs 20 days into a 30-day payment period. The contract uses fractional-period compound interest at the monthly rate and charges a penalty of 2% of the balance including accrued interest. There are no other fees. Find the settlement amount and compare it with the value of continuing the eight payments at the contractual rate.
Method. First value the eight installments immediately after the last payment. Accumulate that balance for \(20/30\) of a month. Then calculate the penalty on the accrued balance. The next installment is due 10 days after settlement, so the remaining payments occur at settlement-relative times \(1/3, 1+1/3,\ldots,7+1/3\) months.
The balance immediately after the last installment is
Accruing for \(2/3\) of a month gives
The penalty is 2% of this accrued balance:
The settlement amount is therefore \(7{,}702.60+154.05=\boxed{\$7{,}856.65}\), rounded to the nearest cent. To check the comparison, discount the eight scheduled payments to the settlement date. Their value is
This equals the accrued balance before the penalty, as expected under the specified fractional-period compound model. The settlement exceeds the continuation value by the penalty. The check would not hold automatically under a different accrual convention.
Penalty Caps and Alternative Comparisons
Some contracts cap a percentage penalty. If the rule is “the lesser of \(p\) times the balance or a cap \(C\),” calculate both candidates and select the smaller. Do not assume that a cap is an additional charge or that it replaces the balance. The settlement remains the balance plus the penalty selected under the contract.
The contractual rate is useful for checking the balance against the scheduled payments. A separate economic comparison can use another rate \(j\), representing the borrower’s stated comparison basis. At a payment-date settlement, if payments \(R_k\) remain due at times \(k\), their value at that rate is \(\sum_k R_k(1+j)^{-k}\). Compare this value with the settlement amount, both measured at the same date. A result based on one valuation rate should not be presented as though it holds for every rate.
Worked Example: Applying a Capped Penalty
A hypothetical loan has 12 monthly payments of $1,800 at an effective monthly rate of 1%. Immediately after the fifth installment, seven payments remain. The contract charges the lesser of 2.5% of the outstanding balance or 1.5 monthly payments. There are no other fees. Find the balance, penalty, and settlement amount, and check the continuation value at the contractual rate.
Method. Value the seven remaining installments, calculate both penalty candidates, and apply the lesser-of rule. This avoids treating the cap as an amount to add on top of the percentage penalty.
The balance is
The percentage candidate is \(0.025(12{,}110.7503)=\$302.7688\). The cap is \(1.5(1{,}800)=\$2{,}700\). The lesser amount is the percentage candidate, so the penalty is $302.77. The settlement amount is
The value of continuing the seven payments at the contractual rate is \(1{,}800a_{\overline{7}|}=\$12{,}110.75\). The settlement exceeds it by $302.77, matching the penalty. All dollar amounts are rounded only at the final step.
Common Mistakes and a Reliable Checklist
A frequent error is to calculate a penalty from the original amount borrowed rather than the contractually specified base on the settlement date. Another is to add accrued interest to a balance that already includes it. Either mistake can materially overstate the amount due. A further trap is to compare a settlement today with the undiscounted sum of future installments; those cash flows occur at different times and cannot be compared directly.
Before calculating, identify the settlement date, the balance on that date, the interest-accrual convention, the penalty base and rule, any separate fees, and the rate used to value continued payments. The calculation is aligned with the SOA Exam FM (Financial Mathematics) syllabus.
Check Your Understanding
For each problem, treat the stated contract terms as complete and assume no fees other than those specified.
- A loan balance immediately after an installment is $4,000. The contract charges 2% of this balance plus a fixed $35 fee. Find the settlement amount. (Answer: $4,115.00)
- A loan balance immediately after an installment is $6,000. The effective monthly rate is 0.5%, interest accrues by simple prorating over a 30-day month, and settlement is 15 days later. The penalty is 1% of the balance including accrued interest. Find the settlement amount. (Answer: $6,075.15)
- Four monthly payments of $900 remain at an effective monthly rate of 1%. The penalty is 2% of the balance immediately after an installment. Find the balance and settlement amount. (Answer: Balance $3,511.77; settlement $3,582.00)
- Five quarterly payments of $500 remain at an effective quarterly rate of 2%. The penalty is the lesser of 4% of the balance or one scheduled payment. Find the settlement amount. (Answer: $2,451.00)
- Five monthly payments of $1,000 remain. The payoff amount is $4,800, and the comparison rate is 1% effective monthly. Compare paying off now with continuing the payments, using the value at the current date. (Answer: The payments have a value of $1,000a_{\overline{5}|}=\$4,853.43, so paying off now costs $53.43 less on this comparison basis.)