← Filings of SWK

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

60 tables with numbers, filed Jul 31, 2020. 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	39
ITEM 3. QUANTITATIVE AND QUALITATIVE DISCLOSURES ABOUT MARKET RISK	51
ITEM 4. CONTROLS AND PROCEDURES	51
PART II — OTHER INFORMATION	53
ITEM 1. LEGAL PROCEEDINGS	53
ITEM 1A. RISK FACTORS	53

	Second Quarter			Year-to-Date
	2020	2019		2020	2019
Net Sales	$3,147.4		$3,761.3		$6,276.8	$7,094.9
Costs and Expenses
Cost of sales	$2,134.7		$2,461.5		$4,241.0	$4,689.5
Selling, general and administrative	713.0		776.2		1,450.8	1,536.8
Provision for credit losses	19.0		6.1		29.7	24.4
Other, net	86.9		62.2		161.8	127.6

	June 27, 2020	December 28, 2019
ASSETS
Current Assets
Cash and cash equivalents	$859.8		$297.7
Accounts and notes receivable, net	1,719.4		1,454.6
Inventories, net	2,753.4		2,255.0
Other current assets	436.9		449.3
Total Current Assets	5,769.5		4,456.6

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

(Millions of Dollars)	June 27, 2020	December 28, 2019
Trade accounts receivable	$1,573.9		$1,284.0
Trade notes receivable	133.9		156.7
Other accounts receivable	148.1		126.3
Gross accounts and notes receivable	$1,855.9		$1,567.0
Allowance for credit losses	(136.5)		(112.4)
Accounts and notes receivable, net	$1,719.4		$1,454.6
Long-term receivables, net	$135.0		$146.1

(Millions of Dollars)	Balance March 28, 2020	Cumulative Effect Adjustment (a)		Charged To Costs and Expenses	Charged To Other Accounts (b)	Deductions (c)		Balance June 27, 2020
Accounts receivable	$108.1		$—		$19.0		$—		$(4.2)	$122.9
Notes receivable	$13.6		$—		$—		$0.1		$(0.1)	$13.6
Total	$121.7		$—		$19.0		$0.1		$(4.3)	$136.5

(Millions of Dollars)	Total	Within 1 Year		2 Years	3 Years	4 Years		5 Years	Thereafter
Financing receivables	$198.8		$75.8		$55.1		$36.1		$19.4	$8.6	$3.8
Operating leases	$50.3		$48.2		$1.3		$0.5		$0.2	$0.1	$—

(Millions of Dollars)
Cash and cash equivalents	$35.9
Accounts receivable, net	48.6
Inventories, net	127.6
Prepaid expenses and other assets	2.7
Property, plant and equipment	132.6
Trade names	25.0
Customer relationships	565.0

(Millions of Dollars)	Second Quarter 2020	Year-to-Date 2020
Net sales	$65.3		$98.4
Net loss attributable to common shareowners	$(30.6)		$(51.4)

	Second Quarter			Year-to-Date
(Millions of Dollars, except per share amounts)	2020	2019		2020	2019
Net sales	$3,147.4		$3,854.5		$6,322.8	$7,357.4
Net earnings attributable to common shareowners	$251.3		$350.3		$399.2	$504.9
Diluted earnings per share	$1.63		$2.33		$2.60	$3.36

	Second Quarter			Year-to-Date
	2020	2019		2020	2019
OPERATING ACTIVITIES
Net earnings	$238.7		$357.4		$371.8	$527.8
Adjustments to reconcile net earnings to cash provided by (used in) operating activities:
Depreciation and amortization of property, plant and equipment	94.2		93.7		187.0	187.7
Amortization of intangibles	50.5		48.0		98.8	91.8
Gain on sale of business	—		(17.2)		—	(17.2)

	Second Quarter			Year-to-Date
	2020	2019		2020	2019
Numerator (in millions):
Net Earnings Attributable to Common Shareowners	$233.7		$356.3		$366.9	$526.2
Denominator (in thousands):
Basic weighted-average shares outstanding	153,330		148,099		152,011	147,982
Dilutive effect of stock contracts and awards	824		2,259		1,279	2,157
Diluted weighted-average shares outstanding	154,154		150,358		153,290	150,139

	Second Quarter			Year-to-Date
(Millions of Dollars)	2020	2019		2020	2019
Sales-type lease revenue	$30.8		$19.6		$53.8	$41.5
Lease interest revenue	3.0		3.3		6.1	6.5
Operating lease revenue	35.2		37.2		71.5	73.9
Total lease revenue	$69.0		$60.1		$131.4	$121.9
Sales-type lease profit	$12.3		$7.8		$21.4	$16.5

(Millions of Dollars)	June 27, 2020	December 28, 2019
Finished products	$1,889.7		$1,526.0
Work in process	227.9		162.0
Raw materials	635.8		567.0
Total	$2,753.4		$2,255.0

