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
U.S. Bancorp USB 20,064.0 5,647.0 10.34 16.41 60,482.4 34,715.76 10.71 1.74 3.01
Hospira Inc HSP 4,092.0 27.2 44.0 2.0 1.48 5,316.98 3,054.4 1.74 1.3
SLM Corporation SLM 3,549.0 939.0 40.32 20.04 8,283.45 4,791.36 8.82 1.73 2.33
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
Ryder System, Inc. R 6,257.0 20.0 210.0 5.67 15.08 2,516.34 1,457.07 11.98 1.73 0.4
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
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
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
Northrop Grumman Corporation NOC 25,218.0 22.1 1,978.0 2.79 19.93 17,214.12 10,061.81 8.7 1.71 0.68
Cisco Systems, Inc. CSCO 46,061.0 61.2 8,041.0 1.79 16.32 88,679.64 52,310.72 11.03 1.7 1.93
Nucor Corporation NUE 19,429.0 7.8 505.0 1.85 6.68 12,968.04 7,651.08 25.68 1.69 0.67
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
Sempra Energy SRE 9,647.0 61.7 865.0 3.55 8.53 17,591.34 10,495.03 20.34 1.68 1.82
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
Johnson Controls, Inc. JCI 41,955.0 14.8 1,226.0 2.67 10.85 19,092.19 11,644.1 15.57 1.64 0.46
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
PPL Corporation PPL 12,286.0 60.3 1,526.0 4.16 14.32 16,878.0 10,481.82 11.06 1.61 1.37
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
Fidelity National Information Services, Inc. FIS 5,808.0 32.0 461.0 2.04 7.02 10,859.12 6,728.84 23.56 1.61 1.87
Newmont Mining Corporation NEM 9,868.0 53.4 1,809.0 2.15 13.57 22,509.89 13,976.99 12.44 1.61 2.28
Meadwestvaco Corporation MWV 5,459.0 20.7 205.0 2.65 6.27 5,455.14 3,389.55 26.61 1.61 1.0
Phillips 66 PSX 182,922.0 13.3 4,124.0 2.31 18.73 34,130.46 21,224.84 8.28 1.61 0.19
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
Aflac Incorporated AFL 25,364.0 2,866.0 8.2 19.44 25,124.33 16,021.04 8.77 1.57 0.99
Forest Laboratories, Inc. FRX 4,586.0 78.2 979.0 1.32 17.52 9,165.3 5,858.12 9.36 1.56 2.0
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
Cigna Corporation CI 29,119.0 1,623.0 5.5 17.92 15,085.05 9,741.3 9.29 1.55 0.52
Edison International EIX 11,862.0 65.1 -92.0 4.71 -1.88 14,737.8 9,553.5 1.54 1.24
CVS Corporation CVS 123,133.0 18.3 3,877.0 1.75 10.24 60,467.2 39,206.4 15.6 1.54 0.49
Chevron Corporation CVX 241,909.0 41.8 26,179.0 1.71 20.3 208,572.0 136,753.5 7.97 1.53 0.86