caseism

Valuing Wal-Mart Stock Case Solution & Answer

Home » Case Study Analysis Solutions » Valuing Wal-Mart Stock

An investment adviser from a major brokerage firm asked whether to recommend Wal-Mart customers who currently have shares in their portfolios. Students will be presented with the basic concepts of the evaluation, including the dividend discount model, the price-earnings model and applications of the model measurement of financial assets. by Stephen R. Foerster Source: Ivey Publishing 14 pages. Release: September 23, 2009. Prod #: 906N09-PDF-ENG Assessing Wal-Mart Stock Case Solution

Related Case Solutions:

Default Thumbnail

LOOK FOR A FREE CASE STUDY SOLUTION

A business journal from the Wharton School of the University of Pennsylvania

Where’s the Value? An Inside Look at Walmart’s Flipkart Deal

May 14, 2018 • 18 min read.

The $16 billion transaction says a lot about India’s e-commerce ecosystem, writes former Snapdeal exec Rajat Kumar in this opinion piece.

walmart stock valuation case study

  • Finance & Accounting

Rajat Kumar, COO of ABP Digital, who previously had a leadership role at the Indian e-commerce company Snapdeal and was a consultant at McKinsey, writes in this opinion piece that Walmart’s $16 billion deal to buy online retailer Flipkart says a lot about India’s e-commerce ecosystem.

Walmart’s much-anticipated $16 billion acquisition of Flipkart, India’s top e-commerce retailer , which was announced last week, brings to mind the opening lines from Charles Dickens’ A Tale of Two Cities : “It was the best of times, it was the worst of times; it was the age of wisdom, it was the age of foolishness; it was the epoch of belief, it was the epoch of incredulity; it was the season of light, it was the season of darkness; it was the spring of hope, it was the winter of despair.” The deal is all those things — and more.

Hardly two years ago, Flipkart was being written off in VC circles. Back then growth was slowing, unit economics and profitability remained dreams, the Amazon juggernaut was gaining market share, and markdowns by current investors signalled to the rest of the investing community that the company was overvalued. At the center of it all was Tiger Global, a New York City-based hedge fund that had bet big on Flipkart and was worried about its Indian investments. In 2017 Kalyan Krishnamurthy, who had previously worked as a director at Tiger Global, became Flipkart’s CEO, replacing the founders, Sachin and Binny Bansal. The taps on discounts were opened; the focus on mobile phone sales was sharpened; and that was enough to woo SoftBank Vision Fund, the biggest of the big fish, which invested $2.5 billion.

Now, two blockbuster deals later — first with SoftBank , which provided some relief to Tiger, and the second with Walmart, which provides a profitable exit to SoftBank — things have changed, and how. But apart from ESOPs being liquidated and many millionaires being created, let us remember that little of the valuation will find its way to India. Most of the money will move from Walmart to Tiger Global, SoftBank Vision Fund and Accel, which have invested heavily in Flipkart during the past two years. According to media reports , while Tiger Global will make $3 billion on this deal, both SoftBank Vision Fund and Accel will reap substantial windfalls. Flipkart’s Indian founders and employees will end up with a small slice — perhaps around 10%. How I wish there were a bigger India wealth role in this story, but I guess something is better than nothing. Even 10% of $16 billion is not exactly chump change.

More importantly, let us assess what this transaction could mean for Walmart, for Amazon, for the e-commerce ecosystem, for Indian traders and manufacturers and for consumers.

“Walmart’s sourcing might, combined with Flipkart’s e-commerce prowess, can and should be a global play, not just an India play.”

E-Commerce 101

Before we begin, consider some basic facts about e-commerce in India:

  • E-commerce operates in four broad verticals — electronics (including mobile phones); fashion; household stuff (ranging from furniture to bedsheets to brooms); and fast-moving consumer goods (FMCG). Of these, the most sales value comes from electronics, including mobiles, and the most transactions come from fashion.
  • Despite regulations that specify that retail with overseas funding has to be a marketplace (i.e., it cannot sell its own inventory but should only be a platform for other merchants), no barriers prohibit some suppliers (less than 25% of total business on the platform) from being affiliated with the retailer. WS Retail (for Flipkart) and Cloudtail (for Amazon) are examples. This also helps from a customer perspective since the perception of quality is stronger with such branded suppliers.
  • In a typical retail business, the cost of customer acquisition is measured against the long-term value of a customer (driven by his value per order, number of orders, profit per order, typical number of years before churn). I have never heard any e-commerce discussion in India even mention these metrics. The metric I have heard used most often is gross sales value (GSV) perhaps in the absence of another simple metric in a growth business fueled by discounting and loss leadership. By the way, the way GSV is measured changes from company to company. Firms either use maximum retail price or MRP to measure GSV, or the retailer listing price, but I do not know of any company that uses the actual price charged to a consumer for calculating GSV.
  • Since market leadership is measured in terms of GSV, and funding is dependent on it, it is pertinent to note why GSV is important. GSV stems from a classic marketing and finance model, with the assumption that higher sales automatically mean a larger number of consumers. This, in turn, means a higher mind share as well as a stronger bottom line (with the assumption that products should not be sold at a loss).
  • In a typical VC-led high growth industry, this usually does not hold true, and hence in e-commerce, GSV levers and profitability levers are separate from each other. For example, reducing prices by 10% on a mobile phone can usually ensure that GSV for that phone triples, but clearly, it may make a significant dent in the bottom line with no significant long term gain in consumer mind share. (Also, especially for mobile phones, discounts can lead to trade buys kicking in, where offline retailers pick up discounted stock for later reselling at full rates.) Moreover, GSV does not account for the number of returns, which should not only not be counted in sales done on the platform but can also contribute to significant losses because of free returns, damages and frauds.
  • E-commerce has not yet fully captured the imagination of Indian consumers other than those living in metros and big cities. While orders are shipped to smaller cities, the numbers are not commensurate with the share of population living in these parts of the country.
  • E-commerce prices are much lower than those one would get in, say, a mall. However, barring mobile phones, branded products and FMCG, the prices may still not be able to beat prices of shops in local markets. These shops do not pay rent, do not need high profits for owner sustenance, deal in unbranded goods, and may have innovative ways of avoiding taxes such as GST that ordinary mortals may not be able to imagine. In other words, the second rung of e-commerce penetration in India will be a long-drawn affair, unlike the current phase, and will likely take an omni-channel route.

