Edited by Adam Isaac
Cisco Systems (NASDAQ:CSCO) is one of the largest networking companies in the world. The company designs, manufactures and sells internet protocol-based networking and other products related to the communications and information technology industry worldwide. Cisco also offers routers that interconnect public and private IP networks for mobile, data, voice, and video applications. In my previous article, I analyzed the funds from operations [FFO], operating cash flows and free cash flows of Cisco. In addition, I also analyzed essential ratios involving FFO, capital spending requirements and debt service coverage.
In this article, I have tried to analyze the composition of components through common size analysis. Common size analysis helps us understand the change in the composition of the components in the statement of operations. This analysis is performed by dividing each component of income statement with total revenue. This analysis is ideal to determine the earnings sustainability. In addition, common size analysis also evaluates the quality of earnings. For any business, it is ideal to have more of its earnings in cash and less in accruals.
Common Size Analysis:
Total Net Sales
Cost of Sales
Total cost of sales
Research and Development
Sales and Marketing
General and administrative
Restructuring and other charges
Total Operating Expenses
other income, net
Interest and other Income, net
Income before provision for taxes
Provision for Income taxes
Source: SEC filings.
For my analysis, I used the data from three most recent annual reports of the company. The first thing I noticed in the revenue decomposition is the trend in business segments. The contribution from product sales is decreasing, whereas the weight of services segment is moving upward. In the previous three years, the products segment has decreased by 2%. I think that indicates a change in company's primary focus to services segment.
However, cost of sales component gives mixed results; products related cost of sales have been fluctuating. An increase was followed by a decrease and this ratio currently stands at 31.49%, while the cost of sales for services component has been steadily increasing. Overall, cost of sales for Cisco keeps going up and now stands at close to 39% of revenues. Thus, the gross margin has come down to 61%. Over the past three years, research and development expenses have also decreased and now stand at just over 11%.
Total operating expenses have been fluctuating between 39% and 44% of sales, and the operating margin currently stands at 21.85%. However, the current operating margin showed a decline of 1.04% from the levels of 2010. Furthermore, the interest expense has also showed a declining trend and now stands at 1.29% of total revenues. Net profit margin has followed operating margin and shows a mixed trend. At the moment, net profit margin is 17.46% for Cisco, which is 1.94% less than the level of 2010. During the past two years, Cisco also absorbed over $1 billion in restructuring expenses.
Balance Sheet accruals
Net Operating Assets
Cash Flow Based
CFO( Operating Cash flow)
CFI( Investing Cash Flow)
Source: SEC Filings.
In order to measure the earnings quality of Cisco, I have used balance sheet and cash flow accruals ratios. For the balance sheet accruals ratio, beginning net operating assets are subtracted from the year end net operating assets and divided by average net assets. Net operating assets are calculated by subtracting operating liabilities (total liabilities - total debt, including short term debt) from operating assets (total assets - cash, cash equivalents and marketable securities).
In accruals analysis, cash component is separated from the accruals component of earnings, and a lower accruals ratio indicates higher quality earnings. The performed accruals analysis suggests intriguing results as the current balance sheet ratio is negative. In addition, both of the ratios were negative in 2011. It is not unusual to have negative accruals ratios, but no business can sustain negative accrual ratios as it implies that the firm is generating more cash than its accounting earnings.
Looking at the balance sheet of Cisco, it is clear that the cash and cash equivalents have increased by more than $4.5 billion from the year end balances of 2011. That is a very good sign for the dividend safety. Cisco has enough cash to cover its dividend for the next 10 years at least.
The cash flow ratio is in the positive territory and currently stands at 1.90%. A closer look at the cash flow statement indicates that there has not been much capital expenditure by the company in the past two years. In addition, cash and cash equivalents have increased enormously during the past three years and currently stand at $9.7 billion; cash and cash equivalents stood at just above $4.5 billion at the end of 2010.
The above analysis suggests Cisco is a strong cash generating machine. In fact it is generating significantly higher cash than the reported earnings. Moreover, the firm has strong asset base and impressive operations. Cisco is in a strong financial position, and the firm should not have any trouble in paying its debt and interest obligations. Along with a steady progress in its revenue, the firm has also shown impressive growth in its EPS and current EPS stands at $1.50.
Compared its closest competitor, Juniper (NYSE:JNPR), Cisco stock is trading at a deep discount. Cisco's trailing P/E is only 13, whereas Juniper has a trailing P/E of 40. Cisco is an established giant which has been given a new direction by its management, and I expect the company to carry on its impressive revenue and earnings growth backed by its strong balance sheet. Analysts also agree with me. The forward P/E ratio of 9.33 indicates almost 40% increase in expected earnings for the next year.