|
City of Ramsey, Minnesota
<br />$9,045,000 General Obligation CIP Bonds, Series 2020
<br />Assumes Current Market BQ AA+ Rates plus 25bps
<br />Wrap Around Debt - $9.422M Cash
<br />Debt Service Schedule
<br />Date Principal Coupon Interest Total P+I Fiscal Total
<br />08/01/2020 - -
<br />06/15/2021 179,123.92 179,123.92 -
<br />12/15/2021 102,682.50 102,682.50 281,806.42
<br />06/15/2022 102,682.50 102,682.50 -
<br />12/15/2022 102,682.50 102,682.50 205,365.00
<br />06/15/2023 102,682.50 102,682.50
<br />12/15/2023 102,682.50 102,682.50 205,365.00
<br />06/15/2024 102,682.50 102,682.50
<br />12/15/2024 102,682.50 102,682.50 205,365.00
<br />06/15/2025 102,682.50 102,682.50
<br />12/15/2025 102,682.50 102,682.50 205,365.00
<br />06/15/2026 102,682.50 102,682.50
<br />12/15/2026 102,682.50 102,682.50 205,365.00
<br />06/15/2027 102,682.50 102,682.50
<br />12/15/2027 102,682.50 102,682.50 205,365.00
<br />06/15/2028 102,682.50 102,682.50
<br />12/15/2028 102,682.50 102,682.50 205,365.00
<br />06/15/2029 102,682.50 102,682.50
<br />12/15/2029 102,682.50 102,682.50 205,365.00
<br />06/15/2030 102,682.50 102,682.50
<br />12/15/2030 102,682.50 102,682.50 205,365.00
<br />06/15/2031 102,682.50 102,682.50
<br />12/15/2031 102,682.50 102,682.50 205,365.00
<br />06/15/2032 - 102,682.50 102,682.50
<br />12/15/2032 820,000.00 1.950% 102,682.50 922,682.50 1,025,365.00
<br />06/15/2033 94,687.50 94,687.50
<br />12/15/2033 835,000.00 2.050% 94,687.50 929,687.50 1,024,375.00
<br />06/15/2034 86,128.75 86,128.75
<br />12/15/2034 855,000.00 2.150% 86,128.75 941,128.75 1,027,257.50
<br />06/15/2035 76,937.50 76,937.50
<br />12/15/2035 870,000.00 2.200% 76,937.50 946,937.50 1,023,875.00
<br />06/15/2036 67,367.50 67,367.50
<br />12/15/2036 890,000.00 2.250% 67,367.50 957,367.50 1,024,735.00
<br />06/15/2037 57,355.00 57,355.00
<br />12/15/2037 910,000.00 2.300% 57,355.00 967,355.00 1,024,710.00
<br />06/15/2038 46,890.00 46,890.00
<br />12/15/2038 935,000.00 2.350% 46,890.00 981,890.00 1,028,780.00
<br />06/15/2039 35,903.75 35,903.75
<br />12/15/2039 955,000.00 2.400% 35,903.75 990,903.75 1,026,807.50
<br />06/15/2040 24,443.75 24,443.75
<br />12/15/2040 975,000.00 2.450% 24,443.75 999,443.75 1,023,887.50
<br />06/15/2041 12,500.00 12,500.00
<br />12/15/2041 1,000,000.00 2.500% 12,500.00 1,012,500.00 1,025,000.00
<br />Total $9,045,000.00 $3,545,248.92 $12,590,248.92
<br />Yield Statistics
<br />Bond Year Dollars
<br />Average Life
<br />Average Coupon
<br />$154,266.75
<br />17.055 Years
<br />2.2981290%
<br />Net Interest Cost (NIC) 2.3567612%
<br />True Interest Cost (TIC) 2.3645367%
<br />Bond Yield for Arbitrage Purposes 2.2927754%
<br />All Inclusive Cost (AIC) 2.4230824%
<br />IRS Form 8038
<br />Net Interest Cost 2.2981290%
<br />Weighted Average Maturity 17.055 Years
<br />2020 GO CIP Bonds - $9.42 I SINGLE PURPOSE 1 4/23/2020 12:56 PM
<br />g EHLERS
<br />
|