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
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
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
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
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
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
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
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
Patterson Companies, Inc. PDCO 3,536.0 32.9 213.0 1.99 14.5 3,571.98 1,388.61 16.77 2.57 1.01
Noble Corporation NE 3,547.0 45.9 522.0 1.89 6.9 8,824.64 7,711.44 16.91 1.14 2.49
SLM Corporation SLM 3,549.0 939.0 40.32 20.04 8,283.45 4,791.36 8.82 1.73 2.33
Torchmark Corporation TMK 3,590.0 529.0 4.3 12.32 5,106.78 4,536.42 9.65 1.13 1.42
Netflix, Inc. NFLX 3,609.0 27.2 17.0 5.33 2.47 5,003.2 790.6 6.33 1.39
Tiffany & Co. TIF 3,643.0 59.0 439.0 1.77 19.41 7,732.26 2,391.66 17.61 3.23 2.12
Leggett & Platt, Incorporated LEG 3,721.0 20.1 248.0 2.27 18.19 3,899.66 1,474.6 15.72 2.64 1.05
FMC Corporation FMC 3,748.0 35.8 416.0 2.95 30.59 7,469.86 1,494.25 17.96 5.0 1.99
NYSE Euronext, Inc. NYX 3,749.0 62.0 348.0 1.98 5.38 5,875.0 6,555.0 16.88 0.9 1.57
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
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
Northern Trust Corporation NTRS 3,896.0 687.0 12.95 9.39 11,502.93 7,591.5 16.74 1.52 2.95
Mead Johnson Nutrition Company MJN 3,901.0 61.9 605.0 174.24 13,559.88 18.36 22.41 3.48
Molson Coors Brewing Company TAP 3,917.0 39.9 443.0 2.03 5.67 7,898.8 7,987.98 17.83 0.99 2.02
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
NVIDIA Corporation NVDA 3,998.0 51.4 581.0 1.34 15.86 8,919.68 4,170.32 15.35 2.14 2.23
McCormick & Company, Incorporated MKC 4,014.0 40.3 408.0 2.48 24.83 8,308.0 1,701.8 20.36 4.88 2.07
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
Expedia, Inc. EXPE 4,030.0 77.7 280.0 3.11 12.51 8,079.4 2,359.0 28.86 3.42 2.0
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
Hospira Inc HSP 4,092.0 27.2 44.0 2.0 1.48 5,316.98 3,054.4 1.74 1.3
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
Lennar Corporation LEN 4,105.0 11.0 679.0 3.03 22.23 8,346.09 3,904.77 12.29 2.14 2.03