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 A B c D Present Idfe of Value of the Internal Investment Cash Project Rate Required Inflown (years) of Return $200,000 $309,323 7 156 $116,000 $282,000 12 200 $100,000 $240,035 17 198 $160,000 $318,136 3 184 The net present values should be 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 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. (Round your answers to 2 decimal places.) Project Profitability Index A B D Project A B D Prument I DE Value of the Internal Investment Canh Project Rate Required Inflow (years) of Return $200,000 $309,323 7 156 $116,000 $282,000 12 208 $100,000 $240,035 7 198 $160,000 $318,136 3 186 The net present values should be computed using a 10% discount rate. The company wants your assistance in determining project to accept first, second, and so forth. 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 Prosent Value Profitability Internal Rate Index of Retur First preference Second preference Third preference Fourth preferenco