Retrospective Balances from Past Cash Flows

Why a Retrospective Balance Uses a Focal Date

A loan balance is a value measured at a particular date. When payments have different amounts or dates, subtracting their original dollar amounts from the advance does not give that value: earlier dollars and later dollars have had different amounts of time to accrue interest. The retrospective method resolves this by carrying the advance and every payment to one common date, then comparing their accumulated values.

This approach is useful when a payment history is known but the balance is not, or when a lender or borrower wants to check whether a stated balance is consistent with the cash flows. It is particularly direct when payments are irregular: the payment schedule need not be level or periodic.

Definition: A retrospective balance at date $T$ is the accumulated value at $T$ of the original loan advance, less the accumulated values at $T$ of all loan payments made on or before $T$. The focal date $T$ is the date at which the balance is measured.

Model and Calculation Rule

For the calculations in this tutorial, assume a loan has one original advance at time 0 and a constant effective annual interest rate $i$. Payments are made at times $t_1,t_2,\ldots,t_n$, measured in years from the advance, where each $t_j$ is no later than the balance date $T$. Assume the loan accumulates at rate $i$ between cash-flow dates, and a payment reduces the debt dollar for dollar when it is made. A payment made on the balance date is therefore included at its amount, without further accumulation.

With annual compounding over whole-year intervals, a cash flow at time $t$ accumulates to time $T$ by the factor $(1+i)^{T-t}$. The same factor with a fractional exponent can be used for a fractional-year interval when the loan contract specifies that fractional-period convention. If the rate changes, the correct accumulation factor must reflect the rates applying over each interval; a single factor $(1+i)^{T-t}$ would not describe that model.

Let $L$ be the original advance and let $P_j$ be the amount of the $j$th payment. Use the convention that the advance is a positive amount borrowed and payments are amounts that reduce the balance. The balance at time $T$ is:

B_T=L(1+i)^T-\sum_{j=1}^{n}P_j(1+i)^{T-t_j}.

The exponent for each cash flow is its own elapsed time from the cash-flow date to the focal date. In particular, the advance accumulates for $T$ years, a payment at $t_j$ accumulates for $T-t_j$ years, and a payment at $T$ has factor $(1+i)^0=1$. If there are no payments, the sum is zero. A negative result would mean the accumulated payments exceed the accumulated advance under this model; it should prompt a check of the cash-flow data or the interpretation of the loan.

Why the Accumulation Formula Holds

The formula follows by updating the balance forward from one cash-flow date to the next. Let $B_{j-1}$ be the balance immediately after the previous cash flow, and let the next payment $P_j$ occur at $t_j$. First the debt accumulates from $t_{j-1}$ to $t_j$; then the payment is subtracted:

B_j=B_{j-1}(1+i)^{t_j-t_{j-1}}-P_j.

Starting from the original advance, this recursion gives each earlier balance component its accumulation to the next date, and subtracts each payment when it occurs. If the resulting balance is then carried to $T$, the advance has accumulated from 0 to $T$, while payment $P_j$ has accumulated only from $t_j$ to $T$. Thus its contribution to the balance at $T$ is subtracted as $P_j(1+i)^{T-t_j}$, which gives the stated retrospective formula. The key is that every term is valued at the same date.

Choose the balance date.
Identify $T$ and measure each cash-flow date from the date of the original advance.

Accumulate the advance.
Carry the original advance forward from time 0 to $T$.

Accumulate each payment separately.
For a payment at $t_j$, use its amount multiplied by the accumulation factor for $T-t_j$ years.

Subtract the accumulated payments.
Subtract their total from the accumulated advance and check that the answer is consistent with the cash-flow history.

Worked Retrospective Balances

Worked Example: Unequal Payments at Different Dates

A hypothetical loan advances $20,000 at time 0 and accumulates at an effective annual interest rate of 6%. The borrower pays $4,000 at the end of year 1 and $5,000 at the end of year 2. Find the balance immediately after the end-of-year-3 date. Round the final result to the nearest cent.

Method. Accumulate the advance and both payments to year 3. The payment at year 1 has two years to accumulate; the payment at year 2 has one year.

B_3=20{,}000(1.06)^3-4{,}000(1.06)^2-5{,}000(1.06).

The accumulated advance is $20{,}000(1.06)^3=20{,}000(1.191016)=23{,}820.32$. The first payment accumulates to $4{,}000(1.06)^2=4{,}000(1.1236)=4{,}494.40$. The second payment accumulates to $5{,}000(1.06)=5{,}300.00$.

B_3=23{,}820.32-4{,}494.40-5{,}300.00=14{,}025.92.

Check. The accumulated payments total $9,794.40, which is less than the $23,820.32 accumulated advance. Their difference is $14,025.92, so the balance is $14,025.92. The common mistake avoided here is subtracting the original payment amounts, $4,000 and $5,000, without allowing either payment to accumulate to year 3.

Worked Example: An Irregular Payment Schedule

A hypothetical borrower receives an advance of $30,000 at time 0. The loan rate is an effective annual rate of 5%. The borrower makes a $5,000 payment at the end of year 1 and an $8,000 payment at the end of year 3. Find the balance immediately after the end-of-year-4 date. Round the final result to the nearest cent.

