2025-01-15T16:01:16-06:00 2024-08-31 920460586 PWC US TAX LLP 301 GRANT STREET 45TH FLOOR PITTSBURGH PA 15219 990PF 2023-09-01 846292171 MILDRED S HANSEN TRUST FOR NORTHERN CO MEDICA HANS 8887304933 PO BOX 505 MAC H0006-092 SAINT LOUIS MO 63166 - TRUSTEE 8887304933 2025-01-15 true true LAURA B STROBEL P01271955 4123556000 2025-01-15 X 2023 2024-10-15 13:58:12Z X 2584919 X 64916 64916 272140 922449 272140 0 337056 337056 25560 23004 2556 0 0 0 0 0 0 1127 0 0 1127 2147 2147 0 0 2810 1712 0 0 0 0 0 0 0 19 19 31663 26882 0 3683 126000 126000 157663 26882 0 129683 179393 310174 0 7500 7500 140351 66684 66684 0 0 0 452124 530361 1222634 75950 50830 48913 805307 998054 1239188 1473732 1653429 2584919 0 X 1473732 1653429 1473732 1653429 1473732 1653429 1473732 179393 495 1653620 191 1653429 25000. SUMITOMO MITSUI FINL 3.936% 10/16/23 2018-11-06 2023-10-16 25000 25120 -120 -120 7710.637 DWS ENH COMMOD STR-I 817 2023-10-18 44799 72000 -27201 -27201 4219.409 MFS EMERGING MKTS DEBT FD-R6 4801 2022-08-04 2023-10-18 45781 50000 -4219 -4219 1420.959 NEUBERGER BERMAN LONG SH-INS #1830 2019-07-05 2023-10-18 23915 20561 3354 3354 140. ISHARES RUSSELL MID-CAP VALUE 2023-10-19 14368 10405 3963 3963 200. ISHARES RUSSELL MID-CAP GROWTH 2009-05-06 2023-10-19 18131 3600 14531 14531 70. ISHARES RUSSELL 2000 VALUE ETF 2023-10-19 9189 5154 4035 4035 40. ISHARES RUSSELL 2000 GROWTH ETF 2009-05-06 2023-10-19 8607 2176 6431 6431 600. VANGUARD FTSE EMERGING MARKETS ETF 2023-10-19 23073 21642 1431 1431 175. BOSTON SCIENTIFIC CORP COM 2015-09-02 2023-11-20 9530 2852 6678 6678 7. BROADCOM INC 2019-10-30 2023-11-20 6975 2022 4953 4953 165. CVS HEALTH CORPORATION 2023-11-20 11321 7924 3397 3397 25. ELI LILLY & CO COM 2017-11-21 2023-11-20 14948 2086 12862 12862 60. MORGAN STANLEY 2018-11-14 2023-11-20 4803 2620 2183 2183 47. UNION PACIFIC CORP 2023-11-20 10387 2285 8102 8102 21. UNITEDHEALTH GROUP INC 2010-10-08 2023-11-20 11205 721 10484 10484 90. ISHARES RUSSELL MID-CAP VALUE 2009-04-14 2023-11-30 9713 2346 7367 7367 120. ISHARES RUSSELL MID-CAP GROWTH 2009-04-14 2023-11-30 11597 1953 9644 9644 1343.381 NEUBERGER BERMAN LONG SH-INS #1830 2019-07-05 2023-11-30 23335 19439 3896 3896 1700. VANGUARD FTSE EMERGING MARKETS ETF 2023-11-30 68985 58556 10429 10429 36. ALPHABET INC CL C 2015-02-23 2024-02-23 5220 955 4265 4265 495. INTERPUBLIC GROUP COS INC 2021-03-03 2024-02-23 16005 13578 2427 2427 20. ELI LILLY & CO COM 2024-02-23 15282 1494 13788 13788 152. MONDELEZ INTERNATIONAL INC 2018-07-18 2024-02-23 11279 6465 4814 4814 6. ADOBE SYS INC 2023-11-20 2024-03-04 3407 3674 -267 -267 31. APPLE INC 2010-09-02 2024-03-04 5438 279 5159 5159 3. BROADCOM INC 2019-10-30 2024-03-04 4231 867 3364 3364 28. EQUINIX INC 2015-03-05 2024-03-04 25085 6455 18630 18630 6. ELI LILLY & CO COM 2016-12-01 2024-03-04 4766 396 4370 4370 74. NIKE INC CL B 2024-03-04 7413 5072 2341 2341 43. TARGET CORP 2010-12-17 2024-03-04 6494 2529 3965 3965 12. THERMO FISHER SCIENTIFIC INC 2013-01-15 2024-03-04 6982 812 6170 6170 460. VANGUARD LONG-TERM BOND ETF 2023-01-19 2024-03-04 32828 35938 -3110 -3110 25. WASTE MANAGEMENT INC 2020-10-14 2024-03-04 5175 2866 2309 2309 41. TE CONNECTIVITY LTD 2024-03-04 5901 3031 2870 2870 165. ISHARES RUSSELL 2000 VALUE ETF 2009-04-14 2024-05-06 25739 7086 18653 18653 100. ISHARES RUSSELL 2000 GROWTH ETF 2024-05-06 26104 5114 20990 20990 400. VANGUARD LONG-TERM BOND ETF 2023-01-19 2024-05-06 27766 31251 -3485 -3485 225. ISHARES RUSSELL MID-CAP VALUE 2009-04-14 2024-05-28 27651 5866 21785 21785 250. ISHARES RUSSELL MID-CAP GROWTH 2009-04-14 2024-05-28 27620 4069 23551 23551 85. ISHARES RUSSELL 2000 VALUE ETF 2009-04-14 2024-05-28 13217 3651 9566 9566 50. ISHARES RUSSELL 2000 GROWTH ETF 2009-04-14 2024-05-28 13275 2469 10806 10806 42. DIAGEO PLC - ADR 2024-05-31 5652 6985 -1333 -1333 30. DIAGEO PLC - ADR 2021-10-18 2024-05-31 4037 5954 -1917 -1917 10. ELI LILLY & CO COM 2016-12-01 2024-05-31 8128 660 7468 7468 101. NIKE INC CL B 2018-03-14 2024-05-31 9517 6689 2828 2828 15. EATON CORP PLC 2021-03-03 2024-05-31 4933 2058 2875 2875 1. BOOKING HOLDINGS INC 2024-05-31 2024-08-28 3878 3727 151 151 3. BOOKING HOLDINGS INC 2015-05-01 2024-08-28 11634 3753 7881 7881 115. ELECTRONIC ARTS INC 2024-08-28 17127 10926 6201 6201 240. PIMCO ENHANCED SHORT MATURITY ETF 2024-08-28 24134 24016 118 118 500. PIMCO ENHANCED SHORT MATURITY ETF 2023-07-27 2024-08-28 50279 49932 347 347 14663.136 PGIM HIGH YIELD-Q 1067 2024-08-28 70530 78230 -7700 -7700 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 CAPITAL GAIN DIVIDENDS P 60 272140 4311 0 4311 0 4311 1072 0 0 1072 0 3239 0 0 false false false false false false false true true CO 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 25560 NONE 0 NONE 0 2337988 76986 0 2414974 0 0 2414974 36225 2378749 118937 118937 4311 4311 114626 0 114626 0 114626 129683 0 0 0 0 129683 114626 94959 0 0 0 0 0 0 0 129683 94959 0 0 34724 0 0 0 0 0 0 0 0 79902 0 0 0 0 0 0 0 0 NONE NONE X NORTH COLORADO MED CENTER FOUNDATION ATTN DONNA BENSON GREELEY CO 80631 NONE PC GENERAL OPERATING 126000 126000 14 64916 18 272140 337056 337056 false false false false false false false false false false TAX PREPARATION FEE (NON-ALLOC 1127 1127 756109AR5 REALTY INCOME CORP 4 25607 24791 86562MBF6 SUMITOMO MITSUI FINL 666807BN1 NORTHROP GRUMMAN COR 25223 24122 037833100 APPLE INC 4261 108546 91324P102 UNITEDHEALTH GROUP I 2198 37773 150870103 CELANESE CORP 11173 21288 09857L108 BOOKING HOLDINGS INC 3495 11728 94106L109 WASTE MANAGEMENT INC 8898 19084 101137107 BOSTON SCIENTIFIC CO 92826C839 VISA INC-CLASS A SHR 12231 19899 405217100 HAIN CELESTIAL GROUP 891160509 TORONTO DOMINION BK 17688 18575 192446102 COGNIZANT TECH SOLUT 10154 13610 09260D107 BLACKSTONE INC 10770 27760 09247X101 BLACKROCK INC 8272 22545 46625H100 JPMORGAN CHASE & CO 3635 35968 609207105 MONDELEZ INTERNATION 9239 15655 097023105 BOEING CO 15990 17027 460690100 INTERPUBLIC GROUP CO 911312106 UNITED PARCEL SERVIC 14408 16712 084670702 BERKSHIRE HATHAWAY I 654106103 NIKE INC CL B 517834107 LAS VEGAS SANDS CORP 31620M106 FIDELITY NATL INFORM 30303M102 META PLATFORMS INC 19612 54738 512807108 LAM RESEARCH CORP CO 18881 26272 172967424 CITIGROUP INC. 19850 25056 867224107 SUNCOR ENERGY INC NE 21915 31419 17275R102 CISCO SYSTEMS INC 7127 17689 532457108 ELI LILLY & CO COM 3564 51841 883556102 THERMO FISHER SCIENT 1895 17222 617446448 MORGAN STANLEY 871829107 SYSCO CORP 907818108 UNION PACIFIC CORP 2424 13573 75513E101 RTX CORP 20758 31328 11135F101 BROADCOM INC 12731 60243 89151E109 TOTALENERGIES SE -SP 23546 30084 594918104 MICROSOFT CORP 10970 100114 56501R106 MANULIFE FINANCIAL C 16167 25512 254687106 WALT DISNEY CO 87612E106 TARGET CORP 3907 10293 H84989104 TE CONNECTIVITY LTD 7352 15974 Y2573F102 FLEX LTD G29183103 EATON CORP PLC 14406 32228 126650100 CVS HEALTH CORPORATI 285512109 ELECTRONIC ARTS INC 00287Y109 ABBVIE INC 11461 18649 02079K107 ALPHABET INC CL C 8708 76611 25243Q205 DIAGEO PLC - ADR H2906T109 GARMIN LTD 16839 24011 418056107 HASBRO INC 00724F101 ADOBE INC 15298 17232 007903107 ADVANCED MICRO DEVIC 12107 18570 437076102 HOME DEPOT INC 13723 15109 7591EP100 REGIONS FINL CORP NE 14757 17448 023135106 AMAZON COM INC COM 19688 20706 032654105 ANALOG DEVICES INC 4068 4227 43300A203 HILTON WORLDWIDE HOL 10509 11641 580135101 MCDONALDS CORP 17664 17608 58933Y105 MERCK & CO INC NEW 21582 22150 855244109 STARBUCKS CORP COM 13168 12200 904767704 UNILEVER PLC - ADR 13272 16716 64128R608 NEUBERGER BERMAN LON 922908553 VANGUARD REAL ESTATE 78463X863 SPDR DJ WILSHIRE INT 464287648 ISHARES RUSSELL 2000 AT COST 2469 14041 52106N459 LAZARD GL LIST INFRA 29444U700 EQUINIX INC AT COST 297 834 464288513 ISHARES IBOXX HIGH Y 921943858 VANGUARD FTSE DEVELO 921937827 VANGUARD SHORT TERM 921937819 VANGUARD INTERMEDIAT 464287630 ISHARES RUSSELL 2000 AT COST 3436 13418 464287481 ISHARES RUSSELL MID- AT COST 13508 94437 922042858 VANGUARD FTSE EMERGI 464287473 ISHARES RUSSELL MID- AT COST 19422 97155 015271109 ALEXANDRIA REAL ESTA 03027X100 AMERICAN TOWER CORP AT COST 5321 16805 74440Y884 PGIM HIGH YIELD-Q 10 46653M849 JOHCM INTERNATIONAL 552746364 MFS EMERGING MKTS DE 77957P402 T ROWE PR SHRT-TRM B 25159L836 DWS ENH COMMOD STR-I 381430107 GOLDMAN SACHS ACTIVE AT COST 51986 57520 46090F100 INVESCO OPTIMUM YIEL AT COST 45216 41354 464287226 ISHARES CORE U.S. AG AT COST 271302 280700 72201R833 PIMCO ENHANCED SHORT 921937793 VANGUARD LONG-TERM B 33739H101 FIRST TRUST GLOBAL T AT COST 44477 42606 464288281 ISHARES JP MORGAN US AT COST 97161 104994 46432F842 ISHARES CORE MSCI EA AT COST 99825 115785 46434G103 ISHARES CORE MSCI EM AT COST 44712 49014 46434V613 ISHARES CORE TOTAL B AT COST 145043 153912 46435U853 ISHARES BROAD USD HI AT COST 78236 78288 92206C664 VANGUARD RUSSELL 200 AT COST 26495 26685 922908629 VANGUARD MIDCAP VIPE AT COST 49148 51640 PY PENDING SALES 186 ROUNDING 5 INVESTMENT EXPENSES - ADR FEES 19 19 0 MUTUAL FUND TIMING ADJ 495 INVESTMNT MNGMNT FEES (NON-DED 2147 2147 FOREIGN TAXES 1469 1469 0 FEDERAL TAX PAYMENT - PRIOR YE 26 0 0 FEDERAL ESTIMATES - PRINCIPAL 1072 0 0 FOREIGN TAXES ON NONQUALIFIED 243 243 0