Analysis of Short-term (Operating) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Short-term Activity Ratios (Summary)
Automatic Data Processing Inc., short-term (operating) activity ratios (quarterly data)
Based on: 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-K (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-K (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-Q (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Automatic Data Processing Inc. receivables turnover ratio improved from Q1 2022 to Q2 2022 but then deteriorated significantly from Q2 2022 to Q3 2022. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Automatic Data Processing Inc. payables turnover ratio decreased from Q1 2022 to Q2 2022 but then increased from Q2 2022 to Q3 2022 exceeding Q1 2022 level. |
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Automatic Data Processing Inc. working capital turnover ratio improved from Q1 2022 to Q2 2022 and from Q2 2022 to Q3 2022. |
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Automatic Data Processing Inc. number of days of receivables outstanding improved from Q1 2022 to Q2 2022 but then deteriorated significantly from Q2 2022 to Q3 2022. |
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. |
Receivables Turnover
Automatic Data Processing Inc., receivables turnover calculation (quarterly data)
| Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | 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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||||||||
| Revenues | 4,513,000) | 4,025,400) | 3,832,300) | 3,737,000) | 4,102,000) | 3,695,700) | 3,470,700) | 3,376,800) | 4,047,800) | 3,669,500) | 3,495,700) | 3,498,700) | 3,847,400) | 3,505,900) | 3,323,200) | 3,318,600) | 3,693,000) | 3,235,400) | 3,078,800) | 3,064,800) | 3,410,800) | 2,987,300) | 2,916,900) | 2,898,200) | 3,248,600) | 2,807,000) | 2,714,000) | ||||||||
| Accounts receivable, net of allowance for doubtful accounts | 3,250,700) | 2,736,000) | 2,769,700) | 2,727,400) | 2,765,400) | 2,509,800) | 2,489,100) | 2,441,300) | 2,620,600) | 2,587,900) | 2,490,400) | 2,439,300) | 2,485,200) | 2,638,100) | 2,216,400) | 1,984,200) | 2,043,400) | 2,045,500) | 1,788,700) | 1,703,600) | 1,811,500) | 1,839,500) | 1,620,600) | 1,742,800) | 2,074,400) | 1,634,200) | 1,565,200) | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Receivables turnover1 | 4.96 | 5.74 | 5.55 | 5.50 | 5.30 | 5.81 | 5.85 | 5.98 | 5.61 | 5.61 | 5.76 | 5.81 | 5.63 | 5.25 | 6.12 | 6.72 | 6.40 | 6.25 | 7.01 | 7.27 | 6.74 | 6.55 | 7.32 | 6.69 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Receivables Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| Adobe Inc. | 9.98 | 10.51 | 9.58 | 8.41 | 9.77 | 9.74 | 9.00 | 9.20 | 9.44 | 8.82 | 8.40 | 7.28 | 7.76 | 7.94 | 7.12 | 6.86 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| International Business Machines Corp. | 10.95 | 10.17 | 9.79 | 8.49 | 9.23 | 9.57 | 10.72 | 10.32 | 12.30 | 11.54 | 11.05 | 9.80 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | 17.44 | 12.84 | 25.10 | 24.64 | 16.04 | 16.60 | 79.16 | 51.54 | 31.31 | 11.82 | 66.66 | 77.98 | 25.87 | 11.61 | 79.14 | 60.86 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Microsoft Corp. | 5.90 | 5.52 | 6.44 | 4.42 | 6.08 | 5.61 | 6.44 | 4.47 | 6.11 | 5.71 | 6.80 | 4.26 | 6.34 | 6.02 | 6.61 | 4.17 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Oracle Corp. | 9.12 | 9.28 | 9.11 | 7.48 | 8.56 | 8.91 | 8.57 | 7.04 | 9.55 | 9.77 | 10.35 | 7.69 | 9.92 | 10.01 | 10.68 | 7.55 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Palo Alto Networks Inc. | 4.17 | 5.10 | 5.61 | 3.43 | 5.20 | 5.65 | 5.30 | 3.29 | 4.88 | 5.78 | 6.04 | 4.98 | 6.75 | 6.25 | 6.34 | 4.86 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Salesforce Inc. | 6.22 | 5.78 | 7.04 | 2.73 | 6.12 | 5.63 | 5.93 | 2.77 | 6.16 | 6.32 | 6.51 | 2.70 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| ServiceNow Inc. | 7.71 | 7.74 | 7.59 | 4.24 | 7.13 | 6.62 | 7.49 | 4.48 | 6.69 | 6.26 | 6.04 | 4.14 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Synopsys Inc. | 7.25 | 6.58 | 4.34 | 7.40 | 7.06 | 6.51 | 4.84 | 4.72 | 5.50 | 5.36 | 4.22 | 6.07 | 7.23 | 6.14 | 4.16 | 5.63 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-K (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-K (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-Q (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30).
1 Q3 2022 Calculation
Receivables turnover
= (RevenuesQ3 2022
+ RevenuesQ2 2022
+ RevenuesQ1 2022
+ RevenuesQ4 2021)
÷ Accounts receivable, net of allowance for doubtful accounts
= (4,513,000 + 4,025,400 + 3,832,300 + 3,737,000)
÷ 3,250,700 = 4.96
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Automatic Data Processing Inc. receivables turnover ratio improved from Q1 2022 to Q2 2022 but then deteriorated significantly from Q2 2022 to Q3 2022. |
Payables Turnover
Automatic Data Processing Inc., payables turnover calculation (quarterly data)
| Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | 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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||||||||
| Costs of revenues | 2,512,200) | 2,341,200) | 2,222,600) | 2,205,500) | 2,278,100) | 2,122,400) | 2,034,300) | 2,067,100) | 2,239,100) | 2,094,100) | 2,044,800) | 2,020,600) | 2,111,800) | 2,013,700) | 1,940,500) | 1,952,100) | 2,077,400) | 1,946,700) | 1,866,400) | 1,847,400) | 1,911,000) | 1,767,800) | 1,743,600) | 1,698,600) | 1,812,700) | 1,682,500) | 1,646,500) | ||||||||
| Accounts payable | 81,700) | 103,500) | 77,800) | 141,100) | 112,200) | 113,900) | 111,200) | 102,000) | 115,500) | 132,900) | 108,800) | 125,500) | 156,300) | 151,300) | 131,800) | 135,400) | 105,700) | 136,800) | 112,600) | 149,700) | 126,500) | 137,400) | 117,800) | 152,300) | 158,400) | 138,700) | 146,500) | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Payables turnover1 | 113.60 | 87.41 | 113.48 | 61.24 | 75.77 | 74.30 | 75.85 | 82.80 | 72.72 | 62.24 | 75.28 | 64.44 | 51.30 | 52.77 | 60.07 | 57.92 | 73.21 | 55.35 | 65.65 | 48.56 | 56.29 | 51.11 | 58.89 | 44.91 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Payables Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| Accenture PLC | 16.93 | 17.22 | 16.45 | 15.03 | 16.92 | 17.94 | 20.16 | 22.48 | 21.75 | 20.11 | 19.17 | 18.16 | 19.00 | 20.14 | 21.74 | 21.62 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Adobe Inc. | 6.66 | 5.53 | 6.54 | 5.98 | 5.40 | 5.60 | 6.76 | 5.63 | 7.62 | 6.00 | 6.52 | 7.98 | 8.45 | 8.63 | 9.18 | 6.42 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| International Business Machines Corp. | 7.35 | 7.40 | 7.69 | 6.54 | 6.71 | 7.47 | 8.35 | 7.75 | 9.76 | 8.36 | 9.63 | 8.30 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | 2.52 | 2.31 | 3.47 | 2.70 | 2.56 | 2.82 | 5.25 | 4.52 | 3.48 | 2.78 | 4.45 | 4.26 | 2.92 | 2.67 | 4.92 | 5.49 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Microsoft Corp. | 3.74 | 3.76 | 3.70 | 3.44 | 3.77 | 3.80 | 3.73 | 3.68 | 4.78 | 4.92 | 5.06 | 4.57 | 5.60 | 5.47 | 4.70 | 4.45 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Oracle Corp. | 7.65 | 8.03 | 10.79 | 10.54 | 9.49 | 10.71 | 14.72 | 12.46 | 15.07 | 15.07 | 16.46 | 13.78 | 13.45 | 13.86 | 15.37 | 15.28 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Palo Alto Networks Inc. | 14.68 | 12.25 | 14.46 | 22.41 | 16.80 | 25.37 | 21.85 | 15.72 | 17.72 | 15.76 | 11.28 | 11.03 | 11.31 | 26.19 | 15.99 | 13.06 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| ServiceNow Inc. | 7.86 | 5.60 | 8.57 | 15.20 | 19.64 | 11.82 | 9.75 | 28.83 | 17.87 | 10.13 | 11.28 | 15.04 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-K (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-K (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-Q (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30).
1 Q3 2022 Calculation
Payables turnover
= (Costs of revenuesQ3 2022
+ Costs of revenuesQ2 2022
+ Costs of revenuesQ1 2022
+ Costs of revenuesQ4 2021)
÷ Accounts payable
= (2,512,200 + 2,341,200 + 2,222,600 + 2,205,500)
÷ 81,700 = 113.60
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Automatic Data Processing Inc. payables turnover ratio decreased from Q1 2022 to Q2 2022 but then increased from Q2 2022 to Q3 2022 exceeding Q1 2022 level. |
Working Capital Turnover
Automatic Data Processing Inc., working capital turnover calculation (quarterly data)
| Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | 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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||||||||
| Current assets | 63,903,800) | 51,107,300) | 52,047,900) | 40,741,800) | 46,752,400) | 41,662,300) | 34,815,400) | 31,564,100) | 35,708,700) | 41,365,000) | 29,508,500) | 34,342,300) | 40,924,000) | 31,682,600) | 29,955,900) | 32,050,000) | 38,714,000) | 39,350,000) | 31,002,600) | 32,658,700) | 39,514,400) | 35,808,100) | 30,124,200) | 39,500,400) | 46,819,000) | 35,659,200) | 30,176,100) | ||||||||
| Less: Current liabilities | 63,106,500) | 49,084,000) | 49,669,900) | 38,094,800) | 44,615,200) | 39,176,500) | 32,329,600) | 30,126,600) | 34,672,800) | 40,522,400) | 29,200,900) | 32,627,700) | 39,166,000) | 30,296,900) | 29,037,300) | 30,413,600) | 36,741,200) | 37,250,900) | 28,286,600) | 29,815,900) | 36,418,500) | 32,956,300) | 26,719,300) | 35,847,400) | 43,250,400) | 32,468,100) | 26,587,300) | ||||||||
| Working capital | 797,300) | 2,023,300) | 2,378,000) | 2,647,000) | 2,137,200) | 2,485,800) | 2,485,800) | 1,437,500) | 1,035,900) | 842,600) | 307,600) | 1,714,600) | 1,758,000) | 1,385,700) | 918,600) | 1,636,400) | 1,972,800) | 2,099,100) | 2,716,000) | 2,842,800) | 3,095,900) | 2,851,800) | 3,404,900) | 3,653,000) | 3,568,600) | 3,191,100) | 3,588,800) | ||||||||
| Revenues | 4,513,000) | 4,025,400) | 3,832,300) | 3,737,000) | 4,102,000) | 3,695,700) | 3,470,700) | 3,376,800) | 4,047,800) | 3,669,500) | 3,495,700) | 3,498,700) | 3,847,400) | 3,505,900) | 3,323,200) | 3,318,600) | 3,693,000) | 3,235,400) | 3,078,800) | 3,064,800) | 3,410,800) | 2,987,300) | 2,916,900) | 2,898,200) | 3,248,600) | 2,807,000) | 2,714,000) | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Working capital turnover1 | 20.20 | 7.76 | 6.46 | 5.67 | 6.85 | 5.87 | 5.86 | 10.15 | 14.20 | 17.22 | 46.64 | 8.27 | 7.96 | 9.99 | 14.77 | 8.14 | 6.63 | 6.09 | 4.62 | 4.35 | 3.94 | 4.23 | 3.49 | 3.19 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| Accenture PLC | 13.41 | 15.55 | 15.85 | 12.77 | 7.71 | 8.35 | 7.70 | 8.71 | 10.32 | 10.56 | 9.98 | 9.85 | 11.92 | 11.77 | 12.53 | 12.12 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Adobe Inc. | 16.36 | 31.92 | 57.86 | 9.09 | 6.22 | 7.44 | 8.67 | 4.89 | 5.51 | 8.11 | 9.50 | — | — | — | — | 16.24 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| International Business Machines Corp. | — | — | — | — | — | — | — | — | 40.51 | 49.97 | — | 107.30 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | 5.68 | 21.87 | 4.39 | 3.85 | 3.40 | 5.45 | 1.74 | 1.73 | 3.19 | 4.80 | 4.93 | 4.17 | 3.46 | 10.00 | 9.43 | 20.71 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Microsoft Corp. | 2.52 | 1.91 | 1.88 | 1.76 | 1.71 | 1.44 | 1.37 | 1.30 | 1.24 | 1.25 | 1.20 | 1.19 | 1.15 | 1.11 | 1.06 | 0.99 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Oracle Corp. | 3.86 | 3.39 | 1.70 | 1.29 | 1.69 | 1.58 | 1.26 | 1.12 | 2.25 | 1.98 | 1.68 | 1.42 | 1.34 | 1.09 | 0.84 | 0.70 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Palo Alto Networks Inc. | — | — | — | — | 3.52 | — | 2.15 | 1.40 | 4.81 | 1.80 | 1.89 | 1.80 | 1.60 | 1.60 | 1.21 | 1.14 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Salesforce Inc. | 27.10 | — | 4.36 | 5.11 | 7.48 | 10.29 | 9.75 | 15.29 | 28.71 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| ServiceNow Inc. | 6.63 | 11.21 | 10.61 | 21.76 | 11.15 | 16.31 | 5.62 | 5.76 | 3.73 | 8.10 | 43.84 | 46.69 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Synopsys Inc. | 14.02 | 7.78 | 9.47 | 10.65 | 9.50 | 9.18 | 16.88 | 9.00 | 27.06 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-K (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-K (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-Q (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30).
1 Q3 2022 Calculation
Working capital turnover
= (RevenuesQ3 2022
+ RevenuesQ2 2022
+ RevenuesQ1 2022
+ RevenuesQ4 2021)
÷ Working capital
= (4,513,000 + 4,025,400 + 3,832,300 + 3,737,000)
÷ 797,300 = 20.20
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Automatic Data Processing Inc. working capital turnover ratio improved from Q1 2022 to Q2 2022 and from Q2 2022 to Q3 2022. |
Average Receivable Collection Period
Automatic Data Processing Inc., average receivable collection period calculation (quarterly data)
| Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | 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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||||||||
| Receivables turnover | 4.96 | 5.74 | 5.55 | 5.50 | 5.30 | 5.81 | 5.85 | 5.98 | 5.61 | 5.61 | 5.76 | 5.81 | 5.63 | 5.25 | 6.12 | 6.72 | 6.40 | 6.25 | 7.01 | 7.27 | 6.74 | 6.55 | 7.32 | 6.69 | — | — | — | ||||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||||||||
| Average receivable collection period1 | 74 | 64 | 66 | 66 | 69 | 63 | 62 | 61 | 65 | 65 | 63 | 63 | 65 | 70 | 60 | 54 | 57 | 58 | 52 | 50 | 54 | 56 | 50 | 55 | — | — | — | ||||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | |||||||||||||||||||||||||||||||||||
| Adobe Inc. | 37 | 35 | 38 | 43 | 37 | 37 | 41 | 40 | 39 | 41 | 43 | 50 | 47 | 46 | 51 | 53 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| International Business Machines Corp. | 33 | 36 | 37 | 43 | 40 | 38 | 34 | 35 | 30 | 32 | 33 | 37 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | 21 | 28 | 15 | 15 | 23 | 22 | 5 | 7 | 12 | 31 | 5 | 5 | 14 | 31 | 5 | 6 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Microsoft Corp. | 62 | 66 | 57 | 83 | 60 | 65 | 57 | 82 | 60 | 64 | 54 | 86 | 58 | 61 | 55 | 88 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Oracle Corp. | 40 | 39 | 40 | 49 | 43 | 41 | 43 | 52 | 38 | 37 | 35 | 47 | 37 | 36 | 34 | 48 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Palo Alto Networks Inc. | 88 | 72 | 65 | 106 | 70 | 65 | 69 | 111 | 75 | 63 | 60 | 73 | 54 | 58 | 58 | 75 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Salesforce Inc. | 59 | 63 | 52 | 134 | 60 | 65 | 62 | 132 | 59 | 58 | 56 | 135 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| ServiceNow Inc. | 47 | 47 | 48 | 86 | 51 | 55 | 49 | 82 | 55 | 58 | 60 | 88 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Synopsys Inc. | 50 | 55 | 84 | 49 | 52 | 56 | 75 | 77 | 66 | 68 | 86 | 60 | 51 | 59 | 88 | 65 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-K (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-K (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-Q (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30).
1 Q3 2022 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 4.96 = 74
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Automatic Data Processing Inc. number of days of receivables outstanding improved from Q1 2022 to Q2 2022 but then deteriorated significantly from Q2 2022 to Q3 2022. |
Average Payables Payment Period
Automatic Data Processing Inc., average payables payment period calculation (quarterly data)
| Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | 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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||||||||
| Payables turnover | 113.60 | 87.41 | 113.48 | 61.24 | 75.77 | 74.30 | 75.85 | 82.80 | 72.72 | 62.24 | 75.28 | 64.44 | 51.30 | 52.77 | 60.07 | 57.92 | 73.21 | 55.35 | 65.65 | 48.56 | 56.29 | 51.11 | 58.89 | 44.91 | — | — | — | ||||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||||||||
| Average payables payment period1 | 3 | 4 | 3 | 6 | 5 | 5 | 5 | 4 | 5 | 6 | 5 | 6 | 7 | 7 | 6 | 6 | 5 | 7 | 6 | 8 | 6 | 7 | 6 | 8 | — | — | — | ||||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||||||||
| Average Payables Payment Period, Competitors2 | |||||||||||||||||||||||||||||||||||
| Accenture PLC | 22 | 21 | 22 | 24 | 22 | 20 | 18 | 16 | 17 | 18 | 19 | 20 | 19 | 18 | 17 | 17 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Adobe Inc. | 55 | 66 | 56 | 61 | 68 | 65 | 54 | 65 | 48 | 61 | 56 | 46 | 43 | 42 | 40 | 57 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| International Business Machines Corp. | 50 | 49 | 47 | 56 | 54 | 49 | 44 | 47 | 37 | 44 | 38 | 44 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | 145 | 158 | 105 | 135 | 142 | 129 | 70 | 81 | 105 | 131 | 82 | 86 | 125 | 137 | 74 | 66 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Microsoft Corp. | 98 | 97 | 99 | 106 | 97 | 96 | 98 | 99 | 76 | 74 | 72 | 80 | 65 | 67 | 78 | 82 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Oracle Corp. | 48 | 45 | 34 | 35 | 38 | 34 | 25 | 29 | 24 | 24 | 22 | 26 | 27 | 26 | 24 | 24 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Palo Alto Networks Inc. | 25 | 30 | 25 | 16 | 22 | 14 | 17 | 23 | 21 | 23 | 32 | 33 | 32 | 14 | 23 | 28 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| ServiceNow Inc. | 46 | 65 | 43 | 24 | 19 | 31 | 37 | 13 | 20 | 36 | 32 | 24 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-K (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-K (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-Q (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30).
1 Q3 2022 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 113.60 = 3
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. |