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
Molex Incorporated MOLX 3,489.0 30.6 281.0 1.48 11.7 4,297.56 2,449.68 15.29 1.75 1.23
First Solar, Inc. FSLR 3,369.0 25.3 -96.0 1.76 -2.66 2,612.61 3,599.19 0.73 0.78
Pinnacle West Capital Corporation PNW 3,302.0 69.9 382.0 3.37 9.79 5,719.83 4,018.2 14.97 1.42 1.73
Pioneer Natural Resources Company PXD 3,228.0 68.1 192.0 2.3 3.44 12,814.2 5,811.12 66.74 2.21 3.97
WPX Energy, Inc. WPX 3,189.0 41.4 -223.0 1.8 -4.07 3,052.66 5,259.57 0.58 0.96
Perrigo Company PRGO 3,173.0 34.5 402.0 2.17 23.76 9,982.8 1,862.14 24.83 5.36 3.15
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
Helmerich & Payne, Inc. HP 3,152.0 44.5 581.0 1.49 16.36 5,070.6 3,918.24 8.73 1.29 1.61
Fastenal Company FAST 3,134.0 51.5 421.0 1.16 27.86 12,488.85 1,562.22 29.66 7.99 3.98
Discover Financial Services DFS 3,129.0 2,345.0 8.17 26.55 21,361.6 9.11 6.83
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
T. Rowe Price Group, Inc. TROW 3,023.0 92.7 884.0 1.09 24.32 16,719.66 3,904.56 18.91 4.28 5.53
Iron Mountain Incorporated IRM 3,005.0 57.5 172.0 5.53 14.33 5,461.75 1,058.75 31.75 5.16 1.82
TECO Energy, Inc. TE 2,997.0 37.3 213.0 3.21 9.33 3,624.9 2,274.7 17.02 1.59 1.21
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
Diamond Offshore Drilling, Inc. DO 2,987.0 46.9 720.0 1.58 16.17 9,546.52 4,575.88 13.26 2.09 3.2
C.R. Bard, Inc. BCR 2,958.0 62.0 530.0 2.16 28.59 8,216.04 1,979.88 15.5 4.15 2.78
Snap-On Incorporated SNA 2,938.0 47.3 306.0 2.17 18.37 4,703.48 1,824.87 15.37 2.58 1.6
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
CME Group Inc. CME 2,915.0 75.5 896.0 1.81 4.17 17,947.92 21,430.6 20.03 0.84 6.16
H&R Block, Inc. HRB 2,894.0 44.4 266.0 3.51 19.16 4,981.34 1,357.46 18.73 3.67 1.72
American Tower Corporation (REIT) AMT 2,876.0 74.9 637.0 3.94 18.58 29,972.88 3,606.96 47.05 8.31 10.42
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
Internationa Flavors & Fragrances, Inc. IFF 2,821.0 41.7 254.0 2.6 21.6 5,361.16 1,254.6 21.11 4.27 1.9
Varian Medical Systems, Inc. VAR 2,807.0 42.6 427.0 1.91 31.02 6,772.09 1,559.4 15.86 4.34 2.41
Chipotle Mexican Grill, Inc. CMG 2,731.0 27.1 278.0 1.34 24.28 8,733.44 1,282.24 31.42 6.81 3.2
Moody's Corporation MCO 2,730.0 70.9 690.0 10.28 638.3 11,150.24 392.71 16.16 28.39 4.08
Southwestern Energy Company SWN 2,715.0 69.2 -707.0 2.22 -20.19 11,747.34 3,018.85 3.89 4.33
Analog Devices, Inc. ADI 2,701.0 64.5 651.0 1.35 16.36 11,683.08 4,265.64 17.95 2.74 4.33
Huntington Bancshares Incorporated HBAN 2,679.0 641.0 10.39 11.67 5,385.12 5,531.83 8.4 0.97 2.01