Exercise 14-11 (Algo) Preference Ranking of Investment Projects (L014-5) Oxford Company has limited funds available for investment and mustration the funds among four competing projects Selected information on the four projects follows: Life of Present the Internal Investment Value of Project Rate Project Required cash Intlovn (years) of Return $ 180,000 $ 269,323 7 150 $ 130,000 $ 242.000 12 200 C$100,000 $ 200,035 2 19 D $ 160,000 $ 278,136 181 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 Required 1 Required 2 Compute the profitability index for each project. (Round your answers to 2 decimal places.) Project Profitability Index A B C D 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. Not Present Value Profitability Internal Rato of Return Index First preference Second preference Third preference Fourth preference