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
Hershey Company (The) HSY 6,644.0 43.0 661.0 4.59 70.1 16,598.4 1,055.64 25.11 15.72 2.5
ONEOK, Inc. OKE 12,633.0 18.6 361.0 7.45 16.51 9,062.45 2,192.29 25.1 4.13 0.72
Ralph Lauren Corporation RL 6,860.0 58.3 681.0 1.48 19.58 16,933.44 3,796.8 24.87 4.46 2.47
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
Sherwin-Williams Company (The) SHW 9,534.0 44.1 631.0 3.69 41.42 15,577.12 1,702.48 24.69 9.15 1.63
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
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
Discovery Communications, Inc. DISCA 4,487.0 72.9 943.0 2.06 14.73 22,997.6 9,743.2 24.39 2.36 5.13
Celgene Corporation CELG 5,507.0 94.6 1,456.0 2.06 25.99 35,500.5 5,984.37 24.38 5.93 6.45
Expeditors International of Washington, Inc. EXPD 5,981.0 30.5 333.0 1.46 16.54 8,102.64 2,081.84 24.33 3.89 1.35
Teradata Corporation TDC 2,665.0 55.9 419.0 1.72 25.6 10,084.36 1,847.28 24.07 5.46 3.78
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
Fidelity National Information Services, Inc. FIS 5,808.0 32.0 461.0 2.04 7.02 10,859.12 6,728.84 23.56 1.61 1.87
FMC Technologies, Inc. FTI 6,151.0 21.4 430.0 3.21 26.37 10,112.36 1,867.75 23.52 5.41 1.64
Carnival Corporation CCL 15,382.0 32.9 1,298.0 1.64 5.44 30,505.64 24,024.36 23.5 1.27 1.98
HCP, Inc. HCP 1,901.0 85.1 833.0 1.89 8.42 19,418.36 9,963.84 23.31 1.95 10.21
Roper Industries, Inc. ROP 2,993.0 55.8 483.0 1.92 14.05 11,223.0 3,740.0 23.24 3.0 3.75
ConAgra Foods, Inc. CAG 13,263.0 21.3 468.0 2.58 10.24 10,725.88 4,552.02 22.92 2.36 0.81
Monsanto Company MON 13,504.0 52.2 2,045.0 1.71 17.5 46,839.6 11,955.6 22.9 3.92 3.47
Wynn Resorts, Limited WYNN 5,154.0 36.9 502.0 54.87 11,444.16 -267.28 22.8 2.22
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
FirstEnergy Corporation FE 15,303.0 56.2 770.0 3.85 5.84 17,409.45 13,110.51 22.61 1.33 1.14
priceline.com Incorporated PCLN 5,261.0 77.6 1,420.0 1.69 43.87 31,923.96 3,985.14 22.48 8.01 6.07
Mead Johnson Nutrition Company MJN 3,901.0 61.9 605.0 174.24 13,559.88 18.36 22.41 3.48
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
Intuit Inc. INTU 4,151.0 82.0 792.0 1.71 29.55 17,522.25 2,833.45 22.12 6.18 4.22
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
Mastercard Incorporated MA 7,391.0 100.0 2,759.0 1.8 43.16 60,429.6 7,071.12 21.9 8.55 8.18
Microchip Technology Incorporated MCHP 1,383.0 57.3 337.0 1.55 17.71 7,370.52 2,113.44 21.87 3.49 5.33
Tenet Healthcare Corporation THC 9,119.0 36.3 152.0 7.91 12.63 3,227.49 1,190.28 21.23 2.71 0.35