Purchase Market Totals
Investment Summary: $ % Price (G/L) Per Trustee % Yield LAIF Accounts 144,715,421 $ 60.63% 144,715,421 $ 144,715,421 $ 4.27% Securities:
U. S. T-Notes & Bills 61,000,000 25.56% 60,792,877 59,916,500 Agencies 24,233,000 10.15% 24,304,497 23,578,833 Certificates of Deposits 735,000 0.31% 732,918 721,753 Corporate Notes 8,000,000 3.35% 7,787,570 7,646,470
Subtotal Securities 93, 968,000 39.37% 93,617,862 91,863,556 3.29% Subtotal LAIF Accounts & Securities 238,683,421$ 100.00% 238,333,282 236,578,977 3.88% Accrued Interest 1,000,665
Total Market Value 237,579,642
Total Bond Account Balances 3,581,539 3,581,539
Total Investments 241,914,821 $ 241,161,181 $
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 April 2024 for settlement in May 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
April 30, 2024
Compliance Report and Attestations
At Par
1 year or less
80.84%
+1-2 years
9.00% - $21.48m
+2-3 years
3.88% - $9.25m
+3-4 years
2.93% - $7.00m
+4-5 years
3.35% - $8.00m
Other
19.16%
INVESTMENT MATURITY SCHEDULE
Investments have a maturity of five years or less
$192,960,421
$45,723,000
Notes & Bills
25.56% - $61,000,000
LAIF - 60.63%
$144,715,421
Fed. Home Loan Bank
2.50% - $6.00m
Fed. Home Loan MC
1.68% - $4.00m
Fed. Farm Credit
4.29% - $10.23m
Fannie Mae
1.68% - $4.00m
Corporate Note
3.35% - $8.00m
Certificate of Deposit
0.31% - $735k
Investment by Type
05 / 08 / 2024
05 / 08 / 2024
Doc ID: 52501192b1ce24d30cd3f5dcd74d96419e140c07
Market Value Per LAIF
Purchase Balance Balance
Investment Balance Price 3/31/2024 Deposits Withdrawals 4/30/2024 Month Y-T-D Yield Total LAIF 144,715,421 144,715,421 143,000,000 8,285,270 (6,569,849) 144,715,421 1,585,270 5,528,235 507,881 4.27% Maturity or Market Value Per Trustee
Interest Purchase Call Purchase Balance Purchases Market Incr. Balance Investment Rate Date Date Par Value Price 3/31/2024 (Maturities) or (Decr) 4/30/2024 Month Y-T-D Yield U.S. Securities
Treasury Note 2.125% 4/13/21 3/31/24 2,000,000 (2,000,000) - - 21,250 42,500 - 0.37% Commercial Paper - MUFG 0.000% 11/22/23 4/17/24 997,166 (1,000,000) 2,834 - - - - 5.70% Fed Farm Credit Bank 2.440% 5/4/22 4/18/24 898,803 (900,000) 1,197 - 10,980 21,960 - 2.76% Treasury Note 2.250% 3/10/21 4/30/24 1,995,000 (2,000,000) 5,000 - 22,500 45,000 - 0.38% Treasury Note 0.000% 11/21/23 5/2/24 10,000,000 9,765,008 9,954,500 - 44,000 9,998,500 - - - 5.40% Treasury Note 2.000% 3/30/21 5/31/24 2,000,000 2,104,219 1,989,200 - 5,160 1,994,360 - 20,000 16,721 0.35% Treasury Note 0.000% 3/22/24 6/6/24 10,000,000 9,889,393 9,904,400 - 42,800 9,947,200 - - - 5.39% Treasury Note 1.750% 3/30/21 6/30/24 2,000,000 2,089,219 1,982,140 - 5,580 1,987,720 - 17,500 11,731 0.37% Fannie Mae 1.750% 12/10/20 7/2/24 2,000,000 2,103,840 1,981,760 - 5,460 1,987,220 - 35,000 11,569 0.28% Treasury Note 1.750% 4/13/21 7/31/24 2,000,000 2,085,313 1,976,480 - 5,640 1,982,120 - 35,000 8,750 0.45% Fed Farm Credit Bank 3.300% 8/16/22 8/15/24 1,000,000 1,000,880 992,780 - 920 993,700 - 33,000 6,967 3.25% Treasury Note 1.250% 2/26/21 8/31/24 2,000,000 2,060,859 1,966,900 - 5,900 1,972,800 - 25,000 4,212 0.38% Home Loan Bank 2.875% 11/19/20 9/13/24 2,000,000 2,191,020 1,978,560 - 2,880 1,981,440 - 57,500 7,667 0.35% Treasury Note 1.500% 1/20/21 10/31/24 2,000,000 2,089,609 1,957,180 - 5,020 1,962,200 15,000 30,000 82 0.31% Certificate of Deposit 0.400% 11/18/20 11/20/24 245,000 244,633 237,226 - 901 238,127 - 494 438 0.44% Treasury Note 1.500% 2/26/21 11/30/24 2,000,000 2,080,234 1,951,620 - 4,280 1,955,900 - 15,000 12,541 0.42% Treasury Note 1.750% 1/20/21 12/31/24 2,000,000 2,111,328 1,950,160 - 3,520 1,953,680 - 17,500 11,731 0.33% Fannie Mae 1.625% 12/29/20 1/7/25 2,000,000 2,104,780 1,947,200 - 2,720 1,949,920 - 32,500 10,292 0.31% Home Loan MC 1.500% 12/29/20 2/12/25 1,293,000 1,354,353 1,260,259 - 1,170 1,261,429 - 19,500 4,279 0.34% Home Loan MC 1.500% 12/29/20 2/12/25 707,000 740,278 678,601 - 630 679,231 - 10,500 2,304 0.35% Treasury Note 0.500% 2/12/21 3/31/25 1,500,000 1,510,371 1,434,660 - 2,295 1,436,955 3,750 7,500 635 0.33% Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,610 976,650 - 590 977,240 15,000 30,000 1,500 3.16% Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,970 976,650 - 590 977,240 15,000 30,000 1,500 3.14% Treasury Note 0.375% 2/12/21 4/30/25 1,500,000 1,501,934 1,427,865 - 1,800 1,429,665 2,813 5,625 15 0.34% Treasury Note 0.250% 9/30/21 5/31/25 2,000,000 1,964,219 1,894,380 - 1,400 1,895,780 - 2,500 2,090 0.75% Treasury Note 2.875% 9/28/23 6/15/25 2,000,000 1,924,297 1,951,800 - (2,820) 1,948,980 - 28,750 21,680 5.21% Treasury Note 3.000% 12/21/22 7/15/25 2,000,000 1,945,547 1,953,360 - (4,680) 1,948,680 - 60,000 17,637 4.13% Treasury Note 3.125% 12/21/22 8/15/25 2,000,000 1,951,172 1,954,680 - (5,700) 1,948,980 - 62,500 13,049 4.11% Corporate Note - Walmart 3.900% 9/29/22 9/9/25 1,000,000 982,170 985,830 - (2,950) 982,880 - 39,000 5,633 4.55% Certificate of Deposit 4.300% 9/29/22 9/29/25 245,000 244,265 242,687 - (279) 242,409 - 10,564 995 4.41% Treasury Note 4.250% 9/28/23 10/15/25 2,000,000 1,967,813 1,983,820 - (9,600) 1,974,220 42,500 85,000 3,716 5.09% Corporate Note - Microsoft 3.125% 3/17/22 11/3/25 1,000,000 1,024,730 974,130 - (4,230) 969,900 - 15,625 15,451 2.36% Home Loan Bank 4.500% 2/7/23 12/12/25 2,000,000 2,035,620 1,990,340 - (11,580) 1,978,760 - 45,000 34,750 3.83% Fed Farm Credit Bank 4.000% 2/7/23 1/13/26 1,233,000 1,239,325 1,217,316 - (7,743) 1,209,573 - 49,320 14,796 3.81% Fed Farm Credit Bank 4.375% 2/28/23 2/23/26 2,000,000 1,987,560 1,988,780 - (15,060) 1,973,720 - 87,500 16,528 4.60% Continued on next page
Fiscal Year Received Accrued
Interest
U.S. Securities Interest
Fiscal Year Received Accrued
Interest
City of Camarillo
LAIF Interest
Report on the Local Agency Investment Fund & U.S. Government Securities April 30, 2024
Investment Report
See Table 1:
Doc ID: 52501192b1ce24d30cd3f5dcd74d96419e140c07
Maturity or Market Value Per Trustee
Interest Purchase Call Purchase Balance Purchases Market Incr. Balance Investment Rate Date Date Par Value Price 3/31/2024 (Maturities) or (Decr) 4/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,862,200 - (7,660) 1,854,540 - 19,200 2,987 3.14% Corporate Note - Berkshire Hathaway 3.125% 3/17/22 3/15/26 1,000,000 1,018,170 968,290 - (4,880) 963,410 - 31,250 3,993 2.61% Corporate Note - Proctor & Gamble 1.000% 12/21/22 4/23/26 1,000,000 898,650 928,360 - (3,890) 924,470 5,000 10,000 222 4.29% Fed Farm Credit Bank 4.375% 6/29/23 6/23/26 2,000,000 1,998,760 1,989,480 - (16,640) 1,972,840 - 43,750 31,111 4.40% Treasury Note 4.500% 11/22/23 7/15/26 2,000,000 1,990,078 1,997,580 - (18,980) 1,978,600 - 45,000 26,456 4.70% Fed Farm Credit Bank 4.750% 9/28/23 9/1/26 2,000,000 1,988,240 2,006,880 - (21,580) 1,985,300 - 47,500 15,833 4.97% Certificate of Deposit 4.250% 9/30/22 9/30/26 245,000 244,020 242,113 - (895) 241,218 5,192 10,441 913 4.36% Home Loan MC 0.800% 9/29/22 10/27/26 2,000,000 1,732,400 1,819,740 - (20,500) 1,799,240 8,000 16,000 178 4.42% Corporate Bond - VISA Inc. 1.900% 2/7/22 4/15/27 1,000,000 926,600 925,270 - (10,550) 914,720 9,500 19,000 844 3.81% Treasury Note 2.375% 6/29/23 5/15/27 2,000,000 1,869,531 1,882,820 - (23,140) 1,859,680 - 23,750 21,923 4.22% Fed Farm Credit Bank 4.125% 2/28/23 8/23/27 2,000,000 1,983,540 1,979,640 - (27,720) 1,951,920 - 82,500 15,583 4.33% Corporate Note - Apple Inc. 3.000% 6/29/23 11/13/27 1,000,000 945,670 949,980 - (13,370) 936,610 - 15,000 14,000 4.38% Treasury Note 3.500% 11/22/23 1/31/28 2,000,000 1,922,188 1,942,420 - (32,880) 1,909,540 - 35,000 17,500 4.53% Treasury Note 4.875% 3/22/24 10/31/28 2,000,000 2,043,594 2,051,320 - (42,880) 2,008,440 48,750 48,750 265 4.35% Treasury Note 4.375% 3/22/24 11/30/28 2,000,000 2,003,906 2,011,640 - (42,820) 1,968,820 - - 36,578 4.33% Treasury Note 3.750% 3/22/24 12/31/28 2,000,000 1,950,469 1,958,440 - (41,880) 1,916,560 - - 25,137 4.33% Treasury Note 4.000% 3/22/24 1/31/29 2,000,000 1,972,578 1,980,460 - (43,340) 1,937,120 - - 20,000 4.32% - - - - - - - 35,250 - - Total U.S. Securities 93,968,000 93,617,862 98,049,516 (5,900,000) (285,960) 91,863,556 225,234 1,499,229 492,784 3.29% Grand Total - LAIF & U.S. Securities 238,683,421 238,333,282 241,049,516 2,385,270 (6,855,809) 236,578,977 1,810,504 7,027,464 1,000,665 3.88% At 4/30/2024, the City's average earnings rate on all investments listed above was 3.88%, LAIF earnings rate was 4.27%, while 3.29% 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 236,578,977$ Treasury Note 2,000,000 2,103,672 (103,672) 23,828 Total Accrued Interest 1,000,665 Commercial Paper - MUFG 1,000,000 977,256 22,744 22,744 237,579,642$ Fed Farm Credit Bank 900,000 894,582 5,418 49,338 Treasury Note 2,000,000 2,116,641 (116,641) 40,859 Securities Interest
Fiscal Year Received
(2) Total Interest Earned
127,500
-
Accrued
Interest
157,500
43,920
FY 2023/24 Interest Prior to 4/2024 for Matured/Called Securities
Doc ID: 52501192b1ce24d30cd3f5dcd74d96419e140c07
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 @ April 30, 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,555,778 274,187 1,016,780 444,482 1,302,146 510,134 534 7,515 Bank of New York Mellon Tax-Exempt MMKT* 25,761 - - 25,761 - - - - Total Investments per Bank & General Ledger 3,581,539 274,187 1,016,780 470,243 1,302,146 510,134 534 7,515 *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
April 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
Doc ID: 52501192b1ce24d30cd3f5dcd74d96419e140c07