Tutorials › Exam FM - Financial Mathematics › Common Errors in Outstanding-Balance Calculations

Home  /  Tutorials  /  Exam FM / Outstanding Balance Methods

Exam FM · Outstanding Balance Methods · Tutorial 276 of 998

Common Errors in Outstanding-Balance Calculations

Learn to locate balance-calculation errors by fixing the valuation date, tracking each payment’s timing, and checking retrospective results against remaining cash flows.

Intermediate 10 min read

What You'll Learn

  • Distinguish a balance immediately before a payment from one immediately after it.
  • Apply retrospective accumulation without omitting or mistiming past payments.
  • Use prospective valuation only for payments remaining after the balance date.
  • Match each interest rate to the period over which it applies.
  • Verify calculations by rolling balances forward one period at a time.
  • Diagnose common wrong calculations and explain the correction.

Why Outstanding-Balance Errors Happen

An outstanding loan balance is a value at a particular time. A calculation can use the correct cash flows and still be wrong if it places a payment on the wrong date, leaves a payment out, or applies an interest rate for the wrong length of time. Before calculating, identify the balance date and whether the balance is measured immediately before or immediately after any payment due on that date.

Two standard approaches are useful for checking a balance. The retrospective method accumulates the original loan and subtracts accumulated past payments. The prospective method discounts payments still due after the balance date. Both methods must use the same valuation date and the same contractual cash flows.

Definition: Let \(B_t^-\) denote the outstanding balance at time \(t\) immediately before a payment at that time, and let \(B_t^+\) denote the balance immediately after that payment. If the payment at time \(t\) is \(R_t\), then \(B_t^+=B_t^- - R_t\). A payment at time \(t\) is included in the retrospective calculation of \(B_t^+\), but is not included in the prospective value of payments remaining after \(t\).

In the examples below, payments are positive amounts made by the borrower, and the balance is the amount owed. Unless stated otherwise, interest is effective over the specified period, payments occur at the stated dates, and there are no fees or additional transactions. These assumptions matter: a different payment date or rate convention changes the balance.

A Date-Based Check for Every Calculation

For a loan with effective interest rate \(i\) per period and a payment \(R_k\) at the end of period \(k\), the retrospective balance immediately after payment \(k\) is

$$ B_k^+ = L(1+i)^k-\sum_{j=1}^{k}R_j(1+i)^{k-j}, $$

where \(L\) is the original loan at time 0. The payment at time \(k\) has exponent zero because it is made on the balance date. Earlier payments accumulate to that date. For a prospective calculation, if \(R_{k+1},\ldots,R_n\) are all remaining payments and the same rate applies, then

$$ B_k^+ = \sum_{j=k+1}^{n}R_j(1+i)^{-(j-k)}. $$

This prospective formula assumes the listed future payments fully repay the loan and that the rate and payment schedule used are the contractual ones. It does not include a payment made at time \(k\), since the balance is measured after that payment. If a payment is due at time \(k\) and the balance is instead measured immediately before it, that payment is included in the prospective value and in \(B_k^-\).

Check: For a payment at the end of a period, first accumulate the balance at the previous date, then subtract the payment: \(B_k^-=(1+i)B_{k-1}^+\) and \(B_k^+=B_k^- - R_k\). When the payment dates or interest periods are irregular, replace \(1+i\) with the accumulation factor that applies over the actual time interval.

The recurrence gives a short justification for the retrospective formula. Start with \(B_0^+=L\). At each period, the amount owed grows by the period’s accumulation factor and then the payment is subtracted. Repeating those two operations carries the original loan forward to the balance date and carries each payment forward only from its own date. Subtracting all those accumulated payments from the accumulated original loan therefore gives the amount still owed.

Worked Examples: Find the Date Error Before the Arithmetic

Worked Example: Before and After the Same Payment

A loan of $1,000 charges an effective annual interest rate of 10%. The borrower pays $250 at the end of year 1 and $250 at the end of year 2. Find the balance immediately before and immediately after the year-2 payment.

Method. Use the retrospective method, keeping the two balance dates distinct. The original loan accumulates for two years:

$$ 1{,}000(1.10)^2=1{,}210. $$

The year-1 payment accumulates for one year to the end of year 2:

$$ 250(1.10)=275. $$

Immediately before the year-2 payment, only the year-1 payment has been subtracted:

$$ B_2^- =1{,}210-275=935. $$

The year-2 payment is made on the balance date, so it is subtracted without further accumulation:

$$ B_2^+=935-250=685. $$

Check and common mistake. Rolling forward gives \(B_1^+=1{,}000(1.10)-250=850\), then \(B_2^-=850(1.10)=935\), and \(B_2^+=935-250=685\). A wrong calculation might use \(1{,}210-250-250=710\), treating the year-1 payment as if it had not accumulated. That also leads to the incorrect pre-payment balance of $960 after adding the year-2 payment back. The correct balances are $935 before and $685 after the year-2 payment.

Worked Example: Detecting an Omitted Past Payment

A loan of $5,000 earns an effective annual rate of 8%. Payments of $1,200 and $1,800 are made at the ends of years 1 and 2, respectively. A single final payment of $2,954.88 is scheduled at the end of year 3. Find the balance immediately after the year-2 payment and check it prospectively.

Method. First use the retrospective method. Accumulating the loan to the end of year 2 gives

$$ 5{,}000(1.08)^2=5{,}000(1.1664)=5{,}832. $$

The year-1 payment accumulates one year:

$$ 1{,}200(1.08)=1{,}296. $$

The year-2 payment is made on the valuation date, so its accumulated value at that date is $1,800. Therefore,

$$ B_2^+=5{,}832-1{,}296-1{,}800=2{,}736. $$

