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
UnitedHealth Group Incorporated UNH 110,618.0 9.5 5,526.0 2.59 18.58 56,682.74 32,007.6 10.26 1.77 0.51
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
McDonald's Corporation MCD 27,567.0 39.2 5,465.0 2.31 36.82 91,198.2 15,555.0 16.69 5.86 3.31
United Technologies Corporation UTX 57,708.0 27.0 5,130.0 3.45 21.47 73,476.07 25,577.4 14.32 2.87 1.27
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
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
3M Company MMM 29,904.0 47.5 4,444.0 1.93 26.94 64,584.61 17,982.74 14.53 3.59 2.16
Amgen Inc. AMGN 17,265.0 83.1 4,345.0 2.85 22.82 70,625.38 19,832.4 16.25 3.56 4.09
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
Altria Group MO 17,500.0 54.6 4,180.0 11.15 122.08 67,642.08 3,197.92 16.18 21.15 3.87
Phillips 66 PSX 182,922.0 13.3 4,124.0 2.31 18.73 34,130.46 21,224.84 8.28 1.61 0.19
Eli Lilly and Company LLY 22,603.0 78.8 4,089.0 2.33 28.89 55,984.04 14,386.96 13.69 3.89 2.48
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
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
Boeing Company (The) BA 81,698.0 16.0 3,900.0 15.15 83.14 57,553.86 5,913.12 14.76 9.73 0.7
Home Depot, Inc. (The) HD 70,395.0 34.5 3,883.0 2.26 21.11 68,342.1 18,274.8 17.6 3.74 0.97
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
Medtronic, Inc. MDT 16,184.0 76.0 3,617.0 1.93 21.87 39,612.2 17,490.0 10.95 2.26 2.45
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
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
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
Marathon Petroleum Corporation MPC 82,492.0 9.5 3,389.0 2.33 31.97 21,207.42 12,011.04 6.26 1.77 0.26
Deere & Company DE 36,157.0 30.5 3,065.0 8.22 44.93 32,638.38 7,091.28 10.65 4.6 0.9
Freeport-McMoran Copper & Gold, Inc. FCX 18,010.0 35.8 3,041.0 2.02 18.33 30,566.16 17,639.46 10.05 1.73 1.7
Time Warner Inc. TWX 28,729.0 44.5 3,019.0 2.29 10.09 45,510.88 31,290.56 15.07 1.45 1.58
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
DIRECTV DTV 29,740.0 47.6 2,949.0 32,051.88 -5,957.0 10.87 1.08
Target Corporation TGT 69,865.0 30.9 2,929.0 2.95 18.71 33,372.36 16,169.76 11.39 2.06 0.48
Honeywell International Inc. HON 37,665.0 24.9 2,926.0 3.23 24.61 48,993.12 13,131.36 16.74 3.73 1.3