Purchase Market Totals
Investment Summary: $ % Price (G/L) Per Trustee % Yield LAIF Accounts 153,200,000 $ 63.79% 153,200,000 $ 153,200,000 $ 4.58% Securities:
U. S. T-Notes & Bills 51,000,000 21.24% 50,789,251 51,017,915 Agencies 25,233,000 10.51% 25,260,096 25,132,452 Certificates of Deposits 735,000 0.31% 732,918 733,594 Commerical Paper 2,000,000 0.82% 1,946,226 1,976,970 Corporate Notes 8,000,000 3.33% 7,787,570 7,815,280
Subtotal Securities 86, 968,000 36.21% 86,516,061 86,676,211 3.51% Subtotal LAIF Accounts & Securities 240,168,000$ 100.00% 239,716,061 239,876,211 4.19% Accrued Interest 1,674,371
Total Market Value 241,550,582
Total Bond Account Balances 7,424,428 7,424,428
Total Investments 247,140,489 $ 248,975,010 $
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 August 2024 for settlement in September 2024.
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
August 31, 2024
Compliance Report and Attestations
At Par
1 year or less
80.13%
+1-2 years
7.28% - $17.48m
+2-3 years
4.68% - $11.25m
+3-4 years
1.25% - $3.00m
+4-5 years
6.66% - $16.00m
Other
19.87%
INVESTMENT MATURITY SCHEDULE
Investments have a maturity of five years or less
$192,445,000
$47,723,000
Notes & Bills
21.24% - $51,000,000
LAIF - 63.79%
$153,200,000
Fed. Home Loan Bank
4.16% - $10.00m
Fed. Home Loan MC
1.67% - $4.00m
Fed. Farm Credit
3.85% - $9.23m
Fannie Mae
0.83% - $2.00m
Corporate Note
3.33% - $8.00m
Commercial Paper
0.82% - $2.00m
Certificate of Deposit
0.31% - $735k
Investment by Type
09 / 11 / 2024
09 / 11 / 2024
Market Value Per LAIF
Purchase Balanc e Balance
Investment Balance Price 7/31/2024 Deposits Withdrawals 8/31/2024 Month Y-T-D Yield Total LAIF 153,200,000 153,200,000 139,900,000 15,700,000 (2,400,000) 153,200,000 - 1,718,804 1,108,366 4.58% Maturity or Market Value Per Trustee
Interest Purchase Call Purchase Balanc e Purchases Market Incr. Balanc e Investment Rate Date Date Par Value Price 7/31/2024 (Maturities) or (Decr) 8/31/2024 Month Y-T-D Yield U.S. Securities
Treasury Note
0.000% 5/21/24 8/8/24 9,989,800 (10,000,000) 10,200 - - - - 5.39% Fed Farm Credit Bank 3.300% 8/16/22 8/15/24 999,170 (1,000,000) 830 - 16,500 16,500 - 3.25% Treasury Note 1.250% 2/26/21 8/31/24 2,000,000 2,060,859 1,992,840 - 7,160 2,000,000 - - - 0.38% Home Loan Bank 2.875% 11/19/20 9/13/24 2,000,000 2,191,020 1,994,080 - 4,580 1,998,660 - - 26,833 0.35% Treasury Note 0.000% 6/26/24 9/19/24 10,000,000 9,876,868 9,928,600 - 48,200 9,976,800 - - - 5.35% Treasury Note 1.500% 1/20/21 10/31/24 2,000,000 2,089,609 1,981,160 - 6,840 1,988,000 - - 10,109 0.31% Commercial Paper - MUFG 0.000% 5/21/24 11/4/24 1,000,000 975,228 985,733 - 4,788 990,522 - - - 5.48% Certificate of Deposit 0.400% 11/18/20 11/20/24 245,000 244,633 241,271 - 1,073 242,344 - - 279 0.44% Treasury Note 1.500% 2/26/21 11/30/24 2,000,000 2,080,234 1,975,220 - 8,680 1,983,900 - - 7,623 0.42% Commercial Paper - Toyota Motor Corp. 0.000% 5/21/24 12/4/24 1,000,000 970,997 981,611 - 4,837 986,448 - - - 5.46% Treasury Note 1.750% 1/20/21 12/31/24 2,000,000 2,111,328 1,971,840 - 7,180 1,979,020 - 17,500 5,992 0.33% Fannie Mae 1.625% 12/29/20 1/7/25 2,000,000 2,104,780 1,969,620 - 7,060 1,976,680 - 16,250 4,875 0.31% Home Loan MC 1.500% 12/29/20 2/12/25 1,293,000 1,354,353 1,275,716 - 5,083 1,280,799 9,750 9,750 1,029 0.34% Home Loan MC 1.500% 12/29/20 2/12/25 707,000 740,278 686,924 - 2,737 689,661 5,250 5,250 554 0.35% Treasury Note 0.500% 2/12/21 3/31/25 1,500,000 1,510,371 1,456,755 - 7,920 1,464,675 - - 3,156 0.33% Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,610 985,040 - 4,110 989,150 - - 11,500 3.16% Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,970 985,040 - 4,110 989,150 - - 11,500 3.14% Treasury Note 0.375% 2/12/21 4/30/25 1,500,000 1,501,934 1,450,170 - 8,610 1,458,780 - - 1,895 0.34% Treasury Note 0.250% 9/30/21 5/31/25 2,000,000 1,964,219 1,924,820 - 12,640 1,937,460 - - 1,270 0.75% Treasury Note 2.875% 9/28/23 6/15/25 2,000,000 1,924,297 1,966,180 - 7,980 1,974,160 - - 12,254 5.21% Treasury Note 3.000% 12/21/22 7/15/25 2,000,000 1,945,547 1,966,600 - 8,480 1,975,080 - 30,000 7,826 4.13% Treasury Note 3.125% 12/21/22 8/15/25 2,000,000 1,951,172 1,967,580 - 8,680 1,976,260 31,250 31,250 2,887 4.11% Corporate Note - Walmart 3.900% 9/29/22 9/9/25 1,000,000 982,170 990,800 - 4,200 995,000 - - 18,633 4.55% Certificate of Deposit 4.300% 9/29/22 9/29/25 245,000 244,265 243,234 - 1,860 245,094 - - 4,594 4.41% Treasury Note 4.250% 9/28/23 10/15/25 2,000,000 1,967,813 1,990,320 - 8,440 1,998,760 - - 32,281 5.09% Corporate Note - Microsoft 3.125% 3/17/22 11/3/25 1,000,000 1,024,730 980,820 - 5,610 986,430 - - 10,243 2.36% Home Loan Bank 4.500% 2/7/23 12/12/25 2,000,000 2,035,620 1,995,720 - 10,680 2,006,400 - - 19,750 3.83% Fed Farm Credit Bank 4.000% 2/7/23 1/13/26 1,233,000 1,239,325 1,221,644 - 6,288 1,227,932 - 24,660 6,576 3.81% Fed Farm Credit Bank 4.375% 2/28/23 2/23/26 2,000,000 1,987,560 1,994,920 - 10,220 2,005,140 43,750 43,750 1,944 4.60% City of Camarillo
LAIF Interest
Report on the Local Agency Investment Fund & U.S. Government Securities August 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 Valu e Price 7/31/2024 (Maturities) or (Decr) 8/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,889,900 - 15,860 1,905,760 - - 9,387 3.14% Corporate Note - Berkshire Hathaway 3.125% 3/17/22 3/15/26 1,000,000 1,018,170 978,440 - 7,280 985,720 - - 14,410 2.61% Corporate Note - Proctor & Gamble 1.000% 12/21/22 4/23/26 1,000,000 898,650 943,480 - 7,130 950,610 - - 3,556 4.29% Fed Farm Credit Bank 4.375% 6/29/23 6/23/26 2,000,000 1,998,760 1,999,280 - 15,700 2,014,980 - - 16,528 4.40% Treasury Note 4.500% 11/22/23 7/15/26 2,000,000 1,990,078 2,005,000 - 13,520 2,018,520 - 45,000 11,739 4.70% Fed Farm Credit Bank 4.750% 9/28/23 9/1/26 2,000,000 1,988,240 2,014,880 - 13,800 2,028,680 - - 47,500 4.97% Certificate of Deposit 4.250% 9/30/22 9/30/26 245,000 244,020 243,812 - 2,344 246,156 - - 4,422 4.36% Home Loan MC 0.800% 9/29/22 10/27/26 2,000,000 1,732,400 1,845,440 - 23,620 1,869,060 - - 5,511 4.42% Corporate Bond - VISA Inc. 1.900% 2/7/22 4/15/27 1,000,000 926,600 934,340 - 13,310 947,650 - - 7,178 3.81% Treasury Note 2.375% 6/29/23 5/15/27 2,000,000 1,869,531 1,905,700 - 19,620 1,925,320 - - 14,069 4.22% Home Loan Bank 4.625% 7/18/24 6/11/27 2,000,000 2,018,360 2,022,400 - 16,360 2,038,760 - - 27,493 4.28% Fed Farm Credit Bank 4.125% 2/28/23 8/23/27 2,000,000 1,983,540 1,995,720 - 19,320 2,015,040 41,250 41,250 1,833 4.33% Corporate Note - Apple Inc. 3.000% 6/29/23 11/13/27 1,000,000 945,670 958,490 - 13,080 971,570 - - 9,000 4.38% Treasury Note 3.500% 11/22/23 1/31/28 2,000,000 1,922,188 1,961,640 - 20,320 1,981,960 - 35,000 6,087 4.53% Treasury Note 4.625% 5/30/24 9/30/28 2,000,000 1,994,375 2,043,760 - 20,860 2,064,620 - - 38,921 4.70% Treasury Note 4.875% 3/22/24 10/31/28 2,000,000 2,043,594 2,064,380 - 20,620 2,085,000 - - 32,853 4.35% Treasury Note 4.375% 3/22/24 11/30/28 2,000,000 2,003,906 2,027,340 - 20,780 2,048,120 - - 22,234 4.33% Treasury Note 3.750% 3/22/24 12/31/28 2,000,000 1,950,469 1,977,420 - 22,260 1,999,680 - 37,500 12,840 4.33% Treasury Note 4.000% 3/22/24 1/31/29 2,000,000 1,972,578 1,998,200 - 21,960 2,020,160 - 40,000 6,957 4.32% Treasury Note 5.250% 5/21/24 2/15/29 2,000,000 2,072,813 2,107,740 - 22,420 2,130,160 52,500 52,500 4,851 4.39% Treasury Note 4.125% 6/27/24 3/31/29 2,000,000 1,985,469 2,009,060 - 22,420 2,031,480 - - 34,713 4.29% Home Loan Bank 4.625% 7/18/24 6/8/29 2,000,000 2,041,960 2,050,180 - 24,720 2,074,900 - - 30,319 4.14% - - - - - - - 52,500 - -
Total U.S. Securities 86,968,000 86,516,061 97,069,830 (11,000,000) 606,381 86,676,211 200,250 498,660 566,005 3.51% Grand Total - LAIF & U.S. Securities 240,168,000 239,716,061 236,969,830 4,700,000 (1,793,619) 239,876,211 200,250 2,217,464 1,674,371 4.19% At 8/31/2024, the City's average earnings rate on all investments listed above was 4.19%, LAIF earnings rate was 4.58%, while 3.51% 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.
Total Market Value:
Table 1: Securities Matured Total US Securities 239,876,211$ Security Type Par Purchase Price (1) Gain / (Loss) Net = (1) + (2) Total Accrued Interest 1,674,371 Treasury Note 10,000,000 9,884,954 115,046 115,046 241,550,582$ Fed Farm Credit Bank 1,000,000 1,000,880 (880) 65,120 Fiscal Year Received
(2) Total Interest Earned
-
Accrued
Interest
Securities Interest
66,000
FY 2024/25 Interest Prior to 8/2024 for Matured/Called Securities
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 @ August 31, 2024 3,774,415
11,205,000 7,500,000
26,485,000 4,030,000
12,600,000 -
Next Principal Payment Due
Principal Payment Amount
381,890
640,000
295,000
720,000
345,000
840,000
-
Principal Payment Due Date
09/01/24 09/01/24 09/01/24 09/01/24 12/01/24 06/01/25 - Next Two Interest Payments Due
1st Installment Amount
46,237
279,588
149,381
557,800
75,738
232,997
-
1st Installment Due
09/01/24 9/01/24 09/01/24 09/01/24 12/01/24 12/01/24 -
2nd Installment Amount
41,558
263,588
144,772
539,800
70,131
232,997
-
2nd Installment Due
03/01/25 3/01/25 03/01/25 03/01/25 6/01/25 06/01/25 -
Type of Investment Total
U.S. Bank 7,424,306 494,194
2,238,682
1,039,037
3,136,780
505,251
2,722
7,640
Bank of New York Mellon Tax-Exempt MMKT* 122 - -
122
-
-
-
-
Total Investments per Bank & General Ledger
7,424,428 494,194
2,238,682
1,039,159
3,136,780
505,251
2,722
7,640
*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
August 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