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
Texas Instruments Incorporated TXN 12,825.0 49.7 1,759.0 1.83 16.05 34,173.72 11,333.94 19.43 3.02 2.66
Johnson Controls, Inc. JCI 41,955.0 14.8 1,226.0 2.67 10.85 19,092.19 11,644.1 15.57 1.64 0.46
ENSCO plc ESV 4,301.0 52.8 1,170.0 1.57 10.29 13,381.4 11,697.8 11.44 1.14 3.11
Nike, Inc. NKE 24,128.0 43.4 2,223.0 1.49 21.98 101,106.4 11,815.8 45.48 8.56 4.19
Monsanto Company MON 13,504.0 52.2 2,045.0 1.71 17.5 46,839.6 11,955.6 22.9 3.92 3.47
Consolidated Edison Inc ED 12,188.0 68.1 1,141.0 3.47 9.68 16,540.65 11,956.35 14.5 1.38 1.36
Marathon Petroleum Corporation MPC 82,492.0 9.5 3,389.0 2.33 31.97 21,207.42 12,011.04 6.26 1.77 0.26
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
Xerox Corporation XRX 22,390.0 32.3 1,195.0 2.69 10.37 9,342.87 12,133.77 7.82 0.77 0.42
Mosaic Company (The) MOS 11,108.0 27.8 1,930.0 1.39 16.34 21,369.3 12,305.92 11.07 1.74 1.92
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
Costco Wholesale Corporation COST 99,137.0 12.4 1,709.0 2.2 14.03 41,836.7 12,551.01 24.48 3.33 0.42
Pacific Gas & Electric Co. PCG 15,040.0 66.6 830.0 4.01 6.48 17,374.0 12,898.75 20.93 1.35 1.16
FirstEnergy Corporation FE 15,303.0 56.2 770.0 3.85 5.84 17,409.45 13,110.51 22.61 1.33 1.14
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
EOG Resources, Inc. EOG 11,683.0 83.7 570.0 2.06 4.4 31,904.83 13,254.61 55.97 2.41 2.73
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
Newmont Mining Corporation NEM 9,868.0 53.4 1,809.0 2.15 13.57 22,509.89 13,976.99 12.44 1.61 2.28
Bristol-Myers Squibb Company BMY 17,621.0 73.8 1,960.0 2.64 13.25 55,383.28 14,111.68 28.26 3.92 3.14
Fifth Third Bancorp FITB 6,594.0 1,576.0 9.15 11.8 13,773.76 14,284.6 8.74 0.96 2.09
Eli Lilly and Company LLY 22,603.0 78.8 4,089.0 2.33 28.89 55,984.04 14,386.96 13.69 3.89 2.48
FedEx Corporation FDX 42,680.0 68.9 2,032.0 2.03 13.57 27,468.05 14,727.82 13.52 1.87 0.64
Regions Financial Corporation RF 5,400.0 1,120.0 8.08 7.97 9,306.77 14,743.81 8.31 0.63 1.72
American Electric Power Company, Inc. AEP 14,945.0 64.7 1,259.0 3.57 8.42 21,034.45 15,214.45 16.71 1.38 1.41
McDonald's Corporation MCD 27,567.0 39.2 5,465.0 2.31 36.82 91,198.2 15,555.0 16.69 5.86 3.31
Yahoo! Inc. YHOO 4,987.0 67.5 3,945.0 1.17 29.12 23,374.29 15,711.18 5.93 1.49 4.69
Halliburton Company HAL 28,503.0 15.6 2,635.0 1.74 18.2 31,236.48 15,748.16 11.85 1.98 1.1
Thermo Fisher Scientific Inc TMO 12,510.0 42.3 1,178.0 1.77 7.72 23,774.26 15,876.42 20.18 1.5 1.9
NextEra Energy, Inc. NEE 14,256.0 64.1 1,911.0 4.01 12.32 28,969.66 15,880.1 15.16 1.82 2.03
Lincoln National Corporation LNC 11,532.0 1,313.0 14.62 9.01 7,413.12 15,888.96 5.65 0.47 0.64