please show work

The management of Revco Products is exploring four different investment opportunities. Information on the four projects under study follows: $(620,000) $(310,000) Investment required Present value of cash inflows at a B discount rate Net present value Life of the project Internal rate of return 697,217 77,217 6 years 125 Project Number 2 3 $(510,000) $(420,000) 655,640 499,270 $ 145,640 $ 79,270 12 years 6 years 135 140 $ 386,488 $ 76,488 3 years 210 Because the company's required rate of return is 8%, a 8% discount rate has been used in the present value computations above. Limited funds are available for investment, so the company can't accept all of the available projects. Required: 1. Compute the project profitability index for each investment project. 2. Rank the four projects according to preference, in terms of net present value, project profitability Index and internal rate of return. Required: 1. Compute the project profitability index for each investment project 2. Rank the four projects according to preference, 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 Compute the project profitability Index for each investment project. (Round your answers to 2 decimal places.) Profitability Project Index 1 2 3 4 Required 1 Required 2 Rank the four projects according to preference, in terms of net present value, project profitability index and internal rate of return. Net Present Value Project Profitability Index Internal Rate of Return 3 First preference Second preference Third preference Fourth preference