An investor seeks to establish an investment portfolio using the lowest possible initial investment that will generate specific amounts of capital at specific time periods in the future. We call this type of problem the 'sinking fund' problem. Marcel Lapierre is trying to plan for his daughter Chantal's university expenses. Based on current projections (it is now the start of year 1), Marcel anticipates that his financial need at the start of each of the following years is as follows (shown below left): Year 3 $20,000 Year 4 $22,000 Year 5 $24,000 Year 6 $26,000 Choice ROI Maturity A 5% 1 year B 13% 2 years C 28% 3 years D 40% 4 years Marcel has several investment choices (assume these are tax free if used for education) at the present time, as also shown above (right). Each choice has a fixed known return on investment and a specified maturity date. Assume that each choice is available for investment at the start of every year. Marcel wants to establish a sinking fund to meet his requirements. Note that at the start of year 1, the entire initial investment is available for investing in the choices. However, in subsequent years, only the amount maturing from a prior investment is available for investment. Remember that this is a multi-year investment problem. Use the following decision variables - you do not need to introduce any additional decision variables. Let A; be the amount (in $) invested in Choice A at the beginning of year i; i=1,2,3,4,5; B; be the amount (in $) invested in Choice B at the beginning of year i; i=1,2,3,4; C; be the amount (in $) invested in Choice C at the beginning of year i; i=1,2,3; D; be the amount (in $) invested in Choice D at the beginning of year i; i=1,2; (a) Formulate an analytical LP model for this problem which should be shown on Excel Worksheet