Loading...
HomeMy WebLinkAbout121625-06.4 TO: Mayor and Town Council December 16, 2025 SUBJECT: October 2025 Month End Treasurer’s Report BACKGROUND The California Government Code and the Town of Danville’s Investment Policy require that a report specifying the investment activity during the month, as well as the month-end investment balances, be prepared and presented to the Town Council on a monthly basis. DISCUSSION Beginning and Ending Cash and Investment Balances for the month of October 2025: Cost Basis Market Value Sep Oct Sep Oct 2025 2025 2025 2025 Town Funds $108,137,886 $105,855,059 $109,814,610 $107,582,476 Trust Funds 1,889,618 1,994,162 1,889,618 1,994,162 Assessment & SA 1,513,544 1,513,054 1,518,779 1,518,893 Total Cash & Investments $111,541,047 $109,362,275 $113,223,006 $111,095,531 Total Cash & Investments Year-to-Year Comparison 2024 $114,486,860 $114,573,632 $115,669,376 $115,019,628 Purchases for the month of October 2025 consisted of one U.S. Treasury for $1,955,234 (maturity date April 30, 2029). There were no purchases for the NERIAD fund for the month of October 2025. Maturities for the month of October 2025 included one U.S. Treasury for $1,606,563. Partial maturities (principal paid down) for the month of October 2025 included one Federal Home Loan Mortgage Corporation K-069 A2 for $2,008, one Toyota Auto Receivables Trust 2023-D A3 for $15,156, one John Deere Owner Trust 2022 A3 for $8,302, one GM Financial Auto Receivables 2022-2 A3 for $8,853, one GM Financial Auto Leasing 2023-3 A3 for $26,400, one BMW Vehicle Owner Trust 2023-A A3 for $9,601. 1 ADMINISTRATIVE STAFF REPORT 6.4 There were no maturities for NERIAD Fund for the month of October 2025. The Town’s net cash position changed from $11,924,054 to $9,362,792 during the month of October 2025. This consisted of operating expenses in excess of operating revenues of -$2,694,327, net funds invested of $278,351, premium/discount recognition of -$6,478 and interest received of $417,894. Cash requirements have been projected for the next 12 months, and the Town is in a position to meet its cash requirements. All investments that the Town owns are in compliance with the California Government Code and the Town’s Investment Policy. PUBLIC CONTACT Posting of the meeting agenda serves as notice to the general public. RECOMMENDATION Accept the October 2025 Month End Treasurer’s Report. Prepared by: Lani Ha Finance Director/Treasurer Reviewed by: Tai J. Williams Town Manager Attachment: October 2025 Month End Treasurer’s Report October 2025 Treasurer’s Report 2 December 16, 2025 Page 1 Town of Danville Treasurer's Report of Investments - Summary October 31, 2025 Description Par Value Cost Market Value % Total TOWN FUNDS 3.92% 4.24% 3.36% 4.48% 4.93% 0.00% 0.00% 4.30% 4.67% Total / Weighted Average $ 107,813,273 $ 105,855,059 $ 107,582,476 100% 4.15% Maturities 0 - 30 Days 31-60 61 - 90 91 - 120 121 - 180 181 - 270 271 - 365 1 - 2 Years 2 - 3 3 - 5 Over 5 Years Total / Weighted Average Town Funds Weighted Average Quality is AAA $ 12,061,806 0 1,097,623 748,179 1,788,741 4,578,145 8,970,184 29,845,592 24,563,449 23,928,757 $ 107,582,476 11% 0% 1% 1% 2% 4% 8% 28% 23% 22% 0% 100% Yield to Maturity U.S. Treasury Obligations Federal Agency Issues Cash Equivalents Collateralized Mortgage Obligation Asset-Backed Securities Commercial Paper Negotiable CD Supranational US Corporate $ 46,550,000 18,250,000 9,362,792 8,831,009 4,879,472 0 0 3,425,000 16,515,000 $ 45,350,027 18,201,818 9,362,792 8,496,716 4,878,760 0 0 3,382,970 16,181,976 $ 46,186,395 18,389,438 9,362,792 8,755,339 4,923,187 0 0 3,432,533 16,532,792 43% 17% 9% 8% 5% 0% 0% 3% 15% Page 2 Town of Danville Treasurer's Report of Investments - Summary October 31, 2025 Market Value % Total $ 1,994,162 100% Total $ SUMMARY TOTAL Town Funds Trust Fund CDA/Successor Agency NERIAD Summary Total $ 1,047,445 $ 111,329,079 $ 1,038,855 $ 109,362,275 $ 1,044,694 111,095,531 100% Description Par Value Cost TRUST FUND Cash Equivalents $ 1,994,162 $ 1,994,162 $ 107,813,273 1,994,162 474,199 1,047,445 $ 105,855,059 1,994,162 474,199 1,038,855 $ 107,582,476 1,994,162 474,199 1,044,694 CDA/SUCCESSOR AGENCY Cash Equivalents Total $ 474,199 $ 474,199 $ 474,199 $ 474,199 $ 474,199 100% $ 474,199 100% ASSESSMENT DISTRICTS NERIAD Federal Agency Issues U.S. Treasury Obligations Cash Equivalents Subtotal $ - $ - 975,000 966,410 72,445 72,445 $ 1,047,445 $ 1,038,855 $ - 0% 972,249 93% 72,445 7% $ 1,044,694 100% Page 3 Town of Danville Treasurer's Report of Investments October 31, 2025 Town Funds Trust Funds NERIAD Total Beginning Balance, at cost Purchases, at cost U.S. Treasury Sales/Maturations/Call U.S. Treasury $ 108,137,886 1,955,234 (1,606,563) $ 1,889,618 $ 475,012 $ 1,038,532 - $ 111,541,047 1,955,234 - - - - - 1,183 134 Net change in Cash (2,972,593) 104,544 (1,996) 189 (2,869,856) Realized gains (losses) - Ending Balance, at cost $ 105,855,059 $ 1,994,162 $ 474,199 $ 1,038,855 $ 109,362,275 CDA Successor Agency (1,606,563) - - - Redemption Premium/Discount Interest Received (70,321) (6,478) 417,894 (70,321) (6,478) 419,211 Page 4 Town of Danville Treasurer's Report of Investments - Detail Town Funds October 31, 2025 Yield to Annual Purchase Date Maturity Date Par Value Cost Market Value Maturity Interest 4.42% 4.58% 4.53% 4.57% 4.41% 4.73% 3.66% 3.80% 3.76% 4.49% 4.74% 3.49% 4.24% 44,700 42,800 39,800 47,440 31,248 44,500 48,500 53,100 43,600 $ 395,688 Description Federal Agency Issues FFCB Note FFCB Note FHLB Note FHLB Note FFCB Note FFCB Note FHLB Note FHLB Note FFCB Note FHLB Note FHLB Note FFCB Note Subtotal 06/22/2023 08/09/2023 11/30/2023 06/26/2024 12/08/2023 11/09/2023 05/15/2023 05/07/2025 04/27/2023 07/06/2023 04/26/2024 09/17/2024 06/23/2026 08/14/2026 11/17/2026 06/11/2027 10/04/2027 11/15/2027 12/10/2027 03/10/2028 04/25/2028 06/09/2028 03/09/2029 09/10/2029 2,000,000 1,500,000 1,000,000 1,000,000 1,500,000 1,750,000 1,500,000 2,000,000 1,500,000 1,500,000 1,500,000 1,500,000 $ 18,250,000 1,997,620 1,496,550 1,002,530 1,001,530 1,504,500 1,743,508 1,536,930 1,957,320 1,507,905 1,467,705 1,484,775 1,500,945 $ 18,201,818 2,007,312 1,508,133 1,008,932 1,013,100 1,523,891 1,782,443 1,519,172 1,972,636 1,509,167 1,513,045 1,540,723 1,490,884 $ 18,389,438 88,400 68,700 45,300 45,700 66,150 82,775 54,900 76,000 56,400 67,350 71,100 52,350 $ 775,125 Collateralized Mortgage Obligation FHLMC K063 A2 FHLMC K066 A2 FHLMC K068 A2 FHLMC K069 A2 FHLMC K073 A2 FHLMC K074 A2 FHLMC K081 A2 FHLMC K082 A2 FHLMC K090 A2 Subtotal 06/06/2023 05/18/2023 05/12/2023 12/27/2023 05/24/2023 12/18/2024 09/05/2023 10/30/2023 03/27/2025 01/25/2027 06/25/2027 08/25/2027 09/25/2027 01/25/2028 01/25/2028 08/25/2028 09/25/2028 02/25/2029 1,000,000 1,000,000 1,000,000 1,111,009 720,000 1,000,000 1,000,000 1,000,000 1,000,000 $ 8,831,009 965,625 958,984 970,820 1,069,650 691,988 974,922 957,969 940,742 966,016 $ 8,496,716 993,011 987,383 988,452 1,096,162 711,474 992,994 999,202 999,750 986,911 $ 8,755,339 4.47% 4.28% 3.98% 4.27% 4.34% 4.45% 4.85% 5.31% 4.36% 4.48% U.S. Treasury Obligations U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes 06/09/2022 07/13/2022 08/03/2022 09/08/2022 11/22/2024 06/07/2023 02/20/2025 11/28/2022 05/17/2024 05/13/2025 10/05/2022 06/21/2024 01/20/2023 03/08/2023 10/17/2024 09/27/2024 11/08/2024 12/30/2024 11/15/2025 1,700,000 1,655,840 1,699,014 3.04% 51,680 12/31/2025 1,100,000 1,079,031 1,097,623 3.20% 35,200 03/31/2026 1,800,000 1,753,523 1,788,741 2.99% 53,820 04/30/2026 1,600,000 1,542,500 1,588,771 3.42% 54,720 07/31/2026 1,750,000 1,749,180 1,757,401 4.40% 77,000 09/30/2026 2,000,000 1,848,984 1,962,312 4.09% 81,800 10/15/2026 1,750,000 1,759,912 1,764,403 4.26% 74,550 03/31/2027 1,450,000 1,363,566 1,427,004 4.00% 58,000 04/15/2027 2,000,000 1,995,469 2,023,594 4.58% 91,600 05/15/2027 2,000,000 1,937,734 1,962,422 4.01% 80,200 06/30/2027 1,500,000 1,451,309 1,491,035 4.00% 60,000 07/31/2027 2,000,000 1,901,875 1,970,626 4.46% 89,200 08/31/2027 1,600,000 1,568,438 1,586,312 3.59% 57,440 09/30/2027 1,250,000 1,234,131 1,261,768 4.44% 55,500 01/31/2028 1,300,000 1,284,105 1,297,360 3.90% 50,700 02/15/2028 1,500,000 1,464,141 1,472,226 3.51% 52,650 03/31/2028 1,000,000 982,344 1,000,742 4.19% 41,900 05/31/2028 1,750,000 1,711,445 1,751,299 4.33% 75,775 Page 5 Town of Danville Treasurer's Report of Investments - Detail Town Funds October 31, 2025 Cash Equivalents Wells Fargo Trsry Plus M Mkt - reserve fund (2001 COP) Wells Fargo Trsry Plus M Mkt - reserve fund (2005 COP) Bank of New York US Bank LAIF Subtotal Asset-Backed Securities Annual Interest 42,500 72,800 70,000 83,880 71,200 43,200 61,500 81,200 80,200 78,200 $ 1,826,415 842 434 18,873 5,016 12,050 13,366 52,039 21,756 23,418 23,923 28,956 12,865 27,104 $ 240,641 Description U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes Subtotal Purchase Date 12/13/2024 09/29/2025 09/16/2025 04/10/2024 10/27/2025 09/05/2024 10/29/2024 03/05/2025 06/03/2025 07/30/2025 Maturity Date 08/31/2028 09/15/2028 10/31/2028 11/15/2028 04/30/2029 05/31/2029 07/31/2029 08/31/2029 11/30/2029 12/31/2029 505,920 357,598 2,397,082 1,275,898 4,826,294 $ 9,362,792 505,920 357,598 2,397,082 1,275,898 4,826,294 $ 9,362,792 3.49% 3.52% 3.52% 0.00% 4.15% 3.36% 17,657 12,587 84,377 0 200,291 314,913 Yield to Maturity 4.25% 3.64% 3.50% 4.66% 3.56% 3.60% 4.10% 4.06% 4.01% 3.91% 3.92% Par Value Cost 1,000,000 1,004,102 2,000,000 1,985,469 2,000,000 1,875,547 1,800,000 1,687,078 2,000,000 1,955,234 1,200,000 1,155,984 1,500,000 1,493,320 2,000,000 1,923,750 2,000,000 1,989,141 2,000,000 1,996,875 $ 46,550,000 $ 45,350,027 Market Value 1,020,391 1,987,812 1,874,140 1,775,180 1,950,626 1,164,422 1,518,047 1,962,188 2,015,625 2,015,311 $ 46,186,395 505,920 357,598 2,397,082 1,275,898 4,826,294 $ 9,362,792 GM Financial Auto Leasing Trust 2023-3 A3 GM Financial Consumer Auto Receiv 2022-2 A3 GM Finacial Automobile Leasing Trust 2025-1 A3 BMW Vehicle Owner Trust 2023-A A3 BMW Vehicle Lease Trust 2025-1 A3 Toyota Auto Receivables Owner 2023-D A3 Chase Issuance Trust 2023-1 A BMW Vehicle Owner Trust 2024-A A3 Bank of America Credit Card Trust 2024-1 A John Deere Owner Trust 2025 A3 BMW Vehicle Owner Trust 2025-A A3 Honda Auto Receivables 2025-2 Owner Trust Mercedes-Benz Auto Receivables Trust 2025-1 Subtotal 08/08/2023 04/05/2022 02/05/2025 07/11/2023 06/03/2025 11/07/2023 09/07/2023 06/04/2024 06/06/2024 03/04/2025 02/04/2025 04/29/2025 01/14/2025 11/20/2026 15,652 15,650 15,659 5.38% 02/16/2027 13,860 13,857 13,848 3.13% 02/21/2028 405,000 404,952 407,961 4.66% 02/25/2028 91,708 91,692 92,286 5.47% 06/26/2028 250,000 249,995 251,570 4.82% 08/15/2028 238,252 238,227 240,800 5.61% 09/15/2028 995,000 994,724 1,005,065 5.23% 02/26/2029 420,000 419,936 423,955 5.18% 05/15/2029 475,000 474,973 482,204 4.93% 09/17/2029 470,000 469,971 472,656 5.09% 09/25/2029 635,000 634,937 639,937 4.56% 10/15/2029 310,000 309,965 311,054 4.15% 12/17/2029 560,000 559,881 566,192 4.84% $ 4,879,472 $ 4,878,760 $ 4,923,187 4.93% Page 6 Town of Danville Treasurer's Report of Investments - Detail Town Funds October 31, 2025 Yield to Annual Description Purchase Date Maturity Date Par Value Cost Market Value Maturity Interest Supranational 41,533 42,300 63,450 $ 147,283 International Finance Corp Note Inter-American Dev Bank Note International Bank For Reconstruction and Dev Subtotal 11/29/2023 01/30/2024 03/11/2024 01/15/2027 02/01/2027 07/12/2028 925,000 1,000,000 1,500,000 $ 3,425,000 921,985 1,004,020 1,456,965 $ 3,382,970 931,194 1,007,183 1,494,156 $ 3,432,533 4.49% 4.23% 4.23% 4.30% US Corporate Microst Callable Note Cont Apple Inc Callable Note Cont Toyota Motor Credit Corp Paccar Financial Corp Note Bank of America NA Callable Note Cont Morgan Stanley Bank NA Callable Note Honeywell Intl Callable Note Pepsico Inc. Callable Note Cont JP Morgan Chase Bank Callable Note John Deere Capital Corp Cisco Systems Inc State Street Corp Caterpillar Financial Service Note Blackrock Funding Inc Amazon.com Inc Visa Inc Paccar Financial Corp Note Pepsico INC. Bank of New York Mellon Corp Apple Inc. Subtotal TOTAL Source: Chandler Asset Management US Bank Local Agency Investment Fund (LAIF) 01/20/2023 02/01/2023 02/08/2024 08/03/2023 08/24/2023 10/30/2023 01/11/2023 11/08/2023 12/05/2023 01/10/2024 02/26/2024 03/13/2024 05/15/2024 07/17/2024 07/10/2024 08/19/2024 08/04/2025 07/29/2025 02/12/2025 03/05/2025 11/03/2025 02/23/2026 06/18/2026 08/10/2026 08/18/2026 10/30/2026 11/01/2026 11/10/2026 12/08/2026 01/08/2027 02/26/2027 03/18/2027 05/14/2027 07/26/2027 08/22/2027 09/15/2027 08/08/2028 01/15/2029 02/01/2029 09/11/2029 1,000,000 970,060 1,000,000 4.28% 42,800 750,000 728,265 748,179 4.27% 32,025 1,000,000 921,800 982,062 4.68% 46,800 515,000 514,743 519,376 5.07% 26,111 1,000,000 1,001,360 1,010,989 5.48% 54,800 440,000 440,000 447,571 5.88% 25,872 1,000,000 933,280 985,839 4.42% 44,200 360,000 359,903 364,016 5.13% 18,468 405,000 405,000 409,817 5.11% 20,696 1,000,000 999,220 1,007,070 4.53% 45,300 1,000,000 999,620 1,011,092 4.81% 48,100 1,065,000 1,065,000 1,080,058 4.99% 53,144 1,000,000 1,002,930 1,016,745 4.89% 48,900 690,000 689,979 698,439 4.60% 31,740 1,000,000 954,920 989,244 4.73% 47,300 1,000,000 960,360 981,698 4.14% 41,400 540,000 539,681 541,898 4.02% 21,708 1,000,000 997,580 1,005,209 4.18% 41,800 1,250,000 1,240,750 1,263,396 4.81% 60,125 500,000 457,525 470,094 4.29% 21,450 $ 16,515,000 $ 16,181,976 $ 16,532,792 4.67% $ 772,738 $ 107,813,273 $ 105,855,059 $ 107,582,476 4.15% $ 4,472,802 Page 7 Town of Danville Treasurer's Report of Investments - Detail Trust Fund October 31, 2025 Description Purchase Date Maturity Date Par Value Cost Market Value Yield to Maturity Annual Interest 1,994,162 1,994,162 1,994,162 4.15% 82,758 TOTAL $ 1,994,162 $ 1,994,162 $ 1,994,162 4.15% $82,758 Source: Local Agency Investment Fund (LAIF) Cash Equivalents LAIF Page 8 Town of Danville Treasurer's Report of Investments - Detail Community Development Agency/Successor Agency October 31, 2025 Yield to Annual Description Purchase Date Maturity Date Par Value Cost Market Value Maturity Interest 3,435 12,694 14 466 $ 16,609 TOTAL Source: BNY Trust Company Local Agency Investment Fund (LAIF) Cash Equivalents LAIF - redemption fund Wells Fargo Trsry Plus M Mkt - reserve fund (TRBs) Wells Fargo Trsry Plus M Mkt - interest acct (TRBs) Wells Fargo Trsry Plus M Mkt - debt service acct (TRBs) Subtotal 82,777 377,787 394 13,242 $ 474,199 82,777 377,787 394 13,242 $ 474,199 82,777 377,787 394 13,242 $ 474,199 4.15% 3.36% 3.52% 3.52% 3.50% $ 474,199 $ 474,199 $ 474,199 3.50% $ 16,609 Page 9 Town of Danville Treasurer's Report of Investments - Detail Northeast Roadway Improvement Assessment District (NERIAD) October 31, 2025 Description Purchase Date Maturity Date Par Value Cost Market Value 10,650 9,270 10,350 9,275 $ 39,545 2,220 667 $ 2,887 Total $ 1,047,445 $ 1,038,855 $ 1,044,694 4.05% $ 42,432 Source: Chandler Asset Management BNY Trust Company Local Agency Investment Fund (LAIF) U.S. Treasury Obligations U.S. Treasury Bill U.S. Treasury Bill U.S. Treasury Bill U.S. Treasury Bill Subtotal 12/16/2024 3/27/2025 6/11/2025 9/16/2025 12/15/2025 3/31/2026 6/15/2026 9/30/2026 250,000 225,000 250,000 250,000 $ 975,000 249,385 217,582 249,970 249,473 $ 966,410 250,005 222,233 250,589 249,422 $ 972,249 Cash Equivalents LAIF - improvement fund Bank of New York-Improvement fd Subtotal 53,497 18,948 $ 72,445 53,497 18,948 $ 72,445 53,497 18,948 $ 72,445 Yield to Annual Maturity Interest 4.26% 4.12% 4.14% 3.71% 4.06% 4.15% 3.52% 3.99%