Problem
Suppose your boss asks you to analyze 4 different projects and determine which project to move forward with. Your firm only has enough resources for 1 project. The 4 project cash flows are summarized in the below file. Assume the initial investment is immediate and the cash flows for each year occur at the beginning of the year. Summarize each project with its NPV and IRR. Then, indicate which project you would recommend based on NPV alone, then IRR alone, and then overall which project is best for the company to pursue.