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
FMC Corporation FMC 3,748.0 35.8 416.0 2.95 30.59 7,469.86 1,494.25 17.96 5.0 1.99
D.R. Horton, Inc. DHI 4,354.0 19.8 956.0 2.02 30.79 7,093.84 4,027.98 7.42 1.76 1.63
Varian Medical Systems, Inc. VAR 2,807.0 42.6 427.0 1.91 31.02 6,772.09 1,559.4 15.86 4.34 2.41
H.J. Heinz Company HNZ 11,649.0 34.3 923.0 4.34 31.47 16,980.11 2,781.03 18.4 6.11 1.46
Estee Lauder Companies, Inc. (The) EL 9,714.0 79.5 857.0 2.41 31.96 21,838.97 2,790.91 25.48 7.83 2.25
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
Gilead Sciences, Inc. GILD 9,703.0 74.5 2,592.0 2.28 32.3 235,001.25 19,401.45 90.66 12.11 24.22
Joy Global Inc. JOY 5,661.0 33.2 762.0 2.38 33.65 6,012.33 2,603.31 7.89 2.31 1.06
Kimberly-Clark Corporation KMB 21,063.0 32.0 1,750.0 3.99 34.2 33,941.16 5,072.76 19.39 6.69 1.61
Waters Corporation WAT 1,844.0 60.0 461.0 2.16 34.26 7,654.0 1,512.11 16.6 5.06 4.15
Nordstrom, Inc. JWN 10,877.0 39.4 683.0 4.34 34.35 10,760.48 2,053.56 15.75 5.24 0.99
Baxter International Inc. BAX 14,190.0 51.5 2,326.0 2.94 34.4 36,412.44 7,061.2 15.65 5.16 2.57
Ball Corporation BLL 8,736.0 17.9 404.0 6.74 34.58 7,037.32 1,175.52 17.42 5.99 0.81
Federated Investors, Inc. FII 959.0 188.0 2.2 34.64 1,980.0 474.0 10.53 4.18 2.06
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
Paychex, Inc. PAYX 2,230.0 69.5 548.0 4.04 35.35 10,839.18 1,608.09 19.78 6.74 4.86
CF Industries Holdings, Inc. CF 6,104.0 51.0 1,849.0 1.72 35.38 13,889.85 6,094.4 7.51 2.28 2.28
Family Dollar Stores, Inc. FDO 9,331.0 34.9 422.0 2.6 35.41 7,517.78 1,327.5 17.81 5.66 0.81
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
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
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
TripAdvisor, Inc. TRIP 763.0 98.4 194.0 1.79 38.03 5,412.99 717.69 27.9 7.54 7.09
McGraw-Hill Companies, Inc. (The) MHP 4,450.0 67.2 437.0 9.19 38.42 16,119.6 783.75 36.89 20.57 3.62
Scripps Networks Interactive, Inc SNI 2,307.0 73.5 681.0 2.27 38.95 8,840.34 1,871.19 12.98 4.72 3.83
Apollo Group, Inc. APOL 4,253.0 57.7 423.0 3.09 38.98 3,490.42 1,008.94 8.25 3.46 0.82
Rockwell Automation, Inc. ROK 6,259.0 40.3 737.0 3.04 40.95 10,358.92 1,876.16 14.06 5.52 1.66
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
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
Monster Beverage Corporation MNST 2,061.0 51.7 340.0 1.62 41.89 9,669.72 711.87 28.44 13.58 4.69
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