<br />
<br />City of New Brighton, MN
<br />$5,045,000 G.O Tax Increment Refunding Bonds, Dated July 15, 2017
<br />Proposed Current Refunding of Series 2007B
<br />Assuming Flat Rate - Bank Offering
<br />Debt Service Comparison
<br />Date Total P+I Net New D/S Old Net D/S Savings
<br />02/01/2018 705,265.02 700,765.02 696,275.63 (4,489.39)
<br />02/01/2019 740,337.00 740,337.00 803,951.26 63,614.26
<br />02/01/2020 738,259.00 738,259.00 803,582.50 65,323.50
<br />02/01/2021 720,998.00 720,998.00 787,182.50 66,184.50
<br />02/01/2022 713,828.50 713,828.50 778,907.50 65,079.00
<br />02/01/2023 736,567.50 736,567.50 804,762.50 68,195.00
<br />02/01/2024 738,666.00 738,666.00 803,950.00 65,284.00
<br />02/01/2025 305,490.00 305,490.00 371,862.50 66,372.50
<br />Total $5,399,411.02 $5,394,911.02 $5,850,474.39 $455,563.37
<br />PV Analysis Summary (Net to Net)
<br />
<br />Gross PV Debt Service Savings.....................416,599.57
<br />
<br />Net PV Cashflow Savings @ 1.830%(Bond Yield).....416,599.57
<br />
<br />Contingency or Rounding Amount....................4,500.00
<br />Net Present Value Benefit $421,099.57
<br />
<br />Net PV Benefit / $5,461,599.57 PV Refunded Debt Service 7.710%
<br />Net PV Benefit / $5,000,000 Refunded Principal...8.422%
<br />Net PV Benefit / $5,045,000 Refunding Principal..8.347%
<br />
<br />Refunding Bond Information
<br />
<br />Refunding Dated Date 7/15/2017
<br />Refunding Delivery Date 7/15/2017
<br />Proposed CR 2007B GO TIF | SINGLE PURPOSE | 7/12/2017 | 9:35 AM
<br />
|