Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

$22.49

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

Analysis of Reportable Segments

Microsoft Excel

Paying users 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 Apple Pay Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Segment Profit Margin

Sherwin-Williams Co., profit margin by reportable segment

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
The Americas Group
Consumer Brands Group
Performance Coatings Group

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

Segment profitability ratio Reportable segment The company
Segment profit margin The Americas Group The Americas Group segment profit margin ratio improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.
Consumer Brands Group Consumer Brands Group segment profit margin ratio improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.
Performance Coatings Group Performance Coatings Group segment profit margin ratio improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021 not reaching 2019 level.

Segment Profit Margin: The Americas Group

Sherwin-Williams Co.; The Americas Group; segment profit margin calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Segment profit
Net sales and intersegment transfers
Segment Profitability Ratio
Segment profit margin1

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

1 2021 Calculation
Segment profit margin = 100 × Segment profit ÷ Net sales and intersegment transfers
= 100 × ÷ =

Segment profitability ratio Reportable segment The company
Segment profit margin The Americas Group The Americas Group segment profit margin ratio improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.

Segment Profit Margin: Consumer Brands Group

Sherwin-Williams Co.; Consumer Brands Group; segment profit margin calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Segment profit
Net sales and intersegment transfers
Segment Profitability Ratio
Segment profit margin1

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

1 2021 Calculation
Segment profit margin = 100 × Segment profit ÷ Net sales and intersegment transfers
= 100 × ÷ =

Segment profitability ratio Reportable segment The company
Segment profit margin Consumer Brands Group Consumer Brands Group segment profit margin ratio improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.

Segment Profit Margin: Performance Coatings Group

Sherwin-Williams Co.; Performance Coatings Group; segment profit margin calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Segment profit
Net sales and intersegment transfers
Segment Profitability Ratio
Segment profit margin1

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

1 2021 Calculation
Segment profit margin = 100 × Segment profit ÷ Net sales and intersegment transfers
= 100 × ÷ =

Segment profitability ratio Reportable segment The company
Segment profit margin Performance Coatings Group Performance Coatings Group segment profit margin ratio improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021 not reaching 2019 level.

Segment Return on Assets (Segment ROA)

Sherwin-Williams Co., ROA by reportable segment

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
The Americas Group
Consumer Brands Group
Performance Coatings Group

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

Segment profitability ratio Reportable segment The company
Segment ROA The Americas Group The Americas Group segment ROA improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021 not reaching 2019 level.
Consumer Brands Group Consumer Brands Group segment ROA improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021 not reaching 2019 level.
Performance Coatings Group Performance Coatings Group segment ROA improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021.

Segment ROA: The Americas Group

Sherwin-Williams Co.; The Americas Group; segment ROA calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Segment profit
Identifiable assets
Segment Profitability Ratio
Segment ROA1

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

1 2021 Calculation
Segment ROA = 100 × Segment profit ÷ Identifiable assets
= 100 × ÷ =

Segment profitability ratio Reportable segment The company
Segment ROA The Americas Group The Americas Group segment ROA improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021 not reaching 2019 level.

Segment ROA: Consumer Brands Group

Sherwin-Williams Co.; Consumer Brands Group; segment ROA calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Segment profit
Identifiable assets
Segment Profitability Ratio
Segment ROA1

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

1 2021 Calculation
Segment ROA = 100 × Segment profit ÷ Identifiable assets
= 100 × ÷ =

Segment profitability ratio Reportable segment The company
Segment ROA Consumer Brands Group Consumer Brands Group segment ROA improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021 not reaching 2019 level.

Segment ROA: Performance Coatings Group

Sherwin-Williams Co.; Performance Coatings Group; segment ROA calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Segment profit
Identifiable assets
Segment Profitability Ratio
Segment ROA1

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

1 2021 Calculation
Segment ROA = 100 × Segment profit ÷ Identifiable assets
= 100 × ÷ =

Segment profitability ratio Reportable segment The company
Segment ROA Performance Coatings Group Performance Coatings Group segment ROA improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021.

Segment Asset Turnover

Sherwin-Williams Co., asset turnover by reportable segment

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
The Americas Group
Consumer Brands Group
Performance Coatings Group

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

