{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["RET_4_0-2012Q3","RET_4_1-2012Q3","RET_5_0-2012Q3","RET_5_1-2012Q3","RET_6_0-2012Q3"],"not_rendered":{"external_links":2,"defined_names":11},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"RET_4_0-2012Q3","index":0,"n_rows":47,"n_cols":11,"rows_kept":47,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[22,1,22,4],[22,6,22,9],[33,1,33,4],[33,6,33,9],[46,0,46,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 4.0 -- Income Statement  For Corporations in NAICS Retail Trade Sector, and Retail Trade Subsector 445,\n                              Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"All Retail Trade\nTotal Assets $50 Million and Over",{"$nulls":4},"Food and Beverage Stores\nTotal Assets $50 Million and Over"]
["Item"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":572400,"d":"572,400 "},{"v":624883,"d":"624,883 "},{"v":596252,"d":"596,252 "},{"v":601995,"d":"601,995 "},{"v":597334,"d":"597,334 "},{"v":104228,"d":"104,228 "},{"v":108870,"d":"108,870 "},{"v":108793,"d":"108,793 "},{"v":110140,"d":"110,140 "},{"v":109734,"d":"109,734 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":10864,"d":"10,864 "},{"v":11020,"d":"11,020 "},{"v":10837,"d":"10,837 "},{"v":11300,"d":"11,300 "},{"v":11319,"d":"11,319 "},{"v":2160,"d":"2,160 "},{"v":2225,"d":"2,225 "},{"v":2048,"d":"2,048 "},{"v":2248,"d":"2,248 "},{"v":2184,"d":"2,184 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":538277,"d":"538,277 "},{"v":581405,"d":"581,405 "},{"v":557738,"d":"557,738 "},{"v":562732,"d":"562,732 "},{"v":562081,"d":"562,081 "},{"v":99279,"d":"99,279 "},{"v":103478,"d":"103,478 "},{"v":103436,"d":"103,436 "},{"v":104390,"d":"104,390 "},{"v":104498,"d":"104,498 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":23258,"d":"23,258 "},{"v":32458,"d":"32,458 "},{"v":27677,"d":"27,677 "},{"v":27963,"d":"27,963 "},{"v":23934,"d":"23,934 "},{"v":2789,"d":"2,789 "},{"v":3167,"d":"3,167 "},{"v":3310,"d":"3,310 "},{"v":3502,"d":"3,502 "},{"v":3052,"d":"3,052 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4247,"d":"4,247 "},{"v":4226,"d":"4,226 "},{"v":4223,"d":"4,223 "},{"v":4230,"d":"4,230 "},{"v":4300,"d":"4,300 "},{"v":738,"d":"738 "},{"v":757,"d":"757 "},{"v":756,"d":"756 "},{"v":744,"d":"744 "},{"v":763,"d":"763 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4249,"d":"4,249 "},{"v":3580,"d":"3,580 "},{"v":1143,"d":"1,143 "},{"v":4513,"d":"4,513 "},{"v":3630,"d":"3,630 "},{"v":153,"d":"153 "},{"v":-1763,"d":"(1,763)"},{"v":-569,"d":"(569)"},{"v":247,"d":"247 "},{"v":247,"d":"247 "}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":23260,"d":"23,260 "},{"v":31811,"d":"31,811 "},{"v":24598,"d":"24,598 "},{"v":28246,"d":"28,246 "},{"v":23263,"d":"23,263 "},{"v":2205,"d":"2,205 "},{"v":647,"d":"647 "},{"v":1985,"d":"1,985 "},{"v":3005,"d":"3,005 "},{"v":2536,"d":"2,536 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":7572,"d":"7,572 "},{"v":12270,"d":"12,270 "},{"v":8861,"d":"8,861 "},{"v":9044,"d":"9,044 "},{"v":8172,"d":"8,172 "},{"v":671,"d":"671 "},{"v":389,"d":"389 "},{"v":926,"d":"926 "},{"v":962,"d":"962 "},{"v":757,"d":"757 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15688,"d":"15,688 "},{"v":19542,"d":"19,542 "},{"v":15737,"d":"15,737 "},{"v":19202,"d":"19,202 "},{"v":15092,"d":"15,092 "},{"v":1533,"d":"1,533 "},{"v":257,"d":"257 "},{"v":1058,"d":"1,058 "},{"v":2044,"d":"2,044 "},{"v":1779,"d":"1,779 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":3147,"d":"3,147 "},{"v":4263,"d":"4,263 "},{"v":9379,"d":"9,379 "},{"v":3954,"d":"3,954 "},{"v":5744,"d":"5,744 "},{"v":299,"d":"299 "},{"v":444,"d":"444 "},{"v":789,"d":"789 "},{"v":534,"d":"534 "},{"v":267,"d":"267 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":12541,"d":"12,541 "},{"v":15279,"d":"15,279 "},{"v":6358,"d":"6,358 "},{"v":15248,"d":"15,248 "},{"v":9348,"d":"9,348 "},{"v":1235,"d":"1,235 "},{"v":-187,"d":"(187)"},{"v":269,"d":"269 "},{"v":1510,"d":"1,510 "},{"v":1512,"d":"1,512 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":343308,"d":"343,308 "},{"v":350477,"d":"350,477 "},{"v":359770,"d":"359,770 "},{"v":352519,"d":"352,519 "},{"v":355746,"d":"355,746 "},{"v":33387,"d":"33,387 "},{"v":34408,"d":"34,408 "},{"v":33819,"d":"33,819 "},{"v":36886,"d":"36,886 "},{"v":37814,"d":"37,814 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-4269,"d":"(4,269)"},{"v":-7092,"d":"(7,092)"},{"v":-7280,"d":"(7,280)"},{"v":-11494,"d":"(11,494)"},{"v":-3085,"d":"(3,085)"},{"v":-321,"d":"(321)"},{"v":-411,"d":"(411)"},{"v":370,"d":"370 "},{"v":-105,"d":"(105)"},{"v":-217,"d":"(217)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":351579,"d":"351,579 "},{"v":358664,"d":"358,664 "},{"v":358848,"d":"358,848 "},{"v":356274,"d":"356,274 "},{"v":362009,"d":"362,009 "},{"v":34300,"d":"34,300 "},{"v":33810,"d":"33,810 "},{"v":34458,"d":"34,458 "},{"v":38290,"d":"38,290 "},{"v":39109,"d":"39,109 "}]
["                         INCOME STATEMENT IN RATIO FORMAT","(percent of net sales)",{"$nulls":4},"(percent of net sales)"]
["     Net sales, receipts, and operating revenues ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment ………………………………………………………………………………………………………………………………………………………………………",{"v":1.9,"d":"1.90"},1.76,1.82,1.88,1.89,2.07,2.04,1.88,2.04,1.99]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",94.04,93.04,93.54,93.48,{"v":94.1,"d":"94.10"},95.25,95.05,95.08,94.78,95.23]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",4.06,5.19,4.64,4.65,4.01,2.68,2.91,3.04,3.18,2.78]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.74,0.68,0.71,{"v":0.7,"d":"0.70"},0.72,0.71,{"v":0.7,"d":"0.70"},0.69,0.68,{"v":0.7,"d":"0.70"}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",0.74,0.57,0.19,0.75,0.61,0.15,{"v":-1.62,"d":"(1.62)"},{"v":-0.52,"d":"(0.52)"},0.22,0.23]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",4.06,5.09,4.13,4.69,3.89,2.12,0.59,1.82,2.73,2.31]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.32,1.96,1.49,{"v":1.5,"d":"1.50"},1.37,0.64,0.36,0.85,0.87,0.69]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",2.74,3.13,2.64,3.19,2.53,1.47,0.24,0.97,1.86,1.62]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",20.93,28.36,22.17,24.51,19.93,{"v":18.6,"d":"18.60"},5.47,17.35,{"v":25.1,"d":"25.10"},20.92]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",14.12,17.42,14.18,16.66,12.93,12.94,2.18,9.25,17.07,14.67]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",8.43,11.46,{"v":8.8,"d":"8.80"},{"v":9.9,"d":"9.90"},7.93,6.16,{"v":1.8,"d":"1.80"},5.53,8.31,6.94]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",5.68,7.04,5.63,6.73,5.14,4.29,0.71,2.95,5.65,4.87]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1.3,"d":"1.30"},1.32,1.31,1.28,1.27,1.08,1.09,1.09,1.12,1.17]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.22,0.26,0.27,0.23,0.21,0.29,0.29,{"v":0.3,"d":"0.30"},{"v":0.3,"d":"0.30"},0.32]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.53,1.55,{"v":1.5,"d":"1.50"},1.53,{"v":1.5,"d":"1.50"},{"v":1.2,"d":"1.20"},1.18,1.12,1.21,1.22]
["  1 These tables only include estimates for corporations with assets of $50 million and over at the time of sample selection."]

