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
Walgreen Co. WAG 71,633.0 28.4 2,127.0 1.83 12.86 31,829.6 17,001.6 14.96 1.87 0.44
EOG Resources, Inc. EOG 11,683.0 83.7 570.0 2.06 4.4 31,904.83 13,254.61 55.97 2.41 2.73
priceline.com Incorporated PCLN 5,261.0 77.6 1,420.0 1.69 43.87 31,923.96 3,985.14 22.48 8.01 6.07
DIRECTV DTV 29,740.0 47.6 2,949.0 32,051.88 -5,957.0 10.87 1.08
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
Praxair, Inc. PX 11,224.0 43.0 1,692.0 2.98 29.29 32,567.68 6,181.94 19.25 5.27 2.9
Deere & Company DE 36,157.0 30.5 3,065.0 8.22 44.93 32,638.38 7,091.28 10.65 4.6 0.9
Morgan Stanley MS 26,112.0 68.0 12.89 -0.05 32,642.19 58,913.3 0.55 1.25
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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