Ecolab inc. (ECL)
CashFlow / TTM
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

1,566,000

1,576,200

1,542,100

1,511,100

1,492,500

1,440,300

1,608,500

1,566,800

1,509,500

1,518,600

1,321,600

1,304,500

1,271,800

1,246,500

1,098,000

968,600

1,013,800

1,017,200

1,137,600

1,256,900

1,263,100

1,222,200

1,168,500

1,106,300

1,007,100

973,600

918,500

850,600

818,200

701,300

555,600

470,800

413,600

463,300

506,100

525,900

529,200

531,100

515,800

486,700

456,700

418,700

0

0

0

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

664,300

654,000

647,800

638,800

629,100

621,000

610,500

605,200

594,700

586,000

577,100

571,300

563,600

561,000

557,700

549,700

557,000

559,500

563,400

567,800

563,700

558,100

550,300

539,900

528,100

514,200

501,000

486,800

475,300

468,200

434,600

400,800

367,300

331,400

0

0

0

-

-

-

-

-

-

-

-

Amortization

319,700

319,200

318,300

317,200

316,600

317,000

318,000

317,000

314,000

307,600

301,000

295,300

290,900

289,700

292,800

295,400

297,500

300,000

301,700

304,500

308,700

313,900

318,100

321,800

319,600

302,000

281,700

262,000

247,300

246,300

209,700

162,600

114,400

64,300

0

0

0

-

-

-

-

-

-

-

-

Deferred income taxes

-37,900

-37,600

46,300

49,400

66,800

85,100

-306,700

-306,000

-343,500

-353,500

-25,500

-76,700

-128,400

-90,600

-123,600

-238,400

-206,600

-244,500

-218,600

-105,800

-110,000

-121,500

-106,900

-101,800

-111,900

-130,500

-120,500

-56,400

-11,200

-3,200

53,000

8,300

22,700

41,700

-30,700

-23,000

-33,200

-31,100

70,800

83,500

84,500

88,100

0

0

0

Depreciation and amortization

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

345,200

347,300

340,100

334,300

0

0

0

Share-based compensation expense

88,000

91,100

92,100

92,100

92,900

94,400

94,200

94,800

93,300

90,500

89,800

89,600

87,500

85,700

85,800

84,700

82,000

78,200

76,100

75,500

73,600

71,100

71,100

72,600

71,300

69,600

68,700

67,200

66,000

65,800

62,600

57,200

49,600

39,900

36,200

36,000

36,000

29,200

35,400

36,600

33,800

37,300

0

0

0

Excess tax benefits from share-based payment arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

43,600

61,100

46,000

44,800

57,800

50,400

56,400

52,700

55,900

52,100

49,600

47,200

36,600

48,200

43,600

55,300

50,100

32,900

30,300

18,500

13,700

12,500

17,800

16,600

16,900

15,100

13,400

10,100

7,700

0

0

0

Pension and postretirement plan contributions

187,600

186,000

178,000

57,000

56,000

60,000

59,100

141,100

144,100

144,100

135,800

56,800

210,800

211,800

217,900

218,900

67,900

64,900

69,700

69,700

69,700

76,700

79,000

88,000

89,000

80,000

84,900

90,900

247,900

254,900

256,600

234,600

73,600

156,600

159,200

156,900

148,900

46,600

138,300

213,200

214,300

263,700

0

0

0

Pension and postretirement plan expense

33,100

28,100

23,900

25,100

28,200

31,900

33,800

36,600

36,700

36,900

37,500

42,800

48,700

54,100

69,900

84,300

98,700

113,800

105,500

98,500

91,300

83,900

100,900

114,600

128,600

142,400

139,300

130,500

123,000

114,600

104,700

98,400

90,600

83,100

83,900

86,200

87,700

90,800

88,000

85,600

84,700

82,000

0

0

0

Restructuring charges, net of cash paid

2,700

35,200

17,300

72,900

67,500

43,500

49,300

-21,400

3,700

5,200

900

-13,100

-53,000

-60,500

