|
Navigation |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Case Builder Model |
Îê |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Banking 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 |
804.0 |
808.0 |
812.1 |
816.1 |
820.2 |
824.3 |
828.4 |
832.6 |
836.7 |
840.9 |
845.1 |
849.3 |
853.6 |
857.9 |
862.1 |
866.5 |
870.8 |
875.1 |
879.5 |
|
Annual Growth Rate |
% per annum |
|
|
|
|
|
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% |
2.0% |
2.0% |
2.0% |
|
Average Price |
USD |
|
|
|
|
55.0 |
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 |
60.2 |
60.5 |
|
Annual Growth Rate |
% per annum |
|
|
|
|
|
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% |
2.0% |
2.0% |
2.0% |
|
Revenues |
USD 000s |
|
|
|
|
44 000.0 |
44 441.1 |
44 886.6 |
45 336.6 |
45 791.1 |
46 250.2 |
46 713.8 |
47 182.1 |
47 655.1 |
48 132.9 |
48 615.4 |
49 102.8 |
49 595.0 |
50 092.2 |
50 594.4 |
51 101.6 |
51 613.9 |
52 131.3 |
52 653.9 |
53 181.8 |
|
Annual Growth Rate |
% per annum |
|
|
|
|
|
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% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
COGS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Raw Materials |
USD 000s |
|
|
|
|
12 000.0 |
13 332.3 |
13 466.0 |
13 601.0 |
13 737.3 |
13 875.0 |
14 014.1 |
14 154.6 |
14 296.5 |
14 439.9 |
14 584.6 |
14 730.8 |
14 878.5 |
15 027.7 |
15 178.3 |
15 330.5 |
15 484.2 |
15 639.4 |
15 796.2 |
15 954.5 |
|
Raw Materials / Revenue |
% |
|
|
|
|
27.3% |
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% |
|
Personnel |
USD 000s |
|
|
|
|
9 000.0 |
8 888.2 |
8 977.3 |
9 067.3 |
9 158.2 |
9 250.0 |
9 342.8 |
9 436.4 |
9 531.0 |
9 626.6 |
9 723.1 |
9 820.6 |
9 919.0 |
10 018.4 |
10 118.9 |
10 220.3 |
10 322.8 |
10 426.3 |
10 530.8 |
10 636.4 |
|
Personnel / Revenue |
% |
|
|
|
|
20.5% |
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% |
|
Fuel & Utilities |
USD 000s |
|
|
|
|
2 000.0 |
1 999.8 |
2 019.9 |
2 040.1 |
2 060.6 |
2 081.3 |
2 102.1 |
2 123.2 |
2 144.5 |
2 166.0 |
2 187.7 |
2 209.6 |
2 231.8 |
2 254.1 |
2 276.7 |
2 299.6 |
2 322.6 |
2 345.9 |
2 369.4 |
2 393.2 |
|
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 |
888.8 |
897.7 |
906.7 |
915.8 |
925.0 |
934.3 |
943.6 |
953.1 |
962.7 |
972.3 |
982.1 |
991.9 |
1 001.8 |
1 011.9 |
1 022.0 |
1 032.3 |
1 042.6 |
1 053.1 |
1 063.6 |
|
Annual Growth Rate |
% per annum |
|
|
|
|
|
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% |
2.0% |
2.0% |
2.0% |
|
Total COGS |
USD 000s |
|
|
|
|
24 000.0 |
25 109.2 |
25 360.9 |
25 615.2 |
25 872.0 |
26 131.3 |
26 393.3 |
26 657.9 |
26 925.1 |
27 195.1 |
27 467.7 |
27 743.1 |
28 021.2 |
28 302.1 |
28 585.8 |
28 872.4 |
29 161.9 |
29 454.2 |
29 749.5 |
30 047.7 |
|
Product Gross Margin |
USD 000s |
|
|
|
|
20 000.0 |
19 331.9 |
19 525.7 |
19 721.4 |
19 919.1 |
20 118.8 |
20 320.5 |
20 524.2 |
20 730.0 |
20 937.8 |
21 147.7 |
21 359.7 |
21 573.8 |
21 790.1 |
22 008.6 |
22 229.2 |
22 452.0 |
22 677.1 |
22 904.5 |
23 134.1 |
|
Gross Margin |
% |
|
|
|
|
45.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% |
43.5% |
43.5% |
43.5% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Central Costs &
Overheads Operating Assumptions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sales & Marketing |
USD 000s |
|
|
|
|
4 000.0 |
3 999.7 |
4 039.8 |
4 080.3 |
4 121.2 |
4 162.5 |
4 204.2 |
4 246.4 |
4 289.0 |
4 332.0 |
4 375.4 |
4 419.2 |
4 463.6 |
4 508.3 |
4 553.5 |
4 599.1 |
4 645.3 |
4 691.8 |
4 738.9 |
4 786.4 |
|
Sales & Marketing / Revenue |
% |
|
|
|
|
9.1% |
9.0% |
9.0% |
9.0% |
9.0% |
9.0% |
9.0% |
9.0% |
9.0% |
9.0% |
9.0% |
9.0% |
9.0% |
9.0% |
9.0% |
9.0% |
9.0% |
9.0% |
9.0% |
9.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 809.0 |
1 818.0 |
1 827.1 |
1 836.3 |
1 845.5 |
1 854.7 |
1 864.0 |
1 873.3 |
1 882.6 |
1 892.1 |
1 901.5 |
1 911.0 |
1 920.6 |
1 930.2 |
1 939.8 |
1 949.5 |
1 959.3 |
1 969.1 |
1 978.9 |
|
Annual Growth Rate |
% per annum |
|
|
|
|
|
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% |
2.0% |
2.0% |
2.0% |
|
Total Central Costs |
USD 000s |
|
|
|
|
10 800.0 |
10 851.2 |
10 943.2 |
11 036.0 |
11 129.7 |
11 224.2 |
11 319.5 |
11 415.7 |
11 512.7 |
11 610.7 |
11 709.4 |
11 809.1 |
11 909.6 |
12 011.1 |
12 113.4 |
12 216.7 |
12 320.9 |
12 426.0 |
12 532.1 |
12 639.1 |
|
Total EBITDA |
USD 000s |
|
|
|
|
9 200.0 |
8 480.7 |
8 582.5 |
8 685.4 |
8 789.4 |
8 894.6 |
9 001.0 |
9 108.5 |
9 217.2 |
9 327.1 |
9 438.3 |
9 550.6 |
9 664.2 |
9 779.0 |
9 895.1 |
10 012.5 |
10 131.1 |
10 251.1 |
10 372.4 |
10 495.0 |
|
EBITDA Margin |
% |
|
|
|
|
20.9% |
19.1% |
19.1% |
19.2% |
19.2% |
19.2% |
19.3% |
19.3% |
19.3% |
19.4% |
19.4% |
19.5% |
19.5% |
19.5% |
19.6% |
19.6% |
19.6% |
19.7% |
19.7% |
19.7% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
>> End of Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|