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
Molson Coors Brewing Company TAP 3,917.0 39.9 443.0 2.03 5.67 7,898.8 7,987.98 17.83 0.99 2.02
St. Jude Medical, Inc. STJ 5,503.0 72.1 752.0 2.26 17.55 11,110.05 4,362.75 14.77 2.55 2.02
Huntington Bancshares Incorporated HBAN 2,679.0 641.0 10.39 11.67 5,385.12 5,531.83 8.4 0.97 2.01
Forest Laboratories, Inc. FRX 4,586.0 78.2 979.0 1.32 17.52 9,165.3 5,858.12 9.36 1.56 2.0
Mattel, Inc. MAT 6,421.0 53.1 776.0 2.13 27.35 12,826.22 3,100.16 16.53 4.14 2.0
Expedia, Inc. EXPE 4,030.0 77.7 280.0 3.11 12.51 8,079.4 2,359.0 28.86 3.42 2.0
FMC Corporation FMC 3,748.0 35.8 416.0 2.95 30.59 7,469.86 1,494.25 17.96 5.0 1.99
Carnival Corporation CCL 15,382.0 32.9 1,298.0 1.64 5.44 30,505.64 24,024.36 23.5 1.27 1.98
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
Bank Of New York Mellon Corporation (The) BK 14,555.0 2,445.0 10.15 7.06 28,613.62 35,799.42 11.7 0.8 1.97
Viacom Inc. VIAB 13,887.0 49.6 1,981.0 2.99 24.62 27,308.88 7,784.86 13.79 3.51 1.97
Vornado Realty Trust VNO 2,427.0 617.0 3.92 9.62 4,787.2 5,619.35 7.76 0.85 1.97
Philip Morris International Inc PM 77,393.0 27.1 8,800.0 150,706.44 -3,553.2 17.13 1.95
DENTSPLY International Inc. XRAY 2,928.0 53.1 314.0 2.25 15.49 5,702.4 2,234.88 18.16 2.55 1.95
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
Agilent Technologies, Inc. A 6,858.0 52.6 1,153.0 2.03 24.3 13,205.73 5,287.94 11.45 2.5 1.93
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
Mosaic Company (The) MOS 11,108.0 27.8 1,930.0 1.39 16.34 21,369.3 12,305.92 11.07 1.74 1.92
PNC Financial Services Group, Inc. (The) PNC 15,512.0 3,013.0 7.82 7.75 29,560.52 39,077.23 9.81 0.76 1.91
Harley-Davidson, Inc. HOG 5,581.0 38.7 624.0 3.59 25.07 10,685.14 2,589.99 17.12 4.13 1.91
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
Thermo Fisher Scientific Inc TMO 12,510.0 42.3 1,178.0 1.77 7.72 23,774.26 15,876.42 20.18 1.5 1.9
Fossil, Inc. FOSL 2,858.0 56.2 343.0 1.49 29.36 5,399.11 1,262.09 15.74 4.28 1.89
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
Motorola Solutions, Inc. MSI 8,698.0 50.0 881.0 3.88 20.78 16,231.05 3,513.51 18.42 4.62 1.87
Fidelity National Information Services, Inc. FIS 5,808.0 32.0 461.0 2.04 7.02 10,859.12 6,728.84 23.56 1.61 1.87
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
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
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
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