$778 Million is the total value of Hills Bank & Trust Co's 393 reported holdings in Q2 2023. The portfolio turnover from Q1 2023 to Q2 2023 was 5.6% .
Value | Shares | ↓ Weighting | ||||||
---|---|---|---|---|---|---|---|---|
SPY | Sell | SSgA Funds Management Inctr unit | $102,659,216 | +7.9% | 231,590 | -0.4% | 13.20% | +0.3% |
AAPL | Sell | Apple Inc | $29,689,630 | +15.5% | 153,063 | -1.9% | 3.82% | +7.3% |
MSFT | Sell | MICROSOFT CORP | $28,225,998 | +17.2% | 82,886 | -0.7% | 3.63% | +9.0% |
PG | Sell | Procter & Gamble Co/The | $19,893,114 | +0.2% | 131,100 | -1.8% | 2.56% | -6.9% |
GOOG | Sell | Alphabet Inccap stk cl c | $16,736,320 | +16.1% | 138,351 | -0.1% | 2.15% | +7.9% |
NVDA | Sell | NVIDIA Corp | $14,570,077 | +47.1% | 34,443 | -3.4% | 1.87% | +36.8% |
IJR | Sell | BlackRock Fund Advisorscore s&p scp etf | $14,103,464 | -26.5% | 141,530 | -28.6% | 1.81% | -31.7% |
FAST | Sell | Fastenal Co | $12,607,638 | +8.4% | 213,725 | -0.9% | 1.62% | +0.7% |
EFA | Sell | iShares ETFs/USAmsci eafe etf | $11,478,780 | -1.3% | 158,328 | -2.7% | 1.48% | -8.3% |
HD | Sell | Home Depot Inc/The | $10,601,212 | +4.5% | 34,127 | -0.7% | 1.36% | -2.9% |
JPM | Sell | JPMorgan Chase & Co | $9,334,339 | +10.3% | 64,180 | -1.2% | 1.20% | +2.5% |
GQRE | Sell | Northern Trust Investments Incglb qlt r/e idx | $8,346,453 | -10.1% | 157,360 | -10.1% | 1.07% | -16.4% |
MCD | Sell | MCDONALD'S CORP | $7,408,924 | +5.9% | 24,828 | -0.8% | 0.95% | -1.5% |
ICE | Sell | INTERCONTINENTAL EXCHANGE | $6,967,651 | +7.4% | 61,617 | -0.9% | 0.90% | -0.1% |
PEP | Sell | PEPSICO INC | $6,896,482 | +0.4% | 37,234 | -1.1% | 0.89% | -6.6% |
ITW | Sell | ILLINOIS TOOL WKS | $6,889,156 | -0.2% | 27,539 | -2.9% | 0.89% | -7.3% |
FISV | Sell | FISERV INC | $6,760,631 | +8.5% | 53,592 | -2.8% | 0.87% | +0.7% |
TMO | Sell | Thermo Fisher Scientific Inc | $6,530,223 | -12.1% | 12,516 | -2.9% | 0.84% | -18.3% |
PANW | Sell | Palo Alto Networks Inc | $6,381,617 | +26.9% | 24,976 | -0.8% | 0.82% | +18.0% |
JNJ | Sell | Johnson & Johnson | $5,879,933 | -0.3% | 35,524 | -6.6% | 0.76% | -7.4% |
XOM | Sell | Exxon Mobil Corp | $5,443,474 | -2.7% | 50,755 | -0.5% | 0.70% | -9.6% |
DHR | Sell | Danaher Corp | $4,666,560 | -5.7% | 19,444 | -0.9% | 0.60% | -12.3% |
CVX | Sell | Chevron Corp | $4,520,666 | -4.7% | 28,730 | -1.2% | 0.58% | -11.6% |
FB | Sell | FACEBOOK INCcl a | $4,030,634 | +34.6% | 14,045 | -0.6% | 0.52% | +25.1% |
V | Sell | VISA INC | $3,909,396 | +2.7% | 16,462 | -2.5% | 0.50% | -4.6% |
DE | Sell | DEERE & CO | $3,631,718 | -20.1% | 8,963 | -18.6% | 0.47% | -25.8% |
CMG | Sell | Chipotle Mexican Grill Inc | $3,330,423 | +24.5% | 1,557 | -0.6% | 0.43% | +15.7% |
GWW | Sell | WW Grainger Inc | $3,142,531 | +12.5% | 3,985 | -1.8% | 0.40% | +4.4% |
ANSS | Sell | ANSYS, INC. | $3,135,913 | -1.3% | 9,495 | -0.6% | 0.40% | -8.4% |
ISRG | Sell | Intuitive Surgical Inc | $2,898,283 | +32.5% | 8,476 | -1.0% | 0.37% | +23.1% |
DIS | Sell | Walt Disney Co/The | $2,633,314 | -11.0% | 29,495 | -0.2% | 0.34% | -17.3% |
BMY | Sell | BRISTOL-MYRS SQUIB | $2,628,920 | -7.8% | 41,109 | -0.1% | 0.34% | -14.4% |
KLAC | Sell | KLA Corp | $2,569,151 | +14.6% | 5,297 | -5.7% | 0.33% | +6.5% |
XLB | Sell | SELECT SECTOR SPDRsbi materials | $2,531,513 | -0.9% | 30,548 | -3.5% | 0.33% | -7.6% |
USB | Sell | US Bancorp | $2,528,155 | -13.9% | 76,518 | -6.1% | 0.32% | -20.1% |
LNT | Sell | Alliant Energy Corp | $2,348,953 | -2.2% | 44,759 | -0.5% | 0.30% | -9.0% |
LLY | Sell | Eli Lilly & Co | $2,009,580 | +26.3% | 4,285 | -7.5% | 0.26% | +17.3% |
IHF | Sell | BlackRock Fund Advisorsus hlthcr pr etf | $1,991,658 | +0.6% | 7,786 | -2.8% | 0.26% | -6.6% |
INTC | Sell | Intel Corp | $1,973,662 | -12.0% | 59,021 | -14.1% | 0.25% | -18.1% |
QCOM | Sell | QUALCOMM Inc | $1,945,828 | -7.3% | 16,346 | -0.6% | 0.25% | -13.8% |
BDX | Sell | BECTON DICKINSON | $1,732,697 | +3.9% | 6,563 | -2.6% | 0.22% | -3.5% |
ECL | Sell | ECOLAB INC | $1,697,385 | +12.4% | 9,092 | -0.3% | 0.22% | +4.3% |
CBOE | Sell | Cboe Global Markets Inc | $1,611,267 | -3.3% | 11,675 | -5.9% | 0.21% | -10.4% |
BRKB | Sell | Berkshire Hathaway Inccl b new | $1,600,654 | +10.4% | 4,694 | -0.0% | 0.21% | +2.5% |
DCI | Sell | Donaldson Co Inc | $1,577,190 | -6.2% | 25,231 | -2.0% | 0.20% | -12.9% |
TECH | Sell | Bio-Techne Corp | $1,519,869 | +8.1% | 18,619 | -1.7% | 0.20% | +0.5% |
IAK | Sell | BlackRock Fund Advisorsu.s. insrnce etf | $1,380,313 | -0.2% | 15,705 | -2.8% | 0.18% | -6.8% |
TROW | Sell | T Rowe Price Group Inc | $1,288,342 | -6.2% | 11,501 | -5.5% | 0.17% | -12.6% |
CBRE | Sell | CBRE Group Inccl a | $1,258,914 | +10.1% | 15,598 | -0.6% | 0.16% | +2.5% |
ADP | Sell | AUTOMATIC DATA PROCESSING | $1,221,593 | -6.5% | 5,558 | -5.3% | 0.16% | -13.3% |
SO | Sell | Southern Co/The | $1,169,803 | -0.1% | 16,652 | -1.0% | 0.15% | -7.4% |
IDXX | Sell | IDEXX Laboratories Inc | $1,041,122 | -15.1% | 2,073 | -15.4% | 0.13% | -21.2% |
VRSK | Sell | Verisk Analytics Inc | $992,949 | +15.3% | 4,393 | -2.1% | 0.13% | +7.6% |
ILMN | Sell | Illumina Inc | $968,948 | -28.0% | 5,168 | -10.7% | 0.12% | -32.8% |
VZ | Sell | VERIZON COMMUN | $920,006 | -5.5% | 24,738 | -1.2% | 0.12% | -12.6% |
MAS | Sell | Masco Corp | $832,297 | +5.7% | 14,505 | -8.4% | 0.11% | -1.8% |
ACN | Sell | Accenture PLC | $786,262 | -4.0% | 2,548 | -11.1% | 0.10% | -10.6% |
ALL | Sell | Allstate Corp/The | $730,350 | -18.8% | 6,698 | -17.5% | 0.09% | -24.2% |
AMD | Sell | ADVANCED MICRO DEV | $686,308 | -13.1% | 6,025 | -25.3% | 0.09% | -19.3% |
ABBV | Sell | AbbVie Inc | $666,240 | -18.6% | 4,945 | -3.7% | 0.09% | -23.9% |
EMR | Sell | EMERSON ELECTRIC | $655,056 | +2.0% | 7,247 | -1.7% | 0.08% | -5.6% |
MS | Sell | MORGAN STANLEY | $627,177 | -11.8% | 7,344 | -9.4% | 0.08% | -17.3% |
AXP | Sell | AMER EXPRESS CO | $614,926 | +2.7% | 3,530 | -2.8% | 0.08% | -4.8% |
SYK | Sell | Stryker Corp | $607,739 | +6.1% | 1,992 | -0.7% | 0.08% | -1.3% |
AFL | Sell | Aflac Inc | $587,018 | +5.1% | 8,410 | -2.9% | 0.08% | -2.6% |
BL | Sell | BlackLine Inc | $569,416 | -21.3% | 10,580 | -1.9% | 0.07% | -27.0% |
CI | Sell | Cigna Group/The | $564,286 | +8.4% | 2,011 | -1.3% | 0.07% | +1.4% |
KMX | Sell | CarMax Inc | $562,464 | +22.7% | 6,720 | -5.8% | 0.07% | +14.3% |
PYPL | Sell | PayPal Holdings Inc | $541,047 | -17.0% | 8,108 | -5.5% | 0.07% | -22.2% |
VOO | Sell | VANGUARD | $538,424 | +5.5% | 1,322 | -2.6% | 0.07% | -2.8% |
CTSH | Sell | COGNIZANT TECHNOLOcl a | $521,457 | +6.1% | 7,988 | -1.0% | 0.07% | -1.5% |
Sell | General Electric Co | $516,076 | +13.3% | 4,698 | -1.4% | 0.07% | +4.8% | |
ES | Sell | Eversource Energy | $506,794 | -9.9% | 7,146 | -0.6% | 0.06% | -16.7% |
WMT | Sell | Walmart Inc | $491,502 | +4.8% | 3,127 | -1.7% | 0.06% | -3.1% |
PBE | Sell | Invesco Capital Management LLCdynmc biotech | $451,805 | -4.3% | 7,372 | -2.0% | 0.06% | -10.8% |
DG | Sell | Dollar General Corp | $431,580 | -23.9% | 2,542 | -5.7% | 0.06% | -29.1% |
CLX | Sell | Clorox Co/The | $370,563 | -1.6% | 2,330 | -2.1% | 0.05% | -7.7% |
MO | Sell | ALTRIA GROUP INC | $330,826 | +0.8% | 7,303 | -0.7% | 0.04% | -4.4% |
FTV | Sell | Fortive Corp | $337,586 | -1.2% | 4,515 | -9.9% | 0.04% | -8.5% |
IVV | Sell | ISHAREScore s&p500 etf | $330,271 | -7.1% | 741 | -14.3% | 0.04% | -14.3% |
XEL | Sell | Xcel Energy Inc | $323,657 | -10.1% | 5,206 | -2.5% | 0.04% | -16.0% |
GOOGL | Sell | ALPHABET INCcap stk cl a | $320,437 | -4.2% | 2,677 | -16.9% | 0.04% | -10.9% |
RTX | Sell | Raytheon Technologies Corp | $301,521 | -1.6% | 3,078 | -1.6% | 0.04% | -7.1% |
SBUX | Sell | STARBUCKS CORP | $301,836 | -13.0% | 3,047 | -8.6% | 0.04% | -18.8% |
LMT | Sell | Lockheed Martin Corp | $291,881 | -13.5% | 634 | -11.2% | 0.04% | -19.1% |
SU | Sell | SUNCOR ENERGY INC | $288,098 | -6.7% | 9,826 | -1.2% | 0.04% | -14.0% |
IEMG | Sell | BlackRock Fund Advisorscore msci emkt | $264,884 | -1.6% | 5,374 | -2.6% | 0.03% | -8.1% |
DVY | Sell | ISHARESselect divid etf | $252,886 | -7.5% | 2,232 | -4.4% | 0.03% | -13.2% |
C | Sell | Citigroup Inc | $246,176 | -76.3% | 5,347 | -75.9% | 0.03% | -77.8% |
VXF | Sell | Vanguard Group Inc/Theextend mkt etf | $246,909 | +4.3% | 1,659 | -1.8% | 0.03% | -3.0% |
MMM | Sell | 3M Co | $241,617 | -23.9% | 2,414 | -20.0% | 0.03% | -29.5% |
LKQ | Sell | LKQ Corp | $229,467 | -2.3% | 3,938 | -4.8% | 0.03% | -6.2% |
TRMB | Sell | Trimble Inc | $218,219 | -9.9% | 4,122 | -10.8% | 0.03% | -17.6% |
KMB | Sell | KIMBERLY-CLARK CP | $215,374 | -8.8% | 1,560 | -11.4% | 0.03% | -15.2% |
IVE | Sell | ISHARESs&p 500 val etf | $220,024 | +4.6% | 1,365 | -1.5% | 0.03% | -3.4% |
DFS | Sell | DISCOVER FINL SVCS | $203,319 | +10.8% | 1,740 | -6.2% | 0.03% | +4.0% |
DEO | Sell | DIAGEOspon adr new | $200,716 | -10.0% | 1,157 | -6.0% | 0.03% | -16.1% |
EXPD | Sell | EXPEDTRS INTL WASH | $196,231 | +9.0% | 1,620 | -0.9% | 0.02% | 0.0% |
VTI | Sell | VANGUARD ETF/USAtotal stk mkt | $190,983 | +3.4% | 867 | -4.2% | 0.02% | -3.8% |
ETN | Sell | Eaton Corp PLC | $188,431 | +16.9% | 937 | -0.4% | 0.02% | +9.1% |
WFC | Sell | WELLS FARGO & CO | $179,256 | +5.4% | 4,200 | -7.7% | 0.02% | -4.2% |
AKAM | Sell | Akamai Technologies Inc | $181,178 | +7.4% | 2,016 | -6.4% | 0.02% | 0.0% |
EBAY | Sell | EBAY INC | $175,989 | -13.1% | 3,938 | -13.7% | 0.02% | -17.9% |
CAT | Sell | Caterpillar Inc | $170,021 | -25.0% | 691 | -30.3% | 0.02% | -29.0% |
IEFA | Sell | ISHAREScore msci eafe | $167,535 | +0.4% | 2,482 | -0.5% | 0.02% | -4.3% |
FDX | Sell | FEDEX CORP | $160,143 | +0.3% | 646 | -7.6% | 0.02% | -4.5% |
AWK | Sell | American Water Works Co Inc | $150,744 | -13.5% | 1,056 | -11.2% | 0.02% | -20.8% |
PSX | Sell | Phillips 66 | $150,796 | -9.0% | 1,581 | -3.3% | 0.02% | -17.4% |
IWM | Sell | ISHARESrussell 2000 etf | $149,816 | -3.8% | 800 | -8.4% | 0.02% | -13.6% |
NVS | Sell | Novartis AGsponsored adr | $144,302 | -4.9% | 1,430 | -13.3% | 0.02% | -9.5% |
IWS | Sell | BlackRock Fund Advisorsrus mdcp val etf | $141,474 | -41.1% | 1,288 | -43.0% | 0.02% | -45.5% |
MOFG | Sell | MidWestOne Financial Group Inc | $130,891 | -50.0% | 6,125 | -42.9% | 0.02% | -52.8% |
TXN | Sell | TEXAS INSTRUMENTS | $128,894 | -6.4% | 716 | -3.2% | 0.02% | -10.5% |
WEC | Sell | WEC Energy Group Inc | $122,830 | -16.3% | 1,392 | -10.1% | 0.02% | -20.0% |
AZN | Sell | AstraZeneca PLCsponsored adr | $127,180 | -17.5% | 1,777 | -20.0% | 0.02% | -23.8% |
Sell | GE HealthCare Technologies Inc | $126,978 | -2.5% | 1,563 | -1.5% | 0.02% | -11.1% | |
MCHP | Sell | Microchip Technology Inc | $112,973 | +0.5% | 1,261 | -6.0% | 0.02% | -6.2% |
SEIC | Sell | SEI INVESTMENTS | $108,568 | -10.3% | 1,821 | -13.4% | 0.01% | -17.6% |
AMAT | Exit | APPLIED MATERIALS | $0 | – | -866 | -100.0% | -0.02% | – |
CINF | Exit | Cincinnati Financial Corp | $0 | – | -1,000 | -100.0% | -0.02% | – |
MDU | Exit | MDU RES GROUP INC | $0 | – | -4,550 | -100.0% | -0.02% | – |
NUV | Exit | Nuveen Closed-End Funds/USA | $0 | – | -18,176 | -100.0% | -0.02% | – |
TDTT | Exit | FlexShares ETFs/USAiboxx 3r targt | $0 | – | -10,206 | -100.0% | -0.03% | – |
NIQ | Exit | Nuveen Asset Management LLCnone | $0 | – | -30,706 | -100.0% | -0.05% | – |
IWV | Exit | BlackRock Fund Advisorsrussell 3000 etf | $0 | – | -2,386 | -100.0% | -0.08% | – |
Original filings
The following EDGAR filing(s) were analyzed to create this report:
- View 13F-HR filed 2023-07-21
Top long-term holdings
Name | Quarters owned | Latest quarter owned | Max weighting |
---|---|---|---|
State Street ETF/USA | 42 | Q3 2023 | 17.3% |
STATE STREET ETF/USA | 42 | Q3 2023 | 10.8% |
Procter & Gamble Co/The | 42 | Q3 2023 | 4.8% |
ISHARES MSCI EAFE INDEX FUND | 42 | Q3 2023 | 7.6% |
MICROSOFT CORP | 42 | Q3 2023 | 3.7% |
Voya Investments LLC | 42 | Q3 2023 | 3.4% |
APPLE INC | 42 | Q3 2023 | 3.9% |
Home Depot Inc/The | 42 | Q3 2023 | 2.5% |
FASTENAL CO | 42 | Q3 2023 | 2.8% |
PEPSICO INC | 42 | Q3 2023 | 2.7% |
View Hills Bank & Trust Co's complete holdings history.
Latest filings
Type | Filed |
---|---|
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 |
13F-HR | 2022-08-02 |
13F-HR | 2022-04-29 |
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.