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.

Related Definitions

  • Sensitivity Analysis

    A technique used to determine how different values of an independent variable will impact a particular dependent variable under a given set of assumptions. This technique is used within ...
    Read More »
  • Financial Modeling

    The process by which a firm constructs a financial representation of some, or all, aspects of the firm or given security. The model is usually characterized by performing calculations, ...
    Read More »
  • Net Present Value - NPV

    The difference between the present value of cash inflows and the present value of cash outflows. NPV is used in capital budgeting to analyze the profitability of an investment or ...
    Read More »

Articles Of Interest

Partner Links