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
CVS Corporation CVS 123,133.0 18.3 3,877.0 1.75 10.24 60,467.2 39,206.4 15.6 1.54 0.49
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
Capital One Financial Corporation COF 21,396.0 3,517.0 7.73 9.94 32,257.5 39,023.16 9.17 0.83 1.51
Prudential Financial, Inc. PRU 84,815.0 469.0 18.39 1.24 24,570.0 38,820.6 52.39 0.63 0.29
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
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
U.S. Bancorp USB 20,064.0 5,647.0 10.34 16.41 60,482.4 34,715.76 10.71 1.74 3.01
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
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
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
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
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
Time Warner Inc. TWX 28,729.0 44.5 3,019.0 2.29 10.09 45,510.88 31,290.56 15.07 1.45 1.58
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
Ace Limited ACE 17,936.0 2,706.0 3.36 10.4 27,721.26 27,748.7 10.24 1.0 1.55
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
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
The Travelers Companies, Inc. TRV 25,740.0 2,473.0 4.13 9.92 28,602.6 26,254.8 11.57 1.09 1.11
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
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
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
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
Visa Inc. V 10,421.0 79.5 2,144.0 1.45 7.93 87,245.04 23,092.68 40.69 3.78 8.37
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
Hewlett-Packard Company HPQ 120,357.0 23.2 -12,650.0 4.85 -41.43 27,991.32 22,562.82 1.24 0.23
Corning Incorporated GLW 8,012.0 42.4 1,728.0 1.37 8.12 19,020.78 22,017.72 11.01 0.86 2.37
Hartford Financial Services Group, Inc. (The) HIG 26,412.0 -38.0 13.64 -0.36 9,557.16 21,974.46 0.43 0.36
CME Group Inc. CME 2,915.0 75.5 896.0 1.81 4.17 17,947.92 21,430.6 20.03 0.84 6.16
State Street Corporation STT 9,649.0 2,061.0 10.92 10.28 21,616.14 21,370.83 10.49 1.01 2.24
Express Scripts Holding Company ESRX 93,858.0 7.8 1,313.0 2.49 10.15 40,741.38 21,349.26 31.03 1.91 0.43