Finding the Balance on a Loan Change Date

Why the Change Date Matters

When a loan is modified or refinanced, the amount being changed depends on the exact date of the transaction. A date just before an installment is not equivalent to a date just after it: the installment due at that date is still part of the debt before payment, but is no longer outstanding after payment. A date between installments requires accounting for interest accrued since the most recent payment.

This tutorial calculates the outstanding principal under a stated loan contract. It does not add fees, prepayment penalties, or other charges. Those items may affect a transaction amount, but they are not part of the principal balance calculated here.

Definition: The outstanding balance at a specified time is the amount of principal remaining under the loan at that time, according to the loan’s interest and payment terms. Immediately before an installment, the balance includes the installment then due. Immediately after that installment is paid, the balance is reduced by the payment.

We use $B(t^-)$ for the balance immediately before a payment at time $t$, and $B(t^+)$ for the balance immediately after it. If the payment is $C$, then $B(t^+)=B(t^-)-C$. Between payment dates, the balance grows according to the loan’s interest model.

Two Ways to Value the Balance

A balance can be found retrospectively by accumulating the original principal and subtracting the accumulated value of payments already made. It can also be found prospectively as the value, at the valuation date, of the payments still due. The prospective approach is especially direct when a loan’s remaining installments are known.

Result: Suppose a loan begins at time 0 with principal $L$, uses an effective annual interest rate $i$, and has payments $C_j$ at times $t_j$ measured in years. Assume fractional-year accumulation follows $(1+i)^t$, and payments are made at the stated times. At a date $t$ that is not itself a payment date, $$ B(t)=L(1+i)^t-\sum_{t_j<t} C_j(1+i)^{t-t_j} =\sum_{t_j>t}\frac{C_j}{(1+i)^{t_j-t}}. $$ At a payment date $t_k$, the balance just before payment includes $C_k$ among the future payments; the balance just after payment excludes it.

The two expressions are equal when the payment schedule exactly satisfies the loan terms. In applying the retrospective expression, include only payments already made. In applying the prospective expression, include only payments still owed. Mixing those rules is a frequent source of off-by-one-payment errors.

Why the Two Valuation Methods Agree

The prospective balance is not a separate loan convention. It follows from the same value equation that defines the payment schedule: at any date, the outstanding amount must equal the value of the remaining contractual payments at the loan’s interest rate. The retrospective expression follows by carrying the original principal and each payment forward to that date.

Accumulate the principal.
At time $t$, the original principal $L$ has accumulated to $L(1+i)^t$.

Accumulate payments already made.
A payment $C_j$ made at $t_j<t$ accumulates to $C_j(1+i)^{t-t_j}$ by time $t$. Subtract each such accumulated payment from the accumulated principal.

Value what remains.
At time $t$, the resulting balance is the amount needed to meet all remaining payments. Discounting each remaining payment back to $t$ gives $\sum_{t_j>t} C_j/(1+i)^{t_j-t}$, the prospective expression.

For the last step, each payment already made is carried forward at the same rate used to accumulate the principal. The loan’s value equation therefore remains balanced at every date: the amount accumulated from the original loan, net of past payments, equals the present value of the unpaid installments. This argument assumes the stated payment schedule and interest model are followed; it does not automatically incorporate a fee or a different rate imposed at a transaction date.

Worked Examples

Worked Example: Balance Immediately Before and After an Installment

A hypothetical loan has principal $1,000 and an effective annual interest rate of 10%. It requires payments of $400 at the end of years 1 and 2, followed by a final payment at the end of year 3. Find the balance immediately before and after the second payment, and verify that the final payment clears the balance.

Method. Accumulate each balance for one year, then subtract the payment due. This avoids treating a payment as if it were made before the interest for its period has accrued.

At the end of year 1, immediately before the first payment, the balance is $1{,}000(1.10)=\$1{,}100.00$. Immediately after the $400 payment, it is $\$1{,}100.00-\$400.00=\$700.00$.

During year 2, the $700 balance earns 10% interest. Thus, immediately before the second payment, $\$700.00(1.10)=\$770.00$. Immediately after that payment, the balance is $\$770.00-\$400.00=\$370.00$.

During year 3, the balance grows to $\$370.00(1.10)=\$407.00$. Therefore, the final scheduled payment is $407.00, which reduces the balance to $\$407.00-\$407.00=\$0.00$.

Check. The sequence of balances is consistent with the 10% annual rate and all three payments. The second installment reduces the balance from $770.00 immediately before payment to $370.00 immediately afterward.

Worked Example: A Change Date Halfway Between Installments

A hypothetical loan has principal $1,000 and an effective annual interest rate of 44%. The borrower pays $300 at the end of year 1 and $500 at the end of year 2. A final payment is scheduled at the end of year 3. Find the outstanding balance at time $t=1.5$, halfway between the first and second payment dates, and determine the final payment.

Assume fractional-year accumulation follows $(1.44)^t$. In particular, the half-year accumulation factor is $(1.44)^{0.5}=1.20$. This assumption is part of the model; a contract using a different day-count or interest convention could give a different between-date balance.

Method. First calculate the balance after the year-1 payment, then accrue it for half a year. As a check, discount the remaining payments to time 1.5.

