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
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
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
AutoZone, Inc. AZO 8,604.0 51.5 930.0 14,371.6 -1,672.4 15.45 1.67
McKesson Corporation MCK 122,734.0 5.4 1,403.0 4.84 19.97 21,686.4 6,967.76 15.46 3.11 0.18
Dr Pepper Snapple Group, Inc DPS 5,995.0 58.3 629.0 3.92 27.69 9,732.92 2,355.32 15.47 4.13 1.62
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
Johnson Controls, Inc. JCI 41,955.0 14.8 1,226.0 2.67 10.85 19,092.19 11,644.1 15.57 1.64 0.46
CVS Corporation CVS 123,133.0 18.3 3,877.0 1.75 10.24 60,467.2 39,206.4 15.6 1.54 0.49
Hormel Foods Corporation HRL 8,231.0 16.2 500.0 1.62 18.26 7,809.07 2,883.68 15.62 2.71 0.95
Baxter International Inc. BAX 14,190.0 51.5 2,326.0 2.94 34.4 36,412.44 7,061.2 15.65 5.16 2.57
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
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
Nordstrom, Inc. JWN 10,877.0 39.4 683.0 4.34 34.35 10,760.48 2,053.56 15.75 5.24 0.99
AutoNation, Inc. AN 15,669.0 15.9 316.0 4.27 17.66 4,979.52 1,760.22 15.76 2.83 0.32
Cincinnati Financial Corporation CINF 4,111.0 421.0 3.03 8.01 6,655.12 5,485.8 15.81 1.21 1.62
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
Southern Company (The) SO 16,537.0 66.1 2,415.0 3.32 12.6 38,394.72 19,241.31 15.9 2.0 2.32
Anadarko Petroleum Corporation APC 13,411.0 71.1 2,391.0 2.55 12.35 38,051.6 20,692.44 15.91 1.84 2.84
Potomac Electric Power Company POM 5,081.0 47.9 285.0 3.55 6.49 4,535.6 4,445.9 15.91 1.02 0.89
Danaher Corporation DHR 18,260.0 51.6 2,392.0 1.73 13.32 38,081.33 19,721.58 15.92 1.93 2.09
Wisconsin Energy Corporation WEC 4,246.0 61.3 546.0 3.43 13.39 8,753.81 4,238.27 16.03 2.07 2.06
Hudson City Bancorp, Inc. HCBK 865.0 249.0 8.64 5.38 4,005.82 4,423.3 16.09 0.91 4.63
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
Stryker Corporation SYK 8,657.0 67.9 1,298.0 1.54 15.95 20,984.57 8,663.46 16.17 2.42 2.42
Altria Group MO 17,500.0 54.6 4,180.0 11.15 122.08 67,642.08 3,197.92 16.18 21.15 3.87
Amgen Inc. AMGN 17,265.0 83.1 4,345.0 2.85 22.82 70,625.38 19,832.4 16.25 3.56 4.09
Newell Rubbermaid Inc. NWL 5,903.0 37.8 401.0 3.12 20.87 6,541.5 2,046.24 16.31 3.2 1.11
BorgWarner Inc. BWA 7,183.0 20.4 501.0 2.08 18.31 8,173.55 3,227.07 16.31 2.53 1.14
Comcast Corporation CMCSA 62,570.0 68.1 6,203.0 3.34 12.84 101,208.25 50,807.9 16.32 1.99 1.62
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