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
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
Ameren Corporation AEE 6,828.0 63.5 -974.0 3.3 -13.4 7,234.11 6,626.61 1.09 1.06
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Masco Corporation MAS 7,745.0 25.2 -114.0 21.35 -26.86 5,538.63 321.08 17.25 0.72
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
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
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
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
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
Eastman Chemical Company EMN 8,102.0 21.7 437.0 3.95 18.16
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
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
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