|
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 />15 Years
<br />Debt Service Schedule
<br />Date Principal Coupon Interest Total P+I
<br />05/01/2022 - - - -
<br />02/01/2023 - - 134,098.13 134,098.13
<br />08/01/2023 - - 89,398.75 89,398.75
<br />02/01/2024 600,000.00 1.000% 89,398.75 689,398.75
<br />08/01/2024 - - 86,398.75 86,398.75
<br />02/01/2025 605,000.00 1.100% 86,398.75 691,398.75
<br />08/01/2025 - - 83,071.25 83,071.25
<br />02/01/2026 610,000.00 1.200% 83,071.25 693,071.25
<br />08/01/2026 - - 79,411.25 79,411.25
<br />02/01/2027 620,000.00 1.300% 79,411.25 699,411.25
<br />08/01/2027 - - 75,381.25 75,381.25
<br />02/01/2028 630,000.00 1.500% 75,381.25 705,381.25
<br />08/01/2028 - - 70,656.25 70,656.25
<br />02/01/2029 635,000.00 1.650% 70,656.25 705,656.25
<br />08/01/2029 - - 65,417.50 65,417.50
<br />02/01/2030 650,000.00 1.750% 65,417.50 715,417.50
<br />08/01/2030 - - 59,730.00 59,730.00
<br />02/01/2031 660,000.00 1.850% 59,730.00 719,730.00
<br />08/01/2031 - - 53,625.00 53,625.00
<br />02/01/2032 670,000.00 1.900% 53,625.00 723,625.00
<br />08/01/2032 - - 47,260.00 47,260.00
<br />02/01/2033 685,000.00 2.000% 47,260.00 732,260.00
<br />08/01/2033 - - 40,410.00 40,410.00
<br />02/01/2034 695,000.00 2.050% 40,410.00 735,410.00
<br />08/01/2034 - - 33,286.25 33,286.25
<br />Fiscal Total
<br />134,098.13
<br />778,797.50
<br />777,797.50
<br />776,142.50
<br />778,822.50
<br />780,762.50
<br />776,312.50
<br />780,835.00
<br />779,460.00
<br />777,250.00
<br />02/01/2035 710,000.00 2.150% 33,286.25 743,286.25
<br />08/01/2035 - - 25,653.75 25,653.75
<br />02/01/2036 725,000.00 2.250% 25,653.75 750,653.75
<br />08/01/2036 - - 17,497.50 17,497.50
<br />02/01/2037 745,000.00 2.300% 17,497.50 762,497.50
<br />08/01/2037 - - 8,930.00 8,930.00
<br />02/01/2038 760,000.00 2.350% 8,930.00 768,930.00
<br />779,520.00
<br />775,820.00
<br />776,572.50
<br />776,307.50
<br />779,995.00
<br />777,860.00
<br />Total $10,000,000.00 $1,806,353.13 $11,806,353.13
<br />Yield Statistics
<br />Bond Year Dollars
<br />Average Life
<br />$90,710.00
<br />9.071 Years
<br />Average Coupon 1.9913495%
<br />Net Interest Cost (NIC)
<br />True Interest Cost (TIC)
<br />2.1236392%
<br />2.1271457%
<br />Bond Yield for Arbitrage Purposes 1.9789244%
<br />All Inclusive Cost (AIC) 2.2285715%
<br />IRS Form 8038
<br />Net Interest Cost 1.9913495%
<br />Weighted Average Maturity 9.071 Years
<br />2022 GO Wat Rev Bds - $10 I SINGLE PURPOSE 1 6/16/2021 1 11:45 AM
<br />EHLERS
<br />am PUBLIC FINANCE ADVI
<br />
|