tickdelta
Sign in
Tables

Tables in the 10-Q of MASCO CORP /DE/

33 tables with numbers, filed Oct 28, 2020. Each one downloads as an Excel file or a CSV (numbers are stored as numbers), 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 ↗

← Filings of MAS

Table 1 after “INDEX”

Page No.
PART I.FINANCIAL INFORMATION
Item 1.Financial Statements (Unaudited):
Condensed Consolidated Balance Sheets — as at September 30, 2020 and December 31, 20191
Condensed Consolidated Statements of Operations for the Three and Nine Months Ended September 30, 2020 and 20192
Condensed Consolidated Statements of Comprehensive Income (Loss) for the Three and Nine Months Ended September 30, 2020 and 20193
Condensed Consolidated Statements of Cash Flows for the Nine Months Ended September 30, 2020 and 20194
Consolidated Statements of Shareholders’ Equity for the Three and Nine Months Ended September 30, 2020 and 20195

First 8 of 16 rows. The download has all of them.

Table 2 after “(In Millions, Except Share Data)”

September 30, 2020December 31, 2019
ASSETS
Current Assets:
Cash and cash investments$1,326$697
Receivables1,262997
Prepaid expenses and other8890
Assets held for sale—173
Inventories:

First 8 of 44 rows. The download has all of them.

Table 3 after “(In Millions, Except Per Common Share Data)”

Three Months Ended September 30,Nine Months Ended September 30,
2020201920202019
Net sales$1,983$1,716$5,328$5,068
Cost of sales1,2311,1053,4013,262
Gross profit7526111,9271,806
Selling, general and administrative expenses328322939964
Impairment charge for other intangible assets———9
Operating profit424289988833

First 8 of 32 rows. The download has all of them.

Table 4 after “(In Millions)”

Three Months Ended September 30,Nine Months Ended September 30,
2020201920202019
Net income$293$138$1,065$517
Less: Net income attributable to noncontrolling interest18123635
Net income attributable to Masco Corporation$275$126$1,029$482
Other comprehensive income (loss), net of tax (Note L):
Cumulative translation adjustment$32$(13)$15$(11)
Interest rate swaps——11

First 8 of 15 rows. The download has all of them.

Table 5 after “(In Millions)”

Nine Months Ended September 30,
20202019
CASH FLOWS FROM (FOR) OPERATING ACTIVITIES:
Cash provided by operations$590$754
Increase in receivables(294)(136)
Increase in inventories(66)(27)
Increase in accounts payable and accrued liabilities, net34314
Net cash from operating activities573605

First 8 of 34 rows. The download has all of them.

Table 6 after “(In Millions, Except Per Common Share Data)”

TotalCommonShares($1 par value)Paid-In CapitalRetained (Deficit) EarningsAccumulated Other Comprehensive (Loss) IncomeNoncontrolling Interest
Balance, January 1, 2019$69$294$—$(278)$(127)$180
Total comprehensive income12811648
Shares issued514
Shares retired:
Repurchased(122)(3)(11)(108)
Surrendered (non-cash)(10)(1)(9)
Cash dividends declared(35)(35)

First 8 of 25 rows. The download has all of them.

Table 7 after “(In Millions, Except Per Common Share Data)”

TotalCommonShares($1 par value)Paid-In CapitalRetained (Deficit) EarningsAccumulated Other Comprehensive (Loss) IncomeNoncontrolling Interest
Balance, January 1, 2020$(56)$276$—$(332)$(179)$179
Cumulative effect of adoption of new credit loss standard (refer to Note A)(1)(1)
Adjusted balance, January 1, 2020$(57)$276$—$(333)$(179)$179
Total comprehensive income (loss)514530(20)4
Shares issued11110
Shares retired:
Repurchased(602)(14)(28)(560)

First 8 of 24 rows. The download has all of them.

Table 8 after “The major classes of line items constituting income from discontinued operations, net, in millions:”

