Purchase Market Totals
Investment Summary: $ % Price (G/L) Per Trustee % Yield LAIF Accounts 146,400,000$ 60.43% 146,400,000$ 146,400,000$ 4.01% Securities:
U. S. T-Notes & Bills 59,000,000 24.36% 58,902,867 58,017,445 Agencies 27,133,000 11.20% 27,194,039 26,674,592
Certificates of Deposits 735,000 0.30% 732,918 718,562 Commerical Paper 1,000,000 0.41% 977,255 988,502
Corporate Notes 8,000,000 3.30% 7,787,570 7,722,600
Subtotal Securities 95,868,000 39.57% 95,594,649 94,121,701 2.99% Subtotal LAIF Accounts & Securities 242,268,000$ 100.00% 241,994,649 240,521,701 3.60% Accrued Interest 1,228,653
Total Market Value 241,750,354
Total Bond Account Balances 4,629,477 4,629,477
Total Investments 246,624,126$ 246,379,831$
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 January 2024 for settlement in February 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
January 31, 2024
Compliance Report and Attestations
At Par
1 year or less
81.54%
+1-2 years
9.28% - $22.48m
+2-3 years
5.88% - $14.25m
+3-4 years
3.30% - $8.00m
+4-5 years
0.00% - $0.00m
Other
18.46%
INVESTMENT MATURITY SCHEDULE
Investments have a maturity of five years or less
$197,545,000
$44,723,000
Notes & Bills
24.36% - $59,000,000
LAIF - 60.43%
$146,400,000
Fed. Home Loan Bank
2.48% - $6.00m
Fed. Home Loan MC
1.65% - $4.00m
Fed. Farm Credit
5.42% - $13.13m
Fannie Mae
1.65% - $4.00m
Corporate Note
3.30% - $8.00m
Commerical Paper
0.41% - $1.00m
Certificate of Deposit
0.30% - $735k
Investment by Type
02 / 14 / 2024
02 / 14 / 2024
Doc ID: 6b8f3bab589dd3b4c71033ccec42f1a66a9ee3a3
Market Value Per LAIF
Purchase Balance Balance
Investment Balance Price 12/31/2023 Deposits Withdrawals 1/31/2024 Month Y-T-D Yield Total LAIF 146,400,000 146,400,000 138,600,000 12,569,075 (4,769,075) 146,400,000 1,369,075 3,942,965 489,772 4.01% Maturity or Market Value Per Trustee
Interest Purchase Call Purchase Balance Purchases Market Incr. Balance Investment Rate Date Date Par Value Price 12/31/2023 (Maturities) or (Decr) 1/31/2024 Month Y-T-D Yield U.S. Securities
Treasury Note 0.125% 8/12/21 1/15/24 1,996,320 (2,000,000) 3,680 - 1,250 2,500 - 0.34% Fed Farm Credit Bank 0.230% 2/12/21 1/19/24 1,496,400 (1,500,000) 3,600 - 1,725 3,450 - 2.00% Treasury Note 0.125% 9/30/21 2/15/24 2,000,000 1,987,734 1,987,580 - 8,520 1,996,100 - 1,250 1,155 0.39% Fed Farm Credit Bank 0.250% 3/10/21 2/26/24 2,000,000 1,994,960 1,984,580 - 8,500 1,993,080 - 2,500 2,153 0.34% Treasury Note 0.000% 9/27/23 3/7/24 10,000,000 9,761,883 9,906,000 - 42,800 9,948,800 - - 186,672 5.51% Treasury Note 2.125% 4/13/21 3/31/24 2,000,000 2,103,672 1,984,060 - 5,560 1,989,620 - 21,250 14,399 0.37% Commercial Paper - MUFG 0.000% 11/22/23 4/17/24 1,000,000 977,256 983,378 - 5,124 988,502 - - 10,985 5.70% Fed Farm Credit Bank 2.440% 5/4/22 4/18/24 900,000 894,582 892,548 - 1,827 894,375 - 10,980 6,283 2.76% Treasury Note 2.250% 3/10/21 4/30/24 2,000,000 2,116,641 1,980,000 - 4,920 1,984,920 - 22,500 11,497 0.38% Treasury Note 0.000% 11/21/23 5/2/24 10,000,000 9,765,008 9,826,700 - 41,800 9,868,500 - - 103,800 5.40% Treasury Note 2.000% 3/30/21 5/31/24 2,000,000 2,104,219 1,973,360 - 5,320 1,978,680 - 20,000 6,885 0.35% Treasury Note 1.750% 3/30/21 6/30/24 2,000,000 2,089,219 1,966,640 - 5,400 1,972,040 17,500 17,500 3,077 0.37% Fannie Mae 1.750% 12/10/20 7/2/24 2,000,000 2,103,840 1,966,640 - 4,840 1,971,480 17,500 35,000 2,819 0.28% Treasury Note 1.750% 4/13/21 7/31/24 2,000,000 2,085,313 1,962,260 - 4,920 1,967,180 17,500 35,000 96 0.45% Fed Farm Credit Bank 3.300% 8/16/22 8/15/24 1,000,000 1,000,880 989,060 - 1,590 990,650 - 16,500 15,217 3.25% Treasury Note 1.250% 2/26/21 8/31/24 2,000,000 2,060,859 1,951,020 - 5,160 1,956,180 - 12,500 10,577 0.38% Home Loan Bank 2.875% 11/19/20 9/13/24 2,000,000 2,191,020 1,971,940 - 1,040 1,972,980 - 28,750 22,042 0.35% Treasury Note 1.500% 1/20/21 10/31/24 2,000,000 2,089,609 1,945,780 - 5,000 1,950,780 - 15,000 7,665 0.31% City of Camarillo
LAIF Interest
Report on the Local Agency Investment Fund & U.S. Government Securities January 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:
Doc ID: 6b8f3bab589dd3b4c71033ccec42f1a66a9ee3a3
Maturity or Market Value Per Trustee
Interest Purchase Call Purchase Balance Purchases Market Incr. Balance Investment Rate Date Date Par Value Price 12/31/2023 (Maturities) or (Decr) 1/31/2024 Month Y-T-D Yield Continued - U.S. Securities
Certificate of Deposit 0.400% 11/18/20 11/20/24 245,000 244,633 234,089 - 1,551 235,640 - 494 196 0.44% Treasury Note 1.500% 2/26/21 11/30/24 2,000,000 2,080,234 1,939,840 - 5,780 1,945,620 - 15,000 5,164 0.42% Treasury Note 1.750% 1/20/21 12/31/24 2,000,000 2,111,328 1,941,100 - 5,460 1,946,560 17,500 17,500 3,077 0.33% Fannie Mae 1.625% 12/29/20 1/7/25 2,000,000 2,104,780 1,938,260 - 4,780 1,943,040 16,250 32,500 2,167 0.31% Home Loan MC 1.500% 12/29/20 2/12/25 1,293,000 1,354,353 1,255,202 - 3,848 1,259,050 - 9,750 9,154 0.34% Home Loan MC 1.500% 12/29/20 2/12/25 707,000 740,278 675,878 - 2,072 677,950 - 5,250 4,929 0.35% Treasury Note 0.500% 2/12/21 3/31/25 1,500,000 1,510,371 1,426,470 - 4,740 1,431,210 - 3,750 2,541 0.33% Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,610 978,410 - 490 978,900 - 15,000 9,000 3.16% Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,970 978,410 - 490 978,900 - 15,000 9,000 3.14% Treasury Note 0.375% 2/12/21 4/30/25 1,500,000 1,501,934 1,419,720 - 4,995 1,424,715 - 2,813 1,437 0.34% Treasury Note 0.250% 9/30/21 5/31/25 2,000,000 1,964,219 1,883,820 - 7,280 1,891,100 - 2,500 861 0.75% Treasury Note 2.875% 9/28/23 6/15/25 2,000,000 1,924,297 1,955,000 - 3,040 1,958,040 - 28,750 7,541 5.21% Treasury Note 3.000% 12/21/22 7/15/25 2,000,000 1,945,547 1,956,640 - 3,520 1,960,160 30,000 60,000 2,802 4.13% Treasury Note 3.125% 12/21/22 8/15/25 2,000,000 1,951,172 1,960,460 - 1,880 1,962,340 - 31,250 28,872 4.11% Corporate Note - Walmart 3.900% 9/29/22 9/9/25 1,000,000 982,170 990,260 - 870 991,130 - 19,500 15,383 4.55% Certificate of Deposit 4.300% 9/29/22 9/29/25 245,000 244,265 242,473 - (247) 242,226 - 5,311 3,637 4.41% Treasury Note 4.250% 9/28/23 10/15/25 2,000,000 1,967,813 1,996,640 - 700 1,997,340 - 42,500 25,314 5.09% Corporate Note - Microsoft 3.125% 3/17/22 11/3/25 1,000,000 1,024,730 976,380 - 2,130 978,510 - 15,625 7,639 2.36% Home Loan Bank 4.500% 2/7/23 12/12/25 2,000,000 2,035,620 2,005,000 - 2,020 2,007,020 - 45,000 12,250 3.83% Fed Farm Credit Bank 4.000% 2/7/23 1/13/26 1,233,000 1,239,325 1,224,270 - 3,317 1,227,587 24,660 49,320 2,466 3.81% Fed Farm Credit Bank 4.375% 2/28/23 2/23/26 2,000,000 1,987,560 2,007,020 - (140) 2,006,880 - 43,750 38,403 4.60% Home Loan Bank 0.960% 5/4/22 3/5/26 2,000,000 1,843,900 1,859,620 - 5,580 1,865,200 - 9,600 7,787 3.14% Corporate Note - Berkshire Hathaway 3.125% 3/17/22 3/15/26 1,000,000 1,018,170 972,200 - 1,430 973,630 - 15,625 11,806 2.61% Corporate Note - Proctor & Gamble 1.000% 12/21/22 4/23/26 1,000,000 898,650 928,820 - 2,670 931,490 - 5,000 2,722 4.29% Fed Farm Credit Bank 4.375% 6/29/23 6/23/26 2,000,000 1,998,760 2,009,360 - 540 2,009,900 - 43,750 9,236 4.40% Treasury Note 4.500% 11/22/23 7/15/26 2,000,000 1,990,078 2,019,300 - (1,020) 2,018,280 45,000 45,000 4,203 4.70% Fed Farm Credit Bank 4.750% 9/28/23 9/1/26 2,000,000 1,988,240 2,030,820 - (1,100) 2,029,720 - - 39,583 4.97% Certificate of Deposit 4.250% 9/30/22 9/30/26 245,000 244,020 239,188 - 1,508 240,696 - 5,249 3,537 4.36% Home Loan MC 0.800% 9/29/22 10/27/26 2,000,000 1,732,400 1,814,080 - 5,180 1,819,260 - 8,000 4,178 4.42% Corporate Bond - VISA Inc. 1.900% 2/7/22 4/15/27 1,000,000 926,600 929,810 - 1,270 931,080 - 9,500 5,594 3.81% Treasury Note 2.375% 6/29/23 5/15/27 2,000,000 1,869,531 1,900,780 - 540 1,901,320 - 23,750 10,179 4.22% Fed Farm Credit Bank 4.125% 2/28/23 8/23/27 2,000,000 1,983,540 2,006,160 - 260 2,006,420 - 41,250 36,208 4.33% Corporate Note - Apple Inc. 3.000% 6/29/23 11/13/27 1,000,000 945,670 960,600 - (1,640) 958,960 - 15,000 6,500 4.38% Treasury Note 3.500% 11/22/23 1/31/28 2,000,000 1,922,188 1,970,000 - (2,040) 1,967,960 35,000 35,000 192 4.53% - - - - - - - 21,800 - - Total U.S. Securities 95,868,000 95,594,649 97,390,346 (3,500,000) 231,355 94,121,701 223,885 983,767 738,881 2.99% Grand Total - LAIF & U.S. Securities 242,268,000 241,994,649 235,990,346 9,069,075 (4,537,719) 240,521,701 1,592,960 4,926,732 1,228,653 3.60% At 1/31/2024, the City's average earnings rate on all investments listed above was 3.60%, LAIF earnings rate was 4.01%, while 2.99% 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 240,521,701 $ Treasury Note 2,000,000 1,989,688 10,312 16,562 Total Accrued Interest 1,228,653 Fed Farm Credit Bank 1,500,000 1,501,065 (1,065) 9,285 241,750,354 $ Accrued
Interest
Securities Interest
FY 2023/24 Interest Prior to 1/2024 for Matured/Called Securities Fiscal Year Received
(2) Total Interest Earned
6,250
10,350
Doc ID: 6b8f3bab589dd3b4c71033ccec42f1a66a9ee3a3
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 @ January 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 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,568,003 320,579 1,281,773 593,856 1,859,926 503,917 528 7,424 Bank of New York Mellon Tax-Exempt MMKT*61,474- - 61,474 - - - - Total Investments per Bank & General Ledger 4,629,477 320,579 1,281,773 655,330 1,859,926 503,917 528 7,424 *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
January 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
Doc ID: 6b8f3bab589dd3b4c71033ccec42f1a66a9ee3a3