Common-Date Cash-Flow Ledgers for Loan and Bond Problems

Why a Dated Ledger Matters

A loan or bond problem can involve several amounts paid at different times. Adding those amounts directly does not account for interest earned or charged between their dates. A dated cash-flow ledger makes the timing explicit: list each amount at its date, state the accumulation assumptions, and move the amounts to one common focal date before comparing them.

The ledger is an organizing method, not a new interest model. It uses the accumulated-value principles of the earlier material on interest and annuities. The essential discipline is to preserve each cash flow’s date and to use the rate that applies over every interval between that date and the focal date.

Definition: A dated cash-flow ledger is a list or table of cash-flow amounts paired with their dates. A focal date is the date to which the listed amounts are accumulated or discounted for comparison. A common-date equation equates the values, at that focal date, of two sets of cash flows.

Accumulating Each Ledger Entry

Suppose an amount $C$ occurs at time $s$, and the focal date is $T$, with $T\geq s$. If the effective annual rate is constant at $i$ throughout the interval and fractional-year compounding is permitted, the amount at $T$ is $C(1+i)^{T-s}$. The exponent is the elapsed time in years, not the date number itself.

If the annual effective rate changes, split the interval at each rate-change date. Multiply by the accumulation factor for every segment. For example, if the rate is $i_1$ from time 0 to time 1 and $i_2$ from time 1 to time 3, an amount at time 0 accumulates to time 3 by the factor $(1+i_1)(1+i_2)^2$.

For a ledger with amounts $C_j$ at dates $t_j$, the accumulated total at focal date $T$ is the sum of each amount multiplied by its accumulation factor from $t_j$ to $T$. When the purpose is to equate two sides, compare their accumulated totals at the same date.

V(T)=\sum_j C_j A(t_j,T)

Here $A(s,T)$ is the accumulation factor from time $s$ to time $T$. Under a constant effective annual rate $i$, $A(s,T)=(1+i)^{T-s}$. Under changing rates, $A(s,T)$ is the product of the applicable factors over the intervening segments. If an amount is already at the focal date, its factor is $A(T,T)=1$.

Why the Common-Date Equation Works

Accumulating is valid because an amount at an earlier date can be replaced, at the focal date, by the amount it would have become under the specified accumulation assumptions. Applying this replacement to each ledger entry and adding gives the total value at that date. Equating two sets of cash flows at the focal date therefore compares amounts expressed at the same time.

Choose the focal date.
It must be stated or selected consistently for both sides of the comparison.

List the dated amounts.
Record every advance, payment, coupon, redemption amount, and transaction cost at its actual date.

Find each accumulation factor.
Use the rate applying over the full interval from each cash-flow date to the focal date.

Accumulate and compare.
Multiply each amount by its factor, add the appropriate totals, and solve or report the requested difference.

The underlying justification is the compound-interest rule. If one unit accumulates by a factor $1+i$ in each of $n$ annual periods, then after $n$ periods it accumulates by $(1+i)^n$. Each ledger amount follows that same rule from its own date. For successive rate regimes, applying the rule segment by segment gives a product of factors, which is why a rate change requires splitting the interval rather than using one rate for the whole period.

Worked Example: Finding a Final Loan Payment

A borrower receives $8,000 at time 0, pays $1,000 at time 1, and makes a final payment $X$ at time 2. The effective annual interest rate is 5% throughout. Find $X$ by accumulating both sides of the loan ledger to time 2. Assume annual compounding and no fees.

Method and ledger. Use the common-date equation at time 2. On the amount-owed side, the advance accumulates for two years. On the repayment side, the first payment accumulates for one year and the final payment is already at time 2.

8{,}000(1.05)^2=1{,}000(1.05)+X

The accumulated advance is $8{,}000(1.1025)=\$8{,}820$. The time-1 payment accumulates to $1{,}000(1.05)=\$1{,}050$. Therefore,

X=8{,}820-1{,}050=\$7{,}770.00

Check. At time 2, the repayment total is $\$1{,}050+\$7{,}770=\$8{,}820$, equal to the accumulated advance. The answer is $7,770.00. The method avoids treating the time-1 payment as though it were paid at time 2.

Bond Receipts and Purchase Costs

A bond ledger can include the purchase price, transaction costs, coupons, and redemption amount. Put each item on the date it occurs. If the question asks for accumulated receipts less accumulated costs, accumulate the receipts and costs separately, then subtract. Do not assume that a purchase price is a coupon, or that coupons are automatically reinvested at the bond’s yield: use the reinvestment assumption stated in the problem.

The ledger calculation itself does not establish a bond’s yield or book value. It answers the specific common-date comparison requested, using the cash flows and accumulation assumptions supplied.

Worked Example: Accumulated Bond Receipts Versus Purchase Price

A hypothetical bond pays a $40 coupon at time 1 and another $40 coupon at time 2, when it also repays $1,000 of principal. An investor pays $980 at time 0, with no other costs. Coupons are reinvested at an effective annual rate of 4%. Find accumulated receipts less accumulated purchase cost at time 2.

Method. Accumulate the time-1 coupon for one year. The time-2 coupon and principal are already at the focal date. Accumulate the time-0 purchase price for two years.

\text{Receipts at time 2}=40(1.04)+40+1{,}000

The first coupon accumulates to $\$40(1.04)=\$41.60$. Thus accumulated receipts are $\$41.60+\$40+\$1{,}000=\$1{,}081.60$. The purchase cost accumulates to

980(1.04)^2=980(1.0816)=\$1{,}059.968

