|
Navigation |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Case Builder Model |
Îê |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Working Capital - Base Case |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Projected
Fiscal Year Ending |
|
|
(in USD 000s, except otherwise stated) |
|
|
|
|
Dec-13 |
Mar-14 |
Jun-14 |
Sep-14 |
Dec-14 |
Mar-15 |
Jun-15 |
Sep-15 |
Dec-15 |
Mar-16 |
Jun-16 |
Sep-16 |
Dec-16 |
Mar-17 |
Jun-17 |
Sep-17 |
Dec-17 |
Mar-18 |
Jun-18 |
Sep-18 |
Dec-18 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Revenues |
USD 000s |
|
|
|
|
44 000.0 |
45 325.5 |
46 577.1 |
47 746.1 |
48 824.6 |
49 804.8 |
50 679.4 |
51 442.2 |
52 087.1 |
52 609.3 |
53 136.7 |
53 669.4 |
54 207.4 |
54 750.9 |
55 299.8 |
55 854.1 |
56 414.1 |
56 979.6 |
57 550.8 |
58 127.8 |
|
|
COGS |
USD 000s |
|
|
|
|
24 000.0 |
25 155.7 |
25 384.5 |
25 544.2 |
25 632.9 |
26 147.5 |
26 606.7 |
27 007.1 |
27 345.7 |
27 619.9 |
27 896.8 |
28 176.4 |
28 458.9 |
28 744.2 |
29 032.4 |
29 323.4 |
29 617.4 |
29 914.3 |
30 214.2 |
30 517.1 |
|
|
Central Costs & Overheads Operating Assumptions |
USD 000s |
|
|
|
|
10 800.0 |
10 930.8 |
11 095.3 |
11 252.9 |
11 402.7 |
11 544.1 |
11 676.4 |
11 799.1 |
11 911.6 |
12 013.5 |
12 116.3 |
12 220.1 |
12 324.8 |
12 430.4 |
12 536.9 |
12 644.4 |
12 752.9 |
12 862.4 |
12 972.8 |
13 084.3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Working Capital |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Debtors - Days of Revenues |
Days |
|
|
|
|
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
|
|
Inventory - Days of COGS |
Days |
|
|
|
|
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
|
|
Creditors - Days of Total Costs |
Days |
|
|
|
|
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
|
|
Changes in Other CA |
USD 000s |
|
|
|
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
Changes in Other CL |
USD 000s |
|
|
|
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Debtors |
USD 000s |
|
|
|
14 000.0 |
14 465.8 |
14 901.5 |
15 313.0 |
15 697.4 |
16 051.9 |
16 374.2 |
16 661.7 |
16 912.5 |
17 124.5 |
17 296.2 |
17 469.6 |
17 644.7 |
17 821.6 |
18 000.3 |
18 180.7 |
18 363.0 |
18 547.1 |
18 733.0 |
18 920.8 |
19 110.5 |
|
|
Inventory |
USD 000s |
|
|
|
5 000.0 |
5 260.3 |
5 513.6 |
5 563.7 |
5 598.7 |
5 618.2 |
5 731.0 |
5 831.6 |
5 919.4 |
5 993.6 |
6 053.7 |
6 114.4 |
6 175.7 |
6 237.6 |
6 300.1 |
6 363.3 |
6 427.1 |
6 491.5 |
6 556.6 |
6 622.3 |
6 688.7 |
|
|
Creditors |
USD 000s |
|
|
|
(20
000.0) |
(19
068.5) |
(19
773.4) |
(19
989.0) |
(20
162.8) |
(20
293.5) |
(20
652.9) |
(20
977.1) |
(21
263.7) |
(21
510.9) |
(21
716.9) |
(21
925.0) |
(22
135.1) |
(22
347.2) |
(22
561.4) |
(22
777.7) |
(22
996.1) |
(23
216.6) |
(23
439.3) |
(23
664.1) |
(23
891.1) |
|
|
Other CA |
USD 000s |
|
|
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
Other CL |
USD 000s |
|
|
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
>> End of Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|