1. A company was ordered by the court in settlement of a class action suit to make a total payment of 51 , 000,000 as per the following schedule: The company has to set up a trust fund and put sufficient amount of money into it at the beginning of year 1 so that the payments can be made on schedule. The fund managers can invest any surplus funds lying with them in short term bonds so that the interest earned along with the principal can be utilized to make the payments as required. There are three available bonds of different years to maturity: A (1-year), B (2-year), and C (3-year). The returns on maturity on the different bonds are: 4% on A,10% on B, and 18% on C. Because the final payment is made at the beginning of year 5 , effectively the investment options available in different years are: he company wishes to find an investment strategy that will allow the fund to make the nec yments from the minimum amount of money needed for the fund. (a) Set up this multi-period cash flow problem algebraically. (15 points) (b) Use Excel Solver to solve the problem and e-mail your answer to subhash.ray@uconn.edu. (20 points) c) What is the minimum initial endowment needed for the fund? (5 points) 1. A company was ordered by the court in settlement of a class action suit to make a total payment of 51 , 000,000 as per the following schedule: The company has to set up a trust fund and put sufficient amount of money into it at the beginning of year 1 so that the payments can be made on schedule. The fund managers can invest any surplus funds lying with them in short term bonds so that the interest earned along with the principal can be utilized to make the payments as required. There are three available bonds of different years to maturity: A (1-year), B (2-year), and C (3-year). The returns on maturity on the different bonds are: 4% on A,10% on B, and 18% on C. Because the final payment is made at the beginning of year 5 , effectively the investment options available in different years are: he company wishes to find an investment strategy that will allow the fund to make the nec yments from the minimum amount of money needed for the fund. (a) Set up this multi-period cash flow problem algebraically. (15 points) (b) Use Excel Solver to solve the problem and e-mail your answer to subhash.ray@uconn.edu. (20 points) c) What is the minimum initial endowment needed for the fund? (5 points)