EIX: Look Ahead to December Quarterly Results

 This "look-ahead" post discusses how I came up with an estimate for Edison International's earnings for fiscal year 2020's fourth quarter, which ended on December 31, 2020, 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 later this month, 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 Edison International.

Edison International is the parent of Southern California Edison, which provides electric power to more than 15 million people.  Per government mandates, a growing percentage of this power has been derived from renewable sources. Electric utilities in California have been blamed for, and are spending considerable sums to prevent, wildfires caused by their equipment.

Shares of Edison now trade for about $58 each, giving the company a market value of $22 billion. These shares can be found in the Dow Jones Utilities Average, Standard and Poors 500, New York Stock Exchange Composite, and Russell 1000 stock indices.

Edison recorded profits of $356 million on revenue of $13 billion during the last year. In the quarter that ended on September 30, 2020, Edison earned $1.67 per share (excluding certain items), which matched the $1.67 Wall Street consensus forecast. See https://tinyurl.com/y4jdllsu for Edison's most recent quarterly report.

Revenue in the September 2020 quarter totaled $4.6 billion, 24 percent more than last year.

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.

Edison International updated its guidance for the entire fiscal year when it reported third-quarter results in last October. 

The columns above with guidance from last September can be ignored because the October guidance superseded any estimates issued earlier.  "Non-core Items" are  the difference between Basic (i.e., GAAP) and Core (i.e., Non-GAAP) earnings.  The $2.74 per share estimate for Non-core Items is almost the same as the actual Non-core amount during the first three quarters of 2020.  This suggests that Non-core amount in the fourth quarter will be minimal; in other words, the difference between Basic and Core EPS should be fairly small.

During the first three quarters of 2020, Edison's Core EPS was $0.57.  The company's Basic EPS guidance for the fourth quarter is, therefore, $1.73 minus $0.57 = $1.16 to $1.88 minus $0.57 = $1.31.

To estimate Revenue for the December quarter, I looked into Edison's historical financial data and found that roughly 24 percent of the company's annual Revenue gets recorded in the fourth quarter of a typical year.  The percentage can vary from year, sometimes significantly, but I consider it a reasonable basis for an estimate.  Since Revenue was $10.42 billion during the first three quarters of 2020, my estimate for the fourth quarter is $3.3 billion.

In the December quarters of 2016, 2017, 2018, and 2019, the Gross Margin averaged 37.2 percent of Revenue.  I'm assuming the figure will be similar in the fiscal year 2020.  The estimated Cost of Goods Sold is (1-0.372)* $3.3 billion = $2.1 billion 

Edison's depreciation expense was between $480 and $490 per quarter during the first nine months of 2020.  I assumed $485 million for the fourth quarter.

Miscellaneous operating expenses were over $1.3 billion in the third quarter because this period included non-core charges related to previous wildfire and mudslide events.  Since the guidance implied that non-core charges would be minimal in the fourth quarter (see above), I used only the token figure of $50 million for this line on the Income Statement.

The numbers above combine to produce an estimate for Operating Income in December quarter of about $690 million, which is more than double the equivalent quantity in the year-earlier quarter.

For the two non-operating items, I used figures from the September quarter..

Edison's effective income tax rate has been both absurdly high and absurdly low during recent quarters. In the first three quarters of the year, the company reported a tax credit of $355 million on pre-tax loss of $36 million.  I simply assumed a 10 percent tax rate, which (strangely enough) seems conservative.

After a $45 million deduction for preferred stock dividend payments, my estimate for Edison International's Net Income in the December 2020 quarter works out to be $454 million ($1.20 per share).

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).

#edison  #eix  #gauges #gcfr  #gcfr2 #lookahead #nac_financialanalysis

CSCO: Earnings Report for the Quarter Ending January 23, 2021

Cisco Systems reported after the market closed on February 9, 2021, it earned $0.60 per diluted share in the quarter that ended on January 23, 2021, down 12 percent from earnings of $0.68 in the equivalent 13 weeks of the previous year. These figures are the earnings determined in accordance with U.S. Generally Accepted Accounting Principles (GAAP). 

Non-GAAP earnings rose 3 percent to $0.79 per share from $0.77 one year earlier, a much better change than the GAAP percentage. The most significant exclusions contributing to the $0.19 per share difference in the latest quarter between the GAAP and Non-GAAP earnings were: Stock-based compensation [$0.10 per share], Acquisition-related expenses [$0.06 per share], and Asset impairments and restructurings [$0.06 per share].  Non-GAAP earnings, by excluding unusual and non-cash items that could obscure the results of a business's primary, ongoing operations, are intended to be cleaner measures of corporate profits.

