16% Spread As Walmart Inc. Continues Bullish Trend

December 29, 2012
By Vlad Karpel

For the latest news on your stock picks, connect with us on Facebook and follow us on Twitter. Sign up here for our exclusive investment round-up delivered directly to your email! We make investing easy!

Walmart Inc. (WMT) is in the business of operations of retail stores across various countries of the world. The major business segments of the company are: Walmart US segment that operates retail stores in US and Puerto Rico; Walmart International segment that is having retail operations in 26 countries and Sam’s Club segment that is having membership warehouse clubs and online retail operations. The share of these segments in total revenue was 60%, 28% and 12% respectively during the previous year.

See the discounted cash flow valuation on Walmart after the JUMP!

INVESTMENT TRIGGERS

The company enjoys a strong retail brand image across the world. The company has strong balance sheet and positive free cash flows. It has regularly rewarded shareholders through dividends and buybacks. The sales and net income have continuously improved over the last five years. The planned investments on reduction of expenses and improvement of productivity are expected to reduce its operating costs lower by 1 per cent during 2013-17. In order to take advantage of e-commerce opportunity, the company raised its stake to 51% in Chinese e-commerce company Yihaodian in Feb 2012 and introduced a new search engine Polaris in August 2012. The launch of Blue Bird, an alternative to debit and checking accounts by Walmart and American express will help customers of the company in saving costs.

VALUATION

Our DCF valuation model provides intrinsic value of each share of the company at $87.82. This DCF Value is obtained on the basis of DCF stream of $107,432 million and terminal value of $228,699 million. After making adjustments for financial assets, net debt and minority interest (book value) from DCF stream and terminal value, value of equity for the company works out to be $295,214 million. We have used WACC of 5.5% for the purpose of above calculations.

INVESTMENT RISKS

The slowdown in economic and industrial activities may result in lesser demand for the products of the company because of lower disposable income with consumers. The traditional retail business of Walmart is facing increased competition from online shopping and department, variety, dollar and specialty stores.  The pressure on prices in retail is also increasing because of increased use of price comparison facilities, showrooming, by the consumers.

DCF Valuation- Walmart Stores Inc(WMT)
2013 2014 2015 2016 2017 2018 2019 2020 2021 2022
Number of Year 0.75 1.75 2.75 3.75 4.75 5.75 6.75 7.75 8.75 9.75
Discounted Cash Flows 10,395 10,644 10,814 11,028 11,015 11,012 10,882 10,723 10,541 10,378
DCF Stream 107,432
Terminal Value 228,699
Financial assets 89
Enterprise Value 336,220
Net Debt 36,156
Minority Interest (Book Value) 4,850
Preferred debt 0
Value of Equity 295,214
Risk Free Rate 1.75%
Beta 1.00
Market Premium 4.1%
Cost of Equity 5.9%
Long-term Tax Rate 35.0%
Cost of Debt 4.6%
Tax Adjusted Cost of Debt 3.0%
Net Debt 36,156
Share of net debt in EV 11.0%
WACC 5.5%
Terminal Growth Rate 1.0%
No. of Shares (million) 3361
Treasury stock (million) 0
Current Market Price 75.62                    
Valuation as per DCF 87.82                    
Spread 16%


Comments Off on


Find Winning Trades
in Minutes

Tradespoon Tools make finding winning trades in minute as easy as 1-2-3.

Our simple 3 step approach has resulted in an average return of almost 20% per trade!

Start Free 7-Day Trial


Latest Tweets

Archive