Edition:
United States

Sherwin-Williams Co (SHW)

SHW on New York Consolidated

350.57USD
21 Sep 2017
Change (% chg)

$3.53 (+1.02%)
Prev Close
$347.04
Open
$347.29
Day's High
$351.67
Day's Low
$346.90
Volume
459,533
Avg. Vol
657,910
52-wk High
$362.57
52-wk Low
$239.48

Consensus Recommendations

Consensus Recommendation Next Earnings (approx.) Company Fiscal Year
End Month
Last Updated
Outperform 4.96 December 21 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,498.58 4,498.58 4,604.47 3,481.92
Quarter Ending Dec-17 3,862.65 3,862.56 3,862.56 3,953.23 2,857.34
Year Ending Dec-17 14,833.70 14,836.30 14,836.60 14,549.20 12,377.30
Year Ending Dec-18 17,417.00 17,406.60 17,413.70 17,506.10 12,926.60
Earnings (per share)
Quarter Ending Sep-17 4.96 4.96 4.96 4.83 4.71
Quarter Ending Dec-17 3.01 3.01 3.01 3.01 2.70
Year Ending Dec-17 14.98 14.99 15.00 14.56 14.05
Year Ending Dec-18 17.87 17.87 17.80 17.63 15.63

Estimates Revisions Summary

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