Is there a margin of safety in Walmart stock at $127.36 after the Q3 FY2027 print on 19 November 2026?

SELL: the blended value is $90.95 a share against $127.36 ((28.6%)) — half the Gordon-growth DCF ($63.17) and half the exit-multiple value ($118.74); no margin of safety.

Walmart · Q3 FY2027 · Published · Data cut-off: 2026-11-19 · By DeepCell AI · Sources

1 · Cover

SELL after Q3: Walmart is worth $90.95 a share on a blend of DCF and exit multiple, against $127.36


No margin of safety at this price.The blended value is -28.6% against the price (the DCF alone, $63.17, is -50.4%); the SELL band starts above $101.06, and a BUY would need $79.09 or less.
Even the bull case falls short.If advertising and membership compound faster, the value is $84.91, still -33.3% against the price.
The price needs a growth rate we cannot underwrite.On our cash flows the price implies 5.4% growth forever, or an exit at 19.4x EBITDA.
The Q3 beat moved the value, not the call.Revenue and EPS beat and the FY2027 guide rose, which lifts the value a few dollars; only a large change in margin path or discount rate would close a gap this wide.

Value per share by case, USD, against the 18 November close

Per shareAgainst the price
Average analyst target$138.508.7%
Base, exit multiple$118.74-6.8%
Blended, 50/50 (headline)$90.95-28.6%
Advertising and membership flywheel$84.91-33.3%
Base, Gordon growth$63.17-50.4%
Consumer slowdown$55.36-56.5%
Margin reset$48.29-62.1%

2 · Our view

Q3 FY2027: the street wanted revenue of $187.2 billion and EPS of $0.64; Walmart reported $188.8 billion and $0.65


Guide and street.EPS guide midpoint $0.63, net sales about $183.8 billion; consensus EPS $0.64.
Our forecast.Revenue $187.8 billion (a year ago $179.5 billion), EPS $0.63, operating margin 3.95%.
Reported on 19 November.Revenue $188.8 billion, EPS $0.65, operating income $7.8 billion (a year ago $6.7 billion).

Exhibit 1: Q3 FY2027: expectations against the print

Q3 FY2027A · Guidance (midpoint)Q3 FY2027A · ConsensusQ3 FY2027A · Our forecastQ3 FY2027A · Actual
Total revenues$M187,190.0187,754.7188,835.0
Operating margin (on total revenues)%4.0%4.1%
Adjusted diluted EPS$0.630.640.630.65

3 · The quarter

Advertising and membership are the higher-margin engine: 23% of operating income in FY2026A, 27% by FY2031E


The fastest-growing lines are not groceries.In Q3 global advertising grew 25%, membership fees 17% and eCommerce 17%, after 38%, 17% and 23% in Q2; Flipkart’s sale timing held International back.
Membership and other income compounds in the forecast.It rises from $6.8 billion in FY2026A to $12.6 billion in FY2031E, lifting gross margin by mix.
The flywheel case is the upside, not the base.At 20% a year the line reaches 28% of operating income and the value $84.91.

Exhibit 2: Membership and other income, FY2024A to FY2031E (USD millions)

USD millions; FY2027E onward is our forecast

4 · Advertising and membership

Walmart U.S. is 68% of sales at a 5.2% margin; International grows faster on thinner margins


Walmart U.S. carries the earnings.Net sales $483.0 billion in FY2026A, up 4.4%, at a 5.2% segment operating margin.
International is the growth line.Net sales $130.4 billion, up 7.0%, at 3.9%.
Sam’s Club is the steady membership box.Net sales $93.0 billion at 2.6%; its membership income sits in the higher-margin line.

Exhibit 3: Net sales by segment, FY2024A to FY2031E (USD millions)

USD millions; FY2027E onward is our forecast

5 · Segments

Operating margin rises from 4.2% to 5.2% by FY2031E, if mix gains are kept rather than reinvested in price


Q2 was flattered; Q3 gave some back.Gross margin on net sales was 25.4% in Q2 against 24.5% a year earlier, helped by tariff refunds, and 24.5% in Q3 as they were reinvested in price.
We start FY2027E below the Q2 run-rate.Gross margin on net sales is 24.6% in FY2027E, from 24.2% in FY2026A, rising to 25.0% by FY2031E.
If the gains are given back, margin stalls.In the margin-reset case FY2031E operating margin is 4.3% and the value $48.29.

Exhibit 4: Operating margin, FY2024A to FY2031E

Operating income over total revenues; FY2027E onward is our forecast

6 · Margins

Cash converts well, but capex at 3.7% of revenue keeps free cash flow thin


Operating cash flow is large; free cash flow is not.FY2026A operating cash flow was $41.6 billion and free cash flow $14.9 billion after capex.
Walmart returns most of what it frees.Dividends and repurchases were $15.6 billion in FY2026A.
The yield at this price is low.FY2027E unlevered free cash flow is 1.3% of market value and the dividend yield 0.8%.

Exhibit 5: Free cash flow against dividends and repurchases, FY2024A to FY2031E (USD millions)

USD millions; FY2027E onward is our forecast

7 · Earnings quality

Blending the DCF ($63.17) and the exit multiple gives $90.95 a share: still well short of the price


The discount rate and growth do the work.A WACC of 7.6% and 3.0% terminal growth; terminal value is 84% of enterprise value.
The exit-multiple method is closer to the price.At 18x FY2031E EBITDA the value is $118.74, -6.8% against the price; the market pays 21.6x FY2027E EBITDA today.
The street is more generous.The average target is $138.50; the stock trades at 44.1x our FY2027E EPS.

Exhibit 6: Value per share by case, beside the price and the analyst target (USD)

USD per share; price is the 18 November close

8 · Valuation

The print delivered a beat, not a new margin path, so the rating stays SELL


A beat on EPS alone did little.Walmart reported $0.65 against a consensus of $0.64; our FY2027E is now $2.89 against a raised guide midpoint of $2.87 and an August consensus of $2.89.
The level that matters.The blended value, now $90.95, would have to rise above $114.62 to leave the SELL band.
Comps, advertising and eCommerce held up.Walmart U.S. comps were 2.9% after 2.6% in Q2; global advertising grew 25% and eCommerce 17%.
Or the price.A fall to $101.06 would make the same value a HOLD; $79.09 a BUY.

Levels against which the rating was re-tested on 19 November

ThresholdNow
Share price for a HOLD$101.06 or below$127.36
Blended value for a HOLD at today’s priceabove $114.62$90.95 (DCF $63.17)
Q3 adjusted EPSconsensus $0.64reported $0.65
Q3 Walmart U.S. compsQ2 2.6%reported 2.9%

Rating after results: SELL. Next test: Q4 FY2027, in February.

9 · What would change the rating

After the print the blended value is $90.95 a share (DCF $63.17): the beat raised the forecast, not the call


What we expected.Revenue of $187.8 billion and EPS of $0.63, in line with the guide of $0.63.
What Walmart reported.Revenue $188.8 billion and EPS $0.65.
Why the call holds.A beat and a raised FY2027 guide lift our FY2027E EPS to $2.89, but the gap between value and price is a valuation gap, not an earnings gap.

Exhibit 7: Total revenues by quarter, Q2 FY2026 to Q3 FY2027

USD millions, as reported, Q2 FY2026 to Q3 FY2027

10 · Before and after the print

Share this review

Send the link: it opens with the picture below, and every number on the page still opens its formula and source. The picture is free to download and share.

More valuation reports

All valuation reports