Fundamental Analysis of Sherwin-Williams Co - Growth / Value Index


SHW - Valuation Highlights

Valuation Analysis

   Undervalued - Price to Intrinsic Value of 0.615
   Tremendous increasing in Book Value last 3 year
   Tsr Value Index - Poor Score of 31.25
   Price to Book Ratio of 13.46 suggesting that it is very expensive
Valuation Key Ratios
Ratio TTM Latest FY Yoy Change MRQ
Price to Earning 33.29 33.78 -16.57 %
Price to Book 13.39 21.72 -17.63 % 12.64
Price to Sales 3.50 3.50 -5.20 %
Enterprise Value to EBITDA Multiple 24.14 24.57 -12.94 %


SHW - Profitability Highlights

Profitability Analysis

   Piotroski F Score - Good Value of 7.0
   Over the last 3 years, the company has achieved Incredible Return on Equity
   Company Earning excess return
   Annual Net Profit in last 3 years is trending up
   EBITDA is continuously increasing for last 3 Years
   Steady ROA in range of 8 to 12 for last 3 years
   Good Return On Capital Employed of 17.61
   Good Return on Equity of 12.62% is achieved by the company
   Good Net Margin of 10.52% is achieved by the company
   Very Low Dividend Yield of 0.890 %
   Low Earning Yield of 2.99 %
Profitability Key Ratios
Ratio TTM Latest FY Yoy Change MRQ
Return On Equity 12.62 64.29 -1.28 % 2.16
Return On Asset 10.44 10.41 16.39 % 2.16
Net Profit Margin 10.52 10.36 13.62 % 9.41
Operating Profit Margin 16.09 16.02 18.53 % 13.62
EBITDA Margin 16.09 16.02 8.14 % 13.62


Highlights
Market Cap79208.71 M
Enterprise Value89232.11 M
Price/Book TTM13.39
Outstanding Share253548 K
Float/ Outstanding Share91.85%
Dividend Yield0.910 %
Share Holding
Guru Numbers
Price/Graham No5.67
Peter Lynch Ratio0.597
Piotroski F Score7.00
Altman Z Score4.18
Sloan Ratio-0.0494
Peter Lynch Fair Value91.19


SHW - Growth Highlights

Growth Analysis

   Annual sales of the company is increased for three years in a row
   Steady increase in Total Assets for last 3 Years
Growth Key Fields
Field TTM YoY Growth QoQ Growth
Revenue 22976.80 M 4.08 % 2.19 %
Gross Profit 10868.20 M 15.37 % 0.694 %
EBITDA 3696.00 M 12.55 % 5.54 %
Net Profit 2416.60 M 18.25 % 41.83 %
EPS 9.38 19.85 % NA


SHW - Stability Highlights

Stability Analysis

   Altman Z Score of 4.19 suggests good Stability
   Tsr Stability Index - Poor Score of 32.81
   Company has high debt burden
Stability Key Ratios
Ratio Latest FY Yoy Change MRQ
Debt to Equity Ratio 2.77 -21.79 % 0.478
Cash Ratio 0.0418 25.24 %
Quick Ratio 0.480 -12.74 % 0.463
Shareholders Equity 16.19 17.90 %
Debt to EBITDA 2.79 -16.76 %


Historical Valuation Ratios of Sherwin-Williams Co

Historical Valuation Ratios
Loading ...

Historical Profitability Ratios of Sherwin-Williams Co

Historical Profitability Ratios
Loading ...

Historical Efficiency Ratios of Sherwin-Williams Co

Historical Efficiency Ratios
Loading ...

Historical Solvency Ratios of Sherwin-Williams Co

Historical Solvency Ratios
Loading ...


Note : All Data Generated at the End of Trading Hours (EOD Data)