Purchase Market Totals
Investment Summary: $ % Price (G/L) Per Trustee % Yield LAIF Accounts 139,800,000$ 60.20% 139,800,000$ 139,800,000$ 3.67% Securities:
U. S. T-Notes & Bills 49,000,000 21.11% 49,213,250 47,492,350 Agencies 33,633,000 14.49% 33,684,404 32,636,783
Certificates of Deposits 735,000 0.32% 732,918 707,716 Commerical Paper 1,000,000 0.43% 977,800 997,028
Corporate Notes 8,000,000 3.45% 7,787,570 7,540,210
Subtotal Securities 92,368,000 39.80% 92,395,942 89,374,087 1.94% Subtotal LAIF Accounts & Securities 232,168,000$ 100.00% 232,195,942 229 ,174,087 3.17% Accrued Interest 894,551
Total Market Value 230,068,638
Total Bond Account Balances 15,024,280 15,024,280
Total Investments 247,220,222$ 245,092,918$
This investment report is in compliance with the following:
(1) All securities have a maturity of 5 years or le ss. (2) Total Agency investments do not exceed 75% of the portfolio. (3) Total Investments for each Agency Issuer do not exceed 20% of the portfolio. (4) No agency transactions were locked in during October 2023 for settlement in November 2023.
Greg Ramirez, City Manager / Treasurer Date Mark Uribe / Director of Finance Date of Camarillo
, we attest that sufficient investment liquidity and anticipated revenue are available to meet the next six (6) months' estimated expenditures.
All City investments are shown above and conform to the City Investment Policy. All investment transactions during this period are included in this report. As Treasurer and Director of Finance of the City
ATTESTATIONS
Investment Policy Check List
City of Camarillo
Investment Report
Security Maturities / Totals at Par
October 31, 2023
Compliance Report and Attestations
At Par
1 year or less
79.77%
+1-2 years
10.55% - $24.49m
+2-3 years
7.10% - $16.48m
+3-4 years
2.58% - $6.00m
+4-
5 years
0.00% - $0.00
Other
20.23%
INVESTMENT MATURITY SCHEDULE
Investments have a maturity of five years or less
$185,200,000
$46,968,000
Notes & Bills
21.11% - $49,000,000
LAIF - 60.20%
$139,800,000
Fed. Home Loan Bank
2.58% - $6.00m
Fed. Home Loan MC
3.02% - $7.00m
Fed. Farm Credit
7.17% - $16.63m
Fannie Mae
1.72% - $4.00m
Corporate Note
3.45% - $8.00m
Commerical Paper
0.43% - $1.00m
Certificate of Deposit
0.32% - $735k
Investment by Type
11 / 09 / 2023
11 / 09 / 2023
Market Value Per LAIF
Purchase Balance Balance
Investment Balance Price 9/30/2023 Deposits Withdrawals 10/31/2023 Month Y-T-D Yield Total LAIF 139,800,000 139,800,000 138,900,000 4,828,973 (3,928,973) 139,800,000 1,328,973 2,573,890 437,462 3.67% Maturity or Market Value Per Trustee
Interest Purchase Call Purchase Balance Purchases Market Incr. Balance Investment Rate Date Date Par Value Price 9/30/2023 (Maturities) or (Decr) 10/31/2023 Month Y-T-D Yield U.S. Securities
Treasury Note 0.125% 6/7/21 10/15/23 1,996,260 (2,000,000) 3,740 - 1,250 1,250 - 0.20% Home Loan MC 0.250% 11/18/20 11/6/23 1,000,000 998,920 995,150 - 4,110 999,260 - - 1,215 0.29% Treasury Note 0.250% 8/12/21 11/15/23 2,000,000 1,997,969 1,987,620 - 8,500 1,996,120 - - 2,310 0.30% Commercial Paper - MUFG 0.000% 6/29/23 11/20/23 1,000,000 977,800 992,165 - 4,862 997,028 - - 19,271 5.68% Home Loan MC 0.250% 12/10/20 12/4/23 2,000,000 1,999,500 1,982,320 - 7,680 1,990,000 - - 2,042 0.26% Fed Farm Credit Bank 0.680% 1/19/22 12/20/23 2,000,000 1,990,880 1,978,660 - 8,160 1,986,820 - - 4,949 0.92% Treasury Note 0.125% 8/12/21 1/15/24 2,000,000 1,989,688 1,970,000 - 8,760 1,978,760 - 1,250 740 0.34% Fe
d Farm Credit Bank 0.230% 2/12/21 1/19/24 1,500,000 1,501,065 1,476,345 - 6,570 1,482,915 - 1,725 978 2.00% Treasury Note 0.125% 9/30/21 2/15/24 2,000,000 1,987,734 1,961,260 - 8,500 1,969,760 - 1,250 530 0.39% Fed Farm Credit Bank 0.250% 3/10/21 2/26/24 2,000,000 1,994,960 1,958,940 - 6,680 1,965,620 - 2,500 903 0.34% Treasury Note 0.000% 9/27/23 3/7/24 10,000,000 9,761,883 9,768,300 - 44,300 9,812,600 - - 51,445 5.51% Treasury Note 2.125% 4/13/21 3/31/24 2,000,000 2,103,672 1,967,260 - 5,480 1,972,740 21,250 21,250 3,716 0.37% Fed Farm Credit Bank 2.440% 5/4/22 4/18/24 900,000 894,582 882,990 - 4,176 887,166 10,980 10,980 793 2.76% Treasury Note 2.250% 3/10/21 4/30/24 2,000,000 2,116,641 1,963,200 - 4,760 1,967,960 22,500 22,500 124 0.38% Treasury Note 2.000% 3/30/21 5/31/24 2,000,000 2,104,219 1,954,460 - 5,700 1,960,160 - - 16,831 0.35% Treasury Note 1.750% 3/30/21 6/30/24 2,000,000 2,089,219 1,945,620 - 5,560 1,951,180 - - 11,793 0.37% Fannie Mae 1.750% 12/10/20 7/2/24 2,000,000 2,103,840 1,944,800 - 6,480 1,951,280 - 17,500 11,569 0.28% Treasury Note 1.750% 4/13/21 7/31/24 2,000,000 2,085,313 1,939,620 - 5,620 1,945,240 - 17,500 8,845 0.45% Fed Farm Credit Bank 3.300% 8/16/22 8/15/24 1,000,000 1,000,880 981,960 - (2,090) 979,870 - 16,500 6,967 3.25% Treasury Note 1.250% 2/26/21 8/31/24 2,000,000 2,060,859 1,925,160 - 6,320 1,931,480 - 12,500 4,258 0.38% Home Loan Bank 2.875% 11/19/20 9/13/24 2,000,000 2,191,020 1,951,300 - 5,100 1,956,400 - 28,750 7,667 0.35% Treasury Note 1.500% 1/20/21 10/31/24 2,000,000 2,089,609 1,918,120 - 5,640 1,923,760 15,000 15,000 82 0.31% City of Camarillo
LAIF Interest
Report on the Local Agency Investment Fund & U.S. Government Securities October 31, 2023
Investment Report
Continued on next page
Fiscal Year Received Accrued
Interest
U.S. Securities Interest
Fiscal Year Received Accrued
Interest
See Table 1:
Maturity or Market Value Per Trustee
Interest Purchase Call Purchase Balance Purchases Market Incr. Balance Investment Rate Date Date Par Value Price 9/30/2023 (Maturities) or (Decr) 10/31/2023 Month Y-T-D Yield Continued - U.S. Securities
Certificate of Deposit 0.400% 11/18/20 11/20/24 245,000 244,633 230,835 - 681 231,516 - - 443 0.44% Treasury Note 1.500% 2/26/21 11/30/24 2,000,000 2,080,234 1,913,520 - 4,380
1,917,900 - -
12,623 0.42%
Treasury Note 1.750% 1/20/21 12/31/24 2,000,000 2,111,328 1,913,600 - 5,160
1,918,760 - -
11,793 0.33%
Fannie Mae 1.625% 12/29/20 1/7/25 2,000,000 2,104,780 1,908,740 - 5,620
1,914,360 -
16,250 10,292 0.31%
Home Loan MC 1.500% 12/29/20 2/12/25 1,293,000 1,354,353 1,235,741 - 3,198
1,238,939 -
9,750 4,279 0.34%
Home Loan MC 1.500% 12/29/20 2/12/25 707,000 740,278 665,399 - 1,722
667,121 -
5,250 2,304 0.35%
Treasury Note 0.500% 2/12/21 3/31/25 1,500,000 1,510,371 1,398,165 - 5,040 1,403,205 3,750 3,750 656 0.33% Corpora
te Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,610 965,800 - 1,990
967,790 15,000 15,000 1,500 3.16% Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,970 965,800 - 1,990
967,790 15,000 15,000 1,500 3.14% Treasury Note 0.375% 2/12/21 4/30/25 1,500,000 1,501,934 1,390,605 - 5,340 1,395,945 2,813 2,813 15 0.34% T
reasury Note 0.250% 9/30/21 5/31/25 2,000,000 1,964,219 1,844,220 - 6,480 1,850,700 - - 2,104 0.75% Treasury Note 2.875% 9/28/23 6/15/25 2,000,000 1,924,297 1,925,540 - 2,740 1,928,280 - - 21,837 5.21% Treasury Note 3.000% 12/21/22 7/15/25 2,000,000 1,945,547 1,927,420 - 2,260 1,929,680 - 30,000 17,772 4.13% Treasury Note 3.125% 12/21/22 8/15/25 2,000,000 1,951,172 1,929,680 - 1,720 1,931,400 - 31,250 13,247 4.11% Corporate Note - Walmart 3.900% 9/29/22 9/9/25 1,000,000 982,170 974,870 - 2,050 976,920 - 19,500 5,633 4.55% Certificate of Deposit 4.300% 9/29/22 9/29/25 245,000 244,265 239,165 - 61 239,225 - 5,311 981 4.41% T
reasury Note 4.250% 9/28/23 10/15/25 2,000,000 1,967,813 1,968,980 - (540) 1,968,440 42,500 42,500 3,948 5.09% Corporate Note - Microsoft 3.125% 3/17/22 11/3/25 1,000,000 1,024,730 958,160 - 1,310
959,470 -
-
15,451 2.36%
Home Loan Bank 4.500% 2/7/23 12/12/25 2,000,000 2,035,620 1,974,720 - (2,200)
1,972,520 -
-
34,750 3.83%
Fed Farm Credit Bank 4.000% 2/7/23 1/13/26 1,233,000 1,239,325 1,206,343 - (3,230)
1,203,112 -
24,660 14,796 3.81%
Fed Farm Credit Bank 4.375% 2/28/23 2/23/26 2,000,000 1,987,560 1,972,240 - (3,120)
1,969,120 -
43,750 16,528 4.60%
Home Loan Bank 0.960% 5/4/22 3/5/26 2,000,000 1,843,900 1,807,180 - 8,700
1,815,880 -
9,600 2,987 3.14%
Corporate Note - Berkshire Hathaway 3.125% 3/17/22 3/15/26 1,000,000 1,018,170 954,190 - (540)
953,650 -
15,625 3,993 2.61%
Corporate Note - Proctor & Gamble 1.000% 12/21/22 4/23/26 1,000,000 898,650 904,620 - (700)
903,920 5,000 5,000 222 4.29%
Fed Farm Credit Bank 4.375% 6/29/23 6/23/26 2,000,000 1,998,760 1,974,020 - (6,960)
1,967,060 -
-
31,111 4.40%
Fed Farm Credit Bank 4.750% 9/28/23 9/1/26 2,000,000 1,988,240 1,990,900 - (3,500)
1,987,400 -
-
15,833 4.97%
Certificate of Deposit 4.250% 9/30/22 9/30/26 245,000 244,020 237,316 - (342)
236,975 5,249 5,249 913 4.36%
Home Loan MC 0.800% 9/29/22 10/27/26 2,000,000 1,732,400 1,757,980 - 6,720
1,764,700 8,000 8,000 178 4.42%
Corporate Bond - VISA Inc. 1.900% 2/7/22 4/15/27 1,000,000 926,600 897,100 - (6,270)
890,830 9,500 9,500 844 3.81%
Treasury Note 2.375% 6/29/23 5/15/27 2,000,000 1,869,531 1,844,540 - (6,260)
1,838,280 -
-
21,943 4.22%
Fed Farm Credit Bank 4.125% 2/28/23 8/23/27 2,000,000 1,983,540 1,950,820 - (13,580)
1,937,240 -
41,250 15,583 4.33%
Corporate Note - Apple Inc. 3.000% 6/29/23 11/13/27 1,000,000 945,670 924,490 - (4,650)
919,840 -
-
14,000 4.38%
-
-
-
-
-
-
- 7,500 - -
To
tal U.S. Securities 92,368,000 92,395,942 91,194,209 (2,000,000) 179,878 89,374,087 177,792 536,963 457,089 1.94% Grand Total - LAIF & U.S. Securities 232,168,000 232,195,942 230,094,209 2,828,973 (3,749,095) 229,174,087 1,506,765 3,110,853 894,551 3.17% At 10/31/2023, the City's average earnings rate on all investments listed above was 3.17%, LAIF earnings rate was 3.67%, while 1.94% was the average purchase price yield to maturity on securities only.
Note: U.S. Security market values are provided by Bank of New York Mellon.
Table 1: Securities Matured Total Market Value:
Security Type Par Purchase Price (1) Gain / (Loss) Net = (1) + (2) Total US Securities 229,174,087$ Treasury Note 2,000,000 1,996,406 3,594 9,844 Total Accrued Interest 894,551 $ 230,068,638
FY 2023/24 Interest Prior to 10/2023 for Matured/Called Securities Fiscal Year Received
(2) Total Interest Earned
6,250
Accrued
Interest
Securities Interest
Assessment District Lease Revenue Revenue Revenue
Description
Original Bond / Note Issue Amount 5,766,065 15,915,000 9,555,000 31,295,000 7,630,000 18,900,000 11,800,000 Date of Bond / Note Issue 06/06/17 11/12/14 12/22/16 12/22/16 04/26/12 08/11/15 08/01/19 Date of Final Maturity 09/01/32 09/01/36 09/01/41 09/01/41 12/01/33 06/01/36 08/07/23 Interest Rates 2.45% 3.50% - 5.25% 1.62% - 5.00% 2.00% - 5.00% 1.00% - 4.25% 2.00% - 5.00% 2.00% - 5.00% Principal Outstanding @ October 31, 2023 3,774,415 11,205,000 7,500,000 26,485,000 4,360,000 13,400,000 - Next Principal Payment Due
Principal Payment Amount 381,890 640,000 295,000 720,000 330,000 800,000 - Principal Payment Due Date 09/01/24 09/01/24 09/01/24 09/01/24 12/01/23 06/01/24 - Next Two Interest Payments Due
1st Installment Amount 46,237 279,588 149,381 557,800 81,100 252,997 - 1st Installment Due 03/01/24 03/01/24 03/01/24 03/01/24 12/01/23 12/01/23 - 2nd Installment Amount 46,237 279,588 149,381 557,800 75,738 252,997 - 2nd Installment Due 09/01/24 9/01/24 09/01/24 09/01/24 06/01/24 06/01/24 - Type of Investment Total
U.S. Bank 14,963,322 70,578 1,265,816 593,849 1,859,902 517,922 3,884 10,651,371 Bank of New York Mellon Tax-Exempt MMKT* 60,958 - - 60,958 - - - - Total Investments per Bank & General Ledger 15,024,280 70,578 1,265,816 654,807 1,859,902 517,922 3,884 10,651,371 *Unspent bond proceeds from the refunded 2006 Tax-Exempt Housing bond as well as investment earnings.
City of Camarillo
Investment Report of Bond Account Balances
October 31, 2023
2019 PFA Water
Bonds
Successor Agency
Mello-Roos Bonds
CFD#1 2017 Bonds
2015 Camsan
Wastewater Bonds
2012 PFA Library
Bonds
2016 SA (C.D.C.)
Refunding Bonds,
Series B
2016 SA (C.D.C.)
Refunding Bonds,
Series A & A-T
2014 SA (C.D.C.)
Refunding Bonds