AI Tokens
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 Investments

Microsoft Excel

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) 2,598,500 2,466,500 2,292,800 1,620,800 1,733,400 1,492,500
Add: Unrealized net gains (losses) on available-for-sale securities, net of tax (280,700) 465,800 498,000 (337,300) (264,100) 186,600
Less: Reclassification of net (gains) losses on available-for-sale securities to net earnings, net of tax (8,800) (10,000) 600 2,100 (1,400) 3,300
Net earnings (adjusted) 2,309,000 2,922,300 2,791,400 1,285,600 1,467,900 1,682,400

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 indicates a general growth trajectory in reported net earnings between 2016 and 2021, contrasting with significant volatility in adjusted net earnings. This divergence is driven by the mark-to-market adjustments of available-for-sale securities, which periodically create substantial deviations between reported and adjusted figures.

Reported Net Earnings Trend
Reported net earnings demonstrated a consistent long-term increase, rising from 1,492,500 thousand US dollars in 2016 to 2,598,500 thousand US dollars by 2021. While a moderate contraction was observed in 2018, the overall progression reflects a steady expansion of reported profitability over the six-year period.
Adjusted Net Earnings Volatility
Adjusted net earnings exhibited significantly higher variance than reported figures. A decline was noted from 2016 through 2018, reaching a period low of 1,285,600 thousand US dollars. This was followed by a sharp increase in 2019 and 2020, peaking at 2,922,300 thousand US dollars, before a notable decrease occurred in 2021 to 2,309,000 thousand US dollars.
Impact of Mark-to-Market Adjustments
The variance between reported and adjusted earnings reveals the fluctuating impact of available-for-sale security valuations. Positive adjustments were observed in 2016, 2019, and 2020, where adjusted net earnings exceeded reported earnings, suggesting favorable valuation movements. In contrast, negative adjustments were present in 2017, 2018, and 2021, where the adjustment reduced the adjusted net earnings relative to the reported totals, indicating unfavorable mark-to-market impacts during those fiscal years.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


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

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

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 17.32% 16.91% 16.17% 12.16% 14.00% 12.79%
Adjusted net profit margin 15.39% 20.03% 19.69% 9.65% 11.86% 14.42%
Return on Equity (ROE)
Reported ROE 45.83% 42.88% 42.46% 46.85% 43.59% 33.30%
Adjusted ROE 40.72% 50.80% 51.69% 37.16% 36.91% 37.54%
Return on Assets (ROA)
Reported ROA 5.33% 6.30% 5.47% 4.37% 4.66% 3.42%
Adjusted ROA 4.73% 7.46% 6.66% 3.47% 3.95% 3.85%

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


An analysis of profitability ratios between June 30, 2016, and June 30, 2021, reveals a general upward trajectory in reported profitability, while adjusted figures demonstrate higher volatility. This variance suggests that mark-to-market adjustments on available-for-sale securities have periodically exerted a significant influence on the company's bottom-line performance.

