Outstanding Loan Balances Between Payment Dates

Why the Valuation Date Matters

A loan balance is not just a number from an amortization schedule: it is the amount owed at a particular time under the loan’s interest and payment terms. If the requested date falls between scheduled payments, the most direct method is usually to start with the balance immediately after the latest payment and accumulate it to the requested date. The key is to use the right starting balance and the interest convention that applies during that interval.

A balance on a payment date can be quoted just before or just after the payment is made. Those amounts differ by the payment itself. Carrying the wrong one forward can produce a large error even if the interest calculation is flawless. Also, a fraction of a year does not by itself determine how interest accrues: the loan terms must specify, or the problem must imply, the applicable convention.

Definition: The outstanding loan balance at a specified time is the debt remaining at that time under the stated loan terms. A balance immediately before a payment includes the amount due at that instant, before the payment is credited. A balance immediately after a payment is the balance after that payment has been applied.

The Between-Payment Balance Rule

Let $B_0$ be the balance immediately after a payment-date transaction, and suppose no further payments or other account transactions occur over the next $t$ years. If the loan’s accumulation factor over that interval is $A(t)$, the balance at the later date is

$$ B(t)=B_0A(t). $$

This rule is about accumulating the existing debt. It does not include a payment that occurs at the end of the interval: at that payment date, calculate the balance just before the payment first, then subtract the payment to get the balance just after it. If the requested date is itself the payment date, read carefully to determine which of those two balances is wanted.

Result: For an interval with no intervening payments, the balance at the end of the interval equals the balance at the start multiplied by the accumulation factor for that exact interval. The accumulation factor must follow the loan’s stated interest convention; it cannot be selected merely because the valuation date is between scheduled payments.

For example, if the contract specifies simple interest at annual rate $i$ on a $D$-day basis, then $d$ days of accrual have factor $1+i(d/D)$. If instead the contract specifies equivalent fractional-period compounding at effective annual rate $i$, then an interval of $t$ years has factor $(1+i)^t$. Under a constant force of interest $\delta$, the factor is $e^{\delta t}$. These are different models; do not switch between them without support from the problem terms.

Why Accumulating the Balance Works

The balance is the debt carried forward from the starting date. Under a specified interest model, that debt grows by the model’s accumulation factor over the interval. With no cash flow in between, there is no payment to subtract and no new borrowing to add, so the accumulated starting balance is the entire later balance.

\text{later balance} = \text{starting balance} + \text{interest accrued} = B_0+\bigl(A(t)-1\bigr)B_0 = B_0A(t).

The second equality expresses accrued interest as the growth factor in excess of 1, applied to the starting debt. The argument depends on there being no intervening transaction. If a payment occurs during the interval, divide the timeline at that payment: accumulate to just before it, subtract the payment, and then accumulate the remaining balance over the next interval.

Locate the valuation date.
Count the elapsed time from the most recent relevant payment or balance date, using the specified day-count basis or period length.

Choose the correct starting balance.
Use the balance immediately after the last payment already made. If only a before-payment balance is given, subtract that payment first.

Apply the stated accumulation rule.
Calculate the interval factor from the contractual interest assumption and multiply it by the starting balance.

Check the timing and units.
Confirm that the payment has been credited at the correct time and that the elapsed-time fraction uses the stated basis.

Worked Applications

Worked Example: Simple Interest for an Odd Number of Days

A hypothetical loan has a balance of $32,000 immediately after a payment. The contract specifies simple interest at an annual rate of 12%, using a 360-day year. What is the balance 45 days later, before the next payment?

Method. There are no intervening payments, so accumulate the post-payment balance for 45 days using the contract’s simple-interest day basis.

The fraction of a 360-day year is $45/360=0.125$. The interest accrued over the interval, expressed as a fraction of the starting balance, is $0.12(0.125)=0.015$. Thus the accumulation factor is $1+0.015=1.015$.

B(45\text{ days})=32{,}000(1.015)=32{,}480.

The balance before the next payment is $32,480.00. As a check, interest is $32{,}000(0.015)=\$480$, and $32{,}000+\$480=\$32{,}480$. The common mistake avoided here is using 45/365: the contract explicitly specifies a 360-day basis.

Worked Example: Subtract the Payment Before Accumulating

On a payment date, a hypothetical loan’s balance immediately before the scheduled payment is $44,379.198. The borrower then pays $2,500. The contract accrues simple interest at 12% per year on a 360-day basis. Find the balance 12 days after the payment.

Method. First find the balance immediately after the payment; that is the debt that accrues interest over the next 12 days.