(Millions of Dollars)	Tools & Storage	Industrial		Security	Total
Balance December 28, 2019	$5,161.8		$1,995.5		$2,080.2	$9,237.5
Acquisitions	—		624.0		0.1	624.1
Foreign currency translation	(44.7)		3.1		(14.8)	(56.4)
Balance June 27, 2020	$5,117.1		$2,622.6		$2,065.5	$9,805.2

(Millions of Dollars)	Balance Sheet Classification	June 27, 2020	December 28, 2019		Balance Sheet Classification	June 27, 2020	December 28, 2019
Derivatives designated as hedging instruments:
Interest Rate Contracts Cash Flow	LT other assets	$—		$—		LT other liabilities	$114.0	$40.5
Foreign Exchange Contracts Cash Flow	Other current assets	5.8		7.0		Accrued expenses	0.5	7.8
Net Investment Hedge	Other current assets	8.7		18.6		Accrued expenses	2.9	8.5
	LT other assets	—		—		LT other liabilities	1.5	2.6
Non-derivative designated as hedging instrument:
Net Investment Hedge		—		—		Short-term borrowings	299.7	335.5

	Second 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	$4.9		Interest expense		$(4.7)		$—
Foreign Exchange Contracts	$(4.9)		Cost of sales		$4.3		$—

	Second Quarter 2019
