In: Accounting
O’Biren Corporation issues bonds with $8,000,000 face value and 8% coupon rate (paid semi-annually), which mature in 5 years. The market initially prices these bonds to yield 6%, compounded semi-annually. Prepare the bond amortization schedule following the format below. Please round up the number to one dollar. Please do this in Excel first and then copy the numbers to the table below.
Period |
Bond Beginning Balance |
Coupon Amount |
Interest Expense |
Change in Bond Value |
Bond Ending Balance |
1 | |||||
2 | |||||
3 | |||||
4 | |||||
5 | |||||
6 | |||||
7 | |||||
8 | |||||
9 | |||||
10 |