Page 59 - CityofMansfieldFY25Budget

Utility Fund Strategic Plan Summary

Utility Fund 2025 2026 2027 2028 2029
Budgeted Projected Projected Projected Projected

BEGINNING FUND BALANCE $ 28,454,219 $ 31,095,057 $ 33,544,740 $ 36,169,670 $ 39,356,172
REVENUES:
Water Sales-Retail $ 23,940,995 $ 25,634,874 $ 27,456,978 $ 29,417,487 $ 31,456,104
Wastewater Sales-Retail 19,175,160 20,300,639 21,505,859 22,792,205 24,091,309
Wholesale Revenue 5,584,910 5,884,848 6,635,740 7,070,093 7,714,777
Other Revenue 1,091,873 1,091,873 1,091,873 1,091,873 1,091,873
TOTAL REVENUE: $ 49,792,937 $ 52,912,234 $ 56,690,451 $ 60,371,657 $ 64,354,064
Percentage Change 6% 7% 6% 7%

EXPENDITURES:
Utility Adminstration $ 1,191,701 $ 1,237,793 $ 1,285,681 $ 1,335,433 $ 1,387,122
Billing and Collections 1,066,706 1,106,207 1,147,190 1,189,709 1,233,824
Meter Reading and Repairs 1,553,220 1,607,993 1,664,725 1,723,490 1,784,359
GIS 420,689 436,680 453,283 470,524 488,427
Water Distribution 1,390,670 1,443,343 1,498,036 1,554,828 1,613,799
Wastewater Collection 12,150,291 13,402,051 14,578,594 15,839,913 17,027,478
Water Treatment 15,277,204 16,022,862 17,059,324 18,702,830 20,495,910
Water Quality 587,899 610,628 634,242 658,774 684,262
Water Demand Management 176,900 183,585 190,526 197,731 205,212
Non-Departmental 258,000 273,475 290,033 307,740 325,991
Cash Capital Outlays 276,551 285,303 294,334 303,653 313,271
Cash Capital CIP - - - - -
Existing Debt Service 7,309,994 7,310,000 7,311,200 6,918,000 6,908,850
Projected Debt Service - - - - -
Debt Service Reserve 1,155,302 1,986,149 2,866,999 2,940,102 3,373,377
Transfer to General Fund 3,018,131 3,215,486 3,427,399 3,654,678 3,888,319
Transfer to Risk Management 318,842 331,596 344,860 358,654 373,000
Shared Services Overhead 1,000,000 1,009,401 1,019,097 1,029,096 1,039,409
TOTAL EXPENDITURES: $ 47,152,099 $ 50,462,552 $ 54,065,521 $ 57,185,156 $ 61,142,610

CHANGE IN NET ASSETS $ 2,640,838 $ 2,449,683 $ 2,624,930 $ 3,186,502 $ 3,211,454

PROJECTED FUND BALANCE $ 31,095,057 $ 33,544,740 $ 36,169,670 $ 39,356,172 $ 42,567,625

DEBT SERVICE COVERAGE:
Total Revenues $ 49,792,937 $ 52,912,234 $ 56,690,451 $ 60,371,657 $ 64,354,064
Less: O&M Expense 38,410,252 40,881,100 43,592,988 47,023,401 50,547,112
Available for Debt Service Requirements $ 11,382,686 $ 12,031,135 $ 13,097,462 $ 13,348,257 $ 13,806,952
Total Debt Service Requirements 7,309,994 7,310,000 7,311,200 6,918,000 6,908,850
Total Debt Service Coverage 1.56 1.65 1.79 1.93 2.00

59