Please provide detailed instructions on how to solve using Solver in Excel.

Problem 4: Using Solver to solve capital budgeting problems A company has nine projects under consideration. The NPV added by each project and the capital required by each project during the next two years is shown in the following table. (All numbers are in millions.) For example, Project I will add $14 million in NPV and require expenditures of $12 million during Year 1 and $3 million during Year 2. During Year 1, $50 million in capital is available for projects, and $20 million is available during Year 2. MIS 4390 Business Analytics FALL 2021 Page 3 of 3 NPV Year 1 expenditure 12 14 Year 2 expenditure 3 7 17 54 17 6 6 15 6 2 Project 1 Project 2 Project 3 Project 4 Projects Project 6 Project 7 Project 8 Project 9 40 32 35 12 6 6 ent 14 48 4 10 36 3 3 12 18 60 If you can't undertake a fraction of a project but must undertake either all or none of a project, how can you maximize the NPV? Suppose that if Project 4 is undertaken, Project 5 must be undertaken. How can you maximize the NPV