← Filings of SWK

Tables in the 10-Q of STANLEY BLACK & DECKER, INC.

58 tables with numbers, filed Aug 1, 2023. 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	31
ITEM 3. QUANTITATIVE AND QUALITATIVE DISCLOSURES ABOUT MARKET RISK	43
ITEM 4. CONTROLS AND PROCEDURES	43
PART II — OTHER INFORMATION	46
ITEM 1. LEGAL PROCEEDINGS	46
ITEM 1A. RISK FACTORS	46

	Second Quarter	Year-to-Date
	2023	2022		2023	2022
Net Sales	$4,158.9		$4,393.0		$8,090.7	$8,841.0
Costs and Expenses
Cost of sales	$3,226.8		$3,185.9		$6,323.1	$6,328.5
Selling, general and administrative	834.4		849.4		1,657.4	1,798.6
Provision for credit losses	2.9		3.3		5.0	14.4
Other, net	66.6		79.1		130.3	141.1

	July 1, 2023	December 31, 2022
ASSETS
Current Assets
Cash and cash equivalents	$391.4		$395.6
Accounts and notes receivable, net	1,706.7		1,231.0
Inventories, net	5,282.9		5,861.1
Prepaid expenses	433.1		441.4
Other current assets	25.6		45.6

	Preferred Stock	Common Stock		Additional Paid In Capital	Retained Earnings	Accumulated Other Comprehensive Loss		Treasury Stock	Non- Controlling Interests	Shareowners’ Equity
Balance December 31, 2022	$—		$442.3		$5,055.6		$9,333.3		$(2,119.5)		$(2,999.6)	$2.1	$9,714.2
Net loss	—		—		—		(187.8)		—		—	—	(187.8)
Other comprehensive income	—		—		—		—		52.8		—	—	52.8
Cash dividends declared — $0.80 per common share	—		—		—		(119.8)		—		—	—	(119.8)
Issuance of common stock (202,552 shares)	—		—		(21.5)		—		—		24.6	—	3.1
Repurchase of common stock (58,377 shares)	—		—		—		—		—		(4.8)	—	(4.8)
Stock-based compensation related	—		—		34.7		—		—		—	—	34.7

(Millions of Dollars)	July 1, 2023	December 31, 2022
Trade accounts receivable	$1,603.8		$1,142.0
Trade notes receivable	85.4		100.1
Other accounts receivable	105.5		95.5
Gross accounts and notes receivable	$1,794.7		$1,337.6
Allowance for credit losses	(88.0)		(106.6)
Accounts and notes receivable, net	$1,706.7		$1,231.0

(Millions of Dollars)	Tools & Outdoor	Industrial		Total
Balance December 31, 2022	$5,939.7		$2,563.0		$8,502.7
Foreign currency translation & other	12.7		(5.6)		7.1
Balance July 1, 2023	$5,952.4		$2,557.4		$8,509.8

(Millions of Dollars)	Balance Sheet Classification	July 1, 2023	December 31, 2022		Balance Sheet Classification	July 1, 2023	December 31, 2022
Derivatives designated as hedging instruments:
Foreign Exchange Contracts Cash Flow	Other current assets	$3.1		$4.5		Accrued expenses	$5.6	$4.2
	LT other assets	0.3		—		LT other liabilities	0.1	—
Non-derivative designated as hedging instrument:
Net Investment Hedge		$—		$—		Short-term borrowings	$736.9	$—
Total designated as hedging instruments		$3.4		$4.5			$742.6	$4.2
Derivatives not designated as hedging instruments:

	Second Quarter 2023
