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