2024-10-28T14:01:18-05:00 2023-12-31 920460586 PWC US TAX LLP 301 GRANT STREET 45TH FLOOR PITTSBURGH PA 15219 990PF 2023-01-01 392012234 DANIEL W ERDMAN FOUNDATION INC ERDM 6082524098 C/O US BANK NA PO BOX 0634 MILWAUKEE WI 532010634 DANIEL W ERDMAN PRESIDENT 6082524098 2024-09-17 true true ALLISON J VALENTY P00963824 4123556000 2024-09-17 X 2023 2024-10-15 13:58:12Z X 6794531 400000 131648 130409 72292 513447 72292 0 139 139 604079 202840 0 0 0 0 0 0 750 0 0 750 46906 42215 4691 0 8426 1052 0 0 0 0 0 0 0 56082 43267 0 5441 175625 175625 231707 43267 0 181066 372372 159573 0 1931 1616 1616 425582 506232 506232 0 0 0 1281035 1378298 3498127 40204 1980558 2213563 2785183 2307 3373 3373 3731617 4103082 6794531 0 X 3731617 4103082 3731617 4103082 3731617 4103082 3731617 372372 25 4104014 932 4103082 22. MERCK AND CO INC 2017-05-03 2023-01-17 2436 1331 1105 1105 10. PEPSICO INC 2017-05-03 2023-01-17 1763 1121 642 642 5. DEERE & CO COM 2023-01-31 2100 840 1260 1260 4. LILLY ELI & CO 2018-04-03 2023-01-31 1365 308 1057 1057 12. TARGET CORP 2023-01-31 2051 1172 879 879 2. UNITEDHEALTH GRP INC COM 2020-03-17 2023-01-31 997 486 511 511 10. TRANE TECHNOLOGIES PLC 2023-01-31 1787 717 1070 1070 18. CONOCOPHILLIPS COM 2023-02-14 2042 1445 597 597 9. JOHNSON & JOHNSON 2022-07-05 2023-03-01 1367 1602 -235 -235 16. JOHNSON & JOHNSON 2023-03-01 2430 2129 301 301 55. U S BANCORP 2022-09-28 2023-03-20 1920 2283 -363 -363 176. U S BANCORP 2023-03-20 6146 8987 -2841 -2841 7. CIGNA CORP 2023-04-25 1774 2302 -528 -528 13. DEERE & CO COM 2023-04-25 4952 2146 2806 2806 21. TEXAS INSTRS INC 2017-05-03 2023-04-25 3589 1676 1913 1913 40000. BANK OF NY MTN 3.500% 4/28/23 2019-01-08 2023-04-28 40000 40204 -204 -204 181. BANK OF AMERICA CORP 2023-05-09 4987 5863 -876 -876 7. LILLY ELI & CO 2018-04-03 2023-05-09 3018 538 2480 2480 125. APPLE INC 2008-12-31 2023-05-24 21313 387 20926 20926 5. LILLY ELI & CO 2018-04-03 2023-06-06 2209 384 1825 1825 19. NORTHERN TR CORP COM 2019-11-12 2023-06-06 1449 2018 -569 -569 5. BROADCOM INC 2023-06-26 4111 1481 2630 2630 30. CROWN CASTLE INTL CORP 2023-06-26 3319 3004 315 315 2. KLA TENCOR CORP COM RTS EXP 04/25/2006 2017-10-09 2023-06-26 920 208 712 712 4. LAM RESH CORP COM 2018-11-13 2023-06-26 2496 575 1921 1921 56. NORTHERN TR CORP COM 2023-06-26 4051 5065 -1014 -1014 8. NORTHROP GRUMMAN CORP COM W/RTS ATTACHED EXP 10/31/2008 2021-12-22 2023-06-26 3577 3038 539 539 39. TARGET CORP 2023-06-26 5244 3485 1759 1759 9. WASTE MGMT INC DEL COM 2017-05-03 2023-06-26 1498 656 842 842 68. VERIZON COMMUNICATIONS 2023-07-18 2228 4112 -1884 -1884 5. LAM RESH CORP COM 2023-08-16 3274 1015 2259 2259 8. UNITED PARCEL SERVICE CL B COM 2022-11-22 2023-08-16 1375 1455 -80 -80 15. ELECTRONIC ARTS COM 2022-09-28 2023-08-30 1811 1766 45 45 95. VERIZON COMMUNICATIONS 2023-08-30 3297 5529 -2232 -2232 17. ELECTRONIC ARTS COM 2022-09-28 2023-09-12 2064 2001 63 63 39. XCEL ENERGY INC COM 2023-09-12 2232 1954 278 278 37. XCEL ENERGY INC COM 2018-08-07 2023-09-26 2150 1746 404 404 4. KLA TENCOR CORP COM RTS EXP 04/25/2006 2017-10-09 2023-10-10 1886 416 1470 1470 28. NEXTERA ENERGY INC 2023-10-10 1428 1513 -85 -85 13. NIKE INC CL B COM 2023-06-06 2023-10-10 1270 1385 -115 -115 37. MEDTRONIC PLC 2023-10-24 2658 2964 -306 -306 4. BROADCOM INC 2023-11-09 3681 1120 2561 2561 22. PHILIP MORRIS INTL 2023-01-17 2023-11-09 1980 2227 -247 -247 5. PHILIP MORRIS INTL 2017-05-03 2023-11-09 450 554 -104 -104 3100. ISHARES 1 3 YEAR TREASURY BOND ETF 2022-06-07 2023-12-01 252887 257564 -4677 -4677 4. BROADCOM INC 2019-10-01 2023-12-07 3668 1107 2561 2561 18. CIGNA CORP 2023-12-07 4622 5457 -835 -835 6. CUMMINS INC COM 2022-12-21 2023-12-07 1387 1458 -71 -71 9. MARSH & MCLENNAN COS INC 2023-12-07 1757 982 775 775 8. WASTE MGMT INC DEL COM 2017-05-03 2023-12-07 1386 583 803 803 25. AMAZON COM INC 2010-04-15 2023-12-15 3736 182 3554 3554 125. APPLE INC 2008-12-31 2023-12-15 24732 387 24345 24345 15. BERKSHIRE HATHAWAY INC CL B 2015-10-28 2023-12-15 5345 2061 3284 3284 55. PAYCOM SOFTWARE INC 2023-05-24 2023-12-15 11043 15486 -4443 -4443 50. T J X COS INC NEW 2013-01-30 2023-12-15 4460 1136 3324 3324 32. CISCO SYS INC 2023-07-18 2023-12-19 1599 1633 -34 -34 20. CISCO SYS INC 2022-11-22 2023-12-19 999 966 33 33 8. EATON CORP PLC 2023-12-19 1902 815 1087 1087 1000. ISHARES IBONDS DEC 2023 TERM CP ETF 2021-05-03 2023-12-22 25332 26130 -798 -798 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 CAPITAL GAIN DIVIDENDS P 1897 72292 2218 0 2218 0 2218 6828 0 0 6828 0 4610 2220 2390 false false false false false false false true true WI true false false false false true US BANK NA 6082527624 1 S PINCKNEY STREET MADISON WI 53703 false false false false false false false false false false false false false false false false false false false false false DANIEL W ERDMAN C/O US BANK NA PO BOX 7900 MADISON WI 537077900 DIRECTOR 1 0 DEBORAH ERDMAN-LUDER C/O US BANK NA PO BOX 7900 MADISON WI 537077900 DIRECTOR 1 0 DARRELL W BEHNKE C/O US BANK NA PO BOX 7900 MADISON WI 537077900 DIRECTOR 1 0 NATALIE BOCK ERDMAN C/O US BANK NA PO BOX 7900 MADISON WI 537077900 DIRECTOR 1 0 NONE 0 NONE 0 5873663 161734 0 6035397 0 0 6035397 90531 5944866 297243 297243 2218 2218 295025 0 295025 0 295025 181066 0 0 0 0 181066 295025 96289 0 0 0 0 0 0 0 181066 96289 0 0 84777 0 0 0 0 0 0 0 0 210248 0 0 0 0 0 0 0 0 DANIEL W ERDMAN X CLEAN LAKES ALLIANCE 150 EAST GILMAN STREET MADISON WI 53703 NONE PC GENERAL OPERATING 2500 ACCESS COMMUNITY HEALTH CENTERS 2910 W BELTLINE HWY STE MADISON WI 53713 NONE PC GENERAL OPERATING 5000 GROUNDSWELL CONSERVANCY 303 S PATERSON ST SUITE 6 MADISON WI 53703 NONE PC GENERAL OPERATING 3000 MADISON MUSEUM OF CONTEMPORARY ART 227 STATE STREET MADISON WI 53703 NONE PC GENERAL OPERATING 5000 THE NATURE CONSERVANCY 4245 N FAIRFAX DRIVE SUITE 100 ARLINGTON VA 22203 NONE PC GENERAL OPERATING 30000 MADISON SYMPHONY ORCHESTRA 222 WEST WAHINGTON AVE MADISON WI 53719 NONE PC GENERAL OPERATING 5000 UNIVERSITY OF WISCONSIN FOUNDATION 1848 UNIVERSITY AVE MADISON WI 537264090 NONE PC GENERAL OPERATING 3000 BAYVIEW FOUNDATION 601 BAYVIEW TRIANGLE MADISON WI 53715 NONE PC GENERAL OPERATING 25000 GOODMAN COMMUNITY CENTER 214 WAUBESA ST MADISON WI 537045736 NONE PC GENERAL OPERATING 5000 CXC ACADEMY 718 POST ROAD SUITE F MADISON WI 53713 NONE PC GENERAL OPERATING 42125 ONE CITY SCHOOLS INC 1707 W BROADWAY MONONA WI 537131834 NONE PC GENERAL OPERATING 50000 175625 14 131648 18 72292 OTHER INCOME 1 139 204079 204079 false false false false false false false false false false X X 1 DANIEL W ERDMAN C/O US BANK NA PO BOX 0634 MILWAUKEE WI 53201 400000 X TAX PREPARATION FEE (NON-ALLOC 750 750 06406RAG2 BANK OF NY MTN 12572Q105 CME GROUP INC 8889 11794 713448108 PEPSICO INC 17305 50442 654106103 NIKE INC 10696 41691 595112103 MICRON TECHNOLOGY IN 19663 39427 30303M102 FACEBOOK INC A 4612 28317 084670702 BERKSHIRE HATHAWAY I 47394 123048 025537101 AMERICAN ELECTRIC PO 5121 5604 459200101 INTERNATIONAL BUSINE 11778 14720 571748102 MARSH MCLENNAN COS I 5541 14210 931142103 WAL MART STORES INC 38019 49502 94106L109 WASTE MGMT INC 3062 7522 09247X101 BLACKROCK INC 6203 9742 58933Y105 MERCK AND CO INC 10396 16244 92939U106 WEC ENERGY GROUP INC 3531 4798 110122108 BRISTOL MYERS SQUIBB 30762 28169 023135106 AMAZON.COM INC 12223 254500 478160104 JOHNSON JOHNSON 28416 59561 22160K105 COSTCO WHSL CORP 5643 66008 46625H100 J P MORGAN CHASE CO 56729 186940 00287Y109 ABBVIE INC 24580 81359 532457108 ELI LILLY CO 907818108 UNION PACIFIC CORP 10213 19158 30040W108 EVERSOURCE ENERGY 3044 3148 20030N101 COMCAST CORP CL A 16838 20215 02079K107 ALPHABET INC CL C 5644 70465 701094104 PARKER HANNIFIN CORP 7478 16125 665859104 NORTHERN TRUST CORP 17275R102 CISCO SYSTEMS INC 48175 64767 512807108 LAM RESEARCH CORP 4361 13315 438516106 HONEYWELL INTERNATIO 10463 15938 902973304 US BANCORP 11135F101 BROADCOM INC 5277 21209 037833100 APPLE INC 8515 529458 053015103 AUTOMATIC DATA PROCE 3013 7222 G1151C101 ACCENTURE PLC CL A 7592 13685 911312106 UNITED PARCEL SERVIC 11418 12107 872540109 TJX COMPANIES INC 6819 28143 30231G102 EXXON MOBIL CORP 32596 41192 92343V104 VERIZON COMMUNICATIO 15767 22620 231021106 CUMMINS INC COM 3989 5750 882508104 TEXAS INSTRUMENTS IN 3352 7159 693475105 P N C FINANCIAL SERV 9320 11149 125896100 C M S ENERGY CORP 1603 3426 22822V101 CROWN CASTLE INTL CO 718172109 PHILIP MORRIS INTL 10470 9126 H1467J104 CHUBB LTD 35055 42262 13645T100 CANADIAN PACIFIC RAI 244199105 DEERE CO. 666807102 NORTHROP GRUMMAN COR 8227 10767 695156109 PACKAGING CORP AMERI 2157 3258 91324P102 UNITED HEALTH GROUP 6265 14741 65339F101 NEXTERA ENERGY INC 1701 4070 002824100 ABBOTT LABORATORIES 20721 69784 166764100 CHEVRON CORPORATION 15725 21181 20825C104 CONOCOPHILLIPS 5049 7312 02079K305 ALPHABET INC CL A 25183 279380 742718109 PROCTER GAMBLE CO 14344 19636 594918104 MICROSOFT CORP 31620 71824 580135101 MCDONALDS CORP 9962 14826 437076102 HOME DEPOT INC 37575 56834 539830109 LOCKHEED MARTIN CORP 5747 9065 060505104 BANK OF AMERICA CORP 38551 37508 98389B100 X CEL ENERGY INC G5960L103 MEDTRONIC PLC 29096 27268 609207105 MONDELEZ INTERNATION 7697 10285 482480100 KLA CORPORATION 3667 15114 023608102 AMEREN CORP 4050 4847 87612E106 TARGET CORP 032654105 ANALOG DEVICES INC 10722 15885 26875P101 E O G RES INC 6430 11853 G29183103 EATON CORP PLC 5691 12282 79466L302 SALESFORCE COM INC 17900 35524 G8994E103 TRANE TECHNOLOGIES P 3447 9756 053611109 AVERY DENNISON CORP 3426 5256 34959E109 FORTINET INC 16164 43898 38141G104 GOLDMAN SACHS GROUP 31238 57866 233331107 D T E ENERGY CO 1970 2867 053484101 AVALONBAY COMMUNITIE 5483 4493 75513E101 RAYTHEON TECHNOLOGIE 6605 18932 29364G103 ENTERGY CORPORATION 5979 5565 009066101 AIRBNB INC CL A 17608 13614 67066G104 NVIDIA CORP 26592 99044 30063P105 EXACT SCIENCES CORPO 26266 22194 036752103 ELEVANCE HEALTH INC 11885 12261 149123101 CATERPILLAR INC 20305 29567 70450Y103 PAYPAL HOLDINGS INC 32637 7369 15135B101 CENTENE CORP COM 17914 22263 693506107 P P G INDS INC 8121 8674 191216100 COCA COLA COMPANY 10811 11550 617446448 MORGAN STANLEY 11380 11097 217204106 COPART INC COM 16386 29400 012653101 ALBEMARLE CORP 15304 14448 075887109 BECTON DICKINSON AND 10554 10241 G5494J103 LINDE PLC 595017104 MICROCHIP TECHNOLOGY 9496 12445 949746101 WELLS FARGO CO 12843 13536 285512109 ELECTRONIC ARTS INC 91913Y100 VALERO ENERGY CORP 6717 9490 099502106 BOOZ ALLEN HAMILTON 3001 4221 09260D107 BLACKSTONE GROUP INC 2418 4189 125523100 CIGNA CORP 00206R102 ATT INC 9329 10571 00724F101 ADOBE SYS INC 15985 29830 007903107 ADVANCED MICRO DEVIC 11405 14741 064058100 BANK OF NEW YORK MEL 6357 7131 13646K108 CANADIAN PACIFIC KAN 13547 47436 370334104 GENERAL MILLS INC 4290 4299 372460105 GENUINE PARTS COMPAN 4568 3878 452308109 ILLINOIS TOOL WORKSI 6351 6810 74340W103 PROLOGIS INC 4150 4666 74460D109 PUBLIC STORAGE INC 4010 4270 747525103 QUALCOMM INC 15293 21695 842587107 SOUTHERN CO THE 7712 7853 92826C839 VISA INC 12745 14319 G54950103 LINDE PLC SHS 8361 11911 63873P817 LOOMIS SAYLES STRATE AT COST 118590 111071 74440B884 PGIM TOTAL RETURN BO AT COST 175000 157204 46434VBD1 ISHARES IBONDS DEC 2 AT COST 44781 40854 131582439 CALVERT HIGH YIELD B AT COST 50000 44174 52469F721 WESTERN ASSET INCOME AT COST 100000 82742 46434VAX8 ISHARES IBONDS DEC 2 921910501 VANGUARD INTERNATION AT COST 25000 15337 06828M876 BARON EMERGING MARKE AT COST 75232 95340 922908652 VANGUARD EXTENDED MA AT COST 79521 157514 464287465 ISHARES MSCI EAFE ET AT COST 163065 173305 81369Y209 HEALTH CARE SELECT S AT COST 5435 20457 464287457 ISHARES 1 3 YEAR TRE AT COST 83085 82040 057071854 BAIRD AGGREGATE BOND AT COST 311661 288554 464287804 ISHARES CORE S P SMA AT COST 77380 153499 922908686 VANGUARD SMALL CAP I AT COST 41631 82752 46090E103 INVESCO QQQ TRUST ET AT COST 34997 122856 78467Y107 SPDR S P MIDCAP 400 AT COST 81029 162869 670678507 NUVEEN REAL ESTATE S AT COST 36590 32265 922908769 VANGUARD TOTAL STOCK AT COST 118610 412295107 HARDING LOEVNER INTE AT COST 55000 74104 258620103 DOUBLELINE TOTAL RET AT COST 100000 84472 464287598 ISHARES RUSSELL 1000 AT COST 78239 184254 922908553 VANGUARD REAL ESTATE AT COST 50026 49482 101156602 BOSTON TRUST WALDEN AT COST 75000 81893 19765N518 COLUMBIA CORPORATE I AT COST 50000 51283 464288638 ISHARES BARCLAYS INT AT COST 200171 208000 464288877 ISHARES MSCI EAFE VA AT COST 50571 57310 46435GAA0 ISHARES IBONDS DEC 2 AT COST 17559 17925 56064L298 MAINSTAY CBRE GLOBAL AT COST 34000 35017 000000000 MISCELLANEOUS ENTRY 2307 3373 3373 ROC ADJ ON CY SALES 32 VANGUARD REIT ADJUSTMENT 602 ENTERGY CORP ADJUSTMENT 163 CROWN CASTLE CORP ADJUSTMENT 94 DIGITAL RE TRUST ADJUSTMENT 41 OTHER INCOME 139 139 ROUNDING 25 OTHER EXPENSE (NON-DEDUCTIBLE 46906 42215 4691 FOREIGN TAXES 1037 1037 0 FEDERAL TAX PAYMENT - PRIOR YE 546 0 0 FEDERAL ESTIMATES - PRINCIPAL 6828 0 0 FOREIGN TAXES ON NONQUALIFIED 15 15 0