|
<br />Refunding Bonds, Series 2009B - Debt Service Comparison
<br />
<br />Final
<br />
<br />City of Centerville, Minnesota
<br />G.O. Improvement Crossover Refunding Bonds, Series 2009B
<br />Crossover Refund 2006A Bonds
<br />
<br />Debt Service Comparison
<br />
<br />Date Total P+I PCF Existing D/S Net New D/S
<br />03/01/2010 (2,420.000.00) 2,616,981.25 196,238.84
<br />03/0112011 225,933.33 225,933.33
<br />03101/2012 231,650.00 231,650.00
<br />03/01/2013 233.250.00 233,250.00
<br />03/01/2014 229,750.00 229,750.00
<br />03/01/2015 .~36,250.00 236,250.00
<br />03/01/2016 237,550.00 237,550.00
<br />03/01/2017 241,850.00 241,850.00
<br />03/01/2018 1,230,850.00 1.230,850.00
<br />03/01/2019
<br />03/01/2020
<br />0310112021
<br />0310112022
<br />Total $2,867,083.33 (2,420,000.00) $2,616,981.25 $3,063,322.17
<br />
<br />Old Net D/S
<br />
<br />196,981.25
<br />248,525.00
<br />252,825.00
<br />256,665.00
<br />255,035.00
<br />258,122.50
<br />260,722.50
<br />262,922.50
<br />264,620.00
<br />260,805.00
<br />266,675.00
<br />271,805.00
<br />271,180.00
<br />
<br />$3,326,883.75
<br />
<br />Savings
<br />742.41
<br />22,591.67
<br />21,175.00
<br />23,415.00
<br />25,285.00
<br />21,872.50
<br />23,172.50
<br />21,072.50
<br />(966,230.00)
<br />260,805.00
<br />266,675.00
<br />271,805.00
<br />271,180.00
<br />
<br />$263,561,58
<br />
<br />PV Analysis Summary (Net to Net)
<br />
<br />Gross PV Debt Service Savings..
<br />
<br />168,528.56
<br />
<br />168,528.56
<br />
<br />Net PV Cashflow Savings @ 2.586%(Bond Yield)... .
<br />
<br />Contingency or Rounding Amount...
<br />Net Present Value Benefit
<br />
<br />Net PV Benefit / $2,634,092.41 PV Refunded Debt Service
<br />Net PV Benefit / $2,420,000 Refunded Principal...
<br />Net PV Benefit / $2,430,000 Refunding Principal
<br />
<br />742.41
<br />$169,270.97
<br />
<br />6.426%
<br />6.995%
<br />6.966%
<br />
<br />Refunding Bond Information
<br />
<br />Refunding Dated Date
<br />Refunding Delivery Date
<br />
<br />10/0112009
<br />10/2912009
<br />
<br />Page 4
<br />
<br />NORTHLANotSEC URITIES
<br />
|