Edition:
India

Sherwin-Williams Co (SHW.N)

SHW.N on New York Stock Exchange

444.80USD
21 Aug 2018
Change (% chg)

$0.74 (+0.17%)
Prev Close
$444.06
Open
$445.00
Day's High
$448.75
Day's Low
$444.71
Volume
110,380
Avg. Vol
171,933
52-wk High
$450.81
52-wk Low
$326.81

Consensus Recommendations

Consensus Recommendation Next Earnings (approx.) Company Fiscal Year
End Month
Last Updated
Outperform 5.78 December 22 Aug 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 8 8
(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.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 17 4,828.77 4,901.00 4,714.00 4,703.43
Quarter Ending Dec-18 16 4,234.27 4,308.00 4,169.00 4,009.14
Year Ending Dec-18 21 17,812.70 17,936.00 17,622.00 17,413.70
Year Ending Dec-19 23 18,838.40 19,749.00 18,028.00 18,031.00
Earnings (per share)
Quarter Ending Sep-18 24 5.78 6.00 5.43 5.65
Quarter Ending Dec-18 24 4.19 4.87 3.91 3.48
Year Ending Dec-18 25 19.28 19.60 19.07 17.80
Year Ending Dec-19 26 22.31 23.00 21.00 20.33
LT Growth Rate (%) 4 16.71 20.64 9.00 12.15

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,828.77 4,828.77 4,803.35 4,808.80 4,703.43
Quarter Ending Dec-18 4,234.27 4,234.27 4,220.03 4,225.48 4,009.14
Year Ending Dec-18 17,812.70 17,812.70 17,667.20 17,680.00 17,413.70
Year Ending Dec-19 18,838.40 18,838.40 18,686.80 18,696.60 18,031.00
Earnings (per share)
Quarter Ending Sep-18 5.78 5.78 5.61 5.61 5.65
Quarter Ending Dec-18 4.19 4.19 4.01 4.00 3.48
Year Ending Dec-18 19.28 19.28 18.82 18.82 17.80
Year Ending Dec-19 22.31 22.31 21.89 21.93 20.33

Estimates Revisions Summary

  Last Week Last 4 Weeks
Number Of Revisions: Up Down Up Down
Revenue
Quarter Ending Sep-18 0 0 9 6
Quarter Ending Dec-18 0 0 9 6
Year Ending Dec-18 0 0 15 5
Year Ending Dec-19 0 0 16 4
Earnings
Quarter Ending Sep-18 0 0 22 1
Quarter Ending Dec-18 0 0 20 2
Year Ending Dec-18 0 0 23 0
Year Ending Dec-19 0 0 20 1