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.
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.
| Measure | FY2025 | FY2026 |
|---|---|---|
| Net sales | 674,538 | 706,413 |
| Membership / other income | 6,447 | 6,750 |
| Total revenue | 680,985 | 713,163 |
| Cost of sales | 511,753 | 535,395 |
| Net sales less cost of sales: derived | 162,785 | 171,018 |
| Operating / selling / general / administrative | 139,884 | 147,943 |
| Operating income | 29,348 | 29,825 |
| Consolidated net income | 20,157 | 22,270 |
| Parent-attributable net income | 19,436 | 21,893 |
| Merchandise gross margin on net sales: derived | 24.1% | 24.2% |
| Operating margin on total revenue: derived | 4.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.
| Measure | FY2025 | FY2026 |
|---|---|---|
| Operating cash | 36,443 | 41,565 |
| Property / equipment payments | 23,783 | 26,642 |
| Cash after these payments | 12,660 | 14,923 |
| Property payments / operating cash: derived | 65.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.
| Step | FY2026 |
|---|---|
| Operating income | 29,825 |
| Net interest expense | -2,431 |
| Other gains, net | 2,075 |
| Income tax | -7,199 |
| Consolidated net income: subtotal | 22,270 |
| Depreciation / amortization | 14,203 |
| Other reconciliation adjustments | 4,340 |
| Operating asset / liability changes | 752 |
| Operating cash: subtotal | 41,565 |
| Property / equipment payments | -26,642 |
| Cash after these payments | 14,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.
| Measure | Historical basis | Illustrative case |
|---|---|---|
| Operating cash | 41,565 | 41,065 |
| Property / equipment payments | 26,642 | 26,642 |
| Cash after these payments | 14,923 | 14,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
| Decision | Treatment |
|---|---|
| Revenue | Separate sales, membership and other income while preserving the recognized marketplace/services perimeter. |
| Cost to serve | Model merchandise cost, labor, distribution and fulfillment together rather than extrapolating gross margin alone. |
| Operating funding | Link inventory and collections to supplier terms, payables and accrued operating obligations. |
| Reinvestment | Schedule cash property purchases and maintenance consistently with the store, digital and distribution case. |
| Equity bridge | Match 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
