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

{"sheet":"RET_4_0-2012Q2","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"," 2Q_\n 2011_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 2Q_\n 2011_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":580937,"d":"580,937 "},{"v":573855,"d":"573,855 "},{"v":626271,"d":"626,271 "},{"v":597349,"d":"597,349 "},{"v":603290,"d":"603,290 "},{"v":107478,"d":"107,478 "},{"v":104228,"d":"104,228 "},{"v":108870,"d":"108,870 "},{"v":108821,"d":"108,821 "},{"v":109990,"d":"109,990 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":10925,"d":"10,925 "},{"v":10888,"d":"10,888 "},{"v":11054,"d":"11,054 "},{"v":10863,"d":"10,863 "},{"v":11287,"d":"11,287 "},{"v":2184,"d":"2,184 "},{"v":2160,"d":"2,160 "},{"v":2225,"d":"2,225 "},{"v":2048,"d":"2,048 "},{"v":2241,"d":"2,241 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":543312,"d":"543,312 "},{"v":539523,"d":"539,523 "},{"v":582653,"d":"582,653 "},{"v":558745,"d":"558,745 "},{"v":563922,"d":"563,922 "},{"v":102029,"d":"102,029 "},{"v":99279,"d":"99,279 "},{"v":103478,"d":"103,478 "},{"v":103440,"d":"103,440 "},{"v":104230,"d":"104,230 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":26700,"d":"26,700 "},{"v":23443,"d":"23,443 "},{"v":32564,"d":"32,564 "},{"v":27741,"d":"27,741 "},{"v":28081,"d":"28,081 "},{"v":3264,"d":"3,264 "},{"v":2789,"d":"2,789 "},{"v":3167,"d":"3,167 "},{"v":3333,"d":"3,333 "},{"v":3518,"d":"3,518 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4367,"d":"4,367 "},{"v":4269,"d":"4,269 "},{"v":4252,"d":"4,252 "},{"v":4247,"d":"4,247 "},{"v":4249,"d":"4,249 "},{"v":747,"d":"747 "},{"v":738,"d":"738 "},{"v":757,"d":"757 "},{"v":755,"d":"755 "},{"v":741,"d":"741 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":3805,"d":"3,805 "},{"v":4272,"d":"4,272 "},{"v":3583,"d":"3,583 "},{"v":1200,"d":"1,200 "},{"v":4579,"d":"4,579 "},{"v":233,"d":"233 "},{"v":153,"d":"153 "},{"v":-1763,"d":"(1,763)"},{"v":-569,"d":"(569)"},{"v":233,"d":"233 "}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":26138,"d":"26,138 "},{"v":23446,"d":"23,446 "},{"v":31894,"d":"31,894 "},{"v":24693,"d":"24,693 "},{"v":28412,"d":"28,412 "},{"v":2751,"d":"2,751 "},{"v":2205,"d":"2,205 "},{"v":647,"d":"647 "},{"v":2009,"d":"2,009 "},{"v":3011,"d":"3,011 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":8543,"d":"8,543 "},{"v":7639,"d":"7,639 "},{"v":12265,"d":"12,265 "},{"v":8909,"d":"8,909 "},{"v":9097,"d":"9,097 "},{"v":907,"d":"907 "},{"v":671,"d":"671 "},{"v":389,"d":"389 "},{"v":936,"d":"936 "},{"v":962,"d":"962 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":17595,"d":"17,595 "},{"v":15808,"d":"15,808 "},{"v":19629,"d":"19,629 "},{"v":15784,"d":"15,784 "},{"v":19314,"d":"19,314 "},{"v":1844,"d":"1,844 "},{"v":1533,"d":"1,533 "},{"v":257,"d":"257 "},{"v":1073,"d":"1,073 "},{"v":2049,"d":"2,049 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":4657,"d":"4,657 "},{"v":3150,"d":"3,150 "},{"v":4241,"d":"4,241 "},{"v":9355,"d":"9,355 "},{"v":3466,"d":"3,466 "},{"v":1535,"d":"1,535 "},{"v":299,"d":"299 "},{"v":444,"d":"444 "},{"v":791,"d":"791 "},{"v":501,"d":"501 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":12938,"d":"12,938 "},{"v":12657,"d":"12,657 "},{"v":15388,"d":"15,388 "},{"v":6429,"d":"6,429 "},{"v":15849,"d":"15,849 "},{"v":309,"d":"309 "},{"v":1235,"d":"1,235 "},{"v":-187,"d":"(187)"},{"v":283,"d":"283 "},{"v":1548,"d":"1,548 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":334752,"d":"334,752 "},{"v":344403,"d":"344,403 "},{"v":351665,"d":"351,665 "},{"v":359471,"d":"359,471 "},{"v":352744,"d":"352,744 "},{"v":32826,"d":"32,826 "},{"v":33387,"d":"33,387 "},{"v":34408,"d":"34,408 "},{"v":33806,"d":"33,806 "},{"v":37002,"d":"37,002 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-5714,"d":"(5,714)"},{"v":-4274,"d":"(4,274)"},{"v":-7112,"d":"(7,112)"},{"v":-7312,"d":"(7,312)"},{"v":-11584,"d":"(11,584)"},{"v":-195,"d":"(195)"},{"v":-321,"d":"(321)"},{"v":-411,"d":"(411)"},{"v":367,"d":"367 "},{"v":-104,"d":"(104)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":341976,"d":"341,976 "},{"v":352787,"d":"352,787 "},{"v":359941,"d":"359,941 "},{"v":358588,"d":"358,588 "},{"v":357008,"d":"357,008 "},{"v":32940,"d":"32,940 "},{"v":34300,"d":"34,300 "},{"v":33810,"d":"33,810 "},{"v":34456,"d":"34,456 "},{"v":38446,"d":"38,446 "}]
["                         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 ………………………………………………………………………………………………………………………………………………………………………",1.88,{"v":1.9,"d":"1.90"},1.77,1.82,1.87,2.03,2.07,2.04,1.88,2.04]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",93.52,94.02,93.04,93.54,93.47,94.93,95.25,95.05,95.06,94.76]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4.6,"d":"4.60"},4.09,{"v":5.2,"d":"5.20"},4.64,4.65,3.04,2.68,2.91,3.06,{"v":3.2,"d":"3.20"}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.75,0.74,0.68,0.71,{"v":0.7,"d":"0.70"},{"v":0.7,"d":"0.70"},0.71,{"v":0.7,"d":"0.70"},0.69,0.67]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",0.65,0.74,0.57,{"v":0.2,"d":"0.20"},0.76,0.22,0.15,{"v":-1.62,"d":"(1.62)"},{"v":-0.52,"d":"(0.52)"},0.21]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",{"v":4.5,"d":"4.50"},4.09,5.09,4.13,4.71,2.56,2.12,0.59,1.85,2.74]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.47,1.33,1.96,1.49,1.51,0.84,0.64,0.36,0.86,0.87]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",3.03,2.75,3.13,2.64,{"v":3.2,"d":"3.20"},1.72,1.47,0.24,0.99,1.86]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",23.07,20.98,28.27,22.13,24.45,{"v":23.5,"d":"23.50"},{"v":18.6,"d":"18.60"},5.47,17.55,25.07]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",15.53,14.14,{"v":17.4,"d":"17.40"},14.14,16.62,15.76,12.94,2.18,9.38,17.06]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",9.51,8.44,11.41,8.78,{"v":9.9,"d":"9.90"},7.74,6.16,{"v":1.8,"d":"1.80"},{"v":5.6,"d":"5.60"},8.34]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":6.4,"d":"6.40"},5.69,7.02,5.61,6.73,5.19,4.29,0.71,2.99,5.67]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.34,{"v":1.3,"d":"1.30"},1.32,1.31,1.28,{"v":1.1,"d":"1.10"},1.08,1.09,1.09,1.12]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.26,0.22,0.26,0.27,0.23,{"v":0.3,"d":"0.30"},0.29,0.29,{"v":0.3,"d":"0.30"},{"v":0.3,"d":"0.30"}]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.59,1.53,1.55,{"v":1.5,"d":"1.50"},1.54,1.18,{"v":1.2,"d":"1.20"},1.18,1.12,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-2012Q2","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"," 2Q_\n 2011_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 2Q_\n 2011_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":56410,"d":"56,410 "},{"v":52104,"d":"52,104 "},{"v":59341,"d":"59,341 "},{"v":68546,"d":"68,546 "},{"v":56101,"d":"56,101 "},{"v":9983,"d":"9,983 "},{"v":10181,"d":"10,181 "},{"v":10315,"d":"10,315 "},{"v":10221,"d":"10,221 "},{"v":10087,"d":"10,087 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":2407,"d":"2,407 "},{"v":2048,"d":"2,048 "},{"v":2434,"d":"2,434 "},{"v":2326,"d":"2,326 "},{"v":1989,"d":"1,989 "},{"v":246,"d":"246 "},{"v":294,"d":"294 "},{"v":322,"d":"322 "},{"v":329,"d":"329 "},{"v":256,"d":"256 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":58817,"d":"58,817 "},{"v":54152,"d":"54,152 "},{"v":61776,"d":"61,776 "},{"v":70872,"d":"70,872 "},{"v":58091,"d":"58,091 "},{"v":10229,"d":"10,229 "},{"v":10475,"d":"10,475 "},{"v":10637,"d":"10,637 "},{"v":10550,"d":"10,550 "},{"v":10343,"d":"10,343 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":17516,"d":"17,516 "},{"v":14722,"d":"14,722 "},{"v":19342,"d":"19,342 "},{"v":15705,"d":"15,705 "},{"v":15254,"d":"15,254 "},{"v":1620,"d":"1,620 "},{"v":1465,"d":"1,465 "},{"v":1445,"d":"1,445 "},{"v":1980,"d":"1,980 "},{"v":1848,"d":"1,848 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":76333,"d":"76,333 "},{"v":68874,"d":"68,874 "},{"v":81117,"d":"81,117 "},{"v":86577,"d":"86,577 "},{"v":73344,"d":"73,344 "},{"v":11849,"d":"11,849 "},{"v":11940,"d":"11,940 "},{"v":12082,"d":"12,082 "},{"v":12530,"d":"12,530 "},{"v":12191,"d":"12,191 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":53061,"d":"53,061 "},{"v":54017,"d":"54,017 "},{"v":58572,"d":"58,572 "},{"v":55019,"d":"55,019 "},{"v":54640,"d":"54,640 "},{"v":5282,"d":"5,282 "},{"v":5423,"d":"5,423 "},{"v":5603,"d":"5,603 "},{"v":5373,"d":"5,373 "},{"v":5696,"d":"5,696 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":231417,"d":"231,417 "},{"v":254069,"d":"254,069 "},{"v":236303,"d":"236,303 "},{"v":237299,"d":"237,299 "},{"v":239148,"d":"239,148 "},{"v":23077,"d":"23,077 "},{"v":23977,"d":"23,977 "},{"v":24149,"d":"24,149 "},{"v":23513,"d":"23,513 "},{"v":23541,"d":"23,541 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":35745,"d":"35,745 "},{"v":35787,"d":"35,787 "},{"v":36475,"d":"36,475 "},{"v":37611,"d":"37,611 "},{"v":37475,"d":"37,475 "},{"v":3344,"d":"3,344 "},{"v":3421,"d":"3,421 "},{"v":3808,"d":"3,808 "},{"v":4165,"d":"4,165 "},{"v":4126,"d":"4,126 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":396557,"d":"396,557 "},{"v":412747,"d":"412,747 "},{"v":412468,"d":"412,468 "},{"v":416505,"d":"416,505 "},{"v":404607,"d":"404,607 "},{"v":43553,"d":"43,553 "},{"v":44761,"d":"44,761 "},{"v":45642,"d":"45,642 "},{"v":45581,"d":"45,581 "},{"v":45554,"d":"45,554 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":628990,"d":"628,990 "},{"v":633232,"d":"633,232 "},{"v":639138,"d":"639,138 "},{"v":647793,"d":"647,793 "},{"v":658500,"d":"658,500 "},{"v":134973,"d":"134,973 "},{"v":135456,"d":"135,456 "},{"v":137185,"d":"137,185 "},{"v":138325,"d":"138,325 "},{"v":138831,"d":"138,831 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":74637,"d":"74,637 "},{"v":75119,"d":"75,119 "},{"v":75774,"d":"75,774 "},{"v":76191,"d":"76,191 "},{"v":77054,"d":"77,054 "},{"v":10731,"d":"10,731 "},{"v":10794,"d":"10,794 "},{"v":10679,"d":"10,679 "},{"v":10805,"d":"10,805 "},{"v":11147,"d":"11,147 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":303317,"d":"303,317 "},{"v":305832,"d":"305,832 "},{"v":310494,"d":"310,494 "},{"v":318292,"d":"318,292 "},{"v":325254,"d":"325,254 "},{"v":69986,"d":"69,986 "},{"v":70611,"d":"70,611 "},{"v":71972,"d":"71,972 "},{"v":73263,"d":"73,263 "},{"v":73232,"d":"73,232 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":400309,"d":"400,309 "},{"v":402519,"d":"402,519 "},{"v":404418,"d":"404,418 "},{"v":405692,"d":"405,692 "},{"v":410301,"d":"410,301 "},{"v":75719,"d":"75,719 "},{"v":75639,"d":"75,639 "},{"v":75892,"d":"75,892 "},{"v":75867,"d":"75,867 "},{"v":76745,"d":"76,745 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":302189,"d":"302,189 "},{"v":296050,"d":"296,050 "},{"v":300813,"d":"300,813 "},{"v":302912,"d":"302,912 "},{"v":333179,"d":"333,179 "},{"v":22942,"d":"22,942 "},{"v":22663,"d":"22,663 "},{"v":22527,"d":"22,527 "},{"v":22177,"d":"22,177 "},{"v":22171,"d":"22,171 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1099055,"d":"1,099,055 "},{"v":1111315,"d":"1,111,315 "},{"v":1117700,"d":"1,117,700 "},{"v":1125109,"d":"1,125,109 "},{"v":1148087,"d":"1,148,087 "},{"v":142214,"d":"142,214 "},{"v":143063,"d":"143,063 "},{"v":144062,"d":"144,062 "},{"v":143625,"d":"143,625 "},{"v":144470,"d":"144,470 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":9434,"d":"9,434 "},{"v":9896,"d":"9,896 "},{"v":11262,"d":"11,262 "},{"v":11288,"d":"11,288 "},{"v":12723,"d":"12,723 "},{"v":384,"d":"384 "},{"v":378,"d":"378 "},{"v":530,"d":"530 "},{"v":383,"d":"383 "},{"v":325,"d":"325 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":11192,"d":"11,192 "},{"v":17107,"d":"17,107 "},{"v":9807,"d":"9,807 "},{"v":10435,"d":"10,435 "},{"v":10687,"d":"10,687 "},{"v":673,"d":"673 "},{"v":1081,"d":"1,081 "},{"v":1169,"d":"1,169 "},{"v":95,"d":"95 "},{"v":146,"d":"146 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":147212,"d":"147,212 "},{"v":156727,"d":"156,727 "},{"v":151912,"d":"151,912 "},{"v":153433,"d":"153,433 "},{"v":154141,"d":"154,141 "},{"v":19623,"d":"19,623 "},{"v":19567,"d":"19,567 "},{"v":20267,"d":"20,267 "},{"v":20613,"d":"20,613 "},{"v":20558,"d":"20,558 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":4500,"d":"4,500 "},{"v":3443,"d":"3,443 "},{"v":5637,"d":"5,637 "},{"v":8847,"d":"8,847 "},{"v":5472,"d":"5,472 "},{"v":760,"d":"760 "},{"v":481,"d":"481 "},{"v":686,"d":"686 "},{"v":990,"d":"990 "},{"v":825,"d":"825 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":3990,"d":"3,990 "},{"v":4236,"d":"4,236 "},{"v":4123,"d":"4,123 "},{"v":4086,"d":"4,086 "},{"v":4084,"d":"4,084 "},{"v":844,"d":"844 "},{"v":873,"d":"873 "},{"v":787,"d":"787 "},{"v":676,"d":"676 "},{"v":355,"d":"355 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":14276,"d":"14,276 "},{"v":15740,"d":"15,740 "},{"v":19170,"d":"19,170 "},{"v":16868,"d":"16,868 "},{"v":16656,"d":"16,656 "},{"v":2541,"d":"2,541 "},{"v":3516,"d":"3,516 "},{"v":3459,"d":"3,459 "},{"v":4060,"d":"4,060 "},{"v":2548,"d":"2,548 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":105760,"d":"105,760 "},{"v":109290,"d":"109,290 "},{"v":110157,"d":"110,157 "},{"v":112678,"d":"112,678 "},{"v":111806,"d":"111,806 "},{"v":14924,"d":"14,924 "},{"v":15743,"d":"15,743 "},{"v":15018,"d":"15,018 "},{"v":15059,"d":"15,059 "},{"v":15760,"d":"15,760 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":296364,"d":"296,364 "},{"v":316440,"d":"316,440 "},{"v":312067,"d":"312,067 "},{"v":317634,"d":"317,634 "},{"v":315570,"d":"315,570 "},{"v":39747,"d":"39,747 "},{"v":41638,"d":"41,638 "},{"v":41916,"d":"41,916 "},{"v":41876,"d":"41,876 "},{"v":40516,"d":"40,516 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":48523,"d":"48,523 "},{"v":50602,"d":"50,602 "},{"v":49830,"d":"49,830 "},{"v":49670,"d":"49,670 "},{"v":52124,"d":"52,124 "},{"v":6584,"d":"6,584 "},{"v":6329,"d":"6,329 "},{"v":6638,"d":"6,638 "},{"v":7262,"d":"7,262 "},{"v":6994,"d":"6,994 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":197430,"d":"197,430 "},{"v":194447,"d":"194,447 "},{"v":197857,"d":"197,857 "},{"v":204954,"d":"204,954 "},{"v":204529,"d":"204,529 "},{"v":28608,"d":"28,608 "},{"v":27205,"d":"27,205 "},{"v":27426,"d":"27,426 "},{"v":28519,"d":"28,519 "},{"v":29071,"d":"29,071 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":103614,"d":"103,614 "},{"v":102723,"d":"102,723 "},{"v":106721,"d":"106,721 "},{"v":106488,"d":"106,488 "},{"v":111135,"d":"111,135 "},{"v":20463,"d":"20,463 "},{"v":20480,"d":"20,480 "},{"v":20813,"d":"20,813 "},{"v":20180,"d":"20,180 "},{"v":19844,"d":"19,844 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":645931,"d":"645,931 "},{"v":664212,"d":"664,212 "},{"v":666475,"d":"666,475 "},{"v":678747,"d":"678,747 "},{"v":683358,"d":"683,358 "},{"v":95402,"d":"95,402 "},{"v":95653,"d":"95,653 "},{"v":96794,"d":"96,794 "},{"v":97837,"d":"97,837 "},{"v":96425,"d":"96,425 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":111148,"d":"111,148 "},{"v":94317,"d":"94,317 "},{"v":91284,"d":"91,284 "},{"v":87775,"d":"87,775 "},{"v":107720,"d":"107,720 "},{"v":13873,"d":"13,873 "},{"v":13110,"d":"13,110 "},{"v":13458,"d":"13,458 "},{"v":11333,"d":"11,333 "},{"v":9599,"d":"9,599 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":341976,"d":"341,976 "},{"v":352787,"d":"352,787 "},{"v":359941,"d":"359,941 "},{"v":358588,"d":"358,588 "},{"v":357008,"d":"357,008 "},{"v":32940,"d":"32,940 "},{"v":34300,"d":"34,300 "},{"v":33810,"d":"33,810 "},{"v":34456,"d":"34,456 "},{"v":38446,"d":"38,446 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":453124,"d":"453,124 "},{"v":447103,"d":"447,103 "},{"v":451225,"d":"451,225 "},{"v":446362,"d":"446,362 "},{"v":464728,"d":"464,728 "},{"v":46813,"d":"46,813 "},{"v":47410,"d":"47,410 "},{"v":47268,"d":"47,268 "},{"v":45789,"d":"45,789 "},{"v":48045,"d":"48,045 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1099055,"d":"1,099,055 "},{"v":1111315,"d":"1,111,315 "},{"v":1117700,"d":"1,117,700 "},{"v":1125109,"d":"1,125,109 "},{"v":1148087,"d":"1,148,087 "},{"v":142214,"d":"142,214 "},{"v":143063,"d":"143,063 "},{"v":144062,"d":"144,062 "},{"v":143625,"d":"143,625 "},{"v":144470,"d":"144,470 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":100193,"d":"100,193 "},{"v":96307,"d":"96,307 "},{"v":100401,"d":"100,401 "},{"v":98871,"d":"98,871 "},{"v":89037,"d":"89,037 "},{"v":3805,"d":"3,805 "},{"v":3123,"d":"3,123 "},{"v":3726,"d":"3,726 "},{"v":3706,"d":"3,706 "},{"v":5037,"d":"5,037 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",6.95,{"v":6.2,"d":"6.20"},7.26,7.69,6.39,8.33,8.35,8.39,8.72,8.44]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",4.83,4.86,5.24,4.89,4.76,3.71,3.79,3.89,3.74,3.94]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",21.06,22.86,21.14,21.09,20.83,16.23,16.76,16.76,16.37,{"v":16.3,"d":"16.30"}]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",36.08,37.14,{"v":36.9,"d":"36.90"},37.02,35.24,30.62,31.29,31.68,31.74,31.53]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",36.42,36.22,36.18,36.06,35.74,53.24,52.87,52.68,52.82,53.12]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",3.54,4.23,3.97,3.79,3.85,3.12,4.09,4.13,3.63,2.33]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",26.97,28.47,27.92,28.23,27.49,27.95,{"v":29.1,"d":"29.10"},{"v":29.1,"d":"29.10"},29.16,28.04]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.38,22.05,22.16,22.63,22.35,24.75,23.44,23.65,24.91,24.96]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",58.77,59.77,59.63,60.33,59.52,67.08,66.86,67.19,68.12,66.74]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",41.23,40.23,40.37,39.67,40.48,32.92,33.14,32.81,31.88,33.26]
["  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-2012Q2","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"," 2Q_\n 2011_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 2Q_\n 2011_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":192874,"d":"192,874 "},{"v":191821,"d":"191,821 "},{"v":229404,"d":"229,404 "},{"v":200088,"d":"200,088 "},{"v":200791,"d":"200,791 "},{"v":280585,"d":"280,585 "},{"v":277805,"d":"277,805 "},{"v":287997,"d":"287,997 "},{"v":288440,"d":"288,440 "},{"v":292510,"d":"292,510 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":4555,"d":"4,555 "},{"v":4501,"d":"4,501 "},{"v":4606,"d":"4,606 "},{"v":4566,"d":"4,566 "},{"v":4737,"d":"4,737 "},{"v":4186,"d":"4,186 "},{"v":4227,"d":"4,227 "},{"v":4223,"d":"4,223 "},{"v":4248,"d":"4,248 "},{"v":4309,"d":"4,309 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":178324,"d":"178,324 "},{"v":178466,"d":"178,466 "},{"v":208685,"d":"208,685 "},{"v":184236,"d":"184,236 "},{"v":185138,"d":"185,138 "},{"v":262959,"d":"262,959 "},{"v":261779,"d":"261,779 "},{"v":270490,"d":"270,490 "},{"v":271069,"d":"271,069 "},{"v":274554,"d":"274,554 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":9995,"d":"9,995 "},{"v":8854,"d":"8,854 "},{"v":16113,"d":"16,113 "},{"v":11286,"d":"11,286 "},{"v":10916,"d":"10,916 "},{"v":13441,"d":"13,441 "},{"v":11800,"d":"11,800 "},{"v":13284,"d":"13,284 "},{"v":13122,"d":"13,122 "},{"v":13646,"d":"13,646 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1631,"d":"1,631 "},{"v":1548,"d":"1,548 "},{"v":1467,"d":"1,467 "},{"v":1536,"d":"1,536 "},{"v":1545,"d":"1,545 "},{"v":1989,"d":"1,989 "},{"v":1984,"d":"1,984 "},{"v":2028,"d":"2,028 "},{"v":1956,"d":"1,956 "},{"v":1963,"d":"1,963 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":2631,"d":"2,631 "},{"v":2552,"d":"2,552 "},{"v":2153,"d":"2,153 "},{"v":3045,"d":"3,045 "},{"v":2876,"d":"2,876 "},{"v":941,"d":"941 "},{"v":1567,"d":"1,567 "},{"v":3192,"d":"3,192 "},{"v":-1276,"d":"(1,276)"},{"v":1470,"d":"1,470 "}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":10995,"d":"10,995 "},{"v":9858,"d":"9,858 "},{"v":16799,"d":"16,799 "},{"v":12794,"d":"12,794 "},{"v":12247,"d":"12,247 "},{"v":12393,"d":"12,393 "},{"v":11383,"d":"11,383 "},{"v":14448,"d":"14,448 "},{"v":9889,"d":"9,889 "},{"v":13154,"d":"13,154 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":3519,"d":"3,519 "},{"v":3280,"d":"3,280 "},{"v":7385,"d":"7,385 "},{"v":4080,"d":"4,080 "},{"v":3974,"d":"3,974 "},{"v":4118,"d":"4,118 "},{"v":3688,"d":"3,688 "},{"v":4491,"d":"4,491 "},{"v":3893,"d":"3,893 "},{"v":4161,"d":"4,161 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":7476,"d":"7,476 "},{"v":6579,"d":"6,579 "},{"v":9415,"d":"9,415 "},{"v":8714,"d":"8,714 "},{"v":8273,"d":"8,273 "},{"v":8275,"d":"8,275 "},{"v":7695,"d":"7,695 "},{"v":9957,"d":"9,957 "},{"v":5997,"d":"5,997 "},{"v":8993,"d":"8,993 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":1308,"d":"1,308 "},{"v":1151,"d":"1,151 "},{"v":1835,"d":"1,835 "},{"v":6672,"d":"6,672 "},{"v":847,"d":"847 "},{"v":1814,"d":"1,814 "},{"v":1701,"d":"1,701 "},{"v":1962,"d":"1,962 "},{"v":1892,"d":"1,892 "},{"v":2117,"d":"2,117 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":6168,"d":"6,168 "},{"v":5428,"d":"5,428 "},{"v":7580,"d":"7,580 "},{"v":2042,"d":"2,042 "},{"v":7426,"d":"7,426 "},{"v":6461,"d":"6,461 "},{"v":5995,"d":"5,995 "},{"v":7995,"d":"7,995 "},{"v":4105,"d":"4,105 "},{"v":6876,"d":"6,876 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":151947,"d":"151,947 "},{"v":153624,"d":"153,624 "},{"v":155724,"d":"155,724 "},{"v":157304,"d":"157,304 "},{"v":157379,"d":"157,379 "},{"v":149980,"d":"149,980 "},{"v":157392,"d":"157,392 "},{"v":161533,"d":"161,533 "},{"v":168361,"d":"168,361 "},{"v":158363,"d":"158,363 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-3381,"d":"(3,381)"},{"v":-3026,"d":"(3,026)"},{"v":-5783,"d":"(5,783)"},{"v":-2326,"d":"(2,326)"},{"v":-3604,"d":"(3,604)"},{"v":-2138,"d":"(2,138)"},{"v":-927,"d":"(927)"},{"v":-918,"d":"(918)"},{"v":-5354,"d":"(5,354)"},{"v":-7877,"d":"(7,877)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":154734,"d":"154,734 "},{"v":156026,"d":"156,026 "},{"v":157521,"d":"157,521 "},{"v":157019,"d":"157,019 "},{"v":161201,"d":"161,201 "},{"v":154302,"d":"154,302 "},{"v":162460,"d":"162,460 "},{"v":168610,"d":"168,610 "},{"v":167112,"d":"167,112 "},{"v":157362,"d":"157,362 "}]
["                         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.36,2.35,2.01,2.28,2.36,1.49,1.52,1.47,1.47,1.47]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",92.46,93.04,90.97,92.08,{"v":92.2,"d":"92.20"},93.72,94.23,93.92,93.98,93.86]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",5.18,4.62,7.02,5.64,5.44,4.79,4.25,4.61,4.55,4.67]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.85,0.81,0.64,0.77,0.77,0.71,0.71,{"v":0.7,"d":"0.70"},0.68,0.67]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",1.36,1.33,0.94,1.52,1.43,0.34,0.56,1.11,{"v":-0.44,"d":"(0.44)"},{"v":0.5,"d":"0.50"}]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",{"v":5.7,"d":"5.70"},5.14,7.32,6.39,{"v":6.1,"d":"6.10"},4.42,{"v":4.1,"d":"4.10"},5.02,3.43,{"v":4.5,"d":"4.50"}]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.82,1.71,3.22,2.04,1.98,1.47,1.33,1.56,1.35,1.42]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",3.88,3.43,{"v":4.1,"d":"4.10"},4.36,4.12,2.95,2.77,3.46,2.08,3.07]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",23.42,21.37,36.04,27.72,26.38,22.68,21.16,26.57,18.32,22.78]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",15.93,14.26,{"v":20.2,"d":"20.20"},18.88,17.82,15.15,14.31,18.31,11.11,15.58]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":10,"d":"10.00"},{"v":8.7,"d":"8.70"},15.11,{"v":11.4,"d":"11.40"},10.89,9.59,8.85,10.93,7.43,{"v":9.5,"d":"9.50"}]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":6.8,"d":"6.80"},{"v":5.8,"d":"5.80"},8.47,7.77,7.36,{"v":6.4,"d":"6.40"},5.98,7.53,{"v":4.5,"d":"4.50"},6.49]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.32,{"v":1.3,"d":"1.30"},1.31,1.26,1.26,1.42,1.37,{"v":1.4,"d":"1.40"},1.41,1.35]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.25,0.19,0.25,0.24,0.22,0.25,0.22,0.26,0.29,0.22]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.67,1.54,1.63,1.61,{"v":1.6,"d":"1.60"},1.64,1.62,1.58,1.52,1.59]
["  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-2012Q2","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"," 2Q_\n 2011_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 2Q_\n 2011_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":21750,"d":"21,750 "},{"v":19132,"d":"19,132 "},{"v":20757,"d":"20,757 "},{"v":22729,"d":"22,729 "},{"v":20554,"d":"20,554 "},{"v":24677,"d":"24,677 "},{"v":22790,"d":"22,790 "},{"v":28269,"d":"28,269 "},{"v":35596,"d":"35,596 "},{"v":25460,"d":"25,460 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":1208,"d":"1,208 "},{"v":681,"d":"681 "},{"v":655,"d":"655 "},{"v":630,"d":"630 "},{"v":626,"d":"626 "},{"v":953,"d":"953 "},{"v":1074,"d":"1,074 "},{"v":1457,"d":"1,457 "},{"v":1366,"d":"1,366 "},{"v":1107,"d":"1,107 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":22958,"d":"22,958 "},{"v":19813,"d":"19,813 "},{"v":21412,"d":"21,412 "},{"v":23359,"d":"23,359 "},{"v":21180,"d":"21,180 "},{"v":25630,"d":"25,630 "},{"v":23864,"d":"23,864 "},{"v":29726,"d":"29,726 "},{"v":36962,"d":"36,962 "},{"v":26568,"d":"26,568 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":6255,"d":"6,255 "},{"v":4348,"d":"4,348 "},{"v":7123,"d":"7,123 "},{"v":5720,"d":"5,720 "},{"v":5967,"d":"5,967 "},{"v":9642,"d":"9,642 "},{"v":8909,"d":"8,909 "},{"v":10773,"d":"10,773 "},{"v":8006,"d":"8,006 "},{"v":7439,"d":"7,439 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":29213,"d":"29,213 "},{"v":24161,"d":"24,161 "},{"v":28536,"d":"28,536 "},{"v":29079,"d":"29,079 "},{"v":27147,"d":"27,147 "},{"v":35272,"d":"35,272 "},{"v":32773,"d":"32,773 "},{"v":40500,"d":"40,500 "},{"v":44968,"d":"44,968 "},{"v":34006,"d":"34,006 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":7196,"d":"7,196 "},{"v":8188,"d":"8,188 "},{"v":7759,"d":"7,759 "},{"v":7450,"d":"7,450 "},{"v":7171,"d":"7,171 "},{"v":40583,"d":"40,583 "},{"v":40406,"d":"40,406 "},{"v":45210,"d":"45,210 "},{"v":42196,"d":"42,196 "},{"v":41774,"d":"41,774 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":99829,"d":"99,829 "},{"v":118144,"d":"118,144 "},{"v":99885,"d":"99,885 "},{"v":102066,"d":"102,066 "},{"v":103279,"d":"103,279 "},{"v":108510,"d":"108,510 "},{"v":111948,"d":"111,948 "},{"v":112269,"d":"112,269 "},{"v":111719,"d":"111,719 "},{"v":112328,"d":"112,328 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15483,"d":"15,483 "},{"v":16016,"d":"16,016 "},{"v":15482,"d":"15,482 "},{"v":15389,"d":"15,389 "},{"v":15641,"d":"15,641 "},{"v":16918,"d":"16,918 "},{"v":16350,"d":"16,350 "},{"v":17185,"d":"17,185 "},{"v":18057,"d":"18,057 "},{"v":17708,"d":"17,708 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":151721,"d":"151,721 "},{"v":166509,"d":"166,509 "},{"v":151662,"d":"151,662 "},{"v":153984,"d":"153,984 "},{"v":153237,"d":"153,237 "},{"v":201283,"d":"201,283 "},{"v":201476,"d":"201,476 "},{"v":215164,"d":"215,164 "},{"v":216940,"d":"216,940 "},{"v":205816,"d":"205,816 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":268440,"d":"268,440 "},{"v":269890,"d":"269,890 "},{"v":272220,"d":"272,220 "},{"v":276547,"d":"276,547 "},{"v":281203,"d":"281,203 "},{"v":225576,"d":"225,576 "},{"v":227886,"d":"227,886 "},{"v":229733,"d":"229,733 "},{"v":232921,"d":"232,921 "},{"v":238466,"d":"238,466 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":29437,"d":"29,437 "},{"v":29496,"d":"29,496 "},{"v":30069,"d":"30,069 "},{"v":30283,"d":"30,283 "},{"v":30475,"d":"30,475 "},{"v":34468,"d":"34,468 "},{"v":34828,"d":"34,828 "},{"v":35026,"d":"35,026 "},{"v":35102,"d":"35,102 "},{"v":35432,"d":"35,432 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":120050,"d":"120,050 "},{"v":120512,"d":"120,512 "},{"v":122332,"d":"122,332 "},{"v":126187,"d":"126,187 "},{"v":129611,"d":"129,611 "},{"v":113281,"d":"113,281 "},{"v":114708,"d":"114,708 "},{"v":116190,"d":"116,190 "},{"v":118842,"d":"118,842 "},{"v":122411,"d":"122,411 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":177828,"d":"177,828 "},{"v":178874,"d":"178,874 "},{"v":179957,"d":"179,957 "},{"v":180643,"d":"180,643 "},{"v":182067,"d":"182,067 "},{"v":146763,"d":"146,763 "},{"v":148006,"d":"148,006 "},{"v":148569,"d":"148,569 "},{"v":149181,"d":"149,181 "},{"v":151488,"d":"151,488 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":110133,"d":"110,133 "},{"v":108112,"d":"108,112 "},{"v":113033,"d":"113,033 "},{"v":114216,"d":"114,216 "},{"v":114353,"d":"114,353 "},{"v":169113,"d":"169,113 "},{"v":165275,"d":"165,275 "},{"v":165253,"d":"165,253 "},{"v":166518,"d":"166,518 "},{"v":196656,"d":"196,656 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":439681,"d":"439,681 "},{"v":453495,"d":"453,495 "},{"v":444652,"d":"444,652 "},{"v":448844,"d":"448,844 "},{"v":449658,"d":"449,658 "},{"v":517159,"d":"517,159 "},{"v":514757,"d":"514,757 "},{"v":528986,"d":"528,986 "},{"v":532640,"d":"532,640 "},{"v":553959,"d":"553,959 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":258,"d":"258 "},{"v":892,"d":"892 "},{"v":678,"d":"678 "},{"v":913,"d":"913 "},{"v":1053,"d":"1,053 "},{"v":8793,"d":"8,793 "},{"v":8626,"d":"8,626 "},{"v":10053,"d":"10,053 "},{"v":9992,"d":"9,992 "},{"v":11345,"d":"11,345 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":7212,"d":"7,212 "},{"v":12464,"d":"12,464 "},{"v":4958,"d":"4,958 "},{"v":7020,"d":"7,020 "},{"v":6830,"d":"6,830 "},{"v":3307,"d":"3,307 "},{"v":3562,"d":"3,562 "},{"v":3680,"d":"3,680 "},{"v":3320,"d":"3,320 "},{"v":3712,"d":"3,712 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":56544,"d":"56,544 "},{"v":65358,"d":"65,358 "},{"v":54971,"d":"54,971 "},{"v":57989,"d":"57,989 "},{"v":57959,"d":"57,959 "},{"v":71045,"d":"71,045 "},{"v":71802,"d":"71,802 "},{"v":76673,"d":"76,673 "},{"v":74830,"d":"74,830 "},{"v":75624,"d":"75,624 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":1335,"d":"1,335 "},{"v":632,"d":"632 "},{"v":2717,"d":"2,717 "},{"v":4105,"d":"4,105 "},{"v":2028,"d":"2,028 "},{"v":2404,"d":"2,404 "},{"v":2331,"d":"2,331 "},{"v":2234,"d":"2,234 "},{"v":3753,"d":"3,753 "},{"v":2619,"d":"2,619 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":429,"d":"429 "},{"v":414,"d":"414 "},{"v":363,"d":"363 "},{"v":342,"d":"342 "},{"v":418,"d":"418 "},{"v":2718,"d":"2,718 "},{"v":2949,"d":"2,949 "},{"v":2974,"d":"2,974 "},{"v":3068,"d":"3,068 "},{"v":3312,"d":"3,312 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5255,"d":"5,255 "},{"v":4654,"d":"4,654 "},{"v":8345,"d":"8,345 "},{"v":6619,"d":"6,619 "},{"v":8288,"d":"8,288 "},{"v":6480,"d":"6,480 "},{"v":7570,"d":"7,570 "},{"v":7366,"d":"7,366 "},{"v":6189,"d":"6,189 "},{"v":5820,"d":"5,820 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":43629,"d":"43,629 "},{"v":43306,"d":"43,306 "},{"v":44121,"d":"44,121 "},{"v":45374,"d":"45,374 "},{"v":45474,"d":"45,474 "},{"v":47208,"d":"47,208 "},{"v":50241,"d":"50,241 "},{"v":51018,"d":"51,018 "},{"v":52245,"d":"52,245 "},{"v":50572,"d":"50,572 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":114662,"d":"114,662 "},{"v":127721,"d":"127,721 "},{"v":116153,"d":"116,153 "},{"v":122361,"d":"122,361 "},{"v":122050,"d":"122,050 "},{"v":141954,"d":"141,954 "},{"v":147081,"d":"147,081 "},{"v":153998,"d":"153,998 "},{"v":153398,"d":"153,398 "},{"v":153004,"d":"153,004 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":14442,"d":"14,442 "},{"v":17004,"d":"17,004 "},{"v":15977,"d":"15,977 "},{"v":15051,"d":"15,051 "},{"v":15061,"d":"15,061 "},{"v":27497,"d":"27,497 "},{"v":27269,"d":"27,269 "},{"v":27215,"d":"27,215 "},{"v":27358,"d":"27,358 "},{"v":30070,"d":"30,070 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":84669,"d":"84,669 "},{"v":84448,"d":"84,448 "},{"v":84300,"d":"84,300 "},{"v":84542,"d":"84,542 "},{"v":84437,"d":"84,437 "},{"v":84153,"d":"84,153 "},{"v":82794,"d":"82,794 "},{"v":86131,"d":"86,131 "},{"v":91892,"d":"91,892 "},{"v":91022,"d":"91,022 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":38150,"d":"38,150 "},{"v":39810,"d":"39,810 "},{"v":41787,"d":"41,787 "},{"v":42254,"d":"42,254 "},{"v":42381,"d":"42,381 "},{"v":45001,"d":"45,001 "},{"v":42433,"d":"42,433 "},{"v":44120,"d":"44,120 "},{"v":44054,"d":"44,054 "},{"v":48911,"d":"48,911 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":251924,"d":"251,924 "},{"v":268982,"d":"268,982 "},{"v":258217,"d":"258,217 "},{"v":264208,"d":"264,208 "},{"v":263927,"d":"263,927 "},{"v":298606,"d":"298,606 "},{"v":299577,"d":"299,577 "},{"v":311464,"d":"311,464 "},{"v":316702,"d":"316,702 "},{"v":323006,"d":"323,006 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":33024,"d":"33,024 "},{"v":28486,"d":"28,486 "},{"v":28914,"d":"28,914 "},{"v":27617,"d":"27,617 "},{"v":24529,"d":"24,529 "},{"v":64251,"d":"64,251 "},{"v":52720,"d":"52,720 "},{"v":48912,"d":"48,912 "},{"v":48826,"d":"48,826 "},{"v":73591,"d":"73,591 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":154734,"d":"154,734 "},{"v":156026,"d":"156,026 "},{"v":157521,"d":"157,521 "},{"v":157019,"d":"157,019 "},{"v":161201,"d":"161,201 "},{"v":154302,"d":"154,302 "},{"v":162460,"d":"162,460 "},{"v":168610,"d":"168,610 "},{"v":167112,"d":"167,112 "},{"v":157362,"d":"157,362 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":187758,"d":"187,758 "},{"v":184513,"d":"184,513 "},{"v":186435,"d":"186,435 "},{"v":184636,"d":"184,636 "},{"v":185730,"d":"185,730 "},{"v":218554,"d":"218,554 "},{"v":215180,"d":"215,180 "},{"v":217522,"d":"217,522 "},{"v":215937,"d":"215,937 "},{"v":230953,"d":"230,953 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":439681,"d":"439,681 "},{"v":453495,"d":"453,495 "},{"v":444652,"d":"444,652 "},{"v":448844,"d":"448,844 "},{"v":449658,"d":"449,658 "},{"v":517159,"d":"517,159 "},{"v":514757,"d":"514,757 "},{"v":528986,"d":"528,986 "},{"v":532640,"d":"532,640 "},{"v":553959,"d":"553,959 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":37058,"d":"37,058 "},{"v":38789,"d":"38,789 "},{"v":35509,"d":"35,509 "},{"v":31623,"d":"31,623 "},{"v":31188,"d":"31,188 "},{"v":59329,"d":"59,329 "},{"v":54395,"d":"54,395 "},{"v":61166,"d":"61,166 "},{"v":63542,"d":"63,542 "},{"v":52812,"d":"52,812 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",6.64,5.33,6.42,6.48,6.04,6.82,6.37,7.66,8.44,6.14]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",1.64,1.81,1.74,1.66,1.59,7.85,7.85,8.55,7.92,7.54]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":22.7,"d":"22.70"},26.05,22.46,22.74,22.97,20.98,21.75,21.22,20.97,20.28]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",34.51,36.72,34.11,34.31,34.08,38.92,39.14,40.67,40.73,37.15]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",40.44,39.44,40.47,40.25,40.49,28.38,28.75,28.09,28.01,27.35]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",2.99,4.06,3.23,3.32,3.69,4.12,4.41,4.55,4.24,4.37]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",26.08,28.16,26.12,27.26,27.14,27.45,28.57,29.11,{"v":28.8,"d":"28.80"},27.62]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.54,22.37,22.55,22.19,22.13,21.59,21.38,21.43,22.39,21.86]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":57.3,"d":"57.30"},59.31,58.07,58.86,{"v":58.7,"d":"58.70"},57.74,{"v":58.2,"d":"58.20"},58.88,59.46,58.31]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":42.7,"d":"42.70"},40.69,41.93,41.14,{"v":41.3,"d":"41.30"},42.26,{"v":41.8,"d":"41.80"},41.12,40.54,41.69]
["  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-2012Q2","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":330930,"d":"330,930 "},{"v":336771,"d":"336,771 "},{"v":339795,"d":"339,795 "},{"v":347722,"d":"347,722 "}]
["2002 …………………………………………………………………………………………...………………………………………………..",{"v":349190,"d":"349,190 "},{"v":354969,"d":"354,969 "},{"v":359615,"d":"359,615 "},{"v":357326,"d":"357,326 "}]
["2003 …………………………………………………………………………………………...………………………………………………..",{"v":366852,"d":"366,852 "},{"v":369682,"d":"369,682 "},{"v":391593,"d":"391,593 "},{"v":398988,"d":"398,988 "}]
["2004 …………………………………………………………………………………………...………………………………………………..",{"v":406958,"d":"406,958 "},{"v":410290,"d":"410,290 "},{"v":421831,"d":"421,831 "},{"v":427324,"d":"427,324 "}]
["2005 …………………………………………………………………………………………...………………………………………………..",{"v":438353,"d":"438,353 "},{"v":447311,"d":"447,311 "},{"v":458722,"d":"458,722 "},{"v":467735,"d":"467,735 "}]
["2006 …………………………………………………………………………………………...………………………………………………..",{"v":480510,"d":"480,510 "},{"v":492653,"d":"492,653 "},{"v":497876,"d":"497,876 "},{"v":501907,"d":"501,907 "}]
["2007 …………………………………………………………………………………………...………………………………………………..",{"v":509826,"d":"509,826 "},{"v":514649,"d":"514,649 "},{"v":516183,"d":"516,183 "},{"v":521212,"d":"521,212 "}]
["2008 …………………………………………………………………………………………...………………………………………………..",{"v":523052,"d":"523,052 "},{"v":536289,"d":"536,289 "},{"v":531558,"d":"531,558 "},{"v":501460,"d":"501,460 "}]
["2009 …………………………………………………………………………………………...………………………………………………..",{"v":495284,"d":"495,284 "},{"v":495164,"d":"495,164 "},{"v":508577,"d":"508,577 "},{"v":520801,"d":"520,801 "}]
["2010 …………………………………………………………………………………………...………………………………………………..",{"v":531122,"d":"531,122 "},{"v":534629,"d":"534,629 "},{"v":539869,"d":"539,869 "},{"v":552091,"d":"552,091 "}]
["2011 …………………………………………………………………………………………...………………………………………………..",{"v":565599,"d":"565,599 "},{"v":585099,"d":"585,099 "},{"v":588019,"d":"588,019 "},{"v":596489,"d":"596,489 "}]
["2012 …………………………………………………………………………………………...………………………………………………..",{"v":608896,"d":"608,896 "},{"v":607284,"d":"607,284 "}]
[]
["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."]