(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	$—		Interest expense		$(1.6)		$—
Foreign Exchange Contracts	$(1.9)		Cost of sales		$(1.0)		$—

	Year-to-Date 2023
(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	$—		Interest expense		$(3.1)		$—
Foreign Exchange Contracts	$(4.5)		Cost of sales		$(0.4)		$—

	Second Quarter 2022
(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	$—		Interest expense		$(1.5)		$—
Foreign Exchange Contracts	$16.9		Cost of sales		$7.2		—

	Second Quarter	Year-to-Date
	2023	2022		2023	2022
OPERATING ACTIVITIES
Net earnings (loss) from continuing operations	$177.5		$78.7		$(10.3)	$234.3
Net (loss) earnings from discontinued operations	(0.5)		9.0		(0.5)	28.8
Adjustments to reconcile net earnings (loss) to cash provided by (used in) operating activities:
Depreciation and amortization of property, plant and equipment	116.1		91.9		229.0	183.9
Amortization of intangibles	48.3		51.5		96.6	103.2

	Second Quarter	Year-to-Date
	2023	2022		2023	2022
Numerator (in millions):
Net Earnings (Loss) from Continuing Operations Attributable to Common Shareowners	$177.5		$78.6		$(10.3)	$234.1
Add: Contract adjustment payments accretion	—		0.4		—	0.7
Net Earnings (Loss) from Continuing Operations Attributable to Common Shareowners - Diluted	$177.5		$79.0		$(10.3)	$234.8
Net (loss) earnings from discontinued operations	(0.5)		9.0		(0.5)	28.8
Net Earnings (Loss) Attributable to Common Shareowners - Diluted	$177.0		$88.0		$(10.8)	$263.6

	Second Quarter	Year-to-Date
	2023	2022		2023	2022
Denominator (in thousands):
Basic weighted-average shares outstanding	149,687		145,353		149,631	150,385
Dilutive effect of stock contracts and awards	540		9,461		—	9,742
Diluted weighted-average shares outstanding	150,227		154,814		149,631	160,127

	Second Quarter	Year-to-Date
	2023	2022		2023	2022
Earnings (loss) per share of common stock:
Basic earnings (loss) per share of common stock:
Continuing operations	$1.19		$0.54		$(0.07)	$1.56
Discontinued operations	$—		$0.06		$—	$0.19
Total basic earnings (loss) per share of common stock	$1.18		$0.60		$(0.07)	$1.75
Diluted earnings (loss) per share of common stock:

	Year-to-Date 2022
(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	$23.4		Interest expense		$(2.7)		$—
Foreign Exchange Contracts	$23.4		Cost of sales		$13.3		$—

(Millions of Dollars)	Second Quarter 2023 Interest Expense	Year-to-Date 2023 Interest Expense
Total amount in the Consolidated Statements of Operations and Comprehensive Income (Loss) in which the effects of the fair value hedges are recorded	$144.6		$275.5
Amortization of gain on terminated swaps	$(0.1)		$(0.2)

(Millions of Dollars)	Second Quarter 2022 Interest Expense	Year-to-Date 2022 Interest Expense
Total amount in the Consolidated Statements of Operations and Comprehensive Income (Loss) in which the effects of the fair value hedges are recorded	$78.2		$132.9
Amortization of gain on terminated swaps	$(0.1)		$(0.2)

	July 1, 2023
(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	$532.8		Terminated Swaps	$(19.9)

	Year-to-Date 2023
(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.2		$—		Other, net	$—	$—
Cross Currency Swap	$(0.1)		$—		Other, net	$—	$—
Non-derivative designated as Net Investment Hedge	$(9.8)		$—		Other, net	$—	$—

(Millions of Dollars)	Currency translation adjustment and other	(Losses) gains on cash flow hedges, net of tax		Gains (losses) on net investment hedges, net of tax	Pension (losses) gains, net of tax	Total
Balance - December 31, 2022	$(1,907.4)		$(44.5)		$73.8		$(241.4)	$(2,119.5)
Other comprehensive income (loss) before reclassifications	32.8		(2.7)		(7.3)		(5.4)	17.4
Reclassification adjustments to earnings	—		1.9		—		4.4	6.3
Net other comprehensive income (loss)	32.8		(0.8)		(7.3)		(1.0)	23.7
Balance - July 1, 2023	$(1,874.6)		$(45.3)		$66.5		$(242.4)	$(2,095.8)

	Second Quarter
	Pension Benefits	Other Benefits
	U.S. Plans	Non-U.S. Plans		All Plans
(Millions of Dollars)	2023	2022		2023	2022	2023		2022
Service cost	$2.1		$1.2		$2.8		$3.6		$—	$—
Interest cost	13.9		8.7		11.0		5.7		0.5	0.6
Expected return on plan assets	(15.6)		(15.1)		(10.5)		(9.5)		—	—
Amortization of prior service cost (credit)	0.2		0.2		(0.1)		(0.2)		—	—

(Millions of Dollars)	Total Carrying Value	Level 1		Level 2	Level 3
July 1, 2023
Money market fund	$11.2		$11.2		$—	$—
Deferred compensation plan investments	$19.1		$19.1		$—	$—
Derivative assets	$6.4		$—		$6.4	$—
Derivative liabilities	$19.4		$—		$19.4	$—
Non-derivative hedging instrument	$736.9		$—		$736.9	$—
Contingent consideration liability	$260.9		$—		$—	$260.9

(Millions of Dollars)	December 31, 2022	Net Additions		Usage	Currency	July 1, 2023
Severance and related costs	$57.0		$7.0		$(39.0)		$(0.3)	$24.7
Facility closures and asset impairments	5.3		9.7		(12.0)		—	3.0
Total	$62.3		$16.7		$(51.0)		$(0.3)	$27.7

(Millions of Dollars)	Term	Maximum Potential Payment	Carrying Amount of Liability
Guarantees on the residual values of leased assets	One to nine years	$156.6		$—
Standby letters of credit	Up to three years	175.3		—
Commercial customer financing arrangements	Up to six years	82.1		13.0
Total		$414.0		$13.0

Tables in the 10-Q of STANLEY BLACK & DECKER, INC.

Table 1 after “TABLE OF CONTENTS”

Table 2 after “(Unaudited, Millions of Dollars, Except Per Share Amounts)”

Table 3 after “(Unaudited, Millions of Dollars, Except Share and Per Share Amounts)”

Table 4 after “(Unaudited, Millions of Dollars)”

Table 5 after “The following table provides a reconciliation of the cash, cash equivalents and restricted cash balances as of July 1, 2023 and December 31,”

Table 6 after “(Unaudited, Millions of Dollars, Except Share and Per Share Amounts)”

Table 7 after “(Unaudited, Millions of Dollars, Except Share and Per Share Amounts)”

Table 8 after “The following table reconciles net earnings (loss) attributable to common shareowners and the weighted-average shares outstanding used to ca”

Table 9 after “The following table reconciles net earnings (loss) attributable to common shareowners and the weighted-average shares outstanding used to ca”

Table 10 after “The following table reconciles net earnings (loss) attributable to common shareowners and the weighted-average shares outstanding used to ca”

Table 11 after “The following weighted-average stock options were not included in the computation of weighted-average diluted shares outstanding because the”

Table 12 after “ACCOUNTS AND NOTES RECEIVABLE, NET”

Table 13 after “The changes in the allowance for credit losses for the three and six months ended July 1, 2023 and July 2, 2022 are as follows:”

Table 14 after “INVENTORIES, NET”

Table 15 after “Changes in the carrying amount of goodwill by segment are as follows:”

Table 16 after “LONG-TERM DEBT AND FINANCING ARRANGEMENTS”

Table 17 after “Table of Contents”

Table 18 after “The tables below detail pre-tax amounts of derivatives designated as cash flow hedges in Accumulated other comprehensive loss during the per”

Table 19 after “The tables below detail pre-tax amounts of derivatives designated as cash flow hedges in Accumulated other comprehensive loss during the per”

Table 20 after “Table of Contents”

Table 21 after “Table of Contents”

Table 22 after “A summary of the pre-tax effect of cash flow hedge accounting on the Consolidated Statements of Operations and Comprehensive Income (Loss) f”

Table 23 after “A summary of the pre-tax effect of cash flow hedge accounting on the Consolidated Statements of Operations and Comprehensive Income (Loss) f”

Table 24 after “A summary of the pre-tax effect of fair value hedge accounting on the Consolidated Statements of Operations and Comprehensive Income (Loss) ”

Table 25 after “A summary of the pre-tax effect of fair value hedge accounting on the Consolidated Statements of Operations and Comprehensive Income (Loss) ”

Table 26 after “A summary of the amounts recorded in the Condensed Consolidated Balance Sheets related to cumulative basis adjustments for fair value hedges”

Table 27 after “A summary of the amounts recorded in the Condensed Consolidated Balance Sheets related to cumulative basis adjustments for fair value hedges”

Table 28 after “The pre-tax gain or loss from fair value changes for the three and six months ended July 1, 2023 and July 2, 2022 is as follows:”

Table 29 after “The pre-tax gain or loss from fair value changes for the three and six months ended July 1, 2023 and July 2, 2022 is as follows:”

Table 30 after “The pre-tax gain or loss from fair value changes for the three and six months ended July 1, 2023 and July 2, 2022 is as follows:”

Table 31 after “Table of Contents”

Table 32 after “Table of Contents”

Table 33 after “Table of Contents”

Table 34 after “The reclassifications out of Accumulated other comprehensive loss for the six months ended July 1, 2023 and July 2, 2022 were as follows:”

Table 35 after “Following are the components of net periodic pension expense (benefit) for the three and six months ended July 1, 2023 and July 2, 2022:”

Table 36 after “Following are the components of net periodic pension expense (benefit) for the three and six months ended July 1, 2023 and July 2, 2022:”

Table 37 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”

Table 38 after “The following table provides information about the Company's financial assets and liabilities not carried at fair value:”

Table 39 after “A summary of the restructuring reserve activity from December 31, 2022 to July 1, 2023 is as follows:”

Table 40 after “Table of Contents”

Table 41 after “The following table is a further disaggregation of the Industrial segment revenue for the three and six months ended July 1, 2023 and July 2”

Table 42 after “The following table is a summary of total assets by segment as of July 1, 2023 and December 31, 2022:”

Table 43 after “The following table is a summary of net sales by geographic area for the three and six months ended July 1, 2023 and July 2, 2022:”

Table 44 after “The following is a summary of the Company's right-of-use assets and lease liabilities:”

Table 45 after “The Company’s financial guarantees at July 1, 2023 are as follows:”

Table 46 after “The changes in the carrying amount of product warranties for the six months ended July 1, 2023 and July 2, 2022 are as follows:”

Table 47 after “Table of Contents”

Table 48 after “The following table presents the significant non-cash items and capital expenditures for the discontinued operations with respect to CSS and”

Table 49 after “Second Quarter 2023”

Table 50 after “Year-To-Date 2023”

Table 51 after “Second Quarter 2022”

Table 52 after “Year-To-Date 2022”

Table 53 after “Tools & Outdoor:”

Table 54 after “Industrial:”

Table 55 after “A summary of the restructuring reserve activity from December 31, 2022 to July 1, 2023 is as follows:”

Table 56 after “Free cash flow, as defined in the table below, was an inflow of $196.1 million in the second quarter of 2023 compared to an outflow of $589.”

Table 57 after “The following table provides information about the Company’s purchases of equity securities that are registered by the Company pursuant to S”

Table 58 after “ITEM 6. EXHIBITS”

(Millions of Dollars)	GAAP	Acquisition-Related Charges & Other		Non-GAAP
Gross profit	$932.1		$51.4		$983.5
Selling, general and administrative1	837.3		(25.4)		811.9
Operating profit	94.8		76.8		171.6
Loss from continuing operations before income taxes	(75.8)		71.1		(4.7)
Income taxes on continuing operations	(253.3)		265.5		12.2
Net Earnings (Loss) from Continuing Operations Attributable to Common Shareowners - Diluted	$177.5		(194.4)		(16.9)
Diluted earnings (loss) per share of common stock - Continuing operations	$1.18		$(1.29)		$(0.11)

2023	Total Number Of Common Shares Purchased (a)	Average Price Paid Per Common Share		Total Number Of Common Shares Purchased As Part Of A Publicly Announced Plan Or Program	(In Millions)Maximum NumberOf Common Shares ThatMay Yet BePurchased UnderThe Program(b)
April 2 - May 6	6,208		$79.83		—	20
May 7 - June 3	3,730		82.75		—	20
June 4 - July 1	57		86.28		—	20
Total	9,995		$80.96		—	20

(10.1)	Employment Offer Letter, dated May 2, 2023, between Stanley Black & Decker, Inc. and Christopher J. Nelson (filed herewith).*
(31.1)	Certification by President and Chief Executive Officer pursuant to Rule 13a-14(a).
(31.2)	Certification by Executive Vice President and Chief Financial Officer pursuant to Rule 13a-14(a).
(32.1)	Certification by President and Chief Executive Officer pursuant to 18 U.S.C. Section 1350, as adopted pursuant to Section 906 of the Sarbanes-Oxley Act of 2002.
(32.2)	Certification by Executive Vice 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 July 1, 2023, formatted in iXBRL (Inline eXtensible Business Reporting Language): (i) Consolidated Statements of Operations and Comprehensive Income (Loss) for the three and six months ended July 1, 2023 and July 2, 2022; (ii) Condensed Consolidated Balance Sheets at July 1, 2023 and December 31, 2022; (iii) Condensed Consolidated Statements of Cash Flows for the three and six months ended July 1, 2023 and July 2, 2022; (iv) Consolidated Statements of Changes in Shareowners' Equity for the three and six months ended July 1, 2023 and July 2, 2022; and (v) Notes to Unaudited Condensed Consolidated Financial Statements**.
(104)	The cover page of Stanley Black & Decker Inc.'s Quarterly Report on Form 10-Q for the quarter ended July 1, 2023, formatted in iXBRL (included within Exhibit 101 attachments).