Purchase Market Totals
Investment Summary: $ % Price (G/L) Per Trustee % Yield LAIF Accounts 139,900,000 $ 58.82% 139,900,000 $ 139,900,000 $ 4.52% Securities:
U. S. T-Notes & Bills 61,000,000 25.64% 60,674,205 60,662,126 Agencies 26,233,000 11.03% 26,260,976 25,955,594 Certificates of Deposits 735,000 0.31% 732,918 728,316 Commerical Paper 2,000,000 0.84% 1,946,226 1,967,344 Corporate Notes 8,000,000 3.36% 7,787,570 7,756,450
Subtotal Securities 97, 968,000 41.18% 97,401,895 97,069,830 3.70% Subtotal LAIF Accounts & Securities 237,868,000$ 100.00% 237,301,895 236,969,830 4.17% Accrued Interest 1,146,127
Total Market Value 238,115,957
Total Bond Account Balances 7,412,955 7,412,955
Total Investments 244,714,850 $ 245,528,912 $
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 July 2024 for settlement in August 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
July 31, 2024
Compliance Report and Attestations
At Par
1 year or less
79.10%
+1-2 years
8.19% - $19.48m
+2-3 years
3.88% - $9.25m
+3-4 years
2.10% - $5.00m
+4-5 years
6.73% - $16.00m
Other
20.90%
INVESTMENT MATURITY SCHEDULE
Investments have a maturity of five years or less
$188,145,000
$49,723,000
Notes & Bills
25.64% - $61,000,000
LAIF - 58.82%
$139,900,000
Fed. Home Loan Bank
4.20% - $10.00m
Fed. Home Loan MC
1.68% - $4.00m
Fed. Farm Credit
4.31% - $10.23m
Fannie Mae
0.84% - $2.00m
Corporate Note
3.36% - $8.00m
Commercial Paper
0.84% - $2.00m
Certificate of Deposit
0.31% - $735k
Investment by Type
08 / 16 / 2024
08 / 15 / 2024
Market Value Per LAIF
Purchase Balanc e Balance
Investment Balance Price 6/30/2024 Deposits Withdrawals 7/31/2024 Month Y-T-D Yield Total LAIF 139,900,000 139,900,000 148,000,000 4,618,804 (12,718,804) 139,900,000 1,718,804 1,718,804 562,114 4.52% Maturity or Market Value Per Trustee
Interest Purchase Call Purchase Balanc e Purchases Market Incr. Balanc e Investment Rate Date Date Par Value Price 6/30/2024 (Maturities) or (Decr) 7/31/2024 Month Y-T-D Yield U.S. Securities
Treasury Note
1.750% 3/30/21 6/30/24 2,000,000 (2,000,000) - - 17,500 17,500 - 0.37% Fannie Mae 1.750% 12/10/20 7/2/24 1,999,780 (2,000,000) 220 - 17,500 17,500 - 0.28% Treasury Note 1.750% 4/13/21 7/31/24 1,994,060 (2,000,000) 5,940 - 17,500 17,500 - 0.45% Treasury Note 0.000% 5/21/24 8/8/24 10,000,000 9,884,954 9,944,800 - 45,000 9,989,800 - - - 5.39% Fed Farm Credit Bank 3.300% 8/16/22 8/15/24 1,000,000 1,000,880 997,140 - 2,030 999,170 - - 15,217 3.25% Treasury Note 1.250% 2/26/21 8/31/24 2,000,000 2,060,859 1,986,020 - 6,820 1,992,840 - - 10,462 0.38% Home Loan Bank 2.875% 11/19/20 9/13/24 2,000,000 2,191,020 1,989,620 - 4,460 1,994,080 - - 22,042 0.35% Treasury Note 0.000% 6/26/24 9/19/24 10,000,000 9,876,868 9,884,200 - 44,400 9,928,600 - - - 5.35% Treasury Note 1.500% 1/20/21 10/31/24 2,000,000 2,089,609 1,974,300 - 6,860 1,981,160 - - 7,582 0.31% Commercial Paper - MUFG 0.000% 5/21/24 11/4/24 1,000,000 975,228 980,517 - 5,216 985,733 - - - 5.48% Certificate of Deposit 0.400% 11/18/20 11/20/24 245,000 244,633 240,102 - 1,168 241,271 - - 196 0.44% Treasury Note 1.500% 2/26/21 11/30/24 2,000,000 2,080,234 1,968,640 - 6,580 1,975,220 - - 5,082 0.42% Commercial Paper - Toyota Motor Corp. 0.000% 5/21/24 12/4/24 1,000,000 970,997 976,384 - 5,227 981,611 - - - 5.46% Treasury Note 1.750% 1/20/21 12/31/24 2,000,000 2,111,328 1,964,840 - 7,000 1,971,840 17,500 17,500 3,043 0.33% Fannie Mae 1.625% 12/29/20 1/7/25 2,000,000 2,104,780 1,962,680 - 6,940 1,969,620 16,250 16,250 2,167 0.31% Home Loan MC 1.500% 12/29/20 2/12/25 1,293,000 1,354,353 1,270,087 - 5,629 1,275,716 - - 9,154 0.34% Home Loan MC 1.500% 12/29/20 2/12/25 707,000 740,278 683,893 - 3,031 686,924 - - 4,929 0.35% Treasury Note 0.500% 2/12/21 3/31/25 1,500,000 1,510,371 1,448,715 - 8,040 1,456,755 - - 2,520 0.33% Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,610 981,580 - 3,460 985,040 - - 9,000 3.16% Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,970 981,580 - 3,460 985,040 - - 9,000 3.14% Treasury Note 0.375% 2/12/21 4/30/25 1,500,000 1,501,934 1,441,935 - 8,235 1,450,170 - - 1,422 0.34% Treasury Note 0.250% 9/30/21 5/31/25 2,000,000 1,964,219 1,912,640 - 12,180 1,924,820 - - 847 0.75% Treasury Note 2.875% 9/28/23 6/15/25 2,000,000 1,924,297 1,957,740 - 8,440 1,966,180 - - 7,384 5.21% Treasury Note 3.000% 12/21/22 7/15/25 2,000,000 1,945,547 1,958,080 - 8,520 1,966,600 30,000 30,000 2,772 4.13% Treasury Note 3.125% 12/21/22 8/15/25 2,000,000 1,951,172 1,958,040 - 9,540 1,967,580 - - 28,846 4.11% Corporate Note - Walmart 3.900% 9/29/22 9/9/25 1,000,000 982,170 985,550 - 5,250 990,800 - - 15,383 4.55% Certificate of Deposit 4.300% 9/29/22 9/29/25 245,000 244,265 242,056 - 1,178 243,234 - - 3,687 4.41% Treasury Note 4.250% 9/28/23 10/15/25 2,000,000 1,967,813 1,981,180 - 9,140 1,990,320 - - 25,082 5.09% Corporate Note - Microsoft 3.125% 3/17/22 11/3/25 1,000,000 1,024,730 975,260 - 5,560 980,820 - - 7,639 2.36% Home Loan Bank 4.500% 2/7/23 12/12/25 2,000,000 2,035,620 1,988,400 - 7,320 1,995,720 - - 12,250 3.83% Fed Farm Credit Bank 4.000% 2/7/23 1/13/26 1,233,000 1,239,325 1,215,393 - 6,251 1,221,644 24,660 24,660 2,466 3.81% Fed Farm Credit Bank 4.375% 2/28/23 2/23/26 2,000,000 1,987,560 1,983,560 - 11,360 1,994,920 - - 38,403 4.60% City of Camarillo
LAIF Interest
Report on the Local Agency Investment Fund & U.S. Government Securities July 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 6/30/2024 (Maturities) or (Decr) 7/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,872,760 - 17,140 1,889,900 - - 7,787 3.14% Corporate Note - Berkshire Hathaway 3.125% 3/17/22 3/15/26 1,000,000 1,018,170 968,090 - 10,350 978,440 - - 11,806 2.61% Corporate Note - Proctor & Gamble 1.000% 12/21/22 4/23/26 1,000,000 898,650 933,810 - 9,670 943,480 - - 2,722 4.29% Fed Farm Credit Bank 4.375% 6/29/23 6/23/26 2,000,000 1,998,760 1,985,980 - 13,300 1,999,280 - - 9,236 4.40% Treasury Note 4.500% 11/22/23 7/15/26 2,000,000 1,990,078 1,991,480 - 13,520 2,005,000 45,000 45,000 4,158 4.70% Fed Farm Credit Bank 4.750% 9/28/23 9/1/26 2,000,000 1,988,240 2,000,740 - 14,140 2,014,880 - - 39,583 4.97% Certificate of Deposit 4.250% 9/30/22 9/30/26 245,000 244,020 240,631 - 3,181 243,812 - - 3,537 4.36% Home Loan MC 0.800% 9/29/22 10/27/26 2,000,000 1,732,400 1,824,880 - 20,560 1,845,440 - - 4,178 4.42% Corporate Bond - VISA Inc. 1.900% 2/7/22 4/15/27 1,000,000 926,600 923,240 - 11,100 934,340 - - 5,594 3.81% Treasury Note 2.375% 6/29/23 5/15/27 2,000,000 1,869,531 1,884,060 - 21,640 1,905,700 - - 10,068 4.22% Home Loan Bank 4.625% 7/18/24 6/11/27 2,000,000 2,018,360 - 2,018,360 4,040 2,022,400 - - 19,785 4.28% Fed Farm Credit Bank 4.125% 2/28/23 8/23/27 2,000,000 1,983,540 1,975,020 - 20,700 1,995,720 - - 36,208 4.33% Corporate Note - Apple Inc. 3.000% 6/29/23 11/13/27 1,000,000 945,670 947,470 - 11,020 958,490 - - 6,500 4.38% Treasury Note 3.500% 11/22/23 1/31/28 2,000,000 1,922,188 1,937,580 - 24,060 1,961,640 35,000 35,000 190 4.53% Treasury Note 4.625% 5/30/24 9/30/28 2,000,000 1,994,375 2,017,960 - 25,800 2,043,760 - - 31,086 4.70% Treasury Note 4.875% 3/22/24 10/31/28 2,000,000 2,043,594 2,038,280 - 26,100 2,064,380 - - 24,640 4.35% Treasury Note 4.375% 3/22/24 11/30/28 2,000,000 2,003,906 2,000,700 - 26,640 2,027,340 - - 14,822 4.33% Treasury Note 3.750% 3/22/24 12/31/28 2,000,000 1,950,469 1,949,920 - 27,500 1,977,420 37,500 37,500 6,522 4.33% Treasury Note 4.000% 3/22/24 1/31/29 2,000,000 1,972,578 1,970,400 - 27,800 1,998,200 40,000 40,000 217 4.32% Treasury Note 5.250% 5/21/24 2/15/29 2,000,000 2,072,813 2,079,300 - 28,440 2,107,740 - - 48,462 4.39% Treasury Note 4.125% 6/27/24 3/31/29 2,000,000 1,985,469 1,980,780 - 28,280 2,009,060 - - 27,725 4.29% Home Loan Bank 4.625% 7/18/24 6/8/29 2,000,000 2,041,960 - 2,041,960 8,220 2,050,180 - - 22,611 4.14% - - - - - - - - - -
Total U.S. Securities 97,968,000 97,401,895 98,351,854 (1,939,680) 657,656 97,069,830 298,410 298,410 584,012 3.70% Grand Total - LAIF & U.S. Securities 237,868,000 237,301,895 246,351,854 2,679,124 (12,061,148) 236,969,830 2,017,214 2,017,214 1,146,127 4.17% At 7/31/2024, the City's average earnings rate on all investments listed above was 4.17%, LAIF earnings rate was 4.52%, while 3.70% 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 236,969,830$ Security Type Par Purchase Price (1) Gain / (Loss) Net = (1) + (2) Total Accrued Interest 1,146,127 Treasury Note 2,000,000 2,089,219 (89,219) 15,781 238,115,957$ Fannie Mae 2,000,000 2,103,840 (103,840) 18,660 Treasury Note 2,000,000 2,085,313 (85,313) 19,687 Fiscal Year Received
(2) Total Interest Earned
105,000
Accrued
Interest
Securities Interest
105,000
122,500
FY 2024/25 Interest Prior to 7/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 @ July 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,412,833 494,192
2,229,373
1,039,032
3,136,767
503,150
2,711
7,608
Bank of New York Mellon Tax-Exempt MMKT* 122 - -
122
-
-
-
-
Total Investments per Bank & General Ledger
7,412,955 494,192
2,229,373
1,039,154
3,136,767
503,150
2,711
7,608
*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
July 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