$659 Million is the total value of Hills Bank & Trust Co's 371 reported holdings in Q2 2021. The portfolio turnover from Q1 2021 to Q2 2021 was 9.0% .
Value | Shares | ↓ Weighting | ||||||
---|---|---|---|---|---|---|---|---|
AAPL | Sell | Apple Inc | $21,672,000 | +11.7% | 158,236 | -0.4% | 3.29% | +4.4% |
PG | Sell | Procter & Gamble Co/The | $16,360,000 | -1.8% | 121,246 | -1.4% | 2.48% | -8.2% |
FAST | Sell | Fastenal Co | $12,141,000 | +2.7% | 233,481 | -0.7% | 1.84% | -4.1% |
HD | Sell | Home Depot Inc/The | $11,520,000 | +3.4% | 36,125 | -1.0% | 1.75% | -3.4% |
JPM | Sell | JPMorgan Chase & Co | $9,750,000 | +1.6% | 62,688 | -0.6% | 1.48% | -5.1% |
JNJ | Sell | Johnson & Johnson | $7,967,000 | -0.5% | 48,363 | -0.7% | 1.21% | -7.0% |
TMO | Sell | Thermo Fisher Scientific Inc | $7,499,000 | +9.4% | 14,865 | -1.0% | 1.14% | +2.2% |
ICE | Sell | INTERCONTINENTAL EXCHANGE | $7,372,000 | +5.8% | 62,109 | -0.4% | 1.12% | -1.1% |
NVDA | Sell | NVIDIA Corp | $7,148,000 | +48.4% | 8,934 | -1.0% | 1.08% | +38.6% |
INTC | Sell | Intel Corp | $7,125,000 | -12.8% | 126,901 | -0.6% | 1.08% | -18.6% |
ITW | Sell | ILLINOIS TOOL WKS | $6,951,000 | +0.3% | 31,089 | -0.7% | 1.05% | -6.3% |
FISV | Sell | FISERV INC | $6,796,000 | -13.2% | 63,577 | -3.3% | 1.03% | -18.8% |
PEP | Sell | PEPSICO INC | $6,083,000 | +4.1% | 41,057 | -0.6% | 0.92% | -2.8% |
MCD | Sell | MCDONALD'S CORP | $6,036,000 | +2.2% | 26,130 | -0.8% | 0.92% | -4.5% |
DIS | Sell | Walt Disney Co/The | $5,644,000 | -4.9% | 32,109 | -0.2% | 0.86% | -11.2% |
CVS | Sell | CVS Health Corp | $4,235,000 | +10.8% | 50,758 | -0.1% | 0.64% | +3.5% |
ZBH | Sell | ZIMMER HLDGS INC | $3,962,000 | -0.1% | 24,635 | -0.5% | 0.60% | -6.7% |
EL | Sell | Estee Lauder Cos Inc/Thecl a | $3,709,000 | +8.5% | 11,660 | -0.8% | 0.56% | +1.3% |
PYPL | Sell | PayPal Holdings Inc | $3,350,000 | +18.6% | 11,495 | -1.2% | 0.51% | +10.9% |
ANSS | Sell | ANSYS, INC. | $3,337,000 | +2.0% | 9,614 | -0.2% | 0.51% | -4.7% |
CMCSA | Sell | Comcast Corpcl a | $3,289,000 | +5.1% | 57,676 | -0.2% | 0.50% | -1.8% |
ALL | Sell | Allstate Corp/The | $3,209,000 | +8.7% | 24,605 | -4.2% | 0.49% | +1.7% |
XOM | Sell | Exxon Mobil Corp | $3,173,000 | +12.8% | 50,297 | -0.1% | 0.48% | +5.5% |
XLB | Sell | SELECT SECTOR SPDRsbi materials | $3,012,000 | +3.8% | 36,598 | -0.6% | 0.46% | -3.0% |
NSC | Sell | Norfolk Southern Corp | $3,007,000 | -1.8% | 11,331 | -0.6% | 0.46% | -8.2% |
CVX | Sell | Chevron Corp | $2,963,000 | -0.9% | 28,283 | -0.9% | 0.45% | -7.4% |
TROW | Sell | T Rowe Price Group Inc | $2,885,000 | +13.4% | 14,575 | -1.7% | 0.44% | +5.8% |
ORCL | Sell | ORACLE CORP | $2,844,000 | +3.8% | 36,532 | -6.4% | 0.43% | -3.1% |
KLAC | Sell | KLA Corp | $2,579,000 | -5.8% | 7,955 | -4.0% | 0.39% | -12.1% |
BMY | Sell | BRISTOL-MYRS SQUIB | $2,577,000 | +3.5% | 38,553 | -2.3% | 0.39% | -3.2% |
LNT | Sell | Alliant Energy Corp | $2,576,000 | +2.9% | 46,207 | -0.0% | 0.39% | -3.7% |
SPGI | Sell | S&P Global Inc | $2,576,000 | +15.6% | 6,276 | -0.6% | 0.39% | +8.0% |
IHF | Sell | BlackRock Fund Advisorsus hlthcr pr etf | $2,512,000 | +5.1% | 9,426 | -0.8% | 0.38% | -1.8% |
MDLZ | Sell | Kraft Foods Inccl a | $2,488,000 | +4.9% | 39,848 | -1.6% | 0.38% | -2.1% |
ILMN | Sell | Illumina Inc | $2,407,000 | +22.0% | 5,086 | -1.0% | 0.36% | +14.1% |
C | Sell | Citigroup Inc | $2,366,000 | -3.3% | 33,439 | -0.5% | 0.36% | -9.6% |
QCOM | Sell | QUALCOMM INC | $2,261,000 | +7.1% | 15,824 | -0.6% | 0.34% | 0.0% |
BDX | Sell | BECTON DICKINSON | $2,068,000 | -3.8% | 8,502 | -3.8% | 0.31% | -10.0% |
ROP | Sell | ROPER INDUSTRIES INC | $2,048,000 | +15.3% | 4,356 | -1.1% | 0.31% | +8.0% |
DCI | Sell | Donaldson Co Inc | $2,013,000 | +6.8% | 31,685 | -2.2% | 0.30% | -0.3% |
ADP | Sell | AUTOMATIC DATA PROCESSING | $1,970,000 | +4.5% | 9,917 | -0.9% | 0.30% | -2.3% |
XLNX | Sell | XILINX INC | $1,868,000 | -1.8% | 12,917 | -15.8% | 0.28% | -8.4% |
VZ | Sell | VERIZON COMMUN | $1,731,000 | -8.9% | 30,903 | -5.4% | 0.26% | -14.9% |
IAK | Sell | BlackRock Fund Advisorsu.s. insrnce etf | $1,661,000 | +2.8% | 21,465 | -1.3% | 0.25% | -3.8% |
HON | Sell | Honeywell International Inc | $1,571,000 | +0.3% | 7,163 | -0.8% | 0.24% | -6.3% |
MKL | Sell | Markel Corp | $1,538,000 | +3.9% | 1,296 | -0.2% | 0.23% | -2.9% |
ACN | Sell | ACCENTURE | $1,424,000 | +5.8% | 4,831 | -0.9% | 0.22% | -0.9% |
HTLD | Sell | Heartland Express Inc | $1,385,000 | -15.7% | 80,865 | -3.6% | 0.21% | -21.3% |
IBM | Sell | INTL BUSINESS MCHN | $1,345,000 | +7.4% | 9,175 | -2.3% | 0.20% | +0.5% |
MMC | Sell | MARSH & MCLENNAN | $1,252,000 | +13.5% | 8,900 | -1.7% | 0.19% | +6.1% |
UNP | Sell | Union Pacific Corp | $1,190,000 | -1.7% | 5,411 | -1.4% | 0.18% | -8.2% |
SBUX | Sell | STARBUCKS CORP | $1,162,000 | -5.8% | 10,392 | -7.9% | 0.18% | -12.0% |
MS | Sell | MORGAN STANLEY | $1,124,000 | +16.1% | 12,251 | -1.7% | 0.17% | +8.3% |
BND | Sell | Vanguard Group Inc/Thetotal bnd mrkt | $1,021,000 | -47.1% | 11,893 | -47.8% | 0.16% | -50.5% |
TDTT | Sell | FlexShares ETFs/USAiboxx 3r targt | $958,000 | -0.2% | 36,158 | -0.6% | 0.14% | -7.1% |
PBE | Sell | Invesco Capital Management LLCdynmc biotech | $809,000 | +2.8% | 10,460 | -1.9% | 0.12% | -3.9% |
ALXN | Sell | Alexion Pharmaceuticals Inc | $785,000 | +3.8% | 4,273 | -13.6% | 0.12% | -3.3% |
AON | Sell | Aon PLC | $766,000 | +3.1% | 3,210 | -0.6% | 0.12% | -4.1% |
SYK | Sell | Stryker Corp | $689,000 | +4.1% | 2,652 | -2.5% | 0.10% | -2.8% |
DG | Sell | Dollar General Corp | $599,000 | +4.5% | 2,765 | -2.2% | 0.09% | -2.2% |
CI | Sell | Cigna Corp | $575,000 | -2.7% | 2,428 | -0.7% | 0.09% | -9.4% |
CTSH | Sell | COGNIZANT TECHNOLOcl a | $548,000 | -11.5% | 7,918 | -0.1% | 0.08% | -17.0% |
CLX | Sell | Clorox Co/The | $543,000 | -10.8% | 3,016 | -4.5% | 0.08% | -17.2% |
JPIB | Sell | JP Morgan ETFs/USAintl bd opp etf | $529,000 | -51.7% | 10,270 | -51.9% | 0.08% | -55.1% |
SLB | Sell | Schlumberger NV | $501,000 | +17.3% | 15,644 | -0.5% | 0.08% | +10.1% |
YUM | Sell | YUM BRANDS INC | $480,000 | -0.4% | 4,177 | -6.2% | 0.07% | -6.4% |
HAL | Sell | HALLIBURTON | $449,000 | +7.4% | 19,402 | -0.3% | 0.07% | 0.0% |
TRMB | Sell | Trimble Inc | $388,000 | +3.5% | 4,737 | -1.9% | 0.06% | -3.3% |
BAX | Sell | BAXTER INTL INC | $368,000 | -6.1% | 4,567 | -1.6% | 0.06% | -12.5% |
T | Sell | AT&T INC | $365,000 | -16.7% | 12,674 | -12.4% | 0.06% | -22.5% |
XEL | Sell | Xcel Energy Inc | $358,000 | -4.3% | 5,438 | -3.2% | 0.05% | -11.5% |
LMT | Sell | Lockheed Martin Corp | $359,000 | -27.5% | 949 | -29.1% | 0.05% | -32.5% |
STZ | Sell | Constellation Brands Inccl a | $290,000 | +2.5% | 1,238 | -0.2% | 0.04% | -4.3% |
XLK | Sell | SELECT SECTOR SPDRtechnology | $272,000 | +5.8% | 1,845 | -4.6% | 0.04% | -2.4% |
BAC | Sell | BK OF AMERICA CORP | $270,000 | +6.3% | 6,527 | -0.6% | 0.04% | 0.0% |
NVS | Sell | Novartis AGsponsored adr | $267,000 | +3.9% | 2,923 | -2.8% | 0.04% | -4.8% |
AWK | Sell | American Water Works Co Inc | $237,000 | -11.9% | 1,537 | -14.2% | 0.04% | -18.2% |
FDX | Sell | FEDEX CORP | $234,000 | +4.5% | 787 | -0.3% | 0.04% | -2.8% |
VTI | Sell | Vanguard ETF/USAtotal stk mkt | $211,000 | +0.5% | 945 | -6.9% | 0.03% | -5.9% |
ENV | Sell | Envestnet Inc | $213,000 | -60.5% | 2,817 | -62.2% | 0.03% | -63.2% |
DOV | Sell | Dover Corp | $203,000 | +9.1% | 1,350 | -0.4% | 0.03% | +3.3% |
MRK | Sell | Merck & Co Inc | $199,000 | -51.6% | 2,559 | -52.0% | 0.03% | -55.2% |
AMGN | Sell | Amgen Inc | $188,000 | -2.6% | 771 | -0.5% | 0.03% | -6.5% |
YUMC | Sell | Yum China Holdings Inc | $184,000 | +8.9% | 2,782 | -2.4% | 0.03% | +3.7% |
GIS | Sell | General Mills Inc | $159,000 | -1.9% | 2,605 | -1.5% | 0.02% | -7.7% |
UNH | Sell | UnitedHealth Group Inc | $155,000 | -14.4% | 388 | -20.2% | 0.02% | -17.2% |
KMB | Sell | KIMBERLY-CLARK CP | $153,000 | -10.0% | 1,143 | -6.6% | 0.02% | -17.9% |
ISTB | Sell | BlackRock Fund Advisorscore 1 5 yr usd | $137,000 | -11.0% | 2,670 | -11.0% | 0.02% | -16.0% |
VEA | Sell | Vanguard ETF/USAftse dev mkt etf | $129,000 | +3.2% | 2,503 | -1.7% | 0.02% | 0.0% |
BIV | Sell | Vanguard ETF/USAintermed term | $123,000 | -2.4% | 1,370 | -3.6% | 0.02% | -5.0% |
URI | Sell | United Rentals Inc | $112,000 | -3.4% | 350 | -0.6% | 0.02% | -10.5% |
SPSM | Exit | SPDR SER TRportfolio s&p600 | $0 | – | -2,899 | -100.0% | -0.02% | – |
PRO | Exit | PROS HOLDINGS INC | $0 | – | -3,225 | -100.0% | -0.02% | – |
JHML | Exit | John Hancock Advisers LLCmltfctr lrg cap | $0 | – | -2,840 | -100.0% | -0.02% | – |
LQD | Exit | ISHARESiboxx inv cp etf | $0 | – | -1,071 | -100.0% | -0.02% | – |
Exit | First Trust Advisors LPpfd secs inc etf | $0 | – | -7,657 | -100.0% | -0.02% | – | |
AEP | Exit | American Electric Power Co Inc | $0 | – | -2,287 | -100.0% | -0.03% | – |
DLR | Exit | Digital Realty Trust Inc | $0 | – | -1,456 | -100.0% | -0.03% | – |
Exit | Edwards Lifesciences Corp | $0 | – | -4,900 | -100.0% | -0.07% | – | |
SLF | Exit | SUN LIFE FINL INC | $0 | – | -14,000 | -100.0% | -0.12% | – |
Original filings
The following EDGAR filing(s) were analyzed to create this report:
- View 13F-HR filed 2021-08-02
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.