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 Solvency Ratios 
Quarterly Data

Microsoft Excel

Solvency Ratios (Summary)

Automatic Data Processing Inc., solvency 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
Debt Ratios
Debt to equity 0.71 0.59 0.57 0.53 0.35 0.34 0.34 0.35 0.37 0.37 1.11 0.42 0.38 0.67 0.52 0.58 0.50 0.51 0.54 0.50 0.49 0.52 0.47
Debt to equity (including operating lease liability) 0.79 0.66 0.63 0.59 0.42 0.40 0.40 0.41 0.43 0.44 1.18 0.42 0.38 0.67 0.52 0.58 0.50 0.51 0.54 0.50 0.49 0.52 0.47
Debt to capital 0.42 0.37 0.36 0.35 0.26 0.25 0.26 0.26 0.27 0.27 0.53 0.30 0.28 0.40 0.34 0.37 0.33 0.34 0.35 0.33 0.33 0.34 0.32
Debt to capital (including operating lease liability) 0.44 0.40 0.39 0.37 0.29 0.28 0.29 0.29 0.30 0.31 0.54 0.30 0.28 0.40 0.34 0.37 0.33 0.34 0.35 0.33 0.33 0.34 0.32
Debt to assets 0.04 0.05 0.05 0.06 0.04 0.04 0.05 0.05 0.05 0.04 0.16 0.05 0.04 0.08 0.07 0.05 0.05 0.04 0.06 0.05 0.05 0.05 0.06
Debt to assets (including operating lease liability) 0.05 0.06 0.06 0.07 0.04 0.05 0.05 0.06 0.05 0.05 0.17 0.05 0.04 0.08 0.07 0.05 0.05 0.04 0.06 0.05 0.05 0.05 0.06
Financial leverage 17.19 11.70 11.21 8.60 9.59 8.36 7.30 6.81 7.90 9.15 7.04 7.76 9.19 8.15 8.00 10.72 10.94 11.33 9.02 9.35 10.69 10.48 8.08
Coverage Ratios
Interest coverage 52.01 53.87 56.42 57.30 56.00 50.63 39.99 30.72 27.23 26.16 24.14 24.14 21.65 21.09 21.52 22.14 25.30 25.50 29.95 32.64 35.08 34.87 32.72

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


Debt to Equity Ratios
The debt to equity ratio exhibited moderate fluctuations over the observed period, beginning around 0.47 to 0.54 between late 2016 and late 2017. Notably, a sharp increase occurred in September 2019, reaching 1.11, before dropping back below 0.4 in the following quarters. From mid-2020 onwards, the ratio remained relatively stable around 0.34 to 0.35 until a gradual increase began in 2021, peaking at 0.71 by the first quarter of 2022. Including operating lease liabilities generally raised the ratio slightly, mirroring the same trend but with marginally higher values throughout.
Debt to Capital Ratios
The debt to capital ratio maintained values mostly between 0.26 and 0.35 for much of the series, with an exception in September 2019 when it abruptly rose to 0.53, then quickly fell back to approximately 0.25 to 0.27 levels. This stability continued until the end of 2019. During 2021, the ratio showed a gradual upward movement, reaching 0.42 by March 2022. Including operating lease liabilities resulted in slightly higher ratios but followed the same pattern.
Debt to Assets Ratios
These ratios remained relatively low and stable, hovering mostly around 0.04 to 0.07 throughout the entire period. A minor spike was observed around September 2019, with the ratio increasing to approximately 0.16 to 0.17, after which it reverted to historical levels. Including operating lease liabilities had a small impact, increasing the ratio slightly but preserving the general trend of low leverage on assets.
Financial Leverage
Financial leverage showed significant variation, ranging from approximately 6.8 to as high as 17.2 by the latest quarter. Initial values in 2016 and 2017 hovered around 8 to 11, dipping somewhat through 2018 and mid-2019 before declining to below 8 by mid-2020. Subsequently, leverage steadily increased with peaks near 11.7 in late 2021 and a substantial surge to 17.19 in early 2022, indicating rising reliance on debt or increased asset base relative to equity.
Interest Coverage Ratio
This ratio maintained very strong coverage throughout the period, consistently above 20 and even exceeding 50 in late 2020 and 2021. The trend initially showed a gradual decline from above 30 in 2016 toward the low 20s by late 2018. However, from 2019 onwards, there was a clear and continuous improvement, reaching a peak of 57.3 in the second quarter of 2021 before a slight decline to 52 by early 2022. This suggests increasing earnings ability to cover interest expenses, reflecting improved profitability or reduced interest costs over time.

Debt Ratios


Coverage Ratios


Debt to Equity

