please solve using excel

5. The cost of capital is 8% for both projects. Annual Cash Flows A B ($300,000) 120,000 ($350,000) 60,000 100,000 80,000 100,000 80,000 60,000 120,000 40,000 140,000 a. Calculate the Payback for each project. b. Calculate NPV for each project. c. Calculate IRR for each project. d. If projects A and B are independent, which project(s), if any, would you accept? Why? e. If projects A and B are mutually exclusive, which project(s), if any, would you accept? Why