This post compares the quarterly Income Statement published by Cisco to the estimates I made in a previous “Look Ahead” post.  My estimates were based on publicly available guidance provided by Cisco's management to financial analysts, news reports, and trends in the company's historical results.  Unless otherwise mentioned, all reported values mentioned below are GAAP figures.

First, a little background about the company:  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.

The following table is a simplified version of Cisco's Income Statement for the quarter that ended in January 2021, with company-reported numbers along side my predictions.  Figures from the year-earlier quarter are also provided to facilitate comparisons.

Revenue in the January 2021 quarter totaled $12.0 billion, about the same as last year.  The Infrastructure Platforms business was responsible for 53 percent of overall revenue, and this unit's revenue percent fell by 3.0 percent compared to the year-earlier result.  The Applications business contributed 11 percent of revenue, and this unit's revenue was essentially unchanged percent.  The Services unit supplied 28 percent of revenue, and this business's revenue rose by 2.0 percent.

I was expecting Cisco to report revenue of $11.9 billion for the January 2021 quarter.  The actual amount surpassed my estimate by $60.0 million (0.5 percent).

The Cost of Revenue (also known as Cost of Goods Sold) was $4.2 billion in the latest quarter, which translates into a Gross Margin of 65.1 percent of revenue. Since it was higher than the 64.7 percent Gross Margin achieved in the year-earlier quarter, it signifies that Cisco sold its products and services at more profitable prices relative to production costs. I was expecting the Gross Margin to be 62.5 percent in the January 2021 quarter, and Cisco exceeded that prediction by 2.6 percent.

Cisco spent $1.5 billion on Research and Development in the latest quarter, down from $1.6 billion one year ago. I had estimated that R&D expenses would be $1.6 billion.  R&D was 12.8 percent of Revenue.

Sales, General, and Administrative expenses totaled $2.8 billion in the January 2021 quarter, up 1.0 percent from one year ago.  SG&A expenses increased from 22.8 percent to 23.1 percent of quarterly revenue, which shows Cisco spent more per dollar of sales on indirect operational costs, such as marketing. I had estimated that SG&A expenses would be 21.8 percent of revenue, and the actual percentage turned out to be higher than the prediction.

The last operating expense line on the Income Statement is where the sum of other operating income and charges, such as restructuring, may be listed.  For Cisco the amount listed on this line was a $273 million loss in the latest quarter.  I was expecting a net loss of $200 million.

Cisco's Operating Income was $3.2 billion in the quarter, down 4.6 percent from the year-earlier period.  Operating Income exceeded my $3.0 billion estimate by $185 million.

Interest and other non-operating items summed to a net income of $32 million.  My estimate for non-operating items was $80 million.

The effective income tax rate rose by 3.3 percent to 21.8 percent, which had a negative effect on net income.  I expected the tax rate to be 19.0 percent.

Net income attributable to Cisco was $2.5 billion, $0.60 per share in the quarter ending January 2021.  The figures for the year-earlier quarter were $2.9 billion, $0.68/share. My earnings estimate for  the latest quarter was $2.5 billion ($0.60/share), so Cisco Systems earned the $0.60 I had predicted.

In conclusion, the following list shows where the reported results differed from my expectations:

      – Better than expected:  Gross Margin 

      – Worse than expected:  SG&A + SG&A/Revenue + Special operating items + Misc non-operating items + Interest + Income tax rate 

      – Near expectations:  Revenue growth + R&D 

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 #QtrlyRpt   #nac_financialanalysis

WMT: Look Ahead to January 2021 Quarterly Results

This "look-ahead" post discusses how I came up with an estimate for Walmart's earnings for fiscal year 2021's fourth quarter, which ended on January 31, 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 18, 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 Walmart.

Walmart is large retailer known for keeping its costs and prices low.  In addition to its many eponymous storers, Walmart also owns Sam's Club warehouses.  To fight off competition from Amazon and other online retailers, Walmart has invested significant sums to improve Walmart.com.  This strategy is starting to pay off, and the company's online sales are growing rapidly.  The person that led Walmart's ecommerce efforts, Marc Lore, left the company on January 31, 2021, so that might be a concern.  Walmart's reputation for low prices, especially for groceries, cleaning products, and other consumer staples, paid off in the early days of the pandemic when home-bound consumers were stocking up on supplies.  Walmart is now taking steps to reduce its overseas operations.  It announced an agreement to sell its UK subsidiary and business in Argentina.  Walmart also made a deal to sell a majority interest in its subsidiary in Japan.

