Tutorials › Exam FM - Financial Mathematics › The Outstanding Balance at a Valuation Date

Exam FM · Outstanding Balance Methods · Tutorial 252 of 998

The Outstanding Balance at a Valuation Date

Determine the amount still owed on a loan at a stated date, with careful attention to payment timing, interest-period units, and schedule entries.

Intermediate 10 min read

What You'll Learn

  • Define an outstanding balance at a specified valuation date
  • Distinguish the original loan amount, payments made, and remaining balance
  • Calculate balances using the loan’s period-by-period schedule
  • Separate balances immediately before and immediately after a payment
  • Apply the correct rate period and payment timing
  • Recognize common valuation-date and interest-unit errors

What Does an Outstanding Balance Measure?

A loan balance answers a specific question: how much of the borrower’s obligation remains at a stated date? It is not the amount originally borrowed, and it is not the total of payments already made. Interest and payments change the amount owed over time, so a balance must always be connected to a valuation date and a payment-timing convention.

For a standard amortizing loan, a schedule records the balance at successive payment dates. Between those dates, the balance changes as interest accrues. When a payment is made, it reduces the amount owed. The distinction between the balance just before a payment and the balance just after it can be material, especially when the valuation date is itself a payment date.

Definition: The outstanding balance at a valuation date is the amount of the loan obligation remaining at that date under the loan’s stated interest and payment terms. At a payment date, specify whether the balance is measured immediately before or immediately after the payment. The original loan amount is the balance at the start, before subsequent interest and payments have changed it.

In this tutorial, \(B_k\) denotes the balance immediately after the \(k\)th payment, and \(B_0=L\) denotes the original amount borrowed. The payment at the end of period \(k\) is denoted by \(R_k\), and \(i\) is the effective interest rate per payment period. Unless stated otherwise, assume that interest is applied once per payment period, payments occur at period ends, and there are no fees or extra transactions. A rate quoted for some other period must first be converted to the effective rate per payment period.

How a Schedule Tracks the Balance

A schedule moves forward one period at a time. Starting with the balance after one payment, the next period’s interest is calculated on that balance. The scheduled payment is then subtracted. Thus the balance immediately after payment \(k\) is

$$ B_k=B_{k-1}(1+i)-R_k. $$

This accounting relation is useful because it identifies the balance at a date directly from the transactions that have occurred by then. It does not require adding up payments from earlier periods and calling that total the balance. In particular, payments may include both interest and principal; the full payment reduces the amount owed, while the interest portion compensates for the period’s interest charge.

Timing convention: Immediately before a period-end payment, the balance is \(B_{k-1}(1+i)\). Immediately after that payment, it is \(B_{k-1}(1+i)-R_k=B_k\). These are different values at the same payment date.

The recurrence follows from the basic schedule bookkeeping. If the balance at the start of a period is \(B_{k-1}\), interest for that period is \(iB_{k-1}\), so the amount due just before payment is \(B_{k-1}+iB_{k-1}=B_{k-1}(1+i)\). Paying \(R_k\) leaves that amount less the payment:

$$ \text{balance after payment} = \text{balance before interest} + \text{interest for the period} - \text{payment} = B_{k-1}+iB_{k-1}-R_k. $$

Combining the first two terms gives \(B_k=B_{k-1}(1+i)-R_k\). This relation applies to the stated period-by-period schedule. It must be adjusted if the interest convention, payment timing, or transaction pattern differs; for example, a payment made at the start rather than the end of a period does not follow the same timing sequence.

Worked Example: Balance After a Level Annual Payment

A borrower takes a loan of $900 at an effective annual rate of 25%. The loan is repaid with two equal payments of $625, each made at the end of a year. Find the balance immediately after the first payment and immediately before and after the second payment. Use the annual schedule recurrence.

Method. Apply interest for each year, then subtract the payment at that year’s end. The rate and payment periods are both annual.

At time 0, before any interest or payment, \(B_0=900\).

During the first year, interest is \(900(0.25)=225\). Immediately before the first payment, the amount due is \(900+225=1{,}125\). Subtract the payment of $625:

$$ B_1=900(1.25)-625=1{,}125-625=500. $$

The balance immediately after the first payment is $500. During the second year, interest is \(500(0.25)=125\), so the balance immediately before the second payment is \(500+125=625\). Subtract the second payment:

$$ B_2=500(1.25)-625=625-625=0. $$

Check. The second payment exactly clears the amount due at time 2. The balance is $625 immediately before that payment and $0 immediately after it. The common mistake is to report $625 as the balance at time 2 without saying that it is the before-payment value.

Original Principal, Past Payments, and Current Balance

These three quantities answer different questions:

  • Original principal: the amount borrowed at the loan’s start, \(B_0=L\).
  • Past payments: cash amounts the borrower has already paid. Their total is not, in general, the balance now owed.
  • Outstanding balance: the amount remaining at the valuation date after accounting for interest and payments through that date.

The total of past payments alone does not reveal the balance. Some of each payment may have covered interest, and the loan balance also depends on the original amount, interest rate, and payment schedule. A schedule is the direct record of how those items combine.

Worked Example: A Monthly Schedule With a Final Adjusted Payment

A loan of $1,000 accrues interest at an effective monthly rate of 1%. Payments of $340 are made at the ends of the first and second months. Find the balance immediately after the second payment. If the loan is to be cleared at the end of month 3, also find the required final payment. Assume the final payment is adjusted to clear the balance exactly.

