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
TripAdvisor, Inc. TRIP 763.0 98.4 194.0 1.79 38.03 5,412.99 717.69 27.9 7.54 7.09
Hudson City Bancorp, Inc. HCBK 865.0 249.0 8.64 5.38 4,005.82 4,423.3 16.09 0.91 4.63
VeriSign, Inc. VRSN 874.0 80.8 320.0 6,066.36 -9.84 18.96 6.94
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
Federated Investors, Inc. FII 959.0 188.0 2.2 34.64 1,980.0 474.0 10.53 4.18 2.06
Apartment Investment and Management Company AIV 1,033.0 59.9 132.0 7.55 14.96 3,415.66 779.88 25.88 4.38 3.31
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
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
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
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
People's United Financial, Inc. PBCT 1,243.0 245.0 6.02 4.78 4,110.08 5,015.92 16.78 0.82 3.31
Linear Technology Corporation LLTC 1,267.0 75.3 398.0 2.51 64.1 6,977.88 748.8 17.53 9.32 5.51
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
First Tennessee National Corporation FHN 1,360.0 -28.0 11.53 -1.21 2,323.76 2,254.32 1.03 1.71
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
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
F5 Networks, Inc. FFIV 1,377.0 82.9 275.0 1.44 22.6 7,730.4 1,345.6 28.11 5.74 5.61
Microchip Technology Incorporated MCHP 1,383.0 57.3 337.0 1.55 17.71 7,370.52 2,113.44 21.87 3.49 5.33
Rowan Companies plc RDC 1,393.0 46.0 181.0 1.7 4.08 3,972.9 4,487.04 21.95 0.89 2.85
FLIR Systems, Inc. FLIR 1,405.0 52.0 222.0 1.36 13.99 3,133.9 1,689.38 14.12 1.86 2.23
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
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
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
Dun & Bradstreet Corporation (The) DNB 1,663.0 68.7 296.0 3,740.72 -1,132.98 12.64 2.25
JDS Uniphase Corporation JDSU 1,682.0 42.2 -56.0 1.8 -5.28 2,419.6 1,032.7 2.34 1.44
Altera Corporation ALTR 1,783.0 69.6 557.0 1.4 17.6 10,400.4 3,379.32 18.67 3.08 5.83
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
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
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
Total System Services, Inc. TSS 1,871.0 32.5 244.0 1.42 17.92 4,150.44 1,440.18 17.01 2.88 2.22