|
Navigation |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Case Builder Model |
Îê |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Stress Case - Operating
Assumtions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Projected
Fiscal Year Ending |
|
(in USD 000s, except otherwise stated) |
|
|
|
|
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Volume |
000s |
|
|
|
|
800.0 |
796.0 |
794.0 |
794.0 |
796.0 |
798.0 |
800.0 |
802.0 |
804.0 |
806.0 |
808.0 |
810.0 |
812.1 |
814.1 |
816.1 |
818.2 |
820.2 |
822.3 |
824.3 |
826.4 |
|
Annual Growth Rate |
% per annum |
|
|
|
|
|
(2.0%) |
(1.0%) |
- |
1.0% |
1.0% |
1.0% |
1.0% |
1.0% |
1.0% |
1.0% |
1.0% |
1.0% |
1.0% |
1.0% |
1.0% |
1.0% |
1.0% |
1.0% |
1.0% |
|
Average Price |
USD |
|
|
|
|
55.0 |
55.0 |
55.1 |
55.3 |
55.6 |
55.8 |
56.1 |
56.4 |
56.7 |
57.0 |
57.2 |
57.5 |
57.8 |
58.1 |
58.4 |
58.7 |
59.0 |
59.3 |
59.6 |
59.9 |
|
Annual Growth Rate |
% per annum |
|
|
|
|
|
- |
1.0% |
1.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
|
Revenues |
USD 000s |
|
|
|
|
44 000.0 |
43 780.0 |
43 779.7 |
43 889.2 |
44 218.9 |
44 551.1 |
44 885.8 |
45 223.0 |
45 562.7 |
45 905.0 |
46 249.9 |
46 597.3 |
46 947.4 |
47 300.1 |
47 655.4 |
48 013.4 |
48 374.1 |
48 737.5 |
49 103.7 |
49 472.6 |
|
Annual Growth Rate |
% per annum |
|
|
|
|
|
(2.0%) |
(0.0%) |
1.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
COGS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Raw Materials |
USD 000s |
|
|
|
|
12 000.0 |
14 009.6 |
13 133.9 |
13 166.8 |
13 265.7 |
13 365.3 |
13 465.7 |
13 566.9 |
13 668.8 |
13 771.5 |
13 875.0 |
13 979.2 |
14 084.2 |
14 190.0 |
14 296.6 |
14 404.0 |
14 512.2 |
14 621.3 |
14 731.1 |
14 841.8 |
|
Raw Materials / Revenue |
% |
|
|
|
|
27.3% |
32.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% |
|
Personnel |
USD 000s |
|
|
|
|
9 000.0 |
9 193.8 |
9 193.7 |
8 777.8 |
8 843.8 |
8 910.2 |
8 977.2 |
9 044.6 |
9 112.5 |
9 181.0 |
9 250.0 |
9 319.5 |
9 389.5 |
9 460.0 |
9 531.1 |
9 602.7 |
9 674.8 |
9 747.5 |
9 820.7 |
9 894.5 |
|
Personnel / Revenue |
% |
|
|
|
|
20.5% |
21.0% |
21.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% |
|
Fuel & Utilities |
USD 000s |
|
|
|
|
2 000.0 |
1 970.1 |
1 970.1 |
1 975.0 |
1 989.9 |
2 004.8 |
2 019.9 |
2 035.0 |
2 050.3 |
2 065.7 |
2 081.2 |
2 096.9 |
2 112.6 |
2 128.5 |
2 144.5 |
2 160.6 |
2 176.8 |
2 193.2 |
2 209.7 |
2 226.3 |
|
Fuel & Utilities / Revenue |
% |
|
|
|
|
4.5% |
4.5% |
4.5% |
4.5% |
4.5% |
4.5% |
4.5% |
4.5% |
4.5% |
4.5% |
4.5% |
4.5% |
4.5% |
4.5% |
4.5% |
4.5% |
4.5% |
4.5% |
4.5% |
4.5% |
|
Leases |
USD 000s |
|
|
|
|
1 000.0 |
1 313.4 |
1 313.4 |
1 316.7 |
884.4 |
891.0 |
897.7 |
904.5 |
911.3 |
918.1 |
925.0 |
931.9 |
938.9 |
946.0 |
953.1 |
960.3 |
967.5 |
974.8 |
982.1 |
989.5 |
|
Annual Growth Rate |
% per annum |
|
|
|
|
|
3.0% |
3.0% |
3.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
|
Total COGS |
USD 000s |
|
|
|
|
24 000.0 |
26 486.9 |
25 611.1 |
25 236.3 |
24 983.7 |
25 171.4 |
25 360.5 |
25 551.0 |
25 742.9 |
25 936.3 |
26 131.2 |
26 327.5 |
26 525.3 |
26 724.5 |
26 925.3 |
27 127.6 |
27 331.4 |
27 536.7 |
27 743.6 |
27 952.0 |
|
Product Gross Margin |
USD 000s |
|
|
|
|
20 000.0 |
17 293.1 |
18 168.6 |
18 652.9 |
19 235.2 |
19 379.7 |
19 525.3 |
19 672.0 |
19 819.8 |
19 968.7 |
20 118.7 |
20 269.8 |
20 422.1 |
20 575.5 |
20 730.1 |
20 885.8 |
21 042.7 |
21 200.8 |
21 360.1 |
21 520.6 |
|
Gross Margin |
% |
|
|
|
|
45.5% |
39.5% |
41.5% |
42.5% |
43.5% |
43.5% |
43.5% |
43.5% |
43.5% |
43.5% |
43.5% |
43.5% |
43.5% |
43.5% |
43.5% |
43.5% |
43.5% |
43.5% |
43.5% |
43.5% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Central Costs &
Overheads Operating Assumptions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sales & Marketing |
USD 000s |
|
|
|
|
4 000.0 |
4 378.0 |
4 378.0 |
4 388.9 |
4 421.9 |
4 455.1 |
4 488.6 |
4 522.3 |
4 556.3 |
4 590.5 |
4 625.0 |
4 659.7 |
4 694.7 |
4 730.0 |
4 765.5 |
4 801.3 |
4 837.4 |
4 873.8 |
4 910.4 |
4 947.3 |
|
Sales & Marketing / Revenue |
% |
|
|
|
|
9.1% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
10.0% |
|
Administration |
USD 000s |
|
|
|
|
3 000.0 |
3 022.5 |
3 045.2 |
3 068.0 |
3 091.0 |
3 114.2 |
3 137.6 |
3 161.1 |
3 184.8 |
3 208.7 |
3 232.7 |
3 257.0 |
3 281.4 |
3 306.0 |
3 330.8 |
3 355.8 |
3 381.0 |
3 406.3 |
3 431.9 |
3 457.6 |
|
Annual Growth Rate |
% |
|
|
|
|
|
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
3.0% |
|
Rent |
USD 000s |
|
|
|
|
2 000.0 |
2 020.0 |
2 040.2 |
2 060.6 |
2 081.2 |
2 102.0 |
2 123.0 |
2 144.3 |
2 165.7 |
2 187.4 |
2 209.2 |
2 231.3 |
2 253.7 |
2 276.2 |
2 298.9 |
2 321.9 |
2 345.2 |
2 368.6 |
2 392.3 |
2 416.2 |
|
Annual Growth Rate |
% |
|
|
|
|
|
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
4.0% |
|
Consulting |
USD 000s |
|
|
|
|
1 800.0 |
1 827.0 |
1 845.3 |
1 859.1 |
1 868.4 |
1 877.7 |
1 887.1 |
1 896.6 |
1 906.1 |
1 915.6 |
1 925.2 |
1 934.8 |
1 944.5 |
1 954.2 |
1 964.0 |
1 973.8 |
1 983.6 |
1 993.6 |
2 003.5 |
2 013.5 |
|
Annual Growth Rate |
% per annum |
|
|
|
|
|
6.0% |
4.0% |
3.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
2.0% |
|
Total Central Costs |
USD 000s |
|
|
|
|
10 800.0 |
11 247.5 |
11 308.6 |
11 376.6 |
11 462.5 |
11 549.1 |
11 636.3 |
11 724.2 |
11 812.8 |
11 902.1 |
11 992.1 |
12 082.9 |
12 174.3 |
12 266.4 |
12 359.3 |
12 452.9 |
12 547.2 |
12 642.3 |
12 738.1 |
12 834.6 |
|
Total EBITDA |
USD 000s |
|
|
|
|
9 200.0 |
6 045.6 |
6 860.0 |
7 276.3 |
7 772.7 |
7 830.6 |
7 889.0 |
7 947.8 |
8 006.9 |
8 066.5 |
8 126.6 |
8 187.0 |
8 247.8 |
8 309.1 |
8 370.8 |
8 433.0 |
8 495.6 |
8 558.6 |
8 622.0 |
8 685.9 |
|
EBITDA Margin |
% |
|
|
|
|
20.9% |
13.8% |
15.7% |
16.6% |
17.6% |
17.6% |
17.6% |
17.6% |
17.6% |
17.6% |
17.6% |
17.6% |
17.6% |
17.6% |
17.6% |
17.6% |
17.6% |
17.6% |
17.6% |
17.6% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
>> End of Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|