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

{"sheet":"RET_4_0-2015Q3","index":0,"n_rows":47,"n_cols":11,"rows_kept":47,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[22,1,22,4],[22,6,22,9],[33,1,33,4],[33,6,33,9],[46,0,46,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 4.0 -- Income Statement  For Corporations in NAICS Retail Trade Sector, and Retail Trade Subsector 445,\n                              Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"All Retail Trade\nTotal Assets $50 Million and Over",{"$nulls":4},"Food and Beverage Stores\nTotal Assets $50 Million and Over"]
["Item"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 2Q_\n 2015_"," 3Q_\n 2015_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 2Q_\n 2015_"," 3Q_\n 2015_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":651860,"d":"651,860 "},{"v":701724,"d":"701,724 "},{"v":636639,"d":"636,639 "},{"v":665254,"d":"665,254 "},{"v":662224,"d":"662,224 "},{"v":114888,"d":"114,888 "},{"v":115658,"d":"115,658 "},{"v":114298,"d":"114,298 "},{"v":115593,"d":"115,593 "},{"v":114698,"d":"114,698 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":12726,"d":"12,726 "},{"v":13031,"d":"13,031 "},{"v":13243,"d":"13,243 "},{"v":13174,"d":"13,174 "},{"v":13668,"d":"13,668 "},{"v":2396,"d":"2,396 "},{"v":2418,"d":"2,418 "},{"v":2526,"d":"2,526 "},{"v":2421,"d":"2,421 "},{"v":2376,"d":"2,376 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":609681,"d":"609,681 "},{"v":649513,"d":"649,513 "},{"v":592048,"d":"592,048 "},{"v":618044,"d":"618,044 "},{"v":617903,"d":"617,903 "},{"v":109431,"d":"109,431 "},{"v":109665,"d":"109,665 "},{"v":107842,"d":"107,842 "},{"v":109572,"d":"109,572 "},{"v":109242,"d":"109,242 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":29452,"d":"29,452 "},{"v":39179,"d":"39,179 "},{"v":31348,"d":"31,348 "},{"v":34036,"d":"34,036 "},{"v":30654,"d":"30,654 "},{"v":3062,"d":"3,062 "},{"v":3575,"d":"3,575 "},{"v":3930,"d":"3,930 "},{"v":3599,"d":"3,599 "},{"v":3079,"d":"3,079 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4326,"d":"4,326 "},{"v":4396,"d":"4,396 "},{"v":4654,"d":"4,654 "},{"v":5056,"d":"5,056 "},{"v":4958,"d":"4,958 "},{"v":657,"d":"657 "},{"v":640,"d":"640 "},{"v":702,"d":"702 "},{"v":744,"d":"744 "},{"v":730,"d":"730 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-119,"d":"(119)"},{"v":206,"d":"206 "},{"v":3182,"d":"3,182 "},{"v":2932,"d":"2,932 "},{"v":1417,"d":"1,417 "},{"v":-190,"d":"(190)"},{"v":-37,"d":"(37)"},{"v":139,"d":"139 "},{"v":117,"d":"117 "},{"v":86,"d":"86 "}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":25007,"d":"25,007 "},{"v":34990,"d":"34,990 "},{"v":29877,"d":"29,877 "},{"v":31912,"d":"31,912 "},{"v":27113,"d":"27,113 "},{"v":2215,"d":"2,215 "},{"v":2899,"d":"2,899 "},{"v":3367,"d":"3,367 "},{"v":2972,"d":"2,972 "},{"v":2436,"d":"2,436 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":8762,"d":"8,762 "},{"v":11448,"d":"11,448 "},{"v":7530,"d":"7,530 "},{"v":10576,"d":"10,576 "},{"v":9197,"d":"9,197 "},{"v":836,"d":"836 "},{"v":941,"d":"941 "},{"v":1225,"d":"1,225 "},{"v":1072,"d":"1,072 "},{"v":906,"d":"906 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":16245,"d":"16,245 "},{"v":23542,"d":"23,542 "},{"v":22347,"d":"22,347 "},{"v":21336,"d":"21,336 "},{"v":17916,"d":"17,916 "},{"v":1379,"d":"1,379 "},{"v":1958,"d":"1,958 "},{"v":2142,"d":"2,142 "},{"v":1900,"d":"1,900 "},{"v":1529,"d":"1,529 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":4931,"d":"4,931 "},{"v":5525,"d":"5,525 "},{"v":13427,"d":"13,427 "},{"v":6025,"d":"6,025 "},{"v":7786,"d":"7,786 "},{"v":647,"d":"647 "},{"v":702,"d":"702 "},{"v":1089,"d":"1,089 "},{"v":390,"d":"390 "},{"v":459,"d":"459 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":11314,"d":"11,314 "},{"v":18018,"d":"18,018 "},{"v":8920,"d":"8,920 "},{"v":15311,"d":"15,311 "},{"v":10130,"d":"10,130 "},{"v":732,"d":"732 "},{"v":1256,"d":"1,256 "},{"v":1053,"d":"1,053 "},{"v":1510,"d":"1,510 "},{"v":1070,"d":"1,070 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":387711,"d":"387,711 "},{"v":394673,"d":"394,673 "},{"v":402631,"d":"402,631 "},{"v":400510,"d":"400,510 "},{"v":409525,"d":"409,525 "},{"v":41981,"d":"41,981 "},{"v":42268,"d":"42,268 "},{"v":42538,"d":"42,538 "},{"v":38983,"d":"38,983 "},{"v":40372,"d":"40,372 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-3667,"d":"(3,667)"},{"v":-5011,"d":"(5,011)"},{"v":-4957,"d":"(4,957)"},{"v":-6819,"d":"(6,819)"},{"v":-18137,"d":"(18,137)"},{"v":-110,"d":"(110)"},{"v":-619,"d":"(619)"},{"v":-57,"d":"(57)"},{"v":-443,"d":"(443)"},{"v":-155,"d":"(155)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":395358,"d":"395,358 "},{"v":407679,"d":"407,679 "},{"v":406593,"d":"406,593 "},{"v":409002,"d":"409,002 "},{"v":401518,"d":"401,518 "},{"v":42603,"d":"42,603 "},{"v":42905,"d":"42,905 "},{"v":43534,"d":"43,534 "},{"v":40050,"d":"40,050 "},{"v":41288,"d":"41,288 "}]
["                         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.95,1.86,2.08,1.98,2.06,2.09,2.09,2.21,2.09,2.07]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",93.53,92.56,{"v":93,"d":"93.00"},{"v":92.9,"d":"92.90"},93.31,95.25,94.82,94.35,94.79,95.24]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",4.52,5.58,4.92,5.12,4.63,2.67,3.09,3.44,3.11,2.68]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.66,0.63,0.73,0.76,0.75,0.57,0.55,0.61,0.64,0.64]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",{"v":-0.02,"d":"(0.02)"},0.03,{"v":0.5,"d":"0.50"},0.44,0.21,{"v":-0.17,"d":"(0.17)"},{"v":-0.03,"d":"(0.03)"},0.12,{"v":0.1,"d":"0.10"},0.08]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",3.84,4.99,4.69,{"v":4.8,"d":"4.80"},4.09,1.93,2.51,2.95,2.57,2.12]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.34,1.63,1.18,1.59,1.39,0.73,0.81,1.07,0.93,0.79]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",2.49,3.35,3.51,3.21,2.71,{"v":1.2,"d":"1.20"},1.69,1.87,1.64,1.33]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":20.4,"d":"20.40"},28.16,23.72,25.71,22.68,15.61,20.07,22.84,21.64,17.51]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",13.26,18.95,17.74,17.19,14.98,9.72,13.56,14.53,13.83,{"v":11,"d":"11.00"}]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",7.79,10.71,8.99,9.52,7.89,5.72,7.33,8.54,7.36,5.96]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",5.06,7.21,6.72,6.36,5.22,3.56,4.95,5.43,4.71,3.74]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.24,1.33,1.29,1.26,1.26,1.23,1.26,1.23,{"v":1.2,"d":"1.20"},1.18]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",{"v":0.2,"d":"0.20"},{"v":0.3,"d":"0.30"},0.25,0.24,0.22,0.35,0.38,0.37,0.36,0.34]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.41,1.36,1.36,1.28,1.17,1.44,1.43,1.53,1.25,1.25]
["  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-2015Q3","index":1,"n_rows":61,"n_cols":11,"rows_kept":61,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[49,1,49,4],[49,6,49,9],[60,0,60,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 4.1 -- Balance Sheet  For Corporations in NAICS Retail Trade Sector, and Retail Trade Subsector 445,\n                               Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"All Retail Trade\nTotal Assets $50 Million and Over",{"$nulls":4},"Food and Beverage Stores\nTotal Assets $50 Million and Over"]
["Item"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 2Q_\n 2015_"," 3Q_\n 2015_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 2Q_\n 2015_"," 3Q_\n 2015_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":56331,"d":"56,331 "},{"v":77706,"d":"77,706 "},{"v":64627,"d":"64,627 "},{"v":65385,"d":"65,385 "},{"v":62816,"d":"62,816 "},{"v":11589,"d":"11,589 "},{"v":12652,"d":"12,652 "},{"v":12274,"d":"12,274 "},{"v":12246,"d":"12,246 "},{"v":12378,"d":"12,378 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":2956,"d":"2,956 "},{"v":3043,"d":"3,043 "},{"v":2516,"d":"2,516 "},{"v":2036,"d":"2,036 "},{"v":1478,"d":"1,478 "},{"v":1110,"d":"1,110 "},{"v":1093,"d":"1,093 "},{"v":840,"d":"840 "},{"v":335,"d":"335 "},{"v":212,"d":"212 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":59287,"d":"59,287 "},{"v":80749,"d":"80,749 "},{"v":67143,"d":"67,143 "},{"v":67422,"d":"67,422 "},{"v":64294,"d":"64,294 "},{"v":12699,"d":"12,699 "},{"v":13745,"d":"13,745 "},{"v":13114,"d":"13,114 "},{"v":12581,"d":"12,581 "},{"v":12590,"d":"12,590 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":16398,"d":"16,398 "},{"v":29028,"d":"29,028 "},{"v":26174,"d":"26,174 "},{"v":24775,"d":"24,775 "},{"v":26963,"d":"26,963 "},{"v":1973,"d":"1,973 "},{"v":2161,"d":"2,161 "},{"v":2179,"d":"2,179 "},{"v":2138,"d":"2,138 "},{"v":2035,"d":"2,035 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":75686,"d":"75,686 "},{"v":109777,"d":"109,777 "},{"v":93318,"d":"93,318 "},{"v":92196,"d":"92,196 "},{"v":91256,"d":"91,256 "},{"v":14673,"d":"14,673 "},{"v":15906,"d":"15,906 "},{"v":15294,"d":"15,294 "},{"v":14719,"d":"14,719 "},{"v":14625,"d":"14,625 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":63222,"d":"63,222 "},{"v":67095,"d":"67,095 "},{"v":66158,"d":"66,158 "},{"v":68770,"d":"68,770 "},{"v":73699,"d":"73,699 "},{"v":5652,"d":"5,652 "},{"v":5822,"d":"5,822 "},{"v":5620,"d":"5,620 "},{"v":5698,"d":"5,698 "},{"v":5869,"d":"5,869 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":285949,"d":"285,949 "},{"v":268564,"d":"268,564 "},{"v":271979,"d":"271,979 "},{"v":274549,"d":"274,549 "},{"v":303775,"d":"303,775 "},{"v":25868,"d":"25,868 "},{"v":25816,"d":"25,816 "},{"v":25228,"d":"25,228 "},{"v":24933,"d":"24,933 "},{"v":26519,"d":"26,519 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":43440,"d":"43,440 "},{"v":43688,"d":"43,688 "},{"v":51646,"d":"51,646 "},{"v":45148,"d":"45,148 "},{"v":43863,"d":"43,863 "},{"v":4596,"d":"4,596 "},{"v":4691,"d":"4,691 "},{"v":4312,"d":"4,312 "},{"v":4392,"d":"4,392 "},{"v":3790,"d":"3,790 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":468297,"d":"468,297 "},{"v":489124,"d":"489,124 "},{"v":483100,"d":"483,100 "},{"v":480662,"d":"480,662 "},{"v":512593,"d":"512,593 "},{"v":50788,"d":"50,788 "},{"v":52234,"d":"52,234 "},{"v":50454,"d":"50,454 "},{"v":49742,"d":"49,742 "},{"v":50803,"d":"50,803 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":740328,"d":"740,328 "},{"v":752167,"d":"752,167 "},{"v":759388,"d":"759,388 "},{"v":757617,"d":"757,617 "},{"v":769714,"d":"769,714 "},{"v":141959,"d":"141,959 "},{"v":144907,"d":"144,907 "},{"v":146577,"d":"146,577 "},{"v":138715,"d":"138,715 "},{"v":141696,"d":"141,696 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":75848,"d":"75,848 "},{"v":76262,"d":"76,262 "},{"v":76815,"d":"76,815 "},{"v":76408,"d":"76,408 "},{"v":77096,"d":"77,096 "},{"v":11430,"d":"11,430 "},{"v":11560,"d":"11,560 "},{"v":11765,"d":"11,765 "},{"v":12125,"d":"12,125 "},{"v":12193,"d":"12,193 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":371893,"d":"371,893 "},{"v":378184,"d":"378,184 "},{"v":387085,"d":"387,085 "},{"v":382823,"d":"382,823 "},{"v":389940,"d":"389,940 "},{"v":75834,"d":"75,834 "},{"v":77675,"d":"77,675 "},{"v":78926,"d":"78,926 "},{"v":70349,"d":"70,349 "},{"v":72263,"d":"72,263 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":444282,"d":"444,282 "},{"v":450246,"d":"450,246 "},{"v":449119,"d":"449,119 "},{"v":451202,"d":"451,202 "},{"v":456870,"d":"456,870 "},{"v":77556,"d":"77,556 "},{"v":78792,"d":"78,792 "},{"v":79416,"d":"79,416 "},{"v":80492,"d":"80,492 "},{"v":81626,"d":"81,626 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":371314,"d":"371,314 "},{"v":367457,"d":"367,457 "},{"v":397603,"d":"397,603 "},{"v":409512,"d":"409,512 "},{"v":404238,"d":"404,238 "},{"v":26458,"d":"26,458 "},{"v":27065,"d":"27,065 "},{"v":27802,"d":"27,802 "},{"v":31202,"d":"31,202 "},{"v":31158,"d":"31,158 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1283894,"d":"1,283,894 "},{"v":1306827,"d":"1,306,827 "},{"v":1329821,"d":"1,329,821 "},{"v":1341377,"d":"1,341,377 "},{"v":1373702,"d":"1,373,702 "},{"v":154802,"d":"154,802 "},{"v":158091,"d":"158,091 "},{"v":157673,"d":"157,673 "},{"v":161436,"d":"161,436 "},{"v":163587,"d":"163,587 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":16234,"d":"16,234 "},{"v":18004,"d":"18,004 "},{"v":17453,"d":"17,453 "},{"v":18956,"d":"18,956 "},{"v":18743,"d":"18,743 "},{"v":388,"d":"388 "},{"v":365,"d":"365 "},{"v":451,"d":"451 "},{"v":381,"d":"381 "},{"v":243,"d":"243 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":14128,"d":"14,128 "},{"v":8966,"d":"8,966 "},{"v":9241,"d":"9,241 "},{"v":11188,"d":"11,188 "},{"v":14324,"d":"14,324 "},{"v":1084,"d":"1,084 "},{"v":1106,"d":"1,106 "},{"v":1139,"d":"1,139 "},{"v":1070,"d":"1,070 "},{"v":1249,"d":"1,249 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":192391,"d":"192,391 "},{"v":182645,"d":"182,645 "},{"v":183894,"d":"183,894 "},{"v":186474,"d":"186,474 "},{"v":208169,"d":"208,169 "},{"v":21551,"d":"21,551 "},{"v":22098,"d":"22,098 "},{"v":21849,"d":"21,849 "},{"v":21603,"d":"21,603 "},{"v":22337,"d":"22,337 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":6199,"d":"6,199 "},{"v":8231,"d":"8,231 "},{"v":9940,"d":"9,940 "},{"v":7611,"d":"7,611 "},{"v":3404,"d":"3,404 "},{"v":327,"d":"327 "},{"v":416,"d":"416 "},{"v":662,"d":"662 "},{"v":331,"d":"331 "},{"v":307,"d":"307 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5387,"d":"5,387 "},{"v":5987,"d":"5,987 "},{"v":5488,"d":"5,488 "},{"v":5260,"d":"5,260 "},{"v":5273,"d":"5,273 "},{"v":952,"d":"952 "},{"v":1121,"d":"1,121 "},{"v":797,"d":"797 "},{"v":781,"d":"781 "},{"v":834,"d":"834 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15537,"d":"15,537 "},{"v":13690,"d":"13,690 "},{"v":16387,"d":"16,387 "},{"v":18840,"d":"18,840 "},{"v":18350,"d":"18,350 "},{"v":1518,"d":"1,518 "},{"v":1056,"d":"1,056 "},{"v":633,"d":"633 "},{"v":1086,"d":"1,086 "},{"v":1836,"d":"1,836 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":126479,"d":"126,479 "},{"v":130002,"d":"130,002 "},{"v":133182,"d":"133,182 "},{"v":131830,"d":"131,830 "},{"v":137423,"d":"137,423 "},{"v":15583,"d":"15,583 "},{"v":15451,"d":"15,451 "},{"v":15453,"d":"15,453 "},{"v":16151,"d":"16,151 "},{"v":16428,"d":"16,428 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":376355,"d":"376,355 "},{"v":367525,"d":"367,525 "},{"v":375586,"d":"375,586 "},{"v":380158,"d":"380,158 "},{"v":405685,"d":"405,685 "},{"v":41403,"d":"41,403 "},{"v":41614,"d":"41,614 "},{"v":40984,"d":"40,984 "},{"v":41402,"d":"41,402 "},{"v":43234,"d":"43,234 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":58516,"d":"58,516 "},{"v":59316,"d":"59,316 "},{"v":70047,"d":"70,047 "},{"v":80635,"d":"80,635 "},{"v":84509,"d":"84,509 "},{"v":9426,"d":"9,426 "},{"v":9542,"d":"9,542 "},{"v":9508,"d":"9,508 "},{"v":14532,"d":"14,532 "},{"v":15565,"d":"15,565 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":238175,"d":"238,175 "},{"v":258798,"d":"258,798 "},{"v":252644,"d":"252,644 "},{"v":252481,"d":"252,481 "},{"v":268053,"d":"268,053 "},{"v":26156,"d":"26,156 "},{"v":27345,"d":"27,345 "},{"v":26048,"d":"26,048 "},{"v":26058,"d":"26,058 "},{"v":24889,"d":"24,889 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":120626,"d":"120,626 "},{"v":124220,"d":"124,220 "},{"v":127690,"d":"127,690 "},{"v":131657,"d":"131,657 "},{"v":137193,"d":"137,193 "},{"v":21055,"d":"21,055 "},{"v":21824,"d":"21,824 "},{"v":22175,"d":"22,175 "},{"v":24504,"d":"24,504 "},{"v":24268,"d":"24,268 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":793671,"d":"793,671 "},{"v":809859,"d":"809,859 "},{"v":825967,"d":"825,967 "},{"v":844931,"d":"844,931 "},{"v":895441,"d":"895,441 "},{"v":98040,"d":"98,040 "},{"v":100325,"d":"100,325 "},{"v":98715,"d":"98,715 "},{"v":106495,"d":"106,495 "},{"v":107955,"d":"107,955 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":94865,"d":"94,865 "},{"v":89288,"d":"89,288 "},{"v":97260,"d":"97,260 "},{"v":87443,"d":"87,443 "},{"v":76743,"d":"76,743 "},{"v":14159,"d":"14,159 "},{"v":14860,"d":"14,860 "},{"v":15424,"d":"15,424 "},{"v":14890,"d":"14,890 "},{"v":14344,"d":"14,344 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":395358,"d":"395,358 "},{"v":407679,"d":"407,679 "},{"v":406593,"d":"406,593 "},{"v":409002,"d":"409,002 "},{"v":401518,"d":"401,518 "},{"v":42603,"d":"42,603 "},{"v":42905,"d":"42,905 "},{"v":43534,"d":"43,534 "},{"v":40050,"d":"40,050 "},{"v":41288,"d":"41,288 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":490223,"d":"490,223 "},{"v":496967,"d":"496,967 "},{"v":503854,"d":"503,854 "},{"v":496446,"d":"496,446 "},{"v":478261,"d":"478,261 "},{"v":56762,"d":"56,762 "},{"v":57766,"d":"57,766 "},{"v":58958,"d":"58,958 "},{"v":54940,"d":"54,940 "},{"v":55632,"d":"55,632 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1283894,"d":"1,283,894 "},{"v":1306827,"d":"1,306,827 "},{"v":1329821,"d":"1,329,821 "},{"v":1341377,"d":"1,341,377 "},{"v":1373702,"d":"1,373,702 "},{"v":154802,"d":"154,802 "},{"v":158091,"d":"158,091 "},{"v":157673,"d":"157,673 "},{"v":161436,"d":"161,436 "},{"v":163587,"d":"163,587 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":91943,"d":"91,943 "},{"v":121599,"d":"121,599 "},{"v":107513,"d":"107,513 "},{"v":100504,"d":"100,504 "},{"v":106908,"d":"106,908 "},{"v":9385,"d":"9,385 "},{"v":10620,"d":"10,620 "},{"v":9470,"d":"9,470 "},{"v":8340,"d":"8,340 "},{"v":7569,"d":"7,569 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5.9,"d":"5.90"},{"v":8.4,"d":"8.40"},7.02,6.87,6.64,9.48,10.06,{"v":9.7,"d":"9.70"},9.12,8.94]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",4.92,5.13,4.97,5.13,5.37,3.65,3.68,3.56,3.53,3.59]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.27,20.55,20.45,20.47,22.11,16.71,16.33,{"v":16,"d":"16.00"},15.44,16.21]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",36.47,37.43,36.33,35.83,37.31,32.81,33.04,{"v":32,"d":"32.00"},30.81,31.06]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":34.6,"d":"34.60"},34.45,33.77,33.64,33.26,{"v":50.1,"d":"50.10"},49.84,50.37,49.86,{"v":49.9,"d":"49.90"}]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",3.99,3.57,3.65,4.04,4.13,2.55,2.31,1.92,2.06,2.54]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",29.31,28.12,28.24,28.34,29.53,26.75,26.32,25.99,25.65,26.43]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",23.11,24.34,24.27,24.83,25.67,22.99,23.33,22.55,25.14,24.73]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",61.82,61.97,62.11,62.99,65.18,63.33,63.46,62.61,65.97,65.99]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",38.18,38.03,37.89,37.01,34.82,36.67,36.54,37.39,34.03,34.01]
["  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-2015Q3","index":2,"n_rows":47,"n_cols":11,"rows_kept":47,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[22,1,22,4],[22,6,22,9],[33,1,33,4],[33,6,33,9],[46,0,46,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 5.0 -- Income Statement  For Corporations in NAICS Retail Trade Subsectors 448 and 452, and\n                               All Other Retail Trade Subsectors, Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"Clothing and General Merchandise Stores\nTotal Assets $50 Million and Over",{"$nulls":4},"All Other Retail Trade\nTotal Assets $50 Million and Over"]
["Item"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 2Q_\n 2015_"," 3Q_\n 2015_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 2Q_\n 2015_"," 3Q_\n 2015_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":214335,"d":"214,335 "},{"v":250420,"d":"250,420 "},{"v":213779,"d":"213,779 "},{"v":219355,"d":"219,355 "},{"v":217256,"d":"217,256 "},{"v":322636,"d":"322,636 "},{"v":335645,"d":"335,645 "},{"v":308562,"d":"308,562 "},{"v":330306,"d":"330,306 "},{"v":330271,"d":"330,271 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":5196,"d":"5,196 "},{"v":5344,"d":"5,344 "},{"v":5287,"d":"5,287 "},{"v":5319,"d":"5,319 "},{"v":5449,"d":"5,449 "},{"v":5134,"d":"5,134 "},{"v":5269,"d":"5,269 "},{"v":5430,"d":"5,430 "},{"v":5434,"d":"5,434 "},{"v":5843,"d":"5,843 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":198646,"d":"198,646 "},{"v":227682,"d":"227,682 "},{"v":196989,"d":"196,989 "},{"v":202620,"d":"202,620 "},{"v":201930,"d":"201,930 "},{"v":301605,"d":"301,605 "},{"v":312167,"d":"312,167 "},{"v":287217,"d":"287,217 "},{"v":305852,"d":"305,852 "},{"v":306731,"d":"306,731 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":10493,"d":"10,493 "},{"v":17395,"d":"17,395 "},{"v":11502,"d":"11,502 "},{"v":11416,"d":"11,416 "},{"v":9876,"d":"9,876 "},{"v":15897,"d":"15,897 "},{"v":18209,"d":"18,209 "},{"v":15916,"d":"15,916 "},{"v":19020,"d":"19,020 "},{"v":17698,"d":"17,698 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1779,"d":"1,779 "},{"v":1837,"d":"1,837 "},{"v":1913,"d":"1,913 "},{"v":2145,"d":"2,145 "},{"v":1836,"d":"1,836 "},{"v":1890,"d":"1,890 "},{"v":1918,"d":"1,918 "},{"v":2039,"d":"2,039 "},{"v":2167,"d":"2,167 "},{"v":2391,"d":"2,391 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1326,"d":"1,326 "},{"v":-885,"d":"(885)"},{"v":2046,"d":"2,046 "},{"v":2372,"d":"2,372 "},{"v":2013,"d":"2,013 "},{"v":-1256,"d":"(1,256)"},{"v":1128,"d":"1,128 "},{"v":997,"d":"997 "},{"v":443,"d":"443 "},{"v":-683,"d":"(683)"}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":10040,"d":"10,040 "},{"v":14672,"d":"14,672 "},{"v":11636,"d":"11,636 "},{"v":11643,"d":"11,643 "},{"v":10053,"d":"10,053 "},{"v":12751,"d":"12,751 "},{"v":17419,"d":"17,419 "},{"v":14874,"d":"14,874 "},{"v":17297,"d":"17,297 "},{"v":14624,"d":"14,624 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":3579,"d":"3,579 "},{"v":5606,"d":"5,606 "},{"v":3873,"d":"3,873 "},{"v":3925,"d":"3,925 "},{"v":3675,"d":"3,675 "},{"v":4347,"d":"4,347 "},{"v":4901,"d":"4,901 "},{"v":2432,"d":"2,432 "},{"v":5579,"d":"5,579 "},{"v":4615,"d":"4,615 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":6462,"d":"6,462 "},{"v":9066,"d":"9,066 "},{"v":7763,"d":"7,763 "},{"v":7718,"d":"7,718 "},{"v":6378,"d":"6,378 "},{"v":8404,"d":"8,404 "},{"v":12519,"d":"12,519 "},{"v":12442,"d":"12,442 "},{"v":11718,"d":"11,718 "},{"v":10009,"d":"10,009 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":1773,"d":"1,773 "},{"v":1790,"d":"1,790 "},{"v":8940,"d":"8,940 "},{"v":1864,"d":"1,864 "},{"v":3000,"d":"3,000 "},{"v":2510,"d":"2,510 "},{"v":3032,"d":"3,032 "},{"v":3398,"d":"3,398 "},{"v":3771,"d":"3,771 "},{"v":4327,"d":"4,327 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4689,"d":"4,689 "},{"v":7276,"d":"7,276 "},{"v":-1177,"d":"(1,177)"},{"v":5854,"d":"5,854 "},{"v":3378,"d":"3,378 "},{"v":5894,"d":"5,894 "},{"v":9486,"d":"9,486 "},{"v":9044,"d":"9,044 "},{"v":7946,"d":"7,946 "},{"v":5682,"d":"5,682 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":158466,"d":"158,466 "},{"v":161771,"d":"161,771 "},{"v":164971,"d":"164,971 "},{"v":160663,"d":"160,663 "},{"v":161796,"d":"161,796 "},{"v":187264,"d":"187,264 "},{"v":190634,"d":"190,634 "},{"v":195122,"d":"195,122 "},{"v":200864,"d":"200,864 "},{"v":207356,"d":"207,356 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-1267,"d":"(1,267)"},{"v":-1004,"d":"(1,004)"},{"v":-2318,"d":"(2,318)"},{"v":-3737,"d":"(3,737)"},{"v":-3574,"d":"(3,574)"},{"v":-2290,"d":"(2,290)"},{"v":-3388,"d":"(3,388)"},{"v":-2582,"d":"(2,582)"},{"v":-2639,"d":"(2,639)"},{"v":-14408,"d":"(14,408)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":161888,"d":"161,888 "},{"v":168042,"d":"168,042 "},{"v":161475,"d":"161,475 "},{"v":162780,"d":"162,780 "},{"v":161600,"d":"161,600 "},{"v":190868,"d":"190,868 "},{"v":196732,"d":"196,732 "},{"v":201585,"d":"201,585 "},{"v":206172,"d":"206,172 "},{"v":198630,"d":"198,630 "}]
["                         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.13,2.47,2.42,2.51,1.59,1.57,1.76,1.65,1.77]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",92.68,90.92,92.15,92.37,92.95,93.48,93.01,93.08,{"v":92.6,"d":"92.60"},92.87]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4.9,"d":"4.90"},6.95,5.38,{"v":5.2,"d":"5.20"},4.55,4.93,5.43,5.16,5.76,5.36]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.83,0.73,0.89,0.98,0.85,0.59,0.57,0.66,0.66,0.72]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",0.62,{"v":-0.35,"d":"(0.35)"},0.96,1.08,0.93,{"v":-0.39,"d":"(0.39)"},0.34,0.32,0.13,{"v":-0.21,"d":"(0.21)"}]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",4.68,5.86,5.44,5.31,4.63,3.95,5.19,4.82,5.24,4.43]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.67,2.24,1.81,1.79,1.69,1.35,1.46,0.79,1.69,{"v":1.4,"d":"1.40"}]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",3.01,3.62,3.63,3.52,2.94,{"v":2.6,"d":"2.60"},3.73,4.03,3.55,3.03]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",20.55,29.81,24.78,24.55,21.74,21.43,28.75,23.14,27.48,24.61]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",13.23,18.42,16.53,16.27,13.79,14.12,20.66,19.36,18.61,16.85]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",8.03,12.03,9.44,9.48,7.87,8.11,10.54,8.76,10.05,8.37]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",5.17,7.43,{"v":6.3,"d":"6.30"},6.28,4.99,5.35,7.58,7.33,6.81,5.73]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.22,1.33,1.28,1.27,1.26,1.26,1.35,{"v":1.3,"d":"1.30"},1.27,1.28]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.14,0.25,0.21,0.19,0.17,0.21,0.31,0.25,0.25,0.24]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.45,1.53,1.37,1.39,{"v":1.3,"d":"1.30"},1.37,1.24,1.31,1.22,1.07]
["  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-2015Q3","index":3,"n_rows":61,"n_cols":11,"rows_kept":61,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[49,1,49,4],[49,6,49,9],[60,0,60,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 5.1 -- Balance Sheet  For Corporations in NAICS Retail Trade Subsectors 448 and 452, and\n                               All Other Retail Trade Subsectors, Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"Clothing and General Merchandise Stores\nTotal Assets $50 Million and Over",{"$nulls":4},"All Other Retail Trade\nTotal Assets $50 Million and Over"]
["Item"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 2Q_\n 2015_"," 3Q_\n 2015_"," 3Q_\n 2014_"," 4Q_\n 2014_"," 1Q_\n 2015_"," 2Q_\n 2015_"," 3Q_\n 2015_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":16408,"d":"16,408 "},{"v":23566,"d":"23,566 "},{"v":21558,"d":"21,558 "},{"v":19889,"d":"19,889 "},{"v":18273,"d":"18,273 "},{"v":28334,"d":"28,334 "},{"v":41488,"d":"41,488 "},{"v":30794,"d":"30,794 "},{"v":33251,"d":"33,251 "},{"v":32165,"d":"32,165 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":716,"d":"716 "},{"v":737,"d":"737 "},{"v":718,"d":"718 "},{"v":822,"d":"822 "},{"v":633,"d":"633 "},{"v":1131,"d":"1,131 "},{"v":1213,"d":"1,213 "},{"v":958,"d":"958 "},{"v":879,"d":"879 "},{"v":633,"d":"633 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":17124,"d":"17,124 "},{"v":24304,"d":"24,304 "},{"v":22277,"d":"22,277 "},{"v":20711,"d":"20,711 "},{"v":18906,"d":"18,906 "},{"v":29464,"d":"29,464 "},{"v":42701,"d":"42,701 "},{"v":31752,"d":"31,752 "},{"v":34129,"d":"34,129 "},{"v":32798,"d":"32,798 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":3571,"d":"3,571 "},{"v":7541,"d":"7,541 "},{"v":6136,"d":"6,136 "},{"v":4617,"d":"4,617 "},{"v":6757,"d":"6,757 "},{"v":10854,"d":"10,854 "},{"v":19326,"d":"19,326 "},{"v":17859,"d":"17,859 "},{"v":18020,"d":"18,020 "},{"v":18171,"d":"18,171 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":20695,"d":"20,695 "},{"v":31844,"d":"31,844 "},{"v":28412,"d":"28,412 "},{"v":25328,"d":"25,328 "},{"v":25663,"d":"25,663 "},{"v":40318,"d":"40,318 "},{"v":62027,"d":"62,027 "},{"v":49612,"d":"49,612 "},{"v":52149,"d":"52,149 "},{"v":50968,"d":"50,968 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":8666,"d":"8,666 "},{"v":9189,"d":"9,189 "},{"v":8621,"d":"8,621 "},{"v":8749,"d":"8,749 "},{"v":8555,"d":"8,555 "},{"v":48904,"d":"48,904 "},{"v":52084,"d":"52,084 "},{"v":51916,"d":"51,916 "},{"v":54323,"d":"54,323 "},{"v":59276,"d":"59,276 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":131434,"d":"131,434 "},{"v":113062,"d":"113,062 "},{"v":115430,"d":"115,430 "},{"v":115630,"d":"115,630 "},{"v":136199,"d":"136,199 "},{"v":128647,"d":"128,647 "},{"v":129686,"d":"129,686 "},{"v":131321,"d":"131,321 "},{"v":133985,"d":"133,985 "},{"v":141057,"d":"141,057 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":16807,"d":"16,807 "},{"v":16950,"d":"16,950 "},{"v":24317,"d":"24,317 "},{"v":17478,"d":"17,478 "},{"v":17749,"d":"17,749 "},{"v":22037,"d":"22,037 "},{"v":22047,"d":"22,047 "},{"v":23017,"d":"23,017 "},{"v":23278,"d":"23,278 "},{"v":22323,"d":"22,323 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":177603,"d":"177,603 "},{"v":171045,"d":"171,045 "},{"v":176780,"d":"176,780 "},{"v":167186,"d":"167,186 "},{"v":188166,"d":"188,166 "},{"v":239907,"d":"239,907 "},{"v":265845,"d":"265,845 "},{"v":255866,"d":"255,866 "},{"v":263735,"d":"263,735 "},{"v":273624,"d":"273,624 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":315067,"d":"315,067 "},{"v":316925,"d":"316,925 "},{"v":319045,"d":"319,045 "},{"v":321480,"d":"321,480 "},{"v":326250,"d":"326,250 "},{"v":283301,"d":"283,301 "},{"v":290335,"d":"290,335 "},{"v":293766,"d":"293,766 "},{"v":297421,"d":"297,421 "},{"v":301768,"d":"301,768 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":34285,"d":"34,285 "},{"v":34480,"d":"34,480 "},{"v":34669,"d":"34,669 "},{"v":34409,"d":"34,409 "},{"v":35018,"d":"35,018 "},{"v":30133,"d":"30,133 "},{"v":30222,"d":"30,222 "},{"v":30381,"d":"30,381 "},{"v":29874,"d":"29,874 "},{"v":29885,"d":"29,885 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":150238,"d":"150,238 "},{"v":151913,"d":"151,913 "},{"v":155177,"d":"155,177 "},{"v":156984,"d":"156,984 "},{"v":160204,"d":"160,204 "},{"v":145822,"d":"145,822 "},{"v":148595,"d":"148,595 "},{"v":152982,"d":"152,982 "},{"v":155490,"d":"155,490 "},{"v":157474,"d":"157,474 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":199115,"d":"199,115 "},{"v":199491,"d":"199,491 "},{"v":198537,"d":"198,537 "},{"v":198905,"d":"198,905 "},{"v":201065,"d":"201,065 "},{"v":167612,"d":"167,612 "},{"v":171962,"d":"171,962 "},{"v":171165,"d":"171,165 "},{"v":171805,"d":"171,805 "},{"v":174180,"d":"174,180 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":123525,"d":"123,525 "},{"v":117333,"d":"117,333 "},{"v":117738,"d":"117,738 "},{"v":125306,"d":"125,306 "},{"v":121858,"d":"121,858 "},{"v":221331,"d":"221,331 "},{"v":223060,"d":"223,060 "},{"v":252062,"d":"252,062 "},{"v":253004,"d":"253,004 "},{"v":251222,"d":"251,222 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":500243,"d":"500,243 "},{"v":487870,"d":"487,870 "},{"v":493056,"d":"493,056 "},{"v":491397,"d":"491,397 "},{"v":511089,"d":"511,089 "},{"v":628850,"d":"628,850 "},{"v":660867,"d":"660,867 "},{"v":679093,"d":"679,093 "},{"v":688544,"d":"688,544 "},{"v":699025,"d":"699,025 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":2123,"d":"2,123 "},{"v":2058,"d":"2,058 "},{"v":1818,"d":"1,818 "},{"v":1616,"d":"1,616 "},{"v":1931,"d":"1,931 "},{"v":13723,"d":"13,723 "},{"v":15581,"d":"15,581 "},{"v":15184,"d":"15,184 "},{"v":16959,"d":"16,959 "},{"v":16570,"d":"16,570 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":8009,"d":"8,009 "},{"v":2058,"d":"2,058 "},{"v":2702,"d":"2,702 "},{"v":2900,"d":"2,900 "},{"v":6219,"d":"6,219 "},{"v":5036,"d":"5,036 "},{"v":5802,"d":"5,802 "},{"v":5401,"d":"5,401 "},{"v":7218,"d":"7,218 "},{"v":6855,"d":"6,855 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":75272,"d":"75,272 "},{"v":64658,"d":"64,658 "},{"v":64474,"d":"64,474 "},{"v":64859,"d":"64,859 "},{"v":78110,"d":"78,110 "},{"v":95568,"d":"95,568 "},{"v":95888,"d":"95,888 "},{"v":97572,"d":"97,572 "},{"v":100011,"d":"100,011 "},{"v":107722,"d":"107,722 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":972,"d":"972 "},{"v":2334,"d":"2,334 "},{"v":3278,"d":"3,278 "},{"v":1054,"d":"1,054 "},{"v":1373,"d":"1,373 "},{"v":4900,"d":"4,900 "},{"v":5481,"d":"5,481 "},{"v":6000,"d":"6,000 "},{"v":6226,"d":"6,226 "},{"v":1724,"d":"1,724 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":632,"d":"632 "},{"v":460,"d":"460 "},{"v":712,"d":"712 "},{"v":688,"d":"688 "},{"v":592,"d":"592 "},{"v":3803,"d":"3,803 "},{"v":4406,"d":"4,406 "},{"v":3979,"d":"3,979 "},{"v":3791,"d":"3,791 "},{"v":3847,"d":"3,847 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5883,"d":"5,883 "},{"v":5559,"d":"5,559 "},{"v":7811,"d":"7,811 "},{"v":6707,"d":"6,707 "},{"v":5653,"d":"5,653 "},{"v":8136,"d":"8,136 "},{"v":7074,"d":"7,074 "},{"v":7943,"d":"7,943 "},{"v":11046,"d":"11,046 "},{"v":10861,"d":"10,861 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":52181,"d":"52,181 "},{"v":51826,"d":"51,826 "},{"v":56808,"d":"56,808 "},{"v":54076,"d":"54,076 "},{"v":55455,"d":"55,455 "},{"v":58715,"d":"58,715 "},{"v":62724,"d":"62,724 "},{"v":60921,"d":"60,921 "},{"v":61603,"d":"61,603 "},{"v":65539,"d":"65,539 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":145071,"d":"145,071 "},{"v":128954,"d":"128,954 "},{"v":137602,"d":"137,602 "},{"v":131903,"d":"131,903 "},{"v":149333,"d":"149,333 "},{"v":189881,"d":"189,881 "},{"v":196957,"d":"196,957 "},{"v":197000,"d":"197,000 "},{"v":206854,"d":"206,854 "},{"v":213118,"d":"213,118 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15466,"d":"15,466 "},{"v":14656,"d":"14,656 "},{"v":19743,"d":"19,743 "},{"v":21018,"d":"21,018 "},{"v":23043,"d":"23,043 "},{"v":33625,"d":"33,625 "},{"v":35117,"d":"35,117 "},{"v":40796,"d":"40,796 "},{"v":45085,"d":"45,085 "},{"v":45902,"d":"45,902 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":102882,"d":"102,882 "},{"v":103584,"d":"103,584 "},{"v":103890,"d":"103,890 "},{"v":103366,"d":"103,366 "},{"v":105024,"d":"105,024 "},{"v":109136,"d":"109,136 "},{"v":127870,"d":"127,870 "},{"v":122706,"d":"122,706 "},{"v":123057,"d":"123,057 "},{"v":138140,"d":"138,140 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":41390,"d":"41,390 "},{"v":43801,"d":"43,801 "},{"v":44006,"d":"44,006 "},{"v":45405,"d":"45,405 "},{"v":48702,"d":"48,702 "},{"v":58181,"d":"58,181 "},{"v":58596,"d":"58,596 "},{"v":61509,"d":"61,509 "},{"v":61748,"d":"61,748 "},{"v":64224,"d":"64,224 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":304809,"d":"304,809 "},{"v":290995,"d":"290,995 "},{"v":305241,"d":"305,241 "},{"v":301692,"d":"301,692 "},{"v":326102,"d":"326,102 "},{"v":390822,"d":"390,822 "},{"v":418540,"d":"418,540 "},{"v":422011,"d":"422,011 "},{"v":436744,"d":"436,744 "},{"v":461384,"d":"461,384 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":33546,"d":"33,546 "},{"v":28833,"d":"28,833 "},{"v":26339,"d":"26,339 "},{"v":26925,"d":"26,925 "},{"v":23387,"d":"23,387 "},{"v":47160,"d":"47,160 "},{"v":45595,"d":"45,595 "},{"v":55497,"d":"55,497 "},{"v":45628,"d":"45,628 "},{"v":39011,"d":"39,011 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":161888,"d":"161,888 "},{"v":168042,"d":"168,042 "},{"v":161475,"d":"161,475 "},{"v":162780,"d":"162,780 "},{"v":161600,"d":"161,600 "},{"v":190868,"d":"190,868 "},{"v":196732,"d":"196,732 "},{"v":201585,"d":"201,585 "},{"v":206172,"d":"206,172 "},{"v":198630,"d":"198,630 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":195433,"d":"195,433 "},{"v":196875,"d":"196,875 "},{"v":187814,"d":"187,814 "},{"v":189705,"d":"189,705 "},{"v":184987,"d":"184,987 "},{"v":238028,"d":"238,028 "},{"v":242327,"d":"242,327 "},{"v":257082,"d":"257,082 "},{"v":251800,"d":"251,800 "},{"v":237641,"d":"237,641 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":500243,"d":"500,243 "},{"v":487870,"d":"487,870 "},{"v":493056,"d":"493,056 "},{"v":491397,"d":"491,397 "},{"v":511089,"d":"511,089 "},{"v":628850,"d":"628,850 "},{"v":660867,"d":"660,867 "},{"v":679093,"d":"679,093 "},{"v":688544,"d":"688,544 "},{"v":699025,"d":"699,025 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":32532,"d":"32,532 "},{"v":42091,"d":"42,091 "},{"v":39178,"d":"39,178 "},{"v":35283,"d":"35,283 "},{"v":38833,"d":"38,833 "},{"v":50026,"d":"50,026 "},{"v":68888,"d":"68,888 "},{"v":58865,"d":"58,865 "},{"v":56881,"d":"56,881 "},{"v":60506,"d":"60,506 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",4.14,6.53,5.76,5.15,5.02,6.41,9.39,7.31,7.57,7.29]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",1.73,1.88,1.75,1.78,1.67,7.78,7.88,7.64,7.89,8.48]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",26.27,23.17,23.41,23.53,26.65,20.46,19.62,19.34,19.46,20.18]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":35.5,"d":"35.50"},35.06,35.85,34.02,36.82,38.15,40.23,37.68,{"v":38.3,"d":"38.30"},39.14]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":39.8,"d":"39.80"},40.89,40.27,40.48,39.34,26.65,26.02,{"v":25.2,"d":"25.20"},24.95,24.92]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",3.33,2.08,2.65,2.42,2.82,4.88,4.97,4.79,5.67,5.46]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":29,"d":"29.00"},26.43,27.91,26.84,29.22,30.19,{"v":29.8,"d":"29.80"},29.01,30.04,30.49]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",23.66,24.24,25.07,25.31,25.06,{"v":22.7,"d":"22.70"},24.66,24.08,24.42,26.33]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",60.93,59.65,61.91,61.39,63.81,62.15,63.33,62.14,63.43,{"v":66,"d":"66.00"}]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",39.07,40.35,38.09,38.61,36.19,37.85,36.67,37.86,36.57,{"v":34,"d":"34.00"}]
["  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-2015Q3","index":4,"n_rows":23,"n_cols":9,"rows_kept":23,"merged":[[1,0,1,8],[2,0,2,8],[3,0,4,0],[3,1,3,4],[3,5,3,8],[5,1,5,4],[5,5,5,8]],"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 and Net Income After Tax  \n                                For Corporations in NAICS Retail Trade Subsectors 448 and 452, and All Other Retail Trade Subsectors, \n                                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",{"$nulls":3},"Net income after tax"]
[null,"Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4"]
[null,"(million dollars)",{"$nulls":3},"(million dollars)"]
["All retail"]
["2004 ……………………………………………….",{"v":406507,"d":"406,507 "},{"v":410777,"d":"410,777 "},{"v":422026,"d":"422,026 "},{"v":427135,"d":"427,135 "},{"v":12243,"d":"12,243 "},{"v":14510,"d":"14,510 "},{"v":11185,"d":"11,185 "},{"v":17000,"d":"17,000 "}]
["2005 ……………………………………………….",{"v":437876,"d":"437,876 "},{"v":447797,"d":"447,797 "},{"v":458902,"d":"458,902 "},{"v":467432,"d":"467,432 "},{"v":13185,"d":"13,185 "},{"v":14816,"d":"14,816 "},{"v":14521,"d":"14,521 "},{"v":16042,"d":"16,042 "}]
["2006 ……………………………………………….",{"v":480200,"d":"480,200 "},{"v":493142,"d":"493,142 "},{"v":498014,"d":"498,014 "},{"v":501371,"d":"501,371 "},{"v":16511,"d":"16,511 "},{"v":14913,"d":"14,913 "},{"v":15205,"d":"15,205 "},{"v":16194,"d":"16,194 "}]
["2007 ……………………………………………….",{"v":509881,"d":"509,881 "},{"v":514994,"d":"514,994 "},{"v":516370,"d":"516,370 "},{"v":520440,"d":"520,440 "},{"v":15316,"d":"15,316 "},{"v":18383,"d":"18,383 "},{"v":14459,"d":"14,459 "},{"v":14010,"d":"14,010 "}]
["2008 ……………………………………………….",{"v":523418,"d":"523,418 "},{"v":536533,"d":"536,533 "},{"v":531754,"d":"531,754 "},{"v":500410,"d":"500,410 "},{"v":12223,"d":"12,223 "},{"v":13345,"d":"13,345 "},{"v":9974,"d":"9,974 "},{"v":-6952,"d":"(6,952)"}]
["2009 ……………………………………………….",{"v":496029,"d":"496,029 "},{"v":495324,"d":"495,324 "},{"v":508801,"d":"508,801 "},{"v":519199,"d":"519,199 "},{"v":8472,"d":"8,472 "},{"v":13876,"d":"13,876 "},{"v":13232,"d":"13,232 "},{"v":20593,"d":"20,593 "}]
["2010 ……………………………………………….",{"v":532677,"d":"532,677 "},{"v":534753,"d":"534,753 "},{"v":539765,"d":"539,765 "},{"v":550016,"d":"550,016 "},{"v":16638,"d":"16,638 "},{"v":17231,"d":"17,231 "},{"v":14970,"d":"14,970 "},{"v":19068,"d":"19,068 "}]
["2011 ……………………………………………….",{"v":568164,"d":"568,164 "},{"v":585078,"d":"585,078 "},{"v":586016,"d":"586,016 "},{"v":585582,"d":"585,582 "},{"v":17009,"d":"17,009 "},{"v":18352,"d":"18,352 "},{"v":17244,"d":"17,244 "},{"v":16497,"d":"16,497 "}]
["2012 ……………………………………………….",{"v":604579,"d":"604,579 "},{"v":597862,"d":"597,862 "},{"v":602904,"d":"602,904 "},{"v":610575,"d":"610,575 "},{"v":16595,"d":"16,595 "},{"v":19768,"d":"19,768 "},{"v":16682,"d":"16,682 "},{"v":20549,"d":"20,549 "}]
["2013 ……………………………………………….",{"v":620107,"d":"620,107 "},{"v":626679,"d":"626,679 "},{"v":635936,"d":"635,936 "},{"v":641708,"d":"641,708 "},{"v":17242,"d":"17,242 "},{"v":21805,"d":"21,805 "},{"v":18932,"d":"18,932 "},{"v":22715,"d":"22,715 "}]
["2014 ……………………………………………….",{"v":642057,"d":"642,057 "},{"v":658574,"d":"658,574 "},{"v":665139,"d":"665,139 "},{"v":667747,"d":"667,747 "},{"v":14542,"d":"14,542 "},{"v":21118,"d":"21,118 "},{"v":17687,"d":"17,687 "},{"v":20807,"d":"20,807 "}]
["2015 ……………………………………………….",{"v":653946,"d":"653,946 "},{"v":668276,"d":"668,276 "},{"v":675474,"d":"675,474 "},null,{"v":23036,"d":"23,036 "},{"v":21928,"d":"21,928 "},{"v":19359,"d":"19,359 "}]
[]
["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."]