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
Kinder Morgan, Inc. KMI 9,973.0 69.3 315.0 4.92 3.67 45,562.1 18,130.06 2.51 4.57
Morgan Stanley MS 26,112.0 68.0 12.89 -0.05 32,642.19 58,913.3 0.55 1.25
Hartford Financial Services Group, Inc. (The) HIG 26,412.0 -38.0 13.64 -0.36 9,557.16 21,974.46 0.43 0.36
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
Masco Corporation MAS 7,745.0 25.2 -114.0 21.35 -26.86 5,538.63 321.08 17.25 0.72
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
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
First Tennessee National Corporation FHN 1,360.0 -28.0 11.53 -1.21 2,323.76 2,254.32 1.03 1.71
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
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
Harris Corporation HRS 5,451.0 34.5 31.0 2.88 1.38 4,698.9 1,988.35 2.36 0.86
Edison International EIX 11,862.0 65.1 -92.0 4.71 -1.88 14,737.8 9,553.5 1.54 1.24
Hospira Inc HSP 4,092.0 27.2 44.0 2.0 1.48 5,316.98 3,054.4 1.74 1.3
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
Crown Castle International Corporation CCI 2,433.0 70.0 189.0 5.47 7.41 19,753.08 2,915.82 6.77 8.12
Eastman Chemical Company EMN 8,102.0 21.7 437.0 3.95 18.16
Ameren Corporation AEE 6,828.0 63.5 -974.0 3.3 -13.4 7,234.11 6,626.61 1.09 1.06
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
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
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
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
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
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
Salesforce.com Inc CRM 2,267.0 78.4 -12.0 2.62 -0.81 14,146.65 1,564.65 9.04 6.24
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
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
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
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
E*TRADE Financial Corporation ETFC 1,899.0 -113.0 9.66 -2.29 2,376.66 4,902.04 0.48 1.25
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