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

{"sheet":"RET_4_0-2014Q3","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"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 2Q_\n 2014_"," 3Q_\n 2014_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 2Q_\n 2014_"," 3Q_\n 2014_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":622577,"d":"622,577 "},{"v":674374,"d":"674,374 "},{"v":623881,"d":"623,881 "},{"v":657218,"d":"657,218 "},{"v":654407,"d":"654,407 "},{"v":109871,"d":"109,871 "},{"v":112895,"d":"112,895 "},{"v":113582,"d":"113,582 "},{"v":115977,"d":"115,977 "},{"v":115857,"d":"115,857 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":11869,"d":"11,869 "},{"v":12286,"d":"12,286 "},{"v":12217,"d":"12,217 "},{"v":12542,"d":"12,542 "},{"v":12906,"d":"12,906 "},{"v":2190,"d":"2,190 "},{"v":2321,"d":"2,321 "},{"v":2325,"d":"2,325 "},{"v":2388,"d":"2,388 "},{"v":2406,"d":"2,406 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":582983,"d":"582,983 "},{"v":627952,"d":"627,952 "},{"v":583838,"d":"583,838 "},{"v":612734,"d":"612,734 "},{"v":612534,"d":"612,534 "},{"v":104628,"d":"104,628 "},{"v":107117,"d":"107,117 "},{"v":107672,"d":"107,672 "},{"v":110206,"d":"110,206 "},{"v":110450,"d":"110,450 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":27725,"d":"27,725 "},{"v":34136,"d":"34,136 "},{"v":27825,"d":"27,825 "},{"v":31943,"d":"31,943 "},{"v":28967,"d":"28,967 "},{"v":3053,"d":"3,053 "},{"v":3457,"d":"3,457 "},{"v":3584,"d":"3,584 "},{"v":3383,"d":"3,383 "},{"v":3001,"d":"3,001 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4068,"d":"4,068 "},{"v":4203,"d":"4,203 "},{"v":4187,"d":"4,187 "},{"v":4582,"d":"4,582 "},{"v":4342,"d":"4,342 "},{"v":673,"d":"673 "},{"v":689,"d":"689 "},{"v":677,"d":"677 "},{"v":678,"d":"678 "},{"v":670,"d":"670 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":2791,"d":"2,791 "},{"v":6696,"d":"6,696 "},{"v":1903,"d":"1,903 "},{"v":3535,"d":"3,535 "},{"v":1666,"d":"1,666 "},{"v":107,"d":"107 "},{"v":3327,"d":"3,327 "},{"v":45,"d":"45 "},{"v":198,"d":"198 "},{"v":65,"d":"65 "}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":26448,"d":"26,448 "},{"v":36629,"d":"36,629 "},{"v":25541,"d":"25,541 "},{"v":30895,"d":"30,895 "},{"v":26292,"d":"26,292 "},{"v":2486,"d":"2,486 "},{"v":6096,"d":"6,096 "},{"v":2952,"d":"2,952 "},{"v":2904,"d":"2,904 "},{"v":2397,"d":"2,397 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":8992,"d":"8,992 "},{"v":11121,"d":"11,121 "},{"v":11710,"d":"11,710 "},{"v":10226,"d":"10,226 "},{"v":9022,"d":"9,022 "},{"v":527,"d":"527 "},{"v":547,"d":"547 "},{"v":1072,"d":"1,072 "},{"v":979,"d":"979 "},{"v":1050,"d":"1,050 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":17457,"d":"17,457 "},{"v":25509,"d":"25,509 "},{"v":13831,"d":"13,831 "},{"v":20670,"d":"20,670 "},{"v":17269,"d":"17,269 "},{"v":1959,"d":"1,959 "},{"v":5548,"d":"5,548 "},{"v":1881,"d":"1,881 "},{"v":1924,"d":"1,924 "},{"v":1347,"d":"1,347 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":4469,"d":"4,469 "},{"v":5552,"d":"5,552 "},{"v":11419,"d":"11,419 "},{"v":5863,"d":"5,863 "},{"v":5405,"d":"5,405 "},{"v":625,"d":"625 "},{"v":954,"d":"954 "},{"v":690,"d":"690 "},{"v":759,"d":"759 "},{"v":644,"d":"644 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":12988,"d":"12,988 "},{"v":19957,"d":"19,957 "},{"v":2412,"d":"2,412 "},{"v":14806,"d":"14,806 "},{"v":11865,"d":"11,865 "},{"v":1334,"d":"1,334 "},{"v":4595,"d":"4,595 "},{"v":1191,"d":"1,191 "},{"v":1165,"d":"1,165 "},{"v":703,"d":"703 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":377748,"d":"377,748 "},{"v":385938,"d":"385,938 "},{"v":395713,"d":"395,713 "},{"v":382117,"d":"382,117 "},{"v":394540,"d":"394,540 "},{"v":40481,"d":"40,481 "},{"v":40534,"d":"40,534 "},{"v":39833,"d":"39,833 "},{"v":41305,"d":"41,305 "},{"v":42212,"d":"42,212 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-4604,"d":"(4,604)"},{"v":-10664,"d":"(10,664)"},{"v":-15514,"d":"(15,514)"},{"v":-3422,"d":"(3,422)"},{"v":-2941,"d":"(2,941)"},{"v":-44,"d":"(44)"},{"v":-6757,"d":"(6,757)"},{"v":62,"d":"62 "},{"v":-351,"d":"(351)"},{"v":-70,"d":"(70)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":386131,"d":"386,131 "},{"v":395231,"d":"395,231 "},{"v":382611,"d":"382,611 "},{"v":393502,"d":"393,502 "},{"v":403464,"d":"403,464 "},{"v":41771,"d":"41,771 "},{"v":38372,"d":"38,372 "},{"v":41086,"d":"41,086 "},{"v":42120,"d":"42,120 "},{"v":42845,"d":"42,845 "}]
["                         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.91,1.82,1.96,1.91,1.97,1.99,2.06,2.05,2.06,2.08]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",93.64,93.12,93.58,93.23,{"v":93.6,"d":"93.60"},95.23,94.88,{"v":94.8,"d":"94.80"},95.02,95.33]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",4.45,5.06,4.46,4.86,4.43,2.78,3.06,3.16,2.92,2.59]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.65,0.62,0.67,{"v":0.7,"d":"0.70"},0.66,0.61,0.61,{"v":0.6,"d":"0.60"},0.58,0.58]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",0.45,0.99,0.31,0.54,0.25,{"v":0.1,"d":"0.10"},2.95,0.04,0.17,0.06]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",4.25,5.43,4.09,{"v":4.7,"d":"4.70"},4.02,2.26,{"v":5.4,"d":"5.40"},{"v":2.6,"d":"2.60"},{"v":2.5,"d":"2.50"},2.07]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.44,1.65,1.88,1.56,1.38,0.48,0.48,0.94,0.84,0.91]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":2.8,"d":"2.80"},3.78,2.22,3.15,2.64,1.78,4.91,1.66,1.66,1.16]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",21.99,29.55,20.74,24.64,{"v":21.3,"d":"21.30"},18.84,43.32,21.24,{"v":20.7,"d":"20.70"},16.91]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",14.52,20.58,11.23,16.48,13.99,14.84,39.43,13.53,13.72,{"v":9.5,"d":"9.50"}]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",8.54,{"v":11.7,"d":"11.70"},8.16,9.76,8.16,6.71,15.42,7.64,7.56,6.19]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",5.64,8.15,4.42,6.53,5.36,5.28,14.04,4.87,5.01,3.48]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.26,1.29,1.26,1.26,1.24,1.16,1.25,1.25,1.25,1.22]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.21,0.25,0.23,0.23,{"v":0.2,"d":"0.20"},0.33,0.41,0.39,0.38,0.35]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.43,1.47,1.46,1.48,1.42,1.37,1.37,1.35,{"v":1.4,"d":"1.40"},1.42]
["  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-2014Q3","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"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 2Q_\n 2014_"," 3Q_\n 2014_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 2Q_\n 2014_"," 3Q_\n 2014_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":57284,"d":"57,284 "},{"v":59714,"d":"59,714 "},{"v":58305,"d":"58,305 "},{"v":59757,"d":"59,757 "},{"v":57914,"d":"57,914 "},{"v":10875,"d":"10,875 "},{"v":11639,"d":"11,639 "},{"v":12123,"d":"12,123 "},{"v":11490,"d":"11,490 "},{"v":11513,"d":"11,513 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":2153,"d":"2,153 "},{"v":5780,"d":"5,780 "},{"v":3543,"d":"3,543 "},{"v":4082,"d":"4,082 "},{"v":2901,"d":"2,901 "},{"v":367,"d":"367 "},{"v":3943,"d":"3,943 "},{"v":1774,"d":"1,774 "},{"v":2011,"d":"2,011 "},{"v":1110,"d":"1,110 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":59437,"d":"59,437 "},{"v":65493,"d":"65,493 "},{"v":61848,"d":"61,848 "},{"v":63840,"d":"63,840 "},{"v":60815,"d":"60,815 "},{"v":11243,"d":"11,243 "},{"v":15582,"d":"15,582 "},{"v":13897,"d":"13,897 "},{"v":13501,"d":"13,501 "},{"v":12623,"d":"12,623 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":16849,"d":"16,849 "},{"v":22322,"d":"22,322 "},{"v":18899,"d":"18,899 "},{"v":17595,"d":"17,595 "},{"v":16314,"d":"16,314 "},{"v":2455,"d":"2,455 "},{"v":2368,"d":"2,368 "},{"v":2542,"d":"2,542 "},{"v":1960,"d":"1,960 "},{"v":2073,"d":"2,073 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":76287,"d":"76,287 "},{"v":87815,"d":"87,815 "},{"v":80747,"d":"80,747 "},{"v":81434,"d":"81,434 "},{"v":77130,"d":"77,130 "},{"v":13697,"d":"13,697 "},{"v":17951,"d":"17,951 "},{"v":16439,"d":"16,439 "},{"v":15460,"d":"15,460 "},{"v":14697,"d":"14,697 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":58290,"d":"58,290 "},{"v":60763,"d":"60,763 "},{"v":58538,"d":"58,538 "},{"v":60964,"d":"60,964 "},{"v":63537,"d":"63,537 "},{"v":5785,"d":"5,785 "},{"v":6525,"d":"6,525 "},{"v":6016,"d":"6,016 "},{"v":5728,"d":"5,728 "},{"v":5731,"d":"5,731 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":275072,"d":"275,072 "},{"v":258303,"d":"258,303 "},{"v":260248,"d":"260,248 "},{"v":262566,"d":"262,566 "},{"v":286588,"d":"286,588 "},{"v":24571,"d":"24,571 "},{"v":25416,"d":"25,416 "},{"v":25059,"d":"25,059 "},{"v":24818,"d":"24,818 "},{"v":25897,"d":"25,897 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":42486,"d":"42,486 "},{"v":43246,"d":"43,246 "},{"v":42216,"d":"42,216 "},{"v":42496,"d":"42,496 "},{"v":43572,"d":"43,572 "},{"v":4577,"d":"4,577 "},{"v":5112,"d":"5,112 "},{"v":4798,"d":"4,798 "},{"v":4380,"d":"4,380 "},{"v":4549,"d":"4,549 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":452135,"d":"452,135 "},{"v":450127,"d":"450,127 "},{"v":441749,"d":"441,749 "},{"v":447460,"d":"447,460 "},{"v":470827,"d":"470,827 "},{"v":48630,"d":"48,630 "},{"v":55004,"d":"55,004 "},{"v":52312,"d":"52,312 "},{"v":50386,"d":"50,386 "},{"v":50874,"d":"50,874 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":693621,"d":"693,621 "},{"v":711289,"d":"711,289 "},{"v":717698,"d":"717,698 "},{"v":728548,"d":"728,548 "},{"v":742492,"d":"742,492 "},{"v":139460,"d":"139,460 "},{"v":140623,"d":"140,623 "},{"v":139649,"d":"139,649 "},{"v":140821,"d":"140,821 "},{"v":143276,"d":"143,276 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":79578,"d":"79,578 "},{"v":74016,"d":"74,016 "},{"v":74002,"d":"74,002 "},{"v":74250,"d":"74,250 "},{"v":75056,"d":"75,056 "},{"v":10729,"d":"10,729 "},{"v":10956,"d":"10,956 "},{"v":11097,"d":"11,097 "},{"v":11214,"d":"11,214 "},{"v":11395,"d":"11,395 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":347369,"d":"347,369 "},{"v":350993,"d":"350,993 "},{"v":357515,"d":"357,515 "},{"v":364361,"d":"364,361 "},{"v":373546,"d":"373,546 "},{"v":74666,"d":"74,666 "},{"v":74719,"d":"74,719 "},{"v":74862,"d":"74,862 "},{"v":75023,"d":"75,023 "},{"v":76527,"d":"76,527 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":425830,"d":"425,830 "},{"v":434312,"d":"434,312 "},{"v":434185,"d":"434,185 "},{"v":438437,"d":"438,437 "},{"v":444002,"d":"444,002 "},{"v":75523,"d":"75,523 "},{"v":76860,"d":"76,860 "},{"v":75884,"d":"75,884 "},{"v":77012,"d":"77,012 "},{"v":78144,"d":"78,144 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":360282,"d":"360,282 "},{"v":367845,"d":"367,845 "},{"v":375692,"d":"375,692 "},{"v":380934,"d":"380,934 "},{"v":373691,"d":"373,691 "},{"v":24163,"d":"24,163 "},{"v":26265,"d":"26,265 "},{"v":26331,"d":"26,331 "},{"v":26134,"d":"26,134 "},{"v":25938,"d":"25,938 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1238247,"d":"1,238,247 "},{"v":1252283,"d":"1,252,283 "},{"v":1251626,"d":"1,251,626 "},{"v":1266831,"d":"1,266,831 "},{"v":1288519,"d":"1,288,519 "},{"v":148316,"d":"148,316 "},{"v":158129,"d":"158,129 "},{"v":154527,"d":"154,527 "},{"v":153531,"d":"153,531 "},{"v":154957,"d":"154,957 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":14640,"d":"14,640 "},{"v":15507,"d":"15,507 "},{"v":15713,"d":"15,713 "},{"v":15878,"d":"15,878 "},{"v":16219,"d":"16,219 "},{"v":353,"d":"353 "},{"v":341,"d":"341 "},{"v":414,"d":"414 "},{"v":409,"d":"409 "},{"v":399,"d":"399 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":20410,"d":"20,410 "},{"v":14044,"d":"14,044 "},{"v":9779,"d":"9,779 "},{"v":9509,"d":"9,509 "},{"v":12883,"d":"12,883 "},{"v":550,"d":"550 "},{"v":417,"d":"417 "},{"v":395,"d":"395 "},{"v":366,"d":"366 "},{"v":467,"d":"467 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":181091,"d":"181,091 "},{"v":170994,"d":"170,994 "},{"v":175143,"d":"175,143 "},{"v":178191,"d":"178,191 "},{"v":193553,"d":"193,553 "},{"v":21095,"d":"21,095 "},{"v":22791,"d":"22,791 "},{"v":21607,"d":"21,607 "},{"v":21119,"d":"21,119 "},{"v":21725,"d":"21,725 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":3331,"d":"3,331 "},{"v":6908,"d":"6,908 "},{"v":9931,"d":"9,931 "},{"v":7455,"d":"7,455 "},{"v":6839,"d":"6,839 "},{"v":676,"d":"676 "},{"v":1780,"d":"1,780 "},{"v":1123,"d":"1,123 "},{"v":623,"d":"623 "},{"v":529,"d":"529 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5785,"d":"5,785 "},{"v":5644,"d":"5,644 "},{"v":5743,"d":"5,743 "},{"v":6333,"d":"6,333 "},{"v":6890,"d":"6,890 "},{"v":801,"d":"801 "},{"v":861,"d":"861 "},{"v":891,"d":"891 "},{"v":853,"d":"853 "},{"v":951,"d":"951 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":14817,"d":"14,817 "},{"v":13177,"d":"13,177 "},{"v":13904,"d":"13,904 "},{"v":14849,"d":"14,849 "},{"v":15593,"d":"15,593 "},{"v":2992,"d":"2,992 "},{"v":2879,"d":"2,879 "},{"v":3352,"d":"3,352 "},{"v":2319,"d":"2,319 "},{"v":2281,"d":"2,281 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":119361,"d":"119,361 "},{"v":122692,"d":"122,692 "},{"v":120819,"d":"120,819 "},{"v":122416,"d":"122,416 "},{"v":127271,"d":"127,271 "},{"v":15278,"d":"15,278 "},{"v":15005,"d":"15,005 "},{"v":14183,"d":"14,183 "},{"v":14636,"d":"14,636 "},{"v":15278,"d":"15,278 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":359434,"d":"359,434 "},{"v":348965,"d":"348,965 "},{"v":351033,"d":"351,033 "},{"v":354630,"d":"354,630 "},{"v":379247,"d":"379,247 "},{"v":41744,"d":"41,744 "},{"v":44073,"d":"44,073 "},{"v":41965,"d":"41,965 "},{"v":40325,"d":"40,325 "},{"v":41630,"d":"41,630 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":63533,"d":"63,533 "},{"v":66546,"d":"66,546 "},{"v":68102,"d":"68,102 "},{"v":67269,"d":"67,269 "},{"v":69044,"d":"69,044 "},{"v":7906,"d":"7,906 "},{"v":7865,"d":"7,865 "},{"v":7703,"d":"7,703 "},{"v":7448,"d":"7,448 "},{"v":7772,"d":"7,772 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":217865,"d":"217,865 "},{"v":222144,"d":"222,144 "},{"v":224232,"d":"224,232 "},{"v":225918,"d":"225,918 "},{"v":227655,"d":"227,655 "},{"v":25936,"d":"25,936 "},{"v":28848,"d":"28,848 "},{"v":28453,"d":"28,453 "},{"v":28647,"d":"28,647 "},{"v":27964,"d":"27,964 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":116367,"d":"116,367 "},{"v":118851,"d":"118,851 "},{"v":115689,"d":"115,689 "},{"v":117433,"d":"117,433 "},{"v":118909,"d":"118,909 "},{"v":19938,"d":"19,938 "},{"v":21061,"d":"21,061 "},{"v":20804,"d":"20,804 "},{"v":21007,"d":"21,007 "},{"v":20882,"d":"20,882 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":757199,"d":"757,199 "},{"v":756507,"d":"756,507 "},{"v":759056,"d":"759,056 "},{"v":765249,"d":"765,249 "},{"v":794855,"d":"794,855 "},{"v":95523,"d":"95,523 "},{"v":101847,"d":"101,847 "},{"v":98925,"d":"98,925 "},{"v":97427,"d":"97,427 "},{"v":98248,"d":"98,248 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":94917,"d":"94,917 "},{"v":100545,"d":"100,545 "},{"v":109959,"d":"109,959 "},{"v":108080,"d":"108,080 "},{"v":90200,"d":"90,200 "},{"v":11022,"d":"11,022 "},{"v":17910,"d":"17,910 "},{"v":14516,"d":"14,516 "},{"v":13985,"d":"13,985 "},{"v":13864,"d":"13,864 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":386131,"d":"386,131 "},{"v":395231,"d":"395,231 "},{"v":382611,"d":"382,611 "},{"v":393502,"d":"393,502 "},{"v":403464,"d":"403,464 "},{"v":41771,"d":"41,771 "},{"v":38372,"d":"38,372 "},{"v":41086,"d":"41,086 "},{"v":42120,"d":"42,120 "},{"v":42845,"d":"42,845 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":481048,"d":"481,048 "},{"v":495776,"d":"495,776 "},{"v":492570,"d":"492,570 "},{"v":501581,"d":"501,581 "},{"v":493664,"d":"493,664 "},{"v":52794,"d":"52,794 "},{"v":56282,"d":"56,282 "},{"v":55602,"d":"55,602 "},{"v":56104,"d":"56,104 "},{"v":56709,"d":"56,709 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1238247,"d":"1,238,247 "},{"v":1252283,"d":"1,252,283 "},{"v":1251626,"d":"1,251,626 "},{"v":1266831,"d":"1,266,831 "},{"v":1288519,"d":"1,288,519 "},{"v":148316,"d":"148,316 "},{"v":158129,"d":"158,129 "},{"v":154527,"d":"154,527 "},{"v":153531,"d":"153,531 "},{"v":154957,"d":"154,957 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":92701,"d":"92,701 "},{"v":101161,"d":"101,161 "},{"v":90716,"d":"90,716 "},{"v":92830,"d":"92,830 "},{"v":91580,"d":"91,580 "},{"v":6887,"d":"6,887 "},{"v":10931,"d":"10,931 "},{"v":10347,"d":"10,347 "},{"v":10061,"d":"10,061 "},{"v":9244,"d":"9,244 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",6.16,7.01,6.45,6.43,5.99,9.24,11.35,10.64,10.07,9.48]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",4.71,4.85,4.68,4.81,4.93,{"v":3.9,"d":"3.90"},4.13,3.89,3.73,{"v":3.7,"d":"3.70"}]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.21,20.63,20.79,20.73,22.24,16.57,16.07,16.22,16.16,16.71]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",36.51,35.94,35.29,35.32,36.54,32.79,34.78,33.85,32.82,32.83]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",34.39,34.68,34.69,34.61,34.46,50.92,48.61,49.11,50.16,50.43]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",4.49,3.86,3.61,3.68,{"v":4,"d":"4.00"},3.17,2.84,3.27,2.57,2.64]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",29.03,27.87,28.05,27.99,29.43,28.14,27.87,27.16,26.26,26.87]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.73,23.05,23.36,23.14,23.03,22.82,23.22,{"v":23.4,"d":"23.40"},23.51,23.06]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",61.15,60.41,60.65,60.41,61.69,{"v":64.4,"d":"64.40"},64.41,64.02,63.46,{"v":63.4,"d":"63.40"}]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",38.85,39.59,39.35,39.59,38.31,{"v":35.6,"d":"35.60"},35.59,35.98,36.54,{"v":36.6,"d":"36.60"}]
["  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-2014Q3","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"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 2Q_\n 2014_"," 3Q_\n 2014_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 2Q_\n 2014_"," 3Q_\n 2014_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":206013,"d":"206,013 "},{"v":241786,"d":"241,786 "},{"v":208376,"d":"208,376 "},{"v":214831,"d":"214,831 "},{"v":215386,"d":"215,386 "},{"v":306693,"d":"306,693 "},{"v":319693,"d":"319,693 "},{"v":301923,"d":"301,923 "},{"v":326410,"d":"326,410 "},{"v":323164,"d":"323,164 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":4912,"d":"4,912 "},{"v":5059,"d":"5,059 "},{"v":5052,"d":"5,052 "},{"v":5130,"d":"5,130 "},{"v":5212,"d":"5,212 "},{"v":4766,"d":"4,766 "},{"v":4906,"d":"4,906 "},{"v":4840,"d":"4,840 "},{"v":5024,"d":"5,024 "},{"v":5288,"d":"5,288 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":190806,"d":"190,806 "},{"v":220458,"d":"220,458 "},{"v":192592,"d":"192,592 "},{"v":198449,"d":"198,449 "},{"v":199506,"d":"199,506 "},{"v":287549,"d":"287,549 "},{"v":300377,"d":"300,377 "},{"v":283575,"d":"283,575 "},{"v":304079,"d":"304,079 "},{"v":302577,"d":"302,577 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":10295,"d":"10,295 "},{"v":16269,"d":"16,269 "},{"v":10732,"d":"10,732 "},{"v":11253,"d":"11,253 "},{"v":10667,"d":"10,667 "},{"v":14377,"d":"14,377 "},{"v":14410,"d":"14,410 "},{"v":13509,"d":"13,509 "},{"v":17307,"d":"17,307 "},{"v":15299,"d":"15,299 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1582,"d":"1,582 "},{"v":1723,"d":"1,723 "},{"v":1727,"d":"1,727 "},{"v":2088,"d":"2,088 "},{"v":1784,"d":"1,784 "},{"v":1812,"d":"1,812 "},{"v":1791,"d":"1,791 "},{"v":1782,"d":"1,782 "},{"v":1816,"d":"1,816 "},{"v":1888,"d":"1,888 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1918,"d":"1,918 "},{"v":1355,"d":"1,355 "},{"v":1892,"d":"1,892 "},{"v":2314,"d":"2,314 "},{"v":1864,"d":"1,864 "},{"v":766,"d":"766 "},{"v":2015,"d":"2,015 "},{"v":-34,"d":"(34)"},{"v":1023,"d":"1,023 "},{"v":-262,"d":"(262)"}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":10631,"d":"10,631 "},{"v":15900,"d":"15,900 "},{"v":10897,"d":"10,897 "},{"v":11478,"d":"11,478 "},{"v":10747,"d":"10,747 "},{"v":13331,"d":"13,331 "},{"v":14633,"d":"14,633 "},{"v":11692,"d":"11,692 "},{"v":16514,"d":"16,514 "},{"v":13148,"d":"13,148 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":3938,"d":"3,938 "},{"v":6128,"d":"6,128 "},{"v":4059,"d":"4,059 "},{"v":4214,"d":"4,214 "},{"v":3613,"d":"3,613 "},{"v":4527,"d":"4,527 "},{"v":4445,"d":"4,445 "},{"v":6580,"d":"6,580 "},{"v":5032,"d":"5,032 "},{"v":4359,"d":"4,359 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":6693,"d":"6,693 "},{"v":9772,"d":"9,772 "},{"v":6839,"d":"6,839 "},{"v":7264,"d":"7,264 "},{"v":7134,"d":"7,134 "},{"v":8804,"d":"8,804 "},{"v":10188,"d":"10,188 "},{"v":5112,"d":"5,112 "},{"v":11482,"d":"11,482 "},{"v":8788,"d":"8,788 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":1463,"d":"1,463 "},{"v":1849,"d":"1,849 "},{"v":7939,"d":"7,939 "},{"v":1644,"d":"1,644 "},{"v":2019,"d":"2,019 "},{"v":2381,"d":"2,381 "},{"v":2749,"d":"2,749 "},{"v":2790,"d":"2,790 "},{"v":3461,"d":"3,461 "},{"v":2742,"d":"2,742 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5230,"d":"5,230 "},{"v":7923,"d":"7,923 "},{"v":-1100,"d":"(1,100)"},{"v":5620,"d":"5,620 "},{"v":5115,"d":"5,115 "},{"v":6423,"d":"6,423 "},{"v":7439,"d":"7,439 "},{"v":2321,"d":"2,321 "},{"v":8021,"d":"8,021 "},{"v":6047,"d":"6,047 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":161575,"d":"161,575 "},{"v":163626,"d":"163,626 "},{"v":168728,"d":"168,728 "},{"v":154108,"d":"154,108 "},{"v":159501,"d":"159,501 "},{"v":175692,"d":"175,692 "},{"v":181778,"d":"181,778 "},{"v":187152,"d":"187,152 "},{"v":186704,"d":"186,704 "},{"v":192827,"d":"192,827 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-3382,"d":"(3,382)"},{"v":-2549,"d":"(2,549)"},{"v":-13658,"d":"(13,658)"},{"v":-1259,"d":"(1,259)"},{"v":-609,"d":"(609)"},{"v":-1178,"d":"(1,178)"},{"v":-1357,"d":"(1,357)"},{"v":-1918,"d":"(1,918)"},{"v":-1812,"d":"(1,812)"},{"v":-2262,"d":"(2,262)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":163423,"d":"163,423 "},{"v":169000,"d":"169,000 "},{"v":153970,"d":"153,970 "},{"v":158470,"d":"158,470 "},{"v":164007,"d":"164,007 "},{"v":180937,"d":"180,937 "},{"v":187859,"d":"187,859 "},{"v":187555,"d":"187,555 "},{"v":192913,"d":"192,913 "},{"v":196612,"d":"196,612 "}]
["                         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.38,2.09,2.42,2.39,2.42,1.55,1.53,{"v":1.6,"d":"1.60"},1.54,1.64]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",92.62,91.18,92.43,92.37,92.63,93.76,93.96,93.92,93.16,93.63]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5,"d":"5.00"},6.73,5.15,5.24,4.95,4.69,4.51,4.47,{"v":5.3,"d":"5.30"},4.73]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.77,0.71,0.83,0.97,0.83,0.59,0.56,0.59,0.56,0.58]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",0.93,0.56,0.91,1.08,0.87,0.25,0.63,{"v":-0.01,"d":"(0.01)"},0.31,{"v":-0.08,"d":"(0.08)"}]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",5.16,6.58,5.23,5.34,4.99,4.35,4.58,3.87,5.06,4.07]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.91,2.53,1.95,1.96,1.68,1.48,1.39,2.18,1.54,1.35]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",3.25,4.04,3.28,3.38,3.31,2.87,3.19,1.69,3.52,2.72]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":23.2,"d":"23.20"},32.73,22.96,23.47,21.74,21.77,23.87,18.92,26.44,21.99]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",14.61,20.12,14.41,14.85,14.43,14.38,16.62,8.27,18.38,{"v":14.7,"d":"14.70"}]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",8.84,13.34,9.11,9.45,8.52,8.76,9.48,7.56,10.53,8.36]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",5.57,{"v":8.2,"d":"8.20"},5.72,5.98,5.66,5.78,{"v":6.6,"d":"6.60"},{"v":3.3,"d":"3.30"},7.32,5.59]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.19,1.25,1.22,1.25,1.24,1.34,1.33,1.29,1.28,1.25]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.15,{"v":0.2,"d":"0.20"},0.18,0.18,0.15,0.24,0.25,0.23,0.23,0.22]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.36,1.51,1.47,{"v":1.5,"d":"1.50"},1.46,{"v":1.5,"d":"1.50"},1.46,1.48,1.47,1.38]
["  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-2014Q3","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"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 2Q_\n 2014_"," 3Q_\n 2014_"," 3Q_\n 2013_"," 4Q_\n 2013_"," 1Q_\n 2014_"," 2Q_\n 2014_"," 3Q_\n 2014_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":16864,"d":"16,864 "},{"v":19161,"d":"19,161 "},{"v":18288,"d":"18,288 "},{"v":19077,"d":"19,077 "},{"v":17334,"d":"17,334 "},{"v":29544,"d":"29,544 "},{"v":28914,"d":"28,914 "},{"v":27893,"d":"27,893 "},{"v":29191,"d":"29,191 "},{"v":29067,"d":"29,067 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":338,"d":"338 "},{"v":471,"d":"471 "},{"v":433,"d":"433 "},{"v":533,"d":"533 "},{"v":538,"d":"538 "},{"v":1448,"d":"1,448 "},{"v":1365,"d":"1,365 "},{"v":1336,"d":"1,336 "},{"v":1538,"d":"1,538 "},{"v":1253,"d":"1,253 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":17202,"d":"17,202 "},{"v":19632,"d":"19,632 "},{"v":18721,"d":"18,721 "},{"v":19610,"d":"19,610 "},{"v":17872,"d":"17,872 "},{"v":30992,"d":"30,992 "},{"v":30279,"d":"30,279 "},{"v":29229,"d":"29,229 "},{"v":30729,"d":"30,729 "},{"v":30320,"d":"30,320 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":3878,"d":"3,878 "},{"v":6136,"d":"6,136 "},{"v":4639,"d":"4,639 "},{"v":4403,"d":"4,403 "},{"v":3386,"d":"3,386 "},{"v":10517,"d":"10,517 "},{"v":13817,"d":"13,817 "},{"v":11718,"d":"11,718 "},{"v":11232,"d":"11,232 "},{"v":10855,"d":"10,855 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":21080,"d":"21,080 "},{"v":25768,"d":"25,768 "},{"v":23361,"d":"23,361 "},{"v":24013,"d":"24,013 "},{"v":21258,"d":"21,258 "},{"v":41509,"d":"41,509 "},{"v":44096,"d":"44,096 "},{"v":40947,"d":"40,947 "},{"v":41961,"d":"41,961 "},{"v":41175,"d":"41,175 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":7892,"d":"7,892 "},{"v":8481,"d":"8,481 "},{"v":8065,"d":"8,065 "},{"v":7936,"d":"7,936 "},{"v":8658,"d":"8,658 "},{"v":44614,"d":"44,614 "},{"v":45756,"d":"45,756 "},{"v":44457,"d":"44,457 "},{"v":47300,"d":"47,300 "},{"v":49148,"d":"49,148 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":126817,"d":"126,817 "},{"v":111102,"d":"111,102 "},{"v":112556,"d":"112,556 "},{"v":114355,"d":"114,355 "},{"v":133342,"d":"133,342 "},{"v":123685,"d":"123,685 "},{"v":121784,"d":"121,784 "},{"v":122633,"d":"122,633 "},{"v":123393,"d":"123,393 "},{"v":127349,"d":"127,349 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":17209,"d":"17,209 "},{"v":16438,"d":"16,438 "},{"v":16745,"d":"16,745 "},{"v":17139,"d":"17,139 "},{"v":17460,"d":"17,460 "},{"v":20699,"d":"20,699 "},{"v":21696,"d":"21,696 "},{"v":20673,"d":"20,673 "},{"v":20977,"d":"20,977 "},{"v":21563,"d":"21,563 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":172998,"d":"172,998 "},{"v":161790,"d":"161,790 "},{"v":160726,"d":"160,726 "},{"v":163443,"d":"163,443 "},{"v":180717,"d":"180,717 "},{"v":230507,"d":"230,507 "},{"v":233333,"d":"233,333 "},{"v":228710,"d":"228,710 "},{"v":233631,"d":"233,631 "},{"v":239236,"d":"239,236 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":297219,"d":"297,219 "},{"v":303370,"d":"303,370 "},{"v":306178,"d":"306,178 "},{"v":310768,"d":"310,768 "},{"v":316774,"d":"316,774 "},{"v":256942,"d":"256,942 "},{"v":267296,"d":"267,296 "},{"v":271872,"d":"271,872 "},{"v":276959,"d":"276,959 "},{"v":282441,"d":"282,441 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":32669,"d":"32,669 "},{"v":33278,"d":"33,278 "},{"v":33445,"d":"33,445 "},{"v":33694,"d":"33,694 "},{"v":33896,"d":"33,896 "},{"v":36180,"d":"36,180 "},{"v":29782,"d":"29,782 "},{"v":29460,"d":"29,460 "},{"v":29342,"d":"29,342 "},{"v":29764,"d":"29,764 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":138869,"d":"138,869 "},{"v":140487,"d":"140,487 "},{"v":143483,"d":"143,483 "},{"v":146985,"d":"146,985 "},{"v":151295,"d":"151,295 "},{"v":133834,"d":"133,834 "},{"v":135787,"d":"135,787 "},{"v":139170,"d":"139,170 "},{"v":142353,"d":"142,353 "},{"v":145724,"d":"145,724 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":191019,"d":"191,019 "},{"v":196162,"d":"196,162 "},{"v":196140,"d":"196,140 "},{"v":197477,"d":"197,477 "},{"v":199376,"d":"199,376 "},{"v":159288,"d":"159,288 "},{"v":161290,"d":"161,290 "},{"v":162161,"d":"162,161 "},{"v":163949,"d":"163,949 "},{"v":166481,"d":"166,481 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":116864,"d":"116,864 "},{"v":118799,"d":"118,799 "},{"v":121521,"d":"121,521 "},{"v":125087,"d":"125,087 "},{"v":124335,"d":"124,335 "},{"v":219254,"d":"219,254 "},{"v":222781,"d":"222,781 "},{"v":227840,"d":"227,840 "},{"v":229713,"d":"229,713 "},{"v":223418,"d":"223,418 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":480881,"d":"480,881 "},{"v":476750,"d":"476,750 "},{"v":478387,"d":"478,387 "},{"v":486006,"d":"486,006 "},{"v":504428,"d":"504,428 "},{"v":609050,"d":"609,050 "},{"v":617404,"d":"617,404 "},{"v":618712,"d":"618,712 "},{"v":627293,"d":"627,293 "},{"v":629135,"d":"629,135 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1135,"d":"1,135 "},{"v":1097,"d":"1,097 "},{"v":1616,"d":"1,616 "},{"v":1963,"d":"1,963 "},{"v":2418,"d":"2,418 "},{"v":13153,"d":"13,153 "},{"v":14069,"d":"14,069 "},{"v":13683,"d":"13,683 "},{"v":13506,"d":"13,506 "},{"v":13402,"d":"13,402 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":15637,"d":"15,637 "},{"v":9282,"d":"9,282 "},{"v":5498,"d":"5,498 "},{"v":4603,"d":"4,603 "},{"v":8037,"d":"8,037 "},{"v":4223,"d":"4,223 "},{"v":4344,"d":"4,344 "},{"v":3887,"d":"3,887 "},{"v":4541,"d":"4,541 "},{"v":4379,"d":"4,379 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":72098,"d":"72,098 "},{"v":61033,"d":"61,033 "},{"v":64153,"d":"64,153 "},{"v":65029,"d":"65,029 "},{"v":75719,"d":"75,719 "},{"v":87898,"d":"87,898 "},{"v":87170,"d":"87,170 "},{"v":89383,"d":"89,383 "},{"v":92043,"d":"92,043 "},{"v":96108,"d":"96,108 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":371,"d":"371 "},{"v":2394,"d":"2,394 "},{"v":3279,"d":"3,279 "},{"v":1367,"d":"1,367 "},{"v":1020,"d":"1,020 "},{"v":2284,"d":"2,284 "},{"v":2735,"d":"2,735 "},{"v":5530,"d":"5,530 "},{"v":5464,"d":"5,464 "},{"v":5291,"d":"5,291 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":447,"d":"447 "},{"v":407,"d":"407 "},{"v":448,"d":"448 "},{"v":633,"d":"633 "},{"v":619,"d":"619 "},{"v":4537,"d":"4,537 "},{"v":4376,"d":"4,376 "},{"v":4404,"d":"4,404 "},{"v":4847,"d":"4,847 "},{"v":5320,"d":"5,320 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":6716,"d":"6,716 "},{"v":5907,"d":"5,907 "},{"v":5110,"d":"5,110 "},{"v":5588,"d":"5,588 "},{"v":5907,"d":"5,907 "},{"v":5110,"d":"5,110 "},{"v":4391,"d":"4,391 "},{"v":5442,"d":"5,442 "},{"v":6942,"d":"6,942 "},{"v":7405,"d":"7,405 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":48948,"d":"48,948 "},{"v":49365,"d":"49,365 "},{"v":51212,"d":"51,212 "},{"v":52011,"d":"52,011 "},{"v":52551,"d":"52,551 "},{"v":55135,"d":"55,135 "},{"v":58322,"d":"58,322 "},{"v":55424,"d":"55,424 "},{"v":55769,"d":"55,769 "},{"v":59442,"d":"59,442 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":145351,"d":"145,351 "},{"v":129486,"d":"129,486 "},{"v":131316,"d":"131,316 "},{"v":131193,"d":"131,193 "},{"v":146270,"d":"146,270 "},{"v":172340,"d":"172,340 "},{"v":175406,"d":"175,406 "},{"v":177752,"d":"177,752 "},{"v":183113,"d":"183,113 "},{"v":191347,"d":"191,347 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":13193,"d":"13,193 "},{"v":12434,"d":"12,434 "},{"v":13216,"d":"13,216 "},{"v":13865,"d":"13,865 "},{"v":15559,"d":"15,559 "},{"v":42434,"d":"42,434 "},{"v":46247,"d":"46,247 "},{"v":47183,"d":"47,183 "},{"v":45956,"d":"45,956 "},{"v":45713,"d":"45,713 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":97739,"d":"97,739 "},{"v":99245,"d":"99,245 "},{"v":102984,"d":"102,984 "},{"v":103595,"d":"103,595 "},{"v":103191,"d":"103,191 "},{"v":94190,"d":"94,190 "},{"v":94051,"d":"94,051 "},{"v":92795,"d":"92,795 "},{"v":93676,"d":"93,676 "},{"v":96501,"d":"96,501 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":41312,"d":"41,312 "},{"v":41263,"d":"41,263 "},{"v":41039,"d":"41,039 "},{"v":41697,"d":"41,697 "},{"v":41632,"d":"41,632 "},{"v":55118,"d":"55,118 "},{"v":56527,"d":"56,527 "},{"v":53847,"d":"53,847 "},{"v":54728,"d":"54,728 "},{"v":56395,"d":"56,395 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":297595,"d":"297,595 "},{"v":282429,"d":"282,429 "},{"v":288554,"d":"288,554 "},{"v":290350,"d":"290,350 "},{"v":306651,"d":"306,651 "},{"v":364081,"d":"364,081 "},{"v":372231,"d":"372,231 "},{"v":371577,"d":"371,577 "},{"v":377472,"d":"377,472 "},{"v":389956,"d":"389,956 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":19863,"d":"19,863 "},{"v":25321,"d":"25,321 "},{"v":35863,"d":"35,863 "},{"v":37187,"d":"37,187 "},{"v":33769,"d":"33,769 "},{"v":64032,"d":"64,032 "},{"v":57314,"d":"57,314 "},{"v":59580,"d":"59,580 "},{"v":56908,"d":"56,908 "},{"v":42567,"d":"42,567 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":163423,"d":"163,423 "},{"v":169000,"d":"169,000 "},{"v":153970,"d":"153,970 "},{"v":158470,"d":"158,470 "},{"v":164007,"d":"164,007 "},{"v":180937,"d":"180,937 "},{"v":187859,"d":"187,859 "},{"v":187555,"d":"187,555 "},{"v":192913,"d":"192,913 "},{"v":196612,"d":"196,612 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":183286,"d":"183,286 "},{"v":194321,"d":"194,321 "},{"v":189833,"d":"189,833 "},{"v":195657,"d":"195,657 "},{"v":197776,"d":"197,776 "},{"v":244968,"d":"244,968 "},{"v":245173,"d":"245,173 "},{"v":247135,"d":"247,135 "},{"v":249821,"d":"249,821 "},{"v":239179,"d":"239,179 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":480881,"d":"480,881 "},{"v":476750,"d":"476,750 "},{"v":478387,"d":"478,387 "},{"v":486006,"d":"486,006 "},{"v":504428,"d":"504,428 "},{"v":609050,"d":"609,050 "},{"v":617404,"d":"617,404 "},{"v":618712,"d":"618,712 "},{"v":627293,"d":"627,293 "},{"v":629135,"d":"629,135 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":27647,"d":"27,647 "},{"v":32303,"d":"32,303 "},{"v":29410,"d":"29,410 "},{"v":32250,"d":"32,250 "},{"v":34447,"d":"34,447 "},{"v":58168,"d":"58,168 "},{"v":57927,"d":"57,927 "},{"v":50958,"d":"50,958 "},{"v":50518,"d":"50,518 "},{"v":47888,"d":"47,888 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",4.38,{"v":5.4,"d":"5.40"},4.88,4.94,4.21,6.82,7.14,6.62,6.69,6.54]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",1.64,1.78,1.69,1.63,1.72,7.33,7.41,7.19,7.54,7.81]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",26.37,{"v":23.3,"d":"23.30"},23.53,23.53,26.43,20.31,19.73,19.82,19.67,20.24]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",35.98,33.94,{"v":33.6,"d":"33.60"},33.63,35.83,37.85,37.79,36.97,37.24,38.03]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",39.72,41.15,{"v":41,"d":"41.00"},40.63,39.53,26.15,26.12,26.21,26.14,26.46]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",4.98,{"v":3.5,"d":"3.50"},2.65,2.63,3.37,4.44,{"v":4.4,"d":"4.40"},4.43,4.76,4.85]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",30.23,27.16,27.45,26.99,{"v":29,"d":"29.00"},{"v":28.3,"d":"28.30"},28.41,28.73,29.19,30.41]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",23.07,23.43,24.29,24.17,23.54,22.43,22.72,22.62,22.26,{"v":22.6,"d":"22.60"}]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",61.89,59.24,60.32,59.74,60.79,59.78,60.29,60.06,60.17,61.98]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",38.11,40.76,39.68,40.26,39.21,40.22,39.71,39.94,39.83,38.02]
["  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-2014Q3","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":367073,"d":"367,073 "},{"v":369877,"d":"369,877 "},{"v":391341,"d":"391,341 "},{"v":398882,"d":"398,882 "}]
["2004 …………………………………………………………………………………………...………………………………………………..",{"v":407099,"d":"407,099 "},{"v":410442,"d":"410,442 "},{"v":421536,"d":"421,536 "},{"v":427487,"d":"427,487 "}]
["2005 …………………………………………………………………………………………...………………………………………………..",{"v":438325,"d":"438,325 "},{"v":447441,"d":"447,441 "},{"v":458372,"d":"458,372 "},{"v":468037,"d":"468,037 "}]
["2006 …………………………………………………………………………………………...………………………………………………..",{"v":480450,"d":"480,450 "},{"v":492754,"d":"492,754 "},{"v":497498,"d":"497,498 "},{"v":502145,"d":"502,145 "}]
["2007 …………………………………………………………………………………………...………………………………………………..",{"v":509962,"d":"509,962 "},{"v":514613,"d":"514,613 "},{"v":515907,"d":"515,907 "},{"v":521254,"d":"521,254 "}]
["2008 …………………………………………………………………………………………...………………………………………………..",{"v":523402,"d":"523,402 "},{"v":536149,"d":"536,149 "},{"v":531407,"d":"531,407 "},{"v":501231,"d":"501,231 "}]
["2009 …………………………………………………………………………………………...………………………………………………..",{"v":495834,"d":"495,834 "},{"v":495031,"d":"495,031 "},{"v":508510,"d":"508,510 "},{"v":520131,"d":"520,131 "}]
["2010 …………………………………………………………………………………………...………………………………………………..",{"v":532127,"d":"532,127 "},{"v":534564,"d":"534,564 "},{"v":539675,"d":"539,675 "},{"v":551086,"d":"551,086 "}]
["2011 …………………………………………………………………………………………...………………………………………………..",{"v":567054,"d":"567,054 "},{"v":585063,"d":"585,063 "},{"v":586129,"d":"586,129 "},{"v":586975,"d":"586,975 "}]
["2012 …………………………………………………………………………………………...………………………………………………..",{"v":602740,"d":"602,740 "},{"v":597932,"d":"597,932 "},{"v":603230,"d":"603,230 "},{"v":612364,"d":"612,364 "}]
["2013 …………………………………………………………………………………………...………………………………………………..",{"v":617609,"d":"617,609 "},{"v":626866,"d":"626,866 "},{"v":636359,"d":"636,359 "},{"v":642690,"d":"642,690 "}]
["2014 …………………………………………………………………………………………...………………………………………………..",{"v":638130,"d":"638,130 "},{"v":660693,"d":"660,693 "},{"v":668144,"d":"668,144 "}]
[]
["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."]