What-If Calculation

Dictionary Says

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 Says

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.
comments powered by Disqus
Hot Definitions
  1. Securitization

    The process through which an issuer creates a financial instrument by combining other financial assets and then marketing different tiers of the repackaged instruments to investors.
  2. Economic Forecasting

    The process of attempting to predict the future condition of the economy. This involves the use of statistical models utilizing variables sometimes called indicators.
  3. Chicago Mercantile Exchange - CME

    The world's second-largest exchange for futures and options on futures and the largest in the U.S. Trading involves mostly futures on interest rates, currency, equities, stock indices and agricultural products.
  4. Private Equity

    Equity capital that is not quoted on a public exchange. Private equity consists of investors and funds that make investments directly into private companies or conduct buyouts of public companies that result in a delisting of public equity.
  5. Valuation

    The process of determining the current worth of an asset or company. There are many techniques that can be used to determine value, some are subjective and others are objective.
  6. Valuation

    The process of determining the current worth of an asset or company. There are many techniques that can be used to determine value, some are subjective and others are objective.
Trading Center