|
$4,595,000
<br />City of Elk River, Minnesota
<br />General Obligation Capital Improvement Plan Refunding Bonds, Series 2020B
<br />Current Refunding of Series 2012A
<br />Debt Service Comparison
<br />DateTotal P+IExisting D/SNet New D/SOld Net D/SSavings
<br />02/01/2021-380,087.50380,087.50380,087.50-
<br />02/01/2022417,465.39-417,465.39438,675.0021,209.61
<br />02/01/2023411,175.00-411,175.00436,975.0025,800.00
<br />02/01/2024418,985.00-418,985.00440,175.0021,190.00
<br />02/01/2025416,547.50-416,547.50438,175.0021,627.50
<br />02/01/2026413,922.50-413,922.50436,075.0022,152.50
<br />02/01/2027415,735.00-415,735.00437,975.0022,240.00
<br />02/01/2028416,935.00-416,935.00439,650.0022,715.00
<br />02/01/2029412,700.00-412,700.00435,625.0022,925.00
<br />02/01/2030413,080.00-413,080.00436,000.0022,920.00
<br />02/01/2031413,010.00-413,010.00436,125.0023,115.00
<br />02/01/2032412,480.00-412,480.00436,000.0023,520.00
<br />02/01/2033411,480.00-411,480.00435,625.0024,145.00
<br />Total$4,973,515.39$380,087.50$5,353,602.89$5,627,162.50$273,559.61
<br />PV Analysis Summary (Net to Net)
<br />Net FV Cashflow Savings........................................................................................................................................273,559.61
<br />Gross PV Debt Service Savings...............................................................................................................................254,146.09
<br />Net PV Cashflow Savings @ 1.180%(Bond Yield).....................................................................................................254,146.09
<br />Contingency or Rounding Amount............................................................................................................................1,723.37
<br />Net Future Value Benefit.........................................................................................................................................$275,282.98
<br />Net Present Value Benefit.......................................................................................................................................$255,869.46
<br />Net PV Benefit / $4,862,046.17 PV Refunded Debt Service.........................................................................................5.263%
<br />Net PV Benefit / $4,515,000 Refunded Principal.......................................................................................................5.667%
<br />Net PV Benefit / $4,595,000 Refunding Principal.......................................................................................................5.568%
<br />Refunding Bond Information
<br />Refunding Dated Date.............................................................................................................................................12/29/2020
<br />Refunding Delivery Date...........................................................................................................................................12/29/2020
<br />2020 GO Ref Bonds (10A, 1 | Current Refunding of Seri | 10/23/2020 | 8:47 AM
<br />Page 20
<br />
|