Stock Analysis on Net

Automatic Data Processing Inc. (NASDAQ:ADP)

$22.49

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

Analysis of Liquidity Ratios
Quarterly Data

Microsoft Excel

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Liquidity Ratios (Summary)

Automatic Data Processing Inc., liquidity ratios (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
Current ratio
Quick ratio
Cash ratio

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 analysis of the liquidity ratios over the observed periods reveals several notable trends and fluctuations.

Current Ratio
The current ratio demonstrates a mild declining trend from 1.13 in September 2015 to values slightly above 1.00 by March 2022, reflecting a generally stable but somewhat decreasing buffer of current assets over current liabilities. The ratio mostly fluctuates within a narrow range around 1.05, indicating that the company typically maintains current assets just sufficient to cover its short-term obligations. Minor dips near 1.01 towards late 2019 and early 2022 suggest occasional tightening of liquidity.
Quick Ratio
The quick ratio, which excludes inventory from current assets, follows a similar pattern to the current ratio but exhibits a slight more pronounced dip around late 2019 where it drops to 0.87 in September 2019. This decrease signals a temporary reduction in liquid assets relative to current liabilities during that period. However, the ratio recovers in subsequent quarters, oscillating around the 1.00 mark, and generally maintaining a ratio indicative of sufficient liquid assets to cover liabilities without relying on inventory liquidation.
Cash Ratio
The cash ratio shows a gradual but discernible decline over the entire timeline, moving from levels above 1.00 in the earlier years to approximately 0.95 by March 2022. The lowest observed ratio occurs in September 2019 at 0.78, notably lower than other periods, implying a tighter cash position during that time. Afterward, the cash ratio somewhat recovers but remains below 1.00, indicating that cash and cash equivalents do not fully cover current liabilities in recent periods. This trend highlights a cautious reduction in the most liquid assets relative to short-term debt.

Overall, the liquidity ratios signal a stable but gradually tightening liquidity position, with the company maintaining ratios close to or slightly above the benchmark of 1.00. The temporary declines around mid to late 2019 suggest episodes of reduced liquidity, particularly in cash availability. However, the recovery in subsequent quarters indicates effective liquidity management, preventing significant short-term solvency risks. The consistent proximity of quick and current ratios to 1.00 suggests a balanced approach in asset composition and liability coverage without excessive reliance on inventory or cash reserves.


Current Ratio

Automatic Data Processing Inc., current ratio calculation (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
Selected Financial Data (US$ in thousands)
Current assets
Current liabilities
Liquidity Ratio
Current ratio1
Benchmarks
Current Ratio, Competitors2
Accenture PLC
Adobe Inc.
Cadence Design Systems Inc.
CrowdStrike Holdings Inc.
International Business Machines Corp.
Intuit Inc.
Microsoft Corp.
Oracle Corp.
Palantir Technologies Inc.
Palo Alto Networks Inc.
Salesforce Inc.
ServiceNow Inc.
Synopsys Inc.
Workday Inc.

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
Current ratio = Current assets ÷ Current liabilities
= ÷ =

2 Click competitor name to see calculations.

Current Assets
The current assets experienced notable fluctuations over the analyzed periods. Initially, there was an increase from 30.2 billion US dollars at the end of September 2015 to 46.8 billion US dollars by March 2016. This was followed by a decline and stabilization oscillating around the 30-40 billion range, before exhibiting a general upward trend starting from late 2018. The quarter ending March 2022 recorded the highest current assets at approximately 63.9 billion US dollars, indicating substantial growth over the longer term.
Current Liabilities
Current liabilities broadly followed a pattern similar to current assets, with values fluctuating significantly over the observed quarters. Starting from 26.6 billion US dollars in September 2015, liabilities rose sharply to 43.3 billion US dollars by March 2016, before descending and showing oscillations around 27-40 billion US dollars in subsequent quarters. Liabilities surged again towards the later periods, reaching a peak of roughly 63.1 billion US dollars in the quarter ending March 2022, closely mirroring the increase in current assets.
Current Ratio
The current ratio remained relatively stable throughout the reporting periods, fluctuating narrowly between 1.01 and 1.13. This indicates a consistent ability to cover short-term liabilities with short-term assets. Despite the increases in both current assets and liabilities, the ratio hovered slightly above 1.0, demonstrating a balance where current assets marginally exceeded current liabilities without significant deterioration or improvement in liquidity. Notably, the ratio showed minor declines from a peak of 1.13 in late 2015 to a low near 1.01 in early 2020 and again in early 2022, reflecting slight decreases in liquidity ratios amid growing asset and liability balances.

Quick Ratio

Automatic Data Processing Inc., quick ratio calculation (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
Selected Financial Data (US$ in thousands)
Cash and cash equivalents
Accounts receivable, net of allowance for doubtful accounts
Funds held for clients
Total quick assets
 
Current liabilities
Liquidity Ratio
Quick ratio1
Benchmarks
Quick Ratio, Competitors2
Accenture PLC
Adobe Inc.
Cadence Design Systems Inc.
CrowdStrike Holdings Inc.
International Business Machines Corp.
Intuit Inc.
Microsoft Corp.
Oracle Corp.
Palantir Technologies Inc.
Palo Alto Networks Inc.
Salesforce Inc.
ServiceNow Inc.
Synopsys Inc.
Workday Inc.

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
Quick ratio = Total quick assets ÷ Current liabilities
= ÷ =

2 Click competitor name to see calculations.

The analysis of the quarterly data indicates that total quick assets have exhibited notable fluctuations over the observed period. Starting from approximately 29.26 billion US dollars at the end of September 2015, the figure increased substantially to a peak exceeding 46.14 billion US dollars by March 2021 and further reached over 63.2 billion US dollars by the end of March 2022. Despite some intermittent declines, the overall trend for total quick assets is upward, reflecting a growth in liquid assets available within each quarter.

Current liabilities have followed a somewhat similar pattern of variability over time. Beginning at around 26.59 billion US dollars in September 2015, current liabilities increased consistently, reaching above 44.6 billion US dollars by March 2021 and approximately 63.1 billion US dollars by the end of March 2022. The parallel movement of current liabilities with total quick assets suggests that the company has expanded both its short-term obligations and quick assets proportionally over the years.

The quick ratio remained relatively stable throughout the periods considered, hovering slightly above or below 1.0. Initially, the quick ratio was 1.1 in September 2015 and decreased gradually to around 1.0 by September 2018. A dip below 1.0 occurred in September 2019 at 0.87, indicating a moment where quick assets were not sufficient to cover current liabilities. However, this was followed by a recovery and stabilization around 1.03 to 1.06 in the subsequent quarters. By March 2022, the ratio returned to 1.0.

This consistency in the quick ratio suggests that, despite fluctuations in absolute values of quick assets and liabilities, the company has managed to maintain a relatively balanced liquidity position, ensuring its immediate assets are generally adequate to cover its short-term liabilities. The slight variances indicate some periods of tighter liquidity management but no prolonged periods of liquidity distress.

Total Quick Assets
Demonstrated an overall increasing trend with intermittent decreases, rising from about 29 billion to above 63 billion US dollars over nearly seven years.
Current Liabilities
Increased in a pattern similar to quick assets, more than doubling from approximately 26.5 billion to over 63 billion US dollars in the same timeframe.
Quick Ratio
Maintained near the benchmark of 1.0, signaling generally stable liquidity though with a brief period below 1.0 in late 2019, followed by recovery and stabilization.

In summary, the financial data reveals a company that has steadily grown its liquid asset base while managing its short-term obligations effectively. The stable quick ratio underscores prudent liquidity management despite the increasing scale of both assets and liabilities. This indicates a consistent ability to meet short-term obligations without significant liquidity risk throughout the analyzed period.


Cash Ratio

Automatic Data Processing Inc., cash ratio calculation (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
Selected Financial Data (US$ in thousands)
Cash and cash equivalents
Funds held for clients
Total cash assets
 
Current liabilities
Liquidity Ratio
Cash ratio1
Benchmarks
Cash Ratio, Competitors2
Accenture PLC
Adobe Inc.
Cadence Design Systems Inc.
CrowdStrike Holdings Inc.
International Business Machines Corp.
Intuit Inc.
Microsoft Corp.
Oracle Corp.
Palantir Technologies Inc.
Palo Alto Networks Inc.
Salesforce Inc.
ServiceNow Inc.
Synopsys Inc.
Workday Inc.

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
Cash ratio = Total cash assets ÷ Current liabilities
= ÷ =

2 Click competitor name to see calculations.

The analysis of the quarterly financial data reveals several notable patterns and trends over the observed periods.

Total Cash Assets

Total cash assets exhibit significant fluctuations across the quarters. Starting at approximately 27.7 billion USD in the third quarter of 2015, the figure increased to a peak of nearly 44.0 billion USD by the first quarter of 2016. Subsequent quarters showed volatility with values ranging from roughly 22.8 billion USD to nearly 60.0 billion USD in the first quarter of 2022. The overall trend towards the end of the series reflects a growth in cash assets, with marked increases in late 2021 and early 2022.

Current Liabilities

Current liabilities similarly demonstrate variability in the same timeframe. Beginning at about 26.6 billion USD in the third quarter of 2015, the amount fluctuates, often paralleling trends observed in total cash assets. There is a peak observed in the first quarter of 2022 at over 63.1 billion USD, representing a substantial increase in liabilities relative to the initial period. The data suggest that current liabilities have generally increased over time but with periods of contraction, indicating adjustments in short-term obligations.

Cash Ratio

The cash ratio, which measures liquidity by comparing total cash assets to current liabilities, maintains a relatively stable pattern slightly above or close to 1.0 during the initial years, indicating that cash assets were sufficient to cover current liabilities. However, starting around the third quarter of 2019, the ratio shows a decrease to below 1.0, reaching a low point of approximately 0.78 in the third quarter of 2019. Despite this, the ratio recovers somewhat in subsequent periods, stabilizing around 0.95 to 0.98 towards the end of the dataset. This indicates a moderate decline in liquidity when considering immediate cash availability against short-term obligations, but no severe liquidity risk is apparent.

In summary, the company has experienced variability in both cash assets and current liabilities, with an overall increase in absolute figures over the years. The cash ratio trend suggests a slight reduction in short-term liquidity buffers relative to liabilities, though the ratio remains near parity, signifying maintained liquidity strength. The fluctuations in cash assets and liabilities may reflect operational adjustments, investment activities, or financing decisions influencing the company's working capital management.