th before Midnight blem 9-15 Calculating Profitability Index. 7 X Calculating the profitability index - Excel FORMULAS DATA REVIEW - Sign in VIEW BE HOME INSERT PAGE LAYOUT FEE Cells Editing B ste T U - A Alignment Number - Conditional Format as Cell Formatting Table Styles Styles ipboards What is the profitability index for the following set of cash flows if the relevant discount rate is 10 percent? What if the discount rate is 15 percent? If it is 22 percent? Year 0 Year 1 Year 2 Year 3 $ $ S $ (15,300) 9,400 7,600 4,300 Discount rate Discount rate Discount rate 10% 15% 2296 Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to answer this question. Profitability index at 10 percent Profitability index at 15 percent Profitability Index at 22 nercent