Automatic Data Processing Inc., debt to equity 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)
Obligations under reverse repurchase agreements 45,800 23,500 13,600 428,600 262,000 453,000 129,400
Obligations under commercial paper borrowings 3,536,700 1,206,000
Short-term debt 1,001,800 1,001,800 1,001,600 1,001,300
Long-term debt 2,986,600 2,986,100 2,985,500 2,985,000 1,994,300 1,994,100 1,993,900 1,002,800 1,002,800 1,003,000 1,003,400 2,002,200 2,002,300 2,002,300 2,002,400 2,002,400 2,002,400 2,002,400 2,002,100 2,002,400 2,002,500 2,002,500 2,007,700
Total debt 2,986,600 2,986,100 3,031,300 3,008,500 1,994,300 1,994,100 1,993,900 2,018,200 2,004,600 2,004,600 5,970,000 2,264,200 2,002,300 3,208,300 2,455,400 2,002,400 2,002,400 2,002,400 2,131,500 2,002,400 2,002,500 2,002,500 2,007,700
 
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
Solvency Ratio
Debt to equity1 0.71 0.59 0.57 0.53 0.35 0.34 0.34 0.35 0.37 0.37 1.11 0.42 0.38 0.67 0.52 0.58 0.50 0.51 0.54 0.50 0.49 0.52 0.47
Benchmarks
Debt to Equity, Competitors2
Accenture PLC 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Adobe Inc. 0.29 0.30 0.30 0.28 0.29 0.30 0.30 0.31 0.35 0.38 0.39
AppLovin Corp. 1.71 1.69 1.60
Cadence Design Systems Inc. 0.29 0.13 0.13 0.13 0.13 0.14 0.14
CrowdStrike Holdings Inc. 0.78 0.82 0.87 0.85 0.00 0.00 0.00
Datadog Inc. 0.57 0.61 0.66 0.71 0.77 0.80 0.87
International Business Machines Corp. 2.53 2.59 2.85 2.74 2.45 2.51 2.64
Intuit Inc. 0.40 0.43 0.21 0.21 0.20 0.27 0.45
Microsoft Corp. 0.31 0.33 0.35 0.41 0.43 0.46 0.52
Oracle Corp. 16.08 7.79 8.94 7.46
Palantir Technologies Inc. 0.00 0.00 0.00
Palo Alto Networks Inc. 10.89 31.19 7.08 5.08 3.20 3.04 4.18
Salesforce Inc. 0.19 0.24 0.06 0.06 0.07 0.07 0.08
ServiceNow Inc. 0.33 0.35 0.39 0.43 0.45 0.48 0.53
Synopsys Inc. 0.00 0.00 0.00 0.02 0.02 0.02 0.03 0.03 0.03 0.06 0.08
Workday Inc. 0.44 0.48 0.55 0.55 0.58 0.63 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).

1 Q3 2022 Calculation
Debt to equity = Total debt ÷ Stockholders’ equity
= 2,986,600 ÷ 4,192,900 = 0.71

2 Click competitor name to see calculations.


The financial data reflects fluctuating trends in the company's leverage and capital structure over multiple quarters. Total debt exhibits variability, initially remaining close to approximately $2 billion from late 2016 through mid-2017, before a marked increase to approximately $2.46 billion and subsequently to over $3.2 billion by the end of 2018. A notable spike occurs in the third quarter of 2019 with debt reaching nearly $6 billion, followed by a return to more stable levels near $2 billion through mid-2020. From late 2020 onward, total debt rises again, approaching approximately $3 billion by the first quarter of 2022.

Stockholders’ equity demonstrates a generally upward trend from the end of 2016 to mid-2019, increasing from roughly $3.8 billion to over $5.3 billion. After peaking around mid-2020 at nearly $5.9 billion, equity declines consistently through early 2022, falling to approximately $4.2 billion. This decline in equity during the later periods contrasts with the rising debt levels observed.

Debt to Equity Ratio
The debt to equity ratio fluctuates significantly over the period. Initially, the ratio hovers between 0.47 and 0.54 from late 2016 through late 2017, reflecting a moderate leverage position. The ratio spikes to a high of 1.11 in the third quarter of 2019, concurrent with the dramatic rise in total debt noted earlier, indicating a substantial increase in financial leverage. Following this peak, the ratio falls back to lower levels near 0.34–0.37 through mid-2020, consistent with debt normalization and increasing equity. Starting late 2020, the ratio trends upwards again, reaching 0.71 by early 2022, suggesting a renewed increase in leverage relative to equity.

Overall, the data reveals periods of both leverage expansion and contraction, with a pronounced leverage peak in mid-2019. The company's capital structure appears to have been more heavily leveraged during this time frame, followed by deleveraging and increasing equity until mid-2020, after which leverage begins to rise once more. The recent upward trend in the debt to equity ratio alongside declining equity may warrant further analysis concerning the company's risk profile and financial strategy going forward.


Debt to Equity (including Operating Lease Liability)

