Stock Analysis on Net

Automatic Data Processing Inc. (NASDAQ:ADP)

$22.49

This company has been moved to the archive! The financial data has not been updated since April 29, 2022.

Analysis of Investments

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

Adjustment to Net Income (Loss): Mark to Market Available-for-sale Securities

Automatic Data Processing Inc., adjustment to net earnings

US$ in thousands

Microsoft Excel
12 months ended: Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016
Net earnings (as reported)
Add: Unrealized net gains (losses) on available-for-sale securities, net of tax
Less: Reclassification of net (gains) losses on available-for-sale securities to net earnings, net of tax
Net earnings (adjusted)

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


Reported Net Earnings

Reported net earnings show an overall upward trend over the six-year period. Starting at $1,492,500 thousand in June 2016, the figure increases steadily to $2,598,500 thousand by June 2021. There is a slight dip observed in June 2018, where earnings decreased to $1,620,800 thousand from $1,733,400 thousand in the previous year, before rebounding sharply in 2019 and continuing to grow through 2021.

Adjusted Net Earnings

Adjusted net earnings reveal a more volatile pattern compared to the reported figures. After a peak of $1,682,400 thousand in June 2016, adjusted earnings decline consistently over the next two years, reaching a low of $1,285,600 thousand in June 2018. This is followed by a significant increase in 2019 to $2,791,400 thousand and a further rise to $2,922,300 thousand in 2020. However, in 2021, adjusted net earnings decrease to $2,309,000 thousand, indicating a contraction relative to the previous two years.

Comparative Insights

The divergence between reported and adjusted net earnings across the timeline is notable. While reported earnings exhibit consistent growth with minor fluctuations, adjusted earnings demonstrate higher volatility, particularly with a sharp increase in 2019 and 2020 followed by a decline in 2021. This suggests that adjustments made to net earnings significantly impacted the financial figures starting in 2019, possibly due to changes in accounting treatments or one-time events being excluded from adjusted results.


Adjusted Profitability Ratios: Mark to Market Available-for-sale Securities (Summary)

Automatic Data Processing Inc., adjusted profitability ratios

Microsoft Excel
Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016
Net Profit Margin
Reported net profit margin
Adjusted net profit margin
Return on Equity (ROE)
Reported ROE
Adjusted ROE
Return on Assets (ROA)
Reported ROA
Adjusted ROA

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 reveals distinct trends and fluctuations in profitability and performance metrics over the period from mid-2016 to mid-2021.

Net Profit Margin
The reported net profit margin displayed an overall upward trend, increasing from 12.79% in 2016 to 17.32% in 2021, with a notable peak in 2019 and 2020 at approximately 16-17%. The adjusted net profit margin, however, exhibited greater volatility. It started higher at 14.42% in 2016, declined sharply to 9.65% in 2018, then surged to a peak of 20.03% in 2020 before declining to 15.39% in 2021. This variability in the adjusted margin suggests the influence of non-recurring items or adjustments impacting the reported profitability differently from the operational results.
Return on Equity (ROE)
Reported ROE consistently remained strong, rising from 33.3% in 2016 to 45.83% in 2021, with minor fluctuations but generally indicating solid shareholder returns. The adjusted ROE showed a different pattern, maintaining relative stability around the mid-to-high 30% range during 2016-2018, followed by a steep increase to over 50% in 2019 and 2020, before decreasing to 40.72% in 2021. This peak in adjusted ROE aligns with the adjusted net profit margin peak, signifying temporarily enhanced equity returns when adjustment factors are taken into account.
Return on Assets (ROA)
The reported ROA demonstrated a gradual increase from 3.42% in 2016 to a high of 6.3% in 2020, subsequently declining to 5.33% by 2021. The adjusted ROA showed a similar but more volatile trend, beginning at 3.85% in 2016, dipping slightly during 2017-2018, then sharply increasing to 7.46% in 2020 before decreasing below the peak in 2021 to 4.73%. This pattern reflects fluctuations in the company’s efficiency in asset utilization, potentially affected by adjustments reflecting one-off assets or expenses.

