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) | |
| 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. |