Goal Seeking

AAA

DEFINITION of 'Goal Seeking'

The process of finding the correct input when only the output is known. A goal-seeking entrepreneur might ask him or herself: "How much money do I have to earn per hour to gross $100,000 this year?" He or she knows the desired output, $100,000, but will have to work backwards to determine the desired input by figuring out how many hours he or she is able and willing to work in a year and then how much he or she needs to earn per hour, along with any other factors which may affect the final output.

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).



RELATED TERMS
  1. Magic Formula Investing

    A money-making strategy that teaches investors a common-sense ...
  2. Coinsurance Formula

    The homeowners insurance formula that determines the amount of ...
  3. Future Value - FV

    The value of an asset or cash at a specified date in the future ...
  4. Present Value - PV

    The current worth of a future sum of money or stream of cash ...
  5. Flat Benefit Formula

    A method of calculating an employer's contribution to an employee's ...
  6. Unit Benefit Formula

    A method of calculating an employer's contribution to an employee's ...
Related Articles
  1. Investing With A Purpose
    Investing Basics

    Investing With A Purpose

  2. Financial Planning: It's About More ...
    Retirement

    Financial Planning: It's About More ...

  3. Microsoft Excel Features For The Financially ...
    Professionals

    Microsoft Excel Features For The Financially ...

  4. Run Your Finances Like A Business
    Entrepreneurship

    Run Your Finances Like A Business

Hot Definitions
  1. Leading Indicator

    A measurable economic factor that changes before the economy starts to follow a particular pattern or trend. Leading indicators ...
  2. Wage-Price Spiral

    A macroeconomic theory to explain the cause-and-effect relationship between rising wages and rising prices, or inflation. ...
  3. Accelerated Depreciation

    Any method of depreciation used for accounting or income tax purposes that allows greater deductions in the earlier years ...
  4. Call Risk

    The risk, faced by a holder of a callable bond, that a bond issuer will take advantage of the callable bond feature and redeem ...
  5. Parity Price

    When the price of an asset is directly linked to another price. Examples of parity price are: 1. Convertibles - the price ...
  6. Earnings Multiplier

    An adjustment made to a company's P/E ratio that takes into account current interest rates. The earnings multiplier is used ...
Trading Center