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
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
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
Covidien plc. COV 11,852.0 57.5 1,905.0 2.11 18.69 27,599.94 10,876.68 14.49 2.54 2.33
International Game Technology IGT 2,151.0 57.5 246.0 3.58 18.63 3,587.3 1,299.2 14.58 2.76 1.67
American Tower Corporation (REIT) AMT 2,876.0 74.9 637.0 3.94 18.58 29,972.88 3,606.96 47.05 8.31 10.42
UnitedHealth Group Incorporated UNH 110,618.0 9.5 5,526.0 2.59 18.58 56,682.74 32,007.6 10.26 1.77 0.51
Starwood Hotels & Resorts Worldwide, Inc. HOT 6,321.0 24.1 562.0 2.82 18.45 10,671.49 3,199.28 18.99 3.34 1.69
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
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
BorgWarner Inc. BWA 7,183.0 20.4 501.0 2.08 18.31 8,173.55 3,227.07 16.31 2.53 1.14
Fiserv, Inc. FISV 4,482.0 42.1 611.0 2.49 18.31 11,055.18 3,534.18 18.09 3.13 2.47
Hormel Foods Corporation HRL 8,231.0 16.2 500.0 1.62 18.26 7,809.07 2,883.68 15.62 2.71 0.95
Halliburton Company HAL 28,503.0 15.6 2,635.0 1.74 18.2 31,236.48 15,748.16 11.85 1.98 1.1
Leggett & Platt, Incorporated LEG 3,721.0 20.1 248.0 2.27 18.19 3,899.66 1,474.6 15.72 2.64 1.05
Eastman Chemical Company EMN 8,102.0 21.7 437.0 3.95 18.16
DaVita Inc. DVA 8,186.0 31.9 536.0 4.26 18.16 10,436.02 3,495.66 19.47 2.99 1.27
Gannett Co., Inc. GCI 5,353.0 45.0 424.0 2.71 18.14 4,230.45 2,422.14 9.98 1.75 0.79
Safeway Inc. SWY 44,207.0 26.5 597.0 5.01 18.05 4,423.08 3,008.58 7.41 1.47 0.1
Airgas, Inc. ARG 4,746.0 54.2 313.0 3.04 17.98 6,477.12 1,787.76 20.69 3.62 1.36
Cigna Corporation CI 29,119.0 1,623.0 5.5 17.92 15,085.05 9,741.3 9.29 1.55 0.52
Total System Services, Inc. TSS 1,871.0 32.5 244.0 1.42 17.92 4,150.44 1,440.18 17.01 2.88 2.22
Pfizer, Inc. PFE 58,986.0 80.8 14,570.0 2.29 17.84 190,778.28 83,789.28 13.09 2.28 3.23
Johnson & Johnson JNJ 67,224.0 67.8 10,853.0 1.87 17.81 198,597.8 65,627.29 18.3 3.03 2.95
Norfolk Souther Corporation NSC 11,040.0 63.4 1,749.0 3.11 17.78 20,176.0 10,101.0 11.54 2.0 1.83
Microchip Technology Incorporated MCHP 1,383.0 57.3 337.0 1.55 17.71 7,370.52 2,113.44 21.87 3.49 5.33
LSI Logic Corporation LSI 2,506.0 49.2 196.0 2.03 17.69 4,096.05 1,225.91 20.9 3.34 1.63
Cardinal Health, Inc. CAH 107,552.0 4.2 1,069.0 3.89 17.68 14,623.1 6,295.96 13.68 2.32 0.14
AutoNation, Inc. AN 15,669.0 15.9 316.0 4.27 17.66 4,979.52 1,760.22 15.76 2.83 0.32
Altera Corporation ALTR 1,783.0 69.6 557.0 1.4 17.6 10,400.4 3,379.32 18.67 3.08 5.83
St. Jude Medical, Inc. STJ 5,503.0 72.1 752.0 2.26 17.55 11,110.05 4,362.75 14.77 2.55 2.02