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
Amazon.com, Inc. AMZN 61,093.0 24.8 -39.0 3.97 -0.49 112,239.81 8,172.12 13.73 1.84
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
Gilead Sciences, Inc. GILD 9,703.0 74.5 2,592.0 2.28 32.3 235,001.25 19,401.45 90.66 12.11 24.22
International Business Machines Corporation IBM 104,507.0 48.1 16,604.0 6.32 85.15 222,476.1 19,496.4 13.4 11.41 2.13
Campbell Soup Company CPB 7,707.0 38.8 774.0 7.27 77.95 10,402.59 918.72 13.44 11.32 1.35
Accenture plc. ACN 29,778.0 30.2 2,554.0 4.02 63.64 44,743.38 4,450.38 17.52 10.05 1.5
Boeing Company (The) BA 81,698.0 16.0 3,900.0 15.15 83.14 57,553.86 5,913.12 14.76 9.73 0.7
Linear Technology Corporation LLTC 1,267.0 75.3 398.0 2.51 64.1 6,977.88 748.8 17.53 9.32 5.51
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
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
Sherwin-Williams Company (The) SHW 9,534.0 44.1 631.0 3.69 41.42 15,577.12 1,702.48 24.69 9.15 1.63
Salesforce.com Inc CRM 2,267.0 78.4 -12.0 2.62 -0.81 14,146.65 1,564.65 9.04 6.24
Dean Foods Company DF 11,462.0 25.3 159.0 15.92 125.0 3,158.28 357.12 19.86 8.84 0.28
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
Mastercard Incorporated MA 7,391.0 100.0 2,759.0 1.8 43.16 60,429.6 7,071.12 21.9 8.55 8.18
Kellogg Company K 14,197.0 38.3 961.0 6.28 45.99 20,206.8 2,412.0 21.03 8.38 1.42
Simon Property Group, Inc. SPG 4,880.0 90.4 1,434.0 5.56 27.34 47,280.12 5,666.1 32.97 8.34 9.69
American Tower Corporation (REIT) AMT 2,876.0 74.9 637.0 3.94 18.58 29,972.88 3,606.96 47.05 8.31 10.42
priceline.com Incorporated PCLN 5,261.0 77.6 1,420.0 1.69 43.87 31,923.96 3,985.14 22.48 8.01 6.07
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
Western Union Company (The) WU 5,665.0 43.6 1,026.0 10.06 111.79 7,872.79 995.48 7.67 7.91 1.39
Estee Lauder Companies, Inc. (The) EL 9,714.0 79.5 857.0 2.41 31.96 21,838.97 2,790.91 25.48 7.83 2.25
Ross Stores, Inc. ROST 8,608.0 27.5 657.0 2.21 46.51 11,571.3 1,513.4 17.61 7.65 1.34
Starbucks Corporation SBUX 13,300.0 56.3 1,384.0 1.61 29.15 39,291.59 5,194.56 28.39 7.56 2.95
TripAdvisor, Inc. TRIP 763.0 98.4 194.0 1.79 38.03 5,412.99 717.69 27.9 7.54 7.09
Edwards Lifesciences Corporation EW 1,900.0 74.0 293.0 1.5 20.82 10,865.44 1,526.92 37.08 7.12 5.72
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
Crown Castle International Corporation CCI 2,433.0 70.0 189.0 5.47 7.41 19,753.08 2,915.82 6.77 8.12
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
Kimberly-Clark Corporation KMB 21,063.0 32.0 1,750.0 3.99 34.2 33,941.16 5,072.76 19.39 6.69 1.61