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

{"sheet":"RET_4_0-2015Q2","index":0,"n_rows":47,"n_cols":11,"rows_kept":47,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[22,1,22,4],[22,6,22,9],[33,1,33,4],[33,6,33,9],[46,0,46,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 4.0 -- Income Statement  For Corporations in NAICS Retail Trade Sector, and Retail Trade Subsector 445,\n                              Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"All Retail Trade\nTotal Assets $50 Million and Over",{"$nulls":4},"Food and Beverage Stores\nTotal Assets $50 Million and Over"]
["Item"," 2Q_\n 2014_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 2Q_\n 2015_"," 2Q_\n 2014_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 2Q_\n 2015_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":655373,"d":"655,373 "},{"v":651897,"d":"651,897 "},{"v":701773,"d":"701,773 "},{"v":637473,"d":"637,473 "},{"v":669959,"d":"669,959 "},{"v":115969,"d":"115,969 "},{"v":115844,"d":"115,844 "},{"v":116647,"d":"116,647 "},{"v":115228,"d":"115,228 "},{"v":114216,"d":"114,216 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":12511,"d":"12,511 "},{"v":12726,"d":"12,726 "},{"v":13029,"d":"13,029 "},{"v":13311,"d":"13,311 "},{"v":13242,"d":"13,242 "},{"v":2388,"d":"2,388 "},{"v":2408,"d":"2,408 "},{"v":2431,"d":"2,431 "},{"v":2541,"d":"2,541 "},{"v":2361,"d":"2,361 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":611116,"d":"611,116 "},{"v":609718,"d":"609,718 "},{"v":650027,"d":"650,027 "},{"v":592683,"d":"592,683 "},{"v":622859,"d":"622,859 "},{"v":110198,"d":"110,198 "},{"v":110347,"d":"110,347 "},{"v":110605,"d":"110,605 "},{"v":108741,"d":"108,741 "},{"v":108144,"d":"108,144 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":31746,"d":"31,746 "},{"v":29453,"d":"29,453 "},{"v":38717,"d":"38,717 "},{"v":31479,"d":"31,479 "},{"v":33858,"d":"33,858 "},{"v":3383,"d":"3,383 "},{"v":3089,"d":"3,089 "},{"v":3610,"d":"3,610 "},{"v":3945,"d":"3,945 "},{"v":3711,"d":"3,711 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4590,"d":"4,590 "},{"v":4326,"d":"4,326 "},{"v":4396,"d":"4,396 "},{"v":4618,"d":"4,618 "},{"v":5156,"d":"5,156 "},{"v":678,"d":"678 "},{"v":658,"d":"658 "},{"v":641,"d":"641 "},{"v":705,"d":"705 "},{"v":752,"d":"752 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":3573,"d":"3,573 "},{"v":-119,"d":"(119)"},{"v":606,"d":"606 "},{"v":2965,"d":"2,965 "},{"v":4016,"d":"4,016 "},{"v":198,"d":"198 "},{"v":-189,"d":"(189)"},{"v":-38,"d":"(38)"},{"v":141,"d":"141 "},{"v":126,"d":"126 "}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":30729,"d":"30,729 "},{"v":25007,"d":"25,007 "},{"v":34927,"d":"34,927 "},{"v":29826,"d":"29,826 "},{"v":32718,"d":"32,718 "},{"v":2904,"d":"2,904 "},{"v":2242,"d":"2,242 "},{"v":2931,"d":"2,931 "},{"v":3382,"d":"3,382 "},{"v":3085,"d":"3,085 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":10232,"d":"10,232 "},{"v":8762,"d":"8,762 "},{"v":11441,"d":"11,441 "},{"v":7630,"d":"7,630 "},{"v":10668,"d":"10,668 "},{"v":979,"d":"979 "},{"v":846,"d":"846 "},{"v":952,"d":"952 "},{"v":1239,"d":"1,239 "},{"v":1057,"d":"1,057 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":20497,"d":"20,497 "},{"v":16246,"d":"16,246 "},{"v":23486,"d":"23,486 "},{"v":22196,"d":"22,196 "},{"v":22050,"d":"22,050 "},{"v":1924,"d":"1,924 "},{"v":1396,"d":"1,396 "},{"v":1979,"d":"1,979 "},{"v":2143,"d":"2,143 "},{"v":2028,"d":"2,028 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":5870,"d":"5,870 "},{"v":4932,"d":"4,932 "},{"v":5535,"d":"5,535 "},{"v":13400,"d":"13,400 "},{"v":6217,"d":"6,217 "},{"v":756,"d":"756 "},{"v":649,"d":"649 "},{"v":704,"d":"704 "},{"v":1092,"d":"1,092 "},{"v":307,"d":"307 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":14627,"d":"14,627 "},{"v":11313,"d":"11,313 "},{"v":17950,"d":"17,950 "},{"v":8796,"d":"8,796 "},{"v":15833,"d":"15,833 "},{"v":1169,"d":"1,169 "},{"v":748,"d":"748 "},{"v":1275,"d":"1,275 "},{"v":1050,"d":"1,050 "},{"v":1721,"d":"1,721 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":380524,"d":"380,524 "},{"v":392691,"d":"392,691 "},{"v":400036,"d":"400,036 "},{"v":407967,"d":"407,967 "},{"v":405850,"d":"405,850 "},{"v":41337,"d":"41,337 "},{"v":42263,"d":"42,263 "},{"v":42565,"d":"42,565 "},{"v":42854,"d":"42,854 "},{"v":39149,"d":"39,149 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-3425,"d":"(3,425)"},{"v":-3677,"d":"(3,677)"},{"v":-5011,"d":"(5,011)"},{"v":-5018,"d":"(5,018)"},{"v":-6248,"d":"(6,248)"},{"v":-347,"d":"(347)"},{"v":-112,"d":"(112)"},{"v":-620,"d":"(620)"},{"v":-58,"d":"(58)"},{"v":-414,"d":"(414)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":391725,"d":"391,725 "},{"v":400327,"d":"400,327 "},{"v":412976,"d":"412,976 "},{"v":411746,"d":"411,746 "},{"v":415434,"d":"415,434 "},{"v":42159,"d":"42,159 "},{"v":42899,"d":"42,899 "},{"v":43219,"d":"43,219 "},{"v":43846,"d":"43,846 "},{"v":40456,"d":"40,456 "}]
["                         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.95,1.86,2.09,1.98,2.06,2.08,2.08,2.21,2.07]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",93.25,93.53,92.63,92.97,92.97,95.02,95.25,94.82,94.37,94.68]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",4.84,4.52,5.52,4.94,5.05,2.92,2.67,{"v":3.1,"d":"3.10"},3.42,3.25]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":0.7,"d":"0.70"},0.66,0.63,0.72,0.77,0.58,0.57,0.55,0.61,0.66]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",0.55,{"v":-0.02,"d":"(0.02)"},0.09,0.47,{"v":0.6,"d":"0.60"},0.17,{"v":-0.16,"d":"(0.16)"},{"v":-0.03,"d":"(0.03)"},0.12,0.11]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",4.69,3.84,4.98,4.68,4.88,{"v":2.5,"d":"2.50"},1.94,2.51,2.93,{"v":2.7,"d":"2.70"}]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.56,1.34,1.63,{"v":1.2,"d":"1.20"},1.59,0.84,0.73,0.82,1.08,0.93]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",3.13,2.49,3.35,3.48,3.29,1.66,1.21,{"v":1.7,"d":"1.70"},1.86,1.78]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":24.6,"d":"24.60"},{"v":20.4,"d":"20.40"},28.09,23.68,{"v":26.3,"d":"26.30"},20.56,{"v":15.7,"d":"15.70"},20.17,{"v":22.8,"d":"22.80"},22.07]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",16.41,13.25,18.89,17.62,17.72,13.62,9.78,13.62,14.44,14.51]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",9.71,7.78,10.76,8.99,9.76,7.54,5.77,7.38,8.53,7.51]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",6.48,5.06,7.24,6.69,6.58,4.99,3.59,4.98,{"v":5.4,"d":"5.40"},4.94]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.26,1.24,1.31,1.26,1.24,1.25,1.23,1.25,1.23,1.22]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.23,{"v":0.2,"d":"0.20"},0.28,0.23,0.23,0.38,0.35,0.38,0.37,0.35]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.46,{"v":1.4,"d":"1.40"},1.38,1.35,1.29,{"v":1.4,"d":"1.40"},1.44,1.43,1.53,1.28]
["  1 These tables only include estimates for corporations with assets of $50 million and over at the time of sample selection."]

