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. Sensitivity Analysis

    A technique used to determine how different values of an independent ...
  4. eXtensible Business Reporting Language ...

    A standard that was developed to improve the way in which financial ...
  5. Financial Modeling

    The process by which a firm constructs a financial representation ...
  6. Discounted Cash Flow - DCF

    A valuation method used to estimate the attractiveness of an ...
Related Articles
  1. Investing Basics

    DCF Valuation: The Stock Market Sanity Check

    Calculate whether the market is paying too much for a particular stock.
  2. Active Trading Fundamentals

    Bet Smarter With The Monte Carlo Simulation

    This technique can reduce uncertainty in estimating future outcomes.
  3. Fundamental Analysis

    Top 3 Pitfalls Of Discounted Cash Flow Analysis

    The DCF method can be difficult to apply to real-life valuations. Find out where it comes up short.
  4. Economics

    Understanding Perpetuity

    Perpetuity means without end. In finance, a perpetuity is a flow of money that will be received on a regular basis without a specified ending date.
  5. Fundamental Analysis

    What is a Null Hypothesis?

    In statistics, a null hypothesis is assumed true until proven otherwise.
  6. Mutual Funds & ETFs

    These 4 Precious Metals ETFs Help Combat Inflation

    A look at 4 precious metal ETFs to combat inflation when it hits.
  7. Investing

    Hedged ETFs That Help You Cushion Currency Impact

    If you’re an investor holding non-U.S. assets, the returns on your investments will be affected when you translate your investment from its local currency
  8. Mutual Funds & ETFs

    Tired Of Mutual Funds? Try This Alternative

    Mirrored investments services are a beneficial alternative to traditional mutual funds. Discover how they work and how they can be used to your advantage.
  9. Mutual Funds & ETFs

    Position Your ETF Portfolio For Success In 2015

    2015 may well usher in a new era in the markets where things like risk management, trend following, and asset allocation are key to a successful outcome.
  10. Economics

    How A Limited Government Affects A Country's Finances

    Countries with limited governments have fewer laws about what individuals and businesses can and can’t do. What's the net result?

You May Also Like

Hot Definitions
  1. Asset Class

    A group of securities that exhibit similar characteristics, behave similarly in the marketplace, and are subject to the same ...
  2. Fiat Money

    Currency that a government has declared to be legal tender, but is not backed by a physical commodity. The value of fiat ...
  3. Interest Rate Risk

    The risk that an investment's value will change due to a change in the absolute level of interest rates, in the spread between ...
  4. Income Effect

    In the context of economic theory, the income effect is the change in an individual's or economy's income and how that change ...
  5. Price-To-Sales Ratio - PSR

    A valuation ratio that compares a company’s stock price to its revenues. The price-to-sales ratio is an indicator of the ...
  6. Hurdle Rate

    The minimum rate of return on a project or investment required by a manager or investor. In order to compensate for risk, ...
Trading Center