4.4 Bond Schedules

Learning Objectives

• Construct an amortization of the premium bond schedule
• Construct an accumulation of the discount bond schedule

Formula & Symbol Hub

Symbols Used

• $BAL$ = Principal balance
• $BV$ = Book value
• $FV$ = Face value of bond
• $PMT$ = Annuity payment amount
• $N$ = Number of annuity payments
• $I/Y$ = Nominal interest rate
• $P/Y$ = Number of payments per year or payment frequency
• $C/Y$ = Number of compounds per year or compounding frequency

Formulas Used

• Formula 4.1 – Bond Payment

$\text{Payment}=\mbox{Face Value} \times \mbox{periodic bond rate}$

• Formula 4.2 – Purchase Price on an Interest Payment Date

$\text{Purchase Price}=\mbox{Present Value of Face Value}+\mbox{Present Value of Bond Payments}$

• Formula 4.3 – Premium (Bonds)

$\text{Premium}=\mbox{Purchase Price}-\mbox{Face Value}$

• Formula 4.4 – Discount (Bonds)

$\text{Discount}=\mbox{Face Value}-\mbox{Purchase Price}$

Introduction

Recall that the purchase price of a bond does not necessarily equal its face value. The bond may be purchased for more that its face value, resulting in a premium, or the bond may be purchased for less that its face value, resulting in a discount. When an investor purchases a bond, the investor receives the bond payments as well as the bond’s face value at maturity. What are the tax implications associated with owning a bond? For example, the bond payments are taxable income for the investor. But, what are the tax implications of the premium or discount that is realized when the bond is redeemed at maturity?

The book value of a bond is the face value of the bond plus or minus any unamortized premium or discount. The initial book value of a bond is its purchase price. A common practice to deal with the tax implications of the premium or discount is to make adjustments to the book value of the bond over the holding period of the bond. The adjustments to the book value involve amortizing small parts of the premium or discount during each payment interval until the book value of the bond equals the bond’s face value.

When a bond is purchased for more than its face value, the result is a premium. For example, suppose an investor pays $\1,050$ for a $\1,000$ face value bond. If the investor holds onto the bond until maturity, only the redemption price of $\1,000$ is returned. The bond premium of $\50$ represents a capital loss for the investor because the premium is not recovered at maturity. A capital loss is the amount by which the current value of an asset falls short of the original purchase price. What does the investor do with this capital loss? One option is for the investor to apply the capital loss against their income at the time of redemption, which results in a lower taxable amount at the time of redemption. But, commonly accepted practices allow the investor to amortize the capital loss over the period of time that the bond is held, and not just in the period during which the capital loss actually occurs (at maturity). This allows the investor to spread the capital loss over each payment interval, claiming a little bit of the capital loss against each bond payment in order to lower the taxable amount for each payment interval. This process is called the amortization of the premium.

The amortization of the premium schedule records the bond payment, the amount of the premium that is claimed with each payment, the book value, and the remaining premium to be amortized. The amortization of the premium schedule shows how much premium is claimed against each payment and the resulting book value.

An amortization of the premium schedule has six columns:

• Payment Number — There is a row for every bond payment during the holding period of the bond.
• Bond Payment — The periodic bond payment (PMT). All of the payments are the same, including the last payment.
• Interest on Book Value at Yield — For each row, the interest on book value entry is the interest portion of the current bond payment based on the book value from the previous row.
• Amortized Premium — For each row, the amortized premium entry is the amount of the premium that is claimed as a capital loss in that payment interval.
• Book Value — For each row, the book value is the face value of the bond plus the remaining unamortized premium.
• Remaining Premium to be Amortized — For each row, the remaining premium is the amount of premium that is left to claim against the payments.

To fill in an amortization of the premium schedule, you first need to have all of the details about the bond, including the face value ($FV$), the purchase price ($PV$), the bond payment ($PMT$), the number of payments ($N$), and the yield rate. If any of these quantities are missing, calculate out the missing value before completing the amortization of the premium schedule.

 Payment Number Bond Payment Interest on Book Value at Yield Amortized Premium Book Value Remaining Premium to be Amortized $0$ $\text{Purchase Price}^1$ $\text{Premium}^1$ $1$ $PMT^2$ $INT$ on $BV^3$ $AP^4$ $BV^5$ $RP^6$ $2$ $PMT^2$ $INT$ on $BV^3$ $AP^4$ $BV^5$ $RP^6$ $\vdots$ $\vdots$ $\vdots$ $\vdots$ $\vdots$ $\vdots$ $N-1$ $PMT^2$ $INT$ on $BV^3$ $AP^4$ $BV^5$ $RP^6$ $N$ $PMT^2$ $INT$ on $BV^3$ $AP^4$ $\text{Face Value}^8$ $0^9$ Totals $\text{Total Payments}^{10}$ $\text{Total Interest}^{12}$ $\text{Total Amortized Premium}^{11}$ $D$

