Company DCF analysis file

Walmart DCF Analysis

Walmart’s DCF needs a retail margin and replenishment-funding case alongside its investment program. Sales growth can require inventory, labor and fulfillment capacity before it produces investor cash. The annual cost and cash bridges below distinguish merchandise economics, membership and other income, nonoperating gains and the spending needed to sustain the shopping proposition.

Walmart DCF Analysis cover

Read sales together with merchandise and operating costs

Fiscal years ended January 31, 2025 and January 31, 2026; consolidated company. Amounts use the monetary scale stated in each table caption. Source: annual financial statements. Reported lines retain the issuer’s scope; derived ratios use the displayed denominators.

Annual income basis, $ millions except derived margins
MeasureFY2025FY2026
Net sales674,538706,413
Membership / other income6,4476,750
Total revenue680,985713,163
Cost of sales511,753535,395
Net sales less cost of sales: derived162,785171,018
Operating / selling / general / administrative139,884147,943
Operating income29,34829,825
Consolidated net income20,15722,270
Parent-attributable net income19,43621,893
Merchandise gross margin on net sales: derived24.1%24.2%
Operating margin on total revenue: derived4.3%4.2%

The merchandise gross margin uses net sales; operating margin uses total revenue including membership and other income. Keep the denominators distinct. Depreciation and many store, distribution and support costs are within operating expense, so a gross-margin comparison alone is not a complete cost-to-serve comparison.

Distribution-cost allocation differs by business and can differ from other retailers. Model the full cost of fulfillment rather than interpreting a higher reported gross margin as an equal operating improvement. Marketplace, seller services and advertising must remain inside the relevant recognized-revenue population; adding them again to an existing sales total would create revenue twice.

Compare investment funding across the two completed fiscal years

The annual cash-flow statement gives this two-year funding comparison. Property purchases are cash investment, not the depreciation already recognized in operating expense.

Annual cash investment and coverage, $ millions except ratio
MeasureFY2025FY2026
Operating cash36,44341,565
Property / equipment payments23,78326,642
Cash after these payments12,66014,923
Property payments / operating cash: derived65.3%64.1%

Investment absorbs a substantial part of operating cash in both periods. A future case needs to distinguish capacity expansion, automation and maintenance on a consistent spending basis. Higher current cash after investment does not establish the return on every new facility or the level of sustainable shareholder distributions.

Trace earnings into cash and reinvestment

Reconciliation source: annual earnings and cash-flow statements. Subtotals below are checkpoints, not extra amounts to add. Grouped adjustments are calculated from the disclosed cash-flow lines.

FY2026 operating-income-to-cash bridge, $ millions
StepFY2026
Operating income29,825
Net interest expense-2,431
Other gains, net2,075
Income tax-7,199
Consolidated net income: subtotal22,270
Depreciation / amortization14,203
Other reconciliation adjustments4,340
Operating asset / liability changes752
Operating cash: subtotal41,565
Property / equipment payments-26,642
Cash after these payments14,923

Other reconciliation combines investment gains reversed from earnings, deferred tax and other operating activities. The operating-balance group combines receivables, inventory, payables, accrued liabilities and accrued tax. Inventory and supplier funding therefore need a paired forecast; an increase in payables cannot be assumed to fund growth indefinitely without corresponding purchases and payment terms.

The bridge starts from consolidated net income, before noncontrolling ownership is allocated. The final cash checkpoint precedes other investing, financing and ownership distributions. Shareholder value requires a dated lease, debt, noncontrolling-claim and available-cash bridge rather than treating reported net income or the capex remainder as common cash automatically.

Stress replenishment cash while holding current earnings fixed

Illustration: fund $500 million of additional inventory without matching supplier financing, with sales, current expense and all other cash movements fixed. This isolates stock funding, not a forecast of demand, shrink, margin or a permanent inventory write-off.

Illustrative inventory-funding sensitivity, $ millions
MeasureHistorical basisIllustrative case
Operating cash41,56541,065
Property / equipment payments26,64226,642
Cash after these payments14,92314,423

The $500 million reduction remains tied up in inventory under this assumption. A later sale or release can return cash, while aging, markdown or shrink would require its own expense and recovery case. Do not both deduct the funding and write off the same amount without explaining the additional economic loss.

Keep interim reporting separate from the annual basis

Q2 FY2027 covers 2026-05-01 through 2026-07-31 and was released 2026-08-20. Revenue was $187,937 million in this quarter. Source: official Q2 FY2027 results.

The later FY2027 quarter is separate from the completed annual spending and inventory cycle. Use its current sales, mix and operating balances to roll the funding case forward; do not annualize one quarter or assume a newer services mix carries the same cost and cash conversion as merchandise retail.

Turn the financial basis into a DCF case

Retail margin and replenishment DCF decisions
DecisionTreatment
RevenueSeparate sales, membership and other income while preserving the recognized marketplace/services perimeter.
Cost to serveModel merchandise cost, labor, distribution and fulfillment together rather than extrapolating gross margin alone.
Operating fundingLink inventory and collections to supplier terms, payables and accrued operating obligations.
ReinvestmentSchedule cash property purchases and maintenance consistently with the store, digital and distribution case.
Equity bridgeMatch operating tax and lease conventions, then reconcile dated financing, available cash, ownership claims and dilution.

A conventional enterprise case begins with operating earnings after an explicit operating tax assumption, suitable non-cash adjustments and the reinvestment and operating funding required by its sales plan. Starting from reported CFO needs tax and financing reconciliation. The terminal case must sustain the price, availability and fulfillment promise without relying on permanently accelerating supplier financing or repeated investment gains.

The Walmart company analysis explains the wider operating context. Use the company forecast tool and DCF calculator with explicit assumptions. Use the historical financials to define an explicit operating and reinvestment case, then supply valuation-date capital costs, claims and diluted shares. Check that each cash claim is counted once before deriving a per-share value.

Company analysis

Read the supporting financial analysis

Walmart Financial Analysis Overview