|
<br />$1,305,000
<br />
<br />City of Hastings, Minnesota
<br />General Obligation Improvement and Refunding Bonds, Series 2005A
<br />Refunding Portion - Current Refunding of the Series 1998A Bonds
<br />
<br />Debt Service Comparison
<br />
<br />Oate Total P+I Escrow Existing DIS Net New DIS Old Net DlS Savings
<br />02/0112006 - (3,755.67) 102,986.25 99.230.58 102,986.25 3,755.67
<br />02/0112007 129,626.25 - - 129,626.25 137,857.50 8,231.25
<br />02/0112008 129,610.00 - - 129,610.00 134,482.50 4,872.50
<br />02/01/2009 127,017.50 - - 127,017.50 136,070.00 9,052.50
<br />02/0112010 129,340.00 - - 129,340.00 137,390.00 8,050.00
<br />02/01/2011 131,415.00 - - 131,415.00 138,395.00 6,980.00
<br />02/01/2012 133,232.50 - - 133,232.50 139,120.00 5,887.50
<br />02/01/2013 129,782.50 - - 129,782.50 134,370.00 4,587.50
<br />02/0112014 126,232.50 - - 126,232.50 134,620.00 8,387.50
<br />02/01/2015 127,582.50 - - 127,582.50 134,620.00 7,037.50
<br />02/0112016 128,645.00 - - 128,645.00 134,370.00 5,725.00
<br />02/01/2017 129,410.00 - - 129,410.00 133,870.00 4,460.00
<br />02/0112018 129,925.00 - - 129,925.00 138,005.00 8.080.00
<br />02/0112019 130.125.00 - - 130,125.00 136,630.00 6,505.00
<br />Total $1,681,943.75 (3,755.67) $102.986.25 $1,781,174.33 $1,872,786.25 $91,611.92
<br />
<br />PV Analysis Summary (Net to Net)
<br />
<br />Net FV Cashflow Savings........................... ..........................................................................................................................
<br />
<br />Gross PV Debt Service Savings............................................................................................................................................
<br />
<br />PV of Escrow Earnings... .............................. ................................................ ......... ...... ............ ......... .......
<br />
<br />Net PV Cashflow Savings @ 3.647%(Bond yield)...............................................................................................................
<br />
<br />Accrued Interest Credit to Debt Service Fund.......................................................................................................................
<br />
<br />Contingency or Rounding Amount.........................................................................................................................................
<br />
<br />Net Future Value Benefit................................................................................................................................................... ....
<br />
<br />Net Present Value Benefit.............................................. ...................................... .................................................................
<br />
<br />Net PV Benefit / $409,179.54 PV Refunded Interest.............................................................................................................
<br />Net PV Benefit / $1,383,720.53 PV Refunded Debt Service..................................................................................................
<br />Net PV Benefit / $1,280,000 Refunded Principal..................................................................................................................
<br />Net PV Benefit / $1,305,000 Refunding Principal.................................................................................................................
<br />
<br />Refunding Bond Information
<br />
<br />91.611.92
<br />69,750.83
<br />3,735.74
<br />
<br />73,486.57
<br />
<br />910.44
<br />264.46
<br />$92,786.82
<br />$74,661.47
<br />
<br />18.247%
<br />5.396%
<br />5.833%
<br />5.721%
<br />
<br />Refunding Dated Date........ ............................ .................... ...................................... ............................ .... ............................. 12/01/2005
<br />Refunding Delivery Date....................................................................................................................................................... 12/08/2005
<br />
<br />Series2005A GOlmpt'C1lle1tle I Sel'if:82005Ref98A I 9/20/2005 I /1:19AM
<br />
<br />Springsted
<br />
<br />Page 19
<br />
|