|
Water Utility Fund #601
<br />Capital Expenses -Equipment
<br />CIP Projects
<br />Fire Station #1 Extension of Water
<br />County Radio System (3-Year Funding)
<br />Public Works Campus
<br />Sada System Software Upgrades
<br />Backhoe (portion of cost)
<br />3/4 Ton Truck
<br />Utility Truck
<br />A. Water Supply& Treatment Improvements
<br />Renovate Pump House #3
<br />Construct Well #9& Pumphouse #5
<br />Well #1 Rehabilitation (Not in CIP Maintenance)
<br />Emergency Supply for Well #3
<br />Water Treatment Facility 10 MGD Groundwater
<br />Refurbish Water Tower#1
<br />Refurbish Water Tower#2
<br />Maintain Water Tower #3 (Not in CI as maintenance)
<br />Watermain- Alpine Drive
<br />Watermain- Bunker/Puma (Riverstone Proj)
<br />Act Actual
<br />201)
<br />Projected
<br />2018
<br />Projected
<br />2019
<br />Projected
<br />2020
<br />Projected
<br />2021
<br />Projected
<br />2022
<br />Projected
<br />2023
<br />Projected
<br />2024
<br />Projected
<br />2025
<br />Projected
<br />2026
<br />Projected Projected
<br />2027
<br />2028
<br />(518,567)
<br />$ (55,000)
<br />$ (1,715,750)
<br />(15,000)
<br />$ (15,625)
<br />$ (43,000)
<br />(25,000) $ (24,000)
<br />$ (70,000)
<br />$ (75,000) (1,700,000)
<br />(41,000) $ (44,000) $ (47,000) (50,000) (53,000) (56,000)
<br />$ (700,000)
<br />$ (1,300,000)
<br />(75,000)
<br />(32,500)
<br />(59,000)
<br />(39,000)
<br />(62,000) (65,000) (68,000) (68,000)
<br />(385,000)
<br />(12,000,000) (12,000,000)
<br />Watermain Looping Ramsey Boulevard to Traprock (142,432)
<br />Cor Bunker Lake Blvd ( Armstrong to Ramsey Blvd) (340,000)
<br />Ford Brook Estates Reconstruction $ (30,762)
<br />Zeolite Street Improvement $ (185,000)
<br />Garnet Street Reconstruction Improvement
<br />Bolton &Menk 2017 Water Study 2021 to 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) $ (784,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 $ - $ - $ -
<br />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,051) $ (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 ($/1000 gal)(5% annual increase)
<br />Water Availability Charge (WAC) ($/connection)()
<br />onnecti on/Trunk Charge($/connection)(4.5% after year 2005)
<br />ate Revenue(Water Sales/1000 x Water Rates)♦water meters Increase by 2.
<br />WAC Revenue(Service Connections x Wac Charge)
<br />.nue (service Connections when platted x Connection Charge)
<br />Interest Earnings
<br />Total System Revenue
<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 $ 2.19 $ 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,120 $ 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,110 $ 2,429,015 $ 2,489,740 $ 2,551,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.11
<br />281,730 $ 306,667 $ 338,121 $ 368,920 $ 369,111 $ 403,548 $ 405,293 $ 415,650 $ 451,655 $ 483,397 $ 492,552 $ 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,113 $ 3,636,946 $ 3,761,414 $ 3,852,520 $ 3,788,938
<br />Trunk Charges returned for John Peterson's Agreement (thru Dec 2026) (13,475) $ (144,375) $ (144,375) $ (144,375) $ (144,375) $ (144,375) $ (144,375) $ (144,375) $ (144,375)
<br />(15 L (15 units) (15 units) (15 units) (15 units) (15 units) (15 units) (15 units) (75 units) (15 units) (15 units) (15 units) (15 units)
<br />Internal Loan to offset Muni Center Debt beginning year 2009-2029 2% Paid off in 2011
<br />PW Land/Building-Internal Loan 2009-2028 @2% $ 34,930 $ 35,629 $ 36,341 $ 37,068 $ 37,810 $ 38,566 $ 39,337 $ 40,124 $ 40,926 $ 41,745 $ 41,745 $ 41,745
<br />Internal Loan to offset Muni Center Debt beginning year 2011-2030 @', $ 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 />Internal Loan for RTC land Purchase $ 241,504 $ - $ - $ - $
<br />WaterWorkingCapitalBalance
<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,057) $ (1,479,260) $ (1,138,550) $ (13,184,492) $ (12,107,000)
<br />Total System Revenue $ 3,419,622 $ 2,962,366 $ 3,058,488 $ 3,155,568 $ 3,223,760 $ 3,327,760 $ 3,400,871 $ 3,484,374 $ 3,595,350 $ 3,865,012 $ 3,956,118 $ 3,892,536
<br />Netlncome(Loss) $ 2,004,361 $ 2,096,933 $ 2,053,291 $ 11,126 $ 2,291,380 $ 116,334 $ 690,489 $ 2,400,317 $ 2,116,091 $ 2,726,462 $ (9,228,374) $ (8,214,464)
<br />Beginning Water Working Capital Balance $ 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 />Ending Water Working Capital Balance $ 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 />
|