|
City of Ramsey, Minnesota
<br />$875,000 General Obligation Bonds, Series 2014A
<br />Assumes Current Market BQ AA+ Rates plus 25bps
<br />Dec 15th Principal Payments
<br />Debt Service Schedule
<br />105%
<br />Date Principal Coupon Interest Total P+I Overlevy Fiscal Total
<br />11/15/2014 - - - -
<br />06/15/2015 - - 8,701.88 8,701.88 9,136.97
<br />12/15/2015 80,000.00 0.650% 7,458.75 87,458.75 91,831.69 100,968.66
<br />06/15/2016 - - 7,198.75 7,198.75 7,558.69
<br />12/15/2016 85,000.00 0.850% 7,198.75 92,198.75 96,808.69 104,367.38
<br />06/15/2017 - - 6,837.50 6,837.50 7,179.38
<br />12/15/2017 85,000.00 1.100% 6,837.50 91,837.50 96,429.38 103,608.75
<br />06/15/2018 - - 6,370.00 6,370.00 6,688.50
<br />12/15/2018 85,000.00 1.350% 6,370.00 91,370.00 95,938.50 102,627.00
<br />06/15/2019 - - 5,796.25 5,796.25 6,086.06
<br />12/15/2019 85,000.00 1.600% 5,796.25 90,796.25 95,336.06 101,422.13
<br />06/15/2020 - - 5,116.25 5,116.25 5,372.06
<br />12/15/2020 85,000.00 1.900% 5,116.25 90,116.25 94,622.06 99,994.13
<br />06/15/2021 - - 4,308.75 4,308.75 4,524.19
<br />12/15/2021 90,000.00 2.100% 4,308.75 94,308.75 99,024.19 103,548.38
<br />06/15/2022 - - 3,363.75 3,363.75 3,531.94
<br />12/15/2022 90,000.00 2.250% 3,363.75 93,363.75 98,031.94 101,563.88
<br />06/15/2023 - - 2,351.25 2,351.25 2,468.81
<br />12/15/2023 95,000.00 2.350% 2,351.25 97,351.25 102,218.81 104,687.63
<br />06/15/2024 - - 1,235.00 1,235.00 1,296.75
<br />12/15/2024 95,000.00 2.600% 1,235.00 96,235.00 101,046.75 102,343.50
<br />Total $875,000.00 - $101,315.63 $976,315.63 $1,025,131.41
<br />Significant Dates
<br />Dated 11/15/2014
<br />First Coupon Date 6/15/2015
<br />Yield Statistics
<br />Bond Year Dollars $5,007.92
<br />Average Life 5.723 Years
<br />Average Coupon 2.0231093%
<br />Net Interest Cost (NIC) 2.2851944%
<br />True Interest Cost (TIC) 2.2945230%
<br />Bond Yield for Arbitrage Purposes 2.0106491%
<br />All Inclusive Cost (AIC) 2.9510594%
<br />IRS Form 8038
<br />Net Interest Cost 2.0231093%
<br />Weighted Average Maturity 5.723 Years
<br />2014 GO Bonds - PreSale R I Equipment Portion 111/ 5/2014 1 12:30 PM
<br />EHLERS
<br />LEADERS IN PUBLIC FINANCE
<br />
|