please use excel and the formulas used

m e paration for your answer. 14. Suppose you purchase a 30-year. zero-coupon bond with a yield to matur hond for five years before selling it. year, zero-coupon bond with a yield to maturity of 8%. You hold the a. If the bonds yield to maturity is 6% when you sell it, what is the inte investment? 0% when you sell it, what is the internal rate of return of your b. If the bond's yield to maturity is 70% when you sell it, what is the internal murity is 7% when you sell it, what is the internal rate of return of your investment? c. If the bond's yield to maturity is 5% when you sell it, what is the internal rate on investment? . Even if a bond has no chance of default is your investment risk-free if you plan to se matures? Explain