|
Preliminary
<br /> $1,460,000
<br /> City of Elk River, Minnesota
<br /> Electric Revenue Refunding Bonds, Series 2016B
<br /> Current Refunding of Series 2007A
<br /> Debt Seryice Comparison
<br /> Date Total P+I DSR Net New D/S Old Net D/S Savings
<br /> 02/01/2017 245,591.49 (399.43) 245,192.06 284,962.50 39,770.44
<br /> 02/01/2018 252,122.50 (730.00) 251,392.50 290,962.50 39,570.00
<br /> 02/01/2019 254,772.50 (730.00) 254,042.50 291,362.50 37,320.00
<br /> 02/01/2020 256,892.50 (730.00) 256,162.50 291,362.50 35,200.00
<br /> 02/01/2021 258,462.50 (730.00) 257,732.50 295,962.50 38,230.00
<br /> 02/01/2022 259,462.50 (146,730.00) 112,732.50 7,462.50 (105,270.00)
<br /> Total $1,527,303.99 (150,049.43) $1,377,254.56 $1,462,075.00 $84,820.44
<br /> PV Analysis Summary(Net to Net)
<br /> Net FV Cashflow Savings 84,820.44
<br /> Gross PV Debt Service Savings 221,569.08
<br /> Effects of changes in DSR investments (134,754.96)
<br /> Net PV Cashflow Savings @ 1.485%(Bond Yield) 86,814.12
<br /> Transfers from Prior Issue Debt Service Fund (30,700.00)
<br /> Contingency or Rounding Amount 2,163.33
<br /> Net Future Value Benefit $56,283.77
<br /> Net Present Value Benefit $58,277.45
<br /> Net PV Benefit/$216,704.78 IN Refunded Interest 26.893%
<br /> Net PV Benefit/$1,681,569.08 W Refunded Debt Service 3.466%
<br /> Net PV Benefit/ $1,535,000 Refunded Rincipal 3.797%
<br /> Net W Benefit/ $1,460,000 Refunding Principal 3.992%
<br /> Refunding Bond Information
<br /> Refunding Dated Date 7/14/2016
<br /> Refunding Delivery Date 7/14/2016
<br /> Series 2016B Ref 2007A Re SINGLEPORPOSE 4/29/2016 11.53 AM
<br /> Springsted Page 11
<br /> 176
<br />
|