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
Marsh & McLennan Companies, Inc. MMC 11,924.0 100.0 1,176.0 2.49 18.93 19,253.76 6,618.48 16.37 2.91 1.61
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
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
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
Aon plc AON 11,514.0 100.0 993.0 3.93 12.54 18,781.2 8,315.01 18.91 2.26 1.63
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
Sherwin-Williams Company (The) SHW 9,534.0 44.1 631.0 3.69 41.42 15,577.12 1,702.48 24.69 9.15 1.63
D.R. Horton, Inc. DHI 4,354.0 19.8 956.0 2.02 30.79 7,093.84 4,027.98 7.42 1.76 1.63
Illinois Tool Works Inc. ITW 17,924.0 36.1 2,870.0 1.83 27.89 29,311.81 10,978.33 10.21 2.67 1.64
FMC Technologies, Inc. FTI 6,151.0 21.4 430.0 3.21 26.37 10,112.36 1,867.75 23.52 5.41 1.64
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
Rockwell Automation, Inc. ROK 6,259.0 40.3 737.0 3.04 40.95 10,358.92 1,876.16 14.06 5.52 1.66
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
J P Morgan Chase & Co JPM 97,031.0 21,284.0 12.1 10.72 161,708.82 195,953.94 7.6 0.83 1.67
AutoZone, Inc. AZO 8,604.0 51.5 930.0 14,371.6 -1,672.4 15.45 1.67
CBS Corporation CBS 14,089.0 43.5 1,574.0 2.59 15.65 23,644.92 10,682.39 15.02 2.21 1.68
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
Starwood Hotels & Resorts Worldwide, Inc. HOT 6,321.0 24.1 562.0 2.82 18.45 10,671.49 3,199.28 18.99 3.34 1.69
Pepsico, Inc. PEP 65,492.0 52.2 6,178.0 3.33 28.65 110,580.75 22,869.0 17.9 4.84 1.69
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
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
Zions Bancorporation ZION 2,152.0 350.0 11.27 3.75 3,650.85 4,891.59 10.43 0.75 1.7
First Tennessee National Corporation FHN 1,360.0 -28.0 11.53 -1.21 2,323.76 2,254.32 1.03 1.71
H&R Block, Inc. HRB 2,894.0 44.4 266.0 3.51 19.16 4,981.34 1,357.46 18.73 3.67 1.72
Regions Financial Corporation RF 5,400.0 1,120.0 8.08 7.97 9,306.77 14,743.81 8.31 0.63 1.72
Apache Corporation APA 17,078.0 80.8 2,001.0 2.02 6.65 29,352.37 30,056.17 14.67 0.98 1.72
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
Clorox Company (The) CLX 5,468.0 42.1 541.0 9,480.24 -137.28 17.52 1.73
Northeast Utilities NU 6,274.0 61.8 526.0 3.06 7.94 10,880.92 8,175.98 20.69 1.33 1.73
Mylan Inc. MYL 6,796.0 42.8 641.0 3.57 18.76 11,768.4 3,549.0 18.36 3.32 1.73