|
City of Ramsey, Minnesota
<br />$1,235,000 General Obligation Bonds, Series 2015
<br />Assumes Current Market BQ AA+ Rates plus 25bps
<br />10 Years
<br />Debt Service Schedule
<br />Date Principal Coupon Interest Total P+I CIF Net New D/S 105% of Total Fiscal Total
<br />05/01/2015 - - -
<br />12/01/2015 - 12,134.79 12,134.79 (12,134,79)
<br />06/01/2016 - 10,401.25 10,401,25 (10,401.25) - -
<br />12/01/2016 115,000.00 0.850% 10,401.25 125,401.25 - 125,401.25 131,671.31 131,671.31
<br />06/01/2017 - - 9,912.50 9,912.50 - 9,912.50 10,408.13 -
<br />12/01/2017 115,000.00 1.050% 9,912.50 124,912.50 124,912.50 131,158.13 141,566.25
<br />06/01/2018 - - 9,308.75 9,308.75 9,308.75 9,774.19
<br />12/01/2018 120,000.00 1.250% 9,308.75 129,308.75 129,308.75 135,774.19 145,548.38
<br />06/01/2019 - - 8,558.75 8,558.75 8,558.75 8,986.69
<br />12/01/2019 120,000.00 1.400% 8,558.75 128,558.75 128,558.75 134,986.69 143,973.38
<br />06/01/2020 - - 7,718.75 7,718.75 7,718.75 8,104.69
<br />12/01/2020 120,000.00 1.650% 7,718.75 127,718.75 127,718.75 134,104.69 142,209.38
<br />06/01/2021 - - 6,728.75 6,728.75 6,728.75 7,065.19
<br />12/01/2021 125,000.00 1.750% 6,728.75 131,728.75 131,728.75 138,315.19 145,380.38
<br />06/01/2022 - 5,635 00 5,635.00 5,635.00 5,916.75
<br />12/01/2022 125,000.00 1.900% 5,635.00 130,635.00 130,635.00 137,166.75 143,083.50
<br />06/01/2023 - - 4,447.50 4,447.50 4,447.50 4,669.88 -
<br />12/01/2023 130,000.00 2.050% 4,447.50 134,447.50 134,447.50 141,169.88 145,839.75
<br />06/01/2024 - - 3,115.00 3,115.00 3,115.00 3,270.75
<br />12/01/2024 130,000.00 2.300% 3,115.00 133,115.00 _ 133,115.00 139,770.75 143,041.50
<br />06/01/2025 - - 1,620.00 1,620.00 1,620.00 1,701.00
<br />12/01/2025 135,000.00 2.400% 1,620.00 136,620.00 136,620.00 143,451.00 145,152.00
<br />Total $1,235,000.00 - $147,027.29 51,382,027,29 (22,536.04) $1,359,491,25 $1,427,465.81
<br />Significant Dates
<br />Dated
<br />First Coupon Date
<br />Yield Statistics
<br />5/01/2015
<br />12/01/2015
<br />Bond Year Dollars
<br />Average Life
<br />Average Coupon
<br />Net Interest Cost (NIC)
<br />True Interest Cost (TIC)
<br />Bond Yield for Arbitrage Purposes
<br />All Inclusive Cost (AIC)
<br />2015 GO Street Reconstruc 1 SINGLE PURPOSE 1 2/ 2/2015 1 12:57 PM
<br />EHLERS
<br />LEADERS IN PUBLIC FINANCE
<br />$7,690.42
<br />6.227 Years
<br />1.9118248%
<br />2.1045321%
<br />2.1101665%
<br />1.9018418%
<br />2.6305974%
<br />
|