Spreadsheet: 2ff128e5-74a6-4918-bb1e-f755e0726bbf
Sheet: Balance Sheet & Cash Flow Info.

MATTEL, INC. AND SUBSIDIARIES
CONDENSED CONSOLIDATED BALANCE SHEETS
 |  |  |  |  |  |  | 2 0 0 9 |  |  |  |  |  |  |  |  | 2 0 1 0 |  |  |  |  |  |  |  |  | 2 0 1 1
(In millions) |  |  |  |  |  |  | At 3/31 |  | At 6/30 |  | At 9/30 |  | At 12/31 |  |  | At 3/31 |  | At 6/30 |  | At 9/30 |  | At 12/31 |  |  | At 3/31 |  | At 6/30 |  | At 9/30 |  | At 12/31
Assets
Cash and equivalents |  |  |  |  |  | $ | 404.9 | $ | 422.7 | $ | 323.7 | $ | 1117 |  | $ | 871.9 | $ | 544.9 | $ | 960.5 | $ | 1281.1 |  | $ | 1049.4 | $ | 418.5 | $ | 254.5 | $ | 1369.1
Accounts receivable, net |  |  |  |  |  |  | 565.3 |  | 747.2 |  | 1450.3 |  | 749.3 |  |  | 661.9 |  | 805.1 |  | 1550 |  | 1146.1 |  |  | 758.6 |  | 1012 |  | 1650.6 |  | 1246.7
Inventories |  |  |  |  |  |  | 487.9 |  | 589.6 |  | 606 |  | 355.7 |  |  | 429.6 |  | 597.6 |  | 741.4 |  | 463.8 |  |  | 607.2 |  | 783.5 |  | 764 |  | 487
Prepaid expenses and other current assets |  |  |  |  |  |  | 375.51 |  | 402.7 |  | 323.5 |  | 332.6 |  |  | 337.9 |  | 330.4 |  | 313.8 |  | 335.6 |  |  | 336.5 |  | 317.1 |  | 303.7 |  | 340.9
Total current assets |  |  |  |  |  |  | 1833.61 |  | 2162.2 |  | 2703.5 |  | 2554.6 |  |  | 2301.3 |  | 2278 |  | 3565.7 |  | 3226.6 |  |  | 2751.7 |  | 2531.1 |  | 2972.8 |  | 3443.7
Property, plant and equipment, net |  |  |  |  |  |  | 516.4 |  | 522.2 |  | 513.2 |  | 504.8 |  |  | 492.2 |  | 486 |  | 478.1 |  | 484.7 |  |  | 494.1 |  | 513.8 |  | 515.3 |  | 523.9
Other noncurrent assets |  |  |  |  |  |  | 1755.9 |  | 1793.2 |  | 1772.4 |  | 1721.2 |  |  | 1709.7 |  | 1711.7 |  | 1715 |  | 1706.4 |  |  | 1736.3 |  | 1752.8 |  | 1713.4 |  | 1704
Total Assets |  |  |  |  |  | $ | 4105.91 | $ | 4477.6 | $ | 4989.1 | $ | 4780.6 |  | $ | 4503.2 | $ | 4475.7 | $ | 5758.8 | $ | 5417.7 |  | $ | 4982.1 | $ | 4797.7 | $ | 5201.5 | $ | 5671.6
Liabilities and Stockholders' Equity
Short-term borrowings |  |  |  |  |  | $ | 0 | $ | 294.2 | $ | 159.3 | $ | 2 |  | $ | 0 | $ | 0 | $ | 5.5 | $ | 0 |  | $ | 0 | $ | 0 | $ | 236.8 | $ | 8
Current portion of long-term debt |  |  |  |  |  |  | 150 |  | 50 |  | 50 |  | 50 |  |  | 50 |  | 250 |  | 250 |  | 250 |  |  | 250 |  | 10 |  | 60 |  | 50
Accounts payable and accrued liabilities |  |  |  |  |  |  | 600.2 |  | 703.3 |  | 1116.3 |  | 968.5 |  |  | 658.6 |  | 762.6 |  | 1138.1 |  | 1048.5 |  |  | 771.6 |  | 871.1 |  | 1055.9 |  | 953.8
Income taxes payable |  |  |  |  |  |  | 20.8 |  | 0 |  | 11.1 |  | 40.4 |  |  | 14.7 |  | 15.1 |  | 52.2 |  | 51.8 |  |  | 18.6 |  | 17.5 |  | 45.7 |  | 27.1
Total current liabilities |  |  |  |  |  |  | 771 |  | 1047.5 |  | 1336.7 |  | 1060.9 |  |  | 723.3 |  | 1027.7 |  | 1445.8 |  | 1350.3 |  |  | 1040.2 |  | 898.6 |  | 1398.4 |  | 1038.9
Long-term debt |  |  |  |  |  |  | 750 |  | 710 |  | 710 |  | 700 |  |  | 700 |  | 460 |  | 960 |  | 950 |  |  | 950 |  | 950 |  | 900 |  | 1500
Other noncurrent liabilities |  |  |  |  |  |  | 538.9 |  | 550.4 |  | 536.7 |  | 488.7 |  |  | 484.3 |  | 481 |  | 495.9 |  | 488.8 |  |  | 474.5 |  | 482.2 |  | 472.6 |  | 522.1
Stockholders' equity |  |  |  |  |  |  | 2046 |  | 2169.7 |  | 2405.7 |  | 2531 |  |  | 2595.6 |  | 2507 |  | 2857.1 |  | 2628.6 |  |  | 2517.4 |  | 2466.9 |  | 2430.5 |  | 2610.6
Total Liabilities and Stockholders' Equity |  |  |  |  |  | $ | 4105.9 | $ | 4477.6 | $ | 4989.1 | $ | 4780.6 |  | $ | 4503.2 | $ | 4475.7 | $ | 5758.8 | $ | 5417.7 |  | $ | 4982.1 | $ | 4797.7 | $ | 5201.5 | $ | 5671.6
SUPPLEMENTAL BALANCE SHEET AND CASH FLOW DATA
 |  |  |  |  |  |  | 2 0 0 9 |  |  |  |  |  |  |  |  | 2 0 1 0 |  |  |  |  |  |  |  |  | 2 0 1 1
