Hi for this problem I need to modify and add to the Duration and Immunization spreadsheet for a bond with a $5$ year maturity, $$1000$ face value, $12\%$ coupon, initial YTM of $10\%.$ Restate the base case and the immunization case and answer the following questions.

$1.$ Describe $($using the data in the problem$)$ what happens when interest rates go up or down by $1\%(100$ Basis Points$)$ if the bond is held until maturity.$$ Also report the standard deviation among the outcomes at maturity.

$2.$ Describe $($using the data in the problem$)$ what happens when interest rates go up or down by $1\%(100$ Basis Points$)$ if the bond is held until duration.$$ Also report the standard deviation among the outcomes at duration.