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.

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin

Microsoft Excel

Two-Component Disaggregation of ROE

Automatic Data Processing Inc., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Jun 30, 2021 45.83% = 5.33% × 8.60
Jun 30, 2020 42.88% = 6.30% × 6.81
Jun 30, 2019 42.46% = 5.47% × 7.76
Jun 30, 2018 46.85% = 4.37% × 10.72
Jun 30, 2017 43.59% = 4.66% × 9.35
Jun 30, 2016 33.30% = 3.42% × 9.74

Based on: 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30).


Return on Assets (ROA)
The return on assets demonstrates an overall upward trend from 2016 to 2020, starting at 3.42% and reaching a peak of 6.3% in 2020. However, there is a noticeable decline in 2021, with the ROA decreasing to 5.33%. This indicates that asset profitability improved significantly over the five-year period before experiencing a slight reduction in the final year analyzed.
Financial Leverage
Financial leverage shows a fluctuating pattern across the years. It begins at a high ratio of 9.74 in 2016, decreases gradually to 6.81 by 2020, reflecting a reduction in the use of debt relative to equity. However, there is an increase in leverage in 2021, rising back to 8.6. This suggests a strategic adjustment in the capital structure, possibly increasing debt levels after a period of deleveraging.
Return on Equity (ROE)
Return on equity exhibits a strong upward trend from 2016 to 2018, with values rising from 33.3% to 46.85%. Following this peak, ROE experiences a slight decline in 2019 to 42.46%, and remains relatively stable around 42.88% in 2020 before increasing again to 45.83% in 2021. This indicates sustained profitability for shareholders with some fluctuations but generally high returns over the period.
Overall Financial Insights
The data suggest improving profitability as measured by both ROA and ROE over the majority of the analyzed period, with ROE consistently outperforming ROA, likely influenced by varying financial leverage. The downward trend in financial leverage until 2020 implies a conservative approach to financing, while the increase in 2021 could reflect a shift in capital management strategy. The interplay between leverage and returns indicates deliberate balancing to optimize shareholder value.

Three-Component Disaggregation of ROE

Automatic Data Processing Inc., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Jun 30, 2021 45.83% = 17.32% × 0.31 × 8.60
Jun 30, 2020 42.88% = 16.91% × 0.37 × 6.81
Jun 30, 2019 42.46% = 16.17% × 0.34 × 7.76
Jun 30, 2018 46.85% = 12.16% × 0.36 × 10.72
Jun 30, 2017 43.59% = 14.00% × 0.33 × 9.35
Jun 30, 2016 33.30% = 12.79% × 0.27 × 9.74

Based on: 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30).


Net Profit Margin
The net profit margin exhibits a generally positive trend over the examined period. Beginning at 12.79% in mid-2016, it rises to a peak of 17.32% by mid-2021. Notable fluctuations include a decline to 12.16% in 2018, followed by consistent increases in subsequent years, indicating an overall improvement in profitability relative to revenue.
Asset Turnover
Asset turnover shows moderate variability, rising from 0.27 in 2016 to 0.37 in 2020, before declining to 0.31 in 2021. This suggests that asset utilization efficiency initially improved, reaching its highest point in 2020, but then decreased slightly, reflecting a reduction in revenue generated per unit of assets in the latest year.
Financial Leverage
Financial leverage experiences fluctuations over the period with values ranging from 6.81 to 10.72. Starting relatively high at 9.74 in 2016, leverage decreases sharply to 6.81 in 2020, indicating a reduction in debt relative to equity. However, an increase to 8.6 occurs in 2021, suggesting partial re-leveraging or changes in capital structure.
Return on Equity (ROE)
The return on equity consistently remains strong throughout the timeline, increasing from 33.3% in 2016 to a peak of 46.85% in 2018. Afterward, it dips slightly but remains above 40% in subsequent years, ending at 45.83% in 2021. This indicates sustained high profitability and effective utilization of shareholders' equity despite some variation.

Five-Component Disaggregation of ROE

