please give answer as formula (using cell names)

I will give a thumbs up

A1 B D E F G H 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 Year 0 Year 1 Year 2 Year 3 $ $ $ $ (15,300) 9,400 7,600 4,300 8 9 10 11 12 Discount rate Discount rate Discount rate 10% 15% 22% 13 14 15 hent Part 1 Saved Help 12 UISLUULIO Discount rate Discount rate IU 70 15% 22% 13 14 15 16 Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to answer this question. 17 18 19 Profitability index at 10 percent Profitability index at 15 percent 20 21 22 23 24 25 Profitability index at 22 percent