|
City of Ramsey, Minnesota
<br />$12,075,000 General Obligation Street Reconstruction Bonds, Series 2022A
<br />Assumes Current Market Non-BQ AA+ Market Rates + 75bps
<br />Debt Service Schedule
<br />Date Principal Coupon Interest Total P+I
<br />12/06/2022 - - - -
<br />12/15/2023 550,000.00 3.900% 538,801.50 1,088,801.50
<br />06/15/2024 - - 252,105.00 252,105.00
<br />12/15/2024 620,000.00 3.900% 252,105.00 872,105.00
<br />06/15/2025 - - 240,015.00 240,015.00
<br />12/15/2025 645,000.00 4.000% 240,015.00 885,015.00
<br />06/15/2026 - - 227,115.00 227,115.00
<br />12/15/2026 670,000.00 4.050% 227,115.00 897,115.00
<br />06/15/2027 - - 213,547.50 213,547.50
<br />12/15/2027 700,000.00 4.100% 213,547.50 913,547.50
<br />06/15/2028 - - 199,197.50 199,197.50
<br />12/15/2028 730,000.00 4.200% 199,197.50 929,197.50
<br />06/15/2029 - - 183,867.50 183,867.50
<br />12/15/2029 760,000.00 4.250% 183,867.50 943,867.50
<br />06/15/2030 - - 167,717.50 167,717.50
<br />Fiscal Total
<br />1,088,801.50
<br />1,124,210.00
<br />1,125,030.00
<br />1,124,230.00
<br />1,127,095.00
<br />12/15/2030 790,000.00 4.300% 167,717.50 957,717.50
<br />06/15/2031 - - 150,732.50 150,732.50
<br />12/15/2031 825,000.00 4.350% 150,732.50 975,732.50
<br />06/15/2032 - - 132,788.75 132,788.75
<br />12/15/2032 860,000.00 4.450% 132,788.75 992,788.75
<br />1,128,395.00
<br />1,127,735.00
<br />1,125,435.00
<br />1,126,465.00
<br />1,125,577.50
<br />06/15/2033 - - 113,653.75 113,653.75
<br />12/15/2033 900,000.00 4.500% 113,653.75 1,013,653.75
<br />06/15/2034 - - 93,403.75 93,403.75
<br />12/15/2034 940,000.00 4.550% 93,403.75 1,033,403.75
<br />06/15/2035 - - 72,018.75 72,018.75
<br />12/15/2035 980,000.00 4.600% 72,018.75 1,052,018.75
<br />06/15/2036 - - 49,478.75 49,478.75
<br />12/15/2036 1,030,000.00 4.650% 49,478.75 1,079,478.75
<br />06/15/2037 - - 25,531.25 25,531.25
<br />12/15/2037 1,075,000.00 4.750% 25,531.25 1,100,531.25
<br />1,127,307.50
<br />1,126,807.50
<br />1,124,037.50
<br />1,128,957.50
<br />1,126,062.50
<br />Total $12,075,000.00 $4,781,146.50 $16,856,146.50
<br />Yield Statistics
<br />Bond Year Dollars $106,716.88
<br />Average Life
<br />Average Coupon
<br />Net Interest Cost (NIC)
<br />True Interest Cost (TIC)
<br />8.838 Years
<br />4.4802160%
<br />4.5707359%
<br />4.5724258%
<br />Bond Yield for Arbitrage Purposes 4.4575026%
<br />All Inclusive Cost (AIC) 4.6635471%
<br />IRS Form 8038
<br />Net Interest Cost 4.4802160%
<br />Weighted Average Maturity 8.838 Years
<br />Series 2022A GO Street Re I SINGLE PURPOSE 110/ 3/2022 1 10:35 AM
<br />16...Z' EHLERS
<br />PUBLIC FINANCE ADVISORS
<br />
|