** solve it by excel with steps and choose the right answers**

The following are the cash-follow information for two candidate projects. Period Cash Flow Project 1 Cash Flow Project 2 0 -72200 -76000 1 18300 35560 2 20200 40440 3 21340 31850 4 42360 22750 5 45620 21200 ON 6 52480 20250 Interest Rate = 12% Please select all the correct options Project 1 has shorter pay back period Project 2 has shorter pay back period Project 1 has higher IRR Proiect 2 has higher IRR Interest Rate = 12% Please select all the correct options Project 1 has shorter pay back period Project 2 has shorter pay back period Project 1 has higher IRR Project 2 has higher IRR Profitability Index of Project 1 is better than Project 2 Profitability Index of Project 2 is better than Project 1 NPV of Project 1 is greater than Project 2 # NPV of Project 2 is greater than Project 1 Based on IRR, project 1 should be selected Based on IRR, project 2 should be selected Based on NPV, project 1 should be selected Based on NPV, project 2 should be selected