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
Forest Laboratories, Inc. FRX 4,586.0 78.2 979.0 1.32 17.52 9,165.3 5,858.12 9.36 1.56 2.0
Monsanto Company MON 13,504.0 52.2 2,045.0 1.71 17.5 46,839.6 11,955.6 22.9 3.92 3.47
CA Inc. CA 4,814.0 86.6 951.0 2.22 17.26 13,149.0 5,410.57 13.83 2.43 2.73
Constellation Brands Inc STZ 2,654.0 40.0 445.0 2.66 17.02 4,483.05 2,877.93 10.07 1.56 1.69
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
CarMax Inc KMX 10,004.0 13.8 414.0 3.12 16.67 6,909.21 2,718.87 16.69 2.54 0.69
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
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
Expeditors International of Washington, Inc. EXPD 5,981.0 30.5 333.0 1.46 16.54 8,102.64 2,081.84 24.33 3.89 1.35
ONEOK, Inc. OKE 12,633.0 18.6 361.0 7.45 16.51 9,062.45 2,192.29 25.1 4.13 0.72
Dover Corporation DOV 8,104.0 38.3 811.0 2.12 16.47 11,737.36 5,181.44 14.47 2.27 1.45
U.S. Bancorp USB 20,064.0 5,647.0 10.34 16.41 60,482.4 34,715.76 10.71 1.74 3.01
Alexion Pharmaceuticals, Inc. ALXN 1,134.0 93.6 255.0 1.33 16.41 18,437.35 2,013.88 72.3 9.16 16.26
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
Helmerich & Payne, Inc. HP 3,152.0 44.5 581.0 1.49 16.36 5,070.6 3,918.24 8.73 1.29 1.61
Autodesk, Inc. ADSK 2,216.0 89.7 285.0 1.71 16.34 7,579.49 1,943.22 26.59 3.9 3.42
Mosaic Company (The) MOS 11,108.0 27.8 1,930.0 1.39 16.34 21,369.3 12,305.92 11.07 1.74 1.92
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
Cisco Systems, Inc. CSCO 46,061.0 61.2 8,041.0 1.79 16.32 88,679.64 52,310.72 11.03 1.7 1.93
IntercontinentalExchange, Inc. ICE 1,363.0 96.6 552.0 10.21 16.31 9,563.0 3,669.71 17.32 2.61 7.02
Diamond Offshore Drilling, Inc. DO 2,987.0 46.9 720.0 1.58 16.17 9,546.52 4,575.88 13.26 2.09 3.2
Aetna Inc. AET 36,596.0 27.1 1,658.0 3.99 16.15 15,414.6 10,957.2 9.3 1.41 0.42
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
Kohl's Corporation KSS 18,804.0 38.2 1,167.0 2.17 15.98 12,474.13 7,140.85 10.69 1.75 0.66
Stryker Corporation SYK 8,657.0 67.9 1,298.0 1.54 15.95 20,984.57 8,663.46 16.17 2.42 2.42
NVIDIA Corporation NVDA 3,998.0 51.4 581.0 1.34 15.86 8,919.68 4,170.32 15.35 2.14 2.23
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
CBS Corporation CBS 14,089.0 43.5 1,574.0 2.59 15.65 23,644.92 10,682.39 15.02 2.21 1.68
DENTSPLY International Inc. XRAY 2,928.0 53.1 314.0 2.25 15.49 5,702.4 2,234.88 18.16 2.55 1.95
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