Average score both tabs: 38% The .. Company issues 10%, 5-year bonds with a par value...

Transcribed Image Text:

Average score both tabs: 38% The .. Company issues 10%, 5-year bonds with a par value of $460,000 and semiannual interest payments. On the issue date, the annual market rate for these bonds is 9%. 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 $460,000 5 9% 10% What is the amount of each semiannual interest payment? How many semiannual payments of $23.000 will be made in total2 Using the PV function, calculate the issue price of the bond. Make sure the formula returns a positive value. See the instructions tab for help on the PV function. $23,000 Complete the amortization schedule for these bonds. Make sure all formulas return positive values. Cash Interest Bond Interest Premium Amortization Unamortized Premium Carrying Value Semiannual Interest Period Paid Expense 0 1 $23,000.00 2 $23,000.00 3 $23,000.00 4 $23,000.00 5 $23,000.00 6 $23,000.00 7 $23,000.00 8 $23,000.00 9 $23,000.00 10 $23,000.00 Totals $230,000.00 $0.00 $0.00 Average score both tabs: 38% The .. Company issues 10%, 5-year bonds with a par value of $460,000 and semiannual interest payments. On the issue date, the annual market rate for these bonds is 9%. 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 $460,000 5 9% 10% What is the amount of each semiannual interest payment? How many semiannual payments of $23.000 will be made in total2 Using the PV function, calculate the issue price of the bond. Make sure the formula returns a positive value. See the instructions tab for help on the PV function. $23,000 Complete the amortization schedule for these bonds. Make sure all formulas return positive values. Cash Interest Bond Interest Premium Amortization Unamortized Premium Carrying Value Semiannual Interest Period Paid Expense 0 1 $23,000.00 2 $23,000.00 3 $23,000.00 4 $23,000.00 5 $23,000.00 6 $23,000.00 7 $23,000.00 8 $23,000.00 9 $23,000.00 10 $23,000.00 Totals $230,000.00 $0.00 $0.00