Given a bond with a 15-year maturity, 4% coupon rate, and sells at an initial value of 4%, create an excel table to calculate this bonds duration, modified duration and convexity.

a. If the bonds yield increases from 4% to 5%, find the percentage decrease of the bond using the approximation formula

b. If the bonds yield increases from 4% to 5%, find the percentage decrease of the bond using the duration with convexity formula