please show how to solve in excel

A B D E F G Question 2 (40 Points) H Cobb Corporation is consumer goods company and is currently considering an investment project with the cash flows below. Cobb's Cost of Capital (discount rate) is 10% and Jansen requires a 2.5-year maximum payback period for new projects. Calculate the following for the project and indicate for each decision tool result whether the project should be accepted or rejected: a. NPV b. IRR c. MIRR d. Payback Period Year 2 3 1 2 3 -$ $ S $ $ Cash Flow 27,500,000.00 5,500,000.00 11,000,000.00 16,500,000.00 22,000,000.00 4 0 1 2 3 4 5 Question 1 - Part A Question to