CIP Book FY 2023-27 - Final - Flipbook - Page 21
Capital Improvements Plan
Water & Wastewater Funding Analysis:
Table 4
Water & Wastewater Fund
Fund Balance,
Less Investm.in Capital
System Revenue
Combined Water
Combined Wastewater
Reclaimed Water
Other Interest
Sewer Impact Fees
Water Impact Fees
Other Income
American Rescue Federal Grant
Total Revenue
Total Funding Available
Less:
Operating Expense Less
Depreciation
Transfer Out
Interest Expense
Water, Wastewater & Reclaimed
Water Projects
Debt Service
Total Expenses
Net Operating Income (Loss)
Fund Balance, End of Year
Actual
Actual
Budgeted
FY 19-20
FY 20-21
FY 21-22
$17,661,470 $18,309,362 $18,397,466
5,980,565 5,913,203 6,157,490
4,932,128 5,080,046 5,544,000
448,718 440,725 483,000
99,331 32,403 33,900
307,369 139,897 356,000
187,938 97,536 120,000
135,738 1,299,232 109,700
- - 12,091,787 13,003,042 12,804,090
29,753,257 31,312,404 31,201,556
Estimated
Projected
FY 21-22
FY 22-23
$18,397,466 $21,368,961
6,225,845 6,225,845
5,267,820 5,267,820
420,000 420,000
20,440 20,440
149,930 149,930
46,460 46,460
8,300 8,300
3,976,526 5,334,843
16,115,321 17,473,638
34,512,787 38,842,599
Projected
FY 23-24
$16,422,468
6,225,845
5,267,820
420,000
20,440
149,930
46,460
8,300
12,138,795
28,561,263
Projected
Projected
FY 24-25
FY 25-26
$13,730,354 $13,853,732
6,412,620 6,604,999
5,425,855 5,588,630
432,600 445,578
21,053 21,685
154,428 159,061
47,854 49,289
8,549 8,805
- 12,502,959 12,878,048
26,233,313 26,731,780
Projected
FY 26-27
$13,601,273
6,803,149
5,756,289
458,945
22,335
163,833
50,768
9,070
13,264,389
26,865,662
4,274,711 6,088,983 6,465,546 6,000,000 6,300,000 6,615,000 6,813,450 7,017,854 7,228,389
1,814,859 1,806,701 2,008,700 2,008,700 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000
374,421 328,748 - 340,000 357,000 374,850 386,096 397,678 409,609
3,781,431 3,662,080 3,672,145 3,672,145 12,662,610 4,762,548 2,123,094 2,679,173 3,936,972
1,198,473 1,028,426 1,122,981 1,122,981 1,100,521 1,078,511 1,056,941 1,035,802 1,015,086
11,443,895 12,914,938 13,269,372 13,143,826 22,420,131 14,830,909 12,379,581 13,130,507 14,590,056
647,892 88,104 (465,282) 2,971,495 (4,946,493) (2,692,114) 123,378 (252,459) (1,325,667)
$18,309,362 $18,397,466 $17,932,184 $21,368,961 $16,422,468 $13,730,354 $13,853,732 $13,601,273 $12,275,606
Notes:
1. Beginning Fund Balance in FY19-20 ties with CAFR FY 18-19 Year-end Balance
2. Revenue projections going forward include a 0% increase per year for FY 22/23 and 23/24 (inflation)
3. Revenue projections going forward include a 2% increase per year for FY 24/27 (new subdivisions
revenue)
4. Expenditures projections going forward include a 5% increase per year for FY 22/23 and 23/24
(inflation)
5. Expenditures projections going forward include a 3% increase per year for FY 24/27 (inflation easing)
6. Analysis assume that project budgets are fully spent each year going forward
19