# Stanley Black & Decker (SWK) Financial Model Free Excel 3-statement financial model and company analysis for Stanley Black & Decker. - Canonical: https://finamodel.com/companies/stanley-black-decker - Industry: Industrial Equipment - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/SWK.xlsx ## Model Purpose 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. ## Company Overview 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. ## 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 1. **Assumptions**: Hardcoded inputs for macroeconomic drivers, segment growth, margin targets, working capital days, and capital allocation. 2. **Scenarios**: Toggle for Base Case, Tariff Impact Case, and Margin Recovery Case. 3. **Income Statement**: Consolidated P&L from Net Sales down to Net Earnings, mirroring the 10-K format. 4. **Segment Build**: Revenue and Segment Profit broken out for Tools & Outdoor and Engineered Fastening. 5. **Balance Sheet**: Standard US GAAP balance sheet with detailed working capital lines. 6. **Cash Flow Statement**: Indirect method starting from Net Earnings, detailing working capital changes, capex, dividends, and debt paydown. 7. **Working Capital Schedule**: Calculation of Receivables, Inventory, and Payables based on DSO, DIO, and DPO. 8. **Debt & Interest Schedule**: Tranche-by-tranche debt build, mandatory repayments, discretionary paydown from FCF, and interest expense calculation. 9. **PP&E & Intangibles**: Capex, depreciation, and amortisation waterfall. 10. **DCF Valuation**: Unlevered free cash flow build, WACC calculation, terminal value, and implied share price. ## Key Financial Relationships 1. Tools & Outdoor Revenue = Prior Year Tools & Outdoor Revenue x (1 + T&O Volume Growth + T&O Price/Mix Growth) 2. Engineered Fastening Revenue = Prior Year Engineered Fastening Revenue x (1 + EF Volume Growth + EF Price/Mix Growth) 3. Total Net Sales = Tools & Outdoor Revenue + Engineered Fastening Revenue 4. Segment Profit (T&O) = Tools & Outdoor Revenue x T&O Adjusted Segment Margin 5. Segment Profit (EF) = Engineered Fastening Revenue x EF Adjusted Segment Margin 6. Consolidated Gross Profit = Total Net Sales x Adjusted Gross Margin % 7. SG&A Expense = Total Net Sales x SG&A % of Sales 8. Adjusted Operating Income = Consolidated Gross Profit - SG&A Expense 9. Inventory Balance = (Cost of Sales / 365) x Days Inventory Outstanding 10. Free Cash Flow = Cash from Operating Activities - Capital Expenditures 11. Discretionary Debt Paydown = MAX(0, Free Cash Flow - Dividends Paid - Minimum Cash Requirement) 12. 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 * Stanley Black & Decker Q4 and Full Year 2025 Earnings Release (February 4, 2026) * Stanley Black & Decker 2025 Annual Report and 10-K Filing * Seeking Alpha Earnings Call Transcripts and Analysis * SEC.gov Company Filings Database --- ## Frequently asked questions ### 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. [Interactive forecast calculator](https://finamodel.com/companies/stanley-black-decker/forecast)