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
News Corporation NWSA 33,706.0 38.3 1,179.0 2.3 4.35 48,677.76 976.56 41.29 49.85 1.44
Simon Property Group, Inc. SPG 4,880.0 90.4 1,434.0 5.56 27.34 47,280.12 5,666.1 32.97 8.34 9.69
Lorillard, Inc LO 6,623.0 36.0 1,099.0 46,917.0 -1,813.5 42.69 7.08
Monsanto Company MON 13,504.0 52.2 2,045.0 1.71 17.5 46,839.6 11,955.6 22.9 3.92 3.47
Ford Motor Company F 134,252.0 16.1 5,665.0 11.95 36.58 46,052.05 16,220.6 8.13 2.84 0.34
Kinder Morgan, Inc. KMI 9,973.0 69.3 315.0 4.92 3.67 45,562.1 18,130.06 2.51 4.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
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
Costco Wholesale Corporation COST 99,137.0 12.4 1,709.0 2.2 14.03 41,836.7 12,551.01 24.48 3.33 0.42
Express Scripts Holding Company ESRX 93,858.0 7.8 1,313.0 2.49 10.15 40,741.38 21,349.26 31.03 1.91 0.43
E.I. du Pont de Nemours and Company DD 35,310.0 27.5 2,788.0 4.96 30.07 40,713.24 10,117.08 14.6 4.02 1.15
Medtronic, Inc. MDT 16,184.0 76.0 3,617.0 1.93 21.87 39,612.2 17,490.0 10.95 2.26 2.45
Starbucks Corporation SBUX 13,300.0 56.3 1,384.0 1.61 29.15 39,291.59 5,194.56 28.39 7.56 2.95
Southern Company (The) SO 16,537.0 66.1 2,415.0 3.32 12.6 38,394.72 19,241.31 15.9 2.0 2.32
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
Anadarko Petroleum Corporation APC 13,411.0 71.1 2,391.0 2.55 12.35 38,051.6 20,692.44 15.91 1.84 2.84
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
Biogen Idec Inc. BIIB 5,516.0 90.1 1,380.0 1.46 20.62 36,753.6 7,063.2 26.63 5.2 6.66
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
Baxter International Inc. BAX 14,190.0 51.5 2,326.0 2.94 34.4 36,412.44 7,061.2 15.65 5.16 2.57
Dow Chemical Company (The) DOW 56,786.0 15.8 1,182.0 4.12 4.79 35,997.36 16,499.28 30.45 2.18 0.63
MetLife, Inc. MET 68,150.0 1,324.0 12.98 1.93 35,616.39 63,586.08 26.9 0.56 0.52
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
BlackRock, Inc. BLK 9,337.0 60.9 2,458.0 7.89 9.74 34,838.16 26,774.76 14.17 1.3 3.73
Texas Instruments Incorporated TXN 12,825.0 49.7 1,759.0 1.83 16.05 34,173.72 11,333.94 19.43 3.02 2.66
Phillips 66 PSX 182,922.0 13.3 4,124.0 2.31 18.73 34,130.46 21,224.84 8.28 1.61 0.19
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
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
Target Corporation TGT 69,865.0 30.9 2,929.0 2.95 18.71 33,372.36 16,169.76 11.39 2.06 0.48
Morgan Stanley MS 26,112.0 68.0 12.89 -0.05 32,642.19 58,913.3 0.55 1.25