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
Scana Corporation SCG 4,176.0 50.6 420.0 3.52 10.44 6,128.64 4,185.51 14.59 1.46 1.47
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
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
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
FMC Corporation FMC 3,748.0 35.8 416.0 2.95 30.59 7,469.86 1,494.25 17.96 5.0 1.99
NiSource, Inc NI 5,061.0 69.5 416.0 3.93 7.89 7,347.0 5,370.0 17.66 1.37 1.45
CarMax Inc KMX 10,004.0 13.8 414.0 3.12 16.67 6,909.21 2,718.87 16.69 2.54 0.69
McCormick & Company, Incorporated MKC 4,014.0 40.3 408.0 2.48 24.83 8,308.0 1,701.8 20.36 4.88 2.07
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
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
BMC Software, Inc. BMC 2,172.0 73.8 401.0 3.36 25.8 6,546.32 1,522.4 16.32 4.3 3.01
Whirlpool Corporation WHR 18,143.0 15.9 401.0 3.61 9.5 7,873.14 4,259.68 19.63 1.85 0.43
Newell Rubbermaid Inc. NWL 5,903.0 37.8 401.0 3.12 20.87 6,541.5 2,046.24 16.31 3.2 1.11
Wyndham Worldwide Corp WYN 4,534.0 53.8 400.0 4.9 19.22 7,316.7 2,038.7 18.29 3.59 1.61
Linear Technology Corporation LLTC 1,267.0 75.3 398.0 2.51 64.1 6,977.88 748.8 17.53 9.32 5.51
Cerner Corporation CERN 2,665.0 77.2 397.0 1.31 15.44 13,803.68 2,898.72 34.77 4.76 5.18
Jabil Circuit, Inc. JBL 17,152.0 7.6 395.0 3.71 19.87 4,783.37 2,156.42 12.11 2.22 0.28
MetroPCS Communications, Inc. PCS 5,101.0 42.6 394.0 3.03 12.54 3,737.6 3,372.6 9.49 1.11 0.73
CONSOL Energy Inc. CNX 5,430.0 33.6 388.0 3.2 10.27 7,618.83 3,968.57 19.64 1.92 1.4
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
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
Pinnacle West Capital Corporation PNW 3,302.0 69.9 382.0 3.37 9.79 5,719.83 4,018.2 14.97 1.42 1.73
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
Jacobs Engineering Group Inc. JEC 10,894.0 15.9 379.0 1.84 10.77 5,259.33 3,695.85 13.88 1.42 0.48
Ventas, Inc. VTR 2,485.0 60.6 363.0 2.1 3.97 19,107.06 9,084.6 52.64 2.1 7.69
ONEOK, Inc. OKE 12,633.0 18.6 361.0 7.45 16.51 9,062.45 2,192.29 25.1 4.13 0.72
Citrix Systems, Inc. CTXS 2,586.0 84.4 353.0 1.54 12.05 11,823.84 3,165.75 33.5 3.73 4.57
The NASDAQ OMX Group, Inc. NDAQ 3,119.0 53.3 352.0 1.75 6.91 4,062.04 5,440.85 11.54 0.75 1.3
Zions Bancorporation ZION 2,152.0 350.0 11.27 3.75 3,650.85 4,891.59 10.43 0.75 1.7
NYSE Euronext, Inc. NYX 3,749.0 62.0 348.0 1.98 5.38 5,875.0 6,555.0 16.88 0.9 1.57