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

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

    A standard that was developed to improve the way in which financial ...
  6. Financial Modeling

    The process by which a firm constructs a financial representation ...
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. Professionals

    Top 5 Highest Paid Hedge Fund Managers

    Understand what a hedge fund is and why hedge fund managers make so much money. Learn about the top 5 highest paid hedge fund managers.
  5. Investing Basics

    6 Reasons Hedge Funds Underperform

    Understand the hedge fund industry and why it has grown exponentially since 1995. Learn about the top six reasons why the industry underperforms.
  6. Investing Basics

    What Does In Specie Mean?

    In specie describes the distribution of an asset in its physical form instead of cash.
  7. Economics

    Calculating Cross Elasticity of Demand

    Cross elasticity of demand measures the quantity demanded of one good in response to a change in price of another.
  8. Fundamental Analysis

    Emerging Markets: Analyzing Colombia's GDP

    With a backdrop of armed rebels and drug cartels, the journey for the Colombian economy has been anything but easy.
  9. Professionals

    How Brokers are Candy-Coating Alternatives

    Alternatives have become a sexy choice for many advisors. But they also come with additional risks that are not always clearly spelled out to clients.
  10. Investing

    What is Carried Interest?

    Carried interest is the percentage of a private equity or a hedge fund’s profits that its general partners receive as compensation.
  1. Who do hedge funds lend money to?

    Many traditional lenders and banks are failing to provide loans. In their absence, hedge funds have begun to fill the gap. ... Read Full Answer >>
  2. What licenses does a hedge fund manager need to have?

    A hedge fund manager does not necessarily need any specific license to operate a fund, but depending on the type of investments ... Read Full Answer >>
  3. What do hedge fund analysts do?

    A hedge fund analyst primarily provides support to a portfolio manager on how to best structure the hedge fund's investment ... Read Full Answer >>
  4. Can mutual funds invest in hedge funds?

    Mutual funds are legally allowed to invest in hedge funds. However, hedge funds and mutual funds have striking differences ... Read Full Answer >>
  5. 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 >>
  6. 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 >>

You May Also Like

Hot Definitions
  1. Zero-Sum Game

    A situation in which one person’s gain is equivalent to another’s loss, so that the net change in wealth or benefit is zero. ...
  2. Capitalization Rate

    The rate of return on a real estate investment property based on the income that the property is expected to generate.
  3. Gross Profit

    A company's total revenue (equivalent to total sales) minus the cost of goods sold. Gross profit is the profit a company ...
  4. Revenue

    The amount of money that a company actually receives during a specific period, including discounts and deductions for returned ...
  5. Normal Profit

    An economic condition occurring when the difference between a firm’s total revenue and total cost is equal to zero.
  6. Operating Cost

    Expenses associated with the maintenance and administration of a business on a day-to-day basis.
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!