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
Tenet Healthcare Corporation THC 9,119.0 36.3 152.0 7.91 12.63 3,227.49 1,190.28 21.23 2.71 0.35
Air Products and Chemicals, Inc. APD 9,612.0 26.6 1,167.0 2.62 19.02 17,894.45 6,579.0 15.33 2.72 1.86
Analog Devices, Inc. ADI 2,701.0 64.5 651.0 1.35 16.36 11,683.08 4,265.64 17.95 2.74 4.33
Schlumberger N.V. SLB 42,321.0 21.9 5,490.0 1.77 16.63 96,408.0 35,028.24 17.56 2.75 2.28
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
Procter & Gamble Company (The) PG 83,680.0 49.3 10,756.0 2.12 16.72 184,547.75 66,819.52 17.16 2.76 2.21
Fluor Corporation FLR 27,577.0 3.2 456.0 2.48 13.55 9,663.36 3,457.44 21.19 2.79 0.35
LyondellBasell Industries NV LYB 45,352.0 12.7 2,848.0 2.17 26.21 31,371.49 11,234.19 11.02 2.79 0.69
Franklin Resources, Inc. BEN 7,101.0 61.4 1,931.0 1.6 21.79 25,968.9 9,261.92 13.45 2.8 3.66
Dominion Resources, Inc. D 13,093.0 59.4 302.0 4.43 2.74 29,612.66 10,532.9 98.06 2.81 2.26
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
Wal-Mart Stores, Inc. WMT 446,950.0 25.0 15,699.0 2.71 22.45 205,104.96 72,467.64 13.06 2.83 0.46
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
United Technologies Corporation UTX 57,708.0 27.0 5,130.0 3.45 21.47 73,476.07 25,577.4 14.32 2.87 1.27
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
PulteGroup, Inc. PHM 4,820.0 15.7 206.0 3.08 9.99 6,314.0 2,179.1 30.65 2.9 1.31
Marsh & McLennan Companies, Inc. MMC 11,924.0 100.0 1,176.0 2.49 18.93 19,253.76 6,618.48 16.37 2.91 1.61
Laboratory Corporation of America Holdings LH 5,671.0 39.7 583.0 2.5 22.34 8,218.81 2,818.82 14.1 2.92 1.45
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
Cummins Inc. CMI 17,334.0 26.0 1,645.0 1.9 27.2 19,615.6 6,610.1 11.92 2.97 1.13
Akamai Technologies, Inc. AKAM 1,374.0 68.6 204.0 1.11 9.06 7,134.4 2,400.58 34.97 2.97 5.19
Big Lots, Inc. BIG 5,202.0 39.8 207.0 1.99 23.4 2,660.64 892.86 12.85 2.98 0.51
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
Roper Industries, Inc. ROP 2,993.0 55.8 483.0 1.92 14.05 11,223.0 3,740.0 23.24 3.0 3.75
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
Precision Castparts Corporation PCP 7,215.0 31.4 1,224.0 1.26 15.77 25,472.62 8,409.6 20.81 3.03 3.53
Oracle Corporation ORCL 37,121.0 78.8 9,981.0 1.79 23.92 137,666.9 45,396.45 13.79 3.03 3.71
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
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
Advanced Micro Devices, Inc. AMD 5,422.0 22.8 -1,183.0 7.43 -111.18 1,719.12 555.75 3.09 0.32