Sales Less: VC Contribution Less: FC Ebit Less: Interest EBT Less: Tax PBT
Sales Less: VC Contribution Less: FC Ebit Less: Interest EBT Less: Tax PBT
Sales Less: VC Contribution Less: FC Ebit Less: Interest EBT Less: Tax PBT
Less: VC
Contribution
Less: FC
EBIT
Less: Interest
EBT
Less: Tax
PBT
Case No FC
Units 1000 1000 1000
Sales (10/ unit) 10000 10000 10000
Less: VC (6/ unit) 6000 6000 6000
Contribution 4000 4000 4000
Less: FC 2000 0 2000
EBIT 2000 4000 2000
OL= Contribution/EBIT 2 1 2
OL = 1, if no FC exist
Case
Units 1000 1200 given
Sales (10/ unit) 10000 12000
Less: VC (6/ unit) 6000 7200 OL 2
Contribution 4000 4800
Less: FC 2000 2000
EBIT 2000 2800
Less: Interest 1000 1000 FL 2
EBT 1000 1800
Less: Tax (40%) 400 720
PAT 600 1080
CL 4
Increase in number of
units % Increase Units % increase HIGH FC
2000 100% 3000
20000 100%
12000 100%
8000 100%
2000
6000 200
1.33
(at what level?)
Increment in sales?
OL = Contribution/EBIT -1.5
600 800 1000 2000 3000 4000 #REF! #REF! #REF!
6000 8000 10000 20000 30000 40000
3600 4800 6000 12000 18000 24000
2400 3200 4000 8000 12000 16000
2000 2000 2000 2000 2000 2000
400 1200 2000 6000 10000 14000