200

15,900

34,200

38,400

12,800

5,000

-11,900

300

-41,700

-42,700

-27,900

-39,800

12,700

32,500

40,300

66,600

38,200

40,900

56,300

49,500

0

0

0

-

-

-

-

22,400

0

0

0

Venezuela currency devaluation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other, net

-25,200

-19,800

-18,500

-25,000

-25,500

-24,000

-37,500

-37,100

-37,600

-37,400

-22,200

-14,100

-11,400

-14,200

-21,300

-17,300

-14,300

-11,600

-1,600

-6,100

-8,900

-7,800

-11,900

-17,600

-15,500

-16,400

-21,700

-6,700

-7,500

-5,600

-100

-11,300

-9,700

-8,900

-10,500

-13,300

-7,700

-1,800

-17,200

-11,100

-11,200

-12,900

0

0

0

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

221,400

137,200

78,500

150,800

190,000

164,100

229,600

196,100

134,000

91,500

60,100

45,500

36,000

-900

-25,400

-16,300

-101,700

24,000

23,500

73,800

226,100

175,400

240,600

231,800

139,200

147,400

85,300

111,700

190,100

189,700

206,600

144,700

85,700

106,000

38,900

46,800

48,300

39,300

52,500

35,300

-19,300

-45,100

0

0

0

Inventories

-98,000

-41,000

17,500

105,100

146,900

141,100

139,800

108,600

95,200

85,500

132,700

117,600

47,500

-18,800

-63,400

-58,000

-33,800

48,600

119,500

169,600

239,600

210,800

106,900

65,100

31,100

30,500

66,900

70,300

74,800

2,000

35,500

23,600

7,900

36,100

11,100

10,500

-4,000

-18,600

7,000

-9,000

-23,800

-13,000

0

0

0

Other assets

136,200

81,500

200,000

100,000

73,800

80,700

80,200

86,400

36,200

48,900

12,500

64,200

43,200

34,900

3,300

-9,000

29,200

69,100

134,400

129,900

106,700

106,300

10,900

15,800

63,200

68,700

42,300

35,100

-13,200

-18,600

68,100

68,100

79,800

60,200

700

-23,600

-3,900

-42,400

13,700

29,700

-3,300

30,700

0

0

0

Accounts payable

-

22,300

72,300

69,900

37,800

113,500

116,300

116,900

148,600

121,100

39,500

108,100

16,000

-55,100

-19,800

20,400

65,700

-46,100

81,300

49,000

74,300

174,700

120,800

89,100

19,000

50,600

-8,400

41,000

64,900

79,000

60,500

6,000

36,400

60,900

44,900

50,600

38,700

6,800

-3,400

-2,000

-8,200

-25,100

0

0

0

Other liabilities

142,800

76,000

122,100

20,600

-121,900

-47,400

79,900

138,300

203,500

147,300

-140,500

-117,700

93,400

99,900

108,500

287,000

81,900

108,400

225,700

121,500

151,600

135,000

71,700

31,500

6,800

-600

-9,700

-18,500

68,000

26,200

-53,700

-160,500

-155,200

-84,900

12,500

27,800

55,700

15,700

-28,000

-100

-25,300

-34,000

0

0

0

Cash provided by operating activities

2,414,400

2,420,700

2,427,000

2,409,500

2,168,600

2,277,700

2,096,800

2,017,300

2,152,800

2,091,300

1,892,900

1,924,600

1,892,900

1,939,700

2,096,300

2,238,000

2,359,800

1,999,800

2,065,800

1,920,300

1,713,700

1,815,600

1,775,600

1,698,700

1,588,200

1,559,800

1,411,400

1,384,900

1,278,500

1,203,000

865,600

594,500

739,900

685,500

852,900

887,500

871,100

950,400

801,700

760,600

803,000

695,000

0

0

0

INVESTING ACTIVITIES
Capital expenditures

774,300

800,600

763,400

805,100

830,800

847,100

908,700

902,900

904,400

868,600

872,200

831,300

784,200

