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
Clorox Company (The) CLX 5,468.0 42.1 541.0 9,480.24 -137.28 17.52 1.73
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
Hartford Financial Services Group, Inc. (The) HIG 26,412.0 -38.0 13.64 -0.36 9,557.16 21,974.46 0.43 0.36
IntercontinentalExchange, Inc. ICE 1,363.0 96.6 552.0 10.21 16.31 9,563.0 3,669.71 17.32 2.61 7.02
Coca-Cola Enterprises, Inc. CCE 8,062.0 36.0 677.0 3.53 24.21 9,598.89 2,874.55 14.18 3.34 1.19
Beam Inc. BEAM 2,466.0 58.3 382.0 1.87 8.78 9,643.9 4,638.41 25.25 2.08 3.91
Fluor Corporation FLR 27,577.0 3.2 456.0 2.48 13.55 9,663.36 3,457.44 21.19 2.79 0.35
Gap, Inc. (The) GPS 14,549.0 36.2 833.0 2.69 24.37 9,668.62 3,027.44 11.61 3.19 0.66
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
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
AmerisourceBergen Corporation (Holding Co) ABC 79,490.0 3.4 719.0 6.29 27.01 9,773.71 2,508.32 13.59 3.9 0.12
Xilinx, Inc. XLNX 2,241.0 64.9 530.0 1.65 20.7 9,911.68 2,812.48 18.7 3.52 4.42
Genuine Parts Company GPC 13,014.0 29.0 648.0 2.27 22.42 9,929.4 3,020.16 15.32 3.29 0.76
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
C.H. Robinson Worldwide, Inc. CHRW 11,359.0 15.1 594.0 1.86 43.14 10,034.28 1,511.46 16.89 6.64 0.88
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
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
Cabot Oil & Gas Corporation COG 1,205.0 72.8 132.0 2.17 6.22 10,134.33 2,141.65 76.78 4.73 8.41
Juniper Networks, Inc. JNPR 4,365.0 62.1 187.0 1.4 2.65 10,141.28 7,243.02 54.23 1.4 2.32
Amphenol Corporation APH 4,292.0 31.3 555.0 2.15 24.14 10,151.6 2,492.8 18.29 4.07 2.37
Range Resources Corporation RRC 1,458.0 72.7 13.0 2.85 0.55 10,198.4 2,321.6 4.39 6.99
Seagate Technology. STX 14,939.0 31.4 2,862.0 2.89 96.04 10,314.99 3,894.03 3.6 2.65 0.69
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
Altera Corporation ALTR 1,783.0 69.6 557.0 1.4 17.6 10,400.4 3,379.32 18.67 3.08 5.83
Campbell Soup Company CPB 7,707.0 38.8 774.0 7.27 77.95 10,402.59 918.72 13.44 11.32 1.35
DaVita Inc. DVA 8,186.0 31.9 536.0 4.26 18.16 10,436.02 3,495.66 19.47 2.99 1.27
SanDisk Corporation SNDK 5,053.0 33.3 417.0 1.42 5.83 10,483.55 7,372.05 25.14 1.42 2.07
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
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
Republic Services, Inc. RSG 8,118.0 38.3 572.0 2.55 7.43 10,683.04 7,849.44 18.68 1.36 1.32