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

{"sheet":"RET_4_0-2015Q1","index":0,"n_rows":47,"n_cols":11,"rows_kept":47,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[22,1,22,4],[22,6,22,9],[33,1,33,4],[33,6,33,9],[46,0,46,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 4.0 -- Income Statement  For Corporations in NAICS Retail Trade Sector, and Retail Trade Subsector 445,\n                              Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"All Retail Trade\nTotal Assets $50 Million and Over",{"$nulls":4},"Food and Beverage Stores\nTotal Assets $50 Million and Over"]
["Item"," 1Q_\n 2014_"," 2Q_\n 2014_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 1Q_\n 2014_"," 2Q_\n 2014_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":624871,"d":"624,871 "},{"v":657743,"d":"657,743 "},{"v":654202,"d":"654,202 "},{"v":703063,"d":"703,063 "},{"v":637582,"d":"637,582 "},{"v":113582,"d":"113,582 "},{"v":115969,"d":"115,969 "},{"v":115844,"d":"115,844 "},{"v":116558,"d":"116,558 "},{"v":111687,"d":"111,687 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":12226,"d":"12,226 "},{"v":12538,"d":"12,538 "},{"v":12755,"d":"12,755 "},{"v":13044,"d":"13,044 "},{"v":13385,"d":"13,385 "},{"v":2325,"d":"2,325 "},{"v":2388,"d":"2,388 "},{"v":2408,"d":"2,408 "},{"v":2428,"d":"2,428 "},{"v":2549,"d":"2,549 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":584804,"d":"584,804 "},{"v":613354,"d":"613,354 "},{"v":611879,"d":"611,879 "},{"v":651273,"d":"651,273 "},{"v":592394,"d":"592,394 "},{"v":107672,"d":"107,672 "},{"v":110198,"d":"110,198 "},{"v":110347,"d":"110,347 "},{"v":110526,"d":"110,526 "},{"v":105265,"d":"105,265 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":27841,"d":"27,841 "},{"v":31851,"d":"31,851 "},{"v":29568,"d":"29,568 "},{"v":38746,"d":"38,746 "},{"v":31802,"d":"31,802 "},{"v":3584,"d":"3,584 "},{"v":3383,"d":"3,383 "},{"v":3089,"d":"3,089 "},{"v":3604,"d":"3,604 "},{"v":3873,"d":"3,873 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4190,"d":"4,190 "},{"v":4584,"d":"4,584 "},{"v":4336,"d":"4,336 "},{"v":4400,"d":"4,400 "},{"v":4480,"d":"4,480 "},{"v":677,"d":"677 "},{"v":678,"d":"678 "},{"v":658,"d":"658 "},{"v":640,"d":"640 "},{"v":693,"d":"693 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1908,"d":"1,908 "},{"v":3567,"d":"3,567 "},{"v":-120,"d":"(120)"},{"v":717,"d":"717 "},{"v":3470,"d":"3,470 "},{"v":45,"d":"45 "},{"v":198,"d":"198 "},{"v":-189,"d":"(189)"},{"v":-33,"d":"(33)"},{"v":153,"d":"153 "}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":25559,"d":"25,559 "},{"v":30834,"d":"30,834 "},{"v":25112,"d":"25,112 "},{"v":35063,"d":"35,063 "},{"v":30792,"d":"30,792 "},{"v":2952,"d":"2,952 "},{"v":2904,"d":"2,904 "},{"v":2242,"d":"2,242 "},{"v":2930,"d":"2,930 "},{"v":3332,"d":"3,332 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":11736,"d":"11,736 "},{"v":10265,"d":"10,265 "},{"v":8792,"d":"8,792 "},{"v":11495,"d":"11,495 "},{"v":7800,"d":"7,800 "},{"v":1072,"d":"1,072 "},{"v":979,"d":"979 "},{"v":846,"d":"846 "},{"v":951,"d":"951 "},{"v":1264,"d":"1,264 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":13823,"d":"13,823 "},{"v":20569,"d":"20,569 "},{"v":16320,"d":"16,320 "},{"v":23568,"d":"23,568 "},{"v":22992,"d":"22,992 "},{"v":1881,"d":"1,881 "},{"v":1924,"d":"1,924 "},{"v":1396,"d":"1,396 "},{"v":1979,"d":"1,979 "},{"v":2068,"d":"2,068 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":11414,"d":"11,414 "},{"v":5889,"d":"5,889 "},{"v":4915,"d":"4,915 "},{"v":5881,"d":"5,881 "},{"v":13753,"d":"13,753 "},{"v":690,"d":"690 "},{"v":758,"d":"758 "},{"v":651,"d":"651 "},{"v":708,"d":"708 "},{"v":1033,"d":"1,033 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":2409,"d":"2,409 "},{"v":14680,"d":"14,680 "},{"v":11405,"d":"11,405 "},{"v":17687,"d":"17,687 "},{"v":9239,"d":"9,239 "},{"v":1191,"d":"1,191 "},{"v":1167,"d":"1,167 "},{"v":745,"d":"745 "},{"v":1271,"d":"1,271 "},{"v":1035,"d":"1,035 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":396817,"d":"396,817 "},{"v":381976,"d":"381,976 "},{"v":394191,"d":"394,191 "},{"v":401079,"d":"401,079 "},{"v":411255,"d":"411,255 "},{"v":39833,"d":"39,833 "},{"v":41305,"d":"41,305 "},{"v":42225,"d":"42,225 "},{"v":42432,"d":"42,432 "},{"v":42673,"d":"42,673 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-15844,"d":"(15,844)"},{"v":-3429,"d":"(3,429)"},{"v":-3678,"d":"(3,678)"},{"v":-5025,"d":"(5,025)"},{"v":-4870,"d":"(4,870)"},{"v":62,"d":"62 "},{"v":-351,"d":"(351)"},{"v":-112,"d":"(112)"},{"v":-633,"d":"(633)"},{"v":-105,"d":"(105)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":383382,"d":"383,382 "},{"v":393227,"d":"393,227 "},{"v":401919,"d":"401,919 "},{"v":413741,"d":"413,741 "},{"v":415624,"d":"415,624 "},{"v":41086,"d":"41,086 "},{"v":42121,"d":"42,121 "},{"v":42859,"d":"42,859 "},{"v":43070,"d":"43,070 "},{"v":43603,"d":"43,603 "}]
["                         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.96,1.91,1.95,1.86,{"v":2.1,"d":"2.10"},2.05,2.06,2.08,2.08,2.28]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",93.59,93.25,93.53,92.63,92.91,{"v":94.8,"d":"94.80"},95.02,95.25,94.83,94.25]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",4.46,4.84,4.52,5.51,4.99,3.16,2.92,2.67,3.09,3.47]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.67,{"v":0.7,"d":"0.70"},0.66,0.63,{"v":0.7,"d":"0.70"},{"v":0.6,"d":"0.60"},0.58,0.57,0.55,0.62]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",0.31,0.54,{"v":-0.02,"d":"(0.02)"},{"v":0.1,"d":"0.10"},0.54,0.04,0.17,{"v":-0.16,"d":"(0.16)"},{"v":-0.03,"d":"(0.03)"},0.14]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",4.09,4.69,3.84,4.99,4.83,{"v":2.6,"d":"2.60"},{"v":2.5,"d":"2.50"},1.94,2.51,2.98]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.88,1.56,1.34,1.63,1.22,0.94,0.84,0.73,0.82,1.13]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",2.21,3.13,2.49,3.35,3.61,1.66,1.66,1.21,{"v":1.7,"d":"1.70"},1.85]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",20.75,24.63,20.44,28.23,24.45,21.24,{"v":20.7,"d":"20.70"},15.81,20.33,{"v":22.3,"d":"22.30"}]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",11.22,16.43,13.28,18.97,18.25,13.53,13.72,9.85,13.74,13.84]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",8.15,9.73,{"v":7.8,"d":"7.80"},10.79,9.32,7.64,7.57,5.79,7.41,8.39]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",4.41,6.49,5.07,7.25,6.96,4.87,5.01,3.61,{"v":5,"d":"5.00"},5.21]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.26,1.26,1.24,1.31,1.26,1.25,1.25,1.22,1.25,1.21]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.23,0.23,{"v":0.2,"d":"0.20"},0.28,0.23,0.39,0.38,0.35,0.38,0.36]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.45,1.47,{"v":1.4,"d":"1.40"},1.38,1.38,1.35,{"v":1.4,"d":"1.40"},1.44,1.43,1.59]
["  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-2015Q1","index":1,"n_rows":61,"n_cols":11,"rows_kept":61,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[49,1,49,4],[49,6,49,9],[60,0,60,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 4.1 -- Balance Sheet  For Corporations in NAICS Retail Trade Sector, and Retail Trade Subsector 445,\n                               Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"All Retail Trade\nTotal Assets $50 Million and Over",{"$nulls":4},"Food and Beverage Stores\nTotal Assets $50 Million and Over"]
["Item"," 1Q_\n 2014_"," 2Q_\n 2014_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 1Q_\n 2014_"," 2Q_\n 2014_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":58079,"d":"58,079 "},{"v":59348,"d":"59,348 "},{"v":56552,"d":"56,552 "},{"v":77951,"d":"77,951 "},{"v":64144,"d":"64,144 "},{"v":12123,"d":"12,123 "},{"v":11491,"d":"11,491 "},{"v":11622,"d":"11,622 "},{"v":12663,"d":"12,663 "},{"v":12186,"d":"12,186 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":3555,"d":"3,555 "},{"v":4103,"d":"4,103 "},{"v":3063,"d":"3,063 "},{"v":3125,"d":"3,125 "},{"v":2693,"d":"2,693 "},{"v":1774,"d":"1,774 "},{"v":2011,"d":"2,011 "},{"v":1110,"d":"1,110 "},{"v":1093,"d":"1,093 "},{"v":840,"d":"840 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":61633,"d":"61,633 "},{"v":63451,"d":"63,451 "},{"v":59615,"d":"59,615 "},{"v":81077,"d":"81,077 "},{"v":66837,"d":"66,837 "},{"v":13897,"d":"13,897 "},{"v":13502,"d":"13,502 "},{"v":12732,"d":"12,732 "},{"v":13756,"d":"13,756 "},{"v":13026,"d":"13,026 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":19539,"d":"19,539 "},{"v":17935,"d":"17,935 "},{"v":16278,"d":"16,278 "},{"v":20977,"d":"20,977 "},{"v":19675,"d":"19,675 "},{"v":2542,"d":"2,542 "},{"v":1960,"d":"1,960 "},{"v":1973,"d":"1,973 "},{"v":2162,"d":"2,162 "},{"v":2180,"d":"2,180 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":81173,"d":"81,173 "},{"v":81386,"d":"81,386 "},{"v":75893,"d":"75,893 "},{"v":102054,"d":"102,054 "},{"v":86511,"d":"86,511 "},{"v":16439,"d":"16,439 "},{"v":15462,"d":"15,462 "},{"v":14705,"d":"14,705 "},{"v":15918,"d":"15,918 "},{"v":15207,"d":"15,207 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":58662,"d":"58,662 "},{"v":61125,"d":"61,125 "},{"v":63595,"d":"63,595 "},{"v":66249,"d":"66,249 "},{"v":64564,"d":"64,564 "},{"v":6016,"d":"6,016 "},{"v":5703,"d":"5,703 "},{"v":5689,"d":"5,689 "},{"v":5879,"d":"5,879 "},{"v":5834,"d":"5,834 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":261185,"d":"261,185 "},{"v":262529,"d":"262,529 "},{"v":286587,"d":"286,587 "},{"v":268701,"d":"268,701 "},{"v":273071,"d":"273,071 "},{"v":25059,"d":"25,059 "},{"v":24839,"d":"24,839 "},{"v":25887,"d":"25,887 "},{"v":25857,"d":"25,857 "},{"v":25526,"d":"25,526 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":41801,"d":"41,801 "},{"v":41980,"d":"41,980 "},{"v":43124,"d":"43,124 "},{"v":43185,"d":"43,185 "},{"v":50775,"d":"50,775 "},{"v":4798,"d":"4,798 "},{"v":4380,"d":"4,380 "},{"v":4568,"d":"4,568 "},{"v":4659,"d":"4,659 "},{"v":4594,"d":"4,594 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":442820,"d":"442,820 "},{"v":447020,"d":"447,020 "},{"v":469199,"d":"469,199 "},{"v":480188,"d":"480,188 "},{"v":474922,"d":"474,922 "},{"v":52312,"d":"52,312 "},{"v":50384,"d":"50,384 "},{"v":50849,"d":"50,849 "},{"v":52313,"d":"52,313 "},{"v":51161,"d":"51,161 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":718437,"d":"718,437 "},{"v":728506,"d":"728,506 "},{"v":741586,"d":"741,586 "},{"v":752482,"d":"752,482 "},{"v":762688,"d":"762,688 "},{"v":139649,"d":"139,649 "},{"v":140797,"d":"140,797 "},{"v":142882,"d":"142,882 "},{"v":145698,"d":"145,698 "},{"v":147842,"d":"147,842 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":74844,"d":"74,844 "},{"v":75208,"d":"75,208 "},{"v":76117,"d":"76,117 "},{"v":76565,"d":"76,565 "},{"v":76793,"d":"76,793 "},{"v":11097,"d":"11,097 "},{"v":11214,"d":"11,214 "},{"v":11529,"d":"11,529 "},{"v":11661,"d":"11,661 "},{"v":11787,"d":"11,787 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":357929,"d":"357,929 "},{"v":364025,"d":"364,025 "},{"v":372458,"d":"372,458 "},{"v":378868,"d":"378,868 "},{"v":387170,"d":"387,170 "},{"v":74862,"d":"74,862 "},{"v":75001,"d":"75,001 "},{"v":76248,"d":"76,248 "},{"v":78027,"d":"78,027 "},{"v":79444,"d":"79,444 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":435352,"d":"435,352 "},{"v":439689,"d":"439,689 "},{"v":445245,"d":"445,245 "},{"v":450179,"d":"450,179 "},{"v":452312,"d":"452,312 "},{"v":75884,"d":"75,884 "},{"v":77010,"d":"77,010 "},{"v":78163,"d":"78,163 "},{"v":79332,"d":"79,332 "},{"v":80186,"d":"80,186 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":376625,"d":"376,625 "},{"v":381495,"d":"381,495 "},{"v":373605,"d":"373,605 "},{"v":369186,"d":"369,186 "},{"v":394063,"d":"394,063 "},{"v":26331,"d":"26,331 "},{"v":26141,"d":"26,141 "},{"v":25935,"d":"25,935 "},{"v":26530,"d":"26,530 "},{"v":27554,"d":"27,554 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1254797,"d":"1,254,797 "},{"v":1268204,"d":"1,268,204 "},{"v":1288049,"d":"1,288,049 "},{"v":1299553,"d":"1,299,553 "},{"v":1321297,"d":"1,321,297 "},{"v":154527,"d":"154,527 "},{"v":153534,"d":"153,534 "},{"v":154948,"d":"154,948 "},{"v":158175,"d":"158,175 "},{"v":158901,"d":"158,901 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15628,"d":"15,628 "},{"v":16114,"d":"16,114 "},{"v":17171,"d":"17,171 "},{"v":18709,"d":"18,709 "},{"v":18316,"d":"18,316 "},{"v":414,"d":"414 "},{"v":409,"d":"409 "},{"v":399,"d":"399 "},{"v":382,"d":"382 "},{"v":485,"d":"485 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":10439,"d":"10,439 "},{"v":10179,"d":"10,179 "},{"v":14136,"d":"14,136 "},{"v":8314,"d":"8,314 "},{"v":8122,"d":"8,122 "},{"v":395,"d":"395 "},{"v":363,"d":"363 "},{"v":1086,"d":"1,086 "},{"v":1117,"d":"1,117 "},{"v":1246,"d":"1,246 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":175205,"d":"175,205 "},{"v":177760,"d":"177,760 "},{"v":193134,"d":"193,134 "},{"v":181565,"d":"181,565 "},{"v":183862,"d":"183,862 "},{"v":21607,"d":"21,607 "},{"v":21122,"d":"21,122 "},{"v":21705,"d":"21,705 "},{"v":22272,"d":"22,272 "},{"v":22049,"d":"22,049 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":10041,"d":"10,041 "},{"v":7498,"d":"7,498 "},{"v":6226,"d":"6,226 "},{"v":8218,"d":"8,218 "},{"v":10184,"d":"10,184 "},{"v":1123,"d":"1,123 "},{"v":623,"d":"623 "},{"v":326,"d":"326 "},{"v":420,"d":"420 "},{"v":699,"d":"699 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5829,"d":"5,829 "},{"v":6495,"d":"6,495 "},{"v":6016,"d":"6,016 "},{"v":7563,"d":"7,563 "},{"v":6475,"d":"6,475 "},{"v":891,"d":"891 "},{"v":853,"d":"853 "},{"v":953,"d":"953 "},{"v":1126,"d":"1,126 "},{"v":790,"d":"790 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":13993,"d":"13,993 "},{"v":14971,"d":"14,971 "},{"v":14918,"d":"14,918 "},{"v":12444,"d":"12,444 "},{"v":16597,"d":"16,597 "},{"v":3325,"d":"3,325 "},{"v":2292,"d":"2,292 "},{"v":1518,"d":"1,518 "},{"v":1058,"d":"1,058 "},{"v":1293,"d":"1,293 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":120761,"d":"120,761 "},{"v":122223,"d":"122,223 "},{"v":127385,"d":"127,385 "},{"v":129383,"d":"129,383 "},{"v":131944,"d":"131,944 "},{"v":14210,"d":"14,210 "},{"v":14726,"d":"14,726 "},{"v":15675,"d":"15,675 "},{"v":15536,"d":"15,536 "},{"v":15759,"d":"15,759 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":351895,"d":"351,895 "},{"v":355238,"d":"355,238 "},{"v":378985,"d":"378,985 "},{"v":366196,"d":"366,196 "},{"v":375500,"d":"375,500 "},{"v":41965,"d":"41,965 "},{"v":40387,"d":"40,387 "},{"v":41663,"d":"41,663 "},{"v":41911,"d":"41,911 "},{"v":42321,"d":"42,321 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":72440,"d":"72,440 "},{"v":70996,"d":"70,996 "},{"v":72014,"d":"72,014 "},{"v":72443,"d":"72,443 "},{"v":76928,"d":"76,928 "},{"v":9162,"d":"9,162 "},{"v":8906,"d":"8,906 "},{"v":9257,"d":"9,257 "},{"v":9383,"d":"9,383 "},{"v":9348,"d":"9,348 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":221437,"d":"221,437 "},{"v":223066,"d":"223,066 "},{"v":225672,"d":"225,672 "},{"v":240080,"d":"240,080 "},{"v":238164,"d":"238,164 "},{"v":26995,"d":"26,995 "},{"v":27132,"d":"27,132 "},{"v":26100,"d":"26,100 "},{"v":27288,"d":"27,288 "},{"v":24509,"d":"24,509 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":116295,"d":"116,295 "},{"v":118062,"d":"118,062 "},{"v":119860,"d":"119,860 "},{"v":124008,"d":"124,008 "},{"v":126910,"d":"126,910 "},{"v":20804,"d":"20,804 "},{"v":21007,"d":"21,007 "},{"v":21214,"d":"21,214 "},{"v":21962,"d":"21,962 "},{"v":22947,"d":"22,947 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":762067,"d":"762,067 "},{"v":767362,"d":"767,362 "},{"v":796531,"d":"796,531 "},{"v":802726,"d":"802,726 "},{"v":817503,"d":"817,503 "},{"v":98925,"d":"98,925 "},{"v":97433,"d":"97,433 "},{"v":98234,"d":"98,234 "},{"v":100544,"d":"100,544 "},{"v":99125,"d":"99,125 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":109349,"d":"109,349 "},{"v":107615,"d":"107,615 "},{"v":89599,"d":"89,599 "},{"v":83085,"d":"83,085 "},{"v":88170,"d":"88,170 "},{"v":14516,"d":"14,516 "},{"v":13980,"d":"13,980 "},{"v":13855,"d":"13,855 "},{"v":14562,"d":"14,562 "},{"v":16173,"d":"16,173 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":383382,"d":"383,382 "},{"v":393227,"d":"393,227 "},{"v":401919,"d":"401,919 "},{"v":413741,"d":"413,741 "},{"v":415624,"d":"415,624 "},{"v":41086,"d":"41,086 "},{"v":42121,"d":"42,121 "},{"v":42859,"d":"42,859 "},{"v":43070,"d":"43,070 "},{"v":43603,"d":"43,603 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":492730,"d":"492,730 "},{"v":500843,"d":"500,843 "},{"v":491517,"d":"491,517 "},{"v":496827,"d":"496,827 "},{"v":503794,"d":"503,794 "},{"v":55602,"d":"55,602 "},{"v":56102,"d":"56,102 "},{"v":56713,"d":"56,713 "},{"v":57632,"d":"57,632 "},{"v":59776,"d":"59,776 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1254797,"d":"1,254,797 "},{"v":1268204,"d":"1,268,204 "},{"v":1288049,"d":"1,288,049 "},{"v":1299553,"d":"1,299,553 "},{"v":1321297,"d":"1,321,297 "},{"v":154527,"d":"154,527 "},{"v":153534,"d":"153,534 "},{"v":154948,"d":"154,948 "},{"v":158175,"d":"158,175 "},{"v":158901,"d":"158,901 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":90925,"d":"90,925 "},{"v":91782,"d":"91,782 "},{"v":90214,"d":"90,214 "},{"v":113992,"d":"113,992 "},{"v":99421,"d":"99,421 "},{"v":10347,"d":"10,347 "},{"v":9996,"d":"9,996 "},{"v":9186,"d":"9,186 "},{"v":10403,"d":"10,403 "},{"v":8840,"d":"8,840 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",6.47,6.42,5.89,7.85,6.55,10.64,10.07,9.49,10.06,9.57]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",4.68,4.82,4.94,{"v":5.1,"d":"5.10"},4.89,3.89,3.71,3.67,3.72,3.67]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",20.81,{"v":20.7,"d":"20.70"},22.25,20.68,20.67,16.22,16.18,16.71,16.35,16.06]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",35.29,35.25,36.43,36.95,35.94,33.85,32.82,32.82,33.07,{"v":32.2,"d":"32.20"}]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":34.7,"d":"34.70"},34.67,34.57,34.64,34.23,49.11,50.16,50.45,50.15,50.46]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",3.66,3.77,4.06,3.62,3.75,3.25,2.55,2.55,2.33,{"v":2.4,"d":"2.40"}]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",28.04,28.01,29.42,28.18,28.42,27.16,26.31,26.89,{"v":26.5,"d":"26.50"},26.63]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",23.42,23.19,23.11,24.05,23.85,{"v":23.4,"d":"23.40"},23.47,22.82,23.18,21.31]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",60.73,60.51,61.84,61.77,61.87,64.02,63.46,{"v":63.4,"d":"63.40"},63.56,62.38]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",39.27,39.49,38.16,38.23,38.13,35.98,36.54,{"v":36.6,"d":"36.60"},36.44,37.62]
["  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-2015Q1","index":2,"n_rows":47,"n_cols":11,"rows_kept":47,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[22,1,22,4],[22,6,22,9],[33,1,33,4],[33,6,33,9],[46,0,46,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 5.0 -- Income Statement  For Corporations in NAICS Retail Trade Subsectors 448 and 452, and\n                               All Other Retail Trade Subsectors, Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"Clothing and General Merchandise Stores\nTotal Assets $50 Million and Over",{"$nulls":4},"All Other Retail Trade\nTotal Assets $50 Million and Over"]
["Item"," 1Q_\n 2014_"," 2Q_\n 2014_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 1Q_\n 2014_"," 2Q_\n 2014_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":208404,"d":"208,404 "},{"v":214234,"d":"214,234 "},{"v":214335,"d":"214,335 "},{"v":250110,"d":"250,110 "},{"v":213711,"d":"213,711 "},{"v":302885,"d":"302,885 "},{"v":327541,"d":"327,541 "},{"v":324023,"d":"324,023 "},{"v":336396,"d":"336,396 "},{"v":312183,"d":"312,183 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":5052,"d":"5,052 "},{"v":5117,"d":"5,117 "},{"v":5196,"d":"5,196 "},{"v":5333,"d":"5,333 "},{"v":5304,"d":"5,304 "},{"v":4849,"d":"4,849 "},{"v":5034,"d":"5,034 "},{"v":5151,"d":"5,151 "},{"v":5284,"d":"5,284 "},{"v":5532,"d":"5,532 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":192672,"d":"192,672 "},{"v":197961,"d":"197,961 "},{"v":198646,"d":"198,646 "},{"v":227514,"d":"227,514 "},{"v":197121,"d":"197,121 "},{"v":284459,"d":"284,459 "},{"v":305195,"d":"305,195 "},{"v":302886,"d":"302,886 "},{"v":313233,"d":"313,233 "},{"v":290008,"d":"290,008 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":10679,"d":"10,679 "},{"v":11156,"d":"11,156 "},{"v":10493,"d":"10,493 "},{"v":17264,"d":"17,264 "},{"v":11286,"d":"11,286 "},{"v":13577,"d":"13,577 "},{"v":17312,"d":"17,312 "},{"v":15986,"d":"15,986 "},{"v":17879,"d":"17,879 "},{"v":16643,"d":"16,643 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1727,"d":"1,727 "},{"v":2084,"d":"2,084 "},{"v":1779,"d":"1,779 "},{"v":1839,"d":"1,839 "},{"v":1887,"d":"1,887 "},{"v":1786,"d":"1,786 "},{"v":1822,"d":"1,822 "},{"v":1899,"d":"1,899 "},{"v":1920,"d":"1,920 "},{"v":1900,"d":"1,900 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1889,"d":"1,889 "},{"v":2303,"d":"2,303 "},{"v":1326,"d":"1,326 "},{"v":-895,"d":"(895)"},{"v":2004,"d":"2,004 "},{"v":-26,"d":"(26)"},{"v":1065,"d":"1,065 "},{"v":-1258,"d":"(1,258)"},{"v":1645,"d":"1,645 "},{"v":1313,"d":"1,313 "}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":10841,"d":"10,841 "},{"v":11375,"d":"11,375 "},{"v":10040,"d":"10,040 "},{"v":14529,"d":"14,529 "},{"v":11404,"d":"11,404 "},{"v":11765,"d":"11,765 "},{"v":16555,"d":"16,555 "},{"v":12829,"d":"12,829 "},{"v":17604,"d":"17,604 "},{"v":16056,"d":"16,056 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":4074,"d":"4,074 "},{"v":4238,"d":"4,238 "},{"v":3579,"d":"3,579 "},{"v":5627,"d":"5,627 "},{"v":3806,"d":"3,806 "},{"v":6590,"d":"6,590 "},{"v":5048,"d":"5,048 "},{"v":4368,"d":"4,368 "},{"v":4917,"d":"4,917 "},{"v":2730,"d":"2,730 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":6768,"d":"6,768 "},{"v":7138,"d":"7,138 "},{"v":6462,"d":"6,462 "},{"v":8902,"d":"8,902 "},{"v":7597,"d":"7,597 "},{"v":5175,"d":"5,175 "},{"v":11507,"d":"11,507 "},{"v":8461,"d":"8,461 "},{"v":12687,"d":"12,687 "},{"v":13326,"d":"13,326 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":7940,"d":"7,940 "},{"v":1653,"d":"1,653 "},{"v":1736,"d":"1,736 "},{"v":1879,"d":"1,879 "},{"v":9330,"d":"9,330 "},{"v":2784,"d":"2,784 "},{"v":3478,"d":"3,478 "},{"v":2527,"d":"2,527 "},{"v":3295,"d":"3,295 "},{"v":3390,"d":"3,390 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-1172,"d":"(1,172)"},{"v":5485,"d":"5,485 "},{"v":4726,"d":"4,726 "},{"v":7023,"d":"7,023 "},{"v":-1732,"d":"(1,732)"},{"v":2391,"d":"2,391 "},{"v":8029,"d":"8,029 "},{"v":5934,"d":"5,934 "},{"v":9393,"d":"9,393 "},{"v":9936,"d":"9,936 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":169202,"d":"169,202 "},{"v":153302,"d":"153,302 "},{"v":158565,"d":"158,565 "},{"v":161447,"d":"161,447 "},{"v":164228,"d":"164,228 "},{"v":187781,"d":"187,781 "},{"v":187369,"d":"187,369 "},{"v":193401,"d":"193,401 "},{"v":197200,"d":"197,200 "},{"v":204354,"d":"204,354 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-13807,"d":"(13,807)"},{"v":-1233,"d":"(1,233)"},{"v":-1267,"d":"(1,267)"},{"v":-1005,"d":"(1,005)"},{"v":-2053,"d":"(2,053)"},{"v":-2099,"d":"(2,099)"},{"v":-1845,"d":"(1,845)"},{"v":-2299,"d":"(2,299)"},{"v":-3387,"d":"(3,387)"},{"v":-2711,"d":"(2,711)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":154223,"d":"154,223 "},{"v":157553,"d":"157,553 "},{"v":162024,"d":"162,024 "},{"v":167465,"d":"167,465 "},{"v":160442,"d":"160,442 "},{"v":188073,"d":"188,073 "},{"v":193553,"d":"193,553 "},{"v":197036,"d":"197,036 "},{"v":203206,"d":"203,206 "},{"v":211579,"d":"211,579 "}]
["                         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.42,2.39,2.42,2.13,2.48,{"v":1.6,"d":"1.60"},1.54,1.59,1.57,1.77]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",92.45,{"v":92.4,"d":"92.40"},92.68,90.97,92.24,93.92,93.18,93.48,93.11,{"v":92.9,"d":"92.90"}]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",5.12,5.21,{"v":4.9,"d":"4.90"},{"v":6.9,"d":"6.90"},5.28,4.48,5.29,4.93,5.31,5.33]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.83,0.97,0.83,0.74,0.88,0.59,0.56,0.59,0.57,0.61]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",0.91,1.08,0.62,{"v":-0.36,"d":"(0.36)"},0.94,{"v":-0.01,"d":"(0.01)"},0.33,{"v":-0.39,"d":"(0.39)"},0.49,0.42]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",{"v":5.2,"d":"5.20"},5.31,4.68,5.81,5.34,3.88,5.05,3.96,5.23,5.14]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.95,1.98,1.67,2.25,1.78,2.18,1.54,1.35,1.46,0.87]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",3.25,3.33,3.01,3.56,3.56,1.71,3.51,2.61,3.77,4.27]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":22.9,"d":"22.90"},23.42,20.54,29.68,24.49,{"v":19,"d":"19.00"},26.44,21.44,28.93,24.92]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",14.29,{"v":14.7,"d":"14.70"},13.22,18.18,16.31,8.36,18.38,14.14,20.85,20.68]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",9.06,9.41,8.02,11.91,9.29,7.57,{"v":10.5,"d":"10.50"},8.11,10.78,9.57]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",5.66,{"v":5.9,"d":"5.90"},5.16,{"v":7.3,"d":"7.30"},6.19,3.33,{"v":7.3,"d":"7.30"},5.35,7.77,7.94]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.22,1.24,1.22,1.33,{"v":1.3,"d":"1.30"},1.29,1.28,1.25,1.32,1.25]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.18,0.18,0.14,0.25,0.21,0.23,0.23,0.21,0.28,0.22]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.47,1.49,1.44,1.53,1.38,1.46,1.46,1.36,1.27,1.34]
["  1 These tables only include estimates for corporations with assets of $50 million and over at the time of sample selection."]

