A Complete Benjamin Graham Analysis For Microsoft Corp.

Benjamin Graham was Warren Buffett's professor and mentor at Columbia Business School. Buffett even named his son - Howard Graham Buffett - after Graham. In the preface to Graham's book - "The Intelligent Investor" - Buffett calls it "by far the best book about investing ever written."

GrahamValue's Benjamin Graham Screener applies the 17 financial criteria given by Graham to all 4700 NYSE and NASDAQ stocks to find Defensive, Enterprising and NCAV grade Graham stocks. Today, we will do a complete Graham analysis for Microsoft (MSFT) and see what grade and price Graham would have recommended for it.

For the most recent numbers, please see the automated analysis for Microsoft Corp (NAS:MSFT).

Microsoft Corporation is an American multinational software corporation headquartered in Redmond, Washington that develops, manufactures, licenses, and supports a wide range of products and services related to computing. The company was founded by Bill Gates and Paul Allen on April 4, 1975. Microsoft is the world's largest software maker measured by revenues.

1. A Defensive Analysis:

The first grade of stocks recommended by Graham are called Defensive stocks. The criteria that Graham specified for identifying Defensive stocks are as follows:

Summarized from CHAPTER 14 of The Intelligent Investor - Stock Selection for the Defensive Investor:

1. Not less than $100 million of annual sales.

[Note: This works out to $500 million today based on the difference in CPI/Inflation from 1971]

2-A. Current assets should be at least twice current liabilities.

2-B. Long-term debt should not exceed the net current assets.

3. Some earnings for the common stock in each of the past ten years.

4. Uninterrupted [dividend] payments for at least the past 20 years.

5. A minimum increase of at least one-third in per-share earnings in the past ten years.

6. Current price should not be more than 15 times average earnings.

7. Current price should not be more than 1-1⁄2 times the book value.

As a rule of thumb we suggest that the product of the multiplier times the ratio of price to book value should not exceed 22.5.

Graham's recommended price for Defensive stocks, popularly known as the Graham number, can be calculated from criteria #6 and #7 as:

The publicly available financial figures for Microsoft are as follows:

Annual Sales

$73,720.00 Million

Reported Book Value

$9.19

Current Assets

$85,084.00 Million

Tangible Book Value

$5.93

Goodwill

$13,452.00 Million

EPS - Current

$1.94

Intangibles

$3,170.00 Million

EPS - Last Year

$2.69

Total Assets

$121,271.00 Million

EPS - 2 Years Ago

$2.10

Current Liabilities

$32,688.00 Million

EPS - 3 Years Ago

$1.62

Long Term Debt

$10,713.00 Million

EPS - 4 Years Ago

$1.87

Total Liabilities

$54,908.00 Million

EPS - 5 Years Ago

$1.42

Redeemable Preferred Stock

$0.00 Million

EPS - 6 Years Ago

$1.20

Non-Redeemable Preferred Stock

$0.00 Million

EPS - 7 Years Ago

$1.12

Shares Outstanding

8,381.00 Million

EPS - 8 Years Ago

$0.75

EPS - 9 Years Ago

$0.69

Based on the above figures, we get the following results for each of Graham's Defensive criteria (anything above 100% is a PASS):

Sales

14,744.00%

Assets / Liabilities

130.15%

Assets / Debt

489.09%

Earnings Stability

100.00%

Dividend Record

55.00%

Earnings Growth

181.23%

Graham Number / Price

45.99%

The Graham number works out to $16.09 for Microsoft. Unfortunately, Microsoft misses the Dividend Record requirement for Defensive stocks and so this is not Graham's recommended price for Microsoft.

Let's now take a look at the other grade calculations given by Graham and see if Microsoft meets them.

2. An Enterprising Analysis:

If a stock failed to meet the criteria for Defensive investment, Graham recommended the following criteria for Enterprising investment.

Summarized from CHAPTER 15 of The Intelligent Investor - Stock Selection for the Enterprising Investor:

[Note: For issues selling at P/E multipliers under 10]

1-A. Current assets at least 11⁄2 times current liabilities.

1-B. Debt not more than 110% of net current assets.

