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
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
Newell Rubbermaid Inc. NWL 5,903.0 37.8 401.0 3.12 20.87 6,541.5 2,046.24 16.31 3.2 1.11
TECO Energy, Inc. TE 2,997.0 37.3 213.0 3.21 9.33 3,624.9 2,274.7 17.02 1.59 1.21
Wynn Resorts, Limited WYNN 5,154.0 36.9 502.0 54.87 11,444.16 -267.28 22.8 2.22
Stanley Black & Decker, Inc. SWK 10,191.0 36.4 884.0 2.38 12.93 11,997.28 6,960.56 13.57 1.72 1.18
Tyco International, Ltd. (Switzerland) TYC 10,403.0 36.3 472.0 2.48 4.92 25,742.8 5,005.03 54.54 5.14 2.47
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
General Mills, Inc. GIS 16,658.0 36.3 1,567.0 3.29 24.51 26,179.75 6,603.3 16.71 3.96 1.57
Gap, Inc. (The) GPS 14,549.0 36.2 833.0 2.69 24.37 9,668.62 3,027.44 11.61 3.19 0.66
Illinois Tool Works Inc. ITW 17,924.0 36.1 2,870.0 1.83 27.89 29,311.81 10,978.33 10.21 2.67 1.64
Coca-Cola Enterprises, Inc. CCE 8,062.0 36.0 677.0 3.53 24.21 9,598.89 2,874.55 14.18 3.34 1.19
Lorillard, Inc LO 6,623.0 36.0 1,099.0 46,917.0 -1,813.5 42.69 7.08
J.C. Penney Company, Inc. Holding Company JCP 17,260.0 36.0 -152.0 2.85 -3.21 7,469.14 4,029.69 1.85 0.43
Dollar Tree, Inc. DLTR 6,631.0 35.9 488.0 1.73 34.83 20,013.4 1,408.44 41.01 14.21 3.02
Freeport-McMoran Copper & Gold, Inc. FCX 18,010.0 35.8 3,041.0 2.02 18.33 30,566.16 17,639.46 10.05 1.73 1.7
FMC Corporation FMC 3,748.0 35.8 416.0 2.95 30.59 7,469.86 1,494.25 17.96 5.0 1.99
Whole Foods Market, Inc. WFM 11,699.0 35.5 466.0 1.39 13.71 17,991.52 3,788.56 38.61 4.75 1.54
Waste Management, Inc. WM 13,649.0 34.9 817.0 3.64 13.15 15,929.12 6,352.16 19.5 2.51 1.17
Family Dollar Stores, Inc. FDO 9,331.0 34.9 422.0 2.6 35.41 7,517.78 1,327.5 17.81 5.66 0.81
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
Home Depot, Inc. (The) HD 70,395.0 34.5 3,883.0 2.26 21.11 68,342.1 18,274.8 17.6 3.74 0.97
Perrigo Company PRGO 3,173.0 34.5 402.0 2.17 23.76 9,982.8 1,862.14 24.83 5.36 3.15
Harris Corporation HRS 5,451.0 34.5 31.0 2.88 1.38 4,698.9 1,988.35 2.36 0.86
H.J. Heinz Company HNZ 11,649.0 34.3 923.0 4.34 31.47 16,980.11 2,781.03 18.4 6.11 1.46
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
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
J.M. Smucker Company (The) SJM 5,526.0 33.4 460.0 1.77 8.79 9,075.03 5,290.66 19.73 1.72 1.64
Sealed Air Corporation SEE 7,648.0 33.3 -1,410.0 6.54 -64.09 3,198.01 1,432.06 2.23 0.42
Flowserve Corporation FLS 4,751.0 33.3 448.0 2.55 21.55 7,573.7 2,081.31 16.91 3.64 1.59
SanDisk Corporation SNDK 5,053.0 33.3 417.0 1.42 5.83 10,483.55 7,372.05 25.14 1.42 2.07