Three Months Ended September 30,Nine Months Ended September 30,
2020201920202019
Net sales$—$403$101$1,234
Cost of sales—31478959
Gross profit—8923275
Selling, general and administrative expenses—5631176
Impairment charge for goodwill (A)———7
Other income (expense), net—1—1

First 8 of 13 rows. The download has all of them.

Table 9 after “The carrying amount of major classes of assets and liabilities included as part of the Cabinetry discontinued operations, were as follows, i”

December 31, 2019
Receivables$76
Prepaid expenses and other7
Inventories90
Property and equipment, net157
Operating lease right-of-use assets4
Goodwill181
Other intangible assets, net1

First 8 of 15 rows. The download has all of them.

Table 10 after “Other selected financial information for Cabinetry, Milgard and UKWG during the period owned by us, were as follows, in millions:”

Nine Months Ended September 30,
20202019
Depreciation and amortization$—$27
Capital expenditures127
ROU assets obtained in exchange for new lease obligations—3

Table 11 after “Our revenues are derived primarily from sales to customers in North America and Internationally, principally Europe. Net sales from these ge”

Three Months Ended September 30, 2020
Plumbing ProductsDecorative Architectural ProductsTotal
Primary geographic markets:
North America$757$842$1,599
International, principally Europe384—384
Total$1,141$842$1,983

Table 12 after “Our revenues are derived primarily from sales to customers in North America and Internationally, principally Europe. Net sales from these ge”

Nine Months Ended September 30, 2020
Plumbing ProductsDecorative Architectural ProductsTotal
Primary geographic markets:
North America$1,973$2,364$4,337
International, principally Europe991—991
Total$2,964$2,364$5,328

Table 13 after “Our revenues are derived primarily from sales to customers in North America and Internationally, principally Europe. Net sales from these ge”

Three Months Ended September 30, 2019
Plumbing ProductsDecorative Architectural ProductsTotal
Primary geographic markets:
North America$664$710$1,374
International, principally Europe342—342
Total$1,006$710$1,716

Table 14 after “D. REVENUE (Concluded)”

Nine Months Ended September 30, 2019
Plumbing ProductsDecorative Architectural ProductsTotal
Primary geographic markets:
North America$1,923$2,110$4,033
International, principally Europe1,035—1,035
Total$2,958$2,110$5,068

Table 15 after “Changes in the allowance for credit losses deducted from accounts receivable were as follows, in millions:”

Nine Months Ended September 30, 2020
Balance at January 1 (after adopting ASU 2016-13)$5
Provision for expected credit losses during the period2
Write-offs charged against the allowance(1)
Recoveries of amounts previously written off1
Balance at end of period$7

Table 16 after “The changes in the carrying amount of goodwill for the nine-month period ended September 30, 2020, by segment, were as follows, in millions:”

Gross Goodwill At September 30, 2020Accumulated Impairment LossesNet Goodwill At September 30, 2020
Plumbing Products$585$(340)$245
Decorative Architectural Products358(75)283
Total$943$(415)$528

Table 17 after “The changes in the carrying amount of goodwill for the nine-month period ended September 30, 2020, by segment, were as follows, in millions:”

Gross Goodwill At December 31, 2019Accumulated Impairment LossesNet Goodwill At December 31, 2019AcquisitionsOther (A)Net Goodwill At September 30, 2020
Plumbing Products$566$(340)$226$14$5$245
Decorative Architectural Products358(75)283——283
Total$924$(415)$509$14$5$528

Table 18 after “Changes in our warranty liability were as follows, in millions:”

Nine Months Ended September 30, 2020Twelve Months Ended December 31, 2019
Balance at January 1$84$81
Accruals for warranties issued during the period2534
Accruals related to pre-existing warranties11
Settlements made (in cash or kind) during the period(24)(31)
Other, net (including currency translation)(1)(1)
Balance at end of period$85$84

Table 19 after “Pre-tax compensation expense included in income from continuing operations for these stock-based incentives was as follows, in millions:”

