|
City of Ramsey, Minnesota
<br />$10,700,000 General Obligation CIP Refunding Bonds, Series 201A
<br />Proposed Current Refunding of Series 2012A
<br />Assuming GO Non-BQ "AA+" Market Rates + 15 bps
<br />Debt Service Schedule
<br />Date
<br />10/19/2021
<br />06/15/2022
<br />12/15/2022
<br />06/15/2023
<br />12/15/2023
<br />06/15/2024
<br />12/15/2024
<br />06/15/2025
<br />12/15/2025
<br />06/15/2026
<br />12/15/2026
<br />06/15/2027
<br />12/15/2027
<br />06/15/2028
<br />12/15/2028
<br />06/15/2029
<br />12/15/2029
<br />06/15/2030
<br />12/15/2030
<br />06/15/2031
<br />12/15/2031
<br />Principal
<br />980,000.00
<br />1,020,000.00
<br />1,040,000.00
<br />1,065,000.00
<br />1,070,000.00
<br />1,080,000.00
<br />1,090,000.00
<br />1,100,000.00
<br />1,120,000.00
<br />1,135,000.00
<br />Coupon
<br />0.400%
<br />0.500%
<br />0.600%
<br />0.700%
<br />0.800%
<br />0.900%
<br />1.050%
<br />1.250%
<br />1.350%
<br />1.450%
<br />Interest
<br />Total P+I Fiscal Total
<br />64,092.03 64,092.03
<br />48,883.75 1,028,883.75 1,092,975.78
<br />46,923.75 46,923.75
<br />46,923.75 1,066,923.75 1,113,847.50
<br />44,373.75 44,373.75
<br />44,373.75 1,084,373.75 1,128,747.50
<br />41,253.75 41,253.75
<br />41,253.75 1,106,253.75 1,147,507.50
<br />37,526.25 37,526.25
<br />37,526.25 1,107,526.25 1,145,052.50
<br />33,246.25 33,246.25
<br />33,246.25 1,113,246.25 1,146,492.50
<br />28,386.25 28,386.25
<br />28,386.25 1,118,386.25 1,146,772.50
<br />22,663.75 22,663.75 -
<br />22,663.75 1,122,663.75 1,145,327.50
<br />15,788.75 15,788.75
<br />15,788,75 1,135,788,75 1,151,577.50
<br />8,228.75 8,228.75
<br />8,228.75 1,143,228.75 1,151,457.50
<br />Total $10,700,000.00
<br />$669,758.28
<br />$11,369,758.28
<br />Yield Statistics
<br />Bond Year Dollars $61,754.44
<br />Average Life 5.771 Years
<br />Average Coupon 1.0845507%
<br />Net Interest Cost (NIC)
<br />True Interest Cost (TIC)
<br />Bond Yield for Arbitrage Purposes
<br />All Inclusive Cost (AIC)
<br />IRS Form 8038
<br />1.2578176%
<br />1.2615204%
<br />1.0804394%
<br />1.4037002%
<br />Net Interest Cost
<br />Weighted Average Maturity
<br />1.0845507%
<br />5.771 Years
<br />Series 2021A GO CIP Ref B SINGLE PURPOSE 18/ 90021 112:28 PM
<br />EHLERS
<br />Pi.1E3! IC FINANCE' ADVISORS
<br />
|