2025-11-05T09:01:34-06:00 2025-06-30 920460586 PWC US TAX LLP 301 GRANT STREET 45TH FLOOR PITTSBURGH PA 15219 990PF 2024-07-01 363918216 SHERRARD BILL & SUSAN FOUNDATION SHER 8887304933 PO BOX 505 MAC H0006-092 SAINT LOUIS MO 63166 - TRUSTEE 8887304933 2025-10-15 true true LAURA B STROBEL P01271955 4123556000 2025-10-15 X 2024 2025-03-06 01:10:19Z X 5855324 X 47905 47905 125050 125050 111306 757 430563 757 0 173712 173712 30458 22844 7615 0 0 0 0 0 0 921 921 0 0 3616 572 0 0 0 0 0 0 0 13768 13753 15 48763 38090 0 7630 265000 265000 313763 38090 0 272630 -140051 135622 0 261 146744 29648 29648 0 0 0 193027 287137 552703 1630591 1514161 5272973 1970623 1830946 5855324 0 X 1970623 1830946 1970623 1830946 1970623 1830946 1970623 -140051 378 1830950 4 1830946 622. ISHARES CORE U.S. AGGREGATE ETF 2019-10-31 2024-07-23 60994 70294 -9300 -9300 225. ISHARES CORE TOTAL BOND ETF 2021-01-14 2024-07-23 10270 12117 -1847 -1847 22. SUNCOR ENERGY INC NEW F 2022-10-18 2024-07-23 848 641 207 207 2. UNITEDHEALTH GROUP INC 2024-03-26 2024-07-23 1110 975 135 135 10. VANGUARD MIDCAP VIPER 2020-05-15 2024-07-23 2506 1469 1037 1037 742. ISHARES CORE U.S. AGGREGATE ETF 2019-05-14 2024-09-05 74878 83060 -8182 -8182 26. ISHARES CORE MSCI EAFE ETF 2023-05-17 2024-09-05 1970 1776 194 194 338. ISHARES CORE TOTAL BOND ETF 2021-02-22 2024-09-05 15867 18093 -2226 -2226 1. ELI LILLY & CO COM 2024-07-23 2024-09-05 941 873 68 68 272. PIMCO ENHANCED SHORT MATURITY ETF 2023-05-17 2024-09-05 27254 27040 214 214 6. VANGUARD MIDCAP VIPER 2020-05-15 2024-09-05 1519 881 638 638 3.99983 ALPHABET INC CL C 2024-07-23 2024-09-26 660 737 -77 -77 8.00017 ALPHABET INC CL C 2024-07-23 2024-09-26 1320 1474 -154 -154 19. BROADCOM INC 2024-07-23 2024-09-26 3402 3102 300 300 1. BROADCOM INC 2019-07-03 2024-09-26 179 28 151 151 2. META PLATFORMS INC 2024-07-23 2024-09-26 1150 984 166 166 121. TORONTO DOMINION BK ONT COM NEW 2019-05-14 2024-09-26 7626 6767 859 859 4. GARMIN LTD 2024-09-05 2024-09-26 696 725 -29 -29 3. GARMIN LTD 2020-08-26 2024-09-26 522 314 208 208 9. ADVANCED MICRO DEVICES INC 2024-06-11 2024-11-08 1343 1427 -84 -84 4. ALPHABET INC CL C 2024-07-02 2024-11-08 728 718 10 10 4. AMAZON COM INC COM 2024-09-26 2024-11-08 839 778 61 61 6. BLACKSTONE INC 2024-09-05 2024-11-08 1063 837 226 226 12. BLACKSTONE INC 2020-08-26 2024-11-08 2126 897 1229 1229 14. BROADCOM INC 2019-07-03 2024-11-08 2581 398 2183 2183 16. CITIGROUP INC. 2024-09-26 2024-11-08 1098 982 116 116 61. INVESCO OPTIMUM YIELD DIVERSIF ETF 2022-07-23 2024-11-08 829 1067 -238 -238 190. ISHARES CORE U.S. AGGREGATE ETF 2019-05-14 2024-11-08 18709 20699 -1990 -1990 206. ISHARES CORE TOTAL BOND ETF 2021-02-22 2024-11-08 9450 11027 -1577 -1577 6. JPMORGAN CHASE & CO 2024-09-05 2024-11-08 1434 1321 113 113 2. JPMORGAN CHASE & CO 2010-05-03 2024-11-08 478 87 391 391 14. LAM RESH CORP 2024-07-23 2024-11-08 1104 1357 -253 -253 69. MANULIFE FINANCIAL CORP 2020-08-26 2024-11-08 2194 1047 1147 1147 3. MICROSOFT CORP 2024-07-23 2024-11-08 1276 1332 -56 -56 86. REGIONS FINL CORP NEW 2022-06-24 2024-11-08 2180 1737 443 443 43. VANGUARD RUSSELL 2000 2024-09-05 2024-11-08 4109 3699 410 410 26. VANGUARD MIDCAP VIPER 2020-05-15 2024-11-08 7140 3819 3321 3321 3. EATON CORP PLC 2024-07-23 2024-11-08 1086 966 120 120 26. CELANESE CORP 2024-11-08 2025-02-28 1310 2293 -983 -983 58. CELANESE CORP 2020-04-03 2025-02-28 2922 4299 -1377 -1377 131. CISCO SYSTEMS INC 2010-12-21 2025-02-28 8310 2566 5744 5744 79. MERCK & CO INC NEW 2017-09-20 2025-02-28 7199 4857 2342 2342 6. GARMIN LTD 2020-08-26 2025-02-28 1356 628 728 728 5. ALPHABET INC CL C 2024-07-02 2025-03-04 842 890 -48 -48 19. ALPHABET INC CL C 2016-06-28 2025-03-04 3199 643 2556 2556 3. META PLATFORMS INC 2024-07-23 2025-03-04 1913 1476 437 437 2. META PLATFORMS INC 2021-04-08 2025-03-04 1275 623 652 652 6. LAM RESH CORP 2024-07-23 2025-03-04 457 582 -125 -125 5. LAM RESH CORP 2020-08-26 2025-03-04 381 176 205 205 10. UNITED PARCEL SERVICE-CL B 2024-09-26 2025-03-04 1182 1336 -154 -154 2. UNITED PARCEL SERVICE-CL B 2022-10-18 2025-03-04 236 337 -101 -101 142. FIRST TRUST GLOBAL TACTICAL 2023-08-10 2025-03-20 3599 3460 139 139 80. GOLDMAN SACHS ACTIVEBETA INT ETF 2021-07-26 2025-03-20 2932 2817 115 115 81. ISHARES CORE U.S. AGGREGATE ETF 2019-05-14 2025-03-20 8010 8824 -814 -814 396. ISHARES IBOXX $ INVESTMENT 2024-11-08 2025-03-20 43222 43518 -296 -296 25. ISHARES JP MORGAN USD EMERGING 2022-04-21 2025-03-20 2289 2345 -56 -56 51. ISHARES CORE MSCI EAFE ETF 2024-11-08 2025-03-20 3958 3771 187 187 51. ISHARES CORE MSCI EAFE ETF 2023-05-17 2025-03-20 3958 3483 475 475 394. ISHARES CORE TOTAL BOND ETF 2021-02-22 2025-03-20 18131 21091 -2960 -2960 37. VANGUARD MORTGAGE-BACKED SEC ETF 2024-07-23 2025-03-20 1712 1702 10 10 13. ALPHABET INC CL C 2024-07-18 2025-03-25 2228 2176 52 52 21. ALPHABET INC CL C 2016-06-28 2025-03-25 3600 711 2889 2889 10. BLACKSTONE INC 2025-03-20 2025-03-25 1523 1480 43 43 1. BLACKSTONE INC 2020-08-26 2025-03-25 152 54 98 98 32. CITIGROUP INC. 2024-09-26 2025-03-25 2386 2194 192 192 21. CITIGROUP INC. 2020-04-03 2025-03-25 1566 815 751 751 11. JPMORGAN CHASE & CO 2025-03-20 2025-03-25 2742 2602 140 140 11.00765 REGIONS FINL CORP NEW 2024-09-05 2025-03-25 245 252 -7 -7 46.99235 REGIONS FINL CORP NEW 2024-09-05 2025-03-25 1046 1075 -29 -29 39. SUNCOR ENERGY INC NEW F 2024-09-05 2025-03-25 1501 1490 11 11 14. SUNCOR ENERGY INC NEW F 2021-12-17 2025-03-25 539 371 168 168 9. TARGET CORP 2024-09-26 2025-03-25 962 1411 -449 -449 26. TARGET CORP 2003-11-10 2025-03-25 2780 1018 1762 1762 33. TOTAL S.A. - ADR 2024-07-23 2025-03-25 2100 2166 -66 -66 1. TOTAL S.A. - ADR 2023-06-15 2025-03-25 64 59 5 5 7. UNITED PARCEL SERVICE-CL B 2024-09-26 2025-04-30 664 935 -271 -271 40. UNITED PARCEL SERVICE-CL B 2017-02-21 2025-04-30 3795 3967 -172 -172 542. FIRST TRUST GLOBAL TACTICAL 2023-08-10 2025-06-18 14006 13207 799 799 757 1885 0 1885 0 1885 2636 0 0 2636 0 751 751 0 false false false false false false false true true IL true false false false false true N/A WELLS FARGO BANK NA 8003523705 100 N MAIN ST FL 5D4001-052 WINSTON SALEM NC 27101 false false false false true false false false false false false false false false false false false false false false false false WELLS FARGO BANK N A 100 N MAIN ST FL 5D4001-052 WINSTONSALEM NC 27101 TRUSTEE 1 30458 NONE 0 NONE 0 5393239 136822 0 5530061 0 0 5530061 82951 5447110 272356 272356 1885 1885 270471 0 270471 0 270471 272630 0 0 0 0 272630 270471 260388 0 0 0 0 0 0 0 272630 260388 0 0 12242 0 0 0 0 0 0 0 0 258229 0 0 0 0 0 0 0 0 NONE NONE THE BILL AND SUSAN SHERRARD FOUNDAT C/O WELLS FARGO BANK WINSTON SALEM NC 27101 8887304933 N/A ONLINE GRANT APPLICATION OR THE ALTERNATIVE ACCESSIBLE APPLICATION s://www.wellsfargo.com/private-foundations/sherrard-foundation/ OCTOBER 15 HENRY COUNTY, ILLINOIS ORGANIZATIONS FOCUSED ON EDUCATIONAL ASSISTANCE HISTORICAL PRESERVATION, RELIGION HILLCREST HOME 915 WEST 1ST STREET SUMNER IL 50674 NONE PC GENERAL OPERATING 53000 GENESEO HISTORICAL ASSOCIATION 205 S STATE ST GENESEO IL 61254 NONE PC GENERAL OPERATING 39750 GENESEO ENDOWMENT FOR EXCELLENCE PO BOX 211 GENESEO IL 612540211 NONE PC GENERAL OPERATING 132500 CONCORDIA EVANGELICAL LUTHERAN CHURCH 316 S OAKWOOD AVE GENESEO IL 61254 NONE PC GENERAL OPERATING 39750 265000 14 47905 16 111306 18 757 159968 159968 false false false false false false false false false false 89151E109 TOTALENERGIES SE -SP 7013 9761 02079K107 ALPHABET INC CL C 4165 21819 150870103 CELANESE CORP 11135F101 BROADCOM INC 4045 28116 75513E101 RTX CORP 7674 13142 097023105 BOEING CO 7832 11524 09260D107 BLACKSTONE INC 3032 8376 192446102 COGNIZANT TECH SOLUT 3574 4838 H2906T109 GARMIN LTD 3704 7514 904767704 UNILEVER PLC - ADR 5857 7340 532457108 ELI LILLY & CO COM 3054 14032 58933Y105 MERCK & CO INC NEW 907818108 UNION PACIFIC CORP 4152 6902 00287Y109 ABBVIE INC 5969 9095 609207105 MONDELEZ INTERNATION 3603 5665 91324P102 UNITEDHEALTH GROUP I 4673 8735 512807108 LAM RESEARCH CORP CO 172967424 CITIGROUP INC. 4560 10470 46625H100 JPMORGAN CHASE & CO 3063 19134 H84989104 TE CONNECTIVITY LTD 30303M102 META PLATFORMS INC 8097 28047 56501R106 MANULIFE FINANCIAL C 4748 9652 09247X101 BLACKROCK INC G29183103 EATON CORP PLC 5066 12138 891160509 TORONTO DOMINION BK 883556102 THERMO FISHER SCIENT 1563 5271 911312106 UNITED PARCEL SERVIC 94106L109 WASTE MANAGEMENT INC 4615 8466 867224107 SUNCOR ENERGY INC NE 5757 10523 17275R102 CISCO SYSTEMS INC 594918104 MICROSOFT CORP 7213 51731 92826C839 VISA INC-CLASS A SHR 6853 13137 037833100 APPLE INC 11104 40008 87612E106 TARGET CORP 7591EP100 REGIONS FINL CORP NE 4543 5457 00724F101 ADOBE INC 7273 5803 007903107 ADVANCED MICRO DEVIC 4730 6811 437076102 HOME DEPOT INC 7067 8066 580135101 MCDONALDS CORP 8334 8473 855244109 STARBUCKS CORP COM 5954 5406 023135106 AMAZON COM INC COM 21251 24352 032654105 ANALOG DEVICES INC 7200 7379 43300A203 HILTON WORLDWIDE HOL 7206 9056 002824100 ABBOTT LABS 6256 6256 084670702 BERKSHIRE HATHAWAY I 8447 7772 09290D101 BLACKROCK INC 2593 8394 278865100 ECOLAB INC 6951 7005 49338L103 KEYSIGHT TECHNOLOGIE 5129 4916 512807306 LAM RESH CORP 1349 8274 571748102 MARSH & MCLENNAN COS 7961 7652 620076307 MOTOROLA SOLUTIONS, 8639 8409 64110L106 NETFLIX INC 4902 6696 67066G104 NVIDIA CORP 6492 9795 90353T100 UBER TECHNOLOGIES IN 6693 8397 931142103 WALMART INC 5126 5769 98419M100 XYLEM INC/NY 3896 4140 G87052109 TE CONNECTIVITY PLC 2674 6578 N07059210 ASML HOLDING NV-NY R 5485 6411 46090F100 INVESCO OPTIMUM YIEL AT COST 33149 27306 464287226 ISHARES CORE U.S. AG AT COST 219424 210006 REG044564 320.00 ACRE HENRY CN AT COST 704000 4400000 922908629 VANGUARD MIDCAP VIPE AT COST 83878 149989 74440Y884 PGIM HIGH YIELD-Q 10 AT COST 32129 28532 46434V613 ISHARES CORE TOTAL B AT COST 103992 98008 464288281 ISHARES JP MORGAN US AT COST 71183 70762 381430107 GOLDMAN SACHS ACTIVE AT COST 25583 29864 46432F842 ISHARES CORE MSCI EA AT COST 72593 88739 72201R833 PIMCO ENHANCED SHORT 33739H101 FIRST TRUST GLOBAL T AT COST 13404 13717 46435U853 ISHARES BROAD USD HI AT COST 56748 57203 92206C664 VANGUARD RUSSELL 200 AT COST 43383 44133 92206C771 VANGUARD MORTGAGE-BA AT COST 41598 41938 98149E303 SPDR GOLD MINISHARES AT COST 13097 12776 ROUNDING 4 FILING FEE/STATE TAX 15 0 15 INVESTMENT EXPENSES - ADR FEES 9 9 0 Rent and Royalty Expense 13744 MUTUAL FUND TIMING ADJ 378 INVESTMNT MNGMNT FEES (NON-DED 921 921 FOREIGN TAXES 548 548 0 FEDERAL TAX PAYMENT - PRIOR YE 408 0 0 FEDERAL ESTIMATES - PRINCIPAL 2636 0 0 FOREIGN TAXES ON NONQUALIFIED 24 24 0