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 Cap | 79208.71 M |
Enterprise Value | 89232.11 M |
Price/Book TTM | 13.39 |
Outstanding Share | 253548 K |
Float/ Outstanding Share | 91.85% |
Dividend Yield | 0.910 % |
Share Holding
Guru Numbers
Price/Graham No | 5.67 |
Peter Lynch Ratio | 0.597 |
Piotroski F Score | 7.00 |
Altman Z Score | 4.18 |
Sloan Ratio | -0.0494 |
Peter Lynch Fair Value | 91.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)