|
City of Ramsey, Minnesota
<br />$10,000,000 General Obligation Water Revenue Bonds, Series 2022
<br />Assumes Current Market 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 - - 115,434.38 115,434.38
<br />08/01/2023 - - 76,956.25 76,956.25
<br />02/01/2024 945,000.00 1.000% 76,956.25 1,021,956.25
<br />08/01/2024 - - 72,231.25 72,231.25
<br />02/01/2025 950,000.00 1.100% 72,231.25 1,022,231.25
<br />08/01/2025 - - 67,006.25 67,006.25
<br />02/01/2026 960,000.00 1.200% 67,006.25 1,027,006.25
<br />08/01/2026 - - 61,246.25 61,246.25
<br />02/01/2027 975,000.00 1.300% 61,246.25 1,036,246.25
<br />08/01/2027 - - 54,908.75 54,908.75
<br />02/01/2028 985,000.00 1.500% 54,908.75 1,039,908.75
<br />08/01/2028 - - 47,521.25 47,521.25
<br />02/01/2029 1,000,000.00 1.650% 47,521.25 1,047,521.25
<br />08/01/2029 - - 39,271.25 39,271.25
<br />02/01/2030 1,020,000.00 1.750% 39,271.25 1,059,271.25
<br />08/01/2030 - - 30,346.25 30,346.25
<br />02/01/2031 1,035,000.00 1.850% 30,346.25 1,065,346.25
<br />08/01/2031 - - 20,772.50 20,772.50
<br />02/01/2032 1,055,000.00 1.900% 20,772.50 1,075,772.50
<br />08/01/2032 - - 10,750.00 10,750.00
<br />02/01/2033 1,075,000.00 2.000% 10,750.00 1,085,750.00
<br />Fiscal Total
<br />115,434.38
<br />1,098,912.50
<br />1,094,462.50
<br />1,094,012.50
<br />1,097,492.50
<br />1,094,817.50
<br />1,095,042.50
<br />1,098,542.50
<br />1,095,692.50
<br />1,096,545.00
<br />1,096,500.00
<br />Total $10,000,000.00 $1,077,454.38 $11,077,454.38
<br />Yield Statistics
<br />Bond Year Dollars $63,715.00
<br />Average Life 6.372 Years
<br />Average Coupon 1.6910529%
<br />Net Interest Cost (NIC) 1.8793916%
<br />True Interest Cost (TIC)
<br />Bond Yield for Arbitrage Purposes
<br />1.8870244%
<br />1.6846710%
<br />All Inclusive Cost (AIC) 2.0254549%
<br />IRS Form 8038
<br />Net Interest Cost 1.6910529%
<br />Weighted Average Maturity 6.372 Years
<br />2022 GO Wat Rev Bds - $10 I SINGLE PURPOSE 1 6/16/2021 1 11:44 AM
<br />EHLERS
<br />PUBLIC FINANC �"
<br />
|