|
City of Ramsey, Minnesota
<br />$7,645,000 General Obligation CIP Bonds, Series 2021
<br />Assumes Current Market BQ AA+ Rates plus 100bps
<br />Wrap Around Debt - $7.5M Cash
<br />Debt Service Schedule
<br />105%
<br />Date Principal Coupon Interest Total P+I Overlevy
<br />12/15/2021 - - - -
<br />12/15/2022 - 293,662.50 293,662.50 308,345.63
<br />12/15/2023 - - 293,662.50 293,662.50 308,345.63
<br />12/15/2024 - 293,662.50 293,662.50 308,345.63
<br />12/15/2025 - 293,662.50 293,662.50 308,345.63
<br />12/15/2026 - - 293,662.50 293,662.50 308,345.63
<br />12/15/2027 - 293,662.50 293,662.50 308,345.63
<br />12/15/2028 - 293,662.50 293,662.50 308,345.63
<br />12/15/2029 - 293,662.50 293,662.50 308,345.63
<br />12/15/2030 - - 293,662.50 293,662.50 308,345.63
<br />12/15/2031 - - 293,662.50 293,662.50 308,345.63
<br />12/15/2032 645,000.00 3.500% 293,662.50 938,662.50 985;595.63
<br />12/15/2033 670,000.00 3.550% 271,087.50 941,087.50 988,141.88
<br />12/15/2034 690,000.00 3.650% 247,302.50 937,302.50 984,167.63
<br />12/15/2035 720,000.00 3.700% 222,117.50 942,117.50 989,223.38
<br />12/15/2036 745,000.00 3.800% 195,477.50 940,477.50 987,501.38
<br />12/15/2037 770,000.00 3.900% 167,167.50 937,167.50 984,025.88
<br />12/15/2038 800,000.00 3.950% 137,137.50 937,137.50 983,994.38
<br />12/15/2039 835,000.00 4.000% 105,537.50 940,537.50 987,564.38
<br />12/15/2040 865,000.00 4.050% 72,137.50 937,137.50 983,994.38
<br />12/15/2041 905,000.00 4.100% 37,105.00 942,105.00 989,210.25
<br />Total $7,645,000.00
<br />$4,685,357.50
<br />S12,330,357.50 $12,946,875.38
<br />Significant Dates
<br />Dated
<br />First Coupon Date
<br />Yield Statistics
<br />12/15/2021
<br />6/15/2022
<br />Bond Year Dollars
<br />Average Life
<br />Average Coupon
<br />Net Interest Cost (NIC)
<br />True Interest Cost (TIC)
<br />Bond Yield for Arbitrage Purposes
<br />All Inclusive Cost (AIC)
<br />IRS Form 8038
<br />$120,845.00
<br />15.807 Years
<br />3.8771629%
<br />3.9404258%
<br />3.9541032%
<br />3.8679635%
<br />4.0282090%
<br />Net Interest Cost
<br />Weighted Average Maturity
<br />2021 GO CIP Bonds - $7.5M 1 SINGLE PURPOSE 1 4/29/2019 1 1:19 PM
<br />3.8771629%
<br />15.807 Years
<br />II_EHLERS
<br />LEADERS IN NVOLIC r,N ,NCE
<br />
|