|
City of Ramsey, Minnesota
<br />$9,045,000 General Obligation CIP Bonds, Series 2020
<br />Assumes Current Market BQ AA+ Rates plus 25bps
<br />Level 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 153,602.69 153,602.69
<br />12/15/2021 88,052.50 88,052.50 241,655.19
<br />06/15/2022 88,052.50 88,052.50 -
<br />12/15/2022 385,000.00 1.300% 88,052.50 473,052.50 561,105.00
<br />06/15/2023 - 85,550.00 85,550.00 -
<br />12/15/2023 390,000.00 1.350% 85,550.00 475,550.00 561,100.00
<br />06/15/2024 - 82,917.50 82,917.50 -
<br />12/15/2024 395,000.00 1.400% 82,917.50 477,917.50 560,835.00
<br />06/15/2025 - 80,152.50 80,152.50 -
<br />12/15/2025 400,000.00 1.450% 80,152.50 480,152.50 560,305.00
<br />06/15/2026 - 77,252.50 77,252.50 -
<br />12/15/2026 405,000.00 1.500% 77,252.50 482,252.50 559,505.00
<br />06/15/2027 - 74,215.00 74,215.00 -
<br />12/15/2027 410,000.00 1.550% 74,215.00 484,215.00 558,430.00
<br />06/15/2028 - 71,037.50 71,037.50 -
<br />12/15/2028 420,000.00 1.600% 71,037.50 491,037.50 562,075.00
<br />06/15/2029 - 67,677.50 67,677.50 -
<br />12/15/2029 425,000.00 1.700% 67,677.50 492,677.50 560,355.00
<br />06/15/2030 - 64,065.00 64,065.00 -
<br />12/15/2030 435,000.00 1.800% 64,065.00 499,065.00 563,130.00
<br />06/15/2031 - 60,150.00 60,150.00 -
<br />12/15/2031 440,000.00 1.850% 60,150.00 500,150.00 560,300.00
<br />06/15/2032 - 56,080.00 56,080.00 -
<br />12/15/2032 450,000.00 1.950% 56,080.00 506,080.00 562,160.00
<br />06/15/2033 - 51,692.50 51,692.50 -
<br />12/15/2033 455,000.00 2.050% 51,692.50 506,692.50 558,385.00
<br />06/15/2034 - 47,028.75 47,028.75 -
<br />12/15/2034 465,000.00 2.150% 47,028.75 512,028.75 559,057.50
<br />06/15/2035 - 42,030.00 42,030.00 -
<br />12/15/2035 475,000.00 2.200% 42,030.00 517,030.00 559,060.00
<br />06/15/2036 - 36,805.00 36,805.00 -
<br />12/15/2036 485,000.00 2.250% 36,805.00 521,805.00 558,610.00
<br />06/15/2037 - 31,348.75 31,348.75 -
<br />12/15/2037 500,000.00 2.300% 31,348.75 531,348.75 562,697.50
<br />06/15/2038 - 25,598.75 25,598.75 -
<br />12/15/2038 510,000.00 2.350% 25,598.75 535,598.75 561,197.50
<br />06/15/2039 - 19,606.25 19,606.25 -
<br />12/15/2039 520,000.00 2.400% 19,606.25 539,606.25 559,212.50
<br />06/15/2040 - 13,366.25 13,366.25 -
<br />12/15/2040 535,000.00 2.450% 13,366.25 548,366.25 561,732.50
<br />06/15/2041 - 6,812.50 6,812.50 -
<br />12/15/2041 545,000.00 2.500% 6,812.50 551,812.50 558,625.00
<br />Total $9,045,000.00 $2,404,532.69 $11,449,532.69
<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 />Net Interest Cost
<br />Weighted Average Maturity
<br />$112,976.75
<br />12.491 Years
<br />2.1283429%
<br />2.2084037%
<br />2.2048705%
<br />2.1111592%
<br />2.2814353%
<br />2.1283429%
<br />12.491 Years
<br />2020 GO CIP Bonds - $9.42 I SINGLE PURPOSE 1 4/23/2020 12:56 PM
<br />gsEHLERS
<br />
|