Automatic Data Processing Inc., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Jun 30, 2021 45.83% = 0.77 × 0.98 × 22.80% × 0.31 × 8.60
Jun 30, 2020 42.88% = 0.77 × 0.97 × 22.55% × 0.37 × 6.81
Jun 30, 2019 42.46% = 0.76 × 0.96 × 22.12% × 0.34 × 7.76
Jun 30, 2018 46.85% = 0.75 × 0.95 × 17.06% × 0.36 × 10.72
Jun 30, 2017 43.59% = 0.68 × 0.97 × 21.09% × 0.33 × 9.35
Jun 30, 2016 33.30% = 0.67 × 0.98 × 19.63% × 0.27 × 9.74

Based on: 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30).


The financial data indicate several notable trends over the six-year period analyzed.

Tax Burden
The tax burden ratio increased steadily from 0.67 in 2016 to 0.77 by 2020 and remained stable at 0.77 in 2021. This gradual rise suggests a consistently increasing portion of earnings allocated to taxes over time.
Interest Burden
The interest burden ratio experienced a minor decline from 0.98 in 2016 to a low of 0.95 in 2018, followed by a slight rebound to 0.98 in 2021. This pattern indicates a relatively stable cost of interest expense relative to earnings before interest and taxes, with limited fluctuations.
EBIT Margin
The EBIT margin exhibited more variability, starting at 19.63% in 2016, increasing to 21.09% in 2017, then declining sharply to 17.06% in 2018. Subsequently, it improved considerably to peak at 22.8% in 2021. This suggests varying operational efficiency or cost management over the years, culminating in improved profitability by 2021.
Asset Turnover
Asset turnover ratio rose from 0.27 in 2016 to a peak of 0.37 in 2020, indicating improved efficiency in using assets to generate revenues. However, there was a decline to 0.31 in 2021, which may warrant further scrutiny to understand underlying operational or market factors.
Financial Leverage
Financial leverage showed a fluctuating trend, starting high at 9.74 in 2016, dipping to 6.81 by 2020, then increasing again to 8.6 in 2021. This reflects changes in the company's use of debt relative to equity, with a general reduction in leverage until 2020, followed by a moderate increase subsequently.
Return on Equity (ROE)
ROE demonstrated a generally positive trend, rising substantially from 33.3% in 2016 to a peak of 46.85% in 2018. It then declined somewhat, stabilizing around 42-46% through 2019 to 2021. Despite volatility, the ROE remains robust, indicating strong shareholder returns across the period.

Overall, the data reflect improvements in profitability and operational efficiency with some volatility, stable costs related to interest, and fluctuating financial leverage strategies. Return on equity maintained a high level, reinforced particularly by improved EBIT margins and asset utilization in the latter years. The upward trend in tax burden highlights increased tax obligations impacting net profitability.


Two-Component Disaggregation of ROA

Automatic Data Processing Inc., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Jun 30, 2021 5.33% = 17.32% × 0.31
Jun 30, 2020 6.30% = 16.91% × 0.37
Jun 30, 2019 5.47% = 16.17% × 0.34
Jun 30, 2018 4.37% = 12.16% × 0.36
Jun 30, 2017 4.66% = 14.00% × 0.33
Jun 30, 2016 3.42% = 12.79% × 0.27

Based on: 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30).


Net Profit Margin
The net profit margin showed a generally increasing trend over the reported periods. Starting at 12.79% in mid-2016, it increased to 14% in 2017 before experiencing a slight decline to 12.16% in 2018. Subsequently, the margin rose steadily, reaching 16.17% in 2019, then 16.91% in 2020, and finally 17.32% in 2021. This indicates improving profitability and effective cost management over time, particularly from 2018 onward.
Asset Turnover
The asset turnover ratio experienced moderate fluctuations throughout the years. It began at 0.27 in 2016, increased to a peak of 0.37 in 2020, demonstrating improved efficiency in utilizing assets to generate revenue. However, in 2021, it declined to 0.31, suggesting a slight reduction in asset use efficiency after reaching its highest level a year earlier.
Return on Assets (ROA)
Return on assets exhibited an overall upward trajectory from 2016 to 2020, rising from 3.42% to 6.3%. This reflects an enhanced ability to convert assets into net income over these years. However, in 2021, ROA decreased to 5.33%, indicating a slight decline in asset profitability, aligning with the reduction observed in asset turnover during the same period.