Now check prospectively. There is one payment remaining, due one year after the balance date. Its present value at the end of year 2 is

$$ \frac{2{,}954.88}{1.08}=2{,}736. $$

The two methods agree. The final payment is consistent with the balance because \(2{,}736(1.08)=2{,}954.88\).

Common mistake avoided. Omitting the year-1 payment would give \(5{,}832-1{,}800=4{,}032\), which is $1,296 too high. A useful diagnostic is to check that every past payment appears once in the retrospective formula, accumulated from its payment date to the balance date. The prospective check also prevents accidentally using a past payment as though it were still due.

Worked Example: Matching a Nominal Rate to Monthly Payments

A $10,000 loan has a nominal annual interest rate of 12% convertible monthly. Payments of $3,200 are made at the ends of months 1, 2, and 3. Find the balance immediately after the third payment.

Method. A nominal rate of 12% convertible monthly gives a monthly rate of \(0.12/12=0.01\), or 1% per month. The payment periods are months, so use 1% for each monthly accumulation.

At the end of month 1, after the first payment,

$$ B_1^+=10{,}000(1.01)-3{,}200=6{,}900. $$

At the end of month 2, after the second payment,

$$ B_2^+=6{,}900(1.01)-3{,}200=3{,}769. $$

At the end of month 3, after the third payment,

$$ B_3^+=3{,}769(1.01)-3{,}200=3{,}806.69-3{,}200=606.69. $$

Check by accumulating all cash flows to the end of month 3. The loan accumulates to \(10{,}000(1.01)^3=10{,}303.01\). The three payments accumulate to \(3{,}200(1.01)^2=3{,}264.32\), \(3{,}200(1.01)=3{,}232\), and $3,200. Thus

$$ 10{,}303.01-(3{,}264.32+3{,}232+3{,}200)=606.69. $$

Common mistake avoided. Applying 12% as a monthly rate confuses an annual nominal quote with a monthly effective rate. That incorrect calculation would give \(10{,}000(1.12)^3-3{,}200[(1.12)^2+1.12+1]=3{,}251.20\), not $606.69. The rate must be converted according to its stated compounding convention before it is used with monthly periods.

A Practical Error-Diagnosis Procedure

A balance calculation is easier to audit when the cash-flow dates are made explicit before any formula is applied. The following sequence catches the most frequent errors without requiring a different loan model.

1
Mark the balance date and boundary.
Write whether the requested value is immediately before or after any payment on that date. The difference is exactly that payment.
2
List the included cash flows.
For a retrospective balance, include the original loan and every payment made by the balance date. For a prospective balance, include only payments remaining after the date, with a payment on the date included only for a before-payment balance.
3
Match rates to time intervals.
Convert nominal rates using their stated compounding frequency. Use the rate or accumulation factor appropriate to each period between cash-flow dates.
4
Apply timing before rounding.
Accumulate or discount each payment from its own date. Do not round intermediate balances unless the contract specifies rounded payments or balances.
5
Check independently.
Roll the balance forward period by period, or compare a retrospective value with the prospective value of the remaining contractual payments when those payments fully repay the loan.

The retrospective and prospective values are not automatically equal for an arbitrary collection of payments. Their equality assumes the loan amount and payment schedule satisfy the loan cash-flow equation at the interest rate used. If a payment schedule includes a balloon, an unpaid amount, or a final overpayment, the balance calculation must reflect that feature rather than force the two methods to agree.

Common Mistakes to Watch For

  • Mixing pre-payment and post-payment balances. A payment at the balance date separates \(B_t^-\) from \(B_t^+\). Subtract it for the latter, not for the former.
  • Leaving out a payment that was already made. In a retrospective calculation, every past payment reduces the balance after being accumulated to the valuation date.
  • Accumulating a payment for the wrong duration. A payment at the balance date has no time to earn interest before that date; an earlier payment does.
  • Using a rate in the wrong unit. A nominal annual rate convertible monthly is not the monthly rate itself. Convert it before applying monthly accumulation.
  • Including a past payment in a prospective value. A prospective balance values future obligations only. A payment already made is not still owed.
  • Using a check that does not match the contract. A prospective check is valid only when the remaining cash flows and interest assumption are correctly specified and are intended to extinguish the balance.
Key takeaway: Every outstanding-balance error can be investigated by asking three questions: What is the exact valuation date? Which payments have occurred by that date? What accumulation factor applies between each cash-flow date and the balance date?

Check Your Understanding

For each problem, identify the relevant payment dates and use a balance convention that matches the question.

  1. A $2,400 loan earns 6% effective annual interest. Payments of $700 at the end of year 1 and $800 at the end of year 2 have been made. Find the balance immediately after the year-2 payment. (Answer: $1,154.64)
  2. An $8,000 loan has a nominal annual rate of 9% convertible monthly. Payments of $1,000 are made at the ends of months 1 and 2. Find the balance immediately after the month-2 payment. (Answer: $6,112.95)
  3. A $4,000 loan earns 5% effective annual interest. Payments of $500 are made at the ends of years 1 and 2, but no payment is made at the end of year 3. Find the balance at the end of year 3. (Answer: $3,554.25)
  4. A $6,000 loan earns 4% effective annual interest. Payments of $1,000 are made at times 0, 1, and 2, with the first payment made immediately when the loan is issued. Find the balance immediately after the time-2 payment. (Answer: $3,368.00)
  5. A $3,000 loan earns 10% effective annual interest. Payments of $1,000 are made at the ends of years 1 and 2, and a final payment of $1,683 is due at the end of year 3. Find the balance immediately after the year-2 payment using both retrospective and prospective methods. (Answer: $1,530.00 by each method)

Previous

Next

Back to Tutorials
Clinical Biostats