Automatic Data Processing Inc., debt to equity (including operating lease liability) 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)
Obligations under reverse repurchase agreements 45,800 23,500 13,600 428,600 262,000 453,000 129,400
Obligations under commercial paper borrowings 3,536,700 1,206,000
Short-term debt 1,001,800 1,001,800 1,001,600 1,001,300
Long-term debt 2,986,600 2,986,100 2,985,500 2,985,000 1,994,300 1,994,100 1,993,900 1,002,800 1,002,800 1,003,000 1,003,400 2,002,200 2,002,300 2,002,300 2,002,400 2,002,400 2,002,400 2,002,400 2,002,100 2,002,400 2,002,500 2,002,500 2,007,700
Total debt 2,986,600 2,986,100 3,031,300 3,008,500 1,994,300 1,994,100 1,993,900 2,018,200 2,004,600 2,004,600 5,970,000 2,264,200 2,002,300 3,208,300 2,455,400 2,002,400 2,002,400 2,002,400 2,131,500 2,002,400 2,002,500 2,002,500 2,007,700
Long-term operating lease liabilities 344,900 363,500 345,700 343,200 360,900 357,400 330,400 344,400 361,200 360,200 355,400
Total debt (including operating lease liability) 3,331,500 3,349,600 3,377,000 3,351,700 2,355,200 2,351,500 2,324,300 2,362,600 2,365,800 2,364,800 6,325,400 2,264,200 2,002,300 3,208,300 2,455,400 2,002,400 2,002,400 2,002,400 2,131,500 2,002,400 2,002,500 2,002,500 2,007,700
 
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
Solvency Ratio
Debt to equity (including operating lease liability)1 0.79 0.66 0.63 0.59 0.42 0.40 0.40 0.41 0.43 0.44 1.18 0.42 0.38 0.67 0.52 0.58 0.50 0.51 0.54 0.50 0.49 0.52 0.47
Benchmarks
Debt to Equity (including Operating Lease Liability), Competitors2
Accenture PLC 0.16 0.17 0.17 0.18 0.18 0.19 0.19
Adobe Inc. 0.32 0.33 0.34 0.32 0.33 0.34 0.35 0.35 0.40 0.43 0.45
CrowdStrike Holdings Inc. 0.82 0.86 0.92 0.89 0.05 0.06 0.05
Datadog Inc. 0.65 0.67 0.72 0.78 0.84 0.87 0.95
International Business Machines Corp. 2.68 2.75 3.02 2.92 2.65 2.72 2.86
Intuit Inc. 0.43 0.46 0.25 0.24 0.24 0.31 0.49
Microsoft Corp. 0.38 0.40 0.42 0.48 0.50 0.53 0.58
Palantir Technologies Inc. 0.10 0.11 0.11
Palo Alto Networks Inc. 11.70 33.58 7.65 5.58 3.52 3.35 4.61
Salesforce Inc. 0.25 0.30 0.14 0.15 0.14 0.15 0.17
ServiceNow Inc. 0.47 0.51 0.55 0.60 0.63 0.64 0.69
Synopsys Inc. 0.12 0.12 0.11 0.13 0.13 0.14 0.13 0.14 0.15 0.18 0.21
Workday Inc. 0.51 0.56 0.63 0.68 0.72 0.75 0.81

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
Debt to equity (including operating lease liability) = Total debt (including operating lease liability) ÷ Stockholders’ equity
= 3,331,500 ÷ 4,192,900 = 0.79

2 Click competitor name to see calculations.


The analysis of the quarterly financial data reveals several noteworthy trends concerning the company's leverage and equity position over the given period.

Total Debt (including operating lease liability)
This metric exhibits fluctuations over time, with values generally ranging between approximately 2.0 billion and 3.3 billion US dollars. There is a notable peak in total debt at the end of 2018 and early 2019, where debt rises sharply to over 3.2 billion and then declines again. Another significant spike occurs in the third quarter of 2019, reaching over 6.3 billion, followed by a steep reduction. In the later quarters, particularly from 2020 onward, total debt remains more stable, hovering around 2.3 billion to 3.3 billion.
Stockholders’ Equity
Equity shows variability over the timeline but generally trends upwards from about 3.8 billion in late 2016 to a peak near 5.9 billion in late 2020. After reaching this high, equity experiences a gradual decline through 2021 and into early 2022, falling back to approximately 4.2 billion. This pattern suggests initial growth in the company's net asset base, followed by some erosion in the more recent quarters.
Debt to Equity Ratio (including operating lease liability)
The debt to equity ratio demonstrates considerable volatility. Ratios mostly remain under 0.6 until early 2019, with a dip as low as 0.38 indicating relatively conservative leverage during this period. However, there is a sharp increase in the ratio in the third quarter of 2019, surging to above 1.18, signifying a temporary rise in leverage exceeding equity. Following this peak, the ratio decreases again, stabilizing between 0.4 and 0.6 for much of 2020 and 2021. The end of 2021 and early 2022 show an increasing trend in leverage ratios, rising to nearly 0.8 by the latest quarter.

In summary, the company generally maintains a moderate debt level relative to equity, though it experiences occasional spikes indicating periods of increased borrowing or changes in capital structure. Equity growth predominates up to 2020, after which there is a decline, potentially reflecting market or operational challenges. The leverage ratio analysis highlights episodes of heightened financial risk, particularly in 2019, with a later trend toward increased leverage in 2021 and early 2022. These patterns underline the importance of monitoring capital structure adjustments and their implications for financial stability.


Debt to Capital

