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. Model Risk

    Model risk occurs when a financial model used to measure a firm's ...
  2. Business Model

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

    The multistage dividend discount model is an equity valuation ...
  4. Sensitivity

    Sensitivity is the magnitude of a financial instrument's reaction ...
  5. Default Model

    Default model is constructed by financial institutions to determine ...
  6. Abnormal Earnings Valuation Model

    The abnormal earnings valuation model is a method for determining ...
Related Articles
  1. Trading

    Build a Profitable Trading Model In 7 Easy Steps

    Trading models can provide a powerful tool for building profit. Traders can use and customize existing trading models or build an original model. This article provides seven steps to building ...
  2. Retirement

    2 of the Best Retirement Calculators

    Find out about two of the best online retirement calculators for determining how much you need to save to provide sustainable income for your lifetime.
  3. 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.
  4. 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.
  5. Investing

    The Advantages and Disadvantages of the CAPM Model

    In many situations, CAPM, while criticized for its unrealistic assumptions, provides a more useful outcome than either the DDM or WACC.
  6. Investing

    Why Your Investment Growth Calculator May Be Wrong

    Many simple investment growth calculators fall short, so here's one you should use instead.
  7. Investing

    Look Smart: Financial Calculations You Can Do In Your Head

    Ditch your financial calculator and use these handy tips for estimating complex financial calculations on the fly.
  8. Insights

    The Fed Model And Stock Valuation: What It Does And Does Not Tell Us

    Learn about this popular stock market valuation model and how accurate it has been over the years.
  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. What is the difference between financial forecasting and financial modeling?

    Understand the difference between financial forecasting and financial modeling, and learn why a company should conduct both ... Read Answer >>
  4. 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 >>
  5. 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 >>
  6. How do I calculate production costs in Excel?

    Find out about ways to use Excel to simplify production cost calculation and some sources of good templates and tips for ... Read Answer >>
Trading Center