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
Eastman Chemical Company EMN 8,102.0 21.7 437.0 3.95 18.16
Gilead Sciences, Inc. GILD 9,703.0 74.5 2,592.0 2.28 32.3 235,001.25 19,401.45 90.66 12.11 24.22
Alexion Pharmaceuticals, Inc. ALXN 1,134.0 93.6 255.0 1.33 16.41 18,437.35 2,013.88 72.3 9.16 16.26
Public Storage PSA 1,827.0 70.4 939.0 1.67 12.84 24,253.72 5,275.24 25.83 4.6 13.28
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
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
HCP, Inc. HCP 1,901.0 85.1 833.0 1.89 8.42 19,418.36 9,963.84 23.31 1.95 10.21
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
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
Kimco Realty Corporation KIM 922.0 73.2 266.0 2.04 3.65 7,903.94 4,757.83 29.71 1.66 8.57
Boston Properties, Inc. BXP 1,876.0 63.5 290.0 3.03 5.81 15,853.49 5,076.62 54.67 3.12 8.45
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
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
Equity Residential EQR 2,124.0 64.9 842.0 2.38 13.0 17,628.8 7,126.4 20.94 2.47 8.3
Red Hat, Inc. RHT 1,133.0 84.2 147.0 1.78 10.9 9,402.12 1,422.96 63.96 6.61 8.3
Mastercard Incorporated MA 7,391.0 100.0 2,759.0 1.8 43.16 60,429.6 7,071.12 21.9 8.55 8.18
Crown Castle International Corporation CCI 2,433.0 70.0 189.0 5.47 7.41 19,753.08 2,915.82 6.77 8.12
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
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
TripAdvisor, Inc. TRIP 763.0 98.4 194.0 1.79 38.03 5,412.99 717.69 27.9 7.54 7.09
Lorillard, Inc LO 6,623.0 36.0 1,099.0 46,917.0 -1,813.5 42.69 7.08
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
Range Resources Corporation RRC 1,458.0 72.7 13.0 2.85 0.55 10,198.4 2,321.6 4.39 6.99
VeriSign, Inc. VRSN 874.0 80.8 320.0 6,066.36 -9.84 18.96 6.94
Discover Financial Services DFS 3,129.0 2,345.0 8.17 26.55 21,361.6 9.11 6.83
Biogen Idec Inc. BIIB 5,516.0 90.1 1,380.0 1.46 20.62 36,753.6 7,063.2 26.63 5.2 6.66
Celgene Corporation CELG 5,507.0 94.6 1,456.0 2.06 25.99 35,500.5 5,984.37 24.38 5.93 6.45
Salesforce.com Inc CRM 2,267.0 78.4 -12.0 2.62 -0.81 14,146.65 1,564.65 9.04 6.24
CME Group Inc. CME 2,915.0 75.5 896.0 1.81 4.17 17,947.92 21,430.6 20.03 0.84 6.16