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
Target Corporation TGT 69,865.0 30.9 2,929.0 2.95 18.71 33,372.36 16,169.76 11.39 2.06 0.48
Amphenol Corporation APH 4,292.0 31.3 555.0 2.15 24.14 10,151.6 2,492.8 18.29 4.07 2.37
Seagate Technology. STX 14,939.0 31.4 2,862.0 2.89 96.04 10,314.99 3,894.03 3.6 2.65 0.69
Precision Castparts Corporation PCP 7,215.0 31.4 1,224.0 1.26 15.77 25,472.62 8,409.6 20.81 3.03 3.53
DaVita Inc. DVA 8,186.0 31.9 536.0 4.26 18.16 10,436.02 3,495.66 19.47 2.99 1.27
Kimberly-Clark Corporation KMB 21,063.0 32.0 1,750.0 3.99 34.2 33,941.16 5,072.76 19.39 6.69 1.61
Fidelity National Information Services, Inc. FIS 5,808.0 32.0 461.0 2.04 7.02 10,859.12 6,728.84 23.56 1.61 1.87
Xerox Corporation XRX 22,390.0 32.3 1,195.0 2.69 10.37 9,342.87 12,133.77 7.82 0.77 0.42
Total System Services, Inc. TSS 1,871.0 32.5 244.0 1.42 17.92 4,150.44 1,440.18 17.01 2.88 2.22
Carnival Corporation CCL 15,382.0 32.9 1,298.0 1.64 5.44 30,505.64 24,024.36 23.5 1.27 1.98
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
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
SanDisk Corporation SNDK 5,053.0 33.3 417.0 1.42 5.83 10,483.55 7,372.05 25.14 1.42 2.07
Flowserve Corporation FLS 4,751.0 33.3 448.0 2.55 21.55 7,573.7 2,081.31 16.91 3.64 1.59
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
J.M. Smucker Company (The) SJM 5,526.0 33.4 460.0 1.77 8.79 9,075.03 5,290.66 19.73 1.72 1.64
CONSOL Energy Inc. CNX 5,430.0 33.6 388.0 3.2 10.27 7,618.83 3,968.57 19.64 1.92 1.4
Nabors Industries Ltd. NBR 6,751.0 33.6 164.0 2.13 2.84 4,277.8 5,977.24 26.08 0.72 0.63
H.J. Heinz Company HNZ 11,649.0 34.3 923.0 4.34 31.47 16,980.11 2,781.03 18.4 6.11 1.46
Harris Corporation HRS 5,451.0 34.5 31.0 2.88 1.38 4,698.9 1,988.35 2.36 0.86
Home Depot, Inc. (The) HD 70,395.0 34.5 3,883.0 2.26 21.11 68,342.1 18,274.8 17.6 3.74 0.97
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
Lowe's Companies, Inc. LOW 50,208.0 34.6 1,839.0 2.03 10.62 33,645.39 16,803.6 18.3 2.0 0.67
Waste Management, Inc. WM 13,649.0 34.9 817.0 3.64 13.15 15,929.12 6,352.16 19.5 2.51 1.17
Family Dollar Stores, Inc. FDO 9,331.0 34.9 422.0 2.6 35.41 7,517.78 1,327.5 17.81 5.66 0.81
Whole Foods Market, Inc. WFM 11,699.0 35.5 466.0 1.39 13.71 17,991.52 3,788.56 38.61 4.75 1.54
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
Freeport-McMoran Copper & Gold, Inc. FCX 18,010.0 35.8 3,041.0 2.02 18.33 30,566.16 17,639.46 10.05 1.73 1.7
Dollar Tree, Inc. DLTR 6,631.0 35.9 488.0 1.73 34.83 20,013.4 1,408.44 41.01 14.21 3.02