Net Profit Margins
Reported net profit margins showed a consistent growth trend over the six-year period, rising from 12.79% in 2016 to 17.32% in 2021. In contrast, the adjusted net profit margin exhibited substantial fluctuations. A notable decline occurred in 2018, where the adjusted margin dropped to 9.65%, significantly trailing the reported margin of 12.16%. However, a sharp recovery followed, with adjusted margins peaking at 20.03% in 2020 before moderating to 15.39% in 2021.
Return on Equity (ROE)
Both reported and adjusted ROE remained high throughout the period, indicating strong returns on shareholder capital. Reported ROE increased from 33.30% in 2016 to 45.83% in 2021. Adjusted ROE experienced a period of exceptional growth between 2019 and 2020, reaching peaks of 51.69% and 50.80%, respectively. This suggests that after adjusting for available-for-sale securities, the underlying equity performance was significantly stronger during those two fiscal years than reported figures indicated.
Return on Assets (ROA)
Return on assets followed a pattern similar to ROE, although at a much lower scale. Reported ROA grew from 3.42% in 2016 to a peak of 6.30% in 2020, ending at 5.33% in 2021. Adjusted ROA mirrored this trajectory, reaching a maximum of 7.46% in 2020. The convergence and divergence between reported and adjusted ROA highlight the impact of security valuations on asset efficiency, particularly in 2020 when adjusted ROA exceeded reported ROA by more than one percentage point.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


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 2,598,500 2,466,500 2,292,800 1,620,800 1,733,400 1,492,500
Revenues 15,005,400 14,589,800 14,175,200 13,325,800 12,379,800 11,667,800
Profitability Ratio
Net profit margin1 17.32% 16.91% 16.17% 12.16% 14.00% 12.79%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in thousands)
Adjusted net earnings 2,309,000 2,922,300 2,791,400 1,285,600 1,467,900 1,682,400
Revenues 15,005,400 14,589,800 14,175,200 13,325,800 12,379,800 11,667,800
Profitability Ratio
Adjusted net profit margin2 15.39% 20.03% 19.69% 9.65% 11.86% 14.42%

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,598,500 ÷ 15,005,400 = 17.32%

2 Adjusted net profit margin = 100 × Adjusted net earnings ÷ Revenues
= 100 × 2,309,000 ÷ 15,005,400 = 15.39%


The financial performance from June 30, 2016, to June 30, 2021, is characterized by a general increase in reported profitability contrasted with significant volatility in adjusted earnings and margins. While reported net earnings demonstrate a consistent upward trajectory over the six-year period, adjusted metrics reveal more substantial fluctuations, particularly between 2018 and 2020.

Net Earnings Trends
Reported net earnings grew from 1,492,500 thousand USD in 2016 to 2,598,500 thousand USD in 2021, indicating a steady expansion of the bottom line. In contrast, adjusted net earnings exhibited a non-linear path, declining from 1,682,400 thousand USD in 2016 to a low of 1,285,600 thousand USD in 2018, before surging to a peak of 2,922,300 thousand USD in 2020 and subsequently retreating to 2,309,000 thousand USD in 2021.
Reported Net Profit Margin Analysis
The reported net profit margin shows a resilient growth pattern. After a slight dip in 2018 to 12.16%, the margin climbed steadily, reaching 17.32% by June 30, 2021. This suggests an improvement in overall operational efficiency and cost management over the long term.
Adjusted Net Profit Margin Volatility
The adjusted net profit margin experienced significant variance. A downward trend was observed between 2016 and 2018, where the margin fell from 14.42% to 9.65%. This was followed by a sharp reversal and rapid expansion, peaking at 20.03% in 2020. By 2021, the adjusted margin contracted to 15.39%, indicating that non-recurring items or specific adjustments had a more pronounced impact on profitability than reported figures suggest.
Comparative Margin Divergence
A notable divergence exists between reported and adjusted margins. In 2020, the adjusted margin significantly exceeded the reported margin (20.03% versus 16.91%), suggesting that negative one-time items were weighing down reported results. Conversely, by 2021, the reported margin (17.32%) surpassed the adjusted margin (15.39%), signaling a shift where reported earnings were bolstered by items that the adjusted metrics excluded.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


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 2,598,500 2,466,500 2,292,800 1,620,800 1,733,400 1,492,500
Stockholders’ equity 5,670,100 5,752,200 5,399,900 3,459,600 3,977,000 4,481,600
Profitability Ratio
ROE1 45.83% 42.88% 42.46% 46.85% 43.59% 33.30%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in thousands)
Adjusted net earnings 2,309,000 2,922,300 2,791,400 1,285,600 1,467,900 1,682,400
Stockholders’ equity 5,670,100 5,752,200 5,399,900 3,459,600 3,977,000 4,481,600
Profitability Ratio
Adjusted ROE2 40.72% 50.80% 51.69% 37.16% 36.91% 37.54%

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,598,500 ÷ 5,670,100 = 45.83%