Below, I will discuss the bottom-line impact of the deal on Walmart, which, if one were to go by regulations, should never be a concern since a pure marketplace model as is mandated by regulations is nothing but a technology platform. But by that logic, e-commerce should never have been a loss-making industry in India to begin with, so I would rather base my thoughts on reality rather than on theory.

“How I wish there were a bigger India wealth role in this story, but I guess something is better than nothing.”

Flipkart vs Amazon — and the Value to Walmart

How does Flipkart compare to Amazon in India? Since both companies hold information close to the chest, a broad statement will be inaccurate and inappropriate. Reports suggest that Flipkart leads in GSV over Amazon, while Amazon leads in units sold. Amazon is also believed to have overtaken Flipkart in metros (where the most purchasing power lies).

Flipkart leads in the fashion vertical. Its subsidiaries Myntra and Jabong are completely focused on that industry. Flipkart also leads in mobile phones, which accounts for a significant portion of its total GSV. Moreover, Flipkart has PhonePe, its payments solution, just like Amazon and PayTm have their own solutions. However, Amazon also seems to lead from a consumer share perspective. Reports suggest that Amazon was ahead of Flipkart on browser visits, app downloads and average daily active app users.

So what does Flipkart bring to the table for Walmart (apart from tailwinds about India’s macro story and retail potential, which has been beaten to death)? The implications of gaining leadership in the fashion vertical are that Flipkart has higher bargaining power with suppliers, especially fashion brands. Myntra and Jabong (both owned by Flipkart) are positioned as fashion destinations and not commodity retail destinations. Just this difference in perception automatically means a difference in pricing power.

Fashion prices are not easy to compare across websites, and therefore a price premium can be charged once a consumer starts browsing. For example, what is easier to compare — the price of a Sony Bravia 42-inch television or a sky-blue Arrow full sleeve shirt, size 42 with a specific stripes pattern? Moreover, given the price points, a consumer’s incentive to compare is also lower than in the electronics segment. Hence, fashion is a goldmine from a P&L perspective, if it is done right. If not done right, though, the following costs kick in: Fashion items usually have an unfavorable value-to-shipping cost ratio and also have a higher propensity for return (mismatch in size, color expectations, material expectations, etc). Such return costs are a drag for both the retailer and suppliers.

Moreover, the retailer is stuck with unsold inventory. (Branded fashion deals are usually not done on a marketplace model and there is some level of retailer risk involved.) This imposes a spoilage risk as well as the possibility that unsold inventory may have to be liquidated at a loss. Overall, the Flipkart fashion vertical seems to be doing well, with reports of Myntra looking to break even this year, while maintaining a healthy growth trajectory.

Flipkart’s lead in the mobile market also has significant implications. For one thing, mobile phones are highly amenable to online purchase through e-commerce platforms. They are high value, have high demand, are not bulky and perhaps cost Rs 40 (or $0.75) to ship. Moreover, a consumer who wants to compare multiple models side by side in peace may take two or three visits before making up his mind (and hence would hate pushy salespeople in a physical store). For these reasons, mobile phones were one of the first few items to show significant traction on e-commerce and take significant share from offline retail. Even today, most searches in e-commerce are about mobile phones, which are a significant symbol of identity, especially for Indian youth.

Flipkart is a leading destination for phones in India — be it the deals it has with Motorola or Xiaomi (which Amazon has slowly tried to wrestle into), or just the sheer number of exclusive launches it does in a year. It is now an indispensable site for manufacturers to list their phones. And with the high volume comes high bargaining power on margins. In addition, a lead in mobile phones market share automatically means an entry into a high-turnover segment with further scope to gain share versus offline retail.

“E-commerce has not yet fully captured the imagination of Indian consumers other than those living in metros and big cities.”

The downside, however, is that mobile phones are a double-edged sword; they usually do not make money. In fact, they are loss leaders for e-commerce. Prices are easy to compare and hence there is a simple downward spiral to woo the consumers, even at a loss. The margins are way lower than in fashion, and usually hover around 7% to 10%. While shipping costs are low, losses on account of fraud or returns can be gigantic. And if platforms want exclusive deals with manufacturers, they have to provide sell out targets (usually guaranteed) to gain that exclusivity. This means that the loss on account of unsold inventory may potentially hit the retailer rather than the manufacturer.

In summary, once the Flipkart deal goes through, Walmart will inherit a business that is a leader in both high-margin business (fashion) and high-GSV business (phones). Still, the latter may continue to remain a bigger drain on the bottom line than the former, despite providing a cushion in the vanity metric of GSV.

Did Walmart Overpay?

Much ink has been spilled discussing the $16 billion acquisition price, so it is worth discussing if the valuation was correct. In my view, beauty lies in the eyes of the beholder. From a pure RoI perspective, the valuation may not appear to be justified. However, one must note that most technology businesses have much of their value embedded in terminal value, or in cash flows that appear after a 15-year to 20-year horizon. The exponential growth curve in a growing market makes it very tough to accurately model the right value in such cases. As a result, most venture capitalists speak in terms of revenue multiples rather than EBITDA multiples. The only concern that Walmart may have is how improving unit economics (especially on the electronics side) will impact growth and consequently the value embedded in terminal value.

