Oxford Company has limited funds available for investment and must ration the funds among five competing projects. Selected information on the five projects follows: Project B C D E Investment Required $ 685,000 550,000 357,000 554,000 467,000 Net Present Value $ 128,000 126,500 110,600 220,000 (52,000) 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 B D E 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