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 Property, Plant and Equipment

Microsoft Excel

Property, Plant and Equipment Disclosure

Automatic Data Processing Inc., balance sheet: property, plant and equipment

US$ in thousands

Microsoft Excel
Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016
Land and buildings 686,500 737,200 781,200 791,800 778,100 745,700
Data processing equipment 902,000 847,900 749,000 707,400 653,700 605,000
Furniture, leaseholds and other 656,000 643,600 651,600 637,100 599,600 490,100
Property, plant and equipment at cost 2,244,500 2,228,700 2,181,800 2,136,300 2,031,400 1,840,800
Accumulated depreciation (1,560,000) (1,524,800) (1,417,600) (1,342,600) (1,251,500) (1,155,800)
Property, plant and equipment, net 684,500 703,900 764,200 793,700 779,900 685,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).

Item Description The company
Property, plant and equipment at cost Amount before accumulated depreciation, depletion and amortization of physical assets used in the normal conduct of business and not intended for resale. Examples include, but are not limited to, land, buildings, machinery and equipment, office equipment, and furniture and fixtures. Automatic Data Processing Inc. property, plant and equipment at cost increased from 2019 to 2020 and from 2020 to 2021.
Property, plant and equipment, net Amount after accumulated depreciation, depletion and amortization of physical assets used in the normal conduct of business to produce goods and services and not intended for resale. Examples include, but are not limited to, land, buildings, machinery and equipment, office equipment, and furniture and fixtures. Automatic Data Processing Inc. property, plant and equipment, net decreased from 2019 to 2020 and from 2020 to 2021.

Asset Age Ratios (Summary)

Automatic Data Processing Inc., asset age ratios

Microsoft Excel
Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016
Average age ratio 69.50% 68.42% 64.97% 62.85% 61.61% 62.79%
Estimated total useful life (years) 12 12 12 12 14 14
Estimated age, time elapsed since purchase (years) 9 8 8 8 8 9
Estimated remaining life (years) 4 4 4 5 5 5

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

Asset age ratio Description The company
Average age ratio As long as straight-line depreciation is used, this is an accurate estimate of asset age as a percentage of depreciable life. The relative age is a useful measure of whether the company fixed asset base is old or new. Newer assets are likely to be more efficient. Automatic Data Processing Inc. average age ratio of depreciable property, plant and equipment deteriorated from 2019 to 2020 and from 2020 to 2021.
Estimated total useful life Over longer time periods, this ratio is a useful measure of company depreciation policy and can be used for comparisons with competitors. Automatic Data Processing Inc. estimated total useful life of depreciable property, plant and equipment decreased from 2019 to 2020 but then increased from 2020 to 2021 exceeding 2019 level.
Estimated time elapsed since purchase The approximate age in years of a company fixed assets. Useful for comparison purposes. Automatic Data Processing Inc. estimated time elapsed since purchase of depreciable property, plant and equipment deteriorated from 2019 to 2020 and from 2020 to 2021.
Estimated remaining life Automatic Data Processing Inc. estimated remaining life of depreciable property, plant and equipment decreased from 2019 to 2020 but then slightly increased from 2020 to 2021.

Average Age

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)
Accumulated depreciation 1,560,000 1,524,800 1,417,600 1,342,600 1,251,500 1,155,800
Property, plant and equipment at cost 2,244,500 2,228,700 2,181,800 2,136,300 2,031,400 1,840,800
Asset Age Ratio
Average age1 69.50% 68.42% 64.97% 62.85% 61.61% 62.79%

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 Average age = 100 × Accumulated depreciation ÷ Property, plant and equipment at cost
= 100 × 1,560,000 ÷ 2,244,500 = 69.50%

Asset age ratio Description The company
Average age As long as straight-line depreciation is used, this is an accurate estimate of asset age as a percentage of depreciable life. The relative age is a useful measure of whether the company fixed asset base is old or new. Newer assets are likely to be more efficient. Automatic Data Processing Inc. average age ratio of depreciable property, plant and equipment deteriorated from 2019 to 2020 and from 2020 to 2021.

Estimated Total Useful Life

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)
Property, plant and equipment at cost 2,244,500 2,228,700 2,181,800 2,136,300 2,031,400 1,840,800
Depreciation of property, plant and equipment 183,300 192,800 180,600 173,100 147,300 135,600
Asset Age Ratio (Years)
Estimated total useful life1 12 12 12 12 14 14

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 Estimated total useful life = Property, plant and equipment at cost ÷ Depreciation of property, plant and equipment
= 2,244,500 ÷ 183,300 = 12

Asset age ratio Description The company
Estimated total useful life Over longer time periods, this ratio is a useful measure of company depreciation policy and can be used for comparisons with competitors. Automatic Data Processing Inc. estimated total useful life of depreciable property, plant and equipment decreased from 2019 to 2020 but then increased from 2020 to 2021 exceeding 2019 level.

Estimated Age, Time Elapsed since Purchase

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)
Accumulated depreciation 1,560,000 1,524,800 1,417,600 1,342,600 1,251,500 1,155,800
Depreciation of property, plant and equipment 183,300 192,800 180,600 173,100 147,300 135,600
Asset Age Ratio (Years)
Time elapsed since purchase1 9 8 8 8 8 9

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 Time elapsed since purchase = Accumulated depreciation ÷ Depreciation of property, plant and equipment
= 1,560,000 ÷ 183,300 = 9

Asset age ratio Description The company
Estimated time elapsed since purchase The approximate age in years of a company fixed assets. Useful for comparison purposes. Automatic Data Processing Inc. estimated time elapsed since purchase of depreciable property, plant and equipment deteriorated from 2019 to 2020 and from 2020 to 2021.

Estimated Remaining Life

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)
Property, plant and equipment, net 684,500 703,900 764,200 793,700 779,900 685,000
Depreciation of property, plant and equipment 183,300 192,800 180,600 173,100 147,300 135,600
Asset Age Ratio (Years)
Estimated remaining life1 4 4 4 5 5 5

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 Estimated remaining life = Property, plant and equipment, net ÷ Depreciation of property, plant and equipment
= 684,500 ÷ 183,300 = 4

Asset age ratio Description The company
Estimated remaining life Automatic Data Processing Inc. estimated remaining life of depreciable property, plant and equipment decreased from 2019 to 2020 but then slightly increased from 2020 to 2021.