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
Xylem Inc. XYL 3,791.0 39.6 297.0 2.26 15.23 4,925.28 2,077.62 16.58 2.37 1.3
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
Computer Sciences Corporation CSC 15,877.0 6.1 -4,242.0 4.03 -82.51 4,877.85 2,776.05 1.76 0.31
Vornado Realty Trust VNO 2,427.0 617.0 3.92 9.62 4,787.2 5,619.35 7.76 0.85 1.97
Jabil Circuit, Inc. JBL 17,152.0 7.6 395.0 3.71 19.87 4,783.37 2,156.42 12.11 2.22 0.28
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
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
Harris Corporation HRS 5,451.0 34.5 31.0 2.88 1.38 4,698.9 1,988.35 2.36 0.86
AGL Resources, Inc. GAS 3,922.0 54.3 271.0 4.14 8.05 4,695.22 3,417.28 17.33 1.37 1.2
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
Potomac Electric Power Company POM 5,081.0 47.9 285.0 3.55 6.49 4,535.6 4,445.9 15.91 1.02 0.89
Constellation Brands Inc STZ 2,654.0 40.0 445.0 2.66 17.02 4,483.05 2,877.93 10.07 1.56 1.69
Safeway Inc. SWY 44,207.0 26.5 597.0 5.01 18.05 4,423.08 3,008.58 7.41 1.47 0.1
Cliffs Natural Resources Inc. CLF 5,873.0 20.0 -899.0 2.93 -17.27 4,382.12 4,616.42 0.95 0.75
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
Molex Incorporated MOLX 3,489.0 30.6 281.0 1.48 11.7 4,297.56 2,449.68 15.29 1.75 1.23
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
Gannett Co., Inc. GCI 5,353.0 45.0 424.0 2.71 18.14 4,230.45 2,422.14 9.98 1.75 0.79
Integrys Energy Group TEG 4,212.0 43.8 285.0 3.36 9.24 4,224.13 3,120.5 14.82 1.35 1.0
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
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
LSI Logic Corporation LSI 2,506.0 49.2 196.0 2.03 17.69 4,096.05 1,225.91 20.9 3.34 1.63
Robert Half International Inc. RHI 4,111.0 40.1 210.0 1.64 25.56 4,089.38 839.56 19.47 4.87 0.99
The NASDAQ OMX Group, Inc. NDAQ 3,119.0 53.3 352.0 1.75 6.91 4,062.04 5,440.85 11.54 0.75 1.3
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
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
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
Legg Mason, Inc. LM 2,663.0 100.0 221.0 1.51 3.86 3,929.64 5,810.09 17.78 0.68 1.48
Leggett & Platt, Incorporated LEG 3,721.0 20.1 248.0 2.27 18.19 3,899.66 1,474.6 15.72 2.64 1.05
Cablevision Systems Corporation CVC 6,705.0 50.4 234.0 3,823.44 -5,687.1 16.34 0.57