$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 8.2% .
| Value | Shares | ↓ Weighting | ||||||
|---|---|---|---|---|---|---|---|---|
| SPY | Sell | SPDR S&P 500 ETF TRUSTother | $57,476,000 | -1.5% | 218,416 | -0.1% | 17.34% | +1.4% |
| TDTT | Buy | FLEXSHARES IBOXX 3-YEAR TARGother | $24,544,000 | +4.8% | 1,006,281 | +4.6% | 7.40% | +7.9% |
| MDY | Buy | SPDR S&P MIDCAP 400 ETF TRUSTother | $18,869,000 | -0.2% | 55,216 | +0.9% | 5.69% | +2.7% |
| HD | Sell | HOME DEPOT INC | $7,880,000 | -6.0% | 44,207 | -0.1% | 2.38% | -3.2% |
| IJR | Buy | ISHARES CORE S&P SMALL-CAP ETFother | $7,754,000 | +3.1% | 100,685 | +2.8% | 2.34% | +6.1% |
| 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% |
| FISV | Buy | FISERV INC | $6,111,000 | +6.2% | 85,700 | +95.4% | 1.84% | +9.4% |
| GUNR | Buy | FLEXSHARES GLOBAL UPSTREAM Nother | $5,984,000 | +33.0% | 183,695 | +35.9% | 1.80% | +36.8% |
| EFA | Buy | ISHARES MSCI EAFE ETFother | $5,803,000 | -0.9% | 83,280 | +0.0% | 1.75% | +2.0% |
| PEP | Sell | PEPSICO INC | $5,761,000 | -10.9% | 52,787 | -2.1% | 1.74% | -8.2% |
| GOOG | Buy | ALPHABET INC CL C | $5,701,000 | +0.7% | 5,525 | +2.1% | 1.72% | +3.7% |
| 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% |
| DIS | Buy | DISNEY WALT CO NEW | $2,381,000 | -3.9% | 23,710 | +2.9% | 0.72% | -1.1% |
| ZBH | Buy | ZIMMER BIOMET HOLDINGS INC | $2,362,000 | -8.0% | 21,662 | +1.8% | 0.71% | -5.3% |
| SBUX | Buy | STARBUCKS CORP | $2,252,000 | +4.4% | 38,896 | +3.6% | 0.68% | +7.4% |
| C | Buy | CITIGROUP INC | $2,196,000 | -8.7% | 32,540 | +0.6% | 0.66% | -6.0% |
| ESRX | Buy | EXPRESS SCRIPTS HLDG | $2,153,000 | -6.3% | 31,155 | +1.2% | 0.65% | -3.4% |
| 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% |
| PANW | Buy | PALO ALTO NETWORKS INC | $1,869,000 | +25.8% | 10,297 | +0.4% | 0.56% | +29.7% |
| 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% |
| BRKA | BERKSHIRE HATHAWAY INC CLASS A | $1,795,000 | +0.5% | 6 | 0.0% | 0.54% | +3.6% | |
| CVX | Sell | CHEVRON CORPORATION | $1,721,000 | -10.9% | 15,090 | -2.1% | 0.52% | -8.3% |
| SCHW | Buy | CHARLES SCHWAB CORP | $1,700,000 | +1.9% | 32,564 | +0.3% | 0.51% | +4.9% |
| PFE | Sell | PFIZER INC | $1,682,000 | -3.6% | 47,389 | -1.6% | 0.51% | -0.8% |
| SLB | Buy | SCHLUMBERGER LTD | $1,633,000 | -3.0% | 25,211 | +0.9% | 0.49% | -0.2% |
| AMT | Buy | AMERICAN TOWER CORP REITother | $1,534,000 | +7.0% | 10,553 | +5.1% | 0.46% | +10.2% |
| HTLD | HEARTLAND EXPRESS INC | $1,521,000 | -22.9% | 84,540 | 0.0% | 0.46% | -20.7% | |
| ALL | Buy | ALLSTATE CORP | $1,503,000 | +4.6% | 15,855 | +15.5% | 0.45% | +7.6% |
| QCOM | Sell | QUALCOMM INC | $1,487,000 | -13.8% | 26,839 | -0.4% | 0.45% | -11.3% |
| ADS | Buy | ALLIANCE DATA SYSTEMS CORP | $1,454,000 | -12.0% | 6,829 | +4.8% | 0.44% | -9.3% |
| ABT | Buy | ABBOTT LABS | $1,414,000 | +25.8% | 23,606 | +19.9% | 0.43% | +29.8% |
| NSC | Buy | NORFOLK SOUTHERN CORP | $1,395,000 | -1.6% | 10,275 | +5.0% | 0.42% | +1.2% |
| 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% |
| BIIB | Buy | BIOGEN INC | $1,337,000 | -12.7% | 4,882 | +1.6% | 0.40% | -10.2% |
| MDLZ | Buy | MONDELEZ INTERNATIONAL INC | $1,323,000 | +16.8% | 31,693 | +19.7% | 0.40% | +20.2% |
| ORCL | Buy | ORACLE CORPORATION | $1,301,000 | -1.0% | 28,434 | +2.3% | 0.39% | +2.1% |
| BMY | Buy | BRISTOL MYERS SQUIBB CO | $1,221,000 | +21.5% | 19,302 | +17.7% | 0.37% | +24.7% |
| 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% |
| CELG | Buy | CELGENE CORP | $1,148,000 | -8.5% | 12,873 | +7.2% | 0.35% | -6.0% |
| COST | Buy | COSTCO WHOLESALE CORP | $1,145,000 | +32.1% | 6,074 | +30.4% | 0.34% | +35.8% |
| 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% |
| SHPG | Buy | SHIRE PLC SPONS ADR | $1,036,000 | +12.1% | 6,931 | +16.3% | 0.31% | +15.5% |
| MAS | Buy | MASCO CORP | $1,022,000 | -4.6% | 25,260 | +3.7% | 0.31% | -1.9% |
| SLF | SUN LIFE FINANCIAL INC | $905,000 | -0.3% | 22,000 | 0.0% | 0.27% | +2.6% | |
| ETFC | Buy | ETRADE FINANCIAL CORP | $850,000 | +57.4% | 15,330 | +40.6% | 0.26% | +62.0% |
| GWW | Buy | WW GRAINGER INC | $838,000 | +25.1% | 2,968 | +4.8% | 0.25% | +29.1% |
| DUK | Buy | DUKE ENERGY CORP | $800,000 | -6.9% | 10,331 | +1.1% | 0.24% | -4.4% |
| 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% |
| ALXN | Buy | ALEXION PHARMACEUTICALS INC | $690,000 | +11.8% | 6,188 | +19.9% | 0.21% | +14.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% |
| AON | Buy | AON PLC | $484,000 | +10.3% | 3,451 | +5.4% | 0.15% | +13.2% |
| 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% |
| KO | Buy | COCA COLA CO | $429,000 | +19.5% | 9,871 | +26.1% | 0.13% | +22.9% |
| EL | Sell | LAUDER ESTEE COS CL-A | $429,000 | +13.8% | 2,865 | -3.4% | 0.13% | +17.3% |
| CSCO | Buy | CISCO SYSTEMS INC | $427,000 | +12.7% | 9,951 | +0.8% | 0.13% | +16.2% |
| ABBV | Buy | ABBVIE INC | $422,000 | +14.1% | 4,466 | +16.8% | 0.13% | +17.6% |
| GIS | Sell | GENERAL MILLS INC. | $411,000 | -61.0% | 9,125 | -48.7% | 0.12% | -59.9% |
| YUM | Buy | YUM! BRANDS INC | $404,000 | +6.9% | 4,745 | +2.6% | 0.12% | +9.9% |
| STZ | CONSTELLATION BRANDS INC | $388,000 | -0.3% | 1,700 | 0.0% | 0.12% | +2.6% | |
| 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% |
| AFL | Buy | AFLAC INC | $379,000 | -0.3% | 8,670 | +100.0% | 0.11% | +2.7% |
| CCL | Buy | CARNIVAL CORP | $373,000 | +19.2% | 5,685 | +20.4% | 0.11% | +22.8% |
| NVS | Sell | NOVARTIS AG SPONS ADR | $369,000 | -56.3% | 4,565 | -54.6% | 0.11% | -55.1% |
| AXP | AMERICAN EXPRESS CO | $364,000 | -5.9% | 3,900 | 0.0% | 0.11% | -2.7% | |
| LMT | Buy | LOCKHEED MARTIN CORP | $346,000 | +10.5% | 1,025 | +5.1% | 0.10% | +13.0% |
| HAL | New | HALLIBURTON CO | $340,000 | – | 7,260 | +100.0% | 0.10% | – |
| AMZN | Buy | AMAZON.COM INC | $320,000 | +55.3% | 221 | +25.6% | 0.10% | +61.7% |
| WMT | Buy | WALMART INC | $303,000 | -5.6% | 3,405 | +4.8% | 0.09% | -3.2% |
| 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% |
| WBA | Buy | WALGREENS BOOTS ALLIANCE INC | $293,000 | +9.7% | 4,476 | +21.8% | 0.09% | +12.8% |
| BRKB | Buy | BERKSHIRE HATHAWAY INC-CL B | $286,000 | +2.5% | 1,432 | +1.8% | 0.09% | +4.9% |
| IDXX | Sell | IDEXX LABS INC | $281,000 | +7.3% | 1,464 | -12.8% | 0.08% | +10.4% |
| ACN | ACCENTURE PLC CL A | $280,000 | +0.4% | 1,825 | 0.0% | 0.08% | +2.4% | |
| TWTR | Sell | TWITTER INC | $257,000 | -27.2% | 8,855 | -39.9% | 0.08% | -24.3% |
| MDU | MDU RESOURCES GROUP INC | $253,000 | +4.5% | 9,000 | 0.0% | 0.08% | +7.0% | |
| ADM | ARCHER DANIELS MIDLAND CO | $247,000 | +8.3% | 5,698 | 0.0% | 0.08% | +11.9% | |
| DGX | Sell | QUEST DIAGNOSTICS INC | $248,000 | +0.4% | 2,475 | -1.4% | 0.08% | +4.2% |
| V | Buy | VISA INC CL A | $241,000 | +10.6% | 2,011 | +5.2% | 0.07% | +14.1% |
| 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% |
| DEO | DIAGEO PLC SPONS ADR | $229,000 | -7.3% | 1,692 | 0.0% | 0.07% | -4.2% | |
| IJH | ISHARES CORE S&P MID-CAP ETFother | $212,000 | -1.4% | 1,131 | 0.0% | 0.06% | +1.6% | |
| BAC | New | BANK OF AMERICA CORP | $211,000 | – | 7,019 | +100.0% | 0.06% | – |
| HRL | HORMEL FOODS CORPORATION | $212,000 | -5.4% | 6,167 | 0.0% | 0.06% | -3.0% | |
| RPG | New | GUGGENHEIM S&P 500 PURE GROWother | $205,000 | – | 1,871 | +100.0% | 0.06% | – |
| 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 | 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.