Agilent technologies, inc. (A)
CashFlow / TTM
Jan'20Oct'19Jul'19Apr'19Jan'19Oct'18Jul'18Apr'18Jan'18Oct'17Jul'17Apr'17Jan'17Oct'16Jul'16Apr'16Jan'16Oct'15Jul'15Apr'15Jan'15Oct'14Jul'14Apr'14Jan'14Oct'13Jul'13Apr'13Jan'13Oct'12Jul'12Apr'12Jan'12Oct'11Jul'11Apr'11Jan'11Oct'10Jul'10Apr'10Jan'10Oct'09Jul'09Apr'09Jan'09
Cash flows from operating activities
Net income

764,000

1,071,000

1,072,000

1,117,000

1,140,000

316,000

298,000

237,000

196,000

684,000

633,000

582,000

509,000

462,000

476,000

463,000

459,000

401,000

329,000

365,000

417,000

549,000

702,000

723,000

750,000

734,000

938,000

1,013,000

1,102,000

1,153,000

1,017,000

1,104,000

1,049,000

1,012,000

1,015,000

890,000

798,000

684,000

417,000

193,000

-16,000

-31,000

0

0

0

Adjustments to reconcile net income to net cash provided by (used in) operating activities:
Depreciation and amortization

263,000

238,000

218,000

216,000

213,000

210,000

206,000

204,000

208,000

212,000

216,000

225,000

235,000

246,000

250,000

252,000

251,000

253,000

286,000

322,000

356,000

384,000

386,000

379,000

374,000

372,000

371,000

364,000

333,000

301,000

270,000

249,000

252,000

253,000

257,000

254,000

226,000

202,000

175,000

156,000

160,000

162,000

0

0

0

Share-based compensation

75,000

72,000

71,000

67,000

63,000

70,000

68,000

68,000

71,000

60,000

59,000

57,000

55,000

58,000

58,000

57,000

55,000

54,000

62,000

71,000

82,000

96,000

96,000

94,000

90,000

85,000

81,000

80,000

78,000

74,000

73,000

71,000

71,000

72,000

73,000

72,000

69,000

66,000

66,000

70,000

75,000

71,000

0

0

0

Excess tax benefit from share-based plans

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

3,000

3,000

3,000

2,000

2,000

2,000

2,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Deferred taxes

36,000

-255,000

-262,000

-275,000

-291,000

-16,000

-2,000

69,000

80,000

102,000

52,000

-12,000

15,000

3,000

120,000

101,000

68,000

70,000

-226,000

-196,000

-181,000

-192,000

13,000

8,000

-7,000

-4,000

-159,000

-158,000

-170,000

-158,000

10,000

-4,000

44,000

38,000

-52,000

-116,000

-189,000

-109,000

-13,000

39,000

107,000

28,000

0

0

0

Excess and obsolete inventory related charges

19,000

19,000

16,000

16,000

25,000

26,000

27,000

26,000

22,000

24,000

23,000

23,000

23,000

20,000

26,000

29,000

30,000

30,000

60,000

69,000

72,000

79,000

51,000

49,000

49,000

48,000

46,000

39,000

34,000

30,000

30,000

30,000

30,000

30,000

29,000

30,000

30,000

30,000

26,000

26,000

33,000

54,000

0

0

0

Unrealized Gain (Loss) on Investments

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Asset impairment charges

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

0

0

0

Other non-cash expense, net

-5,000

-6,000

-6,000

-9,000

-13,000

-9,000

-19,000

-7,000

-8,000

-7,000

-26,000

-21,000

-11,000

-15,000

13,000

-3,000

-15,000

-16,000

-29,000

-7,000

-7,000

-10,000

11,000

-6,000

-7,000

-3,000

-11,000

-8,000

-6,000

-5,000

-1,000

-5,000

-7,000

-8,000

-30,000

-5,000

-2,000

0

20,000

-6,000

-1,000

-2,000

0

0

0

Changes in assets and liabilities:
Allowance for doubtful accounts

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Accounts receivable

124,000

106,000

114,000

69,000

92,000

65,000

119,000

108,000

107,000

81,000

-15,000

-34,000

-13,000

33,000

44,000

59,000

24,000

24,000

118,000

100,000

174,000

119,000

17,000

-14,000

-1,000

-14,000

-72,000

-79,000

-37,000

-19,000

-20,000

26,000

-33,000

-11,000

306,000

285,000

195,000

166,000

-545,000

-489,000

-375,000

-193,000

0

0

0

Inventory

56,000

36,000

48,000

96,000

129,000

83,000

173,000

56,000

53,000

61,000

-28,000

-9,000

-32,000

7,000

-5,000

-7,000

32,000

24,000

44,000

61,000

71,000

99,000

92,000

103,000

99,000

