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
Dover Corporation DOV 8,104.0 38.3 811.0 2.12 16.47 11,737.36 5,181.44 14.47 2.27 1.45
Waste Management, Inc. WM 13,649.0 34.9 817.0 3.64 13.15 15,929.12 6,352.16 19.5 2.51 1.17
Pacific Gas & Electric Co. PCG 15,040.0 66.6 830.0 4.01 6.48 17,374.0 12,898.75 20.93 1.35 1.16
HCP, Inc. HCP 1,901.0 85.1 833.0 1.89 8.42 19,418.36 9,963.84 23.31 1.95 10.21
Gap, Inc. (The) GPS 14,549.0 36.2 833.0 2.69 24.37 9,668.62 3,027.44 11.61 3.19 0.66
Adobe Systems Incorporated ADBE 4,404.0 89.0 833.0 1.5 13.38 16,548.7 6,785.47 19.87 2.44 3.76
Equity Residential EQR 2,124.0 64.9 842.0 2.38 13.0 17,628.8 7,126.4 20.94 2.47 8.3
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
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
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
KeyCorp KEY 4,231.0 858.0 8.94 8.76 7,685.45 10,165.54 8.96 0.76 1.82
Williams Companies, Inc. (The) WMB 7,486.0 39.6 859.0 5.12 26.25 19,512.5 4,362.5 22.72 4.47 2.61
Sempra Energy SRE 9,647.0 61.7 865.0 3.55 8.53 17,591.34 10,495.03 20.34 1.68 1.82
Entergy Corporation ETR 10,302.0 65.7 868.0 4.7 9.28 11,374.2 9,207.94 13.1 1.24 1.1
Verizon Communications Inc. VZ 115,846.0 60.1 875.0 6.79 2.53 126,013.86 33,199.2 3.8 1.09
Motorola Solutions, Inc. MSI 8,698.0 50.0 881.0 3.88 20.78 16,231.05 3,513.51 18.42 4.62 1.87
Stanley Black & Decker, Inc. SWK 10,191.0 36.4 884.0 2.38 12.93 11,997.28 6,960.56 13.57 1.72 1.18
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
Unum Group UNM 10,515.0 894.0 7.23 10.41 5,913.54 8,987.34 6.61 0.66 0.56
CME Group Inc. CME 2,915.0 75.5 896.0 1.81 4.17 17,947.92 21,430.6 20.03 0.84 6.16
Progressive Corporation (The) PGR 17,084.0 902.0 3.78 15.28 13,169.28 6,043.52 14.6 2.18 0.77
Xcel Energy Inc. XEL 10,128.0 55.2 905.0 3.51 10.43 13,288.24 8,876.72 14.68 1.5 1.31
H.J. Heinz Company HNZ 11,649.0 34.3 923.0 4.34 31.47 16,980.11 2,781.03 18.4 6.11 1.46
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
AutoZone, Inc. AZO 8,604.0 51.5 930.0 14,371.6 -1,672.4 15.45 1.67
SLM Corporation SLM 3,549.0 939.0 40.32 20.04 8,283.45 4,791.36 8.82 1.73 2.33
Public Storage PSA 1,827.0 70.4 939.0 1.67 12.84 24,253.72 5,275.24 25.83 4.6 13.28
Spectra Energy Corp SE 5,075.0 79.6 940.0 3.41 11.03 17,935.04 8,810.08 19.08 2.04 3.53
PPG Industries, Inc. PPG 15,200.0 40.3 941.0 3.91 25.74 19,195.2 4,101.3 20.4 4.68 1.26
Discovery Communications, Inc. DISCA 4,487.0 72.9 943.0 2.06 14.73 22,997.6 9,743.2 24.39 2.36 5.13