Automatic Data Processing Inc., debt to capital 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)
Obligations under reverse repurchase agreements 45,800 23,500 13,600 428,600 262,000 453,000 129,400
Obligations under commercial paper borrowings 3,536,700 1,206,000
Short-term debt 1,001,800 1,001,800 1,001,600 1,001,300
Long-term debt 2,986,600 2,986,100 2,985,500 2,985,000 1,994,300 1,994,100 1,993,900 1,002,800 1,002,800 1,003,000 1,003,400 2,002,200 2,002,300 2,002,300 2,002,400 2,002,400 2,002,400 2,002,400 2,002,100 2,002,400 2,002,500 2,002,500 2,007,700
Total debt 2,986,600 2,986,100 3,031,300 3,008,500 1,994,300 1,994,100 1,993,900 2,018,200 2,004,600 2,004,600 5,970,000 2,264,200 2,002,300 3,208,300 2,455,400 2,002,400 2,002,400 2,002,400 2,131,500 2,002,400 2,002,500 2,002,500 2,007,700
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
Total capital 7,179,500 8,035,700 8,382,000 8,678,600 7,668,200 7,894,100 7,802,800 7,770,400 7,495,300 7,369,000 11,330,700 7,664,100 7,248,500 7,972,200 7,134,200 5,462,000 6,031,600 5,933,600 6,084,900 5,979,400 6,105,600 5,817,600 6,257,800
Solvency Ratio
Debt to capital1 0.42 0.37 0.36 0.35 0.26 0.25 0.26 0.26 0.27 0.27 0.53 0.30 0.28 0.40 0.34 0.37 0.33 0.34 0.35 0.33 0.33 0.34 0.32
Benchmarks
Debt to Capital, Competitors2
Accenture PLC 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Adobe Inc. 0.22 0.23 0.23 0.22 0.22 0.23 0.23 0.24 0.26 0.27 0.28
AppLovin Corp. 0.63 0.63 0.62
Cadence Design Systems Inc. 0.23 0.12 0.11 0.11 0.12 0.12 0.12
CrowdStrike Holdings Inc. 0.44 0.45 0.47 0.46 0.00 0.00 0.00
Datadog Inc. 0.36 0.38 0.40 0.41 0.43 0.45 0.47
International Business Machines Corp. 0.72 0.72 0.74 0.73 0.71 0.72 0.73
Intuit Inc. 0.29 0.30 0.17 0.17 0.17 0.21 0.31
Microsoft Corp. 0.23 0.25 0.26 0.29 0.30 0.32 0.34
Oracle Corp. 1.12 1.15 1.02 0.94 0.89 0.90 0.88
Palantir Technologies Inc. 0.00 0.00 0.00
Palo Alto Networks Inc. 0.92 0.97 0.88 0.84 0.76 0.75 0.81
Salesforce Inc. 0.16 0.19 0.06 0.06 0.06 0.07 0.07
ServiceNow Inc. 0.25 0.26 0.28 0.30 0.31 0.33 0.35
Synopsys Inc. 0.00 0.00 0.00 0.02 0.02 0.02 0.02 0.03 0.03 0.05 0.07
Workday Inc. 0.30 0.32 0.35 0.35 0.37 0.39 0.41

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
Debt to capital = Total debt ÷ Total capital
= 2,986,600 ÷ 7,179,500 = 0.42

2 Click competitor name to see calculations.


The analysis of the financial data reveals notable variations and trends in the company's debt structure and capital management over the observed periods.

Total Debt
Total debt levels remained relatively stable around the two million US dollar mark during the early periods, with minor fluctuations. A significant increase is observed in the period ending September 30, 2018, reaching approximately 2.46 million US dollars, followed by a further substantial increase to over 3.2 million by December 31, 2018. This spike is not sustained, as debt returns close to previous levels around two million in the subsequent quarters but surges dramatically to nearly 6 million by September 30, 2019. Following this peak, total debt decreases sharply and stabilizes between approximately 1.99 and 2.01 million until mid-2021, when another uptrend begins, culminating in an increase to nearly 3 million by the end of the observation period.
Total Capital
Total capital displays more pronounced variability compared to debt, fluctuating between roughly 5.4 million and 11.3 million US dollars. The lower range appears in mid-2018, followed by a pronounced increase reaching a peak in September 2019. After this peak, total capital declines steadily toward the end of the period, moving from over 11.3 million down to approximately 7.2 million US dollars. This downward trend in total capital, particularly after 2019, reflects significant changes in the firm's capital base.
Debt to Capital Ratio
The debt to capital ratio reflects the proportion of debt used in the company’s capital structure and shows considerable fluctuations throughout the periods. Initial ratios lie in the range of 0.32 to 0.35, indicating moderate leverage. A marked increase occurs around September 2018 to December 2018, peaking at 0.40, then decreasing sharply to between 0.27 and 0.30 by the end of 2019, suggesting a reduction in leverage. However, the ratio rises again noticeably in 2021, reaching values above 0.35 and eventually climbing to 0.42 by the quarter ended March 31, 2022. This pattern indicates cyclical variations in leverage, with periods of increased borrowing relative to capital, followed by deleveraging phases.

In summary, the company experienced periods of significant debt accumulation, especially around late 2018 and late 2019, followed by notable deleveraging. Total capital peaked in late 2019 but declined thereafter. The debt to capital ratio corroborates these dynamics, showing cycles of increasing and decreasing leverage. These trends suggest active capital and debt management strategies responsive to changing financial conditions or strategic initiatives.


Debt to Capital (including Operating Lease Liability)