Fill In the Amortization of the Premium Schedule

Follow these steps to fill in the amortization of the premium schedule.

Step 1: In row $0$, the only entries are in the book value and remaining premium to be amortized columns. The initial book value is the purchase price of the bond and the initial remaining premium is the premium.

Step 2: Each entry in the bond payment column is the bond payment. All of the payments in this column are the same, including the last payment.

Step 3: Calculate the interest on the book value at yield. The interest is the book value from the previous row times the periodic yield rate:

$\mbox{Interest on Book Value}=\mbox{Book Value from Previous Row} \times i$

Note: this calculation uses the periodic yield rate, not the periodic bond rate.

Step 4: Calculate the amortized premium. The amortized premium is the difference between the payment and the interest on the book value:

$\mbox{Amortized Premium}=PMT-\mbox{Interest on Book Value}$.

Step 5: Calculate the new book value. The book value is the difference between the book value in the previous row and the amortized premium:

$\mbox{Book Value}=\mbox{Book Value from Previous Row}-\mbox{Amortized Premium}$

Step 6: Calculate the remaining premium to be amortized. The remaining premium is the difference between the remaining premium from the previous row and the amortized premium:

$\begin{eqnarray*}\mbox{Remaining Premium}&=&\mbox{Remaining Premium from Previous Row}\\&-&\mbox{Amortized Premium}\end{eqnarray*}$

Step 7: For each payment, repeat steps $2$ through $6$, including for the last row.

Step 8: The last book value is the face value of the bond. If the calculations are done correctly, this will automatically happen.

Step 9: The last remaining premium to be amortized is $0$. If the calculations are done correctly, this will automatically happen.

Step 10: The total payments is the sum of the payment column:

$\mbox{Total Payments}=N \times PMT$.

Step 11: The total amortized premium is the sum of the amortized premium column, and is just the premium:

$\mbox{Total Amortized Premium}=\mbox{Premium}$.

Step 12: The total interest is the sum of the interest on book value column, and equals the difference between the other two column totals:

$\mbox{Total Interest}=\mbox{Total Payments}-\mbox{Total Amortized Premium}$.

Key Takeaways

The manual calculation of the interest on the book value entry above is based on the assumption that the payment frequency and the compounding frequency are equal. For bonds this is generally not an issue because most bonds have semi-annual payments and a yield rate that compounds semi-annually. If the payment frequency and the compounding frequency are not equal, an interest conversion would be required to convert the interest rate to the equivalent rate with the compounding frequency equal to the payment frequency. However, if you use the TI BAII Plus’s built-in amortization worksheet (described below), no interest conversion is required.

As you fill in the schedule, round the entries to two decimal places.

The amortized premium column represents how much of the premium is claimed as a capital loss against the payment for that payment interval.

The amortization of the premium schedule presented here assumes the bond is purchased on an interest payment date. Bonds that are not purchased on an interest payment date have added complications that will not be addressed here.

Example 4.4.1

A $\2,000$ bond with a coupon rate of $8\%$ is redeemable in two years. The bond was purchased when the yield rate was $5\%$. Construct the amortization of the premium schedule.

Solution

Step 1: The given information is

Because no other information is given, the frequency of the payments and the compounding frequencies (for the coupon rate and the yield rate) are assumed to be semi-annual.

$\begin{eqnarray*} FV & = & \2,000 \\ P/Y & = & 2 \\ I/Y & = & 5\% \\ C/Y & = & 2 \\ t & = & 2 \mbox{ years} \\ \mbox{Coupon Rate} & = & 8\% \end{eqnarray*}$

Step 2: Calculate the bond payment.

$\begin{eqnarray*} PMT & = & FV \times \frac{\mbox{coupon rate}}{2} \\ & = & 2,000\times \frac{0.08}{2}\\ & = & \80\end{eqnarray*}$

Step 3: Calculate the purchase price.

 PMT Setting END $N$ $2 \times 2=4$ $PV$ $?$ $FV$ $2,000$ $PMT$ $80$ $I/Y$ $5$ $P/Y$ $2$ $C/Y$ $2$

$PV=\2,112.86$

The purchase price of the bond is $\2,112.86$.

$\begin{eqnarray*} \mbox{Premium} & = & \mbox{Purchase Price}-\mbox{Face Value} \\ & = & 2,112.86-2,000 \\ & = & \112.86 \end{eqnarray*}$

The premium is $\112.86$.

Step 5: Complete the amortization of premium schedule.

