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
Altria Group MO 17,500.0 54.6 4,180.0 11.15 122.08 67,642.08 3,197.92 16.18 21.15 3.87
Bristol-Myers Squibb Company BMY 17,621.0 73.8 1,960.0 2.64 13.25 55,383.28 14,111.68 28.26 3.92 3.14
Illinois Tool Works Inc. ITW 17,924.0 36.1 2,870.0 1.83 27.89 29,311.81 10,978.33 10.21 2.67 1.64
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
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
The AES Corporation AES 18,141.0 20.5 -912.0 9.16 -17.35 8,093.6 4,635.7 1.75 0.45
Whirlpool Corporation WHR 18,143.0 15.9 401.0 3.61 9.5 7,873.14 4,259.68 19.63 1.85 0.43
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
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
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
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
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
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
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
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
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
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
Goodyear Tire & Rubber Company (The) GT 20,992.0 18.2 212.0 307.56 3,233.23 -130.91 15.25 0.15
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
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
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
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
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
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
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
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
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
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
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
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