City of Medina
<br /> Hamel Water System Capital Improvement Plan
<br /> 2006 Update Attachment B
<br /> Capital Improvements Paid By
<br /> ODeratina Fund
<br /> Pro`act 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016
<br /> Land for water treatment plant
<br /> Well Maintenance($30k every 7 years)
<br /> 30,000
<br /> Repair and Replacement 75,000 35,000 35,000 75,000 35,000 35,000 75,000 35,000 35,000 75,000 35,000
<br /> Total 75 000 35 000 35 000 75 000 35 000 35 000 105,000 35 000 35,000 75,00 35,000
<br /> Total Inflated CIP Expense 75 000 36 400 37 856 84 365 40 945 42 583 132 858 46 058 47,900 106,7408 51,809
<br /> Inflation Rate 1 4.0%
<br /> Notes:1. The first water treatment plant is estimated to cost$5,354,978.
<br /> $4,667,130 of the cost was financed with proceeds from the$4.76 million Series 2005A water revenue bonds.
<br /> $594,978 will be paid with cash in 2006.
<br /> 2. The water treatment plant expansion will be constructed in 2015,and allocated 35%to the operatin gfund and 65%to the trunk fund.
<br /> 3. The debt for the existing treatment plant is allocated 60%to the operating fund and 40%to the trunk fund.
<br /> 4. The 2007 improvements and 2008 water tower and land are assumed to be financed in 2007. (Term of 15 years at 5.0%.)
<br /> The 2007 debt is allocated 20%to the operating fund and 80%to the trunk fund.
<br /> Capital Improvements Paid By Trunk
<br /> Fund x=2006 CIP improvements that total$980,000 and will be financed in 2007
<br /> Project 2006 2007 1 2008 2009 2010 2011 2012 2013 2014 2015 2016
<br /> Land for Water Treatment
<br /> Cash Payment for Water Treatment 594,978
<br /> Water Treatment Expansion 1,000,000
<br /> Raw Water Supply Lines x
<br /> Modifiactions to PH 5 x
<br /> Well#6 x
<br /> Well#7 600,000 600,000
<br /> Water Tower and Land 2,200,000
<br /> Total 594,978 980,000 2,200,000 600,000 0 0 0 0 600,000 1,000,000
<br /> Total Inflated CIP Cash Expense 594,978 980,000 2,379,520 674 918 0 0 0 0 821,141 1 423 312 0
<br /> Inflation Rate 4.0% 0.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 470% 4.0% 4.0%
<br /> Transfer to Operating Fund for debt
<br /> service for water tower and wells-
<br /> Series 2007 271,878 271,878 271,878 271,878 271,878 271,878 271,878 271,878 271,878
<br /> Transfer to Operating Fund for debt
<br /> service for treatment plant 1 Series 200,136 164,686 165,164 165,348 165,388 165,270 164,992 164,570 164,002 163,290 164,310
<br /> Transfer to Operating Fund-debt 100,019
<br /> service for treatment expansion
<br /> Total transfers for Debt Service 200,136 164,686 1 437,042 437,226 437,266 1 437,147 436,870 436,447 435,880 1 435,1677± 536 206
<br /> 11/2/2006
<br />
|