A

Discovering Value – Agilent Technologies (A) Offers a Secure Investment Opportunity

Many investors turn to Benjamin Graham's so-called “Graham number” to calculate the fair price of a stock. The Graham number is √(22.5 * 5 year average earnings per share * book value per share), which for Agilent Technologies gives us a fair price of $43.15. In comparison, the stock’s market price is $132.97 per share. Agilent Technologies’s current market price is 208.2% above its Graham number, which implies that there is upside potential -- even for a conservative investors who require a significant margin of safety.

The Graham number is often used in isolation, but in fact it is only one part of a check list for choosing defensive stocks that he laid out in Chapter 14 of The Intelligent Investor. The analysis requires us to look at the following fundamentals of Agilent Technologies:

Sales Revenue Should Be No Less Than $500 million

For Agilent Technologies, average sales revenue over the last 5 years has been $11.02 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 Agilent Technologies's current ratio by dividing its total current assets of $4.19 Billion by its total current liabilities of $1.6 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. In Agilent Technologies’s case, current assets outweigh current liabilities by a factor of 2.6.

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 Agilent Technologies’s debt ratio is -3.7, the company has much more liabilities than current assets because its long term debt to net current asset ratio is -3.7. We calculate Agilent Technologies’s debt to net current assets ratio by dividing its total long term of debt of $2.74 Billion by its current assets minus total liabilities of $4.92 Billion.

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

Agilent Technologies had good record of retained earnings with an average of $2.77 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

Agilent Technologies has offered a regular dividend since at least 2012. The company has returned an average dividend yield of 0.7% over the last five years.

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

To determine Agilent Technologies's EPS growth over time, we will average out its EPS for 2007, 2008, and 2009, which were $1.57, $1.87, and $-0.09 respectively. This gives us an average of $1.12 for the period of 2007 to 2009. Next, we compare this value with the average EPS reported in 2021, 2022, and 2023, which were $3.94, $4.18, and $4.19, for an average of $4.10. Now we see that Agilent Technologies's EPS growth was 266.07% during this period, which satisfies Ben Graham's requirement.

Based on the above analysis, we can conclude that Agilent Technologies meets most of Benjamin Graham's criteria for an undervalued stock because it is trading above its fair value and has:

  • impressive sales revenue
  • an excellent current ratio of 2.61
  • much more liabilities than current assets because its long term debt to net current asset ratio is -3.7
  • good record of retained earnings
  • a solid record of dividends
  • exceptional 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.

IN FOCUS