|
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 />Date Principal Coupon Interest Total P+I Fiscal Total
<br />12/15/2021 - - - -
<br />06/15/2022 146,831.25 146,831.25 -
<br />12/15/2022 - 146,831.25 146,831.25 293,662.50
<br />06/15/2023 - 146,831.25 146,831.25
<br />12/15/2023 - 146,831.25 146,831.25 293,662.50
<br />06/15/2024 - 146,831.25 146,831.25
<br />12/15/2024 - 146,831.25 146,831.25 293,662.50
<br />06/15/2025 146,831.25 146,831.25
<br />12/15/2025 - 146,831.25 146,831.25 293,662.50
<br />06/15/2026 146,831.25 146,831.25
<br />12/15/2026 - 146,831.25 146,831.25 293,662.50
<br />06/15/2027 - 146,831.25 146,831.25 -
<br />12/15/2027 - - 146,831.25 146,831.25 293,662.50
<br />06/15/2028 - 146,831.25 146,831.25 -
<br />12/15/2028 - 146,831.25 146,831.25 293,662.50
<br />06/15/2029 146,831.25 146,831.25 -
<br />12/15/2029 146,831.25 146,831.25 293,662.50
<br />06/15/2030 - 146,831.25 146,831.25
<br />12/15/2030 - 146,831.25 146,831.25 293,662.50
<br />06/15/2031 146,831.25 146,831.25 -
<br />12/15/2031 146,831.25 146,831.25 293,662.50
<br />06/15/2032 - 146,831.25 146,831.25 -
<br />12/15/2032 645,000.00 3.500% 146,831.25 791,831.25 938,662.50
<br />06/15/2033 - 135,543.75 135,543.75 -
<br />12/15/2033 670,000.00 3.550% 135,543.75 805,543.75 941,087.50
<br />06/15/2034 - 123,651.25 123,651.25 -
<br />12/15/2034 690,000.00 3.650% 123,651.25 813,651.25 937,302.50
<br />06/15/2035 - - 111,058.75 111,058.75 -
<br />12/15/2035 720,000.00 3.700% 111,058.75 831,058.75 942,117.50
<br />06/15/2036 97,738.75 97,738.75
<br />12/15/2036 745,000.00 3.800% 97,738.75 842,738.75 940,477.50
<br />06/15/2037 83,583.75 83,583.75
<br />12/15/2037 770,000.00 3.900% 83,583.75 853,583.75 937,167.50
<br />06/15/2038 - - 68,568.75 68,568.75
<br />12/15/2038 800,000.00 3.950% 68,568.75 868,568.75 937,137.50
<br />06/15/2039 - - 52,768.75 52,768.75
<br />12/15/2039 835,000.00 4.000% 52,768.75 887,768.75 940,537.50
<br />06/15/2040 - 36,068.75 36,068.75
<br />12/15/2040 865,000.00 4.050% 36,068.75 901,068.75 937,137.50
<br />06/15/2041 - - 18,552.50 18,552.50
<br />12/15/2041 905,000.00 4.100% 18,552.50 923,552.50 942,105.00
<br />Total $7,645,000.00
<br />$4,685,357.50
<br />$12,330,357.50 -
<br />Yield Statistics
<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 I SINGLE PURPOSE 14/29/2019 1 1:19 PM
<br />3.8771629%
<br />15.807 Years
<br />�:�EHLERS
<br />
|