IN EXCEL, PLEASE. QUESTION 4 & 5, PLEASE.

Bond Valuation: You are considering an investment in the bonds of the Front Range Electric Company. The bonds pay interest semiannually, will mature in 15 years, and have a coupon rate of 6% on a face value of $1,000. Currently, the bonds are selling for $920. Answer the following questions: 3. If your required return is 6.80% for bonds in this risk class, what is the highest price you would be willing to pay? What is the yield to maturity on the bonds if you purchase them at the current price? 4. Now assume that the settlement date for your purchase is 7/30/2020, the maturity date is 7/30/2035, and the first call date is 7/30/2023. what is the highest price you would be willing to pay? What is the yield to maturity on the bonds? 5. Create a chart that shows the relationship of the bond's price to your required return. Use a range of 0% to 15% in calculating the prices. Bond Valuation: You are considering an investment in the bonds of the Front Range Electric Company. The bonds pay interest semiannually, will mature in 15 years, and have a coupon rate of 6% on a face value of $1,000. Currently, the bonds are selling for $920. Answer the following questions: 3. If your required return is 6.80% for bonds in this risk class, what is the highest price you would be willing to pay? What is the yield to maturity on the bonds if you purchase them at the current price? 4. Now assume that the settlement date for your purchase is 7/30/2020, the maturity date is 7/30/2035, and the first call date is 7/30/2023. what is the highest price you would be willing to pay? What is the yield to maturity on the bonds? 5. Create a chart that shows the relationship of the bond's price to your required return. Use a range of 0% to 15% in calculating the prices