| Navigation | Iterate Interest? | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Base Model | خي | No[1] | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Financial Schedules | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Income Statement Summary | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Projected Fiscal Year Ending | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| (GBP in 000s , except otherwise stated) | Aug.14 | 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 | |||||||||||||||||||||||||||||
| Revenues | GBP 000s | 90 240.0 | 90 983.2 | 91 733.2 | 92 490.1 | 93 253.9 | 94 024.8 | 94 802.8 | 95 587.9 | 96 380.3 | 97 180.0 | 97 987.1 | 98 801.6 | 99 623.7 | 100 453.4 | 101 290.8 | 102 136.0 | 102 989.1 | 103 850.0 | 104 719.0 | 105 596.1 | 106 481.4 | 107 374.9 | 108 276.8 | 109 187.1 | 110 106.0 | 111 033.4 | 111 969.5 | 112 914.5 | 113 868.3 | 114 831.1 | 115 802.9 | 116 783.9 | 117 774.1 | 118 773.7 | 119 782.8 | 120 801.4 | 121 829.6 | |||||||||||||||||||||||||||||
| COGS | GBP 000s | (87 000.0) | (74 479.5) | (75 097.5) | (75 721.1) | (76 350.5) | (76 985.6) | (77 626.7) | (78 273.6) | (78 926.6) | (79 585.6) | (80 250.7) | (80 921.9) | (81 599.4) | (82 283.2) | (82 973.3) | (83 669.9) | (84 372.9) | (85 082.5) | (85 798.7) | (86 521.6) | (87 251.3) | (87 987.8) | (88 731.1) | (89 481.5) | (90 238.9) | (91 003.3) | (91 775.0) | (92 553.9) | (93 340.2) | (94 133.8) | (94 935.0) | (95 743.7) | (96 560.0) | (97 384.1) | (98 215.9) | (99 055.6) | (99 903.3) | |||||||||||||||||||||||||||||
| Gross Margin | GBP 000s | 3 240.0 | 16 503.7 | 16 635.7 | 16 769.0 | 16 903.5 | 17 039.2 | 17 176.1 | 17 314.3 | 17 453.7 | 17 594.4 | 17 736.4 | 17 879.7 | 18 024.3 | 18 170.2 | 18 317.5 | 18 466.1 | 18 616.1 | 18 767.5 | 18 920.3 | 19 074.5 | 19 230.1 | 19 387.2 | 19 545.7 | 19 705.6 | 19 867.1 | 20 030.1 | 20 194.5 | 20 360.5 | 20 528.1 | 20 697.2 | 20 867.9 | 21 040.2 | 21 214.1 | 21 389.7 | 21 566.9 | 21 745.7 | 21 926.2 | |||||||||||||||||||||||||||||
| -- gross margin, % | % | 3.6% | 18.1% | 18.1% | 18.1% | 18.1% | 18.1% | 18.1% | 18.1% | 18.1% | 18.1% | 18.1% | 18.1% | 18.1% | 18.1% | 18.1% | 18.1% | 18.1% | 18.1% | 18.1% | 18.1% | 18.1% | 18.1% | 18.1% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | |||||||||||||||||||||||||||||
| CC & Overheads | GBP 000s | (11 800.0) | (11 851.8) | (11 903.9) | (11 956.2) | (12 008.8) | (12 061.5) | (12 114.6) | (12 167.8) | (12 221.3) | (12 275.1) | (12 329.1) | (12 383.3) | (12 437.8) | (12 492.6) | (12 547.5) | (12 602.8) | (12 658.3) | (12 714.0) | (12 770.0) | (12 826.3) | (12 882.8) | (12 939.6) | (12 996.6) | (13 053.9) | (13 111.4) | (13 169.2) | (13 227.3) | (13 285.6) | (13 344.3) | (13 403.1) | (13 462.3) | (13 521.7) | (13 581.4) | (13 641.3) | (13 701.6) | (13 762.1) | (13 822.8) | |||||||||||||||||||||||||||||
| EBITDA | GBP 000s | (8 560.0) | 4 651.8 | 4 731.8 | 4 812.8 | 4 894.7 | 4 977.6 | 5 061.5 | 5 146.4 | 5 232.4 | 5 319.3 | 5 407.3 | 5 496.4 | 5 586.5 | 5 677.7 | 5 770.0 | 5 863.4 | 5 957.9 | 6 053.5 | 6 150.3 | 6 248.2 | 6 347.3 | 6 447.6 | 6 549.1 | 6 651.8 | 6 755.7 | 6 860.8 | 6 967.2 | 7 074.9 | 7 183.9 | 7 294.1 | 7 405.7 | 7 518.5 | 7 632.8 | 7 748.3 | 7 865.3 | 7 983.6 | 8 103.4 | |||||||||||||||||||||||||||||
| -- EBITDA margin, % | % | (9.5%) | 5.1% | 5.2% | 5.2% | 5.2% | 5.3% | 5.3% | 5.4% | 5.4% | 5.5% | 5.5% | 5.6% | 5.6% | 5.7% | 5.7% | 5.7% | 5.8% | 5.8% | 5.9% | 5.9% | 6.0% | 6.0% | 6.0% | 6.1% | 6.1% | 6.2% | 6.2% | 6.3% | 6.3% | 6.4% | 6.4% | 6.4% | 6.5% | 6.5% | 6.6% | 6.6% | 6.7% | |||||||||||||||||||||||||||||
| Depreciation & Amortization | GBP 000s | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | (1 333.3) | |||||||||||||||||||||||||||||
| EBIT | GBP 000s | (9 893.3) | 3 318.5 | 3 398.5 | 3 479.5 | 3 561.4 | 3 644.3 | 3 728.2 | 3 813.1 | 3 899.0 | 3 986.0 | 4 074.0 | 4 163.0 | 4 253.2 | 4 344.4 | 4 436.6 | 4 530.0 | 4 624.5 | 4 720.2 | 4 817.0 | 4 914.9 | 5 014.0 | 5 114.3 | 5 215.8 | 5 318.4 | 5 422.4 | 5 527.5 | 5 633.9 | 5 741.6 | 5 850.5 | 5 960.8 | 6 072.3 | 6 185.2 | 6 299.4 | 6 415.0 | 6 532.0 | 6 650.3 | 6 770.1 | |||||||||||||||||||||||||||||
| -- EBIT margin, % | % | (11.0%) | 3.6% | 3.7% | 3.8% | 3.8% | 3.9% | 3.9% | 4.0% | 4.0% | 4.1% | 4.2% | 4.2% | 4.3% | 4.3% | 4.4% | 4.4% | 4.5% | 4.5% | 4.6% | 4.7% | 4.7% | 4.8% | 4.8% | 4.9% | 4.9% | 5.0% | 5.0% | 5.1% | 5.1% | 5.2% | 5.2% | 5.3% | 5.3% | 5.4% | 5.5% | 5.5% | 5.6% | |||||||||||||||||||||||||||||
| Interest Income | GBP 000s | 0.2 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | 2.0 | 7.4 | 9.9 | 15.4 | 19.6 | 22.2 | 28.0 | 30.7 | 36.7 | 41.2 | 40.4 | 50.3 | 53.3 | 59.7 | 62.9 | 69.5 | 74.5 | |||||||||||||||||||||||||||||
| Interest Expense | GBP 000s | (290.7) | (592.2) | (587.3) | (572.7) | (537.3) | (511.7) | (522.5) | (466.2) | (453.2) | (418.4) | (404.5) | (368.4) | (342.5) | (327.2) | (289.0) | (272.7) | (233.1) | (204.2) | (198.8) | (144.6) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | |||||||||||||||||||||||||||||
| EBT | GBP 000s | (10 183.8) | 2 726.3 | 2 811.2 | 2 906.7 | 3 024.0 | 3 132.6 | 3 205.7 | 3 346.9 | 3 445.9 | 3 567.5 | 3 669.5 | 3 794.6 | 3 910.6 | 4 017.2 | 4 147.6 | 4 257.3 | 4 391.4 | 4 516.0 | 4 618.1 | 4 770.3 | 4 874.3 | 4 980.0 | 5 084.0 | 5 192.2 | 5 300.2 | 5 408.0 | 5 520.2 | 5 630.6 | 5 745.6 | 5 860.3 | 5 971.1 | 6 093.8 | 6 211.1 | 6 333.1 | 6 453.2 | 6 578.1 | 6 702.8 | |||||||||||||||||||||||||||||
| Income Tax | GBP 000s | 2 036.8 | (545.3) | (562.2) | (581.3) | (604.8) | (626.5) | (641.1) | (669.4) | (689.2) | (713.5) | (733.9) | (758.9) | (782.1) | (803.4) | (829.5) | (851.5) | (878.3) | (903.2) | (923.6) | (954.1) | (974.9) | (996.0) | (1 016.8) | (1 038.4) | (1 060.0) | (1 081.6) | (1 104.0) | (1 126.1) | (1 149.1) | (1 172.1) | (1 194.2) | (1 218.8) | (1 242.2) | (1 266.6) | (1 290.6) | (1 315.6) | (1 340.6) | |||||||||||||||||||||||||||||
| Net Exceptional Items & Adjustments | GBP 000s | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||||||||||||||||
| Net Income | GBP 000s | (8 147.1) | 2 181.1 | 2 248.9 | 2 325.4 | 2 419.2 | 2 506.1 | 2 564.6 | 2 677.5 | 2 756.7 | 2 854.0 | 2 935.6 | 3 035.7 | 3 128.5 | 3 213.7 | 3 318.1 | 3 405.9 | 3 513.1 | 3 612.8 | 3 694.5 | 3 816.2 | 3 899.5 | 3 984.0 | 4 067.2 | 4 153.8 | 4 240.2 | 4 326.4 | 4 416.2 | 4 504.5 | 4 596.4 | 4 688.2 | 4 776.9 | 4 875.1 | 4 968.9 | 5 066.5 | 5 162.5 | 5 262.5 | 5 362.3 | |||||||||||||||||||||||||||||
| Balance Sheet Statement Summary | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Projected Fiscal Year Ending | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| (GBP in 000s , except otherwise stated) | Aug.14 | 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 | |||||||||||||||||||||||||||||
| Net Fixed Assets | GBP 000s | 120 000.0 | 118 666.7 | 117 333.3 | 116 000.0 | 114 666.7 | 113 333.3 | 112 000.0 | 110 666.7 | 109 333.3 | 108 000.0 | 106 666.7 | 105 333.3 | 104 000.0 | 102 666.7 | 101 333.3 | 100 000.0 | 98 666.7 | 97 333.3 | 96 000.0 | 94 666.7 | 93 333.3 | 92 000.0 | 90 666.7 | 89 333.3 | 88 000.0 | 86 666.7 | 85 333.3 | 84 000.0 | 82 666.7 | 81 333.3 | 80 000.0 | 78 666.7 | 77 333.3 | 76 000.0 | 74 666.7 | 73 333.3 | 72 000.0 | 70 666.7 | ||||||||||||||||||||||||||||
| Financial Investments | GBP 000s | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | 1 000.0 | ||||||||||||||||||||||||||||
| Deferred Tax Assets | GBP 000s | 200.0 | 2 236.8 | 1 691.5 | 1 129.3 | 547.9 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||||||||||||||||
| Other LT Assets | GBP 000s | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||||||||||||||||
| Long Term Assets | GBP 000s | 121 200.0 | 121 903.4 | 120 024.8 | 118 129.3 | 116 214.6 | 114 333.3 | 113 000.0 | 111 666.7 | 110 333.3 | 109 000.0 | 107 666.7 | 106 333.3 | 105 000.0 | 103 666.7 | 102 333.3 | 101 000.0 | 99 666.7 | 98 333.3 | 97 000.0 | 95 666.7 | 94 333.3 | 93 000.0 | 91 666.7 | 90 333.3 | 89 000.0 | 87 666.7 | 86 333.3 | 85 000.0 | 83 666.7 | 82 333.3 | 81 000.0 | 79 666.7 | 78 333.3 | 77 000.0 | 75 666.7 | 74 333.3 | 73 000.0 | 71 666.7 | ||||||||||||||||||||||||||||
| Cash | GBP 000s | 200.0 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | 2 398.8 | 8 887.8 | 11 847.6 | 18 529.0 | 23 469.6 | 26 614.5 | 33 593.2 | 36 865.4 | 44 048.1 | 49 403.0 | 48 507.0 | 60 367.3 | 63 972.3 | 71 686.6 | 75 430.7 | 83 366.4 | 89 345.0 | 93 304.4 | ||||||||||||||||||||||||||||
| Debtors | GBP 000s | 9 000.0 | 90 240.0 | 88 048.2 | 91 733.2 | 89 506.5 | 90 245.7 | 100 740.8 | 91 744.6 | 95 587.9 | 93 271.2 | 97 180.0 | 94 826.2 | 95 614.5 | 99 623.7 | 97 213.0 | 101 290.8 | 98 841.3 | 99 666.8 | 107 431.1 | 101 341.0 | 105 596.1 | 103 046.5 | 107 374.9 | 104 784.0 | 105 664.9 | 110 106.0 | 107 451.7 | 111 969.5 | 109 272.1 | 110 195.1 | 123 033.3 | 112 067.3 | 116 783.9 | 113 975.0 | 118 773.7 | 115 918.8 | 116 904.5 | 121 829.6 | ||||||||||||||||||||||||||||
| Inventory | GBP 000s | 11 000.0 | 116 000.0 | 96 102.6 | 100 129.9 | 97 704.6 | 98 516.7 | 109 979.5 | 100 163.5 | 104 364.9 | 101 840.8 | 106 114.1 | 103 549.2 | 104 415.4 | 108 799.2 | 106 171.9 | 110 631.1 | 107 961.1 | 108 868.3 | 117 355.2 | 110 708.0 | 115 362.2 | 112 582.3 | 117 317.0 | 114 491.8 | 115 460.0 | 120 318.5 | 117 423.7 | 122 366.7 | 119 424.4 | 120 438.9 | 134 476.9 | 122 496.7 | 127 658.2 | 124 593.6 | 129 845.4 | 126 730.2 | 127 813.7 | 133 204.4 | ||||||||||||||||||||||||||||
| Creditors | 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 | ||||||||||||||||||||||||||||
| Current Assets | GBP 000s | 20 250.0 | 206 290.0 | 184 200.8 | 191 913.1 | 187 261.1 | 188 812.5 | 210 770.3 | 191 958.1 | 200 002.8 | 195 162.0 | 203 344.1 | 198 425.4 | 200 079.9 | 208 472.9 | 203 434.9 | 211 971.9 | 206 852.4 | 208 585.1 | 224 836.3 | 212 099.0 | 223 407.1 | 224 566.6 | 236 589.6 | 237 854.8 | 244 644.6 | 257 088.9 | 258 518.5 | 271 251.6 | 272 794.6 | 280 087.0 | 306 067.2 | 294 981.4 | 308 464.5 | 310 305.1 | 324 099.9 | 326 065.4 | 334 113.3 | 348 388.4 | ||||||||||||||||||||||||||||
| Total Assets | GBP 000s | 141 450.0 | 328 193.4 | 304 225.7 | 310 042.4 | 303 475.7 | 303 145.8 | 323 770.3 | 303 624.7 | 310 336.1 | 304 162.0 | 311 010.7 | 304 758.8 | 305 079.9 | 312 139.6 | 305 768.2 | 312 971.9 | 306 519.1 | 306 918.5 | 321 836.3 | 307 765.7 | 317 740.4 | 317 566.6 | 328 256.2 | 328 188.2 | 333 644.6 | 344 755.6 | 344 851.8 | 356 251.6 | 356 461.3 | 362 420.4 | 387 067.2 | 374 648.1 | 386 797.8 | 387 305.1 | 399 766.5 | 400 398.8 | 407 113.3 | 420 055.1 | ||||||||||||||||||||||||||||
| Other CA | GBP 000s | (15 000.0) | (164 666.7) | (139 244.1) | (145 002.3) | (141 415.0) | (142 514.9) | (159 012.8) | (144 743.9) | (150 735.8) | (147 012.8) | (153 101.1) | (149 322.2) | (150 492.3) | (156 728.7) | (152 864.1) | (159 201.4) | (155 278.5) | (156 501.9) | (168 614.7) | (158 981.8) | (165 579.8) | (161 506.6) | (168 212.2) | (164 077.0) | (165 379.6) | (172 250.4) | (168 020.3) | (175 003.8) | (170 709.0) | (172 071.7) | (192 030.3) | (174 834.3) | (182 108.9) | (177 647.4) | (185 042.3) | (180 512.1) | (181 964.1) | (189 543.6) | ||||||||||||||||||||||||||||
| Short Term Revolver | GBP 000s | (22 350.0) | (67 573.8) | (66 847.6) | (64 657.2) | (59 352.4) | (55 503.4) | (57 123.9) | (48 682.6) | (46 724.6) | (41 516.8) | (39 423.2) | (34 014.6) | (30 129.8) | (27 824.7) | (22 104.1) | (19 652.5) | (13 716.7) | (9 379.5) | (8 571.7) | (439.5) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||||||||||||||||
| 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) | ||||||||||||||||||||||||||||
| Current Liabilities | GBP 000s | (37 450.0) | (232 340.5) | (206 191.7) | (209 759.4) | (200 867.4) | (198 118.2) | (216 236.7) | (193 526.5) | (197 560.4) | (188 629.6) | (192 624.3) | (183 436.8) | (180 722.2) | (184 653.4) | (175 068.2) | (178 953.9) | (169 095.2) | (165 981.4) | (177 286.4) | (159 521.3) | (165 679.8) | (161 606.6) | (168 312.2) | (164 177.0) | (165 479.6) | (172 350.4) | (168 120.3) | (175 103.8) | (170 809.0) | (172 171.7) | (192 130.3) | (174 934.3) | (182 208.9) | (177 747.4) | (185 142.3) | (180 612.1) | (182 064.1) | (189 643.6) | ||||||||||||||||||||||||||||
| Bank Debt Tranche A | GBP 000s | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | (20 000.0) | ||||||||||||||||||||||||||||
| Bank Debt Tranche B | GBP 000s | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | (10 000.0) | ||||||||||||||||||||||||||||
| Other Long Term Liabilities | GBP 000s | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | (15 000.0) | ||||||||||||||||||||||||||||
| Long Term Liabilities | GBP 000s | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | (45 000.0) | ||||||||||||||||||||||||||||
| Net Assets | GBP 000s | 59 000.0 | 50 852.9 | 53 034.0 | 55 283.0 | 57 608.3 | 60 027.6 | 62 533.6 | 65 098.2 | 67 775.7 | 70 532.4 | 73 386.4 | 76 322.0 | 79 357.7 | 82 486.2 | 85 699.9 | 89 018.0 | 92 423.9 | 95 937.1 | 99 549.8 | 103 244.3 | 107 060.6 | 110 960.0 | 114 944.0 | 119 011.2 | 123 165.0 | 127 405.2 | 131 731.6 | 136 147.8 | 140 652.3 | 145 248.7 | 149 936.9 | 154 713.8 | 159 588.9 | 164 557.7 | 169 624.2 | 174 786.7 | 180 049.2 | 185 411.5 | ||||||||||||||||||||||||||||
| Equity & Reserves | GBP 000s | 59 000.0 | 50 852.9 | 53 034.0 | 55 283.0 | 57 608.3 | 60 027.6 | 62 533.6 | 65 098.2 | 67 775.7 | 70 532.4 | 73 386.4 | 76 322.0 | 79 357.7 | 82 486.2 | 85 699.9 | 89 018.0 | 92 423.9 | 95 937.1 | 99 549.8 | 103 244.3 | 107 060.6 | 110 960.0 | 114 944.0 | 119 011.2 | 123 165.0 | 127 405.2 | 131 731.6 | 136 147.8 | 140 652.3 | 145 248.7 | 149 936.9 | 154 713.8 | 159 588.9 | 164 557.7 | 169 624.2 | 174 786.7 | 180 049.2 | 185 411.5 | ||||||||||||||||||||||||||||
| Check | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | خي | |||||||||||||||||||||||||||||
| Cash Flow Statement Summary | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Projected Fiscal Year Ending | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| (GBP in 000s , except otherwise stated) | Aug.14 | 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 | |||||||||||||||||||||||||||||
| EBITDA | GBP 000s | (8 560.0) | 4 651.8 | 4 731.8 | 4 812.8 | 4 894.7 | 4 977.6 | 5 061.5 | 5 146.4 | 5 232.4 | 5 319.3 | 5 407.3 | 5 496.4 | 5 586.5 | 5 677.7 | 5 770.0 | 5 863.4 | 5 957.9 | 6 053.5 | 6 150.3 | 6 248.2 | 6 347.3 | 6 447.6 | 6 549.1 | 6 651.8 | 6 755.7 | 6 860.8 | 6 967.2 | 7 074.9 | 7 183.9 | 7 294.1 | 7 405.7 | 7 518.5 | 7 632.8 | 7 748.3 | 7 865.3 | 7 983.6 | 8 103.4 | |||||||||||||||||||||||||||||
| Interest Income | GBP 000s | 0.2 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | 2.0 | 7.4 | 9.9 | 15.4 | 19.6 | 22.2 | 28.0 | 30.7 | 36.7 | 41.2 | 40.4 | 50.3 | 53.3 | 59.7 | 62.9 | 69.5 | 74.5 | |||||||||||||||||||||||||||||
| Interest Expense | GBP 000s | (290.7) | (592.2) | (587.3) | (572.7) | (537.3) | (511.7) | (522.5) | (466.2) | (453.2) | (418.4) | (404.5) | (368.4) | (342.5) | (327.2) | (289.0) | (272.7) | (233.1) | (204.2) | (198.8) | (144.6) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | (141.7) | |||||||||||||||||||||||||||||
| Cash Tax | GBP 000s | - | - | - | - | (56.9) | (626.5) | (641.1) | (669.4) | (689.2) | (713.5) | (733.9) | (758.9) | (782.1) | (803.4) | (829.5) | (851.5) | (878.3) | (903.2) | (923.6) | (954.1) | (974.9) | (996.0) | (1 016.8) | (1 038.4) | (1 060.0) | (1 081.6) | (1 104.0) | (1 126.1) | (1 149.1) | (1 172.1) | (1 194.2) | (1 218.8) | (1 242.2) | (1 266.6) | (1 290.6) | (1 315.6) | (1 340.6) | |||||||||||||||||||||||||||||
| Net Change in WC | GBP 000s | (36 573.3) | (3 333.4) | (1 954.1) | 1 064.7 | (451.4) | (5 459.9) | 4 543.4 | (2 052.8) | 1 117.8 | (2 093.8) | 1 139.7 | (484.3) | (2 156.7) | 1 173.5 | (2 199.7) | 1 196.5 | (509.2) | (4 138.4) | 3 104.4 | (2 311.3) | 1 256.2 | (2 357.5) | 1 280.9 | (546.5) | (2 428.6) | 1 318.9 | (2 477.3) | 1 344.9 | (574.9) | (6 917.5) | 5 750.1 | (2 603.4) | 1 412.0 | (2 655.7) | 1 439.9 | (617.2) | (2 736.2) | |||||||||||||||||||||||||||||
| Operating Cash Flow before Investments | GBP 000s | (45 423.8) | 726.3 | 2 190.4 | 5 304.8 | 3 849.0 | (1 620.5) | 8 441.3 | 1 958.0 | 5 207.8 | 2 093.6 | 5 408.6 | 3 884.8 | 2 305.1 | 5 720.6 | 2 451.7 | 5 935.7 | 4 337.2 | 807.8 | 8 132.2 | 2 838.3 | 6 489.0 | 2 959.8 | 6 681.4 | 4 940.6 | 3 144.9 | 6 978.6 | 3 272.2 | 7 182.7 | 5 354.9 | (896.0) | 11 860.3 | 3 605.0 | 7 714.2 | 3 744.1 | 7 935.7 | 5 978.6 | 3 959.4 | |||||||||||||||||||||||||||||
| CAPEX | GBP 000s | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||||||||||||||||
| Net Change in Other LTA/LTL | GBP 000s | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||||||||||||||||
| Extraordinary Cash Items | GBP 000s | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||||||||||||||||
| Change in Cash before Financing | GBP 000s | (45 423.8) | 726.3 | 2 190.4 | 5 304.8 | 3 849.0 | (1 620.5) | 8 441.3 | 1 958.0 | 5 207.8 | 2 093.6 | 5 408.6 | 3 884.8 | 2 305.1 | 5 720.6 | 2 451.7 | 5 935.7 | 4 337.2 | 807.8 | 8 132.2 | 2 838.3 | 6 489.0 | 2 959.8 | 6 681.4 | 4 940.6 | 3 144.9 | 6 978.6 | 3 272.2 | 7 182.7 | 5 354.9 | (896.0) | 11 860.3 | 3 605.0 | 7 714.2 | 3 744.1 | 7 935.7 | 5 978.6 | 3 959.4 | |||||||||||||||||||||||||||||
| Financed by | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Equity Issue / (Buy Back or Dividend) | GBP 000s | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||||||||||||||||
| Debt Issue / (Retirement) | GBP 000s | 45 223.8 | (726.3) | (2 190.4) | (5 304.8) | (3 849.0) | 1 620.5 | (8 441.3) | (1 958.0) | (5 207.8) | (2 093.6) | (5 408.6) | (3 884.8) | (2 305.1) | (5 720.6) | (2 451.7) | (5 935.7) | (4 337.2) | (807.8) | (8 132.2) | (439.5) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||||||||||||||||
| Total Financing | GBP 000s | 45 223.8 | (726.3) | (2 190.4) | (5 304.8) | (3 849.0) | 1 620.5 | (8 441.3) | (1 958.0) | (5 207.8) | (2 093.6) | (5 408.6) | (3 884.8) | (2 305.1) | (5 720.6) | (2 451.7) | (5 935.7) | (4 337.2) | (807.8) | (8 132.2) | (439.5) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||||||||||||||||
| Change in Cash for the Period | GBP 000s | (200.0) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | 2 398.8 | 6 489.0 | 2 959.8 | 6 681.4 | 4 940.6 | 3 144.9 | 6 978.6 | 3 272.2 | 7 182.7 | 5 354.9 | (896.0) | 11 860.3 | 3 605.0 | 7 714.2 | 3 744.1 | 7 935.7 | 5 978.6 | 3 959.4 | |||||||||||||||||||||||||||||
| Cash BoP | GBP 000s | 200.0 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | 2 398.8 | 8 887.8 | 11 847.6 | 18 529.0 | 23 469.6 | 26 614.5 | 33 593.2 | 36 865.4 | 44 048.1 | 49 403.0 | 48 507.0 | 60 367.3 | 63 972.3 | 71 686.6 | 75 430.7 | 83 366.4 | 89 345.0 | |||||||||||||||||||||||||||||
| Cash EoP | GBP 000s | 200.0 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | 2 398.8 | 8 887.8 | 11 847.6 | 18 529.0 | 23 469.6 | 26 614.5 | 33 593.2 | 36 865.4 | 44 048.1 | 49 403.0 | 48 507.0 | 60 367.3 | 63 972.3 | 71 686.6 | 75 430.7 | 83 366.4 | 89 345.0 | 93 304.4 | ||||||||||||||||||||||||||||
| >> End of Sheet | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||