Shares of Walmart now trade for about $144 each, giving the company a market value of $411 billion. These shares can be found in the Dow Jones Industrial Average, Standard and Poors 500, Standard and Poors 100, Standard and Poors Dividend Aristocrats, New York Stock Exchange Composite, and Russell 1000 stock indices.

Walmart recorded profits of $20 billion on revenue of $549 billion during the last year. In the quarter that ended on October 31, 2020, Walmart earned $1.34 per share (excluding certain items), which significantly beat the $1.18 Wall Street consensus forecast. 

Revenue in the October 2020 quarter totaled $134.7 billion, 5 percent more than last year.  The Walmart U.S. business was responsible for 66 percent of overall revenue, and this unit's revenue grew by 6.2 percent compared to the year-earlier result.  The Walmart International business contributed 22 percent of revenue, and this unit's revenue increased by 1.3 percent.  The Sam's Club unit supplied 12 percent of revenue, and this business's revenue rose by 8.3 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.

Walmart did not provide any guidance about the fourth quarter when the company reported results last November.  I have had to rely on historical trends and national economic data to estimate Walmart earnings.

In particular, data on U.S. Retail and Food Service Sales are published by the Census Bureau and are readily available.  These reports indicated, for example, that sales were up 3.7 percent in November 2020, compared to November 2019.  Walmart is so large that its Revenue correlates fairly well with the national data, and I use this relationship to estimate the company's Revenue.  Although there's no national data yet for January 2021, my preliminary fourth-quarter estimate for Walmart's revenue, using the data that is available, is $145 billion.

In the first three quarters of fiscal year 2021, Walmart's Gross Margin rose from 23.9 percent to 25.4 percent of Revenue.  Counterintuitively, the Gross Margin in the January quarter is usually a little less than in the preceding October quarter.  This history led me to select 25.0 percent as my estimate for the January 2021 quarter.  The corresponding Cost of Goods Sold is (1-0.25) * $145 billion = $108.75 billion.

Sales, General, and Administrative (SG&A) expenses should be a little more than 20 percent of Revenue if history is a valid guide.  To be specific, I used 20.25 percent of Revenue to come up with a $29.4 billion SG&A estimate.

The numbers above combine to produces an estimate for Operating Income of just under $6.9 billion, which is a hefty 29 percent higher than the equivalent quantity in the year-earlier quarter.

I'm aware of two large items items that may be listed as non-operating gains and losses on Walmart's Income Statement for the fourth quarter.  I've estimated using publicly available data that the equity investment in JD.com earned about $1.0 billion, if the size of the Walmart's  stake in the Chinese firm did not change.  On the other side of the ledger, Walmart previously announced it would recognize a non-cash loss of approximately $2.0 billion, after tax, in the fourth quarter of fiscal 2021 on the sale of a majority stake in Seiyu, a retailer in Japan.  On pre-tax basis, this loss could be $2.4 billion.

I used $525 million for the estimate of net interest paid and 26 percent for the effective income tax rate.  With these figures, the estimate for Net Income (GAAP) in the quarter is $3.57 billion (1.25 per share).  

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).

#walmart  #wmt  #gauges #gcfr  #gcfr2 #lookahead #nac_financialanalysis

PEP: Look Ahead to December 2020 Quarterly Results

This "look-ahead" post discusses how I came up with an estimate for PepsiCo's earnings for fiscal 2020's 16-week fourth quarter, which ended on December 26, 2020, 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 11, 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 PepsiCo. 

PepsiCo is a global food and beverage company. In addition to the eponymous soft drinks, PepsiCo also owns the Frito-Lay snack food business. In April 2020, PepsiCo acquired energy drink maker Rockstar for $3.85 billion. PepsiCo bought SodaStream in 2018 for $3.2 billion.

Shares of PepsiCo now trade for about $140 each, giving the company a market value of $195 billion. These shares can be found in the Standard and Poors 500, Standard and Poors 100, Standard and Poors Dividend Aristocrats, NASDAQ 100, and Russell 1000 stock indices. 

PepsiCo recorded profits of $7 billion on revenue of $69 billion during the last year. In the quarter that ended on September 5, 2020, PepsiCo earned $1.66 per share (excluding certain items), which significantly beat the $1.49 Wall Street consensus forecast. 

