Purchase Market Totals
Investment Summary: $ % Price (G/L) Per Trustee % Yield LAIF Accounts 151,400,000$ 62.24% 151,400,000$ 151,400,000$ 4.12% Securities:
U. S. T-Notes & Bills 57,000,000 23.43% 56,915,133 56,011,580 Agencies 25,133,000 10.33% 25,199,079 24,562,949
Certificates of Deposits 735,000 0.30% 732,918 724,038 Commerical Paper 1,000,000 0.41% 977,255 990,882
Corporate Notes 8,000,000 3.29% 7,787,570 7,667,730
Subtotal Securities 91,868,000 37.76% 91,611,955 89,957,179 3.10% Subtotal LAIF Accounts & Securities 243,268,000$ 100.00% 243,011,955 241,357,179 3.73% Accrued Interest 909,182
Total Market Value 242,266,360
Total Bond Account Balances 4,637,124 4,637,124
Total Investments 247,649,079$ 246,903,484$
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 February 2024 for settlement in March 2024.
Greg Ramirez, City Manager / Treasurer Date Mark Uribe / Director of Finance D ate
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
February 29, 2024
Compliance Report and Attestations
At Par
1 year or less
82.44%
+1-2 years
9.24% - $22.48m
+2-3 years
5.03% - $12.25m
+3-4 years
3.29% - $8.00m
Other
17.56%
INVESTMENT MATURITY SCHEDULE
Investments have a maturity of five years or less
$200,545,000
$42,723,000
Notes & Bills
23.43% - $57,000,000
LAIF - 62.24%
$151,400,000
Fed. Home Loan Bank
2.47% - $6.00m
Fed. Home Loan MC
1.64% - $4.00m
Fed. Farm Credit
4.58% - $11.13m
Fannie Mae
1.64% - $4.00m
Corporate Note
3.29% - $8.00m
Commerical Paper
0.41% - $1.00m
Certificate of Deposit
0.30% - $735k
Investment by Type
03 / 13 / 2024
03 / 13 / 2024
Market Value Per LAIF
Purchase Balance Balance
Investment Balance Price 1/31/2024 Deposits Withdrawals 2/29/2024 Month Y-T-D Yield
Total LAIF 151,400,000 151,400,000 146,400,000 7,500,000 (2,500,000) 151,400,000 - 3,942,965 489,481 4.12%
Maturity or Market Value Per Trustee
Interest Purchase Call Purchase Balance Purchases Market Incr. Balance Investment Rate Date Date Par Value Price 1/31/2024 (Maturities) or (Decr) 2/29/2024 Month Y-T-D Yield U.S. Securities
Treasury Note 0.125%
9/30/21 2/15/24 1,996,100 (2,000,000) 3,900 - 1,250 2,500 - 0.39%
Fed Farm Credit Bank 0.250% 3/10/21 2/26/24 1,993,080 (2,000,000) 6,920 - 2,500 5,000 - 0.34%
Treasury Note 0.000% 9/27/23 3/7/24 10,000,000 9,761,883 9,948,800 - 42,400 9,991,200 - - - 5.51%
Treasury Note 2.125% 4/13/21 3/31/24 2,000,000 2,103,672 1,989,620 - 4,960 1,994,580 - 21,250 17,766 0.37% Commercial Paper - MUFG 0.000% 11/22/23 4/17/24 1,000,000 977,256 988,502 - 2,380 990,882 - - - 5.70%
Fed Farm Credit Bank 2.440% 5/4/22 4/18/24 900,000 894,582 894,375 - 1,980 896,355 - 10,980 8,113 2.76% Treasury Note 2.250% 3/10/21 4/30/24 2,000,000 2,116,641 1,984,920 - 4,920 1,989,840 - 22,500 15,082 0.38% Treasury Note 0.000% 11/21/23 5/2/24 10,000,000 9,765,008 9,868,500 - 40,700 9,909,200 - - - 5.40%
Treasury Note 2.000% 3/30/21 5/31/24 2,000,000 2,104,219 1,978,680 - 4,840 1,983,520 - 20,000 10,055 0.35% Treasury Note 1.750% 3/30/21 6/30/24 2,000,000 2,089,219 1,972,040 - 4,280 1,976,320 - 17,500 5,865 0.37% Fannie Mae 1.750% 12/10/20 7/2/24 2,000,000 2,103,840 1,971,480 - 4,240 1,975,720 - 35,000 5,736 0.28% Treasury Note 1.750% 4/13/21 7/31/24 2,000,000 2,085,313 1,967,180 - 3,680 1,970,860 - 35,000 2,885 0.45% Fed Farm Credit Bank 3.300% 8/16/22 8/15/24 1,000,000 1,000,880 990,650 - (240)
990,410 16,500 33,000 1,467 3.25% Treasury Note 1.250% 2/26/21 8/31/24 2,000,000 2,060,859 1,956,180 - 4,360 1,960,540 12,500 25,000 68
0.38%
Home Loan Bank 2.875% 11/19/20 9/13/24 2,000,000 2,191,020 1,972,980 - 1,660 1,974,640 - 28,750 26,833 0.35% Treasury Note 1.500% 1/20/21 10/31/24 2,000,000 2,089,609 1,950,780 - 1,020 1,951,800 - 15,000 10,055 0.31% Certificate of Deposit 0.400% 11/18/20 11/20/24 245,000 244,633 235,640 - (174)
235,466 - 494 274
0.44%
Treasury Note 1.500% 2/26/21 11/30/24 2,000,000 2,080,234 1,945,620 - 400 1,946,020 - 15,000 7,541 0.42% Treasury Note 1.750% 1/20/21 12/31/24 2,000,000 2,111,328 1,946,560 - (1,020)
1,945,540 - 17,500 5,865 0.33% Fannie Mae 1.625% 12/29/20 1/7/25 2,000,000 2,104,780 1,943,040 - (1,060)
1,941,980 - 32,500 4,875 0.31% Home Loan MC 1.500% 12/29/20 2/12/25 1,293,000 1,354,353 1,259,050 - (1,534)
1,257,516 9,750 19,500 1,029 0.34% Home Loan MC 1.500% 12/29/20 2/12/25 707,000 740,278 677,950 - (826)
677,124 5,250 10,500 554
0.35%
Treasury Note 0.500% 2/12/21 3/31/25 1,500,000 1,510,371 1,431,210 - (1,815)
1,429,395 - 3,750 3,135 0.33%
Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,610 978,900 - (2,210)
976,690 - 15,000 11,500 3.16% Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,970 978,900 - (2,210)
976,690 - 15,000 11,500 3.14% Treasury Note 0.375% 2/12/21 4/30/25 1,500,000 1,501,934 1,424,715 - (1,710)
1,423,005 - 2,813 1,885 0.34%
Treasury Note 0.250% 9/30/21 5/31/25 2,000,000 1,964,219 1,891,100 - (3,440)
1,887,660 - 2,500 1,257 0.75%
Treasury Note 2.875% 9/28/23 6/15/25 2,000,000 1,924,297 1,958,040 - (8,660)
1,949,380 - 28,750 12,097 5.21% Treasury Note 3.000% 12/21/22 7/15/25 2,000,000 1,945,547 1,960,160 - (9,380)
1,950,780 - 60,000 7,582 4.13% Treasury Note 3.125% 12/21/22 8/15/25 2,000,000 1,951,172 1,962,340 - (9,920)
1,952,420 31,250 62,500 2,576 4.11% Corporate Note - Walmart 3.900% 9/29/22 9/9/25 1,000,000 982,170 991,130 - (6,600)
984,530 - 19,500 18,633 4.55% Certificate of Deposit 4.300% 9/29/22 9/29/25 245,000 244,265 242,226 - 1,365 243,591 - 5,311 4,536 4.41% Treasury Note 4.250% 9/28/23 10/15/25 2,000,000 1,967,813 1,997,340 - (13,980)
1,983,360 - 42,500 32,049 5.09% Corporate Note - Microsoft 3.125% 3/17/22 11/3/25 1,000,000 1,024,730 978,510 - (6,730)
971,780 - 15,625 10,243 2.36% Home Loan Bank 4.500% 2/7/23 12/12/25 2,000,000 2,035,620 2,007,020 - (15,380)
1,991,640 - 45,000 19,750 3.83% Fed Farm Credit Bank 4.000% 2/7/23 1/13/26 1,233,000 1,239,325 1,227,587 - (9,543)
1,218,044 - 49,320 6,576 3.81% Fed Farm Credit Bank 4.375% 2/28/23 2/23/26 2,000,000 1,987,560 2,006,880 - (16,280)
1,990,600 43,750 87,500 1,944 4.60% City of Camarillo
LAIF Interest
Report on the Local Agency Investment Fund & U.S. Government Securities February 29, 2024
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 1/31/2024 (Maturities) or (Decr) 2/29/2024 Month Y-T-D Yield Continued - U.S. Securities
Home Loan Bank 0.960%
5/4/22 3/5/26 2,000,000 1,843,900 1,865,200 - (10,040) 1,855,160 - 9,600 9,387 3.14% Corporate Note - Berkshire Hathaway 3.125% 3/17/22 3/15/26 1,000,000 1,018,170 973,630 - (7,730)
965,900 - 15,625 14,410 2.61% Corporate Note - Proctor & Gamble 1.000% 12/21/22 4/23/26 1,000,000 898,650 931,490 - (6,050)
925,440 - 5,000 3,556 4.29%
Fed Farm Credit Bank 4.375% 6/29/23 6/23/26 2,000,000 1,998,760 2,009,900 - (16,840)
1,993,060 - 43,750 16,528 4.40% Treasury Note 4.500% 11/22/23 7/15/26 2,000,000 1,990,078 2,018,280 - (20,320)
1,997,960 - 45,000 11,374 4.70% Fed Farm Credit Bank 4.750% 9/28/23 9/1/26 2,000,000 1,988,240 2,029,720 - (20,960)
2,008,760 - - 47,500 4.97%
Certificate of Deposit 4.250% 9/30/22 9/30/26 245,000 244,020 240,696 - 4,285 244,981 - 5,249 4,365 4.36% Home Loan MC 0.800% 9/29/22 10/27/26 2,000,000 1,732,400 1,819,260 - (6,960)
1,812,300 - 8,000 5,511 4.42%
Corporate Bond - VISA Inc. 1.900% 2/7/22 4/15/27 1,000,000 926,600 931,080 - (10,050)
921,030 - 9,500 7,178 3.81%
Treasury Note 2.375% 6/29/23 5/15/27 2,000,000 1,869,531 1,901,320 - (22,020)
1,879,300 - 23,750 13,963 4.22% Fed Farm Credit Bank 4.125% 2/28/23 8/23/27 2,000,000 1,983,540 2,006,420 - (26,780)
1,979,640 41,250 82,500 1,833 4.33% Corporate Note - Apple Inc. 3.000% 6/29/23 11/13/27 1,000,000 945,670 958,960 - (13,290)
945,670 - 15,000 9,000 4.38% Treasury Note 3.500% 11/22/23 1/31/28 2,000,000 1,922,188 1,967,960 - (29,060)
1,938,900 - 35,000 5,769 4.53% -
-
-
-
-
-
- 27,750 - -
Total U.S. Securities 91,868,000
91,611,955 94,121,701 (4,000,000) (164,522) 89,957,179 164,000 1,147,767 419,701 3.10% Grand Total - LAIF & U.S. Securities 243,268,000 243,011,955 240,521,701 3,500,000 (2,664,522) 241,357,179 164,000 5,090,732 909,182 3.73% At 2/29/2024, the City's average earnings rate on all investments listed above was 3.73%, LAIF earnings rate was 4.12%, while 3.10% 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 241,357,179$ Treasury Note 2,000,000 1,987,734 12,266 18,516 Total Accrued Interest 909,182 Fed Farm Credit Bank 2,000,000 1,994,960 5,040 20,040 $ 242,266,361 Accrued
Interest
Securities Interest
FY 2023/24 Interest Prior to 2/2024 for Matured/Called Securities Fiscal Year Received
(2) Total Interest Earned
6,250
15,000
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 @ February 29, 2024 3,774,415 11,205,000 7,500,000 26,485,000 4,030,000 13,400,000 - Next Principal Payment Due
Principal Payment Amount 381,890
640,000
295,000
720,000
345,000
800,000
-
Principal Payment Due Date 09/01/24
09/01/24 09/01/24 09/01/24 12/01/24 06/01/24 -
Next Two Interest Payments Due
1st Installment Amount 46,237
279,588
149,381
557,800
75,738
252,997
-
1st Installment Due 03/01/24
03/01/24 03/01/24 03/01/24 06/01/24 06/01/24 -
2nd Installment Amount 46,237
279,588
149,381
557,800
75,738
232,997
-
2nd Installment Due 09/01/24
9/01/24 09/01/24 09/01/24 12/01/24 12/01/24 -
Type of Investment Total
U.S. Bank 4,575,502
320,580 1,287,110
593,859
1,859,933
506,035
530
7,455
Bank of New York Mellon Tax-Exempt MMKT*
61,622 - - 61,622 - - - -
Total Investments per Bank & General Ledger 4,637,124 320,580 1,287,110
655,481
1,859,933 506,035
530
7,455
*Unspent bond proceeds from the refunded 2006 Tax-Exempt Housing bond as well as investm ent earnings.
City of Camarillo
Investment Report of Bond Account Balances
February 29, 2024
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