excel formulas only. thanks.

(Excel Formulas) You are considering an investment in the bonds of the Front Range Electric Company. The bonds pay interest quarterly, will mature in 15 years and have a coupon rate of 5% on a face value of $1,000. Currently, the bonds are selling for $960. Assume that the settlement for your purchase is 7/30/2018, the maturity date is 7/30/2033. Type in the Excel formulas you should enter in the cells with bold borders in the table below to solve the following problems. a. If your required rate of return is 5.5% for bonds in this risk class, what is the highest price you would be willing to pay for the bond? (Use PRICE function) (3 Points) b. What is the current yield of these bonds? (2 Points) c. What is the yield to maturity on these bonds if you purchase them at the current price? (Use YIELD function) (3 Points) d. If the bonds can be called in three years (7/30/2021) with a call premium of 4% of the face value, what is the yield to call? (Use YIELD Function) (3 Points) e. Create an IF statement in Cell B16 to show whether these bonds are undervalued, overvalued, or fairly valued. (3 Points) A 1 B Front Range Electric Company Bonds 7/30/2018 2 3 7/30/2033 4 Settlement Date Maturity Date Call Date Price Face Value 7/30/2021 5 S960 6 SL000 alued, or fairly valu 1 B 2 Settlement Date 3 Maturity Date 4 Call Date 5 Price 6 Face Value 7 Call Premium % 8 Coupon Rate 9 Frequency 10 Required Return 11 Front Range Electric Company Bonds 7/30/2018 7/30/2033 7/30/2021 $960 $1.000 4.00% 5.00% 4 5.50% 12 13 a. Value b. Current Yield c. Yield to Maturity d. Yield to Call 14 15 16 e. If Statement