2. As a pension fund manager, you must make a payment of $1,000,000 in three years. You can potentially fund the obligation using the following 2 instruments: (1) an 8% annual coupon, 4-year maturity bond (currently priced at $936.6), and (2) a 1-year zero coupon bond. The market interest rate is 10%. a. What are the duration and modified duration of the 8% annual coupon, 4-year maturity bond? b. What are the duration and modified duration of the zero-coupon bond? c. Find the asset mix (weights) between instruments 1 and 2 that would immunize the obligation. d. From part (c), how much money would you invest in instruments 1 and 2 at present to fully fund the obligation? (Hint: you should invest PV of 1 million) IN EXCEL PLEASE