|
City of Pequot Lakes,Minnesota Master Cash Flow
<br /> Bank Placement
<br /> �2,098,000
<br /> General Obligatfon Utility Revenue and Disposal System Bonds, 2020A
<br /> Uses o1 Funda Bond Details
<br /> Utllity Related Construction 805,792
<br /> Sewer Disposel 835,000 Sale Date 4/7/2020
<br /> Non lltllity Related(Street) 756,000 Dated Dete 4I21/2020
<br /> Subtotal Constructlon 2 386 792 Cbsing Date 4/21/2020
<br /> Engineering(design,construdion,study,geotech) 384,497 1 st Interest Payment 2I1/2021
<br /> Continpency 150,000 Proceeds spent by 12/31l2021
<br /> LeflaVRWlAdminlstreUon 50,000 ro D,red D.ro
<br /> Total ProJ�ct Costa 2,8E1,289 Purchase Price 2.077,020 00
<br /> Placement Agent Fee 1 00% 20,980 Net Interest Cost 407,173.04
<br /> Other. • Nel Effective Rate 2.1400Y,
<br /> Finanual Advisor Venfied 16,000 Average Coupon 2 140%
<br /> Bond Counsel Verifred 11,000 Average Llfe 9 0890
<br /> Pay Agent Setup - YiekJ 2 1394%
<br /> Miscellaneous Venfied 1,500 CallOption 2Itl2028
<br /> Rating Apency Fee - Purchaser Bremer Bank,National AssoGation
<br /> Capitallzed Interest 17,610 Placement Agent RW Baird
<br /> Rounding 121 Bond Counsel Tafl Stettinius�HolHster LLP
<br /> 3,048,500 Pay Agent Ciry of Pequot Lakes
<br /> Discbsure Umfted
<br /> Sourc�s of Funds Authoriry MS 115,444 and 475
<br /> Bondlsaue 2,088,000
<br /> Bid Premium -
<br /> Sourcewell Contrlbution 7,500
<br /> City Contributio�(Fund 402-371 Tumbeck Funds) 943,000
<br /> ConsWction Fund Eamings(excess proceeds) 0
<br /> 3,048,500
<br /> Payment Sch�dule S Cashflow
<br /> Payment Schedule Revenues Account Balances
<br /> 12-Month Payment TOTAL CoAection Weter Sewer Tex Surplus Account
<br /> Period endinq Prinapal Rate Interest Total PLUS 6°/. Year Revenues Revenues Levies (deficit) Batance
<br /> 4l21I2020 Unused Discount 6 accrued interest> 17,731
<br /> 2/1/2021 25,000 214°h 34,920 59,920 82,038 2020 22,172 22,172 - (17,691) 40
<br /> 211/2022 119,000 2.14% 44,362 183,382 171,630 2021 41,854 41,854 87,783 (40) (0)
<br /> 2l1/2023 121,000 214% 41,816 162,816 170,8b6 2022 41,727 41,727 87,503 - (Q)
<br /> 2/1l2024 124,000 2 t4°h 39,226 163,226 171,38a 2023 42,114 42,114 87,159 • (0)
<br /> 2/112025 127,000 2.1�% 36,573 163,573 171,751 2024 41,954 41,954 87,644 - (0)
<br /> 211f2026 129,000 214% 33,855 162,855 170,985 2025 41,782 41,762 87,433 - (0)
<br /> 2I1I2027 932,000 2.14% 31,094 163,094 171,249 2026 42,124 42,124 87,000 - (0)
<br /> 211/2028 135,000 214°h 28,269 163,269 171,433 2027 41,919 41,919 87,595 - (0)
<br /> 211/2029 137,000 214% 25,380 162,380 170,499 2028 41,703 41,703 87,094 - (0)
<br /> 2/1l2030 141,D00 214% 22,449 163,449 171,621 2029 42,000 42,OD0 87,627 - (0)
<br /> 211/2031 143,000 2.74% 19,431 162,431 170,531 2030 41,750 41,750 87,054 - (0)
<br /> 2/1/2032 147,000 2.14% 18,371 163,371 '171,540 2031 42,013 42,013 87,513 - (0)
<br /> 2/1/2033 149,000 214°/a 13,225 162,225 170,338 2032 41,729 41,729 86,878 - (0)
<br /> 2/1l2034 153,000 214°/ 10,037 163,037 171,188 2033 41,959 41,959 87,270 - (0)
<br /> 2/1l2035 157,000 214°� 6,762 163,762 171,951 2034 42,166 42,166 87,618 - (0)
<br /> 2/1/2036 159,000 214% 3,403 162,403 170,623 2035 41,826 47,826 86,870 - (0)
<br /> 2,098,D00 407,173 2,505,173 2629,551 650,792 650,792 1,310,236 (17,731)
<br /> David Drown Assocletes,Inc
<br />
|