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 values 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. What is the utility function and how is it calculated?

    In economics, utility function is an important concept that measures preferences over a set of goods and services. Utility ... Read Full Answer >>
  2. What is the 12b-1 fee meant to cover?

    A 12b-1 fee in a mutual fund is meant to cover the fees of companies and individuals through which investors of a fund buy ... Read Full Answer >>
  3. How can I use a regression to see the correlation between prices and interest rates?

    In statistics, regression analysis is a widely used technique to uncover relationships among variables and determine whether ... Read Full Answer >>
  4. Which federal regulatory agencies approved and are now responsible for enforcing ...

    Five federal regulatory agencies approved and are jointly responsible for enforcing the Volcker rule. These agencies include ... Read Full Answer >>
  5. What is the purpose of the Volcker Rule?

    The Volcker rule limits two main types of activities by large institutional banks. Banks are prohibited from engaging in ... Read Full Answer >>
  6. What types of positions might a Chartered Financial Analyst (CFA) hold?

    The types of positions that a Chartered Financial Analyst (CFA) is likely to hold include any position that deals with large ... Read Full Answer >>
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 Basics

    Understanding Total Return Swaps

    A total return swap is a contract in which a payer and receiver exchange the credit risk and market risk of an underlying asset.
  5. Economics

    What's a Centrally Planned Economy?

    A centrally planned economy is one where the government controls the country’s supply and demand of goods and services.
  6. Economics

    What are Barriers to Entry?

    A barrier to entry is any obstacle that restricts or impedes a company’s efforts to enter an industry.
  7. Investing Basics

    Explaining Absolute Return

    Absolute return refers to an asset’s total return over a set period of time. It’s usually applied to stocks, mutual funds or hedge funds.
  8. Mutual Funds & ETFs

    ETF Analysis: SPDR S&P 500 Trust

    Find out more about the SPDR S&P 500 ETF Trust, the characteristics of the exchange traded fund and the suitability of investing in the fund.
  9. Mutual Funds & ETFs

    ETF Analysis: Energy Select Sector SPDR

    Find out more about the Energy Select Sector SPDR Fund, the top holdings of this exchange-traded fund and the characteristics of the fund.
  10. Mutual Funds & ETFs

    The Daily Routine Of A Hedge Fund Manager

    What does a hedge fund manager's day really look like? Investopedia provides an inside look at the routine.

You May Also Like

Hot Definitions
  1. Topless Meeting

    A meeting in which participants are not allowed to use laptops. A topless meeting organizer can also ban the use of smartphones, ...
  2. Hedging Transaction

    A type of transaction that limits investment risk with the use of derivatives, such as options and futures contracts. Hedging ...
  3. Bogey

    A buzzword that refers to a benchmark used to evaluate a fund's performance. The benchmark is an index that reflects the ...
  4. Xetra

    An all-electronic trading system based in Frankfurt, Germany. Launched in 1997 and operated by the Deutsche Börse, the Xetra ...
  5. Nuncupative Will

    A verbal will that must have two witnesses and can only deal with the distribution of personal property. A nuncupative will ...
  6. OsMA

    An abbreviation for Oscillator - Moving Average. OsMA is used in technical analysis to represent the variance between an ...
Trading Center
×

You are using adblocking software

Want access to all of Investopedia? Add us to your “whitelist”
so you'll never miss a feature!