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. How Does Goodwill Affect Financial Statements?
    Investing Basics

    How Does Goodwill Affect Financial Statements?

comments powered by Disqus
Hot Definitions
  1. Repurchase Agreement - Repo

    A form of short-term borrowing for dealers in government securities.
  2. Correlation

    In the world of finance, a statistical measure of how two securities move in relation to each other. Correlations are used ...
  3. Letter Of Credit

    A letter from a bank guaranteeing that a buyer's payment to a seller will be received on time and for the correct amount. ...
  4. Due Diligence - DD

    1. An investigation or audit of a potential investment. Due diligence serves to confirm all material facts in regards to ...
  5. Certificate Of Deposit - CD

    A savings certificate entitling the bearer to receive interest. A CD bears a maturity date, a specified fixed interest rate ...
  6. Days Sales Of Inventory - DSI

    A financial measure of a company's performance that gives investors an idea of how long it takes a company to turn its inventory ...
Trading Center