$319 Million is the total value of Hills Bank & Trust Co's 249 reported holdings in Q3 2017. The portfolio turnover from Q2 2017 to Q3 2017 was 9.2% .
Value | Shares | ↓ Weighting | ||||||
---|---|---|---|---|---|---|---|---|
MDY | Sell | SPDR S&P MIDCAP 400 ETF TRUSTother | $17,908,000 | +1.6% | 54,877 | -1.1% | 5.62% | -1.4% |
PG | Sell | PROCTER & GAMBLE CO | $8,170,000 | +2.5% | 89,805 | -1.8% | 2.56% | -0.6% |
HD | Sell | HOME DEPOT INC | $7,353,000 | +3.7% | 44,953 | -2.8% | 2.31% | +0.6% |
ITW | Sell | ILLINOIS TOOL WKS INC | $6,507,000 | +2.9% | 43,978 | -0.3% | 2.04% | -0.1% |
AAPL | Sell | APPLE INC | $6,451,000 | +6.5% | 41,860 | -0.5% | 2.02% | +3.3% |
PEP | Sell | PEPSICO INC | $6,045,000 | -5.1% | 54,249 | -1.7% | 1.90% | -8.0% |
EFA | Sell | ISHARES MSCI EAFE ETFother | $5,917,000 | +3.7% | 86,397 | -1.3% | 1.86% | +0.6% |
FISV | Sell | FISERV INC | $5,732,000 | +4.4% | 44,445 | -0.9% | 1.80% | +1.3% |
JNJ | Sell | JOHNSON & JOHNSON | $5,645,000 | -2.1% | 43,422 | -0.3% | 1.77% | -5.0% |
MCD | Sell | MCDONALDS CORP | $5,010,000 | -1.5% | 31,975 | -3.7% | 1.57% | -4.5% |
WFC | Sell | WELLS FARGO & CO | $5,001,000 | -1.0% | 90,675 | -0.5% | 1.57% | -3.9% |
USB | Sell | US BANCORP NEW | $4,764,000 | +0.9% | 88,893 | -2.2% | 1.50% | -2.1% |
ICE | Sell | INTERCONTINENTAL EXCHANGE INC | $4,735,000 | +4.0% | 68,912 | -0.2% | 1.49% | +1.0% |
FAST | Sell | FASTENAL CO | $3,902,000 | +4.5% | 85,614 | -0.2% | 1.22% | +1.4% |
CVS | Sell | CVS HEALTH CORP | $3,678,000 | -1.0% | 45,236 | -2.1% | 1.15% | -4.1% |
BDX | Sell | BECTON DICKINSON | $3,661,000 | -0.3% | 18,687 | -0.7% | 1.15% | -3.3% |
XLB | Sell | MATERIALS SELECT SPDR FUNDother | $3,589,000 | +4.0% | 63,200 | -1.5% | 1.13% | +0.8% |
TMO | Sell | THERMO FISHER SCIENTIFIC INC | $3,504,000 | +8.0% | 18,518 | -0.4% | 1.10% | +4.9% |
XLE | Sell | ENERGY SELECT SECTOR SPDRother | $3,218,000 | +2.1% | 46,995 | -3.2% | 1.01% | -1.0% |
IAK | Sell | ISHARES DJ US INSURANCE ETFother | $3,003,000 | +1.1% | 47,115 | -0.7% | 0.94% | -1.9% |
TROW | Sell | T ROWE PRICE GROUP INC | $2,214,000 | +18.8% | 24,425 | -2.7% | 0.70% | +15.3% |
DCI | Sell | DONALDSON INC | $2,065,000 | +0.6% | 44,952 | -0.2% | 0.65% | -2.4% |
IHF | Sell | ISHARES DJ US HEALTH CAR PRO Eother | $1,994,000 | -1.1% | 13,499 | -0.5% | 0.63% | -4.0% |
EOG | Sell | EOG RES INC | $1,904,000 | +6.8% | 19,679 | -0.1% | 0.60% | +3.6% |
XRAY | Sell | DENTSPLY SIRONA INC | $1,855,000 | -8.1% | 31,011 | -0.4% | 0.58% | -10.9% |
BIIB | Sell | BIOGEN INC | $1,511,000 | +13.0% | 4,824 | -2.1% | 0.47% | +9.5% |
STT | Sell | STATE STREET CORP | $1,449,000 | +6.5% | 15,164 | -0.0% | 0.46% | +3.4% |
RHT | Sell | RED HAT INC | $1,402,000 | +10.8% | 12,640 | -4.3% | 0.44% | +7.6% |
PBE | Sell | POWERSHARES DYN BIOTECH & GENOother | $1,229,000 | +9.1% | 24,611 | -0.2% | 0.39% | +6.0% |
OMC | Sell | OMNICOM GROUP | $1,086,000 | -16.1% | 14,654 | -6.2% | 0.34% | -18.6% |
LNT | Sell | ALLIANT CORP | $1,014,000 | +2.9% | 24,405 | -0.4% | 0.32% | -0.3% |
GIS | Sell | GENERAL MILLS INC. | $981,000 | -15.6% | 18,960 | -9.7% | 0.31% | -18.1% |
PYPL | Sell | PAYPAL HOLDINGS INC | $945,000 | +17.5% | 14,759 | -1.4% | 0.30% | +14.2% |
NVS | Sell | NOVARTIS AG SPONS ADR | $887,000 | +0.5% | 10,338 | -2.3% | 0.28% | -2.8% |
CLX | Sell | CLOROX COMPANY | $853,000 | -2.4% | 6,469 | -1.4% | 0.27% | -5.3% |
T | Sell | AT&T INC | $797,000 | +2.4% | 20,340 | -1.4% | 0.25% | -0.8% |
EMR | Sell | EMERSON ELEC CO | $797,000 | +1.9% | 12,686 | -3.4% | 0.25% | -1.2% |
VZ | Sell | VERIZON COMMUNICATIONS | $782,000 | +9.4% | 15,805 | -1.2% | 0.24% | +6.1% |
PFE | Sell | PFIZER INC | $743,000 | -1.7% | 20,833 | -7.4% | 0.23% | -4.9% |
BAX | Sell | BAXTER INTL INC | $733,000 | +0.3% | 11,671 | -3.3% | 0.23% | -3.0% |
MIDD | Sell | MIDDLEBY CORP | $700,000 | +4.9% | 5,461 | -0.5% | 0.22% | +1.9% |
DE | Sell | DEERE & CO | $658,000 | +1.5% | 5,240 | -0.1% | 0.21% | -1.4% |
UNP | Sell | UNION PAC CORP | $631,000 | +5.5% | 5,445 | -0.9% | 0.20% | +2.6% |
DHR | Sell | DANAHER CORP | $597,000 | -5.2% | 6,963 | -6.7% | 0.19% | -8.3% |
PM | Sell | PHILIP MORRIS INTERNATIONAL | $575,000 | -6.4% | 5,179 | -1.0% | 0.18% | -9.5% |
EBAY | Sell | EBAY INC | $430,000 | +3.6% | 11,197 | -5.8% | 0.14% | +0.7% |
BRKB | Sell | BERKSHIRE HATHAWAY INC-CL B | $414,000 | +3.8% | 2,257 | -4.2% | 0.13% | +0.8% |
MRK | Sell | MERCK & CO INC | $369,000 | -4.7% | 5,766 | -4.7% | 0.12% | -7.2% |
ETN | Sell | EATON CORP PLC | $363,000 | -3.7% | 4,725 | -2.6% | 0.11% | -6.6% |
ABBV | Sell | ABBVIE INC | $358,000 | +19.7% | 4,024 | -2.4% | 0.11% | +15.5% |
KO | Sell | COCA COLA CO | $357,000 | -1.1% | 7,931 | -1.6% | 0.11% | -4.3% |
AXP | Sell | AMERICAN EXPRESS CO | $353,000 | +4.7% | 3,900 | -2.5% | 0.11% | +1.8% |
SRCL | Sell | STERICYCLE INC | $334,000 | -12.1% | 4,664 | -6.1% | 0.10% | -14.6% |
AWK | Sell | AMERICAN WATER WORKS CO INC | $278,000 | +2.6% | 3,438 | -1.1% | 0.09% | -1.1% |
EW | Sell | EDWARDS LIFESCIENCES CORP | $274,000 | -21.7% | 2,510 | -15.2% | 0.09% | -23.9% |
MDU | Sell | MDU RESOURCES GROUP INC | $239,000 | -2.8% | 9,200 | -2.1% | 0.08% | -6.2% |
FTV | Sell | FORTIVE CORP | $240,000 | -7.3% | 3,379 | -17.4% | 0.08% | -10.7% |
DGX | Sell | QUEST DIAGNOSTICS INC | $235,000 | -17.5% | 2,510 | -2.0% | 0.07% | -19.6% |
DEO | Sell | DIAGEO PLC SPONS ADR | $225,000 | +4.7% | 1,704 | -4.9% | 0.07% | +1.4% |
HRL | Exit | HORMEL FOODS CORPORATION | $0 | – | -6,167 | -100.0% | -0.07% | – |
MO | Exit | ALTRIA GROUP INC | $0 | – | -3,117 | -100.0% | -0.08% | – |
CHRW | Exit | CH ROBINSON WORLDWIDE INC | $0 | – | -5,054 | -100.0% | -0.11% | – |
TGT | Exit | TARGET CORP | $0 | – | -9,905 | -100.0% | -0.17% | – |
DKS | Exit | DICKS SPORTING GOODS INC | $0 | – | -27,437 | -100.0% | -0.35% | – |
GILD | Exit | GILEAD SCIENCES INC | $0 | – | -18,254 | -100.0% | -0.42% | – |
Original filings
The following EDGAR filing(s) were analyzed to create this report:
- View 13F-HR filed 2017-10-16
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.