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

{"sheet":"RET_4_0-2014Q1","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 2013_"," 2Q_\n 2013_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 1Q_\n 2013_"," 2Q_\n 2013_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":603869,"d":"603,869 "},{"v":623085,"d":"623,085 "},{"v":622507,"d":"622,507 "},{"v":674520,"d":"674,520 "},{"v":625893,"d":"625,893 "},{"v":112204,"d":"112,204 "},{"v":112227,"d":"112,227 "},{"v":109800,"d":"109,800 "},{"v":112895,"d":"112,895 "},{"v":112973,"d":"112,973 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":11500,"d":"11,500 "},{"v":11663,"d":"11,663 "},{"v":11862,"d":"11,862 "},{"v":12274,"d":"12,274 "},{"v":12185,"d":"12,185 "},{"v":2180,"d":"2,180 "},{"v":2212,"d":"2,212 "},{"v":2188,"d":"2,188 "},{"v":2321,"d":"2,321 "},{"v":2305,"d":"2,305 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":563798,"d":"563,798 "},{"v":579612,"d":"579,612 "},{"v":582954,"d":"582,954 "},{"v":628047,"d":"628,047 "},{"v":586230,"d":"586,230 "},{"v":106852,"d":"106,852 "},{"v":106223,"d":"106,223 "},{"v":104562,"d":"104,562 "},{"v":107117,"d":"107,117 "},{"v":107060,"d":"107,060 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":28572,"d":"28,572 "},{"v":31810,"d":"31,810 "},{"v":27691,"d":"27,691 "},{"v":34199,"d":"34,199 "},{"v":27478,"d":"27,478 "},{"v":3172,"d":"3,172 "},{"v":3791,"d":"3,791 "},{"v":3050,"d":"3,050 "},{"v":3457,"d":"3,457 "},{"v":3608,"d":"3,608 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4676,"d":"4,676 "},{"v":4102,"d":"4,102 "},{"v":4053,"d":"4,053 "},{"v":4200,"d":"4,200 "},{"v":4183,"d":"4,183 "},{"v":767,"d":"767 "},{"v":763,"d":"763 "},{"v":673,"d":"673 "},{"v":689,"d":"689 "},{"v":668,"d":"668 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":813,"d":"813 "},{"v":3357,"d":"3,357 "},{"v":2791,"d":"2,791 "},{"v":6861,"d":"6,861 "},{"v":2984,"d":"2,984 "},{"v":-1368,"d":"(1,368)"},{"v":19,"d":"19 "},{"v":107,"d":"107 "},{"v":3327,"d":"3,327 "},{"v":58,"d":"58 "}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":24709,"d":"24,709 "},{"v":31065,"d":"31,065 "},{"v":26429,"d":"26,429 "},{"v":36860,"d":"36,860 "},{"v":26280,"d":"26,280 "},{"v":1037,"d":"1,037 "},{"v":3047,"d":"3,047 "},{"v":2484,"d":"2,484 "},{"v":6096,"d":"6,096 "},{"v":2998,"d":"2,998 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":8226,"d":"8,226 "},{"v":9919,"d":"9,919 "},{"v":8981,"d":"8,981 "},{"v":11166,"d":"11,166 "},{"v":11692,"d":"11,692 "},{"v":512,"d":"512 "},{"v":750,"d":"750 "},{"v":527,"d":"527 "},{"v":547,"d":"547 "},{"v":1123,"d":"1,123 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":16483,"d":"16,483 "},{"v":21146,"d":"21,146 "},{"v":17448,"d":"17,448 "},{"v":25694,"d":"25,694 "},{"v":14588,"d":"14,588 "},{"v":525,"d":"525 "},{"v":2297,"d":"2,297 "},{"v":1957,"d":"1,957 "},{"v":5548,"d":"5,548 "},{"v":1874,"d":"1,874 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":13495,"d":"13,495 "},{"v":5024,"d":"5,024 "},{"v":4481,"d":"4,481 "},{"v":5837,"d":"5,837 "},{"v":11816,"d":"11,816 "},{"v":571,"d":"571 "},{"v":341,"d":"341 "},{"v":626,"d":"626 "},{"v":954,"d":"954 "},{"v":737,"d":"737 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":2988,"d":"2,988 "},{"v":16122,"d":"16,122 "},{"v":12967,"d":"12,967 "},{"v":19857,"d":"19,857 "},{"v":2771,"d":"2,771 "},{"v":-46,"d":"(46)"},{"v":1956,"d":"1,956 "},{"v":1331,"d":"1,331 "},{"v":4595,"d":"4,595 "},{"v":1137,"d":"1,137 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":373114,"d":"373,114 "},{"v":369720,"d":"369,720 "},{"v":380125,"d":"380,125 "},{"v":388252,"d":"388,252 "},{"v":395973,"d":"395,973 "},{"v":39978,"d":"39,978 "},{"v":39711,"d":"39,711 "},{"v":40481,"d":"40,481 "},{"v":40579,"d":"40,579 "},{"v":38034,"d":"38,034 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-6368,"d":"(6,368)"},{"v":-5219,"d":"(5,219)"},{"v":-4606,"d":"(4,606)"},{"v":-10726,"d":"(10,726)"},{"v":-4139,"d":"(4,139)"},{"v":282,"d":"282 "},{"v":-188,"d":"(188)"},{"v":-44,"d":"(44)"},{"v":-6757,"d":"(6,757)"},{"v":33,"d":"33 "}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":369733,"d":"369,733 "},{"v":380623,"d":"380,623 "},{"v":388487,"d":"388,487 "},{"v":397383,"d":"397,383 "},{"v":394605,"d":"394,605 "},{"v":40213,"d":"40,213 "},{"v":41479,"d":"41,479 "},{"v":41768,"d":"41,768 "},{"v":38417,"d":"38,417 "},{"v":39204,"d":"39,204 "}]
["                         INCOME STATEMENT IN RATIO FORMAT","(percent of net sales)",{"$nulls":4},"(percent of net sales)"]
["     Net sales, receipts, and operating revenues ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment ………………………………………………………………………………………………………………………………………………………………………",{"v":1.9,"d":"1.90"},1.87,1.91,1.82,1.95,1.94,1.97,1.99,2.06,2.04]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",93.36,93.02,93.65,93.11,93.66,95.23,94.65,95.23,94.88,94.77]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",4.73,5.11,4.45,5.07,4.39,2.83,3.38,2.78,3.06,3.19]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.77,0.66,0.65,0.62,0.67,0.68,0.68,0.61,0.61,0.59]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",0.13,0.54,0.45,1.02,0.48,{"v":-1.22,"d":"(1.22)"},0.02,{"v":0.1,"d":"0.10"},2.95,0.05]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",4.09,4.99,4.25,5.46,{"v":4.2,"d":"4.20"},0.92,2.72,2.26,{"v":5.4,"d":"5.40"},2.65]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.36,1.59,1.44,1.66,1.87,0.46,0.67,0.48,0.48,0.99]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",2.73,3.39,{"v":2.8,"d":"2.80"},3.81,2.33,0.47,2.05,1.78,4.91,1.66]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":21,"d":"21.00"},26.07,21.88,29.73,21.22,8.45,24.12,18.82,42.76,20.43]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",14.01,17.75,14.44,20.73,11.78,4.28,18.19,14.83,38.92,12.78]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":8.3,"d":"8.30"},10.37,8.54,11.79,{"v":8.4,"d":"8.40"},2.81,8.19,{"v":6.7,"d":"6.70"},15.35,7.63]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",5.54,7.06,5.64,8.22,4.66,1.42,6.17,5.28,13.97,4.77]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.26,1.26,1.26,1.29,1.27,1.13,1.15,1.17,1.25,1.29]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.23,0.23,0.21,0.25,0.23,0.31,0.33,0.33,0.41,0.41]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.49,1.49,1.44,1.47,1.47,1.25,1.29,1.37,1.38,1.44]
["  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-2014Q1","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 2013_"," 2Q_\n 2013_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 1Q_\n 2013_"," 2Q_\n 2013_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":58723,"d":"58,723 "},{"v":57377,"d":"57,377 "},{"v":57371,"d":"57,371 "},{"v":59944,"d":"59,944 "},{"v":58200,"d":"58,200 "},{"v":10612,"d":"10,612 "},{"v":10849,"d":"10,849 "},{"v":10875,"d":"10,875 "},{"v":11639,"d":"11,639 "},{"v":12302,"d":"12,302 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":2074,"d":"2,074 "},{"v":2190,"d":"2,190 "},{"v":2153,"d":"2,153 "},{"v":5786,"d":"5,786 "},{"v":3632,"d":"3,632 "},{"v":359,"d":"359 "},{"v":480,"d":"480 "},{"v":367,"d":"367 "},{"v":3943,"d":"3,943 "},{"v":1774,"d":"1,774 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":60796,"d":"60,796 "},{"v":59567,"d":"59,567 "},{"v":59524,"d":"59,524 "},{"v":65730,"d":"65,730 "},{"v":61833,"d":"61,833 "},{"v":10971,"d":"10,971 "},{"v":11329,"d":"11,329 "},{"v":11243,"d":"11,243 "},{"v":15582,"d":"15,582 "},{"v":14076,"d":"14,076 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":17568,"d":"17,568 "},{"v":17082,"d":"17,082 "},{"v":16779,"d":"16,779 "},{"v":22123,"d":"22,123 "},{"v":18558,"d":"18,558 "},{"v":2235,"d":"2,235 "},{"v":2602,"d":"2,602 "},{"v":2455,"d":"2,455 "},{"v":2368,"d":"2,368 "},{"v":2550,"d":"2,550 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":78364,"d":"78,364 "},{"v":76649,"d":"76,649 "},{"v":76304,"d":"76,304 "},{"v":87853,"d":"87,853 "},{"v":80391,"d":"80,391 "},{"v":13206,"d":"13,206 "},{"v":13930,"d":"13,930 "},{"v":13698,"d":"13,698 "},{"v":17951,"d":"17,951 "},{"v":16626,"d":"16,626 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":54613,"d":"54,613 "},{"v":55912,"d":"55,912 "},{"v":58288,"d":"58,288 "},{"v":60754,"d":"60,754 "},{"v":59088,"d":"59,088 "},{"v":5893,"d":"5,893 "},{"v":5808,"d":"5,808 "},{"v":5791,"d":"5,791 "},{"v":6525,"d":"6,525 "},{"v":6253,"d":"6,253 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":249771,"d":"249,771 "},{"v":250771,"d":"250,771 "},{"v":275144,"d":"275,144 "},{"v":258573,"d":"258,573 "},{"v":259678,"d":"259,678 "},{"v":24267,"d":"24,267 "},{"v":24025,"d":"24,025 "},{"v":24572,"d":"24,572 "},{"v":25416,"d":"25,416 "},{"v":24725,"d":"24,725 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":40500,"d":"40,500 "},{"v":39952,"d":"39,952 "},{"v":42252,"d":"42,252 "},{"v":43467,"d":"43,467 "},{"v":42506,"d":"42,506 "},{"v":4170,"d":"4,170 "},{"v":4518,"d":"4,518 "},{"v":4577,"d":"4,577 "},{"v":5112,"d":"5,112 "},{"v":5096,"d":"5,096 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":423248,"d":"423,248 "},{"v":423285,"d":"423,285 "},{"v":451988,"d":"451,988 "},{"v":450648,"d":"450,648 "},{"v":441664,"d":"441,664 "},{"v":47535,"d":"47,535 "},{"v":48281,"d":"48,281 "},{"v":48638,"d":"48,638 "},{"v":55004,"d":"55,004 "},{"v":52699,"d":"52,699 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":673310,"d":"673,310 "},{"v":685808,"d":"685,808 "},{"v":693717,"d":"693,717 "},{"v":710069,"d":"710,069 "},{"v":716996,"d":"716,996 "},{"v":141681,"d":"141,681 "},{"v":142585,"d":"142,585 "},{"v":139457,"d":"139,457 "},{"v":140623,"d":"140,623 "},{"v":140654,"d":"140,654 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":78955,"d":"78,955 "},{"v":79487,"d":"79,487 "},{"v":79548,"d":"79,548 "},{"v":74193,"d":"74,193 "},{"v":73976,"d":"73,976 "},{"v":11141,"d":"11,141 "},{"v":11088,"d":"11,088 "},{"v":10729,"d":"10,729 "},{"v":10956,"d":"10,956 "},{"v":11116,"d":"11,116 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":336439,"d":"336,439 "},{"v":343852,"d":"343,852 "},{"v":347483,"d":"347,483 "},{"v":351288,"d":"351,288 "},{"v":357131,"d":"357,131 "},{"v":76408,"d":"76,408 "},{"v":77316,"d":"77,316 "},{"v":74665,"d":"74,665 "},{"v":74719,"d":"74,719 "},{"v":74683,"d":"74,683 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":415826,"d":"415,826 "},{"v":421444,"d":"421,444 "},{"v":425781,"d":"425,781 "},{"v":432974,"d":"432,974 "},{"v":433840,"d":"433,840 "},{"v":76414,"d":"76,414 "},{"v":76358,"d":"76,358 "},{"v":75521,"d":"75,521 "},{"v":76860,"d":"76,860 "},{"v":77088,"d":"77,088 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":351762,"d":"351,762 "},{"v":354030,"d":"354,030 "},{"v":359471,"d":"359,471 "},{"v":367018,"d":"367,018 "},{"v":375733,"d":"375,733 "},{"v":23723,"d":"23,723 "},{"v":24186,"d":"24,186 "},{"v":24163,"d":"24,163 "},{"v":27001,"d":"27,001 "},{"v":27352,"d":"27,352 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1190836,"d":"1,190,836 "},{"v":1198758,"d":"1,198,758 "},{"v":1237239,"d":"1,237,239 "},{"v":1250640,"d":"1,250,640 "},{"v":1251237,"d":"1,251,237 "},{"v":147673,"d":"147,673 "},{"v":148824,"d":"148,824 "},{"v":148322,"d":"148,322 "},{"v":158865,"d":"158,865 "},{"v":157139,"d":"157,139 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15265,"d":"15,265 "},{"v":15070,"d":"15,070 "},{"v":14631,"d":"14,631 "},{"v":15514,"d":"15,514 "},{"v":15789,"d":"15,789 "},{"v":474,"d":"474 "},{"v":318,"d":"318 "},{"v":353,"d":"353 "},{"v":341,"d":"341 "},{"v":414,"d":"414 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":13844,"d":"13,844 "},{"v":16317,"d":"16,317 "},{"v":20410,"d":"20,410 "},{"v":14084,"d":"14,084 "},{"v":10228,"d":"10,228 "},{"v":220,"d":"220 "},{"v":225,"d":"225 "},{"v":550,"d":"550 "},{"v":417,"d":"417 "},{"v":318,"d":"318 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":162106,"d":"162,106 "},{"v":164455,"d":"164,455 "},{"v":181024,"d":"181,024 "},{"v":171234,"d":"171,234 "},{"v":172876,"d":"172,876 "},{"v":20777,"d":"20,777 "},{"v":20623,"d":"20,623 "},{"v":21095,"d":"21,095 "},{"v":22791,"d":"22,791 "},{"v":20773,"d":"20,773 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":7700,"d":"7,700 "},{"v":4130,"d":"4,130 "},{"v":3313,"d":"3,313 "},{"v":6982,"d":"6,982 "},{"v":9146,"d":"9,146 "},{"v":921,"d":"921 "},{"v":789,"d":"789 "},{"v":676,"d":"676 "},{"v":1780,"d":"1,780 "},{"v":885,"d":"885 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4427,"d":"4,427 "},{"v":4714,"d":"4,714 "},{"v":5784,"d":"5,784 "},{"v":5650,"d":"5,650 "},{"v":5762,"d":"5,762 "},{"v":438,"d":"438 "},{"v":515,"d":"515 "},{"v":800,"d":"800 "},{"v":861,"d":"861 "},{"v":909,"d":"909 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":16226,"d":"16,226 "},{"v":15720,"d":"15,720 "},{"v":15062,"d":"15,062 "},{"v":13802,"d":"13,802 "},{"v":13607,"d":"13,607 "},{"v":3053,"d":"3,053 "},{"v":2688,"d":"2,688 "},{"v":2982,"d":"2,982 "},{"v":2870,"d":"2,870 "},{"v":2322,"d":"2,322 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":116983,"d":"116,983 "},{"v":116651,"d":"116,651 "},{"v":117099,"d":"117,099 "},{"v":120810,"d":"120,810 "},{"v":121379,"d":"121,379 "},{"v":16283,"d":"16,283 "},{"v":16709,"d":"16,709 "},{"v":15240,"d":"15,240 "},{"v":14979,"d":"14,979 "},{"v":15309,"d":"15,309 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":336551,"d":"336,551 "},{"v":337058,"d":"337,058 "},{"v":357323,"d":"357,323 "},{"v":348076,"d":"348,076 "},{"v":348786,"d":"348,786 "},{"v":42166,"d":"42,166 "},{"v":41867,"d":"41,867 "},{"v":41697,"d":"41,697 "},{"v":44038,"d":"44,038 "},{"v":40929,"d":"40,929 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":59949,"d":"59,949 "},{"v":60084,"d":"60,084 "},{"v":63082,"d":"63,082 "},{"v":66080,"d":"66,080 "},{"v":67251,"d":"67,251 "},{"v":7188,"d":"7,188 "},{"v":7260,"d":"7,260 "},{"v":7957,"d":"7,957 "},{"v":7900,"d":"7,900 "},{"v":7773,"d":"7,773 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":206032,"d":"206,032 "},{"v":208101,"d":"208,101 "},{"v":217353,"d":"217,353 "},{"v":222198,"d":"222,198 "},{"v":225005,"d":"225,005 "},{"v":27735,"d":"27,735 "},{"v":28059,"d":"28,059 "},{"v":25936,"d":"25,936 "},{"v":28848,"d":"28,848 "},{"v":29078,"d":"29,078 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":117638,"d":"117,638 "},{"v":116932,"d":"116,932 "},{"v":116248,"d":"116,248 "},{"v":118423,"d":"118,423 "},{"v":114787,"d":"114,787 "},{"v":21510,"d":"21,510 "},{"v":21114,"d":"21,114 "},{"v":19943,"d":"19,943 "},{"v":21061,"d":"21,061 "},{"v":20683,"d":"20,683 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":720170,"d":"720,170 "},{"v":722176,"d":"722,176 "},{"v":754006,"d":"754,006 "},{"v":754777,"d":"754,777 "},{"v":755829,"d":"755,829 "},{"v":98600,"d":"98,600 "},{"v":98300,"d":"98,300 "},{"v":95533,"d":"95,533 "},{"v":101847,"d":"101,847 "},{"v":98463,"d":"98,463 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":100933,"d":"100,933 "},{"v":95959,"d":"95,959 "},{"v":94747,"d":"94,747 "},{"v":98480,"d":"98,480 "},{"v":100802,"d":"100,802 "},{"v":8860,"d":"8,860 "},{"v":9045,"d":"9,045 "},{"v":11021,"d":"11,021 "},{"v":18601,"d":"18,601 "},{"v":19471,"d":"19,471 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":369733,"d":"369,733 "},{"v":380623,"d":"380,623 "},{"v":388487,"d":"388,487 "},{"v":397383,"d":"397,383 "},{"v":394605,"d":"394,605 "},{"v":40213,"d":"40,213 "},{"v":41479,"d":"41,479 "},{"v":41768,"d":"41,768 "},{"v":38417,"d":"38,417 "},{"v":39204,"d":"39,204 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":470666,"d":"470,666 "},{"v":476583,"d":"476,583 "},{"v":483233,"d":"483,233 "},{"v":495863,"d":"495,863 "},{"v":495408,"d":"495,408 "},{"v":49073,"d":"49,073 "},{"v":50524,"d":"50,524 "},{"v":52788,"d":"52,788 "},{"v":57018,"d":"57,018 "},{"v":58676,"d":"58,676 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1190836,"d":"1,190,836 "},{"v":1198758,"d":"1,198,758 "},{"v":1237239,"d":"1,237,239 "},{"v":1250640,"d":"1,250,640 "},{"v":1251237,"d":"1,251,237 "},{"v":147673,"d":"147,673 "},{"v":148824,"d":"148,824 "},{"v":148322,"d":"148,322 "},{"v":158865,"d":"158,865 "},{"v":157139,"d":"157,139 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":86697,"d":"86,697 "},{"v":86227,"d":"86,227 "},{"v":94664,"d":"94,664 "},{"v":102572,"d":"102,572 "},{"v":92877,"d":"92,877 "},{"v":5369,"d":"5,369 "},{"v":6414,"d":"6,414 "},{"v":6941,"d":"6,941 "},{"v":10966,"d":"10,966 "},{"v":11770,"d":"11,770 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",6.58,6.39,6.17,7.02,6.42,8.94,9.36,9.24,{"v":11.3,"d":"11.30"},10.58]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",4.59,4.66,4.71,4.86,4.72,3.99,{"v":3.9,"d":"3.90"},{"v":3.9,"d":"3.90"},4.11,3.98]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",20.97,20.92,22.24,20.68,20.75,16.43,16.14,16.57,{"v":16,"d":"16.00"},15.73]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",35.54,35.31,36.53,36.03,{"v":35.3,"d":"35.30"},32.19,32.44,32.79,34.62,33.54]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",34.92,35.16,34.41,34.62,34.67,51.75,51.31,50.92,48.38,49.06]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",4.18,4.32,4.52,3.92,3.63,2.83,2.52,3.16,2.83,2.52]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",28.26,28.12,28.88,27.83,27.88,28.55,28.13,28.11,27.72,26.05]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.34,22.37,22.67,23.05,23.36,23.65,23.73,22.85,23.13,23.45]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",60.48,60.24,60.94,60.35,60.41,66.77,66.05,64.41,64.11,62.66]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",39.52,39.76,39.06,39.65,39.59,33.23,33.95,35.59,35.89,37.34]
["  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-2014Q1","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 2013_"," 2Q_\n 2013_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 1Q_\n 2013_"," 2Q_\n 2013_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":203674,"d":"203,674 "},{"v":206741,"d":"206,741 "},{"v":206032,"d":"206,032 "},{"v":241678,"d":"241,678 "},{"v":208715,"d":"208,715 "},{"v":287991,"d":"287,991 "},{"v":304117,"d":"304,117 "},{"v":306675,"d":"306,675 "},{"v":319947,"d":"319,947 "},{"v":304205,"d":"304,205 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":4740,"d":"4,740 "},{"v":4791,"d":"4,791 "},{"v":4907,"d":"4,907 "},{"v":5045,"d":"5,045 "},{"v":5024,"d":"5,024 "},{"v":4580,"d":"4,580 "},{"v":4659,"d":"4,659 "},{"v":4766,"d":"4,766 "},{"v":4908,"d":"4,908 "},{"v":4856,"d":"4,856 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":186889,"d":"186,889 "},{"v":190374,"d":"190,374 "},{"v":190854,"d":"190,854 "},{"v":220255,"d":"220,255 "},{"v":193155,"d":"193,155 "},{"v":270057,"d":"270,057 "},{"v":283014,"d":"283,014 "},{"v":287538,"d":"287,538 "},{"v":300675,"d":"300,675 "},{"v":286015,"d":"286,015 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":12046,"d":"12,046 "},{"v":11575,"d":"11,575 "},{"v":10270,"d":"10,270 "},{"v":16378,"d":"16,378 "},{"v":10536,"d":"10,536 "},{"v":13354,"d":"13,354 "},{"v":16443,"d":"16,443 "},{"v":14371,"d":"14,371 "},{"v":14364,"d":"14,364 "},{"v":13335,"d":"13,335 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1957,"d":"1,957 "},{"v":1524,"d":"1,524 "},{"v":1568,"d":"1,568 "},{"v":1711,"d":"1,711 "},{"v":1714,"d":"1,714 "},{"v":1952,"d":"1,952 "},{"v":1814,"d":"1,814 "},{"v":1812,"d":"1,812 "},{"v":1800,"d":"1,800 "},{"v":1800,"d":"1,800 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1816,"d":"1,816 "},{"v":2107,"d":"2,107 "},{"v":1918,"d":"1,918 "},{"v":1507,"d":"1,507 "},{"v":2045,"d":"2,045 "},{"v":365,"d":"365 "},{"v":1231,"d":"1,231 "},{"v":766,"d":"766 "},{"v":2026,"d":"2,026 "},{"v":881,"d":"881 "}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":11904,"d":"11,904 "},{"v":12158,"d":"12,158 "},{"v":10621,"d":"10,621 "},{"v":16175,"d":"16,175 "},{"v":10867,"d":"10,867 "},{"v":11767,"d":"11,767 "},{"v":15860,"d":"15,860 "},{"v":13325,"d":"13,325 "},{"v":14590,"d":"14,590 "},{"v":12415,"d":"12,415 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":3922,"d":"3,922 "},{"v":4202,"d":"4,202 "},{"v":3930,"d":"3,930 "},{"v":6162,"d":"6,162 "},{"v":3977,"d":"3,977 "},{"v":3792,"d":"3,792 "},{"v":4967,"d":"4,967 "},{"v":4524,"d":"4,524 "},{"v":4456,"d":"4,456 "},{"v":6592,"d":"6,592 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":7982,"d":"7,982 "},{"v":7956,"d":"7,956 "},{"v":6691,"d":"6,691 "},{"v":10012,"d":"10,012 "},{"v":6890,"d":"6,890 "},{"v":7975,"d":"7,975 "},{"v":10893,"d":"10,893 "},{"v":8800,"d":"8,800 "},{"v":10134,"d":"10,134 "},{"v":5823,"d":"5,823 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":10713,"d":"10,713 "},{"v":1701,"d":"1,701 "},{"v":1469,"d":"1,469 "},{"v":1902,"d":"1,902 "},{"v":8084,"d":"8,084 "},{"v":2211,"d":"2,211 "},{"v":2982,"d":"2,982 "},{"v":2387,"d":"2,387 "},{"v":2981,"d":"2,981 "},{"v":2995,"d":"2,995 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-2730,"d":"(2,730)"},{"v":6255,"d":"6,255 "},{"v":5222,"d":"5,222 "},{"v":8110,"d":"8,110 "},{"v":-1194,"d":"(1,194)"},{"v":5765,"d":"5,765 "},{"v":7911,"d":"7,911 "},{"v":6414,"d":"6,414 "},{"v":7152,"d":"7,152 "},{"v":2828,"d":"2,828 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":166924,"d":"166,924 "},{"v":161025,"d":"161,025 "},{"v":163962,"d":"163,962 "},{"v":166159,"d":"166,159 "},{"v":171359,"d":"171,359 "},{"v":166212,"d":"166,212 "},{"v":168984,"d":"168,984 "},{"v":175682,"d":"175,682 "},{"v":181513,"d":"181,513 "},{"v":186579,"d":"186,579 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-3520,"d":"(3,520)"},{"v":-3289,"d":"(3,289)"},{"v":-3383,"d":"(3,383)"},{"v":-2614,"d":"(2,614)"},{"v":-2234,"d":"(2,234)"},{"v":-3130,"d":"(3,130)"},{"v":-1742,"d":"(1,742)"},{"v":-1178,"d":"(1,178)"},{"v":-1355,"d":"(1,355)"},{"v":-1938,"d":"(1,938)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":160674,"d":"160,674 "},{"v":163992,"d":"163,992 "},{"v":165802,"d":"165,802 "},{"v":171656,"d":"171,656 "},{"v":167931,"d":"167,931 "},{"v":168846,"d":"168,846 "},{"v":175152,"d":"175,152 "},{"v":180918,"d":"180,918 "},{"v":187311,"d":"187,311 "},{"v":187470,"d":"187,470 "}]
["                         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.33,2.32,2.38,2.09,2.41,1.59,1.53,1.55,1.53,{"v":1.6,"d":"1.60"}]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",91.76,92.08,92.63,91.14,92.54,93.77,93.06,93.76,93.98,94.02]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",5.91,{"v":5.6,"d":"5.60"},4.98,6.78,5.05,4.64,5.41,4.69,4.49,4.38]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.96,0.74,0.76,0.71,0.82,0.68,{"v":0.6,"d":"0.60"},0.59,0.56,0.59]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",0.89,1.02,0.93,0.62,0.98,0.13,{"v":0.4,"d":"0.40"},0.25,0.63,0.29]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",5.84,5.88,5.15,6.69,5.21,4.09,5.22,4.34,4.56,4.08]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.93,2.03,1.91,2.55,1.91,1.32,1.63,1.48,1.39,2.17]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",3.92,3.85,3.25,4.14,{"v":3.3,"d":"3.30"},2.77,3.58,2.87,3.17,1.91]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",26.09,26.43,{"v":22.9,"d":"22.90"},33.34,22.93,19.69,26.21,21.76,23.84,20.09]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":17.5,"d":"17.50"},17.29,14.43,20.64,14.54,13.34,{"v":18,"d":"18.00"},14.37,16.56,9.42]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",10.47,10.63,8.85,13.64,9.15,{"v":8,"d":"8.00"},10.71,8.75,9.45,8.02]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",7.02,6.95,5.58,8.45,{"v":5.8,"d":"5.80"},5.42,7.36,5.78,6.56,3.76]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.21,{"v":1.2,"d":"1.20"},1.21,1.26,1.23,1.33,1.33,1.34,1.33,1.29]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",{"v":0.2,"d":"0.20"},0.19,0.15,{"v":0.2,"d":"0.20"},0.18,0.24,0.23,0.24,0.25,0.23]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.52,{"v":1.5,"d":"1.50"},1.38,1.51,1.47,1.53,1.53,{"v":1.5,"d":"1.50"},1.46,1.47]
["  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-2014Q1","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 2013_"," 2Q_\n 2013_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 1Q_\n 2013_"," 2Q_\n 2013_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":19445,"d":"19,445 "},{"v":19227,"d":"19,227 "},{"v":16907,"d":"16,907 "},{"v":19291,"d":"19,291 "},{"v":18373,"d":"18,373 "},{"v":28666,"d":"28,666 "},{"v":27301,"d":"27,301 "},{"v":29588,"d":"29,588 "},{"v":29015,"d":"29,015 "},{"v":27526,"d":"27,526 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":597,"d":"597 "},{"v":335,"d":"335 "},{"v":338,"d":"338 "},{"v":477,"d":"477 "},{"v":434,"d":"434 "},{"v":1118,"d":"1,118 "},{"v":1375,"d":"1,375 "},{"v":1448,"d":"1,448 "},{"v":1365,"d":"1,365 "},{"v":1424,"d":"1,424 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":20041,"d":"20,041 "},{"v":19562,"d":"19,562 "},{"v":17245,"d":"17,245 "},{"v":19768,"d":"19,768 "},{"v":18807,"d":"18,807 "},{"v":29784,"d":"29,784 "},{"v":28676,"d":"28,676 "},{"v":31037,"d":"31,037 "},{"v":30380,"d":"30,380 "},{"v":28950,"d":"28,950 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5422,"d":"5,422 "},{"v":4599,"d":"4,599 "},{"v":3878,"d":"3,878 "},{"v":6007,"d":"6,007 "},{"v":4719,"d":"4,719 "},{"v":9912,"d":"9,912 "},{"v":9882,"d":"9,882 "},{"v":10447,"d":"10,447 "},{"v":13748,"d":"13,748 "},{"v":11289,"d":"11,289 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":25463,"d":"25,463 "},{"v":24161,"d":"24,161 "},{"v":21122,"d":"21,122 "},{"v":25774,"d":"25,774 "},{"v":23526,"d":"23,526 "},{"v":39696,"d":"39,696 "},{"v":38558,"d":"38,558 "},{"v":41484,"d":"41,484 "},{"v":44128,"d":"44,128 "},{"v":40239,"d":"40,239 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":7445,"d":"7,445 "},{"v":7616,"d":"7,616 "},{"v":7860,"d":"7,860 "},{"v":8438,"d":"8,438 "},{"v":7998,"d":"7,998 "},{"v":41275,"d":"41,275 "},{"v":42488,"d":"42,488 "},{"v":44638,"d":"44,638 "},{"v":45791,"d":"45,791 "},{"v":44837,"d":"44,837 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":106582,"d":"106,582 "},{"v":107997,"d":"107,997 "},{"v":126885,"d":"126,885 "},{"v":111302,"d":"111,302 "},{"v":112008,"d":"112,008 "},{"v":118921,"d":"118,921 "},{"v":118749,"d":"118,749 "},{"v":123687,"d":"123,687 "},{"v":121854,"d":"121,854 "},{"v":122946,"d":"122,946 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":16154,"d":"16,154 "},{"v":16159,"d":"16,159 "},{"v":16978,"d":"16,978 "},{"v":16547,"d":"16,547 "},{"v":16736,"d":"16,736 "},{"v":20176,"d":"20,176 "},{"v":19276,"d":"19,276 "},{"v":20697,"d":"20,697 "},{"v":21809,"d":"21,809 "},{"v":20675,"d":"20,675 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":155645,"d":"155,645 "},{"v":155933,"d":"155,933 "},{"v":172844,"d":"172,844 "},{"v":162062,"d":"162,062 "},{"v":160268,"d":"160,268 "},{"v":220068,"d":"220,068 "},{"v":219071,"d":"219,071 "},{"v":230505,"d":"230,505 "},{"v":233582,"d":"233,582 "},{"v":228696,"d":"228,696 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":287887,"d":"287,887 "},{"v":293104,"d":"293,104 "},{"v":297327,"d":"297,327 "},{"v":301910,"d":"301,910 "},{"v":304247,"d":"304,247 "},{"v":243742,"d":"243,742 "},{"v":250119,"d":"250,119 "},{"v":256932,"d":"256,932 "},{"v":267536,"d":"267,536 "},{"v":272095,"d":"272,095 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":32187,"d":"32,187 "},{"v":32385,"d":"32,385 "},{"v":32669,"d":"32,669 "},{"v":33477,"d":"33,477 "},{"v":33665,"d":"33,665 "},{"v":35627,"d":"35,627 "},{"v":36014,"d":"36,014 "},{"v":36150,"d":"36,150 "},{"v":29760,"d":"29,760 "},{"v":29195,"d":"29,195 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":133086,"d":"133,086 "},{"v":136397,"d":"136,397 "},{"v":138994,"d":"138,994 "},{"v":140624,"d":"140,624 "},{"v":143405,"d":"143,405 "},{"v":126945,"d":"126,945 "},{"v":130138,"d":"130,138 "},{"v":133824,"d":"133,824 "},{"v":135944,"d":"135,944 "},{"v":139043,"d":"139,043 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":186988,"d":"186,988 "},{"v":189092,"d":"189,092 "},{"v":191002,"d":"191,002 "},{"v":194763,"d":"194,763 "},{"v":194507,"d":"194,507 "},{"v":152424,"d":"152,424 "},{"v":155994,"d":"155,994 "},{"v":159258,"d":"159,258 "},{"v":161351,"d":"161,351 "},{"v":162246,"d":"162,246 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":112189,"d":"112,189 "},{"v":112613,"d":"112,613 "},{"v":116005,"d":"116,005 "},{"v":117353,"d":"117,353 "},{"v":120239,"d":"120,239 "},{"v":215850,"d":"215,850 "},{"v":217231,"d":"217,231 "},{"v":219303,"d":"219,303 "},{"v":222664,"d":"222,664 "},{"v":228142,"d":"228,142 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":454822,"d":"454,822 "},{"v":457638,"d":"457,638 "},{"v":479851,"d":"479,851 "},{"v":474178,"d":"474,178 "},{"v":475014,"d":"475,014 "},{"v":588342,"d":"588,342 "},{"v":592296,"d":"592,296 "},{"v":609066,"d":"609,066 "},{"v":617597,"d":"617,597 "},{"v":619084,"d":"619,084 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1107,"d":"1,107 "},{"v":1051,"d":"1,051 "},{"v":1129,"d":"1,129 "},{"v":1112,"d":"1,112 "},{"v":1575,"d":"1,575 "},{"v":13684,"d":"13,684 "},{"v":13702,"d":"13,702 "},{"v":13149,"d":"13,149 "},{"v":14062,"d":"14,062 "},{"v":13800,"d":"13,800 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":9001,"d":"9,001 "},{"v":11250,"d":"11,250 "},{"v":15637,"d":"15,637 "},{"v":9313,"d":"9,313 "},{"v":5595,"d":"5,595 "},{"v":4622,"d":"4,622 "},{"v":4843,"d":"4,843 "},{"v":4223,"d":"4,223 "},{"v":4353,"d":"4,353 "},{"v":4315,"d":"4,315 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":60600,"d":"60,600 "},{"v":62170,"d":"62,170 "},{"v":72017,"d":"72,017 "},{"v":61066,"d":"61,066 "},{"v":63878,"d":"63,878 "},{"v":80728,"d":"80,728 "},{"v":81662,"d":"81,662 "},{"v":87912,"d":"87,912 "},{"v":87377,"d":"87,377 "},{"v":88225,"d":"88,225 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":3701,"d":"3,701 "},{"v":1018,"d":"1,018 "},{"v":353,"d":"353 "},{"v":2465,"d":"2,465 "},{"v":3141,"d":"3,141 "},{"v":3078,"d":"3,078 "},{"v":2323,"d":"2,323 "},{"v":2284,"d":"2,284 "},{"v":2737,"d":"2,737 "},{"v":5121,"d":"5,121 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":214,"d":"214 "},{"v":234,"d":"234 "},{"v":447,"d":"447 "},{"v":408,"d":"408 "},{"v":459,"d":"459 "},{"v":3775,"d":"3,775 "},{"v":3964,"d":"3,964 "},{"v":4537,"d":"4,537 "},{"v":4382,"d":"4,382 "},{"v":4394,"d":"4,394 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":6382,"d":"6,382 "},{"v":6798,"d":"6,798 "},{"v":6969,"d":"6,969 "},{"v":6540,"d":"6,540 "},{"v":5751,"d":"5,751 "},{"v":6790,"d":"6,790 "},{"v":6234,"d":"6,234 "},{"v":5110,"d":"5,110 "},{"v":4393,"d":"4,393 "},{"v":5533,"d":"5,533 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":47350,"d":"47,350 "},{"v":47481,"d":"47,481 "},{"v":46715,"d":"46,715 "},{"v":47486,"d":"47,486 "},{"v":49644,"d":"49,644 "},{"v":53351,"d":"53,351 "},{"v":52461,"d":"52,461 "},{"v":55144,"d":"55,144 "},{"v":58345,"d":"58,345 "},{"v":56426,"d":"56,426 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":128355,"d":"128,355 "},{"v":130002,"d":"130,002 "},{"v":143268,"d":"143,268 "},{"v":128390,"d":"128,390 "},{"v":130043,"d":"130,043 "},{"v":166030,"d":"166,030 "},{"v":165190,"d":"165,190 "},{"v":172359,"d":"172,359 "},{"v":175648,"d":"175,648 "},{"v":177814,"d":"177,814 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":12460,"d":"12,460 "},{"v":11461,"d":"11,461 "},{"v":12684,"d":"12,684 "},{"v":11878,"d":"11,878 "},{"v":12566,"d":"12,566 "},{"v":40302,"d":"40,302 "},{"v":41363,"d":"41,363 "},{"v":42441,"d":"42,441 "},{"v":46302,"d":"46,302 "},{"v":46912,"d":"46,912 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":91090,"d":"91,090 "},{"v":91503,"d":"91,503 "},{"v":97235,"d":"97,235 "},{"v":99043,"d":"99,043 "},{"v":102757,"d":"102,757 "},{"v":87207,"d":"87,207 "},{"v":88539,"d":"88,539 "},{"v":94182,"d":"94,182 "},{"v":94307,"d":"94,307 "},{"v":93170,"d":"93,170 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":40427,"d":"40,427 "},{"v":40639,"d":"40,639 "},{"v":41186,"d":"41,186 "},{"v":40840,"d":"40,840 "},{"v":40124,"d":"40,124 "},{"v":55701,"d":"55,701 "},{"v":55179,"d":"55,179 "},{"v":55118,"d":"55,118 "},{"v":56522,"d":"56,522 "},{"v":53980,"d":"53,980 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":272331,"d":"272,331 "},{"v":273605,"d":"273,605 "},{"v":294373,"d":"294,373 "},{"v":280151,"d":"280,151 "},{"v":285490,"d":"285,490 "},{"v":349239,"d":"349,239 "},{"v":350271,"d":"350,271 "},{"v":364100,"d":"364,100 "},{"v":372779,"d":"372,779 "},{"v":371877,"d":"371,877 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":21816,"d":"21,816 "},{"v":20041,"d":"20,041 "},{"v":19677,"d":"19,677 "},{"v":22372,"d":"22,372 "},{"v":21593,"d":"21,593 "},{"v":70256,"d":"70,256 "},{"v":66874,"d":"66,874 "},{"v":64049,"d":"64,049 "},{"v":57507,"d":"57,507 "},{"v":59738,"d":"59,738 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":160674,"d":"160,674 "},{"v":163992,"d":"163,992 "},{"v":165802,"d":"165,802 "},{"v":171656,"d":"171,656 "},{"v":167931,"d":"167,931 "},{"v":168846,"d":"168,846 "},{"v":175152,"d":"175,152 "},{"v":180918,"d":"180,918 "},{"v":187311,"d":"187,311 "},{"v":187470,"d":"187,470 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":182490,"d":"182,490 "},{"v":184033,"d":"184,033 "},{"v":185478,"d":"185,478 "},{"v":194027,"d":"194,027 "},{"v":189524,"d":"189,524 "},{"v":239103,"d":"239,103 "},{"v":242026,"d":"242,026 "},{"v":244966,"d":"244,966 "},{"v":244817,"d":"244,817 "},{"v":247208,"d":"247,208 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":454822,"d":"454,822 "},{"v":457638,"d":"457,638 "},{"v":479851,"d":"479,851 "},{"v":474178,"d":"474,178 "},{"v":475014,"d":"475,014 "},{"v":588342,"d":"588,342 "},{"v":592296,"d":"592,296 "},{"v":609066,"d":"609,066 "},{"v":617597,"d":"617,597 "},{"v":619084,"d":"619,084 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":27290,"d":"27,290 "},{"v":25932,"d":"25,932 "},{"v":29577,"d":"29,577 "},{"v":33672,"d":"33,672 "},{"v":30225,"d":"30,225 "},{"v":54038,"d":"54,038 "},{"v":53881,"d":"53,881 "},{"v":58146,"d":"58,146 "},{"v":57934,"d":"57,934 "},{"v":50882,"d":"50,882 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5.6,"d":"5.60"},5.28,{"v":4.4,"d":"4.40"},5.44,4.95,6.75,6.51,6.81,7.15,{"v":6.5,"d":"6.50"}]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",1.64,1.66,1.64,1.78,1.68,7.02,7.17,7.33,7.41,7.24]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",23.43,{"v":23.6,"d":"23.60"},26.44,23.47,23.58,20.21,20.05,20.31,19.73,19.86]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",34.22,34.07,36.02,34.18,33.74,{"v":37.4,"d":"37.40"},36.99,37.85,37.82,36.94]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",41.11,41.32,{"v":39.8,"d":"39.80"},41.07,40.95,25.91,26.34,26.15,26.13,26.21]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",3.67,4.22,5.04,3.66,2.82,4.91,4.85,4.44,{"v":4.4,"d":"4.40"},4.53]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",28.22,28.41,29.86,27.08,27.38,28.22,27.89,{"v":28.3,"d":"28.30"},28.44,28.72]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.77,{"v":22.5,"d":"22.50"},22.91,23.39,24.28,21.67,21.93,22.43,22.77,22.63]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",59.88,59.79,61.35,59.08,{"v":60.1,"d":"60.10"},59.36,59.14,59.78,60.36,60.07]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",40.12,40.21,38.65,40.92,{"v":39.9,"d":"39.90"},40.64,40.86,40.22,39.64,39.93]
["  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-2014Q1","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"]
["2003 …………………………………………………………………………………………...………………………………………………..",{"v":367028,"d":"367,028 "},{"v":369883,"d":"369,883 "},{"v":391315,"d":"391,315 "},{"v":398840,"d":"398,840 "}]
["2004 …………………………………………………………………………………………...………………………………………………..",{"v":407175,"d":"407,175 "},{"v":410503,"d":"410,503 "},{"v":421529,"d":"421,529 "},{"v":427172,"d":"427,172 "}]
["2005 …………………………………………………………………………………………...………………………………………………..",{"v":438596,"d":"438,596 "},{"v":447565,"d":"447,565 "},{"v":458344,"d":"458,344 "},{"v":467563,"d":"467,563 "}]
["2006 …………………………………………………………………………………………...………………………………………………..",{"v":480851,"d":"480,851 "},{"v":492912,"d":"492,912 "},{"v":497439,"d":"497,439 "},{"v":501689,"d":"501,689 "}]
["2007 …………………………………………………………………………………………...………………………………………………..",{"v":510298,"d":"510,298 "},{"v":514812,"d":"514,812 "},{"v":515833,"d":"515,833 "},{"v":520808,"d":"520,808 "}]
["2008 …………………………………………………………………………………………...………………………………………………..",{"v":523717,"d":"523,717 "},{"v":536354,"d":"536,354 "},{"v":531341,"d":"531,341 "},{"v":500865,"d":"500,865 "}]
["2009 …………………………………………………………………………………………...………………………………………………..",{"v":496062,"d":"496,062 "},{"v":495150,"d":"495,150 "},{"v":508468,"d":"508,468 "},{"v":520028,"d":"520,028 "}]
["2010 …………………………………………………………………………………………...………………………………………………..",{"v":532092,"d":"532,092 "},{"v":534650,"d":"534,650 "},{"v":539675,"d":"539,675 "},{"v":551279,"d":"551,279 "}]
["2011 …………………………………………………………………………………………...………………………………………………..",{"v":566671,"d":"566,671 "},{"v":585169,"d":"585,169 "},{"v":586210,"d":"586,210 "},{"v":587309,"d":"587,309 "}]
["2012 …………………………………………………………………………………………...………………………………………………..",{"v":602102,"d":"602,102 "},{"v":598073,"d":"598,073 "},{"v":603418,"d":"603,418 "},{"v":612651,"d":"612,651 "}]
["2013 …………………………………………………………………………………………...………………………………………………..",{"v":616942,"d":"616,942 "},{"v":627010,"d":"627,010 "},{"v":636556,"d":"636,556 "},{"v":643028,"d":"643,028 "}]
["2014 …………………………………………………………………………………………...………………………………………………..",{"v":639566,"d":"639,566 "}]
[]
["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."]