|
'water Utility Fund 8601
<br />Act Actual
<br />201)
<br />Projected
<br />2018
<br />Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected
<br />2019 2020 2021 2022 2023 2024 2025 2026 2027 2028
<br />Capital Expenses -Equipment
<br />CIP Projects
<br />Fire Station#1 Extension of Water $ (55,000)
<br />County Radio System (3-Year Funding)
<br />Public Works Campus $ (1,715,750)
<br />Sada System Software Upgrades (15,000)
<br />Backhoe(portion of cost) $ (15,625)
<br />3/4 Ton Truck $ (43,000)
<br />Utility Truck $ (25,000) $ (24,000) (32,500)
<br />A. Water Supply& Treatment Improvements
<br />Renovate Pump House 83 $ (70,000)
<br />Construct Well 89& Pumphouse JJS $ (75,000) (1,700,000)
<br />Well #1Rehabil!talon (Not in CIP Maintenance) $ (41,000) $ (44,000) $ (47,000) (50,000) (53,000) (56,000) (59,000) (62,000) (65,000) (68,000)
<br />Emergency Supply for Well #3
<br />Water Treatment Facility 10 MGD Groundwater
<br />Refurbish Water Tower81
<br />Refurbish Water Tower82
<br />Maintain Water Tower #3 (Not in CIP as maintenance)
<br />Watermam - Alpine Drive
<br />Watermam - Bunker/Puma (Rwerstone Pro()
<br />(518,567)
<br />Watermam Looping Ramsey Boulevard to Traprock (142,432)
<br />Cor Bunker Lake Blvd ( Armstrong to Ramsey Blvd)
<br />Ford Brook Estates Reconstruction
<br />Zeolrte Street Improvement
<br />Garnet Street Reconstruction Improvement
<br />(39,000)
<br />(68,000)
<br />(12,000,000) (12,000,000)
<br />$ (700,000)
<br />$ (1,300,000)
<br />(75,000)
<br />$ (385,000)
<br />(340,000)
<br />(30,762)
<br />$ (185,000)
<br />Bolton&Menk 2017 Water Study 2021to 2010 $431,021/yr inflated 3% per year (443,952) (457,271) (470,989) (485,118) (499,672) (514,662) (530,102)
<br />Subtotal -Capital Expenses $ (660,999) $ (81,000) $ (189,387) $ (2,290,000) $ (50,000) $ (2,293,750) $ (1,756,000) $ (91,500) $ (447,000) $ (65,000) $ (12,068,000) $ (12,107,000)
<br />Operational Expenses
<br />Operating Expense -Distribution and Administration (754,262) $ (184,432) $ (815,810) $ (848,442) $ (882,380) $ (917,675) $ (954,382) $ (992,557) $ (1,032,260) $ (1,013,550) $ (1,116,492) $
<br />Operating Expense -Treatment $ - $ - $ Subtotal -Operating Expense $ (754,262) $ (784,432) $ (815,810) $ (848,442) $ (882,380) $ (917,675) $ (954,382) $ (992,557) $ (1,032,260) $ (1,013,550) $ (1,116,492) $
<br />Total Annual Expenses (1,415,261) $ (865,432) $ (1,005,191) $ (3,138,442) $ (932,380) $ (3,211,425) $ (2,710,382) $ (1,084,052) $ (1,479,260) $ (1,138,550) $ (13,184,492) $ (12,107,000)
<br />Water System Revenue
<br />10/05 reduced by 200-300 units per year to be conservative))
<br />Water Sales (gallons/year)
<br />Water rates ($/1000841)(5% annual increase)
<br />Water Availability Charge (WAC) ($/connection)()
<br />necb on/Trunk Charge ($/conneclon)(4.5%after year 2005)
<br />ate Revenue(Water Sales/1000 x Water Rates) t water meters Increase by 2.
<br />WAC Revenue(Serwce Connections x War Charge)
<br />.nue (Service Connections when platted x Connection Charge)
<br />Interest Earnings
<br />Total System Revenue
<br />Trunk Charges returned for John Peterson's Agreement (ihru Dec 2026)
<br />(75L
<br />Internal Loan to offset Muni Center Debt beginning year 2009-2029 2%
<br />PW Land/Building-Internal Loan 2009-2028 @2%
<br />Internal Loan to offset Muni Center Debt beginning year 2011-2030 @,
<br />Internal Loan for RTC Land Purchase
<br />Water Working Capital Balance
<br />Total Annual Expenses
<br />Total System Revenue
<br />Net Income(Loss)
<br />Beginning Water Working Captal Balance
<br />Ending Water Working Capital Balance
<br />160 160 160 160 160 160 160 160 160 160 160 160
<br />998,844,000 1,010,830,128 1,022,960,090 1,035,235,611 1,047,658,438 1,060,230,339 1,072,953,103 1,085,828,541 1,098,858,483 1,112,044,785 1,125,389,322 1,138,893,994
<br />2.51 $ 2.63 $ 2.68 $ 2.14 $ LA $ 2.85 $ 2.90 $ 2.96 $ 3.02 $ 3.08 $ 3.14 $ 3.21
<br />1,261 $ 1,299 $ 1,331 $ 1,365 $ 1,399 $ 1,434 $ 1,410 $ 1,506 $ 1,544 $ 1,583 $ 1,622 $ 1,663
<br />1,220 $ 1,163 $ 1,801 $ 1,852 $ 1,898 $ 1,946 $ 1,994 $ 2,044 $ 2,095 $ 2,148 $ 2,201 $ 2,256
<br />2,146,895 $ 2,200,567 $ 2,255,582 $ 2,311,971 $ 2,369,720 $ 2,429,015 $ 2,489,140 $ 2,5251,984 $ 2,615,783 $ 2,681,178 $ 2,748,207 $ 2,816,912
<br />666,185 $ 207,817 $ 213,012 $ 218,338 $ 223,796 $ 229,391 $ 235,126 $ 241,004 $ 247,029 $ 253,205 $ 259,535 $ 266,023
<br />$ 294,207 $ 297,953 $ 301,793 $ 305,728 $ 309,762 $ 313,897 $ 318,135 $ 322,479 $ 343,635.23 $ 352,226.11 $ 361,031.77
<br />281.730 0 306.667 $ 338.121 $ 368.920 0 369.111 0 403.548 $ 405.293 $ 415.650 $ 451.655 $ 483.397 0 492552 $ 344.971
<br />3,094,810 $ 3,009,259 $ 3,104,668 $ 3,201,022 $ 3,268,472 $ 3,371,716 $ 3,444,056 $ 3,526,773 $ 3,636,946 $ 3,761,414 $ 3,852,520 $ 3,788,938
<br />(13,475) $ (144,375) $ (144,375) $ (144,375) $ (144,375) $ (144,375) $ (144,375) $ (144,375) $ (144,375)
<br />(15 units) (15 units) (15 units) (25 units) (15 units) (15 units) (15 units) (15 units) (25 units) (15 units) (15 units) (15 units)
<br />aid off in2011
<br />34,930 $ 35,629 $ 36,341 $ 37,068 $ 37,810 $ 38,566 $ 39,337 $ 40,124 $ 40,926 $ 41,245 $ 41,745 $ 41,745
<br />61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853
<br />241,504 $ - $ - $ - $ -
<br />(1,415,261) $ (865,432) $ (1,005,191) $ (3,138,442) $ (932,380) $ (3,211,425) $ (2,710,382) $ (1,084,057) $ (1,479,260) $ (1,138,550) $ (13,184,492) $ (12,107,000)
<br />3.419.622 $ 2.962.366 $ 3.058.488 $ 3.155.568 $ 3.223.160 $ 3.327.760 $ 3.400,871 $ 3.484.374 $ 3.595.350 $ 3.865.012 $ 3.956.118 $ 3,892.536
<br />2,004,361 $ 2,096,933 $ 2,053,291 $ 17,126 $ 2,291,380 $ 116,334 $ 690,489 $ 2,400,317 $ 2,116,091 $ 2,726,462 $ (9,228,374) $ (8,214,464)
<br />18.440.114 $ 20.444.475 $ 22.541.408 $ 24.594.699 $ 24.611.825 $ 26.903.205 $ 27.019.539 $ 27.710.028 $ 30.110.345 $ 30.110.345 $ 32.226.436 $ 22.998.062
<br />20,444,475 $ 22,541,408 $ 21,594,699 $ 24,611,825 $ 26,903,205 $ 27,019,539 $ 27,710,028 $ 30,110,345 $ 32,226,436 $ 32,836,807 $ 22,998,062 $ 14,783,599
<br />258
<br />
|