Why Value a Loan Retrospectively?
A loan balance can be found by looking forward from the valuation date at the payments still due, or by looking backward from the original advance. The retrospective method takes the second approach: accumulate the original principal to the valuation date, then subtract the accumulated value at that same date of every payment already made. The two sides of this calculation are expressed at one common date, so they can be compared directly.
This method is particularly useful when the payments already made are known but the remaining payment stream is not level, or when checking a balance obtained by another method. The central requirement is consistent timing: a payment made earlier must be accumulated for more periods than a payment made later.
How the Retrospective Formula Works
The original advance \(L\) remains part of the loan's accumulated value through \(k\) periods, giving \(L(1+i)^k\). A payment \(P_j\) made at the end of period \(j\) has only \(k-j\) periods to accumulate by time \(k\), so its value at time \(k\) is \(P_j(1+i)^{k-j}\). Subtracting all such payment values leaves the balance immediately after the \(k\)th payment.
For level end-of-period payments \(R\), the accumulated value of the payments is \(R s_{\overline{k}|}\), where \(s_{\overline{k}|}\) is the accumulated value of an annuity-immediate of \(k\) unit payments at rate \(i\). Thus:
The formula for \(s_{\overline{k}|}\) follows by adding the accumulated values of the \(k\) payments: \(1+(1+i)+\cdots+(1+i)^{k-1}\). This is a geometric series with first term 1 and common ratio \(1+i\); its sum is \(\big((1+i)^k-1\big)/i\). When \(i=0\), each payment accumulates without growth, so \(s_{\overline{k}|}=k\) and \(B_k=L-kR\).
The timing convention matters. \(B_k\) in these formulas is the balance after the payment at time \(k\). Immediately before that payment, the balance is larger by the amount of the payment: it equals \(B_k+P_k\). If no payment is scheduled at time \(k\), the balance at that date is still found by accumulating the principal and subtracting only payments actually made by then.
Specify the period \(k\) and whether the balance is required immediately before or immediately after any payment at that date.
Convert a quoted rate if necessary. The exponent in each accumulation factor counts payment periods, not automatically years or months.
For a constant effective periodic rate \(i\), its value at time \(k\) is \(L(1+i)^k\).
A payment at time \(j\) is multiplied by \((1+i)^{k-j}\). Include only payments made by the valuation date.
Subtract the accumulated payments from the accumulated principal. Check the timing and confirm that the result is plausible for the loan's history.
Worked Calculations
Worked Example: A Balance After Two Level Payments
A hypothetical loan advances $12,000 at time 0. It charges an effective annual rate of 5%, with payments of $4,000 at the end of each year. Find the balance immediately after the second payment. Use the retrospective method and verify the answer period by period.
Method and timing. The payment period is one year, so \(i=0.05\). The valuation date is time 2, immediately after the second $4,000 payment. The principal accumulates for two years, the first payment for one year, and the second payment for zero years.
Accumulate principal. \(12{,}000(1.05)^2=12{,}000(1.1025)=\$13{,}230.00.\)
Accumulate payments to time 2. The first payment is worth \(4{,}000(1.05)=\$4{,}200.00\). The second payment is already at time 2 and is worth \(4{,}000(1.05)^0=\$4{,}000.00\). Their accumulated total is \(\$8{,}200.00\).
Subtract. The balance is \(\$13{,}230.00-\$8{,}200.00=\$5{,}030.00\).
Check by periods. After year 1 and the first payment, the balance is \(12{,}000(1.05)-4{,}000=\$8{,}600.00\). One year later, before the second payment, it is \(8{,}600(1.05)=\$9{,}030.00\); subtracting $4,000 gives $5,030.00, as above. The common mistake avoided is treating both payments as though they had been made at the same time: the first payment has one year of accumulation, but the second has none at the valuation date.
Worked Example: Quarterly Payments and a Nominal Rate
A hypothetical business borrows $30,000 and makes five end-of-quarter payments of $4,000. The loan rate is nominal 8% per year convertible quarterly. Find the balance immediately after the fifth payment.
Method and rate. A nominal annual rate of 8% convertible quarterly gives a quarterly rate \(i=0.08/4=0.02\). The valuation date is five quarters after the advance. Use five periods, not five years, in the accumulation factors.
Accumulate the principal. \(30{,}000(1.02)^5=30{,}000(1.1040808032)=\$33{,}122.424096.\)
Accumulate the payments. The five $4,000 payments have, respectively, four, three, two, one, and zero quarters to accumulate. Therefore their accumulated value is \(4{,}000\big((1.02)^4+(1.02)^3+(1.02)^2+1.02+1\big)\). The sum of the factors is \(1.08243216+1.061208+1.0404+1.02+1=5.20404016\). The payments' accumulated value is \(4{,}000(5.20404016)=\$20{,}816.16064\).
Subtract. The balance is \(\$33{,}122.424096-\$20{,}816.16064=\$12{,}306.263456\), or $12,306.26 to the nearest cent.
Check. Because the rate and payment intervals are both quarterly, five payments correspond to five quarterly periods. The common mistake avoided is using 8% as the quarterly rate; the stated nominal rate converts to 2% per quarter.
Worked Example: Unequal Payments and a Skipped Payment Date
A hypothetical borrower receives $18,000 at time 0 and pays an effective annual rate of 4%. The borrower pays $5,000 at the end of year 1, $6,000 at the end of year 2, makes no payment at the end of year 3, and pays $4,000 at the end of year 4. Find the balance immediately after the year-4 payment.
Method and valuation date. Use the general retrospective sum because the payments are not level. The valuation date is time 4. The three payments made by then have accumulated for \(4-1=3\), \(4-2=2\), and \(4-4=0\) years, respectively. There is no year-3 payment to include.
Accumulate the principal. \(18{,}000(1.04)^4=18{,}000(1.16985856)=\$21{,}057.45408.\)
Accumulate each payment. The year-1 payment is worth \(5{,}000(1.04)^3=5{,}000(1.124864)=\$5{,}624.32\). The year-2 payment is worth \(6{,}000(1.04)^2=6{,}000(1.0816)=\$6{,}489.60\). The year-4 payment is worth \(\$4{,}000\), since it is made on the valuation date. Total accumulated payments are \(\$5{,}624.32+\$6{,}489.60+\$4{,}000.00=\$16{,}113.92\).
Subtract and check. The balance is \(\$21{,}057.45408-\$16{,}113.92=\$4{,}943.53408\), or $4,943.53 to the nearest cent. The result is positive, consistent with the accumulated principal still exceeding the accumulated payments. The common mistake avoided is assigning a payment to year 3 simply because it lies between the year-2 and year-4 payments.
Conditions, Checks, and Common Errors
The displayed formulas assume that the rate \(i\) is effective for each payment period, the loan starts at time 0, and payments occur at the stated period ends. They also assume that the same periodic rate applies throughout the periods being accumulated. If rates change by period, each cash flow must instead be accumulated using the product of the applicable period factors. For example, a payment at time \(j\) accumulated to time \(k\) uses the factors for periods \(j+1\) through \(k\), rather than a single power of a constant \(1+i\).
A retrospective balance is a value at a specified date, not simply the original loan minus the dollar amounts paid. Interest means earlier payments must be accumulated to the valuation date before they can be compared with the accumulated principal. As a consistency check, for a fully amortizing loan under the same rate and payment assumptions, the retrospective balance at a payment date agrees with the value at that date of the payments still due. This equality depends on using the same contract cash flows, rate, and timing conventions in both valuations.
- Wrong time unit: Using a yearly rate with a period count measured in quarters gives inconsistent accumulation. Convert the rate to the payment interval first.
- Wrong accumulation period: A payment made at time \(j\) accumulates for \(k-j\) periods to time \(k\), not for \(j\) periods.
- Wrong payment-date convention: The balance immediately after a payment excludes that payment from the outstanding amount; the balance immediately before it includes the payment still due.
- Wrong payment pattern: Use \(R s_{\overline{k}|}\) only when the payments are level and made at the ends of successive periods. For unequal or skipped payments, use the payment-by-payment sum.
When possible, verify the result with the balance recurrence: accumulate the previous balance for one period, then subtract the payment made at the end of that period. Agreement with the retrospective calculation is a strong check that the payment dates and accumulation periods have been handled consistently.
Check Your Understanding
For each problem, identify the payment interval and valuation timing before calculating. Amounts are rounded to the nearest cent where needed.
- A hypothetical loan of $8,000 earns 6% effective annually. Payments of $2,500 are made at the ends of years 1 and 2. Find the balance immediately after the second payment. (Answer: $3,838.80)
- A borrower receives $15,000 and makes three end-of-quarter payments of $1,800. The nominal annual rate is 12% convertible quarterly. Find the balance immediately after the third payment. (Answer: $10,827.29)
- A $10,000 loan earns 8% effective annually. Payments of $2,000 at the end of year 1 and $3,000 at the end of year 3 have been made. Find the balance immediately after the year-3 payment. (Answer: $7,264.32)
- A $20,000 loan earns 5% effective annually and requires $6,000 payments at the ends of years 1 and 2. Find the balance immediately before the second payment. (Answer: $15,750.00)
- A hypothetical loan of $40,000 has a nominal annual rate of 8% convertible quarterly and four end-of-quarter payments of $5,000. Find the balance immediately after payment 4. (Answer: $22,689.25)