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
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
Public Service Enterprise Group Incorporated PEG 9,781.0 62.0 1,275.0 2.94 12.11 15,255.63 10,804.17 11.97 1.41 1.56
Cigna Corporation CI 29,119.0 1,623.0 5.5 17.92 15,085.05 9,741.3 9.29 1.55 0.52
Weyerhaeuser Company WY 7,059.0 17.7 385.0 3.09 9.24 14,877.9 4,065.0 38.64 3.66 2.11
Ingersoll-Rand plc (Ireland) IR 14,035.0 30.5 1,019.0 2.59 14.48 14,862.69 7,519.98 14.59 1.98 1.06
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
Edison International EIX 11,862.0 65.1 -92.0 4.71 -1.88 14,737.8 9,553.5 1.54 1.24
SunTrust Banks, Inc. STI 10,475.0 1,958.0 8.56 9.64 14,633.6 20,223.42 7.47 0.72 1.4
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
Kroger Company (The) KR 90,374.0 20.9 602.0 5.9 12.98 14,421.76 4,210.3 23.96 3.43 0.16
Bed Bath & Beyond Inc. BBBY 9,500.0 41.4 990.0 1.46 25.2 14,391.12 4,065.04 14.54 3.54 1.51
AutoZone, Inc. AZO 8,604.0 51.5 930.0 14,371.6 -1,672.4 15.45 1.67
Salesforce.com Inc CRM 2,267.0 78.4 -12.0 2.62 -0.81 14,146.65 1,564.65 9.04 6.24
Applied Materials, Inc. AMAT 8,719.0 38.0 109.0 1.67 1.36 13,919.3 7,713.08 1.8 1.6
CF Industries Holdings, Inc. CF 6,104.0 51.0 1,849.0 1.72 35.38 13,889.85 6,094.4 7.51 2.28 2.28
Cerner Corporation CERN 2,665.0 77.2 397.0 1.31 15.44 13,803.68 2,898.72 34.77 4.76 5.18
Fifth Third Bancorp FITB 6,594.0 1,576.0 9.15 11.8 13,773.76 14,284.6 8.74 0.96 2.09
W.W. Grainger, Inc. GWW 8,950.0 43.8 690.0 1.66 24.41 13,706.55 3,089.92 19.86 4.44 1.53
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
Cameron International Corporation CAM 8,502.0 29.1 751.0 2.0 14.61 13,644.96 5,594.88 18.17 2.44 1.6
Mead Johnson Nutrition Company MJN 3,901.0 61.9 605.0 174.24 13,559.88 18.36 22.41 3.48
Health Care REIT, Inc. HCN 1,822.0 68.7 297.0 2.11 2.88 13,492.2 8,047.86 45.43 1.68 7.41
ENSCO plc ESV 4,301.0 52.8 1,170.0 1.57 10.29 13,381.4 11,697.8 11.44 1.14 3.11
Omnicom Group Inc. OMC 14,219.0 100.0 998.0 6.4 28.67 13,340.7 3,566.7 13.37 3.74 0.94
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
Symantec Corporation SYMC 6,730.0 83.9 1,172.0 2.56 24.36 13,262.04 5,265.92 11.32 2.52 1.97
Agilent Technologies, Inc. A 6,858.0 52.6 1,153.0 2.03 24.3 13,205.73 5,287.94 11.45 2.5 1.93
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
CA Inc. CA 4,814.0 86.6 951.0 2.22 17.26 13,149.0 5,410.57 13.83 2.43 2.73
AvalonBay Communities, Inc. AVB 1,039.0 63.5 424.0 1.63 7.55 13,031.06 5,856.48 30.73 2.23 12.54