Both Bond Sam and Bond Dave have $6\mathrm{.}5\%$ 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\%,$ what is the percentage change in the price of Bond Sam? Of Bond Dave? If rates were to suddenly fall by $2\%$ instead, what would the percentage change in the price of Bond Sam be then? Of Bond Dave? All bond price answers should be dollar prices.

Price at current YTM:

Price of Bond Sam:

Price of Bond Dave:

Price if YTM increases:

Price of Bond Sam:

Price of Bond Dave:

$\%$ change in Bond Sam:

$\%$ change in Bond Dave:

Price if YTM decreases:

Price of Bond Sam:

Price of Bond Dave:

$\%$ change in Bond Sam:

$\%$ change in Bond Dave:

PLEASE ANSWER USING THE CELL BOXES SHOWN IN THE IMAGE. I NEED TO SUBMIT AS EXCEL FORMULAS. THANK YOU.