CITY OF COTATI
ENTERPRISE WATER FUNDS
‐ With Rate Adjustment ‐
FY 18/19 FY 19/20 FY 20/21 FY 21/22 FY 21/22 FY 22/23
ACTUALS ACTUALS ACTUALS ADOPTED ESTIMATE PROPOSED
FUND 401 - WATER OPERATING
OPERATING REVENUES
Charges for Services
Sale of Water ‐ Usage 921,62 $ 4 $ 1,056,377 $ 1,181,243 $ 1,180,000 $ 1,105,000 $ 1,165,000 Sale of Water ‐ Fixed 754,289 809,815 865,72 4 800,000 840,000 860,000 Customer Fees 52,390 43,527 45,416 40,080 38,000 29,300 Other Reimbursements* 475 300 110 ‐ 110 122,000 Special Assessment Backflow 2,082 2,481 202 1,000 12,317 10,000 Charges for Services 1,730,861 1,912,500 2,092,695 2,021,080 1,995,427 2,186,300 Other Revenues 483 278 35,257 ‐ 3,000 ‐
Total Operating Revenues 1,731,344 1,912,778 2,127,952 2,021,080 1,998,427 2,186,300 OPERATING EXPENSES
Water Operations
Personnel Services 517,657 686,225 762,892 750,343 1,732,755 687,365 Services and Supplies 486,07 0 510,954 628,818 629,102 590,227 661,080 Purchased Water 454,827 475,192 602,082 517,937 515,00 0 546,000 Total Operating Expenses 1,458,554 1,672,370 1,993,792 1,897,382 2,837,982 1,894,445 NET OPERATING SURPLUS 272,790 240,407 134,160 123,698 (839,555) 291,855 OTHER SOURCES
Grants from Other Agencies ‐ ‐ 194 ‐ ‐ ‐
Loan from General Fund ‐ ‐ ‐ ‐ 989,900
Loan From Sewer ‐ ‐ ‐ ‐ ‐ ‐
Interest Earnings 23,027 16,628 8,982 5,000 10,000 5,000 Total Other Sources 23,027 16,628 9,176 5,000 999,900 5,000 OTHER USES
Capital Improvements ‐ ‐ ‐ ‐
Debt Service ‐ General Fund (101)
Principal ‐ ‐ ‐ ‐ (27,399) (55,487)
Interest ‐ ‐ ‐ ‐ (12,374) (23,716)
Debt Service ‐ Sewer Capital Fund (405)
Principal (87,500) (91,036) (288,483) (94,966) (94,966) (550,059) Interest (17,016) (13,434) (11,309) (9,503) (9,503) (2,161) Total Other Uses (104,516) (104,469) (299,792) (104,469) (144,242) (631,422) Net Other Sources/(Uses) (81,489) (87,841) (290,616) (99,469) 855,658 (626,422) NET OTHER ADJUSTMENTS/TRANSFERS
Water Recycling ‐ ‐ ‐ ‐ ‐ ‐
Sewer Capital Fund ‐ ‐ ‐ ‐ ‐ ‐
Water Capital Fund ‐ ‐ ‐ ‐ ‐ ‐
Net All Transfers ‐ ‐ ‐ ‐ ‐ ‐
NET SURPLUS/(DEFICIT) 191,301 152,566 (156,456) 24,229 16,103 (334,567) BEGINNING FUND BALANCE 967,562 1,158,863 1,311,429 1,391,818 1,154,973 1,171,076 ENDING BALANCE 1,158,863 1,311,429 1,154,973 1,416,047 1,171,076 836,509 OPERATING RESERVE (33% PER POLICY) 481,323 551,882 657,951 626,136 936,534 625,167 GENERAL RESERVE 677,540 759,547 497,021 789,911 234,542 211,342 TOTAL RESERVE 1,158,863 1,311,429 1,154,973 1,416,047 1,171,076 836,509 NOTE: * 2022/23 Expected Rate Impact
DESCRIPTION
Replaces Packet Page 57
CITY OF COTATI
ENTERPRISE WATER FUNDS
‐ Without Rate Adjustment ‐
FY 18/19 FY 19/20 FY 20/21 FY 21/22 FY 21/22 FY 22/23
ACTUALS ACTUALS ACTUALS ADOPTED ESTIMATE PROPOSED
FUND 401 - WATER OPERATING
OPERATING REVENUES
Charges for Services
$ 921,624 $ 1,056,377 $ 1,181,243 $ 1,180,000 $ 1,105,000 $ 1,165,000 754,289 809,815 865,724 800,000 840,000 860,000 52,390 43,527 45,416 40,080 38,000 29,300
475 300 110 ‐ 110 ‐
Sale of Water ‐ Usage
Sale of Water ‐ Fixed
Customer Fees
Other Reimbursements*
Special Assessment Backflow 2,082 2,481 202 1,000 12,317 10,000 Charges for Services 1,730,861 1,912,500 2,092,695 2,021,080 1,995,427 2,064,300 Other Revenues 483 278 35,257 ‐ 3,000 ‐
Total Operating Revenues 1,731,344 1,912,778 2,127,952 2,021,080 1,998,427 2,064,300 OPERATING EXPENSES
Water Operations
Personnel Services 517,657 686,225 762,892 750,343 1,732,755 687,365 Services and Supplies 486,07 0 510,954 628,818 629,102 590,227 661,080 Purchased Water 454,827 475,192 602,082 517,937 515,00 0 546,000 Total Operating Expenses 1,458,554 1,672,370 1,993,792 1,897,382 2,837,982 1,894,445 NET OPERATING SURPLUS 272,790 240,407 134,160 123,698 (839,555) 169,855 OTHER SOURCES
Grants from Other Agencies ‐ ‐ 194 ‐ ‐ ‐
Loan from General Fund ‐ ‐ ‐ ‐ 989,900
Loan From Sewer ‐ ‐ ‐ ‐ ‐ ‐
Interest Earnings 23,027 16,628 8,982 5,000 10,000 5,000 Total Other Sources 23,027 16,628 9,176 5,000 999,900 5,000 OTHER USES
Capital Improvements ‐ ‐ ‐ ‐
Debt Service ‐ General Fund (101)
Principal ‐ ‐ ‐ ‐ (27,399) (55,487)
Interest ‐ ‐ ‐ ‐ (12,374) (23,716)
Debt Service ‐ Sewer Capital Fund (405)
Principal (87,500) (91,036) (288,483) (94,966) (94,966) (550,059) Interest (17,016) (13,434) (11,309) (9,503) (9,503) (2,161) Total Other Uses (104,516) (104,469) (299,792) (104,469) (144,242) (631,422) Net Other Sources/(Uses) (81,489) (87,841) (290,616) (99,469) 855,658 (626,422) NET OTHER ADJUSTMENTS/TRANSFERS
Water Recycling ‐ ‐ ‐ ‐ ‐ ‐
Sewer Capital Fund ‐ ‐ ‐ ‐ ‐ ‐
Water Capital Fund ‐ ‐ ‐ ‐ ‐ ‐
Net All Transfers ‐ ‐ ‐ ‐ ‐ ‐
NET SURPLUS/(DEFICIT) 191,301 152,566 (156,456) 24,229 16,103 (456,567) BEGINNING FUND BALANCE 967,562 1,158,863 1,311,429 1,391,818 1,154,973 1,171,076 ENDING BALANCE 1,158,863 1,311,429 1,154,973 1,416,047 1,171,076 714,509 OPERATING RESERVE (33% PER POLICY) 481,323 551,882 657,951 626,136 936,534 625,167 GENERAL RESERVE 677,540 759,547 497,021 789,911 234,542 89,342 TOTAL RESERVE 1,158,863 1,311,429 1,154,973 1,416,047 1,171,076 714,509
DESCRIPTION
Replaces Packet Page 61
NOTE: * 2022/23 Expected Rate Impact Excluded
CITY OF COTATI
ENTERPRISE SEWER FUNDS
FY 18/19 FY 19/20 FY 20/21 FY 21/22 FY 21/22 FY 22/23
ACTUALS ACTUALS ACTUALS ADOPTED ESTIMATE PROPOSED
DESCRIPTION
FUND 405 - SEWER CAPITAL
OPERATING REVENUES
Charges for Services
Collection System 36,567 $ 36,567 $ 36,567 $ 15,100 $ 36,560 $ 36,567 $ Sewer Connection Fees 11,532 666,517 143,256 ‐ 163,770 50,000 Sewer Application Fees ‐ ‐ ‐ ‐ ‐ ‐
Other Reimbursements 3,501 ‐ ‐ 3,000 ‐ ‐
Total Operating Revenues 51,600 703,084 179,823 18,100 200,330 86,567 OPERATING EXPENSES
Wastewater Treatment
Contract Services ‐ ‐ ‐ ‐ ‐ ‐
Capital ‐ ‐ ‐ ‐ ‐ ‐
Total Operating Expenses ‐ ‐ ‐ ‐ ‐ ‐
NET OPERATING SURPLUS 51,600 703,084 179,823 18,100 200,330 86,567 OTHER SOURCES
Loan Payments – from General Fund ‐ ‐ ‐ ‐ ‐ ‐
Loan Payments – from Water Op. Fund 104,516 104,469 299,792 104,469 144,242 631,422 Interest Earnings 56,414 18,723 11,309 ‐ 1,000 ‐
Total Other Sources 160,930 123,193 311,101 104,469 145,242 631,422 OTHER USES
Equipment ‐ ‐ (8,915) (22,500) ‐ ‐
Capital Improvements
West Sierra Avenue Sewer Replacement ‐ ‐ ‐ ‐ ‐ (1, 100,000) William/Olaf Sewer Replacement ‐ (68,267) (609,702) ‐ ‐ ‐ SCADA Phase 2 (22,105) ‐ ‐ (100,000) ‐ (150,000) St. Joseph Way Main Replacement ‐ ‐ ‐ ‐ ‐ ‐
Manhole Lateral Repair/Improvement ‐ ‐ (83,615) (96,000) (96,000) ‐ P1 Pipeline/Laguna Sewer Bypass (4,524,924) (2,709) ‐ ‐ ‐ Total Other Uses (4,547,029) (70,976) (702,232) (218,500) (96,000) (1,250,000) Net Other Sources/(Uses) (4,386,099) 52,216 (391,131) (114,031) 49,242 (618,578) NET OTHER ADJUSTMENTS/TRANSFERS
Water Loan ‐ ‐ ‐ ‐ ‐ ‐
Sewer Operating ‐ ‐ ‐ ‐ (45,700) (41,500) Sewer's Cost Portion ‐ AMI ‐ ‐ ‐ ‐ ‐
Water Operating Fund 401 ‐ ‐ ‐ ‐ ‐
Exp. Reimb. Fund 605 ‐ ‐ ‐ ‐ ‐
Net All Transfers ‐ ‐ ‐ ‐ (45,700) (41,500) NET SURPLUS/(DEFICIT) (4,334,499) 755,300 (211,308) (95,931) 203,871 (573,511) BEGINNING FUND BALANCE 4,272,669 (61,830) 693,470 613,458 482,162 686,033 ENDING BALANCE (61,830) 693,470 482,162 517,527 686,033 112,523 ‐ With Rate Adjustment ‐
Replaces Packet Page 65
CITY OF COTATI
ENTERPRISE SEWER FUNDS
FY 18/19 FY 19/20 FY 20/21 FY 21/22 FY 21/22 FY 22/23
ACTUALS ACTUALS ACTUALS ADOPTED ESTIMATE PROPOSED
FUND 404 - SEWER OPERATING
OPERATING REVENUES
Charges for Services
Usage $ 1,207,494 $ 1,188,382 $ 1,284,295 $ 1,361,850 $ 1,382,000 $ 1,394,000 Base 1,115,739 1,204,829 1,284,789 1,360,000 1,401,000 1,423,000 Reimbursements ‐ 88,886 ‐ ‐ ‐ ‐
Special Assessment* ‐ 714 ‐ ‐ 560 ‐
Total Charges for Services 2,323,233 2,482,811 2,569,085 2,721,850 2,783,560 2,817,000 Special Assessment ‐ Sewer 640 ‐ ‐ ‐ ‐
Other Revenues ‐ 19,250 73,500 ‐ ‐ ‐
Total Operating Revenues 2,323,873 2,502,061 2,642,585 2,721,850 2,783,560 2,817,000 OPERATING EXPENSES
Sewer Operations
Personnel Services 526,584 634,220 629,715 719,180 1,661,500 683,855 Services and Supplies 224,313 306,572 305,822 348,027 355,352 389,565 Sewer Operations 750,897 940,792 935,537 1,067,207 2,016,852 1,073,420 Wastewater Treatment
Capital ‐ Subreg Debt Service 826,034 857,099 863,922 867,555 894,936 889,000 Operations 939,697 885,435 1,142,028 1,170,420 1,320,570 1,485,000 Total Operating Expenses 2,516,628 2,683,326 2,941,487 3,105,182 4,232,358 3,447,420 NET OPERATING SURPLUS/(DEFICIT) (192,755) (181,265) (298,902) (383,332) (1,448,798) (630,420) OTHER SOURCES
Loan from Incluisionary Housing (216)** 1,000,000 ‐ ‐ ‐ ‐ ‐ Loan from General Fund (101) ‐ ‐ ‐ ‐ 948,220 ‐ Loan from Sewer Capital (Fund 405) ‐ 48,772 ‐ ‐ ‐ ‐
Interest Earnings 63,019 51,931 25,059 5,000 5,000 5,000 Total Other Sources 1,063,019 100,703 25,059 5,000 953,220 5,000 OTHER USES
Equipment ‐ ‐ ‐ ‐ ‐ ‐
Debt Service ‐ General Fund (101)
Principal ‐ ‐ ‐ ‐ (26,245) (53,479) Interest ‐ ‐ ‐ ‐ (11,853) (22,717) Debt Service ‐ Inclusionary Housing (Fund 216)
Principal ‐ (31,437) (58,539) (40,429) (40,429) (40,429) Interest ‐ ‐ (8,959) (27,068) (27,068) (27,068) Total Other Uses ‐ (31,437) (67,498) (67,497) (105,595) (143,693) Net Other Sources/(Uses) 1,063,019 69,266 (42,439) (62,497) 847,625 (138,693) NET OTHER ADJUSTMENTS/TRANSFERS
Sewer Capital Fund 405 ‐ ‐ ‐ ‐ 45,700 41,500
Compensated Absences ‐ ‐ ‐ ‐ ‐ ‐
Net All Transfers ‐ ‐ ‐ 45,700 41,500 NET SURPLUS/(DEFICIT) 870,264 (111,999) (341,340) (445,829) (555,473) (727,613) BEGINNING FUND BALANCE 2,396,662 3,266,926 3,154,926 1,970,050 2,813,586 2,258,113 ENDING BALANCE 3,266,926 3,154,926 2,813,586 1,524,221 2,258,113 1,530,500 OPERATING RESERVE (33% PER POLICY) 830,487 885,498 970,691 1,024,710 1,083,766 1,137,649 GENERAL RESERVE 2,436,439 2,269,429 1,842,895 499,511 1,174,347 392,851 TOTAL RESERVE 3,266,926 3,154,926 2,813,586 1,524,221 2,258,113 1,530,500 NOTE:
DESCRIPTION
* 2022/23 Expected Rate Impact excluded
** Excluded in prior year budget study session.
‐ Without Rate Adjustment ‐
Replaces Packet Page 67
CITY OF COTATI
ENTERPRISE SEWER FUNDS
FY 18/19 FY 19/20 FY 20/21 FY 21/22 FY 21/22 FY 22/23
ACTUALS ACTUALS ACTUALS ADOPTED ESTIMATE PROPOSED
DESCRIPTION
FUND 405 - SEWER CAPITAL
OPERATING REVENUES
Charges for Services
Collection System 36,567 $ 36,567 $ 36,567 $ 15,100 $ 36,560 $ 36,567 $ Sewer Connection Fees 11,532 666,517 143,256 ‐ 163,770 50,000 Sewer Application Fees ‐ ‐ ‐ ‐ ‐ ‐
Other Reimbursements 3,501 ‐ ‐ 3,000 ‐ ‐
Total Operating Revenues 51,600 703,084 179,823 18,100 200,330 86,567 OPERATING EXPENSES
Wastewater Treatment
Contract Services ‐ ‐ ‐ ‐ ‐ ‐
Capital ‐ ‐ ‐ ‐ ‐ ‐
Total Operating Expenses ‐ ‐ ‐ ‐ ‐ ‐
NET OPERATING SURPLUS 51,600 703,084 179,823 18,100 200,33 0 86,567 OTHER SOURCES
Loan Payments – from General Fund ‐ ‐ ‐ ‐ ‐ ‐
Loan Payments – from Water Op. Fund 104,516 104,469 299,792 104,469 144,242 631,422 Interest Earnings 56,414 18,723 11,309 ‐ 1,000 ‐
Total Other Sources 160,930 123,193 311,101 104,469 145,242 631,422 OTHER USES
Equipment ‐ ‐ (8,915) (22,500) ‐ ‐
Capital Improvements
‐ ‐ ‐ ‐ ‐ (1,100,000)
‐ (68,267) (609,702) ‐ ‐ ‐ (22,105) ‐ ‐ (100,000) ‐ (150,000) ‐ ‐ ‐ ‐ ‐ ‐
‐ ‐ (83,615) (96,000) (96,000) ‐ West Sierra Avenue Sewer Replacement
William/Olaf Sewer Replacement SCADA
Phase 2
St. Joseph Way Main Replacement
Manhole Lateral Repair/Improvement P1
Pipeline/Laguna Sewer Bypass (4,524,924) (2,709) ‐ ‐ ‐ Total Other Uses (4,547,029) (70,976) (702,232) (218,500) (96,000) (1,250,000) Net Other Sources/(Uses) (4,386,099) 52,216 (391,131) (114,031) 49,242 (618,578) NET OTHER ADJUSTMENTS/TRANSFERS
Water Loan ‐ ‐ ‐ ‐ ‐ ‐
Sewer Operating ‐ ‐ ‐ ‐ (45,700) (41,500) Sewer's Cost Portion ‐ AMI ‐ ‐ ‐ ‐ ‐
Water Operating Fund 401 ‐ ‐ ‐ ‐ ‐
Exp. Reimb. Fund 605 ‐ ‐ ‐ ‐ ‐
Net All Transfers ‐ ‐ ‐ ‐ (45,700) (41,500) NET SURPLUS/(DEFICIT) (4,334,499) 755,300 (211,308) (95,931) 203,871 (573,511) BEGINNING FUND BALANCE 4,272,669 (61,830) 693,470 613,458 482,162 686,033 ENDING BALANCE (61,830) 693,470 482,162 517,527 686,033 112,523 ‐ Without Rate Adjustment ‐
Replaces Packet Page 68