Revenue in the September 2020 quarter totaled $18.1 billion, 5 percent more than last year's $17.2 billion. The Beverages North America business was responsible for 33 percent of overall revenue, and this unit's revenue grew by 5.6 percent compared to the year-earlier result. The Frito-Lay North America business contributed 24 percent of revenue, and this unit's revenue increased by 7.2 percent. The Europe unit supplied 18 percent of revenue, and this business's revenue rose by 3.1 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.

PepsiCo updated its guidance for the fiscal year and, thus, the fourth quarter, after the company last reported quarterly results.  The key elements of the guidance are excerpted below:

The Company provides guidance on a non-GAAP basis as we cannot predict certain elements which are included in reported GAAP results, including commodity mark-to-market net impacts.

Based on our year-to-date results and what we can reasonably forecast for the balance of this year, we are providing an update to our full-year financial outlook today. The Company now expects:

•Full-year organic revenue growth to be approximately 4 percent;

•Full-year core earnings per share of $5.50 compared to 2019 core earnings per share of $5.53; and

•Approximately $10 billion in cash from operating activities and free cash flow of approximately $6 billion, which assumes net capital spending of approximately $4 billion.

In addition, the Company continues to expect:

•A core effective tax rate of approximately 21 percent; and

•Total cash returns to shareholders of approximately $7.5 billion, comprised of dividends of approximately $5.5 billion and share repurchases of approximately $2 billion.

Note that the guidance refers to non-GAAP earnings, which makes my task a little more difficult and amplifies the uncertainty of my estimates.

In the first three quarters (only 36 weeks at PepsiCo, but that's another story) of fiscal year 2020, organic Revenue growth was 3.6 percent and GAAP Revenue growth was 3.0 percent.  To get to 4 percent organic growth across the full fiscal year, as the guidance predicts, I've assumed the difference between GAAP and non-GAAP revenue growth will remain 0.6 percent.  This suggests that 3.4 percent (4.0 - 0.6) is a plausible estimate for GAAP revenue growth for the fiscal year.

In fiscal year 2019, PepsiCo's revenue was $67.2 billion.  Fiscal year 2020's revenue could, therefore, be 1.034* $67.2 billion = $69.5 billion.  Revenue during the first three quarters of the year was $47.9 billion, which leaves $69.5 billion - $47.9 billion = $21.6 billion for the fourth quarter of fiscal 2020.

During the first three quarters of the year, PepsiCo's Gross Margin averaged 55.4 percent.  The margin the fourth quarter is usually a little less, so I have assumed it will be 55 percent.  The Cost of Goods Sold estimate is, therefore, (1-0.55) * $21.6 billion = $9.7 billion.

Sales, General, and Administrative (SG&A) expenses have averaged 40.4 percent of Revenue during the first three quarters.  In the fourth quarter, this ratio is often 2 to 3 percent higher.  I don't think it will be quite that high this year, but it could see 42 percent as a possibility.

These estimates would lead to Operating Income of $2.8 billion, up from $2.7 billion one year earlier.

I assume net interest paid would drop to $400 million in this era of low rates.

For the income tax rate, I used the non-GAAP estimate of 21 percent.  The difference between the GAAP and non-GAAP rates is usually small.

With these assumptions, my estimate for Net Income is $1.93 billion ($1.39 per share), which compares favorably to $1.77 billion (1.26/share) in the year-earlier period.

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).

#pepsico  #pep  #gauges #gcfr  #gcfr2 #lookahead #nac_financialanalysis

CSCO: Look Ahead to January 2021 Quarterly Results

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

GOOGL: Earnings Report for the Quarter Ending December 31, 2020

Alphabet reported after the market closed on February 2, 2021, it earned $22.30 per diluted share in the quarter that ended on December 31, 2020, up 45 percent from earnings of $15.35 in the same 3 months of the previous year. These figures are the earnings determined in accordance with U.S. Generally Accepted Accounting Principles (GAAP). 

This post compares the quarterly Income Statement published by Alphabet to the estimates I made in a previous “Look Ahead” post.  My estimates were based on publicly available guidance provided by Alphabet's management to financial analysts, news reports, and trends in the company's historical results.  Unless otherwise mentioned, all reported values mentioned below are GAAP figures.

