|
City of Ramsey, Minnesota
<br />$9,045,000 General Obligation CIP Bonds, Series 2020
<br />Assumes Current Market BQ AA+ Rates plus 25bps
<br />Wrap Around Debt - $9.422M Cash
<br />Debt Service Schedule
<br />Date Principal Coupon Interest Total P+I Existing D/S Net New D/S 105% of Total
<br />12/15/2020 - 963,906.25 963,906.25 1,012,101.56
<br />12/15/2021 281,806.42 281,806.42 1,177,012.50 1,458,818.92 1,531,759.87
<br />12/15/2022 - 205,365.00 205,365.00 1,199,212.50 1,404,577.50 1,474,806.38
<br />12/15/2023 - 205,365.00 205,365.00 1,217,962.50 1,423,327.50 1,494,493.88
<br />12/15/2024 205,365.00 205,365.00 1,235,362.50 1,440,727.50 1,512,763.88
<br />12/15/2025 - 205,365.00 205,365.00 1,251,412.50 1,456,777.50 1,529,616.38
<br />12/15/2026 - 205,365.00 205,365.00 1,251,112.50 1,456,477.50 1,529,301.38
<br />12/15/2027 - 205,365.00 205,365.00 1,249,912.50 1,455,277.50 1,528,041.38
<br />12/15/2028 205,365.00 205,365.00 1,252,812.50 1,458,177.50 1,531,086.38
<br />12/15/2029 - 205,365.00 205,365.00 1,249,662.50 1,455,027.50 1,527,778.88
<br />12/15/2030 - 205,365.00 205,365.00 1,254,193.76 1,459,558.76 1,532,536.70
<br />12/15/2031 - 205,365.00 205,365.00 1,256,006.26 1,461,371.26 1,534,439.82
<br />12/15/2032 820,000.00 1.950% 205,365.00 1,025,365.00 1,025,365.00 1,076,633.25
<br />12/15/2033 835,000.00 2.050% 189,375.00 1,024,375.00 1,024,375.00 1,075,593.75
<br />12/15/2034 855,000.00 2.150% 172,257.50 1,027,257.50 1,027,257.50 1,078,620.38
<br />12/15/2035 870,000.00 2.200% 153,875.00 1,023,875.00 1,023,875.00 1,075,068.75
<br />12/15/2036 890,000.00 2.250% 134,735.00 1,024,735.00 1,024,735.00 1,075,971.75
<br />12/15/2037 910,000.00 2.300% 114,710.00 1,024,710.00 1,024,710.00 1,075,945.50
<br />12/15/2038 935,000.00 2.350% 93,780.00 1,028,780.00 1,028,780.00 1,080,219.00
<br />12/15/2039 955,000.00 2.400% 71,807.50 1,026,807.50 1,026,807.50 1,078,147.88
<br />12/15/2040 975,000.00 2.450% 48,887.50 1,023,887.50 1,023,887.50 1,075,081.88
<br />12/15/2041 1,000,000.00 2.500% 25,000.00 1,025,000.00 1,025,000.00 1,076,250.00
<br />Total $9,045,000.00
<br />Significant Dates
<br />$3,545,248.92 $12,590,248.92 $14,558,568.77 $27,148,817.69 $28,506,258.57
<br />Dated 8/01/2020
<br />First Coupon Date 6/15/2021
<br />Yield Statistics
<br />Bond Year Dollars
<br />Average Life
<br />Average Coupon
<br />Net Interest Cost (NIC)
<br />True Interest Cost (TIC)
<br />Bond Yield for Arbitrage Purposes
<br />$154,266.75
<br />17.055 Years
<br />2.2981290%
<br />2.3567612%
<br />2.3645367%
<br />2.2927754%
<br />All Inclusive Cost (AIC) 2.4230824%
<br />2020 GO CIP Bonds - $9.42 I SINGLE PURPOSE 1 4/23/2020 12:56 PM
<br />gii,„iFREERS
<br />FINANCE ADVI,Ov5
<br />
|