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/

34 tables with numbers, filed Apr 30, 2014. 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 at March 31, 2014 and
December 31, 20131
Condensed Consolidated Statements of
Operations for the Three Months

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

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

Download CSV
March 31,December 31,
20142013
ASSETS
Current assets:
Cash and cash investments$906$1,223
Short-term bank deposits305321
Receivables1,2151,004
Prepaid expenses and other154155

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

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

Download CSV
Three Months Ended March 31,
20142013
Net sales$1,965$1,876
Cost of sales1,4181,368
Gross profit547508
Selling, general and administrative expenses395376
Operating profit152132
Other income (expense), net:

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

Table 4 after “(In Millions)”

Download CSV
Three Months Ended March 31,
20142013
Net income$86$62
Less: Net income attributable to noncontrolling interest129
Net income attributable to Masco Corporation$74$53
Other comprehensive income (loss), net of tax:
Cumulative translation adjustment(4)(36)
Unrecognized pension prior service cost and net gain35

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

Table 5 after “(In Millions)”

Download CSV
Three Months Ended
March 31,
20142013
CASH FLOWS FROM (FOR) OPERATING ACTIVITIES:
Cash provided by operations$121$130
Increase in receivables(227)(263)
Increase in inventories(75)(43)
Decrease in accounts payable and accrued liabilities, net(63)(34)

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

Table 6 after “(In Millions)”

Download CSV
Accumulated
CommonRetainedOther
SharesPaid-In(Deficit)ComprehensiveNoncontrolling
Total($1 par value)CapitalEarningsIncomeInterest
Balance, January 1, 2013$542$349$16$(94)$59$212
Total comprehensive income3153(23)1
Shares issued(7)2(9)
Shares retired:

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

