PLEASE DO IT IN EXCEL!

You need $100million in five years to complete 4) enough money to finance the project through a donation campaign, now you need to invest it to make sure you don't get burned by interest rate risk. The only investments that you are allowed to use are two year, 5% coupon, $1000 face value bonds that are currently selling at par and eight year, 8% coupon, $1000 face value bonds that have an annual discount rate of 5%. Form an immunized portfolio that will be worth $100million in five years. Show how much your portfolio is worth in year five if interest rates fall after the first year to 4% on both bonds. major construction project. You have raised a You need $100million in five years to complete 4) enough money to finance the project through a donation campaign, now you need to invest it to make sure you don't get burned by interest rate risk. The only investments that you are allowed to use are two year, 5% coupon, $1000 face value bonds that are currently selling at par and eight year, 8% coupon, $1000 face value bonds that have an annual discount rate of 5%. Form an immunized portfolio that will be worth $100million in five years. Show how much your portfolio is worth in year five if interest rates fall after the first year to 4% on both bonds. major construction project. You have raised a