Navigation

Iterate Interest?

Manufacturing Model

Ок

No[1]

Financial Schedules

Income Statement Summary

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

Revenues

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)

Gross Margin

GBP 000s

2 344.7

2 362.3

2 328.2

2 371.8

2 415.8

2 433.9

2 425.5

2 443.7

2 489.1

2 507.8

2 471.7

2 517.9

2 564.6

2 583.9

2 546.6

2 594.3

2 642.4

2 662.3

2 623.9

2 673.0

2 722.6

2 743.0

2 733.6

2 754.1

2 805.2

2 826.2

2 785.5

2 837.6

2 890.3

2 912.0

2 870.1

2 923.7

2 978.0

3 000.3

2 957.1

3 012.4

3 068.4

-- gross margin, %

74.3%

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)

EBITDA

(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, %

GBP 000s

(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%)

Depreciation & Amortization

(4 000.0)

EBIT

GBP 000s

(13 455.3)

(13 593.2)

(13 784.9)

(13 901.1)

(14 019.0)

(14 165.1)

(14 339.9)

(14 490.4)

(14 616.1)

(14 770.7)

(14 982.6)

(15 114.5)

(15 248.3)

(15 412.1)

(15 634.9)

(15 775.4)

(15 917.9)

(16 091.4)

(16 325.7)

(16 475.2)

(16 627.0)

(16 810.7)

(17 027.1)

(17 216.4)

(17 378.0)

(17 572.5)

(17 831.8)

(18 001.3)

(18 173.3)

(18 379.3)

(14 652.1)

(14 832.5)

(15 015.5)

(15 233.8)

(15 520.9)

(15 712.8)

(15 907.5)

-- EBIT margin, %

(426.6%)

(427.7%)

(440.1%)

(435.7%)

(431.4%)

(432.6%)

(439.5%)

(440.8%)

(436.5%)

(437.8%)

(450.6%)

(446.2%)

(442.0%)

(443.4%)

(456.4%)

(452.0%)

(447.8%)

(449.3%)

(462.5%)

(458.2%)

(454.0%)

(455.6%)

(463.0%)

(464.7%)

(460.5%)

(462.2%)

(475.8%)

(471.6%)

(467.4%)

(469.2%)

(379.5%)

(377.1%)

(374.8%)

(377.4%)

(390.1%)

(387.7%)

(385.4%)

Interest Income

GBP 000s

0.5

Interest Expense

GBP 000s

(747.0)

(720.2)

(925.0)

(1 137.1)

(1 356.5)

(1 582.7)

(1 816.0)

(2 057.3)

(2 306.5)

(2 563.5)

(2 828.5)

(3 102.5)

(3 385.3)

(3 676.4)

(3 976.4)

(4 286.2)

(4 605.8)

(4 934.7)

(5 273.3)

(5 622.7)

(5 983.0)

(6 353.5)

(6 734.7)

(7 127.6)

(7 532.4)

(7 948.7)

(8 377.0)

(8 818.4)

(9 272.9)

(9 739.8)

(10 219.9)

(10 714.4)

(11 223.3)

(11 746.0)

(12 283.2)

(12 836.2)

(13 405.0)

EBT

GBP 000s

(14 201.8)

(14 313.5)

(14 709.9)

(15 038.2)

(15 375.6)

(15 747.8)

(16 156.0)

(16 547.7)

(16 922.6)

(17 334.3)

(17 811.1)

(18 217.0)

(18 633.6)

(19 088.5)

(19 611.3)

(20 061.6)

(20 523.7)

(21 026.0)

(21 598.9)

(22 098.0)

(22 610.0)

(23 164.2)

(23 761.8)

(24 344.0)

(24 910.3)

(25 521.3)

(26 208.8)

(26 819.7)

(27 446.1)

(28 119.1)

(24 872.1)

(25 547.0)

(26 238.8)

(26 979.8)

(27 804.0)

(28 549.0)

(29 312.5)

Tax

GBP 000s

2 840.4

2 862.7

2 942.0

3 007.6

3 075.1

3 149.6

3 231.2

3 309.5

3 384.5

3 466.9

3 562.2

3 643.4

3 726.7

3 817.7

3 922.3

4 012.3

4 104.7

4 205.2

4 319.8

4 419.6

4 522.0

4 632.8

4 752.4

4 868.8

4 982.1

5 104.3

5 241.8

5 363.9

5 489.2

5 623.8

4 974.4

5 109.4

5 247.8

5 396.0

5 560.8

5 709.8

5 862.5

Net Exceptional Items & Adjustments

GBP 000s

Net Income

GBP 000s

(11 361.5)

(11 450.8)

(11 767.9)

(12 030.6)

(12 300.5)

(12 598.2)

(12 924.8)

(13 238.1)

(13 538.1)

(13 867.4)

(14 248.9)

(14 573.6)

(14 906.9)

(15 270.8)

(15 689.0)

(16 049.3)

(16 419.0)

(16 820.8)

(17 279.2)

(17 678.4)

(18 088.0)

(18 531.3)

(19 009.5)

(19 475.2)

(19 928.3)

(20 417.0)

(20 967.0)

(21 455.8)

(21 956.9)

(22 495.3)

(19 897.6)

(20 437.6)

(20 991.1)

(21 583.8)

(22 243.2)

(22 839.2)

(23 450.0)

Balance Sheet Statement Summary

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

Net Fixed Assets

GBP 000s

120 000.0

116 000.0

112 000.0

108 000.0

104 000.0

100 000.0

96 000.0

92 000.0

88 000.0

84 000.0

80 000.0

76 000.0

72 000.0

68 000.0

64 000.0

60 000.0

56 000.0

52 000.0

48 000.0

44 000.0

40 000.0

36 000.0

32 000.0

28 000.0

24 000.0

20 000.0

16 000.0

12 000.0

8 000.0

4 000.0

Financial Investments

GBP 000s

1 000.0

Deffered Tax Assets

GBP 000s

200.0

3 040.4

5 903.1

8 845.0

11 852.7

14 927.8

18 077.4

21 308.6

24 618.1

28 002.6

31 469.5

35 031.7

38 675.1

42 401.8

46 219.5

50 141.7

54 154.1

58 258.8

62 464.0

66 783.8

71 203.4

75 725.4

80 358.2

85 110.6

89 979.4

94 961.5

100 065.7

105 307.5

110 671.4

116 160.6

121 784.5

126 758.9

131 868.3

137 116.0

142 512.0

148 072.8

153 782.6

159 645.1

Other Long Term Assets

GBP 000s

Long Term Assets

GBP 000s

121 200.0

120 040.4

118 903.1

117 845.0

116 852.7

115 927.8

115 077.4

114 308.6

113 618.1

113 002.6

112 469.5

112 031.7

111 675.1

111 401.8

111 219.5

111 141.7

111 154.1

111 258.8

111 464.0

111 783.8

112 203.4

112 725.4

113 358.2

114 110.6

114 979.4

115 961.5

117 065.7

118 307.5

119 671.4

121 160.6

122 784.5

127 758.9

132 868.3

138 116.0

143 512.0

149 072.8

154 782.6

160 645.1

Cash

GBP 000s

200.0

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

Other CA

GBP 000s

50.0

Current Assets

GBP 000s

21 250.0

1 619.4

1 631.1

1 608.4

1 637.5

1 667.0

1 679.1

1 673.5

1 685.7

1 716.0

1 728.5

1 704.4

1 735.3

1 766.6

1 779.5

1 754.6

1 786.4

1 818.7

1 831.9

1 806.3

1 839.1

1 872.3

1 886.0

1 879.7

1 893.4

1 927.6

1 941.7

1 914.5

1 949.3

1 984.6

1 999.1

1 971.0

2 006.9

2 043.3

2 058.2

2 029.3

2 066.3

2 103.7

Total Assets

GBP 000s

142 450.0

121 659.7

120 534.2

119 453.4

118 490.2

117 594.8

116 756.5

115 982.0

115 303.8

114 718.6

114 198.0

113 736.0

113 410.4

113 168.4

112 999.0

112 896.3

112 940.5

113 077.5

113 296.0

113 590.1

114 042.5

114 597.7

115 244.2

115 990.3

116 872.8

117 889.1

119 007.4

120 221.9

121 620.7

123 145.2

124 783.6

129 729.9

134 875.2

140 159.3

145 570.2

151 102.1

156 848.9

162 748.9

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)

