Page 60 - CityofMansfieldFY24Budget

Utility Fund Strategic Plan Summary

2027
2025
2026
2028
2024
Utility Fund Budgeted Projected Projected Projected Projected
BEGINNING FUND BALANCE $ 34,061,834 $ 34,089,881 $ 36,414,303 $ 39,065,888 $ 40,155,189
REVENUES:
Water Sales-Retail $ 23,085,899 $ 23,804,639 $ 24,515,403 $ 25,588,032 $ 26,916,871
Wastewater Sales-Retail 17,563,377 19,218,969 20,937,102 22,258,196 23,412,650
Wholesale Revenue 7,445,335 7,016,518 8,007,885 7,840,638 9,060,167
Other Revenue 1,091,873 1,091,873 1,091,873 1,091,873 1,091,873
TOTAL REVENUE: $ 49,186,485 $ 51,132,000 $ 54,552,263 $ 56,778,740 $ 60,481,562
Percentage Change 4% 7% 4% 7%

EXPENDITURES:
Utility Adminstration $ 1,144,728 $ 1,181,814 $ 1,220,102 $ 1,259,631 $ 1,300,440
Billing and Collections 1,028,125 1,061,434 1,095,822 1,131,324 1,167,977
Meter Reading and Repairs 1,093,327 1,128,749 1,165,318 1,203,071 1,242,048
GIS 287,619 296,937 306,557 316,489 326,742
Water Distribution 1,133,912 1,170,915 1,209,134 1,248,609 1,289,382
Wastewater Collection 11,299,689 12,553,081 13,846,430 14,576,225 15,550,264
Water Treatment 14,544,464 15,456,450 16,338,885 17,823,835 19,398,947
Water Quality 671,509 693,265 715,725 738,913 762,852
Water Demand Management 168,047 173,491 179,112 184,914 190,905
Non-Departmental 579,145 597,908 617,279 637,277 657,924
Cash Capital Outlays 1,484,757 1,532,948 1,582,706 1,634,081 1,687,128
Cash Capital CIP 8,491,200 400,000 400,000 100,000 -
Existing Debt Service 3,841,100 3,607,250 3,607,250 3,606,700 3,215,500
Projected Debt Service - 3,631,034 4,141,053 5,381,186 6,557,431
Debt Service Reserve 240,000 2,171,485 2,324,491 2,696,366 2,931,879
Transfer to General Fund 3,150,816 3,150,816 3,150,816 3,150,816 3,150,816
TOTAL EXPENDITURES: $ 49,158,438 $ 48,807,577 $ 51,900,679 $ 55,689,438 $ 59,430,234

CHANGE IN NET ASSETS 28,047 2,324,423 2,651,584 1,089,301 1,051,328

PROJECTED FUND BALANCE $ 34,089,881 $ 36,414,303 $ 39,065,888 $ 40,155,189 $ 41,206,517

DEBT SERVICE COVERAGE:
Total Revenues $ 49,186,485 $ 51,132,000 $ 54,552,263 $ 56,778,740 $ 60,481,562
Less: O&M Expense 35,101,381 37,464,860 39,845,180 42,271,104 45,038,296
Available for Debt Service Requirements $ 14,085,104 $ 13,667,140 $ 14,707,084 $ 14,507,635 $ 15,443,265
Total Debt Service Requirements 3,841,100 7,238,284 7,748,303 8,987,886 9,772,931
Total Debt Service Coverage 3.67 1.89 1.90 1.61 1.58

60