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. DCF Valuation: The Stock Market Sanity ...
    Investing Basics

    DCF Valuation: The Stock Market Sanity ...

  2. Bet Smarter With The Monte Carlo Simulation
    Active Trading Fundamentals

    Bet Smarter With The Monte Carlo Simulation

  3. Top 3 Pitfalls Of Discounted Cash Flow ...
    Fundamental Analysis

    Top 3 Pitfalls Of Discounted Cash Flow ...

  4. The Government And Risk: A Love-Hate ...
    Insurance

    The Government And Risk: A Love-Hate ...

comments powered by Disqus
Hot Definitions
  1. Last In, First Out - LIFO

    An asset-management and valuation method that assumes that assets produced or acquired last are the ones that are used, sold ...
  2. Ghosting

    An illegal practice whereby two or more market makers collectively attempt to influence and change the price of a stock. ...
  3. Elasticity

    A measure of a variable's sensitivity to a change in another variable. In economics, elasticity refers the degree to which ...
  4. Tangible Common Equity - TCE

    A measure of a company's capital, which is used to evaluate a financial institution's ability to deal with potential losses. ...
  5. Yield To Maturity (YTM)

    The rate of return anticipated on a bond if held until the maturity date. YTM is considered a long-term bond yield expressed ...
  6. Net Present Value Of Growth Opportunities - NPVGO

    A calculation of the net present value of all future cash flows involved with an additional acquisition, or potential acquisition. ...
Trading Center