Because the payment frequency and the compounding frequency are equal, no interest conversion is required. The calculations for each entry are shown in blue. The periodic yield rate is $i=\frac{5\%}{2}=2.5\%$.

 Payment Number Bond Payment Interest on Book Value at Yield Amortized Premium Book Value Remaining Premium to be Amortized $0$ $\2,112.86$ $\112.86$ $1$ $\80$ $\52.82$ $\color{blue}{(2,112.86 \times 0.025)}$ $\27.18$ $\color{blue}{(80-52.82)}$ $\2,085.68$$\color{blue}{(2,112.86-27.18)}$ $\85.68$$\color{blue}{(112.86-27.18)}$ $2$ $\80$ $\52.14$$\color{blue}{(2,085.68 \times 0.025)}$ $\27.86$$\color{blue}{(80-52.14)}$ $\2,057.82$$\color{blue}{(2,085.68-27.86)}$ $\57.82$$\color{blue}{(85.68-27.86)}$ $3$ $\80$ $\51.45$$\color{blue}{(2,057.82 \times 0.025)}$ $\28.55$$\color{blue}{(80-51.45)}$ $\2,029.27$$\color{blue}{(2,057.82-28.55)}$ $\29.27$$\color{blue}{(57.82-28.55)}$ $4$ $\80$ $\50.73$ $\color{blue}{(2,029.27 \times 0.025)}$ $\29.27$$\color{blue}{(80-50.73)}$ $\2,000$ $\0$$\color{blue}{(29.27-29.27)}$ Totals $\320$$\color{blue}{(4 \times 80)}$ $\207.14$$\color{blue}{(320-112.86)}$ $\112.86$

Things to Watch Out For

In the previous example, the result of the amortization of the premium schedule is that the investor ends up paying taxes only on $\207.14$ (the total of the interest on the book value at yield column) instead of $\320$ (the payments total). That is, by spreading the $\112.86$ capital loss over the holding period of the bond, the total taxable amount is reduced from $\320$ down to $\207.14$.

Sometimes there is a minor difference in the face value and the remaining premium to be amortized in the last row, where the last entries in these columns are off by a cent or two. This is a normal occurrence that happens because of the rounding of the entries in the schedule.

Although the calculations in an amortization of premium schedule are relatively straightforward, the manual calculations are time-consuming, especially when the schedule has a lot of rows. The amortization worksheet on a financial calculator, such as the TI BAII Plus, can be used to quickly calculate the entries for each row of the schedule.

Using the TI BAII Plus Calculator to Construct an Amortization of the Premium Schedule

To use the amortization worksheet to complete an amortization of the premium schedule:

1. Solve for any unknown quantities about the bond. You need to know all of the information about the bond first before you can use the amortization worksheet.
2. Enter all the value of all seven time value of money variables into the calculator ($N$, $PV$, $FV$, $PMT$, $I/Y$, $P/Y$, $C/Y$). If you calculated the purchase price ($PV$) in the first step, you must re-enter it rounded to two decimals and with the correct cash flow sign. Make sure the payment setting is set to END, and obey the cash flow sign convention. Because this is a bond, $PV$ (the purchase price) is negative, $FV$ (the face value) is positive, and $PMT$ (the bond payment) is positive.
3. Go to the amortization worksheet by pressing $2$nd AMORT (the $PV$ button).
4. To view the entries for a specific row of the schedule, set $P_1$ and $P_2$ to the row number. For example, to view the entries for row $5$, set $P_1=5$ and $P_2=5$:
1. At the $P_1$ prompt, enter the row number and press ENTER.
2. Press the down arrow.
3. At the $P_2$ prompt, enter the row number and press ENTER.
4. Press the down arrow.
5. The $BAL$ entry is the book value entry for the corresponding row.
6. Press the down arrow.
7. The $PRN$ entry is the amortized premium entry for the corresponding row.
8. Press the down arrow.
9. The $INT$ entry is the interest on book value at yield entry for the corresponding row.
10. Press the down arrow the return to the P$1$ screen.
5. Repeat the previous step with a different row number to view the entries for a different row.

Paths to Success

• On the amortization worksheet, $BAL$ is the book value entry, $PRN$ is the amortized premium entry, and $INT$ is the interest on book value at yield entry.
• You cannot get the entries for the last column, remaining premium to be amortized, from the amortization worksheet on the calculator. This entry will still need to be calculated manually.
• Make sure to re-enter $PV$ rounded to $2$ decimal places before using the amortization worksheet. If you enter $PV$ with all of the decimal places, you will not get the correct entries for the amortization of the premium schedule.
• As you read the entries off of the amortization worksheet on the calculator and put them in the schedule, round the entries to $2$ decimal places.

Example 4.4.2

A $\5,000$ bond has a $4\%$ coupon and is redeemable in two years. It was purchased to yield $3\%$. Construct the amortization of the premium schedule.

Solution

Step 1: Calculate the purchase price.

$\begin{eqnarray*} PMT & = & FV \times \frac{\mbox{coupon rate}}{2} \\ & = & 5,000\times \frac{0.04}{2}\\ & = & \100\end{eqnarray*}$

 PMT Setting END $N$ $2 \times 2=4$ $PV$ $?$ $FV$ $5,000$ $PMT$ $100$ $I/Y$ $3$ $P/Y$ $2$ $C/Y$ $2$

