What-If Calculation

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.

BREAKING DOWN '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. Financial Modeling

    The process by which a firm constructs a financial representation ...
  2. Discounted Cash Flow (DCF)

    Discounted cash flow (DCF) is a valuation method used to estimate ...
  3. Net Present Value - NPV

    Net Present Value (NPV) is the difference between the present ...
  4. Back-Of-The-Envelope Calculation

    An informal mathematical computation, often performed on a scrap ...
  5. eXtensible Business Reporting Language ...

    A standard that was developed to improve the way in which financial ...
  6. Sensitivity Analysis

    Sensitivity analysis is a technique used to determine how different ...
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

    3 Healthy Financial Habits for 2016

    ”Winning” investors don't just set it and forget it. They consistently take steps to adapt their investment plan in the face of changing markets.
  5. Investing

    How to Ballast a Portfolio with Bonds

    If January and early February performance is any guide, there’s a new normal in financial markets today: Heightened volatility.
  6. Economics

    The Truth about Productivity

    Why has labor market productivity slowed sharply around the world in recent years? One of the greatest economic mysteries out there.
  7. Fundamental Analysis

    HF Performance Report: Did Hedge Funds Earn Their Fee in 2015?

    Find out whether hedge funds, which have come under tremendous pressure to improve their performance, managed to earn their fee in 2015.
  8. Investing Basics

    Bill Ackman's 2 Best Investments (GGP, CP)

    Learn about the two best investments Ackman ever made. Ackman has demonstrated a consistent track record of success in all types of market environments.
  9. Investing

    George Soros: 3 Best Investments Ever

    Learn about some of the most successful trades famed investor George Soros has made during his career, including a billion dollar profit against the pound.
  10. Saving and Spending

    Where Does Bill Ackman Keep His Money?

    Learn about where prominent hedge fund manager Bill Ackman keeps his money. See how his short position in Herbalife has not been successful so far.
RELATED FAQS
  1. What is finance?

    "Finance" is a broad term that describes two related activities: the study of how money is managed and the actual process ... Read Full Answer >>
  2. What is securitization?

    Securitization is the process of taking an illiquid asset, or group of assets, and through financial engineering, transforming ... Read Full Answer >>
  3. What is the difference between positive and normative economics?

    Positive economics is objective and fact based, while normative economics is subjective and value based. Positive economic ... Read Full Answer >>
  4. Can hedge funds trade penny stocks?

    Hedge funds can trade penny stocks. In fact, hedge funds can trade in just about any type of security, including medium- ... Read Full Answer >>
  5. Are hedge funds regulated by FINRA?

    Alternative investment vehicles such as hedge funds offer investors a wider range of possibilities due to certain exceptions ... Read Full Answer >>
  6. Should mutual funds be subject to more regulation?

    Mutual funds, when compared to other types of pooled investments such as hedge funds, have very strict regulations. In fact, ... Read Full Answer >>
Hot Definitions
  1. Liquidation Margin

    Liquidation margin refers to the value of all of the equity positions in a margin account. If an investor or trader holds ...
  2. Black Swan

    An event or occurrence that deviates beyond what is normally expected of a situation and that would be extremely difficult ...
  3. Inverted Yield Curve

    An interest rate environment in which long-term debt instruments have a lower yield than short-term debt instruments of the ...
  4. Socially Responsible Investment - SRI

    An investment that is considered socially responsible because of the nature of the business the company conducts. Common ...
  5. Presidential Election Cycle (Theory)

    A theory developed by Yale Hirsch that states that U.S. stock markets are weakest in the year following the election of a ...
Trading Center