Stock Analysis on Net
AI Tokens
Stock Analysis on Net

Automatic Data Processing Inc. (NASDAQ:ADP)

This company has been moved to the archive! The financial data has not been updated since April 29, 2022.

Common-Size Balance Sheet: Assets
Quarterly Data

Automatic Data Processing Inc., common-size consolidated balance sheet: assets (quarterly data)

Microsoft Excel
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
Cash and cash equivalents 2.27 2.95 2.67 5.28 3.48 3.25 3.81 4.87 3.93 3.06 3.72 4.65 3.79 7.18 3.98 5.85 5.20 3.98 6.63 7.48 6.83 6.76 8.09 7.31 5.75 7.00 9.26
Accounts receivable, net of allowance for doubtful accounts 4.51 4.63 4.62 5.59 5.08 5.09 5.87 6.23 6.04 5.28 6.60 5.82 5.16 6.80 5.92 5.35 4.64 4.59 5.02 4.58 4.13 4.60 4.72 3.99 4.06 4.10 4.55
Other current assets 0.97 1.25 1.45 1.09 1.11 1.39 1.80 1.29 1.26 1.36 11.19 1.24 1.11 1.68 2.26 2.04 1.66 2.42 3.26 2.38 1.87 2.09 2.74 1.66 1.47 2.24 2.67
Current assets before funds held for clients 7.75% 8.83% 8.73% 11.97% 9.67% 9.72% 11.48% 12.40% 11.24% 9.70% 21.52% 11.72% 10.05% 15.66% 12.17% 13.24% 11.50% 11.00% 14.91% 14.44% 12.83% 13.45% 15.54% 12.96% 11.28% 13.34% 16.48%
Funds held for clients 80.92 77.65 78.03 71.57 76.26 74.74 70.65 68.19 71.07 74.62 56.72 70.27 74.86 65.98 67.89 73.17 76.36 77.34 72.03 73.40 77.27 76.07 72.19 77.49 80.30 76.03 71.29
Current assets 88.67% 86.47% 86.77% 83.53% 85.93% 84.46% 82.13% 80.59% 82.31% 84.32% 78.24% 81.99% 84.91% 81.64% 80.06% 86.41% 87.86% 88.34% 86.94% 87.84% 90.10% 89.52% 87.73% 90.45% 91.58% 89.37% 87.77%
Long-term receivables, net of allowance for doubtful accounts 0.01 0.02 0.02 0.02 0.02 0.03 0.04 0.05 0.05 0.04 0.06 0.06 0.05 0.06 0.07 0.07 0.06 0.06 0.08 0.08 0.06 0.06 0.08 0.06 0.05 0.08 0.09
Property, plant and equipment, net 0.90 1.09 1.08 1.40 1.29 1.40 1.65 1.80 1.71 1.55 2.03 1.82 1.59 1.99 2.11 2.14 1.80 1.80 2.24 2.10 1.71 1.83 2.04 1.57 1.31 1.70 1.98
Operating lease right-of-use asset 0.62 0.80 0.77 0.95 0.91 1.02 1.13 1.26 1.20 1.02 1.34 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Deferred contract costs 3.46 4.14 4.11 5.12 4.46 4.90 5.66 6.13 5.54 4.89 6.37 5.80 4.90 6.02 6.29 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Other assets 1.26 1.47 1.36 1.69 0.87 0.98 1.03 1.17 1.34 1.22 2.99 2.23 1.54 1.91 2.82 2.94 3.16 3.08 3.89 3.64 2.83 3.07 3.59 2.84 2.75 3.42 3.87
Goodwill 3.22 3.94 3.88 4.79 4.29 4.76 5.49 5.90 5.30 4.72 6.11 5.55 4.81 5.98 6.21 6.05 5.14 4.86 4.93 4.68 3.94 4.13 4.95 3.85 3.30 4.19 4.90
Intangible assets, net 1.84 2.07 2.02 2.48 2.23 2.45 2.87 3.10 2.55 2.25 2.86 2.56 2.21 2.39 2.45 2.39 1.99 1.87 1.93 1.67 1.36 1.38 1.61 1.22 1.01 1.24 1.39
Noncurrent assets 11.33% 13.53% 13.23% 16.47% 14.07% 15.54% 17.87% 19.41% 17.69% 15.68% 21.76% 18.01% 15.09% 18.36% 19.94% 13.59% 12.14% 11.66% 13.06% 12.16% 9.90% 10.48% 12.27% 9.55% 8.42% 10.63% 12.23%
Total assets 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

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

The asset structure is characterized by a heavy concentration in current assets, which consistently represent the vast majority of the total asset base, generally fluctuating between 78% and 92%. The most significant component of this structure is funds held for clients, reflecting a business model heavily reliant on the management of third-party capital.

Client Funds and Current Asset Volatility
Funds held for clients constitute the primary asset, typically ranging from 65% to 81% of total assets. A notable contraction occurred in September 2019, where these funds dropped to 56.72%, the lowest point in the observed period. This decline coincided with a sharp increase in other current assets, which spiked to 11.19% in the same quarter, suggesting a temporary reallocation of current asset components.
Liquidity and Cash Position
A consistent downward trend is observed in the proportion of cash and cash equivalents. From a peak of 9.26% in September 2015, the cash position steadily declined to 2.27% by March 2022. This suggests a strategic shift in liquidity management or an increase in the deployment of capital into other asset categories over the seven-year period.
Receivables Analysis
Accounts receivable have remained relatively stable, typically oscillating between 4% and 6% of total assets. There was a period of slight expansion between September 2018 and June 2020, where the ratio peaked at 6.23%, before returning to a range of 4.5% to 5.6% in subsequent periods.
Noncurrent Asset Evolution
Noncurrent assets generally represent a smaller portion of the balance sheet, though they experienced a period of growth starting in 2018. This growth was driven primarily by the emergence of deferred contract costs, which first appeared significantly in September 2018 at 6.29% and gradually tapered to 3.46% by March 2022. Additionally, operating lease right-of-use assets appeared in September 2019 (1.34%), likely reflecting changes in accounting standards, and subsequently declined to 0.62%.
Intangible Assets and Goodwill
Goodwill and intangible assets collectively maintain a stable presence, typically totaling between 5% and 9% of total assets. Goodwill fluctuated between a high of 6.21% in September 2019 and a low of 3.22% in March 2022, while intangible assets remained relatively consistent, generally staying between 1% and 3%.

AI Ask an analyst for more

My previous chats

Add tokens

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?