← 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 ↗
| | | Page No. |
| PART I. | FINANCIAL INFORMATION | | |
| Item 1. | Financial Statements (Unaudited) | |
| | Condensed Consolidated Balance Sheets - | |
| | as at March 31, 2014 and | |
| | December 31, 2013 | 1 |
| | 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, |
| 2014 | 2013 |
| ASSETS | | |
| Current assets: | | |
| Cash and cash investments | $906 | $1,223 |
| Short-term bank deposits | 305 | 321 |
| Receivables | 1,215 | 1,004 |
| Prepaid expenses and other | 154 | 155 |
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, | |
| 2014 | 2013 |
| Net sales | $1,965 | $1,876 |
| Cost of sales | 1,418 | 1,368 |
| Gross profit | 547 | 508 |
| Selling, general and administrative expenses | 395 | 376 |
| Operating profit | 152 | 132 |
| Other income (expense), net: | | |
First 8 of 31 rows. The CSV has all of them.
| Three Months Ended March 31, | |
| 2014 | 2013 |
| Net income | $86 | $62 |
| Less: Net income attributable to noncontrolling interest | 12 | 9 |
| 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 gain | 3 | 5 |
First 8 of 14 rows. The CSV has all of them.
| Three Months Ended | |
| March 31, | |
| 2014 | 2013 |
| 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.
| | | | | Accumulated | |
| | Common | | Retained | Other | |
| | Shares | Paid-In | (Deficit) | Comprehensive | Noncontrolling |
| Total | ($1 par value) | Capital | Earnings | Income | Interest |
| Balance, January 1, 2013 | $542 | $349 | $16 | $(94) | $59 | $212 |
| Total comprehensive income | 31 | | | 53 | (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, | | |
| 2013 | 2012 | 2011 |
| Other income (expense), net | | | |
| As reported | $(239) | $(229) | $(177) |
| Correction | 16 | — | 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 Ended | Three Months Ended | | | | | | |
| Dec. 31 | Sep. 30 | June 30 | Mar. 31 | Dec. 31 | Sep. 30 | June 30 | Mar. 31 |
| 2013 | 2012 | | | | | | |
| Other income (expense), net | | | | | | | | |
| As reported | $(71) | $(58) | $(57) | $(53) | $(57) | $(57) | $(66) | $(49) |
| Correction | 3 | 6 | 1 | 6 | 4 | 7 | (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. 31 | Sep. 30 | June 30 | Mar. 31 | As of |
| 2013 | Dec. 31, 2012 | | | |
| Other assets | | | | | |
| As reported | $161 | $166 | $173 | $182 | $184 |
| Correction | 24 | 21 | 15 | 14 | 8 |
| 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, |
| 2013 | 2013 |
| 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 Goodwill | Accumulated | Net Goodwill |
| At | Impairment | At |
| Mar. 31, 2014 | Losses | Mar. 31, 2014 |
| Cabinets and Related Products | $240 | $(59) | $181 |
| Plumbing Products | 550 | (340) | 210 |
| Installation and Other Services | 1,806 | (762) | 1,044 |
| Decorative Architectural Products | 294 | (75) | 219 |
| Other Specialty Products | 983 | (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 Goodwill | Accumulated | Net Goodwill | | Net Goodwill |
| At | Impairment | At | | At |
| Dec. 31, 2013 | Losses | Dec. 31, 2013 | Other(A) | Mar. 31, 2014 |
| Cabinets and Related Products | $240 | $(59) | $181 | $— | $181 |
| Plumbing Products | 550 | (340) | 210 | — | 210 |
| Installation and Other Services | 1,806 | (762) | 1,044 | — | 1,044 |
| Decorative Architectural Products | 294 | (75) | 219 | — | 219 |
| Other Specialty Products | 983 | (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, |
| 2014 | 2013 |
| Equity method investments | $68 | $70 |
| Total equity method investments | 68 | 70 |
| Auction rate securities | 22 | 22 |
| Total recurring investments | 22 | 22 |
| Private equity funds | 17 | 18 |
| Other investments | 3 | 3 |
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, | |
| 2014 | 2013 |
| 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, | |
| 2014 | 2013 |
| 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 | | |
| Amount | Assets | Liabilities |
| Foreign Currency Contracts | | | |
| Exchange Contracts | $83 | | |
| Current liabilities | | $— | $1 |
| Forward Contracts | 67 | | |
| 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 | | |
| Amount | Assets | Liabilities |
| Foreign Currency Contracts | | | |
| Exchange Contracts | $53 | | |
| Current liabilities | | $— | $2 |
| Forward Contracts | 88 | | |
| 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 Ended | Twelve Months Ended |
| March 31, 2014 | December 31, 2013 |
| Balance at January 1 | $124 | $118 |
| Accruals for warranties issued during the period | 11 | 42 |
| Accruals related to pre-existing warranties | 2 | 6 |
| 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, | |
| 2014 | 2013 |
| Long-term stock awards | $11 | $9 |
| Stock options | 1 | 5 |
| 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, | |
| 2014 | 2013 |
| Unvested stock award shares at January 1 | 8 | 8 |
| Weighted average grant date fair value | $17 | $16 |
| Stock award shares granted | 1 | 2 |
| Weighted average grant date fair value | $22 | $20 |
| Stock award shares vested | 2 | 2 |
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, | | | |
| 2014 | | 2013 | |
| Option shares outstanding, January 1 | | 24 | | 30 |
| Weighted average exercise price | $22 | | $21 | |
| Option shares granted | | — | | 1 |
| Weighted average exercise price | $22 | | $20 | |
| Option shares exercised | | 1 | | 2 |
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, | |
| 2014 | 2013 |
| Weighted average grant date fair value | $9.53 | $8.33 |
| Risk-free interest rate | 1.91% | 1.20% |
| Dividend yield | 1.34% | 1.47% |
| Volatility factor | 49.00% | 49.00% |
| Expected option life | 6 years | 6 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, | | | |
| 2014 | 2013 | | |
| Qualified | Non-Qualified | Qualified | Non-Qualified |
| Service cost | $1 | $— | $1 | $— |
| Interest cost | 13 | 2 | 11 | 1 |
| Expected return on plan assets | (12) | — | (10) | — |
| Amortization of net loss | 3 | — | 4 | 1 |
| Net periodic pension cost | $5 | $2 | 6 | 2 |
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 Other | Reclassified | | |
| Comprehensive | March 31, | | |
| Income (Loss) | 2014 | 2013 | Financial Statement Line Item |
| Amortization of defined benefit pension: | | | |
| Actuarial losses, net | $3 | $5 | Selling, general & administrative expense |
| — | — | Income tax expense |
| $3 | $5 | Net 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, | | | |
| 2014 | 2013 | 2014 | 2013 |
| Net Sales(A) | Operating Profit (Loss) | | |
| The Company’s operations by segment were: | | | | |
| Cabinets and Related Products | $237 | $236 | $(12) | $(4) |
| Plumbing Products | 800 | 762 | 119 | 86 |
| Installation and Other Services | 335 | 312 | (4) | (4) |
| Decorative Architectural Products | 441 | 432 | 76 | 89 |
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, | |
| 2014 | 2013 |
| 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, | |
| 2014 | 2013 |
| Numerator (basic and diluted): | | |
| Income from continuing operations | $76 | $62 |
| Less: Allocation to unvested restricted stock awards | 1 | 1 |
| 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 Ended | Percent (Decrease) | |
| March 31, | Increase | |
| 2014 | 2013 | 2014 vs. 2013 |
| Net Sales: | | | |
| Cabinets and Related Products | $237 | $236 | —% |
| Plumbing Products | 800 | 762 | 5% |
| Installation and Other Services | 335 | 312 | 7% |
| Decorative Architectural Products | 441 | 432 | 2% |
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, | |
| 2014 | 2013 |
| Operating Profit (Loss) Margins: (A) | | |
| Cabinets and Related Products | (5.1)% | (1.7)% |
| Plumbing Products | 14.9% | 11.3% |
| Installation and Other Services | (1.2)% | (1.3)% |
| Decorative Architectural Products | 17.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, | |
| 2014 | 2013 |
| Net sales, as reported | $1,965 | $1,876 |
| Acquisitions | (2) | — |
| Net sales, excluding acquisitions | 1,963 | 1,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 of | Maximum Number of |
| | | Shares Purchased | Shares That May |
| Total Number | Average Price | as Part of | Yet Be Purchased |
| of Shares | Paid Per | Publicly Announced | Under the Plans |
| Period | Purchased | Common Share | Plans 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/14 | 1,736,700 | $22.77 | 1,736,700 | 20,879,280 |
First 8 of 9 rows. The CSV has all of them.
| 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 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 |