{"sheet":"RET_4_1-2012Q3","index":1,"n_rows":61,"n_cols":11,"rows_kept":61,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[49,1,49,4],[49,6,49,9],[60,0,60,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 4.1 -- Balance Sheet  For Corporations in NAICS Retail Trade Sector, and Retail Trade Subsector 445,\n                               Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"All Retail Trade\nTotal Assets $50 Million and Over",{"$nulls":4},"Food and Beverage Stores\nTotal Assets $50 Million and Over"]
["Item"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":52240,"d":"52,240 "},{"v":59564,"d":"59,564 "},{"v":68268,"d":"68,268 "},{"v":54044,"d":"54,044 "},{"v":53506,"d":"53,506 "},{"v":10181,"d":"10,181 "},{"v":10315,"d":"10,315 "},{"v":10228,"d":"10,228 "},{"v":10100,"d":"10,100 "},{"v":10514,"d":"10,514 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":3117,"d":"3,117 "},{"v":2914,"d":"2,914 "},{"v":2897,"d":"2,897 "},{"v":3476,"d":"3,476 "},{"v":1933,"d":"1,933 "},{"v":294,"d":"294 "},{"v":322,"d":"322 "},{"v":329,"d":"329 "},{"v":318,"d":"318 "},{"v":266,"d":"266 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":55357,"d":"55,357 "},{"v":62478,"d":"62,478 "},{"v":71165,"d":"71,165 "},{"v":57520,"d":"57,520 "},{"v":55438,"d":"55,438 "},{"v":10475,"d":"10,475 "},{"v":10637,"d":"10,637 "},{"v":10558,"d":"10,558 "},{"v":10418,"d":"10,418 "},{"v":10779,"d":"10,779 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":13364,"d":"13,364 "},{"v":18410,"d":"18,410 "},{"v":15087,"d":"15,087 "},{"v":14465,"d":"14,465 "},{"v":14614,"d":"14,614 "},{"v":1465,"d":"1,465 "},{"v":1445,"d":"1,445 "},{"v":1973,"d":"1,973 "},{"v":1768,"d":"1,768 "},{"v":2200,"d":"2,200 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":68721,"d":"68,721 "},{"v":80888,"d":"80,888 "},{"v":86252,"d":"86,252 "},{"v":71985,"d":"71,985 "},{"v":70053,"d":"70,053 "},{"v":11940,"d":"11,940 "},{"v":12082,"d":"12,082 "},{"v":12531,"d":"12,531 "},{"v":12186,"d":"12,186 "},{"v":12979,"d":"12,979 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":53398,"d":"53,398 "},{"v":58102,"d":"58,102 "},{"v":54458,"d":"54,458 "},{"v":53460,"d":"53,460 "},{"v":55477,"d":"55,477 "},{"v":5423,"d":"5,423 "},{"v":5603,"d":"5,603 "},{"v":5376,"d":"5,376 "},{"v":5664,"d":"5,664 "},{"v":5726,"d":"5,726 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":253175,"d":"253,175 "},{"v":235555,"d":"235,555 "},{"v":236536,"d":"236,536 "},{"v":238297,"d":"238,297 "},{"v":262520,"d":"262,520 "},{"v":23977,"d":"23,977 "},{"v":24149,"d":"24,149 "},{"v":23508,"d":"23,508 "},{"v":23559,"d":"23,559 "},{"v":24379,"d":"24,379 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":35674,"d":"35,674 "},{"v":36345,"d":"36,345 "},{"v":37445,"d":"37,445 "},{"v":37502,"d":"37,502 "},{"v":36862,"d":"36,862 "},{"v":3421,"d":"3,421 "},{"v":3808,"d":"3,808 "},{"v":4164,"d":"4,164 "},{"v":4195,"d":"4,195 "},{"v":4293,"d":"4,293 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":410968,"d":"410,968 "},{"v":410889,"d":"410,889 "},{"v":414691,"d":"414,691 "},{"v":401244,"d":"401,244 "},{"v":424911,"d":"424,911 "},{"v":44761,"d":"44,761 "},{"v":45642,"d":"45,642 "},{"v":45579,"d":"45,579 "},{"v":45605,"d":"45,605 "},{"v":47376,"d":"47,376 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":632184,"d":"632,184 "},{"v":638065,"d":"638,065 "},{"v":645631,"d":"645,631 "},{"v":655834,"d":"655,834 "},{"v":662312,"d":"662,312 "},{"v":135456,"d":"135,456 "},{"v":137176,"d":"137,176 "},{"v":138314,"d":"138,314 "},{"v":138995,"d":"138,995 "},{"v":139602,"d":"139,602 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":74163,"d":"74,163 "},{"v":74828,"d":"74,828 "},{"v":75192,"d":"75,192 "},{"v":76080,"d":"76,080 "},{"v":77455,"d":"77,455 "},{"v":10794,"d":"10,794 "},{"v":10688,"d":"10,688 "},{"v":10814,"d":"10,814 "},{"v":11153,"d":"11,153 "},{"v":11178,"d":"11,178 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":304831,"d":"304,831 "},{"v":309523,"d":"309,523 "},{"v":316197,"d":"316,197 "},{"v":322545,"d":"322,545 "},{"v":327456,"d":"327,456 "},{"v":70611,"d":"70,611 "},{"v":71972,"d":"71,972 "},{"v":73266,"d":"73,266 "},{"v":73333,"d":"73,333 "},{"v":74197,"d":"74,197 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":401515,"d":"401,515 "},{"v":403370,"d":"403,370 "},{"v":404625,"d":"404,625 "},{"v":409369,"d":"409,369 "},{"v":412310,"d":"412,310 "},{"v":75639,"d":"75,639 "},{"v":75892,"d":"75,892 "},{"v":75861,"d":"75,861 "},{"v":76815,"d":"76,815 "},{"v":76583,"d":"76,583 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":291414,"d":"291,414 "},{"v":295960,"d":"295,960 "},{"v":298514,"d":"298,514 "},{"v":330758,"d":"330,758 "},{"v":336829,"d":"336,829 "},{"v":22663,"d":"22,663 "},{"v":22527,"d":"22,527 "},{"v":22175,"d":"22,175 "},{"v":22178,"d":"22,178 "},{"v":22210,"d":"22,210 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1103897,"d":"1,103,897 "},{"v":1110220,"d":"1,110,220 "},{"v":1117830,"d":"1,117,830 "},{"v":1141371,"d":"1,141,371 "},{"v":1174050,"d":"1,174,050 "},{"v":143063,"d":"143,063 "},{"v":144062,"d":"144,062 "},{"v":143615,"d":"143,615 "},{"v":144598,"d":"144,598 "},{"v":146169,"d":"146,169 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":9883,"d":"9,883 "},{"v":11262,"d":"11,262 "},{"v":11415,"d":"11,415 "},{"v":12935,"d":"12,935 "},{"v":12639,"d":"12,639 "},{"v":378,"d":"378 "},{"v":530,"d":"530 "},{"v":383,"d":"383 "},{"v":331,"d":"331 "},{"v":315,"d":"315 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":17112,"d":"17,112 "},{"v":9811,"d":"9,811 "},{"v":10439,"d":"10,439 "},{"v":10557,"d":"10,557 "},{"v":13923,"d":"13,923 "},{"v":1081,"d":"1,081 "},{"v":1169,"d":"1,169 "},{"v":95,"d":"95 "},{"v":118,"d":"118 "},{"v":148,"d":"148 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":156296,"d":"156,296 "},{"v":151421,"d":"151,421 "},{"v":153099,"d":"153,099 "},{"v":153482,"d":"153,482 "},{"v":168474,"d":"168,474 "},{"v":19567,"d":"19,567 "},{"v":20267,"d":"20,267 "},{"v":20606,"d":"20,606 "},{"v":20639,"d":"20,639 "},{"v":21005,"d":"21,005 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":3376,"d":"3,376 "},{"v":5613,"d":"5,613 "},{"v":8847,"d":"8,847 "},{"v":5506,"d":"5,506 "},{"v":4055,"d":"4,055 "},{"v":481,"d":"481 "},{"v":686,"d":"686 "},{"v":1008,"d":"1,008 "},{"v":857,"d":"857 "},{"v":754,"d":"754 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4234,"d":"4,234 "},{"v":4096,"d":"4,096 "},{"v":4026,"d":"4,026 "},{"v":3963,"d":"3,963 "},{"v":4404,"d":"4,404 "},{"v":873,"d":"873 "},{"v":787,"d":"787 "},{"v":676,"d":"676 "},{"v":353,"d":"353 "},{"v":461,"d":"461 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15677,"d":"15,677 "},{"v":19121,"d":"19,121 "},{"v":16858,"d":"16,858 "},{"v":16503,"d":"16,503 "},{"v":18003,"d":"18,003 "},{"v":3516,"d":"3,516 "},{"v":3459,"d":"3,459 "},{"v":4060,"d":"4,060 "},{"v":2547,"d":"2,547 "},{"v":2010,"d":"2,010 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":108660,"d":"108,660 "},{"v":109470,"d":"109,470 "},{"v":111954,"d":"111,954 "},{"v":111187,"d":"111,187 "},{"v":112226,"d":"112,226 "},{"v":15743,"d":"15,743 "},{"v":15018,"d":"15,018 "},{"v":15050,"d":"15,050 "},{"v":15795,"d":"15,795 "},{"v":15851,"d":"15,851 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":315238,"d":"315,238 "},{"v":310793,"d":"310,793 "},{"v":316637,"d":"316,637 "},{"v":314132,"d":"314,132 "},{"v":333725,"d":"333,725 "},{"v":41638,"d":"41,638 "},{"v":41916,"d":"41,916 "},{"v":41878,"d":"41,878 "},{"v":40640,"d":"40,640 "},{"v":40543,"d":"40,543 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":59408,"d":"59,408 "},{"v":57874,"d":"57,874 "},{"v":57244,"d":"57,244 "},{"v":60718,"d":"60,718 "},{"v":60243,"d":"60,243 "},{"v":6329,"d":"6,329 "},{"v":6638,"d":"6,638 "},{"v":7268,"d":"7,268 "},{"v":7050,"d":"7,050 "},{"v":7658,"d":"7,658 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":183584,"d":"183,584 "},{"v":187954,"d":"187,954 "},{"v":195413,"d":"195,413 "},{"v":196003,"d":"196,003 "},{"v":202426,"d":"202,426 "},{"v":27205,"d":"27,205 "},{"v":27426,"d":"27,426 "},{"v":28508,"d":"28,508 "},{"v":29142,"d":"29,142 "},{"v":29089,"d":"29,089 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":101144,"d":"101,144 "},{"v":104947,"d":"104,947 "},{"v":104768,"d":"104,768 "},{"v":109522,"d":"109,522 "},{"v":110821,"d":"110,821 "},{"v":20480,"d":"20,480 "},{"v":20813,"d":"20,813 "},{"v":20196,"d":"20,196 "},{"v":19876,"d":"19,876 "},{"v":20390,"d":"20,390 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":659375,"d":"659,375 "},{"v":661568,"d":"661,568 "},{"v":674063,"d":"674,063 "},{"v":680376,"d":"680,376 "},{"v":707216,"d":"707,216 "},{"v":95653,"d":"95,653 "},{"v":96794,"d":"96,794 "},{"v":97849,"d":"97,849 "},{"v":96707,"d":"96,707 "},{"v":97682,"d":"97,682 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":92943,"d":"92,943 "},{"v":89988,"d":"89,988 "},{"v":84919,"d":"84,919 "},{"v":104721,"d":"104,721 "},{"v":104825,"d":"104,825 "},{"v":13110,"d":"13,110 "},{"v":13458,"d":"13,458 "},{"v":11308,"d":"11,308 "},{"v":9600,"d":"9,600 "},{"v":9378,"d":"9,378 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":351579,"d":"351,579 "},{"v":358664,"d":"358,664 "},{"v":358848,"d":"358,848 "},{"v":356274,"d":"356,274 "},{"v":362009,"d":"362,009 "},{"v":34300,"d":"34,300 "},{"v":33810,"d":"33,810 "},{"v":34458,"d":"34,458 "},{"v":38290,"d":"38,290 "},{"v":39109,"d":"39,109 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":444522,"d":"444,522 "},{"v":448652,"d":"448,652 "},{"v":443767,"d":"443,767 "},{"v":460995,"d":"460,995 "},{"v":466834,"d":"466,834 "},{"v":47410,"d":"47,410 "},{"v":47268,"d":"47,268 "},{"v":45766,"d":"45,766 "},{"v":47891,"d":"47,891 "},{"v":48487,"d":"48,487 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1103897,"d":"1,103,897 "},{"v":1110220,"d":"1,110,220 "},{"v":1117830,"d":"1,117,830 "},{"v":1141371,"d":"1,141,371 "},{"v":1174050,"d":"1,174,050 "},{"v":143063,"d":"143,063 "},{"v":144062,"d":"144,062 "},{"v":143615,"d":"143,615 "},{"v":144598,"d":"144,598 "},{"v":146169,"d":"146,169 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":95729,"d":"95,729 "},{"v":100096,"d":"100,096 "},{"v":98053,"d":"98,053 "},{"v":87112,"d":"87,112 "},{"v":91186,"d":"91,186 "},{"v":3123,"d":"3,123 "},{"v":3726,"d":"3,726 "},{"v":3701,"d":"3,701 "},{"v":4965,"d":"4,965 "},{"v":6833,"d":"6,833 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",6.23,7.29,7.72,6.31,5.97,8.35,8.39,8.73,8.43,8.88]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",4.84,5.23,4.87,4.68,4.73,3.79,3.89,3.74,3.92,3.92]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.93,21.22,21.16,20.88,22.36,16.76,16.76,16.37,16.29,16.68]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",37.23,37.01,{"v":37.1,"d":"37.10"},35.15,36.19,31.29,31.68,31.74,31.54,32.41]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",36.37,36.33,{"v":36.2,"d":"36.20"},35.87,35.12,52.87,52.68,52.82,53.12,52.39]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",4.25,3.99,3.82,3.85,4.17,4.09,4.13,3.63,2.32,2.01]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",28.56,27.99,28.33,27.52,28.43,{"v":29.1,"d":"29.10"},{"v":29.1,"d":"29.10"},29.16,28.11,27.74]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.01,22.14,{"v":22.6,"d":"22.60"},22.49,22.37,23.44,23.65,24.91,25.03,25.14]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",59.73,59.59,{"v":60.3,"d":"60.30"},59.61,60.24,66.86,67.19,68.13,66.88,66.83]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",40.27,40.41,{"v":39.7,"d":"39.70"},40.39,39.76,33.14,32.81,31.87,33.12,33.17]
["  1 These tables only include estimates for corporations with assets of $50 million and over at the time of sample selection."]