First, a little background about the company:  Alphabet was formed in 2015 as the holding company for Google and various smaller businesses.  Google's products include Search, Maps, Gmail, Android, Chrome, Google Cloud, YouTube, and (recent acquisition) Fitbit.  Even though Alphabet also owns various additional businesses, which it refers to as "Other Bets" (e.g., Waymo), Alphabet's revenues are mostly entirely due to Google's ability to deliver online advertising.  Google (and, therefore, Alphabet) has been benefitting as commerce moves on line, and the COVID pandemic has accelerated this trend.  But, Google's strength can also be a concern.  In October 2020, the U.S. filed a civil antitrust lawsuit claiming that Google has abused its market position in the search and search advertising markets.  This follows a decision by the European Union in June 2018 to fine Google €4.34 billion ($5 billion) for abusing the dominance it has as the owner of the Android operating system.  One year earlier, the EU fined Google €2.42 billion ($2.74 billion) for violating European competition law in the way shopping search results and ads were displayed.

Alphabet has three classes of common shares, with Class B shares, which are primarily owned by Google's founders, having much greater voting rights than the Class A (ticker GOOGL) shares.  Class C shares (ticker GOOG) have no voting rights.

The following table is a simplified version of Alphabet's Income Statement for the quarter that ended in December 2020, with company-reported numbers along side my predictions.  Figures from the year-earlier quarter are also provided to facilitate comparisons.

Revenue in the December 2020 quarter totaled $56.9 billion, 23 percent more than last year.  The Google Services business was responsible for 93 percent of overall revenue, and this unit's revenue grew by 22.4 percent compared to the year-earlier result.  The Google Cloud business contributed 7 percent of revenue, and this unit's revenue increased by 46.6 percent.  The Other Bets unit supplied 0 percent of revenue, and this business's revenue rose by 14.0 percent.

I was expecting Alphabet to report revenue of $51.3 billion for the December 2020 quarter.  The actual amount surpassed my estimate by $5.6 billion (10.8 percent).

The Cost of Revenue (also known as Cost of Goods Sold) was $26.1 billion in the latest quarter, which translates into a Gross Margin of 54.2 percent of revenue. Since it was lower than the 54.4 percent Gross Margin achieved in the year-earlier quarter, it's a sign that Alphabet sold its products and services at (slightly) less profitable prices relative to production costs.  I was expecting the Gross Margin to be 54.5 percent in the December 2020 quarter, and Alphabet missed that prediction by 0.3 percent.

Alphabet spent $7.0 billion on Research and Development in the latest quarter, down from $7.2 billion one year ago. I had estimated that R&D expenses would be $7.4 billion.  R&D was 12.3 percent of Revenue.

Sales, General, and Administrative expenses totaled $8.1 billion in the December 2020 quarter, down 4.9 percent from one year ago.  SG&A expenses decreased from 18.6 percent to 14.3 percent of quarterly revenue, which shows Alphabet spent less per dollar of sales on indirect operational costs, such as marketing. I had estimated that SG&A expenses would be 17.5 percent of revenue, and the actual percentage turned out to be lower than the prediction.

Alphabet's Operating Income was $15.7 billion in the quarter, up 68.9 percent from the year-earlier period.  Operating Income exceeded my $11.6 billion estimate by $4.0 billion.

Interest and other non-operating items summed to a net income of $3.0 billion.  My estimate for non-operating items was $1.4 billion.

The effective income tax rate rose by 18.2 percent to 18.5 percent, which had a negative effect on net income.  I expected the tax rate to be 16.0 percent.

Net income attributable to Alphabet was $15.2 billion, $22.30 per share in the quarter ending December 2020.  The figures for the year-earlier quarter were $10.7 billion, $15.35/share. My earnings estimate for  the latest quarter was $10.9 billion ($15.88/share), so Alphabet earned $6.42 per share more than I had predicted.

In conclusion, the following list shows where the reported results differed from my expectations:

      – Better than expected:  Revenue growth + R&D + SG&A + SG&A/Revenue + Misc non-operating items 

      – Worse than expected:  Interest + Income tax rate 

      – Near expectations:  Gross Margin 

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).

 #alphabet  #goog  #googl  #gauges  #gcfr  #gcfr2 #QtrlyRpt   #nac_financialanalysis

QCOM: Earnings Report for the Quarter Ending December 27, 2020

Qualcomm reported after the market closed on February 3, 2021, it earned $2.12 per diluted share in the quarter that ended on December 27, 2020, up 165 percent from earnings of $0.80 in the same 3 months of the previous year. These figures are the earnings determined in accordance with U.S. Generally Accepted Accounting Principles (GAAP). 

