You are given a group of possible investment projects for your company’s capital. For each project, you are given the NPV the project would add to the firm, as well as the cash outflow required by...

You are given a group of possible investment projects for your company’s capital. For each project, you are given the NPV the project would add to the firm, as well as the cash outflow required by each project during each year. Given the information in the file P06_40.xlsx, determine the investments that maximize the firm’s NPV. The firm has $30 million available during each of the next 5 years. All numbers are in millions of dollars.