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
FMC Technologies, Inc. FTI 6,151.0 21.4 430.0 3.21 26.37 10,112.36 1,867.75 23.52 5.41 1.64
Williams Companies, Inc. (The) WMB 7,486.0 39.6 859.0 5.12 26.25 19,512.5 4,362.5 22.72 4.47 2.61
LyondellBasell Industries NV LYB 45,352.0 12.7 2,848.0 2.17 26.21 31,371.49 11,234.19 11.02 2.79 0.69
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
Celgene Corporation CELG 5,507.0 94.6 1,456.0 2.06 25.99 35,500.5 5,984.37 24.38 5.93 6.45
BMC Software, Inc. BMC 2,172.0 73.8 401.0 3.36 25.8 6,546.32 1,522.4 16.32 4.3 3.01
PPG Industries, Inc. PPG 15,200.0 40.3 941.0 3.91 25.74 19,195.2 4,101.3 20.4 4.68 1.26
Teradata Corporation TDC 2,665.0 55.9 419.0 1.72 25.6 10,084.36 1,847.28 24.07 5.46 3.78
Robert Half International Inc. RHI 4,111.0 40.1 210.0 1.64 25.56 4,089.38 839.56 19.47 4.87 0.99
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
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
Harley-Davidson, Inc. HOG 5,581.0 38.7 624.0 3.59 25.07 10,685.14 2,589.99 17.12 4.13 1.91
PetSmart, Inc PETM 6,113.0 29.5 290.0 2.2 24.97 5,970.18 1,194.72 20.59 5.0 0.98
McCormick & Company, Incorporated MKC 4,014.0 40.3 408.0 2.48 24.83 8,308.0 1,701.8 20.36 4.88 2.07
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
Honeywell International Inc. HON 37,665.0 24.9 2,926.0 3.23 24.61 48,993.12 13,131.36 16.74 3.73 1.3
General Mills, Inc. GIS 16,658.0 36.3 1,567.0 3.29 24.51 26,179.75 6,603.3 16.71 3.96 1.57
Western Digital Corporation WDC 12,478.0 29.2 1,612.0 1.85 24.5 7,651.35 7,636.65 4.75 1.0 0.61
KLA-Tencor Corporation KLAC 3,172.0 58.1 756.0 1.54 24.48 8,046.1 3,369.4 10.64 2.39 2.54
W.W. Grainger, Inc. GWW 8,950.0 43.8 690.0 1.66 24.41 13,706.55 3,089.92 19.86 4.44 1.53
Gap, Inc. (The) GPS 14,549.0 36.2 833.0 2.69 24.37 9,668.62 3,027.44 11.61 3.19 0.66
Symantec Corporation SYMC 6,730.0 83.9 1,172.0 2.56 24.36 13,262.04 5,265.92 11.32 2.52 1.97
T. Rowe Price Group, Inc. TROW 3,023.0 92.7 884.0 1.09 24.32 16,719.66 3,904.56 18.91 4.28 5.53
Agilent Technologies, Inc. A 6,858.0 52.6 1,153.0 2.03 24.3 13,205.73 5,287.94 11.45 2.5 1.93
Chipotle Mexican Grill, Inc. CMG 2,731.0 27.1 278.0 1.34 24.28 8,733.44 1,282.24 31.42 6.81 3.2
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
Amphenol Corporation APH 4,292.0 31.3 555.0 2.15 24.14 10,151.6 2,492.8 18.29 4.07 2.37
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
Sysco Corporation SYY 42,381.0 18.1 1,122.0 2.58 23.89 16,963.2 4,712.0 15.12 3.6 0.4
Cognizant Technology Solutions Corporation CTSH 7,346.0 41.8 1,051.0 1.34 23.87 21,716.82 4,923.54 20.66 4.41 2.96