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
Weyerhaeuser Company WY 7,059.0 17.7 385.0 3.09 9.24 14,877.9 4,065.0 38.64 3.66 2.11
Owens-Illinois, Inc. OI 7,000.0 19.6 184.0 9.76 21.4 3,323.32 891.42 18.06 3.73 0.47
Interpublic Group of Companies, Inc. (The) IPG 6,956.0 100.0 447.0 6.14 19.6 5,151.51 2,534.87 11.52 2.03 0.74
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
Agilent Technologies, Inc. A 6,858.0 52.6 1,153.0 2.03 24.3 13,205.73 5,287.94 11.45 2.5 1.93
Ameren Corporation AEE 6,828.0 63.5 -974.0 3.3 -13.4 7,234.11 6,626.61 1.09 1.06
Mylan Inc. MYL 6,796.0 42.8 641.0 3.57 18.76 11,768.4 3,549.0 18.36 3.32 1.73
Nabors Industries Ltd. NBR 6,751.0 33.6 164.0 2.13 2.84 4,277.8 5,977.24 26.08 0.72 0.63
Symantec Corporation SYMC 6,730.0 83.9 1,172.0 2.56 24.36 13,262.04 5,265.92 11.32 2.52 1.97
Cablevision Systems Corporation CVC 6,705.0 50.4 234.0 3,823.44 -5,687.1 16.34 0.57
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
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
Lorillard, Inc LO 6,623.0 36.0 1,099.0 46,917.0 -1,813.5 42.69 7.08
Fifth Third Bancorp FITB 6,594.0 1,576.0 9.15 11.8 13,773.76 14,284.6 8.74 0.96 2.09
CBRE Group, Inc. CBG 6,514.0 42.5 316.0 5.07 23.46 6,324.18 1,523.82 20.01 4.15 0.97
Mattel, Inc. MAT 6,421.0 53.1 776.0 2.13 27.35 12,826.22 3,100.16 16.53 4.14 2.0
Starwood Hotels & Resorts Worldwide, Inc. HOT 6,321.0 24.1 562.0 2.82 18.45 10,671.49 3,199.28 18.99 3.34 1.69
Northeast Utilities NU 6,274.0 61.8 526.0 3.06 7.94 10,880.92 8,175.98 20.69 1.33 1.73
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
Ryder System, Inc. R 6,257.0 20.0 210.0 5.67 15.08 2,516.34 1,457.07 11.98 1.73 0.4
CMS Energy Corporation CMS 6,253.0 48.8 382.0 5.36 12.28 6,644.3 3,252.21 17.39 2.04 1.06
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
O'Reilly Automotive, Inc. ORLY 6,182.0 50.1 586.0 2.73 23.65 11,099.52 2,295.18 18.94 4.84 1.8
Windstream Corporation WIN 6,156.0 52.9 168.0 12.66 12.91 4,902.3 1,099.8 29.18 4.46 0.8
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
PetSmart, Inc PETM 6,113.0 29.5 290.0 2.2 24.97 5,970.18 1,194.72 20.59 5.0 0.98
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
Avery Dennison Corporation AVY 6,036.0 26.1 215.0 3.23 13.3 3,523.52 1,645.28 16.39 2.14 0.58
Dr Pepper Snapple Group, Inc DPS 5,995.0 58.3 629.0 3.92 27.69 9,732.92 2,355.32 15.47 4.13 1.62
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