You are considering an investment in the Tesla bonds. The bonds pay interest semiannually, mature in 30 years, and have a coupon rate of 8.4% with par value of $1,000. The current price of the bonds is $1174. Please complete this problem using a fresh Excel spreadsheet. a. If the YTM changes to 6.5%, what is the price of the bond? (Use the PV function) b. Calculate the price of the bond each year until maturity, assuming the YTM remains the same. Chart your results. Include a line in your chart showing par value. c. What is the current yield of the bond? d. What is the YTM of the bond if you purchase at the current price of $1174 ? e. Assume that the settlement date for your purchase is 11/1/2020 and the maturity date is 11/1/2050. Use the PRICE and YIELD functions to recalculate your results from parts a) and d)