Hi can you help me find the correct excel formula for lower IRR For example, High IRR was =(D6:D8)

FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Ariel -12 - A A % M Paste BTU- Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font D18 V AB c D E F G H 4 5 6 7 Year 0 Year 1 Year 2 s $ $ (45,000,000) 71,000,000 (15,000,000) 8 9 10 Required return 12% 11 12 13 Complete the following analysis. Do not hard code values in your calculations. Use a "Guess" of 99 to calculate the higher IRR and -99 to calculate the lower IRR. You must use the built-in Excel functions to answer this question. NPV 14 15 16 17 $ 6,434,948.98 Higher IRR Lower IRR 32 65% 18 19 20 21 22 Sheet1 L READY Attempt(s) 1/3 Step: The IRR function can be used to find the Internal rate of return for a set of cash flows. 100% Hint