how to do in excel for Approximate modified duration and approximate duration

c$.$ On your sheet labelled 'Part c$\text{'}$ do the following.

Consider the move in yield from $i_0=8\%$ to $i_1=6\%.$ By adjusting our

approximate formula for modified duration, calculate the $($approximate$)$ duration

$($in years$)$ of each of the three Treasury bonds maturing in $8$ years we worked with

above $($one with $4\%$ coupon, one with $10\%$ coupon, and one with $22\%$ coupon$).$

Next, consider the move in yield from $i_0=16\%$ to $i_1=18\%.$ Using your formula

above, calculate the $($approximate$)$ duration $($in years$)$ of each of the three

Treasury bonds maturing in $8$ years we worked with above $($one with $4\%$ coupon,

one with $10\%$ coupon, and one with $22\%$ coupon$).$

The approximate formula for modified duration, shown in the week $8$ lecture

notes on slide $31.$ You are not required to calculate the exact duration, but you

need to calculate the approximate duration.

Modified Duration $=\frac{-1}{P(i_0)}*[\frac{P(i_1)-P(i_0)}{i_1-i_0}]$

The table below is the recommended format, you can add more columns if

necessary.