Express scripts holding co. (ESRX)
CashFlow / Quarterly
Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16Dec'15Sep'15Jun'15Mar'15Dec'14Sep'14Jun'14Mar'14Dec'13Sep'13Jun'13Mar'13Dec'12Sep'12Jun'12Mar'12Dec'11Sep'11Jun'11Mar'11
Cash flows from operating activities:
Net income

1,073,800

879,400

625,900

2,330,900

845,000

805,500

550,300

1,439,800

728,500

727,100

532,200

778,900

667,400

606,100

447,100

-

-

-

-

506,000

438,100

550,500

378,100

511,000

395,900

153,000

270,200

293,100

324,700

334,200

326,500

Net loss from discontinued operations, net of tax

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-12,300

-15,500

-23,900

-1,900

-13,100

-18,800

-400

0

-

-

-

-

Net income from continuing operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

522,700

334,500

518,300

453,600

574,400

380,000

524,100

414,700

153,400

270,200

-

-

-

-

Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization

497,700

503,700

498,800

457,800

449,400

449,200

445,600

543,400

537,700

548,200

525,300

631,400

582,800

588,200

556,700

584,700

547,000

558,100

553,100

623,000

614,300

609,400

600,300

601,400

610,400

594,600

65,000

65,900

61,300

63,300

62,900

Deferred income taxes

-80,200

-61,500

-65,600

-1,431,400

-71,900

-122,300

-53,300

-163,400

-121,700

-99,500

-112,800

-191,600

-76,500

-79,800

-114,200

-157,600

-60,700

-176,500

-35,700

-197,500

-113,600

-123,900

-138,700

-

-

-

-

-

-

-

-

Employee stock-based compensation expense

29,000

28,400

32,300

21,600

25,900

25,000

27,100

25,100

27,200

26,800

27,900

30,300

32,400

27,500

26,900

28,700

27,900

26,400

28,000

33,500

44,200

34,700

52,300

-

-

-

-

-

-

-

-

Deferred financing fees

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

8,800

18,100

-

42,500

1,400

1,000

Other, net

-13,900

-6,700

-100

-19,100

-3,800

-1,800

-18,600

17,100

14,600

800

3,700

1,000

5,300

7,800

32,200

-8,800

-18,000

-5,000

40,100

-3,400

-74,900

47,100

2,000

-26,800

-138,600

57,700

37,200

-250,000

28,500

69,800

54,600

Changes in operating assets and liabilities, net of effects of acquisition:
Receivables

494,400

553,900

-255,800

105,300

-187,400

129,100

-102,900

103,300

-399,900

625,200

45,400

-698,400

923,800

674,700

-129,800

-377,900

1,257,300

1,287,600

-124,600

-1,059,500

673,200

306,000

-1,173,700

71,400

-236,600

-276,900

96,400

148,000

-165,500

34,300

189,300

Inventories

-124,200

265,300

-97,000

72,900

134,100

163,300

-203,600

281,600

-38,300

-17,700

-289,700

292,600

80,400

-235,900

-227,200

323,400

22,800

39,700

-143,800

227,500

-20,600

16,600

-4,600

-

-

-

-

-

-

-

-

Other current and noncurrent assets

61,900

254,300

-129,100

83,700

65,200

53,000

-29,400

94,000

-31,000

66,400

8,100

-218,000

15,900

247,600

-123,800

23,700

101,500

42,200

2,600

-56,900

-21,800

-5,800

-9,700

-

-

-

-

-

-

-

-

Claims and rebates payable

298,700

-77,800

-221,300

472,300

402,400

290,800

-50,600

119,900

81,100

-320,400

-441,400

659,100

525,000

285,300

-559,900

673,200

246,000

1,220,100

-418,900

308,100

636,300

-822,300

-794,300

730,000

-194,100

-229,400

-223,700

163,100

180,000

30,900

-166,500

Accounts payable

-378,900

843,700

215,300

-602,200

0

755,400

-280,000

88,400

-403,100

522,100

229,000

146,100

-35,700

280,200

-72,300

178,600

27,900

123,200

-58,000

336,400

-55,400

67,000

-332,100

-

-

-

-

-

-

-

-

Accrued expenses

-284,600

-326,100

-140,200

417,600

158,700

-807,500

-10,500

731,600

125,200

-220,400

-232,200

282,300

175,500

-133,300

-467,200

908,800

398,300

-176,800

-181,400

-

-

-

-

-

-

-

-

-

-

-

-

Other noncurrent liabilities

22,100

-5,700

84,400

-54,000

98,500

28,700

17,300

-39,900

50,900

-70,300

-9,300

-85,300

-52,500

19,900

15,700

79,700

23,200

2,800

6,700

-39,100

11,700

-131,500

10,500

-

-

-

-

-

-

-

-

Other net changes in operating assets and liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

136,900

-461,700

-

-154,300

6,600

-155,200

Net cash provided by operating activitiescontinuing operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,925,800

1,035,200

-156,100

964,000

2,705,700

788,200

725,100

532,100

-

-

-

-

Net cash used in operating activitiesdiscontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

9,300

4,700

-24,800

-600

21,200

6,900

2,400

0

-

-

-

-

Net cash flows provided by operating activities

759,400

717,300

1,511,600

1,369,800

1,899,900

1,081,200

1,000,400

2,248,900

1,480,400

438,900

