# W. W. Grainger (GWW) Financial Model

Free Excel 3-statement financial model and company analysis for W. W. Grainger.

- Canonical: https://finamodel.com/companies/w-w-grainger
- Industry: Industrial Equipment
- Downloadable model: Yes
- Excel download: https://finamodel.com/company-models/GWW.xlsx

## Model Purpose

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.

## Company Overview

- 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.

## 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

1. **Assumptions**: Hardcoded drivers for macroeconomic inputs, segment growth, margins, working capital days, and capital allocation.
2. **Scenarios**: Base, Bull, and Bear cases toggling tariff impacts, MonotaRO growth, and US industrial production.
3. **Income Statement**: Consolidated P&L mirroring the 10-K (Net Sales, COGS, Gross Profit, SG&A, Operating Earnings, Interest, Taxes, Net Earnings).
4. **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).
5. **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).
6. **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.
7. **Working Capital Schedule**: DSO, DIO, DPO calculations driving AR, Inventory, and AP balances.
8. **Debt & Interest Schedule**: Tranche-by-tranche debt build, mandatory repayments, revolver draw/paydown, and interest expense calculation.
9. **PP&E & Intangibles**: Capex, depreciation waterfall, and capitalised software amortisation.
10. **Shareholders' Equity**: Retained earnings roll-forward, share count reduction from buybacks, and dividend payments.
11. **DCF Valuation**: Unlevered free cash flow build, WACC calculation, terminal value, and implied share price.

## Key Financial Relationships

1. `High-Touch Solutions N.A. Sales = Prior Year Sales x (1 + High-Touch Daily Sales Growth Rate)`
2. `Endless Assortment Sales = Prior Year Sales x (1 + Endless Assortment Daily Sales Growth Rate)`
3. `Consolidated Net Sales = High-Touch Solutions N.A. Sales + Endless Assortment Sales`
4. `High-Touch Gross Profit = High-Touch Sales x High-Touch Gross Margin %`
5. `Endless Assortment Gross Profit = Endless Assortment Sales x Endless Assortment Gross Margin %`
6. `Consolidated COGS = Consolidated Net Sales - (High-Touch Gross Profit + Endless Assortment Gross Profit)`
7. `Segment Operating Earnings = Segment Gross Profit - Segment SG&A`
8. `Consolidated Operating Earnings = High-Touch Operating Earnings + Endless Assortment Operating Earnings - Unallocated Corporate Expenses`
9. `Ending Inventory = (Consolidated COGS / 365) x DIO`
10. `Ending Accounts Receivable = (Consolidated Net Sales / 365) x DSO`
11. `Ending Accounts Payable = (Consolidated COGS / 365) x DPO`
12. `Basic Shares Outstanding = Prior Period Shares - (Share Repurchases / Average Share Price)`
13. `Dividends Paid = Basic Shares Outstanding x Annual Dividend Per Share`
14. `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

1. **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.
2. **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.
3. **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.
4. **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.
5. **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.
6. **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.
7. **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.
8. **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

1. "Consolidated Gross Margin should remain between 38.5% and 39.5%; flag if segment mix-shift pushes it outside this band."
2. "Consolidated Operating Margin should be >15.0% post-2025 due to the U.K. exit and SG&A leverage."
3. "High-Touch Solutions N.A. should represent ~75-78% of total sales; Endless Assortment should represent ~22-25%."
4. "Capex as a % of revenue should be between 2.0% and 2.5%."
5. "OCF / Net Income conversion should be >1.0x in steady-state years."
6. "Debt / EBITDA should remain below 1.5x (company is historically under-levered)."
7. "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
8. "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)

---

## Frequently asked questions

### 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.

[Interactive forecast calculator](https://finamodel.com/companies/w-w-grainger/forecast)