tickdelta
Sign in

Tickdelta is free for now. Sign up and get Pro free

← Filings of MAS

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

39 tables with numbers, filed Jul 28, 2022. 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 ↗

Table 1 after “INDEX”

Download CSV
Page No.
PART I.FINANCIAL INFORMATION
Item 1.Financial Statements (Unaudited):
Condensed Consolidated Balance Sheets — as of June 30, 2022 and December 31, 20211
Condensed Consolidated Statements of Operations for the Three and Six Months Ended June 30, 2022 and 20212
Condensed Consolidated Statements of Comprehensive Income (Loss) for the Three and Six Months Ended June 30, 2022 and 20213
Condensed Consolidated Statements of Cash Flows for the Six Months Ended June 30, 2022 and 20214
Consolidated Statements of Shareholders’ Equity for the Three and Six Months Ended June 30, 2022 and 20215

First 8 of 17 rows. The CSV has all of them.

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

Download CSV
June 30, 2022December 31, 2021
ASSETS
Current Assets:
Cash and cash investments$440$926
Receivables1,4341,171
Prepaid expenses and other131109
Inventories:
Finished goods823702

First 8 of 41 rows. The CSV has all of them.

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

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2022202120222021
Net sales$2,352$2,179$4,553$4,149
Cost of sales1,5831,3883,0802,658
Gross profit7697911,4731,491
Selling, general and administrative expenses361354712689
Operating profit408437761802
Other income (expense), net:

First 8 of 21 rows. The CSV has all of them.

Table 4 after “(In Millions)”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2022202120222021
Net income (loss)$294$(15)$546$99
Less: Net income attributable to noncontrolling interest16213541
Net income (loss) attributable to Masco Corporation$278$(36)$511$58
Other comprehensive (loss) income, net of tax (Note L):
Cumulative translation adjustment$(55)$37$(66)$1
Interest rate swaps———7

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

Table 5 after “(In Millions)”

Download CSV
Six Months Ended June 30,
20222021
CASH FLOWS FROM (FOR) OPERATING ACTIVITIES:
Cash provided by operations$662$610
Increase in receivables(296)(238)
Increase in inventories(159)(147)
(Decrease) increase in accounts payable and accrued liabilities, net(33)14
Net cash from operating activities174239

First 8 of 33 rows. The CSV has all of them.

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

Download CSV
TotalCommonShares($1 par value)Paid-In CapitalRetained Earnings (Deficit)Accumulated Other Comprehensive (Loss) IncomeNoncontrolling Interest
Balance, January 1, 2021$421$258$—$79$(142)$226
Total comprehensive income (loss)90——94(12)8
Shares issued—1(1)———
Shares retired:
Repurchased(303)(6)(27)(270)——
Surrendered (non-cash)(13)——(13)——
Redeemable noncontrolling interest - redemption adjustment(6)——(6)——

First 8 of 17 rows. The CSV has all of them.

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

Download CSV
TotalCommonShares($1 par value)Paid-In CapitalRetained (Deficit) EarningsAccumulated Other Comprehensive Income (Loss)Noncontrolling Interest
Balance, January 1, 2022$56$241$—$(652)$232$235
Total comprehensive income (loss)242——233(6)15
Shares issued11————
Shares retired:
Repurchased(364)(6)(27)(331)——
Surrendered (non-cash)(17)——(17)——
Cash dividends declared(67)——(67)——

First 8 of 19 rows. The CSV has all of them.

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

Download CSV
Three Months Ended June 30, 2022
Plumbing ProductsDecorative Architectural ProductsTotal
Primary geographic markets:
North America$926$979$1,905
International, principally Europe447—447
Total$1,373$979$2,352

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

Download CSV
Six Months Ended June 30, 2022
Plumbing ProductsDecorative Architectural ProductsTotal
Primary geographic markets:
North America$1,818$1,821$3,639
International, principally Europe914—914
Total$2,732$1,821$4,553

Table 10 after “D. REVENUE, Concluded”

Download CSV
Three Months Ended June 30, 2021
Plumbing ProductsDecorative Architectural ProductsTotal
Primary geographic markets:
North America$867$850$1,717
International, principally Europe462—462
Total$1,329$850$2,179

Table 11 after “D. REVENUE, Concluded”

Download CSV
Six Months Ended June 30, 2021
Plumbing ProductsDecorative Architectural ProductsTotal
Primary geographic markets:
North America$1,675$1,571$3,246
International, principally Europe903—903
Total$2,578$1,571$4,149

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

Download CSV
Six Months Ended June 30, 2022Twelve Months Ended December 31, 2021
Balance at January 1$6$7
Provision for expected credit losses during the period21
Write-offs charged against the allowance(1)(2)
Recoveries of amounts previously written off11
Other (A)—(1)
Balance at end of period$8$6

Table 13 after “Goodwill at June 30, 2022, by segment, was as follows, in millions:”

