Preliminary
<br /> $2,125,000
<br /> City of Elk River, Minnesota
<br /> Electric Revenue Refunding Bonds, Series 2014
<br /> Current Refunding of Series 2006A
<br /> Debt Service Comparison
<br /> Date Total P+I DSR Net New DS Old Net DS Savings
<br /> 8/01/2014 438,073.96 (203.62) 437,870.34 275,861.87 (162,008.47)
<br /> 8/01/2015 438,912.50 (531.26) 438,381.24 318,381.24 (120,000.00)
<br /> 8/01/2016 435,972.50 (531.26) 435,441.24 319,561.24 (115,880.00)
<br /> 8/01/2017 437,192.50 (531.26) 436,661.24 320,253.74 (116,407.50)
<br /> 8/01/2018 436,880.00 (213,031.26) 223,848.74 320,316.24 96,467.50
<br /> 8/01/2019 - - - 324,866.24 324,866.24
<br /> 8/01/2020 - - - 323,701.24 323,701.24
<br /> 8/01/2021 - - - (32,798.76) (32,798.76)
<br /> Total $2,187,031.46 (214,828.66) $1,972,202.80 $2,170,143.05 $197,940.25
<br /> PV Analysis Summary(Net to Net)
<br /> Net FV Cashflow Savings 197,940.25
<br /> Gross PV Debt Service Savings 293,75652
<br /> Effects of changes in DSR investments (131,305.99)
<br /> Net P/Cashflow Savings Q 1.221%(Bond Yield) 162,450.53
<br /> Contingency or Rounding Amount 4,281.87
<br /> Net Future Value Benefit $202,222.12
<br /> Net Resent Value Benefit $166,732.40
<br /> Net Pr/Benefit/$344,140.56 P/Refunded Interest 48.449%
<br /> Net P/Benefit/$2,418,756.52 P/Refunded Debt Service 6.893%
<br /> Net P./Benefit/ $2,180,000 Refunded Rincipal 7.648%
<br /> Net PV Benefit/ $2,125,000 Refunding Principal 7.846%
<br /> Refunding Bond Information
<br /> Refunding Dated Date 3/13/2014
<br /> Refunding Delivery Date 3/13/2014
<br /> sere,2014.Re/20064 H,, s/NOLC PUrerosc I u 2401/ 1306re(
<br /> Springsteo Page8
<br /> 74
<br /> •
<br />
|