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
Waters Corporation WAT 1,844.0 60.0 461.0 2.16 34.26 7,654.0 1,512.11 16.6 5.06 4.15
Verizon Communications Inc. VZ 115,846.0 60.1 875.0 6.79 2.53 126,013.86 33,199.2 3.8 1.09
PPL Corporation PPL 12,286.0 60.3 1,526.0 4.16 14.32 16,878.0 10,481.82 11.06 1.61 1.37
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
Abercrombie & Fitch Company ANF 4,158.0 60.6 128.0 1.64 6.8 4,046.4 1,957.5 31.61 2.07 0.97
Ventas, Inc. VTR 2,485.0 60.6 363.0 2.1 3.97 19,107.06 9,084.6 52.64 2.1 7.69
BlackRock, Inc. BLK 9,337.0 60.9 2,458.0 7.89 9.74 34,838.16 26,774.76 14.17 1.3 3.73
Avon Products, Inc. AVP 10,717.0 61.1 -43.0 6.07 -3.05 6,229.44 1,218.24 5.11 0.58
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
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
Electronic Arts Inc. EA 4,143.0 61.4 76.0 2.23 3.03 5,799.36 2,493.12 76.31 2.33 1.4
Franklin Resources, Inc. BEN 7,101.0 61.4 1,931.0 1.6 21.79 25,968.9 9,261.92 13.45 2.8 3.66
CenterPoint Energy, Inc (Holding Co) CNP 7,452.0 61.4 417.0 5.32 9.79 8,565.6 4,321.5 20.54 1.98 1.15
Duke Energy Corporation DUK 19,624.0 61.4 1,768.0 2.79 5.56 36,984.0 33,298.25 20.92 1.11 1.88
Equifax, Inc. EFX 2,161.0 61.6 272.0 2.33 14.97 6,666.6 1,975.38 24.51 3.37 3.08
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
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
Mead Johnson Nutrition Company MJN 3,901.0 61.9 605.0 174.24 13,559.88 18.36 22.41 3.48
NYSE Euronext, Inc. NYX 3,749.0 62.0 348.0 1.98 5.38 5,875.0 6,555.0 16.88 0.9 1.57
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
Public Service Enterprise Group Incorporated PEG 9,781.0 62.0 1,275.0 2.94 12.11 15,255.63 10,804.17 11.97 1.41 1.56
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
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
Juniper Networks, Inc. JNPR 4,365.0 62.1 187.0 1.4 2.65 10,141.28 7,243.02 54.23 1.4 2.32
DTE Energy Company DTE 8,791.0 62.5 610.0 3.57 8.48 10,517.8 7,358.16 17.24 1.43 1.2
EMC Corporation EMC 21,714.0 62.8 2,733.0 1.7 13.23 55,194.12 23,405.66 20.2 2.36 2.54
QUALCOMM Incorporated QCOM 19,121.0 62.9 6,109.0 1.28 20.2 106,705.89 34,262.88 17.47 3.11 5.58
Norfolk Souther Corporation NSC 11,040.0 63.4 1,749.0 3.11 17.78 20,176.0 10,101.0 11.54 2.0 1.83
Boston Properties, Inc. BXP 1,876.0 63.5 290.0 3.03 5.81 15,853.49 5,076.62 54.67 3.12 8.45
AvalonBay Communities, Inc. AVB 1,039.0 63.5 424.0 1.63 7.55 13,031.06 5,856.48 30.73 2.23 12.54