Overall, the data suggests an improvement in profitability and efficiency metrics over the analyzed period, particularly notable around 2019-2020. The divergence between reported and adjusted figures implies that certain adjustments have a meaningful effect on the assessment of true operational performance and returns. The decline in adjusted profitability and returns in 2021 may warrant further investigation into the causes behind this reversal.


Automatic Data Processing Inc., Profitability Ratios: Reported vs. Adjusted


Adjusted Net Profit Margin

Microsoft Excel
Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016
As Reported
Selected Financial Data (US$ in thousands)
Net earnings
Revenues
Profitability Ratio
Net profit margin1
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in thousands)
Adjusted net earnings
Revenues
Profitability Ratio
Adjusted net profit margin2

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

2021 Calculations

1 Net profit margin = 100 × Net earnings ÷ Revenues
= 100 × ÷ =

2 Adjusted net profit margin = 100 × Adjusted net earnings ÷ Revenues
= 100 × ÷ =


Reported net earnings
The reported net earnings demonstrated a generally increasing trend over the six-year period, rising from $1,492,500 thousand in mid-2016 to $2,598,500 thousand by mid-2021. There was a minor decline between 2017 and 2018 but a notable increase thereafter, with the largest growth observed between 2018 and 2019.
Adjusted net earnings
Adjusted net earnings showed more volatility compared to reported earnings, starting at $1,682,400 thousand in 2016 and ending at $2,309,000 thousand in 2021. The value initially decreased over the first three years, falling to $1,285,600 thousand in 2018, then surged to its peak of $2,921,300 thousand in 2020 before declining in 2021. This suggests that adjustments had a significant impact on reported profits, especially in later years.
Reported net profit margin
Reported net profit margin increased steadily over the period, improving from 12.79% in 2016 to 17.32% in 2021. This reflects enhanced profitability relative to revenue in reported figures, with consistent year-over-year improvement except for a slight dip in the earlier years.
Adjusted net profit margin
The adjusted net profit margin displayed greater volatility, ranging from 9.65% in 2018 to a high of 20.03% in 2020. There was a decline in margin from 2016 through 2018, followed by a sharp increase until 2020, and then a drop to 15.39% in 2021. This pattern aligns with the adjusted net earnings, further indicating that adjustments significantly influenced profitability measurements and varied substantially across the years.
Overall trends and insights
The reported financial data show steady growth and improving profitability from 2016 to 2021. In contrast, the adjusted figures reflect more pronounced fluctuations, likely due to one-time items or accounting adjustments impacting net earnings and margins. The divergence between reported and adjusted results highlights the importance of considering both metrics for a comprehensive understanding of financial performance. In particular, the spike in adjusted earnings and margins around 2020, followed by a decline, suggests that specific adjustments that year may have temporarily enhanced financial results.

Adjusted Return on Equity (ROE)

Microsoft Excel
Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016
As Reported
Selected Financial Data (US$ in thousands)
Net earnings
Stockholders’ equity
Profitability Ratio
ROE1
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in thousands)
Adjusted net earnings
Stockholders’ equity
Profitability Ratio
Adjusted ROE2

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

2021 Calculations

1 ROE = 100 × Net earnings ÷ Stockholders’ equity
= 100 × ÷ =

2 Adjusted ROE = 100 × Adjusted net earnings ÷ Stockholders’ equity
= 100 × ÷ =


The financial data reveals distinct trends in both reported and adjusted earnings and return on equity (ROE) for the company over the six-year period ending June 30, 2021.

