|
City of Ramsey, Minnesota
<br />$9,935,000 General Obligation CIP Bonds, Series 2020A
<br />Assumes Current Market BQ AA+ Rates plus 25bps
<br />Wrap Around Debt
<br />Debt Service Schedule
<br />Date Principal Coupon Interest Total P+I Fiscal Total
<br />12/30/2020 - - - - -
<br />06/15/2021 - - 81,489.38 81,489.38 -
<br />12/15/2021 - - 88,897.50 88,897.50 170,386.88
<br />06/15/2022 - - 88,897.50 88,897.50 -
<br />12/15/2022 - - 88,897.50 88,897.50 177,795.00
<br />06/15/2023 - - 88,897.50 88,897.50 -
<br />12/15/2023 - - 88,897.50 88,897.50 177,795.00
<br />06/15/2024 - - 88,897.50 88,897.50 -
<br />12/15/2024 - - 88,897.50 88,897.50 177,795.00
<br />06/15/2025 - - 88,897.50 88,897.50 -
<br />12/15/2025 - - 88,897.50 88,897.50 177,795.00
<br />06/15/2026 - - 88,897.50 88,897.50 -
<br />12/15/2026 - - 88,897.50 88,897.50 177,795.00
<br />06/15/2027 - - 88,897.50 88,897.50 -
<br />12/15/2027 - - 88,897.50 88,897.50 177,795.00
<br />06/15/2028 - - 88,897.50 88,897.50
<br />12/15/2028 - - 88,897.50 88,897.50
<br />06/15/2029 - - 88,897.50 88,897.50
<br />12/15/2029 - - 88,897.50 88,897.50
<br />06/15/2030 - - 88,897.50 88,897.50
<br />12/15/2030 - - 88,897.50 88,897.50
<br />06/15/2031 - - 88,897.50 88,897.50
<br />12/15/2031 - - 88,897.50 88,897.50
<br />06/15/2032 - - 88,897.50 88,897.50
<br />12/15/2032 920,000.00 1.450% 88,897.50 1,008,897.50
<br />06/15/2033 - - 82,227.50 82,227.50
<br />12/15/2033 935,000.00 1.550% 82,227.50 1,017,227.50
<br />06/15/2034 - - 74,981.25 74,981.25
<br />12/15/2034 950,000.00 1.600% 74,981.25 1,024,981.25
<br />06/15/2035 - - 67,381.25 67,381.25
<br />12/15/2035 965,000.00 1.700% 67,381.25 1,032,381.25
<br />06/15/2036 - - 59,178.75 59,178.75
<br />12/15/2036 980,000.00 1.750% 59,178.75 1,039,178.75
<br />06/15/2037 - - 50,603.75 50,603.75
<br />12/15/2037 1,000,000.00 1.850% 50,603.75 1,050,603.75
<br />177,795.00
<br />177,795.00
<br />177,795.00
<br />177,795.00
<br />1,097,795.00
<br />1,099,455.00
<br />1,099,962.50
<br />1,099,762.50
<br />1,098,357.50
<br />1,101,207.50
<br />06/15/2038 - - 41,353.75 41,353.75
<br />12/15/2038 1,015,000.00 1.900% 41,353.75 1,056,353.75
<br />06/15/2039 - - 31,711.25 31,711.25
<br />12/15/2039 1,035,000.00 1.950% 31,711.25 1,066,711.25
<br />06/15/2040 - - 21,620.00 21,620.00
<br />12/15/2040 1,055,000.00 2.000% 21,620.00 1,076,620.00
<br />06/15/2041 - - 11,070.00 11,070.00
<br />12/15/2041 1,080,000.00 2.050% 11,070.00 1,091,070.00
<br />1,097,707.50
<br />1,098,422.50
<br />1,098,240.00
<br />1,102,140.00
<br />Total $9,935,000.00 $3,006,386.88 $12,941,386.88
<br />Yield Statistics
<br />Bond Year Dollars
<br />Average Life
<br />Average Coupon
<br />$164,951.04
<br />16.603 Years
<br />1.8225934%
<br />Net Interest Cost (NIC) 1.8828234%
<br />True Interest Cost (TIC) 1.8887092%
<br />Bond Yield for Arbitrage Purposes 1.8181423%
<br />All Inclusive Cost (AIC) 1.9432506%
<br />IRS Form 8038
<br />
|