City of St Anthony, MN
<br />$2,215,000 G.O. Refunding Bonds, Series 2011 Dated: December 29, 2011
<br />Proposed Current Refunding of Series 2004A & 2005A
<br />Hennepin Cty Rates from 11/1/11 sale + 10 Basis Points
<br />Debt Service Comparison
<br />Date
<br />Total P+1
<br />Net New D/S
<br />Old Net DIS
<br />Savings
<br />02/01/2012
<br />-
<br />(2,280.00)
<br />-
<br />2,280.00
<br />02/01/2013
<br />287,166.50
<br />287,166.50
<br />308,312.50
<br />21,146.00
<br />02/01/2014
<br />287,757.50
<br />287,757.50
<br />309,985.00
<br />22,227.50
<br />02/01/2015
<br />290,845.00
<br />290,845.00
<br />311,170.00
<br />20,325.00
<br />02/01/2016 _
<br />.. 282,985 00
<br />282,985.00
<br />306,732.50
<br />23,747.50
<br />02/01/2017
<br />284,415,00
<br />284,415.00
<br />306,862.50
<br />22,447.50
<br />02/01/2018
<br />285,255.00
<br />285,255.00
<br />306,335.00
<br />21,080.00
<br />02/01/2019
<br />280,352.50
<br />280,352.50
<br />305,195.00
<br />24,842.50
<br />02/01/2020
<br />279,787.50
<br />279,787.50
<br />303,427.50
<br />23,640.00
<br />02/01/2021
<br />138,442 50
<br />138,442 50
<br />151,017.50
<br />12,575,00
<br />Total
<br />$2,417,006.50
<br />$2,414,726.50
<br />$2,609,037.50
<br />$194,311.00
<br />PV Analysis Summary (Net to Net)
<br />Gross PV Debt Service Savings...._ _..._
<br />176,515.27
<br />Net PV Cashltow Savings (n} 1.847%(Bond Yield) __.
<br />176,515.27
<br />Contingency or Rounding Amount,.
<br />2,280.00
<br />Net Present Value Benefit ,., _..
<br />,,.., $178,795.27
<br />Net PV Benet t / $2,391,515 27 PV Refunded Debt Service
<br />Net PV Benefit /.$2,160,000 Refunded Principal, -
<br />Ne( PV Benefit / $2,215,000 Refunding Principal..
<br />Refunding Bond Information
<br />Refunding Dated Date
<br />Refunding Delivery Date
<br />Proposer! Current Refundin I Issue Summary 1 11/ 112011 1 11:31 AM
<br />EHLERS
<br />LEADERS IN PUBLIC FINANCE
<br />7.476
<br />8.278%
<br />8.072%
<br />12/29/2011
<br />12/29/2011
<br />29
<br />
|