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 Geographic Areas

Microsoft Excel

Area Asset Turnover

Automatic Data Processing Inc., asset turnover by geographic area

Microsoft Excel
Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016
United States 0.31 0.38 0.34 0.36 0.33 0.25
Europe 0.54 0.57 0.44 0.54 0.48 0.52
Canada 0.10 0.14 0.17 0.16 0.14 0.15
Other 0.33 0.42 0.46 0.51 0.91 0.97

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

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.
Europe Europe area asset turnover ratio improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021.
Canada Canada area asset turnover ratio deteriorated from 2019 to 2020 and from 2020 to 2021.
Other Other area asset turnover ratio deteriorated from 2019 to 2020 and from 2020 to 2021.

Area Asset Turnover: United States

Automatic Data Processing Inc.; United States; area asset turnover calculation

Microsoft Excel
Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016
Selected Financial Data (US$ in thousands)
Revenues 13,081,700 12,740,100 12,327,600 11,486,400 10,537,400 9,870,000
Assets 42,137,100 33,891,000 36,508,300 32,221,000 32,401,000 39,194,200
Area Activity Ratio
Area asset turnover1 0.31 0.38 0.34 0.36 0.33 0.25

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

1 2021 Calculation
Area asset turnover = Revenues ÷ Assets
= 13,081,700 ÷ 42,137,100 = 0.31

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.

Area Asset Turnover: Europe

Automatic Data Processing Inc.; Europe; area asset turnover calculation

Microsoft Excel
Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016
Selected Financial Data (US$ in thousands)
Revenues 1,307,900 1,236,300 1,236,800 1,245,900 1,086,000 1,063,700
Assets 2,425,100 2,162,700 2,807,900 2,325,000 2,252,300 2,064,300
Area Activity Ratio
Area asset turnover1 0.54 0.57 0.44 0.54 0.48 0.52

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

1 2021 Calculation
Area asset turnover = Revenues ÷ Assets
= 1,307,900 ÷ 2,425,100 = 0.54

Area activity ratio Geographic area The company
Area asset turnover Europe Europe area asset turnover ratio improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021.

Area Asset Turnover: Canada

Automatic Data Processing Inc.; Canada; area asset turnover calculation

Microsoft Excel
Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016
Selected Financial Data (US$ in thousands)
Revenues 337,300 329,800 326,600 322,100 291,100 284,100
Assets 3,360,500 2,435,300 1,950,500 2,009,900 2,018,100 1,949,400
Area Activity Ratio
Area asset turnover1 0.10 0.14 0.17 0.16 0.14 0.15

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

1 2021 Calculation
Area asset turnover = Revenues ÷ Assets
= 337,300 ÷ 3,360,500 = 0.10

Area activity ratio Geographic area The company
Area asset turnover Canada Canada area asset turnover ratio deteriorated from 2019 to 2020 and from 2020 to 2021.

Area Asset Turnover: Other

Automatic Data Processing Inc.; Other; area asset turnover calculation

Microsoft Excel
Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016
Selected Financial Data (US$ in thousands)
Revenues 278,500 283,600 284,200 271,400 465,300 450,000
Assets 849,800 676,500 621,000 532,800 508,600 462,100
Area Activity Ratio
Area asset turnover1 0.33 0.42 0.46 0.51 0.91 0.97

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

1 2021 Calculation
Area asset turnover = Revenues ÷ Assets
= 278,500 ÷ 849,800 = 0.33

Area activity ratio Geographic area The company
Area asset turnover Other Other area asset turnover ratio deteriorated from 2019 to 2020 and from 2020 to 2021.

Revenues

Automatic Data Processing Inc., revenues by geographic area

US$ in thousands

Microsoft Excel
Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016
United States 13,081,700 12,740,100 12,327,600 11,486,400 10,537,400 9,870,000
Europe 1,307,900 1,236,300 1,236,800 1,245,900 1,086,000 1,063,700
Canada 337,300 329,800 326,600 322,100 291,100 284,100
Other 278,500 283,600 284,200 271,400 465,300 450,000
Total 15,005,400 14,589,800 14,175,200 13,325,800 12,379,800 11,667,800

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


Assets

Automatic Data Processing Inc., assets by geographic area

US$ in thousands

Microsoft Excel
Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016
United States 42,137,100 33,891,000 36,508,300 32,221,000 32,401,000 39,194,200
Europe 2,425,100 2,162,700 2,807,900 2,325,000 2,252,300 2,064,300
Canada 3,360,500 2,435,300 1,950,500 2,009,900 2,018,100 1,949,400
Other 849,800 676,500 621,000 532,800 508,600 462,100
Total 48,772,500 39,165,500 41,887,700 37,088,700 37,180,000 43,670,000

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