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. Using Normal Distribution Formula To ...
    Investing Basics

    Using Normal Distribution Formula To ...

comments powered by Disqus
Hot Definitions
  1. Accounts Payable - AP

    An accounting entry that represents an entity's obligation to pay off a short-term debt to its creditors. The accounts payable ...
  2. Ratio Analysis

    Quantitative analysis of information contained in a company’s financial statements. Ratio analysis is based on line items ...
  3. Days Payable Outstanding - DPO

    A company's average payable period. Calculated as: ending accounts payable / (cost of sales/number of days).
  4. Net Sales

    The amount of sales generated by a company after the deduction of returns, allowances for damaged or missing goods and any ...
  5. Over The Counter

    A security traded in some context other than on a formal exchange such as the NYSE, TSX, AMEX, etc. The phrase "over-the-counter" ...
  6. Earnings Before Interest After Taxes - EBIAT

    A financial measure that is an indicator of a company's operating performance. EBIAT, which is equivalent to after-tax EBIT ...
Trading Center