All companies
W. W. Grainger logo
IndustrialsGWW

W. W. Grainger (GWW) Financial Forecast Calculator

Interactive 5-year forecast and DCF for W. W. Grainger. 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 W. W. Grainger’s most recent SEC filings.

Revenue FY30
$25.87B
from $16.48B
FCF FY30
$1.76B
Margin 6.8%
Enterprise value
$24.78B
1.5× LTM revenue
Equity value
$23.03B
Net debt $1.74B
Revenue & free cash flow - history and 5-year forecast
Line (area)
Bars
Historicals from SEC EDGAR (grey). Forecast years (color) update live as you move the sliders.

Assumptions

Revenue growth (annual)
9.4%
-10.0%baseline 9.4%40.0%
Gross margin
37.7%
5.0%baseline 37.7%90.0%
Capex % of revenue
2.0%
0.0%baseline 2.0%30.0%
WACC (discount rate)
9.00%
4.0%baseline 9.0%18.0%
Terminal growth
2.50%
0.0%baseline 2.5%5.0%

Need this as an Excel model?

Keep iterating on the W. W. Grainger 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.

income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

Frequently asked

What does W.W. Grainger, Inc. (GWW) do?+

W.W. Grainger is a leading broad-line, business-to-business distributor of maintenance, repair, and operating (MRO) supplies, serving over 4.6 million customers worldwide. The company provides millions of products, from safety gear to power tools, alongside value-added services like inventory management and technical support.

How does W.W. Grainger generate revenue from its different business segments?+

W.W. Grainger generates revenue through its High-Touch Solutions N.A. segment, serving large enterprises with deep sales engagement, and its Endless Assortment segment (MonotaRO and Zoro), targeting small to mid-sized businesses primarily online. The High-Touch segment accounts for approximately 78% of revenue, while Endless Assortment contributes about 22%.

What is W.W. Grainger's typical capital expenditure as a percentage of revenue?+

W.W. Grainger's capital expenditure typically ranges between 2.0% and 2.5% of revenue. Approximately 70% of this capex is allocated to growth initiatives, such as supply chain expansion, automation, and digital platforms, with the remaining 30% for maintenance.

How does W.W. Grainger's working capital profile impact its cash flow?+

W.W. Grainger maintains a positive and significant net working capital, largely due to holding massive inventory to ensure next-day delivery. During periods of high growth, building up this inventory requires a substantial use of cash.

What are the key analytical focuses of the W.W. Grainger financial model?+

The W.W. Grainger financial model helps analysts forecast margin impacts from tariffs and inflation, evaluate the high-growth trajectory of the Endless Assortment segment against the mature High-Touch Solutions core business, and assess the cash flow available for aggressive share repurchases. It serves as a comprehensive equity valuation and scenario planning tool.

Can I download an Excel financial model for W.W. Grainger (GWW)?+

Yes, an Excel financial model for W.W. Grainger (GWW) is available for download. This general corporate model provides a forecast horizon from FY2026 to FY2030, allowing for detailed analysis of the company's future financial performance.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview