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
Akamai Technologies, Inc. AKAM 1,374.0 68.6 204.0 1.11 9.06 7,134.4 2,400.58 34.97 2.97 5.19
Kellogg Company K 14,197.0 38.3 961.0 6.28 45.99 20,206.8 2,412.0 21.03 8.38 1.42
Gannett Co., Inc. GCI 5,353.0 45.0 424.0 2.71 18.14 4,230.45 2,422.14 9.98 1.75 0.79
Washington Post Company (The) WPO 4,018.0 53.2 132.0 1.97 5.06 2,610.58 2,437.19 19.78 1.07 0.65
Molex Incorporated MOLX 3,489.0 30.6 281.0 1.48 11.7 4,297.56 2,449.68 15.29 1.75 1.23
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
Electronic Arts Inc. EA 4,143.0 61.4 76.0 2.23 3.03 5,799.36 2,493.12 76.31 2.33 1.4
AmerisourceBergen Corporation (Holding Co) ABC 79,490.0 3.4 719.0 6.29 27.01 9,773.71 2,508.32 13.59 3.9 0.12
Interpublic Group of Companies, Inc. (The) IPG 6,956.0 100.0 447.0 6.14 19.6 5,151.51 2,534.87 11.52 2.03 0.74
Sigma-Aldrich Corporation SIAL 2,623.0 51.4 460.0 1.5 19.39 8,949.92 2,588.84 19.46 3.46 3.41
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
Joy Global Inc. JOY 5,661.0 33.2 762.0 2.38 33.65 6,012.33 2,603.31 7.89 2.31 1.06
Allegheny Technologies Incorporated ATI 5,032.0 13.8 158.0 2.52 6.39 3,222.18 2,701.53 20.39 1.19 0.64
CarMax Inc KMX 10,004.0 13.8 414.0 3.12 16.67 6,909.21 2,718.87 16.69 2.54 0.69
Newfield Exploration Company NFX 2,567.0 66.6 -1,184.0 2.85 -35.34 3,511.35 2,772.9 1.27 1.37
Computer Sciences Corporation CSC 15,877.0 6.1 -4,242.0 4.03 -82.51 4,877.85 2,776.05 1.76 0.31
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
Estee Lauder Companies, Inc. (The) EL 9,714.0 79.5 857.0 2.41 31.96 21,838.97 2,790.91 25.48 7.83 2.25
Xilinx, Inc. XLNX 2,241.0 64.9 530.0 1.65 20.7 9,911.68 2,812.48 18.7 3.52 4.42
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
Intuit Inc. INTU 4,151.0 82.0 792.0 1.71 29.55 17,522.25 2,833.45 22.12 6.18 4.22
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
Constellation Brands Inc STZ 2,654.0 40.0 445.0 2.66 17.02 4,483.05 2,877.93 10.07 1.56 1.69
Hormel Foods Corporation HRL 8,231.0 16.2 500.0 1.62 18.26 7,809.07 2,883.68 15.62 2.71 0.95
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
Crown Castle International Corporation CCI 2,433.0 70.0 189.0 5.47 7.41 19,753.08 2,915.82 6.77 8.12
Safeway Inc. SWY 44,207.0 26.5 597.0 5.01 18.05 4,423.08 3,008.58 7.41 1.47 0.1
Southwestern Energy Company SWN 2,715.0 69.2 -707.0 2.22 -20.19 11,747.34 3,018.85 3.89 4.33
Genuine Parts Company GPC 13,014.0 29.0 648.0 2.27 22.42 9,929.4 3,020.16 15.32 3.29 0.76
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