Question 6. Use Excel to do the bond immunization (50): The fund will have to pay the fund investors $1,000,000 after two years. Investors require that the fund invest in only annual coupon bonds: 1) Three year 8.5% bonds 2) Rolling one year 8% bonds Both come in denominations of $1000. Market Yield is 9%. Residual Cash can earn a market yield. Notice: you should invest more than present value of the liability amount. Hence, if you find you should invest in 481.74 shares of 8.5% bond, then you should buy 482 shares of 8,5% bond. If you find you should invest in 369.43 shares of 8% bond, then you should buy 370 shares of 8.0% bond. Find out the portfolio value when market yield is 10% and 8% after investing. Question 6. Use Excel to do the bond immunization (50): The fund will have to pay the fund investors $1,000,000 after two years. Investors require that the fund invest in only annual coupon bonds: 1) Three year 8.5% bonds 2) Rolling one year 8% bonds Both come in denominations of $1000. Market Yield is 9%. Residual Cash can earn a market yield. Notice: you should invest more than present value of the liability amount. Hence, if you find you should invest in 481.74 shares of 8.5% bond, then you should buy 482 shares of 8,5% bond. If you find you should invest in 369.43 shares of 8% bond, then you should buy 370 shares of 8.0% bond. Find out the portfolio value when market yield is 10% and 8% after investing