Navigation

Iterate Interest?

Case Builder Model

Ок

No[1]

Financial Schedules - Base Case

Income Statement Summary

Projected Fiscal Year Ending

(in USD 000s, except otherwise stated)

Dec-13

Mar-14

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

Revenues

USD 000s

44 000.0

45 325.5

46 577.1

47 746.1

48 824.6

49 804.8

50 679.4

51 442.2

52 087.1

52 609.3

53 136.7

53 669.4

54 207.4

54 750.9

55 299.8

55 854.1

56 414.1

56 979.6

57 550.8

58 127.8

COGS

USD 000s

(24 000.0)

(25 155.7)

(25 384.5)

(25 544.2)

(25 632.9)

(26 147.5)

(26 606.7)

(27 007.1)

(27 345.7)

(27 619.9)

(27 896.8)

(28 176.4)

(28 458.9)

(28 744.2)

(29 032.4)

(29 323.4)

(29 617.4)

(29 914.3)

(30 214.2)

(30 517.1)

Gross Margin

USD 000s

20 000.0

20 169.8

21 192.6

22 202.0

23 191.7

23 657.3

24 072.7

24 435.0

24 741.4

24 989.4

25 239.9

25 493.0

25 748.5

26 006.7

26 267.4

26 530.7

26 796.7

27 065.3

27 336.6

27 610.7

-- gross margin, %

45.5%

44.5%

45.5%

46.5%

47.5%

Central Costs & Overheads Operating Assumptions

USD 000s

(10 800.0)

(10 930.8)

(11 095.3)

(11 252.9)

(11 402.7)

(11 544.1)

(11 676.4)

(11 799.1)

(11 911.6)

(12 013.5)

(12 116.3)

(12 220.1)

(12 324.8)

(12 430.4)

(12 536.9)

(12 644.4)

(12 752.9)

(12 862.4)

(12 972.8)

(13 084.3)

EBITDA

USD 000s

9 200.0

9 239.1

10 097.2

10 949.1

11 789.0

12 113.2

12 396.3

12 635.9

12 829.8

12 975.9

13 123.6

13 272.9

13 423.8

13 576.3

13 730.5

13 886.3

14 043.8

14 202.9

14 363.8

14 526.4

-- EBITDA margin, %

20.9%

20.4%

21.7%

22.9%

24.1%

24.3%

24.5%

24.6%

24.7%

24.8%

24.9%

25.0%

Depreciation & Amortization

USD 000s

(8 571.4)

(8 771.4)

(8 950.0)

(9 150.0)

(9 328.6)

(9 528.6)

(9 707.1)

(9 907.1)

(10 085.7)

(10 285.7)

(10 464.3)

(10 689.3)

(10 967.9)

(11 192.9)

(2 800.0)

(3 025.0)

(3 203.6)

(3 428.6)

(3 625.0)

(3 875.0)

EBIT

USD 000s

628.6

467.6

1 147.2

1 799.1

2 460.4

2 584.6

2 689.2

2 728.8

2 744.0

2 690.2

2 659.3

2 583.6

2 455.9

2 383.4

10 930.5

10 861.3

10 840.2

10 774.4

10 738.8

10 651.4

-- EBIT margin, %

1.4%

1.0%

2.5%

3.8%

5.0%

5.2%

5.3%

5.1%

5.0%

4.8%

4.5%

4.4%

19.8%

19.4%

19.2%

18.9%

18.7%

18.3%

Cash Interest Income

USD 000s

2.5

6.4

10.8

23.4

29.1

42.8

47.0

11.6

16.6

32.1

33.8

46.0

48.7

60.6

61.7

Cash Interest Expense

USD 000s

(625.0)

(631.6)

(564.2)

(545.1)

(451.9)

(403.1)

(335.0)

(310.6)

(286.3)

(261.9)

(237.5)

(213.1)

(188.8)

(164.4)

(140.0)

(115.6)

(91.3)

(66.9)

(42.5)

(18.1)

EBT

USD 000s

6.1

(164.0)

583.0

1 254.0

2 008.5

2 181.5

2 360.5

2 429.0

2 481.2

2 457.4

2 464.6

2 417.4

2 278.8

2 235.7

10 822.6

10 779.5

10 795.0

10 756.2

10 756.9

10 695.0

Income Tax

USD 000s

(1.2)

32.8

(116.6)

(250.8)

(401.7)

(436.3)

(472.1)

(485.8)

(496.2)

(491.5)

(492.9)

(483.5)

(455.8)

(447.1)

(2 164.5)

(2 155.9)

(2 159.0)

(2 151.2)

(2 151.4)

(2 139.0)

Net Exceptional Items & Adjustments

USD 000s

Net Income

USD 000s

4.9

(131.2)

466.4

1 003.2

1 606.8

1 745.2

1 888.4

1 943.2

1 985.0

1 966.0

1 971.7

1 934.0

1 823.0

1 788.6

8 658.1

8 623.6

8 636.0

8 604.9

8 605.5

8 556.0

Balance Sheet Statement Summary

