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

{"sheet":"RET_4_0-2012Q1","index":0,"n_rows":47,"n_cols":11,"rows_kept":47,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[22,1,22,4],[22,6,22,9],[33,1,33,4],[33,6,33,9],[46,0,46,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 4.0 -- Income Statement  For Corporations in NAICS Retail Trade Sector, and Retail Trade Subsector 445,\n                              Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"All Retail Trade\nTotal Assets $50 Million and Over",{"$nulls":4},"Food and Beverage Stores\nTotal Assets $50 Million and Over"]
["Item"," 1Q_\n 2011_"," 2Q_\n 2011_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 1Q_\n 2011_"," 2Q_\n 2011_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":554383,"d":"554,383 "},{"v":574993,"d":"574,993 "},{"v":568064,"d":"568,064 "},{"v":621026,"d":"621,026 "},{"v":594905,"d":"594,905 "},{"v":104533,"d":"104,533 "},{"v":107428,"d":"107,428 "},{"v":104170,"d":"104,170 "},{"v":108918,"d":"108,918 "},{"v":108454,"d":"108,454 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":10775,"d":"10,775 "},{"v":10903,"d":"10,903 "},{"v":10867,"d":"10,867 "},{"v":11064,"d":"11,064 "},{"v":10858,"d":"10,858 "},{"v":2156,"d":"2,156 "},{"v":2184,"d":"2,184 "},{"v":2160,"d":"2,160 "},{"v":2227,"d":"2,227 "},{"v":2014,"d":"2,014 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":517431,"d":"517,431 "},{"v":537550,"d":"537,550 "},{"v":533882,"d":"533,882 "},{"v":577336,"d":"577,336 "},{"v":556067,"d":"556,067 "},{"v":99067,"d":"99,067 "},{"v":101983,"d":"101,983 "},{"v":99224,"d":"99,224 "},{"v":103517,"d":"103,517 "},{"v":103199,"d":"103,199 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":26177,"d":"26,177 "},{"v":26540,"d":"26,540 "},{"v":23316,"d":"23,316 "},{"v":32627,"d":"32,627 "},{"v":27980,"d":"27,980 "},{"v":3310,"d":"3,310 "},{"v":3261,"d":"3,261 "},{"v":2785,"d":"2,785 "},{"v":3174,"d":"3,174 "},{"v":3241,"d":"3,241 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":4285,"d":"4,285 "},{"v":4344,"d":"4,344 "},{"v":4246,"d":"4,246 "},{"v":4233,"d":"4,233 "},{"v":4229,"d":"4,229 "},{"v":807,"d":"807 "},{"v":747,"d":"747 "},{"v":738,"d":"738 "},{"v":760,"d":"760 "},{"v":753,"d":"753 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":2809,"d":"2,809 "},{"v":3757,"d":"3,757 "},{"v":4196,"d":"4,196 "},{"v":3515,"d":"3,515 "},{"v":1051,"d":"1,051 "},{"v":266,"d":"266 "},{"v":233,"d":"233 "},{"v":153,"d":"153 "},{"v":-1788,"d":"(1,788)"},{"v":-576,"d":"(576)"}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":24702,"d":"24,702 "},{"v":25954,"d":"25,954 "},{"v":23266,"d":"23,266 "},{"v":31909,"d":"31,909 "},{"v":24801,"d":"24,801 "},{"v":2769,"d":"2,769 "},{"v":2747,"d":"2,747 "},{"v":2201,"d":"2,201 "},{"v":626,"d":"626 "},{"v":1912,"d":"1,912 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":8580,"d":"8,580 "},{"v":8542,"d":"8,542 "},{"v":7646,"d":"7,646 "},{"v":12319,"d":"12,319 "},{"v":8443,"d":"8,443 "},{"v":1059,"d":"1,059 "},{"v":907,"d":"907 "},{"v":671,"d":"671 "},{"v":388,"d":"388 "},{"v":491,"d":"491 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":16122,"d":"16,122 "},{"v":17412,"d":"17,412 "},{"v":15621,"d":"15,621 "},{"v":19590,"d":"19,590 "},{"v":16358,"d":"16,358 "},{"v":1709,"d":"1,709 "},{"v":1840,"d":"1,840 "},{"v":1530,"d":"1,530 "},{"v":239,"d":"239 "},{"v":1421,"d":"1,421 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":8859,"d":"8,859 "},{"v":4660,"d":"4,660 "},{"v":3198,"d":"3,198 "},{"v":4230,"d":"4,230 "},{"v":4140,"d":"4,140 "},{"v":760,"d":"760 "},{"v":1536,"d":"1,536 "},{"v":299,"d":"299 "},{"v":446,"d":"446 "},{"v":805,"d":"805 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":7263,"d":"7,263 "},{"v":12752,"d":"12,752 "},{"v":12422,"d":"12,422 "},{"v":15360,"d":"15,360 "},{"v":12218,"d":"12,218 "},{"v":949,"d":"949 "},{"v":305,"d":"305 "},{"v":1230,"d":"1,230 "},{"v":-208,"d":"(208)"},{"v":615,"d":"615 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":332289,"d":"332,289 "},{"v":332449,"d":"332,449 "},{"v":342022,"d":"342,022 "},{"v":349277,"d":"349,277 "},{"v":357036,"d":"357,036 "},{"v":31854,"d":"31,854 "},{"v":32826,"d":"32,826 "},{"v":33381,"d":"33,381 "},{"v":34415,"d":"34,415 "},{"v":33679,"d":"33,679 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-6693,"d":"(6,693)"},{"v":-5701,"d":"(5,701)"},{"v":-4257,"d":"(4,257)"},{"v":-7245,"d":"(7,245)"},{"v":-11953,"d":"(11,953)"},{"v":1,"d":"1 "},{"v":-196,"d":"(196)"},{"v":-321,"d":"(321)"},{"v":-412,"d":"(412)"},{"v":293,"d":"293 "}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":332859,"d":"332,859 "},{"v":339500,"d":"339,500 "},{"v":350187,"d":"350,187 "},{"v":357393,"d":"357,393 "},{"v":357301,"d":"357,301 "},{"v":32804,"d":"32,804 "},{"v":32935,"d":"32,935 "},{"v":34291,"d":"34,291 "},{"v":33795,"d":"33,795 "},{"v":34587,"d":"34,587 "}]
["                         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.94,{"v":1.9,"d":"1.90"},1.91,1.78,1.83,2.06,2.03,2.07,2.04,1.86]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",93.33,93.49,93.98,92.96,93.47,94.77,94.93,95.25,95.04,95.15]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",4.72,4.62,{"v":4.1,"d":"4.10"},5.25,{"v":4.7,"d":"4.70"},3.17,3.04,2.67,2.91,2.99]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",0.77,0.76,0.75,0.68,0.71,0.77,{"v":0.7,"d":"0.70"},0.71,{"v":0.7,"d":"0.70"},0.69]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",0.51,0.65,0.74,0.57,0.18,0.25,0.22,0.15,{"v":-1.64,"d":"(1.64)"},{"v":-0.53,"d":"(0.53)"}]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",4.46,4.51,{"v":4.1,"d":"4.10"},5.14,4.17,2.65,2.56,2.11,0.57,1.76]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.55,1.49,1.35,1.98,1.42,1.01,0.84,0.64,0.36,0.45]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",2.91,3.03,2.75,3.15,2.75,1.64,1.71,1.47,0.22,1.31]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",21.87,22.97,20.89,28.42,22.31,23.51,23.49,18.59,5.31,16.42]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",14.28,15.41,14.02,17.45,14.71,14.52,15.73,12.92,2.02,{"v":12.2,"d":"12.20"}]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",9.13,9.49,8.42,11.47,8.85,7.81,7.74,6.16,1.74,5.35]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",5.96,6.36,5.65,7.04,5.84,4.82,5.18,4.28,0.66,3.97]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.39,1.33,{"v":1.3,"d":"1.30"},1.31,{"v":1.3,"d":"1.30"},1.14,{"v":1.1,"d":"1.10"},1.07,1.09,1.09]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",0.29,0.26,0.22,0.26,0.27,{"v":0.3,"d":"0.30"},{"v":0.3,"d":"0.30"},0.29,0.29,0.29]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.65,1.61,1.55,1.56,1.51,1.19,1.18,{"v":1.2,"d":"1.20"},1.18,1.13]
["  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-2012Q1","index":1,"n_rows":61,"n_cols":11,"rows_kept":61,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[49,1,49,4],[49,6,49,9],[60,0,60,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 4.1 -- Balance Sheet  For Corporations in NAICS Retail Trade Sector, and Retail Trade Subsector 445,\n                               Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"All Retail Trade\nTotal Assets $50 Million and Over",{"$nulls":4},"Food and Beverage Stores\nTotal Assets $50 Million and Over"]
["Item"," 1Q_\n 2011_"," 2Q_\n 2011_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 1Q_\n 2011_"," 2Q_\n 2011_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":61825,"d":"61,825 "},{"v":56377,"d":"56,377 "},{"v":52070,"d":"52,070 "},{"v":59474,"d":"59,474 "},{"v":68490,"d":"68,490 "},{"v":9651,"d":"9,651 "},{"v":9983,"d":"9,983 "},{"v":10180,"d":"10,180 "},{"v":10314,"d":"10,314 "},{"v":9947,"d":"9,947 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":2310,"d":"2,310 "},{"v":2407,"d":"2,407 "},{"v":2048,"d":"2,048 "},{"v":2435,"d":"2,435 "},{"v":2333,"d":"2,333 "},{"v":202,"d":"202 "},{"v":246,"d":"246 "},{"v":294,"d":"294 "},{"v":322,"d":"322 "},{"v":335,"d":"335 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":64135,"d":"64,135 "},{"v":58784,"d":"58,784 "},{"v":54119,"d":"54,119 "},{"v":61908,"d":"61,908 "},{"v":70823,"d":"70,823 "},{"v":9853,"d":"9,853 "},{"v":10230,"d":"10,230 "},{"v":10473,"d":"10,473 "},{"v":10635,"d":"10,635 "},{"v":10282,"d":"10,282 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":18278,"d":"18,278 "},{"v":17516,"d":"17,516 "},{"v":14397,"d":"14,397 "},{"v":19123,"d":"19,123 "},{"v":15277,"d":"15,277 "},{"v":1356,"d":"1,356 "},{"v":1620,"d":"1,620 "},{"v":1465,"d":"1,465 "},{"v":1428,"d":"1,428 "},{"v":1595,"d":"1,595 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":82413,"d":"82,413 "},{"v":76300,"d":"76,300 "},{"v":68515,"d":"68,515 "},{"v":81032,"d":"81,032 "},{"v":86100,"d":"86,100 "},{"v":11209,"d":"11,209 "},{"v":11849,"d":"11,849 "},{"v":11939,"d":"11,939 "},{"v":12063,"d":"12,063 "},{"v":11877,"d":"11,877 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":51086,"d":"51,086 "},{"v":52380,"d":"52,380 "},{"v":53335,"d":"53,335 "},{"v":58014,"d":"58,014 "},{"v":54603,"d":"54,603 "},{"v":5199,"d":"5,199 "},{"v":5283,"d":"5,283 "},{"v":5423,"d":"5,423 "},{"v":5600,"d":"5,600 "},{"v":5335,"d":"5,335 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":228806,"d":"228,806 "},{"v":231210,"d":"231,210 "},{"v":253827,"d":"253,827 "},{"v":235988,"d":"235,988 "},{"v":237357,"d":"237,357 "},{"v":22607,"d":"22,607 "},{"v":23079,"d":"23,079 "},{"v":23980,"d":"23,980 "},{"v":24149,"d":"24,149 "},{"v":23562,"d":"23,562 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":35490,"d":"35,490 "},{"v":35652,"d":"35,652 "},{"v":35253,"d":"35,253 "},{"v":35810,"d":"35,810 "},{"v":37202,"d":"37,202 "},{"v":4422,"d":"4,422 "},{"v":3346,"d":"3,346 "},{"v":3417,"d":"3,417 "},{"v":3814,"d":"3,814 "},{"v":4162,"d":"4,162 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":397794,"d":"397,794 "},{"v":395542,"d":"395,542 "},{"v":410930,"d":"410,930 "},{"v":410843,"d":"410,843 "},{"v":415262,"d":"415,262 "},{"v":43438,"d":"43,438 "},{"v":43558,"d":"43,558 "},{"v":44759,"d":"44,759 "},{"v":45627,"d":"45,627 "},{"v":44936,"d":"44,936 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":614396,"d":"614,396 "},{"v":626350,"d":"626,350 "},{"v":630590,"d":"630,590 "},{"v":637543,"d":"637,543 "},{"v":644909,"d":"644,909 "},{"v":132372,"d":"132,372 "},{"v":134817,"d":"134,817 "},{"v":135301,"d":"135,301 "},{"v":137062,"d":"137,062 "},{"v":138177,"d":"138,177 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":73435,"d":"73,435 "},{"v":74010,"d":"74,010 "},{"v":74492,"d":"74,492 "},{"v":75157,"d":"75,157 "},{"v":75496,"d":"75,496 "},{"v":10598,"d":"10,598 "},{"v":10731,"d":"10,731 "},{"v":10795,"d":"10,795 "},{"v":10676,"d":"10,676 "},{"v":10790,"d":"10,790 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":295334,"d":"295,334 "},{"v":302294,"d":"302,294 "},{"v":304803,"d":"304,803 "},{"v":310647,"d":"310,647 "},{"v":317163,"d":"317,163 "},{"v":68224,"d":"68,224 "},{"v":69985,"d":"69,985 "},{"v":70610,"d":"70,610 "},{"v":71997,"d":"71,997 "},{"v":73023,"d":"73,023 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":392497,"d":"392,497 "},{"v":398065,"d":"398,065 "},{"v":400279,"d":"400,279 "},{"v":402052,"d":"402,052 "},{"v":403242,"d":"403,242 "},{"v":74747,"d":"74,747 "},{"v":75563,"d":"75,563 "},{"v":75485,"d":"75,485 "},{"v":75741,"d":"75,741 "},{"v":75944,"d":"75,944 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":291816,"d":"291,816 "},{"v":300657,"d":"300,657 "},{"v":294468,"d":"294,468 "},{"v":299668,"d":"299,668 "},{"v":302205,"d":"302,205 "},{"v":23562,"d":"23,562 "},{"v":22937,"d":"22,937 "},{"v":22650,"d":"22,650 "},{"v":22534,"d":"22,534 "},{"v":22203,"d":"22,203 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1082107,"d":"1,082,107 "},{"v":1094264,"d":"1,094,264 "},{"v":1105676,"d":"1,105,676 "},{"v":1112564,"d":"1,112,564 "},{"v":1120709,"d":"1,120,709 "},{"v":141747,"d":"141,747 "},{"v":142057,"d":"142,057 "},{"v":142894,"d":"142,894 "},{"v":143902,"d":"143,902 "},{"v":143083,"d":"143,083 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":10284,"d":"10,284 "},{"v":9614,"d":"9,614 "},{"v":9969,"d":"9,969 "},{"v":11359,"d":"11,359 "},{"v":11160,"d":"11,160 "},{"v":394,"d":"394 "},{"v":384,"d":"384 "},{"v":378,"d":"378 "},{"v":524,"d":"524 "},{"v":380,"d":"380 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":6618,"d":"6,618 "},{"v":11196,"d":"11,196 "},{"v":17218,"d":"17,218 "},{"v":9929,"d":"9,929 "},{"v":11014,"d":"11,014 "},{"v":92,"d":"92 "},{"v":673,"d":"673 "},{"v":1081,"d":"1,081 "},{"v":1172,"d":"1,172 "},{"v":472,"d":"472 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":144019,"d":"144,019 "},{"v":146969,"d":"146,969 "},{"v":156423,"d":"156,423 "},{"v":151313,"d":"151,313 "},{"v":152722,"d":"152,722 "},{"v":18876,"d":"18,876 "},{"v":19628,"d":"19,628 "},{"v":19573,"d":"19,573 "},{"v":20290,"d":"20,290 "},{"v":20274,"d":"20,274 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":5873,"d":"5,873 "},{"v":4501,"d":"4,501 "},{"v":3423,"d":"3,423 "},{"v":5675,"d":"5,675 "},{"v":8626,"d":"8,626 "},{"v":963,"d":"963 "},{"v":760,"d":"760 "},{"v":481,"d":"481 "},{"v":684,"d":"684 "},{"v":915,"d":"915 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":3840,"d":"3,840 "},{"v":3848,"d":"3,848 "},{"v":4098,"d":"4,098 "},{"v":3962,"d":"3,962 "},{"v":3912,"d":"3,912 "},{"v":813,"d":"813 "},{"v":852,"d":"852 "},{"v":883,"d":"883 "},{"v":790,"d":"790 "},{"v":698,"d":"698 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":11113,"d":"11,113 "},{"v":14276,"d":"14,276 "},{"v":15741,"d":"15,741 "},{"v":19129,"d":"19,129 "},{"v":16885,"d":"16,885 "},{"v":2064,"d":"2,064 "},{"v":2541,"d":"2,541 "},{"v":3516,"d":"3,516 "},{"v":3456,"d":"3,456 "},{"v":3638,"d":"3,638 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":105418,"d":"105,418 "},{"v":106209,"d":"106,209 "},{"v":109555,"d":"109,555 "},{"v":111352,"d":"111,352 "},{"v":113983,"d":"113,983 "},{"v":14739,"d":"14,739 "},{"v":14919,"d":"14,919 "},{"v":15746,"d":"15,746 "},{"v":15007,"d":"15,007 "},{"v":14760,"d":"14,760 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":287164,"d":"287,164 "},{"v":296613,"d":"296,613 "},{"v":316427,"d":"316,427 "},{"v":312720,"d":"312,720 "},{"v":318302,"d":"318,302 "},{"v":37942,"d":"37,942 "},{"v":39757,"d":"39,757 "},{"v":41658,"d":"41,658 "},{"v":41923,"d":"41,923 "},{"v":41136,"d":"41,136 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":44320,"d":"44,320 "},{"v":45916,"d":"45,916 "},{"v":47986,"d":"47,986 "},{"v":47199,"d":"47,199 "},{"v":47121,"d":"47,121 "},{"v":6493,"d":"6,493 "},{"v":6584,"d":"6,584 "},{"v":6329,"d":"6,329 "},{"v":6633,"d":"6,633 "},{"v":7168,"d":"7,168 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":197816,"d":"197,816 "},{"v":196208,"d":"196,208 "},{"v":193229,"d":"193,229 "},{"v":196822,"d":"196,822 "},{"v":204585,"d":"204,585 "},{"v":29577,"d":"29,577 "},{"v":28632,"d":"28,632 "},{"v":27230,"d":"27,230 "},{"v":27492,"d":"27,492 "},{"v":28788,"d":"28,788 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":101065,"d":"101,065 "},{"v":103536,"d":"103,536 "},{"v":102473,"d":"102,473 "},{"v":106757,"d":"106,757 "},{"v":106022,"d":"106,022 "},{"v":20634,"d":"20,634 "},{"v":20296,"d":"20,296 "},{"v":20325,"d":"20,325 "},{"v":20656,"d":"20,656 "},{"v":19405,"d":"19,405 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":630366,"d":"630,366 "},{"v":642274,"d":"642,274 "},{"v":660116,"d":"660,116 "},{"v":663498,"d":"663,498 "},{"v":676030,"d":"676,030 "},{"v":94646,"d":"94,646 "},{"v":95269,"d":"95,269 "},{"v":95542,"d":"95,542 "},{"v":96704,"d":"96,704 "},{"v":96497,"d":"96,497 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":118882,"d":"118,882 "},{"v":112491,"d":"112,491 "},{"v":95374,"d":"95,374 "},{"v":91673,"d":"91,673 "},{"v":87377,"d":"87,377 "},{"v":14297,"d":"14,297 "},{"v":13854,"d":"13,854 "},{"v":13062,"d":"13,062 "},{"v":13402,"d":"13,402 "},{"v":11999,"d":"11,999 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":332859,"d":"332,859 "},{"v":339500,"d":"339,500 "},{"v":350187,"d":"350,187 "},{"v":357393,"d":"357,393 "},{"v":357301,"d":"357,301 "},{"v":32804,"d":"32,804 "},{"v":32935,"d":"32,935 "},{"v":34291,"d":"34,291 "},{"v":33795,"d":"33,795 "},{"v":34587,"d":"34,587 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":451741,"d":"451,741 "},{"v":451991,"d":"451,991 "},{"v":445561,"d":"445,561 "},{"v":449066,"d":"449,066 "},{"v":444679,"d":"444,679 "},{"v":47101,"d":"47,101 "},{"v":46789,"d":"46,789 "},{"v":47353,"d":"47,353 "},{"v":47197,"d":"47,197 "},{"v":46586,"d":"46,586 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1082107,"d":"1,082,107 "},{"v":1094264,"d":"1,094,264 "},{"v":1105676,"d":"1,105,676 "},{"v":1112564,"d":"1,112,564 "},{"v":1120709,"d":"1,120,709 "},{"v":141747,"d":"141,747 "},{"v":142057,"d":"142,057 "},{"v":142894,"d":"142,894 "},{"v":143902,"d":"143,902 "},{"v":143083,"d":"143,083 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":110630,"d":"110,630 "},{"v":98929,"d":"98,929 "},{"v":94503,"d":"94,503 "},{"v":98123,"d":"98,123 "},{"v":96960,"d":"96,960 "},{"v":5496,"d":"5,496 "},{"v":3801,"d":"3,801 "},{"v":3101,"d":"3,101 "},{"v":3704,"d":"3,704 "},{"v":3800,"d":"3,800 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",7.62,6.97,{"v":6.2,"d":"6.20"},7.28,7.68,7.91,8.34,8.35,8.38,{"v":8.3,"d":"8.30"}]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",4.72,4.79,4.82,5.21,4.87,3.67,3.72,{"v":3.8,"d":"3.80"},3.89,3.73]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",21.14,21.13,22.96,21.21,21.18,15.95,16.25,16.78,16.78,16.47]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",36.76,36.15,37.17,36.93,37.05,30.64,30.66,31.32,31.71,31.41]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",36.27,36.38,{"v":36.2,"d":"36.20"},36.14,35.98,52.73,53.19,52.83,52.63,53.08]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",2.94,3.56,4.25,3.99,3.83,2.37,3.13,{"v":4.1,"d":"4.10"},4.13,3.63]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",26.54,27.11,28.62,28.11,{"v":28.4,"d":"28.40"},26.77,27.99,29.15,29.13,28.75]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.38,22.13,21.82,21.93,22.46,25.45,24.79,23.49,23.71,25.13]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",58.25,58.69,{"v":59.7,"d":"59.70"},59.64,60.32,66.77,67.06,66.86,{"v":67.2,"d":"67.20"},67.44]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",41.75,41.31,{"v":40.3,"d":"40.30"},40.36,39.68,33.23,32.94,33.14,{"v":32.8,"d":"32.80"},32.56]
["  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-2012Q1","index":2,"n_rows":47,"n_cols":11,"rows_kept":47,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[22,1,22,4],[22,6,22,9],[33,1,33,4],[33,6,33,9],[46,0,46,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 5.0 -- Income Statement  For Corporations in NAICS Retail Trade Subsectors 448 and 452, and\n                               All Other Retail Trade Subsectors, Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"Clothing and General Merchandise Stores\nTotal Assets $50 Million and Over",{"$nulls":4},"All Other Retail Trade\nTotal Assets $50 Million and Over"]
["Item"," 1Q_\n 2011_"," 2Q_\n 2011_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 1Q_\n 2011_"," 2Q_\n 2011_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"]
[null,"(million dollars)",{"$nulls":4},"(million dollars)"]
["     Net sales, receipts, and operating revenues ………………………………………………………………………………………………………………………………………………………………………",{"v":188184,"d":"188,184 "},{"v":192874,"d":"192,874 "},{"v":191894,"d":"191,894 "},{"v":229974,"d":"229,974 "},{"v":200721,"d":"200,721 "},{"v":261666,"d":"261,666 "},{"v":274692,"d":"274,692 "},{"v":272000,"d":"272,000 "},{"v":282134,"d":"282,134 "},{"v":285729,"d":"285,729 "}]
["     Depreciation, depletion, and amortization of property, "]
["          plant, and equipment …………………………………………………………………………………………………………………………………………………………………………………………",{"v":4465,"d":"4,465 "},{"v":4555,"d":"4,555 "},{"v":4501,"d":"4,501 "},{"v":4615,"d":"4,615 "},{"v":4600,"d":"4,600 "},{"v":4154,"d":"4,154 "},{"v":4164,"d":"4,164 "},{"v":4205,"d":"4,205 "},{"v":4222,"d":"4,222 "},{"v":4243,"d":"4,243 "}]
["     All other operating costs and expenses …………………………………………………………………………………………………………...……………………………………………………………",{"v":172670,"d":"172,670 "},{"v":178304,"d":"178,304 "},{"v":178470,"d":"178,470 "},{"v":209012,"d":"209,012 "},{"v":184682,"d":"184,682 "},{"v":245694,"d":"245,694 "},{"v":257263,"d":"257,263 "},{"v":256187,"d":"256,187 "},{"v":264807,"d":"264,807 "},{"v":268186,"d":"268,186 "}]
["               Income (loss) from operations …………………………………………………………………………………………………………...……………………………………………………………",{"v":11049,"d":"11,049 "},{"v":10015,"d":"10,015 "},{"v":8923,"d":"8,923 "},{"v":16348,"d":"16,348 "},{"v":11439,"d":"11,439 "},{"v":11819,"d":"11,819 "},{"v":13264,"d":"13,264 "},{"v":11607,"d":"11,607 "},{"v":13105,"d":"13,105 "},{"v":13300,"d":"13,300 "}]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1513,"d":"1,513 "},{"v":1631,"d":"1,631 "},{"v":1548,"d":"1,548 "},{"v":1468,"d":"1,468 "},{"v":1550,"d":"1,550 "},{"v":1964,"d":"1,964 "},{"v":1965,"d":"1,965 "},{"v":1960,"d":"1,960 "},{"v":2005,"d":"2,005 "},{"v":1927,"d":"1,927 "}]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1632,"d":"1,632 "},{"v":2611,"d":"2,611 "},{"v":2499,"d":"2,499 "},{"v":2142,"d":"2,142 "},{"v":2909,"d":"2,909 "},{"v":911,"d":"911 "},{"v":913,"d":"913 "},{"v":1544,"d":"1,544 "},{"v":3161,"d":"3,161 "},{"v":-1283,"d":"(1,283)"}]
["               Income (loss) before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":11168,"d":"11,168 "},{"v":10995,"d":"10,995 "},{"v":9874,"d":"9,874 "},{"v":17022,"d":"17,022 "},{"v":12799,"d":"12,799 "},{"v":10766,"d":"10,766 "},{"v":12212,"d":"12,212 "},{"v":11191,"d":"11,191 "},{"v":14261,"d":"14,261 "},{"v":10091,"d":"10,091 "}]
["     Provision for current and deferred domestic income taxes …………………………………………………………………………………………………………………………………………………………………………………………",{"v":3743,"d":"3,743 "},{"v":3519,"d":"3,519 "},{"v":3286,"d":"3,286 "},{"v":7440,"d":"7,440 "},{"v":4092,"d":"4,092 "},{"v":3777,"d":"3,777 "},{"v":4116,"d":"4,116 "},{"v":3689,"d":"3,689 "},{"v":4492,"d":"4,492 "},{"v":3859,"d":"3,859 "}]
["               Income (loss) after income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":7425,"d":"7,425 "},{"v":7476,"d":"7,476 "},{"v":6588,"d":"6,588 "},{"v":9582,"d":"9,582 "},{"v":8707,"d":"8,707 "},{"v":6988,"d":"6,988 "},{"v":8095,"d":"8,095 "},{"v":7502,"d":"7,502 "},{"v":9769,"d":"9,769 "},{"v":6231,"d":"6,231 "}]
["     Cash dividends charged to retained earnings this quarter ……………………………………………………………………………………………………………………………………………………………………………………",{"v":6406,"d":"6,406 "},{"v":1308,"d":"1,308 "},{"v":1194,"d":"1,194 "},{"v":1812,"d":"1,812 "},{"v":1359,"d":"1,359 "},{"v":1694,"d":"1,694 "},{"v":1816,"d":"1,816 "},{"v":1705,"d":"1,705 "},{"v":1971,"d":"1,971 "},{"v":1976,"d":"1,976 "}]
["               Net income retained in business ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":1019,"d":"1,019 "},{"v":6168,"d":"6,168 "},{"v":5394,"d":"5,394 "},{"v":7770,"d":"7,770 "},{"v":7348,"d":"7,348 "},{"v":5295,"d":"5,295 "},{"v":6279,"d":"6,279 "},{"v":5797,"d":"5,797 "},{"v":7798,"d":"7,798 "},{"v":4255,"d":"4,255 "}]
["     Retained earnings at beginning of quarter …………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":153927,"d":"153,927 "},{"v":150823,"d":"150,823 "},{"v":152430,"d":"152,430 "},{"v":154554,"d":"154,554 "},{"v":156314,"d":"156,314 "},{"v":146507,"d":"146,507 "},{"v":148799,"d":"148,799 "},{"v":156210,"d":"156,210 "},{"v":160309,"d":"160,309 "},{"v":167043,"d":"167,043 "}]
["     Other direct credits (charges) to retained earnings (net), including "]
["          stock and other non-cash dividends, etc. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":-3620,"d":"(3,620)"},{"v":-3367,"d":"(3,367)"},{"v":-3008,"d":"(3,008)"},{"v":-5913,"d":"(5,913)"},{"v":-7925,"d":"(7,925)"},{"v":-3073,"d":"(3,073)"},{"v":-2138,"d":"(2,138)"},{"v":-928,"d":"(928)"},{"v":-919,"d":"(919)"},{"v":-4320,"d":"(4,320)"}]
["               Retained earnings at end of quarter ……………………………………………………………………………………………………………………………………………………………………………………………………",{"v":151326,"d":"151,326 "},{"v":153624,"d":"153,624 "},{"v":154817,"d":"154,817 "},{"v":156410,"d":"156,410 "},{"v":155736,"d":"155,736 "},{"v":148729,"d":"148,729 "},{"v":152941,"d":"152,941 "},{"v":161079,"d":"161,079 "},{"v":167188,"d":"167,188 "},{"v":166978,"d":"166,978 "}]
["                         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.37,2.36,2.35,2.01,2.29,1.59,1.52,1.55,{"v":1.5,"d":"1.50"},1.49]
["     All other operating costs and expenses ……………………………………………………………………………………………………………………………………………………………………………………………………",91.76,92.45,{"v":93,"d":"93.00"},90.88,92.01,{"v":93.9,"d":"93.90"},93.66,94.19,93.86,93.86]
["               Income (loss) from operations …………………………………………………………………………………………………………………………………………………………………………………………………",5.87,5.19,4.65,7.11,{"v":5.7,"d":"5.70"},4.52,4.83,4.27,4.64,4.65]
["     Interest expense …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":0.8,"d":"0.80"},0.85,0.81,0.64,0.77,0.75,0.72,0.72,0.71,0.67]
["     All other nonoperating income (expense) ……………………………………………………………………………………………………………………………………………………………………………………………",0.87,1.35,{"v":1.3,"d":"1.30"},0.93,1.45,0.35,0.33,0.57,1.12,{"v":-0.45,"d":"(0.45)"}]
["               Income (loss) before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………",5.93,{"v":5.7,"d":"5.70"},5.15,{"v":7.4,"d":"7.40"},6.38,4.11,4.45,4.11,5.05,3.53]
["     Provision for current and deferred domestic income taxes ……………………………………………………………………………………………………………………………………………………………………………………",1.99,1.82,1.71,3.24,2.04,1.44,{"v":1.5,"d":"1.50"},1.36,1.59,1.35]
["               Income (loss) after income taxes ………………………………………………………………………………………………………………………………………………………………………………………………",3.95,3.88,3.43,4.17,4.34,2.67,2.95,2.76,3.46,2.18]
["                         OPERATING RATIOS","(percent)",{"$nulls":4},"(percent)"]
["                                   (see explanatory notes)"]
["     Annual rate of profit on stockholders' equity at end of period:"]
["          Before income taxes ……………………………………………………………………………………………………………………………………………………………………………………………………………………",24.01,23.47,21.49,36.79,27.97,{"v":19.7,"d":"19.70"},22.43,20.88,26.31,18.77]
["          After income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",15.96,15.96,14.34,20.71,19.03,12.79,14.87,{"v":14,"d":"14.00"},18.02,11.59]
["     Annual rate of profit on total assets:"]
["          Before income taxes ………………………………………………………………………………………………………………………………………………………………………………………………………………",10.24,10.01,8.73,15.33,11.42,8.54,9.53,8.77,10.88,7.63]
["          After income taxes …………………………………………………………………………………………………………………………………………………………………………………………………………………………",6.81,{"v":6.8,"d":"6.80"},5.82,8.63,7.77,5.54,6.32,5.88,7.45,4.71]
["                         BALANCE SHEET RATIOS"]
["                                   (based on succeeding table)"]
["     Total current assets to total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………",1.36,1.31,1.29,1.28,1.24,1.48,1.42,1.37,{"v":1.4,"d":"1.40"},1.42]
["     Total cash, U.S. Government and other securities, to total current liabilities …………………………………………………………………………………………………………………………………………………………………",{"v":0.3,"d":"0.30"},0.25,0.19,0.24,0.23,0.28,0.25,0.22,0.26,{"v":0.3,"d":"0.30"}]
["     Total stockholders' equity to total debt ………………………………………………………………………………………………………………………………………………………………………………………………………",1.71,1.69,1.55,1.63,1.61,1.74,1.67,1.65,1.61,1.54]
["  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-2012Q1","index":3,"n_rows":61,"n_cols":11,"rows_kept":61,"merged":[[1,0,1,10],[2,0,2,10],[3,1,3,5],[3,6,3,10],[5,1,5,4],[5,6,5,9],[49,1,49,4],[49,6,49,9],[60,0,60,5]],"flags":["formulas_cached_only"]}
["Table with row headers in column A with column headers in rows 5 and 6"]
["Retail Table 5.1 -- Balance Sheet  For Corporations in NAICS Retail Trade Subsectors 448 and 452, and\n                               All Other Retail Trade Subsectors, Total Assets $50 Million and Over 1"]
["See the Survey Methodology section of the Introduction in the most recent QFR Publication for information on survey design, estimation, and sampling error.   "]
[null,"Clothing and General Merchandise Stores\nTotal Assets $50 Million and Over",{"$nulls":4},"All Other Retail Trade\nTotal Assets $50 Million and Over"]
["Item"," 1Q_\n 2011_"," 2Q_\n 2011_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"," 1Q_\n 2011_"," 2Q_\n 2011_"," 3Q_\n 2011_"," 4Q_\n 2011_"," 1Q_\n 2012_"]
["ASSETS","(million dollars)",{"$nulls":4},"(million dollars)"]
["     Cash and demand deposits in the U.S. .………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":25354,"d":"25,354 "},{"v":21750,"d":"21,750 "},{"v":19128,"d":"19,128 "},{"v":20862,"d":"20,862 "},{"v":22488,"d":"22,488 "},{"v":26820,"d":"26,820 "},{"v":24644,"d":"24,644 "},{"v":22763,"d":"22,763 "},{"v":28298,"d":"28,298 "},{"v":36056,"d":"36,056 "}]
["     Time deposits in the U.S., including negotiable certificates of deposit ……………………………………………………………………………………………………………………………………………………………………………………",{"v":1460,"d":"1,460 "},{"v":1208,"d":"1,208 "},{"v":681,"d":"681 "},{"v":655,"d":"655 "},{"v":630,"d":"630 "},{"v":647,"d":"647 "},{"v":953,"d":"953 "},{"v":1074,"d":"1,074 "},{"v":1458,"d":"1,458 "},{"v":1368,"d":"1,368 "}]
["               Total cash on hand and in U.S. banks ……………………………………………………………………………………………………………………………………………………………………………………",{"v":26814,"d":"26,814 "},{"v":22958,"d":"22,958 "},{"v":19808,"d":"19,808 "},{"v":21518,"d":"21,518 "},{"v":23118,"d":"23,118 "},{"v":27468,"d":"27,468 "},{"v":25597,"d":"25,597 "},{"v":23837,"d":"23,837 "},{"v":29756,"d":"29,756 "},{"v":37423,"d":"37,423 "}]
["     Other short-term financial investments, including marketable and "]
["          government securities, commercial paper, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":6922,"d":"6,922 "},{"v":6255,"d":"6,255 "},{"v":4022,"d":"4,022 "},{"v":6921,"d":"6,921 "},{"v":5707,"d":"5,707 "},{"v":9999,"d":"9,999 "},{"v":9642,"d":"9,642 "},{"v":8909,"d":"8,909 "},{"v":10774,"d":"10,774 "},{"v":7975,"d":"7,975 "}]
["               Total cash, U.S. Government and other securities ……………………………………………………………………………………………………………………………………………………………………………………",{"v":33737,"d":"33,737 "},{"v":29213,"d":"29,213 "},{"v":23830,"d":"23,830 "},{"v":28439,"d":"28,439 "},{"v":28825,"d":"28,825 "},{"v":37467,"d":"37,467 "},{"v":35239,"d":"35,239 "},{"v":32746,"d":"32,746 "},{"v":40530,"d":"40,530 "},{"v":45399,"d":"45,399 "}]
["     Trade accounts and trade notes receivable"]
["          (less allowance for doubtful accounts) …………………………………………………………………………………………………………………………………………",{"v":7268,"d":"7,268 "},{"v":7196,"d":"7,196 "},{"v":8210,"d":"8,210 "},{"v":7922,"d":"7,922 "},{"v":7565,"d":"7,565 "},{"v":38619,"d":"38,619 "},{"v":39901,"d":"39,901 "},{"v":39701,"d":"39,701 "},{"v":44492,"d":"44,492 "},{"v":41703,"d":"41,703 "}]
["     Inventories ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":98887,"d":"98,887 "},{"v":99829,"d":"99,829 "},{"v":118088,"d":"118,088 "},{"v":99777,"d":"99,777 "},{"v":102013,"d":"102,013 "},{"v":107311,"d":"107,311 "},{"v":108302,"d":"108,302 "},{"v":111759,"d":"111,759 "},{"v":112062,"d":"112,062 "},{"v":111782,"d":"111,782 "}]
["     All other current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":15031,"d":"15,031 "},{"v":15383,"d":"15,383 "},{"v":15535,"d":"15,535 "},{"v":14858,"d":"14,858 "},{"v":15033,"d":"15,033 "},{"v":16036,"d":"16,036 "},{"v":16923,"d":"16,923 "},{"v":16301,"d":"16,301 "},{"v":17137,"d":"17,137 "},{"v":18007,"d":"18,007 "}]
["               Total current assets ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":154923,"d":"154,923 "},{"v":151621,"d":"151,621 "},{"v":165664,"d":"165,664 "},{"v":150996,"d":"150,996 "},{"v":153436,"d":"153,436 "},{"v":199434,"d":"199,434 "},{"v":200364,"d":"200,364 "},{"v":200507,"d":"200,507 "},{"v":214221,"d":"214,221 "},{"v":216890,"d":"216,890 "}]
["     Property, plant, and equipment ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":264083,"d":"264,083 "},{"v":268440,"d":"268,440 "},{"v":269881,"d":"269,881 "},{"v":273217,"d":"273,217 "},{"v":276664,"d":"276,664 "},{"v":217941,"d":"217,941 "},{"v":223092,"d":"223,092 "},{"v":225408,"d":"225,408 "},{"v":227263,"d":"227,263 "},{"v":230069,"d":"230,069 "}]
["     Land and mineral rights ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":29271,"d":"29,271 "},{"v":29437,"d":"29,437 "},{"v":29496,"d":"29,496 "},{"v":30080,"d":"30,080 "},{"v":30279,"d":"30,279 "},{"v":33565,"d":"33,565 "},{"v":33841,"d":"33,841 "},{"v":34201,"d":"34,201 "},{"v":34401,"d":"34,401 "},{"v":34426,"d":"34,426 "}]
["     Less:  Accumulated depreciation, depletion, and amortization ……………………………………………………………………………………………………………………………………………………………………………………",{"v":118219,"d":"118,219 "},{"v":120050,"d":"120,050 "},{"v":120503,"d":"120,503 "},{"v":123451,"d":"123,451 "},{"v":126436,"d":"126,436 "},{"v":108892,"d":"108,892 "},{"v":112258,"d":"112,258 "},{"v":113690,"d":"113,690 "},{"v":115200,"d":"115,200 "},{"v":117705,"d":"117,705 "}]
["               Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………",{"v":175135,"d":"175,135 "},{"v":177828,"d":"177,828 "},{"v":178874,"d":"178,874 "},{"v":179846,"d":"179,846 "},{"v":180507,"d":"180,507 "},{"v":142615,"d":"142,615 "},{"v":144675,"d":"144,675 "},{"v":145919,"d":"145,919 "},{"v":146465,"d":"146,465 "},{"v":146791,"d":"146,791 "}]
["     All other noncurrent assets, including investment in nonconsolidated"]
["          entities, long-term investments, intangibles, etc. ………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":106005,"d":"106,005 "},{"v":110092,"d":"110,092 "},{"v":108036,"d":"108,036 "},{"v":113346,"d":"113,346 "},{"v":114497,"d":"114,497 "},{"v":162248,"d":"162,248 "},{"v":167628,"d":"167,628 "},{"v":163782,"d":"163,782 "},{"v":163789,"d":"163,789 "},{"v":165505,"d":"165,505 "}]
["               Total Assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":436064,"d":"436,064 "},{"v":439540,"d":"439,540 "},{"v":452573,"d":"452,573 "},{"v":444188,"d":"444,188 "},{"v":448441,"d":"448,441 "},{"v":504297,"d":"504,297 "},{"v":512667,"d":"512,667 "},{"v":510208,"d":"510,208 "},{"v":524474,"d":"524,474 "},{"v":529185,"d":"529,185 "}]
["LIABILITIES AND STOCKHOLDERS' EQUITY"]
["     Short-term debt, original maturity of 1 year or less:"]
["          a.  Loans from banks ………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":510,"d":"510 "},{"v":258,"d":"258 "},{"v":792,"d":"792 "},{"v":578,"d":"578 "},{"v":794,"d":"794 "},{"v":9380,"d":"9,380 "},{"v":8972,"d":"8,972 "},{"v":8799,"d":"8,799 "},{"v":10256,"d":"10,256 "},{"v":9986,"d":"9,986 "}]
["          b.  Other short-term loans, including commercial paper ………………………………………………………………………………………………………………………………………………………………………………………",{"v":4096,"d":"4,096 "},{"v":7212,"d":"7,212 "},{"v":12572,"d":"12,572 "},{"v":5071,"d":"5,071 "},{"v":7133,"d":"7,133 "},{"v":2430,"d":"2,430 "},{"v":3310,"d":"3,310 "},{"v":3566,"d":"3,566 "},{"v":3686,"d":"3,686 "},{"v":3409,"d":"3,409 "}]
["     Trade accounts and trade notes payable ……………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":56869,"d":"56,869 "},{"v":57244,"d":"57,244 "},{"v":65989,"d":"65,989 "},{"v":55247,"d":"55,247 "},{"v":58348,"d":"58,348 "},{"v":68273,"d":"68,273 "},{"v":70096,"d":"70,096 "},{"v":70860,"d":"70,860 "},{"v":75776,"d":"75,776 "},{"v":74100,"d":"74,100 "}]
["     Income taxes accrued, prior and current years, net of payments ………………………………………………………………………………………………………………………………………………………………………………",{"v":2003,"d":"2,003 "},{"v":1335,"d":"1,335 "},{"v":608,"d":"608 "},{"v":2750,"d":"2,750 "},{"v":4092,"d":"4,092 "},{"v":2907,"d":"2,907 "},{"v":2405,"d":"2,405 "},{"v":2334,"d":"2,334 "},{"v":2241,"d":"2,241 "},{"v":3619,"d":"3,619 "}]
["     Current portion of long-term debt, due in 1 year or less:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":373,"d":"373 "},{"v":429,"d":"429 "},{"v":414,"d":"414 "},{"v":363,"d":"363 "},{"v":337,"d":"337 "},{"v":2654,"d":"2,654 "},{"v":2567,"d":"2,567 "},{"v":2800,"d":"2,800 "},{"v":2810,"d":"2,810 "},{"v":2878,"d":"2,878 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":5773,"d":"5,773 "},{"v":5255,"d":"5,255 "},{"v":4655,"d":"4,655 "},{"v":8355,"d":"8,355 "},{"v":6610,"d":"6,610 "},{"v":3276,"d":"3,276 "},{"v":6480,"d":"6,480 "},{"v":7570,"d":"7,570 "},{"v":7318,"d":"7,318 "},{"v":6637,"d":"6,637 "}]
["     All other current liabilities, including excise and"]
["          sales taxes, and accrued expenses ……..……………………………………………………………………………………………………………………………………………………",{"v":44708,"d":"44,708 "},{"v":44129,"d":"44,129 "},{"v":43652,"d":"43,652 "},{"v":45461,"d":"45,461 "},{"v":46859,"d":"46,859 "},{"v":45970,"d":"45,970 "},{"v":47162,"d":"47,162 "},{"v":50158,"d":"50,158 "},{"v":50884,"d":"50,884 "},{"v":52365,"d":"52,365 "}]
["               Total current liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":114333,"d":"114,333 "},{"v":115862,"d":"115,862 "},{"v":128682,"d":"128,682 "},{"v":117825,"d":"117,825 "},{"v":124172,"d":"124,172 "},{"v":134890,"d":"134,890 "},{"v":140994,"d":"140,994 "},{"v":146087,"d":"146,087 "},{"v":152972,"d":"152,972 "},{"v":152994,"d":"152,994 "}]
["     Long-term debt, due in more than 1 year:"]
["          a.  Loans from banks …………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":13741,"d":"13,741 "},{"v":14442,"d":"14,442 "},{"v":17004,"d":"17,004 "},{"v":15977,"d":"15,977 "},{"v":15074,"d":"15,074 "},{"v":24086,"d":"24,086 "},{"v":24890,"d":"24,890 "},{"v":24653,"d":"24,653 "},{"v":24590,"d":"24,590 "},{"v":24879,"d":"24,879 "}]
["          b.  Other long-term loans ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":84516,"d":"84,516 "},{"v":83423,"d":"83,423 "},{"v":83210,"d":"83,210 "},{"v":83172,"d":"83,172 "},{"v":83651,"d":"83,651 "},{"v":83722,"d":"83,722 "},{"v":84153,"d":"84,153 "},{"v":82789,"d":"82,789 "},{"v":86158,"d":"86,158 "},{"v":92147,"d":"92,147 "}]
["     All other noncurrent liabilities, including deferred income taxes, "]
["          capitalized leases, and minority stockholders' interest"]
["          in consolidated domestic corporations ……………………………………………………………………………………………………………………………………………………………………",{"v":37436,"d":"37,436 "},{"v":38400,"d":"38,400 "},{"v":39875,"d":"39,875 "},{"v":42147,"d":"42,147 "},{"v":42532,"d":"42,532 "},{"v":42995,"d":"42,995 "},{"v":44840,"d":"44,840 "},{"v":42273,"d":"42,273 "},{"v":43953,"d":"43,953 "},{"v":44085,"d":"44,085 "}]
["               Total liabilities ……………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":250026,"d":"250,026 "},{"v":252127,"d":"252,127 "},{"v":268772,"d":"268,772 "},{"v":259122,"d":"259,122 "},{"v":265429,"d":"265,429 "},{"v":285694,"d":"285,694 "},{"v":294878,"d":"294,878 "},{"v":295802,"d":"295,802 "},{"v":307672,"d":"307,672 "},{"v":314105,"d":"314,105 "}]
["     Capital stock and other capital (less treasury stock) …………………………………………………………………………………………………………………………………………………………………………………………",{"v":34712,"d":"34,712 "},{"v":33788,"d":"33,788 "},{"v":28985,"d":"28,985 "},{"v":28657,"d":"28,657 "},{"v":27276,"d":"27,276 "},{"v":69874,"d":"69,874 "},{"v":64849,"d":"64,849 "},{"v":53327,"d":"53,327 "},{"v":49614,"d":"49,614 "},{"v":48102,"d":"48,102 "}]
["     Retained earnings …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":151326,"d":"151,326 "},{"v":153624,"d":"153,624 "},{"v":154817,"d":"154,817 "},{"v":156410,"d":"156,410 "},{"v":155736,"d":"155,736 "},{"v":148729,"d":"148,729 "},{"v":152941,"d":"152,941 "},{"v":161079,"d":"161,079 "},{"v":167188,"d":"167,188 "},{"v":166978,"d":"166,978 "}]
["               Stockholders' equity ……………………………………………………………………………………………………………………………………………………………………………………………………………………",{"v":186038,"d":"186,038 "},{"v":187413,"d":"187,413 "},{"v":183801,"d":"183,801 "},{"v":185067,"d":"185,067 "},{"v":183013,"d":"183,013 "},{"v":218603,"d":"218,603 "},{"v":217789,"d":"217,789 "},{"v":214406,"d":"214,406 "},{"v":216802,"d":"216,802 "},{"v":215081,"d":"215,081 "}]
["               Total Liabilities and Stockholders' Equity ………………………………………………………………………………………………………………………………………………………………………………………………",{"v":436064,"d":"436,064 "},{"v":439540,"d":"439,540 "},{"v":452573,"d":"452,573 "},{"v":444188,"d":"444,188 "},{"v":448441,"d":"448,441 "},{"v":504297,"d":"504,297 "},{"v":512667,"d":"512,667 "},{"v":510208,"d":"510,208 "},{"v":524474,"d":"524,474 "},{"v":529185,"d":"529,185 "}]
["                         NET WORKING CAPITAL"]
["     Excess of total current assets over total current liabilities ………………………………………………………………………………………………………………………………………………………………………………………",{"v":40590,"d":"40,590 "},{"v":35758,"d":"35,758 "},{"v":36981,"d":"36,981 "},{"v":33171,"d":"33,171 "},{"v":29264,"d":"29,264 "},{"v":64544,"d":"64,544 "},{"v":59370,"d":"59,370 "},{"v":54421,"d":"54,421 "},{"v":61249,"d":"61,249 "},{"v":63896,"d":"63,896 "}]
["                         SELECTED BALANCE SHEET RATIOS","(percent of total assets)",{"$nulls":4},"(percent of total assets)"]
["     Total cash, U.S. Government and other securities …………………………………………………………………………………………………………………………………………………………………………………………………",7.74,6.65,5.27,{"v":6.4,"d":"6.40"},6.43,7.43,6.87,6.42,7.73,8.58]
["     Trade accounts and trade notes receivable ……………………………………………………………………………………………………………………………………………………………………………………………………",1.67,1.64,1.81,1.78,1.69,7.66,7.78,7.78,8.48,7.88]
["     Inventories ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.68,22.71,26.09,22.46,22.75,21.28,21.13,{"v":21.9,"d":"21.90"},21.37,21.12]
["     Total current assets …………………………………………………………………………………………………………………………………………………………………………………………………………………………",35.53,{"v":34.5,"d":"34.50"},{"v":36.6,"d":"36.60"},33.99,34.22,39.55,39.08,{"v":39.3,"d":"39.30"},40.84,40.99]
["     Net property, plant, and equipment ……………………………………………………………………………………………………………………………………………………………………………………………………………",40.16,40.46,39.52,40.49,40.25,28.28,28.22,{"v":28.6,"d":"28.60"},27.93,27.74]
["     Short-term debt, including current portion of long-term debt ………………………………………………………………………………………………………………………………………………………………………………………",2.47,2.99,4.07,3.23,3.32,3.52,4.16,4.46,4.59,4.33]
["     Total current liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",26.22,26.36,28.43,26.53,27.69,26.75,{"v":27.5,"d":"27.50"},28.63,29.17,28.91]
["     Long-term debt …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",22.53,22.27,22.14,22.32,22.01,21.38,21.27,21.06,21.12,22.11]
["     Total liabilities …………………………………………………………………………………………………………………………………………………………………………………………………………………………………",57.34,57.36,59.39,58.34,59.19,56.65,57.52,57.98,58.66,59.36]
["     Stockholders' equity ………………………………………………………………………………………………………………………………………………………………………………………………………………………………",42.66,42.64,40.61,41.66,40.81,43.35,42.48,42.02,41.34,40.64]
["  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-2012Q1","index":4,"n_rows":24,"n_cols":5,"rows_kept":24,"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"]
["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":331041,"d":"331,041 "},{"v":337074,"d":"337,074 "},{"v":339286,"d":"339,286 "},{"v":347809,"d":"347,809 "}]
["2002 …………………………………………………………………………………………...………………………………………………..",{"v":349344,"d":"349,344 "},{"v":355219,"d":"355,219 "},{"v":359120,"d":"359,120 "},{"v":357390,"d":"357,390 "}]
["2003 …………………………………………………………………………………………...………………………………………………..",{"v":367094,"d":"367,094 "},{"v":369842,"d":"369,842 "},{"v":391105,"d":"391,105 "},{"v":398988,"d":"398,988 "}]
["2004 …………………………………………………………………………………………...………………………………………………..",{"v":407278,"d":"407,278 "},{"v":410422,"d":"410,422 "},{"v":421364,"d":"421,364 "},{"v":427354,"d":"427,354 "}]
["2005 …………………………………………………………………………………………...………………………………………………..",{"v":438625,"d":"438,625 "},{"v":447488,"d":"447,488 "},{"v":458225,"d":"458,225 "},{"v":467812,"d":"467,812 "}]
["2006 …………………………………………………………………………………………...………………………………………………..",{"v":480686,"d":"480,686 "},{"v":492916,"d":"492,916 "},{"v":497367,"d":"497,367 "},{"v":502033,"d":"502,033 "}]
["2007 …………………………………………………………………………………………...………………………………………………..",{"v":509893,"d":"509,893 "},{"v":514932,"d":"514,932 "},{"v":515718,"d":"515,718 "},{"v":521343,"d":"521,343 "}]
["2008 …………………………………………………………………………………………...………………………………………………..",{"v":523075,"d":"523,075 "},{"v":536604,"d":"536,604 "},{"v":531035,"d":"531,035 "},{"v":501641,"d":"501,641 "}]
["2009 …………………………………………………………………………………………...………………………………………………..",{"v":495320,"d":"495,320 "},{"v":495422,"d":"495,422 "},{"v":507942,"d":"507,942 "},{"v":521247,"d":"521,247 "}]
["2010 …………………………………………………………………………………………...………………………………………………..",{"v":530987,"d":"530,987 "},{"v":535076,"d":"535,076 "},{"v":538878,"d":"538,878 "},{"v":552929,"d":"552,929 "}]
["2011 …………………………………………………………………………………………...………………………………………………..",{"v":565189,"d":"565,189 "},{"v":579905,"d":"579,905 "},{"v":580752,"d":"580,752 "},{"v":592618,"d":"592,618 "}]
["2012 …………………………………………………………………………………………...………………………………………………..",{"v":605645,"d":"605,645 "}]
[]
["1 This table only includes estimates for corporations with assets of $50 million and over at the time of sample selection."]
["NOTE:   Seasonally adjusted estimates are the result of removing normal seasonal patterns from an unadjusted data series to bring out underlying trends.  "]
["The seasonally adjusted estimates are computed using the X-13ARIMA-SEATS seasonal adjustment program. Further information related to the Census Bureau's "]
["seasonal adjustment software may be obtained by visiting http://www.census.gov/srd/www/x12a/contact.html "]