#1 At 12% ACC 300 Activities CH 5 Fall 2020 Total: 4 points. The Agawa Canyon Corp. issued ten-year bonds with a face amount of $5,000,000 on January 1, 2020. The bonds have a stated interest rate of 6% payable semi-annually, each January 1 and July 1. The bonds were priced to yield 8%. Present value factors are as At 3% At 4% At 6% At 8% follows: Present value of $1 for 10 periods 0.74409 0.67556 0.55839 0.46319 Present value of $1 for 20 periods 0.55368 0.45639 0.3118 0.21455 Present value of an ordinary annuity of $1 for 10 periods 8.5302 8.1109 7.36009 6.71008 Present value of an ordinarv annuity of $1 for 20 periods 14.87747 13.59033 11.46992 9.818 The face amount of the bonds is: 5,000,000 Stated interest rate (for six months) 6% Market interest rate (for one year) 8% The annual amount of interest expense is: REQUIRED: Calculate the interest expense for the whole year and present in cell D11. Reference data cells in rows 5 through 13 in your calculations below. Don't use a calculator and type in answers. 0.32197 0.10367 5.65022 7.46944 1 pt. 1 pt. Calculate the price of the bond on Jan 1, 2020. Use the present value function in Excel. Put your answer in the yellow box. Calculate the price of the bond on Jan 1, 2020. Add the present value of the interest component and principal component of the bond. Put your answers in the yellow boxes to the right. 1 pt. 1 pt. PV of interest PV of principal Total price of the bond Do your answers in cell E16 and E20 agree? If not, go back and make sure they do (ignore small rounding differences). Don't worry if the sign of your answers are different. #1 At 12% ACC 300 Activities CH 5 Fall 2020 Total: 4 points. The Agawa Canyon Corp. issued ten-year bonds with a face amount of $5,000,000 on January 1, 2020. The bonds have a stated interest rate of 6% payable semi-annually, each January 1 and July 1. The bonds were priced to yield 8%. Present value factors are as At 3% At 4% At 6% At 8% follows: Present value of $1 for 10 periods 0.74409 0.67556 0.55839 0.46319 Present value of $1 for 20 periods 0.55368 0.45639 0.3118 0.21455 Present value of an ordinary annuity of $1 for 10 periods 8.5302 8.1109 7.36009 6.71008 Present value of an ordinarv annuity of $1 for 20 periods 14.87747 13.59033 11.46992 9.818 The face amount of the bonds is: 5,000,000 Stated interest rate (for six months) 6% Market interest rate (for one year) 8% The annual amount of interest expense is: REQUIRED: Calculate the interest expense for the whole year and present in cell D11. Reference data cells in rows 5 through 13 in your calculations below. Don't use a calculator and type in answers. 0.32197 0.10367 5.65022 7.46944 1 pt. 1 pt. Calculate the price of the bond on Jan 1, 2020. Use the present value function in Excel. Put your answer in the yellow box. Calculate the price of the bond on Jan 1, 2020. Add the present value of the interest component and principal component of the bond. Put your answers in the yellow boxes to the right. 1 pt. 1 pt. PV of interest PV of principal Total price of the bond Do your answers in cell E16 and E20 agree? If not, go back and make sure they do (ignore small rounding differences). Don't worry if the sign of your answers are different
