Sensitivity and Scenario Analysis in Financial Modeling
Racing Daylight full movie In a typical financial model, variability in cash inflows and net present value (NPV) are often modeled using sensitivity and scenario analysis. Sensitivity analysis uses several possible values for a given variable, such as cash inflows, to assess that variable’s impact on the company’s return, measured here by the NPV. This technique is often used by financial analysts to get a feel for the variability of return in response to changes in a key variable.
One of the most common sensitivity approaches used in financial modeling is to estimate the NPV in relation to a number of different estimates of cash inflow, which vary from the optimistic case (best) estimates for cash flow, to the base case (expected) estimate of cash inflow, to the pessimistic case (worst) estimate of cash inflow.
download The Flintstones in Viva Rock Vegas
The NPV range can then be determined by subtracting the pessimistic outcome NPV from the optimistic outcome NPV. Often, by putting forward an NPV range, a good financial analyst is able to present a balanced view of a business case by highlighting both the potential downside risks as well as the potential upside of the investment, allowing business executives to make calculated decisions based on their risk appetite.
Scenario analysis in financial modeling is similar to sensitivity analysis, but broader in scope. Scenario analysis evaluates the impact of simultaneous changes in a number of variables, such as cash inflows, cash outflows, the cost of capital, or even leading revenue / cost growth rates. The combined effect of changes in these variables are then applied to evaluate the impact on the company’s return.
For instance, a company could evaluate the impact of a high or low risk-free interest rate environment on a company’s NPV. Each scenario will affect the company’s cash inflow, cash outflows, and cost of capital, thereby resulting in different levels of NPV. A financial analyst can then use these NPV estimates to assess the risk involved with respect to the interest rate environment.