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.

Enterprise Value (EV)

Microsoft Excel

Current Enterprise Value (EV)

Sherwin-Williams Co., current enterprise value calculation

Microsoft Excel
Current share price (P) $231.97
No. shares of common stock outstanding 259,183,053
US$ in thousands
Common equity (market value)1 60,122,693
Total equity 60,122,693
Add: Short-term borrowings (per books) 763,500
Add: Current portion of long-term debt (per books) 260,600
Add: Long-term debt, excluding current portion (per books) 8,590,900
Total equity and debt 69,737,693
Less: Cash and cash equivalents 165,700
Enterprise value (EV) 69,571,993

Based on: 10-K (reporting date: 2021-12-31).

1 Common equity (market value) = Share price × No. shares of common stock outstanding
= 231.97 × 259,183,053


Historical Enterprise Value (EV)

Sherwin-Williams Co., EV calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Share price1, 2 $267.22 $238.97 $191.11 $146.63 $132.73
No. shares of common stock outstanding1 260,373,774 268,805,607 276,683,112 278,154,810 281,981,373
US$ in thousands
Common equity (market value)3 69,577,080 64,236,476 52,876,910 40,785,840 37,427,388
Total equity 69,577,080 64,236,476 52,876,910 40,785,840 37,427,388
Add: Short-term borrowings (book value) 763,500 100 204,700 328,403 633,731
Add: Current portion of long-term debt (book value) 260,600 25,100 429,800 307,191 1,179
Add: Long-term debt, excluding current portion (book value) 8,590,900 8,266,900 8,050,700 8,708,057 9,885,745
Total equity and debt 79,192,080 72,528,576 61,562,110 50,129,491 47,948,043
Less: Cash and cash equivalents 165,700 226,600 161,800 155,505 204,213
Enterprise value (EV) 79,026,380 72,301,976 61,400,310 49,973,986 47,743,830

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 Data adjusted for splits and stock dividends.

2 Closing price as at the filing date of Sherwin-Williams Co. Annual Report.

3 2021 Calculation
Common equity (market value) = Share price × No. shares of common stock outstanding
= 267.22 × 260,373,774

Item Description The company
EV Enterprise value is total company value (the market value of common equity, debt, and preferred equity) minus the value of cash and short-term investments. Sherwin-Williams Co. EV increased from 2019 to 2020 and from 2020 to 2021.