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
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
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
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
H.J. Heinz Company HNZ 11,649.0 34.3 923.0 4.34 31.47 16,980.11 2,781.03 18.4 6.11 1.46
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
Legg Mason, Inc. LM 2,663.0 100.0 221.0 1.51 3.86 3,929.64 5,810.09 17.78 0.68 1.48
Accenture plc. ACN 29,778.0 30.2 2,554.0 4.02 63.64 44,743.38 4,450.38 17.52 10.05 1.5
Emerson Electric Company EMR 24,412.0 40.0 1,968.0 2.31 19.02 36,580.95 10,400.25 18.59 3.52 1.5
Capital One Financial Corporation COF 21,396.0 3,517.0 7.73 9.94 32,257.5 39,023.16 9.17 0.83 1.51
Bed Bath & Beyond Inc. BBBY 9,500.0 41.4 990.0 1.46 25.2 14,391.12 4,065.04 14.54 3.54 1.51
General Electric Company GE 147,359.0 49.6 13,641.0 5.57 11.39 225,963.96 124,866.48 16.57 1.81 1.53
W.W. Grainger, Inc. GWW 8,950.0 43.8 690.0 1.66 24.41 13,706.55 3,089.92 19.86 4.44 1.53
V.F. Corporation VFC 10,880.0 46.5 1,086.0 1.88 22.5 16,648.8 5,209.12 15.33 3.2 1.53
Whole Foods Market, Inc. WFM 11,699.0 35.5 466.0 1.39 13.71 17,991.52 3,788.56 38.61 4.75 1.54
AT&T Inc. T 127,434.0 56.7 7,264.0 2.95 7.34 196,342.33 96,337.55 27.03 2.04 1.54
Chubb Corporation (The) CB 13,595.0 1,545.0 3.3 9.84 20,921.2 16,384.66 13.54 1.28 1.54
Ace Limited ACE 17,936.0 2,706.0 3.36 10.4 27,721.26 27,748.7 10.24 1.0 1.55
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
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
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
Time Warner Inc. TWX 28,729.0 44.5 3,019.0 2.29 10.09 45,510.88 31,290.56 15.07 1.45 1.58
Flowserve Corporation FLS 4,751.0 33.3 448.0 2.55 21.55 7,573.7 2,081.31 16.91 3.64 1.59
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
Applied Materials, Inc. AMAT 8,719.0 38.0 109.0 1.67 1.36 13,919.3 7,713.08 1.8 1.6
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
Citigroup Inc. C 70,173.0 7,541.0 10.0 4.14 112,165.04 185,695.12 14.87 0.6 1.6
Snap-On Incorporated SNA 2,938.0 47.3 306.0 2.17 18.37 4,703.48 1,824.87 15.37 2.58 1.6
Kimberly-Clark Corporation KMB 21,063.0 32.0 1,750.0 3.99 34.2 33,941.16 5,072.76 19.39 6.69 1.61
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
Helmerich & Payne, Inc. HP 3,152.0 44.5 581.0 1.49 16.36 5,070.6 3,918.24 8.73 1.29 1.61