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
Eastman Chemical Company EMN 8,102.0 21.7 437.0 3.95 18.16
Best Buy Co., Inc. BBY 50,705.0 24.8 -1,231.0 4.27 -23.79 9,179.28 0.18
Bank of America Corporation BAC 83,334.0 4,188.0 10.13 1.28 114,589.37 219,421.84 27.36 0.52 1.38
J P Morgan Chase & Co JPM 97,031.0 21,284.0 12.1 10.72 161,708.82 195,953.94 7.6 0.83 1.67
Citigroup Inc. C 70,173.0 7,541.0 10.0 4.14 112,165.04 185,695.12 14.87 0.6 1.6
Exxon Mobil Corporation XOM 482,295.0 29.9 44,880.0 2.01 28.03 409,161.48 170,495.52 9.12 2.4 0.85
Wells Fargo & Company WFC 86,086.0 18,897.0 9.84 13.16 176,883.6 147,019.44 9.36 1.2 2.05
Chevron Corporation CVX 241,909.0 41.8 26,179.0 1.71 20.3 208,572.0 136,753.5 7.97 1.53 0.86
General Electric Company GE 147,359.0 49.6 13,641.0 5.57 11.39 225,963.96 124,866.48 16.57 1.81 1.53
Apple Inc. AAPL 156,508.0 43.9 41,733.0 1.49 42.84 626,289.3 119,164.5 15.01 5.26 4.0
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
AT&T Inc. T 127,434.0 56.7 7,264.0 2.95 7.34 196,342.33 96,337.55 27.03 2.04 1.54
Pfizer, Inc. PFE 58,986.0 80.8 14,570.0 2.29 17.84 190,778.28 83,789.28 13.09 2.28 3.23
Goldman Sachs Group, Inc. (The) GS 34,163.0 7,475.0 13.5 10.66 60,377.16 77,116.2 8.08 0.78 1.77
Wal-Mart Stores, Inc. WMT 446,950.0 25.0 15,699.0 2.71 22.45 205,104.96 72,467.64 13.06 2.83 0.46
Google Inc. GOOG 50,175.0 58.9 10,737.0 1.31 16.54 221,390.66 70,197.59 20.62 3.15 4.41
Microsoft Corporation MSFT 73,723.0 76.2 16,978.0 1.83 27.51 252,202.9 67,197.4 14.85 3.75 3.42
Procter & Gamble Company (The) PG 83,680.0 49.3 10,756.0 2.12 16.72 184,547.75 66,819.52 17.16 2.76 2.21
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
MetLife, Inc. MET 68,150.0 1,324.0 12.98 1.93 35,616.39 63,586.08 26.9 0.56 0.52
Morgan Stanley MS 26,112.0 68.0 12.89 -0.05 32,642.19 58,913.3 0.55 1.25
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
Intel Corporation INTC 53,341.0 62.1 11,005.0 1.65 22.66 103,612.8 53,457.6 9.42 1.94 1.94
Cisco Systems, Inc. CSCO 46,061.0 61.2 8,041.0 1.79 16.32 88,679.64 52,310.72 11.03 1.7 1.93
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
ConocoPhillips COP 62,004.0 45.9 8,428.0 2.44 14.89 72,523.64 49,280.49 8.61 1.47 1.17
Oracle Corporation ORCL 37,121.0 78.8 9,981.0 1.79 23.92 137,666.9 45,396.45 13.79 3.03 3.71
Walt Disney Company (The) DIS 42,278.0 21.0 5,682.0 1.88 14.73 93,663.36 40,286.88 16.48 2.32 2.22
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