|
Preliminary
<br />City of Ramsey EDA, Minnesota
<br />G.O. Refunding Bonds, Series 2010
<br />2005A (Assumes Old Reserve Earnings at 4.50 %)
<br />Debt Service Comparison
<br />S v./
<br />'
<br />Adss� 5
<br />(0S . o2/ a
<br />0 `s
<br />Date Total P +I
<br />Net New D/S
<br />Old Net D/S
<br />Savings
<br />12/15/2010 1,064,820.00
<br />1,063,085.60
<br />1,068,838.85
<br />5,753.25
<br />12/15/2011 1,212,240.00
<br />1,212,240.00
<br />1,439,277.70
<br />227,037.70
<br />12/15/2012 1,208,815.00
<br />1,208,815.00
<br />1,444,277.70
<br />235,462.70
<br />12/15/2013 1,209,020.00
<br />1,209,020.00
<br />1,442,877.70
<br />233,857.70
<br />12/15/2014 1,212,120.00
<br />1,212,120.00
<br />1,446,202.70
<br />234,082.70
<br />12/15/2015 1,213,020.00
<br />1,213,020.00
<br />1,439,865.20
<br />226,845.20
<br />12/15/2016 1,210,950.00
<br />1,210,950.00
<br />1,442,252.70
<br />231,302.70
<br />12/15/2017 1,211,190.00
<br />1,211,190.00
<br />1,437,940.20
<br />226,750.20
<br />12/15/2018 1,208,917.50
<br />1,208,917.50
<br />1,412,140.20
<br />203,222.70
<br />12/15/2019 1,209,417.50
<br />1,209,417.50
<br />1,405,702.70
<br />196,285.20
<br />12/15/2020 1,208,242.50
<br />1,208,242.50
<br />1,425,302.70
<br />217,060.20
<br />12/15/2021 1,210,332.50
<br />1,210,332.50
<br />1,380,362.70
<br />170,030.20
<br />12/15/2022 1,210,475.00
<br />1,210,475.00
<br />1,330,422.70
<br />119,947.70
<br />12/15/2023 1,208,595.00
<br />1,208,595.00
<br />1,405,692.70
<br />197,097.70
<br />12/15/2024 1,209,617.50
<br />1,209,617.50
<br />1,414,145.20
<br />204,527.70
<br />12/15/2025 1,208,292.50
<br />1,208,292.50
<br />1,424,987.70
<br />216,695.20
<br />12/15/2026 1,209,992.50
<br />1,209,992.50
<br />1,463,002.70
<br />253,010.20
<br />12/15/2027 1,209,472.50
<br />1,209,472.50
<br />(55,757.30)
<br />(1,265,229.80)
<br />12/15/2028 1,211,662.50
<br />1,211,662.50
<br />-
<br />(1,211,662.50)
<br />12/15/2029 1,211,297.50
<br />1,211,297.50
<br />-
<br />(1,211,297.50)
<br />12/15/2030 1,208,297.50
<br />1,208,297.50
<br />-
<br />(1,208,297.50)
<br />12/15/2031 1,208,140.00
<br />1,208,140.00
<br />-
<br />(1,208,140.00)
<br />Total $26,474,927.50
<br />$26,473,193.10
<br />$23,767,534.75
<br />(2,705,658.35)
<br />PV Analysis Summary (Net to Net)
<br />Gross PV Debt Service Savings
<br />1,139,686.48
<br />Effects of changes in DSR investments
<br />(1,754,514.38)
<br />Net PV Cashflow Savings @ 3.392 %(Bond Yield)
<br />(614,827.91)
<br />Contingency or Rounding Amount
<br />1.740
<br />Net Present Value Loss
<br />I $(613,093.51)
<br />Net PV Loss / $19,854,686.48 PV Refunded Debt Service
<br />(3.088 %)
<br />Net PV Loss / $18,500,000 Refunded Principal...
<br />(3.314 %)
<br />Net PV Loss / $18,715,000 Refunding Principal..
<br />(3.276 %)
<br />Refunding Bond Information
<br />Refunding Dated Date
<br />6/15/2010
<br />Refunding Delivery Date
<br />6/15/2010
<br />05ref I SINGLE PURPOSE 1 3/ 9/2010 1 12:51 PM
<br />Northland Securities
<br />Public Finance
<br />Page 2
<br />S - yet,
<br />©Of:).
<br />- 7 rex
<br />
|