Edition:
United States

Sherwin-Williams Co (SHW.N)

SHW.N on New York Stock Exchange

469.96USD
21 Sep 2018
Change (% chg)

$-8.02 (-1.68%)
Prev Close
$477.98
Open
$479.64
Day's High
$479.64
Day's Low
$468.10
Volume
484,835
Avg. Vol
149,572
52-wk High
$479.64
52-wk Low
$344.29

Consensus Recommendations

Consensus Recommendation Next Earnings (approx.) Company Fiscal Year
End Month
Last Updated
Outperform 5.78 December 24 Sep 2018

Analyst Recommendations and Revisions

1-5 Linear Scale Current 1 Month
Ago
2 Month
Ago
3 Month
Ago
(1) BUY 9 9 9 9
(2) OUTPERFORM 6 8 8 8
(3) HOLD 9 8 8 8
(4) UNDERPERFORM 0 0 0 0
(5) SELL 0 0 0 0
No Opinion 0 0 0 0
Mean Rating 2.00 1.96 1.96 1.96

Consensus Estimates Analysis

Sales and Profit Figures in US Dollar (USD)
Earnings and Dividend Figures in US Dollar (USD)
  # of Estimates Mean High Low 1 Year
Ago
SALES (in millions)
Quarter Ending Sep-18 16 4,829.51 4,901.00 4,714.00 4,703.43
Quarter Ending Dec-18 15 4,238.36 4,308.00 4,169.00 4,009.14
Year Ending Dec-18 21 17,813.30 17,936.00 17,622.00 17,417.00
Year Ending Dec-19 22 18,884.20 19,749.00 18,585.00 18,069.90
Earnings (per share)
Quarter Ending Sep-18 23 5.78 6.00 5.43 5.65
Quarter Ending Dec-18 23 4.19 4.87 3.91 3.48
Year Ending Dec-18 25 19.28 19.60 19.07 17.87
Year Ending Dec-19 25 22.36 23.30 21.00 20.35
LT Growth Rate (%) 4 16.71 20.64 9.00 14.70

Historical Surprises

Sales and Profit Figures in US Dollar (USD)
Earnings and Dividend Figures in US Dollar (USD)
Estimates vs Actual Estimate Actual Difference Surprise %
SALES (in millions)
Quarter Ending Jun-18 4,672.20 4,773.80 101.59 2.17
Quarter Ending Mar-18 3,941.67 3,965.01 23.34 0.59
Quarter Ending Dec-17 3,938.53 3,979.56 41.04 1.04
Quarter Ending Sep-17 4,436.51 4,507.02 70.51 1.59
Quarter Ending Jun-17 3,771.36 3,735.82 35.55 0.94
Earnings (per share)
Quarter Ending Jun-18 5.66 5.73 0.07 1.29
Quarter Ending Mar-18 3.13 3.57 0.44 13.89
Quarter Ending Dec-17 3.12 3.16 0.04 1.23
Quarter Ending Sep-17 4.65 4.75 0.10 2.07
Quarter Ending Jun-17 4.58 4.52 0.06 1.28

Consensus Estimates Trend

Sales and Profit Figures in US Dollar (USD)
Earnings and Dividend Figures in US Dollar (USD)
  Current 1 Week
Ago
1 Month
Ago
2 Month
Ago
1 Year
Ago
SALES (in millions)
Quarter Ending Sep-18 4,829.51 4,829.51 4,828.77 4,798.89 4,703.43
Quarter Ending Dec-18 4,238.36 4,238.36 4,234.27 4,215.50 4,009.14
Year Ending Dec-18 17,813.30 17,813.30 17,809.40 17,659.50 17,417.00
Year Ending Dec-19 18,884.20 18,884.20 18,875.70 18,686.80 18,069.90
Earnings (per share)
Quarter Ending Sep-18 5.78 5.78 5.78 5.61 5.65
Quarter Ending Dec-18 4.19 4.19 4.19 4.01 3.48
Year Ending Dec-18 19.28 19.28 19.28 18.82 17.87
Year Ending Dec-19 22.36 22.36 22.31 21.89 20.35

Estimates Revisions Summary

  Last Week Last 4 Weeks
Number Of Revisions: Up Down Up Down
Revenue
Quarter Ending Sep-18 0 0 0 0
Quarter Ending Dec-18 0 0 0 0
Year Ending Dec-18 0 0 0 0
Year Ending Dec-19 0 0 0 0
Earnings
Quarter Ending Sep-18 0 0 0 0
Quarter Ending Dec-18 0 0 0 0
Year Ending Dec-18 0 0 0 0
Year Ending Dec-19 0 0 1 0