2. Given the settlement date of April 29, 2021, use the info from previous problem to calculate on this spreadsheet (not a separate sheet) the bond price, duration, con 3 and show the formulas in the orange cells. 4 Settlement date 29-Apr-21 Bond Price Formula 5 Maturity date 31-May-25 2. 93% Convexity Formula J Coupon 2.875% 8 Face value 100 Frequency 2 Use Excel's Data Table to run a sensitivity analysis of the duration as a function of the coupon rate 0 (coupon rate=0%, 1%, 2%, 3%, 4%, 5%, 6%, 7%, 9%, 13%, 15%, 17%) and comment on the effect of coupon on the duration. 1 Modified Duration 2 Build a chart of the duration as a function of the coupon rate. 3. What is the interpretation of the modified duration? What is the interpretation of the convexity? 4 5 6 7 8 9 2. Given the settlement date of April 29, 2021, use the info from previous problem to calculate on this spreadsheet (not a separate sheet) the bond price, duration, con 3 and show the formulas in the orange cells. 4 Settlement date 29-Apr-21 Bond Price Formula 5 Maturity date 31-May-25 2. 93% Convexity Formula J Coupon 2.875% 8 Face value 100 Frequency 2 Use Excel's Data Table to run a sensitivity analysis of the duration as a function of the coupon rate 0 (coupon rate=0%, 1%, 2%, 3%, 4%, 5%, 6%, 7%, 9%, 13%, 15%, 17%) and comment on the effect of coupon on the duration. 1 Modified Duration 2 Build a chart of the duration as a function of the coupon rate. 3. What is the interpretation of the modified duration? What is the interpretation of the convexity? 4 5 6 7 8 9