Short Term Revolver

GBP 000s

(22 350.0)

(21 011.8)

(31 248.5)

(41 855.7)

(52 827.3)

(64 135.3)

(75 801.8)

(87 862.6)

(100 326.5)

(113 177.2)

(126 425.5)

(140 122.9)

(154 264.4)

(168 821.5)

(183 819.0)

(199 310.8)

(215 292.1)

(231 734.5)

(248 664.1)

(266 137.3)

(284 150.0)

(302 673.5)

(321 735.6)

(341 379.5)

(361 618.4)

(382 436.7)

(403 849.9)

(425 919.4)

(448 642.7)

(471 991.0)

(495 995.8)

(520 721.2)

(546 165.7)

(572 300.6)

(599 159.3)

(626 808.9)

(655 249.0)

(684 451.0)

Other CL

GBP 000s

(100.0)

Current Liabilities

GBP 000s

(37 450.0)

(28 021.2)

(38 346.4)

(49 033.5)

(60 100.9)

(71 506.0)

(83 265.9)

(95 416.2)

(107 976.1)

(120 929.1)

(134 275.8)

(148 062.7)

(162 310.6)

(176 975.5)

(192 076.9)

(207 663.3)

(223 756.7)

(240 312.7)

(257 352.0)

(274 925.3)

