← Filings of MAS

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

35 tables with numbers, filed May 2, 2013. 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 ↗

		Page No.
PART I.	FINANCIAL INFORMATION
Item 1.	Financial Statements:
	Condensed Consolidated Balance Sheets – as at March 31, 2013 and December 31, 2012		1
	Condensed Consolidated Statements of Operations for the Three Months Ended March 31, 2013 and 2012		2
	Condensed Consolidated Statements of Comprehensive Income (Loss) for the Three Months Ended March 31, 2013 and 2012		3
	Condensed Consolidated Statements of Cash Flows for the Three Months Ended March 31, 2013 and 2012		4
	Consolidated Statements of Shareholders’ Equity for the Three Months Ended March 31, 2013 and 2012		5

	March 31,		December 31,
	2013		2012
ASSETS
Current assets:
Cash and cash investments	$1,032		$1,351
Receivables		1,174		933
Prepaid expenses and other		107		107
Assets held for sale		98		100

	Three Months Ended March 31,
	2013		2012
Net sales	$1,876		$1,806
Cost of sales		1,368		1,322
Gross profit		508		484
Selling, general and administrative expenses		376		377
Income from litigation settlements, net		—		(2)
Operating profit		132		109

	Three Months Ended
	March 31,
	2013		2012
CASH FLOWS FROM (FOR) OPERATING ACTIVITIES:
Cash provided by operations	$130		$90
Increase in receivables		(263)		(272)
Increase in inventories		(43)		(50)
(Decrease) increase in accounts payable and accrued liabilities, net		(34)		65

									(In Millions)
	Total		Common Shares ($ 1 par value)		Paid-In Capital	(Accumulated) Deficit) Retained Earnings	Accumulated Other Comprehensive Income		Noncontrolling Interest
Balance, January 1, 2012	$742		$348		$65	$38	$76		$215
Total comprehensive income		78						33		27	18
Shares issued		—		2		(2)
Shares retired:
Repurchased		(8)		(1)		(7)
Surrendered (non-cash)		(7)				(7)

	Gross Goodwill		Accumulated		Net Goodwill
	At		Impairment		At
	Mar. 31, 2013		Losses		Mar. 31, 2013
Cabinets and Related Products	$240		$(59)		$181
Plumbing Products		539		(340)		199
Installation and Other Services		1,806		(762)		1,044
Decorative Architectural Products		294		(75)		219
Other Specialty Products		982		(734)		248

	Gross Goodwill At Dec. 31, 2012		Accumulated Impairment Losses		Net Goodwill At Dec. 31, 2012	Other(A)	Additions(B)		Net Goodwill At Mar. 31, 2013
Cabinets and Related Products	$240		$(59)		$181	$—	$—		$181
Plumbing Products		544		(340)		204		(5)		—	199
Installation and Other Services		1,806		(762)		1,044		—		—	1,044
Decorative Architectural Products		294		(75)		219		—		—	219
Other Specialty Products		980		(734)		246		—		2	248
Total	$3,864		$(1,970)		$1,894	$(5)	$2		$1,891

		Pre-tax
		Unrealized	Unrealized	Recorded
	Cost Basis	Gains	Losses	Basis
March 31, 2013	$19	$3	$—	$22
December 31, 2012	$19	$3	$—	$22

		Fair Value Measurements Using
				Significant
		Quoted		Other		Significant
		Market		Observable		Unobservable
	Mar. 31,	Prices		Inputs		Inputs
	2013	(Level 1)		(Level 2)		(Level 3)
Auction rate securities	$22		—		—		$22
Total	$22	$—		$—		$22

	March 31, 2013		December 31, 2012
	Auction Rate		Auction Rate
	Securities		Securities
Fair value at beginning of period	$22		$22
Total losses included in earnings		—		—
Unrealized (losses)		—		—
Purchases		—		—
Settlements		—		—

	Three Months Ended
	March 31,
	2013		2012
Net Sales	$59		$89
Operating loss from discontinued operations	$(3)		$(11)
Impairment of assets		(10)		—
Loss on disposal of discontinued operations, net		—		(1)
Loss before income tax		(13)		(12)

	Three Months Ended
	March 31,
	2013		2012
Foreign Currency Contracts
Exchange Contracts	$7		$(5)
Forward Contracts		2		(1)
Metal Contracts		(4)		7
Total gain	$5		$1

	At March 31, 2013
	Notional
	Amount		Assets			Liabilities
Foreign Currency Contracts
Exchange Contracts	$162
Current assets				$4			$1
Forward Contracts		68
Current assets					1			—

	At December 31, 2012
	Notional
	Amount		Assets			Liabilities
Foreign Currency Contracts
Exchange Contracts	$172
Current liabilities				$—			$5
Forward Contracts		76
Current assets					1			1

	Three Months Ended		Twelve Months Ended
	March 31, 2013		December 31, 2012
Balance at January 1	$118		$102
Accruals for warranties issued during the period		9		42
Accruals related to pre-existing warranties		1		16
Settlements made (in cash or kind) during the period		(10)		(38)
Other, net		—		(4)
Balance at end of period	$118		$118

		Amount
Accumulated Other Comprehensive Income (Loss)		Reclassified
	March 31,
	2013			2012		Income Statement Line Item