{"sheet":"RET_4_1-2015Q2","index":1,"n_rows":61,"n_cols":11,"rows_kept":61,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[49,1,49,4],[49,6,49,9],[60,0,60,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 4.1 -- Balance Sheet  For Corporations in NAICS Retail Trade Sector, and Retail Trade Subsector 445,\n                               Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"All Retail Trade\nTotal Assets $50 Million and Over",{"$nulls":4},"Food and Beverage Stores\nTotal Assets $50 Million and Over"]
["Item"," 2Q_\n 2014_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 2Q_\n 2015_"," 2Q_\n 2014_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 2Q_\n 2015_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":59043,"d":"59,043 "},{"v":56333,"d":"56,333 "},{"v":77720,"d":"77,720 "},{"v":64436,"d":"64,436 "},{"v":65357,"d":"65,357 "},{"v":11515,"d":"11,515 "},{"v":11646,"d":"11,646 "},{"v":12726,"d":"12,726 "},{"v":12348,"d":"12,348 "},{"v":12721,"d":"12,721 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":4012,"d":"4,012 "},{"v":2956,"d":"2,956 "},{"v":3044,"d":"3,044 "},{"v":2523,"d":"2,523 "},{"v":2273,"d":"2,273 "},{"v":2011,"d":"2,011 "},{"v":1110,"d":"1,110 "},{"v":1093,"d":"1,093 "},{"v":840,"d":"840 "},{"v":335,"d":"335 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":63055,"d":"63,055 "},{"v":59290,"d":"59,290 "},{"v":80764,"d":"80,764 "},{"v":66959,"d":"66,959 "},{"v":67630,"d":"67,630 "},{"v":13526,"d":"13,526 "},{"v":12756,"d":"12,756 "},{"v":13818,"d":"13,818 "},{"v":13188,"d":"13,188 "},{"v":13056,"d":"13,056 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":18006,"d":"18,006 "},{"v":16400,"d":"16,400 "},{"v":20864,"d":"20,864 "},{"v":19729,"d":"19,729 "},{"v":18398,"d":"18,398 "},{"v":1960,"d":"1,960 "},{"v":1973,"d":"1,973 "},{"v":2161,"d":"2,161 "},{"v":2179,"d":"2,179 "},{"v":2138,"d":"2,138 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":81061,"d":"81,061 "},{"v":75689,"d":"75,689 "},{"v":101628,"d":"101,628 "},{"v":86688,"d":"86,688 "},{"v":86028,"d":"86,028 "},{"v":15486,"d":"15,486 "},{"v":14730,"d":"14,730 "},{"v":15979,"d":"15,979 "},{"v":15367,"d":"15,367 "},{"v":15194,"d":"15,194 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":60920,"d":"60,920 "},{"v":63354,"d":"63,354 "},{"v":66046,"d":"66,046 "},{"v":63919,"d":"63,919 "},{"v":66868,"d":"66,868 "},{"v":5727,"d":"5,727 "},{"v":5713,"d":"5,713 "},{"v":5884,"d":"5,884 "},{"v":5683,"d":"5,683 "},{"v":6094,"d":"6,094 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":261967,"d":"261,967 "},{"v":285797,"d":"285,797 "},{"v":268350,"d":"268,350 "},{"v":271944,"d":"271,944 "},{"v":275767,"d":"275,767 "},{"v":24890,"d":"24,890 "},{"v":25935,"d":"25,935 "},{"v":25882,"d":"25,882 "},{"v":25328,"d":"25,328 "},{"v":26476,"d":"26,476 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":41533,"d":"41,533 "},{"v":42607,"d":"42,607 "},{"v":42846,"d":"42,846 "},{"v":50061,"d":"50,061 "},{"v":43954,"d":"43,954 "},{"v":4416,"d":"4,416 "},{"v":4605,"d":"4,605 "},{"v":4700,"d":"4,700 "},{"v":4327,"d":"4,327 "},{"v":4536,"d":"4,536 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":445482,"d":"445,482 "},{"v":467448,"d":"467,448 "},{"v":478869,"d":"478,869 "},{"v":472613,"d":"472,613 "},{"v":472616,"d":"472,616 "},{"v":50519,"d":"50,519 "},{"v":50982,"d":"50,982 "},{"v":52445,"d":"52,445 "},{"v":50706,"d":"50,706 "},{"v":52300,"d":"52,300 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":726495,"d":"726,495 "},{"v":739515,"d":"739,515 "},{"v":750284,"d":"750,284 "},{"v":759092,"d":"759,092 "},{"v":749734,"d":"749,734 "},{"v":140568,"d":"140,568 "},{"v":142634,"d":"142,634 "},{"v":145589,"d":"145,589 "},{"v":147346,"d":"147,346 "},{"v":133040,"d":"133,040 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":75216,"d":"75,216 "},{"v":76127,"d":"76,127 "},{"v":76510,"d":"76,510 "},{"v":77180,"d":"77,180 "},{"v":77096,"d":"77,096 "},{"v":11229,"d":"11,229 "},{"v":11545,"d":"11,545 "},{"v":11675,"d":"11,675 "},{"v":11884,"d":"11,884 "},{"v":12228,"d":"12,228 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":363497,"d":"363,497 "},{"v":371897,"d":"371,897 "},{"v":378134,"d":"378,134 "},{"v":385911,"d":"385,911 "},{"v":378183,"d":"378,183 "},{"v":74888,"d":"74,888 "},{"v":76129,"d":"76,129 "},{"v":77973,"d":"77,973 "},{"v":79242,"d":"79,242 "},{"v":67207,"d":"67,207 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":438214,"d":"438,214 "},{"v":443745,"d":"443,745 "},{"v":448660,"d":"448,660 "},{"v":450361,"d":"450,361 "},{"v":448647,"d":"448,647 "},{"v":76909,"d":"76,909 "},{"v":78050,"d":"78,050 "},{"v":79291,"d":"79,291 "},{"v":79988,"d":"79,988 "},{"v":78061,"d":"78,061 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":381900,"d":"381,900 "},{"v":374018,"d":"374,018 "},{"v":370540,"d":"370,540 "},{"v":404253,"d":"404,253 "},{"v":419583,"d":"419,583 "},{"v":26697,"d":"26,697 "},{"v":26496,"d":"26,496 "},{"v":27103,"d":"27,103 "},{"v":27890,"d":"27,890 "},{"v":33859,"d":"33,859 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1265596,"d":"1,265,596 "},{"v":1285211,"d":"1,285,211 "},{"v":1298069,"d":"1,298,069 "},{"v":1327227,"d":"1,327,227 "},{"v":1340846,"d":"1,340,846 "},{"v":154126,"d":"154,126 "},{"v":155529,"d":"155,529 "},{"v":158839,"d":"158,839 "},{"v":158584,"d":"158,584 "},{"v":164220,"d":"164,220 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":16116,"d":"16,116 "},{"v":16870,"d":"16,870 "},{"v":18919,"d":"18,919 "},{"v":18205,"d":"18,205 "},{"v":19652,"d":"19,652 "},{"v":409,"d":"409 "},{"v":399,"d":"399 "},{"v":376,"d":"376 "},{"v":468,"d":"468 "},{"v":409,"d":"409 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":10176,"d":"10,176 "},{"v":14130,"d":"14,130 "},{"v":8279,"d":"8,279 "},{"v":8846,"d":"8,846 "},{"v":10449,"d":"10,449 "},{"v":363,"d":"363 "},{"v":1084,"d":"1,084 "},{"v":1106,"d":"1,106 "},{"v":1144,"d":"1,144 "},{"v":1287,"d":"1,287 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":177136,"d":"177,136 "},{"v":192550,"d":"192,550 "},{"v":181132,"d":"181,132 "},{"v":183079,"d":"183,079 "},{"v":185187,"d":"185,187 "},{"v":21108,"d":"21,108 "},{"v":21692,"d":"21,692 "},{"v":22255,"d":"22,255 "},{"v":22019,"d":"22,019 "},{"v":22041,"d":"22,041 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":7481,"d":"7,481 "},{"v":6200,"d":"6,200 "},{"v":8233,"d":"8,233 "},{"v":10017,"d":"10,017 "},{"v":7722,"d":"7,722 "},{"v":624,"d":"624 "},{"v":327,"d":"327 "},{"v":416,"d":"416 "},{"v":662,"d":"662 "},{"v":337,"d":"337 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":6444,"d":"6,444 "},{"v":5973,"d":"5,973 "},{"v":7322,"d":"7,322 "},{"v":6396,"d":"6,396 "},{"v":6252,"d":"6,252 "},{"v":853,"d":"853 "},{"v":953,"d":"953 "},{"v":1123,"d":"1,123 "},{"v":808,"d":"808 "},{"v":799,"d":"799 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":14929,"d":"14,929 "},{"v":15038,"d":"15,038 "},{"v":12443,"d":"12,443 "},{"v":15918,"d":"15,918 "},{"v":18536,"d":"18,536 "},{"v":2293,"d":"2,293 "},{"v":1519,"d":"1,519 "},{"v":1057,"d":"1,057 "},{"v":640,"d":"640 "},{"v":1298,"d":"1,298 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":121760,"d":"121,760 "},{"v":126843,"d":"126,843 "},{"v":128966,"d":"128,966 "},{"v":132630,"d":"132,630 "},{"v":132314,"d":"132,314 "},{"v":14685,"d":"14,685 "},{"v":15625,"d":"15,625 "},{"v":15493,"d":"15,493 "},{"v":15507,"d":"15,507 "},{"v":16662,"d":"16,662 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":354041,"d":"354,041 "},{"v":377605,"d":"377,605 "},{"v":365294,"d":"365,294 "},{"v":375091,"d":"375,091 "},{"v":380112,"d":"380,112 "},{"v":40334,"d":"40,334 "},{"v":41599,"d":"41,599 "},{"v":41827,"d":"41,827 "},{"v":41248,"d":"41,248 "},{"v":42834,"d":"42,834 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":70381,"d":"70,381 "},{"v":71378,"d":"71,378 "},{"v":72177,"d":"72,177 "},{"v":83006,"d":"83,006 "},{"v":93552,"d":"93,552 "},{"v":9209,"d":"9,209 "},{"v":9509,"d":"9,509 "},{"v":9618,"d":"9,618 "},{"v":9557,"d":"9,557 "},{"v":14653,"d":"14,653 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":223750,"d":"223,750 "},{"v":226259,"d":"226,259 "},{"v":241202,"d":"241,202 "},{"v":239551,"d":"239,551 "},{"v":238577,"d":"238,577 "},{"v":27135,"d":"27,135 "},{"v":26156,"d":"26,156 "},{"v":27345,"d":"27,345 "},{"v":26085,"d":"26,085 "},{"v":25344,"d":"25,344 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":117755,"d":"117,755 "},{"v":119658,"d":"119,658 "},{"v":122024,"d":"122,024 "},{"v":125714,"d":"125,714 "},{"v":131006,"d":"131,006 "},{"v":20946,"d":"20,946 "},{"v":21147,"d":"21,147 "},{"v":21918,"d":"21,918 "},{"v":22356,"d":"22,356 "},{"v":25471,"d":"25,471 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":765927,"d":"765,927 "},{"v":794900,"d":"794,900 "},{"v":800697,"d":"800,697 "},{"v":823362,"d":"823,362 "},{"v":843247,"d":"843,247 "},{"v":97624,"d":"97,624 "},{"v":98412,"d":"98,412 "},{"v":100708,"d":"100,708 "},{"v":99247,"d":"99,247 "},{"v":108302,"d":"108,302 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":107943,"d":"107,943 "},{"v":89984,"d":"89,984 "},{"v":84396,"d":"84,396 "},{"v":92119,"d":"92,119 "},{"v":82164,"d":"82,164 "},{"v":14343,"d":"14,343 "},{"v":14217,"d":"14,217 "},{"v":14912,"d":"14,912 "},{"v":15491,"d":"15,491 "},{"v":15462,"d":"15,462 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":391725,"d":"391,725 "},{"v":400327,"d":"400,327 "},{"v":412976,"d":"412,976 "},{"v":411746,"d":"411,746 "},{"v":415434,"d":"415,434 "},{"v":42159,"d":"42,159 "},{"v":42899,"d":"42,899 "},{"v":43219,"d":"43,219 "},{"v":43846,"d":"43,846 "},{"v":40456,"d":"40,456 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":499668,"d":"499,668 "},{"v":490310,"d":"490,310 "},{"v":497372,"d":"497,372 "},{"v":503865,"d":"503,865 "},{"v":497599,"d":"497,599 "},{"v":56501,"d":"56,501 "},{"v":57116,"d":"57,116 "},{"v":58132,"d":"58,132 "},{"v":59337,"d":"59,337 "},{"v":55918,"d":"55,918 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1265596,"d":"1,265,596 "},{"v":1285211,"d":"1,285,211 "},{"v":1298069,"d":"1,298,069 "},{"v":1327227,"d":"1,327,227 "},{"v":1340846,"d":"1,340,846 "},{"v":154126,"d":"154,126 "},{"v":155529,"d":"155,529 "},{"v":158839,"d":"158,839 "},{"v":158584,"d":"158,584 "},{"v":164220,"d":"164,220 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":91440,"d":"91,440 "},{"v":89843,"d":"89,843 "},{"v":113575,"d":"113,575 "},{"v":97522,"d":"97,522 "},{"v":92504,"d":"92,504 "},{"v":10185,"d":"10,185 "},{"v":9383,"d":"9,383 "},{"v":10619,"d":"10,619 "},{"v":9457,"d":"9,457 "},{"v":9466,"d":"9,466 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",{"v":6.4,"d":"6.40"},5.89,7.83,6.53,6.42,10.05,9.47,10.06,9.69,9.25]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",4.81,4.93,5.09,4.82,4.99,3.72,3.67,{"v":3.7,"d":"3.70"},3.58,3.71]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":20.7,"d":"20.70"},22.24,20.67,20.49,20.57,16.15,16.68,16.29,15.97,16.12]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":35.2,"d":"35.20"},36.37,36.89,35.61,35.25,32.78,32.78,33.02,31.97,31.85]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",34.63,34.53,34.56,33.93,33.46,{"v":49.9,"d":"49.90"},50.18,49.92,50.44,47.53]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",3.77,4.05,3.62,3.72,4.09,2.54,2.54,2.31,1.93,2.31]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",27.97,29.38,28.14,28.26,28.35,26.17,26.75,26.33,26.01,26.08]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",23.24,23.16,24.14,{"v":24.3,"d":"24.30"},24.77,23.58,22.93,23.27,22.48,24.36]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",60.52,61.85,61.68,62.04,62.89,63.34,63.28,{"v":63.4,"d":"63.40"},62.58,65.95]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",39.48,38.15,38.32,37.96,37.11,36.66,36.72,{"v":36.6,"d":"36.60"},37.42,34.05]
["  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-2015Q2","index":2,"n_rows":47,"n_cols":11,"rows_kept":47,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[22,1,22,4],[22,6,22,9],[33,1,33,4],[33,6,33,9],[46,0,46,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 5.0 -- Income Statement  For Corporations in NAICS Retail Trade Subsectors 448 and 452, and\n                               All Other Retail Trade Subsectors, Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"Clothing and General Merchandise Stores\nTotal Assets $50 Million and Over",{"$nulls":4},"All Other Retail Trade\nTotal Assets $50 Million and Over"]
["Item"," 2Q_\n 2014_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 2Q_\n 2015_"," 2Q_\n 2014_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 2Q_\n 2015_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":214234,"d":"214,234 "},{"v":214335,"d":"214,335 "},{"v":250420,"d":"250,420 "},{"v":213509,"d":"213,509 "},{"v":219982,"d":"219,982 "},{"v":325170,"d":"325,170 "},{"v":321718,"d":"321,718 "},{"v":334705,"d":"334,705 "},{"v":308736,"d":"308,736 "},{"v":335761,"d":"335,761 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":5117,"d":"5,117 "},{"v":5196,"d":"5,196 "},{"v":5344,"d":"5,344 "},{"v":5284,"d":"5,284 "},{"v":5329,"d":"5,329 "},{"v":5006,"d":"5,006 "},{"v":5122,"d":"5,122 "},{"v":5254,"d":"5,254 "},{"v":5486,"d":"5,486 "},{"v":5552,"d":"5,552 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":197961,"d":"197,961 "},{"v":198646,"d":"198,646 "},{"v":227682,"d":"227,682 "},{"v":196845,"d":"196,845 "},{"v":203047,"d":"203,047 "},{"v":302957,"d":"302,957 "},{"v":300725,"d":"300,725 "},{"v":311740,"d":"311,740 "},{"v":287097,"d":"287,097 "},{"v":311668,"d":"311,668 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":11156,"d":"11,156 "},{"v":10493,"d":"10,493 "},{"v":17395,"d":"17,395 "},{"v":11380,"d":"11,380 "},{"v":11606,"d":"11,606 "},{"v":17207,"d":"17,207 "},{"v":15871,"d":"15,871 "},{"v":17712,"d":"17,712 "},{"v":16153,"d":"16,153 "},{"v":18541,"d":"18,541 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":2084,"d":"2,084 "},{"v":1779,"d":"1,779 "},{"v":1837,"d":"1,837 "},{"v":1911,"d":"1,911 "},{"v":2152,"d":"2,152 "},{"v":1829,"d":"1,829 "},{"v":1889,"d":"1,889 "},{"v":1917,"d":"1,917 "},{"v":2003,"d":"2,003 "},{"v":2252,"d":"2,252 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":2303,"d":"2,303 "},{"v":1326,"d":"1,326 "},{"v":-885,"d":"(885)"},{"v":1987,"d":"1,987 "},{"v":2624,"d":"2,624 "},{"v":1071,"d":"1,071 "},{"v":-1257,"d":"(1,257)"},{"v":1529,"d":"1,529 "},{"v":837,"d":"837 "},{"v":1265,"d":"1,265 "}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":11375,"d":"11,375 "},{"v":10040,"d":"10,040 "},{"v":14672,"d":"14,672 "},{"v":11456,"d":"11,456 "},{"v":12078,"d":"12,078 "},{"v":16450,"d":"16,450 "},{"v":12725,"d":"12,725 "},{"v":17324,"d":"17,324 "},{"v":14988,"d":"14,988 "},{"v":17555,"d":"17,555 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":4238,"d":"4,238 "},{"v":3579,"d":"3,579 "},{"v":5606,"d":"5,606 "},{"v":3844,"d":"3,844 "},{"v":3981,"d":"3,981 "},{"v":5015,"d":"5,015 "},{"v":4337,"d":"4,337 "},{"v":4883,"d":"4,883 "},{"v":2546,"d":"2,546 "},{"v":5630,"d":"5,630 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":7138,"d":"7,138 "},{"v":6462,"d":"6,462 "},{"v":9066,"d":"9,066 "},{"v":7612,"d":"7,612 "},{"v":8096,"d":"8,096 "},{"v":11435,"d":"11,435 "},{"v":8387,"d":"8,387 "},{"v":12441,"d":"12,441 "},{"v":12441,"d":"12,441 "},{"v":11925,"d":"11,925 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":1653,"d":"1,653 "},{"v":1773,"d":"1,773 "},{"v":1790,"d":"1,790 "},{"v":8974,"d":"8,974 "},{"v":1965,"d":"1,965 "},{"v":3462,"d":"3,462 "},{"v":2510,"d":"2,510 "},{"v":3041,"d":"3,041 "},{"v":3333,"d":"3,333 "},{"v":3945,"d":"3,945 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5485,"d":"5,485 "},{"v":4689,"d":"4,689 "},{"v":7276,"d":"7,276 "},{"v":-1362,"d":"(1,362)"},{"v":6131,"d":"6,131 "},{"v":7973,"d":"7,973 "},{"v":5877,"d":"5,877 "},{"v":9400,"d":"9,400 "},{"v":9108,"d":"9,108 "},{"v":7980,"d":"7,980 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":153203,"d":"153,203 "},{"v":158466,"d":"158,466 "},{"v":161771,"d":"161,771 "},{"v":164663,"d":"164,663 "},{"v":160219,"d":"160,219 "},{"v":185984,"d":"185,984 "},{"v":191962,"d":"191,962 "},{"v":195701,"d":"195,701 "},{"v":200451,"d":"200,451 "},{"v":206482,"d":"206,482 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-1233,"d":"(1,233)"},{"v":-1267,"d":"(1,267)"},{"v":-1004,"d":"(1,004)"},{"v":-2332,"d":"(2,332)"},{"v":-3107,"d":"(3,107)"},{"v":-1845,"d":"(1,845)"},{"v":-2299,"d":"(2,299)"},{"v":-3386,"d":"(3,386)"},{"v":-2628,"d":"(2,628)"},{"v":-2727,"d":"(2,727)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":157454,"d":"157,454 "},{"v":161888,"d":"161,888 "},{"v":168042,"d":"168,042 "},{"v":160969,"d":"160,969 "},{"v":163243,"d":"163,243 "},{"v":192113,"d":"192,113 "},{"v":195540,"d":"195,540 "},{"v":201714,"d":"201,714 "},{"v":206931,"d":"206,931 "},{"v":211736,"d":"211,736 "}]
["                         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.39,2.42,2.13,2.47,2.42,1.54,1.59,1.57,1.78,1.65]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":92.4,"d":"92.40"},92.68,90.92,{"v":92.2,"d":"92.20"},{"v":92.3,"d":"92.30"},93.17,93.47,93.14,92.99,92.82]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",5.21,{"v":4.9,"d":"4.90"},6.95,5.33,5.28,5.29,4.93,5.29,5.23,5.52]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.97,0.83,0.73,0.89,0.98,0.56,0.59,0.57,0.65,0.67]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",1.08,0.62,{"v":-0.35,"d":"(0.35)"},0.93,1.19,0.33,{"v":-0.39,"d":"(0.39)"},0.46,0.27,0.38]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",5.31,4.68,5.86,5.37,5.49,5.06,3.96,5.18,4.85,5.23]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.98,1.67,2.24,{"v":1.8,"d":"1.80"},1.81,1.54,1.35,1.46,0.82,1.68]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",3.33,3.01,3.62,3.57,3.68,3.52,2.61,3.72,4.03,3.55]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",23.43,20.55,29.81,24.49,25.46,26.43,21.41,28.59,23.29,27.87]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":14.7,"d":"14.70"},13.23,18.42,16.27,17.07,18.37,14.11,20.53,19.33,18.94]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",9.41,8.03,12.03,9.29,9.81,10.48,8.09,10.64,8.87,10.26]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5.9,"d":"5.90"},5.17,7.43,6.18,6.58,7.29,5.33,7.64,7.37,6.97]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.24,1.22,1.33,1.28,1.27,1.28,1.25,1.31,1.25,1.23]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.18,0.14,0.25,0.21,0.19,0.23,0.21,0.28,0.22,0.22]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.49,1.45,1.53,1.37,1.39,1.45,1.36,1.27,1.31,1.22]
["  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-2015Q2","index":3,"n_rows":61,"n_cols":11,"rows_kept":61,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[49,1,49,4],[49,6,49,9],[60,0,60,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 5.1 -- Balance Sheet  For Corporations in NAICS Retail Trade Subsectors 448 and 452, and\n                               All Other Retail Trade Subsectors, Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"Clothing and General Merchandise Stores\nTotal Assets $50 Million and Over",{"$nulls":4},"All Other Retail Trade\nTotal Assets $50 Million and Over"]
["Item"," 2Q_\n 2014_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 2Q_\n 2015_"," 2Q_\n 2014_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 2Q_\n 2015_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":18755,"d":"18,755 "},{"v":16408,"d":"16,408 "},{"v":23566,"d":"23,566 "},{"v":21557,"d":"21,557 "},{"v":19723,"d":"19,723 "},{"v":28774,"d":"28,774 "},{"v":28279,"d":"28,279 "},{"v":41428,"d":"41,428 "},{"v":30531,"d":"30,531 "},{"v":32913,"d":"32,913 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":552,"d":"552 "},{"v":716,"d":"716 "},{"v":737,"d":"737 "},{"v":718,"d":"718 "},{"v":1057,"d":"1,057 "},{"v":1449,"d":"1,449 "},{"v":1131,"d":"1,131 "},{"v":1214,"d":"1,214 "},{"v":965,"d":"965 "},{"v":880,"d":"880 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":19306,"d":"19,306 "},{"v":17124,"d":"17,124 "},{"v":24304,"d":"24,304 "},{"v":22275,"d":"22,275 "},{"v":20780,"d":"20,780 "},{"v":30223,"d":"30,223 "},{"v":29409,"d":"29,409 "},{"v":42642,"d":"42,642 "},{"v":31496,"d":"31,496 "},{"v":33794,"d":"33,794 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4747,"d":"4,747 "},{"v":3571,"d":"3,571 "},{"v":7541,"d":"7,541 "},{"v":6131,"d":"6,131 "},{"v":4674,"d":"4,674 "},{"v":11299,"d":"11,299 "},{"v":10855,"d":"10,855 "},{"v":11162,"d":"11,162 "},{"v":11419,"d":"11,419 "},{"v":11586,"d":"11,586 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":24053,"d":"24,053 "},{"v":20695,"d":"20,695 "},{"v":31844,"d":"31,844 "},{"v":28406,"d":"28,406 "},{"v":25454,"d":"25,454 "},{"v":41522,"d":"41,522 "},{"v":40264,"d":"40,264 "},{"v":53804,"d":"53,804 "},{"v":42915,"d":"42,915 "},{"v":45379,"d":"45,379 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":7954,"d":"7,954 "},{"v":8666,"d":"8,666 "},{"v":9189,"d":"9,189 "},{"v":8611,"d":"8,611 "},{"v":8814,"d":"8,814 "},{"v":47239,"d":"47,239 "},{"v":48975,"d":"48,975 "},{"v":50973,"d":"50,973 "},{"v":49625,"d":"49,625 "},{"v":51960,"d":"51,960 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":113176,"d":"113,176 "},{"v":131434,"d":"131,434 "},{"v":113062,"d":"113,062 "},{"v":115374,"d":"115,374 "},{"v":115806,"d":"115,806 "},{"v":123901,"d":"123,901 "},{"v":128429,"d":"128,429 "},{"v":129406,"d":"129,406 "},{"v":131242,"d":"131,242 "},{"v":133485,"d":"133,485 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":16287,"d":"16,287 "},{"v":16807,"d":"16,807 "},{"v":16950,"d":"16,950 "},{"v":24378,"d":"24,378 "},{"v":17478,"d":"17,478 "},{"v":20830,"d":"20,830 "},{"v":21194,"d":"21,194 "},{"v":21196,"d":"21,196 "},{"v":21357,"d":"21,357 "},{"v":21940,"d":"21,940 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":161470,"d":"161,470 "},{"v":177603,"d":"177,603 "},{"v":171045,"d":"171,045 "},{"v":176769,"d":"176,769 "},{"v":167552,"d":"167,552 "},{"v":233493,"d":"233,493 "},{"v":238863,"d":"238,863 "},{"v":255379,"d":"255,379 "},{"v":245138,"d":"245,138 "},{"v":252764,"d":"252,764 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":309314,"d":"309,314 "},{"v":315067,"d":"315,067 "},{"v":316925,"d":"316,925 "},{"v":319044,"d":"319,044 "},{"v":321279,"d":"321,279 "},{"v":276614,"d":"276,614 "},{"v":281813,"d":"281,813 "},{"v":287770,"d":"287,770 "},{"v":292702,"d":"292,702 "},{"v":295415,"d":"295,415 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":34046,"d":"34,046 "},{"v":34285,"d":"34,285 "},{"v":34480,"d":"34,480 "},{"v":34669,"d":"34,669 "},{"v":34410,"d":"34,410 "},{"v":29941,"d":"29,941 "},{"v":30297,"d":"30,297 "},{"v":30355,"d":"30,355 "},{"v":30626,"d":"30,626 "},{"v":30458,"d":"30,458 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":146140,"d":"146,140 "},{"v":150238,"d":"150,238 "},{"v":151913,"d":"151,913 "},{"v":155166,"d":"155,166 "},{"v":157090,"d":"157,090 "},{"v":142470,"d":"142,470 "},{"v":145531,"d":"145,531 "},{"v":148248,"d":"148,248 "},{"v":151503,"d":"151,503 "},{"v":153885,"d":"153,885 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":197220,"d":"197,220 "},{"v":199115,"d":"199,115 "},{"v":199491,"d":"199,491 "},{"v":198547,"d":"198,547 "},{"v":198599,"d":"198,599 "},{"v":164085,"d":"164,085 "},{"v":166580,"d":"166,580 "},{"v":169877,"d":"169,877 "},{"v":171826,"d":"171,826 "},{"v":171988,"d":"171,988 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":125034,"d":"125,034 "},{"v":123525,"d":"123,525 "},{"v":117333,"d":"117,333 "},{"v":117751,"d":"117,751 "},{"v":126089,"d":"126,089 "},{"v":230168,"d":"230,168 "},{"v":223997,"d":"223,997 "},{"v":226104,"d":"226,104 "},{"v":258612,"d":"258,612 "},{"v":259635,"d":"259,635 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":483724,"d":"483,724 "},{"v":500243,"d":"500,243 "},{"v":487870,"d":"487,870 "},{"v":493067,"d":"493,067 "},{"v":492240,"d":"492,240 "},{"v":627746,"d":"627,746 "},{"v":629439,"d":"629,439 "},{"v":651360,"d":"651,360 "},{"v":675576,"d":"675,576 "},{"v":684387,"d":"684,387 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1963,"d":"1,963 "},{"v":2123,"d":"2,123 "},{"v":2058,"d":"2,058 "},{"v":1748,"d":"1,748 "},{"v":1561,"d":"1,561 "},{"v":13745,"d":"13,745 "},{"v":14349,"d":"14,349 "},{"v":16485,"d":"16,485 "},{"v":15989,"d":"15,989 "},{"v":17682,"d":"17,682 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":4602,"d":"4,602 "},{"v":8009,"d":"8,009 "},{"v":2058,"d":"2,058 "},{"v":2707,"d":"2,707 "},{"v":3058,"d":"3,058 "},{"v":5211,"d":"5,211 "},{"v":5038,"d":"5,038 "},{"v":5115,"d":"5,115 "},{"v":4995,"d":"4,995 "},{"v":6103,"d":"6,103 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":64712,"d":"64,712 "},{"v":75272,"d":"75,272 "},{"v":64658,"d":"64,658 "},{"v":64504,"d":"64,504 "},{"v":64787,"d":"64,787 "},{"v":91316,"d":"91,316 "},{"v":95586,"d":"95,586 "},{"v":94218,"d":"94,218 "},{"v":96556,"d":"96,556 "},{"v":98358,"d":"98,358 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":1331,"d":"1,331 "},{"v":972,"d":"972 "},{"v":2334,"d":"2,334 "},{"v":3274,"d":"3,274 "},{"v":1082,"d":"1,082 "},{"v":5525,"d":"5,525 "},{"v":4901,"d":"4,901 "},{"v":5483,"d":"5,483 "},{"v":6082,"d":"6,082 "},{"v":6303,"d":"6,303 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":633,"d":"633 "},{"v":632,"d":"632 "},{"v":460,"d":"460 "},{"v":715,"d":"715 "},{"v":687,"d":"687 "},{"v":4959,"d":"4,959 "},{"v":4388,"d":"4,388 "},{"v":5739,"d":"5,739 "},{"v":4874,"d":"4,874 "},{"v":4766,"d":"4,766 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5585,"d":"5,585 "},{"v":5883,"d":"5,883 "},{"v":5559,"d":"5,559 "},{"v":7814,"d":"7,814 "},{"v":6392,"d":"6,392 "},{"v":7050,"d":"7,050 "},{"v":7635,"d":"7,635 "},{"v":5827,"d":"5,827 "},{"v":7464,"d":"7,464 "},{"v":10846,"d":"10,846 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":51824,"d":"51,824 "},{"v":52181,"d":"52,181 "},{"v":51826,"d":"51,826 "},{"v":56835,"d":"56,835 "},{"v":54188,"d":"54,188 "},{"v":55251,"d":"55,251 "},{"v":59038,"d":"59,038 "},{"v":61647,"d":"61,647 "},{"v":60288,"d":"60,288 "},{"v":61463,"d":"61,463 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":130650,"d":"130,650 "},{"v":145071,"d":"145,071 "},{"v":128954,"d":"128,954 "},{"v":137596,"d":"137,596 "},{"v":131756,"d":"131,756 "},{"v":183057,"d":"183,057 "},{"v":190935,"d":"190,935 "},{"v":194514,"d":"194,514 "},{"v":196247,"d":"196,247 "},{"v":205522,"d":"205,522 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":14181,"d":"14,181 "},{"v":15466,"d":"15,466 "},{"v":14656,"d":"14,656 "},{"v":19743,"d":"19,743 "},{"v":20737,"d":"20,737 "},{"v":46991,"d":"46,991 "},{"v":46403,"d":"46,403 "},{"v":47902,"d":"47,902 "},{"v":53706,"d":"53,706 "},{"v":58163,"d":"58,163 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":103237,"d":"103,237 "},{"v":102882,"d":"102,882 "},{"v":103584,"d":"103,584 "},{"v":103937,"d":"103,937 "},{"v":103706,"d":"103,706 "},{"v":93378,"d":"93,378 "},{"v":97220,"d":"97,220 "},{"v":110273,"d":"110,273 "},{"v":109529,"d":"109,529 "},{"v":109527,"d":"109,527 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":41460,"d":"41,460 "},{"v":41390,"d":"41,390 "},{"v":43801,"d":"43,801 "},{"v":44661,"d":"44,661 "},{"v":46273,"d":"46,273 "},{"v":55349,"d":"55,349 "},{"v":57121,"d":"57,121 "},{"v":56305,"d":"56,305 "},{"v":58697,"d":"58,697 "},{"v":59262,"d":"59,262 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":289527,"d":"289,527 "},{"v":304809,"d":"304,809 "},{"v":290995,"d":"290,995 "},{"v":305937,"d":"305,937 "},{"v":302472,"d":"302,472 "},{"v":378776,"d":"378,776 "},{"v":391679,"d":"391,679 "},{"v":408994,"d":"408,994 "},{"v":418178,"d":"418,178 "},{"v":432474,"d":"432,474 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":36742,"d":"36,742 "},{"v":33546,"d":"33,546 "},{"v":28833,"d":"28,833 "},{"v":26161,"d":"26,161 "},{"v":26525,"d":"26,525 "},{"v":56858,"d":"56,858 "},{"v":42221,"d":"42,221 "},{"v":40651,"d":"40,651 "},{"v":50467,"d":"50,467 "},{"v":40177,"d":"40,177 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":157454,"d":"157,454 "},{"v":161888,"d":"161,888 "},{"v":168042,"d":"168,042 "},{"v":160969,"d":"160,969 "},{"v":163243,"d":"163,243 "},{"v":192113,"d":"192,113 "},{"v":195540,"d":"195,540 "},{"v":201714,"d":"201,714 "},{"v":206931,"d":"206,931 "},{"v":211736,"d":"211,736 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":194196,"d":"194,196 "},{"v":195433,"d":"195,433 "},{"v":196875,"d":"196,875 "},{"v":187130,"d":"187,130 "},{"v":189768,"d":"189,768 "},{"v":248971,"d":"248,971 "},{"v":237761,"d":"237,761 "},{"v":242365,"d":"242,365 "},{"v":257398,"d":"257,398 "},{"v":251913,"d":"251,913 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":483724,"d":"483,724 "},{"v":500243,"d":"500,243 "},{"v":487870,"d":"487,870 "},{"v":493067,"d":"493,067 "},{"v":492240,"d":"492,240 "},{"v":627746,"d":"627,746 "},{"v":629439,"d":"629,439 "},{"v":651360,"d":"651,360 "},{"v":675576,"d":"675,576 "},{"v":684387,"d":"684,387 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":30821,"d":"30,821 "},{"v":32532,"d":"32,532 "},{"v":42091,"d":"42,091 "},{"v":39173,"d":"39,173 "},{"v":35796,"d":"35,796 "},{"v":50435,"d":"50,435 "},{"v":47928,"d":"47,928 "},{"v":60865,"d":"60,865 "},{"v":48892,"d":"48,892 "},{"v":47242,"d":"47,242 "}]
["                         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.14,6.53,5.76,5.17,6.61,{"v":6.4,"d":"6.40"},8.26,6.35,6.63]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",1.64,1.73,1.88,1.75,1.79,7.53,7.78,7.83,7.35,7.59]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":23.4,"d":"23.40"},26.27,23.17,{"v":23.4,"d":"23.40"},23.53,19.74,{"v":20.4,"d":"20.40"},19.87,19.43,{"v":19.5,"d":"19.50"}]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",33.38,{"v":35.5,"d":"35.50"},35.06,35.85,34.04,{"v":37.2,"d":"37.20"},37.95,39.21,36.29,36.93]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",40.77,{"v":39.8,"d":"39.80"},40.89,40.27,40.35,26.14,26.46,26.08,25.43,25.13]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",2.64,3.33,2.08,2.63,2.38,4.93,4.99,5.09,4.93,5.76]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",27.01,{"v":29,"d":"29.00"},26.43,27.91,26.77,29.16,30.33,29.86,29.05,30.03]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",24.27,23.66,24.24,25.08,25.28,22.36,22.82,24.28,24.16,{"v":24.5,"d":"24.50"}]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",59.85,60.93,59.65,62.05,61.45,60.34,62.23,62.79,{"v":61.9,"d":"61.90"},63.19]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",40.15,39.07,40.35,37.95,38.55,39.66,37.77,37.21,{"v":38.1,"d":"38.10"},36.81]
["  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-2015Q2","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":406507,"d":"406,507 "},{"v":410771,"d":"410,771 "},{"v":422029,"d":"422,029 "},{"v":427140,"d":"427,140 "}]
["2005 …………………………………………………………………………………………...………………………………………………..",{"v":437880,"d":"437,880 "},{"v":447787,"d":"447,787 "},{"v":458905,"d":"458,905 "},{"v":467435,"d":"467,435 "}]
["2006 …………………………………………………………………………………………...………………………………………………..",{"v":480207,"d":"480,207 "},{"v":493126,"d":"493,126 "},{"v":498018,"d":"498,018 "},{"v":501376,"d":"501,376 "}]
["2007 …………………………………………………………………………………………...………………………………………………..",{"v":509890,"d":"509,890 "},{"v":514973,"d":"514,973 "},{"v":516374,"d":"516,374 "},{"v":520449,"d":"520,449 "}]
["2008 …………………………………………………………………………………………...………………………………………………..",{"v":523428,"d":"523,428 "},{"v":536504,"d":"536,504 "},{"v":531761,"d":"531,761 "},{"v":500424,"d":"500,424 "}]
["2009 …………………………………………………………………………………………...………………………………………………..",{"v":496038,"d":"496,038 "},{"v":495284,"d":"495,284 "},{"v":508815,"d":"508,815 "},{"v":519226,"d":"519,226 "}]
["2010 …………………………………………………………………………………………...………………………………………………..",{"v":532685,"d":"532,685 "},{"v":534685,"d":"534,685 "},{"v":539793,"d":"539,793 "},{"v":550051,"d":"550,051 "}]
["2011 …………………………………………………………………………………………...………………………………………………..",{"v":568184,"d":"568,184 "},{"v":584981,"d":"584,981 "},{"v":586042,"d":"586,042 "},{"v":585623,"d":"585,623 "}]
["2012 …………………………………………………………………………………………...………………………………………………..",{"v":604623,"d":"604,623 "},{"v":597771,"d":"597,771 "},{"v":602885,"d":"602,885 "},{"v":610620,"d":"610,620 "}]
["2013 …………………………………………………………………………………………...………………………………………………..",{"v":620193,"d":"620,193 "},{"v":626612,"d":"626,612 "},{"v":635827,"d":"635,827 "},{"v":641769,"d":"641,769 "}]
["2014 …………………………………………………………………………………………...………………………………………………..",{"v":642206,"d":"642,206 "},{"v":658511,"d":"658,511 "},{"v":664964,"d":"664,964 "},{"v":667893,"d":"667,893 "}]
["2015 …………………………………………………………………………………………...………………………………………………..",{"v":655016,"d":"655,016 "},{"v":672851,"d":"672,851 "}]
[]
["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."]