ModernGraham Quarterly Valuation Of Cisco Systems, Inc.

| About: Cisco Systems, (CSCO)

The tech industry can sometimes be difficult to analyze and compare to other industries, with the result often leading to speculation about where a company will go in the future. One of the greatest lessons from Benjamin Graham is to avoid speculating by basing your analysis on factual data. The tech industry is one of the areas where this lesson should be remembered most dearly. Intelligent Investors seeking to follow Graham's methods should use an analytical method that can be utilized across industries in order to allow the comparison of opportunities for profit. The ModernGraham analysis is intended to compile information in order to compare an investment opportunity against another, and what follows is a specific look at how Cisco Systems, Inc. fares in the ModernGraham valuation model.

CSCO Chart

CSCO data by YCharts

Defensive Investor - must pass at least 6 of the following 7 tests: Score = 6/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 - PASS
  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 1/3 over the last 10 years using 3 year averages at beginning and end of period - PASS
  6. Moderate PEmg ratio - PEmg is less than 20 - PASS
  7. Moderate Price to Assets - PB ratio is less than 2.5 or PB x PEmg is less than 50 - PASS

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:

MG Value $31.26
MG Opinion Undervalued
Value Based on 3% Growth $23.62
Value Based on 0% Growth $13.84
Market Implied Growth Rate 2.46%
Net Current Asset Value (NCAV) $3.92
PEmg 13.43
Current Ratio 2.89
PB Ratio 1.99

Balance Sheet - 10/31/2013

Current Assets $62,796,000,000
Current Liabilities $21,728,000,000
Total Debt $12,947,000,000
Total Assets $100,741,000,000
Intangible Assets $27,639,000,000
Total Liabilities $41,844,000,000
Outstanding Shares 5,351,000,000

Earnings Per Share

2014 (estimate) $1.77
2013 $1.86
2012 $1.49
2011 $1.17
2010 $1.33
2009 $1.05
2008 $1.31
2007 $1.17
2006 $0.89
2005 $0.87
2004 $0.70
2002 $0.25

Earnings Per Share - ModernGraham

2014 (estimate) $1.63
2013 $1.50
2012 $1.30
2011 $1.21
2010 $1.20
2009 $1.11

Dividend History

CSCO Dividend Chart

CSCO Dividend data by YCharts


Cisco Systems, Inc. looks very good for both the Defensive Investor and the Enterprising Investor, and has even improved upon the state we found the company in when it was last reviewed in November 2013. The company passes all of the requirements of the Defensive Investor except for the dividend history, as the company only recently began paying a dividend. In addition, all five of the requirements of the Enterprising Investor are satisfied. As a result, value investors following the ModernGraham approach should feel comfortable proceeding with further research to determine whether Cisco is right for their individual portfolio. One recommended research technique would be to compare Cisco to competitors such as by reviewing the ModernGraham valuation of Microsoft (NASDAQ:MSFT) and the ModernGraham valuation of Hewlett-Packard Co. (NYSE:HPQ).

From a valuation perspective, the company has grown EPSmg (normalized earnings) from $1.11 in 2009 to an estimated $1.63 for 2013. This level of growth is very solid, and outpaces the market's implied growth rate of 2.46%. The ModernGraham valuation model returns an intrinsic value that surpasses the market's price, demonstrating that the company seems to be undervalued at the present time.

The next part of the analysis is up to individual investors, and requires discussion of the company's prospects. What do you think? What value would you put on Cisco Systems, Inc.? Where do you see the company going in the future? Is there a company you like better?

Disclosure: The author did not hold a position in Cisco Systems, Inc. (NASDAQ:CSCO) or any of the other companies listed in this article at the time of publication and had no intention of changing that position within the next 72 hours.