Automatic Data Processing Inc., debt to capital (including operating lease liability) 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)
Obligations under reverse repurchase agreements 45,800 23,500 13,600 428,600 262,000 453,000 129,400
Obligations under commercial paper borrowings 3,536,700 1,206,000
Short-term debt 1,001,800 1,001,800 1,001,600 1,001,300
Long-term debt 2,986,600 2,986,100 2,985,500 2,985,000 1,994,300 1,994,100 1,993,900 1,002,800 1,002,800 1,003,000 1,003,400 2,002,200 2,002,300 2,002,300 2,002,400 2,002,400 2,002,400 2,002,400 2,002,100 2,002,400 2,002,500 2,002,500 2,007,700
Total debt 2,986,600 2,986,100 3,031,300 3,008,500 1,994,300 1,994,100 1,993,900 2,018,200 2,004,600 2,004,600 5,970,000 2,264,200 2,002,300 3,208,300 2,455,400 2,002,400 2,002,400 2,002,400 2,131,500 2,002,400 2,002,500 2,002,500 2,007,700
Long-term operating lease liabilities 344,900 363,500 345,700 343,200 360,900 357,400 330,400 344,400 361,200 360,200 355,400
Total debt (including operating lease liability) 3,331,500 3,349,600 3,377,000 3,351,700 2,355,200 2,351,500 2,324,300 2,362,600 2,365,800 2,364,800 6,325,400 2,264,200 2,002,300 3,208,300 2,455,400 2,002,400 2,002,400 2,002,400 2,131,500 2,002,400 2,002,500 2,002,500 2,007,700
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
Total capital (including operating lease liability) 7,524,400 8,399,200 8,727,700 9,021,800 8,029,100 8,251,500 8,133,200 8,114,800 7,856,500 7,729,200 11,686,100 7,664,100 7,248,500 7,972,200 7,134,200 5,462,000 6,031,600 5,933,600 6,084,900 5,979,400 6,105,600 5,817,600 6,257,800
Solvency Ratio
Debt to capital (including operating lease liability)1 0.44 0.40 0.39 0.37 0.29 0.28 0.29 0.29 0.30 0.31 0.54 0.30 0.28 0.40 0.34 0.37 0.33 0.34 0.35 0.33 0.33 0.34 0.32
Benchmarks
Debt to Capital (including Operating Lease Liability), Competitors2
Accenture PLC 0.14 0.15 0.15 0.15 0.15 0.16 0.16
Adobe Inc. 0.24 0.25 0.25 0.24 0.25 0.25 0.26 0.26 0.29 0.30 0.31
CrowdStrike Holdings Inc. 0.45 0.46 0.48 0.47 0.05 0.05 0.05
Datadog Inc. 0.39 0.40 0.42 0.44 0.46 0.46 0.49
International Business Machines Corp. 0.73 0.73 0.75 0.74 0.73 0.73 0.74
Intuit Inc. 0.30 0.31 0.20 0.20 0.19 0.24 0.33
Microsoft Corp. 0.27 0.29 0.29 0.32 0.33 0.35 0.37
Palantir Technologies Inc. 0.09 0.10 0.10
Palo Alto Networks Inc. 0.92 0.97 0.88 0.85 0.78 0.77 0.82
Salesforce Inc. 0.20 0.23 0.13 0.13 0.13 0.13 0.14
ServiceNow Inc. 0.32 0.34 0.36 0.37 0.39 0.39 0.41
Synopsys Inc. 0.11 0.11 0.10 0.11 0.12 0.12 0.12 0.12 0.13 0.15 0.17
Workday Inc. 0.34 0.36 0.39 0.41 0.42 0.43 0.45

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
Debt to capital (including operating lease liability) = Total debt (including operating lease liability) ÷ Total capital (including operating lease liability)
= 3,331,500 ÷ 7,524,400 = 0.44

2 Click competitor name to see calculations.


Trend in Total Debt
The total debt experienced fluctuations over the observed periods, starting near 2.0 billion USD and remaining relatively stable around this level until late 2017. A notable increase occurred during the latter part of 2018, reaching over 3.2 billion USD at year-end 2018, followed by a sharp decrease back to around 2.0 billion USD in early 2019. In late 2019 to early 2022, total debt showed a significant rise, peaking above 6.3 billion USD at one point, and then settling around 3.3 billion USD by the end of the analyzed timeframe.
Trend in Total Capital
Total capital exhibited variability throughout the periods, beginning at approximately 6.3 billion USD in late 2016. It showed some downward movement during 2017 and mid-2018 but then increased sharply during late 2018 and especially in early 2022, exceeding 11.6 billion USD at its highest point. Toward the end of the period, total capital decreased steadily, finishing around 7.5 billion USD.
Debt to Capital Ratio Analysis
The debt to capital ratio remained mostly within a moderate range around 0.3 to 0.4 throughout most periods. An exception occurred in early 2022 when the ratio spiked to 0.54, indicating substantially higher leverage relative to capital at that time. Subsequently, although the ratio declined after this peak, it remained elevated compared to the initial periods, ending near 0.44.
General Insights
The data indicate periods of increased leverage and capital restructuring, with notable peaks in both total debt and total capital around late 2018 and early 2022. The elevated debt to capital ratio in early 2022 suggests a strategic shift toward higher debt financing during that period. However, the subsequent reduction in total capital and stabilization of debt levels may indicate efforts to manage leverage following these peaks. Overall, the company’s financial structure has demonstrated periodic adjustments in debt and capital levels, reflecting dynamic financial management in response to evolving conditions.

Debt to Assets