Download CSV
Gross Goodwill At June 30, 2022Accumulated Impairment LossesNet Goodwill At June 30, 2022
Plumbing Products$609$(301)$308
Decorative Architectural Products366(120)246
Total$975$(421)$554

Table 14 after “The changes in the carrying amount of goodwill for the six months ended June 30, 2022, by segment, were as follows, in millions:”

Download CSV
Gross Goodwill At December 31, 2021Accumulated Impairment LossesNet Goodwill At December 31, 2021Other (B)Net Goodwill At June 30, 2022
Plumbing Products (A)$623$(301)$322$(14)$308
Decorative Architectural Products366(120)246—246
Total$989$(421)$568$(14)$554

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

Download CSV
Six Months Ended June 30, 2022Twelve Months Ended December 31, 2021
Balance at January 1$80$83
Accruals for warranties issued during the period1938
Accruals related to pre-existing warranties2(8)
Settlements made (in cash or kind) during the period(16)(31)
Other, net (including currency translation and acquisitions)(2)(2)
Balance at end of period$83$80

Table 16 after “Pre-tax compensation expense for these stock-based incentives was as follows, in millions:”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2022202120222021
Restricted stock units$6$4$25$23
Performance restricted stock units3446
Stock options1165
Long-term stock awards2346
Phantom stock awards———2
Total$12$12$39$42

Table 17 after “Our restricted stock unit activity was as follows, units in millions:”

Download CSV
Six Months Ended June 30,
20222021
Unvested restricted stock units at January 11—
Weighted average grant date fair value$54$47
Restricted stock units granted11
Weighted average grant date fair value$59$57
Restricted stock units vested1—
Weighted average grant date fair value$53$47

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

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

Download CSV
Six Months Ended June 30,
20222021
Option shares outstanding, January 132
Weighted average exercise price$37$33
Option shares granted—1
Weighted average exercise price$59$56
Option shares exercised——
Aggregate intrinsic value on date of exercise (A)$—$1 million

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

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

Download CSV
Six Months Ended June 30,
20222021
Weighted average grant date fair value$14.66$13.61
Risk-free interest rate1.90%0.75%
Dividend yield1.89%1.67%
Volatility factor29.00%30.00%
Expected option life6 years6 years

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

Download CSV
Six Months Ended June 30,
20222021
Unvested stock award shares at January 111
Weighted average grant date fair value$37$36
Stock award shares vested1—
Weighted average grant date fair value$37$34
Stock award shares forfeited——
Weighted average grant date fair value$37$37

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

Table 21 after “Net periodic pension cost for our defined-benefit pension plans was as follows, in millions:”

Download CSV
Three Months Ended June 30,
20222021
QualifiedNon-QualifiedQualifiedNon-Qualified
Service cost$—$—$1$—
Interest cost—15—
Expected return on plan assets——(3)—
Settlement loss——406—
Amortization of net loss1—51

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

Table 22 after “Net periodic pension cost for our defined-benefit pension plans was as follows, in millions:”

Download CSV
Six Months Ended June 30,
20222021
QualifiedNon-QualifiedQualifiedNon-Qualified
Service cost$1$—$2$—
Interest cost12131
Expected return on plan assets(1)—(7)—
Settlement loss——406—
Amortization of net loss21112

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

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

Download CSV
Amounts Reclassified
Accumulated Other Comprehensive IncomeThree Months Ended June 30,Six Months Ended June 30,Statement of Operations Line Item
2022202120222021
Settlement and amortization of defined-benefit pension and other post-retirement benefits (A):
Actuarial losses, net$1$9$3$16Other, net
Settlement loss—447—447Other, net
Tax (benefit)—(98)(1)(100)
Net of tax$1$358$2$363

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

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

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
20222021202220212022202120222021
Net Sales (A)Operating ProfitNet Sales (A)Operating Profit
Operations by segment:
Plumbing Products$1,373$1,329$238$273$2,732$2,578$466$525
Decorative Architectural Products9798501921881,8211,571347330
Total$2,352$2,179$430$461$4,553$4,149$813$855
Operations by geographic area:

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

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

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2022202120222021
Contingent consideration (A)$28$—$24$—
Foreign currency transaction (losses) gains(6)2(2)2
Net periodic pension and post-retirement benefit expense (B)(3)(415)(5)(426)
Loss on sale of businesses, net(3)(18)(1)(18)
Income from cash and cash investments1—1—
Gain on preferred stock redemption (C)—14—14

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

Table 26 after “Reconciliations of the numerators and denominators used in the computations of basic and diluted income (loss) per common share were as foll”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2022202120222021
Numerator (basic and diluted):
Net income (loss)$278$(36)$511$58
Less: Allocation to redeemable noncontrolling interest1——6
Less: Allocation to unvested restricted stock awards1—2—
Net income (loss) attributable to common shareholders$276$(36)$509$52
Denominator:

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

