help with the following question:

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 rst and then copy the numbers to the table below. Bond Liab. . Bond Liab. Period Be innin Coupon Interest Change in En din g g Amount Expense Bond Liab. g Balance Balance