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
Honeywell International Inc. HON 37,665.0 24.9 2,926.0 3.23 24.61 48,993.12 13,131.36 16.74 3.73 1.3
Hess Corporation HES 37,691.0 23.8 2,025.0 2.06 10.23 17,006.8 20,995.0 8.4 0.81 0.45
Humana Inc. HUM 39,126.0 1,222.0 2.26 14.45 10,921.0 9,108.44 8.94 1.2 0.28
Abbott Laboratories ABT 39,874.0 62.1 5,963.0 2.52 23.31 104,005.36 26,984.4 17.44 3.85 2.61
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
Walt Disney Company (The) DIS 42,278.0 21.0 5,682.0 1.88 14.73 93,663.36 40,286.88 16.48 2.32 2.22
Schlumberger N.V. SLB 42,321.0 21.9 5,490.0 1.77 16.63 96,408.0 35,028.24 17.56 2.75 2.28
Sysco Corporation SYY 42,381.0 18.1 1,122.0 2.58 23.89 16,963.2 4,712.0 15.12 3.6 0.4
FedEx Corporation FDX 42,680.0 68.9 2,032.0 2.03 13.57 27,468.05 14,727.82 13.52 1.87 0.64
Safeway Inc. SWY 44,207.0 26.5 597.0 5.01 18.05 4,423.08 3,008.58 7.41 1.47 0.1
LyondellBasell Industries NV LYB 45,352.0 12.7 2,848.0 2.17 26.21 31,371.49 11,234.19 11.02 2.79 0.69
Cisco Systems, Inc. CSCO 46,061.0 61.2 8,041.0 1.79 16.32 88,679.64 52,310.72 11.03 1.7 1.93
Lockheed Martin Corporation LMT 47,182.0 8.9 2,745.0 991.21 527.88 30,310.48 39.36 11.04 0.64
Merck & Company, Inc. MRK 47,267.0 65.2 6,168.0 2.0 11.47 136,820.48 53,891.52 22.18 2.54 2.89
Coca-Cola Company (The) KO 48,017.0 60.3 9,019.0 2.63 28.0 172,541.76 33,646.56 19.13 5.13 3.59
Google Inc. GOOG 50,175.0 58.9 10,737.0 1.31 16.54 221,390.66 70,197.59 20.62 3.15 4.41
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
Best Buy Co., Inc. BBY 50,705.0 24.8 -1,231.0 4.27 -23.79 9,179.28 0.18
Intel Corporation INTC 53,341.0 62.1 11,005.0 1.65 22.66 103,612.8 53,457.6 9.42 1.94 1.94
United Parcel Service, Inc. UPS 54,127.0 76.6 807.0 8.35 13.81 71,395.92 4,738.41 88.47 15.07 1.32
Dow Chemical Company (The) DOW 56,786.0 15.8 1,182.0 4.12 4.79 35,997.36 16,499.28 30.45 2.18 0.63
United Technologies Corporation UTX 57,708.0 27.0 5,130.0 3.45 21.47 73,476.07 25,577.4 14.32 2.87 1.27
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
Amazon.com, Inc. AMZN 61,093.0 24.8 -39.0 3.97 -0.49 112,239.81 8,172.12 13.73 1.84
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
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
Dell Inc. DELL 62,071.0 22.3 3,492.0 4.99 41.86 29,314.46 9,190.88 8.39 3.19 0.47
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
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
American International Group, Inc. AIG 65,656.0 3,438.0 5.6 3.39 56,278.32 111,983.06 16.37 0.5 0.86