Why Rounding Needs a Plan
A bond book-value schedule is built by applying the original yield to each opening balance and then subtracting the coupon. In exact arithmetic, a schedule that starts at the bond’s correctly calculated price reaches the redemption amount at maturity. In a table reported to cents, however, rounded interest and rounded opening balances can leave a small residual. The final entry should make that residual visible and reconcile it explicitly.
The purpose of a reconciliation is not to change the bond’s contractual cash flows. The coupon and redemption payment remain the amounts stated in the bond terms. Instead, the table’s final interest or amortization entry is adjusted by the small amount needed to bring the book value immediately before redemption to the contractual redemption amount.
For an annual coupon bond, \(j\) is the effective annual yield. If a yield is quoted as a nominal annual rate convertible \(m\) times per year, the effective rate per coupon period is the nominal rate divided by \(m\), provided coupons are paid \(m\) times per year. Use the rate per coupon period in the recurrence.
A consistent table policy is to round each interest entry to the nearest cent and carry each book value to the nearest cent. The examples below use ordinary rounding to the nearest cent, with half-cent ties rounded up. A calculation performed internally at greater precision may give a slightly different displayed result if intermediate entries are rounded differently. State and apply one policy throughout.
How to Reconcile the Final Period
Suppose the opening book value for the final period is \(B_{n-1}\). The ordinary rounded interest entry is the opening balance times the yield, rounded to cents. That entry may not produce the required closing balance \(F\). The final interest amount that does produce it follows directly from the recurrence:
The reconciliation adjustment is the required final interest minus the ordinary rounded final interest. A positive adjustment increases the final interest entry; a negative adjustment decreases it. Equivalently, if the ordinary rounded calculation produces a closing balance \(B_n^{\text{ordinary}}\), the adjustment to the final interest is \(F-B_n^{\text{ordinary}}\).
Identify the yield per coupon period, coupon amount, redemption amount, and rounding policy. Record book values after coupons, with the maturity value shown before principal redemption.
For each period, multiply the opening book value by the yield to obtain interest, round as specified, and subtract the coupon to obtain the closing book value.
Calculate the ordinary final result and compare it with \(F\). A residual of a cent or two can arise from rounding; a larger difference warrants checking the inputs and earlier calculations.
Set final interest to \(F+C-B_{n-1}\), or show the equivalent adjustment to the ordinary final interest. Verify that the final coupon leaves a balance of exactly \(F\).
Why the Final-Period Formula Holds
The recurrence says that the opening balance earns interest for one period, after which the coupon is paid. If the final period begins with \(B_{n-1}\), and its interest entry is \(I_n\), the balance after the coupon is \(B_{n-1}+I_n-C\). To make that balance equal the contractual redemption amount \(F\), solve the equation \(B_{n-1}+I_n-C=F\) for \(I_n\).
This reconciliation is a bookkeeping convention for reporting a rounded schedule. It does not assert that the yield earned in the final period was different from the original yield. The exact, unrounded schedule uses the original yield in every period; the displayed adjustment absorbs the accumulated effect of rounding entries.
Worked Schedules
Worked Example: A Premium Bond with a One-Cent Shortfall
A hypothetical three-year bond has a redemption amount of $1,000 and annual coupons of $50. Its effective annual yield is 4%. Calculate its purchase price to cents, build the book-value schedule using cent-rounded interest entries and balances, and reconcile the final period.
Method. First calculate the price at the original yield, then apply the book-value recurrence. The purchase price is the present value of the three coupons and the redemption payment:
The discount factors are \(1/1.04=0.96153846\), \(1/1.04^2=0.92455621\), and \(1/1.04^3=0.88899636\). Thus the three present-value terms are $48.076923, $46.227811, and $933.446178. Their sum is $1,027.750912, so the cent-rounded purchase price is \(B_0=\$1{,}027.75\). The price is above redemption, as expected for a coupon rate above the yield.
Period 1. Interest is \(1{,}027.75(0.04)=\$41.11\), rounded to cents. After the $50 coupon, \(B_1=1{,}027.75+41.11-50=\$1{,}018.86\).
Period 2. Interest is \(1{,}018.86(0.04)=\$40.7544\), or $40.75 to cents. After the coupon, \(B_2=1{,}018.86+40.75-50=\$1{,}009.61\).
Period 3 without reconciliation. Interest is \(1{,}009.61(0.04)=\$40.3844\), or $40.38 to cents. The resulting balance after the coupon is \(1{,}009.61+40.38-50=\$999.99\), one cent below redemption.
Reconciliation. The final interest needed is \(1{,}000+50-1{,}009.61=\$40.39\), one cent more than the ordinary rounded interest. The reconciled final balance is \(1{,}009.61+40.39-50=\$1{,}000.00\). The principal redemption of $1,000 then extinguishes that balance.
The common mistake is to leave the final interest at $40.38 and report a maturity balance of $999.99 as though it were the contractual redemption amount. The table should instead show the one-cent adjustment and the resulting $1,000 balance.
Worked Example: A Discount Bond That Reconciles Without an Adjustment
A hypothetical two-year bond has a redemption amount of $1,000, annual coupons of $30, and an effective annual yield of 5%. Find its price and carry the book value to maturity using the same cent-rounding policy.
Method. Price the coupons and final coupon plus redemption at the original yield:
Therefore, \(B_0=\$962.81\). The bond is priced below redemption because its coupon rate is below its yield.
Period 1. Interest is \(962.81(0.05)=\$48.1405\), or $48.14 to cents. After the $30 coupon, \(B_1=962.81+48.14-30=\$980.95\).
Period 2. Interest is \(980.95(0.05)=\$49.0475\), or $49.05 to cents. After the $30 coupon, \(B_2=980.95+49.05-30=\$1{,}000.00\). The ordinary cent-rounded schedule already reaches redemption, so the adjustment is $0.00. The final principal payment is then $1,000.
Check. The book value rises from $962.81 to $980.95 and then to $1,000.00, consistent with discount accretion. Do not assume that every rounded schedule needs a forced adjustment: calculate the residual first and reconcile only when a residual exists.
Worked Example: A Discount Bond with a One-Cent Excess
A hypothetical two-year bond has a redemption amount of $1,000, annual coupons of $35, and an effective annual yield of 5%. Calculate its cent-rounded schedule and reconcile its final period.
Method. The purchase price is
so \(B_0=\$972.11\).
Period 1. Interest is \(972.11(0.05)=\$48.6055\), which rounds to $48.61. After the $35 coupon, \(B_1=972.11+48.61-35=\$985.72\).
Period 2 without reconciliation. Interest is \(985.72(0.05)=\$49.286\), or $49.29 to cents. After the coupon, the ordinary closing balance is \(985.72+49.29-35=\$1{,}000.01\).
Reconciliation. The final interest required is \(1{,}000+35-985.72=\$49.28\), one cent less than the ordinary rounded amount. The reconciled balance is \(985.72+49.28-35=\$1{,}000.00\). The $1,000 principal redemption then closes the account.
The common mistake is to add a cent to the final balance to “round it to” redemption. The transparent correction is a one-cent reduction in the final interest entry, with the coupon unchanged.
Interpreting Residuals and Avoiding Traps
Rounding each period can transmit small differences into later periods: the next interest amount is calculated from the rounded opening book value, not from an unreported exact balance. A small maturity residual is therefore not automatically evidence of a bad schedule. It is a reason to inspect the stated rounding policy and calculate the final adjustment.
The size of the residual matters. A discrepancy of a cent or a few cents may be consistent with cent-level rounding across several periods. A substantial mismatch is not explained by ordinary rounding alone. Recheck the purchase price, the yield per coupon period, coupon timing, coupon amount, and whether the balance is being recorded before or after the final coupon. Do not conceal a large mismatch with a large final-period adjustment.
- Keep cash flows fixed. Reconciliation does not change the coupon or redemption amount owed under the bond terms.
- State what the balance represents. Here, \(B_n=F\) means the balance after the final coupon and before payment of redemption principal.
- Apply one rounding policy. Do not round interest in early rows but silently use full precision in the last row.
- Show the adjustment. Report both the ordinary rounded final result and the amount used to reconcile it.
Careful reconciliation makes a book-value table auditable: a reader can see the yield calculation, the rounding convention, the residual, and the reason for the final entry. These methods are aligned with the SOA Exam FM (Financial Mathematics) syllabus.
Check Your Understanding
Use cent-rounded interest entries and book values unless a question specifies otherwise. In each maturity calculation, the balance is measured after the final coupon and before principal redemption.
- A bond’s final-period opening book value is $1,009.61. Its annual yield is 4%, annual coupon is $50, and redemption amount is $1,000. Find the ordinary rounded interest, ordinary closing balance, and reconciliation adjustment. (Answer: ordinary interest $40.38; ordinary closing balance $999.99; increase final interest by $0.01 to $40.39.)
- A bond’s final-period opening book value is $985.72. Its annual yield is 5%, annual coupon is $35, and redemption amount is $1,000. Find the ordinary rounded interest and the reconciled final interest. (Answer: ordinary interest $49.29; reconciled final interest $49.28, a decrease of $0.01.)
- A two-period bond starts at a book value of $1,950.00. Its annual yield is 3%, each annual coupon is $70, and its contractual redemption amount is $1,926.66. Calculate the first-period interest and closing book value, then the ordinary second-period interest and closing value. State the final adjustment. (Answer: first-period interest $58.50 and closing value $1,938.50; second-period interest $58.16 and closing value $1,926.66; no adjustment.)
- A bond pays semiannual coupons of $140 and has a $5,000 redemption amount. Its nominal annual yield is 6% convertible semiannually, and its final-period opening book value is $4,990.28. Find the yield per half-year, ordinary final interest, ordinary closing value, and reconciled final interest. (Answer: yield per half-year 3%; ordinary interest $149.71; ordinary closing value $4,999.99; reconciled final interest $149.72, an increase of $0.01.)