Property, Plant and Equipment Disclosure
Asset Age Ratios (Summary)
Average Age
Estimated Total Useful Life
Estimated Age, Time Elapsed Since Purchase
Estimated Remaining Life

Sherwin-Williams Co., balance sheet: property, plant and equipment

US$ in thousands

	Dec 31, 2021	Dec 31, 2020	Dec 31, 2019	Dec 31, 2018	Dec 31, 2017
Land	257,700)	283,500)	242,100)	244,608)	254,676)
Buildings	1,157,800)	1,098,000)	1,044,200)	979,140)	962,094)
Machinery and equipment	3,043,600)	3,026,800)	2,952,100)	2,668,492)	2,572,963)
Construction in progress	205,400)	140,500)	144,000)	147,931)	177,056)
Property, plant and equipment, gross	4,664,500)	4,548,800)	4,382,400)	4,040,171)	3,966,789)
Allowances for depreciation	(2,797,200)	(2,714,300)	(2,547,200)	(2,263,332)	(2,089,674)
Property, plant and equipment, net	1,867,300)	1,834,500)	1,835,200)	1,776,839)	1,877,115)

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

Download chart

Item	Description	The company
Property, plant and equipment, gross	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.	Sherwin-Williams Co. property, plant and equipment, gross 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.	Sherwin-Williams Co. property, plant and equipment, net decreased from 2019 to 2020 but then increased from 2020 to 2021 exceeding 2019 level.

Sherwin-Williams Co., asset age ratios

	Dec 31, 2021	Dec 31, 2020	Dec 31, 2019	Dec 31, 2018	Dec 31, 2017
Average age ratio	63.47%	63.64%	61.52%	59.63%	56.29%
Estimated total useful life (years)	17	16	16	14	13
Estimated age, time elapsed since purchase (years)	11	10	10	8	7
Estimated remaining life (years)	6	6	6	6	6

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

Download chart

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.	Sherwin-Williams Co. average age ratio of depreciable property, plant and equipment deteriorated from 2019 to 2020 but then slightly improved 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.	Sherwin-Williams Co. estimated total useful life of depreciable property, plant and equipment increased from 2019 to 2020 and from 2020 to 2021.
Estimated time elapsed since purchase	The approximate age in years of a company fixed assets. Useful for comparison purposes.	Sherwin-Williams Co. estimated time elapsed since purchase of depreciable property, plant and equipment deteriorated from 2019 to 2020 and from 2020 to 2021.
Estimated remaining life		Sherwin-Williams Co. estimated remaining life of depreciable property, plant and equipment decreased from 2019 to 2020 but then increased from 2020 to 2021 exceeding 2019 level.

	Dec 31, 2021	Dec 31, 2020	Dec 31, 2019	Dec 31, 2018	Dec 31, 2017
Selected Financial Data (US$ in thousands)
Allowances for depreciation	2,797,200)	2,714,300)	2,547,200)	2,263,332)	2,089,674)
Property, plant and equipment, gross	4,664,500)	4,548,800)	4,382,400)	4,040,171)	3,966,789)
Land	257,700)	283,500)	242,100)	244,608)	254,676)
Asset Age Ratio
Average age¹	63.47%	63.64%	61.52%	59.63%	56.29%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

2021 Calculations

¹ Average age = 100 × Allowances for depreciation ÷ (Property, plant and equipment, gross – Land)
= 100 × 2,797,200 ÷ (4,664,500 – 257,700) = 63.47%

Download chart

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.	Sherwin-Williams Co. average age ratio of depreciable property, plant and equipment deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.

	Dec 31, 2021	Dec 31, 2020	Dec 31, 2019	Dec 31, 2018	Dec 31, 2017
Selected Financial Data (US$ in thousands)
Property, plant and equipment, gross	4,664,500)	4,548,800)	4,382,400)	4,040,171)	3,966,789)
Land	257,700)	283,500)	242,100)	244,608)	254,676)
Depreciation expense	263,100)	268,000)	262,100)	278,169)	284,997)
Asset Age Ratio (Years)
Estimated total useful life¹	17	16	16	14	13

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

2021 Calculations

¹ Estimated total useful life = (Property, plant and equipment, gross – Land) ÷ Depreciation expense
= (4,664,500 – 257,700) ÷ 263,100 = 17

Download chart

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.	Sherwin-Williams Co. estimated total useful life of depreciable property, plant and equipment increased from 2019 to 2020 and from 2020 to 2021.

	Dec 31, 2021	Dec 31, 2020	Dec 31, 2019	Dec 31, 2018	Dec 31, 2017
Selected Financial Data (US$ in thousands)
Allowances for depreciation	2,797,200)	2,714,300)	2,547,200)	2,263,332)	2,089,674)
Depreciation expense	263,100)	268,000)	262,100)	278,169)	284,997)
Asset Age Ratio (Years)
Time elapsed since purchase¹	11	10	10	8	7

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

2021 Calculations

¹ Time elapsed since purchase = Allowances for depreciation ÷ Depreciation expense
= 2,797,200 ÷ 263,100 = 11

Download chart

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.	Sherwin-Williams Co. estimated time elapsed since purchase of depreciable property, plant and equipment deteriorated from 2019 to 2020 and from 2020 to 2021.

	Dec 31, 2021	Dec 31, 2020	Dec 31, 2019	Dec 31, 2018	Dec 31, 2017
Selected Financial Data (US$ in thousands)
Property, plant and equipment, net	1,867,300)	1,834,500)	1,835,200)	1,776,839)	1,877,115)
Land	257,700)	283,500)	242,100)	244,608)	254,676)
Depreciation expense	263,100)	268,000)	262,100)	278,169)	284,997)
Asset Age Ratio (Years)
Estimated remaining life¹	6	6	6	6	6

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

2021 Calculations

¹ Estimated remaining life = (Property, plant and equipment, net – Land) ÷ Depreciation expense
= (1,867,300 – 257,700) ÷ 263,100 = 6

Download chart

Asset age ratio	Description	The company
Estimated remaining life		Sherwin-Williams Co. estimated remaining life of depreciable property, plant and equipment decreased from 2019 to 2020 but then increased from 2020 to 2021 exceeding 2019 level.

Sherwin-Williams Co. (NYSE:SHW)

Analysis of Property, Plant and Equipment

Property, Plant and Equipment Disclosure

Asset Age Ratios (Summary)

Average Age

Estimated Total Useful Life

Estimated Age, Time Elapsed since Purchase

Estimated Remaining Life