$309 Million is the total value of Hills Bank & Trust Co's 253 reported holdings in Q2 2017. The portfolio turnover from Q1 2017 to Q2 2017 was 8.2% .
Value | Shares | ↓ Weighting | ||||||
---|---|---|---|---|---|---|---|---|
SPY | Sell | SPDR S&P 500 ETF TRUSTother | $51,816,000 | +2.3% | 214,292 | -0.3% | 16.76% | -2.5% |
MDY | Sell | SPDR S&P MIDCAP 400 ETF TRUSTother | $17,624,000 | +0.7% | 55,488 | -0.9% | 5.70% | -4.0% |
PG | Sell | PROCTER & GAMBLE CO | $7,970,000 | -10.3% | 91,455 | -7.5% | 2.58% | -14.5% |
HD | Sell | HOME DEPOT INC | $7,093,000 | +2.8% | 46,237 | -1.6% | 2.30% | -2.0% |
ITW | Sell | ILLINOIS TOOL WKS INC | $6,321,000 | +5.2% | 44,121 | -2.7% | 2.04% | +0.3% |
EFA | Sell | ISHARES MSCI EAFE ETFother | $5,705,000 | +3.4% | 87,497 | -1.2% | 1.85% | -1.4% |
FISV | Sell | FISERV INC | $5,488,000 | +4.4% | 44,855 | -1.6% | 1.78% | -0.5% |
JPM | Sell | JP MORGAN CHASE & CO | $5,171,000 | +3.9% | 56,575 | -0.1% | 1.67% | -0.9% |
MCD | Sell | MCDONALDS CORP | $5,086,000 | +16.9% | 33,208 | -1.0% | 1.65% | +11.4% |
WFC | Sell | WELLS FARGO & CO | $5,050,000 | -1.1% | 91,145 | -0.6% | 1.63% | -5.7% |
ICE | Sell | INTERCONTINENTAL EXCHANGE INC | $4,551,000 | +9.3% | 69,029 | -0.8% | 1.47% | +4.1% |
FAST | Sell | FASTENAL CO | $3,734,000 | -16.2% | 85,799 | -0.9% | 1.21% | -20.2% |
BDX | Sell | BECTON DICKINSON | $3,673,000 | +5.1% | 18,827 | -1.2% | 1.19% | +0.1% |
XLB | Sell | MATERIALS SELECT SPDR FUNDother | $3,451,000 | +0.7% | 64,135 | -1.9% | 1.12% | -4.0% |
TMO | Sell | THERMO FISHER SCIENTIFIC INC | $3,243,000 | +12.6% | 18,589 | -0.9% | 1.05% | +7.3% |
XLE | Sell | ENERGY SELECT SECTOR SPDRother | $3,153,000 | -9.4% | 48,568 | -2.5% | 1.02% | -13.7% |
IAK | Sell | ISHARES DJ US INSURANCE ETFother | $2,970,000 | +1.4% | 47,440 | -1.8% | 0.96% | -3.3% |
C | Sell | CITIGROUP INC | $2,147,000 | +9.4% | 32,094 | -2.2% | 0.70% | +4.4% |
DCI | Sell | DONALDSON INC | $2,052,000 | -1.3% | 45,064 | -1.3% | 0.66% | -5.8% |
XRAY | Sell | DENTSPLY SIRONA INC | $2,018,000 | +2.7% | 31,135 | -1.1% | 0.65% | -2.1% |
IHF | Sell | ISHARES DJ US HEALTH CAR PRO Eother | $2,016,000 | +10.1% | 13,566 | -0.6% | 0.65% | +4.8% |
TROW | Sell | T ROWE PRICE GROUP INC | $1,864,000 | +5.0% | 25,113 | -3.6% | 0.60% | 0.0% |
ESRX | Sell | EXPRESS SCRIPTS HLDG | $1,848,000 | -7.1% | 28,958 | -4.1% | 0.60% | -11.5% |
QCOM | Sell | QUALCOMM INC | $1,396,000 | -27.6% | 25,292 | -24.8% | 0.45% | -31.0% |
STT | Sell | STATE STREET CORP | $1,361,000 | +9.3% | 15,169 | -3.0% | 0.44% | +4.0% |
OMC | Sell | OMNICOM GROUP | $1,295,000 | -8.9% | 15,624 | -5.2% | 0.42% | -13.1% |
GILD | Sell | GILEAD SCIENCES INC | $1,292,000 | +3.4% | 18,254 | -0.8% | 0.42% | -1.4% |
AMT | Sell | AMERICAN TOWER CORP REITother | $1,250,000 | +7.2% | 9,447 | -1.5% | 0.40% | +2.0% |
GIS | Sell | GENERAL MILLS INC. | $1,163,000 | -17.9% | 20,992 | -12.6% | 0.38% | -21.8% |
PBE | Sell | POWERSHARES DYN BIOTECH & GENOother | $1,126,000 | +4.6% | 24,661 | -3.1% | 0.36% | -0.3% |
ALL | Sell | ALLSTATE CORP | $1,098,000 | +8.1% | 12,415 | -0.4% | 0.36% | +2.9% |
NVS | Sell | NOVARTIS AG SPONS ADR | $883,000 | -6.1% | 10,583 | -16.3% | 0.29% | -10.3% |
CLX | Sell | CLOROX COMPANY | $874,000 | -24.7% | 6,559 | -23.8% | 0.28% | -28.2% |
PYPL | Sell | PAYPAL HOLDINGS INC | $804,000 | +2.8% | 14,969 | -17.7% | 0.26% | -1.9% |
EMR | Sell | EMERSON ELEC CO | $782,000 | -13.1% | 13,129 | -12.7% | 0.25% | -17.3% |
CMCSA | Sell | COMCAST CORP-CL A | $764,000 | +3.0% | 19,618 | -0.6% | 0.25% | -2.0% |
PFE | Sell | PFIZER INC | $756,000 | -4.5% | 22,498 | -2.7% | 0.24% | -8.9% |
BAX | Sell | BAXTER INTL INC | $731,000 | +16.0% | 12,071 | -0.6% | 0.24% | +10.7% |
MIDD | Sell | MIDDLEBY CORP | $667,000 | -11.3% | 5,486 | -0.5% | 0.22% | -15.3% |
DE | Sell | DEERE & CO | $648,000 | +6.2% | 5,246 | -6.4% | 0.21% | +1.4% |
DHR | Sell | DANAHER CORP | $630,000 | -5.8% | 7,463 | -4.6% | 0.20% | -10.1% |
TGT | Sell | TARGET CORP | $518,000 | -9.9% | 9,905 | -5.0% | 0.17% | -13.8% |
EBAY | Sell | EBAY INC | $415,000 | -18.0% | 11,887 | -21.1% | 0.13% | -22.1% |
MRK | Sell | MERCK & CO INC | $387,000 | -6.5% | 6,050 | -7.3% | 0.12% | -11.3% |
SRCL | Sell | STERICYCLE INC | $380,000 | -8.7% | 4,968 | -1.0% | 0.12% | -12.8% |
ETN | Sell | EATON CORP PLC | $377,000 | -1.6% | 4,850 | -6.3% | 0.12% | -6.2% |
KO | Sell | COCA COLA CO | $361,000 | +4.6% | 8,056 | -0.9% | 0.12% | 0.0% |
CHRW | Sell | CH ROBINSON WORLDWIDE INC | $347,000 | -44.6% | 5,054 | -37.6% | 0.11% | -47.4% |
AXP | Sell | AMERICAN EXPRESS CO | $337,000 | +5.0% | 4,000 | -1.2% | 0.11% | 0.0% |
STZ | Sell | CONSTELLATION BRANDS INC | $330,000 | +15.0% | 1,700 | -4.2% | 0.11% | +10.3% |
WBA | Sell | WALGREENS BOOTS ALLIANCE INC | $274,000 | -6.2% | 3,502 | -0.4% | 0.09% | -10.1% |
IDXX | Sell | IDEXX LABS INC | $272,000 | -1.8% | 1,683 | -6.1% | 0.09% | -6.4% |
AWK | Sell | AMERICAN WATER WORKS CO INC | $271,000 | -9.7% | 3,475 | -9.7% | 0.09% | -13.7% |
FTV | Sell | FORTIVE CORP | $259,000 | -36.4% | 4,089 | -39.6% | 0.08% | -39.1% |
WMT | Sell | WAL MART STORES INC | $241,000 | +1.7% | 3,180 | -3.0% | 0.08% | -2.5% |
ACN | Sell | ACCENTURE PLC CL A | $225,000 | -2.6% | 1,825 | -5.2% | 0.07% | -6.4% |
SU | Exit | SUNCOR ENERGY INC | $0 | – | -6,575 | -100.0% | -0.07% | – |
EXC | Exit | EXELON CORP | $0 | – | -7,247 | -100.0% | -0.09% | – |
BCR | Exit | C. R. BARD INC | $0 | – | -2,425 | -100.0% | -0.20% | – |
ATVI | Exit | ACTIVISION BLIZZARD INC | $0 | – | -14,440 | -100.0% | -0.24% | – |
NXPI | Exit | NXP SEMICONDUCTORS | $0 | – | -9,090 | -100.0% | -0.32% | – |
Original filings
The following EDGAR filing(s) were analyzed to create this report:
- View 13F-HR filed 2017-07-12
Top long-term holdings
Name | Quarters owned | Latest quarter owned | Max weighting |
---|---|---|---|
State Street ETF/USA | 45 | Q2 2024 | 17.3% |
STATE STREET ETF/USA | 45 | Q2 2024 | 10.8% |
Procter & Gamble Co/The | 45 | Q2 2024 | 4.8% |
ISHARES MSCI EAFE INDEX FUND | 45 | Q2 2024 | 7.6% |
MICROSOFT CORP | 45 | Q2 2024 | 3.7% |
APPLE INC | 45 | Q2 2024 | 3.9% |
Voya Investments LLC | 45 | Q2 2024 | 3.4% |
Home Depot Inc/The | 45 | Q2 2024 | 2.5% |
FASTENAL CO | 45 | Q2 2024 | 2.8% |
PEPSICO INC | 45 | Q2 2024 | 2.7% |
View Hills Bank & Trust Co's complete holdings history.
Latest filings
Type | Filed |
---|---|
N-PX | 2024-08-28 |
13F-HR | 2024-07-25 |
13F-HR | 2024-05-08 |
13F-HR | 2024-02-07 |
13F-HR | 2023-10-26 |
13F-HR | 2023-07-21 |
13F-HR | 2023-04-17 |
13F-HR | 2023-02-06 |
13F-HR | 2022-11-03 |
13F-HR/A | 2022-08-16 |
View Hills Bank & Trust Co's complete filings history.
All filings
- Holdings (13F-HR)
- Significant ownership (13-D/G)
- Insider transactions (4, 5, 6)
- Events (8-K)
- Shareholder votes (proxy)
View complete filings history.