Valuing Walmart: A Beginner Walkthrough
Walmart remains one of the world's largest retailers, serving millions of customers daily and generating consistent cash flows that make it an excellent case study for learning valuation. Unlike speculative growth stocks, Walmart's mature business model, predictable earnings, and steady dividend provide clear signals for fundamental investors. This walkthrough demonstrates how to apply multiple valuation approaches to arrive at a fair value estimate.
Quick definition
Walmart valuation is the process of estimating the intrinsic value of Walmart Inc. (ticker: WMT) by analyzing its financial statements, cash flow generation, competitive advantages, and growth prospects using methods such as discounted cash flow analysis, price-to-earnings multiples, and dividend discount models.
Key takeaways
- Walmart's dividend history and stable cash flows make it suitable for dividend discount model valuation
- A DCF analysis requires assumptions about revenue growth, margin trends, and terminal value
- Comparable company multiples (P/E, EV/EBITDA) provide a market reality check
- Sensitivity analysis reveals which assumptions most impact fair value estimates
- Walmart's moat comes from scale, operational efficiency, and customer loyalty, not growth
- Multiple valuation methods should converge to similar conclusions for confidence
The business model and why it matters
Walmart's business model fundamentally differs from growth-stage tech companies. The retailer generates revenue through scale—operating thousands of stores worldwide and moving massive volumes of inventory at thin margins. Understanding this is crucial because it shapes which valuation method works best.
The company operates three main segments: Walmart U.S., Walmart International, and Sam's Club. Walmart U.S. accounts for roughly 60–65% of revenue and operates hypermarkets, supercenters, neighborhood markets, and increasingly, e-commerce fulfillment. This diversification within retail reduces dependency on any single channel.
Walmart's competitive advantages—often called "moats"—aren't about innovation or brand mystique. Instead, they rest on:
Scale advantages: Walmart's purchasing power forces suppliers to offer better terms. The company buys such enormous volumes that it can negotiate discounts unavailable to competitors. This translates directly to lower cost of goods sold and higher margins than smaller retailers.
Operational efficiency: Decades of optimizing supply chains, logistics, and store operations mean Walmart moves inventory faster and with less waste. Every percentage point improvement in inventory turns represents millions in recovered capital.
Customer loyalty through price: While not a "brand moat" like Coca-Cola, Walmart's position as the low-price leader creates habitual purchasing. Customers return because they trust everyday low prices (EDLP strategy).
These moats don't generate explosive growth, but they provide stability. Walmart's revenue grows 3–6% annually, and margins expand modestly through efficiency gains, not price increases.
Gathering financial data
Begin by collecting Walmart's audited financial statements from the past five years. Download the 10-K from the SEC's EDGAR database or from Walmart's investor relations website. You'll need:
Income statement items: Total revenue, cost of goods sold, operating expenses, operating income (EBIT), interest expense, taxes, and net income.
Balance sheet items: Total assets, inventory, accounts payable, total liabilities, and shareholders' equity.
Cash flow statement items: Operating cash flow, capital expenditures, free cash flow, and dividend payments.
For Walmart, pull data from fiscal years 2020–2024 to establish trends. Create a simple spreadsheet with these line items organized by year, calculating year-over-year growth rates for each metric.
Step 1: Analyze historical financial performance
Walmart's five-year financials reveal consistent patterns. Revenue typically grows 3–5% annually, with occasional acceleration from e-commerce or acquisitions. More importantly, observe operating margin trends.
Historical analysis for a recent fiscal year showed:
- Total revenue: ~$650 billion
- Cost of goods sold: ~$490 billion (75% of revenue)
- Operating income (EBIT): ~$25 billion (3.8% margin)
- Net income: ~$15 billion
- Free cash flow: ~$18 billion
These figures demonstrate why scale matters. A 1% improvement in COGS on $650 billion in revenue creates $6.5 billion in additional operating profit—without a single new customer.
Calculate key metrics:
Gross margin: COGS ÷ Revenue. For Walmart, this runs 24–26%, typical for discount retailers.
Operating margin: EBIT ÷ Revenue. Walmart's 3–4% reflects its low-margin, high-volume strategy.
Net margin: Net income ÷ Revenue. Around 2–2.5% for Walmart, showing how much flows to owners after all expenses.
Return on equity (ROE): Net income ÷ Average shareholders' equity. Track this over time. Walmart's ROE typically ranges 13–16%, respectable for a mature company.
These historical patterns become the foundation for projections. If Walmart has maintained 3.8% operating margins for years, assuming it suddenly expands to 5% requires justification—cost structure changes, pricing power increases, or efficiency breakthroughs.
Step 2: Project future cash flows (5–10 year horizon)
With historical performance understood, project the next 5–10 years. For Walmart, conservative assumptions align with the business model:
Revenue growth: Assume 4% annually. This reflects inflation-adjusted sales growth plus modest real expansion. Walmart's mature market share limits explosive growth, but continued international expansion and e-commerce justify a few percentage points above inflation.
Operating margin: Model a gradual expansion from 3.8% to 4.2% by year 10, reflecting e-commerce scale (higher margins than some traditional retail) and automation benefits. This is modest but realistic.
Tax rate: Use Walmart's historical effective tax rate, typically 22–24%. For this example, assume 23%.
Capex and working capital: Walmart reinvests heavily in stores, distribution centers, and technology. Assume capex equals 3% of revenue growth annually. Working capital changes are minimal in steady state given Walmart's ability to collect from customers while delaying supplier payments.
Year 1–5 projections (simplified example):
| Year | Revenue | Growth | EBIT | EBIT Margin | FCF |
|---|---|---|---|---|---|
| Base | $650B | — | $24.7B | 3.8% | $18.0B |
| +1 | $676B | 4.0% | $25.8B | 3.82% | $18.9B |
| +2 | $703B | 4.0% | $27.0B | 3.84% | $19.8B |
| +3 | $731B | 4.0% | $28.3B | 3.87% | $20.8B |
| +5 | $793B | 4.0% | $31.5B | 3.97% | $23.1B |
From EBIT, subtract taxes, add back depreciation, subtract capex to arrive at free cash flow to the firm (FCFF). For Walmart, this simplifies to roughly 75% of EBIT after tax, accounting for maintenance capex and working capital needs.
Step 3: Calculate terminal value
Beyond year 10, project perpetual growth. For Walmart, use 2.5–3% annually, aligned with long-term GDP growth. This avoids assuming Walmart shrinks to nothing (too pessimistic) or grows faster than the economy forever (unrealistic).
Terminal value = Final year FCF × (1 + Perpetual growth rate) ÷ (WACC – Perpetual growth rate)
Assume a WACC of 7.5% for Walmart (detailed calculation below). In year 10, FCF is ~$26B. Terminal value = $26B × 1.025 ÷ (0.075 – 0.025) = $26B × 1.025 ÷ 0.05 = $533 billion.
Terminal value often represents 60–75% of total enterprise value, so this figure carries weight. Test the reasonableness: Is $533B in perpetual cash flows, discounted at 7.5% minus 2.5% growth, reasonable for a $650B revenue company? Yes—mature retailers with stable cash flows can trade at these valuation levels.
Step 4: Calculate weighted average cost of capital (WACC)
WACC represents the minimum return required by all capital providers—both debt and equity holders.
WACC = (E ÷ V) × Re + (D ÷ V) × Rd × (1 – Tc)
Where:
- E = Market value of equity
- D = Market value of debt
- V = E + D (total firm value)
- Re = Cost of equity
- Rd = Cost of debt
- Tc = Corporate tax rate
For Walmart:
Market values: Assume 3 billion shares outstanding at $90 per share = $270B equity value. Walmart carries ~$50B in long-term debt. V = $320B.
Weights: E/V = 84%, D/V = 16%.
Cost of equity (using CAPM): Re = Risk-free rate + Beta × Market risk premium
- Risk-free rate: 4.5% (long-term U.S. Treasury yield)
- Beta: 0.5 (Walmart is defensive; moves less than the market)
- Market risk premium: 6% (historical average equity premium)
Re = 4.5% + 0.5 × 6% = 7.5%
Cost of debt: Walmart's bonds yield ~3.5%. After-tax cost = 3.5% × (1 – 0.23) = 2.7%.
WACC = 0.84 × 7.5% + 0.16 × 2.7% = 6.3% + 0.43% = 6.73%, round to 6.7–7.0%.
This 6.7% threshold means any project returning above that rate creates shareholder value.
Step 5: Discount cash flows to present value
Sum the present value of years 1–10's projected FCF plus terminal value, discounting each at WACC.
Simplified example (actual spreadsheet would be more detailed):
| Period | FCF | Discount Factor (6.7% WACC) | PV |
|---|---|---|---|
| Year 1 | $18.9B | 0.937 | $17.7B |
| Year 2 | $19.8B | 0.878 | $17.4B |
| Year 3 | $20.8B | 0.822 | $17.1B |
| Years 4–10 | (combined) | — | $132B |
| Terminal Value | $533B | 0.445 | $237B |
| Total Enterprise Value | $421B |
Subtract net debt (debt minus cash) to arrive at equity value. If Walmart holds $5B in cash and carries $50B in debt, net debt = $45B.
Equity value = $421B – $45B = $376B
Per-share value = $376B ÷ 3 billion shares = $125 per share
Step 6: Validate with multiples
Cross-check the DCF with comparable company analysis. Identify peer retailers and examine their valuations.
Price-to-earnings multiple: If Walmart trades at 30× forward earnings and you project $5 billion in next-year net income, implied price = 30 × $5B ÷ 3B shares = $50 per share. (This is notably lower, suggesting either the market undervalues Walmart or your earnings projection is optimistic.)
EV/EBITDA multiple: Peers might trade at 12–15× EBITDA. Walmart's EBITDA is roughly EBIT plus depreciation (~$25B + $8B = $33B). At 13× EBITDA, Enterprise Value = $429B, close to our DCF estimate. This convergence suggests the $125 per share estimate is reasonable.
Real-world examples
A fundamental investor using this framework in 2022, when Walmart traded at $145–150, would conclude the stock was fairly valued or slightly overpriced depending on their assumptions. The modest premium to DCF value ($125) reflects the market's confidence in Walmart's moat and dividend sustainability.
Conversely, during the 2020 COVID downturn, Walmart briefly dropped to $115 per share. Using the same model with updated forecasts, analysts would have identified it as undervalued, presenting a buying opportunity. The company's essential retail status and e-commerce surge during lockdowns supported higher growth assumptions, justifying a premium valuation.
Common mistakes
Overestimating growth: The most frequent error is assuming Walmart will grow faster than it historically has. Retail is mature; international markets do add runway, but assuming 7–8% perpetual revenue growth ignores market saturation and competition.
Ignoring working capital cycles: While Walmart's negative working capital (it collects from customers before paying suppliers) is a cash generation engine, assuming this advantage perpetually expands is incorrect. As the company matures, working capital stabilizes as a percentage of revenue.
Using wrong discount rate: Applying a tech startup's 12% discount rate to Walmart is inappropriate. Walmart's stable cash flows justify a lower rate; conversely, assuming 4% WACC underestimates risk. Use peer-based betas and current interest rates to calibrate WACC.
Neglecting dividend sustainability: Walmart increased its dividend for 50+ consecutive years. Assuming this continues indefinitely in a recession scenario is naive. Model dividend growth conservatively, perhaps capped at 5–7% annually.
Cherry-picking time periods: If you gather data only during strong e-commerce quarters, your margin projections become unrepresentative. Include multiple cycles (growth phases and recessions) to understand true trends.
FAQ
What if Walmart's margins compress due to competition?
Rerun the model with lower margin assumptions (e.g., flat 3.8% rather than expanding to 4.2%). This would reduce terminal value and per-share equity value by 15–20%, resulting in a lower intrinsic value estimate. Sensitivity analysis quantifies this impact.
How do I account for Walmart's dividend in DCF?
The DCF approach to free cash flow implicitly includes dividends. FCF = operating cash flow minus capex, and management allocates FCF to dividends, buybacks, or debt repayment. If Walmart pays $8B in dividends from $18B in FCF, the remaining $10B funds growth or debt reduction. The DCF capture this via terminal value growth. Alternatively, use a dividend discount model for simplicity if Walmart's dividend is predictable.
Should I include Walmart's $50B in debt?
Yes, in two ways: First, calculate WACC using Walmart's actual capital structure (16% debt, 84% equity). Second, subtract net debt from enterprise value. Debt holders have prior claim on assets, so equity holders own only the residual. Ignoring debt inflates your per-share value estimate.
What happens if interest rates rise?
Higher rates increase WACC (the risk-free rate component rises). A WACC of 8.5% instead of 6.7% reduces terminal value and DCF equity value by 20–30%. This is why interest-rate-sensitive businesses like Walmart can see share prices fall when the Fed tightens, even if fundamentals don't change.
How often should I revalue Walmart?
Revalue quarterly when earnings are released or annually for a comprehensive review. If material news emerges (major acquisition, unexpected margin loss, significant capital allocation change), update immediately. Otherwise, quarterly recalibration captures new data without obsessive recalculation.
Can I use a dividend discount model instead of DCF?
Yes, for mature dividend payers. Project Walmart's dividends forward 20–30 years, assume a terminal growth rate (e.g., 3%), and discount to present value using your cost of equity (7.5%). This method tends to give more conservative valuations for high-dividend-yield stocks. Both DCF and DDM should yield similar results if assumptions align.
Related concepts
Comparable company analysis: Comparing Walmart's P/E, EV/EBITDA, and price-to-sales multiples against Target, Costco, and Amazon reveals relative valuation. If Walmart trades at a 15% discount to peers on EV/EBITDA despite superior margins, it may be undervalued.
Asset-based valuation: For retailers, book value (assets minus liabilities) is less relevant than cash generation, but store real estate is a hidden asset. Walmart owns many properties, increasing tangible book value beyond what financial statements suggest.
Intrinsic value vs. market price: The gap between your DCF estimate and Walmart's market price represents the margin of safety. A $125 intrinsic value with a $90 market price offers a 39% margin of safety, which is attractive; a $125 intrinsic value with a $140 market price suggests overvaluation.
Sensitivity analysis tables: Building a table showing how per-share value changes with different revenue growth rates and WACC assumptions is essential. If value ranges from $110–$140 across reasonable assumption ranges, you have a valuation band, not a point estimate.
Free cash flow to equity vs. free cash flow to the firm: FCFE is available to shareholders after debt service; FCFF is available to all capital providers. This article used FCFF with WACC, the standard approach. Ensure consistency: FCFF with WACC or FCFE with cost of equity.
Summary
Valuing Walmart demonstrates how fundamental analysis works for mature, cash-generative businesses. The process requires gathering historical financials, understanding business economics and competitive advantages, projecting realistic cash flows, calculating an appropriate discount rate, and comparing results to multiples and peer valuations.
Walmart's stable business model, powerful moat, and predictable cash flows make it a relatively straightforward valuation exercise compared to high-growth companies. The key discipline is avoiding overoptimistic assumptions about growth and margins. A 4% revenue growth rate reflects market reality; projecting 10% growth for a retailer serving saturated markets lacks credibility.
The DCF analysis yields an intrinsic value, but valuation is not precise. Reasonable assumptions can support a range from $110 to $140 per share. Your margin of safety—the gap between intrinsic value and market price—determines whether the stock merits purchase. When market price is well below your conservative intrinsic value estimate, the risk-reward favors ownership. When the market price exceeds even optimistic valuations, risk management suggests patience.
Next
Proceed to Valuing Procter and Gamble: A Beginner Walkthrough to apply these techniques to another stable dividend aristocrat with different business characteristics.
Across five major U.S. companies using DCF methods, valuations require baseline assumptions on perpetual growth (2–3%), WACC calibration (6–8%), and margin sustainability that investors must test against peer multiples, sensitivity scenarios, and macroeconomic conditions.