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.

  1. Discounted Cash Flow (DCF)

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

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

    An informal mathematical computation, often performed on a scrap ...
  4. Financial Modeling

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

    Sensitivity analysis is a technique used to determine how different ...
  6. eXtensible Business Reporting Language ...

    A standard that was developed to improve the way in which financial ...
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. Mutual Funds & ETFs

    The Democratization of the Hedge Fund Industry

    The coveted compensations of hedge fund managers are protected by barriers of entry to the industry, but one recent startup is working to break those barriers.
  5. Investing

    What a Family Tradition Taught Me About Investing

    We share some lessons from friends and family on saving money and planning for retirement.
  6. Investing

    Where the Price is Right for Dividends

    There are two broad schools of thought for equity income investing: The first pays the highest dividend yields and the second focuses on healthy yields.
  7. Professionals

    A Day in the Life of a Hedge Fund Manager

    Learn what a typical early morning to late evening workday for a hedge fund manager consists of and looks like from beginning to end.
  8. Personal Finance

    How Tech Can Help with 3 Behavioral Finance Biases

    Even if you’re a finance or statistics expert, you’re not immune to common decision-making mistakes that can negatively impact your finances.
  9. Investing Basics

    5 Tips For Diversifying Your Portfolio

    A diversified portfolio will protect you in a tough market. Get some solid tips here!
  10. Entrepreneurship

    Identifying And Managing Business Risks

    There are a lot of risks associated with running a business, but there are an equal number of ways to prepare for and manage them.
  1. 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 >>
  2. 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 >>
  3. 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 >>
  4. Can hedge fund returns be replicated?

    You can replicate hedge fund returns to a degree but not perfectly. Most replication strategies underperform hedge funds ... Read Full Answer >>
  5. Can foreign investors invest in US hedge funds?

    U.S. hedge funds are open to accredited investors. When they distribute profits to investors, those proceeds are taxed at ... Read Full Answer >>
  6. Do hedge funds manipulate stock prices?

    Some economics professors think there is evidence of manipulation of certain stocks by hedge funds on key reporting days. ... Read Full Answer >>

You May Also Like

Hot Definitions
  1. Bar Chart

    A style of chart used by some technical analysts, on which, as illustrated below, the top of the vertical line indicates ...
  2. Bullish Engulfing Pattern

    A chart pattern that forms when a small black candlestick is followed by a large white candlestick that completely eclipses ...
  3. Cyber Monday

    An expression used in online retailing to describe the Monday following U.S. Thanksgiving weekend. Cyber Monday is generally ...
  4. Take A Bath

    A slang term referring to the situation of an investor who has experienced a large loss from an investment or speculative ...
Trading Center