Please Show Work

Answers are to be entered in the yellow-shaded areas. Amount ($) Maturity (years) Settlement date Maturity date Coupon rate (%) Price ($) Yield (%) 100.00000 20 2/15/2020 2/15/2040 7.25% 100.40695 Increase in yield 1 basis point 200 basis points 0.01% 2.00% New yield (%) New price ($), using PRICE function Actual price growth (%) Modified duration Price growth (predicted by duration) Price (predicted by duration) Price difference due to convexity Answers are to be entered in the yellow-shaded areas. Amount ($) Maturity (years) Settlement date Maturity date Coupon rate (%) Price ($) Yield (%) 100.00000 20 2/15/2020 2/15/2040 7.25% 100.40695 Increase in yield 1 basis point 200 basis points 0.01% 2.00% New yield (%) New price ($), using PRICE function Actual price growth (%) Modified duration Price growth (predicted by duration) Price (predicted by duration) Price difference due to convexity