1 Oxford Company has limited funds available for investment and mustration the funds among five competing projects. Selected information on the five projects follows: Project A B D E Investment Required $ 572,000 402,089 416, cee 688,800 459, eee Net Present Value $ 133,900 127, 100 108,900 218,900 (68,600) Life of the Project (years) 7 12 7 3 6 The net present values above have been computed using a 10% discount rate. The company wants your assistance in determining which project to accept first, which to accept second, and so on. Required: 1. Compute the profitability index for each project. (Round your answers to 2 decimal places.) Project Profitability Index A B E C D 1 1 E Skipped 2. In order of preference, rank the five projects in terms of (a) net present value. (b) profitability Index. Net Present Value Profitability Index First preference Second preference Third preference Fourth preference Fifth preference 3. This part of the question is not part of your Connect assignment