|
Water Utility Fund 8601
<br />Actual Actual Actual Projected Projected Projected Projected
<br />2009
<br />2010
<br />2011
<br />2012
<br />2013
<br />2014
<br />2015
<br />Projected Projected
<br />2016
<br />2017
<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%
<br />Internal Loan for RTC Land Purchase-10 Year @ 2% When Land Sold
<br />Internal Loan to offset Muni Center Debt beginning year 2011-2030 @2%
<br />Utility Truck
<br />A. Water Supply & Treatment Improvements
<br />1 Renovate Pump House 82
<br />2 Renovate Pump House 03
<br />Well house I Improvements
<br />3 Well H1 Rehabilitation
<br />4 Well Jt7&8 $ (69,373)
<br />6 Bonding & Study for Water Treatment Facility (20 yrs @5.09S $18.4M)
<br />7 Site Acquisition for Water Treatment Plant
<br />8 Water Meter Replacement $ (209,999) $ (210,571) $ (109,665) $ (249,200)
<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 />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 131 Extension of Water
<br />9 Oak Park Terrace
<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 />Sunfish Lake Blvd/Alpine Drive Intersection Sign
<br />6 Watermain Looping Ramsey Blvd Armstrong Blvd
<br />Subtotal - Capital Expenses
<br />Operational Expenses
<br />Operating Expense -Distribution and Administration
<br />Operating Expense -Treatment
<br />Subtotal -Operating Expense
<br />$ (1,000,000)
<br />$ (2,334,394)
<br />$ (1,000,000)
<br />$ (62,995)
<br />$ (25,000)
<br />$ (49,000)
<br />$ (60,000)
<br />$ (50,000) $ (58,000) $ (30,000) $ (32,000) $ (35,000) $ (38,000)
<br />$ (30,000)
<br />$ (1,457,182) $ (1,457,182)
<br />$ (1,000,000)
<br />$ (2,000,000)
<br />$ (100,000)
<br />$ (250,000) $ (250,000) $ (250,000) $ (250,000) $
<br />$ (521,000)
<br />$ (225,000)
<br />(250,000) $
<br />$ (350,000)
<br />(20,000)
<br />(250,000)
<br />$ (6,873,666) $ (1,424,072) $ (1,172,660) $ (579,200) $ (829,000) $ (605,000) $ (3,282,000) $ (2,092,182) $ (1,874,182)
<br />$ (603,685) $ (792,870) $ (801,733) $ (922,943) $ (950,631) $ (979,150) $ (1,008,525) $ (1,038,780) $ (1,069,944)
<br />$ (579,115) $ (596,489) $ (614,383) $ (632,815) $ (651,799)
<br />$ (603,685) $ (792,870) $ (801,733) $ (922,943) $ (1,529,746) $ (1,575,639) $ (1,622,908) $ (1,671,595) $ (1,721,743)
<br />Total Annual Expenses $ (7,477,351) $ (2,216,942) $ (1,974,393) $ (1,502,143) $ (2,358,746) $ (2,180,639) $ (4,904,908) $ (3,763,777) $ (3,595,925)
<br />Water System Revenue
<br />al Impact Study 10/05 reduced by 200-300 units per year to be conservative)) 895 784
<br />Water Sales (gallons/year) 923,993,850 973,353,713
<br />Water rates($/100ogal)(5% annual increase) $ 2.05 $ 2.16
<br />Water Availability Charge (WAC) ($/connection)() $ 1,557 $ 1,627
<br />Connection/Trunk Charge ($/connection)(4.5% after year 2005) $ 2,113 $ 2,209
<br />Water Rate Revenue(Water Sales/1000 x Water Rates) water meters $ 1,693,581 $ 1,633,461
<br />WAC Revenue(Service Connectionsx Wac Charge) $ 77,850 $ 165,406
<br />unk Charge Revenue (Service Connections when platted x Connection Charge) $ 10,600 $ 79,711
<br />Interest Earnings $ 459,839 $ 306,955
<br />Total System Revenue $ 2,241,870 $ 2,185,533
<br />900 502
<br />975,000,000 975,000,000
<br />$ 2.27 $ 2.38
<br />$ 1,701 $ 1,640
<br />$ 2,308 $ 2,226
<br />$ 1,820,130 $ 1,888,402
<br />$ 83,349 $ 200,000
<br />$ - $ 100,000
<br />$ 267,790 $ 125,195
<br />$ 2,171,269 $ 2,313,597
<br />394 369 301 160
<br />975,000,000 975,000,000 975,000,000 1,269,000
<br />$ 2.38 $ 2.50 $ 2.62 $ 2.75
<br />$ 1,681 $ 1,723 $ 1,766 $ 1,810
<br />$ 2,282 $ 2,339 $ 2,397 $ 2,457
<br />$ 1,888,402 $ 1,945,054 $ 2,003,406 $ 2,063,508
<br />$ 200,000 $ 200,000 $ 200,000 $ 289,641
<br />$ 100,000 $ 100,000 $ 100,000 $ 393,134
<br />$ 138,586 $ 140,828 $ 146,626 $ 112,521
<br />$ 2,326,988 $ 2,385,882 $ 2,450,031 $ 2,858,804
<br />160
<br />1,269,000
<br />2.89
<br />1,856
<br />2,519
<br />2,125,413
<br />296,882
<br />402,962
<br />101,666
<br />2,926,923
<br />Trunk Charges returned for John Peterson's Agreement $ (300,000) $ (200,000) $ (200,000) $ (200,000) $ (200,000) $ (100,000)
<br />(384 units) (348 units) (271 units) (242 units) (195 units) (170 units) (187 units) (130 units) (45 units) Net of $6 m
<br />Internal Loan to offset Muni Center Debt beginning year 2009-2029 2% Paid off i $ 80,243 $ 80,243 $ 956,762 until 2028
<br />PW land/Building-Internal Loan 2009-2029 @2% $ 59,527 $ 59,527 $ 59,527 $ 59,527 $ 59,527 $ 59,527 $ 59,527 $ 59,527 $ 59,527 until 2028
<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 until 2029
<br />Internal Loan for RTC Land Purchase-10 Vear @ 2% When Land Sold $ 259,880 $ 259,880 $ 259,880 $ 259,880 $ 259,880 $ 259,880
<br />Water Working Capital Balance Profit
<br />Total Annual Expenses $ (7,477,351) $ (2,216,942) $ (1,974,393) $ (1,502,143) $ (2,358,746) $ (2,180,639) $ (4,904,908) $ (3,763,777) $ (3,595,925)
<br />Total System Revenue $ 2,381,640 $ 2,325,303 $ 3,249,411 $ 2,394,857 $ 2,508,248 $ 2,567,142 $ 2,631,291 $ 3,040,064 $ 3,208,183
<br />Net Income(Loss) $ (5,095,711) $ 108,361 $ 1,275,018 $ 892,714 $ 149,501 $ 386,503 $ (2,273,617) $ (723,713) $ (387,742)
<br />Beginning Water Working Capital Balance $ 12,058,651 $ 6,962,941 $ 7,071,302 $ 8,346,320 $ 9,239,034 $ 9,388,535 $ 9,775,038 $ 7,501,421 $ 6,777,708
<br />Ending Water Working Capital Balance $ 6,962,941 $ 7,071,302 $ 8,346,320 $ 9,239,034 $ 9,388,535 $ 9,775,038 $ 7,501,421 $ 6,777,708 $ 6,389,966
<br />PAGE 312
<br />
|