|
City of Gem Lake, Minnesota
<br />$70,000 General Obligation Improvement Bonds, Series 2018A
<br />Revenue Portion (429)
<br />Debt Service Schedule
<br />Net New
<br />105% of
<br />Date
<br />Principal
<br />Coupon
<br />Interest
<br />Total P+I CIF
<br />D/S
<br />Total
<br />02/01/2019
<br />1,326.67
<br />1,326.67 (1,326.67)
<br />-
<br />-
<br />02/01/2020
<br />-
<br />2,400.00
<br />2,400.00
<br />2,400.00
<br />2,520.00
<br />02/01/2021
<br />5,000.00
<br />3.000%
<br />2,400.00
<br />7,400.00
<br />7,400.00
<br />7,770.00
<br />02/01/2022
<br />5,000.00
<br />3.000%
<br />2,250.00
<br />7,250.00
<br />7,250.00
<br />7,612.50
<br />02/01/2023
<br />5,000.00
<br />3.000%
<br />2,100.00
<br />7,100.00 -
<br />7,100.00
<br />7,455.00
<br />02/01/2024
<br />5,000.00
<br />3.000%
<br />1.950.00
<br />6,950.00 -
<br />6,950.00
<br />7,297-50
<br />02/01/2025
<br />5,000.00
<br />3.000%
<br />1,800.00
<br />6,800.00 -
<br />6,800.00
<br />7,140.00
<br />02/01/2026
<br />5,000.00
<br />3.000%
<br />1,650.00
<br />6,650.00 -
<br />6,650.00
<br />6,982.50
<br />02/01/2027
<br />5,000.00
<br />3.000%
<br />1,500.00
<br />6,500.00 -
<br />6,500.00
<br />6,825.00
<br />02/01/2028
<br />5,000.00
<br />3.000%
<br />1,350.00
<br />6.350.00 -
<br />6,350.00
<br />6,667.50
<br />02/01/2029
<br />5,000.00
<br />4.000%
<br />1,200.00
<br />6,200.00 -
<br />6,200.00
<br />6,510.00
<br />02/01/2030
<br />5,000.00
<br />4.000%
<br />1,000.00
<br />6,000.00
<br />6,000.00
<br />6,300.00
<br />02/01/2031
<br />5,000.00
<br />4.000%
<br />800.00
<br />5,800.00
<br />5,800.00
<br />6,090.00
<br />02/01/2032
<br />5,000.00
<br />4.000%
<br />600.00
<br />5,600.00 -
<br />5,600.00
<br />5,880.00
<br />02/01/2033
<br />5.00000
<br />4.000%
<br />400.00
<br />5,400.00
<br />5,400.00
<br />5,670.00
<br />02/01/2034
<br />5,000.00
<br />4.000%
<br />200.00
<br />5,200.00
<br />5,200.00
<br />5.46000
<br />Total $70,000.00
<br />- $22,926.67 $92,926.67 (1,326.67) $91,600.00 $96,180.00
<br />Significant Dates
<br />Dated
<br />Y 7/12/2018
<br />First Coupon Date
<br />2/01/2019
<br />Yield Statistics
<br />Bond Year Dollars
<br />— $633.69
<br />Average Life
<br />9.053 Years
<br />Average Coupon
<br />_ 3.6179377%
<br />Net Interest Cost (NIC)
<br />_ _ 3.7186802%
<br />True Interest Cost (TIC)
<br />_
<br />3.7143652%
<br />Bond Yield for Arbitrage Purposes
<br />3.0858095%
<br />All Inclusive Cost (AIC) _
<br />_ _-_ 4.3252176%
<br />Series 2018A GO Imp Bonds I Revenue Portion (429) 1 6/19/2018 1 10:39 AM
<br />EHLERS
<br />LEADERS IN PUBLIC FINANCE
<br />
|