Analysis of Long-term (Investment) 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.
Long-term Activity Ratios (Summary)
Automatic Data Processing Inc., long-term (investment) 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).
The analysis of the financial ratios over the observed periods reveals distinct trends and shifts in asset efficiency and equity utilization.
- Net Fixed Asset Turnover
- This ratio demonstrates a consistent upward trend from the beginning of the period through to the end, starting at 16.93 and rising progressively to 24.76. The steady increase suggests improving efficiency in generating sales revenue from the company's net fixed assets.
- Net Fixed Asset Turnover (including operating lease, right-of-use asset)
- While initially mirroring the traditional net fixed asset turnover figures, this ratio experiences a marked decline starting around the 2019 period, dropping from approximately 18.55 down to 11.29. Thereafter, it gradually recovers but remains significantly lower than the traditional measurement by the end of the timeline, indicated by a value of 14.7. This pattern likely reflects the impact of accounting changes or lease capitalization effects, which temporarily suppressed this metric before a modest recovery occurred.
- Total Asset Turnover
- The total asset turnover ratio exhibits variability without a clear upward or downward long-term trend. Early values oscillate between 0.28 and 0.36, followed by a general decline after 2019, with ratios decreasing gradually to 0.22 by the latest period. This suggests a gradual reduction in the efficiency with which the company uses all its assets to generate sales revenue.
- Equity Turnover
- Equity turnover fluctuates throughout the periods, beginning in the range of approximately 2.79 to 3.85 before experiencing a decline to a low of 2.47 around mid-2020. Subsequently, it trends upward, reaching 3.84 by the final quarter. These fluctuations illustrate variability in how effectively the company utilizes shareholders’ equity to generate sales, with an overall recovery by the end of the period.
In summary, net fixed asset utilization has strengthened consistently over time, indicating enhanced operational capabilities or asset productivity. The incorporation of operating lease assets into fixed asset turnover calculations appears to have introduced volatility and a downward adjustment in that metric, reflecting lease accounting changes. Conversely, total asset turnover has declined modestly, signaling potential efficiency challenges in broader asset management. Equity turnover reveals fluctuations but ends on a positive trajectory, denoting a recent improvement in equity use efficiency.
Net Fixed Asset Turnover
Automatic Data Processing Inc., net fixed asset 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||||
| Property, plant and equipment, net | 650,500) | 644,500) | 648,700) | 684,500) | 701,400) | 692,700) | 701,500) | 703,900) | 743,100) | 761,300) | 767,100) | 764,200) | 765,800) | 772,700) | 787,700) | 793,700) | 794,600) | 799,900) | 800,400) | 779,900) | 750,600) | 733,200) | 701,000) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||||
| Net fixed asset turnover1 | 24.76 | 24.35 | 23.69 | 21.92 | 20.88 | 21.06 | 20.76 | 20.73 | 19.80 | 19.06 | 18.70 | 18.55 | 18.28 | 17.91 | 17.23 | 16.79 | 16.45 | 15.99 | 15.67 | 15.87 | 16.27 | 16.44 | 16.93 | |||||||
| Benchmarks | ||||||||||||||||||||||||||||||
| Net Fixed Asset Turnover, Competitors2 | ||||||||||||||||||||||||||||||
| Accenture PLC | 35.78 | 34.22 | 32.49 | 30.83 | 31.16 | 30.44 | 29.69 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Adobe Inc. | 9.25 | 9.33 | 9.48 | 9.44 | 9.27 | 9.15 | 8.94 | 8.48 | 8.48 | 8.68 | 8.70 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| AppLovin Corp. | 40.76 | 46.80 | 44.17 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Cadence Design Systems Inc. | 9.86 | 10.37 | 10.15 | 9.77 | 9.81 | 9.57 | 9.18 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| CrowdStrike Holdings Inc. | 5.31 | 5.27 | 5.22 | 5.24 | 4.69 | 4.27 | 4.05 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Datadog Inc. | 13.81 | 13.97 | 13.15 | 13.69 | 12.79 | 12.63 | 12.70 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| International Business Machines Corp. | 11.75 | 11.31 | 10.50 | 10.07 | 6.68 | 6.93 | 7.33 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Intuit Inc. | 15.00 | 13.74 | 13.08 | 12.35 | 11.24 | 9.74 | 10.55 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Microsoft Corp. | 2.74 | 2.75 | 2.76 | 2.81 | 2.91 | 2.96 | 3.07 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Oracle Corp. | 4.86 | 5.16 | 5.37 | 5.74 | 5.82 | 5.95 | 6.13 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Palantir Technologies Inc. | 31.65 | 36.61 | 39.34 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Palo Alto Networks Inc. | 14.54 | 13.39 | 14.05 | 13.37 | 12.36 | 11.44 | 10.60 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Salesforce Inc. | 9.03 | 8.68 | 8.98 | 8.64 | 7.91 | 7.67 | 7.24 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| ServiceNow Inc. | 7.57 | 7.54 | 7.84 | 7.70 | 7.47 | 7.06 | 6.97 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Synopsys Inc. | 10.17 | 9.68 | 9.43 | 8.90 | 8.67 | 8.32 | 7.85 | 7.62 | 7.25 | 7.23 | 7.38 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Workday Inc. | 4.37 | 4.12 | 3.87 | 4.44 | 4.26 | 4.17 | 4.08 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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).
1 Q3 2022 Calculation
Net fixed asset turnover
= (RevenuesQ3 2022
+ RevenuesQ2 2022
+ RevenuesQ1 2022
+ RevenuesQ4 2021)
÷ Property, plant and equipment, net
= (4,513,000 + 4,025,400 + 3,832,300 + 3,737,000)
÷ 650,500 = 24.76
2 Click competitor name to see calculations.
- Revenue Trends
- The quarterly revenues demonstrate a general upward trajectory over the observed period. Starting at approximately $2.9 billion in September 2016, revenues show incremental growth with some seasonal fluctuations. Notably, the second quarter of 2020 sees a dip, potentially linked to broader economic conditions during that timeframe. Subsequently, revenues rebound and continue to increase, reaching over $4.5 billion by the first quarter of 2022. This pattern indicates resilience and steady business expansion despite intermittent downturns.
- Property, Plant, and Equipment (PP&E) Trends
- The net value of property, plant, and equipment exhibits a gradual decline from about $701 million in September 2016 to approximately $651 million in March 2022. The asset base remains relatively stable during the initial years but shows a more pronounced reduction starting from late 2019 through 2021. This decrease could reflect depreciation outpacing new capital investments or divestitures of fixed assets during this period.
- Net Fixed Asset Turnover Ratio
- The net fixed asset turnover ratio shows a consistent and marked improvement throughout the analyzed quarters. Beginning at a ratio of roughly 16.9 in September 2016, this metric steadily increases, reaching nearly 24.8 by March 2022. The rising turnover ratio suggests enhanced efficiency in utilizing fixed assets to generate revenues, indicating improved asset management or a shift toward less capital-intensive operations.
- Overall Insights
- The data reveals a company achieving consistent revenue growth while simultaneously reducing its fixed asset base. Improved asset turnover ratios reinforce the notion of increasing operational efficiency. However, the decline in net fixed assets warrants attention to future capital expenditure plans to sustain growth momentum. The observed dip in revenues during mid-2020 aligns with known macroeconomic challenges, but the swift recovery denotes robust underlying demand and adaptability.
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)
Automatic Data Processing Inc., net fixed asset turnover (including operating lease, right-of-use asset) 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||||
| Property, plant and equipment, net | 650,500) | 644,500) | 648,700) | 684,500) | 701,400) | 692,700) | 701,500) | 703,900) | 743,100) | 761,300) | 767,100) | 764,200) | 765,800) | 772,700) | 787,700) | 793,700) | 794,600) | 799,900) | 800,400) | 779,900) | 750,600) | 733,200) | 701,000) | |||||||
| Operating lease right-of-use asset | 445,500) | 472,100) | 462,400) | 462,200) | 493,800) | 501,100) | 479,000) | 493,700) | 521,100) | 500,200) | 504,000) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | |||||||
| Property, plant and equipment, net (including operating lease, right-of-use asset) | 1,096,000) | 1,116,600) | 1,111,100) | 1,146,700) | 1,195,200) | 1,193,800) | 1,180,500) | 1,197,600) | 1,264,200) | 1,261,500) | 1,271,100) | 764,200) | 765,800) | 772,700) | 787,700) | 793,700) | 794,600) | 799,900) | 800,400) | 779,900) | 750,600) | 733,200) | 701,000) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||||
| Net fixed asset turnover (including operating lease, right-of-use asset)1 | 14.70 | 14.06 | 13.83 | 13.09 | 12.25 | 12.22 | 12.34 | 12.18 | 11.64 | 11.50 | 11.29 | 18.55 | 18.28 | 17.91 | 17.23 | 16.79 | 16.45 | 15.99 | 15.67 | 15.87 | 16.27 | 16.44 | 16.93 | |||||||
| Benchmarks | ||||||||||||||||||||||||||||||
| Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2 | ||||||||||||||||||||||||||||||
| Accenture PLC | 12.30 | 11.56 | 11.17 | 10.48 | 10.27 | 9.83 | 9.71 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Adobe Inc. | 7.57 | 7.52 | 7.55 | 7.46 | 7.26 | 7.08 | 6.82 | 6.42 | 6.30 | 6.42 | 6.32 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| CrowdStrike Holdings Inc. | 4.66 | 4.54 | 4.38 | 4.30 | 3.79 | 3.38 | 3.22 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Datadog Inc. | 7.67 | 8.44 | 7.82 | 7.54 | 6.73 | 6.96 | 6.33 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| International Business Machines Corp. | 7.67 | 7.35 | 6.73 | 6.43 | 4.56 | 4.73 | 4.97 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Intuit Inc. | 10.03 | 8.99 | 8.64 | 8.30 | 7.66 | 6.52 | 8.04 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Microsoft Corp. | 2.31 | 2.32 | 2.34 | 2.37 | 2.44 | 2.47 | 2.58 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Palantir Technologies Inc. | 7.12 | 6.73 | 6.17 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Palo Alto Networks Inc. | 8.68 | 8.08 | 7.91 | 7.32 | 6.86 | 6.49 | 6.08 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Salesforce Inc. | 4.40 | 4.03 | 4.02 | 3.75 | 3.67 | 3.52 | 3.31 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| ServiceNow Inc. | 4.63 | 4.46 | 4.53 | 4.34 | 4.11 | 4.32 | 4.21 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Synopsys Inc. | 4.66 | 4.42 | 4.70 | 4.35 | 4.23 | 4.05 | 4.03 | 3.88 | 3.67 | 3.64 | 3.68 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Workday Inc. | 3.52 | 3.31 | 3.11 | 3.11 | 2.99 | 3.12 | 3.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).
1 Q3 2022 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset)
= (RevenuesQ3 2022
+ RevenuesQ2 2022
+ RevenuesQ1 2022
+ RevenuesQ4 2021)
÷ Property, plant and equipment, net (including operating lease, right-of-use asset)
= (4,513,000 + 4,025,400 + 3,832,300 + 3,737,000)
÷ 1,096,000 = 14.70
2 Click competitor name to see calculations.
The analyzed data reveals several trends related to revenues, property, plant, and equipment (PP&E), as well as net fixed asset turnover over the covered periods.
- Revenues
- Revenues exhibit a general upward trajectory across the period under review. Beginning at approximately 2.92 billion US dollars as of September 2016, revenues trend consistently higher with periodic fluctuations reflecting typical quarterly variations. A notable increase can be observed moving into 2019 and continuing through to the first quarter of 2022, where revenues reach over 4.5 billion US dollars. Despite some dips such as in mid-2020, likely influenced by external conditions, the overall progression indicates steady growth in operating income over the almost six-year span.
- Property, Plant, and Equipment, Net (Including Operating Lease, Right-of-Use Asset)
- The net value of property, plant, and equipment remains relatively stable during the early periods, fluctuating between approximately 700 million to 800 million US dollars through the end of 2018. Beginning in late 2019, a significant increase occurs, with PP&E values rising sharply to over 1.2 billion US dollars by mid-2019. This elevated level maintains through 2019 into 2020, followed by a gradual decline back toward approximately 1.1 billion US dollars by early 2022. This pattern suggests a period of substantial capital investment or asset revaluation during late 2019, with subsequent asset disposals, depreciation, or amortization reducing the net carrying amounts in following quarters.
- Net Fixed Asset Turnover (Including Operating Lease, Right-of-Use Asset)
- Net fixed asset turnover ratios start at high levels near 17 at the beginning of the dataset, indicating efficient utilization of fixed assets to generate revenues. Ratios exhibit a gradual decline starting 2017 and intensify markedly in late 2019, dropping to approximately 11.3. This drop coincides with the sharp increase in net fixed assets, diluting the turnover ratio due to increased asset base. From mid-2020 onward, the ratio gradually improves again, climbing back to nearly 14.7 by the first quarter of 2022. This restoration suggests improved asset turnover efficiency, either through revenue growth outpacing asset bases or through asset base optimization.
In summary, the data reflects consistent revenue growth accompanied by significant investment in fixed assets in late 2019, resulting in a temporary decrease in asset turnover efficiency. Subsequent quarters show adjustment and optimization in asset management, coupled with maintenance of revenue growth, implying ongoing efforts to balance capital investments with operational performance.
Total Asset Turnover
Automatic Data Processing Inc., total asset 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||||
| Total assets | 72,068,100) | 59,102,600) | 59,987,200) | 48,772,500) | 54,407,700) | 49,325,900) | 42,390,100) | 39,165,500) | 43,383,400) | 49,059,400) | 37,714,700) | 41,887,700) | 48,196,300) | 38,806,300) | 37,416,700) | 37,088,700) | 44,065,500) | 44,545,500) | 35,661,100) | 37,180,000) | 43,855,900) | 39,999,400) | 34,337,400) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||||
| Total asset turnover1 | 0.22 | 0.27 | 0.26 | 0.31 | 0.27 | 0.30 | 0.34 | 0.37 | 0.34 | 0.30 | 0.38 | 0.34 | 0.29 | 0.36 | 0.36 | 0.36 | 0.30 | 0.29 | 0.35 | 0.33 | 0.28 | 0.30 | 0.35 | |||||||
| Benchmarks | ||||||||||||||||||||||||||||||
| Total Asset Turnover, Competitors2 | ||||||||||||||||||||||||||||||
| Accenture PLC | 1.29 | 1.28 | 1.23 | 1.17 | 1.14 | 1.14 | 1.17 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Adobe Inc. | 0.64 | 0.63 | 0.62 | 0.58 | 0.58 | 0.56 | 0.55 | 0.53 | 0.55 | 0.56 | 0.55 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| AppLovin Corp. | 0.50 | 0.49 | 0.46 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Cadence Design Systems Inc. | 0.69 | 0.75 | 0.72 | 0.68 | 0.71 | 0.70 | 0.70 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| CrowdStrike Holdings Inc. | 0.39 | 0.36 | 0.35 | 0.32 | 0.44 | 0.40 | 0.37 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Datadog Inc. | 0.55 | 0.51 | 0.47 | 0.43 | 0.40 | 0.37 | 0.34 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| International Business Machines Corp. | 0.48 | 0.47 | 0.44 | 0.43 | 0.42 | 0.44 | 0.47 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Intuit Inc. | 0.45 | 0.43 | 0.69 | 0.62 | 0.56 | 0.53 | 0.81 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Microsoft Corp. | 0.56 | 0.54 | 0.53 | 0.50 | 0.52 | 0.50 | 0.49 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Oracle Corp. | 0.39 | 0.39 | 0.33 | 0.31 | 0.34 | 0.36 | 0.35 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Palantir Technologies Inc. | 0.55 | 0.53 | 0.50 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Palo Alto Networks Inc. | 0.47 | 0.47 | 0.44 | 0.42 | 0.42 | 0.40 | 0.41 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Salesforce Inc. | 0.29 | 0.27 | 0.34 | 0.32 | 0.34 | 0.34 | 0.34 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| ServiceNow Inc. | 0.62 | 0.59 | 0.57 | 0.55 | 0.58 | 0.56 | 0.55 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Synopsys Inc. | 0.53 | 0.52 | 0.51 | 0.48 | 0.48 | 0.48 | 0.48 | 0.46 | 0.46 | 0.46 | 0.47 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Workday Inc. | 0.52 | 0.51 | 0.52 | 0.50 | 0.53 | 0.53 | 0.53 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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).
1 Q3 2022 Calculation
Total asset turnover
= (RevenuesQ3 2022
+ RevenuesQ2 2022
+ RevenuesQ1 2022
+ RevenuesQ4 2021)
÷ Total assets
= (4,513,000 + 4,025,400 + 3,832,300 + 3,737,000)
÷ 72,068,100 = 0.22
2 Click competitor name to see calculations.
- Revenue Trends
- Revenues demonstrate a generally upward trajectory over the analyzed period, increasing from approximately $2.92 billion in September 2016 to $4.51 billion by March 2022. There are recurring seasonal fluctuations, with revenues often peaking around March quarters. Notably, there is a dip during mid-2020, likely related to external economic conditions, followed by a recovery and growth thereafter.
- Total Assets Evolution
- Total assets exhibit significant volatility, fluctuating between roughly $34.3 billion and $72.1 billion across the periods. An initial rise is observed until early 2017, followed by periods of decline and sharp increases, especially from late 2018 onward. The asset base more than doubled from approximately $34.3 billion at the start to over $72 billion by March 2022, indicating substantial growth in asset holdings or investments.
- Total Asset Turnover Analysis
- The total asset turnover ratio shows a declining trend throughout the period, starting from around 0.35 and falling to 0.22 by March 2022. This ratio reflects the efficiency with which the company is using its assets to generate revenue. The downward trend suggests that despite increasing revenues, the asset base is growing at a faster pace or that assets are being utilized less efficiently over time.
- Combined Insights
- The simultaneous increase in both revenues and total assets, accompanied by a declining asset turnover ratio, indicates that the company is expanding its asset base more rapidly than its revenue generation capability. This pattern may point to significant investments or acquisitions, and suggests a shift in asset structure or utilization. Seasonal revenue patterns persist despite these changes, and mid-2020 represents a temporary contraction phase likely influenced by broader economic factors.
Equity Turnover
Automatic Data Processing Inc., equity 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||||
| Stockholders’ equity | 4,192,900) | 5,049,600) | 5,350,700) | 5,670,100) | 5,673,900) | 5,900,000) | 5,808,900) | 5,752,200) | 5,490,700) | 5,364,400) | 5,360,700) | 5,399,900) | 5,246,200) | 4,763,900) | 4,678,800) | 3,459,600) | 4,029,200) | 3,931,200) | 3,953,400) | 3,977,000) | 4,103,100) | 3,815,100) | 4,250,100) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||||
| Equity turnover1 | 3.84 | 3.11 | 2.87 | 2.65 | 2.58 | 2.47 | 2.51 | 2.54 | 2.68 | 2.71 | 2.68 | 2.63 | 2.67 | 2.91 | 2.90 | 3.85 | 3.24 | 3.25 | 3.17 | 3.11 | 2.98 | 3.16 | 2.79 | |||||||
| Benchmarks | ||||||||||||||||||||||||||||||
| Equity Turnover, Competitors2 | ||||||||||||||||||||||||||||||
| Accenture PLC | 2.79 | 2.76 | 2.64 | 2.59 | 2.48 | 2.49 | 2.50 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Adobe Inc. | 1.20 | 1.19 | 1.17 | 1.07 | 1.05 | 1.04 | 1.01 | 0.97 | 1.06 | 1.11 | 1.11 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| AppLovin Corp. | 1.55 | 1.53 | 1.40 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Cadence Design Systems Inc. | 1.27 | 1.25 | 1.14 | 1.09 | 1.13 | 1.15 | 1.10 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| CrowdStrike Holdings Inc. | 1.36 | 1.26 | 1.18 | 1.00 | 0.94 | 0.83 | 0.75 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Datadog Inc. | 1.19 | 1.12 | 1.07 | 0.99 | 0.92 | 0.84 | 0.80 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| International Business Machines Corp. | 3.02 | 3.07 | 3.06 | 3.03 | 2.75 | 2.98 | 3.24 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Intuit Inc. | 0.76 | 0.73 | 1.06 | 0.98 | 0.89 | 0.87 | 1.49 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Microsoft Corp. | 1.18 | 1.16 | 1.16 | 1.18 | 1.19 | 1.18 | 1.19 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Oracle Corp. | — | — | — | 7.73 | 4.46 | 4.98 | 4.13 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Palantir Technologies Inc. | 0.77 | 0.74 | 0.70 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Palo Alto Networks Inc. | 15.31 | 41.24 | 8.78 | 6.71 | 4.00 | 3.65 | 4.80 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Salesforce Inc. | 0.44 | 0.42 | 0.53 | 0.51 | 0.50 | 0.50 | 0.53 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| ServiceNow Inc. | 1.53 | 1.57 | 1.57 | 1.60 | 1.57 | 1.58 | 1.59 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Synopsys Inc. | 0.88 | 0.86 | 0.84 | 0.79 | 0.79 | 0.78 | 0.78 | 0.75 | 0.76 | 0.80 | 0.81 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Workday Inc. | 1.16 | 1.21 | 1.31 | 1.32 | 1.35 | 1.41 | 1.47 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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).
1 Q3 2022 Calculation
Equity turnover
= (RevenuesQ3 2022
+ RevenuesQ2 2022
+ RevenuesQ1 2022
+ RevenuesQ4 2021)
÷ Stockholders’ equity
= (4,513,000 + 4,025,400 + 3,832,300 + 3,737,000)
÷ 4,192,900 = 3.84
2 Click competitor name to see calculations.
The analysis of the quarterly financial data reveals several notable trends in revenues, stockholders’ equity, and equity turnover over the examined periods.
- Revenues
- Revenues exhibit an overall upward trajectory with some fluctuations across quarters. Starting from approximately 2.9 billion USD in the third quarter of 2016, revenues increased to a peak of around 4.5 billion USD by the first quarter of 2022. Periods of notable growth include the quarters ending March 2017, March 2018, March 2019, and March 2022, indicating a recurring seasonal uplift in revenues during the early year quarters. There are intermittent dips, such as in the second quarter of 2020, likely associated with broader economic conditions during that time, but the recovery in subsequent quarters is evident.
- Stockholders’ Equity
- Stockholders’ equity shows a more volatile pattern compared to revenues. From about 4.25 billion USD in late 2016, equity experienced a decline towards mid-2018, reaching a low around 3.46 billion USD, before rebounding significantly to approximately 5.9 billion USD by the fourth quarter of 2020. However, after this peak, equity steadily decreased through to the first quarter of 2022, ending near 4.19 billion USD. This volatility may reflect changes in retained earnings, share repurchases, dividends, or other equity transactions during the periods.
- Equity Turnover
- Equity turnover, which measures the efficiency of the company’s use of equity to generate revenues, varied over time but stayed mostly within the 2.5 to 3.8 range. Initial quarters in 2016 and 2017 presented ratios around 2.8 to 3.2, peaking at 3.85 in mid-2018. A dip followed, bringing the ratio to below 2.5 in late 2020 and early 2021. Subsequently, equity turnover increased again, reaching a high of 3.84 in the first quarter of 2022. This suggests periods where the company either improved its revenue generation relative to equity or where shifts in equity influenced this ratio significantly.
In summary, the company demonstrated consistent revenue growth over the period with seasonal spikes primarily in early-year quarters. Stockholders’ equity was more volatile, with a notable dip in 2018, recovery through 2020, and a decline thereafter. Equity turnover fluctuated but indicated an overall solid capability to generate revenues from equity, peaking in early 2018 and again in early 2022. These trends highlight underlying business cycles, potential capital management strategies, and revenue effectiveness relative to equity during the analyzed timeframe.