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
AutoZone, Inc. AZO 8,604.0 51.5 930.0 14,371.6 -1,672.4 15.45 1.67
Clorox Company (The) CLX 5,468.0 42.1 541.0 9,480.24 -137.28 17.52 1.73
Dun & Bradstreet Corporation (The) DNB 1,663.0 68.7 296.0 3,740.72 -1,132.98 12.64 2.25
Lorillard, Inc LO 6,623.0 36.0 1,099.0 46,917.0 -1,813.5 42.69 7.08
Marriot International MAR 11,814.0 13.4 571.0 11,495.57 -1,333.99 20.13 0.97
Cablevision Systems Corporation CVC 6,705.0 50.4 234.0 3,823.44 -5,687.1 16.34 0.57
Philip Morris International Inc PM 77,393.0 27.1 8,800.0 150,706.44 -3,553.2 17.13 1.95
VeriSign, Inc. VRSN 874.0 80.8 320.0 6,066.36 -9.84 18.96 6.94
Goodyear Tire & Rubber Company (The) GT 20,992.0 18.2 212.0 307.56 3,233.23 -130.91 15.25 0.15
DIRECTV DTV 29,740.0 47.6 2,949.0 32,051.88 -5,957.0 10.87 1.08
Wynn Resorts, Limited WYNN 5,154.0 36.9 502.0 54.87 11,444.16 -267.28 22.8 2.22
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
Mead Johnson Nutrition Company MJN 3,901.0 61.9 605.0 174.24 13,559.88 18.36 22.41 3.48
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
Pitney Bowes Inc PBI 4,904.0 52.0 445.0 71.47 2,198.94 110.55 4.94 19.89 0.45
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
SLM Corporation SLM 3,549.0 939.0 40.32 20.04 8,283.45 4,791.36 8.82 1.73 2.33
Masco Corporation MAS 7,745.0 25.2 -114.0 21.35 -26.86 5,538.63 321.08 17.25 0.72
Prudential Financial, Inc. PRU 84,815.0 469.0 18.39 1.24 24,570.0 38,820.6 52.39 0.63 0.29
Principal Financial Group Inc PFG 9,215.0 806.0 16.6 7.97 8,319.0 9,960.0 10.32 0.84 0.9
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
The Charles Schwab Corporation SCHW 4,899.0 928.0 15.32 10.74 17,046.75 8,708.25 18.37 1.96 3.48
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
AMERIPRISE FINANCIAL SERVICES, INC. AMP 10,259.0 1,029.0 14.82 10.64 13,667.67 9,941.34 13.28 1.37 1.33
Lincoln National Corporation LNC 11,532.0 1,313.0 14.62 9.01 7,413.12 15,888.96 5.65 0.47 0.64
Hartford Financial Services Group, Inc. (The) HIG 26,412.0 -38.0 13.64 -0.36 9,557.16 21,974.46 0.43 0.36
Goldman Sachs Group, Inc. (The) GS 34,163.0 7,475.0 13.5 10.66 60,377.16 77,116.2 8.08 0.78 1.77
MetLife, Inc. MET 68,150.0 1,324.0 12.98 1.93 35,616.39 63,586.08 26.9 0.56 0.52
Northern Trust Corporation NTRS 3,896.0 687.0 12.95 9.39 11,502.93 7,591.5 16.74 1.52 2.95
Morgan Stanley MS 26,112.0 68.0 12.89 -0.05 32,642.19 58,913.3 0.55 1.25