{"sheet":"RET_5_0-2012Q3","index":2,"n_rows":47,"n_cols":11,"rows_kept":47,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[22,1,22,4],[22,6,22,9],[33,1,33,4],[33,6,33,9],[46,0,46,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 5.0 -- Income Statement  For Corporations in NAICS Retail Trade Subsectors 448 and 452, and\n                               All Other Retail Trade Subsectors, Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"Clothing and General Merchandise Stores\nTotal Assets $50 Million and Over",{"$nulls":4},"All Other Retail Trade\nTotal Assets $50 Million and Over"]
["Item"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":190381,"d":"190,381 "},{"v":228012,"d":"228,012 "},{"v":199021,"d":"199,021 "},{"v":199511,"d":"199,511 "},{"v":199907,"d":"199,907 "},{"v":277791,"d":"277,791 "},{"v":288001,"d":"288,001 "},{"v":288438,"d":"288,438 "},{"v":292344,"d":"292,344 "},{"v":287694,"d":"287,694 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":4477,"d":"4,477 "},{"v":4572,"d":"4,572 "},{"v":4542,"d":"4,542 "},{"v":4704,"d":"4,704 "},{"v":4697,"d":"4,697 "},{"v":4227,"d":"4,227 "},{"v":4223,"d":"4,223 "},{"v":4248,"d":"4,248 "},{"v":4348,"d":"4,348 "},{"v":4438,"d":"4,438 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":177229,"d":"177,229 "},{"v":207429,"d":"207,429 "},{"v":183221,"d":"183,221 "},{"v":184081,"d":"184,081 "},{"v":186241,"d":"186,241 "},{"v":261770,"d":"261,770 "},{"v":270498,"d":"270,498 "},{"v":271082,"d":"271,082 "},{"v":274261,"d":"274,261 "},{"v":271343,"d":"271,343 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":8674,"d":"8,674 "},{"v":16011,"d":"16,011 "},{"v":11259,"d":"11,259 "},{"v":10726,"d":"10,726 "},{"v":8969,"d":"8,969 "},{"v":11795,"d":"11,795 "},{"v":13280,"d":"13,280 "},{"v":13108,"d":"13,108 "},{"v":13735,"d":"13,735 "},{"v":11913,"d":"11,913 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1522,"d":"1,522 "},{"v":1441,"d":"1,441 "},{"v":1512,"d":"1,512 "},{"v":1517,"d":"1,517 "},{"v":1529,"d":"1,529 "},{"v":1988,"d":"1,988 "},{"v":2028,"d":"2,028 "},{"v":1956,"d":"1,956 "},{"v":1969,"d":"1,969 "},{"v":2008,"d":"2,008 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":2532,"d":"2,532 "},{"v":2150,"d":"2,150 "},{"v":2988,"d":"2,988 "},{"v":2834,"d":"2,834 "},{"v":3712,"d":"3,712 "},{"v":1564,"d":"1,564 "},{"v":3192,"d":"3,192 "},{"v":-1275,"d":"(1,275)"},{"v":1432,"d":"1,432 "},{"v":-329,"d":"(329)"}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":9685,"d":"9,685 "},{"v":16720,"d":"16,720 "},{"v":12735,"d":"12,735 "},{"v":12043,"d":"12,043 "},{"v":11151,"d":"11,151 "},{"v":11371,"d":"11,371 "},{"v":14444,"d":"14,444 "},{"v":9878,"d":"9,878 "},{"v":13198,"d":"13,198 "},{"v":9576,"d":"9,576 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":3218,"d":"3,218 "},{"v":7390,"d":"7,390 "},{"v":4043,"d":"4,043 "},{"v":3911,"d":"3,911 "},{"v":3614,"d":"3,614 "},{"v":3683,"d":"3,683 "},{"v":4490,"d":"4,490 "},{"v":3891,"d":"3,891 "},{"v":4171,"d":"4,171 "},{"v":3801,"d":"3,801 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":6466,"d":"6,466 "},{"v":9330,"d":"9,330 "},{"v":8693,"d":"8,693 "},{"v":8132,"d":"8,132 "},{"v":7538,"d":"7,538 "},{"v":7688,"d":"7,688 "},{"v":9955,"d":"9,955 "},{"v":5986,"d":"5,986 "},{"v":9027,"d":"9,027 "},{"v":5775,"d":"5,775 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":1148,"d":"1,148 "},{"v":1857,"d":"1,857 "},{"v":6699,"d":"6,699 "},{"v":961,"d":"961 "},{"v":3473,"d":"3,473 "},{"v":1701,"d":"1,701 "},{"v":1962,"d":"1,962 "},{"v":1891,"d":"1,891 "},{"v":2459,"d":"2,459 "},{"v":2004,"d":"2,004 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5319,"d":"5,319 "},{"v":7473,"d":"7,473 "},{"v":1994,"d":"1,994 "},{"v":7171,"d":"7,171 "},{"v":4064,"d":"4,064 "},{"v":5987,"d":"5,987 "},{"v":7993,"d":"7,993 "},{"v":4095,"d":"4,095 "},{"v":6568,"d":"6,568 "},{"v":3771,"d":"3,771 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":152660,"d":"152,660 "},{"v":154675,"d":"154,675 "},{"v":156146,"d":"156,146 "},{"v":155890,"d":"155,890 "},{"v":160276,"d":"160,276 "},{"v":157261,"d":"157,261 "},{"v":161394,"d":"161,394 "},{"v":169806,"d":"169,806 "},{"v":159744,"d":"159,744 "},{"v":157657,"d":"157,657 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-3021,"d":"(3,021)"},{"v":-5783,"d":"(5,783)"},{"v":-2323,"d":"(2,323)"},{"v":-3557,"d":"(3,557)"},{"v":-1205,"d":"(1,205)"},{"v":-927,"d":"(927)"},{"v":-898,"d":"(898)"},{"v":-5326,"d":"(5,326)"},{"v":-7832,"d":"(7,832)"},{"v":-1663,"d":"(1,663)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":154958,"d":"154,958 "},{"v":156365,"d":"156,365 "},{"v":155816,"d":"155,816 "},{"v":159504,"d":"159,504 "},{"v":163135,"d":"163,135 "},{"v":162321,"d":"162,321 "},{"v":168489,"d":"168,489 "},{"v":168575,"d":"168,575 "},{"v":158480,"d":"158,480 "},{"v":159765,"d":"159,765 "}]
["                         INCOME STATEMENT IN RATIO FORMAT","(percent of net sales)",{"$nulls":4},"(percent of net sales)"]
["     Net sales, receipts, and operating revenues ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment ………………………………………………………………………………………………………………………………………………………………………",2.35,{"v":2,"d":"2.00"},2.28,2.36,2.35,1.52,1.47,1.47,1.49,1.54]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",93.09,90.97,92.06,92.27,93.16,94.23,93.92,93.98,93.81,94.32]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",4.56,7.02,5.66,5.38,4.49,4.25,4.61,4.54,{"v":4.7,"d":"4.70"},4.14]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":0.8,"d":"0.80"},0.63,0.76,0.76,0.76,0.72,{"v":0.7,"d":"0.70"},0.68,0.67,{"v":0.7,"d":"0.70"}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",1.33,0.94,{"v":1.5,"d":"1.50"},1.42,1.86,0.56,1.11,{"v":-0.44,"d":"(0.44)"},0.49,{"v":-0.11,"d":"(0.11)"}]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",5.09,7.33,{"v":6.4,"d":"6.40"},6.04,5.58,4.09,5.02,3.42,4.51,3.33]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.69,3.24,2.03,1.96,1.81,1.33,1.56,1.35,1.43,1.32]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":3.4,"d":"3.40"},4.09,4.37,4.08,3.77,2.77,3.46,2.08,3.09,2.01]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",21.32,36.42,28.02,26.41,24.09,21.12,26.54,18.28,22.88,16.42]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",14.23,20.32,19.12,17.83,16.29,14.28,18.29,11.08,15.65,9.91]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",8.68,{"v":15.3,"d":"15.30"},11.54,10.91,9.75,8.84,10.92,7.42,9.51,6.72]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5.8,"d":"5.80"},8.54,7.87,7.37,6.59,5.97,7.53,{"v":4.5,"d":"4.50"},{"v":6.5,"d":"6.50"},4.05]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1.3,"d":"1.30"},1.31,1.25,1.25,1.23,1.37,{"v":1.4,"d":"1.40"},1.41,1.34,1.34]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.19,0.25,0.24,0.21,0.17,0.22,0.26,0.29,0.22,0.21]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.54,1.63,1.62,{"v":1.6,"d":"1.60"},1.56,1.62,1.58,1.52,1.57,1.52]
["  1 These tables only include estimates for corporations with assets of $50 million and over at the time of sample selection."]

