|
Navigation |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Base Model |
Îê |
|
|
|
|
|
Product_A Operating
Assumtions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Projected
Fiscal Year Ending |
|
|
(GBP in 000s , except otherwise stated) |
|
|
|
|
|
Sep.14 |
Oct.14 |
Nov.14 |
Dec.14 |
Jan.15 |
Feb.15 |
Mar.15 |
Apr.15 |
May.15 |
Jun.15 |
Jul.15 |
Aug.15 |
Sep.15 |
Oct.15 |
Nov.15 |
Dec.15 |
Jan.16 |
Feb.16 |
Mar.16 |
Apr.16 |
May.16 |
Jun.16 |
Jul.16 |
Aug.16 |
Sep.16 |
Oct.16 |
Nov.16 |
Dec.16 |
Jan.17 |
Feb.17 |
Mar.17 |
Apr.17 |
May.17 |
Jun.17 |
Jul.17 |
Aug.17 |
Sep.17 |
|
|
|
|
Volume |
000s |
|
800.0 |
802.7 |
805.3 |
808.0 |
810.7 |
813.4 |
816.1 |
818.9 |
821.6 |
824.3 |
827.1 |
829.8 |
832.6 |
835.4 |
838.2 |
840.9 |
843.8 |
846.6 |
849.4 |
852.2 |
855.1 |
857.9 |
860.8 |
863.6 |
866.5 |
869.4 |
872.3 |
875.2 |
878.1 |
881.1 |
884.0 |
886.9 |
889.9 |
892.9 |
895.8 |
898.8 |
901.8 |
|
|
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% |
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% |
|
|
|
|
|
|
|
|
|
|
Average Price |
GBP |
|
55.2 |
55.3 |
55.5 |
55.6 |
55.8 |
55.9 |
56.0 |
56.2 |
56.3 |
56.5 |
56.6 |
56.7 |
56.9 |
57.0 |
57.2 |
57.3 |
57.4 |
57.6 |
57.7 |
57.9 |
58.0 |
58.2 |
58.3 |
58.5 |
58.6 |
58.8 |
58.9 |
59.0 |
59.2 |
59.3 |
59.5 |
59.6 |
59.8 |
59.9 |
60.1 |
60.2 |
60.4 |
|
|
Growth Rate |
% per annum |
|
|
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% |
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% |
|
|
Revenues |
GBP 000s |
|
44 160.0 |
44 418.0 |
44 677.4 |
44 938.4 |
45 200.9 |
45 465.0 |
45 730.6 |
45 997.7 |
46 266.4 |
46 536.7 |
46 808.6 |
47 082.0 |
47 357.0 |
47 633.7 |
47 911.9 |
48 191.8 |
48 473.3 |
48 756.5 |
49 041.3 |
49 327.8 |
49 616.0 |
49 905.8 |
50 197.3 |
50 490.6 |
50 785.5 |
51 082.2 |
51 380.6 |
51 680.8 |
51 982.7 |
52 286.3 |
52 591.8 |
52 899.0 |
53 208.0 |
53 518.8 |
53 831.5 |
54 145.9 |
54 462.2 |
|
|
Growth Rate |
% per annum |
|
|
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
7.0% |
|
|
|
|
|
|
|
|
COGS |
|
|
|
|
|
Raw Materials |
GBP 000s |
|
18 000.0 |
17 767.2 |
17 871.0 |
17 975.4 |
18 080.4 |
18 186.0 |
18 292.2 |
18 399.1 |
18 506.6 |
18 614.7 |
18 723.4 |
18 832.8 |
18 942.8 |
19 053.5 |
19 164.8 |
19 276.7 |
19 389.3 |
19 502.6 |
19 616.5 |
19 731.1 |
19 846.4 |
19 962.3 |
20 078.9 |
20 196.2 |
20 314.2 |
20 432.9 |
20 552.2 |
20 672.3 |
20 793.1 |
20 914.5 |
21 036.7 |
21 159.6 |
21 283.2 |
21 407.5 |
21 532.6 |
21 658.4 |
21 784.9 |
|
|
Raw Materials / Revenue |
% |
|
|
|
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
40.0% |
|
|
|
|
|
|
|
|
|
|
Personnel |
GBP 000s |
|
13 000.0 |
13 325.4 |
13 403.2 |
13 481.5 |
13 560.3 |
13 639.5 |
13 719.2 |
13 799.3 |
13 879.9 |
13 961.0 |
14 042.6 |
14 124.6 |
14 207.1 |
14 290.1 |
14 373.6 |
14 457.5 |
14 542.0 |
14 627.0 |
14 712.4 |
14 798.3 |
14 884.8 |
14 971.7 |
15 059.2 |
15 147.2 |
15 235.7 |
15 324.7 |
15 414.2 |
15 504.2 |
15 594.8 |
15 685.9 |
15 777.5 |
15 869.7 |
15 962.4 |
16 055.6 |
16 149.4 |
16 243.8 |
16 338.7 |
|
|
Personnel / Revenue |
% |
|
|
|
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% |
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% |
|
|
|
|
|
|
|
|
|
|
Fuel & Utilities |
GBP 000s |
|
2 000.0 |
1 998.8 |
2 010.5 |
2 022.2 |
2 034.0 |
2 045.9 |
2 057.9 |
2 069.9 |
2 082.0 |
2 094.2 |
2 106.4 |
2 118.7 |
2 131.1 |
2 143.5 |
2 156.0 |
2 168.6 |
2 181.3 |
2 194.0 |
2 206.9 |
2 219.8 |
2 232.7 |
2 245.8 |
2 258.9 |
2 272.1 |
2 285.3 |
2 298.7 |
2 312.1 |
2 325.6 |
2 339.2 |
2 352.9 |
2 366.6 |
2 380.5 |
2 394.4 |
2 408.3 |
2 422.4 |
2 436.6 |
2 450.8 |
|
|
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% |
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% |
|
|
|
|
|
|
|
|
|
|
Rent & Leases |
GBP 000s |
|
1 000.0 |
888.4 |
893.5 |
898.8 |
904.0 |
909.3 |
914.6 |
920.0 |
925.3 |
930.7 |
936.2 |
941.6 |
947.1 |
952.7 |
958.2 |
963.8 |
969.5 |
975.1 |
980.8 |
986.6 |
992.3 |
998.1 |
1 003.9 |
1 009.8 |
1 015.7 |
1 021.6 |
1 027.6 |
1 033.6 |
1 039.7 |
1 045.7 |
1 051.8 |
1 058.0 |
1 064.2 |
1 070.4 |
1 076.6 |
1 082.9 |
1 089.2 |
|
|
Rent & Leases / Revenue |
% |
|
|
|
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% |
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% |
|
|
|
|
|
|
|
|
|
|
Other COGS |
GBP 000s |
|
500.0 |
444.2 |
446.8 |
449.4 |
452.0 |
454.6 |
457.3 |
460.0 |
462.7 |
465.4 |
468.1 |
470.8 |
473.6 |
476.3 |
479.1 |
481.9 |
484.7 |
487.6 |
490.4 |
493.3 |
496.2 |
499.1 |
502.0 |
504.9 |
507.9 |
510.8 |
513.8 |
516.8 |
519.8 |
522.9 |
525.9 |
529.0 |
532.1 |
535.2 |
538.3 |
541.5 |
544.6 |
|
|
Other COGS / Revenue |
% |
|
|
|
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% |
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% |
1.0% |
1.0% |
|
|
|
|
|
|
|
|
|
|
Total COGS |
GBP 000s |
|
|
34 500.0 |
34 423.9 |
34 625.0 |
34 827.3 |
35 030.7 |
35 235.4 |
35 441.2 |
35 648.2 |
35 856.5 |
36 065.9 |
36 276.6 |
36 488.6 |
36 701.7 |
36 916.1 |
37 131.8 |
37 348.7 |
37 566.8 |
37 786.3 |
38 007.0 |
38 229.1 |
38 452.4 |
38 677.0 |
38 902.9 |
39 130.2 |
39 358.8 |
39 588.7 |
39 820.0 |
40 052.6 |
40 286.6 |
40 521.9 |
40 758.6 |
40 996.7 |
41 236.2 |
41 477.1 |
41 719.4 |
41 963.1 |
42 208.2 |
|
|
Product Gross Margin |
GBP 000s |
|
|
9 660.0 |
9 994.0 |
10 052.4 |
10 111.1 |
10 170.2 |
10 229.6 |
10 289.4 |
10 349.5 |
10 409.9 |
10 470.8 |
10 531.9 |
10 593.5 |
10 655.3 |
10 717.6 |
10 780.2 |
10 843.2 |
10 906.5 |
10 970.2 |
11 034.3 |
11 098.8 |
11 163.6 |
11 228.8 |
11 294.4 |
11 360.4 |
11 426.7 |
11 493.5 |
11 560.6 |
11 628.2 |
11 696.1 |
11 764.4 |
11 833.1 |
11 902.3 |
11 971.8 |
12 041.7 |
12 112.1 |
12 182.8 |
12 254.0 |
|
|
Gross Margin |
% |
|
|
21.9% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
22.5% |
|
|
|
>> End of Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|