|
<br />
<br />St Anthony HRA, Minnesota
<br />$4,445,000 GO TIF Rev Bonds, Dated December 15, 2015
<br />Proposed Full Net Cash Refunding of Series 2006
<br />Rev to GO - Assumed Current BQ GO "AA" Market Rates
<br />Debt Service Comparison
<br />Date Total P+I Net New D/S Old Net D/S Savings
<br />02/01/2016 149,492.61 147,758.41 184,525.00 36,766.59
<br />02/01/2017 303,500.00 303,500.00 373,271.88 69,771.88
<br />02/01/2018 307,321.25 307,321.25 380,075.00 72,753.75
<br />02/01/2019 315,727.50 315,727.50 385,937.51 70,210.01
<br />02/01/2020 323,556.25 323,556.25 391,128.13 67,571.88
<br />02/01/2021 325,817.50 325,817.50 395,378.13 69,560.63
<br />02/01/2022 327,665.00 327,665.00 398,956.25 71,291.25
<br />02/01/2023 328,916.25 328,916.25 401,156.26 72,240.01
<br />02/01/2024 334,657.50 334,657.50 407,375.01 72,717.51
<br />02/01/2025 334,862.50 334,862.50 407,609.38 72,746.88
<br />02/01/2026 339,613.75 339,613.75 411,859.38 72,245.63
<br />02/01/2027 353,722.50 353,722.50 424,843.76 71,121.26
<br />02/01/2028 356,892.50 356,892.50 426,281.25 69,388.75
<br />02/01/2029 354,316.25 354,316.25 426,593.76 72,277.51
<br />02/01/2030 366,191.25 366,191.25 435,640.63 69,449.38
<br />02/01/2031 372,290.00 372,290.00 443,000.01 70,710.01
<br />Total $5,194,542.61 $5,192,808.41 $6,293,631.34 $1,100,822.93
<br />PV Analysis Summary (Net to Net)
<br />
<br />Gross PV Debt Service Savings.....................945,529.92
<br />
<br />Net PV Cashflow Savings @ 2.034%(Bond Yield).....945,529.92
<br />
<br />Contingency or Rounding Amount....................1,734.20
<br />Net Present Value Benefit $947,264.12
<br />
<br />Net PV Benefit / $5,390,529.92 PV Refunded Debt Service 17.573%
<br />Net PV Benefit / $4,120,000 Refunded Principal...22.992%
<br />Net PV Benefit / $4,445,000 Refunding Principal..21.311%
<br />
<br />Refunding Bond Information
<br />
<br />Refunding Dated Date 12/15/2015
<br />Refunding Delivery Date 12/15/2015
<br />Proposed NCR 2006 HRA GO | SINGLE PURPOSE | 10/19/2015 | 11:14 AM
<br />
<br />13
|