lipboard LO E H D G 36% Name Matt Saputo Your score this tab The Matt Saputo 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 $520.000 31 Par Value Term (years) Annual market % Annual contract % Payments per year 11% 10% 2 What is the amount of each semiannual interest payment? $507 011 621 Complete the amortization schedule for these bonds Semiannual Cash Interest Bond Interest Discount Interest Period Paid Expense Amortization Unamortized Discount Carrying Value $507 011.62 0 1 2 3 4 5 6 + Totals $0.00 $0 00 $0.00 Instructions Bond 1 Bond 2 Type here to search Form Coboard Number Font Alignment BA 8 D E G Name: Matt Saputo Your score this tab. 3696 Average score both tabs % The Malt Saputo 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 $470,000 Par Value Term (years) Annual market % Annual contract % Payments per year 10% 119 What is the amount of each semiannual interest payment? $481,927.88 Complete the amortization schedule for these bonds. Make sure all formulas return positive values. Semiannual Cash Interest Bond Interest Prernium Unamortized Carrying Interest Period Paid Expense Amortization Premium Value $481,927 88 0 1 2 3 4 5 6 Totals $0.00 $0.00 $0.00 Instructions Bond Bond 2 Type here to search a