Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Sherwin-Williams Company (The) logo

Sherwin-Williams Company (The)

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
Peers   
VAL / 
PPG / 
RPM / 
AKZOY / 
DD / 
MAS / 
FUL / 
Last updated: Thursday 23rd March 2023
47
MarketXLS Rank
55
Value
30
Technical
57
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock
Are you?
twitterstocktwits
Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

AKZOY

DD

0.015840 B7.175.37

FUL

0.00964 B24.269.53

HD

0.0184385 B24.6357.35

MAS

0.015615 B34.660.32

PPG

0.015437 B26152.83

RPM

0.018511 B25.386.59

VAL

Financials

SHW Income Statement

Annual
Save
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
Total revenues10,186 M11,130 M11,339 M11,856 M14,984 M17,535 M17,901 M18,362 M19,945 M22,149 M
Cost of sales5,381 M5,766 M5,411 M5,565 M7,488 M9,241 M9,028 M8,830 M10,566 M12,507 M
Gross operating profit4,617 M5,164 M5,730 M6,093 M7,004 M7,697 M8,298 M8,951 M8,806 M9,325 M
Selling Gen & administrative expense3,465 M3,859 M3,917 M4,183 M4,813 M5,210 M5,298 M5,515 M5,569 M6,015 M
Research & development expense0000000000
Operating income1,152 M1,305 M1,615 M1,713 M1,699 M1,890 M2,425 M2,854 M2,665 M2,994 M
floaterest income0000000000
floaterest expense0000000000
Other income net4 M25 M6 M40 M35 M-159 M-109 M12 M-76 M-38 M
Pre-tax Income (EBT)1,086 M1,258 M1,549 M1,595 M1,469 M1,360 M1,982 M2,519 M2,249 M2,573 M
Income taxes333 M392 M495 M463 M-300 M251 M441 M489 M384 M553 M
Net income from total operations753 M866 M1,054 M1,133 M1,728 M1,109 M1,541 M2,030 M1,864 M2,020 M
Minority floaterest0000000000
Total net income753 M866 M1,054 M1,133 M1,728 M1,109 M1,541 M2,030 M1,864 M2,020 M
Preferred dividendsN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A
Net income available for common753 M866 M1,054 M1,133 M1,770 M1,109 M1,541 M2,030 M1,864 M2,020 M
Depreciation188 M199 M199 M197 M492 M596 M575 M581 M573 M317 M
Amortization0028 M25 M207 M318 M313 M313 M310 M317 M
Operating income before depreciation (EBITDA)1,336 M1,521 M1,809 M1,947 M2,225 M2,323 M2,906 M3,441 M3,156 M3,281 M
Total Income available for floaterest expense (EBIT)0000000000
Basic EPS total2.472.983.794.116.23.975.67.487.17.83
Diluted EPS total2.422.933.7246.073.895.57.366.987.72
Call: 1-877-778-8358
Ankur Mohan MarketXLS
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