|
Preliminary
<br />City of Ramsey. EDA, Minnesota
<br />0.6. Refunding Bonds, Series 2012 (Level Savings)
<br />2005A (Assumes Old Reserve Earnings at 2.50 %)
<br />Debt Service Comparison
<br />Date
<br />1 2115/2012
<br />12/1 5/2013
<br />12/15/2014
<br />12/15/2015
<br />12/15/2016
<br />12/15/2017
<br />12/15/2018
<br />12/15/2019
<br />12/15/2020
<br />1 2/15/2021
<br />12/15/2022
<br />12/15/2023
<br />12/15/2024
<br />12/15/2025
<br />12/15/2026
<br />12/15/2027
<br />- 12/15/2028
<br />12/15/2029
<br />12/15/2030
<br />12/15/2031
<br />Total P+I
<br />1,155,761.72
<br />1,155,305.00
<br />1,156,885.00
<br />1,156,912.50
<br />1,155,367.50
<br />1,157,230.00
<br />1,157,417.50
<br />1,155,890.00
<br />1,157,607.50
<br />1 ,157,437.50
<br />1,154, 902.50
<br />1,155,352.50
<br />1,158,167.50
<br />1,153,555.00
<br />1,156,562.50
<br />1,157,267.50
<br />1,155,580,00
<br />1,156,912.50
<br />1,155,512.50
<br />1,156, 812.50
<br />Total $23,126,439.22
<br />PV Analysis Summary (Net to Net)
<br />Gross PV Debt Service Savings
<br />Effects of changes in DSR investments
<br />Net PV Cashflow Savings @ 2.798 %(Bond Yield)
<br />Contingency or Rounding Amount
<br />Net Present Value Benefit
<br />Net PV Benefit 1 $19,229,129.07 PV Refunded Debt Service
<br />Net PV Benefit / $17,040,000 Refunded Principal...
<br />Net PV Benefit 1 $17,670,000 Refunding Principal..
<br />Refunding Bond Information
<br />Refunding Dated Date
<br />Refunding Delivery Date
<br />05ref 1200 1 SINGLE PURPOSE 1 1/11/2012 1 10:29 AM
<br />II Northland Securities
<br />Public Finance
<br />Net New WS.
<br />1,153,635.74
<br />1,155,305.00
<br />1,156,885,00
<br />1,156,912.50
<br />1,155,367.50
<br />1,157,230.00
<br />1,157,417.50
<br />1,155,890.00
<br />1,157,607.50
<br />1,157,437.50
<br />1,154,902.50
<br />1,155,352.50
<br />1,158,167.50
<br />1 ,153,555.00
<br />1,156,562.50
<br />1,157,267.50
<br />1,155,580.00
<br />1,156,912.50
<br />1,155, 512.50
<br />1,156,81 2.50
<br />$23,124,313,24
<br />c
<br />16/1Th
<br />Old Net DIS
<br />1,486,222.07
<br />1,473,516.50
<br />1,476, 841.50
<br />1,470,504.00
<br />1,472,891.50
<br />1,468,579.00
<br />1,442,779.00
<br />1,436,341.50
<br />1,455,941.50
<br />1,411,001.50
<br />1,361,061.50
<br />1,436,331.50
<br />1,444,784.00
<br />1,455,626.50
<br />1,493,641.50
<br />(25,118,50)
<br />Savings
<br />332,586.33
<br />318,211.50
<br />319,956.50
<br />31 3,591.50
<br />317,524.00
<br />311,349.00
<br />285,361.50
<br />280,451.50
<br />298,334.00
<br />253,564.00
<br />206,159.00
<br />280,979.00
<br />286,616.50
<br />302,071.50
<br />337, 079.00
<br />(1,182,386.00)
<br />(1,155,580.00)
<br />(1,156,912.50)
<br />(1,155,512.50)
<br />(1,156,812.50)
<br />$21,760,944.57 (1,363,368,67)
<br />1,559,129.07
<br />(1,474,308.72)
<br />Page 2
<br />84,820,35
<br />2,125, 98
<br />$86,946.33
<br />0,452%
<br />0.510%
<br />0.492%
<br />4/01/2012
<br />4/01/2012
<br />
|