Company Profile (obtained from Google Finance): Wal-Mart Stores, Inc. (Walmart) operates retail stores in various formats around globally. Everyday low prices (EDLP) is the Company’s pricing philosophy under, which it prices items at a low price everyday. The Company’s operates in three business segments: the Walmart U.S. segment, the Walmart International segment, and the Sam’s Club segment. During the fiscal year ended January 31, 2012 (fiscal 2012), its Walmart U.S. segment accounted for approximately 60% of its net sales and operates retail stores in various formats in all 50 states in the United States and Puerto Rico, as well as Walmart’s online retail operations, walmart.com. Its Walmart International segment consists of retail operations in 26 countries. Its Sam’s Club segment consists of membership warehouse clubs operated in 47 states in the United States and Puerto Rico, as well as the segment’s online retail operations, samsclub.com. During 2012, Sam’s Club accounted for approximately 12% of its net sales.
Defensive and Enterprising Investor Tests (What is the significance of these tests, and what is PEmg ratio?):
Defensive Investor – must pass at least 6 of the following 7 tests: Score = 5/7
- Adequate Size of Enterprise – market capitalization of at least $2 billion – PASS
- Sufficiently Strong Financial Condition – current ratio greater than 2 – FAIL
- Earnings Stability – positive earnings per share for at least 10 straight years – PASS
- Dividend Record – has paid a dividend for at least 10 straight years – PASS
- Earnings Growth – earnings per share has increased by at least 1/3 over the last 10 years using 3 year averages at beginning and end of period – PASS
- Moderate PEmg ratio – PEmg is less than 20 – PASS
- Moderate Price to Assets – PB ratio is less than 2.5 or PB x PEmg is less than 50 – FAIL
Enterprising Investor – must pass at least 4 of the following 5 tests or be suitable for a defensive investor: Score = 3/5
- Sufficiently Strong Financial Condition, Part 1 – current ratio greater than 1.5 – FAIL
- Sufficiently Strong Financial Condition, Part 2 – Debt to Net Current Assets ratio less than 1.1 – FAIL
- Earnings Stability – positive earnings per share for at least 5 years – PASS
- Dividend Record – currently pays a dividend – PASS
- Earnings growth – EPSmg greater than 5 years ago – PASS
Valuation Summary (Calculator)
|MG Opinion||Fairly Valued|
|Value Based on 3% Growth||$69.00|
|Value Based on 0% Growth||$40.45|
|Market Implied Growth Rate||4.07%|
Balance Sheet – 7/31/2013
Earnings Per Share – Diluted
Earnings Per Share – Modern Graham
Walmart Stores is a solid company with a strong history of success; however, when measured using ModernGraham’s requirements for the Defensive Investor or the Enterprising Investor, revised and updated from Benjamin Graham’s The Intelligent Investor, the company does not appear to be a solid opportunity at this time. The current ratio and the high PB ratio eliminate it from contention for the Defensive Investor, and similarly the high level of current liabilities eliminates it from the Enterprising Investor’s view. Looking at it purely on a valuation standpoint, the company appears to be fairly valued, as it is currently trading within ModernGraham’s margin of safety.
What do you think? Is Walmart fairly valued? Is the company not suitable for Defensive Investors and Enterprising Investors? Leave a comment or mention @ModernGraham on Twitter to discuss.
Disclaimer: The author did not hold a position in Walmart at the time of publication and had no intention of purchasing a position in the next 72 hours.
Photo Credit: Andrew Magill