This "look-ahead" post discusses how I came up with an estimate for Cisco's earnings for fiscal year 2021's second quarter, which ended on January 23, 2021, by predicting each element of its Income Statement, from top-line Revenue to bottom-line Earnings Per Share (EPS) and everything in between.
Once the company’s official results become available on February 9, 2021, I will compare the published Income Statement to the prediction and identify any surprises, positive or negative. Examining these differences can identify what factors (e.g., profit margins, non-GAAP expenses, tax rates, share buybacks) are driving changes to a company's financial performance.
But, before getting into the details, let's take a step back and start with background information about Cisco Systems.
Founded in 1984, Cisco is a leading seller of products, such as routers and switches, and related services, for connecting devices via the Internet. The company makes products related to the following technologies: software-defined wide area networks, cloud computing, 5G and WiFi-6, optical networking, next generation silicon, and artificial intelligence. A frequent acquirer of other companies, Cisco expects it will soon complete the $4.5 billion acquisition of Acacia Communications, Inc., a company that sells high-speed coherent optical interconnect products.
Shares of Cisco now trade for about $48 each, giving the company a market value of $200 billion. These shares can be found in the Dow Jones Industrial Average, Standard and Poors 500, Standard and Poors 100, NASDAQ 100, and Russell 1000 stock indices.
Cisco recorded profits of $10 billion on revenue of $48 billion during the last year. In the quarter that ended on October 24, 2020, Cisco earned $0.76 per share (excluding certain items), which beat the $0.70 Wall Street consensus forecast.
Revenue in the October 2020 quarter totaled $11.9 billion, 9 percent less than last year. The Infrastructure Platforms business was responsible for 53 percent of overall revenue, and this unit's revenue percent fell by 16.0 percent compared to the year-earlier result. The Applications business contributed 12 percent of revenue, and this unit's revenue decreased by 8.0 percent. The Services unit supplied 28 percent of revenue, and this business's revenue rose by 2.0 percent.
My starting point, if available, when estimating earnings is guidance provided by the company's management to financial analysts. It's true that the company may downplay expectations somewhat to avoid disappointments, but the top managers ought to know better than anyone else how well their products and services are selling. I also look for other information about the company in the news, and I take advantage of trends in the company's historical results. While it makes my task a little more difficult, I also try to estimate earnings that conform to Generally Accepted Accounting Principles (GAAP). Non-GAAP results, which most professionals focus on, are somewhat arbitrary and often exclude meaningful items.
When Cisco reported its results for the October 2020 quarter, it also provided the following guidance the January 2021 period:
Guidance for Q2 FY 2021
Cisco expects to achieve the following results for the second quarter of fiscal 2021:
Q2 FY 2021
Revenue
0% - (2)% decline Y/Y Non-GAAP gross margin rate
64% - 65% Non-GAAP operating margin rate
32% - 33% Non-GAAP tax provision rate
19% Non-GAAP EPS
$0.74 - $0.76 Cisco estimates that GAAP EPS will be $0.55 to $0.60 in the second quarter of fiscal 2021.
Cisco reported Revenue of $12.0 billion in the quarter that ended January 25, 2020 (i.e., one year ago). Assuming a minus-2 to 0 percent change, per the guidance, leads to a Revenue estimate for the January 2021 quarter between $11.75 billion and $12.0 billion. I made $11.9 billion, just over the midpoint of this range, as my estimate.
For the Gross Margin, Cisco indicated that this ratio would be, on a GAAP basis, between 62 and 63 percent. Using the 62.5 percent midpoint, the estimate for the Cost of Goods Sold = 37.5 percent of Revenue, or 0.375 * $11.9 billion = $4.5 billion
The Operating Margin listed in the guidance refers to operating income as a percentage of revenue. A 25-percent GAAP margin with the $11.9 billion revenue estimate indicates that operating income should be about 0.25 * $11.9 billion = $3.0 billion and that operating costs would, therefore, total $11.9 billion - $3.0 billion = $8.9 billion. This latter figure includes the Cost of Goods Sold, estimated at $4.5 billion, so there would be $8.9 billion - $4.5 billion = $4.4 billion to cover Research and Development (R&D), Sales, General, and Administrative (SG&A), and other operating expenses. I've allocated this amount as $1.6 billion for R&D, $2.6 billion for SG&A, and $200 million for other.
For non-operating items, I've assumed a $20 million gain and $60 million net interest income.
The guidance indicates that an effective income tax rate of 19 percent is expected.
With these assumptions, my estimate for Net Income is $2.5 billion ($0.60 per share), which is at top end of the guidance range.
The following Income Statement summarizes the estimates made as discussed above.
This post is not investment advice, and the accuracy of the information, tables, charts, and any commentary presented is not guaranteed. Readers are encouraged to independently verify all data using information from original sources. The Income Statements discussed in these blog posts have not been audited and may differ in material respects from those published by the subject company. These differences are intended to facilitate analysis and cross-company comparisons. Complete financial statements with notes can usually be found in the 10-Q and 10-K filings companies submit to the Securities and Exchange Commission (SEC).
#cisco #csco #gauges #gcfr #gcfr2 #lookahead #nac_financialanalysis