need required 1 & 2 please

Oxford Company has limited funds available for investment and mustration the funds among four competing projects. Selected Information on the four projects follows: Internal Present Life of Rate value of the of Investment Cash Project Return Project Required Inflows (years) A $160,000 $204,3237 189 B $135,000 $177,000 12 16 $100,000 $135,035 7 201 D $175,000 $213,136 3 229 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 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 Het Present Profitability Internal Rate Value Index of Return First preference Second preference Third preference Fourth preference