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
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!