(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	$(17.5)		Interest expense		$(4.1)		$—
Foreign Exchange Contracts	$(2.5)		Cost of sales		$2.7		$—

	Year-to-Date 2019
(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	$(28.4)		Interest expense		$(8.1)		$—
Foreign Exchange Contracts	$4.5		Cost of sales		$2.5		$—

(Millions of Dollars)	Second 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	$57.3		$117.0
Amortization of gain on terminated swaps	$(0.8)		$(1.6)

(Millions of Dollars)	Second Quarter 2019 Interest Expense	Year-to-Date 2019 Interest Expense
Total amount in the Consolidated Statements of Operations and Comprehensive Income in which the effects of the fair value hedges are recorded	$72.4		$146.8
Amortization of gain on terminated swaps	$(0.7)		$(6.1)

	June 27, 2020
(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
Current Maturities of Long-Term Debt	$3.1		Terminated Swaps	$3.1
Long-Term Debt	$4,658.7		Terminated Swaps	$(19.0)

	Second 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.2		$—		Other, net	$—	$—
Cross Currency Swap	$(0.7)		$16.1		Other, net	$4.2	$4.2
Option Contracts	$—		$—		Other, net	$—	$—
Non-derivative designated as Net Investment Hedge	$(11.0)		$—		Other, net	$—	$—

(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	(143.4)		(58.8)		34.3		9.7	(158.2)
Reclassification adjustments to earnings	—		1.7		(7.3)		7.8	2.2
Net other comprehensive (loss) income	(143.4)		(57.1)		27.0		17.5	(156.0)
Balance - June 27, 2020	$(1,660.6)		$(111.3)		$124.3		$(393.0)	$(2,040.6)

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 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 June 27, 2020 and December 28”

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

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

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

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

Table 10 after “ACCOUNTS AND NOTES RECEIVABLE, NET”

Table 11 after “The changes in the allowance for credit losses for the three and six months ended June 27, 2020 are as follows:”

Table 12 after “The changes in the allowance for credit losses for the three and six months ended June 27, 2020 are as follows:”

Table 13 after “The following is a summary of the expected timing of receipt of payments from customers on an undiscounted basis as of June 27, 2020 relatin”

Table 14 after “The following is a summary of lease revenue and sales-type lease profit for the three and six months ended June 27, 2020 and June 29, 2019:”

Table 15 after “The components of Inventories, net at June 27, 2020 and December 28, 2019 are as follows:”

Table 16 after “The following table summarizes the estimated acquisition date value of identifiable net assets acquired and liabilities assumed:”

Table 17 after “The net sales and net loss from the 2020 acquisition included in the Company's Consolidated Statements of Operations and Comprehensive Incom”

Table 18 after “The following table presents supplemental pro-forma information as if the 2020 acquisition had occurred on December 30, 2018 and the 2019 ac”

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

Table 20 after “Long-term debt and financing arrangements at June 27, 2020 and December 28, 2019 are as follows:”

Table 21 after “Table of Contents”

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

Table 23 after “Table of Contents”

Table 24 after “Table of Contents”

Table 25 after “Table of Contents”

Table 26 after “A summary of the pre-tax effect of cash flow hedge accounting on the Consolidated Statements of Operations and Comprehensive Income for the ”

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 ”

Table 28 after “A summary of the pre-tax effect of fair value hedge accounting on the Consolidated Statements of Operations and Comprehensive Income for the”

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”

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

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

Table 32 after “The pre-tax gain or loss from fair value changes for the three and six months ended June 27, 2020 and June 29, 2019 was as follows:”

Table 33 after “The pre-tax gain or loss from fair value changes for the three and six months ended June 27, 2020 and June 29, 2019 was as follows:”

Table 34 after “The pre-tax gain or loss from fair value changes for the three and six months ended June 27, 2020 and June 29, 2019 was as follows:”

Table 35 after “Table of Contents”

Table 36 after “The gain (loss) recorded in income from changes in the fair value related to derivatives not designated as hedging instruments under ASC 815”

Table 37 after “Table of Contents”

Table 38 after “Table of Contents”

Table 39 after “The reclassifications out of accumulated other comprehensive loss for the six months ended June 27, 2020 and June 29, 2019 were as follows:”

Table 40 after “Table of Contents”

Table 41 after “Table of Contents”

Table 42 after “Table of Contents”

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

Table 44 after “A summary of the restructuring reserve activity from December 28, 2019 to June 27, 2020 is as follows:”

Table 45 after “material. Segment assets primarily include cash, accounts receivable, inventory, other current assets, property, plant and equipment, right-”

Table 46 after “The following table provides the percent of total segment revenue recognized over time for the Industrial and Security segments for the thre”

Table 47 after “The following table is a further disaggregation of the Industrial segment revenue for the three and six months ended June 27, 2020 and June ”

Table 48 after “The following table is a summary of total assets by segment as of June 27, 2020 and December 28, 2019:”

Table 49 after “The following table is a summary of net sales by geographic area for the three and six months ended June 27, 2020 and June 29, 2019:”

Table 50 after “The following is a summary of the Company's total lease cost for the three and six months ended June 27, 2020 and June 29, 2019:”

Table 51 after “The following is a summary of the Company's future lease obligations on an undiscounted basis at June 27, 2020:”

Table 52 after “The Company’s financial guarantees at June 27, 2020 are as follows:”

Table 53 after “The changes in the carrying amount of product warranties for the six months ended June 27, 2020 and June 29, 2019 are as follows:”

Table 54 after “Tools & Storage:”

Table 55 after “Industrial:”

Table 56 after “Security:”

Table 57 after “A summary of the restructuring reserve activity from December 28, 2019 to June 27, 2020 is as follows:”

Table 58 after “Free cash flow, as defined in the table below, was $263.7 million in the second quarter of 2020 and $403.8 million in the second quarter of ”

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

Table 60 after “ITEM 6. EXHIBITS”

	Second Quarter
	Pension Benefits					Other Benefits
	U.S. Plans			Non-U.S. Plans		All Plans
(Millions of Dollars)	2020	2019		2020	2019	2020		2019
Service cost	$1.7		$3.2		$3.9		$3.7		$0.2	$—
Interest cost	8.9		11.7		5.4		7.6		0.4	0.4
Expected return on plan assets	(14.7)		(15.5)		(9.9)		(11.4)		—	—
Amortization of prior service cost (credit)	0.2		0.3		(0.2)		(0.2)		(0.4)	(0.4)

(Millions of Dollars)	Total Carrying Value	Level 1		Level 2	Level 3
June 27, 2020
Money market fund	$2.5		$2.5		$—	$—
Derivative assets	$21.0		$—		$21.0	$—
Derivative liabilities	$126.8		$—		$126.8	$—
Non-derivative hedging instrument	$299.7		$—		$299.7	$—
Contingent consideration liabilities	$331.3		$—		$—	$331.3
December 28, 2019

(Millions of Dollars)	December 28, 2019	Net Additions		Usage	Currency	June 27, 2020
Severance and related costs	$140.3		$28.9		$(55.3)		$0.5	$114.4
Facility closures and asset impairments	7.5		2.9		(8.3)		—	2.1
Total	$147.8		$31.8		$(63.6)		$0.5	$116.5

(Millions of Dollars)	Term	Maximum Potential Payment	Carrying Amount of Liability
Guarantees on the residual values of leased assets	One to four years	$101.9		$—
Standby letters of credit	Up to three years	162.3		—
Commercial customer financing arrangements	Up to six years	64.7		6.9
Total		$328.9		$6.9

2020	(a) Total Number Of Shares Purchased	Average Price Paid Per Share		Total Number Of Shares Purchased As Part Of A Publicly Announced Plan Or Program	(b) Maximum Number Of Shares That May Yet Be Purchased Under The Program
March 29 - May 2	1,564		$106.24		—	11,450,000
May 3 - May 30	314		110.53		—	11,450,000
May 31 - June 27	615		117.81		—	11,450,000
Total	2,493		$109.64		—	11,450,000

(3.2)	Certificate of Amendment to the Restated Certificate of Incorporation, dated May 15, 2020 (incorporated by reference to Exhibit 3.2 to the Company’s Current Report on Form 8-K filed on May 15, 2020).
(10.1)	Amendment No. 1, dated as of April 23, 2020, to the Amended and Restated Credit Agreement, among the Company, the 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 April 29, 2020).
(10.2)	Amendment No. 1, dated as of April 23, 2020, to the Amended and Restated Five Year Credit Agreement, among the Company, the 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 April 29, 2020).
(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 President and Chief Executive Officer pursuant to Rule 13a-14(a).
(i)(b)	Certification by Executive Vice President and Chief Financial Officer pursuant to Rule 13a-14(a).
(32)(i)	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.
(ii)	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.