|
Ci of Gem Lake, Minnesota
<br />$70,000 General Obligation Improvement Bonds, Series 201 SA
<br />Revenue Portion (429)
<br />Assumes Current Market BQ AA+ Credit Enhanced Rates plus 25bps
<br />Debt Service Schedule
<br />Net New
<br />165%.0f
<br />Date
<br />Principal
<br />Coupon
<br />Interest
<br />Total P+l CIF
<br />DIS
<br />Total
<br />02/01/2019
<br />-
<br />-
<br />1,181.25
<br />I;181125 (1,181.:25)
<br />02/01/20.20
<br />-
<br />2,025.00
<br />2,025m -
<br />2,025,00
<br />2,12625
<br />02/01/2021
<br />5,000,00
<br />2,200°%
<br />2,025.00
<br />7,025M -
<br />7,02100
<br />7,376.25
<br />02/01/2022
<br />5,000.00
<br />2.350°%
<br />1,915.OQ
<br />61915.OQ -
<br />6,915.,00
<br />7,260,75
<br />02/01/2023
<br />5,006.06
<br />2,450°/0
<br />1,79750
<br />6,797,50 -
<br />63.97.50
<br />7.137.38
<br />02101t2025
<br />- --- --
<br />5,000.00
<br />—•---•-
<br />1650°%
<br />-
<br />1;547.5.0
<br />.6;547.5Q
<br />- p,v.f.7.vu
<br />- 5,54.7.50
<br />I'wo,/3
<br />6,874.88
<br />02/01/2026
<br />5,006.00
<br />1750%
<br />1141.5..00
<br />6;415,00
<br />- 6,415.00
<br />61735.75
<br />02/01/2027
<br />5,000;00.
<br />2$50%
<br />1,247:50
<br />6, 17.50
<br />- 6.277.50
<br />6,541.3.8
<br />0210i72028
<br />5,000.00
<br />2.950%
<br />1,135,00
<br />6,135.00
<br />- 6.135,00
<br />6.441.75
<br />02/01/2010
<br />5,000.00
<br />3,20OVo
<br />835.00
<br />.5,835.00
<br />- 5,835:00
<br />6,126,75
<br />0210112031
<br />5,000.00.
<br />3.300"%
<br />6.75,00.
<br />5,675.00
<br />- 5,675.00
<br />5,958.75
<br />02/01/2032
<br />5,000.00
<br />3,350%
<br />510.00
<br />5;510.00
<br />- 5,510,04
<br />5,78.5.50
<br />02101033
<br />5,000,00
<br />.3,400%
<br />342.5.0
<br />5;342;50
<br />5,342.50
<br />5;(509,63
<br />02/01/2034
<br />5,000+00
<br />3,450%
<br />172.50
<br />5,172.50
<br />- 5,17150
<br />5,431.13
<br />Total
<br />$70,000.00
<br />-
<br />$19,516.25
<br />$89,516M
<br />(1,18L25) $99,335.00
<br />$92,751.75.
<br />5i rlif 2ht Rates
<br />bated �( _�.._.,_..,_.,_........._...____--.._.�_..,....,.._.�._.._..�.._..._......._
<br />710i1201 a
<br />Firs[ Coupon Date.
<br />—........w...._........... _
<br />.2101/2019
<br />Yleld Statistics
<br />Band Year Dollars ..
<br />$635.83
<br />yerage i e.,.�......_-....Y..._._.-_.„._...„.-._�.._.��.,_,._.._.
<br />9:083 Years.
<br />_ _
<br />Average Cflupon
<br />3.0693971%
<br />Netinterest:Cost IVI�C) w µ
<br />3.2345347%
<br />TrueIriterestCost MC)
<br />3:2466859%a
<br />on Yield for Aroitr EiUrpnses - _
<br />_.. 30714340%
<br />All .Inclusive :Cosf(AIC) .w _.
<br />.r _ 3.424if0990
<br />Series 2818A GO Imp eonds i Revenue?orWn (429) 1 4126M18 I 1-.43 PM
<br />EHLERS
<br />LEADERS IN PU$LIC FINANCE
<br />
|