Purchase Market Totals
Investment Summary: $ % Price (G/L) Per Trustee % Yield LAIF Accounts 143,000,000 $ 58.89% 143,000,000 $ 143,000,000 $ 4.23% Securities:
U. S. T-Notes & Bills 65,000,000 26.76% 65,013,190 64,052,825 Agencies 25,133,000 10.35% 25,199,079 24,592,339 Certificates of Deposits 735,000 0.30% 732,918 722,026 Commerical Paper 1,000,000 0.41% 977,255 997,166 Corporate Notes 8,000,000 3.29% 7,787,570 7,685,160
Subtotal Securities 99, 868,000 41.11% 99,710,012 98,049,516 3.19% Subtotal LAIF Accounts & Securities 242,868,000$ 100.00% 242,710,012 241,049,516 3.80% Accrued Interest 2,039,730
Total Market Value 243,089,247
Total Bond Account Balances 3,575,023 3,575,023
Total Investments 246,285,035 $ 246,664,270 $
This investment report is in compliance with the following:
(
1) A
ll securities have a maturity of 5 years or less.
(
2) T
otal Agency investments do not exceed 75% of the portfolio. (
3) T
otal Investments for each Agency Issuer do not exceed 20% of the portfolio. (
4) N
o agency transactions were locked in during March 2024 for settlement in April 2024.
Greg Ramirez, City Manager / Treasurer Date Mark Uribe / Director of Finance Date City of Camarillo
Investment Report
Security Maturities / Totals at Par
March 31, 2024
Compliance Report and Attestations
At Par
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
1 year or less
79.73%
+1-2 years
9.87% - $23.98m
+2-3 years
3.82% - $9.25m
+3-4 years
3.29% - $8.00m
+4-5 years
3.29% - $8.00m
Other
20.27%
INVESTMENT MATURITY SCHEDULE
Investments have a maturity of five years or less
$193,645,000
$49,223,000
Notes & Bills
26.76% - $65,000,000
LAIF - 58.89%
$143,000,000
Fed. Home Loan Bank
2.47% - $6.00m
Fed. Home Loan MC
1.65% - $4.00m
Fed. Farm Credit
4.58% - $11.13m
Fannie Mae
1.65% - $4.00m
Corporate Note
3.29% - $8.00m
Commerical Paper
0.41% - $1.00m
Certificate of Deposit
0.30% - $735k
Investment by Type
04 / 11 / 2024
04 / 10 / 2024
Market Value Per LAIF
Purchase Balance Balance
Investment Balance Price 2/29/2024 Deposits Withdrawals 3/31/2024 Month Y-T-D Yield
Total LAIF 143,000,000 143,000,000 151,400,000 11,700,000 (20,100,000) 143,000,000 - 3,942,965 1,523,547 4.23%
Maturity or Market Value Per Trustee
Interest Purchase Call Purchase Balance Purchases Market Incr. Balance Investment Rate Date Date Par Value Price 2/29/2024 (Maturities) or (Decr) 3/31/2024 Month Y-T-D Yield
U.S. Securities
Treasury Note 0.000% 9/27/23 3/7/24 9,991,200 (10,000,000) 8,800 - - - - 5.51%
Treasury Note 2.125% 4/13/21 4/1/24 2,000,000 2,103,672 1,994,580 - 5,420 2,000,000 - 21,250 - 0.37%
Commercial Paper - MUFG 0.000% 11/22/23 4/17/24 1,000,000 977,256 990,882 - 6,284 997,166 - - - 5.70%
Fed Farm Credit Bank 2.440% 5/4/22 4/18/24 900,000 894,582 896,355 - 2,448 898,803 - 10,980 9,943 2.76% Treasury Note 2.250% 3/10/21 4/30/24 2,000,000 2,116,641 1,989,840 - 5,160 1,995,000 - 22,500 18,915 0.38% Treasury Note 0.000% 11/21/23 5/2/24 10,000,000 9,765,008 9,909,200 - 45,300 9,954,500 - - - 5.40%
Treasury Note 2.000% 3/30/21 5/31/24 2,000,000 2,104,219 1,983,520 - 5,680 1,989,200 - 20,000 13,443 0.35% Treasury Note 0.000% 3/22/24 6/6/24 10,000,000 9,889,393 - 9,889,393 15,007 9,904,400 - - - 5.39%
Treasury Note 1.750% 3/30/21 6/30/24 2,000,000 2,089,219 1,976,320 - 5,820 1,982,140 - 17,500 8,846 0.37% Fannie Mae 1.750% 12/10/20 7/2/24 2,000,000 2,103,840 1,975,720 - 6,040 1,981,760 - 35,000 8,653 0.28% Treasury Note 1.750% 4/13/21 7/31/24 2,000,000 2,085,313 1,970,860 - 5,620 1,976,480 - 35,000 5,865 0.45% Fed Farm Credit Bank 3.300% 8/16/22 8/15/24 1,000,000 1,000,880 990,410 - 2,370 992,780 - 33,000 4,217 3.25% Treasury Note 1.250% 2/26/21 8/31/24 2,000,000 2,060,859 1,960,540 - 6,360 1,966,900 - 25,000 2,174 0.38% Home Loan Bank 2.875% 11/19/20 9/13/24 2,000,000 2,191,020 1,974,640 - 3,920 1,978,560 28,750 57,500 2,875 0.35% Treasury Note 1.500% 1/20/21 10/31/24 2,000,000 2,089,609 1,951,800 - 5,380 1,957,180 - 15,000 12,610 0.31% Certificate of Deposit 0.400% 11/18/20 11/20/24 245,000 244,633 235,466 - 1,760 237,226 - 494 357
0.44%
Treasury Note 1.500% 2/26/21 11/30/24 2,000,000 2,080,234 1,946,020 - 5,600 1,951,620 - 15,000 10,082 0.42% Treasury Note 1.750% 1/20/21 12/31/24 2,000,000 2,111,328 1,945,540 - 4,620 1,950,160 - 17,500 8,846 0.33% Fannie Mae 1.625% 12/29/20 1/7/25 2,000,000 2,104,780 1,941,980 - 5,220 1,947,200 - 32,500 7,583 0.31% Home Loan MC 1.500% 12/29/20 2/12/25 1,293,000 1,354,353 1,257,516 - 2,743 1,260,259 - 19,500 2,654 0.34% Home Loan MC 1.500% 12/29/20 2/12/25 707,000 740,278 677,124 - 1,477 678,601 - 10,500 1,429 0.35% Treasury Note 0.500% 2/12/21 3/31/25 1,500,000 1,510,371 1,429,395 - 5,265 1,434,660 - 3,750 20
0.33%
Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,610 976,690 - (40)
976,650 - 15,000 14,000 3.16% Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,970 976,690 - (40)
976,650 - 15,000 14,000 3.14% Treasury Note 0.375% 2/12/21 4/30/25 1,500,000 1,501,934 1,423,005 - 4,860 1,427,865 - 2,813 2,364 0.34% Treasury Note 0.250% 9/30/21 5/31/25 2,000,000 1,964,219 1,887,660 - 6,720 1,894,380 - 2,500 1,680 0.75% Treasury Note 2.875% 9/28/23 6/15/25 2,000,000 1,924,297 1,949,380 - 2,420 1,951,800 - 28,750 16,967 5.21% Treasury Note 3.000% 12/21/22 7/15/25 2,000,000 1,945,547 1,950,780 - 2,580 1,953,360 - 60,000 12,692 4.13% Treasury Note 3.125% 12/21/22 8/15/25 2,000,000 1,951,172 1,952,420 - 2,260 1,954,680 - 62,500 7,898 4.11% Corporate Note - Walmart 3.900% 9/29/22 9/9/25 1,000,000 982,170 984,530 - 1,300 985,830 19,500 39,000 2,383 4.55% Certificate of Deposit 4.300% 9/29/22 9/29/25 245,000 244,265 243,591 - (904)
242,687 5,253 10,564 117
4.41%
Treasury Note 4.250% 9/28/23 10/15/25 2,000,000 1,967,813 1,983,360 - 460 1,983,820 - 42,500 39,249 5.09% Corporate Note - Microsoft 3.125% 3/17/22 11/3/25 1,000,000 1,024,730 971,780 - 2,350 974,130 - 15,625 12,847 2.36% Home Loan Bank 4.500% 2/7/23 12/12/25 2,000,000 2,035,620 1,991,640 - (1,300)
1,990,340 - 45,000 27,250 3.83% Fed Farm Credit Bank 4.000% 2/7/23 1/13/26 1,233,000 1,239,325 1,218,044 - (727)
1,217,316 - 49,320 10,686 3.81% Fed Farm Credit Bank 4.375% 2/28/23 2/23/26 2,000,000 1,987,560 1,990,600 - (1,820)
1,988,780 - 87,500 9,236 4.60% City of Camarillo
LAIF Interest
Report on the Local Agency Investment Fund & U.S. Government Securities March 31, 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 2/29/2024 (Maturities) or (Decr) 3/31/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,855,160 - 7,040 1,862,200 9,600 19,200 1,387 3.14% Corporate Note - Berkshire Hathaway 3.125% 3/17/22 3/15/26 1,000,000 1,018,170 965,900 - 2,390 968,290 15,625 31,250 1,389 2.61% Corporate Note - Proctor & Gamble 1.000% 12/21/22 4/23/26 1,000,000 898,650 925,440 - 2,920 928,360 - 5,000 4,389 4.29% Fed Farm Credit Bank 4.375% 6/29/23 6/23/26 2,000,000 1,998,760 1,993,060 - (3,580)
1,989,480 - 43,750 23,819 4.40% Treasury Note 4.500% 11/22/23 7/15/26 2,000,000 1,990,078 1,997,960 - (380)
1,997,580 - 45,000 19,038 4.70% Fed Farm Credit Bank 4.750% 9/28/23 9/1/26 2,000,000 1,988,240 2,008,760 - (1,880)
2,006,880 47,500 47,500 7,917 4.97% Certificate of Deposit 4.250% 9/30/22 9/30/26 245,000 244,020 244,981 - (2,868)
242,113 - 5,249 57
4.36%
Home Loan MC 0.800% 9/29/22 10/27/26 2,000,000 1,732,400 1,812,300 - 7,440 1,819,740 - 8,000 6,844 4.42% Corporate Bond - VISA Inc. 1.900% 2/7/22 4/15/27 1,000,000 926,600 921,030 - 4,240 925,270 - 9,500 8,761 3.81% Treasury Note 2.375% 6/29/23 5/15/27 2,000,000 1,869,531 1,879,300 - 3,520 1,882,820 - 23,750 18,008 4.22% Fed Farm Credit Bank
4.125% 2/28/23 8/23/27 2,000,000 1,983,540 1,979,640 - - 1,979,640 - 82,500 8,708 4.33% Corporate Note - Apple Inc. 3.000% 6/29/23 11/13/27 1,000,000 945,670 945,670 - 4,310 949,980 - 15,000 11,500 4.38% Treasury Note 3.500% 11/22/23 1/31/28 2,000,000 1,922,188 1,938,900 - 3,520 1,942,420 - 35,000 11,731 4.53% Treasury Note 4.875% 3/22/24 10/31/28 2,000,000 2,043,594 - 2,081,897 (30,577)
2,051,320 - - 40,982 4.35%
Treasury Note 4.375% 3/22/24 11/30/28 2,000,000 2,003,906 - 2,030,921 (19,281)
2,011,640 - - 29,406 4.33%
Treasury Note 3.750% 3/22/24 12/31/28 2,000,000 1,950,469 - 1,967,364 (8,924)
1,958,440 - - 18,956 4.33%
Treasury Note 4.000% 3/22/24 1/31/29 2,000,000 1,972,578 - 1,983,787 (3,327)
1,980,460 - - 13,407 4.32%
-
-
-
- -
-
- 35,250 - -
Total U.S. Securities
99,868,000 99,710,012 89,957,179 7,953,362 138,975 98,049,516 126,228 1,273,995 516,183 3.19% Grand Total - LAIF & U.S. Securities 242,868,000 242,710,012 241,357,179 19,653,362 (19,961,025) 241,049,516 126,228 5,216,960 2,039,730 3.80% At 3/31/2024, the City's average earnings rate on all investments listed above was 3.80%, LAIF earnings rate was 4.23%, while 3.19% 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,049,516$ Treasury Note 10,000,000 9,761,883 238,117 238,117 Total Accrued Interest 2,039,730 243,089,246$
FY 2023/24 Interest Prior to 3/2024 for Matured/Called Securities Fiscal Year Received
(2) Total Interest Earned
-
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 @ March 31, 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
09/01/24 9/01/24 09/01/24 09/01/24 06/01/24 06/01/24 -
2nd Installment Amount
41,558
263,588
144,772
539,800
75,738
232,997
-
2nd Installment Due
03/01/25 3/01/25 03/01/25 03/01/25 12/01/24 12/01/24 -
Type of Investment Total
U.S. Bank 3,549,386 274,186
1,012,551
444,480
1,302,141
508,012
532
7,484
Bank of New York Mellon Tax-Exempt MMKT* 25,637 - -
25,637
-
-
-
-
Total Investments per Bank & General Ledger
3,575,023 274,186
1,012,551
470,117
1,302,141
508,012
532
7,484
*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
March 31, 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
LAIF LAIF LAIF LAIF Bank of NY Mellon Investment
Description City Camsan CCI Corp. Subtotal Securities (at Par) Total February 29 Beginning Balance 50,700,000 $ 50,100,000 $ 50,600,000 $ 151,400,000 $ 91,868,000 $ 243,268,000 $ March 5 LAIF Wire -
700,000
- 700,000
- 700,000
March 7
Matured Security -
- - - (10,000,000) (10,000,000)
March 8 LAIF Wire 9,700,000 - - 9,700,000 - 9,700,000 March 18 LAIF Wire (1,100,000) - - (1,100,000) - (1,100,000) March 21 LAIF Wire (18,000,000) (1,000,000) - (19,000,000) - (19,000,000) March 22 Five Securities Purchase -
- - - 18,000,000 18,000,000
March 25 LAIF Wire 300,000 - - 300,000 - 300,000 March 26
LAIF Wire 400,000 - - 400,000 - 400,000 March 27
LAIF Wire 600,000 - - 600,000 - 600,000 (8,100,000)
(300,000) - (8,400,000) 8,000,000
(400,000)
March 31 Ending Balance 42,600,000$ 49,800,000$ 50,600,000$ 143,000,000$ 99,868,000$ 242,868,000$ Subtotal of Incr. / <Decr.> in A/C Balances
City of Camarillo
Chronological Investment Activity Report - At Par
For the Month Ended March 31, 2024
(Bond Proceeds Accounts Excluded)
Date