Investopedia explains 'Goal Seeking'
To solve more complex goal-seeking problems, business people commonly rely on computer software. The spreadsheet program Microsoft Excel has a goal-seeking tool built in that allows the user to determine the correct input value for a formula when the desired output is known. This feature can be used, for example, to determine the interest rate a borrower would need to qualify for (the input) if he or she only knows how much he can afford to pay per month (the output).
|