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
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
Morgan Stanley MS 26,112.0 68.0 12.89 -0.05 32,642.19 58,913.3 0.55 1.25
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
Aflac Incorporated AFL 25,364.0 2,866.0 8.2 19.44 25,124.33 16,021.04 8.77 1.57 0.99
Northrop Grumman Corporation NOC 25,218.0 22.1 1,978.0 2.79 19.93 17,214.12 10,061.81 8.7 1.71 0.68
Raytheon Company RTN 24,414.0 21.8 1,888.0 3.32 23.3 19,341.94 8,172.98 10.24 2.37 0.79
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
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
Nike, Inc. NKE 24,128.0 43.4 2,223.0 1.49 21.98 101,106.4 11,815.8 45.48 8.56 4.19
Alcoa Inc. AA 23,700.0 13.6 191.0 3.06 1.42 9,221.32 13,256.32 48.28 0.7 0.39
Exelon Corporation EXC 23,489.0 56.8 1,160.0 3.67 6.48 24,348.87 20,532.33 20.99 1.19 1.04
TJX Companies, Inc. (The) TJX 23,191.0 27.3 1,496.0 2.58 47.43 50,743.44 3,328.2 33.92 15.25 2.19
Eli Lilly and Company LLY 22,603.0 78.8 4,089.0 2.33 28.89 55,984.04 14,386.96 13.69 3.89 2.48
Xerox Corporation XRX 22,390.0 32.3 1,195.0 2.69 10.37 9,342.87 12,133.77 7.82 0.77 0.42
EMC Corporation EMC 21,714.0 62.8 2,733.0 1.7 13.23 55,194.12 23,405.66 20.2 2.36 2.54
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
Time Warner Cable Inc TWC 21,386.0 53.5 2,155.0 6.84 29.1 29,303.04 7,628.4 13.6 3.84 1.37
Baker Hughes Incorporated BHI 21,361.0 18.7 1,311.0 1.56 7.99 18,698.4 17,071.11 14.26 1.1 0.88
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
Goodyear Tire & Rubber Company (The) GT 20,992.0 18.2 212.0 307.56 3,233.23 -130.91 15.25 0.15
Union Pacific Corporation UNP 20,926.0 66.8 3,943.0 2.37 20.51 59,734.71 20,196.18 15.15 2.96 2.85
U.S. Bancorp USB 20,064.0 5,647.0 10.34 16.41 60,482.4 34,715.76 10.71 1.74 3.01
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
Duke Energy Corporation DUK 19,624.0 61.4 1,768.0 2.79 5.56 36,984.0 33,298.25 20.92 1.11 1.88
Nucor Corporation NUE 19,429.0 7.8 505.0 1.85 6.68 12,968.04 7,651.08 25.68 1.69 0.67
United States Steel Corporation X 19,328.0 8.8 -124.0 4.38 -3.55 3,146.4 3,470.4 0.91 0.16
QUALCOMM Incorporated QCOM 19,121.0 62.9 6,109.0 1.28 20.2 106,705.89 34,262.88 17.47 3.11 5.58
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
CenturyLink, Inc. CTL 18,376.0 58.4 777.0 2.8 3.87 23,654.66 19,176.26 30.44 1.23 1.29
Danaher Corporation DHR 18,260.0 51.6 2,392.0 1.73 13.32 38,081.33 19,721.58 15.92 1.93 2.09