Edition:
United States

Sherwin-Williams Co (SHW.N)

SHW.N on New York Stock Exchange

352.00USD
25 Sep 2017
Change (% chg)

$2.24 (+0.64%)
Prev Close
$349.76
Open
$347.40
Day's High
$352.93
Day's Low
$347.40
Volume
119,834
Avg. Vol
163,078
52-wk High
$362.50
52-wk Low
$239.48

Consensus Recommendations

Consensus Recommendation Next Earnings (approx.) Company Fiscal Year
End Month
Last Updated
Outperform 4.96 December 26 Sep 2017

Analyst Recommendations and Revisions

1-5 Linear Scale Current 1 Month
Ago
2 Month
Ago
3 Month
Ago
(1) BUY 7 7 7 6
(2) OUTPERFORM 7 7 7 8
(3) HOLD 8 8 7 7
(4) UNDERPERFORM 1 1 1 1
(5) SELL 0 0 0 0
No Opinion 0 0 0 0
Mean Rating 2.13 2.13 2.09 2.14

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-17 15 4,495.42 4,730.04 4,394.30 3,481.92
Quarter Ending Dec-17 15 3,862.65 4,126.17 3,689.00 2,857.34
Year Ending Dec-17 18 14,833.70 15,488.30 14,314.90 12,377.30
Year Ending Dec-18 18 17,417.00 19,073.70 16,560.00 12,926.60
Earnings (per share)
Quarter Ending Sep-17 18 4.96 5.20 4.57 4.71
Quarter Ending Dec-17 19 3.01 3.69 2.46 2.70
Year Ending Dec-17 16 14.98 15.55 14.00 14.05
Year Ending Dec-18 20 17.87 18.75 16.60 15.63
LT Growth Rate (%) 2 14.70 15.60 13.80 10.09

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-17 3,771.36 3,735.82 35.55 0.94
Quarter Ending Mar-17 2,717.35 2,761.39 44.04 1.62
Quarter Ending Dec-16 2,685.44 2,782.59 97.15 3.62
Quarter Ending Sep-16 3,283.43 3,279.46 3.97 0.12
Quarter Ending Jun-16 3,282.54 3,219.52 63.02 1.92
Earnings (per share)
Quarter Ending Jun-17 4.58 4.52 0.06 1.28
Quarter Ending Mar-17 2.08 2.27 0.19 9.34
Quarter Ending Dec-16 2.21 2.42 0.21 9.62
Quarter Ending Sep-16 4.32 4.23 0.09 2.14
Quarter Ending Jun-16 4.14 4.06 0.08 2.04

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-17 4,495.42 4,495.42 4,498.58 4,560.83 3,481.92
Quarter Ending Dec-17 3,862.65 3,862.65 3,862.56 3,928.33 2,857.34
Year Ending Dec-17 14,833.70 14,833.70 14,836.60 14,608.40 12,377.30
Year Ending Dec-18 17,417.00 17,417.00 17,413.70 17,549.60 12,926.60
Earnings (per share)
Quarter Ending Sep-17 4.96 4.96 4.96 4.93 4.71
Quarter Ending Dec-17 3.01 3.01 3.01 2.98 2.70
Year Ending Dec-17 14.98 14.98 15.00 14.74 14.05
Year Ending Dec-18 17.87 17.87 17.80 17.64 15.63

Estimates Revisions Summary

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