Three Months Ended September 30,Nine Months Ended September 30,
2020201920202019
Long-term stock awards$4$6$11$16
Stock options1163
Restricted stock units1—12—
Performance restricted stock units2—32
Phantom stock awards and stock appreciation rights1133
Total$9$8$35$24

Table 20 after “Our long-term stock award activity was as follows, shares in millions:”

Nine Months Ended September 30,
20202019
Unvested stock award shares at January 122
Weighted average grant date fair value$34$30
Stock award shares granted—1
Weighted average grant date fair value$—$36
Stock award shares vested11
Weighted average grant date fair value$32$25

First 8 of 12 rows. The download has all of them.

Table 21 after “Our stock option activity was as follows, shares in millions:”

Nine Months Ended September 30,
20202019
Option shares outstanding, January 134
Weighted average exercise price$27$21
Option shares granted11
Weighted average exercise price$48$36
Option shares exercised12
Aggregate intrinsic value on date of exercise (A)$29 million$29 million

First 8 of 22 rows. The download has all of them.

Table 22 after “The weighted average grant date fair value of option shares granted and the assumptions used to estimate those values using a Black-Scholes ”

Nine Months Ended September 30,
20202019
Weighted average grant date fair value$10.67$8.81
Risk-free interest rate1.53%2.57%
Dividend yield1.14%1.35%
Volatility factor24.00%25.00%
Expected option life6 years6 years

Table 23 after “Net periodic pension cost for our defined-benefit pension plans, with the exception of service cost, is recorded in other income (expense), ”

Three Months Ended September 30,
20202019
QualifiedNon-QualifiedQualifiedNon-Qualified
Service cost$1$—$1$—
Interest cost52112
Expected return on plan assets(6)—(12)—
Amortization of net loss7—41
Net periodic pension cost$7$2$4$3

Table 24 after “Net periodic pension cost for our defined-benefit pension plans, with the exception of service cost, is recorded in other income (expense), ”

Nine Months Ended September 30,
20202019
QualifiedNon-QualifiedQualifiedNon-Qualified
Service cost$2$—$2$—
Interest cost184305
Expected return on plan assets(17)—(34)—
Amortization of net loss182142
Net periodic pension cost$21$6$12$7

Table 25 after “The reclassifications from accumulated other comprehensive loss to the condensed consolidated statements of operations were as follows, in m”

Amounts ReclassifiedAmounts Reclassified
Accumulated Other Comprehensive LossThree Months Ended September 30,Nine Months Ended September 30,Statement of Operations Line Item
2020201920202019
Amortization of defined-benefit pension and other post-retirement benefits:
Actuarial losses, net$7$5$20$16Other income (expense), net
Tax (benefit)(2)(1)(5)(4)
Net of tax$5$4$15$12
Interest rate swaps$—$—$1$1Interest expense

First 8 of 10 rows. The download has all of them.

Table 26 after “Information by segment and geographic area was as follows, in millions:”

Three Months Ended September 30,Nine Months Ended September 30,
20202019202020192020201920202019
Net Sales (A)Operating Profit (Loss)Net Sales (A)Operating Profit (Loss)
Operations by segment:
Plumbing Products$1,141$1,006$271$179$2,964$2,958$583$530
Decorative Architectural Products8427101791342,3642,110475380
Total$1,983$1,716$450$313$5,328$5,068$1,058$910
Operations by geographic area:

First 8 of 15 rows. The download has all of them.

Table 27 after “Other, net, which is included in other income (expense), net, was as follows, in millions:”

Three Months Ended September 30,Nine Months Ended September 30,
2020201920202019
Income from cash and cash investments$—$1$2$2
Equity investment income, net1111
Foreign currency transaction gains (losses)1(5)(6)(3)
Net periodic pension and post-retirement benefit cost(9)(6)(25)(17)
Dividend income3—7—
Other items, net——(1)—

First 8 of 9 rows. The download has all of them.

Table 28 after “Reconciliations of the numerators and denominators used in the computations of basic and diluted income per common share were as follows, in”

