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
Citrix Systems, Inc. CTXS 2,586.0 84.4 353.0 1.54 12.05 11,823.84 3,165.75 33.5 3.73 4.57
Ecolab Inc. ECL 11,839.0 45.2 704.0 2.89 11.98 21,539.96 6,165.38 30.6 3.49 1.82
Occidental Petroleum Corporation OXY 24,253.0 66.2 4,598.0 1.6 11.85 61,033.5 40,240.8 13.27 1.52 2.52
Fifth Third Bancorp FITB 6,594.0 1,576.0 9.15 11.8 13,773.76 14,284.6 8.74 0.96 2.09
Allstate Corporation (The) ALL 33,315.0 2,306.0 6.17 11.75 20,410.2 21,179.28 8.85 0.96 0.61
Molex Incorporated MOLX 3,489.0 30.6 281.0 1.48 11.7 4,297.56 2,449.68 15.29 1.75 1.23
Huntington Bancshares Incorporated HBAN 2,679.0 641.0 10.39 11.67 5,385.12 5,531.83 8.4 0.97 2.01
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Unum Group UNM 10,515.0 894.0 7.23 10.41 5,913.54 8,987.34 6.61 0.66 0.56
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