100,000

59,000

41,000

40,000

52,000

90,000

133,000

169,000

208,000

265,000

207,000

137,000

51,000

-106,000

-77,000

-26,000

-47,000

0

0

0

Accounts payable

30,000

29,000

49,000

46,000

27,000

40,000

-18,000

-18,000

-10,000

2,000

23,000

44,000

12,000

-15,000

-6,000

-44,000

-5,000

-26,000

32,000

-29,000

12,000

50,000

-9,000

24,000

-21,000

-27,000

-77,000

-32,000

4,000

-31,000

0

-22,000

-21,000

-35,000

-8,000

39,000

49,000

113,000

141,000

106,000

54,000

-7,000

0

0

0

Employee compensation and benefits

14,000

23,000

20,000

25,000

22,000

31,000

25,000

24,000

19,000

38,000

18,000

35,000

19,000

15,000

21,000

2,000

-5,000

8,000

14,000

-2,000

37,000

9,000

21,000

21,000

24,000

16,000

14,000

-32,000

-22,000

-54,000

-25,000

-13,000

3,000

24,000

15,000

13,000

-3,000

17,000

0

40,000

-5,000

-86,000

0

0

0

Change in assets and liabilities due to Tax Act

-

-

-

-

-

-552,000

-533,000

533,000

533,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Interest rate swap proceeds

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-43,000

0

0

0

Other assets and liabilities

264,000

43,000

-11,000

-68,000

-46,000

4,000

273,000

200,000

183,000

98,000

-109,000

-78,000

-87,000

-10,000

50,000

112,000

172,000

249,000

-30,000

64,000

33,000

26,000

210,000

106,000

69,000

-8,000

-25,000

32,000

36,000

58,000

93,000

67,000

80,000

16,000

-16,000

7,000

58,000

-35,000

222,000

132,000

87,000

85,000

0

0

0

Net cash provided by (used in) operating activities

749,000

1,021,000

1,079,000

1,034,000

1,085,000

1,087,000

1,003,000

1,034,000

988,000

889,000

835,000

801,000

798,000

793,000

800,000

714,000

643,000

512,000

455,000

375,000

517,000

731,000

924,000

1,111,000

1,101,000

1,152,000

1,260,000

1,285,000

1,323,000

1,228,000

1,253,000

1,265,000

1,290,000

1,260,000

1,123,000

961,000

808,000

718,000

558,000

509,000

421,000

408,000

0

0

0

Cash flows from Investing activities:
Investments in property, plant and equipment

150,000

155,000

161,000

147,000

156,000

177,000

199,000

209,000

204,000

176,000

170,000

151,000

133,000

139,000

114,000

109,000

104,000

98,000

114,000

159,000

192,000

205,000

194,000

183,000

181,000

195,000

225,000

221,000

207,000

194,000

182,000

182,000

196,000

188,000

172,000

156,000

184,000

121,000

117,000

114,000

69,000

128,000

0

0

0

Proceeds from lease receivable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

Proceeds from the sale of property, plant and equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,000

2,000

2,000

1,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from the sale of investment securities

-

-

-

-

-

-

-

-

-

-

-

-

-

1,000

1,000

1,000

1,000

0

0

0

0

-

-

-

-

12,000

11,000

11,000

13,000

5,000

7,000

7,000

14,000

16,000

14,000

44,000

39,000

38,000

51,000

40,000

78,000

94,000

0

0

0

Proceeds from divestitures

-

-

-

-

-

-

-

-

-

2,000

1,000

1,000

1,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payment to acquire cost method investment

22,000

23,000

21,000

28,000

12,000

11,000

12,000

2,000

2,000

1,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments in exchange for convertible note

2,000

3,000

2,000

2,000

3,000

2,000

0

0

0

-

-

-

-

1,000

1,000

3,000

3,000

2,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchase of other investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

25,000

15,000

15,000

15,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Change in restricted cash, cash equivalents and investments, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-245,000

-4,000

-4,000

-4,000

240,000

4,000

3,000

3,000

4,000

0

0

0

-

-

-

-

-

-

-

-

-1,545,000

-1,550,000

-1,551,000

-1,545,000

-10,000

-7,000

-10,000

-10,000

-16,000

0

0

0

Acquisitions of businesses and intangible assets, net of cash acquired

1,160,000

1,408,000

327,000

757,000

758,000

516,000

438,000

65,000

64,000

128,000

153,000

96,000

96,000

261,000

243,000

309,000

309,000

74,000

76,000

11,000

11,000

13,000

13,000

13,000

13,000

21,000

41,000

2,191,000

2,212,000

2,257,000

2,229,000

78,000

153,000

98,000

99,000

1,397,000

1,325,000

1,313,000

1,310,000

12,000

-11,000

2,000

