|
City of Pequot Lak�s,Minnesota
<br /> SZ,1IS,OOO �,Yw;Yr'�'
<br /> `tM:�s���:�.:.:$ .r..
<br /> Generol Obligation Revenu�and Disposal System Bonda, 2020A
<br /> Us�s of Funds Bond D�Lib
<br /> Utilily Related Constnx:tion 8p5,792 Set Sale Date
<br /> Sewer Disposal 835.000 Sab Date 3/5/2020
<br /> Non UWity Related(Street) 756 Opp Dated Date ��020
<br /> Subtotat Construetion , 2 792 Cbaing Date 4/2�/2020
<br /> Engineering(design,construcUon,sWdy,geotech 384,497 1at Intereat Payment
<br /> Contingency 150.000 Proceeds 2/7/2021
<br /> LeyaURW/Administration s�t�� 12/31/1021
<br /> 50,000
<br /> Other. - Purchase Prioe ro naroa osn
<br /> Other: 2.088.582.50
<br /> - Net Intereat Coat 429,056.19
<br /> �r - Net Effective Rate
<br /> Tohl Proj�et Costs 2.Y�7,2sY Avenge Coupon 2.2867%
<br /> Undervvriter's DiacouM Albwance 1.25•k 26,�38 Average Life 2•��`yO
<br /> Unused Undervvritefs Discount Albwance - Cali Opfion 8•8716
<br /> Finandal Advisor Verifrod 16.000 Purchaser 2/1/2029
<br /> Bond Counsel Veri/fed Proposed for Competitive Sale
<br /> 10,000 Bond Counsel TaR Law PA
<br /> Pay Agent Setup Verified 750 Rating Agenq
<br /> Miscellaneous Verified 1.500 Pay AgeM Sfandard�Poors
<br /> RaUng Ayenq Fee Estimate 11,500 Discbsure Northland Trust Services
<br /> Capifalized Irrterest
<br /> 14,320 qutlqrity Limited
<br /> Rounding 3.704 MS 115,444 and 475
<br /> 3.065,500
<br /> Sourus of Funda
<br /> ����� 2,115,000
<br /> Bond Premium
<br /> Sourcewell ContribWon 7,500
<br /> City CoMribution(Fund 402-371 Tumback Funds) 943,000
<br /> ConsUudion Fund Eamings(excess proceeds)
<br /> 3,065,500
<br /> Paym�nt Sch�dub E Cashllow
<br /> Pavment Schedule
<br /> Revenuea Account Balances
<br /> 12-MonVi Payment TOTAL Colledion Utility
<br /> Period endinsa Principal Rate IMerest Total PWS 5'K T� Surplus Acoount
<br /> M27/2020
<br /> Year Revenues Levies defiat ge�enoe
<br /> 2/1/2021 30,000 1.550°h 2g,641 5g 6�� Unused DiscouM 3 axnied interest> 18,024
<br /> d0l57 2020 46.202 (14,656) 3�368
<br /> 2/1/2022 725,000 1.550% 41,793 166.793 175.132 2021 g4�8gg
<br /> 2H/2023 125,000 1.600% 39,855 164,855 173,Oaa " ' 87,066 (3,36E) _
<br /> 2022 63,722 89.376
<br /> 2/1/2024 130.000 1.650°� 37,855 167,855 176.24L 2023 87.964 -
<br /> 2/1/2025 130,000 1.700% 35,710 165,710 173,Y96 �'2� " -
<br /> 2024 86,838 a7.158
<br /> 2J1/2026 130,000 7.750% 33,500 163,500 111,673 2026 85.677 -
<br /> 2/1/2027 135,000 1.800SG 31,225 166,225 174,536 _ - �,� . _
<br /> 2026 84.483 90,053
<br /> 2/�/2028 135.000 1.900•rb 28,795 163.795 171.9�5 2027 83,255 -
<br /> 2/1/2029 140.000 1.950X, 26.230 166.230 174,5�2 - - 86.730 - -
<br /> 2028 87,208 87,334
<br /> 2/1/2030 140,000 2.0504L 23,500 163,500 171,675 2029 55,775
<br /> 2/1l2031 140,000 2.160% 20,630 160,630 �6a,66y ���� - -
<br /> 2030 84,266 y�3�
<br /> 2/�l2032 140.000 2.200'k 17,620 157,620 165,501 Zp3� $2688 ' -
<br /> 2/1/2033 150,000 2.250% 14,540 784,540 ��p,�s� - - 82,a14 _ _
<br /> 2032 E6,321 ��7
<br /> 2/1/2034 150,000 2.350`L '11,165 161,165 169,223 2033 gq,�g "
<br /> 2/1/2035 155,000 2.400% 7,640 162,640 �7p,7�2 ' - 81,675 _ _
<br /> 2034 E2,698 88.074
<br /> 2/1/2036 160.000 2.45056 3 920 183 920 17 1�6 2035 gg 05g _ -
<br /> 86 058
<br /> -_2,115.000 402.619 2.517 619 2 6�2 7!4 7.322.400 - - 1 302 360 H d 024)
<br /> David Drown Associates,Inc.
<br />
|