What-If Calculation

AAA

DEFINITION of 'What-If Calculation'

Calculations for testing a financial model using different assumptions and scenarios. What-if`calculations enable the forecaster to check the variance in end results for a financial model using various hypothetical levels for inputs such as interest rates and exchange rates. These calculations are generally performed with spreadsheet software. What-if calculations can also be referred to as sensitivity analysis or stress testing.

INVESTOPEDIA EXPLAINS 'What-If Calculation'

In a discounted cash flow model used to assess the viability of a project, changes in the discount rate can lead to wide ranges in the net present value of the project. The key benefit of what-if calculations in this case is that they can test the viability of the project under various scenarios. What-if calculations are similar to a sensitivity analysis, and should not be confused with the "IF" function in excel.

RELATED TERMS
  1. Net Present Value - NPV

    The difference between the present value of cash inflows and ...
  2. Back-Of-The-Envelope Calculation

    An informal mathematical computation, often performed on a scrap ...
  3. Discounted Cash Flow - DCF

    A valuation method used to estimate the attractiveness of an ...
  4. Sensitivity Analysis

    A technique used to determine how different values of an independent ...
  5. Financial Modeling

    The process by which a firm constructs a financial representation ...
  6. eXtensible Business Reporting Language ...

    A standard that was developed to improve the way in which financial ...
Related Articles
  1. Investing Basics

    DCF Valuation: The Stock Market Sanity Check

    Calculate whether the market is paying too much for a particular stock.
  2. Active Trading Fundamentals

    Bet Smarter With The Monte Carlo Simulation

    This technique can reduce uncertainty in estimating future outcomes.
  3. Fundamental Analysis

    Top 3 Pitfalls Of Discounted Cash Flow Analysis

    The DCF method can be difficult to apply to real-life valuations. Find out where it comes up short.
  4. Mutual Funds & ETFs

    How do hedge funds determine what assets to own?

    Learn about the various types of investments that hedge fund managers use, and explore basic hedge fund management trading strategies.
  5. Mutual Funds & ETFs

    What is the difference between a hedge fund and a private equity fund?

    Learn the primary differences between hedge funds and private equity funds, both of which are utilized by high net worth investors.
  6. Mutual Funds & ETFs

    Where does a hedge fund get its money?

    Learn how a hedge fund is structured and how the managing partner of the fund goes about the process of finding and soliciting investors.
  7. Mutual Funds & ETFs

    What is the purpose of a hedge fund?

    Find out what a hedge fund is, how it is set up and why it is different than other forms of investment partnerships like mutual funds.
  8. Mutual Funds & ETFs

    How do traders use the ABX index?

    Learn about some of the ways traders, banks and even hedge funds have traditionally used the ABX indices to make bets on mortgage-backed securities.
  9. Economics

    How A Limited Government Affects A Country's Finances

    Countries with limited governments have fewer laws about what individuals and businesses can and can’t do. What's the net result?
  10. Investing Basics

    How Does Goodwill Affect Financial Statements?

    Goodwill is a bit of a paradox--intangible, yet it is recorded as an asset on the purchasing company's balance sheet.

You May Also Like

Hot Definitions
  1. Santa Claus Rally

    A surge in the price of stocks that often occurs in the week between Christmas and New Year's Day. There are numerous explanations ...
  2. Commodity

    1. A basic good used in commerce that is interchangeable with other commodities of the same type. Commodities are most often ...
  3. Deferred Revenue

    Advance payments or unearned revenue, recorded on the recipient's balance sheet as a liability, until the services have been ...
  4. Multinational Corporation - MNC

    A corporation that has its facilities and other assets in at least one country other than its home country. Such companies ...
  5. SWOT Analysis

    A tool that identifies the strengths, weaknesses, opportunities and threats of an organization. Specifically, SWOT is a basic, ...
  6. Simple Interest

    A quick method of calculating the interest charge on a loan. Simple interest is determined by multiplying the interest rate ...
Trading Center