2. Earnings stability: No deficit in the last five years covered in the Stock Guide.

3. Dividend record: Some current dividend.

4. Earnings growth: Last year's earnings more than those of 1966.

[Note: This corresponds approximately to the earnings of 2008 today]

5. Price: Less than 120% net tangible assets.

This second set of criteria gives us a maximum price for a stock meeting Enterprising conditions as - the lower of 120% net tangible assets (book value), or 10 times current earnings. Microsoft does meet all the Enterprising criteria (except for the price). So Graham's recommended price for Microsoft works out to $7.12 per share.

Finally, let's take a quick look at the criteria that Graham recommended for NCAV, Net-Net, or Bargain stocks; and how Microsoft fares against them.

3. An NCAV or Net-Net Analysis:

If a stock met neither Defensive nor Enterprising requirements, Graham recommended these final set of criteria.

Summarized from CHAPTER 15 of The Intelligent Investor - Stock Selection for the Enterprising Investor:

"Bargain Issues, or Net-Current-Asset Stocks"

"price less than the applicable net current assets alone - after deducting all prior claims, and counting as zero the fixed and other assets."

"eliminated those which had reported net losses in the last 12-month period."

These criteria give us what are called NCAV stocks - stocks selling for less than the value of their cash worth alone, and with positive earnings in the last one year.

These are also the most well known of Graham's stocks, and the source of the popular misconception that Graham only recommended cheap stocks. These were, in fact, the last grade of stocks that Graham recommended.

Microsoft's NCAV price works out to $3.60 and the company has not reported net losses for the last 12 months. But since Microsoft meets all the Enterprising criteria at a higher price, Graham's recommended price for Microsoft remains its Enterprising price.

To Conclude

Microsoft's current price of $34.98 works out to a Price/Earnings of 18 and a Price/Book (tangibles) of 5.89. Since Microsoft does not meet Graham's Defensive criteria, but meets the Enterprising and NCAV criteria, Graham's recommended price for Microsoft is the Enterprising price of $7.12 per share.

However, these results are based on a strict inflation-adjusted Graham analysis. Using more customized strategies, such as those in Tweaking Benjamin Graham's Stock Selection Criteria, would yield higher recommended prices for Microsoft such as a Serenity Number of $11.74; or even the Graham Number of $16.09 itself, if one were willing to overlook the partially met Dividend criterion.

Lastly, this analysis should not be construed as a recommendation to short sell Microsoft. Graham never believed in predicting a stock's future price. As far as Graham's principles are concerned, Microsoft may remain at its current or even higher levels indefinitely. Graham simply recommended the prices at which stocks should be bought to avoid losses, and to consistently make profits.

Graham's elaborate criteria, when applied conscientiously to financial data, highlight any discrepancies between stock prices and a company's underlying numbers. Such objective statistical data helps in making informed investment decisions, minimizing losses, and identifying unique investment opportunities.

Disclaimer: The results were arrived at by automated quantitative analysis and were not verified manually. Verify the validity of the data used - most importantly, for any recent stock splits - before making an investment decision.

Comments

Hi,

it is not entirely clear for me, how you calculated the values for the defensive analysis ? Which values did you use for the calculations of Assets / Liabilities, Assets / Debt and Earnings Growth. How did you get the tangible book value and reported book value. It could be that I did something wrong in my calculations to reproduce the values, because I have to translate things from balance sheet to german Bilanz.

Thanks,
Edi

Sorry for the confusion, Edi!

Some of the nomenclature used in the past on Serenity might have been a little confusing.
The names used now should be a lot clearer.

Assets / Liabilities should actually be Current Assets ÷ [2 x Current Liabilities].

Assets / Debt should actually be Net Current Assets ÷ Long Term Debt".

Earnings Growth is calculated by taking 3-year averages at the beginning and end of the last 10-year period.
Then the most recent one is divided by 1.3x times the one from 10 year ago.

Thus, for true defensive investment, all these ratings should evaluate to at least 100%.

Reported Book Value is the value reported by the company.
Tangible Book Value is calculated by deducting Goodwill and Intangibles from the Reported Book Value.

For more clarity, please see the latest automated analysis for Microsoft Corp.