Page 60 - CityofMansfieldFY25Budget

Utility Fund Strategic Plan Summary

Utility Fund 2030 2031 2032 2033 2034
Projected Projected Projected Projected Projected

BEGINNING FUND BALANCE $ 42,567,625 $ 46,130,098 $ 47,860,660 $ 46,594,744 $ 41,943,305
REVENUES:
Water Sales-Retail $ 32,674,391 $ 33,315,333 $ 33,975,502 $ 34,655,476 $ 35,355,850
Wastewater Sales-Retail 24,607,360 25,138,892 25,686,370 26,250,273 26,831,092
Wholesale Revenue 7,758,898 7,981,792 8,370,953 8,787,769 9,231,704
Other Revenue 1,091,873 1,091,873 1,091,873 1,091,873 1,091,873
TOTAL REVENUE: $ 66,132,523 $ 67,527,889 $ 69,124,698 $ 70,785,391 $ 72,510,519
Percentage Change 3% 2% 2% 2% 2%

EXPENDITURES:
Utility Adminstration $ 1,440,825 $ 1,496,620 $ 1,554,589 $ 1,614,818 $ 1,677,395
Billing and Collections 1,279,594 1,327,083 1,376,356 1,427,480 1,480,526
Meter Reading and Repairs 1,847,411 1,912,724 1,980,380 2,050,466 2,123,068
GIS 507,017 526,321 546,366 567,182 588,797
Water Distribution 1,675,035 1,738,623 1,804,655 1,873,227 1,944,436
Wastewater Collection 18,648,719 20,442,786 22,426,163 24,618,991 27,042,618
Water Treatment 22,300,768 24,280,457 26,460,775 28,863,139 31,511,298
Water Quality 710,742 738,254 766,837 796,534 827,389
Water Demand Management 212,978 221,041 229,412 238,104 247,128
Non-Departmental 336,615 344,062 351,735 359,640 367,785
Cash Capital Outlays 323,196 333,439 344,010 354,919 366,179
Cash Capital CIP - - - - -
Existing Debt Service 4,910,100 4,171,800 4,172,900 4,178,650 4,173,600
Projected Debt Service - - - - -
Debt Service Reserve 2,929,361 2,707,871 2,708,201 2,709,926 2,708,411
Transfer to General Fund 4,009,723 4,091,796 4,176,331 4,263,402 4,705,634
Transfer to Risk Management 387,920 403,437 419,574 436,357 453,812
Shared Services Overhead 1,050,046 1,061,015 1,072,328 1,083,996 1,096,029
TOTAL EXPENDITURES: $ 62,570,050 $ 65,797,328 $ 70,390,614 $ 75,436,831 $ 81,314,104

CHANGE IN NET ASSETS $ 3,562,473 $ 1,730,562 $ (1,265,916) $ (4,651,440) $ (8,803,585)

PROJECTED FUND BALANCE $ 46,130,098 $ 47,860,660 $ 46,594,744 $ 41,943,305 $ 33,139,720

DEBT SERVICE COVERAGE:
Total Revenues $ 66,132,523 $ 67,527,889 $ 69,124,698 $ 70,785,391 $ 72,510,519
Less: O&M Expense 54,407,392 58,584,218 63,165,503 68,193,335 74,065,914
Available for Debt Service Requirements $ 11,725,130 $ 8,943,672 $ 5,959,195 $ 2,592,056 $ (1,555,395)
Total Debt Service Requirements 4,910,100 4,171,800 4,172,900 4,178,650 4,173,600
Total Debt Service Coverage 2.39 2.14 1.43 0.62 (0.37)

60