|
Navigation |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Base Model |
Îê |
|
|
|
|
|
Product_B 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 |
|
400.0 |
401.7 |
403.3 |
405.0 |
406.7 |
408.4 |
410.1 |
411.8 |
413.5 |
415.3 |
417.0 |
418.7 |
420.5 |
422.2 |
424.0 |
425.7 |
427.5 |
429.3 |
431.1 |
432.9 |
434.7 |
436.5 |
438.3 |
440.1 |
442.0 |
443.8 |
445.7 |
447.5 |
449.4 |
451.3 |
453.1 |
455.0 |
456.9 |
458.8 |
460.7 |
462.7 |
464.6 |
|
|
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% |
|
|
|
|
|
|
|
|
|
|
Average Price |
GBP |
|
55.2 |
55.4 |
55.7 |
55.9 |
56.1 |
56.4 |
56.6 |
56.8 |
57.1 |
57.3 |
57.5 |
57.8 |
58.0 |
58.3 |
58.5 |
58.8 |
59.0 |
59.2 |
59.5 |
59.7 |
60.0 |
60.2 |
60.5 |
60.7 |
61.0 |
61.2 |
61.5 |
61.8 |
62.0 |
62.3 |
62.5 |
62.8 |
63.1 |
63.3 |
63.6 |
63.8 |
64.1 |
|
|
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 |
|
22 080.0 |
22 264.4 |
22 450.3 |
22 637.8 |
22 826.8 |
23 017.4 |
23 209.7 |
23 403.5 |
23 598.9 |
23 796.0 |
23 994.7 |
24 195.1 |
24 397.1 |
24 600.8 |
24 806.3 |
25 013.4 |
25 222.3 |
25 432.9 |
25 645.3 |
25 859.5 |
26 075.4 |
26 293.2 |
26 512.7 |
26 734.1 |
26 957.4 |
27 182.5 |
27 409.5 |
27 638.4 |
27 869.2 |
28 101.9 |
28 336.6 |
28 573.2 |
28 811.8 |
29 052.4 |
29 295.0 |
29 539.6 |
29 786.3 |
|
|
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% |
|
|
|
|
|
|
|
|
COGS |
|
|
|
|
|
Raw Materials |
GBP 000s |
|
18 000.0 |
10 019.0 |
10 102.6 |
10 187.0 |
10 272.1 |
10 357.8 |
10 444.3 |
10 531.6 |
10 619.5 |
10 708.2 |
10 797.6 |
10 887.8 |
10 978.7 |
11 070.4 |
11 162.8 |
11 256.0 |
11 350.0 |
11 444.8 |
11 540.4 |
11 636.8 |
11 733.9 |
11 831.9 |
11 930.7 |
12 030.4 |
12 130.8 |
12 232.1 |
12 334.3 |
12 437.3 |
12 541.1 |
12 645.9 |
12 751.5 |
12 857.9 |
12 965.3 |
13 073.6 |
13 182.8 |
13 292.8 |
13 403.8 |
|
|
Raw Materials / Revenue |
% |
|
|
|
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
45.0% |
|
|
|
|
|
|
|
|
|
|
Personnel |
GBP 000s |
|
10 000.0 |
7 792.5 |
7 857.6 |
7 923.2 |
7 989.4 |
8 056.1 |
8 123.4 |
8 191.2 |
8 259.6 |
8 328.6 |
8 398.1 |
8 468.3 |
8 539.0 |
8 610.3 |
8 682.2 |
8 754.7 |
8 827.8 |
8 901.5 |
8 975.9 |
9 050.8 |
9 126.4 |
9 202.6 |
9 279.5 |
9 356.9 |
9 435.1 |
9 513.9 |
9 593.3 |
9 673.4 |
9 754.2 |
9 835.7 |
9 917.8 |
10 000.6 |
10 084.1 |
10 168.3 |
10 253.3 |
10 338.9 |
10 425.2 |
|
|
Personnel / Revenue |
% |
|
|
|
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
35.0% |
|
|
|
|
|
|
|
|
|
|
Fuel & Utilities |
GBP 000s |
|
2 000.0 |
1 113.2 |
1 122.5 |
1 131.9 |
1 141.3 |
1 150.9 |
1 160.5 |
1 170.2 |
1 179.9 |
1 189.8 |
1 199.7 |
1 209.8 |
1 219.9 |
1 230.0 |
1 240.3 |
1 250.7 |
1 261.1 |
1 271.6 |
1 282.3 |
1 293.0 |
1 303.8 |
1 314.7 |
1 325.6 |
1 336.7 |
1 347.9 |
1 359.1 |
1 370.5 |
1 381.9 |
1 393.5 |
1 405.1 |
1 416.8 |
1 428.7 |
1 440.6 |
1 452.6 |
1 464.8 |
1 477.0 |
1 489.3 |
|
|
Fuel & Utilities / Revenue |
% |
|
|
|
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% |
|
|
|
|
|
|
|
|
|
|
Rent & Leases |
GBP 000s |
|
2 000.0 |
1 113.2 |
1 122.5 |
1 131.9 |
1 141.3 |
1 150.9 |
1 160.5 |
1 170.2 |
1 179.9 |
1 189.8 |
1 199.7 |
1 209.8 |
1 219.9 |
1 230.0 |
1 240.3 |
1 250.7 |
1 261.1 |
1 271.6 |
1 282.3 |
1 293.0 |
1 303.8 |
1 314.7 |
1 325.6 |
1 336.7 |
1 347.9 |
1 359.1 |
1 370.5 |
1 381.9 |
1 393.5 |
1 405.1 |
1 416.8 |
1 428.7 |
1 440.6 |
1 452.6 |
1 464.8 |
1 477.0 |
1 489.3 |
|
|
Rent & Leases / Revenue |
% |
|
|
|
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% |
|
|
|
|
|
|
|
|
|
|
Other COGS |
GBP 000s |
|
500.0 |
334.0 |
336.8 |
339.6 |
342.4 |
345.3 |
348.1 |
351.1 |
354.0 |
356.9 |
359.9 |
362.9 |
366.0 |
369.0 |
372.1 |
375.2 |
378.3 |
381.5 |
384.7 |
387.9 |
391.1 |
394.4 |
397.7 |
401.0 |
404.4 |
407.7 |
411.1 |
414.6 |
418.0 |
421.5 |
425.0 |
428.6 |
432.2 |
435.8 |
439.4 |
443.1 |
446.8 |
|
|
Other COGS / Revenue |
% |
|
|
|
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
1.5% |
|
|
|
|
|
|
|
|
|
|
Total COGS |
GBP 000s |
|
|
32 500.0 |
20 371.9 |
20 542.0 |
20 713.6 |
20 886.5 |
21 061.0 |
21 236.8 |
21 414.2 |
21 593.0 |
21 773.3 |
21 955.1 |
22 138.5 |
22 323.4 |
22 509.8 |
22 697.7 |
22 887.3 |
23 078.4 |
23 271.1 |
23 465.5 |
23 661.4 |
23 859.0 |
24 058.2 |
24 259.1 |
24 461.7 |
24 666.0 |
24 872.0 |
25 079.7 |
25 289.1 |
25 500.3 |
25 713.2 |
25 928.0 |
26 144.5 |
26 362.8 |
26 582.9 |
26 804.9 |
27 028.8 |
27 254.5 |
|
|
Product Gross Margin |
GBP 000s |
|
|
(10
420.0) |
1 892.5 |
1 908.3 |
1 924.2 |
1 940.3 |
1 956.5 |
1 972.8 |
1 989.3 |
2 005.9 |
2 022.7 |
2 039.5 |
2 056.6 |
2 073.8 |
2 091.1 |
2 108.5 |
2 126.1 |
2 143.9 |
2 161.8 |
2 179.9 |
2 198.1 |
2 216.4 |
2 234.9 |
2 253.6 |
2 272.4 |
2 291.4 |
2 310.5 |
2 329.8 |
2 349.3 |
2 368.9 |
2 388.7 |
2 408.6 |
2 428.7 |
2 449.0 |
2 469.5 |
2 490.1 |
2 510.9 |
2 531.8 |
|
|
Gross Margin |
% |
|
|
(47.2%) |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
8.5% |
|
|
|
>> End of Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|