Projected Fiscal Year Ending

(in USD 000s, except otherwise stated)

Dec-13

Mar-14

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

Net Fixed Assets

USD 000s

120 000.0

119 428.6

115 657.1

114 707.1

110 557.1

109 228.6

104 700.0

102 992.9

98 085.7

96 000.0

90 714.3

89 250.0

103 560.7

101 592.9

95 400.0

101 600.0

103 575.0

109 371.4

111 442.9

117 817.9

119 942.9

Financial Investments

USD 000s

1 000.0

Deffered Tax Assets

USD 000s

32.8

Other LT Assets

USD 000s

Long Term Assets

USD 000s

121 000.0

120 428.6

116 689.9

115 707.1

111 557.1

110 228.6

105 700.0

103 992.9

99 085.7

97 000.0

91 714.3

90 250.0

104 560.7

102 592.9

96 400.0

102 600.0

104 575.0

110 371.4

112 442.9

118 817.9

120 942.9

Cash

USD 000s

1 000.0

2 543.0

4 324.5

9 372.9

11 654.6

17 130.5

18 790.5

4 637.4

6 651.6

12 856.0

13 536.7

18 407.7

19 469.2

24 224.4

24 676.2

29 828.1

Debtors

USD 000s

14 000.0

14 465.8

14 901.5

15 313.0

15 697.4

16 051.9

16 374.2

16 661.7

16 912.5

17 124.5

17 296.2

17 469.6

17 644.7

17 821.6

18 000.3

18 180.7

18 363.0

18 547.1

18 733.0

18 920.8

19 110.5

Inventory

USD 000s

5 000.0

5 260.3

5 513.6

5 563.7

5 598.7

5 618.2

5 731.0

5 831.6

5 919.4

5 993.6

6 053.7

6 114.4

6 175.7

6 237.6

6 300.1

6 363.3

6 427.1

6 491.5

6 556.6

6 622.3

6 688.7

Other CA

USD 000s

Current Assets

USD 000s

20 000.0

19 726.0

20 415.1

20 876.7

21 296.1

21 670.1

24 648.1

26 817.8

32 204.8

34 772.7

40 480.4

42 374.5

28 457.8

30 710.8

37 156.4

38 080.7

43 197.7

44 507.8

49 513.9

50 219.3

55 627.3

Total Assets

USD 000s

141 000.0

140 154.6

137 105.0

136 583.9

132 853.2

131 898.7

130 348.1

130 810.7

131 290.5

131 772.7

132 194.7

132 624.5

133 018.5

133 303.6

133 556.4

140 680.7

147 772.7

154 879.2

161 956.8

169 037.2

176 570.2

Creditors

USD 000s

(20 000.0)

(19 068.5)

(19 773.4)

(19 989.0)

(20 162.8)

(20 293.5)

(20 652.9)

(20 977.1)

(21 263.7)

(21 510.9)

(21 716.9)

(21 925.0)

(22 135.1)

(22 347.2)

(22 561.4)

(22 777.7)

(22 996.1)

(23 216.6)

(23 439.3)

(23 664.1)

(23 891.1)

Short Term Revolver

USD 000s

(10 000.0)

(11 081.2)

(8 458.0)

(8 254.8)

(4 347.2)

(2 655.1)

Other CL

USD 000s

Current Liabilities

USD 000s

(30 000.0)

(30 149.7)

(28 231.4)

(28 243.8)

(24 510.0)

(22 948.6)

(20 652.9)

(20 977.1)

(21 263.7)

(21 510.9)

(21 716.9)

(21 925.0)

(22 135.1)

(22 347.2)

(22 561.4)

(22 777.7)

(22 996.1)

(23 216.6)

(23 439.3)

(23 664.1)

(23 891.1)

Bank Debt Tranche A

USD 000s

(20 000.0)

(19 000.0)

(18 000.0)

(17 000.0)

(16 000.0)

(15 000.0)

(14 000.0)

(13 000.0)

(12 000.0)

(11 000.0)

(10 000.0)

(9 000.0)

(8 000.0)

(7 000.0)

(6 000.0)

(5 000.0)

(4 000.0)

(3 000.0)

(2 000.0)

(1 000.0)

Bank Debt Tranche B

USD 000s

(10 000.0)

(9 250.0)

(8 500.0)

(7 750.0)

(7 000.0)

(6 250.0)

(5 500.0)

(4 750.0)

(4 000.0)

(3 250.0)

(2 500.0)

(1 750.0)

(1 000.0)

(250.0)

Bank Debt Tranche C

USD 000s

Other LT Libilities

USD 000s

Long Term Liabilities

USD 000s

(30 000.0)

(29 000.0)

(28 000.0)

(27 000.0)

(26 000.0)

(25 000.0)

(24 000.0)

(22 250.0)

(20 500.0)

(18 750.0)

(17 000.0)

(15 250.0)

(13 500.0)

(11 750.0)

(10 000.0)

(8 250.0)

(6 500.0)

(4 750.0)

(3 000.0)

(1 250.0)

