IT Hardware Stocks

Agilent Technologies Inc. Quarterly Valuation – April 2015 $A

500px-Agilent.svgAgilent Technologies (NYSE:A) may initially attract many value investors due to the significant drop in price in the last year. However, Benjamin Graham, the father of value investing, taught that looking at the price cannot be the sole factor in investment decisions, as the most important aspect to consider is whether the company is trading at a discount relative to its intrinsic value. It is through a thorough fundamental analysis that the investor is able to make a determination about a potential investment’s merits. Here is an updated look at how the company fares in the ModernGraham valuation model.

The model is inspired by the teachings of Benjamin Graham, and considers numerous metrics intended to help the investor reduce risk levels. The first part of the analysis is to determine whether the company is suitable for the very conservative Defensive Investor, or the less conservative Enterprising Investor who is willing to spend a greater amount of time conducting further research.

In addition, Graham strongly suggested that investors avoid speculation in order to remove the subjective elements of emotion. This is best achieved by utilizing a systematic approach to analysis that will provide investors with a sense of how a specific company compares to another. By using theModernGraham method, one can review a company’s historical accomplishments and determine an intrinsic value that can be compared across industries.

A Chart

[level-free]
To read the rest of this valuation, you must be logged in as a premium member. If you are not a premium member, please consider becoming one.
[/level-free]
[level-mg-stocks-screens-subscriber]

Defensive Investor – Must pass at least 6 of the following 7 tests: Score = 2/7

  1. Adequate Size of Enterprise – Market capitalization of at least $2 billion – PASS
  2. Sufficiently Strong Financial Condition – Current ratio greater than 2 – PASS
  3. Earnings Stability – Positive earnings per share for at least 10 straight years – FAIL
  4. Dividend Record – Has paid a dividend for at least 10 straight years – FAIL
  5. Earnings Growth – Earnings per share has increased by at least one-third over the last 10 years, using three-year averages at the beginning and end of the period – FAIL
  6. Moderate PEmg (price over normalized earnings) ratio – PEmg is less than 20 – FAIL
  7. Moderate Price-to-Assets – PB ratio is less than 2.5 or PB x PEmg is less than 50 – FAIL

Enterprising Investor – Must pass at least 4 of the following 5 tests, or be suitable for a Defensive Investor: Score = 5/5

  1. Sufficiently Strong Financial Condition, Part 1 – Current ratio greater than 1.5 – PASS
  2. Sufficiently Strong Financial Condition, Part 2 – Debt-to-Net Current Assets ratio less than 1.1 – PASS
  3. Earnings Stability – Positive earnings per share for at least 5 years – PASS
  4. Dividend Record – Currently pays a dividend – PASS
  5. Earnings Growth – EPSmg greater than 5 years ago – PASS

Valuation Summary

Key Data

Recent Price $42.05
MG Value $23.39
MG Opinion Overvalued
Value Based on 3% Growth $28.95
Value Based on 0% Growth $16.97
Market Implied Growth Rate 6.28%
Net Current Asset Value (NCAV) $1.10
PEmg 21.06
Current Ratio 3.94
PB Ratio 3.35


Balance Sheet – January 2015

Current Assets $3,654,000,000
Current Liabilities $928,000,000
Total Debt $1,658,000,000
Total Assets $7,519,000,000
Intangible Assets $2,911,000,000
Total Liabilities $3,282,000,000
Outstanding Shares 338,000,000


Earnings Per Share

2015 (estimate) $1.66
2014 $1.49
2013 $2.10
2012 $3.27
2011 $2.85
2010 $1.94
2009 -$0.09
2008 $1.87
2007 $1.57
2006 $7.50
2005 $0.65


Earnings Per Share – ModernGraham

2015 (estimate) $2.00
2014 $2.22
2013 $2.39
2012 $2.35
2011 $1.80
2010 $1.71


Dividend History

A Dividend Chart

Conclusion

Agilent Technologies is suitable for the Enterprising Investor, but not for the more conservative Defensive Investor, who is concerned about the insufficient earnings growth or stability over the last ten years, the short dividend history, and the high PEmg and PB ratios. The Enterprising Investor, on the other hand, has no initial concerns as the company passes all of the investor type’s requirements. As a result, all Enterprising Investors should feel very comfortable proceeding to the next part of the analysis, which is a determination of the company’s intrinsic value.

When it comes to valuation, it is critical to consider the company’s earnings history. In this case, Agilent Technologies has grown its EPSmg (normalized earnings) from $1.80 in 2011 to only an estimated $2.00 for 2015. This lack of demonstrated growth does not support the market’s implied estimate for earnings growth of 6.28% over the next 7-10 years. Therefore, the model returns an estimate of intrinsic value falling below the current price, indicating the company is overvalued at the present time.

[/level-mg-stocks-screens-subscriber]

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top