# How Would Ben Graham Have Analyzed Sherwin-Williams (SHW)?

Sherwin-Williams is currently trading at \$233.16 per share and has a Graham number of \$45.49, which implies that it is 412.6% above its fair value. We calculate the Graham number as follows:

√(22.5 * 5 year average earnings per share * book value per share) = √(22.5 * 6.27 * 14.184) = 45.49

The Graham number is one of seven factors that Graham enumerates in Chapter 14 of The Intelligent Investor for determining whether a stock offers a margin of safety. Rather than use the Graham number by itself, its best to consider it alongside the following fundamental metrics:

Sales Revenue Should Be No Less Than \$500 million

For Sherwin-Williams, average sales revenue over the last 6 years has been \$25.9 Billion, so in the context of the Graham analysis the stock has impressive sales revenue. Originally the threshold was \$100 million, but since the book was published in the 1970s it's necessary to adjust the figure for inflation.

Current Assets Should Be at Least Twice Current Liabilities

We calculate Sherwin-Williams's current ratio by dividing its total current assets of \$5.91 Billion by its total current liabilities of \$5.96 Billion. Current assets refer to company assets that can be transferred into cash within one year, such as accounts receivable, inventory, and liquid financial instruments. Current liabilities, on the other hand, refer to those that will come due within one year. Sherwin-Williams’s current liabilities are actually greater than its current assets, since its current ratio is only 1.0.

The Company’s Long-term Debt Should Not Exceed its Net Current Assets

This means that its ratio of debt to net current assets should be 1 or less. Since Sherwin-Williams’s debt ratio is -0.7, the company has much more liabilities than current assets. We calculate Sherwin-Williams’s debt to net current assets ratio by dividing its total long term of debt of \$9.59 Billion by its current assets minus total liabilities of \$19.49 Billion.

The Stock Should Have a Positive Level of Retained Earnings Over Several Years

Sherwin-Williams had positive retained earnings from 2007 to 2022 with an average of \$3.54 Billion. Retained earnings are the sum of the current and previous reporting periods' net asset amounts, minus all dividend payments. It's a similar metric to free cash flow, with the difference that retained earnings are accounted for on an accrual basis.

There Should Be a Record of Uninterrupted Dividend Payments Over the Last 20 Years

Shareholders of Sherwin-Williams have received regular dividends since 2007. The company has returned an average dividend yield of 0.8% over the last five years.

A Minimum Increase of at Least One-third in Earnings per Share (EPS) Over the Past 10 Years

Sherwin-Williams's earnings per share growth will be calculated using the average EPS of the years 2007, 2008, and 2009, and the average of the years 2020, 2021, and 2022. For the years starting in 2007, we have EPS values of \$4.70, \$4.00, and \$0.58, which give us an average of \$3.09. From 2020 to the present, we have EPS values of \$1.49, \$1.15, and \$7.72, which average out to \$3.45. The growth rate between the two averages is 11.65%, which falls short of Graham's 30% requirement while remaining positive.

It may be trading far above its fair value, but Sherwin-Williams actually does not have the profile of a defensive stock according to Benjamin Graham's criteria because it has:

• impressive sales revenue
• not enough current assets to cover current liabilities
• much more liabilities than current assets
• positive retained earnings from 2007 to 2022
• an acceptable record of dividends
• some EPS growth
The above analysis is intended for educational purposes only and was performed on the basis of publicly available data. It is not to be construed as a recommendation to buy or sell any security. Any buy, sell, or other recommendations mentioned in the article are direct quotations of consensus recommendations from the analysts covering the stock, and do not represent the opinions of Market Inference or its writers. Past performance, accounting data, and inferences about market position and corporate valuation are not reliable indicators of future price movements. Market Inference does not provide financial advice. Investors should conduct their own review and analysis of any company of interest before making an investment decision.