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
Hewlett-Packard Company HPQ 120,357.0 23.2 -12,650.0 4.85 -41.43 27,991.32 22,562.82 1.24 0.23
Sprint Nextel Corporation S 35,345.0 41.0 -4,326.0 7.28 -46.73 16,991.32 7,054.7 2.41 0.48
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
Boston Scientific Corporation BSX 7,249.0 67.6 -4,068.0 2.5 -44.65 8,033.97 7,133.49 1.13 1.11
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
Best Buy Co., Inc. BBY 50,705.0 24.8 -1,231.0 4.27 -23.79 9,179.28 0.18
Newfield Exploration Company NFX 2,567.0 66.6 -1,184.0 2.85 -35.34 3,511.35 2,772.9 1.27 1.37
Advanced Micro Devices, Inc. AMD 5,422.0 22.8 -1,183.0 7.43 -111.18 1,719.12 555.75 3.09 0.32
Micron Technology, Inc. MU 8,234.0 11.8 -1,032.0 1.86 -12.76 6,699.16 7,501.87 0.89 0.81
Ameren Corporation AEE 6,828.0 63.5 -974.0 3.3 -13.4 7,234.11 6,626.61 1.09 1.06
The AES Corporation AES 18,141.0 20.5 -912.0 9.16 -17.35 8,093.6 4,635.7 1.75 0.45
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
Chesapeake Energy Corporation CHK 12,316.0 41.0 -769.0 3.33 -7.21 10,924.57 12,107.69 0.9 0.89
Southwestern Energy Company SWN 2,715.0 69.2 -707.0 2.22 -20.19 11,747.34 3,018.85 3.89 4.33
R.R. Donnelley & Sons Company RRD 10,222.0 22.8 -651.0 137.55 -118.92 1,704.6 52.2 32.66 0.17
Peabody Energy Corporation BTU 8,078.0 26.6 -586.0 3.22 -11.27 7,316.4 4,893.68 1.5 0.91
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
WPX Energy, Inc. WPX 3,189.0 41.4 -223.0 1.8 -4.07 3,052.66 5,259.57 0.58 0.96
Devon Energy Corporation DVN 9,502.0 65.1 -206.0 2.04 -0.96 21,189.6 21,226.05 1.0 2.23
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
United States Steel Corporation X 19,328.0 8.8 -124.0 4.38 -3.55 3,146.4 3,470.4 0.91 0.16
Masco Corporation MAS 7,745.0 25.2 -114.0 21.35 -26.86 5,538.63 321.08 17.25 0.72
E*TRADE Financial Corporation ETFC 1,899.0 -113.0 9.66 -2.29 2,376.66 4,902.04 0.48 1.25
First Solar, Inc. FSLR 3,369.0 25.3 -96.0 1.76 -2.66 2,612.61 3,599.19 0.73 0.78
Edison International EIX 11,862.0 65.1 -92.0 4.71 -1.88 14,737.8 9,553.5 1.54 1.24
JDS Uniphase Corporation JDSU 1,682.0 42.2 -56.0 1.8 -5.28 2,419.6 1,032.7 2.34 1.44
Vulcan Materials Company VMC 2,567.0 13.0 -53.0 2.16 -1.39 6,771.7 3,768.7 1.8 2.64
Avon Products, Inc. AVP 10,717.0 61.1 -43.0 6.07 -3.05 6,229.44 1,218.24 5.11 0.58
AMB Property Corporation PLD 2,006.0 71.6 -40.0 2.19 -0.63 16,182.8 12,438.4 1.3 8.07
Amazon.com, Inc. AMZN 61,093.0 24.8 -39.0 3.97 -0.49 112,239.81 8,172.12 13.73 1.84