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
Express Scripts Holding Company ESRX 93,858.0 7.8 1,313.0 2.49 10.15 40,741.38 21,349.26 31.03 1.91 0.43
WellPoint Inc. WLP 61,712.0 2,656.0 2.48 11.28 18,918.25 25,385.75 7.12 0.75 0.31
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
Fluor Corporation FLR 27,577.0 3.2 456.0 2.48 13.55 9,663.36 3,457.44 21.19 2.79 0.35
Tyco International, Ltd. (Switzerland) TYC 10,403.0 36.3 472.0 2.48 4.92 25,742.8 5,005.03 54.54 5.14 2.47
Valero Energy Corporation VLO 139,250.0 5.2 2,083.0 2.47 12.09 18,158.96 18,158.96 8.72 1.0 0.13
EQT Corporation EQT 1,642.0 71.0 183.0 2.46 5.1 8,659.5 3,601.5 47.32 2.4 5.27
ConocoPhillips COP 62,004.0 45.9 8,428.0 2.44 14.89 72,523.64 49,280.49 8.61 1.47 1.17
TE Connectivity Ltd. TEL 13,282.0 30.5 1,112.0 2.42 14.4 15,462.8 8,109.8 13.91 1.91 1.16
Estee Lauder Companies, Inc. (The) EL 9,714.0 79.5 857.0 2.41 31.96 21,838.97 2,790.91 25.48 7.83 2.25
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
Stanley Black & Decker, Inc. SWK 10,191.0 36.4 884.0 2.38 12.93 11,997.28 6,960.56 13.57 1.72 1.18
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
Union Pacific Corporation UNP 20,926.0 66.8 3,943.0 2.37 20.51 59,734.71 20,196.18 15.15 2.96 2.85
Eli Lilly and Company LLY 22,603.0 78.8 4,089.0 2.33 28.89 55,984.04 14,386.96 13.69 3.89 2.48
Marathon Petroleum Corporation MPC 82,492.0 9.5 3,389.0 2.33 31.97 21,207.42 12,011.04 6.26 1.77 0.26
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
McDonald's Corporation MCD 27,567.0 39.2 5,465.0 2.31 36.82 91,198.2 15,555.0 16.69 5.86 3.31
Archer-Daniels-Midland Company ADM 89,038.0 4.1 1,223.0 2.31 6.65 21,212.1 18,175.14 17.34 1.17 0.24
Emerson Electric Company EMR 24,412.0 40.0 1,968.0 2.31 19.02 36,580.95 10,400.25 18.59 3.52 1.5
Phillips 66 PSX 182,922.0 13.3 4,124.0 2.31 18.73 34,130.46 21,224.84 8.28 1.61 0.19
Stericycle, Inc. SRCL 1,913.0 44.8 268.0 2.3 19.56 8,256.3 1,559.91 30.81 5.29 4.32
News Corporation NWSA 33,706.0 38.3 1,179.0 2.3 4.35 48,677.76 976.56 41.29 49.85 1.44
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
Pfizer, Inc. PFE 58,986.0 80.8 14,570.0 2.29 17.84 190,778.28 83,789.28 13.09 2.28 3.23
Time Warner Inc. TWX 28,729.0 44.5 3,019.0 2.29 10.09 45,510.88 31,290.56 15.07 1.45 1.58
Gilead Sciences, Inc. GILD 9,703.0 74.5 2,592.0 2.28 32.3 235,001.25 19,401.45 90.66 12.11 24.22
Parker-Hannifin Corporation PH 13,146.0 24.2 1,152.0 2.28 22.41 12,596.85 5,025.1 10.93 2.51 0.96
Genuine Parts Company GPC 13,014.0 29.0 648.0 2.27 22.42 9,929.4 3,020.16 15.32 3.29 0.76
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