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
Hess Corporation HES 37,691.0 23.8 2,025.0 2.06 10.23 17,006.8 20,995.0 8.4 0.81 0.45
ConAgra Foods, Inc. CAG 13,263.0 21.3 468.0 2.58 10.24 10,725.88 4,552.02 22.92 2.36 0.81
CVS Corporation CVS 123,133.0 18.3 3,877.0 1.75 10.24 60,467.2 39,206.4 15.6 1.54 0.49
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
State Street Corporation STT 9,649.0 2,061.0 10.92 10.28 21,616.14 21,370.83 10.49 1.01 2.24
ENSCO plc ESV 4,301.0 52.8 1,170.0 1.57 10.29 13,381.4 11,697.8 11.44 1.14 3.11
Xerox Corporation XRX 22,390.0 32.3 1,195.0 2.69 10.37 9,342.87 12,133.77 7.82 0.77 0.42
Ace Limited ACE 17,936.0 2,706.0 3.36 10.4 27,721.26 27,748.7 10.24 1.0 1.55
Unum Group UNM 10,515.0 894.0 7.23 10.41 5,913.54 8,987.34 6.61 0.66 0.56
Xcel Energy Inc. XEL 10,128.0 55.2 905.0 3.51 10.43 13,288.24 8,876.72 14.68 1.5 1.31
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
BB&T Corporation BBT 9,677.0 1,979.0 9.66 10.51 20,107.24 19,291.89 10.16 1.04 2.08
Coventry Health Care, Inc. CVH 14,113.0 21.2 487.0 1.85 10.55 6,049.92 4,808.7 12.42 1.26 0.43
Denbury Resources, Inc. (Holding Company) DNR 2,456.0 77.7 525.0 2.18 10.59 6,192.88 5,298.18 11.8 1.17 2.52
Lowe's Companies, Inc. LOW 50,208.0 34.6 1,839.0 2.03 10.62 33,645.39 16,803.6 18.3 2.0 0.67
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
Goldman Sachs Group, Inc. (The) GS 34,163.0 7,475.0 13.5 10.66 60,377.16 77,116.2 8.08 0.78 1.77
J P Morgan Chase & Co JPM 97,031.0 21,284.0 12.1 10.72 161,708.82 195,953.94 7.6 0.83 1.67
The Charles Schwab Corporation SCHW 4,899.0 928.0 15.32 10.74 17,046.75 8,708.25 18.37 1.96 3.48
Jacobs Engineering Group Inc. JEC 10,894.0 15.9 379.0 1.84 10.77 5,259.33 3,695.85 13.88 1.42 0.48
Bemis Company, Inc. BMS 5,139.0 18.4 174.0 2.55 10.79 3,465.28 1,653.6 19.92 2.1 0.67
Johnson Controls, Inc. JCI 41,955.0 14.8 1,226.0 2.67 10.85 19,092.19 11,644.1 15.57 1.64 0.46
Red Hat, Inc. RHT 1,133.0 84.2 147.0 1.78 10.9 9,402.12 1,422.96 63.96 6.61 8.3
Murphy Oil Corporation MUR 28,626.0 12.8 971.0 1.96 10.96 11,038.95 9,147.45 11.37 1.21 0.39
Spectra Energy Corp SE 5,075.0 79.6 940.0 3.41 11.03 17,935.04 8,810.08 19.08 2.04 3.53
WellPoint Inc. WLP 61,712.0 2,656.0 2.48 11.28 18,918.25 25,385.75 7.12 0.75 0.31
General Electric Company GE 147,359.0 49.6 13,641.0 5.57 11.39 225,963.96 124,866.48 16.57 1.81 1.53
Gamestop Corporation GME 9,551.0 28.1 340.0 1.59 11.45 3,416.43 3,135.84 10.05 1.09 0.36
Merck & Company, Inc. MRK 47,267.0 65.2 6,168.0 2.0 11.47 136,820.48 53,891.52 22.18 2.54 2.89
M&T Bank Corporation MTB 4,266.0 1,029.0 8.9 11.61 12,346.74 9,171.54 12.0 1.35 2.89