756,800

698,000

747,200

744,300

771,000

811,600

754,500

773,300

748,700

690,400

681,700

638,100

625,100

603,900

585,100

579,500

574,500

507,400

450,400

400,100

341,700

300,600

280,900

275,300

260,500

271,700

270,200

252,300

252,500

0

0

0

Capitalized software expenditures

-

-

-

-

-

-

-

-

-

-

-

-

-

-

51,700

52,100

46,000

44,200

38,000

44,000

43,300

45,200

43,400

36,500

39,600

37,200

41,100

41,200

35,000

33,000

25,400

20,400

21,800

24,300

25,400

28,000

35,400

37,200

43,400

48,600

45,400

44,800

0

0

0

Property and other assets sold

10,900

10,900

9,000

9,000

30,900

30,000

36,100

32,700

10,700

10,700

5,000

21,600

23,700

30,500

34,400

19,600

16,300

15,000

12,500

12,400

16,200

10,900

17,100

21,100

17,900

18,100

15,600

10,200

14,600

15,900

9,800

8,500

4,800

3,000

4,200

3,700

2,200

2,600

10,000

12,100

11,800

11,700

0

0

0

Acquisitions and investments in affiliates, net of cash acquired

111,100

391,400

538,800

440,500

435,100

229,800

235,600

240,800

239,100

989,200

836,000

866,600

866,600

49,500

181,100

260,600

264,600

265,900

141,300

62,900

68,100

82,600

66,200

20,000

1,371,800

1,437,700

1,442,300

1,467,700

122,400

43,000

1,394,300

1,379,500

1,367,500

1,633,200

0

0

0

-

-

-

-

14,400

0

0

0

Divestiture of businesses

-

-

-

-

-

9,200

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

16,000

0

0

0

-

-

-

-

Release from (deposit into) acquisition related escrow

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

45,600

44,400

16,700

17,000

8,700

8,700

1,400

1,100

13,000

13,000

28,200

28,200

17,300

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Deposit into acquisition related escrow

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

10,500

10,600

10,600

8,000

1,300

1,300

1,300

1,300

28,100

0

0

0

-

-

-

-

-

-

-

-

Settlement of net investment hedges

-

-

-

-

-

14,100

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other, net

19,700

24,800

0

0

0

-

-

-

-

800

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash used for investing activities

-887,400

-1,199,100

-1,310,300

-1,243,100

-1,251,600

-1,030,000

-954,000

-967,500

-987,500

-1,727,000

-1,613,700

-1,653,600

-1,618,000

-773,600

-948,500

-899,700

-897,700

-915,800

-832,500

-829,000

-842,900

-848,300

-765,300

-718,300

-2,041,300

-2,087,700

-1,960,300

-1,936,300

-571,400

-487,900

-1,887,500

-1,840,200

-1,783,800

-2,024,300

-615,500

-633,100

-623,900

-303,600

-337,200

-305,300

-293,800

-299,300

0

0

0

FINANCING ACTIVITIES
Net issuances of commercial paper and notes payable

217,700

-252,000

375,600

553,400

475,400

341,800

-115,800

-730,800

-548,200

-43,700

103,800

645,800

582,000

-606,400

-607,100

-1,104,100

-977,400

-312,100

62,000

571,600

537,800

599,600

122,500

131,700

429,200

-278,300

-88,300

-746,100

-1,016,900

-387,300

220,500

971,200

761,000

907,100

140,500

222,500

286,400

-66,600

65,700

-71,300

-213,100

-244,000

0

0

0

Long-term debt borrowings

0

-

-

-

-

-

-

-

-

-

-

-

-

2,390,000

792,500

1,421,900

1,422,300

1,223,700

0

0

0

-

-

-

-

900,100

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Long-term debt repayments

300,000

400,600

650,400

652,000

651,300

551,600

1,080,700

1,094,300

1,099,200

799,000

1,459,200

1,444,900

1,444,300

1,569,600

281,000

784,700

784,700

1,034,700

1,384,700

1,031,300

