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
NRG Energy, Inc. NRG 8,422.0 27.7 559.0 3.51 6.29 5,190.12 7,263.36 9.28 0.71 0.62
E.I. du Pont de Nemours and Company DD 35,310.0 27.5 2,788.0 4.96 30.07 40,713.24 10,117.08 14.6 4.02 1.15
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
TJX Companies, Inc. (The) TJX 23,191.0 27.3 1,496.0 2.58 47.43 50,743.44 3,328.2 33.92 15.25 2.19
Hospira Inc HSP 4,092.0 27.2 44.0 2.0 1.48 5,316.98 3,054.4 1.74 1.3
Netflix, Inc. NFLX 3,609.0 27.2 17.0 5.33 2.47 5,003.2 790.6 6.33 1.39
Philip Morris International Inc PM 77,393.0 27.1 8,800.0 150,706.44 -3,553.2 17.13 1.95
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
Harman International Industries, Incorporated HAR 4,364.0 27.1 330.0 2.07 22.32 2,886.48 1,562.4 8.75 1.85 0.66
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
United Technologies Corporation UTX 57,708.0 27.0 5,130.0 3.45 21.47 73,476.07 25,577.4 14.32 2.87 1.27
National-Oilwell, Inc. NOV 20,041.0 26.6 2,491.0 1.56 13.16 28,989.03 20,244.07 11.64 1.43 1.45
Air Products and Chemicals, Inc. APD 9,612.0 26.6 1,167.0 2.62 19.02 17,894.45 6,579.0 15.33 2.72 1.86
Peabody Energy Corporation BTU 8,078.0 26.6 -586.0 3.22 -11.27 7,316.4 4,893.68 1.5 0.91
Safeway Inc. SWY 44,207.0 26.5 597.0 5.01 18.05 4,423.08 3,008.58 7.41 1.47 0.1
Avery Dennison Corporation AVY 6,036.0 26.1 215.0 3.23 13.3 3,523.52 1,645.28 16.39 2.14 0.58
Cummins Inc. CMI 17,334.0 26.0 1,645.0 1.9 27.2 19,615.6 6,610.1 11.92 2.97 1.13
International Paper Company IP 27,833.0 26.0 794.0 5.1 12.29 15,985.2 6,305.2 20.13 2.54 0.57
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
First Solar, Inc. FSLR 3,369.0 25.3 -96.0 1.76 -2.66 2,612.61 3,599.19 0.73 0.78
Masco Corporation MAS 7,745.0 25.2 -114.0 21.35 -26.86 5,538.63 321.08 17.25 0.72
Wal-Mart Stores, Inc. WMT 446,950.0 25.0 15,699.0 2.71 22.45 205,104.96 72,467.64 13.06 2.83 0.46
Honeywell International Inc. HON 37,665.0 24.9 2,926.0 3.23 24.61 48,993.12 13,131.36 16.74 3.73 1.3
Best Buy Co., Inc. BBY 50,705.0 24.8 -1,231.0 4.27 -23.79 9,179.28 0.18
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
Parker-Hannifin Corporation PH 13,146.0 24.2 1,152.0 2.28 22.41 12,596.85 5,025.1 10.93 2.51 0.96
Starwood Hotels & Resorts Worldwide, Inc. HOT 6,321.0 24.1 562.0 2.82 18.45 10,671.49 3,199.28 18.99 3.34 1.69
Hess Corporation HES 37,691.0 23.8 2,025.0 2.06 10.23 17,006.8 20,995.0 8.4 0.81 0.45
Hewlett-Packard Company HPQ 120,357.0 23.2 -12,650.0 4.85 -41.43 27,991.32 22,562.82 1.24 0.23
Darden Restaurants, Inc. DRI 7,999.0 22.9 476.0 3.23 25.17 6,768.37 1,899.24 14.22 3.56 0.85