O Goal Seek Goal Seek permits you to find an input value of a relationship, including a model, that generates a specific result. Cash Flows IRR 2023 -500 24% 2024 100 2025 110 2026 121 ou can see that the value in B215 is 12% What is the value of the largest investment that you calculated? 2027 133 2028 146 For example, suppose you want to determine the largest investment you could make (cell B214) that will result in a 12% IRR. 1 Select 'Data' tab 2 Select 'What-if Analysis' icon 3 Select "Goal Seek...' 4 In the 'Set Cell:' box enter or clck in B215 5 In the 'To Value:' box enter '12%' 6 By 'Changing Cell:' box enter or click in B214 7 Select "OK" 2029 161 Hint: the value should be the absolute value of what is calculatd by the 'Goal Seek' capability in B214 2030 177 2031 195 2032 214 2033 236