please solve question 2

here is the answer for question 1. please solve question 2

2. Assume the projects are mutually exclusive and answer the following: . Which project(s) would you accept based on the payback criterion? Which projects would you accept based on the IRR criterion? Which projects would you accept based on the NPV criterion? Submission Instructions: . Complete and submit the assignment by 23:59 Sunday. . You should submit your completed work in a Word document or Excel spreadsheet if needed. Grading Rubric Your assignment will be graded according to the following: Question 1: 60 points, 10 points each part. Question 2: 40 points, 13 points for part 1 and 2, 14 points for part 3. We can calculate the desired result in excel sheet as follows: CH 5 Pos 20 DB TF Formulas used in the excel sheet are: Payback period of Project A is 3.15 years Payback period of Project Bis 3.71 years Payback Period of Project C is 2.50 years As the firm uses 3 year cut off period so project C should be selected IRR of Project A is 21.96% IRR of Project Bis 19.79% IRR of Project C is 18.11% Project A should be selected as it has highest NPV of Project A is $ 7,011.80 NPV of Project Bis $ 3,074.71 NPV of Project Cis $ 3,170.79 Project A should be selected as it has highest NPV As there are multiple questions asked, I have solved the first question which has 6 sub parts. Please post the question separately for rest parts to be answered IRR