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
Baxter International Inc. BAX 14,190.0 51.5 2,326.0 2.94 34.4 36,412.44 7,061.2 15.65 5.16 2.57
EMC Corporation EMC 21,714.0 62.8 2,733.0 1.7 13.23 55,194.12 23,405.66 20.2 2.36 2.54
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
Occidental Petroleum Corporation OXY 24,253.0 66.2 4,598.0 1.6 11.85 61,033.5 40,240.8 13.27 1.52 2.52
Denbury Resources, Inc. (Holding Company) DNR 2,456.0 77.7 525.0 2.18 10.59 6,192.88 5,298.18 11.8 1.17 2.52
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
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
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
Eli Lilly and Company LLY 22,603.0 78.8 4,089.0 2.33 28.89 55,984.04 14,386.96 13.69 3.89 2.48
Fiserv, Inc. FISV 4,482.0 42.1 611.0 2.49 18.31 11,055.18 3,534.18 18.09 3.13 2.47
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
Tyco International, Ltd. (Switzerland) TYC 10,403.0 36.3 472.0 2.48 4.92 25,742.8 5,005.03 54.54 5.14 2.47
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
Medtronic, Inc. MDT 16,184.0 76.0 3,617.0 1.93 21.87 39,612.2 17,490.0 10.95 2.26 2.45
Stryker Corporation SYK 8,657.0 67.9 1,298.0 1.54 15.95 20,984.57 8,663.46 16.17 2.42 2.42
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
Life Technologies Corporation LIFE 3,799.0 56.2 431.0 1.86 9.31 9,023.39 4,863.43 20.94 1.86 2.38
Corning Incorporated GLW 8,012.0 42.4 1,728.0 1.37 8.12 19,020.78 22,017.72 11.01 0.86 2.37
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
SLM Corporation SLM 3,549.0 939.0 40.32 20.04 8,283.45 4,791.36 8.82 1.73 2.33
Covidien plc. COV 11,852.0 57.5 1,905.0 2.11 18.69 27,599.94 10,876.68 14.49 2.54 2.33
Pall Corporation PLL 2,672.0 51.7 319.0 2.22 21.29 6,187.92 1,559.96 19.4 3.97 2.32
Southern Company (The) SO 16,537.0 66.1 2,415.0 3.32 12.6 38,394.72 19,241.31 15.9 2.0 2.32
Juniper Networks, Inc. JNPR 4,365.0 62.1 187.0 1.4 2.65 10,141.28 7,243.02 54.23 1.4 2.32
Yum! Brands, Inc. YUM 13,633.0 27.7 1,597.0 4.18 80.31 31,336.25 2,260.94 19.62 13.86 2.3
CF Industries Holdings, Inc. CF 6,104.0 51.0 1,849.0 1.72 35.38 13,889.85 6,094.4 7.51 2.28 2.28
Schlumberger N.V. SLB 42,321.0 21.9 5,490.0 1.77 16.63 96,408.0 35,028.24 17.56 2.75 2.28
Newmont Mining Corporation NEM 9,868.0 53.4 1,809.0 2.15 13.57 22,509.89 13,976.99 12.44 1.61 2.28
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
Dominion Resources, Inc. D 13,093.0 59.4 302.0 4.43 2.74 29,612.66 10,532.9 98.06 2.81 2.26