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 it in Excel first and then copy the numbers to the table below.

Period

Bond Liab. Beginning Balance

Coupon Amount

Interest Expense

Change in Bond Liab.

Bond Liab. Ending Balance

1

2

3

4

5

6

7

8

9

10

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. Bond Liab. Period Beginning Coupon Interest Change in Bond Liab. Balance Amount Expense Bond Liab. Ending Balance I A W N 10