HomeMy WebLinkAbout011624-06.3
1
ADMINISTRATIVE STAFF REPORT 6.3
TO: Mayor and Town Council January 16, 2024
SUBJECT: November 2023 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 November 2023:
October November October November
2023 2023 2023 2023
Town Funds $103,894,647 $104,001,946 $100,919,286 $101,887,349
Trust Funds 1,640,102 1,734,634 1,640,102 1,734,634
Assessment & SA 1,665,693 1,667,867 1,676,054 1,680,414
Total Cash & Investments $107,200,442 $107,404,447 $104,235,442 $105,302,397
Total Cash & Investments
Year-to-Year Comparison
2022 $106,704,888 $105,540,060 $102,275,178 $101,606,885
Cost Basis Market Value
Purchases for the month of November 2023 consisted of one Morgan Stanley Bank NA
Callable Note Cont for $440,000 (maturity date October 30, 2026), one Federal Home Loan
Mortgage Corporation K082 A2 for $940,742 (maturity date September 25, 2028), one
Pepsico Inc. Callable Note Cont for $359,903 (maturity date November 10, 2026), one
Toyota Auto Receivables Owner 2023-D A3 for $254,973 (maturity date August 15, 2028),
and one Federal Farm Credit Bank Note for $1,743,508 (maturity date November 15,
2027).
There were no purchases for the NERIAD Fund for the month of November 2023.
November 2023 Treasurer’s Report 2 January 16, 2024
Maturities for the month of November 2023 included one Federal Home Loan Mortgage
Corporation Note for $1,453,691, one Int’l. Bank Recon & Development Note for $354,237,
and one Federal National Mortgage Association Note for $1,499,160.
Partial maturities (principal paid down) for the month of November 2023 included one
John Deere Owner Trust 2022-A A3 for $29,645, one John Deere Owner Trust 2021-A A3
for $16,114, one John Deere Owner Trust 2021-B A3 for $16,856, one Mercedes-Benz Auto
Lease Trust 2021-B A3 for $37,910, one Toyota Auto Receivables Trust 2021-B A3 for
$46,598, one Toyota Auto Receivables Trust 2021-D A3 for 13,060, one GM Financial Auto
Receivables 2022-1 A3 for $8,774, one GM Financial Auto Lease Trust 2022-2 A3 for
$8,185, one Honda Auto Receivables Trust 2021-4 A3 for $14,131, and one BMW Vehicle
Lease Trust 2022-1 A3 for $24,587.
There were no maturities for NERIAD Fund for the month of November 2023.
The Town’s net cash position changed from $12,895,619 to $12,786,713 during the month
of November 2023. This consisted of operating revenues in excess of operating expenses
of -$33,256, net funds invested of $216,178, premium/discount recognition of $2,916 and
interest received of $137,612.
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 November 2023 Month End Treasurer’s Report.
Prepared by:
Lani Ha
Finance Director/Treasurer
November 2023 Treasurer’s Report 3 January 16, 2024
Reviewed by:
Joseph A. Calabrigo
Town Manager
Attachment: November 2023 Month End Treasurer’s Report
Town of Danville
Treasurer's Report of Investments - Summary
November 30, 2023
Yield to
Description Par Value Cost Market Value % Total Maturity
TOWN FUNDS
U.S. Treasury Obligations 43,400,000$ 42,788,463$ 41,527,176$ 41%1.96%
Federal Agency Issues 21,195,000 21,230,577 20,810,036 20%2.83%
Cash Equivalents 12,786,713 12,786,713 12,786,713 13%3.00%
Collateralized Mortgage Obligation 5,720,000 5,486,128 5,446,694 5%4.56%
ABS Honda Auto Receivables Trust 2021-4 5,387,729 5,386,941 5,305,402 5%2.92%
Commercial Paper 0 0 0 0%0.00%
Negotiable CD 0 0 0 0%0.00%
Supranational 2,250,000 2,278,055 2,169,396 2%0.49%
US Corporate 14,145,000 14,045,069 13,841,932 14%2.77%
Total / Weighted Average 104,884,442$ 104,001,946$ 101,887,349$ 100%2.54%
Maturities
0 - 30 Days 15,034,571$ 15%
31-60 1,628,871 2%
61 - 90 1,780,815 2%
91 - 120 2,470,719 2%
121 - 180 6,316,715 6%
181 - 270 4,374,681 4%
271 - 365 9,774,201 10%
1 - 2 Years 28,407,913 28%
2 - 3 15,844,516 16%
3 - 5 16,254,347 16%
Over 5 Years 0 0%
101,887,349$ 100%
Total / Weighted Average
Town Funds Weighted Average Quality is AAA
Page 1
Town of Danville
Treasurer's Report of Investments - Summary
November 30, 2023
Description Par Value Cost Market Value % Total
TRUST FUND
Cash Equivalents 1,734,634$ 1,734,634$ 1,734,634$ 100%
CDA/SUCCESSOR AGENCY
Cash Equivalents 439,643$ 439,643$ 439,643$ 100%
Total 439,643$ 439,643$ 439,643$ 100%
ASSESSMENT DISTRICTS
NERIAD
Federal Agency Issues -$ -$ -$ 0%
U.S. Treasury Obligations 900,000 870,168 882,715 71%
Cash Equivalents 358,056 358,056 358,056 29%
Subtotal 1,258,056$ 1,228,224$ 1,240,771$ 100%
Total 1,258,056$ 1,228,224$ 1,240,771$ 100%
SUMMARY TOTAL
Town Funds 104,884,442$ 104,001,946$ 101,887,349$
Trust Fund 1,734,634 1,734,634 1,734,634
CDA/Successor Agency 439,643 439,643 439,643
NERIAD 1,258,056 1,228,224 1,240,771
Summary Total 108,316,775$ 107,404,447$ 105,302,397$
Page 2
Town of Danville
Treasurer's Report of Investments
CDA
Town Funds Trust Funds Successor Agency NERIAD Total
Beginning Balance, at cost 103,894,647$ 1,640,102$ 438,099$ 1,227,594$ 107,200,442$
Purchases, at cost
Morgan Stanley Bank NA Callable Note Cont 9/3 440,000 440,000
FHLMC K082 A2 940,742 940,742
Pepsico Inc. Callable Note Cont 10/10/2026 359,903 359,903
Toyota Auto Receivables Owner 2023-D A3 254,973 254,973
FFCB Note 1,743,508 1,743,508
Sales/Maturations/Call
FHLMC Note (1,453,691) (1,453,691)
Int'l Bank Recon & Development Note (354,237) (354,237)
FNMA Note (1,499,160) (1,499,160)
Redemption (215,860) (215,860)
Premium/Discount 2,916 2,916
Interest Received 137,612 1,543 442 139,598
Net change in Cash (249,407) 94,533 - 188 (154,688)
Realized gains (losses)-
Ending Balance, at cost 104,001,946$ 1,734,634$ 439,643$ 1,228,224$ 107,404,447$
November 30, 2023
Page 3
Town of Danville
Treasurer's Report of Investments - DetailTown Funds
Yield to Annual
Description Purchase Date Maturity Date Par Value Cost Market Value Maturity Interest
Federal Agency Issues
FHLMC Note 12/09/2020 12/04/2023 1,500,000 1,499,610 1,499,358 0.26%3,900
FNMA Note 03/24/2020 02/05/2024 1,700,000 1,808,052 1,691,078 0.82%13,940
FHLB Note 03/03/2020 03/08/2024 1,500,000 1,560,525 1,485,587 0.85%12,750
FHLB Note 0801/2022 11/08/2024 900,000 858,798 865,776 3.11%27,990
FHLB Note 07/27/2022 12/20/2024 1,000,000 950,740 957,634 3.15%31,500
FFCB Note 01/06/2022 01/06/2025 595,000 593,661 569,734 1.20%7,140
FFCB Note 02/17/2022 02/14/2025 750,000 748,365 721,558 1.83%13,725
FFCB Note 02/28/2022 02/14/2025 750,000 748,057 721,261 1.83%13,725
FFCB Note 03/14/2022 02/25/2025 750,000 743,441 720,392 2.06%15,450
FFCB Note 05/03/2022 05/09/2025 1,000,000 998,050 970,397 2.97%29,700
FNMA Note 12/09/2021 08/25/2025 1,000,000 971,060 926,615 1.17%11,700
FFCB Note 06/22/2023 06/23/2026 2,000,000 1,997,620 1,992,246 4.42%88,400
FFCB Note 08/09/2023 08/14/2026 1,500,000 1,496,550 1,499,160 4.58%68,700
FFCB Note 11/09/2023 11/15/2027 1,750,000 1,743,508 1,759,131 4.73%82,775
FHLB Note 05/15/2023 12/10/2027 1,500,000 1,536,930 1,490,544 3.66%54,900
FFCB Note 04/27/2023 04/25/2028 1,500,000 1,507,905 1,463,066 3.76%56,400
FHLB Note 07/06/2023 06/09/2028 1,500,000 1,467,705 1,476,499 4.49%67,350
Subtotal 21,195,000$ 21,230,577$ 20,810,036$ 2.83%600,045$
Collateralized Mortgage Obligation
FHLMC K063 06/06/2023 01/25/2027 1,000,000 965,625 958,106 4.48%44,800
FHLMC K066 A2 05/18/2023 06/25/2027 1,000,000 958,984 943,880 4.28%42,800 FHLMC K068 A2 05/12/2023 08/25/2027 1,000,000 970,820 945,307 4.00%40,000
FHLMC K073 A2 05/24/2023 01/25/2028 720,000 691,988 679,835 4.34%31,248
FHLMC K081 A2 09/05/2023 08/25/2028 1,000,000 957,969 959,644 4.88%48,800
FHLMC K082 A2 10/30/2023 09/25/2028 1,000,000 940,742 959,922 5.33%53,300
Subtotal 5,720,000$ 5,486,128$ 5,446,694$ 4.56%260,948$
U.S. Treasury Obligations
U.S. Treasury Notes 01/08/2021 12/15/2023 750,000 747,861 748,499 0.22%1,650
U.S. Treasury Notes 04/14/2021 04/15/2024 1,000,000 1,000,352 982,031 0.36%3,600
U.S. Treasury Notes 07/27/2022 04/30/2024 1,000,000 981,914 986,328 3.06%30,600
U.S. Treasury Notes 05/12/2021 05/15/2024 1,250,000 1,246,094 1,221,485 0.36%4,500
U.S. Treasury Notes 06/10/2021 06/15/2024 1,500,000 1,496,543 1,460,216 0.33%4,950
U.S. Treasury Notes 07/28/2021 07/15/2024 1,500,000 1,499,648 1,455,234 0.38%5,700
U.S. Treasury Notes 02/09/2021 08/31/2024 1,000,000 1,034,805 970,469 0.26%2,600
U.S. Treasury Notes 09/13/2021 09/15/2024 1,400,000 1,397,266 1,347,445 0.44%6,160
U.S. Treasury Notes 08/06/2021 10/31/2024 1,350,000 1,395,246 1,305,176 0.45%6,075
U.S. Treasury Notes 11/10/2021 11/15/2024 1,500,000 1,497,832 1,437,774 0.80%12,000
U.S. Treasury Notes 01/26/2022 12/15/2024 850,000 840,637 814,307 1.39%11,815
U.S. Treasury Notes 03/15/2022 12/31/2024 1,500,000 1,488,633 1,446,621 2.03%30,450
U.S. Treasury Notes 02/24/2021 01/31/2025 1,500,000 1,557,012 1,437,012 0.40%6,000
November 30, 2023
Page 4
Town of Danville
Treasurer's Report of Investments - DetailTown Funds
Yield to Annual
Description Purchase Date Maturity Date Par Value Cost Market Value Maturity Interest
November 30, 2023
U.S. Treasury Notes 02/03/2022 02/28/2025 1,000,000 990,820 952,813 1.43%14,300
U.S. Treasury Notes 03/12/2021 03/31/2025 1,350,000 1,342,150 1,271,954 0.66%8,910
U.S. Treasury Notes 01/26/2021 04/30/2025 1,000,000 1,001,953 971,359 0.33%3,300
U.S. Treasury Notes 04/28/2022 04/30/2025 1,000,000 932,344 903,875 2.74%27,400
U.S. Treasury Notes 06/11/2021 05/31/2025 1,500,000 1,483,359 1,399,746 0.53%7,950
U.S. Treasury Notes 07/29/2021 06/30/2025 1,500,000 1,482,246 1,395,117 0.56%8,400
U.S. Treasury Notes 12/02/2021 07/31/2025 1,350,000 1,310,871 1,251,756 1.06%14,310
U.S. Treasury Notes 04/21/2022 08/15/2025 1,500,000 1,454,883 1,431,153 2.96%44,400
U.S. Treasury Notes 04/21/2022 09/30/2025 1,500,000 1,502,109 1,453,829 2.96%44,400
U.S. Treasury Notes 06/02/2022 10/31/2025 1,600,000 1,606,563 1,549,750 2.87%45,920
U.S. Treasury Notes 06/09/2022 11/15/2025 1,700,000 1,655,840 1,621,773 3.05%51,850
U.S. Treasury Notes 07/13/2022 12/31/2025 1,100,000 1,079,031 1,055,786 3.21%35,310
U.S. Treasury Notes 08/03/2022 03/31/2026 1,800,000 1,753,523 1,707,680 3.00%54,000
U.S. Treasury Notes 09/08/2022 04/30/2026 1,600,000 1,542,500 1,520,688 3.43%54,880
U.S. Treasury Notes 06/07/2023 09/30/2026 2,000,000 1,848,984 1,850,782 4.09%81,800
U.S. Treasury Notes 11/28/2022 03/31/2027 1,450,000 1,363,566 1,364,869 4.01%58,145
U.S. Treasury Notes 10/05/2022 06/30/2027 1,500,000 1,451,309 1,443,222 4.01%60,150
U.S. Treasury Notes 01/20/2023 08/31/2027 1,600,000 1,568,438 1,530,000 3.59%57,440
U.S. Treasury Notes 03/08/2023 09/30/2027 1,250,000 1,234,131 1,238,427 4.44%55,500
Subtotal 43,400,000$ 42,788,463$ 41,527,176$ 1.96%854,465$
Cash Equivalents
Wells Fargo Trsry Plus M Mkt - reserve fund (2001 COP)484,954 484,954 484,954 4.86%23,569
Wells Fargo Trsry Plus M Mkt - reserve fund (2005 COP)359,378 359,378 359,378 4.86%17,466
Bank of New York 4,638,215 4,638,215 4,638,215 2.48%115,028
US Bank 1,372,418 1,372,418 1,372,418 0.00%23
LAIF 5,931,748 5,931,748 5,931,748 3.84%227,779
Subtotal 12,786,713$ 12,786,713$ 12,786,713$ 3.00%383,864
Asset-Backed Securities
Mercedes-Benz Auto Lease Trust 2021-B A3 06/22/2021 11/15/2024 70,275 70,270 69,995 0.40%281
BMW Vehicle Lease Trust 2022-1-A3 01/11/2022 03/25/2025 90,425 90,412 89,737 1.11%1,004
GM Financial Auto Lease Trust 2022-2 A3 05/30/2022 06/20/2025 441,815 441,769 438,538 3.45%15,243
John Deere Owner Trust 2021-A A3 03/02/2021 09/15/2025 82,801 82,786 81,108 0.37%306
Toyota Auto Receivables Trust 2021-B A3 06/08/2021 11/17/2025 461,818 461,768 450,832 0.26%1,201
Honda Auto Receivables Trust 2021-4 A3 11/16/2021 01/21/2026 194,453 194,412 188,205 0.89%1,731
John Deere Owner Trust 2021-B A3 07/13/2021 03/16/2026 199,941 199,923 193,332 0.52%1,040
Toyota Auto Receivables Trust 2021-D A3 11/09/2021 04/15/2026 185,735 185,731 179,670 0.71%1,319
Honda Auto Receivables Trust 2022-1 A3 02/15/2022 05/15/2026 425,000 424,936 412,135 1.89%8,033
BMW Vehicle Owner Trust 2022-A A3 05/10/2022 08/25/2026 300,000 299,984 294,009 3.23%9,690
John Deere Owner Trust 2022-A A3 03/10/2022 09/16/2026 295,013 294,947 287,270 2.34%6,903
Hyundai Auto Receivables Trust 2022-A A3 03/09/2022 10/15/2026 595,000 594,977 579,125 2.23%13,269
GM Financial Auto Receivables 2022-1 A3 01/11/2022 11/16/2026 150,453 150,439 145,536 1.27%1,911
Page 5
Town of Danville
Treasurer's Report of Investments - DetailTown Funds
Yield to Annual
Description Purchase Date Maturity Date Par Value Cost Market Value Maturity Interest
November 30, 2023
GM Financial Auto Leasing 2023-3 A3 08/08/2023 11/20/2026 210,000 209,975 209,437 5.45%11,445
GM Financial Securitized ART 2022-2 A3 04/05/2022 02/16/2027 260,000 259,946 254,099 3.13%8,138
BMW Vehicle Owner Trust 2023-A A3 07/11/2023 02/25/2028 175,000 174,969 175,794 5.54%9,695
Toyota Auto Receivables Owner 2023-D A3 11/07/2023 08/15/2028 255,000 254,973 257,446 5.61%14,306
Chase Issuance Trust 23-A1 A 09/07/2023 09/15/2028 995,000 994,724 999,134 5.23%52,039
Subtotal 5,387,729$ 5,386,941$ 5,305,402$ 2.92%157,551$
Supranational
Inter-American Dev Bank Note 09/15/2021 09/23/2024 1,250,000 1,249,075 1,202,486 0.52%6,500
International Finance Corp Note 07/29/2021 10/16/2024 1,000,000 1,028,980 966,910 0.46%4,600
Subtotal 2,250,000$ 2,278,055$ 2,169,396$ 0.49%11,100$
US Corporate
American Honda Finance Note 08/19/2019 01/12/2024 950,000 1,008,634 947,756 2.07%19,665
John Deere Capital Corp Note 03/01/2021 01/17/2024 615,000 614,564 611,120 0.47%2,891
Charles Schwab Corp Callable Note 11/17/2021 03/18/2024 1,000,000 996,020 985,132 0.92%9,200
Amazon.com Inc Callable Note Cont 05/10/2021 05/12/2024 570,000 569,168 559,918 0.69%3,933
Amazon.com Inc Callable Note Cont 12/06/2021 05/12/2024 430,000 424,973 418,066 0.69%2,967
Caterpillar Financial Service Note 05/10/2021 05/17/2024 905,000 903,787 884,400 0.50%4,525
John Deere Capital Corp Note 06/07/2021 06/07/2024 540,000 539,325 526,166 0.49%2,646 Paccar Financial Corp Note 08/03/2021 08/09/2024 385,000 384,792 371,858 0.52%2,002
MasterCard Inc Callable Note 1x 02/25/2022 02/03/0225 1,000,000 999,010 962,875 2.03%20,300
Apple Inc Callable Note Cont 02/25/2022 05/11/2025 500,000 485,870 473,408 2.04%10,200
JP Morgan Chase & Co Callable Note 05/24/2021 06/01/2025 750,000 750,972 729,695 2.03%15,225
Colgate Palmolive Co. Note 08/01/2022 08/15/2025 470,000 469,567 457,265 3.13%14,711
Wal-Mart Stores Note 09/26/2022 02/06/2026 700,000 685,776 688,943 4.64%32,480
Microst Callable Note Cont 01/20/2023 11/03/2025 1,000,000 970,060 969,261 4.28%42,800
State Street Bank Callable Note Cont 02/02/2025 02/06/2026 265,000 265,000 252,581 2.80%7,420
Apple Inc Callable Note Cont 02/01/2023 02/23/2026 750,000 728,265 725,669 4.27%32,025
Paccar Financial Corp Note 08/03/2023 08/10/2026 515,000 514,743 517,160 5.07%26,111
Bank of America NA Callable Note Cont 08/24/2023 08/18/2026 1,000,000 1,001,360 1,007,718 5.48%54,800
Morgan Stanley Bank NA Callable Note 10/30/2023 10/30/2026 440,000 440,000 447,040 5.88%25,872
Honeywell Intl Callable Note 01/11/2023 11/01/2026 1,000,000 933,280 942,459 4.43%44,300
Pepsico Inc. Callable Note Cont 11/08/2023 11/10/2026 360,000 359,903 363,442 5.13%18,468
Subtotal 14,145,000$ 14,045,069$ 13,841,932$ 2.77%392,540$ TOTAL 104,884,442$ 104,001,946$ 101,887,349$ 2.54%2,660,513$
Source:
Chandler Asset Management
US Bank
Local Agency Investment Fund (LAIF)
Page 6
Town of Danville
Treasurer's Report of Investments - Detail
November 30, 2023
Yield to Annual
Description Purchase Date Maturity Date Par Value Cost Market Value Maturity Interest
Cash Equivalents
LAIF 1,734,634 1,734,634 1,734,634 3.84%66,610
TOTAL 1,734,634$ 1,734,634$ 1,734,634$ 3.84% $66,610
Source:
Local Agency Investment Fund (LAIF)
Trust Fund
Page 7
Town of Danville
Treasurer's Report of Investments - Detail
November 30, 2023
Yield to Annual
Description Purchase Date Maturity Date Par Value Cost Market Value Maturity Interest
Cash Equivalents
LAIF - redemption fund 45,704 45,704 45,704 3.84%1,755
Wells Fargo Trsry Plus M Mkt - reserve fund (TRBs)393,214 393,214 393,214 4.86%19,110
Wells Fargo Trsry Plus M Mkt - interest acct (TRBs)593 593 593 4.86%29
Wells Fargo Trsry Plus M Mkt - debt service acct (TRBs)132 132 132 4.86%6
Subtotal 439,643$ 439,643$ 439,643$ 4.75%20,900$
TOTAL 439,643$ 439,643$ 439,643$ 4.75%20,900$
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 Note 3/20/2023 12/15/2023 250,000 242,148 249,500 4.51%11,275
U.S. Treasury Note 6/28/2023 3/15/2024 250,000 241,172 246,367 5.39%13,475
U.S. Treasury Bill 10/30/2023 4/25/2024 150,000 146,082 146,082 5.53%8,295
U.S. Treasury Bill 10/2/2023 6/13/2024 250,000 240,766 240,766 5.47%13,675
Subtotal 900,000$ 870,168$ 882,715$ 5.19%46,720$
Cash Equivalents
LAIF - improvement fund 331,320 331,320 331,320 3.84%12,723
Bank of New York-Improvement fd 26,736 26,736 26,736 2.48%663
Subtotal 358,056$ 358,056$ 358,056$ 3.74%13,386$
Total 1,258,056$ 1,228,224$ 1,240,771$ 4.78%60,106$
Source:
Chandler Asset Management
BNY Trust Company
Local Agency Investment Fund (LAIF)
Northeast Roadway Improvement Assessment District (NERIAD)
November 30, 2023
Page 9