Non-GAAP earnings rose 119 percent to $2.17 per share from $0.99 one year earlier, a not quite as robust change than the GAAP percentage. The principal exclusions contributing to the $0.05 per share difference in the latest quarter between the GAAP and Non-GAAP earnings were: Strategic initiatives [$0.13 per share], Share-based compensation [($0.20) per share], and Other items [$0.02 per share].  Non-GAAP earnings, by excluding unusual and non-cash items that could obscure the results of a business's principal, ongoing operations, are intended to be cleaner measures of corporate profits.

This post compares the quarterly Income Statement published by Qualcomm to the estimates I made in a previous “Look Ahead” post.  My estimates were based on publicly available guidance provided by Qualcomm's management to financial analysts, news reports, and trends in the company's historical results.  Unless otherwise mentioned, all reported values mentioned below are GAAP figures.

First, a little background about the company:  Qualcomm makes chips and licenses mobile communications technologies that are used in many advanced wireless devices.  The transition to 5G mobile networks, which is just beginning, should benefit Qualcomm as the technology will motivate consumers to upgrade (again!) to newer, more capable phones.  Qualcomm's licensing business has been criticized on anti-trust grounds by government regulators in multiple countries and also by phone manufacturers.  This threat eased significantly when Qualcomm settled all litigation in April 2019 with Apple and Apple's contract manufacturers.  More progress was made in 2020 when Qualcomm and Huawei settled their disputes and reached a new long-term, global patent-license agreement.  Anti-trust concerns did end up scuttling the company's planned acquisition of NXP Semiconductors for $44 billion. 

The following table is a simplified version of Qualcomm's Income Statement for the quarter that ended in December 2020, with company-reported numbers along side my predictions.  Figures from the year-earlier quarter are also provided to facilitate comparisons.

Revenue in the December 2020 quarter totaled $8.2 billion, 62 percent more than last year. The CDMA Technologies business was responsible for 79 percent of overall revenue, and this unit's revenue grew by 80.6 percent compared to the year-earlier result. The Technology Licensing business contributed 20 percent of revenue, and this unit's revenue increased by 18.2 percent.

I was expecting Qualcomm to report revenue of $8.2 billion for the December 2020 quarter.  The actual amount surpassed my estimate by a mere $35.0 million (0.4 percent).

The Cost of Revenue (also known as Cost of Goods Sold) was $3.5 billion in the latest quarter, which translates into a Gross Margin of 57.6 percent of revenue. Since it was lower than the 58.4 percent Gross Margin achieved in the year-earlier quarter, it's a sign that Qualcomm sold its products and services at less profitable prices relative to production costs. I was expecting the Gross Margin to be 63.0 percent in the December 2020 quarter, and Qualcomm missed that prediction by 5.4 percent.

Qualcomm spent $1.7 billion on Research and Development in the latest quarter, up from $1.4 billion one year ago. I had estimated that R&D expenses would be $1.7 billion.  R&D was 20.1 percent of Revenue.

Sales, General, and Administrative expenses totaled $567 million in the December 2020 quarter, up 7.4 percent from one year ago.  SG&A expenses decreased from 10.4 percent to 6.9 percent of quarterly revenue, which shows Qualcomm spent less per dollar of sales on indirect operational costs, such as marketing. I had estimated that SG&A expenses would be 7.5 percent of revenue, and the actual percentage turned out to be lower than the prediction.

Qualcomm's Operating Income was $2.5 billion in the quarter, up 145.2 percent from the year-earlier period.  Operating Income fell short of my $2.9 billion estimate by $325 million.

Interest and other non-operating items summed to a net income of $78 million.  My estimate for non-operating items was $225 million.

The effective income tax rate rose by 3.4 percent to 5.7 percent, which had a negative effect on net income.  I expected the tax rate to be 16.0 percent.

Net income attributable to Qualcomm was $2.5 billion, $2.12 per share in the quarter ending December 2020.  The figures for the year-earlier quarter were $925 million, $0.80/share. My earnings estimate for  the latest quarter was $2.2 billion ($1.92/share), so Qualcomm earned $0.21 per share more than I had predicted.

In conclusion, the following list shows where the reported results differed from my expectations:

      – Better than expected:  SG&A + SG&A/Revenue + Misc non-operating items + Income tax rate 

      – Worse than expected:  Gross Margin + Interest 

      – Near expectations:  Revenue growth + R&D 

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).

 #qualcomm    #qcom    #gauges  #gcfr  #gcfr2 #QtrlyRpt   #nac_financialanalysis