$331 Million is the total value of Hills Bank & Trust Co's 249 reported holdings in Q1 2018. The portfolio turnover from Q4 2017 to Q1 2018 was 10.3% .
| Value | Shares | ↓ Weighting | ||||||
|---|---|---|---|---|---|---|---|---|
| SPY | Sell | SPDR S&P 500 ETF TRUSTother | $57,476,000 | -1.5% | 218,416 | -0.1% | 17.34% | +1.4% |
| HD | Sell | HOME DEPOT INC | $7,880,000 | -6.0% | 44,207 | -0.1% | 2.38% | -3.2% |
| PG | Sell | PROCTER & GAMBLE CO | $6,858,000 | -15.3% | 86,508 | -1.8% | 2.07% | -12.8% |
| AAPL | Sell | APPLE INC | $6,745,000 | -2.3% | 40,198 | -1.5% | 2.04% | +0.5% |
| ITW | Sell | ILLINOIS TOOL WKS INC | $6,615,000 | -8.4% | 42,231 | -2.4% | 2.00% | -5.6% |
| MSFT | Sell | MICROSOFT CORP | $6,198,000 | +5.8% | 67,913 | -0.9% | 1.87% | +8.9% |
| JPM | Sell | JP MORGAN CHASE & CO | $6,173,000 | +1.1% | 56,138 | -1.7% | 1.86% | +4.1% |
| PEP | Sell | PEPSICO INC | $5,761,000 | -10.9% | 52,787 | -2.1% | 1.74% | -8.2% |
| NKE | Sell | NIKE INC-CLASS B | $5,596,000 | +5.4% | 84,230 | -0.8% | 1.69% | +8.5% |
| JNJ | Sell | JOHNSON & JOHNSON | $5,293,000 | -10.6% | 41,310 | -2.6% | 1.60% | -8.0% |
| INTC | Sell | INTEL CORP | $5,172,000 | +11.1% | 99,318 | -1.5% | 1.56% | +14.4% |
| ICE | Sell | INTERCONTINENTAL EXCHANGE INC | $4,924,000 | +1.6% | 67,901 | -1.2% | 1.49% | +4.6% |
| MCD | Sell | MCDONALDS CORP | $4,888,000 | -10.0% | 31,258 | -0.9% | 1.48% | -7.3% |
| WFC | Sell | WELLS FARGO & CO | $4,589,000 | -15.8% | 87,564 | -2.5% | 1.38% | -13.2% |
| XOM | Sell | EXXONMOBIL CORP | $4,546,000 | -12.3% | 60,935 | -1.7% | 1.37% | -9.7% |
| FAST | Sell | FASTENAL CO | $4,436,000 | -4.3% | 81,274 | -4.2% | 1.34% | -1.5% |
| BDX | Sell | BECTON DICKINSON | $3,790,000 | -3.3% | 17,488 | -4.4% | 1.14% | -0.3% |
| TMO | Sell | THERMO FISHER SCIENTIFIC INC | $3,678,000 | +6.2% | 17,819 | -2.3% | 1.11% | +9.4% |
| XLB | Sell | MATERIALS SELECT SPDR FUNDother | $3,342,000 | -11.4% | 58,688 | -5.8% | 1.01% | -8.8% |
| USB | Sell | US BANCORP NEW | $3,315,000 | -10.2% | 65,633 | -4.7% | 1.00% | -7.6% |
| XLE | Sell | ENERGY SELECT SECTOR SPDRother | $2,835,000 | -15.3% | 42,049 | -9.2% | 0.86% | -12.8% |
| IAK | Sell | ISHARES DJ US INSURANCE ETFother | $2,821,000 | -9.7% | 43,708 | -6.8% | 0.85% | -7.0% |
| CVS | Sell | CVS HEALTH CORP | $2,692,000 | -16.0% | 43,278 | -2.0% | 0.81% | -13.5% |
| KSS | Sell | KOHL'S CORP | $2,679,000 | +15.9% | 40,891 | -4.1% | 0.81% | +19.2% |
| TROW | Sell | T ROWE PRICE GROUP INC | $2,467,000 | -3.5% | 22,855 | -6.2% | 0.74% | -0.7% |
| IHF | Sell | ISHARES US HEALTHCARE PROVIDother | $2,072,000 | -1.5% | 13,121 | -2.1% | 0.62% | +1.5% |
| EOG | Sell | EOG RES INC | $1,999,000 | -4.4% | 18,992 | -2.0% | 0.60% | -1.6% |
| DCI | Sell | DONALDSON INC | $1,873,000 | -14.3% | 41,563 | -6.9% | 0.56% | -11.9% |
| FOXA | Sell | TWENTY-FIRST CENTURY FOX INC C | $1,851,000 | +4.6% | 50,456 | -1.5% | 0.56% | +7.7% |
| RHT | Sell | RED HAT INC | $1,823,000 | +20.3% | 12,193 | -3.4% | 0.55% | +23.9% |
| CVX | Sell | CHEVRON CORPORATION | $1,721,000 | -10.9% | 15,090 | -2.1% | 0.52% | -8.3% |
| PFE | Sell | PFIZER INC | $1,682,000 | -3.6% | 47,389 | -1.6% | 0.51% | -0.8% |
| QCOM | Sell | QUALCOMM INC | $1,487,000 | -13.8% | 26,839 | -0.4% | 0.45% | -11.3% |
| STT | Sell | STATE STREET CORP | $1,361,000 | -7.5% | 13,642 | -9.5% | 0.41% | -4.6% |
| CRM | Sell | SALESFORCE.COM | $1,354,000 | +13.2% | 11,646 | -0.5% | 0.41% | +16.5% |
| ADP | Sell | AUTOMATIC DATA PROCESSING INC | $1,200,000 | -3.5% | 10,567 | -0.5% | 0.36% | -0.8% |
| XRAY | Sell | DENTSPLY SIRONA INC | $1,166,000 | -42.4% | 23,178 | -24.6% | 0.35% | -40.6% |
| NUE | Sell | NUCOR CORP | $1,126,000 | -6.1% | 18,427 | -2.3% | 0.34% | -3.1% |
| PYPL | Sell | PAYPAL HOLDINGS INC | $1,082,000 | +0.7% | 14,263 | -2.3% | 0.33% | +3.5% |
| PBE | Sell | POWERSHARES DYN BIOTECH & GENOother | $1,050,000 | -7.3% | 21,325 | -11.3% | 0.32% | -4.5% |
| DE | Sell | DEERE & CO | $798,000 | -2.6% | 5,135 | -1.9% | 0.24% | +0.4% |
| LNT | Sell | ALLIANT CORP | $754,000 | -4.9% | 18,455 | -0.8% | 0.23% | -2.2% |
| UNP | Sell | UNION PAC CORP | $729,000 | -0.1% | 5,420 | -0.5% | 0.22% | +2.8% |
| CTSH | Sell | COGNIZANT TECHNOLOGY SOLUTIONS | $710,000 | +8.2% | 8,830 | -4.3% | 0.21% | +11.5% |
| BAX | Sell | BAXTER INTL INC | $699,000 | -4.9% | 10,746 | -5.5% | 0.21% | -1.9% |
| VZ | Sell | VERIZON COMMUNICATIONS | $659,000 | -21.7% | 13,784 | -13.4% | 0.20% | -19.4% |
| MIDD | Sell | MIDDLEBY CORP | $657,000 | -10.0% | 5,311 | -1.8% | 0.20% | -7.5% |
| CLX | Sell | CLOROX COMPANY | $640,000 | -32.6% | 4,810 | -24.7% | 0.19% | -30.6% |
| CMCSA | Sell | COMCAST CORP-CL A | $641,000 | -20.0% | 18,765 | -6.1% | 0.19% | -17.9% |
| BA | Sell | BOEING CO | $637,000 | +3.2% | 1,942 | -7.2% | 0.19% | +6.1% |
| GE | Sell | GENERAL ELECTRIC CORP | $600,000 | -39.1% | 44,532 | -21.1% | 0.18% | -37.4% |
| DHR | Sell | DANAHER CORP | $586,000 | -4.9% | 5,978 | -9.9% | 0.18% | -2.2% |
| EMR | Sell | EMERSON ELEC CO | $562,000 | -32.7% | 8,222 | -31.3% | 0.17% | -30.6% |
| PM | Sell | PHILIP MORRIS INTERNATIONAL | $509,000 | -6.8% | 5,120 | -1.0% | 0.15% | -3.8% |
| IBM | Sell | INTL. BUSINESS MACHINES CORP | $466,000 | -3.1% | 3,041 | -3.0% | 0.14% | 0.0% |
| SYK | Sell | STRYKER CORPORATION | $467,000 | +3.1% | 2,902 | -0.8% | 0.14% | +6.0% |
| T | Sell | AT&T INC | $453,000 | -36.2% | 12,713 | -30.4% | 0.14% | -34.1% |
| EL | Sell | LAUDER ESTEE COS CL-A | $429,000 | +13.8% | 2,865 | -3.4% | 0.13% | +17.3% |
| GIS | Sell | GENERAL MILLS INC. | $411,000 | -61.0% | 9,125 | -48.7% | 0.12% | -59.9% |
| OMC | Sell | OMNICOM GROUP | $383,000 | -62.0% | 5,269 | -62.0% | 0.12% | -60.8% |
| EBAY | Sell | EBAY INC | $384,000 | -6.6% | 9,541 | -12.4% | 0.12% | -3.3% |
| NVS | Sell | NOVARTIS AG SPONS ADR | $369,000 | -56.3% | 4,565 | -54.6% | 0.11% | -55.1% |
| EW | Sell | EDWARDS LIFESCIENCES CORP | $298,000 | +5.3% | 2,135 | -14.9% | 0.09% | +8.4% |
| ETN | Sell | EATON CORP PLC | $296,000 | -19.1% | 3,700 | -20.0% | 0.09% | -16.8% |
| IDXX | Sell | IDEXX LABS INC | $281,000 | +7.3% | 1,464 | -12.8% | 0.08% | +10.4% |
| TWTR | Sell | TWITTER INC | $257,000 | -27.2% | 8,855 | -39.9% | 0.08% | -24.3% |
| DGX | Sell | QUEST DIAGNOSTICS INC | $248,000 | +0.4% | 2,475 | -1.4% | 0.08% | +4.2% |
| PAYX | Sell | PAYCHEX INC | $240,000 | -11.8% | 3,904 | -2.5% | 0.07% | -10.0% |
| SRCL | Sell | STERICYCLE INC | $234,000 | -22.8% | 3,995 | -10.5% | 0.07% | -20.2% |
| AWK | Sell | AMERICAN WATER WORKS CO INC | $231,000 | -26.4% | 2,812 | -18.2% | 0.07% | -23.9% |
| BP | Exit | BP PLC SPONS ADR | $0 | – | -4,804 | -100.0% | -0.06% | – |
| VIG | Exit | VANGUARD DIVIDEND APPREC ETFother | $0 | – | -2,120 | -100.0% | -0.06% | – |
| CHRW | Exit | CH ROBINSON WORLDWIDE INC | $0 | – | -2,504 | -100.0% | -0.06% | – |
| MO | Exit | ALTRIA GROUP INC | $0 | – | -3,115 | -100.0% | -0.06% | – |
| CDK | Exit | CDK GLOBAL HOLDINGS LLC | $0 | – | -3,235 | -100.0% | -0.07% | – |
| FTV | Exit | FORTIVE CORP | $0 | – | -3,205 | -100.0% | -0.07% | – |
| SU | Exit | SUNCOR ENERGY INC | $0 | – | -6,575 | -100.0% | -0.07% | – |
| MRK | Exit | MERCK & CO INC | $0 | – | -5,666 | -100.0% | -0.09% | – |
Original filings
The following EDGAR filing(s) were analyzed to create this report:
- View 13F-HR filed 2018-04-13
Top long-term holdings
| Name | Quarters owned | Latest quarter owned | Max weighting |
|---|---|---|---|
| State Street ETF/USA | 45 | Q2 2024 | 17.3% |
| STATE STREET ETF/USA | 45 | Q2 2024 | 10.8% |
| Procter & Gamble Co/The | 45 | Q2 2024 | 4.8% |
| ISHARES MSCI EAFE INDEX FUND | 45 | Q2 2024 | 7.6% |
| MICROSOFT CORP | 45 | Q2 2024 | 3.7% |
| APPLE INC | 45 | Q2 2024 | 3.9% |
| Voya Investments LLC | 45 | Q2 2024 | 3.4% |
| Home Depot Inc/The | 45 | Q2 2024 | 2.5% |
| FASTENAL CO | 45 | Q2 2024 | 2.8% |
| PEPSICO INC | 45 | Q2 2024 | 2.7% |
View Hills Bank & Trust Co's complete holdings history.
Latest filings
| Type | Filed |
|---|---|
| N-PX | 2024-08-28 |
| 13F-HR | 2024-07-25 |
| 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 |
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.