|
City of Gem Lake, Minnesota
<br />$70,000 General Obligation Improvement Bonds., Series 2.018A.
<br />Revenue Portion (429)
<br />Assumes Current Market BQ. AA+ Credit Enhanced Rates plus 25bps
<br />Debt Service Schedule
<br />Net New
<br />Date
<br />Principal
<br />Coupon
<br />Interest
<br />Total P+l CIF
<br />a15
<br />Fiscal total
<br />07101l202 8
<br />-
<br />_
<br />_
<br />02101l2019
<br />-
<br />-
<br />1,18I.25.
<br />1,181,25 (1,18i:25}
<br />,.
<br />68101l2019
<br />-
<br />I'012.50
<br />1,012.50 -
<br />1,0.i2:50
<br />-
<br />02/0112020
<br />-
<br />-
<br />1,012.50
<br />1;612.50 -
<br />1,612 50
<br />2,02500
<br />03/01/2020
<br />1,012,5D
<br />I012:50
<br />.1,012.50
<br />_
<br />02/01/2021
<br />5,000.00.
<br />2,200%
<br />1,0.12.50
<br />6;012;50. -
<br />6,012.50
<br />7,025.00
<br />0810112021
<br />-
<br />957.50
<br />957.50 -
<br />957.50
<br />02/01/2022
<br />5,000100
<br />2350%
<br />957.S0
<br />.5.957.50 -.
<br />5.057,56
<br />69.15.00
<br />08/0.112022
<br />898:75
<br />898.75 -
<br />898.75.
<br />-
<br />02/01/2023
<br />5;600.00
<br />2.450%
<br />898,75
<br />5,898.75
<br />5 898 75
<br />6,7.97.50
<br />08101/2023
<br />-
<br />-
<br />837.50.
<br />837.50 -.
<br />837;50.
<br />02101=24
<br />5,600.00
<br />2.550%:
<br />837,50
<br />5,837.50
<br />5,837.50
<br />6;675.0D
<br />.0810112024
<br />-
<br />773:75
<br />77175
<br />773.75
<br />02/01/2025
<br />5,000+06
<br />2:650%
<br />773;75
<br />5.,7.73,75 -
<br />5;773,75
<br />fi 547.50
<br />08101I2025
<br />-
<br />707;50
<br />707,50
<br />707,50
<br />0210112D26
<br />5.000,00
<br />2.750.%
<br />707.50
<br />5,707,50 -
<br />5,707.50
<br />6,415.00
<br />08/01/2026
<br />-
<br />-
<br />639.75
<br />638.75 -
<br />638,75
<br />02/01/2027
<br />5,600.Q0
<br />2.850%
<br />639.75
<br />5,638.75 -
<br />5,638,75.
<br />6,277,50
<br />08/01/2027
<br />-
<br />-
<br />567.50
<br />567.50 -
<br />56750
<br />-
<br />02101n028
<br />5.000.00
<br />.2.950%
<br />567,30
<br />5;567.50
<br />5,567+50
<br />6,135.00;
<br />Q810112028
<br />-
<br />493,75
<br />493.75 -
<br />493.75
<br />.:
<br />02/01/2029
<br />5;006:00
<br />3:050°/°
<br />493.75
<br />5,493.75 -
<br />5,493.75
<br />5,087.50
<br />08/61/2029
<br />-
<br />-
<br />417.50
<br />.417;50 -
<br />417.50
<br />-
<br />02/01/2030
<br />5,000.00
<br />3:2Q0%
<br />417.50
<br />5,4.17.50 -
<br />5.4I7.50
<br />5,935.00
<br />08J0112030
<br />-
<br />337:50
<br />337.56 -
<br />337.50
<br />.02/01/2031
<br />5,000,00
<br />3,300%
<br />337.50
<br />5,337.50
<br />- 5,337.50
<br />51675.00
<br />08/01/2031
<br />-
<br />-
<br />255,00
<br />255,00.
<br />- 255.60
<br />_
<br />02J0112032.
<br />5,000.0.0
<br />3.350J°
<br />255;06
<br />5,255.00
<br />5,255.00
<br />5510.00
<br />08/61/2032
<br />-
<br />-
<br />171.25
<br />1.71:25
<br />171.25
<br />02101/2033.
<br />5;000:6Q
<br />3.460°I
<br />171.25
<br />5.171.25
<br />- 5,171.25
<br />5.342.50.
<br />08101n033
<br />,
<br />86;25
<br />86,25
<br />- 86.25
<br />02/01/2034
<br />000.00.
<br />3,450%
<br />86,25
<br />5.086.25
<br />- 5,086.25
<br />5,172.50
<br />Tota]
<br />57Q,000.00
<br />-
<br />SI9,Si6.ZS
<br />589,516.25
<br />(1,i8I:25) 58835.06
<br />_
<br />Significant Dates
<br />bated
<br />710Il2018
<br />I first_2101/2019
<br />�
<br />Yield .Statistics
<br />Bond Year Dollars
<br />_
<br />Awe Lice
<br />_S635.83
<br />9.483 Years
<br />AveraECauPOn
<br />_
<br />W
<br />_
<br />__ _
<br />_ M _
<br />W .3.0693971%
<br />I�'etInterestCost [NiC} .
<br />True Interest Cost (TIC)
<br />Bond Yield for.Arbitraji Pu
<br />All Inclusfye Eost (AIC)
<br />1R5 Form 8038
<br />Cast1069397
<br />GO Imp Bonds j Revnwe Portion (429) 1 41282018 1 1:43 PM
<br />EHLERS
<br />LEADERS 14 PBBUC FINAN"
<br />
|