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
American Express Company AXP 31,582.0 4,482.0 8.11 23.79 64,751.75 19,499.69 14.45 3.32 2.05
Perrigo Company PRGO 3,173.0 34.5 402.0 2.17 23.76 9,982.8 1,862.14 24.83 5.36 3.15
O'Reilly Automotive, Inc. ORLY 6,182.0 50.1 586.0 2.73 23.65 11,099.52 2,295.18 18.94 4.84 1.8
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
Big Lots, Inc. BIG 5,202.0 39.8 207.0 1.99 23.4 2,660.64 892.86 12.85 2.98 0.51
Abbott Laboratories ABT 39,874.0 62.1 5,963.0 2.52 23.31 104,005.36 26,984.4 17.44 3.85 2.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
Hasbro, Inc. HAS 4,089.0 51.7 336.0 2.87 22.98 4,963.2 1,543.08 14.77 3.22 1.21
Automatic Data Processing, Inc. ADP 10,665.0 41.5 1,389.0 5.04 22.9 26,410.56 6,150.0 19.01 4.29 2.48
Amgen Inc. AMGN 17,265.0 83.1 4,345.0 2.85 22.82 70,625.38 19,832.4 16.25 3.56 4.09
Intel Corporation INTC 53,341.0 62.1 11,005.0 1.65 22.66 103,612.8 53,457.6 9.42 1.94 1.94
F5 Networks, Inc. FFIV 1,377.0 82.9 275.0 1.44 22.6 7,730.4 1,345.6 28.11 5.74 5.61
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
Wal-Mart Stores, Inc. WMT 446,950.0 25.0 15,699.0 2.71 22.45 205,104.96 72,467.64 13.06 2.83 0.46
Genuine Parts Company GPC 13,014.0 29.0 648.0 2.27 22.42 9,929.4 3,020.16 15.32 3.29 0.76
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
Laboratory Corporation of America Holdings LH 5,671.0 39.7 583.0 2.5 22.34 8,218.81 2,818.82 14.1 2.92 1.45
Harman International Industries, Incorporated HAR 4,364.0 27.1 330.0 2.07 22.32 2,886.48 1,562.4 8.75 1.85 0.66
Lennar Corporation LEN 4,105.0 11.0 679.0 3.03 22.23 8,346.09 3,904.77 12.29 2.14 2.03
Reynolds American Inc RAI 8,304.0 48.0 1,272.0 3.15 22.11 24,310.4 5,401.68 19.11 4.5 2.93
Nike, Inc. NKE 24,128.0 43.4 2,223.0 1.49 21.98 101,106.4 11,815.8 45.48 8.56 4.19
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
Medtronic, Inc. MDT 16,184.0 76.0 3,617.0 1.93 21.87 39,612.2 17,490.0 10.95 2.26 2.45
Franklin Resources, Inc. BEN 7,101.0 61.4 1,931.0 1.6 21.79 25,968.9 9,261.92 13.45 2.8 3.66
Internationa Flavors & Fragrances, Inc. IFF 2,821.0 41.7 254.0 2.6 21.6 5,361.16 1,254.6 21.11 4.27 1.9
Flowserve Corporation FLS 4,751.0 33.3 448.0 2.55 21.55 7,573.7 2,081.31 16.91 3.64 1.59
United Technologies Corporation UTX 57,708.0 27.0 5,130.0 3.45 21.47 73,476.07 25,577.4 14.32 2.87 1.27
Owens-Illinois, Inc. OI 7,000.0 19.6 184.0 9.76 21.4 3,323.32 891.42 18.06 3.73 0.47
CSX Corporation CSX 11,756.0 64.1 1,859.0 3.4 21.32 20,727.2 9,162.4 11.15 2.26 1.76
Pall Corporation PLL 2,672.0 51.7 319.0 2.22 21.29 6,187.92 1,559.96 19.4 3.97 2.32