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
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
Pepsico, Inc. PEP 65,492.0 52.2 6,178.0 3.33 28.65 110,580.75 22,869.0 17.9 4.84 1.69
Southern Company (The) SO 16,537.0 66.1 2,415.0 3.32 12.6 38,394.72 19,241.31 15.9 2.0 2.32
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
Chubb Corporation (The) CB 13,595.0 1,545.0 3.3 9.84 20,921.2 16,384.66 13.54 1.28 1.54
Ameren Corporation AEE 6,828.0 63.5 -974.0 3.3 -13.4 7,234.11 6,626.61 1.09 1.06
General Mills, Inc. GIS 16,658.0 36.3 1,567.0 3.29 24.51 26,179.75 6,603.3 16.71 3.96 1.57
Honeywell International Inc. HON 37,665.0 24.9 2,926.0 3.23 24.61 48,993.12 13,131.36 16.74 3.73 1.3
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
Avery Dennison Corporation AVY 6,036.0 26.1 215.0 3.23 13.3 3,523.52 1,645.28 16.39 2.14 0.58
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
TECO Energy, Inc. TE 2,997.0 37.3 213.0 3.21 9.33 3,624.9 2,274.7 17.02 1.59 1.21
FMC Technologies, Inc. FTI 6,151.0 21.4 430.0 3.21 26.37 10,112.36 1,867.75 23.52 5.41 1.64
CONSOL Energy Inc. CNX 5,430.0 33.6 388.0 3.2 10.27 7,618.83 3,968.57 19.64 1.92 1.4
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
Reynolds American Inc RAI 8,304.0 48.0 1,272.0 3.15 22.11 24,310.4 5,401.68 19.11 4.5 2.93
Newell Rubbermaid Inc. NWL 5,903.0 37.8 401.0 3.12 20.87 6,541.5 2,046.24 16.31 3.2 1.11
CarMax Inc KMX 10,004.0 13.8 414.0 3.12 16.67 6,909.21 2,718.87 16.69 2.54 0.69
Norfolk Souther Corporation NSC 11,040.0 63.4 1,749.0 3.11 17.78 20,176.0 10,101.0 11.54 2.0 1.83
Expedia, Inc. EXPE 4,030.0 77.7 280.0 3.11 12.51 8,079.4 2,359.0 28.86 3.42 2.0
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
Weyerhaeuser Company WY 7,059.0 17.7 385.0 3.09 9.24 14,877.9 4,065.0 38.64 3.66 2.11
PulteGroup, Inc. PHM 4,820.0 15.7 206.0 3.08 9.99 6,314.0 2,179.1 30.65 2.9 1.31
SAIC Inc SAI 10,587.0 9.3 59.0 3.06 2.53 4,354.56 2,150.4 73.81 2.03 0.41
Alcoa Inc. AA 23,700.0 13.6 191.0 3.06 1.42 9,221.32 13,256.32 48.28 0.7 0.39
Northeast Utilities NU 6,274.0 61.8 526.0 3.06 7.94 10,880.92 8,175.98 20.69 1.33 1.73
Airgas, Inc. ARG 4,746.0 54.2 313.0 3.04 17.98 6,477.12 1,787.76 20.69 3.62 1.36
Rockwell Automation, Inc. ROK 6,259.0 40.3 737.0 3.04 40.95 10,358.92 1,876.16 14.06 5.52 1.66
Cincinnati Financial Corporation CINF 4,111.0 421.0 3.03 8.01 6,655.12 5,485.8 15.81 1.21 1.62
Boston Properties, Inc. BXP 1,876.0 63.5 290.0 3.03 5.81 15,853.49 5,076.62 54.67 3.12 8.45