|
City of Elk River, Minnesota
<br /> $9,685,000 G.O. Refunding Bonds, Series 2013A
<br /> Crossover Refunding of
<br /> $10,000,000 G.O. Bonds, Series 2007
<br /> Debt Service Comparison
<br /> Const Loan
<br /> Date Total P+I Pmt Existing D/S Net New D/S Old Net D/S Savings
<br /> 02/01/2014 218,743.02 (218,743.02) 397,858.79 396,479.10 397,858.79 1,379.69
<br /> 02/01/2015 225,637.50 (225,637.50) 410,398.76 410,398.76 410,398.76 -
<br /> 02/01/2016 225,637.50 (225,637.50) 790,398.76 790,398.76 790,398.76 -
<br /> 02/01/2017 225,637.50 (9,450,638.86) 10,015,958.76 790,957.40 790,958.76 1.36
<br /> 02/01/2018 730,637.50 - - 730,637.50 790,948.76 60,311.26
<br /> 02/01/2019 730,537.50 - - 730,537.50 795,368.76 64,831.26
<br /> 02/01/2020 730,237.50 - - 730,237.50 793,813.76 63,576.26
<br /> 02/01/2021 734,737.50 - - 734,737.50 796,458.76 61,721.26
<br /> 02/01/2022 733,937.50 - - 733,937.50 798,091.26 64,153.76
<br /> 02/01/2023 737 937.50 - - 737,937.50 798,691.26 60,753.76
<br /> 02/01/2024 736,637.50 - - 736,637.50 798,238.76 61,601.26
<br /> 02/01/2025 740,137.50 - - 740,137.50 801,976.26 61,838.76
<br /> 02/01/2026 743,337.50 - - 743,337.50 804,426.26 61,088.76
<br /> 02/01/2027 741,237.50 - - 741,237.50 805,707.50 64,470.00
<br /> 02/01/2028 742,400.00 - - 742,400.00 805,807.50 63,407.50
<br /> 02/01/2029 747,437.50 - - 747,437.50 809,557.50 62,120.00
<br /> 02/01/2030 756,187.50 - - 756,187.50 816,720.00 60,532.50
<br /> 02/01/2031 752,625.00 - - 752,625.00 817,395.00 64,770.00
<br /> 02/01/2032 758,650.00 - - 758,650.00 821,435.00 62,785.00
<br /> 02/01/2033 762,200.00 - - 762,200.00 823,970.00 61,770.00
<br /> Total $12,774,530.52 (10,120,656.88) $11,614,615.07 $14,267,109.02 $15,268,221.41 $1,001,112.39
<br /> PV Analysis Summary(Net to Net)
<br /> Gross PV Debt Service Savin•s 794,486.16
<br /> Net PV Cashflow Savings nu, 1.943%(Bond Yield) 794,486.16
<br /> Contingency or Rounding Amount 1,379.69
<br /> Net Present Value Benefit $795,865.85
<br /> Net PV Benefit/$10,163,686.31 PV Refunded Debt Service 7.830%
<br /> Net PV Benefit/ $9,225,000 Refunded Principal... 8.627%
<br /> Net PV Benefit/ $9,685,000 Re£undin_Princi.al.. 8.218%
<br /> Refunding Bond Information
<br /> Refundin•Dated Date 2/12/2013
<br /> Refunding Delivery Date 2/12/2013
<br /> Series 2013 Xovr Ref Ser I SINGLE PURPOSE I 1/15/2013 I 12:50 PM
<br /> 0 EHLERS
<br /> LEADERS IN PUBLIC FINANCE Page 4
<br />
|