What Else Should Value Investors Consider Besides Comcast (CMCSA)'s Graham Number

Comcast does not have the profile of a defensive investment based on the requirements of Ben Graham. The Cable Television firm may nonetheless be of interest to more risk-oriented investors who have a solid thesis on the company's future growth. At Market Inference, we remain agnostic as to such further developments, and prefer to use a company's past track record as the bellwether for future potential gains.

Comcast Is Probably Overvalued

Graham devised the below equation to give investors a quick way of determining whether a stock is trading at a fair multiple of its earnings and its assets:

√(22.5 * 6 year average earnings per share (2.76) * 6 year average book value per share (20.357) = $21.36

After an impressive 53.0% performance over the 12 months, Comcast is now trading well over its price because its Graham number is 107.4% above today's share price of $44.3. Even though the stock does not trade at an attractive multiple, it might still meet some of the other criteria for quality stocks that Graham listed in Chapter 14 of The Intelligent Investor.

Impressive Revenues, Consistent Profitability, and a Growing Dividend Imply Value

Comcast’s average sales revenue over the last 6 years has been $153.09 Billion, so by Graham’s standards the stock has sufficient revenues to make it worthy of investment. When published in 1972, Graham’s threshold was $100 million in average sales, which would be the equivalent of around a half million dollars today.

Ben Graham believed that a margin of safety could be obtained by investing only in companies with consistently positive retained earnings. Retained earnings represent the cumulative net earnings or (deficit) left to equity holders after dividends have been paid out. Comcast had positive retained earnings from 2008 to 2022 with an average of $29.73 Billion over this period.

Ben Graham would also require a cumulative growth of Earnings Per Share of at least 30% over the last ten years.To determine Comcast's EPS growth over time, we will average out its EPS for 2007, 2008, and 2009, which were $0.83, $0.86, and $0.33 respectively. This gives us an average of $0.67 for the period of 2007 to 2009. Next, we compare this value with the average EPS reported in 2020, 2021, and 2022, which were $2.28, $3.04, and $1.21, for an average of $2.18. Now we see that Comcast's EPS growth was 225.37% during this period, which satisfies Ben Graham's requirement.

Negative Current Asset to Liabilities Balance and Not Enough Current Assets to Cover Current Liabilities

Graham sought companies with extremely low debt levels compared to their assets. For one, he expected their current ratio to be over 2 and their long term debt to net current asset ratio to be near, or ideally under, under 1. Comcast fails on both counts with a current ratio of 0.8 and a debt to net current asset ratio of -0.6.

Conclusion

According to Graham's analysis, Comcast is likely a company of average quality, which does not offer a significant enough margin of safety for a risk averse investor.

2018-01-31 2019-01-31 2020-01-30 2021-02-04 2022-02-02 2023-02-03
Revenue (MM) $85,029 $94,507 $108,942 $103,564 $116,385 $121,427
Gross Margins 70.0% 69.0% 68.0% 68.0% 67.0% 69.0%
Operating Margins 21% 20% 19% 17% 18% 19%
Net Margins 27.0% 12.0% 12.0% 10.0% 12.0% 4.0%
Net Income (MM) $22,735 $11,731 $13,057 $10,534 $14,159 $5,370
Net Interest Expense (MM) -$3,086 -$3,542 -$4,567 -$4,588 -$4,281 -$3,896
Depreciation & Amort. (MM) -$9,688 -$10,676 -$12,953 -$13,100 -$13,804 -$13,821
Earnings Per Share $4.75 $2.53 $2.83 $2.28 $3.04 $1.15
EPS Growth n/a -46.74% 11.86% -19.43% 33.33% -62.17%
Diluted Shares (MM) 4,786 4,640 4,610 4,624 4,665 4,654
Free Cash Flow (MM) $32,834 $36,006 $38,125 $36,371 $41,204 $40,180
Capital Expenditures (MM) -$11,573 -$11,709 -$12,428 -$11,634 -$12,057 -$13,767
Net Current Assets (MM) -$100,303 -$156,018 -$152,776 -$154,110 -$153,090 -$153,409
Long Term Debt (MM) $59,422 $107,345 $102,931 $105,782 $97,888 $98,240
Net Debt / EBITDA 2.21 3.64 2.99 3.18 2.64 2.61
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.

IN FOCUS