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
Ameren Corporation AEE 6,828.0 63.5 -974.0 3.3 -13.4 7,234.11 6,626.61 1.09 1.06
CSX Corporation CSX 11,756.0 64.1 1,859.0 3.4 21.32 20,727.2 9,162.4 11.15 2.26 1.76
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
Analog Devices, Inc. ADI 2,701.0 64.5 651.0 1.35 16.36 11,683.08 4,265.64 17.95 2.74 4.33
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
Equity Residential EQR 2,124.0 64.9 842.0 2.38 13.0 17,628.8 7,126.4 20.94 2.47 8.3
Xilinx, Inc. XLNX 2,241.0 64.9 530.0 1.65 20.7 9,911.68 2,812.48 18.7 3.52 4.42
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
Edison International EIX 11,862.0 65.1 -92.0 4.71 -1.88 14,737.8 9,553.5 1.54 1.24
Merck & Company, Inc. MRK 47,267.0 65.2 6,168.0 2.0 11.47 136,820.48 53,891.52 22.18 2.54 2.89
Entergy Corporation ETR 10,302.0 65.7 868.0 4.7 9.28 11,374.2 9,207.94 13.1 1.24 1.1
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
Occidental Petroleum Corporation OXY 24,253.0 66.2 4,598.0 1.6 11.85 61,033.5 40,240.8 13.27 1.52 2.52
Marathon Oil Corporation MRO 16,221.0 66.3 1,582.0 1.93 8.93 21,555.6 18,360.6 13.63 1.17 1.33
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
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
Union Pacific Corporation UNP 20,926.0 66.8 3,943.0 2.37 20.51 59,734.71 20,196.18 15.15 2.96 2.85
McGraw-Hill Companies, Inc. (The) MHP 4,450.0 67.2 437.0 9.19 38.42 16,119.6 783.75 36.89 20.57 3.62
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
Boston Scientific Corporation BSX 7,249.0 67.6 -4,068.0 2.5 -44.65 8,033.97 7,133.49 1.13 1.11
Johnson & Johnson JNJ 67,224.0 67.8 10,853.0 1.87 17.81 198,597.8 65,627.29 18.3 3.03 2.95
Stryker Corporation SYK 8,657.0 67.9 1,298.0 1.54 15.95 20,984.57 8,663.46 16.17 2.42 2.42
Comcast Corporation CMCSA 62,570.0 68.1 6,203.0 3.34 12.84 101,208.25 50,807.9 16.32 1.99 1.62
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
Pioneer Natural Resources Company PXD 3,228.0 68.1 192.0 2.3 3.44 12,814.2 5,811.12 66.74 2.21 3.97
Akamai Technologies, Inc. AKAM 1,374.0 68.6 204.0 1.11 9.06 7,134.4 2,400.58 34.97 2.97 5.19
Health Care REIT, Inc. HCN 1,822.0 68.7 297.0 2.11 2.88 13,492.2 8,047.86 45.43 1.68 7.41
Dun & Bradstreet Corporation (The) DNB 1,663.0 68.7 296.0 3,740.72 -1,132.98 12.64 2.25
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
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