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. 4 Psychological Traps That Are Killing ...
    Active Trading Fundamentals

    4 Psychological Traps That Are Killing ...

comments powered by Disqus
Hot Definitions
  1. Odious Debt

    Money borrowed by one country from another country and then misappropriated by national rulers. A nation's debt becomes odious ...
  2. Takeover

    A corporate action where an acquiring company makes a bid for an acquiree. If the target company is publicly traded, the ...
  3. Harvest Strategy

    A strategy in which investment in a particular line of business is reduced or eliminated because the revenue brought in by ...
  4. Stop-Limit Order

    An order placed with a broker that combines the features of stop order with those of a limit order. A stop-limit order will ...
  5. Pareto Principle

    A principle, named after economist Vilfredo Pareto, that specifies an unequal relationship between inputs and outputs. The ...
  6. Pareto Principle

    A principle, named after economist Vilfredo Pareto, that specifies an unequal relationship between inputs and outputs. The ...
Trading Center