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
Clorox Company (The) CLX 5,468.0 42.1 541.0 9,480.24 -137.28 17.52 1.73
DIRECTV DTV 29,740.0 47.6 2,949.0 32,051.88 -5,957.0 10.87 1.08
Lockheed Martin Corporation LMT 47,182.0 8.9 2,745.0 991.21 527.88 30,310.48 39.36 11.04 0.64
Lorillard, Inc LO 6,623.0 36.0 1,099.0 46,917.0 -1,813.5 42.69 7.08
AutoZone, Inc. AZO 8,604.0 51.5 930.0 14,371.6 -1,672.4 15.45 1.67
Dun & Bradstreet Corporation (The) DNB 1,663.0 68.7 296.0 3,740.72 -1,132.98 12.64 2.25
Philip Morris International Inc PM 77,393.0 27.1 8,800.0 150,706.44 -3,553.2 17.13 1.95
Mead Johnson Nutrition Company MJN 3,901.0 61.9 605.0 174.24 13,559.88 18.36 22.41 3.48
Wynn Resorts, Limited WYNN 5,154.0 36.9 502.0 54.87 11,444.16 -267.28 22.8 2.22
VeriSign, Inc. VRSN 874.0 80.8 320.0 6,066.36 -9.84 18.96 6.94
Marriot International MAR 11,814.0 13.4 571.0 11,495.57 -1,333.99 20.13 0.97
Best Buy Co., Inc. BBY 50,705.0 24.8 -1,231.0 4.27 -23.79 9,179.28 0.18
Eastman Chemical Company EMN 8,102.0 21.7 437.0 3.95 18.16
Goodyear Tire & Rubber Company (The) GT 20,992.0 18.2 212.0 307.56 3,233.23 -130.91 15.25 0.15
Discover Financial Services DFS 3,129.0 2,345.0 8.17 26.55 21,361.6 9.11 6.83
Cablevision Systems Corporation CVC 6,705.0 50.4 234.0 3,823.44 -5,687.1 16.34 0.57
Limited Brands, Inc. LTD 10,364.0 39.1 850.0 44.58 105.39 12,321.36 144.44 14.5 85.3 1.19
News Corporation NWSA 33,706.0 38.3 1,179.0 2.3 4.35 48,677.76 976.56 41.29 49.85 1.44
R.R. Donnelley & Sons Company RRD 10,222.0 22.8 -651.0 137.55 -118.92 1,704.6 52.2 32.66 0.17
Moody's Corporation MCO 2,730.0 70.9 690.0 10.28 638.3 11,150.24 392.71 16.16 28.39 4.08
Colgate-Palmolive Company CL 17,085.0 58.1 2,472.0 6.12 108.33 51,259.2 2,246.4 20.74 22.82 3.0
Altria Group MO 17,500.0 54.6 4,180.0 11.15 122.08 67,642.08 3,197.92 16.18 21.15 3.87
McGraw-Hill Companies, Inc. (The) MHP 4,450.0 67.2 437.0 9.19 38.42 16,119.6 783.75 36.89 20.57 3.62
Pitney Bowes Inc PBI 4,904.0 52.0 445.0 71.47 2,198.94 110.55 4.94 19.89 0.45
Masco Corporation MAS 7,745.0 25.2 -114.0 21.35 -26.86 5,538.63 321.08 17.25 0.72
Hershey Company (The) HSY 6,644.0 43.0 661.0 4.59 70.1 16,598.4 1,055.64 25.11 15.72 2.5
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
United Parcel Service, Inc. UPS 54,127.0 76.6 807.0 8.35 13.81 71,395.92 4,738.41 88.47 15.07 1.32
Dollar Tree, Inc. DLTR 6,631.0 35.9 488.0 1.73 34.83 20,013.4 1,408.44 41.01 14.21 3.02
Yum! Brands, Inc. YUM 13,633.0 27.7 1,597.0 4.18 80.31 31,336.25 2,260.94 19.62 13.86 2.3