|
Page 16
<br />
<br />
<br />
<br />
<br />
<br />$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 Total P+I Existing D/S Net New D/S Old Net D/S 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 (Net to Net) 22,778.77
<br />
<br />Net FV Cashflow Savings.................................................................................................................................................................................136,672.64
<br />Gross PV Debt Service Savings...........................................................................................................................................................................130,833.20
<br />
<br />Net PV Cashflow Savings @ 1.292%(Bond Yield)...........................................................................................................................................................130,833.20
<br />
<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 />
<br />Net PV Benefit / $243,039.63 PV Refunded Interest.......................................................................................................................................................55.066%
<br />Net PV Benefit / $1,730,833.20 PV Refunded Debt Service.................................................................................................................................................7.732%
<br />Net PV Benefit / $1,565,000 Refunded Principal.........................................................................................................................................................8.552%
<br />Net PV Benefit / $1,600,000 Refunding Principal........................................................................................................................................................8.365%
<br />
<br />Refunding Bond Information
<br />
<br />Refunding Dated Date....................................................................................................................................................................................11/23/2016
<br />Refunding Delivery Date.................................................................................................................................................................................11/23/2016
<br />2016C GO Tax Abatement Re | Current Refunding of 2006 | 9/22/2016 | 9:43 AM
|