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

    Tribune Media: An Activist Investment Analysis (TRCO)

    Learn more about the breakup of Tribune Company, once a powerful newspaper and broadcasting giant, and the role of activist investor Cliff Robbins.
  5. Fundamental Analysis

    5 Basic Financial Ratios And What They Reveal

    Understanding financial ratios can help investors pick strong stocks and build wealth. Here are five to know.
  6. Stock Analysis

    Air Products and Chemicals: An Activist Investment Analysis (APD)

    Learn about the productive, and uncommonly friendly, activist investment made by Bill Ackman into Air Products and Chemicals.
  7. Investing

    What Investors Need to Know About Returns in 2016

    Last year wasn’t a great one for investors seeking solid returns, so here are three things we believe all investors need to know about returns in 2016.
  8. Investing News

    Icahn's Bet on Cheniere Energy: Should You Follow?

    Investing legend Carl Icahn continues to lose money on Cheniere Energy, but he's increasing his stake. Should you follow his lead?
  9. Investing

    3 Things About International Investing and Currency

    As world monetary policy continues to diverge rocking bottom on interest rates while the Fed raises them, expect currencies to continue their bumpy ride.
  10. Stock Analysis

    Jana Partners: An Activist Investor Analysis

    Learn about Jana Partners, a hedge fund founded by Barry Rosenstein. Read about new positions in ConAgra and Qualcomm the fund took in 2015.
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. Flight To Quality

    The action of investors moving their capital away from riskier investments to the safest possible investment vehicles. This ...
  2. Discouraged Worker

    A person who is eligible for employment and is able to work, but is currently unemployed and has not attempted to find employment ...
  3. Ponzimonium

    After Bernard Madoff's $65 billion Ponzi scheme was revealed, many new (smaller-scale) Ponzi schemers became exposed. Ponzimonium ...
  4. Quarterly Earnings Report

    A quarterly filing made by public companies to report their performance. Included in earnings reports are items such as net ...
  5. Dark Pool Liquidity

    The trading volume created by institutional orders that are unavailable to the public. The bulk of dark pool liquidity is ...
Trading Center