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

Bond Bond Period Beginning Coupon Interest Change in Balance