Ecolab inc. (ECL)
CashFlow / Quarterly
Mar'20Dec'19Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16Dec'15Sep'15Jun'15Mar'15Dec'14Sep'14Jun'14Mar'14Dec'13Sep'13Jun'13Mar'13Dec'12Sep'12Jun'12Mar'12Dec'11Sep'11Jun'11Mar'11Dec'10Sep'10Jun'10Mar'10Dec'09Sep'09Jun'09Mar'09
OPERATING ACTIVITIES
Net income including noncontrolling interest

290,200

434,300

469,300

372,200

300,400

400,200

438,300

353,600

248,200

568,400

396,600

296,300

257,300

371,400

379,500

263,600

232,000

222,900

250,100

308,800

235,400

343,300

369,400

315,000

194,500

289,600

307,200

215,800

161,000

234,500

239,300

183,400

44,100

88,800

154,500

126,200

93,800

131,600

174,300

129,500

95,700

116,300

145,200

99,500

57,700

Adjustments to reconcile net income to cash provided by operating activities:
Depreciation

169,300

165,700

165,000

164,300

159,000

159,500

156,000

154,600

150,900

149,000

150,700

144,100

142,200

140,100

144,900

136,400

139,600

136,800

136,900

143,700

142,100

140,700

141,300

139,600

136,500

132,900

130,900

127,800

122,600

119,700

116,700

116,300

115,500

86,100

82,900

82,800

79,600

-

-

-

-

-

-

-

-

Amortization

80,300

79,000

79,700

80,700

79,800

78,100

78,600

80,100

80,200

79,100

77,600

77,100

73,800

72,500

71,900

72,700

72,600

75,600

74,500

74,800

75,100

77,300

77,300

79,000

80,300

81,500

81,000

76,800

62,700

61,200

61,300

62,100

61,700

24,600

14,200

13,900

11,600

-

-

-

-

-

-

-

-

Deferred income taxes

-5,300

-55,400

20,900

1,900

-5,000

28,500

24,000

19,300

13,300

-363,300

24,700

-18,200

3,300

-35,300

-26,500

-69,900

41,100

-68,300

-141,300

-38,100

3,200

-42,400

-28,500

-42,300

-8,300

-27,800

-23,400

-52,400

-26,900

-17,800

40,700

-7,200

-18,900

38,400

-4,000

7,200

100

-34,000

3,700

-3,000

2,200

67,900

16,400

-2,000

5,800

Depreciation and amortization

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

81,500

91,800

86,200

85,700

83,600

84,600

80,400

Share-based compensation expense

29,100

17,900

13,700

27,300

32,200

18,900

13,700

28,100

33,700

18,700

14,300

26,600

30,900

18,000

14,100

24,500

29,100

18,100

13,000

21,800

25,300

16,000

12,400

19,900

22,800

16,000

13,900

18,600

21,100

15,100

12,400

17,400

20,900

11,900

7,000

9,800

11,200

8,200

6,800

9,800

4,400

14,400

8,000

7,000

7,900

Excess tax benefits from share-based payment arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

4,100

19,900

12,900

6,700

21,600

4,800

11,700

19,700

14,200

10,800

8,000

22,900

10,400

8,300

5,600

12,300

22,000

3,700

17,300

7,100

4,800

1,100

5,500

2,300

3,600

6,400

4,300

2,600

1,800

4,700

1,000

200

Pension and postretirement plan contributions

20,600

22,000

133,000

12,000

19,000

14,000

12,000

11,000

23,000

13,100

94,000

14,000

23,000

4,800

15,000

168,000

24,000

10,900

16,000

17,000

21,000

15,700

16,000

17,000

28,000

18,000

25,000

18,000

19,000

22,900

31,000

175,000

26,000

24,600

9,000

14,000

109,000

27,200

6,700

6,000

6,700

118,900

81,600

7,100

56,100

Pension and postretirement plan expense

9,900

12,700

5,200

5,300

4,900

8,500

6,400

8,400

8,600

10,400

9,200

8,500

8,800

11,000

14,500

14,400

14,200

26,800

28,900

28,800

29,300

18,500

21,900

21,600

21,900

35,500

35,600

35,600

35,700

32,400

26,800

28,100

27,300

22,500

