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
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
Marsh & McLennan Companies, Inc. MMC 11,924.0 100.0 1,176.0 2.49 18.93 19,253.76 6,618.48 16.37 2.91 1.61
Edison International EIX 11,862.0 65.1 -92.0 4.71 -1.88 14,737.8 9,553.5 1.54 1.24
Covidien plc. COV 11,852.0 57.5 1,905.0 2.11 18.69 27,599.94 10,876.68 14.49 2.54 2.33
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
Marriot International MAR 11,814.0 13.4 571.0 11,495.57 -1,333.99 20.13 0.97
CSX Corporation CSX 11,756.0 64.1 1,859.0 3.4 21.32 20,727.2 9,162.4 11.15 2.26 1.76
Whole Foods Market, Inc. WFM 11,699.0 35.5 466.0 1.39 13.71 17,991.52 3,788.56 38.61 4.75 1.54
EOG Resources, Inc. EOG 11,683.0 83.7 570.0 2.06 4.4 31,904.83 13,254.61 55.97 2.41 2.73
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
Lincoln National Corporation LNC 11,532.0 1,313.0 14.62 9.01 7,413.12 15,888.96 5.65 0.47 0.64
Aon plc AON 11,514.0 100.0 993.0 3.93 12.54 18,781.2 8,315.01 18.91 2.26 1.63
Dean Foods Company DF 11,462.0 25.3 159.0 15.92 125.0 3,158.28 357.12 19.86 8.84 0.28
C.H. Robinson Worldwide, Inc. CHRW 11,359.0 15.1 594.0 1.86 43.14 10,034.28 1,511.46 16.89 6.64 0.88
Praxair, Inc. PX 11,224.0 43.0 1,692.0 2.98 29.29 32,567.68 6,181.94 19.25 5.27 2.9
Mosaic Company (The) MOS 11,108.0 27.8 1,930.0 1.39 16.34 21,369.3 12,305.92 11.07 1.74 1.92
Norfolk Souther Corporation NSC 11,040.0 63.4 1,749.0 3.11 17.78 20,176.0 10,101.0 11.54 2.0 1.83
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
V.F. Corporation VFC 10,880.0 46.5 1,086.0 1.88 22.5 16,648.8 5,209.12 15.33 3.2 1.53
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
Avon Products, Inc. AVP 10,717.0 61.1 -43.0 6.07 -3.05 6,229.44 1,218.24 5.11 0.58
Automatic Data Processing, Inc. ADP 10,665.0 41.5 1,389.0 5.04 22.9 26,410.56 6,150.0 19.01 4.29 2.48
SAIC Inc SAI 10,587.0 9.3 59.0 3.06 2.53 4,354.56 2,150.4 73.81 2.03 0.41
Unum Group UNM 10,515.0 894.0 7.23 10.41 5,913.54 8,987.34 6.61 0.66 0.56
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
Visa Inc. V 10,421.0 79.5 2,144.0 1.45 7.93 87,245.04 23,092.68 40.69 3.78 8.37
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
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
Entergy Corporation ETR 10,302.0 65.7 868.0 4.7 9.28 11,374.2 9,207.94 13.1 1.24 1.1
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