قالب وردپرس درنا توس
Home / Business / Walmart, Inc.: An Updated Valuation and Purchase Price Targets – Walmart Inc. (NYSE: WMT)

Walmart, Inc.: An Updated Valuation and Purchase Price Targets – Walmart Inc. (NYSE: WMT)



 Walmart Dividend Stock Analysis 2019 Passive-Income-Pursuit.com

Walmart (NYSE: WMT) is one of the few consumer related business models that tend to thrive during recessions as consumers seek out cheaper alternatives for the items that they have need. Walmart has continued to expand their grocery offerings as well as the number of stores offering online grocery ordering and in-store pickup. In a world where everyone seems pressed for time, you can buy everything you need at one store or at time when ordering groceries online can free up an hour or two per week.

Walmart has also been expanding its e-commerce business both organically and through acquisitions such as with Jet.com and Flipkart. In 3Q FY 2019, ecommerce sales for the Walmart U.S. segment grew by 43% sequentially. About the TTM, ecommerce revenues now represent over $ 15 B in revenues.

With 4Q and full year results due out this week, I wanted to re-examine this retailing giant to see whether it was warrants some of my investment capital. ] Dividend History

When I started investing, the approach that I gravitated towards was dividend growth investing. The premise being focused on quality companies trading at fair valuations or cheaper and look at the dividends while letting the capital gains come over time. The idea behind that is that you can eat apples from an apple tree every year, but you can only harvest the wood once.

 Walmart Dividend History Passive-Income-Pursuit.com Image by author; data source Walmart Investor Relations. An interactive version of this chart can be found here.

Walmart has increased its dividend payment for 45 consecutive years giving it the title of Dividend Champion from the late David Fish. That's nearly half a century of economic and geopolitical turmoils, inflation, stagflation and every other "catastrophe" that was going to forever change the economy as we knew it. Yet, every year, Walmart has been paying and increasing their dividend.

Up to 2013, Walmart had routinely given 10% + annual dividend growth. However, starting in 2014, dividend growth has slowed to a crawl with just $ 0.01 per share increases being paid out, which works out to roughly 2% per year.

The 1-, 3-, 5- and 10-year rolling dividend growth rates since 1993

Year Year Year 5 Year 10 Year 1993 $ 0.06
1994 $ 0.09 49.47% 1995 $ 0.10 17.37% $ 0.10 17.37% ] 19.66% 22.66% 28.62% 1998 19.79% 19.79% 15.78% 22.79% 19659013] 18.61%
2000 $ 0.24 20.00% [196590] 13] 21.08% 19.14%
2001 $ 0.28 16.67% 21.74% 21.63%
2002 $ 0.30 7.14 % 14.47% 17.28%
2003 $ 0.36 20.00% 14.47% 18.33% 20.24%
2004 20.24%
2004 $ 0.52 44.44% 22.92% 21.06% 19.83%
2005 $ 0.60 15.38% 25.99% 20.11% 19.62% [19659018] 2006 $ 0.67 11.67% 01.23% 19.06% 20.34%
2007 $ 0.88 31.34% 19.17% 24.01% [19659013] 20.60%
2008 $ 0.95 7.95% 16.55% 21.42% 19.86%
2009 $ 09.01 14.74% 17.61% 15.95% 18.48%
2010 $ 1.21 01.11% 11.20% 15.06% 17.56%
2011 $ 1.46 20.66 % [19659013] 15.40% 16.86% 17.96%
2012 $ 1.59 8.90% 13.41% 12.56% 18.15%
2013 $ 1.88 18.24% 15.82% 14.63% 17.97%
2014 $ 1.92 2.13% 9.56% 11.99% 13.95% [19659018] 2015 $ 1.96 08.02% 7.22% 10.13% 12.57%
2016 $ 2.00 04.02% 08.02% 6.50% [19659013] 11.56%
2017 $ 04.02 2.00% 04.02% 11.05% 8.77%
2018 $ 08.02 1.96% 2.00% 2.04% 8.15%

Table and calculations by author. Data source Walmart SEC filings. An interactive chart of the table is available here.

