EXPRESS SCRIPTS HOLDING CO. ESRX Cash Flow

Express scripts holding co. (ESRX)

CashFlow / TTM

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	Dec'11	Sep'11	Jun'11	Mar'11
Cash flows from operating activities:
Net income
4,910	4,681	4,607	4,531	3,640	3,524	3,445	3,427	2,766	2,705	2,584	2,499	0	0	0	-	-	-	-	1,872	1,877	1,835	1,438	1,330	1,112	1,041	1,222	1,278	0	0	0
Net loss from discontinued operations, net of tax
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-53	-54	-57	-34	-32	0	0	0	-	-	-	-
Net income from continuing operations
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,829	1,880	1,926	1,932	1,893	1,472	1,362	0	0	0	-	-	-	-
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization
1,958	1,909	1,855	1,802	1,887	1,975	2,074	2,154	2,242	2,287	2,327	2,359	2,312	2,276	2,246	2,242	2,281	2,348	2,399	2,447	2,425	2,421	2,406	1,871	1,335	786	255	253	0	0	0
Deferred income taxes
-1,638	-1,630	-1,691	-1,678	-410	-460	-437	-497	-525	-480	-460	-462	-428	-412	-509	-430	-470	-523	-470	-573	0	0	0	-	-	-	-	-	-	-	-
Employee stock-based compensation expense
111	108	104	99	103	104	106	107	112	117	118	117	115	111	109	111	115	132	140	164	0	0	0	-	-	-	-	-	-	-	-
Deferred financing fees
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	0	0	0
Other, net
-39	-29	-24	-43	-7	11	13	36	20	10	17	46	36	13	0	8	13	-43	8	-29	-52	-116	-105	-70	-293	-126	-114	-97	0	0	0
Changes in operating assets and liabilities, net of effects of acquisition:
Receivables
897	216	-208	-55	-57	-270	225	374	-427	896	945	770	1,090	1,424	2,037	2,042	1,360	776	-204	-1,254	-123	-1,032	-1,615	-345	-269	-198	113	206	0	0	0
Inventories
117	375	273	166	375	203	22	-64	-53	65	-152	-90	-59	-116	158	242	146	102	79	218	0	0	0	-	-	-	-	-	-	-	-
Other current and noncurrent assets
270	274	72	172	182	86	100	137	-174	-127	53	-78	163	249	43	170	89	-33	-81	-94	0	0	0	-	-	-	-	-	-	-	-
Claims and rebates payable
471	575	944	1,114	762	441	-170	-560	-21	422	1,028	909	923	644	1,579	1,720	1,355	1,745	-296	-672	-250	-1,080	-487	82	-484	-110	150	207	0	0	0
Accounts payable
77	456	368	-126	563	160	-72	436	494	861	619	318	350	414	257	271	429	346	290	15	0	0	0	-	-	-	-	-	-	-	-
Accrued expenses
-333	110	-371	-241	72	38	625	404	-45	5	92	-142	483	706	663	948	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Other noncurrent liabilities
46	123	157	90	104	57	-42	-68	-114	-217	-127	-102	62	138	121	112	-6	-17	-152	-148	0	0	0	-	-	-	-	-	-	-	-
Other net changes in operating assets and liabilities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	0	0	0
Net cash provided by operating activitiescontinuing operations
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	4,768	4,548	4,301	5,183	4,751	0	0	0	-	-	-	-
Net cash used in operating activitiesdiscontinued operations
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-11	0	2	29	30	0	0	0	-	-	-	-
Net cash flows provided by operating activities
4,358	5,498	5,862	5,351	6,230	5,810	5,168	4,919	5,544	4,857	5,318	4,848	4,898	4,540	4,376	4,549	4,559	5,164	4,248	4,757	4,549	4,304	5,212	4,781	2,587	2,749	2,480	2,193	0	0	0
Cash flows from investing activities:
Capital expenditures for property and equipment and computer software
331	337	322	267	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Acquisitions, net of cash acquired
3,404	3,404	3,524	3,501	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of property and equipment
-	-	-	-	-	-	-	-	0	0	330	-	286	334	367	436	475	436	431	423	332	291	250	160	148	154	143	144	0	0	0
Other, net
24	24	11	7	25	25	26	21	-0	-21	-49	-27	-36	-20	-3	-24	-30	-1	-2	3	14	-8	-1	4	4	-6	-8	-20	0	0	0
Net cash used in investing activitiescontinuing operations
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-70	-4	-142	-10,512	-10,428	0	0	0	-	-	-	-
Net cash used in investing activitiesdiscontinued operations
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-2	-3	-4	-6	-5	0	0	0	-	-	-	-
Net cash used in investing activities
-3,675	-3,682	-3,772	-3,690	-418	-425	-320	-351	-355	-325	-280	-268	-250	-314	-364	-411	-401	-156	-73	-72	-7	-148	-10,476	-10,391	-10,408	-10,433	-135	-123	0	0	0
Cash flows from financing activities:
Proceeds from long-term debt, net of discounts
-	-	-	-	-	-	-	5,986	5,986	1,991	7,491	5,500	0	0	0	-	-	-	-	-	-	-	-	7,458	0	0	0	-	-	-	-
Repayment of long-term debt
1,306	1,381	1,918	1,125	1,187	4,932	4,997	5,932	5,432	2,650	3,152	3,390	4,463	4,834	3,886	2,834	1,881	631	631	1,931	2,931	2,984	5,326	3,868	0	0	0	-	-	-	-
Treasury stock acquired
623	1,338	2,521	2,938	3,589	3,446	2,475	4,746	3,892	3,320	8,609	5,500	6,319	7,333	3,874	4,493	6,176	5,914	4,373	4,055	1,552	801	300	0	0	0	0	-	-	-	-
Net proceeds from employee stock plans
228	149	148	81	82	88	90	87	84	89	145	183	246	327	309	510	501	507	610	466	433	455	429	326	279	150	31	32	0	0	0
Commercial paper repayments, net
-0	-0	-0	194	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Excess tax benefit relating to employee stock-based compensation
-	-	-	-	-	-	-	-	0	0	32	-	71	76	74	94	94	93	93	42	38	44	33	45	31	18	29	28	0	0	0
Distributions paid to non-controlling interest
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	20	18	10	8	0	0	0	-	-	-	-
Other, net
-65	-48	-46	-44	-19	-53	-59	-72	-26	3	-20	-9	-69	-68	-61	-57	-78	-58	-23	-16	118	109	21	0	0	0	0	-	-	-	-
Net cash used in financing activities
-367	-1,220	-2,938	-2,433	-4,725	-4,357	-3,453	-4,677	-3,322	-3,925	-4,170	-3,217	-5,035	-6,332	-4,948	-4,289	-5,031	-3,500	-4,320	-5,494	-4,043	-4,216	-2,281	2,823	8,003	8,815	6,466	3,029	0	0	0
Effect of foreign currency translation adjustment
-5	-6	2	4	4	0	-1	1	0	-2	-1	-9	-9	-8	-7	-6	-4	-0	-6	-5	-5	-3	-0	2	3	-2	-1	-2	0	0	0
Less cash decrease attributable to discontinued operations
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	13	28	25	-42	-42	0	0	0	-	-	-	-
Net increase in cash and cash equivalents
309	589	-846	-767	1,091	1,028	1,392	-109	1,866	603	865	1,353	-396	-2,114	-944	-158	-887	1,493	-139	-801	521	-37	-7,588	-2,827	138	1,088	8,811	5,096	0	0	0