2 Adjusted ROE = 100 × Adjusted net earnings ÷ Stockholders’ equity
= 100 × 2,309,000 ÷ 5,670,100 = 40.72%


The financial performance from June 30, 2016, to June 30, 2021, exhibits a divergent trend between reported and adjusted financial metrics, particularly concerning net earnings and the resulting return on equity.

Net Earnings Analysis
Reported net earnings demonstrated a consistent upward trajectory, increasing from 1,492,500 thousand US$ in 2016 to 2,598,500 thousand US$ in 2021. Conversely, adjusted net earnings were characterized by significant volatility, experiencing a decline from 2016 through 2018, followed by a sharp increase peaking at 2,922,300 thousand US$ in 2020, and a subsequent reduction to 2,309,000 thousand US$ in 2021.
Reported Return on Equity (ROE) Trends
Reported ROE showed a steady and overall positive trend, rising from 33.30% in 2016 to 45.83% in 2021. This indicates a progressive improvement in the efficiency of generating profits from shareholders' equity based on reported accounting standards.
Adjusted Return on Equity (ROE) Patterns
Adjusted ROE displayed more cyclical behavior. The metric remained relatively stable between 36.91% and 37.54% from 2016 to 2018, before experiencing a substantial surge to 51.69% in 2019 and 50.80% in 2020. A significant correction followed in 2021, where the ratio declined to 40.72%.
Comparative Performance Insights
A notable divergence is observed in 2021, where reported ROE continued to climb to its period high, while adjusted ROE declined. The most significant period of adjusted outperformance occurred between 2019 and 2020, during which the adjusted ROE substantially exceeded the reported ROE, suggesting a period of high non-GAAP profitability relative to the equity base.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


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 2,598,500 2,466,500 2,292,800 1,620,800 1,733,400 1,492,500
Total assets 48,772,500 39,165,500 41,887,700 37,088,700 37,180,000 43,670,000
Profitability Ratio
ROA1 5.33% 6.30% 5.47% 4.37% 4.66% 3.42%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in thousands)
Adjusted net earnings 2,309,000 2,922,300 2,791,400 1,285,600 1,467,900 1,682,400
Total assets 48,772,500 39,165,500 41,887,700 37,088,700 37,180,000 43,670,000
Profitability Ratio
Adjusted ROA2 4.73% 7.46% 6.66% 3.47% 3.95% 3.85%

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,598,500 ÷ 48,772,500 = 5.33%

2 Adjusted ROA = 100 × Adjusted net earnings ÷ Total assets
= 100 × 2,309,000 ÷ 48,772,500 = 4.73%


The financial performance from 2016 to 2021 reflects a general expansion in earnings capacity, characterized by a notable divergence between reported and adjusted metrics.

Net Earnings Trajectory
Reported net earnings demonstrated a consistent upward trend, growing from 1.49 billion in 2016 to 2.59 billion in 2021, with only a marginal contraction observed in 2018. In contrast, adjusted net earnings exhibited higher volatility, experiencing a downward trend through 2018 before a substantial increase in 2019 and 2020, followed by a decrease to 2.30 billion in 2021.
Return on Assets (ROA) Performance
Reported ROA improved steadily from 3.42% in 2016 to a peak of 6.30% in 2020, before moderating to 5.33% in 2021. Adjusted ROA followed a more erratic trajectory, declining to a low of 3.47% in 2018, surging to a peak of 7.46% in 2020, and subsequently falling to 4.73% in 2021.
Analysis of Adjusted Variances
A significant disparity between reported and adjusted figures is evident during the 2019 and 2020 fiscal years, where adjusted ROA substantially exceeded reported ROA. This suggests the influence of non-recurring expenses or accounting adjustments that negatively impacted reported results during those periods. However, by 2021, this relationship inverted, as adjusted ROA fell below reported ROA, indicating that the adjustments for that period reduced the earnings figure relative to the reported amount.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?