Please show all your work!

You are the CEO. 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 Iny A Inv B Iny C Inv D Inv E 0 -$500,000 -$600,000 1 $23,000 $150,000 2 $148,000 $150,000 -$750,000-$450,000 -$450,000-$400,000 $255,000 $145,000 $225,000 $205,000 $165,000 -$28,000 $175,000 $185,000 $210,000 $120,000 $200,000 -$22,000 $50,000 $225,000 $235,000 3 $178,000 $210,000 $150,000 $150,000 4 5 $250,000 $150,000 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 Which project should you choose