The bigger question is whether Walmart had a choice: Could it have invested its war chest in India and hoped to reach Flipkart levels organically, choosing the path that Amazon chose earlier? Perhaps it could have, provided it had technology and e-commerce expertise, but the company has not been able to convincingly demonstrate this elsewhere. (For example, Walmart’s plan to collaborate with Bharti to build its retail presence in India did not take off as planned, so perhaps it remains wary of organic plays in India, especially with regulation stacked against it.) Moreover, in such a scenario, it would have to be wary of SoftBank pumping in more money into Flipkart to counter Walmart, or prepping it for listing and using the funds to crush Walmart India before it could gain a proper toehold.

In the medium term, Walmart may be able to do some smart moves with Flipkart. I am sure it has built these factors into its valuation — and if it has not, it should have. Walmart and Flipkart will have better bargaining power with suppliers (imagine the global might of both U.S. and India volumes while negotiating rates with Chinese suppliers). Walmart could also apply its e-commerce lessons from Flipkart and implement them in the U.S and other global plays (Jet.com, etc). I imagine this would have a much greater bearing on Walmart’s thinking than a pure India play. After all, few companies globally have been able to withstand Amazon’s onslaught, as Walmart knows from previous experience. Walmart’s sourcing might, combined with Flipkart’s e-commerce prowess, can and should be a global play, not just an India play.

“Even today, most searches in e-commerce are about mobile phones, which are a significant symbol of identity, especially for Indian youth.”

Implications for Indian Retail

Let’s face it — Indian manufacturing and retail are inefficient. The warped ratio of real estate rents to product value, inefficient transportation and infrastructure, or the sheer number of intermediaries, make the final consumer price way higher than it should ideally be, considering the purchasing power of average Indians. Of course, high tax rates on sales worsen the situation, offset by rampant tax evasion. Having said that, I do not see any immediate implications for the retail sector, except for a tailwind-driven, slow erosion of sales towards e-commerce.

Over time, though, I see this situation as one of which both small retailers and big players like Future Retail (Big Bazaar) should be wary. Apart from both Amazon and Flipkart developing the significant (and automated) warehousing infrastructure that has worked so well in the U.S., and which has a role to play in the Indian context, I imagine that Flipkart under Walmart may test some omni-channel possibilities as well (despite regulatory hurdles), especially seeing the success of DMart and the reach of Big Bazaar. It would also be much better positioned than Future Retail and DMart to open physical stores in smaller towns — purely as a window to e-commerce as well as a means to ease the returns process.

A point that is often missed is that for the first time, all the leading players in Indian retail are strategic players and not VC driven start-ups. This means that the VC pressure that often accompanies a funded start-up to show growth will be replaced by logical, long-term horizon decisions. Be it Flipkart, Amazon, Big Bazaar or DMart, I now foresee a lot more real value creation for consumers, rather than a primarily discount-led play that is nothing but a transfer of value from one player to another. To that extent, I foresee that losses will stabilize, suppliers will be squeezed (beware small manufacturers), and loyalty programs and customer data will play a key role in market share battles. I personally look forward to enjoying the replicas of Cola wars all over again.

I have mixed feelings about what Walmart’s Flipkart deal shows about India’s regulatory direction. Despite clear mandates about not allowing foreign capital in retail unless it is a pure platform play, we now have a situation where Indian e-commerce is pretty much being run on foreign strategic capital. Both Walmart and Amazon have their own store brands as well, and at least in spirit, cannot be called pure platform plays. I would have loved to see an Alibaba being created and sustained in India. It seems, though, that Indian regulations are not geared towards creating homegrown behemoths in the internet age.

China has done a great job in this regard, by not allowing foreign players in internet-driven sectors, thus ensuring the rise of Chinese internet giants such as Alibaba, Baidu and Tencent. Without similar protection, basic economics dictate that established overseas players with deeper pockets will always win an internet platform battle, since by its very nature, the internet is geared towards promoting global monopolies or duopolies. Cases in point: Google, Uber, Amazon, Facebook, AirBnB, etc.

“In summary, once the Flipkart deal goes through, Walmart will inherit a business that is a leader in both high-margin business (fashion) and high-GSV business (phones).”

I have two final comments about the role of capital. No player (even a Big Bazaar) was able to create this kind of scale with Indian capital, so is Indian capital slow to react? Why would a Flipkart even get a chance to rise with both Reliance and Future Retail already present in the market?

My view is that, in general, the Indian mind is not focused on innovation. The education system based on a “repeat after me” style of teaching; the societal mindset which looks down upon a young person doing a summer job in a TGIF or McDonalds; the parental pressure to do a “job” rather than experiment with passion — all these ways of thinking carry forward in a typical Indian work environment. The result is that innovation has limited (or no) budgets allocated; the boss is always right; and no middle manager would want to be in a situation where, despite a grand vision and a potential payoff of billions, the risk of failure can be attributed to him. So, unfortunately, I do not believe that traditional Indian capital is geared towards a 20-year horizon. (I mark Reliance Jio as an exception — but that is a story for another day.)

The big takeaway from the present deal is that deep pockets win. This is a maxim that has been demonstrated over and over again, especially in B2C technology plays. A certain disdain for capital efficiency, a focus on gaining share and a relentless focus on killing competition define today’s leading companies. Flipkart would have been in the news for very different reasons had it not been for the timely fund infusion by SoftBank in 2017. Growth had stalled, the annual burn was high and unit economics were unsustainable. And yet, as part of the strategy of Lee Fixel of Tiger Global and Kalyan Krishnamurthy, Flipkart doubled down on not ceding market share to Amazon, whatever the capital burn. This in turn caught Softbank’s eye (whose earlier investment in Snapdeal was not working to its expectations).

As a result, Flipkart is now touted as a poster child of Indian start-ups. The critical question in today’s age, which may require some rewriting of textbooks, is: What comes first, the business plan or the capital? Walmart’s Flipkart deal suggests it is the latter.

More From Knowledge at Wharton

walmart stock valuation case study

Why Do Stocks Trade at Such Different Multiples or Valuation Ratios?

walmart stock valuation case study

How Financial Frictions Hinder Innovation

walmart stock valuation case study

The U.S. Housing Market Has Homeowners Stuck | Lu Liu

