I have created the spreadsheet and have the following functions, just not sure if the value I got for the total investment is correct:

Minimize A1 + B1 + C1 + D1

Subject to:

1.06A1-1A2 = 0 (year 2 inflows and outflows)

1.14B1 + 1.06A2 1A3 1B3 = 0 (year 3 inflows and outflows)

1.18C1 + 1.06A3 1A4 1C4 = 0 (year 4 inflows and outflows)

1.14B3 + 1.06A4 1A5 1B5 = 0 (year 5 inflows and outflows)

1.06A5 1A6 = 12000 (year 6 inflows and outflows)

1.18C4 + 1.14B5 + 1.06A6 1A7 1B7 = 14000 (year 7 inflows and outflows)

1.06A7 + 1.65D1 1A8 = 16000 (year 8 inflows and outflows)

1.14B7+1.06A8 = 18000 (year 9 inflows and outflows)

Ai, Bi, Ci, Di >0

AND:

Fred and Sally Merrit recently inherited a substantial amount of money from a deceased relative. They want to use part of this money to establish an account to pay for their daughter's college education. Their daughter, Lisa, will be starting college five years from now. The Merrits estimate that her first year college expenses will amount to $12,000 and increase $2,000 per year during each of the remaining three years of her education. The following investments are available to the Merrits: Investment Available MaturesReturn at Maturity A Every year 1 year 6% 14% 1,3,5,7 2 years 1,4 3 years 18% 1 7years 65% The Mernts want to determine an investment plan that wil rovide the necessary tundsto cover Lisa's anticipated college expenses with the smallest initial investment. a. Formulate an LP model for this problem b. Create a spreadsheet model for this problem, and solve it using Solver. c. What is the optimal solution? Fred and Sally Merrit recently inherited a substantial amount of money from a deceased relative. They want to use part of this money to establish an account to pay for their daughter's college education. Their daughter, Lisa, will be starting college five years from now. The Merrits estimate that her first year college expenses will amount to $12,000 and increase $2,000 per year during each of the remaining three years of her education. The following investments are available to the Merrits: Investment Available MaturesReturn at Maturity A Every year 1 year 6% 14% 1,3,5,7 2 years 1,4 3 years 18% 1 7years 65% The Mernts want to determine an investment plan that wil rovide the necessary tundsto cover Lisa's anticipated college expenses with the smallest initial investment. a. Formulate an LP model for this problem b. Create a spreadsheet model for this problem, and solve it using Solver. c. What is the optimal solution