751,200

2,874,000

793,000

899,900

281,400

2,924,400

435,100

735,500

454,000

2,935,100

1,039,900

-180,900

963,400

2,726,900

795,100

727,500

532,100

533,200

956,800

458,700

244,400

Cash flows from investing activities:
Capital expenditures for property and equipment and computer software

65,500

75,400

100,400

90,100

72,000

59,500

45,800

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisitions, net of cash acquired

0

3,300

23,100

3,378,400

0

122,700

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of property and equipment

-

-

-

-

-

-

-

-

79,100

75,900

82,600

-

70,000

58,800

48,300

109,600

118,200

91,700

117,100

148,400

79,700

86,100

108,800

58,300

38,000

45,200

18,700

46,300

44,000

34,600

19,500

Other, net

3,600

18,700

6,000

-3,900

3,800

5,200

2,300

13,900

4,200

6,200

-2,800

-8,200

-17,000

-21,900

19,700

-17,000

-1,000

-4,700

-2,000

-22,400

27,600

-5,700

4,400

-12,200

5,000

900

10,300

-12,000

-6,100

-700

-1,700

Net cash used in investing activitiescontinuing operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-82,100

127,800

-2,500

-113,200

-16,100

-11,100

-10,372,500

-29,000

-

-

-

-

Net cash used in investing activitiesdiscontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-1,400

-700

-1,300

-1,400

-2,700

0

-

-

-

-

Net cash used in investing activities

-69,100

-97,400

-129,500

-3,379,300

-75,800

-187,400

-48,100

-106,700

-83,300

-82,100

-79,800

-110,600

-53,000

-36,900

-68,000

-92,600

-117,200

-87,000

-115,100

-82,100

127,800

-3,900

-113,900

-17,400

-12,900

-10,332,400

-29,000

-34,300

-37,900

-33,900

-17,800

Cash flows from financing activities:
Proceeds from long-term debt, net of discounts

-

-

-

-

-

-

-

0

3,995,800

0

1,991,000

0

0

5,500,000

0

-

-

-

-

-

-

-

-

0

105,300

3,894,700

3,458,900

-

-

-

-

Repayment of long-term debt

0

0

831,400

475,000

75,000

537,500

37,500

537,500

3,820,000

602,800

972,200

37,500

1,037,500

1,105,300

1,210,500

1,110,600

1,407,900

157,800

158,000

157,900

157,900

157,900

1,457,900

1,157,900

210,500

2,500,100

0

-

-

-

-

Treasury stock acquired

0

0

420,700

202,300

715,700

1,182,600

837,400

854,200

572,500

211,000

3,109,200

0

0

5,500,000

0

819,500

1,013,600

2,041,700

618,200

2,502,700

751,500

501,000

300,000

0

0

0

0

-

-

-

-

Net proceeds from employee stock plans

92,700

23,900

82,300

29,700

13,800

23,000

14,500

31,200

20,100

24,800

11,100

28,100

25,500

80,700

48,800

91,100

107,300

61,800

250,300

82,400

112,600

165,100

105,900

49,500

135,400

139,000

2,100

3,300

5,800

20,500

2,600

Commercial paper repayments, net

0

0

-195,000

194,800

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefit relating to employee stock-based compensation

-

-

-

-

-

-

-

-

1,400

1,500

8,200

-

4,700

14,500

33,800

18,600

9,500

13,000

52,900

19,500

8,400

12,600

2,200

14,900

14,800

1,700

13,900

1,000

1,400

12,900

13,000

Distributions paid to non-controlling interest

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4,600

9,100

4,300

2,800

1,900

1,400

2,000

-

-

-

-

Other, net

-23,600

-12,600

-7,200

-22,400

-6,200

-10,200

-6,100

3,300

-40,300

-16,100

-19,300

49,500

-11,100

-39,100

-8,600

-10,800

-10,400

-31,400

-4,400

-32,100

9,100

4,300

2,000

103,200

0

-83,400

-19,800

-

-

-

-

Net cash used in financing activities

69,100

11,300

-1,372,000

923,700

-783,100

-1,707,300

-866,500

-1,368,300

-415,500

-803,600

-2,090,400

-12,900

-1,018,400

-1,049,200

-1,136,500

-1,831,200

-2,315,100

334,000

-477,400

-2,572,800

-783,900

-486,000

-1,652,100

-1,121,800

-956,500

1,448,800

3,453,100

4,057,700

-144,600

-899,300

15,600

Effect of foreign currency translation adjustment

4,000

-6,500

-2,100

-500

2,400

2,200

800

-1,400

-1,300

100

3,800

-2,400

-4,400

1,400

-3,700

-2,800

-3,200

2,300

-2,500

-1,200

700

-3,700

-1,500

-600

2,800

-1,600

1,400

900

-2,700

-600

200

Less cash decrease attributable to discontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-9,900

-4,100

26,900

500

4,800

-6,400

-40,900

0

-

-

-

-

Net increase in cash and cash equivalents

763,400

624,700

8,000

-1,086,300

1,043,400

-811,300

86,600

772,500

980,300

-446,700

-1,415,200

2,748,100

-282,800

-184,800

-926,800

997,800

-2,000,400

984,800

-141,000

269,100

380,400

-647,600

-803,600

1,591,900

-177,900

-8,198,600

3,957,600

4,557,500

771,600

-475,100

242,400