Tutorials › Exam FM - Financial Mathematics › Recasting an Existing Loan After a Rate Reset

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

Recasting an Existing Loan After a Rate Reset

Learn to value the loan balance at a rate reset and calculate the revised installment for the remaining payment dates.

Intermediate 12 min read

What You'll Learn

  • Identify the balance and remaining payment dates used in a rate-reset calculation
  • Calculate a revised level installment while retaining the original maturity
  • Derive the recast payment from the present value of the remaining installments
  • Check a revised schedule using its first-period interest and principal split
  • Avoid timing, rate-period, and rounding errors when recasting a loan

What a Rate Reset Changes

When an existing loan’s interest rate changes, the installment that was calculated using the old rate will generally no longer repay the balance by the original maturity date. A recast keeps the outstanding balance and the remaining contractual payment dates, but recalculates the level installment using the new rate. It is not automatically a new loan or an extension of the term.

The key calculation is the value, at the reset date, of the remaining installments discounted at the new rate. That value must equal the loan balance at that date. The earlier installment amount matters only if it is needed to determine that balance or to compare the old and new installments.

Definition: A rate-reset recast is a recalculation of the level installment on an existing loan after its interest rate changes. The recast uses the balance at the reset date, the new rate per payment period, and the number and timing of the remaining installments. Unless the contract says otherwise, the original maturity and payment dates are retained.

Model and Recast Formula

Assume the reset occurs immediately after a scheduled installment has been paid. Let \(B\) be the outstanding balance at that instant, \(i_{\text{new}}\) the effective interest rate for each payment period after the reset, and \(n\) the number of remaining installments. Assume equal installments \(R\) are made at the ends of those periods, the new rate remains constant through maturity, and there are no fees, skipped payments, or other cash flows.

$$ B=R\,a_{\overline{n}|} =R\frac{1-(1+i_{\text{new}})^{-n}}{i_{\text{new}}}, \qquad R=\frac{B}{a_{\overline{n}|}}. $$

Here \(a_{\overline{n}|}\) is the present-value annuity factor at the new rate per payment period. If \(i_{\text{new}}=0\), the factor is \(n\), so \(R=B/n\). The rate and payment period must match: for example, a monthly installment requires the effective rate for a month. This tutorial takes that rate as given; a quoted rate that uses a different compounding convention must first be converted appropriately.

The formula follows directly from the value equation. At the reset date, the first installment is one payment period away and is worth \(Rv\), the second is worth \(Rv^2\), and the last is worth \(Rv^n\), where \(v=1/(1+i_{\text{new}})\). Thus the total value is \(R(v+v^2+\cdots+v^n)\). The geometric sum is \(a_{\overline{n}|}\), giving \(B=R\,a_{\overline{n}|}\). Dividing by the factor gives the revised installment.

1
Pin down the reset instant.
Determine whether the reset is just after a scheduled installment or at another time. Use a balance measured at that same instant.
2
Count the remaining installments.
Count the payment dates through the stated maturity. Do not count a payment already made.
3
Use the new rate per payment period.
Calculate the annuity factor at this rate and for the remaining number of payments.
4
Recast and check.
Divide the balance by the factor. Check the first-period interest and principal, and confirm that the payment stream has the correct value at the reset date.

Worked Recast Calculations

Worked Example: Resetting a Monthly Installment

Immediately after a scheduled payment, a loan has a balance of \(\$8{,}000\) and 12 monthly installments remaining. The rate resets to an effective \(0.5\%\) per month. Find the revised installment and the balance after its first payment. Assume the rate remains unchanged through the original maturity.

Method. Value the 12 end-of-month installments at the reset-date balance using the new monthly rate. This keeps the remaining term at 12 months.

The factor is

$$ a_{\overline{12}|} =\frac{1-(1.005)^{-12}}{0.005} \approx 11.6189321. $$

Therefore the installment, calculated before rounding, is

$$ R=\frac{8{,}000}{11.6189321} \approx \$688.5314. $$

The displayed factor is rounded, so the intermediate result is shown to four decimal places. The installment to the nearest cent is \(\$688.53\). In the first month, interest is \(0.005(8{,}000)=\$40.00\). The principal repaid is approximately \(\$688.5314-\$40=\$648.5314\), leaving a balance of approximately \(\$8{,}000-\$648.5314=\$7{,}351.4686\).

Check. The revised installment is the reset balance divided by the 12-payment factor, so the present value of the 12 remaining payments is \(\$8{,}000\), subject to the shown factor rounding. The first payment covers the month’s \(\$40.00\) interest and reduces principal. The common mistake is to use 13 payments by counting the payment just made.

Worked Example: Recasting a Larger Balance With 30 Payments Left

A loan’s balance immediately after an installment is \(\$22{,}000\). There are 30 monthly installments remaining to the original maturity. Following a reset, the effective rate is \(0.4\%\) per month. The former installment was \(\$820\). Calculate the new installment and the first month’s principal repayment.

Method. Use the reset-date balance and the 30 remaining dates. The former installment is useful for comparison, but it does not determine the new installment.

