What is a 'What-If Calculation'

A what-if calculation is an output from a financial model using different assumptions or scenarios. What if "x" is inputted into the model — what is the result? What-if calculations enable an economic forecaster to check the variance in end results for a financial model using various hypothetical levels for inputs such as interest rates, inflation rates and exchange rates for a GDP model, for instance. 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'

What-if calculations can be run very easily once a sound financial model is set up. Any number of variable inputs can be changed to estimate how a studied output is affected. All types of corporations put together financial models for internal budgeting needs and to evaluate contemplated investments. In a discounted cash flow model used to assess the viability of a project, for example, 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 on Wall Street

Wall Street cannot function without spreadsheets. Whether it is a banker in mergers and acquisitions, a sell-side analyst, or a risk manager running internal value-at-risk (VaR) models, what-if calculations in a financial model are routinely performed to account for various possibilities that may impact the valuation of an acquisition target, price-earnings ratio of a stock, or the conformity of a set of derivative transactions to risk parameters. The caveats of what-if calculations is that a) a model must be set up correctly, and b) the output will only be as reliable as the inputs. As it was so painfully demonstrated during the financial crisis, what-if calculations failed because modelers put together faulty models and, on top of that, made grossly erroneous assumptions for model inputs.

  1. Financial Modeling

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

    Sensitivity analysis is a technique used to determine how different ...
  3. Capital Investment Analysis

    Capital investment analysis is a budgeting procedure that companies ...
  4. Business Model

    A business model is a company's plan for generating revenues ...
  5. Multistage Dividend Discount Model

    The multistage dividend discount model is an equity valuation ...
  6. Option Pricing Theory

    An option pricing theory is any model or theory-based approach ...
Related Articles
  1. Investing

    Financial Models You Can Create With Excel

    The relatively modest amount of time it takes to build these models can pay for itself by leading you to better investment decisions.
  2. Personal Finance

    How to Prepare an Expense Budget and Why

    It is important to budget your expenses so you are prepared for unforeseen costs or income losses.
  3. Personal Finance

    The Best Financial Modeling Courses for Investment Bankers

    Obtain information, both general and comparative, about the best available financial modeling courses for individuals pursuing a career in investment banking.
  4. Retirement

    The 3 Best Social Security Calculators For 2016

    Find out how to analyze your Social Security benefits under different retirement scenarios using multifunctional online Social Security calculators.
  5. Retirement

    11 Social Security Calculators Worth Your Time

    The safest Social Security calculators to use when figuring benefits are on the official website. The best are the ones that access your actual record.
  6. Small Business

    How to Calculate Net Present Value (NPV) in Excel

    Learn how to calculating the net present value (NPV) of your investment projects using built-in functions from Excel.
  7. Financial Advisor

    Is Texas Instruments a Good Value Play? (TXN)

    Find out whether investors and analysts believe that Texas Instruments would make a good value play at its current valuation, and learn more about its outlook.
  8. Investing

    Business forecasting: Understanding the basics

    Discover the methods behind financial forecasts and the risks inherent when we seek to predict the future.
  9. Investing

    Why Your Investment Growth Calculator May Be Wrong

    Many simple investment growth calculators fall short, so here's one you should use instead.
  1. How do I use Excel to get discount rate over time?

    Learn how to calculate discount rate in Microsoft Excel and how to find the discount factor over a specified number of years. Read Answer >>
  2. What are some examples of ways that sensitivity analysis can be used?

    Understand the concept of sensitivity analysis and learn about the wide variety of disciplines to which it can be applied. Read Answer >>
  3. How is the ability to perform Activities of Daily Living (ADL) measured?

    Find out how to apply sensitivity analysis to your investment decisions, why sensitivity analysis might be useful and what ... Read Answer >>
  4. How is productivity calculated?

    Learn about productivity, what it measures and how to compute a company's productivity level by measuring its outputs relative ... Read Answer >>
  5. What are the advantages and disadvantages of the Gordon Growth Model?

    Understand the advantages and disadvantages of using the Gordon Growth Model to value a company's publicly traded stock. ... Read Answer >>
  6. Calculate your portfolio's investment returns

    Learn the basic principles underlying the data and calculations used to perform personal rates of return on investment portfolios. Read Answer >>
Hot Definitions
  1. Business Cycle

    The business cycle describes the rise and fall in production output of goods and services in an economy. Business cycles ...
  2. Futures Contract

    An agreement to buy or sell the underlying commodity or asset at a specific price at a future date.
  3. Yield Curve

    A yield curve is a line that plots the interest rates, at a set point in time, of bonds having equal credit quality, but ...
  4. Portfolio

    A portfolio is a grouping of financial assets such as stocks, bonds and cash equivalents, also their mutual, exchange-traded ...
  5. Gross Profit

    Gross profit is the profit a company makes after deducting the costs of making and selling its products, or the costs of ...
  6. Diversification

    Diversification is the strategy of investing in a variety of securities in order to lower the risk involved with putting ...
Trading Center