You have just been hired as a bond portfolio manager for a small corporation and you anticipate that you will have a significant liability of $14 million coming due in 3 years. As the portfolio manager, you are thinking of using a barbell strategy to immunize. You are considering investing enough money in the following two bonds to protect your corporation against interest rate risk: a 3-year bond with a coupon rate of 12%, and a 6-year bond with a coupon rate of 8%. The yield curve is flat at 10%. How many of each bond you would need to purchase for complete immunization? Assume a face value of 1,000. Show all your calculations in detail. Marks will be given only to accurate numbers. Calculate up to two decimals. Submit all your working files (e.g., Excel file(s)). A screenshot of Excel would not be accepted. You have just been hired as a bond portfolio manager for a small corporation and you anticipate that you will have a significant liability of $14 million coming due in 3 years. As the portfolio manager, you are thinking of using a barbell strategy to immunize. You are considering investing enough money in the following two bonds to protect your corporation against interest rate risk: a 3-year bond with a coupon rate of 12%, and a 6-year bond with a coupon rate of 8%. The yield curve is flat at 10%. How many of each bond you would need to purchase for complete immunization? Assume a face value of 1,000. Show all your calculations in detail. Marks will be given only to accurate numbers. Calculate up to two decimals. Submit all your working files (e.g., Excel file(s)). A screenshot of Excel would not be accepted