|
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 Principal Coupon Interest Total P+I Fiscal Total
<br />07/01/2023 - - - - -
<br />06/15/2024 - - 246,612.17 246,612.17 -
<br />12/15/2024 265,000.00 3.450% 129,041.25 394,041.25 640,653.42
<br />06/15/2025 - - 124,470.00 124,470.00 -
<br />12/15/2025 390,000.00 3.350% 124,470.00 514,470.00 638,940.00
<br />06/15/2026 - - 117,937.50 117,937.50 -
<br />12/15/2026 405,000.00 3.350% 117,937.50 522,937.50 640,875.00
<br />06/15/2027 - - 111,153.75 111,153.75 -
<br />12/15/2027 420,000.00 3.350% 111,153.75 531,153.75 642,307.50
<br />06/15/2028 - - 104,118.75 104,118.75 -
<br />12/15/2028 435,000.00 3.350% 104,118.75 539,118.75 643,237.50
<br />06/15/2029 - - 96,832.50 96,832.50 -
<br />12/15/2029 445,000.00 3.350% 96,832.50 541,832.50 638,665.00
<br />06/15/2030 - - 89,378.75 89,378.75 -
<br />12/15/2030 460,000.00 3.400% 89,378.75 549,378.75 638,757.50
<br />06/15/2031 - - 81,558.75 81,558.75 -
<br />12/15/2031 480,000.00 3.400% 81,558.75 561,558.75 643,117.50
<br />06/15/2032 - - 73,398.75 73,398.75 -
<br />12/15/2032 495,000.00 3.450% 73,398.75 568,398.75 641,797.50
<br />06/15/2033 - - 64,860.00 64,860.00 -
<br />12/15/2033 510,000.00 3.500% 64,860.00 574,860.00 639,720.00
<br />06/15/2034 - - 55,935.00 55,935.00 -
<br />12/15/2034 530,000.00 3.650% 55,935.00 585,935.00 641,870.00
<br />06/15/2035 - - 46,262.50 46,262.50 -
<br />12/15/2035 550,000.00 3.800% 46,262.50 596,262.50 642,525.00
<br />06/15/2036 - - 35,812.50 35,812.50 -
<br />12/15/2036 570,000.00 3.950% 35,812.50 605,812.50 641,625.00
<br />06/15/2037 - - 24,555.00 24,555.00 -
<br />12/15/2037 590,000.00 4.050% 24,555.00 614,555.00 639,110.00
<br />06/15/2038 - - 12,607.50 12,607.50 -
<br />12/15/2038 615,000.00 4.100% 12,607.50 627,607.50 640,215.00
<br />Total $7,160,000.00 $2,453,415.92 $9,613,415.92
<br />Yield Statistics
<br />Bond Year Dollars
<br />Average Life
<br />Average Coupon
<br />$65,986.78
<br />9.216 Years
<br />3.7180417%
<br />Net Interest Cost (NIC) 3.8482496%
<br />True Interest Cost (TIC)
<br />Bond Yield for Arbitrage Purposes
<br />3.8580211%
<br />3.6978745%
<br />All Inclusive Cost (AIC) 3.9962156%
<br />IRS Form 8038
<br />Net Interest Cost 3.7180417%
<br />Weighted Average Maturity 9.216 Years
<br />Series 2023A GO TIF Bonds I SINGLE PURPOSE 15/ 5/2023 18:41 AM
<br />gu. EHLERS
<br />FUEILIC FINANCE ADVISORS
<br />
|