Tutorials › Exam FM - Financial Mathematics › Shortening a Loan Term With Extra Principal

Exam FM · Loan Changes and Refinancing · Tutorial 310 of 998

Shortening a Loan Term With Extra Principal

Use the post-prepayment balance and unchanged installment to find the shortened loan term and calculate any smaller final payment.

Intermediate 9 min read

What You'll Learn

  • Set up the loan model and verify that the fixed installment will amortize the post-prepayment balance.
  • Derive the theoretical remaining term from the level-payment present-value equation.
  • Convert a fractional theoretical term into the number of full installments and the final-payment date.
  • Calculate the final payment from the balance immediately after the last full installment.
  • Check the result with a balance recurrence and recognize when no finite payoff term exists.

Why an Extra Principal Payment Shortens the Term

A borrower may make a lump-sum principal payment but keep the regular installment unchanged. The balance then falls, while each future installment continues to make the same scheduled payment. If the installment is large enough to cover interest and repay principal, the loan is paid off sooner than originally scheduled. The key is to calculate the term from the balance remaining after the lump sum, not from the original balance.

This tutorial assumes a standard discrete-payment loan: interest is charged once per payment period at a constant effective rate, and installments are made at the ends of periods. The lump-sum principal payment is made immediately after a scheduled installment, so no extra interest accrues between that installment and the lump sum. The regular installment remains fixed, and there are no fees, payment holidays, or changes to the interest rate.

Definition: Let \(B\) be the loan balance immediately after the lump-sum principal payment, \(R\) the fixed installment paid at each period-end, and \(j\) the effective interest rate per payment period. The theoretical remaining term is the real-valued number \(n\) satisfying \(B=R a_{\overline{n}|}\), using the standard level-payment present-value equation extended to a real term. The actual loan is settled on a scheduled payment date; if \(n\) is not an integer, the last payment is generally smaller than \(R\).

Deriving the Theoretical Remaining Term

For a positive periodic rate \(j\), the present value of \(n\) end-of-period installments of \(R\) is \(R a_{\overline{n}|}=R(1-v^n)/j\), where \(v=1/(1+j)\). Equating this present value to the post-prepayment balance gives the term equation.

$$ B=R\frac{1-(1+j)^{-n}}{j} $$

Rearranging first isolates the discount factor raised to \(n\); taking logarithms then gives the term directly.

$$ (1+j)^{-n}=1-\frac{jB}{R} \qquad\Longrightarrow\qquad n=\frac{-\ln\left(1-\frac{jB}{R}\right)}{\ln(1+j)} $$

This formula requires \(j>0\) and \(R>jB\). The second condition means the installment exceeds the first period’s interest, so the balance decreases. If \(R=jB\), each installment only covers interest and the principal does not decline. If \(R<jB\), the balance grows under the stated model. Neither case has a finite payoff term with the fixed installment. If \(j=0\), the separate formula is \(n=B/R\).

The logarithm returns a real-valued term, not necessarily a whole number of installments. When \(n\) is not an integer, the borrower does not make a fractional installment at a fractional date under this model. Instead, the final payment is made on the next scheduled due date after the last full installment.

From a Fractional Term to the Final Payment

Let \(k=\lfloor n\rfloor\), the greatest integer not exceeding \(n\). If \(n\) is not an integer, the borrower makes \(k\) full installments. To find the payoff amount, first calculate the balance immediately after installment \(k\), then accrue one period of interest to the next due date.

$$ B_k=B(1+j)^k-Rs_{\overline{k}|} =B(1+j)^k-R\frac{(1+j)^k-1}{j} $$
$$ F=(1+j)B_k $$

Here \(F\) is the final payment on due date \(k+1\). The balance formula follows by accumulating the original balance for \(k\) periods and subtracting each of the \(k\) installments accumulated to the same date. The final payment is then the balance after \(k\) installments plus one period’s interest. Under the conditions above, if \(k<n<k+1\), then \(0<F<R\). If \(n\) is an integer, the loan is instead paid by \(n\) full installments, with no additional smaller payment.

