|
Navigation |
|
|
|
|
|
|
|
|
|
|
|
|
|
Case Builder Model |
Îê |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Annual Summary - Base Case |
|
|
|
|
|
|
|
|
|
|
|
|
|
Income Statement Summary |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(in USD 000s, except otherwise stated) |
|
|
|
|
|
Dec-14 |
Dec-15 |
Dec-16 |
Dec-17 |
Dec-18 |
|
|
|
Revenues |
USD 000s |
|
|
|
|
183 648.7 |
200 751.0 |
211 502.6 |
220 112.2 |
229 072.3 |
|
|
|
Gross Margin |
USD 000s |
|
|
|
|
83 564.4 |
95 356.7 |
100 463.7 |
104 553.3 |
108 809.4 |
|
|
|
-- gross margin, % |
% |
|
|
|
|
45.5% |
47.5% |
47.5% |
47.5% |
47.5% |
|
|
|
EBITDA |
USD 000s |
|
|
|
|
39 485.3 |
48 934.4 |
52 202.1 |
54 616.8 |
57 137.0 |
|
|
|
-- EBITDA margin, % |
% |
|
|
|
|
21.5% |
24.4% |
24.7% |
24.8% |
24.9% |
|
|
|
EBIT |
USD 000s |
|
|
|
|
4 042.5 |
10 462.9 |
10 677.1 |
26 631.1 |
43 004.8 |
|
|
|
-- EBIT margin, % |
% |
|
|
|
|
2.2% |
5.2% |
5.0% |
12.1% |
18.8% |
|
|
|
EBT |
USD 000s |
|
|
|
|
1 679.1 |
8 979.4 |
9 820.7 |
26 116.5 |
43 003.0 |
|
|
|
-- EBT ìàðæà, % |
% |
|
|
|
|
0.9% |
4.5% |
4.6% |
11.9% |
18.8% |
|
|
|
Net Income |
USD 000s |
|
|
|
|
1 343.3 |
7 183.6 |
7 856.6 |
20 893.2 |
34 402.4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Balance Sheet Statement Summary |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Projected
Fiscal Year Ending |
|
|
|
(in USD 000s, except otherwise stated) |
|
|
|
|
Dec-13 |
Dec-14 |
Dec-15 |
Dec-16 |
Dec-17 |
Dec-18 |
|
|
|
Long Term Assets |
USD 000s |
|
|
|
121 000.0 |
111 557.1 |
99 085.7 |
104 560.7 |
104 575.0 |
120 942.9 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Debtors |
USD 000s |
|
|
|
14 000.0 |
15 697.4 |
16 912.5 |
17 644.7 |
18 363.0 |
19 110.5 |
|
|
|
Inventory |
USD 000s |
|
|
|
5 000.0 |
5 598.7 |
5 919.4 |
6 175.7 |
6 427.1 |
6 688.7 |
|
|
|
Other CA |
USD 000s |
|
|
|
- |
- |
- |
- |
- |
- |
|
|
|
Creditors |
USD 000s |
|
|
|
(20
000.0) |
(20
162.8) |
(21
263.7) |
(22
135.1) |
(22
996.1) |
(23
891.1) |
|
|
|
Other CL |
USD 000s |
|
|
|
- |
- |
- |
- |
- |
- |
|
|
|
Net Working Capital (ex.Cash) |
USD 000s |
|
|
|
(1
000.0) |
1 133.3 |
1 568.2 |
1 685.3 |
1 794.0 |
1 908.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Financed by |
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash |
USD 000s |
|
|
|
1 000.0 |
- |
9 372.9 |
4 637.4 |
18 407.7 |
29 828.1 |
|
|
|
Short Term Revolver |
USD 000s |
|
|
|
(10
000.0) |
(4
347.2) |
- |
- |
- |
- |
|
|
|
Bank Debt Tranche A |
USD 000s |
|
|
|
(20
000.0) |
(16
000.0) |
(12
000.0) |
(8
000.0) |
(4
000.0) |
- |
|
|
|
Bank Debt Tranche B |
USD 000s |
|
|
|
(10
000.0) |
(10
000.0) |
(8
500.0) |
(5
500.0) |
(2
500.0) |
- |
|
|
|
Bank Debt Tranche C |
USD 000s |
|
|
|
- |
- |
- |
- |
- |
- |
|
|
|
Net Debt as of |
USD 000s |
|
|
|
(39
000.0) |
(30
347.2) |
(11
127.1) |
(8
862.6) |
11 907.7 |
29 828.1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other LT Libilities |
USD 000s |
|
|
|
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Equity & Reserves |
USD 000s |
|
|
|
81 000.0 |
82 343.3 |
89 526.8 |
97 383.4 |
118 276.6 |
152 679.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Îê |
Îê |
Îê |
Îê |
Îê |
Îê |
|
|
|
Cash Flow Statement Summary |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(in USD 000s, except otherwise stated) |
|
|
|
|
Dec-13 |
Dec-14 |
Dec-15 |
Dec-16 |
Dec-17 |
Dec-18 |
|
|
|
EBITDA |
USD 000s |
|
|
|
|
39 485.3 |
48 934.4 |
52 202.1 |
54 616.8 |
57 137.0 |
|
|
|
Cash Interest Income |
USD 000s |
|
|
|
|
2.5 |
17.2 |
142.4 |
94.2 |
216.9 |
|
|
|
Cash Interest Expense |
USD 000s |
|
|
|
|
(2
365.9) |
(1
500.7) |
(998.8)
|
(608.8)
|
(218.8)
|
|
|
|
Cash Tax |
USD 000s |
|
|
|
|
(335.8)
|
(1
795.9) |
(1
964.1) |
(5
223.3) |
(8
600.6) |
|
|
|
Net Change in WC |
USD 000s |
|
|
|
|
(2
133.3) |
(434.9)
|
(117.1)
|
(108.7)
|
(114.1)
|
|
|
|
Operating Cash Flow before Investments |
USD 000s |
|
|
|
|
34 652.8 |
45 220.1 |
49 264.5 |
48 770.3 |
48 420.5 |
|
|
|
CAPEX |
USD 000s |
|
|
|
|
(26
000.0) |
(26
000.0) |
(47
000.0) |
(28
000.0) |
(30
500.0) |
|
|
|
Net Change in Other LTA/LTL |
USD 000s |
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
Extraordinary Cash Items |
USD 000s |
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
Change in Cash before Financing |
USD 000s |
|
|
|
|
8 652.8 |
19 220.1 |
2 264.5 |
20 770.3 |
17 920.5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Financed by |
|
|
|
|
|
|
|
|
|
|
|
|
|
Equity Issue / (Buy Back or Dividend) |
USD 000s |
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
Debt Issue / (Retirement) |
USD 000s |
|
|
|
|
(9
652.8) |
(9
847.2) |
(7
000.0) |
(7
000.0) |
(6
500.0) |
|
|
|
Total Financing |
USD 000s |
|
|
|
|
(9
652.8) |
(9
847.2) |
(7
000.0) |
(7
000.0) |
(6
500.0) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Change in Cash for the Period |
USD 000s |
|
|
|
|
(1
000.0) |
9 372.9 |
(4
735.5) |
13 770.3 |
11 420.5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash BoP |
USD 000s |
|
|
|
|
1 000.0 |
0.0 |
9 372.9 |
4 637.4 |
18 407.7 |
|
|
|
Cash EoP |
USD 000s |
|
|
|
1 000.0 |
0.0 |
9 372.9 |
4 637.4 |
18 407.7 |
29 828.1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Month Counter |
|
|
|
|
|
12.0 |
24.0 |
36.0 |
48.0 |
60.0 |
|
|
|
Year Counter |
|
|
|
|
|
1.0 |
2.0 |
3.0 |
4.0 |
5.0 |
|
|
|
>> End of Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|