Stanley Black & Decker Financial Model
Industrial Equipment Company Financials Example (Free Excel Download)
Stanley Black & Decker (SWK) is a global provider of hand tools, power tools, outdoor products, and highly engineered fastening solutions.
professionals from Deloitte
Used by professionals from
About this model
This model evaluates the equity valuation and credit profile of Stanley Black & Decker to help an analyst determine if the company's ongoing margin recovery programme and debt reduction efforts justify a "Buy" rating.
Stanley Black & Decker (SWK) is a global provider of hand tools, power tools, outdoor products, and highly engineered fastening solutions. The company serves builders, tradespeople, DIY enthusiasts, and industrial customers through iconic brands such as DEWALT, STANLEY, CRAFTSMAN, and Cub Cadet.
Business segments:
- Tools & Outdoor (approx. 87% of revenue)
- Engineered Fastening (approx. 13% of revenue)
Key geographies:
- United States (approx. 62%)
- Europe (approx. 16%)
- Emerging Markets (approx. 13%)
- Canada (approx. 4%)
The business model is manufacturing-heavy and relies on global supply chains, extensive retail distribution networks (especially home improvement centres), and brand loyalty. Its competitive position is strong, ranking as the global leader in tools and storage, competing primarily with Techtronic Industries (Milwaukee, Ryobi) and Makita. Recent major events include the $2.1 billion Global Cost Reduction Programme, the 2024 divestiture of STANLEY Infrastructure to Epiroc, and the pending 2026 divestiture of the Consolidated Aerospace Manufacturing (CAM) business for $1.8 billion.
The downloadable Stanley Black & Decker 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 & AssumptionsStanley Black & Decker financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $15.28B | $16.95B | $15.78B | $15.37B | $15.13B |
| Gross profit | $5.09B | $4.28B | $3.93B | $4.51B | $4.59B |
| Cost of sales | $10.42B | $12.66B | $11.85B | $10.85B | $10.54B |
| Net income | $1.69B | $1.06B | -$310.5M | $294.3M | $401.9M |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Stanley Black & Decker
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Tools & Outdoor
- Segment name: Tools & Outdoor
- Revenue driver formula: Volume (Units Sold) x Average Selling Price (ASP)
- Historical growth rate: -5% to +2% (highly cyclical, down 2% in 2025)
- Key growth levers and headwinds: Driven by US housing turnover, repair and remodel (R&R) activity, and retail inventory destocking. Weather patterns heavily influence the outdoor power equipment sub-segment.
- Pricing dynamics: Highly competitive but supported by brand strength. The company has implemented significant pricing actions to offset inflation and tariffs.
- Revenue recognition notes: Recognised at the point of sale when control transfers to the retailer or distributor.
- Seasonality: Q2 and Q4 are typically the strongest quarters due to the spring outdoor season and winter holiday promotions, respectively.
Engineered Fastening
- Segment name: Engineered Fastening
- Revenue driver formula: Industrial Production Volume x Price per Fastener/Component
- Historical growth rate: 2% to 8% (up 6% in 2025)
- Key growth levers and headwinds: Driven by global automotive production, aerospace build rates, and general industrial capital expenditure.
- Pricing dynamics: Often contractual with raw material pass-through clauses, though lag times exist.
- Revenue recognition notes: Recognised upon shipment or delivery to the OEM customer.
- Seasonality: Relatively evenly distributed, with slight dips in Q3 and Q4 due to automotive plant holiday shutdowns.
Cost Structure
Variable Costs / COGS
- COGS includes raw materials (steel, resin, base metals, lithium-ion battery cells), purchased components, manufacturing labour, freight, and import tariffs.
- Gross margin range: 20% to 35% (dropped to the low 20s in 2022/2023 due to supply chain shocks, recovered to 30.7% adjusted in 2025, targeting 35% by late 2026).
- Input costs are highly exposed to commodity cycles and trans-Pacific shipping rates.
- COGS scales linearly with volume, but factory absorption creates operating leverage. When production is cut to reduce inventory, unabsorbed fixed overhead severely penalises gross margins.
Operating Expenses
- R&D: Typically 1.5% to 2.0% of revenue, expensed as incurred, covering new product development and battery technology.
- SG&A: Typically 21% to 23% of revenue (21.5% adjusted in 2025). This includes heavy marketing and brand activation spend, sales force compensation, and corporate overhead.
- Depreciation & Amortisation: Approximately 3% to 4% of revenue, reflecting the asset-heavy manufacturing base and amortisation of acquired intangibles (e.g., CRAFTSMAN brand).
- Stock-Based Compensation: Approximately 0.5% of revenue.
- Restructuring / one-time charges: Highly frequent in recent years, with over $100 million in annual charges related to the supply chain transformation and footprint rationalisation.
Margin Profile
- Gross margin: 25% to 35% (expanding).
- EBITDA margin: 8% to 15% (13.5% adjusted in 2025).
- Operating margin: 5% to 12%.
- Net margin: 2% to 7%.
- Segment margins: Tools & Outdoor runs at 10% to 14% (13.6% adjusted in 2025), while Engineered Fastening runs at 12% to 15% (12.1% in 2025).
Balance Sheet Structure
- Total assets are approximately $25 billion.
- Key asset categories include Inventory, Goodwill, and Intangible Assets.
- Goodwill & intangibles represent over 50% of total assets, a legacy of serial acquisitions (Black & Decker, Newell Tools, Craftsman, MTD Holdings).
- Working capital profile:
- Days Sales Outstanding (DSO): 45 to 55 days.
- Days Inventory Outstanding (DIO): 120 to 160 days (historically elevated post-pandemic, a major focus of current cash generation efforts).
- Days Payable Outstanding (DPO): 80 to 100 days.
- Net working capital as % of revenue is typically 15% to 20%.
- Working capital is positive and represents a massive use of cash during growth phases, but a source of cash during downturns as inventory is liquidated.
- PP&E consists of global manufacturing facilities and distribution centres, depreciated over 3 to 40 years.
- Right-of-use assets for operating leases are material, typically around $600 million, related to warehouses and distribution centres.
Capital Expenditure & Investment
- Capex as % of revenue: 2.0% to 3.0% (projected at $300 million or approx. 2.0% for 2026).
- Maintenance capex represents roughly 60% of total capex, with the remainder dedicated to automation, footprint consolidation, and new product tooling.
- Major capex programmes are currently constrained to prioritise free cash flow generation and debt paydown.
- Capitalised software is present but not a primary driver of the asset base.
- M&A pattern: Historically a transformational and bolt-on acquirer, but currently in a divestiture phase to repair the balance sheet.
Debt & Capital Structure
- Total debt is approximately $7.5 billion, with net debt around $7.1 billion.
- Debt/EBITDA ratio: Currently elevated above 4.0x, with management targeting 2.5x by the end of 2026.
- Credit rating: Investment grade (BBB range), which management is highly motivated to protect.
- Key debt instruments include senior unsecured notes, a commercial paper programme, and a revolving credit facility.
- Maturity profile includes near-term maturities that the company actively manages through refinancing and using divestiture proceeds (e.g., the $1.5 billion expected net proceeds from the CAM sale).
- Interest rate profile is predominantly fixed via bonds, with a weighted average cost of debt around 4.5%.
- The share repurchase programme is currently suspended to prioritise debt reduction.
- Dividend policy: The company is a "Dividend King" with over 50 consecutive years of increases. The current yield is approximately 3.5%, with a payout ratio often exceeding 100% of GAAP earnings during the recent trough, but normalising as earnings recover.
Cash Flow Characteristics
- Operating cash flow conversion (OCF / Net Income) is highly volatile, often exceeding 2.0x during inventory destocking phases (e.g., $971 million OCF on $402 million GAAP net income in 2025).
- Free cash flow margin (FCF / Revenue) ranges from 4% to 8% ($688 million FCF in 2025).
- Major non-cash items include depreciation, amortisation of intangibles, and significant non-cash asset impairment charges.
- Working capital cash flow impact is the primary swing factor for OCF. Inventory reduction has been the main source of cash over the last 24 months.
- Capex intensity is relatively low, allowing for strong cash conversion when working capital is neutral.
- The cash tax rate often differs from the GAAP effective tax rate due to restructuring charges and geographic mix.
Sheet Structure
- Assumptions: Hardcoded inputs for macroeconomic drivers, segment growth, margin targets, working capital days, and capital allocation.
- Scenarios: Toggle for Base Case, Tariff Impact Case, and Margin Recovery Case.
- Income Statement: Consolidated P&L from Net Sales down to Net Earnings, mirroring the 10-K format.
- Segment Build: Revenue and Segment Profit broken out for Tools & Outdoor and Engineered Fastening.
- Balance Sheet: Standard US GAAP balance sheet with detailed working capital lines.
- Cash Flow Statement: Indirect method starting from Net Earnings, detailing working capital changes, capex, dividends, and debt paydown.
- Working Capital Schedule: Calculation of Receivables, Inventory, and Payables based on DSO, DIO, and DPO.
- Debt & Interest Schedule: Tranche-by-tranche debt build, mandatory repayments, discretionary paydown from FCF, and interest expense calculation.
- PP&E & Intangibles: Capex, depreciation, and amortisation waterfall.
- DCF Valuation: Unlevered free cash flow build, WACC calculation, terminal value, and implied share price.
Key Financial Relationships
- Tools & Outdoor Revenue = Prior Year Tools & Outdoor Revenue x (1 + T&O Volume Growth + T&O Price/Mix Growth)
- Engineered Fastening Revenue = Prior Year Engineered Fastening Revenue x (1 + EF Volume Growth + EF Price/Mix Growth)
- Total Net Sales = Tools & Outdoor Revenue + Engineered Fastening Revenue
- Segment Profit (T&O) = Tools & Outdoor Revenue x T&O Adjusted Segment Margin
- Segment Profit (EF) = Engineered Fastening Revenue x EF Adjusted Segment Margin
- Consolidated Gross Profit = Total Net Sales x Adjusted Gross Margin %
- SG&A Expense = Total Net Sales x SG&A % of Sales
- Adjusted Operating Income = Consolidated Gross Profit - SG&A Expense
- Inventory Balance = (Cost of Sales / 365) x Days Inventory Outstanding
- Free Cash Flow = Cash from Operating Activities - Capital Expenditures
- Discretionary Debt Paydown = MAX(0, Free Cash Flow - Dividends Paid - Minimum Cash Requirement)
- Interest Expense = Average Total Debt x Weighted Average Interest Rate
Cross-Sheet Dependencies
- The Segment Build feeds Total Net Sales and Segment Profit into the Income Statement.
- The Income Statement feeds Net Earnings into the Cash Flow Statement and Retained Earnings into the Balance Sheet.
- The Working Capital Schedule uses Net Sales and Cost of Sales from the Income Statement to calculate balances, which feed the Balance Sheet and the change in working capital on the Cash Flow Statement.
- The Debt & Interest Schedule uses Free Cash Flow from the Cash Flow Statement to determine debt paydown, which updates the debt balances on the Balance Sheet and feeds Interest Expense back to the Income Statement. This creates a circular reference that must be managed with a toggle or iterative calculation.
- The DCF Valuation pulls NOPAT and D&A from the Income Statement and Capex/Working Capital changes from the Cash Flow Statement.
Sign Convention
- Revenue, Gross Profit, and Net Income are positive.
- Expenses (COGS, SG&A, Interest, Taxes) are entered as positive numbers in their respective schedules but subtracted in summation formulas.
- On the Cash Flow Statement, cash inflows (e.g., Net Income, Depreciation, increase in Payables) are positive. Cash outflows (e.g., increase in Inventory, Capex, Dividends) are negative.
- Debt paydown is a negative cash flow but reduces the positive debt balance on the Balance Sheet.
Things Most Likely to Go Wrong
- Failing to account for the pending CAM divestiture. The model must remove approximately $400 million in annual revenue and adjust margins for the stub period in 2026.
- Mismodelling the gross margin recovery. The company is targeting 35% by late 2026, but tariffs and production curtailments can severely delay this.
- Confusing GAAP and Adjusted EPS. The company reports massive restructuring charges that depress GAAP earnings. The model should forecast on an adjusted basis and handle restructuring below the operating line.
- Overestimating cash flow by ignoring the limits of inventory destocking. Once DIO normalises, working capital will become a use of cash as revenue grows.
- Ignoring the dividend burden. The company pays over $480 million annually in dividends, which severely restricts the cash available for debt reduction.
- Miscalculating the impact of unabsorbed overhead. If volume drops and the company cuts production, gross margins will fall faster than revenue due to fixed factory costs.
- Forgetting to exclude the divested Infrastructure segment from historical growth rate calculations to ensure a like-for-like comparison.
- Incorrectly linking the debt paydown logic, causing the model to pay down more debt than available cash allows.
Validation Checks
- Adjusted Gross Margin should trend towards the 33% to 35% range; flag if it exceeds 36% or drops below 28%.
- Free Cash Flow should be between $600 million and $900 million in the near term based on management guidance.
- Debt/EBITDA must decline towards the 2.5x target by 2026/2027; flag if leverage remains above 3.5x.
- Dividend payout ratio should be checked against Free Cash Flow to ensure the dividend is covered by cash generation, not debt.
- Total Assets must equal Total Liabilities plus Equity in every forecasted period.
- Capex as a percentage of revenue should not fall below 1.5%, as this would imply underinvestment in maintenance.
- The effective tax rate should remain in the 24% to 27% range for adjusted earnings.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| T&O Revenue Growth (2026) | 1.0 | % | Modest recovery in US retail demand offsetting tariff pressures |
| EF Revenue Growth (2026) | 4.0 | % | Continued strength in aerospace and automotive markets |
| Adjusted Gross Margin | 33.0 | % | Management guidance for 2026, progressing towards 35% target |
| SG&A as % of Sales | 21.5 | % | Maintained cost discipline from the Global Cost Reduction Programme |
| Days Sales Outstanding (DSO) | 50 | Days | Historical average |
| Days Inventory Outstanding (DIO) | 135 | Days | Continued improvement from destocking initiatives |
| Days Payable Outstanding (DPO) | 90 | Days | Historical average |
| Capex as % of Revenue | 2.0 | % | Based on $300M guidance on ~$15B revenue |
| Effective Tax Rate | 26.6 | % | 2025 adjusted actual rate |
| Weighted Average Interest Rate | 4.5 | % | Blended rate of current outstanding senior notes |
| Annual Dividend per Share | 3.32 | USD | Current run-rate, assuming minimal increases until target leverage is met |
| Target Net Debt / EBITDA | 2.5 | x | Stated management goal for year-end 2026 |
| WACC | 8.5 | % | Standard discount rate for industrial manufacturing peers |
| Terminal Growth Rate | 2.0 | % | Long-term GDP growth proxy |
Data Sources & Benchmarks
- SEC EDGAR for SWK 10-K and 10-Q filings.
- Stanley Black & Decker Investor Relations page for earnings presentations and the 2025 Annual Report.
- Key peers for benchmarking: Techtronic Industries (HKG: 0669), Makita (TYO: 6586), Snap-on (SNA), and Illinois Tool Works (ITW).
- Industry data sources: US Census Bureau (Housing Starts, Repair & Remodel indices), Global automotive production forecasts.
- Consensus estimates from FactSet or Bloomberg for validation of 2026/2027 revenue and EPS projections.
Sources
Do more with the Stanley Black & Decker model
Frequently asked
What does Stanley Black & Decker (SWK) do?+
Stanley Black & Decker is a global provider of hand tools, power tools, outdoor products, and highly engineered fastening solutions. The company serves builders, tradespeople, DIY enthusiasts, and industrial customers through iconic brands such as DEWALT, STANLEY, and CRAFTSMAN.
What are the main revenue segments for Stanley Black & Decker?+
Stanley Black & Decker's revenue is primarily driven by its Tools & Outdoor segment, which accounts for approximately 87% of total revenue. The Engineered Fastening segment contributes the remaining 13% of the company's sales.
What is Stanley Black & Decker's typical capital expenditure as a percentage of revenue?+
Stanley Black & Decker's capital expenditure typically ranges from 2.0% to 3.0% of revenue. For 2026, it is projected at approximately $300 million, or 2.0% of revenue, with current major capex programs constrained to prioritize free cash flow generation and debt paydown.
What is the primary purpose of the Stanley Black & Decker financial model?+
The financial model evaluates the equity valuation and credit profile of Stanley Black & Decker. This helps an analyst determine if the company's ongoing margin recovery program and debt reduction efforts justify a 'Buy' rating.
Can I download an Excel financial model for Stanley Black & Decker (SWK)?+
Yes, an Excel financial model for Stanley Black & Decker (SWK) is available for download. This general corporate model provides a forecast horizon from FY2026 to FY2030, incorporating key assumptions like revenue growth and margin percentages.
How does Stanley Black & Decker manage its working capital?+
Stanley Black & Decker's net working capital as a percentage of revenue is typically 15% to 20%, representing a significant use of cash during growth phases. The company is currently focused on improving Days Inventory Outstanding (DIO), which has been historically elevated, as a major part of its cash generation efforts.
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.
