Project: 1 2 3 4 5 6 Year Initial cost: -5000 -5000 -5000 -5000 -5000 -5000 1 0 700 2500 -550 670 625 2 0 900 1700 -50 670 625 3 0 915 900 60 670 625 4 0 920 700 450 670 625 5 0 925 500 800 670 625 6 0 930 300 1100 670 625 7 0 940 200 1350 670 625 8 0 950 150 1500 670 625 9 0 960 100 1625 670 625 10 0 970 60 1725 670 625 11 0 980 30 1810 670 625 12 0 990 20 1885 670 625 13 0 1000 10 1935 670 625 14 0 1100 5 1975 670 625 15 22000 -5000 5 2000 670 5625 In this interactive assignment, you will take on the role of a capital budgeting analyst for a company considering investments in six projects. You are asked to rank the projects and recommend the three best that the company should accept by calculating the NPV, IRR, MIRR, and profitability index. A. calculate NPV, IRR, MIRR and profitability Index