Purchase Market Totals
Investment Summary: $ % Price (G/L) Per Trustee % Yield LAIF Accounts 140,800,000 $ 58.72% 140,800,000 $ 140,800,000 $ 4.58% Securities:
U. S. T-Notes & Bills 63,000,000 26.28% 62,731,676 63,149,930 Agencies 25,233,000 10.52% 25,068,337 25,237,627 Certificates of Deposits 735,000 0.31% 732,918 732,758 Commerical Paper 2,000,000 0.83% 1,946,226 1,986,871 Corporate Notes 8,000,000 3.34% 7,787,570 7,854,220
Subtotal Securities 98, 968,000 41.28% 98,266,727 98,961,406 3.74% Subtotal LAIF Accounts & Securities 239,768,000$ 100.00% 239,066,727 239,761,406 4.22% Accrued Interest 2,238,736
Total Market Value 242,000,142
Total Bond Account Balances 4,366,030 4,366,030
Total Investments 243,432,757 $ 246,366,172 $
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 September 2024 for settlement in October 2024.
Greg Ramirez, City Manager / Treasurer Date Mark Uribe / Director of Finance Date City of Camarillo
Investment Report
Security Maturities / Totals at Par
September 30, 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
78.11%
+1-2 years
9.27% - $22.23m
+2-3 years
3.86% - $9.25m
+3-4 years
2.09% - $5.00m
+4-5 years
6.67% - $16.00m
Other
21.89%
INVESTMENT MATURITY SCHEDULE
Investments have a maturity of five years or less
$187,290,000
$52,478,000
Notes & Bills
26.28% - $63,000,000
LAIF - 58.72%
$140,800,000
Fed. Home Loan Bank
3.34% - $8.00m
Fed. Home Loan MC
1.67% - $4.00m
Fed. Farm Credit
4.68% - $11.23m
Fannie Mae
0.83% - $2.00m
Corporate Note
3.34% - $8.00m
Commercial Paper
0.83% - $2.00m
Certificate of Deposit
0.31% - $735k
Investment by Type
10 / 09 / 2024
10 / 09 / 2024
Market Value Per LAIF
Purchase Balanc e Balance
Investment Balance Price 8/31/2024 Deposits Withdrawals 9/30/2024 Month Y-T-D Yield Total LAIF 140,800,000 140,800,000 153,200,000 5,900,000 (18,300,000) 140,800,000 - 1,718,804 1,667,810 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 8/31/2024 (Maturities) or (Decr) 9/30/2024 Month Y-T-D Yield U.S. Securities
Treasury Note 1.250% 2/26/21 8/31/24 2,000,000 (2,000,000) - - 12,500 12,500 - 0.38% Home Loan Bank 2.875% 11/19/20 9/13/24 1,998,660 (2,000,000) 1,340 - 28,750 28,750 - 0.35% Treasury Note 0.000% 6/26/24 9/19/24 9,976,800 (10,000,000) 23,200 - - - - 5.35% Treasury Note 0.000% 9/19/24 10/24/24 10,000,000 9,953,212 - 9,953,212 16,688 9,969,900 - - - 4.90% Treasury Note 1.500% 1/20/21 10/31/24 2,000,000 2,089,609 1,988,000 - 6,460 1,994,460 - - 12,554 0.31% Commercial Paper - MUFG 0.000% 5/21/24 11/4/24 1,000,000 975,228 990,522 - 4,802 995,324 - - - 5.48% Certificate of Deposit 0.400% 11/18/20 11/20/24 245,000 244,633 242,344 - 1,126 243,470 - - 360 0.44% Treasury Note 1.500% 2/26/21 11/30/24 2,000,000 2,080,234 1,983,900 - 5,260 1,989,160 - - 10,082 0.42% Treasury Note 0.000% 9/20/24 12/03/24 10,000,000 9,902,567 - 9,902,567 18,133 9,920,700 - - - 4.85% Commercial Paper - Toyota Motor Corp. 0.000% 5/21/24 12/4/24 1,000,000 970,997 986,448 - 5,099 991,547 - - - 5.46% Treasury Note 1.750% 1/20/21 12/31/24 2,000,000 2,111,328 1,979,020 - 6,600 1,985,620 - 17,500 8,845 0.33% Fannie Mae 1.625% 12/29/20 1/7/25 2,000,000 2,104,780 1,976,680 - 7,220 1,983,900 - 16,250 7,583 0.31% Home Loan MC 1.500% 12/29/20 2/12/25 1,293,000 1,354,353 1,280,799 - 4,784 1,285,583 - 9,750 2,654 0.34% Home Loan MC 1.500% 12/29/20 2/12/25 707,000 740,278 689,661 - 2,576 692,237 - 5,250 1,429 0.35% Treasury Note 0.500% 2/12/21 3/31/25 1,500,000 1,510,371 1,464,675 - 6,975 1,471,650 3,750 3,750 21 0.33% Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,610 989,150 - 3,740 992,890 - - 14,000 3.16% Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,970 989,150 - 3,740 992,890 - - 14,000 3.14% Treasury Note 0.375% 2/12/21 4/30/25 1,500,000 1,501,934 1,458,780 - 7,560 1,466,340 - - 2,354 0.34% Treasury Note 0.250% 9/30/21 5/31/25 2,000,000 1,964,219 1,937,460 - 10,880 1,948,340 - - 1,680 0.75% Treasury Note 2.875% 9/28/23 6/15/25 2,000,000 1,924,297 1,974,160 - 7,740 1,981,900 - - 16,967 5.21% Treasury Note 3.000% 12/21/22 7/15/25 2,000,000 1,945,547 1,975,080 - 8,640 1,983,720 - 30,000 12,717 4.13% Treasury Note 3.125% 12/21/22 8/15/25 2,000,000 1,951,172 1,976,260 - 7,720 1,983,980 - 31,250 7,982 4.11% Corporate Note - Walmart 3.900% 9/29/22 9/9/25 1,000,000 982,170 995,000 - 2,770 997,770 19,500 19,500 2,383 4.55% Certificate of Deposit 4.300% 9/29/22 9/29/25 245,000 244,265 245,094 - (2,825) 242,269 5,311 5,311 88 4.41% Treasury Note 4.250% 9/28/23 10/15/25 2,000,000 1,967,813 1,998,760 - 7,180 2,005,940 - - 39,249 5.09% Corporate Note - Microsoft 3.125% 3/17/22 11/3/25 1,000,000 1,024,730 986,430 - 4,080 990,510 - - 12,847 2.36% Home Loan Bank 4.500% 2/7/23 12/12/25 2,000,000 2,035,620 2,006,400 - 8,280 2,014,680 - - 27,250 3.83% Fed Farm Credit Bank 4.000% 2/7/23 1/13/26 1,233,000 1,239,325 1,227,932 - 7,275 1,235,207 - 24,660 10,686 3.81% Fed Farm Credit Bank 4.375% 2/28/23 2/23/26 2,000,000 1,987,560 2,005,140 - 7,880 2,013,020 - 43,750 9,236 4.60% See Table 1:
City of Camarillo
LAIF Interest
Report on the Local Agency Investment Fund & U.S. Government Securities September 30, 2024
Investment Report
Continued on next page
Fiscal Year Received Accrued
Interest
U.S. Securities Interest
Fiscal Year Received Accrued
Interest
Doc ID: 4abc963f48d3a2aa2153a05c34d74d84a9b381a3
Maturity or Market Value Per Trustee
Interest Purchase Call Purchase Balance Purchases Market Incr. Balance Investment Rate Date Date Par Valu e Price 8/31/2024 (Maturities) or (Decr) 9/30/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,905,760 - 11,500 1,917,260 9,600 9,600 1,387 3.14% Corporate Note - Berkshire Hathaway 3.125% 3/17/22 3/15/26 1,000,000 1,018,170 985,720 - 2,040 987,760 15,625 15,625 1,389 2.61% Corporate Note - Proctor & Gamble 1.000% 12/21/22 4/23/26 1,000,000 898,650 950,610 - 7,160 957,770 - - 4,389 4.29% Treasury Note 3.625% 9/19/24 5/15/26 2,000,000 1,997,266 - 1,997,266 (626) 1,996,640 - - 27,385 3.71% Fed Farm Credit Bank 4.375% 6/29/23 6/23/26 2,000,000 1,998,760 2,014,980 - 9,000 2,023,980 - - 23,819 4.40% Treasury Note 4.500% 11/22/23 7/15/26 2,000,000 1,990,078 2,018,520 - 8,900 2,027,420 - 45,000 19,076 4.70% Treasury Note 4.375% 9/19/24 8/15/26 2,000,000 2,027,109 - 2,027,109 (2,349) 2,024,760 - - 11,175 3.63% Fed Farm Credit Bank 4.750% 9/28/23 9/1/26 2,000,000 1,988,240 2,028,680 - 11,460 2,040,140 47,500 47,500 7,917 4.97% Certificate of Deposit 4.250% 9/30/22 9/30/26 245,000 244,020 246,156 - 863 247,019 5,249 5,249 29 4.36% Home Loan MC 0.800% 9/29/22 10/27/26 2,000,000 1,732,400 1,869,060 - 12,820 1,881,880 - - 6,844 4.42% Corporate Bond - VISA Inc. 1.900% 2/7/22 4/15/27 1,000,000 926,600 947,650 - 7,540 955,190 - - 8,761 3.81% Treasury Note 2.375% 6/29/23 5/15/27 2,000,000 1,869,531 1,925,320 - 13,440 1,938,760 - - 17,942 4.22% Home Loan Bank 4.625% 7/18/24 6/11/27 2,000,000 2,018,360 2,038,760 - 12,560 2,051,320 - - 35,201 4.28% Fed Farm Credit Bank 4.125% 2/28/23 8/23/27 2,000,000 1,983,540 2,015,040 - 10,900 2,025,940 - 41,250 8,708 4.33% Corporate Note - Apple Inc. 3.000% 6/29/23 11/13/27 1,000,000 945,670 971,570 - 7,870 979,440 - - 11,500 4.38% Treasury Note 3.500% 11/22/23 1/31/28 2,000,000 1,922,188 1,981,960 - 12,800 1,994,760 - 35,000 11,793 4.53% Treasury Note 4.625% 5/30/24 9/30/28 2,000,000 1,994,375 2,064,620 - 12,100 2,076,720 46,250 46,250 254 4.70% Treasury Note 4.875% 3/22/24 10/31/28 2,000,000 2,043,594 2,085,000 - 11,720 2,096,720 - - 40,802 4.35% Treasury Note 4.375% 3/22/24 11/30/28 2,000,000 2,003,906 2,048,120 - 12,120 2,060,240 - - 29,406 4.33% Treasury Note 3.750% 3/22/24 12/31/28 2,000,000 1,950,469 1,999,680 - 12,740 2,012,420 - 37,500 18,954 4.33% Treasury Note 4.000% 3/22/24 1/31/29 2,000,000 1,972,578 2,020,160 - 12,660 2,032,820 - 40,000 13,478 4.32% Treasury Note 5.250% 5/21/24 2/15/29 2,000,000 2,072,813 2,130,160 - 12,500 2,142,660 - 52,500 13,410 4.39% Treasury Note 4.125% 6/27/24 3/31/29 2,000,000 1,985,469 2,031,480 - 12,820 2,044,300 41,250 41,250 227 4.29% Home Loan Bank 4.625% 7/18/24 6/8/29 2,000,000 2,041,960 2,074,900 - 9,980 2,084,880 - - 38,028 4.14% Fed Farm Credit Bank 3.500% 9/20/24 9/10/29 2,000,000 1,999,260 - 1,999,260 (11,660) 1,987,600 - - 4,083 3.51% - - - - - - - 69,000 - -
Total U.S. Securities 98,968,000 98,266,727 86,676,211 11,879,413 405,782 98,961,406 235,285 733,945 570,926 3.74% Grand Total - LAIF & U.S. Securities 239,768,000 239,066,727 239,876,211 17,779,413 (17,894,218) 239,761,406 235,285 2,452,749 2,238,736 4.22% At 9/30/2024, the City's average earnings rate on all investments listed above was 4.22%, LAIF earnings rate was 4.58%, while 3.74% 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,761,406$ Security Type Par Purchase Price (1) Gain / (Loss) Net = (1) + (2) Total Accrued Interest 2,238,736 Treasury Note 2,000,000 2,060,859 (60,859) 39,141 242,000,142$ Home Loan Bank 2,000,000 2,191,020 (191,020) 38,980 Treasury Note 10,000,000 9,876,868 123,132 123,132- 230,000
FY 2024/25 Interest Prior to 9/2024 for Matured/Called Securities Fiscal Year Received
(2) Total Interest Earned
100,000
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 @ September 30, 2024 3,392,525
10,565,000 7,205,000
25,765,000 4,030,000
12,600,000 -
Next Principal Payment Due
Principal Payment Amount
387,160
670,000
305,000
755,000
345,000
840,000
-
Principal Payment Due Date
09/01/25 09/01/25 09/01/25 09/01/25 12/01/24 06/01/25 - Next Two Interest Payments Due
1st Installment Amount
41,558
263,588
144,772
539,800
75,738
232,997
-
1st Installment Due
03/01/25 3/01/25 03/01/25 03/01/25 12/01/24 12/01/24 -
2nd Installment Amount
41,558
263,588
144,772
539,800
70,131
232,997
-
2nd Installment Due
09/01/25 09/01/25 09/01/25 09/01/25 6/01/25 06/01/25 -
Type of Investment Total
U.S. Bank 4,365,908 66,070
1,328,422
594,660
1,858,994
507,356
2,734
7,672
Bank of New York Mellon Tax-Exempt MMKT* 122 - -
122
-
-
-
-
Total Investments per Bank & General Ledger
4,366,030 66,070
1,328,422
594,782
1,858,994
507,356
2,734
7,672
*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
September 30, 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