The slowing dividend growth has brought the payout ratio based on free cash flow down to more conservative levels. Over the last decade, the free cash flow payout ratio has averaged 39.3%, while the traditional net income payout ratio has averaged 37.5%. For the TTM period, the net income payout ratio is over 100%, although that is due to accounting earnings taking a hit due to the tax law changes, which is not reflected in the free cash flow. Walmart's dividend is still very safe and well covered by cash that the business generates.

 Walmart Dividend Payout Ratios Passive-Income-Pursuit.com Image by author; data source Walmart SEC filings

How Does Walmart Make Money?

Walmart is the world's largest retailer with a variety of large formats from grocery only, membership stores and the most well-known Walmart Supercenter where you can buy just about anything that you can think of. Walmart is organized into 3 operating segments:

  1. Walmart U.S.
  2. Walmart International
  3. Sam's Club

 Walmart 3Q FY 2019 revenue and operating profits by segment Passive-Income-Pursuit.com Image by author; data source Walmart's 3Q FY 2019 quarterly filing

Walmart U.S. is by far the largest in terms of both sales and operating profits with ~ 65% and 71% for 3Q or FY 2019, respectively. Walmart International is the second largest with 23% and 21%, respectively, with Sam's Club generating 12% and 7%, respectively.

Walmart U.S.A. also leads the way in terms of operating profit margin at 4.9%, with Walmart International showing margins of 4.1% and Sam's Club well behind just 2.6%.

 Walmart 3Q FY 2019 revenue and operating profits by geography Passive-Income-Pursuit.com Image by author; data source Walmart's 3Q FY 2019 quarterly filing

Approximately 77% of Walmart's revenue and 79% of its operating profits during 3Q FY 2019 came domestically with the rest coming from outside the United States. While Walmart is highly exposed to the domestic market, they have significant exposure to the strength of the U.S. US $ 19659171 A strong U.S. dollar hurts the international sales, by scale alone, it's going to have an impact, when converted back to dollars for reporting purposes. However, it is also important to remember that as a retailer Walmart has to buy goods to stock the shelves. With a large number of consumer goods production coming from outside the United States, specifically in China and other Asian countries, the stronger U.S. dollar lets Walmart source the products for cheaper

Quantitative Quality

The quality of a business model will show up in its numbers. Whether it is consistent growth, improved operational efficiency, and most importantly, gobs of cash flow.

 Walmart Revenue Operating and Free Cash Flows Image by author; data source Walmart SEC filings

In spite of the "end of Walmart" being written many times, Walmart has managed to grow sales by 23.4% over the last decade or roughly 2.4% per year. It's actually pretty amazing to think that a company with over $ 400 B in annual sales in 2009 could push up to $ 500 in 10 years when the business is pretty much fully built out. Even more impressive is that revenue has only one year-over-year decline in that time as well.

About that same time, operating cash flow has grown 22.4% or 2.3% annually with free cash flow climbing and absurd 57.0% in total or 5.1% annually. With operating cash flow keeping pace with revenue growth, operating cash flow margins have been flat over the decade while free cash flow margins have seen a market improvement, albeit still at very low levels.

 Walmart Cash Flow Margins Passive-Income-Pursuit.com Image by author; data source Walmart SEC filings

My preference is for the companies I invest in to have 10% + free cash flow margins. Walmart clearly fails this test with free cash flow margins averaging just 3.1% over the last decade. The 10% threshold is very industry-specific, and in the discount retailing space that Walmart operates, margins are notoriously tight compared to other industries.

Alternatively, I like to view the profitability of a business via its free cash flow return on invested capital. The FCF ROIC is the yearly return that one could generate from the business if you owned it outright under the current capital structure. I also include the FCF ROIC "net" value, which is the cash held on the balance sheet from both equity and debt. Once again, I want to see a value over 10%

 Walmart Free Cash Flow Returns On Capital Passive-Income-Pursuit.com Image by author; data source Walmart SEC filings

Walmart has not been above the 10% level every year over the last decade; however, they have routinely been above or just slightly below 10%. The average over the last decade has been 11.7% with the average FCF ROIC not coming in at 13.3%. Both of these are at healthy levels, and since 2014, the trend for both has been higher.