Net Assets

USD 000s

81 000.0

81 004.9

80 873.7

81 340.1

82 343.3

83 950.0

85 695.2

87 583.6

89 526.8

91 511.8

93 477.7

95 449.5

97 383.4

99 206.4

100 995.0

109 653.0

118 276.6

126 912.6

135 517.5

144 123.0

152 679.0

Equity & Reserves

USD 000s

81 000.0

81 004.9

80 873.7

81 340.1

82 343.3

83 950.0

85 695.2

87 583.6

89 526.8

91 511.8

93 477.7

95 449.5

97 383.4

99 206.4

100 995.0

109 653.0

118 276.6

126 912.6

135 517.5

144 123.0

152 679.0

Ок

Cash Flow Statement Summary

(in USD 000s, except otherwise stated)

Dec-13

Mar-14

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

EBITDA

USD 000s

9 200.0

9 239.1

10 097.2

10 949.1

11 789.0

12 113.2

12 396.3

12 635.9

12 829.8

12 975.9

13 123.6

13 272.9

13 423.8

13 576.3

13 730.5

13 886.3

14 043.8

14 202.9

14 363.8

14 526.4

Cash Interest Income

USD 000s

2.5

6.4

10.8

23.4

29.1

42.8

47.0

11.6

16.6

32.1

33.8

46.0

48.7

60.6

61.7

Cash Interest Expense

USD 000s

(625.0)

(631.6)

(564.2)

(545.1)

(451.9)

(403.1)

(335.0)

(310.6)

(286.3)

(261.9)

(237.5)

(213.1)

(188.8)

(164.4)

(140.0)

(115.6)

(91.3)

(66.9)

(42.5)

(18.1)

Cash Tax

USD 000s

(1.2)

(83.8)

(250.8)

(401.7)

(436.3)

(472.1)

(485.8)

(496.2)

(491.5)

(492.9)

(483.5)

(455.8)

(447.1)

(2 164.5)

(2 155.9)

(2 159.0)

(2 151.2)

(2 151.4)

(2 139.0)

Net Change in WC

USD 000s

(1 657.5)

15.8

(246.1)

(245.5)

(243.3)

(75.6)

(64.1)

(51.9)

(39.1)

(25.7)

(26.0)

(26.3)

(26.7)

(27.0)

(27.3)

(27.7)

(28.0)

(28.3)

(28.7)

(29.0)

Operating Cash Flow before Investments

USD 000s

6 918.8

8 623.3

9 203.2

9 907.6

10 692.0

11 198.2

11 531.5

11 798.4

12 031.6

12 226.0

12 410.0

12 596.9

12 764.2

12 954.4

11 430.7

11 620.9

11 811.5

12 005.2

12 201.8

12 402.0

CAPEX

USD 000s

(8 000.0)

(5 000.0)

(8 000.0)

(5 000.0)

(8 000.0)

(5 000.0)

(8 000.0)

(5 000.0)

(8 000.0)

(5 000.0)

(9 000.0)

(25 000.0)

(9 000.0)

(5 000.0)

(9 000.0)

(5 000.0)

(9 000.0)

(5 500.0)

(10 000.0)

(6 000.0)

Net Change in Other LTA/LTL

USD 000s

Extraordinary Cash Items

USD 000s

Operating Cash Flow before Investments

USD 000s

(1 081.2)

3 623.3

1 203.2

4 907.6

2 692.0

6 198.2

3 531.5

6 798.4

4 031.6

7 226.0

3 410.0

(12 403.1)

3 764.2

7 954.4

2 430.7

6 620.9

2 811.5

6 505.2

2 201.8

6 402.0

Financed by

Equity Issue / (Buy Back or Dividend)

USD 000s

Debt Issue / (Retirement)

USD 000s

81.2

(3 623.3)

(1 203.2)

(4 907.6)

(2 692.0)

(3 655.1)

(1 750.0)

(1 250.0)

Total Financing

USD 000s

81.2

(3 623.3)

(1 203.2)

(4 907.6)

(2 692.0)

(3 655.1)

(1 750.0)

(1 250.0)

Change in Cash for the Period

USD 000s

(1 000.0)

2 543.0

1 781.5

5 048.4

2 281.6

5 476.0

1 660.0

(14 153.1)

2 014.2

6 204.4

680.7

4 870.9

1 061.5

4 755.2

451.8

5 152.0

Cash BoP

USD 000s

1 000.0

2 543.0

4 324.5

9 372.9

11 654.6

17 130.5

18 790.5

4 637.4

6 651.6

12 856.0

13 536.7

18 407.7

19 469.2

24 224.4

24 676.2

Cash EoP

USD 000s

1 000.0

2 543.0

4 324.5

9 372.9

11 654.6

17 130.5

18 790.5

4 637.4

6 651.6

12 856.0

13 536.7

18 407.7

19 469.2

24 224.4

24 676.2

29 828.1

>> End of Sheet

[1]

FinRobot:
If the toggle is set to "Yes", Excel needs to be set to interative calculations mode.