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
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
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
Pepsico, Inc. PEP 65,492.0 52.2 6,178.0 3.33 28.65 110,580.75 22,869.0 17.9 4.84 1.69
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
Cerner Corporation CERN 2,665.0 77.2 397.0 1.31 15.44 13,803.68 2,898.72 34.77 4.76 5.18
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
Cabot Oil & Gas Corporation COG 1,205.0 72.8 132.0 2.17 6.22 10,134.33 2,141.65 76.78 4.73 8.41
Allergan, Inc. AGN 5,806.0 86.6 1,099.0 1.57 19.72 28,250.14 5,968.08 25.71 4.73 4.87
Scripps Networks Interactive, Inc SNI 2,307.0 73.5 681.0 2.27 38.95 8,840.34 1,871.19 12.98 4.72 3.83
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
Motorola Solutions, Inc. MSI 8,698.0 50.0 881.0 3.88 20.78 16,231.05 3,513.51 18.42 4.62 1.87
Public Storage PSA 1,827.0 70.4 939.0 1.67 12.84 24,253.72 5,275.24 25.83 4.6 13.28
Deere & Company DE 36,157.0 30.5 3,065.0 8.22 44.93 32,638.38 7,091.28 10.65 4.6 0.9
Reynolds American Inc RAI 8,304.0 48.0 1,272.0 3.15 22.11 24,310.4 5,401.68 19.11 4.5 2.93
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
Windstream Corporation WIN 6,156.0 52.9 168.0 12.66 12.91 4,902.3 1,099.8 29.18 4.46 0.8
Ralph Lauren Corporation RL 6,860.0 58.3 681.0 1.48 19.58 16,933.44 3,796.8 24.87 4.46 2.47
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
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
Range Resources Corporation RRC 1,458.0 72.7 13.0 2.85 0.55 10,198.4 2,321.6 4.39 6.99
Apartment Investment and Management Company AIV 1,033.0 59.9 132.0 7.55 14.96 3,415.66 779.88 25.88 4.38 3.31
Varian Medical Systems, Inc. VAR 2,807.0 42.6 427.0 1.91 31.02 6,772.09 1,559.4 15.86 4.34 2.41
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
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
Fossil, Inc. FOSL 2,858.0 56.2 343.0 1.49 29.36 5,399.11 1,262.09 15.74 4.28 1.89
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
Internationa Flavors & Fragrances, Inc. IFF 2,821.0 41.7 254.0 2.6 21.6 5,361.16 1,254.6 21.11 4.27 1.9
Federated Investors, Inc. FII 959.0 188.0 2.2 34.64 1,980.0 474.0 10.53 4.18 2.06
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
C.R. Bard, Inc. BCR 2,958.0 62.0 530.0 2.16 28.59 8,216.04 1,979.88 15.5 4.15 2.78