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
Hershey Company (The) HSY 6,644.0 43.0 661.0 4.59 70.1 16,598.4 1,055.64 25.11 15.72 2.5
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
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
Lennar Corporation LEN 4,105.0 11.0 679.0 3.03 22.23 8,346.09 3,904.77 12.29 2.14 2.03
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
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
Nordstrom, Inc. JWN 10,877.0 39.4 683.0 4.34 34.35 10,760.48 2,053.56 15.75 5.24 0.99
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
Moody's Corporation MCO 2,730.0 70.9 690.0 10.28 638.3 11,150.24 392.71 16.16 28.39 4.08
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
Ecolab Inc. ECL 11,839.0 45.2 704.0 2.89 11.98 21,539.96 6,165.38 30.6 3.49 1.82
Broadcom Corporation BRCM 8,006.0 49.7 719.0 1.43 10.01 19,578.24 7,937.28 27.23 2.47 2.45
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
Diamond Offshore Drilling, Inc. DO 2,987.0 46.9 720.0 1.58 16.17 9,546.52 4,575.88 13.26 2.09 3.2
Rockwell Automation, Inc. ROK 6,259.0 40.3 737.0 3.04 40.95 10,358.92 1,876.16 14.06 5.52 1.66
Tesoro Petroleum Corporation TSO 32,974.0 7.4 743.0 2.52 18.77 5,804.96 4,369.34 7.81 1.33 0.18
Cameron International Corporation CAM 8,502.0 29.1 751.0 2.0 14.61 13,644.96 5,594.88 18.17 2.44 1.6
St. Jude Medical, Inc. STJ 5,503.0 72.1 752.0 2.26 17.55 11,110.05 4,362.75 14.77 2.55 2.02
Zimmer Holdings, Inc. ZMH 4,472.0 74.8 755.0 1.54 13.28 11,528.0 6,010.4 15.27 1.92 2.58
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
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
FirstEnergy Corporation FE 15,303.0 56.2 770.0 3.85 5.84 17,409.45 13,110.51 22.61 1.33 1.14
Campbell Soup Company CPB 7,707.0 38.8 774.0 7.27 77.95 10,402.59 918.72 13.44 11.32 1.35
Mattel, Inc. MAT 6,421.0 53.1 776.0 2.13 27.35 12,826.22 3,100.16 16.53 4.14 2.0
CenturyLink, Inc. CTL 18,376.0 58.4 777.0 2.8 3.87 23,654.66 19,176.26 30.44 1.23 1.29
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
International Paper Company IP 27,833.0 26.0 794.0 5.1 12.29 15,985.2 6,305.2 20.13 2.54 0.57
Principal Financial Group Inc PFG 9,215.0 806.0 16.6 7.97 8,319.0 9,960.0 10.32 0.84 0.9
United Parcel Service, Inc. UPS 54,127.0 76.6 807.0 8.35 13.81 71,395.92 4,738.41 88.47 15.07 1.32
L-3 Communications Holdings, Inc. LLL 13,146.0 10.3 810.0 2.53 13.39 7,511.7 5,920.18 9.27 1.27 0.57