20,500

20,300

19,800

23,300

22,800

21,800

22,900

20,500

20,400

20,900

20,200

Restructuring charges, net of cash paid

-16,200

4,000

8,100

6,800

16,300

-13,900

63,700

1,400

-7,700

-8,100

-7,000

26,500

-6,200

-12,400

-21,000

-13,400

-13,700

48,300

-5,300

4,900

-9,500

22,700

-13,100

-12,000

2,700

-19,300

-14,100

2,800

-9,200

33,200

5,700

10,600

17,100

4,800

8,400

26,000

10,300

-

-

-

-

-6,500

-5,000

9,200

24,700

Venezuela currency devaluation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

100

0

-23,400

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other, net

-11,800

-5,300

-1,200

-6,900

-6,400

-4,000

-7,700

-7,400

-4,900

-17,500

-7,300

-7,900

-4,700

-2,300

800

-5,200

-7,500

-9,400

4,800

-2,200

-4,800

600

300

-5,000

-3,700

-3,500

-5,400

-2,900

-4,600

-8,800

9,600

-3,700

-2,700

-3,300

-1,600

-2,100

-1,900

-4,900

-4,400

3,500

4,000

-20,300

1,700

3,400

2,300

Changes in operating assets and liabilities, net of effect of acquisitions:
Accounts receivable

76,200

61,500

500

83,200

-8,000

2,800

72,800

122,400

-33,900

68,300

39,300

60,300

-76,400

36,900

24,700

50,800

-113,300

12,400

33,800

-34,600

12,400

11,900

84,100

117,700

-38,300

77,100

75,300

25,100

-30,100

15,000

101,700

103,500

-30,500

31,900

39,800

44,500

-10,200

-35,200

47,700

46,000

-19,200

-22,000

30,500

-8,600

-45,000

Inventories

26,000

-88,600

-35,300

-100

83,000

-30,100

52,300

41,700

77,200

-31,400

21,100

28,300

67,500

15,800

6,000

-41,800

1,200

-28,800

11,400

-17,600

83,600

42,100

61,500

52,400

54,800

-61,800

19,700

18,400

54,200

-25,400

23,100

22,900

-18,600

8,100

11,200

7,200

9,600

-16,900

10,600

-7,300

-5,000

8,700

-5,400

-22,100

5,800

Other assets

48,800

-60,700

75,800

72,300

-5,900

57,800

-24,200

46,100

1,000

57,300

-18,000

-4,100

13,700

20,900

33,700

-25,100

5,400

-10,700

21,400

13,100

45,300

54,600

16,900

-10,100

44,900

-40,800

21,800

37,300

50,400

-67,200

14,600

-11,000

45,000

19,500

14,600

700

25,400

-40,000

-9,700

20,400

-13,100

16,100

6,300

-12,600

20,900

Accounts payable

-

11,300

-25,200

71,500

-35,300

61,300

-27,600

39,400

40,400

64,100

-27,000

71,100

12,900

-17,500

41,600

-21,000

-58,200

17,800

81,800

24,300

-170,000

145,200

49,500

49,600

-69,600

91,300

17,800

-20,500

-38,000

32,300

67,200

3,400

-23,900

13,800

12,700

33,800

600

-2,200

18,400

21,900

-31,300

-12,400

19,800

15,700

-48,200

Other liabilities

-25,700

80,300

118,300

-30,100

-92,500

126,400

16,800

-172,600

-18,000

253,700

75,200

-107,400

-74,200

-34,100

98,000

103,700

-67,700

-25,500

276,500

-101,400

-41,200

91,800

172,300

-71,300

-57,800

28,500

132,100

-96,000

-65,200

19,400

123,300

-9,500

-107,000

-60,500

16,500

-4,200

-36,700

36,900

31,800

23,700

-76,700

-6,800

59,700

-1,500

-85,400

Cash provided by operating activities

371,800

821,000

682,200

539,400

378,100

827,300

664,700

298,500

487,200

646,400

585,200

434,000

425,700

448,000

616,900

402,300

472,500

604,600

758,600

524,100

112,500

670,600

613,100

317,500

214,400

630,600

536,200

207,000

186,000

482,200

509,700

100,600

110,500

144,800

238,600

246,000

56,100

312,200