Table 7 after “The following table presents the impact of the revisions on the Company’s previously issued full-year consolidated statement of operations (”

Download CSV
Year ended December 31,
201320122011
Other income (expense), net
As reported$(239)$(229)$(177)
Correction16—9
As revised$(223)$(229)$(168)
Income (loss) from continuing operations, before income taxes
As reported$434$73$(392)

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

Table 8 after “The following table presents the impact of the revisions on the Company’s previously issued quarterly consolidated statements of operations ”

Download CSV
Three Months EndedThree Months Ended
Dec. 31Sep. 30June 30Mar. 31Dec. 31Sep. 30June 30Mar. 31
20132012
Other income (expense), net
As reported$(71)$(58)$(57)$(53)$(57)$(57)$(66)$(49)
Correction361647(2)(9)
As revised$(68)$(52)$(56)$(47)$(53)$(50)$(68)$(58)
Income (loss) from continuing operations, before income taxes

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

Table 9 after “The following table presents the impact of the revisions on the Company’s previously issued consolidated balance sheets (in millions):”

Download CSV
As of
Dec. 31Sep. 30June 30Mar. 31As of
2013Dec. 31, 2012
Other assets
As reported$161$166$173$182$184
Correction242115148
As revised$185$187$188$196$192
Total assets

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

Table 10 after “The following table presents the impact of the revisions on the Company’s previously issued consolidated balance sheets and statements of ca”

Download CSV
Mar. 31,June 30,
20132013
Cash and cash investments
As reported$1,032$1,223
As revised$828$1,028
Short-term bank deposits
As reported——
As revised$204$195

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

Table 11 after “Selected financial information for the discontinued operations, during the period owned by the Company, was as follows, in millions:”

Download CSV
Three Months Ended
March 31, 2013
Net Sales$59
Operating loss from discontinued operations$(3)
Impairment of assets(10)
Loss on disposal of discontinued operations, net—
Loss before income tax(13)
Income tax benefit(4)

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

Table 12 after “The changes in the carrying amount of goodwill for the three months ended March 31, 2014, by segment, were as follows, in millions:”

Download CSV
Gross GoodwillAccumulatedNet Goodwill
AtImpairmentAt
Mar. 31, 2014LossesMar. 31, 2014
Cabinets and Related Products$240$(59)$181
Plumbing Products550(340)210
Installation and Other Services1,806(762)1,044
Decorative Architectural Products294(75)219
Other Specialty Products983(734)249

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

Table 13 after “The changes in the carrying amount of goodwill for the three months ended March 31, 2014, by segment, were as follows, in millions:”

Download CSV
Gross GoodwillAccumulatedNet GoodwillNet Goodwill
AtImpairmentAtAt
Dec. 31, 2013LossesDec. 31, 2013Other(A)Mar. 31, 2014
Cabinets and Related Products$240$(59)$181$—$181
Plumbing Products550(340)210—210
Installation and Other Services1,806(762)1,044—1,044
Decorative Architectural Products294(75)219—219
Other Specialty Products983(734)249—249

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

Table 14 after “The Company has maintained investments in available-for-sale securities and a number of private equity funds, principally as part of its tax”

Download CSV
March 31,December 31,
20142013
Equity method investments$68$70
Total equity method investments6870
Auction rate securities2222
Total recurring investments2222
Private equity funds1718
Other investments33

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

Table 15 after “Income (loss) from financial investments, net, included in other, net, within other income (expense), net, was as follows, in millions:”

Download CSV
Three Months Ended
March 31,
20142013
Realized gains from private equity funds$1$3
Equity investments (loss) income, net(2)7
Total income from financial investments$(1)$10

Table 16 after “The pre-tax (losses) gains included in the Company’s condensed consolidated statements of operations is as follows, in millions:”

Download CSV
Three Months Ended
March 31,
20142013
Foreign Currency Contracts
Exchange Contracts$(2)$7
Forward Contracts(1)2
Metals Contracts(3)(4)
Total (loss) gain$(6)$5

Table 17 after “The Company presents its derivatives, net by counterparty due to the right of offset under master netting arrangements in current assets or ”

Download CSV
At March 31, 2014
Notional
AmountAssetsLiabilities
Foreign Currency Contracts
Exchange Contracts$83
Current liabilities$—$1
Forward Contracts67
Current liabilities—1

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

Table 18 after “The Company presents its derivatives, net by counterparty due to the right of offset under master netting arrangements in current assets or ”

Download CSV
At December 31, 2013
Notional
AmountAssetsLiabilities
Foreign Currency Contracts
Exchange Contracts$53
Current liabilities$—$2
Forward Contracts88
Current liabilities—1

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

Table 19 after “Changes in the Company’s warranty liability were as follows, in millions:”

Download CSV
Three Months EndedTwelve Months Ended
March 31, 2014December 31, 2013
Balance at January 1$124$118
Accruals for warranties issued during the period1142
Accruals related to pre-existing warranties26
Settlements made (in cash or kind) during the period(11)(42)
Other, net——
Balance at end of period$126$124

Table 20 after “The Company’s 2005 Long Term Stock Incentive Plan (the “2005 Plan”) provides for the issuance of stock-based incentives in various forms to ”

Download CSV
Three Months Ended
March 31,
20142013
Long-term stock awards$11$9
Stock options15
Phantom stock awards and stock appreciation rights—3
Total$12$17
Income tax benefit (37 percent tax rate - before valuation allowance)$4$6

Table 21 after “The Company’s long-term stock award activity was as follows, shares in millions:”

Download CSV
Three Months Ended
March 31,
20142013
Unvested stock award shares at January 188
Weighted average grant date fair value$17$16
Stock award shares granted12
Weighted average grant date fair value$22$20
Stock award shares vested22

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

Table 22 after “The Company’s stock option activity was as follows, shares in millions:”

Download CSV
Three Months Ended
March 31,
20142013
Option shares outstanding, January 12430
Weighted average exercise price$22$21
Option shares granted—1
Weighted average exercise price$22$20
Option shares exercised12

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

Table 23 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
Three Months Ended
March 31,
20142013
Weighted average grant date fair value$9.53$8.33
Risk-free interest rate1.91%1.20%
Dividend yield1.34%1.47%
Volatility factor49.00%49.00%
Expected option life6 years6 years

Table 24 after “Net periodic pension cost for the Company’s defined-benefit pension plans was as follows, in millions:”

Download CSV
Three Months ended March 31,
20142013
QualifiedNon-QualifiedQualifiedNon-Qualified
Service cost$1$—$1$—
Interest cost132111
Expected return on plan assets(12)—(10)—
Amortization of net loss3—41
Net periodic pension cost$5$262

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

Download CSV
Amount
Accumulated OtherReclassified
ComprehensiveMarch 31,
Income (Loss)20142013Financial Statement Line Item
Amortization of defined benefit pension:
Actuarial losses, net$3$5Selling, general & administrative expense
——Income tax expense
$3$5Net of tax

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

Download CSV
Three Months Ended March 31,
2014201320142013
Net Sales(A)Operating Profit (Loss)
The Company’s operations by segment were:
Cabinets and Related Products$237$236$(12)$(4)
Plumbing Products80076211986
Installation and Other Services335312(4)(4)
Decorative Architectural Products4414327689

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

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

Download CSV
Three Months Ended
March 31,
20142013
Income from cash and cash investments$1$1
Income from financial investments (Note E)(1)10
Other items, net(3)2
Total other net$(3)$13

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

Download CSV
Three Months Ended
March 31,
20142013
Numerator (basic and diluted):
Income from continuing operations$76$62
Less: Allocation to unvested restricted stock awards11
Income from continuing operations attributable to common shareholders$75$61
Loss from discontinued operations, net(2)(9)

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

Table 29 after “The following table sets forth the Company’s net sales and operating profit margins by business segment and geographic area, dollars in mill”

Download CSV
Three Months EndedPercent (Decrease)
March 31,Increase
201420132014 vs. 2013
Net Sales:
Cabinets and Related Products$237$236—%
Plumbing Products8007625%
Installation and Other Services3353127%
Decorative Architectural Products4414322%

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

Table 30 after “The following table sets forth the Company’s net sales and operating profit margins by business segment and geographic area, dollars in mill”

Download CSV
Three Months Ended
March 31,
20142013
Operating Profit (Loss) Margins: (A)
Cabinets and Related Products(5.1)%(1.7)%
Plumbing Products14.9%11.3%
Installation and Other Services(1.2)%(1.3)%
Decorative Architectural Products17.2%20.6%

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

Table 31 after “Net sales increased five percent for the three-month period ended March 31, 2014, from the comparable period of 2013. Excluding the favorabl”

Download CSV
Three Months Ended
March 31,
20142013
Net sales, as reported$1,965$1,876
Acquisitions(2)—
Net sales, excluding acquisitions1,9631,876
Currency translation(13)—
Net sales, excluding acquisitions and the effect of currency translation$1,950$1,876

Table 32 after “The following table provides information regarding the repurchase of Company common stock for the three months ended March 31, 2013:”

Download CSV
Total Number ofMaximum Number of
Shares PurchasedShares That May
Total NumberAverage Priceas Part ofYet Be Purchased
of SharesPaid PerPublicly AnnouncedUnder the Plans
PeriodPurchasedCommon SharePlans or Programs(a)or Programs
1/1/14- 1/31/14—$——22,615,980
2/1/14- 2/28/14—$——22,615,980
3/1/14- 3/31/141,736,700$22.771,736,70020,879,280

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

Table 33 after “Exhibits”

Download CSV
12-Computation of Ratio of Earnings to Combined Fixed Charges and Preferred Stock Dividends
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-Interactive Data File

Table 34 after “EXHIBIT INDEX”

Download CSV
Exhibit
Exhibit 12Computation of Ratio of Earnings to Combined Fixed Charges and Preferred Stock Dividends
Exhibit 31aCertification by Chief Executive Officer Required by Rule 13a-14(a) or 15d-14(a) of the Securities Exchange Act of 1934
Exhibit 31bCertification by Chief Financial Officer Required by Rule 13a-14(a) or 15d-14(a) of the Securities Exchange Act of 1934
Exhibit 32Certification 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
Exhibit 101Interactive Data File