Use Excel to prepare a Bond Interest and Discount Amortization Table using the following information:

$50,000,000 face value

coupon rate of interest - 6%

market rate of interest - 7%

term - 10 years payable semi-annually

First calculate the proceeds received upon issuance and the amount of the discount