2024-11-04T17:01:16-06:00 2024-06-30 920460586 PWC US TAX LLP 301 GRANT STREET 45TH FLOOR PITTSBURGH PA 15219 990PF 2023-07-01 363918216 SHERRARD BILL & SUSAN FOUNDATION SHER 8887304933 PO BOX 505 MAC H0006-092 SAINT LOUIS MO 63166 - TRUSTEE 8887304933 2024-10-16 true true LAURA B STROBEL P01271955 4123556000 2024-10-16 X 2023 2024-10-15 13:58:12Z X 5497073 X 48798 48798 125050 125050 113619 51551 213390 51551 0 225399 225399 30373 22780 7593 0 0 0 0 0 0 858 858 0 0 2855 649 0 0 0 0 0 0 0 11455 11440 15 45541 35727 0 7608 255000 255000 300541 35727 0 262608 -75142 189672 0 49 261 261 163813 146744 146744 0 0 0 222334 193027 434982 1659962 1630591 4915086 2046158 1970623 5497073 0 X 2046158 1970623 2046158 1970623 2046158 1970623 2046158 -75142 2 1971018 395 1970623 4. APPLE INC 2020-04-03 2023-08-10 718 240 478 478 1. BROADCOM INC 2021-07-26 2023-08-10 853 482 371 371 763. INVESCO OPTIMUM YIELD DIVERSIF ETF 2022-08-10 2023-08-10 11234 13200 -1966 -1966 1288. INVESCO OPTIMUM YIELD DIVERSIF ETF 2022-03-31 2023-08-10 18963 24218 -5255 -5255 3. MICROSOFT CORP 2002-05-26 2023-08-10 978 80 898 898 26. VANGUARD MIDCAP VIPER 2020-05-15 2023-08-10 5802 3819 1983 1983 7. CELANESE CORP 2023-06-15 2023-12-15 1059 808 251 251 7. CELANESE CORP 2022-10-18 2023-12-15 1059 714 345 345 117. INTERPUBLIC GROUP COS INC 2020-10-26 2023-12-15 3827 2213 1614 1614 7. ELI LILLY & CO COM 2016-10-11 2023-12-15 3946 572 3374 3374 36. RTX CORP 2021-07-06 2023-12-15 2890 3213 -323 -323 8. EATON CORP PLC 2021-04-08 2023-12-15 1879 1122 757 757 5. ABBVIE INC 2021-07-06 2024-01-25 820 556 264 264 2. ADOBE SYS INC 2023-06-15 2024-01-25 1231 958 273 273 19. ALPHABET INC CL C 2016-06-28 2024-01-25 2887 713 2174 2174 15. APPLE INC 2020-04-03 2024-01-25 2930 902 2028 2028 4. BLACKSTONE INC 2023-02-09 2024-01-25 490 368 122 122 5. BLACKSTONE INC 2020-08-26 2024-01-25 613 271 342 342 14. CISCO SYSTEMS INC 2010-12-21 2024-01-25 724 274 450 450 20. CITIGROUP INC. 2020-10-26 2024-01-25 1068 864 204 204 3. META PLATFORMS INC 2021-04-02 2024-01-25 1170 943 227 227 7. JPMORGAN CHASE & CO 2020-08-26 2024-01-25 1206 697 509 509 45. MANULIFE FINANCIAL CORP 2020-08-26 2024-01-25 978 683 295 295 8. MERCK & CO INC NEW 2023-06-15 2024-01-25 952 875 77 77 9. MICROSOFT CORP 2002-05-26 2024-01-25 3641 240 3401 3401 11. MONDELEZ INTERNATIONAL INC 2018-07-17 2024-01-25 817 472 345 345 41. REGIONS FINL CORP NEW 2022-08-22 2024-01-25 793 884 -91 -91 2. THERMO FISHER SCIENTIFIC INC 2023-06-15 2024-01-25 1086 1056 30 30 12. TORONTO DOMINION BK ONT COM NEW 2021-07-26 2024-01-25 733 792 -59 -59 1. UNITED PARCEL SERVICE-CL B 2023-02-09 2024-01-25 159 185 -26 -26 4. UNITED PARCEL SERVICE-CL B 2021-10-13 2024-01-25 635 769 -134 -134 1. UNITEDHEALTH GROUP INC 2023-06-15 2024-01-25 489 468 21 21 2. UNITEDHEALTH GROUP INC 2013-04-15 2024-01-25 978 591 387 387 385. VANGUARD LONG-TERM BOND ETF 2023-01-25 2024-01-25 27753 29808 -2055 -2055 4. VISA INC-CLASS A SHRS 2021-12-17 2024-01-25 1086 851 235 235 14. GARMIN LTD 2020-08-26 2024-01-25 1747 1465 282 282 5. ABBVIE INC 2021-10-12 2024-02-12 867 542 325 325 6. ADVANCED MICRO DEVICES INC 2023-06-15 2024-02-12 1053 744 309 309 19. ALPHABET INC CL C 2016-06-28 2024-02-12 2845 643 2202 2202 13. APPLE INC 2020-04-03 2024-02-12 2444 782 1662 1662 1. BLACKROCK INC 2014-07-15 2024-02-12 807 324 483 483 6. BLACKSTONE INC 2023-03-17 2024-02-12 782 510 272 272 3. BOEING CO 2023-12-15 2024-02-12 626 775 -149 -149 1. BOEING CO 2022-10-18 2024-02-12 209 139 70 70 1. BOOKING HOLDINGS INC 2021-07-26 2024-02-12 3814 2204 1610 1610 3. BROADCOM INC 2019-07-03 2024-02-12 3800 1069 2731 2731 6. CELANESE CORP 2023-06-15 2024-02-12 918 692 226 226 9. COGNIZANT TECH SOLUTIONS CRP COM 2016-08-24 2024-02-12 686 519 167 167 6. DIAGEO PLC - ADR 2016-12-19 2024-02-12 883 782 101 101 7. ELECTRONIC ARTS INC 2020-04-03 2024-02-12 979 727 252 252 2. META PLATFORMS INC 2021-04-02 2024-02-12 947 626 321 321 82. FIRST TRUST GLOBAL TACTICAL 2023-08-10 2024-02-12 1898 1998 -100 -100 45. GOLDMAN SACHS ACTIVEBETA INT ETF 2021-07-26 2024-02-12 1472 1585 -113 -113 3. HOME DEPOT INC 2024-01-25 2024-02-12 1101 1053 48 48 116. INVESCO OPTIMUM YIELD DIVERSIF ETF 2022-08-10 2024-02-12 1553 2007 -454 -454 185. ISHARES CORE U.S. AGGREGATE ETF 2019-11-18 2024-02-12 18070 21099 -3029 -3029 14.99946 ISHARES JP MORGAN USD EMERGING 2022-04-21 2024-02-12 1314 1407 -93 -93 30.00054 ISHARES JP MORGAN USD EMERGING 2022-04-21 2024-02-12 2628 2814 -186 -186 82. ISHARES CORE MSCI EAFE ETF 2023-05-17 2024-02-12 5766 5646 120 120 66.0005 ISHARES CORE TOTAL BOND ETF 2021-02-22 2024-02-12 2997 3533 -536 -536 100.9995 ISHARES CORE TOTAL BOND ETF 2021-02-01 2024-02-12 4586 5497 -911 -911 8. JPMORGAN CHASE & CO 2010-05-03 2024-02-12 1412 628 784 784 2. LAM RESEARCH CORP COM 2020-08-26 2024-02-12 1826 702 1124 1124 3. ELI LILLY & CO COM 2016-10-11 2024-02-12 2193 245 1948 1948 32. MANULIFE FINANCIAL CORP 2020-08-26 2024-02-12 726 486 240 240 3. MCDONALDS CORP 2023-06-15 2024-02-12 870 874 -4 -4 6. MERCK & CO INC NEW 2021-08-30 2024-02-12 751 459 292 292 9. MICROSOFT CORP 2002-05-26 2024-02-12 3761 236 3525 3525 8. NIKE INC CL B 2017-10-24 2024-02-12 855 427 428 428 15. PIMCO ENHANCED SHORT MATURITY ETF 2024-01-25 2024-02-12 1502 1505 -3 -3 5. TARGET CORP 2003-11-10 2024-02-12 750 196 554 554 12. TOTAL S.A. - ADR 2023-06-15 2024-02-12 776 706 70 70 15. UNILEVER PLC - ADR 2020-04-03 2024-02-12 758 713 45 45 2. UNITEDHEALTH GROUP INC 2013-04-15 2024-02-12 1032 124 908 908 30. VANGUARD MIDCAP VIPER 2020-05-15 2024-02-12 7078 4406 2672 2672 6. EATON CORP PLC 2021-04-08 2024-02-12 1646 841 805 805 7. TE CONNECTIVITY LTD 2021-11-19 2024-02-12 1013 1123 -110 -110 33. ISHARES CORE U.S. AGGREGATE ETF 2019-10-31 2024-02-21 3199 3829 -630 -630 8. ISHARES JP MORGAN USD EMERGING 2022-04-21 2024-02-21 697 750 -53 -53 31. ISHARES CORE MSCI EAFE ETF 2023-05-17 2024-02-21 2197 2117 80 80 31. ISHARES CORE TOTAL BOND ETF 2021-01-14 2024-02-21 1398 1700 -302 -302 8. RTX CORP 2019-09-10 2024-02-21 722 665 57 57 7. VANGUARD MIDCAP VIPER 2020-05-15 2024-02-21 1637 1028 609 609 3. VISA INC-CLASS A SHRS 2021-11-19 2024-02-21 826 613 213 213 10. ADVANCED MICRO DEVICES INC 2023-02-09 2024-03-26 1795 834 961 961 33. DIAGEO PLC - ADR 2016-12-19 2024-03-26 4854 3425 1429 1429 36. NIKE INC CL B 2017-10-24 2024-03-26 3356 1922 1434 1434 7. EATON CORP PLC 2020-11-03 2024-03-26 2182 805 1377 1377 2. BOOKING HOLDINGS INC 2020-03-04 2024-06-11 7559 3370 4189 4189 2. BROADCOM INC 2019-07-03 2024-06-11 2863 569 2294 2294 33. ELECTRONIC ARTS INC 2018-12-21 2024-06-11 4472 3139 1333 1333 2. LAM RESEARCH CORP COM 2020-08-26 2024-06-11 1976 702 1274 1274 7. EATON CORP PLC 2020-11-03 2024-06-11 2233 776 1457 1457 12. GARMIN LTD 2020-08-26 2024-06-11 1930 1256 674 674 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 CAPITAL GAIN DIVIDENDS P 41 51551 2636 0 2636 0 2636 2228 0 0 2228 0 408 0 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 5 D4001-052 WINSTONSALEM NC 27101 TRUSTEE 1 30373 NONE 0 NONE 0 5347699 160500 0 5508199 0 0 5508199 82623 5425576 271279 271279 2636 2636 268643 0 268643 0 268643 262608 0 0 0 0 262608 268643 254353 0 0 0 0 0 0 0 262608 254353 0 0 8255 0 0 0 0 0 0 0 0 260388 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 39443 BISHOP HILL HERITAGE ASSOCIATION PO BOX 92 BISHOP HILL IL 614190092 NONE PC GENERAL OPERATING 2000 GENESEO HISTORICAL ASSOCIATION 205 S STATE ST GENESEO IL 612541454 NONE PC GENERAL OPERATING 38250 GENESEO PUBLIC LIBRARY DISTRICT 805 N CHICAGO ST GENESEO IL 61254 NONE PC GENERAL OPERATING 3331 GENESEO ENDOWMENT FOR EXCELLENCE PO BOX 211 GENESEO IL 612540211 NONE PC GENERAL OPERATING 125500 HAMMONDHENRY HOSPITAL FOUNDATION 600 N COLLEGE AVE GENESEO IL 612541091 NONE PC GENERAL OPERATING 8226 CONCORDIA EVANGELICAL LUTHERAN CHURCH 316 S OAKWOOD AVE Geneseo IL 61254 NONE PC GENERAL OPERATING 38250 255000 14 48798 16 113619 18 51551 213968 213968 false false false false false false false false false false 31620M106 FIDELITY NATL INFORM 89151E109 TOTALENERGIES SE -SP 7072 10669 02079K107 ALPHABET INC CL C 5520 29897 150870103 CELANESE CORP 4299 7824 G5960L103 MEDTRONIC PLC 11135F101 BROADCOM INC 3130 17661 75513E101 RTX CORP 5528 7429 097023105 BOEING CO 5051 6916 09260D107 BLACKSTONE INC 3983 8542 192446102 COGNIZANT TECH SOLUT 3574 4216 H2906T109 GARMIN LTD 3808 6680 126650100 CVS HEALTH CORPORATI 904767704 UNILEVER PLC - ADR 5093 5884 532457108 ELI LILLY & CO COM 1308 14486 517834107 LAS VEGAS SANDS CORP 58933Y105 MERCK & CO INC NEW 4857 9780 907818108 UNION PACIFIC CORP 2423 5204 00287Y109 ABBVIE INC 4329 7032 609207105 MONDELEZ INTERNATION 3603 5497 871829107 SYSCO CORP 91324P102 UNITEDHEALTH GROUP I 2335 12222 512807108 LAM RESEARCH CORP CO 1524 9584 654106103 NIKE INC CL B 172967424 CITIGROUP INC. 5375 9138 46625H100 JPMORGAN CHASE & CO 2913 13551 H84989104 TE CONNECTIVITY LTD 2674 5867 30303M102 META PLATFORMS INC 6971 18656 56501R106 MANULIFE FINANCIAL C 4788 8998 09247X101 BLACKROCK INC 2593 6299 G29183103 EATON CORP PLC 2993 8466 891160509 TORONTO DOMINION BK 6767 6650 405217100 HAIN CELESTIAL GROUP 25243Q205 DIAGEO PLC - ADR 09857L108 BOOKING HOLDINGS INC 254687106 WALT DISNEY CO 883556102 THERMO FISHER SCIENT 526 6083 911312106 UNITED PARCEL SERVIC 4304 5748 94106L109 WASTE MANAGEMENT INC 3707 7040 867224107 SUNCOR ENERGY INC NE 6769 12078 418056107 HASBRO INC 17275R102 CISCO SYSTEMS INC 2566 6224 594918104 MICROSOFT CORP 2403 41119 285512109 ELECTRONIC ARTS INC 92826C839 VISA INC-CLASS A SHR 5158 8399 037833100 APPLE INC 6253 36437 460690100 INTERPUBLIC GROUP CO 87612E106 TARGET CORP 1018 3849 7591EP100 REGIONS FINL CORP NE 5225 5431 00724F101 ADOBE INC 6160 7222 007903107 ADVANCED MICRO DEVIC 4294 7299 437076102 HOME DEPOT INC 6003 6541 580135101 MCDONALDS CORP 7409 6626 855244109 STARBUCKS CORP COM 5954 4593 023135106 AMAZON COM INC COM 10097 10436 032654105 ANALOG DEVICES INC 6324 6163 43300A203 HILTON WORLDWIDE HOL 6346 6546 46434G103 ISHARES CORE MSCI EM 46090F100 INVESCO OPTIMUM YIEL AT COST 32623 28564 464287226 ISHARES CORE U.S. AG AT COST 402302 364207 464287655 ISHARES RUSSELL 2000 REG044564 320.00 ACRE HENRY CN AT COST 704000 4000000 922908629 VANGUARD MIDCAP VIPE AT COST 59139 111366 74440Y884 PGIM HIGH YIELD-Q 10 AT COST 32129 27649 46434V613 ISHARES CORE TOTAL B AT COST 166320 148457 464288281 ISHARES JP MORGAN US AT COST 72152 68484 381430107 GOLDMAN SACHS ACTIVE AT COST 28400 28030 46432F842 ISHARES CORE MSCI EA AT COST 77851 82810 72201R833 PIMCO ENHANCED SHORT AT COST 27040 27377 921937793 VANGUARD LONG-TERM B 33739H101 FIRST TRUST GLOBAL T AT COST 28635 28142 MUTUAL FUND TIMING ADJ 394 TAX LOT BASIS ADJUSTMENT 1 FILING FEE/STATE TAX 15 0 15 INVESTMENT EXPENSES - ADR FEES 9 9 0 Rent and Royalty Expense 11431 ROUNDING 2 INVESTMNT MNGMNT FEES (NON-DED 858 858 FOREIGN TAXES 627 627 0 FEDERAL ESTIMATES - PRINCIPAL 2206 0 0 FOREIGN TAXES ON NONQUALIFIED 22 22 0