0

0

0

Net cash used in investing activities

-1,335,000

-1,590,000

-511,000

-933,000

-928,000

-705,000

-650,000

-278,000

-270,000

-304,000

-323,000

-246,000

-311,000

-238,000

-435,000

-498,000

-397,000

-400,000

-183,000

-166,000

-214,000

-230,000

-223,000

-207,000

-223,000

-248,000

-289,000

-2,435,000

-2,420,000

-2,366,000

-2,322,000

-154,000

-224,000

1,294,000

1,299,000

233,000

357,000

-1,174,000

-1,111,000

-19,000

-34,000

-14,000

0

0

0

Cash flows from financing activities:
Issuance of common stock under employee stock plans

64,000

54,000

55,000

53,000

53,000

56,000

61,000

76,000

73,000

66,000

61,000

56,000

56,000

62,000

60,000

50,000

74,000

58,000

109,000

133,000

123,000

188,000

181,000

188,000

182,000

161,000

126,000

107,000

110,000

100,000

95,000

161,000

210,000

304,000

334,000

279,000

332,000

299,000

282,000

268,000

148,000

71,000

0

0

0

Payment of taxes related to net share settlement of equity awards

36,000

16,000

16,000

15,000

15,000

30,000

30,000

30,000

30,000

14,000

13,000

14,000

13,000

6,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payment of dividends

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Purchase of non-controlling interest

0

4,000

4,000

4,000

4,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,000

3,000

3,000

4,000

6,000

6,000

6,000

5,000

0

0

0

0

-

-

-

-

-

-

-

-

Proceeds from revolving credit facility

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

325,000

0

0

0

Repayments of revolving credit facility

0

-

-

-

0

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

325,000

0

0

0

Repayment of revolving credit facility

-

-

-

-

-

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,500,000

0

0

0

-

-

-

-

-

-

-

-

Repayment of finance lease

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayment of debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

Treasury stock repurchases

708,000

723,000

760,000

454,000

450,000

422,000

336,000

93,000

130,000

194,000

240,000

334,000

345,000

434,000

388,000

393,000

461,000

267,000

267,000

218,000

106,000

200,000

200,000

831,000

921,000

900,000

994,000

313,000

217,000

172,000

113,000

305,000

261,000

497,000

514,000

416,000

581,000

411,000

359,000

265,000

132,000

157,000

0

0

0

Excess tax benefit from share-based plans

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

3,000

3,000

3,000

2,000

2,000

2,000

2,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Net transfer of cash and cash equivalents to Keysight

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

734,000

734,000

734,000

796,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in financing activities

-238,000

-299,000

-927,000

-934,000

-956,000

-797,000

-772,000

-154,000

-107,000

-202,000

-152,000

-286,000

-187,000

-268,000

-245,000

-267,000

-400,000

-1,089,000

-515,000

-906,000

-877,000

-117,000

-652,000

-466,000

-559,000

-554,000

-532,000

-207,000

-103,000

-37,000

-95,000

-185,000

-56,000

-1,693,000

-1,680,000

-909,000

-1,036,000

601,000

1,379,000

731,000

709,000

657,000

0

0

0

Effect of exchange rate movements

-8,000

2,000

-9,000

-24,000

-33,000

-17,000

-11,000

21,000

38,000

8,000

4,000

-19,000

10,000

-1,000

4,000

-7,000

-33,000

-48,000

-73,000

-56,000

-50,000

-31,000

12,000

-7,000

-27,000

-26,000

-32,000

-20,000

-12,000

-1,000

-14,000

-5,000

14,000

17,000

42,000

44,000

28,000

25,000

12,000

25,000

23,000

23,000

0

0

0

Net decrease in cash, cash equivalents and restricted cash

-832,000

-866,000

-368,000

-857,000

-832,000

-432,000

-430,000

623,000

649,000

391,000

364,000

250,000

310,000

286,000

124,000

-58,000

-187,000

-1,025,000

-316,000

-753,000

-624,000

353,000

61,000

431,000

292,000

324,000

407,000

-1,377,000

-1,212,000

-1,176,000

-1,178,000

921,000

1,024,000

878,000

784,000

329,000

157,000

170,000

838,000

1,246,000

1,119,000

1,074,000

0

0

0

Supplemental cash flow information:
Income tax payments, net

379,000

159,000

124,000

158,000

91,000

102,000

93,000

70,000

68,000

63,000

69,000

87,000

57,000

67,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Interest payments

72,000

80,000

73,000

73,000

76,000

80,000

81,000

85,000

82,000

82,000

76,000

76,000

73,000

73,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash changes in investments in property, plant and equipment - increase (decrease)

-17,000

-21,000

-7,000

-7,000

-6,000

-5,000

-12,000

0

11,000

29,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-