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
Diamond Offshore Drilling, Inc. DO 2,987.0 46.9 720.0 1.58 16.17 9,546.52 4,575.88 13.26 2.09 3.2
Perrigo Company PRGO 3,173.0 34.5 402.0 2.17 23.76 9,982.8 1,862.14 24.83 5.36 3.15
Bristol-Myers Squibb Company BMY 17,621.0 73.8 1,960.0 2.64 13.25 55,383.28 14,111.68 28.26 3.92 3.14
ENSCO plc ESV 4,301.0 52.8 1,170.0 1.57 10.29 13,381.4 11,697.8 11.44 1.14 3.11
Equifax, Inc. EFX 2,161.0 61.6 272.0 2.33 14.97 6,666.6 1,975.38 24.51 3.37 3.08
Dollar Tree, Inc. DLTR 6,631.0 35.9 488.0 1.73 34.83 20,013.4 1,408.44 41.01 14.21 3.02
BMC Software, Inc. BMC 2,172.0 73.8 401.0 3.36 25.8 6,546.32 1,522.4 16.32 4.3 3.01
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
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
Cognizant Technology Solutions Corporation CTSH 7,346.0 41.8 1,051.0 1.34 23.87 21,716.82 4,923.54 20.66 4.41 2.96
Northern Trust Corporation NTRS 3,896.0 687.0 12.95 9.39 11,502.93 7,591.5 16.74 1.52 2.95
Starbucks Corporation SBUX 13,300.0 56.3 1,384.0 1.61 29.15 39,291.59 5,194.56 28.39 7.56 2.95
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
Reynolds American Inc RAI 8,304.0 48.0 1,272.0 3.15 22.11 24,310.4 5,401.68 19.11 4.5 2.93
Praxair, Inc. PX 11,224.0 43.0 1,692.0 2.98 29.29 32,567.68 6,181.94 19.25 5.27 2.9
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
M&T Bank Corporation MTB 4,266.0 1,029.0 8.9 11.61 12,346.74 9,171.54 12.0 1.35 2.89
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
Rowan Companies plc RDC 1,393.0 46.0 181.0 1.7 4.08 3,972.9 4,487.04 21.95 0.89 2.85
Anadarko Petroleum Corporation APC 13,411.0 71.1 2,391.0 2.55 12.35 38,051.6 20,692.44 15.91 1.84 2.84
C.R. Bard, Inc. BCR 2,958.0 62.0 530.0 2.16 28.59 8,216.04 1,979.88 15.5 4.15 2.78
CA Inc. CA 4,814.0 86.6 951.0 2.22 17.26 13,149.0 5,410.57 13.83 2.43 2.73
EOG Resources, Inc. EOG 11,683.0 83.7 570.0 2.06 4.4 31,904.83 13,254.61 55.97 2.41 2.73
Invesco Plc IVZ 4,177.0 100.0 677.0 2.1 8.24 11,281.9 8,757.66 16.66 1.29 2.7
Texas Instruments Incorporated TXN 12,825.0 49.7 1,759.0 1.83 16.05 34,173.72 11,333.94 19.43 3.02 2.66
Vulcan Materials Company VMC 2,567.0 13.0 -53.0 2.16 -1.39 6,771.7 3,768.7 1.8 2.64
Williams Companies, Inc. (The) WMB 7,486.0 39.6 859.0 5.12 26.25 19,512.5 4,362.5 22.72 4.47 2.61
Abbott Laboratories ABT 39,874.0 62.1 5,963.0 2.52 23.31 104,005.36 26,984.4 17.44 3.85 2.61
NetApp, Inc. NTAP 6,233.0 59.6 605.0 2.22 15.09 16,135.68 4,523.52 26.67 3.57 2.59
Zimmer Holdings, Inc. ZMH 4,472.0 74.8 755.0 1.54 13.28 11,528.0 6,010.4 15.27 1.92 2.58