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
3M Company MMM 29,904.0 47.5 4,444.0 1.93 26.94 64,584.61 17,982.74 14.53 3.59 2.16
Cintas Corporation CTAS 4,102.0 42.4 298.0 1.95 13.4 5,011.5 2,198.3 16.82 2.28 1.22
Murphy Oil Corporation MUR 28,626.0 12.8 971.0 1.96 10.96 11,038.95 9,147.45 11.37 1.21 0.39
Washington Post Company (The) WPO 4,018.0 53.2 132.0 1.97 5.06 2,610.58 2,437.19 19.78 1.07 0.65
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
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
Big Lots, Inc. BIG 5,202.0 39.8 207.0 1.99 23.4 2,660.64 892.86 12.85 2.98 0.51
Patterson Companies, Inc. PDCO 3,536.0 32.9 213.0 1.99 14.5 3,571.98 1,388.61 16.77 2.57 1.01
Merck & Company, Inc. MRK 47,267.0 65.2 6,168.0 2.0 11.47 136,820.48 53,891.52 22.18 2.54 2.89
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
Hospira Inc HSP 4,092.0 27.2 44.0 2.0 1.48 5,316.98 3,054.4 1.74 1.3
PerkinElmer, Inc. PKI 2,115.0 45.5 70.0 2.01 3.7 3,585.7 1,938.9 51.22 1.85 1.7
Exxon Mobil Corporation XOM 482,295.0 29.9 44,880.0 2.01 28.03 409,161.48 170,495.52 9.12 2.4 0.85
Freeport-McMoran Copper & Gold, Inc. FCX 18,010.0 35.8 3,041.0 2.02 18.33 30,566.16 17,639.46 10.05 1.73 1.7
Apache Corporation APA 17,078.0 80.8 2,001.0 2.02 6.65 29,352.37 30,056.17 14.67 0.98 1.72
D.R. Horton, Inc. DHI 4,354.0 19.8 956.0 2.02 30.79 7,093.84 4,027.98 7.42 1.76 1.63
Molson Coors Brewing Company TAP 3,917.0 39.9 443.0 2.03 5.67 7,898.8 7,987.98 17.83 0.99 2.02
Lowe's Companies, Inc. LOW 50,208.0 34.6 1,839.0 2.03 10.62 33,645.39 16,803.6 18.3 2.0 0.67
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
LSI Logic Corporation LSI 2,506.0 49.2 196.0 2.03 17.69 4,096.05 1,225.91 20.9 3.34 1.63
FedEx Corporation FDX 42,680.0 68.9 2,032.0 2.03 13.57 27,468.05 14,727.82 13.52 1.87 0.64
Devon Energy Corporation DVN 9,502.0 65.1 -206.0 2.04 -0.96 21,189.6 21,226.05 1.0 2.23
Kimco Realty Corporation KIM 922.0 73.2 266.0 2.04 3.65 7,903.94 4,757.83 29.71 1.66 8.57
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
Hess Corporation HES 37,691.0 23.8 2,025.0 2.06 10.23 17,006.8 20,995.0 8.4 0.81 0.45
Celgene Corporation CELG 5,507.0 94.6 1,456.0 2.06 25.99 35,500.5 5,984.37 24.38 5.93 6.45
Discovery Communications, Inc. DISCA 4,487.0 72.9 943.0 2.06 14.73 22,997.6 9,743.2 24.39 2.36 5.13
EOG Resources, Inc. EOG 11,683.0 83.7 570.0 2.06 4.4 31,904.83 13,254.61 55.97 2.41 2.73
Harman International Industries, Incorporated HAR 4,364.0 27.1 330.0 2.07 22.32 2,886.48 1,562.4 8.75 1.85 0.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