Reconciling Cash-Flow and Balance Methods in Combined Transactions

Why Reconcile Two Methods?

A combined transaction may involve a bond coupon, a scheduled loan payment, the sale of the bond, and payoff of the remaining loan. A direct cash-flow calculation adds the receipts and payments on their actual dates. A balance calculation instead tracks the bond’s book value and the loan’s outstanding balance. Both methods should agree when they use the same dates, rates, and sign convention.

The reconciliation is useful because the two methods expose different errors. The cash-flow ledger makes omitted or reversed payments visible. The balance method makes it easier to spot interest applied over the wrong period or a sale price confused with book value. The objective is not to treat all cash flows as investment profit; it is to show precisely how the dated cash amount relates to the carrying values and interest accrued.

Definition: Treat the bond as an asset and the loan as a liability. Receipts are positive and payments are negative. Let $C_0$ be the bond’s book value at the start of one period, $B_0$ the loan balance, $K$ the bond coupon paid at the end of the period, and $P$ the scheduled loan payment at that date. Let $y$ and $j$ be the effective bond yield and loan interest rate, respectively, for that same period. The period-end book value and loan balance, before any sale or separate payoff adjustment, are $C_1=C_0(1+y)-K$ and $B_1=B_0(1+j)-P$.

These recurrences assume that the bond yield and loan rate apply over the same interval, and that the coupon and scheduled payment are made at the end of that interval. If cash flows occur at different dates, use separate dated steps rather than applying a full-period rate to each of them. If a bond is sold for an amount different from its book value, or a loan is paid off for an amount different from its calculated balance, those differences must also be recorded.

The Reconciliation Identity

Suppose the bond is sold for $S$ at the end of the period and the loan is discharged for a total amount $Q$. The signed cash flow on that date, including the coupon and scheduled payment, is

$$ F=K+S-P-Q. $$

The starting net carrying position is $C_0-B_0$. During the period the bond earns book yield interest $yC_0$, while the loan incurs interest $jB_0$. The difference $yC_0-jB_0$ is the interest spread in dollars for this period. A sale above book value adds $S-C_1$; a sale below book value makes that term negative. A payoff above the scheduled ending loan balance adds the negative adjustment $-(Q-B_1)$.

Theorem: Under the stated end-of-period timing convention, $$ F=(C_0-B_0)+(yC_0-jB_0)+(S-C_1)-(Q-B_1). $$ If the bond is sold at book value and the loan is paid off exactly at its calculated balance, then $S=C_1$ and $Q=B_1$, so $F=(C_0-B_0)+(yC_0-jB_0)$.

The identity follows by rearranging the recurrences: $K=C_0+yC_0-C_1$ and $P=B_0+jB_0-B_1$. Substituting these into the signed cash-flow expression gives

\begin{aligned} F &=(C_0+yC_0-C_1)+S-(B_0+jB_0-B_1)-Q\\ &=(C_0-B_0)+(yC_0-jB_0)+(S-C_1)-(Q-B_1). \end{aligned}

This is a reconciliation, not a claim that the cash flow $F$ is a period’s profit. It can include the release of the starting net carrying position. The interest spread and sale or payoff adjustments explain how that position changes into the cash amount at the transaction date.

Fix the date and signs.
List each receipt as positive and each payment as negative. Identify whether the coupon and loan payment occur before, at, or after the sale and payoff date.

Calculate both carrying amounts.
Apply the bond yield to the starting book value and the loan rate to the starting balance over the matching period. Then subtract the coupon and scheduled loan payment, respectively.

Record transaction differences.
Compare sale proceeds with the bond book value, and compare the payoff amount with the calculated loan balance. Keep each difference signed.

Check the two totals.
Compute the dated cash flow directly and independently compute the right side of the reconciliation identity. Investigate any difference instead of forcing the amounts to agree.

Worked Examples

Worked Example: Sale and Payoff at the Period-End Date

An investor begins a one-year period with a bond book value of $4,000 and a loan balance of $3,000. The bond yield is 6% effective annually, and its $200 coupon is paid at year-end. The loan rate is 4% effective annually, and the scheduled year-end payment is $500. At year-end the bond is sold for $4,050 and the loan is paid off for its calculated balance. Reconcile the transaction. Method: calculate each carrying value first, then compare the direct signed cash flow with the balance identity. This avoids treating the sale proceeds or loan payment as interest alone.

