Walmart Financial Model

• Total assets: Approximately $250 billion.
• Key asset categories: Property and equipment (stores, distribution centres) and inventory are the largest components.
• Goodwill & intangibles: Roughly 12% to 15% of total assets, primarily from historical acquisitions like Flipkart and Massmart.
• Working capital profile:
• Days Sales Outstanding (DSO): 4 to 6 days (mostly receivables from credit card processors and pharmacy PBMs).
• Days Inventory Outstanding (DIO): 40 to 45 days.
• Days Payable Outstanding (DPO): 45 to 50 days.
• Net working capital: Structurally negative. Walmart uses its massive scale to negotiate favourable payment terms with suppliers, selling inventory before it has to pay for it. This negative working capital is a significant source of cash during growth periods.
• PP&E: Consists of land, buildings, fixtures, and equipment. Useful lives range from 3 to 40 years.
• Operating leases: Material, representing right-of-use assets of approximately $12 billion to $15 billion for leased store locations.

• Capex as % of revenue: 2.5% to 3.5% (approximately $20 billion to $24 billion annually).
• Maintenance vs. growth: Roughly 40% maintenance (store remodels) and 60% growth (supply chain automation, e-commerce fulfillment centres, technology).
• Major programmes: Heavy investment in automated distribution centres and store-fulfilled delivery capabilities to support the omnichannel strategy.
• Capitalised software: Material but blended into total capex; critical for the tech-powered retail transition.
• M&A pattern: Selective and strategic. Historically focused on geographic expansion, but recently pivoted to technology and capabilities (e.g., the $2.3 billion acquisition of VIZIO to bolster the advertising network).