{"sheet":"RET_5_1-2012Q3","index":3,"n_rows":61,"n_cols":11,"rows_kept":61,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[49,1,49,4],[49,6,49,9],[60,0,60,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 5.1 -- Balance Sheet  For Corporations in NAICS Retail Trade Subsectors 448 and 452, and\n                               All Other Retail Trade Subsectors, Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"Clothing and General Merchandise Stores\nTotal Assets $50 Million and Over",{"$nulls":4},"All Other Retail Trade\nTotal Assets $50 Million and Over"]
["Item"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":19334,"d":"19,334 "},{"v":20949,"d":"20,949 "},{"v":22615,"d":"22,615 "},{"v":19368,"d":"19,368 "},{"v":17170,"d":"17,170 "},{"v":22725,"d":"22,725 "},{"v":28300,"d":"28,300 "},{"v":35425,"d":"35,425 "},{"v":24576,"d":"24,576 "},{"v":25822,"d":"25,822 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":510,"d":"510 "},{"v":484,"d":"484 "},{"v":438,"d":"438 "},{"v":430,"d":"430 "},{"v":412,"d":"412 "},{"v":2313,"d":"2,313 "},{"v":2107,"d":"2,107 "},{"v":2130,"d":"2,130 "},{"v":2728,"d":"2,728 "},{"v":1255,"d":"1,255 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":19845,"d":"19,845 "},{"v":21434,"d":"21,434 "},{"v":23053,"d":"23,053 "},{"v":19798,"d":"19,798 "},{"v":17582,"d":"17,582 "},{"v":25038,"d":"25,038 "},{"v":30407,"d":"30,407 "},{"v":37555,"d":"37,555 "},{"v":27304,"d":"27,304 "},{"v":27077,"d":"27,077 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4163,"d":"4,163 "},{"v":6872,"d":"6,872 "},{"v":5708,"d":"5,708 "},{"v":6060,"d":"6,060 "},{"v":5765,"d":"5,765 "},{"v":7735,"d":"7,735 "},{"v":10092,"d":"10,092 "},{"v":7406,"d":"7,406 "},{"v":6637,"d":"6,637 "},{"v":6650,"d":"6,650 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":24007,"d":"24,007 "},{"v":28306,"d":"28,306 "},{"v":28761,"d":"28,761 "},{"v":25858,"d":"25,858 "},{"v":23347,"d":"23,347 "},{"v":32773,"d":"32,773 "},{"v":40499,"d":"40,499 "},{"v":44960,"d":"44,960 "},{"v":33941,"d":"33,941 "},{"v":33727,"d":"33,727 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":7554,"d":"7,554 "},{"v":7271,"d":"7,271 "},{"v":6923,"d":"6,923 "},{"v":6729,"d":"6,729 "},{"v":7045,"d":"7,045 "},{"v":40421,"d":"40,421 "},{"v":45228,"d":"45,228 "},{"v":42159,"d":"42,159 "},{"v":41066,"d":"41,066 "},{"v":42706,"d":"42,706 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":117255,"d":"117,255 "},{"v":99137,"d":"99,137 "},{"v":101302,"d":"101,302 "},{"v":102324,"d":"102,324 "},{"v":120162,"d":"120,162 "},{"v":111943,"d":"111,943 "},{"v":112269,"d":"112,269 "},{"v":111727,"d":"111,727 "},{"v":112414,"d":"112,414 "},{"v":117979,"d":"117,979 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15862,"d":"15,862 "},{"v":15309,"d":"15,309 "},{"v":15185,"d":"15,185 "},{"v":15466,"d":"15,466 "},{"v":14533,"d":"14,533 "},{"v":16391,"d":"16,391 "},{"v":17228,"d":"17,228 "},{"v":18095,"d":"18,095 "},{"v":17840,"d":"17,840 "},{"v":18037,"d":"18,037 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":164678,"d":"164,678 "},{"v":150023,"d":"150,023 "},{"v":152171,"d":"152,171 "},{"v":150378,"d":"150,378 "},{"v":165086,"d":"165,086 "},{"v":201528,"d":"201,528 "},{"v":215224,"d":"215,224 "},{"v":216941,"d":"216,941 "},{"v":205261,"d":"205,261 "},{"v":212448,"d":"212,448 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":267888,"d":"267,888 "},{"v":270206,"d":"270,206 "},{"v":273383,"d":"273,383 "},{"v":277277,"d":"277,277 "},{"v":280316,"d":"280,316 "},{"v":228839,"d":"228,839 "},{"v":230682,"d":"230,682 "},{"v":233934,"d":"233,934 "},{"v":239561,"d":"239,561 "},{"v":242394,"d":"242,394 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":29495,"d":"29,495 "},{"v":30068,"d":"30,068 "},{"v":30314,"d":"30,314 "},{"v":30522,"d":"30,522 "},{"v":31367,"d":"31,367 "},{"v":33874,"d":"33,874 "},{"v":34072,"d":"34,072 "},{"v":34064,"d":"34,064 "},{"v":34404,"d":"34,404 "},{"v":34909,"d":"34,909 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":119512,"d":"119,512 "},{"v":121364,"d":"121,364 "},{"v":124114,"d":"124,114 "},{"v":126799,"d":"126,799 "},{"v":129370,"d":"129,370 "},{"v":114708,"d":"114,708 "},{"v":116187,"d":"116,187 "},{"v":118817,"d":"118,817 "},{"v":122413,"d":"122,413 "},{"v":123889,"d":"123,889 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":177872,"d":"177,872 "},{"v":178910,"d":"178,910 "},{"v":179583,"d":"179,583 "},{"v":181001,"d":"181,001 "},{"v":182313,"d":"182,313 "},{"v":148005,"d":"148,005 "},{"v":148567,"d":"148,567 "},{"v":149182,"d":"149,182 "},{"v":151553,"d":"151,553 "},{"v":153415,"d":"153,415 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":103536,"d":"103,536 "},{"v":108248,"d":"108,248 "},{"v":109820,"d":"109,820 "},{"v":110147,"d":"110,147 "},{"v":110205,"d":"110,205 "},{"v":165215,"d":"165,215 "},{"v":165185,"d":"165,185 "},{"v":166518,"d":"166,518 "},{"v":198434,"d":"198,434 "},{"v":204414,"d":"204,414 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":446085,"d":"446,085 "},{"v":437181,"d":"437,181 "},{"v":441574,"d":"441,574 "},{"v":441526,"d":"441,526 "},{"v":457604,"d":"457,604 "},{"v":514748,"d":"514,748 "},{"v":528977,"d":"528,977 "},{"v":532641,"d":"532,641 "},{"v":555248,"d":"555,248 "},{"v":570277,"d":"570,277 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":892,"d":"892 "},{"v":678,"d":"678 "},{"v":805,"d":"805 "},{"v":1042,"d":"1,042 "},{"v":1234,"d":"1,234 "},{"v":8613,"d":"8,613 "},{"v":10053,"d":"10,053 "},{"v":10227,"d":"10,227 "},{"v":11561,"d":"11,561 "},{"v":11091,"d":"11,091 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":12464,"d":"12,464 "},{"v":4958,"d":"4,958 "},{"v":7020,"d":"7,020 "},{"v":6819,"d":"6,819 "},{"v":10095,"d":"10,095 "},{"v":3567,"d":"3,567 "},{"v":3684,"d":"3,684 "},{"v":3324,"d":"3,324 "},{"v":3620,"d":"3,620 "},{"v":3680,"d":"3,680 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":64928,"d":"64,928 "},{"v":54481,"d":"54,481 "},{"v":57814,"d":"57,814 "},{"v":57397,"d":"57,397 "},{"v":67088,"d":"67,088 "},{"v":71802,"d":"71,802 "},{"v":76673,"d":"76,673 "},{"v":74679,"d":"74,679 "},{"v":75446,"d":"75,446 "},{"v":80382,"d":"80,382 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":561,"d":"561 "},{"v":2688,"d":"2,688 "},{"v":4095,"d":"4,095 "},{"v":2046,"d":"2,046 "},{"v":1639,"d":"1,639 "},{"v":2335,"d":"2,335 "},{"v":2239,"d":"2,239 "},{"v":3744,"d":"3,744 "},{"v":2603,"d":"2,603 "},{"v":1662,"d":"1,662 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":340,"d":"340 "},{"v":280,"d":"280 "},{"v":262,"d":"262 "},{"v":238,"d":"238 "},{"v":256,"d":"256 "},{"v":3021,"d":"3,021 "},{"v":3030,"d":"3,030 "},{"v":3088,"d":"3,088 "},{"v":3372,"d":"3,372 "},{"v":3687,"d":"3,687 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4654,"d":"4,654 "},{"v":8345,"d":"8,345 "},{"v":6619,"d":"6,619 "},{"v":8179,"d":"8,179 "},{"v":9268,"d":"9,268 "},{"v":7507,"d":"7,507 "},{"v":7317,"d":"7,317 "},{"v":6179,"d":"6,179 "},{"v":5777,"d":"5,777 "},{"v":6725,"d":"6,725 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":42679,"d":"42,679 "},{"v":43467,"d":"43,467 "},{"v":44667,"d":"44,667 "},{"v":44777,"d":"44,777 "},{"v":44810,"d":"44,810 "},{"v":50238,"d":"50,238 "},{"v":50985,"d":"50,985 "},{"v":52237,"d":"52,237 "},{"v":50615,"d":"50,615 "},{"v":51566,"d":"51,566 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":126518,"d":"126,518 "},{"v":114896,"d":"114,896 "},{"v":121281,"d":"121,281 "},{"v":120497,"d":"120,497 "},{"v":134390,"d":"134,390 "},{"v":147083,"d":"147,083 "},{"v":153981,"d":"153,981 "},{"v":153478,"d":"153,478 "},{"v":152995,"d":"152,995 "},{"v":158792,"d":"158,792 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15673,"d":"15,673 "},{"v":14843,"d":"14,843 "},{"v":13955,"d":"13,955 "},{"v":14423,"d":"14,423 "},{"v":15405,"d":"15,405 "},{"v":37405,"d":"37,405 "},{"v":36392,"d":"36,392 "},{"v":36021,"d":"36,021 "},{"v":39245,"d":"39,245 "},{"v":37180,"d":"37,180 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":83722,"d":"83,722 "},{"v":83574,"d":"83,574 "},{"v":83776,"d":"83,776 "},{"v":83306,"d":"83,306 "},{"v":82317,"d":"82,317 "},{"v":72657,"d":"72,657 "},{"v":76953,"d":"76,953 "},{"v":83129,"d":"83,129 "},{"v":83556,"d":"83,556 "},{"v":91020,"d":"91,020 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":38435,"d":"38,435 "},{"v":40221,"d":"40,221 "},{"v":40727,"d":"40,727 "},{"v":40913,"d":"40,913 "},{"v":40349,"d":"40,349 "},{"v":42229,"d":"42,229 "},{"v":43913,"d":"43,913 "},{"v":43845,"d":"43,845 "},{"v":48733,"d":"48,733 "},{"v":50082,"d":"50,082 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":264348,"d":"264,348 "},{"v":253534,"d":"253,534 "},{"v":259740,"d":"259,740 "},{"v":259140,"d":"259,140 "},{"v":272460,"d":"272,460 "},{"v":299374,"d":"299,374 "},{"v":311239,"d":"311,239 "},{"v":316473,"d":"316,473 "},{"v":324529,"d":"324,529 "},{"v":337074,"d":"337,074 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":26780,"d":"26,780 "},{"v":27282,"d":"27,282 "},{"v":26018,"d":"26,018 "},{"v":22882,"d":"22,882 "},{"v":22008,"d":"22,008 "},{"v":53053,"d":"53,053 "},{"v":49249,"d":"49,249 "},{"v":47593,"d":"47,593 "},{"v":72239,"d":"72,239 "},{"v":73438,"d":"73,438 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":154958,"d":"154,958 "},{"v":156365,"d":"156,365 "},{"v":155816,"d":"155,816 "},{"v":159504,"d":"159,504 "},{"v":163135,"d":"163,135 "},{"v":162321,"d":"162,321 "},{"v":168489,"d":"168,489 "},{"v":168575,"d":"168,575 "},{"v":158480,"d":"158,480 "},{"v":159765,"d":"159,765 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":181738,"d":"181,738 "},{"v":183647,"d":"183,647 "},{"v":181833,"d":"181,833 "},{"v":182386,"d":"182,386 "},{"v":185144,"d":"185,144 "},{"v":215374,"d":"215,374 "},{"v":217737,"d":"217,737 "},{"v":216167,"d":"216,167 "},{"v":230718,"d":"230,718 "},{"v":233203,"d":"233,203 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":446085,"d":"446,085 "},{"v":437181,"d":"437,181 "},{"v":441574,"d":"441,574 "},{"v":441526,"d":"441,526 "},{"v":457604,"d":"457,604 "},{"v":514748,"d":"514,748 "},{"v":528977,"d":"528,977 "},{"v":532641,"d":"532,641 "},{"v":555248,"d":"555,248 "},{"v":570277,"d":"570,277 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":38161,"d":"38,161 "},{"v":35127,"d":"35,127 "},{"v":30889,"d":"30,889 "},{"v":29880,"d":"29,880 "},{"v":30696,"d":"30,696 "},{"v":54446,"d":"54,446 "},{"v":61243,"d":"61,243 "},{"v":63463,"d":"63,463 "},{"v":52266,"d":"52,266 "},{"v":53656,"d":"53,656 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",5.38,6.47,6.51,5.86,{"v":5.1,"d":"5.10"},6.37,7.66,8.44,6.11,5.91]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",1.69,1.66,1.57,1.52,1.54,7.85,8.55,7.92,{"v":7.4,"d":"7.40"},7.49]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",26.29,22.68,22.94,23.18,26.26,21.75,21.22,20.98,20.25,20.69]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",36.92,34.32,34.46,34.06,36.08,39.15,40.69,40.73,36.97,37.25]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",39.87,40.92,40.67,40.99,39.84,28.75,28.09,28.01,27.29,{"v":26.9,"d":"26.90"}]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",4.11,3.26,3.33,3.69,4.56,4.41,4.55,4.28,4.38,4.42]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",28.36,26.28,27.47,27.29,29.37,28.57,29.11,28.81,27.55,27.84]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.28,22.51,22.13,22.13,21.36,21.38,21.43,22.37,22.12,22.48]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",59.26,57.99,58.82,58.69,59.54,58.16,58.84,59.42,58.45,59.11]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",40.74,42.01,41.18,41.31,40.46,41.84,41.16,40.58,41.55,40.89]
["  1 These tables only include estimates for corporations with assets of $50 million and over at the time of sample selection."]

