|
City of Ramsey, Minnesota
<br />$7,645,000 General Obligation CIP Bonds, Series 2021
<br />Assumes Current Market BQ AA+ Rates plus 100bps
<br />Level 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 - - 133,978.75 133,978.75 -
<br />12/15/2022 280,000.00 2.700% 133,978.75 413,978.75 547,957.50
<br />06/15/2023 - - 130,198.75 130,198.75 -
<br />12/15/2023 285,000.00 2.750% 130,198.75 415,198.75 545,397.50
<br />06/15/2024 - - 126,280.00 126,280.00
<br />12/15/2024 295,000.00 2.800% 126,280.00 421,280.00 547,560.00
<br />06/15/2025 - 122,150.00 122,150.00
<br />12/15/2025 305,000.00 2.900% 122,150.00 427,150.00 549,300.00
<br />06/15/2026 117,727.50 117,727.50
<br />12/15/2026 310,000.00 2.950% 117,727.50 427,727.50 545,455.00
<br />06/15/2027 - - 113,155.00 113,155.00
<br />12/15/2027 320,000.00 3.050% 113,155.00 433,155.00 546,310.00
<br />06/15/2028 - - 108,275.00 108,275.00
<br />12/15/2028 330,000.00 3.100% 108,275.00 438,275.00 546,550.00
<br />06/15/2029 - - 103,160.00 103,160.00
<br />12/15/2029 340,000.00 3.200% 103,160.00 443,160.00 546,320.00
<br />06/15/2030 - 97,720.00 97,720.00
<br />12/15/2030 355,000.00 3.300% 97,720.00 452,720.00 550,440.00
<br />06/15/2031 - - 91,862.50 91,862.50 -
<br />12/15/2031 365,000.00 3.400% 91,862.50 456,862.50 548,725.00
<br />06/15/2032 - 85,657.50 85,657.50 -
<br />12/15/2032 375,000.00 3.500% 85,657.50 460,657.50 546,315.00
<br />06/15/2033 - 79,095.00 79,095.00 -
<br />12/15/2033 390,000.00 3.550% 79,095.00 469,095.00 548,190.00
<br />06/15/2034 - 72,172.50 72,172.50 -
<br />12/15/2034 405,000.00 3.650% 72,172.50 . 477,172.50 549,345.00
<br />06/15/2035 - - 64,781.25 64,781.25 -
<br />12/15/2035 420,000.00 3.700% 64,781.25 484,781.25 549,562.50
<br />06/15/2036 - - 57,011.25 57,011.25 -
<br />12/15/2036 435,000.00 3.800% 57,011.25 492,011.25 549,022.50
<br />06/15/2037 - - 48,746.25 48,746.25 -
<br />12/15/2037 450,000.00 3.900% 48,746.25 498,746.25 547,492.50
<br />06/15/2038 - - 39,971.25 39,971.25 -
<br />12/15/2038 470,000.00 3.950% 39,971.25 509,971.25 549,942.50
<br />06/15/2039 - 30,688,75 30,688.75 -
<br />12/15/2039 485,000.00 4.000% 30,688.75 515,688.75 546,377.50
<br />06/15/2040 - - 20,988.75 20,988.75 -
<br />12/15/2040 505,000.00 4.050% 20,988.75 525,988.75 546,977.50
<br />06/15/2041 10,762.50 10,762.50 -
<br />12/15/2041 525,000.00 4.100% 10,762.50 535,762.50 546,525.00
<br />Total $7,645,000.00 $3,308,765.00 $10,953,765.00
<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 />$88,790.00
<br />11.614 Years
<br />3.7265064%
<br />3.8126084%
<br />3.8098120%
<br />3.6983678%
<br />3.9058509%
<br />Net Interest Cost
<br />Weighted Average Maturity
<br />3.7265064%
<br />11.614 Years
<br />2021 GO CIP Bonds - $7.5M I SINGLE PURPOSE 1 4/29/2019. 1 9:59 AM
<br />Igt% RS
<br />, FAOEftS W PUBLIC E1NANC£
<br />
|