Deriving the Retrospective Balance Formula

Why Accumulate Past Cash Flows?

A loan balance at a payment date can be calculated by looking forward at payments still due or by looking backward at the original principal and installments already paid. The retrospective method uses the second view: move the original loan and every past payment forward to the date at which the balance is measured. This approach is especially useful when the past installments are not all equal.

The essential timing rule is that each cash flow is accumulated for the number of interest periods between its date and the balance date. A payment made at the balance date has no time to earn interest after it is made. A payment made one period earlier is accumulated for one period, and so on.

Definition: Suppose a loan has original principal $L$, a constant effective interest rate per payment period $i$, and installments $R_1,R_2,\ldots$ paid at the ends of periods $1,2,\ldots$. Let $B_k$ be the outstanding balance immediately after the $k$th installment. Under this timing convention, the retrospective balance is the accumulated value of the original principal less the accumulated value of the first $k$ installments.

The formula assumes the loan earns interest at the same rate $i$ in every payment period, and that the installments are made on the stated period ends. The rate must be expressed per payment period. For example, if installments are monthly, use the effective monthly rate, not an annual rate inserted without conversion. If a payment is missed, made on a different date, or subject to a different rate period, the simple formula below needs adjustment.

The derivation starts with the balance recurrence. During each period, the previous balance earns interest; the installment is then subtracted at the end of that period. Thus, for period $t$,

B_t=(1+i)B_{t-1}-R_t,\qquad B_0=L.

Substituting this relation repeatedly shows exactly how much each cash flow contributes to the balance at time $k$.

Accumulate the original principal.
The principal $L$ is present for all $k$ periods, so its value at time $k$, before subtracting past installments, is $L(1+i)^k$.

Accumulate the first installment.
The payment $R_1$ is made at time 1. It earns interest for the remaining $k-1$ periods, contributing $R_1(1+i)^{k-1}$ at time $k$.

Accumulate every other installment.
In general, $R_j$ is made at time $j$, so it earns interest for $k-j$ periods and contributes $R_j(1+i)^{k-j}$.

Subtract the accumulated installments.
Each payment reduces the loan. Therefore, the balance is the accumulated principal minus the sum of the accumulated payments.

The resulting formula is

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

The exponent $k-j$ is the number of periods from the date of installment $j$ to the balance date. In particular, the last installment $R_k$ has exponent zero, so it is subtracted without further accumulation.

The formula can also be verified directly by induction. It is true at $k=0$, since $B_0=L$. Assume it holds at $k-1$. The recurrence gives

\begin{aligned} B_k &=(1+i)\left[L(1+i)^{k-1} -\sum_{j=1}^{k-1}R_j(1+i)^{k-1-j}\right]-R_k\\ &=L(1+i)^k-\sum_{j=1}^{k-1}R_j(1+i)^{k-j}-R_k\\ &=L(1+i)^k-\sum_{j=1}^{k}R_j(1+i)^{k-j}. \end{aligned}

This establishes the expression for every nonnegative integer $k$. It also explains why each payment is accumulated only from its own payment date: the recurrence applies interest to the balance that remains after the previous installment.

Equal Installments as a Special Case

If every installment is the same amount $R$, the accumulated value of the $k$ installments is $R$ times the accumulated value of an annuity-immediate. With the standard notation $s_{\overline{k}|}$, the balance becomes

B_k=L(1+i)^k-Rs_{\overline{k}|}, \qquad s_{\overline{k}|}=\frac{(1+i)^k-1}{i}\quad (i\ne 0).

This is just a compact form of the retrospective formula, not a different balance principle. If $i=0$, each payment is accumulated by a factor of one, so $B_k=L-kR$; the quotient expression for $s_{\overline{k}|}$ is not used at zero interest.

Worked Example: Accumulating Three Past Installments

A loan of \$10,000 is repaid with three end-of-year installments of \$2,300. The effective annual interest rate is 5%. Find the balance immediately after the third installment using the retrospective method, and verify the result by the recurrence.

Method. Accumulate the principal for three years, then subtract each installment accumulated from its payment date to the end of year 3. The first payment earns interest for two years, the second for one year, and the third for none.

The accumulated principal is

10{,}000(1.05)^3 =10{,}000(1.157625) =\$11{,}576.25.

The first installment accumulates to

2{,}300(1.05)^2 =2{,}300(1.1025) =\$2{,}535.75.

The second installment accumulates to

2{,}300(1.05)=\$2{,}415.00,

and the third installment remains \$2,300.00 at the balance date. The total accumulated installments are

2{,}535.75+2{,}415.00+2{,}300.00=\$7{,}250.75.

Therefore,

B_3=11{,}576.25-7{,}250.75=\boxed{\$4{,}325.50}.

Check by recurrence. After year 1, $B_1=10{,}000(1.05)-2{,}300=\$8{,}200$. After year 2, $B_2=8{,}200(1.05)-2{,}300=\$6{,}310$. After year 3, $B_3=6{,}310(1.05)-2{,}300=\$4{,}325.50$, agreeing with the retrospective calculation. The main timing trap is giving the first installment three years of accumulation: it was paid at the end of year 1, so it earns interest for only two years.

