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
Norfolk Souther Corporation NSC 11,040.0 63.4 1,749.0 3.11 17.78 20,176.0 10,101.0 11.54 2.0 1.83
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
The Travelers Companies, Inc. TRV 25,740.0 2,473.0 4.13 9.92 28,602.6 26,254.8 11.57 1.09 1.11
Gap, Inc. (The) GPS 14,549.0 36.2 833.0 2.69 24.37 9,668.62 3,027.44 11.61 3.19 0.66
National-Oilwell, Inc. NOV 20,041.0 26.6 2,491.0 1.56 13.16 28,989.03 20,244.07 11.64 1.43 1.45
Bank Of New York Mellon Corporation (The) BK 14,555.0 2,445.0 10.15 7.06 28,613.62 35,799.42 11.7 0.8 1.97
Macy's Inc M 26,405.0 40.4 1,256.0 3.72 21.91 14,784.88 6,071.68 11.77 2.44 0.56
Denbury Resources, Inc. (Holding Company) DNR 2,456.0 77.7 525.0 2.18 10.59 6,192.88 5,298.18 11.8 1.17 2.52
Halliburton Company HAL 28,503.0 15.6 2,635.0 1.74 18.2 31,236.48 15,748.16 11.85 1.98 1.1
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
Public Service Enterprise Group Incorporated PEG 9,781.0 62.0 1,275.0 2.94 12.11 15,255.63 10,804.17 11.97 1.41 1.56
Ryder System, Inc. R 6,257.0 20.0 210.0 5.67 15.08 2,516.34 1,457.07 11.98 1.73 0.4
M&T Bank Corporation MTB 4,266.0 1,029.0 8.9 11.61 12,346.74 9,171.54 12.0 1.35 2.89
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
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
Textron Inc. TXT 12,237.0 18.1 589.0 4.36 20.54 7,136.05 3,250.9 12.12 2.2 0.58
Lennar Corporation LEN 4,105.0 11.0 679.0 3.03 22.23 8,346.09 3,904.77 12.29 2.14 2.03
Rockwell Collins, Inc. COL 4,726.0 29.7 609.0 4.22 43.78 7,516.11 1,302.42 12.34 5.77 1.59
Coventry Health Care, Inc. CVH 14,113.0 21.2 487.0 1.85 10.55 6,049.92 4,808.7 12.42 1.26 0.43
Newmont Mining Corporation NEM 9,868.0 53.4 1,809.0 2.15 13.57 22,509.89 13,976.99 12.44 1.61 2.28
Dun & Bradstreet Corporation (The) DNB 1,663.0 68.7 296.0 3,740.72 -1,132.98 12.64 2.25
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
Scripps Networks Interactive, Inc SNI 2,307.0 73.5 681.0 2.27 38.95 8,840.34 1,871.19 12.98 4.72 3.83
Wal-Mart Stores, Inc. WMT 446,950.0 25.0 15,699.0 2.71 22.45 205,104.96 72,467.64 13.06 2.83 0.46
Pfizer, Inc. PFE 58,986.0 80.8 14,570.0 2.29 17.84 190,778.28 83,789.28 13.09 2.28 3.23
Entergy Corporation ETR 10,302.0 65.7 868.0 4.7 9.28 11,374.2 9,207.94 13.1 1.24 1.1
Diamond Offshore Drilling, Inc. DO 2,987.0 46.9 720.0 1.58 16.17 9,546.52 4,575.88 13.26 2.09 3.2
Occidental Petroleum Corporation OXY 24,253.0 66.2 4,598.0 1.6 11.85 61,033.5 40,240.8 13.27 1.52 2.52
AMERIPRISE FINANCIAL SERVICES, INC. AMP 10,259.0 1,029.0 14.82 10.64 13,667.67 9,941.34 13.28 1.37 1.33
Omnicom Group Inc. OMC 14,219.0 100.0 998.0 6.4 28.67 13,340.7 3,566.7 13.37 3.74 0.94