Loading...
HomeMy WebLinkAboutOctober 15, 2024 Council PacketShakopee City Council Regular Meeting Tuesday, October 15, 2024 7:00 PM City Hall, 485 Gorman Street Vision: Shakopee is a place where people want to be! A distinctive river town, with a multitude of business, cultural and recreational opportunities in a safe, welcoming, and attractive environment for residents and visitors Mission: Our mission is to deliver high quality services essential to maintaining a safe and sustainable community. We commit to doing this cost-effectively, with integrity and transparency. 1. Call to Order 2. Roll Call 3. Pledge of Allegiance 4. Approval of Agenda 5. Consent Agenda These items are considered routine and will be enacted by one motion. There will be no separate discussion of these unless a council member or staff requests, in which event the item will be removed from the consent agenda for separate discussion & action. 5.a Declaring a vehicle as surplus property Declare one vehicle as surplus property and authorize disposal. 5.b Final Acceptance and Payment for the 2024 Cured -in -Place Sewer Pipe Lining Project Adopt Resolution R2024-131, accepting work on the 2024 Cured -in -Place Sewer Pipe Lining Project, SEWER-23-001, and authorize final payment in the amount of $67,295.08. Resolution R2024-131 Certificate of Completion 5.c Final Acceptance and Payment for the 2023 Full Depth Pavement Reconstruction and Bituminous Pavement Rehabilitation Project Adopt Resolution R2024-130, accepting work on the 2023 Full Depth Pavement Reconstruction and Bituminous Pavement Rehabilitation Project CIF-23-001, CIF-23-011, CIF-23-012 and CIF-23-013, and authorizing final payment in the amount of $100,775.70. Resolution R2024-130 CERTIFICATE OF COMPLETION - 2023 FDR Pavement Project 5.d National Recreation and Park Association's Supporting Healthy Aging Through Parks and Recreation Program Application Adopt Resolution R2024-132, approving an application to the National Recreation and Parks Association's (NRPA) Supporting Healthy Aging Through Parks and Recreation (SHATPR) program. Resolution R2024-132.pdf 5.e Change Order for Canterbury Commons Internal Roadway Improvements Approve Change Order No. 1 to extend the completion date for the Canterbury Commons Internal Roadway Improvements. Change Order #1 - Revised Contract Date_Signed Change Order #1 - 2025 Project Items 6. Public Comment Individuals may address the City Council about any item not on the regular agenda. Speakers are requested to come to the center table, state their name and address for the clerk's record, and limit their remarks to three minutes. The City Council will not take official action on items discussed at this time, but may refer the matter to staff for a follow up report or direct that matter be scheduled on an upcoming agenda. 7. Business removed from consent agenda 8. Public Hearings 8.a Assessment hearing on delinquent refuse bills from Dick's Sanitation Adopt Resolution R2024-128, certifying assessments for delinquent refuse bills R2024-128 Certification of Delinquent Refuse (10-1 5-24).pdf Delinquent Refuse List (10-7-2024).pdf 2024 Delinquent Garbage Public Hearing 10-15-2024.pdf 8.b Assessment hearing on delinquent fire/police alarms and mowing services Hold public hearing and adopt Resolution R2024-129, certifying assessments for delinquent fire/police false alarms and mowing bills. Resolution R2024-129 Certifying Ordinance Violations (10-1 5-2024).pdf Ordinance Violations 10-15-2024.pdf 2024 Delinquent False Alarms Public Hearing 10-15-2024.pdf 9. General Business 9.a Monthly Financial Report - September 2024 Review of September 2024 General Fund revenues/expenditures and 3rd quarter investment report. 2024.09 Monthly Financial Report- with Revenues.pdf September 30, 2024 - Investments Narrative.pdf City of Shakopee Portfolio Analysis_09.30.24.pdf 10. Workshop 10.a Emergency management table top exercise. Recommend that the council participate in an emergency management tabletop training event led by an outside facilitator and fire and police department staff. 11. Reports Liaison and Administration 11.a City Bill List Review of City Bill List 11.b Liaison and Administration N/A 12. Other Business 13. Adjournment to Wednesday, November 6, 2024 at 7:00 pm Agenda Item: Prepared by: Reviewed by: Shakopee City Council 5.a October 15, 2024 Declaring a vehicle as surplus property Josh Davis, Sergeant Sergeant Josh Davis Action to be considered: Declare one vehicle as surplus property and authorize disposal. Motion Type: Approve Background: The following vehicle was obtained through forfeiture proceedings and is described as follows: 1. 2009 Chevrolet Avalanche, VI N : 1 GCEK39J 19Z251423 If the vehicle is suitable for resale it will be sold at auction and the proceeds, if any, will be distributed according to Minnesota State Statute. If the vehicle is not suitable for resale, it will be junked. Recommendation: Approve policy/action as requested. Budget Impact: None. Attachments: Agenda Item: Prepared by: Reviewed by: Shakopee City Council 5.b October 15, 2024 Final Acceptance and Payment for the 2024 Cured -in -Place Sewer Pipe Lining Project Micah Heckman, Assistant City Engineer Alex Jordan, City Engineer Action to be considered: Adopt Resolution R2024-131, accepting work on the 2024 Cured -in -Place Sewer Pipe Lining Project, SEWER-23-001, and authorize final payment in the amount of $67,295.08. Motion Type: Adopt Background: On March 6, 2024, the City Council adopted Resolution R2024-029 accepting the bids and awarding a contract for the 2024 Cured -in -Place Sewer Pipe Lining Project to Insituform Technologies USA LLC, of Chesterfield, Missouri. All of the improvements have been constructed in accordance with the contract documents. Attached is the Certificate of Completion showing the original contract amount of $442,797.09 with actual final costs of $456,821.29. All required project documentation has been received and is compliant. The project will be closed out upon issuance of final payment to Insituform Technologies USA LLC, in the amount of $67,295.08. Recommendation: Adopt Resolution R2024-131. Budget Impact: The total final project amount is $461,821.29. This total amount includes the final construction cost of $456,821.29 and engineering/administration/legal costs amounting to $5,000.00. This project is funded by the Sanitary Sewer Fund. Table 1 below provides a summary of the costs and funding comparing the estimated amounts based on bid award versus the final actual amounts. Table 1. Cost and Funding for Project SEWER-23-001 ESTIMATE BASED ON BID AWARD FINAL PROJECT COSTS COSTS Construction Cost $442,797.09 $456,821.29 Contingency $ 25,000.00 $0.00 Subtotal $ 467,797.09 $456,821.29 Engineering/Admin/Legal $23,390.00 $5,000.00 Total Estimated Project Cost $491,187.09 $461,821.29 FUNDING Sanitary Sewer Fund $491,187.09 $461,821 .29 Total Funding $491,187.09 $461,821.29 Attachments: Resolution R2024-131 Certificate of Completion RESOLUTION R2024-131 A RESOLUTION OF THE CITY OF SHAKOPEE, MINNESOTA ACCEPTING WORK ON THE 2024 CURED -IN -PLACE SEWER PIPE LINING PROJECT, SEWER-23-001, AND AUTHORIZE FINAL PAYMENT IN THE AMOUNT OF $67,295.08 WHEREAS, pursuant to a written contract signed with the City of Shakopee on March 6, 2024, Insituform Technologies USA, LLC, has satisfactorily completed the 2024 Cured -in -Place Sewer Pipe Lining project in accordance with such contract. NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SHAKOPEE, MINNESOTA AS FOLLOWS: The work completed under said contract is hereby accepted and approved. BE IT FURTHER RESOLVED AS FOLLOWS: The City Clerk and Mayor are hereby directed to issue a proper order for the final payment on such contract in the amount of $67,295.08, taking the contractor's receipt in full. Adopted in regular session of the City Council of the City of Shakopee, Minnesota, held this 15th day of October 2024. Mayor of the City of Shakopee ATTEST: City Clerk Prepared by: City of Shakopee 485 Gorman Street Shakopee, MN 55379 CERTIFICATE OF COMPLETION CONTRACT NO(S): SEWER-23-001 DATE: September 25, 2024 PROJECT DESCRIPTION: 2024 Cured -in -Place Sewer Pipe Lining CONTRACTOR: Insituform Technologies USA LLC, 580 Goddard Avenue Chesterfield, MO 63005 ORIGINAL CONTRACT AMOUNT $ 442,797.09 QUANTITY CHANGE AMOUNT $ -0- CHANGE ORDER NO. THRU NO. AMOUNT $ -0- FINAL CONTRACT AMOUNT $ 456,821.29 LESS PREVIOUS PAYMENTS $ 389,526.21 FINAL PAYMENT $ 67,295.08 I, hereby certify that the above described work was inspected under my direct supervision and that, to the best of my belief and knowledge, I find that the same has been fully completed in all respects according to the contract, together with any modifications approved by City Council. I, therefore, recommend above specified final payment be made to the above -named Contractor. Micah Heckman Agenda Item: Prepared by: Reviewed by: Shakopee City Council 5.c October 15, 2024 Final Acceptance and Payment for the 2023 Full Depth Pavement Reconstruction and Bituminous Pavement Rehabilitation Project Micah Heckman, Assistant City Engineer Alex Jordan, City Engineer Action to be considered: Adopt Resolution R2024-130, accepting work on the 2023 Full Depth Pavement Reconstruction and Bituminous Pavement Rehabilitation Project CIF-23-001, CIF-23-011, CIF-23-012 and CIF-23-013, and authorizing final payment in the amount of $100,775.70. Motion Type: Adopt Background: On April 18, 2023, the City Council adopted Resolution R2023-050 accepting the bids and awarding the contract for the 2023 Full -Depth Pavement Reconstruction and Bituminous Pavement Rehabilitation Project to Bituminous Roadways, of Mendota Heights. All of the improvements have been constructed in accordance with the contract documents. Attached is the Certificate of Completion showing the original contract amount of $4,845,215.42 with actual final costs of $4,474,862.32. All required project documentation has been received and is compliant. Final payment to Bituminous Roadways in the amount of $100,775.70 will be issued once approved. Recommendation: Adopt Resolution R2024-130. Budget Impact: The total estimated final project amount is $4,710,671.55. This project is funded by the Capital Improvement Fun, (CIF), Storm Drainage Fund, Sanitary Sewer Fund, Special Assessments and Shakopee Public Utilities. The following table provides a summary of the costs and funding amounts comparing the estimated bid award budget versus the final project costs: Table 1: Cost and Funding for 2023 Full Depth Pavement Reconstruction and Bituminous Pavement Rehabilitation Project Estimate Based on Bid Award Based on Final Project Costs COSTS Construction Cost $ 4,845,215.42 $ 4,474,862.32 Streetl ighti ng $ 12,000.00 $ 4,608.97 Chip Seal Coat $ 53,650.80 $ 57,312.50 Contingency $ 242,860.77 $ 0.00 Subtotal $ 5,153,726.99 $ 4,536,783.79 Engineering/Legal/Admin $ 320,000.00 $ 173,887.76 Total Project Cost $ 5,473,726.99 $ 4,710,671.55 FUNDING Special Assessments $ 572,301.03 $ 488,564.23 Capital Improvement Fund $ 4,567,258.13 $ 3,962,729.53 Storm Sewer Fund $ 225,522.10 $ 170,063.56 Sanitary Sewer Fund $ 48,424.74 $ 35,907.96 Shakopee Public Utilities $ 60,220.99 $ 53,406.26 Total Funding $ 5,473,726.99 $ 4,710,671.55 Attachments: Resolution R2024-130 CERTIFICATE OF COMPLETION - 2023 FDR Pavement Project RESOLUTION R2024-130 A RESOLUTION OF THE CITY OF SHAKOPEE, MINNESOTA ACCEPTING WORK ON THE 2023 FULL DEPTH PAVEMENT RECONSTRUCTION AND BITUMINOUS PAVEMENT REHABILITATION PROJECT, CIF-23-001, CIF-23-011, CIF-23-012 & CIF-23-013 WHEREAS, pursuant to a written contract signed with the City of Shakopee on April 18, 2023, Bituminous Roadways, Inc., has satisfactorily completed the 2023 Full Depth Pavement Reconstruction and Bituminous Pavement Rehabilitation Project in accordance with such contract. NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SHAKOPEE, MINNESOTA AS FOLLOWS: The work completed under said contract is hereby accepted and approved. BE IT FURTHER RESOLVED AS FOLLOWS: The City Clerk and Mayor are hereby directed to issue a proper order for the final payment on such contract in the amount of $100,775.70, taking the contractor's receipt in full. Adopted in regular session of the City Council of the City of Shakopee, Minnesota, held this 15th day of October 2024. Mayor of the City of Shakopee ATTEST: City Clerk Prepared by: City of Shakopee 485 Gorman Street Shakopee, MN 55379 CERTIFICATE OF COMPLETION CONTRACT NO(S): CIF-23-001, CIF-23-011, DATE: October 10, 2024 CIF-23-012, CIF-23-013 PROJECT DESCRIPTION: 2023 Full Depth Pavement Reconstruction & Bituminous Pavement Rehabilitation CONTRACTOR: Bituminous Roadways Inc. 1520 Commerce Drive Mendota Heights, MN 55120 ORIGINAL CONTRACT AMOUNT $ 4,845,215.42 QUANTITY CHANGE AMOUNT $ -0- CHANGE ORDER NO. THRU NO. AMOUNT $ -0- FINAL CONTRACT AMOUNT $ 4,474,862.32 LESS PREVIOUS PAYMENTS $ 4,374,086.62 FINAL PAYMENT $ 100,775.70 I, hereby certify that the above described work was inspected under my direct supervision and that, to the best of my belief and knowledge, I find that the same has been fully completed in all respects according to the contract, together with any modifications approved by City Council. I, therefore, recommend above specified final payment be made to the above named Contractor. Micah Heckman Agenda Item: Prepared by: Reviewed by: Shakopee City Council 5.d October 15, 2024 National Recreation and Park Association's Supporting Healthy Aging Through Parks and Recreation Program Application Andrea Harrell, Grants and Special Projects Coordinator Chelsea Petersen Action to be considered: Adopt Resolution R2024-132, approving an application to the National Recreation and Parks Association's (NRPA) Supporting Healthy Aging Through Parks and Recreation (SHATPR) program. Motion Type: Simple Majority Background: NRPA provides funding to Parks and Recreation professionals to increase access, availability, participation, and sustainable support for programs that improve physical activity, engagement, and the quality of life for older adults. The SHATPR program's goal is to increase access to arthritis -appropriate, evidence -based interventions within parks and recreation classes such as Active Living Every Day, Enhanced Fitness, Fit & Strong!, Tai Chi for Arthritis, and Walk With Ease. Recommendation: Adopt Resolution R2024-132. Budget Impact: The grant requires a 0% match. Attachments: Resolution R2024-132.pdf RESOLUTION R2024-132 A RESOLUTION OF THE CITY OF SHAKOPEE, MINNESOTA APPROVING THE CITY TO SUBMIT A NATIONAL RECREATION AND PARK ASSOCIATION SUPPORTING HEALTHY AGING THROUGH PARKS AND RECREATION PROGRAM APPLICATION WHEREAS, the City of Shakopee supports the application made to the National Recreation and Park Association's (NRPA) Supporting Healthy Aging Through Parks and Recreation (SHATPR) program, and WHEREAS, the application is to obtain funding for the support costs of establishing programming and training Recreation staff in at least one of five classes to increase access to arthritis - appropriate, evidence -based interventions for older adults, and WHEREAS, the City of Shakopee recognizes a 0% match is required. NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SHAKOPEE, MINNESOTA AS FOLLOWS: if the City of Shakopee is awarded a grant by the National Recreation and Parks Association, the City of Shakopee agrees to accept the grant award and may enter into an agreement with National Recreation and Parks Association for the above -referenced project. The City of Shakopee will comply with all applicable laws, requirements, and regulations as stated in the grant agreement. Adopted in the regular session of the City Council of the City of Shakopee, Minnesota, held this 15th day of October 2024. Matt Lehman, Mayor of the City of Shakopee ATTEST: Lori Hensen City Clerk Prepared by: City of Shakopee 485 Gorman Street Shakopee, MN 55379 Agenda Item: Prepared by: Reviewed by: Shakopee City Council 5.e October 15, 2024 Change Order for Canterbury Commons Internal Roadway Improvements Alex Jordan, City Engineer Action to be considered: Approve Change Order No. 1 to extend the completion date for the Canterbury Commons Internal Roadway Improvements. Motion Type: Approve Background: On June 4, 2024, the City Council awarded a contract to Heselton Construction, LLC (Heselton) for construction of the Canterbury Commons Internal Roadway Improvements. The Notice to Proceed was issued by the City on June 11, 2024. The contract included a Substantial Completion date of October 15, 2024 and a Final Completion date of November 1, 2024. Substantial Completion includes utility installation, placement of bituminous base course pavement, sidewalk, trail, pedestrian curb ramps, signage, restoration, cleanup and paving of final bituminous pavement lift and striping. Final completion includes 100 percent of all work and submittal of all close out documents to be ready for final payment. The adjacent Ampitheatre improvements include construction of a VIP Parking Lot, bounded by the roadways constructed with the City's improvement project. The Ampitheatre contractor was not able to complete this parking lot in 2024, and plans to finish the improvements in the spring of 2025. Following completion of the parking lot, Heselton can complete construction of the sidewalk, irrigation and landscaping adjacent to the parking lot. Those improvements must be completed prior to placing the final lift of pavement and installing the pavement markings. City staff are recommending approval of Change Order No. 1 which will extend the Substantial Completion date to June 14, 2025 and Final Completion date to June 28, 2025. This extension will allow the Ampitheatre contractor to finish the necessary parking lot construction to allow Heselton to complete the City improvements. The roadways will be completed and ready for public use prior to the first event at the Ampitheatre, which is expected to be held in the summer of 2025. Recommendation: Approve Change Order Budget Impact: Heselton has indicated that some of the bid items may increase in price due to expected rising labor and material costs. The City will negotiate the amended construction costs, if necessary, with Heselton in the spring prior to commencing the remainder of construction. The change order limits the cost increases to the values found in the Construction Cost Index. Based on the work completed to date, the total amended construction costs (including any cost increases due to this Change Order) is expected to be less than the total approved project costs based on the bid award. Attachments: Change Order #1 - Revised Contract Date_Signed Change Order #1 - 2025 Project Items SECTION 00 63 63 CHANGE ORDER FORM Change Order No. 1 Date 10/9/2024 Agreement Date 6/4/2024 Name of Project: Canterbury Commons Internal Roadway Improvements Owner: City of Shakopee Contractor: Heselton Construction The following changes are hereby made to the Contract Documents: Substantial completion date has been revised to 30 days after the completion of the Amphitheater parking lot or June 14th, 2025, whichever comes first. Final completion has been revised to June 28th, 2025. Justification: The substantial and final completion dates have been revised to 2025 to account for the coordination delays attributed to private utility relocations, adjacent construction projects, and material procurement. The Amphitheater improvements, including the VIP parking lot, need to be completed prior to allowing Heselton to grade the boulevards, construct the sidewalk and installing the landscaping along Road B adjacent to the parking lot. Heselton will complete the rest of the sidewalk, landscaping, restoration and irrigation coordination not adjacent to the parking lot in 2024. The City is amenable to extending the contract completion date to allow the improvements to be completed during favorable weather conditions creating a better finished product. The contractor has expressed that some of the bid items may increase in price due to expected rising labor and material costs that are to be discussed in the spring. The increased costs will be limited to the values found in the Construction Cost Index, if necessary. Project No. 193807171 Change Order Form 00 63 63-1 Original Contract Price: $ 4,419,649.75 Current Contract Price adjusted to previous Change Order: $ N/A The Contract Price due to this Change Order will be increased by $ TBD The new Contract Price including this Change Order will be $ 4,419,649.75 Original Contract Substantial Completion Date: October 15, 2024 The Contract Time will be Increased by 242 Calendar days Current Contract Substantial Completion Date adjusted to this Change Order: June 14, 2024 Original Contract Final Completion Date: November 1, 2024 The Contract Time will be Increased by 239 Calendar days Current Contract Final Completion Date adjusted to this Change Order: June 27, 2024 Approvals Required: To be effective, this Order must be approved by the Owner and the Contractor if it changes the scope of objective of the Project, or as may otherwise be required by the Supplemental General Conditions. Digitally signed by Wyers Nick Requested by: Wyers, Nick o�e$zoz4;o 01215D51-05'00'naI OU=users, Nick Wyers, P.E. Digitally signed by Jason Brandvold JasonBrandvold DN; C=US, E=jason@heseltonconstruction.com, Accepted b y ■ Date: 2024.110.10 10a51:48-05'00' Heselton Construction Accepted by: City of Shakopee, Mayor Accepted by: City of Shakopee, City Administrator Project No. 193807171 Change Order Form 00 63 63-2 VlOS3NNIW ')J Nl0O llOOS 33dO)IVHS dO AlIO S6-1760-CS dlO # lO3rald AllO 1O3f O Jd 1N213A0HdWI SAWMOVOH 1VN2131NI SNOWWOO A2:1f192:131NV3 .31111103f0. D z rwn V w w w U � � w � z z w w :Liz J O � � U w dw J U O Z zw °� = z u~i H O H C7 d � w N K pU w F1(7), U m w 0 ALL DIMENSIONS ARE SHOWN TO FACE OF CURB UNLESS W W 5 5Q LJ 5 5 ui rn Cn w EXIST ING ZONING 5 X w II NV Ll b5 l l 1.2/0E/6 .N'S`J3AM 1,00E/60, 1951,0 Nbld.S 1.06-DISANSNVld Noisa 5\S3111311f1 NNf12i1 aNV OV0`J\ ovidO13n30 N2i31SV3.1.31,1,1951,011Z , w U C w J c rO U ❑ J W 2 Hp, OJ m ZZ11111,b H~=c~r�0 6 zW o��a¢ L'I) Owoaz za zJnp�z wNaO� xUJoyzJ�¢}W~lin Qx Of?Q� � Wp OW 11) 1111 Owaazwo =vOW¢Qw�❑aa Zd�x�WJ�d'� WW J�Ow07Fx��d¢¢OQx�¢U¢rn O��U�7 ���>�>cwi�FU�OwWwx Ou7 wwpamrn �-� wF JlillwIxHZ1JWp lis iip0~'kik ���WWQ��JZg� _� ¢��QO�ZW�wQ Z aO11 Hii(°: mZOZmZ �w j�Z ZU W¢~O OJU Z 111 1p Z WQa�Qwui¢�aOO¢Jz=❑zwi¢ �ZwC7Z Q Q � (Y(!7zF= Q�JW?O Qa ZW UQ>¢QWHxad'xLl,lpU��ZrW1Pw OaJL'L z�O�QpzOopQLHHvQZKw¢❑OjW��QW'�QfnEwzFwa¢a HxOU¢OOQNUfiliir Z�0�����XK�Jx�-~ QU ZaQ W� WW H 2 Jd�H Q �¢ pW¢ZW Hm (n(n Z F dJQm W p WZ J Z N x plx a U x QQ O O W JI¢ W Z W a¢p FQOF�a /nxxUF00 ¢>xmY¢� VLOS3NNIW `33dONVHS JO ) LIO 1N31NdO13A30 SaVOI 1SV3 H1fOS A2If192J31NV3 ISSUE SCHEDULE oQ � H U � CD Z Q ri w w 0 J ui.., mew, :q8 Wd EE E bZOZ/lZ/S 31VO 101d / uie6ean6w :A8 Wd 60 E 4ZOZ/lZ/5 31V4 3AVS / NVId `JN,Nvid L Lbl-Olbl ZZ50Z\13S ONIMV2IO AVMOV021 - l0\S133HS\OVO0111V\`JNI1iiJOM ZZ50Z,eaq.dwy ZZ50Z\OZOZ\ N uoileuoq ali j INETERSegi ■ § Ct G ym \ \ d GE3ZA N Agenda Item: Prepared by: Reviewed by: Shakopee City Council 8.a October 15, 2024 Assessment hearing on delinquent refuse bills from Dick's Sanitation Nate Reinhardt, Finance Director Action to be considered: Adopt Resolution R2024-128, certifying assessments for delinquent refuse bills Motion Type: Simple Majority Background: The city has received a listing of unpaid refuse and recycling services from Dick's Sanitation (DSI), the city's designated garbage hauler. In a previous action, the City Council authorized city participation in the collection of delinquent garbage accounts in the city's designated "organized" collection area. By doing this, it eliminates the need to stop service to the accounts, which would lead to a higher incidence of illegal dumping. DSI provided a list of delinquent accounts (greater that 60 days past due as of August 31) which was presented to the City Council on September 15, 2024. That list included 450 property owners with unpaid garbage/refuse bills for a total amount due of $56,523.44. All property owners impacted received mailed notices, which included information on the certification process. Attached is an updated list of delinquent property owners who have unpaid garbage/refuse bills as of October 7, 2024, which was comprised of 179 property owners with unpaid garbage/refuse bills for a total amount of $31,160.73. Property owners have been informed that a $25.00 administration fee will be added, and the delinquent amount will be levied to their 2025 property tax bill if not paid by November 15, 2024. Recommendation: Following a public hearing, adopt Resolution R2024-128, ordering certification of unpaid refuse bills for collection with payable 2025 property taxes. Budget Impact: There is no budget impact to the City as the amounts were previously owed. A $25.00 administrative charge will be added to cover administrative costs of the certification process. Attachments: R2024-128 Certification of Delinquent Refuse (10-1 5-24).pdf Delinquent Refuse List (10-7-2024).pdf 2024 Delinquent Garbage Public Hearing 10-15-2024.pdf RESOLUTION NO. 2024-128 A Resolution Ordering Certification of Unpaid Refuse Bills for Collection with Payable 2025 Property Taxes WHEREAS, pursuant to proper notice duly given as required by law, the City Council of the City of Shakopee met and heard and passed upon all objections to the proposed assessments of: Delinquent Refuse Bills NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SHAKOPEE, MINNESOTA: 1. That such proposed assessment together with any amendments thereof, a copy of which is attached hereto and made a part hereof, is hereby accepted and shall constitute the special assessment against the lands named herein and each tract therein included is hereby found to be delinquent. 2. That there will be added to the delinquent amount a $25.00 fee if the delinquent amount is not paid to City of Shakopee on or before November 15, 2024. 3. Such assessments shall be payable in one installment, payable on or before the first Monday in January 2025, and shall bear interest at the rate of 6 percent per annum from the date of the adoption of this assessment resolution. To the one installment shall be added the interest on the entire assessment from the date of this resolution until December 31, 2024. 4. The owner of any property so assessed may, at any time prior to November 15, 2024, pay the whole of the assessment on such property without interest to DSI (Dick's Sanitation). 5. The owner may thereafter January 2025 pay to the County Treasurer the installment and interest in process of collection on the current tax list. 6. The Finance Deparment shall file the assessment rolls pertaining to this assessment and shall certify to the County Auditor the total amount of the installment on each parcel of land for collection with next year's taxes. Adopted in session of the City Council of the City of Shakopee, Minnesota, held this day of , 2024. Mayor of the City of Shakopee ATTEST: City Clerk Delinquent Refuse Bills PID Property Address Balance 270011420 2181ST AVE W $86.34 270012540 229 3RD AVE W $127.36 270012630 301.5 3RD AVE W $80.27 270012960 845 4TH AVE W $425.03 270012963 815 4TH AVE W $183.87 270013530 338 LEWIS ST S $307.04 270013620 2214TH AVE E $307.71 270013800 438 3RD AVE E $443.01 270014910 8216TH AVE W $292.04 270015180 537 6TH AVE W $86.34 270015310 403 6TH AVE W $162.68 270015351 422 5TH AVE W $391.44 270015480 219 6TH AVE W $298.83 270015650 128 5TH AVE W $81.70 270016010 322 6TH AVE E $119.74 270016090 235 7TH AVE E $86.34 270016110 616 SOMMERVILLE ST S $135.10 270016280 119 7TH AVE W $86.34 270016360 138 6TH AVE W $162.68 270017290 212 7TH AVE W $183.06 270017660 705 SOMMERVILLE ST S $91.60 270018190 210 8TH AVE W $61.43 270018260 523 4TH AVE E $81.70 270018330 506 3RD AVE E $153.40 270018430 502 2ND AVE E $391.44 270020330 210 SHAKOPEE AVE E $86.34 270040270 627 4TH AVE E $81.70 270040740 835 4TH AVE E $153.40 270040741 825 4TH AVE E $133.06 270040741 827 4TH AVE E $102.49 270041020 9221ST AVE E $228.05 270041150 1011 BLUFF AVE E $200.82 270041151 1037 BLUFF AVE E $162.68 270041230 136 NAUMKEAG ST S $273.83 270041360 336 NAUMKEAG ST S $298.83 270041520 1124 2ND AVE E $215.10 270041640 1143 3RD AVE E $86.34 270041680 805 BLUFF AVE E $86.34 270050090 714 4TH AVE E $406.08 270080130 633 MARKET ST S $307.71 270080610 837 7TH AVE E $149.36 270100100 539 7TH AVE E $288.83 Delinquent Refuse Bills PID Property Address Balance 270100180 507 6TH AVE E $81.70 270100220 5416TH AVE E $129.48 270120220 953 FULLER ST S $81.70 270120240 969 FULLER ST S $81.70 270120340 913 ATWOOD ST S $71.70 270130230 1025 MARKET ST S $86.34 270150010 1205 6TH AVE W $98.01 270160030 814 APGAR ST S $86.34 270170180 658 JEFFERSON ST S $85.94 270180100 959 MAIN ST S $68.68 270210130 1007 PIERCE ST S $303.86 270210220 920 CLAY ST S $229.02 270210460 907 PIERCE ST S $298.83 270210540 717 SHAKOPEE AVE W $162.68 270210550 730 PIERCE ST S $166.92 270250040 651 JACKSON ST S $162.68 270250060 671 JACKSON ST S $215.10 270250060 673 JACKSON ST S $144.67 270260020 1640 6TH AVE W $81.70 270290270 1067 HARRISON ST S $263.83 270290300 1097 HARRISON ST S $229.02 270340020 142410TH AVE E $177.36 270340050 1042 SIBLEY ST S $317.04 270340260 1053 RAMSEY ST S $81.70 270380010 1107 TYLER ST S $86.34 270410380 1028 NAUMKEAG ST S $321.63 270410440 1065 PRAIRIE ST S $289.91 270460050 2293 PARK RIDGE DR $153.40 270620310 8394 HORIZON DR $292.04 270630280 194812TH AVE W $301.68 270650050 1165 MERRIFIELD CT $74.45 270650100 1124 MERRITT CT $466.83 270740070 1274 HARRISON ST S $86.34 270840410 193013TH AVE W $86.34 270920100 1055 EASNIEW CIR $162.68 270920141 1002 EASNIEW CIR $86.34 270920381 1071 EASNIEW CIR $61.48 270940021 1130 3RD AVE W $306.66 271020090 1282 POLK ST S $81.70 271040022 204512TH AVE W $234.89 271150030 1008 3RD AVE E $81.70 271210020 123612TH AVE W $64.71 Delinquent Refuse Bills PID Property Address Balance 271220070 1199 LIMESTONE DR S $86.34 271250040 922 DAKOTA ST S $381.44 271330110 1941 HERITAGE DR E $94.82 271330590 1940 HERITAGE DR E $81.70 271330670 2104 MURPHY AVE $81.70 271360280 1108 MINNESOTA CT E $86.34 271380230 1121 PRAIRIE CT S $255.29 271380300 131211TH AVE E $218.69 271450080 1272 RUBY LN $86.34 271450250 1808 GRANITE DR $162.68 271450400 1817 GRANITE DR $298.83 271500220 1136 CLOVER CT $307.04 271500260 1311 MINNESOTA ST S $86.34 271600130 1228 DAKOTA ST S $162.68 271600250 804 LARKSPUR CT $81.70 271620040 514 5TH AVE E $324.23 271660150 1194TUMBLEWEED CIR $351.81 271770210 1274 SWIFT CIR $81.70 271770260 1257 SWIFT CIR $136.93 271770310 1272 MILLER ST S $162.68 271890040 655 5TH AVE E $226.36 271920280 145 BLUESTEM AVE E $292.04 271920460 335 BLUESTEM AVE E $246.01 271920560 329 ALEXANDER CT $303.12 271920620 209 FOXGLOVE LN $86.34 271950100 324 SAND ST $249.48 272040180 1347 APPLEGATE LN $86.34 272070340 344 HICKORY LN $250.63 272070530 177 HICKORY LN $94.81 272080250 2134 GREENWAY AVE $64.71 272090380 604 MONNENS AVE $99.48 272100010 428 APPLEBLOSSOM LN W $144.43 272200010 386 BRAEBURN DR $153.40 272200110 392 ORCHARD PKWY W $81.70 272300130 1134 ATWOOD ST S $153.40 272440250 644 MCINTOSH CT $162.68 272500470 6768 CARLISLE CURV $87.92 272600270 2142 GROVELAND WAY $238.69 272630360 2155 MATHIAS RD $255.29 272660190 1510 MCINTOSH CIR $105.25 272660340 1547 HARVEST LN $647.08 272740050 2077 PHEASANT RUN ST $298.83 Delinquent Refuse Bills PID Property Address Balance 272800400 2052 MATHIAS RD $229.02 272810270 6598 DANBURY CURV $162.68 272930030 1563 HARVEST LN $48.17 272960010 1732 TU RN B RI DGE CT $81.70 272970090 2321 PONDS WAY $317.04 273030040 2341 PONDS WAY $79.66 273050110 6749 FALMOUTH CURV $292.04 273050140 6821 FALMOUTH CURV $205.10 273050160 6869 FALMOUTH CURV $218.69 273050360 6774 FALMOUTH CURV $317.04 273130040 1277 FIRESIDE CT $162.68 273190360 2118 WILLIAMS ST $293.23 273291050 872 NEWPORT AVE $153.40 273310220 1420 WAKEFIELD CIR $249.48 273350030 1930 EAGLE CREEK BLVD $97.28 273350040 1940 EAGLE CREEK BLVD $129.42 273431650 2141 STAGHORN DR $86.34 273431910 2910 ASARUM CT $81.70 273432180 3112 CRANE ST $162.68 273470410 2680 KING AVE $292.04 273580110 1852 WYNDAM DR $81.70 273640020 1219 4TH AVE W $212.68 273711260 1527 CONEFLOWER LN $61.07 273760850 3580 MOLINAST $81.70 273860210 1796 SWITCHGRASS CT $229.02 273860640 1757 SWITCHGRASS CIR $124.25 273900120 1160 DANUBE AVE $162.68 273900400 620 DANUBE AVE $87.12 273900600 727 DANUBE AVE $86.34 273901280 1644 FRIESIAN ST $152.68 273901670 1679 NORIC ST $86.34 273902280 233 DONGOLA LN $317.04 273902280 233 DONGOLA LN $156.04 273902570 273 ARABIAN AVE W $86.34 273903210 136 ARABIAN AVE W $86.34 273904330 282 ARABIAN AVE E $81.70 273940350 3806 WHITETAIL DR $288.83 273940450 2114 ROCK RIDGE CIR $50.49 274210060 1367 RIDGE LN $422.68 274270640 8104 SPRING LAKE DR $101.78 274710150 1526 LINWOOD CIR $114.25 274750280 1668 WICKING WAY $153.40 Delinquent Refuse Bills PID Property Address Balance 274750300 1644 WICKING WAY $86.34 274750460 1755 WICKING WAY $118.29 274780260 2036 WINDERMERE WAY $86.34 274840300 7449 WATERLILY WAY $86.34 275041290 2974TRINITY DR $69.11 275080480 1860 ALOHA AVE $153.40 275110070 2087 BROOKVIEW ST $81.70 279010260 844 SOMMERVILLE ST S $320.63 279060390 1012 4TH AVE E $81.66 279061000 533 SHAKOPEE AVE E $140.54 279061030 525 SHAKOPEE AVE E $162.68 179 Totals $31,160.73 • z H • IIIIIIIIIIIIII N • • IMMIMMIMMI 4 z • iij MINN 1111111111111111M • MIIMMIIMMMI • rn rn # of Properties 00 C) rn q). rn -(r)- rn N L.r) z • IIIIIIIMIN • rn N 0 00 0rn 00 rn N 11: CA 0 C3 N # of Properties rn r-- r-- rn • z •� • (11) CI IM0000000 IMMI iw • 1111.111111111 111111111111111111111111111 z 0 o tr; 111101111= ction Requested x z Shakopee City Council 8.b October 15, 2024 Agenda Item: Assessment hearing on delinquent fire/police alarms and mowing services Prepared by: Nate Reinhardt, Finance Director Reviewed by: Action to be considered: Hold public hearing and adopt Resolution R2024-129, certifying assessments for delinquent fire/police false alarms and mowing bills. Motion Type: Simple Majority Background: The Council is asked to consider Resolution R2024-129 that would assess property owners on taxes payable 2025 for unpaid fire/police false alarms and mowing services. The city routinely certifies past due bills for collection with the property taxes. To date the city has been unable to collect $456 for false alarm and mowing services for four parcels. The city will charge an additional $25 administrative fee if the delinquent assessments become levied to cover the city's administrative costs. An updated list of property owners to be assessed (if needed) will be provided Tuesday evening; this is to allow property owners to make final payments until Tuesday, October 15, 2024. Recommendation: Adoption Budget Impact: The $25.00 delinquent charge would be revenue to cover the administrative costs; therefore, there is no impact on the budget. Attachments: Resolution R2024-129 Certifying Ordinance Violations (10-1 5-2024).pdf Ordinance Violations 10-15-2024.pdf 2024 Delinquent False Alarms Public Hearing 10-15-2024.pdf RESOLUTION NO. R2024-129 A Resolution Ordering Certification of Unpaid False Alarms & Lawn Mowing Services for Collection with Payable 2025 Property Taxes WHEREAS, pursuant to proper notice duly given as required by law, the City Council of the City of Shakopee met and heard and passed upon all objections to the proposed assessments of: Delinquent False Alarms and Lawn Mowing Services. NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SHAKOPEE, MINNESOTA: 1. That such proposed assessment together with any amendments thereof, a copy of which is attached hereto and made a part hereof, is hereby accepted and shall constitute the special assessment against the lands named herein and each tract therein included is hereby found to be delinquent. 2. That there will be added to the delinquent amount a $25 fee if the delinquent amount is not paid to the City of Shakopee on or before October 15, 2024. 3. Such assessments shall be payable in one installment, payable on or before the first Monday in January 2025, and shall bear interest at the rate of 6.0 percent per annum from the date of the adoption of this assessment resolution. To the one installment shall be added the interest on the entire assessment from the date of this resolution until December 31, 2024. 4. The owner of any property so assessed may, at any time prior to November 15, 2024, pay the whole of the assessment on such property without interest to the City of Shakopee Finance Department. 5. The owner may thereafter January 2025 pay to the County Treasurer the installment and interest in process of collection on the current tax list. 6. The Finance Department shall file the assessment rolls pertaining to this assessment and shall certify to the County Auditor the total amount of the installment on each parcel of land for collection with next year's taxes. Adopted in session of the City Council of the City of Shakopee, Minnesota, held this day of , 2024. Mayor of the City of Shakopee ATTEST: City Clerk IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII Report Name: 2024 Ordinance Violation Calc Daily Interest: Category: Assessment Amortization Type: S Opened Date: o O N O N � O S/A Number: A Interest Rate: County Admin Fee: $25.00 1,4 5 z E ct Status: Pending 2nd Hearing: O Sub Status: Resolution Number: z O Contract Nbr: z • IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII Closed Desc Payoff Amt Total Assessment Orig Assessment Street Name Pronertv ID 0 0 0 0 0 0 0 0 • odo 00 co M O O O O O O O O • O O O 00 Q1 M O O O O O O O O • 00 M - — — 71. Grand Total: Total Count: ,111111111. • IIIIIIIIIIII =111111111111111111 z z 111 • MIIMMMIIMMI 1.11111 1.11111 0 01111111111111111111• 111 • Immo 11111111111111111111111111111, 1,1 c,2 z H 111111111111111111111111111 4-0 0 MEM 00MEM 100000000 z 111111111 • I 0 01111111111111111111111M Jo LJ • 01110010 11111111111111111111111111111111110 • 1111111111110 c,2z H Agenda Item: Prepared by: Reviewed by: Shakopee City Council 9.a October 15, 2024 Monthly Financial Report - September 2024 Nate Reinhardt, Finance Director Action to be considered: Review of September 2024 General Fund revenues/expenditures and 3rd quarter investment report. Motion Type: Discuss Background: General Fund -September 2024 (see attachment) The 2024 Budget column has been adjusted for budget amendments approved by City Council on July 2, 2024. Revenue variances (75% target) • Total revenues were at 67 percent of budgeted revenues. • Taxes will remain below budget targets until the 2nd half property tax settlement is received from the County in December. • Licenses and permits have exceeded the budget expectation for the full year as a result of building permits. However, building permits are tracking behind last year through August. • Intergovernmental is currently below budget targets, this is typical as the majority of grant revenue is received in the fall. • Miscellaneous includes interest earnings on investments, which are tracking ahead of budget targets. This amount does not include the adjustment for an unrealized gain (adjustment of investments to market value), which will occur once a year on December 31. Expenditure variances (75% target) • In total departmental expenditures are within the normal range and similar to last year's percentage through September. • Finance department expenditures are currently exceeding budget targets as a result of payments for the County assessing contract and the annual audit. These payments occur in the first half of the year. It is anticipated the department will remain within the total annual budget allocation. • Planning and Development expenditures are currently exceeding budget targets as a result of the professional services related to the National Historic registry. The city received a grant of $77,500 from the Minnesota Historical Society towards the registry which covers a significant portion of the overall cost. • The Building Inspections department is currently ahead of budget targets, as a result of annual software costs paid in the 1st half and hiring of a building official funded through a state grant. It is anticipated the department will be near the budget allocation for the full year. Quarterly Investment Portfolio Report - Q3, 2024 (see attachment) Attached is the 3rd quarter investment portfolio report including a cover page that provides a comparison of investment results over the past five years. The report provided by Wells Fargo Securities encompasses all city investments. As required by the investment policy the report provides: • Total return performance measured against the the three year treasury (Page 6) • Weighted average yield (Page 3/Page 6) • A listing of individual securities held at the end of the reporting period listed by maturity date (Pages 16-19) • The carrying basis, the current calculated accredited basis and the current market value (Page 3) As a reminder, the city's investment policy is guided by the investment acronym SLY, which stands for Safety, Liquidity and Yield, and in that priority order. Safety of principal is the foremost objective of the investment program. Second, the investment portfolio needs to remain sufficiently liquid to meet day-to-day operational requirements. Lastly, attaining a market yield is the third goal of the investment policy. The first two priorities of safety and liquidity limit the ability of the portfolio to realize comparable private sector earning in those robust years. However, the policy also minimizes the changes of experiencing losses in the down years. Recommendation: Information only Budget Impact: N/A Attachments: 2024.09 Monthly Financial Report- with Revenues.pdf September 30, 2024 - Investments Narrative.pdf City of Shakopee Portfolio Analysis_09.30.24.pdf 01000 - GENERAL FUND REVENUES: * - TAXES * - SPECIAL ASSESSMENTS * - LICENSES AND PERMITS * - INTERGOVERNMENTAL * - CHARGES FOR SERVICES * - FINES AND FORFEITS * - MISCELLANEOUS TOTAL REVENUES EXPENDITURES: 11 - MAYOR & COUNCIL 12 - ADMINISTRATION 13 - CITY CLERK 15 - FINANCE 17 - PLANNING AND DEVELOPMENT 18 - FACILITIES 31 - POLICE DEPARTMENT 32-FIRE 33 - INSPECTION-BLDG-PLMBG-HTG 41 - ENGINEERING 42 - STREET MAINTENANCE 44 - FLEET 46 - PARK MAINTENANCE 67 - RECREATION 91 - UNALLOCATED TOTAL EXPENDITURES OTHER FINANCING * - TRANSFERS IN * - TRANSFERS OUT OTHER FINANCING TOTAL FUND TOTAL Key YTD 2024 Budget CITY OF SHAKOPEE Monthly Financial Report September YTD 2024 Actual September 2024 Actual Budget Balance Percent Remaining Used 22,569,800 0 11,688,219 10,881,581 14,000 0 11,473 2,527 3,491,450 531,802 4,215,086 (723,636) 1,679,000 4,726 887,283 791,717 8,113,350 749,487 6,702,552 1,410,798 325,200 22,943 211,882 113,318 379,200 87,057 627,982 (248,782) 36,572,000 1,396,014 24,344,477 12,227,523 (208,000) (2,643,925) (567,500) (1,128,925) (731,900) (693,650) (12,158,300) (3,844,100) (1,811,400) (1,490,850) (2,822,830) (565,100) (3,455,170) (5,208,560) (13,100) (37,343,310) (19,446) (196,160) (33,674) (70,095) (49,097) (35,331) (828,371) (293,392) (140,247) (103,959) (197,290) (44,994) (227,607) (345,723) (250) (2,585,637) 611,360 0 0 0 (105,283) (1,825,903) (399,332) (950,321) (622,539) (427,882) (8,112,484) (2,596,098) (1,664,327) (958,805) (1,983,212) (387,649) (2,502,363) (3,750,832) (11,778) (26,298,808) (102,717) (818,022) (168,168) (178,604) (109,361) (265,768) (4,045,816) (1,248,002) (147,073) (532,045) (839,618) (177,451) (952,807) (1,457,728) (1,322) (11,044,502) September YTD 2023 Actual 52% 10,910,295 82%,, 29,817 121% 5,058,758 53% 1,641,089 83% ,,v 6,654,015 65% , 240,739 166% 2,553,970 67%,,v 27,088,682 51% 69% 70% 84% 85% 62% 67% 68% 92% 64% 70% 69% 72% 72% 90% 70% 0 611,360 0% 0 0 #DIV/0! 611,360 0 (412,500) (1,189,623) 0 611,360 0% (1,954,331) 1,794,381 Varies more than 10% than budget positively Varies more than 10% than budget negatively Within 10% of budget (145,387) (1,691,165) (378,985) (889,619) (423,188) (501,433) (7,974,598) (2,336,170) (1,418,554) (943,208) (2,111, 814) (355,407) (2,528,363) (3,737,563) (27,405) (25,462,862) 0 0 0 583,254 City of Shakopee Investment Information September 30, 2024 Investments The City currently has a cash and investment balance of $88.6 million compared to a balance of $86.5 million one year ago. The City's total investment gain for 2024 is $4,111,029 which is comprised of investment income in the amount of $1,998,128 and an unrealized gain of 2,112,901. This compares to an investment gain for 2023 of $1,663,750, which included investment income of $1,438,459 and an unrealized gain of $225,291. The City intends to hold all investments until they mature, however it's important to keep in mind that changes in market interest rates will impact unrealized gains/losses of the investment portfolio. Rising interest rates in 2021 and 2022 resulted in unrealized losses ("paper losses") over those years, while declining/flat 2020, 2023, 2024 rates led to unrealized gains. $2,000,000 1 500 000 1 000 000 $500,000 $2,100,000 $1,600,000 $1,100,000 $600,000 $100,000 $(400,000) $(900,000) $(1,400,000) $(1,900,000) $(2,400,000) $(2,900,000) $(3,400,000) $(3,900,000) $(4,400,000) aNiN�ININ�N'oV NtN �� 1 N�1uN11� � N»»NNN»»I��lllummullll»\\\\N\\\»»WWWWWWWWWWWI' ���1111111111111111�1 ��0�1111 1\\V\N11NON10N1lllllllllll»NlllV\01\»\»0\»0\»0\ lip\\ p�lllll i��gglqqlllluw, � lolllmlllllmllmllll tWWW11//01 piWmiW111// NpuWWWAie 1011e tit; 111111111111111111111111111111111111111111111111111111111 Nip u�uiglgqu�ioNui�uiool�ll���l�ui°ol oll�i��444��u �11N���I��� �N\om\�»�N�1NON�1aiola 1N NUNS �i 11�Niuli�i N moWllllll.1o' 1111i1111111111 WW InterestEarnings by Year 2020-2024/////,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,///////// too pLr///�0��lrr 0011111110011110011110 �\111��1�11��0����111X 1111111111111111h�1111��1i��uuuul�uuuuuul�uuuuuul�uuuuuuuoluluuuuuull�uuuu � llNluu��1�100 »\\»N��N»N\N�iNliiNui�INl�`��o1�ati �am��amaiii���i 0��11�11�� N\NON\\NIII INNioi�ui�ui�ui NiNNlm�uiNnq�uiNngNNll�u lllllllllllllllllllllllll 00000uuulllllllllllluuuuuuuuuuuuuuuuuuu uuuuuuuuuuuul°��� I 'i'iiiuuuuuul°uuuuuiaum�0 uuuuuuuuuuuuuu�ll 11 11111lm°iiollmlioimolll:1,1 u� 1,11-,. IIIII!II loliliillloUmo� �w INNNlllt1UQ1111W�1��1N@ININ@@INN�INWININ@@INNNN11Uut1�11 \\\111\\111\\111\\111\\\\O»\\\111\\11\1111\1111\111\OOp\111\\1�����������01 »»»»N»»»»»»»»»»»»»»v»»vuv�llp°°°vN�»NNv .a.����,�dwNvvl»Nv»NVII»vvvl»NN�1111 II NOIIIIIIIIIII��� NI 11 laal Ili �»»»»»»»»»»»Nvvvvvvvvvvvvv� �ON1\NON\»\\N»\N11\\Nl\NI»\N11\\N\\NN\\N11\\N\\NI»\N11\»\\\NNI\N11ll»1»N41\N11ll 1 �1\ 1�1111�11111�, 1�1111�11�11�1\\N\\\\\\\\\\1\\\\11\\\\\\\\\\\\\\\1\\\\11\\\\\\\\\\\\\\\1\\\\11\\\\\\\\\\\\\\\1\\\\11\\\\\\\\\\\\\\\1111\\\\\\\\\\\\\\\10\\111 ° Illllllllu IIII11111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111 �Ij 11 IIIII Illllllliiiiuuuuuuuluuuuuuu uuuuuuluuuullullllllllllllllllllllllllllllllluuuuuuuuuuuuuul uuuuuul;iiilll u000uuulll001001""""Illllllllllul °001P N MIIIII oul MMIIIIIIIIIIIImImImMM Illllllm1.1.„1„.„„ii������ol ll�l�lllll�lluuluuull�llllllmll Iou�loumumlllllllmlou�loumumlllllllmlou�loumumlllllllmlll IIIIIIIVIIII i�lll� Inllllllll ommilnw 1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111,0101 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter m1omuuuuuuuu IIIW pun" 202 0 2021 20222023 2024 Unrealized Gain (Loss) 2020 - 2024 ,A1A////7/. J 00 uuuuumuuuuuu %/J�/ »» \\\l01 o»I�Nliiol oluuuul 0ouuuuuuuuuu loo� a�NNI 0\�111 lulouu /�I lllouuuu »»\\�0 uuuuu luau / uuuuuuul �00\111 uuuuu uuuuuuuuu uuuuuuul \\»\\1�1�\ uuuuu uuuuuuuul uuuuuuul (1`�� uuuuu uuuuuuuul / uuuuuuuu o»\�1�1��1` uuuuu uuuuuluul / uuuuuuul 1\01ao\ uuuuu uuuuuuuuu / uuuuuuul »\11N1 � IIIII 1\111111111111111 IIIIIIIIIIIIIII N\00•1 1 11�� 41111111111111111111111111111 \\O»000\\\N\O»N\\O 1,::::Enti‘111%‘‘,,)1 ��1�111IIIIIIII %yiy�,gflll������NI111u1111111111N1111p1p11tititi���1161h1�1,Ih11111111���, 0\\O 0 011»l\01\0 d ��9»I��NgP �111�1!VaaiiiiNla��uiulluiull / N»\» � �1101»011lll\\\1111NONN111N10\l11\1»\»1\N\1111111\LINO»\0\111N1 �1\\11»\\INNN\N\INNN\N\lNN»\N1»\1\\\11\\)1»\1\O»1\»»»»»\\I\1111N»\\1\\\N»1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111 �j% � 0»1111uumllouuum,11,11 l lllrr"rrrrrrrrrrrr. 1 mom 10000000u000000u0000u0000u0000u0000uuuuuuuuuuuuuuuuuuuuuuuuu00uuuuul jliiimlllll llllllllmllllllllllllllllllllllllm1911>�uull nwmullllf� 1st Quarter mouulouuuuuuuuuuulW4tW�11\\N uouuuuuuuuuo 202 0 1811111111111111111111111111111 IIIIIIIIIIIIIIIIII I00Nl0u1111 2021 11111111111111111111111111111111111111111111111111111111111111111111111111111111 2nd Quarter 111111 1 111 q 1111\\ °°u11111i°°°NNNNN\\\\\1\\ looi1ulouuuuuuuuuuuuu 11.1111111111111111111111111111111111111111111111111111111101 ���;, glologs�\a�aN���UIWS 1110.0000u I Ilu 111 i1111,,llll uuullu0000uuuuuluuuuuuuuuuuuuuuuuuuuuuuuuuuuu 111 11111111.111 lllllllllllllllllllllllllpllllpppppppppppppppppppplllllllllllllllllllllllllllIlllllllllllili iu 3rd Quarter 4th Quarter 2022 SIN,NN»»N»\\\»\\ II01...2023 r rrrrrrrrrrrrrrrrrrrrrr 2024 mmouuuuu� City .fSh.k..hh* •/ / • A A . i 11. -' ./ •/ • '.r •Ii• .s • : ./ +/ • . . .. • JJ.r I- (A•2) ' - • 2 jj.•artlett • ellsfar•o.co © 2024 ells Fargo :ank, N.A. All rights reserved. Confidential CN 4 0 0 LO N CO 0) 0 N N N N M (1) •4 0.) tr) et Sector - Su 0 • a L) co (0 (r) LL IS M 71- LO N CO 01 NI LO 0 0 • 0 a 0 0 1 0 a 0 a 5- 0 0 • aturity - Scenari a 11) C C 0 0 :473 :4:3 (7) (7) tr, 0 0 0 • © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. • 00 • • 0 •• • <00 • pow CL UN c 2 • i—iL00)rnaN 0 L.0 N 0 ("N N 00 LO N (yi 0) 0) (3) umber of Positions :ook Value ($000) kt Value w/o Accrd ($000) Unrlzed Gain / Loss ($000) ertificate of c o • u x o Li: 0 • (..o 00 L 0. :ook Yield arket Yield gt Avg aturity Effective Duration Effective Convexity 0 cf) r-i 00() oo LO m L.0 -I ai Nis L6 •vernight Funds Principal •vernight Funds Interest Term Securities Principal Term Securities Interest Total Cash Flow 1 (X) (.7') 00 (11,0 (5) INI 11111111% 00 C, (Y) 01, Or) N Cash Flow or Run Off Yield *Cash Flow Projections Chart - 1 Year Cash flow does not include 0 © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. • i• C.shFl.w r.j*cti.ns �uu 0 rI Sr CO Sr 0 N <O r-I r-I C0 ,, C31 M dl r-I d' Sr r-I 00 N 0 M CS.; ; CO r-I 0 L) Ln M O N M M fV'( h h h h h h h h R w r Lnh N O CO r-I r-I I`� I� C31 N M 6 co Ln m N N eq. O Cr 61 Ln 00 CC rn N CO rn CO M Sr Ln h h h h h h h h h h cam'° oo r-I .7 <O N N N O rI d'w r-I r-I r-I r-I N N M m m N G L() m oo Ln O <O t CO N Sr Sr N N 0 t Ln N N C0 CO Sr l0 M M N d' N N M r-I d' CO h lO h 00 h N h co- Ln R o0 h h Ln- Ln r-I m N LC) 00 N r-I Lf) N CO O N Ln m r-I M r-1 N 00 0 Sr Sr rI N m h h h h h 00 O rl N M Ln C0 00 O Oh d' d' d' d' d' d' d' in L) Ln C9 r-I M M <O CO M m Ln r-I eq. m r-I N N Lf) N Ln N 0o N N Sr Sr LO N N 61 N N m co M O N `t' m m o d" 61 O O et' C31 Ln C31 N <O N O N I� O N CO O 00 N 00 O) ri N M YK h h h h R h h h h h W^ h h h R R w h N LO �' 61 Lf) O N 00 Ln Gl �.f1 00 r I 6) O N N N N 00 co- o " C31 CO f'Sr 01 CO CO r-I 0 N r-I IIIIIII N N 71- 00 t r-I C3> M N N 00 Ln N f`` m N 00 N I� I� r-I O O N N O CO N M o N CO Lf) h h h h h h N h r-I h h N h h h h h h h h h M N N N M r-I Ln d' M �II', N r-I r-I r-I r-I r-I ri N Lf, 0 M O Ln CO r-I <O CO CO 0) CO M 61 N r-I 0 0 00 r-I 0Y CO M r-I N N •7t' Ln r-I N m N N M ct' rl 0 Lf) N N 61 01 N N N r-I r-I 0 00 M N O N t ► „ co L!') t r-I N '� O 0 t co Lf) h h " f 'xi' CO CO Lf) N h N N 00 0o O lU r-I r-I N N Ln CO N Ln M CO Ln Ln ,-I Ln m 0 N �' O N h h h h h h h h N co- rl Ln d' N r-I N N d' 00 r-I N Ln Ln t 0o 0 M 61 Lf) r-I Ln N 00 0 r-I h � R hR R h h R R C0 r-I rr-IN CO M 00 C31 61 O CO 7t d' 01 Lf) C31 r-I N N 01 O CO O N O Ln 00 Cr N ,-I r, ri 0 CO 00 C0 rI 0o r-I N Ln R R h h R CO' �� Cr 0 d' M I� CO 6 Cn 't 0 O N Lf) Lf) 0 00 r-I N N M N N N r-I N N rI N N r-I N NN N N, N NNin Ln -N > U '' > N u 0 0) Zo.<t��� ✓�!IIdYullllull„ Illlullll^ M M CO N r-I N N N r-I r-I CO LC) 0 L.n N fit' CO C0 L11 N 0 N M N N O M N N r-I d' r-I rI CO C0 LLn ct' Ln N �f)0 6) Ln C51 N CO00 N lO Lf) NN M (.6 O C7 N N N O 00 M h N,- N r-I co cos N I� M O � eq.O N N Lin 0 co ,-1 N H rI rI r-I rI N co Ln O m rI f31 r-I o 00 m co d' Ln 61 N Lfi m rl O O <fl Ln 00 �t 0 M ct' 00 M N 0 rI <0 C0 Cf7 SF Ln N Ti d' Ln Ln CU Ln O r-IrI rI r-I N 1-1rl ri rI r 1 Ln 00 00 Ln r-1 N r-I M N Cr) r-I 0 N M N t d' N r-I d' 0 in 0 in L() N Lf) co 00 N CO M Sr R R 0 R F t L L0 0 ci ai f Oh 7t. Ln <0 r-I rl Lf) ri Sr Lf) 0 0) r-I r-I rI r- I N rI r-I ri r-I r-1 r-I l„n Ln Ln � C0 � <O N N N N N N N N <0 C0 N -N > U N '- L N N C31 u o as a r6 C —. OZr�gI��aC���<C Yy� Lnl �IIIIIIIIIII'' r-I r-I O N 61 0 t N 0 LO 61 0 CO N C0 0 r-I L) N 00 r-I t 61 7r Ln N 0 rI M CO r-1 Ln 0 w h 00 h h h h h h h h m lO N Ln m M I'� t 0 LO O C51 Ln 00 N 0o N C31 N f O N M O rI O M M N M w w h h h h h h h h Ln C31 61 61 N d' CO f`` 00 00 61 Ln Ln Ln Ln LO co CO Co C0 CO C0 O 61 r, N rA fit M M up M O 00 00 61 71" O mot' N Ln M M Ln Ln O <O N N N Ln M Ln 0 h N h 00 h w O h 7h <O h <Oh N N c0 Ln dl 61 L0 N M Ln 01 N 7t N O M <O r-I r-I CO -1 CO M 01 '7f <O M N N r-1 r 1 L) 0) 0) CO N M M CO CO 01 61 CO 0 Sr Sr Sr Sr CO 61 Lf) O N r-I N r-I M M Kt' r-I r-I N N N mot' N .' N 0 00 01,-I N ,-I O M O M oo ,—I o d' .7t 00 N LO N ch d� L Cfl Lf) r-I 0 0 rI LC) Lf) Ln r-I r-I Sr O N 0 r-I CO N M N N r-I r-I 00 M '7t C31 r-I C0 Sr 01 Ln M M r-I (0 'Sr N CO N Ln d- co O m oo LO 00 co rl 0 CO ri Ln o Ln m N d' h h h h R w h h h R M m N N O r-I N N N C) N rl r-I rI ri r 1 N r 1 r-I r-I rI rI co h LnN co 61 O m C31 O h N r-i 00 00 Ln, M C rI Ln 0 0.) M M N NO h -I O M h N r-I r-I ri ,--I rr-i r-I � � h NCO N N r`' N N OZ0gLL <<-<C Ln T 0 © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. • rtf.li • A n. lysis u7 C.shFl.w r.j*cti.ns = C.ntinu. 00 00 d' N r-I M 00 Ln N N Ln M I- O Ln O Lf) r- ,A 00 0) Ln 0) N d1 00 O CO N r-I LO d' h h h h h h h h I- 0001 00 7 rl O Ln I� N M 7t CO Ln d' N M N M 7t O C31 0 r-I r-1 N 00 r1 r-I M d' M R h h w w h Oh O r-I r-I N M M Lf) LO 00 00 NNNNNNNNNN00 CO r-I Lf) 00 01 M Lf) L0 N IS) CO N 00 M N d' Ln Ln r-1 d- LO O O M M LO 61 r-I CO d' CX7 Ln cO LO h Ln h 61 h Ln h LM O h (Y R h O h N h d'h r-I 01 O 7t LO CO N O 01 r-I r-I Ln 00 r-I r-1 61 O Ln M 61 N r-I 00 h w w h r-I ri N r-1 N N rl r-I O LO m Ln o0 M d N C31 M ct' Ln lO r-I r-i M r-I M fit' r-I ct' 00 N d' M M LO N Ln LO Ln O O a (31 ���' R M h R R w co Ln C)i 71- r-I rr r 1 LO Ln r-I N O 1-0 0 m 00 00 C31 Ln N r 1 M ▪ O CO N m Ln Ln ON Or..10 00 Lf) N r-1 LO 61 m Ln LO N r-1 0 0 0 06 CO 0 0 r-1 r-1 ri r-I r-I r-I r-1 N co Ln rn r-1 O M O 0 0 Ln co O M Lc)h N h N 61 O h MLc?h h w rl1 h /�/1 h t 0 e 1LO oo cn i� N`1J/ co N N N Co 00 00 GO N C>0 co r.1 NJu N NI N. u ▪ O CU C C) (0 Q m s= OZ()�LL22 CO co 11-1I rAl dl" t~ 0 CO O d' C51 Ln tO N r1 M C31 00 CS1 Ln O LO r-I Cr N N CO Ln IN O d' 61 N M N 00 LO O mot' h R R R R h h h R R O I'` O N d' N M N N Ln LO O m d' d' Ln r-I 00 r-I Ln 61 61 00 r-I coLn C31 O O m m LO N h w w w w w w w w w w O r1 ri N N M M d' Ln Ln LO 00 00 00 00 00 00 00 00 00 00 00 61 ct' CO N LO r-I N d' N Lf) O N Ln Ln Ln Ln Ln o0 N 0 r-I N N M M d' M 0 01 Ln N Ln M h h h h h h h LO LO M N LO M Ln d' d' N LnM000�LOLONom� h R h r-I r-I r-I Ln Ln N lO r-I M 00 Ln LO Ln M ▪ N r-I rl N M N N LO M Ln ▪ d' ct d' r-I r-I M 6N1 LO fit' M m Ln r-I C31 LO 0N0 w � CX) I� Lfl Ln � � � O C31 M r-I M M M M ) r-I r1 r 1 LO r-I ri r-I r-I N r1 N LO O N LO LO M (31 N N d' a) N N N mot' rl d' O r-I C31 fit' 'ct 00 0 Cr) N LC) M fit' C31 LO N C31 r 1 Ln f r-I 01 LO CXi 00 00 N N 00 N N Ln r-I N N co LO M (51 L0 Ln d' r-I CO d' LO M Ln O 00 Ln N (Sl m I'` m co LO Ln r-I Ln LO CO M Ln r-i Ln L0 M N Ln Ln N O M LO 00 00 CO co M N Ln N co 00 co Co 0> 01 m C31 2 61 61 N N N N N N N 61 N -N > v N '- ,- >, f , N C31 u 0 CU C v( 0_ (0 C— D O z o- Li_ Q cG Q 00� L0 aO ��IIIIIIIIV�I 00 O M Ln 00 r-I M Ln CO r-I O O d- N CO O N CO CO N N O CO CO d' O CO 61 CO LO N N • Mh iris Lnh Oh OR O O O N N L) M 61 Ln N O N N d' N N M d' t LO r-I M Ln Ln w w w w w w w w w N I� 00 O O O O rI rI r-I N 00 CO CO 01 0) 01 01 61 01 Ol 01 CO N M N M M N N M M cr CO 01 ct- M H r-I N r-I O CO O 61 N O LO LO N LO d' M O Ln h h h h h h h 00 N N M Ln Ln d- Lf) (.O 61 L ) 00 N Lf) LO co co co .t Ln M Ln O Ln r-I N 0-1 h N O LO r-I O d' 0 01 N O N N r-I M IS) M 01 M N M M L.n L.n '4 r-i r-i r-i d- ‘4 M LO d' r-'I � rhM -I (31 (.0M O Ln �' m N' 0 N M dLsis M N r-I w w w ri (.0r-I O N r-I M r�-i Ln Ln co LO N LI) r-I ri �' Ln r-i N CO N r-I N C 0 00 61 O r-I LO 61 00 LO ct' Ln 6) d' mL 1 r-I M O 61 LO N N . cn d' h in N co Ln d' • LC) Lri Lfj rM-I Lf) Lf) Lfj Lf) Lfj GO 01 r-I O CO N Ln CO 01 N L0 O N fit' (S) Ln 00 O ClO N LO d' •7t O O N N O m 61 61 O d' O 00 O Ln o0 1Lnh N N Ln M N Ln M r1 d' N Ln Cg 0 C31 O O O O O O uM M iM > M u ▪ O 0) C C1) Q its c O z o Li_ c Q �G O OM cn 00 © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. '•rtf•li• i n.lysis • -rf 0 rm. nAK c O o a o 0 0 0 0 0 0 0 0 O O O O O O O O O O O O O o 0 0 o o 0 00 N <0 d M M M N N r-I M M r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I .7r • 00 l0 Ls) CO M O r-I O N r-I r-I r-I r-I r-I r-I r-I O o a o 0 0 0 0 0 0 0 0 O O O O O O O O O O O O O 0 0 0 0 0 0 0 0 0 0 0 • (0 (0N O 0o N N 01 <0 O N (0 Ln <0 <0 « Ln N <0 (0 (0 <0 <0 N o o o o m N LO r-I r-I r-I r-I r-I r-I r-I r-I r-I Q + + + + + + + + + + + Q Q a a a Q Q Q Q a Q Q Q Q a a a a a Q a Q Q Q (a (a (o (0 (0 (0 (0 (0 (0 (0 (0 f6 a Q Q Q a Q Q Q a a a a r-I al al I`<0 L.D. (n0 a1 0 M M N r-I r-I r-I r-I r-I r-I r-I r-I r-I N N L() d' Lf) M M N L(l M ,t co. O O NNNNCNINNNNNMM • o N al 0 00 0) N Ln Ln a) 01 <9 00 <0 0) N 0 0 d N Ol M M d' d' Lri Lti d' d d N N O 00 r-I 0 01 M 0 01 d' N d' M 01 0 0 00 <0 M r-I M Lf) 0 <0 0) I, • Lii d d' Lf) d' d' d N r-I O <0 N O O O r-1 IN O N O N d' r-I M O r-I 00 N 0) N I, d' 01 a) M M M M N N r-I N r-I r-I O O N 0) al 0) <0 0 4 0 <,0 ,.........I o u....a M N co (0 O N N CO O d' L0 O N d L0 <0 N Lf) L() <0 <0 N 0 r-I 00 L() 00 N 00 01 d' 00 I, d' <0 M N r-I N M N( r-I 00 M 00 00 M 01 O al O 01 01 00 00 00 CO <O I, r-I r-I N r-I r-I 00 0 r-I r-I 0 r-I N L(1 a) r-I M O o0 00 N r-I N 00 d' r-I r-I M M M N N N N N r-I r-I r-I r-I 71- O M d' N <0 <0 M Ol 00 L {) 0 r-I al 0 CO I, U1 <0 U1 Li) N M N N r-I N r-I r-I r-I r-I r-I r-I r-I r-I d' MMMMNNNN r-I NNNNNNNNNNNN O O r-I r-I O O r-I r-I O O r-I r-I M M M M M M M M M M M M 01 <0 M N (Si <0 M N al <0 M N O O O r-1 O O O r-1 O O O r-I IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII���0��0\\0��������������������\���M������I „ w IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII-III\\1\ \����\��\ �\�\�\ \ \������`�� ����\��\\\\\IMI IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII�II�����0��0��1���������������\IIII�0\�����'��������0���������\\\����\�■ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII=I ���������� ������������������� �\���\\\\\\\\\\\\\\\\\\I\\\\\\\\\\\\��\\\\\\\\\\\\\\\ IIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII�II�\�0��0�\��\\\\\\\\\\\\\\\\\��\\\\\\\\\\����1������\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\�■ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII=III\�0��0�\��\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\■■■ III MII\�0\\0�\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\0\10\\\1\1��\'������\\\0\\\\\1\\\\\\\\\ ■ • 1■ * Portfolio Allocation is a new addition to portfolio analysis. Data will be added over time. © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. '•rtf•li• i n.lysis *- o 1. *o • se ( (1) 0 C) (0 0) Lfl 111111111111111111111, N rNNOOmLr. N 71' 0 M h 0 LS) LS) LS) 00 M 1-1 CO I' 0 N • .7f .71 rri 0 o (Y) (Y) NLn rn u Lrc (,6 0- Ln 0 rec 0 N 00 rr) r—. Ln cyl (y) (\j71- N(Y) N Ln NN, rds O0NO LOLn N m L6 0 NI 0 N m 0 rei CNro- L6 r\I Ni (Y) (\I N- a) L-n i—i N co ,,I07r NCO - m 71- oo co i, i—i m NI co Ln i—i i—i L6 ,,- N' .0) iyi. N's ° Cis Lo Lc) 0 ,4 N cis LO LO .- 0) Ln ma' N N ,—I cei r\is i—i 0) rds L(5s N N M N .—I ,—I o-) 0 N m m LO (Ni cri .71 d Agency Pass Through Certificate of Deposit ca U a) © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. '.10- • DAIS • A411 D g cr) N N N N N N N r-I r-I co N N N 3 N ;•—•• L C 0 00 (Yi LC) rr) m 0 0 0 1.6 N E r, N 0 MORGAN STANLEY PVT BANK Certificate of Deposit LL (N▪ I N r-I N r-I N 0 0 - 1-1 LflL() CNN r-I N - N 0 0 - r-I ▪ cr) CNN r-I N r-I N 0 0 - r-I co ro • rri o cc) Ln c5 c5 0 0 0 0 0 0 LfL • k7t. N N (i) E E O co LflD N N r-1 N r-1 N N r-I r-1 0 JONESBORO ST BANK BANKUNITED NA (I) CA O 0 CL U) a) O 0 4- 4- O 0 cu a) 4, -I, fL5 4: CI-7 4J 4) cu 'crj • U co 71 - LI a_ 0) d' LI) 0 k.0 00 k.0 d" 0 cO 00 L00 \\ti © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. D.r • i• 00 A Last • I ! ays Cr*.itR.tin. M.nit.r 91I"' .^...I o o d' o' o d' m M m co M m co m M M m M m m m M M m m m co co N NNNNN NNNNNNNNNNNNNNNNNNNNNN 01 CO Ln I, N l0 10 M N N N N N N N N N N N N N N r-I r-1 r-1 r-1 r-I rl r-1 r-1 N ON r-1 N O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O lO LO 0 N • Zr Zr C31 CO CO 00 CO CO CO CO CO CO CO CO CO 00 00 CO CO 00 CO CO 0 oO O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 + + + < + + + + + + + + + + + + + + + + + + + + + + + < < < < < < < < < < < < < < < < < < < < < < Q Q Q Q Q < < < < < < < < < < < < < < < < < < < < < < Q Q Q Q Q o mot' 10 10 O r-1 10 10 M co co co M M O M N N r-I 0 0 N N N r-I 0 I, N M N N N N N r-I N N N N N N N N N N N N r-I N N N N N r-I N r-I N N N CO M 01 0101 Ln I, CO to N 11' N 01 CO I, 01 N co 10 Ln r 1 10 CO CO O co Go 10 NO N r-1 0 0 r-I 0 N 0 ON 0 r-1 0 r-1 0 0 0 0 N r-1 r-1 r 1 0 r-I N N r-I OLD rfi' M OM 10 M r-1 r-1 r-I 0 0 01 Ln Ln co GO CO Ln 00 Ln Ln LO CO CO CO M N 00 00 r-1 0 0 0 r-1 r-1 r-I r-1 r-I 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 + Q + + Q Q a a Q + + + + + + + + + + + + + + + + + + + + + + + Q Q Q Q Q Q Q Q a Q Q Q Q Q a Q Q Q Q Q Q Q a Q Q Q Q Q Q Q Q Q a Q Q Q Q Q Q a Q Q Q Q Q Q Q a Q 10 10 10 fit' mot' 10 0 0 d' COMM M M M O M N N r-1 0 0 N N N r-1 0 I0 N M 0 0 r-1 r-I N N NNNINNINN r-1 N NNNNNNNNNN r-I N N N N N r-I N r-I N NNNNNNN LO GO M O O 't' lO l4 Ln 01 lO N • 4 N 0 CO CO 01 CO N r-I CO N 00 I, N r-I CO 00 r-I CO d' CO CO 10 10 NON MN N 0 r-I r-I N O Si: N 0 N O r-1 r-1 0 O O N r-1 r-1 r-1 0 r-I N N N N N N N N N 01 CO Ln 10 M Z' O 1' d' r-1 r-1 r-I O 0 01 Ln Ln co CO co h o0 Ln LO CO CO 00 CO M N LO 01 r-I N CO l0 0 0 0 0 0 0 r-i 0 0 r-1 r-1 r-I r-I r-1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 r-I its ri 74 Rs' R2 2 r-1a ritcr. rCi RS c0 rt3 rt3 f6 r0 r0 rt3 rt3 rt5 its lLS gg lLi c[3 rt3 Q Q < Q Q Q Q Q Q Q Q Q Q Q Q rt3 rti ritt5s r«6s RaSs Q Q Q 0 0 0 0 0 0 0 M 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 M 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o Ln o o O o O o O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o O o 0 0 0 a 0 0 0 0 O Ln CV 0 0 0 0 0 Ln 0 0 0 0 0 Ln O 0 0 O a 0 10 Ln 0 0 0 O Ln Ln d d O o o l0 I' 0 0 0 Ln 0 CO 0 0 0 0 0 LO L11 0 0 Lfs O O N O O o mot' N Ln O Ln Ln o O l0 r-I M CO I, l0 CO GO 10 Ln 0 0 Ln CO CO CO r-1 Ln GO 0 LC) Ifs Lf1 CO 0 0 N <O CO Lf) r-I rl rl N r-I r-I r-I rl h r-I 0 r-I h 01 CO h 10 I, 1 M 00 01 r-I '0 Ln 0 LO Ln 0 LO Ln 01 LO CO I, Ln CO Ln M Ln LO CO CO CO l0 NMCOMNINNN CONN CONNCONN CONN CONNNINNNNNN CONINNNNN M r-1 r I N l0 r-1 GO r-1 O fit' 01 co -1 N Ln Ln M 00 I, Ln N LC) I, CO N 1 r-I r-I r-I M r-1 0 -1 CO O r-i r I O O 0 N M , 0 r-1 O O O O O -1 N r-I N N N r-I N N r-I N N N N Si) Si) N M M CO N M M CO N LO LO M r-I LOCO M LO 0 N N CO 01 r-1 Ln LO N CO r-I mot' CO Ln Ln LO 01 00 01 mot N LC) 01 r-I N '1' 00 0 0 0 0 0 0 0 0 0 0 r-1 r-1 r-1 0 0 -0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 0 0 Lf1 0 0 0 01 GO 0 0 00 Ln Ln 00 0 Ln 00 OLOM M CO L,Cy MO 01 LO 0 r-I GO LO LO Lf1 0 Lf1 Lf1 N 0 0 I, Ln 0 r-I CO I' CO Ln 00 0' N CO LC) 0' CO0 N r-1 l0 CO01 CO ct' 0 Ln d' LO1 N N N h GO N h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . r-1 LO GO '0 4 '0 r-1 LOI '0 4 4 4 4 GO 4 Ln O M 10 M h O O M N 0 CO 0 N N 10 O O O O r-1 O MASSACHUSETTS ST SCH BLDG AUTH ROCHESTER MN N E IA CMNTY CLG FEDERAL FARM CREDIT BANK FEDERAL FARM CREDIT BANK US TREASURY N/B SAN FRANCISCO CA CITY & CNTY OREGON ST FEDERAL HOME LOAN BANK CANADIAN CNTY OK INDEP SCH DIS FEDERAL FARM CREDIT BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK HENDERSON NV FEDERAL HOME LOAN BANK FEDERAL FARM CREDIT BANK TENN VALLEY AUTHORITY FEDERAL FARM CREDIT BANK FREDDIE MAC FREDDIE MAC FANNIE MAE FANNIE MAE FANNIE MAE FEDERAL FARM CREDIT BANK FEDERAL FARM CREDIT BANK FEDERAL FARM CREDIT BANK FANNIE MAE FANNIE MAE FEDERAL FARM CREDIT BANK FEDERAL FARM CREDIT BANK FEDERAL FARM CREDIT BANK US TREASURY NIB US TREASURY NIB US TREASURY NIB US TREASURY NIB US TREASURY NIB US TREASURY NIB ▪ Ta To To "To Q a !Z S? - V lJ U V V U U V V U V V U V U V V V V V U U V ••C C C C C C C C C C C C C C >= C C C v1 Lri in N to t/) C C f0 fQ (Li (Cf (6 rp rt3 N QJ CU N N N N N N N N N 4J QJ QJ CU N N N N N 4J N C31 o) �J C3) CT o) CJ7 C Y) C D Cal C Y) CY) C Y) d 1 di 01 C Y) di CY) d1 C Y) 01 01 C D CiU i1 N N iJ Q) Q Q F— 2 2 Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q �- �- 4 �- 576000ZG1 10 r1 177 771588WJ5 170 664214QD8 3133ERDMO 3133EP6K6 91282CJW2 ,N N CO r-1 Ln ✓ 1 r-I r-I 79773KBH6 co 120 68607LXQ5 3130B0X87 135537GZ5 3133EPH81 3130AXQZ4 3130AXQK7 CO l0 h Ln 0 01 r-1 N 01 Lf1 r-I r-I r-I r-I r-I 157 425201AZ3 3130AXEZ7 3133EPWP6 880591EW8 3133EPKKO 3134GX588 3134GXX58 co co M N ct' 31359MFJ7 3135G03U5 3135G05X7 od o �t M Lf1 r-I 3133ENWT3 3133ENXE5 3133ENZFO 31364FCB5 3136G4N74 3133EHWV1 3133ENTK6 oo Lf} Lf7 r-I Lf) 00 M oo Lf} 01 N 3133EPBR5 01 r-I 912828ZT0 91282CAM3 01 l0 M LO 91282CBJ9 01 r-I 91282CBQ3 M 10 91282CBZ3 91282CCW9 O1 © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. '•rtf•li• i n.lysis A Last • I ' ays Cr*.itR.tin. M.nit.r M M M M M M M M M M M m m MNNNN NNNNNNNN NNNNN NNNNN r-i r-I r-I r-I r-1 r-1 r-I r-i r-I r-I r-I r-I r-1 r 01 rn L.01, o O 0 0 O O 0 0 0 0 0 0 0 r-I 0 0 N 0 CO CO CO 00 00 00 CO CO CO 00 CO 00 00 N N N 00 O O 0 0 0 0 0 0 0 0 0 0 0 a r-I r-I r-I r-1 n nnnnnnnnnnnn + + + + + + + + + + + + + Q < a<<<<< Q Q a a< a< a<< Q<<< Q a a< a < Q a a 0 N N CO M N Or-1 r-I0 0 r-1 r-1 0 Q a Q Q a Q 01 01 N N N CD N O N N N N N r-I rI rI rI rI rl rI rI rI rI r-I rI N N N rI NNN NINNNNNNN NINNIN N N CO 01 lD l0 I3 0 Ln ID CO 13 in co r-1 CO in mot' O in O 01 M M co N r-1 0 0 N 0 r-1 r-1 r-1 r-1 N N M 0 0 r-1 Cr) N r-1 O N r-i r-i CO N Ln GO o r-I ID N Ln u1 GO M r-1 r-1 r-1 0 co CO CO CO N 0 N o O 0 0 r-1 0 0 r-I 0 0 0 0 0 r-I r-I r-I 0 0 0 0 0 0 0 + + + + + + + + + Q + + + Q Q Q Q Q Q Q Q Q Q Q < < < Q < < Q < < < Q Q Q < < Q < Q Q Q Q Q Q Q Q Q < Q < Q Q Q Q 0 N M M G l0 CO h 01 01 01 01 OMMO r-1 r-I N CO N N N N N N N N r-1 r-1 r-1 N N N N r-I r-I r-I r-I r-I r-I r-I NNNNNNN r I N N N N N N N N N N N NNN N d lfl CO N CO CII I, r-I M N N N in N r-I lD lD ld GO 01 in O co 13 in co r-1 co LC7 M 01 M GO oO NNN r-I N N N 0 N 00 N ON 0 0 ON O N r-I -1 , , N N 0 0 0 -1 O N r-I 0 CD lD N GO 01 r-I N O ON N N • 13 Ln O N • N 0 r-I 13 lD lD Ln Ln GO M N r-1 -1 0 CON hi'', 0 0 0 0 0 0 0 r-I r-I r-I r-I 0 0 0 -1 , , , 0 0 0 0 0 0 0 0 0 -O , , 0 0 0 0 (0 (0 (0 (0 ro ro R3 co (0 (o (o (6 r-I r-I N M M N r-I - 1 (o (o (o ro ro (o R3 (o N N rts rts ro ro ro ro m m rts rts (o ro (o ro ro ro ro (o (o rt3 ro rt3 rt3 (o (o (o (o co co Q < < < < < < <C < Q < Q < Q < Q < < < < Q <C < < < < Q < < < a a N (o co co r 1 Q Q Q Q o o O O O O O 0 O O 0 O O O O O O O O 0 O O O O O O O O O O O O O O O O O o o O O O O O O O O O O O O O O O O O 0 O O O O O O O O O O O O 0 O O a a 0 0 0 o 0 0 o 0 0 0 0 0 0 0 0 0 0 0 0 o O o 0 0 0 0 0 0 0 0 o a o 0 o a o 0 0 0 0 0 0 0 0 In o 0 0) 0 Lri. 10 o 0 0 0 0 o 10 0 0 o O O 0 0 o 10 0 10 0 0 0 Ln - o o a o 0 o LO o I3 0 Ln N r-I 0 I3 01 01 0 r-I in O O o a a 0 Ln 0 in I3 co O 10 o 0 o CO L.0 L.0 CO 0 0 ID , 01 N 0 r-I N M N t.D L0 -1 N fit' N in 0 0 0 in 0 CD M GO M f V I3 CO ND) rl rl rl r-I r-I r-I r-I GO ID CO CD ID Ln h l4 GO L.0 lD GO Ln lD 0) CO h CO rn 10 lD 0 CO Ln N Ln 13 in ID o co 0 1, 01 lD lD Ln ID NNNNNNQN NNNNN N N N N N N N N N N N M N N N N M N M N N N N N N 10 10 01 L0 Ln r-I Ln O r-I r-I 0 < 00 r-I < < in Ln < r-1 r-1 r-1 r-1 ID lD 01 N r-1 GO r-1 < O < < CD co oO < r-I r-I N <0 <0 M <0 m GO M CO M N O 0 0 <0 <0 0 O O r I O O N N N O N O O M O O N r I N 0 ON N GO DO < N 01 0 0 <0 N N GO ID 00 N N O O N • lD co I D L0 GO mot 13 r-1 0 O1 N 13 N CO L0 GO < r-i 0 0 0 0 0 0 0 < < < r-I 0 0 0 0 0 0 r-1 < 0 0 0 0 0 0 0 0 < < O r-1 0 < 0 0 0 < M 0 0 in 0 0 Ln M 0 M M 10 M o Ln M 10 o o r-i r-1 0 N Ln 00 CO 1n Ln I, 01 0 0 r-1 GO 0 CO 0 0 L0 0 0 I, in 10 N ID Ln CD lD 0 r-i M N ID 0 01 r-i 01 co in N N N m r-1 01 N 01 I, 0 r-1 I, 0 CO lD 0 d . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . GO GO M <0 N N <0 r-I r-I r-I r-I r-I N LO N r-1 r-1 L0 N O M r-1 M o' M M r-1 r-I r I r-I N r-1 r-1 r-1 O O N US TREASURY N/B 91282CDB4 US TREASURY N/B 91282CGL9 N 0 US TREASURY N/B 91282CGP0 US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B US TREASURY N/B SAN DIEGO CA CMNTY CLG DIST N E IA CMNTY CLG NEW YORK NY PORT AUTH OF NEW YORK & NEW JE PORT AUTH OF NEW YORK & NEW JE CALIFORNIA ST TAMPA BAY FL WTR REGL WTR SPLY SHAKOPEE MN INDEPSCH DIST#72 FEDERAL HOME LOAN BANK SAN JOSE CA UNIF SCH DIST SANT FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK UNIV OF WASHINGTON WA UNIV REV LOS ANGELES CA BENSENVILLE IL WISCONSIN STTRANSPRTN REVENUE ALTOONA PA AREA SCH DIST FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK VIRGINIA ST RESOURCES AUTH INF L L L L L L L L L L Q Q Q Q Q Q Q Q Q Q Q. a Q o V U U V V U U U V V V V V U 0 lJ 0 V V U U RS ro (o R3 (o R3 6 r6 (6 (Lf C C _ .= C C C C C _ S= Ft 91282CGV7 9128282A7 9128283V0 CON 0 I3 01 N 912828V98 912828YG9 GO GO 912828YM6 ID 912828YQ7 107 912828YU8 912828YY0 912828ZC7 797272QR5 664214PS6 64966QCE8 73358XDB5 73358XDC3 13063D2W7 875124GS2 819190WU9 3130ASGU7 798186P30 3130AS6N4 N M ,' • 0 MM l.0 N .,r 7r r-I r-I r-I r-I r-I r-I r-I in 186 3130AS5M7 3130ARVZ1 3130ARJH5 91523NWV4 3130APTE5 605581QQ3 Min in ir) <0 Cr) • O h r-I r-I r-I 148 544351PT0 082419F56 977123X94 l0 M r N r-I r-I 165 021807MB5 3130ANM64 3130ANFGO 3130ANAZ3 M r-I r-1 01 CO M 92818N5U8 0 r-1 © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. a a '•rtf•li• i n.lysis A Last • I ! ays Cr*.itR.tin. M.nit.r r-I G1 CO NNN LO Lf1 r-I-I r-I-I <0 G1 N O r-I r-1 0 O d PIN N 61 Gl 0 O O O 0 O r-1 r-1 , r-I r-I r-I r-1 , , , O 0 0 01 01 CO CO I, L0 Gt r 1 N N N NNNNNNNN N N r-I r-I r-I r-I r-I r-I r-I r-I 01I, 0 Lf1 Lf1 d' d' O r-1 MO CO GO d' LO 00 d' I, Gl d' CO O 0 r-1 N 0 O 0 r-1 0 N N r-I ,N N 0 0 O N O O O 1 h LO M M N N N N r-1 O I, N O G1 CO LO r-I G1 , 00 00 0 O O o O O O O r-I 0 O r-I O O O r-I O r-I O + + Q Q Q + + + + Q Q + + Q Q + + Q Q Q Q Q Q Q Q Q Q Q Q Q < Q Q Q Q Q Q Q Q Q Q Q Q a Q a Q Q Q Q a a Q Q Q Q a Q NNNNNQN N N NNNN r-I r-I r-I r-I r-I r-I r-I r-I Gl lO CO 0 M Lf1 GO 0, G1 M I' LO d' LO CO d' IO N GO N O O r-1 r-1 N N 0 r-1 O ,N N ,0 O N O O O N r 1 O O I, I, LO LO d' M M N N OM I' M 0 01 CO CO r 1 01 r-I CO O O O O O O O 00 r1 O O O r1 O O O r1 O rG O rt3 N r-1 Rf M 0 (0 r6 (6 (C1 0 r-I N N M (0 r-I , r 1 (0 0 rt3 rt5 rt3 (�S (t3 (6 (0 r6 r6 (t3 !6 (c (0 rC1 (0 (tS (3 (6 (Ci ([3 rt3 a Q Q a Q Q Q a s Q a < Q < Q a Q a Q Q a o o O O O o O O O O O O O O O O O O O O O o O o O o o O O o o O O O O O O O O O O O O O O O o 0 o O O O O O o O o o o o o o o o o o o o o o o o o o o o GO 0 0 0 0 0 0 0 0 0 o a Lf) O O GO a o a a o o GO a o 00 ,0 0 Lf1 O Lf1 Lrf O O o Lf1 r O o d' 0 Lf1 GO OM ON GO r N r Lr) If) N d' LO r CO Ln M CO CO ('M N LC) rG LO I, h r-I LO CO LO LO Gl l0 CO LO CO LS1 LS1 01 LC1 0 Lri I, 0 Lf1 r 1 GO GO dO CO d' l0 NNNNNNNNNNNNNQIN N M N M N N N N N N Gl O r-1 0 GO O Lf1 , , d' O r-1 , GO r-I r-I r-I r-I r-I N r1 , r1 MC') N M S. M r-I M r-I O 0 N N O O r I O O O O O r I O O O r 1 , r-1 LO in G1 CO M GO d' 4 r-1 r-1 N CO CON O r-I r 1 d' G1 CO N 00 N M O O O O O O O o O r-1 r-1 O O O r-I r 1 O O O O O r 1 o r 1 O Lr1 M LO Ln O O r-1 d' O LO r-1 LC1 IO O Gl O N lO IO M O I11 IO 111 CO 00 Ln N O O O Ln 111 IO Is, O N O M GO M O r r-i r-1 r-. O O r-. O GO O N N N N M M N N N d FEDERAL HOME LOAN BANK OREGON EDU DISTS FULL FAITH & WILLIAMSTON MI CMNTY SCHS SCH FEDERAL HOME LOAN BANK NORTHSIDE TX INDEP SCH DIST FEDERAL HOME LOAN BANK TEXAS ST A & M UNIV REVENUES SAN DIEGO CNTY CA REGL TRANSPR SAN DIEGO CNTY CA REGL TRANSPR FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK CINNAMINSON TWP NJ LOS ANGELES CA CMNTY CLG DIST MAGNOLIA TX INDEP SCH DIST CALIFORNIA ST DEPT OF WTR RESO OAK CREEK WI DOWNERS GROVE IL BIRMINGHAM AL WTRWKS BRD WTR R BAY AREA CA TOLL AUTH TOLL BRI FEDERAL HOME LOAN BANK DOWNTOWN SAVANNAH GA AUTH CALIFORNIA ST DEPT OF WTR RESO NEW YORK CITY NY TRANSITIONAL FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK (6 r6 rt3 (o (o o r6 R3 R3 R3 R3 R3 ITS (6 ro as as V U U V u V V u U V V u u u u v U u U V U U U V V 3130AN7C8 68587FAY0 970294DD3 3130AMUF7 M O d GI, 001 66702RZE5 3130ALU85 Lc) GO 88213ARR8 797400MR6 797400MT2 3130ALAA2 3130AKY26 �t GO GO 172513CN1 54438CYK2 559686WU0 M GO r-1 13067WRC8 671137C62 2607415L8 <Or, N LO 091096NE3 072024W57 CO GO r-I 3130AERV4 M CP N r r-I r-I LO 13067WPG1 64971WN89 3130A3GE8 313373B68 Ln O G N in Lr1 r-I r-I r-I r-I h FDIC -Insured brokered CDs are not included in the Credit Rating Monitor © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. '•rtf•li• i n.lysis • II II .yS*ct.r 0 0 ;: o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o 0 o r1 -+ ri N az m M a 0 o d 0 0 o O o o d d d d d d O d o 0 0 0 0 0 0 a 0 0 0 a O a a a 0 r ci o 0 N N d" Ln Ln l0 O lfl lfl r r Ol dl di r-I r-I m d' Ln lO N O � di r-I M M a � r r r r V O lO 61 r O � lQ O O O O O O O O O O O O O O r 1 :1 r i O r 1 N N N N N N N m h �t L -i Ln Ln M I� r r N N d" � l0 l0 l0 l0 l0 r r O 01 O N N M d' Ln lO r O O O Nu� l0 r C3 O N CO M CO CO O r �1' N� 0 0 0 0 0 0 0 0 0 0 0 0 0 r 1 N N N N N N c'rl c'�l �t `t Ln Ln CO I� r Cd O 01 Ol M Ln M O r O 00 r Ol ct O r-1 M N 0 O 't O O M 00 Ln �t lO M O O Ln r r �t Ln O lO Ln �t M O M M N st M M O 0 0 0 0 00 O O M CO r 00 00 O 0 r 0 r 0 C0 ri r lO 00 01 Ln O O Ln s4 .4 .t s,f .4 .4 .4 .t d M M M M M M M M M M M M M M M M M d M M M M r M C51 M M 0 01 r-1 01 Lfl �-+ Ln ,p To � �-+ 8 O O r C51 �t Ln r-1 O 01 'Li?) Cri O r-1 00 O r M M Ln 01 CO CO) c9 O 00 r 1 �? Ln �t 8 Ln Ln 00 N O �t O �t O M 4 d" N M 00 M N Ln 4 (t N N r N Ln . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Ln O M N a a M a N M M O a a a a a M (0 a 0 r-� 0 r-� r-1 �t d M �t M 0 0 �t cf. 7 �t Ln 0( 0 cf. 0 �t O ¢'� N ua^p ��y u•n Ln O CX] m rt ii•n M N r Ln d r-1 �f' O M M r r Lo �r Lr1 a1 rn c9 � a � o�to Call tQ rl O cYr-Il r I Lf} O c0 m r-N ri N r N r-I M Ln Ln O N Ln lO r Ln M N c1' M O O N ct r O O N O O 8 00 r-1 O Ln 4 N O O O O O M r-I 01 �h 4 O 00 Ci O O Ln M M M r-I O Ln �t N G' lO O Ol O d: 00 ri N r-I r r-I O 00 N r d �t 00 �1 lO M M O O O r-I N O N �t CO r-i Lc} Ln r-I O Ln C7; d7 d`t G� 01 I� � cT (Si cfl CO � � � Cq di 61 c0 0 0 0 g dl S g 1c O O O O O O O O O O O O O O O O O O O d 0 0 0 0 0 r-I 0 0 0 0 0 0 ri r-i r-I In O O O M N O o0 O O �t O O O N N M lO r-I Ln W O Ln �1 N CO 2 Ln 2 O N O O r lO M CO 01 O �t O� 0 0�� O O� O O M O 0 0 Ir. d1 O O O M O r O O O M Ln O� N 6� 0 0� LT). l0 O O O O O O O O N O O r-I O O O O r-i lO O N N r-i O dl 01 Ol 01 O d> 01 CO 6l O dl CO CO CO CO 0 0 0 0 0 n1 O O a y O O O O O O O n1 0 0 0 0 0 0 0 0 r-1 ' 0 0 0 0 0 r-I r-I ri ri ri ri ri ri r-i r-i r-I r-i r-i r-i r-i r-i r-i r-i r-i r-i r-i r-i r-i CO �D r 0 Ln r i t9 0 0 0 c 1 N r b1 ao r a 0 a M �t M M Ct 00 Ln N cD g N N d 7. r-1 c� o� 61 ,_.., r r� r� Ln o r o m o 61 rn rn 0 o Ln O M ., oo r m 11. N �. o m o�c71). O r o (y O rn R O O nj O Si O nj 0 ay M �y O O O rn 6 O r-i 6 r 01 O N cu51 `t So) N r o C0 t I 0 0 0 81 01 O O1 61 0 0 0 0 ri 0 0 d1 O �1 O O a 0 0 0 a 0 0 0 a1 r-1 0 0 0 0 r-I ri ri ri ri ri ri r-i r-i r-i r-i r-I r-i r-i ri ri r-i v a E a+i v a, E v E a3 E a E E E a+i E E v E E a E a, v a+i v a+i 12' :I;v a+i a+i ) L L L E v v E v E m m m m m Q m m m m Q m m m m m m m m m Q m m m <t m m m m m m m< m m m m< m m N r-1 r-I N N ri N N r-I ri ri ri N N N N \ \ N `t `t 61 O co Ln :1 ri Ln N N N c`n ` O\ c\n O N N r-I O r-I N O r-i r-I r-I r-i ri ri ri r-i 2 r-I Ln r-I c1 Ln r-I + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Q Q Q Q Q Q Q Q Q Q Q t Q Q Q Q Q Q Q Q Q d Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q d Q Q 0t Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q � ra ra rt � � � m � m ra � � r<s rt � ra ra co ro ro m m ro ra T T, ra r<s m ra ra rt r6 ra Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q m co ca ro ra r6 ra ra m as as rts ra rts ra � Q Q Q Q Q Q Q Q Q Q Q Q Q Q Ln Lr O ri M O mM rLLn uN1 u1 L, 0 M rI T Ln DM o (2 O L0n ca rn O0 Lr L02 cN LnN 00 o \ o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 � o o � � � o 0 0 0 � o 0 0 � r 1 O 01 r-1 M O0 (0 r 1 H Ln 00 Ln Lf} 00 Ln r 00 01 M 01 Ln C0 CO Lf} r I N CO r-I 0 r r r r M Ln r Ln 4' r( r . . r-I r-I O r-1 N O r-I r-I r-I 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 r-1 N O r-I O O O O O N 0 0 0 r-I r-1 O V Q 0 0 FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK z Y Y z Y Y Q Z Z Q Z Z < m <L Q m < < m F- CO m , CO m 0 0 0 0 a s 0 V O O V 0 0 v w O o w L.L.2 I L.L. D' •' c''71 W 0 0 0 0 LLILLILLILLI W W O O W Q L J J C J < < W < w w Z w w w w w <( OOZO L L L L L L L L L FEDERAL HOME LOAN BANK FEDERAL FARM CREDIT BANK FANNIE MAE FEDERAL FARM CREDIT BANK FEDERAL FARM CREDIT BANK FEDERAL FARM CREDIT BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK Ln �1 Urf. O O > lrLn CO E Ln r Ln r0 rrLn `t rw�� w�Y � Y� N� O' N o0VW XLnX Z O Z � Z v5 O W Y J Z M J Z Z Z = c`' a_ a_ > O_ � L D_ X Z d � X� � X O w Q 0 W 0 0 0 rn w Q 0 0 0 Q <C <t Q r Q Q W <C W Q Q W of Q Q of W Q W 01 W W Q Q W Q m M 0 M Ln O O Ln M O 0 CD Ln O O O O M O O M O M O O M N O O l0 M O M Ln M M O O M O O M M M M M M O M M M M M M M M M M M M M M M M M M d M M M M M M M M M M M M M M 1 r-1 r-1 r-1 r-1 r-1 r-1 GJ r-1 r-1 r-1 r-1 r l r-1 Cr-1 r-I ri r-I r-1 r-1 'CT r-I r-I r-I r-I r-1 ri M M ri r-1 1 r-1 r-1 -I M M M M M M M �JJ M M M M M COMM M M M M M M M M M M M M M M M COM COM M M M M M M M M a7 Nr-I MN 0N0 O M-NM M CM O1' rni LLn r-�1 MrrrN-I Lrrn LdCO MGt7 CUO0 NOl 0Ln1 l0O1 0 0 00 0 0 0 0 0 0 0 0 lO dl CO N d" � l0 0 �t lO CO Ln dl dl N N N 00 R sj O O O r-I N N N N N N N N N N N N M (. ( d" M Lk 00 M l0 r r 01 m M «t �t Ln O lO r r r r 00 CO CO CO r-1 r-1 r-1 r-1 r-1 CO :t N N M r .1 rn m M r Ln r 61 lfl r-1 r-I r-I -I Ol Ol dl dl r-I 61 61 CSl 01 N N N N N 0 M M M M 0 0 0 01 0t r 01 N r N r-1 r �t M 001 lM 61 NO M O N M O. r-. M . M. . a. sOOl. O LO r 61 N 01 00 mot' 00 Ol Ln Ln l0 l0 A ri r r �t M 1 Ln r-I M O r r r r Ol Ln r d O M 00 00 00 r-I 01 00 00 r lO lO g 00 00 00 00 g 00 CO 1c r 01 01 01 N O O al O � � � � O O al dl � � ao � � al lO N O Lr O(a) SNl O N MN O 4 N COO SV OO Ol O r-I r-I N O O O N ri N N �1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 r-I r-i � r-i r-i r-i r-I r-I ri r-i ri r-i r-I ri � ri ri ri ri ri r 0 r-I r-I Sil0 �t CO M r-I r-I O �t 00 O M O « O lfl 8 Ol0 N �11 Ln Ol �t LO C1 : 1 2 Ol M N M 0t 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 r-i r-i � r-i r-i r-i r-I r-I ri r-i ri r-i r-I ri � ri ri ri ri ri r-I r-i r-I �1' Ln lO lO Ol 61 Ol 00 00 Ca CD Ol Ol O O O O r-I r-i r-i r-i r-i r-I r-i r-i r-I r-1 00 O1 G0 O N N N r 1 Ol Ol M lO r CO O r-I r-i N O r-i O M N r-i O N N M O r-I M Ol �1 00 O r 1 r-I r i N O1 r 1 N M �t 01 O1 r 1 r 1 O r-I r-i 0 0 0 0 r-I 0 0 r-i r-i O r-I O O O O O 61 M r r r r-1 00 O � al r-1 Ln Ln r N r-1 Ln M O r al M N dl dl dl r � r-i M :11 CO OCO 61 M W N � lO Ln M N rl M �t M � M O �t M r-I M M M r lO r-I N N N 00 N dl 60 O ri lS7 lO lO O r I r-I N N N N N M M M M Ln Ln Ln Ln lO N N N N M M M M M M M M M M M M M M M M M r-1 r-1 r-1 r-i r-1 r1 r-i r-1 r-1 r-1 ?DI r-1 r-1 r-1 r-1 r-1 r-I r-1 r-I r-1 r-1 O O O O O O O O O O O O O O O O O O O O O M r-I r-I N CO � r N Ln <O l0 O1 r-I r-I M M N O O r-I N o r-1 r-1 r-1 O O o 0 0 0 0 0 0 0 0 0 0 r-1 r-I r-I o 0 0 0 0 0 0 0 0 0 0 0 0 0 o d o 0 0 0 0 O O O Ln Fr') Fr), O L1 Ln Ln Ln O Lc) Ln O O O Ln Ln FA' O Freddie Mac o � o 0 0 0 0� o 0 0 0 0 � o O O O O rI O O rI rI O N 0 0 0 rI rI M rI rI N O O O O O O O O O O O O O O O O O O O rI Freddie Mac O1 X r-1 r-1 ra Li N d N d N r M1 c � c Li Li Li r-i V 61 l6 N � Y J 0 0 M M UJ f6 r6 OO M M c6 r-1 N N N c c c mot' V C) O Fly) ri X ri 2 0 r-1 ri > V r-1 0 r-1 N N N c c c Li Li Li C0 X 0 r-1 r-1 00 0 h OD O d- �t l6 N c c� L 00 Ln Y r-1 Q1 Q1 00 r V rn X 0 r-1 r-1 O N Ol N �t Ln 00 r Ol d r-1 M d" r Ol 00 O O Ln r r W CA 00 00 00 CO Ol rn Ol Ol Ol 61 dl O O r-1 r-1 r-1 r-1 r-1 -1 r-1 r-1 r-1 r-I r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-1 N N © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. '•rtf•li• A n.lysis • II II .yS*ct.r 0 4 O O O O o d O 0 0 0 0 0 0 d O d d O 0 0 0 0 0 0 0 0 d d d d O d O 0 0 0 0 d O 0 d 0 0 0 0 0 0 0 0 0 0 0 a 0 0 0 0 0 0 o:d 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0i d 0 0 0 0 0 M �t O 01 O O O r c,0 M O 0 0 0 M CX3 00 r-I r-i 0 0 0 r-1 r-I 0 01 0 0 O O 0 O O 1S) 1&' O 01 Ll) Lf) O O 0 I.r1 O O 1.n O 1.n �t 71 01 0 `Lb' i.r) O O 1.n Cn - O Ln o Lfi. 0 00 01 m �? M N M r I M M N N I!) aI) 0 O O CO O N O l0 0 N N O 0 r r r m m O 0 0 O 0 N O1 O O O1 00 0 C0 0 M i.t') 0 CO M N N 00 0 0 0 Sri Sri 0 Sri 0 1si u-i 0 1.s-i ui Lri iri 0 cri 1si Lri r-i 1si 1 ri d i ri ui 1 ri Lri 0 ISi 0 0 1.1i 0 0 0 1ri r-i 0 0 0 ri ri N O C9 O m 01 r-i O 0 N N N M M M M 0 0 0 0 0 0 O 0 l0 m r r r r 0 03 O1 O O O d 0 0 0 O N M d 0 r l0 l0 l0 r r 00 0 0 0 N N M 0 0 0 0 0 M O O O O O O O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 r-1 r-1 r-1 r-1 r-1 r-1 r--1 r-1 � �--1 r-I r-I r-I r-I r-I r-I r-I r-I N N N N N N O N N N M m m O 12 N N M M M M 0 0 0 0 0 l0 l0 CO CO CO r r m 00 C31 O O O N M l0 r r r r CO CO 61 r-1 r-1 N t �t l0 l0 l0 r M �fi O O o 0 0 0 0 0 d O o 0 0 0 0 0 0 0 0 0 0 0 0 o d 0 0 r 1 r-i r i r i r i r-i r-1 (r- 1 -+ '4 r-1 r-1 r-1 r-1 , r-1 21 r-1 N N N N N N N N N N M m N V r N d' N M ri �i 00 r o0 00 00 N 0 r O r 01 N N CO N 00 0 O O Ln r Ln Cfl (an, CO 03 et M dl Cfl r CO l0 Ln Ln Ln 0• M M r-1 N 0 N M u) M l0 lO r L0 r 00 0 00 r r 0 r 0 0 0 0 0 0 0 M N M N N N 0 0 0 r 1 m 01 01 (71 Ol Ol 61 O1 O1 (b m m CYJ CYJ lac)) lac)) 00 r m (b lb (b CO CO CO CO C 6 CX) r r l0 o .t o o o o o o of .t .t o o o o o o o o oo �t �t M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M r M r-M1 0") I¢b M r-i 0 ) III N r-i O r 01 00N1COOM1M 4Ir 8uO Nir;rrm.M(LrCr0O Ou� ON 1i1) OMN Nr t0NO N) N0r0 r-1 rl rl N rl N u..ry r-I r-I 6,0 N M N N r-I r N CO" N CC M 1-0 a 0, r r-1 'CI rn 8 rn u� M -I a) d" v•••••II rNv••••• m r I r rt d 61 N r Ol S61 Ol •�3. 61 M r-I m M M 0 r 0 00 d' N rn r rn N � m M m m ri �' M � M r-i r-I Cil C31 Ol Gt O r-I Lr) cc] M M � l0 M M CX) Lr) P. o0 r-I Ol r-I f>D r-I O N r.T' �t r m N r-1 00 N M r-I N l0 N �t r l0 O O O r-I O� ri � N N : M U7 m � ct 01 m r CO � N Cif m �t r CYJ m O � M r m m CYJ �� O r-I O l0 m O CO � l4 m �fi m O O r8 CO O O O 0 0 0 0 0 0 0 O O 0 0 0 0 d d d rI ri ri O 8 ri ri N M o o N N 2 2 N C)j CX) CSi � � � Cfl Lrl Lrl fit' Lri Sri et �1 CO cc); C70 0 0 0 0 0 O O O O 0 0 0 0 0 0 0 0 . 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Cn 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 r-I ri ri ri ri ri r-i r-I r-I r-i r-i r-i r-i r-i r-i r-I r-i r-I r-i r-i r-i r-i r-i r-i r-i r-i ri ri r-i r-i r-i ri r-I r-I r-i r-i ri ri ri ri ri 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o d o 0 0 0 0 0 o d O o d o 0 0 0 0 0 0 0 o O o 0 0 °c4) O o o O O O o o O o O O o O O O O o o O o 0 0 o 0 0 0 O O O O O O O 0 ci d 0 0 d 0 0 d d 0 d 0 d 0 ci o a' � d d d O ci 0 0 0 d d o d o 0 O ci d 0 d d d 0 ci o d d 0 o d o d 0 d d ci d ci 0 0 0 0 o 0 0 0 0 0 0 0 0 0 o 0 0 0 0 0 0 0 0 0 0 0 o d o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o p o m o 0 0 0 0 0 0 0 0 0 0 11, o d o p o o d o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O o 0 0 o r o m o 0 0 0 0 0 0 0 0 0 0 61 O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 0 0 0 0 0; o 0 0 0 0 0 0 0 0 0 o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o d o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 r-1 r-1 r-1 r-1 r-1 01 r-1 � r-1 r-1 r-i r-i r-i r-1 r-1 r-1 r-1 r-1 r-I � r-1 r-1 r-1 � r-i r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-I r-I r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-1 r-1 �t N N N M 5 M 0 M 0• 0 M M M N 0. M O 0 M O 0 0 0 M N N N N N O 0• <71 0 O N e1 0 0 0 0 0 N 0 M 0 M �1 N N N 0 0 M N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N O N 00 0 O l0 r-I (3 0 O M r O O r-1 r I r I O M r Cr r CO (r i r-1 r m CYJ r r-I r-1 M C O O r r 00 r 8 N r 0 N N 0 m O O 01 O l0 M N O r-I N N O O O O r-i N N O O O O O N r-I N O -I N I I r-I N I r-I r-I CO r I r I ri l0 r N r N CX) N CO c9 l0 O O O �Ci N r I lO CO N r CO Lf) l0 m O O O O r-I N l0 N N ui N N l0 l0 r r Cp Ol O �f) r I C0 m M Cfi ii7 m r I N iS) O rI r1 r1 O O O O 0 0 0 0 0 0 0 r-1 ri 0 0 rI O O ri O d 0 0 0 ri rI ri ri ri rI 0 0 0 0 ri ri 0 0 0 0 0 0 rI O rI 0 0 0 0 0 0 0 0 0 O O O O O O O O O O O O O O O O O O O O O O O O O O O Op O O O O O O O O O O O O O O O O O O O O p O O O O O O O O O O O O O OO O O O O O O O O O O O O O O O O O O O O p O O O O O O O O O O O O O O O O O O O O p d d O O O O O O 0 0 0 0 0 o d o 0 0 0 0 0 0 0 0 0 0 0 0 0 o d o 0 0 0 0 0 0 0 0 0 0 0 0 0 o d o 0 0 0 0 0 o d o 0 0 0 0 0 0 O O O 00 CO d O M (X) M Lr) CO 00 M,f) M � lS) 0 Lf1 Lr} M Lf1 Lr) M Ln O1 m Cr O1 M d d d d p M d M �t d- �t d �t �t �t d, d M �t d N O G �t �t p g 4) �t �t V g g g G O �t g ,t ' N N, N N N N N �1 N N N N N r-I N N N r-i N N N N N N N N N N N N N � N N N N Ct N N N N N N N N Lc?) N N N N N N N N N � N N N N N N N N v t; v a) v v a) v a) t; v t v v v v v v v cr.; t ru v a) a) a) a) v v m v m m m m m m m m m m m m m m m m m m m m Q m m m m m m m m m m m m Q m m m m m m m m m m m m m m m m m m d m m m m m m N N N 01 I I I O r-I O r-I r-i r-•I © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. ri r-I ri 0-1 0t 't 03 03 03 03 03 03 03 03 03 03 03 03 u) u) ui ui 03 Lr) Cn 03 03 03 In 1n an 1n 1n 03 an 03 03 03 CO l0 l0 m l0 l0 l0 l0 l0 CO l0 l0 l0 t0 r r r r r r r C0 03 03 N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N r 00 01 01 O r r I r (X) r I IS1 r r r I (?, .°2 r 1 CO Ol L) ) N O o0 r 1 II) CO fX) M r i C<3 N N d r-I 111 l0 Ol Lf1 M O N l0 O 00 (b r 1 is) 00 C31 M l0 O O N O M O r-I N N r-I N N N N N O O r-I N r-I r N M N M r-I N N O N O O N r-I r-I N N r-i r-i r-I N N r-I r-I r-I r-I O ri M O r-i O r-I r-I N N r-I O r i r i N N r i r I r I r I N N M M M f Lfi iI) �1) 11i CO CO m t 0 r r M (YJ (XJ O O r i r-I r i N N r i r I 111 l0 l0 l0 l0 r r a0 is r i r-1 r-I N N ct i1) 11i 11l O l0 r i NO O 1 O r-i r-i r-i r-i r-i O O O O O O O O O O O O O O O O O O O O O O O r-I r-i r-i r-1 r-i r-i r-i O O O O O O O O O O O r-i r-1 r-1 O O O O O O O CO f O Cr) `cc,' O O 0 0 0 LS) O Lr1 O 0 i-f') L O 0r•) O- d 0 O Lr) 0 O O 0 0 0 0 O O O O 0 i-t1 O O 0 0 ul O Lr) O Lr) O 0 0 0 L(1 0 0 0 0 O -1 I-fi O r ", d" r 01 0 03 N 0 N N N'0 M M (0 03 Lr) O O 0) O M 03 CO r N N O d: r r r 01 l0 r-1 ) (0 O (0 N 01 C�r.}. O 01 00 0) l0 W N 0) l0 CO M N N 00 03 ri 0) d fV �rl d 0 0t (r•) u1 O u1 O 0 0n u1 u1 Lr) u1 u7 u1 M Lit Lr) ri 0n u1 O O 0 (0 ui 0 0 0 0t 00 0 0 0 O u') O d- d V 0 0 0 O 0 Lr) d- 0 0 M M M 0 0 d �t o e e e o 0 0 0 0 0 0 0 0 0 0 0 0 0 o 0 0 0 e o e e o e o 0 0 0 0 e o e o 0 0 e o o e e o o e o 0 0 o 0 0 •dam CO M M M M M M N M rI M M r1 M M M M M M M M M M M M N d' M M M r1 M Lo M M M M M M M M Ln M M M M M M m M M W M M M M M M M M d o o ci d ci d d 0 0 ri o d o 0 d d d d d d d d d o 0 0 d d d d ri d d o d d d 0 d d 0 d 0 0 d d d d d o ci r1 0 d o ci 0 ci d d CORP AMERICA FAMILY CU w } Z mi) Z Z < C z ZY O0 0 Y Q I�—mUw Qw Z 0 Z QU mOwZ mo OO= H`Xn UYQV mmO 0Xw 0 QzQ< UQote ZQm JZ2 ~ OZ g ts/)o Q JQ OOQ lw °C V Q Lip z O V � YQ°Q7° wLQQi Zo~OIz�n oYQwUQc (Lj w w N H J O w W J Q w W HN1LTIHNIILDAM5MAini0AWIEIWTH 00 d-r r 01O= r mM�� r-I�M �t �r r-I CDCX)N l0 p d m N 2 �m d� O'Q>Q> 2 � m�Q =�U w Q� u- l7�w� O' Q Z Q > a -1v) >Q L7 m l� O1 lOd' > YQ> �- O' N=�S' l7dO Q r Q Od_=Q 01 J d" (Yr1 O lfl >J} J NZli) Lf) L!) Lr) Oi �tOr irhOtAWAhMOMFOVAMH O d CO r I N CO M r r r CJl r CYJ r CYJ O lO t0 r-I r-I O O O r-1 Ln Ln M 03 O N 03 01 l0 d" 00 d r r u1 r r I lr) m d M CYJCj r Ir I l0 Nd 00Lf} CYJ dd CA r i i000Lf) r i r it0 r iCYJdM Ol0NOMO OO 0 M M 0 0103 r M 03N MO O 0000 rM u1 0lM M COO 03 rl0 01 01M l0r03N 00r)03ONO d�1 O CO N O r I CO 03 rCb rM lO OM MN N 03O d" r03 03 Ol0 d' d"O M C31CSMo0OLr)r �tO L!) d 01 L11 M O O CO m r I r I O N M d O O M 01 M r I N O O 03 N M M r Cb 03 00 M N 00 O M N MORGAN STANLEY PVT BANK ri 00 lfl r-i ALABAMA CREDIT UNION BMO BANK NA l0 d' CO N N O (0 d" Cfl 0t O 0) N r-I M r-I O O rram�.M �t l0 CO r-I Ct r O Ol N 00 r-I r rr % r-1 M CO r m 01 r I N 1 r) CO r 01 0) M CO r r I N M Lf) r UO O N M W (T O r I N CO r 01 C!J O N M lO r CYJ 61 r I l0 O O O O r I r I r I r I r I N N M M 4 ,,• r 01 0 0 0 0 0 03 N N N N N N M M M M d" d" d" d" 03 03 U1 (0 (0 (0 1s) l0 l0 C.0 CO CO CO l0 )0 rb )0 )0 )0 Cb M 01 01 03 03 0 0 03 03 03 03 03 0 0 0 0 '•rtf•li• A n.lysis • * * A W gr 00 0 0e) g` ((;.' rc;' 0c)0c)rc-)i cc;i (cN,i „ (c-)i ccyz,) \t! (4-) (4-) LT, ic; c)3 Lr,' cri (7,t- cr° c),°, c(,) cryn, crin, r'n) Li), Lryc), r;',_ (.4 r,7 z't • Lr-r)i Lu-n, 7,-; ° (T) cu.') 'Lc') c.°) ° cc'Di rcr,) ec° cc'DD cr2 Lrc,' rr-,i cr° 0 (7-) cr,°, cr° (r,n, (4. Fs), (• L3,-)) (;,/ g 8 5 `c:'') 8 EP) L'_)! [No 2 8 'cf.) 8 g 8 2 Lr&' (c),, R(,) RI 74 8 2 2' 8 8 28 8 8 g 2 g 8 2 28 5 2 2 2 8 cc 39) i.`) r(),) 2 8 8 Po ') 8 8 2 2 '2 2 2 00000000000000 ,f ,f ,f ,f cf cf cf ,t rri rei (.6 cri ,c cri cri cri ori Pri re; rvi ,c ,t cf $ 2 2 8 LCS rn) .L7 .) 2 IC,' 2 ral 28 78 8 al (%' 5 2 8 8 8 CO 2 8 g.) i5)) 2.2 2 ,Q 2 oNo' 2 2 5 2 (T 2 2 2 5 CO,8 8 2 (cn) ,f ,t cf cf Lri ct: cf cf cr cr Lri 0 cf ,f 0 rr-i d (Ni d 0 0 rvi d r-i 0 0r-i r-i ,t r-i r-i0 0 0 0 0 0 0 ,t 0 0 Lri 0 ,t 0 0 0 0 0 r.; C • C4 (7, L, C:21- 7,1- 51- C'C 2- r?-9 8 8 8 8 8 8 8 8 8 8 8 8 8 d d d d d ci d d d d d d 2 2 2 2 2 2 2 2 2 2 2 2 2 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8. (ci• c(ir,c_p':,9))LA'(;.1,9(i:AFOL;:,Pci o rn IN CO Q0, 0 Ln c; g4). 'Ai LI' C CO N 7F 01- lb' 7r- r_H.- rrc Ls5' r-i • Cr) r L-T, `rlit ,L,r),) Li) r`El (1,) (," L,&) m m " °,-° 0, •-t. 8 8 cc (5 )5 I, (61 (3)L6 cnui c3,1-6 cs,L6 cn`ri 0)(.6 8 8 8 8 0;1 blh 8. 8 8. 8. 21-. 2L6 &31-. 6 6'1 51' L,,i'L2N th' cy) 80 8`2?85c)2 Rl 0 TLLL82 8 8 0 9(rps ru(1c\o1e?r .! . rr1 . T,Tr(0 rt ?), cr8, g9' (0,1 ?), §) cr8, (- c)i r° g T), P, (?),' g L°g g erc(),) 8 8 8 8 Ri to 8 8. 8 8 'A' 8 8 8 2 8 2 8 8 8 0- 2 5 2 g 2 2 2 2 4 ro-,) 2 (To g 2 c-oi 2 8. 8. 0 0 r8, r8, § (7)1 2 0(02 2 2 2 2 ?), 2 2 1 51,1 c't0 P, 28 o8 0 0 0 28 28 28 28 0 0 0 crL § c§, 0 0 0 0 0 0 0 0 0 0 0 0 rj` g Lg L`r5 r"2: g rc?: g (r‘i g 8- 50; E?) 2. r`r-iS ,L1 7_1' crL r)) LLT, 77.- M it; t t t; ▪ ti; t; t; +cr) ttttt tttt (i 3 t 4a1 ,22,2,2.fcc20,20,220 c,) rf,D (4 rfz. T,10 (r<oZoZ<<' r<' :(7 (.ij ' (<`11 :c(12 (:`21 ' <<<< Q1 .CC12 Qj 71 1 Irr LW' c:P 'c! ) c''? gr9 c3r,:11 ,f Lri •st: ,t ,t ,c ,f ,t to, ,t ,toj r r d r d d r rr-iof Lri r-i r-i tri ni ni Lri rd Ls; Lri ni Lri rtsr 4 4- c-.5 (.';`," A A A' c`in' A A' 1- • eAA44 '0 '0 '0 4 '0 AArgg 4AAgggg4 gggggg44rg Vg d c5.--iddddddddddd010 d 0 dcidddddddddr-iddddddddciddddddddcidddcidr-idddcitll-citS''d 5 0• 0(0 (r) UNITED FIDELITY BK FSB 0 z OLD NAT CHK OLD NAT SVGS First American Treasury Obliga 2Fs-t9cfc(L.,'1_,, NLaLcr.-7 5 - EuLQt,, tL,1FsLji 1 . L>'a''(I 4Li, ,06 1 H 217 5 0iiL3IqL<.(0(0 ii u -T° Ers2- , ! cI,- 1 ';t6 j6 ,6 -.,2,9 - a-z ar' E ',,<g! - -<6_-ZzZY52I- (L9‘,.°) ,„cd-EZ)1,• I.9.-7l. -‹-Cz 1 ''' E 1 ', -; -g ili ,., (' 2 5. ., E 8 8 .(1) 3 ,•! F2, P-t P -.`!. 1 i`i L) ) .c- 00,,,,i,_ 2 '-ci- 8-2i9v!''.<,..(LIL:',)I,Izih,(isz.L'Az52._°80'-§Ag.-.)F,,-,L-c- ---i,-,,)2,--)--'2,26-,,i2LLeti,--,,, Small Business Administration US TREASURY NUB g0 - >c<31-3;1 LCS'' ci) Lct' cr3 rj9I rj (7) LC2 2 rvo -t 2, cp cL 3 2 r-- (L11 LT, Lc2 00 S 0 L)) L%.) Lccf?),_ N 00 CO CY C cr id4k rc:,) N cirrl 1111 rrO) L§) Lcccil 'A 1 .c3 Ln tEl cc' 28 eLr?)) LL'sA Fr',1 cc•L )C1 F,1 'r,tilirH) trail :7: LYI rc-Ld V'cf9) coc'),° 11 dr1 c'08) cLL Fri cna,L) cri Fir iLrA cLA c, „ r0 ra_0) `,1 `,1 ,c(0, `,911) 00) 00 Lri 00 CO L7f_il, LZ, :c91 `,j9i) © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. Der •i* • gggg ca, )°cc(7.1 cc,) cNn L ,, nr, :• ry, (c;) (;) 0 ic; 0 0 0 0 0 0 0 0 0 0 cc?, 0 'cro, ori 0 ri 0 0 0 0 0 0 0 0 nri cL.8 •`,D, GL g g F1-1 PI `(-:1 00000000000000 Fii"Ii3 3 3 o o r-1- Ln 0 7,1 r'503 (cyl 03 03 00 1c.i 2 803 rLY8 03 C) (0\01 P) g c,s3, ',I,' 2, 1,§,1 ccSi r??( rr0000000000000 § § § § § § § § § § § § § § § § § § §§, 0) cr crl 0000P, §L?,- t ttIi.;tt'tt'tt'tt'ttt'tt't 2 2 2 2 2 2 2 2 ,2 c:2 c:2 cp cp cTi Et;<00<<<<<<<<<<<3Z<0Zc zzzzzzzzzzzzzzzzzzz' DDDDDDDDDDDDDDDDD• DD F- F- F- F- F- F- F- F- F- F- F- F- F- F- F- F- F- F- F— L) L) L) 110 '3 6 S (.,`-"co ccZpo ccc,1 cco'l coNuU• UU „, 01 01 01 01 01 01 01 01 01 01 0, 01 © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. r •i* � siti . ns . y M. turity O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 �N 0 0 0 0 0 0 0 0 O O O O O O O a 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 , o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0°, 0 0 0 0 0 0 0 0 d 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0>; 0 0 0 0 0 O O O O O 03 r-I N N N N N N M M M M M M M d' 0 0 Ln Ln Lf) Ln (.0 L.r) C0 C0 'D. C0 C0 0 0 (.0 r r r r r r OO C 0 0 0 0 0 0 0 O CI. CD. 03 0 000000000000000000000000000000• 00000000000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 03 4 r-r-r-I r-I r-I O O O O O r-3 r-I N N N N N N M M m m m m M C'f: d: 0 0 0 Ln 0 Ln. O O O l0 C0 03 CC) CC) C0 L9 r r r r r r r .0 00 00 CO a) a1 a`) a) 6) O O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . N. . . . N. N. N. . . . . . . . . . . . 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0, r-1 0 0 r-I r-I 3 Ln Ln Ln N r-I 00 03 Ct r M N CO Ct 0 N N M r-I .71. Ct CO r 01 Ct 03 00 CO M N N Ln r r-I r M 0 r 0 03 0 a) N N r C0 M N CO 01 HI 0 0 0 CO r CO Sri Ct Ln r Lr) C0 r r r m l0 CO r 0 l0 CO r C0 00 r al rn 00 r r Ln Ln r LC) Ct d: d' d' d' Ct M 0 M 'St Ct M Ct M N N 03 N M N M N M N r-I N r-I r-I M r-I 0 01 a) + HI 0) 0) a) (3) Ct Ct Ct d Ct Ct d d d d Ct Ct Ct Ct Ct Ct Ct d d d d Ct Ct Ct Ct Ct d d d Ct Ct M M Ct M M M M Ln Ln Ln o r i 71- o r O M lfl O l4 N M o Ct O Co r-I C51 M o0 oO m r-I M O al r-I al r-1 in in al N r-1 r-1 r-1 Ct O al v. in r-1 CO O O Ca Ct M r-1 ca r-1 O O Ln Ln r r r Ct 00 al CO M al r CO Ln Ct l0 M 03 M N M r r-I M a1 O M N N C0 Ln C0 C0 C0 Ln Ct' 00 O 0 r M 03 l0 O N 03 O al CO Ln r N N Ln O Ct' C0 N W al 0t r r r Ct Ln O 0 Ct Lf) Ct N Ch O Ln 03 rV Ln O 0 O N Ln Ln m r-I Ln Ln Ln N Ln O O M in Ln 0 M Ln N O rM Ln r-I Ln M Ln r-I O Ln 0 Ln Ln O Ln O O o (4 N Cf Ct Ct Ct O O or N CO 0t d' r-i r/) 03 N 03 O al ar) M Ln r x--, M m r 3 —IF r u ILn in al C0 N CO CO 'HI H N Ln C6 M Ln u 5 b r-1 Lo Ir r d al M iun O Ir (.0 N O C0 r^ ) Ln M m iLI, 71. O L0 yr al C0 I, C0 Ln 03 M 0 03 1-1 al M u N 0 Ln in al u-3X in al a1 00 03 1, ($) 00 in Cfi (0 O O r ) o N 0' C0 03 M (0 r-i N M M 03 03 ...4 N 03 .•.• N r� CD O +--N Ln Ct Cr Ln a1 03 (0) Cr oo 03 Ln Ir Ir Ln Ir r O 0 N a1 Ln II'� 00 O a1 N Ir N HI al N 3D r O 0 (,0 CC) CO ¢gyp') r M, 0 MI, Lc N 03 M N l9 Y N L( (0 i 0 0 0 N 03 C0 Ct M Ln Ln L.n CO 03 03 a) Ol al �t O N 03 in r-I M Ln M Ln N r lq al r N Ln ' C0 r Ln M N C0 Ct r-I M o0 al Ln 00 N Ct' CO Ln N ao O O O O M r O O O l0 o Ca '3 N M O LQ r! in co N N r 0 M M 0 Ln a) 0 Ct C0 CO CO r-I r-1 Ct N a: C0 N 0 O N 0 N r-1 a: a. r o0 r N M O 0 0 0 0 0 0 a o O O O d 0 0 0 a 0 d o O O o 0 0 0 ai ai ai ai ai ai ao 0 ai ai ao ai � od ai r ai ai r ai r d ai r � � 0 d ai d o 0 0 0 O O O O O O O O O O O a O O O o O o 0 0 0 ,� ,� ,� rn a1 ,� ,� ,� rn � al � al rn � rn rn a) � a1 rn ,� 6) rn rn ,� al a1 r1 a1 p rn rn al a1 a) ,� ,� rn ,� al a) a) 0 0 0 0 Ln o r-I 0 0 0 Ln o d' 0 0 O o 0 0 M 0 0 0 O O O O O o o M N O O O O O r-1 O o 0 0 Co rn o0 r d N Ca Ln Ol 6) m Ln 0 0 0 0 61 0 0 0 0 0 0 Ct 0 0 0 0 6l 0 6) 61 0 0 0 0 0 0 0 61 0 0 0 00 6) 0 0 0 6) O 0 0 «) 0 0 0 0 0 0 0 0 6) M 6) O 0 0 0 0 0 a a 0 0 0 0 0 d 0 o d 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Ni coca 61 0 o O d O o 0 0 0 0 o al O al 6l o 0 0 0 0 0 0 61 O o 0 61 0 0 o 0 o a1 0 0 61 o al o 0 0 O o 0 0 0 al 0 6) 0 0 0 0 m 0 C0 0 0 0 C0 0 r-.I 0 0 p 0 r 0 0 0 C0 0 0 0 r 0 0 0 �) 0 0, 0 0 Ca .q. 0 0 0 co 0 0 0 p Ln 0 0 0 0 M N 0 0 0 0 0 0 r 0 0 0 0 0 C0 O r O O r 0 0 0. 0 0 0 N O 0 0 0 0 a) O 0 O O r 0 0 0 ,o r-1 0 6) O 0 0 0 0 03 0 0 0 0 0 r 0 . . . . Ni. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . O 0 0 0 61 0 0 0 0 o r 0 0 0 0 d1 0 al a> 0 0 0 0 O O O a• 0 61 0 a• 0 0 a1 O 0 O 6• 0 0 6� 0 ay 0 0 0 �: 0 0 0 0 0 6• 0 6� 0 0 0 0 al 0 0 0 0 0 0 0 0 0 0 0 61 O 6l 6> 0 0 0 0 0 0 0 61 0 61 0 61 00 6) 0 0 0 61 00 6) O 61 0 0 o Ol 0 0 0 0 0 6) N Ln N al Ln M N 0 Ln 0 r rl r N M p LO CO M M M d r CO CO 060000 • o 0 0 0 HI HI HI HI O O o 0 0 O O o 0 0 O 0 o d d 0 0 0 0 0 H HI HI HI HI 0 0 0 0 0 0 0 0 0 0 O 0 0 o d 0 0 0 0 0 HI HI HI HI HI mot. v v v' r-I al N 03 N r N 03 �f O 03 M 03 M r-I N M At N r-I V 33t N M O 03 N M M 0 N d' N 0 N M 0 03 N M N 0 0 HI 'Cr 0t 0 M 0 HI 0 C0 N N N N N N N N N r-I N N N N N N N N N N N N N N N (1,1 N N N N N N N N N N N N N N N N N N N N N N N N N r-I N N N N O O C0 O al CO N Ln CO r al 03 O Ln CO 10 03 l0 03 al O M al Ct r O O 03 r-I N r-I r-I r-I r-I C0 O M a1 N L0 r 01 r 01 00 C0 Ct r in Ct r CO iz,,' CO r-1 N M M HI HI r M M r-I N N N O N r-I •O N r-I N r-I 0 0 0 0 0 r-I r-I r-I O N r-I N N O N N N N CO MSr-I r-I r-I O N r-I r-I r-I N r-I r-I r-I r-I N r-I r-I r-I r-I O Si: 0 HONNN 6l 6l 6, C0 O O 03 CO 03 N 03 C0 Co 03 03 r N r N d' 03 N CO :111 C0 10 CO Ct a) Ct • r C0 O O 1n 1n N Ln (0 Ln 03 CO Co C0 N N r CO C0 Ln Co 00 00 N al O 03 O O O O 0 0 0 0 r-i r-I r-I O 0 r-I r-I o 0 0 r-I 0 0 0 0 0 0 0 0 r-i 0 0 0 0 0 0 0 0 r-I r-1 0 0 0 0 0 0 r-1 0 0 0 r-1 0 0 0 0 0 0 0 0 r-1 0 03 O H H 9 H `t O O O 0 0 O 0 o 0 0 0 0 0 0 0 0 000 0 p O p O p 0 O p 0 00 0 0 000000000000000 'Kt 00 0000000000 0000000000 O o 0 o d (-,, 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 C0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CO 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 O 0 -00 -00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 M p 1 p OO p p p Mp OCOOaMOCt NCOOOMN O p OM0 1.0OOMOCO in M p N O co- in n Lj m p L) Lr O Lfj M O v 0 0 0 3 CO ul Ct 0 ai 0 0 Ch M Ct r CT' Ln 0 Ct Ln Ln 0 0 CO CY 0 N M 0 d 0 ,-I 0 0 CY 0 0 d- v' 0 N 0 Ct 0 M Ln 0 Ln 0 N 00 0 Ct 0 7' 0 Ln Ln M M N N r N' N r-I N H N r-I Ln N r-I N r. N N 0O N 0I N N H N N r N N 3 N N - Ln N NNLONLO r-I 0 00000 0 000 - 0 0 O 7 p IS) r-I N ▪ N dam' u a v v u a�'i t v at') t) a) vtcriai a-'3 v t E v v u u v v ai a3 E a a v v E v u a3 v a}i v v v v E v ai t a''3 eU C'D u a n==== n D D n D p. D n n n n n au n n==== E a, = D= v n E D E n== m m D v n n n n n n m.= m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m Q m m m m m m m m m m Q m Q m m m m m m m m m m m m m m m m m r-I r-I i Q i Q i < i i Q i i Q < < < Q Q (0 (6 f6 r-I RS N fl) fl) RS Q Q Q Q ' Q Q Q Q Q � N • � O r-I + + + + < Q Q Q < Q Q Q Q 10 O N r-I Q i Q < < Ct r-I O r-I r � r-I Ct r-I i r-I r-I + + + + + + i < i < i i Q i i Q i Q Q f6 !6 r6 !0 CL3 Q Q Q ! Q RS (6 2 2 2 r-I Q Q Q Q Q .CY Ct 3303 03 3 3 v' 3 Ct Ct Ct Ln Ln Ln Ln Ln Ln In Ln Ln Ln Ln in in Ln in in Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln 1n Ln Ln Ln Ln Ln Ln Ln Ln Ln LS) Ln Ln Ln Ln Ln Ln Ln Ln N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N NNNNN r in r CO Ln a) 03 al M O r-I r-I r 'Co" r-I r r-I co r-I c0 00 Ln r r r-I r-I N 'Oa a) CO Ln al r-1 M r-1 to lU al In r 0 N O r-1 W r-I r-1 in Ln N O 0 C0 Ca M Ct O r-1 M O N N O O r-1 M M O O 03 N N M 0I N N N N N N O N N N N O O 03 HI N N M O HI 0 N N M O N M 0 r-I N N N N 0 M a a N 00 O O O 03 03 03 N N 0 N 03 03 03 03 03 03 03 N N N N M (0 (0 0 Ct LCOCOCOCOl O O o 03 03 r-I r- I 3 r-I r-I r-I r-I r-I r-I r-I r-I 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 HI HI r-1 HI HI Ln Ln Ln o M o Ln O Ln Lf) 0 Lf) 0 Ln l0 Ln Ln Lfi Ln 0 0 Lf) 0 Si) 0 Ln Ln r-I O M 0 Co Ln o Ln Ln o Ln Ln Ln IS) 0 Ln Ln o Ln Ln LC) r o o 10 Ln C0 M Ln Q::, H 0 0 0 0 r r r mot' l0 L.n r Ln CO r al r Ct r M 0 N 03 N Ln N N O r-I 0 M Cn Ln Ln C0 C0 M 0 Ln r 0 0 00 N N Ln O M N 0 al 0 r N N N Ln O M 0 N 0 al Ct N N N Ct Ct Ct LC") O r-I Ct Ln 03 N Ct N Ln 03 N Lri O Ln O N Ln in Ct 03 Ln Ln Ln r0 Ln O O M Lr) Ln 0 ((0 Ln c0 O M Ln r-I Ln M Ln 03 O O O Ln (0 O Ln O M O (%( N Cf Ct Ct O 0 0 0 0 0 o o c 0 0 0 0 0 0 0 o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Ct 0 0 0 0 N 0, 0 0 0 N 0 0 r-I 0 0 0 r-I r-I 0 0 r-I 0 0 0 0 H O N H r-1 0 0, 0 0, r-1 r-1 0 0 0 0 0 03 0 0 H 0 0 H 0 0 0 0 OLD NAT CHK OLD NAT SVGS d c' Ln > C3) CU O C Ct a) '> co U 00 0 70086VBT7 US TREASURY N/B US TREASURY N/B >- U CO CO CO N N ri H 01 0) FEDERAL FARM CREDIT BANK WELLS FARGO BANK NA O N LL M W l9 M r0-1 Ct M Ol MANUF &TRADERS TRUST CO FEDERAL HOME LOAN BANK BIRMINGHAM AL WTRWKS BRD WTR R FIRST CAROLINA BANK ro al 0Wd r_i p W o 0 a) p CO Ct 00 r CU O0 CU et Ln NCOD 0 X 7 Q Z LVi_ O' U to M Q N i 2 H M Q m Ct O' Q Ln DC Q al M W l0 0 00 co Q M X 00 03 Q al Z CO O Z 00 Ct r-I Y Q Z CO U) H a X N Z 2 V V d d CY 0 W Ln Q Ln N a) Ln a) Ct O N 03 r U N r N r W r 0 0 0 0) HI al O d W N Q t0 r-I N l7 La M M Ln GO r r O r C.7 Q N N. 0 Ln 00 0 Ct r 0 HI 00 Ln CO 73' CO 00 Ln r M O in O a 00 in Ln 3t' M M CO O 00 Ct r-1 Ct r'1 N C0 N M d W C0 Ln Ln 0 co Ct M M N 03 M r-I a1 r-I N N (3) M N C0 d' 00 M Ln M M M (3) 0 0 r M M N M 00 N M M O Ln O o0 Ct CO r m (0) M M N 10 r-I LSD HI a1 N 0 r-1 N r-1 C0 03 03 03 al N N r-I l0 r-I r-I r-I C0 C0 CO C0 r-I r-I r-I r-I r o0 r r-1 M r-1 CO O Ct M M r-1 N 0 0 0 Ln M Ct 0) 0 0) Ln CO M al O N M a) N CO CO M Ct M M M r-I O Cl3 0 0) M al M l0 00 r-I M r-I al O N In M Ct M O M M a) FIRST NATL BK OF AMERICA US TREASURY N/B BANK HAPOALIM BM NY US TREASURY N/B d Y Z 0 W ° Z VS• O m~ z • 0 W ISRAEL DISCOUNT BK OF NY w z z FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK CHIPPEWA VALLEY BANK BANK OF AMERICA NA TENN VALLEY AUTHORITY BARCLAYS BANK/DELAWARE UNITED HERITAGE CU FEDERAL FARM CREDIT BANK US TREASURY N/B FEDERAL HOME LOAN BANK OKLAHOMAS CREDIT UNION TEXAS EXCHANGE BANK SSB CITIBANK NA FREDDIE MAC CALIFORNIA CREDIT UNION UNIV OF WASHINGTON WA UNIV REV BANK OF BARODA CONNEXUS CREDIT UNION LOS ANGELES CA CMNTY CLG DIST FLAGSTAR BANK NA HOMETRUST BANK CLYDE NC FANNIE MAE AMERANT BANK NA FANNIE MAE FEDERAL HOME LOAN BANK US TREASURY N/B 0 r-I N M Ct Ln C0 r CO 6) 0 r-I N rn 3t' I) C0 r 00 0) O r-I N Ct M Ln CO r CO 0) 0 0 N M Ct Ln C0 r 00 0) 0 N 0 M 03t Ln CO N M r-I Ct Ln C0 r CO a) r-I r-I r-I r-I r-I r-I r-I r-I 3 r-I N N N N N N N N N N M M M M M M M CO M 01 Ct Ct d C1 C1 Ct Ct Ct Ct' 0 Ln Ln Ln Ln 111 Ln Ln O 0 00,-100 TAMPA BAY FL WTR REGL WTR SPLY 875124GS2 AMERICAN EXPR NATL BK 02589AE24 UBS BANK USA 90348J6V7 FLUSHING BANK 34387AFF1 N CO rn 0 r-I Ln In Ln C0 C0 © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. can 1-1 '•rtf•li• i n.lysis � siti . ns . y M. turity 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 r O O O O O O O O O O O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 03 03 03 0 O N M O M M M Ct C9 03 LCi Lci LO Lc) LO O r r CO N C9 C0 r r 00 00 00 01 01 00 Cal 0 0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 03 03 03 03 03 03 03 03 03 03 03 03 0 03 03 03 03 03 03 03 03 03 r 1 0 r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I r I r-I r-I N N N N N M M M M Ct Ct Ln Ln Ln 03 CC3 r r r r r r oo rn 6) 6) 6) 61 Cal O O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . r-I rl rl rl rl rl r-I r-I r-I r-I r-I r-I r-I r-I r-I rl r-I LT-9 r-I r-I r-I r-I r-I r-I r-I r-I r-I rl rl r-I r-I r-I r-I r-I r-I N N M 61 Cr 01 CO 03 Cf M r-I Ln 01 61 r 0 M. 0 n Ln CM CO N 0 0 Ln 00 0 00 0 01 01 61 O 01 01 01 01 01 01 o00) O O CO 61 CO O 00 M 00 CO CO 00 00 00 Co CO O Ct' CCO M 0t M M M. M M M. 0t M M. CtM. M. M. t' Mm03 01 LC) CO 03 0 01 Lc) Lc) LI) 00 M r r-I r-I 0t 0 CO 0 00 0 r-I 0) 0 0 0 0 0 N O 0 0 L!) N Ln O O 00 0 Ln 0. 0 V Ln CO 00 ct r Ln N 0 0 V 0 0 00 Lf1 01 N Ct 0) 0 0 C3) M 00 r-I 0 CO Cr 01 0 r . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Ch O O O O 0 O O 0 Ct Ch -I M M r-I r-I Ct r-I Ln O 0 Ct .4 0 0 Ln 0 O 03 0 r-I r-I 0 Ct 0 0 0 O r•••I o0 CO N N („) 03 N 00 0) O II3 O iO3 N (3) CO r-I N Ct N Lly Lc) 0 Lc1 Ln II" O 6l Ln r r-I 4 / CO 01 III 61 0 01 Ct' 0) II, (5) 0 C0 0.M 03 Cr 00 m N r-I 0- O0 O. O. 0 r-I r-I r-I r-I -� r-I -� r-I r-I r-I r-I r-I ') r-I r-I 0 r-I r-I . . . . . . . . . . . . . . . . . . . . . . O O O 0000000000000000,00000 O 0 00 0) O d 0 0 0 N M M N M M M O 03 0) Ln Lc) C0 Ln Ln . . . . . . . . . . . . . . . . . . . . . . . N N O O N N N N N N N N N N N N N N O N N 03 N N r-I r-I r-I r-I r-I r-I N N N �' �' �' Cr Ln Ln Ln l4 CO 0) L9 L9 r r r . . . . . . . . . . . . . . . . . . . . . . . N N N N N N N N N N N N N N N N N N N N N N N N Ln C0 MOMMOM Ln M 0 M N 6) M r-I CO Ct' N r-I N r-I 10 M C0 01 (.0 0Ct. 00 00 00 CO CO CO 6) O CO 0 CO CO CON CO M. M. M. M. 0) r N 0) Ct' 0 r r-I mot' 0) in in LC) 0) Ct. 10 Ln 03 Ln 0 0 N CO 0) 0 l0 C0 0) M M r Ln r N C0 0' 03 O N 0) M N N 0) M CO . . . . . . . . . . . . . . . . . . r-I O M N Ct' Ct r-I Ln r-I Cr r-I Ct �t d' d' Ct' M M 1O 01 , )D r M M O O fV C Y '' '-" 01 N 0 r 01 M II, d- ui' N N II'� iL b 4` M Lf7 a N Ct 0l 0) O 0 .4 Ln in 0 Oy 6) 03 M 0 0) a ¢l (0 0) M M 0) M r ��,'t��°M II' 00 M l0 0 000 00 00 0) 00 I, I' M C0 03 • 00 Co' 0 0) 03 0 0) N r �` d CO CO N M wCJ NCt N Ln 0 N r n r O O 0 O n O Ln M N w r' 6M 4 00 6M 00 .l' Ln ('`1 Ln 0 61 Ln M 00 . O 00 alONLnOr000 a) :: r Ln •s rco' 600 6O O 01- r CC0O CNO0 0N o0 r-I r-I r-I Si Si • Si •r-Irr• r-i O • O LO r-I LnO O r-l3. . .4.4CUOl0l0lOnLnlflnOLn O O O OOOO C1• 66O00)O)O 0000o0O M 61 61 01 01 01 01 01 01 01 61 61 0) 0l 6) 61 61 0) 01 0, 6) 6) 61 01 dl 0) ONO , ,� CT 6) 61 6) 01 0 0,000000 p N m Ct d 6) O 0 0 0 0 m O d O 0 0 0 p O N 0 ,H N O O Ch O O, O 0 0 0 a N l0 O M O 0 0 0 0 0 0 0 0 O r o O dl 0Or-I 00 0 0 0 0 0 0 O CtN o 03 '. o O6i 0 0 0 0 007 0 o 0 o 0 0 N0 0 0 0 00i M 0 Oi Crnr 0)00 0 0 0 0 0 Crn � O O 0O O 2 r6rO o 0 0 0 6O O O)) Orn 0 0 0 0 0 0 0 00 00 0 M 0 0 0 0 0 0 0 0 0 0 00 O 0 M m Cr m r r Ln o Cr o M Cr Ln O CO O r d d d d 01 CO O N 0 0l Ol O 0 01 O O O p O 0 0 0 0 0 0 0 r 0 al m O r ,3 O 61 O O O O O O 0i c y aj �j N M al 0 0 0 0 0 ,� 0 0 0 0 0 0 �y 0 0 O 6i Cr 0 C3i C31 0 61 0 0 0 0 0 0 61 rn rn rn O o 6l O 6l o o O O 6) O O O O d O 61 o O O 61 61 0 61 6l C6 N 0 C0 0 0 6) 0 00 m O N N a r p O 0 d 0) O r-I O N O O O O O 0 O 0 0 0 r N O O d LT 61 0 6.• 0 0 0 0 0 6• 0 61 0 0• 0 0 r-i 0 of •6) 0 0 0 0 • 0 0 0 0 0 o O O o d o 0 0 0 0 0 a) —9 r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I rn l0 0 r 0 0 m 0 0 0 0 r ONMO 0 0 0 Ln 0 N MO 00 O 0 03 0 N 0 0 0 0 0 CO 0 in O 0 0 0 0 m 0 co03 o r-I 0 o CT 0 a1 0 0 ,: 0 o r-i 0 a) 0i 0 0 0 0 h 0 0 0 0 0 0 0 0 o 0000 0 0 0 0 0 N r-I r i O O Ct r-I r-I r-I M N r-I N r-I r-I M r-I 0 r-I 0 M N N 0 0 r-I r-I N r-I r-I r-I r-I C M r-I r-I 0) 0l 0 0 0 N Ct' r-I M 0l Cr r-I M M 0 M mot' N CF N N N M M 0 N N N N N N N N N N N N r-I N N N N N N N N N N N N N N N N N N N N N N N r-I r-I N r-I r-I N N N N r-I N N N N N N N N N N N N N N N (X) 61 O 0) r r-I r-I r-I CX3 r-I N CO 00 r-I r-I r i Ln M N CO 0 0 0 r r OD CO 0 N 00 00 r N 00 01 r Ct' N N 0l N CO r-I r, 0 r-I 00 03 M 0 0 6l 0 03 O r-I r-I O c) O 0I N O O O M O N r-I r-I O O N O d 03 N 0 0 r-I N O N 03 03 N 03 O N N O 03 O 0 N O N, N r-I r-I , M O N r-I N N r N l0 N N r C0 N M M r V' M N 10 Ln m N r-I N t.0 O O r r Ln 00 N O 00 N 61 CO O r-I r r-I O O Ln N o, CO N N 0) l0 N M CF Ch 10 Ln 1, N CO 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 a -� O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o M o 0 0 0 0 o p o 0 0 0 0 0 t 0 0 0 0 0 0 0 0 0 o p p o O p o 0 0 o M o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 r-I 0 0 0 0 0 0 0 0 0 0 0 0 0( 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N 0 0 O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 'o O p C0 0 0,000 p 0 p o —00 0 0 0 0 a Ln O O ri O O O Lfj M Lfj 10 0 0 0 0 O O O O O 0 o Ln 10 m 0 0 03 m 10 0 10 0 0 Ln 0 0 0 0 L0 L1) Ol 0o p 0) O 0) ' O p p 0 Ch p 0 Lc} LC} Lfy N O Cd Ct' O O O Ct 01- `t C0 0 0 0 0 r LN 0 O 0 N O N 03 0 0 0 N N N MI N p O O N O Ln r C>D Ch Ct' p mot' 0 03 61 0 10 0 0 Ch 0 0 03 dmotr 0 CF NM0MNNNNrN0n N N- N CO N C0 r-I -MN - r N N N M d' N r i aEEavaaEEaaa aEaaaaEaaaLi; aaaaaaaEaaaas a avaaaaavaaaEaaaaa ('D E v 0 n0nDDED= =nnu )==E n n = n m m n )D E n n n CO m m CO Q m CO m m CO CO CO CO m CO CO CO CO m CO CO CO Q CO CO m CO m CO CO m CO CO CO m CO MM m m Q m m m m m m m m m m m Q m m m m m d v Ct N N N N r-I r-I r-i r-i r-I r-i r-i •st N 01 , N N O 0 r-I r-I N N N i O i i i i O i N r-I 0 r-I r-I , + + Q + Q + Q < < Q Q Q l6 � r-I f6 r-i RT f6 f6 f6 RS r-I f0 ca �Qra f6 � cs Rs cr3 � � ra ra cCs cr3 � cr3 � � cCs r6 � ro ca Q Q Q Q Q Q Q Q Q Q Q Q Q Q r-I r-I M r-I + + + Q . Q . <( < < < r-I rt) rti (C) f6 c� Rs Q Q Q Q Q Q Q i Q i Q Q • ' Cr Ln O 0 r-I Q QQ I O r-I r-I r-I r-I + i QQ i i Q Q rQ CCf M R) Q < Q Q Q Q Q Q Ln Ln LC) Ln 1 Ln CO C.0 l0 l0 l0 l0 l0 l0 l0 CO CO CO CO C0 C0 CO C9 CD CO C0 C0 (.0 (.0 C0 C0 C0 0 0 0 0 0 0 0 0 0l0 0 l0 0 CO r r r r r r r r r r r r r r r N N N N N N N N N N N N N N N N NNNNNNNNNNNNNNNNNNNNN N N N N N N N N N N N N N N N N N N N N N N N N Ct Cr Cr rI 03 00 N N 0) 71', (0 00 03 M O 03 1.10 03 03 CO 03 -Co' Ln N 10 0) Ct Ln 03 M 0) C0 03 03 O O O 0 0 0 0 N 0 0 0 0 00 Ln LS) CO 0 03 in N 03 r 0) 10 03 03 00 N N N O r i r i N N N O r-I N O r-I M O r-I 0 r-I r-I r-I r-I r-I N N N r-I r-I 0 03 03 N M O r-I C'0 M M d O d 0 r-I N M M O r-I r-I r-I N O O N O r I r-I N O r-I N 03 03 03 N N N 03 03 03 N N N M M M Cr Cr Ln in 0) C0 C0 C0 C0 10 t0 r r 00 00 00 00 00 6) 0) 0) 0) 0 03 03 r-I 03 r-I r-I r-I r-I N N N N M 0 03 d' Ln 10 0) 10 co CO C0 0 03 0 0I 0 0 0 0 0 0 0 0 o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ,,,, 0 0 0,, 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CO 0l 0 0 Ln in Ln r-I 0 O 0 00 O Ch in 0 O 03 0 0 Ln O Ln in O in 0 0 0 0 Ln O Ln in m of Ln Lc) r t0 r-i Cr in (0 m 0 in 0 M 00 r N 0 CO in r-I N Ch 0) 0) 0 0) M 00 Ln 0 r CF' 0) O1 10 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Ct 0 0 0 0 Ln O O O O Ct O Cr Ct r-I r-I M r-i Ln O O r-I Cr Ch C1 d r-I O N O r-I r-I O N O O r-I 0 0 0 � o 0 0 0 0 � o 0 0 0 0 0 0 0 0 0 0 0 0 0 � o 0 0 0 0 0 0 0 0 0 0 0 O 4 4 O O O O O 4 0 4 03 0 4 O 4 4 0 O 4 O O O 4 4 O O O O O 4 4 O 0 0 4 O CITY NATL BK - BEV HILLS FEDERAL HOME LOAN BANK 0 Y � Y Z > Z m, Z O Y Z H Y O Q m z ZQ0 w Q m < m w z w z O Z o 0� 0 Q m U Z g o -) z L3' z Z o Lwl U 0 2 • 00 ') W Q Q N- r-I 0 0 CO CO M M 0 r r-I r-I M , M M , 48040PJT3 41166HEB8 20786ADE2 LOW U � Z MO .M l,0 r-I OM US TREASURY N/B US TREASURY N/B Freddie Mac FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK SAN DIEGO CNTY CA REGL TRANSPR US TREASURY N/B WILLIAMSTON MI CMNTY SCHS SCH ATLANTIC UNION BANK FEDERAL HOME LOAN BANK SAN DIEGO CA CMNTY CLG DIST FEDERAL HOME LOAN BANK US TREASURY N/B Ln p , 0p Q U Cr 0 Q 0 > 0 H U a 2 2 N r M Ln r-I r JMN .rmpOp000 U m z m Z 2 0 0 Q L.- z m Q N> Y r J a Ln N 0 'S O 0. M -) O U Ct' J Z. Y o Z d' o 0, N C0 o!J Z U 2 N N X r Q 0 N 6) r-I < 0 co 0 W 0 r-I in in r M N Q N W CO CO r-I M O Ct 00 N r-I O r-I r Lc) M r-I w Ct M N O 00 O 00 M N N M M M r N 0 0) M 0) r M M C0 r in N r CO N M N M , , , 0 0 01 r-I r CT r-I Ct' 0) 0 r-I M 0 0) (31 0) M r-I r-I 0 0 0) 0) M M M r C3) 0) 0 M Ln r N M M M r 00 r Ln 0) M 6) M FEDERAL FARM CREDIT BANK US TREASURY N/B 912828YG9 N M Ct' Ln CO r d CO 0 r-I N M Ct in lfl r 00 0l O r-I N Cr M Ln m r 00 0) O 03 N M Cr in co r 00 C0 10 10 C0 CO C0 C0 C0 r r r r r r r r r r CO CO CO CO 00 00 00 00 00 00 0) 0) 0l 0l 0) 0) 0l 0) 0) M 0 0 0 0 Ln r LO M Ln Ln Ln Ln O 03 Ln Ln O Ln O O 0) O O 00 0 0 C0 CO N N CO U) r N CO Ln 00 C0 0 C0 M N N (0 M m . . . . . . . . . . . . . . . . . . . . . . r-I N M M Ct' Ct' r-I Ln r-I Cr' r-I N Ct' .4 Ct Ct' M fit' M M M Ln o a o 0 e o 0 0 0 0 0 0 e o 0 0 e o 0 0 0 0 0 0 0 0 0 0 0, 0, 0 0, N N, O, 0 0 0 0 0 0 0 US TREASURY N/B a 00 00 r-I C3) 3131X7B49 FORBRIGHT BANK 34520LAU7 EAGLEBANK 27002YG P5 FEDERAL HOME LOAN BANK 3130APTE5 LAFAYETTE FEDERAL CU 50625LBR3 US TREASURY N/B 912828YU8 US TREASURY N/B 912828V98 FEDERAL FARM CREDIT BANK 3133EP6K6 EAGLEMARK SAVINGS BANK 27004PEP4 FEDERAL HOME LOAN BANK 313OARJH5 CANADIAN CNTY OK INDEP SCH DIS 135537GZ5 MORGAN STANLEY PVT BANK 61768U4F1 DISCOVER BANK 254673D94 OREGON ST N 0 r-I M C0 10 C0 r 0) 0) 0 r-I N M Cr Lc) C0 r CO 0l 0 r-I N 6) 0 0 0 0 0 0 0 0 0 0 r-I r-I r-I r-I r-I r-I r I r I r I r I N N N 0) r-i r-I r-i r-i r-i r-i r-i r-I r-I r-I r-I r-I r-I r-I r-i r-i r-i r-i r-i r-i r-i r-i r-i © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. '•rtf•li• i n.lysis • e • or, 0 1-1 ,1 0 RI CV CN 'CT; NI NI NI r\I r\I NI rr? (""`! ("? (Y"? (Y.? rn rrl ("`! fr*: m. (0(0(00(0 O 0000000000000000000000000000 d d c5 c:5 c5c5c5cidO ci 000000000000ti:000000 N • N • N r• 4 NNMMM 01 01 01 01 01 M ro m m rn rn m m Ln CO 1, 0) 'I' 0 01 0 N r-I 40- cf) I' 00 LO '1" 0 N 00 t (0 (0 LO N 00 ▪ 0 • .tr 0 0 m L-r).00 01) Lo. N N h h cc). co. cq 0 � N!r rn hhhhh cc? cc? 0 N! m. (n. (0 cc? (00 0 m. (Y). L-r)L-r). ID N N C• Y) (4" Ori M rri ro rri rri rommm rn m m ro rn mmmmm rn rn m .4 .4 (0 .4 .4 .4 .4 .4 tr: Ln in in in Ls, Ln Ln 10 in in in ut to CO CO CO IS) CO • o to Ln to Ln a, m co rn 0 ID 10 M CO N N 10 CO LC) 00 0 r-I M (3) 0 0 NI NI 0 CY) in is) ID 0 0 00 NI 00 o 10 to in oo 10 o in oo o Ln r co r oo r 10 CO Ln a, 00 CO r ID CD 00 (3) CO 0 C5) I, 00 (3) Co (3) r-I CO in 10 10 Co ID 0 ID CD CO (0 CO 11, C) CO 0 C3) CO 01 CO r-I rt'L r-I 00 r-I r-I N rri orirri rri rri rri rri ori rri rri rri rri cri rri rri rri rri rri rri ori rri ,t ori nri rri rri nri rri rri rri rri ori ori rri rri rri V) 00 M C.000,,t0(00,0(3)NOOOM7tOctONC),07r C.0 7t. 0, 0 N LC) 7t 0) 0) L.r) t.iir---1 o o cr, N 0 N 00 M cD (3) CC) 0 r-I (3) 0 N 00 CO M 10 m 0) 10 10 V) m L0 LJ, 00 00 IS) CO Ill r-I 00 I, CO '1" 0) 0 10 N N 00 CO 00 Ln 00 Ln r rn rri cy, 10 0) LO CD LC) N CY) 0 CO 10 r0 LO r-i cri ,f .4. 0r-i .4 .4 .4 ,f .41 .4 ((I0 Ni iri 10 .4 ,f ,fo c:5 Fn* r\I ,t ,r .4 co rq ry ry 6 Ln (0to o m o o 66 N 04„, a) 6 N LS) r-1 c, 5 Ln N N r-I 00 U) m N (31 CO r-,1 V) 00 (5) 0 ,t M C3) 00 (3) I, (3) 1, CO " 71. LO 0) N 7t. rl (3) CO C3) V) (3) C.C) 0 CO rl IS) 0) LO(0 CO 0 't (ci).) 8 00D, Ct. N c , (x) rn ,t 01 0) 00 cf) Lo L., (4c4. o 6 a, a, r r--1 7t. 00 01 CO 7t. LO 00 CO IC) 10 N m m. co N 10 0cl). °q 01 01 Cel 01 N 0 CO 0 0 -(01 10 01 01 Isn 01 01 01 01 ° O. '41;" C° '4 Isn 66 m (Y) Lc) Lo iorn't . co• N rri nri Lc) c0 N 7t. Ln m r_i r_i cs 6 Lsi ori cd, r: • „. isi ryi cp• r-I r-I r-I 1110M -,),00,00,0,)0000,000,00 0 10006m001110000100 10 o m 10 Ln o o o 10 o o 0 o m o 0 0 Lo 0 L.1) 0.6„0100001000(0)00 cicica c:5c506cic566d 6 d c:5 c:i d ci ci d • N hz 000000(00 000 • oo o o 22222220000.,0)228 r...,,,nor,,,000000000000 C) 0 LO 71- L.0 0 M CO 0 cp. Co NI cs, cc? ° CO 10 0 rrtll in' 10 (%) CO- , od 0 in 0 Lo 0 c:i rri • • 0000(0 co C07-11 2 2 (,2. 100 r-I r-I r-I r-I 00r---1,1W00)0 00 0,00010000 0 0 10 00000000r N CO 0 LO MOCOK 1,•0'100.(NO 0000000 0,m6,06,0.,0M6Lp „00.10001,71- co,0,050N,4 010,0,0 00 0 L'n L'n 3.) (n c5 c5 • 0, c5 c5 c5 00 c5 o 6 00. ociood o d Ni c6 ccg 0 c)Ni 0 „i d d d d d t.c5 rri 06 d ,f r-i C5 1-.1 rri r-i 1-1 Or „0 Or „, 0 Or „, Or Or „ Or „ Or „ Or r Or Or Or 0 0 0 r 0 Or r„ cs, 00 0 0 0 0 0 0 0 0 c,00,000r,o)00000 0,000000 r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I r-I 0000 01 7r M m m rn m ro co m rn rn co .4 if) rri o ro N ( O (010 N N N Nr-INNNNNNNNNINr-IN N N N Ciljrn g' (11. COI ( -(j1C )jr rrIC\L00 (0100000000100000100 co ma,r4ornenr °or, CO I, 00 03 000 (01000 (C (J's 1M' 5) 1,) c\o' c) NNONNNNNr-INNINr-IN • ( ) ) C) C) N ) N r, N I, hl 010100)10000(000001000 0 r-Irir-100,0,0000000000r-Ir-lr,r-10r,r-101-101-1,00,00000 r,r, r, 0 0 0 0 0 0 00CO • 0000 o o o o o o o 0 0 o o o o o o o o o 4- o o o o o o o o 000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 (-N 0 0 0 0 0 0 0 06000000000000 4, 0 0 0 0 0 c_-, 0 0 0 m 0 LO cri'':, 0 0 0 0 C., 0 0 0 0 I, 000000000000000 ^0000000 0 000000000000 0,0000C) -000 OC)0000CY)0 d ci ci d o- cri oo- I, 0/ m 0 in Lc, in o in o i,kr oo - d d d o- .4.- .4- in- .4- cn- al- o- o- 0- o oo in st in in o o -4 „i• in o 0,, o in o o m d o is, r .r",', o o .4 o ° ,r o o is, Ln o .4. ,r o .4. 0 o co o r o ,t r m .4 o o o in .4. .4 to .4 .4 ,r o o 0 sl- LO .71" 71" . o .4 'Cr cy) I, 1--, re, V) 00 I' LO r-I 0 M ,t. Ln ' N CO N CC) . N Lc) is) , .1 .4 ry ry r\J N1 r...," M N N CC) co cv m , N ' CC) CO 01 CD NI NI 7t. c, cv r, in Lf) LC) N N N r-I - lf) r-I N CO N , LO ,I- ,:r r-I r-I in , it) tuj t3.1 t3.1 it VI) ru "a," ru "al -4") t1.1 "a") ci3 V, 'a; tu' tu' tu' ti; +ci, ci5 tu' tuj t'u < ▪ nn DpnmnDn mnpnm======DEE"3 --51.=.E=== mnmEn mnmmE DD= co co co co 00 co com coca men co co co co co comm co<<co co co co co<co co moo com<co comco co<com co co m < , + < < < < < < < <It c• fl CO 'I' N N 8,1L-n (0 o r---i (<',D (<1 <7 < ' < 00 Ln 8 00 0 00 0 E• ' co<oom CO CO N , 8 . . 0 (-2 0 r-I + + < + + < < < <k < < < < < < < < < < •r(1.r4 rriS (NI << •Ct CO CO r-I < < < < ' ' < < < r r r r r oo oo CO 00 CO CO 00 CO 00 CO 00 CO 00 00 CO 00 00 00 CO 00 00 00 00 00 (31 C5) 0) 0) 0) 0) 0) 0) (3) 01 0) 0, 0) 0) (3) 0 0 0 0 C) 0 0 0 0 C) r-I rI r-I r-I N N N NNNNNNNNNNNNNNNNNNNNNNN NNNNNNNNNNNNNN Ln 10 0 L 8 8 00 00 8 i 11NNNIN.QMMOIC202r.2S) COMMMM(Y) i-1 i i (0 0) 10- , r - ) (0 .- i ,- i L., 8 r-I 0).---i ,---i ,---, L, ,---i 10 (0 10 108 8 ,-, ,:o , ,-, L-,10 10 ,----, m 10 m 10 Lei ,_,. , , , , 0 ,----, N 00,Mr-INNOOM10,MONNNMOOONO CY100010.-IMMONNOO10 0 CY) 0 CY) 0 r-I N 0 0 0 r-I r-I 0(.10000 • Cr) Cl 8 8 ,, ,--, e:, (-:, e:, (-,, Zr. •i- Lf-, ir, L., LO CO CO C) C) ,0 Ci0 i C) ?) i, c -1 CI .-1 ("1 c- ) V) LC) k) c.) ?,0 ,C) Or -INN 0o C) 0 N N 't. 't. Ln o o o r-ir-i000000000000000000000 r, r-I r-I0000000000 0 00101000000000 r-1100000 10 oo cs) !0',": 0 0 10o Ln 0 0 o Ln 000mNM,00 000 0 o Ln o o Ln Ln o o o Ot„, 0 Ln o m co 0000 ro oor o CO N 0 N Ln r r---1 o o Ln Ln r N in to in in N ,t (Xf: o Ln o r Ln Ln in to o r\I o co o in in o o P00 o. o Ln d ,c Lri .4. 10 (St;:: Lri .4. 00 .4 in 00 00 00 rri Lri 1010 rri Lri 00 Ni 10 10 Lti„ r-i Ni NI .4 gg 10 0rofi0400c40400000040004400,, 00 ,,0.-100,-1000101000r100000N10000,-10• 441.,100000,--1 WISCONSIN ST TRANSPRTN REVENUE 977123X94 MASSACHUSETTS ST SCH BLDG AUTH 576000ZG1 FANNIE MAE 31364FCB5 OAK CREEK WI FEDERAL FARM CREDIT BANK CARTER FEDERAL CU Z 00 CY 0 ›- Zu.. >" i:15)D F<3.ti CC I- F- CY in 0 D ALABAMA CREDIT UNION (1) Z 00 Z cc) D >±1 Z Z < c, Z O D < < 2 00w < 0 10) 00(i„ OWI0OHOO OC)X 00• (010(0(0000(0(00)100 N E IA CMNTY CLG 664214PS6 FEDERAL SAVINGS BANK 313812EG0 FIRST MERCHANTS BANK 32082BFU8 06 IZ 1'2 01 E E-- • _ < u z O 0 LIJZ O v) 68587FAY0 798186P30 NEW YORK NY NEW YORK CITY NY TRANSITIONAL CELTIC BANK LOS ANGELES CA Z 0 ▪ Z D < 0 • Z CY < U 1.LJ • LLI 1.LJ LL 0 CU Z o < • w U o rc, US TREASURY N/B CINNAMINSON TWP NJ FEDERAL FARM CREDIT BANK BEAL BANK - PLANO TX BEAL BANK USA HENDERSON NV CUSTOMERS BANK MEDALLION BANK UTAH CARTER BANK &TRUST DOWNTOWN SAVANNAH GA AUTH NORTHSIDE TX INDEP SCH DIST CALIFORNIA ST USALLIANCE FED CR UNION ALTOONA PA AREA SCH DIST LEDYARK NBK/NORWICH VT DOWNERS GROVE IL FANNIE MAE FEDERAL FARM CREDIT BANK N E IA CMNTY CLG MIZRAHI TEFAHOT BANK/LA r`d MAGNOLIA TX INDEP SCH DIST Small Business Administration MISSISSIPPI ST co0010) m r rri rn tti (711.<°CyZ . w 0' 0' CY NI L,... CY CO r r m .4 oo CO in r-i Co to in 0) or, r-i o 10 in CO : (010(0 to NI 00 rn r-i m co o CO .4 BENSENVILLE IL 082419F56 ROCHESTER MN 771588WJ5 31418B2N5 3140NU7C7 (elf m • in r co a) o m .4 in ts) r co o N M CO .4 in r oo o N ▪ ts) r co a, o m , 0-, 0 r, N • 10ID CO 0) 0 LO CC) CO CO cD N N N \!NNNMMCOMMMMMM 41; In In In in • I11 11, in Ln Ln Lc) CD CD c0 © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. 'ir •I.A 8 4 1 3 1 9 1 1 1 e • • 0. 'st: 6, 6 F. 0 6 0. 6: 0. o o o 0, o 0 0 o 0 o 0 0 h 0 SS 0"." 0;;; o o 9 Lc) 0 0 La▪ . h ,t. La. (D. : co '1 0 a) 0 00 ,t. 0 Lt h 0 0 N. co. Ln N Ln rri N efer N N N r•-• rri ,r ,r m 413. r rrrr oci o6 oci °di cid N 9M 0 0 cyi ci 0010 N N .7r Ls) N M ,t ,r a) co M LO 1000100100(000 co o 0„;;; 0-1 LO 01 01 , tr, 01 01 0 10 0) 0- 0 0 0 N N N N N 61: rri rri rri rri ,t rri rri rri rri rri cri ,c 0010 0oLO00010000LOLO0oco om N 00000000100 N L.n ,t L.ri ,f nri rri rri .4" .7t: 1000 Ln co R" 66 rri co co co co 1100 o ot- a) in o") LLD Lo o c", N 7t k 10 N OMONO N 0 0 CO 0) r21 c5 Lti ,t "6 ad ad ad ad cd cd oci r,"6 CT) o co co cn 7016101010,010-0,61201014 ab9i rcvC(ri- ST,)2 82 P2 2 82 Ln 0O .00 'L t C)N ,D T° CO , moo0oo 6 oci 6 cv(k 0.71' 6 tr, of" 10(0 ,r rn o ,r rn co 0 LO zt.) rc,), 0(0 N 0 01 in ,r 00 0, 00 r-i .▪ 7f0rjoo d ,:r CD M 01 G) N CO 0) CO 00 00 M 0) 0) 1010 o o o o r-i 5?il iircii ,-)r-I -r-I iil 1O or -I ON,0 l ;35' O '....i(Nf ,..' C35' LF5' iioN z i 3 ( , IN 1 . (o(0r 1 8, ,-1 MN,,, ) ::... ) . •-:,, Cr..:•- 8i ,r1L' L-1:2' 1 ' )j N C9,' ' - .ii '1) .1 Q' r -1l,13 i:I: \i:1 , 0) 0) o 0 , , 0 0 , 0 , 0 , , 0 0 00 0 0 0 , 0 , 0 0,0 c,,,,0 00,,4p,6-..0 0 , 0 0,:-, , , 0 . co 0 N, 0 , ,„„ 0., ci , a, „ .61-:, r-i m .71- c5 NJ- c5 - - rri` 0 r2, ,.„,1- o m 0 , , o , (0N 7, r, L--I ,-,_ co ▪ co 10 co 10 r, c?-1 • Lo 61 0 0 Ls) Ls) (st r,° 00 co co _ di; c5 r`i LLB 8 6.k" + + • + + < < < < < < < < • < < 10 co o Lo 10 m co r, • o.0 • 0) CO 0 1 Ir• 7)1 (To' NNNNNN 10 m m rn ro m m mmmrom m m m m m 71. LO LO MMMMM 0k) m 0) 8 • 71 00,1000 2. '2 2. !;....) C3 00000 Ls) 1}) ,NMM N 8 8 o o o 000000 00000 o o o Lc) o co o o co o o o F:2) ci-r,), 8 8 co, 8 2 2 2 8 a: 0 00 Lo N Ln o rri ,t rd rd c,Ig4tt;g4ggcg.ggg4gg44e)gto,g4,4„, FEDERAL FARM CREDIT BANK 3133ERDMO az FEDERAL HOME LOAN BANK H 0 o ge, L- 2 2 2 2 2 2 2 < 2 2 4 ig. ! I' a0 ± L72' L'ir2c L FEDERAL HOME LOAN BANK 0' ---, 8' E >2 L> NI 0' -_-_-, °°-_-_-, ai 11 .0) X < , 0 r b' i? -9 0 0 m a , a ‘,5-,. ‘,5-,. :-1-,. ',-st-; rii .,q,. Lit m M M M M M M M M 01), , N M ..1. LO l0 , co 01 00 00 00 CO CO CO CO CO CO 0) , , 0) 0) , r-i r-i r-i . 10 10 10 10 r-i ' ' r-i 3138WHJ29 3130AXEZ7 3132A9TC1 31418CKU7 3130AS5M7 m FEDERAL HOME LOAN BANK 3130B0X87 00 CD GO CO 00 x _J 0 U_ F— > Ls) u O 0 N 0, c0 00 X X r—ir-1000 MMMMM r4 c0 0 CI 01 01 01 0 0 r-i r-i 0 00 kft 4,61 00 © 2024 Wells Fargo Bank, N.A. All rights reserved. Confidential. 'ir • Shakopee City Council 10.a October 15, 2024 Agenda Item: Emergency management table top exercise. Prepared by: Dave Giddings, Deputy Chief Reviewed by: Action to be considered: Recommend that the council participate in an emergency management tabletop training event led by an outside facilitator and fire and police department staff. Motion Type: Informational only Background: The mayor and council will participate in a complex, realistic tabletop disaster scenario. This tabletop training will define the roles and responsibilities of the mayor, council, staff, and outside agencies during a prolonged emergency event within Shakopee. Recommendation: Recommend that the council participate in an emergency management tabletop training event led by an outside facilitator and fire and police department staff. Budget Impact: None Attachments: Shakopee City Council 11.a October 15, 2024 Agenda Item: City Bill List Prepared by: Nate Reinhardt, Finance Director Reviewed by: Action to be considered: Review of City Bill List Motion Type: Discuss Background: The City Bill List have been provided to the City Council. Recommendation: Review of City Bill List. Budget Impact: N/A Attachments: Shakopee City Council 11.b October 15, 2024 Agenda Item: Liaison and Administration Prepared by: Lori Hensen, City Clerk Reviewed by: Lori Hensen, City Clerk Action to be considered: N/A Motion Type: Informational only Background: N/A Recommendation: Information only Budget Impact: N/A Attachments: