AGILENT TECHNOLOGIES, INC. A Cash Flow

Agilent technologies, inc. (A)

CashFlow / Quarterly

Jan'20	Oct'19	Jul'19	Apr'19	Jan'19	Oct'18	Jul'18	Apr'18	Jan'18	Oct'17	Jul'17	Apr'17	Jan'17	Oct'16	Jul'16	Apr'16	Jan'16	Oct'15	Jul'15	Apr'15	Jan'15	Oct'14	Jul'14	Apr'14	Jan'14	Oct'13	Jul'13	Apr'13	Jan'13	Oct'12	Jul'12	Apr'12	Jan'12	Oct'11	Jul'11	Apr'11	Jan'11	Oct'10	Jul'10	Apr'10	Jan'10	Oct'09	Jul'09	Apr'09	Jan'09
Cash flows from operating activities
Net income
197,000	194,000	191,000	182,000	504,000	195,000	236,000	205,000	-320,000	177,000	175,000	164,000	168,000	126,000	124,000	91,000	121,000	140,000	111,000	87,000	63,000	68,000	147,000	139,000	195,000	221,000	168,000	166,000	179,000	425,000	243,000	255,000	230,000	289,000	330,000	200,000	193,000	292,000	205,000	108,000	79,000	25,000	-19,000	-101,000	64,000
Adjustments to reconcile net income to net cash provided by (used in) operating activities:
Depreciation and amortization
79,000	76,000	55,000	53,000	54,000	56,000	53,000	50,000	51,000	52,000	51,000	54,000	55,000	56,000	60,000	64,000	66,000	60,000	62,000	63,000	68,000	93,000	98,000	97,000	96,000	95,000	91,000	92,000	94,000	94,000	84,000	61,000	62,000	63,000	63,000	64,000	63,000	67,000	60,000	36,000	39,000	40,000	41,000	40,000	41,000
Share-based compensation
27,000	15,000	17,000	16,000	24,000	14,000	13,000	12,000	31,000	12,000	13,000	15,000	20,000	11,000	11,000	13,000	23,000	11,000	10,000	11,000	22,000	19,000	19,000	22,000	36,000	19,000	17,000	18,000	31,000	15,000	16,000	16,000	27,000	14,000	14,000	16,000	28,000	15,000	13,000	13,000	25,000	15,000	17,000	18,000	21,000
Excess tax benefit from share-based plans
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	0	0	3,000	0	0	0	2,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Deferred taxes
10,000	12,000	5,000	9,000	-281,000	5,000	-8,000	-7,000	-6,000	19,000	63,000	4,000	16,000	-31,000	-1,000	31,000	4,000	86,000	-20,000	-2,000	6,000	-210,000	10,000	13,000	-5,000	-5,000	5,000	-2,000	-2,000	-160,000	6,000	-14,000	10,000	8,000	-8,000	34,000	4,000	-82,000	-72,000	-39,000	84,000	14,000	-20,000	29,000	5,000
Excess and obsolete inventory related charges
4,000	7,000	5,000	3,000	4,000	4,000	5,000	12,000	5,000	5,000	4,000	8,000	7,000	4,000	4,000	8,000	4,000	10,000	7,000	9,000	4,000	40,000	16,000	12,000	11,000	12,000	14,000	12,000	10,000	10,000	7,000	7,000	6,000	10,000	7,000	7,000	6,000	9,000	8,000	7,000	6,000	5,000	8,000	14,000	27,000
Unrealized Gain (Loss) on Investments
16,000	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Asset impairment charges
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,000	19,000	-	5,000	13,000	19,000
Other non-cash expense, net
-2,000	-2,000	-6,000	5,000	-3,000	-2,000	-9,000	1,000	1,000	-12,000	3,000	0	2,000	-31,000	8,000	10,000	-2,000	-3,000	-8,000	-2,000	-3,000	-16,000	14,000	-2,000	-6,000	5,000	-3,000	-3,000	-2,000	-3,000	0	-1,000	-1,000	1,000	-4,000	-3,000	-2,000	-21,000	21,000	0	0	-1,000	-5,000	5,000	-1,000
Changes in assets and liabilities:
Allowance for doubtful accounts
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	1,000	3,000
Accounts receivable
40,000	48,000	75,000	-39,000	22,000	56,000	30,000	-16,000	-5,000	110,000	19,000	-17,000	-31,000	14,000	0	4,000	15,000	25,000	15,000	-31,000	15,000	119,000	-3,000	43,000	-40,000	17,000	-34,000	56,000	-53,000	-41,000	-41,000	98,000	-35,000	-42,000	5,000	39,000	-13,000	275,000	-16,000	-51,000	-42,000	-436,000	40,000	63,000	140,000
Inventory
32,000	5,000	52,000	-33,000	12,000	17,000	100,000	0	-34,000	107,000	-17,000	-3,000	-26,000	18,000	2,000	-26,000	13,000	6,000	0	13,000	5,000	26,000	17,000	23,000	33,000	19,000	28,000	19,000	34,000	-22,000	10,000	18,000	46,000	16,000	53,000	54,000	85,000	73,000	-5,000	-16,000	-1,000	-84,000	24,000	35,000	-22,000
Accounts payable
-15,000	29,000	8,000	8,000	-16,000	49,000	5,000	-11,000	-3,000	-9,000	5,000	-3,000	9,000	12,000	26,000	-35,000	-18,000	21,000	-12,000	4,000	-39,000	79,000	-73,000	45,000	-1,000	20,000	-40,000	0	-7,000	-30,000	5,000	36,000	-42,000	1,000	-17,000	37,000	-56,000	28,000	30,000	47,000	8,000	56,000	-5,000	-5,000	-53,000
Employee compensation and benefits
-80,000	58,000	-22,000	58,000	-71,000	55,000	-17,000	55,000	-62,000	49,000	-18,000	50,000	-43,000	29,000	-1,000	34,000	-47,000	35,000	-20,000	27,000	-34,000	41,000	-36,000	66,000	-62,000	53,000	-36,000	69,000	-70,000	51,000	-82,000	79,000	-102,000	80,000	-70,000	95,000	-81,000	71,000	-72,000	79,000	-61,000	54,000	-32,000	34,000	-142,000
Change in assets and liabilities due to Tax Act
-	-	-	-	-	-19,000	-1,066,000	0	533,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Interest rate swap proceeds
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-86,000	0	0	43,000
Other assets and liabilities
195,000	29,000	60,000	-20,000	-26,000	-25,000	3,000	2,000	24,000	244,000	-70,000	-15,000	-61,000	37,000	-39,000	-24,000	16,000	97,000	23,000	36,000	93,000	-182,000	117,000	5,000	86,000	2,000	13,000	-32,000	9,000	-15,000	70,000	-28,000	31,000	20,000	44,000	-15,000	-33,000	-12,000	67,000	36,000	-126,000	245,000	-23,000	-9,000	-128,000
Net cash provided by (used in) operating activities
-59,000	314,000	242,000	252,000	213,000	372,000	197,000	303,000	215,000	288,000	228,000	257,000	116,000	234,000	194,000	254,000	111,000	241,000	108,000	183,000	-20,000	184,000	28,000	325,000	194,000	377,000	215,000	315,000	245,000	485,000	240,000	353,000	150,000	510,000	252,000	378,000	120,000	373,000	90,000	225,000	30,000	213,000	41,000	137,000	17,000
Cash flows from Investing activities:
Investments in property, plant and equipment
34,000	30,000	47,000	39,000	39,000	36,000	33,000	48,000	60,000	58,000	43,000	43,000	32,000	52,000	24,000	25,000	38,000	27,000	19,000	20,000	32,000	43,000	64,000	53,000	45,000	32,000	53,000	51,000	59,000	62,000	49,000	37,000	46,000	50,000	49,000	51,000	38,000	34,000	33,000	79,000	-25,000	30,000	30,000	34,000	34,000
Proceeds from lease receivable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	80,000	-	0	0	0	-	-	-	-	-	-	-	-
Proceeds from the sale of property, plant and equipment
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	1,000	1,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from the sale of investment securities
-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	1,000	0	0	0	0	-	-	-	-	1,000	0	0	11,000	0	0	2,000	3,000	2,000	0	9,000	5,000	0	30,000	4,000	4,000	13,000	19,000	42,000	20,000
Proceeds from divestitures
-	-	-	-	-	-	-	-	-	1,000	0	0	1,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payment to acquire cost method investment
1,000	2,000	3,000	16,000	2,000	0	10,000	0	1,000	1,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments in exchange for convertible note
0	1,000	0	1,000	1,000	0	0	2,000	0	-	-	-	-	0	0	0	1,000	0	2,000	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Purchase of other investments
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	10,000	0	0	15,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Change in restricted cash, cash equivalents and investments, net
-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-245,000	241,000	0	0	-1,000	5,000	-1,000	0	0	-	-	-	-	-	-	-	-	0	0	-12,000	-1,533,000	-5,000	-1,000	-6,000	2,000	-2,000	-4,000	-6,000	-4,000
Acquisitions of businesses and intangible assets, net of cash acquired
0	1,160,000	0	0	248,000	79,000	430,000	1,000	6,000	1,000	57,000	0	70,000	26,000	0	0	235,000	8,000	66,000	0	0	10,000	1,000	0	2,000	10,000	1,000	0	10,000	30,000	2,151,000	21,000	55,000	2,000	0	96,000	0	3,000	1,298,000	24,000	-12,000	0	0	1,000	1,000
Net cash used in investing activities
-35,000	-1,193,000	-51,000	-56,000	-290,000	-114,000	-473,000	-51,000	-67,000	-59,000	-101,000	-43,000	-101,000	-78,000	-24,000	-108,000	-28,000	-275,000	-87,000	-7,000	-31,000	-58,000	-70,000	-55,000	-47,000	-51,000	-54,000	-71,000	-72,000	-92,000	-2,200,000	-56,000	-18,000	-48,000	-32,000	-126,000	1,500,000	-43,000	-1,098,000	-2,000	-31,000	20,000	-6,000	-17,000	-11,000
Cash flows from financing activities:
Issuance of common stock under employee stock plans
32,000	2,000	19,000	11,000	22,000	3,000	17,000	11,000	25,000	8,000	32,000	8,000	18,000	3,000	27,000	8,000	24,000	1,000	17,000	32,000	8,000	52,000	41,000	22,000	73,000	45,000	48,000	16,000	52,000	10,000	29,000	19,000	42,000	5,000	95,000	68,000	136,000	35,000	40,000	121,000	103,000	18,000	26,000	1,000	26,000
Payment of taxes related to net share settlement of equity awards
33,000	1,000	1,000	1,000	13,000	1,000	0	1,000	28,000	1,000	0	1,000	12,000	0	1,000	0	5,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payment of dividends
56,000	-	51,000	52,000	52,000	-	48,000	48,000	48,000	-	42,000	43,000	42,000	-	37,000	37,000	38,000	-	33,000	33,000	34,000	-	44,000	44,000	44,000	-	41,000	41,000	35,000	-	35,000	35,000	0	-	-	-	-	-	-	-	-	-	-	-	-
Purchase of non-controlling interest
0	0	0	0	4,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	3,000	0	0	1,000	5,000	0	0	0	0	-	-	-	-	-	-	-	-
Proceeds from revolving credit facility
432,000	-	0	0	0	-	127,000	82,000	274,000	-	115,000	97,000	131,000	-	0	155,000	100,000	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	50,000	275,000
Repayments of revolving credit facility
372,000	-	-	-	0	-	-	-	-	-	-	-	-	-	0	0	20,000	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	100,000	225,000
Repayment of revolving credit facility
-	-	-	-	-	-	442,000	112,000	139,000	-	76,000	45,000	42,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	1,500,000	-	-	-	-	-	-	-	-
Repayment of finance lease
4,000	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayment of debt
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-
Treasury stock repurchases
60,000	49,000	549,000	50,000	75,000	86,000	243,000	46,000	47,000	0	0	83,000	111,000	46,000	94,000	94,000	200,000	0	99,000	162,000	6,000	0	50,000	50,000	100,000	0	681,000	140,000	79,000	94,000	0	44,000	34,000	35,000	192,000	0	270,000	52,000	94,000	165,000	100,000	0	0	32,000	125,000
Excess tax benefit from share-based plans
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	0	0	3,000	0	0	0	2,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Net transfer of cash and cash equivalents to Keysight
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-62,000	796,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in financing activities
-61,000	497,000	-582,000	-92,000	-122,000	-131,000	-589,000	-114,000	37,000	-106,000	29,000	-67,000	-58,000	-56,000	-105,000	32,000	-139,000	-33,000	-127,000	-101,000	-828,000	541,000	-518,000	-72,000	-68,000	6,000	-332,000	-165,000	-63,000	28,000	-7,000	-61,000	3,000	-30,000	-97,000	68,000	-1,634,000	-17,000	674,000	-59,000	3,000	761,000	26,000	-81,000	-49,000
Effect of exchange rate movements
-1,000	-1,000	1,000	-7,000	9,000	-12,000	-14,000	-16,000	25,000	-6,000	18,000	1,000	-5,000	-10,000	-5,000	30,000	-16,000	-5,000	-16,000	4,000	-31,000	-30,000	1,000	10,000	-12,000	13,000	-18,000	-10,000	-11,000	7,000	-6,000	-2,000	0	-6,000	3,000	17,000	3,000	19,000	5,000	1,000	0	6,000	18,000	-1,000	0
Net decrease in cash, cash equivalents and restricted cash
-156,000	-383,000	-390,000	97,000	-190,000	115,000	-879,000	122,000	210,000	117,000	174,000	148,000	-48,000	90,000	60,000	208,000	-72,000	-72,000	-122,000	79,000	-910,000	637,000	-559,000	208,000	67,000	345,000	-189,000	69,000	99,000	428,000	-1,973,000	234,000	135,000	426,000	126,000	337,000	-11,000	332,000	-329,000	165,000	2,000	1,000,000	79,000	38,000	-43,000
Supplemental cash flow information:
Income tax payments, net
241,000	51,000	4,000	83,000	21,000	16,000	38,000	16,000	32,000	7,000	15,000	14,000	27,000	13,000	33,000	-16,000	37,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Interest payments
17,000	19,000	25,000	11,000	25,000	12,000	25,000	14,000	29,000	13,000	29,000	11,000	29,000	7,000	29,000	8,000	29,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Non-cash changes in investments in property, plant and equipment - increase (decrease)
-9,000	5,000	-3,000	-10,000	-13,000	19,000	-3,000	-9,000	-12,000	12,000	9,000	2,000	6,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-