Loading...
HomeMy WebLinkAbout102125-6.3 1 ADMINISTRATIVE STAFF REPORT 6.3 TO: Mayor and Town Council October 21, 2025 SUBJECT: August 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 August 2025: July August July August 2025 2025 2025 2025 Town Funds $111,859,838 $110,653,713 $113,036,810 $112,330,071 Trust Funds 2,074,306 1,897,566 2,074,306 1,897,566 Assessment & SA 2,399,711 2,573,462 2,411,381 2,587,746 Total Cash & Investments $116,333,854 $115,124,741 $117,522,496 $116,815,384 Total Cash & Investments Year-to-Year Comparison 2024 $120,427,637 $118,420,620 $120,473,630 $119,110,960 Cost Basis Market Value Purchases for the month of August 2025 consisted of one PACCAR Financial Group for $539,681 (maturity date August 8, 2028). There were no purchases for the NERIAD Fund for the month of August 2025. Maturities for the month of August 2025 included one Colgate-Palmolive CO for $469,568, one U.S. Treasury for $1,454,883, and one Federal National Mortgage Association for $971,060. Partial maturities (principal paid down) for the month of August 2025 included one Federal Home Loan Mortgage Corporation K-069 A2 for $1,873, one John Deere Owner Trust 2022 A3 for $9,770, one Hyundai Auto Receivables Trust 2022-A A3 for $15,778, one August 2025 Treasurer’s Report 2 October 21, 2025 Honda Auto Receivables Trust 2022-1 A3 for $10,690, one GM Financial Auto Receivables 2022-2 A3 for $9,953, one GM Financial Auto Leasing 2023-3 A3 for $26,588, one BMW Vehicle Owner Trust 2023-A A3 for $10,316, and one BMW Vehicle Owner Trust 2022-A A3 for $9,844. There were no maturities for NERIAD Fund for the month of August 2025. The Town’s net cash position changed from $14,806,287 to $16,050,722 during the month of August 2025. This consisted of operating expenses in excess of operating revenues of -$1,365,254, net funds invested of -$2,261,018, premium/discount recognition of $74,571 and interest received of $274,100. 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 August 2025 Month End Treasurer’s Report. Prepared by: Lani Ha Finance Director/Treasurer Reviewed by: Tai Williams Town Manager Attachment: August 2025 Month End Treasurer’s Report Town of Danville Treasurer's Report of Investments - Summary August 31, 2025 Yield to Description Par Value Cost Market Value % Total Maturity TOWN FUNDS U.S. Treasury Obligations 43,650,000$ 42,642,449$ 43,429,798$ 38%3.90% Federal Agency Issues 18,250,000 18,201,818 18,392,042 16%4.24% Cash Equivalents 16,548,385 16,548,385 16,548,385 15%3.74% Collateralized Mortgage Obligation 8,834,896 8,500,458 8,745,289 8%4.48% Asset-Backed Securities 5,008,276 5,007,544 5,059,290 4%4.92% Commercial Paper 0 0 0 0%0.00% Negotiable CD 0 0 0 0%0.00% Supranational 3,425,000 3,382,970 3,433,920 3%4.30% US Corporate 17,215,000 16,867,752 17,219,010 15%4.67% Total / Weighted Average 112,931,557$ 111,151,376$ 112,827,734$ 100%4.16% Maturities 0 - 30 Days 18,746,639$ 17% 31-60 0 0% 61 - 90 4,287,504 4% 91 - 120 0 0% 121 - 180 1,840,960 2% 181 - 270 3,365,119 3% 271 - 365 7,788,258 7% 1 - 2 Years 29,217,766 26% 2 - 3 24,449,216 22% 3 - 5 23,132,272 21% Over 5 Years 0% 112,827,734$ 100% Total / Weighted Average Town Funds Weighted Average Quality is AAA Page 1 Town of Danville Treasurer's Report of Investments - Summary August 31, 2025 Description Par Value Cost Market Value % Total TRUST FUND Cash Equivalents 1,897,566$ 1,897,566$ 1,897,566$ 100% CDA/SUCCESSOR AGENCY Cash Equivalents 964,718$ 964,718$ 964,718$ 100% Total 964,718$ 964,718$ 964,718$ 100% ASSESSMENT DISTRICTS NERIAD Federal Agency Issues -$ -$ -$ 0% U.S. Treasury Obligations 975,000 956,813 971,097 86% Cash Equivalents 154,269 154,269 154,269 14% Subtotal 1,129,269$ 1,111,082$ 1,125,366$ 100% Total 1,129,269$ 1,111,082$ 1,125,366$ 100% SUMMARY TOTAL Town Funds 112,931,557$ 111,151,376$ 112,827,734$ Trust Fund 1,897,566 1,897,566 1,897,566 CDA/Successor Agency 964,718 964,718 964,718 NERIAD 1,129,269 1,111,082 1,125,366 Summary Total 116,923,110$ 115,124,742$ 116,815,385$ Page 2 Town of Danville Treasurer's Report of Investments CDA Town Funds Trust Funds Successor Agency NERIAD Total Beginning Balance, at cost 111,859,838$ 2,074,306$ 1,285,297$ 1,114,414$ 116,333,854$ Purchases, at cost PACCAR Financial Group 539,681 539,681 - - - - - - Sales/Maturations/Call Colgate-Palmolive CO (469,568) (469,568) U.S. Treasury (1,454,883) (1,454,883) Federal National Mortgage Association (971,060) (971,060) - Redemption (94,812) (94,812) Premium/Discount 74,571 74,571 Interest Received 274,100 1,271 425 275,796 Net change in Cash 1,393,509 (176,740) (321,850) (3,757)891,162 Realized gains (losses)- Ending Balance, at cost 111,151,376$ 1,897,566$ 964,718$ 1,111,082$ 115,124,741$ August 31, 2025 Page 3 Town of Danville Treasurer's Report of Investments - Detail Town Funds Yield to Annual Description Purchase Date Maturity Date Par Value Cost Market Value Maturity Interest Federal Agency Issues FFCB Note 06/22/2023 06/23/2026 2,000,000 1,997,620 2,006,497 4.42%88,400 FFCB Note 08/09/2023 08/14/2026 1,500,000 1,496,550 1,509,272 4.58%68,700 FHLB Note 11/30/2023 11/17/2026 1,000,000 1,002,530 1,009,821 4.53%45,300 FHLB Note 06/26/2024 06/11/2027 1,000,000 1,001,530 1,013,714 4.57%45,700 FFCB Note 12/08/2023 10/04/2027 1,500,000 1,504,500 1,523,725 4.41%66,150 FFCB Note 11/09/2023 11/15/2027 1,750,000 1,743,508 1,783,755 4.73%82,775 FHLB Note 05/15/2023 12/10/2027 1,500,000 1,536,930 1,521,288 3.66%54,900 FHLB Note 05/07/2025 03/10/2028 2,000,000 1,957,320 1,971,818 3.80%76,000 FFCB Note 04/27/2023 04/25/2028 1,500,000 1,507,905 1,507,126 3.76%56,400 FHLB Note 07/06/2023 06/09/2028 1,500,000 1,467,705 1,515,155 4.49%67,350 FHLB Note 04/26/2024 03/09/2029 1,500,000 1,484,775 1,543,908 4.74%71,100 FFCB Note 09/17/2024 09/10/2029 1,500,000 1,500,945 1,485,963 3.49%52,350 Subtotal 18,250,000$ 18,201,818$ 18,392,042$ 4.24%775,125$ Collateralized Mortgage Obligation FHLMC K063 A2 06/06/2023 01/25/2027 1,000,000 965,625 990,617 4.47%44,700 FHLMC K066 A2 05/18/2023 06/25/2027 1,000,000 958,984 985,059 4.28%42,800 FHLMC K068 A2 05/12/2023 08/25/2027 1,000,000 970,820 986,792 3.98%39,800 FHLMC K069 A2 12/27/2023 09/25/2027 1,114,896 1,073,392 1,098,199 4.27%47,606 FHLMC K073 A2 05/24/2023 01/25/2028 720,000 691,988 710,626 4.34%31,248 FHLMC K074 A2 12/18/2024 01/25/2028 1,000,000 974,922 992,016 4.45%44,500 FHLMC K081 A2 09/05/2023 08/25/2028 1,000,000 957,969 999,135 4.85%48,500 FHLMC K082 A2 10/30/2023 09/25/2028 1,000,000 940,742 999,475 5.31%53,100 FHLMC K090 A2 03/27/2025 02/25/2029 1,000,000 966,016 983,370 4.36%43,600 Subtotal 8,834,896$ 8,500,458$ 8,745,289$ 4.48%395,854$ U.S. Treasury Obligations U.S. Treasury Notes 04/21/2022 09/30/2025 1,500,000 1,502,109 1,498,372 2.96%44,400 U.S. Treasury Notes 06/02/2022 10/31/2025 1,600,000 1,606,563 1,596,494 2.87%45,920 U.S. Treasury Notes 06/09/2022 11/15/2025 1,700,000 1,655,840 1,693,094 3.04%51,680 U.S. Treasury Notes 07/13/2022 12/31/2025 1,100,000 1,079,031 1,094,532 3.20%35,200 U.S. Treasury Notes 08/03/2022 03/31/2026 1,800,000 1,753,523 1,781,944 2.99%53,820 U.S. Treasury Notes 09/08/2022 04/30/2026 1,600,000 1,542,500 1,583,175 3.42%54,720 U.S. Treasury Notes 11/22/2024 07/31/2026 1,750,000 1,749,180 1,757,178 4.40%77,000 U.S. Treasury Notes 06/07/2023 09/30/2026 2,000,000 1,848,984 1,953,672 4.09%81,800 U.S. Treasury Notes 02/20/2025 10/15/2026 1,750,000 1,759,912 1,765,176 4.26%74,550 U.S. Treasury Notes 11/28/2022 03/31/2027 1,450,000 1,363,566 1,423,492 4.00%58,000 U.S. Treasury Notes 05/17/2024 04/15/2027 2,000,000 1,995,469 2,024,922 4.58%91,600 U.S. Treasury Notes 05/13/2025 05/15/2027 2,000,000 1,937,734 1,957,500 4.01%80,200 U.S. Treasury Notes 10/05/2022 06/30/2027 1,500,000 1,451,309 1,489,512 4.00%60,000 U.S. Treasury Notes 06/21/2024 07/31/2027 2,000,000 1,901,875 1,966,953 4.46%89,200 U.S. Treasury Notes 01/20/2023 08/31/2027 1,600,000 1,568,438 1,584,688 3.59%57,440 U.S. Treasury Notes 03/08/2023 09/30/2027 1,250,000 1,234,131 1,262,598 4.44%55,500 U.S. Treasury Notes 10/17/2024 01/31/2028 1,300,000 1,284,105 1,297,004 3.90%50,700 U.S. Treasury Notes 09/27/2024 02/15/2028 1,500,000 1,464,141 1,470,527 3.51%52,650 August 31, 2025 Page 4 Town of Danville Treasurer's Report of Investments - Detail Town Funds Yield to Annual Description Purchase Date Maturity Date Par Value Cost Market Value Maturity Interest August 31, 2025 U.S. Treasury Notes 11/08/2024 03/31/2028 1,000,000 982,344 1,000,860 4.19%41,900 U.S. Treasury Notes 12/30/2024 05/31/2028 1,750,000 1,711,445 1,751,436 4.33%75,775 U.S. Treasury Notes 12/13/2024 08/31/2028 1,000,000 1,004,102 1,022,109 4.25%42,500 U.S. Treasury Notes 04/10/2024 11/15/2028 1,800,000 1,687,078 1,774,336 4.66%83,880 U.S. Treasury Notes 09/05/2024 05/31/2029 1,200,000 1,155,984 1,163,625 3.60%43,200 U.S. Treasury Notes 10/29/2024 07/31/2029 1,500,000 1,493,320 1,519,804 4.10%61,500 U.S. Treasury Notes 03/05/2025 08/31/2029 2,000,000 1,923,750 1,962,500 4.06%81,200 U.S. Treasury Notes 06/03/2025 11/30/2029 2,000,000 1,989,141 2,017,030 4.01%80,200 U.S. Treasury Notes 07/30/2025 12/31/2029 2,000,000 1,996,875 2,017,265 3.91%78,200 Subtotal 43,650,000$ 42,642,449$ 43,429,798$ 3.90%1,702,735$ Cash Equivalents Wells Fargo Trsry Plus M Mkt - reserve fund (2001 COP)502,814 502,814 502,814 3.72%18,705 Wells Fargo Trsry Plus M Mkt - reserve fund (2005 COP)355,385 355,385 355,385 3.75%13,327 Bank of New York 3,619,459 3,619,459 3,619,459 3.51%127,043 US Bank 1,220,062 1,220,062 1,220,062 0.00%0 LAIF 10,850,665 10,850,665 10,850,665 4.25%461,262 Subtotal 16,548,385$ 16,548,385$ 16,548,385$ 3.74%620,336 Asset-Backed Securities BMW Vehicle Owner Trust 2022-A A3 05/10/2022 08/25/2026 6,444 6,443 6,437 3.23%208 John Deere Owner Trust 2022-A A3 03/10/2022 09/15/2026 16,397 16,393 16,380 2.34%384 GM Financial Auto Leasing Trust 2023-3 A3 08/08/2023 11/20/2026 67,069 67,061 67,153 5.38%3,608 GM Financial Consumer Auto Receiv 2022-2 A3 04/05/2022 02/16/2027 32,238 32,232 32,176 3.13%1,009 GM Finacial Automobile Leasing Trust 2025-1 A3 02/05/2025 02/21/2028 405,000 404,952 408,133 4.66%18,873 BMW Vehicle Owner Trust 2023-A A3 07/11/2023 02/25/2028 111,128 111,109 111,895 5.47%6,079 BMW Vehicle Lease Trust 2025-1 A3 06/03/2025 06/26/2028 250,000 249,995 251,876 4.82%12,050 Toyota Auto Receivables Owner 2023-D A3 11/07/2023 08/15/2028 255,000 254,973 257,925 5.61%14,306 Chase Issuance Trust 2023-1 A 09/07/2023 09/15/2028 995,000 994,724 1,006,335 5.23%52,039 BMW Vehicle Owner Trust 2024-A A3 06/04/2024 02/26/2029 420,000 419,936 424,762 5.18%21,756 Bank of America Credit Card Trust 2024-1 A 06/06/2024 05/15/2029 475,000 474,973 482,775 4.93%23,418 John Deere Owner Trust 2025 A3 03/04/2025 09/17/2029 470,000 469,970 472,519 5.09%23,923 BMW Vehicle Owner Trust 2025-A A3 02/04/2025 09/25/2029 635,000 634,937 640,819 4.56%28,956 Honda Auto Receivables 2025-2 Owner Trust 04/29/2025 10/15/2029 310,000 309,965 311,563 4.15%12,865 Mercedes-Benz Auto Receivables Trust 2025-1 01/14/2025 12/17/2029 560,000 559,881 568,542 4.84%27,104 Subtotal 5,008,276$ 5,007,544$ 5,059,290$ 4.92%246,576$ Page 5 Town of Danville Treasurer's Report of Investments - Detail Town Funds Yield to Annual Description Purchase Date Maturity Date Par Value Cost Market Value Maturity Interest August 31, 2025 Supranational International Finance Corp Note 11/29/2023 01/15/2027 925,000 921,985 931,924 4.49%41,533 Inter-American Dev Bank Note 01/30/2024 02/01/2027 1,000,000 1,004,020 1,007,783 4.23%42,300 International Bank For Reconstruction and Dev 03/11/2024 07/12/2028 1,500,000 1,456,965 1,494,213 4.23%63,450 Subtotal 3,425,000$ 3,382,970$ 3,433,920$ 4.30%147,283$ US Corporate Wal-Mart Stores Note 09/26/2022 09/09/2025 700,000 685,776 699,883 4.64%32,480 Microst Callable Note Cont 01/20/2023 11/03/2025 1,000,000 970,060 997,916 4.28%42,800 Apple Inc Callable Note Cont 02/01/2023 02/23/2026 750,000 728,265 746,428 4.27%32,025 Toyota Motor Credit Corp 02/08/2024 06/18/2026 1,000,000 921,800 976,861 4.68%46,800 Paccar Financial Corp Note 08/03/2023 08/10/2026 515,000 514,743 519,495 5.07%26,111 Bank of America NA Callable Note Cont 08/24/2023 08/18/2026 1,000,000 1,001,360 1,012,517 5.48%54,800 Morgan Stanley Bank NA Callable Note 10/30/2023 10/30/2026 440,000 440,000 448,629 5.88%25,872 Honeywell Intl Callable Note 01/11/2023 11/01/2026 1,000,000 933,280 982,292 4.42%44,200 Pepsico Inc. Callable Note Cont 11/08/2023 11/10/2026 360,000 359,903 364,560 5.13%18,468 JP Morgan Chase Bank Callable Note 12/05/2023 12/08/2026 405,000 405,000 410,221 5.11%20,696 John Deere Capital Corp 01/10/2024 01/08/2027 1,000,000 999,220 1,007,587 4.53%45,300 Cisco Systems Inc 02/26/2024 02/26/2027 1,000,000 999,620 1,012,521 4.81%48,100 State Street Corp 03/13/2024 03/18/2027 1,065,000 1,065,000 1,081,455 4.99%53,144 Caterpillar Financial Service Note 05/15/2024 05/14/2027 1,000,000 1,002,930 1,017,372 4.89%48,900 Blackrock Funding Inc 07/17/2024 07/26/2027 690,000 689,979 698,654 4.60%31,740 Amazon.com Inc 07/10/2024 08/22/2027 1,000,000 954,920 987,142 4.73%47,300 Visa Inc 08/19/2024 09/15/2027 1,000,000 960,360 978,518 4.14%41,400 Paccar Financial Corp Note 08/04/2025 08/08/2028 540,000 539,681 541,392 4.02%21,708 Pepsico INC. 07/29/2025 01/15/2029 1,000,000 997,580 1,002,340 4.18%41,800 Bank of New York Mellon Corp 02/12/2025 02/01/2029 1,250,000 1,240,750 1,264,911 4.81%60,125 Apple Inc.03/05/2025 09/11/2029 500,000 457,525 468,316 4.29%21,450 Subtotal 17,215,000$ 16,867,752$ 17,219,010$ 4.67%805,218$ TOTAL 112,931,557$ 111,151,376$ 112,827,734$ 4.16%4,693,127$ Source: Chandler Asset Management US Bank Local Agency Investment Fund (LAIF) Page 6 Town of Danville Treasurer's Report of Investments - Detail August 31, 2025 Yield to Annual Description Purchase Date Maturity Date Par Value Cost Market Value Maturity Interest Cash Equivalents LAIF 1,897,566 1,897,566 1,897,566 4.25%80,666 TOTAL 1,897,566$ 1,897,566$ 1,897,566$ 4.25% $80,666 Source: Local Agency Investment Fund (LAIF) Trust Fund Page 7 Town of Danville Treasurer's Report of Investments - Detail August 31, 2025 Yield to Annual Description Purchase Date Maturity Date Par Value Cost Market Value Maturity Interest Cash Equivalents LAIF - redemption fund 78,118 78,118 78,118 4.25%3,321 Wells Fargo Trsry Plus M Mkt - reserve fund (TRBs)375,526 375,526 375,526 3.60%13,519 Wells Fargo Trsry Plus M Mkt - interest acct (TRBs)70 70 70 3.75%3 Wells Fargo Trsry Plus M Mkt - debt service acct (TRBs)511,004 511,004 511,004 3.75%19,163 Subtotal 964,718$ 964,718$ 964,718$ 3.73%36,005$ TOTAL 964,718$ 964,718$ 964,718$ 3.73%36,005$ Source: BNY Trust Company Local Agency Investment Fund (LAIF) Community Development Agency/Successor Agency Page 8 Town of Danville Treasurer's Report of Investments - Detail Yield to Annual Description Purchase Date Maturity Date Par Value Cost Market Value Maturity Interest U.S. Treasury Obligations U.S. Treasury Bill 9/5/2024 9/4/2025 250,000 239,876 249,941 4.20%10,500 U.S. Treasury Bill 12/16/2024 12/15/2025 250,000 249,385 249,912 4.26%10,650 U.S. Treasury Bill 3/27/2025 3/31/2026 225,000 217,582 220,890 4.12%9,270 U.S. Treasury Bill 6/11/2025 6/15/2026 250,000 249,970 250,354 4.14%10,350 Subtotal 975,000$ 956,813$ 971,097$ 4.18%40,770$ Cash Equivalents LAIF - improvement fund 137,437 137,437 137,437 4.25%5,842 Bank of New York-Improvement fd 16,832 16,832 16,832 3.51%591 Subtotal 154,269$ 154,269$ 154,269$ 4.17%6,433$ Total 1,129,269$ 1,111,082$ 1,125,366$ 4.18%47,203$ Source: Chandler Asset Management BNY Trust Company Local Agency Investment Fund (LAIF) Northeast Roadway Improvement Assessment District (NERIAD) August 31, 2025 Page 9