Edition:
United States

Sherwin-Williams Co (SHW.N)

SHW.N on New York Stock Exchange

386.48USD
24 May 2018
Change (% chg)

$1.98 (+0.51%)
Prev Close
$384.50
Open
$383.09
Day's High
$387.57
Day's Low
$378.55
Volume
189,665
Avg. Vol
195,197
52-wk High
$435.00
52-wk Low
$326.81

Revenue & Earnings Per Share

    Revenue* Earnings Per Share**
FY 2018 Mar '18 3,965.01 2.618
FY 2017 Dec '17 3,979.56 3.039
Sep '17 4,507.02 3.325
Jun '17 3,735.82 3.798
Mar '17 2,761.39 2.530
FY 2016 Dec '16 2,782.59 2.144
Sep '16 3,279.46 4.081
Jun '16 3,219.52 3.993
Mar '16 2,574.02 1.752
 
*Note: Units in Millions ofU.S. Dollars
**Note: Units in U.S. Dollars

Consensus Estimates Analysis

  # of Estimates Mean High Low 1 Year Ago
SALES (in millions)
Quarter Ending Jun-18 17 4,682.36 4,901.40 3,965.00 3,593.24
Quarter Ending Sep-18 15 4,813.87 4,886.00 4,748.09 3,627.48
Year Ending Dec-18 22 17,684.30 18,017.00 17,131.00 13,250.20
Year Ending Dec-19 23 18,696.80 19,749.00 18,028.00 13,793.90
Earnings (per share)
Quarter Ending Jun-18 24 5.67 5.96 5.25 4.96
Quarter Ending Sep-18 24 5.61 5.89 5.24 4.90
Year Ending Dec-18 26 18.82 19.30 18.15 15.40
Year Ending Dec-19 26 21.90 22.85 20.75 16.82
LT Growth Rate (%) 5 15.28 18.38 9.00 10.97
Sales and Profit Figures in US Dollar (USD);

Valuation Ratios

  Company industry sector
P/E Ratio (TTM) 30.24 27.07 26.00
P/E High - Last 5 Yrs. 32.28 64.98 167.77
P/E Low - Last 5 Yrs. 22.42 15.87 14.86
Beta 1.17 0.85 1.05
Price to Sales (TTM) 2.23 2.82 3.03
Price to Book (MRQ) 9.80 4.07 2.69
Price to Tangible Book (MRQ) -- 4.19 47.97
Price to Cash Flow (TTM) 19.92 17.31 19.71
% Owned Institutions 77.09 0.16 0.22

Dividends

  Company industry sector
Dividend Yield 0.89 1.23 1.80
Dividend Yield - 5 Year Avg 0.98 0.29 1.49
Dividend 5 Year Growth Rate 16.86 59.69 25.11
Payout Ratio(TTM) 26.34 4.09 38.82

Growth Rates

  Company industry sector
Sales (MRQ) vs Qtr. 1 Yr. Ago 43.59 14.99 55.85
Sales (TTM) vs TTM 1 Yr. Ago 34.41 22.54 16.42
Sales - 5 Yr. Growth Rate 9.46 1.87 1.27
EPS (MRQ) vs Qtr. 1 Yr. Ago 3.49 -9.88 136.84
EPS (TTM) vs TTM 1 Yr. Ago 0.25 -- --
EPS - 5 Yr. Growth Rate 16.10 2.41 -4.27
Capital Spending - 5 Yr. Growth Rate 7.23 17.32 4.03

Financial Strength

  Company industry sector
Quick Ratio (MRQ) 0.67 1.95 2.15
Current Ratio (MRQ) 1.13 2.37 2.70
LT Debt to Equity (MRQ) 268.05 30.69 24.34
Total Debt to Equity (MRQ) 293.01 37.83 33.32
Interest Coverage (TTM) 11.71 21.98 16.18

Profitability Ratios

  Company industry sector
Gross Margin (TTM) 44.01 23.99 24.45
Gross Margin - 5 Yr. Avg. 47.14 15.28 24.86
EBITD Margin (TTM) 15.02 -- --
EBITD - 5 Yr. Avg 14.86 13.49 20.25
Operating Margin (TTM) 11.27 17.84 12.12
Operating Margin - 5 Yr. Avg. 12.73 9.72 13.53
Pre-Tax Margin (TTM) 9.42 16.70 12.41
Pre-Tax Margin - 5 Yr. Avg. 11.79 8.91 13.60
Net Profit Margin (TTM) 7.52 12.58 9.52
Net Profit Margin - 5 Yr. Avg. 8.42 6.47 10.46
Effective Tax Rate (TTM) 20.22 24.61 22.04
Effective Tax Rate - 5 Yr. Avg. 28.59 26.74 24.36

Efficiency

  Company industry sector
Revenue/Employee (TTM) 307,191 13,844,066,138 6,824,279,584
Net Income/Employee (TTM) 23,092 1,815,703,747 785,361,431
Receivable Turnover (TTM) 8.79 12.44 10.21
Inventory Turnover (TTM) 5.58 7.77 6.15
Asset Turnover (TTM) 1.18 0.91 0.68

Management Effectiveness

  Company industry sector
Return on Assets (TTM) 8.90 11.42 6.70
Return on Assets - 5 Yr. Avg. 13.29 6.48 7.41
Return on Investment (TTM) 12.11 14.87 8.64
Return on Investment - 5 Yr. Avg. 20.37 8.78 9.23
Return on Equity (TTM) 42.29 20.20 20.48
Return on Equity - 5 Yr. Avg. 61.29 12.59 11.64
  1 Year 3 Year 5 Year
Sales % 26.39 10.42 9.46
EPS (TTM) % 5.97 13.15 16.10
Dividend % 1.19 15.62 16.86
Note: Units in Millions of US Dollars

Performance for Sherwin-Williams Co

Period %
Actual
% vs.
S&P 500
Rank In
Industry
Industry
Rank
4 Week 3.16 -0.38 99 16
13 Week -3.18 -4.31 99 31
26 Week -1.55 -6.46 99 46
52 Week 15.84 1.65 99 50
YTD -6.23 -8.28 99 42
Note:: Rank is a percentile that ranges from 0 to 99, with 99 = best.

Institutional Holders

% Shares Owned: 77.11%
# of Holders: 1,125
Total Shares Held: 72,135,360
3 Mo. Net Change: -481,614
# New Positions: 65
# Closed Positions: 105
# Increased Positions: 405
# Reduced Positions: 508
# Net Buyers: -103
NYSE and AMEX quotes delayed by at least 20 minutes. NASDAQ delayed by at least 15 minutes. For a complete list of exchanges and delays, please click here.