|
$7,295,000
<br />City of Elk River, Minnesota
<br />Taxable General Obligation Sewer Revenue Refunding Bonds, Series 2020C
<br />Crossover Refunding of Series 2014B
<br />Debt Service Comparison
<br />DateTotal P+IEscrowExisting D/SNet New D/SOld Net D/SSavings
<br />02/01/2021--557,502.50557,502.50557,502.50-
<br />02/01/2022134,540.39(7,174,540.39)7,716,205.00676,205.00676,205.00-
<br />02/01/2023638,557.50--638,557.50672,205.0033,647.50
<br />02/01/2024639,695.00--639,695.00670,830.0031,135.00
<br />02/01/2025644,755.00--644,755.00674,205.0029,450.00
<br />02/01/2026639,190.00--639,190.00672,205.0033,015.00
<br />02/01/2027638,095.00--638,095.00668,730.0030,635.00
<br />02/01/2028640,605.00--640,605.00673,730.0033,125.00
<br />02/01/2029636,885.00--636,885.00668,130.0031,245.00
<br />02/01/2030641,985.00--641,985.00672,230.0030,245.00
<br />02/01/2031641,250.00--641,250.00674,355.0033,105.00
<br />02/01/2032639,750.00--639,750.00669,975.0030,225.00
<br />02/01/2033642,465.00--642,465.00675,085.0032,620.00
<br />02/01/2034644,265.00--644,265.00674,345.0030,080.00
<br />02/01/2035645,120.00--645,120.00677,925.0032,805.00
<br />Total$8,467,157.89(7,174,540.39)$8,273,707.50$9,566,325.00$9,977,657.50$411,332.50
<br />PV Analysis Summary (Net to Net)
<br />Net FV Cashflow Savings........................................................................................................................................411,332.50
<br />Gross PV Debt Service Savings...............................................................................................................................352,552.52
<br />Net PV Cashflow Savings @ 2.063%(TIC)................................................................................................................352,552.52
<br />Contingency or Rounding Amount............................................................................................................................362.37
<br />Net Future Value Benefit.........................................................................................................................................$411,694.87
<br />Net Present Value Benefit.......................................................................................................................................$352,914.89
<br />Net PV Benefit / $7,435,541.90 PV Refunded Debt Service.........................................................................................4.746%
<br />Net PV Benefit / $7,040,000 Refunded Principal.......................................................................................................5.013%
<br />Net PV Benefit / $7,295,000 Refunding Principal.......................................................................................................4.838%
<br />Refunding Bond Information
<br />Refunding Dated Date.............................................................................................................................................12/29/2020
<br />Refunding Delivery Date...........................................................................................................................................12/29/2020
<br />2020 Txbl GO Ref Bonds (1 | SINGLE PURPOSE | 10/22/2020 | 1:55 PM
<br />Page 26
<br />
|