Hills Bank & Trust Co - Q3 2017 holdings

$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 SellSPDR S&P MIDCAP 400 ETF TRUSTother$17,908,000
+1.6%
54,877
-1.1%
5.62%
-1.4%
PG SellPROCTER & GAMBLE CO$8,170,000
+2.5%
89,805
-1.8%
2.56%
-0.6%
HD SellHOME DEPOT INC$7,353,000
+3.7%
44,953
-2.8%
2.31%
+0.6%
ITW SellILLINOIS TOOL WKS INC$6,507,000
+2.9%
43,978
-0.3%
2.04%
-0.1%
AAPL SellAPPLE INC$6,451,000
+6.5%
41,860
-0.5%
2.02%
+3.3%
PEP SellPEPSICO INC$6,045,000
-5.1%
54,249
-1.7%
1.90%
-8.0%
EFA SellISHARES MSCI EAFE ETFother$5,917,000
+3.7%
86,397
-1.3%
1.86%
+0.6%
FISV SellFISERV INC$5,732,000
+4.4%
44,445
-0.9%
1.80%
+1.3%
JNJ SellJOHNSON & JOHNSON$5,645,000
-2.1%
43,422
-0.3%
1.77%
-5.0%
MCD SellMCDONALDS CORP$5,010,000
-1.5%
31,975
-3.7%
1.57%
-4.5%
WFC SellWELLS FARGO & CO$5,001,000
-1.0%
90,675
-0.5%
1.57%
-3.9%
USB SellUS BANCORP NEW$4,764,000
+0.9%
88,893
-2.2%
1.50%
-2.1%
ICE SellINTERCONTINENTAL EXCHANGE INC$4,735,000
+4.0%
68,912
-0.2%
1.49%
+1.0%
FAST SellFASTENAL CO$3,902,000
+4.5%
85,614
-0.2%
1.22%
+1.4%
CVS SellCVS HEALTH CORP$3,678,000
-1.0%
45,236
-2.1%
1.15%
-4.1%
BDX SellBECTON DICKINSON$3,661,000
-0.3%
18,687
-0.7%
1.15%
-3.3%
XLB SellMATERIALS SELECT SPDR FUNDother$3,589,000
+4.0%
63,200
-1.5%
1.13%
+0.8%
TMO SellTHERMO FISHER SCIENTIFIC INC$3,504,000
+8.0%
18,518
-0.4%
1.10%
+4.9%
XLE SellENERGY SELECT SECTOR SPDRother$3,218,000
+2.1%
46,995
-3.2%
1.01%
-1.0%
IAK SellISHARES DJ US INSURANCE ETFother$3,003,000
+1.1%
47,115
-0.7%
0.94%
-1.9%
TROW SellT ROWE PRICE GROUP INC$2,214,000
+18.8%
24,425
-2.7%
0.70%
+15.3%
DCI SellDONALDSON INC$2,065,000
+0.6%
44,952
-0.2%
0.65%
-2.4%
IHF SellISHARES DJ US HEALTH CAR PRO Eother$1,994,000
-1.1%
13,499
-0.5%
0.63%
-4.0%
EOG SellEOG RES INC$1,904,000
+6.8%
19,679
-0.1%
0.60%
+3.6%
XRAY SellDENTSPLY SIRONA INC$1,855,000
-8.1%
31,011
-0.4%
0.58%
-10.9%
BIIB SellBIOGEN INC$1,511,000
+13.0%
4,824
-2.1%
0.47%
+9.5%
STT SellSTATE STREET CORP$1,449,000
+6.5%
15,164
-0.0%
0.46%
+3.4%
RHT SellRED HAT INC$1,402,000
+10.8%
12,640
-4.3%
0.44%
+7.6%
PBE SellPOWERSHARES DYN BIOTECH & GENOother$1,229,000
+9.1%
24,611
-0.2%
0.39%
+6.0%
OMC SellOMNICOM GROUP$1,086,000
-16.1%
14,654
-6.2%
0.34%
-18.6%
LNT SellALLIANT CORP$1,014,000
+2.9%
24,405
-0.4%
0.32%
-0.3%
GIS SellGENERAL MILLS INC.$981,000
-15.6%
18,960
-9.7%
0.31%
-18.1%
PYPL SellPAYPAL HOLDINGS INC$945,000
+17.5%
14,759
-1.4%
0.30%
+14.2%
NVS SellNOVARTIS AG SPONS ADR$887,000
+0.5%
10,338
-2.3%
0.28%
-2.8%
CLX SellCLOROX COMPANY$853,000
-2.4%
6,469
-1.4%
0.27%
-5.3%
T SellAT&T INC$797,000
+2.4%
20,340
-1.4%
0.25%
-0.8%
EMR SellEMERSON ELEC CO$797,000
+1.9%
12,686
-3.4%
0.25%
-1.2%
VZ SellVERIZON COMMUNICATIONS$782,000
+9.4%
15,805
-1.2%
0.24%
+6.1%
PFE SellPFIZER INC$743,000
-1.7%
20,833
-7.4%
0.23%
-4.9%
BAX SellBAXTER INTL INC$733,000
+0.3%
11,671
-3.3%
0.23%
-3.0%
MIDD SellMIDDLEBY CORP$700,000
+4.9%
5,461
-0.5%
0.22%
+1.9%
DE SellDEERE & CO$658,000
+1.5%
5,240
-0.1%
0.21%
-1.4%
UNP SellUNION PAC CORP$631,000
+5.5%
5,445
-0.9%
0.20%
+2.6%
DHR SellDANAHER CORP$597,000
-5.2%
6,963
-6.7%
0.19%
-8.3%
PM SellPHILIP MORRIS INTERNATIONAL$575,000
-6.4%
5,179
-1.0%
0.18%
-9.5%
EBAY SellEBAY INC$430,000
+3.6%
11,197
-5.8%
0.14%
+0.7%
BRKB SellBERKSHIRE HATHAWAY INC-CL B$414,000
+3.8%
2,257
-4.2%
0.13%
+0.8%
MRK SellMERCK & CO INC$369,000
-4.7%
5,766
-4.7%
0.12%
-7.2%
ETN SellEATON CORP PLC$363,000
-3.7%
4,725
-2.6%
0.11%
-6.6%
ABBV SellABBVIE INC$358,000
+19.7%
4,024
-2.4%
0.11%
+15.5%
KO SellCOCA COLA CO$357,000
-1.1%
7,931
-1.6%
0.11%
-4.3%
AXP SellAMERICAN EXPRESS CO$353,000
+4.7%
3,900
-2.5%
0.11%
+1.8%
SRCL SellSTERICYCLE INC$334,000
-12.1%
4,664
-6.1%
0.10%
-14.6%
AWK SellAMERICAN WATER WORKS CO INC$278,000
+2.6%
3,438
-1.1%
0.09%
-1.1%
EW SellEDWARDS LIFESCIENCES CORP$274,000
-21.7%
2,510
-15.2%
0.09%
-23.9%
MDU SellMDU RESOURCES GROUP INC$239,000
-2.8%
9,200
-2.1%
0.08%
-6.2%
FTV SellFORTIVE CORP$240,000
-7.3%
3,379
-17.4%
0.08%
-10.7%
DGX SellQUEST DIAGNOSTICS INC$235,000
-17.5%
2,510
-2.0%
0.07%
-19.6%
DEO SellDIAGEO PLC SPONS ADR$225,000
+4.7%
1,704
-4.9%
0.07%
+1.4%
HRL ExitHORMEL FOODS CORPORATION$0-6,167
-100.0%
-0.07%
MO ExitALTRIA GROUP INC$0-3,117
-100.0%
-0.08%
CHRW ExitCH ROBINSON WORLDWIDE INC$0-5,054
-100.0%
-0.11%
TGT ExitTARGET CORP$0-9,905
-100.0%
-0.17%
DKS ExitDICKS SPORTING GOODS INC$0-27,437
-100.0%
-0.35%
GILD ExitGILEAD 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
Signatures

The EDGAR filing(s) were signed by:

Top long-term holdings
NameQuarters ownedLatest quarter ownedMax weighting
State Street ETF/USA45Q2 202417.3%
STATE STREET ETF/USA45Q2 202410.8%
Procter & Gamble Co/The45Q2 20244.8%
ISHARES MSCI EAFE INDEX FUND45Q2 20247.6%
MICROSOFT CORP45Q2 20243.7%
APPLE INC45Q2 20243.9%
Voya Investments LLC45Q2 20243.4%
Home Depot Inc/The45Q2 20242.5%
FASTENAL CO45Q2 20242.8%
PEPSICO INC45Q2 20242.7%

View Hills Bank & Trust Co's complete holdings history.

Latest filings
TypeFiled
N-PX2024-08-28
13F-HR2024-07-25
13F-HR2024-05-08
13F-HR2024-02-07
13F-HR2023-10-26
13F-HR2023-07-21
13F-HR2023-04-17
13F-HR2023-02-06
13F-HR2022-11-03
13F-HR/A2022-08-16

View Hills Bank & Trust Co's complete filings history.

Compare quarters

Export Hills Bank & Trust Co's holdings