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
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
Ralph Lauren Corporation RL 6,860.0 58.3 681.0 1.48 19.58 16,933.44 3,796.8 24.87 4.46 2.47
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
Vulcan Materials Company VMC 2,567.0 13.0 -53.0 2.16 -1.39 6,771.7 3,768.7 1.8 2.64
Roper Industries, Inc. ROP 2,993.0 55.8 483.0 1.92 14.05 11,223.0 3,740.0 23.24 3.0 3.75
Jacobs Engineering Group Inc. JEC 10,894.0 15.9 379.0 1.84 10.77 5,259.33 3,695.85 13.88 1.42 0.48
IntercontinentalExchange, Inc. ICE 1,363.0 96.6 552.0 10.21 16.31 9,563.0 3,669.71 17.32 2.61 7.02
Intuitive Surgical, Inc. ISRG 2,179.0 72.1 657.0 1.13 21.09 21,600.85 3,651.46 32.88 5.92 9.91
American Tower Corporation (REIT) AMT 2,876.0 74.9 637.0 3.94 18.58 29,972.88 3,606.96 47.05 8.31 10.42
EQT Corporation EQT 1,642.0 71.0 183.0 2.46 5.1 8,659.5 3,601.5 47.32 2.4 5.27
First Solar, Inc. FSLR 3,369.0 25.3 -96.0 1.76 -2.66 2,612.61 3,599.19 0.73 0.78
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
Mylan Inc. MYL 6,796.0 42.8 641.0 3.57 18.76 11,768.4 3,549.0 18.36 3.32 1.73
Fiserv, Inc. FISV 4,482.0 42.1 611.0 2.49 18.31 11,055.18 3,534.18 18.09 3.13 2.47
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
DaVita Inc. DVA 8,186.0 31.9 536.0 4.26 18.16 10,436.02 3,495.66 19.47 2.99 1.27
United States Steel Corporation X 19,328.0 8.8 -124.0 4.38 -3.55 3,146.4 3,470.4 0.91 0.16
Fluor Corporation FLR 27,577.0 3.2 456.0 2.48 13.55 9,663.36 3,457.44 21.19 2.79 0.35
Lam Research Corporation LRCX 2,665.0 40.7 169.0 1.56 4.44 4,702.5 3,436.25 27.83 1.37 1.76
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
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
Altera Corporation ALTR 1,783.0 69.6 557.0 1.4 17.6 10,400.4 3,379.32 18.67 3.08 5.83
MetroPCS Communications, Inc. PCS 5,101.0 42.6 394.0 3.03 12.54 3,737.6 3,372.6 9.49 1.11 0.73
KLA-Tencor Corporation KLAC 3,172.0 58.1 756.0 1.54 24.48 8,046.1 3,369.4 10.64 2.39 2.54
TJX Companies, Inc. (The) TJX 23,191.0 27.3 1,496.0 2.58 47.43 50,743.44 3,328.2 33.92 15.25 2.19
QEP Resources, Inc. QEP 2,350.0 49.8 128.0 2.79 3.91 5,305.56 3,277.49 41.45 1.62 2.26
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
Textron Inc. TXT 12,237.0 18.1 589.0 4.36 20.54 7,136.05 3,250.9 12.12 2.2 0.58
BorgWarner Inc. BWA 7,183.0 20.4 501.0 2.08 18.31 8,173.55 3,227.07 16.31 2.53 1.14
Starwood Hotels & Resorts Worldwide, Inc. HOT 6,321.0 24.1 562.0 2.82 18.45 10,671.49 3,199.28 18.99 3.34 1.69