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
Textron Inc. TXT 12,237.0 18.1 589.0 4.36 20.54 7,136.05 3,250.9 12.12 2.2 0.58
International Paper Company IP 27,833.0 26.0 794.0 5.1 12.29 15,985.2 6,305.2 20.13 2.54 0.57
Cablevision Systems Corporation CVC 6,705.0 50.4 234.0 3,823.44 -5,687.1 16.34 0.57
L-3 Communications Holdings, Inc. LLL 13,146.0 10.3 810.0 2.53 13.39 7,511.7 5,920.18 9.27 1.27 0.57
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
Unum Group UNM 10,515.0 894.0 7.23 10.41 5,913.54 8,987.34 6.61 0.66 0.56
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
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
Big Lots, Inc. BIG 5,202.0 39.8 207.0 1.99 23.4 2,660.64 892.86 12.85 2.98 0.51
UnitedHealth Group Incorporated UNH 110,618.0 9.5 5,526.0 2.59 18.58 56,682.74 32,007.6 10.26 1.77 0.51
CVS Corporation CVS 123,133.0 18.3 3,877.0 1.75 10.24 60,467.2 39,206.4 15.6 1.54 0.49
Sprint Nextel Corporation S 35,345.0 41.0 -4,326.0 7.28 -46.73 16,991.32 7,054.7 2.41 0.48
Target Corporation TGT 69,865.0 30.9 2,929.0 2.95 18.71 33,372.36 16,169.76 11.39 2.06 0.48
Jacobs Engineering Group Inc. JEC 10,894.0 15.9 379.0 1.84 10.77 5,259.33 3,695.85 13.88 1.42 0.48
Dell Inc. DELL 62,071.0 22.3 3,492.0 4.99 41.86 29,314.46 9,190.88 8.39 3.19 0.47
Owens-Illinois, Inc. OI 7,000.0 19.6 184.0 9.76 21.4 3,323.32 891.42 18.06 3.73 0.47
Wal-Mart Stores, Inc. WMT 446,950.0 25.0 15,699.0 2.71 22.45 205,104.96 72,467.64 13.06 2.83 0.46
Johnson Controls, Inc. JCI 41,955.0 14.8 1,226.0 2.67 10.85 19,092.19 11,644.1 15.57 1.64 0.46
Hess Corporation HES 37,691.0 23.8 2,025.0 2.06 10.23 17,006.8 20,995.0 8.4 0.81 0.45
The AES Corporation AES 18,141.0 20.5 -912.0 9.16 -17.35 8,093.6 4,635.7 1.75 0.45
Pitney Bowes Inc PBI 4,904.0 52.0 445.0 71.47 2,198.94 110.55 4.94 19.89 0.45
Walgreen Co. WAG 71,633.0 28.4 2,127.0 1.83 12.86 31,829.6 17,001.6 14.96 1.87 0.44
Southwest Airlines Company LUV 17,088.0 56.0 421.0 2.66 6.07 7,448.88 7,244.49 17.69 1.03 0.44
Express Scripts Holding Company ESRX 93,858.0 7.8 1,313.0 2.49 10.15 40,741.38 21,349.26 31.03 1.91 0.43
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
J.C. Penney Company, Inc. Holding Company JCP 17,260.0 36.0 -152.0 2.85 -3.21 7,469.14 4,029.69 1.85 0.43
Coventry Health Care, Inc. CVH 14,113.0 21.2 487.0 1.85 10.55 6,049.92 4,808.7 12.42 1.26 0.43
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
Costco Wholesale Corporation COST 99,137.0 12.4 1,709.0 2.2 14.03 41,836.7 12,551.01 24.48 3.33 0.42
Xerox Corporation XRX 22,390.0 32.3 1,195.0 2.69 10.37 9,342.87 12,133.77 7.82 0.77 0.42