Bond book value. The bond earns $0.06(4000)=\$240$ of yield interest. After the $200 coupon, its year-end book value is

C_1=4000(1.06)-200=4240-200=\$4{,}040.

Loan balance. The loan incurs $0.04(3000)=\$120$ of interest. After the $500 payment, its year-end balance is

B_1=3000(1.04)-500=3120-500=\$2{,}620.

Direct cash-flow method. The coupon and sale proceeds are receipts; the scheduled payment and payoff are payments:

F=200+4050-500-2620=\$1{,}130.

Balance method. The starting net carrying position is $4000-3000=\$1{,}000$. The interest spread is $240-120=\$120$. The bond sells for $4050-4040=\$10$ above book value, and the loan payoff equals its balance, so its adjustment is zero. Thus

F=1000+120+10-0=\$1{,}130.

The two methods agree. The $1,130 cash receipt is not just the $120 spread: it also reflects the $1,000 starting net carrying position and the $10 sale premium over book value.

Worked Example: Locating a Loan Timing Error

At the start of a six-month period, a bond has a book value of $8,000 and a loan has a balance of $10,000. The effective six-month bond yield is 4%, and the bond pays a $300 coupon at the period end. The effective six-month loan rate is 3%, and a $2,000 loan payment is due at the period end. At that date the bond is sold for $8,030 and the loan is paid off for its calculated balance. A calculation instead treats the scheduled payment as if it were made at the beginning of the period. Find the correct cash flow and the size of the timing error. Method: apply both rates to the opening balances, then subtract end-of-period payments. The error to avoid is using a beginning-payment loan recurrence for an end-of-period payment.

Correct bond value. The yield interest is $0.04(8000)=\$320$. After the coupon,

C_1=8000(1.04)-300=8320-300=\$8{,}020.

Correct loan balance. The loan interest is $0.03(10000)=\$300$. Since the payment is made at the period end,

B_1=10000(1.03)-2000=10300-2000=\$8{,}300.

The direct dated cash flow is

F=300+8030-2000-8300=-\$1{,}970.

The balance method gives a starting net position of $8000-10000=-\$2{,}000$, an interest spread of $320-300=\$20$, a sale difference of $8030-8020=\$10$, and no payoff adjustment. Therefore

F=-2000+20+10-0=-\$1{,}970.

If the payment were incorrectly treated as occurring at the beginning, the balance would be $(10000-2000)(1.03)=\$8{,}240$, which is $60 too low. Using that incorrect payoff in the direct calculation would give $300+8030-2000-8240=-\$1{,}910$, also $60 too high. The specified payment date determines which recurrence applies.

Worked Example: Separating Sale and Payoff Adjustments

A bond has a starting book value of $8,000, an annual yield of 5%, and a $360 year-end coupon. A loan has a starting balance of $6,000, an annual rate of 4%, and a $1,000 year-end payment. At year-end the bond sells for $7,700. The lender’s payoff quote is $5,265, which is $25 more than the loan balance calculated from the stated rate and payment. Find the signed cash flow and reconcile it. Method: calculate book values and balances from their contractual recurrences, then keep the market sale and quoted payoff differences separate. This avoids labeling every difference as interest.

Bond book value. Yield interest is $0.05(8000)=\$400$, so after the coupon

C_1=8000(1.05)-360=8400-360=\$8{,}040.

The sale is $7700-8040=-\$340$ below book value.

Loan balance. Loan interest is $0.04(6000)=\$240$, so after the scheduled payment

B_1=6000(1.04)-1000=6240-1000=\$5{,}240.

The quoted payoff exceeds this balance by $5265-5240=\$25$. The direct cash-flow calculation is

F=360+7700-1000-5265=\$1{,}795.

For the balance check, the starting net position is $8000-6000=\$2{,}000$, and the interest spread is $400-240=\$160$. Include the sale difference of $-\$340$ and subtract the payoff excess of $25:

F=2000+160-340-25=\$1{,}795.

