← WMT forward model

WMT · Forward model · Walmart U.S. · Rainey case

What has to happen in Walmart U.S.

Model as of

This page changes Walmart U.S. inside the complete WMT model. Every other vertical, corporate programme and valuation assumption stays in the selected portfolio case.

WMT forward model
Horizon
Consolidated fair value $83.84 all other verticals held in this portfolio case
Final-quarter revenue $153.97B 66% of company revenue
Explicit segment contribution $71.14B EBITDA less segment capex, before corporate items

The CFO's own framing taken literally: the tariff refunds are not earnings, they are price investment funded in advance. John David Rainey said the operating income outlook reflects prioritising the refunds received in Q2 into customer experience and price investments in the second half, and asked investors to consider Q2 and Q3 together. This case models the reinvestment doing what it is meant to do: volume above the base case at Walmart U.S. and Sam's Club, bought with 40bps of EBITDA margin given back across every segment, on the base 17x exit. What it does not achieve is the bull case - share gain at a flat margin is worth less than mix shift at an expanding one, and the case still sits below today's price.

Walmart U.S.

Basis quarter$125.19B
Final quarter$153.97B
Implied CAGR+4%
Final revenue mix66%

Roughly two thirds of the company. Revenue is comparable sales - transactions times ticket, with eCommerce contributing about 510bps of comp in 2027 Q2 - across a 4,611-unit estate that grows by a handful of stores a year. Walmart discloses no quarterly capacity or subscriber metric that mechanically generates the line, so the honest driver is deseasonalised growth anchored on disclosed comp sales and the company's own guidance.

Last four quarters
2026 Q3 $120.68B Reported
2026 Q4 $129.22B Reported
2027 Q1 $117.17B Reported
2027 Q2 $125.19B Reported
Supercenters, discount stores and Neighborhood MarketsStore-fulfilled pickup and delivery, marketplace and fulfilment servicesWalmart Connect advertising
Sequential growth +0.9%/qtr decaying toward +0.8% Deseasonalised trend is 1.04%/qtr over eight quarters and 0.88% over four; 0.95% compounds to 3.9% a year.
Walmart U.S.

Latest: $153.97B (2032Q2E)

Period Value
2024Q1 $103.90B
2024Q2 $110.85B
2024Q3 $109.42B
2024Q4 $117.64B
2025Q1 $108.67B
2025Q2 $115.35B
2025Q3 $114.88B
2025Q4 $123.52B
2026Q1 $112.16B
2026Q2 $120.91B
2026Q3 $120.68B
2026Q4 $129.22B
2027Q1 $117.17B
2027Q2 $125.19B
2027Q3E $125.77B
2027Q4E $136.52B
2028Q1E $121.02B
2028Q2E $130.73B
2028Q3E $131.29B
2028Q4E $142.47B
2029Q1E $126.25B
2029Q2E $136.35B
2029Q3E $136.91B
2029Q4E $148.52B
2030Q1E $131.59B
2030Q2E $142.08B
2030Q3E $142.63B
2030Q4E $154.71B
2031Q1E $137.05B
2031Q2E $147.95B
2031Q3E $148.50B
2031Q4E $161.04B
2032Q1E $142.64B
2032Q2E $153.97B

Assumptions & reasoning

  • The 7.15% starting EBITDA margin is derived, not disclosed: FY2026 segment operating income of $25,158M plus segment D&A of $9,390M over segment net sales of $482,975M. That numerator already contains this segment's share of membership and other income, which is why the membershipOther vertical is carried at a zero margin.
  • The 158bps gross-margin gain at Walmart U.S. in 2027 Q2 is attributed by the company primarily to tariff refunds, and the release says those refunds are being reinvested into price in the second half. It is not extrapolated here; the margin starts at the FY2026 level and glides 45bps over five years.
  • Operating expense deleveraged 72bps in 2027 Q2 on claims expense, depreciation and associate healthcare. Unlike the refunds that is a recurring cost line, and it is one reason the terminal margin assumption is deliberately slow.
WMT model map

Explore another vertical