I NEED THE FORMULA, EXAMPLE: =IRR(D7:D11)

FORMULA NEEDS TO BE THE ANSWER, LIKE THE EXAMPLE

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? Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to answer this