|
City of Gem Lake, Minnesota
<br />$595,000 General Obligation Improvement Bonds, Series 2018A
<br />improvement 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 />Merest
<br />Tots[ P+I CIF"
<br />DIS
<br />Fiscal Total
<br />0T101W s
<br />02/01/2019
<br />-
<br />1.0,00 m
<br />10,007.08 (10,007M)
<br />-
<br />-
<br />08l6112014
<br />-
<br />-
<br />8,577,50.
<br />8,5.7.T,50 -
<br />8;5.77,50
<br />-
<br />02/01/2020
<br />35,0MOO
<br />2.050%
<br />8,577.50
<br />43;577.50 -
<br />43;577,50
<br />52;155.00
<br />08/01/2020
<br />-
<br />8,218.75
<br />8,218.75.
<br />8,21835
<br />02/01/2021
<br />35,000.00
<br />2.200%
<br />8;218.75
<br />43,218.75 -
<br />43,218.75
<br />51,437.50
<br />08/0112021
<br />-
<br />-
<br />7,833,75..
<br />7,833.75
<br />7,83335
<br />-
<br />02/0112022
<br />352000.00
<br />2.35Q%
<br />7,833.75
<br />42;83335 -
<br />42,833.75
<br />50 667.50:
<br />09/01/2022
<br />-
<br />-
<br />7,422.50
<br />7,422:50 -
<br />7.422;50
<br />-
<br />02/01/2023
<br />35;000.06
<br />2,450%
<br />7.422.50
<br />42,421.50 -
<br />42,422.50
<br />49,8.45,00
<br />09/0112023
<br />-.
<br />6,993.75
<br />6,993.75 -
<br />6,99.3,75
<br />-
<br />02J0112024
<br />35,000.00
<br />2.550%.
<br />6,993.75
<br />41,99175 -
<br />41;993.75
<br />48,01.50
<br />08/01/2024
<br />-
<br />6,547.50
<br />6,547.50 -
<br />6,547.5.0
<br />-
<br />02/61/2025
<br />35,000.00
<br />2.650%
<br />6,547.50
<br />41,5.47,50 -
<br />41,547.50
<br />48,095,00
<br />08/01/2025
<br />-
<br />m
<br />6,083.75
<br />6,083.75 -
<br />6,09171
<br />-
<br />�0210112026
<br />40,000:00
<br />2.7509/0
<br />6,083,75
<br />46,083.75
<br />46A3.75
<br />$2,167.50
<br />0810112026.
<br />-
<br />5,533,75
<br />5,533,75
<br />5,533.75
<br />-
<br />02101 12027
<br />40,000.00
<br />2.850%
<br />5,533.75
<br />45,531.75. -
<br />45,533.75
<br />51,067.50
<br />02/0I/2027
<br />-
<br />-
<br />4,963.75
<br />4,963;75.
<br />4,963.75
<br />-
<br />02/01I2028
<br />40,000.00
<br />2.950%.
<br />4,963.75
<br />44,963,75 -
<br />44,963.75
<br />49,927.50
<br />0810112028.
<br />-
<br />-
<br />4,373.75
<br />4,373.75
<br />4,V17.5
<br />-
<br />02101/2029
<br />40,000.00
<br />3,050%
<br />4,373.75:
<br />407175
<br />4.4,373,75
<br />49,747.50
<br />08/01/2029
<br />-
<br />-
<br />31763.75.
<br />3,163.75
<br />- 3;763.75
<br />-
<br />62IO112030
<br />40,0000
<br />3.200%.
<br />3,763,75
<br />43;763,75
<br />- 43,763,75
<br />47,527.50
<br />09/61/2030:
<br />3,123.75.
<br />3;I23.75
<br />- 3,123,75
<br />-
<br />02J0112031
<br />45,000.00
<br />.3:300%
<br />3.123.75
<br />48.123.75
<br />- .48,123;75
<br />51;247.50
<br />08/0112031
<br />-
<br />2,381,25
<br />21391.25
<br />2;381:25
<br />-
<br />02101/2032
<br />452000.00
<br />3,350%
<br />2,381.2.5
<br />47,38.1,25
<br />- 47,381.25
<br />492762.50
<br />09/01/2032
<br />-
<br />-
<br />1;627.50
<br />1,627.50
<br />1,627,50
<br />02101/2033
<br />,45.000.00
<br />3.400%
<br />1,627.50
<br />46,627.50
<br />46,627.50
<br />48,255,00
<br />0.210IM34 .50,600,00 3.4.5No. 862.50 50,864.50 - 50,862.50. 51,725.00
<br />Total. S595,000A0 - 5166,622.08 .5761,622m (10,007.09) W51,615M -
<br />8IgnifIcant Dates
<br />I]ated
<br />_ _71�1I?Al8
<br />_ _
<br />2/0 i/2019,
<br />Yield Statistics
<br />Bond Year. Doi tars
<br />9.054_Years
<br />3.0929924o/e.
<br />NetlntetestCost MC�.W_.. ...w....._._.._....... ..w_ ._�.....� wW
<br />._� _.. _ _ 3,258660W
<br />True lnlc[estCast
<br />3,2712961%
<br />Bond Yield for Arbitra a Purposes . W
<br />3_07i4340%
<br />All IncIuside Gost (AIC} _ ._ m_. _ .__
<br />_.... _ ._ .,_ �_. ._ 3.99553612%
<br />IRS Form 8038
<br />Net Interest Cost _ _ � _ �_•� 3,00929924°/a_
<br />Weighted Avqrage JALturitY .. _ _ _. .. - 9,054 Years
<br />86603 mm W Imp eoi,es� � Improvemertpcnwn.(429) I 4rt=O1.8 1 1:43 PM � T
<br />EHLERS
<br />LEADERS IN P IBUC FINANCE.
<br />
|