$PV=\5,096.36$

$\begin{eqnarray*} \mbox{Premium} & = & \mbox{Purchase Price}-\mbox{Face Value} \\ & = & 5,096.36-5,000 \\ & = & \96.36 \end{eqnarray*}$

Step 3: Enter the information into the time value of money buttons on the calculator.

 PMT Setting END $N$ $4$ $PV$ $-5,096.36$ $FV$ $5,000$ $PMT$ $100$ $I/Y$ $3$ $P/Y$ $2$ $C/Y$ $2$

Step 4: Complete the amortization of the premium schedule using the amortization worksheet on the calculator.

Remember, the calculator will not tell you the entries for the last column (remaining premium to be amortized), so you will need to complete this column manually.

 Payment Number Bond Payment Interest on Book Value at Yield Amortized Premium Book Value Remaining Premium to be Amortized $0$ $\5,096.36$ $\96.36$ $1$ $\100$ $\76.45$ $\23.55$ $\5,072.81$ $\72.81$ $2$ $\100$ $\76.09$ $\23.91$ $\5,048.90$ $\48.90$ $3$ $\100$ $\75.73$ $\24.27$ $\5,024.63$ $\24.63$ $4$ $\100$ $\75.37$ $\24.63$ $\5,000$ $\0$ Totals $\400$ $\303.63$ $\96.36$
• Row 1: In the amortization worksheet, set $P_1=1$ and $P_2=1$. The entry for the last column (remaining premium to be amortized) is $96.36-23.55$.
• Row 2: In the amortization worksheet, set $P_1=2$ and $P_2=2$. The entry for the last column (remaining premium to be amortized) is $72.81-23.91$.
• Row 3: In the amortization worksheet, set $P_1=3$ and $P_2=3$. The entry for the last column (remaining premium to be amortized) is $48.90-24.27$.
• Row 4: In the amortization worksheet, set $P_1=4$ and $P_2=4$. The entry for the last column (remaining premium to be amortized) is $24.63-24.63$.
• Totals Row:
• The amortized premium total is the premium ($\96.36$).
• The payments total is the sum of the payments: $4 \times 100=400$.
• The interest on book value total is the difference in the other two column totals: $400-96.36=303.63$.

Try It

1) A $\10,000$ bond has a coupon rate of $6.5\%$. The bond was purchased when there was three years to maturity and the yield rate was $5\%$. Construct the amortization of the premium schedule.

Solution
 PMT Setting END $N$ $2 \times 3=6$ $PV$ $?$ $FV$ $10,000$ $PMT$ $325$ $I/Y$ $5$ $P/Y$ $2$ $C/Y$ $2$

$PV=\10,413.11$

 Payment Number Bond Payment Interest on Book Value at Yield Amortized Premium Book Value Remaining Premium to be Amortized $0$ $\10,413.11$ $\413.11$ $1$ $\325$ $\260.33$ $\64.67$ $\10,348.44$ $\348.44$ $2$ $\325$ $\258.71$ $\66.29$ $\10,282.15$ $\282.15$ $3$ $\325$ $\257.05$ $\67.95$ $\10,214.20$ $\214.20$ $4$ $\325$ $\255.36$ $\69.64$ $\10,144.56$ $\144.56$ $5$ $\325$ $\253.61$ $\71.39$ $\10,073.17$ $\73.17$ $6$ $\325$ $\251.83$ $\73.17$ $\10,000$ $\0$ Totals $\1,950$ $\303.63$ $\413.11$

Accumulation of the Discount

When a bond is purchased for less than its face value, the result is a discount. For example, suppose an investor pays $\950$ for a $\1,000$ face value bond. If the investor holds onto the bond until maturity, the investor receives the redemption price of $\1,000$. The bond discount of $\50$ represents a capital gain for the investor. A capital gain is the amount by which the current value of an asset exceeds the original purchase price. What does the investor do with this capital gain? One option is for the investor to claim all of the capital gain as taxable income at the time of redemption, which results in a higher taxable amount at the time of redemption. But, commonly accepted practices allow the investor to distribute the capital gain over the period of time that the bond is held, and not just in the period during which the capital gain actually occurs (at maturity). This allows the investor to spread the capital gain over each payment interval, claiming a little bit of the capital gain along with each bond payment. This results in a higher taxable amount for each payment interval, but results in lower taxes overall because the capital gain is not claimed as a single lump-sum taxable expense on the maturity date. This process is called the accumulation of the discount.

The accumulation of the discount schedule records the bond payment, the amount of the discount that is claimed with each payment, the book value, and the remaining discount to be accumulated. The accumulation of the discount schedule shows how much discount is claimed with each payment and the resulting book value.

An accumulation of the discount schedule has six columns:

