2024-05-15T08:01:13-05:00 2023-12-31 346565596 ERNST & YOUNG US LLP 800 YARD STREET SUITE 200 GRANDVIEW HEIGHTS OH 43212 990PF 2023-01-01 811157275 JOANN & JIM FRANCIS FOUNDATION 15185100 FRAN 8165848183 5313 BLUFF WAY PARKVILLE MO 64152 JAMES R FRANCIS DIRECTOR 8165848183 2024-05-15 true true JOSEPH B HULL P00135850 6142327290 2024-05-15 2023 2023-04-26 12:10:37Z X 2785216 1461661 X 60449 60449 211232 1589987 211232 0 6 6 1733348 271687 14498 7249 7249 0 0 0 0 0 0 0 0 794 794 0 0 0 0 0 0 0 3 15295 8043 0 7249 0 0 15295 8043 0 7249 1718053 263644 0 64190 98630 98630 0 0 0 691542 2060664 2686586 755732 2159294 2785216 0 X 755732 2159294 755732 2159294 755732 2159294 755732 1718053 0 2473785 314491 2159294 15. ABBOTT LABORATORIES 2020-03-23 2023-01-09 1677 932 745 745 9. ABBVIE INC 2020-06-03 2023-01-09 1446 815 631 631 28. ALPHABET INC 2021-10-06 2023-01-09 2465 3840 -1375 -1375 34. AMAZON COM INC 2020-03-23 2023-01-09 2976 3198 -222 -222 9. AMERICAN WATER WORKS CO INC 2020-05-06 2023-01-09 1423 1063 360 360 3. AMGEN INC 2022-12-08 2023-01-09 805 856 -51 -51 21. AMPHENOL CORP CLASS A 2022-06-22 2023-01-09 1660 1334 326 326 3. ELEVANCE HEALTH INC 2022-02-16 2023-01-09 1406 1377 29 29 43. APPLE COMPUTER INC 2020-03-23 2023-01-09 5608 2342 3266 3266 54. BANK OF AMERICA CORP 2020-03-23 2023-01-09 1822 974 848 848 2. BLACKROCK INC 2020-03-23 2023-01-09 1511 658 853 853 4. BROADCOM INC 2020-03-23 2023-01-09 2358 760 1598 1598 9. CATERPILLAR INC 2020-10-07 2023-01-09 2224 1395 829 829 13. CHEVRONTEXACO CORP 2021-03-03 2023-01-09 2276 1354 922 922 5. COSTCO WHOLESALE CORP 2020-03-23 2023-01-09 2397 1397 1000 1000 4. DANAHER CORP 2020-10-07 2023-01-09 1027 888 139 139 5. DEERE & CO 2022-02-16 2023-01-09 2137 1956 181 181 17. DEVON ENERGY CORP 2022-01-25 2023-01-09 1051 872 179 179 9. DISNEY WALT HOLDING CO 2020-03-23 2023-01-09 854 756 98 98 19. DUKE ENERGY CORP 2020-08-05 2023-01-09 1996 1589 407 407 22. EXXON MOBIL CORP 2021-07-07 2023-01-09 2384 1331 1053 1053 10. GILEAD SCIENCES INC 2022-12-08 2023-01-09 846 895 -49 -49 7. HOME DEPOT INC 2020-03-23 2023-01-09 2224 1106 1118 1118 7. HONEYWELL INTERNATIONAL INC 2020-03-23 2023-01-09 1469 711 758 758 17. INTERNATIONAL BUSINESS MACHINES CORP 2021-10-06 2023-01-09 2443 2299 144 144 5. INTUIT INC 2020-03-23 2023-01-09 1974 944 1030 1030 17. J P MORGAN CHASE & CO 2020-03-23 2023-01-09 2329 1338 991 991 12. JOHNSON & JOHNSON 2020-03-23 2023-01-09 2100 1321 779 779 7. LILLY ELI & COMPANY 2022-01-25 2023-01-09 2441 1676 765 765 7. MARRIOTT INTERNATIONAL INC CLASS A 2021-03-03 2023-01-09 1064 1033 31 31 4. MASTERCARD INC - A 2020-03-23 2023-01-09 1482 806 676 676 8. MCDONALDS CORP 2020-11-04 2023-01-09 2134 1723 411 411 20. MICROSOFT CORP 2020-03-23 2023-01-09 4551 2678 1873 1873 30. MORGAN STANLEY DEAN WITTER & CO 2021-02-03 2023-01-09 2621 2085 536 536 26. NEXTERA ENERGY INC 2020-03-23 2023-01-09 2183 1143 1040 1040 9. PEPSICO INC 2020-03-23 2023-01-09 1610 929 681 681 16. PFIZER INC 2020-03-23 2023-01-09 769 426 343 343 9. PRINCIPAL FINANCIAL GROUP 2022-10-19 2023-01-09 774 710 64 64 10. PROCTER & GAMBLE CO 2020-03-23 2023-01-09 1518 949 569 569 40. REALTY INCOME CORP 2021-01-06 2023-01-09 2579 2385 194 194 16. STARBUCKS CORP 2022-09-20 2023-01-09 1671 1455 216 216 14. TEXAS INSTRUMENTS INC 2020-03-23 2023-01-09 2476 1353 1123 1123 10. TRAVELERS COS INC/THE 2020-10-07 2023-01-09 1884 1140 744 744 43. US BANCORP 2022-05-18 2023-01-09 1996 2112 -116 -116 13. UNION PACIFIC CORP 2020-03-23 2023-01-09 2756 1474 1282 1282 9. UNITED PARCEL SERVICE INC CLASS B 2020-03-23 2023-01-09 1634 827 807 807 7. UNITEDHEALTH GROUP INC 2020-03-23 2023-01-09 3423 1331 2092 2092 55. VERIZON COMMUNICATIONS 2021-11-10 2023-01-09 2275 2894 -619 -619 10. WAL MART STORES INC 2020-03-23 2023-01-09 1450 1127 323 323 4. ACCENTURE PLC-CL A 2020-03-23 2023-01-09 1096 563 533 533 12. EATON CORP PLC 2020-11-04 2023-01-09 1933 1278 655 655 7. LINDE PLC/OLD 2020-03-23 2023-01-09 2248 1040 1208 1208 7. CATERPILLAR INC 2020-10-07 2023-01-18 1771 895 876 876 31. DISNEY WALT HOLDING CO 2020-03-23 2023-01-18 3067 2603 464 464 61. DEVON ENERGY CORP 2022-01-25 2023-02-22 3248 3129 119 119 26000. BANKWELL BANK 3.85% 20 APR 2023 2022-10-20 2023-04-20 26000 25998 2 2 428. DEERE & CO 2022-02-16 2023-04-21 165589 40140 125449 125449 32. PRINCIPAL FINANCIAL GROUP 2022-10-19 2023-04-21 2406 2523 -117 -117 158. US BANCORP 2022-09-20 2023-04-21 5286 7336 -2050 -2050 10000. BMO HARRIS BANK NA 4.15% 01 MAY 2023 2022-10-26 2023-05-01 10000 9998 2 2 14. AMERICAN WATER WORKS CO INC 2022-09-20 2023-05-17 2007 2042 -35 -35 22. CATERPILLAR INC 2020-03-23 2023-05-17 4663 2017 2646 2646 8. UNION PACIFIC CORP 2020-03-23 2023-05-17 1590 907 683 683 10. AMGEN INC 2022-12-08 2023-06-21 2271 2853 -582 -582 9. ELEVANCE HEALTH INC 2022-02-16 2023-06-21 4018 4132 -114 -114 61. SCHLUMBERGER LTD 2023-02-22 2023-06-21 2917 3189 -272 -272 13900.574 VANGUARD TTL BD MKT IDX-ADM 2023-01-10 2023-07-12 132611 134052 -1441 -1441 64. APPLE COMPUTER INC 2020-03-23 2023-09-08 11385 3486 7899 7899 8630.919 BLACKROCK STRAT INC OPP-INST 2014-01-02 2023-09-08 78714 86211 -7497 -7497 902.499 COLUMBIA DIVIDEND INCOME-I 2013-11-18 2023-09-08 27039 17898 9141 9141 673.174 DFA US CORE EQTY 1 PORT 2022-10-05 2023-09-08 22673 20000 2673 2673 1232.342 DFA US CORE EQTY 1 PORT 2022-03-31 2023-09-08 41505 30920 10585 10585 1856.269 DFA EMERGING MARKETS PORT 2022-03-31 2023-09-08 49358 52769 -3411 -3411 2270.107 DFA L/C INTERNATIONAL PORTF 2022-03-31 2023-09-08 56253 53360 2893 2893 5222.688 DFA INVESTMENT GRADE PORT 2019-12-12 2023-09-08 51026 59506 -8480 -8480 880. DIMENSIONAL US SMALL CAP ETF 2022-12-09 2023-09-08 47414 46118 1296 1296 390. FS KKR CAPITAL CORP. COM 2013-01-09 2023-09-08 8016 15601 -7585 -7585 493.955 FIDELITY ADV HEALTH CARE-I 2021-12-20 2023-09-08 31613 24002 7611 7611 1366. FRANKLIN LTD DUR INC TR 2012-12-21 2023-09-08 8442 15761 -7319 -7319 9. INTERNATIONAL BUSINESS MACHINES CORP 2021-10-06 2023-09-08 1320 1217 103 103 34. J P MORGAN CHASE & CO 2020-03-23 2023-09-08 4877 2675 2202 2202 449.138 JANUS HNDRSN GL LIFE SCI-T 2014-08-21 2023-09-08 30824 24353 6471 6471 178. JOHNSON & JOHNSON 2023-04-21 2023-09-08 28496 28937 -441 -441 5769.099 LORD ABBETT BND DEBENTUR-F 2022-04-01 2023-09-08 39518 47795 -8277 -8277 32. MICROSOFT CORP 2020-03-23 2023-09-08 10653 4286 6367 6367 8198.522 PRINCIPAL SHRT TRM INC-INST 2022-04-01 2023-09-08 95185 100756 -5571 -5571 5325.739 PGIM HIGH YIELD-Z 2019-09-12 2023-09-08 24552 29355 -4803 -4803 21. REALTY INCOME CORP 2022-09-20 2023-09-08 1153 1322 -169 -169 5339.138 T ROWE PR CAPTL APPREC-INV 2019-09-12 2023-09-08 178007 171676 6331 6331 220. T-MOBILE US INC 2014-12-10 2023-09-08 30272 12189 18083 18083 8. TEXAS INSTRUMENTS INC 2020-03-23 2023-09-08 1303 773 530 530 1507.664 VIRTUS CONVERTIBLE FUND-P 2014-01-02 2023-09-08 46074 51096 -5022 -5022 623.066 VANGUARD EQUITY INCOME-ADM 2012-12-21 2023-09-11 52892 38234 14658 14658 9. BROADCOM INC 2020-03-23 2023-10-18 7976 1711 6265 6265 9. LILLY ELI & COMPANY 2022-01-25 2023-10-18 5450 2154 3296 3296 126. REALTY INCOME CORP 2022-09-20 2023-10-18 6304 6897 -593 -593 136. VERIZON COMMUNICATIONS 2021-11-10 2023-10-18 4217 6885 -2668 -2668 3.6667 VERALTO CORP 2023-09-08 2023-10-26 258 319 -61 -61 4.3333 VERALTO CORP 2020-10-07 2023-10-26 305 337 -32 -32 212.757 VANGUARD INST INDEX-INST 2023-09-11 2023-11-07 77837 79931 -2094 -2094 8. AMERICAN WATER WORKS CO INC 2023-09-08 2023-11-16 1048 1111 -63 -63 34. AMERICAN WATER WORKS CO INC 2022-09-20 2023-11-16 4452 4238 214 214 51. INTERNATIONAL BUSINESS MACHINES CORP 2021-10-06 2023-11-16 7796 6607 1189 1189 7. COSTCO WHOLESALE CORP 2020-03-23 2023-12-26 4717 1955 2762 2762 61. DUKE ENERGY CORP 2020-08-05 2023-12-26 5913 4208 1705 1705 2. LILLY ELI & COMPANY 2023-09-08 2023-12-26 1142 1171 -29 -29 7. MCDONALDS CORP 2020-11-04 2023-12-26 2048 1507 541 541 32. MORGAN STANLEY DEAN WITTER & CO 2022-07-20 2023-12-26 2969 2621 348 348 45. PFIZER INC 2023-09-08 2023-12-26 1277 1547 -270 -270 59. PFIZER INC 2020-03-23 2023-12-26 1674 1572 102 102 7. UNITEDHEALTH GROUP INC 2020-03-23 2023-12-26 3639 1331 2308 2308 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 CAPITAL GAIN DIVIDENDS P 2347 211232 3665 0 3665 0 3665 376 0 0 376 0 3289 0 0 false false false false false false false true true MO true false false false false true N/A UMB BANK NA 8168607711 1010 GRAND KANSAS CITY MO 64106 false false false false true false false false false false false false false false false false false false false false false false JOANN L FRANCIS 5313 BLUFF WAY PARKVILLE MO 64152 DIRECTOR 5 0 JAMES R FRANCIS 5313 BLUFF WAY PARKVILLE MO 64152 DIRECTOR 5 0 WILLIAM R FRANCIS 4505 NW ROSSELLA CT RIVERSIDE MO 64150 DIRECTOR 5 0 UMB BANK 1010 GRAND AVE KANSAS CITY MO 64106 TRUSTEE 2 14498 NONE 0 NONE 0 2149081 107285 0 2256366 0 0 2256366 33845 2222521 111126 111126 3665 3665 107461 0 107461 0 107461 7249 0 0 0 0 7249 107461 0 0 0 0 0 0 13093 13093 7249 0 0 0 7249 0 13093 13093 0 0 0 0 0 87119 0 0 0 0 0 0 0 0 JAMES FRANCIS JAMES FRANCIS 5313 BLUFF WAY PARKVILLE MO 64152 8167608466 N/A NO SPECIFIC APPLICATION FORM N/A MUST SUBMIT COMPLETE RECORD AND ALL SUPPORTING MATERIALS AS IT RELATES TO THE ORGANIZATIONS ACTIVITIES AND ITS INTENDED USE FOR THE GRANT. 14 60449 18 211232 OTHER REVENUE 1 6 271687 271687 false false false false false false false false false false X X 1 JIM JOANN FRANCIS 5313 BLUFF WAY PARKVILLE MO 64152 51866 X 2 JIM JOANN FRANCIS 5313 BLUFF WAY PARKVILLE MO 64152 1409795 X 2 VARIOUS SECURITIES 1409796 2023-03-13 FUNDING COST BASIS OF SECURITIES ADJ 314486 ROUNDING 5 OTHER EXPENSE (NON-DEDUCTIBLE 3 0 0 FOREIGN TAXES ON QUALIFIED FOR 636 636 0 FOREIGN TAXES ON NONQUALIFIED 158 158 0