Unequal Installments and Unknown Payments

The summation form is useful when installments vary. No level-payment assumption is needed: each $R_j$ is accumulated separately using its own time to the balance date. It can also be rearranged to find an unknown installment when the principal, rate, other installments, and balance are known.

Worked Example: A Loan with Unequal Installments

A \$20,000 loan charges an effective rate of 4% per year. The borrower pays \$5,000 at the end of year 1 and \$6,000 at the end of year 2. Find the balance immediately after the second payment.

Method. Use $k=2$. The principal accumulates for two years, the first payment for one year, and the second payment for zero years:

\begin{aligned} B_2 &=20{,}000(1.04)^2-5{,}000(1.04)-6{,}000\\ &=20{,}000(1.0816)-5{,}200-6{,}000\\ &=21{,}632-5{,}200-6{,}000\\ &=\boxed{\$10{,}432}. \end{aligned}

Check by recurrence. After year 1, $B_1=20{,}000(1.04)-5{,}000=\$15{,}800$. Then $B_2=15{,}800(1.04)-6{,}000=16{,}432-6{,}000=\$10{,}432$. This agrees. The installments differ, but the retrospective expression still applies because it does not require equal payments.

Worked Example: Recovering an Unknown Installment

A \$10,000 loan has an effective interest rate of 10% per period. Payments are made at the ends of periods 1, 2, and 3. The first payment is \$2,000, the third is \$3,000, and the balance immediately after the third payment is \$6,240. Find the second payment.

Method. Accumulate the principal and known payments to time 3, then solve the retrospective equation for the unknown second payment $R_2$. The original principal accumulates for three periods; the first payment for two; and $R_2$ for one.

\begin{aligned} 6{,}240 &=10{,}000(1.10)^3-2{,}000(1.10)^2-R_2(1.10)-3{,}000\\ &=13{,}310-2{,}420-1.10R_2-3{,}000\\ &=7{,}890-1.10R_2. \end{aligned}

Rearrange and solve:

1.10R_2=7{,}890-6{,}240=1{,}650, \qquad R_2=\frac{1{,}650}{1.10}=\boxed{\$1{,}500}.

Check. The accumulated payments are $2{,}000(1.10)^2=\$2{,}420$, $1{,}500(1.10)=\$1{,}650$, and \$3,000. Their total is \$7,070. The accumulated principal is \$13,310, so the balance is $13{,}310-7{,}070=\$6{,}240$, as specified. The common mistake is to accumulate $R_2$ for two periods; it is paid at time 2, so only one period remains before the time-3 balance.

Common Exam Traps

Using the wrong exponent. At time $k$, installment $R_j$ is multiplied by $(1+i)^{k-j}$, not $(1+i)^k$. Exponents count periods after the payment, not periods since the loan began.
Accumulating a payment made on the balance date. The final installment has exponent zero and is subtracted as $R_k$. Giving it another period of interest changes the balance incorrectly.
Mixing annual and payment-period rates. The $i$ in the formula is the effective rate for one interval between scheduled payments. Confirm the payment frequency before substituting a rate.
Assuming equal payments without checking. The summation formula works for unequal installments. Use $Rs_{\overline{k}|}$ only when all $k$ payments are equal.
Subtracting payments before accumulating the principal without tracking dates. The recurrence is a useful audit: after each period, multiply the current balance by $1+i$, then subtract that period’s payment.

Key takeaway: At a balance date $k$, accumulate the original principal for $k$ periods and subtract each installment accumulated for exactly the number of periods since it was paid. For end-of-period installments under a constant rate, this gives $B_k=L(1+i)^k-\sum_{j=1}^{k}R_j(1+i)^{k-j}$.

The retrospective formula is aligned with the SOA Exam FM (Financial Mathematics) syllabus. Its main value is keeping the timing of every past cash flow explicit; writing the payment dates and exponents before calculating is often the simplest way to avoid an otherwise costly error.

Check Your Understanding

For each problem, use the stated effective rate per payment period and measure the balance immediately after the final listed payment.

A \$8,000 loan earns 5% per period. The first two end-of-period payments are \$2,000 and \$2,500. Find the balance after the second payment. (Answer: \$4,220)
A \$15,000 loan earns 4% per period and has payments of \$3,000 and \$4,000 at the ends of periods 1 and 2. Find the balance after payment 2. (Answer: \$9,104)
A \$12,000 loan earns 5% per period and has three payments: \$3,000, \$3,500, and \$4,000. Find the balance after payment 3. (Answer: \$2,909)
A \$10,000 loan earns 6% per period. The first two payments are \$2,500 and \$3,000. What final payment at the end of period 3 will exactly repay the loan? (Answer: \$5,921)
A \$9,000 loan earns 3% per period and has four payments: \$1,000, \$1,500, \$2,000, and \$2,500. Find the balance after payment 4, to the nearest cent. (Answer: \$2,885.50)

Deriving the Retrospective Balance Formula

What You'll Learn

Why Accumulate Past Cash Flows?