• Payment Number — There is a row for every bond payment during the holding period of the bond.
• Bond Payment — The periodic bond payment (PMT). All of the payments are the same, including the last payment.
• Interest on Book Value at Yield — For each row, the interest on book value entry is the interest portion of the current bond payment based on the book value from the previous row.
• Accumulated Discount — For each row, the accumulated discount entry is the amount of the discount that is claimed as a capital gain in that payment interval.
• Book Value — For each row, the book value is the face value of the bond minus the remaining unaccumulated discount.
• Remaining Discount to be Accumulated — For each row, the remaining discount is the amount of discount that is left to claim with the payments.

To fill in an accumulation of the discount schedule, you first need to have all of the details about the bond, including the face value ($FV$), the purchase price ($PV$), the bond payment ($PMT$), the number of payments ($N$), and the yield rate. If any of these quantities are missing, calculate out the missing value before completing the accumulation of the discount schedule.

$\text{Total Accumulated Discount}^{11}$

 Payment Number Bond Payment Interest on Book Value at Yield Accumulated Discount Book Value Remaining Discount to be Accumulated $0$ $\text{Purchase Price}^1$ $\text{Discount}^1$ $1$ $PMT^2$ $INT$ on $BV^3$ $AD^4$ $BV^5$ $RD^6$ $2$ $PMT^2$ $INT$ on $BV^3$ $AD^4$ $BV^5$ $RD^6$ $\vdots$ $\vdots$ $\vdots$ $\vdots$ $\vdots$ $\vdots$ $N-1$ $PMT^2$ $INT$ on $BV^3$ $AD^4$ $BV^5$ $RD^6$ $N$ $PMT^2$ $INT$ on $BV^3$ $AD^4$ $\text{Face Value}^8$ $0^9$ Totals $\text{Total Payments}^{10}$ $\text{Interest}^{12}$

HOW TO

Fill In the Accumulation of the Discount Schedule

Step 1: In row $0$, the only entries are in the book value and remaining discount to be accumulated columns. The initial book value is the purchase price of the bond and the initial remaining discount is the discount.

Step 2: Each entry in the bond payment column is the bond payment. All of the payments in this column are the same, including the last payment.

Step 3: Calculate the interest on the book value at yield. The interest is the book value from the previous row times the periodic yield rate:

$\mbox{Interest on Book Value}=\mbox{Book Value from Previous Row} \times i$

Note: this calculation uses the periodic yield rate, not the periodic bond rate.

Step 4: Calculate the accumulated discount. The accumulated discount is the difference between the interest on the book value and the payment:

$\mbox{Accumulated Discount}=\mbox{Interest on Book Value}-PMT$.

Step 5: Calculate the new book value. The book value is sum of the book value in the previous row and the accumulated discount:

$\mbox{Book Value}=\mbox{Book Value from Previous Row}+\mbox{Accumulated Discount}$.

Step 6: Calculate the remaining discount to be accumulated. The remaining discount is the difference between the remaining discount from the previous row and the accumulated discount:

$\begin{eqnarray*}\mbox{Remaining Discount}&=&\mbox{Remaining Discount from Previous Row}\\&-&\mbox{Accumulated Discount}\end{eqnarray*}$

Step 7: For each payment, repeat Steps $2$ through $6$, including for the last row.

Step 8: The last book value is the face value of the bond. If the calculations are done correctly, this will automatically happen.

Step 9: The last remaining discount to be accumulated is $0$. If the calculations are done correctly, this will automatically happen.

Step 10: The total payments is the sum of the payment column:

$\mbox{Total Payments}=N \times PMT$.

Step 11: The total accumulated discount is the sum of the accumulated discount column, and is just the discount:

$\mbox{Total Accumulated Discount}=\mbox{Discount}$.

Step 12: The total interest is the sum of the interest on book value column, and equals the sum of the other two column totals:

$\mbox{Total Interest}=\mbox{Total Payments}+\mbox{Total Accumulated Discount}$.

Paths to Success

The manual calculation of the interest on the book value entry above is based on the assumption that the payment frequency and the compounding frequency are equal. For bonds this is generally not an issue because most bonds have semi-annual payments and a yield rate that compounds semi-annually. If the payment frequency and the compounding frequency are not equal, an interest conversion would be required to convert the interest rate to the equivalent rate with the compounding frequency equal to the payment frequency. However, if you use the TI BAII Plus’s built-in amortization worksheet (described below), no interest conversion is required.

As you fill in the schedule, round the entries to two decimal places.

The accumulated discount column represents how much of the discount is claimed as a capital gain with the payment for that payment interval.

The accumulation of the discount schedule presented here assumes the bond is purchased on an interest payment date. Bonds that are not purchased on an interest payment date have added complications that will not be addressed here.

Example 4.4.3

A $\3,000$ bond with a coupon rate of $5\%$ is redeemable in two years. The bond was purchased when the yield rate was $8\%$. Construct the accumulation of the discount schedule.

