|
City of Ramsey, Minnesota
<br />$9,065,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+l Existing DIS Net New DIS 105% of Total
<br />12/15/2021 - 155,465.63 155,465.63 1,177,012.50 1,332,478.13 1,399,102.04
<br />12/15/2022 162,225.00 162,225.00 1,199,212, 50 1,361,437.50 1,429,509.38
<br />12/15/2023 162,225.00 162,225.00 1,217,962.50 1,380,187.50 1,449,196.88
<br />12/15/2024 162,225.00 162,225.00 1,235,362.50 1,397,5 87. 50 1,467,466. 88
<br />12/15/2025 162,225.00 162,225.00 1,251,412.50 1,413,637.50 1,484,319.38
<br />12/15/2026 - 162,225.00 162,225.00 1,251,112. 50 1,413,337.50 1,484,004.38
<br />12/15/2027 162,225.00 162,225.00 1,249,912,50 1,412,137.50 1,482,744.38
<br />12/15/2028 162,225.00 162,225.00 1,252,812.50 1,415,037.50 1,485,789.38
<br />12/15/2029 162,225.00 162,225.00 1,249,662.50 1,411,887.50 1,482,481.88
<br />12/15/2030 - 162,225.00 162,225.00 1,254,193.76 1,416,418.76 1,487,239.70
<br />12/15/2031 162,225.00 162,225.00 1,256,006.26 1,418,231.26 1,489,142. 82
<br />12/15/2032 840,000 00 1.450% 162,225.00 1,002,225.00 1,002,225.00 1,052,336.25
<br />12/15/2033 855,000.00 1.550% 150,045.00 1,005,045.00 1,005,045.00 1,055,297.25
<br />12/15/2034 865,000.00 1.600% 136,792.50 1,001,792.50 1,001,792.50 1,051,882.13
<br />12/15/2035 880,000.00 1.700% 122,952. 50 1,002,952.50 1,002,952.50 1,053,100.13
<br />12/15/2036 895,000.00 1.750% 107,992. 50 1,002,992.50 1,002,992.50 1,053,142.13
<br />12/15/2037 910,000.00 1.850% 92,330.00 1,002,330.00 1,002,330.00 1,052,446.50
<br />12/15/2038 925,000.00 1.900% 75,495.00 1,000,495.00 1,000,495.00 1,050,519.75
<br />12/15/2039 945,000.00 1.950% 57,920.00 1,002,920.00 1,002,920.00 1,053,066.00
<br />12/15/2040 965,000.00 2.000% 39,492.50 1,004,492.50 1,004,492,50 1,054,717.13
<br />12/15/2041 985,000.00 2.050% 20,192,50 1,005,192.50 1,005,192.50 .1,055,452.13
<br />Total $9,065,000.00
<br />$2,743,153.13 $11,808,153,13 $13,59,1,662,52 $25,402,815.65 526,672,956.43
<br />Significant Dates
<br />Dated
<br />First Coupon Date
<br />Yield Statistics
<br />12/30/2020
<br />6/15/2021
<br />Bond Year Dollars
<br />$150,507.29
<br />Average Life
<br />16.603 Years
<br />Average Coupon
<br />1.8226048%
<br />Net Interest Cost (NIC)
<br />True Interest Cost (TIC)
<br />Bond Yield for Arbitrage Purposes
<br />All Inclusive Cost (AIC)
<br />2020A GO CAP Bonds - PreS I SINGLE PURPOSE 111/ 2/2020 111:04 AM
<br />1.8828344%
<br />1.8887180%
<br />1.8181513%
<br />1.9485196%
<br />oEHLERS
<br />`3 7 b:CF /.DYlS47
<br />
|