please answer in Excel format!Both Bond Sam and Bond Dave have $6\mathrm{.}5$ percent coupons, make

semiannual payments, and are priced at par value. Bond Sam has $3$

years to maturity, whereas Bond Dave has $20$ years to maturity. If

interest rates suddenly rise by $2$ percent, what is the percentage

change in the price of Bond Sam? Of Bond Dave? If rates were

suddenly fall by $2$ percent instead, what would the percentage

change in the price of Bond Sam be then? Bond Dave? Illustrate your

answers by graphing bond prices versus YTM$.$ What does this problem

telll you about the interest rate risk of longer$-$term bonds?$$use $=$price$()$ function for c$29$