What is the minimum initial endowment needed for the fund?

Use excel solver to solve the problem

1. A company was ordered by the court in settlement of a class action suit to make a total payment of $1,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 inv 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 different bonds are: 4% on A,10% on B, and 18% on C. Because the final payment is made at beginning of year 5 , effectively the investment options available in different years are: 1. A company was ordered by the court in settlement of a class action suit to make a total payment of $1,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 inv 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 different bonds are: 4% on A,10% on B, and 18% on C. Because the final payment is made at beginning of year 5 , effectively the investment options available in different years are