|
Navigation |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Manufacturing Model |
Îê |
|
|
|
|
|
|
|
Central Costs &
Overheads Operating Assumptions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Projected
Fiscal Period Ending |
|
|
(GBP in 000s, except otherwise stated) |
|
|
|
|
|
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 |
Mar.19 |
Jun.19 |
Sep.19 |
Dec.19 |
Mar.20 |
Jun.20 |
Sep.20 |
Dec.20 |
Mar.21 |
Jun.21 |
Sep.21 |
Dec.21 |
Mar.22 |
Jun.22 |
Sep.22 |
Dec.22 |
Mar.23 |
Jun.23 |
Sep.23 |
|
|
|
|
|
|
|
|
Revenue |
GBP 000s |
|
3 154.3 |
3 177.9 |
3 132.2 |
3 190.7 |
3 250.0 |
3 274.4 |
3 263.1 |
3 287.5 |
3 348.6 |
3 373.7 |
3 325.1 |
3 387.3 |
3 450.2 |
3 476.1 |
3 426.0 |
3 490.0 |
3 554.9 |
3 581.5 |
3 529.9 |
3 595.9 |
3 662.7 |
3 690.2 |
3 677.4 |
3 705.0 |
3 773.8 |
3 802.1 |
3 747.4 |
3 817.4 |
3 888.3 |
3 917.5 |
3 861.1 |
3 933.2 |
4 006.3 |
4 036.3 |
3 978.2 |
4 052.6 |
4 127.8 |
|
|
Implied Growth Rate |
% per annum |
|
|
3.0% |
(5.8%) |
7.5% |
7.4% |
3.0% |
(1.4%) |
3.0% |
7.4% |
3.0% |
(5.8%) |
7.5% |
7.4% |
3.0% |
(5.8%) |
7.5% |
7.4% |
3.0% |
(5.8%) |
7.5% |
7.4% |
3.0% |
(1.4%) |
3.0% |
7.4% |
3.0% |
(5.8%) |
7.5% |
7.4% |
3.0% |
(5.8%) |
7.5% |
7.4% |
3.0% |
(5.8%) |
7.5% |
7.4% |
|
|
COGS |
GBP 000s |
|
809.6 |
815.7 |
803.9 |
819.0 |
834.2 |
840.4 |
837.5 |
843.8 |
859.5 |
865.9 |
853.5 |
869.4 |
885.6 |
892.2 |
879.3 |
895.8 |
912.4 |
919.3 |
906.0 |
923.0 |
940.1 |
947.2 |
943.9 |
951.0 |
968.6 |
975.9 |
961.8 |
979.8 |
998.0 |
1 005.5 |
991.0 |
1 009.5 |
1 028.3 |
1 036.0 |
1 021.1 |
1 040.2 |
1 059.5 |
|
|
|
|
|
|
|
|
Central Costs |
|
|
|
|
|
Sales & Marketing |
GBP 000s |
driver ► |
|
4 000.0 |
4 060.0 |
4 120.9 |
4 182.7 |
4 245.5 |
4 309.1 |
4 373.8 |
4 439.4 |
4 506.0 |
4 573.6 |
4 642.2 |
4 711.8 |
4 782.5 |
4 854.2 |
4 927.0 |
5 000.9 |
5 075.9 |
5 152.1 |
5 229.4 |
5 307.8 |
5 387.4 |
5 468.2 |
5 550.3 |
5 633.5 |
5 718.0 |
5 803.8 |
5 890.8 |
5 979.2 |
6 068.9 |
6 159.9 |
6 252.3 |
6 346.1 |
6 441.3 |
6 537.9 |
6 636.0 |
6 735.5 |
6 836.6 |
|
|
Annual Growth Rate |
% per annum |
driver ► |
|
|
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% |
|
|
|
|
|
|
|
|
Administration |
GBP 000s |
driver ► |
|
3 000.0 |
3 045.0 |
3 090.7 |
3 137.0 |
3 184.1 |
3 231.9 |
3 280.3 |
3 329.5 |
3 379.5 |
3 430.2 |
3 481.6 |
3 533.8 |
3 586.9 |
3 640.7 |
3 695.3 |
3 750.7 |
3 807.0 |
3 864.1 |
3 922.0 |
3 980.9 |
4 040.6 |
4 101.2 |
4 162.7 |
4 225.1 |
4 288.5 |
4 352.8 |
4 418.1 |
4 484.4 |
4 551.7 |
4 619.9 |
4 689.2 |
4 759.6 |
4 831.0 |
4 903.4 |
4 977.0 |
5 051.6 |
5 127.4 |
|
|
Annual Growth Rate |
% per annum |
driver ► |
|
|
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% |
|
|
|
|
|
|
|
|
Rent & Leases |
GBP 000s |
driver ► |
|
2 000.0 |
2 025.0 |
2 050.3 |
2 075.9 |
2 101.9 |
2 128.2 |
2 154.8 |
2 181.7 |
2 209.0 |
2 236.6 |
2 264.5 |
2 292.8 |
2 321.5 |
2 350.5 |
2 379.9 |
2 409.7 |
2 439.8 |
2 470.3 |
2 501.2 |
2 532.4 |
2 564.1 |
2 596.1 |
2 628.6 |
2 661.4 |
2 694.7 |
2 728.4 |
2 762.5 |
2 797.0 |
2 832.0 |
2 867.4 |
2 903.2 |
2 939.5 |
2 976.3 |
3 013.5 |
3 051.1 |
3 089.3 |
3 127.9 |
|
|
Annual Growth Rate |
% per annum |
driver ► |
|
|
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% |
|
|
|
|
|
|
|
|
Consulting |
GBP 000s |
driver ► |
|
1 800.0 |
1 818.0 |
1 836.2 |
1 854.5 |
1 873.1 |
1 891.8 |
1 910.7 |
1 929.8 |
1 949.1 |
1 968.6 |
1 988.3 |
2 008.2 |
2 028.3 |
2 048.6 |
2 069.1 |
2 089.7 |
2 110.6 |
2 131.7 |
2 153.1 |
2 174.6 |
2 196.3 |
2 218.3 |
2 240.5 |
2 262.9 |
2 285.5 |
2 308.4 |
2 331.5 |
2 354.8 |
2 378.3 |
2 402.1 |
2 426.1 |
2 450.4 |
2 474.9 |
2 499.6 |
2 524.6 |
2 549.9 |
2 575.4 |
|
|
Annual Growth Rate |
% per annum |
driver ► |
|
|
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% |
|
|
|
|
|
|
|
|
|
Other CC |
GBP 000s |
driver ► |
|
1 000.0 |
1 007.5 |
1 015.1 |
1 022.7 |
1 030.3 |
1 038.1 |
1 045.9 |
1 053.7 |
1 061.6 |
1 069.6 |
1 077.6 |
1 085.7 |
1 093.8 |
1 102.0 |
1 110.3 |
1 118.6 |
1 127.0 |
1 135.4 |
1 144.0 |
1 152.5 |
1 161.2 |
1 169.9 |
1 178.7 |
1 187.5 |
1 196.4 |
1 205.4 |
1 214.4 |
1 223.5 |
1 232.7 |
1 242.0 |
1 251.3 |
1 260.7 |
1 270.1 |
1 279.6 |
1 289.2 |
1 298.9 |
1 308.6 |
|
|
Annual Growth Rate |
% per annum |
driver ► |
|
|
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% |
|
|
|
|
|
|
|
|
Total Central Costs |
GBP 000s |
|
|
11 800.0 |
11 955.5 |
12 113.1 |
12 272.9 |
12 434.9 |
12 599.0 |
12 765.5 |
12 934.2 |
13 105.2 |
13 278.5 |
13 454.2 |
13 632.4 |
13 812.9 |
13 996.0 |
14 181.5 |
14 369.6 |
14 560.3 |
14 753.6 |
14 949.6 |
15 148.2 |
15 349.6 |
15 553.7 |
15 760.7 |
15 970.5 |
16 183.2 |
16 398.8 |
16 617.3 |
16 838.9 |
17 063.6 |
17 291.3 |
17 522.2 |
17 756.2 |
17 993.5 |
18 234.1 |
18 478.0 |
18 725.2 |
18 975.9 |
|
|
Total EBITDA |
GBP 000s |
|
|
(9
455.3) |
(9
593.2) |
(9
784.9) |
(9
901.1) |
(10
019.0) |
(10
165.1) |
(10
339.9) |
(10
490.4) |
(10
616.1) |
(10
770.7) |
(10
982.6) |
(11
114.5) |
(11
248.3) |
(11
412.1) |
(11
634.9) |
(11
775.4) |
(11
917.9) |
(12
091.4) |
(12
325.7) |
(12
475.2) |
(12
627.0) |
(12
810.7) |
(13
027.1) |
(13
216.4) |
(13
378.0) |
(13
572.5) |
(13
831.8) |
(14
001.3) |
(14
173.3) |
(14
379.3) |
(14
652.1) |
(14
832.5) |
(15
015.5) |
(15
233.8) |
(15
520.9) |
(15
712.8) |
(15
907.5) |
|
|
EBITDA Margin |
% |
|
|
(299.8%) |
(301.9%) |
(312.4%) |
(310.3%) |
(308.3%) |
(310.4%) |
(316.9%) |
(319.1%) |
(317.0%) |
(319.3%) |
(330.3%) |
(328.1%) |
(326.0%) |
(328.3%) |
(339.6%) |
(337.4%) |
(335.3%) |
(337.6%) |
(349.2%) |
(346.9%) |
(344.7%) |
(347.2%) |
(354.2%) |
(356.7%) |
(354.5%) |
(357.0%) |
(369.1%) |
(366.8%) |
(364.5%) |
(367.1%) |
(379.5%) |
(377.1%) |
(374.8%) |
(377.4%) |
(390.1%) |
(387.7%) |
(385.4%) |
|
|
|
>> End of Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|