Maturity or Market Value Per Trustee Securities Interest Interest Purchase Call Purchase Balance Purchases Market Incr. Balance Fiscal Year Received Accrued Investment Rate Date Date Par Value Price 11/30/2024 (Maturities) or (Decr) 12/31/2024 Month Y-T-D Interest Yield Continued - U.S. Securities
Home Loan Bank 0.960% 5/4/22 3/5/26 2,000,000 1,843,900 1,918,440 6,460 1,924,900 9,600 6,187 3.14% Corporate Note - Berkshire Hathaway 3.125% 3/17/22 3/15/26 1,000,000 1,018,170 983,750 910 984,660 15.625 9,201 2.61% Corporate Note - Proctor & Gamble 1.000% 12/21/22 4/23/26 1,000,000 898,650 958,060 510฿ 958,570 5,000 1,889 4.29% Treasury Note 3.625% 9/19/24 5/15/26 2,000,000 1,997,266 1,982,260 1,180 1,983,440 36,250 9,413 3.71% Fed Farm Credit Bank 4.375% 6/29/23 6/23/26 2,000,000 1,998.760 2,002,780 (80) 2,002,700 43,750 1,944 4.40% Treasury Note 4.500% 11/22/23 7/15/26 2,000,000 1.990,078 2.007.900 (780) 2,007,120 45.000 41,576 4.70% Treasury Note 4.375% 9/19/24 8/15/26 2,000,000 2,027,109 2,004,840 (1,240) 2,003,600 33,050 3.63% Fed Farm Credit Bank 4.750% 9/28/23 9/1/26 2,000,000 1,988,240 2,016,620 (1,220) 2,015,400 47,500 31,667 4.97% Certificate of Deposit 4.250% 9/30/22 9/30/26 245,000 244.020 245.491 347 245,838 5,249 2,653 4.36% Home Loan MC 0.800% 9/29/22 10/27/26 2,000,000 1,732,400 1,871,560 5,140 1.876.700 8,000 2,844 4.42% Corporate Bond - VISA Inc. 1.900% 2/7/22 4/15/27 1,000,000 926,600 945,510 (120) 945,390 9,500 4,011 3.81% Treasury Note 2.375% 6/29/23 5/15/27 2,000,000 1,869,531 1.917.960 (2,800) 1.915,160 23,750 6,167 4.22% Home Loan Bank 4.625% 7/18/24 6/11/27 2,000,000 2,018,360 2,023,040 (7,300) 2,015,740 53,188 5,139 4.28% Fed Farm Credit Bank 4.125% 2/28/23 8/23/27 2,000,000 1,983,540 1,995,940 (6,180) 1,989,760 41,250 29,333 4.33% Corporate Note - Apple Inc. 3.000% 6/29/23 11/13/27 1,000,000 945,670 967,240 (1,790) 965.450 15,000 4,000 4.38% Treasury Note 3.500% 11/22/23 1/31/28 2,000,000 1.922,188 1.963,200 (9,300) 1,953,900 35.000 29,293 4.53% Treasury Note 4.625% 5/30/24 9/30/28 2,000,000 1,994,375 2,035,160 (16,720) 2,018,440 23.633 4.70% Treasury Note 4.875% 3/22/24 10/31/28 2,000,000 2,043,594 2,053,900 (18,200) 2,035,700 16,699 4.35% Treasury Note 4.375% 3/22/24 11/30/28 2,000,000 2,003,906 2.018.900 (18,360) 2,000,540 7,692 4.33%
3.750% 3/22/24 12/31/28 2,000,000 1,950,469 1.972,580 (17,740) 1,954,840 207 4.33%
4.000% 3/22/24 1/31/29 2,000,000 1,972,578 1,991,100 (18,760) 1,972,340 33,478 4.32%
5.250% 5/21/24 2/15/29 2,000,000 2,072,813 2,095,000 (22,180) 2,072,820 39,660 4.39%
4.125% 6/27/24 3/31/29 2,000,000 1,985,469 2,000,780 (20,700) 1,980,080 4.29% 6/8/29 2,000,000 2,041,960 2,96,080 : (20,340) 2,017,780 4.14%
3.500% 9/10/29 2,000,000 1,999,260 (22,460) 1,923,620 3.51% 70,723,000 69,938,919 85,243,663 (15,000,000) (131,397) 70,112,206 342,181 582,971 3.69% Grand Total - LAIF & U.S. Securities 238,823,000 238,038,919| 237,443,663 5,400,000 (4,631,397) 238,212,266 342,181 4,811,199 2,306,006 4.20% t 12/31/2024, the City's average earnings rate on all investments listed above was 4.20%, LAIF earnings rate was 4.43%, while 3.69% was the average purchase price yield to maturity on securities on ote: U.S. Security market values are provided by Bank of New York Mello Total Market Value:
Table 1: Securities Matured Total US Securities $238.212,266 Security Type Par Purchas price I ain 3455) (2) Total Interest Earned Net = (1) + (2) Total Accrued Interest 2,306,006 Treasury Note 2,000,000 S240.518.272
Treasury Note 10,000,000 9,902,567
mmercial Paper - Toyota Motor Co 1,000,000 970,997
casury No 2,000,000 2,111,328 111,328
City of Camarillo
Investment Report of Bond Account Balances
December 31, 2024
Assessment District Successor Agency Lease Revenue Revenue Revenue 2016 SA (C.D.C.) 2016 SA (C.D.C.) 2012 PFA Library 2019 PFA Water Mello-Roos Bonds 2014 SA (C.D.C.) Refunding Bonds, Refunding Bonds, 2015 Camsan FD#1 2017 Bond Refunding Bonds Bonds Wastewater Bonds Bonds Description Series A & A-T Series B
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, 2024 3,392,525 10,565,000 7,205,000 25,765,000 3,685,000 12,600,000 387,160 670,000 305,000 755,000 355,000 840,000
09/01/25 09/01/25 09/01/25 09/01/25 12/01/25 06/01/25 :
Next Two Interest Payments Due
1st Installment Amount 41,558 263,588 144,772 539,800 70,131 232,997 Ist Installment Due 03/01/25 3/01/25 03/01/25 03/01/25 6/01/25 06/01/25 :
nd Installment Amour 41,558 263,588 144,772 539,800 70,131 211,997 :
nd Installment Di 09/01/25 09/01/25 09/01/25 09/01/25 12/01/25 12/01/25 Type of Investment Total
U.S. Bank 4,372,970 66,071 1,343,660 594,667 1.859.017 501,320 477 7,758 Bank of New York Mellon Tax-Exempt MMKT* 122 122
Total Investments per Bank & General Ledger 4,373,092 66.071 1,343,660 594,789 1.859.017 501,320 477 7,758 *Unspent bond proceeds from the refunded 2006 Tax-Exempt Housing bond as well as investment earnings.
City of Camarillo
Chronological Investment Activity Report - At Par
For the Month Ended December 31, 2024
(Bond Proceeds Accounts Excluded)
LAIF LAIF LAIF LAIF Bank of NY Mellon Investment
Date Description City Camsan CCI Corp. Subtotal Securities (at Par) Total November 30 Beginning Balance 54,500,000 $ 49,600,000 $ 48,100,000 $ 152,200,000 $ 85,723,000 $ 237,923,000 December 2 Matured Security (2,000,000) (2,000,000)
December Matured Security : (10,000,000) (10,000,000)
December 3 LAIF Wire 500,000 500,000 500,000
December 4 Matured Security : (1,00000) (1,000,000)
December 4 LAIF Wire 5,000.000 5,000,000 5,000,000
December 5 LAIF Wire 5,000,000 - 5,000,000 5,000,000
1,900,000
December 9 LAIF Wire 1,900,000 1,900,000
December 12 LAIF Wire (300,000) (300,000) (300,000)
-
December 16 LAIF Wire (900,000) (900,000) (900,000)
December LAIF Wire : (900,000)
19 (900,000) - (900,000)
December 23 LAIF Wire (2,400,000) (2,400,000) (2,400,000) December 30 LAIF Wire 8,000,000 8,000,000 8,000,000
December 31 Matured Security (2,000,000) (2,000,000)
Subtotal of Incr. / <Decr.> in A/C Balances 6,300,000 (300,000) 9,900,000 15,900,000 (15,000,000) 900,000 December 31 Ending Balance $ 60,800,000 $ 49,300,000 $ 58,000,000 $ 168,100,000 $ 70,723,000 $ 238,823,000
PORTFOLIO SUMMARY
ASSET MANAGEMENT
City of Camarillo Cons Account | Account #285 | As of December 31, 2024 Portfolio Characteristics Account Summary Top Issuers
Beg. Values as of End Values as of LAIF 70.06%
Average Modified Duration 0.53 12/31/2024
12/01/2024
Government of The United States 15.34%
4.08% Market Value 238,614,913.26 239,941,987.19
Average Coupon Farm Credit System 4.65%
Accrued Interest 662,779.36 582,970.92 3.32%
Average Purchase YTM 4.19% Federal Home Loan Banks
Total Market Value 239,277,692.62 240,524,958.10 1.61%
FHLMC
Average Market YTM 4.36% Income Earned 138,633.96 262,372.12 0.83% FNMA
Average Quality Cont/WD 1,763,880.97 557,819.44 Amazon.com, Inc. 0.83% AAA
Par 239,091,904.96 240,546,035.12 Walmart Inc. 0.42%
Average Final Maturity 0.58
Book Value 238,292,715.20 239,761,953.34 Other 2.94%
Average Life 0.54 Cost Value 238,292,715.20 239,761,953.34 Total 100.00% Sector Allocation Maturity Distribution Credit Quality
100%
LAIF 70.06%
76.2%
US Treasury 15.34%
Agency 10.42%
50%
Corporate 3.26%
Cash 0.72%
8.0% 8.3%
4.3% 3.3%
Neg CD 0.20% 0%*
ois 5., AAA 1.1% AA 28.6% BBB 0.1%
NR 70.2%
*See Footnote
Note: There may be a slight difference in the market value between the custodian and investment advisor due to small variances of the independent valuation provided by third party vendors.
The credit quality is a weighted average calculation of the highest of S&P, Moody's and Fitch Execution Time: 01/08/2025 01:57:18 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747 City of Camarillo
General Fund
Comparative Balance Sheet
November 30 and December 31, 2024, and December 31, 2023 - Preliminary Preliminary Preliminary Final Year over Year
November December December Positive Increase
2024 2024 2023 (Negative) (Decrease)
Assets:
Cash and investments 96,506,031 $ 99,472,799 83,922,209 $ 15,550,590 18.53 % Restricted cash 8,087,005 8,087,005.00 7,098,909.00 988,096 13.92 Accounts receivable, net 921,802 969,773.00 772,035.00 197,738 (1) 25.61 Due from other funds 20,780 20.780.00 20,780 (2) 100.00 Prepaid items 1,799,099 1,569,495.00 1,410,990.00 158,505 11.23 Deposits 125,000 125,000.00 125,000.00
Total Assets $ 107,459,717 110,244,852 $ 93,329,143 $ 16,915,709 18.12% Liabilities and Fund Balance:
Liabilities:
Accounts payable 1,575 $ 1,575 $ 411,008 S (409,433) (3) (99.62) % Vages & payroll taxes payabl 275,206 208,265 237,611 (29,346) (12.35) Deposit & deferred revenue 2,607,062 2,607,136 4,617,530 (2,010,394) (4) (43.54) Total Liabilities 2,883,843 2.816,976 5,266,149 (2,449,173) (46.51) Fund Balance:
Nonspendable 1,924,099 1,694,495 1,535,990 158,505 10.32 Restricted 8,278,952 8.278.952 (5) 7,266,836 1,012,116 13.93 Committed 88,036,791 88.036.791 (6) 71,360,064 16,676,727 23.37 Assigned 5,173,779 5,786,930 2,595,784 3,191,146 122.94 Unassigned 1,162,253 3.630.708 5,304,320 (1,673,612) (51.33) Total Fund Balance 104,575,874 107,427,876 88,062,994 19,364,882 71 99 Total Liabilities and Fund Balance S 107.459.717 110.244.852 93,329,143 $ 16,915,709 18.12 % Fund Balance:
Beginning Balance on July 1 $ 109,522,919 109,522,919 $ 91,561,603 $ 17,961,316 19.62 Revenues 12,780,803 19,913,347 20,841,599 (928,252) (7) (4.45) Interfund Transfers-in
Total Revenues & Transfers-in 12,780,803 19,913,347 20,841,599 (928,252) (4.45) Expenditures 17,727,848 22,008,390 24,340,208 2,331,818 (8) (9.58) Interfund Transfers-out
Total Expenditures & Transfers-out 17,727,848 22,008,390 24,340,208 2,331,818 (9.58) Total Fund Balance $ 104,575,874 107,427,876 $ 88,062,994 $ 19,364,882 21.99 % (1) Accounts receivable increase is due to normal fluctuations during the fiscal year. (2) Due from other funds increase is due to a loan to the CDBG fund for the purchase of an affordable housing property. (3) Accounts payable is significantly lower due to the timing of payments. (4) The deposit and deferred revenues has a net decrease of $2m due to ARPA funds being spent in prior fiscal year. (5) The restricted fund balance includes S7.6m PARS Trust balance, $0.5m economic development loans, and $0.2.m CASp fee. , Pursuant to GASB 54, City Council adopted a Resolution committing $88.0m of the General Fund Balance for the fiscal year ending June 30, 2024 as listed in the table below:
GASB 54 Commitment of Fund Balance Authorized Remaining @ 6/30/24 @ 12/31/24
Reserve Level Policy - Council Goal of 50% $31,231,791 $31,231,791 Camarillo Springs Debris Barrier Remediation Maintenance 200,000 200,000 Continuum of Care 3,800,000 3,800,000
Economic Development 5,400,000 5,400,000
Facility Improvement Projects 14,405,000 14,405,000
Loan to Water Utility 15,000,000 15,000,000
Natural Disaster Recovery 10,000,000 10,000,000
Pleasant Valley Recreation & Park District (Senior Center) 8,000,000 8,000,000 Total Commitment $88,036,791 $88,036,791
(7) Year-to-date revenues decreased by $0.9m compared to prior fiscal year, which includes a decrease of S1m in Development Services, offset by increase of $0.1m in Sales Tax.
(8) Year-to-date expenditures decreased by $2.3m primarily due to ISF consolidation of Facilities to the General Fund in the prior fiscal year.