Purchase Market Totals
Investment Summary: $ % Price (G/L) Per Trustee % Yield LAIF Accounts 147,900,000 $ 60.16% 147,900,000 $ 147,900,000 $ 4.33% Securities:
U. S. T-Notes & Bills 63,000,000 25.62% 62,875,792 48,150,830 Agencies 24,233,000 9.86% 24,304,496 37,652,503 Certificates of Deposits 735,000 0.30% 732,918 722,299 Commerical Paper 2,000,000 0.81% 1,946,226 1,948,186 Corporate Notes 8,000,000 3.25% 7,787,570 7,679,120
Subtotal Securities 97, 968,000 39.84% 97,647,002 96,152,938 3.45% Subtotal LAIF Accounts & Securities 245,868,000$ 100.00% 245,547,002 244,052,938 3.98% Accrued Interest 1,650,410
Total Market Value 245,703,348
Total Bond Account Balances 4,922,640 4,922,640
Total Investments 250,469,642 $ 250,625,988 $
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 May 2024 for settlement in June 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
May 31, 2024
Compliance Report and Attestations
At Par
1 year or less
80.59%
+1-2 years
7.92% - $19.48m
+2-3 years
4.58% - $11.25m
+3-4 years
2.03% - $5.00m
+4-5 years
4.88% - $12.00m
Other
19.41%
INVESTMENT MATURITY SCHEDULE
Investments have a maturity of five years or less
$198,145,000
$47,723,000
Notes & Bills
25.62% - $63,000,000
LAIF - 60.16%
$147,900,000
Fed. Home Loan Bank
2.44% - $6.00m
Fed. Home Loan MC
1.63% - $4.00m
Fed. Farm Credit
4.16% - $10.23m
Fannie Mae
1.63% - $4.00m
Corporate Note
3.25% - $8.00m
Commercial Paper
0.81% - $2.00m
Certificate of Deposit
0.30% - $735k
Investment by Type
06 / 11 / 2024
06 / 10 / 2024
Market Value Per LAIF
Purchase Balanc e Balance
Investment Balance Price 4/30/2024 Deposits Withdrawals 5/31/2024 Month Y-T-D Yield Total LAIF 147,900,000 147,900,000 144,715,421 26,000,000 (22,815,421) 147,900,000 - 5,528,235 1,077,468 4.33% Maturity or Market Value Per Trustee
Interest Purchase Call Purchase Balanc e Purchases Market Incr. Balanc e Investment Rate Date Date Par Value Price 4/30/2024 (Maturities) or (Decr) 5/31/2024 Month Y-T-D Yield U.S. Securities
Treasury Note 0.000% 11/21/23 5/2/24 9,998,500 (10,000,000) 1,500 - - - - 5.40% Treasury Note 2.000% 3/30/21 5/31/24 1,994,360 (2,000,000) 5,640 - 20,000 40,000 - 0.35% Treasury Note 0.000% 3/22/24 6/6/24 10,000,000 9,889,393 9,947,200 - 48,400 9,995,600 - - - 5.39% Treasury Note 1.750% 3/30/21 6/30/24 2,000,000 2,089,219 1,987,720 - 6,880 1,994,600 - 17,500 14,712 0.37% Fannie Mae 1.750% 12/10/20 7/2/24 2,000,000 2,103,840 1,987,220 - 7,000 1,994,220 - 35,000 14,486 0.28% Treasury Note 1.750% 4/13/21 7/31/24 2,000,000 2,085,313 1,982,120 - 6,080 1,988,200 - 35,000 11,731 0.45% Treasury Note 0.000% 5/21/24 8/8/24 10,000,000 9,884,954 - 9,884,954 18,746 9,903,700 - - - 5.39% Fed Farm Credit Bank 3.300% 8/16/22 8/15/24 1,000,000 1,000,880 993,700 - 1,720 995,420 - 33,000 9,717 3.25% Treasury Note 1.250% 2/26/21 8/31/24 2,000,000 2,060,859 1,972,800 - 7,140 1,979,940 - 25,000 6,318 0.38% Home Loan Bank 2.875% 11/19/20 9/13/24 2,000,000 2,191,020 1,981,440 - 4,820 1,986,260 - 57,500 12,458 0.35% Treasury Note 1.500% 1/20/21 10/31/24 2,000,000 2,089,609 1,962,200 - 7,080 1,969,280 - 30,000 2,609 0.31% Commercial Paper - MUFG 0.000% 5/21/24 11/4/24 1,000,000 975,228 - 975,228 983 976,212 - - - 5.48% Certificate of Deposit 0.400% 11/18/20 11/20/24 245,000 244,633 238,127 - 1,067 239,194 489 983 32 0.44% Treasury Note 1.500% 2/26/21 11/30/24 2,000,000 2,080,234 1,955,900 - 6,680 1,962,580 15,000 30,000 82 0.42% Commercial Paper - Toyota Motor Corp. 0.000% 5/21/24 12/4/24 1,000,000 970,997 - 970,997 977 971,974 - - - 5.46% Treasury Note 1.750% 1/20/21 12/31/24 2,000,000 2,111,328 1,953,680 - 6,120 1,959,800 - 17,500 14,712 0.33% Fannie Mae 1.625% 12/29/20 1/7/25 2,000,000 2,104,780 1,949,920 - 7,400 1,957,320 - 32,500 13,000 0.31% Home Loan MC 1.500% 12/29/20 2/12/25 1,293,000 1,354,353 1,261,429 - 5,187 1,266,616 - 19,500 5,904 0.34% Home Loan MC 1.500% 12/29/20 2/12/25 707,000 740,278 679,231 - 2,793 682,024 - 10,500 3,179 0.35% Treasury Note 0.500% 2/12/21 3/31/25 1,500,000 1,510,371 1,436,955 - 6,540 1,443,495 - 7,500 1,270 0.33% Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,610 977,240 - 2,170 979,410 - 30,000 4,000 3.16% Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,970 977,240 - 2,170 979,410 - 30,000 4,000 3.14% Treasury Note 0.375% 2/12/21 4/30/25 1,500,000 1,501,934 1,429,665 - 6,570 1,436,235 - 5,625 489 0.34% Treasury Note 0.250% 9/30/21 5/31/25 2,000,000 1,964,219 1,895,780 - 9,200 1,904,980 2,500 5,000 14 0.75% Treasury Note 2.875% 9/28/23 6/15/25 2,000,000 1,924,297 1,948,980 - 4,780 1,953,760 - 28,750 26,551 5.21% Treasury Note 3.000% 12/21/22 7/15/25 2,000,000 1,945,547 1,948,680 - 5,080 1,953,760 - 60,000 22,747 4.13% Treasury Note 3.125% 12/21/22 8/15/25 2,000,000 1,951,172 1,948,980 - 4,620 1,953,600 - 62,500 18,372 4.11% Corporate Note - Walmart 3.900% 9/29/22 9/9/25 1,000,000 982,170 982,880 - 2,360 985,240 - 39,000 8,883 4.55% Certificate of Deposit 4.300% 9/29/22 9/29/25 245,000 244,265 242,409 - (286) 242,123 - 10,564 1,902 4.41% Treasury Note 4.250% 9/28/23 10/15/25 2,000,000 1,967,813 1,974,220 - 3,680 1,977,900 - 85,000 10,915 5.09% Corporate Note - Microsoft 3.125% 3/17/22 11/3/25 1,000,000 1,024,730 969,900 - 3,110 973,010 15,625 31,250 2,431 2.36% Home Loan Bank 4.500% 2/7/23 12/12/25 2,000,000 2,035,620 1,978,760 - 9,120 1,987,880 - 45,000 42,250 3.83% Fed Farm Credit Bank 4.000% 2/7/23 1/13/26 1,233,000 1,239,325 1,209,573 - 3,650 1,213,223 - 49,320 18,906 3.81% Fed Farm Credit Bank 4.375% 2/28/23 2/23/26 2,000,000 1,987,560 1,973,720 - 6,540 1,980,260 - 87,500 23,819 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 May 31, 2024
Investment Report
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 4/30/2024 (Maturities) or (Decr) 5/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,854,540 - 12,340 1,866,880 - 19,200 4,587 3.14% Corporate Note - Berkshire Hathaway 3.125% 3/17/22 3/15/26 1,000,000 1,018,170 963,410 - 3,320 966,730 - 31,250 6,597 2.61% Corporate Note - Proctor & Gamble 1.000% 12/21/22 4/23/26 1,000,000 898,650 924,470 - 5,620 930,090 - 10,000 1,056 4.29% Fed Farm Credit Bank 4.375% 6/29/23 6/23/26 2,000,000 1,998,760 1,972,840 - 5,560 1,978,400 - 43,750 38,403 4.40% Treasury Note 4.500% 11/22/23 7/15/26 2,000,000 1,990,078 1,978,600 - 6,640 1,985,240 - 45,000 34,121 4.70% Fed Farm Credit Bank 4.750% 9/28/23 9/1/26 2,000,000 1,988,240 1,985,300 - 10,440 1,995,740 - 47,500 23,750 4.97% Certificate of Deposit 4.250% 9/30/22 9/30/26 245,000 244,020 241,218 - (235) 240,982 - 10,441 1,797 4.36% Home Loan MC 0.800% 9/29/22 10/27/26 2,000,000 1,732,400 1,799,240 - 15,500 1,814,740 - 16,000 1,511 4.42% Corporate Bond - VISA Inc. 1.900% 2/7/22 4/15/27 1,000,000 926,600 914,720 - 5,590 920,310 - 19,000 2,428 3.81% Treasury Note 2.375% 6/29/23 5/15/27 2,000,000 1,869,531 1,859,680 - 13,280 1,872,960 23,750 47,500 2,194 4.22% Fed Farm Credit Bank 4.125% 2/28/23 8/23/27 2,000,000 1,983,540 1,951,920 - 13,600 1,965,520 - 82,500 22,458 4.33% Corporate Note - Apple Inc. 3.000% 6/29/23 11/13/27 1,000,000 945,670 936,610 - 8,310 944,920 15,000 30,000 1,500 4.38% Treasury Note 3.500% 11/22/23 1/31/28 2,000,000 1,922,188 1,909,540 - 14,840 1,924,380 - 35,000 23,462 4.53% Treasury Note 4.625% 5/30/24 9/30/28 2,000,000 1,994,375 - 1,994,375 8,365 2,002,740 - - 15,669 4.70% Treasury Note 4.875% 3/22/24 10/31/28 2,000,000 2,043,594 2,008,440 - 14,760 2,023,200 - 48,750 8,478 4.35% Treasury Note 4.375% 3/22/24 11/30/28 2,000,000 2,003,906 1,968,820 - 15,860 1,984,680 43,750 43,750 239 4.33% Treasury Note 3.750% 3/22/24 12/31/28 2,000,000 1,950,469 1,916,560 - 16,560 1,933,120 - - 31,525 4.33% Treasury Note 4.000% 3/22/24 1/31/29 2,000,000 1,972,578 1,937,120 - 16,400 1,953,520 - - 26,813 4.32% Treasury Note 5.250% 5/21/24 2/15/29 2,000,000 2,072,813 - 2,072,813 (11,253) 2,061,560 - - 30,865 4.39% - - - - - - - 144,710 - -
Total U.S. Securities 97,968,000 97,647,002 91,863,556 3,898,367 391,014 96,152,938 136,114 1,635,343 572,943 3.45% Grand Total - LAIF & U.S. Securities 245,868,000 245,547,002 236,578,977 29,898,367 (22,424,407) 244,052,938 136,114 7,163,578 1,650,410 3.98% At 5/31/2024, the City's average earnings rate on all investments listed above was 3.98%, LAIF earnings rate was 4.33%, while 3.45% 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 244,052,938$ Treasury Note 10,000,000 9,765,008 234,992 234,992 Total Accrued Interest 1,650,410 Treasury Note 2,000,000 2,104,219 (104,219) 35,781 245,703,348$ Securities Interest
Fiscal Year Received
(2) Total Interest Earned
-
140,000
Accrued
Interest
FY 2023/24 Interest Prior to 5/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 @ May 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 4,896,812 494,189
1,020,884
444,483
1,302,152
574,559
1,052,999
7,546
Bank of New York Mellon Tax-Exempt MMKT* 25,828 - -
25,828
-
-
-
-
Total Investments per Bank & General Ledger
4,922,640 494,189
1,020,884
470,311
1,302,152
574,559
1,052,999
7,546
*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
May 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