Automatic Data Processing Inc., debt to assets 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)
Obligations under reverse repurchase agreements 45,800 23,500 13,600 428,600 262,000 453,000 129,400
Obligations under commercial paper borrowings 3,536,700 1,206,000
Short-term debt 1,001,800 1,001,800 1,001,600 1,001,300
Long-term debt 2,986,600 2,986,100 2,985,500 2,985,000 1,994,300 1,994,100 1,993,900 1,002,800 1,002,800 1,003,000 1,003,400 2,002,200 2,002,300 2,002,300 2,002,400 2,002,400 2,002,400 2,002,400 2,002,100 2,002,400 2,002,500 2,002,500 2,007,700
Total debt 2,986,600 2,986,100 3,031,300 3,008,500 1,994,300 1,994,100 1,993,900 2,018,200 2,004,600 2,004,600 5,970,000 2,264,200 2,002,300 3,208,300 2,455,400 2,002,400 2,002,400 2,002,400 2,131,500 2,002,400 2,002,500 2,002,500 2,007,700
 
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
Solvency Ratio
Debt to assets1 0.04 0.05 0.05 0.06 0.04 0.04 0.05 0.05 0.05 0.04 0.16 0.05 0.04 0.08 0.07 0.05 0.05 0.04 0.06 0.05 0.05 0.05 0.06
Benchmarks
Debt to Assets, Competitors2
Accenture PLC 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Adobe Inc. 0.15 0.16 0.16 0.15 0.16 0.16 0.16 0.17 0.18 0.19 0.19
AppLovin Corp. 0.55 0.54 0.52
Cadence Design Systems Inc. 0.16 0.08 0.08 0.08 0.08 0.08 0.09
CrowdStrike Holdings Inc. 0.22 0.24 0.26 0.27 0.00 0.00 0.00
Datadog Inc. 0.26 0.28 0.29 0.31 0.33 0.35 0.38
International Business Machines Corp. 0.40 0.39 0.41 0.39 0.38 0.38 0.38
Intuit Inc. 0.24 0.26 0.14 0.13 0.13 0.16 0.24
Microsoft Corp. 0.14 0.16 0.16 0.17 0.19 0.20 0.21
Oracle Corp. 0.72 0.73 0.67 0.64 0.59 0.64 0.62
Palantir Technologies Inc. 0.00 0.00 0.00
Palo Alto Networks Inc. 0.33 0.35 0.35 0.31 0.33 0.33 0.36
Salesforce Inc. 0.12 0.15 0.04 0.04 0.05 0.05 0.05
ServiceNow Inc. 0.13 0.13 0.14 0.15 0.17 0.17 0.18
Synopsys Inc. 0.00 0.00 0.00 0.01 0.01 0.01 0.02 0.02 0.02 0.03 0.05
Workday Inc. 0.20 0.20 0.22 0.21 0.23 0.24 0.25

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
Debt to assets = Total debt ÷ Total assets
= 2,986,600 ÷ 72,068,100 = 0.04

2 Click competitor name to see calculations.


The financial data reveals the company’s management of debt relative to its asset base over multiple quarters. An examination of the key financial indicators provides insights into the company's leverage and asset growth trends.

Total Debt
Total debt levels have generally ranged between approximately $2 billion and $6 billion across the periods analyzed. Notably, there was a significant spike in total debt during the quarter ending September 30, 2019, reaching nearly $6 billion, which is substantially higher than the surrounding periods. However, this elevated debt was temporary, as subsequent quarters show a decline back to around $2 billion to $3 billion. Large fluctuations in total debt suggest episodic debt financing or restructuring activities rather than gradual changes.
Total Assets
Total assets exhibited a mostly upward trajectory during the period, with values increasing from roughly $34 billion in late 2016 to over $72 billion in early 2022. Despite some quarter-to-quarter volatility, the overall trend indicates steady growth in asset size. Significant increases correspond with certain periods, which may reflect asset acquisitions, operational expansion, or valuation changes.
Debt to Assets Ratio
The debt-to-assets ratio remained relatively low throughout the timeframe, mostly fluctuating between 0.04 and 0.07, indicating conservative leverage relative to the size of assets. A noticeable exception appears in the quarter ending September 30, 2019, coinciding with the spike in total debt, where this ratio rose sharply to 0.16. This indicates a transient increase in leverage, possibly due to short-term borrowing or strategic financing decisions. Outside this quarter, the ratio suggests that the company maintained a low level of debt relative to its asset base.

Overall, the company demonstrates a strong asset growth trend over the evaluated quarters, while maintaining low leverage with some episodic borrowing spikes. The temporary surge in total debt and leverage ratio around Q3 2019 stands out as an anomaly, after which the company returned to a more conservative debt position.


Debt to Assets (including Operating Lease Liability)

Automatic Data Processing Inc., debt to assets (including operating lease liability) 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)
Obligations under reverse repurchase agreements 45,800 23,500 13,600 428,600 262,000 453,000 129,400
Obligations under commercial paper borrowings 3,536,700 1,206,000
Short-term debt 1,001,800 1,001,800 1,001,600 1,001,300
Long-term debt 2,986,600 2,986,100 2,985,500 2,985,000 1,994,300 1,994,100 1,993,900 1,002,800 1,002,800 1,003,000 1,003,400 2,002,200 2,002,300 2,002,300 2,002,400 2,002,400 2,002,400 2,002,400 2,002,100 2,002,400 2,002,500 2,002,500 2,007,700
Total debt 2,986,600 2,986,100 3,031,300 3,008,500 1,994,300 1,994,100 1,993,900 2,018,200 2,004,600 2,004,600 5,970,000 2,264,200 2,002,300 3,208,300 2,455,400 2,002,400 2,002,400 2,002,400 2,131,500 2,002,400 2,002,500 2,002,500 2,007,700
Long-term operating lease liabilities 344,900 363,500 345,700 343,200 360,900 357,400 330,400 344,400 361,200 360,200 355,400
Total debt (including operating lease liability) 3,331,500 3,349,600 3,377,000 3,351,700 2,355,200 2,351,500 2,324,300 2,362,600 2,365,800 2,364,800 6,325,400 2,264,200 2,002,300 3,208,300 2,455,400 2,002,400 2,002,400 2,002,400 2,131,500 2,002,400 2,002,500 2,002,500 2,007,700
 
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
Solvency Ratio
Debt to assets (including operating lease liability)1 0.05 0.06 0.06 0.07 0.04 0.05 0.05 0.06 0.05 0.05 0.17 0.05 0.04 0.08 0.07 0.05 0.05 0.04 0.06 0.05 0.05 0.05 0.06
Benchmarks
Debt to Assets (including Operating Lease Liability), Competitors2
Accenture PLC 0.08 0.08 0.08 0.08 0.08 0.09 0.09
Adobe Inc. 0.17 0.18 0.18 0.17 0.18 0.18 0.19 0.19 0.21 0.22 0.22
CrowdStrike Holdings Inc. 0.24 0.25 0.27 0.29 0.02 0.03 0.03
Datadog Inc. 0.30 0.31 0.32 0.34 0.37 0.38 0.41
International Business Machines Corp. 0.43 0.42 0.43 0.42 0.41 0.41 0.41
Intuit Inc. 0.25 0.27 0.16 0.16 0.15 0.19 0.27
Microsoft Corp. 0.18 0.19 0.19 0.20 0.22 0.23 0.24
Palantir Technologies Inc. 0.07 0.08 0.08
Palo Alto Networks Inc. 0.36 0.38 0.38 0.35 0.37 0.37 0.39
Salesforce Inc. 0.16 0.19 0.09 0.09 0.10 0.10 0.11
ServiceNow Inc. 0.19 0.19 0.20 0.21 0.23 0.23 0.24
Synopsys Inc. 0.07 0.07 0.07 0.08 0.08 0.08 0.08 0.08 0.09 0.11 0.12
Workday Inc. 0.23 0.24 0.25 0.26 0.28 0.28 0.29

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
Debt to assets (including operating lease liability) = Total debt (including operating lease liability) ÷ Total assets
= 3,331,500 ÷ 72,068,100 = 0.05

