Estero Municipal Improvement District Attachment 1 - Water Enterprise CIP Funding Strategy Long-Range CIP Planning
15-Year Forecasts and Funding Options
FY 2024-2025 through FY 2038-2039 Water Enterprise Fund Funding Strategy
15-Year Fund Balance Analysis
Fund Balance Analysis - 15-Year Forecast (FYE 6/30) 15 year 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 Total Beginning Fund Balance 5,636,457 6,636,457 7,186,457 5,986,457 5,486,457 5,048,457 5,048,457 5,048,457 6,048,457 5,298,457 5,548,457 5,798,457 6,048,457 5,298,457 5,548,457 5,636,457 Less: Capital Improvement Expenditures - (550,000) (2,700,000) (1,500,000) (1,438,000) (1,000,000) (1,000,000) - (1,750,000) (750,000) (750,000) (750,000) (1,750,000) (750,000) (3,500,000) (18,188,000) Add: Other Funding Sources
Water Connection Fees - 100,000 500,000 - - - - - - - - - - - - 600,000 Add: Annual Long-Term CIP Funding from Operations (1) 2,213,000 2,213,000 2,213,000 2,213,000 2,213,000 2,213,000 2,213,000 2,213,000 2,213,000 2,213,000 2,213,000 2,213,000 2,213,000 2,213,000 2,213,000 33,195,000 (1,213,000) (1,213,000) (1,213,000) (1,213,000) (1,213,000) (1,213,000) (1,213,000) (1,213,000) (1,213,000) (1,213,000) (1,213,000) (1,213,000) (1,213,000) (1,213,000) (1,213,000) (18,195,000) Ending Fund Balance 6,636,457 7,186,457 5,986,457 5,486,457 5,048,457 5,048,457 5,048,457 6,048,457 5,298,457 5,548,457 5,798,457 6,048,457 5,298,457 5,548,457 3,048,457 3,048,457 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 Requirement4,636,457 5,186,457 3,986,457 3,486,457 3,048,457 3,048,457 3,048,457 4,048,457 3,298,457 3,548,457 3,798,457 4,048,457 3,298,457 3,548,457 1,048,457 1,048,457 Net Annual Long-Term CIP Funding from Operations (1) - (2)1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 15,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)