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
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
Ventas, Inc. VTR 2,485.0 60.6 363.0 2.1 3.97 19,107.06 9,084.6 52.64 2.1 7.69
Health Care REIT, Inc. HCN 1,822.0 68.7 297.0 2.11 2.88 13,492.2 8,047.86 45.43 1.68 7.41
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
Dover Corporation DOV 8,104.0 38.3 811.0 2.12 16.47 11,737.36 5,181.44 14.47 2.27 1.45
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
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
Noble Energy Inc. NBL 4,223.0 74.4 1,027.0 2.13 13.23 18,072.0 8,303.4 17.6 2.18 4.28
Nabors Industries Ltd. NBR 6,751.0 33.6 164.0 2.13 2.84 4,277.8 5,977.24 26.08 0.72 0.63
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
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
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
Vulcan Materials Company VMC 2,567.0 13.0 -53.0 2.16 -1.39 6,771.7 3,768.7 1.8 2.64
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
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
Snap-On Incorporated SNA 2,938.0 47.3 306.0 2.17 18.37 4,703.48 1,824.87 15.37 2.58 1.6
Kohl's Corporation KSS 18,804.0 38.2 1,167.0 2.17 15.98 12,474.13 7,140.85 10.69 1.75 0.66
Perrigo Company PRGO 3,173.0 34.5 402.0 2.17 23.76 9,982.8 1,862.14 24.83 5.36 3.15
LyondellBasell Industries NV LYB 45,352.0 12.7 2,848.0 2.17 26.21 31,371.49 11,234.19 11.02 2.79 0.69
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
AMB Property Corporation PLD 2,006.0 71.6 -40.0 2.19 -0.63 16,182.8 12,438.4 1.3 8.07
PetSmart, Inc PETM 6,113.0 29.5 290.0 2.2 24.97 5,970.18 1,194.72 20.59 5.0 0.98
Federated Investors, Inc. FII 959.0 188.0 2.2 34.64 1,980.0 474.0 10.53 4.18 2.06
Costco Wholesale Corporation COST 99,137.0 12.4 1,709.0 2.2 14.03 41,836.7 12,551.01 24.48 3.33 0.42
Ross Stores, Inc. ROST 8,608.0 27.5 657.0 2.21 46.51 11,571.3 1,513.4 17.61 7.65 1.34
CA Inc. CA 4,814.0 86.6 951.0 2.22 17.26 13,149.0 5,410.57 13.83 2.43 2.73
NetApp, Inc. NTAP 6,233.0 59.6 605.0 2.22 15.09 16,135.68 4,523.52 26.67 3.57 2.59
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
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
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