Looking for more insights.

Sign up to stay informed about our latest article releases.

The Case Centre logo

Product details

walmart stock valuation case study

  • Today's news
  • Reviews and deals
  • Climate change
  • 2024 election
  • Fall allergies
  • Health news
  • Mental health
  • Sexual health
  • Family health
  • So mini ways
  • Unapologetically
  • Buying guides

Entertainment

  • How to Watch
  • My Portfolio
  • Latest News
  • Stock Market
  • Premium News
  • Biden Economy
  • EV Deep Dive
  • Stocks: Most Actives
  • Stocks: Gainers
  • Stocks: Losers
  • Trending Tickers
  • World Indices
  • US Treasury Bonds
  • Top Mutual Funds
  • Highest Open Interest
  • Highest Implied Volatility
  • Stock Comparison
  • Advanced Charts
  • Currency Converter
  • Basic Materials
  • Communication Services
  • Consumer Cyclical
  • Consumer Defensive
  • Financial Services
  • Industrials
  • Real Estate
  • Mutual Funds
  • Credit cards
  • Balance Transfer Cards
  • Cash-back Cards
  • Rewards Cards
  • Travel Cards
  • Personal Loans
  • Student Loans
  • Car Insurance
  • Morning Brief
  • Market Domination
  • Market Domination Overtime
  • Opening Bid
  • Stocks in Translation
  • Lead This Way
  • Good Buy or Goodbye?
  • Fantasy football
  • Pro Pick 'Em
  • College Pick 'Em
  • Fantasy baseball
  • Fantasy hockey
  • Fantasy basketball
  • Download the app
  • Daily fantasy
  • Scores and schedules
  • GameChannel
  • World Baseball Classic
  • Premier League
  • CONCACAF League
  • Champions League
  • Motorsports
  • Horse racing
  • Newsletters

New on Yahoo

  • Privacy Dashboard

Yahoo Finance

Walmart (wmt) is a top-ranked value stock: should you buy.

For new and old investors, taking full advantage of the stock market and investing with confidence are common goals.

Achieving those goals is made easier with the Zacks Style Scores, a unique set of guidelines that rates stocks based on popular investing methodologies, namely value, growth, and momentum. The Style Scores can help you narrow down which stocks are better for your portfolio and which ones can beat the market over the long-term.

Why Investors Should Pay Attention to This Value Stock

Value investors love finding good stocks at good prices, especially before the broader market catches on to a stock's true value. Utilizing ratios like P/E, PEG, Price/Sales, and Price/Cash Flow, the Value Style Score identifies the most attractive and most discounted stocks.

Walmart (WMT)

Walmart Inc. has evolved from just being a traditional brick-and-mortar retailer into an omnichannel player. In this regard, acquisitions; partnerships; delivery programs like Walmart + and Express Delivery; and investment in online e-commerce platform Flipkart are noteworthy. These position the company to keep pace with the changing retail ecosystem and stay firm in the presence of rivals like Amazon and Target. Markedly, Walmart’s product offerings include almost everything from grocery to cosmetics, electronics to stationery, home furnishings to health and wellness products, and apparel to entertainment products, to name a few.

WMT is a Zacks Rank #2 (Buy) stock, with a Value Style Score of B and VGM Score of A. Shares are currently trading at a forward P/E of 25X for the current fiscal year compared to the Retail - Supermarkets industry's P/E of 12.3X. Additionally, WMT has a PEG Ratio of 3.8 and a Price/Cash Flow ratio of 15.9X. Value investors should also note WMT's Price/Sales ratio of 0.7X.

A company's earnings performance is important for value investors as well. For fiscal 2025, one analyst revised their earnings estimate higher in the last 60 days for WMT, while the Zacks Consensus Estimate has increased $0.02 to $2.36 per share. WMT also holds an average earnings surprise of 7.3%.

WMT should be on investors' short lists because of its impressive earnings and valuation fundamentals, a good Zacks Rank, and strong Value and VGM Style Scores.

Want the latest recommendations from Zacks Investment Research? Today, you can download 7 Best Stocks for the Next 30 Days. Click to get this free report

Walmart Inc. (WMT) : Free Stock Analysis Report

To read this article on Zacks.com click here.

Zacks Investment Research

TheCaseSolutions.com

  • Order Status
  • Testimonials
  • What Makes Us Different

VALUING WAL-MART STOCK Harvard Case Solution & Analysis

Home >> Harvard Case Study Analysis Solutions >> VALUING WAL-MART STOCK

VALUING WAL-MART STOCK Case Solution

Determine the intrinsic value of Wal-Mart (price P0) using the dividend discount Model (DDM). Assess the value based on two forms of the DDM: the constant growth version, an assessment based on three years of projected dividends and a projected future stock price. Clearly state any assumptions you make to calculate the intrinsic price, including an estimation of Wal-Mart investor required returns from the Capital Asset Pricing Model (CAPM).

The dividend discount model relates the current share price to the current value of its future cash flows. It depends on projections of potential capitalization rates of the extra cash flows and company growth rate. The change in capitalization rate or growth rates will reflect the change in intrinsic value for the stock.

valuing walmart stock case solution

valuing walmart stock case solution

Three Intrinsic values of Walmart have been calculated using dividend discount model. The first reflects its constant growth version; second intrinsic value was calculated by taking 17 years of data and the last intrinsic value was calculated using the three years of data. The first intrinsic value of Walmart is 18.9 using dividends at perpetuity. The intrinsic value was calculated using the formula P0=D1/(Ke– g). Taking D1 as 1, The Dividend from the year 2010 was taken

Ke = 19.65%

The value of expected investors’ rate of return is calculated using data of 2010, this return on equity is CAPM, whichwe calculated using formula (net income/sales)*(sales/ total assets)*(total assets/ equity).

CAPM= .035*2.37*2.34 = 19.6%

While the dividend rate is 13.8% By using formula P0=D1/(Ke– g), we get 18.86

