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
T. Rowe Price Group, Inc. TROW 3,023.0 92.7 884.0 1.09 24.32 16,719.66 3,904.56 18.91 4.28 5.53
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
Intuitive Surgical, Inc. ISRG 2,179.0 72.1 657.0 1.13 21.09 21,600.85 3,651.46 32.88 5.92 9.91
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
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
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
QUALCOMM Incorporated QCOM 19,121.0 62.9 6,109.0 1.28 20.2 106,705.89 34,262.88 17.47 3.11 5.58
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
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
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
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
Cognizant Technology Solutions Corporation CTSH 7,346.0 41.8 1,051.0 1.34 23.87 21,716.82 4,923.54 20.66 4.41 2.96
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
Chipotle Mexican Grill, Inc. CMG 2,731.0 27.1 278.0 1.34 24.28 8,733.44 1,282.24 31.42 6.81 3.2
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
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
Quanta Services, Inc. PWR 5,920.0 15.8 307.0 1.36 8.58 5,733.96 3,834.0 18.68 1.5 0.97
Corning Incorporated GLW 8,012.0 42.4 1,728.0 1.37 8.12 19,020.78 22,017.72 11.01 0.86 2.37
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
Leucadia National Corporation LUK 9,194.0 17.7 854.0 1.38 13.2 5,789.25 6,889.83 6.78 0.84 0.63
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
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
Juniper Networks, Inc. JNPR 4,365.0 62.1 187.0 1.4 2.65 10,141.28 7,243.02 54.23 1.4 2.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
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
SanDisk Corporation SNDK 5,053.0 33.3 417.0 1.42 5.83 10,483.55 7,372.05 25.14 1.42 2.07
Broadcom Corporation BRCM 8,006.0 49.7 719.0 1.43 10.01 19,578.24 7,937.28 27.23 2.47 2.45
F5 Networks, Inc. FFIV 1,377.0 82.9 275.0 1.44 22.6 7,730.4 1,345.6 28.11 5.74 5.61
Visa Inc. V 10,421.0 79.5 2,144.0 1.45 7.93 87,245.04 23,092.68 40.69 3.78 8.37
Biogen Idec Inc. BIIB 5,516.0 90.1 1,380.0 1.46 20.62 36,753.6 7,063.2 26.63 5.2 6.66