Statement of Cash Flows Quarterly Data

Difficulty: Beginner

The cash flow statement provides information about a company's cash receipts and cash payments during an accounting period, showing how these cash flaws link the ending cash balance to the beginning balance shown on the company's statement of financial position.

The cash flow statement consists of three parts: cash flows provided by (used in) operating activities, cash flows provided by (used in) investing activities, and cash flows provided by (used in) financing activities.

Automatic Data Processing Inc., Consolidated Statement of Cash Flows (quarterly data)

USD $ in thousands

 
3 months ended Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012 Dec 31, 2011 Sep 30, 2011
Net earnings 643,100  467,500  401,500  265,800  588,000  510,900  368,700  282,000  532,500  341,400  336,600  336,200  489,600  331,500  295,200  288,800  521,500  377,000  328,600  227,000  482,700  390,800  305,300  258,400  452,400  375,000  302,700 
Depreciation and amortization 96,300  94,800  87,200  82,500  77,600  78,400  77,600  73,900  73,300  72,600  68,800  70,800  70,000  69,400  67,700  89,100  82,700  83,900  80,500  80,300  81,100  77,300  78,300  83,300  81,100  79,200  79,700 
Deferred income taxes 10,700  (39,100) 46,400  (12,200) (5,500) (4,200) 31,900  (21,700) (14,300) 7,300  29,400  24,800  (32,100) (17,300) 9,300  9,900  (56,900) (22,000) 18,700  21,200  800  (4,500) 7,100  30,200  700  (2,500) 9,700 
Stock-based compensation expense 41,700  38,700  39,000  37,700  34,300  35,800  31,100  35,200  31,700  36,000  34,700  32,500  35,800  36,200  38,700  36,500  35,600  39,100  27,200  32,100  22,400  24,300  17,600  12,600  20,400  27,100  18,600 
Excess tax benefit related to exercise of stock options and restricted stock (3,800) (10,900) (6,800) (15,900) (20,500) 500  (4,200) (44,200) (5,700)
Net pension expense 2,700  2,800  2,700  6,100  6,000  6,000  6,100  4,500  4,400  4,400  4,400  3,900  3,900  4,000  5,800  7,500  7,400  7,400  7,400  11,000  10,900  10,900  10,900  9,200  9,200  9,100  9,200 
Net amortization of premiums and accretion of discounts on available-for-sale securities 17,700  18,500  19,400  19,800  20,600  22,300  23,200  23,100  23,000  23,900  24,100  24,900  25,100  25,000  25,300  24,600  23,600  23,400  22,800  21,500  19,900  19,200  18,700  16,900  15,900  14,400  12,800 
Impairment losses on available-for-sale securities 5,800 
Impairment losses on assets held for sale 2,200 
Goodwill impairment 42,700 
Gain on sale of assets (66,000)
Gain on sale of building (13,900) (2,200)
Gain on sale of divested businesses, net of tax (121,400) (21,800) (78,400) (10,500) (36,700)
Other 7,200  5,200  9,600  12,300  11,200  5,400  8,200  7,800  13,100  4,000  5,800  7,100  3,200  (1,600) (6,900) 4,100  (700) (13,600) (27,900) (21,000) 1,500  (5,300) 5,200  (5,200) 13,200  (11,300) 300 
(Increase) decrease in accounts receivable 97,800  (255,400) (81,700) 113,500  29,600  (240,700) 121,000  321,200  (434,600) (78,900) (32,300) 37,800  (26,800) (213,900) 27,800  32,800  (107,900) (141,100) 12,200  127,200  (133,500) (137,300) (73,400) (23,200) (19,300) (103,900) 106,300 
(Increase) decrease in other assets 206,100  14,800  (259,500) (116,200) (8,800) 77,500  (221,600) 97,800  19,400  23,100  (249,200) (2,300) 98,200  19,400  (224,400) 27,600  35,900  (26,700) (290,000) 30,200  14,500  2,300  (330,500) 67,400  (15,900) (5,400) (117,700)
Increase (decrease) in accounts payable (28,400) 21,800  (24,500) 17,900  (13,400) 20,200  (36,300) (18,200) 20,300  1,500  (19,500) 29,300  (6,600) (500) (9,100) 22,300  5,700  (6,700) (11,600) 6,100  12,400  2,300  (31,400) 25,000  2,400  10,300  (26,500)
Increase (decrease) in accrued expenses and other liabilities 40,000  60,800  4,600  30,000  88,000  121,100  (80,100) (142,700) 450,200  (15,100) (71,900) (24,700) 195,800  (36,600) (12,400) 61,300  207,300  71,000  (86,600) (2,800) 105,600  106,100  (73,000) 30,200  100,900  99,800  (78,800)
Changes in operating assets and liabilities, net of effects from acquisitions and divestitures of businesses 315,500  (158,000) (361,100) 45,200  95,400  (21,900) (217,000) 258,100  55,300  (69,400) (372,900) 40,100  260,600  (231,600) (218,100) 144,000  141,000  (103,500) (376,000) 160,700  (1,000) (26,600) (508,300) 99,400  68,100  800  (116,700)
Proceeds from the sale of notes receivable 1,200  18,300  207,200 
Operating activities of discontinued operations (700) (800) (1,800) 200  1,300  100 
Adjustments to reconcile net earnings to cash flows provided by (used in) operating activities 491,800  (37,100) (156,800) 191,400  239,600  400  (38,900) 377,100  175,600  58,100  (243,400) 105,200  367,500  (102,600) 83,000  315,700  222,400  14,700  (247,300) 348,500  135,600  57,700  (370,400) 240,700  210,800  56,600  13,600 
Net cash flows provided by (used in) operating activities 1,134,900  430,400  244,700  457,200  827,600  511,300  329,800  659,100  708,100  399,500  93,200  441,400  857,100  228,900  378,200  604,500  743,900  391,700  81,300  575,500  618,300  448,500  (65,100) 499,100  663,200  431,600  316,300 
Purchases of corporate and client funds marketable securities (1,238,500) (1,296,900) (1,157,300) (912,800) (1,110,500) (1,188,400) (1,171,100) (1,635,400) (1,801,400) (1,579,700) (859,800) (1,681,500) (1,515,000) (956,900) (894,200) (1,333,100) (849,900) (862,800) (369,100) (1,065,000) (1,677,200) (1,394,900) (765,500) (1,463,300) (1,417,100) (1,138,000) (1,095,100)
Proceeds from the sales and maturities of corporate and client funds marketable securities 836,500  858,300  1,007,700  889,000  826,600  977,900  900,100  1,154,200  1,397,000  1,408,900  1,255,300  1,223,600  1,245,000  777,200  595,200  590,100  423,300  474,500  571,600  777,100  1,024,300  1,234,700  602,500  1,078,400  852,100  1,187,400  844,300 
Net (increase) decrease in restricted cash and cash equivalents held to satisfy client funds obligations 6,755,900  (3,125,300) (5,947,800) 9,160,800  7,751,700  (9,906,700) (5,925,400) (137,800) 4,172,700  6,247,600  (13,382,400) 1,500  5,828,700  2,551,200  (8,232,600) 2,390,500  7,735,400  (6,040,000) (2,800,000) 943,600  8,767,500  (5,910,100) (4,194,600) 6,192,200 
Capital expenditures (41,300) (45,000) (73,300) (65,700) (54,800) (71,000) (48,700) (40,900) (28,200) (43,800) (55,600) (51,300) (27,100) (44,300) (36,100) (53,800) (67,700) (48,700) (46,400) (52,300) (47,000) (44,800) (30,500) (35,700) (37,800) (33,200) (33,400)
Additions to intangibles (63,400) (62,700) (69,700) (68,300) (55,500) (49,400) (57,200) (57,400) (54,400) (60,300) (45,400) (45,100) (47,200) (40,500) (43,900) (40,000) (35,700) (42,600) (32,800) (26,900) (22,400) (25,500) (33,500) (27,000) (31,100) (27,400) (24,000)
Acquisitions of businesses, net of cash acquired (125,000) (487,400) (700) (66,700) (20,000) (8,100) (300) (15,700) (9,700) (26,700) (14,600) (700) (65,900) (23,500) (174,400) (1,900)
Proceeds from the sale of property, plant, and equipment and other assets 15,700  23,600  400  10,000  5,600  66,000 
Dividend received from CDK Global, Inc. 825,000 
Cash retained by CDK Global, Inc. (180,000)
Other (100) 100  (600) 1,300  (1,200) (15,400) 200 
Proceeds from the sale of divested businesses 234,000  (300) 162,500  98,600  24,400  161,400 
Investing activities of discontinued operations (800) (15,900) (500) (600)
Net cash flows (used in) provided by investing activities (631,700) (1,033,700) (292,600) 6,597,400  (3,586,200) (6,044,700) 8,763,900  7,172,200  (10,393,700) (6,184,900) 319,200  3,716,200  5,903,300  (13,646,900) 267,100  4,991,800  2,045,300  (8,727,900) 2,504,100  7,341,000  (6,775,600) (2,859,700) 715,900  8,258,400  (6,582,900) (4,314,000) 5,882,100 
Net increase (decrease) in client funds obligations (506,900) 8,881,400  (1,674,300) (6,757,300) 3,436,600  6,128,400  (8,928,300) (7,294,800) 10,304,500  6,068,700  (275,100) (3,736,900) (5,910,200) 15,674,200  47,300  (7,093,400) (2,141,600) 11,540,500  (5,295,000) (7,699,600) 6,694,200  3,364,300  (1,220,400) (8,387,800) 6,466,400  4,131,700  (5,936,900)
Net proceeds from debt issuance 12,000  (100) 1,986,400 
Payments of debt (500) (5,400) (900) (500) (500) (500) (500) (500) 200  (600) (600) (500) (600) (600) (600) (600) (600) (1,500) (600) (500) (8,300) (500) (8,200) (500) (500) (500) (500)
Repurchases of common stock (187,900) (158,200) (250,100) (302,800) (191,500) (436,700) (328,600) (64,700) (318,000) (464,900) (308,100) (429,500) (665,500) (401,000) (61,200) (208,300) (41,800) (114,200) (303,000) (245,300) (95,100) (112,400) (194,500) (341,400) (102,000) (48,700) (249,200)
Net proceeds from stock purchase plan and stock-based compensation plans 51,600  9,600  (15,100) 21,200  55,300  33,600  (14,400) 22,600  49,400  25,300  (22,000) 21,300  59,000  12,300  16,500  61,500  43,900  52,500  61,200  46,000  59,800  49,300  80,200  59,700  72,100  69,300  48,900 
Excess tax benefit related to exercise of stock options and restricted stock 3,800  10,900  6,800  15,900  20,500  (500) 4,200  44,200  5,700 
Dividends paid (278,400) (253,000) (253,700) (255,800) (257,100) (240,500) (241,800) (242,400) (242,400) (229,800) (229,000) (231,400) (234,900) (231,500) (229,800) (231,100) (231,200) (210,200) (210,600) (210,800) (210,400) (192,200) (192,100) (193,300) (192,500) (176,200) (177,700)
Net proceeds (repayments) from reverse repurchase agreements (129,400) 129,400  (344,600) 98,700  245,900  (13,500) (428,200) 441,700 
Net proceeds from issuance (repayments) of commercial paper borrowings (1,937,000) (236,000) 2,173,000  (2,477,000) 2,477,000 
Other (100) 100  (23,400) 23,400  4,900  (10,000) 9,100  34,800  1,600 
Financing activities of discontinued operations (100) 1,600 
Net cash flows provided by (used in) financing activities (922,100) 8,345,000  (2,064,700) (7,295,200) 3,042,800  5,484,300  (9,513,600) (7,576,100) 9,816,700  5,405,400  1,144,100  (4,333,100) (6,752,800) 13,120,600  (418,000) (5,294,000) (2,381,300) 8,454,600  (3,137,500) (7,862,700) 6,426,700  2,680,300  (1,093,300) (8,857,600) 6,243,500  3,975,600  (6,315,400)
Effect of exchange rate changes on cash, cash equivalents, restricted cash, and restricted cash equivalents 4,000  34,900  14,200  25,500  6,100  (22,300) 5,400  (5,500) 15,400  (9,800) (11,100) 6,200  (49,800) (27,500) (35,200) 10,300  (4,000) (300) 2,000  (2,400) (12,600) 4,400  11,800  (16,900) 10,000  (10,800) (23,500)
Net change in cash, cash equivalents, restricted cash, and restricted cash equivalents (414,900) 7,776,600  (2,098,400) (215,100) 290,300  (71,400) (414,500) 249,700  146,500  (389,800) 1,545,400  (169,300) (42,200) (324,900) 192,100  312,600  403,900  118,100  (550,100) 51,400  256,800  273,500  (430,700) (117,000) 333,800  82,400  (140,500)
Source: Automatic Data Processing Inc., Quarterly and Annual Reports
Item Description The company
Net cash flows provided by (used in) operating activities The net cash from (used in) all of the entity's operating activities, including those of discontinued operations, of the reporting entity. Operating activities generally involve producing and delivering goods and providing services. Operating activity cash flows include transactions, adjustments, and changes in value that are not defined as investing or financing activities. Automatic Data Processing Inc.'s net cash flows provided by (used in) operating activities increased from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.

Top