(In millions, except days and percentage information) |  |  |  |  |  |  | At 3/31 |  | At 6/30 |  | At 9/30 |  | At 12/31 |  |  | At 3/31 |  | At 6/30 |  | At 9/30 |  | At 12/31 |  |  | At 3/31 |  | At 6/30 |  | At 9/30 |  | At 12/31
Key Balance Sheet Data:
Accounts Receivable, Net |  |  |  |  |  | $ | 565.3 | $ | 747.2 | $ | 1450.3 | $ | 749.3 |  | $ | 661.9 | $ | 805.1 | $ | 1550 | $ | 1146.1 |  | $ | 758.6 | $ | 1012 | $ | 1650.6 | $ | 1246.7
Days of Sales Outstanding (DSO) |  |  |  |  |  |  | 65 |  | 75 |  | 73 |  | 35 |  |  | 68 |  | 71 |  | 76 |  | 48 |  |  | 72 |  | 78 |  | 74 |  | 52
Total Debt Outstanding |  |  |  |  |  | $ | 900 | $ | 1054.2 | $ | 919.3 | $ | 752 |  | $ | 750 | $ | 710 | $ | 1215.5 | $ | 1200 |  | $ | 1200 | $ | 960 | $ | 1196.8 | $ | 1558
Total Debt-to-Total-Capital Ratio |  |  |  |  |  |  | 0.3054989816700611 |  | 0.3269952541952295 |  | 0.276 |  | 0.229 |  |  | 0.224 |  | 0.221 |  | 0.298 |  | 0.313 |  |  | 0.323 |  | 0.28 |  | 0.33 |  | 0.374
 |  |  |  |  |  |  | 2 0 0 9 |  |  |  |  |  |  |  |  | 2 0 1 0 |  |  |  |  |  |  |  |  | 2 0 1 1
 |  |  |  |  |  |  | 3 Months |  | 6 Months |  | 9 Months |  | 12 Months |  |  | 3 Months |  | 6 Months |  | 9 Months |  | 12 Months |  |  | 3 Months |  | 6 Months |  | 9 Months |  | 12 Months
(In millions) |  |  |  |  |  |  | 3/31 |  | 6/30 |  | 9/30 |  | 12/31 |  |  | 3/31 |  | 6/30 |  | 9/30 |  | 12/31 |  |  | 3/31 |  | 6/30 |  | 9/30 |  | 12/31
Condensed Cash Flow Data:
Cash Flows From (Used For) Operating Activities |  |  |  |  |  | $ | -215 | $ | -350 | $ | -319 | $ | 945 |  | $ | -245 | $ | -372 | $ | -428 | $ | 528 |  | $ | -42 | $ | -227 | $ | -322 | $ | 665
Cash Flows From (Used For) Investing Activities |  |  |  |  |  |  | 23 |  | 9 |  | -3 |  | -34 |  |  | -35 |  | -97 |  | -89 |  | -147 |  |  | -9 |  | -44 |  | -119 |  | -175
Cash Flows From (Used For) Financing Activities and Other |  |  |  |  |  |  | -21 |  | 146 |  | 28 |  | -412 |  |  | 35 |  | -103 |  | 361 |  | -217 |  |  | -181 |  | -592 |  | -586 |  | -402
(Decrease) Increase in Cash and Equivalents |  |  |  |  |  | $ | -213 | $ | -195 | $ | -294 | $ | 499 |  | $ | -245 | $ | -572 | $ | -156 | $ | 164 |  | $ | -232 | $ | -863 | $ | -1027 | $ | 88
The financial information included herein should be read in conjunction with Mattel's consolidated financial statements and related notes in its Annual Reports on Form 10-K and/or Quarterly Reports on Form 10-Q, as applicable.