Walmart (WMT) Financial Forecast Calculator
Interactive 5-year forecast and DCF for Walmart. Adjust revenue growth, gross margin, capex intensity, WACC, and terminal growth - see revenue, free cash flow, and enterprise value update in real time. Seeded from Walmart’s most recent SEC filings.
Assumptions
Need this as an Excel model?
Keep iterating on the Walmart forecast in Excel. The downloadable sample has every assumption you see here plus a fully integrated income statement, balance sheet, cash flow, and debt schedule - five years of SEC historicals and live formulas in a fully editable workbook.
Other Staples forecasts
Run the same calculator on a peer.
Frequently asked
What is Walmart's core business model?+
Walmart Inc. operates as a people-led, tech-powered omnichannel retailer, offering a broad assortment of merchandise and services through stores, clubs, and e-commerce platforms globally. The company leverages its massive physical footprint to fulfill online orders and drive retail media networks, competing with major retailers like Amazon, Target, and Costco.
How does Walmart generate its revenue across different segments?+
Walmart generates revenue primarily through its Walmart U.S. segment, which accounts for approximately 68% of net sales, followed by Walmart International at about 18%, and Sam's Club at around 13%. The company's revenue drivers include sales from its extensive physical store network and increasingly from higher-margin e-commerce and advertising streams.
What are the key capital expenditure assumptions in Walmart's financial model?+
Walmart's financial model assumes capital expenditure as a percentage of revenue to be approximately 2.44%. This capex, typically ranging from 2.5% to 3.5% of revenue, is split roughly 40% for maintenance like store remodels and 60% for growth initiatives such as supply chain automation and e-commerce fulfillment centers.
What are the primary margin assumptions used in the Walmart financial model?+
The financial model for Walmart assumes a Cost of Goods Sold (COGS) as a percentage of revenue at approximately 75.99% and Selling, General, and Administrative (SGA) expenses at about 20.80% of revenue. These assumptions are crucial for evaluating the margin impact as the company transitions towards higher-margin e-commerce and advertising revenue streams.
How does Walmart's negative net working capital affect its valuation?+
Walmart's structurally negative net working capital, modeled at approximately -2.66% of revenue, indicates that the company sells inventory before it has to pay its suppliers. This unique working capital profile is a significant source of cash during growth periods, positively influencing its cash flow generation and, consequently, its valuation.
Is an Excel financial model available for Walmart (WMT) for download?+
Yes, a comprehensive Excel financial model for Walmart (WMT) is available for download, providing an equity valuation and scenario planning tool. This model allows analysts to evaluate the company's performance and forecast its financials through FY2031.
Have more financial modelling questions? Contact us
