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


Current Ratio
The current ratio remained relatively stable throughout the observed periods, fluctuating slightly above 1.0. Starting at 1.13 in September 2016, it gradually decreased to around 1.05 by late 2017 and maintained a narrow range between 1.01 and 1.08 through 2020 and into early 2022. This consistency indicates a steady ability to cover short-term liabilities with current assets without significant volatility.
Quick Ratio
This ratio showed a similar pattern to the current ratio, beginning at 1.09 in September 2016. There was a mild decline by the end of 2017, reaching approximately 1.03. A notable dip occurred in September 2019 where the quick ratio fell to 0.87, suggesting a temporary reduction in liquid assets relative to current liabilities. However, it recovered quickly and stabilized around 1.00 to 1.06 afterward, demonstrating resilience in the company's short-term liquidity excluding inventory.
Cash Ratio
The cash ratio exhibited a declining trend from 1.03 in September 2016 to a low point of 0.78 around September 2019, corresponding with the period when the quick ratio also dipped. This decline indicates a temporary contraction in cash and cash equivalents relative to current liabilities. After this low point, the cash ratio gradually increased to approximately 0.98 by mid-2021 but slightly declined again to 0.95 by March 2022. Overall, cash availability showed some variability but generally remained below the initial levels observed in 2016.
Summary of Liquidity Trends
Overall, the company's liquidity ratios indicate a stable short-term financial position, with minor fluctuations over the examined timeframe. The current and quick ratios maintained values close to or just above 1, suggesting satisfactory liquidity to meet obligations as they come due. The cash ratio showed more pronounced variation, including a notable dip around late 2019, but demonstrated recovery afterward. These patterns may reflect changes in cash management strategies or working capital needs during the period without indicating acute liquidity distress.

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
Selected Financial Data (US$ in thousands)
Current assets
Current liabilities
Liquidity Ratio
Current ratio1
Benchmarks
Current Ratio, Competitors2
Accenture PLC
Adobe Inc.
AppLovin Corp.
Cadence Design Systems Inc.
CrowdStrike Holdings Inc.
Datadog 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).

1 Q3 2022 Calculation
Current ratio = Current assets ÷ Current liabilities
= ÷ =

2 Click competitor name to see calculations.


The analysis of quarterly financial data reveals measurable trends in the liquidity position of the company over the examined periods.

Current Assets
Current assets exhibit fluctuations throughout the quarters, with notable peaks and troughs. Starting at approximately 30.1 billion US dollars, current assets rise to about 39.5 billion by the first quarter of 2017, then decline through mid-2017 and show intermittent rebounds thereafter. A significant upward trend emerges from late 2018 through early 2022, culminating at approximately 63.9 billion US dollars by the first quarter of 2022, indicating enhanced liquidity and asset base over the long term.
Current Liabilities
Current liabilities follow a pattern somewhat parallel to that of current assets, with considerable increases and decreases over the periods. Beginning at roughly 26.7 billion US dollars, liabilities increase to over 36 billion by early 2017, and experience dips and rises in subsequent periods. A marked increase is observed from late 2020 to early 2022, culminating at around 63.1 billion US dollars, suggesting greater short-term obligations alongside growth in current assets.
Current Ratio
The current ratio remains relatively stable and consistently above 1, indicating that current assets have been sufficient to cover current liabilities throughout the timeline. Values mostly range from 1.01 to 1.13, reflecting a liquidity position that is adequate but not excessively strong. This stability points to a balanced management of short-term assets and liabilities, despite the fluctuations in absolute levels of assets and liabilities. A slight downward trend towards 1.01 near the end of the observed period suggests marginal tightening of liquidity.

Overall, the data suggest that the company has managed to maintain sufficient liquidity to meet its current obligations across the periods. The steady growth in current assets and liabilities towards the end of the timeline may reflect expansion activities or seasonal dynamics in working capital. The resilience of the current ratio close to or slightly above unity underscores effective liquidity management, although the narrowing ratio near the end of the period indicates a cautious approach may be warranted to ensure continued financial stability.


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
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.
AppLovin Corp.
Cadence Design Systems Inc.
CrowdStrike Holdings Inc.
Datadog 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).

1 Q3 2022 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= ÷ =

2 Click competitor name to see calculations.