2 Click competitor name to see calculations.


Total Debt (Including Operating Lease Liability)
The total debt has experienced a generally stable trend with fluctuations across the periods. Initially, it remained near the 2,000,000 mark (in thousands of US dollars) until late 2017, but starting in late 2018, there were noticeable increases, peaking at 6,325,400 in March 2019. This peak was followed by a return to lower values around 2,300,000 to 3,300,000, with some increases observed in the last periods, reaching values above 3,300,000 by the first quarter of 2022. The variability indicates episodic increases in leverage possibly related to strategic financing or lease liabilities adjustments.
Total Assets
Total assets exhibited a fluctuating yet generally upward trajectory over the covered quarters. From a starting point of approximately 34,337,400 (thousands) in September 2016, assets rose significantly to highs exceeding 59,000,000 towards the end of 2021 and early 2022. This increase implies asset base growth, although certain quarters showed declines, suggesting asset portfolio rebalancing or other balance sheet management activities. The fluctuations demonstrate responsiveness to business conditions and investment opportunities.
Debt to Assets Ratio
The debt to assets ratio has remained relatively low and stable, reflecting a conservative leverage position. Ratios mostly range between 0.04 and 0.08, with an outlier reaching 0.17 in March 2019 coinciding with the peak in total debt observed in the same quarter. This indicates that despite fluctuations in total debt, the company maintains a strong asset backing, and the proportion of debt relative to assets is generally kept low. The temporary spike in early 2019 may indicate a short-term financing decision or asset valuation effect.

Financial Leverage

Automatic Data Processing Inc., financial leverage 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)
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
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
Solvency Ratio
Financial leverage1 17.19 11.70 11.21 8.60 9.59 8.36 7.30 6.81 7.90 9.15 7.04 7.76 9.19 8.15 8.00 10.72 10.94 11.33 9.02 9.35 10.69 10.48 8.08
Benchmarks
Financial Leverage, Competitors2
Accenture PLC 2.16 2.16 2.15 2.21 2.18 2.18 2.14
Adobe Inc. 1.86 1.88 1.89 1.84 1.81 1.85 1.84 1.83 1.91 1.99 2.03
AppLovin Corp. 3.08 3.11 3.06
Cadence Design Systems Inc. 1.83 1.66 1.59 1.60 1.60 1.64 1.57
CrowdStrike Holdings Inc. 3.48 3.47 3.39 3.14 2.15 2.04 2.02
Datadog Inc. 2.17 2.18 2.26 2.29 2.29 2.27 2.32
International Business Machines Corp. 6.27 6.57 7.00 6.98 6.49 6.69 6.95
Intuit Inc. 1.68 1.69 1.53 1.57 1.58 1.65 1.85
Microsoft Corp. 2.12 2.13 2.21 2.35 2.30 2.34 2.44
Oracle Corp. 25.03 13.27 13.90 11.96
Palantir Technologies Inc. 1.39 1.40 1.40
Palo Alto Networks Inc. 32.88 88.29 20.09 16.14 9.59 9.15 11.68
Salesforce Inc. 1.53 1.60 1.52 1.60 1.47 1.50 1.55
ServiceNow Inc. 2.46 2.65 2.75 2.92 2.68 2.81 2.90
Synopsys Inc. 1.66 1.66 1.65 1.65 1.65 1.64 1.64 1.64 1.67 1.71 1.74
Workday Inc. 2.24 2.36 2.53 2.66 2.55 2.64 2.78

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
Financial leverage = Total assets ÷ Stockholders’ equity
= 72,068,100 ÷ 4,192,900 = 17.19

2 Click competitor name to see calculations.


