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.

RELATED TERMS
  1. Model Risk

    A type of risk that occurs when a financial model used to measure ...
  2. Efficiency Variance

    The difference between the theoretical amount of inputs required ...
  3. Financial Modeling

    The process by which a firm constructs a financial representation ...
  4. Stress Testing

    A simulation technique used on asset and liability portfolios ...
  5. Variance

    The spread between numbers in a data set, measuring Variance ...
  6. Hull–White Model

    A single-factor interest model used to price derivatives. The ...
Related Articles
  1. Professionals

    Style Matters In Financial Modeling

    If you're looking to get a job as an analyst, you'll need to know how to work it.
  2. Professionals

    Risk-Analysis Techniques

    CFA Level 1 - Risk-Analysis Techniques. Learn the three techniques behind risk analysis. Covers aspects of sensitivity and scenario analysis, along with monte carlo simulation.
  3. Investing

    Understanding Financial Models

    A financial model is a representation of some aspects of a firm or given security. It uses historical numbers to create calculations that inform financial recommendations or predict future financial ...
  4. Retirement

    The 3 Best Retirement Calculators For 2016

    Find out the top three online retirement calculators to use in 2016 for determining how much you need to save to provide for sustainable income.
  5. Trading Systems & Software

    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 ...
  6. Fundamental Analysis

    Explaining Variance

    Variance is a measurement of the spread between numbers in a data set.
  7. 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.
  8. Investing

    Calculating The Means

    Learn more about the different ways you can calculate your portfolio's average return.
  9. Professionals

    DCF Vs. Comparables: Which One To Use

    DCF and Comparables models are widely used in equity valuation. We explain the pros and cons of each method.
  10. Fundamental Analysis

    Guide To Excel For Finance: Valuation Methods

    DCF There is not a specific function to run a full discounted cash flow model in Excel, but there are a number of tools to make the exercise much more straightforward. As touched upon in the ...
RELATED FAQS
  1. 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 >>
  2. What is the difference between financial forecasting and financial modelling?

    Understand the difference between financial forecasting and financial modeling, and learn why a company should conduct both ... 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 do you use a financial calculator to determine present value?

    Learn how to utilize a financial calculator to calculate present value. Understand the necessary data, why it is important ... Read Answer >>
  5. How do you use DCF for real estate valuation?

    Learn how discounted cash flow analysis is used for real estate valuation and the various factors that go into calculating ... Read Answer >>
  6. Where can I find a good compound interest calculator free on the Internet?

    Understand compound interest calculations and learn where you can find a good, free online compound interest calculator to ... Read Answer >>
Hot Definitions
  1. Law Of Demand

    A microeconomic law that states that, all other factors being equal, as the price of a good or service increases, consumer ...
  2. Cost Of Debt

    The effective rate that a company pays on its current debt. This can be measured in either before- or after-tax returns; ...
  3. Yield Curve

    A line that plots the interest rates, at a set point in time, of bonds having equal credit quality, but differing maturity ...
  4. Stop-Limit Order

    An order placed with a broker that combines the features of stop order with those of a limit order. A stop-limit order will ...
  5. Keynesian Economics

    An economic theory of total spending in the economy and its effects on output and inflation. Keynesian economics was developed ...
  6. Society for Worldwide Interbank Financial Telecommunications ...

    A member-owned cooperative that provides safe and secure financial transactions for its members. Established in 1973, the ...
Trading Center