Solving for an Affordable Extra Payment

Balancing an Extra Payment and Future Installments

When a borrower changes a loan, the central question is often not simply what payment would repay the balance. The borrower may have both an upfront cash limit and a maximum affordable installment. The useful method is to value every remaining payment at the modification date, then solve the loan’s remaining value equation for the amount that can change.

This tutorial assumes a fixed effective interest rate per payment period, payments made at the ends of their stated periods, and no fees, penalties, or new borrowing unless the problem says otherwise. The balance used is the amount owed at the modification date, after any payment due on that date has been accounted for. An extra principal payment is made immediately at that date.

Definition: Let $B$ be the loan balance at the modification date, $E$ the extra principal payment made immediately, $R$ a level installment paid at each period-end for $n$ periods, and $i$ the effective interest rate per payment period. If the extra payment is followed by $n$ level installments, the remaining value equation is $$ B=E+R a_{\overline{n}|}, \qquad a_{\overline{n}|}=\frac{1-v^n}{i}, \qquad v=\frac{1}{1+i}. $$

The equation states that the balance equals the value, at the modification date, of the proposed repayment plan. The term $E$ is already paid at that date, so it is not discounted. Each installment is paid later and is discounted to the same date. If payments are not level, value each payment separately; do not apply a level-annuity factor to an unequal schedule.

The equation can be rearranged in either direction. If the installment is fixed, the required extra payment is $E=B-Ra_{\overline{n}|}$. If the extra payment is fixed, the revised level installment is $R=(B-E)/a_{\overline{n}|}$. A cash limit can then be tested against the resulting amount.

Why the Remaining Value Equation Holds

The value equation follows from the same present-value principle used to value an annuity. At the modification date, the first end-of-period installment has value $Rv$, the second has value $Rv^2$, and the final one has value $Rv^n$. Their total value is a geometric series:

R(v+v^2+\cdots+v^n) =R\frac{v(1-v^n)}{1-v} =R\frac{1-v^n}{i} =R a_{\overline{n}|}.

Here $1-v=i/(1+i)=iv$, which gives the second equality. Adding the immediate payment $E$ gives the total value of the proposed plan, $E+Ra_{\overline{n}|}$. The plan repays the balance precisely when this value equals $B$. This reasoning requires the stated payment timing and rate assumption; a payment at the modification date or a rate that changes over the term must be valued according to its actual timing and applicable rate.

Finding the Extra Payment Needed for an Installment Limit

When the borrower sets a maximum installment $M$, the least immediate extra payment that allows installments no greater than $M$ is found by first valuing installments at that maximum. The threshold is $E_{\text{req}}=B-Ma_{\overline{n}|}$. If this is positive, at least that much must be paid upfront to support installments of $M$. If it is zero or negative, the balance can already be repaid with installments no greater than $M$, so no extra payment is needed.

Worked Example: Testing a Fixed Installment Against an Upfront Cash Limit

At a modification date, a borrower owes $8,000. The balance is to be repaid with three annual installments of $2,700, each paid at year-end. The effective annual interest rate is 4%. The borrower can pay at most $600 immediately toward principal. Find the required extra payment and determine whether the plan is affordable.

Method. Value the three installments at the modification date, subtract that value from the balance, and compare the resulting extra payment with the cash limit. This avoids treating the future installments as though they were payments made immediately.

The annual rate and payment frequency match, so use $i=0.04$ and $n=3$. The discount factor and annuity factor are $$ v=\frac{1}{1.04}=0.961538462,\qquad a_{\overline{3}|}=\frac{1-v^3}{0.04} =\frac{1-(1/1.04)^3}{0.04} \approx 2.775091034. $$

The present value of the installments is $$ 2{,}700(2.775091034)\approx \$7{,}492.75. $$

Therefore, the immediate extra payment required by the value equation is $$ E=8{,}000-7{,}492.75=\$507.25. $$

The amount is below the $600 limit by $\$600-\$507.25=\$92.75$, so the plan is affordable. As a check, the present value of the $507.25 extra payment and the installments is approximately $\$507.25+\$7{,}492.75=\$8{,}000.00$. The common mistake is to round or miscalculate the annuity factor before multiplying; using the factor shown gives $507.25, not $504.56.

Solving for the Revised Installment

Sometimes the borrower has a fixed amount available now and wants to know what installment that amount will support. For a chosen upfront payment $E$, the revised installment is $(B-E)/a_{\overline{n}|}$. If the borrower also has an installment ceiling $M$, the plan meets that ceiling exactly when $E$ is at least $B-Ma_{\overline{n}|}$, provided the extra payment is nonnegative.

For fixed $B$, $n$, and $i$, a larger upfront payment leaves a smaller balance to be repaid through installments. Consequently, if the borrower can pay at most $C$ upfront, the smallest installment attainable under that cash limit uses $E=C$, as long as $C\leq B$. The plan is feasible under both limits if the installment calculated using the available cash does not exceed the installment ceiling.

Worked Example: Checking an Installment Ceiling and Cash Budget

A borrower owes $12,000 at a modification date. There are four annual payments remaining, at an effective annual interest rate of 5%. The borrower can pay no more than $500 immediately and wants annual installments no greater than $3,300. Find the minimum upfront payment needed and test the cash budget.

Method. Find the present value of four installments at the maximum acceptable amount. The difference between the balance and that value is the minimum immediate payment needed to bring the installments down to the ceiling.

With $i=0.05$ and $n=4$, $$ v=\frac{1}{1.05}=0.952380952, \qquad a_{\overline{4}|} =\frac{1-(1/1.05)^4}{0.05} \approx 3.545950504. $$

