|
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 />15 Years
<br />Debt Service Schedule
<br />Date Principal Coupon Interest Total P+I
<br />05/01/2022 - - - -
<br />02/01/2023 - - 236,977.50 236,977.50
<br />08/01/2023 - - 157,985.00 157,985.00
<br />02/01/2024 965,000.00 1.050% 157,985.00 1,122,985.00
<br />08/01/2024 - - 152,918.75 152,918.75
<br />02/01/2025 975,000.00 1.200% 152,918.75 1,127,918.75
<br />08/01/2025 - - 147,068.75 147,068.75
<br />02/01/2026 985,000.00 1.300% 147,068.75 1,132,068.75
<br />08/01/2026 - - 140,666.25 140,666.25
<br />02/01/2027 1,000,000.00 1.450% 140,666.25 1,140,666.25
<br />08/01/2027 - - 133,416.25 133,416.25
<br />02/01/2028 1,015,000.00 1.650% 133,416.25 1,148,416.25
<br />08/01/2028 - - 125,042.50 125,042.50
<br />02/01/2029 1,030,000.00 1.800% 125,042.50 1,155,042.50
<br />08/01/2029 - - 115,772.50 115,772.50
<br />02/01/2030 1,050,000.00 1.900% 115,772.50 1,165,772.50
<br />08/01/2030 - - 105,797.50 105,797.50
<br />02/01/2031 1,070,000.00 2.000% 105,797.50 1,175,797.50
<br />08/01/2031 - - 95,097.50 95,097.50
<br />02/01/2032 1,090,000.00 2.050% 95,097.50 1,185,097.50
<br />08/01/2032 - - 83,925.00 83,925.00
<br />02/01/2033 1,115,000.00 2.150% 83,925.00 1,198,925.00
<br />08/01/2033 - - 71,938.75 71,938.75
<br />02/01/2034 1,135,000.00 2.200% 71,938.75 1,206,938.75
<br />08/01/2034 - - 59,453.75 59,453.75
<br />02/01/2035 1,165,000.00 2.350% 59,453.75 1,224,453.75
<br />08/01/2035 - - 45,765.00 45,765.00
<br />02/01/2036 1,190,000.00 2.450% 45,765.00 1,235,765.00
<br />08/01/2036 - - 31,187.50 31,187.50
<br />02/01/2037 1,220,000.00 2.500% 31,187.50 1,251,187.50
<br />08/01/2037 - - 15,937.50 15,937.50
<br />02/01/2038 1,250,000.00 2.550% 15,937.50 1,265,937.50
<br />Fiscal Total
<br />236,977.50
<br />1,280,970.00
<br />1,280,837.50
<br />1,279,137.50
<br />1,281,332.50
<br />1,281,832.50
<br />1,280,085.00
<br />1,281,545.00
<br />1,281,595.00
<br />1,280,195.00
<br />1,282,850.00
<br />1,278,877.50
<br />1,283,907.50
<br />1,281,530.00
<br />1,282,375.00
<br />1,281,875.00
<br />Total $16,255,000.00 $3,200,922.50 $19,455,922.50
<br />Yield Statistics
<br />Bond Year Dollars $147,951.25
<br />Average Life 9.102 Years
<br />Average Coupon 2.1634981%
<br />Net Interest Cost (NIC) 2.2733654%
<br />True Interest Cost (TIC)
<br />Bond Yield for Arbitrage Purposes
<br />2.2730383%
<br />2.1489818%
<br />All Inclusive Cost (AIC) 2.3432290%
<br />IRS Form 8038
<br />Net Interest Cost 2.1634981%
<br />Weighted Average Maturity 9.102 Years
<br />2022 GO Wat Rev Bds - $16 I SINGLE PURPOSE 1 6/16/2021 111:20 AM
<br />EHLERS
<br />IN PUBLIC FINANCE ADVISG.
<br />
|