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
The Charles Schwab Corporation SCHW 4,899.0 928.0 15.32 10.74 17,046.75 8,708.25 18.37 1.96 3.48
Northrop Grumman Corporation NOC 25,218.0 22.1 1,978.0 2.79 19.93 17,214.12 10,061.81 8.7 1.71 0.68
Pacific Gas & Electric Co. PCG 15,040.0 66.6 830.0 4.01 6.48 17,374.0 12,898.75 20.93 1.35 1.16
FirstEnergy Corporation FE 15,303.0 56.2 770.0 3.85 5.84 17,409.45 13,110.51 22.61 1.33 1.14
Intuit Inc. INTU 4,151.0 82.0 792.0 1.71 29.55 17,522.25 2,833.45 22.12 6.18 4.22
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
Equity Residential EQR 2,124.0 64.9 842.0 2.38 13.0 17,628.8 7,126.4 20.94 2.47 8.3
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
Spectra Energy Corp SE 5,075.0 79.6 940.0 3.41 11.03 17,935.04 8,810.08 19.08 2.04 3.53
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
Whole Foods Market, Inc. WFM 11,699.0 35.5 466.0 1.39 13.71 17,991.52 3,788.56 38.61 4.75 1.54
Noble Energy Inc. NBL 4,223.0 74.4 1,027.0 2.13 13.23 18,072.0 8,303.4 17.6 2.18 4.28
Valero Energy Corporation VLO 139,250.0 5.2 2,083.0 2.47 12.09 18,158.96 18,158.96 8.72 1.0 0.13
Alexion Pharmaceuticals, Inc. ALXN 1,134.0 93.6 255.0 1.33 16.41 18,437.35 2,013.88 72.3 9.16 16.26
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
Aon plc AON 11,514.0 100.0 993.0 3.93 12.54 18,781.2 8,315.01 18.91 2.26 1.63
Coach, Inc. COH 4,763.0 72.8 1,039.0 1.56 57.63 18,816.0 2,040.36 18.11 9.22 3.95
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
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
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
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
PPG Industries, Inc. PPG 15,200.0 40.3 941.0 3.91 25.74 19,195.2 4,101.3 20.4 4.68 1.26
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
Raytheon Company RTN 24,414.0 21.8 1,888.0 3.32 23.3 19,341.94 8,172.98 10.24 2.37 0.79
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
Williams Companies, Inc. (The) WMB 7,486.0 39.6 859.0 5.12 26.25 19,512.5 4,362.5 22.72 4.47 2.61
Broadcom Corporation BRCM 8,006.0 49.7 719.0 1.43 10.01 19,578.24 7,937.28 27.23 2.47 2.45
Cummins Inc. CMI 17,334.0 26.0 1,645.0 1.9 27.2 19,615.6 6,610.1 11.92 2.97 1.13
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
Dollar Tree, Inc. DLTR 6,631.0 35.9 488.0 1.73 34.83 20,013.4 1,408.44 41.01 14.21 3.02