SOLVER FUNCTION EXCEL

1) A firm as $40 M to invest in year 1 and $20 M to invest in year 2. Using Solver, determine what projects will maximize NPV using Simplex LP solving method. Save Scenario is NPV Project Selection1. Objective Investment Year 1 Year 2 Expenditures Choices NPV Year 1 Year 2 Project 1 Project 2 Project 3 Project 4 Project 5 Project 6 Project 7 Project 8 Project 9 $ 28,000,000$ 15,000,000$ $ 14,000,000$4,000,000$ 20,000,000 $ 17,000,000$ $7,000,000$4,000,000$2,000,000 $ 37,000,000$ 40,000,000$ $ 18,000,000$ 10,000,000$ 10,000,000 $ 18,000,000$ 12,000,000$ $ 24,000,000$ 15,000,000$ $ 15,000,000$ 12,000,000$ 12,000,000 8,000,000 8,000,000$ 8,000,000 1,000,000 3,000,000 Needed Constraints