•
<br />•
<br />$1,015,000
<br />City of Lino Lakes, Minnesota
<br />General Obligation Improvement & Utility Revenue Refunding Bonds, Series 2010A
<br />Current Refunding of Series 2004A
<br />Debt Service Comparison
<br />Date Total P +I Net New D/S Old Net D/S Savings
<br />02/01 /2011 118,010.00 118,010.00 121,736.26 3,726.26
<br />02/01/2012 113,937.50 113,937.50 119,101.26 5,163.76
<br />02/01/2013 113,177.50 113,177.50 116,296.26 3,118.76
<br />02/01/2014 112,180.00 112,180.00 118,321.26 6,141.26
<br />02/01/2015 115,897.50 115,897.50 120,081.26 4,183.76
<br />02/01/2016 114,197.50 114,197.50 116,281.26 2,083.76
<br />02/01/2017 112, 047.50 112, 047.50 117,481.26 5,433.76
<br />02/01/2018 114, 597.50 114,597.50 118,481.26 3,883.76
<br />02/01/2019 116, 710.00 116,710.00 119,281.26 2,571.26
<br />02/01/2020 113,465.00 113,465.00 119,743.76 6,278.76
<br />Total $1,144,220.00 $1,144,220.00 $1,186,805.10 $42,585.10
<br />PV Analysis Summary (Net to Net)
<br />Net FV Cashflow Savings 42,585.10
<br />Gross PV Debt Service Savings 38,293.58
<br />Net PV Cashflow Savings @ 2.394 %(Bond Yield) 38,293.58
<br />Contingency or Rounding Amount 2,826.98
<br />Net Future Value Benefit $45,412.08
<br />Net Present Value Benefit $41,120.56
<br />Net PV Benefit / $203,982.76 PV Refunded Interest 20.159%
<br />Net PV Benefit / $1,053,293.58 PV Refunded Debt Service 3.904%
<br />Net PV Benefit / $965,000 Refunded Principal 4.261%
<br />Net PV Benefit / $1,015,000 Refunding Principal 4.051%
<br />Refunding Bond Information
<br />Refunding Dated Date 6/01/2010
<br />Refunding Delivery Date 6/01/2010
<br />Series 2010 Ref 20045 / .s'Nd11: PI %TOSE / 3/25/2010 / 10:10 AM
<br />Springsted
<br />Page 13
<br />
|