Table 27 after “The following stock options and restricted stock units were excluded from the computation of weighted-average diluted common shares outstand”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2022202120222021
Number of stock options6702,802599260
Number of restricted stock units249464171

Table 28 after “Below is a summary of our net sales, in millions, for the three and six months ended June 30, 2022 and 2021:”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
20222021Change20222021Change
Net sales, as reported$2,352$2,179$173$4,553$4,149$404
Acquisitions(5)—(5)(11)—(11)
Divestitures—(12)12—(32)32
Net sales, excluding acquisitions and divestitures2,3472,1671804,5424,117425
Currency translation57—5788—88
Net sales, excluding acquisitions, divestitures and the effect of currency translation$2,404$2,167$237$4,630$4,117$513

Table 29 after “Below is a summary of our gross profit, in millions, and gross margin for the three and six months ended June 30, 2022 and 2021:”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
20222021Favorable / (Unfavorable)20222021Favorable / (Unfavorable)
Gross profit$769$791$(22)$1,473$1,491$(18)
Gross margin32.7%36.3%(360) bps32.4%35.9%(350) bps

Table 30 after “Below is a summary of our selling, general and administrative expenses, in millions, and selling, general and administrative expenses as a p”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
20222021(Favorable) / Unfavorable20222021(Favorable) / Unfavorable
Selling, general and administrative expenses$361$354$7$712$689$23
Selling, general and administrative expenses as percentage of net sales15.3%16.2%(90) bps15.6%16.6%(100) bps

Table 31 after “Below is a summary of our operating profit, in millions, and operating profit margin for the three and six months ended June 30, 2022 and 20”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
20222021Favorable / (Unfavorable)20222021Favorable / (Unfavorable)
Operating profit$408$437$(29)$761$802$(41)
Operating profit margin17.3%20.1%(280) bps16.7%19.3%(260) bps

Table 32 after “Below is a summary of our interest expense, in millions, for the three and six months ended June 30, 2022 and 2021:”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
20222021Favorable / (Unfavorable)20222021Favorable / (Unfavorable)
Interest expense$(28)$(25)$(3)$(53)$(227)$174

Table 33 after “Below is a summary of our other, net, in millions, for the three and six months ended June 30, 2022 and 2021:”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
20222021Favorable / (Unfavorable)20222021Favorable / (Unfavorable)
Other, net$17$(415)$432$16$(421)$437

Table 34 after “Below is a summary of our income tax expense, in millions, and our effective tax rate for the three and six months ended June 30, 2022 and 2”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
20222021(Favorable) / Unfavorable20222021(Favorable) / Unfavorable
Income tax expense$103$12$91$178$55$123
Effective tax rate26%Not MeaningfulNot Meaningful25%36%(11)%

Table 35 after “Below is a summary of our net income (loss) and diluted income (loss) per common share, in millions, except per share data, for the three an”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
20222021Favorable / (Unfavorable)20222021Favorable / (Unfavorable)
Net income (loss)$278$(36)$314$511$58$453
Diluted income (loss) per common share$1.18$(0.14)$1.32$2.15$0.20$1.95

Table 36 after “The following table sets forth our net sales and operating profit information by Business Segment and Geographic Area, dollars in millions.”

Download CSV
Three Months Ended June 30,Percent ChangeSix Months Ended June 30,Percent Change
202220212022vs.2021202220212022vs.2021
Net Sales:
Plumbing Products$1,373$1,3293%$2,732$2,5786%
Decorative Architectural Products97985015%1,8211,57116%
Total$2,352$2,1798%$4,553$4,14910%
North America$1,905$1,71711%$3,639$3,24612%
International, principally Europe447462(3)%9149031%

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

Table 37 after “The following table sets forth our net sales and operating profit information by Business Segment and Geographic Area, dollars in millions.”

Download CSV
Three Months Ended June 30,Percent ChangeSix Months Ended June 30,Percent Change
202220212022vs.2021202220212022vs.2021
Operating Profit: (A)
Plumbing Products$238$273(13)%$466$525(11)%
Decorative Architectural Products1921882%3473305%
Total$430$461(7)%$813$855(5)%
North America$356$370(4)%$656$678(3)%
International, principally Europe7491(19)%157177(11)%

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

Table 38 after “The following table provides information regarding the repurchase of our common stock for the three months ended June 30, 2022 under the 202”

Download CSV
PeriodTotal Number Of Shares PurchasedAverage Price Paid Per Common ShareTotal Number Of Shares Purchased As Part Of Publicly Announced Plans or ProgramsMaximum Value Of Shares That May Yet Be Purchased Under The Plans Or Programs
4/1/22 - 4/30/22984,503$50.80984,503$714,466,545
5/1/22 - 5/31/22 (A)7,905,506$63.287,905,506$214,216,545
6/1/22 - 6/30/22 (A)1,545,468$—1,545,468$214,216,545
Total for the quarter10,435,477$52.7310,435,477$214,216,545

Table 39 after “Exhibits”

Download CSV
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 June 30, 2022, 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)