|
City of Ramsey, Minnesota
<br />$8,640,000 General Obligation Bonds, Series 2023A
<br />Issue Summary
<br />Assumes Current Market BQ AA+ Rates plus 50bps
<br />Debt Service Schedule
<br />Date Principal
<br />Coupon
<br />Interest
<br />Total P+I
<br />Fiscal Total
<br />11/15/2023 -
<br />-
<br />-
<br />-
<br />-
<br />06/15/2024 -
<br />-
<br />194,538.75
<br />194,538.75
<br />-
<br />12/15/2024 46000.00
<br />3.950%
<br />166,747.50
<br />626,747.50
<br />821,286.25
<br />06/15/2025 -
<br />-
<br />15702.50
<br />15702.50
<br />-
<br />12/15/2025 5101000.00
<br />3.800%
<br />15702.50
<br />66702.50
<br />825X5.00
<br />06/15/2026 -
<br />-
<br />147,972.50
<br />147,972.50
<br />-
<br />12/15/2026 5301000.00
<br />3.750%
<br />147,972.50
<br />677,972.50
<br />825,945.00
<br />06/15/2027 -
<br />-
<br />138M35.00
<br />138M35.00
<br />-
<br />12/15/2027 5501000.00
<br />3.650%
<br />138M35.00
<br />688M35.00
<br />826M70.00
<br />06/15/2028 -
<br />-
<br />127,997.50
<br />127,997.50
<br />-
<br />12/15/2028 5701000.00
<br />3.650%
<br />127,997.50
<br />697,997.50
<br />8251995.00
<br />06/15/2029 -
<br />-
<br />117,595.00
<br />117,595.00
<br />-
<br />12/15/2029 5901000.00
<br />3.650%
<br />117,595.00
<br />707,595.00
<br />8251190.00
<br />06/15/2030 -
<br />-
<br />106,827.50
<br />106,827.50
<br />-
<br />12/15/2030 6101000.00
<br />3.650%
<br />106,827.50
<br />7165827.50
<br />8235655.00
<br />06/15/2031 -
<br />-
<br />95,695.00
<br />95,695.00
<br />-
<br />12/15/2031 6351000.00
<br />3.650%
<br />95,695.00
<br />730,695.00
<br />826,390.00
<br />06/15/2032 -
<br />-
<br />84,106.25
<br />84,106.25
<br />-
<br />12/15/2032 66000.00
<br />3.700%
<br />84,106.25
<br />744,106.25
<br />828,212.50
<br />06/15/2033 -
<br />-
<br />71,896.25
<br />71,896.25
<br />-
<br />12/15/2033 68000.00
<br />3.750%
<br />71,896.25
<br />751,896.25
<br />823,792.50
<br />06/15/2034 -
<br />-
<br />59J46.25
<br />59J46.25
<br />-
<br />12/15/2034 52500.00
<br />3.950%
<br />59J46.25
<br />584J46.25
<br />643,292.50
<br />06/15/2035 -
<br />-
<br />48,777.50
<br />48,777.50
<br />-
<br />12/15/2035 5451000.00
<br />4.050%
<br />48,777.50
<br />5935777.50
<br />6425555.00
<br />06/15/2036 -
<br />-
<br />37,741.25
<br />375741.25
<br />-
<br />12/15/2036 57000.00
<br />4.150%
<br />37,741.25
<br />6075741.25
<br />6455482.50
<br />06/15/2037 -
<br />-
<br />25,913.75
<br />255913.75
<br />-
<br />12/15/2037 5901000.00
<br />4.250%
<br />25,913.75
<br />615,913.75
<br />6415827.50
<br />06/15/2038 -
<br />-
<br />13,376.25
<br />13,376.25
<br />-
<br />12/15/2038 6151000.00
<br />4.350%
<br />13,376.25
<br />6281)376.25
<br />641,752.50
<br />Total $8,6401000.00
<br />-
<br />$2,826J71.25
<br />$M466J71.25
<br />-
<br />Yield Statistics
<br />Bond Year Dollars
<br />$7100.00
<br />Average Life
<br />8.296 Years
<br />Average Coupon
<br />3.9435983%
<br />Net Interest Cost (NIC)
<br />4.0882411%
<br />True Interest Cost (TIC)
<br />4.1061715%
<br />Bond Yield for Arbitrage Purposes
<br />3.9281110%
<br />All Inclusive Cost (AIC)
<br />4.2492167%
<br />IRS Form 8038
<br />Net Interest Cost
<br />3.9435983%
<br />Weighted Average Maturity
<br />8.296 Years
<br />Series 2023A GO Bonds - P I Issue Summary 1 9/11/2023 1 1:47 PM
<br />Mao%
<br />ukiEHLERS
<br />M PUBLIC FINANCE ADVISORS
<br />
|