Graham Number is a figure that measures a stock's fundamental value by taking into account the company's earnings per share and book value per share. The Graham number is the upper bound of the price range that a defensive investor should pay for the stock. According to the theory, any stock price below the Graham number is considered undervalued, and thus worth investing in.
As of today (2024-04-23), the stock price of Microsoft is $407.055. Microsoft's graham number for the quarter that ended in Dec. 2023 was $54.76. Therefore, Microsoft's Price to Graham Number ratio for today is 7.43.
The historical rank and industry rank for Microsoft's Graham Number or its related term are showing as below:
MSFT'
s Price-to-Graham-Number Range Over the Past 10 Years
Min: 1.86 Med: 4.69 Max: 7.45
Current: 7.43
During the past 13 years, the highest Price to Graham Number ratio of Microsoft was 7.45. The lowest was 1.86. And the median was 4.69.
MSFT's Price-to-Graham-Number is ranked worse than 87.88% of 1353
companies
in the Software industry
Industry Median: 2.15
vs MSFT: 7.43
Graham Number is a combination of asset valuation and earnings power valuation. It is a very conservative way of valuing a stock.
Microsoft Graham Number Historical Data
The historical data trend for Microsoft's Graham Number can be seen below:
* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD. * For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.
For the Software - Infrastructure subindustry, Microsoft's Price-to-Graham-Number, along with its competitors' market caps and Price-to-Graham-Number data, can be viewed below:
* Competitive companies are chosen from companies within the same industry, with headquarter located in same country, with closest market capitalization; x-axis shows the market cap, and y-axis shows the term value; the bigger the dot, the larger the market cap. Note that "N/A" values will not show up in the chart.
Microsoft Price-to-Graham-Number Distribution
For the Software industry and Technology sector, Microsoft's Price-to-Graham-Number distribution charts can be found below:
* The bar in red indicates where Microsoft's Price-to-Graham-Number falls into.
Microsoft Graham Number Calculation
Graham Number is a concept based on Ben Graham's conservative valuation of companies.
Microsoft's Graham Number for the fiscal year that ended in Jun. 2023 is calculated as
* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD. * For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.
Microsoft (NAS:MSFT) Graham Number Explanation
Ben Graham actually did not publish a formula like this. But he wrote in The Intelligent Investor (1948 version) regarding to the criteria for purchases:
Current price should not be more than 15 times average earnings of the past three years.
Current price should not be more than 1.5 times the book value last reported. However, a multiplier of earnings below 15 could justify a correspondingly higher multiplier of assets. 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. (This figure corresponds to 15 times earnings and 1.5 times book value. It would admit an issue selling at only 9 times earnings and 2.5 times asset value, etc.)
Unlike valuation methods such as DCF or Discounted Earnings, the Graham number does not take growth into the valuation. Unlike the valuation methods based on book value alone, it takes into account the earnings power. Therefore, the Graham Number is a combination of asset valuation and earnings power valuation.
In general, the Graham number is a very conservative way of valuing a stock. It cannot be applied to companies with negative book values.
Microsoft's Price to Graham number Ratio for today is calculated as
Price to Graham number
=
Share Price (Today)
/
Graham number (Q: Dec. 2023 )
=
407.055
/
54.76
=
7.43
* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD. * For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.
Be Aware
Please keep these in mind:
1. Graham Number does not take growth into account. Therefore it underestimates the values of the companies that have good earnings growth. We feel that if the earnings per share grows more than 10% a year, Graham Number underestimates the value.
2. Graham Number punishes the companies that have temporarily low earnings. Therefore, an average of earnings makes more sense in the calculation of Graham Number.
3. Graham Numbers underestimates companies that are light with book.
Microsoft Graham Number Related Terms
Thank you for viewing the detailed overview of Microsoft's Graham Number provided by GuruFocus.com. Please click on the following links to see related term pages.
Microsoft develops and licenses consumer and enterprise software. It is known for its Windows operating systems and Office productivity suite. The company is organized into three equally sized broad segments: productivity and business processes (legacy Microsoft Office, cloud-based Office 365, Exchange, SharePoint, Skype, LinkedIn, Dynamics), intelligence cloud (infrastructure- and platform-as-a-service offerings Azure, Windows Server OS, SQL Server), and more personal computing (Windows Client, Xbox, Bing search, display advertising, and Surface laptops, tablets, and desktops).
Quick Browse
Personalize
Premium Gurus 
Create New Portfolio
Portfolio Contest
MSFT has been successfully added to your 