|
Water Utility Fund #601
<br />Actual
<br />Actual
<br />Actual
<br />Actual
<br />Projected
<br />Actual
<br />2009
<br />2010
<br />2011
<br />2012
<br />2013
<br />Projected
<br />2014
<br />Projected
<br />2015
<br />Projected
<br />2016
<br />2017
<br />2018
<br />2019
<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 291 $ (1,000,000)
<br />Internal Loan for RTC Land Purchase-10 Year @ 2% When Land Sold $ (2,334,394)
<br />Internal Loan to offset Muni Center Debt beginning year 2011-2030 @2%
<br />Fire Station #1 Extension of Water
<br />County Radio System (3-Year Funding)
<br />3/4 Ton Truck
<br />Utility Truck
<br />A. Water Supply & Treatment Improvements
<br />2 Renovate Pump House #3
<br />3 Well #1 Rehabilitation
<br />4 Well #7 & 8 $ (69,373)
<br />6 Bonding & Study for Water Treatment Facility (20 yrs @5.0%-$19.575M]
<br />7 Site Acquisition for Water Treatment Plant
<br />8 Water Meter Replacement $ (209,999) $ (210,571) $ (109,665)
<br />Pump House #1 Building Repairs
<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 />8 Alpine Drive-CSAH 5 to Germanium St Watermain
<br />12 River Pines Lift Station Water Connection
<br />17 General Infrastructure Needs
<br />D. Distribution System Maintenance Improvements
<br />Watermain Looping Bunker Lake Blvd
<br />Watermain Looping Sunfish Lake Blvd
<br />Watermain Looping Ramsey Boulevard to Traprock
<br />Bunker/Puma Water Trunk Extension
<br />Sunfish Lake Blvd/Alpine Drive Intersection Sign $ (62,995)
<br />Watermain Sunwood Drive Realignment $ (347,540)
<br />Garnet Street Reconstruction Improvement $ (170,000)
<br />6 Watermain Looping (Riverdale Drive Project-Traprock to Armstro ng) $ (841,725)
<br />$ (55,000)
<br />$ (1,700) $ (1,700) $ (1,700)
<br />$ (60,000)
<br />$ (32,000) $
<br />(35,000) $
<br />$ (350,000)
<br />$ (400,000)
<br />$ (700,000)
<br />$ (1,000,000)
<br />Subtotal- Capital Expenses $ (6,873,666) $ (1,424,072) $ (1,172,660) $
<br />$ (83,000)
<br />$ (47,250)
<br />$ (25,000)
<br />(38,000) $ (41,000) $ (44,000)
<br />$
<br />$ (2,000,000)
<br />$ (1,300,000)
<br />$ (20,000)
<br />$ (450,000)
<br />(1,552,250) $ (1,552,250)
<br />(1,000,000)
<br />$ (1,300,000)
<br />$ (347,540) $ (924,725) $ (202,000) $ (1,545,000) $ (3,808,000) $ (3,893,250) $ (1,596,250)
<br />Operational Expenses
<br />Operating Expense -Distribution and Administration $ (603,685) $ (792,870) $ (785,299) $ (700,562) $ (704,375) $ (725,506) $ (747,271) $ (769,689) $ (792,780) $ (816,563) $ (841,060)
<br />Operating Expense -Treatment $ - $ - $ - $ (671,353) $ (691,494)
<br />Subtotal -Operating Expense $ (603,685) $ (792,870) $ (785,299) $ (700,562) $ (704,375) $ (725,506) $ (747,271) $ (769,689) $ (792,780) $ (1,487,916) $ (1,532,554)
<br />Total Annual Expenses $ (7,477,351) $ (2,216,942) $ (1,957,959) $ (700,562) $ (1,051,915) $ (1,650,231) $ (949,271) $ (2,314,689) $ (4,600,780) $ (5,381,166) $ (3,128,804)
<br />Water System Revenue
<br />1 Impact Study 10/05 reduced by 200-300 units per year to be conservative) 895 784 900 502 394 369 100 100 100 100 100
<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 1,269,000
<br />Water rates ($/1000gal)(5% annual increase) $ 2.05 $ 2.16 $ 2.27 $ 2.38 $ 2.38 $ 2.43 $ 2.47 $ 2.52 $ 2.57 $ 2.70 $ 2.83
<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 $ 1,331
<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 $ 1,807
<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,917,708 $ 1,845,000 $ 1,891,125 $ 1,939,916 $ 1,985,339 $ 2,044,899 $ 2,106,246
<br />WAC Revenue(Service Connections x Wac Charge) $ 77,850 $ 165,406 $ 83,349 $ 490,360 $ 242,228 $ 77,682 $ 120,612 $ 123,627 $ 126,718 $ 129,886 $ 133,133
<br />nk Charge Revenue (Service Connections when platted x Connection Charge) $ 10,600 $ 79,711 $ - $ 523,999 $ 139,711 $ 81,213 $ 177,115 $ 177,935 $ 178,775 $ 224,440 $ 224,440
<br />Interest Earnings $ 459,839 $ 306,955 $ 267,790 $ 157,107 $ (213,783) $ 182,140 $ 193,735 $ 214,501 $ 215,896 $ 183,771 $ 144,994
<br />Total System Revenue $ 2,241,870 $ 2,185,533 $ 2,171,269 $ 3,237,902 $ 2,085,864 $ 2,186,035 $ 2,382,587 $ 2,455,979 $ 2,506,728 $ 2,582,996 $ 2,608,812
<br />Trunk Charges returned for John Peterson's Agreement $ - $ (144,375) $ (144,375) $ (144,375) $ (144,375) $ (144,375)
<br />(75 units) (75 units) (75 units) (45 units) (45 units)
<br />Internal Loan to offset Muni Center Debt beginning year 2009-202921 $ 80,243 $ 80,243 $ 956,762
<br />PW Land/Building-Internal Loan 2009-2029 @2% $ 59,527 $ 59,527 $ 43,093 $ 31,637 $ 32,270 $ 32,915 $ 33,574 $ 34,245 $ 34,930 $ 35,629 $ 36,341
<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 $ 61,853
<br />Internal Loan for RTC Land Purchase-10 Year @ 2% When Land Sold $ 37,442 $ - $ 142,444 $ - $ - $ - $ 259,880 $ 259,880
<br />Water Working Capital Balance
<br />Total Annual Expenses $ (7,477,351) $ (2,216,942) $ (1,957,959) $ (700,562) $ (1,051,915) $ (1,650,231) $ (949,271) $ (2,314,689) $ (4,600,780) $ (5,381,166) $ (3,128,804)
<br />Total System Revenue $ 2,381,640 $ 2,325,303 $ 3,232,977 $ 3,368,834 $ 2,179,987 $ 2,423,247 $ 2,333,639 $ 2,407,702 $ 2,459,136 $ 2,795,983 $ 2,822,512
<br />Net Income(Loss) $ (5,095,711) $ 108,361 $ 1,275,018 $ 2,668,272 $ 1,128,073 $ 773,017 $ 1,384,368 $ 93,013 $ (2,141,644) $ (2,585,183) $ (306,292)
<br />Beginning Water Working Capital Balance $ 12,058,651 $ 6,962,941 $ 7,071,302 $ 8,346,320 $ 11,014,592 $ 12,142,664 $ 12,915,681 $ 14,300,049 $ 14,393,061 $ 12,251,417 $ 9,666,234
<br />Remaining Ending Water Working Capital Balance $ 6,962,941 $ 7,071,302 $ 8,346,320 $ 11,014,592 $ 12,142,664 $ 12,915,681 $ 14,300,049 $ 14,393,061 $ 12,251,417 $ 9,666,234 $ 9,359,942
<br />*** This fund is created to offset the repairs of lines. The city currently has over $24,000,000 of sewer lines (per 2013 audit
<br />which includes $7.1M of accum depr
<br />Page 206
<br />
|