Estero Municipal Improvement District Attachment 3 - Wastewater Enterprise CIP Funding Strategy Long-Range CIP Planning
15-Year Forecasts and Funding Options
FY 2025-2026 through FY 2039-2040
Wastewater Enterprise Fund
Funding Strategy
15-Year Fund Balance Analysis
Fund Balance Analysis - 15-Year Forecast (FYE 6/30) 15 year 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 Total Beginning Fund Balance 6,578,500 3,343,063 3,985,260 6,826,080 5,526,080 6,026,080 6,836,080 4,636,080 7,136,080 7,436,080 9,936,080 6,236,080 8,736,080 5,036,080 7,536,080 6,578,500 Less: Capital Improvement Expenditures (20,359,516) (2,857,803) (2,600,000) (4,800,000) (3,000,000) (2,690,000) (5,700,000) - (2,200,000) - (6,200,000) - (6,200,000) - - (56,607,319) Add: Other Funding Sources
Wastewater Connection Fees 1,124,079 - 1,940,820 - - - - - - - - - - - - 1,124,079 Add: Annual Long-Term CIP Funding from Operations (1) 19,774,000 7,274,000 7,274,000 7,274,000 7,274,000 7,274,000 7,274,000 6,274,000 6,274,000 6,274,000 6,274,000 6,274,000 6,274,000 6,274,000 6,274,000 113,610,000 (3,774,000) (3,774,000) (3,774,000) (3,774,000) (3,774,000) (3,774,000) (3,774,000) (3,774,000) (3,774,000) (3,774,000) (3,774,000) (3,774,000) (3,774,000) (3,774,000) (3,774,000) (56,610,000) Ending Fund Balance 3,343,063 3,985,260 6,826,080 5,526,080 6,026,080 6,836,080 4,636,080 7,136,080 7,436,080 9,936,080 6,236,080 8,736,080 5,036,080 7,536,080 10,036,080 8,095,260 Less Minimum Fund Balance Requirement 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 Excess Fund Balance Over Minimum Requirement 1, 343,063 1,985,260 4,826,080 3,526,080 4,026,080 4,836,080 2,636,080 5,136,080 5,436,080 7,936,080 4,236,080 6,736,080 3,036,080 5,536,080 8,036,080 6,095,260 Net Annual Long-Term CIP Funding from Operations (1) - 16, 000,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 57,000,000 NOTE:
This analysis projects fund balance levels over the 15-year period to determine:
(A) - That there are sufficient funds to meet cash flow requirements in future years (B) - The extent to which excess cash is being reserved Increase (Decrease) to Annual Long-Term CIP Funding due to Excess / Deficiency of Reserves (2)