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
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
Parker-Hannifin Corporation PH 13,146.0 24.2 1,152.0 2.28 22.41 12,596.85 5,025.1 10.93 2.51 0.96
Hormel Foods Corporation HRL 8,231.0 16.2 500.0 1.62 18.26 7,809.07 2,883.68 15.62 2.71 0.95
Omnicom Group Inc. OMC 14,219.0 100.0 998.0 6.4 28.67 13,340.7 3,566.7 13.37 3.74 0.94
Frontier Communications Corporation FTR 5,012.0 89.6 137.0 4.32 3.19 4,672.32 4,077.12 34.1 1.15 0.93
PACCAR Inc. PCAR 17,051.0 18.4 1,112.0 3.19 19.83 15,845.56 5,888.24 14.25 2.69 0.93
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
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
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
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
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
Harris Corporation HRS 5,451.0 34.5 31.0 2.88 1.38 4,698.9 1,988.35 2.36 0.86
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
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
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
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
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
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
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
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
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
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