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
TE Connectivity Ltd. TEL 13,282.0 30.5 1,112.0 2.42 14.4 15,462.8 8,109.8 13.91 1.91 1.16
CONSOL Energy Inc. CNX 5,430.0 33.6 388.0 3.2 10.27 7,618.83 3,968.57 19.64 1.92 1.4
Zimmer Holdings, Inc. ZMH 4,472.0 74.8 755.0 1.54 13.28 11,528.0 6,010.4 15.27 1.92 2.58
Danaher Corporation DHR 18,260.0 51.6 2,392.0 1.73 13.32 38,081.33 19,721.58 15.92 1.93 2.09
Intel Corporation INTC 53,341.0 62.1 11,005.0 1.65 22.66 103,612.8 53,457.6 9.42 1.94 1.94
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
The Charles Schwab Corporation SCHW 4,899.0 928.0 15.32 10.74 17,046.75 8,708.25 18.37 1.96 3.48
CenterPoint Energy, Inc (Holding Co) CNP 7,452.0 61.4 417.0 5.32 9.79 8,565.6 4,321.5 20.54 1.98 1.15
Halliburton Company HAL 28,503.0 15.6 2,635.0 1.74 18.2 31,236.48 15,748.16 11.85 1.98 1.1
Ingersoll-Rand plc (Ireland) IR 14,035.0 30.5 1,019.0 2.59 14.48 14,862.69 7,519.98 14.59 1.98 1.06
Comcast Corporation CMCSA 62,570.0 68.1 6,203.0 3.34 12.84 101,208.25 50,807.9 16.32 1.99 1.62
Norfolk Souther Corporation NSC 11,040.0 63.4 1,749.0 3.11 17.78 20,176.0 10,101.0 11.54 2.0 1.83
Southern Company (The) SO 16,537.0 66.1 2,415.0 3.32 12.6 38,394.72 19,241.31 15.9 2.0 2.32
Lowe's Companies, Inc. LOW 50,208.0 34.6 1,839.0 2.03 10.62 33,645.39 16,803.6 18.3 2.0 0.67
Interpublic Group of Companies, Inc. (The) IPG 6,956.0 100.0 447.0 6.14 19.6 5,151.51 2,534.87 11.52 2.03 0.74
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
CMS Energy Corporation CMS 6,253.0 48.8 382.0 5.36 12.28 6,644.3 3,252.21 17.39 2.04 1.06
AT&T Inc. T 127,434.0 56.7 7,264.0 2.95 7.34 196,342.33 96,337.55 27.03 2.04 1.54
Spectra Energy Corp SE 5,075.0 79.6 940.0 3.41 11.03 17,935.04 8,810.08 19.08 2.04 3.53
Target Corporation TGT 69,865.0 30.9 2,929.0 2.95 18.71 33,372.36 16,169.76 11.39 2.06 0.48
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
Wisconsin Energy Corporation WEC 4,246.0 61.3 546.0 3.43 13.39 8,753.81 4,238.27 16.03 2.07 2.06
Beam Inc. BEAM 2,466.0 58.3 382.0 1.87 8.78 9,643.9 4,638.41 25.25 2.08 3.91
Diamond Offshore Drilling, Inc. DO 2,987.0 46.9 720.0 1.58 16.17 9,546.52 4,575.88 13.26 2.09 3.2
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
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
NVIDIA Corporation NVDA 3,998.0 51.4 581.0 1.34 15.86 8,919.68 4,170.32 15.35 2.14 2.23
General Dynamics Corporation GD 31,513.0 16.2 -332.0 3.01 -2.7 24,092.25 11,281.88 2.14 0.76
Lennar Corporation LEN 4,105.0 11.0 679.0 3.03 22.23 8,346.09 3,904.77 12.29 2.14 2.03
Avery Dennison Corporation AVY 6,036.0 26.1 215.0 3.23 13.3 3,523.52 1,645.28 16.39 2.14 0.58