$$ a_{\overline{30}|} =\frac{1-(1.004)^{-30}}{0.004} \approx 28.2168107, \qquad R=\frac{22{,}000}{28.2168107} \approx \$779.6771. $$

Thus the new installment is \(\$779.68\) to the nearest cent, a decrease of approximately \(\$820-\$779.6771=\$40.3229\) before rounding. First-month interest is \(0.004(22{,}000)=\$88.00\). The principal repayment is approximately \(\$779.6771-\$88=\$691.6771\), and the balance after that payment is approximately \(\$22{,}000-\$691.6771=\$21{,}308.3229\).

Check. The value of 30 installments at the new monthly rate is \(\$22{,}000\), using the annuity factor shown. The first installment exceeds first-month interest, so the balance declines. Do not use the former \(\$820\) payment in the new value equation: doing so would not generally repay the reset balance exactly at the retained maturity.

Worked Example: Checking the First Payment After a Reset

Immediately after a scheduled payment, a loan balance is \(\$5{,}000\), with six monthly installments remaining. The new effective rate is \(1\%\) per month. The previous installment was \(\$840\). Find the recast installment, its first-period interest and principal components, and the balance after that first payment.

Method. First value the six remaining payments at the new rate. Then split the first installment between interest on the reset-date balance and principal repayment.

$$ a_{\overline{6}|} =\frac{1-(1.01)^{-6}}{0.01} \approx 5.7954765, \qquad R=\frac{5{,}000}{5.7954765} \approx \$862.7418. $$

The recast installment is \(\$862.74\) to the nearest cent. First-month interest is \(0.01(5{,}000)=\$50.00\). Principal repaid is approximately \(\$862.7418-\$50=\$812.7418\), leaving approximately \(\$5{,}000-\$812.7418=\$4{,}187.2582\). The new installment is about \(\$22.7418\) higher than the former \(\$840\) installment.

Check. The payment exceeds interest, and the balance therefore falls. The value of the six recast payments at the new rate equals the \(\$5{,}000\) reset balance, subject to rounding of the displayed factor. Do not assume that a lower or higher installment alone indicates whether the recast is correct; the balance, rate, and remaining payment count must all appear in the value equation.

Timing, Balance, and Rounding Checks

The formula assumes the balance is measured at the same time from which the remaining installments are valued. When a reset is immediately after a payment, the next installment is one full payment period away. If the reset instead occurs between scheduled payment dates, the balance may need to be adjusted for interest accrued to the reset date, and the first remaining payment may not be a full period away. Applying the ordinary annuity formula without accounting for that timing would value the wrong cash flows.

The balance \(B\) is also not automatically the original principal less the total installments paid. Each earlier installment included interest. If the balance is not supplied, it must be determined from the loan’s actual history and the applicable terms up to the reset date. Once the correct reset-date balance is known, the new rate is used to value the remaining payments.

Keep precision in the annuity factor and installment calculation until the final step. If the contract requires payments rounded to cents, the resulting rounded installments may leave a small residual at maturity; a final payment may then need a rounding adjustment. A formula calculated with the unrounded installment has exactly the stated present value, while a cent-rounded payment stream may differ slightly.

QuestionUse in the recastCommon error
What is the balance?Balance at the reset instantUsing the original principal or a balance from a different date
How many payments remain?Payments after the reset through original maturityCounting a payment already made or extending the term
Which rate applies?New effective rate per payment periodUsing the old rate or a rate for a different period
What is being valued?The remaining contractual installmentsAdding fees or other cash flows without including them in the model
Key takeaway: A rate-reset recast is a present-value equation at the reset date: the outstanding balance equals the value of the remaining level installments at the new rate. Retaining the stated maturity means retaining the original remaining payment count.

Check Your Understanding

For each problem, assume the reset occurs immediately after a scheduled payment, the stated rate is effective per payment period, and there are no fees or other cash flows.

  1. A balance of \(\$6{,}000\) has 10 annual installments remaining, and the new annual effective rate is \(0\%\). Find the revised installment. (Answer: \(\$600\))
  2. A balance of \(\$5{,}795.4765\) has six monthly installments remaining at a new effective rate of \(1\%\) per month. Use \(a_{\overline{6}|}=5.7954765\). Find the installment and first month’s interest. (Answer: installment \(\$1{,}000.00\); first month’s interest \(\$57.9548\), approximately \(\$57.95\) to the nearest cent)
  3. A loan has a reset-date balance of \(\$18{,}000\), 24 quarterly installments remaining, and a new effective rate of \(0\%\) per quarter. Find the installment and explain why the original maturity is unchanged. (Answer: \(\$750\) per quarter; 24 payments remain, so the original final payment date is retained)
  4. A balance of \(\$9{,}000\) has 12 monthly installments remaining after a reset to \(0.5\%\) per month. Write the exact recast installment and state what must be counted as the first payment date. (Answer: \(R=\$9{,}000/a_{\overline{12}|}\), where \(a_{\overline{12}|}=[1-(1.005)^{-12}]/0.005\); the first remaining payment is one month after the reset date)
Clinical Biostats