From time 0 to time 1, the original $1,000 accumulates to $\$1{,}000(1.44)=\$1{,}440$. After the $300 payment at time 1, the balance is $\$1{,}440-\$300=\$1{,}140$.

From time 1 to time 1.5, this balance accumulates by a factor of 1.20: $\$1{,}140(1.20)=\$1{,}368$. Thus the balance on the change date is $1,368.00.

To find the year-3 payment, first advance the post-payment balance at time 2. The balance immediately before the year-2 payment is $\$1{,}140(1.44)=\$1{,}641.60$. After the $500 payment, it is $\$1{,}641.60-\$500=\$1{,}141.60$. One more year of interest gives the final payment: $\$1{,}141.60(1.44)=\$1{,}643.904$, or $1,643.90 to the nearest cent.

Check by valuing the remaining payments at time 1.5. The $500 payment is due half a year later, and the $1,643.904 payment is due 1.5 years later: $\$500/1.20+\$1{,}643.904/(1.44\times1.20)=\$416.6667+\$951.3333=\$1{,}368.00$.

Check. Both methods give $1,368.00 at time 1.5. The final payment is $1,643.90 when rounded to cents; the unrounded amount of $1,643.904 clears the balance exactly.

Worked Example: Checking a Balance From the Remaining Payment

A hypothetical loan has principal $2,000 and an effective annual interest rate of 10%. It requires payments of $1,000 at the end of years 1 and 2, followed by one final payment at the end of year 3. Find the balance immediately before and after the year-2 payment, then verify the balance just after that payment using the remaining installment.

Method. Use the retrospective calculation through the year-2 payment, and then check prospectively from the one remaining payment. This provides an independent timing check.

At the end of year 1, the balance before payment is $\$2{,}000(1.10)=\$2{,}200$. After the $1,000 payment, the balance is $\$2{,}200-\$1{,}000=\$1{,}200$.

At the end of year 2, immediately before payment, the balance is $\$1{,}200(1.10)=\$1{,}320$. After the $1,000 payment, it is $\$1{,}320-\$1{,}000=\$320$. The final payment one year later must be $\$320(1.10)=\$352$.

Prospectively, the balance immediately after the year-2 payment is the year-3 payment discounted one year: $\$352/1.10=\$320$. This agrees with the retrospective result. Immediately before the year-2 payment, the balance is the value at year 2 of both payments still due: $\$1{,}000+\$352/1.10=\$1{,}320$.

Check. The balance before payment includes the $1,000 due at year 2; the balance after payment does not. Both retrospective and prospective calculations agree at each stated point.

Dates Between Payments and Contract Assumptions

Between installments, use the accumulation rule specified by the loan. If the loan has an effective annual rate $i$ and the model assumes compound accumulation for fractional years, a balance $B$ immediately after a payment grows over $\tau$ years to $B(1+i)^\tau$. The same result can be obtained by discounting each future payment to the date being valued.

Do not assume that every contract uses fractional-year compound accumulation. A loan may specify a nominal rate convertible at a stated frequency, a monthly rate, or a particular day-count convention. In that case, apply the contract’s stated method to the time between the payment date and change date. If the change date is exactly a payment date, identify whether the requested amount is before or after that payment.

Common Timing Errors

A common mistake is to subtract the installment before charging interest for the period that just ended. In Worked Example 1, this would incorrectly calculate the balance just before the second installment as $\$700-\$400=\$300$. That subtracts the second payment before it is due and ignores the year’s interest.

The correct order is $\$700(1.10)=\$770$ immediately before the payment, followed by $\$770-\$400=\$370$ immediately after it.

Before versus after. Before payment, include the installment due at that date. After payment, subtract it.
Between dates. Accrue from the most recent payment date using the contract’s interest convention; do not apply a full period’s interest for a fraction of a period.
Retrospective versus prospective. Retrospective calculations include payments already made; prospective calculations include payments still owed. Do not include the same payment in both sets.
Principal versus transaction amount. The outstanding principal calculated here is not necessarily a complete settlement amount if separate fees or other charges apply.

Key takeaway: Fix the valuation date and payment timing first. Then either accumulate the loan principal net of past payments or discount the remaining payments to that date. Under a consistent loan model, both methods give the same balance.

Check Your Understanding

For each question, state whether the requested balance is before or after a payment where relevant. Use the stated fractional-year assumption.

A hypothetical loan has principal $3,000, an effective annual rate of 5%, and a payment of $800 at the end of year 1. Find the balances immediately before and after that payment. (Answer: $3,150.00 before; $2,350.00 after.)
Immediately after a scheduled payment, a loan balance is $1,200. The effective annual rate is 10%, with fractional-year accumulation $(1.10)^t$. Find the balance six months later, before any further payment. (Answer: $1,258.57.)
A loan has principal $4,000, an effective annual rate of 10%, and payments of $1,500 at the ends of years 1 and 2. Find the balance immediately after the year-2 payment. (Answer: $1,690.00.)
Immediately after a payment at time 1, a loan balance is $900. The effective annual rate is 21%, with fractional-year accumulation $(1.21)^t$. Find the balance at time 1.5, before the next installment. (Answer: $990.00.)
Immediately after one installment, a loan balance is $2,500. One period later, the effective interest rate for that period is 4%, and a $700 installment is due. Find the balance immediately before and after that installment. (Answer: $2,600.00 before; $1,900.00 after.)

What You'll Learn