S&P500 2012 Annual Data -- Dynamic Spreadsheet

Click to sort!
Company Name Company Ticker Revenue Usd Mil Gross Margin Pctg Net Income Mil Financial Leverage Avg Return On Equity Pctg Market Cap Mil Book Value Mil Pe Ratio Pb Ratio Ps Ratio
Coca-Cola Enterprises, Inc. CCE 8,062.0 36.0 677.0 3.53 24.21 9,598.89 2,874.55 14.18 3.34 1.19
Lorillard, Inc LO 6,623.0 36.0 1,099.0 46,917.0 -1,813.5 42.69 7.08
J.C. Penney Company, Inc. Holding Company JCP 17,260.0 36.0 -152.0 2.85 -3.21 7,469.14 4,029.69 1.85 0.43
Illinois Tool Works Inc. ITW 17,924.0 36.1 2,870.0 1.83 27.89 29,311.81 10,978.33 10.21 2.67 1.64
Gap, Inc. (The) GPS 14,549.0 36.2 833.0 2.69 24.37 9,668.62 3,027.44 11.61 3.19 0.66
Tyco International, Ltd. (Switzerland) TYC 10,403.0 36.3 472.0 2.48 4.92 25,742.8 5,005.03 54.54 5.14 2.47
Tenet Healthcare Corporation THC 9,119.0 36.3 152.0 7.91 12.63 3,227.49 1,190.28 21.23 2.71 0.35
General Mills, Inc. GIS 16,658.0 36.3 1,567.0 3.29 24.51 26,179.75 6,603.3 16.71 3.96 1.57
Stanley Black & Decker, Inc. SWK 10,191.0 36.4 884.0 2.38 12.93 11,997.28 6,960.56 13.57 1.72 1.18
Wynn Resorts, Limited WYNN 5,154.0 36.9 502.0 54.87 11,444.16 -267.28 22.8 2.22
TECO Energy, Inc. TE 2,997.0 37.3 213.0 3.21 9.33 3,624.9 2,274.7 17.02 1.59 1.21
Newell Rubbermaid Inc. NWL 5,903.0 37.8 401.0 3.12 20.87 6,541.5 2,046.24 16.31 3.2 1.11
Applied Materials, Inc. AMAT 8,719.0 38.0 109.0 1.67 1.36 13,919.3 7,713.08 1.8 1.6
Kohl's Corporation KSS 18,804.0 38.2 1,167.0 2.17 15.98 12,474.13 7,140.85 10.69 1.75 0.66
Dover Corporation DOV 8,104.0 38.3 811.0 2.12 16.47 11,737.36 5,181.44 14.47 2.27 1.45
News Corporation NWSA 33,706.0 38.3 1,179.0 2.3 4.35 48,677.76 976.56 41.29 49.85 1.44
Host Marriott Financial Trust HST 5,286.0 38.3 61.0 1.9 0.9 10,900.8 6,782.4 1.61 2.06
Republic Services, Inc. RSG 8,118.0 38.3 572.0 2.55 7.43 10,683.04 7,849.44 18.68 1.36 1.32
Kellogg Company K 14,197.0 38.3 961.0 6.28 45.99 20,206.8 2,412.0 21.03 8.38 1.42
Harley-Davidson, Inc. HOG 5,581.0 38.7 624.0 3.59 25.07 10,685.14 2,589.99 17.12 4.13 1.91
Campbell Soup Company CPB 7,707.0 38.8 774.0 7.27 77.95 10,402.59 918.72 13.44 11.32 1.35
Limited Brands, Inc. LTD 10,364.0 39.1 850.0 44.58 105.39 12,321.36 144.44 14.5 85.3 1.19
McDonald's Corporation MCD 27,567.0 39.2 5,465.0 2.31 36.82 91,198.2 15,555.0 16.69 5.86 3.31
Nordstrom, Inc. JWN 10,877.0 39.4 683.0 4.34 34.35 10,760.48 2,053.56 15.75 5.24 0.99
Williams Companies, Inc. (The) WMB 7,486.0 39.6 859.0 5.12 26.25 19,512.5 4,362.5 22.72 4.47 2.61
Xylem Inc. XYL 3,791.0 39.6 297.0 2.26 15.23 4,925.28 2,077.62 16.58 2.37 1.3
Laboratory Corporation of America Holdings LH 5,671.0 39.7 583.0 2.5 22.34 8,218.81 2,818.82 14.1 2.92 1.45
Big Lots, Inc. BIG 5,202.0 39.8 207.0 1.99 23.4 2,660.64 892.86 12.85 2.98 0.51
Molson Coors Brewing Company TAP 3,917.0 39.9 443.0 2.03 5.67 7,898.8 7,987.98 17.83 0.99 2.02
Emerson Electric Company EMR 24,412.0 40.0 1,968.0 2.31 19.02 36,580.95 10,400.25 18.59 3.52 1.5