1
Establish the transaction-date balance.
Use the balance immediately after the lump-sum payment. If the balance just before that payment is known, subtract the amount applied to principal.
2
Check amortization.
Verify \(R>jB\). If this fails, the fixed installment does not produce a finite payoff under the model.
3
Find the theoretical term.
Use the logarithmic formula, or \(n=B/R\) if the periodic rate is zero.
4
Determine the payment count and final amount.
If \(n\) is fractional, make \(\lfloor n\rfloor\) full installments and calculate the final payment one period later from the remaining balance.

Worked Examples

Worked Example: Monthly Extra Principal Payment

Immediately after a monthly installment, a hypothetical loan has a balance of $14,500. The borrower pays an extra $2,500 directly toward principal on that date. The monthly installment remains $2,000, and the effective monthly interest rate is 1%. Find the theoretical remaining term, the number of full installments, and the final payment.

Method and balance. The extra payment reduces principal immediately, so the new balance is \(B=14{,}500-2{,}500=12{,}000\). Here \(j=0.01\) and \(R=2{,}000\). First-period interest is \(0.01(12{,}000)=120\), which is less than the installment, so the loan amortizes.

Theoretical term. Substitute into the term formula:

$$ n=\frac{-\ln(1-0.01(12{,}000)/2{,}000)}{\ln(1.01)} =\frac{-\ln(0.94)}{\ln(1.01)} \approx 6.218 $$

Thus, there are 6 full monthly installments, followed by a final payment on the 7th monthly due date.

Final payment. Using \(1.01^6\approx1.06152015\) and \(s_{\overline{6}|}=(1.06152015-1)/0.01\approx6.152015\), the balance just after the sixth full installment is

$$ B_6=12{,}000(1.06152015)-2{,}000(6.152015) =12{,}738.2418-12{,}304.0300 =434.2118 $$

Accrue one more month of interest: \(F=434.2118(1.01)=438.553918\), or $438.55 to the nearest cent. This is less than the scheduled $2,000 installment, as expected. The common mistake this method avoids is calculating the term from the $14,500 pre-lump-sum balance rather than the $12,000 post-payment balance.

Worked Example: Quarterly Payments and a Small Final Installment

A hypothetical loan has a balance of $15,000 immediately after an extra principal payment. The borrower will continue making quarterly installments of $2,600. The effective quarterly rate is 2%. Find the theoretical term and the actual payoff schedule.

Method and amortization check. The first quarter’s interest is \(0.02(15{,}000)=300\), less than the $2,600 installment. Therefore, the balance declines and a finite payoff is possible.

Theoretical term.

$$ n=\frac{-\ln(1-0.02(15{,}000)/2{,}600)}{\ln(1.02)} =\frac{-\ln(23/26)}{\ln(1.02)} \approx 6.191 $$

The borrower makes 6 full quarterly installments. The final payment is due on the 7th quarterly due date.

Final payment. Use \(1.02^6\approx1.12616242\) and \(s_{\overline{6}|}\approx(1.12616242-1)/0.02=6.308121\). The balance after the sixth installment is

$$ B_6=15{,}000(1.12616242)-2{,}600(6.308121) =16{,}892.4363-16{,}401.1146 =491.3217 $$

The amount due one quarter later is \(491.3217(1.02)=501.1481\), or $501.15 to the nearest cent. The result is a smaller final payment, not a seventh full $2,600 installment. The common mistake is to round 6.191 up to 7 and then assume all 7 payments have the regular amount.

Worked Example: Counting Full Payments Before the Final Payment

After a lump-sum principal payment, a hypothetical loan balance is $10,000. The fixed monthly installment is $1,100, and the effective monthly rate is 1%. Determine the remaining term and final payment.

Method and check. The first month’s interest is $100, which is less than the installment. The loan therefore amortizes. The theoretical term is

