Please try to answer any/all parts you can. I will upvote!

(12 marks) Question 1: You are on the board of directors as the CFO of the company and have been given the following projects to evaluate. The board does not like to investment in projects that are longer than 3 years but are open to all suggestions made. There are 5 investments to assess which are shown below in the table. Year Inv A Inv B Inv C Inv D Inv E 0-$500,000-$600,000-$750,000-$450,000-$400,000 1 $23,000 $150,000 $255,000 $145,000 $225,000 2 $148,000 $150,000 $205,000 $165,000 - $28,000 3 $178,000 $150,000 $175,000 $185,000 $210,000 4 $210,000 $150,000 $120,000 $200,000 - $22,000 5 $250,000 $150,000 $50,000 $225,000 $235,000 a) (9 marks) Perform an investment criteria analysis. 1. NPV (find the answer for each of the following required returns: 5%, 10%, 15%, 20%, and 30%) 2. IRR (hint - graph the IRR for each of the investments to show the IRR%) 3. Profitability Index 4. Payback Period b)(3 marks) Which project should you choose