Solution

Step 1: The given information is

Because no other information is given, the frequency of the payments and the compounding frequencies (for the coupon rate and the yield rate) are assumed to be semi-annual.

$\begin{eqnarray*} FV & = & \3,000 \\ P/Y & = & 2 \\ I/Y & = & 8\% \\ C/Y & = & 2 \\ t & = & 2 \mbox{ years} \\ \mbox{Coupon Rate} & = & 5\% \end{eqnarray*}$

Step 2: Calculate the bond payment.

$\begin{eqnarray*} PMT & = & FV \times \frac{\mbox{coupon rate}}{2} \\ & = & 3,000\times \frac{0.05}{2}\\ & = & \75\end{eqnarray*}$

Step 3: Calculate the purchase price.

 PMT Setting END $N$ $2 \times 2=4$ $PV$ $?$ $FV$ $3,000$ $PMT$ $75$ $I/Y$ $8$ $P/Y$ $2$ $C/Y$ $2$

$PV=\2,836.65$

The purchase price of the bond is $\2,836.65$.

Step 4: Calculate the discount.

$\begin{eqnarray*} \mbox{Discount} & = & \mbox{Face Value}-\mbox{Discount} \\ & = & 3,000-2,836.65 \\ & = & \163.35 \end{eqnarray*}$

The discount is $\163.35$.

Step 5: Complete the accumulation of discount schedule.

Because the payment frequency and the compounding frequency are equal, no interest conversion is required. The calculations for each entry are shown in blue. The periodic yield rate is $i=\frac{8\%}{2}=4\%$.

 Payment Number Bond Payment Interest on Book Value at Yield Accumulated Discount Book Value Remaining Premium to be Amortized $0$ $\2,836.65$ $\163.35$ $1$ $\75$ $\113.47$$\color{blue}{(2,836.65 \times 0.04)}$ $\38.47$$\color{blue}{(113.47-75)}$ $\2,875.12$$\color{blue}{(2,836.65+38.47)}$ $\124.88$$\color{blue}{(163.35-38.47)}$ $2$ $\75$ $\115$$\color{blue}{(2,875.12 \times 0.04)}$ $\40$ $\color{blue}{(115-75)}$ $\2,915.12$$\color{blue}{(2,915.12+40)}$ $\84.88$$\color{blue}{(124.88-40)}$ $3$ $\75$ $\116.60$$\color{blue}{(2,915.12 \times 0.04)}$ $\41.60$$\color{blue}{(116.60-75)}$ $\2,956.72$$\color{blue}{(2,915.12+41.60)}$ $\43.28$$\color{blue}{(84.88-41.60)}$ $4$ $\75$ $\118.27$ $\color{blue}{(2,029.27 \times 0.025)}$ $\43.27$$\color{blue}{(80-50.73)}$ $\2999.99$$\color{blue}{(2,956.72+43.27)}$ $\0.01$$\color{blue}{(43.28-43.27)}$ Totals $\300$$\color{blue}{(4 \times 75)}$ $\463.34$$\color{blue}{(300+163.34)}$ $\163.34$

Key Takeaways

In the previous example, there is a minor difference of $\0.01$ in the final book value and the final remaining discount to be accumulated in row $4$ and the totals in the interest on the book value and accumulated discount totals. This sometimes happens, and is caused by rounding the entries at each step.

In the previous example, the result of the accumulation of discount schedule is that the investor ends up paying taxes on $\463.34$ (the total of the interest on the book value at yield column) instead of $\300$ (the payments total). That is, by spreading the $\163.35$ capital gain over the holding period of the bond, the total taxable amount is increased from $\300$ to $\463.34$. Because the capital gain is spread out over the payments, this results in a lower tax amount overall.

Although the calculations in an accumulation of the discount schedule are relatively straightforward, the manual calculations are time-consuming, especially when the schedule has a lot of rows. The amortization worksheet on a financial calculator, such as the TI BAII Plus, can be used to quickly calculate the entries for each row of the schedule.

Using the TI BAII Plus Calculator to Construct an Accumulation of the Discount Schedule

To use the amortization worksheet to complete an accumulation of the discount schedule:

