M Paste BIU- | AA A. Alignment Number Conditional Format as Cell Formatting Table Styles Cells Editing Clipboard Font > f A A c D E F G H 1 J 1 2 3 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? 4 5 6 7 8 Year 0 Year 1 Year 2 Year 3 (15,300) 9,400 7,600 4,300 9 $ 10 11 12 13 Discount rate Discount rate Discount rate 10% 15% 22% 14 15 16 17 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 18 19 20 MacBook Air BO 888 F4 F6 ga F7 FB $ % A & 3 4 5 6 7 R T Y 1 Cells Editing pboard Font Formatting Table Styles Styles 11 f B D E F G H 1 Year 0 Year 1 Year 2 Year 3 AG (15,300) 9,400 7,600 4,300 1 Discount rate Discount rate Discount rate 10% 15% 22% 3 4 5 6 7 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 9 0 1 2 3 Profitability index at 22 percent 5 MacBook Air 80 F2 DDD F4 DU FB F6 F7 & 3 4 % 5 0) > 7 E R T