City of Little Canada, Minnesota
<br />$1,335,000 General Obligation Refunding Bonds, Series 2015A
<br />Crossover Refunding of 08A GO Bonds - TIF Portion Only
<br />(Gross Funded)
<br />Debt Service Comparison
<br />Date Total P+I PCF Existing D/S Net New D/S Old Net DIS Savings
<br />02/01/2016 16,563.46 (1,311,563.46) 1,454,362.50 158,099.94 159,362,50 1,262.56
<br />02/01/2017 152,352.50 152,352.50 160,687.50 8,335,00
<br />02/01/2018 144,852.50 144,852.50 156,837.50 11,985.00
<br />02/01/2019 147,452.50 147,452,50 157,712.50 10,260.00
<br />02/01/2020 149,952.50 149,952.50 158,400.00 8,447.50
<br />02/01/2021 147,352.50 147,352.50 158,600,00 11,247.50
<br />02/01/2022 149,752.50 149,752.50 158,600.00 8,847.50
<br />02/01/2023 147,052.50 147,052.50 158,400.00 11,347.50
<br />02/01/2024 154,352.50 154,352.50 163,000.00 8,647.50
<br />02/01/2025 151,452.50 151,452.50 162,200.00 10,747.50
<br />02/01/2026 148,335.00 148,335.00 161,200.00 12,865.00
<br />Total $1,509,470.96 (1,311,563.46) $1,454,362.50 $1,651,007.44 $1,755,000.00 $103,992.56
<br />PV Analysis Summary (Net to Net)
<br />Gross PV Debt Service Savings
<br />Net PV Cashflow Savings @ 1.798%(Bond Yield)
<br />Contingency or Rounding Amount
<br />Net Present Value Benefit
<br />Net PV Benefit / $1,433,027.94 PV Refunded Debt Service
<br />Net PV Benefit / $1,295,000 Refunded Principal...
<br />Net PV Benefit / $1,335,000 Refunding Principal..
<br />Refunding Bond Information
<br />92,565.67
<br />92,565.67
<br />...............................
<br />1,262.56
<br />...............................
<br />$93,828.23
<br />...............................
<br />6,548%
<br />7.245%
<br />7.028%
<br />Refunding Dated Date
<br />Refunding Delivery Date
<br />Series 2015A GO Ref Bds - 1 Tax Increment Portion 1 5/27/2015 1 10:22 AM
<br />EHLERS
<br />LEADERS IN PUBLIC FINANCE
<br />6/23/2015
<br />6/23/2015
<br />
|