The Walmart Inc (WMT) DCF Valuation: Is The Stock Undervalued?

Johnny HopkinsStock ScreenerLeave a Comment

As part of a new series, each week we typically conduct a DCF on one of the companies in our screens. This week we thought we’d take a look at one of the stocks that are not currently in our screens, Walmart Inc (WMT).

Profile

Walmart serves as the preeminent retailer in the United States, with its strategy predicated on superior operating efficiency and offering the lowest priced goods to consumers to drive robust store traffic and product turnover. Walmart augmented its low-price business strategy by offering a convenient one-stop shopping destination with the opening of its first supercenter in 1988.Today, Walmart operates over 4,700 stores in the United States (5,300 including Sam’s Club) and over 10,000 stores globally. Walmart generated over $420 billion in domestic namesake sales last year, with Sam’s Club contributing another $84 billion to the firm’s top line. Internationally, Walmart generated $100 billion in sales. The company serves around 240 million customers globally each week.

Recent Performance

Over the past twelve months the share price is up 13.04%.

WMT Chart

WMT; data by YCharts

Inputs

  • Discount Rate: 5.9%
  • Terminal Growth Rate: 2%
  • WACC: 5.9%

Forecasted Free Cash Flows (FCFs)

Year FCF (billions) PV(billions)
2024 18.78 17.73
2025 19.61 17.49
2026 20.49 17.25
2027 21.6 17.17
2028 23 17.27

Terminal Value

Terminal Value = FCF * (1 + g) / (r – g) = 601.54 billion

Present Value of Terminal Value

PV of Terminal Value = Terminal Value / (1 + WACC)^5 = 451.63 billion

Present Value of Free Cash Flows

Present Value of FCFs = ∑ (FCF / (1 + r)^n) = 86.91 billion

Enterprise Value

Enterprise Value = Present Value of FCFs + Present Value of Terminal Value = 538.55 billion

Net Debt

Net Debt = Total Debt – Total Cash = 68.07 billion

Equity Value

Equity Value = Enterprise Value – Net Debt = 470.48 billion

Per-Share DCF Value

Per-Share DCF Value = Enterprise Value / Number of Shares Outstanding = $174.70

Conclusion

DCF Value Current Price Margin of Safety
$174.70 $163.24 6.56%

Based on the DCF valuation, the stock is undervalued. The DCF value of $174.70 per share is higher than the current market price of $163.24. The Margin of Safety is 6.56%.

It is important to note that this valuation is based on a number of assumptions, and these assumptions could change in the future. This valuation is meant to be a back-of-the-envelope analyse that could be used as a starting point in a much more thorough valuation process. As a result, it is important to do your own research before making any investment decision.

For all the latest news and podcasts, join our free newsletter here.

FREE Stock Screener

Don’t forget to check out our FREE Large Cap 1000 – Stock Screener, here at The Acquirer’s Multiple:

unlimited

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.