City of Camarillo
Reserve Analysis - Current
Fiscal Year 2023/24
"Exhibit D"
Reserve
Basis
Projected
6/30/24
Fund
Balance (1)
Expend. &
Transfers *
Reserve Policy
Requirement
Other
Committed
Fund Balance
Projected
6/30/24
Unassigned
Fund Balance
Available
Fund
Balance %
50% 101 General Fund 83,141,268 $ 55,092,040 $ 27,546,020 $ $40,985,000 14,610,248 $ 18% 20% 221 Zone 1-Mission Oaks MD-1A 1,170,049 1,334,964 266,993 903,056 77% 20% 222 Zone 2-Wittenberg Maint. Dist. 87,418 43,060 8,612 78,806 90% 20% 223 Zone 3-Armitos Storm Basins MD 77 5,658 1,132 (1,055) -1372% 20% 224 Zone 4-Mission Oaks Industrial MD 57,661 56,262 11,252 46,409 80% 20% 225 Zone 5-Presley Maint. Dist. 25,163 23,596 4,719 20,444 81% 20% 226 Zone 6-Spanish Hills Maint. Dist. 35,079 23,934 4,787 30,292 86% 20% 227 Zone 7-Sares/Regis Maint. Dist. 14,141 10,570 2,114 12,027 85% 20% 228 Zone 8-Vista Las Posas Maint. Dist. 31,867 42,604 8,521 23,346 73% 20% 230 Zone 10-Adolfo Glen III Maint. Dist. 57,325 34,388 6,878 50,447 88% 20% 231 Zone 9-Adolfo Glen II Maint. Dist. 64,389 45,616 9,123 55,266 86% (1) The working capital measurement is used for Internal Service Funds (5xx) and Enterprise Funds (8xx) (2) General Fund Commitments of Fund Balance
$5,400,000 Economic Development
$10,000,000 Natural Disaster Recovery
$200,000 Camarillo Springs Debris Barrier Remediation Maintenance $8,000,000 Pleasant Valley Rec. & Park District - Community and Senior Center $9,021,000 Capital Improvement Projects
$4,550,000 Building and Grounds Capital Projects
$3,814,000 Conti nuum of Care
$40,985,000 Total
* Expenditures and transfers exclude capital projects and depreciation, and include principal payments on debt Reserve
Basis
Projected
6/30/24
Fund
Balance (1)
Expend. &
Transfers *
Reserve Policy
Requirement
Other
Committed
Fund Balance
Projected
6/30/24
Unassigned
Fund Balance
Available
Fund
Balance %
510 Risk Management 1,038,216 $ 2,584,168 $ 271,250 $ 141,508 $ 625,458 $ 60%
100% of accumulated depreciation:
530 Information Services 2,364,174 4,188,110 1,297,596 1,066,578 45% 120% of accumulated depreciation:
540 Vehicles & Equipment 5,664,327 3,645,415 4,828,880 835,447 15% 550 City Hall Facility 5,396,276 2,016,126 754,497 4,641,779 86% 551 Corporation Yard Facility 2,087,484 727,196 673,494 1,413,990 68% 552 Police Facility 1,985,154 408,065 809,296 1,175,858 59% 553 Library Facility 1,851,370 1,287,568 1,342,306 509,064 27% 555 Camarillo Chamber of Commerce Facility 140,813 4,250 74,455 66,358 47% (1) The working capital measurement is used for Internal Service Funds (5xx) and Enterprise Funds (8xx) * Expenditures and transfers exclude capital projects and depreciation, and include principal payments on debt ** (RC) Replacement Cost
*** Funds are available in the Wastewater Capital Fund
Fund
General Fund: Minimum of 50% of the operating expenditures plus transfers to other funds for operations:
Zone 2-10 Funds: Minimum of 20% of the operating expenditures:
Fund
Three times the self-insured retention for liability claims ($30,000 * 3), + 100% greatest deductible for single property damage coverage ($100,000), + 25% annual appropriation for workers' compensation expense:
100% of the reserve study capital replacement plan
components:
1 of 2
City of Camarillo
Reserve Analysis - Current
Fiscal Year 2023/24
"Exhibit D"
Reserve
Basis
Projected
6/30/24
Fund
Balance
Expend. &
Transfers *
Reserve Policy
Requirement
Other
Committed
Fund Balance
Projected
6/30/24
Unassigned
Fund Balance
Available
Fund
Balance %
Solid Waste
805 Operations 5% 249,880$ 5,479,577$ 273,979 $ (24,099) $ -10% Water Utility
860 Operations 25% of O&M 22,079,251 5,519,813 Rate Stabilization 5% Commodity Sales 468,750
Capital Annual Depreciation (RC)** 552,197
Restricted/Emergency 1% Assets (RC) 3,900,000
Operating Fund 1,181,405 10,440,760 (9,259,355) -784% Wastewater Utility
871 Operations 25% of O&M 20,512,410 5,128,103 Capital Annual Depreciation (RC) 2,700,000
Restricted/Emergency 1% Assets (RC) 2,000,000
Debt Service 1 Year Debt Service 1,305,994
Operating Fund 28,864,577 11,134,097 17,730,480 61% (1) The working capital measurement is used for Internal Service Funds (5xx) and Enterprise Funds (8xx) * Expenditures and transfers exclude capital projects and depreciation, and include principal payments on debt ** (RC) Replacement Cost
*** Funds are available in the Wastewater Capital Fund
(2) The Camarillo Ranch Facility activities have been transferred to the Camarillo Ranch Enterprise Fund.
Fund
2 of 2