Do you have Analytic solver or R in exel?

profileDIV708
stocks.xlsx
Home>Business & Finance homework help>Accounting homework help>Do you have Analytic solver or R in exel?

Sheet1

Name Price Dividend PE EPS Book Value 52 week low 52 week high Market Cap EBITDA
3M Company 189.09 2.48 23.17 8.16 17.26 158.28 190.54 112.74 8.7
Abbott Laboratories 45 2.34 48.03 0.94 13.94 36.76 45.83 77.76 4.59
AbbVie 63.69 4.04 17.55 3.63 2.91 54.41 68.12 101.52 10.95
Accenture plc 124.14 1.96 18.37 6.76 11.95 102.1 125.72 77.29 5.66
Activision Blizzard 48.06 0.64 37.55 1.28 12.23 30.37 48.36 36.13 2.14
Acuity Brands Inc 205.41 0.25 29.68 6.92 39.5 193.06 280.89 9 0.5862
Advance Auto Parts 151.99 0.15 24.51 6.2 39.66 132.98 177.83 11.18 1.12
Aetna Inc 130.59 1.53 20.37 6.41 50.84 104.59 136.5 45.93 6.2
Affiliated Managers Group Inc 166.56 0.47 19.44 8.57 63.84 130.48 179.85 9.44 0.835
AFLAC Inc 71.95 2.38 11.21 6.42 50.47 59.66 74.5 28.88 4.78
Agilent Technologies Inc 51.21 1.02 32.85 1.56 13.35 37.62 52.26 16.49 0.942
Air Products & Chemicals Inc 139.64 2.72 53.77 2.6 32.91 123.05 150.45 30.38 3.13
Alaska Air Group Inc 95.12 1.21 14.54 6.54 23.77 54.51 101.43 11.74 1.82
Albemarle Corp 103.79 1.22 18.26 5.68 33.73 58.6 105.2 11.68 0.70201
Allegion 72.86 0.87 30.87 2.36 1.19 61.47 75 6.96 0.4789
Allergan, Plc 239.6 1.14 6.28 38.18 212.79 184.5 299.11 80.32 6.1
Alliance Data Systems 245.05 0.85 33.39 7.34 28.89 185.02 249.22 13.7 1.46
Alliant Energy Corp 39.28 3.22 24.01 1.64 16.96 34.04 40.99 8.94 1.03
Allstate Corp 81.46 1.66 17.44 4.67 51.44 63.73 83.05 29.74 3.46
Altria Group Inc 76.1 3.23 10.45 7.28 6.58 59.48 76.3 147.64 9.5
Ameren Corp 54.82 3.21 20.46 2.68 29.28 46.29 55.51 13.3 2.3
American Airlines Group 44.84 0.85 9.32 4.81 7.46 24.85 50.64 22.61 7.83
American Electric Power 66.24 3.55 53.29 1.24 35.38 57.89 71.32 32.57 5.29
American Express Co 79.58 1.6 14.08 5.65 22.68 57.15 82 71.72 0
American Tower Corp A 114.7 2.01 57.93 1.98 15.84 93.69 118.26 49 3.46
American Water Works Company Inc 76.89 1.94 29.35 2.62 29.3 66.63 85.24 13.7 1.62
Ameriprise Financial 132.18 2.25 16.92 7.81 40.66 84.92 135.2 20.36 2.77
AmerisourceBergen Corp 88.48 1.58 14.78 5.99 9.75 68.38 94.5 19.22 2.16
AMETEK Inc 54.51 0.66 24.89 2.19 14.2 43.28 55.48 12.51 1.01
Amgen Inc 177.38 2.55 17.32 10.24 40.47 133.64 180.53 130.63 12
Amphenol Corp 70.27 0.91 26.92 2.61 11.92 54.87 71 21.62 1.46
Analog Devices, Inc. 83.41 2.16 28.45 2.93 17.16 52.17 84.24 25.79 1.37
Anthem Inc. 166.01 1.57 18.02 9.21 95.17 114.85 169.2 43.89 5.78
Aon plc 115.54 1.13 22.39 5.16 20.9 97.62 117.89 30.34 2.39
Apartment Investment & Mgmt 45.43 3.17 17.01 2.67 10.64 38.05 47.91 7.13 0.57096
Apple Inc. 139.52 1.63 16.75 8.33 25.19 89.47 140.28 732 69.75
Applied Materials Inc 36.97 1.08 19.02 1.94 7.12 18.94 37.26 39.92 2.99
Archer-Daniels-Midland Co 44.46 2.83 20.58 2.16 29.97 34.55 47.88 25.39 2.54
Arthur J. Gallagher & Co. 56.32 2.74 24.28 2.32 20.17 40.76 57.82 10.06 0.8688
Assurant Inc 99.6 2.12 10.91 9.13 73.26 75.2 101.32 5.54 1.04
AT&T Inc 41.88 4.67 19.95 2.1 20.06 36.1 43.89 257.21 49.74
Automatic Data Processing 104.27 2.18 28.01 3.72 8.5 84.36 105 46.81 2.73
AvalonBay Communities, Inc. 183.05 3.14 24.34 7.52 74.07 158.32 192.29 25.14 1.32
Avery Dennison Corp 80.4 2.01 22.71 3.54 10.48 68.06 82.11 7.09 0.7403
Ball Corp 72.28 0.7 52 1.39 20.04 66.41 82.24 12.63 1.28
Bank of America Corp 25.21 1.18 16.84 1.5 24.04 12.05 25.8 265.12 0
Bard (C.R.) Inc. 245.69 0.42 34.95 7.03 22.98 191.79 248.19 17.7 1.15
Baxter International Inc. 51.04 1.02 5.67 9.01 15.36 38.99 51.4 27.57 1.97
BB&T Corporation 47.93 2.47 17.3 2.77 33.14 32.22 49.88 38.75 0
Becton Dickinson 183.94 1.58 30.62 6.01 35.63 145.78 186.11 39.15 3.26
Bed Bath & Beyond 39.01 1.24 8.28 4.71 17.82 38.58 52.33 5.73 1.5
Best Buy Co. Inc. 44.55 2.64 11.71 3.81 15.03 28.76 49.4 13.96 2.6
BlackRock 385.35 2.56 20.24 19.04 178.38 317.6 399.46 62.86 4.88
Boeing Company 182.02 3.12 23.92 7.61 1.32 121.43 185.71 111.48 8.68
BorgWarner 41.69 1.3 75.8 0.55 15.16 27.52 43.43 8.87 0.8076
Boston Properties 135.66 2.21 41.61 3.26 36.32 113.69 144.02 20.87 1.53
Bristol-Myers Squibb 56.33 2.72 21.26 2.65 9.68 46.01 77.12 94.22 6.7
C. H. Robinson Worldwide 78.94 2.26 21.99 3.59 8.9 65.57 81.16 11.15 0.9008
CA, Inc. 31.97 3.14 16.95 1.89 13.49 29.12 34.99 13.36 1.28
Campbell Soup 59.09 2.35 36.82 1.61 4.83 52.58 67.89 18.08 1.57
Capital One Financial 92.82 1.7 13.47 6.89 98.96 58.03 96.92 44.57 0
Cardinal Health Inc. 81.21 2.17 19.55 4.15 17.91 62.7 87.85 25.62 3.07
Carnival Corp. 55.53 2.51 14.93 3.72 31.12 42.94 57.79 40.31 4.76
CBOE Holdings 77.97 1.28 34.35 2.27 3.91 61.22 81.36 6.34 0.35726
CBS Corp. 67.94 1.06 24.18 2.81 8.95 48.88 68.59 27.82 3.1
CenterPoint Energy 28 3.84 28 1 8.03 19.83 28.08 12.06 2.09
CenturyLink Inc 22.5 9.2 19.4 1.16 24.52 22.37 33.45 12.3 6.49
Charles Schwab Corporation 41.66 0.75 31.8 1.31 10.23 23.83 43.36 55.61 0
Chubb Limited 137.41 1.99 15.49 8.87 103.6 115.5 140.55 64 5.69
Church & Dwight 49.55 1.45 28.31 1.75 7.79 42.56 53.68 12.62 0.8367
CIGNA Corp. 151.84 0.03 21.12 7.19 53.42 115.03 154.24 39.03 3.85
Cincinnati Financial 73.17 2.7 20.61 3.55 42.95 63.57 79.6 12.05 0.913
Cintas Corporation 118.27 0.89 24.65 4.8 19.29 85.86 122.21 12.42 0.98328
Cisco Systems 34.2 3.38 17.63 1.94 12.74 25.81 34.53 171.27 14.67
Citigroup Inc. 60.5 1.05 12.82 4.72 74.26 38.31 61.94 167.63 0
Citizens Financial Group 37.97 1.46 19.27 1.97 38.09 18.34 39.75 19.33 0
CME Group Inc. 123.56 2.13 27.28 4.53 60.14 89 127.6 41.97 2.45
CMS Energy 44.44 3 22.44 1.98 15.23 38.78 46.25 12.42 2
Coach Inc. 37.82 3.55 20.76 1.82 10.02 34.07 43.71 10.61 0.8989
Coca Cola Company 41.99 3.48 28.18 1.49 5.38 39.88 47.13 180.28 11.53
Comcast Corp. 37.42 1.69 20.96 1.78 11.38 29.03 38.44 177.45 26.48
Comerica Inc. 72.63 1.25 27.1 2.68 44.47 35.58 75 12.77 0
ConAgra Foods Inc. 40.75 1.94 28.74 1.42 10.22 33.61 48.86 17.73 1.83
Consolidated Edison 76.64 3.6 18.6 4.12 46.88 68.76 81.88 23.38 3.69
Constellation Brands 157.21 1.01 24.33 6.46 35.26 139.11 173.55 30.82 2.4
Corning Inc. 27.72 2.22 8.58 3.23 16.84 18.21 28.36 25.73 2.56
Costco Co. 167 1.06 30.81 5.42 28.34 138.57 178.71 73.3 5.03
Crown Castle International Corp. 91.5 4.14 96.32 0.95 20.96 79.38 102.82 32.99 2.07
CSRA Inc. 28.5 1.34 24.05 1.18 1.87 21.95 33.54 4.65 0.74557
CSX Corp. 48.44 1.46 26.78 1.81 12.58 24.36 50.31 44.88 4.69
Cummins Inc. 152.1 2.7 18.48 8.23 41.04 100.43 154.67 25.48 2.31
CVS Health 80.81 2.47 16.46 4.91 34.71 69.3 106.67 85.74 13.05
D. R. Horton 32.85 1.23 13.2 2.49 18.7 26.69 34.56 12.27 1.52
Danaher Corp. 86.07 0.64 23.57 3.65 33.23 75.71 102.79 59.67 4.12
Darden Restaurants 74.51 2.98 21.82 3.41 14.93 59.5 79.43 9.25 0.9302
Deere & Co. 110.24 2.17 23.88 4.62 21.44 74.91 112.18 35.09 3.89
Delphi Automotive 75.97 1.5 16.55 4.59 8.9 58.04 78.12 20.48 2.98
Delta Air Lines 47.64 1.62 8.23 5.79 16.88 32.6 52.76 34.68 8.24
Dentsply Sirona 62.55 0.55 32.24 1.94 35.26 55 65.83 14.37 0.7795
Digital Realty Trust 107.48 3.43 48.85 2.2 25.68 83.4 113.21 17.12 1.17
Discover Financial Services 70.98 1.68 12.3 5.77 27.68 47.5 74.33 27.37 0
Dollar General 71.36 1.37 16.74 4.26 19.41 66.5 96.88 19.71 2.37
Dominion Resources 76.12 3.94 22.13 3.44 23.26 68.71 78.97 47.81 5.8
Dover Corp. 79.39 2.19 24.43 3.25 24.45 58.91 82.56 12.35 1.12
Dow Chemical 63.15 2.91 17.94 3.52 21.46 47.51 64.36 76.62 8.69
Dr Pepper Snapple Group 94.23 2.44 20.76 4.54 11.65 81.05 98.8 17.25 1.65
DTE Energy Co. 101.55 3.26 21.02 4.83 50.22 84.77 102.1 18.22 2.24
Du Pont (E.I.) 79.39 1.91 27.81 2.86 11.31 61.12 80.66 68.64 5.07
Duke Energy 81.69 4.18 26.18 3.12 58.62 72.34 87.75 57.15 10.03
E*Trade 35.07 0 17.71 1.98 21.41 21.52 38.61 9.63 0
Eastman Chemical 78.92 2.54 13.73 5.75 30.94 62.7 82.1 11.56 2.11
Eaton Corporation 71.54 3.34 16.99 4.21 33.15 54.3 73.86 32.17 3.19
Ecolab Inc. 124.72 1.18 30.13 4.14 23.65 102.38 126.17 36.38 2.87
Edison Int'l 79.25 2.73 19.93 3.98 36.82 67.44 80.61 25.82 3.96
Emerson Electric Company 60.22 3.18 24.43 2.46 12 48.45 64.36 38.85 3.11
Equifax Inc. 131.37 1.17 32.52 4.04 22.21 105.52 136.97 15.75 1.12
Equinix 375.24 1.93 209.05 1.79 61.14 299.29 391.07 26.88 1.5
Equity Residential 62.55 3.23 5.36 11.68 27.86 58.28 75.49 22.96 1.57
Essex Property Trust, Inc. 233.7 3.04 37.27 6.27 94.5 200.01 237.5 15.32 0.89818
Estee Lauder Cos. 82.77 1.64 28.6 2.89 10.36 75.29 97.48 30.33 2.2
Eversource Energy 58.56 3.26 19.78 2.96 33.8 50.56 60.44 18.56 2.55
Exelon Corp. 36.13 3.61 29.61 1.22 27.96 29.82 37.7 33.48 9.13
Expedia Inc. 122.39 0.93 67.25 1.82 27.54 96.58 133.55 18.34 1.07
Expeditors Int'l 56.05 1.42 23.75 2.36 10.26 46.42 57.35 10.1 0.71696
Express Scripts 67.39 0 12.5 5.39 26.81 64.46 80.02 40.82 7.1
Extra Space Storage 78.99 3.95 27.17 2.91 17.88 68.09 94.81 9.92 0.64929
Exxon Mobil Corp. 82.52 3.64 43.96 1.88 40.34 80.76 95.55 342.17 23.24
Fastenal Co 51.37 2.47 29.71 1.73 6.68 37.7 52.64 14.86 0.89936
Federal Realty Investment Trust 133.39 2.9 38.11 3.5 27.32 132.91 171.08 9.62 0.51283
FedEx Corporation 192.91 0.82 28.35 6.8 54.52 139.58 201.57 51.41 7.86
Fidelity National Information Services 82.64 1.4 47.96 1.72 29.7 59.11 83.86 27.17 2.27
Fifth Third Bancorp 27.37 2.01 14.18 1.93 19.82 16.02 28.97 20.55 0
FLIR Systems 36.5 1.65 30.42 1.2 12.31 28.26 37.44 4.98 0.35466
Flowserve Corporation 46 1.63 41.44 1.11 12.7 39.13 52.5 6 0.47792
Fluor Corp. 55.08 1.51 27.54 2 22.44 44.05 58.37 7.68 0.88816
FMC Corporation 59.09 1.11 37.95 1.56 14.64 36.72 62.84 7.9 0.7144
FMC Technologies Inc. 31.9 3.43 12.92 2.47 43.01 30.61 36.14 3.76 1.16
Foot Locker Inc 75.72 1.62 15.42 4.91 20.33 50.9 79.43 10.09 1.16
Ford Motor 12.46 4.74 10.83 1.15 7.34 11.07 14.22 49.52 13.3
Fortive Corp 58.2 0.48 23.19 2.51 7.77 43 59.24 20.13 1.44
Fortune Brands Home & Security 57.92 1.23 22.15 2.62 15.39 50.39 64.47 8.87 0.7747
Franklin Resources 42.38 1.87 14.28 2.97 21.15 30.56 44.1 23.96 2.32
Gap (The) 24.18 3.73 14.31 1.69 7.28 17 30.74 9.65 1.92
Garmin Ltd. 51.51 3.96 19.08 2.7 18.13 38.4 56.19 9.71 0.71025
General Dynamics 191.47 1.77 20.1 9.52 36.43 127.74 193.17 57.69 4.76
General Electric 29.86 3.19 33.44 0.89 8.67 28.19 33 260.52 17.14
General Growth Properties Inc. 23.92 3.61 17.85 1.34 9.5 23.7 32.1 21.14 1.86
General Mills 60.25 3.16 22.5 2.68 7.2 58.7 72.95 34.95 3.38
General Motors 37.52 3.98 6.25 6 29.22 27.34 38.55 56.2 19.68
Genuine Parts 93.52 2.85 20.37 4.59 21.52 86.61 105.97 13.88 1.22
Gilead Sciences 69.02 2.94 6.94 9.94 14.42 65.38 103.1 90.21 19.22
Global Payments Inc 80.89 0.05 58.24 1.39 17.29 58.11 81.56 12.31 0.98935
Goldman Sachs Group 250.9 1.03 15.4 16.29 182.46 138.2 255.15 104.08 0
Goodyear Tire & Rubber 35.27 0.95 7.44 4.74 17.91 24.31 36.61 8.88 2.51
Grainger (W.W.) Inc. 250.59 1.95 25.39 9.87 30.58 201.94 262.71 14.74 1.46
Hanesbrands Inc 19.98 2.92 14.21 1.41 3.23 18.91 30.42 7.57 1.01
Harley-Davidson 57.78 2.48 15.09 3.83 11 41.63 62.35 10.09 1.28
Harman Int'l Industries 111.43 1.25 22.04 5.06 36.87 64.93 111.85 7.79 0.86035
Harris Corporation 109.73 1.92 20.77 5.28 25.4 73.32 111.67 13.66 1.58
Hartford Financial Svc.Gp. 48.66 1.87 21.44 2.27 45.2 38.92 50.13 18.01 1.48
Hasbro Inc. 97.2 2.33 22.4 4.34 14.96 76.14 99.33 12.08 0.97538
HCP Inc. 31.3 4.6 23.38 1.34 11.85 27.61 40.43 14.65 1.28
Hewlett Packard Enterprise 22.82 1.04 12.38 1.84 18.94 15.3 24.88 37.95 7.8
Home Depot 146.02 2.41 22.64 6.45 3.59 119.2 148.26 176.1 15.4
Honeywell Int'l Inc. 126.26 2.11 20.36 6.2 25.46 105.25 127.41 96.11 7.71
Hormel Foods Corp. 34.85 1.92 21.12 1.65 8.66 33.18 44.73 18.42 1.41
Host Hotels & Resorts 18.18 4.35 17.82 1.02 9.48 14.3 20.21 13.44 1.42
Humana Inc. 217.95 0.75 53.55 4.07 71.57 150 218.93 32.55 2.06
Huntington Bancshares 14.24 2.22 20.34 0.7 8.51 8.05 14.74 15.46 0
Illinois Tool Works 133.9 1.94 23.49 5.7 12.26 96.13 135.24 46.4 3.53
Ingersoll-Rand PLC 79.59 2 14.1 5.65 25.65 56.73 82.17 20.65 1.92
Intel Corp. 35.8 2.9 16.89 2.12 14 29.5 38.45 169.26 22.87
Intercontinental Exchange 58.63 1.36 24.74 2.37 26.42 45.44 60.54 6.75 2.75
International Business Machines 180.38 3.11 14.57 12.38 19.29 138.09 182.79 170.14 18.55
International Paper 51.48 3.43 23.64 2.18 10.56 37.88 58.86 21.17 2.87
Interpublic Group 24.2 2.97 16.24 1.49 5.15 20.82 25.33 9.5 1.1
Intl Flavors & Fragrances 123.89 2.05 24.53 5.05 20.53 106.11 143.64 9.79 0.67298
Intuit Inc. 125.4 1.08 33.67 3.72 3.07 96.85 128.45 32.08 1.41
Invesco Ltd. 31.96 3.46 15.51 2.06 18.58 23.01 33.46 12.91 1.33
Iron Mountain Incorporated 35.79 6.05 84.41 0.42 7.34 30.32 41.5 9.44 1.11
J. B. Hunt Transport Services 96.6 0.94 25.35 3.81 12.7 75.71 102.38 10.75 1.08
Jacobs Engineering Group 56.51 1.06 30.55 1.85 33.59 39.88 63.42 6.84 0.64212
JM Smucker 139.17 2.14 24.23 5.74 62.19 122.05 157.31 16.21 1.66
Johnson & Johnson 123.83 2.59 20.88 5.93 26.02 106.07 126.07 335.99 24.96
JPMorgan Chase & Co. 91.41 2.07 14.77 6.19 64.07 57.05 93.98 325.49 0
Juniper Networks 28.15 1.41 18.4 1.53 13.02 21.17 29.21 10.75 1.11
Kansas City Southern 89 1.47 20.09 4.43 38.31 79.05 100.69 9.49 1.12
Kellogg Co. 74.14 2.79 37.83 1.96 5.44 70.74 87.16 26.03 2.25
KeyCorp 18.79 1.78 23.46 0.8 12.58 10.21 19.53 20.15 0
Kimco Realty 22.75 4.62 28.8 0.79 12.37 22.73 32.24 9.68 0.76614
Kinder Morgan 21.63 2.3 87.93 0.25 15.44 16.63 23.36 48.29 6.16
KLA-Tencor Corp. 91.04 2.39 16.55 5.5 6.16 66.88 91.65 14.27 1.25
Kohl's Corp. 39.51 4.96 12.7 3.11 29.75 33.87 59.67 6.87 2.31
Kraft Heinz Co 90.8 2.62 32.31 2.81 47.15 75.55 97.77 110.52 8.57
Kroger Co. 28.81 1.62 14.05 2.05 7.26 28.71 39.22 26.62 5.78
L-3 Communications Holdings 169.07 1.79 18.77 9.01 58.95 115.75 171.24 13.15 1.23
Lam Research 117.43 1.52 21.05 5.58 39.39 72 119.91 19.12 1.62
Leggett & Platt 48.83 2.75 17.72 2.76 8.18 44.02 54.62 6.63 0.5892
Lennar Corp. 50.71 0.32 12.89 3.93 29.97 39.68 50.81 11.89 1.34
Leucadia National Corp. 26.66 0.94 79.11 0.34 28.18 14.31 27.33 9.59 1.25
Lilly (Eli) & Co. 82.74 2.48 32.07 2.58 13.33 64.18 84.28 86.95 5.37
Lincoln National 69.25 1.63 13.77 5.03 63.97 35.27 73.31 15.6 1.8
Linear Technology Corp. 65.33 2.04 32.02 2.04 7.81 42.65 65.76 15.73 0.72598
Lockheed Martin Corp. 269.04 2.72 15.38 17.49 5.23 214.81 270 77.75 6.11
Loews Corp. 47.45 0.52 24.59 1.93 53.96 36.05 48.05 15.97 2.94
Lowe's Cos. 80.84 1.71 23.3 3.47 7.43 64.87 83.65 70.01 7.44
LyondellBasell 91.23 3.69 10 9.13 14.97 69.82 97.64 36.72 6.07
M&T Bank Corp. 166.73 1.7 21.44 7.78 97.66 106.05 173.72 25.71 0
Macerich 65.27 4.27 18.54 3.52 28.52 64.55 94.51 9.39 0.64491
Macy's Inc. 30.81 4.75 15.48 1.99 14.22 28.55 45.5 9.37 2.9
Marathon Petroleum 50.15 2.81 22.69 2.21 25.68 32.02 54.59 26.47 4.66
Marriott Int'l. 86.15 1.38 32.63 2.64 13.88 60.87 91.07 33.04 2
Marsh & McLennan 73.62 1.83 21.78 3.38 12.03 57.11 74.76 37.91 3.1
Martin Marietta Materials 209.93 0.77 31.66 6.63 65.53 150.75 243.98 13.24 0.95467
Mastercard Inc. 110.96 0.79 30.07 3.69 5.23 85.93 112.92 119.61 6.25
Mattel Inc. 25.02 5.97 27.2 0.92 7.03 25 34.76 8.57 0.82347
McCormick & Co. 99 1.89 26.83 3.69 12.98 88.64 107.84 12.39 0.7541
McKesson Corp. 147.24 0.73 17.47 8.43 36.27 114.53 199.43 31.22 4.62
Medtronic plc 81.4 2.1 28.73 2.83 35.99 69.35 89.27 111.7 8.89
Merck & Co. 65.96 2.82 46.78 1.41 14.58 51.33 66.8 181.1 12
MetLife Inc. 53.35 2.92 84.68 0.63 61.44 36.17 58.09 58.01 1.57
Microchip Technology 73.84 1.97 179.66 0.41 11.86 45.9 76.5 15.98 0.9251
Microsoft Corp. 64.4 2.43 30.31 2.12 8.9 48.03 65.91 497.65 27.74
Mid-America Apartments 100.78 3.44 37.48 2.69 56.41 85.04 110.01 11.44 0.63626
Molson Coors Brewing Company 96.99 1.64 10.48 9.26 53.13 88.24 112.19 20.85 0.851
Mondelez International 43.23 1.74 41.17 1.05 16.46 39.21 46.4 66 4.24
Monsanto Co. 115.06 1.88 31.55 3.65 10.04 83.73 116.04 50.46 4.01
Morgan Stanley 46.33 1.71 15.86 2.92 36.99 23.11 47.17 86.46 0
Mylan N.V. 43.33 0 47.1 0.92 20.76 33.6 50.4 23.2 3.53
NASDAQ OMX Group 70.93 1.8 110.83 0.64 32.6 61.19 72.52 11.83 1.16
Navient 14.54 4.29 6.86 2.12 12.72 11.01 17.95 4.23 0
NetApp 42.66 1.78 38.96 1.1 9.94 22.5 43.14 11.56 0.768
Newell Brands 48.53 1.54 38.89 1.25 23.52 38.82 55.45 23.41 2.39
NextEra Energy 130.65 3 20.9 6.25 52.01 110.49 131.98 61.09 7.67
Nielsen Holdings 44.5 2.77 32.01 1.39 11.48 40.28 55.94 15.91 1.62
Nike 56.55 1.27 24.93 2.27 7.44 49.01 65.44 93.56 5.18
NiSource Inc. 23.5 2.95 23.02 1.02 12.6 21.17 26.94 7.6 1.36
Nordstrom 44.03 3.19 21.8 2.02 5.12 35.01 62.82 7.49 1.65
Norfolk Southern Corp. 122 1.99 21.7 5.62 42.73 74.7 125 35.45 4.1
Northern Trust Corp. 88.39 1.71 20.46 4.32 38.88 61.32 91.14 20.22 0
Northrop Grumman Corp. 243.78 1.48 20 12.19 30.04 186.41 253.8 42.56 3.65
Nucor Corp. 60.93 2.41 24.55 2.48 24.72 43.28 68 19.43 2.15
Nvidia Corporation 98.74 0.57 38.42 2.57 9.85 31.04 120.92 58.16 2.13
Omnicom Group 84.09 2.58 17.59 4.78 9.21 75.61 89.66 19.72 2.3
ONEOK 56.58 4.36 34.08 1.66 0.9 25.61 59.47 11.92 1.67
Oracle Corp. 42.6 1.41 20.33 2.1 11.81 37.51 43.26 174.76 14.6
PACCAR Inc. 67.57 1.4 45.66 1.48 19.33 48.17 70.12 23.71 2.43
Parker-Hannifin 157.49 1.68 24.3 6.48 33.97 99.1 159.05 20.99 1.6
Patterson Companies 44.15 2.13 24.23 1.82 14.63 36.46 50.4 4.18 0.39844
Paychex Inc. 62.16 2.94 28.91 2.15 5.06 51.06 63.01 22.31 1.31
Pentair Ltd. 58.9 2.33 20.62 2.86 23.41 48.87 66.99 10.71 0.9195
People's United Financial 19.09 3.51 20.8 0.92 15.85 13.8 20.13 5.9 0
PepsiCo Inc. 109.32 2.72 25.08 4.36 7.88 98.5 110.94 156.02 12.11
PerkinElmer 54.08 0.51 25.4 2.13 19.65 45.35 57.28 5.94 0.40594
Pfizer Inc. 33.99 3.71 28.98 1.17 9.81 28.74 37.39 202.3 19.81
PG&E Corp. 66.26 2.97 23.83 2.78 35.39 56.39 66.93 33.65 5.16
Phillips 66 77.48 3.22 26.5 2.92 43.16 73.67 90.87 40.12 2.24
Pinnacle West Capital 82.54 3.16 20.9 3.95 43.15 69.8 83.77 9.19 1.42
PNC Financial Services 127.4 1.72 17.45 7.3 94.22 77.4 131.83 61.94 0
Polo Ralph Lauren Corp. 79.14 2.51 45.25 1.75 43.92 75.62 114 6.51 1.01
PPG Industries 100.78 1.57 30.72 3.28 18.75 89.64 117 25.91 2.56
PPL Corp. 36.79 4.31 13.19 2.79 14.56 32.08 39.92 25.04 4.05
Praxair Inc. 118.79 2.68 22.8 5.21 17.62 105.92 125 33.86 3.44
Principal Financial Group 63.04 2.83 14.01 4.5 35.55 37.69 64.31 18.12 1.95
Procter & Gamble 90.29 2.96 16.54 5.46 20.35 79.1 91.89 230.82 17.77
Progressive Corp. 39.32 1.71 22.34 1.76 13.72 30.54 39.94 22.84 1.81
Prologis 50.55 3.44 22.28 2.27 28.21 40.88 54.87 26.76 1.81
Prudential Financial 111.24 2.67 11.46 9.71 106.76 66.51 114.55 47.83 7.5
Public Serv. Enterprise Inc. 44.98 3.78 25.7 1.75 26.01 39.28 47.41 22.77 3.37
Public Storage 228.01 3.53 33.48 6.81 29.11 200.65 277.6 39.59 1.86
Pulte Homes Inc. 22.79 1.6 13.04 1.75 14.6 16.6 22.94 7.24 1.03
PVH Corp. 89.75 0.17 12.56 7.15 60.33 82.1 115.4 7.11 1.07
QUALCOMM Inc. 56.73 3.76 17.3 3.28 21.12 49.67 71.62 83.79 8.55
Quest Diagnostics 98.17 1.83 21.77 4.51 33.78 67.36 98.75 13.5 1.41
Raytheon Co. 154.48 1.91 20.76 7.44 34.38 120.24 156.4 45.24 3.69
Realty Income Corporation 59.84 4.19 52.96 1.13 24.49 52.72 72.29 15.57 0.99764
Regency Centers Corporation 65.72 2.95 46.28 1.42 21.76 65.16 85.35 6.84 0.40428
Regions Financial Corp. 15.25 1.69 17.45 0.87 13.05 7.53 16.03 18.38 0
Republic Services Inc 62.08 2.06 34.88 1.78 22.66 45.56 62.39 21.05 2.65
Reynolds American Inc. 61.18 3.32 14.4 4.25 15.23 43.38 61.96 87.24 6.03
Robert Half International 47.53 2.02 17.8 2.67 8.5 34.34 50.98 6.07 0.61754
Rockwell Automation Inc. 153.58 1.99 26.44 5.81 15.94 104.48 156.11 19.75 1.19
Rockwell Collins 97.47 1.36 17.42 5.59 16.85 78.54 98.12 12.75 1.22
Roper Industries 211.75 0.66 32.93 6.43 56.94 159.28 213.39 21.57 1.3
Ross Stores 66.87 0.95 23.63 2.83 7.08 52 69.81 25.96 2.11
Royal Caribbean Cruises Ltd 94.54 2.01 15.94 5.93 42.51 64.95 97.67 20.31 2.38
Ryder System 76.07 2.29 15.51 4.9 38.39 56.98 85.42 4.07 1.81
S&P Global, Inc. 130.69 1.27 16.46 7.94 2.52 92.03 131.26 33.77 2.47
SCANA Corp 69.81 3.48 16.78 4.16 40.06 64.5 76.41 9.98 1.6
Scripps Networks Interactive Inc. 78.34 1.53 15.12 5.18 14.69 58.73 83.42 10.14 1.52
Seagate Technology 48.28 5.15 28.17 1.71 5.16 18.42 49.79 14.25 1.71
Sealed Air 44.41 1.38 18.05 2.46 3.15 42.01 52.83 8.59 1.04
Sempra Energy 110.58 3.01 20.25 5.46 51.77 92.95 114.66 27.71 2.94
Sherwin-Williams 310.58 1.09 25.9 11.99 20.3 239.48 316.66 28.74 1.98
Signet Jewelers 63.25 1.61 9.47 6.68 32.06 62.1 125.45 4.4 0.9051
Simon Property Group Inc 177.29 3.9 30.2 5.87 13.63 173.11 229.1 55.5 4
Skyworks Solutions 95.05 1.18 20.11 4.73 19.81 57.11 97.57 17.58 1.37
SL Green Realty 112.12 2.76 47.98 2.34 70.63 91.03 120.63 11.28 0.98259
Snap-On Inc. 168.46 1.67 18.31 9.2 45.16 145.17 181.73 9.77 0.9267
Southern Co. 50.4 4.45 19.76 2.55 25 46.2 54.64 49.95 7.63
Southwest Airlines 56.83 0.68 16.02 3.55 13.72 35.42 59.68 34.96 5.27
Stanley Black & Decker 127.91 1.81 19.65 6.51 41.73 97.47 130.47 19.52 1.88
Starbucks Corp. 56.2 1.58 28.82 1.95 3.98 50.84 61.64 81.91 4.95
State Street Corp. 79.6 1.89 16.02 4.97 47.19 50.6 83.49 30.4 0
Stryker Corp. 129.14 1.31 29.69 4.35 25.47 102.31 131.36 48.15 3.11
SunTrust Banks 59.72 1.73 16.59 3.6 45.38 34.79 61.69 29.33 0
Symantec Corp. 29.29 1.03 8.82 3.32 6.38 16.14 29.47 18.13 0.875
Synchrony Financial 35.6 1.44 13.14 2.71 17.37 23.25 38.06 28.86 0
Sysco Corp. 52.3 2.53 28.52 1.83 4.58 44.71 57.07 28.25 3
T. Rowe Price Group 70.9 3.2 14.93 4.75 20.46 62.97 79 17.26 1.93
Target Corp. 55.14 4.18 11.74 4.7 19.69 55.05 84.14 30.67 7.27
TE Connectivity Ltd. 74.36 1.96 13.01 5.72 24.86 54.54 76.49 26.42 2.63
Tegna, Inc. 25.82 2.16 13 1.99 10.59 17.91 26.65 5.54 1.21
Tesoro Petroleum Co. 83.46 2.64 13.63 6.12 46.79 69.49 93.5 9.75 2.09
Texas Instruments 79.12 2.57 22.75 3.48 10.52 54.54 80.37 79.09 5.7
Textron Inc. 47.85 0.17 13.57 3.53 20.62 32.55 50.93 12.92 1.59
The Bank of New York Mellon Corp. 47.67 1.58 15.13 3.15 33.67 35.44 49.54 49.46 0
The Clorox Company 136.91 2.34 27.46 4.99 2.11 111.24 140.47 17.56 1.22
The Cooper Companies 193.46 0.03 31.88 6.07 57.07 141.67 201.83 9.56 0.62857
The Hershey Company 108.15 2.27 32.38 3.34 3.7 87.92 117.79 22.97 1.62
The Mosaic Company 29.18 1.99 34.33 0.85 27.37 22.77 34.36 10.22 1.2
The Travelers Companies Inc. 122.14 2.16 11.88 10.28 83.05 103.45 125.49 34.16 5.12
The Walt Disney Company 110.86 1.4 20.01 5.54 27.01 90.32 111.99 175.3 16.78
Thermo Fisher Scientific 157.26 0.37 30.89 5.09 54.74 136.58 160.89 61.39 4.53
Tiffany & Co. 88.76 1.99 24.86 3.57 23.37 56.99 92.74 11.05 0.9348
Time Warner Inc. 98.24 1.63 19.83 4.95 31.52 67.85 99.29 76.07 8.57
TJX Companies Inc. 78.3 1.32 22.64 3.46 6.86 71.5 83.64 51.47 4.51
Torchmark Corp. 78.03 0.77 17.37 4.49 38.69 52.19 79.05 9.19 0.86538
Total System Services 54.26 0.73 31.31 1.73 11.45 43.67 56.54 9.95 0.85436
Tractor Supply Company 71.43 1.33 21.84 3.27 11.11 61.5 97.25 9.34 0.83984
Transocean 12.78 0 6.09 2.1 41.27 8.34 16.66 4.67 1.69
Twenty-First Century Fox Class A 30.52 1.18 18.6 1.64 7.75 23.33 31.75 56.49 6.95
Twenty-First Century Fox Class B 30.11 1.2 18.35 1.64 7.75 23.88 31.3 55.73 6.95
Tyson Foods 61.89 1.42 12.49 4.96 26.01 55.72 77.05 22.72 3.78
U.S. Bancorp 55.03 2.02 16.98 3.24 24.63 38.47 56.61 93.22 0
UDR Inc 36.23 3.29 33.55 1.08 11.4 32.79 38.61 9.69 0.60553
Union Pacific 108.36 2.22 21.37 5.07 24.43 77.29 111.38 88.18 9.31
United Continental Holdings 72.64 0 10.6 6.85 27.52 37.41 76.8 22.85 6.85
United Health Group Inc. 168.3 1.49 23.21 7.25 40.2 120.41 169.36 160.08 14.51
United Parcel Service 105.64 3.13 27.3 3.87 0.47 98.85 120.44 91.91 7.7
United Technologies 112.28 2.35 18.35 6.12 34.1 95.05 114.44 90.48 10.04
Universal Health Services, Inc. 123.75 0.32 17.33 7.14 46.91 99.72 139.77 11.95 1.7
Unum Group 48.71 1.63 12.33 3.95 39.02 29.79 50.27 11.17 1.62
V.F. Corp. 52.62 3.19 20.66 2.55 11.93 48.05 66.91 21.79 1.93
Valero Energy 65.62 4.24 13.3 4.93 44.35 46.88 71.4 29.6 5.52
Varian Medical Systems 86.06 0 24.5 3.51 18.45 66.86 93.97 8.04 0.6334
Ventas Inc 62.67 4.87 33.75 1.86 29.54 55.91 76.8 22.22 1.83
Verizon Communications 49.44 4.61 15.4 3.21 5.53 46.01 56.95 201.55 43.39
Viacom Inc. 42.93 1.89 12.32 3.48 11.23 33.94 46.69 17.04 2.86
Visa Inc. 89.06 0.74 34.52 2.58 11.2 69.58 89.3 206.98 11.01
Vornado Realty Trust 107.85 2.61 24.88 4.34 30.99 86.35 111.72 20.39 1.4
Vulcan Materials 118.37 0.82 38.32 3.09 34.55 101.58 138.18 15.67 0.94985
Walgreens Boots Alliance 85.99 1.75 22.75 3.78 27.17 75.74 88 92.82 7.89
Wal-Mart Stores 69.87 2.91 15.95 4.38 25.38 62.72 75.19 214.15 32.84
Waste Management Inc. 72.7 2.33 27.43 2.65 12.06 56.05 73.65 31.97 3.71
Wec Energy Group Inc 59.29 3.51 20.03 2.96 28.29 53.66 66.1 18.71 2.44
Wells Fargo 58.3 2.58 14.61 3.99 35.21 43.55 59.99 291.7 0
Welltower Inc. 68.49 5 24.37 2.81 38.06 59.39 80.19 24.83 2.11
Western Union Co 19.9 3.51 39.02 0.51 1.87 18.07 22.7 9.57 1.37
WestRock Company 50.9 2.96 94.61 0.54 38.02 31.05 56.12 12.79 2.16
Weyerhaeuser Corp. 33.47 3.63 23.92 1.4 12.26 26.55 34.37 25.07 1.59
Whirlpool Corp. 175.38 2.25 15.25 11.5 64.1 145.91 194.1 13.06 2.18
Whole Foods Market 29.47 1.89 21.28 1.38 10.34 27.67 35.58 9.39 1.37
Willis Towers Watson 127.63 1.63 56.47 2.26 78.47 112.59 133.4 17.45 1.58
Wyndham Worldwide 82.19 2.52 14.86 5.53 6.76 62.6 86.72 8.63 1.31
Wynn Resorts Ltd 99.46 1.98 41.79 2.38 1.55 79.77 109.5 10.11 0.95059
Xcel Energy Inc 43.82 3.29 19.85 2.21 21.73 38 45.42 22.23 3.65
Xilinx Inc 58.75 2.25 25.77 2.28 9.97 41.53 62.24 14.62 0.76713
XL Capital 40.13 2.18 25.72 1.56 40.99 30.33 41.39 10.63 1.1
Xylem Inc. 48.78 1.48 33.64 1.45 12.21 37.58 54.99 8.75 0.615
Zimmer Biomet Holdings 117.07 0.81 77.53 1.51 48.2 95.63 133.21 23.54 2.8
Zions Bancorp 45.28 0.71 22.75 1.99 34.1 23.02 48.33 9.17 0
Zoetis 53.07 0.79 32.16 1.65 3.02 39.35 56.5 26.11 1.7