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
Ventas, Inc. VTR 2,485.0 60.6 363.0 2.1 3.97 19,107.06 9,084.6 52.64 2.1 7.69
Humana Inc. HUM 39,126.0 1,222.0 2.26 14.45 10,921.0 9,108.44 8.94 1.2 0.28
Murphy Oil Corporation MUR 28,626.0 12.8 971.0 1.96 10.96 11,038.95 9,147.45 11.37 1.21 0.39
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
M&T Bank Corporation MTB 4,266.0 1,029.0 8.9 11.61 12,346.74 9,171.54 12.0 1.35 2.89
Dell Inc. DELL 62,071.0 22.3 3,492.0 4.99 41.86 29,314.46 9,190.88 8.39 3.19 0.47
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
Franklin Resources, Inc. BEN 7,101.0 61.4 1,931.0 1.6 21.79 25,968.9 9,261.92 13.45 2.8 3.66
Edison International EIX 11,862.0 65.1 -92.0 4.71 -1.88 14,737.8 9,553.5 1.54 1.24
Cigna Corporation CI 29,119.0 1,623.0 5.5 17.92 15,085.05 9,741.3 9.29 1.55 0.52
Discovery Communications, Inc. DISCA 4,487.0 72.9 943.0 2.06 14.73 22,997.6 9,743.2 24.39 2.36 5.13
AMERIPRISE FINANCIAL SERVICES, INC. AMP 10,259.0 1,029.0 14.82 10.64 13,667.67 9,941.34 13.28 1.37 1.33
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
HCP, Inc. HCP 1,901.0 85.1 833.0 1.89 8.42 19,418.36 9,963.84 23.31 1.95 10.21
Northrop Grumman Corporation NOC 25,218.0 22.1 1,978.0 2.79 19.93 17,214.12 10,061.81 8.7 1.71 0.68
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
E.I. du Pont de Nemours and Company DD 35,310.0 27.5 2,788.0 4.96 30.07 40,713.24 10,117.08 14.6 4.02 1.15
KeyCorp KEY 4,231.0 858.0 8.94 8.76 7,685.45 10,165.54 8.96 0.76 1.82
Emerson Electric Company EMR 24,412.0 40.0 1,968.0 2.31 19.02 36,580.95 10,400.25 18.59 3.52 1.5
PPL Corporation PPL 12,286.0 60.3 1,526.0 4.16 14.32 16,878.0 10,481.82 11.06 1.61 1.37
Sempra Energy SRE 9,647.0 61.7 865.0 3.55 8.53 17,591.34 10,495.03 20.34 1.68 1.82
Dominion Resources, Inc. D 13,093.0 59.4 302.0 4.43 2.74 29,612.66 10,532.9 98.06 2.81 2.26
CBS Corporation CBS 14,089.0 43.5 1,574.0 2.59 15.65 23,644.92 10,682.39 15.02 2.21 1.68
Public Service Enterprise Group Incorporated PEG 9,781.0 62.0 1,275.0 2.94 12.11 15,255.63 10,804.17 11.97 1.41 1.56
Covidien plc. COV 11,852.0 57.5 1,905.0 2.11 18.69 27,599.94 10,876.68 14.49 2.54 2.33
XL Group plc XL 7,230.0 651.0 4.32 6.53 7,852.3 10,908.9 12.06 0.72 1.09
Aetna Inc. AET 36,596.0 27.1 1,658.0 3.99 16.15 15,414.6 10,957.2 9.3 1.41 0.42
Illinois Tool Works Inc. ITW 17,924.0 36.1 2,870.0 1.83 27.89 29,311.81 10,978.33 10.21 2.67 1.64
LyondellBasell Industries NV LYB 45,352.0 12.7 2,848.0 2.17 26.21 31,371.49 11,234.19 11.02 2.79 0.69
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