PLS HELP: Using the excel sheet format, can you please break down the steps to solve this problem? I would appreciate if you aligned the answers into Questions 1-4 and format them to coincide with the excel sheet as you are solving the problem.

AZM Inc. is evaluating two mutually exclusive projects of making two types of SUVs: mini-SUV, and full- SUV. Assume the discount rate for both projects is 10 percent. The costs of investment and projected cash flows for both projects are given in the following table: Year AZM MINI-SUV AZM FULL-SUV 0 -$650,000 -$975,000 1 $330,000 490,000 2 $310,000 460,000 3 $260,000 410,000 Questions 1. What is the payback period of each project? Based on the payback period, which project should be taken? 2. What is the profitability index of each project? Based on the profitability index, wiich project should be taken? 3. What is the internal rate of return (IRR) of each project? Based on the IRR, which project should be taken? 4. What is the net present value (NPV) of each project? Based on the NPV, which project should be taken?? Year Mini-SUV Cash flows 5 Full SUV Cash flows 10N 7 Required return lused as the discount rate) 8 Part 1: 9 Mini-SUV Initial cash outlay 10 Accumulated cash inflows 11 Payback period 12 13 Pull SUV Initial cash outlay 14 Accumulated cast inflows 15 Payback period 16 17 Which project should be taken? 18 19 Part 2 20 Mini SUV Present value of cash inflows 21 Present value of cash outflows 22 Profitability index 23 24 Full SUV Present value of cash inflows 25 Present value of cash outfiows 26 Profitability index 27 28 Which project should be taken? 29 30 Part 3: 31 Mini SUV. Internal rate of return (RR) 32 Full SUV Internal rate of return (IRR) 33 Which project should be taken? 34 35 Part 4 36 Mini-SUV Net present value (NPV) 37 Full SUV Net present value (NPV) 38 Which project should be taken? 39 40