Total Quick Assets
Total quick assets demonstrated fluctuations over the reported periods. Initially, the values rose from approximately $29.2 billion to a peak near $38.7 billion in the first quarter of 2017. This was followed by periods of decline and recovery, with a notable low point around $25.3 billion in the third quarter of 2019. Post this low, total quick assets generally trended upward, reaching a peak of about $63.2 billion by the first quarter of 2022. Overall, there was significant growth in total quick assets over the observation period, particularly towards the latter quarters.
Current Liabilities
Current liabilities closely tracked the movements in total quick assets, with values generally rising during the same periods of increase in quick assets and falling when quick assets declined. Starting at about $26.7 billion, current liabilities peaked above $39.1 billion in early 2019 before declining to around $29.2 billion in the third quarter of 2019. Subsequently, liabilities increased steadily to reach approximately $63.1 billion by the first quarter of 2022. This movement suggests that increases in current liabilities corresponded with growth in quick assets, indicating an overall expansion in the scale of short-term financial activities.
Quick Ratio
The quick ratio remained relatively stable throughout the examined timeframe, consistently hovering near a ratio of 1.0. Minor fluctuations were observed, with values oscillating between a low of 0.87 in the third quarter of 2019 and highs slightly above 1.06 in several quarters, such as the third quarter of 2016 and the last quarter of 2021. Despite fluctuations in both assets and liabilities, the quick ratio's stability implies sustained short-term liquidity, where quick assets have generally exceeded current liabilities by a modest margin or remained at parity.
Overall Analysis
The period under review reveals that the company maintained its liquidity position, as indicated by the quick ratio consistently around the 1.0 mark. Total quick assets and current liabilities both experienced volatility but showed an upward trend in recent quarters, reflecting growth in the scale of operations or increased short-term assets and obligations. The dip in the quick ratio below 1.0 in late 2019 suggests a momentary reduction in liquidity, which was promptly corrected in subsequent periods. The parallel movement of quick assets and current liabilities suggests that increases in short-term liabilities were accompanied by proportional increases in liquid assets, maintaining the company's ability to cover near-term obligations without difficulty.

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
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.
AppLovin Corp.
Cadence Design Systems Inc.
CrowdStrike Holdings Inc.
Datadog 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).

1 Q3 2022 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= ÷ =

2 Click competitor name to see calculations.


Total Cash Assets
The total cash assets exhibited fluctuations over the examined periods. Initially, there was a growth from approximately 27.6 billion USD to around 36.9 billion USD between September 2016 and March 2017. Subsequently, the cash assets generally declined through late 2017 and 2018, reaching a low near 22.8 billion USD by September 2019. Following this trough, cash assets rebounded notably, peaking at nearly 59.95 billion USD by March 2022. This overall pattern indicates periods of both cash accumulation and deployment, with a significant increase in liquidity towards the end of the period.
Current Liabilities
Current liabilities followed a trend broadly similar to that of total cash assets, with a rise from approximately 26.7 billion USD in September 2016 to about 36.4 billion USD by March 2017. After this, liabilities showed some variations but overall increased steadily, culminating in a marked rise to about 63.1 billion USD by the last date in March 2022. This increase suggests a growing short-term obligation profile, potentially linked to operational expansion or financing strategies over the time frame.
Cash Ratio
The cash ratio, measuring liquidity by comparing cash assets to current liabilities, remained relatively stable between 0.93 and 1.03 during the earlier periods, indicating a generally balanced short-term liquidity position. A notable dip occurred around September 2019 when the ratio dropped to approximately 0.78, signaling a period where current liabilities exceeded cash assets to a greater degree. Thereafter, the ratio largely recovered and stabilized between 0.94 and 0.98 through the end of the observation period, suggesting the company maintained consistent liquidity management despite increasing liabilities.
Overall Analysis
The data indicate that the company managed its liquidity prudently, balancing growing current liabilities with increased cash assets, especially in the latter periods. The dip in liquidity ratios in late 2019 may reflect a transitional phase or investment activities that temporarily constrained immediate cash reserves relative to liabilities. However, the company’s recovery and steady cash ratios afterward demonstrate resilience and an ability to maintain sufficient liquidity coverage against short-term obligations. The trend of rising current liabilities alongside increasing cash assets hints at possible strategic growth or scaling activities requiring significant working capital.