Purchase Market Totals
Investment Summary: $ % Price (G/L) Per Trustee % Yield LAIF Accounts 138,600,000$ 58.24% 138,600,000$ 138,600,000$ 3.93% Securities:
U. S. T-Notes & Bills 61,000,000 25.64% 60,892,555 59,849,490 Agencies 28,633,000 12.03% 28,695,104 28,126,838
Certificates of Deposits 735,000 0.31% 732,918 715,750 Commerical Paper 1,000,000 0.42% 977,255 983,378
Corporate Notes 8,000,000 3.36% 7,787,570 7,714,890
Subtotal Securities 99,368,000 41.76% 99,085,402 97,390,346 2.40% Subtotal LAIF Accounts & Securities 237,968,000$ 100.00% 237,685,402 235 ,990,346 3.50% Accrued Interest 1,988,246
Total Market Value 237,978,592
Total Bond Account Balances 4,371,706 4,371,706
Total Investments 242,057,108$ 242,350,298$
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 December 2023 for settlement in January 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
December 31, 2023
Compliance Report and Attestations
At Par
1 year or less
80.37%
+1-2 years
9.77% - $23.25m
+2-3 years
6.50% - $15.48m
+3-4 years
3.36% - $8.00m
+
4-5 years
0.00% - $0.00m
Oth
er
19.63%
INVESTMENT MATURITY SCHEDULE
Investments have a maturity of five years or less
$191,245,000
$46,723,000
Notes & Bills
25.64% - $61,000,000
LAIF - 58.24%
$138,600,000
Fed. Home Loan Bank
2.52% - $6.00m
Fed. Home Loan MC
1.68% - $4.00m
Fed. Farm Credit
6.15% - $14.63m
Fannie Mae
1.68% - $4.00m
Corporate Note
3.36% - $8.00m
Commerical Paper
0.42% - $1.00m
Certificate of Deposit
0.31% - $735k
Investment by Type
01 / 10 / 2024
01 / 10 / 2024
Doc ID: 655c366d8de9668b68c1146e9dd684baef26ecde
Market Value Per LAIF
Purchase Balance Balance
Investment Balance Price 11/30/2023 Deposits Withdrawals 12/31/2023 Month Y-T-D Yield Total LAIF 138,600,000 138,600,000 127,500,000 13,500,000 (2,400,000) 138,600,000 - 2,573,890 1,306,565 3.93% Maturity or Market Value Per Trustee
Interest Purchase Call Purchase Balance Purchases Market Incr. Balance Investment Rate Date Date Par Value Price 11/30/2023 (Maturities) or (Decr) 12/31/2023 Month Y-T-D Yie ld U.S. Securities
Home Loan MC 0.250% 12/10/20 12/4/23 1,999,140 (2,000,000) 860 - 2,500 2,500 - 0.26% Fed Farm Credit Bank 0.680% 1/19/22 12/20/23 1,995,100 (2,000,000) 4,900 - 6,800 6,800 - 0.92% Treasury Note 0.125% 8/12/21 1/15/24 2,000,000 1,989,688 1,987,240 - 9,080 1,996,320 - 1,250 1,155 0.34% Fed Farm Credit Bank 0.230% 2/12/21 1/19/24 1,500,000 1,501,065 1,489,680 - 6,720 1,496,400 - 1,725 1,553 2.00% Treasury Note 0.125% 9/30/21 2/15/24 2,000,000 1,987,734 1,978,760 - 8,820 1,987,580 - 1,250 944 0.39% Fed Farm Credit Bank 0.250% 3/10/21 2/26/24 2,000,000 1,994,960 1,975,540 - 9,040 1,984,580 - 2,500 1,736 0.34% Treasury Note 0.000% 9/27/23 3/7/24 10,000,000 9,761,883 9,859,600 - 46,400 9,906,000 - - 141,107 5.51% Treasury Note 2.125% 4/13/21 3/31/24 2,000,000 2,103,672 1,979,380 - 4,680 1,984,060 - 21,250 10,799 0.37% Commercial Paper - MUFG 0.000% 11/22/23 4/17/24 1,000,000 977,256 978,469 - 4,909 983,378 - - 6,189 5.70% Fed Farm Credit Bank 2.440% 5/4/22 4/18/24 900,000 894,582 890,208 - 2,340 892,548 - 10,980 4,453 2.76% Treasury Note 2.250% 3/10/21 4/30/24 2,000,000 2,116,641 1,974,380 - 5,620 1,980,000 - 22,500 7,665 0.38% Treasury Note 0.000% 11/21/23 5/2/24 10,000,000 9,765,008 9,780,600 - 46,100 9,826,700 - - 59,108 5.40% Treasury Note 2.000% 3/30/21 5/31/24 2,000,000 2,104,219 1,967,040 - 6,320 1,973,360 - 20,000 3,497 0.35% Treasury Note 1.750% 3/30/21 6/30/24 2,000,000 2,089,219 1,959,540 - 7,100 1,966,640 - - 96 0.37% Fannie Mae 1.750% 12/10/20 7/2/24 2,000,000 2,103,840 1,959,120 - 7,520 1,966,640 - 17,500 17,403 0.28% Treasury Note 1.750% 4/13/21 7/31/24 2,000,000 2,085,313 1,953,760 - 8,500 1,962,260 - 17,500 14,647 0.45% Fed Farm Credit Bank 3.300% 8/16/22 8/15/24 1,000,000 1,000,880 983,640 - 5,420 989,060 - 16,500 12,467 3.25% Treasury Note 1.250% 2/26/21 8/31/24 2,000,000 2,060,859 1,941,020 - 10,000 1,951,020 - 12,500 8,448 0.38% Home Loan Bank 2.875% 11/19/20 9/13/24 2,000,000 2,191,020 1,962,860 - 9,080 1,971,940 - 28,750 17,250 0.35% Treasury Note 1.500% 1/20/21 10/31/24 2,000,000 2,089,609 1,934,060 - 11,720 1,945,780 - 15,000 5,110 0.31% City of Camarillo
LAIF Interest
Report on the Local Agency Investment Fund & U.S. Government Securities December 31, 2023
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: 655c366d8de9668b68c1146e9dd684baef26ecde
Maturity or Market Value Per Trustee
Interest Purchase Call Purchase Balance Purchases Market Incr. Balance Investment Rate Date Date Par Value Price 11/30/2023 (Maturities) or (Decr) 12/31/2023 Month Y-T-D Yield Continued - U.S. Securities
Certificate of Deposit 0.400% 11/18/20 11/20/24 245,000 244,633 232,551 - 1,537 234,089 - 494 113 0.44% Treasury Note 1.500% 2/26/21 11/30/24 2,000,000 2,080,234 1,928,520 - 11,320 1,939,840 - 15,000 2,623 0.42% Treasury Note 1.750% 1/20/21 12/31/24 2,000,000 2,111,328 1,928,760 - 12,340 1,941,100 - - 96 0.33% Fannie Mae 1.625% 12/29/20 1/7/25 2,000,000 2,104,780 1,926,040 - 12,220 1,938,260 - 16,250 15,708 0.31% Home Loan MC 1.500% 12/29/20 2/12/25 1,293,000 1,354,353 1,247,870 - 7,332 1,255,202 - 9,750 7,529 0.34% Home Loan MC 1.500% 12/29/20 2/12/25 707,000 740,278 671,930 - 3,948 675,878 - 5,250 4,054 0.35% Treasury Note 0.500% 2/12/21 3/31/25 1,500,000 1,510,371 1,413,285 - 13,185 1,426,470 - 3,750 1,906 0.33% Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,610 970,790 - 7,620 978,410 - 15,000 6,500 3.16% Corporate Note - Amazon.com Inc. 3.000% 5/4/22 4/13/25 1,000,000 995,970 970,790 - 7,620 978,410 - 15,000 6,500 3.14% Treasury Note 0.375% 2/12/21 4/30/25 1,500,000 1,501,934 1,406,550 - 13,170 1,419,720 - 2,813 958 0.34% Treasury Note 0.250% 9/30/21 5/31/25 2,000,000 1,964,219 1,866,320 - 17,500 1,883,820 - 2,500 437 0.75% Treasury Note 2.875% 9/28/23 6/15/25 2,000,000 1,924,297 1,940,400 - 14,600 1,955,000 28,750 28,750 2,671 5.21% Treasury Note 3.000% 12/21/22 7/15/25 2,000,000 1,945,547 1,942,340 - 14,300 1,956,640 - 30,000 27,717 4.13% Treasury Note 3.125% 12/21/22 8/15/25 2,000,000 1,951,172 1,944,540 - 15,920 1,960,460 - 31,250 23,607 4.11% Corporate Note - Walmart 3.900% 9/29/22 9/9/25 1,000,000 982,170 984,170 - 6,090 990,260 - 19,500 12,133 4.55% Certificate of Deposit 4.300% 9/29/22 9/29/25 245,000 244,265 240,009 - 2,463 242,473 - 5,311 2,742 4.41% Treasury Note 4.250% 9/28/23 10/15/25 2,000,000 1,967,813 1,981,640 - 15,000 1,996,640 - 42,500 18,115 5.09% Corporate Note - Microsoft 3.125% 3/17/22 11/3/25 1,000,000 1,024,730 969,150 - 7,230 976,380 - 15,625 5,035 2.36% Home Loan Bank 4.500% 2/7/23 12/12/25 2,000,000 2,035,620 1,989,400 - 15,600 2,005,000 45,000 45,000 4,750 3.83% Fed Farm Credit Bank 4.000% 2/7/23 1/13/26 1,233,000 1,239,325 1,214,949 - 9,321 1,224,270 - 24,660 23,016 3.81% Fed Farm Credit Bank 4.375% 2/28/23 2/23/26 2,000,000 1,987,560 1,988,600 - 18,420 2,007,020 - 43,750 31,111 4.60% Home Loan Bank 0.960% 5/4/22 3/5/26 2,000,000 1,843,900 1,836,400 - 23,220 1,859,620 - 9,600 6,187 3.14% Corporate Note - Berkshire Hathaway 3.125% 3/17/22 3/15/26 1,000,000 1,018,170 965,960 - 6,240 972,200 - 15,625 9,201 2.61% Corporate Note - Proctor & Gamble 1.000% 12/21/22 4/23/26 1,000,000 898,650 918,180 - 10,640 928,820 - 5,000 1,889 4.29% Fed Farm Credit Bank 4.375% 6/29/23 6/23/26 2,000,000 1,998,760 1,991,780 - 17,580 2,009,360 43,750 43,750 1,944 4.40% Treasury Note 4.500% 11/22/23 7/15/26 2,000,000 1,990,078 1,998,440 - 20,860 2,019,300 - - 41,576 4.70% Fed Farm Credit Bank 4.750% 9/28/23 9/1/26 2,000,000 1,988,240 2,009,440 - 21,380 2,030,820 - - 31,667 4.97% Certificate of Deposit 4.250% 9/30/22 9/30/26 245,000 244,020 238,826 - 362 239,188 - 5,249 2,653 4.36% Home Loan MC 0.800% 9/29/22 10/27/26 2,000,000 1,732,400 1,791,060 - 23,020 1,814,080 - 8,000 2,844 4.42% Corporate Bond - VISA Inc. 1.900% 2/7/22 4/15/27 1,000,000 926,600 915,690 - 14,120 929,810 - 9,500 4,011 3.81% Treasury Note 2.375% 6/29/23 5/15/27 2,000,000 1,869,531 1,869,840 - 30,940 1,900,780 - 23,750 6,133 4.22% Fed Farm Credit Bank 4.125% 2/28/23 8/23/27 2,000,000 1,983,540 1,973,580 - 32,580 2,006,160 - 41,250 29,333 4.33% Corporate Note - Apple Inc. 3.000% 6/29/23 11/13/27 1,000,000 945,670 944,810 - 15,790 960,600 - 15,000 4,000 4.38% Treasury Note 3.500% 11/22/23 1/31/28 2,000,000 1,922,188 1,934,460 - 35,540 1,970,000 - - 29,293 4.53% - - - - - - - 12,500 - - Total U.S. Securities 99,368,000 99,085,402 100,696,208 (4,000,000) 694,138 97,390,346 126,800 759,882 681,681 2.40% Grand Total - LAIF & U.S. Securities 237,968,000 237,685,402 228,196,208 9,500,000 (1,705,862) 235,990,346 126,800 3,333,772 1,988,246 3.50% At 12/31/2023, the City's average earnings rate on all investments listed above was 3.50%, LAIF earnings rate was 3.93%, while 2.40% 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 235,990,346 $ Home Loan MC 2,000,000 1,999,500 500 15,500 Total Accrued Interest 1,988,246 Fed Farm Credit Bank 2,000,000 1,990,880 9,120 36,320 237,978,592 $ Accrued
Interest
Securities Interest
FY 2023/24 Interest Prior to 12/2023 for Matured/Called Securities Fiscal Year Received
(2) Total Interest Earned
15,000
27,200
Doc ID: 655c366d8de9668b68c1146e9dd684baef26ecde
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 @ December 31, 2023 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,310,406 70,578 1,276,337 593,854 1,859,918 501,800 526 7,393 Bank of New York Mellon Tax-Exempt MMKT* 61,300 - - 61,300 - - - - Total Investments per Bank & General Ledger 4,371,706 70,578 1,276,337 655,154 1,859,918 501,800 526 7,393 *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
December 31, 2023
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: 655c366d8de9668b68c1146e9dd684baef26ecde