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.

Analysis of Liquidity Ratios
Quarterly Data

Microsoft Excel

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 1.01 1.04 1.05 1.07 1.05 1.06 1.08 1.05 1.03 1.02 1.01 1.05 1.04 1.05 1.03 1.05 1.05 1.06 1.10 1.10 1.09 1.09 1.13 1.10 1.08 1.10 1.13
Quick ratio 1.00 1.03 1.03 1.06 1.03 1.05 1.05 1.03 1.01 1.00 0.87 1.04 1.03 1.02 1.00 1.03 1.03 1.03 1.05 1.07 1.06 1.06 1.09 1.08 1.07 1.07 1.10
Cash ratio 0.95 0.97 0.97 0.98 0.97 0.98 0.98 0.95 0.94 0.94 0.78 0.96 0.97 0.94 0.93 0.96 0.98 0.97 0.99 1.01 1.01 1.01 1.03 1.03 1.02 1.02 1.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).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Automatic Data Processing Inc. current ratio deteriorated from Q1 2022 to Q2 2022 and from Q2 2022 to Q3 2022.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Automatic Data Processing Inc. quick ratio deteriorated from Q1 2022 to Q2 2022 and from Q2 2022 to Q3 2022.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Automatic Data Processing Inc. cash ratio deteriorated from Q1 2022 to Q2 2022 and from Q2 2022 to Q3 2022.

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 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
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
Liquidity Ratio
Current ratio1 1.01 1.04 1.05 1.07 1.05 1.06 1.08 1.05 1.03 1.02 1.01 1.05 1.04 1.05 1.03 1.05 1.05 1.06 1.10 1.10 1.09 1.09 1.13 1.10 1.08 1.10 1.13
Benchmarks
Current Ratio, Competitors2
Accenture PLC 1.27 1.23 1.22 1.25 1.42 1.39 1.45 1.40 1.37 1.38 1.39 1.40 1.34 1.35 1.33 1.34 1.29 1.31 1.25
Adobe Inc. 1.14 1.07 1.04 1.25 1.39 1.31 1.27 1.48 1.44 1.29 1.23 0.79 0.74 0.70 0.97 1.13 1.66 2.08 2.12
International Business Machines Corp. 0.95 0.88 0.92 0.88 0.84 0.84 0.93 0.98 1.05 1.04 0.96 1.02 1.09 1.83 1.36
Intuit Inc. 1.63 1.18 2.10 1.94 1.96 1.53 3.09 2.26 1.79 1.67 1.80 1.83 1.85 1.32 1.41 1.14 1.05 0.63 0.67
Microsoft Corp. 1.99 2.25 2.16 2.08 2.29 2.58 2.53 2.52 2.90 2.80 2.85 2.53 2.97 3.12 2.92 2.90 3.40 2.89 3.12
Oracle Corp. 1.52 1.65 2.04 2.30 2.16 2.17 2.66 3.03 2.12 2.37 2.25 2.49 2.65 2.80 3.43 3.96 4.33 5.07 3.63
Palo Alto Networks Inc. 0.74 0.66 0.68 0.91 1.38 0.98 1.63 1.91 1.29 1.78 1.78 1.78 1.86 1.87 2.10 1.93 1.14 1.19 1.17
Salesforce Inc. 1.06 0.93 1.33 1.23 1.22 1.15 1.15 1.08 1.05 0.97 0.96 0.95 0.86 0.80 1.29
ServiceNow Inc. 1.24 1.12 1.12 1.05 1.13 1.08 1.23 1.21 1.40 1.17 1.03 1.03 1.05 1.10 1.13
Synopsys Inc. 1.14 1.25 1.19 1.16 1.18 1.19 1.10 1.19 1.06 0.95 0.95 0.99 0.99 0.95 0.89 0.73 0.70 0.73 0.68

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
= 63,903,800 ÷ 63,106,500 = 1.01

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Automatic Data Processing Inc. current ratio deteriorated from Q1 2022 to Q2 2022 and from Q2 2022 to Q3 2022.

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 1,634,200 1,745,000 1,602,100 2,575,200 1,891,500 1,602,200 1,613,100 1,908,500 1,705,000 1,500,400 1,403,900 1,949,200 1,826,200 2,785,600 1,490,300 2,170,000 2,293,600 1,773,400 2,363,600 2,780,400 2,995,500 2,705,200 2,776,600 3,191,100 2,941,400 2,794,900 3,184,700
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
Funds held for clients 58,319,600 45,890,400 46,808,600 34,905,800 41,491,000 36,866,200 29,950,300 26,708,100 30,834,400 36,608,600 21,393,200 29,434,200 36,078,200 25,605,900 25,402,700 27,137,800 33,646,700 34,451,300 25,686,200 27,291,500 33,887,100 30,426,400 24,787,200 33,841,200 41,051,500 30,336,000 24,508,700
Total quick assets 63,204,500 50,371,400 51,180,400 40,208,400 46,147,900 40,978,200 34,052,500 31,057,900 35,160,000 40,696,900 25,287,500 33,822,700 40,389,600 31,029,600 29,109,400 31,292,000 37,983,700 38,270,200 29,838,500 31,775,500 38,694,100 34,971,100 29,184,400 38,775,100 46,067,300 34,765,100 29,258,600
 
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
Liquidity Ratio
Quick ratio1 1.00 1.03 1.03 1.06 1.03 1.05 1.05 1.03 1.01 1.00 0.87 1.04 1.03 1.02 1.00 1.03 1.03 1.03 1.05 1.07 1.06 1.06 1.09 1.08 1.07 1.07 1.10
Benchmarks
Quick Ratio, Competitors2
Accenture PLC 1.14 1.10 1.10 1.14 1.31 1.27 1.34 1.29 1.25 1.25 1.28 1.29 1.22 1.23 1.22 1.24 1.19 1.19 1.13
Adobe Inc. 1.01 0.93 0.89 1.11 1.25 1.18 1.12 1.34 1.28 1.11 1.06 0.70 0.64 0.62 0.86 1.06 1.58 1.99 2.04
International Business Machines Corp. 0.74 0.66 0.72 0.67 0.64 0.66 0.75 0.83 0.88 0.88 0.80 0.87 0.91 1.68 1.19
Intuit Inc. 1.29 0.78 1.71 1.60 1.72 1.20 2.74 2.04 1.54 1.30 1.34 1.44 1.57 0.94 0.89 0.86 0.83 0.41 0.42
Microsoft Corp. 1.77 2.05 1.96 1.90 2.10 2.36 2.30 2.33 2.73 2.65 2.68 2.35 2.80 2.93 2.72 2.74 3.24 2.77 2.96
Oracle Corp. 1.34 1.45 1.90 2.15 2.00 2.02 2.50 2.83 1.91 2.16 2.09 2.31 2.45 2.63 3.26 3.78 4.14 4.86 3.49
Palo Alto Networks Inc. 0.70 0.62 0.64 0.86 1.23 0.88 1.48 1.78 1.16 1.64 1.64 1.65 1.73 1.74 1.98 1.81 1.02 1.08 1.06
Salesforce Inc. 0.89 0.79 1.19 1.11 1.05 0.98 1.00 0.95 0.87 0.82 0.81 0.82 0.68 0.64 1.13
ServiceNow Inc. 1.17 1.06 1.06 1.01 1.07 1.03 1.19 1.16 1.33 1.11 0.98 0.98 0.99 1.04 1.06
Synopsys Inc. 0.87 0.99 0.93 0.89 0.90 0.92 0.83 0.94 0.82 0.73 0.73 0.73 0.70 0.67 0.67 0.61 0.60 0.61 0.57

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
= 63,204,500 ÷ 63,106,500 = 1.00

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Automatic Data Processing Inc. quick ratio deteriorated from Q1 2022 to Q2 2022 and from Q2 2022 to Q3 2022.

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 1,634,200 1,745,000 1,602,100 2,575,200 1,891,500 1,602,200 1,613,100 1,908,500 1,705,000 1,500,400 1,403,900 1,949,200 1,826,200 2,785,600 1,490,300 2,170,000 2,293,600 1,773,400 2,363,600 2,780,400 2,995,500 2,705,200 2,776,600 3,191,100 2,941,400 2,794,900 3,184,700
Funds held for clients 58,319,600 45,890,400 46,808,600 34,905,800 41,491,000 36,866,200 29,950,300 26,708,100 30,834,400 36,608,600 21,393,200 29,434,200 36,078,200 25,605,900 25,402,700 27,137,800 33,646,700 34,451,300 25,686,200 27,291,500 33,887,100 30,426,400 24,787,200 33,841,200 41,051,500 30,336,000 24,508,700
Total cash assets 59,953,800 47,635,400 48,410,700 37,481,000 43,382,500 38,468,400 31,563,400 28,616,600 32,539,400 38,109,000 22,797,100 31,383,400 37,904,400 28,391,500 26,893,000 29,307,800 35,940,300 36,224,700 28,049,800 30,071,900 36,882,600 33,131,600 27,563,800 37,032,300 43,992,900 33,130,900 27,693,400
 
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
Liquidity Ratio
Cash ratio1 0.95 0.97 0.97 0.98 0.97 0.98 0.98 0.95 0.94 0.94 0.78 0.96 0.97 0.94 0.93 0.96 0.98 0.97 0.99 1.01 1.01 1.01 1.03 1.03 1.02 1.02 1.04
Benchmarks
Cash Ratio, Competitors2
Accenture PLC 0.41 0.35 0.37 0.52 0.67 0.65 0.68 0.67 0.54 0.49 0.52 0.55 0.45 0.44 0.43 0.50 0.41 0.38 0.37
Adobe Inc. 0.77 0.72 0.65 0.84 1.00 0.94 0.85 1.09 1.03 0.84 0.80 0.51 0.47 0.45 0.61 0.75 1.30 1.70 1.74
International Business Machines Corp. 0.32 0.24 0.32 0.22 0.23 0.22 0.31 0.36 0.41 0.37 0.30 0.24 0.31 1.10 0.47
Intuit Inc. 1.09 0.48 1.52 1.46 1.52 1.02 2.69 2.00 1.46 1.03 1.28 1.39 1.46 0.67 0.84 0.81 0.72 0.24 0.37
Microsoft Corp. 1.35 1.62 1.62 1.47 1.74 1.96 1.97 1.89 2.34 2.25 2.35 1.93 2.44 2.54 2.41 2.29 2.87 2.46 2.68
Oracle Corp. 1.12 1.21 1.70 1.93 1.77 1.81 2.26 2.50 1.64 1.88 1.89 2.03 2.23 2.43 3.07 3.50 3.92 4.62 3.31
Palo Alto Networks Inc. 0.50 0.45 0.48 0.57 0.98 0.72 1.22 1.39 0.87 1.40 1.39 1.37 1.52 1.51 1.76 1.59 0.83 0.88 0.86
Salesforce Inc. 0.62 0.55 0.98 0.67 0.78 0.72 0.76 0.54 0.62 0.59 0.61 0.39 0.43 0.40 0.91
ServiceNow Inc. 0.89 0.81 0.83 0.67 0.80 0.76 0.94 0.83 1.04 0.82 0.68 0.61 0.67 0.74 0.79
Synopsys Inc. 0.60 0.70 0.51 0.65 0.66 0.65 0.47 0.58 0.51 0.42 0.34 0.42 0.42 0.36 0.29 0.34 0.36 0.30 0.31

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
= 59,953,800 ÷ 63,106,500 = 0.95

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Automatic Data Processing Inc. cash ratio deteriorated from Q1 2022 to Q2 2022 and from Q2 2022 to Q3 2022.