1,182,100

907,800

580,700

531,700

610,900

511,200

339,800

239,800

7,100

1,694,900

2,957,600

2,957,700

2,958,100

1,420,400

157,200

157,900

157,800

7,400

7,300

6,200

5,800

6,400

0

0

0

Reacquired shares

317,300

353,700

589,600

694,100

478,700

562,400

334,000

315,000

440,900

600,300

589,500

602,800

724,200

739,600

765,100

666,700

732,400

755,100

815,400

818,300

598,600

428,600

420,100

468,500

528,000

307,600

245,300

194,700

146,800

209,900

760,600

758,700

705,100

690,000

126,200

269,000

274,300

348,800

402,400

270,400

213,400

68,800

0

0

0

Dividends paid

559,000

554,900

543,700

524,900

514,500

496,500

489,200

478,100

458,900

448,700

433,300

432,800

432,700

427,500

423,600

415,800

408,900

400,700

387,100

374,600

358,300

344,400

333,400

318,000

299,500

218,100

269,900

258,300

250,100

306,800

221,100

202,600

183,500

162,900

158,200

153,300

149,300

145,500

142,800

139,700

136,500

132,700

0

0

0

Exercise of employee stock options

202,500

186,800

200,400

183,800

153,800

114,500

106,600

79,600

86,500

83,800

77,500

90,700

93,200

76,800

87,600

74,800

69,400

83,100

71,700

83,500

64,400

65,400

70,800

71,700

89,000

97,000

127,700

121,900

156,200

163,700

142,500

136,300

114,700

89,000

77,500

105,100

89,300

89,200

81,200

69,100

58,300

46,400

0

0

0

Excess tax benefits from share-based payment arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

43,600

61,100

46,000

44,800

57,800

50,400

56,400

52,700

55,900

52,100

49,600

47,200

36,600

48,200

43,600

55,300

50,100

32,900

30,300

18,500

13,700

12,500

17,800

16,600

16,900

15,100

13,400

10,100

7,700

0

0

0

Acquisition related liabilities and contingent consideration

0

-

-

-

-

10,100

0

0

0

-

-

-

-

35,500

15,900

15,500

15,300

12,900

-2,000

12,900

11,000

98,700

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other, net

0

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

200

0

0

0

-

-

-

-

-41,400

0

0

0

-

-

-

-

-

-

-

-

Cash provided by (used for) financing activities

33,700

-1,349,600

-1,200,700

-1,141,900

-1,025,200

-1,172,700

-1,141,700

-1,255,200

-1,183,200

-522,700

-245,300

-165,000

-327,300

-868,200

-1,151,500

-1,444,100

-1,382,200

-1,150,900

-1,180,100

-935,100

-912,000

-1,071,000

-1,200,600

-1,170,300

-72,200

-292,600

616,500

618,300

-217,300

-1,393,600

1,160,700

1,416,200

1,244,900

2,933,800

-219,400

-234,900

-189,200

-462,200

-390,500

-405,100

-500,400

-397,800

0

0

0

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

22,200

20,400

16,300

7,000

11,700

7,600

-6,600

-1,100

-18,700

-10,600

-5,400

-12,700

-4,000

-10,300

-500

-37,400

-49,300

-49,900

-66,200

-32,600

-21,200

-25,900

-6,300

1,700

1,300

1,900

2,800

3,400

-19,500

-7,300

-22,100

-28,800

1,600

6,300

20,900

22,400

8,100

-15,900

-13,100

-11,600

-3,000

9,000

0

0

0

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

1,582,900

-107,600

-67,700

31,500

-96,500

82,600

-5,500

-206,500

-36,600

-169,000

28,500

93,300

-56,400

287,600

-4,200

-143,200

30,600

-116,800

-13,000

123,600

-62,400

-129,600

-196,600

-188,200

-524,000

-818,600

70,400

70,300

470,300

-685,800

116,700

141,700

202,600

1,601,300

38,900

41,900

66,100

168,700

60,900

38,600

5,800

6,900

0

0

0