Method. Use the monthly rate with each monthly period, applying interest before subtracting each end-of-month payment.

At the end of month 1, the balance before payment is \(1{,}000(1.01)=1{,}010\). After the $340 payment:

$$ B_1=1{,}010-340=670. $$

During month 2, interest is \(670(0.01)=6.70\). The balance before the second payment is \(670+6.70=676.70\). After the $340 payment:

$$ B_2=670(1.01)-340=676.70-340=336.70. $$

Therefore the outstanding balance immediately after the second payment is $336.70. To find the adjusted payment at the end of month 3, first apply one more month of interest to that balance:

$$ 336.70(1.01)=340.067. $$

So the amount due just before the final payment is $340.067. Rounded to the nearest cent, the required payment is $340.07. The unrounded calculation leaves no balance; if payments are actually restricted to cents, a lender may specify a final-payment rounding adjustment.

Check. The month-3 amount is slightly greater than $336.70 because one more month of interest accrues. The common mistake is to use an annual rate as though it were the stated monthly rate, or to report the amount due before the second payment as the balance after it.

Valuing at a Payment Date

When a valuation date coincides with a scheduled payment, first identify which side of the payment is intended. The schedule’s after-payment balance already reflects that payment. The before-payment balance includes the period’s interest but does not yet subtract the scheduled payment. State the convention explicitly rather than relying on a phrase such as “the balance at the end of year 2.”

The same discipline applies when reading an amortization table. Check the column heading and the row convention: a row may show the opening balance, interest, payment, principal repaid, and closing balance. If the closing balance is the value after the listed payment, it is the relevant balance only for a valuation date after that payment has been made.

Worked Example: Balance Around an Unequal Payment

A loan begins at $5,000 and earns an effective annual rate of 8%. The borrower pays $2,000 at the end of year 1 and $1,800 at the end of year 2. Find the balance immediately after the first payment, immediately before the second payment, and immediately after the second payment.

Method. Apply the schedule recurrence separately for each period. The payments are unequal, so use the actual payment in each period.

For year 1, interest is \(5{,}000(0.08)=400\). The amount due before payment is \(5{,}000+400=5{,}400\). After the $2,000 payment:

$$ B_1=5{,}000(1.08)-2{,}000=5{,}400-2{,}000=3{,}400. $$

For year 2, interest on the $3,400 opening balance is \(3{,}400(0.08)=272\). Thus the balance immediately before the second payment is \(3{,}400+272=3{,}672\). Subtract the $1,800 payment:

$$ B_2=3{,}400(1.08)-1{,}800=3{,}672-1{,}800=1{,}872. $$

The requested values are $3,400 immediately after the first payment, $3,672 immediately before the second payment, and $1,872 immediately after the second payment.

Check. In year 2, the difference between the before-payment and after-payment balances is exactly $1,800. The common mistake is to apply the second payment twice, or to assume unequal payments can be replaced by a single level-payment amount.

Common Exam Traps

A valuation-date question often tests interpretation as much as arithmetic. Before calculating, mark the payment period, rate period, and whether the requested balance is before or after any payment on the valuation date.

Common mistake: Treating the sum of payments already made as the amount repaid from principal, then subtracting it from the original loan. Payments generally include interest as well as principal, so this subtraction does not give the outstanding balance.

For example, after the first $625 payment in the $900 loan above, subtracting $625 directly from $900 would suggest a $275 balance. But the correct schedule calculation gives \(900(1.25)-625=500\). The $225 difference is the first year’s interest; it had to be covered before the payment reduced the obligation.

Other errors to avoid include:

  • Using a quoted annual rate as a monthly or quarterly rate without conversion.
  • Reporting the amount due before a payment when the question asks for the balance after it.
  • Confusing the original amount borrowed with the current balance.
  • Ignoring a non-level payment and using a different payment amount in the recurrence.
  • Rounding intermediate balances unnecessarily when the problem specifies exact arithmetic or an adjusted final payment.

For a schedule with a stated rate per payment period, the most reliable procedure is to begin with \(B_0=L\), carry the balance forward one period at a time, and identify the exact point in the payment cycle at which the valuation date falls. This keeps the meaning of each balance tied to the loan transactions that have actually occurred.

Check Your Understanding

For each problem, identify the valuation convention and use the stated schedule terms.

  1. A $2,000 loan earns 5% effective interest per year. A $700 payment is made at the end of year 1. Find the balance immediately after that payment. (Answer: $1,400)
  2. A $4,000 loan earns 2% effective interest per quarter. Payments of $1,100 are made at the ends of the first and second quarters. Find the balance immediately after the second payment. (Answer: $1,939.60)
  3. A $7,500 loan earns 3% effective interest per half-year. Payments of $2,500 and $3,000 are made at the ends of the first and second half-years. Find the balance immediately after the second payment. (Answer: $2,381.75)
  4. A $1,200 loan earns 0.5% effective interest per month. Payments of $300 are made at the ends of months 1 and 2. Find the balance immediately after the second payment. (Answer: $610.53)
  5. A $6,000 loan earns 10% effective interest per year. A $2,500 payment is made at the end of year 1, followed by a $2,000 payment at the end of year 2. Find the balances immediately before and immediately after the year-2 payment. (Answer: $4,510 before; $2,510 after)
Clinical Biostats