Total Assets
Total assets demonstrate considerable variability across the periods analyzed without a consistent directional trend. The value peaked initially at nearly 44 billion US dollars in early 2017 before declining to approximately 35 billion by mid-2017. Following this, there was a pattern of fluctuations with significant increases toward the end of 2018 and into early 2019, culminating in values exceeding 54 billion US dollars by early 2021. Subsequently, a marked upward trajectory is observed, with total assets reaching their highest point at over 72 billion US dollars by the first quarter of 2022. This suggests periods of expansion interspersed with contractions, with an overall upward movement in asset base over the longer term.
Stockholders’ Equity
Stockholders’ equity values exhibit moderate fluctuations over the same intervals but display a generally stable to slightly declining trend in recent quarters. Initial values are around 4.25 billion US dollars, dropping to near 3.45 billion by mid-2018, followed by a recovery period that raised equity to over 5.3 billion by early 2020. However, the latter data points reveal a gradual decline, with equity decreasing steadily to roughly 4.2 billion US dollars by the first quarter of 2022. This pattern may indicate variations in retained earnings, share issuances or buybacks, and possibly dividend payments affecting the equity base.
Financial Leverage
Financial leverage ratios vary notably throughout the periods under review. Starting at approximately 8.08, leverage intensified to a peak exceeding 11 by late 2016 and early 2017, reflecting increased reliance on debt relative to equity. It then declined to a low near 6.81 in mid-2020, indicating deleveraging or equity growth relative to debt. However, from that point onward, the leverage ratio increased sharply, escalating to 17.19 by the first quarter of 2022. This notable rise implies a substantial increase in debt or a decrease in equity, or both, signaling a shift toward greater financial risk and potentially more aggressive capital structure strategies in the most recent periods.

Interest Coverage

Automatic Data Processing Inc., interest coverage 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)
Net earnings 928,500 694,400 700,500 538,200 810,700 647,500 602,100 411,600 820,900 651,600 582,400 475,500 753,700 558,200 505,400 108,700 643,100 467,500 401,500 265,900 587,900 510,900 368,700
Less: Net loss from discontinued operations
Add: Income tax expense 261,400 215,700 200,300 159,000 255,500 185,100 163,100 119,700 255,800 183,900 156,700 157,800 230,800 182,800 141,400 95,900 209,500 98,200 146,700 122,400 240,000 275,300 160,000
Add: Interest expense 18,400 18,400 18,500 17,200 13,500 13,900 15,100 15,600 20,000 31,600 39,900 33,700 21,700 38,600 35,900 28,600 18,600 27,500 28,000 22,800 16,800 20,500 19,900
Earnings before interest and tax (EBIT) 1,208,300 928,500 919,300 714,400 1,079,700 846,500 780,300 546,900 1,096,700 867,100 779,000 667,000 1,006,200 779,600 682,700 233,200 871,200 593,200 576,200 411,100 844,700 806,700 548,600
Solvency Ratio
Interest coverage1 52.01 53.87 56.42 57.30 56.00 50.63 39.99 30.72 27.23 26.16 24.14 24.14 21.65 21.09 21.52 22.14 25.30 25.50 29.95 32.64 35.08 34.87 32.72
Benchmarks
Interest Coverage, Competitors2
Accenture PLC 188.01 133.08 133.32 131.46 126.89 196.99 191.96
Adobe Inc. 54.21 54.34 53.39 51.49 49.52 45.92 42.50 37.00 32.36 28.08 23.87
AppLovin Corp. 0.25 0.19 0.02
Cadence Design Systems Inc. 57.84 58.34 52.92 46.26 44.21 40.38 35.68
CrowdStrike Holdings Inc. -6.41 -8.16 -12.40 -55.36 -151.33 -185.47 -226.03
Datadog Inc. 0.81 1.72 1.24 0.12 -0.48 -0.44 -0.18
International Business Machines Corp. 1.59 6.01 5.40 5.19 3.79 4.56 4.97
Intuit Inc. 55.36 62.71 93.29 89.14 92.00 89.58 120.30
Oracle Corp. 3.98 4.23 6.06 6.21 6.27 6.48 6.76
Palantir Technologies Inc. -176.15 -201.09 -194.27
Palo Alto Networks Inc. -4.28 -3.42 -2.65 -1.85 -1.68 -1.49 -1.36
Synopsys 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
Interest coverage = (EBITQ3 2022 + EBITQ2 2022 + EBITQ1 2022 + EBITQ4 2021) ÷ (Interest expenseQ3 2022 + Interest expenseQ2 2022 + Interest expenseQ1 2022 + Interest expenseQ4 2021)
= (1,208,300 + 928,500 + 919,300 + 714,400) ÷ (18,400 + 18,400 + 18,500 + 17,200) = 52.01

2 Click competitor name to see calculations.


Earnings Before Interest and Tax (EBIT)
The EBIT values show notable fluctuations across the observed quarters. Initially, the EBIT increased from 548,600 thousand USD in September 2016 to a peak of 871,200 thousand USD in March 2018. This was followed by a sharp decline to 233,200 thousand USD in June 2018, indicating significant volatility. After this trough, EBIT generally trended upward, reaching 1,208,300 thousand USD by March 2022. The interim periods showed a cyclical pattern with multiple fluctuations, yet the longer-term trend indicates growth in operating profitability.
Interest Expense
Interest expenses exhibited moderate variability during the timeframe. The amount started at 19,900 thousand USD in September 2016, peaked at 39,900 thousand USD in September 2019, and then gradually decreased to stabilize around 18,400 thousand USD by March 2022. The fluctuations suggest changes in the company's debt structure or interest rates, while the general downward trend in the latter period could imply successful debt management or refinancing at lower costs.
Interest Coverage Ratio
The interest coverage ratio, calculated as EBIT divided by interest expense, displayed significant improvement over time. It commenced at 32.72 in September 2016, experienced a declining trend until reaching a minimum of approximately 21.09 in December 2018, corresponding to periods of lower EBIT and higher interest expenses. From 2019 onwards, the ratio steadily increased, culminating in a peak value of 57.3 in September 2021, before slightly decreasing but remaining high (52.01) in March 2022. This trend indicates enhanced ability of the company to meet its interest obligations from operating earnings, reflecting improved financial health and reduced credit risk.