To understand how Walmart uses its free cash flow, I like to examine 3 variations on the metric, defined below:

  1. Free Cash Flow (FCF): The traditional calculation for free cash flow of operating cash flow capital expenditures
  2. Free Cash Flow after Dividend (FCFaD): FCF less total cash dividend payments
  3. Free Cash Flow after Dividend and Buybacks (FCFaDB): FCFaD less total cash spent on share repurchases

Ideal investment candidates will show positive FCFaDB the majority of the time. A positive FCFaDB would mean that the business generates enough cash through its operations to maintain and grow the business, as well as reward shareholders with dividends and share buybacks. If FCFaDB trends negative, then management will be forced to either use cash or assets on the balance sheet or seek out external funding via the capital markets.

 Walmart Free Cash Flows Passive-Income-Pursuit.com Image by author ; data source Walmart SEC filings

About the last decade, Walmart has grown its annual FCF by more than 50% and has averaged $ 14.17 B per year in FCF. Cumulatively, Walmart has generated $ 141.74 B in FCF, which is an astounding total.

That FCF has allowed Walmart to pay out $ 53.78 B to shareholders in dividends over the last decade and puts the FCFa at $ 87.97 B for the entire period with an annual average of $ 8.80 B.

Walmart has also used $ 67.86 in total on share repurchases over the last decade for an average of $ 6.79 B per year. That puts the FCFaDB for the last decade at a healthy $ 20.09 B.

Walmart has been truly exceptional at managing their free cash flow and not allocating cash towards dividends or buybacks. The positive FCFDDB should allow management to continue with dividend increases as well as further pursue share repurchases through internally generated cash. [$ 67,86] spent on share repurchases over the last decade has reduced the weighted shares outstanding by 23.8% over the last. decade. That's good for a 3.0% annual reduction.

 Walmart Shares Outstanding Passive-Income-Pursuit.com Image by author; data source Walmart SEC filings

The following chart shows the ratio of the cash Walmart has used on dividends and buybacks. While I concede that share repurchases are more tax efficient, I prefer dividends to a larger portion of the cash returned to shareholders. It takes a strong management to not force feed share repurchases if they are a smart use of capital, and many managements do a poor job of buying $ 1 or earning power for $ 0.50, let alone a 1: 1.

 Walmart Dividends vs Share Buybacks Passive-Income-Pursuit.com Image by author; data source Walmart SEC filings

The ratio of cash returned to shareholders has been quite variable over time; however, the ratio has typically hovered around a 60:40 or 50:50 split for dividends versus share buybacks.

 Walmart Debt to Capitalization Passive-Income-Pursuit.com Image by author; data source Walmart SEC filings

With plenty of cash flow, Walmart has no need to take on additional debt. That's why the total debt to capitalization has been very consistent over the last decade with debt accounting for roughly 40% of the capital structure with equity making up roughly 60%. The debt that Walmart does carry is very manageable and would take just 2.1 years of free cash flow to pay off completely with free cash flow also covering interest at 8.3x. I would still prefer to see debt reduced; Walmart's balance sheet

Risks To An Investment

The elephant in the room is Amazon (AMZN). Amazon is one of the few retail companies that have the scale to be able to challenge Walmart as the low-cost provider for consumers on just about any product they want to buy. That being said, at least up until now, I think Mark Twain said it was best with "the rumors of my death have been greatly exaggerated."

A spite of Amazon's growing presence, Walmart has still grown sales over the last decade with only 1 year-over-year decline. Also, Walmart has been building its e-commerce business and has made great strides in that department with revenues over $ 11B for the last fiscal year. That's still a long way from truly competing with Amazon on e-commerce, but Walmart has made progress and should continue to do so.

Walmart has also been offering in-store grocery pickup which is a service I've yet to use But that's why I prefer to grocery shop for myself. My time is not so busy where I feel the need to save time with online grocery shopping although that very well could change with our second child due in April.

The other big risk is that there will be a continued push for higher wages. As one of the largest employers, increased wages will be felt by Walmart. I'm not too concerned about this either as Walmart has already pushed its starting up to $ 11 / hr, and employees are likely to be at least a portion of the increased wages back to sales at Walmart.

Valuation

One of the methods that I use to determine the valuation of a business is the minimum acceptable rate of return, or "MARR "analysis. A MARR analysis entails estimating future earnings and dividends, applying a valuation to the future earnings and then determining whether the expected return meets your threshold for investment.

