The Mazumder Abdullaah Company issues 10%, 3-year bonds with a par value of $520,000 and semiannual interest payments. On the issue date, the annual market rate for these bonds is 11%. Enter a valid Excel formula or function in each of the yellow cells below. Formulas must refer to cells addresses. Entering a value will be marked as incorrect Par Value Term (years) Annual market % Annual contract % Payments per year $520,000 3 11% 10% 2 4 5 What is the amount of each semiannual interest payment? 36 17 18 19 20 Complete the amortization schedule for these bonds. Semiannual Cash Interest Bond Interest Discount Interest Period Paid Expense Amortization 21 22 0 23 1 24 2 25 3 26 4 27 5 28 6 29 30 Unamortized Discount Carrying Value Totals $0.00 $0.00 $0.00 33 34 35 The Mazumder Abdullaah Company issues 11%, 3-year bonds with a par value of $470,000 and semiannual interest payments. On the issue date, the annual market rate for these bonds is 10%. Enter a valid Excel formula or function in each of the yellow cells below. Formulas must refer to cells addresses. Entering a value will be marked as incorrect Par Value Term (years) Annual market % Annual contract % Payments per year $470,000 31 10% 11% 2 What is the amount of each semiannual interest payment? 6 7 18 19 20 Complete the amortization schedule for these bonds. Make sure all formulas return positive values Semiannual Cash Interest Bond Interest Premium Unamortized Carrying Interest Period Paid Expense Amortization Premium Value 21 22 23 24 25 0 1 2 3 4 5 6 26 27 28 29 30 31 32 Totals $0.00 $0.00 $0.00 33 34 35