|
<br />
<br />City of Little Canada, Minnesota
<br />$1,255,000 Taxable G.O. Housing Imp Area Refunding Bonds, Series 2017A
<br />Proposed Current Refunding of Series 2009A
<br />Assuming Current GO Taxable "AA" Market Rates plus 25bps
<br />Debt Service Comparison
<br />Date Total P+I
<br />Existing
<br />D/S Net New D/S Old Net D/S Savings
<br />02/01/2018 -177,697.50 173,257.50 177,697.50 4,440.00
<br />02/01/2019 199,862.92 -199,862.92 209,305.00 9,442.08
<br />02/01/2020 196,912.50 -196,912.50 207,705.00 10,792.50
<br />02/01/2021 198,427.50 -198,427.50 205,575.00 7,147.50
<br />02/01/2022 199,490.00 -199,490.00 207,895.00 8,405.00
<br />02/01/2023 200,170.00 -200,170.00 209,395.00 9,225.00
<br />02/01/2024 200,545.00 -200,545.00 210,215.00 9,670.00
<br />02/01/2025 195,415.00 -195,415.00 205,335.00 9,920.00
<br />Total $1,390,822.92 $177,697.50 $1,564,080.42 $1,633,122.50 $69,042.08
<br />PV Analysis Summary (Net to Net)
<br />
<br />Gross PV Debt Service Savings.....................58,891.59
<br />
<br />Net PV Cashflow Savings @ 2.530%(Bond Yield).....58,891.59
<br />
<br />Contingency or Rounding Amount....................4,440.00
<br />Net Present Value Benefit $63,331.59
<br />
<br />Net PV Benefit / $1,313,891.59 PV Refunded Debt Service 4.820%
<br />Net PV Benefit / $1,200,000 Refunded Principal...5.278%
<br />Net PV Benefit / $1,255,000 Refunding Principal..5.046%
<br />
<br />Refunding Bond Information
<br />
<br />Refunding Dated Date 12/01/2017
<br />Refunding Delivery Date 12/01/2017
<br />Series 2017A TAX GO HIA R | SINGLE PURPOSE | 9/20/2017 | 12:35 PM
<br />
|