Long-Range CIP Planning Attachment 1 - 15 Year Fund Balance Analysis 15-Year Forecasts and Funding Options
FY 2025-2026 through FY 2039-2040 City Capital Investment Funding Funding Strategy
15-Year Fund Balance Analysis
Fund Balance Analysis - 15-Year Forecast (FYE 6/30) Total 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 Cash Flow Beginning Fund Balance 25,445,751 23,619,314 17,760,564 10,863,298 13,574,548 11,718,548 8,573,948 14,323,948 14,254,148 19,057,148 24,487,948 29,637,948 34,139,948 39,889,948 45,639,948 25,445,751 Less: Capital Improvement Expenditures from 15-Year Forecast (8,467,000) (11,635,000) (18,350,000) (5,725,000) (8,041,000) (8,894,600) (290,000) (6,294,800) (1,147,000) (929,200) (600,000) (2,068,000) (200,000) - (980,000) (73,621,600) Add: Funding Available from Other Non-General Fund Sources - Reimbursements from Youth Sports Groups (1) 26,250 26,250 26,250 26,250 - - - - - - - - - - 105,000 Parks in Lieu Fees (2) - - - 2,050,000 - - - - - - - - - - - 2,050,000 Park Facilities Impact Fees (2) 864,313 - 4,791,484 - - - - - - - - - - - - 5,655,797 Equipment Replacement Fund (3) - - 385,000 110,000 435,000 - 290,000 425,000 200,000 360,000 - - - - - 2,205,000 Building Maintenance Fund (4) - - 500,000 500,000 - - - 50,000 - 250,000 - 820,000 200,000 - 980,000 3,300,000 Add: Annual Long-Term CIP Funding from City General Fund (A) 10,658,000 10,658,000 10,658,000 10,658,000 10,658,000 10,658,000 10,658,000 10,658,000 10,658,000 10,658,000 10,658,000 10,658,000 10,658,000 10,658,000 10,658,000 159,870,000 Increase (Decrease) to Annual Long-Term CIP Funding from City General Fund due to Excess / Deficiency of Reserves (B) (4,908,000) (4,908,000) (4,908,000) (4,908,000) (4,908,000) (4,908,000) (4,908,000) (4,908,000) (4,908,000) (4,908,000) (4,908,000) (4,908,000) (4,908,000) (4,908,000) (4,908,000) (73,620,000) Ending Fund Balance 23,619,314 17,760,564 10,863,298 13,574,548 11,718,548 8,573,948 14,323,948 14,254,148 19,057,148 24,487,948 29,637,948 34,139,948 39,889,948 45,639,948 51,389,948 51,389,948 Less Minimum Fund Balance Requirement (5) 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 21, 619,314 15,760,564 8,863,298 11,574,548 9,718,548 6,573,948 12,323,948 12,254,148 17,057,148 22,487,948 27,637,948 32,139,948 37,889,948 43,639,948 49,389,948 49,389,948 Net Annual Long-Term CIP Funding from City General Fund (A) - (B) 5,750,000 5,750,000 5,750,000 5,750,000 5,750,000 5,750,000 5,750,000 5,750,000 5,750,000 5,750,000 5,750,000 5,750,000 5,750,000 5,750,000 5,750,000 86,250,000 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 FOOTNOTES:
(2) - Impact Fees are forecasted using conservatively probable development schedules. (1) - The Parks and Recreation Department anticipates payments over the next 5 years will be forthcoming from Youth Sports Groups for reimbursement of the Sea Cloud Synthetic Turf Fields (CIP 301-659).
(3) - Funding for various Parks projects include parks/playground equipment funded from the Equipment Replacement Internal Service Fund. (4) - Funding for Building Maintenance projects is from the Building Maintenance Internal Service Fund. (5) - Per City Council Policy, the minimum fund balance in the City CIP fund is $2 million.
Q:\PubWorks\BUDGET\Budget 2025-2026\CIP\2025-03-24 Long Term CIP\CITY Long-Term CIP\Copy of CIP 15yr forecast CITY Attachments 2025.03.06 - al_md