Method. Use the actual date of each payment rather than treating the payments as though they were evenly spaced. At year 4, the advance has accumulated for four years, the first payment for three years, and the second payment for one year.

B_4=30{,}000(1.05)^4-5{,}000(1.05)^3-8{,}000(1.05).

The accumulation factors are $(1.05)^4=1.21550625$, $(1.05)^3=1.157625$, and $1.05$. Therefore, the accumulated advance is $30{,}000(1.21550625)=36{,}465.1875$. The year-1 payment accumulates to $5{,}000(1.157625)=5{,}788.125$. The year-3 payment accumulates to $8{,}000(1.05)=8{,}400$.

B_4=36{,}465.1875-5{,}788.125-8{,}400=22{,}277.0625.

Rounded to the nearest cent, the balance is $22,277.06. As a check, the two accumulated payments total $14,188.125; subtracting that amount from $36,465.1875 gives $22,277.0625. The common mistake avoided is assigning a payment the wrong accumulation period: the year-3 payment has one year to accumulate, not three or four.

Worked Example: Finding an Unknown Past Payment

A hypothetical loan of $20,000 is issued at time 0 and accumulates at an effective annual rate of 5%. A payment of $3,000 is made at the end of year 1, an unknown payment $X$ is made at the end of year 2, and a final payment of $2,000 is made at the end of year 3. The balance immediately after the year-3 payment is $13,645. Find $X$.

Method. Write the retrospective balance equation at year 3. The payment at year 3 is included at face value because it is made on the balance date.

13{,}645=20{,}000(1.05)^3-3{,}000(1.05)^2-X(1.05)-2{,}000.

The accumulated advance is $20{,}000(1.157625)=23{,}152.50$. The year-1 payment accumulates to $3{,}000(1.1025)=3{,}307.50$. Subtracting those known amounts and the year-3 payment gives:

$$ 23{,}152.50-3{,}307.50-2{,}000=17{,}845. $$

The equation becomes $13{,}645=17{,}845-1.05X$. Therefore $1.05X=17{,}845-13{,}645=4{,}200$, and $X=4{,}200/1.05=4{,}000$.

Check. Substituting $X=4{,}000$, its accumulated value at year 3 is $4{,}000(1.05)=4{,}200$. Then $17{,}845-4{,}200=13{,}645$, as required. The unknown payment is $4,000. The common mistake avoided is accumulating the unknown payment for three years: it occurs at year 2, so it accumulates for only one year.

Common Timing Errors and Practical Checks

Retrospective calculations are mechanically simple once the focal date is fixed, but a small timing error can change the result. Before evaluating the arithmetic, label the date of each cash flow and count the periods from that date to $T$. Do not use the payment number as its time: an irregular schedule may have a first payment after two years or several payments in a single year.

A frequent incorrect calculation is to subtract nominal payments from the original advance and then accumulate the remainder. That treats every payment as though it had been made at time 0. Another incorrect approach is to accumulate all payments for the same number of years. For example, at year 4 a payment made in year 1 accumulates for three years, while one made in year 3 accumulates for only one year.

Also distinguish the balance immediately before a payment from the balance immediately after it. At the payment date, the payment has no time to earn interest before the balance is measured. If the balance is specified immediately after that payment, subtract the payment once at its full amount. If the balance is specified immediately before it, do not subtract it yet.

Write the focal date first. Every amount in the final comparison must be a value at that date.
Give each cash flow its own exponent. Use the time remaining from its date to the focal date.
Keep signs consistent. The advance increases the debt; payments reduce it.
Check the date convention. A payment on the balance date has exponent zero and is included only if the balance is after the payment.
Check the model. A single constant-rate factor is not appropriate if the loan has a changing rate or a different contractual accumulation rule.

The retrospective method is a ledger calculation: it translates past cash flows to a common date rather than valuing future payments. That makes it an efficient independent check on a stated balance when the original advance, payment amounts, dates, and applicable interest model are known. These methods and calculations are aligned with the SOA Exam FM (Financial Mathematics) syllabus.

Check Your Understanding

For each problem, identify the balance date and accumulate every cash flow to that date before subtracting. Round monetary answers to the nearest cent when needed.

A hypothetical $10,000 loan is issued at time 0 at an effective annual rate of 5%. A $2,000 payment is made at the end of year 1. Find the balance immediately after the end of year 2. (Answer: $8,925.00)
A hypothetical $16,000 advance accumulates at an effective annual rate of 6%. Payments of $3,000 and $5,000 are made at the ends of years 1 and 3, respectively. Find the balance immediately after the end of year 4. (Answer: $11,326.58)
A hypothetical $12,000 loan accumulates at an effective annual rate of 4%. A $2,000 payment is made at the end of year 1, and an unknown payment $X$ is made at the end of year 2. If the balance immediately after the end of year 3 is $8,000, find $X$. (Answer: $3,206.89)
A hypothetical $10,000 loan accumulates at an effective annual rate of 10%. Payments of $1,000, $2,000, and $1,000 are made at the ends of years 1, 2, and 4, respectively. Find the balance immediately after the year-4 payment. (Answer: $9,890.00)

What You'll Learn