Need this done in excel ASAP

Problem 2 (15 points) Your firm has an obligation to pay out $60,000 in 4 years and $190,000 in 8 years. You want to immunize this liability with zero coupon bonds that have a maturity of 3 years and a perpetuity that makes annual payments. The current market interest rate is 59. a. Calculate the duration of the liability. b. What is the duration of the zero coupon bond? What is the duration of the perpetuity! c. What proportions of your investment should you put into the zero.coupon bond and into the perpetuity to immunize your position d. How much in dollars, should you invest in each of the assets/ e. What is the face value of your investment in the zero-coupon bond? Altach File Browse My Compute Browse Content Collection