Why Prospective and Retrospective Loan Balances Agree

Two Ways to Measure the Same Loan Balance

A loan balance at a payment date can be calculated in two directions. The prospective method values the payments still due after that date. The retrospective method accumulates the original advance to that date and subtracts the accumulated value of payments already made. Under a consistent loan agreement, the two amounts agree.

This equivalence is useful as both a calculation method and a check. If the methods produce different balances, the discrepancy often points to a timing error, a missing payment, or inconsistent interest assumptions. The result is aligned with the SOA Exam FM (Financial Mathematics) syllabus.

Definition: Consider a loan of $L$ dollars advanced at time $0$, with payments $C_1,C_2,\ldots,C_n$ made at the ends of periods $1,2,\ldots,n$. Assume one constant effective interest rate $i$ per period and let $v=1/(1+i)$. The balance $B_k$ immediately after the payment at time $k$ is the amount that remains owed at that instant. Payments are positive amounts paid by the borrower to the lender.

The model assumes a fixed rate per period, payments on the stated period dates, and no separate fees or transactions. The loan is fully repaid by its scheduled cash flows, so the original advance equals the present value of all scheduled payments. If a fee, extra payment, or other cash flow is part of the agreement, it must be included consistently in the cash-flow record. These formulas do not directly describe balances between payment dates or loans whose rate changes; those require matching the accumulation to the actual timing and rate structure.

The Retrospective Balance

Start with the original advance $L$. Accumulate it for $k$ periods to obtain $L(1+i)^k$, the amount it would have grown to at time $k$ if no payments had been made. A payment $C_j$ made at time $j$ accumulates for $k-j$ periods by time $k$, giving $C_j(1+i)^{k-j}$. Subtract each such accumulated payment from the accumulated advance.

B_k=L(1+i)^k-\sum_{j=1}^{k} C_j(1+i)^{k-j}.

This is the retrospective balance. The payment made at time $k$ is included in the sum with exponent zero: it is subtracted at its amount, since no time has elapsed for it to earn interest. This makes $B_k$ the balance just after that payment.

The Prospective Balance and Why It Agrees

At time $k$, each remaining payment $C_j$, for $j>k$, is discounted back $j-k$ periods. The sum of those present values is the prospective balance. Its equality to the retrospective balance follows directly from the original loan equation.

Theorem: If the loan is issued for $L$ at time $0$, earns the same effective rate $i$ per period, and is fully repaid by the scheduled payments, then at each payment date $k$, $$ B_k=\sum_{j=k+1}^{n} C_jv^{j-k} =L(1+i)^k-\sum_{j=1}^{k} C_j(1+i)^{k-j}. $$ The balance is measured immediately after the payment at time $k$.

Justification. Because the payments repay the original advance, their values at time $0$ satisfy $L=\sum_{j=1}^{n}C_jv^j$. Multiply both sides by $(1+i)^k$. For payments at or before time $k$, $j\leq k$, the resulting term is $C_j(1+i)^{k-j}$. For later payments, $j>k$, the term is $C_jv^{j-k}$, since $(1+i)^k v^j=v^{j-k}$. Therefore,

L(1+i)^k =\sum_{j=1}^{k}C_j(1+i)^{k-j} +\sum_{j=k+1}^{n}C_jv^{j-k}.

Rearranging gives the retrospective expression on one side and the prospective expression on the other. The equality is not a separate assumption about balances: it follows from valuing the same contract cash flows at the same date and rate.

Fix the focal date.
Specify the payment date $k$, and state whether the balance is immediately before or immediately after its scheduled payment.

Choose a direction.
For a retrospective calculation, accumulate the advance and each past payment to $k$. For a prospective calculation, discount each remaining payment to $k$.

Use consistent cash flows and rate units.
Include all relevant payments and use an effective rate for the stated period.

Check the result.
When the schedule fully repays the advance, the two balances must agree before rounding.

Worked Applications

Worked Example: Checking a Balance After Two Payments

A borrower receives $L=\$10{,}000$. Interest is 10% effective per year. The borrower pays $\$4{,}000$ at the end of year 1, another $\$4{,}000$ at the end of year 2, and pays the remaining balance at the end of year 3. Find the balance immediately after the year-2 payment, using both methods, and determine the final payment.

Method. Apply retrospective accumulation to the advance and the two past payments, then verify with the present value of the remaining payment.

Retrospective calculation. At time 2, the advance has accumulated for two years. The year-1 payment has accumulated for one year, while the year-2 payment has accumulated for zero years.

B_2=10{,}000(1.10)^2-4{,}000(1.10)-4{,}000 =12{,}100-4{,}400-4{,}000 =\$3{,}700.

Prospective calculation and final payment. Let $C_3$ be the year-3 payment. The balance at time 2 must accumulate for one year to equal that payment, so $C_3=3{,}700(1.10)=\$4{,}070$. Discounting this remaining payment to time 2 gives

B_2=\frac{4{,}070}{1.10}=\$3{,}700.

The methods agree. As a further check, the final payment extinguishes the balance because $3{,}700(1.10)-4{,}070=0$. The common mistake avoided here is leaving the year-2 payment out of the retrospective sum or accumulating it for an extra year.

Worked Example: Unequal Payments and a Final Payoff

A loan of $\$12{,}000$ earns 8% effective per year. Payments of $\$1{,}000$, $\$2{,}500$, and $\$2{,}000$ are made at the ends of years 1, 2, and 3. Find the balance immediately after the year-3 payment and the payoff required at the end of year 4.

Method. Use the retrospective method for the year-3 balance, then accumulate that balance one year to find the payoff. This schedule has unequal payments, but the equality does not require level payments.

