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
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
Lam Research Corporation LRCX 2,665.0 40.7 169.0 1.56 4.44 4,702.5 3,436.25 27.83 1.37 1.76
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
Cerner Corporation CERN 2,665.0 77.2 397.0 1.31 15.44 13,803.68 2,898.72 34.77 4.76 5.18
Legg Mason, Inc. LM 2,663.0 100.0 221.0 1.51 3.86 3,929.64 5,810.09 17.78 0.68 1.48
Constellation Brands Inc STZ 2,654.0 40.0 445.0 2.66 17.02 4,483.05 2,877.93 10.07 1.56 1.69
Sigma-Aldrich Corporation SIAL 2,623.0 51.4 460.0 1.5 19.39 8,949.92 2,588.84 19.46 3.46 3.41
Citrix Systems, Inc. CTXS 2,586.0 84.4 353.0 1.54 12.05 11,823.84 3,165.75 33.5 3.73 4.57
Vulcan Materials Company VMC 2,567.0 13.0 -53.0 2.16 -1.39 6,771.7 3,768.7 1.8 2.64
Newfield Exploration Company NFX 2,567.0 66.6 -1,184.0 2.85 -35.34 3,511.35 2,772.9 1.27 1.37
Comerica Incorporated CMA 2,546.0 521.0 9.42 7.46 5,617.92 7,079.04 10.78 0.79 2.21
LSI Logic Corporation LSI 2,506.0 49.2 196.0 2.03 17.69 4,096.05 1,225.91 20.9 3.34 1.63
Ventas, Inc. VTR 2,485.0 60.6 363.0 2.1 3.97 19,107.06 9,084.6 52.64 2.1 7.69
Beam Inc. BEAM 2,466.0 58.3 382.0 1.87 8.78 9,643.9 4,638.41 25.25 2.08 3.91
Denbury Resources, Inc. (Holding Company) DNR 2,456.0 77.7 525.0 2.18 10.59 6,192.88 5,298.18 11.8 1.17 2.52
Crown Castle International Corporation CCI 2,433.0 70.0 189.0 5.47 7.41 19,753.08 2,915.82 6.77 8.12
Vornado Realty Trust VNO 2,427.0 617.0 3.92 9.62 4,787.2 5,619.35 7.76 0.85 1.97
QEP Resources, Inc. QEP 2,350.0 49.8 128.0 2.79 3.91 5,305.56 3,277.49 41.45 1.62 2.26
Scripps Networks Interactive, Inc SNI 2,307.0 73.5 681.0 2.27 38.95 8,840.34 1,871.19 12.98 4.72 3.83
Salesforce.com Inc CRM 2,267.0 78.4 -12.0 2.62 -0.81 14,146.65 1,564.65 9.04 6.24
Xilinx, Inc. XLNX 2,241.0 64.9 530.0 1.65 20.7 9,911.68 2,812.48 18.7 3.52 4.42
Paychex, Inc. PAYX 2,230.0 69.5 548.0 4.04 35.35 10,839.18 1,608.09 19.78 6.74 4.86
Autodesk, Inc. ADSK 2,216.0 89.7 285.0 1.71 16.34 7,579.49 1,943.22 26.59 3.9 3.42
Intuitive Surgical, Inc. ISRG 2,179.0 72.1 657.0 1.13 21.09 21,600.85 3,651.46 32.88 5.92 9.91
BMC Software, Inc. BMC 2,172.0 73.8 401.0 3.36 25.8 6,546.32 1,522.4 16.32 4.3 3.01
Equifax, Inc. EFX 2,161.0 61.6 272.0 2.33 14.97 6,666.6 1,975.38 24.51 3.37 3.08
Zions Bancorporation ZION 2,152.0 350.0 11.27 3.75 3,650.85 4,891.59 10.43 0.75 1.7
International Game Technology IGT 2,151.0 57.5 246.0 3.58 18.63 3,587.3 1,299.2 14.58 2.76 1.67
Equity Residential EQR 2,124.0 64.9 842.0 2.38 13.0 17,628.8 7,126.4 20.94 2.47 8.3
PerkinElmer, Inc. PKI 2,115.0 45.5 70.0 2.01 3.7 3,585.7 1,938.9 51.22 1.85 1.7