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
Sempra Energy SRE 9,647.0 61.7 865.0 3.55 8.53 17,591.34 10,495.03 20.34 1.68 1.82
Iron Mountain Incorporated IRM 3,005.0 57.5 172.0 5.53 14.33 5,461.75 1,058.75 31.75 5.16 1.82
Ecolab Inc. ECL 11,839.0 45.2 704.0 2.89 11.98 21,539.96 6,165.38 30.6 3.49 1.82
O'Reilly Automotive, Inc. ORLY 6,182.0 50.1 586.0 2.73 23.65 11,099.52 2,295.18 18.94 4.84 1.8
Goldman Sachs Group, Inc. (The) GS 34,163.0 7,475.0 13.5 10.66 60,377.16 77,116.2 8.08 0.78 1.77
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
CSX Corporation CSX 11,756.0 64.1 1,859.0 3.4 21.32 20,727.2 9,162.4 11.15 2.26 1.76
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
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
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
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
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
First Tennessee National Corporation FHN 1,360.0 -28.0 11.53 -1.21 2,323.76 2,254.32 1.03 1.71
Zions Bancorporation ZION 2,152.0 350.0 11.27 3.75 3,650.85 4,891.59 10.43 0.75 1.7
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
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
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
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
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
AutoZone, Inc. AZO 8,604.0 51.5 930.0 14,371.6 -1,672.4 15.45 1.67
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
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
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
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
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