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
Boeing Company (The) BA 81,698.0 16.0 3,900.0 15.15 83.14 57,553.86 5,913.12 14.76 9.73 0.7
Masco Corporation MAS 7,745.0 25.2 -114.0 21.35 -26.86 5,538.63 321.08 17.25 0.72
ONEOK, Inc. OKE 12,633.0 18.6 361.0 7.45 16.51 9,062.45 2,192.29 25.1 4.13 0.72
MetroPCS Communications, Inc. PCS 5,101.0 42.6 394.0 3.03 12.54 3,737.6 3,372.6 9.49 1.11 0.73
Interpublic Group of Companies, Inc. (The) IPG 6,956.0 100.0 447.0 6.14 19.6 5,151.51 2,534.87 11.52 2.03 0.74
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
Genuine Parts Company GPC 13,014.0 29.0 648.0 2.27 22.42 9,929.4 3,020.16 15.32 3.29 0.76
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
Progressive Corporation (The) PGR 17,084.0 902.0 3.78 15.28 13,169.28 6,043.52 14.6 2.18 0.77
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
Gannett Co., Inc. GCI 5,353.0 45.0 424.0 2.71 18.14 4,230.45 2,422.14 9.98 1.75 0.79
Raytheon Company RTN 24,414.0 21.8 1,888.0 3.32 23.3 19,341.94 8,172.98 10.24 2.37 0.79
Windstream Corporation WIN 6,156.0 52.9 168.0 12.66 12.91 4,902.3 1,099.8 29.18 4.46 0.8
ConAgra Foods, Inc. CAG 13,263.0 21.3 468.0 2.58 10.24 10,725.88 4,552.02 22.92 2.36 0.81
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
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
Ball Corporation BLL 8,736.0 17.9 404.0 6.74 34.58 7,037.32 1,175.52 17.42 5.99 0.81
Apollo Group, Inc. APOL 4,253.0 57.7 423.0 3.09 38.98 3,490.42 1,008.94 8.25 3.46 0.82
Exxon Mobil Corporation XOM 482,295.0 29.9 44,880.0 2.01 28.03 409,161.48 170,495.52 9.12 2.4 0.85
Darden Restaurants, Inc. DRI 7,999.0 22.9 476.0 3.23 25.17 6,768.37 1,899.24 14.22 3.56 0.85
American International Group, Inc. AIG 65,656.0 3,438.0 5.6 3.39 56,278.32 111,983.06 16.37 0.5 0.86
Harris Corporation HRS 5,451.0 34.5 31.0 2.88 1.38 4,698.9 1,988.35 2.36 0.86
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
C.H. Robinson Worldwide, Inc. CHRW 11,359.0 15.1 594.0 1.86 43.14 10,034.28 1,511.46 16.89 6.64 0.88
Baker Hughes Incorporated BHI 21,361.0 18.7 1,311.0 1.56 7.99 18,698.4 17,071.11 14.26 1.1 0.88
Potomac Electric Power Company POM 5,081.0 47.9 285.0 3.55 6.49 4,535.6 4,445.9 15.91 1.02 0.89
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
Caterpillar, Inc. CAT 65,875.0 28.6 5,681.0 5.1 37.36 58,444.1 17,929.2 10.29 3.26 0.89
Deere & Company DE 36,157.0 30.5 3,065.0 8.22 44.93 32,638.38 7,091.28 10.65 4.6 0.9
Principal Financial Group Inc PFG 9,215.0 806.0 16.6 7.97 8,319.0 9,960.0 10.32 0.84 0.9