|
Water Utility Fund #601
<br />Actual
<br />Projected
<br />Actual
<br />2009
<br />Actual
<br />2010
<br />2011
<br />Actual
<br />2012
<br />Projected
<br />2013
<br />2014
<br />Projected
<br />2015
<br />Projected
<br />2016
<br />Projected
<br />2017
<br />2018
<br />Capital Expenses -Equipment
<br />CIP Projects
<br />PW Land/Building
<br />PW Land/Building-Internal Loan 2009-2029 @2%
<br />Internal Loan to offset Muni Center Debt beginning year 2009-2029 2% $ (1,000,000)
<br />Internal Loan for RTC Land Purchase-l0Year @ 2%When Land Sold $ (2,334,394)
<br />Internal Loan to offset Muni Center Debt beginning year 2011-2030 @2%
<br />1-Ton Truck with Boom
<br />Utility Truck
<br />A. Water Supply & Treatment Improvements
<br />1 Renovate Pump House #2
<br />2 Renovate Pump House #3
<br />Well house I Improvements
<br />3 Well #1 Rehabilitation
<br />4 Well #7 & 8 $ (69,373)
<br />6 Bonding & Study for Water Treatment Facility (20 yrs @5.0%-$18.4M] $ (1,457,182) $ (1,457,182)
<br />7 Site Acquisition for Water Treatment Plant $ (1,000,000)
<br />8 Water Meter Replacement $ (209,999) $ (210,571) $ (109,665)
<br />Pump House #1 Building Repairs $ (20,000)
<br />B. Water Storage Improvements
<br />1 1.5 MG Ground Storage Reservoir
<br />2 2.00 MG Elevated Storage Reservoir (Elmcrest Park) $ (2,176,853) $ (1,213,501)
<br />3 2.00 MG Elevated Storage Reservoir (Elmcrest Park) Site Land $ (768,513)
<br />Refurbish Water Tower #1
<br />Refurbish Water Tower #2
<br />C. Distribution System Improvements
<br />2 Alpine Park to Regency Pond $ (314,533)
<br />5 NE & NW S&W Ext
<br />8 Alpine Drive-CSAH 5 to Germanium St Watermain
<br />Magnesium St Watermain Looping
<br />Fire Station #1 Extension of Water
<br />9 Oak Park Terrace
<br />12 River Pines Lift Station Water Connection $ (20,000)
<br />17 General Infrastructure Needs $ (250,000)
<br />D. Distribution System Maintenance Improvements
<br />Watermain Looping Bunker Lake Blvd $ (350,000)
<br />Watermain Looping Sunfish Lake Blvd $ (350,000)
<br />Sunfish Lake Blvd/Alpine Drive Intersection Sign $ (62,995)
<br />Watermain Sunwood Drive Realignment $ (347,540)
<br />6 Watermain Looping Ramsey Blvd Armstrong Blvd $ (521,000)
<br />Subtotal- Capital Expenses $ (6,873,666) $ (1,424,072) $ (1,172,660) $ $ (405,540) $ (671,000) $ (1,032,000) $ (735,000) $ (4,815,182) $ (1,707,182)
<br />$ (49,000)
<br />$ (33,877) $ (25,000)
<br />$ (58,000) $ (30,000) $ (32,000) $ (35,000) $ (38,000)
<br />$ (100,000)
<br />$ (2,000,000)
<br />$ (1,300,000)
<br />Operational Expenses
<br />Operating Expense -Distribution and Administration $ (603,685) $ (792,870) $ (785,299) $ (700,562) $ (950,631) $ (979,150) $ (1,008,525) $ (1,038,780) $ (1,069,944) $ (1,102,042)
<br />Operating Expense -Treatment $ - $ - $ - $ (651,799) $ (671,353)
<br />Subtotal -Operating Expense $ (603,685) $ (792,870) $ (785,299) $ (700,562) $ (950,631) $ (979,150) $ (1,008,525) $ (1,038,780) $ (1,721,743) $ (1,773,395)
<br />Total Annual Expenses $ (7,477,351) $ (2,216,942) $ (1,957,959) $ (700,562) $ (1,356,171) $ (1,650,150) $ (2,040,525) $ (1,773,780) $ (6,536,925) $ (3,480,577)
<br />Water System Revenue
<br />d Impact Study 10/05 reduced by 200-300 units per year to be conservative) 895 784 900 502 394 369 301 160 160 160
<br />Water Sales (gallons/year) 923,993,850 973,353,713 975,000,000 975,000,000 975,000,000 975,000,000 975,000,000 1,269,000 1,269,000 1,269,000
<br />Water rates ($/1000ga1)(5%annual increase) $ 2.05 $ 2.16 $ 2.27 $ 2.38 $ 2.38 $ 2.43 $ 2.48 $ 2.53 $ 2.58 $ 2.71
<br />Water Availability Charge (WAC) ($/connection)() $ 1,557 $ 1,627 $ 1,701 $ 1,640 $ 1,148 $ 1,177 $ 1,206 $ 1,236 $ 1,267 $ 1,299
<br />Connection/Trunk Charge ($/connection)(4.5% after year 2005) $ 2,113 $ 2,209 $ 2,308 $ 2,226 $ 1,558 $ 1,597 $ 1,637 $ 1,678 $ 1,720 $ 1,763
<br />Water Rate Revenue(Water Sales/1000 x Water Rates)+ water meters $ 1,693,581 $ 1,633,461 $ 1,820,130 $ 2,066,436 $ 1,800,000 $ 1,845,000 $ 1,891,125 $ 1,939,916 $ 1,985,339 $ 2,044,899
<br />WAC Revenue(Service Connections x Wac Charge) $ 77,850 $ 165,406 $ 83,349 $ 490,360 $ 225,000 $ 200,000 $ 200,000 $ 197,803 $ 202,748 $ 207,817
<br />nk Charge Revenue (Service Connections when platted x Connection Charge) $ 10,600 $ 79,711 $ - $ 523,999 $ 130,329 $ 224,440 $ 177,115 $ 177,935 $ 178,775 $ 224,440
<br />Interest Earnings $ 459,839 $ 306,955 $ 267,790 $ 157,107 $ 165,219 $ 181,505 $ 192,450 $ 198,408 $ 209,167 $ 149,409
<br />Total System Revenue $ 2,241,870 $ 2,185,533 $ 2,171,269 $ 3,237,902 $ 2,320,548 $ 2,450,945 $ 2,460,690 $ 2,514,062 $ 2,576,029 $ 2,626,565
<br />Trunk Charges returned for John Peterson's Agreement $ - $ (192,500) $ (144,375) $ (144,375) $ (144,375) $ (144,375)
<br />100 Units (75 units) (75 units) (75 units) (45 units)
<br />Internal Loan to offset Muni Center Debt beginning year 2009-2029 2% Paid off in 201J $ 80,243 $ 80,243 $ 956,762
<br />PW Land/Building-Internal Loan 2009-2029 @2% $ 59,527 $ 59,527 $ 43,093 $ 31,637 $ 59,527 $ 59,527 $ 59,527 $ 59,527 $ 59,527 $ 59,527
<br />internal Loan to offset Muni Center Debt beginning year 2011-2030 @2% $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853
<br />Internal Loan for RTC Land Purchase-10 Year @ 2% When Land Sold $ 37,442 $ - $ - $ - $ - $ - $ 259,880
<br />Water Working Capital Balance
<br />Total Annual Expenses $ (7,477,351) $ (2,216,942) $ (1,957,959) $ (700,562) $ (1,356,171) $ (1,650,150) $ (2,040,525) $ (1,773,780) $ (6,536,925) $ (3,480,577)
<br />Total System Revenue $ 2,381,640 $ 2,325,303 $ 3,232,977 $ 3,368,834 $ 2,441,928 $ 2,379,825 $ 2,437,695 $ 2,491,067 $ 2,553,034 $ 2,863,450
<br />Net Income(Loss) $ (5,095,711) $ 108,361 $ 1,275,018 $ 2,668,272 $ 1,085,757 $ 729,675 $ 397,171 $ 717,287 $ (3,983,890) $ (617,127)
<br />Beginning Water Working Capital Balance $ 12,058,651 $ 6,962,941 $ 7,071,302 $ 8,346,320 $ 11,014,592 $ 12,100,348 $ 12,830,023 $ 13,227,194 $ 13,944,481 $ 9,960,590
<br />Ending Water Working Capital Balance $ 6,962,941 $ 7,071,302 $ 8,346,320 $ 11,014,592 $ 12,100,348 $ 12,830,023 $ 13,227,194 $ 13,944,481 $ 9,960,590 $ 9,343,463
<br />*** This fund is created to offset the repairs of lines. The city currently has over $24,000,000 of sewer lines (per 2012 audit
<br />which includes $6.5M of accum depr
<br />Page 315
<br />
|