Investopedia

What-If Calculation

Filed Under » ,
Dictionary Says

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.

Investopedia Says

Investopedia explains '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.

Articles Of Interest

  1. DCF Valuation: The Stock Market Sanity Check

    Calculate whether the market is paying too much for a particular stock.
  2. Bet Smarter With The Monte Carlo Simulation

    This technique can reduce uncertainty in estimating future outcomes.
  3. 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. Quants: The Rocket Scientists Of Wall Street

    Blend math, finance and computer skills to command a high - and well deserved - salary.
  5. Financial Career Options For Professionals

    Find out if spreading your wings to try a new career will make you soar or fall flat.
  6. 7 Unconventional Ways Businesses Can Borrow Money

    Find out how your business can get the money it needs - even when the bank says "no".
  7. A Look At CFA Job Opportunities

    Being a CFA charterholder can take your career in many different directions. Find out what your option are.
  8. 5 ETFs Flaws You Shouldn't Overlook

    Despite their popularity, exchange traded funds have some drawbacks that investors should know about.
  9. Using The Price-To-Book Ratio To Evaluate Companies

    The P/B ratio can be an easy way to determine a company's value, but it isn't magic!
  10. Liquidity Vs. Solvency

    Learn about the differences between these two words and how each one is used in the stock market.
comments powered by Disqus
Marketplace
Hot Definitions
  1. Abatement Cost

    A cost borne by many businesses for the removal and/or reduction of an undesirable item that they have created.
  2. Validation Period

    The amount of time necessary for the premium on an insurance policy to cover the commissions, the cost of investigation, medical exams and other expenses associated with the issuance of the policy.
  3. Winner's Curse

    Because of incomplete information, emotions or any other number of factors regarding the item being auctioned, bidders can have a difficult time determining the item's intrinsic value. As a result, the largest overestimation of an item's value ends up winning the auction.
  4. Glocalization

    A combination of the words "globalization" and "localization" used to describe a product or service that is developed and distributed globally, but is also fashioned to accommodate the user or consumer in a local market.
  5. Disaster Loss

    A special type of tax-deductible loss, similar to a casualty loss, where a loss has been incurred by taxpayers who reside in an area that has been designated as a federal disaster area by the President.
  6. Fool In The Shower

    The notion that changes or policies designed to alter the course of the economy should be done slowly, rather than all at once.
Trading Center