Three-statement Excel model · 22 quarters and 5 fiscal years of history · 10 quarters and 5 fiscal years of projections
About the WMT model
This three-statement Excel model covers Walmart Inc. (WMT): its income statement, balance sheet and cash flow statement. It holds 22 quarters and 5 fiscal years of history and 10 quarters and 5 fiscal years of projections.
Projected revenue is built from KPI drivers: Three reportable segments' net sales grown off the same quarter a year earlier, plus membership income; segments tie to net sales in all 27 periods, across 3 segments.
Beyond the income statement, the workbook has these sections: KPI Drivers, Balance Sheet and Cash Flow Statement.
Model thesis: Segment growth rates held to the August guide: FY27E EPS $2.85 inside $2.80–2.87, with 3Q27E at the top of its $0.62–0.64 range
On October 19, 2026, the model passed checks C13 (every subtotal reconciles to the reported figure at $0), C14 (every projected revenue cell traces to a KPI driver row) and C15 (each driver ends in a rate, a count or a historical anchor, never a typed-in projected dollar level). It was last updated September 27, 2026.
Income statement preview
Columns 2024–2026 are actual results and FY27E–FY29E are our estimates. Figures were recalculated in Excel on September 27, 2026. Dollars in millions, except per share.
| Income Statement | ||||||
|---|---|---|---|---|---|---|
| Actual | Estimate | |||||
| 2024 | 2025 | 2026 | FY27E | FY28E | FY29E | |
| Walmart U.S. | $441,817.0 | $462,415.0 | $482,975.0 | $501,910.1 | $521,099.8 | $540,111.1 |
| Walmart International | 114,641.0 | 121,885.0 | 130,423.0 | 144,147.6 | 153,042.4 | 161,418.8 |
| Sam's Club | 86,179.0 | 90,238.0 | 93,015.0 | 98,915.5 | 103,585.6 | 108,012.2 |
| Net Sales | $642,637.0 | $674,538.0 | $706,413.0 | $744,973.1 | $777,727.8 | $809,542.2 |
| Membership and Other Income | $5,488.0 | $6,447.0 | $6,750.0 | $7,790.4 | $8,647.9 | $9,491.2 |
| Total Revenues | $648,125.0 | $680,985.0 | $713,163.0 | $752,763.5 | $786,375.7 | $819,033.4 |
| Less: Cost of Sales | ($490,142.0) | ($511,753.0) | ($535,395.0) | ($561,808.6) | ($587,561.6) | ($611,143.2) |
| Gross Profit | $157,983.0 | $169,232.0 | $177,768.0 | $190,954.9 | $198,814.1 | $207,890.2 |
| Less: Operating, Selling, General and Administrative Expenses | ($130,971.0) | ($139,884.0) | ($147,943.0) | ($157,857.5) | ($164,286.0) | ($170,699.6) |
| Operating Income | $27,012.0 | $29,348.0 | $29,825.0 | $33,097.4 | $34,528.1 | $37,190.6 |
| Depreciation and Amortization (from Cash Flow) | $11,853.0 | $12,973.0 | $14,203.0 | $16,249.3 | $18,161.1 | $19,552.7 |
| EBITDA | $38,865.0 | $42,321.0 | $44,028.0 | $49,346.7 | $52,689.2 | $56,743.2 |
| Less: Interest on Debt | ($2,259.0) | ($2,249.0) | ($2,318.0) | ($2,073.4) | ($2,724.8) | ($2,724.8) |
| Less: Interest on Finance Lease Obligations | (424.0) | (479.0) | (481.0) | (494.2) | (486.4) | (486.4) |
| Interest Income | 546.0 | 483.0 | 368.0 | 366.8 | 259.2 | 187.1 |
| Less: Interest, Net | ($2,137.0) | ($2,245.0) | ($2,431.0) | ($2,200.8) | ($2,952.0) | ($3,024.1) |
| Less: Loss on Extinguishment of Debt | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| Other Gains and (Losses) | (3,027.0) | (794.0) | 2,075.0 | (925.0) | 0.0 | 0.0 |
| Income Before Income Taxes | $21,848.0 | $26,309.0 | $29,469.0 | $29,971.6 | $31,576.0 | $34,166.5 |
| Less: Provision for Income Taxes | ($5,578.0) | ($6,152.0) | ($7,199.0) | ($6,695.8) | ($7,578.3) | ($8,200.0) |
| Consolidated Net Income | $16,270.0 | $20,157.0 | $22,270.0 | $23,275.8 | $23,997.8 | $25,966.5 |
| Less: Net Income Attributable to Noncontrolling Interest | (759.0) | (721.0) | (377.0) | (548.1) | (480.0) | (519.3) |
| Net Income Attributable to Walmart | $15,511.0 | $19,436.0 | $21,893.0 | $22,727.7 | $23,517.8 | $25,447.2 |
| Ratios & Assumptions | ||||||
| YoY Walmart U.S. Net Sales Growth | 5.1% | 4.7% | 4.4% | 3.9% | 3.8% | 3.6% |
| YoY Walmart International Net Sales Growth | 13.5% | 6.3% | 7.0% | 10.5% | 6.2% | 5.5% |
| YoY Sam's Club Net Sales Growth | 2.2% | 4.7% | 3.1% | 6.3% | 4.7% | 4.3% |
| YoY Net Sales Growth | 6.1% | 5.0% | 4.7% | 5.5% | 4.4% | 4.1% |
| YoY Total Revenues Growth | 6.0% | 5.1% | 4.7% | 5.6% | 4.5% | 4.2% |
The full workbook adds 22 historical and 10 projected quarters, plus KPI Drivers · Balance Sheet · Cash Flow Statement — every subtotal a live formula, every projection traced to a driver.
Walmart research
Aardvark Labs Capital Research has published 8 reports on Walmart (WMT). The latest is the Q2 FY27 Earnings Recap, published August 27, 2026, rated Outperform.
Maintaining Outperform: A 9% De-Rate on a Comp Line the Government Set, While Underlying Operating Income Grew Four Times the U.S. Comp
Methodology
Every projected revenue cell traces to a KPI/driver row (C14). Terminal driver cells are rates, counts, or historical anchors — never typed-in projected dollar levels (C15). Every subtotal-vs-reported reconciliation row ties to $0 (C13). Each model is written per-ticker against its actual schema — no cloning, no level-input shortcuts.