Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

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

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, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Fair value of debt1 10,542,800 9,733,600 9,211,200 8,931,314 10,776,638
Operating lease liability 1,880,400 1,821,400 1,742,300 1,699,113 1,649,766
Market value of common equity 69,577,080 64,236,476 52,876,910 40,785,840 37,427,388
Market (fair) value of Sherwin-Williams 82,000,280 75,791,476 63,830,410 51,416,267 49,853,792
Less: Invested capital2 15,808,100 15,489,500 16,416,500 16,849,000 17,931,827
MVA 66,192,180 60,301,976 47,413,910 34,567,267 31,921,965

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 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 2019 to 2020 and from 2020 to 2021.

MVA Spread Ratio

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

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Market value added (MVA)1 66,192,180 60,301,976 47,413,910 34,567,267 31,921,965
Invested capital2 15,808,100 15,489,500 16,416,500 16,849,000 17,931,827
Performance Ratio
MVA spread ratio3 418.72% 389.31% 288.82% 205.16% 178.02%
Benchmarks
MVA Spread Ratio, Competitors4
Linde plc 128.35% 92.56% 56.94%

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 MVA. See details »

2 Invested capital. See details »

3 2021 Calculation
MVA spread ratio = 100 × MVA ÷ Invested capital
= 100 × 66,192,180 ÷ 15,808,100 = 418.72%

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 2019 to 2020 and from 2020 to 2021.

MVA Margin

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

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Market value added (MVA)1 66,192,180 60,301,976 47,413,910 34,567,267 31,921,965
Net sales 19,944,600 18,361,700 17,900,800 17,534,493 14,983,788
Performance Ratio
MVA margin2 331.88% 328.41% 264.87% 197.14% 213.04%
Benchmarks
MVA Margin, Competitors3
Linde plc 302.43% 267.64% 158.41%

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 MVA. See details »

2 2021 Calculation
MVA margin = 100 × MVA ÷ Net sales
= 100 × 66,192,180 ÷ 19,944,600 = 331.88%

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 2019 to 2020 and from 2020 to 2021.