•
<br />•
<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 DM 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 />.Scrim 2010 Re! 2004A / SIN alt rr 7OtYSL / '/25/2010 / 10.7:) AM
<br />-47-
<br />Page 13
<br />
|