Applying Excel #9-2 LO 9-5, 9-6, 9-7) On January 1, 2021, a company issued 10 year. $3,000,000,6% bonds with semiannual interest payments. The market interest rate for these bonds is 7% Required: (a) Calculate the issue price of the bonds and determine whether the bonds issued at face amount at a discount, or at a premium. Pare 472 Also, (b) complete the amortization schedule for the first four semiannual interest payments, (c) record the issuance of the bonds. and record the (d) first semiannual interest payment and (e) second semiannual interest payment. How would your answers change if the bonds had an 8 stated interest rate? April 17, 2020 at 2:21 PM Complete in an excel worksheet