2024-01-15T11:00:38-06:00 2023-08-31 920460586 PWC US TAX LLP 301 GRANT STREET 45TH FLOOR PITTSBURGH PA 15219 990PF 2022-09-01 846292171 MILDRED S HANSEN TRUST FOR NORTHERN CO MEDICA HANS 8887304933 6325 S RAINBOW BLVD STE 300 LAS VEGAS NV 89118 - TRUSTEE 8887304933 2023-12-08 true true LAURA B STROBEL P01271955 4123556000 2023-12-08 X 2022 2023-04-26 12:10:37Z X 2323686 X 81637 81637 20098 644239 20098 0 101735 101735 24158 21742 2416 0 0 0 0 0 0 1039 0 0 1039 1357 1357 0 0 2939 1630 0 0 0 0 0 0 0 15 15 29508 24744 0 3455 132000 132000 161508 24744 0 135455 -59773 76991 0 47614 140351 140351 0 0 0 457463 452124 1017731 75950 75950 72391 952516 805307 1093213 1533543 1473732 2323686 0 X 1533543 1473732 1533543 1473732 1533543 1473732 1533543 -59773 186 1473956 224 1473732 200. ISHARES IBOXX HIGH YLD CORP ETF 2019-08-15 2023-01-19 15199 17173 -1974 -1974 699.625 JOHCM INTERNATIONAL SEL-INST #180 2014-01-15 2023-01-19 14902 13041 1861 1861 410. SPDR DJ WILSHIRE INTERNATIONAL R ETF 2023-01-19 11468 14987 -3519 -3519 700. VANGUARD INTERMEDIATE TERM B 2023-01-19 53979 63310 -9331 -9331 200. VANGUARD REAL ESTATE ETF 2019-04-22 2023-01-19 17384 16968 416 416 185. CITIGROUP INC. 2023-02-10 9204 13156 -3952 -3952 70. COGNIZANT TECH SOLUTIONS CRP COM 2017-10-27 2023-02-10 4639 5280 -641 -641 65. FIDELITY NATL INFORMATION SVCS INC 2018-08-09 2023-02-10 4872 6290 -1418 -1418 260. HAIN CELESTIAL GROUP INC 2020-04-16 2023-02-10 4762 7005 -2243 -2243 125. LAS VEGAS SANDS CORP 2023-02-10 7124 8248 -1124 -1124 95. ALEXANDRIA REAL ESTATE EQUITIES 2023-07-27 12202 11648 554 554 50. BERKSHIRE HATHAWAY INC. 2012-07-09 2023-07-27 17511 4174 13337 13337 10. BLACKROCK INC 2023-07-27 7298 4773 2525 2525 125. WALT DISNEY CO 2023-07-27 10669 7538 3131 3131 55. HASBRO INC 2021-10-18 2023-07-27 3455 5089 -1634 -1634 60. ISHARES RUSSELL MID-CAP VALUE 2020-02-11 2023-07-27 6872 5772 1100 1100 170. ISHARES RUSSELL MID-CAP GROWTH 2009-06-02 2023-07-27 16873 3213 13660 13660 120. LAS VEGAS SANDS CORP 2023-07-27 7019 7317 -298 -298 1535.836 LAZARD GL LIST INFRASTR-INST 1243 2019-02-26 2023-07-27 23329 22500 829 829 6852.248 T ROWE PR SHRT-TRM BND-I #442 2022-03-15 2023-07-27 30767 32000 -1233 -1233 245. SYSCO CORP 2023-07-27 18485 13479 5006 5006 1000. VANGUARD INTERMEDIATE TERM B 2023-07-27 74715 85434 -10719 -10719 750. VANGUARD FTSE DEVELOPED ETF 2023-07-27 35741 30871 4870 4870 400. VANGUARD FTSE EMERGING MARKETS ETF 2023-07-27 16942 15894 1048 1048 250. FLEXTRONICS INTL LTD 2021-03-03 2023-07-27 6765 4502 2263 2263 100. ISHARES RUSSELL 2000 VALUE ETF 2023-08-30 14413 13021 1392 1392 60. ISHARES RUSSELL 2000 GROWTH ETF 2023-08-30 14456 12062 2394 2394 2606.833 JOHCM INTERNATIONAL SEL-INST #180 2023-08-30 58263 48068 10195 10195 6073.752 PGIM HIGH YIELD-Q 1067 2021-10-21 2023-08-30 28061 33770 -5709 -5709 800. SPDR DJ WILSHIRE INTERNATIONAL R ETF 2023-08-30 20185 24741 -4556 -4556 700. VANGUARD SHORT TERM BOND ETF 2023-08-30 52903 54663 -1760 -1760 500. VANGUARD FTSE EMERGING MARKETS ETF 2023-08-30 20498 18154 2344 2344 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 CAPITAL GAIN DIVIDENDS P 3284 20098 1070 0 1070 0 1070 1044 0 0 1044 0 26 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 5D4001-052 WINSTON SALEM NC 27101 TRUSTEE 1 24158 NONE 0 NONE 0 2188295 56149 0 2244444 0 0 2244444 33667 2210777 110539 110539 1070 1070 109469 0 109469 0 109469 135455 0 0 0 0 135455 109469 120945 0 0 0 0 0 0 0 135455 120945 0 0 14510 0 0 0 0 0 0 0 0 94959 0 0 0 0 0 0 0 0 NONE NONE X NORTH COLORADO MED CENTER FOUNDATION 815 8TH AVE GREELEY CO 80631 NONE PC GENERAL OPERATING 132000 132000 14 81637 18 20098 101735 101735 false false false false false false false false false false TAX PREPARATION FEE (NON-ALLOC 1039 1039 756109AR5 REALTY INCOME CORP 4 25607 24160 86562MBF6 SUMITOMO MITSUI FINL 25120 24942 666807BN1 NORTHROP GRUMMAN COR 25223 23289 037833100 APPLE INC 4540 94874 91324P102 UNITEDHEALTH GROUP I 2919 40509 150870103 CELANESE CORP 9469 18954 09857L108 BOOKING HOLDINGS INC 7248 18630 94106L109 WASTE MANAGEMENT INC 11765 18030 101137107 BOSTON SCIENTIFIC CO 2852 9440 92826C839 VISA INC-CLASS A SHR 10488 15969 405217100 HAIN CELESTIAL GROUP 891160509 TORONTO DOMINION BK 17688 18913 192446102 COGNIZANT TECH SOLUT 10154 12532 09260D107 BLACKSTONE INC 10770 20742 09247X101 BLACKROCK INC 8272 17514 46625H100 JPMORGAN CHASE & CO 3635 23413 609207105 MONDELEZ INTERNATION 15703 26366 097023105 BOEING CO 9098 14562 460690100 INTERPUBLIC GROUP CO 13578 16142 911312106 UNITED PARCEL SERVIC 14408 22022 084670702 BERKSHIRE HATHAWAY I 654106103 NIKE INC CL B 11761 17799 517834107 LAS VEGAS SANDS CORP 31620M106 FIDELITY NATL INFORM 30303M102 META PLATFORMS INC 14037 26630 512807108 LAM RESEARCH CORP CO 13849 17560 172967424 CITIGROUP INC. 14781 12387 867224107 SUNCOR ENERGY INC NE 21915 26257 17275R102 CISCO SYSTEMS INC 7127 20073 532457108 ELI LILLY & CO COM 8200 63733 883556102 THERMO FISHER SCIENT 2707 22284 617446448 MORGAN STANLEY 2620 5109 871829107 SYSCO CORP 907818108 UNION PACIFIC CORP 4709 22057 75513E101 RTX CORP 15124 15745 11135F101 BROADCOM INC 12998 41530 89151E109 TOTALENERGIES SE -SP 19918 23906 594918104 MICROSOFT CORP 10970 78662 56501R106 MANULIFE FINANCIAL C 9137 11735 254687106 WALT DISNEY CO 87612E106 TARGET CORP 6435 13921 H84989104 TE CONNECTIVITY LTD 10384 19197 Y2573F102 FLEX LTD G29183103 EATON CORP PLC 16464 27644 126650100 CVS HEALTH CORPORATI 7924 10753 285512109 ELECTRONIC ARTS INC 10926 13798 00287Y109 ABBVIE INC 8539 11757 02079K107 ALPHABET INC CL C 9662 68675 25243Q205 DIAGEO PLC - ADR 11243 9939 H2906T109 GARMIN LTD 10851 9012 418056107 HASBRO INC 00724F101 ADOBE INC 10241 11187 007903107 ADVANCED MICRO DEVIC 7302 9515 437076102 HOME DEPOT INC 9887 9909 7591EP100 REGIONS FINL CORP NE 9826 8345 64128R608 NEUBERGER BERMAN LON AT COST 40000 47243 922908553 VANGUARD REAL ESTATE 78463X863 SPDR DJ WILSHIRE INT AT COST 24741 20240 464287648 ISHARES RUSSELL 2000 AT COST 24291 72201 52106N459 LAZARD GL LIST INFRA 29444U700 EQUINIX INC AT COST 6752 22660 464288513 ISHARES IBOXX HIGH Y 921943858 VANGUARD FTSE DEVELO 921937827 VANGUARD SHORT TERM AT COST 54663 52969 921937819 VANGUARD INTERMEDIAT 464287630 ISHARES RUSSELL 2000 AT COST 32349 72010 464287481 ISHARES RUSSELL MID- AT COST 23129 134694 922042858 VANGUARD FTSE EMERGI AT COST 98352 113484 464287473 ISHARES RUSSELL MID- AT COST 38039 132636 015271109 ALEXANDRIA REAL ESTA 03027X100 AMERICAN TOWER CORP AT COST 5321 13599 74440Y884 PGIM HIGH YIELD-Q 10 AT COST 78230 67744 46653M849 JOHCM INTERNATIONAL 552746364 MFS EMERGING MKTS DE AT COST 50000 48397 77957P402 T ROWE PR SHRT-TRM B 25159L836 DWS ENH COMMOD STR-I AT COST 72000 45339 381430107 GOLDMAN SACHS ACTIVE AT COST 48501 46815 46090F100 INVESCO OPTIMUM YIEL AT COST 23624 23600 464287226 ISHARES CORE U.S. AG AT COST 68194 67760 72201R833 PIMCO ENHANCED SHORT AT COST 49932 50040 921937793 VANGUARD LONG-TERM B AT COST 67189 61782 MUTUAL FUND TIMING ADJ 203 COST BASIS ADJUSTMENT 21 INVESTMENT EXPENSES - ADR FEES 15 15 0 CY PENDING SALES 186 INVESTMNT MNGMNT FEES (NON-DED 1357 1357 FOREIGN TAXES 1237 1237 0 FEDERAL TAX PAYMENT - PRIOR YE 265 0 0 FEDERAL ESTIMATES - PRINCIPAL 1044 0 0 FOREIGN TAXES ON QUALIFIED FOR 110 110 0 FOREIGN TAXES ON NONQUALIFIED 283 283 0