Amortization of defined benefit pension:
Actuarial losses, net		$5			$4		Selling, General & Administrative Expense
			—			—		Tax expense
		$5			$4		Net of tax

	Three Months Ended		Percent (Decrease)
	March 31,		Increase
	2013		2012		2013 vs. 2012
Net Sales:
Cabinets and Related Products	$236		$228			4%
Plumbing Products		762		742			3%
Installation and Other Services		312		278			12%
Decorative Architectural Products		432		434			—%

Period	Total Number of Shares Purchased		Average Price Paid Per Common Share		Total Number of Shares Purchased as Part of Publicly Announced Plans or Programs (a)		Maximum Number of Shares That May Yet Be Purchased Under the Plans or Programs
1/1/13- 1/31/13		—		$—		—		24,348,790
2/1/13- 2/29/13		—		$—		—		24,348,790
3/1/13- 3/31/13		1,732,810		$20.14		1,732,810		22,615,980
Total for the quarter		1,732,810		$20.14		1,732,810		22,615,980

10	-	Credit Agreement dated as of March 28, 2013 among Masco Corporation and Masco Europe S.à.r.l., as borrowers, the Lenders party thereto, JPMorgan Chase Bank, N.A., as Administrative Agent, Citibank, N.A., as Syndication Agent, and Royal Bank of Canada, Deutsche Bank Securities Inc., PNC Bank, National Association, and SunTrust Bank, as Co-Documentation Agents. Incorporated by reference to Exhibit 10 to the Registrant’s Current Report on Form 8-K dated March 28, 2013 and filed on April 3, 2013.
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

Exhibit
Exhibit 10	Credit Agreement dated as of March 28, 2013 among Masco Corporation and Masco Europe S.à.r.l., as borrowers, the Lenders party thereto, JPMorgan Chase Bank, N.A., as Administrative Agent, Citibank, N.A., as Syndication Agent, and Royal Bank of Canada, Deutsche Bank Securities Inc., PNC Bank, National Association, and SunTrust Bank, as Co-Documentation Agents. Incorporated by reference to Exhibit 10 to the Registrant’s Current Report on Form 8-K dated March 28, 2013 and filed on April 3, 2013.
Exhibit 12	Computation of Ratio of Earnings to Combined Fixed Charges and Preferred Stock Dividends
Exhibit 31a	Certification by Chief Executive Officer Required by Rule 13a-14(a) or 15d-14(a) of the Securities Exchange Act of 1934
Exhibit 31b	Certification by Chief Financial Officer Required by Rule 13a-14(a) or 15d-14(a) of the Securities Exchange Act of 1934
Exhibit 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
Exhibit 101	Interactive Data File

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

Table 1 after “INDEX”

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

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

Table 4 after “(In Millions)”

Table 5 after “(In Millions)”

Table 6 after “For The Three Months Ended March 31, 2013 and 2012”

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

Table 8 after “The following balance sheet items have been reclassified as held for sale:”

Table 9 after “NOTES TO CONDENSED CONSOLIDATED FINANCIAL STATEMENTS (Unaudited) (continued)”

Table 10 after “NOTES TO CONDENSED CONSOLIDATED FINANCIAL STATEMENTS (Unaudited) (continued)”

Table 11 after “NOTES TO CONDENSED CONSOLIDATED FINANCIAL STATEMENTS (Unaudited) (continued)”

Table 12 after “The Company’s investments in available-for-sale securities at March 31, 2013 and December 31, 2012 were as follows, in millions:”

Table 13 after “Financial investments measured at fair value on a recurring basis at each reporting period and the amounts for each level within the fair va”

Table 14 after “Financial investments measured at fair value on a recurring basis at each reporting period and the amounts for each level within the fair va”

Table 15 after “The following table summarizes the changes in Level 3 financial assets measured at fair value on a recurring basis for the three months ende”

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

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

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 ”

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

Table 20 after “The fair value of all metal and foreign currency derivative contracts is estimated on a recurring basis, quarterly, using Level 2 inputs (si”

Table 21 after “NOTES TO CONDENSED CONSOLIDATED FINANCIAL STATEMENTS (Unaudited) (continued)”

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

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

Table 24 after “The weighted average grant date fair value of option shares granted in the period and the assumptions used to estimate those values using a ”

Table 25 after “The weighted average grant date fair value of option shares granted in the period and the assumptions used to estimate those values using a ”

Table 26 after “Effective January 1, 2010, the Company froze all future benefit accruals under substantially all of the Company’s domestic qualified and non”

Table 27 after “NOTES TO CONDENSED CONSOLIDATED FINANCIAL STATEMENTS (Unaudited) (continued)”

Table 28 after “NOTES TO CONDENSED CONSOLIDATED FINANCIAL STATEMENTS (Unaudited) (continued)”

Table 29 after “NOTES TO CONDENSED CONSOLIDATED FINANCIAL STATEMENTS (Unaudited) (continued)”

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

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

Table 32 after “Net sales increased four percent for the three-month period ended March 31, 2013 from the comparable period of 2012. There was no net impact”

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

Table 34 after “PART II. OTHER INFORMATION (continued)”

Table 35 after “EXHIBIT INDEX”