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
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
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
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
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
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
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
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
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
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
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
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
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
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