Use Solver in Excel

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 1 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. 1) If you cant undertake a fraction of a project but must undertake either all or none of a project, how can you maximize the NPV? 2) Suppose that if Project 4 is undertaken, Project 5 must be undertaken. How can you maximize the NPV?

NPV Year 1 expenditure Year 2 expenditure Project 1 14 12 3 Project 2 17 54 7 17 6 6 Project 3 15 6 2 project 4 project 5 40 32 35 12 6 6 project 6 project 7 14 48 4 project 8 10 36 3 12 18 project 9 3