Only need Part A please, with calculations. Thank you.

Question 5 Maybe Navy was formed late in 2022 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. Year Investment WACC NPV IRR MIRR Payback 1 2 3 4 5 Project A (805,200) 159,600 159,600 159,600 247,000 251,400 8.0% (41, 244) 6.2% 6.9% Project B (759,330) 290,540 290,540 300,000 211,780 206,350 293,032 22.7% 11.3% Project C (540,300) 264,570 165,000 165,000 165,000 165,000 210,692 23.3% 11.3% Project D (833,120) 185,000 180,000 160,000 250,170 250,000 (26,461) 6.9% 4.2% o