1. Solve for any unknown quantities about the bond. You need to know all of the information about the bond first before you can use the amortization worksheet.
2. Enter all the value of all seven time value of money variables into the calculator ($N$, $PV$, $FV$, $PMT$, $I/Y$, $P/Y$, $C/Y$). If you calculated the purchase price ($PV$) in the first step, you must re-enter it rounded to two decimals and with the correct cash flow sign. Make sure the payment setting is set to END, and obey the cash flow sign convention. Because this is a bond, $PV$ (the purchase price) is negative, $FV$ (the face value) is positive, and $PMT$ (the bond payment) is positive.
3. Go to the amortization worksheet by pressing $2$nd AMORT (the $PV$ button).
4. To view the entries for a specific row of the schedule, set $P_1$ and $P_2$ to the row number. For example, to view the entries for row $5$, set $P_1=5$ and $P_2=5$:
1. At the $P_1$ prompt, enter the row number and press ENTER.
2. Press the down arrow.
3. At the $P_2$ prompt, enter the row number and press ENTER.
4. Press the down arrow.
5. The $BAL$ entry is the book value entry for the corresponding row.
6. Press the down arrow.
7. The $PRN$ entry is the accumulated discount entry for the corresponding row.
8. Press the down arrow.
9. The $INT$ entry is the interest on book value at yield entry for the corresponding row.
10. Press the down arrow the return to the $P_1$ screen.
5. Repeat the previous step with a different row number to view the entries for a different row.

Paths to Success

• On the amortization worksheet, $BAL$ is the book value entry, $PRN$ is the accumulation of discount entry, and $INT$ is the interest on book value at yield entry.
• You cannot get the entries for the last column, remaining discount to be accumulated, from the amortization worksheet on the calculator. This entry will still need to be calculated manually.
• Make sure to re-enter $PV$ rounded to $2$ decimal places before using the amortization worksheet. If you enter $PV$ with all of the decimal places, you will not get the correct entries for the accumulation of the discount schedule.
• As you read the entries off of the amortization worksheet on the calculator and put them in the schedule, round the entries to $2$ decimal places.

Example 4.4.4

A $\7,000$ bond has a $3\%$ coupon and is redeemable in two years. It was purchased to yield $5\%$. Construct the accumulation of the discount schedule.

Solution

Step 1: Calculate the purchase price.

$\begin{eqnarray*} PMT & = & FV \times \frac{\mbox{coupon rate}}{2} \\ & = & 7,000\times \frac{0.03}{2}\\ & = & \105\end{eqnarray*}$

 PMT Setting END N $2 \times 2=4$ PV $?$ FV $7,000$ PMT $105$ I/Y $5$ P/Y $2$ C/Y $2$

$PV=\6,736.66$

Step 2: Calculate the discount.

$\begin{eqnarray*} \mbox{Premium} & = & \mbox{Face Value}-\mbox{Purchase Price} \\ & = & 7,000-6,736.66 \\ & = & \263.34 \end{eqnarray*}$

Step 3: Enter the information into the time value of money buttons on the calculator.

 PMT Setting END $N$ $4$ $PV$ $-6,736.66$ $FV$ $7,000$ $PMT$ $105$ $I/Y$ $5$ $P/Y$ $2$ $C/Y$ $2$

Step 4: Complete the accumulation of the discount schedule using the amortization worksheet on the calculator.

Remember, the calculator will not tell you the entries for the last column (remaining discount to be accumulated), so you will need to complete this column manually.

 Payment Number Bond Payment Interest on Book Value at Yield Accumulated Discount Book Value Remaining Discount to be Accumulated $0$ $\6,736.66$ $\263.34$ $1$ $\105$ $\168.42$ $\63.42$ $\6,800.08$ $\199.92$ $2$ $\105$ $\170$ $\65$ $\6,865.08$ $\134.92$ $3$ $\105$ $\171.63$ $\66.63$ $\6,931.71$ $\68.29$ $4$ $\105$ $\173.29$ $\68.29$ $\7,000$ $\0$ Totals $\420$ $\683.34$ $\263.34$
• Row 1: In the amortization worksheet, set $P_1=1$ and $P_2=1$. The entry for the last column (remaining discount to be accumulated) is $263.34-63.42$.
• Row 2: In the amortization worksheet, set $P_1=2$ and $P_2=2$. The entry for the last column (remaining discount to be accumulated) is $199.92-65$.
• Row 3: In the amortization worksheet, set $P_1=3$ and $P_2=3$. The entry for the last column (remaining discount to be accumulated) is $134.92-66.63$.
• Row 4: In the amortization worksheet, set $P_1=4$ and $P_2=4$. The entry for the last column (remaining discount to be accumulated) is $68.29-68.29$.
• Totals Row:
• The accumulated discount total is the discount ($\263.34$).
• The payments total is the sum of the payments: $4 \times 105=420$.
• The interest on book value total is the sum of other two column totals: $420+263.34=683.34$.

Try It

1) A $\5,000$ bond has a coupon rate of $3.6\%$. The bond was purchased when there was $2.5$ years to maturity and the yield rate was $6\%$. Construct the accumulation of the discount schedule.

Solution
 PMT Setting END $N$ $2 \times 2.5=5$ $PV$ $?$ $FV$ $5,000$ $PMT$ $90$ $I/Y$ $6$ $P/Y$ $2$ $C/Y$ $2$

