|
City of Gem Lake, Minnesota
<br />$665,000 General 0bIigation .[mprovement Bonds, Series 2018A
<br />Issue Summary
<br />Assumes Current Market BQ AA+ Credit Enhanced Rates plus 25bps
<br />Debt Service Schedule
<br />Net New
<br />Date
<br />Prin6l al
<br />Coupon
<br />Interest
<br />Total :P+I CIF
<br />D1S
<br />Flscal Total
<br />07/01/2018
<br />-
<br />- -
<br />02/01120.19
<br />-
<br />1lit 89.33
<br />1I,188.33. (11,188:33)
<br />-
<br />-
<br />08/01/2019
<br />-
<br />-
<br />9,590.00
<br />9;590.00 -
<br />9,590,00
<br />-
<br />02101/2020
<br />35,000.00
<br />2:050%
<br />9,590,00
<br />44,590100: -
<br />44;590.00
<br />54,180.00
<br />08101/2620
<br />-
<br />9,231.25
<br />9,23.1.25 -
<br />9,231.25
<br />02/01l2021
<br />40,000.00
<br />2.200%
<br />9,231.25.
<br />4.9,231,25 -
<br />49,231.25
<br />5846250
<br />08/01/2021
<br />-
<br />81791..25
<br />8,79145 -
<br />8,791+25
<br />02/01/2022
<br />40,000.00
<br />2,3509/.
<br />8,791:25
<br />48;79i.2S -
<br />48,791.25
<br />57,582.50
<br />08101/2022
<br />-
<br />-
<br />4,321.25
<br />8;321.25
<br />8,321:25
<br />-
<br />02/01/2023
<br />40,000.00
<br />2.450%
<br />8,321,25
<br />49.321,25 -
<br />48,32i.25
<br />56,642.50
<br />08/01/2023
<br />-
<br />7.831.25
<br />7,931.25 -
<br />71831.25
<br />-
<br />02M/2024
<br />.40,000,00
<br />2.550°%
<br />7,831.25
<br />47,831,25 -
<br />47,83.1:25
<br />55,662.50
<br />08/01/2024
<br />-
<br />-
<br />7,321;25
<br />7,321,25. -
<br />71321.25
<br />-
<br />02/01/2025
<br />40,000.0.D
<br />2;65T/0
<br />7,321.25
<br />47,321.25
<br />47,321.25
<br />54;642,50
<br />09/01/2925
<br />-
<br />6,7.91.25.
<br />6,791:25
<br />6,791.25
<br />-
<br />02/61/2026
<br />45,000.DD
<br />2,730%
<br />6,79115
<br />51,791,25
<br />51391:25
<br />58,532.50
<br />08MI/2026.
<br />-
<br />-
<br />61172.56..
<br />6,172,50 -
<br />6,172.50
<br />-
<br />02/0112027
<br />45,000.00
<br />21850°/u
<br />6,172,50
<br />51072.50 -
<br />51,172.50
<br />51,145,00
<br />D81D112027
<br />-
<br />-
<br />5,53125
<br />5,531.25 -
<br />5;53I.25
<br />-
<br />02/01/2028
<br />45,000,00
<br />2.950%
<br />5;531:25
<br />50,531.25
<br />50,531.25
<br />56,0062.50
<br />09/01/2028
<br />-
<br />-
<br />4;867,50
<br />4.867,50 -
<br />4,867,50
<br />02/01/2029
<br />45,000.40
<br />3.050%
<br />.4,867:50
<br />49,867.50 -
<br />49.867.50
<br />54,735.00.
<br />08/01/2029
<br />-
<br />4,181.25
<br />4,181:25. -
<br />4,181,25
<br />-
<br />02/01/2030
<br />4.SA D
<br />3.200%
<br />4,18.1.25
<br />49.191.25.
<br />49,181,25
<br />53,362:50
<br />08/01/2030
<br />-
<br />3,461.25
<br />3;461.25.
<br />3,461.25
<br />-
<br />02/0ll2031
<br />50,000,00
<br />3.300%
<br />3,461,25.
<br />53,461.25 -
<br />53,461.25
<br />56,922.50
<br />09/01/2031
<br />-
<br />-
<br />2,636.25
<br />2,636.25 -
<br />2,636.25
<br />-
<br />02/01/2032
<br />50,000.00
<br />3.356%
<br />2,636.25
<br />52,636.25 -
<br />52,636.25
<br />55,272.50
<br />08/01/2032
<br />-
<br />-
<br />1,798.75
<br />1.798.75 -
<br />1,798,75
<br />-
<br />0210I72033
<br />56,a00,00
<br />3.4007o
<br />1;798,75
<br />51,798,75
<br />51,798.75
<br />53,597.50
<br />08/01/2033
<br />-
<br />-
<br />949.75
<br />949,75 -
<br />94815
<br />-
<br />0?10112034
<br />55,090,00
<br />3.450%
<br />948,75.
<br />5.5,949+75 -
<br />55,949,75.
<br />56,897.50
<br />iota]
<br />,5665;000.00.
<br />-
<br />$186,138.33
<br />$85%1303. (11,188.33)
<br />$939,950.0D
<br />-
<br />Significant dates
<br />Elated.
<br />_
<br />_.»..
<br />_
<br />_.-..
<br />7/01/2018
<br />w. _...
<br />_._.--_....
<br />210I/2619
<br />Yield Statistics
<br />Bond Year Dollars _.... «
<br />_.._... _ .._ .._. .. .__ $6,02192
<br />«.. ...-... .e _....--._..._._.-... _. _..-..w_._._.._
<br />9.037 Y.eurs
<br />Net Interest Cast (NICE w_....,_..W . _....__.__._..w._... .W. _�_._..
<br />__.. _ _ 12561189%
<br />True Interest Cost MC) _... �.. _. _.__..-_._.......
<br />� _. _. �~ 3,2686793%
<br />_
<br />Bond Yield.for Ashitra8e Purposes,
<br />w__.- 3.0714340%
<br />_ _W.-_
<br />All Inclusive Cost(AIC)
<br />_
<br />3.9520443%
<br />IRS Form.8038.
<br />3.0905015%
<br />__--__._.....__...._._......._......_�.....-,..�......,.....__........_...___........-._.._...._,.r...�,.,.M 9:057 Years
<br />18A GOTmp 9onds I Issue Summary 14JAW18 1 1 A PM
<br />EHLERS
<br />LEADERS IN PUBLICFINANCE.
<br />
|