Most use excel and show equations and equal to the same results that is provided

to the 12. Gymnastics Life is a high-end facility for beginn e nde wish to invest up to 150 methods for critical evaluation endop hou of 7 years. In addition, G4L will giv e . The latere drawn from the begin for de c h efowindependent s a nd below. MARR is 12 usi e n dicated menteach of which G4L estment at the mo v Investment I nvestment SI50.000 SI $100.000 $160.000 S Annual Return 524 522 SISOKO $250 $10.00 * Determine the optimum portfolio, including which investments are fully or partially if partial, give percentage) selected. You may use Excel, do not use SOLVER ANSWER 2.1.41415) ) plus 20% and minus 20%. Use b. Determine the optimum portfolio and its PW, specifying which investments are fully or partially give percentage selected using (1) the current limit on investment capital Excel and SOLVER ANSWER b. Determine the optimum portfolio and its PW specifying which investments are fully or partially (give percentage) selected using (1) the current limit on investment capital, (2) plus 20%, and (3) minus 20%. Use Erseland SOLVER ANSWER CAP CONSTRAINT $280 000.00 $350 000.00 $420000.00 PORTFOLIO 2.1 2.1.443.7596) 2.1.4/8759) PW $56.590 58 $68,171.11 $79,751.65 Determine the optimum portfolio and its PW, specifying which investments are fully or partially give percentage) selected using (1) the current MARR, (2) plus 20%, and (3) minus 2016. Use Excel and SOLVER MARR 9.60 12.00 14.40% 2. 1.4743.75%) 2.1, 4(43.75%) 2.1443.759) S115,12865 $68,171.11 S27 695 45 d. Determine the optimum investment portfolio and its PW when investments 1 and 2 are divisible and investments 3, 4, and 5 are indivisible. Use Excel and SOLVER ANSWER Optimal Portfolio Percent Total PW Total Investment 2 100% $6660 $350,000.00 4 100% 40%