Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2023-03-20 I01H WRA Senior Bond Issuance Certificate
AGENDA ITEM: CITY OF WAUKEE, IOWA CITY COUNCIL MEETING COMMUNICATION MEETING DATE: March 20, 2023 AGENDA ITEM:Consideration of approval of a resolution approving Senior Bond Issuance Certificate of WRA Participating Community FORMAT:Consent Agenda SYNOPSIS INCLUDING PRO & CON: The WRA intends to issue debt in the amount of $94,250,000 over the next two calendar years, 2023 and 2024. WRA board is asking for participating communities to have Council approval of this certificate. FISCAL IMPACT INCLUDING COST/BENEFIT ANALYSIS: COMMISSION/BOARD/COMMITTEE COMMENT: STAFF REVIEW AND COMMENT: City staff recommends approval of the attached resolution and directs the Finance Director to execute and return the Senior Bond Issuance Certificate. RECOMMENDATION: Approve the resolution. ATTACHMENTS: I. Proposed Resolution II. Senior Bond Issuance Certificate III. PFM Memo and Project Listing PREPARED BY:Linda Burkhart REVIEWED BY: I1H THE CITY OF WAUKEE, IOWA RESOLUTION 2023- APPROVING SENIOR BOND ISSUANCE CERTIFICATE OF WRA PARTICIPATING COMMUNITY IN THE NAME AND BY THE AUTHORITY OF THE CITY OF WAUKEE, IOWA WHEREAS, the City of Waukee, Dallas County, State of Iowa, is a duly organized Municipal Organization; AND, WHEREAS, the City of Waukee is a member of the Des Moines Metropolitan Wastewater Reclamation Authority (WRA) and is in compliance with the provisions of the WRA Agreement; AND, WHEREAS, the WRA requires the assistance of participating communities to approve a Senior Bond Issuance Certificate for anticipated additional senior bonds in the amount of $94,250,000.00. THEREFORE BE IT RESOLVED by the Waukee City Council on this 20th day of March, 2023, that it hereby approves the attached Senior Bond Issuance Certificate of WRA Participating Community for the anticipated additional senior bonds of the WRA in the amount of $94,250,000.00 and authorizes the City of Waukee Finance Director to execute and return the Certificate to the Des Moines Metropolitan Wastewater Reclamation Authority. ____________________________ Courtney Clarke, Mayor Attest: ___________________________________ Rebecca D. Schuett, City Clerk RESULTS OF VOTE: AYE NAY ABSENT ABSTAIN Anna Bergman Pierce R. Charles Bottenberg Chris Crone Larry R. Lyon Ben Sinclair SENIOR BOND ISSUANCE CERTIFICATE OF WRA PARTICIPATING COMMUNITY Name of Participating Community: City of Waukee, Iowa Anticipated Amount of Additional Senior Bonds: $ 94,250,000 Estimated Date of Issuance: $70,100,000 after May 1st in calendar 2023; Remaining amounts will be issued after January 1, 2024 This Senior Bond Issuance Certificate is being executed by the undersigned financial officer of the Participating Community indicated above (the “Participating Community”) pursuant to Section 8.3 of Resolution No. 04-070 approved on October 28, 2004 (the “Master Resolution”) by the Board of the Des Moines Metropolitan Wastewater Reclamation Authority (“WRA”), and supplementing Section 2 of Article XIII of the Second Amended and Restated Agreement for the WRA, filed with the Secretary of State on June 11, 2014 (the WRA Agreement). All capitalized terms used in this Certificate which are not otherwise defined herein shall have the meanings given to them in the Master Resolution. Attached hereto are the following: • WRA Certificate Memo & Instructions, • City of Altoona WRA Debt Service Allocation, 2023 Certificates: PFM’s proposed allocation of Debt Service to the Participating Community for the Additional Senior Bonds (subject to change based on actual timing of issuance by WRA), receipt of which is acknowledged by execution of this Certificate. • WRA Cash Contribution Process The Participating Community hereby consents to and certifies, in connection with the anticipated issuance of the above-referenced Senior Bonds, that it is currently in compliance with the provisions of the WRA Agreement requiring the establishment of rates and charges or appropriation of other funds sufficient in amount as will produce at least 110% of the amount necessary to pay the Participating Community’s share of the principal and interest coming due on all Outstanding Bonds and all outstanding Local Obligations during the fiscal year 2024, and acknowledges it has factored its estimated allocations from future WRA issuances of Additional Senior Bonds into rate and coverage planning to ensure maintenance of said coverage in future fiscal years. Attach to this Certificate for return the following: 1. A copy of the resolution passed by your governing body approving the Senior Bond Issuance Certificate of WRA Participating Community, 2. Schedule of principal and interest requirements of all outstanding Local Obligations of the Participating Community, 3. Details of other funds appropriated to meet the coverage requirements. Approved by the Governing Body of the Participating Community on the ___ day of _________, 2023. Dated this ____ day of ______ 2023. By: _________________________ Print Name: ____________________ Title: ________________________ CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates 123456789 Payment SRF 2008A ($16.52M) SWD SRF 2008B ($6.575M) EXP SRF 2008D ($2.65M) EXP Date Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt 12/01/22 - 3,658 - - 2,311 - - 891 - 06/01/23 19,214 23,917 27,575 12,124 15,096 17,407 4,978 6,124 7,014 12/01/23 - 3,699 - - 2,279 - - 876 - 06/01/24 20,952 25,708 29,407 12,895 15,826 18,105 5,267 6,393 7,268 12/01/24 - 3,515 - - 2,167 - - 830 - 06/01/25 21,617 26,137 29,652 13,319 16,104 18,271 5,449 6,515 7,345 12/01/25 - 3,326 - - 2,050 - - 782 - 06/01/26 22,242 26,519 29,845 13,682 16,318 18,368 5,630 6,635 7,417 12/01/26 - 3,132 - - 1,930 - - 733 - 06/01/27 22,907 26,933 30,065 14,106 16,588 18,518 5,812 6,754 7,486 12/01/27 - 2,931 - - 1,807 - - 682 - 06/01/28 23,610 27,379 30,310 14,530 16,853 18,660 5,993 6,870 7,552 12/01/28 - 2,725 - - 1,680 - - 629 - 06/01/29 24,314 27,817 30,542 14,953 17,113 18,793 6,236 7,045 7,674 12/01/29 - 2,512 - - 1,549 - - 575 - 06/01/30 25,018 28,247 30,759 15,438 17,429 18,978 6,417 7,156 7,731 12/01/30 - 2,293 - - 1,414 - - 519 - 06/01/31 25,799 28,748 31,041 15,922 17,740 19,154 6,599 7,266 7,784 12/01/31 - 2,067 - - 1,275 - - 461 - 06/01/32 26,581 29,239 31,306 16,346 17,984 19,259 6,841 7,434 7,894 12/01/32 - 1,835 - - 1,131 - - 401 - 06/01/33 27,363 29,722 31,557 16,891 18,345 19,477 7,023 7,538 7,939 12/01/33 - 1,595 - - 984 - - 340 - 06/01/34 28,184 30,235 31,830 17,375 18,640 19,623 7,265 7,701 8,041 12/01/34 - 1,349 - - 832 - - 276 - 06/01/35 29,044 30,778 32,127 17,920 18,989 19,821 7,507 7,862 8,138 12/01/35 - 1,095 - - 675 - - 210 - 06/01/36 29,904 31,311 32,406 18,404 19,272 19,947 7,749 8,020 8,230 12/01/36 - 833 - - 514 - - 142 - 06/01/37 30,803 31,874 32,707 19,010 19,670 20,184 7,991 8,174 8,317 12/01/37 - 563 - - 347 - - 73 - 06/01/38 31,702 32,426 32,990 19,554 20,001 20,349 8,294 8,387 8,460 12/01/38 - 286 - - 176 - - - - 06/01/39 32,679 33,047 33,333 20,160 20,387 20,563 - - - 12/01/39 - - - - - - - - - 06/01/40 - - - - - - - - - 12/01/40 - - - - - - - - - 06/01/41 - - - - - - - - - 12/01/41 - - - - - - - - - 06/01/42 - - - - - - - - - 12/01/42 - - - - - - - - - 06/01/43 - - - - - - - - - 12/01/43 - - - - - - - - - 06/01/44 - - - - - - - - - 12/01/44 - - - - - - - - - 06/01/45 - - - - - - - - - 12/01/45 - - - - - - - - - 06/01/46 - - - - - - - - - 12/01/46 - - - - - - - - - 06/01/47 - - - - - - - - - 12/01/47 - - - - - - - - - 06/01/48 - - - - - - - - - 12/01/48 - - - - - - - - - 06/01/49 - - - - - - - - - 12/01/49 - - - - - - - - - 06/01/50 - - - - - - - - - 12/01/50 - - - - - - - - - 06/01/51 - - - - - - - - - 12/01/51 - - - - - - - - - 06/01/52 - - - - - - - - - 12/01/52 - - - - - - - - - 06/01/53 - - - - - - - - - 12/01/53 - - - - - - - - - 06/01/54 - - - - - - - - - 12/01/54 - - - - - - - - - 06/01/55 - - - - - - - - - Total as of: 5/1/2023 441,934$ 523,792$ 527,450$ 272,628$ 323,164$ 325,476$ 105,051$ 123,401$ 124,291$ Prepared by PFM Financial Advisors LLC Page 1 of 19 Date:3/7/2023 CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates Payment Date 12/01/22 06/01/23 12/01/23 06/01/24 12/01/24 06/01/25 12/01/25 06/01/26 12/01/26 06/01/27 12/01/27 06/01/28 12/01/28 06/01/29 12/01/29 06/01/30 12/01/30 06/01/31 12/01/31 06/01/32 12/01/32 06/01/33 12/01/33 06/01/34 12/01/34 06/01/35 12/01/35 06/01/36 12/01/36 06/01/37 12/01/37 06/01/38 12/01/38 06/01/39 12/01/39 06/01/40 12/01/40 06/01/41 12/01/41 06/01/42 12/01/42 06/01/43 12/01/43 06/01/44 12/01/44 06/01/45 12/01/45 06/01/46 12/01/46 06/01/47 12/01/47 06/01/48 12/01/48 06/01/49 12/01/49 06/01/50 12/01/50 06/01/51 12/01/51 06/01/52 12/01/52 06/01/53 12/01/53 06/01/54 12/01/54 06/01/55 Total as of: 5/1/2023 10 11 12 13 14 15 16 17 18 SRF 2009B ($8.4M) EXP SRF 2009C ($9.2M) EXP SRF 2010A ($8.5M) SWD Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt - 2,987 - - 3,271 - - 1,986 - 15,345 19,185 22,172 16,810 21,015 24,285 9,478 12,031 14,017 - 2,948 - - 3,229 - - 2,017 - 16,406 20,197 23,146 17,980 22,132 25,360 10,359 12,952 14,969 - 2,805 - - 3,071 - - 1,926 - 16,891 20,497 23,302 18,525 22,474 25,545 10,711 13,187 15,114 - 2,657 - - 2,909 - - 1,833 - 17,496 20,912 23,569 19,131 22,871 25,780 11,062 13,419 15,251 - 2,504 - - 2,742 - - 1,736 - 18,041 21,260 23,764 19,736 23,261 26,003 11,414 13,646 15,382 - 2,346 - - 2,569 - - 1,636 - 18,646 21,663 24,009 20,402 23,705 26,274 11,805 13,909 15,545 - 2,183 - - 2,391 - - 1,533 - 19,252 22,058 24,241 21,068 24,142 26,532 12,157 14,128 15,660 - 2,015 - - 2,206 - - 1,426 - 19,857 22,447 24,462 21,734 24,571 26,777 12,548 14,382 15,808 - 1,841 - - 2,016 - - 1,317 - 20,523 22,890 24,731 22,460 25,053 27,069 12,978 14,671 15,987 - 1,661 - - 1,820 - - 1,203 - 21,189 23,325 24,986 23,187 25,526 27,346 13,408 14,955 16,157 - 1,476 - - 1,617 - - 1,086 - 21,855 23,752 25,228 23,913 25,992 27,609 13,838 15,234 16,319 - 1,285 - - 1,407 - - 965 - 22,581 24,233 25,518 24,700 26,510 27,917 14,268 15,508 16,473 - 1,087 - - 1,191 - - 840 - 23,308 24,705 25,792 25,548 27,080 28,271 14,737 15,817 16,656 - 883 - - 968 - - 711 - 24,034 25,170 26,053 26,335 27,579 28,547 15,206 16,120 16,831 - 673 - - 737 - - 578 - 24,821 25,686 26,359 27,182 28,131 28,868 15,714 16,457 17,035 - 456 - - 500 - - 440 - 25,608 26,194 26,650 28,091 28,733 29,232 16,222 16,788 17,229 - 231 - - 254 - - 298 - 26,456 26,754 26,985 28,999 29,325 29,579 16,770 17,153 17,451 - - - - - - - 152 - - - - - - - 17,317 17,512 17,663 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 352,311$ 417,981$ 420,967$ 385,801$ 457,725$ 460,996$ 239,992$ 287,561$ 289,547$ Prepared by PFM Financial Advisors LLC Page 2 of 19 Date:3/7/2023 CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates Payment Date 12/01/22 06/01/23 12/01/23 06/01/24 12/01/24 06/01/25 12/01/25 06/01/26 12/01/26 06/01/27 12/01/27 06/01/28 12/01/28 06/01/29 12/01/29 06/01/30 12/01/30 06/01/31 12/01/31 06/01/32 12/01/32 06/01/33 12/01/33 06/01/34 12/01/34 06/01/35 12/01/35 06/01/36 12/01/36 06/01/37 12/01/37 06/01/38 12/01/38 06/01/39 12/01/39 06/01/40 12/01/40 06/01/41 12/01/41 06/01/42 12/01/42 06/01/43 12/01/43 06/01/44 12/01/44 06/01/45 12/01/45 06/01/46 12/01/46 06/01/47 12/01/47 06/01/48 12/01/48 06/01/49 12/01/49 06/01/50 12/01/50 06/01/51 12/01/51 06/01/52 12/01/52 06/01/53 12/01/53 06/01/54 12/01/54 06/01/55 Total as of: 5/1/2023 19 20 21 22 23 24 25 26 27 SRF 2010B ($7.0M) EXP SRF 2010-C1 ($2.0M) CORE SRF 2010-C2 ($21.5M) CORE Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt - 2,597 - - 453 - - 2,741 - 12,417 15,756 18,352 26 609 1,062 27,003 30,527 33,268 - 2,572 - - 494 - - 2,729 - 13,198 16,504 19,076 28 663 1,157 30,384 33,893 36,621 - 2,456 - - 493 - - 2,463 - 13,682 16,840 19,297 28 663 1,156 31,377 34,544 37,006 - 2,337 - - 493 - - 2,188 - 14,106 17,110 19,447 28 663 1,156 32,399 35,212 37,400 - 2,213 - - 493 - - 1,905 - 14,530 17,375 19,588 28 662 1,155 33,448 35,897 37,802 - 2,086 - - 493 - - 1,612 - 15,014 17,696 19,782 28 662 1,155 34,526 36,599 38,211 - 1,955 - - 493 - - 1,310 - 15,498 18,011 19,966 28 662 1,154 35,661 37,345 38,655 - 1,819 - - 492 - - 998 - 16,043 18,382 20,201 28 661 1,154 36,796 38,079 39,077 - 1,679 - - 492 - - 676 - 16,527 18,686 20,364 11,859 12,491 12,983 38,016 38,885 39,561 - 1,534 - - 388 - - 343 - 17,072 19,045 20,579 44,371 44,870 45,258 39,236 39,677 40,020 - 1,385 - - - - - - - 17,617 19,397 20,782 - - - - - - - 1,231 - - - - - - - 18,223 19,805 21,035 - - - - - - - 1,071 - - - - - - - 18,828 20,205 21,276 - - - - - - - 906 - - - - - - - 19,433 20,599 21,505 - - - - - - - 736 - - - - - - - 20,039 20,985 21,722 - - - - - - - 561 - - - - - - - 20,705 21,426 21,987 - - - - - - - 380 - - - - - - - 21,371 21,859 22,239 - - - - - - - 193 - - - - - - - 22,037 22,284 22,477 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 306,339$ 367,079$ 369,676$ 56,454$ 66,937$ 67,390$ 338,847$ 374,881$ 377,622$ Prepared by PFM Financial Advisors LLC Page 3 of 19 Date:3/7/2023 CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates Payment Date 12/01/22 06/01/23 12/01/23 06/01/24 12/01/24 06/01/25 12/01/25 06/01/26 12/01/26 06/01/27 12/01/27 06/01/28 12/01/28 06/01/29 12/01/29 06/01/30 12/01/30 06/01/31 12/01/31 06/01/32 12/01/32 06/01/33 12/01/33 06/01/34 12/01/34 06/01/35 12/01/35 06/01/36 12/01/36 06/01/37 12/01/37 06/01/38 12/01/38 06/01/39 12/01/39 06/01/40 12/01/40 06/01/41 12/01/41 06/01/42 12/01/42 06/01/43 12/01/43 06/01/44 12/01/44 06/01/45 12/01/45 06/01/46 12/01/46 06/01/47 12/01/47 06/01/48 12/01/48 06/01/49 12/01/49 06/01/50 12/01/50 06/01/51 12/01/51 06/01/52 12/01/52 06/01/53 12/01/53 06/01/54 12/01/54 06/01/55 Total as of: 5/1/2023 28 29 30 31 32 33 34 35 36 SRF 2011A ($60.0M) CORE SRF 2011B ($16.0M) EXP SRF 2011C ($9.6M) SWD Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt - 10,687 - - 6,126 - - 2,334 - 44,320 58,061 68,748 27,235 35,112 41,238 10,363 13,364 15,698 - 11,221 - - 6,086 - - 2,378 - 49,846 64,273 75,494 29,059 36,884 42,970 11,336 14,393 16,770 - 10,785 - - 5,832 - - 2,278 - 51,463 65,330 76,114 29,967 37,465 43,297 11,727 14,656 16,935 - 10,335 - - 5,570 - - 2,176 - 53,137 66,424 76,759 30,936 38,097 43,666 12,079 14,876 17,052 - 9,870 - - 5,299 - - 2,070 - 54,868 67,557 77,427 31,965 38,778 44,077 12,470 15,131 17,201 - 9,390 - - 5,019 - - 1,961 - 56,655 68,727 78,117 32,994 39,447 44,467 12,900 15,421 17,382 - 8,894 - - 4,730 - - 1,848 - 58,499 69,934 78,828 34,084 40,166 44,896 13,291 15,667 17,515 - 8,382 - - 4,432 - - 1,732 - 60,400 71,177 79,559 35,174 40,872 45,305 13,760 15,986 17,718 - 7,853 - - 4,124 - - 1,611 - 62,357 72,455 80,308 36,324 41,627 45,751 14,190 16,261 17,873 - 7,308 - - 3,807 - - 1,487 - 64,372 73,767 81,075 37,535 42,429 46,236 14,659 16,571 18,058 - 6,745 - - 3,478 - - 1,359 - 66,471 75,143 81,887 38,746 43,218 46,696 15,128 16,875 18,234 - 6,163 - - 3,139 - - 1,227 - 68,627 76,551 82,714 40,017 44,053 47,192 15,636 17,213 18,440 - 5,563 - - 2,789 - - 1,090 - 70,868 78,020 83,583 41,288 44,874 47,663 16,144 17,545 18,635 - 4,942 - - 2,428 - - 948 - 73,166 79,521 84,463 42,620 45,742 48,169 16,652 17,872 18,820 - 4,302 - - 2,055 - - 803 - 75,549 81,081 85,383 44,013 46,654 48,709 17,200 18,232 19,034 - 3,641 - - 1,670 - - 652 - 77,989 82,671 86,312 45,466 47,612 49,282 17,747 18,585 19,238 - 2,959 - - 1,272 - - 497 - 80,514 84,318 87,277 46,919 48,554 49,826 18,333 18,972 19,469 - 2,254 - - 861 - - 337 - 83,152 86,051 88,305 48,432 49,539 50,401 18,920 19,352 19,689 - 1,527 - - 438 - - 171 - 85,848 87,810 89,337 50,006 50,569 51,006 19,545 19,765 19,936 - 775 - - - - - - - 88,628 89,625 90,400 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 1,326,729$ 1,621,403$ 1,632,090$ 722,779$ 874,720$ 880,847$ 282,078$ 341,362$ 343,696$ Prepared by PFM Financial Advisors LLC Page 4 of 19 Date:3/7/2023 CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates Payment Date 12/01/22 06/01/23 12/01/23 06/01/24 12/01/24 06/01/25 12/01/25 06/01/26 12/01/26 06/01/27 12/01/27 06/01/28 12/01/28 06/01/29 12/01/29 06/01/30 12/01/30 06/01/31 12/01/31 06/01/32 12/01/32 06/01/33 12/01/33 06/01/34 12/01/34 06/01/35 12/01/35 06/01/36 12/01/36 06/01/37 12/01/37 06/01/38 12/01/38 06/01/39 12/01/39 06/01/40 12/01/40 06/01/41 12/01/41 06/01/42 12/01/42 06/01/43 12/01/43 06/01/44 12/01/44 06/01/45 12/01/45 06/01/46 12/01/46 06/01/47 12/01/47 06/01/48 12/01/48 06/01/49 12/01/49 06/01/50 12/01/50 06/01/51 12/01/51 06/01/52 12/01/52 06/01/53 12/01/53 06/01/54 12/01/54 06/01/55 Total as of: 5/1/2023 37 38 39 40 41 42 43 44 45 SRF 2011D ($14.4M) SWD SRF 2012B ($2.772M) EXP SRF 2012C $18.0M) CORE Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt - 5,440 - - 1,110 - - 5,689 - 16,485 23,063 28,503 4,627 6,054 7,164 13,228 17,495 23,184 - 5,557 - - 1,106 - - 3,489 - 17,942 24,662 30,219 4,904 6,325 7,431 14,838 19,324 22,813 - 5,343 - - 1,063 - - 3,360 - 18,411 24,872 30,214 5,085 6,452 7,514 15,291 19,611 22,971 - 5,122 - - 1,018 - - 3,226 - 18,880 25,075 30,197 5,267 6,576 7,594 15,745 19,893 23,119 - 4,897 - - 972 - - 3,088 - 19,389 25,310 30,207 5,388 6,638 7,610 16,228 20,198 23,286 - 4,665 - - 925 - - 2,946 - 19,897 25,538 30,203 5,570 6,759 7,684 16,710 20,498 23,444 - 4,427 - - 876 - - 2,800 - 20,444 25,798 30,225 5,751 6,878 7,754 17,192 20,792 23,592 - 4,183 - - 826 - - 2,649 - 20,991 26,050 30,233 5,933 6,995 7,821 17,731 21,138 23,787 - 3,932 - - 774 - - 2,494 - 21,539 26,294 30,226 6,175 7,170 7,944 18,242 21,449 23,943 - 3,675 - - 720 - - 2,335 - 22,086 26,530 30,204 6,357 7,282 8,002 18,809 21,811 24,146 - 3,411 - - 664 - - 2,170 - 22,672 26,797 30,208 6,538 7,392 8,057 19,377 22,167 24,337 - 3,140 - - 607 - - 2,001 - 23,298 27,095 30,235 6,780 7,561 8,168 19,944 22,516 24,517 - 2,862 - - 548 - - 1,826 - 23,923 27,383 30,245 6,962 7,666 8,214 20,540 22,888 24,714 - 2,576 - - 487 - - 1,646 - 24,549 27,663 30,239 7,204 7,830 8,317 21,164 23,281 24,927 - 2,282 - - 424 - - 1,461 - 25,174 27,934 30,216 7,446 7,991 8,415 21,788 23,667 25,128 - 1,982 - - 359 - - 1,270 - 25,878 28,274 30,255 7,689 8,150 8,508 22,441 24,074 25,345 - 1,672 - - 291 - - 1,074 - 26,542 28,564 30,237 7,931 8,305 8,597 23,122 24,503 25,577 - 1,355 - - 222 - - 872 - 27,246 28,884 30,239 8,173 8,458 8,680 23,802 24,923 25,795 - 1,030 - - 150 - - 664 - 27,988 29,233 30,263 8,476 8,669 8,819 24,540 25,393 26,057 - 695 - - 76 - - 449 - 28,692 29,533 30,228 8,718 8,816 8,892 25,278 25,855 26,304 - 352 - - - - - 228 - 29,474 29,900 30,252 - - - 26,015 26,308 26,536 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 481,500$ 627,607$ 633,047$ 130,974$ 160,075$ 161,185$ 412,025$ 507,830$ 513,519$ Prepared by PFM Financial Advisors LLC Page 5 of 19 Date:3/7/2023 CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates Payment Date 12/01/22 06/01/23 12/01/23 06/01/24 12/01/24 06/01/25 12/01/25 06/01/26 12/01/26 06/01/27 12/01/27 06/01/28 12/01/28 06/01/29 12/01/29 06/01/30 12/01/30 06/01/31 12/01/31 06/01/32 12/01/32 06/01/33 12/01/33 06/01/34 12/01/34 06/01/35 12/01/35 06/01/36 12/01/36 06/01/37 12/01/37 06/01/38 12/01/38 06/01/39 12/01/39 06/01/40 12/01/40 06/01/41 12/01/41 06/01/42 12/01/42 06/01/43 12/01/43 06/01/44 12/01/44 06/01/45 12/01/45 06/01/46 12/01/46 06/01/47 12/01/47 06/01/48 12/01/48 06/01/49 12/01/49 06/01/50 12/01/50 06/01/51 12/01/51 06/01/52 12/01/52 06/01/53 12/01/53 06/01/54 12/01/54 06/01/55 Total as of: 5/1/2023 46 47 48 49 50 51 52 53 54 SRF 2012D ($7.0M) CORE SRF 2012E ($12.3M) EXP SRF 2012F ($1.42M) EXP Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt - 2,137 - - 8,680 - - 1,006 - 5,182 6,785 8,922 20,207 28,887 37,567 2,343 3,349 4,355 - 1,309 - - 8,659 - - 1,003 - 5,816 7,498 8,807 21,492 30,150 38,809 2,482 3,486 4,489 - 1,258 - - 8,336 - - 966 - 6,014 7,632 8,889 22,158 30,494 38,830 2,543 3,509 4,475 - 1,205 - - 8,004 - - 928 - 6,185 7,734 8,939 22,763 30,767 38,771 2,664 3,592 4,520 - 1,151 - - 7,663 - - 888 - 6,412 7,892 9,043 23,490 31,152 38,815 2,724 3,612 4,501 - 1,095 - - 7,310 - - 847 - 6,610 8,018 9,113 24,155 31,466 38,776 2,785 3,632 4,479 - 1,037 - - 6,948 - - 805 - 6,809 8,142 9,179 24,882 31,830 38,778 2,906 3,711 4,517 - 978 - - 6,575 - - 762 - 7,036 8,293 9,270 25,669 32,244 38,818 2,966 3,728 4,490 - 916 - - 6,190 - - 717 - 7,263 8,440 9,356 26,395 32,585 38,775 3,088 3,805 4,522 - 852 - - 5,794 - - 671 - 7,518 8,614 9,467 27,243 33,037 38,830 3,148 3,819 4,490 - 787 - - 5,385 - - 624 - 7,745 8,756 9,543 28,030 33,415 38,800 3,269 3,893 4,517 - 719 - - 4,965 - - 575 - 8,000 8,925 9,644 28,878 33,842 38,807 3,330 3,905 4,479 - 649 - - 4,531 - - 525 - 8,256 9,090 9,739 29,725 34,257 38,788 3,451 3,976 4,501 - 577 - - 4,086 - - 473 - 8,539 9,281 9,857 30,633 34,719 38,804 3,572 4,045 4,518 - 502 - - 3,626 - - 420 - 8,823 9,468 9,970 31,541 35,167 38,793 3,632 4,052 4,471 - 425 - - 3,153 - - 365 - 9,107 9,653 10,078 32,510 35,663 38,816 3,753 4,119 4,484 - 345 - - 2,665 - - 309 - 9,390 9,834 10,179 33,479 36,144 38,809 3,875 4,183 4,492 - 263 - - 2,163 - - 251 - 9,703 10,041 10,303 34,447 36,610 38,773 3,996 4,246 4,497 - 178 - - 1,646 - - 191 - 10,015 10,243 10,421 35,537 37,183 38,830 4,117 4,307 4,498 - 90 - - 1,113 - - 129 - 10,327 10,443 10,533 36,566 37,679 38,793 4,238 4,367 4,496 - - - - 565 - - 65 - - - - 37,656 38,221 38,786 4,359 4,424 4,490 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 154,749$ 189,117$ 191,254$ 597,456$ 804,888$ 813,568$ 69,240$ 93,275$ 94,281$ Prepared by PFM Financial Advisors LLC Page 6 of 19 Date:3/7/2023 CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates Payment Date 12/01/22 06/01/23 12/01/23 06/01/24 12/01/24 06/01/25 12/01/25 06/01/26 12/01/26 06/01/27 12/01/27 06/01/28 12/01/28 06/01/29 12/01/29 06/01/30 12/01/30 06/01/31 12/01/31 06/01/32 12/01/32 06/01/33 12/01/33 06/01/34 12/01/34 06/01/35 12/01/35 06/01/36 12/01/36 06/01/37 12/01/37 06/01/38 12/01/38 06/01/39 12/01/39 06/01/40 12/01/40 06/01/41 12/01/41 06/01/42 12/01/42 06/01/43 12/01/43 06/01/44 12/01/44 06/01/45 12/01/45 06/01/46 12/01/46 06/01/47 12/01/47 06/01/48 12/01/48 06/01/49 12/01/49 06/01/50 12/01/50 06/01/51 12/01/51 06/01/52 12/01/52 06/01/53 12/01/53 06/01/54 12/01/54 06/01/55 Total as of: 5/1/2023 55 56 57 58 59 60 61 62 63 SRF 2012G 9$24.4M) SWD SRF 2013A ($7.7M) CORE 2014A ($1.8M) CORE Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt - 8,255 - - 2,439 - - 303 - 25,779 34,034 42,288 5,677 8,116 10,555 2,265 2,569 2,872 - 8,439 - - 2,564 - - 306 - 27,988 36,428 44,867 6,355 8,919 11,484 2,497 2,802 3,108 - 8,121 - - 2,469 - - 281 - 28,614 36,735 44,857 6,553 9,023 11,492 2,553 2,834 3,115 - 7,797 - - 2,371 - - 255 - 29,278 37,075 44,872 6,752 9,123 11,494 2,610 2,865 3,121 - 7,464 - - 2,269 - - 229 - 29,943 37,407 44,872 6,951 9,220 11,490 2,667 2,896 3,125 - 7,124 - - 2,165 - - 203 - 30,607 37,732 44,856 7,149 9,314 11,480 2,724 2,926 3,129 - 6,777 - - 2,058 - - 175 - 31,311 38,088 44,865 7,376 9,434 11,492 2,780 2,956 3,131 - 6,422 - - 1,947 - - 148 - 32,054 38,476 44,897 7,603 9,550 11,498 2,837 2,985 3,132 - 6,058 - - 1,833 - - 119 - 32,757 38,815 44,873 7,830 9,663 11,497 2,894 3,013 3,132 - 5,686 - - 1,716 - - 90 - 33,539 39,225 44,911 8,057 9,773 11,489 2,950 3,041 3,131 - 5,305 - - 1,595 - - 61 - 34,282 39,587 44,893 8,312 9,907 11,502 3,007 3,068 3,129 - 4,916 - - 1,470 - - 31 - 35,064 39,980 44,896 8,539 10,010 11,480 3,064 3,095 3,125 - 4,518 - - 1,342 - - - - 35,885 40,403 44,921 8,823 10,165 11,507 - - - - 4,111 - - 1,210 - - - - 36,706 40,817 44,928 9,078 10,288 11,498 - - - - 3,694 - - 1,074 - - - - 37,526 41,221 44,915 9,334 10,407 11,481 - - - - 3,269 - - 934 - - - - 38,386 41,655 44,923 9,617 10,551 11,485 - - - - 2,833 - - 789 - - - - 39,285 42,118 44,951 9,901 10,691 11,480 - - - - 2,387 - - 641 - - - - 40,185 42,571 44,958 10,213 10,854 11,495 - - - - 1,931 - - 488 - - - - 41,084 43,014 44,945 10,525 11,013 11,501 - - - - 1,465 - - 330 - - - - 42,061 43,525 44,990 10,837 11,167 11,497 - - - - 987 - - 167 - - - - 42,999 43,986 44,973 11,149 11,317 11,484 - - - - 499 - - - - - - - 43,976 44,475 44,975 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 769,310$ 977,173$ 985,428$ 176,634$ 237,939$ 240,378$ 32,848$ 36,946$ 37,250$ Prepared by PFM Financial Advisors LLC Page 7 of 19 Date:3/7/2023 CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates Payment Date 12/01/22 06/01/23 12/01/23 06/01/24 12/01/24 06/01/25 12/01/25 06/01/26 12/01/26 06/01/27 12/01/27 06/01/28 12/01/28 06/01/29 12/01/29 06/01/30 12/01/30 06/01/31 12/01/31 06/01/32 12/01/32 06/01/33 12/01/33 06/01/34 12/01/34 06/01/35 12/01/35 06/01/36 12/01/36 06/01/37 12/01/37 06/01/38 12/01/38 06/01/39 12/01/39 06/01/40 12/01/40 06/01/41 12/01/41 06/01/42 12/01/42 06/01/43 12/01/43 06/01/44 12/01/44 06/01/45 12/01/45 06/01/46 12/01/46 06/01/47 12/01/47 06/01/48 12/01/48 06/01/49 12/01/49 06/01/50 12/01/50 06/01/51 12/01/51 06/01/52 12/01/52 06/01/53 12/01/53 06/01/54 12/01/54 06/01/55 Total as of: 5/1/2023 64 65 66 67 68 69 70 71 72 2014C ($5.4M) EXP 2014D ($6.0M) SWD 2015A ($9.3M) SWD Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt - 2,133 - - 1,492 - - 1,159 - 15,931 18,064 20,197 11,138 12,630 14,122 16,780 17,939 19,098 - 2,040 - - 1,464 - - 1,139 - 16,770 18,810 20,850 12,040 13,503 14,967 17,942 19,081 20,220 - 1,873 - - 1,343 - - 1,049 - 17,072 18,945 20,817 12,274 13,617 14,961 18,138 19,187 20,237 - 1,702 - - 1,220 - - 959 - 17,436 19,137 20,839 12,509 13,729 14,950 18,333 19,292 20,251 - 1,527 - - 1,095 - - 867 - 17,799 19,326 20,854 12,782 13,878 14,973 18,490 19,357 20,224 - 1,349 - - 967 - - 775 - 18,162 19,511 20,861 13,017 13,984 14,952 18,685 19,460 20,234 - 1,168 - - 837 - - 681 - 18,525 19,693 20,861 13,291 14,128 14,965 18,880 19,562 20,243 - 983 - - 704 - - 587 - 18,888 19,871 20,854 13,525 14,230 14,934 19,076 19,663 20,249 - 794 - - 569 - - 491 - 19,252 20,045 20,839 13,799 14,368 14,937 19,271 19,763 20,254 - 601 - - 431 - - 395 - 19,615 20,216 20,817 14,072 14,504 14,935 19,467 19,862 20,257 - 405 - - 290 - - 298 - 20,039 20,444 20,849 14,385 14,676 14,966 19,623 19,921 20,219 - 205 - - 147 - - 200 - 20,463 20,667 20,872 14,659 14,805 14,952 19,858 20,057 20,257 - - - - - - - 100 - - - - - - - 20,053 20,153 20,254 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 219,951$ 247,376$ 249,509$ 157,491$ 177,121$ 178,613$ 244,597$ 260,836$ 261,995$ Prepared by PFM Financial Advisors LLC Page 8 of 19 Date:3/7/2023 CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates Payment Date 12/01/22 06/01/23 12/01/23 06/01/24 12/01/24 06/01/25 12/01/25 06/01/26 12/01/26 06/01/27 12/01/27 06/01/28 12/01/28 06/01/29 12/01/29 06/01/30 12/01/30 06/01/31 12/01/31 06/01/32 12/01/32 06/01/33 12/01/33 06/01/34 12/01/34 06/01/35 12/01/35 06/01/36 12/01/36 06/01/37 12/01/37 06/01/38 12/01/38 06/01/39 12/01/39 06/01/40 12/01/40 06/01/41 12/01/41 06/01/42 12/01/42 06/01/43 12/01/43 06/01/44 12/01/44 06/01/45 12/01/45 06/01/46 12/01/46 06/01/47 12/01/47 06/01/48 12/01/48 06/01/49 12/01/49 06/01/50 12/01/50 06/01/51 12/01/51 06/01/52 12/01/52 06/01/53 12/01/53 06/01/54 12/01/54 06/01/55 Total as of: 5/1/2023 73 74 75 76 77 78 79 80 81 2015B ($0.37M) CORE 2015C ($1.6M) EXP Series 2015E Refunding Bonds ($32.02M) Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt - 62 - - 347 - - 15,776 - 469 531 594 5,037 5,384 5,732 58,768 74,544 90,321 - - - - 333 - - 15,918 - - - - 5,267 5,600 5,933 63,192 79,109 95,027 - - - - 307 - - 14,970 - - - - 5,328 5,634 5,941 65,313 80,283 95,252 - - - - 280 - - 13,990 - - - - 5,328 5,608 5,888 67,277 81,267 95,257 - - - - 253 - - 12,981 - - - - 5,388 5,641 5,895 69,187 82,167 95,148 - - - - 226 - - 11,943 - - - - 5,449 5,675 5,901 71,367 83,310 95,253 - - - - 199 - - 10,873 - - - - 5,509 5,708 5,907 73,279 84,151 95,024 - - - - 172 - - 9,773 - - - - 5,570 5,741 5,913 75,655 85,428 95,202 - - - - 144 - - 8,591 - - - - 5,630 5,774 5,918 77,787 86,378 94,970 - - - - 116 - - 7,327 - - - - 5,691 5,806 5,922 80,607 87,934 95,261 - - - - 87 - - 6,017 - - - - 5,751 5,838 5,926 83,398 89,415 95,432 - - - - 58 - - 4,610 - - - - 5,812 5,870 5,929 85,759 90,369 94,979 - - - - 29 - - 3,163 - - - - 5,872 5,902 5,931 88,749 91,912 95,075 - - - - - - - 1,610 - - - - - - - 91,985 93,595 95,204 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 469$ 531$ 594$ 71,631$ 76,387$ 76,735$ 1,052,321$ 1,311,628$ 1,327,405$ Prepared by PFM Financial Advisors LLC Page 9 of 19 Date:3/7/2023 CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates Payment Date 12/01/22 06/01/23 12/01/23 06/01/24 12/01/24 06/01/25 12/01/25 06/01/26 12/01/26 06/01/27 12/01/27 06/01/28 12/01/28 06/01/29 12/01/29 06/01/30 12/01/30 06/01/31 12/01/31 06/01/32 12/01/32 06/01/33 12/01/33 06/01/34 12/01/34 06/01/35 12/01/35 06/01/36 12/01/36 06/01/37 12/01/37 06/01/38 12/01/38 06/01/39 12/01/39 06/01/40 12/01/40 06/01/41 12/01/41 06/01/42 12/01/42 06/01/43 12/01/43 06/01/44 12/01/44 06/01/45 12/01/45 06/01/46 12/01/46 06/01/47 12/01/47 06/01/48 12/01/48 06/01/49 12/01/49 06/01/50 12/01/50 06/01/51 12/01/51 06/01/52 12/01/52 06/01/53 12/01/53 06/01/54 12/01/54 06/01/55 Total as of: 5/1/2023 82 83 84 85 86 87 88 89 90 Series 2016A ($8.0M) CORE Series 2016E ($0.66M) EXP Series 2016F ($31.4M) CORE Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt - 1,426 - - 275 - - 11,186 - 9,713 11,139 12,565 1,699 1,973 2,248 19,338 30,524 41,710 - 1,448 - - 266 - - 11,871 - 10,781 12,228 13,676 1,816 2,083 2,349 21,714 33,585 45,456 - 1,340 - - 248 - - 11,545 - 11,008 12,347 13,687 1,877 2,125 2,373 22,360 33,905 45,450 - 1,230 - - 229 - - 11,210 - 11,235 12,464 13,694 1,877 2,106 2,336 23,028 34,238 45,448 - 1,117 - - 211 - - 10,865 - 11,461 12,579 13,696 1,937 2,148 2,359 23,718 34,583 45,447 - 1,003 - - 191 - - 10,509 - 11,688 12,691 13,694 1,937 2,129 2,320 24,431 34,939 45,448 - 886 - - 172 - - 10,142 - 11,915 12,801 13,687 1,998 2,170 2,342 25,166 35,308 45,450 - 767 - - 152 - - 9,765 - 12,142 12,909 13,676 2,058 2,210 2,362 25,923 35,688 45,452 - 645 - - 131 - - 9,376 - 12,398 13,043 13,689 2,058 2,190 2,321 26,702 36,078 45,454 - 521 - - 111 - - 8,975 - 12,653 13,174 13,696 2,119 2,230 2,340 27,504 36,479 45,455 - 395 - - 90 - - 8,563 - 12,908 13,303 13,698 2,179 2,269 2,359 28,328 36,891 45,454 - 266 - - 68 - - 8,138 - 13,164 13,430 13,695 2,240 2,308 2,376 29,174 37,312 45,450 - 134 - - 45 - - 7,700 - 13,419 13,553 13,687 2,240 2,285 2,331 30,043 37,743 45,444 - - - - 23 - - 7,250 - - - - 2,301 2,324 2,347 30,956 38,206 45,455 - - - - - - - 6,785 - - - - - - - 31,869 38,654 45,440 - - - - - - - 6,307 - - - - - - - 32,827 39,134 45,441 - - - - - - - 5,815 - - - - - - - 33,807 39,621 45,436 - - - - - - - 5,308 - - - - - - - 34,831 40,139 45,447 - - - - - - - 4,785 - - - - - - - 35,878 40,663 45,448 - - - - - - - 4,247 - - - - - - - 36,947 41,194 45,441 - - - - - - - 3,693 - - - - - - - 38,060 41,753 45,446 - - - - - - - 3,122 - - - - - - - 39,196 42,318 45,440 - - - - - - - 2,534 - - - - - - - 40,376 42,910 45,445 - - - - - - - 1,929 - - - - - - - 41,601 43,530 45,458 - - - - - - - 1,304 - - - - - - - 42,848 44,153 45,457 - - - - - - - 662 - - - - - - - 44,118 44,780 45,441 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 154,485$ 175,416$ 176,842$ 28,336$ 32,487$ 32,761$ 810,740$ 1,166,728$ 1,177,915$ Prepared by PFM Financial Advisors LLC Page 10 of 19 Date:3/7/2023 CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates Payment Date 12/01/22 06/01/23 12/01/23 06/01/24 12/01/24 06/01/25 12/01/25 06/01/26 12/01/26 06/01/27 12/01/27 06/01/28 12/01/28 06/01/29 12/01/29 06/01/30 12/01/30 06/01/31 12/01/31 06/01/32 12/01/32 06/01/33 12/01/33 06/01/34 12/01/34 06/01/35 12/01/35 06/01/36 12/01/36 06/01/37 12/01/37 06/01/38 12/01/38 06/01/39 12/01/39 06/01/40 12/01/40 06/01/41 12/01/41 06/01/42 12/01/42 06/01/43 12/01/43 06/01/44 12/01/44 06/01/45 12/01/45 06/01/46 12/01/46 06/01/47 12/01/47 06/01/48 12/01/48 06/01/49 12/01/49 06/01/50 12/01/50 06/01/51 12/01/51 06/01/52 12/01/52 06/01/53 12/01/53 06/01/54 12/01/54 06/01/55 Total as of: 5/1/2023 91 92 93 94 95 96 97 98 99 Series 2016F ($8.6M) SPECIAL Series 2017A ($38M) CORE Series 2018A ($4.2M) CORE Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt - - - - 13,946 - - 1,003 - - - - 22,837 36,783 50,730 4,687 5,690 6,693 - - - - 14,821 - - 1,041 - - - - 25,618 40,439 55,260 5,192 6,233 7,275 - - - - 14,437 - - 990 - - - - 26,412 40,849 55,286 5,305 6,295 7,284 - - - - 14,041 - - 936 - - - - 27,178 41,219 55,260 5,419 6,355 7,292 - - - - 13,633 - - 882 - - - - 28,001 41,634 55,267 5,532 6,414 7,297 - - - - 13,213 - - 827 - - - - 28,852 42,065 55,278 5,617 6,444 7,271 - - - - 12,780 - - 771 - - - - 29,703 42,484 55,264 5,731 6,502 7,272 - - - - 12,335 - - 714 - - - - 30,611 42,946 55,280 5,873 6,586 7,300 - - - - 11,875 - - 655 - - - - 31,519 43,394 55,270 5,986 6,641 7,296 - - - - 11,403 - - 595 - - - - 32,455 43,858 55,261 6,100 6,694 7,289 - - - - 10,916 - - 534 - - - - 33,448 44,364 55,280 6,213 6,747 7,281 - - - - 10,414 - - 472 - - - - 34,441 44,855 55,269 6,355 6,827 7,298 - - - - 9,897 - - 408 - - - - 35,491 45,388 55,286 6,468 6,877 7,285 - - - - 9,365 - - 344 - - - - 36,541 45,906 55,271 6,610 6,954 7,297 - - - - 8,817 - - 277 - - - - 37,647 46,464 55,281 6,724 7,001 7,279 - - - - 8,252 - - 210 - - - - 38,753 47,006 55,258 6,866 7,076 7,286 - - - - 7,671 - - 142 - - - - 39,917 47,588 55,259 7,007 7,149 7,291 - - - - 7,072 - - 71 - - - - 41,137 48,209 55,281 7,149 7,221 7,292 - - - - 6,455 - - - - - - - 42,356 48,812 55,267 - - - - - - - 5,820 - - - - - - - 43,633 49,453 55,273 - - - - - - - 5,165 - - - - - - - 44,938 50,103 55,269 - - - - - - - 4,491 - - - - - - - 46,300 50,791 55,282 - - - - - - - 3,797 - - - - - - - 47,690 51,487 55,283 - - - - - - - 3,081 - - - - - - - 49,108 52,190 55,271 - - - - - - - 2,345 - - - - - - - 50,584 52,928 55,273 - - - - - - - 1,586 - - - - - - - 52,087 53,673 55,259 - - - - - - - 805 - - - - - - - 53,648 54,452 55,257 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -$ -$ -$ 1,010,907$ 1,473,828$ 1,487,774$ 108,833$ 129,574$ 130,577$ Prepared by PFM Financial Advisors LLC Page 11 of 19 Date:3/7/2023 CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates Payment Date 12/01/22 06/01/23 12/01/23 06/01/24 12/01/24 06/01/25 12/01/25 06/01/26 12/01/26 06/01/27 12/01/27 06/01/28 12/01/28 06/01/29 12/01/29 06/01/30 12/01/30 06/01/31 12/01/31 06/01/32 12/01/32 06/01/33 12/01/33 06/01/34 12/01/34 06/01/35 12/01/35 06/01/36 12/01/36 06/01/37 12/01/37 06/01/38 12/01/38 06/01/39 12/01/39 06/01/40 12/01/40 06/01/41 12/01/41 06/01/42 12/01/42 06/01/43 12/01/43 06/01/44 12/01/44 06/01/45 12/01/45 06/01/46 12/01/46 06/01/47 12/01/47 06/01/48 12/01/48 06/01/49 12/01/49 06/01/50 12/01/50 06/01/51 12/01/51 06/01/52 12/01/52 06/01/53 12/01/53 06/01/54 12/01/54 06/01/55 Total as of: 5/1/2023 100 101 102 103 104 105 106 107 108 Series 2018D-1 ($10.0M) CORE 2.0% Series 2018D-2 ($8.0M) CORE 3.0% Series 2018E ($11.3M) CORE 2.0% Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt - 1,327 - - 2,025 - - 1,462 - 13,957 15,284 16,611 9,426 11,452 13,477 14,999 16,501 17,963 - 1,367 - - 2,074 - - 1,553 - 15,348 16,716 18,083 10,525 12,599 14,672 16,483 18,036 19,589 - 1,288 - - 1,937 - - 1,469 - 15,518 16,807 18,095 10,781 12,718 14,655 16,653 18,122 19,591 - 1,208 - - 1,798 - - 1,384 - 15,660 16,869 18,077 11,064 12,862 14,660 16,823 18,208 19,592 - 1,128 - - 1,654 - - 1,298 - 15,830 16,958 18,086 11,348 13,002 14,657 17,022 18,320 19,619 - 1,046 - - 1,507 - - 1,212 - 16,001 17,047 18,093 11,660 13,167 14,675 17,192 18,404 19,615 - 964 - - 1,356 - - 1,124 - 16,171 17,135 18,099 11,944 13,300 14,657 17,362 18,486 19,610 - 881 - - 1,202 - - 1,035 - 16,313 17,193 18,074 12,256 13,458 14,659 17,533 18,568 19,603 - 797 - - 1,043 - - 946 - 16,483 17,280 18,076 12,568 13,611 14,654 17,703 18,649 19,595 - 712 - - 880 - - 856 - 16,653 17,365 18,077 12,908 13,789 14,669 17,901 18,757 19,613 - 626 - - 713 - - 764 - 16,823 17,449 18,075 13,249 13,962 14,675 18,072 18,836 19,600 - 539 - - 542 - - 672 - 16,994 17,533 18,072 13,589 14,131 14,672 18,270 18,942 19,615 - 452 - - 366 - - 579 - 17,192 17,644 18,096 13,930 14,295 14,661 18,441 19,020 19,599 - 363 - - 185 - - 485 - 17,362 17,726 18,089 14,298 14,484 14,669 18,639 19,124 19,609 - 274 - - - - - 390 - 17,533 17,806 18,080 - - - 18,838 19,228 19,618 - 184 - - - - - 294 - 17,731 17,915 18,098 - - - 19,008 19,302 19,596 - 92 - - - - - 197 - 17,901 17,994 18,086 - - - 19,206 19,403 19,600 - - - - - - - 99 - - - - - - - 19,405 19,504 19,603 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 279,472$ 304,640$ 305,967$ 169,547$ 202,086$ 204,111$ 319,551$ 349,769$ 351,231$ Prepared by PFM Financial Advisors LLC Page 12 of 19 Date:3/7/2023 CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates Payment Date 12/01/22 06/01/23 12/01/23 06/01/24 12/01/24 06/01/25 12/01/25 06/01/26 12/01/26 06/01/27 12/01/27 06/01/28 12/01/28 06/01/29 12/01/29 06/01/30 12/01/30 06/01/31 12/01/31 06/01/32 12/01/32 06/01/33 12/01/33 06/01/34 12/01/34 06/01/35 12/01/35 06/01/36 12/01/36 06/01/37 12/01/37 06/01/38 12/01/38 06/01/39 12/01/39 06/01/40 12/01/40 06/01/41 12/01/41 06/01/42 12/01/42 06/01/43 12/01/43 06/01/44 12/01/44 06/01/45 12/01/45 06/01/46 12/01/46 06/01/47 12/01/47 06/01/48 12/01/48 06/01/49 12/01/49 06/01/50 12/01/50 06/01/51 12/01/51 06/01/52 12/01/52 06/01/53 12/01/53 06/01/54 12/01/54 06/01/55 Total as of: 5/1/2023 109 110 111 112 113 114 115 116 117 Series 2018F ($6.0M) CORE 2.0% Series 2019A ($12.0M) CORE 2.0% Series 2020B ($11.2M) CORE 2.0% Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt - 775 - - 2,718 - - 1,848 - 4,036 4,818 5,593 13,567 16,284 19,002 2,344 4,879 6,727 - 808 - - 2,813 - - 3,000 - 4,426 5,234 6,042 15,093 17,906 20,719 13,788 16,940 19,940 - 764 - - 2,662 - - 3,014 - 4,511 5,275 6,039 15,405 18,067 20,729 14,072 17,086 20,100 - 719 - - 2,508 - - 2,873 - 4,568 5,286 6,005 15,689 18,197 20,704 14,355 17,229 20,102 - 673 - - 2,351 - - 2,730 - 4,653 5,326 5,999 16,001 18,352 20,703 14,639 17,369 20,098 - 627 - - 2,191 - - 2,583 - 4,738 5,364 5,991 16,341 18,532 20,723 14,923 17,506 20,089 - 579 - - 2,028 - - 2,434 - 4,823 5,402 5,982 16,653 18,681 20,708 15,235 17,669 20,103 - 531 - - 1,861 - - 2,282 - 4,908 5,439 5,970 16,994 18,855 20,716 15,547 17,829 20,110 - 482 - - 1,691 - - 2,126 - 4,993 5,475 5,957 17,334 19,025 20,716 15,859 17,985 20,111 - 432 - - 1,518 - - 1,968 - 5,078 5,510 5,942 17,675 19,192 20,710 16,171 18,139 20,106 - 381 - - 1,341 - - 1,806 - 5,163 5,545 5,926 18,043 19,384 20,725 16,483 18,289 20,095 - 330 - - 1,161 - - 1,641 - 5,248 5,578 5,908 18,412 19,573 20,733 16,823 18,465 20,106 - 277 - - 976 - - 1,473 - 5,362 5,639 5,916 18,753 19,729 20,706 17,164 18,637 20,110 - 224 - - 789 - - 1,301 - 5,447 5,671 5,894 19,150 19,939 20,728 17,504 18,806 20,107 - 169 - - 597 - - 1,126 - 5,532 5,701 5,870 19,519 20,116 20,714 17,845 18,971 20,097 - 114 - - 402 - - 948 - 5,646 5,759 5,873 19,916 20,318 20,720 18,214 19,161 20,109 - 57 - - 203 - - 766 - 5,731 5,788 5,845 20,313 20,516 20,719 18,582 19,348 20,114 - - - - - - - 580 - - - - - - - 18,951 19,531 20,111 - - - - - - - 390 - - - - - - - 19,320 19,710 20,101 - - - - - - - 197 - - - - - - - 19,717 19,914 20,111 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 84,862$ 99,979$ 100,754$ 294,855$ 347,758$ 350,475$ 317,534$ 386,700$ 388,549$ Prepared by PFM Financial Advisors LLC Page 13 of 19 Date:3/7/2023 CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates Payment Date 12/01/22 06/01/23 12/01/23 06/01/24 12/01/24 06/01/25 12/01/25 06/01/26 12/01/26 06/01/27 12/01/27 06/01/28 12/01/28 06/01/29 12/01/29 06/01/30 12/01/30 06/01/31 12/01/31 06/01/32 12/01/32 06/01/33 12/01/33 06/01/34 12/01/34 06/01/35 12/01/35 06/01/36 12/01/36 06/01/37 12/01/37 06/01/38 12/01/38 06/01/39 12/01/39 06/01/40 12/01/40 06/01/41 12/01/41 06/01/42 12/01/42 06/01/43 12/01/43 06/01/44 12/01/44 06/01/45 12/01/45 06/01/46 12/01/46 06/01/47 12/01/47 06/01/48 12/01/48 06/01/49 12/01/49 06/01/50 12/01/50 06/01/51 12/01/51 06/01/52 12/01/52 06/01/53 12/01/53 06/01/54 12/01/54 06/01/55 Total as of: 5/1/2023 118 119 120 121 122 123 124 125 126 Series 2021A Refunding ($37.38M) Series 2022A ($20.370M) CORE 2.0% 2022B SO Tier West ($3.6M) EXP 2% Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt - 23,953 - - 972 - - - - 91,915 115,868 139,822 - 2,293 3,264 - 1,392 1,392 - 22,855 - - 3,713 - - 2,175 - 101,835 124,690 147,545 19,292 24,287 28,000 8,960 11,139 13,314 - 20,309 - - 5,671 - - 2,090 - 107,073 127,383 147,692 24,455 30,041 35,712 9,142 11,231 13,321 - 17,632 - - 5,342 - - 1,998 - 111,896 129,529 147,161 24,937 30,279 35,620 9,323 11,322 13,320 - 14,835 - - 5,092 - - 1,905 - 117,035 131,870 146,705 25,448 30,540 35,632 9,505 11,410 13,315 - 11,909 - - 4,838 - - 1,810 - 122,425 134,334 146,243 25,959 30,796 35,634 9,686 11,497 13,307 - 8,849 - - 4,578 - - 1,713 - 127,747 136,596 145,444 26,469 31,047 35,625 9,929 11,642 13,355 - 5,655 - - 4,313 - - 1,614 - 133,874 139,529 145,184 27,008 31,322 35,635 10,110 11,724 13,338 - 4,651 - - 4,043 - - 1,513 - 135,200 139,850 144,501 27,547 31,591 35,634 10,292 11,805 13,318 - 3,552 - - 3,768 - - 1,410 - 136,985 140,537 144,090 28,086 31,854 35,622 10,534 11,944 13,354 - 2,439 - - 3,487 - - 1,305 - 138,417 140,856 143,295 28,654 32,141 35,628 10,716 12,020 13,325 - 1,228 - - 3,200 - - 1,197 - 140,360 141,588 142,816 29,221 32,422 35,622 10,958 12,155 13,353 - - - - 2,908 - - 1,088 - - - - 29,817 32,725 35,633 11,139 12,227 13,315 - - - - 2,610 - - 977 - - - - 30,413 33,023 35,633 11,382 12,358 13,335 - - - - 2,306 - - 863 - - - - 31,008 33,314 35,620 11,624 12,486 13,349 - - - - 1,996 - - 746 - - - - 31,633 33,628 35,624 11,866 12,612 13,359 - - - - 1,680 - - 628 - - - - 32,285 33,965 35,644 12,047 12,675 13,303 - - - - 1,357 - - 507 - - - - 32,909 34,266 35,623 12,290 12,797 13,304 - - - - 1,028 - - 384 - - - - 33,590 34,618 35,645 12,532 12,916 13,301 - - - - 692 - - 259 - - - - 34,243 34,934 35,626 12,834 13,094 13,353 - - - - 349 - - 131 - - - - 34,923 35,273 35,622 13,077 13,207 13,338 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 1,464,762$ 1,716,546$ 1,740,499$ 577,897$ 707,327$ 708,298$ 217,944$ 267,967$ 267,967$ Prepared by PFM Financial Advisors LLC Page 14 of 19 Date:3/7/2023 CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates Payment Date 12/01/22 06/01/23 12/01/23 06/01/24 12/01/24 06/01/25 12/01/25 06/01/26 12/01/26 06/01/27 12/01/27 06/01/28 12/01/28 06/01/29 12/01/29 06/01/30 12/01/30 06/01/31 12/01/31 06/01/32 12/01/32 06/01/33 12/01/33 06/01/34 12/01/34 06/01/35 12/01/35 06/01/36 12/01/36 06/01/37 12/01/37 06/01/38 12/01/38 06/01/39 12/01/39 06/01/40 12/01/40 06/01/41 12/01/41 06/01/42 12/01/42 06/01/43 12/01/43 06/01/44 12/01/44 06/01/45 12/01/45 06/01/46 12/01/46 06/01/47 12/01/47 06/01/48 12/01/48 06/01/49 12/01/49 06/01/50 12/01/50 06/01/51 12/01/51 06/01/52 12/01/52 06/01/53 12/01/53 06/01/54 12/01/54 06/01/55 Total as of: 5/1/2023 127 128 129 130 131 132 133 134 135 TOTAL EXISTING DEBT 2022C Sewer Lining P2 $11.0M Core 2% 2022D Igersoll Run ($26.4M) Core 3% WRA DEBT Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt - - - - - - - 158,987 - - 973 973 - 1,139 1,139 611,749 787,234 946,220 - 2,089 - - 4,008 - - 169,755 - 13,901 16,779 18,867 - 6,824 10,832 722,006 911,232 1,080,987 - 2,981 - - 9,048 - - 169,154 - 13,050 16,032 19,013 16,994 28,088 37,136 764,719 949,610 1,118,763 - 2,851 - - 10,980 - - 161,672 - 13,334 16,185 19,036 16,199 27,179 38,159 785,541 960,314 1,121,987 - 2,718 - - 10,737 - - 151,801 - 13,589 16,307 19,025 16,682 27,418 38,155 808,561 972,768 1,124,569 - 2,582 - - 10,486 - - 141,608 - 13,845 16,427 19,008 17,164 27,650 38,137 832,450 985,747 1,127,355 - 2,444 - - 10,229 - - 131,081 - 14,128 16,572 19,015 17,703 27,932 38,161 856,654 998,684 1,129,765 - 2,302 - - 9,963 - - 120,217 - 14,412 16,714 19,016 18,214 28,177 38,140 882,522 1,012,926 1,133,143 - 2,158 - - 9,690 - - 111,281 - 14,696 16,854 19,012 18,753 28,443 38,133 915,566 1,036,247 1,147,528 - 2,011 - - 9,409 - - 101,883 - 15,008 17,019 19,030 19,320 28,729 38,138 971,105 1,081,546 1,183,430 - 1,861 - - 9,119 - - 91,951 - 15,291 17,153 19,014 19,916 29,035 38,154 909,177 1,008,737 1,100,688 - 1,708 - - 8,820 - - 82,373 - 15,604 17,312 19,020 20,512 29,332 38,152 931,687 1,020,906 1,103,279 - 1,552 - - 8,513 - - 72,550 - 15,916 17,468 19,020 21,107 29,620 38,133 773,912 852,520 925,070 - 1,393 - - 8,196 - - 64,045 - 16,228 17,621 19,014 21,760 29,956 38,152 755,524 824,816 888,861 - 1,231 - - 7,870 - - 55,561 - 16,568 17,799 19,029 22,412 30,282 38,152 664,705 724,676 780,237 - 1,065 - - 7,534 - - 48,710 - 16,880 17,945 19,010 23,093 30,627 38,160 683,190 735,445 784,156 - 896 - - 7,187 - - 41,666 - 17,221 18,117 19,013 23,774 30,961 38,148 693,516 737,835 779,501 - 724 - - 6,831 - - 34,499 - 17,561 18,285 19,009 24,483 31,314 38,144 556,338 592,592 627,091 - 548 - - 6,463 - - 28,467 - 17,930 18,478 19,027 25,221 31,684 38,147 504,507 534,082 562,549 - 369 - - 6,085 - - 22,792 - 18,270 18,639 19,008 25,987 32,072 38,157 446,975 470,310 493,102 - 186 - - 5,695 - - 17,584 - 18,639 18,825 19,012 26,753 32,448 38,143 328,043 345,766 363,350 - - - - 5,294 - - 13,406 - - - - 27,547 32,841 38,135 157,019 170,426 183,832 - - - - 4,881 - - 11,212 - - - - 28,398 33,279 38,160 116,465 127,676 138,888 - - - - 4,455 - - 9,465 - - - - 29,249 33,704 38,159 119,959 129,424 138,888 - - - - 4,016 - - 7,665 - - - - 30,101 34,116 38,132 123,533 131,198 138,863 - - - - 3,564 - - 5,812 - - - - 31,008 34,573 38,137 127,213 133,026 138,838 - - - - 3,099 - - 3,904 - - - - 31,945 35,044 38,143 85,592 89,496 93,400 - - - - 2,620 - - 2,620 - - - - 32,909 35,529 38,149 32,909 35,529 38,149 - - - - 2,126 - - 2,126 - - - - 33,902 36,029 38,155 33,902 36,029 38,155 - - - - 1,618 - - 1,618 - - - - 34,895 36,513 38,131 34,895 36,513 38,131 - - - - 1,095 - - 1,095 - - - - 35,945 37,039 38,134 35,945 37,039 38,134 - - - - 555 - - 555 - - - - 37,023 37,578 38,134 37,023 37,578 38,134 - - - - - - - - - - - - - - - - - - 312,070$ 381,172$ 381,172$ 748,968$ 1,155,341$ 1,155,341$ 16,302,902$ 20,386,056$ 20,545,043$ Prepared by PFM Financial Advisors LLC Page 15 of 19 Date:3/7/2023 CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates Payment Date 12/01/22 06/01/23 12/01/23 06/01/24 12/01/24 06/01/25 12/01/25 06/01/26 12/01/26 06/01/27 12/01/27 06/01/28 12/01/28 06/01/29 12/01/29 06/01/30 12/01/30 06/01/31 12/01/31 06/01/32 12/01/32 06/01/33 12/01/33 06/01/34 12/01/34 06/01/35 12/01/35 06/01/36 12/01/36 06/01/37 12/01/37 06/01/38 12/01/38 06/01/39 12/01/39 06/01/40 12/01/40 06/01/41 12/01/41 06/01/42 12/01/42 06/01/43 12/01/43 06/01/44 12/01/44 06/01/45 12/01/45 06/01/46 12/01/46 06/01/47 12/01/47 06/01/48 12/01/48 06/01/49 12/01/49 06/01/50 12/01/50 06/01/51 12/01/51 06/01/52 12/01/52 06/01/53 12/01/53 06/01/54 12/01/54 06/01/55 Total as of: 5/1/2023 136 137 138 139 140 141 142 143 144 C Clarifier P2 ($19.0M) C Bid Contingency ($12.0M) Total 2022 Certificate Remaining Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt - - - - - - - - - - - - - - - - - - - 1,277 - - - - - 1,277 - - 1,277 2,553 - - - - 1,277 2,553 - 4,856 - - 2,897 - - 7,753 - 22,696 28,086 32,942 14,469 17,873 20,770 37,165 45,959 53,712 - 5,163 - - 3,260 - - 8,423 - 22,611 27,774 32,938 14,270 17,530 20,790 36,881 45,304 53,727 - 4,937 - - 3,117 - - 8,054 - 23,065 28,002 32,939 14,554 17,671 20,788 37,619 45,673 53,727 - 4,707 - - 2,971 - - 7,678 - 23,519 28,225 32,932 14,838 17,809 20,780 38,356 46,034 53,712 - 4,471 - - 2,823 - - 7,294 - 24,001 28,472 32,944 15,150 17,973 20,796 39,151 46,445 53,740 - 4,231 - - 2,672 - - 6,903 - 24,455 28,686 32,918 15,462 18,133 20,805 39,917 46,820 53,723 - 3,987 - - 2,517 - - 6,504 - 24,966 28,952 32,939 15,745 18,262 20,779 40,711 47,215 53,719 - 3,737 - - 2,360 - - 6,097 - 25,448 29,185 32,922 16,086 18,445 20,805 41,534 47,630 53,727 - 3,483 - - 2,199 - - 5,681 - 25,959 29,441 32,924 16,398 18,597 20,795 42,356 48,038 53,719 - 3,223 - - 2,035 - - 5,258 - 26,498 29,721 32,944 16,710 18,745 20,779 43,208 48,465 53,723 - 2,958 - - 1,868 - - 4,826 - 27,008 29,966 32,925 17,050 18,918 20,786 44,059 48,884 53,710 - 2,688 - - 1,697 - - 4,385 - 27,547 30,235 32,923 17,391 19,088 20,785 44,938 49,323 53,708 - 2,413 - - 1,523 - - 3,936 - 28,115 30,527 32,940 17,731 19,254 20,778 45,846 49,782 53,717 - 2,131 - - 1,346 - - 3,477 - 28,682 30,814 32,945 18,100 19,446 20,792 46,782 50,259 53,737 - 1,845 - - 1,165 - - 3,009 - 29,249 31,094 32,939 18,469 19,634 20,799 47,718 50,728 53,737 - 1,552 - - 980 - - 2,532 - 29,817 31,369 32,921 18,838 19,818 20,798 48,655 51,187 53,719 - 1,254 - - 792 - - 2,046 - 30,413 31,667 32,921 19,206 19,998 20,790 49,619 51,665 53,711 - 950 - - 600 - - 1,550 - 31,037 31,987 32,936 19,604 20,203 20,803 50,640 52,190 53,740 - 639 - - 404 - - 1,043 - 31,661 32,300 32,940 19,972 20,376 20,780 51,633 52,677 53,720 - 323 - - 204 - - 527 - 32,285 32,608 32,931 20,398 20,602 20,806 52,683 53,210 53,737 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 539,030$ 661,215$ 661,215$ 340,440$ 415,803$ 415,803$ 879,470$ 1,077,018$ 1,077,018$ Prepared by PFM Financial Advisors LLC Page 16 of 19 Date:3/7/2023 CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates Payment Date 12/01/22 06/01/23 12/01/23 06/01/24 12/01/24 06/01/25 12/01/25 06/01/26 12/01/26 06/01/27 12/01/27 06/01/28 12/01/28 06/01/29 12/01/29 06/01/30 12/01/30 06/01/31 12/01/31 06/01/32 12/01/32 06/01/33 12/01/33 06/01/34 12/01/34 06/01/35 12/01/35 06/01/36 12/01/36 06/01/37 12/01/37 06/01/38 12/01/38 06/01/39 12/01/39 06/01/40 12/01/40 06/01/41 12/01/41 06/01/42 12/01/42 06/01/43 12/01/43 06/01/44 12/01/44 06/01/45 12/01/45 06/01/46 12/01/46 06/01/47 12/01/47 06/01/48 12/01/48 06/01/49 12/01/49 06/01/50 12/01/50 06/01/51 12/01/51 06/01/52 12/01/52 06/01/53 12/01/53 06/01/54 12/01/54 06/01/55 Total as of: 5/1/2023 145 146 147 148 149 150 151 152 153 Ingersoll Run #2 - CORE 4.0% Phosphorus Recovery - CORE 4.0% Sewer Lining Loan #3 - CORE 3.0% Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt - - - - - - - - - - - - - - - - 567 - - - - - - - - 1,702 2,270 - - - - 3,799 - - 18,270 - - 3,063 - 6,837 12,511 16,310 2,837 26,725 44,995 10,695 14,951 18,014 - 5,537 - - 23,831 - - 4,095 - 5,220 10,757 16,295 28,370 52,201 76,032 10,866 14,961 19,056 - 5,433 - - 23,263 - - 3,932 - 5,447 10,880 16,313 45,364 68,627 91,890 11,206 15,138 19,070 - 5,324 - - 22,356 - - 3,764 - 5,646 10,970 16,293 47,179 69,535 91,892 11,518 15,282 19,046 - 5,211 - - 21,413 - - 3,591 - 5,873 11,084 16,295 49,052 70,464 91,877 11,887 15,478 19,069 - 5,094 - - 20,432 - - 3,413 - 6,128 11,221 16,315 51,009 71,441 91,872 12,227 15,640 19,053 - 4,971 - - 19,411 - - 3,229 - 6,355 11,326 16,297 53,052 72,463 91,875 12,596 15,826 19,055 - 4,844 - - 18,350 - - 3,041 - 6,610 11,454 16,298 55,180 73,530 91,880 12,993 16,034 19,075 - 4,712 - - 17,247 - - 2,846 - 6,866 11,577 16,289 57,393 74,639 91,886 13,362 16,208 19,054 - 4,574 - - 16,099 - - 2,645 - 7,149 11,724 16,298 59,690 75,789 91,888 13,759 16,405 19,050 - 4,431 - - 14,905 - - 2,439 - 7,433 11,864 16,296 62,074 76,979 91,884 14,185 16,624 19,063 - 4,283 - - 13,664 - - 2,226 - 7,745 12,028 16,310 64,542 78,205 91,869 14,611 16,837 19,063 - 4,128 - - 12,373 - - 2,007 - 8,057 12,185 16,313 67,152 79,525 91,897 15,036 17,043 19,050 - 3,967 - - 11,030 - - 1,781 - 8,369 12,336 16,303 69,819 80,848 91,878 15,490 17,271 19,053 - 3,799 - - 9,633 - - 1,549 - 8,710 12,509 16,308 72,627 82,261 91,894 15,972 17,521 19,070 - 3,625 - - 8,181 - - 1,309 - 9,050 12,675 16,300 75,521 83,702 91,882 16,455 17,764 19,073 - 3,444 - - 6,670 - - 1,063 - 9,419 12,863 16,307 78,557 85,227 91,897 16,937 17,999 19,062 - 3,256 - - 5,099 - - 809 - 9,788 13,043 16,299 81,677 86,776 91,876 17,448 18,256 19,065 - 3,060 - - 3,466 - - 547 - 10,185 13,245 16,305 84,940 88,405 91,871 17,958 18,505 19,052 - 2,856 - - 1,767 - - 277 - 10,582 13,438 16,295 88,344 90,111 91,878 18,497 18,775 19,052 - 2,645 - - - - - - - 11,008 13,652 16,297 - - - - - - - 2,425 - - - - - - - 11,461 13,886 16,310 - - - - - - - 2,195 - - - - - - - 11,915 14,111 16,306 - - - - - - - 1,957 - - - - - - - 12,398 14,355 16,312 - - - - - - - 1,709 - - - - - - - 12,880 14,589 16,298 - - - - - - - 1,451 - - - - - - - 13,391 14,842 16,293 - - - - - - - 1,184 - - - - - - - 13,930 15,113 16,297 - - - - - - - 905 - - - - - - - 14,497 15,402 16,307 - - - - - - - 615 - - - - - - - 15,064 15,680 16,295 - - - - - - - 314 - - - - - - - 15,689 16,002 16,316 - - - - - - - - - - - - - - - - - - - - - - - - 283,700$ 489,069$ 489,069$ 1,194,377$ 1,777,182$ 1,777,182$ 283,700$ 380,145$ 380,145$ Prepared by PFM Financial Advisors LLC Page 17 of 19 Date:3/7/2023 CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates Payment Date 12/01/22 06/01/23 12/01/23 06/01/24 12/01/24 06/01/25 12/01/25 06/01/26 12/01/26 06/01/27 12/01/27 06/01/28 12/01/28 06/01/29 12/01/29 06/01/30 12/01/30 06/01/31 12/01/31 06/01/32 12/01/32 06/01/33 12/01/33 06/01/34 12/01/34 06/01/35 12/01/35 06/01/36 12/01/36 06/01/37 12/01/37 06/01/38 12/01/38 06/01/39 12/01/39 06/01/40 12/01/40 06/01/41 12/01/41 06/01/42 12/01/42 06/01/43 12/01/43 06/01/44 12/01/44 06/01/45 12/01/45 06/01/46 12/01/46 06/01/47 12/01/47 06/01/48 12/01/48 06/01/49 12/01/49 06/01/50 12/01/50 06/01/51 12/01/51 06/01/52 12/01/52 06/01/53 12/01/53 06/01/54 12/01/54 06/01/55 Total as of: 5/1/2023 154 155 156 157 158 159 160 161 162 Southern Tier Interceptor P10 - CORE 3.0% Bid Contingency - CORE 4.0% Total 2023 Certificate Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 878 - - 4,539 - - 1,601 - - 1,447 2,325 10,554 16,228 20,767 - 2,561 4,162 - 1,775 - - 5,463 - - 3,251 - - 2,426 4,201 9,873 15,336 20,799 28 3,759 7,010 - 2,915 - - 5,265 - - 3,730 - 8,908 12,313 15,228 10,270 15,535 20,801 37,136 40,867 44,597 - 3,271 - - 5,060 - - 3,359 - 8,681 11,952 15,223 10,667 15,727 20,787 34,867 38,226 41,585 - 3,141 - - 4,847 - - 3,010 - 8,937 12,077 15,218 11,093 15,939 20,786 33,221 36,232 39,242 - 3,007 - - 4,625 - - 2,678 - 9,220 12,227 15,233 11,547 16,171 20,796 31,519 34,197 36,875 - 2,868 - - 4,394 - - 2,363 - 9,476 12,344 15,212 12,001 16,394 20,788 73,138 75,501 77,864 - 2,726 - - 4,154 - - 1,632 - 9,788 12,514 15,240 12,483 16,637 20,791 69,138 70,769 72,401 - 2,579 - - 3,904 - - 940 - 10,071 12,651 15,230 12,993 16,898 20,802 94,018 94,958 95,899 - 2,428 - - 3,644 - - - - 10,355 12,783 15,211 13,504 17,149 20,793 - - - - 2,273 - - 3,374 - - - - 10,667 12,940 15,213 14,043 17,417 20,792 - - - - 2,113 - - 3,093 - - - - 11,008 13,120 15,233 14,611 17,704 20,797 - - - - 1,948 - - 2,801 - - - - 11,320 13,267 15,215 15,206 18,008 20,809 - - - - 1,778 - - 2,497 - - - - 11,660 13,438 15,216 15,802 18,299 20,796 - - - - 1,603 - - 2,181 - - - - 12,029 13,632 15,235 16,426 18,607 20,788 - - - - 1,423 - - 1,853 - - - - 12,369 13,792 15,215 17,107 18,960 20,812 - - - - 1,237 - - 1,510 - - - - 12,738 13,975 15,212 17,788 19,298 20,809 - - - - 1,046 - - 1,155 - - - - 13,135 14,181 15,227 18,497 19,652 20,807 - - - - 849 - - 785 - - - - 13,532 14,381 15,230 19,235 20,020 20,804 - - - - 646 - - 400 - - - - 13,930 14,576 15,222 20,001 20,401 20,801 - - - - 437 - - - - - - - 14,355 14,792 15,229 - - - - - - - 222 - - - - - - - 14,781 15,002 15,224 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 226,960$ 310,991$ 310,991$ 283,700$ 415,926$ 415,926$ 373,066$ 419,634$ 419,634$ Prepared by PFM Financial Advisors LLC Page 18 of 19 Date:3/7/2023 CITY OF WAUKEE WRA Debt Service Allocations 2023 Certificates Payment Date 12/01/22 06/01/23 12/01/23 06/01/24 12/01/24 06/01/25 12/01/25 06/01/26 12/01/26 06/01/27 12/01/27 06/01/28 12/01/28 06/01/29 12/01/29 06/01/30 12/01/30 06/01/31 12/01/31 06/01/32 12/01/32 06/01/33 12/01/33 06/01/34 12/01/34 06/01/35 12/01/35 06/01/36 12/01/36 06/01/37 12/01/37 06/01/38 12/01/38 06/01/39 12/01/39 06/01/40 12/01/40 06/01/41 12/01/41 06/01/42 12/01/42 06/01/43 12/01/43 06/01/44 12/01/44 06/01/45 12/01/45 06/01/46 12/01/46 06/01/47 12/01/47 06/01/48 12/01/48 06/01/49 12/01/49 06/01/50 12/01/50 06/01/51 12/01/51 06/01/52 12/01/52 06/01/53 12/01/53 06/01/54 12/01/54 06/01/55 Total as of: 5/1/2023 163 164 165 166 167 168 169 170 171 TOTAL EXISTING AND PENDING DEBT Effluent Pumping #1 - CORE 3.0% Total PENDING Estimated WRA Debt for 2023 Certificates Par Total Debt Ann. Debt Par Total Debt Ann. Debt Par Total Debt Ann. Debt - - - - - 158,987 - - - - 611,749 787,234 946,220 - - - - 1,277 - - 171,032 - - - - - 1,277 2,553 722,006 912,509 1,083,541 - 1,601 - - 10,955 - - 180,108 - - 2,561 4,162 37,165 51,081 62,036 801,884 1,000,691 1,180,799 - 3,251 - - 14,925 - - 176,597 - 28 3,759 7,010 36,938 52,822 67,747 822,478 1,013,136 1,189,733 - 3,730 - - 15,515 - - 167,316 - 37,136 40,867 44,597 111,891 127,406 142,921 920,452 1,100,174 1,267,490 - 3,359 - - 14,396 - - 156,004 - 34,867 38,226 41,585 108,090 122,486 136,882 940,539 1,108,233 1,264,237 - 3,010 - - 13,315 - - 144,396 - 33,221 36,232 39,242 105,593 118,908 132,223 962,247 1,117,593 1,261,988 - 2,678 - - 12,259 - - 132,476 - 31,519 34,197 36,875 102,955 115,214 127,473 985,477 1,128,140 1,260,616 - 2,363 - - 11,230 - - 122,511 - 73,138 75,501 77,864 186,987 198,216 209,446 1,102,553 1,234,463 1,356,974 - 1,632 - - 9,360 - - 111,243 - 69,138 70,769 72,401 179,809 189,169 198,529 1,150,914 1,270,715 1,381,958 - 940 - - 7,562 - - 99,513 - 94,018 94,958 95,899 230,393 237,955 245,516 1,139,570 1,246,691 1,346,204 - - - - 5,258 - - 87,631 - - - - 43,208 48,465 53,723 974,895 1,069,371 1,157,003 - - - - 4,826 - - 77,376 - - - - 44,059 48,884 53,710 817,970 901,404 978,780 - - - - 4,385 - - 68,430 - - - - 44,938 49,323 53,708 800,463 874,139 942,570 - - - - 3,936 - - 59,497 - - - - 45,846 49,782 53,717 710,551 774,457 833,955 - - - - 3,477 - - 52,188 - - - - 46,782 50,259 53,737 729,972 785,705 837,892 - - - - 3,009 - - 44,675 - - - - 47,718 50,728 53,737 741,234 788,563 833,238 - - - - 2,532 - - 37,031 - - - - 48,655 51,187 53,719 604,992 643,779 680,810 - - - - 2,046 - - 30,513 - - - - 49,619 51,665 53,711 554,126 585,747 616,260 - - - - 1,550 - - 24,341 - - - - 50,640 52,190 53,740 497,616 522,500 546,841 - - - - 1,043 - - 18,627 - - - - 51,633 52,677 53,720 379,676 398,442 417,070 - - - - 527 - - 13,933 - - - - 52,683 53,210 53,737 209,702 223,636 237,569 - - - - - - - 11,212 - - - - - - - 116,465 127,676 138,888 - - - - - - - 9,465 - - - - - - - 119,959 129,424 138,888 - - - - - - - 7,665 - - - - - - - 123,533 131,198 138,863 - - - - - - - 5,812 - - - - - - - 127,213 133,026 138,838 - - - - - - - 3,904 - - - - - - - 85,592 89,496 93,400 - - - - - - - 2,620 - - - - - - - 32,909 35,529 38,149 - - - - - - - 2,126 - - - - - - - 33,902 36,029 38,155 - - - - - - - 1,618 - - - - - - - 34,895 36,513 38,131 - - - - - - - 1,095 - - - - - - - 35,945 37,039 38,134 - - - - - - - 555 - - - - - - - 37,023 37,578 38,134 - - - - - - - - - - - - - - - - - - 373,066$ 419,634$ 419,634$ 1,625,601$ 1,916,286$ 1,916,286$ 17,928,503$ 22,302,342$ 22,461,329$ Prepared by PFM Financial Advisors LLC Page 19 of 19 Date:3/7/2023 WRA Cash Contribution Process 1. Project costs are presented in the annual Construction Program and have been determined tentatively in the current facility plan. WRA staff, with assistance from a financial advisor, presents a funding plan to the Finance Committee annually and prior to the Senior Bond Certificate process. 2. The Senior Bond Certificate amount is determined by review of funding plan and current project estimates from WRA Engineering. 3. Project costs and anticipated financing details will be known upon completion of final design for project subject to a new construction loan. 4. Construction projects are subject to public hearing and bid letting process, before final costs can be determined; a. Any Community interested in funding their share of a new project with cash, should alert WRA in writing (with copy to financial advisor) so the financial analysis can begin – bid letting process will go to the WRA board at this time and serves as a reminder to Communities to initiate the cash contribution discussion; b. Model for cash allocations can be developed during the period after construction is ordered and prior to the preparation of the debt closing documents; 5. Loan details with IFA can be structured on the assumption full loan amount will be drawn (e.g. Intended Use Plan approved amount) – ensuring WRA has sufficient funds to complete the project regardless of Community cash contribution; a. Senior Bond Certificates will be structured on the assumption WRA will issue full amount of debt for approved projects, and Communities will be asked to acknowledge the same with each Certificate. However, any Community who desires to fund a project with cash will have that ability – in accordance herewith 6. Prior to WRA Board final approval of the Loan documentation (authorizing resolution, Loan Agreement, etc.), a resolution of the governing body of the Community seeking cash contribution shall be filed with the WRA; a. Community resolution should identify the following project specifics: i. Anticipated project cost estimates (design + construction), ii. Amount of community cash allocation, iii. Fund into which cash shall be held by the Community solely for payment to WRA during the construction phase, iv. Any other assumptions material to the project; 7. Upon closing of WRA Loan, WRA shall seek cash contribution from Community on a pro-rata basis of other loan draws, through final completion of the project; a. Once a Community begins contributing its share with cash, the option to change back to sharing in the debt for said project ceases (due to administrative burdens of tracking only partial cash payments, etc.); 8. Due to cash contributions from Community(ies) during the project construction phase, WRA will not draw down full loan amount. WRA shall request a re-amortization of the final debt service schedule to reflect actual lower final principal amount drawn. It may be possible to set the final payment amount high enough to cover the cash contribution amount. 9. Annual reconciliations of each Community’s cash contribution to actual allocable debt service (based on flow) will be administered in the operational/debt service component of the Community’s budget allocation (either credit or additional charge due, based on actual flow compared to actual debt for project). Per discussion in January 2023 with Financial Committee members, recommendation to follow the above outline. Options to modify the above and Article XIII, Section 5 of the 28E Agreement after the process is placed in service on future construction funding and reported back to the Finance Committee.