Please use cell referencing

Home Inser Draw Page Layout Formulas Data Review View D Cut Calibri (Body) 11A A Copy Paste Format Blyv v-v N23 Problem 6-25 Suppose yo purchase a 30-year, zero co pon bond with a yoeld o maturity of 6%. You hold the bood for frve years before selling t. Note: assume$100 face valbe Complete the steps below aring cell refereaces so given data or previows calewlonions. I some cases, a simple cell reference is all you need To copypase a formsla across a row or dons a columa an absolute cell reference or a mixed cell reference may be preferred lf a specyic Excel fanctiow is to be used, the directions wall specify the sse of shat furaction. Do not type ie merical data to a cell or fanction. Istead make a reference to the cell in whick the data is found Make your compatioes ouly in the blwe cells kighighted below Ia all cases, wless okerwise directed, e the earliest appearance of the data se yourfomwlas, wally the Giver Data section If the bood's yield io maturity is 6% when you sell it, what is the annualized rate of return of your investment? If the bond's yield so maturity is%when you sell in, what is the anmalized rate of return of your investment! If the bood's yield io maturny is 5% when you sell it, what is the annualized rate of return of your investment? Even if a bond has no chance of defauh, is your investment risk free if you plano sell it be fore it matures? Explai Maturity (years) Face value Yield to maturity Holding period (years) L fthe bond's yield to matury is 6% when you sell it, what is the annualized rate of return of your investment? Purchase price Maturity when sold (years) Bond price when sold Rate of retur If the bond's yield so maturity is%when you sell in, what is the anmalized rate of return of your investment! Yield so maturiy Bond price when sold Rate of retur If the bond's yield io maturity is 5% when you sell it, what is the annualized rate of return of your investment? Yield so maturiy Bond price when sold Rate of retur Even if a bond has no chance of defauh, is your investment risk free if you plano sell it be fore it matures? Explai If you sell prior to maturiy, yon are exposed to the risk that the may change 41 Requirements