Sherwin-Williams Company (The)
SHW
NYE
Sector: Basic Materials
Industry: Specialty Chemicals
211.34
USD
-9.46
(-4.28%)
Optionable: Yes Market Cap: 56,978 M 90-day average vol: 1,563,794
Previous close: 220.8 Open: 218.98 Bid: 211.75 Ask: 211.75
52 week range
195.24 285.00
Last updated: Thursday 23rd March 2023
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started todaySearch for a stock
Are you?
Metrics
Valuation
Price per Sales TTM ($) | 2.57 |
Price per Book TTM ($) | 18.26 |
PE Ratio (TTM) | 28.40 |
Book Value per Share ($) | 10.26 |
5 Year PE Range | 30.5 , 50.6 |
Returns
7 Day Return | -2.41% | |
1 Month Return | -5.06% | |
3 Month Return | -12.18% | |
1 Year Return | -14.68% | |
3 Year Return | 63.82% | |
5 Year Return | 70.38% | |
YTD Return | -10.95% |
Risk
Dividends
Analyst Estimates
Financial Health
Technicals
RSI (14 Day) | 36.59 |
14 Day SMA ($) | 218.65 |
14 Day EMA ($) | 218.68 |
Money Flow Index | 68.28 |
Average True Range | 5.70 |
50 Day SMA ($) | 230.05 |
200 Day SMA ($) | 233.40 |
ADX | 13.45 |
MACD | -3.76 |
Growth
Free Cash Flow QoQ Growth | -100.00% |
Free Cash Flow YoY Growth | 0.00% |
Revenue YoY Growth | 0.00% |
EPS QoQ Growth | -43.61% |
Revenue QoQ Growth | -13.51% |
EPS YoY Growth | 0.00% |
Profitability
Financials
SHW Income Statement
Annual
Save
| Dec-13 | Dec-14 | Dec-15 | Dec-16 | Dec-17 | Dec-18 | Dec-19 | Dec-20 | Dec-21 | Dec-22 | |
|---|---|---|---|---|---|---|---|---|---|---|
| Total revenues | 10,186 M | 11,130 M | 11,339 M | 11,856 M | 14,984 M | 17,535 M | 17,901 M | 18,362 M | 19,945 M | 22,149 M |
| Cost of sales | 5,381 M | 5,766 M | 5,411 M | 5,565 M | 7,488 M | 9,241 M | 9,028 M | 8,830 M | 10,566 M | 12,507 M |
| Gross operating profit | 4,617 M | 5,164 M | 5,730 M | 6,093 M | 7,004 M | 7,697 M | 8,298 M | 8,951 M | 8,806 M | 9,325 M |
| Selling Gen & administrative expense | 3,465 M | 3,859 M | 3,917 M | 4,183 M | 4,813 M | 5,210 M | 5,298 M | 5,515 M | 5,569 M | 6,015 M |
| Research & development expense | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Operating income | 1,152 M | 1,305 M | 1,615 M | 1,713 M | 1,699 M | 1,890 M | 2,425 M | 2,854 M | 2,665 M | 2,994 M |
| floaterest income | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| floaterest expense | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Other income net | 4 M | 25 M | 6 M | 40 M | 35 M | -159 M | -109 M | 12 M | -76 M | -38 M |
| Pre-tax Income (EBT) | 1,086 M | 1,258 M | 1,549 M | 1,595 M | 1,469 M | 1,360 M | 1,982 M | 2,519 M | 2,249 M | 2,573 M |
| Income taxes | 333 M | 392 M | 495 M | 463 M | -300 M | 251 M | 441 M | 489 M | 384 M | 553 M |
| Net income from total operations | 753 M | 866 M | 1,054 M | 1,133 M | 1,728 M | 1,109 M | 1,541 M | 2,030 M | 1,864 M | 2,020 M |
| Minority floaterest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total net income | 753 M | 866 M | 1,054 M | 1,133 M | 1,728 M | 1,109 M | 1,541 M | 2,030 M | 1,864 M | 2,020 M |
| Preferred dividends | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |
| Net income available for common | 753 M | 866 M | 1,054 M | 1,133 M | 1,770 M | 1,109 M | 1,541 M | 2,030 M | 1,864 M | 2,020 M |
| Depreciation | 188 M | 199 M | 199 M | 197 M | 492 M | 596 M | 575 M | 581 M | 573 M | 317 M |
| Amortization | 0 | 0 | 28 M | 25 M | 207 M | 318 M | 313 M | 313 M | 310 M | 317 M |
| Operating income before depreciation (EBITDA) | 1,336 M | 1,521 M | 1,809 M | 1,947 M | 2,225 M | 2,323 M | 2,906 M | 3,441 M | 3,156 M | 3,281 M |
| Total Income available for floaterest expense (EBIT) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Basic EPS total | 2.47 | 2.98 | 3.79 | 4.11 | 6.2 | 3.97 | 5.6 | 7.48 | 7.1 | 7.83 |
| Diluted EPS total | 2.42 | 2.93 | 3.72 | 4 | 6.07 | 3.89 | 5.5 | 7.36 | 6.98 | 7.72 |
Call: 1-877-778-8358
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today
Get started today