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
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
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
Southwest Airlines Company LUV 17,088.0 56.0 421.0 2.66 6.07 7,448.88 7,244.49 17.69 1.03 0.44
Meadwestvaco Corporation MWV 5,459.0 20.7 205.0 2.65 6.27 5,455.14 3,389.55 26.61 1.61 1.0
Bristol-Myers Squibb Company BMY 17,621.0 73.8 1,960.0 2.64 13.25 55,383.28 14,111.68 28.26 3.92 3.14
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
Salesforce.com Inc CRM 2,267.0 78.4 -12.0 2.62 -0.81 14,146.65 1,564.65 9.04 6.24
Air Products and Chemicals, Inc. APD 9,612.0 26.6 1,167.0 2.62 19.02 17,894.45 6,579.0 15.33 2.72 1.86
Family Dollar Stores, Inc. FDO 9,331.0 34.9 422.0 2.6 35.41 7,517.78 1,327.5 17.81 5.66 0.81
Internationa Flavors & Fragrances, Inc. IFF 2,821.0 41.7 254.0 2.6 21.6 5,361.16 1,254.6 21.11 4.27 1.9
Ingersoll-Rand plc (Ireland) IR 14,035.0 30.5 1,019.0 2.59 14.48 14,862.69 7,519.98 14.59 1.98 1.06
UnitedHealth Group Incorporated UNH 110,618.0 9.5 5,526.0 2.59 18.58 56,682.74 32,007.6 10.26 1.77 0.51
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
ConAgra Foods, Inc. CAG 13,263.0 21.3 468.0 2.58 10.24 10,725.88 4,552.02 22.92 2.36 0.81
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
TJX Companies, Inc. (The) TJX 23,191.0 27.3 1,496.0 2.58 47.43 50,743.44 3,328.2 33.92 15.25 2.19
Symantec Corporation SYMC 6,730.0 83.9 1,172.0 2.56 24.36 13,262.04 5,265.92 11.32 2.52 1.97
Flowserve Corporation FLS 4,751.0 33.3 448.0 2.55 21.55 7,573.7 2,081.31 16.91 3.64 1.59
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
Republic Services, Inc. RSG 8,118.0 38.3 572.0 2.55 7.43 10,683.04 7,849.44 18.68 1.36 1.32
Bemis Company, Inc. BMS 5,139.0 18.4 174.0 2.55 10.79 3,465.28 1,653.6 19.92 2.1 0.67
L-3 Communications Holdings, Inc. LLL 13,146.0 10.3 810.0 2.53 13.39 7,511.7 5,920.18 9.27 1.27 0.57
Allegheny Technologies Incorporated ATI 5,032.0 13.8 158.0 2.52 6.39 3,222.18 2,701.53 20.39 1.19 0.64
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
Tesoro Petroleum Corporation TSO 32,974.0 7.4 743.0 2.52 18.77 5,804.96 4,369.34 7.81 1.33 0.18
Linear Technology Corporation LLTC 1,267.0 75.3 398.0 2.51 64.1 6,977.88 748.8 17.53 9.32 5.51
Boston Scientific Corporation BSX 7,249.0 67.6 -4,068.0 2.5 -44.65 8,033.97 7,133.49 1.13 1.11
Laboratory Corporation of America Holdings LH 5,671.0 39.7 583.0 2.5 22.34 8,218.81 2,818.82 14.1 2.92 1.45
Fiserv, Inc. FISV 4,482.0 42.1 611.0 2.49 18.31 11,055.18 3,534.18 18.09 3.13 2.47
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