A B C D E F G H | J K L M N 1 Project Cash Flows (dollars in thousands) Project: 1 2 3 4 5 6 2 3 Initial cost: 4 -5000 -5000 -5000 -5000 -5000 -5000 567 Year 1 0 700 2500 -550 670 625 2 0 900 1700 -50 670 625 8 3 0 915 900 60 670 625 9 4 0 920 700 450 670 625 10 5 0 925 500 800 670 625 Questions All projects require initial investment of $5million and all are on same risk class 12% discount rate Calculate the NPV, IRR, MIRR and Profiitability Index 11 6 0 930 300 1100 670 625 12 7 0 940 200 1350 670 625 13 8 0 950 150 1500 670 625 Calculate the Cross-over point--the point at which the NPV of the two mutually exclusive projects is same 14 9 0 960 100 1625 670 625 15 10 0 970 60 1725 670 625 16 11 0 980 30 1810 670 625 17 12 0 990 20 1885 670 625 18 13 0 1000 10 1935 670 625 19 14 0 1100 5 1975 670 625 20 15 22000 -5000 5 2000 670 5625 21 22 Rank the projects base on quantitative decision alone. NPV,IRR, MIRR, Profitability index Rankings and why are there differences in ranking in these projects 23 3 and 4 are mutually exclusive and all other projects are independent 24 Independent projects will be accepted if they increase company's wealth 25 Choose the project that leads to most wealth to the company Cheat Sheet? Sheet2