You just purchased a $1000 par value bond maturing on December 31, 2020. Suppose today's date (settlement date) is December 31, 2015 and the yield to maturity is 6%. Given all these inputs, do the following: Assume the bond is a zero coupon bond (with annual compounding). Compute the bond's Macaulay duration (using the DURATION function) and modified duration (using the MDURATION function) Holding everything else constant, now assume the bond pays coupons semi-annually. Compute the bond's Macaulay and modified durations for the following annual coupon rates: 4%, 5%, 6%, 7%, and 8%. a) b) c) Continue with the bond in part ( b ), but now assume (i) the annual coupon rate is 7% and (ii) the maturity date is now December 31, 2025. Compute the bond's Macaulay and modified durations. d) Continue with the bond in part ( b ), but now assume (i) the annual coupon rate is 7%, (ii) the maturity date is again December 31, 2020 and (iii) the yield to maturity is 5%. Compute the bond's Macaulay and modified durations