← Filings of SWK
Tables in the 10-Q of STANLEY BLACK & DECKER, INC.
61 tables with numbers, filed Nov 12, 2021. Each one downloads as a CSV for Excel or
Google Sheets, with the filing's address in the last row. Only the layout is tidied (a "$" or ")" in a cell of its own is joined to its number); no value is changed.
Open the filing on sec.gov ↗
| PART I — FINANCIAL INFORMATION | 3 |
| ITEM 1. CONDENSED CONSOLIDATED FINANCIAL STATEMENTS | 3 |
| ITEM 2. MANAGEMENT’S DISCUSSION AND ANALYSIS OF FINANCIAL CONDITION AND RESULTS OF OPERATIONS | 38 |
| ITEM 3. QUANTITATIVE AND QUALITATIVE DISCLOSURES ABOUT MARKET RISK | 50 |
| ITEM 4. CONTROLS AND PROCEDURES | 50 |
| PART II — OTHER INFORMATION | 53 |
| ITEM 1. LEGAL PROCEEDINGS | 53 |
| ITEM 1A. RISK FACTORS | 53 |
First 8 of 11 rows. The CSV has all of them.
Table 2 after “(Unaudited, Millions of Dollars, Except Share and Per Share Amounts)”
Download CSV
| Third Quarter | Year-to-Date | | | | |
| 2021 | 2020 | | 2021 | 2020 | |
| Net Sales | $4,263.2 | | $3,850.2 | | $12,761.2 | $10,127.0 |
| Costs and Expenses | | | | | | |
| Cost of sales | $2,871.7 | | $2,473.9 | | $8,261.8 | $6,714.9 |
| Selling, general and administrative | 895.2 | | 731.3 | | 2,645.1 | 2,182.1 |
| Provision for credit losses | 3.6 | | 7.6 | | 8.2 | 37.3 |
| Other, net | 39.5 | | 74.3 | | 152.3 | 236.1 |
First 8 of 31 rows. The CSV has all of them.
Table 3 after “(Unaudited, Millions of Dollars, Except Share and Per Share Amounts)”
Download CSV
| October 2, 2021 | January 2, 2021 | |
| ASSETS | | | |
| Current Assets | | | |
| Cash and cash equivalents | $292.7 | | $1,381.0 |
| Accounts and notes receivable, net | 1,989.0 | | 1,512.2 |
| Inventories, net | 4,134.4 | | 2,737.4 |
| Prepaid expenses | 419.3 | | 370.7 |
| Other current assets | 41.0 | | 34.7 |
First 8 of 38 rows. The CSV has all of them.
Table 4 after “(Unaudited, Millions of Dollars)”
Download CSV
| Third Quarter | Year-to-Date | | | | |
| 2021 | 2020 | | 2021 | 2020 | |
| OPERATING ACTIVITIES | | | | | | |
| Net earnings | $414.1 | | $395.2 | | $1,359.4 | $767.0 |
| Adjustments to reconcile net earnings to cash provided by operating activities: | | | | | | |
| Depreciation and amortization of property, plant and equipment | 93.9 | | 94.1 | | 279.3 | 281.1 |
| Amortization of intangibles | 50.3 | | 51.2 | | 151.3 | 150.0 |
| Loss on sales of businesses | — | | — | | 3.6 | — |
First 8 of 37 rows. The CSV has all of them.
Table 5 after “The following table provides a reconciliation of the cash, cash equivalents and restricted cash balances as of October 2, 2021 and January 2”
Download CSV
| October 2, 2021 | January 2, 2021 | |
| Cash and cash equivalents | $292.7 | | $1,381.0 |
| Restricted cash included in Other current assets | 10.7 | | 17.3 |
| Cash, cash equivalents and restricted cash | $303.4 | | $1,398.3 |
Table 6 after “(Unaudited, Millions of Dollars, Except Share and Per Share Amounts)”
Download CSV
| Preferred Stock | Common Stock | | Additional Paid In Capital | Retained Earnings | Accumulated Other Comprehensive Loss | | Treasury Stock | Non- Controlling Interests | Shareowners’ Equity | | | |
| Balance January 2, 2021 | $1,500.0 | | $442.3 | | $4,832.7 | | $7,547.6 | | $(1,713.7) | | $(1,549.3) | $6.8 | $11,066.4 |
| Net earnings (loss) | — | | — | | — | | 487.4 | | — | | — | (0.6) | 486.8 |
| Other comprehensive loss | — | | — | | — | | — | | (97.7) | | — | — | (97.7) |
| Cash dividends declared — $0.70 per common share | — | | — | | — | | (110.1) | | — | | — | — | (110.1) |
| Cash dividends declared — $50.00 per annum per preferred share | — | | — | | — | | (9.4) | | — | | — | — | (9.4) |
| Issuance of common stock (848,275 shares) | — | | — | | (12.7) | | — | | — | | 76.8 | — | 64.1 |
| Repurchase of common stock (80,310 shares) | — | | — | | — | | — | | — | | (14.9) | — | (14.9) |
First 8 of 27 rows. The CSV has all of them.
| Preferred Stock | Common Stock | | Additional Paid In Capital | Retained Earnings | Accumulated Other Comprehensive Loss | | ESOP | Treasury Stock | Non- Controlling Interests | | Shareowners’ Equity | | | |
| Balance December 28, 2019 | $1,500.0 | | $442.3 | | $4,492.9 | | $6,772.8 | | $(1,884.6) | | $(2.3) | | $(2,184.8) | $5.9 | $9,142.2 |
| Net earnings (loss) | — | | — | | — | | 133.2 | | — | | — | | — | (0.1) | 133.1 |
| Other comprehensive loss | — | | — | | — | | — | | (258.8) | | — | | — | — | (258.8) |
| Cash dividends declared — $0.69 per common share | — | | — | | — | | (105.6) | | — | | — | | — | — | (105.6) |
| Issuance of common stock (744,339 shares) | — | | — | | (20.5) | | — | | — | | — | | 65.1 | — | 44.6 |
| Repurchase of common stock (125,294 shares) | — | | — | | 10.0 | | — | | — | | — | | (19.0) | — | (9.0) |
| Preferred stock issuance costs | — | | — | | (1.2) | | — | | — | | — | | — | — | (1.2) |
First 8 of 30 rows. The CSV has all of them.
Table 8 after “The following table reconciles net earnings attributable to common shareowners and the weighted-average shares outstanding used to calculate”
Download CSV
| Third Quarter | Year-to-Date | | | | |
| 2021 | 2020 | | 2021 | 2020 | |
| Numerator (in millions): | | | | | | |
| Net Earnings Attributable to Common Shareowners | $414.6 | | $385.5 | | $1,347.8 | $752.4 |
| Denominator (in thousands): | | | | | | |
| Basic weighted-average shares outstanding | 159,444 | | 156,370 | | 158,494 | 153,345 |
| Dilutive effect of stock contracts and awards | 5,892 | | 1,601 | | 6,406 | 1,414 |
| Diluted weighted-average shares outstanding | 165,336 | | 157,971 | | 164,900 | 154,759 |
First 8 of 11 rows. The CSV has all of them.
Table 9 after “The following weighted-average stock options were not included in the computation of weighted-average diluted shares outstanding because the”
Download CSV
| Third Quarter | Year-to-Date | | | | |
| 2021 | 2020 | | 2021 | 2020 | |
| Number of stock options | 1,042 | | 2,059 | | 948 | 2,947 |
Table 10 after “ACCOUNTS AND NOTES RECEIVABLE, NET”
Download CSV
| (Millions of Dollars) | October 2, 2021 | January 2, 2021 | |
| Trade accounts receivable | $1,816.0 | | $1,345.7 |
| Trade notes receivable | 150.7 | | 156.1 |
| Other accounts receivable | 161.4 | | 151.5 |
| Gross accounts and notes receivable | $2,128.1 | | $1,653.3 |
| Allowance for credit losses | (139.1) | | (141.1) |
| Accounts and notes receivable, net | $1,989.0 | | $1,512.2 |
| Long-term receivables, net | $138.0 | | $139.9 |
Table 11 after “The changes in the allowance for credit losses for the three and nine months ended October 2, 2021 and September 26, 2020 are as follows:”
Download CSV
| (Millions of Dollars) | Balance July 3, 2021 | Cumulative Effect Adjustment (a) | | Charged To Costs and Expenses | Charged To Other Accounts (b) | Deductions (c) | | Balance October 2, 2021 | | |
| Accounts receivable | $126.4 | | $— | | $3.4 | | $(2.6) | | $(3.1) | $124.1 |
| Notes receivable | 14.8 | | — | | 0.2 | | — | | — | 15.0 |
| Total | $141.2 | | $— | | $3.6 | | $(2.6) | | $(3.1) | $139.1 |
Table 12 after “The changes in the allowance for credit losses for the three and nine months ended October 2, 2021 and September 26, 2020 are as follows:”
Download CSV
| (Millions of Dollars) | Balance January 2, 2021 | Cumulative Effect Adjustment (a) | | Charged To Costs and Expenses | Charged To Other Accounts (b) | Deductions (c) | | Balance October 2, 2021 | | |
| Accounts receivable | $126.7 | | $— | | $7.6 | | $(1.8) | | $(8.4) | $124.1 |
| Notes receivable | 14.4 | | — | | 0.6 | | — | | — | 15.0 |
| Total | $141.1 | | $— | | $8.2 | | $(1.8) | | $(8.4) | $139.1 |
| (Millions of Dollars) | Balance June 27, 2020 | Cumulative Effect Adjustment (a) | | Charged To Costs and Expenses | Charged To Other Accounts (b) | Deductions (c) | | Balance September 26, 2020 | | |
| Accounts receivable | 122.9 | | — | | 7.6 | | 2.3 | | (9.4) | 123.4 |
| Notes receivable | 13.6 | | — | | — | | 0.3 | | — | 13.9 |
| Total | $136.5 | | $— | | $7.6 | | $2.6 | | $(9.4) | $137.3 |
| (Millions of Dollars) | Balance December 28 2019 | Cumulative Effect Adjustment (a) | | Charged To Costs and Expenses | Charged To Other Accounts (b) | Deductions (c) | | Balance September 26, 2020 | | |
| Accounts receivable | $99.3 | | $2.9 | | $37.3 | | $(0.5) | | $(15.6) | $123.4 |
| Notes receivable | $13.1 | | $0.9 | | $— | | $0.2 | | $(0.3) | $13.9 |
| Total | $112.4 | | $3.8 | | $37.3 | | $(0.3) | | $(15.9) | $137.3 |
Table 15 after “The following is a summary of the expected timing of receipt of payments from customers on an undiscounted basis as of October 2, 2021 relat”
Download CSV
| (Millions of Dollars) | Total | Within 1 Year | | 2 Years | 3 Years | 4 Years | | 5 Years | Thereafter | | |
| Financing receivables | $199.2 | | $73.1 | | $54.3 | | $37.7 | | $21.6 | $10.8 | $1.7 |
| Operating leases | $28.3 | | $26.5 | | $0.9 | | $0.5 | | $0.3 | $0.1 | $— |
Table 16 after “The following is a summary of lease revenue and sales-type lease profit for the three and nine months ended October 2, 2021 and September 26”
Download CSV
| Third Quarter | Year-to-Date | | | | |
| (Millions of Dollars) | 2021 | 2020 | | 2021 | 2020 | |
| Sales-type lease revenue | $27.8 | | $28.2 | | $93.8 | $82.0 |
| Lease interest revenue | 3.2 | | 3.3 | | 9.9 | 9.4 |
| Operating lease revenue | 21.5 | | 30.4 | | 61.6 | 101.9 |
| Total lease revenue | $52.5 | | $61.9 | | $165.3 | $193.3 |
| Sales-type lease profit | $11.0 | | $11.2 | | $37.3 | $32.6 |
Table 17 after “The components of Inventories, net at October 2, 2021 and January 2, 2021 are as follows:”
Download CSV
| (Millions of Dollars) | October 2, 2021 | January 2, 2021 | |
| Finished products | $2,777.4 | | $1,922.5 |
| Work in process | 350.3 | | 222.3 |
| Raw materials | 1,006.7 | | 592.6 |
| Total | $4,134.4 | | $2,737.4 |
Table 18 after “The following table summarizes the acquisition date value of identifiable net assets acquired and liabilities assumed:”
Download CSV
| (Millions of Dollars) | |
| Cash and cash equivalents | $35.8 |
| Accounts receivable, net | 48.3 |
| Inventories, net | 124.3 |
| Prepaid expenses and other assets | 2.6 |
| Property, plant and equipment | 127.9 |
| Trade names | 25.0 |
| Customer relationships | 565.0 |
First 8 of 16 rows. The CSV has all of them.
Table 19 after “The following table presents supplemental pro-forma information as if the 2020 acquisitions had occurred on December 30, 2018. The pro-forma”
Download CSV
| (Millions of Dollars, except per share amounts) | Third Quarter 2020 | Year-to-Date 2020 | |
| Net sales | $3,854.2 | | $10,185.0 |
| Net earnings attributable to common shareowners | $392.5 | | $791.7 |
| Diluted earnings per share | $2.48 | | $5.12 |
Table 20 after “Changes in the carrying amount of goodwill by segment are as follows:”
Download CSV
| (Millions of Dollars) | Tools & Storage | Industrial | | Security | Total | |
| Balance January 2, 2021 | $5,247.7 | | $2,646.5 | | $2,143.9 | $10,038.1 |
| Acquisitions | 4.4 | | (0.5) | | 5.2 | 9.1 |
| Foreign currency translation | (41.2) | | (19.5) | | (42.4) | (103.1) |
| Balance October 2, 2021 | $5,210.9 | | $2,626.5 | | $2,106.7 | $9,944.1 |
Table 21 after “Long-term debt and financing arrangements at October 2, 2021 and January 2, 2021 are as follows:”
Download CSV
| | October 2, 2021 | January 2, 2021 | | | | | | | | | |
| (Millions of Dollars) | Interest Rate | Original Notional | Unamortized Discount | | Unamortized Gain/(Loss) Terminated Swaps 1 | Purchase Accounting FV Adjustment | Deferred Financing Fees | | Carrying Value | Carrying Value | | |
| Notes payable due 2026 | 3.40% | $500.0 | | $(0.5) | | $— | | $— | | $(1.9) | $497.6 | $497.2 |
| Notes payable due 2028 | 7.05% | 150.0 | | — | | 7.4 | | 7.1 | | — | 164.5 | 166.1 |
| Notes payable due 2028 | 4.25% | 500.0 | | (0.3) | | — | | — | | (3.1) | 496.6 | 496.2 |
| Notes payable due 2030 | 2.30% | 750.0 | | (2.1) | | — | | — | | (4.4) | 743.5 | 742.9 |
| Notes payable due 2040 | 5.20% | 400.0 | | (0.2) | | (27.9) | | — | | (2.6) | 369.3 | 368.1 |
| Notes payable due 2048 | 4.85% | 500.0 | | (0.5) | | — | | — | | (5.0) | 494.5 | 494.3 |
First 8 of 11 rows. The CSV has all of them.
Table 22 after “A summary of the fair values of the Company’s derivatives recorded in the Condensed Consolidated Balance Sheets at October 2, 2021 and Janua”
Download CSV
| (Millions of Dollars) | Balance Sheet Classification | October 2, 2021 | January 2, 2021 | | Balance Sheet Classification | October 2, 2021 | January 2, 2021 | |
| Derivatives designated as hedging instruments: | | | | | | | | |
| Interest Rate Contracts Cash Flow | Other current assets | $— | | $— | | Accrued expenses | $60.6 | $90.9 |
| Foreign Exchange Contracts Cash Flow | Other current assets | 17.8 | | — | | Accrued expenses | 0.9 | 23.7 |
| LT other assets | 0.4 | | — | | LT other liabilities | — | — |
| Net Investment Hedge | Other current assets | 2.3 | | 3.5 | | Accrued expenses | 0.5 | 55.1 |
| LT other assets | 0.4 | | — | | LT other liabilities | — | 5.7 |
| Total designated as hedging | | $20.9 | | $3.5 | | | $62.0 | $175.4 |
First 8 of 11 rows. The CSV has all of them.
Table 23 after “The tables below detail pre-tax amounts of derivatives designated as cash flow hedges in Accumulated other comprehensive income (loss) durin”
Download CSV
| Third Quarter 2021 | | | | | | |
| (Millions of dollars) | Gain (Loss) Recorded in OCI | Classification of Gain (Loss) Reclassified from OCI to Income | | Gain (Loss) Reclassified from OCI to Income | | Gain (Loss) Recognized in Income on Amounts Excluded from Effectiveness Testing | |
| Interest Rate Contracts | $2.9 | | Interest expense | | $(0.8) | | $— |
| Foreign Exchange Contracts | $11.0 | | Cost of sales | | $(9.9) | | $— |
| Year-to-Date 2021 | | | | | | |
| (Millions of Dollars) | Gain (Loss) Recorded in OCI | Classification of Gain (Loss) Reclassified from OCI to Income | | Gain (Loss) Reclassified from OCI to Income | | Gain (Loss) Recognized in Income on Amounts Excluded from Effectiveness Testing | |
| Interest Rate Contracts | $30.3 | | Interest expense | | $(2.9) | | $— |
| Foreign Exchange Contracts | $19.2 | | Cost of sales | | $(21.3) | | $— |
| Third Quarter 2020 | | | | | | |
| (Millions of dollars) | Gain (Loss) Recorded in OCI | Classification of Gain (Loss) Reclassified from OCI to Income | | Gain (Loss) Reclassified from OCI to Income | | Gain (Loss) Recognized in Income on Amounts Excluded from Effectiveness Testing | |
| Interest Rate Contracts | $1.9 | | Interest expense | | $(4.3) | | $— |
| Foreign Exchange Contracts | $(5.3) | | Cost of sales | | $5.9 | | $— |
| Year-to-Date 2020 | | | | | | |
| (Millions of Dollars) | Gain (Loss) Recorded in OCI | Classification of Gain (Loss) Reclassified from OCI to Income | | Gain (Loss) Reclassified from OCI to Income | | Gain (Loss) Recognized in Income on Amounts Excluded from Effectiveness Testing | |
| Interest Rate Contracts | $(92.1) | | Interest expense | | $(13.5) | | $— |
| Foreign Exchange Contracts | $10.1 | | Cost of sales | | $12.5 | | $— |
Table 27 after “A summary of the pre-tax effect of cash flow hedge accounting on the Consolidated Statements of Operations and Comprehensive Income for the ”
Download CSV
| Third Quarter 2021 | Year-to-Date 2021 | | | | |
| (Millions of Dollars) | Cost of Sales | Interest Expense | | Cost of Sales | Interest Expense | |
| Total amount in the Consolidated Statements of Operations and Comprehensive Income in which the effects of the cash flow hedges are recorded | $2,871.7 | | $45.8 | | $8,261.8 | $139.8 |
| Gain (loss) on cash flow hedging relationships: | | | | | | |
| Foreign Exchange Contracts: | | | | | | |
| Hedged Items | $9.9 | | $— | | $21.3 | $— |
| Gain (loss) reclassified from OCI into Income | $(9.9) | | $— | | $(21.3) | $— |
| Interest Rate Swap Agreements: | | | | | | |
First 8 of 9 rows. The CSV has all of them.
Table 28 after “A summary of the pre-tax effect of cash flow hedge accounting on the Consolidated Statements of Operations and Comprehensive Income for the ”
Download CSV
| Third Quarter 2020 | Year-to-Date 2020 | | | | |
| (Millions of Dollars) | Cost of Sales | Interest Expense | | Cost of Sales | Interest Expense | |
| Total amount in the Consolidated Statements of Operations and Comprehensive Income in which the effects of the cash flow hedges are recorded | $2,473.9 | | $52.7 | | $6,714.9 | $169.7 |
| Gain (loss) on cash flow hedging relationships: | | | | | | |
| Foreign Exchange Contracts: | | | | | | |
| Hedged Items | $(5.9) | | $— | | $(12.5) | $— |
| Gain (loss) reclassified from OCI into Income | $5.9 | | $— | | $12.5 | $— |
| Interest Rate Swap Agreements: | | | | | | |
First 8 of 9 rows. The CSV has all of them.
Table 29 after “A summary of the pre-tax effect of fair value hedge accounting on the Consolidated Statements of Operations and Comprehensive Income for the”
Download CSV
| (Millions of Dollars) | Third Quarter 2021 Interest Expense | Year-to-Date 2021 Interest Expense | |
| Total amount in the Consolidated Statements of Operations and Comprehensive Income in which the effects of the fair value hedges are recorded | $45.8 | | $139.8 |
| Amortization of gain on terminated swaps | $(0.1) | | $(0.3) |
Table 30 after “A summary of the pre-tax effect of fair value hedge accounting on the Consolidated Statements of Operations and Comprehensive Income for the”
Download CSV
| (Millions of Dollars) | Third Quarter 2020 Interest Expense | Year-to-Date 2020 Interest Expense | |
| Total amount in the Consolidated Statements of Operations and Comprehensive Income in which the effects of the fair value hedges are recorded | $52.7 | | $169.7 |
| Amortization of gain on terminated swaps | $(0.8) | | $(2.4) |
| October 2, 2021 | | | |
| (Millions of Dollars) | Carrying Amount of Hedged Liability (1) | Cumulative Amount of Fair Value Hedging Adjustment Included in the Carrying Amount of the Hedged Liability | | |
| Long-Term Debt | $4,246.9 | | Terminated Swaps | $(20.5) |
| January 2, 2021 | | | |
| (Millions of Dollars) | Carrying Amount of Hedged Liability (1) | Cumulative Amount of Fair Value Hedging Adjustment Included in the Carrying Amount of the Hedged Liability | | |
| Long-Term Debt | $4,245.4 | | Terminated Swaps | $(20.8) |
Table 33 after “The pre-tax gain or loss from fair value changes for the three and nine months ended October 2, 2021 and September 26, 2020 was as follows:”
Download CSV
| Third Quarter 2021 | | | | | | |
| (Millions of Dollars) | Total Gain (Loss) Recorded in OCI | Excluded Component Recorded in OCI | | Income Statement Classification | Total Gain (Loss) Reclassified from OCI to Income | Excluded Component Amortized from OCI to Income | |
| Forward Contracts | $(0.4) | | $0.3 | | Other, net | $0.4 | $0.4 |
| Cross Currency Swap | $(0.2) | | $6.0 | | Other, net | $0.8 | $0.8 |
Table 34 after “The pre-tax gain or loss from fair value changes for the three and nine months ended October 2, 2021 and September 26, 2020 was as follows:”
Download CSV
| Year-to-Date 2021 | | | | | | |
| (Millions of Dollars) | Total Gain (Loss) Recorded in OCI | Excluded Component Recorded in OCI | | Income Statement Classification | Total Gain (Loss) Reclassified from OCI to Income | Excluded Component Amortized from OCI to Income | |
| Forward Contracts | $(1.4) | | $1.1 | | Other, net | $1.1 | $1.1 |
| Cross Currency Swap | $9.1 | | $19.9 | | Other, net | $2.9 | $2.9 |
Table 35 after “The pre-tax gain or loss from fair value changes for the three and nine months ended October 2, 2021 and September 26, 2020 was as follows:”
Download CSV
| Third Quarter 2020 | | | | | | |
| (Millions of Dollars) | Total Gain (Loss) Recorded in OCI | Excluded Component Recorded in OCI | | Income Statement Classification | Total Gain (Loss) Reclassified from OCI to Income | Excluded Component Amortized from OCI to Income | |
| Forward Contracts | $0.3 | | $— | | Other, net | $— | $— |
| Cross Currency Swap | $(19.0) | | $14.0 | | Other, net | $4.1 | $4.1 |
| Non-derivative designated as Net Investment Hedge | $(13.1) | | $— | | Other, net | $— | $— |
Table 36 after “The pre-tax gain or loss from fair value changes for the three and nine months ended October 2, 2021 and September 26, 2020 was as follows:”
Download CSV
| Year-to-Date 2020 | | | | | | |
| (Millions of Dollars) | Total Gain (Loss) Recorded in OCI | Excluded Component Recorded in OCI | | Income Statement Classification | Total Gain (Loss) Reclassified from OCI to Income | Excluded Component Amortized from OCI to Income | |
| Forward Contracts | $0.4 | | $— | | Other, net | $— | $— |
| Cross Currency Swap | $22.3 | | $48.9 | | Other, net | $13.7 | $13.7 |
| Non-derivative designated as Net Investment Hedge | $(8.5) | | $— | | Other, net | $— | $— |
Table 37 after “The gain (loss) recorded in income from changes in the fair value related to derivatives not designated as hedging instruments under ASC 815”
Download CSV
| (Millions of Dollars) | Income Statement Classification | Third Quarter 2021 | Year-to-Date 2021 | | Third Quarter 2020 | Year-to-Date 2020 | |
| Foreign Exchange Contracts | Other, net | $3.4 | | $(20.1) | | $(9.0) | $(2.6) |
Table 38 after “The following tables summarize the changes in the balances for each component of Accumulated other comprehensive loss:”
Download CSV
| (Millions of Dollars) | Currency translation adjustment and other | Unrealized (losses) gains on cash flow hedges, net of tax | | Unrealized gains (losses) on net investment hedges, net of tax | Pension (losses) gains, net of tax | Total | | |
| Balance - January 2, 2021 | $(1,235.3) | | $(103.0) | | $72.8 | | $(448.2) | $(1,713.7) |
| Other comprehensive (loss) income before reclassifications | (239.7) | | 42.9 | | 5.9 | | 6.6 | (184.3) |
| Reclassification adjustments to earnings | — | | 13.5 | | (3.0) | | 12.7 | 23.2 |
| Net other comprehensive (loss) income | (239.7) | | 56.4 | | 2.9 | | 19.3 | (161.1) |
| Balance - October 2, 2021 | $(1,475.0) | | $(46.6) | | $75.7 | | $(428.9) | $(1,874.8) |
Table 39 after “The following tables summarize the changes in the balances for each component of Accumulated other comprehensive loss:”
Download CSV
| (Millions of Dollars) | Currency translation adjustment and other | Unrealized (losses) gains on cash flow hedges, net of tax | | Unrealized gains (losses) on net investment hedges, net of tax | Pension (losses) gains, net of tax | Total | | |
| Balance - December 28, 2019 | $(1,517.2) | | $(54.2) | | $97.3 | | $(410.5) | $(1,884.6) |
| Other comprehensive (loss) income before reclassifications | (29.2) | | (61.7) | | 10.3 | | 3.0 | (77.6) |
| Reclassification adjustments to earnings | — | | 0.6 | | (10.4) | | 10.9 | 1.1 |
| Net other comprehensive (loss) income | (29.2) | | (61.1) | | (0.1) | | 13.9 | (76.5) |
| Balance - September 26, 2020 | $(1,546.4) | | $(115.3) | | $97.2 | | $(396.6) | $(1,961.1) |
| (Millions of Dollars) | 2021 | 2020 | | Affected line item in Consolidated Statements of Operations And Comprehensive Income | |
| Realized (losses) gains on cash flow hedges | $(21.3) | | $12.5 | | Cost of sales |
| Realized losses on cash flow hedges | (2.9) | | (13.5) | | Interest expense |
| Total before taxes | $(24.2) | | $(1.0) | | |
| Tax effect | 10.7 | | 0.4 | | Income taxes |
| Realized losses on cash flow hedges, net of tax | $(13.5) | | $(0.6) | | |
| Realized gains on net investment hedges | $4.0 | | $13.7 | | Other, net |
| Tax effect | (1.0) | | (3.3) | | Income taxes |
First 8 of 15 rows. The CSV has all of them.
Table 41 after “Following are the components of net periodic pension (benefit) expense for the three and nine months ended October 2, 2021 and September 26,”
Download CSV
| Third Quarter | | | | | | | | | |
| Pension Benefits | Other Benefits | | | | | | | | |
| U.S. Plans | Non-U.S. Plans | | All Plans | | | | | | |
| (Millions of Dollars) | 2021 | 2020 | | 2021 | 2020 | 2021 | | 2020 | | |
| Service cost | $1.7 | | $1.7 | | $4.3 | | $4.0 | | $0.2 | $0.2 |
| Interest cost | 5.7 | | 8.8 | | 4.2 | | 5.7 | | 0.2 | 0.3 |
| Expected return on plan assets | (13.8) | | (14.7) | | (10.0) | | (10.4) | | — | — |
| Amortization of prior service cost (credit) | 0.3 | | 0.3 | | (0.2) | | (0.1) | | (0.2) | (0.3) |
First 8 of 12 rows. The CSV has all of them.
Table 42 after “Following are the components of net periodic pension (benefit) expense for the three and nine months ended October 2, 2021 and September 26,”
Download CSV
| Year-to-Date | | | | | | | | | |
| Pension Benefits | Other Benefits | | | | | | | | |
| U.S. Plans | Non-U.S. Plans | | All Plans | | | | | | |
| (Millions of Dollars) | 2021 | 2020 | | 2021 | 2020 | 2021 | | 2020 | | |
| Service cost | $4.9 | | $5.1 | | $13.3 | | $11.9 | | $0.3 | $0.5 |
| Interest cost | 17.2 | | 26.5 | | 12.8 | | 16.7 | | 0.7 | 1.1 |
| Expected return on plan assets | (41.2) | | (44.1) | | (30.2) | | (30.6) | | — | — |
| Amortization of prior service cost (credit) | 0.9 | | 0.8 | | (0.6) | | (0.5) | | (0.5) | (1.0) |
First 8 of 12 rows. The CSV has all of them.
Table 43 after “The following table presents the Company’s financial assets and liabilities that are measured at fair value on a recurring basis for each of”
Download CSV
| (Millions of Dollars) | Total Carrying Value | Level 1 | | Level 2 | Level 3 | |
| October 2, 2021 | | | | | | |
| Money market fund | $29.7 | | $29.7 | | $— | $— |
| Equity Security | $18.6 | | $18.6 | | $— | $— |
| Derivative assets | $29.6 | | $— | | $29.6 | $— |
| Derivative liabilities | $69.2 | | $— | | $69.2 | $— |
| Contingent consideration liability | $189.3 | | $— | | $— | $189.3 |
| January 2, 2021 | | | | | | |
First 8 of 12 rows. The CSV has all of them.
Table 44 after “The following table provides information about the Company's financial assets and liabilities not carried at fair value:”
Download CSV
| October 2, 2021 | January 2, 2021 | | | | |
| (Millions of Dollars) | Carrying Value | Fair Value | | Carrying Value | Fair Value | |
| Other investments | $11.2 | | $11.7 | | $13.3 | $13.9 |
| Long-term debt | $4,246.9 | | $4,828.7 | | $4,245.4 | $4,934.5 |
Table 45 after “A summary of the restructuring reserve activity from January 2, 2021 to October 2, 2021 is as follows:”
Download CSV
| (Millions of Dollars) | January 2, 2021 | Net Additions | | Usage | Currency | October 2, 2021 | | |
| Severance and related costs | $87.5 | | $5.9 | | $(49.9) | | $2.0 | $45.5 |
| Facility closures and asset impairments | 2.7 | | 16.2 | | (15.3) | | — | 3.6 |
| Total | $90.2 | | $22.1 | | $(65.2) | | $2.0 | $49.1 |
Table 46 after “The Company utilizes segment profit, which is defined as net sales minus cost of sales and SG&A inclusive of the provision for credit losses”
Download CSV
| Third Quarter | Year-to-Date | | | | |
| (Millions of Dollars) | 2021 | 2020 | | 2021 | 2020 | |
| NET SALES | | | | | | |
| Tools & Storage | $3,185.9 | | $2,804.1 | | $9,445.3 | $7,072.1 |
| Industrial | 593.5 | | 586.6 | | 1,853.4 | 1,694.8 |
| Security | 483.8 | | 459.5 | | 1,462.5 | 1,360.1 |
| Total | $4,263.2 | | $3,850.2 | | $12,761.2 | $10,127.0 |
| SEGMENT PROFIT | | | | | | |
First 8 of 19 rows. The CSV has all of them.
| Third Quarter | Year-to-Date | | | | |
| 2021 | 2020 | | 2021 | 2020 | |
| Industrial | 6.4% | | 8.0% | | 5.4% | 10.0% |
| Security | 52.7% | | 49.7% | | 51.4% | 49.1% |
Table 48 after “The following table is a further disaggregation of the Industrial segment revenue for the three and nine months ended October 2, 2021 and Se”
Download CSV
| Third Quarter | Year-to-Date | | | | |
| (Millions of Dollars) | 2021 | 2020 | | 2021 | 2020 | |
| Engineered Fastening | $435.7 | | $436.0 | | $1,389.0 | $1,212.4 |
| Infrastructure | 157.8 | | 150.6 | | 464.4 | 482.4 |
| Industrial | $593.5 | | $586.6 | | $1,853.4 | $1,694.8 |
Table 49 after “The following table is a summary of total assets by segment as of October 2, 2021 and January 2, 2021:”
Download CSV
| (Millions of Dollars) | October 2, 2021 | January 2, 2021 | |
| Tools & Storage | $15,676.0 | | $14,294.9 |
| Industrial | 5,678.3 | | 5,621.4 |
| Security | 3,571.0 | | 3,493.5 |
| 24,925.3 | | 23,409.8 |
| Corporate | (598.7) | | 156.5 |
| Consolidated | $24,326.6 | | $23,566.3 |
Table 50 after “The following table is a summary of net sales by geographic area for the three and nine months ended October 2, 2021 and September 26, 2020:”
Download CSV
| Third Quarter | Year-to-Date | | | | |
| (Millions of Dollars) | 2021 | 2020 | | 2021 | 2020 | |
| United States | $2,530.6 | | $2,336.2 | | $7,381.1 | $6,182.2 |
| Canada | 208.9 | | 185.1 | | 631.7 | 470.8 |
| Other Americas | 227.1 | | 168.6 | | 638.4 | 388.8 |
| France | 159.7 | | 148.9 | | 534.9 | 389.5 |
| Other Europe | 814.8 | | 722.3 | | 2,591.1 | 1,953.5 |
| Asia | 322.1 | | 289.1 | | 984.0 | 742.2 |
First 8 of 9 rows. The CSV has all of them.
Table 51 after “The following is a summary of the Company's total lease cost for the three and nine months ended October 2, 2021 and September 26, 2020:”
Download CSV
| Third Quarter | Year-to-Date | | | | |
| (Millions of Dollars) | 2021 | 2020 | | 2021 | 2020 | |
| Operating lease cost | $39.8 | | $38.8 | | $117.3 | $113.7 |
| Short-term lease cost | 6.4 | | 6.2 | | 17.9 | 19.0 |
| Variable lease cost | 1.1 | | 1.6 | | 4.4 | 5.4 |
| Sublease income | (0.5) | | (0.3) | | (1.5) | (0.7) |
| Total lease cost | $46.8 | | $46.3 | | $138.1 | $137.4 |
Table 52 after “The following is a summary of the Company's future lease obligations on an undiscounted basis at October 2, 2021:”
Download CSV
| (Millions of Dollars) | Total | 2021 | | 2022 | 2023 | 2024 | | 2025 | Thereafter | | |
| Lease obligations | $524.9 | | $36.6 | | $120.2 | | $91.5 | | $74.5 | $53.4 | $148.7 |
Table 53 after “The Company’s financial guarantees at October 2, 2021 are as follows:”
Download CSV
| (Millions of Dollars) | Term | Maximum Potential Payment | Carrying Amount of Liability | |
| Guarantees on the residual values of leased assets | One to four years | $89.6 | | $— |
| Standby letters of credit | Up to three years | 167.6 | | — |
| Commercial customer financing arrangements | Up to six years | 67.4 | | 8.4 |
| Total | | $324.6 | | $8.4 |
Table 54 after “The changes in the carrying amount of product warranties for the nine months ended October 2, 2021 and September 26, 2020 are as follows:”
Download CSV
| (Millions of Dollars) | 2021 | 2020 | |
| Balance beginning of period | $113.8 | | $100.1 |
| Warranties and guarantees issued | 110.3 | | 94.1 |
| Warranty payments and currency | (119.7) | | (84.5) |
| Balance end of period | $104.4 | | $109.7 |
| Third Quarter | Year-to-Date | | | | |
| (Millions of Dollars) | 2021 | 2020 | | 2021 | 2020 | |
| Net sales | $3,185.9 | | $2,804.1 | | $9,445.3 | $7,072.1 |
| Segment profit | $485.8 | | $597.1 | | $1,772.2 | $1,177.0 |
| % of Net sales | 15.2% | | 21.3% | | 18.8% | 16.6% |
| Third Quarter | Year-to-Date | | | | |
| (Millions of Dollars) | 2021 | 2020 | | 2021 | 2020 | |
| Net sales | $593.5 | | $586.6 | | $1,853.4 | $1,694.8 |
| Segment profit | $43.8 | | $63.8 | | $207.4 | $136.7 |
| % of Net sales | 7.4% | | 10.9% | | 11.2% | 8.1% |
| Third Quarter | Year-to-Date | | | | |
| (Millions of Dollars) | 2021 | 2020 | | 2021 | 2020 | |
| Net sales | $483.8 | | $459.5 | | $1,462.5 | $1,360.1 |
| Segment profit | $39.6 | | $39.3 | | $111.1 | $69.4 |
| % of Net sales | 8.2% | | 8.6% | | 7.6% | 5.1% |
Table 58 after “A summary of the restructuring reserve activity from January 2, 2021 to October 2, 2021 is as follows:”
Download CSV
| (Millions of Dollars) | January 2, 2021 | Net Additions | | Usage | Currency | October 2, 2021 | | |
| Severance and related costs | $87.5 | | $5.9 | | $(49.9) | | $2.0 | $45.5 |
| Facility closures and asset impairments | 2.7 | | 16.2 | | (15.3) | | — | 3.6 |
| Total | $90.2 | | $22.1 | | $(65.2) | | $2.0 | $49.1 |
Table 59 after “Free cash flow, as defined in the table below, was an outflow of $124.5 million in the third quarter of 2021 compared to an inflow of $615.1”
Download CSV
| Third Quarter | Year-to-Date | | | | |
| (Millions of Dollars) | 2021 | 2020 | | 2021 | 2020 | |
| Net cash provided by operating activities | $4.6 | | $677.2 | | $291.2 | $600.2 |
| Less: capital and software expenditures | (129.1) | | (62.1) | | (322.5) | (209.5) |
| Free cash flow | $(124.5) | | $615.1 | | $(31.3) | $390.7 |
Table 60 after “The following table provides information about the Company’s purchases of equity securities that are registered by the Company pursuant to S”
Download CSV
| 2021 | Total Number Of Shares Purchased (a) | Average Price Paid Per Share | | Total Number Of Shares Purchased As Part Of A Publicly Announced Plan Or Program | Maximum Number Of Shares That May Yet Be Purchased Under The Program (b) | |
| July 4 - August 7 | 11,538 | | $203.44 | | — | 20,000,000 |
| August 8 - September 4 | 233 | | 197.47 | | — | 20,000,000 |
| September 5 - October 2 | 2,378 | | 181.53 | | — | 20,000,000 |
| Total | 14,149 | | $199.66 | | — | 20,000,000 |
| (10.1) | 364-Day Credit Agreement, made as of September 8, 2021 among Stanley Black & Decker, Inc., the initial lenders named therein and Citibank, N.A. as administrative agent for the lenders (incorporated by reference to Exhibit 10.1 to the Company’s Current Report on Form 8-K filed on September 14, 2021). |
| (10.2) | Amended and Restated Five Year Credit Agreement, made as of September 8, 2021 among Stanley Black & Decker, Inc., the initial lenders named therein and Citibank, N.A. as administrative agent for the lenders (incorporated by reference to Exhibit 10.2 to the Company’s Current Report on Form 8-K filed on September 14, 2021). |
| (11) | Statement re-computation of per share earnings (the information required to be presented in this exhibit appears in Note C to the Company’s Unaudited Condensed Consolidated Financial Statements set forth in this Quarterly Report on Form 10-Q). |
| (31)(i)(a) | Certification by Chief Executive Officer pursuant to Rule 13a-14(a). |
| (i)(b) | Certification by President and Chief Financial Officer pursuant to Rule 13a-14(a). |
| (32)(i) | Certification by Chief Executive Officer pursuant to 18 U.S.C. Section 1350, as adopted pursuant to Section 906 of the Sarbanes-Oxley Act of 2002. |
| (ii) | Certification by President and Chief Financial Officer pursuant to 18 U.S.C. Section 1350, as adopted pursuant to Section 906 of the Sarbanes-Oxley Act of 2002. |
| (101) | The following materials from Stanley Black & Decker Inc.'s Quarterly Report on Form 10-Q for the quarter ended October 2, 2021, formatted in iXBRL (Inline eXtensible Business Reporting Language): (i) Consolidated Statements of Operations and Comprehensive Income for the three and nine months ended October 2, 2021 and September 26, 2020; (ii) Condensed Consolidated Balance Sheets at October 2, 2021 and January 2, 2021; (iii) Condensed Consolidated Statements of Cash Flows for the three and nine months ended October 2, 2021 and September 26, 2020; (iv) Consolidated Statements of Changes in Shareowners' Equity for the three and nine months ended October 2, 2021 and September 26, 2020; and (v) Notes to Unaudited Condensed Consolidated Financial Statements**. |
First 8 of 9 rows. The CSV has all of them.