$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 1.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% |
| 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% |
| 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% |
| JPM | Sell | JP MORGAN CHASE & CO | $4,976,000 | +0.6% | 56,644 | -1.1% | 1.69% | -2.8% |
| 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% |
| ICE | Sell | INTERCONTINENTAL EXCHANGE INC | $4,165,000 | +5.5% | 69,572 | -0.5% | 1.41% | +2.0% |
| 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% |
| 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% |
| 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% |
| C | Sell | CITIGROUP INC | $1,962,000 | -1.3% | 32,801 | -1.9% | 0.67% | -4.6% |
| 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% |
| CVX | Sell | CHEVRON CORPORATION | $1,628,000 | -10.9% | 15,162 | -2.4% | 0.55% | -13.9% |
| 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% |
| 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% |
| CLX | Sell | CLOROX COMPANY | $1,160,000 | -25.4% | 8,604 | -33.6% | 0.39% | -27.8% |
| NUE | Sell | NUCOR CORP | $1,085,000 | -5.6% | 18,170 | -5.9% | 0.37% | -8.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% |
| T | Sell | AT&T INC | $850,000 | -2.5% | 20,467 | -0.2% | 0.29% | -5.6% |
| 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% |
| 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% |
| DHR | Sell | DANAHER CORP | $669,000 | -4.7% | 7,823 | -13.3% | 0.23% | -8.1% |
| VZ | Sell | VERIZON COMMUNICATIONS | $655,000 | -12.2% | 13,444 | -3.8% | 0.22% | -15.3% |
| CHRW | Sell | CH ROBINSON WORLDWIDE INC | $626,000 | -27.7% | 8,099 | -31.5% | 0.21% | -29.9% |
| BCR | Sell | C. R. BARD INC | $603,000 | +8.3% | 2,425 | -2.0% | 0.20% | +4.6% |
| TGT | Sell | TARGET CORP | $575,000 | -60.8% | 10,426 | -48.7% | 0.20% | -62.1% |
| 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% |
| 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% |
| ETN | Sell | EATON CORP PLC | $383,000 | -2.8% | 5,175 | -11.9% | 0.13% | -5.8% |
| 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% |
| 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% |
| 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% |
| 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% |
| EXC | Sell | EXELON CORP | $260,000 | -18.2% | 7,247 | -19.0% | 0.09% | -21.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% |
| ACN | Sell | ACCENTURE PLC CL A | $231,000 | +0.9% | 1,925 | -1.3% | 0.08% | -2.5% |
| CINF | Sell | CINCINNATI FINL CORP | $213,000 | -9.4% | 2,950 | -4.8% | 0.07% | -13.3% |
| SU | Sell | SUNCOR ENERGY INC | $202,000 | -15.8% | 6,575 | -10.2% | 0.07% | -17.9% |
| 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.