Hills Bank & Trust Co - Q4 2019 holdings

$424 Million is the total value of Hills Bank & Trust Co's 300 reported holdings in Q4 2019. The portfolio turnover from Q3 2019 to Q4 2019 was 5.6% .

 Value Shares↓ Weighting
SPY BuySPDR S&P 500 ETF TRUSTother$68,311,000
+9.4%
212,238
+0.9%
16.11%
+2.3%
MDY BuySPDR S&P MIDCAP 400 ETF TRUSTother$30,282,000
+7.2%
80,671
+0.6%
7.14%
+0.2%
TDTT SellFLEXSHARES IBOXX 3-YEAR TARGother$26,543,000
-0.4%
1,074,201
-0.9%
6.26%
-6.8%
AAPL SellAPPLE INC$12,323,000
+29.2%
41,962
-1.5%
2.91%
+20.8%
MSFT SellMICROSOFT CORP$11,990,000
+12.9%
76,030
-0.5%
2.83%
+5.6%
IJR BuyISHARES CORE S&P SMALL-CAP ETFother$8,987,000
+8.2%
107,181
+0.5%
2.12%
+1.2%
FISV SellFISERV INC$8,794,000
+9.7%
76,057
-1.7%
2.07%
+2.6%
HD SellHOME DEPOT INC$8,720,000
-8.2%
39,931
-2.4%
2.06%
-14.2%
GOOG  ALPHABET INC CL C$8,633,000
+9.7%
6,4570.0%2.04%
+2.6%
JPM SellJP MORGAN CHASE & CO$8,335,000
+18.0%
59,788
-0.4%
1.96%
+10.3%
GUNR SellFLEXSHARES GLOBAL UPSTREAM Nother$7,912,000
+6.7%
235,974
-0.9%
1.87%
-0.2%
PG SellPROCTER & GAMBLE CO$7,770,000
-1.3%
62,210
-1.7%
1.83%
-7.8%
EFA BuyISHARES MSCI EAFE ETFother$6,818,000
+7.4%
98,189
+0.9%
1.61%
+0.4%
FAST SellFASTENAL CO$6,593,000
+10.5%
178,433
-2.3%
1.56%
+3.3%
INTC SellINTEL CORP$6,418,000
+15.8%
107,226
-0.3%
1.51%
+8.2%
ITW SellILLINOIS TOOL WKS INC$6,377,000
+12.5%
35,502
-2.0%
1.50%
+5.2%
PEP SellPEPSICO INC$6,262,000
-2.5%
45,817
-2.2%
1.48%
-8.8%
NKE BuyNIKE INC-CLASS B$6,252,000
+7.9%
61,714
+0.0%
1.47%
+0.9%
JNJ SellJOHNSON & JOHNSON$6,124,000
+11.8%
41,983
-0.9%
1.44%
+4.5%
ICE SellINTERCONTINENTAL EXCHANGE INC$6,077,000
-0.3%
65,666
-0.6%
1.43%
-6.8%
MCD SellMCDONALDS CORP$5,920,000
-9.3%
29,955
-1.4%
1.40%
-15.1%
DIS SellDISNEY WALT CO NEW$5,733,000
+10.2%
39,645
-0.7%
1.35%
+3.1%
TMO SellTHERMO FISHER SCIENTIFIC INC$4,813,000
+8.7%
14,816
-2.6%
1.14%
+1.6%
BDX SellBECTON DICKINSON$4,043,000
+4.6%
14,869
-2.7%
0.95%
-2.3%
USB SellUS BANCORP NEW$4,021,000
+5.3%
67,813
-1.7%
0.95%
-1.6%
XOM SellEXXONMOBIL CORP$3,427,000
-7.5%
49,121
-6.4%
0.81%
-13.5%
CVS BuyCVS HEALTH CORP$3,423,000
+18.0%
46,082
+0.2%
0.81%
+10.2%
ZBH SellZIMMER BIOMET HOLDINGS INC$3,235,000
+8.0%
21,611
-1.0%
0.76%
+1.1%
SBUX BuySTARBUCKS CORP$3,217,000
-0.4%
36,588
+0.2%
0.76%
-6.8%
TJX SellTJX COS INC$3,057,000
+7.3%
50,065
-2.1%
0.72%
+0.3%
XLB SellMATERIALS SELECT SPDR FUNDother$2,973,000
+3.5%
48,409
-1.9%
0.70%
-3.2%
AMZN BuyAMAZON.COM INC$2,943,000
+10.7%
1,593
+4.0%
0.69%
+3.6%
BA SellBOEING CO$2,944,000
-14.6%
9,035
-0.2%
0.69%
-20.1%
AMT SellAMERICAN TOWER CORP REITother$2,797,000
+3.4%
12,171
-0.4%
0.66%
-3.2%
MA BuyMASTERCARD INC CL A$2,772,000
+10.7%
9,281
+0.6%
0.65%
+3.5%
C SellCITIGROUP INC$2,657,000
+14.0%
33,264
-1.4%
0.63%
+6.6%
BMY BuyBRISTOL MYERS SQUIBB CO$2,636,000
+105.6%
41,075
+62.5%
0.62%
+92.6%
IAK SellISHARES DJ US INSURANCE ETFother$2,589,000
-5.3%
36,306
-4.3%
0.61%
-11.3%
ABT BuyABBOTT LABS$2,573,000
+6.3%
29,621
+2.4%
0.61%
-0.5%
KLAC BuyKLA CORP$2,525,000
+13.0%
14,170
+1.1%
0.60%
+5.5%
TROW SellT ROWE PRICE GROUP INC$2,486,000
+5.2%
20,411
-1.3%
0.59%
-1.7%
IHF SellISHARES US HEALTHCARE PROVIDother$2,415,000
+22.2%
12,025
-1.7%
0.57%
+14.0%
CVX BuyCHEVRON CORPORATION$2,246,000
+3.2%
18,637
+1.6%
0.53%
-3.5%
DCI SellDONALDSON INC$2,187,000
+5.8%
37,952
-4.4%
0.52%
-1.0%
PFE BuyPFIZER INC$2,153,000
+9.5%
54,969
+0.5%
0.51%
+2.4%
NSC SellNORFOLK SOUTHERN CORP$2,095,000
+7.4%
10,788
-0.6%
0.49%
+0.4%
COST BuyCOSTCO WHOLESALE CORP$2,064,000
+2.1%
7,024
+0.1%
0.49%
-4.5%
NVDA SellNVIDIA CORP$2,051,000
+33.4%
8,719
-1.2%
0.48%
+24.7%
ALL BuyALLSTATE CORP$2,044,000
+4.9%
18,174
+1.4%
0.48%
-1.8%
FB SellFACEBOOK INC-A$1,849,000
+13.4%
9,007
-1.6%
0.44%
+6.1%
DHR SellDANAHER CORP$1,822,000
+5.4%
11,872
-0.8%
0.43%
-1.4%
MDLZ BuyMONDELEZ INTERNATIONAL INC$1,813,000
+2.0%
32,921
+2.5%
0.43%
-4.5%
ADP SellAUTOMATIC DATA PROCESSING INC$1,788,000
+5.5%
10,487
-0.0%
0.42%
-1.2%
EL BuyLAUDER ESTEE COS CL-A$1,787,000
+9.1%
8,651
+5.1%
0.42%
+1.9%
ORCL SellORACLE CORPORATION$1,782,000
-3.8%
33,644
-0.1%
0.42%
-10.1%
HTLD SellHEARTLAND EXPRESS INC$1,761,000
-3.3%
83,685
-1.2%
0.42%
-9.6%
CRM BuySALESFORCE.COM$1,761,000
+13.0%
10,828
+3.1%
0.42%
+5.6%
WFC SellWELLS FARGO & CO$1,712,000
+2.7%
31,807
-3.8%
0.40%
-3.8%
VZ SellVERIZON COMMUNICATIONS$1,681,000
+1.4%
27,377
-0.3%
0.40%
-5.3%
MCHP SellMICROCHIP TECHNOLOGY INC$1,653,000
+10.1%
15,788
-2.3%
0.39%
+3.2%
XLE SellENERGY SELECT SECTOR SPDRother$1,643,000
-5.0%
27,365
-6.3%
0.39%
-11.2%
ETFC BuyETRADE FINANCIAL CORP$1,587,000
+41.4%
34,978
+36.2%
0.37%
+32.2%
PYPL SellPAYPAL HOLDINGS INC$1,546,000
+3.2%
14,295
-1.1%
0.36%
-3.4%
EOG SellEOG RES INC$1,509,000
+10.6%
18,022
-1.9%
0.36%
+3.5%
PANW SellPALO ALTO NETWORKS INC$1,506,000
+10.9%
6,512
-2.2%
0.36%
+3.8%
MAS SellMASCO CORP$1,445,000
+13.8%
30,104
-1.1%
0.34%
+6.6%
ALXN BuyALEXION PHARMACEUTICALS INC$1,408,000
+11.7%
13,017
+1.1%
0.33%
+4.4%
BRKA  BERKSHIRE HATHAWAY INC CLASS A$1,359,000
+9.0%
40.0%0.32%
+1.9%
CMCSA BuyCOMCAST CORP-CL A$1,232,000
+5.6%
27,414
+5.9%
0.29%
-1.0%
AGN SellALLERGAN PLC$1,220,000
+1.2%
6,382
-10.9%
0.29%
-5.3%
GWW BuyWW GRAINGER INC$1,068,000
+16.2%
3,154
+2.0%
0.25%
+8.6%
NUE SellNUCOR CORP$1,040,000
+7.9%
18,487
-2.4%
0.24%
+0.8%
V SellVISA INC CL A$1,038,000
+9.1%
5,526
-0.0%
0.24%
+2.1%
DUK SellDUKE ENERGY CORP$1,027,000
-8.4%
11,261
-3.7%
0.24%
-14.5%
SLF  SUN LIFE FINANCIAL INC$1,003,000
+1.7%
22,0000.0%0.24%
-4.8%
UNP  UNION PAC CORP$973,000
+11.6%
5,3840.0%0.23%
+4.1%
PBE SellINVESCO DYNAMIC BIOTECHNOLOGYother$943,000
+12.9%
16,889
-4.1%
0.22%
+5.2%
CCL SellCARNIVAL CORP$902,000
+11.5%
17,746
-4.1%
0.21%
+4.4%
IBM BuyINTL. BUSINESS MACHINES CORP$898,000
-6.2%
6,701
+1.9%
0.21%
-12.0%
SLB SellSCHLUMBERGER LTD$856,000
+6.9%
21,307
-9.1%
0.20%0.0%
DE SellDEERE & CO$843,000
-1.1%
4,870
-3.5%
0.20%
-7.4%
CSCO  CISCO SYSTEMS INC$795,000
-2.9%
16,5700.0%0.19%
-9.7%
EBAY BuyEBAY INC$721,000
-3.1%
19,966
+4.6%
0.17%
-9.6%
GD BuyGENERAL DYNAMICS CORP$703,000
-1.8%
3,984
+1.7%
0.17%
-8.3%
AON SellAON PLC$677,000
+6.8%
3,250
-0.8%
0.16%0.0%
HON BuyHONEYWELL INTERNATIONAL INC$676,000
+5.8%
3,817
+1.1%
0.16%
-1.2%
KO SellCOCA COLA CO$662,000
+0.3%
11,973
-1.2%
0.16%
-6.0%
LMT  LOCKHEED MARTIN CORP$663,000
-0.3%
1,7030.0%0.16%
-7.1%
AFL SellAFLAC INC$635,000
+1.1%
12,005
-0.1%
0.15%
-5.1%
BAX SellBAXTER INTL INC$627,000
-6.3%
7,493
-2.1%
0.15%
-12.4%
SYK  STRYKER CORPORATION$609,000
-3.0%
2,9020.0%0.14%
-8.9%
CI SellCIGNA CORP$603,000
+34.6%
2,949
-0.1%
0.14%
+25.7%
CLX SellCLOROX COMPANY$579,000
-1.4%
3,770
-2.6%
0.14%
-7.4%
BIIB BuyBIOGEN INC$575,000
+30.7%
1,938
+2.5%
0.14%
+22.5%
ANSS  ANSYS INC$574,000
+16.4%
2,2280.0%0.14%
+8.9%
MIDD SellMIDDLEBY CORP$569,000
-6.4%
5,190
-0.2%
0.13%
-12.4%
CTSH SellCOGNIZANT TECHNOLOGY SOLUTIONS$550,000
+2.8%
8,873
-0.1%
0.13%
-3.7%
WMT SellWALMART INC$548,0000.0%4,606
-0.2%
0.13%
-6.5%
GE SellGENERAL ELECTRIC CORP$547,000
+24.0%
48,971
-0.6%
0.13%
+16.2%
ABBV  ABBVIE INC$543,000
+17.0%
6,1310.0%0.13%
+9.4%
MRK SellMERCK & CO INC$531,000
+7.7%
5,835
-0.4%
0.12%
+0.8%
AXP  AMERICAN EXPRESS CO$528,000
+5.4%
4,2430.0%0.12%
-0.8%
ECL SellECOLAB INC$527,000
-4.2%
2,728
-1.8%
0.12%
-10.8%
LLY BuyLILLY ELI & CO$496,000
+39.7%
3,772
+18.7%
0.12%
+30.0%
HAL SellHALLIBURTON CO$498,000
+25.8%
20,349
-3.2%
0.12%
+17.0%
EMR SellEMERSON ELEC CO$497,000
+9.0%
6,510
-4.5%
0.12%
+1.7%
RTN  RAYTHEON COMPANY$476,000
+12.0%
2,1680.0%0.11%
+4.7%
EW  EDWARDS LIFESCIENCES CORP$467,000
+6.1%
2,0000.0%0.11%
-0.9%
BRKB  BERKSHIRE HATHAWAY INC-CL B$463,000
+8.9%
2,0450.0%0.11%
+1.9%
PAYX  PAYCHEX INC$442,000
+2.6%
5,1990.0%0.10%
-4.6%
YUM  YUM! BRANDS INC$442,000
-11.2%
4,3890.0%0.10%
-17.5%
PM  PHILIP MORRIS INTERNATIONAL$427,000
+12.1%
5,0150.0%0.10%
+5.2%
ROP  ROPER TECHNOLOGIES INC$424,000
-0.7%
1,1970.0%0.10%
-7.4%
T SellAT&T INC$416,000
-24.4%
10,643
-26.7%
0.10%
-29.5%
ETN SellEATON CORP PLC$389,000
+11.5%
4,106
-2.4%
0.09%
+4.5%
IDXX  IDEXX LABS INC$382,000
-4.0%
1,4640.0%0.09%
-10.0%
ACN  ACCENTURE PLC CL A$379,000
+9.5%
1,8000.0%0.09%
+2.3%
STT SellSTATE STREET CORP$378,000
+26.4%
4,777
-5.5%
0.09%
+18.7%
SO  SOUTHERN COMPANY$378,000
+3.3%
5,9290.0%0.09%
-3.3%
SU  SUNCOR ENERGY INC$369,000
+3.7%
11,2650.0%0.09%
-3.3%
LNT SellALLIANT CORP$370,000
+1.1%
6,752
-0.4%
0.09%
-5.4%
FTV SellFORTIVE CORP$347,000
+9.1%
4,540
-2.2%
0.08%
+2.5%
MCO  MOODYS CORP$349,000
+15.9%
1,4700.0%0.08%
+7.9%
CAT  CATERPILLAR INC$334,000
+16.8%
2,2620.0%0.08%
+9.7%
ISRG BuyINTUITIVE SURGICAL INC$336,000
+11.6%
568
+1.8%
0.08%
+3.9%
DEO  DIAGEO PLC SPONS ADR$325,000
+2.8%
1,9280.0%0.08%
-3.8%
SPGI  S&P GLOBAL INC$327,000
+11.6%
1,1980.0%0.08%
+4.1%
NVS SellNOVARTIS AG SPONS ADR$322,000
+5.9%
3,400
-2.9%
0.08%
-1.3%
BP NewBP PLC SPONS ADR$305,0008,078
+100.0%
0.07%
SCHW SellCHARLES SCHWAB CORP$306,000
+10.1%
6,437
-3.0%
0.07%
+2.9%
ILMN  ILLUMINA INC$296,000
+9.2%
8920.0%0.07%
+2.9%
VWO BuyVANGUARD MSCI EMERGING MARKETSother$292,000
+27.5%
6,560
+15.1%
0.07%
+19.0%
XRAY SellDENTSPLY SIRONA INC$292,000
-3.9%
5,158
-9.8%
0.07%
-10.4%
MO  ALTRIA GROUP INC$289,000
+21.9%
5,7960.0%0.07%
+13.3%
MDU  MDU RESOURCES GROUP INC$287,000
+5.5%
9,6500.0%0.07%
-1.4%
HRL  HORMEL FOODS CORPORATION$278,000
+3.0%
6,1670.0%0.07%
-2.9%
VIG SellVANGUARD DIVIDEND APPREC ETFother$271,000
-3.2%
2,175
-7.1%
0.06%
-9.9%
MMC NewMARSH & MCLENNAN COS INC$273,0002,456
+100.0%
0.06%
QCOM SellQUALCOMM INC$266,000
+11.3%
3,013
-4.0%
0.06%
+5.0%
AWK SellAMERICAN WATER WORKS CO INC$268,000
-4.6%
2,182
-3.5%
0.06%
-11.3%
TECH  BIO-TECHNE CORP$263,000
+12.4%
1,1960.0%0.06%
+5.1%
ADM  ARCHER DANIELS MIDLAND CO$259,000
+12.6%
5,5920.0%0.06%
+5.2%
EEM  ISHARES MSCI EMERGING MKT ETFother$257,000
+9.8%
5,7320.0%0.06%
+3.4%
CPRT  COPART INC$254,000
+12.9%
2,8000.0%0.06%
+5.3%
POOL  POOL CORPORATION$244,000
+5.2%
1,1500.0%0.06%
-1.7%
DSI  ISHARES MSCI KLD 400 SOCIAL ETother$246,000
+8.4%
2,0500.0%0.06%
+1.8%
DGX  QUEST DIAGNOSTICS INC$246,0000.0%2,3010.0%0.06%
-6.5%
IWF  ISHARES RUSSELL 1000 GROWTH ETother$237,000
+9.7%
1,3500.0%0.06%
+3.7%
IJH  ISHARES CORE S&P MID-CAP ETFother$233,000
+6.4%
1,1310.0%0.06%0.0%
TYL  TYLER TECHNOLOGIES INC$233,000
+14.2%
7760.0%0.06%
+7.8%
BND NewVANGUARD TOTAL BOND MARKET ETFother$233,0002,781
+100.0%
0.06%
STZ  CONSTELLATION BRANDS INC$235,000
-8.6%
1,2400.0%0.06%
-15.4%
MKL  MARKEL CORPORATION$229,000
-3.0%
2000.0%0.05%
-10.0%
GOOGL  ALPHABET INC CL A$226,000
+9.7%
1690.0%0.05%
+1.9%
AEP  AMERICAN ELEC PWR INC$225,000
+0.9%
2,3810.0%0.05%
-5.4%
NEE  NEXTERA ENERGY INC$221,000
+3.8%
9140.0%0.05%
-3.7%
SEIC NewSEI INVESTMENTS COMPANY$217,0003,321
+100.0%
0.05%
OMC SellOMNICOM GROUP$218,000
+2.8%
2,682
-0.6%
0.05%
-3.8%
TRMB  TRIMBLE INC$216,000
+7.5%
5,1820.0%0.05%0.0%
WBA SellWALGREENS BOOTS ALLIANCE INC$212,000
+5.0%
3,585
-1.9%
0.05%
-2.0%
SRCL NewSTERICYCLE INC$203,0003,180
+100.0%
0.05%
VRSK  VERISK ANALYTICS INC$201,000
-5.6%
1,3460.0%0.05%
-13.0%
BMYRT NewBRISTOL-MYERS SQU - RIGHTS 3other$48,00015,817
+100.0%
0.01%
HSY ExitTHE HERSHEY COMPANY$0-1,358
-100.0%
-0.05%
WELL ExitWELLTOWER INC REITother$0-2,411
-100.0%
-0.06%
CELG ExitCELGENE CORP$0-15,948
-100.0%
-0.40%
Original filings

The following EDGAR filing(s) were analyzed to create this report:

  • View 13F-HR filed 2020-01-27
Signatures

The EDGAR filing(s) were signed by:

Top long-term holdings
NameQuarters ownedLatest quarter ownedMax weighting
State Street ETF/USA42Q3 202317.3%
STATE STREET ETF/USA42Q3 202310.8%
Procter & Gamble Co/The42Q3 20234.8%
ISHARES MSCI EAFE INDEX FUND42Q3 20237.6%
MICROSOFT CORP42Q3 20233.7%
Voya Investments LLC42Q3 20233.4%
APPLE INC42Q3 20233.9%
Home Depot Inc/The42Q3 20232.5%
FASTENAL CO42Q3 20232.8%
PEPSICO INC42Q3 20232.7%

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

Latest filings
TypeFiled
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
13F-HR2022-08-02
13F-HR2022-04-29

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

Compare quarters

Export Hills Bank & Trust Co's holdings