Ive pretty much given all info just need help with last part the whole question 3. The yes and no part as well thank you.

CUCK HERE TO SAVE YOUR WORK 8 2 1 Information on four investment projects being investigated by Clenning Company is as follows: Project Number 1 2 3 4 Imestment required $ 490,000 $ 440.000 $ 340,000 $ 460,000 Net present value $ 106, 160 $ 83,050 $ 107,120 $ 80,750 Life of the project in years) 16 5 Internal Rate of Return 18% 15% 21% 19% & Since the company's required rate of return is 12%, a 12% discount rate has been used in the present value computations above. Limited funds are available for investment, so the company cannot accept all of the available projects 9 1! Required: 10 12. 1 Compute the project profitability index for each project (4 marks) Round the final answers to 2 decimal places. 1 Project 14 Profitability index 0.22 15 Project 1 Project 2 0.19 2 Project 3 0.32 3 Project 4 0.18 in order of preference, rank the four projects in terms of net present value, project profitability index and internal rate of return. (3 marks) 2 Project Net Present Profitability Internal Rate Value index of Return Project 3 Project 3 Project 3 Project 1 Project 1 Project 4 Project 2 Project 2 Project 1 Project 4 Project 4 Project 2 First preference Second preference Third preference Fourthe preference 3 f the company has $1,000,000 available to invest, in which project(s) should be selected and why? (3 marks) Investment Required Project 1 Project 2 Project 3 Project 4 Total invested Yes No Yes No Reason