Reported Net Earnings
There is a general upward trend in reported net earnings from 2016 through 2021. Earnings increased from $1,492,500 thousand in 2016 to $2,598,500 thousand in 2021, representing a substantial growth in profitability. Notably, there was a decline in 2018 after the 2017 peak, followed by a strong recovery and continued increases in subsequent years through 2021.
Adjusted Net Earnings
The adjusted net earnings show more volatility compared to reported earnings. Starting at $1,682,400 thousand in 2016, these earnings decreased for two consecutive years, reaching a low of $1,285,600 thousand in 2018. Subsequently, there was a sharp increase in 2019 and 2020, peaking at $2,922,300 thousand in 2020, before declining in 2021 to $2,309,000 thousand. This pattern indicates adjustments that significantly affected the earnings, particularly with a strong rebound after 2018.
Reported ROE
The reported return on equity shows a generally positive trend with some fluctuations. ROE rose from 33.3% in 2016 to 46.85% in 2018, then slightly decreased but remained stable around the low 40% range through 2019 to 2020, before increasing again to 45.83% in 2021. This suggests that the company maintained strong profitability relative to shareholders’ equity over the period.
Adjusted ROE
Adjusted ROE follows a somewhat different trajectory, starting at 37.54% in 2016 and remaining relatively stable around 36-37% through 2017 and 2018. There was a significant jump to 51.69% in 2019 and 50.8% in 2020, indicating a marked improvement in the adjusted returns during these years. However, in 2021, adjusted ROE declined to 40.72%, reflecting a decrease from its peak but still higher than earlier years outside the peak period.

Overall, the data depicts a company with strong and improving profitability metrics. Both reported net earnings and reported ROE increased over the timeframe, signaling robust financial performance. The adjusted metrics, while more volatile, peak notably in 2019 and 2020 before moderating in 2021, suggesting that adjustments significantly impacted profitability assessments during these years. The variations between reported and adjusted figures also highlight the importance of considering both sets of data for comprehensive analysis. The peak adjusted ROE in 2019 and 2020 suggests extraordinary circumstances or one-time adjustments that enhanced returns during this period.


Adjusted Return on Assets (ROA)

Microsoft Excel
Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016
As Reported
Selected Financial Data (US$ in thousands)
Net earnings
Total assets
Profitability Ratio
ROA1
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in thousands)
Adjusted net earnings
Total assets
Profitability Ratio
Adjusted ROA2

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

2021 Calculations

1 ROA = 100 × Net earnings ÷ Total assets
= 100 × ÷ =

2 Adjusted ROA = 100 × Adjusted net earnings ÷ Total assets
= 100 × ÷ =


The financial data reveals varying trends in both reported and adjusted net earnings over the six-year period. Reported net earnings exhibited an overall upward trajectory, increasing from 1,492,500 thousand US dollars in 2016 to 2,598,500 thousand US dollars in 2021. Despite a slight decline in 2018, earnings steadily grew in subsequent years, peaking in 2021.

In contrast, adjusted net earnings showed a less consistent pattern. Starting at 1,682,400 thousand US dollars in 2016, adjusted net earnings decreased for the next two years, reaching their lowest point in 2018 at 1,285,600 thousand US dollars. They then rose sharply in 2019 and 2020, surpassing the reported net earnings figures for those years, before declining again in 2021 to 2,309,000 thousand US dollars. This volatility may indicate adjustments related to non-recurring items or other financial considerations that impacted the reported figures.

Regarding profitability measures, the reported return on assets (ROA) demonstrated a positive trend, increasing from 3.42% in 2016 to a peak of 6.3% in 2020, before declining slightly to 5.33% in 2021. This suggests improved efficiency in generating earnings from assets up to 2020, with a marginal weakening thereafter.

Adjusted ROA followed a somewhat different trajectory. It increased modestly from 3.85% in 2016 to 3.95% in 2017 but then declined to 3.47% in 2018. A substantial increase occurred in 2019 and 2020, reaching a high of 7.46%, which exceeded the reported ROA for those years, reflecting the strong adjusted earnings in this period. However, adjusted ROA fell significantly to 4.73% in 2021, a sharper decrease than that seen in reported ROA, corresponding with the drop in adjusted net earnings.

Overall, the data indicates that while reported net earnings and reported ROA improved steadily with minor fluctuations, adjusted figures were more volatile with pronounced peaks and troughs. This disparity underscores the importance of considering both reported and adjusted metrics to gain a comprehensive understanding of financial performance and underlying profitability trends during the period analyzed.