{"sheet":"RET_5_1-2015Q1","index":3,"n_rows":61,"n_cols":11,"rows_kept":61,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[49,1,49,4],[49,6,49,9],[60,0,60,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 5.1 -- Balance Sheet  For Corporations in NAICS Retail Trade Subsectors 448 and 452, and\n                               All Other Retail Trade Subsectors, Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"Clothing and General Merchandise Stores\nTotal Assets $50 Million and Over",{"$nulls":4},"All Other Retail Trade\nTotal Assets $50 Million and Over"]
["Item"," 1Q_\n 2014_"," 2Q_\n 2014_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 1Q_\n 2014_"," 2Q_\n 2014_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":18070,"d":"18,070 "},{"v":18755,"d":"18,755 "},{"v":16408,"d":"16,408 "},{"v":23417,"d":"23,417 "},{"v":21303,"d":"21,303 "},{"v":27885,"d":"27,885 "},{"v":29102,"d":"29,102 "},{"v":28522,"d":"28,522 "},{"v":41872,"d":"41,872 "},{"v":30655,"d":"30,655 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":445,"d":"445 "},{"v":552,"d":"552 "},{"v":716,"d":"716 "},{"v":737,"d":"737 "},{"v":718,"d":"718 "},{"v":1336,"d":"1,336 "},{"v":1540,"d":"1,540 "},{"v":1238,"d":"1,238 "},{"v":1295,"d":"1,295 "},{"v":1134,"d":"1,134 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":18515,"d":"18,515 "},{"v":19306,"d":"19,306 "},{"v":17124,"d":"17,124 "},{"v":24154,"d":"24,154 "},{"v":22021,"d":"22,021 "},{"v":29221,"d":"29,221 "},{"v":30642,"d":"30,642 "},{"v":29759,"d":"29,759 "},{"v":43167,"d":"43,167 "},{"v":31790,"d":"31,790 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5280,"d":"5,280 "},{"v":4747,"d":"4,747 "},{"v":3571,"d":"3,571 "},{"v":7586,"d":"7,586 "},{"v":6220,"d":"6,220 "},{"v":11718,"d":"11,718 "},{"v":11228,"d":"11,228 "},{"v":10733,"d":"10,733 "},{"v":11229,"d":"11,229 "},{"v":11274,"d":"11,274 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":23795,"d":"23,795 "},{"v":24053,"d":"24,053 "},{"v":20695,"d":"20,695 "},{"v":31740,"d":"31,740 "},{"v":28241,"d":"28,241 "},{"v":40939,"d":"40,939 "},{"v":41871,"d":"41,871 "},{"v":40492,"d":"40,492 "},{"v":54396,"d":"54,396 "},{"v":43064,"d":"43,064 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":8065,"d":"8,065 "},{"v":7917,"d":"7,917 "},{"v":8648,"d":"8,648 "},{"v":9167,"d":"9,167 "},{"v":8497,"d":"8,497 "},{"v":44581,"d":"44,581 "},{"v":47505,"d":"47,505 "},{"v":49258,"d":"49,258 "},{"v":51203,"d":"51,203 "},{"v":50233,"d":"50,233 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":112556,"d":"112,556 "},{"v":113176,"d":"113,176 "},{"v":131734,"d":"131,734 "},{"v":112994,"d":"112,994 "},{"v":115324,"d":"115,324 "},{"v":123570,"d":"123,570 "},{"v":124514,"d":"124,514 "},{"v":128967,"d":"128,967 "},{"v":129849,"d":"129,849 "},{"v":132221,"d":"132,221 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":16078,"d":"16,078 "},{"v":16325,"d":"16,325 "},{"v":16827,"d":"16,827 "},{"v":17055,"d":"17,055 "},{"v":24535,"d":"24,535 "},{"v":20925,"d":"20,925 "},{"v":21275,"d":"21,275 "},{"v":21730,"d":"21,730 "},{"v":21471,"d":"21,471 "},{"v":21646,"d":"21,646 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":160494,"d":"160,494 "},{"v":161471,"d":"161,471 "},{"v":177904,"d":"177,904 "},{"v":170957,"d":"170,957 "},{"v":176596,"d":"176,596 "},{"v":230014,"d":"230,014 "},{"v":235165,"d":"235,165 "},{"v":240447,"d":"240,447 "},{"v":256918,"d":"256,918 "},{"v":247165,"d":"247,165 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":305821,"d":"305,821 "},{"v":309317,"d":"309,317 "},{"v":315072,"d":"315,072 "},{"v":316951,"d":"316,951 "},{"v":319552,"d":"319,552 "},{"v":272967,"d":"272,967 "},{"v":278392,"d":"278,392 "},{"v":283632,"d":"283,632 "},{"v":289834,"d":"289,834 "},{"v":295294,"d":"295,294 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":33787,"d":"33,787 "},{"v":34043,"d":"34,043 "},{"v":34280,"d":"34,280 "},{"v":34470,"d":"34,470 "},{"v":34304,"d":"34,304 "},{"v":29960,"d":"29,960 "},{"v":29952,"d":"29,952 "},{"v":30307,"d":"30,307 "},{"v":30435,"d":"30,435 "},{"v":30702,"d":"30,702 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":143484,"d":"143,484 "},{"v":146140,"d":"146,140 "},{"v":150238,"d":"150,238 "},{"v":151903,"d":"151,903 "},{"v":155157,"d":"155,157 "},{"v":139583,"d":"139,583 "},{"v":142884,"d":"142,884 "},{"v":145973,"d":"145,973 "},{"v":148939,"d":"148,939 "},{"v":152570,"d":"152,570 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":196124,"d":"196,124 "},{"v":197220,"d":"197,220 "},{"v":199115,"d":"199,115 "},{"v":199518,"d":"199,518 "},{"v":198699,"d":"198,699 "},{"v":163343,"d":"163,343 "},{"v":165460,"d":"165,460 "},{"v":167967,"d":"167,967 "},{"v":171330,"d":"171,330 "},{"v":173427,"d":"173,427 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":121774,"d":"121,774 "},{"v":125093,"d":"125,093 "},{"v":123590,"d":"123,590 "},{"v":117575,"d":"117,575 "},{"v":115962,"d":"115,962 "},{"v":228520,"d":"228,520 "},{"v":230261,"d":"230,261 "},{"v":224079,"d":"224,079 "},{"v":225081,"d":"225,081 "},{"v":250547,"d":"250,547 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":478393,"d":"478,393 "},{"v":483784,"d":"483,784 "},{"v":500608,"d":"500,608 "},{"v":488049,"d":"488,049 "},{"v":491258,"d":"491,258 "},{"v":621878,"d":"621,878 "},{"v":630886,"d":"630,886 "},{"v":632493,"d":"632,493 "},{"v":653329,"d":"653,329 "},{"v":671138,"d":"671,138 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1609,"d":"1,609 "},{"v":1963,"d":"1,963 "},{"v":2423,"d":"2,423 "},{"v":1858,"d":"1,858 "},{"v":1823,"d":"1,823 "},{"v":13606,"d":"13,606 "},{"v":13742,"d":"13,742 "},{"v":14349,"d":"14,349 "},{"v":16469,"d":"16,469 "},{"v":16008,"d":"16,008 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":5498,"d":"5,498 "},{"v":4602,"d":"4,602 "},{"v":8009,"d":"8,009 "},{"v":2059,"d":"2,059 "},{"v":1864,"d":"1,864 "},{"v":4546,"d":"4,546 "},{"v":5214,"d":"5,214 "},{"v":5041,"d":"5,041 "},{"v":5137,"d":"5,137 "},{"v":5012,"d":"5,012 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":64131,"d":"64,131 "},{"v":64712,"d":"64,712 "},{"v":75272,"d":"75,272 "},{"v":64659,"d":"64,659 "},{"v":64481,"d":"64,481 "},{"v":89466,"d":"89,466 "},{"v":91927,"d":"91,927 "},{"v":96157,"d":"96,157 "},{"v":94634,"d":"94,634 "},{"v":97331,"d":"97,331 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":3293,"d":"3,293 "},{"v":1331,"d":"1,331 "},{"v":989,"d":"989 "},{"v":2322,"d":"2,322 "},{"v":3182,"d":"3,182 "},{"v":5626,"d":"5,626 "},{"v":5543,"d":"5,543 "},{"v":4911,"d":"4,911 "},{"v":5476,"d":"5,476 "},{"v":6303,"d":"6,303 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":448,"d":"448 "},{"v":633,"d":"633 "},{"v":632,"d":"632 "},{"v":460,"d":"460 "},{"v":710,"d":"710 "},{"v":4490,"d":"4,490 "},{"v":5009,"d":"5,009 "},{"v":4430,"d":"4,430 "},{"v":5977,"d":"5,977 "},{"v":4975,"d":"4,975 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5110,"d":"5,110 "},{"v":5585,"d":"5,585 "},{"v":5883,"d":"5,883 "},{"v":5559,"d":"5,559 "},{"v":7818,"d":"7,818 "},{"v":5557,"d":"5,557 "},{"v":7093,"d":"7,093 "},{"v":7517,"d":"7,517 "},{"v":5827,"d":"5,827 "},{"v":7486,"d":"7,486 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":51253,"d":"51,253 "},{"v":51824,"d":"51,824 "},{"v":52285,"d":"52,285 "},{"v":52061,"d":"52,061 "},{"v":56214,"d":"56,214 "},{"v":55298,"d":"55,298 "},{"v":55673,"d":"55,673 "},{"v":59424,"d":"59,424 "},{"v":61786,"d":"61,786 "},{"v":59972,"d":"59,972 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":131342,"d":"131,342 "},{"v":130650,"d":"130,650 "},{"v":145492,"d":"145,492 "},{"v":128978,"d":"128,978 "},{"v":136092,"d":"136,092 "},{"v":178588,"d":"178,588 "},{"v":184201,"d":"184,201 "},{"v":191830,"d":"191,830 "},{"v":195307,"d":"195,307 "},{"v":197088,"d":"197,088 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":13481,"d":"13,481 "},{"v":13672,"d":"13,672 "},{"v":14958,"d":"14,958 "},{"v":14150,"d":"14,150 "},{"v":18820,"d":"18,820 "},{"v":49797,"d":"49,797 "},{"v":48417,"d":"48,417 "},{"v":47798,"d":"47,798 "},{"v":48910,"d":"48,910 "},{"v":48760,"d":"48,760 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":103134,"d":"103,134 "},{"v":103745,"d":"103,745 "},{"v":103389,"d":"103,389 "},{"v":103590,"d":"103,590 "},{"v":103945,"d":"103,945 "},{"v":91308,"d":"91,308 "},{"v":92189,"d":"92,189 "},{"v":96182,"d":"96,182 "},{"v":109201,"d":"109,201 "},{"v":109710,"d":"109,710 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":41039,"d":"41,039 "},{"v":41460,"d":"41,460 "},{"v":41269,"d":"41,269 "},{"v":45498,"d":"45,498 "},{"v":46129,"d":"46,129 "},{"v":54452,"d":"54,452 "},{"v":55594,"d":"55,594 "},{"v":57377,"d":"57,377 "},{"v":56549,"d":"56,549 "},{"v":57834,"d":"57,834 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":288997,"d":"288,997 "},{"v":289527,"d":"289,527 "},{"v":305109,"d":"305,109 "},{"v":292216,"d":"292,216 "},{"v":304986,"d":"304,986 "},{"v":374145,"d":"374,145 "},{"v":380401,"d":"380,401 "},{"v":393188,"d":"393,188 "},{"v":409967,"d":"409,967 "},{"v":413391,"d":"413,391 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":35173,"d":"35,173 "},{"v":36703,"d":"36,703 "},{"v":33476,"d":"33,476 "},{"v":28368,"d":"28,368 "},{"v":25829,"d":"25,829 "},{"v":59660,"d":"59,660 "},{"v":56932,"d":"56,932 "},{"v":42268,"d":"42,268 "},{"v":40156,"d":"40,156 "},{"v":46168,"d":"46,168 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":154223,"d":"154,223 "},{"v":157553,"d":"157,553 "},{"v":162024,"d":"162,024 "},{"v":167465,"d":"167,465 "},{"v":160442,"d":"160,442 "},{"v":188073,"d":"188,073 "},{"v":193553,"d":"193,553 "},{"v":197036,"d":"197,036 "},{"v":203206,"d":"203,206 "},{"v":211579,"d":"211,579 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":189396,"d":"189,396 "},{"v":194256,"d":"194,256 "},{"v":195499,"d":"195,499 "},{"v":195833,"d":"195,833 "},{"v":186271,"d":"186,271 "},{"v":247733,"d":"247,733 "},{"v":250485,"d":"250,485 "},{"v":239305,"d":"239,305 "},{"v":243362,"d":"243,362 "},{"v":257747,"d":"257,747 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":478393,"d":"478,393 "},{"v":483784,"d":"483,784 "},{"v":500608,"d":"500,608 "},{"v":488049,"d":"488,049 "},{"v":491258,"d":"491,258 "},{"v":621878,"d":"621,878 "},{"v":630886,"d":"630,886 "},{"v":632493,"d":"632,493 "},{"v":653329,"d":"653,329 "},{"v":671138,"d":"671,138 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":29152,"d":"29,152 "},{"v":30821,"d":"30,821 "},{"v":32411,"d":"32,411 "},{"v":41979,"d":"41,979 "},{"v":40505,"d":"40,505 "},{"v":51426,"d":"51,426 "},{"v":50964,"d":"50,964 "},{"v":48616,"d":"48,616 "},{"v":61611,"d":"61,611 "},{"v":50076,"d":"50,076 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",4.97,4.97,4.13,{"v":6.5,"d":"6.50"},5.75,6.58,6.64,{"v":6.4,"d":"6.40"},8.33,6.42]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",1.69,1.64,1.73,1.88,1.73,7.17,7.53,7.79,7.84,7.48]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",23.53,23.39,26.31,23.15,23.48,19.87,19.74,20.39,19.87,{"v":19.7,"d":"19.70"}]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",33.55,33.38,35.54,35.03,35.95,36.99,37.28,38.02,39.32,36.83]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":41,"d":"41.00"},40.77,39.77,40.88,40.45,26.27,26.23,26.56,26.22,25.84]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",2.65,2.64,3.39,2.04,2.49,4.53,4.92,4.95,5.11,4.99]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",27.45,27.01,29.06,26.43,{"v":27.7,"d":"27.70"},28.72,{"v":29.2,"d":"29.20"},30.33,29.89,29.37]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",24.38,24.27,23.64,24.12,24.99,22.69,22.29,22.76,{"v":24.2,"d":"24.20"},23.61]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",60.41,59.85,60.95,59.87,62.08,60.16,{"v":60.3,"d":"60.30"},62.16,62.75,{"v":61.6,"d":"61.60"}]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",39.59,40.15,39.05,40.13,37.92,39.84,{"v":39.7,"d":"39.70"},37.84,37.25,{"v":38.4,"d":"38.40"}]
["  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-2015Q1","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"]
["2004 …………………………………………………………………………………………...………………………………………………..",{"v":407093,"d":"407,093 "},{"v":410459,"d":"410,459 "},{"v":421545,"d":"421,545 "},{"v":427461,"d":"427,461 "}]
["2005 …………………………………………………………………………………………...………………………………………………..",{"v":438316,"d":"438,316 "},{"v":447476,"d":"447,476 "},{"v":458378,"d":"458,378 "},{"v":468000,"d":"468,000 "}]
["2006 …………………………………………………………………………………………...………………………………………………..",{"v":480443,"d":"480,443 "},{"v":492804,"d":"492,804 "},{"v":497492,"d":"497,492 "},{"v":502104,"d":"502,104 "}]
["2007 …………………………………………………………………………………………...………………………………………………..",{"v":509961,"d":"509,961 "},{"v":514677,"d":"514,677 "},{"v":515872,"d":"515,872 "},{"v":521205,"d":"521,205 "}]
["2008 …………………………………………………………………………………………...………………………………………………..",{"v":523425,"d":"523,425 "},{"v":536244,"d":"536,244 "},{"v":531327,"d":"531,327 "},{"v":501140,"d":"501,140 "}]
["2009 …………………………………………………………………………………………...………………………………………………..",{"v":495948,"d":"495,948 "},{"v":495104,"d":"495,104 "},{"v":508409,"d":"508,409 "},{"v":519961,"d":"519,961 "}]
["2010 …………………………………………………………………………………………...………………………………………………..",{"v":532395,"d":"532,395 "},{"v":534627,"d":"534,627 "},{"v":539520,"d":"539,520 "},{"v":550732,"d":"550,732 "}]
["2011 …………………………………………………………………………………………...………………………………………………..",{"v":567637,"d":"567,637 "},{"v":585130,"d":"585,130 "},{"v":585928,"d":"585,928 "},{"v":586134,"d":"586,134 "}]
["2012 …………………………………………………………………………………………...………………………………………………..",{"v":603914,"d":"603,914 "},{"v":598085,"d":"598,085 "},{"v":602887,"d":"602,887 "},{"v":610969,"d":"610,969 "}]
["2013 …………………………………………………………………………………………...………………………………………………..",{"v":619397,"d":"619,397 "},{"v":627104,"d":"627,104 "},{"v":635852,"d":"635,852 "},{"v":641942,"d":"641,942 "}]
["2014 …………………………………………………………………………………………...………………………………………………..",{"v":641459,"d":"641,459 "},{"v":661500,"d":"661,500 "},{"v":667270,"d":"667,270 "},{"v":669158,"d":"669,158 "}]
["2015 …………………………………………………………………………………………...………………………………………………..",{"v":654580,"d":"654,580 "}]
[]
["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."]