Edition:
India

Sherwin-Williams Co (SHW.N)

SHW.N on New York Stock Exchange

398.20USD
23 Feb 2018
Change (% chg)

$-0.68 (-0.17%)
Prev Close
$398.88
Open
$399.41
Day's High
$399.49
Day's Low
$395.00
Volume
95,211
Avg. Vol
149,145
52-wk High
$435.00
52-wk Low
$305.86

Consensus Recommendations

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

Analyst Recommendations and Revisions

1-5 Linear Scale Current 1 Month
Ago
2 Month
Ago
3 Month
Ago
(1) BUY 9 10 10 9
(2) OUTPERFORM 8 7 7 7
(3) HOLD 7 8 7 7
(4) UNDERPERFORM 0 0 0 0
(5) SELL 0 0 0 0
No Opinion 0 0 0 0
Mean Rating 1.92 1.92 1.88 1.91

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 Mar-18 15 3,945.78 4,053.00 3,724.00 2,863.70
Quarter Ending Jun-18 14 4,753.67 5,143.70 4,251.95 3,582.98
Year Ending Dec-18 22 17,712.00 18,173.90 17,199.50 13,162.60
Year Ending Dec-19 20 18,626.00 19,190.20 17,972.40 13,735.80
Earnings (per share)
Quarter Ending Mar-18 22 3.14 3.74 2.29 2.50
Quarter Ending Jun-18 22 5.75 6.08 5.14 5.12
Year Ending Dec-18 24 19.01 19.50 16.60 15.23
Year Ending Dec-19 24 21.82 23.04 19.00 16.67
LT Growth Rate (%) 4 18.48 21.14 15.20 10.74

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 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
Quarter Ending Dec-16 2,685.44 2,782.59 97.15 3.62
Earnings (per share)
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
Quarter Ending Dec-16 2.21 2.42 0.21 9.62

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 Mar-18 3,945.78 3,945.78 3,967.72 3,957.07 2,863.70
Quarter Ending Jun-18 4,753.67 4,753.67 4,787.91 4,797.11 3,582.98
Year Ending Dec-18 17,712.00 17,712.00 17,695.30 17,686.00 13,162.60
Year Ending Dec-19 18,626.00 18,626.00 18,535.20 18,523.50 13,735.80
Earnings (per share)
Quarter Ending Mar-18 3.14 3.14 3.17 3.05 2.50
Quarter Ending Jun-18 5.75 5.75 5.74 5.65 5.12
Year Ending Dec-18 19.01 19.01 18.48 18.12 15.23
Year Ending Dec-19 21.82 21.82 21.42 21.10 16.67

Estimates Revisions Summary

  Last Week Last 4 Weeks
Number Of Revisions: Up Down Up Down
Revenue
Quarter Ending Mar-18 0 0 3 6
Quarter Ending Jun-18 0 0 3 6
Year Ending Dec-18 0 0 12 7
Year Ending Dec-19 0 0 9 4
Earnings
Quarter Ending Mar-18 0 0 9 5
Quarter Ending Jun-18 0 0 6 7
Year Ending Dec-18 0 0 17 5
Year Ending Dec-19 0 0 11 3