$$ n=\frac{-\ln(1-0.01(10{,}000)/1{,}100)}{\ln(1.01)} =\frac{-\ln(10/11)}{\ln(1.01)} \approx 9.578 $$

Since \(9<n<10\), there are 9 full installments, and the final payment is due on the 10th monthly due date. Using \(1.01^9\approx1.09368527\) and \(s_{\overline{9}|}\approx9.36852727\), the balance just after the ninth installment is

$$ B_9=10{,}000(1.09368527)-1{,}100(9.36852727) =10{,}936.8527-10{,}305.3800 =631.4727 $$

The tenth due-date payment is \(631.4727(1.01)=637.7874\), or $637.79 to the nearest cent. The total number of payment dates is 10, but only the first 9 payments are full installments. This distinction is important whenever the theoretical term is fractional.

Timing, Rounding, and Common Traps

The term formula depends on the payment schedule and transaction date. If the lump-sum payment is made between installment dates, the balance must first be valued on the lump-sum date, including any interest accrued to that date under the loan’s terms. A balance stated just after an installment cannot automatically be used for a payment made later in the period.

Keep the interest rate in the same time unit as the installments. For monthly payments, use the effective monthly rate; for quarterly payments, use the effective quarterly rate. An annual effective rate cannot be inserted as though it were a monthly rate. If only an annual effective rate is given, convert it consistently with the stated compounding convention before applying the formulas.

  • Using the original balance. The term after the extra principal payment is based on the reduced balance \(B\), not the balance before the lump sum.
  • Rounding the term too early. Keep adequate precision in \(n\) to identify \(\lfloor n\rfloor\), then use the balance recurrence to calculate the final payment.
  • Putting the final payment on the wrong date. A term such as \(6.218\) means 6 full payments and a payoff on the 7th due date, not a payment at 6.218 periods.
  • Accruing interest over the wrong number of periods. After the sixth payment, accrue the remaining balance for one period to find a payoff on the seventh due date.
  • Assuming any installment will eventually pay off the loan. If \(R\leq jB\), the balance does not decline under this fixed-payment model.

The same balance method also provides a useful check: after each full installment, calculate \(B_t=B_{t-1}(1+j)-R\). The final payment is the resulting balance after one more period of interest. This tutorial’s method is aligned with the SOA Exam FM (Financial Mathematics) syllabus.

Key takeaway: First reduce the balance by the lump-sum principal payment. Then solve \(B=R a_{\overline{n}|}\) for the theoretical term. If that term is fractional, make its integer part in full installments and pay the accrued remaining balance on the next scheduled due date.

Check Your Understanding

Assume each lump-sum payment is made immediately after a scheduled installment, and all stated rates are effective per payment period. Round dollar amounts to the nearest cent.

  1. A balance of $7,000 is repaid with installments of $1,500 at an effective monthly rate of 1%. Find the theoretical term, the number of full installments, and the final payment. (Answer: \(n\approx4.80\) months; 4 full installments, then $1,205.56 on the 5th due date.)
  2. A post-prepayment balance is $5,000. The fixed monthly installment is $1,000 and the effective monthly rate is 1%. Find the theoretical term and final payment. (Answer: \(n\approx5.15\) months; 5 full installments, then $155.59 on the 6th due date.)
  3. A loan balance after the extra principal payment is $8,000. The quarterly installment is $1,500 and the effective quarterly rate is 1.5%. Find the theoretical term and final payment. (Answer: \(n\approx5.60\) quarters; 5 full installments, then $903.22 on the 6th due date.)
  4. A loan balance is exactly \(1{,}000a_{\overline{5}|}\), with an effective annual rate of 2% and annual installments of $1,000 at year-end. How many installments are required? (Answer: exactly 5 annual installments of $1,000.)
  5. A balance of $4,000 is subject to an effective monthly rate of 1%, with a fixed monthly installment of $40. Does the loan have a finite payoff term under the stated model? (Answer: No. The first month’s interest is $40, so each installment covers interest only and does not reduce principal.)
Clinical Biostats