|
City of Ramsey,. Minnesota
<br />$9,065,000 General Obligation CIP Bonds, Series 2020A
<br />Assumes Current Market BQ AA+ Rates plus 25bps
<br />Wrap Around Debt
<br />Debt Service Schedule
<br />Date Principal Coupon Interest Total P+I Fiscal Total
<br />12/30/2020
<br />06/15/2021 74,353.13 74,353.13 -
<br />12/15/2021 - 81,112.50 81,112.50 155,465.63
<br />06/15/2022 81,112. 50 81,112. 50
<br />12/15/2022 81,112.50 81,112.50 162,225.00
<br />06/15/2023 81,112.50 81,112.50
<br />12/15/2023 81,112.50 81,112.50 162,225.00
<br />06/15/2024 - - 81,112.50 81,1 12. 50
<br />12/15/2024 81,112.50 81,112.50 162,225.00
<br />06/15/2025 81,1 12,50 81,1 12.50
<br />12/15/2025 81,1 12.50 81,1 12.50 162,225.00
<br />06/15/2026 81,112.50 81,1 12, 50
<br />12/15/2026 81,112.50 81,112.50 162,225.00
<br />06/15/2027 81,1 12.50 81,1 12.50
<br />12/15/2027 81,112.50 81,112.50 162,225.00
<br />06/15/2028 81,112.50 81,112.50
<br />12/15/2028 81,112.50 81,112.50 162,225.00
<br />06/15/2029 81,112.50 81,112.50
<br />12/15/2029 81,112.50 81,112.50 162,225.00
<br />06/15/2030 81,112.50 81,112.50
<br />12/15/2O30 81,112.50 81,112.50 162,225.00
<br />06/15/2O31 81,112.50 81,1 12.50
<br />12/15/2031 81,112.50 81,112.50 162,225.00
<br />06/15/2032 81,112.50 81,112.50
<br />12/15/2032 840,000.00 1.450% 81,112.50 921,112.50 1,002,225.00
<br />06/15/2033 75,022,50 75,022,50
<br />12/15/2033 855,000.00 1.550% 75,022.50 930,022.50 1,005,045.00
<br />06/15/2034 - - 68,396.25 68,396.25
<br />12/15/2034 865,000.00 1,600% 68,396.25 933,396.25 1,001,792,50
<br />06/15/2035 61,476.25 61,476.25
<br />12/15/2O35 880,000.00 1.700% 61,476.25 941,476.25 1,002,952.50
<br />06/15/2036 53,996.25 53,996.25
<br />12/15/2036 895,000.00 1.750% 53,996,25 948,996.25 1,002,992.50
<br />06/15/2037 46,165.00 46,165.00
<br />12/15/2037 910,000.00 1.850% 46,165.00 956,165.00 1,002,330.00
<br />06/15/2038 37,747.50 37,747.50
<br />12/15/2038 925,000.00 1.900% 37,747.50 962,747.50 1,000,495.00
<br />06/15/2039 28,960.00 28,960.00
<br />12/15/2039 945,000.00 1.950% 28,960.00 973,960.00 1,002,920.00
<br />06/15/2040 19,746.25 19,746.25
<br />12/15/2040 965,000.00 2.000% 19,746.25 984,746,25 1,004,492.50
<br />06/15/2041 10,096.25 10,096.25
<br />12/15/2041 985,000.00 2.050% 10,096.25 995,096.25 1,005,192.50
<br />Total $9,065,000.00. $2,743,153, I3 $11,808,153.13
<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 />$150,507.29
<br />16.603 Years
<br />1.8226048%
<br />1.8828344%
<br />1.8887180%
<br />1.8181513%
<br />1.9485196%
<br />Net Interest Cost
<br />Weighted Average Maturity
<br />1.8226048%
<br />.................
<br />16.603 Years
<br />2020A GO CIP Bonds - PreS I SINGLE PURPOSE J 111212020 111:04 AM
<br />EHLE S
<br />
|