City of Cotati
Summary of Fiscal Resilience Enterprise Fund Factors
As of:
General Fund:
Cash*
Budget Operating
Expenses Cash Coverage Goal
A. Cash Coverage Ratio = $ 5,197,399 $ 9,170,755 56.67% > 25% Cash* Current Liabilities** Quick Ratio Goal
B. Liquidity Ratio = $ 5,197,399 $ 389,506 13.34 > 2.00 Twelve Month
Rolling Revenues To
6/30/2024
Twelve Month
Rolling Budget
Revenues
Revenues to
Budget Goal
C.1 Rolling Twelve Months Revenue to Budget = $ 11,216,926 $ 10,946,693 2% > - 10% Fiscal Year Total
Revenues To
6/30/2024
Prior Fiscal Year
Revenues *
6/30/2023
Revenues to Prior
Year
C.2 Current Fiscal Year Revenue to Prior Fiscal Year = $ 11,216,926 $ 10,863,553 3% D. Increase in Expenditures
Fiscal Year
Operating
Expenditures
6/30/2024
Budget Expenditures
(12 Months)
Expenditures to
Budget Goal
Operating Expenditures Compared to Budget $ 8,829,037 $ 9,190,755 -4% < 10% Fiscal Year
Operating
Expenditures
6/30/2024
Prior Fiscal Year
Expenditures
06/30/2023
Expenditures to
Prior Year
Operating Expenditures Compared to Prior Year $ 8,829,037 $ 7,975,143 11% E. Significant Revenue Sources Changes
Current Fiscal Year
6/30/2024
Prior Fiscal Year
6/30/2023 % Change Goal
Bradley Burns $ 2,857,805 $ 2,916,524 -2.0% > - 10%
Measure S $ 3,070,593 $ 3,100,971 -1.0%
Combined Sales Tax $ 5,928,398 $ 6,017,495 -1.5%
Property Tax $ 2,083,756 $ 1,967,056 5.9%
Current Fiscal Year
6/30/2024
Budget
(12 Months) % Change Goal
Bradley Burns* $ 2,857,805 $ 2,871,000 -0.5% > - 10%
Measure S* $ 3,070,593 $ 3,115,000 -1.4%
Combined Sales Tax* $ 5,928,398 $ 5,986,000 -1.0%
Property Tax $ 2,083,756 $ 2,060,765 1.1%
Sunday, June 30, 2024
* - Sales Tax - 11 of the 12 monthly payments have been received to date as they are received two months after the collection period they represent. An estimated payment was included within the analysis above and will be accrued for the fiscal year end.
City of Cotati
Summary of Fiscal Resilience Enterprise Fund Factors
As of:
General Fund:
Sunday, June 30, 2024
F. Community Event Identification: None Noted
Fiscal Year Total
Revenues To
6/30/2024
Fiscal Year
Operating
Expenditures
6/30/2024
Current Year
Revenues to
Expenses Goal
G. Current Fiscal Year Revenues to Operating Expenditures $ 11,216,926 $ 8,829,037 127% > 110% Prior Fiscal Year
Revenues
6/30/2023
Prior Fiscal Year
Expenditures
06/30/2023
Prior Year
Revenues to
Expenses
Prior year Revenues to Operating Expenditures $ 10,863,553 $ 7,975,143 136% Ref:
* Cash incudes the pooled cash attributable to the evaluated fund which consists of all liquid available cash and investments held including CD's and Treasury notes. ** Current Liabilities are the total of all liabilities for the evaluated fund, as of the reporting date, that are due and payable within one year.
Due to timing of major revenue sources, mentioned in D above, it is consistent that the coverage for revenues would be lower through this period to date. This will continue to be monitored for risk.
Though no indicator was noted, this will continue to be monitored.
City of Cotati
Summary of Fiscal Resilience Enterprise Fund Factors
As of:
Water Enterprise Fund
Cash*
Budget Operating
Expenses Cash Coverage Goal
A. Cash Coverage Ratio = $ 3,922,197 $ 2,010,178 195.12% > 33% Cash* Current Liabilities** Quick Ratio Goal
B. Liquidity Ratio: = $ 3,922,197 $ 84,420 46.46 > 2.0
Twelve Month
Rolling Revenues To
6/30/2024
Twelve Month
Rolling Budget
Revenues Revenues to Budget Goal
C.1 Rolling Twelve Months Revenue to Budget = $ 2,396,442 $ 2,340,724 2% > - 10% Fiscal Year Total
Revenues To
6/30/2024
Prior Fiscal Year
Revenues
6/30/2023
Revenues to Prior
Year
C.2 Current Fiscal Year Revenue to Prior Fiscal Year = $ 2,396,442 $ 2,149,043 12% D. Increase in Expenditures Fiscal Year
Operating
Expenditures
6/30/2024
Budget
Expenditures
(12 Months)
Expenditures to
Budget Goal
Operating Expenditures Compared to Budget $ 2,010,178 $ 1,975,191 2% < 10% Fiscal Year
Operating
Expenditures
6/30/2024
Prior Fiscal Year
Expenditures
06/30/2023
Expenditures to
Prior Year
Operating Expenditures Compared to Prior Year $ 2,010,178 $ 1,971,247 2% E. Supporting Agency Change In Rates
1-Jul-24 Goal
Budgeted Rate Agency Rate Difference < 2%
Sonoma County Water Agency (65% of supply) 6.00% 9.98% 3.9800% F.
Fiscal Year Total
Revenues To
6/30/2024
Fiscal Year
Operating
Expenditures
6/30/2024
Revenues to
Expenses Goal
Operating Revenues to Operating Expenditures $ 2,396,442 $ 2,010,178 119% > 110% Prior Fiscal Year
Revenues
6/30/2023
Prior Fiscal Year
Expenditures
06/30/2023
Prior Year Revenues
to Expenses
Prior Year Revenues to Operating Expenditures $ 2,149,043 $ 1,971,247 109% Sunday, June 30, 2024
* Cash incudes the pooled cash attributable to the evaluated fund which consists of all liquid available cash and investments held including CD's and Treasury notes. ** Current Liabilities are the total of all liabilities for the evaluated fund, as of the reporting date, that are due and payable within one year.
City of Cotati
Summary of Fiscal Resilience General Fund Factors
As of:
Sewer Enterprise Funds
Cash*
Budget Operating
Expenses Cash Coverage Goal
A. Cash Coverage Ratio = $ 3,228,970 $ 3,583,714 90.10% > 33% B. Cash* Current Liabilities** Quick Ratio Goal
Liquidity Ratio: = $ 3,228,970 $ 48,608 66.43 > 2.0
C.1 Twelve Month
Rolling Revenues To
6/30/2024
Twelve Month
Rolling Budget
Revenues Revenues to Budget Goal
Rolling Twelve Months Revenue to Budget = $ 3,505,418 $ 3,605,010 -3% > - 10% C.2 Fiscal Year Total
Revenues To
6/30/2024
Prior Fiscal Year
Revenues
6/30/2023
Revenues to Prior
Year
Current Fiscal Year Revenue to Prior Fiscal Year = $ 3,505,418 $ 2,986,863 17% D. Increase in Expenditures Fiscal Year
Operating
Expenditures
6/30/2024
Budget
Expenditures
(12 Months)
Expenditures to
Budget Goal
Operating Expenditures Compared to Budget $ 3,411,775 $ 3,583,714 -5% < 10% Fiscal Year
Operating
Expenditures
6/30/2024
Prior Fiscal Year
Expenditures
06/30/2023
Expenditures to
Prior Year
Operating Expenditures Compared to Prior Year $ 3,411,775 $ 3,416,391 0% E. Supporting Agency Change In Rates
1-Jul-24 Goal
Budgeted Rate Agency Rate Difference < 2%
Santa Rosa Wastewater Treatment 9.00% 6.38% -2.6200%
F.
Total Revenues To
6/30/2024
Operating
Expenditures
6/30/2024
Revenues to
Expenses Goal
Operating Revenues to Operating Expenditures $ 3,505,418 $ 3,411,775 103% > 110% Prior Fiscal Year
Revenues
6/30/2023
Prior Fiscal Year
Expenditures
06/30/2023
Prior Year Revenues
to Expenses
Prior Year Revenues to Operating Expenditures $ 2,986,863 $ 3,416,391 87% Note:
Sunday, June 30, 2024
* Cash incudes the pooled cash attributable to the evaluated fund which consists of all liquid available cash and investments held including CD's and Treasury notes. ** Current Liabilities are the total of all liabilities for the evaluated fund, as of the reporting date, that are due and payable within one year.
This item is improving over prior year and aligned with the utility rate study. Revenues have improved in part due to the move to monthly billing which more closely ties to the cost of services rendered. This will continue to be monitored for increased risk.