Tuesday 13 October 2015

Sensitivity Analyses for Cost Example

Sensitivity Analyses for Cost Example

In sensitivity analyses for cost, we see sensitivity (reaction) of NPV to cost. We calculate a margin of safety for cost. There are three steps for these analyses. In first place we calculate NPV, then we calculated Present value of cost and in last we calculate margin of safety for cost. (How much cost can be increase to get zero NPV?

Example of Sensitivity & Variable

Initial Investment
200,000
Volume of Sales
20,000 Units
Selling Price
12
Variable Price
8
Project term 4 years
4 years

Cost of Capital is 10%

Solution

1.     Calculate NPV

Cash outflow
$ 200,000
Cash inflow ( $ 20,000 x 4 x 3.170)
$ 253,600
NPV (253,600-200,000)
$ 53,600

2.     Calculate present Value of Variable Cost

Variable Cost ( 20,000 @ 8 )
160,000
Annuity Factor 4 years
3.170
Present Value of Variable Cost
$ 507,200





3.    Margin of safety for contribution
= $ 53,600/$ 507,200 x 100
=10.56%

Cost is to be raised by 10.56% to bring the NPV to the level of Zero. Therefore variable cost is more sensitive to the NPV.