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
General Dynamics Corporation GD 31,513.0 16.2 -332.0 3.01 -2.7 24,092.25 11,281.88 2.14 0.76
Cliffs Natural Resources Inc. CLF 5,873.0 20.0 -899.0 2.93 -17.27 4,382.12 4,616.42 0.95 0.75
Interpublic Group of Companies, Inc. (The) IPG 6,956.0 100.0 447.0 6.14 19.6 5,151.51 2,534.87 11.52 2.03 0.74
MetroPCS Communications, Inc. PCS 5,101.0 42.6 394.0 3.03 12.54 3,737.6 3,372.6 9.49 1.11 0.73
ONEOK, Inc. OKE 12,633.0 18.6 361.0 7.45 16.51 9,062.45 2,192.29 25.1 4.13 0.72
Masco Corporation MAS 7,745.0 25.2 -114.0 21.35 -26.86 5,538.63 321.08 17.25 0.72
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
LyondellBasell Industries NV LYB 45,352.0 12.7 2,848.0 2.17 26.21 31,371.49 11,234.19 11.02 2.79 0.69
Seagate Technology. STX 14,939.0 31.4 2,862.0 2.89 96.04 10,314.99 3,894.03 3.6 2.65 0.69
CarMax Inc KMX 10,004.0 13.8 414.0 3.12 16.67 6,909.21 2,718.87 16.69 2.54 0.69
Northrop Grumman Corporation NOC 25,218.0 22.1 1,978.0 2.79 19.93 17,214.12 10,061.81 8.7 1.71 0.68
Nucor Corporation NUE 19,429.0 7.8 505.0 1.85 6.68 12,968.04 7,651.08 25.68 1.69 0.67
Lowe's Companies, Inc. LOW 50,208.0 34.6 1,839.0 2.03 10.62 33,645.39 16,803.6 18.3 2.0 0.67
Bemis Company, Inc. BMS 5,139.0 18.4 174.0 2.55 10.79 3,465.28 1,653.6 19.92 2.1 0.67
Harman International Industries, Incorporated HAR 4,364.0 27.1 330.0 2.07 22.32 2,886.48 1,562.4 8.75 1.85 0.66
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
Kohl's Corporation KSS 18,804.0 38.2 1,167.0 2.17 15.98 12,474.13 7,140.85 10.69 1.75 0.66
Washington Post Company (The) WPO 4,018.0 53.2 132.0 1.97 5.06 2,610.58 2,437.19 19.78 1.07 0.65
Allegheny Technologies Incorporated ATI 5,032.0 13.8 158.0 2.52 6.39 3,222.18 2,701.53 20.39 1.19 0.64
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
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
FedEx Corporation FDX 42,680.0 68.9 2,032.0 2.03 13.57 27,468.05 14,727.82 13.52 1.87 0.64
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
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
Nabors Industries Ltd. NBR 6,751.0 33.6 164.0 2.13 2.84 4,277.8 5,977.24 26.08 0.72 0.63
NRG Energy, Inc. NRG 8,422.0 27.7 559.0 3.51 6.29 5,190.12 7,263.36 9.28 0.71 0.62
Allstate Corporation (The) ALL 33,315.0 2,306.0 6.17 11.75 20,410.2 21,179.28 8.85 0.96 0.61
Western Digital Corporation WDC 12,478.0 29.2 1,612.0 1.85 24.5 7,651.35 7,636.65 4.75 1.0 0.61
Avery Dennison Corporation AVY 6,036.0 26.1 215.0 3.23 13.3 3,523.52 1,645.28 16.39 2.14 0.58
Avon Products, Inc. AVP 10,717.0 61.1 -43.0 6.07 -3.05 6,229.44 1,218.24 5.11 0.58