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.

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
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

Two-Component Disaggregation of ROE

Automatic Data Processing Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
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 = ×

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


Return on Assets (ROA)
The Return on Assets exhibited some fluctuations over the observed periods, ranging roughly between 3.97% and 6.3%. Initially, it showed a moderate level around 4.44%, followed by a slight dip to below 4% in early 2017. Afterward, there was a gradual upward trend reaching a peak near 6.3% by mid-2020. The metric then experienced a downward correction, settling around the 4% mark at the end of the timespan. This indicates variability in the company's efficiency in generating profits from its assets, with periods of improvement and decline.
Financial Leverage
Financial leverage demonstrated notable volatility throughout the timeline. Starting at a ratio of about 8.08, it increased substantially to values exceeding 10 in late 2016 to early 2017. The ratio then fluctuated between approximately 6.8 and 11.7 for several quarters, showing alternating periods of higher and lower leverage. In the latest period, there was a sharp rise reaching as high as 17.19, indicating a significant increase in the company's use of debt relative to equity or assets. This escalation may imply a shift toward more aggressive financing strategies or changes in capital structure risk appetite.
Return on Equity (ROE)
Return on Equity showed an overall positive and increasing trend, with values moving from mid-30% levels to a peak above 68.25% by the last quarter analyzed. The ROE generally remained in the 40-50% range for most of the middle periods, with some temporary decreases around late 2018 and early 2020. The strong upward trend toward the end suggests an improving ability to generate profit from shareholders' equity, potentially reflecting operational enhancements, leverage effects, or profit margin expansions. This increased profitability for equity holders is noteworthy and indicates favorable performance outcomes in the latter periods.

Three-Component Disaggregation of ROE

Automatic Data Processing Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
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 = × ×

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


The analysis of the quarterly financial ratios reveals several distinct trends over the observed periods.

Net Profit Margin
The net profit margin shows a generally positive trend with moderate fluctuations. Starting at 12.84% in the third quarter of 2016, it experiences some volatility but maintains an upward trajectory overall. Notably, from mid-2018 onwards, the margin consistently stays above 13%, peaking near 17.77% by the first quarter of 2022. This indicates improving profitability and effective cost management over time.
Asset Turnover
The asset turnover ratio displays more variability without a clear linear trend. Initial values start at 0.35 and gradually fluctuate between approximately 0.22 and 0.38 throughout the periods. The ratio peaks around 0.38 in late 2019 before trending downward toward 0.22 by early 2022. This suggests a declining efficiency in generating revenue from assets toward the later periods.
Financial Leverage
Financial leverage has seen significant fluctuations over the timeframe. Beginning at 8.08 in late 2016, the ratio spikes multiple times, notably reaching a peak of 17.19 by the first quarter of 2022. The period also includes several temporary declines, indicating changing capital structures possibly influenced by debt levels or equity changes. The overall upward trend toward increased leverage may imply greater risk exposure.
Return on Equity (ROE)
Return on equity exhibits a strong upward trend with notable increases across the periods. Starting at 35.87%, the ROE fluctuates but generally rises, with peaks above 50% seen in late 2021 and early 2022, reaching as high as 68.25%. This suggests enhanced profitability relative to shareholders’ equity, possibly driven by improved profit margins and amplified by increased financial leverage despite some volatility in asset turnover.

In summary, the firm demonstrates improving profitability and shareholder returns, supported by increased net profit margins and substantially rising ROE. However, the decreasing asset turnover ratio and heightened financial leverage indicate potential operational efficiency concerns and greater financial risk. Monitoring these factors will be important for sustaining long-term performance.


Five-Component Disaggregation of ROE

Automatic Data Processing Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
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 = × × × ×

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


Tax Burden
The tax burden ratio displayed a moderate upward trend over the analyzed period, starting at 0.68 and gradually increasing to a stable value of approximately 0.77 from late 2019 onward. This suggests a slight rise in the proportion of earnings retained after taxes, indicating more efficient tax management or changes in tax structures.
Interest Burden
The interest burden ratio remained relatively stable, hovering around 0.95 to 0.98 throughout the period. This constancy implies that interest expenses relative to earnings before interest and taxes did not significantly change, indicating steady financing costs or debt service conditions.
EBIT Margin
The EBIT margin showcased some volatility initially but demonstrated a consistent improving trend starting in 2018. It rose from around 17% to over 23% by early 2022, highlighting enhanced operating profitability, potentially due to improved operational efficiency or revenue quality.
Asset Turnover
Asset turnover fluctuated moderately across the reported quarters, ranging generally between 0.22 and 0.38 without a clear directional trend. This variability suggests inconsistent utilization of assets to generate revenue, possibly reflecting seasonality or changes in asset base versus sales.
Financial Leverage
Financial leverage showed significant variability with a notable increase in the final quarters, reaching as high as 17.19 by the last period. Earlier values fluctuated between approximately 6.81 and 11.7. The considerable upward movement toward the end indicates increased reliance on debt financing, which may raise financial risk but could also enhance returns.
Return on Equity (ROE)
ROE experienced a mostly upward trajectory, beginning at 35.87% and culminating at a high of 68.25% at the end of the period. Despite some fluctuations, especially around late 2018 and early 2019, the overall improvement was pronounced. This increase reflects a stronger capacity to generate earnings from shareholders’ equity, influenced by improved margins and rising financial leverage.

Two-Component Disaggregation of ROA

Automatic Data Processing Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
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 = ×

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


The analysis of the quarterly financial ratios over the observed periods reveals several key trends related to profitability, efficiency, and asset utilization.

