Maybe Navy was formed late in 2021 to build and popularize an online video platform for competitively setting routes for seaborne shipping. This is one of a new category of games that mimic actual work that people do. As the new company builds out its infrastructure, management is evaluating several capital projects, noted at this point A, B, C, and D. The initial investment and annual cash flow data for each project is presented in the spreadsheet.

Required:

a. Show calculations for Net Present Value, Internal Rate of Return, Modified Internal Rate of Return, Profitability Index, and Payback period for each of the projects.

b. Rank the four projects in order from most desirable to least, indicating any projects that should be rejected. Explain how you arrived at your rankings.