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
Beam Inc. BEAM 2,466.0 58.3 382.0 1.87 8.78 9,643.9 4,638.41 25.25 2.08 3.91
Coach, Inc. COH 4,763.0 72.8 1,039.0 1.56 57.63 18,816.0 2,040.36 18.11 9.22 3.95
Pioneer Natural Resources Company PXD 3,228.0 68.1 192.0 2.3 3.44 12,814.2 5,811.12 66.74 2.21 3.97
Fastenal Company FAST 3,134.0 51.5 421.0 1.16 27.86 12,488.85 1,562.22 29.66 7.99 3.98
Apple Inc. AAPL 156,508.0 43.9 41,733.0 1.49 42.84 626,289.3 119,164.5 15.01 5.26 4.0
Moody's Corporation MCO 2,730.0 70.9 690.0 10.28 638.3 11,150.24 392.71 16.16 28.39 4.08
Amgen Inc. AMGN 17,265.0 83.1 4,345.0 2.85 22.82 70,625.38 19,832.4 16.25 3.56 4.09
Waters Corporation WAT 1,844.0 60.0 461.0 2.16 34.26 7,654.0 1,512.11 16.6 5.06 4.15
Nike, Inc. NKE 24,128.0 43.4 2,223.0 1.49 21.98 101,106.4 11,815.8 45.48 8.56 4.19
Intuit Inc. INTU 4,151.0 82.0 792.0 1.71 29.55 17,522.25 2,833.45 22.12 6.18 4.22
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
Stericycle, Inc. SRCL 1,913.0 44.8 268.0 2.3 19.56 8,256.3 1,559.91 30.81 5.29 4.32
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
Southwestern Energy Company SWN 2,715.0 69.2 -707.0 2.22 -20.19 11,747.34 3,018.85 3.89 4.33
Google Inc. GOOG 50,175.0 58.9 10,737.0 1.31 16.54 221,390.66 70,197.59 20.62 3.15 4.41
Xilinx, Inc. XLNX 2,241.0 64.9 530.0 1.65 20.7 9,911.68 2,812.48 18.7 3.52 4.42
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
Citrix Systems, Inc. CTXS 2,586.0 84.4 353.0 1.54 12.05 11,823.84 3,165.75 33.5 3.73 4.57
Hudson City Bancorp, Inc. HCBK 865.0 249.0 8.64 5.38 4,005.82 4,423.3 16.09 0.91 4.63
Monster Beverage Corporation MNST 2,061.0 51.7 340.0 1.62 41.89 9,669.72 711.87 28.44 13.58 4.69
Yahoo! Inc. YHOO 4,987.0 67.5 3,945.0 1.17 29.12 23,374.29 15,711.18 5.93 1.49 4.69
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
Paychex, Inc. PAYX 2,230.0 69.5 548.0 4.04 35.35 10,839.18 1,608.09 19.78 6.74 4.86
Allergan, Inc. AGN 5,806.0 86.6 1,099.0 1.57 19.72 28,250.14 5,968.08 25.71 4.73 4.87
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
Plum Creek Timber Company, Inc. PCL 1,339.0 29.6 203.0 3.58 16.33 6,925.5 1,223.1 34.12 5.66 5.17
Cerner Corporation CERN 2,665.0 77.2 397.0 1.31 15.44 13,803.68 2,898.72 34.77 4.76 5.18
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
EQT Corporation EQT 1,642.0 71.0 183.0 2.46 5.1 8,659.5 3,601.5 47.32 2.4 5.27
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