← All financial models

Walmart (WMT) Financial Model

📊 Download Model

Three-statement Excel model · 22 quarters and 5 fiscal years of history · 10 quarters and 5 fiscal years of projections

current ✓ C13 recon ✓ C14 trace ✓ C15 terminals

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.

History
22 quarters and 5 fiscal years
Projections
10 quarters and 5 fiscal years
KPI
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
Segments
3
Units
Dollars in millions, except per share
Verified
Updated
File
Excel workbook (.xlsx), 171 KB
Access
Free account required: 3 different models a month at no charge, then $9 a month.

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 preview for WMT. Dollars in millions, except per share. Actual fiscal years followed by our estimates.
Income Statement
ActualEstimate
202420252026FY27EFY28EFY29E
Walmart U.S.$441,817.0$462,415.0$482,975.0$501,910.1$521,099.8$540,111.1
Walmart International114,641.0121,885.0130,423.0144,147.6153,042.4161,418.8
Sam's Club86,179.090,238.093,015.098,915.5103,585.6108,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 Income546.0483.0368.0366.8259.2187.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 Debt0.00.00.00.00.00.0
Other Gains and (Losses)(3,027.0)(794.0)2,075.0(925.0)0.00.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 Growth5.1%4.7%4.4%3.9%3.8%3.6%
YoY Walmart International Net Sales Growth13.5%6.3%7.0%10.5%6.2%5.5%
YoY Sam's Club Net Sales Growth2.2%4.7%3.1%6.3%4.7%4.3%
YoY Net Sales Growth6.1%5.0%4.7%5.5%4.4%4.1%
YoY Total Revenues Growth6.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.

Download the full WMT model (xlsx)3 free models a month with an account, then $9 a month

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

All WMT research →

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.