W. W. Grainger Financial Model
Industrial Equipment Company Financials Example (Free Excel Download)
W.W.
professionals from Deloitte
Used by professionals from
About this model
This model provides a comprehensive equity valuation and scenario planning tool for W.W. Grainger, Inc. (GWW), enabling an analyst to forecast the margin impacts of tariff and inflation headwinds, evaluate the high-growth trajectory of the Endless Assortment segment (MonotaRO and Zoro) against the mature High-Touch Solutions core business, and assess the cash flow available for aggressive share repurchases.
- 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 (KeepStock) and technical support.
- Business Segments:
- High-Touch Solutions N.A. (~78% of revenue): Serves complex, large enterprise and mid-market customers in the US and Canada with deep sales-force engagement, technical expertise, and integrated procurement solutions.
- Endless Assortment (~22% of revenue): Operates primarily through MonotaRO (Japan) and Zoro (US), targeting small to mid-sized businesses with a streamlined, online-only model offering millions of SKUs.
- Key Geographies: United States, Canada, and Japan.
- Business Model: B2B distribution. It is relatively asset-light compared to manufacturing, but requires significant working capital (inventory) and a robust, purpose-built supply chain and distribution centre (DC) footprint.
- Competitive Position: Grainger is the market leader in the highly fragmented North American MRO market, leveraging its massive scale, purchasing power, and next-day delivery capabilities to take continuous market share from smaller local and regional distributors.
- Recent Major Events: In Q4 2025, Grainger strategically exited the U.K. market by selling its Cromwell business and closing Zoro U.K., resulting in non-cash charges but structurally improving go-forward consolidated operating margins.
The downloadable W. W. Grainger financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
Historicals & AssumptionsW. W. Grainger financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $13.02B | $15.23B | $16.48B | $17.17B | $17.94B |
| Gross profit | $4.72B | $5.85B | $6.50B | $6.76B | $7.01B |
| Operating income | $1.55B | $2.21B | $2.56B | $2.64B | $2.50B |
| Net income | $1.04B | $1.55B | $1.83B | $1.91B | $1.71B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for W. W. Grainger
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
High-Touch Solutions N.A.
- Segment Name: High-Touch Solutions N.A.
- Revenue Driver Formula: `(Prior Year Segment Revenue) x (1 + Volume Growth + Price/Mix Contribution)`
- Historical Growth Rate: 3% - 8% CAGR (highly correlated with US industrial production and non-residential investment).
- Key Growth Levers and Headwinds: Market share capture through sales force expansion, KeepStock (inventory management) deployments, and e-procurement integrations. Headwinds include macroeconomic industrial slowdowns and tariff-related pricing pressures.
- Pricing Dynamics: Contractual pricing for large enterprises, spot pricing for mid-market. Grainger actively manages price/cost dynamics to pass through supplier inflation and tariffs.
- Revenue Recognition: Recognised upon shipment or delivery of products (point in time).
- Seasonality: Q2 and Q3 are typically the strongest quarters due to higher construction, facility maintenance, and seasonal product demand (e.g., HVAC, safety gear).
Endless Assortment
- Segment Name: Endless Assortment
- Revenue Driver Formula: `Active Registered Customers x Average Annual Spend per Customer`
- Historical Growth Rate: 12% - 18% CAGR.
- Key Growth Levers and Headwinds: Digital marketing efficiency, SKU expansion (adding hundreds of thousands of items annually), and enterprise customer adoption at MonotaRO. Headwinds include digital advertising costs and intense online competition.
- Pricing Dynamics: Highly dynamic, algorithm-driven spot pricing based on market scraping and competitor matching.
- Revenue Recognition: Point in time upon shipment.
- Seasonality: Less seasonal than High-Touch, but heavily influenced by the timing of digital marketing campaigns and Japanese business cycles (for MonotaRO).
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Product purchase costs (the vast majority), inbound freight, and tariff costs.
- Gross Margin Range: 38.5% - 39.5% consolidated (High-Touch runs ~41-42%, Endless Assortment runs ~30-31%).
- Key Input Costs: Wholesale cost of MRO products, steel/resin commodity pass-throughs from suppliers, and trans-Pacific shipping rates.
- How COGS scales: Linear with revenue, but heavily impacted by inventory accounting. Grainger uses the Last-In, First-Out (LIFO) method for ~79% of its inventory, meaning inflationary periods (or new tariffs) immediately hit COGS and compress gross margins.
Operating Expenses
- R&D: Not material / not reported separately. IT and software development are capitalised or sit in SG&A.
- SG&A: Includes branch network costs, distribution centre operations, outbound freight, sales force compensation, digital marketing (heavy in Endless Assortment), and corporate overhead.
- Depreciation & Amortisation: ~1.5% - 2.0% of revenue, primarily related to distribution centre automation, buildings, and capitalised software.
- Stock-Based Compensation: ~0.3% - 0.5% of revenue.
- Restructuring: Occasional charges related to branch network optimisation or market exits (e.g., Q4 2025 U.K. exit).
Margin Profile
- Gross Margin: ~39.1% (2025 actual).
- Operating Margin: ~15.0% (2025 actual), expected to expand to 15.4% - 15.9% post-U.K. exit.
- Margin Trend: Structurally expanding due to SG&A leverage and the divestiture of dilutive international operations, though occasionally pressured by LIFO inventory accounting during tariff/inflation spikes.
Balance Sheet Structure
- Total Assets: ~$8.5B - $9.5B.
- Key Asset Categories: Inventory is the largest asset, followed by Property, Buildings and Equipment (distribution centres), and Accounts Receivable.
- Goodwill & Intangibles: ~10-15% of total assets (historical bolt-on acquisitions, Cromwell, Cromwell impairment).
- Working Capital Profile:
- Days Sales Outstanding (DSO): ~35 - 40 days.
- Days Inventory Outstanding (DIO): ~110 - 120 days (Grainger holds massive inventory to guarantee next-day delivery).
- Days Payable Outstanding (DPO): ~45 - 55 days.
- Net working capital: Positive and significant. Working capital is a major use of cash during high-growth periods as inventory must be built up.
- PP&E: Heavily weighted towards highly automated, mega-distribution centres (e.g., the new Mito DC in Japan) and IT infrastructure.
- Right-of-use assets: Material, representing leased branch locations and some distribution facilities.
Capital Expenditure & Investment
- Capex as % of revenue: 2.0% - 2.5%.
- Maintenance vs. Growth: ~30% maintenance, ~70% growth (supply chain expansion, automation, and digital platforms).
- Major Capex Programmes: Multi-year investments in automated distribution centres (both in the US and Japan for MonotaRO) and AI/machine learning capabilities for the seller insights platform.
- Capitalised Software: Significant ongoing investment in Grainger.com, Zoro.com, and internal ERP/supply chain management systems.
- M&A Pattern: Historically a bolt-on acquirer, but currently focused on organic growth and portfolio rationalisation (exiting the U.K.).
Debt & Capital Structure
- Total Debt: ~$2.0B - $2.5B.
- Debt/EBITDA Ratio: ~0.8x - 1.2x (very conservatively capitalised).
- Credit Rating: A+ / A3 (Investment Grade).
- Key Debt Instruments: Unsecured senior notes and a revolving credit facility (maturing 2025/extended).
- Maturity Profile: Well-laddered with long-dated senior notes.
- Interest Rate Profile: Predominantly fixed-rate bonds.
- Share Repurchase Programme: Highly active. Grainger routinely returns excess FCF to shareholders, repurchasing ~$1.0B+ annually.
- Dividend Policy: Dividend aristocrat. Yield is typically ~1.0% - 1.5%, with a payout ratio of ~25% - 30% and consistent annual growth.
Cash Flow Characteristics
- OCF Conversion: Consistently >1.0x Net Income, though it can dip below 1.0x during periods of rapid revenue growth due to heavy inventory investments.
- Free Cash Flow Margin: 8% - 10% of revenue.
- Major Non-Cash Items: Depreciation, amortisation, LIFO inventory reserve adjustments, and deferred income taxes.
- Working Capital Impact: Inventory is the largest swing factor. In inflationary environments, the LIFO reserve increases (non-cash add-back), but physical inventory replenishment consumes significant cash.
- Cash Tax Rate: Closely mirrors the GAAP effective tax rate (~23.8%).
Sheet Structure
- Assumptions: Hardcoded drivers for macroeconomic inputs, segment growth, margins, working capital days, and capital allocation.
- Scenarios: Base, Bull, and Bear cases toggling tariff impacts, MonotaRO growth, and US industrial production.
- Income Statement: Consolidated P&L mirroring the 10-K (Net Sales, COGS, Gross Profit, SG&A, Operating Earnings, Interest, Taxes, Net Earnings).
- Segment Build:
- High-Touch Solutions N.A. (Sales, Gross Profit, Operating Earnings)
- Endless Assortment (Sales, Gross Profit, Operating Earnings)
- Corporate / Unallocated (to bridge to consolidated).
- Balance Sheet: Standard US GAAP presentation (Cash, AR, Inventory, Other Current, PP&E, ROU Assets, Goodwill, AP, Accrued Expenses, Current Debt, Long-Term Debt, Equity).
- Cash Flow Statement: Indirect method starting from Net Earnings, adjusting for D&A, LIFO reserve, working capital changes, capex, debt issuance/repayment, dividends, and buybacks.
- Working Capital Schedule: DSO, DIO, DPO calculations driving AR, Inventory, and AP balances.
- Debt & Interest Schedule: Tranche-by-tranche debt build, mandatory repayments, revolver draw/paydown, and interest expense calculation.
- PP&E & Intangibles: Capex, depreciation waterfall, and capitalised software amortisation.
- Shareholders' Equity: Retained earnings roll-forward, share count reduction from buybacks, and dividend payments.
- DCF Valuation: Unlevered free cash flow build, WACC calculation, terminal value, and implied share price.
Key Financial Relationships
- `High-Touch Solutions N.A. Sales = Prior Year Sales x (1 + High-Touch Daily Sales Growth Rate)`
- `Endless Assortment Sales = Prior Year Sales x (1 + Endless Assortment Daily Sales Growth Rate)`
- `Consolidated Net Sales = High-Touch Solutions N.A. Sales + Endless Assortment Sales`
- `High-Touch Gross Profit = High-Touch Sales x High-Touch Gross Margin %`
- `Endless Assortment Gross Profit = Endless Assortment Sales x Endless Assortment Gross Margin %`
- `Consolidated COGS = Consolidated Net Sales - (High-Touch Gross Profit + Endless Assortment Gross Profit)`
- `Segment Operating Earnings = Segment Gross Profit - Segment SG&A`
- `Consolidated Operating Earnings = High-Touch Operating Earnings + Endless Assortment Operating Earnings - Unallocated Corporate Expenses`
- `Ending Inventory = (Consolidated COGS / 365) x DIO`
- `Ending Accounts Receivable = (Consolidated Net Sales / 365) x DSO`
- `Ending Accounts Payable = (Consolidated COGS / 365) x DPO`
- `Basic Shares Outstanding = Prior Period Shares - (Share Repurchases / Average Share Price)`
- `Dividends Paid = Basic Shares Outstanding x Annual Dividend Per Share`
- `Unlevered Free Cash Flow = Consolidated Operating Earnings x (1 - Effective Tax Rate) + D&A - Capex - Change in Net Working Capital`
Cross-Sheet Dependencies
- Assumptions feeds all growth rates, margin profiles, and working capital days into the Segment Build and Working Capital Schedule.
- Segment Build aggregates into the Income Statement to form the top half of the P&L (Revenue down to Operating Earnings).
- Working Capital Schedule calculates AR, Inventory, and AP, which feed the Balance Sheet (assets/liabilities) and the Cash Flow Statement (change in NWC).
- Debt & Interest Schedule uses cash flow deficits/surpluses from the Cash Flow Statement to trigger revolver draws/paydowns, and feeds Interest Expense back to the Income Statement. *Note: This creates a circular reference that must be managed with a circuit breaker toggle.*
- Cash Flow Statement ending cash balance feeds the Balance Sheet cash line.
- Income Statement Net Earnings feeds the top of the Cash Flow Statement and the Retained Earnings line in Shareholders' Equity.
Sign Convention
- Revenues and Assets: Positive.
- Expenses and Liabilities: Positive on their specific schedules, but subtracted in aggregation formulas (e.g., `Gross Profit = Revenue - COGS`).
- Cash Flow Statement: Cash inflows are positive; cash outflows (e.g., Capex, Dividends, Share Repurchases) are negative.
- Contra-Assets (e.g., Accumulated Depreciation): Negative.
Things Most Likely to Go Wrong
- LIFO Inventory Accounting: Grainger uses LIFO for 79% of inventory. In the model, COGS will spike immediately if you input a tariff or inflation shock, compressing gross margins faster than a FIFO-based distributor.
- Selling Days vs. Reported Growth: Grainger frequently reports "daily sales growth" which normalises for the number of selling days in a quarter/year (e.g., 255 vs 256 days). The model must forecast absolute reported sales, so ensure growth rates are applied to the correct base.
- U.K. Exit Stub Period: The Q4 2025 exit of the U.K. market (Cromwell/Zoro UK) removes a chunk of historical revenue. 2026 growth rates must be applied to a pro-forma 2025 base that excludes the U.K., otherwise 2026 revenue will be understated.
- FX Exposure (MonotaRO): The Endless Assortment segment is heavily weighted towards Japan. A weakening Yen (JPY/USD) will severely drag reported USD revenue growth for this segment despite strong local currency growth.
- Segment Margin Mix: Endless Assortment grows much faster than High-Touch but has lower gross margins. If the model does not build revenue and COGS from the segment level up, consolidated gross margin will fail to capture this structural mix-shift headwind.
- Working Capital Cash Drain: Because Grainger guarantees next-day delivery, high revenue growth requires massive inventory builds. If DIO is kept flat during a revenue spike, the model will correctly show a massive cash outflow for inventory - do not manually override this to "fix" cash flow.
- Share Count Reduction: Grainger buys back stock aggressively. Failing to dynamically reduce the share count will result in understated EPS and an overstated dividend cash burden in the out-years.
- Corporate Allocations: Segment operating earnings do not sum perfectly to consolidated operating earnings due to unallocated corporate expenses. The model must include a corporate overhead line to bridge the gap.
Validation Checks
- "Consolidated Gross Margin should remain between 38.5% and 39.5%; flag if segment mix-shift pushes it outside this band."
- "Consolidated Operating Margin should be >15.0% post-2025 due to the U.K. exit and SG&A leverage."
- "High-Touch Solutions N.A. should represent ~75-78% of total sales; Endless Assortment should represent ~22-25%."
- "Capex as a % of revenue should be between 2.0% and 2.5%."
- "OCF / Net Income conversion should be >1.0x in steady-state years."
- "Debt / EBITDA should remain below 1.5x (company is historically under-levered)."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Effective tax rate should be ~23.8%."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| High-Touch Solutions N.A. Sales Growth | 6.25 | % | Midpoint of 2026 guidance (5.0% - 7.5%) |
| Endless Assortment Sales Growth | 13.75 | % | Midpoint of 2026 guidance (12.5% - 15.0%) |
| High-Touch Gross Margin | 41.5 | % | Historical average, adjusting for stabilising tariff impacts |
| Endless Assortment Gross Margin | 30.5 | % | Historical average, reflecting online-only model |
| High-Touch SG&A as % of Sales | 25.5 | % | Historical average |
| Endless Assortment SG&A as % of Sales | 20.0 | % | Historical average, reflecting digital marketing spend |
| Unallocated Corporate Expense | 1.0 | % of Total Sales | Historical run-rate |
| Days Sales Outstanding (DSO) | 38 | Days | Based on 2024/2025 actuals |
| Days Inventory Outstanding (DIO) | 115 | Days | Based on 2024/2025 actuals (LIFO adjusted) |
| Days Payable Outstanding (DPO) | 50 | Days | Based on 2024/2025 actuals |
| Capex as % of Revenue | 2.2 | % | Management guidance for supply chain investments |
| Effective Tax Rate | 23.8 | % | 2025 actual / 2026 guidance |
| Annual Share Repurchases | 1,100 | $ Millions | Historical run-rate of capital return programme |
| Dividend Payout Ratio | 28.0 | % | Historical average |
| Cost of Debt | 4.5 | % | Weighted average interest rate on senior notes |
| WACC | 8.5 | % | Standard for US large-cap industrial distributor |
| Terminal Growth Rate | 2.5 | % | Long-term GDP + inflation proxy |
Data Sources & Benchmarks
- SEC Filings: W.W. Grainger Investor Relations (invest.grainger.com) or SEC EDGAR (Form 10-K, 10-Q, 8-K).
- Key Peers for Benchmarking: Fastenal (FAST), MSC Industrial Direct (MSM), Wesco International (WCC), Watsco (WSO).
- Industry Data Sources: US Industrial Production Index (Federal Reserve FRED), ISM Manufacturing PMI.
- Consensus Estimates: FactSet, Bloomberg, or Yahoo Finance for near-term EPS and revenue consensus.
- Proprietary Data: SimilarWeb (for tracking Zoro.com and MonotaRO.com web traffic and conversion rates as a leading indicator for Endless Assortment sales).
Sources
- W.W. Grainger Q4 2025 Earnings Release and Presentation (February 2026)
- W.W. Grainger 2025 Annual Report on Form 10-K (February 2026)
- W.W. Grainger Q3 2025 Earnings Release and Presentation (October 2025)
- Seeking Alpha: Grainger outlines 2026 revenue outlook (February 2026)
- Distribution Strategy Group: Grainger posts solid sales growth but profit slips amid strategic U.K. exit (October 2025)
Do more with the W. W. Grainger model
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
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Industrial Equipment Company Financial Models
Browse another company in the same sector.
Ametek
Ametek is a global manufacturer of highly engineered electronic instruments and electromechanical devices, serving niche industrial markets through organic innovation and disciplined acquisitions.
Caterpillar
Caterpillar is the world's leading manufacturer of construction and mining equipment, off-highway diesel and natural gas engines, industrial gas turbines, and diesel-electric locomotives.
Cummins
Cummins designs, manufactures, distributes, and services a broad portfolio of power solutions, from diesel and natural gas engines to electric and hybrid powertrains, for commercial vehicle and industrial markets.
Deere & Company
Deere & Company is a global leader in the manufacturing of agricultural, construction, and forestry equipment, operating under the iconic John Deere brand.
Dover
Dover Corporation is a diversified global manufacturer delivering innovative equipment, consumable supplies, aftermarket parts, and software solutions.
Emerson Electric
Emerson Electric is a global technology and software company providing advanced automation solutions for process, hybrid, and discrete manufacturing industries, helping customers optimise operations, reduce emissions, and improve safety through proprietary hardware and software.
Fastenal
Fastenal Company is a leading North American wholesale distributor of industrial and construction supplies, operating through a dense network of branches and customer-specific Onsite locations.
Fortive
Fortive is a diversified industrial technology conglomerate that provides essential technologies for connected workflow solutions across industrial and healthcare applications.
Explore more Manufacturing financial model templates.
