|
Navigation |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Base Model |
Îê |
|
|
|
|
|
Product_C 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 |
|
300.0 |
302.5 |
305.0 |
307.6 |
310.1 |
312.7 |
315.3 |
317.9 |
320.6 |
323.3 |
326.0 |
328.7 |
331.4 |
334.2 |
337.0 |
339.8 |
342.6 |
345.5 |
348.3 |
351.2 |
354.2 |
357.1 |
360.1 |
363.1 |
366.1 |
369.2 |
372.2 |
375.3 |
378.5 |
381.6 |
384.8 |
388.0 |
391.2 |
394.5 |
397.8 |
401.1 |
404.5 |
|
|
Growth Rate |
% per annum |
|
|
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% |
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% |
|
|
|
|
|
|
|
|
|
|
Average Price |
GBP |
|
80.0 |
80.3 |
80.7 |
81.0 |
81.3 |
81.7 |
82.0 |
82.4 |
82.7 |
83.1 |
83.4 |
83.7 |
84.1 |
84.4 |
84.8 |
85.1 |
85.5 |
85.9 |
86.2 |
86.6 |
86.9 |
87.3 |
87.7 |
88.0 |
88.4 |
88.8 |
89.1 |
89.5 |
89.9 |
90.3 |
90.6 |
91.0 |
91.4 |
91.8 |
92.1 |
92.5 |
92.9 |
|
|
Growth Rate |
% per annum |
|
|
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
5.0% |
|
|
Revenues |
GBP 000s |
|
24 000.0 |
24 300.8 |
24 605.4 |
24 913.9 |
25 226.1 |
25 542.4 |
25 862.5 |
26 186.7 |
26 514.9 |
26 847.3 |
27 183.8 |
27 524.6 |
27 869.6 |
28 218.9 |
28 572.6 |
28 930.8 |
29 293.4 |
29 660.6 |
30 032.4 |
30 408.8 |
30 790.0 |
31 175.9 |
31 566.7 |
31 962.4 |
32 363.1 |
32 768.7 |
33 179.5 |
33 595.4 |
34 016.5 |
34 442.8 |
34 874.6 |
35 311.7 |
35 754.3 |
36 202.5 |
36 656.3 |
37 115.8 |
37 581.0 |
|
|
Growth Rate |
% per annum |
|
|
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
15.0% |
|
|
|
|
|
|
|
|
COGS |
|
|
|
|
|
Raw Materials |
GBP 000s |
|
10 000.0 |
9 720.3 |
9 842.2 |
9 965.5 |
10 090.5 |
10 216.9 |
10 345.0 |
10 474.7 |
10 606.0 |
10 738.9 |
10 873.5 |
11 009.8 |
11 147.8 |
11 287.6 |
11 429.1 |
11 572.3 |
11 717.4 |
11 864.2 |
12 013.0 |
12 163.5 |
12 316.0 |
12 470.4 |
12 626.7 |
12 785.0 |
12 945.2 |
13 107.5 |
13 271.8 |
13 438.1 |
13 606.6 |
13 777.1 |
13 949.8 |
14 124.7 |
14 301.7 |
14 481.0 |
14 662.5 |
14 846.3 |
15 032.4 |
|
|
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 |
|
6 000.0 |
6 075.2 |
6 151.4 |
6 228.5 |
6 306.5 |
6 385.6 |
6 465.6 |
6 546.7 |
6 628.7 |
6 711.8 |
6 796.0 |
6 881.1 |
6 967.4 |
7 054.7 |
7 143.2 |
7 232.7 |
7 323.4 |
7 415.2 |
7 508.1 |
7 602.2 |
7 697.5 |
7 794.0 |
7 891.7 |
7 990.6 |
8 090.8 |
8 192.2 |
8 294.9 |
8 398.8 |
8 504.1 |
8 610.7 |
8 718.6 |
8 827.9 |
8 938.6 |
9 050.6 |
9 164.1 |
9 278.9 |
9 395.3 |
|
|
Personnel / Revenue |
% |
|
|
|
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
25.0% |
|
|
|
|
|
|
|
|
|
|
Fuel & Utilities |
GBP 000s |
|
2 000.0 |
1 944.1 |
1 968.4 |
1 993.1 |
2 018.1 |
2 043.4 |
2 069.0 |
2 094.9 |
2 121.2 |
2 147.8 |
2 174.7 |
2 202.0 |
2 229.6 |
2 257.5 |
2 285.8 |
2 314.5 |
2 343.5 |
2 372.8 |
2 402.6 |
2 432.7 |
2 463.2 |
2 494.1 |
2 525.3 |
2 557.0 |
2 589.0 |
2 621.5 |
2 654.4 |
2 687.6 |
2 721.3 |
2 755.4 |
2 790.0 |
2 824.9 |
2 860.3 |
2 896.2 |
2 932.5 |
2 969.3 |
3 006.5 |
|
|
Fuel & Utilities / Revenue |
% |
|
|
|
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
8.0% |
|
|
|
|
|
|
|
|
|
|
Rent & Leases |
GBP 000s |
|
1 500.0 |
1 458.1 |
1 476.3 |
1 494.8 |
1 513.6 |
1 532.5 |
1 551.8 |
1 571.2 |
1 590.9 |
1 610.8 |
1 631.0 |
1 651.5 |
1 672.2 |
1 693.1 |
1 714.4 |
1 735.8 |
1 757.6 |
1 779.6 |
1 801.9 |
1 824.5 |
1 847.4 |
1 870.6 |
1 894.0 |
1 917.7 |
1 941.8 |
1 966.1 |
1 990.8 |
2 015.7 |
2 041.0 |
2 066.6 |
2 092.5 |
2 118.7 |
2 145.3 |
2 172.2 |
2 199.4 |
2 226.9 |
2 254.9 |
|
|
Rent & Leases / Revenue |
% |
|
|
|
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
6.0% |
|
|
|
|
|
|
|
|
|
|
Other COGS |
GBP 000s |
|
500.0 |
486.0 |
492.1 |
498.3 |
504.5 |
510.8 |
517.3 |
523.7 |
530.3 |
536.9 |
543.7 |
550.5 |
557.4 |
564.4 |
571.5 |
578.6 |
585.9 |
593.2 |
600.6 |
608.2 |
615.8 |
623.5 |
631.3 |
639.2 |
647.3 |
655.4 |
663.6 |
671.9 |
680.3 |
688.9 |
697.5 |
706.2 |
715.1 |
724.1 |
733.1 |
742.3 |
751.6 |
|
|
Other COGS / 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% |
|
|
|
|
|
|
|
|
|
|
Total COGS |
GBP 000s |
|
|
20 000.0 |
19 683.7 |
19 930.4 |
20 180.2 |
20 433.2 |
20 689.3 |
20 948.6 |
21 211.2 |
21 477.1 |
21 746.3 |
22 018.9 |
22 294.9 |
22 574.4 |
22 857.3 |
23 143.8 |
23 433.9 |
23 727.7 |
24 025.1 |
24 326.2 |
24 631.2 |
24 939.9 |
25 252.5 |
25 569.1 |
25 889.6 |
26 214.1 |
26 542.7 |
26 875.4 |
27 212.2 |
27 553.3 |
27 898.7 |
28 248.4 |
28 602.5 |
28 961.0 |
29 324.0 |
29 691.6 |
30 063.8 |
30 440.6 |
|
|
Product Gross Margin |
GBP 000s |
|
|
4 000.0 |
4 617.2 |
4 675.0 |
4 733.6 |
4 793.0 |
4 853.0 |
4 913.9 |
4 975.5 |
5 037.8 |
5 101.0 |
5 164.9 |
5 229.7 |
5 295.2 |
5 361.6 |
5 428.8 |
5 496.8 |
5 565.7 |
5 635.5 |
5 706.2 |
5 777.7 |
5 850.1 |
5 923.4 |
5 997.7 |
6 072.9 |
6 149.0 |
6 226.1 |
6 304.1 |
6 383.1 |
6 463.1 |
6 544.1 |
6 626.2 |
6 709.2 |
6 793.3 |
6 878.5 |
6 964.7 |
7 052.0 |
7 140.4 |
|
|
Gross Margin |
% |
|
|
16.7% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
19.0% |
|
|
|
>> End of Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|