please include excel formulas

3095 - Spring 2021 - Mid Term 2 Excel Temp Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 23 Wrap Text Paste - A A General BIU lili Merge & Center $ % 9 *898 A14 Xfx D E 1 H K 3 4 5 B F Question 2 (40 Points) 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 6 7 8 9 10 11 12 23 Year 0 1 Cash Flow 27.500,000.00 5,500,000.00 11,000,000.00 16,500,000.00 22,000,000.00 -5 $ $ $ $ 2 3 4 15 16 17 18 19 20 21 22 23 24 25 26 27 Question 1 - Part A Question 1 - Part 8 Cartine 1