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
Lincoln National Corporation LNC 11,532.0 1,313.0 14.62 9.01 7,413.12 15,888.96 5.65 0.47 0.64
Marathon Oil Corporation MRO 16,221.0 66.3 1,582.0 1.93 8.93 21,555.6 18,360.6 13.63 1.17 1.33
J.M. Smucker Company (The) SJM 5,526.0 33.4 460.0 1.77 8.79 9,075.03 5,290.66 19.73 1.72 1.64
Beam Inc. BEAM 2,466.0 58.3 382.0 1.87 8.78 9,643.9 4,638.41 25.25 2.08 3.91
KeyCorp KEY 4,231.0 858.0 8.94 8.76 7,685.45 10,165.54 8.96 0.76 1.82
Quanta Services, Inc. PWR 5,920.0 15.8 307.0 1.36 8.58 5,733.96 3,834.0 18.68 1.5 0.97
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
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
HCP, Inc. HCP 1,901.0 85.1 833.0 1.89 8.42 19,418.36 9,963.84 23.31 1.95 10.21
American Electric Power Company, Inc. AEP 14,945.0 64.7 1,259.0 3.57 8.42 21,034.45 15,214.45 16.71 1.38 1.41
Invesco Plc IVZ 4,177.0 100.0 677.0 2.1 8.24 11,281.9 8,757.66 16.66 1.29 2.7
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
AGL Resources, Inc. GAS 3,922.0 54.3 271.0 4.14 8.05 4,695.22 3,417.28 17.33 1.37 1.2
Cincinnati Financial Corporation CINF 4,111.0 421.0 3.03 8.01 6,655.12 5,485.8 15.81 1.21 1.62
Baker Hughes Incorporated BHI 21,361.0 18.7 1,311.0 1.56 7.99 18,698.4 17,071.11 14.26 1.1 0.88
Regions Financial Corporation RF 5,400.0 1,120.0 8.08 7.97 9,306.77 14,743.81 8.31 0.63 1.72
Principal Financial Group Inc PFG 9,215.0 806.0 16.6 7.97 8,319.0 9,960.0 10.32 0.84 0.9
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
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
NiSource, Inc NI 5,061.0 69.5 416.0 3.93 7.89 7,347.0 5,370.0 17.66 1.37 1.45
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
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
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
Comerica Incorporated CMA 2,546.0 521.0 9.42 7.46 5,617.92 7,079.04 10.78 0.79 2.21
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
Crown Castle International Corporation CCI 2,433.0 70.0 189.0 5.47 7.41 19,753.08 2,915.82 6.77 8.12
AT&T Inc. T 127,434.0 56.7 7,264.0 2.95 7.34 196,342.33 96,337.55 27.03 2.04 1.54
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
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
The NASDAQ OMX Group, Inc. NDAQ 3,119.0 53.3 352.0 1.75 6.91 4,062.04 5,440.85 11.54 0.75 1.3