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

{"sheet":"RET_4_0-2013Q1","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"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 1Q_\n 2013_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 1Q_\n 2013_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":589462,"d":"589,462 "},{"v":594015,"d":"594,015 "},{"v":590120,"d":"590,120 "},{"v":642826,"d":"642,826 "},{"v":603857,"d":"603,857 "},{"v":109126,"d":"109,126 "},{"v":110268,"d":"110,268 "},{"v":109832,"d":"109,832 "},{"v":111712,"d":"111,712 "},{"v":111222,"d":"111,222 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":10764,"d":"10,764 "},{"v":11232,"d":"11,232 "},{"v":11233,"d":"11,233 "},{"v":11405,"d":"11,405 "},{"v":11439,"d":"11,439 "},{"v":2050,"d":"2,050 "},{"v":2255,"d":"2,255 "},{"v":2189,"d":"2,189 "},{"v":2189,"d":"2,189 "},{"v":2120,"d":"2,120 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":551062,"d":"551,062 "},{"v":555040,"d":"555,040 "},{"v":554984,"d":"554,984 "},{"v":597483,"d":"597,483 "},{"v":563809,"d":"563,809 "},{"v":103764,"d":"103,764 "},{"v":104503,"d":"104,503 "},{"v":104665,"d":"104,665 "},{"v":106017,"d":"106,017 "},{"v":106042,"d":"106,042 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":27636,"d":"27,636 "},{"v":27743,"d":"27,743 "},{"v":23903,"d":"23,903 "},{"v":33938,"d":"33,938 "},{"v":28609,"d":"28,609 "},{"v":3312,"d":"3,312 "},{"v":3510,"d":"3,510 "},{"v":2978,"d":"2,978 "},{"v":3506,"d":"3,506 "},{"v":3060,"d":"3,060 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4194,"d":"4,194 "},{"v":4204,"d":"4,204 "},{"v":4283,"d":"4,283 "},{"v":4242,"d":"4,242 "},{"v":4678,"d":"4,678 "},{"v":755,"d":"755 "},{"v":744,"d":"744 "},{"v":764,"d":"764 "},{"v":753,"d":"753 "},{"v":749,"d":"749 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1142,"d":"1,142 "},{"v":4501,"d":"4,501 "},{"v":3700,"d":"3,700 "},{"v":3989,"d":"3,989 "},{"v":899,"d":"899 "},{"v":-561,"d":"(561)"},{"v":248,"d":"248 "},{"v":246,"d":"246 "},{"v":-174,"d":"(174)"},{"v":-1341,"d":"(1,341)"}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":24584,"d":"24,584 "},{"v":28040,"d":"28,040 "},{"v":23321,"d":"23,321 "},{"v":33685,"d":"33,685 "},{"v":24830,"d":"24,830 "},{"v":1996,"d":"1,996 "},{"v":3014,"d":"3,014 "},{"v":2460,"d":"2,460 "},{"v":2579,"d":"2,579 "},{"v":971,"d":"971 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":8816,"d":"8,816 "},{"v":8971,"d":"8,971 "},{"v":8202,"d":"8,202 "},{"v":10247,"d":"10,247 "},{"v":8563,"d":"8,563 "},{"v":927,"d":"927 "},{"v":962,"d":"962 "},{"v":757,"d":"757 "},{"v":911,"d":"911 "},{"v":867,"d":"867 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15768,"d":"15,768 "},{"v":19069,"d":"19,069 "},{"v":15118,"d":"15,118 "},{"v":23438,"d":"23,438 "},{"v":16267,"d":"16,267 "},{"v":1069,"d":"1,069 "},{"v":2052,"d":"2,052 "},{"v":1703,"d":"1,703 "},{"v":1668,"d":"1,668 "},{"v":104,"d":"104 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":9372,"d":"9,372 "},{"v":3892,"d":"3,892 "},{"v":4479,"d":"4,479 "},{"v":7412,"d":"7,412 "},{"v":13803,"d":"13,803 "},{"v":787,"d":"787 "},{"v":533,"d":"533 "},{"v":267,"d":"267 "},{"v":1401,"d":"1,401 "},{"v":552,"d":"552 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":6397,"d":"6,397 "},{"v":15177,"d":"15,177 "},{"v":10640,"d":"10,640 "},{"v":16026,"d":"16,026 "},{"v":2464,"d":"2,464 "},{"v":283,"d":"283 "},{"v":1519,"d":"1,519 "},{"v":1436,"d":"1,436 "},{"v":266,"d":"266 "},{"v":-448,"d":"(448)"}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":358976,"d":"358,976 "},{"v":352020,"d":"352,020 "},{"v":355673,"d":"355,673 "},{"v":361107,"d":"361,107 "},{"v":371670,"d":"371,670 "},{"v":33971,"d":"33,971 "},{"v":37060,"d":"37,060 "},{"v":37593,"d":"37,593 "},{"v":39009,"d":"39,009 "},{"v":39552,"d":"39,552 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-7150,"d":"(7,150)"},{"v":-11196,"d":"(11,196)"},{"v":-4317,"d":"(4,317)"},{"v":-6132,"d":"(6,132)"},{"v":-6800,"d":"(6,800)"},{"v":372,"d":"372 "},{"v":-106,"d":"(106)"},{"v":-218,"d":"(218)"},{"v":-351,"d":"(351)"},{"v":139,"d":"139 "}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":358222,"d":"358,222 "},{"v":356001,"d":"356,001 "},{"v":361995,"d":"361,995 "},{"v":371001,"d":"371,001 "},{"v":367334,"d":"367,334 "},{"v":34626,"d":"34,626 "},{"v":38473,"d":"38,473 "},{"v":38811,"d":"38,811 "},{"v":38924,"d":"38,924 "},{"v":39242,"d":"39,242 "}]
["                         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.83,1.89,{"v":1.9,"d":"1.90"},1.77,1.89,1.88,2.04,1.99,1.96,1.91]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",93.49,93.44,94.05,92.95,93.37,95.09,94.77,{"v":95.3,"d":"95.30"},{"v":94.9,"d":"94.90"},95.34]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",4.69,4.67,4.05,5.28,4.74,3.04,3.18,2.71,3.14,2.75]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.71,0.71,0.73,0.66,0.77,0.69,0.67,{"v":0.7,"d":"0.70"},0.67,0.67]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",0.19,0.76,0.63,0.62,0.15,{"v":-0.51,"d":"(0.51)"},0.22,0.22,{"v":-0.16,"d":"(0.16)"},{"v":-1.21,"d":"(1.21)"}]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",4.17,4.72,3.95,5.24,4.11,1.83,2.73,2.24,2.31,0.87]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",{"v":1.5,"d":"1.50"},1.51,1.39,1.59,1.42,0.85,0.87,0.69,0.82,0.78]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",2.68,3.21,2.56,3.65,2.69,0.98,1.86,1.55,1.49,0.09]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",22.17,24.34,19.96,28.09,{"v":21.1,"d":"21.10"},17.38,25.07,20.32,21.05,7.87]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",14.22,16.56,12.94,19.54,13.82,9.31,17.07,14.07,13.61,0.84]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",8.84,9.88,7.97,11.35,8.33,5.55,8.32,6.74,6.97,2.62]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",5.67,6.72,5.17,{"v":7.9,"d":"7.90"},5.46,2.97,5.67,4.66,4.51,0.28]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.31,1.27,1.27,1.28,1.26,1.09,1.12,1.17,1.12,1.11]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.27,0.23,0.21,0.25,0.23,{"v":0.3,"d":"0.30"},{"v":0.3,"d":"0.30"},0.32,{"v":0.3,"d":"0.30"},0.31]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.52,1.55,1.52,1.56,1.49,1.15,1.25,1.25,1.24,1.28]
["  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-2013Q1","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"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 1Q_\n 2013_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 1Q_\n 2013_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":68255,"d":"68,255 "},{"v":53413,"d":"53,413 "},{"v":52596,"d":"52,596 "},{"v":61688,"d":"61,688 "},{"v":57207,"d":"57,207 "},{"v":10234,"d":"10,234 "},{"v":10103,"d":"10,103 "},{"v":10538,"d":"10,538 "},{"v":10236,"d":"10,236 "},{"v":10787,"d":"10,787 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":2897,"d":"2,897 "},{"v":3434,"d":"3,434 "},{"v":1933,"d":"1,933 "},{"v":1536,"d":"1,536 "},{"v":2163,"d":"2,163 "},{"v":329,"d":"329 "},{"v":318,"d":"318 "},{"v":267,"d":"267 "},{"v":464,"d":"464 "},{"v":432,"d":"432 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":71152,"d":"71,152 "},{"v":56848,"d":"56,848 "},{"v":54528,"d":"54,528 "},{"v":63224,"d":"63,224 "},{"v":59370,"d":"59,370 "},{"v":10563,"d":"10,563 "},{"v":10420,"d":"10,420 "},{"v":10805,"d":"10,805 "},{"v":10700,"d":"10,700 "},{"v":11219,"d":"11,219 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":14948,"d":"14,948 "},{"v":14335,"d":"14,335 "},{"v":14099,"d":"14,099 "},{"v":17987,"d":"17,987 "},{"v":18897,"d":"18,897 "},{"v":1969,"d":"1,969 "},{"v":1763,"d":"1,763 "},{"v":2223,"d":"2,223 "},{"v":2013,"d":"2,013 "},{"v":2192,"d":"2,192 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":86100,"d":"86,100 "},{"v":71183,"d":"71,183 "},{"v":68627,"d":"68,627 "},{"v":81211,"d":"81,211 "},{"v":78267,"d":"78,267 "},{"v":12533,"d":"12,533 "},{"v":12184,"d":"12,184 "},{"v":13028,"d":"13,028 "},{"v":12712,"d":"12,712 "},{"v":13411,"d":"13,411 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":53437,"d":"53,437 "},{"v":52628,"d":"52,628 "},{"v":55059,"d":"55,059 "},{"v":55918,"d":"55,918 "},{"v":55033,"d":"55,033 "},{"v":5368,"d":"5,368 "},{"v":5655,"d":"5,655 "},{"v":5731,"d":"5,731 "},{"v":6169,"d":"6,169 "},{"v":5783,"d":"5,783 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":235037,"d":"235,037 "},{"v":237038,"d":"237,038 "},{"v":263436,"d":"263,436 "},{"v":247235,"d":"247,235 "},{"v":251354,"d":"251,354 "},{"v":23559,"d":"23,559 "},{"v":23614,"d":"23,614 "},{"v":24362,"d":"24,362 "},{"v":24723,"d":"24,723 "},{"v":24346,"d":"24,346 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":37424,"d":"37,424 "},{"v":37482,"d":"37,482 "},{"v":36652,"d":"36,652 "},{"v":38605,"d":"38,605 "},{"v":40913,"d":"40,913 "},{"v":4203,"d":"4,203 "},{"v":4263,"d":"4,263 "},{"v":4214,"d":"4,214 "},{"v":4253,"d":"4,253 "},{"v":4380,"d":"4,380 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":411997,"d":"411,997 "},{"v":398331,"d":"398,331 "},{"v":423774,"d":"423,774 "},{"v":422969,"d":"422,969 "},{"v":425566,"d":"425,566 "},{"v":45662,"d":"45,662 "},{"v":45716,"d":"45,716 "},{"v":47335,"d":"47,335 "},{"v":47856,"d":"47,856 "},{"v":47920,"d":"47,920 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":642373,"d":"642,373 "},{"v":650779,"d":"650,779 "},{"v":658848,"d":"658,848 "},{"v":665184,"d":"665,184 "},{"v":674456,"d":"674,456 "},{"v":138594,"d":"138,594 "},{"v":139290,"d":"139,290 "},{"v":139592,"d":"139,592 "},{"v":141144,"d":"141,144 "},{"v":140751,"d":"140,751 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":74668,"d":"74,668 "},{"v":75750,"d":"75,750 "},{"v":76972,"d":"76,972 "},{"v":77866,"d":"77,866 "},{"v":78438,"d":"78,438 "},{"v":10834,"d":"10,834 "},{"v":11174,"d":"11,174 "},{"v":11165,"d":"11,165 "},{"v":11310,"d":"11,310 "},{"v":11390,"d":"11,390 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":315094,"d":"315,094 "},{"v":319951,"d":"319,951 "},{"v":326542,"d":"326,542 "},{"v":328689,"d":"328,689 "},{"v":335988,"d":"335,988 "},{"v":73419,"d":"73,419 "},{"v":73493,"d":"73,493 "},{"v":74196,"d":"74,196 "},{"v":75179,"d":"75,179 "},{"v":75868,"d":"75,868 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":401947,"d":"401,947 "},{"v":406578,"d":"406,578 "},{"v":409278,"d":"409,278 "},{"v":414361,"d":"414,361 "},{"v":416906,"d":"416,906 "},{"v":76009,"d":"76,009 "},{"v":76971,"d":"76,971 "},{"v":76562,"d":"76,562 "},{"v":77275,"d":"77,275 "},{"v":76274,"d":"76,274 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":297954,"d":"297,954 "},{"v":330191,"d":"330,191 "},{"v":336753,"d":"336,753 "},{"v":349767,"d":"349,767 "},{"v":349482,"d":"349,482 "},{"v":22184,"d":"22,184 "},{"v":22187,"d":"22,187 "},{"v":22184,"d":"22,184 "},{"v":22869,"d":"22,869 "},{"v":24304,"d":"24,304 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1111898,"d":"1,111,898 "},{"v":1135100,"d":"1,135,100 "},{"v":1169804,"d":"1,169,804 "},{"v":1187098,"d":"1,187,098 "},{"v":1191954,"d":"1,191,954 "},{"v":143856,"d":"143,856 "},{"v":144874,"d":"144,874 "},{"v":146080,"d":"146,080 "},{"v":148000,"d":"148,000 "},{"v":148497,"d":"148,497 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":11507,"d":"11,507 "},{"v":13004,"d":"13,004 "},{"v":12810,"d":"12,810 "},{"v":13609,"d":"13,609 "},{"v":15079,"d":"15,079 "},{"v":381,"d":"381 "},{"v":329,"d":"329 "},{"v":315,"d":"315 "},{"v":368,"d":"368 "},{"v":463,"d":"463 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":10384,"d":"10,384 "},{"v":10474,"d":"10,474 "},{"v":13775,"d":"13,775 "},{"v":14145,"d":"14,145 "},{"v":12793,"d":"12,793 "},{"v":92,"d":"92 "},{"v":113,"d":"113 "},{"v":148,"d":"148 "},{"v":358,"d":"358 "},{"v":270,"d":"270 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":151529,"d":"151,529 "},{"v":152110,"d":"152,110 "},{"v":169458,"d":"169,458 "},{"v":162011,"d":"162,011 "},{"v":163088,"d":"163,088 "},{"v":20673,"d":"20,673 "},{"v":20727,"d":"20,727 "},{"v":21025,"d":"21,025 "},{"v":21245,"d":"21,245 "},{"v":20268,"d":"20,268 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":8808,"d":"8,808 "},{"v":5294,"d":"5,294 "},{"v":4163,"d":"4,163 "},{"v":7017,"d":"7,017 "},{"v":6633,"d":"6,633 "},{"v":1008,"d":"1,008 "},{"v":857,"d":"857 "},{"v":750,"d":"750 "},{"v":779,"d":"779 "},{"v":760,"d":"760 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":3953,"d":"3,953 "},{"v":3898,"d":"3,898 "},{"v":4218,"d":"4,218 "},{"v":4222,"d":"4,222 "},{"v":4495,"d":"4,495 "},{"v":675,"d":"675 "},{"v":352,"d":"352 "},{"v":462,"d":"462 "},{"v":427,"d":"427 "},{"v":406,"d":"406 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":16856,"d":"16,856 "},{"v":17743,"d":"17,743 "},{"v":18174,"d":"18,174 "},{"v":17468,"d":"17,468 "},{"v":16985,"d":"16,985 "},{"v":4059,"d":"4,059 "},{"v":2547,"d":"2,547 "},{"v":2013,"d":"2,013 "},{"v":3846,"d":"3,846 "},{"v":3940,"d":"3,940 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":111043,"d":"111,043 "},{"v":110028,"d":"110,028 "},{"v":110924,"d":"110,924 "},{"v":111947,"d":"111,947 "},{"v":117402,"d":"117,402 "},{"v":15079,"d":"15,079 "},{"v":15821,"d":"15,821 "},{"v":15874,"d":"15,874 "},{"v":15663,"d":"15,663 "},{"v":17057,"d":"17,057 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":314080,"d":"314,080 "},{"v":312550,"d":"312,550 "},{"v":333522,"d":"333,522 "},{"v":330420,"d":"330,420 "},{"v":336475,"d":"336,475 "},{"v":41966,"d":"41,966 "},{"v":40746,"d":"40,746 "},{"v":40587,"d":"40,587 "},{"v":42687,"d":"42,687 "},{"v":43164,"d":"43,164 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":56807,"d":"56,807 "},{"v":61080,"d":"61,080 "},{"v":62977,"d":"62,977 "},{"v":61175,"d":"61,175 "},{"v":62100,"d":"62,100 "},{"v":7262,"d":"7,262 "},{"v":7045,"d":"7,045 "},{"v":7661,"d":"7,661 "},{"v":7253,"d":"7,253 "},{"v":7655,"d":"7,655 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":192725,"d":"192,725 "},{"v":191521,"d":"191,521 "},{"v":195456,"d":"195,456 "},{"v":197145,"d":"197,145 "},{"v":203586,"d":"203,586 "},{"v":27504,"d":"27,504 "},{"v":28145,"d":"28,145 "},{"v":28031,"d":"28,031 "},{"v":27335,"d":"27,335 "},{"v":25948,"d":"25,948 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":104805,"d":"104,805 "},{"v":109232,"d":"109,232 "},{"v":110436,"d":"110,436 "},{"v":118606,"d":"118,606 "},{"v":119102,"d":"119,102 "},{"v":21180,"d":"21,180 "},{"v":20857,"d":"20,857 "},{"v":21383,"d":"21,383 "},{"v":21715,"d":"21,715 "},{"v":22363,"d":"22,363 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":668418,"d":"668,418 "},{"v":674382,"d":"674,382 "},{"v":702392,"d":"702,392 "},{"v":707346,"d":"707,346 "},{"v":721263,"d":"721,263 "},{"v":97912,"d":"97,912 "},{"v":96793,"d":"96,793 "},{"v":97661,"d":"97,661 "},{"v":98990,"d":"98,990 "},{"v":99130,"d":"99,130 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":85258,"d":"85,258 "},{"v":104718,"d":"104,718 "},{"v":105417,"d":"105,417 "},{"v":108751,"d":"108,751 "},{"v":103358,"d":"103,358 "},{"v":11318,"d":"11,318 "},{"v":9608,"d":"9,608 "},{"v":9608,"d":"9,608 "},{"v":10086,"d":"10,086 "},{"v":10124,"d":"10,124 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":358222,"d":"358,222 "},{"v":356001,"d":"356,001 "},{"v":361995,"d":"361,995 "},{"v":371001,"d":"371,001 "},{"v":367334,"d":"367,334 "},{"v":34626,"d":"34,626 "},{"v":38473,"d":"38,473 "},{"v":38811,"d":"38,811 "},{"v":38924,"d":"38,924 "},{"v":39242,"d":"39,242 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":443480,"d":"443,480 "},{"v":460718,"d":"460,718 "},{"v":467412,"d":"467,412 "},{"v":479752,"d":"479,752 "},{"v":470692,"d":"470,692 "},{"v":45943,"d":"45,943 "},{"v":48081,"d":"48,081 "},{"v":48419,"d":"48,419 "},{"v":49010,"d":"49,010 "},{"v":49367,"d":"49,367 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1111898,"d":"1,111,898 "},{"v":1135100,"d":"1,135,100 "},{"v":1169804,"d":"1,169,804 "},{"v":1187098,"d":"1,187,098 "},{"v":1191954,"d":"1,191,954 "},{"v":143856,"d":"143,856 "},{"v":144874,"d":"144,874 "},{"v":146080,"d":"146,080 "},{"v":148000,"d":"148,000 "},{"v":148497,"d":"148,497 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":97917,"d":"97,917 "},{"v":85781,"d":"85,781 "},{"v":90251,"d":"90,251 "},{"v":92549,"d":"92,549 "},{"v":89091,"d":"89,091 "},{"v":3696,"d":"3,696 "},{"v":4971,"d":"4,971 "},{"v":6748,"d":"6,748 "},{"v":5170,"d":"5,170 "},{"v":4756,"d":"4,756 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",7.74,6.27,5.87,6.84,6.57,8.71,8.41,8.92,8.59,9.03]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",4.81,4.64,4.71,4.71,4.62,3.73,{"v":3.9,"d":"3.90"},3.92,4.17,3.89]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",21.14,20.88,22.52,20.83,21.09,16.38,{"v":16.3,"d":"16.30"},16.68,{"v":16.7,"d":"16.70"},16.39]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",37.05,35.09,36.23,35.63,{"v":35.7,"d":"35.70"},31.74,31.56,{"v":32.4,"d":"32.40"},32.34,32.27]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",36.15,35.82,34.99,34.91,34.98,52.84,53.13,52.41,52.21,51.36]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",3.84,3.97,4.19,4.17,4.14,3.62,2.31,2.01,3.38,3.42]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",28.25,27.54,28.51,27.83,28.23,29.17,28.12,27.78,28.84,29.07]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.44,22.25,22.09,21.76,22.29,24.17,24.29,24.43,23.37,22.63]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",60.12,59.41,60.04,59.59,60.51,68.06,66.81,66.85,66.89,66.76]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",39.88,40.59,39.96,40.41,39.49,31.94,33.19,33.15,33.11,33.24]
["  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-2013Q1","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"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 1Q_\n 2013_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 1Q_\n 2013_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":199040,"d":"199,040 "},{"v":199542,"d":"199,542 "},{"v":199295,"d":"199,295 "},{"v":233433,"d":"233,433 "},{"v":201931,"d":"201,931 "},{"v":281295,"d":"281,295 "},{"v":284204,"d":"284,204 "},{"v":280993,"d":"280,993 "},{"v":297681,"d":"297,681 "},{"v":290704,"d":"290,704 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":4548,"d":"4,548 "},{"v":4709,"d":"4,709 "},{"v":4697,"d":"4,697 "},{"v":4725,"d":"4,725 "},{"v":4728,"d":"4,728 "},{"v":4166,"d":"4,166 "},{"v":4267,"d":"4,267 "},{"v":4347,"d":"4,347 "},{"v":4491,"d":"4,491 "},{"v":4590,"d":"4,590 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":183249,"d":"183,249 "},{"v":184139,"d":"184,139 "},{"v":185676,"d":"185,676 "},{"v":213082,"d":"213,082 "},{"v":185250,"d":"185,250 "},{"v":264049,"d":"264,049 "},{"v":266398,"d":"266,398 "},{"v":264643,"d":"264,643 "},{"v":278384,"d":"278,384 "},{"v":272518,"d":"272,518 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":11243,"d":"11,243 "},{"v":10694,"d":"10,694 "},{"v":8922,"d":"8,922 "},{"v":15626,"d":"15,626 "},{"v":11953,"d":"11,953 "},{"v":13081,"d":"13,081 "},{"v":13539,"d":"13,539 "},{"v":12003,"d":"12,003 "},{"v":14806,"d":"14,806 "},{"v":13596,"d":"13,596 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1528,"d":"1,528 "},{"v":1533,"d":"1,533 "},{"v":1545,"d":"1,545 "},{"v":1458,"d":"1,458 "},{"v":1947,"d":"1,947 "},{"v":1910,"d":"1,910 "},{"v":1928,"d":"1,928 "},{"v":1974,"d":"1,974 "},{"v":2031,"d":"2,031 "},{"v":1982,"d":"1,982 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":2989,"d":"2,989 "},{"v":2835,"d":"2,835 "},{"v":3796,"d":"3,796 "},{"v":3262,"d":"3,262 "},{"v":1775,"d":"1,775 "},{"v":-1286,"d":"(1,286)"},{"v":1418,"d":"1,418 "},{"v":-342,"d":"(342)"},{"v":901,"d":"901 "},{"v":464,"d":"464 "}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":12704,"d":"12,704 "},{"v":11997,"d":"11,997 "},{"v":11173,"d":"11,173 "},{"v":17430,"d":"17,430 "},{"v":11781,"d":"11,781 "},{"v":9884,"d":"9,884 "},{"v":13029,"d":"13,029 "},{"v":9687,"d":"9,687 "},{"v":13676,"d":"13,676 "},{"v":12078,"d":"12,078 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":4033,"d":"4,033 "},{"v":3898,"d":"3,898 "},{"v":3615,"d":"3,615 "},{"v":5074,"d":"5,074 "},{"v":3836,"d":"3,836 "},{"v":3857,"d":"3,857 "},{"v":4111,"d":"4,111 "},{"v":3830,"d":"3,830 "},{"v":4262,"d":"4,262 "},{"v":3860,"d":"3,860 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":8672,"d":"8,672 "},{"v":8099,"d":"8,099 "},{"v":7558,"d":"7,558 "},{"v":12356,"d":"12,356 "},{"v":7945,"d":"7,945 "},{"v":6027,"d":"6,027 "},{"v":8918,"d":"8,918 "},{"v":5857,"d":"5,857 "},{"v":9414,"d":"9,414 "},{"v":8217,"d":"8,217 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":6697,"d":"6,697 "},{"v":959,"d":"959 "},{"v":2258,"d":"2,258 "},{"v":3393,"d":"3,393 "},{"v":10819,"d":"10,819 "},{"v":1888,"d":"1,888 "},{"v":2400,"d":"2,400 "},{"v":1954,"d":"1,954 "},{"v":2618,"d":"2,618 "},{"v":2431,"d":"2,431 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1975,"d":"1,975 "},{"v":7139,"d":"7,139 "},{"v":5301,"d":"5,301 "},{"v":8964,"d":"8,964 "},{"v":-2874,"d":"(2,874)"},{"v":4139,"d":"4,139 "},{"v":6519,"d":"6,519 "},{"v":3903,"d":"3,903 "},{"v":6796,"d":"6,796 "},{"v":5786,"d":"5,786 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":155662,"d":"155,662 "},{"v":155387,"d":"155,387 "},{"v":159715,"d":"159,715 "},{"v":163778,"d":"163,778 "},{"v":166983,"d":"166,983 "},{"v":169343,"d":"169,343 "},{"v":159572,"d":"159,572 "},{"v":158365,"d":"158,365 "},{"v":158320,"d":"158,320 "},{"v":165135,"d":"165,135 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-2323,"d":"(2,323)"},{"v":-3546,"d":"(3,546)"},{"v":-2543,"d":"(2,543)"},{"v":-4789,"d":"(4,789)"},{"v":-3556,"d":"(3,556)"},{"v":-5199,"d":"(5,199)"},{"v":-7545,"d":"(7,545)"},{"v":-1556,"d":"(1,556)"},{"v":-992,"d":"(992)"},{"v":-3383,"d":"(3,383)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":155313,"d":"155,313 "},{"v":158981,"d":"158,981 "},{"v":162472,"d":"162,472 "},{"v":167952,"d":"167,952 "},{"v":160553,"d":"160,553 "},{"v":168283,"d":"168,283 "},{"v":158546,"d":"158,546 "},{"v":160712,"d":"160,712 "},{"v":164125,"d":"164,125 "},{"v":167538,"d":"167,538 "}]
["                         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.28,2.36,2.36,2.02,2.34,1.48,{"v":1.5,"d":"1.50"},1.55,1.51,1.58]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",92.07,92.28,93.17,91.28,91.74,93.87,93.73,94.18,93.52,93.74]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",5.65,5.36,4.48,6.69,5.92,4.65,4.76,4.27,4.97,4.68]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.77,0.77,0.78,0.62,0.96,0.68,0.68,{"v":0.7,"d":"0.70"},0.68,0.68]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",{"v":1.5,"d":"1.50"},1.42,{"v":1.9,"d":"1.90"},{"v":1.4,"d":"1.40"},0.88,{"v":-0.46,"d":"(0.46)"},{"v":0.5,"d":"0.50"},{"v":-0.12,"d":"(0.12)"},{"v":0.3,"d":"0.30"},0.16]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",6.38,6.01,5.61,7.47,5.83,3.51,4.58,3.45,4.59,4.15]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",2.03,1.95,1.81,2.17,{"v":1.9,"d":"1.90"},1.37,1.45,1.36,1.43,1.33]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",4.36,4.06,3.79,5.29,3.93,2.14,3.14,2.08,3.16,2.83]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",27.97,26.33,24.16,36.28,25.77,18.32,22.62,16.56,22.93,20.26]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",19.09,17.78,16.34,25.72,17.38,11.17,15.48,10.01,15.78,13.79]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",11.49,10.85,9.74,15.43,10.39,7.52,9.51,6.86,9.32,8.19]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",7.84,7.32,6.59,10.94,7.01,4.59,6.51,4.15,6.41,5.57]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.25,1.25,1.22,1.25,1.24,1.42,1.34,1.34,1.34,1.33]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.24,0.21,0.17,{"v":0.2,"d":"0.20"},{"v":0.2,"d":"0.20"},{"v":0.3,"d":"0.30"},0.22,0.21,0.26,0.23]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.61,1.59,1.56,1.71,1.54,1.55,{"v":1.6,"d":"1.60"},1.56,1.53,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-2013Q1","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"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 1Q_\n 2013_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 1Q_\n 2013_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":22617,"d":"22,617 "},{"v":19393,"d":"19,393 "},{"v":16788,"d":"16,788 "},{"v":19624,"d":"19,624 "},{"v":18465,"d":"18,465 "},{"v":35404,"d":"35,404 "},{"v":23918,"d":"23,918 "},{"v":25269,"d":"25,269 "},{"v":31827,"d":"31,827 "},{"v":27955,"d":"27,955 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":438,"d":"438 "},{"v":430,"d":"430 "},{"v":412,"d":"412 "},{"v":364,"d":"364 "},{"v":581,"d":"581 "},{"v":2130,"d":"2,130 "},{"v":2687,"d":"2,687 "},{"v":1254,"d":"1,254 "},{"v":709,"d":"709 "},{"v":1150,"d":"1,150 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":23055,"d":"23,055 "},{"v":19823,"d":"19,823 "},{"v":17201,"d":"17,201 "},{"v":19988,"d":"19,988 "},{"v":19046,"d":"19,046 "},{"v":37533,"d":"37,533 "},{"v":26604,"d":"26,604 "},{"v":26523,"d":"26,523 "},{"v":32536,"d":"32,536 "},{"v":29105,"d":"29,105 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5568,"d":"5,568 "},{"v":5931,"d":"5,931 "},{"v":5171,"d":"5,171 "},{"v":5100,"d":"5,100 "},{"v":6777,"d":"6,777 "},{"v":7411,"d":"7,411 "},{"v":6641,"d":"6,641 "},{"v":6705,"d":"6,705 "},{"v":10874,"d":"10,874 "},{"v":9927,"d":"9,927 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":28623,"d":"28,623 "},{"v":25755,"d":"25,755 "},{"v":22371,"d":"22,371 "},{"v":25088,"d":"25,088 "},{"v":25823,"d":"25,823 "},{"v":44944,"d":"44,944 "},{"v":33245,"d":"33,245 "},{"v":33228,"d":"33,228 "},{"v":43411,"d":"43,411 "},{"v":39033,"d":"39,033 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":6921,"d":"6,921 "},{"v":6730,"d":"6,730 "},{"v":7141,"d":"7,141 "},{"v":7788,"d":"7,788 "},{"v":7511,"d":"7,511 "},{"v":41149,"d":"41,149 "},{"v":40243,"d":"40,243 "},{"v":42186,"d":"42,186 "},{"v":41962,"d":"41,962 "},{"v":41739,"d":"41,739 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":101230,"d":"101,230 "},{"v":102226,"d":"102,226 "},{"v":120452,"d":"120,452 "},{"v":105282,"d":"105,282 "},{"v":106822,"d":"106,822 "},{"v":110247,"d":"110,247 "},{"v":111197,"d":"111,197 "},{"v":118622,"d":"118,622 "},{"v":117229,"d":"117,229 "},{"v":120186,"d":"120,186 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15198,"d":"15,198 "},{"v":15473,"d":"15,473 "},{"v":14420,"d":"14,420 "},{"v":15927,"d":"15,927 "},{"v":16496,"d":"16,496 "},{"v":18022,"d":"18,022 "},{"v":17746,"d":"17,746 "},{"v":18018,"d":"18,018 "},{"v":18425,"d":"18,425 "},{"v":20037,"d":"20,037 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":151972,"d":"151,972 "},{"v":150183,"d":"150,183 "},{"v":164385,"d":"164,385 "},{"v":154086,"d":"154,086 "},{"v":156652,"d":"156,652 "},{"v":214363,"d":"214,363 "},{"v":202432,"d":"202,432 "},{"v":212054,"d":"212,054 "},{"v":221026,"d":"221,026 "},{"v":220995,"d":"220,995 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":273211,"d":"273,211 "},{"v":277091,"d":"277,091 "},{"v":280140,"d":"280,140 "},{"v":283075,"d":"283,075 "},{"v":287711,"d":"287,711 "},{"v":230568,"d":"230,568 "},{"v":234398,"d":"234,398 "},{"v":239116,"d":"239,116 "},{"v":240965,"d":"240,965 "},{"v":245994,"d":"245,994 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":30377,"d":"30,377 "},{"v":30586,"d":"30,586 "},{"v":31500,"d":"31,500 "},{"v":31916,"d":"31,916 "},{"v":32148,"d":"32,148 "},{"v":33457,"d":"33,457 "},{"v":33990,"d":"33,990 "},{"v":34307,"d":"34,307 "},{"v":34641,"d":"34,641 "},{"v":34900,"d":"34,900 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":123874,"d":"123,874 "},{"v":126551,"d":"126,551 "},{"v":129186,"d":"129,186 "},{"v":130478,"d":"130,478 "},{"v":133316,"d":"133,316 "},{"v":117801,"d":"117,801 "},{"v":119906,"d":"119,906 "},{"v":123159,"d":"123,159 "},{"v":123032,"d":"123,032 "},{"v":126805,"d":"126,805 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":179715,"d":"179,715 "},{"v":181126,"d":"181,126 "},{"v":182453,"d":"182,453 "},{"v":184512,"d":"184,512 "},{"v":186543,"d":"186,543 "},{"v":146223,"d":"146,223 "},{"v":148482,"d":"148,482 "},{"v":150263,"d":"150,263 "},{"v":152574,"d":"152,574 "},{"v":154090,"d":"154,090 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":110748,"d":"110,748 "},{"v":111079,"d":"111,079 "},{"v":111789,"d":"111,789 "},{"v":113341,"d":"113,341 "},{"v":110311,"d":"110,311 "},{"v":165022,"d":"165,022 "},{"v":196925,"d":"196,925 "},{"v":202780,"d":"202,780 "},{"v":213558,"d":"213,558 "},{"v":214868,"d":"214,868 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":442435,"d":"442,435 "},{"v":442388,"d":"442,388 "},{"v":458627,"d":"458,627 "},{"v":451939,"d":"451,939 "},{"v":453505,"d":"453,505 "},{"v":525608,"d":"525,608 "},{"v":547839,"d":"547,839 "},{"v":565096,"d":"565,096 "},{"v":587158,"d":"587,158 "},{"v":589953,"d":"589,953 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":805,"d":"805 "},{"v":1042,"d":"1,042 "},{"v":1295,"d":"1,295 "},{"v":978,"d":"978 "},{"v":1134,"d":"1,134 "},{"v":10321,"d":"10,321 "},{"v":11633,"d":"11,633 "},{"v":11200,"d":"11,200 "},{"v":12262,"d":"12,262 "},{"v":13482,"d":"13,482 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":7020,"d":"7,020 "},{"v":6819,"d":"6,819 "},{"v":10090,"d":"10,090 "},{"v":8718,"d":"8,718 "},{"v":7737,"d":"7,737 "},{"v":3272,"d":"3,272 "},{"v":3542,"d":"3,542 "},{"v":3537,"d":"3,537 "},{"v":5068,"d":"5,068 "},{"v":4787,"d":"4,787 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":57816,"d":"57,816 "},{"v":57393,"d":"57,393 "},{"v":68110,"d":"68,110 "},{"v":58546,"d":"58,546 "},{"v":60721,"d":"60,721 "},{"v":73040,"d":"73,040 "},{"v":73990,"d":"73,990 "},{"v":80323,"d":"80,323 "},{"v":82221,"d":"82,221 "},{"v":82099,"d":"82,099 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":4091,"d":"4,091 "},{"v":2074,"d":"2,074 "},{"v":1568,"d":"1,568 "},{"v":3844,"d":"3,844 "},{"v":3667,"d":"3,667 "},{"v":3710,"d":"3,710 "},{"v":2363,"d":"2,363 "},{"v":1844,"d":"1,844 "},{"v":2393,"d":"2,393 "},{"v":2206,"d":"2,206 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":267,"d":"267 "},{"v":243,"d":"243 "},{"v":257,"d":"257 "},{"v":288,"d":"288 "},{"v":213,"d":"213 "},{"v":3011,"d":"3,011 "},{"v":3303,"d":"3,303 "},{"v":3500,"d":"3,500 "},{"v":3507,"d":"3,507 "},{"v":3876,"d":"3,876 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":6619,"d":"6,619 "},{"v":8179,"d":"8,179 "},{"v":9274,"d":"9,274 "},{"v":5972,"d":"5,972 "},{"v":6382,"d":"6,382 "},{"v":6178,"d":"6,178 "},{"v":7018,"d":"7,018 "},{"v":6887,"d":"6,887 "},{"v":7650,"d":"7,650 "},{"v":6664,"d":"6,664 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":44673,"d":"44,673 "},{"v":44778,"d":"44,778 "},{"v":44639,"d":"44,639 "},{"v":44533,"d":"44,533 "},{"v":46727,"d":"46,727 "},{"v":51292,"d":"51,292 "},{"v":49428,"d":"49,428 "},{"v":50411,"d":"50,411 "},{"v":51751,"d":"51,751 "},{"v":53618,"d":"53,618 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":121290,"d":"121,290 "},{"v":120528,"d":"120,528 "},{"v":135234,"d":"135,234 "},{"v":122879,"d":"122,879 "},{"v":126581,"d":"126,581 "},{"v":150824,"d":"150,824 "},{"v":151276,"d":"151,276 "},{"v":157701,"d":"157,701 "},{"v":164854,"d":"164,854 "},{"v":166731,"d":"166,731 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":14062,"d":"14,062 "},{"v":14529,"d":"14,529 "},{"v":15342,"d":"15,342 "},{"v":14544,"d":"14,544 "},{"v":14213,"d":"14,213 "},{"v":35483,"d":"35,483 "},{"v":39505,"d":"39,505 "},{"v":39975,"d":"39,975 "},{"v":39378,"d":"39,378 "},{"v":40231,"d":"40,231 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":84426,"d":"84,426 "},{"v":83956,"d":"83,956 "},{"v":82715,"d":"82,715 "},{"v":82142,"d":"82,142 "},{"v":89139,"d":"89,139 "},{"v":80795,"d":"80,795 "},{"v":79420,"d":"79,420 "},{"v":84710,"d":"84,710 "},{"v":87668,"d":"87,668 "},{"v":88500,"d":"88,500 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":40957,"d":"40,957 "},{"v":41142,"d":"41,142 "},{"v":40327,"d":"40,327 "},{"v":40208,"d":"40,208 "},{"v":40693,"d":"40,693 "},{"v":42668,"d":"42,668 "},{"v":47232,"d":"47,232 "},{"v":48726,"d":"48,726 "},{"v":56683,"d":"56,683 "},{"v":56046,"d":"56,046 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":260734,"d":"260,734 "},{"v":260155,"d":"260,155 "},{"v":273617,"d":"273,617 "},{"v":259773,"d":"259,773 "},{"v":270626,"d":"270,626 "},{"v":309771,"d":"309,771 "},{"v":317434,"d":"317,434 "},{"v":331113,"d":"331,113 "},{"v":348582,"d":"348,582 "},{"v":351507,"d":"351,507 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":26388,"d":"26,388 "},{"v":23251,"d":"23,251 "},{"v":22538,"d":"22,538 "},{"v":24214,"d":"24,214 "},{"v":22326,"d":"22,326 "},{"v":47553,"d":"47,553 "},{"v":71858,"d":"71,858 "},{"v":73272,"d":"73,272 "},{"v":74451,"d":"74,451 "},{"v":70907,"d":"70,907 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":155313,"d":"155,313 "},{"v":158981,"d":"158,981 "},{"v":162472,"d":"162,472 "},{"v":167952,"d":"167,952 "},{"v":160553,"d":"160,553 "},{"v":168283,"d":"168,283 "},{"v":158546,"d":"158,546 "},{"v":160712,"d":"160,712 "},{"v":164125,"d":"164,125 "},{"v":167538,"d":"167,538 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":181701,"d":"181,701 "},{"v":182232,"d":"182,232 "},{"v":185010,"d":"185,010 "},{"v":192166,"d":"192,166 "},{"v":182879,"d":"182,879 "},{"v":215836,"d":"215,836 "},{"v":230405,"d":"230,405 "},{"v":233984,"d":"233,984 "},{"v":238576,"d":"238,576 "},{"v":238446,"d":"238,446 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":442435,"d":"442,435 "},{"v":442388,"d":"442,388 "},{"v":458627,"d":"458,627 "},{"v":451939,"d":"451,939 "},{"v":453505,"d":"453,505 "},{"v":525608,"d":"525,608 "},{"v":547839,"d":"547,839 "},{"v":565096,"d":"565,096 "},{"v":587158,"d":"587,158 "},{"v":589953,"d":"589,953 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":30682,"d":"30,682 "},{"v":29655,"d":"29,655 "},{"v":29151,"d":"29,151 "},{"v":31207,"d":"31,207 "},{"v":30071,"d":"30,071 "},{"v":63539,"d":"63,539 "},{"v":51156,"d":"51,156 "},{"v":54352,"d":"54,352 "},{"v":56173,"d":"56,173 "},{"v":54264,"d":"54,264 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",6.47,5.82,4.88,5.55,5.69,8.55,6.07,5.88,7.39,6.62]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",1.56,1.52,1.56,1.72,1.66,7.83,7.35,7.47,7.15,7.07]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.88,23.11,26.26,{"v":23.3,"d":"23.30"},23.55,20.98,{"v":20.3,"d":"20.30"},20.99,19.97,20.37]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",34.35,33.95,35.84,34.09,34.54,40.78,36.95,37.53,37.64,37.46]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",40.62,40.94,39.78,40.83,41.13,27.82,{"v":27.1,"d":"27.10"},26.59,25.99,26.12]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",3.33,3.68,4.56,3.53,3.41,4.33,4.65,4.45,4.85,4.88]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",27.41,27.24,29.49,27.19,27.91,{"v":28.7,"d":"28.70"},27.61,27.91,28.08,28.26]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.26,22.26,21.38,21.39,22.79,22.12,21.71,22.06,21.64,21.82]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",58.93,58.81,59.66,57.48,59.67,58.94,57.94,58.59,59.37,59.58]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",41.07,41.19,40.34,42.52,40.33,41.06,42.06,41.41,40.63,40.42]
["  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-2013Q1","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":349173,"d":"349,173 "},{"v":354913,"d":"354,913 "},{"v":359651,"d":"359,651 "},{"v":357364,"d":"357,364 "}]
["2003 …………………………………………………………………………………………...………………………………………………..",{"v":366843,"d":"366,843 "},{"v":369610,"d":"369,610 "},{"v":391623,"d":"391,623 "},{"v":399048,"d":"399,048 "}]
["2004 …………………………………………………………………………………………...………………………………………………..",{"v":406962,"d":"406,962 "},{"v":410190,"d":"410,190 "},{"v":421854,"d":"421,854 "},{"v":427403,"d":"427,403 "}]
["2005 …………………………………………………………………………………………...………………………………………………..",{"v":438378,"d":"438,378 "},{"v":447170,"d":"447,170 "},{"v":458739,"d":"458,739 "},{"v":467830,"d":"467,830 "}]
["2006 …………………………………………………………………………………………...………………………………………………..",{"v":480599,"d":"480,599 "},{"v":492419,"d":"492,419 "},{"v":497878,"d":"497,878 "},{"v":502066,"d":"502,066 "}]
["2007 …………………………………………………………………………………………...………………………………………………..",{"v":509949,"d":"509,949 "},{"v":514336,"d":"514,336 "},{"v":516196,"d":"516,196 "},{"v":521380,"d":"521,380 "}]
["2008 …………………………………………………………………………………………...………………………………………………..",{"v":523249,"d":"523,249 "},{"v":535875,"d":"535,875 "},{"v":531556,"d":"531,556 "},{"v":501700,"d":"501,700 "}]
["2009 …………………………………………………………………………………………...………………………………………………..",{"v":495434,"d":"495,434 "},{"v":494761,"d":"494,761 "},{"v":508532,"d":"508,532 "},{"v":521183,"d":"521,183 "}]
["2010 …………………………………………………………………………………………...………………………………………………..",{"v":531236,"d":"531,236 "},{"v":534144,"d":"534,144 "},{"v":539763,"d":"539,763 "},{"v":552679,"d":"552,679 "}]
["2011 …………………………………………………………………………………………...………………………………………………..",{"v":565649,"d":"565,649 "},{"v":584509,"d":"584,509 "},{"v":586421,"d":"586,421 "},{"v":588845,"d":"588,845 "}]
["2012 …………………………………………………………………………………………...………………………………………………..",{"v":600989,"d":"600,989 "},{"v":597425,"d":"597,425 "},{"v":604237,"d":"604,237 "},{"v":613580,"d":"613,580 "}]
["2013 …………………………………………………………………………………………...………………………………………………..",{"v":615655,"d":"615,655 "}]
[]
["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."]