Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

Sherwin-Williams Co. (NYSE:SHW)

Enterprise Value (EV)

Intermediate level

Current Enterprise Value (EV)

Sherwin-Williams Co., current enterprise value calculation

Microsoft Excel LibreOffice Calc
Current share price (P) $682.83
No. shares of common stock outstanding 91,049,658
US$ in thousands
Common equity (market value)1 62,171,438 
Total equity 62,171,438 
Add: Short-term borrowings (per books) 204,700 
Add: Current portion of long-term debt (per books) 429,800 
Add: Long-term debt, excluding current portion (per books) 8,050,700 
Total equity and debt 70,856,638 
Less: Cash and cash equivalents 161,800 
Enterprise value (EV) 70,694,838 

Based on: 10-K (filing date: 2020-02-21).

1 Common equity (market value) = Share price × No. shares of common stock outstanding
= 682.83 × 91,049,658

Historical Enterprise Value (EV)

Sherwin-Williams Co., EV calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Share price1, 2 $573.34 $439.88 $398.20 $312.46 $259.71
No. shares of common stock outstanding1 92,227,704 92,718,270 93,993,791 93,307,230 92,270,422
US$ in thousands
Common equity (market value)3 52,877,832  40,784,913  37,428,328  29,154,777  23,963,551 
Total equity 52,877,832  40,784,913  37,428,328  29,154,777  23,963,551 
Add: Short-term borrowings (book value) 204,700  328,403  633,731  40,739  39,462 
Add: Current portion of long-term debt (book value) 429,800  307,191  1,179  700,475  3,154 
Add: Long-term debt, excluding current portion (book value) 8,050,700  8,708,057  9,885,745  1,211,326  1,920,196 
Total equity and debt 61,563,032  50,128,564  47,948,983  31,107,317  25,926,363 
Less: Cash and cash equivalents 161,800  155,505  204,213  889,793  205,744 
Enterprise value (EV) 61,401,232  49,973,059  47,744,770  30,217,524  25,720,619 

Based on: 10-K (filing date: 2020-02-21), 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-22), 10-K (filing date: 2016-02-24).

1 Data adjusted for splits and stock dividends.

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

3 2019 Calculation
Common equity (market value) = Share price × No. shares of common stock outstanding
= 573.34 × 92,227,704

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.’s EV increased from 2017 to 2018 and from 2018 to 2019.