Edition:
India

Sherwin-Williams Co (SHW.N)

SHW.N on New York Stock Exchange

382.87USD
23 May 2018
Change (% chg)

$6.90 (+1.84%)
Prev Close
$375.97
Open
$376.00
Day's High
$383.64
Day's Low
$375.81
Volume
153,424
Avg. Vol
192,666
52-wk High
$435.00
52-wk Low
$326.81

Consensus Recommendations

Consensus Recommendation Next Earnings (approx.) Company Fiscal Year
End Month
Last Updated
Outperform 5.67 December 26 May 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 8 8 8 8
(3) HOLD 8 8 7 7
(4) UNDERPERFORM 0 0 0 0
(5) SELL 0 0 0 0
No Opinion 0 0 0 0
Mean Rating 1.96 1.96 1.92 1.92

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 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

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 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
Quarter Ending Mar-17 2,717.35 2,761.39 44.04 1.62
Earnings (per share)
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
Quarter Ending Mar-17 2.08 2.27 0.19 9.34

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 Jun-18 4,682.36 4,684.17 4,823.00 4,792.34 3,593.24
Quarter Ending Sep-18 4,813.87 4,817.17 4,829.64 4,819.53 3,627.48
Year Ending Dec-18 17,684.30 17,689.00 17,761.10 17,726.00 13,250.20
Year Ending Dec-19 18,696.80 18,696.20 18,728.60 18,687.20 13,793.90
Earnings (per share)
Quarter Ending Jun-18 5.67 5.66 5.81 5.80 4.96
Quarter Ending Sep-18 5.61 5.61 5.92 5.92 4.90
Year Ending Dec-18 18.82 18.81 19.08 19.09 15.40
Year Ending Dec-19 21.90 21.86 21.85 21.90 16.82

Estimates Revisions Summary

  Last Week Last 4 Weeks
Number Of Revisions: Up Down Up Down
Revenue
Quarter Ending Jun-18 0 0 6 9
Quarter Ending Sep-18 0 0 6 8
Year Ending Dec-18 0 0 8 14
Year Ending Dec-19 0 0 11 11
Earnings
Quarter Ending Jun-18 0 0 2 20
Quarter Ending Sep-18 0 0 0 23
Year Ending Dec-18 0 0 3 23
Year Ending Dec-19 0 0 11 11