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
Alcoa Inc. AA 23,700.0 13.6 191.0 3.06 1.42 9,221.32 13,256.32 48.28 0.7 0.39
EQT Corporation EQT 1,642.0 71.0 183.0 2.46 5.1 8,659.5 3,601.5 47.32 2.4 5.27
American Tower Corporation (REIT) AMT 2,876.0 74.9 637.0 3.94 18.58 29,972.88 3,606.96 47.05 8.31 10.42
Nike, Inc. NKE 24,128.0 43.4 2,223.0 1.49 21.98 101,106.4 11,815.8 45.48 8.56 4.19
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
Lorillard, Inc LO 6,623.0 36.0 1,099.0 46,917.0 -1,813.5 42.69 7.08
QEP Resources, Inc. QEP 2,350.0 49.8 128.0 2.79 3.91 5,305.56 3,277.49 41.45 1.62 2.26
News Corporation NWSA 33,706.0 38.3 1,179.0 2.3 4.35 48,677.76 976.56 41.29 49.85 1.44
Dollar Tree, Inc. DLTR 6,631.0 35.9 488.0 1.73 34.83 20,013.4 1,408.44 41.01 14.21 3.02
Visa Inc. V 10,421.0 79.5 2,144.0 1.45 7.93 87,245.04 23,092.68 40.69 3.78 8.37
Weyerhaeuser Company WY 7,059.0 17.7 385.0 3.09 9.24 14,877.9 4,065.0 38.64 3.66 2.11
Whole Foods Market, Inc. WFM 11,699.0 35.5 466.0 1.39 13.71 17,991.52 3,788.56 38.61 4.75 1.54
Edwards Lifesciences Corporation EW 1,900.0 74.0 293.0 1.5 20.82 10,865.44 1,526.92 37.08 7.12 5.72
McGraw-Hill Companies, Inc. (The) MHP 4,450.0 67.2 437.0 9.19 38.42 16,119.6 783.75 36.89 20.57 3.62
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
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
Plum Creek Timber Company, Inc. PCL 1,339.0 29.6 203.0 3.58 16.33 6,925.5 1,223.1 34.12 5.66 5.17
Frontier Communications Corporation FTR 5,012.0 89.6 137.0 4.32 3.19 4,672.32 4,077.12 34.1 1.15 0.93
TJX Companies, Inc. (The) TJX 23,191.0 27.3 1,496.0 2.58 47.43 50,743.44 3,328.2 33.92 15.25 2.19
Citrix Systems, Inc. CTXS 2,586.0 84.4 353.0 1.54 12.05 11,823.84 3,165.75 33.5 3.73 4.57
Simon Property Group, Inc. SPG 4,880.0 90.4 1,434.0 5.56 27.34 47,280.12 5,666.1 32.97 8.34 9.69
Intuitive Surgical, Inc. ISRG 2,179.0 72.1 657.0 1.13 21.09 21,600.85 3,651.46 32.88 5.92 9.91
Iron Mountain Incorporated IRM 3,005.0 57.5 172.0 5.53 14.33 5,461.75 1,058.75 31.75 5.16 1.82
Abercrombie & Fitch Company ANF 4,158.0 60.6 128.0 1.64 6.8 4,046.4 1,957.5 31.61 2.07 0.97
Chipotle Mexican Grill, Inc. CMG 2,731.0 27.1 278.0 1.34 24.28 8,733.44 1,282.24 31.42 6.81 3.2
Express Scripts Holding Company ESRX 93,858.0 7.8 1,313.0 2.49 10.15 40,741.38 21,349.26 31.03 1.91 0.43
Stericycle, Inc. SRCL 1,913.0 44.8 268.0 2.3 19.56 8,256.3 1,559.91 30.81 5.29 4.32
AvalonBay Communities, Inc. AVB 1,039.0 63.5 424.0 1.63 7.55 13,031.06 5,856.48 30.73 2.23 12.54
PulteGroup, Inc. PHM 4,820.0 15.7 206.0 3.08 9.99 6,314.0 2,179.1 30.65 2.9 1.31
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