|
Navigation |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Manufacturing Model |
Îê |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Working Capital |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Projected
Fiscal Period Ending |
|
|
(GBP in 000s, except otherwise stated) |
|
|
|
|
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 |
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 |
|
|
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 |
|
|
CC & Overheads |
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Working Capital |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Debtors - Days of Revenue |
Days |
|
driver ► |
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 |
30.0 |
|
|
Inventory - Days of COGS |
Days |
|
driver ► |
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 |
40.0 |
|
|
Raw Materials - Days of COGS |
Days |
|
driver ► |
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 |
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 |
|
|
Creditors - Days of Total Costs |
Days |
|
driver ► |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
|
|
Changes in Other CA |
GBP 000s |
|
driver ► |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
Changes in Other CL |
GBP 000s |
|
driver ► |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Debtors |
GBP 000s |
|
|
|
9 000.0 |
1 037.0 |
1 044.8 |
1 029.8 |
1 049.0 |
1 068.5 |
1 076.5 |
1 072.8 |
1 080.8 |
1 100.9 |
1 109.2 |
1 093.2 |
1 113.6 |
1 134.3 |
1 142.8 |
1 126.4 |
1 147.4 |
1 168.7 |
1 177.5 |
1 160.5 |
1 182.2 |
1 204.2 |
1 213.2 |
1 209.0 |
1 218.1 |
1 240.7 |
1 250.0 |
1 232.0 |
1 255.0 |
1 278.4 |
1 287.9 |
1 269.4 |
1 293.1 |
1 317.1 |
1 327.0 |
1 307.9 |
1 332.4 |
1 357.1 |
|
|
Inventory |
GBP 000s |
|
|
|
11 000.0 |
354.9 |
357.6 |
352.4 |
359.0 |
365.7 |
368.4 |
367.1 |
369.9 |
376.8 |
379.6 |
374.1 |
381.1 |
388.2 |
391.1 |
385.5 |
392.7 |
400.0 |
403.0 |
397.2 |
404.6 |
412.1 |
415.2 |
413.8 |
416.9 |
424.6 |
427.8 |
421.6 |
429.5 |
437.5 |
440.8 |
434.4 |
442.5 |
450.8 |
454.1 |
447.6 |
456.0 |
464.4 |
|
|
Raw Materials |
GBP 000s |
|
|
|
1 000.0 |
177.4 |
178.8 |
176.2 |
179.5 |
182.8 |
184.2 |
183.6 |
184.9 |
188.4 |
189.8 |
187.1 |
190.6 |
194.1 |
195.5 |
192.7 |
196.3 |
200.0 |
201.5 |
198.6 |
202.3 |
206.0 |
207.6 |
206.9 |
208.4 |
212.3 |
213.9 |
210.8 |
214.8 |
218.7 |
220.4 |
217.2 |
221.3 |
225.4 |
227.1 |
223.8 |
228.0 |
232.2 |
|
|
Creditors |
GBP 000s |
|
|
|
(15
000.0) |
(6
909.4) |
(6
997.9) |
(7
077.8) |
(7
173.6) |
(7
270.7) |
(7
364.1) |
(7
453.7) |
(7
549.6) |
(7
651.9) |
(7
750.4) |
(7
839.8) |
(7
946.2) |
(8
054.0) |
(8
157.9) |
(8
252.5) |
(8
364.6) |
(8
478.2) |
(8
587.9) |
(8
688.0) |
(8
806.1) |
(8
925.9) |
(9
041.6) |
(9
153.2) |
(9
272.0) |
(9
398.2) |
(9
520.4) |
(9
632.4) |
(9
763.7) |
(9
896.8) |
(10
025.6) |
(10
144.2) |
(10
282.6) |
(10
422.9) |
(10
559.0) |
(10
684.4) |
(10
830.4) |
(10
978.3) |
|
|
Other CA |
GBP 000s |
|
|
|
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
|
|
Other CL |
GBP 000s |
|
|
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
(100.0)
|
|
|
|
>> End of Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|