Please show all intermediate steps and formulas used. Use excel to complete the problem.

The Simpson Corporation is trying to choose between the following two mutually exclusive design projects: Year 0 1 2 3 Cash Flow (1) Cash Flow (II) -$55,000 -$18,900 25,000 10,150 25,000 10,150 25,000 10,150 a-1.If the required return for both projects is 10 percent, what is the profitability Index for both projects? (Do not round Intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.) a. If the company applies the profitability Index decision rule, which project should the 2. firm accept? b-1.What is the NPV for both projects? (A negative answer should be indicated by a minus sign. Do not round Intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) b- If the company applies the NPV decision rule, which project should it choose? 2. a-1. Project profitability index Project Il profitability index a-2. Profitability index decision b-1. Project INPV Project II NPV b-2. NPV decision