|
Trunk Charges returned to John Peterson
<br />Internal Loan to offset Muni Center Debt beginning year 2009 20 years 5%
<br />PW Land/Building- Internal Loan to General Fund 20 years 5%
<br />Internal Loan to offset Muni Center Debt beginning year 201120 years 2%
<br />Internal Loan for RTC Land 10 year 2%
<br />Water Working Capital Balance
<br />(341 units) (343 units) (384 units) (348 units)
<br />$ 80,243 $ 80,243 $
<br />$ 59,527 $ 59,527 $
<br />(100,000) $
<br />Actual
<br />Actual
<br />Actual
<br />(100,000)
<br />(271 units)
<br />(242 units)
<br />(195 units)
<br />(170 units)
<br />(187 units)
<br />Water Utility
<br />2007
<br />2008
<br />2009
<br />2010
<br />2011
<br />2012
<br />2013
<br />2014
<br />2015
<br />Capital Expenses- Equipment
<br />$ 61,853 $
<br />61,853 $
<br />61,853 $
<br />61,853
<br />259,880
<br />$ 259,880
<br />Beginning Water Working Capital Balance $ 11,015,920 $
<br />12,102,747 $
<br />12,058,651 $
<br />CIP Projects
<br />6,663,680 $
<br />5,698,348
<br />$ 6,360,813
<br />$ 8,520,843
<br />$ 9,425,754
<br />Ending Water Working Capital Balance $ 12,102,747 $
<br />12,058,651 $
<br />6,962,941 $
<br />6,663,680 $
<br />PW Land/Building
<br />$
<br />(292,250)
<br />$ 9,425,754
<br />$ 10,455,772
<br />PW Land/Building-Internal Loan to General Fund 20 years 5%
<br />$
<br />(719,774)
<br />Internal Loan to offset Muni Center Debt beginning year 2010 20 years 5%
<br />$
<br />(1,000,000)
<br />Internal Loan for RTC Land Purchase
<br />$
<br />(2,334,394)
<br />Internal Loan to offset Muni Center Debt beginning year 2012 20 years 5%
<br />$
<br />(1,000,000)
<br />Utility Truck
<br />$
<br />(25,000)
<br />A. Water Supply & Treatment Improvements
<br />-
<br />1 Renovate Pump House #2
<br />-
<br />$
<br />(49,000)
<br />2 Renovate Pump House #3
<br />$
<br />(60,000)
<br />Well house I Improvements
<br />$
<br />(141,443)
<br />$
<br />(8,000)
<br />3 Well #1 Rehabilitation
<br />$
<br />(22,000) $
<br />(24,000) $
<br />(26,000) $
<br />(28,000) $
<br />(30,000) $
<br />(32,000)
<br />4 Well #7&8 $
<br />(315,477) $
<br />(158,623) $
<br />(69,373)
<br />6 Bonding & Study for Water Treatment Facility (20 yrs @5.0 %- $18.4M) $
<br />(273,855)
<br />$
<br />(1,457,182) $
<br />(1,457,182)
<br />7 Site Acquisition for Water Treatment Plant
<br />$
<br />(1,000,000)
<br />8 Water Meter Replacement
<br />$
<br />(212,052) $
<br />(209,999) $
<br />(226,000) $
<br />(237,300) $
<br />(249,200)
<br />B. Water Storage Improvements
<br />1 1.5 MG Ground Storage Reservoir
<br />$
<br />(2,000,000)
<br />2 2.00 MG Elevated Storage Reservoir (Elmcrest Park)
<br />$
<br />(49,925) $
<br />(2,176,853) $
<br />(1,500,000)
<br />3 2.00 MG Elevated Storage Reservoir (Elmcrest Park) Site Land
<br />$
<br />(768,513)
<br />C. Distribution System Improvements
<br />2 Alpine Park to Regency Pond
<br />$
<br />(1,143) $
<br />(314,533)
<br />5 NE & NW S&W Ext $
<br />(307,106) $
<br />(39,280)
<br />8 Alpine Drive -CSAH 5 to Germanium St Watermain
<br />-
<br />$
<br />(100,000)
<br />C.R. 57 ?Alpine Drive Watermain Looping
<br />Magnesium St Watermain Looping
<br />$
<br />(35,000)
<br />Fire Station #1 Extension of Water
<br />$
<br />(35,000)
<br />9 Oak Park Terrace
<br />$
<br />(15,000)
<br /># Elmcrest Park Water
<br />$
<br />(20,000)
<br /># River Pines Lift Station Water Connection
<br />$
<br />(20,000)
<br /># Scada System
<br />$
<br />(21,000)
<br /># Sunfish Lake Estates to Fox Knoll
<br /># General Infrastructure Needs
<br />$
<br />(250,000) $
<br />(250,000) $
<br />(250,000) $
<br />(250,000) $
<br />(250,000)
<br />D. Distribution System Maintenance Improvements
<br />1 South Highway 10 Frontage Road
<br />167th Avenue Extenstion
<br />Watermain Looping Bunker Lake Blvd
<br />$ -
<br />(225,000)
<br />Sunfish Lake Blvd /Alpine Drive Intersection Sign
<br />$
<br />(105,000)
<br />6 Watermain Looping Ramsey Blvd Armstrong Blvd
<br />$
<br />(226,100)
<br />Subtotal - Capital Expenses $
<br />(896,438) $
<br />(1,614,490) $
<br />(6,873,666) $
<br />(1,789,000) $
<br />(2,769,300) $
<br />(2,750,200) $
<br />(504,100) $
<br />(1,857,182) $
<br />(1,813,182)
<br />Operational Expenses
<br />Operating Expense- Distribution and Administration $
<br />(512,889) $
<br />(753,600) $
<br />(603,685) $
<br />(750,000) $
<br />(772,500) $
<br />795,675 $
<br />819,545 $
<br />844,131 $
<br />869,455
<br />Operating Expense- Treatment
<br />$
<br />(579,115) $
<br />(596,489) $
<br />(614,383)
<br />Subtotal -Operating Expense $
<br />(512,889) $
<br />(753,600) $
<br />(603,685) $
<br />(750,000) $
<br />(772,500) $
<br />795,675 $
<br />240,430 $
<br />247,642 $
<br />255,072
<br />Total Annual Expenses $
<br />(1,409,327) $
<br />(2,368,090) $
<br />(7,477,351) $
<br />(2,539,000) $
<br />(3,541,800) $
<br />(1,954,525) $
<br />(263,670) $
<br />(1,609,540) $
<br />(1,558,110)
<br />Water System Revenue
<br />-
<br />i Fiscal Impact Study 10/05 reduced by 200 -300 units per year to be conservative))
<br />710
<br />816
<br />895
<br />784
<br />900
<br />502
<br />394
<br />369
<br />301
<br />Water Sales (gallons /year)
<br />825,274,125
<br />874,633,988
<br />923,993,850
<br />973,353,713
<br />975,000
<br />975,000,000
<br />975,000,000
<br />975,000,000
<br />975,000,000
<br />Water rates ($/1000 gal)(5% annual increase) $
<br />1.86 $
<br />1.96 $
<br />2.05 $
<br />2.16 $
<br />2.27 $
<br />2.38 $
<br />2.50 $
<br />2.62 $
<br />2.75
<br />Water Availability Charge (WAC) ($ /connection)(4.5 %annual increase) $
<br />1,454 $
<br />1 $
<br />1,557 $
<br />1,627 $
<br />1,701 $
<br />1,777 $
<br />1,821 $
<br />1,867 $
<br />1,914
<br />Connection /Trunk Charge ($ /connection)(4.5 %after year 2005) $
<br />1,973 $
<br />2,022 $
<br />2,113 $
<br />2,209 $
<br />2,308 $
<br />2,412 $
<br />2,472 $
<br />2,534 $
<br />2,597
<br />Water Rate Revenue(Water Sales /1000 x Water Rates) +water meters $
<br />1,438,893 $
<br />1,539,665 $
<br />1,693,581 $
<br />1,780,000 $
<br />1,833,400 $
<br />1,888,402 $
<br />1,945,054 $
<br />2,003,406 $
<br />2,063,508
<br />WAC Revenue(Service Connections x Wac Charge) $
<br />400,050 $
<br />169,932 $
<br />77,850 $
<br />160,525 $
<br />200,000 $
<br />200,000 $
<br />200,000 $
<br />200,000 $
<br />200,000
<br />VTrunk Charge Revenue (Service Connections when platted x Connection Charge) $
<br />16,989 $
<br />20,220 $
<br />10,600 $
<br />55,000 $
<br />100,000 $
<br />100,000 $
<br />100,000 $
<br />100,000 $
<br />100,000
<br />Interest Earnings $
<br />640,223 $
<br />594,177 $
<br />459,839 $
<br />104,444 $
<br />99,955 $
<br />85,475 $
<br />95,412 $
<br />127,813 $
<br />141,386
<br />Total System Revenue $
<br />2,496,155 $
<br />2,323,994 $
<br />2,241,870 $
<br />2,099,969 $
<br />2,233,355 $
<br />2,273,877 $
<br />2,340,466 $
<br />2,431,218 $
<br />2,504,894
<br />Trunk Charges returned to John Peterson
<br />Internal Loan to offset Muni Center Debt beginning year 2009 20 years 5%
<br />PW Land/Building- Internal Loan to General Fund 20 years 5%
<br />Internal Loan to offset Muni Center Debt beginning year 201120 years 2%
<br />Internal Loan for RTC Land 10 year 2%
<br />Water Working Capital Balance
<br />(341 units) (343 units) (384 units) (348 units)
<br />$ 80,243 $ 80,243 $
<br />$ 59,527 $ 59,527 $
<br />(100,000) $
<br />(100,000) $
<br />(100,000) $
<br />(100,000) $
<br />(100,000)
<br />(271 units)
<br />(242 units)
<br />(195 units)
<br />(170 units)
<br />(187 units)
<br />61,853
<br />$ 61,853 $
<br />61,853 $
<br />61,853 $
<br />61,853
<br />59,527
<br />$ 59,527 $
<br />59,527 $
<br />59,527 $
<br />59,527
<br />61,853
<br />$ 61,853 $
<br />61,853 $
<br />61,853 $
<br />61,853
<br />259,880
<br />$ 259,880
<br />Beginning Water Working Capital Balance $ 11,015,920 $
<br />12,102,747 $
<br />12,058,651 $
<br />Total Annual Expenses $ (1,409,327) $
<br />(2,368,090) $
<br />(7,477,351) $
<br />(2,539,000) $
<br />(3,541,800) $
<br />(1,954,525) $
<br />(263,670) $
<br />(1,609,540) $.
<br />(1,558,110)
<br />Total System Revenue $ 2,496,155 $
<br />2,323,994 $
<br />2,381,640 $
<br />2,239,739 $
<br />2,576,468 $
<br />2,616,990
<br />$ 2,423,699
<br />$ 2,514,451
<br />$ 2,588,127
<br />Netlncome(Loss) $ 1,086,827 $
<br />(44,096) $
<br />(5 $
<br />(299,261) $
<br />(965,332) $
<br />662,465
<br />$ 2,160,030
<br />$ 904,912
<br />$ 1,030,017
<br />Beginning Water Working Capital Balance $ 11,015,920 $
<br />12,102,747 $
<br />12,058,651 $
<br />6,962,941 $
<br />6,663,680 $
<br />5,698,348
<br />$ 6,360,813
<br />$ 8,520,843
<br />$ 9,425,754
<br />Ending Water Working Capital Balance $ 12,102,747 $
<br />12,058,651 $
<br />6,962,941 $
<br />6,663,680 $
<br />5,698,348 $
<br />6,360,813
<br />$ 8,520,843
<br />$ 9,425,754
<br />$ 10,455,772
<br />
|