|
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 />Net Debt Service Schedule
<br />Date Principal Coupon Interest Total P+I Existing D/S Net New D/S Fiscal Total
<br />12/30/2020 - - - - - -
<br />06/15/2021 - - 81,489.38 81,489.38 178,506.25 259,995.63 -
<br />12/15/2021 - - 88,897.50 88,897.50 998,506.25 1,087,403.75 1,347,399.38
<br />06/15/2022 - - 88,897.50 88,897.50 162,106.25 251,003.75 -
<br />12/15/2022 - - 88,897.50 88,897.50 1,037,106.25 1,126,003.75 1,377,007.50
<br />06/15/2023 - - 88,897.50 88,897.50 148,981.25 237,878.75
<br />12/15/2023 - - 88,897.50 88,897.50 1,068,981.25 1,157,878.75 1,395,757.50
<br />06/15/2024 - - 88,897.50 88,897.50 135,181.25 224,078.75
<br />12/15/2024 - - 88,897.50 88,897.50 1,100,181.25 1,189,078.75 1,413,157.50
<br />06/15/2025 - - 88,897.50 88,897.50 120,706.25 209,603.75
<br />12/15/2025 - - 88,897.50 88,897.50 1,130,706.25 1,219,603.75 1,429,207.50
<br />06/15/2026 - - 88,897.50 88,897.50 105,556.25 194,453.75
<br />12/15/2026 - - 88,897.50 88,897.50 1,145,556.25 1,234,453.75 1,428,907.50
<br />06/15/2027 - - 88,897.50 88,897.50 89,956.25 178,853.75
<br />12/15/2027 - - 88,897.50 88,897.50 1,159,956.25 1,248,853.75 1,427,707.50
<br />06/15/2028 - - 88,897.50 88,897.50 73,906.25 162,803.75
<br />12/15/2028 - - 88,897.50 88,897.50 1,178,906.25 1,267,803.75 1,430,607.50
<br />06/15/2029 - - 88,897.50 88,897.50 57,331.25 146,228.75
<br />12/15/2029 - - 88,897.50 88,897.50 1,192,331.25 1,281,228.75 1,427,457.50
<br />06/15/2030 - - 88,897.50 88,897.50 39,596.88 128,494.38
<br />12/15/2030 - - 88,897.50 88,897.50 1,214,596.88 1,303,494.38 1,431,988.76
<br />06/15/2031 - - 88,897.50 88,897.50 20,503.13 109,400.63
<br />12/15/2031 - - 88,897.50 88,897.50 1,235,503.13 1,324,400.63 1,433,801.26
<br />06/15/2032 - - 88,897.50 88,897.50 - 88,897.50
<br />12/15/2032 920,000.00 1.450% 88,897.50 1,008,897.50 - 1,008,897.50 1,097,795.00
<br />06/15/2033 - - 82,227.50 82,227.50 - 82,227.50
<br />12/15/2033 935,000.00 1.550% 82,227.50 1,017,227.50 - 1,017,227.50 1,099,455.00
<br />06/15/2034 - - 74,981.25 74,981.25 - 74,981.25
<br />12/15/2034 950,000.00 1.600% 74,981.25 1,024,981.25 - 1,024,981.25 1,099,962.50
<br />06/15/2035 - - 67,381.25 67,381.25 - 67,381.25
<br />12/15/2035 965,000.00 1.700% 67,381.25 1,032,381.25 - 1,032,381.25 1,099,762.50
<br />06/15/2036 - - 59,178.75 59,178.75 - 59,178.75
<br />12/15/2036 980,000.00 1.750% 59,178.75 1,039,178.75 1,039,178.75 1,098,357.50
<br />06/15/2037 - - 50,603.75 50,603.75 - 50,603.75
<br />12/15/2037 1,000,000.00 1.850% 50,603.75 1,050,603.75 - 1,050,603.75 1,101,207.50
<br />06/15/2038 - - 41,353.75 41,353.75 - 41,353.75
<br />12/15/2038 1,015,000.00 1.900% 41,353.75 1,056,353.75 - 1,056,353.75 1,097,707.50
<br />06/15/2039 - - 31,711.25 31,711.25 - 31,711.25
<br />12/15/2039 1,035,000.00 1.950% 31,711.25 1,066,711.25 - 1,066,711.25 1,098,422.50
<br />06/15/2040 - - 21,620.00 21,620.00 - 21,620.00
<br />12/15/2040 1,055,000.00 2.000% 21,620.00 1,076,620.00 - 1,076,620.00 1,098,240.00
<br />06/15/2041 - - 11,070.00 11,070.00 - 11,070.00
<br />12/15/2041 1,080,000.00 2.050% 11,070.00 1,091,070.00 - 1,091,070.00 1,102,140.00
<br />Total $9,935,000.00 $3,006,386.88 $12,941,386.88 $13,594,662.52 $26,536,049.40
<br />2020A GO CIP Bonds - PreS I SINGLE PURPOSE 1 10/12/2020 12:40 PM
<br />litEHLERS
<br />ir,,LI 1-INA cE AL.,,,,,,,
<br />
|