Page 61 - CityofMansfieldFY24Budget

Utility Fund Strategic Plan Summary

2032
2030
2031
2033
2029
Utility Fund Projected Projected Projected Projected Projected
BEGINNING FUND BALANCE $ 41,206,517 $ 39,988,509 $ 40,886,112 $ 41,685,408 $ 41,490,098
REVENUES:
Water Sales-Retail $ 27,685,412 $ 28,324,197 $ 29,558,432 $ 30,865,637 $ 32,279,352
Wastewater Sales-Retail 23,927,686 24,458,173 25,004,575 25,567,368 26,147,046
Wholesale Revenue 8,087,927 7,710,324 7,888,197 8,279,841 8,699,213
Other Revenue 1,091,873 1,091,873 1,091,873 1,091,873 1,091,873
TOTAL REVENUE: $ 60,792,899 $ 61,584,567 $ 63,543,078 $ 65,804,719 $ 68,217,484
Percentage Change 1% 1% 3% 4% 4%

EXPENDITURES:
Utility Adminstration $ 1,342,571 $ 1,386,068 $ 1,430,973 $ 1,477,333 $ 1,525,196
Billing and Collections 1,205,817 1,244,882 1,285,214 1,326,852 1,369,839
Meter Reading and Repairs 1,282,288 1,323,831 1,366,720 1,410,999 1,456,712
GIS 337,328 348,257 359,539 371,187 383,213
Water Distribution 1,331,496 1,374,995 1,419,926 1,466,337 1,514,277
Wastewater Collection 16,139,801 16,754,193 18,176,086 19,733,651 21,438,863
Water Treatment 20,012,238 20,383,610 21,681,239 23,072,357 24,564,046
Water Quality 787,567 813,082 839,424 866,619 894,696
Water Demand Management 197,090 203,475 210,068 216,873 223,899
Non-Departmental 679,239 701,245 723,963 747,418 771,633
Cash Capital Outlays 1,741,899 1,798,453 1,856,845 1,917,138 1,979,392
Cash Capital CIP - - - - -
Existing Debt Service 3,207,100 1,208,100 468,800 468,400 472,400
Projected Debt Service 7,410,406 7,410,406 7,410,406 7,410,406 7,410,406
Debt Service Reserve 3,185,252 2,585,552 2,363,762 2,363,642 2,364,842
Transfer to General Fund 3,150,816 3,150,816 3,150,816 3,150,816 3,150,816
TOTAL EXPENDITURES: $ 62,010,907 $ 60,686,964 $ 62,743,782 $ 66,000,029 $ 69,520,230

CHANGE IN NET ASSETS (1,218,008) 897,603 799,296 (195,310) (1,302,746)

PROJECTED FUND BALANCE $ 39,988,509 $ 40,886,112 $ 41,685,408 $ 41,490,098 $ 40,187,352

DEBT SERVICE COVERAGE:
Total Revenues $ 60,792,899 $ 61,584,567 $ 63,543,078 $ 65,804,719 $ 68,217,484
Less: O&M Expense 46,466,249 47,684,454 50,643,968 53,840,443 57,293,190
Available for Debt Service Requirements $ 14,326,649 $ 13,900,114 $ 12,899,109 $ 11,964,276 $ 10,924,294
Total Debt Service Requirements 10,617,506 8,618,506 7,879,206 7,878,806 7,882,806
Total Debt Service Coverage 1.35 1.61 1.64 1.52 1.39

61