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
AT&T Inc. T 127,434.0 56.7 7,264.0 2.95 7.34 196,342.33 96,337.55 27.03 2.04 1.54
Starbucks Corporation SBUX 13,300.0 56.3 1,384.0 1.61 29.15 39,291.59 5,194.56 28.39 7.56 2.95
Life Technologies Corporation LIFE 3,799.0 56.2 431.0 1.86 9.31 9,023.39 4,863.43 20.94 1.86 2.38
Fossil, Inc. FOSL 2,858.0 56.2 343.0 1.49 29.36 5,399.11 1,262.09 15.74 4.28 1.89
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
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
Teradata Corporation TDC 2,665.0 55.9 419.0 1.72 25.6 10,084.36 1,847.28 24.07 5.46 3.78
Roper Industries, Inc. ROP 2,993.0 55.8 483.0 1.92 14.05 11,223.0 3,740.0 23.24 3.0 3.75
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
Altria Group MO 17,500.0 54.6 4,180.0 11.15 122.08 67,642.08 3,197.92 16.18 21.15 3.87
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
Airgas, Inc. ARG 4,746.0 54.2 313.0 3.04 17.98 6,477.12 1,787.76 20.69 3.62 1.36
Wyndham Worldwide Corp WYN 4,534.0 53.8 400.0 4.9 19.22 7,316.7 2,038.7 18.29 3.59 1.61
Time Warner Cable Inc TWC 21,386.0 53.5 2,155.0 6.84 29.1 29,303.04 7,628.4 13.6 3.84 1.37
Teradyne, Inc. TER 1,657.0 53.5 217.0 1.37 13.22 3,755.9 2,175.8 17.31 1.73 2.27
Newmont Mining Corporation NEM 9,868.0 53.4 1,809.0 2.15 13.57 22,509.89 13,976.99 12.44 1.61 2.28
The NASDAQ OMX Group, Inc. NDAQ 3,119.0 53.3 352.0 1.75 6.91 4,062.04 5,440.85 11.54 0.75 1.3
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
DENTSPLY International Inc. XRAY 2,928.0 53.1 314.0 2.25 15.49 5,702.4 2,234.88 18.16 2.55 1.95
Mattel, Inc. MAT 6,421.0 53.1 776.0 2.13 27.35 12,826.22 3,100.16 16.53 4.14 2.0
Windstream Corporation WIN 6,156.0 52.9 168.0 12.66 12.91 4,902.3 1,099.8 29.18 4.46 0.8
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
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
Pepsico, Inc. PEP 65,492.0 52.2 6,178.0 3.33 28.65 110,580.75 22,869.0 17.9 4.84 1.69
Monsanto Company MON 13,504.0 52.2 2,045.0 1.71 17.5 46,839.6 11,955.6 22.9 3.92 3.47
FLIR Systems, Inc. FLIR 1,405.0 52.0 222.0 1.36 13.99 3,133.9 1,689.38 14.12 1.86 2.23
Pitney Bowes Inc PBI 4,904.0 52.0 445.0 71.47 2,198.94 110.55 4.94 19.89 0.45
Monster Beverage Corporation MNST 2,061.0 51.7 340.0 1.62 41.89 9,669.72 711.87 28.44 13.58 4.69
Hasbro, Inc. HAS 4,089.0 51.7 336.0 2.87 22.98 4,963.2 1,543.08 14.77 3.22 1.21
Pall Corporation PLL 2,672.0 51.7 319.0 2.22 21.29 6,187.92 1,559.96 19.4 3.97 2.32