The second intrinsic value of Walmart is calculated by using 17 years data provided in excel sheet is 27.7. Using the formula P0=D1/(1+Ke)1+D2/(1+Ke)2+….+Dn/(1+Ke)n+Pn/(1+Ke)n Third intrinsic value is 53.6 by using the terminal value and a data set of three years. The. values taken in this case are calculated in the excel sheet provided with write-up.

Dividendyield 2% Rf 3.68% Rm 5% β 0.665

ke 20% g 14% D 1.09 Po (perp) 18.86420072

P0 - 17 years 27.68471533 P0 - 3 years 53.63364516........................

This is just a sample partial case solution. Please place the order on the website to order your own originally done case solution.

Related Case Solutions & Analyses:

walmart stock valuation case study

Hire us for Originally Written Case Solution/ Analysis

Like us and get updates:.

Harvard Case Solutions

Search Case Solutions

  • Accounting Case Solutions
  • Auditing Case Studies
  • Business Case Studies
  • Economics Case Solutions
  • Finance Case Studies Analysis
  • Harvard Case Study Analysis Solutions
  • Human Resource Cases
  • Ivey Case Solutions
  • Management Case Studies
  • Marketing HBS Case Solutions
  • Operations Management Case Studies
  • Supply Chain Management Cases
  • Taxation Case Studies

More From Harvard Case Study Analysis Solutions

  • Matters of Life and Death: Defending Organ Transplants in the State of Arizona
  • AIRPORT OPERATIONS ASSIGNMENT
  • Tenex Greenhouse Investors
  • DLC Management Corporation: Securing Its Future
  • Market Consolidation In The Telecommunication Sector Will Lime Survive
  • Business Crime: What To Do When the Law Pursues You (with updates by John L. Akula)

Contact us:

walmart stock valuation case study

Check Order Status

Service Guarantee

How Does it Work?

Why TheCaseSolutions.com?

walmart stock valuation case study

Revenue Growth Forecast

While earnings growth is arguably the most superior indicator of a company's financial health, nothing happens as such if a business isn't able to grow its revenues. After all, it's nearly impossible for a company to increase its earnings for an extended period without increasing its revenues. So, it's important to know a company's potential revenue growth.

In the case of Walmart, the consensus sales estimate of $159.17 billion for the current quarter points to a year-over-year change of +4.5%. The $672.55 billion and $699.6 billion estimates for the current and next fiscal years indicate changes of +3.8% and +4%, respectively.

Last Reported Results and Surprise History

Walmart reported revenues of $173.39 billion in the last reported quarter, representing a year-over-year change of +5.7%. EPS of $0.60 for the same period compares with $0.57 a year ago.

Compared to the Zacks Consensus Estimate of $170.64 billion, the reported revenues represent a surprise of +1.61%. The EPS surprise was +9.09%.

Over the last four quarters, Walmart surpassed consensus EPS estimates three times. The company topped consensus revenue estimates each time over this period.

Without considering a stock's valuation, no investment decision can be efficient. In predicting a stock's future price performance, it's crucial to determine whether its current price correctly reflects the intrinsic value of the underlying business and the company's growth prospects.

Comparing the current value of a company's valuation multiples, such as its price-to-earnings (P/E), price-to-sales (P/S), and price-to-cash flow (P/CF), to its own historical values helps ascertain whether its stock is fairly valued, overvalued, or undervalued, whereas comparing the company relative to its peers on these parameters gives a good sense of how reasonable its stock price is.

The Zacks Value Style Score (part of the Zacks Style Scores system), which pays close attention to both traditional and unconventional valuation metrics to grade stocks from A to F (an An is better than a B; a B is better than a C; and so on), is pretty helpful in identifying whether a stock is overvalued, rightly valued, or temporarily undervalued.

Walmart is graded C on this front, indicating that it is trading at par with its peers. Click here to see the values of some of the valuation metrics that have driven this grade.

The facts discussed here and much other information on Zacks.com might help determine whether or not it's worthwhile paying attention to the market buzz about Walmart. However, its Zacks Rank #3 does suggest that it may perform in line with the broader market in the near term.

Zacks Investment Research

walmart stock valuation case study

Walmart Inc. (WMT) Is a Trending Stock: Facts to Know Before Betting on It

Walmart (WMT) has been one of the most searched-for stocks on Zacks.com lately. So, you might want to look at some of the facts that could shape the stock's performance in the near term.

Over the past month, shares of this world's largest retailer have returned +0.6%, compared to the Zacks S&P 500 composite's +0.2% change. During this period, the Zacks Retail - Supermarkets industry, which Walmart falls in, has gained 0.9%. The key question now is: What could be the stock's future direction?

Although media reports or rumors about a significant change in a company's business prospects usually cause its stock to trend and lead to an immediate price change, there are always certain fundamental factors that ultimately drive the buy-and-hold decision.

Earnings Estimate Revisions

Here at Zacks, we prioritize appraising the change in the projection of a company's future earnings over anything else. That's because we believe the present value of its future stream of earnings is what determines the fair value for its stock.

Our analysis is essentially based on how sell-side analysts covering the stock are revising their earnings estimates to take the latest business trends into account. When earnings estimates for a company go up, the fair value for its stock goes up as well. And when a stock's fair value is higher than its current market price, investors tend to buy the stock, resulting in its price moving upward. Because of this, empirical studies indicate a strong correlation between trends in earnings estimate revisions and short-term stock price movements.

For the current quarter, Walmart is expected to post earnings of $0.52 per share, indicating a change of +6.1% from the year-ago quarter. The Zacks Consensus Estimate has changed +0.1% over the last 30 days.

The consensus earnings estimate of $2.36 for the current fiscal year indicates a year-over-year change of +6.3%. This estimate has remained unchanged over the last 30 days.

For the next fiscal year, the consensus earnings estimate of $2.55 indicates a change of +8.1% from what Walmart is expected to report a year ago. Over the past month, the estimate has remained unchanged.