On average, analysts expect Walmart to have earnings of $ 4.72 for FY 2019 and to see 6.0% annual earnings growth over the next 5 years. I then assumed that earnings growth would be slow to 4.0% annually for the following 5 years. I've assumed that dividends will be targeted at 45% of annual earnings per share.

To determine a reasonable valuation, use the historic multiples that investors have valued Walmart's earnings. As you can see in the following chart, investors have typically valued Walmart's earnings between ~ 10x and 20x. Using a modified Graham Number calculation pegs the fair P / E around 17x. For the MARR analysis, I'll examine multiples in that range

 Chart Data by YCharts

The following table shows the potential internal rates of return that an investment in Walmart could provide a purchase price around $ 100 per share. Returns include estimated dividend payments and are due through the end of calendar year 2023, "5 Year", and calendar year 2028, "10 Year".

 Walmart MARR Analysis Results Passive-Income-Pursuit.com

Alternatively, I want to determine price targets that would potentially generate 10% and 15% internal rates of return based on the varying P / E ratios.

 Conclusion </strong></h2>
<p class= Walmart the business has proven itself over the last 57 years growing from a single store front in. Arkansas to the world's largest retailer. The retail sector is notorious for having very low profit margins; However, Walmart has consistently proven to have management that focuses on its free cash flow.

The problem right now with Walmart is not the business, rather it's the stock price. At nearly $ 100 per share, the valuation appears too high based on the relatively larger growth prospects that Walmart has. If analyst estimates for $ 4.72 in EPS for FY 2020 play out, you're paying over 21x forward earnings for a company expected to grow just 6% per year. That's a premium to pay even for a quality company.

Unless you expect growth to be higher than assumed in this analysis returns from the current price seem more than

Even adding the perpetuity value of the dividend stream assuming now future growth after 2028 adds just $ 12.80 per share in the 10% discount rate price target and $ 5.47 per share at the 15% discount rate target. That would have been shares of Walmart quite overvalued.

I believe there are better opportunities currently in the market and that better opportunities to purchase shares of Walmart will come in the future. Ongoing, I can't tell when that will be. Given the current growth prospects of Walmart, I would start to contemplate purchasing shares in the mid- $ 80s or roughly 15% lower than the current share price and probably wouldn't share until the upper $ 70s share price is seen. 19659227] I am not a financial professional. Please consult an investment advisor and do your own due diligence prior to investing. Investing involves risks. All thoughts / ideas presented in this article are the opinions of the author and should not be taken as investment advice.

