|
Cable FundBalance 12/31/23 -$10,986Table 1720242025202620272028202920302031203220332034ExpenditureIT CIP - Cable Fund Portion0000075,00025,0000000Operating Expenditure (1) 62,60072,20074,40076,60078,90081,30083,70086,20088,80091,50094,200Transfer to IT Fund 00000000000Total Expenditure62,60072,20074,40076,60078,900156,300108,70086,20088,80091,50094,200RevenueOperating Revenues (1)71,00073,10075,30077,60079,90082,30084,80087,30089,90092,60095,400Add back depreciation (1)18,00019,50020,10020,70021,30021,90022,60023,30024,00024,70025,400Total Revenue89,00092,60095,40098,300101,200104,200107,400110,600113,900117,300120,800Change in Fund Balance26,40020,40021,00021,70022,300(52,100) (1,300)24,40025,10025,80026,600Ending Balance$15,414$35,814$56,814$78,514$100,814$48,714$47,414$71,814$96,914$122,714$149,314Fleet FundBalance 12/31/23 -$125,995Table 1720242025202620272028202920302031203220332034ExpenditureTransfer to Equipment Improvement Outlay Fund45,000255,0000 330,00000 100,0000000Operating Expenditure (1) 441,000450,650464,200478,100492,400507,200522,400538,100554,200570,800587,900Total Expenditure486,000705,650464,200808,100492,400507,200622,400538,100554,200570,800587,900RevenueOperating Revenues (2)260,250412,700454,000499,400549,300604,200622,300641,000660,200680,000700,400Transfer in from General Fund050,00075,00075,00075,00075,00050,00050,00025,00000Total Revenue 260,250462,700529,000574,400624,300679,200672,300691,000685,200680,000700,400Change in Fund Balance(225,750) (242,950)64,800(233,700)131,900172,00049,900152,900131,000109,200112,500Ending Balance($351,745) ($594,695) ($529,895) ($763,595) ($631,695) ($459,695) ($409,795) ($256,895) ($125,895) ($16,695)$95,805NOTES:(1) Expenditures and Revenues are based on the City's 2025 draft budgets. For planning purposes, a 3% annual inflation factor has been used to project future amounts.(2) Revenue are based on the City's 2025 draft budget and for planning purposes, includes an adjustment of 10% within the first 5-year plan and an inflator of 3% for the post 5-year plan.(3) Revenues includes utility rate charges that are based on the utility rate study conducted in 2019 for future year 2020-2025.Page 24 of 24314
|