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
Accenture plc. ACN 29,778.0 30.2 2,554.0 4.02 63.64 44,743.38 4,450.38 17.52 10.05 1.5
Legg Mason, Inc. LM 2,663.0 100.0 221.0 1.51 3.86 3,929.64 5,810.09 17.78 0.68 1.48
Scana Corporation SCG 4,176.0 50.6 420.0 3.52 10.44 6,128.64 4,185.51 14.59 1.46 1.47
H.J. Heinz Company HNZ 11,649.0 34.3 923.0 4.34 31.47 16,980.11 2,781.03 18.4 6.11 1.46
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
National-Oilwell, Inc. NOV 20,041.0 26.6 2,491.0 1.56 13.16 28,989.03 20,244.07 11.64 1.43 1.45
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
NiSource, Inc NI 5,061.0 69.5 416.0 3.93 7.89 7,347.0 5,370.0 17.66 1.37 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
JDS Uniphase Corporation JDSU 1,682.0 42.2 -56.0 1.8 -5.28 2,419.6 1,032.7 2.34 1.44
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
Torchmark Corporation TMK 3,590.0 529.0 4.3 12.32 5,106.78 4,536.42 9.65 1.13 1.42
American Electric Power Company, Inc. AEP 14,945.0 64.7 1,259.0 3.57 8.42 21,034.45 15,214.45 16.71 1.38 1.41
SunTrust Banks, Inc. STI 10,475.0 1,958.0 8.56 9.64 14,633.6 20,223.42 7.47 0.72 1.4
CONSOL Energy Inc. CNX 5,430.0 33.6 388.0 3.2 10.27 7,618.83 3,968.57 19.64 1.92 1.4
Electronic Arts Inc. EA 4,143.0 61.4 76.0 2.23 3.03 5,799.36 2,493.12 76.31 2.33 1.4
Netflix, Inc. NFLX 3,609.0 27.2 17.0 5.33 2.47 5,003.2 790.6 6.33 1.39
Western Union Company (The) WU 5,665.0 43.6 1,026.0 10.06 111.79 7,872.79 995.48 7.67 7.91 1.39
Bank of America Corporation BAC 83,334.0 4,188.0 10.13 1.28 114,589.37 219,421.84 27.36 0.52 1.38
PPL Corporation PPL 12,286.0 60.3 1,526.0 4.16 14.32 16,878.0 10,481.82 11.06 1.61 1.37
Time Warner Cable Inc TWC 21,386.0 53.5 2,155.0 6.84 29.1 29,303.04 7,628.4 13.6 3.84 1.37
Newfield Exploration Company NFX 2,567.0 66.6 -1,184.0 2.85 -35.34 3,511.35 2,772.9 1.27 1.37
Airgas, Inc. ARG 4,746.0 54.2 313.0 3.04 17.98 6,477.12 1,787.76 20.69 3.62 1.36
Consolidated Edison Inc ED 12,188.0 68.1 1,141.0 3.47 9.68 16,540.65 11,956.35 14.5 1.38 1.36
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
Expeditors International of Washington, Inc. EXPD 5,981.0 30.5 333.0 1.46 16.54 8,102.64 2,081.84 24.33 3.89 1.35
Ross Stores, Inc. ROST 8,608.0 27.5 657.0 2.21 46.51 11,571.3 1,513.4 17.61 7.65 1.34
AMERIPRISE FINANCIAL SERVICES, INC. AMP 10,259.0 1,029.0 14.82 10.64 13,667.67 9,941.34 13.28 1.37 1.33
Marathon Oil Corporation MRO 16,221.0 66.3 1,582.0 1.93 8.93 21,555.6 18,360.6 13.63 1.17 1.33
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