how would i do this in excel. pls help im so stressed.

Part 2: Duration and Rate of Return Consider a five-year $1,000 face value, Treasury bond with a 5 percent semiannual coupon selling at par. E) Calculate the duration if the yield to maturity is 7% (5 Points) F) Calculate the duration if the yield to maturity is 12% (5 Points) G) Calculate the duration if the yield to maturity is 17% ( 5 Points) H) Plot the relationship between yield to maturity ( x-axis) and the duration ( y-axis). Be sure to label the y-axis, x-axis, and chart title ( 5 points) In your report, identify and comment on the relationship between duration and yield to maturity. Part 2: Duration and Rate of Return Consider a five-year $1,000 face value, Treasury bond with a 5 percent semiannual coupon selling at par. E) Calculate the duration if the yield to maturity is 7% (5 Points) F) Calculate the duration if the yield to maturity is 12% (5 Points) G) Calculate the duration if the yield to maturity is 17% ( 5 Points) H) Plot the relationship between yield to maturity ( x-axis) and the duration ( y-axis). Be sure to label the y-axis, x-axis, and chart title ( 5 points) In your report, identify and comment on the relationship between duration and yield to maturity