Please show any excel formulas used, thank you so much!!

Chapter 5 Homework Q Search Sheet AutoSave oFF Homc Insert Page Layout Formulas Data Review View Share Insert Delete Formatting as Table Styles Format Calibri (Body) ,1111 A? A? Wrap Text , Merge & Center $%00Coditional Format Cell Sort & Filter 5.12 Problems with Profitability Index The Cor's Sausage Corporation is trying to choose between the following two mutually 1 exclusive design projects: Cash Flow () Cash Flow (II) 0 (35,000.00) (16,000.00) 1 19,800.00$9,400.00 2 $ 19,800.00$9,400.00 3 $19,800.00$9,400.00 3 Year 9 Discount Rate 10 PI 11 NPV 12 10.00% a. If the required return is 10 percent and the company applies the profitability index decision rule, which project should the firm accept? b. If the company applies the NPV decision rule, which project should it take? c. Explain why your answers in (a) and (b) are different 13 14 15 16 17 18 19 20 21 Problem 5.02 Problem 5.04 Problem 5.06 Problem 5.07 Problem 5.11 Problem 5.12 Problem 5.14 Edit ??? 130%