|
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 Existing D/S Net New D/S 105% of Total
<br />12/15/2021 - - 998,506.25 998,506.25 1,048,431.56
<br />12/15/2022 293,662.50 293,662.50 1,199,212.50 1,492,875.00 1,567,518.75
<br />12/15/2023 293,662.50 293,662.50 1,217,962.50 1,511,625.00 1,587,206.25
<br />12/15/2024 293,662.50 293,662.50 1,235,362.50 1,529,025.00 1,605,476.25
<br />12/15/2025 - 293,662.50 293,662.50 1,251,412.50 1,545,075.00 1,622,328.75
<br />12/15/2026 - 293,662.50 293,662.50 1,251,112.50 1,544,775.00 1,622,013.75
<br />12/15/2027 293,662.50 293,662.50 1,249,912.50 1,543,575.00 1,620,753.75
<br />12/15/2028 293,662.50 293,662.50 1,252,812.50 1,546,475.00 1,623,798.75
<br />12/15/2029 - 293,662.50 293,662.50 1,249,662.50 1,543,325.00 1,620,491.25
<br />12/15/2030 - 293,662.50 293,662.50 1,254,193.76 1,547,856.26 1,625,249.07
<br />12/15/2031 - - 293,662.50 293,662.50 1,256,006.26 1,549,668.76 1,627,152.20
<br />12/15/2032 645,000.00 3.500% 293,662.50 938,662.50 938,662.50 985,595.63
<br />12/15/2033 670,000.00 3.550% 271,087.50 941,087.50 - 941,087.50 988,141.88
<br />12/15/2034 690,000.00 3.650% 247,302.50 937,302.50 - 937,302.50 984,167.63
<br />12/15/2035 720,000.00 3.700% 222,117.50 942,117.50 - 942,117.50 989,223.38
<br />12/15/2036 745,000.00 3.800% 195,477.50 940,477.50 . - 940,477.50 987,501.38
<br />12/15/2037 770,000.00 3.900% 167,167.50 937,167.50 937,167.50 984,025.88
<br />12/15/2038 800,000.00 3.950% 137,137.50 937,137.50 937,137.50 983,994.38
<br />12/15/2039 835,000.00 4.000% 105,537.50 940,537.50 940,537.50 987,564.38
<br />12/15/2040 865,000.00 4.050% 72,137.50 937,137.50 - 937,137.50 983,994.38
<br />12/15/2041 905,000.00 4.100% 37,105.00 942,105.00 942,105.00 989,210.25
<br />Total $7,645,000.00 $4,685,357.50 $12,330,357.50 $13,416,156.27 $25,746,513.77 $27,033,839.46
<br />Significant Dates
<br />Dated 12/15/2021
<br />First Coupon Date 6/15/2022
<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 />2021 GO CIP Bonds - $7.5M 1 SINGLE PURPOSE 1 4/29/2019 11:19 PM
<br />$120,845.00
<br />15.807 Years
<br />3.8771629%
<br />3.9404258%
<br />3.9541032%
<br />3.8679635%
<br />4.0282090%
<br />EHLERS
<br />LEADER'S IN PUOLIC FINANGd
<br />
|