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. |
|
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. |
Related Definitions
Articles Of Interest
-
DCF Valuation: The Stock Market Sanity Check
Calculate whether the market is paying too much for a particular stock. -
Bet Smarter With The Monte Carlo Simulation
This technique can reduce uncertainty in estimating future outcomes. -
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. -
Quants: The Rocket Scientists Of Wall Street
Blend math, finance and computer skills to command a high - and well deserved - salary. -
Financial Career Options For Professionals
Find out if spreading your wings to try a new career will make you soar or fall flat. -
7 Unconventional Ways Businesses Can Borrow Money
Find out how your business can get the money it needs - even when the bank says "no". -
A Look At CFA Job Opportunities
Being a CFA charterholder can take your career in many different directions. Find out what your option are. -
5 ETFs Flaws You Shouldn't Overlook
Despite their popularity, exchange traded funds have some drawbacks that investors should know about. -
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! -
Liquidity Vs. Solvency
Learn about the differences between these two words and how each one is used in the stock market.
Free Annual Reports