Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
A023 - Estimated amortization Schedule
Estimated Amortization Schedule City of Ames Water Revenue Bond FS-85-21-DWSRF-010 l y` Loan SUmmar/ Estimated Draw Schedule "RF Loan Closing Date Aug 26,2022 Initiation Fee- Aug 26,2022 17,500.00 Final Disbursement Date Jun 23,2023 P&D Payoff- Aug 26,2022 Final Maturity Date Jun 1,2042 Estimated Draw#1- Aug 26,2022 347,750.00 r "¢' Loan Period in Years 20 Estimated Draw#2- Sep 23,2022 347,750.00 Total Loaned Amount $ 3,500,000.00 Estimated Draw#3- Oct 21,2022 347,750.00 0.5%Initiation Fee 17,500.00 Estimated Draw#4- Nov 18,2022 347,750.00 Net Proceeds to Borrower $ 3,482,500.00 Estimated Draw#5- Dec 16,2022 347,750.00 Annual Interest Rate 1.75% Estimated Draw#6- Jan 13,2023 347,750.00 Total Interest $ 647,983.81 Estimated Draw#7- Feb 10,2023 347,750.00 Servicing Fee Rate 0.25% Estimated Draw#8- Mar 10,2023 347,750.00 Total Servicing Fees $ 92,569.12 Estimated Draw#9- Apr 7,2023 347,750.00 Total Loan Costs $ 758,052.93 Estimated Draw#10- May 5,2023 347,750.00 Held for Final Docs- Jun 23,2023 5,000.00 Total Loaned Amount 3,500,000.00 Payment Beginning Servicing Total Loan Total Annual Debt Ending Date Balance Principal Interest Fee Payment Service Balance Dec 1,2022 1,060.750.00 3,512.43 501.78 4,014.21 1,060,750.00 Jun 1,2023 3,147,250.00 144,000.00 21,824.71 3.117.82 168,942.53 172,956.74 3,003,250.00 Dec 1,2023 3,356,000.00 29,799.17 4,257.02 34,056.19 3,356,000.00 Jun 1,2024 3,356,000.00 147,000.00 29,365.00 4,195.00 _ 180,560.00 214,616.19 3,209,000.00 Dec 1,2024 3,209,000.00 28,078.75 4,011.25 32,090.00 3,209,000.00 Jun 1,2025 3,209,000.00 _ 150,000.00 28,078.75 4,011.25 182,090.00 214,180.00 3,059,000.00 Dec 1,2025 3,059,000.00 26,766.25 3,823.75 30,590.00 3,059,000.00 Jun 1,2026 3,059,000.00 153,000.00 26,766.25 3,823.75 183,590.00 214,180,00 2,906,000.00 Dec 1,2026 2,906,000.00 25,427.50 3,632.50 29,060.00 2,906,000.00 Jun 1,2027 2,906,000.00 156,000.00 25,427.50 3,632.50 185,060.00 214,120.00 2,750,000.00 Dec 1,2027 2,750,000.00 24,062.50 3,437.50 27,500.00 2,750,000.00 Jun 1,2028 2,750,000.00 _159,000.00 24,062.50 3,437,50 186,500.00 214,000.00 2,591,000.00 Dec 1,2028 2,591,000.00 22,671.25 3,238.75 25,910.00 2,591,000.00 Jun 1,2029 2,591,000.00 162,000.00 22,671.25 3,238.75 187,910.00 213,820.00 2,429,000.00 Dec 1,2029 2,429,000.00 21,253.75 3,036.25 24,290.00 2,429,000.00 Jun 1,2030 2,429,000.00 165,000.00 21,253.75 3,036.25 189,290.00 213,580.00 2,264,000.00 Dec 1,2030 2,264,000.00 19,810.00 2,830.00 22,640.00 2,264,000.00 Jun 1,2031 2,264,000.00 169,000.00 19,810.00 2,830.00 191,640.00 214,280.00 2,095,000.00 Dec 1,2031 2,095.000.00 18,331.25 2,618.75 20,950.00 2,095,000.00 Jun 1,2032 2,095,000.00 172,000.00 18,331.25 2,618.75 192,950,00 213,900.00 1,923,000.00 Dec 1,2032 1,923,000.00 16,826.25 2,403.75 19,230.00 1,923,000.00 Jun 1,2033 1,923,000.00 175,000.00 16,826.25 2,403.75 194,230.00 213,460.00 1,748,000.00 Dec 1,2033 1,748.000.00 15,295.00 2,185.00 17,480.00 1,748,000.00 Jun 1,2034 1,748,000.00 179,000.00 15,295.00 2,185.00 196,480.00 213,960.00 1,569,000.00 Dec 1,2034 1,569,000.00 13,728.75 1,961.25 15,690.00 1,569,000.00 Jun 1,2035 1,569,000.00 183,000.00 13,728.75 1,961.25 198,690.00 214,380.00 1,386,000.00 Dec 1,2035 1,386,000.00 12,127.50 1.732.50 13,860.00 1,386,000.00 Jun 1,2036 1,386,000.00 186,000.00 12,127.50 1,732.50 199,860.00 213,720.00 1,200,000.00 Dec 1,2036 1,200,000.00 10,500.00 1,500.00 12,000.00 1,200,000.00 _Jun 1,2037 1,200,000.00 190,000.00 10,500.00 1,500.00 202,000.00 214,000.00 1,010,000.00 Dec 1,2037 1,010,000.00 8,837.50 1,262.50 10,100.00 1,010,000.00 _Jun 1,2038 1,010,000.00 194,000.00 8,837.50 _ 1,262.50 204,100.00 214,200.00 816,000.00 Dec 1,2038 816,000.00 7,140.00 1,020.00 8,160.00 816,000.00 Jun 1,2039 816,000.00 _198,000.00 7,140.00 1,02_0.00 206,160.00 214,320.00 618,000.00 Dec 1,2039 618,000.00 5,407.50 772.50 6,180.00 618,000.00 Jun 1,2040 618,000.00 202,000.00 5,407.50 772.50 208,180.00 214,360.00 416.000.00 Dec 1,2040 416,000.00 3,640.00 520.00 4,160.00 416,000.00 Jun 1,2041 416,000.00 206,000.00 3,640.00 520.00_ _210,160.00 214,320.00 210.000.00 Dec 1,2041 210,000.00 1,837.50 262.50 2,100.00 210,000.00 Jun 1,2042 210,000.00 210,000.00 1,837.50 262.50 212,100.00 214,200.00 0.00 As of 8/1/2022 INVESTING IN IOWA'S WATER www.iowasrf.com Ce t�o IA4