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
Discover Financial Services DFS 3,129.0 2,345.0 8.17 26.55 21,361.6 9.11 6.83
American Express Company AXP 31,582.0 4,482.0 8.11 23.79 64,751.75 19,499.69 14.45 3.32 2.05
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
Tenet Healthcare Corporation THC 9,119.0 36.3 152.0 7.91 12.63 3,227.49 1,190.28 21.23 2.71 0.35
BlackRock, Inc. BLK 9,337.0 60.9 2,458.0 7.89 9.74 34,838.16 26,774.76 14.17 1.3 3.73
PNC Financial Services Group, Inc. (The) PNC 15,512.0 3,013.0 7.82 7.75 29,560.52 39,077.23 9.81 0.76 1.91
Capital One Financial Corporation COF 21,396.0 3,517.0 7.73 9.94 32,257.5 39,023.16 9.17 0.83 1.51
Apartment Investment and Management Company AIV 1,033.0 59.9 132.0 7.55 14.96 3,415.66 779.88 25.88 4.38 3.31
ONEOK, Inc. OKE 12,633.0 18.6 361.0 7.45 16.51 9,062.45 2,192.29 25.1 4.13 0.72
Advanced Micro Devices, Inc. AMD 5,422.0 22.8 -1,183.0 7.43 -111.18 1,719.12 555.75 3.09 0.32
Sprint Nextel Corporation S 35,345.0 41.0 -4,326.0 7.28 -46.73 16,991.32 7,054.7 2.41 0.48
Campbell Soup Company CPB 7,707.0 38.8 774.0 7.27 77.95 10,402.59 918.72 13.44 11.32 1.35
Unum Group UNM 10,515.0 894.0 7.23 10.41 5,913.54 8,987.34 6.61 0.66 0.56
Genworth Financial Inc GNW 10,023.0 323.0 6.85 1.95 3,319.68 16,603.34 10.28 0.2 0.33
Time Warner Cable Inc TWC 21,386.0 53.5 2,155.0 6.84 29.1 29,303.04 7,628.4 13.6 3.84 1.37
Verizon Communications Inc. VZ 115,846.0 60.1 875.0 6.79 2.53 126,013.86 33,199.2 3.8 1.09
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
Sealed Air Corporation SEE 7,648.0 33.3 -1,410.0 6.54 -64.09 3,198.01 1,432.06 2.23 0.42
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
International Business Machines Corporation IBM 104,507.0 48.1 16,604.0 6.32 85.15 222,476.1 19,496.4 13.4 11.41 2.13
AmerisourceBergen Corporation (Holding Co) ABC 79,490.0 3.4 719.0 6.29 27.01 9,773.71 2,508.32 13.59 3.9 0.12
Kellogg Company K 14,197.0 38.3 961.0 6.28 45.99 20,206.8 2,412.0 21.03 8.38 1.42
Allstate Corporation (The) ALL 33,315.0 2,306.0 6.17 11.75 20,410.2 21,179.28 8.85 0.96 0.61
Interpublic Group of Companies, Inc. (The) IPG 6,956.0 100.0 447.0 6.14 19.6 5,151.51 2,534.87 11.52 2.03 0.74
Colgate-Palmolive Company CL 17,085.0 58.1 2,472.0 6.12 108.33 51,259.2 2,246.4 20.74 22.82 3.0
Avon Products, Inc. AVP 10,717.0 61.1 -43.0 6.07 -3.05 6,229.44 1,218.24 5.11 0.58
People's United Financial, Inc. PBCT 1,243.0 245.0 6.02 4.78 4,110.08 5,015.92 16.78 0.82 3.31
Kroger Company (The) KR 90,374.0 20.9 602.0 5.9 12.98 14,421.76 4,210.3 23.96 3.43 0.16
Ryder System, Inc. R 6,257.0 20.0 210.0 5.67 15.08 2,516.34 1,457.07 11.98 1.73 0.4
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