BREAK-EVEN ANALYSIS


Sensitivity analysis is a variation of the break-even analysis. In sensitivity analysis we are asking; for example, what shall be the consequences if volume or price or cost changes? This question can be asked differently: How much lower the sales volume can become before the project becomes unprofitable? To answer this question we shall require the Breakeven point.

Continuing with the above example, let us compute the level of units variable costs above which the NPV is negative.

 NPV = Annual cashflows x PVIFA 10%, 10 yrs - 150,000

 But

Annual cashflows = Revenue - variable costs - Fixed costs - depreciation - Tax + depreciation.

 Let variable cost per unit be V

 Annual cashflows = (375,000 - 100 (V) - 45,000)0.5 + 15,000

 Therefore NPV = [(330,000 - 100 V) 0.5 + 15,000] x 6.145 - 150,000

 At Break even point NPV = 0

 Therefore (165,000 - 50 V + 15,000) 6.145 = 150,000

 1,106,100 - 307.25v = 150,000

 307.25 V = 956,100

V = 3,111.8

 Therefore the point above which the variable cost per unit will cause the NPV to be negative is about Sh 3,112.

To prove if variable unit cost is Sh 3,112 the NPV will be computed as follows:

Sh

Revenue 375,000

Variable costs 311,200

Fixed cost 30,000

Depreciation 15,000 356,200

18,800

Tax 9,400

9,400

Add back depreciation 15,000

Net cashflows 24,400

NPV = 24,400 x 6.145 - 150,000

= -62

Note: The NPV is not equal to zero due to rounding off effects.