(293 056.1)

(311 699.3)

(330 877.2)

(350 632.7)

(370 990.4)

(391 935.0)

(413 470.3)

(435 651.9)

(458 506.4)

(481 987.8)

(506 121.5)

(530 965.4)

(556 548.3)

(582 823.5)

(609 818.2)

(637 593.4)

(666 179.4)

(695 529.3)

Long Term Loan

GBP 000s

(20 000.0)

Other Long Term Liabilities

GBP 000s

(10 000.0)

Long Term Liabilities

GBP 000s

(30 000.0)

Net Assets

GBP 000s

75 000.0

63 638.5

52 187.8

40 419.9

28 389.3

16 088.8

3 490.6

(9 434.2)

(22 672.4)

(36 210.4)

(50 077.8)

(64 326.7)

(78 900.3)

(93 807.1)

(109 078.0)

(124 767.0)

(140 816.3)

(157 235.2)

(174 056.1)

(191 335.2)

(209 013.6)

(227 101.6)

(245 632.9)

(264 642.4)

(284 117.6)

(304 045.9)

(324 462.9)

(345 429.9)

(366 885.7)

(388 842.6)

(411 337.9)

(431 235.5)

(451 673.1)

(472 664.2)

(494 248.0)

(516 491.2)

(539 330.4)

(562 780.5)

Equity & Reserves

GBP 000s

75 000.0

63 638.5

52 187.8

40 419.9

28 389.3

16 088.8

3 490.6

(9 434.2)

(22 672.4)

(36 210.4)

(50 077.8)

(64 326.7)

(78 900.3)

(93 807.1)

(109 078.0)

(124 767.0)

(140 816.3)

(157 235.2)

(174 056.1)

(191 335.2)

(209 013.6)

(227 101.6)

(245 632.9)

(264 642.4)

(284 117.6)

(304 045.9)

(324 462.9)

(345 429.9)

(366 885.7)

(388 842.6)

(411 337.9)

(431 235.5)

(451 673.1)

(472 664.2)

(494 248.0)

(516 491.2)

(539 330.4)

(562 780.5)

Ок

Cash Flow Statement Summary

(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

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)

Cash Interest Income

GBP 000s

0.5

Cash Interest Expense

GBP 000s

(747.0)

(720.2)

(925.0)

(1 137.1)

(1 356.5)

(1 582.7)

(1 816.0)

(2 057.3)

(2 306.5)

(2 563.5)

(2 828.5)

(3 102.5)

(3 385.3)

(3 676.4)

(3 976.4)

(4 286.2)

(4 605.8)

(4 934.7)

