2024-05-02T08:50:02-05:00 2023-12-31 990PF 2023-01-01 866716399 JOSEPH D AND SARA M HANSBERRY CHARITABLE TRUST % JOSEPH D HANSBERRY JOSE 8157080395 N2347 ALTA VISTA DR LAKE GENEVA WI 531473836 JOSEPH D HANSBERRY TRUSTEE 8154204100 2024-05-02 JOSEPH HANSBERRY XXX-XX-XXXX false 1 AAL2 IAL1 2023 2023-04-26 12:10:37Z X 907754 X 184681 12277 12277 9619 9619 373193 972701 373193 20581 0 18 18 579788 395107 20581 0 0 4708 1417 3291 10552 74 0 0 15260 1491 3291 250000 250000 265260 1491 253291 314528 393616 20581 56861 24545 24545 55136 62628 62655 0 0 0 297968 781058 819373 147513 1174 1181 0 0 0 0 0 0 557478 869405 907754 0 0 0 X 557478 869405 557478 869405 557478 869405 557478 314528 0 872006 2601 869405 373193 20581 5471 0 5471 5471 5682 0 5682 X 5 206 206 false false false false false false false false true true WI true false false false false true JOSEPH D HANSBERRY 7795006102 N2347 ALTA VISTA DRIVE LAKE GENEVA WI 531473836 false false false false false false false false false false false false false false false false false false false false false false false false false false false JOSEPH D HANSBERRY N2347 ALTA VISTA DRIVE LAKE GENEVA WI 53147 TRUSTEE 1.000 0 SARA M HANSBERRY N2347 ALTA VISTA LAKE GENEVA WI 53147 TRUSTEE 1.000 0 NONE 0 NONE 0 308415 362260 0 670675 0 670675 10060 660615 33031 33031 5471 5471 27560 27560 27560 253291 0 253291 27560 264141 264141 253291 0 0 27560 225731 489872 0 489872 264141 225731 0 0 0 0 0 0 0 0 0 0 NONE NONE X MAYO CLINIC 200 FIRST ST SW ROCHESTER MN 55905 PC LEADERSHIP FUND IN DIVERSITY HEALTH EQUITY 250000 250000 14 12277 14 9619 18 18 18 373193 395107 395107 1a NA false false false false false false false false false false X X 1 JOSEPH D HANSBERRY N2347 ALTA VISTA DR LAKE GENEVA WI 53147 36200 X 2 JOSEPH D HANSBERRY N2347 ALTA VISTA DR LAKE GENEVA WI 53147 148481 X X 2 PUBLICLY TRADED SECURITIES 498852 2023-12-13 PUBLICLY TRADED SECURITIE 2022-07 2023-05 05312023 466248 445483 20765 PUBLICLY TRADED SECURITIE 2015-12 2023-12 12142023 501093 148481 352612 PUBLICLY TRADED SECURITIE 2023-02 2023-10 10022023 5360 5544 -184 MAINSTAY FLOATING RATE FUND 133 SHARES 1174 1181 SPDR SP 500 ETF TRUST 25 SHARES 10463 11883 ISHARES TR SP MIDCAP 400 INDEX 8 SHARES 2123 2217 ISHARES RUSSELL 200 INDEX FUND 14 SHARES 2669 2810 ISHARES MSCI EFE INDEX FD 33 SHARES 2342 2486 BNY MELLON GLOBAL EMERGING MARKETS 48 SHARES 906 968 NASDAQ 100 INDEX FUND INVESCO QQQ TRUST ETF 70 SHARES 26801 28682 SP 500 INDEX FUND SPDR SP 500 EFT TRUST 1435 SHARES 655901 684805 MSCI EAFE INDEX FUND ISHARES MSCI EAFE ETF 1135 SHARES 79853 85522 ACCRUED INCOME 2377 TAX PENALTIES 222 ROUNDING ADJUSTMENT 2 ISHARES SP GSCI COMMODITY INDEXED TR K1 18 18 NORTHERN TRUSTINVEST FEE 1277 1277 NORTHERN TRUSTBANKING FE 58 58 BNY INVEST FEE 140 140 FOLEY 3233 3233 FOREIGN TAX PAIDNO TRUST 7 7 FOREIGN TAX PAIDGOLDMAN 67 67 2022 TAX RETURN 4796 2023 ESTIMATED TAX 5682