Segment activity ratio Reportable segment The company
Segment asset turnover The Americas Group The Americas Group segment asset turnover ratio improved from 2019 to 2020 and from 2020 to 2021.
Consumer Brands Group Consumer Brands Group segment asset turnover ratio improved from 2019 to 2020 and from 2020 to 2021.
Performance Coatings Group Performance Coatings Group segment asset turnover ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.

Segment Asset Turnover: The Americas Group

Sherwin-Williams Co.; The Americas Group; segment asset turnover calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Net sales and intersegment transfers
Identifiable assets
Segment Activity Ratio
Segment asset turnover1

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

1 2021 Calculation
Segment asset turnover = Net sales and intersegment transfers ÷ Identifiable assets
= ÷ =

Segment activity ratio Reportable segment The company
Segment asset turnover The Americas Group The Americas Group segment asset turnover ratio improved from 2019 to 2020 and from 2020 to 2021.

Segment Asset Turnover: Consumer Brands Group

Sherwin-Williams Co.; Consumer Brands Group; segment asset turnover calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Net sales and intersegment transfers
Identifiable assets
Segment Activity Ratio
Segment asset turnover1

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

1 2021 Calculation
Segment asset turnover = Net sales and intersegment transfers ÷ Identifiable assets
= ÷ =

Segment activity ratio Reportable segment The company
Segment asset turnover Consumer Brands Group Consumer Brands Group segment asset turnover ratio improved from 2019 to 2020 and from 2020 to 2021.

Segment Asset Turnover: Performance Coatings Group

Sherwin-Williams Co.; Performance Coatings Group; segment asset turnover calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Net sales and intersegment transfers
Identifiable assets
Segment Activity Ratio
Segment asset turnover1

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

1 2021 Calculation
Segment asset turnover = Net sales and intersegment transfers ÷ Identifiable assets
= ÷ =

Segment activity ratio Reportable segment The company
Segment asset turnover Performance Coatings Group Performance Coatings Group segment asset turnover ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.

Segment Capital Expenditures to Depreciation

Sherwin-Williams Co., capital expenditures to depreciation by reportable segment

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
The Americas Group
Consumer Brands Group
Performance Coatings Group

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

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation The Americas Group The Americas Group segment capital expenditures to depreciation ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.
Consumer Brands Group Consumer Brands Group segment capital expenditures to depreciation ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 not reaching 2019 level.
Performance Coatings Group Performance Coatings Group segment capital expenditures to depreciation ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.

Segment Capital Expenditures to Depreciation: The Americas Group

Sherwin-Williams Co.; The Americas Group; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Capital expenditures
Depreciation
Segment Financial Ratio
Segment capital expenditures to depreciation1

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

1 2021 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation
= ÷ =

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation The Americas Group The Americas Group segment capital expenditures to depreciation ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.

Segment Capital Expenditures to Depreciation: Consumer Brands Group

Sherwin-Williams Co.; Consumer Brands Group; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Capital expenditures
Depreciation
Segment Financial Ratio
Segment capital expenditures to depreciation1

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

1 2021 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation
= ÷ =

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Consumer Brands Group Consumer Brands Group segment capital expenditures to depreciation ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 not reaching 2019 level.

Segment Capital Expenditures to Depreciation: Performance Coatings Group

Sherwin-Williams Co.; Performance Coatings Group; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Capital expenditures
Depreciation
Segment Financial Ratio
Segment capital expenditures to depreciation1

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

1 2021 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation
= ÷ =

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Performance Coatings Group Performance Coatings Group segment capital expenditures to depreciation ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.

Net sales and intersegment transfers

Sherwin-Williams Co., net sales and intersegment transfers by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
The Americas Group
Consumer Brands Group
Performance Coatings Group
Administrative
Consolidated totals

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


Segment profit

Sherwin-Williams Co., segment profit by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
The Americas Group
Consumer Brands Group
Performance Coatings Group
Consolidated totals

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


Identifiable assets

Sherwin-Williams Co., identifiable assets by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
The Americas Group
Consumer Brands Group
Performance Coatings Group
Administrative
Consolidated totals

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


Capital expenditures

Sherwin-Williams Co., capital expenditures by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
The Americas Group
Consumer Brands Group
Performance Coatings Group
Administrative
Consolidated totals

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


Depreciation

Sherwin-Williams Co., depreciation by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
The Americas Group
Consumer Brands Group
Performance Coatings Group
Administrative
Consolidated totals

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