Estero Municipal Improvement District Attachment 1 - Water Enterprise CIP Funding Strategy Long-Range CIP Planning
15-Year Forecasts and Funding Options
FY 2025-2026 through FY 2039-2040
Water 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 5,438,483 7,804,953 6,954,953 2,460,912 3,522,912 4,272,912 5,722,912 4,722,912 4,222,912 5,722,912 6,472,912 7,222,912 6,972,912 4,222,912 4,972,912 5,438,483 Less: Capital Improvement Expenditures (800,000) (3,450,000) (7,250,000) (1,438,000) (1,000,000) (50,000) (2,500,000) (2,000,000) - (750,000) (750,000) (1,750,000) (4,250,000) (750,000) (750,000) (27,488,000) Add: Other Funding Sources
Water Connection Fees 566,470 - 255,959 - - - - - - - - - - - - 822,429 Add: Annual Long-Term CIP Funding from Operations (1) 4,433,000 4,433,000 4,333,000 4,333,000 3,583,000 3,333,000 3,333,000 3,333,000 3,333,000 3,333,000 3,333,000 3,333,000 3,333,000 3,333,000 3,333,000 54,445,000 (1,833,000) (1,833,000) (1,833,000) (1,833,000) (1,833,000) (1,833,000) (1,833,000) (1,833,000) (1,833,000) (1,833,000) (1,833,000) (1,833,000) (1,833,000) (1,833,000) (1,833,000) (27,495,000) Ending Fund Balance 7,804,953 6,954,953 2,460,912 3,522,912 4,272,912 5,722,912 4,722,912 4,222,912 5,722,912 6,472,912 7,222,912 6,972,912 4,222,912 4,972,912 5,722,912 5,722,912 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 5, 804,953 4,954,953 460,912 1,522,912 2,272,912 3,722,912 2,722,912 2,222,912 3,722,912 4,472,912 5,222,912 4,972,912 2,222,912 2,972,912 3,722,912 3,722,912 Net Annual Long-Term CIP Funding from Operations (1) - (2) 2, 600,000 2,600,000 2,500,000 2,500,000 1,750,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 26,950,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)