## 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.

Next Up

## 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.

RELATED TERMS
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 ...

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.

### 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.

### 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.
RELATED FAQS
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 >>

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

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