Three Months Ended September 30,Nine Months Ended September 30,
2020201920202019
Numerator (basic and diluted):
Income from continuing operations$275$163$618$481
Less: Allocation to unvested restricted stock awards1153
Income from continuing operations attributable to common shareholders274162613478
(Loss) income from discontinued operations, net—(37)4111
Less: Allocation to unvested restricted stock awards——3—

First 8 of 14 rows. The download has all of them.

Table 29 after “The following table sets forth our net sales and operating profit (loss) by business segment and geographic area, dollars in millions:”

Three Months Ended September 30,Percent Change
202020192020vs.2019
Net Sales:
Plumbing Products$1,141$1,00613%
Decorative Architectural Products84271019%
Total$1,983$1,71616%
North America$1,599$1,37416%
International, principally Europe38434212%

First 8 of 9 rows. The download has all of them.

Table 30 after “The following table sets forth our net sales and operating profit (loss) by business segment and geographic area, dollars in millions:”

Nine Months Ended September 30,Percent Change
202020192020vs.2019
Net Sales:
Plumbing Products$2,964$2,958—%
Decorative Architectural Products2,3642,11012%
Total$5,328$5,0685%
North America$4,337$4,0338%
International, principally Europe9911,035(4)%

First 8 of 9 rows. The download has all of them.

Table 31 after “The following table sets forth our net sales and operating profit (loss) by business segment and geographic area, dollars in millions:”

Three Months Ended September 30,Nine Months Ended September 30,
2020201920202019
Operating Profit (Loss): (A)
Plumbing Products$271$179$583$530
Decorative Architectural Products179134475380
Total$450$313$1,058$910
North America$368$262$899$759
International, principally Europe8251159151

First 8 of 11 rows. The download has all of them.

Table 32 after “r the three-month and nine-month periods ended September 30, 2020, respectively. The following table reconciles reported net sales to net sa”

Three Months Ended September 30,Nine Months Ended September 30,
2020201920202019
Net sales, as reported$1,983$1,716$5,328$5,068
Currency translation(13)—9—
Net sales, excluding the effect of currency translation$1,970$1,716$5,337$5,068

Table 33 after “Exhibits”

4.1–Resolutions establishing the terms of the 2.000% Notes Due 2030 and form of global note. Incorporated by reference to Exhibit 4.1 to Masco Corporation’s Current Report on Form 8-K dated and filed on September 18, 2020.
4.2–Resolutions establishing the terms of the 4.500% Notes Due 2047 and form of global note. Incorporated by reference to Exhibit 4.2 to Masco Corporation’s Current Report on Form 8-K dated and filed on September 18, 2020.
4.3–Second Supplemental Indenture dated as of September 18, 2020 to the Indenture dated as of February 12, 2001 between Masco Corporation and The Bank of New York Mellon Trust Company, N.A., as successor trustee under agreement originally with Bank One Trust Company, National Association, as Trustee, as supplemented. Incorporated by reference to Exhibit 4.3 to Masco Corporation’s Current Report on Form 8-K dated and filed on September 18, 2020.
31a–Certification by Chief Executive Officer Required by Rule 13a-14(a) or 15d-14(a) of the Securities Exchange Act of 1934
31b–Certification by Chief Financial Officer Required by Rule 13a-14(a) or 15d-14(a) of the Securities Exchange Act of 1934
32–Certification Required by Rule 13a-14(b) or 15d-14(b) of the Securities Exchange Act of 1934 and Section 1350 of Chapter 63 of Title 18 of the United States Code
101–The following financial information from Masco Corporation's Quarterly Report on Form 10-Q for the quarter ended September 30, 2020, formatted in Inline XBRL: (i) the Condensed Consolidated Balance Sheets, (ii) the Condensed Consolidated Statements of Operations, (iii) the Condensed Consolidated Statements of Comprehensive Income (Loss), (iv) the Condensed Consolidated Statements of Cash Flows, (v) the Consolidated Statements of Shareholders' Equity, and (vi) Notes to Condensed Consolidated Financial Statements.
104–Cover Page Interactive Data File (formatted in Inline XBRL and contained in Exhibit 101)