Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

Market Value Added (MVA)

Microsoft Excel

Market value added (MVA) is the difference between a firm fair value and its invested capital. MVA is a measure of the value a company has created in excess of the resources already committed to the enterprise.


MVA

Sherwin-Williams Co., MVA calculation

US$ in thousands

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Fair value of debt and finance lease liabilities1 9,024,700 8,990,100 9,361,900 10,542,800 9,733,600
Operating lease liability 2,024,900 1,958,800 1,938,200 1,880,400 1,821,400
Market value of common equity 87,982,475 79,204,627 57,537,005 69,577,080 64,236,476
Market (fair) value of Sherwin-Williams 99,032,075 90,153,527 68,837,105 82,000,280 75,791,476
Less: Invested capital2 16,707,900 16,412,900 17,346,300 15,808,100 15,489,500
MVA 82,324,175 73,740,627 51,490,805 66,192,180 60,301,976

Based on: 10-K (reporting date: 2024-12-31), 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).

1 Fair value of debt. See details »

2 Invested capital. See details »

Item Description The company
MVA Sherwin-Williams Co. market (fair) value less invested capital. Sherwin-Williams Co. MVA increased from 2022 to 2023 and from 2023 to 2024.

MVA Spread Ratio

Sherwin-Williams Co., MVA spread ratio calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in thousands)
Market value added (MVA)1 82,324,175 73,740,627 51,490,805 66,192,180 60,301,976
Invested capital2 16,707,900 16,412,900 17,346,300 15,808,100 15,489,500
Performance Ratio
MVA spread ratio3 492.73% 449.28% 296.84% 418.72% 389.31%
Benchmarks
MVA Spread Ratio, Competitors4
Linde plc 221.98% 223.74% 162.37% 128.35% 92.56%

Based on: 10-K (reporting date: 2024-12-31), 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).

1 MVA. See details »

2 Invested capital. See details »

3 2024 Calculation
MVA spread ratio = 100 × MVA ÷ Invested capital
= 100 × 82,324,175 ÷ 16,707,900 = 492.73%

4 Click competitor name to see calculations.

Performance ratio Description The company
MVA spread ratio The ratio of MVA to invested capital. It measures the efficiency with which investors’ capital investment has translated into a franchise value and into an aggregate net present value premium. Sherwin-Williams Co. MVA spread ratio improved from 2022 to 2023 and from 2023 to 2024.

MVA Margin

Sherwin-Williams Co., MVA margin calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in thousands)
Market value added (MVA)1 82,324,175 73,740,627 51,490,805 66,192,180 60,301,976
Net sales 23,098,500 23,051,900 22,148,900 19,944,600 18,361,700
Performance Ratio
MVA margin2 356.40% 319.89% 232.48% 331.88% 328.41%
Benchmarks
MVA Margin, Competitors3
Linde plc 503.64% 499.92% 352.06% 302.43% 267.64%

Based on: 10-K (reporting date: 2024-12-31), 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).

1 MVA. See details »

2 2024 Calculation
MVA margin = 100 × MVA ÷ Net sales
= 100 × 82,324,175 ÷ 23,098,500 = 356.40%

3 Click competitor name to see calculations.

Performance ratio Description The company
MVA margin The ratio of MVA to sales. It measures how efficiently and prodigiously sales translate into franchise value. Sherwin-Williams Co. MVA margin ratio improved from 2022 to 2023 and from 2023 to 2024.