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
Hartford Financial Services Group, Inc. (The) HIG 26,412.0 -38.0 13.64 -0.36 9,557.16 21,974.46 0.43 0.36
First Tennessee National Corporation FHN 1,360.0 -28.0 11.53 -1.21 2,323.76 2,254.32 1.03 1.71
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
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
Netflix, Inc. NFLX 3,609.0 27.2 17.0 5.33 2.47 5,003.2 790.6 6.33 1.39
Harris Corporation HRS 5,451.0 34.5 31.0 2.88 1.38 4,698.9 1,988.35 2.36 0.86
Hospira Inc HSP 4,092.0 27.2 44.0 2.0 1.48 5,316.98 3,054.4 1.74 1.3
SAIC Inc SAI 10,587.0 9.3 59.0 3.06 2.53 4,354.56 2,150.4 73.81 2.03 0.41
Host Marriott Financial Trust HST 5,286.0 38.3 61.0 1.9 0.9 10,900.8 6,782.4 1.61 2.06
Morgan Stanley MS 26,112.0 68.0 12.89 -0.05 32,642.19 58,913.3 0.55 1.25
PerkinElmer, Inc. PKI 2,115.0 45.5 70.0 2.01 3.7 3,585.7 1,938.9 51.22 1.85 1.7
Electronic Arts Inc. EA 4,143.0 61.4 76.0 2.23 3.03 5,799.36 2,493.12 76.31 2.33 1.4
Applied Materials, Inc. AMAT 8,719.0 38.0 109.0 1.67 1.36 13,919.3 7,713.08 1.8 1.6
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
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
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
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
Washington Post Company (The) WPO 4,018.0 53.2 132.0 1.97 5.06 2,610.58 2,437.19 19.78 1.07 0.65
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
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
Tenet Healthcare Corporation THC 9,119.0 36.3 152.0 7.91 12.63 3,227.49 1,190.28 21.23 2.71 0.35
Allegheny Technologies Incorporated ATI 5,032.0 13.8 158.0 2.52 6.39 3,222.18 2,701.53 20.39 1.19 0.64
Dean Foods Company DF 11,462.0 25.3 159.0 15.92 125.0 3,158.28 357.12 19.86 8.84 0.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
Windstream Corporation WIN 6,156.0 52.9 168.0 12.66 12.91 4,902.3 1,099.8 29.18 4.46 0.8
Lam Research Corporation LRCX 2,665.0 40.7 169.0 1.56 4.44 4,702.5 3,436.25 27.83 1.37 1.76
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
Bemis Company, Inc. BMS 5,139.0 18.4 174.0 2.55 10.79 3,465.28 1,653.6 19.92 2.1 0.67
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
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