Please show work using Excel

Period 1 Period 2 Period 3 40 40 40 B 20 120 20 10 10 110 14. Duration Calculate durations and modified durations for the 3% bonds in Table 3.2. You can follow the procedure set out in Table 3.4 for the 9% coupon bonds. Confirm that modified duration closely predicts the impact of a 1% change in interest rates on the bond prices. Period 1 Period 2 Period 3 40 40 40 B 20 120 20 10 10 110 14. Duration Calculate durations and modified durations for the 3% bonds in Table 3.2. You can follow the procedure set out in Table 3.4 for the 9% coupon bonds. Confirm that modified duration closely predicts the impact of a 1% change in interest rates on the bond prices