Oxford Company has limited funds available for investment and must ration the funds among four competing projects. Selected information on the four projects follows: Project Value Life of Net the Internal Investment Present Project Rate Required (years) of Return $860,000 $407,670 8 22% $75e,eee $247,227 13 16% $710,000 $366, 716 8 23% $918,888 $225,463 4 21% B D 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, second, and so forth. Required: 1. Compute the project profitability index for each project. 2. In order of preference, rank the four projects in terms of net present value, project profitability index and internal rate of return Complete this question by entering your answers in the tabs below. es Required 1 Required 2 Compute the project prontability Index for each project. (Round your answers to 2 decimal places.) Project Project Profitability Index A B D Project A B c D Investment Required $868, eee $750,000 $710,000 $918,888 Net the Internal Present Project Rate Value (years) of Return $407,670 8 22% $247,227 13 16% $366,716 8 23% $225,463 4 21% The net present values above have been computed using a 10% discount rate. The company wants your assistance in determin which project to accept first second, and so forth. Required: 1. Compute the project profitability index for each project. 2. In order of preference, rank the four projects in terms of net present value project profitability index and internal rate of return Complete this question by entering your answers in the tabs below. Required 1 Required 2 In order of preference, rank the four projects in terms of net present value, project profitability Index and internal rate of return. Net Present Value Project Profitability Index Internal Rate of Return First preference Second preference Third preference Fourth preference