|
City of Ramsey, Minnesota
<br />$5,125,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 - - 59,146.88 59,146.88
<br />08/01/2023 - - 39,431.25 39,431.25
<br />02/01/2024 485,000.00 1.000% 39,431.25 524,431.25
<br />08/01/2024 - - 37,006.25 37,006.25
<br />02/01/2025 485,000.00 1.100% 37,006.25 522,006.25
<br />08/01/2025 - - 34,338.75 34,338.75
<br />02/01/2026 495,000.00 1.200% 34,338.75 529,338.75
<br />08/01/2026 - - 31,368.75 31,368.75
<br />02/01/2027 500,000.00 1.300% 31,368.75 531,368.75
<br />08/01/2027 - - 28,118.75 28,118.75
<br />02/01/2028 505,000.00 1.500% 28,118.75 533,118.75
<br />08/01/2028 - - 24,331.25 24,331.25
<br />02/01/2029 515,000.00 1.650% 24,331.25 539,331.25
<br />08/01/2029 - - 20,082.50 20,082.50
<br />02/01/2030 520,000.00 1.750% 20,082.50 540,082.50
<br />08/01/2030 - - 15,532.50 15,532.50
<br />02/01/2031 530,000.00 1.850% 15,532.50 545,532.50
<br />08/01/2031 - - 10,630.00 10,630.00
<br />02/01/2032 540,000.00 1.900% 10,630.00 550,630.00
<br />08/01/2032 - - 5,500.00 5,500.00
<br />02/01/2033 550,000.00 2.000% 5,500.00 555,500.00
<br />Fiscal Total
<br />59,146.88
<br />563,862.50
<br />559,012.50
<br />563,677.50
<br />562,737.50
<br />561,237.50
<br />563,662.50
<br />560,165.00
<br />561,065.00
<br />561,260.00
<br />561,000.00
<br />Total $5,125,000.00 $551,826.88 $5,676,826.88
<br />Yield Statistics
<br />Bond Year Dollars $32,638.75
<br />Average Life 6.369 Years
<br />Average Coupon 1.6907108%
<br />Net Interest Cost (NIC) 1.8791372%
<br />True Interest Cost (TIC) 1.8867667%
<br />Bond Yield for Arbitrage Purposes 1.6843271%
<br />All Inclusive Cost (AIC) 2.0975357%
<br />IRS Form 8038
<br />Net Interest Cost 1.6907108%
<br />Weighted Average Maturity 6.369 Years
<br />2022 GO Wat Rev Bds - $5M I SINGLE PURPOSE 1 6/16/2021 1 11:13 AM
<br />gig EHLERS Rs
<br />PUBLIC FINANCi ,ORS
<br />
|