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
E.I. du Pont de Nemours and Company DD 35,310.0 27.5 2,788.0 4.96 30.07 40,713.24 10,117.08 14.6 4.02 1.15
Ingersoll-Rand plc (Ireland) IR 14,035.0 30.5 1,019.0 2.59 14.48 14,862.69 7,519.98 14.59 1.98 1.06
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
International Game Technology IGT 2,151.0 57.5 246.0 3.58 18.63 3,587.3 1,299.2 14.58 2.76 1.67
Bed Bath & Beyond Inc. BBBY 9,500.0 41.4 990.0 1.46 25.2 14,391.12 4,065.04 14.54 3.54 1.51
3M Company MMM 29,904.0 47.5 4,444.0 1.93 26.94 64,584.61 17,982.74 14.53 3.59 2.16
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
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
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
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
American Express Company AXP 31,582.0 4,482.0 8.11 23.79 64,751.75 19,499.69 14.45 3.32 2.05
United Technologies Corporation UTX 57,708.0 27.0 5,130.0 3.45 21.47 73,476.07 25,577.4 14.32 2.87 1.27
Baker Hughes Incorporated BHI 21,361.0 18.7 1,311.0 1.56 7.99 18,698.4 17,071.11 14.26 1.1 0.88
PACCAR Inc. PCAR 17,051.0 18.4 1,112.0 3.19 19.83 15,845.56 5,888.24 14.25 2.69 0.93
Darden Restaurants, Inc. DRI 7,999.0 22.9 476.0 3.23 25.17 6,768.37 1,899.24 14.22 3.56 0.85
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
BlackRock, Inc. BLK 9,337.0 60.9 2,458.0 7.89 9.74 34,838.16 26,774.76 14.17 1.3 3.73
FLIR Systems, Inc. FLIR 1,405.0 52.0 222.0 1.36 13.99 3,133.9 1,689.38 14.12 1.86 2.23
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
Rockwell Automation, Inc. ROK 6,259.0 40.3 737.0 3.04 40.95 10,358.92 1,876.16 14.06 5.52 1.66
TE Connectivity Ltd. TEL 13,282.0 30.5 1,112.0 2.42 14.4 15,462.8 8,109.8 13.91 1.91 1.16
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
Becton, Dickinson and Company BDX 7,708.0 51.3 1,170.0 2.75 26.1 16,230.94 4,332.57 13.87 3.75 2.11
CA Inc. CA 4,814.0 86.6 951.0 2.22 17.26 13,149.0 5,410.57 13.83 2.43 2.73
Viacom Inc. VIAB 13,887.0 49.6 1,981.0 2.99 24.62 27,308.88 7,784.86 13.79 3.51 1.97
Oracle Corporation ORCL 37,121.0 78.8 9,981.0 1.79 23.92 137,666.9 45,396.45 13.79 3.03 3.71
Eli Lilly and Company LLY 22,603.0 78.8 4,089.0 2.33 28.89 55,984.04 14,386.96 13.69 3.89 2.48
Cardinal Health, Inc. CAH 107,552.0 4.2 1,069.0 3.89 17.68 14,623.1 6,295.96 13.68 2.32 0.14
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
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