|
City of Ramsey, Minnesota
<br />$16,255,000 General Obligation Water Revenue Bonds, Series 2022
<br />Assumes Current Market Non-BQ AA+ Rates plus 75bps
<br />10 Years
<br />Debt Service Schedule
<br />Date Principal Coupon Interest Total P+I
<br />05/01/2022 - - - -
<br />02/01/2023 - - 203,745.00 203,745.00
<br />08/01/2023 - - 135,830.00 135,830.00
<br />02/01/2024 1,525,000.00 1.050% 135,830.00 1,660,830.00
<br />08/01/2024 - - 127,823.75 127,823.75
<br />02/01/2025 1,540,000.00 1.200% 127,823.75 1,667,823.75
<br />08/01/2025 - - 118,583.75 118,583.75
<br />02/01/2026 1,560,000.00 1.300% 118,583.75 1,678,583.75
<br />08/01/2026 - - 108,443.75 108,443.75
<br />02/01/2027 1,580,000.00 1.450% 108,443.75 1,688,443.75
<br />08/01/2027 - - 96,988.75 96,988.75
<br />02/01/2028 1,600,000.00 1.650% 96,988.75 1,696,988.75
<br />08/01/2028 - - 83,788.75 83,788.75
<br />02/01/2029 1,630,000.00 1.800% 83,788.75 1,713,788.75
<br />08/01/2029 - - 69,118.75 69,118.75
<br />02/01/2030 1,655,000.00 1.900% 69,118.75 1,724,118.75
<br />08/01/2030 - - 53,396.25 53,396.25
<br />02/01/2031 1,690,000.00 2.000% 53,396.25 1,743,396.25
<br />08/01/2031 - - 36,496.25 36,496.25
<br />02/01/2032 1,720,000.00 2.050% 36,496.25 1,756,496.25
<br />08/01/2032 - - 18,866.25 18,866.25
<br />02/01/2033 1,755,000.00 2.150% 18,866.25 1,773,866.25
<br />Fiscal Total
<br />203,745.00
<br />1,796,660.00
<br />1,795,647.50
<br />1,797,167.50
<br />1,796,887.50
<br />1,793,977.50
<br />1,797,577.50
<br />1,793,237.50
<br />1,796,792.50
<br />1,792,992.50
<br />1,792,732.50
<br />Total $16,255,000.00 $1,902,417.50 $18,157,417.50
<br />Yield Statistics
<br />Bond Year Dollars $103,711.25
<br />Average Life 6.380 Years
<br />Average Coupon 1.8343405%
<br />Net Interest Cost (NIC) 1.9910738%
<br />True Interest Cost (TIC)
<br />Bond Yield for Arbitrage Purposes
<br />1.9961662%
<br />1.8270705%
<br />All Inclusive Cost (AIC) 2.0918192%
<br />IRS Form 8038
<br />Net Interest Cost 1.8343405%
<br />Weighted Average Maturity 6.380 Years
<br />2022 GO Wat Rev Bds - $16 I SINGLE PURPOSE 1 6/16/2021 1 11:19 AM
<br />EHLERS
<br />PUBLIC FINANC �"
<br />
|