{"sheet":"RET_6_0-2012Q3","index":4,"n_rows":23,"n_cols":5,"rows_kept":23,"merged":[[1,0,1,10],[2,0,2,4],[3,0,4,0],[3,1,3,4],[5,1,5,4]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 6.0 -- Seasonally Adjusted Sales  For Corporations in NAICS Retail Trade Subsectors 448 and 452, and\n                               All Other Retail Trade Subsectors, Total Assets $50 Million and Over 1,2"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
["Industry group and year","Sales"]
[null,"Q1","Q2","Q3","Q4"]
[null,"(million dollars)"]
["All retail"]
["2001 …………………………………………………………………………………………...………………………………………………..",{"v":330909,"d":"330,909 "},{"v":336728,"d":"336,728 "},{"v":339868,"d":"339,868 "},{"v":347719,"d":"347,719 "}]
["2002 …………………………………………………………………………………………...………………………………………………..",{"v":349164,"d":"349,164 "},{"v":354926,"d":"354,926 "},{"v":359690,"d":"359,690 "},{"v":357327,"d":"357,327 "}]
["2003 …………………………………………………………………………………………...………………………………………………..",{"v":366814,"d":"366,814 "},{"v":369645,"d":"369,645 "},{"v":391678,"d":"391,678 "},{"v":398992,"d":"398,992 "}]
["2004 …………………………………………………………………………………………...………………………………………………..",{"v":406901,"d":"406,901 "},{"v":410258,"d":"410,258 "},{"v":421924,"d":"421,924 "},{"v":427325,"d":"427,325 "}]
["2005 …………………………………………………………………………………………...………………………………………………..",{"v":438278,"d":"438,278 "},{"v":447284,"d":"447,284 "},{"v":458832,"d":"458,832 "},{"v":467747,"d":"467,747 "}]
["2006 …………………………………………………………………………………………...………………………………………………..",{"v":480397,"d":"480,397 "},{"v":492633,"d":"492,633 "},{"v":498005,"d":"498,005 "},{"v":501946,"d":"501,946 "}]
["2007 …………………………………………………………………………………………...………………………………………………..",{"v":509656,"d":"509,656 "},{"v":514638,"d":"514,638 "},{"v":516339,"d":"516,339 "},{"v":521266,"d":"521,266 "}]
["2008 …………………………………………………………………………………………...………………………………………………..",{"v":522811,"d":"522,811 "},{"v":536326,"d":"536,326 "},{"v":531728,"d":"531,728 "},{"v":501505,"d":"501,505 "}]
["2009 …………………………………………………………………………………………...………………………………………………..",{"v":495036,"d":"495,036 "},{"v":495222,"d":"495,222 "},{"v":508741,"d":"508,741 "},{"v":520835,"d":"520,835 "}]
["2010 …………………………………………………………………………………………...………………………………………………..",{"v":530821,"d":"530,821 "},{"v":534736,"d":"534,736 "},{"v":540036,"d":"540,036 "},{"v":552128,"d":"552,128 "}]
["2011 …………………………………………………………………………………………...………………………………………………..",{"v":565261,"d":"565,261 "},{"v":585226,"d":"585,226 "},{"v":586758,"d":"586,758 "},{"v":595142,"d":"595,142 "}]
["2012 …………………………………………………………………………………………...………………………………………………..",{"v":607422,"d":"607,422 "},{"v":606135,"d":"606,135 "},{"v":611908,"d":"611,908 "}]
[]
["1 This table only includes estimates for corporations with assets of $50 million and over at the time of sample selection."]
["2 For information on adjustment for seasonal variation, see the Introduction, Survey Methodology section, in the Quarterly Financial Report for Manufacturing, Mining, Trade, "]
["and Selected Service Industries, or at the QFR internet website http://www.census.gov/econ/qfr/collection.html."]