273,200

229,600

135,400

163,500

232,100

272,000

27,400

INVESTING ACTIVITIES
Capital expenditures

160,700

250,200

179,900

183,500

187,000

213,000

221,600

209,200

203,300

274,600

215,800

210,700

167,500

278,200

174,900

163,600

140,100

219,400

224,100

160,700

166,800

260,000

167,000

179,500

142,200

201,700

158,300

135,900

129,200

180,500

139,500

130,300

124,200

113,400

82,500

80,000

65,800

72,300

62,800

74,400

51,000

83,500

61,300

56,500

51,200

Capitalized software expenditures

-

-

-

-

-

-

-

-

-

-

-

-

-

-

10,000

13,600

8,600

19,500

10,400

7,500

6,800

13,300

16,400

6,800

8,700

11,500

9,500

9,900

6,300

15,400

9,600

3,700

4,300

7,800

4,600

5,100

6,800

8,900

7,200

12,500

8,600

15,100

12,400

9,300

8,000

Property and other assets sold

1,400

2,400

5,000

2,100

1,400

500

5,000

24,000

500

6,600

1,600

2,000

500

900

18,200

4,100

7,300

4,800

3,400

800

6,000

2,300

3,300

4,600

700

8,500

7,300

1,400

900

6,000

1,900

5,800

2,200

-100

600

2,100

400

1,100

100

600

800

8,500

2,200

300

700

Acquisitions and investments in affiliates, net of cash acquired

1,500

4,800

97,800

7,000

281,800

152,200

-500

1,600

76,500

158,000

4,700

-100

826,600

4,800

35,300

-100

9,500

136,400

114,800

3,900

10,800

11,800

36,400

9,100

25,300

-4,600

-9,800

1,360,900

91,200

0

15,600

15,600

11,800

1,351,300

800

3,600

277,500

-

-

-

-

7,300

1,900

700

4,500

Divestiture of businesses

-

-

-

-

-

0

800

-1,000

9,400

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

6,000

8,700

1,300

-

-

-

-

Release from (deposit into) acquisition related escrow

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,200

35,000

0

9,400

0

7,300

300

1,100

0

0

0

13,000

0

15,200

0

2,100

-

-

-

-

-

-

-

-

-

-

-

-

Deposit into acquisition related escrow

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-100

0

2,600

8,000

0

0

0

1,300

0

0

0

28,100

-

-

-

-

-

-

-

-

Settlement of net investment hedges

-

-

-

-

-

0

0

0

14,100

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other, net

4,900

17,300

0

-2,500

10,000

-

-

-

-

0

-900

0

1,700

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash used for investing activities

-165,700

-269,900

-271,700

-180,100

-477,400

-381,100

-204,500

-188,600

-255,800

-305,100

-218,000

-208,600

-995,300

-191,800

-257,900

-173,000

-150,900

-366,700

-209,100

-171,000

-169,000

-283,400

-205,600

-184,900

-174,400

-200,400

-158,600

-1,507,900

-220,800

-73,000

-134,600

-143,000

-137,300

-1,472,600

-87,300

-86,600

-377,800

-63,800

-104,900

-77,400

-57,500

-97,400

-73,000

-65,900

-63,000

FINANCING ACTIVITIES
Net issuances of commercial paper and notes payable

957,600

-401,500

-284,800

-53,600

487,900

226,100

-107,000

-131,600

354,300

-231,500

-722,000

51,000

858,800

-84,000

-180,000

-12,800

-329,600

-84,700

-677,000

113,900

335,700

289,400

-167,400

80,100

397,500

-187,700

-158,200

377,600

-310,000

2,300

-816,000

106,800

319,600

610,100

-65,300

-103,400

465,700

-156,500

16,700

-39,500

112,700

-24,200

-120,300

-181,300

81,800

Long-term debt borrowings

766,600

-

-

-

-

-

-

-

-

-

-

-

-

1,596,200

0

-300

794,100

-1,300

629,400

100

595,500

-

-

-

-

0

0

899,900

200

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Long-term debt repayments

299,700

0

-400

700

400,300

249,800

1,200

0

300,600

778,900

14,800

4,900

400

1,439,100

500

4,300

125,700

150,500

504,200

4,300

375,700

