IQVIA HOLDINGS INC. IQV Cash Flow

Iqvia holdings inc. (IQV)

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	Jun'13	Mar'13	Dec'12	Sep'12	Jun'12	Mar'12
Operating activities:
Net income
91,000	20,000	69,000	71,000	67,000	76,000	67,000	68,000	73,000	1,035,000	93,000	66,000	102,000	-217,000	104,000	91,000	109,000	107,783	108,839	84,947	86,431	88,943	92,733	85,110	90,214	72,934	66,584	38,353	48,156	34,836	51,975	47,012	42,808
Adjustments to reconcile net income to cash provided by operating activities:
Depreciation and amortization
316,000	314,000	299,000	294,000	295,000	294,000	283,000	282,000	282,000	278,000	256,000	245,000	232,000	191,000	34,000	32,000	32,000	34,776	32,884	30,011	30,329	31,887	30,180	29,845	29,088	30,554	27,324	24,986	24,640	25,571	25,727	23,719	23,271
Amortization of debt issuance costs and discount
3,000	3,000	4,000	3,000	3,000	3,000	3,000	2,000	3,000	3,000	2,000	2,000	2,000	25,000	2,000	1,000	2,000	1,515	1,685	4,123	1,677	2,213	1,596	1,596	1,595	4,881	1,686	12,383	2,875	3,548	2,103	1,952	1,634
Amortization of accumulated other comprehensive loss on terminated interest rate swaps
-	-	-	-	-	-	-	-	-	0	0	0	3,000	0	0	0	3,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Stock-based compensation
0	59,000	27,000	34,000	26,000	35,000	31,000	26,000	21,000	24,000	29,000	27,000	26,000	46,000	15,000	10,000	9,000	9,298	8,381	10,747	9,574	7,612	6,787	8,380	7,221	5,866	5,869	6,618	4,473	12,197	3,260	3,083	7,386
Loss (gain) on disposals of property and equipment, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	262	296	833	-1,159	345	522
(Earnings) loss from unconsolidated affiliates
6,000	-	-	-	-1,000	2,000	2,000	5,000	6,000	14,000	3,000	4,000	-11,000	-3,000	1,000	-4,000	-2,000	35	5,362	1,692	911	-5,763	18,002	-3,348	-4,891	450	-2,780	3,009	-1,683	-236	897	265	1,573
Loss (gain) on investments, net
-8,000	-	-	2,000	3,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	194	-308	-154	5,268	121	57	-7	12	-	-	-	-
Benefit from deferred income taxes
-40,000	-3,000	-88,000	-54,000	-12,000	6,000	-69,000	-88,000	-26,000	-1,084,000	61,000	-146,000	-52,000	119,000	-1,000	-8,000	5,000	-5,252	23,627	509	-884	5,529	-10,356	414	-1,587	-8,353	-3,842	-23,205	11,164	14,070	-5,360	4,049	3,836
Excess income tax benefits from stock-based award activities
-	-	-	-	-	-	-	-	-	-	-	-	-	27,000	9,000	2,000	3,000	3,856	5,579	20,488	9,077	7,198	4,189	2,773	5,840	16,059	-264	213	196	85	0	229	151
Changes in operating assets and liabilities:
Change in accounts receivable, unbilled services and unearned income
84,000	-	115,000	-24,000	76,000	-	105,000	-64,000	178,000	-	31,000	-8,000	81,000	-	-65,000	104,000	-23,000	-	-7,215	114,034	63,460	-	57,153	10,550	51,018	-	-52,705	87,584	39,654	-	27,309	31,247	7,697
Change in other operating assets and liabilities
125,000	-	-128,000	-22,000	188,000	-	-136,000	35,000	-13,000	-	-29,000	-7,000	187,000	-	-23,000	-17,000	70,000	-	-108,126	-54,988	118,011	-	-78,718	41,694	87,951	-	-25,307	-52,117	74,291	-	-37,738	-34,961	64,351
Net cash provided by operating activities
163,000	583,000	330,000	391,000	113,000	417,000	344,000	311,000	182,000	233,000	436,000	245,000	56,000	447,000	260,000	41,000	112,000	206,624	282,946	50,762	-64,332	257,203	137,100	67,134	-28,437	215,460	176,526	22,843	-21,458	159,974	88,396	82,690	4,641
Investing activities:
Acquisition of property, equipment and software
141,000	137,000	149,000	155,000	141,000	138,000	123,000	110,000	88,000	102,000	89,000	100,000	78,000	86,000	21,000	31,000	26,000	21,308	24,768	15,492	16,432	25,218	21,950	18,126	17,706	14,407	13,663	28,818	31,459	21,983	15,425	22,782	11,146
Acquisition of businesses, net of cash acquired
14,000	127,000	260,000	26,000	175,000	54,000	28,000	207,000	20,000	329,000	257,000	118,000	150,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from disposition of property and equipment
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	373	659	853	375	595	906
Purchase of equity securities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-161	161	6,645	6,559
Proceeds from sale of equity securities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	139	0	0	5,861	0	0	0	60	-	-	-	70
Purchases of marketable securities, net
7,000	-	0	0	2,000	-	-	-	1,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Investments in unconsolidated affiliates, net of payments received
-17,000	-	-6,000	5,000	-2,000	-7,000	19,000	9,000	-4,000	-10,000	1,000	-7,000	1,000	4,000	3,000	8,000	2,000	7,160	1,409	889	2,542	1,863	-199	1,112	1,224	1,409	1,276	291	4,377	-9,255	1,042	9,411	2,448
Investments in equity securities
6,000	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from corporate owned life insurance policies
-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	21,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Investments in equity securities
-	-	-	-	-	-	-	-	-	-	-	-	1,000	-	0	2,000	37,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Change in restricted cash, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,077	-	-	-	850
Other
-1,000	0	-3,000	-1,000	-1,000	-	-	-	15,000	-	-	-	10,000	-2,000	-2,000	2,000	-1,000	111	-1,241	-204	-666	-	-1,033	-209	910	-	-	-	-	343	1,201	55	1,473
Net cash used in investing activities
-150,000	-280,000	-400,000	-195,000	-315,000	-178,000	-182,000	-330,000	-120,000	-416,000	-334,000	-200,000	-240,000	1,813,000	-22,000	-17,000	-43,000	-27,599	6,065	-27,158	-18,308	-27,073	-112,919	-19,029	-13,979	-12,184	-160,592	-27,206	-36,194	-12,564	-56,711	-41,458	-21,500
Financing activities:
Proceeds from issuance of debt
800,000	0	800,000	1,100,000	0	-	-	-	-	0	1,244,000	0	3,998,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,153,227	0	-20	287,810
Payment of debt issuance costs
11,000	0	36,000	11,000	0	-	-	-	-	-3,000	30,000	5,000	18,000	-	-	-	-	-28	171	21,838	19	-	-	-	-	-	-	-	-	-	-	-	-
Repayment of debt and principal payments on capital lease obligations
25,000	-	825,000	25,000	25,000	-	25,000	656,000	26,000	-	343,000	24,000	2,491,000	-	12,000	13,000	12,000	-	13,160	2,033,841	1,210	-	6,263	132	334	-	982	350,521	34,304	-	5,792	5,620	5,892
Proceeds from revolving credit facility
990,000	812,000	610,000	310,000	790,000	645,000	340,000	1,055,000	405,000	699,000	369,000	363,000	490,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayment of revolving credit facility
1,250,000	846,000	210,000	1,335,000	385,000	160,000	390,000	1,479,000	300,000	270,000	607,000	25,000	865,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
(Payments) proceeds related to employee stock option plans
41,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
(Payments) proceeds related to employee stock option plans
-	-4,000	3,000	3,000	9,000	-3,000	20,000	9,000	-11,000	5,000	17,000	40,000	29,000	54,000	28,000	10,000	5,000	5,677	13,015	26,814	18,494	11,799	11,888	5,397	5,916	12,175	111	104	149	-	-	-	-
Repurchase of common stock
345,000	270,000	298,000	236,000	145,000	604,000	133,000	573,000	95,000	368,000	558,000	378,000	1,316,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	443	2,454	1,252	9,214
Distributions to non-controlling interest, net
5,000	12,000	4,000	2,000	0	-	-	-	-	-	-2,000	2,000	3,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Contingent consideration and deferred purchase price payments
6,000	-1,000	1,000	4,000	16,000	0	0	10,000	14,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repurchase of stock options
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-415	0	0	8,415	-	-	-	-	-	-	-	-
Excess income tax benefits from stock-based award activities
-	-	-	-	-	-	-	-	-	-	-	-	-	27,000	9,000	3,000	2,000	3,856	5,579	20,488	9,077	7,198	4,189	2,773	5,840	16,059	-264	213	196	85	0	229	151
Dividends paid to common shareholders
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	241,703	0	0	326,148
Net cash provided by financing activities
107,000	-343,000	39,000	-200,000	228,000	-158,000	-201,000	-52,000	-41,000	45,000	93,000	-34,000	-176,000	-2,206,000	25,000	-98,000	-5,000	-270,728	5,263	-9,877	26,342	14,377	9,709	-157,093	3,007	-33,305	-1,516	139,737	-33,959	-80,021	-8,192	-5,367	-53,293
Effect of foreign currency exchange rate changes on cash
-30,000	14,000	-44,000	6,000	19,000	-17,000	-13,000	-10,000	-20,000	-6,000	6,000	29,000	24,000	-66,000	-8,000	-24,000	12,000	-12,743	-16,085	10,820	-31,992	-21,398	-25,324	4,075	2,647	-1,538	9,570	-3,945	-21,824	-5,971	6,575	-5,897	127
Increase in cash and cash equivalents
90,000	-26,000	-75,000	2,000	45,000	64,000	-52,000	-81,000	1,000	-144,000	201,000	40,000	-336,000	-12,000	255,000	-98,000	76,000	-104,446	278,189	24,547	-88,290	223,109	8,566	-104,913	-36,762	168,433	23,988	131,429	-113,435	61,418	30,068	29,968	-70,025