$PV=\4,725.22$

 Payment Number Bond Payment Interest on Book Value at Yield Accumulated Discount Book Value Remaining Discount to be Accumulated $0$ $\4,725.22$ $\274.78$ $1$ $\90$ $\141.76$ $\51.76$ $\4,776.98$ $\223.02$ $2$ $\90$ $\143.31$ $\53.31$ $\4,830.29$ $\169.71$ $3$ $\90$ $\144.91$ $\54.91$ $\4,885.19$ $\114.80$ $4$ $\90$ $\146.56$ $\56.56$ $\4,941.75$ $\58.25$ $5$ $\90$ $\148.25$ $\58.25$ $\5,000$ $\0$ Totals $\450$ $\703.33$ $\253.33$

Section 4.4 Exercises

1. A $\20,000$ bond has a $5\%$ coupon rate. The bond was purchased when there are three years to maturity and the yield rate was $6.75\%$. Construct the appropriate bond schedule for the bond.
Solution
 Payment Number Bond Payment Interest on Book Value at Yield Accumulated Discount Book Value Remaining Discount to be Accumulated $0$ $\19,063.66$ $\936.34$ $1$ $\500$ $\643.40$ $\143.40$ $\19,207.06$ $\792.94$ $2$ $\500$ $\648.24$ $\148.24$ $\19,355.30$ $\644.70$ $3$ $\500$ $\653.24$ $\153.24$ $\19,508.54$ $\491.46$ $4$ $\500$ $\658.41$ $\158.41$ $\19,666.95$ $\333.05$ $5$ $\500$ $\663.76$ $\163.76$ $\19,830.71$ $\169.29$ $6$ $\500$ $\669.29$ $\169.29$ $\20,000$ $\0$ Totals $\3,000$ $\3,936.34$ $\936.34$
2. A $\50,000$ bond with an $8\%$ coupon is redeemable in two years. The bond was purchased when the yield to maturity was $5\%$. Construct the appropriate bond scheduled for the bond.
Solution
 Payment Number Bond Payment Interest on Book Value at Yield Amortized Premium Book Value Remaining Premium to be Amortized $0$ $\52,821.48$ $\2,821.48$ $1$ $\2,000$ $\1,320.54$ $\679.46$ $\52,142.02$ $\2,142.02$ $2$ $\2,000$ $\1,303.55$ $\696.45$ $\51,445.57$ $\1,445.57$ $3$ $\2,000$ $\1,286.14$ $\713.86$ $\50,731.71$ $\731.71$ $4$ $\2,000$ $\1,268.29$ $\731.71$ $\50,000$ $\0$ Totals $\8,000$ $\5,178.52$ $\2,821.48$
3. Three years before maturity, a $\55,000$ face value bond carrying a $5.5\%$ coupon is acquired when posted market rates are $4.77\%$ compounded semi-annually. Construct the appropriate bond schedule for the bond.
Solution
 Payment Number Bond Payment Interest on Book Value at Yield Amortized Premium Book Value Remaining Premium to be Amortized $0$ $\56,110.02$ $\1,110.02$ $1$ $\1,512.50$ $\1,338.22$ $\174.28$ $\55,935.74$ $\935.74$ $2$ $\1,512.50$ $\1,334.07$ $\178.43$ $\55,757.31$ $\757.31$ $3$ $\1,512.50$ $\1,329.81$ $\182.69$ $\55,574.62$ $\574.62$ $4$ $\1,512.50$ $\1,325.45$ $\187.05$ $\55,387.58$ $\387.58$ $5$ $\1,512.50$ $\1,320.99$ $\191.51$ $\55,196.07$ $\196.07$ $6$ $\1,512.50$ $\1,316.43$ $\196.07$ $\55,000$ $\0$ Totals $\9,075$ $\57,964.98$ $\1,110.02$
4. When the current bond market is yielding $5.89\%$ compounded semi-annually, Jennifer purchases a $\10,000$ face value bond carrying a $4.2\%$ coupon with three years until maturity for her RRSP. Construct the appropriate bond schedule for the bond.
Solution
 Payment Number Bond Payment Interest on Book Value at Yield Accumulated Discount Book Value Remaining Discount to be Accumulated $0$ $\9,541.41$ $\458.59$ $1$ $\210$ $\280.99$ $\70.99$ $\9,612.40$ $\387.60$ $2$ $\210$ $\283.09$ $\73.09$ $\9,685.49$ $\314.52$ $3$ $\210$ $\285.24$ $\75.24$ $\9,760.73$ $\239.27$ $4$ $\210$ $\287.45$ $\77.45$ $\9,838.19$ $\161.82$ $5$ $\210$ $\289.73$ $\79.73$ $\9,917.92$ $\82.08$ $6$ $\210$ $\292.08$ $\82.08$ $\10,000$ $\0$ Totals $\1,260$ $\1,718.59$ $\458.59$

14.4: Debt Retirement & Amortization” from Business Math: A Step-by-Step Handbook (2021B) by J. Olivier and Lyryx Learning Inc. through a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License unless otherwise noted.