$861 Million is the total value of Hills Bank & Trust Co's 414 reported holdings in Q3 2023. The portfolio turnover from Q2 2023 to Q3 2023 was 8.3% .
Value | Shares | ↓ Weighting | ||||||
---|---|---|---|---|---|---|---|---|
SPY | Sell | State Street ETF/USAtr unit | $96,483,519 | -6.0% | 225,703 | -2.5% | 11.21% | -15.1% |
MSFT | Sell | MICROSOFT CORP | $25,409,350 | -10.0% | 80,473 | -2.9% | 2.95% | -18.7% |
AAPL | Sell | Apple Inc | $25,373,664 | -14.5% | 148,202 | -3.2% | 2.95% | -22.8% |
PG | Sell | Procter & Gamble Co/The | $18,677,664 | -6.1% | 128,052 | -2.3% | 2.17% | -15.2% |
GOOG | Sell | Alphabet Inccap stk cl c | $17,804,892 | +6.4% | 135,039 | -2.4% | 2.07% | -3.9% |
NVDA | Sell | NVIDIA Corp | $12,429,839 | -14.7% | 28,575 | -17.0% | 1.44% | -22.9% |
FAST | Sell | Fastenal Co | $11,563,518 | -8.3% | 211,631 | -1.0% | 1.34% | -17.1% |
HD | Sell | Home Depot Inc/The | $10,237,181 | -3.4% | 33,880 | -0.7% | 1.19% | -12.8% |
JPM | Sell | JPMorgan Chase & Co | $9,209,060 | -1.3% | 63,502 | -1.1% | 1.07% | -10.8% |
AMZN | Sell | Amazon.com Inc | $8,713,440 | -4.2% | 68,545 | -1.8% | 1.01% | -13.5% |
IJR | Sell | BlackRock Fund Advisorscore s&p scp etf | $8,575,635 | -39.2% | 90,911 | -35.8% | 1.00% | -45.1% |
ICE | Sell | INTERCONTINENTAL EXCHANGE | $6,678,434 | -4.2% | 60,702 | -1.5% | 0.78% | -13.4% |
MCD | Sell | MCDONALD'S CORP | $6,500,646 | -12.3% | 24,676 | -0.6% | 0.76% | -20.8% |
TMO | Sell | Thermo Fisher Scientific Inc | $6,255,755 | -4.2% | 12,359 | -1.3% | 0.73% | -13.5% |
ITW | Sell | ILLINOIS TOOL WKS | $6,253,607 | -9.2% | 27,153 | -1.4% | 0.73% | -18.1% |
PEP | Sell | PEPSICO INC | $6,226,751 | -9.7% | 36,749 | -1.3% | 0.72% | -18.5% |
XOM | Sell | Exxon Mobil Corp | $5,942,258 | +9.2% | 50,538 | -0.4% | 0.69% | -1.4% |
FISV | Sell | FISERV INC | $5,787,845 | -14.4% | 51,238 | -4.4% | 0.67% | -22.7% |
NKE | Sell | NIKE INCcl b | $5,530,756 | -13.4% | 57,841 | -0.1% | 0.64% | -21.9% |
JNJ | Sell | Johnson & Johnson | $5,485,204 | -6.7% | 35,218 | -0.9% | 0.64% | -15.7% |
PANW | Sell | Palo Alto Networks Inc | $5,326,008 | -16.5% | 22,718 | -9.0% | 0.62% | -24.6% |
COST | Sell | Costco Wholesale Corp | $5,014,020 | +4.9% | 8,875 | -0.1% | 0.58% | -5.4% |
DHR | Sell | Danaher Corp | $4,752,852 | +1.8% | 19,157 | -1.5% | 0.55% | -8.0% |
FB | Sell | FACEBOOK INCcl a | $4,111,376 | +2.0% | 13,695 | -2.5% | 0.48% | -7.7% |
AMT | Sell | American Tower Corp | $4,056,489 | -16.1% | 24,667 | -1.1% | 0.47% | -24.3% |
CVS | Sell | CVS Health Corp | $3,897,143 | +0.9% | 55,817 | -0.1% | 0.45% | -8.9% |
V | Sell | VISA INC | $3,786,194 | -3.2% | 16,461 | -0.0% | 0.44% | -12.5% |
TJX | Sell | TJX Cos Inc/The | $3,750,558 | +4.7% | 42,198 | -0.1% | 0.44% | -5.2% |
DE | Sell | DEERE & CO | $3,185,842 | -12.3% | 8,442 | -5.8% | 0.37% | -20.8% |
ZBH | Sell | ZIMMER HLDGS INC | $2,873,168 | -22.9% | 25,603 | -0.0% | 0.33% | -30.4% |
ANSS | Sell | ANSYS, INC. | $2,803,218 | -10.6% | 9,421 | -0.8% | 0.33% | -19.1% |
GWW | Sell | WW Grainger Inc | $2,712,705 | -13.7% | 3,921 | -1.6% | 0.32% | -22.0% |
XLB | Sell | SELECT SECTOR SPDRsbi materials | $2,390,277 | -5.6% | 30,430 | -0.4% | 0.28% | -14.7% |
SPGI | Sell | S&P Global Inc | $2,396,724 | -10.5% | 6,559 | -1.9% | 0.28% | -19.4% |
BMY | Sell | BRISTOL-MYRS SQUIB | $2,363,389 | -10.1% | 40,720 | -0.9% | 0.28% | -18.6% |
PFE | Sell | Pfizer Inc | $2,348,502 | -9.6% | 70,802 | -0.0% | 0.27% | -18.3% |
KLAC | Sell | KLA Corp | $2,338,707 | -9.0% | 5,099 | -3.7% | 0.27% | -17.6% |
DIS | Sell | Walt Disney Co/The | $2,325,892 | -11.7% | 28,697 | -2.7% | 0.27% | -20.4% |
LNT | Sell | Alliant Energy Corp | $2,157,091 | -8.2% | 44,522 | -0.5% | 0.25% | -16.9% |
EOG | Sell | EOG Resources Inc | $2,134,892 | +10.2% | 16,842 | -0.5% | 0.25% | -0.4% |
INTC | Sell | Intel Corp | $2,047,218 | +3.7% | 57,587 | -2.4% | 0.24% | -6.3% |
IBM | Sell | INTL BUSINESS MCHN | $2,033,508 | -2.4% | 14,494 | -7.0% | 0.24% | -11.9% |
MMC | Sell | MARSH & MCLENNAN | $1,926,027 | -7.8% | 10,121 | -8.8% | 0.22% | -16.7% |
IHF | Sell | BlackRock Fund Advisorsus hlthcr pr etf | $1,885,372 | -5.3% | 7,661 | -1.6% | 0.22% | -14.5% |
LLY | Sell | Eli Lilly & Co | $1,812,276 | -9.8% | 3,374 | -21.3% | 0.21% | -18.2% |
BA | Sell | BOEING CO | $1,766,139 | -10.1% | 9,214 | -1.0% | 0.20% | -19.0% |
QCOM | Sell | QUALCOMM Inc | $1,748,751 | -10.1% | 15,746 | -3.7% | 0.20% | -18.8% |
ECL | Sell | ECOLAB INC | $1,511,556 | -10.9% | 8,923 | -1.9% | 0.18% | -19.3% |
DCI | Sell | Donaldson Co Inc | $1,498,992 | -5.0% | 25,134 | -0.4% | 0.17% | -14.3% |
IAK | Sell | BlackRock Fund Advisorsu.s. insrnce etf | $1,427,632 | +3.4% | 15,577 | -0.8% | 0.17% | -6.7% |
ADP | Sell | AUTOMATIC DATA PROCESSING | $1,336,662 | +9.4% | 5,556 | -0.0% | 0.16% | -1.3% |
TECH | Sell | Bio-Techne Corp | $1,261,473 | -17.0% | 18,532 | -0.5% | 0.15% | -24.6% |
MKL | Sell | Markel Group Inc | $1,216,277 | -1.1% | 826 | -7.1% | 0.14% | -10.8% |
TROW | Sell | T Rowe Price Group Inc | $1,192,897 | -7.4% | 11,375 | -1.1% | 0.14% | -16.3% |
TDG | Sell | TRANSDIGM INC | $1,146,657 | -5.9% | 1,360 | -0.2% | 0.13% | -15.3% |
MCO | Sell | MOODYS CORP | $1,045,258 | -9.4% | 3,306 | -0.4% | 0.12% | -18.2% |
ACN | Sell | Accenture PLC | $770,846 | -2.0% | 2,510 | -1.5% | 0.09% | -10.9% |
VRSK | Sell | Verisk Analytics Inc | $776,757 | -21.8% | 3,288 | -25.2% | 0.09% | -29.7% |
IDXX | Sell | IDEXX Laboratories Inc | $767,846 | -26.2% | 1,756 | -15.3% | 0.09% | -33.6% |
AON | Sell | Aon PLC | $749,597 | -6.4% | 2,312 | -0.3% | 0.09% | -15.5% |
ALL | Sell | Allstate Corp/The | $742,325 | +1.6% | 6,663 | -0.5% | 0.09% | -8.5% |
UNP | Sell | Union Pacific Corp | $737,548 | -3.3% | 3,622 | -2.9% | 0.09% | -12.2% |
ABBV | Sell | AbbVie Inc | $734,866 | +10.3% | 4,930 | -0.3% | 0.08% | -1.2% |
CSGP | Sell | CoStar Group Inc | $697,546 | -13.8% | 9,072 | -0.2% | 0.08% | -22.1% |
AFL | Sell | Aflac Inc | $619,680 | +5.6% | 8,074 | -4.0% | 0.07% | -4.0% |
MS | Sell | MORGAN STANLEY | $596,517 | -4.9% | 7,304 | -0.5% | 0.07% | -14.8% |
DSI | Sell | BlackRock Fund Advisorsmsci kld400 soc | $592,502 | -4.4% | 7,278 | -1.2% | 0.07% | -13.8% |
CI | Sell | Cigna Group/The | $571,854 | +1.3% | 1,999 | -0.6% | 0.07% | -9.6% |
SYK | Sell | Stryker Corp | $534,516 | -12.0% | 1,956 | -1.8% | 0.06% | -20.5% |
Sell | General Electric Co | $518,811 | +0.5% | 4,693 | -0.1% | 0.06% | -9.1% | |
BL | Sell | BlackLine Inc | $506,164 | -11.1% | 9,125 | -13.8% | 0.06% | -19.2% |
WMT | Sell | Walmart Inc | $481,549 | -2.0% | 3,011 | -3.7% | 0.06% | -11.1% |
ROP | Sell | ROPER INDUSTRIES INC | $474,110 | +0.5% | 979 | -0.2% | 0.06% | -9.8% |
PBE | Sell | Invesco Capital Management LLCdynmc biotech | $411,464 | -8.9% | 7,214 | -2.1% | 0.05% | -17.2% |
YUM | Sell | YUM BRANDS INC | $383,691 | -10.1% | 3,071 | -0.3% | 0.04% | -18.2% |
POOL | Sell | Pool Corp | $365,359 | -5.3% | 1,026 | -0.4% | 0.04% | -16.0% |
GOOGL | Sell | ALPHABET INCcap stk cl a | $345,470 | +7.8% | 2,640 | -1.4% | 0.04% | -2.4% |
FTV | Sell | Fortive Corp | $334,462 | -0.9% | 4,510 | -0.1% | 0.04% | -9.3% |
SU | Sell | SUNCOR ENERGY INC | $333,589 | +15.8% | 9,703 | -1.3% | 0.04% | +5.4% |
STZ | Sell | Constellation Brands Inccl a | $308,885 | +1.4% | 1,229 | -0.7% | 0.04% | -7.7% |
IVV | Sell | ISHAREScore s&p500 etf | $312,625 | -5.3% | 728 | -1.8% | 0.04% | -14.3% |
LOW | Sell | LOWE'S COS INC | $303,446 | -8.5% | 1,460 | -0.7% | 0.04% | -18.6% |
XEL | Sell | Xcel Energy Inc | $297,315 | -8.1% | 5,196 | -0.2% | 0.04% | -16.7% |
CLX | Sell | Clorox Co/The | $302,094 | -18.5% | 2,305 | -1.1% | 0.04% | -27.1% |
SBUX | Sell | STARBUCKS CORP | $278,008 | -7.9% | 3,046 | -0.0% | 0.03% | -17.9% |
TYL | Sell | Tyler Technologies Inc | $254,466 | -8.5% | 659 | -1.3% | 0.03% | -16.7% |
DVY | Sell | ISHARESselect divid etf | $239,068 | -5.5% | 2,221 | -0.5% | 0.03% | -15.2% |
HSY | Sell | HERSHEY CO (THE) | $234,094 | -26.6% | 1,170 | -8.4% | 0.03% | -34.1% |
AKAM | Sell | Akamai Technologies Inc | $214,572 | +18.4% | 2,014 | -0.1% | 0.02% | +8.7% |
DGX | Sell | Quest Diagnostics Inc | $218,129 | -13.5% | 1,790 | -0.2% | 0.02% | -21.9% |
DFAC | Sell | Dimensional ETF Trustus core equity 2 | $213,399 | -5.8% | 8,145 | -2.4% | 0.02% | -13.8% |
MMM | Sell | 3M Co | $208,492 | -13.7% | 2,227 | -7.7% | 0.02% | -22.6% |
IVE | Sell | ISHARESs&p 500 val etf | $209,838 | -4.6% | 1,364 | -0.1% | 0.02% | -14.3% |
BAC | Sell | BK OF AMERICA CORP | $185,965 | -7.0% | 6,792 | -2.6% | 0.02% | -15.4% |
C | Sell | Citigroup Inc | $193,434 | -21.4% | 4,703 | -12.0% | 0.02% | -31.2% |
MRK | Sell | Merck & Co Inc | $177,280 | -16.5% | 1,722 | -6.4% | 0.02% | -22.2% |
EXPD | Sell | EXPEDTRS INTL WASH | $183,293 | -6.6% | 1,599 | -1.3% | 0.02% | -16.0% |
VTI | Sell | VANGUARD ETF/USAtotal stk mkt | $179,274 | -6.1% | 844 | -2.7% | 0.02% | -16.0% |
EBAY | Sell | EBAY INC | $173,495 | -1.4% | 3,935 | -0.1% | 0.02% | -13.0% |
WFC | Sell | WELLS FARGO & CO | $170,386 | -4.9% | 4,170 | -0.7% | 0.02% | -13.0% |
FDX | Sell | FEDEX CORP | $164,250 | +2.6% | 620 | -4.0% | 0.02% | -9.5% |
AMGN | Sell | Amgen Inc | $165,019 | +19.9% | 614 | -1.0% | 0.02% | +5.6% |
SRCL | Sell | Stericycle Inc | $132,297 | -4.4% | 2,959 | -0.7% | 0.02% | -16.7% |
AWK | Sell | American Water Works Co Inc | $130,640 | -13.3% | 1,055 | -0.1% | 0.02% | -21.1% |
AZN | Sell | AstraZeneca PLCsponsored adr | $118,645 | -6.7% | 1,752 | -1.4% | 0.01% | -12.5% |
WEC | Sell | WEC Energy Group Inc | $110,998 | -9.6% | 1,378 | -1.0% | 0.01% | -18.8% |
Sell | GE HealthCare Technologies Inc | $106,279 | -16.3% | 1,562 | -0.1% | 0.01% | -25.0% | |
YUMC | Sell | Yum China Holdings Inc | $100,909 | -1.8% | 1,811 | -0.4% | 0.01% | -7.7% |
WY | Sell | Weyerhaeuser Co | $100,013 | -12.5% | 3,262 | -4.4% | 0.01% | -20.0% |
TIP | Sell | ISHARES TRUSTtips bd etf | $105,276 | -19.5% | 1,015 | -16.5% | 0.01% | -29.4% |
WERN | Exit | Werner Enterprises Inc | $0 | – | -2,500 | -100.0% | -0.01% | – |
DAVA | Exit | Endava PLCads | $0 | – | -2,108 | -100.0% | -0.01% | – |
MCHP | Exit | Microchip Technology Inc | $0 | – | -1,261 | -100.0% | -0.02% | – |
IWS | Exit | BlackRock Fund Advisorsrus mdcp val etf | $0 | – | -1,288 | -100.0% | -0.02% | – |
IWM | Exit | ISHARESrussell 2000 etf | $0 | – | -800 | -100.0% | -0.02% | – |
Exit | Target Corp | $0 | – | -1,179 | -100.0% | -0.02% | – | |
IWR | Exit | BlackRock Fund Advisorsrus mid cap etf | $0 | – | -2,500 | -100.0% | -0.02% | – |
CCI | Exit | Crown Castle Inc | $0 | – | -1,850 | -100.0% | -0.03% | – |
HHC | Exit | Howard Hughes Corp/The | $0 | – | -4,571 | -100.0% | -0.05% | – |
DG | Exit | Dollar General Corp | $0 | – | -2,542 | -100.0% | -0.06% | – |
Original filings
The following EDGAR filing(s) were analyzed to create this report:
- View 13F-HR filed 2023-10-26
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.