HomeMy WebLinkAboutA094 - Certificate of Final Loan Balance dated April 5, 2021 IOWA FINANCE AUTHORITY CC�31
DRINKING WATER PROGRAM REVOLVING LOAN FUND
CERTIFICATE OF FINAL LOAN BALANCE
Loan Recipient: Date of Loan Agreement:
City of Ames January 30,2015
Mailing Address: Amount of Loan Agreement:
515 Clark Ave $76,325,000.00
Ames,IA 50010
Total of All Loan Disbursements:
DNR Project Number $68,081,339.32
FS-85-10-DWSRF-046 Date of Final Disbursement:
IFA Loan Number April 2,2021
DF0322RT Remaining Loan Account Balance:
$8,243,660.68
Forgivable Portion:
$6,598,621.20
The undersigned Loan Recipient hereby certifies to the Iowa Finance Authority(the Authority)
and the Iowa Department of Natural Resources (IDNR)that it has submitted a final Loan
Disbursement Requisition to the Authority representing final project costs for which the above
Loan Agreement was made, and further certifies that no additional disbursements will be
requested by the undersigned from the above-referenced Loan Account. The date and amount
of the Loan Agreement,the Total of all Loan Disbursements received to date,the Date of Final
Disbursement and the Remaining Loan Account Balance are as set forth above. The Remaining
Loan Account Balance reflected above should be(i)used to adjust and reduce the principal
amount of the Loan Agreement and(ii) reallocated to another Loan Participant. Interest on the
principal amount of the Loan Agreement shall accrue from the Date of Final Disbursement, as
set forth in the debt service schedule attached as Exhibit A to the Loan Agreement.
City of Ames
Date:
Name: �✓GcGVI� '
Title:
Final Amortization Schedule
City of Ames
DF0322RT
FS-85-10-DWSRF-046
i
LQ.P _wni,rtiAty Final,Draw Schedule
Loan Closing Dale Jan 30,2015 Initiation Fee Jan 30,2015 100,000.00 Pi
Final Disbursement Date Apr 02,2021 Actual Draw Jan 30,2015 6,870,181.07
Final Maturity Date Jun 01,2037 Actual Draw Feb 27,2015 2,987,572,79
Actual Draw Mar 13,2015 582,799.94 Loan Period in Years 20 Actual Draw May 15,2015 1,714,060.52 S TAT E
Original Loan Amount 76,325,000.00 Actual Draw Jul 10,2015 3,231,248.86
0.5%Initiation Fee 100,000.00 Actual Draw Jul 24,2015 5,186.05 --
Unused Proceeds,If Any 8,243,660,68 Actual Draw Aug 21,2015 3,735,056.70
Annual Interest Rate 1.75% Actual Draw Oct 23,2015 1,781,715.37
Actual Draw Nov 20,2015 1,984,232.36
Total Interest 13,331,911.05 Actual Draw Jan 08,2016 3,938,182.25
Servicing Fee Rate 0.25% Actual Draw Jan 22,2016 37,668.42
Total Servicing Fees 1,904,558.73 Actual Draw Mar 18,2016 2,711,967.01
Total Loan Costs 15.336,469.78 Actual Draw Apr 01,2016 4,750.00
Actual Draw Apr 29,2016 3,896,748,58
Actual Draw Jul 22,2016 4,343,782.12
Actual Draw Sep 16,2016 2,184,407.21
Actual Draw Jan 06,2017 5,958,075.13
Actual Draw Feb 24,2017 2,721,053.87
Actual Draw Apr 28,2017 9,810,307.96
Actual Draw Jun 26,2017 4.086,233.28
Actual Draw Jun 26,2017 540,925.25
Actual Draw Aug 18,2017 124,925 00
Actual Draw Sep 22,2017 1,577,364,78
Actual Draw Oct O6,2017 20,508 60
Actual Draw Feb 02,2018 1,882,012.60
Actual Draw Oct 26,2018 481,378.19
Actual Draw Apr 05,2019 675,393.17
Actual Draw Feb 19,2021 88,602.24
Actual Draw Apr 02,2021 5,000.00
Sub Total 68,081,339.32
Forgiveness Apr 02,2021 (6,598,621.20)
Final Loan Amt 61,482,718.12
aa
Payment Beginning Servicing Total Loan Total Annual Debt Ending
Date Balance Principal Interest Fee Payment Service Balance
Jun 01,2015 12,254,61.1.3'2 56,859.55 8,122 ,'t 64,982 34 12.264.6 4 32
Dec 01,2015 22,992.053.66 152,188,32 21,741.19 173,929.51 22,992,053.66
Jun 01,2016 33,581,369.92 245,552.70 35,078.96 280,631.66 519,543,51 33,581,369.92
Dec 01,2016 40,109,559.25 329,040.10 47,005.73 376,045.83 40,109,559.25
Jun 01,2017 58.598,996.21 421,522.69 60,217.53 481,740.22 857,786.05 58.598,996.21
Dec 01,2017 64,948,953.12 553,576 64 79,082.38 632,659.02 64,948,953.12
Jun 01,2018 66,830,965.72 2,870,000.00 579 190.26 82,741.47 3,531,931,73 4,164,590.75 63,960,965.72
Dec 03,2018 64,442,343.91 560,477.46 80,068.21 640,545.67 64,442.343.91
Jun 03,2019 65,117,737.08 2,927,000.00 565,709.08 80,815.58 3,573,524.66 4.214,070.33 62,190,737.08
Dec 02,2019 62,190,737.08 544,168.95 77,738.42 621,907,37 62,190,737.08
Jun 01,2020 62,190,737.08 2,986,000.00 544,168 95 77,738.42 3,607,907.37 4.229,814.74 59,204,737.08
Dec 01,2020 59,204,737.08 518,041.45 74,005,92 592,047.37 59,204,737.08
Jun 01,2021 52,699,718.12 2,686,718.12 499,569.90 71,367.13 3,257,655,15 3,849,702.52 50,013,000.00
Dec 01,2021 50.013,000.00 437,613.75 62,516.25 500,130.00 50.013,000.00
Jun 01,2022 50.013.000.00 2,736,000.00 437,613.75 62,516,25 3,236,130.00 3,736,260.00 47,277,000.00
Dec 01,2022 47,277,000.00 413,673,75 59,096.25 472,770.00 47,277,000.00
Jun 01,2023 47.277,000 00 2,783,000.00 413,673.75 59,096 25 3,255,770.00 3,728,540.00 44,494,000.00
Dec 01,2023 44,494,000.00 389,322,50 55.617.50 444,940.00 44,494,000,00
Jun 01,2024 44,494,000.00 2,832,000.00 389,322.50 55,617.50 3,276,940.00 3,721,880.00 41,662,000.00
Dec 01,2024 41,662,000,00 364.542.50 52,077.50 416.620.00 41,662,000.00
Jun 01,2025 41,662,000.00 2,882,000.00 364,542.50 52,077.50 3,298,620.00 3,715,240.00 38,780,000,00
Dec 01,2025 38,780,000.00 339,325.00 48,475.00 387,800.00 38,780.000.00
Jun 01,2026 38,780,000.00 2,932,000.00 339,325.00 48.476.00 3,319,800.00 3,707,600.00 35,848,000.00
As Of 04/05/2021 INVESTING IN IOWA'S WATER
www.iowasrf com
............
.............- ............. ........
Payment Beginning Servicing Total Loan Total Annual Debt Ending
Date Balance Principal Interest Fee Pavment Service Balance
Dec 01,2026 35,848,000.00 313,670.00 44,810.00 358,480.00 35,848,000.00
Jun 01,2027 35,848,000.00 2,983,000.00 313,670.00 44,810.00 3,341,480.00 3,699,960.00 32,865,000.00
()1,r,,027 32,865,000,00 287,568,75 41,0131,25 32U50 00 32,865,000.0
Jun 01,x,028 32,865,000,00 3,030,000,00 U7,56815 4 1,00 1,25 3,3654,650 DC', 1WI,3,300 00 29,&19,000m
Dec 01,2028 29,829,000.00 261,003.75 37,286.25 298,290.00 29,829,000.00
Jun 01,2029 29,829,000,00 3,089,000.00 261,003.75 37,28(3.25 3,387,290.00 3,685,580.00 26,740.000,00
t'fie 26JM,000=
,(,,T_,1,21)2'�4 21��,'T 4 0,0 0 Gj)0 233,075,00 3,K 4 2�,0 0 267,400 00
jw 01,20"W 26,/40,000,00 3,143,000,00 233,97600 3?,4 26 00 3,410,400,00 3,677,800 00 23,`.97,4000M
Dec 01,2030 23,597,000.00 206,473.75 29,496.25 235,970.00 23,597,000.00
Jun 01,2031 23,597,000.00 3,198,000.00 206,473.75 29,496.25 3,433,970.00 3,669,940.00 20,399,000-00
Dec 01,2031 20,399,000M 178,494,25 25,49875 203,1990,00 20,399,000M
Jtin 01,2032 4,390.000.01,'' 178,491,25 ?,a,49815 3,457,990,01) 3,661,980,00 17,145,000.00
Dec 01,2032 17,145,000.00 150,018.75 21,431.25 171,450.00 17,145,000.00
Jun 01,2033 17,145,000.00 3,311,000.00 150,018,75 21,431.25 3,482,450.00 3,653,900.00 13,834,000,00
Dec 01,2033 13,834,000,00 '121ke-7.50 17,292,50 lX340M 13,834;060,00
Jun 01,4'03,1 11,834,000,00 3,369,000M 121,047,50 17.292,50 3,507.340A10 1.645,680,00 10,465,000,00
Dec 01,2034 10,465,000.00 91,568.75 13,081.25 104,650.00 10,465,000.00
Jun 01,2035 10.465,000.00 3,428,000.00 91.568.75 13,081.25 3,532,650.00 3,637,300.00 7,037,000.00
Dec 0 1,203" 7,037,000,00 61,,573,75 8,7961r) 70,370.00 7,037,000,00
Jun 01,2036 7,037,000,00 3AKU00,00 s,796 25 3.558,370,00 3,62.8,740.00 3,549,000,00
Dec 01,2036 3,549,000.00 31,053.75 4,436.25 35,490,00 3,549,000.00
Jun 01,2037 3,549,000.00 3,549,000.00 31,053.75 4,436.25 3,584,490.00 3,619,980.00 0.00
As Of 04/05/2021 INVESTING IN IOWA'S WATER
www.iowasrf.com