excel working please

Suppose you purchase a 30-you, aro-coupon bond with a yield to maturity of 6%. You hold the bond for five years before selling it. Note assume $100 face value. Complete the steps below' wing adl nefernoer to given data or previous atlafations. In some cames, a simple oill roference is all you ned. To copypatfe a formula acrocr a row or down a colimin, an absolute coll roference or a mind cell refermae may be preferred. If a spedfic Etod function is to be wsat, the dirnetions will spealfy the wre of that funcilon Do nor rype in numerical data into a cell or funcrion. Instead, make a reference to the cell in which the data is found. Make your computafions only in the blue cells highlighied below. In all cates, wmles othenvire direated, wate the aurliedt. appeurance of the data in your formulas, usually the Giver Data section. a. If the bond's yicld to moturity is 6% when you sell it, what is the annualizad rate of retum of your investment? b. If the bond's yield to maturity is 7% when you sell it, what is the annualized rate of retum of your investment? c. If the bond's yield to matarity is 5% when you sell it, what is the annualiad rate of retum of your investment? d. Even if a bond has no chance of default, is your investment risk free if you plan to sell it before it matures? Explain. a. If the bond's yield to maturity is 6% when you sell it, what is the annualizod rate of retum of your investment? b. If the bond's yield to maturity is 7% when you sell it, what is the annualiaod rate of retum of your investment? c. If the bond's yield to maturity is 5% when you sell it, what is the annualized ne of return of your investment