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
Teradyne, Inc. TER 1,657.0 53.5 217.0 1.37 13.22 3,755.9 2,175.8 17.31 1.73 2.27
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
Noble Energy Inc. NBL 4,223.0 74.4 1,027.0 2.13 13.23 18,072.0 8,303.4 17.6 2.18 4.28
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
Zimmer Holdings, Inc. ZMH 4,472.0 74.8 755.0 1.54 13.28 11,528.0 6,010.4 15.27 1.92 2.58
Avery Dennison Corporation AVY 6,036.0 26.1 215.0 3.23 13.3 3,523.52 1,645.28 16.39 2.14 0.58
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
Adobe Systems Incorporated ADBE 4,404.0 89.0 833.0 1.5 13.38 16,548.7 6,785.47 19.87 2.44 3.76
L-3 Communications Holdings, Inc. LLL 13,146.0 10.3 810.0 2.53 13.39 7,511.7 5,920.18 9.27 1.27 0.57
Wisconsin Energy Corporation WEC 4,246.0 61.3 546.0 3.43 13.39 8,753.81 4,238.27 16.03 2.07 2.06
Cintas Corporation CTAS 4,102.0 42.4 298.0 1.95 13.4 5,011.5 2,198.3 16.82 2.28 1.22
eBay Inc. EBAY 14,072.0 70.0 2,609.0 1.78 13.45 67,186.21 21,165.56 25.75 3.17 4.77
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
Newmont Mining Corporation NEM 9,868.0 53.4 1,809.0 2.15 13.57 22,509.89 13,976.99 12.44 1.61 2.28
FedEx Corporation FDX 42,680.0 68.9 2,032.0 2.03 13.57 27,468.05 14,727.82 13.52 1.87 0.64
Whole Foods Market, Inc. WFM 11,699.0 35.5 466.0 1.39 13.71 17,991.52 3,788.56 38.61 4.75 1.54
United Parcel Service, Inc. UPS 54,127.0 76.6 807.0 8.35 13.81 71,395.92 4,738.41 88.47 15.07 1.32
FLIR Systems, Inc. FLIR 1,405.0 52.0 222.0 1.36 13.99 3,133.9 1,689.38 14.12 1.86 2.23
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
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
Quest Diagnostics Incorporated DGX 7,383.0 40.9 556.0 2.23 14.15 9,286.4 4,206.4 16.7 2.21 1.26
PPL Corporation PPL 12,286.0 60.3 1,526.0 4.16 14.32 16,878.0 10,481.82 11.06 1.61 1.37
Iron Mountain Incorporated IRM 3,005.0 57.5 172.0 5.53 14.33 5,461.75 1,058.75 31.75 5.16 1.82
TE Connectivity Ltd. TEL 13,282.0 30.5 1,112.0 2.42 14.4 15,462.8 8,109.8 13.91 1.91 1.16
Humana Inc. HUM 39,126.0 1,222.0 2.26 14.45 10,921.0 9,108.44 8.94 1.2 0.28
Ingersoll-Rand plc (Ireland) IR 14,035.0 30.5 1,019.0 2.59 14.48 14,862.69 7,519.98 14.59 1.98 1.06
Patterson Companies, Inc. PDCO 3,536.0 32.9 213.0 1.99 14.5 3,571.98 1,388.61 16.77 2.57 1.01
Cameron International Corporation CAM 8,502.0 29.1 751.0 2.0 14.61 13,644.96 5,594.88 18.17 2.44 1.6
Discovery Communications, Inc. DISCA 4,487.0 72.9 943.0 2.06 14.73 22,997.6 9,743.2 24.39 2.36 5.13
Walt Disney Company (The) DIS 42,278.0 21.0 5,682.0 1.88 14.73 93,663.36 40,286.88 16.48 2.32 2.22