500,500

150,800

155,100

101,400

173,400

101,800

234,300

1,700

2,000

1,800

1,600

1,689,500

1,264,700

1,900

2,000

151,800

1,500

2,600

1,900

1,400

1,400

1,500

1,500

2,000

Reacquired shares

95,000

5,100

1,100

216,100

131,400

241,000

105,600

700

215,100

12,600

86,600

126,600

374,500

1,800

99,900

248,000

389,900

27,300

1,500

313,700

412,600

87,600

4,400

94,000

242,600

79,100

52,800

153,500

22,200

16,800

2,200

105,600

85,300

567,500

300

52,000

70,200

3,700

143,100

57,300

144,700

57,300

11,100

300

100

Dividends paid

145,500

136,900

137,300

139,300

141,400

125,700

118,500

128,900

123,400

118,400

107,400

109,700

113,200

103,000

106,900

109,600

108,000

99,100

99,100

102,700

99,800

85,500

86,600

86,400

85,900

74,500

71,200

67,900

4,500

126,300

59,600

59,700

61,200

40,600

41,100

40,600

40,600

35,900

36,200

36,600

36,800

33,200

33,100

33,400

33,000

Exercise of employee stock options

83,400

15,100

52,000

52,000

67,700

28,700

35,400

22,000

28,400

20,800

8,400

28,900

25,700

14,500

21,600

31,400

9,300

25,300

8,800

26,000

23,000

13,900

20,600

6,900

24,000

19,300

21,500

24,200

32,000

50,000

15,700

58,500

39,500

28,800

9,500

36,900

13,800

17,300

37,100

21,100

13,700

9,300

25,000

10,300

1,800

Excess tax benefits from share-based payment arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

4,100

19,900

12,900

6,700

21,600

4,800

11,700

19,700

14,200

10,800

8,000

22,900

10,400

8,300

5,600

12,300

22,000

3,700

17,300

7,100

4,800

1,100

5,500

2,300

3,600

6,400

4,300

2,600

1,800

4,700

1,000

200

Acquisition related liabilities and contingent consideration

2,500

-

-

-

-

-100

-100

1,700

8,600

-

-

-

-

31,700

400

1,100

2,300

12,100

0

900

-100

-2,800

14,900

-1,000

87,600

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other, net

900

-

-

-

-

-

-

-

-

-

-

0

-900

-

-

-

-

-

-

-

-

-

-

-

-

-400

500

-300

400

-

-

-

-

-33,100

-8,200

0

-100

-

-

-

-

-

-

-

-

Cash provided by (used for) financing activities

1,265,800

-502,100

-371,800

-358,200

-117,500

-353,200

-313,000

-241,500

-265,000

-322,200

-426,500

-169,500

395,500

-44,800

-346,200

-331,800

-145,400

-328,100

-638,800

-269,900

85,900

-357,300

-393,800

-246,800

-73,100

-486,900

-363,500

851,300

-293,500

422,200

-361,700

15,700

-1,469,800

2,976,500

-106,200

-155,600

219,100

-176,700

-121,700

-109,900

-53,900

-105,000

-136,300

-205,200

48,700

Effect of exchange rate changes on cash, cash equivalents and restricted cash

3,600

1,500

11,500

5,600

1,800

-2,600

2,200

10,300

-2,300

-16,800

7,700

-7,300

5,800

-11,600

400

1,400

-500

-1,800

-36,500

-10,500

-1,100

-18,100

-2,900

900

-5,800

1,500

5,100

500

-5,200

2,400

5,700

-22,400

7,000

-12,400

-1,000

8,000

11,700

2,200

500

-6,300

-12,300

5,000

2,000

2,300

-300

Increase (decrease) in cash, cash equivalents and restricted cash

1,475,500

50,500

50,200

6,700

-215,000

90,400

149,400

-121,300

-35,900

2,300

-51,600

48,600

-168,300

199,800

13,200

-101,100

175,700

-92,000

-125,800

72,700

28,300

11,800

10,800

-113,300

-38,900

-55,200

19,200

-449,100

-333,500

833,800

19,100

-49,100

-1,489,600

1,636,300

44,100

11,800

-90,900

73,900

47,100

36,000

11,700

-33,900

24,800

3,200

12,800