Having a strong externally audited track record, our proprietary stock rating tool, the Zacks Rank, offers a more conclusive picture of a stock's price direction in the near term, since it effectively harnesses the power of earnings estimate revisions. Due to the size of the recent change in the consensus estimate, along with three other factors related to earnings estimates, Walmart is rated Zacks Rank #3 (Hold).

The chart below shows the evolution of the company's forward 12-month consensus EPS estimate:

12 Month EPS

Revenue Growth Forecast

While earnings growth is arguably the most superior indicator of a company's financial health, nothing happens as such if a business isn't able to grow its revenues. After all, it's nearly impossible for a company to increase its earnings for an extended period without increasing its revenues. So, it's important to know a company's potential revenue growth.

In the case of Walmart, the consensus sales estimate of $159.17 billion for the current quarter points to a year-over-year change of +4.5%. The $672.55 billion and $699.6 billion estimates for the current and next fiscal years indicate changes of +3.8% and +4%, respectively.

Last Reported Results and Surprise History

Walmart reported revenues of $173.39 billion in the last reported quarter, representing a year-over-year change of +5.7%. EPS of $0.60 for the same period compares with $0.57 a year ago.

Compared to the Zacks Consensus Estimate of $170.64 billion, the reported revenues represent a surprise of +1.61%. The EPS surprise was +9.09%.

Over the last four quarters, Walmart surpassed consensus EPS estimates three times. The company topped consensus revenue estimates each time over this period.

Without considering a stock's valuation, no investment decision can be efficient. In predicting a stock's future price performance, it's crucial to determine whether its current price correctly reflects the intrinsic value of the underlying business and the company's growth prospects.

Comparing the current value of a company's valuation multiples, such as its price-to-earnings (P/E), price-to-sales (P/S), and price-to-cash flow (P/CF), to its own historical values helps ascertain whether its stock is fairly valued, overvalued, or undervalued, whereas comparing the company relative to its peers on these parameters gives a good sense of how reasonable its stock price is.

The Zacks Value Style Score (part of the Zacks Style Scores system), which pays close attention to both traditional and unconventional valuation metrics to grade stocks from A to F (an An is better than a B; a B is better than a C; and so on), is pretty helpful in identifying whether a stock is overvalued, rightly valued, or temporarily undervalued.

Walmart is graded C on this front, indicating that it is trading at par with its peers. Click here to see the values of some of the valuation metrics that have driven this grade.

The facts discussed here and much other information on Zacks.com might help determine whether or not it's worthwhile paying attention to the market buzz about Walmart. However, its Zacks Rank #3 does suggest that it may perform in line with the broader market in the near term.

To read this article on Zacks.com click here.

12-month consensus EPS estimate for WMT _12MonthEPSChartUrl

Judge Hearing Noncompete Cases Holds Stock in Companies That Use Noncompetes

Judge J. Campbell Barker’s stock portfolio is a spreadsheet full of conflicts of interest.

by David Dayen

May 9, 2024

Dayen-J. Campbell Barker 050924.png

Senate Judiciary Committee

J. Campbell Barker testifies before the Senate Judiciary Committee during his confirmation hearing to be U.S. district judge for the Eastern District of Texas, May 9, 2018.

We all know the drill by now: A federal agency finalizes a rule to make people’s lives a bit better, a business gets offended because the rule might slightly eat into their record profits, and the Chamber of Commerce files a lawsuit in Texas, automatically drawing a reliably conservative judge. It looks like we’re now going to have to add a part four to this pattern: The judge holds stocks in companies with a material interest in the rule.

Meet Judge J. Campbell Barker, a Donald Trump appointee who is presiding over the Chamber’s challenge to the Federal Trade Commission’s ban on noncompete agreements . The watchdog group Accountable.US revealed yesterday that Barker, as of his most recent financial disclosure form , which covers up to the end of 2022, owns as much as $665,000 in the stock of three companies that regularly use noncompetes to prevent employees from leaving for competitors.

This includes up to $65,000 in Amazon, which has routinely sued to enforce its noncompete agreements in the past; between $250,000 and $500,000 in Apple, which despite a no-poaching scandal when Steve Jobs was CEO continues to attack employees for breaking noncompete agreements; and between $50,000 and $100,000 in IBM, a board member of the Chamber of Commerce, which has also attempted to sue former employees for leaving for rivals.

More from David Dayen

Many of the Amazon, Apple, and IBM noncompete cases involved personnel whose agreements would likely still be enforceable under the FTC’s ban, as noncompetes for senior executives are grandfathered in. However, new senior executives would not have to sign noncompete agreements. The FTC ban still allows for litigation over the deliberate release of confidential information to competing firms, under trade secrets laws.

The Chamber of Commerce’s noncompete case is currently on hold because of the “first to file” rule. Ryan LLC, a tax services company run by a former tax adviser to Donald Trump , filed its challenge to the noncompete ban hours before the Chamber. Ryan LLC may or may not be a member of the Chamber, which would make consolidating the cases more likely. When Judge Barker asked Ryan whether they have membership in the Chamber, the company “refuse[d] to disclose” that information to the judge, according to a court filing.

After the Ryan case is adjudicated, it is expected that the Chamber’s case will resume, with Judge Barker as the presiding judge. “The corporate-funded U.S. Chamber is counting on Barker not to recuse despite his clear conflicts of interest,” said Liz Zelnick of Accountable.US. “It’s all part of the Chamber’s longtime legal strategy of venue shopping industry lawsuits in courtrooms of least resistance.”

Judge Barker’s financial disclosure is a case study in why judges should maybe not be allowed to own individual stocks. His holdings are not limited to Amazon, Apple, and IBM, but also include stock in AbbVie, American Electric Power, Caterpillar, CenterPoint Energy, Chevron, Clorox, Coinbase, Constellation Energy, Costco, Dominion Energy, Duke Energy, Entergy, ExxonMobil, FirstEnergy, International Paper, Johnson & Johnson, Kraft Heinz, Lockheed Martin, McDonald’s, Merck, Occidental Petroleum, Pfizer, Procter & Gamble, Royal Dutch Shell, Schlumberger, Southern Company, Target, Texas Instruments, and Walmart. These are held in five different brokerage accounts; in some cases, Barker holds stock in the same company in multiple accounts.

