Loading...
HomeMy WebLinkAbout101921-06.3TO: ADMINISTRATNE STAFF REPORT 6.3 Mayor and Town Council SUBJECT: August 2021 Month End Treasurer's Report BACKGROUND October 19, 2021 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 2021: Town Funds Trust Funds Assessment & SA Total Cash & Investments Total Cash & Investments Year -to -Year Comparison 2020 Cost Basis July August 31, 2021 31, 2021 $96,432,440 1,115,682 2,449,867 $99,997,989 $85,174,778 $95,199,832 1,136,341 2,428,226 $98,764,399 $83,767,206 Market Value July 31, 2021 $97,527,701 1,115,682 2,448,285 $101,091,668 August 31, 2021 $96,203,397 1,136,341 2,426,400 $99,766,138 $87,258,042 $85,767,267 Purchases for the month of August 2021 consisted of one International Finance Corp Note for $1,028,980 (maturity date October 16, 2024), one Paccar Financial Corp Note for $384,792 (maturity date August 9, 2024), and one U.S. Treasury Note for $1,395,246 (maturity date October 31, 2024). There were no purchases for the NERIAD Fund for the month of August 2021. There were no maturities for the month of August 2021. Sales before maturities for the month included one Honda Auto Receivables Trust 2019- 3 A3(partial) for $39,110, one John Deere Owner Trust 2019-B A3(partial) for $14,935, one Nissan Auto Receivables Owner 2019-C A3(partial) for $41,258, one Honda Auto Receivables Trust 2018-2 A3(partial) for $3,679, and one Honda Auto Receivables Trust 2018-3 A3(partial) for $23,839. There were no maturities for the NERIAD Fund for the month of August 2021. The Town's net cash position changed from $20,729,406 to $16,810,591 during the month of August 2021. This consisted of operating expenses in excess of operating revenues of -$1,287,724 net funds invested of -$2,686,197, premium/ discount recognition of $9 and interest received of $55,097. 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 Towns Investment Policy. PUBLIC CONTACT Posting of the meeting agenda serves as notice to the general public. RECOMMENDATION Accept the August 2021 Month End Treasurer's Report. Prepared by: Lani Ha Finance Director/ Treasurer Reviewed by: Joseph A. Calabrigo Town Manager Attachment: August 2021 Month End Treasurer's Report Aug 2021 Treasurer's Report 2 October 19, 2021 Description TOWN FUNDS U.S. Treasury Obligations Federal Agency Issues Cash Equivalents Asset -Backed Securities Commercial Paper Negotiable CD Supranational US Corporate Total / Weighted Average 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 of Danville Treasurer's Report of Investments - Summary August 31, 2021 Yield to Par Value Cost Market Value % Total Maturity $ 26,350,000 $ 26,214,120 $ 26,599,053 28% 1.22% 35,515,000 35,666,625 36,037,012 37% 1.28% 16,810,591 16,810,591 16,810,591 17% 0.18% 3,472,907 3,472,597 3,485,591 4% 0.96% 0 0 0 0% 0.00% 0 0 0 0% 0.00% 2,455,000 2,437,435 2,492,813 3% 1.57% 10,520,000 10,598,464 10,778,337 11% 1.86% 96,203,397 1.14% $ 95,123,498 $ 95,199,832 $ 100% Town Funds Weighted Average Quality is AAA Page 1 $ 15,894,699 17% 1,251,068 1% 3,114,499 3% 1,004,964 1% 1,831,739 2% 4,759,323 5% 2,421,367 3% 32,570,213 34% 23,557,845 24% 9,797,680 10% 0 0% $ 96,203,397 100% Description TRUST FUND Cash Equivalents CDA/SUCCESSOR AGENCY Cash Equivalents Total ASSESSMENT DISTRICTS NERIAD Federal Agency Issues U.S. Treasury Obligations Cash Equivalents Subtotal Total SUMMARY TOTAL Town Funds Trust Fund CDA/Successor Agency NERIAD Summary Total Par Valu Town of Danville Treasurer's Report of Investments - Summary August 31, 2021 Value Cost Market Value $ 1,136,341 $ 1,136,341 $ 1,136,341 $ 1.170,686 $ 1,170,686 $ 1,170,686 $ 1,170,686 $ 1,170,686 $ 1,170,686 860,000 862,412 860,586 395.128 395,128 395,128 $ 1,255,128 $ 1,257,540 $ 1,255,714 % Total 100% 100% 100% 0% 69% 31% 100% $ 1,255,128 $ 1,257,540 $ 1,255,714 100% $ 95,123,498 $ 95,199,832 $ 96,203,397 1,136,341 1,136,341 1,136,341 1,170,686 1,170,686 1,170,686 1,255,128 1,257.540 1,255,714 $ 98,685,653 $ 98,764,399 $ 99,766,138 Page 2 Town of Danville Treasurer's Report of Investments August 31, 2021 Page 3 CDA Town Funds Trust Funds Successor Aeencv NERIAD Total Beginning Balance, at cost $ 96,432,440 $ 1,115,682 $ 1,183,656 $ 1,266,211 $ 99,997,989 Purchases, at cost International Finance Corp Note $ 1,028,980 1,028,980 Paccar Financial Corp Note $ 384,792 384,792 US Treasury Note $ 1,395,246 1,395,246 US Treasury Bill $ - - Sales/Maturations/Call Wells Fargo Treasury Plus MMFD 453 $ Wells Fargo Treasury Plus MMFD 453 $ Redemption $ (122,821) (122,821) Premium/Discount $ 9 - - 9 Interest Received $ 55,097 - 3 227 55,327 Net change in Cash $ (3,973,914) 20,660 (12,974 (8,898) (3,975,126) Realized gains (losses) _ Ending Balance, at cost $ 95,199,832 $ 1,136,341 $ 1,170,686 $ 1,257,540 98,764,399 Page 3 Page 4 Town of Danville Treasurer's Report of Investments - Detail Town Funds August 31, 2021 Yield to Annual Description Purchase Date Maturity Date Par Value Cost Market Value Maturity Interest Federal Agency Issues FFCB Note 12/11/2018 11/15/2021 1,600,000 1,607,984 1,609,725 2.87% 45,920 FHLB Note 12/15/2017 12/10/2021 1,000,000 989,100 1,004,964 2.16% 21,600 FNMA Note 09/27/2017 01/05/2022 1,400,000 1,405,418 1,409,341 1.90% 26,600 FHLB Note 06/12/2018 06/10/2022 475,000 473,418 484,755 2.84% 13,490 FHLB Note 07/17/2018 06/10/2022 1,000,000 996,850 1,020,721 2.84% 28,400 FNMA Note 09/06/2019 09/06/2022 825,000 822,129 837,268 1.55% 12,788 FNMA Note 09/26/2019 09/06/2022 700,000 695,149 707,950 1.55% 10,850 FHLB Note 11/05/2018 09/09/2022 1,000,000 1,000,830 1,030,744 3.10% 31,000 FFCB Note 10/15/2019 10/11/2022 1,500,000 1,488,585 1,521,684 1.64% 24,600 FHLB Note 08/27/2018 12/09/2022 1,250,000 1,235,000 1,287,962 2.80% 35,000 FHLB Note 12/20/2018 12/09/2022 1,700,000 1,714,756 1,761,234 2.77% 47,090 FNMA Note 03/18/2019 01/19/2023 1,500,000 1,495,455 1,546,200 2.46% 36,900 FHLB Note 03/28/2019 03/10/2023 900,000 917,136 935,597 2.24% 20,160 FHLMC Note 05/05/2020 05/05/2023 1,330,000 1,329,441 1,334,100 0.39% 5,187 FNMA Note 05/20/2020 05/22/2023 1,425,000 1,420,711 1,427,016 0.35% 4,988 FFCB Note 06/02/2020 06/08/2023 1,500,000 1,498,875 1,502,572 033% 4,950 FHLB Note 06/10/2019 06/09/2023 1,500,000 1,507,305 1,551,620 2.00% 30,000 FHLMC Note 06/24/2020 06/26/2023 1,305,000 1,301,190 1,305,853 0.35% 4,568 FNMA Note 07/08/2020 07/10/2023 560,000 558,796 559,751 0.28% 1,568 FNMA Note 08/12/2020 07/10/2023 900,000 900,054 901,591 0.28% 2,520 FFCB Note 08/12/2020 08/14/2023 1,500,000 1,496,880 1,498,737 0.27% 4,050 FHLMC Note 09/28/2020 08/24/2023 1,500,000 1,501,095 1,500,464 0.22% 3,300 FHLMC Note 09/04/2020 09/08/2023 890,000 889,706 891,085 0.26% 2,314 FHLMC Note 09/10/2020 09/08/2023 600,000 599,724 600,654 026% 1,560 FHLMC Note 11/03/2020 11/06/2023 1,455,000 1,453,691 1,454,983 0.28% 4,074 FNMA Note 11/24/2020 11/27/2023 1,500,000 1,499,160 1,500,891 0.27% 4,050 FHLMC Note 12/09/2020 12/04/2023 1,500,000 1,499,610 1,499,526 0.26% 3,900 FNMA Note 03/24/2020 02/05/2024 1,700,000 1,808,052 1,791,428 082% 13,940 FHLB Note 03/03/2020 03/08/2024 1,500,000 1,560,525 1,558,596 0.85% 12,750 Subtotal $ 35,515,000 $ 35,666,625 $ 36,037,012 1.5%. $ 458,116 Page 4 Town of Danville Treasurer's Report of Investments - Detail Town Funds August 31, 2021 Page 5 Yield to Annual Description Purchase Date Maturity Date Par Value Cost Market Value Maturity Interest U.S. Treasury Obligations U.S. Treasury Notes 01/10/2018 09/30/2021 1,250,000 1,202,393 1,251,067 2.20% 27,500 U.S. Treasury Notes 08/29/2018 10/31/2021 1,500,000 1,465,781 1,504,775 2.76% 41,400 U.S. Treasury Notes 02/08/2018 02/28/2022 1,300,000 1,269,227 1,311,679 2.49% 32,370 U.S. Treasury Notes 10/24/2017 03/31/2022 1,250,000 1,244,580 1,262,989 1.98% 24,750 U.S. Treasury Notes 10/04/2018 08/31/2022 900,000 862,488 915,890 3.01% 27,090 U.S. Treasury Notes 04/29/2019 11/30/2022 950,000 940,760 972,266 2.28% 21,660 U.S. Treasury Notes 06/19/2019 04/30/2023 1,500,000 1,486,582 1,536,445 1.87% 28,050 U.S. Treasury Notes 04/11/2019 05/31/2023 1,500,000 1,460,156 1,538,145 2.30% 34,500 U.S. Treasury Notes 09/13/2019 10/31/2023 1,500,000 1,490,918 1,544,708 1.78% 26,700 U.S. Treasury Notes 01/02/2021 12/15/2023 750,000 747,861 747,481 0.22% 1,650 U.S. Treasury Notes 04/14/2021 04/15/2024 1,000,000 1,000,352 1,000,977 0.36% 3,600 U.S. Treasury Notes 05/12/2021 05/15/2024 1,250,000 1,246,094 1,246,631 0.36% 4,500 U.S. Treasury Notes 06/10/2021 06/15/2024 1,500,000 1,496,543 1,495,430 0.33% 4,950 U.S. Treasury Notes 02/09/2021 08/31/2024 1,000,000 1,034,805 1,025,312 0.26% 2,600 U.S. Treasury Notes 02/24/2021 01/31/2025 1,500,000 1,557,012 1,544,532 0.40% 6,000 U.S. Treasury Notes 03/12/2021 03/31/2025 850,000 846,115 849,037 0.61% 5,185 U.S. Treasury Notes 01/26/2021 04/30/2025 1,000,000 1,001,953 993,438 0.33% 3,300 U.S. Treasury Notes 06/11/2021 05/31/2025 1,500,000 1,483,360 1,482,070 0.53% 7,950 U.S. Treasury Notes 07/28/2021 07/15/2024 1,500,000 1,499,648 1,499,766 0.38% 5,700 U.S. Treasury Notes 07/29/2021 06/30/2025 1,500,000 1,482,246 1,480,958 0.56% 8,400 U.S. Treasury Notes 08/06/2021 10/31/2024 1,350,000 1,395,246 1,395,457 0.45% 6,075 Subtotal $ 26,350,000 $ 26,214,120 $ 26,599.053 1.22% $ 323,930 Cash Equivalents Wells Fargo Trsry Plus M Mkt - reserve fund (2001 COP) 462,012 462,012 462,012 0.01% 46 Wells Fargo Trsry Plus M Mkt - reserve fund (2005 COP) 347,521 347,521 347,521 0.01% 35 Bank of New York 653,407 653,407 653,407 0.00% 0 US Bank 941,836 941,836 941,836 0.00% 16 LAIF 14,405,814 14,405,814 14,405,814 0.22% 31,837 Subtotal $ 16,810,591 $ 16,810,591 $ 16,810,591 0.18% 31,934 Asset -Backed Securities Honda Auto Receivables Owner 2018-3 A3 08/21/2018 08/22/2022 53,332 53,325 53,501 2.98% 1,589 Honda Auto Receivables Owner Trust 2019-3 A3 08/20/2019 08/15/2023 418,992 418,989 422,398 1.79% 7,500 John Deere Owner Trust 2019-B A3 07/16/2019 12/15/2023 167,937 167,901 169,808 2.23% 3,745 Nissan Auto Receivables Owner 2019-C A3 10/16/2019 07/15/2024 512,646 512,619 517,728 1.94% 9,945 John Deere Owner Trust 2020-A A3 03/04/2020 08/15/2024 370,000 369,977 372,834 1.11% 4,107 Mercedes-Benz Auto Lease Trust 2021-B A3 06/22/2021 11/15/2024 360,000 359,973 360,506 0.40% 1,440 John Deere Owner Trust 2021-A A3 03/02/2021 09/15/2025 255,000 254,951 255,095 0.37% 944 Toyota Auto Receivables Trust 2021-B A3 06/08/2021 11/17/2025 1,025,000 1,024,890 1,023,266 0.26% 2,665 John Deere Owner Trust 2021-B A3 07/13/2021 03/16/2026 310,000 309.972 310.455 0.52% 1,612 Subtotal $ 3,472,907 S 3,472,597 $ 3,485,591 0.96% $ 33.547 Page 5 Description Supranational Inter -American Dev Bank Note Intl. Bank Recon & Development Note International Finance Corp Note Subtotal US Corporate Berkshire Hathaway Note Paccar Financial Corp Note Chevron Corp Callable Note Cont Toyota Motor Credit Corp Note US Bank NA Callable Note Cont Bank of NY Mellon Corp Callable Note Cont Apple Inc Note Wal-Mart Stores Callable Note Cont American Honda Finance Note John Deere Capital Corp Note Amazon.comInc Callable Note Cont CaterpillarFinancial Service Note John Deere Capital Corp Note JP Morgan Chase & Co Callable Note Paccar Financial Corp Note Subtotal TOTAL Source: Chandler Asset Management US Bank Local Agency Investment Fund (LAIF) Page 6 Town of Danville Treasurer's Report of Investments - Detail Town Funds August 31, 2021 Yield to Annual Purchase Date Maturity Date Par Value Cost Market Value Maturity Interest 09/13/2018 04/14/2022 1,100,000 1,054,218 1,111,232 2.99% 32,890 11/17/2020 11/24/2023 355,000 354,237 354,705 032% 1,136 07/29/2021 10/16/2024 1,000,000 1,028,980 1,026,876 0.46% 4,600 $ 2,455,000 $ 2,437,435 $ 2,492,813 1.57% $ 38,626 0 03/16/2018 05/15/2022 1,000,000 1,000,670 1,019,922 2.98% 29,800 09/23/2019 09/26/2022 500,000 499,390 509,665 2.04% 10,200 06/19/2019 12/05/2022 255,000 255,607 260,523 228% 5,814 01/25/2019 01/11/2023 1,000,000 980,920 1,032,822 3.22% 32,200 04/29/2019 01/23/2023 750,000 752,190 775,895 2.77% 20,775 07/25/2019 01/29/2023 750,000 764,625 776,564 2.37% 17,775 05/29/2019 05/03/2023 750,000 746,205 776,728 2.54% 19,050 03/27/2019 06/26/2023 800,000 827,616 844,049 2.54% 20,320 08/19/2019 01/12/2024 950,000 1,008,634 1,015,417 2.07% 19,665 03/01/2021 01/17/2024 615,000 614,563 615,328 0.47% 2,891 05/10/2021 05/12/2024 570,000 569,168 570,209 0.50% 2,850 05/10/2021 05/17/2024 905,000 903,787 905,576 050% 4,525 06/07/2021 06/07/2024 540,000 539,325 540,204 0.49% 2,646 05/24/2021 06/01/2025 750,000 750,972 751,003 0.74% 5,550 08/03/2021 08/09/2024 385,000 384,792 384,432 052% 2,002 $ 10,520,000 $ 10,598,464 $ 10,778,337 1.86% $ 196,063 $ 95,123,498 $ 95,199,832 $ 96,203,397 1.14% $ 1,082,215 Page 6 Description Cash Equivalents LAIF TOTAL Town of Danville Treasurer's Report of Investments - Detail Trust Fund August 31, 2021 Purchase Date Maturity Date Source: Local Agency Investment Fund (LAIF) Yield to Annual Par Value Cost Market Value Maturity Interest $ 1,136,341 $ 1,136,341 $ 1,136,341 0.22% 2.511 $ 1,136,341 $ 1,136,341 $ 1,136,341 0.22% $2,511 Page 7 Town of Danville Treasurer's Report of Investments - Detail Community Development Agency/Successor Agency August 31, 2021 Description Purchase Date 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 TOTAL Source: BNY Trust Company Local Agency Investment Fund (LAIF) Yield to Annual Maturity Date Par Value Cost Market Value Maturity Interest $ 331,866 $ 331,866 $ 331,866 0.22% 733 $ 362,014 362,014 362,014 0.01% 36 $ 3 3 3 0.01% 0 $ 476,802 476,802 476,802 0.01% 48 $ 1,170,686 $ 1,170,686 $ 1,170,686 0.07% $ 817 $ 1,170,686 $ 1,170,686 $ 1,170,686 0.07% $ 817 Page 8 Town of Danville Treasurer's Report of Investments - Detail Northeast Roadway Improvement Assessment District (NERIAD) August 31, 2021 Description Purchase Date Maturitv Date Par Value U.S. Treasury Obligations U.S. Treasury Note U.S. Treasury Note U.S. Treasury Note U.S. Treasury Bill Subtotal Cash Equivalents LAIF - improvement fund Bank of New York -Improvement fd Subtotal Total Source: Chandler Asset Management BNY Trust Company Local Agency Investment Fund (LAIF) Yield to Annual Cost Market Value Maturity Interest 11/30/2020 11/4/2021 S 250,000 $ 249,759 5 249,758 0.10% 250 12/18/2020 11/30/2021 5 125,000 S 127,075 5 125,562 0.11% 138 3/30/2021 3/31/2022 S 250,000 5 250,742 5 250,430 0.08% 200 7/19/2021 7/14/2022 5 235,000 S 234,836 $ 234,836 0.07% 165 $ 860,000 $ 862,412 $ 860,586 0.09% $ 752 $ 391,128 $ 391,128 $ 391,128 0.22% 864 $ 4,000 4,000 4,000 0.00% 0 $ 395,128 $ 395,128 $ 395,128 0.22% $ 864 $ 1.255.128 $ 1.257.540 $ 1.255.714 0.13% $ 1,616 Page 9