City of Medina
<br /> Hamel Water System Capital Improvement Plan
<br /> 2006 Update
<br /> Capital Improvements Paid By
<br /> ODeratina Fund
<br /> Pro ect 2006 2007 2008 2009 1 2010 2011 2012 2013 2014 2015 2016
<br /> 1 Land for water treatment plant
<br /> Well Maintenance($30k every 7 years)
<br /> 2 30,000
<br /> 3 Repair and Replacement 75,000 35,000 35,000 751000 35,000 35,000 75,000 35,000 35,000 75,000 35,000
<br /> 4 Total 75,000 35,000 35,000 75,000 35,000 35,000 105,000 35,000 35,000 75,000 35,000
<br /> 5 Total Inflated CIP Ex ense 75 000 36 400 37 856 84 365 40 945 42 583 132,858 46,058 47,900 106,748 51 809
<br /> 8 Inflation Rate 1 4.0%
<br /> 7
<br /> 8 Notes:1. The first water treatment plant is estimated to cost$5,354,978.
<br /> 9 $4,667,130 of the cost was financed with proceeds from the$4.76 million Series 20O5A water revenue bonds.
<br /> 10 $594,978 will be paid with cash in 2006.
<br /> 11 2. The second water treatment plant will be constructed after 2015.
<br /> 12 3. The debt for the existing treatment plant is allocated 60%to the operating fund and 40%to the trunk fund.
<br /> 13 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 /> 14 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 /> 15 Pro ect 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016
<br /> 16 Land for Water Treatment
<br /> 17 Cash Payment for Water Treatment 594,978
<br /> 18 Water Treatment Expansion 1,000,000
<br /> 19 Raw Water Supply Lines x
<br /> 20 Modifiactions to PH 5 x
<br /> 21 Well#6 x
<br /> 22 Well#7 600,000 600,000
<br /> 23 Water Tower and Land 2,200,000
<br /> 24 Total 594,978 980,000 2,200,000 600 000 0 0 0 0 600,000 1,000,000
<br /> 25 Total Inflated CIP Cash Expense 594,978 980,000 2,379,520 674 918 0 0 0 0 621 141 1,423,312 0
<br /> 26 Inflation Rate 4.0% 0.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0%
<br /> Transfer to Operating Fund for debt
<br /> service for water tower and wells-
<br /> 27 Series 2007 271,878 271,878 1 271,878 271,878 271,878 1 271,878 271,878 271,878 1 271,878
<br /> Transfer to Operating Fund for debt
<br /> 48 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 /> 29 service for treatment plant 2
<br /> 30 ITotal transfers for Debt Service 200 136 1 164,686 437,042 437,226 437,266 437,147 436,870 438 447 435,880 435,167 536,206
<br /> 2/2112007
<br />
|