Chevron, Entergy, FirstEnergy, ExxonMobil, Royal Dutch Shell, Southern Company, and Texas Instruments have all disclosed in the recent past that they are members of the Chamber of Commerce, the plaintiff in the case.

Several of Barker’s stock holdings are in companies that were clients of the law firm Yetter Coleman, where he worked as an associate and then partner between 2011 and 2015. Those clients include Chevron and IBM, the Chamber board member with a history of using and enforcing noncompete agreements.

Barker also holds several cryptocurrencies, including Bitcoin, Ethereum, and Dogecoin.

This is a potential minefield of conflicts of interest for any federal judge. But that’s especially the case for any judge in federal district court in Texas, where every business group happily files with the secure knowledge that their judge will be as conservative and pro-business as all get-out.

Indeed, Judge Barker routinely rules in cases affecting big business. In 2021, he struck down the Biden administration’s eviction moratorium, which benefited landlords. Last year, he ruled against the Consumer Financial Protection Bureau’s attempts to enforce anti-discrimination laws in the banking industry through its examination manual. In March, he struck down the National Labor Relations Board’s joint-employer rule, which aims to hold franchisors accountable in matters of employment.

As you can see above, Judge Barker literally owns stock in McDonald’s (albeit less than $15,000 worth). His portfolio—unless he’s sold every one of those stocks in the past 16 months—is bound to run into the cases he hears on a regular basis.

It would obviously be less problematic if judges were confined to index funds. Judge Barker obviously sees their value, because he owns at least a half million dollars in them, according to the disclosure.

There is definitely an alternate universe where a judge’s financial ties to the businesses that have material interests in the cases he hears would be disqualifying. It’s just not the universe we live in, where recusals are entirely up to the conflicted judge in question.

You can count on the Prospect , can we count on you?

There's no paywall here. Your donations power our newsroom as we report on ideas, politics and power — and what’s really at stake as we navigate another presidential election year. Please, become a member , or make a one-time donation , today. Thank you!

walmart stock valuation case study

About the Prospect / Contact Info

Browse Archive / Back Issues

Subscription Services

Privacy Policy

DONATE TO THE PROSPECT

walmart stock valuation case study

Copyright 2023 | The American Prospect, Inc. | All Rights Reserved

