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
Whirlpool Corporation WHR 18,143.0 15.9 401.0 3.61 9.5 7,873.14 4,259.68 19.63 1.85 0.43
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
Exelon Corporation EXC 23,489.0 56.8 1,160.0 3.67 6.48 24,348.87 20,532.33 20.99 1.19 1.04
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
Jabil Circuit, Inc. JBL 17,152.0 7.6 395.0 3.71 19.87 4,783.37 2,156.42 12.11 2.22 0.28
Macy's Inc M 26,405.0 40.4 1,256.0 3.72 21.91 14,784.88 6,071.68 11.77 2.44 0.56
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
FirstEnergy Corporation FE 15,303.0 56.2 770.0 3.85 5.84 17,409.45 13,110.51 22.61 1.33 1.14
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
Cardinal Health, Inc. CAH 107,552.0 4.2 1,069.0 3.89 17.68 14,623.1 6,295.96 13.68 2.32 0.14
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
Vornado Realty Trust VNO 2,427.0 617.0 3.92 9.62 4,787.2 5,619.35 7.76 0.85 1.97
Dr Pepper Snapple Group, Inc DPS 5,995.0 58.3 629.0 3.92 27.69 9,732.92 2,355.32 15.47 4.13 1.62
NiSource, Inc NI 5,061.0 69.5 416.0 3.93 7.89 7,347.0 5,370.0 17.66 1.37 1.45
Aon plc AON 11,514.0 100.0 993.0 3.93 12.54 18,781.2 8,315.01 18.91 2.26 1.63
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
Eastman Chemical Company EMN 8,102.0 21.7 437.0 3.95 18.16
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
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
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
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
NextEra Energy, Inc. NEE 14,256.0 64.1 1,911.0 4.01 12.32 28,969.66 15,880.1 15.16 1.82 2.03
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
Computer Sciences Corporation CSC 15,877.0 6.1 -4,242.0 4.03 -82.51 4,877.85 2,776.05 1.76 0.31
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
Loews Corporation L 14,552.0 568.0 4.11 2.97 16,251.84 19,669.32 28.61 0.83 1.12
Dow Chemical Company (The) DOW 56,786.0 15.8 1,182.0 4.12 4.79 35,997.36 16,499.28 30.45 2.18 0.63
The Travelers Companies, Inc. TRV 25,740.0 2,473.0 4.13 9.92 28,602.6 26,254.8 11.57 1.09 1.11
AGL Resources, Inc. GAS 3,922.0 54.3 271.0 4.14 8.05 4,695.22 3,417.28 17.33 1.37 1.2
PPL Corporation PPL 12,286.0 60.3 1,526.0 4.16 14.32 16,878.0 10,481.82 11.06 1.61 1.37