Valuation Template
Valuation Template
Valuation Template
Methods of Valuation
27 Elul Wed
Index
Valuation Summary
Qualitative Multiple
Justified Multiple
Year 1 2 3
EBIT 100.0 110.0 121.0
(-) Taxes (25.0) (27.5) (30.3)
(=) NOPAT 75.0 82.5 90.8
(+) Depreciation
(-) CAPEX
(-) ∆ Working Capital
FCF Pre Growth Inv 75.0 82.5 90.8
(=) Net Investment (37.5) (41.3) (45.4)
(=) FCFF 37.5 41.3 45.4
g
1.0% 3.0% 5.0% 7.0% 9.0% 11.0% 13.0% 15.0%
g
1.0% 3.0% 5.0% 7.0% 9.0% 11.0% 13.0% 15.0%
g
1.0% 3.0% 5.0% 7.0% 9.0% 11.0% 13.0% 15.0%
12 13 14 15 16 17 18 19
285.3 313.8 345.2 379.7 387.3 395.1 403.0 411.1
(71.3) (78.5) (86.3) (94.9) (96.8) (98.8) (100.7) (102.8)
214.0 235.4 258.9 284.8 290.5 296.3 302.2 308.3
Justified Multiple