Disclosure: I am / we are long WMT. I wrote this article myself, and it expresses my own opinions. I am not receiving compensation for it (other than from Seeking Alpha). I have no business relationship with any company whose stock is mentioned in this article. [Window] SAA = {"App": {"name": "SA", "fullName": "Seeking Alpha", "type": "regular", "host", "https://seekingalpha.com", "email host": "https://email.seekingalpha.com," "pro": false, "ProPlus": false, "contributorCenter": false, "real hostname" "https://seekingalpha.com", "ISCM" false, "cancelPV" false, "isSharkPreview" false, "usersOnSite", "7277832", "assetHosts": [“https://static.seekingalpha.com”,”https://static1.seekingalpha.com”,”https://static2.seekingalpha.com”,”https://static3.seekingalpha.com”]"moneData": { "params", "subscribe_color = test_v1"}, "asset host": "https://static.seekingalpha.com", "user echo host": "https://feedback.seekingalpha.com", "env ": {" dev "false," staging "false," production ": true," test ": false}," gaAccountId ":" UA-1466493-1, "" comscoreAccountId ": 8500672," fbAppId ": "624608951014846", "twitter account name", "SeekingAlpha", "rollbarToken": "5edf110be2fc4cecb32637fc421111e2", "perimeterXAppId": "PXxgCxM9By", "embedlyKey": "a6da93fdfc49472099ce63260954716b", "mp" false, "chat": { "host" "https://rc.seekingalpha.com"}} "pageConfig": { "refresh" : {"active": false}, "Data": {"article": {"id": 4241947, "title": "Walmart, Inc .: An Updated Valuation And Purchase Price Targets", "stub": false, "primaryTicker": "wmt", "prioritizedTicker": "wmt", "primaryIsCrypto": false, "isTranscript": false, "isSlides": false, "twitContent": "$ WMT – Walmart, Inc .: An Updated Valuation And Purchase Price Targets https://seekingalpha.com/article/4241947-walmart-inc-updated-valuation-purchase-price-targets?source=tweet","isProArticle":false,"isProPaywall":false,"paywallReason " : zero "isArchived" false, "inEmbargo" false, "is_wsb" false, "isAuthorNewsletter" false, "title test": null, "archiveOn": 1551480529000.0, "isProNoEmbargo" false, "url": " https://seekingalpha.com/article/4241947-walmart-inc-updated-valuation-purchase-price-targets","isFreeMpArticle":false,"isFreeProArticle":null,"isInsight":false,"insightSlug ":" "" price_at_publication ": null," date_at_publication ":" 2019-02-19 "," themes ": [“dividend-ideas”,”sa-exclusive”,”us”,”discount-variety-stores”,”services”,”article”]," from_liftigniter "false," isAnyProArticle "false," allowMpPromotion "false," article_EN datetime ":" 2019-02-18T18: 18: 55.000-05: 00 "," isEtf ": false," taggedUrlsHtml ":" "items items itemtype = 'http: //data-vocabulary.org/Breadcrumb' href = 'https: //seekingalpha.com/analysis/investing-income/all' sasource = 'article_navigation' itemprop = 'url' spell itemprop = 'title' dividends / span You can use itemscope type = 'http: //data-vocabulary.org/Breadcrumb' href = 'https: //seekingalpha.com/analysis/investing -income / dividend-ideas' sasource = 'article_navigation' itemprop = 'url' spell itemprop = 'title' dividend ideas / span / span itemscope itemtype = 'http: //data-vocabulary.org/Breadcrumb' href = 'https: //seekingalpha.com/analysis/sectors/services' sasource = 'article_navigation' itemprop = 'url' usp3 itsprop = 'title' services / span / span, span / span U003c / span u003e "," isFidelityEducationPage "False," content data ": null," marketing bullet ": null}, the" author ": {" id ": 60561," userId ": 7257631," slug "," passive -income-pursuit "," exclusiveResearch ": null," tagId ": 140611," name ":" Passive Income Pursuit "," picture_url ":" https://static3.seekingalpha.com/images/users_profile/007/257 /631/big_pic.png","is_brand_author":false,"show_managed_account":false},"comments":{"discussion_status":0,"discussion_message":"Comments disabled for this article "}," brand ": null , "first research author": {}, "page type", "article", "articleModeratedMsg": null, "indexTickers": {} "qmChartData": { "isMF" false, "isETF" false, "isCEF": false, "etfData": {}, "isCrypto": false, "isIndex": false}, "chartTimes": {"MARKET_OPEN_TS": 1550500200, "END_TIME": "02/15/2019 16:00", "1D ":" 02/15/2019 9:30 "," PREV_1D ":" 02/15/2019 9:30 "," 5D ":" 02/11/2019 9:30 "," 1M ":" 01 / 18/2019 9:30 "," 6M ":" 08/17/2018 16:00 "," 1Y ":" 02/16/2018 16:00 "," 5Y ":" 02/18/2014 16: 00 "," 10Y ":" 02/18/2009 16:00 "," 20Y ":" 02/18/1999 16:00 "," MAX ":" 01/01/1950 9:30 "}, "Object": { "id" 56, "name", "WMT", "slug": "WMT", "visible": true, "searchable": true, "tag_kind_id" 52, "is_defunct" False , "updated_on": "2018-07-15T07: 34: 08.000-04: 00", "content": "Walmart Inc."}}, "Ads": {"slots": [{“container”:”article-left-slot-2″,”data”:{“name”:”/6001/sek.analysis/dividends/dividend-ideas”,”disable_collapse_empty_div”:false,”targeting”:{“tile”:160},”size”:[[160,600]"fluid"] , "size", "160×600, fluid"}}, { "container", "article-left-slot 3", "data": { "name": "/ 6001 / sek.analysis / Dividends / dividend-ideas "" disable_collapse_empty_div "false," targeting ": {" tile ": 162}," size ": [[160,600]," fluid "]," size "," 160×600, fluid "}," delay ": true, "whenOutOfView": "article-left-slot 2"}, { "container", "article-right-slot-1", "data": { "name": "/ 6001 / sek.analysis / Dividends / dividend -Idea "," disable_collapse_empty_div "false," targeting ": {" tile ": 1}," size ": [[300,250][300,600]," fluid "]," size "," 300×250,300×600, fluid " }, "cis", "MB25", "flex": true}, { "container", "article-right-slot 2", "data": { "name": "/ 6001 / sek.analysis / Dividends / dividend-ideas "," disable_collapse_empty_div ": false," targeting ": {" tile ": 100}," size ": [[300,100]]," str "," 300×100 "}," cls ":" MB25 "} { "container", "article-right-slot 3", "data ": {" Name ":" / 6001 / sek.analysis / Dividends / dividend-ideas "," disable_collapse_empty_div "False," targeting ": {" tile ": 2}," size ": [[300,252]," fluid "]," size "," 300×252, fluid "}," cis "," MB25 "," native ": true}, {" container "," article-middle slot 1 "," data ": {" name ":" / 6001 / sek.analysis / Dividends / dividend-ideas "," disable_collapse_empty_div ": false," targeting ": {}," size ": [[640,40]]," str "," 640×40 "}} { "container", "ad_728x90", "data": { "name": "/ 6001 / sek.analysis / Dividends / dividend-ideas", "disable_collapse_empty_div" false, "targeting": { "tile": 728} , "size": [[728,90]]"str", "728×90"}, "delay": true, "delta": 500}, { "container": "instream_recommendation_ad", "data": { "name": "/6001/sek.analysis/dividends/dividend-ideas","disable_collapse_empty_div":false,"targeting":{"tile":50},"size":[[3,3],"fluid"],"str": "3×3, fluid"}, "delay": true, "delta": 500}]"test scroll": true, "disabled" false, "kvs": { "d": [“analysis”,”investing-income”,”sectors”]"t": [“dividends”,”dividend-ideas”,”sa-exclusive”,”us”,”discount-variety-stores”,”services”,”article”]"aid", "4241947", "a", "passive income-pursuit", "cnt": [“6″,”8″,”oil”,”fed”,”taxes”,”ssga1″,”ssga2″,”fnk1″,”fnk2″,”port”,”420″,”fnk3″,”fnk4″]"prstock", "true", "ticker bundle": [“value”,”dividend”,”large-cap”,”consumer-services”]"pr ": "WMT", "s", "WMT", "ab_subscribe_color": "test_v1"}} "Path": { "int": { "adsAPI": { "src", "https: //static3.seekingalpha. com / assets / api / ads-0cf8a56f1d93653afa4e33f67b12af5def2cb05353be15eeceffef0ad3d63d2f.js "," id ":" sa-ads-api "}}," ext ": [{“src”:”https://js-sec.indexww.com/ht/p/183642-162053219843577.js”,”id”:”ie”},{“src”:”https://www.googletagservices.com/tag/js/gpt.js”,”id”:”gpt”},{“src”:”https://pub.doubleverify.com/pub.js?ctx=818052u0026cmp=DV157324″,”id”:”doubleverify”},{“src”:”https://sb.scorecardresearch.com/beacon.js”,”id”:”sb”},{“src”:”https://ssl.google-analytics.com/ga.js”,”id”:”ga”},{“src”:”https://connect.facebook.net/en_US/sdk.js”,”id”:”facebook-jssdk”}]}," lastRequested ":" 2019-02-18 19:50: "," lastRequested ":" 2019-02-18 19:50: "," lastRequested ":" 2019-02-18 19:50: 20 -0500 "," SlugsPrices ": {" disabled ": false}," proOpenHouse ": {" active ": false," end_date ":" 2017-03-20T06: 00: 00.000-04: 00 "}," proFlashSale ": {" active "false," end_date "" 2017-03-23T00: 00: 00.000 to 04: 00 "}" saSource ": null," name "," article "," useSQuoteBackup ": null } "headerConfig": { "noNotificationsMenu": null, "nonFixed": null, "tabless": null, "activeTab": "Dividends"}, "modules": {} "requires": []" trackq ": []," exceptions ": []," gptInit ": false},
Source link