Sensitivity Analysis
Originally published: 14/08/2020 17:40
Publication number: ELQ-79558-1
View all versions & Certificate

Sensitivity Analysis

What-if analysis in Microsoft Excel for anyone to use.

Sensitivity analysis is a model show how target variables are effected on changes in input variables. A sensitivity analysis determines how different values of an independent variables affect a particular dependent variable under a given set of assumptions.

In this case Study I set a strategy were adopted from one January, what the cash balance closest to at the end of 2020, if:
- sales price increases by 12%
- forecast volume is lower going forward by 5%
- direct cost per unit are maintained.

In witch quarter the cash shortfall peak, which month run out of the cash, what is the total of indirect cost forecast expected for the three years forecast, what is the closing accounts payable in December 2020, what is forecast revenue in January 2019.

You as a financial analysis need to forecast the cash flow for the coming three years with particular focus in the next twelve month, you will design a sensitivity financial model to determinate who the small change in the input assumption will effected in cash flow and revenue in the output, in which point of input assumption the cash flow is so sensitive, what strategy you need to set to a swift improvement in cash flow, to keep the businesses afloat.

This Best Practice includes
1 Excel Template

Acquire consulting license for $25.00

Add to cart

Add to bookmarks


0.0 / 5 (0 votes)

please wait...