|
City of Pequot Lakes,Minnesota 1/72022
<br /> $176,000
<br /> General Obligation Equipment Certificate,2022A
<br /> (MN Rural Water Micro-Loan) FINAL rillii-Ae-
<br /> RURAL WATER
<br /> ,s.O C I ATI OS
<br /> Uses of Funds Schedule for Approval and Closing
<br /> Equipment 170,859.00 Application Received 1/6/2022
<br /> Rounding 91.00 Governing Board Resolution Approving Loan 2/1/2022
<br /> Capitalized Interest -
<br /> Micro Loan Fee 5,050.00 Closing and Transfer of Funds 2/15/2022
<br /> Total Project Costs 176,000.00
<br /> Sources of Funds
<br /> Micro Loan 176,000.00
<br /> Cash Contributrion -
<br /> Construction Fund Earnings(excess proceeds) -
<br /> 176,000.00
<br /> Cashfiow&Budget Requirements
<br /> Payment Schedule Pledged Revenues Account Balances
<br /> 12-Month Annual Semi-annual Annual Collection Tax Other Pledged Surplus Account
<br /> Period ending Principal Rate Interest Payment w/5%Cov'g Year Levies Revenues for Coverage (deficit) Balance
<br /> 2/15/2022 Dated Date Capitalized&accrued interest> -
<br /> 2/1/2023 20,000 2.40% 4,059.73 24,059.73 25,263 2022 24,060 - 1,203 - -
<br /> 8/1/2023 2.40% 1,872.00 1,872.00
<br /> 2/1/2024 21,000 2.40% 1,872.00 22,872.00 25,981 2023 24,744 - 1,237 - -
<br /> 8/1/2024 2.40% 1,620.00 1,620.00
<br /> 2/1/2025 21,000 2.40% 1,620.00 22,620.00 25,452 2024 24,240 - 1,212 - -
<br /> 8/1/2025 2.40% 1,368.00 1,368.00
<br /> 2/1/2026 22,000 2.40% 1,368.00 23,368.00 25,973 2025 24,736 - 1,237 - -
<br /> 8/1/2026 240% 1,104.00 1,104.00
<br /> 2/1/2027 22,000 2.40% 1,104.00 23,104.00 25,418 2026 24,208 - 1,210 - -
<br /> 8/1/2027 2.40% 840.00 840.00
<br /> 2/1/2028 23,000 2.40% 840.00 23,840.00 25,914 2027 24,680 - 1,234 - -
<br /> 8/1/2028 2.40% 564.00 864.00
<br /> 2/1/2029 23,000 2.40% 564.00 23,564.00 25,334 2028 24,128 - 1,206 - -
<br /> 8/1/2029 2.40% 288.00 288.00
<br /> 2/1/2030 24,000 2.40% 288.00 24,288.00 25,805 2029 24,576 - 1,229 - -
<br /> 176,000 19,371.73 195,371.73 205,140.32 195,372 - 9,769 -
<br /> David Drown Associates,Inc. CASHFLOW and BUDGET
<br />
|