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
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
Ball Corporation BLL 8,736.0 17.9 404.0 6.74 34.58 7,037.32 1,175.52 17.42 5.99 0.81
CMS Energy Corporation CMS 6,253.0 48.8 382.0 5.36 12.28 6,644.3 3,252.21 17.39 2.04 1.06
Archer-Daniels-Midland Company ADM 89,038.0 4.1 1,223.0 2.31 6.65 21,212.1 18,175.14 17.34 1.17 0.24
AGL Resources, Inc. GAS 3,922.0 54.3 271.0 4.14 8.05 4,695.22 3,417.28 17.33 1.37 1.2
IntercontinentalExchange, Inc. ICE 1,363.0 96.6 552.0 10.21 16.31 9,563.0 3,669.71 17.32 2.61 7.02
Teradyne, Inc. TER 1,657.0 53.5 217.0 1.37 13.22 3,755.9 2,175.8 17.31 1.73 2.27
DTE Energy Company DTE 8,791.0 62.5 610.0 3.57 8.48 10,517.8 7,358.16 17.24 1.43 1.2
Procter & Gamble Company (The) PG 83,680.0 49.3 10,756.0 2.12 16.72 184,547.75 66,819.52 17.16 2.76 2.21
Philip Morris International Inc PM 77,393.0 27.1 8,800.0 150,706.44 -3,553.2 17.13 1.95
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
TECO Energy, Inc. TE 2,997.0 37.3 213.0 3.21 9.33 3,624.9 2,274.7 17.02 1.59 1.21
Total System Services, Inc. TSS 1,871.0 32.5 244.0 1.42 17.92 4,150.44 1,440.18 17.01 2.88 2.22
Noble Corporation NE 3,547.0 45.9 522.0 1.89 6.9 8,824.64 7,711.44 16.91 1.14 2.49
Flowserve Corporation FLS 4,751.0 33.3 448.0 2.55 21.55 7,573.7 2,081.31 16.91 3.64 1.59
C.H. Robinson Worldwide, Inc. CHRW 11,359.0 15.1 594.0 1.86 43.14 10,034.28 1,511.46 16.89 6.64 0.88
NYSE Euronext, Inc. NYX 3,749.0 62.0 348.0 1.98 5.38 5,875.0 6,555.0 16.88 0.9 1.57
Cintas Corporation CTAS 4,102.0 42.4 298.0 1.95 13.4 5,011.5 2,198.3 16.82 2.28 1.22
People's United Financial, Inc. PBCT 1,243.0 245.0 6.02 4.78 4,110.08 5,015.92 16.78 0.82 3.31
Patterson Companies, Inc. PDCO 3,536.0 32.9 213.0 1.99 14.5 3,571.98 1,388.61 16.77 2.57 1.01
Northern Trust Corporation NTRS 3,896.0 687.0 12.95 9.39 11,502.93 7,591.5 16.74 1.52 2.95
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
American Electric Power Company, Inc. AEP 14,945.0 64.7 1,259.0 3.57 8.42 21,034.45 15,214.45 16.71 1.38 1.41
Quest Diagnostics Incorporated DGX 7,383.0 40.9 556.0 2.23 14.15 9,286.4 4,206.4 16.7 2.21 1.26
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
McDonald's Corporation MCD 27,567.0 39.2 5,465.0 2.31 36.82 91,198.2 15,555.0 16.69 5.86 3.31
Invesco Plc IVZ 4,177.0 100.0 677.0 2.1 8.24 11,281.9 8,757.66 16.66 1.29 2.7
Waters Corporation WAT 1,844.0 60.0 461.0 2.16 34.26 7,654.0 1,512.11 16.6 5.06 4.15
Xylem Inc. XYL 3,791.0 39.6 297.0 2.26 15.23 4,925.28 2,077.62 16.58 2.37 1.3