|
City of Ramsey, Minnesota
<br />$7,160,000 General Obligation TIF Bonds, Series 2023A
<br />Assumes Current Market BQ AA+ Rates + 50bps
<br />Debt Service Schedule
<br />Date
<br />Principal
<br />Coupon
<br />Interest
<br />Total P+I
<br />Fiscal Total
<br />07/01/2023
<br />-
<br />-
<br />-
<br />-
<br />-
<br />06/15/2024
<br />-
<br />-
<br />246M2.17
<br />246,612.17
<br />-
<br />12/15/2024
<br />2651000.00
<br />3.450%
<br />1291041.25
<br />394M41.25
<br />640,653.42
<br />06/15/2025
<br />-
<br />-
<br />124,470.00
<br />124,470.00
<br />-
<br />12/15/2025
<br />3901000.00
<br />3.350%
<br />124,470.00
<br />514,470.00
<br />638,940.00
<br />06/15/2026
<br />-
<br />-
<br />117,937.50
<br />117,937.50
<br />-
<br />12/15/2026
<br />4051000.00
<br />3.350%
<br />117,937.50
<br />522,937.50
<br />640,875.00
<br />06/15/2027
<br />-
<br />-
<br />111 J 53.75
<br />111 J 53.75
<br />-
<br />12/15/2027
<br />4201000.00
<br />3.350%
<br />111 J 53.75
<br />531J53.75
<br />642,307.50
<br />06/15/2028
<br />-
<br />-
<br />104,118.75
<br />104,118.75
<br />-
<br />12/15/2028
<br />4351000.00
<br />3.350%
<br />104,118.75
<br />539,118.75
<br />6431237.50
<br />06/15/2029
<br />-
<br />-
<br />96,832.50
<br />96,832.50
<br />-
<br />12/15/2029
<br />4451000.00
<br />3.350%
<br />96,832.50
<br />541,832.50
<br />6381665.00
<br />06/15/2030
<br />-
<br />-
<br />K378.75
<br />K378.75
<br />-
<br />12/15/2030
<br />460M00.00
<br />3.400%
<br />K378.75
<br />549X8.75
<br />6385757.50
<br />06/15/2031
<br />-
<br />-
<br />8 L558.75
<br />81,558.75
<br />-
<br />12/15/2031
<br />4801000.00
<br />3.400%
<br />K558.75
<br />561,558.75
<br />643,117.50
<br />06/15/2032
<br />-
<br />-
<br />73,398.75
<br />73,398.75
<br />-
<br />12/15/2032
<br />49500.00
<br />3.450%
<br />73,398.75
<br />568,398.75
<br />641,797.50
<br />06/15/2033
<br />-
<br />-
<br />64,860.00
<br />64,860.00
<br />-
<br />12/15/2033
<br />51000.00
<br />3.500%
<br />64,860.00
<br />574,860.00
<br />639,720.00
<br />06/15/2034
<br />-
<br />-
<br />55,935.00
<br />55,935.00
<br />-
<br />12/15/2034
<br />53000.00
<br />3.650%
<br />55,935.00
<br />585,935.00
<br />641,870.00
<br />06/15/2035
<br />-
<br />-
<br />46>2.50
<br />46>2.50
<br />-
<br />12/15/2035
<br />5501000.00
<br />3.800%
<br />46>2.50
<br />596>2.50
<br />6425525.00
<br />06/15/2036
<br />-
<br />-
<br />35,812.50
<br />355812.50
<br />-
<br />12/15/2036
<br />5701000.00
<br />3.950%
<br />35,812.50
<br />6055812.50
<br />6415625.00
<br />06/15/2037
<br />-
<br />-
<br />24,555.00
<br />245555.00
<br />-
<br />12/15/2037
<br />5901000.00
<br />4.050%
<br />24,555.00
<br />614,555.00
<br />6395110.00
<br />06/15/2038
<br />-
<br />-
<br />1207.50
<br />1207.50
<br />-
<br />12/15/2038
<br />6151000.00
<br />4.100%
<br />12,607.50
<br />6271)607.50
<br />640,215.00
<br />Total
<br />$7J601000.00
<br />-
<br />$2,453,415.92
<br />$9,613,415.92
<br />-
<br />Yield Statistics
<br />Bond Year Dollars
<br />$65,986.78
<br />Average Life
<br />9.216 Years
<br />Average Coupon
<br />3.7180417%
<br />Net Interest Cost (NIC)
<br />3.8482496%
<br />True Interest Cost (TIC)
<br />3.8580211%
<br />Bond Yield for Arbitrage
<br />Purposes
<br />3.6978745%
<br />All Inclusive Cost (AIC)
<br />3.9962156%
<br />IRS Form 8038
<br />Net Interest Cost
<br />3.7180417%
<br />Weighted Average Maturity
<br />9.216 Years
<br />Series 2023A GO TIF Bonds I
<br />SINGLE PURPOSE 1 5/ 5/2023 1 8:41 AM
<br />9 s
<br />N EHLE S
<br />iM PUBLIC FINANCE ADVISORS
<br />
|