,.. $1,600,000
<br />City of Lino Lakes, Minnesota
<br />General Obligation Tax Abatement Refunding Bonds, Series 2016C
<br />Current Refunding of 2006C Bonds
<br />Debt Service Comparison
<br />Date
<br />Total P+I Existing DVS
<br />Net New DIS Old Net DIS
<br />Savings
<br />02/01/2017 - 227,447.50 227,447.50 227,447.50
<br />02/01/2018 248,287.36 248,287.36 271,820.00 23,532.64
<br />02/01/2019 262,337.50 - 262,337.50 283,107.50 20,770.00
<br />02/01/2020 274,765.00 274,765.00 298,545.00 23,780.00
<br />02/01/2021 286,775.00 286,775.00 307,920.00 21,145.00
<br />02/01/2022 298,337.50 298,337.50 321,445.00 23,107.50
<br />02/01/2023 309,422.50 - 309,422.50 333,760.00 24,337.50
<br />Total $1,679,924.86 $227,447.50 $1,907,372.36 $2,044,045.00 $136,672.64
<br />PV Analysis Summary (Netto Net)
<br />' 22,778.77
<br />Net FV Cashflow Savings 136,672.64
<br />Gross FV Debt Service Savings 130,833.20
<br />Net R/ Cashflow Savings @ 1.292%(Bond Yield) 130,833.20
<br />Contingency or Rounding Amount 3,000.00
<br />Net Future Value Benefit $139,672.64
<br />Net Present Value Benefit $133,833.20
<br />Net FV Benefit / $243,039.63 PJ Refunded Interest 55.066%
<br />Net R/ Benefit / $1,730,833.20 IN Refunded Debt Service 7.732%
<br />Net FV Benefit / $1,565,000 Refunded Principal 8.552%
<br />Net R/ Benefit/ $1,600,000 Refunding Rincipal 8.365%
<br />Refunding Bond Information
<br />Refunding Dated Date 11/23/2016
<br />Refunding Delivery Date 11/23/2016
<br />2016C GO Tax Abatement Re 1 Curren Refunding of 2006 1 9/22/2016 1 9:43 AM
<br />Springsted
<br />Page 16
<br />
|