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. 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.
  5. 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.
  6. 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.
  7. Investing Basics

    5 Tips For Diversifying Your Portfolio

    A diversified portfolio will protect you in a tough market. Get some solid tips here!
  8. 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.
  9. Forex Education

    Explaining Uncovered Interest Rate Parity

    Uncovered interest rate parity is when the difference in interest rates between two nations is equal to the expected change in exchange rates.
  10. Fundamental Analysis

    Using Decision Trees In Finance

    A decision tree provides a comprehensive framework to review the alternative scenarios and consequences a decision may lead to.
  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. Turkey

    Slang for an investment that yields disappointing results or turns out worse than expected. Failed business deals, securities ...
  2. Barefoot Pilgrim

    A slang term for an unsophisticated investor who loses all of his or her wealth by trading equities in the stock market. ...
  3. Quick Ratio

    The quick ratio is an indicator of a company’s short-term liquidity. The quick ratio measures a company’s ability to meet ...
  4. Black Tuesday

    October 29, 1929, when the DJIA fell 12% - one of the largest one-day drops in stock market history. More than 16 million ...
  5. Black Monday

    October 19, 1987, when the Dow Jones Industrial Average (DJIA) lost almost 22% in a single day. That event marked the beginning ...
  6. Monetary Policy

    Monetary policy is the actions of a central bank, currency board or other regulatory committee that determine the size and ...
Trading Center