Subtract costs from receipts: $\$1{,}081.60-\$1{,}059.968=\$21.632$, which rounds to $21.63 to the nearest cent.

Check. The accumulated cost is less than the accumulated receipts by $21.632. The method avoids accumulating the time-1 coupon for two years or leaving the purchase price at time 0.

Rate Changes and Transaction Costs

When rates differ across time intervals, the ledger still works, but the factor for an entry must reflect every rate segment it crosses. The same care applies to transaction costs: include a cost at its actual payment date and accumulate it from there. A cost paid at time 0 and a cost paid at time 1 do not generally have the same value at a later focal date.

A useful layout is to make the dates explicit before doing arithmetic. The following example has a rate change after the first year. The stated convention is annual effective compounding within each year.

Worked Example: A Loan with a Rate Change

A borrower receives $5,000 at time 0, pays $1,000 at time 1 and another $1,000 at time 2, then makes a final payment $X$ at time 3. The effective annual rate is 5% from time 0 to time 1, and 6% from time 1 to time 3. Find $X$ by accumulating to time 3. Assume no fees.

Method and factors. The advance crosses both rate regimes, so its factor is $1.05(1.06)^2$. The time-1 payment crosses two years at 6%, so its factor is $(1.06)^2$. The time-2 payment crosses one year at 6%, and $X$ is already at the focal date.

5{,}000(1.05)(1.06)^2=1{,}000(1.06)^2+1{,}000(1.06)+X

The accumulated advance is $5{,}000(1.05)(1.1236)=\$5{,}898.90$. The time-1 payment accumulates to $1{,}000(1.1236)=\$1{,}123.60$. The time-2 payment accumulates to $1{,}000(1.06)=\$1{,}060$. Hence,

X=5{,}898.90-1{,}123.60-1{,}060=\$3{,}715.30

Check. At time 3, the two earlier payments total $\$2{,}183.60$, and adding the final payment gives $\$5{,}898.90$, the accumulated advance. The method avoids applying 5% beyond time 1 or applying 6% to the entire three-year interval.

Worked Example: Including a Bond Transaction Cost

A hypothetical two-year bond has face amount $2,000 and pays annual coupons of 3% of face at times 1 and 2. It repays the $2,000 face amount at time 2. An investor pays $1,940 for the bond and a $10 transaction cost at time 0. Coupons are reinvested at an effective annual rate of 5%. Find accumulated receipts less accumulated costs at time 2.

Method. Each coupon is $0.03(2{,}000)=\$60$. Accumulate the time-1 coupon for one year; the time-2 coupon and redemption are already at the focal date. The purchase price and transaction cost are both paid at time 0.

\text{Receipts}=60(1.05)+60+2{,}000=\$2{,}123

The total cost at time 0 is $\$1{,}940+\$10=\$1{,}950$. Its accumulated value is $1{,}950(1.05)^2=1{,}950(1.1025)=\$2{,}149.875$. Therefore,

\text{Receipts}-\text{costs}=2{,}123-2{,}149.875=-\$26.875

Rounded to the nearest cent, accumulated receipts less accumulated costs equal −$26.88. The negative difference means the accumulated costs exceed the accumulated receipts by $26.875. The method avoids omitting the transaction cost or treating it as if it were paid at time 2.

Common Ledger Errors

Adding amounts at different dates. A payment at time 1 and one at time 2 must first be expressed at a common date before they are compared.
Using the wrong elapsed time. To move a time-1 amount to time 3, use two years of accumulation, not three.
Applying one rate across a rate change. Split the accumulation interval at the change date and multiply the applicable factors.
Omitting a cash flow or misplacing its date. Include transaction costs, coupons, and redemption amounts exactly where they occur.
Rounding too early. Keep unrounded intermediate values when calculating accumulated totals, then round the requested money result to cents.

Before finalizing an equation, check that every cash flow appears once, its date is correct, and its accumulation factor covers precisely the interval to the focal date. A final balance check should reproduce the same common-date total on both sides of an equation of value.

Key takeaway: A common-date ledger is reliable when every cash flow is dated, every accumulation factor matches its date-to-focal-date interval and rate regime, and all amounts are compared at the same focal date.

Check Your Understanding

For each problem, write a dated ledger, select the stated focal date, and check that each accumulation factor covers the correct interval.

A borrower receives $6,000 at time 0, pays $1,500 at time 1, and makes a final payment at time 2. The effective annual rate is 4% throughout. Find the final payment. (Answer: $4,929.60)
A hypothetical bond with face amount $1,000 pays a 5% coupon at times 1 and 2 and repays principal at time 2. It is purchased for $970 at time 0. Coupons are reinvested at 3% effective annually. Find accumulated receipts less accumulated purchase cost at time 2. (Answer: $72.43)
A borrower receives $9,000 at time 0, pays $2,000 at time 1 and $3,000 at time 2, and makes a final payment at time 3. The effective annual rate is 5% throughout. Find the final payment. (Answer: $5,063.63)
A hypothetical two-year bond is purchased for $1,500 at time 0, with a $12 transaction cost also paid at time 0. It pays coupons of $80 at times 1 and 2 and repays $1,500 at time 2. Coupons are reinvested at 4% effective annually. Find accumulated receipts less accumulated costs at time 2. (Answer: $27.82)
A borrower receives $4,000 at time 0, pays $500 at time 1, and makes a final payment at time 3. The effective annual rate is 4% from time 0 to time 1 and 5% from time 1 to time 3. Find the final payment. (Answer: $4,035.15)

What You'll Learn