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. Closed-End Fund

    A closed-end fund is a publicly traded investment company that raises a fixed amount of capital through an initial public offering (IPO). The fund is then structured, listed and traded like a stock on a stock exchange.
  2. Payday Loan

    A type of short-term borrowing where an individual borrows a small amount at a very high rate of interest. The borrower typically writes a post-dated personal check in the amount they wish to borrow plus a fee in exchange for cash.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
Trading Center