(5 273.3)

(5 622.7)

(5 983.0)

(6 353.5)

(6 734.7)

(7 127.6)

(7 532.4)

(7 948.7)

(8 377.0)

(8 818.4)

(9 272.9)

(9 739.8)

(10 219.9)

(10 714.4)

(11 223.3)

(11 746.0)

(12 283.2)

(12 836.2)

(13 405.0)

Cash Tax

GBP 000s

Net Change in WC

GBP 000s

11 340.0

76.8

102.7

66.7

67.6

81.3

95.2

83.7

71.9

86.0

113.6

75.4

76.5

91.1

119.5

80.2

81.4

96.4

125.8

85.3

86.5

102.1

117.9

105.1

92.0

108.0

139.3

96.4

97.8

114.4

146.6

102.5

104.0

121.1

154.4

108.9

110.5

Operating Cash Flow before Investments

GBP 000s

1 138.2

(10 236.7)

(10 607.1)

(10 971.6)

(11 308.0)

(11 666.6)

(12 060.7)

(12 464.0)

(12 850.7)

(13 248.3)

(13 697.5)

(14 141.5)

(14 557.1)

(14 997.5)

(15 491.7)

(15 981.4)

(16 442.4)

(16 929.6)

(17 473.2)

(18 012.7)

(18 523.5)

(19 062.1)

(19 643.9)

(20 238.9)

(20 818.3)

(21 413.2)

(22 069.5)

(22 723.3)

(23 348.3)

(24 004.8)

(24 725.4)

(25 444.5)

(26 134.9)

(26 858.7)

(27 649.7)

(28 440.1)

(29 202.0)

CAPEX

GBP 000s

Net Change in Other LTA/LTL

GBP 000s

Extraordinary Cash Items

GBP 000s

Change in Cash before Financing

GBP 000s

1 138.2

(10 236.7)

(10 607.1)

(10 971.6)

(11 308.0)

(11 666.6)

(12 060.7)

(12 464.0)

(12 850.7)

(13 248.3)

(13 697.5)

(14 141.5)

(14 557.1)

(14 997.5)

(15 491.7)

(15 981.4)

(16 442.4)

(16 929.6)

(17 473.2)

(18 012.7)

(18 523.5)

(19 062.1)

(19 643.9)

(20 238.9)

(20 818.3)

(21 413.2)

(22 069.5)

(22 723.3)

(23 348.3)

(24 004.8)

(24 725.4)

(25 444.5)

(26 134.9)

(26 858.7)

(27 649.7)

(28 440.1)

(29 202.0)

Financed by

Equity Issue / (Buy Back or Dividend)

GBP 000s

Debt Issue / (Retirement)

GBP 000s

(1 338.2)

10 236.7

10 607.1

10 971.6

11 308.0

11 666.6

12 060.7

12 464.0

12 850.7

13 248.3

13 697.5

14 141.5

14 557.1

14 997.5

15 491.7

15 981.4

16 442.4

16 929.6

17 473.2

18 012.7

18 523.5

19 062.1

19 643.9

20 238.9

20 818.3

21 413.2

22 069.5

22 723.3

23 348.3

24 004.8

24 725.4

25 444.5

26 134.9

26 858.7

27 649.7

28 440.1

29 202.0

Total Financing

GBP 000s

(1 338.2)

10 236.7

10 607.1

10 971.6

11 308.0

11 666.6

12 060.7

12 464.0

12 850.7

13 248.3

13 697.5

14 141.5

14 557.1

14 997.5

15 491.7

15 981.4

16 442.4

16 929.6

17 473.2

18 012.7

18 523.5

19 062.1

19 643.9

20 238.9

20 818.3

21 413.2

22 069.5

22 723.3

23 348.3

24 004.8

24 725.4

25 444.5

26 134.9

26 858.7

27 649.7

28 440.1

29 202.0

Change in Cash for the Period

GBP 000s

(200.0)

Cash BoP

GBP 000s

200.0

Cash EoP

GBP 000s

200.0

>> End of Sheet

[1]

FinRobot:
If the toggle is set on Yes, then Excel calculation options would need to have iterations option turned on