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

{"sheet":"RET_4_0-2013Q2","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 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 1Q_\n 2013_"," 2Q_\n 2013_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 1Q_\n 2013_"," 2Q_\n 2013_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":593882,"d":"593,882 "},{"v":589872,"d":"589,872 "},{"v":643627,"d":"643,627 "},{"v":603504,"d":"603,504 "},{"v":623347,"d":"623,347 "},{"v":110268,"d":"110,268 "},{"v":109789,"d":"109,789 "},{"v":111628,"d":"111,628 "},{"v":111377,"d":"111,377 "},{"v":111383,"d":"111,383 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":11231,"d":"11,231 "},{"v":11201,"d":"11,201 "},{"v":11403,"d":"11,403 "},{"v":11459,"d":"11,459 "},{"v":11646,"d":"11,646 "},{"v":2255,"d":"2,255 "},{"v":2163,"d":"2,163 "},{"v":2187,"d":"2,187 "},{"v":2162,"d":"2,162 "},{"v":2226,"d":"2,226 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":554910,"d":"554,910 "},{"v":554939,"d":"554,939 "},{"v":598271,"d":"598,271 "},{"v":563609,"d":"563,609 "},{"v":579466,"d":"579,466 "},{"v":104503,"d":"104,503 "},{"v":104617,"d":"104,617 "},{"v":105878,"d":"105,878 "},{"v":106023,"d":"106,023 "},{"v":104977,"d":"104,977 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":27741,"d":"27,741 "},{"v":23733,"d":"23,733 "},{"v":33952,"d":"33,952 "},{"v":28435,"d":"28,435 "},{"v":32234,"d":"32,234 "},{"v":3510,"d":"3,510 "},{"v":3009,"d":"3,009 "},{"v":3562,"d":"3,562 "},{"v":3192,"d":"3,192 "},{"v":4180,"d":"4,180 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4204,"d":"4,204 "},{"v":4295,"d":"4,295 "},{"v":4233,"d":"4,233 "},{"v":4659,"d":"4,659 "},{"v":4060,"d":"4,060 "},{"v":744,"d":"744 "},{"v":773,"d":"773 "},{"v":754,"d":"754 "},{"v":741,"d":"741 "},{"v":736,"d":"736 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4500,"d":"4,500 "},{"v":3935,"d":"3,935 "},{"v":4137,"d":"4,137 "},{"v":868,"d":"868 "},{"v":3216,"d":"3,216 "},{"v":248,"d":"248 "},{"v":241,"d":"241 "},{"v":-166,"d":"(166)"},{"v":-1373,"d":"(1,373)"},{"v":52,"d":"52 "}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":28038,"d":"28,038 "},{"v":23372,"d":"23,372 "},{"v":33856,"d":"33,856 "},{"v":24643,"d":"24,643 "},{"v":31390,"d":"31,390 "},{"v":3014,"d":"3,014 "},{"v":2477,"d":"2,477 "},{"v":2643,"d":"2,643 "},{"v":1078,"d":"1,078 "},{"v":3495,"d":"3,495 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":8971,"d":"8,971 "},{"v":8201,"d":"8,201 "},{"v":10353,"d":"10,353 "},{"v":8460,"d":"8,460 "},{"v":10149,"d":"10,149 "},{"v":962,"d":"962 "},{"v":734,"d":"734 "},{"v":890,"d":"890 "},{"v":782,"d":"782 "},{"v":1042,"d":"1,042 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":19067,"d":"19,067 "},{"v":15171,"d":"15,171 "},{"v":23503,"d":"23,503 "},{"v":16183,"d":"16,183 "},{"v":21242,"d":"21,242 "},{"v":2052,"d":"2,052 "},{"v":1743,"d":"1,743 "},{"v":1753,"d":"1,753 "},{"v":296,"d":"296 "},{"v":2453,"d":"2,453 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":3891,"d":"3,891 "},{"v":4424,"d":"4,424 "},{"v":7212,"d":"7,212 "},{"v":13555,"d":"13,555 "},{"v":5229,"d":"5,229 "},{"v":533,"d":"533 "},{"v":263,"d":"263 "},{"v":1231,"d":"1,231 "},{"v":574,"d":"574 "},{"v":237,"d":"237 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15176,"d":"15,176 "},{"v":10748,"d":"10,748 "},{"v":16291,"d":"16,291 "},{"v":2628,"d":"2,628 "},{"v":16013,"d":"16,013 "},{"v":1519,"d":"1,519 "},{"v":1480,"d":"1,480 "},{"v":522,"d":"522 "},{"v":-279,"d":"(279)"},{"v":2216,"d":"2,216 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":351994,"d":"351,994 "},{"v":355553,"d":"355,553 "},{"v":361639,"d":"361,639 "},{"v":371931,"d":"371,931 "},{"v":368464,"d":"368,464 "},{"v":37060,"d":"37,060 "},{"v":37593,"d":"37,593 "},{"v":39065,"d":"39,065 "},{"v":39762,"d":"39,762 "},{"v":39627,"d":"39,627 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-11197,"d":"(11,197)"},{"v":-4292,"d":"(4,292)"},{"v":-5941,"d":"(5,941)"},{"v":-6390,"d":"(6,390)"},{"v":-5210,"d":"(5,210)"},{"v":-106,"d":"(106)"},{"v":-206,"d":"(206)"},{"v":-349,"d":"(349)"},{"v":281,"d":"281 "},{"v":-130,"d":"(130)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":355974,"d":"355,974 "},{"v":362009,"d":"362,009 "},{"v":371989,"d":"371,989 "},{"v":368170,"d":"368,170 "},{"v":379267,"d":"379,267 "},{"v":38473,"d":"38,473 "},{"v":38867,"d":"38,867 "},{"v":39238,"d":"39,238 "},{"v":39764,"d":"39,764 "},{"v":41714,"d":"41,714 "}]
["                         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.89,{"v":1.9,"d":"1.90"},1.77,{"v":1.9,"d":"1.90"},1.87,2.04,1.97,1.96,1.94,{"v":2,"d":"2.00"}]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",93.44,94.08,92.95,93.39,92.96,94.77,95.29,94.85,95.19,94.25]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",4.67,4.02,5.28,4.71,5.17,3.18,2.74,3.19,2.87,3.75]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.71,0.73,0.66,0.77,0.65,0.67,{"v":0.7,"d":"0.70"},0.68,0.67,0.66]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",0.76,0.67,0.64,0.14,0.52,0.22,0.22,{"v":-0.15,"d":"(0.15)"},{"v":-1.23,"d":"(1.23)"},0.05]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",4.72,3.96,5.26,4.08,5.04,2.73,2.26,2.37,0.97,3.14]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.51,1.39,1.61,{"v":1.4,"d":"1.40"},1.63,0.87,0.67,{"v":0.8,"d":"0.80"},{"v":0.7,"d":"0.70"},0.94]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",3.21,2.57,3.65,2.68,3.41,1.86,1.59,1.57,0.27,{"v":2.2,"d":"2.20"}]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",24.34,{"v":20,"d":"20.00"},28.23,20.97,26.37,25.07,20.44,21.58,8.77,27.25]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",16.56,12.99,{"v":19.6,"d":"19.60"},13.77,17.85,17.07,14.39,14.31,2.41,19.13]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",9.88,7.99,11.41,8.27,10.47,8.32,6.79,7.16,2.92,9.36]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",6.72,5.19,7.92,5.43,7.08,5.67,4.78,4.75,{"v":0.8,"d":"0.80"},6.57]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.27,1.26,1.27,1.26,1.25,1.12,1.16,1.12,1.12,1.12]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.23,{"v":0.2,"d":"0.20"},0.24,0.23,0.23,{"v":0.3,"d":"0.30"},0.32,{"v":0.3,"d":"0.30"},0.31,0.32]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.55,1.52,1.57,1.49,1.48,1.25,1.26,1.24,1.27,1.32]
["  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-2013Q2","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 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 1Q_\n 2013_"," 2Q_\n 2013_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 1Q_\n 2013_"," 2Q_\n 2013_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":54626,"d":"54,626 "},{"v":53498,"d":"53,498 "},{"v":61414,"d":"61,414 "},{"v":59202,"d":"59,202 "},{"v":58295,"d":"58,295 "},{"v":10103,"d":"10,103 "},{"v":10482,"d":"10,482 "},{"v":10174,"d":"10,174 "},{"v":10555,"d":"10,555 "},{"v":10852,"d":"10,852 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":3434,"d":"3,434 "},{"v":1933,"d":"1,933 "},{"v":1536,"d":"1,536 "},{"v":2074,"d":"2,074 "},{"v":2134,"d":"2,134 "},{"v":318,"d":"318 "},{"v":267,"d":"267 "},{"v":464,"d":"464 "},{"v":359,"d":"359 "},{"v":450,"d":"450 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":58060,"d":"58,060 "},{"v":55430,"d":"55,430 "},{"v":62950,"d":"62,950 "},{"v":61276,"d":"61,276 "},{"v":60430,"d":"60,430 "},{"v":10420,"d":"10,420 "},{"v":10749,"d":"10,749 "},{"v":10638,"d":"10,638 "},{"v":10914,"d":"10,914 "},{"v":11302,"d":"11,302 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":13109,"d":"13,109 "},{"v":12802,"d":"12,802 "},{"v":16923,"d":"16,923 "},{"v":17521,"d":"17,521 "},{"v":16958,"d":"16,958 "},{"v":1763,"d":"1,763 "},{"v":2223,"d":"2,223 "},{"v":2174,"d":"2,174 "},{"v":2235,"d":"2,235 "},{"v":2389,"d":"2,389 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":71169,"d":"71,169 "},{"v":68232,"d":"68,232 "},{"v":79873,"d":"79,873 "},{"v":78797,"d":"78,797 "},{"v":77388,"d":"77,388 "},{"v":12184,"d":"12,184 "},{"v":12972,"d":"12,972 "},{"v":12812,"d":"12,812 "},{"v":13149,"d":"13,149 "},{"v":13691,"d":"13,691 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":52619,"d":"52,619 "},{"v":55111,"d":"55,111 "},{"v":55679,"d":"55,679 "},{"v":54453,"d":"54,453 "},{"v":55670,"d":"55,670 "},{"v":5655,"d":"5,655 "},{"v":5728,"d":"5,728 "},{"v":6206,"d":"6,206 "},{"v":5835,"d":"5,835 "},{"v":5788,"d":"5,788 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":237002,"d":"237,002 "},{"v":263250,"d":"263,250 "},{"v":247052,"d":"247,052 "},{"v":250275,"d":"250,275 "},{"v":251376,"d":"251,376 "},{"v":23614,"d":"23,614 "},{"v":24334,"d":"24,334 "},{"v":24685,"d":"24,685 "},{"v":24433,"d":"24,433 "},{"v":24480,"d":"24,480 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":37480,"d":"37,480 "},{"v":36457,"d":"36,457 "},{"v":38786,"d":"38,786 "},{"v":40566,"d":"40,566 "},{"v":40102,"d":"40,102 "},{"v":4263,"d":"4,263 "},{"v":4237,"d":"4,237 "},{"v":4278,"d":"4,278 "},{"v":4114,"d":"4,114 "},{"v":4452,"d":"4,452 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":398270,"d":"398,270 "},{"v":423050,"d":"423,050 "},{"v":421389,"d":"421,389 "},{"v":424091,"d":"424,091 "},{"v":424536,"d":"424,536 "},{"v":45716,"d":"45,716 "},{"v":47272,"d":"47,272 "},{"v":47982,"d":"47,982 "},{"v":47530,"d":"47,530 "},{"v":48411,"d":"48,411 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":650735,"d":"650,735 "},{"v":659074,"d":"659,074 "},{"v":665171,"d":"665,171 "},{"v":674556,"d":"674,556 "},{"v":687358,"d":"687,358 "},{"v":139290,"d":"139,290 "},{"v":139577,"d":"139,577 "},{"v":141124,"d":"141,124 "},{"v":141498,"d":"141,498 "},{"v":142329,"d":"142,329 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":75746,"d":"75,746 "},{"v":76963,"d":"76,963 "},{"v":77851,"d":"77,851 "},{"v":78485,"d":"78,485 "},{"v":79158,"d":"79,158 "},{"v":11174,"d":"11,174 "},{"v":11165,"d":"11,165 "},{"v":11310,"d":"11,310 "},{"v":11407,"d":"11,407 "},{"v":11331,"d":"11,331 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":319924,"d":"319,924 "},{"v":326515,"d":"326,515 "},{"v":328331,"d":"328,331 "},{"v":336319,"d":"336,319 "},{"v":344162,"d":"344,162 "},{"v":73493,"d":"73,493 "},{"v":74239,"d":"74,239 "},{"v":75266,"d":"75,266 "},{"v":76537,"d":"76,537 "},{"v":77225,"d":"77,225 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":406557,"d":"406,557 "},{"v":409522,"d":"409,522 "},{"v":414691,"d":"414,691 "},{"v":416722,"d":"416,722 "},{"v":422354,"d":"422,354 "},{"v":76971,"d":"76,971 "},{"v":76504,"d":"76,504 "},{"v":77167,"d":"77,167 "},{"v":76368,"d":"76,368 "},{"v":76436,"d":"76,436 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":330462,"d":"330,462 "},{"v":337492,"d":"337,492 "},{"v":350464,"d":"350,464 "},{"v":350912,"d":"350,912 "},{"v":352612,"d":"352,612 "},{"v":22187,"d":"22,187 "},{"v":22182,"d":"22,182 "},{"v":22551,"d":"22,551 "},{"v":23890,"d":"23,890 "},{"v":24511,"d":"24,511 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1135288,"d":"1,135,288 "},{"v":1170064,"d":"1,170,064 "},{"v":1186544,"d":"1,186,544 "},{"v":1191725,"d":"1,191,725 "},{"v":1199503,"d":"1,199,503 "},{"v":144874,"d":"144,874 "},{"v":145957,"d":"145,957 "},{"v":147701,"d":"147,701 "},{"v":147788,"d":"147,788 "},{"v":149358,"d":"149,358 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":12988,"d":"12,988 "},{"v":12794,"d":"12,794 "},{"v":13570,"d":"13,570 "},{"v":15188,"d":"15,188 "},{"v":15095,"d":"15,095 "},{"v":329,"d":"329 "},{"v":315,"d":"315 "},{"v":368,"d":"368 "},{"v":474,"d":"474 "},{"v":324,"d":"324 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":10468,"d":"10,468 "},{"v":13896,"d":"13,896 "},{"v":13862,"d":"13,862 "},{"v":14010,"d":"14,010 "},{"v":16734,"d":"16,734 "},{"v":113,"d":"113 "},{"v":145,"d":"145 "},{"v":336,"d":"336 "},{"v":252,"d":"252 "},{"v":218,"d":"218 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":152092,"d":"152,092 "},{"v":169718,"d":"169,718 "},{"v":161922,"d":"161,922 "},{"v":162464,"d":"162,464 "},{"v":165324,"d":"165,324 "},{"v":20727,"d":"20,727 "},{"v":21011,"d":"21,011 "},{"v":21251,"d":"21,251 "},{"v":20888,"d":"20,888 "},{"v":20826,"d":"20,826 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":5294,"d":"5,294 "},{"v":4130,"d":"4,130 "},{"v":7491,"d":"7,491 "},{"v":7328,"d":"7,328 "},{"v":3565,"d":"3,565 "},{"v":857,"d":"857 "},{"v":752,"d":"752 "},{"v":781,"d":"781 "},{"v":921,"d":"921 "},{"v":730,"d":"730 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":3890,"d":"3,890 "},{"v":4211,"d":"4,211 "},{"v":4210,"d":"4,210 "},{"v":4493,"d":"4,493 "},{"v":5032,"d":"5,032 "},{"v":345,"d":"345 "},{"v":455,"d":"455 "},{"v":422,"d":"422 "},{"v":439,"d":"439 "},{"v":516,"d":"516 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":17751,"d":"17,751 "},{"v":18178,"d":"18,178 "},{"v":17573,"d":"17,573 "},{"v":16141,"d":"16,141 "},{"v":17034,"d":"17,034 "},{"v":2554,"d":"2,554 "},{"v":2020,"d":"2,020 "},{"v":3849,"d":"3,849 "},{"v":3053,"d":"3,053 "},{"v":3972,"d":"3,972 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":110621,"d":"110,621 "},{"v":111697,"d":"111,697 "},{"v":113045,"d":"113,045 "},{"v":117286,"d":"117,286 "},{"v":115919,"d":"115,919 "},{"v":15821,"d":"15,821 "},{"v":15931,"d":"15,931 "},{"v":15670,"d":"15,670 "},{"v":16486,"d":"16,486 "},{"v":16594,"d":"16,594 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":313102,"d":"313,102 "},{"v":334623,"d":"334,623 "},{"v":331673,"d":"331,673 "},{"v":336911,"d":"336,911 "},{"v":338704,"d":"338,704 "},{"v":40746,"d":"40,746 "},{"v":40629,"d":"40,629 "},{"v":42677,"d":"42,677 "},{"v":42512,"d":"42,512 "},{"v":43181,"d":"43,181 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":61038,"d":"61,038 "},{"v":62849,"d":"62,849 "},{"v":61748,"d":"61,748 "},{"v":62818,"d":"62,818 "},{"v":63007,"d":"63,007 "},{"v":7015,"d":"7,015 "},{"v":7598,"d":"7,598 "},{"v":7184,"d":"7,184 "},{"v":7769,"d":"7,769 "},{"v":7907,"d":"7,907 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":191230,"d":"191,230 "},{"v":194967,"d":"194,967 "},{"v":195408,"d":"195,408 "},{"v":203412,"d":"203,412 "},{"v":203957,"d":"203,957 "},{"v":28175,"d":"28,175 "},{"v":28038,"d":"28,038 "},{"v":27334,"d":"27,334 "},{"v":26576,"d":"26,576 "},{"v":25806,"d":"25,806 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":109230,"d":"109,230 "},{"v":110281,"d":"110,281 "},{"v":118025,"d":"118,025 "},{"v":118481,"d":"118,481 "},{"v":117708,"d":"117,708 "},{"v":20857,"d":"20,857 "},{"v":21224,"d":"21,224 "},{"v":21504,"d":"21,504 "},{"v":21783,"d":"21,783 "},{"v":21164,"d":"21,164 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":674600,"d":"674,600 "},{"v":702720,"d":"702,720 "},{"v":706853,"d":"706,853 "},{"v":721621,"d":"721,621 "},{"v":723376,"d":"723,376 "},{"v":96793,"d":"96,793 "},{"v":97489,"d":"97,489 "},{"v":98700,"d":"98,700 "},{"v":98640,"d":"98,640 "},{"v":98058,"d":"98,058 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":104715,"d":"104,715 "},{"v":105335,"d":"105,335 "},{"v":107702,"d":"107,702 "},{"v":101934,"d":"101,934 "},{"v":96860,"d":"96,860 "},{"v":9608,"d":"9,608 "},{"v":9601,"d":"9,601 "},{"v":9763,"d":"9,763 "},{"v":9384,"d":"9,384 "},{"v":9586,"d":"9,586 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":355974,"d":"355,974 "},{"v":362009,"d":"362,009 "},{"v":371989,"d":"371,989 "},{"v":368170,"d":"368,170 "},{"v":379267,"d":"379,267 "},{"v":38473,"d":"38,473 "},{"v":38867,"d":"38,867 "},{"v":39238,"d":"39,238 "},{"v":39764,"d":"39,764 "},{"v":41714,"d":"41,714 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":460688,"d":"460,688 "},{"v":467344,"d":"467,344 "},{"v":479691,"d":"479,691 "},{"v":470104,"d":"470,104 "},{"v":476126,"d":"476,126 "},{"v":48081,"d":"48,081 "},{"v":48468,"d":"48,468 "},{"v":49001,"d":"49,001 "},{"v":49148,"d":"49,148 "},{"v":51300,"d":"51,300 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1135288,"d":"1,135,288 "},{"v":1170064,"d":"1,170,064 "},{"v":1186544,"d":"1,186,544 "},{"v":1191725,"d":"1,191,725 "},{"v":1199503,"d":"1,199,503 "},{"v":144874,"d":"144,874 "},{"v":145957,"d":"145,957 "},{"v":147701,"d":"147,701 "},{"v":147788,"d":"147,788 "},{"v":149358,"d":"149,358 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":85168,"d":"85,168 "},{"v":88427,"d":"88,427 "},{"v":89716,"d":"89,716 "},{"v":87180,"d":"87,180 "},{"v":85832,"d":"85,832 "},{"v":4971,"d":"4,971 "},{"v":6642,"d":"6,642 "},{"v":5304,"d":"5,304 "},{"v":5018,"d":"5,018 "},{"v":5230,"d":"5,230 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",6.27,5.83,6.73,6.61,6.45,8.41,8.89,8.67,{"v":8.9,"d":"8.90"},9.17]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",4.63,4.71,4.69,4.57,4.64,{"v":3.9,"d":"3.90"},3.92,{"v":4.2,"d":"4.20"},3.95,3.88]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",20.88,{"v":22.5,"d":"22.50"},20.82,{"v":21,"d":"21.00"},20.96,{"v":16.3,"d":"16.30"},16.67,16.71,16.53,16.39]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",35.08,36.16,35.51,35.59,35.39,31.56,32.39,32.49,32.16,32.41]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",35.81,{"v":35,"d":"35.00"},34.95,34.97,35.21,53.13,52.42,52.25,51.67,51.18]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",3.97,4.19,4.15,4.18,4.49,2.31,2.01,3.37,2.85,3.37]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",27.58,{"v":28.6,"d":"28.60"},27.95,28.27,28.24,28.12,27.84,28.89,28.77,28.91]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.22,22.03,21.67,22.34,22.26,24.29,24.42,23.37,23.24,22.57]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",59.42,60.06,59.57,60.55,60.31,66.81,66.79,66.82,66.74,65.65]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",40.58,39.94,40.43,39.45,39.69,33.19,33.21,33.18,33.26,34.35]
["  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-2013Q2","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 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 1Q_\n 2013_"," 2Q_\n 2013_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 1Q_\n 2013_"," 2Q_\n 2013_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":199542,"d":"199,542 "},{"v":199303,"d":"199,303 "},{"v":234735,"d":"234,735 "},{"v":203634,"d":"203,634 "},{"v":206571,"d":"206,571 "},{"v":284072,"d":"284,072 "},{"v":280780,"d":"280,780 "},{"v":297264,"d":"297,264 "},{"v":288493,"d":"288,493 "},{"v":305392,"d":"305,392 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":4709,"d":"4,709 "},{"v":4699,"d":"4,699 "},{"v":4737,"d":"4,737 "},{"v":4739,"d":"4,739 "},{"v":4774,"d":"4,774 "},{"v":4267,"d":"4,267 "},{"v":4339,"d":"4,339 "},{"v":4479,"d":"4,479 "},{"v":4559,"d":"4,559 "},{"v":4646,"d":"4,646 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":184139,"d":"184,139 "},{"v":185904,"d":"185,904 "},{"v":214340,"d":"214,340 "},{"v":186882,"d":"186,882 "},{"v":190237,"d":"190,237 "},{"v":266268,"d":"266,268 "},{"v":264417,"d":"264,417 "},{"v":278053,"d":"278,053 "},{"v":270704,"d":"270,704 "},{"v":284252,"d":"284,252 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":10694,"d":"10,694 "},{"v":8699,"d":"8,699 "},{"v":15657,"d":"15,657 "},{"v":12013,"d":"12,013 "},{"v":11560,"d":"11,560 "},{"v":13537,"d":"13,537 "},{"v":12024,"d":"12,024 "},{"v":14733,"d":"14,733 "},{"v":13230,"d":"13,230 "},{"v":16495,"d":"16,495 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1533,"d":"1,533 "},{"v":1551,"d":"1,551 "},{"v":1467,"d":"1,467 "},{"v":1957,"d":"1,957 "},{"v":1511,"d":"1,511 "},{"v":1927,"d":"1,927 "},{"v":1971,"d":"1,971 "},{"v":2013,"d":"2,013 "},{"v":1961,"d":"1,961 "},{"v":1812,"d":"1,812 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":2835,"d":"2,835 "},{"v":4047,"d":"4,047 "},{"v":3333,"d":"3,333 "},{"v":1812,"d":"1,812 "},{"v":2090,"d":"2,090 "},{"v":1417,"d":"1,417 "},{"v":-353,"d":"(353)"},{"v":970,"d":"970 "},{"v":428,"d":"428 "},{"v":1074,"d":"1,074 "}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":11997,"d":"11,997 "},{"v":11195,"d":"11,195 "},{"v":17523,"d":"17,523 "},{"v":11868,"d":"11,868 "},{"v":12138,"d":"12,138 "},{"v":13027,"d":"13,027 "},{"v":9700,"d":"9,700 "},{"v":13690,"d":"13,690 "},{"v":11697,"d":"11,697 "},{"v":15756,"d":"15,756 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":3898,"d":"3,898 "},{"v":3637,"d":"3,637 "},{"v":5207,"d":"5,207 "},{"v":3917,"d":"3,917 "},{"v":4220,"d":"4,220 "},{"v":4111,"d":"4,111 "},{"v":3830,"d":"3,830 "},{"v":4257,"d":"4,257 "},{"v":3761,"d":"3,761 "},{"v":4886,"d":"4,886 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":8099,"d":"8,099 "},{"v":7558,"d":"7,558 "},{"v":12317,"d":"12,317 "},{"v":7952,"d":"7,952 "},{"v":7918,"d":"7,918 "},{"v":8916,"d":"8,916 "},{"v":5870,"d":"5,870 "},{"v":9433,"d":"9,433 "},{"v":7936,"d":"7,936 "},{"v":10870,"d":"10,870 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":959,"d":"959 "},{"v":2274,"d":"2,274 "},{"v":3522,"d":"3,522 "},{"v":10695,"d":"10,695 "},{"v":1814,"d":"1,814 "},{"v":2399,"d":"2,399 "},{"v":1887,"d":"1,887 "},{"v":2459,"d":"2,459 "},{"v":2285,"d":"2,285 "},{"v":3178,"d":"3,178 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":7139,"d":"7,139 "},{"v":5285,"d":"5,285 "},{"v":8795,"d":"8,795 "},{"v":-2744,"d":"(2,744)"},{"v":6104,"d":"6,104 "},{"v":6518,"d":"6,518 "},{"v":3983,"d":"3,983 "},{"v":6974,"d":"6,974 "},{"v":5651,"d":"5,651 "},{"v":7692,"d":"7,692 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":155387,"d":"155,387 "},{"v":159715,"d":"159,715 "},{"v":163693,"d":"163,693 "},{"v":166884,"d":"166,884 "},{"v":161001,"d":"161,001 "},{"v":159547,"d":"159,547 "},{"v":158246,"d":"158,246 "},{"v":158882,"d":"158,882 "},{"v":165286,"d":"165,286 "},{"v":167835,"d":"167,835 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-3546,"d":"(3,546)"},{"v":-2543,"d":"(2,543)"},{"v":-4681,"d":"(4,681)"},{"v":-3523,"d":"(3,523)"},{"v":-3353,"d":"(3,353)"},{"v":-7545,"d":"(7,545)"},{"v":-1543,"d":"(1,543)"},{"v":-912,"d":"(912)"},{"v":-3148,"d":"(3,148)"},{"v":-1727,"d":"(1,727)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":158981,"d":"158,981 "},{"v":162456,"d":"162,456 "},{"v":167807,"d":"167,807 "},{"v":160617,"d":"160,617 "},{"v":163752,"d":"163,752 "},{"v":158519,"d":"158,519 "},{"v":160686,"d":"160,686 "},{"v":164944,"d":"164,944 "},{"v":167788,"d":"167,788 "},{"v":173801,"d":"173,801 "}]
["                         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.36,2.02,2.33,2.31,{"v":1.5,"d":"1.50"},1.55,1.51,1.58,1.52]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",92.28,93.28,91.31,91.77,92.09,93.73,94.17,93.54,93.83,93.08]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",5.36,4.36,6.67,{"v":5.9,"d":"5.90"},{"v":5.6,"d":"5.60"},4.77,4.28,4.96,4.59,{"v":5.4,"d":"5.40"}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.77,0.78,0.62,0.96,0.73,0.68,{"v":0.7,"d":"0.70"},0.68,0.68,0.59]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",1.42,2.03,1.42,0.89,1.01,{"v":0.5,"d":"0.50"},{"v":-0.13,"d":"(0.13)"},0.33,0.15,0.35]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",6.01,5.62,7.47,5.83,5.88,4.59,3.45,4.61,4.05,5.16]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.95,1.82,2.22,1.92,2.04,1.45,1.36,1.43,{"v":1.3,"d":"1.30"},{"v":1.6,"d":"1.60"}]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",4.06,3.79,5.25,{"v":3.9,"d":"3.90"},3.83,3.14,2.09,3.17,2.75,3.56]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",26.33,{"v":24.2,"d":"24.20"},36.54,26.03,{"v":26.4,"d":"26.40"},22.62,16.59,22.93,19.61,26.16]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",17.78,16.34,25.68,17.44,17.22,15.48,10.04,{"v":15.8,"d":"15.80"},13.31,18.05]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",10.84,9.75,15.46,10.44,10.62,9.51,6.87,9.35,7.94,10.63]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",7.32,6.58,10.87,{"v":7,"d":"7.00"},6.93,6.51,4.16,6.45,5.39,7.33]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.24,{"v":1.2,"d":"1.20"},1.23,1.21,{"v":1.2,"d":"1.20"},1.34,1.34,1.34,1.33,1.33]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.21,0.16,{"v":0.2,"d":"0.20"},{"v":0.2,"d":"0.20"},0.19,0.22,0.21,0.26,0.24,0.24]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.59,1.56,{"v":1.7,"d":"1.70"},1.52,1.51,{"v":1.6,"d":"1.60"},1.56,1.55,1.52,1.51]
["  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-2013Q2","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 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 1Q_\n 2013_"," 2Q_\n 2013_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 1Q_\n 2013_"," 2Q_\n 2013_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":20617,"d":"20,617 "},{"v":17785,"d":"17,785 "},{"v":20056,"d":"20,056 "},{"v":19421,"d":"19,421 "},{"v":19652,"d":"19,652 "},{"v":23907,"d":"23,907 "},{"v":25230,"d":"25,230 "},{"v":31184,"d":"31,184 "},{"v":29226,"d":"29,226 "},{"v":27792,"d":"27,792 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":430,"d":"430 "},{"v":412,"d":"412 "},{"v":363,"d":"363 "},{"v":597,"d":"597 "},{"v":339,"d":"339 "},{"v":2686,"d":"2,686 "},{"v":1254,"d":"1,254 "},{"v":708,"d":"708 "},{"v":1118,"d":"1,118 "},{"v":1345,"d":"1,345 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":21047,"d":"21,047 "},{"v":18197,"d":"18,197 "},{"v":20419,"d":"20,419 "},{"v":20017,"d":"20,017 "},{"v":19991,"d":"19,991 "},{"v":26593,"d":"26,593 "},{"v":26484,"d":"26,484 "},{"v":31892,"d":"31,892 "},{"v":30344,"d":"30,344 "},{"v":29137,"d":"29,137 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4708,"d":"4,708 "},{"v":3884,"d":"3,884 "},{"v":3891,"d":"3,891 "},{"v":5373,"d":"5,373 "},{"v":4729,"d":"4,729 "},{"v":6638,"d":"6,638 "},{"v":6695,"d":"6,695 "},{"v":10858,"d":"10,858 "},{"v":9913,"d":"9,913 "},{"v":9840,"d":"9,840 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":25755,"d":"25,755 "},{"v":22081,"d":"22,081 "},{"v":24310,"d":"24,310 "},{"v":25390,"d":"25,390 "},{"v":24720,"d":"24,720 "},{"v":33231,"d":"33,231 "},{"v":33179,"d":"33,179 "},{"v":42750,"d":"42,750 "},{"v":40258,"d":"40,258 "},{"v":38977,"d":"38,977 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":6730,"d":"6,730 "},{"v":7204,"d":"7,204 "},{"v":7737,"d":"7,737 "},{"v":7429,"d":"7,429 "},{"v":7504,"d":"7,504 "},{"v":40234,"d":"40,234 "},{"v":42179,"d":"42,179 "},{"v":41736,"d":"41,736 "},{"v":41189,"d":"41,189 "},{"v":42378,"d":"42,378 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":102226,"d":"102,226 "},{"v":120450,"d":"120,450 "},{"v":105250,"d":"105,250 "},{"v":106587,"d":"106,587 "},{"v":107826,"d":"107,826 "},{"v":111161,"d":"111,161 "},{"v":118465,"d":"118,465 "},{"v":117116,"d":"117,116 "},{"v":119255,"d":"119,255 "},{"v":119070,"d":"119,070 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15473,"d":"15,473 "},{"v":14204,"d":"14,204 "},{"v":16191,"d":"16,191 "},{"v":16144,"d":"16,144 "},{"v":16219,"d":"16,219 "},{"v":17744,"d":"17,744 "},{"v":18016,"d":"18,016 "},{"v":18316,"d":"18,316 "},{"v":20309,"d":"20,309 "},{"v":19431,"d":"19,431 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":150183,"d":"150,183 "},{"v":163940,"d":"163,940 "},{"v":153488,"d":"153,488 "},{"v":155550,"d":"155,550 "},{"v":156268,"d":"156,268 "},{"v":202371,"d":"202,371 "},{"v":211839,"d":"211,839 "},{"v":219919,"d":"219,919 "},{"v":221010,"d":"221,010 "},{"v":219857,"d":"219,857 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":277091,"d":"277,091 "},{"v":280546,"d":"280,546 "},{"v":283399,"d":"283,399 "},{"v":287868,"d":"287,868 "},{"v":293310,"d":"293,310 "},{"v":234353,"d":"234,353 "},{"v":238950,"d":"238,950 "},{"v":240649,"d":"240,649 "},{"v":245190,"d":"245,190 "},{"v":251718,"d":"251,718 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":30586,"d":"30,586 "},{"v":31500,"d":"31,500 "},{"v":31925,"d":"31,925 "},{"v":32187,"d":"32,187 "},{"v":32370,"d":"32,370 "},{"v":33986,"d":"33,986 "},{"v":34298,"d":"34,298 "},{"v":34616,"d":"34,616 "},{"v":34892,"d":"34,892 "},{"v":35457,"d":"35,457 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":126551,"d":"126,551 "},{"v":129165,"d":"129,165 "},{"v":130111,"d":"130,111 "},{"v":133080,"d":"133,080 "},{"v":136746,"d":"136,746 "},{"v":119879,"d":"119,879 "},{"v":123111,"d":"123,111 "},{"v":122954,"d":"122,954 "},{"v":126701,"d":"126,701 "},{"v":130191,"d":"130,191 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":181126,"d":"181,126 "},{"v":182882,"d":"182,882 "},{"v":185212,"d":"185,212 "},{"v":186975,"d":"186,975 "},{"v":188933,"d":"188,933 "},{"v":148460,"d":"148,460 "},{"v":150137,"d":"150,137 "},{"v":152311,"d":"152,311 "},{"v":153380,"d":"153,380 "},{"v":156985,"d":"156,985 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":111359,"d":"111,359 "},{"v":112634,"d":"112,634 "},{"v":114692,"d":"114,692 "},{"v":112168,"d":"112,168 "},{"v":112017,"d":"112,017 "},{"v":196916,"d":"196,916 "},{"v":202676,"d":"202,676 "},{"v":213221,"d":"213,221 "},{"v":214854,"d":"214,854 "},{"v":216084,"d":"216,084 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":442668,"d":"442,668 "},{"v":459456,"d":"459,456 "},{"v":453392,"d":"453,392 "},{"v":454692,"d":"454,692 "},{"v":457219,"d":"457,219 "},{"v":547747,"d":"547,747 "},{"v":564652,"d":"564,652 "},{"v":585451,"d":"585,451 "},{"v":589244,"d":"589,244 "},{"v":592926,"d":"592,926 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1042,"d":"1,042 "},{"v":1295,"d":"1,295 "},{"v":967,"d":"967 "},{"v":1187,"d":"1,187 "},{"v":1202,"d":"1,202 "},{"v":11616,"d":"11,616 "},{"v":11184,"d":"11,184 "},{"v":12234,"d":"12,234 "},{"v":13528,"d":"13,528 "},{"v":13569,"d":"13,569 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":6819,"d":"6,819 "},{"v":10090,"d":"10,090 "},{"v":8664,"d":"8,664 "},{"v":9001,"d":"9,001 "},{"v":11331,"d":"11,331 "},{"v":3536,"d":"3,536 "},{"v":3661,"d":"3,661 "},{"v":4862,"d":"4,862 "},{"v":4757,"d":"4,757 "},{"v":5185,"d":"5,185 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":57393,"d":"57,393 "},{"v":68528,"d":"68,528 "},{"v":58750,"d":"58,750 "},{"v":60611,"d":"60,611 "},{"v":62073,"d":"62,073 "},{"v":73972,"d":"73,972 "},{"v":80179,"d":"80,179 "},{"v":81921,"d":"81,921 "},{"v":80965,"d":"80,965 "},{"v":82425,"d":"82,425 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":2074,"d":"2,074 "},{"v":1536,"d":"1,536 "},{"v":3963,"d":"3,963 "},{"v":3697,"d":"3,697 "},{"v":1037,"d":"1,037 "},{"v":2363,"d":"2,363 "},{"v":1842,"d":"1,842 "},{"v":2747,"d":"2,747 "},{"v":2710,"d":"2,710 "},{"v":1799,"d":"1,799 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":243,"d":"243 "},{"v":257,"d":"257 "},{"v":281,"d":"281 "},{"v":216,"d":"216 "},{"v":265,"d":"265 "},{"v":3302,"d":"3,302 "},{"v":3499,"d":"3,499 "},{"v":3507,"d":"3,507 "},{"v":3838,"d":"3,838 "},{"v":4251,"d":"4,251 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":8179,"d":"8,179 "},{"v":9274,"d":"9,274 "},{"v":5971,"d":"5,971 "},{"v":6381,"d":"6,381 "},{"v":6796,"d":"6,796 "},{"v":7018,"d":"7,018 "},{"v":6885,"d":"6,885 "},{"v":7753,"d":"7,753 "},{"v":6706,"d":"6,706 "},{"v":6266,"d":"6,266 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":45378,"d":"45,378 "},{"v":45368,"d":"45,368 "},{"v":45771,"d":"45,771 "},{"v":47313,"d":"47,313 "},{"v":47406,"d":"47,406 "},{"v":49421,"d":"49,421 "},{"v":50398,"d":"50,398 "},{"v":51603,"d":"51,603 "},{"v":53487,"d":"53,487 "},{"v":51919,"d":"51,919 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":121128,"d":"121,128 "},{"v":136348,"d":"136,348 "},{"v":124368,"d":"124,368 "},{"v":128407,"d":"128,407 "},{"v":130109,"d":"130,109 "},{"v":151228,"d":"151,228 "},{"v":157646,"d":"157,646 "},{"v":164627,"d":"164,627 "},{"v":165991,"d":"165,991 "},{"v":165414,"d":"165,414 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":14529,"d":"14,529 "},{"v":15342,"d":"15,342 "},{"v":15304,"d":"15,304 "},{"v":14901,"d":"14,901 "},{"v":13948,"d":"13,948 "},{"v":39494,"d":"39,494 "},{"v":39909,"d":"39,909 "},{"v":39261,"d":"39,261 "},{"v":40148,"d":"40,148 "},{"v":41152,"d":"41,152 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":83636,"d":"83,636 "},{"v":82395,"d":"82,395 "},{"v":81554,"d":"81,554 "},{"v":88448,"d":"88,448 "},{"v":88527,"d":"88,527 "},{"v":79419,"d":"79,419 "},{"v":84534,"d":"84,534 "},{"v":86519,"d":"86,519 "},{"v":88388,"d":"88,388 "},{"v":89625,"d":"89,625 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":41142,"d":"41,142 "},{"v":40361,"d":"40,361 "},{"v":40316,"d":"40,316 "},{"v":40546,"d":"40,546 "},{"v":40719,"d":"40,719 "},{"v":47231,"d":"47,231 "},{"v":48696,"d":"48,696 "},{"v":56205,"d":"56,205 "},{"v":56152,"d":"56,152 "},{"v":55825,"d":"55,825 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":260435,"d":"260,435 "},{"v":274446,"d":"274,446 "},{"v":261542,"d":"261,542 "},{"v":272301,"d":"272,301 "},{"v":273302,"d":"273,302 "},{"v":317372,"d":"317,372 "},{"v":330785,"d":"330,785 "},{"v":346612,"d":"346,612 "},{"v":350679,"d":"350,679 "},{"v":352016,"d":"352,016 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":23251,"d":"23,251 "},{"v":22553,"d":"22,553 "},{"v":24044,"d":"24,044 "},{"v":21774,"d":"21,774 "},{"v":20165,"d":"20,165 "},{"v":71855,"d":"71,855 "},{"v":73181,"d":"73,181 "},{"v":73895,"d":"73,895 "},{"v":70777,"d":"70,777 "},{"v":67109,"d":"67,109 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":158981,"d":"158,981 "},{"v":162456,"d":"162,456 "},{"v":167807,"d":"167,807 "},{"v":160617,"d":"160,617 "},{"v":163752,"d":"163,752 "},{"v":158519,"d":"158,519 "},{"v":160686,"d":"160,686 "},{"v":164944,"d":"164,944 "},{"v":167788,"d":"167,788 "},{"v":173801,"d":"173,801 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":182232,"d":"182,232 "},{"v":185010,"d":"185,010 "},{"v":191851,"d":"191,851 "},{"v":182391,"d":"182,391 "},{"v":183917,"d":"183,917 "},{"v":230375,"d":"230,375 "},{"v":233867,"d":"233,867 "},{"v":238839,"d":"238,839 "},{"v":238565,"d":"238,565 "},{"v":240909,"d":"240,909 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":442668,"d":"442,668 "},{"v":459456,"d":"459,456 "},{"v":453392,"d":"453,392 "},{"v":454692,"d":"454,692 "},{"v":457219,"d":"457,219 "},{"v":547747,"d":"547,747 "},{"v":564652,"d":"564,652 "},{"v":585451,"d":"585,451 "},{"v":589244,"d":"589,244 "},{"v":592926,"d":"592,926 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":29055,"d":"29,055 "},{"v":27592,"d":"27,592 "},{"v":29120,"d":"29,120 "},{"v":27143,"d":"27,143 "},{"v":26159,"d":"26,159 "},{"v":51143,"d":"51,143 "},{"v":54193,"d":"54,193 "},{"v":55291,"d":"55,291 "},{"v":55019,"d":"55,019 "},{"v":54443,"d":"54,443 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",5.82,4.81,5.36,5.58,5.41,6.07,5.88,{"v":7.3,"d":"7.30"},6.83,6.57]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",1.52,1.57,1.71,1.63,1.64,7.35,7.47,7.13,6.99,7.15]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",23.09,26.22,23.21,23.44,23.58,20.29,20.98,{"v":20,"d":"20.00"},20.24,20.08]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",33.93,35.68,33.85,34.21,34.18,36.95,37.52,37.56,37.51,37.08]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",40.92,{"v":39.8,"d":"39.80"},40.85,41.12,41.32,{"v":27.1,"d":"27.10"},26.59,26.02,26.03,26.48]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",3.68,4.55,{"v":3.5,"d":"3.50"},3.69,4.29,4.65,4.47,4.84,4.89,4.94]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",27.36,29.68,27.43,28.24,28.46,27.61,27.92,28.12,28.17,{"v":27.9,"d":"27.90"}]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.18,21.27,21.36,22.73,22.41,21.71,22.04,21.48,21.81,22.06]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",58.83,59.73,57.69,59.89,59.77,57.94,58.58,{"v":59.2,"d":"59.20"},59.51,59.37]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",41.17,40.27,42.31,40.11,40.23,42.06,41.42,{"v":40.8,"d":"40.80"},40.49,40.63]
["  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-2013Q2","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"]
["2002 …………………………………………………………………………………………...………………………………………………..",{"v":349273,"d":"349,273 "},{"v":355152,"d":"355,152 "},{"v":359369,"d":"359,369 "},{"v":357303,"d":"357,303 "}]
["2003 …………………………………………………………………………………………...………………………………………………..",{"v":366945,"d":"366,945 "},{"v":369855,"d":"369,855 "},{"v":391318,"d":"391,318 "},{"v":398978,"d":"398,978 "}]
["2004 …………………………………………………………………………………………...………………………………………………..",{"v":407060,"d":"407,060 "},{"v":410454,"d":"410,454 "},{"v":421552,"d":"421,552 "},{"v":427339,"d":"427,339 "}]
["2005 …………………………………………………………………………………………...………………………………………………..",{"v":438459,"d":"438,459 "},{"v":447470,"d":"447,470 "},{"v":458408,"d":"458,408 "},{"v":467777,"d":"467,777 "}]
["2006 …………………………………………………………………………………………...………………………………………………..",{"v":480669,"d":"480,669 "},{"v":492754,"d":"492,754 "},{"v":497525,"d":"497,525 "},{"v":502017,"d":"502,017 "}]
["2007 …………………………………………………………………………………………...………………………………………………..",{"v":510019,"d":"510,019 "},{"v":514631,"d":"514,631 "},{"v":515898,"d":"515,898 "},{"v":521311,"d":"521,311 "}]
["2008 …………………………………………………………………………………………...………………………………………………..",{"v":523310,"d":"523,310 "},{"v":536133,"d":"536,133 "},{"v":531367,"d":"531,367 "},{"v":501553,"d":"501,553 "}]
["2009 …………………………………………………………………………………………...………………………………………………..",{"v":495498,"d":"495,498 "},{"v":494957,"d":"494,957 "},{"v":508492,"d":"508,492 "},{"v":520954,"d":"520,954 "}]
["2010 …………………………………………………………………………………………...………………………………………………..",{"v":531264,"d":"531,264 "},{"v":534399,"d":"534,399 "},{"v":539779,"d":"539,779 "},{"v":552372,"d":"552,372 "}]
["2011 …………………………………………………………………………………………...………………………………………………..",{"v":565658,"d":"565,658 "},{"v":584802,"d":"584,802 "},{"v":586459,"d":"586,459 "},{"v":588502,"d":"588,502 "}]
["2012 …………………………………………………………………………………………...………………………………………………..",{"v":600978,"d":"600,978 "},{"v":597613,"d":"597,613 "},{"v":604071,"d":"604,071 "},{"v":613965,"d":"613,965 "}]
["2013 …………………………………………………………………………………………...………………………………………………..",{"v":615352,"d":"615,352 "},{"v":626698,"d":"626,698 "}]
[]
["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."]