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
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
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
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
Stryker Corporation SYK 8,657.0 67.9 1,298.0 1.54 15.95 20,984.57 8,663.46 16.17 2.42 2.42
EOG Resources, Inc. EOG 11,683.0 83.7 570.0 2.06 4.4 31,904.83 13,254.61 55.97 2.41 2.73
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
Exxon Mobil Corporation XOM 482,295.0 29.9 44,880.0 2.01 28.03 409,161.48 170,495.52 9.12 2.4 0.85
EQT Corporation EQT 1,642.0 71.0 183.0 2.46 5.1 8,659.5 3,601.5 47.32 2.4 5.27
KLA-Tencor Corporation KLAC 3,172.0 58.1 756.0 1.54 24.48 8,046.1 3,369.4 10.64 2.39 2.54
Xylem Inc. XYL 3,791.0 39.6 297.0 2.26 15.23 4,925.28 2,077.62 16.58 2.37 1.3
Raytheon Company RTN 24,414.0 21.8 1,888.0 3.32 23.3 19,341.94 8,172.98 10.24 2.37 0.79
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
EMC Corporation EMC 21,714.0 62.8 2,733.0 1.7 13.23 55,194.12 23,405.66 20.2 2.36 2.54
ConAgra Foods, Inc. CAG 13,263.0 21.3 468.0 2.58 10.24 10,725.88 4,552.02 22.92 2.36 0.81
Harris Corporation HRS 5,451.0 34.5 31.0 2.88 1.38 4,698.9 1,988.35 2.36 0.86
JDS Uniphase Corporation JDSU 1,682.0 42.2 -56.0 1.8 -5.28 2,419.6 1,032.7 2.34 1.44
Electronic Arts Inc. EA 4,143.0 61.4 76.0 2.23 3.03 5,799.36 2,493.12 76.31 2.33 1.4
Walt Disney Company (The) DIS 42,278.0 21.0 5,682.0 1.88 14.73 93,663.36 40,286.88 16.48 2.32 2.22
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
Joy Global Inc. JOY 5,661.0 33.2 762.0 2.38 33.65 6,012.33 2,603.31 7.89 2.31 1.06
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
Cintas Corporation CTAS 4,102.0 42.4 298.0 1.95 13.4 5,011.5 2,198.3 16.82 2.28 1.22
Pfizer, Inc. PFE 58,986.0 80.8 14,570.0 2.29 17.84 190,778.28 83,789.28 13.09 2.28 3.23
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
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
CSX Corporation CSX 11,756.0 64.1 1,859.0 3.4 21.32 20,727.2 9,162.4 11.15 2.26 1.76
Medtronic, Inc. MDT 16,184.0 76.0 3,617.0 1.93 21.87 39,612.2 17,490.0 10.95 2.26 2.45
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
Sealed Air Corporation SEE 7,648.0 33.3 -1,410.0 6.54 -64.09 3,198.01 1,432.06 2.23 0.42
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