Oxford Company has limited funds available for investment and must ration the funds among the four competing projects shown below: Life of Present the Internal Investment Value of Cash Project Rate Project Required Inflows (years) of Return A $ 200,000 $294,323 7 16% B $ 137,000 $ 267,000 12 21% C $ 104,000 $ 225,035 7 20% 0 $167,000 $303,136 3 19% The net present values above have been computed using a 10% discount rate. Required: 1 Compute the profitability index for each project 2. In order of preference, rank the four projects in terms of net present value, profitability index, and internal rate of return. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compute the profitability index for each project. Note: Round your answers to 2 decimal places, Project Profitability Index A B Required: 1. Compute the profitability index for each project. 2. In order of preference, rank the four projects in terms of net present value, profitability index, and internal rate of return Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compute the profitability index for each project. Note: Round your answers to 2 decimal places. Profitability Project Index A B C D Required 1 Required 2 > Project Required Present Investment Value of Cash Inflows the Project A $ 200,000 $294,323 (years) 7 Internal Rate of Return 16% B $ 137,000 $ 267,000 12 21% C $ 104,000 $ 225,035 7 20% D $ 167,000 $303,136 3 19% The net present values above have been computed using a 10% discount rate Required: 1. Compute the profitability index for each project. 2. In order of preference, rank the four projects in terms of net present value, 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, profitability index, and internal rate of return. Net Present Value Profitability Index Internal Rate of Return First preference Second preference Third preference Fourth preference