In: Accounting
4. ABC Corp issues a $1000.00 bond. The bond is priced at $1,052.42. It matures in three (3) years. The bond pays a 10% coupon and it yields 8% compounded semiannually. Prepare a bond premium amortization schedule for the bond.
Step-1:Semi annual payment | ||||||
Semi annual payment | = | =PMT(rate,nper,-pv,fv) | Where, | |||
= | $ 50.00 | rate | = | 4% | ||
nper | = | 6 | ||||
pv | = | $ 1,052.42 | ||||
fv | = | $ 1,000.00 | ||||
Step-2:Bond premium amortization | ||||||
Semi annual period: | ||||||
Semi annual coupon | Interest Expense | Premium amortized | Unamortized Premium | Carrying Value | ||
0 | $ 52.42 | $ 1,052.42 | ||||
1 | $ 50.00 | $ 42.10 | $ 7.90 | $ 44.52 | $ 1,044.52 | |
2 | $ 50.00 | $ 41.78 | $ 8.22 | $ 36.30 | $ 1,036.30 | |
3 | $ 50.00 | $ 41.45 | $ 8.55 | $ 27.75 | $ 1,027.75 | |
4 | $ 50.00 | $ 41.11 | $ 8.89 | $ 18.86 | $ 1,018.86 | |
5 | $ 50.00 | $ 40.75 | $ 9.25 | $ 9.62 | $ 1,009.62 | |
6 | $ 50.00 | $ 40.38 | $ 9.62 | $ 0.00 | $ 1,000.00 | |
Working: | ||||||
Interest expense | = | Carrying value at the end of previous period | * | Semi annual yield | ||
= | $ 1,052.42 | * | 4% | |||
= | $ 42.10 | |||||
Premium amortized | = | Semi annual coupon | - | Interest Expense | ||
= | $ 50.00 | - | $ 42.10 | |||
= | $ 7.90 | |||||
Unamortized Premium | = | Unamortized Premium at end of previous period | - | Premium amortized | ||
= | $ 52.42 | - | $ 7.90 | |||
= | $ 44.52 | |||||
Carrying value | = | Carrying value at end of previous period | - | Premium amortized | ||
= | $ 1,052.42 | - | $ 7.90 | |||
= | $ 1,044.52 |