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
Peabody Energy Corporation BTU 8,078.0 26.6 -586.0 3.22 -11.27 7,316.4 4,893.68 1.5 0.91
Frontier Communications Corporation FTR 5,012.0 89.6 137.0 4.32 3.19 4,672.32 4,077.12 34.1 1.15 0.93
PACCAR Inc. PCAR 17,051.0 18.4 1,112.0 3.19 19.83 15,845.56 5,888.24 14.25 2.69 0.93
Omnicom Group Inc. OMC 14,219.0 100.0 998.0 6.4 28.67 13,340.7 3,566.7 13.37 3.74 0.94
Hormel Foods Corporation HRL 8,231.0 16.2 500.0 1.62 18.26 7,809.07 2,883.68 15.62 2.71 0.95
Parker-Hannifin Corporation PH 13,146.0 24.2 1,152.0 2.28 22.41 12,596.85 5,025.1 10.93 2.51 0.96
WPX Energy, Inc. WPX 3,189.0 41.4 -223.0 1.8 -4.07 3,052.66 5,259.57 0.58 0.96
Home Depot, Inc. (The) HD 70,395.0 34.5 3,883.0 2.26 21.11 68,342.1 18,274.8 17.6 3.74 0.97
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
CBRE Group, Inc. CBG 6,514.0 42.5 316.0 5.07 23.46 6,324.18 1,523.82 20.01 4.15 0.97
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
Marriot International MAR 11,814.0 13.4 571.0 11,495.57 -1,333.99 20.13 0.97
PetSmart, Inc PETM 6,113.0 29.5 290.0 2.2 24.97 5,970.18 1,194.72 20.59 5.0 0.98
Robert Half International Inc. RHI 4,111.0 40.1 210.0 1.64 25.56 4,089.38 839.56 19.47 4.87 0.99
Aflac Incorporated AFL 25,364.0 2,866.0 8.2 19.44 25,124.33 16,021.04 8.77 1.57 0.99
Nordstrom, Inc. JWN 10,877.0 39.4 683.0 4.34 34.35 10,760.48 2,053.56 15.75 5.24 0.99
Meadwestvaco Corporation MWV 5,459.0 20.7 205.0 2.65 6.27 5,455.14 3,389.55 26.61 1.61 1.0
Integrys Energy Group TEG 4,212.0 43.8 285.0 3.36 9.24 4,224.13 3,120.5 14.82 1.35 1.0
Patterson Companies, Inc. PDCO 3,536.0 32.9 213.0 1.99 14.5 3,571.98 1,388.61 16.77 2.57 1.01
Exelon Corporation EXC 23,489.0 56.8 1,160.0 3.67 6.48 24,348.87 20,532.33 20.99 1.19 1.04
Leggett & Platt, Incorporated LEG 3,721.0 20.1 248.0 2.27 18.19 3,899.66 1,474.6 15.72 2.64 1.05
CMS Energy Corporation CMS 6,253.0 48.8 382.0 5.36 12.28 6,644.3 3,252.21 17.39 2.04 1.06
Ingersoll-Rand plc (Ireland) IR 14,035.0 30.5 1,019.0 2.59 14.48 14,862.69 7,519.98 14.59 1.98 1.06
Joy Global Inc. JOY 5,661.0 33.2 762.0 2.38 33.65 6,012.33 2,603.31 7.89 2.31 1.06
Ameren Corporation AEE 6,828.0 63.5 -974.0 3.3 -13.4 7,234.11 6,626.61 1.09 1.06
DIRECTV DTV 29,740.0 47.6 2,949.0 32,051.88 -5,957.0 10.87 1.08
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
XL Group plc XL 7,230.0 651.0 4.32 6.53 7,852.3 10,908.9 12.06 0.72 1.09
Entergy Corporation ETR 10,302.0 65.7 868.0 4.7 9.28 11,374.2 9,207.94 13.1 1.24 1.1
Halliburton Company HAL 28,503.0 15.6 2,635.0 1.74 18.2 31,236.48 15,748.16 11.85 1.98 1.1