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
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
Tyson Foods, Inc. TSN 33,278.0 6.5 583.0 1.98 9.99 5,894.1 6,145.7 10.11 0.96 0.18
Automatic Data Processing, Inc. ADP 10,665.0 41.5 1,389.0 5.04 22.9 26,410.56 6,150.0 19.01 4.29 2.48
Ecolab Inc. ECL 11,839.0 45.2 704.0 2.89 11.98 21,539.96 6,165.38 30.6 3.49 1.82
Praxair, Inc. PX 11,224.0 43.0 1,692.0 2.98 29.29 32,567.68 6,181.94 19.25 5.27 2.9
Cardinal Health, Inc. CAH 107,552.0 4.2 1,069.0 3.89 17.68 14,623.1 6,295.96 13.68 2.32 0.14
International Paper Company IP 27,833.0 26.0 794.0 5.1 12.29 15,985.2 6,305.2 20.13 2.54 0.57
Waste Management, Inc. WM 13,649.0 34.9 817.0 3.64 13.15 15,929.12 6,352.16 19.5 2.51 1.17
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
Air Products and Chemicals, Inc. APD 9,612.0 26.6 1,167.0 2.62 19.02 17,894.45 6,579.0 15.33 2.72 1.86
General Mills, Inc. GIS 16,658.0 36.3 1,567.0 3.29 24.51 26,179.75 6,603.3 16.71 3.96 1.57
Cummins Inc. CMI 17,334.0 26.0 1,645.0 1.9 27.2 19,615.6 6,610.1 11.92 2.97 1.13
Marsh & McLennan Companies, Inc. MMC 11,924.0 100.0 1,176.0 2.49 18.93 19,253.76 6,618.48 16.37 2.91 1.61
Ameren Corporation AEE 6,828.0 63.5 -974.0 3.3 -13.4 7,234.11 6,626.61 1.09 1.06
Fidelity National Information Services, Inc. FIS 5,808.0 32.0 461.0 2.04 7.02 10,859.12 6,728.84 23.56 1.61 1.87
Host Marriott Financial Trust HST 5,286.0 38.3 61.0 1.9 0.9 10,900.8 6,782.4 1.61 2.06
Adobe Systems Incorporated ADBE 4,404.0 89.0 833.0 1.5 13.38 16,548.7 6,785.47 19.87 2.44 3.76
Leucadia National Corporation LUK 9,194.0 17.7 854.0 1.38 13.2 5,789.25 6,889.83 6.78 0.84 0.63
Stanley Black & Decker, Inc. SWK 10,191.0 36.4 884.0 2.38 12.93 11,997.28 6,960.56 13.57 1.72 1.18
McKesson Corporation MCK 122,734.0 5.4 1,403.0 4.84 19.97 21,686.4 6,967.76 15.46 3.11 0.18
Sprint Nextel Corporation S 35,345.0 41.0 -4,326.0 7.28 -46.73 16,991.32 7,054.7 2.41 0.48
Baxter International Inc. BAX 14,190.0 51.5 2,326.0 2.94 34.4 36,412.44 7,061.2 15.65 5.16 2.57
Biogen Idec Inc. BIIB 5,516.0 90.1 1,380.0 1.46 20.62 36,753.6 7,063.2 26.63 5.2 6.66
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
Comerica Incorporated CMA 2,546.0 521.0 9.42 7.46 5,617.92 7,079.04 10.78 0.79 2.21
Deere & Company DE 36,157.0 30.5 3,065.0 8.22 44.93 32,638.38 7,091.28 10.65 4.6 0.9
Equity Residential EQR 2,124.0 64.9 842.0 2.38 13.0 17,628.8 7,126.4 20.94 2.47 8.3
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
Kohl's Corporation KSS 18,804.0 38.2 1,167.0 2.17 15.98 12,474.13 7,140.85 10.69 1.75 0.66
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