IQVIA HOLDINGS INC. IQV Cash Flow

Iqvia holdings inc. (IQV)

CashFlow / TTM

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
251	227	283	281	278	284	1,243	1,269	1,267	1,296	44	55	80	87	411	416	410	388	369	353	353	357	340	314	268	226	187	173	181	176	0	0	0
Adjustments to reconcile net income to cash provided by operating activities:
Depreciation and amortization
1,223	1,202	1,182	1,166	1,154	1,141	1,125	1,098	1,061	1,011	924	702	489	289	132	131	129	128	125	122	122	121	119	116	111	107	102	100	99	98	0	0	0
Amortization of debt issuance costs and discount
13	13	13	12	11	11	11	10	10	9	31	31	30	30	6	6	9	9	9	9	7	7	9	9	20	21	20	20	10	9	0	0	0
Amortization of accumulated other comprehensive loss on terminated interest rate swaps
-	-	-	-	-	-	-	-	-	3	3	3	3	3	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Stock-based compensation
120	146	122	126	118	113	102	100	101	106	128	114	97	80	43	36	37	38	36	34	32	30	28	27	25	22	29	26	23	25	0	0	0
Loss (gain) on disposals of property and equipment, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	0	0	0
(Earnings) loss from unconsolidated affiliates
0	-	-	-	8	15	27	28	27	10	-7	-9	-17	-8	-4	-0	5	8	2	14	9	4	10	-10	-4	-1	-1	1	-0	2	0	0	0
Loss (gain) on investments, net
0	-	-	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	5	4	5	5	0	0	0	0	-	-	-	-
Benefit from deferred income taxes
-185	-157	-148	-129	-163	-177	-1,267	-1,137	-1,195	-1,221	-18	-80	58	115	-9	15	23	18	28	-5	-5	-6	-19	-13	-36	-24	-1	-3	23	16	0	0	0
Excess income tax benefits from stock-based award activities
-	-	-	-	-	-	-	-	-	-	-	-	-	41	17	14	32	39	42	40	23	20	28	24	21	16	0	0	0	0	0	0	0
Changes in operating assets and liabilities:
Change in accounts receivable, unbilled services and unearned income
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
Change in other operating assets and liabilities
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
Net cash provided by operating activities
1,467	1,417	1,251	1,265	1,185	1,254	1,070	1,162	1,096	970	1,184	1,008	804	860	619	642	652	476	526	380	397	433	391	430	386	393	337	249	309	335	0	0	0
Investing activities:
Acquisition of property, equipment and software
582	582	583	557	512	459	423	389	379	369	353	285	216	164	99	103	87	78	81	79	81	83	72	63	74	88	95	97	91	71	0	0	0
Acquisition of businesses, net of cash acquired
427	588	515	283	464	309	584	813	724	854	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from disposition of property and equipment
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2	2	2	0	0	0
Purchase of equity securities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	13	0	0	0
Proceeds from sale of equity securities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	6	5	5	5	0	0	0	0	-	-	-	0
Purchases of marketable securities, net
0	-	0	0	0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Investments in unconsolidated affiliates, net of payments received
0	-	-10	15	19	17	14	-4	-20	-15	-1	1	16	17	20	18	11	12	6	5	5	4	3	5	4	7	-3	-3	5	3	0	0	0
Investments in equity securities
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from corporate owned life insurance policies
-	-	-	-	-	-	-	-	-	-	-	-	-	21	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Investments in equity securities
-	-	-	-	-	-	-	-	-	-	-	-	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Change in restricted cash, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	0
Other
-5	-5	0	0	0	-	-	-	0	-	-	-	8	-3	-0	-0	-2	-2	0	0	0	-	0	0	0	-	-	-	-	3	0	0	0
Net cash used in investing activities
-1,025	-1,190	-1,088	-870	-1,005	-810	-1,048	-1,200	-1,070	-1,190	1,039	1,351	1,534	1,731	-109	-81	-91	-67	-66	-185	-177	-173	-158	-205	-213	-236	-236	-132	-146	-132	0	0	0
Financing activities:
Proceeds from issuance of debt
2,700	1,900	0	0	0	-	-	-	-	5,242	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,441	0	0	0
Payment of debt issuance costs
58	47	0	0	0	-	-	-	-	50	0	0	0	-	-	-	-	22	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Repayment of debt and principal payments on capital lease obligations
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
Proceeds from revolving credit facility
2,722	2,522	2,355	2,085	2,830	2,445	2,499	2,528	1,836	1,921	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayment of revolving credit facility
3,641	2,776	2,090	2,270	2,414	2,329	2,439	2,656	1,202	1,767	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
(Payments) proceeds related to employee stock option plans
0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
(Payments) proceeds related to employee stock option plans
-	11	12	29	35	15	23	20	51	91	140	151	121	97	48	33	50	64	70	68	47	35	35	23	18	12	0	0	0	-	-	-	-
Repurchase of common stock
1,149	949	1,283	1,118	1,455	1,405	1,169	1,594	1,399	2,620	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	13	0	0	0
Distributions to non-controlling interest, net
23	18	0	0	0	-	-	-	-	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Contingent consideration and deferred purchase price payments
10	20	21	20	26	24	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repurchase of stock options
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	8	0	0	0	-	-	-	-	-	-	-	-
Excess income tax benefits from stock-based award activities
-	-	-	-	-	-	-	-	-	-	-	-	-	41	17	14	31	39	42	40	23	20	28	24	21	16	0	0	0	0	0	0	0
Dividends paid to common shareholders
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	567	0	0	0
Net cash provided by financing activities
-397	-276	-91	-331	-183	-452	-249	45	63	-72	-2,323	-2,391	-2,455	-2,284	-348	-368	-280	-249	36	40	-106	-130	-177	-188	107	70	24	17	-127	-146	0	0	0
Effect of foreign currency exchange rate changes on cash
-54	-5	-36	-5	-21	-60	-49	-30	9	53	-7	-21	-74	-86	-32	-40	-6	-50	-58	-67	-74	-40	-20	14	6	-17	-22	-25	-27	-5	0	0	0
Increase in cash and cash equivalents
-9	-54	36	59	-24	-68	-276	-23	98	-239	-107	-53	-191	221	128	151	274	110	437	167	38	90	35	50	287	210	103	109	8	51	0	0	0