$295 Million is the total value of Hills Bank & Trust Co's 249 reported holdings in Q1 2017. The portfolio turnover from Q4 2016 to Q1 2017 was 2.4% .
| Value | Shares | ↓ Weighting | ||||||
|---|---|---|---|---|---|---|---|---|
| SPY | Sell | SPDR S&P 500 ETF TRUSTother | $50,652,000 | +5.3% | 214,864 | -0.2% | 17.19% | +1.7% |
| TDTT | Buy | FLEXSHARES IBOXX 3-YEAR TARGother | $21,235,000 | +11.3% | 851,085 | +10.2% | 7.21% | +7.5% |
| MDY | Sell | SPDR S&P MIDCAP 400 ETF TRUSTother | $17,501,000 | +2.1% | 56,017 | -1.4% | 5.94% | -1.4% |
| PG | Sell | PROCTER & GAMBLE CO | $8,884,000 | +2.9% | 98,872 | -3.7% | 3.02% | -0.6% |
| HD | Sell | HOME DEPOT INC | $6,900,000 | +7.6% | 46,998 | -1.7% | 2.34% | +4.0% |
| IJR | Buy | ISHARES CORE S&P SMALL-CAP ETFother | $6,580,000 | +0.6% | 95,142 | +100.0% | 2.23% | -2.8% |
| PEP | Sell | PEPSICO INC | $6,030,000 | +3.9% | 53,909 | -2.8% | 2.05% | +0.3% |
| ITW | Sell | ILLINOIS TOOL WKS INC | $6,006,000 | +6.5% | 45,343 | -1.6% | 2.04% | +2.9% |
| AAPL | Sell | APPLE INC | $5,929,000 | +23.2% | 41,268 | -0.7% | 2.01% | +19.0% |
| EFA | Sell | ISHARES MSCI EAFE ETFother | $5,516,000 | +6.7% | 88,558 | -1.1% | 1.87% | +3.1% |
| FISV | Sell | FISERV INC | $5,257,000 | +5.1% | 45,592 | -3.2% | 1.78% | +1.5% |
| JNJ | Sell | JOHNSON & JOHNSON | $5,229,000 | +6.7% | 41,981 | -1.3% | 1.78% | +3.1% |
| WFC | Buy | WELLS FARGO & CO | $5,106,000 | +1.7% | 91,725 | +0.6% | 1.73% | -1.8% |
| JPM | Sell | JP MORGAN CHASE & CO | $4,976,000 | +0.6% | 56,644 | -1.1% | 1.69% | -2.8% |
| NKE | Buy | NIKE INC-CLASS B | $4,571,000 | +10.3% | 82,021 | +0.6% | 1.55% | +6.6% |
| XOM | Buy | EXXONMOBIL CORP | $4,553,000 | -8.9% | 55,523 | +0.2% | 1.55% | -12.0% |
| MSFT | Sell | MICROSOFT CORP | $4,515,000 | +5.5% | 68,556 | -0.5% | 1.53% | +2.0% |
| FAST | Sell | FASTENAL CO | $4,457,000 | +9.3% | 86,549 | -0.3% | 1.51% | +5.6% |
| MCD | Sell | MCDONALDS CORP | $4,350,000 | +4.5% | 33,560 | -1.9% | 1.48% | +1.0% |
| GOOG | Buy | ALPHABET INC CL C | $4,242,000 | +9.7% | 5,114 | +2.0% | 1.44% | +6.0% |
| ICE | Sell | INTERCONTINENTAL EXCHANGE INC | $4,165,000 | +5.5% | 69,572 | -0.5% | 1.41% | +2.0% |
| CVS | Buy | CVS HEALTH CORP | $3,601,000 | +0.0% | 45,870 | +0.6% | 1.22% | -3.4% |
| BDX | Sell | BECTON DICKINSON | $3,496,000 | +7.1% | 19,058 | -3.3% | 1.19% | +3.6% |
| XLE | Sell | ENERGY SELECT SECTOR SPDRother | $3,482,000 | -12.4% | 49,813 | -5.7% | 1.18% | -15.4% |
| XLB | Sell | MATERIALS SELECT SPDR FUNDother | $3,426,000 | +2.8% | 65,370 | -2.5% | 1.16% | -0.7% |
| IAK | Sell | ISHARES DJ US INSURANCE ETFother | $2,928,000 | +0.8% | 48,295 | -1.4% | 0.99% | -2.6% |
| TMO | Sell | THERMO FISHER SCIENTIFIC INC | $2,881,000 | +7.2% | 18,754 | -1.6% | 0.98% | +3.6% |
| INTC | Buy | INTEL CORP | $2,640,000 | -0.4% | 73,188 | +0.1% | 0.90% | -3.8% |
| DIS | Sell | DISNEY WALT CO NEW | $2,283,000 | +7.7% | 20,140 | -0.9% | 0.78% | +4.2% |
| DCI | Sell | DONALDSON INC | $2,078,000 | +6.2% | 45,639 | -1.8% | 0.70% | +2.6% |
| ESRX | Buy | EXPRESS SCRIPTS HLDG | $1,990,000 | -3.7% | 30,186 | +0.5% | 0.68% | -6.9% |
| USB | Sell | US BANCORP NEW | $1,980,000 | -5.5% | 38,446 | -5.7% | 0.67% | -8.7% |
| XRAY | Sell | DENTSPLY SIRONA INC | $1,965,000 | +4.7% | 31,474 | -3.2% | 0.67% | +1.2% |
| SBUX | Buy | STARBUCKS CORP | $1,961,000 | +8.6% | 33,585 | +3.3% | 0.67% | +5.0% |
| SLB | Buy | SCHLUMBERGER LTD | $1,962,000 | -5.1% | 25,111 | +1.9% | 0.67% | -8.4% |
| C | Sell | CITIGROUP INC | $1,962,000 | -1.3% | 32,801 | -1.9% | 0.67% | -4.6% |
| QCOM | Buy | QUALCOMM INC | $1,929,000 | -8.6% | 33,632 | +3.8% | 0.66% | -11.7% |
| EOG | Buy | EOG RES INC | $1,909,000 | -2.5% | 19,574 | +1.1% | 0.65% | -5.8% |
| IHF | Sell | ISHARES DJ US HEALTH CAR PRO Eother | $1,831,000 | +6.3% | 13,649 | -0.7% | 0.62% | +2.8% |
| TROW | Sell | T ROWE PRICE GROUP INC | $1,775,000 | -14.9% | 26,048 | -6.0% | 0.60% | -17.7% |
| AGN | Buy | ALLERGAN PLC | $1,691,000 | +21.9% | 7,075 | +7.1% | 0.57% | +17.9% |
| CVX | Sell | CHEVRON CORPORATION | $1,628,000 | -10.9% | 15,162 | -2.4% | 0.55% | -13.9% |
| FOXA | Buy | TWENTY-FIRST CENTURY FOX INC C | $1,609,000 | +21.3% | 49,684 | +5.1% | 0.55% | +17.2% |
| KSS | Buy | KOHL'S CORP | $1,552,000 | -11.3% | 38,982 | +10.0% | 0.53% | -14.2% |
| BRKA | BERKSHIRE HATHAWAY INC CLASS A | $1,499,000 | +2.3% | 6 | 0.0% | 0.51% | -1.2% | |
| OMC | Sell | OMNICOM GROUP | $1,421,000 | -9.8% | 16,480 | -10.9% | 0.48% | -12.8% |
| GIS | Sell | GENERAL MILLS INC. | $1,417,000 | -15.0% | 24,007 | -11.0% | 0.48% | -17.9% |
| GE | Buy | GENERAL ELECTRIC CORP | $1,363,000 | +7.8% | 45,758 | +14.5% | 0.46% | +4.3% |
| CELG | Buy | CELGENE CORP | $1,340,000 | +9.8% | 10,763 | +2.1% | 0.46% | +6.1% |
| ZBH | Buy | ZIMMER BIOMET HOLDINGS INC | $1,309,000 | +27.3% | 10,724 | +7.7% | 0.44% | +23.0% |
| DKS | Buy | DICKS SPORTING GOODS INC | $1,293,000 | -1.0% | 26,572 | +8.0% | 0.44% | -4.4% |
| BIIB | Buy | BIOGEN INC | $1,287,000 | -0.5% | 4,707 | +3.1% | 0.44% | -4.0% |
| SCHW | Buy | CHARLES SCHWAB CORP | $1,253,000 | +4.2% | 30,704 | +0.8% | 0.42% | +0.7% |
| GILD | Sell | GILEAD SCIENCES INC | $1,250,000 | -6.4% | 18,402 | -1.4% | 0.42% | -9.6% |
| STT | Sell | STATE STREET CORP | $1,245,000 | -3.2% | 15,634 | -5.5% | 0.42% | -6.4% |
| ADS | Buy | ALLIANCE DATA SYSTEMS CORP | $1,235,000 | +15.5% | 4,959 | +6.0% | 0.42% | +11.4% |
| AMT | Buy | AMERICAN TOWER CORP REITother | $1,166,000 | +18.4% | 9,586 | +2.9% | 0.40% | +14.5% |
| CLX | Sell | CLOROX COMPANY | $1,160,000 | -25.4% | 8,604 | -33.6% | 0.39% | -27.8% |
| RHT | Buy | RED HAT INC | $1,118,000 | +31.4% | 12,927 | +6.0% | 0.38% | +27.1% |
| ORCL | Buy | ORACLE CORPORATION | $1,118,000 | +33.4% | 25,058 | +15.0% | 0.38% | +29.3% |
| NUE | Sell | NUCOR CORP | $1,085,000 | -5.6% | 18,170 | -5.9% | 0.37% | -8.9% |
| NSC | Buy | NORFOLK SOUTHERN CORP | $1,081,000 | +5.5% | 9,653 | +1.8% | 0.37% | +1.9% |
| PBE | Sell | POWERSHARES DYN BIOTECH & GENOother | $1,076,000 | +6.4% | 25,446 | -2.4% | 0.36% | +2.8% |
| ALL | Sell | ALLSTATE CORP | $1,016,000 | +9.6% | 12,460 | -0.4% | 0.34% | +5.8% |
| NVS | Sell | NOVARTIS AG SPONS ADR | $940,000 | -15.4% | 12,646 | -17.1% | 0.32% | -18.2% |
| NXPI | Sell | NXP SEMICONDUCTORS | $941,000 | +4.3% | 9,090 | -1.3% | 0.32% | +0.6% |
| EMR | Sell | EMERSON ELEC CO | $900,000 | -3.4% | 15,033 | -10.0% | 0.31% | -6.4% |
| CRM | Buy | SALESFORCE.COM | $854,000 | +26.7% | 10,360 | +5.3% | 0.29% | +22.4% |
| T | Sell | AT&T INC | $850,000 | -2.5% | 20,467 | -0.2% | 0.29% | -5.6% |
| SLF | SUN LIFE FINANCIAL INC | $804,000 | -4.9% | 22,000 | 0.0% | 0.27% | -8.1% | |
| MDLZ | Buy | MONDELEZ INTERNATIONAL INC | $795,000 | -1.9% | 18,457 | +1.0% | 0.27% | -5.3% |
| PFE | Sell | PFIZER INC | $792,000 | +4.6% | 23,130 | -0.7% | 0.27% | +1.1% |
| PYPL | Sell | PAYPAL HOLDINGS INC | $782,000 | -32.9% | 18,191 | -38.4% | 0.26% | -35.4% |
| MIDD | MIDDLEBY CORP | $752,000 | +5.9% | 5,511 | 0.0% | 0.26% | +2.4% | |
| CMCSA | Buy | COMCAST CORP-CL A | $742,000 | +8.5% | 19,728 | +99.1% | 0.25% | +5.0% |
| MAS | Buy | MASCO CORP | $743,000 | +22.0% | 21,860 | +13.6% | 0.25% | +17.8% |
| LNT | Sell | ALLIANT CORP | $733,000 | +4.1% | 18,515 | -0.3% | 0.25% | +0.8% |
| DUK | Sell | DUKE ENERGY CORP | $720,000 | +2.7% | 8,775 | -2.7% | 0.24% | -0.8% |
| ATVI | Sell | ACTIVISION BLIZZARD INC | $720,000 | +34.1% | 14,440 | -3.0% | 0.24% | +29.1% |
| ABT | Buy | ABBOTT LABS | $714,000 | +46.6% | 16,071 | +26.7% | 0.24% | +41.5% |
| DHR | Sell | DANAHER CORP | $669,000 | -4.7% | 7,823 | -13.3% | 0.23% | -8.1% |
| COST | Buy | COSTCO WHOLESALE CORP | $655,000 | +14.3% | 3,903 | +8.9% | 0.22% | +10.4% |
| VZ | Sell | VERIZON COMMUNICATIONS | $655,000 | -12.2% | 13,444 | -3.8% | 0.22% | -15.3% |
| BAX | Buy | BAXTER INTL INC | $630,000 | +21.2% | 12,146 | +3.5% | 0.21% | +16.9% |
| CHRW | Sell | CH ROBINSON WORLDWIDE INC | $626,000 | -27.7% | 8,099 | -31.5% | 0.21% | -29.9% |
| DE | Buy | DEERE & CO | $610,000 | +8.5% | 5,606 | +2.7% | 0.21% | +5.1% |
| BCR | Sell | C. R. BARD INC | $603,000 | +8.3% | 2,425 | -2.0% | 0.20% | +4.6% |
| SHPG | Buy | SHIRE PLC SPONS ADR | $593,000 | +12.5% | 3,405 | +10.0% | 0.20% | +8.6% |
| UNP | UNION PAC CORP | $582,000 | +2.1% | 5,495 | 0.0% | 0.20% | -1.0% | |
| TGT | Sell | TARGET CORP | $575,000 | -60.8% | 10,426 | -48.7% | 0.20% | -62.1% |
| ADP | AUTOMATIC DATA PROCESSING INC | $563,000 | -0.5% | 5,500 | 0.0% | 0.19% | -4.0% | |
| CTSH | Sell | COGNIZANT TECHNOLOGY SOLUTIONS | $549,000 | +5.0% | 9,230 | -1.1% | 0.19% | +1.1% |
| EBAY | Sell | EBAY INC | $506,000 | -19.2% | 15,060 | -28.5% | 0.17% | -21.8% |
| HTLD | HEARTLAND EXPRESS INC | $420,000 | -1.4% | 20,942 | 0.0% | 0.14% | -4.7% | |
| MRK | Sell | MERCK & CO INC | $414,000 | +3.8% | 6,525 | -3.7% | 0.14% | +0.7% |
| SRCL | Sell | STERICYCLE INC | $416,000 | +7.5% | 5,018 | -0.2% | 0.14% | +3.7% |
| FTV | Sell | FORTIVE CORP | $407,000 | -18.1% | 6,765 | -26.9% | 0.14% | -21.1% |
| AON | AON PLC | $388,000 | +6.3% | 3,275 | 0.0% | 0.13% | +3.1% | |
| PM | PHILIP MORRIS INTERNATIONAL | $387,000 | +23.6% | 3,423 | 0.0% | 0.13% | +19.1% | |
| ETN | Sell | EATON CORP PLC | $383,000 | -2.8% | 5,175 | -11.9% | 0.13% | -5.8% |
| SYK | STRYKER CORPORATION | $361,000 | +9.7% | 2,745 | 0.0% | 0.12% | +6.0% | |
| KO | Buy | COCA COLA CO | $345,000 | +7.5% | 8,126 | +5.2% | 0.12% | +3.5% |
| IBM | Sell | INTL. BUSINESS MACHINES CORP | $341,000 | +1.8% | 1,953 | -3.0% | 0.12% | -1.7% |
| AXP | Sell | AMERICAN EXPRESS CO | $321,000 | +4.2% | 4,050 | -2.8% | 0.11% | +0.9% |
| BMY | Buy | BRISTOL MYERS SQUIBB CO | $322,000 | +15.8% | 5,919 | +24.2% | 0.11% | +11.2% |
| AWK | Sell | AMERICAN WATER WORKS CO INC | $300,000 | +0.3% | 3,850 | -6.7% | 0.10% | -2.9% |
| WBA | Sell | WALGREENS BOOTS ALLIANCE INC | $292,000 | -7.9% | 3,516 | -8.2% | 0.10% | -10.8% |
| AFL | AFLAC INC | $293,000 | +3.9% | 4,050 | 0.0% | 0.10% | 0.0% | |
| STZ | Sell | CONSTELLATION BRANDS INC | $287,000 | -4.0% | 1,775 | -9.0% | 0.10% | -7.6% |
| IDXX | Sell | IDEXX LABS INC | $277,000 | +26.5% | 1,793 | -4.0% | 0.09% | +22.1% |
| EW | EDWARDS LIFESCIENCES CORP | $278,000 | +0.4% | 2,960 | 0.0% | 0.09% | -3.1% | |
| GWW | New | WW GRAINGER INC | $274,000 | – | 1,175 | +100.0% | 0.09% | – |
| CSCO | Sell | CISCO SYSTEMS INC | $269,000 | +10.2% | 7,955 | -1.5% | 0.09% | +5.8% |
| ABBV | Sell | ABBVIE INC | $269,000 | +1.1% | 4,124 | -3.1% | 0.09% | -2.2% |
| LMT | LOCKHEED MARTIN CORP | $261,000 | +7.0% | 975 | 0.0% | 0.09% | +3.5% | |
| EXC | Sell | EXELON CORP | $260,000 | -18.2% | 7,247 | -19.0% | 0.09% | -21.4% |
| MDU | MDU RESOURCES GROUP INC | $257,000 | -4.8% | 9,400 | 0.0% | 0.09% | -8.4% | |
| DGX | QUEST DIAGNOSTICS INC | $248,000 | +6.9% | 2,525 | 0.0% | 0.08% | +2.4% | |
| PAYX | Sell | PAYCHEX INC | $236,000 | -3.3% | 4,004 | -0.4% | 0.08% | -7.0% |
| WMT | Sell | WAL MART STORES INC | $237,000 | +1.3% | 3,280 | -3.2% | 0.08% | -2.4% |
| YUM | YUM! BRANDS INC | $232,000 | +1.3% | 3,620 | 0.0% | 0.08% | -1.2% | |
| ACN | Sell | ACCENTURE PLC CL A | $231,000 | +0.9% | 1,925 | -1.3% | 0.08% | -2.5% |
| BRKB | BERKSHIRE HATHAWAY INC-CL B | $225,000 | +2.3% | 1,352 | 0.0% | 0.08% | -1.3% | |
| CINF | Sell | CINCINNATI FINL CORP | $213,000 | -9.4% | 2,950 | -4.8% | 0.07% | -13.3% |
| DEO | New | DIAGEO PLC SPONS ADR | $207,000 | – | 1,792 | +100.0% | 0.07% | – |
| SU | Sell | SUNCOR ENERGY INC | $202,000 | -15.8% | 6,575 | -10.2% | 0.07% | -17.9% |
| TWTR | Buy | TWITTER INC | $191,000 | -7.7% | 12,735 | +0.1% | 0.06% | -11.0% |
| TEVA | Exit | TEVA PHARMACEUTICAL INDS SPONS | $0 | – | -15,571 | -100.0% | -0.20% | – |
Original filings
The following EDGAR filing(s) were analyzed to create this report:
- View 13F-HR filed 2017-04-06
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.