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
Edison International EIX 11,862.0 65.1 -92.0 4.71 -1.88 14,737.8 9,553.5 1.54 1.24
Macy's Inc M 26,405.0 40.4 1,256.0 3.72 21.91 14,784.88 6,071.68 11.77 2.44 0.56
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
Weyerhaeuser Company WY 7,059.0 17.7 385.0 3.09 9.24 14,877.9 4,065.0 38.64 3.66 2.11
Cigna Corporation CI 29,119.0 1,623.0 5.5 17.92 15,085.05 9,741.3 9.29 1.55 0.52
Public Service Enterprise Group Incorporated PEG 9,781.0 62.0 1,275.0 2.94 12.11 15,255.63 10,804.17 11.97 1.41 1.56
Aetna Inc. AET 36,596.0 27.1 1,658.0 3.99 16.15 15,414.6 10,957.2 9.3 1.41 0.42
TE Connectivity Ltd. TEL 13,282.0 30.5 1,112.0 2.42 14.4 15,462.8 8,109.8 13.91 1.91 1.16
Sherwin-Williams Company (The) SHW 9,534.0 44.1 631.0 3.69 41.42 15,577.12 1,702.48 24.69 9.15 1.63
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
Boston Properties, Inc. BXP 1,876.0 63.5 290.0 3.03 5.81 15,853.49 5,076.62 54.67 3.12 8.45
Waste Management, Inc. WM 13,649.0 34.9 817.0 3.64 13.15 15,929.12 6,352.16 19.5 2.51 1.17
International Paper Company IP 27,833.0 26.0 794.0 5.1 12.29 15,985.2 6,305.2 20.13 2.54 0.57
McGraw-Hill Companies, Inc. (The) MHP 4,450.0 67.2 437.0 9.19 38.42 16,119.6 783.75 36.89 20.57 3.62
NetApp, Inc. NTAP 6,233.0 59.6 605.0 2.22 15.09 16,135.68 4,523.52 26.67 3.57 2.59
AMB Property Corporation PLD 2,006.0 71.6 -40.0 2.19 -0.63 16,182.8 12,438.4 1.3 8.07
Becton, Dickinson and Company BDX 7,708.0 51.3 1,170.0 2.75 26.1 16,230.94 4,332.57 13.87 3.75 2.11
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
Loews Corporation L 14,552.0 568.0 4.11 2.97 16,251.84 19,669.32 28.61 0.83 1.12
Consolidated Edison Inc ED 12,188.0 68.1 1,141.0 3.47 9.68 16,540.65 11,956.35 14.5 1.38 1.36
Adobe Systems Incorporated ADBE 4,404.0 89.0 833.0 1.5 13.38 16,548.7 6,785.47 19.87 2.44 3.76
Hershey Company (The) HSY 6,644.0 43.0 661.0 4.59 70.1 16,598.4 1,055.64 25.11 15.72 2.5
V.F. Corporation VFC 10,880.0 46.5 1,086.0 1.88 22.5 16,648.8 5,209.12 15.33 3.2 1.53
T. Rowe Price Group, Inc. TROW 3,023.0 92.7 884.0 1.09 24.32 16,719.66 3,904.56 18.91 4.28 5.53
PPL Corporation PPL 12,286.0 60.3 1,526.0 4.16 14.32 16,878.0 10,481.82 11.06 1.61 1.37
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
Sysco Corporation SYY 42,381.0 18.1 1,122.0 2.58 23.89 16,963.2 4,712.0 15.12 3.6 0.4
H.J. Heinz Company HNZ 11,649.0 34.3 923.0 4.34 31.47 16,980.11 2,781.03 18.4 6.11 1.46
Sprint Nextel Corporation S 35,345.0 41.0 -4,326.0 7.28 -46.73 16,991.32 7,054.7 2.41 0.48
Hess Corporation HES 37,691.0 23.8 2,025.0 2.06 10.23 17,006.8 20,995.0 8.4 0.81 0.45