Agilent Technologies does not have the profile of a defensive investment based on the requirements of Ben Graham. The Electrical Equipment & Parts 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.
Agilent Technologies 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.79) * 6 year average book value per share (18.986) = $39.83
At today's price of $113.52 per share, Agilent Technologies is now trading 185.0% above the maximum price that Graham would have wanted to pay for the stock.
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.
Negative Retained Earnings In 2017 And 2018, A Solid Record Of Dividends, and Eps Growth In Excess Of Graham'S Requirements
Ben Graham wrote that an investment in a company with a record of positive retained earnings could contribute significantly to the margin of safety. However, Agilent Technologies had negative retained earnings in 2017 and 2018 with an average of $2.9 Billion over this period.
Another one of Graham's requirements is for a 30% or more cumulative growth rate of the company's earnings per share over the last ten 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 2020, 2021, and 2022, which were $2.30, $3.94, and $4.18, for an average of $3.47. Now we see that Agilent Technologies's EPS growth was 209.82% during this period, which satisfies Ben Graham's requirement.
Shareholders of Agilent Technologies have received regular dividends since 2012. The company has returned an average dividend yield of 0.7% over the last five years.
Negative Current Asset to Liabilities Balance and a Decent Current Ratio
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. Agilent Technologies fails on both counts with a current ratio of 2.0 and a debt to net current asset ratio of -1.9.
Conclusion
According to Graham's analysis, Agilent Technologies is likely a company of average quality, which does not offer a significant enough margin of safety for a risk averse investor.
| 2017-12-21 | 2018-12-20 | 2019-12-19 | 2020-12-18 | 2021-12-17 | 2022-12-21 | |
|---|---|---|---|---|---|---|
| Revenue (MM) | $4,472 | $4,914 | $5,163 | $5,339 | $6,319 | $6,848 |
| Gross Margins | 54.0% | 55.0% | 54.0% | 53.0% | 54.0% | 54.0% |
| Operating Margins | 19% | 18% | 18% | 16% | 21% | 24% |
| Net Margins | 15.0% | 6.0% | 21.0% | 13.0% | 19.0% | 18.0% |
| Net Income (MM) | $684 | $316 | $1,071 | $719 | $1,210 | $1,254 |
| Net Interest Expense (MM) | -$57 | -$37 | -$38 | -$70 | -$79 | -$75 |
| Depreciation & Amort. (MM) | -$212 | -$210 | -$238 | -$308 | -$321 | -$317 |
| Earnings Per Share | $2.1 | $0.97 | $3.37 | $2.3 | $3.94 | $4.08 |
| EPS Growth | n/a | -53.81% | 247.42% | -31.75% | 71.3% | 3.55% |
| Diluted Shares (MM) | 326 | 325 | 318 | 312 | 307 | 307 |
| Free Cash Flow (MM) | $1,065 | $1,263 | $1,176 | $1,039 | $1,672 | $1,603 |
| Capital Expenditures (MM) | -$176 | -$176 | -$155 | -$118 | -$187 | -$291 |
| Net Current Assets (MM) | $578 | -$122 | -$1,515 | -$1,339 | -$1,517 | -$1,449 |
| Long Term Debt (MM) | $1,801 | $1,799 | $1,791 | $2,284 | $2,729 | $2,733 |
| Net Debt / EBITDA | -0.63 | -0.4 | 0.87 | 0.8 | 0.69 | 0.89 |
