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
Prudential Financial, Inc. PRU 84,815.0 469.0 18.39 1.24 24,570.0 38,820.6 52.39 0.63 0.29
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
Range Resources Corporation RRC 1,458.0 72.7 13.0 2.85 0.55 10,198.4 2,321.6 4.39 6.99
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
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
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
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
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
First Tennessee National Corporation FHN 1,360.0 -28.0 11.53 -1.21 2,323.76 2,254.32 1.03 1.71
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
Edison International EIX 11,862.0 65.1 -92.0 4.71 -1.88 14,737.8 9,553.5 1.54 1.24
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
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
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
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
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
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
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
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
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
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
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
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
Best Buy Co., Inc. BBY 50,705.0 24.8 -1,231.0 4.27 -23.79 9,179.28 0.18
Masco Corporation MAS 7,745.0 25.2 -114.0 21.35 -26.86 5,538.63 321.08 17.25 0.72
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