Suppose you are the capital-budgeting analyst for a company considering investments in the eight projects listed in the table below. The chief financial officer of your company has asked you to rank the projects and recommend "three best" that the company should accept in preparation for a meeting with the capital budgeting committee of the company's Board of Directors No other project characteristics are deciding factors in the selection, except that management has determine that projects 4 and 5 are together mutually exclusive and that projects 7 and 8 are also together mutually exclusive (but are separately mutually exclusive from projects 4 and 5). All the projects require the same initial investment: of $3 million. Moreover, all are believed to be of the same risk class and the appropriate discount rate to be used is 9% ( an Excel Spreadsheet can be found in D2L) Project number 5 24000 $ 500.00 330000 1,80000 S (s25.00) 2 5 495 00 $ 501.00 3 495.00 S 247.50 $ 4$ 495.00 5 5 49500 6 5 495.00 $ 1,350.00 $ (0.00) 450.00 S 90.00 S 135.00 $ 525.00 105.00 1,0s0.00 S 100.00 $1,800.00 100.00 $ 3,375.00 500.00 500.00 S 30000 S 500.00 $ 525.00 $ 500.00 $592.50 $648.00 50000 $ 660.00 500.00 5 66100 S 500.00 5 66600 500.00 660.00 500.00 67200 $ 500.00 675.00 $ 50000 $5 67650 500.00 $ 495.00 8$ 1,500.00 is 67650 678.00 15 Tasks: 1. For each of the eight projects find their: a. Net Present Vallues (8 points) b. internal Rates of Return (8 points) c Profitability Indexes (8 points) d. Equivalent Annual Annuities (8 points) Based on your rankings, which of the three projects would you recommend? To be awarded any points you have to explain to the CFO how you arrived at your choices (18 points) 2. PrtScn 5 6