• Total debt: Approximately $45.8 billion in FY25.
• Net debt: Approximately $36.8 billion (Total debt less $9.0 billion in cash and cash equivalents).
• Debt/EBITDA ratio: Consistently managed below 1.5x.
• Credit rating: AA (S&P) / Aa2 (Moody's), reflecting a pristine balance sheet.
• Key debt instruments: Primarily long-term fixed-rate unsecured bonds and commercial paper for short-term liquidity.
• Maturity profile: Well-laddered over 10 to 30 years.
• Interest rate profile: Predominantly fixed rate, resulting in a stable weighted average cost of debt around 3.5% to 4.5%.
• Share repurchase programme: Highly active. The company repurchased $4.5 billion in shares during FY25.
• Dividend policy: Progressive dividend policy. The company raised its dividend by 13% to $0.94 per share in FY25, marking its largest increase in over a decade.

• OCF / Net Income: Consistently above 1.5x, driven by massive depreciation add-backs and favourable working capital dynamics.
• Free cash flow margin: 1.5% to 2.5% of revenue (FY25 FCF was $12.7 billion).
• Major non-cash items: Depreciation and amortisation, deferred income taxes, and unrealised gains or losses on equity investments (e.g., JD.com, Symbotic).
• Working capital impact: Inventory management is critical. A slight increase in DIO can consume billions in cash, while efficient sell-through generates massive cash inflows.
• Capex intensity: High absolute dollar capex, but manageable as a percentage of revenue due to the massive top-line denominator.
• Cash tax rate: Closely tracks the GAAP effective tax rate of approximately 24%, with minor timing differences related to accelerated depreciation.

1. Assumptions: Contains all hardcoded inputs for macroeconomic drivers, segment growth rates, margin profiles, and capital allocation policies.
2. Revenue & Segment Build: Forecasts net sales and operating income separately for Walmart U.S., Walmart International, and Sam's Club, including a breakout of membership income.
3. Income Statement: Consolidated view mirroring the 10-K, flowing from Total Revenues down to Consolidated Net Income Attributable to Walmart.
4. Balance Sheet: Standard asset, liability, and equity line items, highlighting inventory, accounts payable, and short-term borrowings.
5. Cash Flow Statement: Indirect method starting from Net Income, adjusting for non-cash items, working capital changes, capex, debt issuance, and shareholder returns.
6. Working Capital Schedule: Projects receivables, inventory, and payables based on DSO, DIO, and DPO assumptions.
7. Debt & Interest Schedule: Tracks commercial paper, long-term debt tranches, and calculates interest expense based on average balances.
8. PP&E & Capex Schedule: Models capital expenditures, depreciation roll-forward, and right-of-use asset amortisation.
9. DCF Valuation: Calculates unlevered free cash flow, applies WACC, and determines the implied share price using a terminal growth rate.

1. Walmart U.S. Net Sales = Prior Year Walmart U.S. Net Sales x (1 + Walmart U.S. Comparable Sales Growth) + Non-Comparable Sales
2. Sam's Club Total Revenue = Sam's Club Net Sales + Membership and Other Income
3. Total Revenues = Walmart U.S. Net Sales + Walmart International Net Sales + Sam's Club Net Sales + Membership and Other Income
4. Cost of Sales = Total Revenues x (1 - Consolidated Gross Margin Percentage)
5. Consolidated Gross Profit = Total Revenues - Cost of Sales
6. Operating, Selling, General and Administrative Expenses = Total Revenues x OSG&A Margin Percentage
7. Operating Income = Consolidated Gross Profit - Operating, Selling, General and Administrative Expenses
8. Ending Inventory = (Cost of Sales / 365) x Days Inventory Outstanding
9. Ending Accounts Payable = (Cost of Sales / 365) x Days Payable Outstanding
10. Interest Expense = Average Total Debt x Weighted Average Interest Rate
11. Free Cash Flow = Net Cash Provided by Operating Activities - Payments for Property and Equipment
12. Shares Outstanding = Prior Year Shares Outstanding - (Share Repurchase Amount / Average Share Price)

The Assumptions sheet dictates the growth and margin profiles in the Revenue & Segment Build. The segment totals feed directly into the top line of the Income Statement. The Income Statement generates Net Income, which is the starting point for the Cash Flow Statement. The Working Capital Schedule uses Cost of Sales from the Income Statement to project balance sheet accounts, feeding changes in working capital back to the Cash Flow Statement. The Cash Flow Statement determines the ending cash balance and debt requirements, which link to the Balance Sheet. A circularity exists between the Debt & Interest Schedule and the Income Statement because interest expense reduces net income, which reduces cash flow, which dictates the need for debt, which in turn drives interest expense.

• Income Statement: Revenues are positive. Expenses (Cost of Sales, OSG&A, Interest) are entered as positive numbers and subtracted in subtotal formulas.
• Balance Sheet: Assets, liabilities, and equity are all positive numbers.
• Cash Flow Statement: Cash inflows (e.g., net income, depreciation, increases in payables) are positive. Cash outflows (e.g., capex, dividends, increases in inventory) are negative.
• Working Capital: An increase in an asset (inventory) is a negative cash flow; an increase in a liability (accounts payable) is a positive cash flow.

1. Advertising revenue classification: Walmart records its global advertising business in either net sales or as a reduction to cost of sales depending on the arrangement. The model must not double-count this margin benefit when forecasting gross profit.
2. Stock split adjustments: The 3-for-1 stock split in February 2024 requires retroactive adjustment for all historical per-share metrics to ensure comparability.
3. Fuel sales volatility: Sam's Club comparable sales are reported both with and without fuel. The model should use ex-fuel comps for core retail forecasting and model fuel separately based on spot price assumptions.
4. Constant currency vs reported FX: Walmart International results swing heavily based on foreign exchange rates. The model should forecast on a constant currency basis and apply a top-level FX overlay.
5. Equity investment volatility: Walmart holds stakes in companies like JD.com and Symbotic. Mark-to-market unrealised gains and losses on these investments distort GAAP EPS and must be excluded from core operating forecasts.
6. E-commerce fulfillment costs: As digital penetration grows, delivery costs pressure operating margins. The model must reflect the tension between higher-margin advertising and lower-margin digital fulfillment.
7. Negative working capital dynamics: Because Walmart operates with negative working capital, a decline in revenue growth can actually cause a severe cash flow crunch as payables come due without sufficient new inventory sales to fund them.
8. Leap year lapping: Retail comps are highly sensitive to the number of selling days. The model must account for leap year effects when projecting Q1 and full-year growth rates.

1. Gross margin band: Consolidated gross margin should remain between 23.5% and 24.5%; flag if it exceeds this band as retail pricing power is constrained by the Everyday Low Price strategy.
2. Operating margin check: Operating margin should remain in the 4.0% to 5.5% range.
3. Capex intensity: Capital expenditures should consistently run between 2.5% and 3.5% of total revenues.
4. Cash conversion: Operating Cash Flow divided by Net Income should consistently exceed 1.2x due to depreciation and working capital advantages.
5. Leverage ratio: Total Debt to EBITDA should remain below 1.5x to align with the company's AA credit rating profile.
6. Balance sheet check: Total Assets must equal Total Liabilities plus Total Equity in every forecasted period.
7. Inventory turnover: Days Inventory Outstanding should remain between 40 and 45 days; a spike above 45 days indicates severe markdown risk.
8. Dividend payout: The dividend payout ratio should remain between 35% and 45% of adjusted earnings.

• Filings: SEC EDGAR (Form 10-K, 10-Q, 8-K) and the Walmart Investor Relations website.
• Key peers: Amazon (AMZN), Target (TGT), Costco (COST), Kroger (KR).
• Industry data: U.S. Census Bureau Monthly Retail Trade Report, NielsenIQ for grocery market share data.
• Consensus estimates: Bloomberg or FactSet for forward-looking analyst estimates on comp sales and EPS.
• Proprietary data: SimilarWeb for Walmart.com traffic trends, Placer.ai for physical store foot traffic analysis.

• Walmart Inc. Q4 FY25 Earnings Release (February 20, 2025)
• Walmart Inc. Q4 FY25 Earnings Presentation (February 20, 2025)
• Walmart Inc. Form 10-K for the fiscal year ended January 31, 2024