Saturday, October 31, 2020

Apple: Gauge Analysis for Value Investors (updated 31 October 2020)

I have analyzed Apple's financial statements to determine whether the reported figures suggest that the company's shares are a good value and reasonable risk for prudent investors. The way I performed this analysis was inspired by Benjamin Graham's recommendations in "The Intelligent Investor," which was first published in 1949 and is still one of the best-known books about value investing. I modified Graham's specific suggestions to fit modern times; however, the goal is the same: find stocks that are inexpensive relative to the company's strengths and aren't excessively risky.

The analysis evaluates investment suitability by determining whether the company satisfies seven criteria.  GREEN, YELLOW, and RED grades indicate whether the criteria are fully satisfied, partially satisfied, or not satisfied at all.  An Overall Score between zero and 100, which takes the details of all criteria into account, is also computed.  While the analysis includes both growth and value criteria, the calculation is weighted to favor companies that exhibit good value characteristics over companies that are fast growers.

An Overall Score of 60 or higher is good result, and it signifies that the subject company appears to have enough value-investment appeal to be worth examining in more detail.


First, a quick review of the company itself.

Apple has become one of the largest companies in the wolrld by selling stylish computers, tablets, smartphones, music players, and watches, as well as software and media.  Services for these devices are also a lucrative and growing business for Apple, but selling iPhones is, by far, the company's largest single revenue source. Apple's shares split 4-for-1 on 28 August 2020; they had split 7-for-1 just six years earlier.

Apple recorded profits of $57 billion on revenue of $275 billion during the last year. In the quarter that ended on 26 September 2020, Apple earned $0.73 per share, which beat the $0.71 Wall Street consensus forecast. See tinyurl.com/yx9xv84k for Apple's most recent quarterly report.

Shares of Apple now trade for about $109 each.  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.


Analysis Results:

Apple's grades on the seven investment criteria are listed below, along with some of the financial figures that influenced these color assignments

1. The Company's Size is Substantial: GREEN

    Market Value: $1.9 trillion (mega-cap)


2. The Company is Conservatively Financed: RED

    Current ratio = 1.4 (>2.0 is conservative)

    Long-term debt/Working Capital = 257% (<150% is conservative)


3. The Company Generates Stable Earnings: GREEN

    Twenty positive quarterly earnings reports in last 5 years (perfect)

    Earnings variability = 1% (negligible)


4. The Company Exhibits Earnings Growth: YELLOW

    Owner Earnings growth rate (trailing year) = 8% (modest)

    Owner Earnings growth rate (five-year average) = 5% (modest)

    Free Cash Flow growth rate (trailing year) = 25% (very good)

    Free Cash Flow growth rate (five-year average) = 8% (modest)


5. The Company is Efficiently Profitable: GREEN

    Cash Flow Return On Invested Capital = 43% (excellent)

    Operating Profit/Sales = 24.1% (excellent)


6. The Company Pays a Healthy Dividend: GREEN

    Dividends paid for the last 7 years or longer

    Dividend 5-year average growth rate = 10% (good)

    Dividend = 19% of last year's FCF (easily sustainable with room to grow)


7. The Company's Shares are Fairly Valued: RED

    Price/Owner Earnings (last year) = 30.9 (very expensive)

    Price/GAAP Earnings (five-year average) = 40.1 (expensive)

    Free Cash Flow/Market Value = 3.9% (low, less than the five-year average of 7.0%)

    Acquirer's Multiple = 28.7 (very expensive)

    Price/Book Value = 28.8 (more expensive than the five-year average of 9.2)

    Price/Sales = 6.8 (more expensive than the five-year average of 3.7)


In summary, the analysis assigned Apple four GREEN, one YELLOW, and two RED grades.  The resulting Overall Score is 44 of the 100 possible points, which is unappealing.  The score is below the 60-point threshold, and, therefore, Apple does not qualify at this time for consideration by value investors.

Check back here occasionally for updates to the Overall Score, which will typically move up or down each time the company releases new financial results and when the share price changes significantly. 

This analysis reported here is not, by any means, a complete evaluation of the subject company, and it does not consider all material facts about the company's operations, finances, or future prospects. The analysis relies on publicly available financial data assumed, but not guaranteed, to be accurate. Readers are encouraged to independently verify all data. Other analytical approaches and screening criteria will be more applicable to investors having different goals, circumstances, and tolerance for investment risk. The analysis is not and should not be considered investment advice, nor does it constitute an offer or solicitation to buy or sell any security. The author might have a position in the subject company and/or its competitors. The methodology and results are subject to change without notification.



---------------

 #apple    #aapl    #valueinvesting    #nac_financialanalysis

Tuesday, October 27, 2020

Microsoft's Quarterly Earnings Report

Microsoft reported (tinyurl.com/yxosq5h4) after the market closed on 27 October 2020 it earned $1.82 per diluted share in the quarter that ended on 30 September 2020, up 32% percent from earnings of $1.38 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). 

Microsoft develops and sells operating system and application software, software and cloud services, and hardware items, such as game consoles. Microsoft acquired LinkedIn in December 2016 for approximately $27 billion, and it acquired GitHub in October 2018 for $7.5 billion.  In September 2020, Microsoft reached an agreement to acquire ZeniMax Media, the parent company of game-developer Bethesda Softworks, for $7.5 billion.

Earnings of $1.82 per share in the latest quarter significantly beat the $1.54 average ("consensus") of estimates made by Wall Street analysts. See tinyurl.com/y66ln98g for Microsoft's earnings record and forecasts.

Although Microsoft's earnings were better than expected, stock market traders still weren't satisfied. The price of the company's shares fell 1.8% during after-hours trading following the report.

Note that a change in the assumed useful life of Microsoft's servers and network equipment increased net income in the quarter by $927 million, or $0.10 per share.

Looking deeper into the GAAP results, "top-line" revenue in the September 2020 quarter totaled $37.2 billion, 12% more than last year's $33.1 billion. The Productivity and Business Processes business was responsible for 33% of overall revenue, and this unit's revenue grew by 11.2% compared to the year-earlier result. The Intelligent Cloud business contributed 35% of revenue, and this unit's revenue grew by 19.7%. The More Personal Computing unit supplied 32% of revenue, and the amount grew by 6.4%.

The gross margin strengthened from 68.5% of revenue to 70.4%, a sign that Microsoft sold its output and services at more profitable prices relative to production costs. Sales, general, and administrative expenses decreased from 16.3% to 14.4% of quarterly revenue, which shows the company spent less per dollar of sales on other operational costs, such as marketing. The effective income tax rate fell by 2.0% to 13.8%, which had a positive effect on net income.

Microsoft's operating activities generated $19.3 billion in cash during the last quarter, up 39.9% from $13.8 billion in the year-earlier period. The cash flow delta was, therefore, much better than the change in earnings. Notable uses for cash included $3.9 billion to pay dividends to shareholders, $481 million for corporate acquisitions, $6.7 billion to buy back the company's common shares, and $4.9 billion to acquire property, plant and capital equipment. 

Free cash flow over the last 12 months totaled $49.3 billion, or $6.45 per share using the latest share count. At the current market price per share of $202.47, this translates into a modest Free Cash Flow Yield of 3.2%.

The accompanying charts illustrate several trends in Microsoft's financial results, taken from data in regulatory filings. The text and the charts are intended to provide some limited historical context for readers interested in the company’s finances. No investment advice is provided, and no investment offer of any kind is made or solicited. The accuracy of the information presented is not guaranteed, and readers are encouraged to independently verify all data.























#microsoft    #msft    #earnings    #nac_financialanalysis