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

{"sheet":"RET_4_0-2012Q4","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"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":617801,"d":"617,801 "},{"v":589462,"d":"589,462 "},{"v":594420,"d":"594,420 "},{"v":590803,"d":"590,803 "},{"v":633112,"d":"633,112 "},{"v":108870,"d":"108,870 "},{"v":109126,"d":"109,126 "},{"v":110268,"d":"110,268 "},{"v":109835,"d":"109,835 "},{"v":111505,"d":"111,505 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":10955,"d":"10,955 "},{"v":10764,"d":"10,764 "},{"v":11229,"d":"11,229 "},{"v":11243,"d":"11,243 "},{"v":11389,"d":"11,389 "},{"v":2225,"d":"2,225 "},{"v":2050,"d":"2,050 "},{"v":2255,"d":"2,255 "},{"v":2189,"d":"2,189 "},{"v":2183,"d":"2,183 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":574380,"d":"574,380 "},{"v":551062,"d":"551,062 "},{"v":555247,"d":"555,247 "},{"v":555509,"d":"555,509 "},{"v":589191,"d":"589,191 "},{"v":103478,"d":"103,478 "},{"v":103764,"d":"103,764 "},{"v":104503,"d":"104,503 "},{"v":104578,"d":"104,578 "},{"v":105743,"d":"105,743 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":32466,"d":"32,466 "},{"v":27636,"d":"27,636 "},{"v":27944,"d":"27,944 "},{"v":24052,"d":"24,052 "},{"v":32532,"d":"32,532 "},{"v":3167,"d":"3,167 "},{"v":3312,"d":"3,312 "},{"v":3510,"d":"3,510 "},{"v":3068,"d":"3,068 "},{"v":3580,"d":"3,580 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4182,"d":"4,182 "},{"v":4194,"d":"4,194 "},{"v":4204,"d":"4,204 "},{"v":4281,"d":"4,281 "},{"v":4257,"d":"4,257 "},{"v":757,"d":"757 "},{"v":755,"d":"755 "},{"v":744,"d":"744 "},{"v":764,"d":"764 "},{"v":751,"d":"751 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":3569,"d":"3,569 "},{"v":1142,"d":"1,142 "},{"v":4501,"d":"4,501 "},{"v":3679,"d":"3,679 "},{"v":4400,"d":"4,400 "},{"v":-1763,"d":"(1,763)"},{"v":-561,"d":"(561)"},{"v":248,"d":"248 "},{"v":243,"d":"243 "},{"v":-178,"d":"(178)"}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":31853,"d":"31,853 "},{"v":24584,"d":"24,584 "},{"v":28241,"d":"28,241 "},{"v":23449,"d":"23,449 "},{"v":32675,"d":"32,675 "},{"v":647,"d":"647 "},{"v":1996,"d":"1,996 "},{"v":3014,"d":"3,014 "},{"v":2547,"d":"2,547 "},{"v":2650,"d":"2,650 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":12237,"d":"12,237 "},{"v":8816,"d":"8,816 "},{"v":9029,"d":"9,029 "},{"v":8233,"d":"8,233 "},{"v":9610,"d":"9,610 "},{"v":389,"d":"389 "},{"v":927,"d":"927 "},{"v":962,"d":"962 "},{"v":759,"d":"759 "},{"v":908,"d":"908 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":19616,"d":"19,616 "},{"v":15768,"d":"15,768 "},{"v":19212,"d":"19,212 "},{"v":15216,"d":"15,216 "},{"v":23065,"d":"23,065 "},{"v":257,"d":"257 "},{"v":1069,"d":"1,069 "},{"v":2052,"d":"2,052 "},{"v":1788,"d":"1,788 "},{"v":1743,"d":"1,743 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":4260,"d":"4,260 "},{"v":9372,"d":"9,372 "},{"v":3892,"d":"3,892 "},{"v":4475,"d":"4,475 "},{"v":7794,"d":"7,794 "},{"v":444,"d":"444 "},{"v":787,"d":"787 "},{"v":533,"d":"533 "},{"v":260,"d":"260 "},{"v":1327,"d":"1,327 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15356,"d":"15,356 "},{"v":6397,"d":"6,397 "},{"v":15320,"d":"15,320 "},{"v":10741,"d":"10,741 "},{"v":15272,"d":"15,272 "},{"v":-187,"d":"(187)"},{"v":283,"d":"283 "},{"v":1519,"d":"1,519 "},{"v":1528,"d":"1,528 "},{"v":415,"d":"415 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":349911,"d":"349,911 "},{"v":358968,"d":"358,968 "},{"v":352108,"d":"352,108 "},{"v":356024,"d":"356,024 "},{"v":360667,"d":"360,667 "},{"v":34408,"d":"34,408 "},{"v":33971,"d":"33,971 "},{"v":37060,"d":"37,060 "},{"v":37814,"d":"37,814 "},{"v":39258,"d":"39,258 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-7080,"d":"(7,080)"},{"v":-7148,"d":"(7,148)"},{"v":-11303,"d":"(11,303)"},{"v":-4431,"d":"(4,431)"},{"v":-6043,"d":"(6,043)"},{"v":-411,"d":"(411)"},{"v":372,"d":"372 "},{"v":-106,"d":"(106)"},{"v":-230,"d":"(230)"},{"v":-350,"d":"(350)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":358187,"d":"358,187 "},{"v":358217,"d":"358,217 "},{"v":356125,"d":"356,125 "},{"v":362335,"d":"362,335 "},{"v":369895,"d":"369,895 "},{"v":33810,"d":"33,810 "},{"v":34626,"d":"34,626 "},{"v":38473,"d":"38,473 "},{"v":39111,"d":"39,111 "},{"v":39324,"d":"39,324 "}]
["                         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.77,1.83,1.89,{"v":1.9,"d":"1.90"},{"v":1.8,"d":"1.80"},2.04,1.88,2.04,1.99,1.96]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",92.97,93.49,93.41,94.03,93.06,95.05,95.09,94.77,95.21,94.83]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",5.26,4.69,{"v":4.7,"d":"4.70"},4.07,5.14,2.91,3.04,3.18,2.79,3.21]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.68,0.71,0.71,0.72,0.67,{"v":0.7,"d":"0.70"},0.69,0.67,{"v":0.7,"d":"0.70"},0.67]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",0.58,0.19,0.76,0.62,{"v":0.7,"d":"0.70"},{"v":-1.62,"d":"(1.62)"},{"v":-0.51,"d":"(0.51)"},0.22,0.22,{"v":-0.16,"d":"(0.16)"}]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",5.16,4.17,4.75,3.97,5.16,0.59,1.83,2.73,2.32,2.38]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.98,{"v":1.5,"d":"1.50"},1.52,1.39,1.52,0.36,0.85,0.87,0.69,0.81]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",3.18,2.68,3.23,2.58,3.64,0.24,0.98,1.86,1.63,1.56]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",28.43,22.17,24.51,20.07,27.43,5.47,17.38,25.07,21.01,21.61]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",17.51,14.22,16.67,13.02,19.36,2.18,9.31,17.07,14.75,14.21]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",11.55,8.84,9.95,8.03,11.01,{"v":1.8,"d":"1.80"},5.55,8.32,6.97,7.17]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",7.11,5.67,6.77,5.21,7.77,0.71,2.97,5.67,4.89,4.72]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.33,1.31,1.28,1.27,1.27,1.09,1.09,1.12,1.17,1.12]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.26,0.27,0.23,0.21,0.24,0.29,{"v":0.3,"d":"0.30"},{"v":0.3,"d":"0.30"},0.32,{"v":0.3,"d":"0.30"}]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.56,1.51,1.54,1.52,1.53,1.18,1.12,1.22,1.22,{"v":1.2,"d":"1.20"}]
["  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-2012Q4","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"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":59608,"d":"59,608 "},{"v":68254,"d":"68,254 "},{"v":54036,"d":"54,036 "},{"v":52642,"d":"52,642 "},{"v":59346,"d":"59,346 "},{"v":10315,"d":"10,315 "},{"v":10234,"d":"10,234 "},{"v":10103,"d":"10,103 "},{"v":10523,"d":"10,523 "},{"v":10234,"d":"10,234 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":2913,"d":"2,913 "},{"v":2897,"d":"2,897 "},{"v":3434,"d":"3,434 "},{"v":1932,"d":"1,932 "},{"v":1534,"d":"1,534 "},{"v":322,"d":"322 "},{"v":329,"d":"329 "},{"v":318,"d":"318 "},{"v":266,"d":"266 "},{"v":464,"d":"464 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":62522,"d":"62,522 "},{"v":71151,"d":"71,151 "},{"v":57470,"d":"57,470 "},{"v":54573,"d":"54,573 "},{"v":60880,"d":"60,880 "},{"v":10637,"d":"10,637 "},{"v":10563,"d":"10,563 "},{"v":10420,"d":"10,420 "},{"v":10788,"d":"10,788 "},{"v":10698,"d":"10,698 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":18415,"d":"18,415 "},{"v":14948,"d":"14,948 "},{"v":14335,"d":"14,335 "},{"v":14065,"d":"14,065 "},{"v":17677,"d":"17,677 "},{"v":1445,"d":"1,445 "},{"v":1969,"d":"1,969 "},{"v":1763,"d":"1,763 "},{"v":2199,"d":"2,199 "},{"v":1997,"d":"1,997 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":80937,"d":"80,937 "},{"v":86099,"d":"86,099 "},{"v":71806,"d":"71,806 "},{"v":68639,"d":"68,639 "},{"v":78557,"d":"78,557 "},{"v":12082,"d":"12,082 "},{"v":12533,"d":"12,533 "},{"v":12184,"d":"12,184 "},{"v":12988,"d":"12,988 "},{"v":12695,"d":"12,695 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":57140,"d":"57,140 "},{"v":53458,"d":"53,458 "},{"v":52529,"d":"52,529 "},{"v":54975,"d":"54,975 "},{"v":55804,"d":"55,804 "},{"v":5603,"d":"5,603 "},{"v":5368,"d":"5,368 "},{"v":5655,"d":"5,655 "},{"v":5742,"d":"5,742 "},{"v":6137,"d":"6,137 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":234269,"d":"234,269 "},{"v":235037,"d":"235,037 "},{"v":236822,"d":"236,822 "},{"v":261899,"d":"261,899 "},{"v":251680,"d":"251,680 "},{"v":24149,"d":"24,149 "},{"v":23559,"d":"23,559 "},{"v":23614,"d":"23,614 "},{"v":24371,"d":"24,371 "},{"v":24627,"d":"24,627 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":36278,"d":"36,278 "},{"v":37426,"d":"37,426 "},{"v":37423,"d":"37,423 "},{"v":36686,"d":"36,686 "},{"v":36964,"d":"36,964 "},{"v":3808,"d":"3,808 "},{"v":4203,"d":"4,203 "},{"v":4263,"d":"4,263 "},{"v":4295,"d":"4,295 "},{"v":4332,"d":"4,332 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":408624,"d":"408,624 "},{"v":412020,"d":"412,020 "},{"v":398579,"d":"398,579 "},{"v":422199,"d":"422,199 "},{"v":423006,"d":"423,006 "},{"v":45642,"d":"45,642 "},{"v":45662,"d":"45,662 "},{"v":45716,"d":"45,716 "},{"v":47395,"d":"47,395 "},{"v":47791,"d":"47,791 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":634862,"d":"634,862 "},{"v":642397,"d":"642,397 "},{"v":650699,"d":"650,699 "},{"v":658672,"d":"658,672 "},{"v":666336,"d":"666,336 "},{"v":137176,"d":"137,176 "},{"v":138594,"d":"138,594 "},{"v":139290,"d":"139,290 "},{"v":139560,"d":"139,560 "},{"v":140918,"d":"140,918 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":74188,"d":"74,188 "},{"v":74636,"d":"74,636 "},{"v":75716,"d":"75,716 "},{"v":76947,"d":"76,947 "},{"v":77771,"d":"77,771 "},{"v":10688,"d":"10,688 "},{"v":10834,"d":"10,834 "},{"v":11174,"d":"11,174 "},{"v":11175,"d":"11,175 "},{"v":11246,"d":"11,246 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":308580,"d":"308,580 "},{"v":315102,"d":"315,102 "},{"v":319859,"d":"319,859 "},{"v":326357,"d":"326,357 "},{"v":329867,"d":"329,867 "},{"v":71972,"d":"71,972 "},{"v":73419,"d":"73,419 "},{"v":73493,"d":"73,493 "},{"v":74180,"d":"74,180 "},{"v":74924,"d":"74,924 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":400471,"d":"400,471 "},{"v":401931,"d":"401,931 "},{"v":406557,"d":"406,557 "},{"v":409263,"d":"409,263 "},{"v":414240,"d":"414,240 "},{"v":75892,"d":"75,892 "},{"v":76009,"d":"76,009 "},{"v":76971,"d":"76,971 "},{"v":76556,"d":"76,556 "},{"v":77239,"d":"77,239 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":294493,"d":"294,493 "},{"v":297944,"d":"297,944 "},{"v":330221,"d":"330,221 "},{"v":336890,"d":"336,890 "},{"v":349933,"d":"349,933 "},{"v":22527,"d":"22,527 "},{"v":22184,"d":"22,184 "},{"v":22187,"d":"22,187 "},{"v":22213,"d":"22,213 "},{"v":22797,"d":"22,797 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1103587,"d":"1,103,587 "},{"v":1111895,"d":"1,111,895 "},{"v":1135358,"d":"1,135,358 "},{"v":1168351,"d":"1,168,351 "},{"v":1187178,"d":"1,187,178 "},{"v":144062,"d":"144,062 "},{"v":143856,"d":"143,856 "},{"v":144874,"d":"144,874 "},{"v":146164,"d":"146,164 "},{"v":147827,"d":"147,827 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":11259,"d":"11,259 "},{"v":11415,"d":"11,415 "},{"v":12925,"d":"12,925 "},{"v":12754,"d":"12,754 "},{"v":13877,"d":"13,877 "},{"v":530,"d":"530 "},{"v":381,"d":"381 "},{"v":329,"d":"329 "},{"v":315,"d":"315 "},{"v":361,"d":"361 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":9760,"d":"9,760 "},{"v":10384,"d":"10,384 "},{"v":10480,"d":"10,480 "},{"v":13789,"d":"13,789 "},{"v":14662,"d":"14,662 "},{"v":1169,"d":"1,169 "},{"v":92,"d":"92 "},{"v":113,"d":"113 "},{"v":148,"d":"148 "},{"v":291,"d":"291 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":149617,"d":"149,617 "},{"v":151157,"d":"151,157 "},{"v":151538,"d":"151,538 "},{"v":167597,"d":"167,597 "},{"v":164872,"d":"164,872 "},{"v":20267,"d":"20,267 "},{"v":20673,"d":"20,673 "},{"v":20727,"d":"20,727 "},{"v":21020,"d":"21,020 "},{"v":21282,"d":"21,282 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":5580,"d":"5,580 "},{"v":8808,"d":"8,808 "},{"v":5508,"d":"5,508 "},{"v":4152,"d":"4,152 "},{"v":6205,"d":"6,205 "},{"v":686,"d":"686 "},{"v":1008,"d":"1,008 "},{"v":857,"d":"857 "},{"v":754,"d":"754 "},{"v":669,"d":"669 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4088,"d":"4,088 "},{"v":4023,"d":"4,023 "},{"v":3965,"d":"3,965 "},{"v":4268,"d":"4,268 "},{"v":4020,"d":"4,020 "},{"v":787,"d":"787 "},{"v":675,"d":"675 "},{"v":352,"d":"352 "},{"v":462,"d":"462 "},{"v":427,"d":"427 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":19121,"d":"19,121 "},{"v":16856,"d":"16,856 "},{"v":17244,"d":"17,244 "},{"v":18166,"d":"18,166 "},{"v":18218,"d":"18,218 "},{"v":3459,"d":"3,459 "},{"v":4059,"d":"4,059 "},{"v":2547,"d":"2,547 "},{"v":2009,"d":"2,009 "},{"v":3939,"d":"3,939 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":108924,"d":"108,924 "},{"v":111440,"d":"111,440 "},{"v":110500,"d":"110,500 "},{"v":111378,"d":"111,378 "},{"v":110095,"d":"110,095 "},{"v":15018,"d":"15,018 "},{"v":15079,"d":"15,079 "},{"v":15821,"d":"15,821 "},{"v":15871,"d":"15,871 "},{"v":15635,"d":"15,635 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":308349,"d":"308,349 "},{"v":314082,"d":"314,082 "},{"v":312160,"d":"312,160 "},{"v":332105,"d":"332,105 "},{"v":331950,"d":"331,950 "},{"v":41916,"d":"41,916 "},{"v":41966,"d":"41,966 "},{"v":40746,"d":"40,746 "},{"v":40579,"d":"40,579 "},{"v":42604,"d":"42,604 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":56988,"d":"56,988 "},{"v":56779,"d":"56,779 "},{"v":61055,"d":"61,055 "},{"v":62885,"d":"62,885 "},{"v":61437,"d":"61,437 "},{"v":6638,"d":"6,638 "},{"v":7262,"d":"7,262 "},{"v":7045,"d":"7,045 "},{"v":7661,"d":"7,661 "},{"v":7115,"d":"7,115 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":186171,"d":"186,171 "},{"v":193753,"d":"193,753 "},{"v":193056,"d":"193,056 "},{"v":196492,"d":"196,492 "},{"v":199481,"d":"199,481 "},{"v":27426,"d":"27,426 "},{"v":28504,"d":"28,504 "},{"v":29145,"d":"29,145 "},{"v":29035,"d":"29,035 "},{"v":28777,"d":"28,777 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":103937,"d":"103,937 "},{"v":103806,"d":"103,806 "},{"v":108161,"d":"108,161 "},{"v":109458,"d":"109,458 "},{"v":117809,"d":"117,809 "},{"v":20813,"d":"20,813 "},{"v":20180,"d":"20,180 "},{"v":19857,"d":"19,857 "},{"v":20397,"d":"20,397 "},{"v":20274,"d":"20,274 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":655445,"d":"655,445 "},{"v":668421,"d":"668,421 "},{"v":674431,"d":"674,431 "},{"v":700940,"d":"700,940 "},{"v":710678,"d":"710,678 "},{"v":96794,"d":"96,794 "},{"v":97912,"d":"97,912 "},{"v":96793,"d":"96,793 "},{"v":97671,"d":"97,671 "},{"v":98769,"d":"98,769 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":89955,"d":"89,955 "},{"v":85258,"d":"85,258 "},{"v":104802,"d":"104,802 "},{"v":105077,"d":"105,077 "},{"v":106605,"d":"106,605 "},{"v":13458,"d":"13,458 "},{"v":11318,"d":"11,318 "},{"v":9608,"d":"9,608 "},{"v":9382,"d":"9,382 "},{"v":9734,"d":"9,734 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":358187,"d":"358,187 "},{"v":358217,"d":"358,217 "},{"v":356125,"d":"356,125 "},{"v":362335,"d":"362,335 "},{"v":369895,"d":"369,895 "},{"v":33810,"d":"33,810 "},{"v":34626,"d":"34,626 "},{"v":38473,"d":"38,473 "},{"v":39111,"d":"39,111 "},{"v":39324,"d":"39,324 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":448143,"d":"448,143 "},{"v":443474,"d":"443,474 "},{"v":460927,"d":"460,927 "},{"v":467411,"d":"467,411 "},{"v":476501,"d":"476,501 "},{"v":47268,"d":"47,268 "},{"v":45943,"d":"45,943 "},{"v":48081,"d":"48,081 "},{"v":48493,"d":"48,493 "},{"v":49058,"d":"49,058 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1103587,"d":"1,103,587 "},{"v":1111895,"d":"1,111,895 "},{"v":1135358,"d":"1,135,358 "},{"v":1168351,"d":"1,168,351 "},{"v":1187178,"d":"1,187,178 "},{"v":144062,"d":"144,062 "},{"v":143856,"d":"143,856 "},{"v":144874,"d":"144,874 "},{"v":146164,"d":"146,164 "},{"v":147827,"d":"147,827 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":100275,"d":"100,275 "},{"v":97937,"d":"97,937 "},{"v":86420,"d":"86,420 "},{"v":90094,"d":"90,094 "},{"v":91055,"d":"91,055 "},{"v":3726,"d":"3,726 "},{"v":3696,"d":"3,696 "},{"v":4971,"d":"4,971 "},{"v":6817,"d":"6,817 "},{"v":5187,"d":"5,187 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",7.33,7.74,6.32,5.87,6.62,8.39,8.71,8.41,8.89,8.59]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",5.18,4.81,4.63,4.71,{"v":4.7,"d":"4.70"},3.89,3.73,{"v":3.9,"d":"3.90"},3.93,4.15]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",21.23,21.14,20.86,22.42,{"v":21.2,"d":"21.20"},16.76,16.38,{"v":16.3,"d":"16.30"},16.67,16.66]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",37.03,37.06,35.11,36.14,35.63,31.68,31.74,31.56,32.43,32.33]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",36.29,36.15,35.81,35.03,34.89,52.68,52.84,53.13,52.38,52.25]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",4.01,3.84,3.93,4.19,4.28,4.13,3.62,2.31,2.01,3.39]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",27.94,28.25,27.49,28.43,27.96,{"v":29.1,"d":"29.10"},29.17,28.12,27.76,28.82]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.03,22.53,22.38,{"v":22.2,"d":"22.20"},21.98,23.65,24.86,24.98,25.11,24.28]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",59.39,60.12,{"v":59.4,"d":"59.40"},59.99,59.86,67.19,68.06,66.81,66.82,66.81]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",40.61,39.88,{"v":40.6,"d":"40.60"},40.01,40.14,32.81,31.94,33.19,33.18,33.19]
["  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-2012Q4","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"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":228012,"d":"228,012 "},{"v":199040,"d":"199,040 "},{"v":199542,"d":"199,542 "},{"v":199905,"d":"199,905 "},{"v":231991,"d":"231,991 "},{"v":280918,"d":"280,918 "},{"v":281295,"d":"281,295 "},{"v":284611,"d":"284,611 "},{"v":281064,"d":"281,064 "},{"v":289616,"d":"289,616 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":4572,"d":"4,572 "},{"v":4548,"d":"4,548 "},{"v":4710,"d":"4,710 "},{"v":4703,"d":"4,703 "},{"v":4727,"d":"4,727 "},{"v":4158,"d":"4,158 "},{"v":4166,"d":"4,166 "},{"v":4264,"d":"4,264 "},{"v":4352,"d":"4,352 "},{"v":4479,"d":"4,479 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":207429,"d":"207,429 "},{"v":183249,"d":"183,249 "},{"v":184123,"d":"184,123 "},{"v":186285,"d":"186,285 "},{"v":211942,"d":"211,942 "},{"v":263473,"d":"263,473 "},{"v":264049,"d":"264,049 "},{"v":266621,"d":"266,621 "},{"v":264646,"d":"264,646 "},{"v":271507,"d":"271,507 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":16011,"d":"16,011 "},{"v":11243,"d":"11,243 "},{"v":10708,"d":"10,708 "},{"v":8917,"d":"8,917 "},{"v":15321,"d":"15,321 "},{"v":13288,"d":"13,288 "},{"v":13081,"d":"13,081 "},{"v":13726,"d":"13,726 "},{"v":12067,"d":"12,067 "},{"v":13630,"d":"13,630 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1441,"d":"1,441 "},{"v":1528,"d":"1,528 "},{"v":1533,"d":"1,533 "},{"v":1545,"d":"1,545 "},{"v":1495,"d":"1,495 "},{"v":1983,"d":"1,983 "},{"v":1910,"d":"1,910 "},{"v":1928,"d":"1,928 "},{"v":1972,"d":"1,972 "},{"v":2010,"d":"2,010 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":2150,"d":"2,150 "},{"v":2989,"d":"2,989 "},{"v":2834,"d":"2,834 "},{"v":3795,"d":"3,795 "},{"v":3023,"d":"3,023 "},{"v":3181,"d":"3,181 "},{"v":-1286,"d":"(1,286)"},{"v":1420,"d":"1,420 "},{"v":-359,"d":"(359)"},{"v":1555,"d":"1,555 "}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":16720,"d":"16,720 "},{"v":12704,"d":"12,704 "},{"v":12010,"d":"12,010 "},{"v":11167,"d":"11,167 "},{"v":16849,"d":"16,849 "},{"v":14486,"d":"14,486 "},{"v":9884,"d":"9,884 "},{"v":13218,"d":"13,218 "},{"v":9735,"d":"9,735 "},{"v":13176,"d":"13,176 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":7390,"d":"7,390 "},{"v":4033,"d":"4,033 "},{"v":3901,"d":"3,901 "},{"v":3616,"d":"3,616 "},{"v":4879,"d":"4,879 "},{"v":4457,"d":"4,457 "},{"v":3857,"d":"3,857 "},{"v":4167,"d":"4,167 "},{"v":3859,"d":"3,859 "},{"v":3823,"d":"3,823 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":9330,"d":"9,330 "},{"v":8672,"d":"8,672 "},{"v":8109,"d":"8,109 "},{"v":7551,"d":"7,551 "},{"v":11970,"d":"11,970 "},{"v":10029,"d":"10,029 "},{"v":6027,"d":"6,027 "},{"v":9051,"d":"9,051 "},{"v":5877,"d":"5,877 "},{"v":9353,"d":"9,353 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":1857,"d":"1,857 "},{"v":6697,"d":"6,697 "},{"v":960,"d":"960 "},{"v":2258,"d":"2,258 "},{"v":3571,"d":"3,571 "},{"v":1959,"d":"1,959 "},{"v":1888,"d":"1,888 "},{"v":2399,"d":"2,399 "},{"v":1957,"d":"1,957 "},{"v":2895,"d":"2,895 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":7473,"d":"7,473 "},{"v":1975,"d":"1,975 "},{"v":7149,"d":"7,149 "},{"v":5293,"d":"5,293 "},{"v":8399,"d":"8,399 "},{"v":8070,"d":"8,070 "},{"v":4139,"d":"4,139 "},{"v":6652,"d":"6,652 "},{"v":3919,"d":"3,919 "},{"v":6458,"d":"6,458 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":154675,"d":"154,675 "},{"v":155662,"d":"155,662 "},{"v":155387,"d":"155,387 "},{"v":159708,"d":"159,708 "},{"v":162954,"d":"162,954 "},{"v":160828,"d":"160,828 "},{"v":169336,"d":"169,336 "},{"v":159660,"d":"159,660 "},{"v":158503,"d":"158,503 "},{"v":158455,"d":"158,455 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-5783,"d":"(5,783)"},{"v":-2323,"d":"(2,323)"},{"v":-3557,"d":"(3,557)"},{"v":-2543,"d":"(2,543)"},{"v":-4393,"d":"(4,393)"},{"v":-886,"d":"(886)"},{"v":-5197,"d":"(5,197)"},{"v":-7641,"d":"(7,641)"},{"v":-1658,"d":"(1,658)"},{"v":-1301,"d":"(1,301)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":156365,"d":"156,365 "},{"v":155313,"d":"155,313 "},{"v":158980,"d":"158,980 "},{"v":162459,"d":"162,459 "},{"v":166959,"d":"166,959 "},{"v":168012,"d":"168,012 "},{"v":168278,"d":"168,278 "},{"v":158672,"d":"158,672 "},{"v":160765,"d":"160,765 "},{"v":163612,"d":"163,612 "}]
["                         INCOME STATEMENT IN RATIO FORMAT","(percent of net sales)",{"$nulls":4},"(percent of net sales)"]
["     Net sales, receipts, and operating revenues ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment ………………………………………………………………………………………………………………………………………………………………………",{"v":2,"d":"2.00"},2.28,2.36,2.35,2.04,1.48,1.48,{"v":1.5,"d":"1.50"},1.55,1.55]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",90.97,92.07,92.27,93.19,91.36,93.79,93.87,93.68,94.16,93.75]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",7.02,5.65,5.37,4.46,{"v":6.6,"d":"6.60"},4.73,4.65,4.82,4.29,4.71]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.63,0.77,0.77,0.77,0.64,0.71,0.68,0.68,{"v":0.7,"d":"0.70"},0.69]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",0.94,{"v":1.5,"d":"1.50"},1.42,{"v":1.9,"d":"1.90"},{"v":1.3,"d":"1.30"},1.13,{"v":-0.46,"d":"(0.46)"},{"v":0.5,"d":"0.50"},{"v":-0.13,"d":"(0.13)"},0.54]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",7.33,6.38,6.02,5.59,7.26,5.16,3.51,4.64,3.46,4.55]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",3.24,2.03,1.95,1.81,{"v":2.1,"d":"2.10"},1.59,1.37,1.46,1.37,1.32]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",4.09,4.36,4.06,3.78,5.16,3.57,2.14,3.18,2.09,3.23]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",36.42,27.97,26.36,24.15,{"v":35.5,"d":"35.50"},26.67,18.32,22.93,16.65,22.18]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",20.32,19.09,{"v":17.8,"d":"17.80"},16.33,25.22,18.47,11.17,{"v":15.7,"d":"15.70"},10.05,15.75]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15.3,"d":"15.30"},11.49,10.86,9.74,14.94,11.09,7.52,9.65,6.91,8.96]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",8.54,7.84,7.33,6.59,10.61,7.68,4.59,6.61,4.17,6.36]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.31,1.25,1.25,1.22,1.24,1.41,1.42,1.34,1.35,1.34]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.25,0.24,0.21,0.16,{"v":0.2,"d":"0.20"},0.27,{"v":0.3,"d":"0.30"},0.22,0.21,0.25]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.63,1.61,1.59,1.55,1.67,1.61,1.55,{"v":1.6,"d":"1.60"},1.56,1.51]
["  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-2012Q4","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"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 2Q_\n 2012_"," 3Q_\n 2012_"," 4Q_\n 2012_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":20949,"d":"20,949 "},{"v":22617,"d":"22,617 "},{"v":19374,"d":"19,374 "},{"v":16637,"d":"16,637 "},{"v":19322,"d":"19,322 "},{"v":28344,"d":"28,344 "},{"v":35403,"d":"35,403 "},{"v":24559,"d":"24,559 "},{"v":25482,"d":"25,482 "},{"v":29791,"d":"29,791 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":484,"d":"484 "},{"v":438,"d":"438 "},{"v":430,"d":"430 "},{"v":412,"d":"412 "},{"v":362,"d":"362 "},{"v":2107,"d":"2,107 "},{"v":2130,"d":"2,130 "},{"v":2687,"d":"2,687 "},{"v":1254,"d":"1,254 "},{"v":708,"d":"708 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":21434,"d":"21,434 "},{"v":23055,"d":"23,055 "},{"v":19804,"d":"19,804 "},{"v":17049,"d":"17,049 "},{"v":19684,"d":"19,684 "},{"v":30451,"d":"30,451 "},{"v":37533,"d":"37,533 "},{"v":27246,"d":"27,246 "},{"v":26736,"d":"26,736 "},{"v":30499,"d":"30,499 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":6872,"d":"6,872 "},{"v":5568,"d":"5,568 "},{"v":5931,"d":"5,931 "},{"v":5160,"d":"5,160 "},{"v":4923,"d":"4,923 "},{"v":10097,"d":"10,097 "},{"v":7411,"d":"7,411 "},{"v":6641,"d":"6,641 "},{"v":6706,"d":"6,706 "},{"v":10756,"d":"10,756 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":28306,"d":"28,306 "},{"v":28623,"d":"28,623 "},{"v":25735,"d":"25,735 "},{"v":22210,"d":"22,210 "},{"v":24607,"d":"24,607 "},{"v":40548,"d":"40,548 "},{"v":44943,"d":"44,943 "},{"v":33887,"d":"33,887 "},{"v":33441,"d":"33,441 "},{"v":41255,"d":"41,255 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":7271,"d":"7,271 "},{"v":6921,"d":"6,921 "},{"v":6727,"d":"6,727 "},{"v":7152,"d":"7,152 "},{"v":7930,"d":"7,930 "},{"v":44266,"d":"44,266 "},{"v":41169,"d":"41,169 "},{"v":40146,"d":"40,146 "},{"v":42080,"d":"42,080 "},{"v":41737,"d":"41,737 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":99137,"d":"99,137 "},{"v":101230,"d":"101,230 "},{"v":102239,"d":"102,239 "},{"v":120462,"d":"120,462 "},{"v":106750,"d":"106,750 "},{"v":110983,"d":"110,983 "},{"v":110247,"d":"110,247 "},{"v":110969,"d":"110,969 "},{"v":117067,"d":"117,067 "},{"v":120303,"d":"120,303 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15309,"d":"15,309 "},{"v":15198,"d":"15,198 "},{"v":15475,"d":"15,475 "},{"v":14413,"d":"14,413 "},{"v":14025,"d":"14,025 "},{"v":17161,"d":"17,161 "},{"v":18025,"d":"18,025 "},{"v":17685,"d":"17,685 "},{"v":17978,"d":"17,978 "},{"v":18608,"d":"18,608 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":150023,"d":"150,023 "},{"v":151972,"d":"151,972 "},{"v":150177,"d":"150,177 "},{"v":164237,"d":"164,237 "},{"v":153312,"d":"153,312 "},{"v":212958,"d":"212,958 "},{"v":214385,"d":"214,385 "},{"v":202686,"d":"202,686 "},{"v":210566,"d":"210,566 "},{"v":221902,"d":"221,902 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":270206,"d":"270,206 "},{"v":273211,"d":"273,211 "},{"v":277091,"d":"277,091 "},{"v":280070,"d":"280,070 "},{"v":283942,"d":"283,942 "},{"v":227480,"d":"227,480 "},{"v":230592,"d":"230,592 "},{"v":234318,"d":"234,318 "},{"v":239042,"d":"239,042 "},{"v":241475,"d":"241,475 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":30068,"d":"30,068 "},{"v":30377,"d":"30,377 "},{"v":30586,"d":"30,586 "},{"v":31500,"d":"31,500 "},{"v":31921,"d":"31,921 "},{"v":33432,"d":"33,432 "},{"v":33425,"d":"33,425 "},{"v":33956,"d":"33,956 "},{"v":34272,"d":"34,272 "},{"v":34604,"d":"34,604 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":121364,"d":"121,364 "},{"v":123874,"d":"123,874 "},{"v":126551,"d":"126,551 "},{"v":129141,"d":"129,141 "},{"v":131534,"d":"131,534 "},{"v":115244,"d":"115,244 "},{"v":117809,"d":"117,809 "},{"v":119814,"d":"119,814 "},{"v":123036,"d":"123,036 "},{"v":123409,"d":"123,409 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":178910,"d":"178,910 "},{"v":179715,"d":"179,715 "},{"v":181126,"d":"181,126 "},{"v":182429,"d":"182,429 "},{"v":184330,"d":"184,330 "},{"v":145668,"d":"145,668 "},{"v":146208,"d":"146,208 "},{"v":148460,"d":"148,460 "},{"v":150278,"d":"150,278 "},{"v":152670,"d":"152,670 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":108248,"d":"108,248 "},{"v":110748,"d":"110,748 "},{"v":111075,"d":"111,075 "},{"v":111842,"d":"111,842 "},{"v":113500,"d":"113,500 "},{"v":163718,"d":"163,718 "},{"v":165012,"d":"165,012 "},{"v":196960,"d":"196,960 "},{"v":202835,"d":"202,835 "},{"v":213636,"d":"213,636 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":437181,"d":"437,181 "},{"v":442435,"d":"442,435 "},{"v":442378,"d":"442,378 "},{"v":458508,"d":"458,508 "},{"v":451143,"d":"451,143 "},{"v":522344,"d":"522,344 "},{"v":525605,"d":"525,605 "},{"v":548106,"d":"548,106 "},{"v":563679,"d":"563,679 "},{"v":588208,"d":"588,208 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":678,"d":"678 "},{"v":805,"d":"805 "},{"v":1042,"d":"1,042 "},{"v":1295,"d":"1,295 "},{"v":1210,"d":"1,210 "},{"v":10050,"d":"10,050 "},{"v":10229,"d":"10,229 "},{"v":11553,"d":"11,553 "},{"v":11145,"d":"11,145 "},{"v":12307,"d":"12,307 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":4958,"d":"4,958 "},{"v":7020,"d":"7,020 "},{"v":6819,"d":"6,819 "},{"v":10090,"d":"10,090 "},{"v":8791,"d":"8,791 "},{"v":3633,"d":"3,633 "},{"v":3272,"d":"3,272 "},{"v":3548,"d":"3,548 "},{"v":3550,"d":"3,550 "},{"v":5579,"d":"5,579 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":54481,"d":"54,481 "},{"v":57816,"d":"57,816 "},{"v":57396,"d":"57,396 "},{"v":67973,"d":"67,973 "},{"v":60070,"d":"60,070 "},{"v":74869,"d":"74,869 "},{"v":72669,"d":"72,669 "},{"v":73415,"d":"73,415 "},{"v":78605,"d":"78,605 "},{"v":83520,"d":"83,520 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":2688,"d":"2,688 "},{"v":4091,"d":"4,091 "},{"v":2044,"d":"2,044 "},{"v":1552,"d":"1,552 "},{"v":3342,"d":"3,342 "},{"v":2206,"d":"2,206 "},{"v":3710,"d":"3,710 "},{"v":2608,"d":"2,608 "},{"v":1846,"d":"1,846 "},{"v":2195,"d":"2,195 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":280,"d":"280 "},{"v":267,"d":"267 "},{"v":243,"d":"243 "},{"v":257,"d":"257 "},{"v":310,"d":"310 "},{"v":3022,"d":"3,022 "},{"v":3081,"d":"3,081 "},{"v":3370,"d":"3,370 "},{"v":3549,"d":"3,549 "},{"v":3284,"d":"3,284 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":8345,"d":"8,345 "},{"v":6619,"d":"6,619 "},{"v":8179,"d":"8,179 "},{"v":9274,"d":"9,274 "},{"v":6285,"d":"6,285 "},{"v":7317,"d":"7,317 "},{"v":6178,"d":"6,178 "},{"v":6518,"d":"6,518 "},{"v":6883,"d":"6,883 "},{"v":7995,"d":"7,995 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":43467,"d":"43,467 "},{"v":44673,"d":"44,673 "},{"v":44786,"d":"44,786 "},{"v":44708,"d":"44,708 "},{"v":43725,"d":"43,725 "},{"v":50439,"d":"50,439 "},{"v":51689,"d":"51,689 "},{"v":49893,"d":"49,893 "},{"v":50800,"d":"50,800 "},{"v":50735,"d":"50,735 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":114896,"d":"114,896 "},{"v":121290,"d":"121,290 "},{"v":120510,"d":"120,510 "},{"v":135150,"d":"135,150 "},{"v":123732,"d":"123,732 "},{"v":151536,"d":"151,536 "},{"v":150826,"d":"150,826 "},{"v":150904,"d":"150,904 "},{"v":156376,"d":"156,376 "},{"v":165614,"d":"165,614 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":14443,"d":"14,443 "},{"v":14062,"d":"14,062 "},{"v":14529,"d":"14,529 "},{"v":15342,"d":"15,342 "},{"v":14817,"d":"14,817 "},{"v":35906,"d":"35,906 "},{"v":35455,"d":"35,455 "},{"v":39481,"d":"39,481 "},{"v":39883,"d":"39,883 "},{"v":39506,"d":"39,506 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":83974,"d":"83,974 "},{"v":84426,"d":"84,426 "},{"v":83956,"d":"83,956 "},{"v":82715,"d":"82,715 "},{"v":82449,"d":"82,449 "},{"v":74771,"d":"74,771 "},{"v":80824,"d":"80,824 "},{"v":79955,"d":"79,955 "},{"v":84742,"d":"84,742 "},{"v":88255,"d":"88,255 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":40221,"d":"40,221 "},{"v":40957,"d":"40,957 "},{"v":41142,"d":"41,142 "},{"v":40324,"d":"40,324 "},{"v":40282,"d":"40,282 "},{"v":42904,"d":"42,904 "},{"v":42669,"d":"42,669 "},{"v":47161,"d":"47,161 "},{"v":48738,"d":"48,738 "},{"v":57252,"d":"57,252 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":253534,"d":"253,534 "},{"v":260734,"d":"260,734 "},{"v":260137,"d":"260,137 "},{"v":273530,"d":"273,530 "},{"v":261281,"d":"261,281 "},{"v":305117,"d":"305,117 "},{"v":309774,"d":"309,774 "},{"v":317502,"d":"317,502 "},{"v":329739,"d":"329,739 "},{"v":350627,"d":"350,627 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":27282,"d":"27,282 "},{"v":26388,"d":"26,388 "},{"v":23262,"d":"23,262 "},{"v":22519,"d":"22,519 "},{"v":22903,"d":"22,903 "},{"v":49216,"d":"49,216 "},{"v":47552,"d":"47,552 "},{"v":71932,"d":"71,932 "},{"v":73176,"d":"73,176 "},{"v":73969,"d":"73,969 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":156365,"d":"156,365 "},{"v":155313,"d":"155,313 "},{"v":158980,"d":"158,980 "},{"v":162459,"d":"162,459 "},{"v":166959,"d":"166,959 "},{"v":168012,"d":"168,012 "},{"v":168278,"d":"168,278 "},{"v":158672,"d":"158,672 "},{"v":160765,"d":"160,765 "},{"v":163612,"d":"163,612 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":183647,"d":"183,647 "},{"v":181701,"d":"181,701 "},{"v":182241,"d":"182,241 "},{"v":184978,"d":"184,978 "},{"v":189862,"d":"189,862 "},{"v":217228,"d":"217,228 "},{"v":215830,"d":"215,830 "},{"v":230604,"d":"230,604 "},{"v":233941,"d":"233,941 "},{"v":237581,"d":"237,581 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":437181,"d":"437,181 "},{"v":442435,"d":"442,435 "},{"v":442378,"d":"442,378 "},{"v":458508,"d":"458,508 "},{"v":451143,"d":"451,143 "},{"v":522344,"d":"522,344 "},{"v":525605,"d":"525,605 "},{"v":548106,"d":"548,106 "},{"v":563679,"d":"563,679 "},{"v":588208,"d":"588,208 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":35127,"d":"35,127 "},{"v":30682,"d":"30,682 "},{"v":29668,"d":"29,668 "},{"v":29088,"d":"29,088 "},{"v":29580,"d":"29,580 "},{"v":61422,"d":"61,422 "},{"v":63559,"d":"63,559 "},{"v":51781,"d":"51,781 "},{"v":54190,"d":"54,190 "},{"v":56288,"d":"56,288 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",6.47,6.47,5.82,4.84,5.45,7.76,8.55,6.18,5.93,7.01]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",1.66,1.56,1.52,1.56,1.76,8.47,7.83,7.32,7.47,{"v":7.1,"d":"7.10"}]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.68,22.88,23.11,26.27,23.66,21.25,20.98,20.25,20.77,20.45]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",34.32,34.35,33.95,35.82,33.98,40.77,40.79,36.98,37.36,37.73]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",40.92,40.62,40.94,39.79,40.86,27.89,27.82,27.09,26.66,25.96]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",3.26,3.33,3.68,4.56,3.68,{"v":4.6,"d":"4.60"},4.33,4.56,4.46,4.96]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",26.28,27.41,27.24,29.48,27.43,29.01,{"v":28.7,"d":"28.70"},27.53,27.74,28.16]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.51,22.26,22.26,21.39,21.56,21.19,22.12,21.79,22.11,21.72]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",57.99,58.93,{"v":58.8,"d":"58.80"},59.66,57.92,58.41,58.94,57.93,{"v":58.5,"d":"58.50"},59.61]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",42.01,41.07,{"v":41.2,"d":"41.20"},40.34,42.08,41.59,41.06,42.07,{"v":41.5,"d":"41.50"},40.39]
["  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-2012Q4","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"]
["2001 …………………………………………………………………………………………...………………………………………………..",{"v":330908,"d":"330,908 "},{"v":336728,"d":"336,728 "},{"v":339849,"d":"339,849 "},{"v":347739,"d":"347,739 "}]
["2002 …………………………………………………………………………………………...………………………………………………..",{"v":349167,"d":"349,167 "},{"v":354920,"d":"354,920 "},{"v":359666,"d":"359,666 "},{"v":357350,"d":"357,350 "}]
["2003 …………………………………………………………………………………………...………………………………………………..",{"v":366832,"d":"366,832 "},{"v":369624,"d":"369,624 "},{"v":391641,"d":"391,641 "},{"v":399030,"d":"399,030 "}]
["2004 …………………………………………………………………………………………...………………………………………………..",{"v":406941,"d":"406,941 "},{"v":410212,"d":"410,212 "},{"v":421875,"d":"421,875 "},{"v":427383,"d":"427,383 "}]
["2005 …………………………………………………………………………………………...………………………………………………..",{"v":438346,"d":"438,346 "},{"v":447203,"d":"447,203 "},{"v":458761,"d":"458,761 "},{"v":467807,"d":"467,807 "}]
["2006 …………………………………………………………………………………………...………………………………………………..",{"v":480550,"d":"480,550 "},{"v":492469,"d":"492,469 "},{"v":497921,"d":"497,921 "},{"v":502008,"d":"502,008 "}]
["2007 …………………………………………………………………………………………...………………………………………………..",{"v":509909,"d":"509,909 "},{"v":514401,"d":"514,401 "},{"v":516206,"d":"516,206 "},{"v":521372,"d":"521,372 "}]
["2008 …………………………………………………………………………………………...………………………………………………..",{"v":523155,"d":"523,155 "},{"v":535966,"d":"535,966 "},{"v":531594,"d":"531,594 "},{"v":501639,"d":"501,639 "}]
["2009 …………………………………………………………………………………………...………………………………………………..",{"v":495379,"d":"495,379 "},{"v":494853,"d":"494,853 "},{"v":508579,"d":"508,579 "},{"v":521047,"d":"521,047 "}]
["2010 …………………………………………………………………………………………...………………………………………………..",{"v":531218,"d":"531,218 "},{"v":534266,"d":"534,266 "},{"v":539858,"d":"539,858 "},{"v":552385,"d":"552,385 "}]
["2011 …………………………………………………………………………………………...………………………………………………..",{"v":565725,"d":"565,725 "},{"v":584678,"d":"584,678 "},{"v":586503,"d":"586,503 "},{"v":588479,"d":"588,479 "}]
["2012 …………………………………………………………………………………………...………………………………………………..",{"v":601103,"d":"601,103 "},{"v":598026,"d":"598,026 "},{"v":604990,"d":"604,990 "},{"v":603584,"d":"603,584 "}]
[]
["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."]