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
U.S. Bancorp USB 20,064.0 5,647.0 10.34 16.41 60,482.4 34,715.76 10.71 1.74 3.01
Schlumberger N.V. SLB 42,321.0 21.9 5,490.0 1.77 16.63 96,408.0 35,028.24 17.56 2.75 2.28
Bank Of New York Mellon Corporation (The) BK 14,555.0 2,445.0 10.15 7.06 28,613.62 35,799.42 11.7 0.8 1.97
Prudential Financial, Inc. PRU 84,815.0 469.0 18.39 1.24 24,570.0 38,820.6 52.39 0.63 0.29
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
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
CVS Corporation CVS 123,133.0 18.3 3,877.0 1.75 10.24 60,467.2 39,206.4 15.6 1.54 0.49
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
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
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
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
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
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
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
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
Morgan Stanley MS 26,112.0 68.0 12.89 -0.05 32,642.19 58,913.3 0.55 1.25
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
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
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
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
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
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
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
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
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
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
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
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
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
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