of Elk River, MN
<br />Proposed Crossover Refunding of
<br />$3,590,000 G.O. Water Revenue Bonds, Series 2001A
<br />Debt Service Comparison
<br />Date Total P+I PCF Existing D/S Net New D/S Old Net D/S Savings
<br />02/01/2008 - - - (4,779.58) - 4,779.58
<br />02/01/2009 97,641.00 (97,641.00) 120,795.00 120,795.00 120,795.00 -
<br />02/O1/20I0 97,641.00 (2,672,641.00) 2,695,795.00 120,795.00 120,795.00 -
<br />02/O1/2011 277,641.00 - - 277,641.00 280,795.00 3,154.00
<br />02/01/2012 276,521.00 - - 276,521.00 284,235.00 7,714.00
<br />02/01/2013 280,138.50 - 280,138.50 287,010.00 6,871.50
<br />02/01/2014 278,313.50 - - 278,313.50 284,180.00 5,866.50
<br />02/01/2015 276,213.50 - - 276,213.50 285,670.00 9,456.50
<br />02/01/2016 278,833.50 - - 278,833.50 286,700.00 7,866.50
<br />02/01/2017 275,986.00 - - 275,986.00 286,962 50 10,976.50
<br />02/01/2018 277,846.00 - - 277,846.00 291,750.00 13,904.00
<br />02/01/2019 279,221.00 - - 279,221.00 290,595.00 11,374.00
<br />02/01/2020 280,101.00 - - 280,101.00 288,955.00 8,854.00
<br />02/01/2021 280,476.00 - - 280,476.00 291,705.00 11,229.00
<br />02/01/2022 275,388.00 - - 275,388.00 293,720.00 18,332.00
<br />Total $3,531,961.00 (2,770,282.00) $2,816,590.00 53,573,489.42 $3,693,867.50 $120,378.08
<br />PV Analysis Summary (Net to Net)
<br />Gross PV Debt Service Savings.... ..... __ 82,989.98„
<br />_ _._...
<br />Net PV Cashflow Savings @..3.730%(Bond Yield)..... _ _ _ _ 82,989.98_
<br />Contingency or Rounding Amount ................
<br />Net Present Value Benefit
<br />4,779.58
<br />$87,769.56
<br />Net PV Benefit / $2,544,815.22 PV Refunded Debt Service
<br />Net PV Benefit / $2,575,000 Refunded Principal...
<br />Net PV Benefit / $2,645,000 Refunding Principal..
<br />Refunding Bond Information
<br />Dated Date
<br />________ .._ ..............._..__.
<br />Delivery Date
<br />3.449%
<br />_ _ . 3.409%
<br />_ __ __ 3.318%
<br />z/o1/2008
<br />2/Ol /2008
<br />08 xover of Ser 01A & cur ~ Ser 01A $3.59M ROVER ~ 11/ 1/2007 ~ 11:51 AM
<br />
|