Net Profit Margin
The net profit margin demonstrates an overall upward trend from approximately 12.84% in late 2016 to around 17.77% by early 2022. Despite some quarterly fluctuations, the margin consistently improved, especially noticeable from mid-2018 onward, indicating enhanced profitability relative to revenue. This improvement suggests effective cost management or pricing strategies that positively impacted net earnings.
Asset Turnover
The asset turnover ratio shows more variability and a general downward trajectory over the timeline. Starting near 0.35 in late 2016, it fluctuates with sporadic increases but ultimately declines to approximately 0.22 by the first quarter of 2022. This pattern indicates a decrease in the efficiency with which the company is generating sales from its assets, potentially reflecting asset base expansions or challenges in scaling revenue proportionally.
Return on Assets (ROA)
The return on assets exhibits a volatile pattern, initially declining slightly in early 2017, then rising significantly around mid-2019 to early 2020, peaking close to 6.3%. Following this peak, ROA trends downward again towards 3.97% by the first quarter of 2022. The fluctuations suggest changing effectiveness in utilizing assets to generate net income, influenced by both profitability and asset turnover dynamics over the analyzed periods.

Overall, the company achieved consistent gains in profitability margins over time while experiencing challenges in asset utilization efficiency. The divergence between increasing net profit margin and decreasing asset turnover suggests a shift possibly toward higher-margin activities or improvements in expense control, offset by lower sales volume relative to asset base growth. The ROA pattern aligns with these observations, reflecting combined impacts of profitability and operational efficiency changes.


Four-Component Disaggregation of ROA

Automatic Data Processing Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
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 = × × ×

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


The analysis of the quarterly financial data reveals several notable trends across key financial ratios. The tax burden ratio shows a gradual increase from 0.68 in late 2016 to a consistently higher level of approximately 0.77 from late 2019 onwards, indicating a stable but slightly rising proportion of earnings paid in taxes over time.

Interest burden ratios remained relatively steady across the periods, with minor fluctuations between 0.95 and 0.98. This suggests that interest expenses relative to earnings before interest and taxes have been fairly consistent, reflecting stable financing costs.

The EBIT margin experienced some variability, initially decreasing from around 21.67% at the end of 2016 to a low of approximately 17.06% in mid-2018. Following this decline, there was a clear upward trend from mid-2018 onwards, with margins steadily improving to reach above 23% by early 2022, signaling enhanced operational profitability.

Asset turnover ratios fluctuated notably, beginning with 0.35 in late 2016 and showing a downward trend intermittently, reaching a low around 0.22 by early 2022. These fluctuations indicate varying efficiency in using assets to generate revenue, with recent periods reflecting reduced asset utilization efficiency.

The return on assets (ROA) mirrored some of these patterns, initially peaking near 4.95% in late 2017, followed by oscillations that showed improvement towards mid-2019, where ROA reached over 6%. However, from then on, there was a general decline culminating in a lower ROA of approximately 3.97% by early 2022. This trend suggests that despite improvements in operational margins, the overall asset profitability has weakened in recent years, potentially due to decreased asset turnover.

Tax Burden
Increased gradually and stabilized at a higher level of 0.77, indicating a consistent tax expense ratio in recent years.
Interest Burden
Remained stable with minor changes between 0.95 and 0.98, reflecting steady interest expense relative to earnings.
EBIT Margin
Experienced a decline up to mid-2018 followed by a consistent rise, achieving improvements in operational profitability exceeding 23% by early 2022.
Asset Turnover
Displayed volatility with a declining trend toward early 2022, signaling decreased efficiency in asset utilization to generate sales.
Return on Assets (ROA)
Showed early growth with peaks reaching above 6%, followed by a downward trend ending below 4% in early 2022, suggesting decreased overall asset profitability despite improved margins.

Disaggregation of Net Profit Margin

Automatic Data Processing Inc., decomposition of net profit margin ratio (quarterly data)

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
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 = × ×

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


The analysis of the quarterly financial ratios reveals distinct patterns and trends in profitability and cost management over the examined periods.

Tax Burden
The tax burden ratio showed a gradual increase from approximately 0.68 in late 2016 to a steady level around 0.77 from early 2020 onwards. This indicates a progressively higher portion of pre-tax earnings being absorbed by taxes, stabilizing in the recent periods at a relatively elevated level compared to the start of the timeline.
Interest Burden
The interest burden ratio remained relatively stable, fluctuating narrowly between 0.95 and 0.98 throughout the period. This consistency suggests stable interest expenses relative to earnings before interest and taxes, with a slight improvement towards the end of the period reflecting marginally lower interest costs.
EBIT Margin
The EBIT margin experienced some volatility, starting at 19.62% in September 2016, rising to over 21% by early 2017, and then dipping to approximately 17% in mid-2018. After this dip, a noticeable upward trend occurred, with margins increasing steadily to exceed 23% by early 2022. This demonstrates an overall improvement in operational profitability over the longer term, recovering from a mid-period decline.
Net Profit Margin
The net profit margin mirrored the direction of the EBIT margin but with generally lower values, starting near 12.84%, rising steadily through the years, and reaching around 17.7% by the first quarter of 2022. The margin showed consistent incremental improvement, particularly from 2018 onward, indicating enhanced bottom-line profitability that benefits from both operating efficiency and financial cost management.

In summary, the company displayed a stable cost of debt, increasing tax obligations, and significant improvements in operational and net profitability margins over the reported period. The increasing EBIT and net profit margins in recent years suggest stronger earnings quality and effective cost controls despite a higher tax burden. These trends point to a favorable financial performance trajectory.