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
Raytheon Company RTN 24,414.0 21.8 1,888.0 3.32 23.3 19,341.94 8,172.98 10.24 2.37 0.79
Abbott Laboratories ABT 39,874.0 62.1 5,963.0 2.52 23.31 104,005.36 26,984.4 17.44 3.85 2.61
Big Lots, Inc. BIG 5,202.0 39.8 207.0 1.99 23.4 2,660.64 892.86 12.85 2.98 0.51
CBRE Group, Inc. CBG 6,514.0 42.5 316.0 5.07 23.46 6,324.18 1,523.82 20.01 4.15 0.97
O'Reilly Automotive, Inc. ORLY 6,182.0 50.1 586.0 2.73 23.65 11,099.52 2,295.18 18.94 4.84 1.8
Perrigo Company PRGO 3,173.0 34.5 402.0 2.17 23.76 9,982.8 1,862.14 24.83 5.36 3.15
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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