|
City of Ramsey, Minnesota
<br />$7,155,000 General Obligation Bonds, Series 2023A
<br />TIF
<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 />162,366.46
<br />162,366.46
<br />-
<br />12/15/2024 3401000.00
<br />3.950%
<br />1391171.25
<br />479J71.25
<br />641,537.71
<br />06/15/2025 -
<br />-
<br />132,456.25
<br />132,456.25
<br />-
<br />12/15/2025 3801000.00
<br />3.800%
<br />132,456.25
<br />512,456.25
<br />644,912.50
<br />06/15/2026 -
<br />-
<br />125,236.25
<br />125,236.25
<br />-
<br />12/15/2026 3951000.00
<br />3.750%
<br />125,236.25
<br />520,236.25
<br />645,472.50
<br />06/15/2027 -
<br />-
<br />117,830.00
<br />117,830.00
<br />-
<br />12/15/2027 4101000.00
<br />3.650%
<br />117,830.00
<br />527,830.00
<br />64500.00
<br />06/15/2028 -
<br />-
<br />11M47.50
<br />1 M347.50
<br />-
<br />12/15/2028 4251000.00
<br />3.650%
<br />110,347.50
<br />535,347.50
<br />6451695.00
<br />06/15/2029 -
<br />-
<br />102,591.25
<br />102,591.25
<br />-
<br />12/15/2029 4401000.00
<br />3.650%
<br />102,591.25
<br />542,591.25
<br />6451182.50
<br />06/15/2030 -
<br />-
<br />94,561.25
<br />94,561.25
<br />-
<br />12/15/2030 455M00.00
<br />3.650%
<br />94,561.25
<br />549,561.25
<br />6445122.50
<br />06/15/2031 -
<br />-
<br />86,257.50
<br />86,257.50
<br />-
<br />12/15/2031 4701000.00
<br />3.650%
<br />86,257.50
<br />556,257.50
<br />642,515.00
<br />06/15/2032 -
<br />-
<br />7700.00
<br />7700.00
<br />-
<br />12/15/2032 49000.00
<br />3.700%
<br />7700.00
<br />56700.00
<br />645,360.00
<br />06/15/2033 -
<br />-
<br />68,615.00
<br />68,615.00
<br />-
<br />12/15/2033 50500.00
<br />3.750%
<br />68,615.00
<br />573,615.00
<br />642,230.00
<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 />593,777.50
<br />6425555.00
<br />06/15/2036 -
<br />-
<br />37,741.25
<br />375741.25
<br />-
<br />12/15/2036 5701000.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 $7J551000.00
<br />-
<br />$2,502,597.71
<br />$9,657,597.71
<br />-
<br />Yield Statistics
<br />Bond Year Dollars
<br />$62,901.25
<br />Average Life
<br />8.791 Years
<br />Average Coupon
<br />3.9786136%
<br />Net Interest Cost (NIC)
<br />4.1151133%
<br />True Interest Cost (TIC)
<br />4.1327842%
<br />Bond Yield for Arbitrage Purposes
<br />3.9281110%
<br />All Inclusive Cost (AIC)
<br />4.2690768%
<br />IRS Form 8038
<br />Net Interest Cost
<br />3.9786136%
<br />Weighted Average Maturity
<br />8.791 Years
<br />Series 2023A GO Bonds - P I TIF 1 9/11/2023 1 1:47 PM
<br />%iEHLERS
<br />E'S
<br />5ft
<br />PUBLIC FINANCE ADVISORS
<br />
|