YTM Question 4: (5 points) Given the settlement date of May 4, 2020, use the info from previous problem to calculate on this spreadsheet(not a separate sheet) the bond price, duration, convexity and show the formulas in the orange cells. Settlement date 04.05.2020 Bond Price Formula Maturity date 30.04.20251 0.394951 Convexity Formula Coupon 0.375 Face value 1001 Frequency Use Excel's Data Table to run a sensitivity analysis of the duration as a function of the coupon rate (coupon rate 0%, 1%,2%,3%,4%,5%,6%,7%,9%,13%,15%,17%)and comment on the effect of coupon on the duration, Modified Duration Build a chart of the duration as a function of the coupon rate. What is the interpretation of the modified duration? What is the interpretation of the convexity