The post-payment balance is $44{,}379.198-2{,}500=41{,}879.198$. The 12-day interest factor is $1+0.12(12/360)=1+0.004=1.004$.

$$ 41{,}879.198(1.004)=42{,}046.714792. $$

Rounding only the final dollar amount to the nearest cent, the balance is $42,046.71. The accrued interest is $41{,}879.198(0.004)=167.516792$, and adding it to the post-payment balance gives $42{,}046.714792$, which checks the calculation.

Common mistake. Accumulating the pre-payment amount instead gives $44{,}379.198(1.004)=44{,}556.714792$, or $44,556.71 to the nearest cent. That is $2,510 higher than the correct unrounded balance after 12 days. The difference is $2{,}500(1.004)=2{,}510$: the already-made payment was incorrectly left in the debt and then accrued interest. Subtract the payment before accumulating.

Worked Example: Equivalent Fractional-Period Compounding

A hypothetical loan has a balance of $18,000 immediately after a payment. Its contract specifies fractional-period accumulation equivalent to an effective annual rate of 21.550625%. The next scheduled payment is six months later. Find the balance three months after the first payment, before the next payment.

Method. Use the specified equivalent fractional-period compounding model. Three months is $3/12=1/4$ of a year, and there are no intervening payments.

The annual accumulation factor is $1+0.21550625=1.21550625$. This equals $1.05^4$, so the accumulation factor for one quarter of a year is $(1.21550625)^{1/4}=1.05$. The balance at the requested date is therefore

$$ B(1/4)=18{,}000(1.05)=18{,}900. $$

The balance is $18,900.00. The interest accrued is $18{,}900-18{,}000=\$900$, which is 5% of the starting balance and confirms the result. The next scheduled payment is not subtracted because the valuation date is three months before it. The common mistake avoided is applying the full annual rate to a quarter-year interval.

Timing and Model Checks

A useful way to prevent errors is to write a short timeline before calculating. Mark each payment, label each balance as before or after that payment, and identify the valuation date. For each interval between transactions, write the accumulation factor separately. This makes the sequence explicit:

\text{balance after payment} \ \longrightarrow\ \text{accumulation to next date} \ \longrightarrow\ \text{balance before next payment} \ \longrightarrow\ \text{subtract payment}.

The same sequence works when an exam problem supplies an earlier balance rather than the balance at the most recent payment date. Accumulate or discount that balance to the needed payment date under the stated terms, apply the payment at its actual time, and then accumulate the resulting balance to the requested date. Do not skip a transaction simply because it lies between the given and requested dates.

These calculations matter whenever a loan amount must be stated on a non-payment date. They also clarify what an answer represents: a contractual balance at a specified instant, not necessarily a payoff quotation that includes fees or other charges not given in the problem.

Common Mistakes

Using the pre-payment balance as the starting point. If the payment has already been made, subtract it before accruing subsequent interest.
Subtracting a future payment too early. A payment due after the valuation date does not reduce the balance at the valuation date.
Assuming a fractional-year rule. Simple interest, fractional-period compounding, and continuous accumulation can give different results. Follow the stated convention.
Mixing time units. A 30-day interval on a 360-day basis is $30/360$ of a year, not $30/12$ years or automatically $30/365$ years.
Rounding intermediate amounts unnecessarily. Keep the unrounded balance through the accumulation and round the final monetary answer to cents unless instructed otherwise.

Key takeaway: For a between-payment valuation, start with the balance immediately after the latest payment already made, apply the accumulation factor for the elapsed interval under the stated loan convention, and check that no payment has been included on the wrong side of the valuation date.

Check Your Understanding

For each problem, identify the relevant starting balance and interest convention before calculating.

A loan balance is $24,000 immediately after a payment. The contract charges simple interest at 9% per year on a 360-day basis. Find the balance 20 days later, before the next payment. (Answer: $24,120.00)
A loan balance is $51,200 immediately after a payment. The stated nominal annual rate is 6% convertible monthly, and the contract compounds monthly. Find the balance two months later, assuming no intervening transactions. (Answer: $51,713.28)
Immediately before a scheduled payment, a loan balance is $27,850. A payment of $1,850 is then made. The contract accrues simple interest at 10% per year on a 360-day basis. Find the balance 30 days later, before the next payment. (Answer: $26,216.67)
A loan balance is $40,000 immediately after a payment. The contract specifies accumulation for fractional years equivalent to an effective annual rate of 10%. Find the balance six months later, before the next payment. Round to the nearest cent. (Answer: $41,952.35)

What You'll Learn