Excel Formulas You are considering an investment in the bonds of the Front Range Electric Company. The bonds pay interest quarterly, wil mature in 15 years and have a coupon rate of 5% on a face vabe of 51.000. Outrently, the bonds are selling for $960. Assume that the settlement for your purchase 57/30/2010. the maturity date la late in 7/30/2013 Type in the Excel formulas you should enter in the cells with bold borders in the table below to solve the following problems H our required rate of return is 5.5% for bonds in this fick class what the highest price you would be willing to pay for the bond? (Use PRICE function) (3 Points 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 priele VIELD function Point d. If the bands can be cated in free vers 17/30/20211 with a colt premium ox of the face wake what is the veld to co? (U VIELD Function () Points) Create an statement in Cet016 to show whether these bands are underved overvalued, or faired Point A B + 1 Front Range Electric Company Bonds 2 Settlement Date 7/30/2018 3 Maturity Date 7/30/2033 Call Date 7/30/2021 Price 5960 Face Value $1,000 7 Call Premium 4.00 8 Coupon Rate 5.00 9 Frequency + 10. Required Return 5.50% 11 12 a. Value 13 b. Current Yield 14 Yield to Maturity 15 d. Yield to Call 16 c. Ir Statement