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
AutoZone, Inc. AZO 8,604.0 51.5 930.0 14,371.6 -1,672.4 15.45 1.67
Assurant, Inc. AIZ 8,508.0 484.0 5.58 9.47 2,966.5 5,603.2 6.13 0.53 0.35
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
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
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
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
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
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
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
Dover Corporation DOV 8,104.0 38.3 811.0 2.12 16.47 11,737.36 5,181.44 14.47 2.27 1.45
Eastman Chemical Company EMN 8,102.0 21.7 437.0 3.95 18.16
Peabody Energy Corporation BTU 8,078.0 26.6 -586.0 3.22 -11.27 7,316.4 4,893.68 1.5 0.91
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
Corning Incorporated GLW 8,012.0 42.4 1,728.0 1.37 8.12 19,020.78 22,017.72 11.01 0.86 2.37
Broadcom Corporation BRCM 8,006.0 49.7 719.0 1.43 10.01 19,578.24 7,937.28 27.23 2.47 2.45
Darden Restaurants, Inc. DRI 7,999.0 22.9 476.0 3.23 25.17 6,768.37 1,899.24 14.22 3.56 0.85
Masco Corporation MAS 7,745.0 25.2 -114.0 21.35 -26.86 5,538.63 321.08 17.25 0.72
Becton, Dickinson and Company BDX 7,708.0 51.3 1,170.0 2.75 26.1 16,230.94 4,332.57 13.87 3.75 2.11
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
Sealed Air Corporation SEE 7,648.0 33.3 -1,410.0 6.54 -64.09 3,198.01 1,432.06 2.23 0.42
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
CenterPoint Energy, Inc (Holding Co) CNP 7,452.0 61.4 417.0 5.32 9.79 8,565.6 4,321.5 20.54 1.98 1.15
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
Quest Diagnostics Incorporated DGX 7,383.0 40.9 556.0 2.23 14.15 9,286.4 4,206.4 16.7 2.21 1.26
Cognizant Technology Solutions Corporation CTSH 7,346.0 41.8 1,051.0 1.34 23.87 21,716.82 4,923.54 20.66 4.41 2.96
Boston Scientific Corporation BSX 7,249.0 67.6 -4,068.0 2.5 -44.65 8,033.97 7,133.49 1.13 1.11
XL Group plc XL 7,230.0 651.0 4.32 6.53 7,852.3 10,908.9 12.06 0.72 1.09
Precision Castparts Corporation PCP 7,215.0 31.4 1,224.0 1.26 15.77 25,472.62 8,409.6 20.81 3.03 3.53
BorgWarner Inc. BWA 7,183.0 20.4 501.0 2.08 18.31 8,173.55 3,227.07 16.31 2.53 1.14
Franklin Resources, Inc. BEN 7,101.0 61.4 1,931.0 1.6 21.79 25,968.9 9,261.92 13.45 2.8 3.66