Four-Component Disaggregation of ROA

Automatic Data Processing Inc., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Jun 30, 2021 5.33% = 0.77 × 0.98 × 22.80% × 0.31
Jun 30, 2020 6.30% = 0.77 × 0.97 × 22.55% × 0.37
Jun 30, 2019 5.47% = 0.76 × 0.96 × 22.12% × 0.34
Jun 30, 2018 4.37% = 0.75 × 0.95 × 17.06% × 0.36
Jun 30, 2017 4.66% = 0.68 × 0.97 × 21.09% × 0.33
Jun 30, 2016 3.42% = 0.67 × 0.98 × 19.63% × 0.27

Based on: 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30).


Tax Burden
The tax burden ratio shows a consistent upward trend from 0.67 in 2016 to 0.77 by 2020, remaining steady at 0.77 in 2021. This indicates a gradual increase in the proportion of taxes relative to pre-tax income over the analyzed period.
Interest Burden
The interest burden ratio remains relatively stable, fluctuating slightly between 0.95 and 0.98 across the years. There is no significant change, suggesting consistent interest expenses relative to earnings before interest and taxes.
EBIT Margin
The EBIT margin demonstrates notable variability, starting at 19.63% in 2016, increasing to 21.09% in 2017, then declining sharply to 17.06% in 2018. Following this dip, it recovers consistently, reaching 22.8% by 2021, the highest point in the timeframe. This reflects fluctuations in operating profitability with a strong recovery in recent years.
Asset Turnover
Asset turnover has generally increased from 0.27 in 2016 to a peak of 0.37 in 2020, before declining to 0.31 in 2021. This pattern indicates improved efficiency in using assets to generate sales for most of the period, with a slight decrease in the latest year.
Return on Assets (ROA)
ROA shows an overall increasing trend from 3.42% in 2016 to a peak of 6.3% in 2020, followed by a decrease to 5.33% in 2021. The increase corresponds with improvements in operational efficiency and profitability, although the drop in the final year may suggest emerging challenges affecting asset profitability.

Disaggregation of Net Profit Margin

Automatic Data Processing Inc., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Jun 30, 2021 17.32% = 0.77 × 0.98 × 22.80%
Jun 30, 2020 16.91% = 0.77 × 0.97 × 22.55%
Jun 30, 2019 16.17% = 0.76 × 0.96 × 22.12%
Jun 30, 2018 12.16% = 0.75 × 0.95 × 17.06%
Jun 30, 2017 14.00% = 0.68 × 0.97 × 21.09%
Jun 30, 2016 12.79% = 0.67 × 0.98 × 19.63%

Based on: 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30).


Tax Burden
The tax burden ratio exhibits a consistent upward trend from 0.67 in June 2016 to 0.77 in both June 2020 and June 2021, indicating an increase in the proportion of earnings retained after taxes over the analyzed period.
Interest Burden
The interest burden ratio remains relatively stable throughout the years, fluctuating slightly between 0.95 and 0.98, suggesting stable interest expenses relative to earnings before interest and taxes.
EBIT Margin
The EBIT margin shows variability with an initial increase from 19.63% in 2016 to 21.09% in 2017, a notable decline to 17.06% in 2018, followed by recovery and growth reaching 22.8% by 2021. This indicates fluctuations in operating profitability with a strong recovery in the latter years.
Net Profit Margin
The net profit margin mirrors a similar pattern to the EBIT margin, increasing from 12.79% in 2016 to 14% in 2017, a dip to 12.16% in 2018, then rising steadily to 17.32% in 2021. This reflects improved efficiency and profitability after all expenses, particularly following the downturn in 2018.