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
Caterpillar, Inc. CAT 65,875.0 28.6 5,681.0 5.1 37.36 58,444.1 17,929.2 10.29 3.26 0.89
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
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
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
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
Walgreen Co. WAG 71,633.0 28.4 2,127.0 1.83 12.86 31,829.6 17,001.6 14.96 1.87 0.44
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
Philip Morris International Inc PM 77,393.0 27.1 8,800.0 150,706.44 -3,553.2 17.13 1.95
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
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
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
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
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
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
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
Archer-Daniels-Midland Company ADM 89,038.0 4.1 1,223.0 2.31 6.65 21,212.1 18,175.14 17.34 1.17 0.24
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
Express Scripts Holding Company ESRX 93,858.0 7.8 1,313.0 2.49 10.15 40,741.38 21,349.26 31.03 1.91 0.43
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
Costco Wholesale Corporation COST 99,137.0 12.4 1,709.0 2.2 14.03 41,836.7 12,551.01 24.48 3.33 0.42
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
Cardinal Health, Inc. CAH 107,552.0 4.2 1,069.0 3.89 17.68 14,623.1 6,295.96 13.68 2.32 0.14
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
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
Hewlett-Packard Company HPQ 120,357.0 23.2 -12,650.0 4.85 -41.43 27,991.32 22,562.82 1.24 0.23
McKesson Corporation MCK 122,734.0 5.4 1,403.0 4.84 19.97 21,686.4 6,967.76 15.46 3.11 0.18
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
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
Ford Motor Company F 134,252.0 16.1 5,665.0 11.95 36.58 46,052.05 16,220.6 8.13 2.84 0.34