COMMENTS

  1. Walmart case solution

    Price of Wal-Mart stock = Projected EPS * Forward P/E: = 413 = $55. Industry average price = Industry P/E * Projected EPS: = 144 = $58. So, the current value of Wal-Mart's stock price according to the Price/Earnings approach model comes as $55. ANALYSIS OF WAL-MART'S VALUATION: Stock price of Wal-Mart according to recent close = $53.

  2. Valuing Wal-Mart 2010

    This case achieves the following objectives: Discusses the role of and techniques employed by equity analysts; Introduces students to the valuation of a stock using variants of the dividend discount model (DDM); Introduces students to the price-earnings (P/E) multiple model; Illustrates the application of the capital asset pricing model (CAPM); Introduces students to the use of a variety of ...

  3. Valuing Wal-Mart 2010

    We have evaluated Wal-Mart's stock value using five methods, which are DDM, two-stage DDM, three-stage DDM, P/E ratio, and FCFE. However, we choose three-stage DDM as the best method to value stock. Such a method can evaluate the stock at $89.34 while the current price is $53.45. This means Wal-Mart's stock price is supposed to be $89.34 ...

  4. PDF The valuation of Wal-Mart

    The case offers multiple alternative methods to reach the projected stock valuation for Wal-Mart. The methods that this case will utilize is the dividend discount model, the Capital Asset Pricing Model (CAPM), and the P/E multiples. We will utilize these methods in order to obtain a valuation of Wal-Mart in order to offer suggested courses of ...

  5. Valuing Wal-Mart Stock by Stephen R. Foerster :: SSRN

    An investment advisor at a major brokerage is considering whether she should recommend Wal-Mart stock to her clients who do not currently have this stock in their portfolios. Students will be presented with basic valuation concepts including the dividend discount model, price-earnings model and applications of the capital asset pricing model.

  6. Valuing Wal-Mart 2010

    An equity analyst uses a variety of methods to value Wal-Mart shares with a view to making a buy/sell or hold recommendation for the stock. Her key task is to use an intrinsic value approach to price the shares and to then compare the resulting price with the price at which the stock is traded in the market.

  7. A Case Study: Wal-Mart's Returns Over the Past Decade

    Happily, you look at your brokerage statement to see $5015 worth of Wal-Mart stock that you anticipate doubling in value. Unfortunately for you, in 2001, Wal-Mart was posting earnings of $1.50 per ...

  8. Valuing Wal-Mart Stock Case Study Solution for Harvard HBR Case Study

    Prod #: 906N09-PDF-ENG Assessing Wal-Mart Stock Case Solution. Related Case Solutions: Sally Jameson-1999 Valuing Wal-Mart Stock Valuing Wal-Mart Stock VALUING WAL-MART STOCK Valuing Wal-Mart 2010 Valuing Coca Cola Stock Sally Jameson: ... JUST REGISTER NOW AND GET 50% OFF ON EACH CASE STUDY .

  9. Read the case study, "Valuing Wal-Mart Stock" from the Harvard

    Introduction: The case study "Valuing Wal-Mart Stock" by Professor Stephen R. Foerster in 2006 discusses the financial health of Wal-Mart, one of the largest retailers in the world. The major findings of the case study include assessing Wal-Mart's financial health using financial ratios, calculating the intrinsic value of Wal-Mart per share using the dividend discount model and price-earnings ...

  10. PDF A Value Perspective: the Case of Warren Buffet and His Investment

    Walmart (WMT). These investment decisions will be used to illustrate how the principles of security analysis proposed by Graham were adopted and acted on by Buffett. In sum, the paper is a case study which examines value investing through the application of theory by a prominent practitioner.

  11. Estimating Walmart's Cost of Capital

    This case has been designed for use in finance courses at both the undergraduate and graduate levels to discuss cost of capital. It can be placed in a section on capital investments and projects or near the beginning of a section on valuation. The case may be preceded by a 30- to 45-minute lecture or discussion on cost of capital theory.

  12. Solved Read the case study, "Valuing Wal-Mart Stock" from

    Determine the intrinsic value of Wal-Mart (on a per share basis) Read the case study, "Valuing Wal-Mart Stock" from the Harvard Business written by Professor Stephen R. Foerster in 2006. In your case study analysis, answer all elements of the following questions. Use stock valuation information from the case only, not current information ...

  13. Solved Read the case study, "Valuing Wal-Mart Stock" from

    Question: Read the case study, "Valuing Wal-Mart Stock" from the Harvard Business written by Professor Stephen R. Foerster in 2006. In your case study analysis, answer all elements of the following questions. Use stock valuation information from the case only, not current information available online. Compare your DDM and P/E valuations.

  14. PDF Business Model Evaluation: Quantifying Walmart's Sources of Advantage

    academic papers, case studies, and books about Walmart to describe the company's business model choices over time. Second, we implement the quantitative model in order to determine the effect of Walmart's choices on its performance. The results reveal that while Walmart's business model did not change during the 36-

  15. Where's the Value? An Inside Look at Walmart's Flipkart Deal

    Where's the Value? An Inside Look at Walmart's Flipkart Deal May 14, 2018 • 18 min read. The $16 billion transaction says a lot about India's e-commerce ecosystem, writes former Snapdeal ...

  16. PDF Real Vision Investment Case Study

    Introduction. This study investigates the relative returns from long-term investment into Walmart and. Amazon. The question about comparability is difficult for two primary reasons. First, the ...

  17. WALMART CASE STUDY.docx

    Valuing Wal-Mart 2010 Case Gianluca Sordano, Alessandra Ravetta iii. Discounted Cash Flows Model Our team considers it fundamental to add another model to value Wal-Mart stock in order to provide a comprehensive valuation. It is clear that in order to perform an analysis based on future cash flows, many assumptions have to be made, but nonetheless we believe this is the best way to proceed.

  18. Valuing Wal-Mart Stock

    An investment advisor at a major brokerage is considering whether she should recommend Wal-Mart stock to her clients who do not currently have this stock in their portfolios. Students will be presented with basic valuation concepts including the dividend discount model, price-earnings model and applications of the capital asset pricing model.

  19. Walmart (WMT) is a Top-Ranked Value Stock: Should You Buy?

    Markedly, Walmart's product offerings include almost everything from grocery to cosmetics, electronics to stationery, home furnishings to health and wellness products, and apparel to ...

  20. VALUING WAL-MART STOCK Case Solution And Analysis, HBR Case Study

    VALUING WAL-MART STOCK Case Solution. Determine the intrinsic value of Wal-Mart (price P0) using the dividend discount Model (DDM). Assess the value based on two forms of the DDM: the constant growth version, an assessment based on three years of projected dividends and a projected future stock price. Clearly state any assumptions you make to calculate the intrinsic price, including an ...

  21. Factors Influencing Organization Success: A Case Study of Walmart

    A longitudinal case study of Amazon's financial situation during the 2016-2020 period, and time-series analysis, ratio analysis, and DuPont analysis, are employed as a quantitative methodology ...

  22. Walmart Inc. (WMT) Is a Trending Stock: Facts to Know ...

    In the case of Walmart, the consensus sales estimate of $159.17 billion for the current quarter points to a year-over-year change of +4.5%. The $672.55 billion and $699.6 billion estimates for the current and next fiscal years indicate changes of +3.8% and +4%, respectively. Last Reported Results and Surprise History.

  23. Walmart Inc. (WMT) Is a Trending Stock: Facts to Know Before ...

    The $672.55 billion and $699.6 billion estimates for the current and next fiscal years indicate changes of +3.8% and +4%, respectively. Last Reported Results and Surprise History. Walmart reported ...

  24. PDF Walmart-Flipkart Acquisition: a case study

    Case Study Walmart-Flipkart Acquisition: a case study Amity Business School, Amity University, India Available ... Walmart while acquiring Flipkart. iii. To study the reasons of high valuation of Flipkart despite of it being a loss company. Parties to the Deal Walmart: Walmart Inc is an American multinational retail company which was originated ...

  25. Morgan Stanley Direct Lending Fund 2024 Q1

    Top Value Stocks; Top Small Cap Stocks; ... Tesla Stock: Rich Valuation Faces Reality Check. ... Trending News. 1. Catalyst Watch: Retail heavyweights Walmart and Home Depot report, OpenAI vs ...

  26. Judge Hearing Noncompete Cases Holds Stock in Companies That Use

    The watchdog group Accountable.US revealed yesterday that Barker, as of his most recent financial disclosure form, which covers up to the end of 2022, owns as much as $665,000 in the stock of three companies that regularly use noncompetes to prevent employees from leaving for competitors. This includes up to $65,000 in Amazon, which has ...

  27. Why Axsome Therapeutics Stock Is A Promising Stock Pick In CNS

    Its main value driver is Auvelity, approved in 2022 for major depressive disorder [MDD]. Executives forecast peak sales of $1 to $3 billion for this particular drug.

  28. Savers Value Village, Inc. (SVV) Q1 2024 Earnings Call Transcript

    Savers Value Village, Inc. (NYSE:SVV) Q1 2024 Earnings Conference Call May 9, 2024 4:30 PM ETCompany Participants. Mark Walsh - Chief Executive Officer Jubran Tanious - President & Chief Operating ...