|
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 Existing D/S Net New DIS 105% of Total
<br />12/15/2021 - - 998,506.25 998,506.25 1,048,431.56
<br />12/15/2022 280,000.00 2.700% 267,957.50 547,957.50 1,199,212.50 1,747,170.00 1,834,528.50
<br />12/15/2023 285,000.00 2.750% 260,397.50 545,397.50 1,217,962.50 1,763,360.00 1,851,528.00
<br />12/15/2024 295,000.00 2.800% 252,560.00 547,560.00 , 1,235,362.50 1,782,922.50 1,872,068.63
<br />12/15/2025 305,000.00 2.900% 244,300.00 549,300.00 1,251,412.50 1,800,712.50 1,890,748.13
<br />12/15/2026 310,000.00 2.950% 235,455.00 545,455.00 1,251,112.50 1,796,567.50 1,886,395.88
<br />12/15/2027 320,000.00 3.050% 226,310.00 546,310.00 1,249,912.50 1,796,222.50 1,886,033.63
<br />12/15/2028 330,000.00 3.100% 216,550.00 546,550.00 1,252,812.50 1,799,362.50 1,889,330.63
<br />12/15/2029 340,000.00 3.200% 206,320.00 546,320.00 1,249,662.50 1,795,982.50 1,885,781.63
<br />12/15/2030 355,000.00 3.300% 195,440.00 550,440.00 1,254,193.76 1,804,633.76 1,894,865.45
<br />12/15/2031 365,000.00 3.400% 183,725.00 548,725.00 1,256,006.26 1,804,731.26 1,894,967.82
<br />12/15/2032 375,000.00 3.500% 171,315.00 546,315.00 546,315.00 573,630.75
<br />12/15/2033 390,000.00 3.550% 158,190.00 548,190.00 548,190.00 575,599.50
<br />12/15/2034 405,000.00 3.650% 144,345.00 549,345.00 549,345.00 576,812.25
<br />12/15/2035 420,000.00 3.700% 129,562.50 549,562.50 549,562.50 577,040.63
<br />12/15/2036 435,000.00 3.800% 114,022.50 549,022.50 - 549,022.50 576,473.63
<br />12/15/2037 450,000.00 3.900% 97,492.50 547,492.50 547,492.50 574,867.13
<br />12/15/2038 470,000.00 3.950% 79,942.50 549,942.50 549,942.50 577,439.63
<br />12/15/2039 485,000.00 4.000% 61,377.50 546,377.50 546,377.50 573,696.38
<br />12/15/2040 505,000.00 4.050% 41,977.50 546,977.50 546,977.50 574,326.38
<br />12/15/2041 525,000.00 4.100% 21,525.00 546,525.00 - 546,525.00 573,851.25
<br />•
<br />Total $7,645,000.00 $3,308,765.00 $10,953,765.00 $13,416,156.27 S24,369,921.27 $25,588,417.33
<br />Significant Dates
<br />Dated 12/15/2021
<br />First Coupon Date 6/15/2022
<br />Yield Statistics
<br />Bond Year Dollars $88,790.00
<br />Average Life 11.614 Years
<br />Average Coupon 3.7265064%
<br />Net lnterest Cost (NIC) 3.8126084%
<br />True Interest Cost (TIC) 3.8098120%
<br />Bond Yield for Arbitrage Purposes 3.6983678%
<br />All Inclusive Cost (MC) 3.9058509%
<br />2021 GO CIP Bonds -57.5M I SINGLE PURPOSE 1 4/29/2019 19:59 AM
<br />g§. EHLERS,
<br />LEADERS 1,1 PUOLIC EDIANCD
<br />
|