The result agrees. The $25 payoff excess is recorded as a transaction adjustment; without further information, it should not be folded into the stated 4% loan interest.

Common Mistakes and Diagnostic Checks

A reconciliation is most useful when it preserves the transaction’s signs and dates. For example, in the first worked example, a common incorrect calculation is to add the $500 scheduled payment as though it were a receipt:

200+4050+500-2620=\$2{,}130.

The correction is to treat the loan payment as a cash outflow:

200+4050-500-2620=\$1{,}130.

The wrong result is $1,000 too high, twice the $500 payment, because changing a negative payment to a positive receipt changes the total by $2(500)$. This is a useful sign check when a total seems plausible but does not reconcile.

Do not apply interest to the wrong balance. Under end-of-period payment timing, interest accrues on the opening loan balance before the payment is subtracted.
Do not omit the coupon or scheduled payment. Each belongs in the dated cash flow and also affects the bond book value or loan balance recurrence.
Do not substitute market price for book value. The sale-price difference $S-C_1$ is a separate adjustment.
Do not treat a payoff quote as automatically equal to the balance. Compare $Q$ with $B_1$ and include the signed difference.
Do not compare amounts from different dates without adjustment. The identity above is for one matched period and transaction date. With unequal dates, establish the dated cash-flow ledger and carry balances only over the intervals to which their rates apply.

In practice, write the direct cash-flow total before interpreting it. Then independently compute the starting net position, interest spread, sale-price difference, and payoff difference. If the totals disagree, check in order: the transaction date, the period rate, the payment timing, the signs, and whether the sale or payoff amount differs from its carrying amount. This procedure is aligned with the SOA Exam FM (Financial Mathematics) syllabus.

Key takeaway: For a matched period, reconcile signed cash flow as starting bond book value minus starting loan balance, plus bond yield interest minus loan interest, plus sale proceeds above or below book value, minus any payoff amount above or below the calculated loan balance. Use the same dates and payment convention in both methods.

Check Your Understanding

For each case, use end-of-period coupon and loan-payment timing. Treat receipts as positive and payments as negative, and check the direct cash flow against the balance method where requested.

A bond has book value $6,000, annual yield 4%, and a $240 coupon. A loan has balance $4,500, annual rate 5%, and a $700 payment. The bond sells for $5,990 and the loan is paid off at its calculated balance. Find both ending carrying amounts and the net cash flow. (Answer: Bond book value $6,000; loan balance $4,025; net cash flow $1,505.)
Over one quarter, a bond with book value $10,000 earns an effective 3% yield and pays a $250 coupon. A loan with balance $12,000 accrues effective 2% interest and has a $2,500 end-of-quarter payment. The bond sells for $10,020 and the loan is paid off at its calculated balance. Find the net cash flow and the error in the loan balance if the payment is mistakenly treated as beginning-of-quarter. (Answer: Net cash flow $-\$1,970$; the mistaken balance is $9,690, which is $50 too low.)
A bond has book value $8,000, annual yield 5%, and coupon $360. A loan has balance $6,000, annual rate 4%, and payment $1,000. The bond sells for $7,700 and payoff is $5,265. Find the cash flow and identify the sale and payoff adjustments relative to book value and calculated balance. (Answer: Cash flow $1,795; sale adjustment $-\$340$; payoff adjustment $-\$25$ in the reconciliation.)
A bond begins at book value $10,000, earns effective annual yield 4%, and pays a $600 coupon. A loan begins at $7,000, accrues effective annual interest of 3%, and has a $900 payment. The bond sells for $9,850 and the loan payoff is $6,330. Reconcile the transaction. (Answer: Bond book value $9,800; loan balance $6,310; direct and reconciled cash flow $3,220.)
A bond begins a second annual period with book value $5,100, earns 6% yield, and pays a $200 coupon at year-end. A loan begins that period with balance $3,400, accrues 5% interest, and has an $800 year-end payment. At year-end the bond is sold for $5,190 and the loan is paid off at its calculated balance. Find the year-end cash flow and verify it using the starting net position and interest spread for this period. (Answer: Ending bond book value $5,206; loan balance $2,770; cash flow $1,820, equal to $1,700+136-16$.)

What You'll Learn