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

{"sheet":"RET_4_0-2014Q2","index":0,"n_rows":47,"n_cols":11,"rows_kept":47,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[22,1,22,4],[22,6,22,9],[33,1,33,4],[33,6,33,9],[46,0,46,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 4.0 -- Income Statement  For Corporations in NAICS Retail Trade Sector, and Retail Trade Subsector 445,\n                              Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"All Retail Trade\nTotal Assets $50 Million and Over",{"$nulls":4},"Food and Beverage Stores\nTotal Assets $50 Million and Over"]
["Item"," 2Q_\n 2013_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 2Q_\n 2014_"," 2Q_\n 2013_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 2Q_\n 2014_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":623097,"d":"623,097 "},{"v":622566,"d":"622,566 "},{"v":674474,"d":"674,474 "},{"v":623898,"d":"623,898 "},{"v":656368,"d":"656,368 "},{"v":112227,"d":"112,227 "},{"v":109871,"d":"109,871 "},{"v":112895,"d":"112,895 "},{"v":113582,"d":"113,582 "},{"v":115623,"d":"115,623 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":11663,"d":"11,663 "},{"v":11864,"d":"11,864 "},{"v":12281,"d":"12,281 "},{"v":12218,"d":"12,218 "},{"v":12502,"d":"12,502 "},{"v":2212,"d":"2,212 "},{"v":2190,"d":"2,190 "},{"v":2321,"d":"2,321 "},{"v":2325,"d":"2,325 "},{"v":2383,"d":"2,383 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":579616,"d":"579,616 "},{"v":582982,"d":"582,982 "},{"v":628005,"d":"628,005 "},{"v":583789,"d":"583,789 "},{"v":611597,"d":"611,597 "},{"v":106223,"d":"106,223 "},{"v":104628,"d":"104,628 "},{"v":107117,"d":"107,117 "},{"v":107672,"d":"107,672 "},{"v":109877,"d":"109,877 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":31819,"d":"31,819 "},{"v":27720,"d":"27,720 "},{"v":34188,"d":"34,188 "},{"v":27891,"d":"27,891 "},{"v":32269,"d":"32,269 "},{"v":3791,"d":"3,791 "},{"v":3053,"d":"3,053 "},{"v":3457,"d":"3,457 "},{"v":3584,"d":"3,584 "},{"v":3364,"d":"3,364 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4102,"d":"4,102 "},{"v":4053,"d":"4,053 "},{"v":4188,"d":"4,188 "},{"v":4174,"d":"4,174 "},{"v":4544,"d":"4,544 "},{"v":763,"d":"763 "},{"v":673,"d":"673 "},{"v":689,"d":"689 "},{"v":677,"d":"677 "},{"v":671,"d":"671 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":3355,"d":"3,355 "},{"v":2792,"d":"2,792 "},{"v":6695,"d":"6,695 "},{"v":1884,"d":"1,884 "},{"v":3567,"d":"3,567 "},{"v":19,"d":"19 "},{"v":107,"d":"107 "},{"v":3327,"d":"3,327 "},{"v":45,"d":"45 "},{"v":125,"d":"125 "}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":31072,"d":"31,072 "},{"v":26460,"d":"26,460 "},{"v":36694,"d":"36,694 "},{"v":25601,"d":"25,601 "},{"v":31292,"d":"31,292 "},{"v":3047,"d":"3,047 "},{"v":2486,"d":"2,486 "},{"v":6096,"d":"6,096 "},{"v":2952,"d":"2,952 "},{"v":2817,"d":"2,817 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":9921,"d":"9,921 "},{"v":8995,"d":"8,995 "},{"v":11150,"d":"11,150 "},{"v":11709,"d":"11,709 "},{"v":10364,"d":"10,364 "},{"v":750,"d":"750 "},{"v":527,"d":"527 "},{"v":547,"d":"547 "},{"v":1072,"d":"1,072 "},{"v":1019,"d":"1,019 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":21150,"d":"21,150 "},{"v":17464,"d":"17,464 "},{"v":25544,"d":"25,544 "},{"v":13892,"d":"13,892 "},{"v":20928,"d":"20,928 "},{"v":2297,"d":"2,297 "},{"v":1959,"d":"1,959 "},{"v":5548,"d":"5,548 "},{"v":1881,"d":"1,881 "},{"v":1799,"d":"1,799 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":5023,"d":"5,023 "},{"v":4473,"d":"4,473 "},{"v":5584,"d":"5,584 "},{"v":11415,"d":"11,415 "},{"v":6108,"d":"6,108 "},{"v":341,"d":"341 "},{"v":625,"d":"625 "},{"v":954,"d":"954 "},{"v":690,"d":"690 "},{"v":739,"d":"739 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":16128,"d":"16,128 "},{"v":12992,"d":"12,992 "},{"v":19960,"d":"19,960 "},{"v":2477,"d":"2,477 "},{"v":14820,"d":"14,820 "},{"v":1956,"d":"1,956 "},{"v":1334,"d":"1,334 "},{"v":4595,"d":"4,595 "},{"v":1191,"d":"1,191 "},{"v":1059,"d":"1,059 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":369725,"d":"369,725 "},{"v":380193,"d":"380,193 "},{"v":388411,"d":"388,411 "},{"v":398168,"d":"398,168 "},{"v":384469,"d":"384,469 "},{"v":39711,"d":"39,711 "},{"v":40481,"d":"40,481 "},{"v":40534,"d":"40,534 "},{"v":39833,"d":"39,833 "},{"v":41229,"d":"41,229 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-5219,"d":"(5,219)"},{"v":-4605,"d":"(4,605)"},{"v":-10671,"d":"(10,671)"},{"v":-15530,"d":"(15,530)"},{"v":-3626,"d":"(3,626)"},{"v":-188,"d":"(188)"},{"v":-44,"d":"(44)"},{"v":-6757,"d":"(6,757)"},{"v":62,"d":"62 "},{"v":-326,"d":"(326)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":380633,"d":"380,633 "},{"v":388579,"d":"388,579 "},{"v":397700,"d":"397,700 "},{"v":385115,"d":"385,115 "},{"v":395663,"d":"395,663 "},{"v":41479,"d":"41,479 "},{"v":41771,"d":"41,771 "},{"v":38372,"d":"38,372 "},{"v":41086,"d":"41,086 "},{"v":41961,"d":"41,961 "}]
["                         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.87,1.91,1.82,1.96,{"v":1.9,"d":"1.90"},1.97,1.99,2.06,2.05,2.06]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",93.02,93.64,93.11,93.57,93.18,94.65,95.23,94.88,{"v":94.8,"d":"94.80"},95.03]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",5.11,4.45,5.07,4.47,4.92,3.38,2.78,3.06,3.16,2.91]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.66,0.65,0.62,0.67,0.69,0.68,0.61,0.61,{"v":0.6,"d":"0.60"},0.58]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",0.54,0.45,0.99,{"v":0.3,"d":"0.30"},0.54,0.02,{"v":0.1,"d":"0.10"},2.95,0.04,0.11]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",4.99,4.25,5.44,{"v":4.1,"d":"4.10"},4.77,2.72,2.26,{"v":5.4,"d":"5.40"},{"v":2.6,"d":"2.60"},2.44]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.59,1.44,1.65,1.88,1.58,0.67,0.48,0.48,0.94,0.88]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",3.39,2.81,3.79,2.23,3.19,2.05,1.78,4.91,1.66,1.56]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",26.08,{"v":21.9,"d":"21.90"},29.48,{"v":20.7,"d":"20.70"},24.95,24.12,18.84,43.32,21.24,20.17]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",17.75,14.46,20.52,11.23,16.68,18.19,14.84,39.43,13.53,12.87]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",10.37,8.55,11.73,8.19,9.95,8.19,6.71,15.42,7.64,{"v":7.4,"d":"7.40"}]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",7.06,5.65,8.17,4.44,6.65,6.17,5.28,14.04,4.87,4.72]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.26,1.26,{"v":1.3,"d":"1.30"},1.27,1.27,1.15,1.16,1.25,1.25,1.25]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.23,0.21,0.25,0.23,0.23,0.33,0.33,0.41,0.39,0.38]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.49,1.44,1.48,1.47,1.49,1.29,1.37,1.37,1.35,1.41]
["  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-2014Q2","index":1,"n_rows":61,"n_cols":11,"rows_kept":61,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[49,1,49,4],[49,6,49,9],[60,0,60,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 4.1 -- Balance Sheet  For Corporations in NAICS Retail Trade Sector, and Retail Trade Subsector 445,\n                               Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"All Retail Trade\nTotal Assets $50 Million and Over",{"$nulls":4},"Food and Beverage Stores\nTotal Assets $50 Million and Over"]
["Item"," 2Q_\n 2013_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 2Q_\n 2014_"," 2Q_\n 2013_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 2Q_\n 2014_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":57377,"d":"57,377 "},{"v":57297,"d":"57,297 "},{"v":59760,"d":"59,760 "},{"v":58430,"d":"58,430 "},{"v":60279,"d":"60,279 "},{"v":10849,"d":"10,849 "},{"v":10875,"d":"10,875 "},{"v":11639,"d":"11,639 "},{"v":12123,"d":"12,123 "},{"v":11298,"d":"11,298 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":2190,"d":"2,190 "},{"v":2153,"d":"2,153 "},{"v":5780,"d":"5,780 "},{"v":3527,"d":"3,527 "},{"v":4325,"d":"4,325 "},{"v":480,"d":"480 "},{"v":367,"d":"367 "},{"v":3943,"d":"3,943 "},{"v":1774,"d":"1,774 "},{"v":2011,"d":"2,011 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":59568,"d":"59,568 "},{"v":59450,"d":"59,450 "},{"v":65539,"d":"65,539 "},{"v":61957,"d":"61,957 "},{"v":64604,"d":"64,604 "},{"v":11329,"d":"11,329 "},{"v":11243,"d":"11,243 "},{"v":15582,"d":"15,582 "},{"v":13897,"d":"13,897 "},{"v":13309,"d":"13,309 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":17082,"d":"17,082 "},{"v":16849,"d":"16,849 "},{"v":22322,"d":"22,322 "},{"v":18899,"d":"18,899 "},{"v":17521,"d":"17,521 "},{"v":2602,"d":"2,602 "},{"v":2455,"d":"2,455 "},{"v":2368,"d":"2,368 "},{"v":2542,"d":"2,542 "},{"v":1942,"d":"1,942 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":76650,"d":"76,650 "},{"v":76300,"d":"76,300 "},{"v":87861,"d":"87,861 "},{"v":80856,"d":"80,856 "},{"v":82124,"d":"82,124 "},{"v":13930,"d":"13,930 "},{"v":13697,"d":"13,697 "},{"v":17951,"d":"17,951 "},{"v":16439,"d":"16,439 "},{"v":15251,"d":"15,251 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":55898,"d":"55,898 "},{"v":58304,"d":"58,304 "},{"v":60776,"d":"60,776 "},{"v":58541,"d":"58,541 "},{"v":60639,"d":"60,639 "},{"v":5808,"d":"5,808 "},{"v":5785,"d":"5,785 "},{"v":6525,"d":"6,525 "},{"v":6016,"d":"6,016 "},{"v":5519,"d":"5,519 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":250777,"d":"250,777 "},{"v":275119,"d":"275,119 "},{"v":258280,"d":"258,280 "},{"v":260027,"d":"260,027 "},{"v":260199,"d":"260,199 "},{"v":24025,"d":"24,025 "},{"v":24571,"d":"24,571 "},{"v":25416,"d":"25,416 "},{"v":25059,"d":"25,059 "},{"v":24782,"d":"24,782 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":39952,"d":"39,952 "},{"v":42272,"d":"42,272 "},{"v":43210,"d":"43,210 "},{"v":42164,"d":"42,164 "},{"v":42028,"d":"42,028 "},{"v":4518,"d":"4,518 "},{"v":4577,"d":"4,577 "},{"v":5112,"d":"5,112 "},{"v":4798,"d":"4,798 "},{"v":4252,"d":"4,252 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":423278,"d":"423,278 "},{"v":451995,"d":"451,995 "},{"v":450128,"d":"450,128 "},{"v":441588,"d":"441,588 "},{"v":444991,"d":"444,991 "},{"v":48281,"d":"48,281 "},{"v":48630,"d":"48,630 "},{"v":55004,"d":"55,004 "},{"v":52312,"d":"52,312 "},{"v":49804,"d":"49,804 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":685810,"d":"685,810 "},{"v":693708,"d":"693,708 "},{"v":711401,"d":"711,401 "},{"v":717863,"d":"717,863 "},{"v":727987,"d":"727,987 "},{"v":142585,"d":"142,585 "},{"v":139460,"d":"139,460 "},{"v":140623,"d":"140,623 "},{"v":139649,"d":"139,649 "},{"v":140231,"d":"140,231 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":79512,"d":"79,512 "},{"v":79572,"d":"79,572 "},{"v":74010,"d":"74,010 "},{"v":73997,"d":"73,997 "},{"v":74230,"d":"74,230 "},{"v":11088,"d":"11,088 "},{"v":10729,"d":"10,729 "},{"v":10956,"d":"10,956 "},{"v":11097,"d":"11,097 "},{"v":11212,"d":"11,212 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":343854,"d":"343,854 "},{"v":347489,"d":"347,489 "},{"v":351119,"d":"351,119 "},{"v":357700,"d":"357,700 "},{"v":364776,"d":"364,776 "},{"v":77316,"d":"77,316 "},{"v":74666,"d":"74,666 "},{"v":74719,"d":"74,719 "},{"v":74862,"d":"74,862 "},{"v":74839,"d":"74,839 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":421467,"d":"421,467 "},{"v":425791,"d":"425,791 "},{"v":434292,"d":"434,292 "},{"v":434160,"d":"434,160 "},{"v":437442,"d":"437,442 "},{"v":76358,"d":"76,358 "},{"v":75523,"d":"75,523 "},{"v":76860,"d":"76,860 "},{"v":75884,"d":"75,884 "},{"v":76603,"d":"76,603 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":353997,"d":"353,997 "},{"v":359461,"d":"359,461 "},{"v":366958,"d":"366,958 "},{"v":374629,"d":"374,629 "},{"v":375753,"d":"375,753 "},{"v":24186,"d":"24,186 "},{"v":24163,"d":"24,163 "},{"v":26265,"d":"26,265 "},{"v":26331,"d":"26,331 "},{"v":25965,"d":"25,965 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1198742,"d":"1,198,742 "},{"v":1237247,"d":"1,237,247 "},{"v":1251377,"d":"1,251,377 "},{"v":1250377,"d":"1,250,377 "},{"v":1258186,"d":"1,258,186 "},{"v":148824,"d":"148,824 "},{"v":148316,"d":"148,316 "},{"v":158129,"d":"158,129 "},{"v":154527,"d":"154,527 "},{"v":152372,"d":"152,372 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15070,"d":"15,070 "},{"v":14635,"d":"14,635 "},{"v":15504,"d":"15,504 "},{"v":15595,"d":"15,595 "},{"v":15581,"d":"15,581 "},{"v":318,"d":"318 "},{"v":353,"d":"353 "},{"v":341,"d":"341 "},{"v":414,"d":"414 "},{"v":413,"d":"413 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":16317,"d":"16,317 "},{"v":20410,"d":"20,410 "},{"v":14047,"d":"14,047 "},{"v":9783,"d":"9,783 "},{"v":9391,"d":"9,391 "},{"v":225,"d":"225 "},{"v":550,"d":"550 "},{"v":417,"d":"417 "},{"v":395,"d":"395 "},{"v":332,"d":"332 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":164351,"d":"164,351 "},{"v":180951,"d":"180,951 "},{"v":170925,"d":"170,925 "},{"v":174954,"d":"174,954 "},{"v":177201,"d":"177,201 "},{"v":20623,"d":"20,623 "},{"v":21095,"d":"21,095 "},{"v":22791,"d":"22,791 "},{"v":21607,"d":"21,607 "},{"v":20921,"d":"20,921 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":4130,"d":"4,130 "},{"v":3331,"d":"3,331 "},{"v":6941,"d":"6,941 "},{"v":9952,"d":"9,952 "},{"v":7246,"d":"7,246 "},{"v":789,"d":"789 "},{"v":676,"d":"676 "},{"v":1780,"d":"1,780 "},{"v":1123,"d":"1,123 "},{"v":472,"d":"472 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4714,"d":"4,714 "},{"v":5785,"d":"5,785 "},{"v":5645,"d":"5,645 "},{"v":5743,"d":"5,743 "},{"v":6303,"d":"6,303 "},{"v":515,"d":"515 "},{"v":801,"d":"801 "},{"v":861,"d":"861 "},{"v":891,"d":"891 "},{"v":850,"d":"850 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15730,"d":"15,730 "},{"v":15071,"d":"15,071 "},{"v":13429,"d":"13,429 "},{"v":14145,"d":"14,145 "},{"v":14716,"d":"14,716 "},{"v":2698,"d":"2,698 "},{"v":2992,"d":"2,992 "},{"v":2879,"d":"2,879 "},{"v":3352,"d":"3,352 "},{"v":2041,"d":"2,041 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":116770,"d":"116,770 "},{"v":117196,"d":"117,196 "},{"v":120627,"d":"120,627 "},{"v":118838,"d":"118,838 "},{"v":119954,"d":"119,954 "},{"v":16753,"d":"16,753 "},{"v":15278,"d":"15,278 "},{"v":15005,"d":"15,005 "},{"v":14183,"d":"14,183 "},{"v":14671,"d":"14,671 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":337081,"d":"337,081 "},{"v":357378,"d":"357,378 "},{"v":347119,"d":"347,119 "},{"v":349009,"d":"349,009 "},{"v":350393,"d":"350,393 "},{"v":41921,"d":"41,921 "},{"v":41744,"d":"41,744 "},{"v":44073,"d":"44,073 "},{"v":41965,"d":"41,965 "},{"v":39698,"d":"39,698 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":60030,"d":"60,030 "},{"v":63030,"d":"63,030 "},{"v":66042,"d":"66,042 "},{"v":67557,"d":"67,557 "},{"v":65780,"d":"65,780 "},{"v":7206,"d":"7,206 "},{"v":7906,"d":"7,906 "},{"v":7865,"d":"7,865 "},{"v":7703,"d":"7,703 "},{"v":7391,"d":"7,391 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":208103,"d":"208,103 "},{"v":217352,"d":"217,352 "},{"v":221670,"d":"221,670 "},{"v":223723,"d":"223,723 "},{"v":223882,"d":"223,882 "},{"v":28059,"d":"28,059 "},{"v":25936,"d":"25,936 "},{"v":28848,"d":"28,848 "},{"v":28453,"d":"28,453 "},{"v":28530,"d":"28,530 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":116932,"d":"116,932 "},{"v":116239,"d":"116,239 "},{"v":118724,"d":"118,724 "},{"v":115398,"d":"115,398 "},{"v":116359,"d":"116,359 "},{"v":21114,"d":"21,114 "},{"v":19938,"d":"19,938 "},{"v":21061,"d":"21,061 "},{"v":20804,"d":"20,804 "},{"v":20871,"d":"20,871 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":722146,"d":"722,146 "},{"v":754000,"d":"754,000 "},{"v":753554,"d":"753,554 "},{"v":755687,"d":"755,687 "},{"v":756414,"d":"756,414 "},{"v":98300,"d":"98,300 "},{"v":95523,"d":"95,523 "},{"v":101847,"d":"101,847 "},{"v":98925,"d":"98,925 "},{"v":96490,"d":"96,490 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":95962,"d":"95,962 "},{"v":94668,"d":"94,668 "},{"v":100123,"d":"100,123 "},{"v":109575,"d":"109,575 "},{"v":106109,"d":"106,109 "},{"v":9045,"d":"9,045 "},{"v":11022,"d":"11,022 "},{"v":17910,"d":"17,910 "},{"v":14516,"d":"14,516 "},{"v":13921,"d":"13,921 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":380633,"d":"380,633 "},{"v":388579,"d":"388,579 "},{"v":397700,"d":"397,700 "},{"v":385115,"d":"385,115 "},{"v":395663,"d":"395,663 "},{"v":41479,"d":"41,479 "},{"v":41771,"d":"41,771 "},{"v":38372,"d":"38,372 "},{"v":41086,"d":"41,086 "},{"v":41961,"d":"41,961 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":476596,"d":"476,596 "},{"v":483247,"d":"483,247 "},{"v":497823,"d":"497,823 "},{"v":494690,"d":"494,690 "},{"v":501772,"d":"501,772 "},{"v":50524,"d":"50,524 "},{"v":52794,"d":"52,794 "},{"v":56282,"d":"56,282 "},{"v":55602,"d":"55,602 "},{"v":55882,"d":"55,882 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1198742,"d":"1,198,742 "},{"v":1237247,"d":"1,237,247 "},{"v":1251377,"d":"1,251,377 "},{"v":1250377,"d":"1,250,377 "},{"v":1258186,"d":"1,258,186 "},{"v":148824,"d":"148,824 "},{"v":148316,"d":"148,316 "},{"v":158129,"d":"158,129 "},{"v":154527,"d":"154,527 "},{"v":152372,"d":"152,372 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":86196,"d":"86,196 "},{"v":94616,"d":"94,616 "},{"v":103010,"d":"103,010 "},{"v":92579,"d":"92,579 "},{"v":94597,"d":"94,597 "},{"v":6360,"d":"6,360 "},{"v":6887,"d":"6,887 "},{"v":10931,"d":"10,931 "},{"v":10347,"d":"10,347 "},{"v":10106,"d":"10,106 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",6.39,6.17,7.02,6.47,6.53,9.36,9.24,11.35,10.64,10.01]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",4.66,4.71,4.86,4.68,4.82,{"v":3.9,"d":"3.90"},{"v":3.9,"d":"3.90"},4.13,3.89,3.62]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",20.92,22.24,20.64,{"v":20.8,"d":"20.80"},20.68,16.14,16.57,16.07,16.22,16.26]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",35.31,36.53,35.97,35.32,35.37,32.44,32.79,34.78,33.85,32.69]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",35.16,34.41,34.71,34.72,34.77,51.31,50.92,48.61,49.11,50.27]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",4.32,4.52,3.89,3.62,3.66,2.52,3.17,2.84,3.27,2.39]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",28.12,28.88,27.74,27.91,27.85,28.17,28.14,27.87,27.16,26.05]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.37,22.66,22.99,{"v":23.3,"d":"23.30"},23.02,{"v":23.7,"d":"23.70"},22.82,23.22,{"v":23.4,"d":"23.40"},23.57]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",60.24,60.94,60.22,60.44,60.12,66.05,{"v":64.4,"d":"64.40"},64.41,64.02,63.33]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",39.76,39.06,39.78,39.56,39.88,33.95,{"v":35.6,"d":"35.60"},35.59,35.98,36.67]
["  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-2014Q2","index":2,"n_rows":47,"n_cols":11,"rows_kept":47,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[22,1,22,4],[22,6,22,9],[33,1,33,4],[33,6,33,9],[46,0,46,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 5.0 -- Income Statement  For Corporations in NAICS Retail Trade Subsectors 448 and 452, and\n                               All Other Retail Trade Subsectors, Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"Clothing and General Merchandise Stores\nTotal Assets $50 Million and Over",{"$nulls":4},"All Other Retail Trade\nTotal Assets $50 Million and Over"]
["Item"," 2Q_\n 2013_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 2Q_\n 2014_"," 2Q_\n 2013_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 2Q_\n 2014_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":206741,"d":"206,741 "},{"v":206016,"d":"206,016 "},{"v":241833,"d":"241,833 "},{"v":208475,"d":"208,475 "},{"v":214373,"d":"214,373 "},{"v":304129,"d":"304,129 "},{"v":306678,"d":"306,678 "},{"v":319745,"d":"319,745 "},{"v":301842,"d":"301,842 "},{"v":326372,"d":"326,372 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":4791,"d":"4,791 "},{"v":4907,"d":"4,907 "},{"v":5054,"d":"5,054 "},{"v":5041,"d":"5,041 "},{"v":5099,"d":"5,099 "},{"v":4659,"d":"4,659 "},{"v":4767,"d":"4,767 "},{"v":4906,"d":"4,906 "},{"v":4851,"d":"4,851 "},{"v":5020,"d":"5,020 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":190374,"d":"190,374 "},{"v":190810,"d":"190,810 "},{"v":220473,"d":"220,473 "},{"v":192631,"d":"192,631 "},{"v":197768,"d":"197,768 "},{"v":283019,"d":"283,019 "},{"v":287543,"d":"287,543 "},{"v":300415,"d":"300,415 "},{"v":283486,"d":"283,486 "},{"v":303953,"d":"303,953 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":11575,"d":"11,575 "},{"v":10299,"d":"10,299 "},{"v":16307,"d":"16,307 "},{"v":10803,"d":"10,803 "},{"v":11506,"d":"11,506 "},{"v":16452,"d":"16,452 "},{"v":14368,"d":"14,368 "},{"v":14424,"d":"14,424 "},{"v":13504,"d":"13,504 "},{"v":17400,"d":"17,400 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1524,"d":"1,524 "},{"v":1568,"d":"1,568 "},{"v":1708,"d":"1,708 "},{"v":1714,"d":"1,714 "},{"v":2069,"d":"2,069 "},{"v":1815,"d":"1,815 "},{"v":1812,"d":"1,812 "},{"v":1791,"d":"1,791 "},{"v":1783,"d":"1,783 "},{"v":1803,"d":"1,803 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":2107,"d":"2,107 "},{"v":1918,"d":"1,918 "},{"v":1353,"d":"1,353 "},{"v":1874,"d":"1,874 "},{"v":2333,"d":"2,333 "},{"v":1229,"d":"1,229 "},{"v":768,"d":"768 "},{"v":2015,"d":"2,015 "},{"v":-35,"d":"(35)"},{"v":1110,"d":"1,110 "}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":12158,"d":"12,158 "},{"v":10649,"d":"10,649 "},{"v":15951,"d":"15,951 "},{"v":10964,"d":"10,964 "},{"v":11769,"d":"11,769 "},{"v":15867,"d":"15,867 "},{"v":13324,"d":"13,324 "},{"v":14647,"d":"14,647 "},{"v":11685,"d":"11,685 "},{"v":16706,"d":"16,706 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":4202,"d":"4,202 "},{"v":3944,"d":"3,944 "},{"v":6158,"d":"6,158 "},{"v":4064,"d":"4,064 "},{"v":4257,"d":"4,257 "},{"v":4970,"d":"4,970 "},{"v":4524,"d":"4,524 "},{"v":4445,"d":"4,445 "},{"v":6573,"d":"6,573 "},{"v":5088,"d":"5,088 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":7956,"d":"7,956 "},{"v":6705,"d":"6,705 "},{"v":9793,"d":"9,793 "},{"v":6900,"d":"6,900 "},{"v":7511,"d":"7,511 "},{"v":10897,"d":"10,897 "},{"v":8800,"d":"8,800 "},{"v":10202,"d":"10,202 "},{"v":5112,"d":"5,112 "},{"v":11618,"d":"11,618 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":1701,"d":"1,701 "},{"v":1466,"d":"1,466 "},{"v":1855,"d":"1,855 "},{"v":7942,"d":"7,942 "},{"v":1861,"d":"1,861 "},{"v":2981,"d":"2,981 "},{"v":2382,"d":"2,382 "},{"v":2775,"d":"2,775 "},{"v":2783,"d":"2,783 "},{"v":3508,"d":"3,508 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":6255,"d":"6,255 "},{"v":5239,"d":"5,239 "},{"v":7938,"d":"7,938 "},{"v":-1042,"d":"(1,042)"},{"v":5650,"d":"5,650 "},{"v":7916,"d":"7,916 "},{"v":6418,"d":"6,418 "},{"v":7427,"d":"7,427 "},{"v":2329,"d":"2,329 "},{"v":8110,"d":"8,110 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":161025,"d":"161,025 "},{"v":164029,"d":"164,029 "},{"v":166099,"d":"166,099 "},{"v":171210,"d":"171,210 "},{"v":156636,"d":"156,636 "},{"v":168989,"d":"168,989 "},{"v":175682,"d":"175,682 "},{"v":181778,"d":"181,778 "},{"v":187125,"d":"187,125 "},{"v":186605,"d":"186,605 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-3289,"d":"(3,289)"},{"v":-3383,"d":"(3,383)"},{"v":-2555,"d":"(2,555)"},{"v":-13664,"d":"(13,664)"},{"v":-1478,"d":"(1,478)"},{"v":-1742,"d":"(1,742)"},{"v":-1178,"d":"(1,178)"},{"v":-1359,"d":"(1,359)"},{"v":-1928,"d":"(1,928)"},{"v":-1821,"d":"(1,821)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":163992,"d":"163,992 "},{"v":165886,"d":"165,886 "},{"v":171481,"d":"171,481 "},{"v":156503,"d":"156,503 "},{"v":160807,"d":"160,807 "},{"v":175162,"d":"175,162 "},{"v":180922,"d":"180,922 "},{"v":187846,"d":"187,846 "},{"v":187526,"d":"187,526 "},{"v":192894,"d":"192,894 "}]
["                         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.32,2.38,2.09,2.42,2.38,1.53,1.55,1.53,1.61,1.54]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",92.08,92.62,91.17,{"v":92.4,"d":"92.40"},92.25,93.06,93.76,93.95,93.92,93.13]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5.6,"d":"5.60"},{"v":5,"d":"5.00"},6.74,5.18,5.37,5.41,4.69,4.51,4.47,5.33]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.74,0.76,0.71,0.82,0.97,{"v":0.6,"d":"0.60"},0.59,0.56,0.59,0.55]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",1.02,0.93,0.56,{"v":0.9,"d":"0.90"},1.09,{"v":0.4,"d":"0.40"},0.25,0.63,{"v":-0.01,"d":"(0.01)"},0.34]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",5.88,5.17,{"v":6.6,"d":"6.60"},5.26,5.49,5.22,4.34,4.58,3.87,5.12]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",2.03,1.91,2.55,1.95,1.99,1.63,1.48,1.39,2.18,1.56]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",3.85,3.25,4.05,3.31,{"v":3.5,"d":"3.50"},3.58,2.87,3.19,1.69,3.56]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",26.43,22.96,32.49,22.84,24.01,26.22,21.76,{"v":23.9,"d":"23.90"},18.92,26.75]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",17.29,14.46,19.95,14.37,15.32,18.01,14.37,16.65,8.28,{"v":18.6,"d":"18.60"}]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",10.63,8.88,13.41,9.19,9.83,10.72,8.75,9.49,7.56,10.66]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",6.95,5.59,8.23,5.78,6.27,7.36,5.78,6.61,3.31,7.41]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1.2,"d":"1.20"},1.21,1.27,1.24,1.27,1.33,1.34,1.33,1.29,1.28]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.19,0.15,{"v":0.2,"d":"0.20"},0.18,0.19,0.23,0.24,0.25,0.23,0.23]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1.5,"d":"1.50"},1.38,1.54,{"v":1.5,"d":"1.50"},1.54,1.53,{"v":1.5,"d":"1.50"},1.46,1.48,1.48]
["  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-2014Q2","index":3,"n_rows":61,"n_cols":11,"rows_kept":61,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[49,1,49,4],[49,6,49,9],[60,0,60,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 5.1 -- Balance Sheet  For Corporations in NAICS Retail Trade Subsectors 448 and 452, and\n                               All Other Retail Trade Subsectors, Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"Clothing and General Merchandise Stores\nTotal Assets $50 Million and Over",{"$nulls":4},"All Other Retail Trade\nTotal Assets $50 Million and Over"]
["Item"," 2Q_\n 2013_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 2Q_\n 2014_"," 2Q_\n 2013_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 2Q_\n 2014_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":19227,"d":"19,227 "},{"v":16907,"d":"16,907 "},{"v":19216,"d":"19,216 "},{"v":18365,"d":"18,365 "},{"v":19418,"d":"19,418 "},{"v":27302,"d":"27,302 "},{"v":29515,"d":"29,515 "},{"v":28905,"d":"28,905 "},{"v":27942,"d":"27,942 "},{"v":29563,"d":"29,563 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":335,"d":"335 "},{"v":338,"d":"338 "},{"v":471,"d":"471 "},{"v":433,"d":"433 "},{"v":534,"d":"534 "},{"v":1375,"d":"1,375 "},{"v":1448,"d":"1,448 "},{"v":1365,"d":"1,365 "},{"v":1319,"d":"1,319 "},{"v":1780,"d":"1,780 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":19562,"d":"19,562 "},{"v":17244,"d":"17,244 "},{"v":19686,"d":"19,686 "},{"v":18799,"d":"18,799 "},{"v":19952,"d":"19,952 "},{"v":28677,"d":"28,677 "},{"v":30963,"d":"30,963 "},{"v":30271,"d":"30,271 "},{"v":29261,"d":"29,261 "},{"v":31343,"d":"31,343 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4599,"d":"4,599 "},{"v":3878,"d":"3,878 "},{"v":6136,"d":"6,136 "},{"v":4639,"d":"4,639 "},{"v":4368,"d":"4,368 "},{"v":9882,"d":"9,882 "},{"v":10517,"d":"10,517 "},{"v":13817,"d":"13,817 "},{"v":11718,"d":"11,718 "},{"v":11210,"d":"11,210 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":24161,"d":"24,161 "},{"v":21122,"d":"21,122 "},{"v":25823,"d":"25,823 "},{"v":23438,"d":"23,438 "},{"v":24320,"d":"24,320 "},{"v":38558,"d":"38,558 "},{"v":41480,"d":"41,480 "},{"v":44088,"d":"44,088 "},{"v":40979,"d":"40,979 "},{"v":42553,"d":"42,553 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":7616,"d":"7,616 "},{"v":7894,"d":"7,894 "},{"v":8486,"d":"8,486 "},{"v":8069,"d":"8,069 "},{"v":7986,"d":"7,986 "},{"v":42475,"d":"42,475 "},{"v":44625,"d":"44,625 "},{"v":45765,"d":"45,765 "},{"v":44455,"d":"44,455 "},{"v":47134,"d":"47,134 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":107997,"d":"107,997 "},{"v":126858,"d":"126,858 "},{"v":111102,"d":"111,102 "},{"v":112470,"d":"112,470 "},{"v":112492,"d":"112,492 "},{"v":118755,"d":"118,755 "},{"v":123690,"d":"123,690 "},{"v":121762,"d":"121,762 "},{"v":122498,"d":"122,498 "},{"v":122925,"d":"122,925 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":16159,"d":"16,159 "},{"v":16997,"d":"16,997 "},{"v":16402,"d":"16,402 "},{"v":16697,"d":"16,697 "},{"v":16918,"d":"16,918 "},{"v":19276,"d":"19,276 "},{"v":20698,"d":"20,698 "},{"v":21697,"d":"21,697 "},{"v":20669,"d":"20,669 "},{"v":20858,"d":"20,858 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":155933,"d":"155,933 "},{"v":172871,"d":"172,871 "},{"v":161813,"d":"161,813 "},{"v":160675,"d":"160,675 "},{"v":161715,"d":"161,715 "},{"v":219064,"d":"219,064 "},{"v":230493,"d":"230,493 "},{"v":233311,"d":"233,311 "},{"v":228601,"d":"228,601 "},{"v":233471,"d":"233,471 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":293104,"d":"293,104 "},{"v":297326,"d":"297,326 "},{"v":303477,"d":"303,477 "},{"v":306385,"d":"306,385 "},{"v":310974,"d":"310,974 "},{"v":250121,"d":"250,121 "},{"v":256922,"d":"256,922 "},{"v":267300,"d":"267,300 "},{"v":271829,"d":"271,829 "},{"v":276783,"d":"276,783 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":32385,"d":"32,385 "},{"v":32669,"d":"32,669 "},{"v":33278,"d":"33,278 "},{"v":33444,"d":"33,444 "},{"v":33694,"d":"33,694 "},{"v":36038,"d":"36,038 "},{"v":36174,"d":"36,174 "},{"v":29776,"d":"29,776 "},{"v":29456,"d":"29,456 "},{"v":29325,"d":"29,325 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":136397,"d":"136,397 "},{"v":138993,"d":"138,993 "},{"v":140613,"d":"140,613 "},{"v":143711,"d":"143,711 "},{"v":147701,"d":"147,701 "},{"v":130141,"d":"130,141 "},{"v":133830,"d":"133,830 "},{"v":135787,"d":"135,787 "},{"v":139127,"d":"139,127 "},{"v":142236,"d":"142,236 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":189092,"d":"189,092 "},{"v":191001,"d":"191,001 "},{"v":196143,"d":"196,143 "},{"v":196118,"d":"196,118 "},{"v":196966,"d":"196,966 "},{"v":156018,"d":"156,018 "},{"v":159267,"d":"159,267 "},{"v":161288,"d":"161,288 "},{"v":162158,"d":"162,158 "},{"v":163872,"d":"163,872 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":112613,"d":"112,613 "},{"v":116011,"d":"116,011 "},{"v":117941,"d":"117,941 "},{"v":120597,"d":"120,597 "},{"v":120383,"d":"120,383 "},{"v":217199,"d":"217,199 "},{"v":219287,"d":"219,287 "},{"v":222751,"d":"222,751 "},{"v":227701,"d":"227,701 "},{"v":229405,"d":"229,405 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":457638,"d":"457,638 "},{"v":479883,"d":"479,883 "},{"v":475898,"d":"475,898 "},{"v":477390,"d":"477,390 "},{"v":479065,"d":"479,065 "},{"v":592280,"d":"592,280 "},{"v":609047,"d":"609,047 "},{"v":617351,"d":"617,351 "},{"v":618460,"d":"618,460 "},{"v":626749,"d":"626,749 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1051,"d":"1,051 "},{"v":1129,"d":"1,129 "},{"v":1092,"d":"1,092 "},{"v":1611,"d":"1,611 "},{"v":1740,"d":"1,740 "},{"v":13702,"d":"13,702 "},{"v":13153,"d":"13,153 "},{"v":14071,"d":"14,071 "},{"v":13570,"d":"13,570 "},{"v":13427,"d":"13,427 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":11250,"d":"11,250 "},{"v":15637,"d":"15,637 "},{"v":9282,"d":"9,282 "},{"v":5498,"d":"5,498 "},{"v":4601,"d":"4,601 "},{"v":4843,"d":"4,843 "},{"v":4223,"d":"4,223 "},{"v":4347,"d":"4,347 "},{"v":3890,"d":"3,890 "},{"v":4459,"d":"4,459 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":62083,"d":"62,083 "},{"v":71949,"d":"71,949 "},{"v":60987,"d":"60,987 "},{"v":64031,"d":"64,031 "},{"v":64440,"d":"64,440 "},{"v":81645,"d":"81,645 "},{"v":87908,"d":"87,908 "},{"v":87147,"d":"87,147 "},{"v":89315,"d":"89,315 "},{"v":91840,"d":"91,840 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":1018,"d":"1,018 "},{"v":371,"d":"371 "},{"v":2427,"d":"2,427 "},{"v":3302,"d":"3,302 "},{"v":1311,"d":"1,311 "},{"v":2323,"d":"2,323 "},{"v":2284,"d":"2,284 "},{"v":2735,"d":"2,735 "},{"v":5527,"d":"5,527 "},{"v":5463,"d":"5,463 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":234,"d":"234 "},{"v":447,"d":"447 "},{"v":408,"d":"408 "},{"v":448,"d":"448 "},{"v":613,"d":"613 "},{"v":3964,"d":"3,964 "},{"v":4537,"d":"4,537 "},{"v":4376,"d":"4,376 "},{"v":4404,"d":"4,404 "},{"v":4840,"d":"4,840 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":6798,"d":"6,798 "},{"v":6969,"d":"6,969 "},{"v":6159,"d":"6,159 "},{"v":5351,"d":"5,351 "},{"v":5846,"d":"5,846 "},{"v":6234,"d":"6,234 "},{"v":5110,"d":"5,110 "},{"v":4391,"d":"4,391 "},{"v":5442,"d":"5,442 "},{"v":6829,"d":"6,829 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":47568,"d":"47,568 "},{"v":46776,"d":"46,776 "},{"v":47314,"d":"47,314 "},{"v":49197,"d":"49,197 "},{"v":49244,"d":"49,244 "},{"v":52448,"d":"52,448 "},{"v":55142,"d":"55,142 "},{"v":58309,"d":"58,309 "},{"v":55458,"d":"55,458 "},{"v":56040,"d":"56,040 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":130002,"d":"130,002 "},{"v":143278,"d":"143,278 "},{"v":127670,"d":"127,670 "},{"v":129438,"d":"129,438 "},{"v":127796,"d":"127,796 "},{"v":165159,"d":"165,159 "},{"v":172357,"d":"172,357 "},{"v":175376,"d":"175,376 "},{"v":177606,"d":"177,606 "},{"v":182899,"d":"182,899 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":11461,"d":"11,461 "},{"v":12684,"d":"12,684 "},{"v":11924,"d":"11,924 "},{"v":12705,"d":"12,705 "},{"v":12526,"d":"12,526 "},{"v":41363,"d":"41,363 "},{"v":42441,"d":"42,441 "},{"v":46253,"d":"46,253 "},{"v":47149,"d":"47,149 "},{"v":45862,"d":"45,862 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":91503,"d":"91,503 "},{"v":97235,"d":"97,235 "},{"v":98794,"d":"98,794 "},{"v":102492,"d":"102,492 "},{"v":101821,"d":"101,821 "},{"v":88541,"d":"88,541 "},{"v":94181,"d":"94,181 "},{"v":94027,"d":"94,027 "},{"v":92778,"d":"92,778 "},{"v":93531,"d":"93,531 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":40639,"d":"40,639 "},{"v":41183,"d":"41,183 "},{"v":41138,"d":"41,138 "},{"v":40746,"d":"40,746 "},{"v":40824,"d":"40,824 "},{"v":55179,"d":"55,179 "},{"v":55118,"d":"55,118 "},{"v":56526,"d":"56,526 "},{"v":53848,"d":"53,848 "},{"v":54664,"d":"54,664 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":273605,"d":"273,605 "},{"v":294380,"d":"294,380 "},{"v":279526,"d":"279,526 "},{"v":285380,"d":"285,380 "},{"v":282967,"d":"282,967 "},{"v":350242,"d":"350,242 "},{"v":364097,"d":"364,097 "},{"v":372182,"d":"372,182 "},{"v":371381,"d":"371,381 "},{"v":376956,"d":"376,956 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":20041,"d":"20,041 "},{"v":19617,"d":"19,617 "},{"v":24891,"d":"24,891 "},{"v":35506,"d":"35,506 "},{"v":35290,"d":"35,290 "},{"v":66877,"d":"66,877 "},{"v":64029,"d":"64,029 "},{"v":57323,"d":"57,323 "},{"v":59552,"d":"59,552 "},{"v":56898,"d":"56,898 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":163992,"d":"163,992 "},{"v":165886,"d":"165,886 "},{"v":171481,"d":"171,481 "},{"v":156503,"d":"156,503 "},{"v":160807,"d":"160,807 "},{"v":175162,"d":"175,162 "},{"v":180922,"d":"180,922 "},{"v":187846,"d":"187,846 "},{"v":187526,"d":"187,526 "},{"v":192894,"d":"192,894 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":184033,"d":"184,033 "},{"v":185503,"d":"185,503 "},{"v":196372,"d":"196,372 "},{"v":192010,"d":"192,010 "},{"v":196098,"d":"196,098 "},{"v":242039,"d":"242,039 "},{"v":244951,"d":"244,951 "},{"v":245169,"d":"245,169 "},{"v":247078,"d":"247,078 "},{"v":249792,"d":"249,792 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":457638,"d":"457,638 "},{"v":479883,"d":"479,883 "},{"v":475898,"d":"475,898 "},{"v":477390,"d":"477,390 "},{"v":479065,"d":"479,065 "},{"v":592280,"d":"592,280 "},{"v":609047,"d":"609,047 "},{"v":617351,"d":"617,351 "},{"v":618460,"d":"618,460 "},{"v":626749,"d":"626,749 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":25932,"d":"25,932 "},{"v":29594,"d":"29,594 "},{"v":34144,"d":"34,144 "},{"v":31237,"d":"31,237 "},{"v":33920,"d":"33,920 "},{"v":53905,"d":"53,905 "},{"v":58136,"d":"58,136 "},{"v":57935,"d":"57,935 "},{"v":50995,"d":"50,995 "},{"v":50572,"d":"50,572 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",5.28,{"v":4.4,"d":"4.40"},5.43,4.91,5.08,6.51,6.81,7.14,6.63,6.79]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",1.66,1.65,1.78,1.69,1.67,7.17,7.33,7.41,7.19,7.52]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":23.6,"d":"23.60"},26.44,23.35,23.56,23.48,20.05,20.31,19.72,19.81,19.61]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",34.07,36.02,{"v":34,"d":"34.00"},33.66,33.76,36.99,37.84,37.79,36.96,37.25]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",41.32,{"v":39.8,"d":"39.80"},41.22,41.08,41.11,26.34,26.15,26.13,26.22,26.15]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",4.22,5.04,3.56,{"v":2.7,"d":"2.70"},2.67,4.85,4.44,{"v":4.4,"d":"4.40"},4.42,4.72]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",28.41,29.86,26.83,27.11,26.68,27.89,{"v":28.3,"d":"28.30"},28.41,28.72,29.18]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":22.5,"d":"22.50"},22.91,23.27,24.13,23.87,21.93,22.43,22.72,22.63,22.24]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",59.79,61.34,58.74,59.78,59.07,59.13,59.78,60.29,60.05,60.14]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",40.21,38.66,41.26,40.22,40.93,40.87,40.22,39.71,39.95,39.86]
["  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-2014Q2","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":367080,"d":"367,080 "},{"v":369881,"d":"369,881 "},{"v":391326,"d":"391,326 "},{"v":398885,"d":"398,885 "}]
["2004 …………………………………………………………………………………………...………………………………………………..",{"v":407107,"d":"407,107 "},{"v":410447,"d":"410,447 "},{"v":421517,"d":"421,517 "},{"v":427491,"d":"427,491 "}]
["2005 …………………………………………………………………………………………...………………………………………………..",{"v":438337,"d":"438,337 "},{"v":447448,"d":"447,448 "},{"v":458344,"d":"458,344 "},{"v":468049,"d":"468,049 "}]
["2006 …………………………………………………………………………………………...………………………………………………..",{"v":480464,"d":"480,464 "},{"v":492758,"d":"492,758 "},{"v":497463,"d":"497,463 "},{"v":502166,"d":"502,166 "}]
["2007 …………………………………………………………………………………………...………………………………………………..",{"v":509980,"d":"509,980 "},{"v":514602,"d":"514,602 "},{"v":515873,"d":"515,873 "},{"v":521287,"d":"521,287 "}]
["2008 …………………………………………………………………………………………...………………………………………………..",{"v":523424,"d":"523,424 "},{"v":536117,"d":"536,117 "},{"v":531379,"d":"531,379 "},{"v":501254,"d":"501,254 "}]
["2009 …………………………………………………………………………………………...………………………………………………..",{"v":495884,"d":"495,884 "},{"v":494958,"d":"494,958 "},{"v":508512,"d":"508,512 "},{"v":520144,"d":"520,144 "}]
["2010 …………………………………………………………………………………………...………………………………………………..",{"v":532219,"d":"532,219 "},{"v":534447,"d":"534,447 "},{"v":539686,"d":"539,686 "},{"v":551075,"d":"551,075 "}]
["2011 …………………………………………………………………………………………...………………………………………………..",{"v":567233,"d":"567,233 "},{"v":584862,"d":"584,862 "},{"v":586155,"d":"586,155 "},{"v":586949,"d":"586,949 "}]
["2012 …………………………………………………………………………………………...………………………………………………..",{"v":602974,"d":"602,974 "},{"v":597691,"d":"597,691 "},{"v":603270,"d":"603,270 "},{"v":612329,"d":"612,329 "}]
["2013 …………………………………………………………………………………………...………………………………………………..",{"v":617886,"d":"617,886 "},{"v":626569,"d":"626,569 "},{"v":636378,"d":"636,378 "},{"v":642797,"d":"642,797 "}]
["2014 …………………………………………………………………………………………...………………………………………………..",{"v":638404,"d":"638,404 "},{"v":659509,"d":"659,509 "}]
[]
["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."]