At the maximum acceptable installment, the present value is $$ 3{,}300(3.545950504)\approx \$11{,}701.64. $$

The minimum upfront payment required is therefore $$ E_{\text{req}}=12{,}000-11{,}701.64=\$298.36. $$

The $500 cash budget exceeds the required payment by $\$500-\$298.36=\$201.64$, so the installment ceiling is affordable. At the minimum required upfront payment, the remaining value is $11,701.64, exactly the value of four $3,300 installments. The check confirms both the value equation and the installment limit. The common mistake is to compare the $12,000 balance directly with the sum of four installments; that ignores interest and the timing of those future payments.

Unequal Future Payments and the Same Affordability Test

The same approach works when only some future installments are revised. At the modification date, write the present value of each remaining payment separately. For example, if a fixed payment $C_1$ is due after one period and the next two payments are equal to $R$, the value equation is $B=E+C_1v+R(v^2+v^3)$. Solving this equation for $R$ gives the largest level amount for those later payments when $E$ is fixed and no other constraint limits $R$.

Worked Example: Maximizing Later Installments Under an Upfront Limit

At a modification date, a borrower owes $12,000. The repayment plan requires $4,000 at the end of year 1, followed by equal installments at the ends of years 2 and 3. The effective annual interest rate is 5%. The borrower can pay at most $1,500 immediately and wants the largest possible equal amount for the year 2 and year 3 installments. Find that amount and verify the plan.

Method. Use the full $1,500 upfront limit to maximize the later installments, then solve the remaining value equation for their common amount $R$. The year 1 payment is valued separately because it is not part of the level pair.

The discount factors needed are $$ v=\frac{1}{1.05}=0.952380952,\qquad v^2=0.907029478,\qquad v^3=0.863837599. $$

The fixed year 1 payment has present value $$ 4{,}000v=4{,}000(0.952380952)\approx \$3{,}809.52. $$

The present-value factor for the two later payments is $$ v^2+v^3=0.907029478+0.863837599=1.770867077. $$

Using $E=\$1{,}500$, the value equation becomes $$ 12{,}000=1{,}500+3{,}809.52+1.770867077R. $$

Thus, $$ R=\frac{12{,}000-1{,}500-3{,}809.52}{1.770867077} =\frac{6{,}690.48}{1.770867077} \approx \$3{,}778.08. $$

For a check, the present value of the plan is approximately $\$1{,}500+\$3{,}809.52+\$3{,}778.08(1.770867077)=\$12{,}000.00$. Any larger $R$, with the other terms fixed, would make the right-hand side exceed the balance. The common mistake is to discount the year 1 payment by $v^2$, as if it were due at the same time as the first revised installment.

Feasibility Checks and Common Traps

An algebraic solution is not automatically an affordable or valid plan. Before accepting it, check that the extra payment is nonnegative, that it does not exceed the borrower’s upfront limit, and that the installment meets its stated limit. A proposed extra payment larger than the balance, or an installment below zero, usually signals an infeasible plan or a misread condition. If $B-Ma_{\overline{n}|}<0$, the maximum installment already has enough present value to repay the balance; the required extra payment is zero, not a negative payment to the borrower.

Use the balance at the correct date. Identify whether the stated balance is before or after a payment due on the modification date. Do not include that payment twice.
Match the rate period to the payment period. For annual payments, use an effective annual rate. For a different payment frequency, first obtain the effective rate per payment period.
Discount payments according to their actual dates. An immediate extra payment is not discounted; a year-end payment is discounted one period.
Distinguish a cash ceiling from a required cash amount. A maximum upfront budget is a constraint, not necessarily the amount the borrower must pay.
Check the proposed plan in the original value equation. Substituting the rounded final amounts should reproduce the balance to the stated precision.

These calculations are useful because they turn a borrower’s limits into a clear feasibility test. The value equation shows how much immediate principal reduction is needed to support a chosen installment, or how much installment the available upfront cash can support. It does not by itself account for fees, penalties, changing rates, or alternative loan terms; those items must be valued separately when they apply. These problem-solving methods are aligned with the SOA Exam FM (Financial Mathematics) syllabus.

Key takeaway: Value all proposed payments at the modification date, solve the remaining value equation for the unknown amount, and then compare that amount with the borrower’s cash and installment limits. Verify the final plan by substituting it back into the equation.

Check Your Understanding

For each problem, use the stated payment timing and rate. Round money to the nearest cent.

A balance of $5,000 is to be repaid by two annual installments of $2,600 at an effective annual rate of 5%. Find the immediate extra payment required. (Answer: $165.53)
A borrower owes $12,000, has four annual payments remaining, and faces an effective annual rate of 5%. Annual installments may not exceed $3,300, and the borrower can pay at most $500 upfront. Is the plan feasible, and what is the minimum upfront payment required? (Answer: Yes; $298.36)
A balance of $15,000 is to be repaid over five years at an effective annual rate of 6%. If annual installments may not exceed $3,500, find the minimum immediate extra payment. Is it within an upfront cash limit of $1,000? (Answer: $256.73; yes, with $743.27 of the limit remaining)
A borrower owes $8,000. The plan requires $2,000 at the end of year 1 and equal payments $R$ at the ends of years 2 and 3. At an effective annual rate of 5%, the borrower can pay at most $500 immediately. Find the largest possible $R$. (Answer: $3,159.60)
A balance of $10,000 is to be repaid by four annual installments at an effective annual rate of 5%. The installment ceiling is $2,800 and the upfront cash limit is $300. Find the minimum extra payment required and determine whether the plan is feasible. (Answer: $71.34; yes, with $228.66 of the limit remaining)

What You'll Learn