Perrigo Company plc PRGO Cash Flow

Perrigo company plc (PRGO)

CashFlow / Quarterly

Mar'20	Dec'19	Sep'19	Jun'19	Mar'19	Dec'18	Sep'18	Jun'18	Mar'18	Dec'17	Sep'17	Jun'17	Mar'17	Dec'16	Sep'16	Jun'16	Mar'16	Dec'15	Sep'15	Jun'15	Mar'15	Dec'14	Sep'14	Jun'14	Mar'14	Dec'13	Sep'13
Cash Flows From (For) Operating Activities
Net income
106,400	-19,000	92,200	9,000	63,900	81,400	-67,400	36,200	80,800	73,200	44,400	-69,600	71,600	-1,359,100	-1,590,200	-534,300	-529,200	-70,100	112,600	-22,300	-22,200	70,200	96,300	159,400	48,100	-86,100	111,400
Adjustments to derive cash flows:
Depreciation and amortization
93,100	103,000	102,000	94,900	96,600	99,600	106,200	108,300	109,500	111,700	112,300	111,400	109,400	118,600	114,700	114,000	109,700	7,000	175,400	94,800	55,100	127,100	126,600	-31,500	127,200	62,700	47,700
Unrealized loss on equity method investments
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0
Loss on acquisition-related foreign currency derivatives
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	1,900	298,100	-	-	-	-	-	-
Share-based compensation
16,200	11,300	12,900	15,600	12,400	11,100	4,300	9,600	12,700	15,700	13,300	8,700	6,100	7,700	5,700	-6,200	15,800	8,500	14,300	8,000	7,500	7,400	8,800	6,100	4,900	7,700	5,900
Impairment charges
0	141,600	11,000	27,800	4,100	900	221,800	1,700	0	100	7,800	27,400	12,200	602,200	1,614,400	10,500	403,900	215,600	0	6,800	0	-	-	-	-	-	-
Change in financial assets
1,600	3,600	2,600	5,500	10,400	122,800	74,900	600	-9,600	-700	-2,600	-38,700	17,100	-1,115,600	-377,300	-910,900	-204,400	-116,600	173,900	-69,300	100,800	-	-	-	-	-	-
Loss on extinguishment of debt
-	-	-	-	-	-	-	0	-500	0	0	-135,200	0	0	-700	0	-400	-900	0	-900	0	-	-	-	-	-	-
Restructuring charges
0	-400	5,200	12,200	9,300	-2,200	18,000	3,700	1,500	6,300	3,900	12,100	38,700	13,100	6,600	5,900	5,400	24,700	2,200	-100	1,100	2,500	1,700	29,400	3,300	12,400	1,900
Income tax benefit from exercise of stock options
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,800
Excess tax benefit of stock transactions
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-500	-300	7,200
Deferred income taxes
6,700	-54,000	900	5,300	3,900	-9,500	5,800	-7,000	-7,200	-32,600	-8,200	37,900	-46,000	-316,800	-351,300	-144,500	-178,300	-105,800	-14,200	54,900	-34,700	-18,100	-20,100	-22,600	-21,700	9,200	-14,600
Amortization of debt premium
-700	-600	-800	-1,100	-1,900	-1,900	-2,500	-1,600	-2,100	-4,000	-6,600	-5,400	-6,400	-100	-8,400	-9,500	-6,700	-3,500	-6,700	-3,600	1,800	-	-	-	-	-	-
Other non-cash adjustments, net
-14,000	-11,900	12,100	13,000	13,400	-17,500	1,300	-7,000	12,100	24,500	-6,600	-19,500	-1,100	-1,000	6,400	26,500	1,600	14,900	3,200	5,500	-100	8,300	300	-	-	-	-
Subtotal
206,100	178,300	160,500	171,200	191,300	39,600	212,100	143,300	217,400	195,600	162,900	276,900	167,400	180,200	175,900	373,300	27,000	28,200	293,500	216,100	205,800	229,600	213,600	115,400	173,700	176,500	146,900
Increase (decrease) in cash due to:
Accounts receivable
67,600	128,600	-43,200	6,800	48,500	-800	-44,500	26,900	-2,600	35,200	13,400	-1,700	-50,100	113,600	-71,800	-23,900	-17,300	-6,300	-46,200	80,000	-32,300	61,800	-57,300	50,500	24,900	19,400	45,700
Inventories
-36,500	-11,300	0	40,800	37,500	-2,700	2,000	55,600	43,700	-12,300	23,700	5,100	-500	-75,600	-20,400	-300	-4,400	-27,400	57,000	-5,900	-2,100	-12,000	29,700	-65,000	-9,200	-22,500	12,000
Prepaid expenses
33,400	-	-	-	3,700	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Accounts payable
53,800	-16,700	-7,500	-34,200	75,400	-15,700	-44,700	31,700	57,500	-33,600	0	-8,500	2,500	-18,000	-10,700	-43,800	-3,200	-100	-194,000	149,400	18,000	-14,300	-32,500	27,500	18,400	-3,200	-67,600
Payroll and related taxes
-18,400	6,900	12,400	-3,100	-19,900	6,300	7,600	-9,500	-38,900	9,300	1,200	-27,800	-10,100	-1,100	-800	-1,800	-37,400	-15,400	-22,800	-2,800	-1,000	8,600	-34,900	-15,200	-54,000	22,300	-8,600
Accrued customer programs
-13,600	34,100	-29,900	8,900	-61,700	26,700	-35,100	16,600	17,300	50,400	-2,000	18,900	-32,700	59,800	-29,500	37,500	-81,700	34,800	-400	47,300	-27,800	33,700	18,100	30,500	9,800	45,300	27,500
Accrued liabilities
11,100	1,600	-5,600	-15,400	-3,800	10,200	-700	-6,400	-24,000	-29,000	30,600	-51,700	2,300	10,500	-36,100	-41,100	-12,800	46,600	61,500	-6,800	-2,500	51,400	600	14,200	6,800	-19,200	21,200
Accrued income taxes
3,800	-8,700	-29,100	-26,700	-10,000	128,100	-39,200	-27,200	6,400	55,400	24,300	-127,200	41,400	15,700	8,000	-188,500	185,700	-72,000	15,200	31,600	-42,900	17,800	14,600	10,000	29,100	-85,000	34,600
Other, net
6,500	-11,300	4,000	-7,000	-12,900	4,400	-1,500	-16,300	22,200	8,300	-16,800	-13,600	26,900	2,900	-20,000	28,600	800	-9,100	6,200	-22,500	3,800	4,400	12,000	-35,300	-12,400	18,200	-2,400
Subtotal
34,300	88,800	20,500	107,400	96,800	-154,700	68,100	61,000	45,000	-21,300	-33,800	186,100	-27,100	-26,000	-43,100	242,100	-71,500	-36,700	157,500	-167,100	25,600	-43,000	18,500	-116,800	-6,800	54,900	48,200
Net cash from operating activities
171,800	89,500	140,000	63,800	94,500	194,300	144,000	82,300	172,400	216,900	196,700	90,800	194,500	206,200	219,000	131,200	98,500	64,900	136,000	383,200	180,200	272,600	195,100	232,200	180,500	121,600	98,700
Cash Flows From (For) Investing Activities
Proceeds from royalty rights
1,800	-	-	-	1,200	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from royalty rights
-	-	-	-	-	2,300	1,100	300	10,000	900	700	400	85,300	94,200	89,600	86,500	83,400	84,900	81,400	81,100	87,800	-	-	-	-	-	-
Acquisitions of businesses, net of cash acquired
11,300	-	-	-	0	-	-	-	-	-	-	-	-	-9,400	17,100	3,300	416,400	386,500	405,100	2,094,800	4,000	83,000	0	-	-	-	-
Purchase of investment securities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	1,300	5,400	298,100	-	-	-	-	-	-
Proceeds from the Royalty Pharma contingent milestone
0	0	0	0	250,000	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Asset acquisitions
32,700	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Additions to property, plant and equipment
33,800	47,400	35,600	33,600	21,100	45,800	23,500	19,900	13,400	33,400	18,000	15,200	22,000	21,600	27,500	22,400	34,700	39,200	38,600	57,100	31,900	16,300	31,700	51,600	42,200	37,400	40,400
(Purchase) return of Investments
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0
Net proceeds from sale of business
-	-	-	-	-	5,200	-1,300	0	1,300	107,900	9,500	11,900	25,300	10,600	58,500	0	0	-	-	-	-	-	-	-	-	-	0
Proceeds from sale of the Tysabri® financial asset
-	-	-	-	-	-	-	-	-	0	4,400,000	0	-2,200,000	-	-	-	0	-	-	-	-	-	-	-	-	-	-
Other investing, net
-1,200	-	-	-	0	-	-	-	-	9,000	2,100	2,900	800	2,600	0	0	1,000	-1,300	5,000	-1,000	0	200	-1,000	-	-	-	-
Proceeds from sale of land
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	4,600
Net cash from (for) investing activities
-74,800	-106,300	-651,800	-68,100	230,100	-46,100	-51,500	-27,100	-2,100	66,000	-9,900	-5,800	2,287,800	94,500	38,400	60,800	-368,700	-259,400	-448,700	-2,075,200	-246,200	-125,900	-30,700	1,400	-46,200	-1,563,700	-35,800
Cash Flows From (For) Financing Activities
Issuances of long-term debt
-	-	-	-	-	0	0	0	431,000	0	0	0	0	0	0	0	1,190,300	0	0	0	0	-	-	-	-	-	-
Payments on long-term debt
0	0	317,100	146,600	12,300	12,500	12,700	12,800	444,500	367,300	14,600	2,215,500	13,600	13,400	517,100	14,400	14,300	14,000	14,300	875,400	13,600	895,000	39,500	35,000	35,000	1,965,000	0
Borrowings (repayments) of revolving credit agreements and other financing, net
102,000	-300	-396,700	397,800	-300	4,300	-500	-2,000	-6,200	6,800	0	-300	300	1,100	300	-88,000	-715,900	639,000	79,000	-55,400	3,400	-	-2,100	-	-	-	1,100
Deferred financing fees
-	-	-	-	-	0	0	0	2,400	600	200	3,600	400	0	400	900	1,500	300	0	0	3,300	-	-	0	0	24,000	24,800
Settlements of contingent consideration
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0
Issuance of ordinary shares
-	-	-	-	-	-	-	-	-	-	-	-	-	100	4,700	400	3,100	2,700	2,200	2,800	1,200	1,036,800	2,600	900	2,200	3,200	3,500
Excess tax benefit of stock transactions
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-500	-300	7,200
Repurchase of ordinary shares
-	-	-	-	-	0	135,000	156,900	108,100	0	133,300	58,200	0	-	-	-	-	491,000	9,000	-7,800	100	200	7,500	-7,500	200	0	7,300
Cash dividends
30,900	28,800	28,800	28,900	25,900	26,200	25,900	26,100	26,700	22,400	22,700	23,000	23,000	20,800	20,800	20,800	20,800	18,000	18,300	18,300	17,600	14,900	14,100	14,100	14,000	9,500	8,500
Other financing, net
-6,400	-2,600	-1,700	-2,800	-3,100	-200	-2,300	-1,800	-5,700	-400	-2,000	5,200	-500	8,700	-5,700	-8,200	-3,500	-12,500	4,100	-9,000	-1,600	-6,300	-700	-	-	-	-
Net cash from (for) financing activities
64,700	-31,500	-144,900	219,800	-41,600	-34,300	-175,400	-199,600	-162,600	-383,700	-172,500	-2,411,300	-37,200	-34,600	-539,600	-131,900	437,400	105,900	43,700	-955,200	-31,600	2,570,300	-61,300	-46,900	-47,500	1,151,200	-28,800
Effect of exchange rate changes on cash and cash equivalents
-5,600	4,100	-500	2,300	3,800	-7,000	600	-16,400	900	3,600	800	9,300	10,400	-6,500	3,100	-7,200	3,900	-100	-10,100	2,400	-68,100	-12,400	-11,100	3,400	1,500	-4,600	2,600
Net increase (decrease) in cash and cash equivalents
156,100	-44,200	-657,200	217,800	286,800	106,900	-82,300	-160,800	8,600	-97,200	15,100	-2,317,000	2,455,500	259,600	-279,100	52,900	171,100	-88,700	-279,100	-2,644,800	-165,700	2,704,600	92,000	190,100	88,300	-295,500	36,700
Supplemental Disclosures of Cash Flow Information
Cash paid/received during the year for:
Interest paid
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	78,000	6,200	81,100	5,200	51,700	5,200	43,700	5,600	47,400	1,700
Interest received
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	400	300	500	200	200	200	300	500	1,400	200
Income taxes paid
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	68,000	19,800	18,000	92,200	9,900	10,900	9,900	9,400	51,800	22,100
Income taxes refunded
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	700	1,000	500	1,600	7,000	500	700	0	2,800	800