|
Water Utility
<br />Actual
<br />Actual Actual
<br />2008 2009 2010 2011 2012 2013 2014 2015 2016
<br />Capital Expenses- Equipment
<br />CIP Projects
<br />PW Land /Building $ (292 250)
<br />PW Land/Building- Internal Loan to General Fund 20 years 5% $ (719,774)
<br />Internal Loan to offset Muni Center Debt beginning year 2010 20 years 5% $ (1,000,000)
<br />Internal Loan for RTC Land Purchase $ (2,334,394)
<br />Internal Loan to offset Muni Center Debt beginning year 2012 20 years 5% $ (1,000,000)
<br />Utility Truck $ (25,000)
<br />A. Water Supply & Treatment Improvements
<br />1 Renovate Pump House #2 $ (49,000)
<br />2 Renovate Pump House #3 $ (60,000)
<br />Well house I Improvements $ (141,443) $ (30,000)
<br />3 Well #1 Rehabilitation $ (50,000) $ (58,000) $ (30,000) $ (32,000)
<br />4 Well #7 & 8 $ (158,623) $ (69,373)
<br />6 Bonding & Study for Water Treatment Facility (20 yrs @5.0 % -$18.4M) $ (1,457,182) $ (1,457,182) $ (1,457,182)
<br />7 Site Acquisition for Water Treatment Plant $ (1,000,000)
<br />8 Water Meter Replacement $ (212,052) $ (209,999) $ (210,571) $ (237,300) $ (249,200)
<br />B. Water Storage Improvements
<br />1 1.5 MG Ground Storage Reservoir $ (2,000,000)
<br />2 2.00 MG Elevated Storage Reservoir (Elmcrest Park) $ (49,925) $ (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 Po_ nd $ (1,143) $ (314,533)
<br />5 NE & NW S &W Ext $ (39,280)
<br />8 Alpine Drive -CSAH 5 to Germanium St Watermain $ (100,000)
<br />Magnesium St Watermain Looping $ (120,000)
<br />Fire Station #1 Extension of Water $ (25,000)
<br />9 Oak Park Terrace $ (15,000)
<br /># River Pines Lift Station Water Connection - $ (20,000)
<br /># General Infrastructure Needs $ (250,000) $ (250,000) $ (250,000) $ (250,000) $ (250,000) $ (250,000)
<br />D. Distribution System Maintenance Improvements
<br />Watermain Looping Bunker Lake Blvd $ (225,000)
<br />Waterrnain Looping Sunfish Lake Blvd $ (350,000)
<br />Sunfish Lake Blvd/Alpine Drive Intersection Sign $ (105,000)
<br />6 Watermain Looping Ramsey Blvd Armstrong Blvd $ (273,000)
<br />Subtotal - Capital Expenses $ ' (1,614,490) $ (6,873,666) $ (1,424,072) $ (1,607,300) $ (949,200) $ (3,581,000) $ (1,857,182) $ (1,764,182) $ (2,166,182)
<br />Operational Expenses
<br />Operating Expense- Distribution and Administration $ (753,600) $ (603,685) $ (792,870) $ (772,500) $ 795,675 $ 819,545 $ 844,131 $ 869,455 $ (1,386,393)
<br />Operating Expense- Treatment $ (579,115) $ (596,489) $ (614,383) $ (632,815)
<br />Subtotal - Operating Expense $ (753,600) $ (603,685) $ (792,870) $ (772,500) $ 795,675 $ 240,430 $ 247,642 $ 255,072 $ (2,019,208)
<br />Total Annual Expenses $ (2,368,090) $ (7,477,351) $ (2,216,942) $ (2,379,800) $ (153,525) $ (3,340,570) $ (1,609,540) $ (1,509,110) $ (4,185,390)
<br />Water System Revenue
<br />'Fiscal Impact Study 10/05 reduced by 200 -300 units per year to be conservative)) 816 895 784 900 502 394 369 301 160
<br />Water Sales (gallons /year)- 874,633,9886 923,993,850 973,353,713 975,000,000 975,000,000 975,000,000 975,000,000 975,000,000 1,269,477,300
<br />Water rates ($/1000 gal)(5 %annual increase) $ 1.96 $ 2.05 $ 2.16 $ 2.27 $ 2.38 $ 2.50 $ 2.62 $ 2.75 $ 2.89
<br />Water Availability Charge (WAC) ($ /connection)(4.5% annual increase) $ 1,490 $ 1,557 $ 1,627 $ 1,701 $ 1,777 $ 1,821 $ 1,867 $ 1,914 $ 1,962
<br />Connection /Trunk Charge ($/connection)(4.5% after year 2005) $ 2,022 $ 2,113 $ 2,209 $ 2,308 $ 2,412 $ 2,472 $ 2,534 $ 2597 $ 2,662
<br />Water Rate Revenue(Water Sales /1000 x Water Rates) + water meters $ 1,539,665 $ 1,693581 1,633,461 $ 1,833,400 $ 1,888,402 $ 1,945,054 $ 2,003,406 $ 2,063, $ 3,670,476
<br />WAC Revenue(Service Connections x Wac Charge) $ 169,932 $ 77,,850 $
<br />$ 165,406 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 313,841
<br />i/Trunk Charge Revenue (Service Connections when platted x Connection Charge) $ 20,220 $ 10,600 $ 79,711 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 425,950
<br />Interest Earnings $ 594,177 $ 459,839 $ 306,955 $ 106,070 $ 109,111 $ 146,418 $ 133,430 $ 147,088 $ 163,359
<br />Total System Revenue $ 2,323,994 $ 2,241,870 $ 2,185,533 $ 2,239,470 $ 2,297,513 $ 2,391,472 $ 2,436,835 $ 2,510,596 $ 4,573,626
<br />Trunk Charges returned to John Peterson $ (100,000) $ (100,000) $ (100,000) $ (100,000) $ (100,000)
<br />(343 units) (384 units) (348 units) (271 units) (242 units) (195 units) (170 units) (187 units) (130 units)
<br />Internal Loan to offset Muni Center Debt beginning year 2009 20 years 5% $ 80,243 $ 80,243 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853
<br />PW Land /building - Internal Loan to General Fund 20 years 5% $ 59,527 $ 59,527 $ 59,527 $ 59,527 $ 59,527 $ 59,527 $ 59,527 $ 59,527
<br />Internal Loan to offset Muni Center Debt beginning year 2011 20 years 2% $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853
<br />Internal Loan for RTC Land 10 year 2% $ 259,880 $ 259,880
<br />- O Water Working Capital Balance
<br />Total Annual Expenses $ (2,368,090) $ (7,477,351) $ (2,216,942) $ (2,379,800) $ (153,525) $ (3,340,570) $ (1,609,540) $ (1,509,110) $ (4,185,390)
<br />m Total System Revenue $ 2,323,994 $ 2,381,640 $ 2,325,303 $ 2,582,583 $ 2,640,626 $ 2,474,705 $ 2,520,068 $ 2,593,829 $ 4,635,479
<br />I w Net Income(Loss) $ (44,096) $ (5,095,711) $ 108,361 $ 202,783 $ 2,487,101 $ (865,865) $ 910,529 $ 1,084,719 $ 450,089
<br />Beginning Water Working Capital Balance $ 12,102,747 $ 12,058,651 $ 6,962,941 $ 7,071,302 $ 7,274,084 $ 9,761,185 $ 8,895,321 $ 9,805,849 $ 10,890,568
<br />Ending Water Working Capital Balance $ 12,058,651 $ 6,962,941 $ 7,071,302 $ 7,274,084 $ 9,761,185 $ 8,895,321 $ 9,805,849 $ 10,890,568 $ 11,340,657
<br />
|