Retrospective calculation. The original advance accumulates for three years. The first payment accumulates for two years, the second for one year, and the third for zero years.

\begin{aligned} B_3 &=12{,}000(1.08)^3-1{,}000(1.08)^2-2{,}500(1.08)-2{,}000\\ &=15{,}116.544-1{,}166.400-2{,}700-2{,}000\\ &=\$9{,}250.144. \end{aligned}

Prospective check and payoff. If $C_4$ is the payoff one year later, then $C_4=B_3(1.08)=\$9{,}990.15552$. The prospective value at time 3 is

\frac{9{,}990.15552}{1.08}=\$9{,}250.144=B_3.

To the nearest cent, the balance is $\$9{,}250.14$ and the payoff is $\$9{,}990.16$. The calculations retain full precision until the final reporting step. The common mistake avoided is treating the unequal payments as if they occurred at the same date or grew for the same number of years.

Worked Example: Finding Equal Remaining Payments From the Balance

A borrower receives $\$12{,}000$ at time 0 at an effective annual rate of 10%. A payment of $\$3{,}200$ is made at the end of year 1. The loan is then repaid by equal payments $X$ at the ends of years 2 and 3. Find $X$, and check the year-1 balance both ways.

Method. First calculate the balance immediately after the known payment retrospectively. Then set that balance equal to the present value at time 1 of the two equal remaining payments.

Retrospective balance at time 1.

B_1=12{,}000(1.10)-3{,}200 =13{,}200-3{,}200 =\$10{,}000.

Prospective equation. The year-2 payment is discounted one period and the year-3 payment two periods. Thus

\begin{aligned} 10{,}000 &=Xv+Xv^2\\ &=X\left(\frac{1}{1.10}+\frac{1}{(1.10)^2}\right)\\ &=X\left(\frac{10}{11}+\frac{100}{121}\right) =X\left(\frac{210}{121}\right). \end{aligned}

Therefore, $X=10{,}000(121/210)=5{,}761.904761\ldots$, or $\$5{,}761.90$ to the nearest cent.

Check. Using the unrounded payment, the prospective value at time 1 is $5{,}761.904761\ldots(210/121)=\$10{,}000$, equal to the retrospective balance. If the rounded payment is used instead, a small rounding residual may remain; it is not a failure of the balance identity. The common mistake avoided is discounting the year-2 payment two periods rather than one from the year-1 focal date.

Common Errors and Practical Checks

The retrospective and prospective methods are especially useful together when a payment history is complicated. A calculation should use one clearly stated focal date and a consistent record of cash flows. For example, an amount paid at time $j$ contributes $C_j(1+i)^{k-j}$ to the retrospective sum at time $k$; its exponent is determined by the time between the payment and the focal date.

Issue	Incorrect approach	Correction
Balance timing	Calling the amount before a payment the balance after it	For the after-payment balance, subtract the payment at time $k$ with exponent zero.
Accumulation period	Accumulating every past payment for $k$ periods	Accumulate payment $C_j$ for exactly $k-j$ periods.
Discount period	Discounting every remaining payment from time 0	From focal date $k$, discount $C_j$ for $j-k$ periods.
Rate units	Using an annual effective rate as though it were a monthly rate	Match the rate per period to the period length in the payment schedule.
Incomplete cash flows	Omitting an extra payment or contractual amount	Include each amount that changes the loan’s value at the chosen date.

A negative retrospective balance can indicate that accumulated payments exceed the accumulated advance. In a scheduled loan, that may signal an overpayment or a cash-flow entry error. Similarly, if the two methods disagree beyond rounding, check payment dates and amounts before changing the interest rate or the balance definition.

Key takeaway: At a payment date, the balance after the payment is both the accumulated original advance less accumulated past payments and the present value of the remaining payments. The identity holds when the contract cash flows and interest basis are consistent.

Check Your Understanding

For each problem, state the focal date and use the payment timing specified.

A loan of $\$8{,}000$ earns 5% effective annually. The borrower pays $\$3{,}000$ at the ends of years 1 and 2. Find the balance immediately after the year-2 payment and the payoff at the end of year 3. (Answer: balance $\$2{,}670.00$; payoff $\$2{,}803.50$)
A loan of $\$10{,}000$ earns 6% effective per half-year period. Payments of $\$2{,}500$ and $\$3{,}000$ are made at the ends of periods 1 and 2. Find the balance immediately after the second payment and the payoff one period later. (Answer: balance $\$5{,}586.00$; payoff $\$5{,}921.16$)
A loan of $\$9{,}000$ earns 10% effective annually. Payments of $\$2{,}000$, $\$2{,}500$, and $\$3{,}000$ are made at the ends of years 1, 2, and 3. Find the balance just after the year-3 payment and the payoff at year 4. (Answer: balance $\$3{,}809.00$; payoff $\$4{,}189.90$)
A loan of $\$15{,}000$ earns 5% effective annually. A $\$4{,}000$ payment is made at year 1, followed by equal payments $X$ at years 2 and 3. Find $X$ by equating the year-1 balance to the present value of the remaining payments. (Answer: $X=\$6{,}319.21$)
A loan of $\$5{,}000$ earns 8% effective annually. Payments of $\$1{,}200$ are made at the ends of years 1 and 2. A statement reports a balance of $\$4{,}000$ immediately after the second payment. Check the reported balance retrospectively and find the year-3 payoff implied by the actual cash flows. (Answer: balance $\$3{,}336.00$, not $\$4{,}000.00$; payoff $\$3{,}602.88$)

What You'll Learn