Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

$24.99

Analysis of Reportable Segments

Microsoft Excel

Paying user area


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, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Paint Stores Group
Consumer Brands Group
Performance Coatings Group

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

Segment profitability ratio Reportable segment The company
Segment profit margin Paint Stores Group Paint Stores Group segment profit margin ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.
Consumer Brands Group Consumer Brands Group segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023.
Performance Coatings Group Performance Coatings Group segment profit margin ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Profit Margin: Paint Stores Group

Sherwin-Williams Co.; Paint Stores Group; segment profit margin calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
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: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

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

Segment profitability ratio Reportable segment The company
Segment profit margin Paint Stores Group Paint Stores Group segment profit margin ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

Segment Profit Margin: Consumer Brands Group

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

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
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: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 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 deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Profit Margin: Performance Coatings Group

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

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
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: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 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 2021 to 2022 and from 2022 to 2023.

Segment Return on Assets (Segment ROA)

Sherwin-Williams Co., ROA by reportable segment

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Paint Stores Group
Consumer Brands Group
Performance Coatings Group

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

Segment profitability ratio Reportable segment The company
Segment ROA Paint Stores Group Paint Stores Group segment ROA improved from 2021 to 2022 and from 2022 to 2023.
Consumer Brands Group Consumer Brands Group segment ROA deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.
Performance Coatings Group Performance Coatings Group segment ROA improved from 2021 to 2022 and from 2022 to 2023.

Segment ROA: Paint Stores Group

Sherwin-Williams Co.; Paint Stores Group; segment ROA calculation

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

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

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

Segment profitability ratio Reportable segment The company
Segment ROA Paint Stores Group Paint Stores Group segment ROA improved from 2021 to 2022 and from 2022 to 2023.

Segment ROA: Consumer Brands Group

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

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

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

1 2023 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 deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.

Segment ROA: Performance Coatings Group

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

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

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

1 2023 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 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover

Sherwin-Williams Co., asset turnover by reportable segment

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Paint Stores Group
Consumer Brands Group
Performance Coatings Group

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

Segment activity ratio Reportable segment The company
Segment asset turnover Paint Stores Group Paint Stores Group segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.
Consumer Brands Group Consumer Brands Group segment asset turnover ratio deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.
Performance Coatings Group Performance Coatings Group segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover: Paint Stores Group

Sherwin-Williams Co.; Paint Stores Group; segment asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
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: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

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

Segment activity ratio Reportable segment The company
Segment asset turnover Paint Stores Group Paint Stores Group segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover: Consumer Brands Group

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

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
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: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 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 deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.

Segment Asset Turnover: Performance Coatings Group

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

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
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: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 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 improved from 2021 to 2022 and from 2022 to 2023.

Segment Capital Expenditures to Depreciation

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

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Paint Stores Group
Consumer Brands Group
Performance Coatings Group

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

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Paint Stores Group Paint Stores Group segment capital expenditures to depreciation ratio improved from 2021 to 2022 and from 2022 to 2023.
Consumer Brands Group Consumer Brands Group segment capital expenditures to depreciation ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.
Performance Coatings Group Performance Coatings Group segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Capital Expenditures to Depreciation: Paint Stores Group

Sherwin-Williams Co.; Paint Stores Group; segment capital expenditures to depreciation calculation

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

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

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

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Paint Stores Group Paint Stores Group segment capital expenditures to depreciation ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Capital Expenditures to Depreciation: Consumer Brands Group

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

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

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

1 2023 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 improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Segment Capital Expenditures to Depreciation: Performance Coatings Group

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

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

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

1 2023 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 2021 to 2022 and from 2022 to 2023.

Net sales and intersegment transfers

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

US$ in thousands

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Paint Stores Group
Consumer Brands Group
Performance Coatings Group
Administrative
Consolidated totals

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


Segment profit

Sherwin-Williams Co., segment profit by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Paint Stores Group
Consumer Brands Group
Performance Coatings Group
Consolidated totals

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


Identifiable assets

Sherwin-Williams Co., identifiable assets by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Paint Stores Group
Consumer Brands Group
Performance Coatings Group
Administrative
Consolidated totals

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


Capital expenditures

Sherwin-Williams Co., capital expenditures by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Paint Stores Group
Consumer Brands Group
Performance Coatings Group
Administrative
Consolidated totals

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


Depreciation

Sherwin-Williams Co., depreciation by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Paint Stores Group
Consumer Brands Group
Performance Coatings Group
Administrative
Consolidated totals

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