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
Hormel Foods Corporation HRL 8,231.0 16.2 500.0 1.62 18.26 7,809.07 2,883.68 15.62 2.71 0.95
Micron Technology, Inc. MU 8,234.0 11.8 -1,032.0 1.86 -12.76 6,699.16 7,501.87 0.89 0.81
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
NRG Energy, Inc. NRG 8,422.0 27.7 559.0 3.51 6.29 5,190.12 7,263.36 9.28 0.71 0.62
Cameron International Corporation CAM 8,502.0 29.1 751.0 2.0 14.61 13,644.96 5,594.88 18.17 2.44 1.6
Assurant, Inc. AIZ 8,508.0 484.0 5.58 9.47 2,966.5 5,603.2 6.13 0.53 0.35
AutoZone, Inc. AZO 8,604.0 51.5 930.0 14,371.6 -1,672.4 15.45 1.67
Ross Stores, Inc. ROST 8,608.0 27.5 657.0 2.21 46.51 11,571.3 1,513.4 17.61 7.65 1.34
Stryker Corporation SYK 8,657.0 67.9 1,298.0 1.54 15.95 20,984.57 8,663.46 16.17 2.42 2.42
Motorola Solutions, Inc. MSI 8,698.0 50.0 881.0 3.88 20.78 16,231.05 3,513.51 18.42 4.62 1.87
Applied Materials, Inc. AMAT 8,719.0 38.0 109.0 1.67 1.36 13,919.3 7,713.08 1.8 1.6
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
DTE Energy Company DTE 8,791.0 62.5 610.0 3.57 8.48 10,517.8 7,358.16 17.24 1.43 1.2
W.W. Grainger, Inc. GWW 8,950.0 43.8 690.0 1.66 24.41 13,706.55 3,089.92 19.86 4.44 1.53
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
Leucadia National Corporation LUK 9,194.0 17.7 854.0 1.38 13.2 5,789.25 6,889.83 6.78 0.84 0.63
Principal Financial Group Inc PFG 9,215.0 806.0 16.6 7.97 8,319.0 9,960.0 10.32 0.84 0.9
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
BlackRock, Inc. BLK 9,337.0 60.9 2,458.0 7.89 9.74 34,838.16 26,774.76 14.17 1.3 3.73
Bed Bath & Beyond Inc. BBBY 9,500.0 41.4 990.0 1.46 25.2 14,391.12 4,065.04 14.54 3.54 1.51
Devon Energy Corporation DVN 9,502.0 65.1 -206.0 2.04 -0.96 21,189.6 21,226.05 1.0 2.23
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
Gamestop Corporation GME 9,551.0 28.1 340.0 1.59 11.45 3,416.43 3,135.84 10.05 1.09 0.36
Air Products and Chemicals, Inc. APD 9,612.0 26.6 1,167.0 2.62 19.02 17,894.45 6,579.0 15.33 2.72 1.86
Sempra Energy SRE 9,647.0 61.7 865.0 3.55 8.53 17,591.34 10,495.03 20.34 1.68 1.82
State Street Corporation STT 9,649.0 2,061.0 10.92 10.28 21,616.14 21,370.83 10.49 1.01 2.24
BB&T Corporation BBT 9,677.0 1,979.0 9.66 10.51 20,107.24 19,291.89 10.16 1.04 2.08
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
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
Public Service Enterprise Group Incorporated PEG 9,781.0 62.0 1,275.0 2.94 12.11 15,255.63 10,804.17 11.97 1.41 1.56