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. Financial Modeling

    The process by which a firm constructs a financial representation ...
  4. Sensitivity Analysis

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

    A standard that was developed to improve the way in which financial ...
  6. Discounted Cash Flow - DCF

    A valuation method used to estimate the attractiveness of an ...
RELATED FAQS
  1. No results found.
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. 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
  5. 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.
  6. 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.
  7. 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?
  8. Investing Basics

    How Does Goodwill Affect Financial Statements?

    Goodwill is a bit of a paradox--intangible, yet it is recorded as an asset on the purchasing company's balance sheet.
  9. Investing Basics

    Using Normal Distribution Formula To Optimize Your Portfolio

    Normal or bell curve distribution can be used in portfolio theory to help portfolio managers maximize return and minimize risk.
  10. Investing Basics

    R-Squared

    Learn more about this statistical measurement used to represent movement between a security and its benchmark.

You May Also Like

Hot Definitions
  1. Sunk Cost

    A cost that has already been incurred and thus cannot be recovered. A sunk cost differs from other, future costs that a business ...
  2. Technical Skills

    1. The knowledge and abilities needed to accomplish mathematical, engineering, scientific or computer-related duties, as ...
  3. Prepaid Expense

    A type of asset that arises on a balance sheet as a result of business making payments for goods and services to be received ...
  4. Gordon Growth Model

    A model for determining the intrinsic value of a stock, based on a future series of dividends that grow at a constant rate. ...
  5. Cost Accounting

    A type of accounting process that aims to capture a company's costs of production by assessing the input costs of each step ...
  6. Law Of Supply

    A microeconomic law stating that, all other factors being equal, as the price of a good or service increases, the quantity ...
Trading Center