|
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 />15 Years
<br />Debt Service Schedule
<br />Date Principal Coupon Interest Total P+I
<br />05/01/2022 - - - -
<br />02/01/2023 - - 68,737.50 68,737.50
<br />08/01/2023 - - 45,825.00 45,825.00
<br />02/01/2024 305,000.00 1.000% 45,825.00 350,825.00
<br />08/01/2024 - - 44,300.00 44,300.00
<br />02/01/2025 310,000.00 1.100% 44,300.00 354,300.00
<br />08/01/2025 - - 42,595.00 42,595.00
<br />02/01/2026 315,000.00 1.200% 42,595.00 357,595.00
<br />08/01/2026 - - 40,705.00 40,705.00
<br />02/01/2027 320,000.00 1.300% 40,705.00 360,705.00
<br />08/01/2027 - - 38,625.00 38,625.00
<br />02/01/2028 320,000.00 1.500% 38,625.00 358,625.00
<br />08/01/2028 - - 36,225.00 36,225.00
<br />02/01/2029 325,000.00 1.650% 36,225.00 361,225.00
<br />08/01/2029 - - 33,543.75 33,543.75
<br />02/01/2030 330,000.00 1.750% 33,543.75 363,543.75
<br />08/01/2030 - - 30,656.25 30,656.25
<br />02/01/2031 340,000.00 1.850% 30,656.25 370,656.25
<br />08/01/2031 - - 27,511.25 27,511.25
<br />02/01/2032 345,000.00 1.900% 27,511.25 372,511.25
<br />08/01/2032 - - 24,233.75 24,233.75
<br />02/01/2033 350,000.00 2.000% 24,233.75 374,233.75
<br />08/01/2033 - - 20,733.75 20,733.75
<br />02/01/2034 355,000.00 2.050% 20,733.75 375,733.75
<br />08/01/2034 - - 17,095.00 17,095.00
<br />02/01/2035 365,000.00 2.150% 17,095.00 382,095.00
<br />08/01/2035 - - 13,171.25 13,171.25
<br />02/01/2036 375,000.00 2.250% 13,171.25 388,171.25
<br />08/01/2036 - - 8,952.50 8,952.50
<br />02/01/2037 380,000.00 2.300% 8,952.50 388,952.50
<br />08/01/2037 - - 4,582.50 4,582.50
<br />02/01/2038 390,000.00 2.350% 4,582.50 394,582.50
<br />Fiscal Total
<br />68,737.50
<br />396,650.00
<br />398,600.00
<br />400,190.00
<br />401,410.00
<br />397,250.00
<br />397,450.00
<br />397,087.50
<br />401,312.50
<br />400,022.50
<br />398,467.50
<br />396,467.50
<br />399,190.00
<br />401,342.50
<br />397,905.00
<br />399,165.00
<br />Total $5,125,000.00 $926,247.50 $6,051,247.50
<br />Yield Statistics
<br />Bond Year Dollars $46,508.75
<br />Average Life 9.075 Years
<br />Average Coupon 1.9915554%
<br />Net Interest Cost (NIC) 2.1237885%
<br />True Interest Cost (TIC) 2.1272939%
<br />Bond Yield for Arbitrage Purposes 1.9791308%
<br />All Inclusive Cost (AIC) 2.2816028%
<br />IRS Form 8038
<br />Net Interest Cost 1.9915554%
<br />Weighted Average Maturity 9.075 Years
<br />2022 GO Wat Rev Bds - $5M I SINGLE PURPOSE 1 6/16/2021 1 11:13 AM
<br />6...% EHLERS
<br />PUBLIC INANCE ADVI'.
<br />
|