Loading...
2023 City of Hopkins, MN Annual Financial Report Annual Comprehensive Financial Report of the City of Hopkins, Minnesota For The Year Ended December 31, 2023 Prepared by the Department of Finance THIS PAGE IS LEFT BLANK INTENTIONALLY 2 City of Hopkins, Minnesota Annual Comprehensive Financial Report Table of Contents For the Year Ended December 31, 2023 Page No. Introductory Section Letter of Transmittal 9 Certificate of Achievement 13 Elected and Appointed Officials 15 Organizational Chart 16 Financial Section Independent Auditors Report 19 Managements Discussion and Analysis 23 Basic Financial Statements Government-wide Financial Statements Statement of Net Position 39 Statement of Activities 40 Fund Financial Statements Governmental Funds Balance Sheet 44 Reconciliation of the Balance Sheet to the Statement of Net Position 47 Statement of Revenues, Expenditures and Changes in Fund Balances 48 Reconciliation of the Statement of Revenues, Expenditures and Changes in Fund Balances to the Statement of Activities 50 General Fund Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual 51 Economic Development Fund Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual 52 Tax Increment District Super Value Fund Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual 53 Proprietary Funds Statement of Net Position 54 Statement of Revenues, Expenses and Changes in Net Position 58 Statement of Cash Flows 60 Notes to the Financial Statements 65 Required Supplementary Information - General Employees Retirement Fund 106 - General Employees Retirement Fund 106 Notes to the Required Supplementary Information - General Employees Retirement Fund 107 - Public Employees Police and Fire Fund 109 - Public Employees Police and Fire Fund 109 Notes to the Required Supplementary Information - Public Employees Police and Fire Fund 110 112 Contributions 112 Schedule of 113 3 City of Hopkins, Minnesota Annual Comprehensive Financial Report Table of Contents (Continued) For the Year Ended December 31, 2023 Page No. Combiningand Individual Fund Financial Statements and Schedules Nonmajor Governmental Funds Combining Balance Sheet 116 Combining Statement of Revenues, Expenditures and Changes in Fund Balances 117 Nonmajor Special Revenue Funds Combining Balance Sheet 120 Combining Statement of Revenues, Expenditures and Changes in Fund Balances 122 Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual State Chemical Assessment Fund 124 Parking Fund 125 Communications Fund 126 Art Center Fund 127 Hopkins Race and Equity Initiative Fund 128 Depot Coffee House Fund 129 Tax Increment District Entertainment District Fund 130 Tax Increment District of Oaks of Mainstreet Fund 131 Tax Increment District Moline Fund 132 Tax Increment District Marketplace and Main Fund 133 Nonmajor Capital Projects Funds Combining Balance Sheet 136 Combining Statement of Revenues, Expenditures and Changes in Fund Balances 137 Debt Service Funds Combining Balance Sheet 138 Combining Schedule of Revenues, Expenditures and Changes in Fund Balances 140 General Fund Schedule of Revenues, Expenditures and Changes in Fund Balances Budget and Actual 143 Nonmajor Enterprise Funds Combining Schedule of Net Position 150 Combining Schedule of Revenues, Expenses and Changes in Net Position 151 Combining Statement of Cash Flows 152 Internal Service Funds Combining Schedule of Net Position 156 Combining Schedule of Revenues, Expenses and Changes in Net Position 157 Combining Statement of Cash Flows 158 Summary Financial Report Revenues and Expenditures for General Operations - Governmental Funds 160 4 City of Hopkins, Minnesota Annual Comprehensive Financial Report Table of Contents (Continued) For the Year Ended December 31, 2023 Table Page No. Statistical Section (Unaudited) Financial Trends Net Position by Component 1 164 Changes in Net Position 2 166 Fund Balances of Governmental Funds 3 170 Changes in Fund Balances of Governmental Funds 4 172 Revenue Capacity Assessed and Actual Value of Taxable Property 5 174 Direct and Overlapping Property Tax Rates 6 175 Principal Property Taxpayers 7 176 Property Tax Levies and Collections 8 177 Debt Capacity Ratio of Outstanding Debt by Type 9 178 Ratios of Net General Bonded Debt Outstanding 10 179 Direct and Overlapping Governmental Debt 11 181 Legal Debt Margin Information 12 183 Demographic and Economic Information Demographic and Economic Statistics 13 184 Principal Employers 14 185 Operating Information Full-Time Equivalent City Government Employees by Type 15 186 Operating Indicators by Function/Program 16 188 Capital Asset Statistics by Function/Program 17 190 5 THIS PAGE IS LEFT BLANK INTENTIONALLY 6 INTRODUCTORY SECTION CITY OF HOPKINS HOPKINS, MINNESOTA FOR THE YEAR ENDED DECEMBER 31, 2023 7 THIS PAGE IS LEFT BLANK INTENTIONALLY 8 Tothe Honorable Mayor, Members ofthe Hopkins City Council and the Residents of the City of Hopkins, Minnesota: The AnnualComprehensiveFinancialReportofthe City ofHopkins, Minnesota(the City)for the fiscalyearendedDecember31,2023 is herebysubmitted.Thisreportwaspreparedin accordancewith U.S.generallyacceptedaccountingprinciples(GAAP)as establishedby the GovernmentalAccounting StandardsBoard (GASB)andmeetsthe requirementsof the Hopkins. Consequently,managementassumes full responsibility for both the completenessand reliabilityof allofthe informationpresentedinthisreport.To providea reasonablebasisfor makingthese representations,managementof the Cityof Hopkinshas establisheda assetsfromloss,theft,or misuseand tocompilesufficientreliableinformationforthe preparationof the Cityof Hopkins financialstatementsin conformitywithGAAP.Because the costof internalcontrols shouldnot outweightheirbenefits,theCity of Hopkins comprehensive frameworkof internalcontrolshasbeen designedto providereasonableratherthanabsolute assurance that the financial statements will be free from material misstatement. As management, we assertthat,to the bestof our knowledgeand belief,thisfinancialreportis completeand reliable in all material respects. The City of Hopkins financial statementshavebeen auditedby Abdo LLP, a firmof licensed certifiedpublicaccountants.The goal oftheindependentauditwas toprovidereasonable assurance that the financial statements of the City of Hopkins for the fiscal year ended December 31, 2023, are free of material misstatement. The independent audit involved examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements; assessing the accountingprinciplesusedand significant estimatesmade by management;and evaluatingthe overallfinancialstatementpresentation.Theindependentauditorconcluded based upon the audit,thattherewas areasonablebasisfor renderingunmodifiedopinionsthatthe City of Hopkins financial statements for the fiscal year ended December 31, 2023, are fairly presented in the financial section of this report. GAAPrequiresthatmanagementprovidea narrativeintroduction,overview,andanalysisto accompany (MD&A). This letter of transmittal is designed to complement the MD&A and should be read in immediately following the report of the independent auditors. 3 9 Profile of the Government Hopkins was firstsettled in 1853 and was incorporatedas the Villageof WestMinneapolis in 1893. The namewaschangedin1928to Hopkinsafter oneof the earlyresidents.Theoriginal territoryof incorporationwas threesquaremiles,but successiveannexationsince1946 has enlargedthisarea by one-third.In 1947,the residentsoftheareaadopteda CityCharter witha Council/Manager form of government. The governing council is responsible, among other things, for passing ordinances, adopting the budget, appointing committees and hiring the City Manager. government,foroverseeingday-to-dayoperationsof thegovernmentand for appointingthe Authority(HRA).TheCity providesa full range of servicesincludinggeneralgovernment, publicsafety,highways and streets,urbanredevelopmentandhousing,cultureandrecreation, and healthand welfare.In additionto generalmunicipalactivities,theCity provideswater, sewer, storm sewer and refuse services and operates anice arena. Low-income rental housing is a function of the HRA. The Hopkins Fire Relief Association has not met the established criteria for inclusion in the reporting entity, and accordingly is excluded from this report. The annual budget serves as the foundationfor the Cityof Hopkins financialplanningand control. All departments of the City of Hopkins are required to submit requests for appropriation to the Finance Directorby June of each year.The FinanceDirectorusestheserequestsas the startingpointfor developinga proposedbudget.TheFinanceDirectorthen presents this proposedbudgetto theCouncilforreviewpriorto September30th. TheCouncilis requiredto holdpublic hearings on the proposed budget and to adopt a final budget no later than December 31, the close of the City of Hopkins fiscal year. The appropriatedbudgetis preparedby fund and department.Departmentheadsmay make transfersofappropriationswithina department. Transfers of appropriationsbetweenfunds require approval of the City Council. Budget to actual comparisons are provided in this report for each individual governmental fund for which an annual budget has been adopted. For the General Fund and the major Special Revenue Funds this comparison is presented on pages 5-5 as part of the basic financial statements for the governmental funds. For governmental funds, other than the General fund and major Special Revenue Funds, with annual budgets, this comparison is presented in the combining and individual fund statements and schedules subsection of this report on pages 12-133. Factors Affecting Financial Condition The Cityof Hopkins, consistingof2,504 acres,is locatedinHennepin County on thewesterly fringe of the Minneapolis urban area. The City, as part of the Minneapolis-St. Paul metropolitan complex, is readily accessible by the many highways and railways leading into the area. This easy access prompted steady growth for the City of Hopkins during its formative years. In response to this growth the City developed goals of working towards a planned community, with its policies directedtowardsoundratiosofresidential,commercialandindustrialcomponents,withthe 4 10 current tax base approximately77% single family residential and apartments, and 23% commercial- but has seen increased interest from developers since 2018 after the ground breaking for Southwest Light Rail Transit, a fourteen mile light rail line with three stops in Hopkins. TheCityCouncilandstaffalongwithanorganizedgroupofconcernedpartnersdeterminedwhat the Vision and the Mission of the City of Hopkins should be. Participation in this project was very high and the resulting Vision and Mission are as follows: CommunityVision Creatingaspiritofcommunitywhere: Allpeoplefeelsaveandrespected,anddiversityiscelebrated. Businessgrowthissupportedandavibrantdowntownismaintained. Peopleenjoyexceptionalgovernmentservices,neighborhoodsandoutstanding schools. CityofHopkins Mission Inspire,Educate,Involve,Communicate EconomicConditionandOutlook Hopkinscontinues to see an upward trend in economic and redevelopment opportunities within the City.The ground breaking for Southwest Light Rail Transit (SWLRT) occurred during 2018. The project will continue to be a catalyst for development along its corridor, including in Hopkins. Development activity is also the result of successful planning on the part of the city council and city staff. Efforts are being made for continued development and growth for 2024 and beyond. Long-termfinancialplanning The Cityof Hopkins has a strategicplan for economic development and has completed extensive planning work in anticipation of the Southwest Light Rail Transit (SWLRT) line and the three Hopkins LRT stations. As a part of the plans, the City of Hopkins intends to pursue various development and redevelopment efforts throughout the City. Futureprojects A systematic citywide sidewalk rehab program was initiated in 1992. Each year one quadrant is inspected and necessary repairs made. A sidewalk/trail plan was developed and implemented in 2003, which guides future improvements and connections to regional trails. The City has established a street reconstruction and utilityprogram based on a street condition surveyandmonitoring of water, sanitary sewer and storm sewer infrastructure. The streetsand utilitiesfound in poor condition and future problem streets will be systematically included for repairs in the five-year Capital Improvement Plan. 5 11 Certificate of Achievement ForExcellence inFinancialReporting The Government Finance Officers Association of the United States and Canada (GFOA) awarded a Certificate of Achievement for Excellence in Financial reporting to the City of Hopkins for its annual comprehensive finance report for the fiscal year ended December 31, 2022. In order to be awarded a Certificate of Achievement for Excellence in Financial Reporting, a governmental unit must publish an easily readable and efficiently organized annual comprehensive financial report. This report must satisfyboth U.S. generallyaccepted accounting principles and applicable legal requirements. A Certificate of Achievement is valid for a period of one year only. We believe our current annual comprehensive financial report continues to meet the Certificate of Achievement another certificate. Acknowledgments We wish to express our appreciation to the Mayor and City Council for their continued interest and support in planning and conducting the financial operations of the City in a responsible and progressive manner. We also want to express our appreciation to the Finance Department staff for their work in preparing this report. Respectfullysubmitted, MichaelJ.MornsonNickBishop,CPA CityManagerFinanceDirector 6 12 Government Finance Officers Association Certificate of Achievement for Excellence in Financial Reporting Presented to City of Hopkins Minnesota For its Annual Comprehensive Financial Report For the Fiscal Year Ended December 31, 2022 Executive Director/CEO 13 THIS PAGE IS LEFT BLANK INTENTIONALLY 14 City of Hopkins, Minnesota Elected and Appointed Officials For the Year Ended December 31, 2023 15 Organizational Chart Residents City Council Boards & Commissions City Manager City AttorneyCity Clerk Planning and Community FinanceFirePolicePublic WorksRecreation Economic Services Development Joint Recreation CommunicationsAssessingBuilding Fire & Medical Patrol Economic Maintenance & Response DevelopmentDepot Coffee Information Accounting Investigation Equipment House Services Prevention Housing Payroll Communication Services Inspections Emergency Planning & Zoning Utility Billing Crime PreventionEngineering Preparedness Activity Center Public Housing Outreach Parks & Forestry Arts Center Streets & Traffic Refuse Water & Sewer Pavilion/Ice Arena 16 FINANCIAL SECTION CITY OF HOPKINS HOPKINS, MINNESOTA FOR THE YEAR ENDED DECEMBER 31, 2023 17 THIS PAGE IS LEFT BLANK INTENTIONALLY 18 INDEPENDENT AUDITORS REPORT Honorable Mayor and City Council City of Hopkins, Minnesota Report on the Audit of the Financial Statements Opinions We have audited the accompanying financial statements of the governmental activities, the business-type activities, each major fund and the aggregate remaining fund information of the City of Hopkins, Minnesota (the City), as of and for the year ended December31,2023 basic financial statements as listed in the table of contents. In our opinion, the financial statements referred to above present fairly, in all material respects, the respective financial position of the governmental activities, the business-type activities, each major fund and the aggregate remaining fund information of the City as of December 31, 2023, and the respective changes in financial position and, where applicable, cash flows thereof and the budgetary comparison for the General fund, Economic Development specialrevenue fund and the Tax Increment Super Valu special revenue fund for the year then ended in accordance with accounting principles generally accepted in the United States of America. Basis for Opinions We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of Audit of the Financial Statements section of our report. We are required to be independent of theCityand to meet our other ethical responsibilities, in accordance with the relevant ethical requirements relating to our audit. We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our audit opinions. Responsibilities of Management for the Financial Statements Management is responsible for the preparationand fair presentation of these financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. In preparing the financial statements, management is required to evaluate whether there are conditions or events, considered in the aggregate, that raise substantial doubt about the City months beyond the financial statement date, including any currently known information that may raise substantial doubt shortly thereafter. 19 Our objectives are to obtain reasonable assurance about whether the financial statements as a whole are free from Reasonable assurance is a high level of assurance but is not absolute assurance and therefore is not a guarantee that an audit conducted in accordance with generally accepted auditing standards and Government Auditing Standards will always detect a material misstatement when it exists. The risk of not detecting a material misstatement resulting from fraud is higher than for one resulting from error, as fraud may involve collusion, forgery, intentional omissions, misrepresentations, or the override of internal control. Misstatements are considered material if there is a substantial likelihood that, individually or in the aggregate, they would influence the judgment made by a reasonable user based on the financial statements. In performing an audit in accordance with generally accepted auditing standards and Government Auditing Standards, we: Exercise professional judgment and maintain professional skepticism throughout the audit. Identify and assess the risks of material misstatement of the financial statements, whether due to fraud or error, and design and perform audit procedures responsive to those risks. Such procedures include examining, on a test basis, evidence regarding the amounts and disclosures in the financial statements. Obtain an understanding of internal control relevant to the audit in order to design audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of the Cityinternal control. Accordingly, no such opinion is expressed. Evaluate the appropriateness of accounting policies used and the reasonableness of significant accounting estimates made by management, as well as evaluate the overall presentation of the financial statements. Conclude whether, in our judgment, there are conditions or events, considered in the aggregate, that raise substantial doubt about theCityability to continue as a going concern for a reasonable period of time. We are required to communicate with those charged with governance regarding, among other matters, the planned scope and timing of the audit, significant audit findings, and certain internal control-related matters that we identified during the audit. Other Matters Required Supplementary Information Analysis starting on page 2 and the Schedule of 106 be presented to supplement the basic financial statements. Such information is the responsibility of management and, although not a part of the basic financial statements, is required by the Governmental Accounting Standards Board who considers it to be an essential part of financial reporting for placing the basic financial statements in an appropriate operational, economic, or historical context. We have applied certain limited procedures to the required supplementary information in accordance with auditing standards generally accepted in the United States of America, which consisted of inquiries of management about to our inquiries, the basic financial statements, and other knowledge we obtained during our audit of the basic financial statements. We do not express an opinion or provide any assurance on the information because the limited procedures do not provide us with sufficient evidence to express an opinion or provide any assurance. 20 Supplementary Information Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the accompanying supplementary information as listed in the table of contents is presented for purposes of additional analysis and are not a required part of the basic financial statements. Such information is the responsibility of management and was derived from and relates directly to the underlying accounting and other records used to prepare the basic financial statements. The information has been subjected to the auditing procedures applied in the audit of the basic financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the basic financial statements or to the basic financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America. In our opinion, the supplementary information as listed in the table of contents isfairly stated, in all material respects, in relation to the basic financial statements as a whole. Other Information Management is responsible for the other information included in the annual report. The other information comprises the introductory section and statistical section thereon. Our opinions on the basic financial statements do not cover the other information, and we do not express an opinion or any form of assurance thereon. In connection with our audit of the basic financial statements, our responsibility is to read the other information and consider whether a material inconsistency exists between the other information and the basic financial statements, or the other information otherwise appears to be materially misstated. If, based on the work performed, we conclude that an uncorrected material misstatement of the other information exists, we are required to describe it in our report. Other Reporting Required by Government Auditing Standards In accordance with Government Auditing Standards, we have also issued our report dated , on our provisions of laws, regulations, contracts, and grant agreements and other matters. The purpose of that report is solely to describe the scope of our testing of internal control over financial reporting and compliance and the results of that testing,and not to provide an opinion on the effectiveness of internal control over financial reporting or on compliance. That report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the Abdo Minneapolis, Minnesota 21 THIS PAGE IS LEFT BLANK INTENTIONALLY 22 As management of the City of Hopkins narrative overview and analysis of the financial activities of the City for the fiscal year ended December 31, 2023. Financial Highlights The assets and deferred outflows of resources of the City exceeded its liabilities and deferred inflows of resources at the close of the most recent fiscal year as shown in the summary of net position on the following pages. The unrestricted amount of net position may be used to meet the Cresidents and creditors. increased as shown in the summary of changes in net assets table on the following pages. The increase this year was due primarily to an increase in tax revenue, operating grants and contributions, and unrestricted investment earnings. For the current fiscal year, the City's governmental funds fund balances are shown in the Financial Analysis of the City's Funds section of the MD&A. The total fund balance increased in comparison with the prior year. This increase was mainly due to an increase in tax revenue and the issuance of 2023A bonds. increased from prior year. The increase is mainly due to revenue related to taxes and grant revenue. increased during the fiscal year. The increase was a combination of schedule debt service payments as shown on the outstanding schedule offset by new bond issuance. 23 Overview of the Financial Statements . basic financial statements comprise three components: 1) government-wide financial statements, 2) fund financial statements, and 3)notesto the financial statements. This report also contains other supplemental information in addition to the basic financial statements themselves. The financial statements also include notes that explain some of the information in the financial statements and provide more detailed data. The statements are followed by a section of combining and individual fund financial statements and schedules that further explains and supports the information in the financial statements. Figure 1 shows how therequired parts of this annual report are arranged and relate to one another. In addition to these required elements, we have included a section with combining and individual fund financial statements and schedules that provide details about nonmajor governmental funds, which are added together and presented in single columns in the basic financial statements. Figure 1 Required Components of the Management's BasicRequired Discussion and Financial Supplementary Analysis StatementsInformation Government-FundNotes to the wide Financial FinancialFinancial StatementsStatementsStatements SummaryDetail 24 financial statements, including the portion of the City government they cover and the types of information they contain. and analysis explains the structure and contents of each of the statements. Figure 2 Major Features of the Government-wide and Fund Financial Statements Fund Financial Statements Government-wide Governmental Funds Proprietary Funds Statements Scope Entire City government The activities of the City that Activities the City (except fiduciary funds) are not proprietary or operates similar to private fiduciary, such as police, fire businesses, such as the units and parks water and sewer system Required financial Statement of Net Balance Sheet Statements of Net statements Position Position Statement of Revenues, Statement of Activities Expenditures, and Statements of Changes in Fund Revenues, Expenses Balances and Changes in Fund Net Position Statements of Cash Flows Accounting basis and Accrual accounting and Modified accrual accounting Accrual accounting and measurement focus economic resources focus and current financial economic resources focus resources focus Type of asset/liability All assets and liabilities, Only assets expected to be All assets and liabilities, informationboth financial and capital, used up and liabilities that both financial and capital, and short-term and long-come due during the year or and short-term and long- term soon thereafter; no capital term assets included Type of deferred All deferred Only deferred outflows of All deferred outflows/inflows of outflows/inflows of resources expected to be outflows/inflows of resources information resources, regardless of used up and deferred resources, regardless of when cash is received or inflows of resources that when cash is received or paid come due during the year or paid soon thereafter; no capital assets included Type of inflow/out flow All revenues and expenses Revenues for which cash is All revenues and expenses informationduring year, regardless of received during or soon during the year, regardless when cash is received or after the end of the year; of when cash is received paid expenditures when goods or or paid services have been received and payment is due during the year or soon thereafter 25 Government-wide Financial Statements. The government-wide financial statements are designed to provide readers with -sector business. The tubufnfou!pg!ofu!qptjujpo and deferred outflows of resources and liabilities and deferred inflows of resources, with the difference reported as ofu!qptjujpo. Over time, increases or decreases in net position may serve as a useful indicator of whether the financial position of the City is improving or deteriorating. The tubufnfou!pg!bdujwjujft position changed during the most recent fiscal year. All changes in net position are reported as soon as the underlying event giving rise to the change occurs, sfhbsemftt!pg!uif!ujnjoh!pg!sfmbufe!dbti!gmpxt. Thus, revenues and expenses are reported in this statement for some items that will only result in cash flows in future fiscal periods (e.g., uncollected taxes and earned but unused vacation leave). Both of the government-wide financial statements distinguish functions of the City that are principally supported by taxes and intergovernmental revenue (hpwfsonfoubm!bdujwjujft) from other functions that are intended to recover all or a significant portion of their costs through user fees and charges (cvtjoftt.uzqf!bdujwjujft). The governmental activities of the City include general government, public safety, public works, culture and recreation, economic development and interest on long-term debt. The business-type activities of the City include major funds: water, sewer, storm sewer, and pavilion and nonmajor funds: refuse and housing authority. The government-wide financial statements include not only the City itself (known as the qsjnbsz!hpwfsonfou), but also a legally separate Hopkins Housing and redevelopment Authority for which the City is financially accountable. Although the Hopkins Housing and Redevelopment Authority is legally separate, it functions for all practical purposes as a department of the City of Hopkins, and therefore has been included as a integral part of the primary government. The government-wide financial statements start on page 39 of this report. Fund Financial Statements. A gvoe is a grouping of related accounts that is used to maintain control over resources that have been segregated for specific activities or objectives. The City, like other state and local governments, uses fund accounting to ensure and demonstrate compliance with finance-related legal requirements. All of the funds of the City can be divided into three categories: governmental funds, proprietary funds and fiduciary funds. Hpwfsonfoubm!Gvoet. Hpwfsonfoubm!gvoet are used to account for essentially the same functions reported as hpwfsonfoubm!bdujwjujft in the government-wide financial statements. However, unlike the government-wide financial statements, governmental fund financial statements focus on ofbs.ufsn!jogmpxt!boe!pvugmpxt!pg!tqfoebcmf!sftpvsdft, as well as on cbmbodft!pg!tqfoebcmf!sftpvsdft available at the end of the fiscal year. Such information may be useful in -term financing requirements. Because the focus of governmental funds is narrower than that of the government-wide financial statements, it is useful to compare the information presented for hpwfsonfoubm!gvoet with similar information presented for hpwfsonfoubm! bdujwjujft in the government-wide financial statements. By doing so, readers may better understand the long-term impact -term financing decisions. Both the governmental fund balance sheet and the governmental fund statement of revenues, expenditures and changes in fund balances provide a reconciliation to facilitate this comparison between hpwfsonfoubm!gvoet and hpwfsonfoubm!bdujwjujft. The City maintains numerous individual governmental funds. Information is presented separately in the governmental fund balance sheet and in the governmental fund statement of revenues, expenditures and changes in fund balances for the General, Economic Development, Tax Increment Super Valu, Permanent Improvement Revolving and Debt Service funds, all of which are considered to be major funds. Data from the other governmental funds are combined into a single, aggregated presentation. Individual fund data for each of these nonmajor governmental funds is provided in the form of dpncjojoh!tubufnfout!ps!tdifevmft elsewhere in this report. The City adopts an annual appropriated budget for its General fund, Economic Development special revenue fund, and Tax Increment Super Valu special revenue fund. Budgetary comparison statement and schedules have been provided for these funds to demonstrate compliance with their budgets. The basic governmental fund financial statements start on page 44 of this report. 26 Qspqsjfubsz!Gvoet. The City maintains two types of proprietary funds and internal service funds/!Foufsqsjtf!gvoet are used to report the same functions presented as cvtjoftt.uzqf!bdujwjujft in the government-wide financial statements. The City uses enterprise funds to account for its water, sewer, storm sewer, pavilion, refuse and housing authority. The City uses an internal service fund to account equipment replacement, employee benefits and insurance risk. Because these services predominantly benefit governmental functions rather than business-type functions, they have been included within governmental activities in the government-wide financial statements. Proprietary funds provide the same type of information as the government-wide financial statements, only in more detail. The proprietary fund financial statements provide separate information for each of the enterprise funds which are considered to be major funds of the City. The basic proprietary fund financial statements start on page 5 of this report. Notes to the Financial Statements. The notes provide additional information that is essential to a full understanding of the data provided in the government-wide and fund financial statements. The notes to the financial statements start on page 6 of this report. Required Supplementary Information. In addition to the basic financial statements and accompanying notes, this report also presents defined benefits plans, schedules of contributions, and progress in funding its obligation to provide pension and other postemployment benefits to its employees. Required supplementary information can be found starting on page 106 of this report. Other Information. The combining statements referred to earlier in connection with nonmajor governmental funds and internal service funds are presented following the notes to the financial statements. Combining and individual fund financial statements and schedules start on page 116 of this report. Government-wide Financial Analysis As noted earlier, net position . In the case of the City, assets and deferred outflows of resources exceeded liabilities and deferred inflows of resources at the close of the most recent fiscal year. d equipment) less any related debt used to acquire those assets that are still outstanding. The City uses these capital assets to provide services to residents; consequently, these assets are not available for future spending. resources needed to repay this debt must be provided from other sources, since the capital assets themselves cannot be used to liquidate these liabilities. 27 City of HopkinsSummary of Net Position At the end of the current fiscal year, the City is able to report positive balances in its net investment in capital assets and restricted net position, both for the City as a whole, as well as for its separate governmental and business-type activities. The City also reports positive unrestricted net position in governmental, business-type activities, and the City as a whole. 28 Statement of Activities. Governmental type activities and the business-type activities in Key elements of the overall decrease are as follows: City of HopkinsChanges in Net Position Governmental ActivitiesBusiness-type Activities IncreaseIncrease 20232022(Decrease)20232022(Decrease) Revenues Program Revenues Charges for services$ 3,876,253$ 3,867,099$ 9,154$ 8,815,025$ 8,257,538$ 557,487 Operating grants and contributions 2,873,391 1,536,123 1,337,268 844,202 565,267 278,935 Capital grants and contributions 1,377,956 542,947 835,009 - - - General revenues Taxes Property taxes 18,630,743 17,536,200 1,094,543 340,000 417,999 (77,999) Tax increment 3,481,962 4,108,301 (626,339) - - - Franchise and other 1,162,668 1,160,763 1,905 - - - Grants and contributions not restricted to specific programs 1,771,853 1,356,976 414,877 - - - Unrestricted investment earnings (loss) 1,812,017 328,320 1,483,697 23,309 (1,052) 24,361 Gain on sale of capital assets 85,778 112,496 (26,718) 31,777 250,000 (218,223) Total Revenues 35,072,621 30,549,225 4,523,396 10,054,313 9,489,752 564,561 Expenses General government 5,040,785 4,226,750 814,035 - - - Public safety 11,669,337 9,841,518 1,827,819 - - - Public works 4,495,490 4,149,085 346,405 - - - Culture and recreation 4,308,046 4,183,137 124,909 - - - Urban development and housing 3,908,244 8,036,771 (4,128,527) - - - Interest on long-term debt 1,530,798 1,703,818 (173,020) - - - Water - - - 2,197,562 2,354,679 (157,117) Sewer - - - 2,950,830 2,894,178 56,652 Refuse - - - 1,260,831 1,327,982 (67,151) Storm sewer - - - 529,473 544,962 (15,489) Pavilion - - - 1,061,595 1,096,391 (34,796) Housing authority - - - 825,703 914,637 (88,934) Total Expenses 30,952,700 32,141,079 (1,188,379) 8,825,994 9,132,829 (306,835) Increase (Decrease) in Net Position Before Transfers 4,119,921 (1,591,854) 5,711,775 1,228,319 356,923 871,396 Transfers (Net) 471,762 471,762 - (471,762) (471,762) - Change in Net Position 4,591,683 (1,120,092) 5,711,775 756,557 (114,839) 871,396 Net Position, January 1 56,729,298 57,849,390 (1,120,092) 31,601,866 31,716,705 (114,839) Net Position, December 31$ 61,320,981 $ 56,729,298 $ 4,591,683$ 32,358,423 $ 31,601,866 $ 756,557 Revenues increased in the current year in property taxes, grants and investment earnings. The increase in property taxes relates to an increase in the annual levy and the increase in investment earnings is due to annual Expenses decreased during the year mainly due to the completion of urban development projects in prior year. 29 The majority of governmental activities are funded through a tax levy and general revenue support. The following graph depicts various governmental activities and shows the revenue and expenses directly related to those activities. Expenses and Program Revenue-Governmental Activities $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 $- GeneralPublic SafetyPublic WorksCulture andUrbanInterest on Long- GovernmentRecreationDevelopmentterm Debt and Housing ExpensesProgram Revenues Revenue by Source-Governmental Activities Charges for Services Operating Grants and Other 11.0% Contributions 5.4% 8.2% Capital Grants and Contributions 3.9% Grants and Contributions Unrestricted 5.1% Taxes 66.4% 30 Business-type Activities. Business-type activities are meant to be supported by program revenues. Program revenues exceeded expenses in the Water, Sewer, Pavilion and Housing Authority Funds. Expenses exceeded program revenues in the Refuse and Pavilion funds. Business-type activities dedecrease are as follows: Expenses and Program Revenues - Business Type Activities As noted earlier, the City uses fund accounting to ensure and demonstrate compliance with finance-related legal requirements. Hpwfsonfoubm!Gvoet. hpwfsonfoubm!gvoet is to provide information on near-term inflows, outflows and balances of tqfoebcmf particular, vobttjhofe!gvoe!cbmbodf spending at the end of the fiscal year. The table below outlines the governmental fund balances for the year ending December 31, 2023. Other Economic Permanent GeneralTax IncrementDebtGovernmentalPrior Year Development Improvement FundSuper ValueServiceFundsTotalTotal Authority Revolving Fund Balances $ 323,992$ 300,820 Nonspendable$ 316,170$ 5,931$ -$ -$ -$ 1,891 11,863,013 12,352,557 Restricted for 13,166 - - - 7,800,338 4,049,509 5,273,080 3,434,292 Committed for - 5,200,059 - - - 73,021 2,112,547 2,762,981 Assigned for 245,494 - - 169,889 - 1,697,164 7,296,025 7,062,575 Unassigned 8,885,553 - (507,717) - - (1,081,811) Total$ 9,460,383$ 5,205,990$ (507,717) $ 169,889$ 7,800,338$ 4,739,774$ 26,868,657$ 25,913,225 and 3. 31 The General fund is the chief operating fund of the City. At the end of the current year, the fund balance of the General unassigned fund balance and total fund balance to total fund expenditures. The total unassigned fund balance as a percent of total fund expenditures is shown in the chart below along with total fund balance as a percent of total expenditures. increased during the current fiscal year as shown in the table above. Revenues increased in the current year in property taxes, grants and investment earnings. The increase in property taxes relates to investment portfolio. More detail on the fund balance increase is shown below in the budgetary highlights. Other major governmental fund analysis follows: Increase 20232022(Decrease) Economic Development Authority$ 5,205,990$ 4,525,777$ 680,213 Uifsf!xbt!bo!jodsfbtf!jo!gvoe!cbmbodf!evf!up! sfdfjwjoh!nvmujqmf!joufshpwfsonfoubm!hsbout!uibu!xfsf!opu!cvehfufe/ Tax Increment Super Value$ (507,717) $ 344,501$ (852,218) Efdsfbtf!jo!gvoe!cbmbodf!xbt!evf!up!b!zfbs!foe !usbotgfs!pvu!pg!uif!gvoe/ Permanent Improvement Revolving$ 169,889$ 994,413$ (824,524) Efdsfbtf!jo!gvoe!cbmbodf!evf!up!dbqjubm!pvumbz!dptut!fydffejoh!sfwfovft/!Efdsfbtf! xbt!pggtfu!cz!usbotgfs!jo!gspn!efcu!tfswjdf!gvoe!gvoefe!cz!cpoe!jttvbodf!jo!3134/ Debt Service Funds$ 7,800,338$ 7,482,692$ 317,646 Upubm!gvoe!cbmbodf!gps!efcu!tfswjdf!bddpvout!jodsfbtfe! evf!up!uif!usbotgfst!jo!up!uif!gvoe/ ! 32 Qspqsjfubsz!Gvoet. -wide financial statements, but in more : General fund Budgetary Highlights decrease in fund balance. Total revenues show a positive budget variance due to licenses for permits, charges for services and intergovernmental revenues being greater than expected. The expenditures were over budget due to higher general government, public safety, and culture & recreation costs than anticipated. Original/Final BudgetedActualVariance with AmountAmountsFinal Budget Revenues$ 17,188,440$ 18,335,397$ 1,146,957 Expenditures 17,168,440 17,831,191 (662,751) Excess of Revenues Over Expenditures 20,000 504,206 484,206 Other Financing Sources (Uses) Transfers out (20,000) (56,924) (36,924) Net Change in Fund Balances - 447,282 447,282 Fund Balances, January 1 9,013,101 9,013,101 - Fund Balances, December 31$ 9,013,101$ 9,460,383$ 447,282 33 Capital Asset and Debt Administration Capital Assets. -type activities as of December 31, 2023 is shown below. This investment in capital assets includes land, buildings, infrastructure, machinery current fiscal year for governmental and business-type activities is shown in the table below. C starting on page of this report. City of HopkinsCapital Assets (Net of Depreciation) Long-term Debt. At the end of the current fiscal year, the City had total bonded debt outstanding consisting of general obligation debt and general obligation revenue debt. backed by the full faith and credit of the City. City of HopkinsOutstanding Debt increased during the current fiscal year. The main reason for the increase in overall debt is due to the City making regularly scheduled debt payments during the year and the issuance of new debt in 2023. Minnesota statutes limit the amount of net general obligation debt a City may issue to 3 percent of the market value of taxable property within the City. Net debt is debt payable solely from ad valorem taxes. There is no outstanding debt at year end that is subject to the limit. -term debt can be found in Note 3E starting on page 8 of this report. 34 A number of factors were taken into consideration when preparing the City of Hopkins 2024 budget. The City will complete a street reconstruction and infrastructure project as part of its residential street improvement program. Employee compensation will remain competitive in the market, which was most recently affirmed with a compensation and classification study in 2023. Water and sewer rates were increased incrementally and based on operational needs. The City continues to use a Financial Management Plan that can estimate the property tax increases or decreases on a median value home as a basis for decision making. As a result of these factors the City prepared a budget for 2024 that included a general fund increase of 7.18% and an overall increase to the tax levy 4.86%. During the current fiscal year, unassigned fund balance in the general fund was $8,883,963 or 50% of general fund expenditures. The Office of the State Auditor recommends unassigned fund balances of no less than five months of its property tax levy revenues in June. Requests for Information This financial report is designed to provide a general overview of the City of Hopkins finances for all those with an interest additional financial information should be addressed to the Director of Finance, City of Hopkins, 1010 First Street South, Hopkins, MN 55343. 35 THIS PAGE IS LEFT BLANK INTENTIONALLY 36 GOVERNMENT-WIDE FINANCIAL STATEMENTS CITY OF HOPKINS HOPKINS, MINNESOTA FOR THE YEAR ENDED DECEMBER 31, 2023 37 THIS PAGE IS LEFT BLANK INTENTIONALLY 38 City of Hopkins, Minnesota Statement of Net Position December 31, 2023 GovernmentalBusiness-type ActivitiesActivitiesTotal Assets Cash and temporary investments$ 36,365,302$ 8,403,188 $ 44,768,490 Receivables Accrued interest 95,488 - 95,488 Taxes 375,290 - 375,290 Loans 7,901 - 7,901 Accounts477,579 529,814 1,007,393 Leases 973,298 1,039,275 2,012,573 Special assessments 4,337,948 - 4,337,948 Due from other governments 523,126 186,732 709,858 Internal balances 88,866 (88,866) - Prepaid items 216,907 167,577 384,484 Inventories 107,085 33,785 140,870 Assets held for resale 689,792 - 689,792 Net pension asset 389,338 - 389,338 Capital assets Land and construction in progress 12,462,994 3,572,798 16,035,792 Depreciable assets (net of accumulated depreciation)86,338,880 46,024,955 132,363,835 Total Assets 143,449,794 59,869,258 203,319,052 Deferred Outflows of Resources Deferred pension resources 9,105,104 213,532 9,318,636 Deferred other postemployment benefits 444,852 84,549 529,401 Total Deferred Outflows of Resources 9,549,956 298,081 9,848,037 Liabilities Accounts and contracts payable 6,713,965 201,890 6,915,855 Accrued salaries payable 739,766 105,547 845,313 Due to other governments 53,612 11,472 65,084 Accrued interest payable 798,588 333,235 1,131,823 Deposits payable 19,556 7,698 27,254 Unearned revenue 1,155,583 192,880 1,348,463 Noncurrent liabilities Due within one year Long-term liabilities 6,197,710 1,614,782 7,812,492 Other postemployment benefit liability 252,769 48,041 300,810 Due in more than one year Long-term liabilities 56,624,720 23,021,736 79,646,456 Net pension liability 8,408,838 846,127 9,254,965 Other postemployment benefit liability 816,963 155,272 972,235 Total Liabilities 81,782,070 26,538,680 108,320,750 Deferred Inflows of Resources Deferred pension resources 8,800,806 265,928 9,066,734 Deferred lease resources 965,290 979,486 1,944,776 Deferred other postemployment benefits 130,603 24,822 155,425 Total Deferred Inflows of Resources 9,896,699 1,270,236 11,166,935 Net Position Net investment in capital assets 37,145,331 26,094,187 63,239,518 Restricted for Debt service 11,093,785 - 11,093,785 Economic development 2,699,876 - 2,699,876 Park improvements 526,100 - 526,100 Equity initiative 46,073 - 46,073 Public safety 790,626 - 790,626 Net pension asset 389,338 - 389,338 Unrestricted 8,629,852 6,264,236 14,894,088 Total Net Position$ 61,320,981$ 32,358,423$ 93,679,404 The notes to the financial statements are an integral part of this statement. 39 City of Hopkins, Minnesota Statement of Activities For the Year Ended December 31, 2023 Program Revenue Operating Capital Grants Charges forGrants andand Functions/Programs ExpensesServicesContributionsContributions Governmental Activities General government$ 5,040,785 $ 2,592,754 $ 220,004 $ - Public safety 11,669,337 165,122 1,155,101 - Public works 4,495,490 119,314 382,073 1,377,956 Culture and recreation 4,308,046 998,940 379,271 - Urban development and housing 3,908,244 123 736,942 - Interest on long-term debt 1,530,798 - - - Total Governmental Activities 30,952,700 3,876,253 2,873,391 1,377,956 Business-type Activities Water 2,197,562 2,695,990 9,679 - Sewer 2,950,830 3,323,407 86,875 - Refuse 1,260,831 1,200,980 37,836 - Storm sewer 529,473 802,032 4 - 1,061,595 510,075 21 - Pavilion Housing authority 825,703 282,541 709,787 - Total Business-type Activities 8,825,994 8,815,025 844,202 - Total $ 39,778,694$ 12,691,278$ 3,717,593 $ 1,377,956 General Revenues Taxes Property taxes, levied for general purposes Property taxes, levied for debt service Tax increments Franchise and other taxes Grants and contributions not restricted to specific programs Gain on sale of capital assets Unrestricted investment earnings Transfers Total General Revenues and Transfers Change in Net Position Net Position, January 1 Net Position, December 31 The notes to the financial statements are an integral part of this statement. 40 Net (Expenses) Revenues and Changes in Net Position GovernmentalBusiness-type ActivitiesActivitiesTotal $ (2,228,027)$ -$ (2,228,027) (10,349,114) - (10,349,114) (2,616,147) - (2,616,147) (2,929,835) - (2,929,835) (3,171,179) - (3,171,179) (1,530,798) - (1,530,798) (22,825,100) - (22,825,100) - 508,107 508,107 - 459,452 459,452 - (22,015) (22,015) - 272,563 272,563 - (551,499) (551,499) - 166,625 166,625 - 833,233 833,233 (22,825,100) 833,233 (21,991,867) 14,737,997 340,000 15,077,997 3,892,746 - 3,892,746 3,481,962 - 3,481,962 1,162,668 - 1,162,668 1,771,853 - 1,771,853 85,778 31,777 117,555 1,812,017 23,309 1,835,326 471,762 (471,762) - 27,416,783 (76,676) 27,340,107 4,591,683 756,557 5,348,240 56,729,298 31,601,866 88,331,164 $ 61,320,981$ 32,358,423$ 93,679,404 The notes to the financial statements are an integral part of this statement. 41 THIS PAGE IS LEFT BLANK INTENTIONALLY 42 FUND FINANCIAL STATEMENTS CITY OF HOPKINS HOPKINS, MINNESOTA FOR THE YEAR ENDED DECEMBER 31, 2023 43 City of Hopkins, Minnesota Balance Sheet Governmental Funds December 31, 2023 212315342612 Permanent EconomicTax IncrementImprovement GeneralDevelopmentSuper ValueRevolving Assets Cash and temporary investments$ 9,362,965 $ 4,121,152 $ 2,900,100 $ 1,521,626 Receivables Accounts 186,520 41,000 - 4,566 Taxes 371,842 3,448 - - Leases - - - - Accrued interest 95,488 - - - Loans - - - - Special assessments - - - 243,666 Due from other governments 159,077 172,300 - 182,426 Due from other funds 467,567 654,222 - - Prepaid items 209,085 5,931 - - Inventory 107,085 - - - Assets held for resale - 227,404 462,388 - Total Assets$ 10,959,629$ 5,225,457 $ 3,362,488 $ 1,952,284 Liabilities Accounts and contracts payable$ 319,653$ 2,905$ 3,870,205 $ 1,359,522 Accrued salaries payable 672,222 14,474 - - Due to other governments 52,573 - - - Deposits payable 19,556 - - - Unearned revenue 313,468 - - - Due to other funds - - - - Total Liabilities 1,377,472 17,379 3,870,205 1,359,522 Deferred Inflows of Resources Deferred lease resources - - - - Unavailable revenues - taxes 121,774 2,088 - - Unavailable revenues - special assessments - - - 240,447 Unavailable revenues - intergovernmental - - - 182,426 Total Deferred Inflows of Resources 121,774 2,088 - 422,873 Fund Balances Nonspendable 316,170 5,931 - - Restricted 13,166 - - - Committed - 5,200,059 - - Assigned 245,494 - - 169,889 Unassigned 8,885,553 - (507,717) - Total Fund Balances 9,460,383 5,205,990 (507,717) 169,889 Total Liabilities, Deferred Inflows of Resources and Fund Balances$ 10,959,629$ 5,225,457 $ 3,362,488 $ 1,952,284 The notes to the financial statements are an integral part of this statement. 44 DebtOtherTotal ServiceGovernmentalGovernmental FundFundsFunds $ 7,835,015 $ 7,475,394 $ 33,216,252 - 224,230 456,316 - - 375,290 - 973,298 973,298 - - 95,488 - 7,901 7,901 4,094,282 - 4,337,948 - 9,323 523,126 - - 1,121,789 - 1,891 216,907 - - 107,085 - - 689,792 $ 11,929,297$ 8,692,037 $ 42,121,192 $ -$ 1,094,750 $ 6,647,035 - 53,070 739,766 - 1,039 53,612 - - 19,556 - 842,115 1,155,583 36,924 995,999 1,032,923 36,924 2,986,973 9,648,475 - 965,290 965,290 - - 123,862 4,092,035 - 4,332,482 - - 182,426 4,092,035 965,290 5,604,060 - 1,891 323,992 7,800,338 4,049,509 11,863,013 - 73,021 5,273,080 - 1,697,164 2,112,547 - (1,081,811) 7,296,025 7,800,338 4,739,774 26,868,657 $ 11,929,297$ 8,692,037 $ 42,121,192 The notes to the financial statements are an integral part of this statement. 45 THIS PAGE IS LEFT BLANK INTENTIONALLY 46 City of Hopkins, Minnesota Reconciliation of the Balance Sheet to the Statement of Net Position Governmental Funds December 31, 2023 Amounts reported for the governmental activities in the statement of net position are different because Total Fund Balances - Governmental$ 26,868,657 Capital assets used in governmental activities are not financial resources and therefore are not reported as assets in governmental funds. Cost of capital assets 136,158,506 Less: accumulated depreciation (41,723,737) Long-term liabilities, including bonds payable, are not due and payable in the current period and therefore are not reported as liabilities in the funds. Long-term liabilities at year-end consist of Bond principal payable (58,795,000) Plus: premiums on bonds issued (2,861,543) Other postemployment benefits payable (1,069,732) Net pension liability (8,408,838) Long-term assets from pensions reported in governmental activities are not financial resources and therefore, are not reported as assets in the funds. Net pension asset 389,338 Some receivables are not available soon enough to pay for the current period's expenditures, and therefore are unavailable in the funds. Taxes 123,862 Special assessments 4,332,482 Intergovernmental 182,426 Internal service funds are used by the City to charge the costs of certain activities, such as replacement of City vehicles and equipment. The assets and liabilities of the internal service funds are included in the governmental activities in the statement of net position 6,304,601 Governmental funds do not report long-term amounts related to pensions and other postemployment benefits Deferred outflows of pension resources 9,105,104 Deferred inflows of pension resources (8,800,806) Deferred outflows of other postemployment benefits 444,852 Deferred inflows of other postemployment benefits (130,603) Governmental funds do not report a liability for accrued interest until due and payable. (798,588) Total Net Position - Governmental Activities$ 61,320,981 The notes to the financial statements are an integral part of this statement. 47 City of Hopkins, Minnesota Statement of Revenues, Expenditures and Changes in Fund Balances Governmental Funds For the Year Ended December 31, 2023 212315342612 Permanent EconomicTax IncrementImprovement GeneralDevelopmentSuper ValueRevolving Revenues Property taxes$ 13,628,350$ 477,255 $ -$ - Tax increment - - 2,164,722 - Franchise taxes 304,979 - - - Licenses and permits 1,744,095 - - - Intergovernmental 1,884,698 736,942 - 416,512 Charges for services 464,629 123 - 6,278 Fines and forfeitures 100,924 - - - Special assessments - - - 320,670 Investment earnings 159,376 80,539 67,604 402,661 Miscellaneous 48,346 - - - Total Revenues 18,335,397 1,294,859 2,232,326 1,146,121 Expenditures Current General government 3,062,158 - - - Public safety 10,019,974 - - - Public works 1,863,073 - - - Culture and recreation 2,612,634 - - - Urban development and housing 77,229 586,176 714,673 - Capital outlay General government 130,491 - - - Public safety 18,310 - - - Public works 47,322 - - 5,707,294 Culture and recreation - - - - Urban development and housing - - - - Debt service Principal - - - - Interest and other charges - - - - Total Expenditures 17,831,191 586,176 714,673 5,707,294 Excess (Deficiency) of Revenues Over (Under) Expenditures 504,206 708,683 1,517,653 (4,561,173) Other Financing Sources (Uses) Transfers in - 1,530 188,429 3,817,443 Premium on bonds issued - - - - Bonds issued - - - - Transfers out (56,924) (30,000) (2,558,300) (80,794) Total Other Financing Sources (Uses) (56,924) (28,470) (2,369,871) 3,736,649 Net Change in Fund Balances 447,282 680,213 (852,218) (824,524) Fund Balances, January 1 9,013,101 4,525,777 344,501 994,413 Fund Balances, December 31$ 9,460,383$ 5,205,990$ (507,717)$ 169,889 The notes to the financial statements are an integral part of this statement. 48 DebtOtherTotal ServiceGovernmentalGovernmental FundFundsFunds $ 3,892,746$ 347,697 $ 18,346,048 - 1,317,240 3,481,962 - 857,689 1,162,668 - - 1,744,095 - 1,574,477 4,612,629 - 853,063 1,324,093 - - 100,924 855,357 - 1,176,027 1,042,315 31,156 1,783,651 - 154,312 202,658 5,790,418 5,135,634 33,934,755 - 360,253 3,422,411 - 357,448 10,377,422 - 174,668 2,037,741 - 1,131,382 3,744,016 - 200,946 1,579,024 - - 130,491 - 48,443 66,753 - 4,881 5,759,497 - 106,735 106,735 - 2,318,845 2,318,845 5,805,000 - 5,805,000 1,896,230 - 1,896,230 7,701,230 4,703,601 37,244,165 (1,910,812) 432,033 (3,309,410) 2,442,780 1,275,000 7,725,182 8,080 - 8,080 3,985,000 - 3,985,000 (4,207,402) (520,000) (7,453,420) 2,228,458 755,000 4,264,842 317,646 1,187,033 955,432 7,482,692 3,552,741 25,913,225 $ 7,800,338$ 4,739,774$ 26,868,657 The notes to the financial statements are an integral part of this statement. 49 City of Hopkins, Minnesota Reconciliation of the Statement of Revenues, Expenditures and Changes in Fund Balances to the Statement of Activities Governmental Funds For the Year Ended December 31, 2023 Amounts reported for governmental activities in the statement of activities are different because Total Net Change in Fund Balances - Governmental Funds$ 955,432 Capital outlays are reported in governmental funds as expenditures. However, in the statement of activities, the cost of those assets is allocated over the estimated useful lives as depreciation expense. Capital outlays 5,233,587 Depreciation expense (2,652,076) The issuance of long-term debt provides current financial resources to governmental funds, while the repayment of principal of long-term debt consumes the current financial resources of governmental funds. Neither transaction, however, has any effect on net position. Also, governmental funds report the effect of premiums, discounts and similar items when debt is first issued, whereas these amounts are deferred and amortized in the statement of activities. Principal repayments 5,805,000 Bonds issued (3,985,000) Premium on bonds issued (8,080) Interest due and premium amortized on long-term debt in the statement of activities differs from the amount reported in the governmental fund because they are recognized as an expenditure in the funds when due, and thus requires the use of current financial resources. In the statement of activities, however interest expense and bond premium are recognized as they accrue, regardless of when they are due. 365,432 Certain revenues are recognized as soon as it is earned. Under the modified accrual basis of accounting certain revenues cannot be recognized until they are available to liquidate liabilities of the current period. Special assessments 201,929 Property taxes 34,695 Intergovernmental (234,087) Long-term pension activity is not reported in governmental funds. Pension expense (1,215,276) Pension revenue 13,905 Some expenses reported in the statement of activities do not require the use of current financial resources and, therefore, are not reported as expenditures in governmental funds. Other post employment benefits 7,099 External revenues and expenditures of the internal service funds reported in the statement of activities are not reported as revenues and expenditures in governmental funds. 69,123 Change in Net Position - Governmental Activities$ 4,591,683 The notes to the financial statements are an integral part of this statement. 50 City of Hopkins, Minnesota Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual General Fund For the Year Ended December 31, 2023 Original and FinalActualVariance with BudgetAmountsFinal Budget Revenues Taxes$ 14,316,981$ 13,933,329$ (383,652) Licenses and permits 683,515 1,744,095 1,060,580 Intergovernmental 1,630,794 1,884,698 253,904 Charges for services 328,100 464,629 136,529 Fines and forfeitures 192,500 100,924 (91,576) Investment earnings2 0,000 159,376 139,376 Miscellaneous1 6,5504 8,3463 1,796 Total Revenues 17,188,440 18,335,397 1,146,957 Expenditures Current General government 2,846,102 3,062,158 (216,056) Public safety 9,648,977 10,019,974 (370,997) Public works 2,047,558 1,863,073 184,485 Culture and recreation 2,252,655 2,612,634 (359,979) Urban development and housing 126,8487 7,2294 9,619 Capital outlay General government 116,000 130,491 (14,491) Public safety 5,3001 8,310 (13,010) Public works 125,0004 7,3227 7,678 Total Expenditures 17,168,440 17,831,191 (662,751) Excess (Deficiency) of Revenues Over (Under) Expenditures2 0,000 504,206 484,206 Other Financing Sources (Uses) Transfers out (20,000) (56,924) (36,924) Net Change in Fund Balances- 447,282 447,282 Fund Balances, January 1 9,013,101 9,013,101 - Fund Balances, December 31$ 9,013,101 $ 9,460,383 $ 447,282 The notes to the financial statements are an integral part of this statement. 51 City of Hopkins, Minnesota Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual Economic Development Fund For the Year Ended December 31, 2023 Original and FinalActualVariance with BudgetAmountsFinal Budget Revenues Property tax$ 551,531 $ 477,255 $ (74,276) Intergovernmental - 736,942 736,942 Charges for services - 123 123 Investment earnings20,00080,539 60,539 Total Revenues 571,531 1,294,859 723,328 Expenditures Capital outlay Urban development and housing459,236586,176 (126,940) Excess (Deficiency) of Revenues Over (Under) Expenditures 112,295 708,683 596,388 Other Financing Sources (Uses) Transfers out (60,000) (30,000) 30,000 Net Change in Fund Balances 52,295 680,213 627,918 Fund Balances, January 1 4,525,777 4,525,777 - Fund Balances, December 31$ 4,578,072 $ 5,205,990 $ 627,918 The notes to the financial statements are an integral part of this statement. 52 City of Hopkins, Minnesota Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual Tax Increment Super Value Fund For the Year Ended December 31, 2023 Original and FinalActualVariance with BudgetAmountsFinal Budget Revenues Tax increment$ 2,800,000 $ 2,164,722$ (635,278) Investment earnings 20,000 67,604 47,604 Total Revenues 2,820,000 2,232,326 (587,674) Expenditures Capital outlay Urban development and housing882,000714,6731 67,327 Excess (Deficiency) of Revenues Over (Under) Expenditures 1,938,000 1,517,653 (420,347) Other Financing Sources (Uses) Transfers out (2,818,000) (2,558,300)2 59,700 Net Change in Fund Balances (880,000) (852,218) 27,782 Fund Balances, January 1 344,501 344,501 - Fund Balances, December 31$ (535,499)$ (507,717)$ 27,782 The notes to the financial statements are an integral part of this statement. 53 City of Hopkins, Minnesota Statement of Net Position (Continued on the Following Pages) Proprietary Funds December 31, 2023 Business-type Activities - Enterprise Funds 814818851858 Nonmajor Proprietary WaterSewerStorm SewerPavilionFunds Assets Current Assets Cash and temporary investments$ 1,624,593$ 1,907,811$ 3,020,528$ -$ 1,850,256 Receivables Accounts 152,910 255,4351 2,0371 7,3489 2,084 Leases5 1,208 - - - - Due from other governments - - - - 186,732 Prepaid items - 153,182 - 2,4581 1,937 Inventories3 1,361 2,381 43 - - Total Current Assets 1,860,072 2,318,809 3,032,6081 9,806 2,141,009 Noncurrent Assets Lease receivable 988,067 - - - - Capital assets Land1 4,097 5,1502 6,800 - 208,252 Construction in progress 1,281,628 1,250,744 786,127 -- Buildings3 9,589 6,500 6,500 3,272,851 6,113,399 Infrastructure 24,938,975 16,451,324 17,473,217 6,159,965 - Machinery and equipment 432,065 931,795 9,000 360,561 1,196,000 Less accumulated depreciation (8,749,869) (6,599,580) (6,290,499) (4,109,380) (5,617,458) Net Capital Assets 17,956,485 12,045,933 12,011,145 5,683,997 1,900,193 Total Noncurrent Assets 18,944,552 12,045,933 12,011,145 5,683,997 1,900,193 Total Assets 20,804,624 14,364,742 15,043,753 5,703,803 4,041,202 Deferred Outflows of Resources Deferred pension resources7 9,1543 8,041 9,1894 2,9304 4,218 Deferred other postemployment benefits2 6,0291 0,922 2,4801 2,7603 2,358 Total Deferred Outflows of Resources 105,1834 8,9631 1,6695 5,6907 6,576 The notes to the financial statements are an integral part of this statement. 54 Governmental Activities - Internal TotalsService Funds $ 8,403,188$ 3,149,050 529,814 21,263 51,208 - 186,732 - 167,577 - 33,785 - 9,372,304 3,170,313 988,067 - 254,299 - 3,318,499 22,057 9,438,839 - 65,023,481 - 2,929,421 11,026,334 (31,366,786) (6,681,286) 49,597,753 4,367,105 50,585,820 4,367,105 59,958,124 7,537,418 213,532 - 84,549 - 298,081 - The notes to the financial statements are an integral part of this statement. 55 City of Hopkins, Minnesota Statement of Net Position (Continued) Proprietary Funds December 31, 2023 Business-type Activities - Enterprise Funds 814818851858 Nonmajor Proprietary WaterSewerStorm SewerPavilionFunds Liabilities Current Liabilities Accounts payable$ 38,082$ 17,826$ 20$ 4,628 $ 141,334 Deposits payable 7,698 - - - - Accrued salaries payable 27,671 12,357 3,381 16,531 45,607 Due to other governments 2,409 - - 1,969 7,094 Due to other funds - - - 88,866 - Accrued interest payable 154,559 89,154 57,779 31,743 - Unearned revenue - - - 36,697 156,183 Other postemployment benefits 14,790 6,206 1,409 7,250 18,386 Compensated absences payable - current 14,264 7,613 3,669 28,566 20,670 Bonds payable - current 699,600 398,170 242,230 200,000 - Total Current Liabilities 959,073 531,326 308,488 416,250 389,274 Noncurrent Liabilities Other postemployment benefits 47,802 20,057 4,554 23,433 59,426 Compensated absences payable 3,567 1,903 917 7,141 5,168 Net pension liability 313,648 150,738 36,413 170,112 175,216 Bonds payable 10,682,472 5,788,626 4,153,866 2,378,076 - Total Noncurrent Liabilities 11,047,489 5,961,324 4,195,750 2,578,762 239,810 Total Liabilities 12,006,562 6,492,650 4,504,238 2,995,012 629,084 Deferred Inflows of Resources Deferred pension resources 98,576 47,375 11,444 53,464 55,069 Deferred lease resources 979,486 - - - - Deferred other post employment benefits 7,642 3,206 728 3,746 9,500 Total Deferred Inflows of Resources 1,085,704 50,581 12,172 57,210 64,569 Net Position Net investment in capital assets 7,291,053 6,010,262 7,786,758 3,105,921 1,900,193 Unrestricted 526,488 1,860,212 2,752,254 (398,650) 1,523,932 Total Net Position$ 7,817,541$ 7,870,474$ 10,539,012 $ 2,707,271$ 3,424,125 The notes to the financial statements are an integral part of this statement. 56 Governmental Activities - Internal TotalsService Funds $ 201,890$ 66,930 7,698 - 105,547 - 11,472 - 88,866 - 333,235 - 192,880 - 48,041 - 74,782 1,165,887 1,540,000 - 2,604,411 1,232,817 155,272 - 18,696 - 846,127 - 23,003,040 - 24,023,135 - 26,627,546 1,232,817 265,928 - 979,486 - 24,822 - 1,270,236 - 26,094,187 4,367,105 6,264,236 1,937,496 $ 32,358,423$ 6,304,601 The notes to the financial statements are an integral part of this statement. 57 City of Hopkins, Minnesota Statement of Revenues, Expenses and Changes in Net Position Proprietary Funds For the Year Ended December 31, 2023 Business-type Activities - Enterprise Funds 814818851858 Nonmajor Proprietary WaterSewerStorm SewerPavilionFunds Operating Revenues Charges for services$ 2,695,990 $ 3,323,407 $ 802,032 $ 510,075 $ 1,483,521 Operating Expenses Personal services 571,938 235,574 64,361 267,912 537,708 Contracted services - 1,751,678 - - 352,327 Supplies 165,510 44,849 55 21,379 100,854 Professional services 463,345 193,018 28,910 172,941 809,245 Communications 22,254 7,608 - - - Insurance 39,351 22,475 - 9,656 16,766 Utilities 171,912 16,323 - - - Repairs and maintenance 161,019 186,289 19,048 37,691 447 Depreciation 315,134 340,059 319,119 478,140 269,187 Total Operating Expenses 1,910,463 2,797,873 431,493 987,719 2,086,534 Operating Income (Loss) 785,527 525,534 370,539 (477,644) (603,013) Nonoperating Revenues (Expenses) Taxes - - - 340,000 - Investment earnings - - - 19 23,290 Miscellaneous 9,679 399 4 21 21 Intergovernmental grants - 86,476 - - 747,602 Gain on sale of capital assets - - - - 31,777 Interest expense (287,099) (152,957) (97,980) (73,876) - Total Nonoperating Revenues (Expenses) (277,420) (66,082) (97,976) 266,164 802,690 Income (Loss) Before Transfers 508,107 459,452 272,563 (211,480) 199,677 Transfers In - - - - - Transfers Out (159,426) (131,832) (155,504) - (25,000) Change in Net Position 348,681 327,620 117,059 (211,480) 174,677 Net Position, January 1 7,468,860 7,542,854 10,421,953 2,918,751 3,249,448 Net Position, December 31$ 7,817,541 $ 7,870,474 $ 10,539,012$ 2,707,271 $ 3,424,125 The notes to the financial statements are an integral part of this statement. 58 Governmental Activities - Internal TotalsService Funds $ 8,815,025 $ 714,679 1,677,493 27,123 2,104,005 - 332,647 - 1,667,459 - 29,862 - 88,248 - 188,235 - 404,494 439,623 1,721,639 799,460 8,214,082 1,266,206 600,943 (551,527) 340,000 250,000 23,309 28,366 10,124 52,906 834,078 3,600 31,777 85,778 (611,912) - 627,376 420,650 1,228,319 (130,877) - 200,000 (471,762) - 756,557 69,123 31,601,866 6,235,478 $ 32,358,423$ 6,304,601 The notes to the financial statements are an integral part of this statement. 59 City of Hopkins, Minnesota Statement of Cash Flows (Continued on the Following Page) Proprietary Funds For the Year Ended December 31, 2023 Business-type Activities - Enterprise Funds 814818851858 Nonmajor Proprietary WaterSewerStorm SewerPavilionFunds Cash Flows from Operating Activities Receipts from customers and users$ 2,646,499$ 3,342,436$ 801,350$ 464,052$ 1,591,013 Payments to suppliers (1,017,448) (2,384,657) (47,339) (230,934) (1,293,510) Payments to employees (659,012) (298,716) (84,328) (357,805) (650,924) Net Cash Provided (Used) by Operating Activities 970,039 659,063 669,683 (124,687) (353,421) Cash Flows from Noncapital Financing Activities Payments on interfund balances - - - - (200,000) Receipts on interfund balances - - - 88,866 - Property taxes received - - - 341,189 - Intergovernmental receipts - 86,476 - - 856,475 Transfers from other funds - - - - - Transfers to other funds (159,426) (131,832) (155,504) - (25,000) Net Cash Provided (Used) by Noncapital Financing Activities (159,426) (45,356) (155,504) 430,055 631,475 Cash Flows from Capital Financing Activities Acquisition of capital assets (839,167) (884,966) (419,995) (129,248) (143,962) Proceeds from sale of capital assets - - - - 31,777 Proceeds from bonds issued, net 1,361,769 1,226,494 768,562 - - Interest paid on bonds (347,213) (162,732) (104,457) (79,845) - Principal paid on bonds (485,450) (377,540) (312,010) (195,000) - Net Cash Provided (Used) by Capital Financing Activities (310,061) (198,744) (67,900) (404,093) (112,185) Cash Flows from Investing Activities Interest received on investments - - - 19 23,291 Net Increase (Decrease) in Cash and Cash Equivalents 500,552 414,963 446,279 (98,706) 189,160 Cash and Cash Equivalents, January 1 1,124,041 1,492,848 2,574,249 98,706 1,661,096 Cash and Cash Equivalents, December 31$ 1,624,593$ 1,907,811$ 3,020,528$ -$ 1,850,256 The notes to the financial statements are an integral part of this statement. 60 Governmental Activities - Internal TotalsService Funds $ 8,845,350$ 765,049 (4,973,888) (375,864) (2,050,785) 68,957 1,820,677 458,142 (200,000) - 88,866 - 341,189 250,000 942,9513 ,600 - 200,000 (471,762) - 701,244 453,600 (2,417,338) (1,035,840) 31,777 85,778 3,356,825 - (694,247) - (1,370,000) - (1,092,983) (950,062) 23,310 28,366 1,452,248 (9,954) 6,950,940 3,159,004 $ 8,403,188$ 3,149,050 The notes to the financial statements are an integral part of this statement. 61 City of Hopkins, Minnesota Statement of Cash Flows (Continued) Proprietary Funds For the Year Ended December 31, 2023 Business-type Activities - Enterprise Funds 814818851858 Nonmajor Proprietary WaterSewerStorm SewerPavilionFunds Reconciliation of Operating Income (Loss) to Net Cash Provided (Used) by Operating Activities Operating income (loss)$ 785,527$ 525,534$ 370,539$ (477,644)$ (603,013) Adjustments to reconcile operating income (loss) to net cash provided (used) by operating activities Depreciation 315,134 340,059 319,119 478,140 269,187 Other income related to operations 9,679 399 4 21 21 (Increase) decrease in assets Receivables Accounts 9,935 18,630 (686) (17,348) (48,712) Leases 16,534 - - - - Prepaids - (7,209) 1,300 57,110 1,211 Inventories 746 720 - - - Increase (decrease) in deferred outflows of resources Deferred pension resources (3,191) (364) 318 (221) 4,073 Deferred other post employment benefit resources 1,133 1,599 302 1,339 69 Increase (decrease) in liabilities Accounts payable 5,137 (155,928) (626) (46,699) (3,247) Accrued salaries payable 4,127 757 176 1,808 (25,195) Due to other governments 60 - - 322 (11,835) Unearned revenue (9,316) - - (28,696) 156,183 Other postemployment benefits (3,439) (4,176) (801) (3,592) (1,020) Compensated absences payable (7,155) (3,896) (1,069) (11,376) (1,772) Net pension liability (162,708) (95,960) (27,971) (120,984) (138,747) Increase (decrease) in deferred inflows of resources 77,156 35,987 8,415 39,717 40,638 Deferred pension resources (76,323) - - - - Deferred lease resources Deferred other post employment benefit resources 7,003 2,911 663 3,416 8,738 Net Cash Provided (Used) by Operating Activities$ 970,039$ 659,063$ 669,683$ (124,687)$ (353,421) Noncash Capital Financing and Investing Activities Amortization of premium (discount)$ 61,336$ 35,616$ 23,391$ 3,450$ - The notes to the financial statements are an integral part of this statement. 62 Governmental Activities - Internal TotalsService Funds $ 600,943$ (551,527) 1,721,639 799,460 10,124 52,906 (38,181) (2,536) 16,534 - 52,412 1,475 1,466 - 615 - 4,442 - (201,363) 24,275 (18,327) - (11,453) - 118,171 - (13,028) - (25,268) 134,089 (546,370) - 201,913 - (76,323) - 22,731 - $ 1,820,677$ 458,142 $ 123,793$ - The notes to the financial statements are an integral part of this statement. 63 THIS PAGE IS LEFT BLANK INTENTIONALLY 64 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 1: Summary of Significant Accounting Policies A.Reporting Entity The City of Hopkins, Minnesota (the City) is a charter City, which was approved December 2, 1947. The City operates pursuant to applicable Minnesota laws and statutes. The governing body of the City is a Council Manager form of government. The financial statements of the City have been prepared in conformity with U.S. generally accepted accounting principles as applied to governmental units by the Government Accounting Standards Board (GASB). and its component units, for which the City is considered to be financially accountable. A blended component unit, although legally separa -end. The fund statements shown represent a year-end nine months prior to the City's December 31 year-end. Housing and Redevelopment Authority in and for the City of Hopkins (HRA) The HRA was created by the City to carry out certain redevelopment projects and low-income rental housing. The HRA's governing body is the same as the governing body of the primary government in that all members of the Hopkins City Council are also the Hopkins Housing and Redevelopment Authority Commissioners. The City of Hopkins in its capacity as the HRA Board of Directors, has operational responsibility for the HRA. Therefore, there is a burden relationship between the primary government and the component unit. The housing activity is supported in part by federal subsidies. enterprise funds. Separate financials are not prepared. B.Government-wide and Fund Financial Statements The government-wide financial statements (i.e., the statement of net position and the statement of activities) report information on all of the activities of the City and its component unit. Governmental activities, which normally are supported by taxes and intergovernmental revenues, are reported separately from business-type activities, which rely to a significant extent on fees and charges for support. The statement of activities demonstrates the degree to which the direct expenses of a given function or segments are offset by program revenues. Direct expenses are those that are clearly identifiable with a specific function or segment. Amounts reported as program revenues include 1) charges to customers or applicants who purchase, use, or directly benefit from goods, services, or privileges provided by a given function or segment and 2) grants and contributions that are restricted to meeting the operational or capital requirements of a particular function or segment. Taxes and other items not properly included among program revenues are reported instead as general revenues. Separate financial statements are provided for governmental funds and proprietary funds. Major individual governmental funds and major individual enterprise funds are reported as separate columns in the fund financial statements. C.Measurement Focus, Basis of Accounting and Financial Statement Presentation The government-wide financial statements are reported using the economic resources measurement focus and the accrual basis of accounting, as are the proprietary funds financial statements. Revenues are recorded when earned and expenses are recorded when a liability is incurred, regardless of the timing of related cash flows. Property taxes are recognized as revenues in the year for which they are levied. Grants and similar items are recognized as revenue as soon as all eligibility requirements imposed by the provider have been met. 65 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 1: Summary of Significant Accounting Policies (Continued) Governmental fund financial statements are reported using the current financial resources measurement focus and the modified accrual basis of accounting. Revenues are recognized as soon as they are both measurable and available. Revenues are considered to be available when they are collectible within the current period or soon enough thereafter to pay liabilities of the current period. For this purpose, the City considers revenues to be available if they are collected within 60 days of the end of the current fiscal period. Expenditures generally are recorded when a liability is incurred, as under accrual accounting. However, debt service expenditures, as well as expenditures related to compensated absences and claims and judgments, are recorded only when payment is due. Property taxes, franchise taxes, licenses and interest associated with the current fiscal period are all considered to be susceptible to accrual and so have been recognized as revenues of the current fiscal period. Only the portion of special assessments receivable due within the current fiscal period is considered to be susceptible to accrual as revenue of the current period.All other revenue items are considered to be measurable and available only when cash is received by the City. Revenue resulting from exchange transactions, in which each party gives and receives essentially equal value, is recorded on the accrual basis when the exchange takes place. On a modified accrual basis, revenue is recorded in the year in which the resources are measurable and become available. Non-exchange transactions, in which the City receives value without directly giving equal value in return, include property taxes, grants, entitlement and donations. On an accrual basis, revenue from property taxes is recognized in the year for which the tax is levied. Revenue from grants, entitlements and donations is recognized in the year in which all eligibility requirements have been satisfied. Eligibility requirements include timing requirements, which specify the year when the resources are required to be used or the year when use is first permitted, matching requirements, in which the City must provide local resources to be used for a specified purpose, and expenditure requirements, in which the resources are provided to the City on a reimbursement basis. On a modified accrual basis, revenue from non-exchange transactions must also be available before it can be recognized. Unearned revenue arises when assets are recognized before revenue recognition criteria have been satisfied. Grants and entitlements received before eligibility requirements are met are also recorded as unearned revenue. The preparation of financial statements in conformity with accounting principles generally accepted in the United States of America requires management to make estimates and assumptions that affect certain reported amounts and disclosures.Accordingly, actual results could differ from those estimates. The City reports the following major governmental funds: The General fund required to be accounted for in another fund. The Economic Development Authority fund accounts for development opportunities of the city. Sources of funds are derived from grants received and an annual tax levy. The Tax Increment Super Valu fund accounts for the activities of the Super Valu tax increment development district. Sources of funds are a tax increment levy. The Permanent Improvement Revolving fund accounts for the accumulation of resources for future building improvement capital outlay. The Debt Service fund accounts for the servicing of general long-term debt not being financed by proprietary funds. 66 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 1: Summary of Significant Accounting Policies (Continued) The City reports the following major proprietary funds: The W ater fund accounts for the activities of the water distribution system the City maintains. The S ewer fund The Storm Sewer fund The Pavilion fund accounts for the operations and improvements of the city owned ice arena. The City reports the following internal service funds: The Equipment Replacement fund The Employee Benefits fund - employment benefits.. The Insurance Risk fund accounts all revenues and expenses associated with insurance premiums, deductibles, and claims for general liability and workers compensation. As a general rule, the effect of interfund activity has been eliminated from government-wide financial statements. Exceptions to this general rule are payments, where the amounts are reasonable equivalent in value to the interfund . Elimination of these charges would distort the direct costs and program revenues reported for the various functions concerned. Proprietary funds distinguish operating revenues and expenses from nonoperating items. Operating revenues and expenses generally result from providing services and producing and delivering goods in connection with proprietary funds principal ongoing operations. The principal operating revenues of the City enterprise funds are charges to customers for sales and services. Operating expenses for enterprise funds include the cost of sales and services, administrative expenses and depreciation on capital assets. All revenues and expenses not meeting this definition are reported as nonoperating revenues and expenses. 67 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 1: Summary of Significant Accounting Policies (Continued) D.Assets, Deferred Outflows of Resources, Liabilities, Deferred Inflows of Resources and Net Position/Fund Balances Deposits and Investments The Citys cash and cash equivalents are considered to be cash on hand, demand deposits, commercial paper, government securities and short-term investments with original maturities of three months or less from the date of acquisition. -wide cash and temporary investments pool is considered to be cash and cash equivalents for purposes of the statement of cash flows. Cash balances from all funds are pooled and invested, to the extent available, in certificates of deposit and other authorized investments. Earnings on investments are allocated to the individual funds based upon the average of month- end cash and investment balances. The City may also invest idle funds as authorized by Minnesota statutes, as follows: 1.Direct obligations or obligations guaranteed by the United States or its agencies. 2.Shares of investment companies registered under the Federal Investment Company Act of 1940 and received the highest credit rating, rated in one of the two highest rating categories by a statistical rating agency, and have a final maturity of thirteen months or less. 3.General 4. 5.Obligation of a school district with an original maturity not exceeding 13 months and (i) rated in the highest category by a national bond rating service or (ii) enrolled in the credit enhancement program pursuant to statute section 126C.55. 6.Bankers acceptances of United States banks eligible for purchase by the Federal Reserve System. 7.Commercial paper issued by United States banks corporations or their Canadian subsidiaries, of highest quality category by at least two nationally recognized rating agencies, and maturing in 270 days or less. 8.Repurchase or reverse repurchase agreements and securities lending agreements with financial institutions with capitalization exceeding $10,000,000, a primary reporting dealer in U.S. government securities to the Federal Reserve Bank of New York, or certain Minnesota securities broker-dealers. 9.Guaranteed Investment Contracts (GIC's) issued or guaranteed by a United States commercial bank, a domestic branch of a foreign bank, a United States insurance company, or its Canadian subsidiary, whose similar debt obligations were rated in one of the top two rating categories by a nationally recognized rating agency. The City categorizes its fair value measurements within the fair value hierarchy established by generally accepted accounting principles. The hierarchy is based on the valuation inputs used to measure the fair value of the asset. Level 1 inputs are quoted prices in active markets for identical assets; Level 2 inputs are significant other observable inputs; Level 65. 68 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 1: Summary of Significant Accounting Policies (Continued) Property Taxes The City Council annually adopts a tax levy and certifies it to the County in December for collection in the following year. The County is responsible for collecting all property taxes for the City. These taxes attach an enforceable lien on taxable property within the City on January 1 and are payable by the property owners in two installments. The taxes are collected by the County Treasurer and tax settlements are made to the City during January, June and December each year. Delinquent taxes receivable include the past six years uncollected taxes. Delinquent taxes have been offset by a deferred inflow of resources for delinquent taxes not received within 60 days after year end in the governmental financial statements. Accounts Receivable Accounts receivable include amounts billed for services provided before year end. Unbilled utility enterprise fund receivables are also included for services provided in 2023. The City annually certifies delinquent water, sewer and storm sewer accounts to the County for collection in the following year. As a result, there has been no allowance for doubtful accounts established in the enterprise funds. Special Assessments Special assessments represent the financing for public improvements paid for by benefiting property owners. These assessments are recorded as receivables upon certification to the County. Special assessments are recognized as revenue when they are received in cash or within 60 days after year end. All governmental special assessments receivable are offset by a deferred inflow of resources in the fund financial statements. Leases Receivable s receivable are measured at the present value of lease payments expected to be received during the lease term. Under the lease agreement, the City may receive variable lease payments that are dependent upon the nflow of resources in the period the payment is received. A deferred inflow of resources is recorded for the lease. The deferred inflow of resources is recorded at the initiation of the lease in an amount equal to the initial recording of the lease receivable. The deferred inflow of resources is amortized on a straight-line basis over the term of the lease. Interfund Receivables and Payables Activity between funds that are representative of lending/borrowing arrangements outstanding at the end of the fiscal year are referred to as either due to/from other funds (i.e., the current portion of interfund loans) or advances to/from other funds (i.e., the non-current portion of interfund loans). All other outstanding balances between funds are reported as due to/from other funds. Any residual balances outstanding between the governmental activities and business-type activities are reported in the government-wide financial statements as internal balances. Inventories and Prepaid Items All inventories are valued at cost using the first-in/first-out (FIFO) method. Inventories of governmental funds are recorded as expenditures when consumed rather than when purchased. Certain payments to vendors reflect costs applicable to future accounting periods and are recorded as prepaid items in both government-wide and fund financial statements. Prepaid expenditures of governmental funds are reported using the consumption method and recorded as expenditures at the time of consumption. 69 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 1: Summary of Significant Accounting Policies (Continued) Property Held for Resale The City acquires properties for redevelopment purposes. These properties are reported at their net realizable value in the the current period. Capital Assets Capital assets, which include land, buildings, equipment and infrastructure assets (e.g., roads, bridges, curbs and gutters, streets and sidewalks, drainage systems, lighting systems, and similar items), are reported in the applicable governmental or business-type activities columns in the government-wide financial statements and the proprietary fund financial statements. The City defines capital assets as assets with an initial, individual cost of more than $5,000 and an estimated useful life in excess of three years. Such assets are recorded at historical cost. Donated capital assets are recorded at acquisition value at the date of donation. The cost of normal maintenance and repairs that do not add to the value of the asset or materially extend assets lives are not capitalized. Assets not being depreciated include land and construction in progress. Buildings, equipment, and infrastructure of the City and the Housing Authority are depreciated using the straight-line method over the estimated useful lives as follows: Deferred Outflows of Resources In addition to assets, the statement of net position will sometimes report a separate section for deferred outflows of resources. This separate financial statement element, deferred outflows of resources, represents a consumption of net assets that applies to a future period(s) and so will not be recognized as an outflow of resources (expense/expenditure) until then. The City has two items that qualify for reporting in this category. Deferred pension resources and other postemployment benefit (OPEB) resources are reported only in the statements of net position. These items result from actuarial calculations and current year pension contributions and OPEB contributions made subsequent to the measurement date. 70 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 1: Summary of Significant Accounting Policies (Continued) Compensated Absences The City compensates all employees upon termination for unused vacation or flex leave. Employees hired prior to August 1, 1998 may opt to have sick leave, at the rate of 8 hours for each calendar month of full-time service, instead of flex leave. Employees hired prior to August 1, 1998, that have not opted for flex leave, shall be entitled to severance pay, after completion of five years of continuous City employment. Severance pay is calculated by multiplying the total number of continuous years in the City employ and/or accumulated sick leave by the daily wage rate prevailing at date of severance, at one day per year of such employment, to a maximum of 20 days. Such severance money shall be paid in case of separation caused by death, eligible retirements, or medically attested disability preventing an employee from performing the major duties of the position or separation for non-disciplinary reasons. Accumulated vacation, flex and vested severance pay is reported as an expense and an accrued liability as the benefits accrue to employees in the government-wide and proprietary fund financial statements. A liability for these amounts is reported in the governmental funds only if benefits have matured as a result of employee resignations and retirements. accrual basis. For the governmental activities, compensated absences liability is generally liquidated by the general and by the parking, communications, Depot Coffee House and arts center special revenue funds. Long-term Obligations In the government-wide financial statements, and proprietary funds types in the fund financial statements, long-term debt and other long-term obligations are reported as liabilities in the applicable governmental activities, business-type activities or proprietary funds type statement of net position. The recognition of bond premiums and discounts are amortized over the life of the bonds using the straight-line method. Bonds payable are reported net of the applicable bond premium or discount. Bond issuance costs are reported as an expense in the period incurred. In the fund financial statements, governmental fund types recognized bond premiums and discounts, as well as bond issuance costs, during the current period. The face amount of debt issued is reported as other financing sources. Premiums received on debt issuances are reported as other financing sources while discounts on debt issuances are reported as other financing uses. Issuance costs, whether or not withheld from the actual debt proceeds received, are reported as debt service expenditures. 71 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 1: Summary of Significant Accounting Policies (Continued) Pensions For purposes of measuring the net pension liability, deferred outflows/inflows of resources, and pension expense, information about the fiduciary net position of the Public Employees Retirement Association (PERA) and additions PERA except that PER For this purpose, plan contributions are recognized as of employer payroll paid dates and benefit payments and refunds are recognized when due and payable in accordance with the benefit terms. Investments are reported at fair value. The General, parking, communications, depot coffee house and arts center special revenue fund aretypically used to liquidate the governmental net pension liability. For purposes of measuring the net pension liability (asset), deferred outflows of resources and deferred inflows of resources related to pensions, and pension expense, information about the fiduciary net position of the defined benefit plan administered by Hopkins fiduciary net position have been determined on the same basis as they are reported by the plan. Investments are reported at fair value. The General fund is typically used to liquidate the governmental net pension liability. The total pension expense for the General Employee Plan (GERP), Police and Fire Plan (PEPFP), and the Hopkins Fire Relief Association is as follows: PostemploymentBenefits Other Than Pensions Under Minnesota statute §471.61, subdivision 2b, public employers must allow retirees and their dependents to continue coverage indefinitely in an employer-sponsored health care plan, under the following conditions: 1) Retirees must be receiving (or eligible to receive) an annuity from a Minnesota public pension plan, 2) Coverage must continue in group plan until age 65, and retirees must pay no more than the group premium, and 3) Retirees may obtain dependent coverage immediately before retirement. All premiums are funded on a pay-as-you-go basis. The liability was actuarially determined, in accordance with GASB Statement 75, at January 1, 2022. Deferred Inflows of Resources In addition to liabilities, the statement of net position and fund financial statements will sometimes report a separate section for deferred inflows of resources. This separate financial statement element, deferred inflows of resources, represents an acquisition of net assets that applies to a future period(s) and so will not be recognized as an inflow of resources (revenue) until that time. The City has only one type of item, which arises only under a modified accrual basis of accounting that qualifies as needing to be reported in this category. Accordingly, the item, unavailable revenue, is reported only in the governmental funds balance sheet. The governmental funds report unavailable revenues from three sources: property taxes, special assessments and intergovernmental. These amounts are deferred and recognized as an inflow of resources in the period that the amounts become available. The City also recognizes a deferred lease resource, which is reported under both the modified accrual and full accrual basis. 72 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 1: Summary of Significant Accounting Policies (Continued) Furthermore, the City has additional items which qualify for reporting in this category on the statement of net position. The items, deferred pension resources, deferred other postemployment benefit resources and deferred lease resources, are reported only in the statement of net position and results from actuarial calculations involving net differences between projected and actual earnings on plan investments, changes in proportions, and future lease receipts, respectively. Fund Balance In the fund financial statements, fund balance is divided into five classifications based primarily on the extent to which the City is bound to observe constraints imposed upon the use of resources reported in the governmental funds. These classifications are defined as follows: Nonspendable - Amounts that cannot be spent because they are not in spendable form, such as prepaid items. Restricted - Amounts related to externally imposed constraints established by creditors, grantors or contributors; or constraints imposed by state statutory provisions. Committed - Amounts constrained for specific purposes that are internally imposed by formal action (resolution) of the City Council -making authority. Committed amounts cannot be used for any other purpose unless the City Council modifies or rescinds the commitment by resolution. Assigned - Amounts constrained for specific purposes that are internally imposed. In governmental funds other than the General fund, assigned fund balance represents all remaining amounts that are not classified as nonspendable and are neither restricted nor committed. In the General fund, assigned amounts represent intended uses established by the City Council itself or by an official to which the governing body delegates the authority. The City Council has adopted a fund balance policy which delegates the authority to assign amounts for specific purposes to the Finance Director. Unassigned -The residual classification for the General fund and also negative residual amounts in other funds. When an expenditure is incurred for purposes for which committed, assigned, and unassigned amounts are available, it use committed first, then assigned, and finally unassigned amounts. The City formally adopted a fund balance policy for the General Fund. The policy establishes an unassigned fund of a operating expenditures. Net Position Net position represents the difference between assets and deferred outflows of resources and liabilities and deferred inflows of resources. Net position is displayed in three components: a.Net investment in capital assets - Consists of capital assets, net of accumulated depreciation reduced by any outstanding debt attributable to acquire capital assets. b.Restricted net position - Consists of net position balances restricted when there are limitations imposed on their use through external restrictions imposed by creditors, grantors, laws or regulations of other governments. c.Unrestricted net position - All other net position balances that do not meet the definition of restricted or investment in capital assets. first, then unrestricted resources as they are needed. 73 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 2: Stewardship, Compliance and Accountability A.Budgetary Information Annual budgets are adopted on a basis consistent with U.S. generally accepted accounting principles for all th governmental funds except the TIF Spending Plan, Hennepin County CDBG, 5 Avenue Flats, and American Rescue Plan Act special revenue funds, the debt service funds and the capital projects funds, which are not budgeted. A capital improvement plan is reviewed annually by the City Council for the capital projects funds and utility funds. However, appropriations for major projects are not adopted until the actual bid award of the improvement. The appropriations are not reflected in the financial statements. All annual appropriations lapse at fiscal year-end. The City follows these procedures in establishing the budgetary data reflected in the financial statements and set forth in Section 7.04 of the City Charter. 1.The City Manager shall, at the first regular council meeting in September, submit to the Council a proposed budget and an explanatory budget message in a form and manner as prescribed by the City Charter. 2.The Council shall determine the plan and time of the public hearings on the budget to obtain taxpayer comments. 3.The Council shall adopt the tax levy by resolution no later than a December date, which is annually established by law for the county auditor to levy taxes. The budget shall set forth the total for each budgeted fund with such segregation as to objects and purposes of expenditures as the Council deems necessary for purposes of budget control. 4.The City Manager is authorized to transfer budgeted amounts between departments within any fund; however, any revisions that alter the total expenditures of any fund must be approved by the City Council and are limited to the amount revenues exceed the budgets or authorize the transfer of sums from unexpended balances to other purposes. Budgeted expenditure appropriations lapse at year-end. The level of legal control is at the fund level. 5.The Council made no supplemental budgetary appropriation throughout the year. B.Excess of Expenditures Over Appropriations For the year ended December 31, 2023 expenditures exceeded appropriations in the following funds: Excess of Expenditures Over Fund BudgetActualAppropriations Major General$ 17,168,440$ 17,831,191$ 662,751 Economic Development Authority 459,236 586,176 126,940 Nonmajor State Chemical Assessment 65,000 110,721 45,721 Parking 158,610 174,668 16,058 Communications 253,596 292,434 38,838 The excess expenditures were funded by revenues in excess of expectations and available fund balance. 74 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 2: Stewardship, Compliance and Accountability (Continued) C.Fund Balance Deficits At December 31, 2023, the following funds had deficit fund balances or net position. These deficits will be funded through future tax levies, contributions, grants, charges for services or developer payments: Note 3: Detailed Notes on All Funds A.Deposits and Investments Deposits Custodial credit risk for deposits and investments is the risk that in the event of a bank failure, the Citys deposits and investments may not be returned or the City will not be able to recover collateral securities in the possession of an outside party. In accordance with Minnesota statutes and as authorized by the City Council, the City maintains deposits at those depository banks, all of which are members of the Federal Reserve System. Minnesota statutes require that all City deposits be protected by insurance, surety bond or collateral. The fair value of collateral pledged must equal 110 percent of the deposits not covered by insurance or bonds, with the exception of irrevocable standby letters of credit issued by Federal Home Loan Banks as this type of collateral only requires collateral pledged equalto 100 percent of the deposits not covered by insurance or bonds. 75 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 3: Detailed Notes on All Funds (Continued) Authorized collateral in lieu of a corporate surety bond includes: United States government Treasury bills, Treasury notes, Treasury bonds; Issues of United States government agencies and instrumentalities as quoted by a recognized industry quotation service available to the government entity; General obligation securities of any state or local government with taxing powers which is rated A or better by a national bond rating service, or revenue obligation securities of any state or local government with taxing powers which is rated AA or better by a national bond rating service; General obligation securities of a local government with taxing powers may be pledged as collateral against funds deposited by that same local government entity; Irrevocable standby letters of credit issued by Federal Home Loan Banks to a municipality accompanied by written evidence that the banks public debt is rated AA or better by Moodys Investors Service, Inc., or Standard & Poors Corporation; and Time deposits that are fully insured by any Federal agency. Minnesota statutes require that all collateral shall be placed in safekeeping in a restricted account at a Federal Reserve Bank, or in an account at a trust department of a commercial bank or other financial institution that is not owned or controlled by the financial institution furnishing the collateral. The selection should be approved by the City. At year end, the Citys carrying amount of deposits was $8,88,942 and the bank balance was $8,890,539. The bank balance was covered by federal depository insurance totaling $500,000. The remaining balance was covered by collateral Investments In accordance with this standard, the City has categorized its investments, based on the priority of the inputs to the valuation technique, into a three-level fair value hierarchy. The fair value hierarchy gives the highest priority to quoted prices in active markets for identical assets or liabilities (Level 1) and the lowest priority to unobservable inputs (Level 3). If the inputs used to measure the financial instruments fall within different levels of the hierarchy, the categorization is based on the lowest level input that is significant to the fair value measurement of the instrument. Financial assets and liabilities recorded on the combined statements of financial position are categorized based on the inputs to the valuation techniques as follows: Level 1 - Financial assets and liabilities are valued using inputs that are unadjusted quoted prices in active markets accessible at the measurement date of identical financial assets and liabilities. Level 2 - Financial assets and liabilities are values based on quoted prices for similar assets, or inputs that are observable, either directly or indirectly for substantially the full term through corroboration with observable market data. Level 3 - Financial assets and liabilities are valued using pricing inputs which are unobservable for the asset, inputs that reflect the reporting entity's own assumptions about the assumptions market participants and would use in pricing the assets. 76 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 3: Detailed Notes on All Funds (Continued) As of December 31, 2023, the City had the following investments that are insured or registered, or securities held by the name. (1) (2)Interest rate risk is disclosed using the segmented time distribution method. N/A Indicates not applicable or available. The investments of the City are subject to the following risks: Credit Risk. Is the risk of loss due to failure of the securities issuer or backer. Thus, designated depositories shall have insurance through the FDIC (Federal Insurance) or the SIPC (Securities Investor Protection Corporation). To ensure safety, it is the policy of the City that when considering an investment, all depositories under consideration be cross-checked against existing investments to make certain that funds in excess of insurance limits are not in the same institution unless collateralized. . Minnesota statutes limit the Citys investments to the list on page 57 of the notes. Custodial Credit Risk. The City will minimize deposit custodial risk, which is risk of loss due to failure of the depository bank (credit union), by obtaining collateral or bonds for all uninsured amounts on deposit, and by obtaining necessary documentation to show compliance with state law and a perfected security interest under federal law. Concentration of Credit Risk. Is the risk of loss attributed to the magnitude of a governments investment in a single issuer. Interest Rate Risk. Is the risk that the market value of securities in the portfolio will fall due to changes in general interest rates. The City will minimize interest rate risk by structuring the investment portfolio so that securities mature to meet cash requirements for ongoing operations, thereby avoiding the need to sell securities on the open market prior to maturity. 77 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 3: Detailed Notes on All Funds (Continued) It is the policy of the City to invest public funds in a manner which will provide the highest investment return with the maximum security while meeting the daily cash flow requirements of the City and conforming to all state and local statutes governing the investment of public funds. The purpose of this Policy statement is to establish standards governing the investment of City funds. In accordance with Minnesota Statutes 385.05 and 118A.02 the Finance Director is authorized to invest the City funds in accordance with Minnesota Statutes 118A.04and118A.05which defines the types of securities and financial instruments the City is allowed to purchase. A reconciliation of cash and temporary investments as shown on the statement of net position for the City follows: B.Lease Receivable As of December 31, 2023, the City had the following lease receivables maturing over the period shown below: Current Year IssueDiscountInfow ofBalance at Description DateRateResourcesYear End New Cingular Wireless Antenna05/15/192.26%$ 76,323$ 1,039,275 Stages Theatre Company09/01/233.13% 68,949 973,298 $ 2,012,573 Lease Maturity Year Ending December 31,PrincipalInterestTotal 2024$ 235,928$ 50,793$ 286,721 2025 252,463 43,635 296,098 2026 269,732 35,986 305,718 2027 287,869 27,823 315,692 2028 227,216 19,425 246,641 2029 - 2033 427,639 61,139 488,778 2034 - 2038 311,726 10,556 322,282 Total$ 2,012,573$ 249,357$ 2,261,930 78 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 3: Detailed Notes on All Funds (Continued) C.Capital Assets Capital asset activity for the year ended December 31, 2023 was as follows: 79 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 3: Detailed Notes on All Funds (Continued) 80 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 3: Detailed Notes on All Funds (Continued) Depreciation expense was charged to functions/programs of the City as follows: D.Interfund Receivables, Payables and Transfers The composition of interfund balances as of December 31, 2023 is as follows: Receivable FundPayable Fund PurposeAmount GeneralNonmajor Governmental FundsTo eliminate cash deficit$ 467,567 Economic Development Nonmajor Governmental FundsTo eliminate cash deficit 654,222 Subtotal Interfund Balances 1,121,789 Interfund Activity Eliminated From Government-Wide Statements (1,032,923) Total Internal Balances - Government-Wide Statements$ 88,866 The interfund receivables and payables are to eliminate negative cash balances between funds, to allow for development loans or to facilitate a project in another fund. 81 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 3: Detailed Notes on All Funds (Continued) The composition of interfund transfers for the year ended December 31, 2023 is as follows: During the year ended December 31, 2023, the City made the following one-time transfers: Annual transfer from the General Fund to the non-major governmental Depot Coffee House fund to pay for operating costs of the facility. Annual transfer from the Economic Development fund to the Art Center fund totaling $30,000 to pay for operating costs of the facility. Annual transfers from Tax Increment Super Valu fund to Debt Service funds for debt payments. Transfers from Water, Sewer and Storm Sewer funds to Debt Service funds for bond payment contributions. Annual transfer, from the non-major governmental Communication fund to the Art Center fund totaling $50,000 for operating costs of the facility. Annual transfer from the Capital Improvement Revolving fund to the Debt Service fund for annual debt service payments. Annual transfer from non-major enterprise Refuse fund to the Debt Service fund for debt payments. Transfers of unobligated TIF revenue between Tax Increment Supervalu fund and nonmajor TIF funds to fund construction projects Transfers of bond proceeds from debt service funds to the Permanent Improvement Revolving fund and internal service funds. Year end transfer from the 2005B G.O. TIF Refunding Bonds fund to the Economic Development Authority fund to close out the 2005B G.O. TIF Refunding Bonds fund. Year end transfer from the 2009B G.O. Housing Improvement Bonds fund to the Economic Development Authority fund to close out the 2009B G.O. Housing Improvement Bonds fund. Year end transfer from the 2010B G.O. Refunding Bonds fund to the Tax Increment Super Valu fund to close out the 2010B G.O. Refunding Bonds fund. 82 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 3: Detailed Notes on All Funds (Continued) Year end transfer from the General fund to the 2012 G.O. Improvement Bonds fund to close out the 2012 G.O. Improvement Bonds fund. Year end transfer from the General fund to the 2014B G.O. Refunding Bonds fund to close out the 2014B G.O. Refunding Bonds fund. E.Long-term Debt General Obligation Bonds The City issues general obligation bonds to provide funds street reconstruction, utility improvements and major capital facilities. General obligation bonds have been issued for general government activities. In addition, general obligation bonds have been issued to refund bond issues. General obligation bonds are direct obligations and pledge the full faith and credit of the City. General obligation bonds currently outstanding are as follows: Interest AuthorizedIssueMaturityBalance at DescriptionRate and IssuedDateDateYear End GO SROP Bonds Series 2015A$ 4,100,0002.00 - 3.005/25/20152/1/2031 %$ 2,350,000 GO Tax Abatement Bonds Series 2015B2,940,0002.00 - 3.205/25/20152/1/2036 2,065,000 GO Improvement Series 2016A 4,335,0002.00 - 2.507/20/20162/1/2032 2,760,000 GO Tax Abatement Bonds Series 2016B 1,630,0002.00 - 2.207/20/20162/1/2032 1,030,000 GO Bonds Series 2016C1,875,0002.0011/10/20162/1/2026 665,000 GO Bonds Series 2017A11,795,0003.00 - 4.006/20/20172/1/2033 8,525,000 GO Tax Abatement Bonds Series 2017B 1,735,0003.00 - 4.006/20/20172/1/2033 1,270,000 GO Bonds Series 2018A 6,715,0003.00 - 4.005/1/20182/1/2034 5,105,000 GO Bonds Series 2019A11,550,0003.00 - 5.004/2/20192/1/2034 9,760,000 GO Bonds Series 2020A2,560,0002.00 - 5.006/9/20202/1/2036 2,410,000 Equipment Certificate Bonds Series 2020A225,0002.00 - 5.006/9/20202/1/2036 200,000 GO Bond Bonds Series 2021A 3,720,0006/9/20212/1/2036 2.10 - 3.00 3,720,000 GO Bonds Series 2022A 2,085,0002.00 - 3.004/26/20222/1/2038 2,085,000 Equipment Certificate Bonds 2022A900,0000.35 - 4.04/26/20222/1/2033 900,000 GO Bonds Series 2023A 3,775,0003.503/14/20232/1/2026 3,775,000 Equipment Certificate Bonds 2023A210,0003.503/14/20232/1/2026 210,000 Total G.O. Bonds$ 46,830,000 83 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 3: Detailed Notes on All Funds (Continued) Annual debt service requirements to maturity for general obligation bonds outstanding at December 31, 2023 are as follows: General Obligation Improvement Bonds The following bonds were used to for street reconstruction and major capital improvements to buildings. They will be repaid with ad valorem taxes, special assessments levied against the properties and tax increments. The bonds are backed by the full faith and credit of the City. Interest AuthorizedIssueMaturityBalance at DescriptionRate and IssuedDateDateYear End G.O. Improvement 2.00 - 3.137/10/20142/1/2030 Bonds, Series 2014A$ 1,895,000%$ 960,000 G.O. Improvement and Refunding 1,220,0005.0011/26/20192/1/2026 Bonds, Series 2019B 480,000 G.O. Improvement and Refunding 2,495,0002.00 - 3.0012/30/20202/1/2027 Bonds, Series 2020B 1,815,000 Total G.O. Improvement Bonds$ 3,255,000 Annual debt service requirements to maturity for general obligation improvement bonds outstanding at December 31, 2023 are as follows: Governmental Activities Year Ending December 31,PrincipalInterestTotal 2024$ 590,000$ 92,369 $ 682,369 2025 620,000 71,069 691,069 2026 640,000 48,869 688,869 2027 480,000 30,419 510,419 2028 - 2030 925,000 28,115 953,115 Total$ 3,255,000$ 270,841$ 3,525,841 84 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 3: Detailed Notes on All Funds (Continued) General Obligation Revenue Bonds The following bonds were used to finance improvements to water, sewer and storm sewer infrastructure; and improvements to the ice arena. Bonds are funded through revenue in the water, sewer, storm sewer funds; and a general tax levy in the pavilion fund. The bonds are backed by the full faith and credit of the City. Annual debt service requirements to maturity for revenue bonds are as follows: Business-type Activities Year Ending December 31,PrincipalInterestTotal 2024$ 1,540,000$ 718,988$ 2,258,988 2025 1,805,000 603,881 2,408,881 2026 4,655,000 491,581 5,146,581 2027 1,580,000 385,994 1,965,994 2028 1,630,000 334,694 1,964,694 2029 - 2033 7,655,000 995,957 8,650,957 2034 - 2038 4,520,000 202,434 4,722,434 Total$ 23,385,000$ 3,733,529$ 27,118,529 85 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 3: Detailed Notes on All Funds (Continued) General Obligation Tax Increment Bonds The following bonds will be repaid from revenues generated from tax increment financing districts. Annual debt service requirements to maturity for tax increment bonds are as follows: 86 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 3: Detailed Notes on All Funds (Continued) Changes in Long-term Liabilities During the year ended December 31, 2023, the following changes occurred in long-term liabilities. 87 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 3: Detailed Notes on All Funds (Continued) F.Components of Fund Balance At December 31, 2023 form (Nonspendable), legal restrictions (Restricted), or City Council action (Committed). The following is a summary of the components of fund balance: Permanent Economic ImprovementDebtNonmajor General DevelopmentRevolvingServiceGovernmentalTotal Nonspendable Inventory $ 107,085 $ - $ - $ - $ - $ 107,085 Prepaid items 209,085 5,931 - - 1,891 216,907 Total Nonspendable $ 316,170 $ 5,931 $ - $ - $ 1,891 $ 323,992 Restricted for Police seizure funds $ 13,166 $ - $ - $ - $ - $ 13,166 Debt service - - - 7,800,338 - 7,800,338 TIF spending plan - - - - 2,654,400 2,654,400 Hennepin county CDBG - - - - 7,934 7,934 Hopkins race and equity initiative - - - - 46,073 46,073 Tax increment district entertainment district - - - - 37,542 37,542 Public safety - - - - 777,460 777,460 Park improvements - - - - 526,100 526,100 Total Restricted $ 13,166 $ - $ - $ 7,800,338 $ 4,049,509 $ 11,863,013 Committed to Economic development $ - $ 5,200,059 $ - $ - $ - $ 5,200,059 Communications - - - - 73,021 73,021 Total Committed $ - $ 5,200,059 $ - $ - $ 73,021 $ 5,273,080 Assigned to Park improvements $ - $ - $ - $ - $ 518,706 $ 518,706 Streets - - - - 1,076,709 1,076,709 Capital improvements - - - - 101,749 101,749 Permanent Improvement Revolving - - 169,889 - - 169,889 Economic development 245,494 - - - - 245,494 Total Assigned $ 245,494 $ - $ 169,889 $ - $ 1,697,164 $ 2,112,547 88 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 4:Defined Benefit Pension Plans - Statewide A. Plan Description The City participates in the following cost-sharing multiple-employer defined benefit pension plans administered by the are tax qualified plans under Section 401(a) of the Internal Revenue Code. General Employees Retirement Plan All full-time and certain part-time employees of the City are covered by the General Employees Plan. General Employees Plan members belong to the Coordinated Plan. Coordinated Plan members are covered by Social Security. Public Employees Police and Fire Plan The Police and Fire Plan, originally established for police officers and firefighters not covered by a local relief association, now covers all police officers and firefighters hired since 1980. Effective July 1, 1999, the Police and Fire Plan also covers police officers and firefighters belonging to a local relief association that elected to merge with and transfer assets and administration to PERA. B. Benefits Provided PERA provides retirement, disability and death benefits. Benefit provisions are established by state statute and can only be modified by the state Legislature. Vested, terminated employees who are entitled to benefits but are not receiving them yet are bound by the provisions in effect at the time they last terminated their public service. General Employee Plan Benefits allowable service, age, and years of credit at termination of service. Two methods are used to compute benefits for PERA's Coordinated Plan members. Members hired prior to July 1, 1989, receive the higher of Method 1 or Method 2 formulas. Only Method 2 is used for members hired after June 30, 1989. Under Method 1, the accrual rate for Coordinated members is 1.2 percent of average salary for each of the first 10 years of service and 1.7 percent of average salary for each additional year. Under Method 2, the accrual rate for Coordinated members is 1.7 percent for average salary for all years of service. For members hired prior to July 1, 1989 a full annuity is available when age plus years of service equal 90 and normal retirement age is 65. For members hired on or after July 1, 1989 normal retirement age is the age for unreduced Social Security benefits capped at 66. Benefit increases are provided to benefit recipients each January. The postretirement increase is equal to 50 percent of the cost-of-living adjustment (COLA) announced by the SSA, with a minimum increase of at least 1 percent and a maximum of 1.5 percent. Recipients that have been receiving the annuity or benefit for at least a full year as of the June 30 before the effective date of the increase will receive the full increase. Recipients receiving the annuity or benefit for at least one month but less than a full year as of the June 30 before the effective date of the increase will receive a reduced prorated increase. In 2023, legislation repealed the statute delaying increases for members retiring before full retirement age. 89 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 4:Defined Benefit Pension Plans - Statewide (Continued) Police and Fire Plan Benefits Benefits for Police and Fire Plan members first hired after June 30, 2010, but before July 1, 2014, vest on a prorated basis from 50 percent after five years up to 100 percent after ten years of credited service. Benefits for Police and Fire Plan members first hired after June 30, 2014 vest on a prorated basis from 50 percent after ten years up to 100 percent after twenty years of credited service. The annuity accrual rate is 3 percent of average salary for each year of service. For Police and Fire Plan members who were first hired prior to July 1, 1989, a full annuity is available when age plus years of service equal at least 90. Benefit increases are provided to benefit recipients each January. The postretirement increase is fixed at 1 percent. Recipients that have been receiving the annuity or benefit for at least 36 months as of the June 30 before the effective date of the increase will receive the full increase. Recipients receiving the annuity or benefit for at least 25 months but less than 36 months as of the June 30 before the effective date of the increase will receive a reduced prorated increase. C. Contributions Minnesota statutes, chapter 353 sets the rates for employer and employee contributions. Contribution rates can only be modified by the state Legislature. General Employees Fund Contributions Coordinated Plan members were required to contribute 6.50 percent of their annual covered salary in fiscal year 2023 General Employees Fund for the years ending December 31, 2023, 2022 and 2021 were $485,793, $453,608 and statute. Police and Fire Fund Contributions Police and Fire Plan members were required to contribute 11.80 percent of their annual covered salary in fiscal year 2023 Police and Fire Fund for the years ending December 31, 2023, 2022 and 2021 were $679,655, $639,711 and $618,899, 90 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 4:Defined Benefit Pension Plans - Statewide (Continued) D. Pension Costs General Employees Fund Pension Costs At December 31, 2023, the City reported a liability of $4,423,183 for its proportionate share of the General Employees pension liability associated with the City totaled $121,961. The net pension liability was measured as of June 30, 2023, and the total pension liability used to calculate the net pension liability was determined by an actuarial valuation as of PERA during the measurement period for employer payroll paid dates from July 1, 2022 through June 30, 2023 relative to 0.0791 percent at the end of the measurement period and 0.0788 percent for the beginning of the period. City Proportionate Share of the Net Pension Liability$ 4,423,183 State of Minnesota's Proportionate Share of the Net Pension Liability Associated with the City 121,961 $ 4,545,144 Total For the year ended December 31, 2023, the City recognized pension expense of $643,921 for its proportionate share of Fund. resources and deferred inflows of resources related to pensions from the following sources: DeferredDeferred OutflowsInflows of Resourcesof Resources Differences Between Expected and Actual Economic Experience$ 145,126 $ 30,008 Changes in Actuarial Assumptions 705,513 1,212,357 Net Difference Between Projected and Actual Investment Earnings - 147,793 Changes in Proportion 21,489 - Contributions Paid to PERA Subsequent to the Measurement Date 244,128 - Total$ 1,116,256 $ 1,390,158 91 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 4:Defined Benefit Pension Plans - Statewide (Continued) subsequent to the measurement date will be recognized as a reduction of the net pension liability in the year ended December 31, 2024. Other amounts reported as deferred outflows and inflows of resources related to pensions will be recognized in pension expense as follows: 2024 $ 123,951 2025 (647,150) 2026 101,123 2027 (95,954) Police and Fire Fund Pension Costs net pension liability. The net pension liability was measured as of June 30, 2023, and the total pension liability used to employer payroll paid dates from July 1, 2022 through June 30, 2023, relative to the total employer contributions measurement period and 0.2911 percent for the beginning of the period. The State of Minnesota contributed $18 million to the Police and Fire Fund in the plan fiscal year ended June 30, 2023. The contribution consisted of $9 million in direct state aid that does meet the definition of a special funding situation and $9 million in supplemental state aid that does not meet the definition of a special funding situation. The $9 million direct state was paid on October 1, 2022. Thereafter, by October 1 of each year, the state will pay $9 million to the Police and Fire Fund until full funding is reached or July 1, 2048, whichever is earlier. The $9 million in supplemental state aid will continue until the fund is 90 percent funded, or until the State Patrol Plan (administered by the Minnesota State Retirement System) is 90 percent funded, whichever occurs later. The State of Minnesota's proportionate share of the net pension liability associated with the City totaled $194,647. City Proportionate Share of the Net Pension Liability$ 4,831,782 State of Minnesota's Proportionate Share of the Net Pension Liability Associated with the 194,647 $ 5,026,429 Total The State of Minnesota is included as a non-employer contributing entity in the Police and Fire Retirement Plan Schedule of Employer Allocations and Schedule of Pension Amounts by Employer, Current Reporting Period Only (pension allocation schedules) for the $9 million in direct state aid. Police and Fire Plan employers need to recognize their situation accounting and financial reporting requirements. For the year ended December 31, 2023, the City recognized City recognized an additional negative $11,723 as pension expense (grant revenue) for its proportionate share of the 92 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 4:Defined Benefit Pension Plans - Statewide (Continued) The State of Minnesota is not included as a non-employer contributing entity in the Police and Fire Pension Plan pension allocation schedules for the $9 million in supplemental state aid. The City recognized $25,182 for the year ended December 31, 2023 as revenue and an offsetting reduction of net pension liability for its proportionate share of the State resources and deferred inflows of resources from the following sources: DeferredDeferred OutflowsInflows of Resourcesof Resources Differences Between Expected and Actual Economic Experience$ 1,359,568 $ - Changes in Actuarial Assumptions 5,867,365 6,796,117 Net Difference Between Projected and Actual Investment Earnings - 254,908 Changes in Proportion 50,920 421,044 Contributions Paid to PERA Subsequent to the Measurement Date 348,739 - Total$ 7,626,592 $ 7,472,069 subsequent to the measurement date will be recognized as a reduction of the net pension liability in the year ended December 31, 2024. Other amounts reported as deferred outflows and inflows of resources related to pensions will be recognized in pension expense as follows: 2024 $ 193,964 2025 (24,771) 2026 1,199,222 2027 (363,836) 2028 (1,198,795) E. Long-term Expected Return on Investment The State Board of Investment, which manages the investments of PERA, prepares an analysis of the reasonableness on a regular basis of the long-term expected rate of return using a building-block method in which best-estimate ranges of expected future rates of return are developed for each major asset class. These ranges are combined to produce an expected long-term rate of return by weighting the expected future rates of return by the target asset allocation percentages. The target allocation and best estimates of geometric real rates of return for each major asset class are summarized in the following table: 93 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 4:Defined Benefit Pension Plans - Statewide (Continued) Long-term TargetExpected Real Asset ClassAllocationRate of Return Domestic Equity 33.5 % 5.10 % International Equity 16.5 5.30 Fixed Income 25.0 0.75 Private Markets 25.0 5.90 Total 100.0 % F. Actuarial Assumptions The total pension liability in the June 30, 2023, actuarial valuation was determined using an individual entry-age normal actuarial cost method. The long-term rate of return on pension plan investments used in the determination of the total liability is 7.0 percent. This assumption is based on a review of inflation and investments return assumptions from a number of national investment consulting firms. The review provided a range of return investment return rates deemed to be reasonable by the actuary. An investment return of 7.0 percent was deemed to be within that range of reasonableness for financial reporting purposes. Inflation is assumed to be 2.25 percent for the General Employees Plan and 2.25 percent for the Police and Fire Plan. Benefit increases after retirement are assumed to be 1.25 percent for the General Employees Plan and 1.00 percent for the the Police and Fire Plan. Salary growth assumptions in the General Employees Plan range in annual increments from 10.25 percent after one year of service to 3.0 percent after 27 years of service. In the Police and Fire Plan, salary growth assumptions range from 11.75 percent after one year of service to 3.0 percent after 24 years of service. Mortality rates for the General Employees Plan are based on the Pub-2010 General Employee Mortality Table. Mortality rates for the Police and Fire Plan is based on the Pub-2010 Public Safety Employee Mortality tables. The tables are Actuarial assumptions for the General Employees Plan are reviewed every four years. The most recent four-year experience study for the General Employees Plan was completed in 2022. The assumption changes were adopted by the Board and became effective with the July 1, 2023 actuarial valuation. The most recent four-year experience study for the Police and Fire Plan was adopted by the Board and became effective with the July 1, 2021 actuarial valuation. 94 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 4:Defined Benefit Pension Plans - Statewide (Continued) The following changes in actuarial assumptions and plan provisions occurred in 2023: General Employees Fund Changes in Actuarial Assumptions - The investment return assumption and single discount rate were changed from 6.5 percent to 7.0 percent. Changes in Plan Provisions - An additional one-time direct state aid contribution of $170.1 million will be contributed to the Plan on October 1, 2023. - The vesting period of those hired after June 30, 2010, was changed from five years of allowable service to three years of allowable service. - The benefit increase delay for early retirements on or after January 1, 2024, was eliminated. - A one-time, non-compounding benefit increase of 2.5 percent minus the actual 2024 adjustment will be payable in a lump sum for calendar year 2024 by March 31, 2024. Police and Fire Fund Changes in Actuarial Assumptions - The investment return assumption was changed from 6.5 percent to 7.0 percent. - The single discount rate changed from 5.4 percent to 7.0 percent. Changes in Plan Provisions - An additional one-time direct state aid contribution of $19.4 million will be contributed to the Plan on October 1, 2023. - The vesting requirement for new hires after June 30, 2014 was changed from a graded 20-year vesting schedule to a graded 10-year vesting schedule, with 50 percent vesting after five years increasing incrementally to 100 percent after 10 years. - A one-time, non-compounding benefit increase of 3.0 percent will be payable in a lump sum for calendar year 2024 by March 31, 2024. - Psychological treatment is required effective July 1, 2023 prior to approval for a duty disability benefit for a - The total and permanent duty disability benefit was increased, effective July 1, 2023. 95 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 4:Defined Benefit Pension Plans - Statewide (Continued) G. Discount Rate The discount rate used to measure the total pension liability in 2023 was 7.0 percent. The projection of cash flows used to determine the discount rate assumed that contributions from plan members and employers will be made at rates set in Minnesota statutes. Based on these assumptions, the fiduciary net position of the General Employees and Police and Fire Funds were projected to be available to make all projected future benefit payments of current plan members. Therefore, the long-term expected rate of return on pension plan investments was applied to all periods of projected benefit payments to determine the total pension liability. H. Pension Liability Sensitivity pension liability would be if it were calculated using a discount rate one percentage point lower or one percentage point higher than the current discount rate: 1 Percent1 Percent Decrease (6.0%)Current (7.0%)Increase (8.0%) General Employees Fund$ 7,824,967$ 4,423,183$ 1,625,087 Police and Fire Fund 9,586,832 4,831,782 922,495 I. Pension Plan Fiduciary Net Position report that includes financial statements and required supplementary information. That report may be obtained on the Internet at www.mnpera.org. 96 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 5: Defined Benefit Pension Plans - Fire Relief Association A. Plan Description Firefighters of the City of Hopkins are members of the Hopkins Fire Department Relief Association. The Association is the administrator of the single-employer defined benefit pension plan available to firefighters. The plan was established in 1909 and is administered pursuant to Minnesota S-laws. It is governed by a Board of Trustees made up of six members elected by the members of the Association for three year terms, and the Mayor, Finance Director and Fire Chief, who serve as ex-officio voting members of the Board of Trustees. As of December 31, 2023, membership includes 34 active participants and 14 vested terminated employees entitled to benefit but not yet receiving them. The Association issues a publicly available financial report that includes financial statements and required supplementary information of the Hopkins Fire Relief Association. That report may be obtained by writing to the Hopkins Fire Relief Association, 1010 First St S, Hopkins, MN 55343. because the Association is not a component unit of the City. The Association does not have any component units. B. Benefits Provided A fire fighter who completes at least 20 years as an active member of the Department is entitled, after age 50, to a full service pension upon retirement. The bylaws of the Association also provide for an early vested service pension for a retiring member who has completed fewer than 20 years of service. The reduced pension, available to members with 10 years of service, shall be equal to 60 percent of the pension as prescribed by the bylaws. This percentage increases 4 percent per year so that at 20 years of service, the full amount prescribed is paid. Members who retire with less than 20 years of service and have reached the age of 50 years and have completed at least 10 years of active membership are entitled to a reduced service pension not to exceed the amount calculated by multiplying the member's service pension for the completed years of service times the applicable non-forfeitable percentage of pension. C. Contributions Minnesota statutes, chapters 424 and 424A authorize pension benefits for volunteer fire relief associations. The plan is funded by fire state aid, investment earnings and, if necessary, employer contributions as specified in Minnesota statutes and voluntary City contributions (if applicable). The State of Minnesota contributed $146,833 in fire state aid to the plan on behalf of the City Fire Department for the year ended December 31, 2023, which was recorded as a revenue. Required employer contributions are calculated annually based on statutory provisions. The City made voluntary contributions of $45,540 to the plan. 97 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 5: Defined Benefit Pension Plans - Fire Relief Association (Continued) D. Pension Costs At December 31, 2023, the City reported a net pension asset of $389,338 for the Volunteer Firefighter Fund. The net pension asset was measured as of December 31, 2023. The total pension liability used to calculate the net pension asset in accordance with GASB 68 was determined by PERA, applying an actuarial formula to specific census data certified by the Department. The following table presents the changes in net pension liability (asset) during the year: For the year ended December 31, 2023, the City recognized a pension expense of $216,131 At December 31, 2023, the City reported deferred outflows of resources and deferred inflows of resources, and contributions subsequent to the measurement date, to the plan from the following sources: DeferredDeferred OutflowsInflows of Resourcesof Resources Differences between Expected and Actual Economic Experience$ 10,387 $ 143,865 Changes in Actuarial Assumptions 32,064 60,642 Net Difference between Projected and Actual Earnings on Plan Investments 340,963 - Contributions to Plan Subsequent to the Measurement Date 192,374 - Total$ 575,788 $ 204,507 98 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 5: Defined Benefit Pension Plans - Fire Relief Association (Continued) Deferred outflows of resources totaling $192,374 subsequent to the measurement date will be recognized as a reduction of the net pension liability in the year ended December 31, 2024. E. Actuarial Assumptions The total pension liability at December 31, 2023 was determined using the entry age normal actuarial cost method and the following actuarial assumptions: There were no changes in actuarial assumptions in 2023. F.Discount Rate The discount rate used to measure the total pension liability was 5.0 percent. The projection of cash flows used to determine the discount rate assumed that contributions to the plan will be made as specified in statute. Based on that assumption and considering the funding ratio of the plan, the fiduciary net position was projected to be available to make all projected future benefit payments of current active and inactive members. Therefore, the long-term expected rate of return on pension plan investments was applied to all periods of projected benefit payments to determine the total pension liability. G. Pension Asset Sensitivity 1 percent lower or 1 percent higher than the current discount rate: 1 Percent1 Percent Decrease (4.00%)Current (5.00%)Increase (6.00%) Defined Benefit Plan$ (294,145)$ (389,338)$ (477,902) 99 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 5: Defined Benefit Pension Plans - Fire Relief Association (Continued) H.Asset Allocation The long-term expected rate of return on pension plan investments was determined using a building-block method in which best estimates for expected future real rates of return (expected returns, net of inflation) were developed for each -term return expectations by asset class. Inflation expectations were applied to derive the nominal rate of return for the portfolio. The target allocation and best estimates of geometric real rates of return for each major asset class are summarized in the following table: .Pension Plan Fiduciary Net Position Detailed information about the Plan's fiduciary net position is available in a separately-issued report. That report may be obtained by writing to the Hopkins Fire Relief Association, 1010 First St. S., Hopkins, MN 55343. Note 6: Postemployment Benefits Other Than Pensions A.Plan Description The City's single employer defined benefit OPEB plan provides OPEB for all permanent full-time employees of the City. The City's OPEB plan is administered by the City. The City does not administer a trust and therefore does not issue a separate financial statements. The City is funding this liability on a pay-as-you-go-basis. The City provides benefits for retirees as required by Minnesota Statute §471.61 subdivision 2b. The City provides subsidized benefits to active employees, who were hired prior to July 1, 1993 and have been with the City for at least ten years and are either (1) age 60 year or older or (2) eligible for full PERA retirement benefits. Employees retiring by June 30, 2007 will receive full single health and life insurance coverage until age 65; employees retiring between July 1, 2007 and December 31, 2009 will receive $500 per month towards the cost of single health and life insurance until age 65; and employees retiring after December 31, 2009 will receive $15 per month times years of service (maximum of $500 per month) towards the cost of single health and life insurance until age 65. Currently 16 employees meet those eligibility requirements. Benefit and eligibility provisions are established through negotiations and are renegotiated every two years. In the valuation dated, the following employees were covered by the benefit terms: Inactive Plan Members or Beneficiaries Currently Receiving Benefit Payments 14 Active Plan Members 105 Total Plan Members 119 100 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 6: Postemployment Benefits Other Than Pensions (Continued) B.Funding Policy The contribution requirements of plan members and the City are established and may be amended by the Board of Directors. The required contributions are based on projected pay-as-you-go financing requirements. The City contributed $112,849 to the plan for the year ended December 31, 2023. As of the valuation date, there was nine retirees that were receiving health benefits from the plan. C.Actuarial Methods and Assumptions 273,045 was measured as of December 31, 2023, and the total OPEB liability used to calculate the total OPEB liability was determined by an actuarial valuation as the valuation date. The actuarial valuation was determined using the following actuarial assumptions, applied to all periods included in the measurement, unless otherwise specified. Each assumption was reviewed for reasonableness with the source information as well as for consistency with the other economic assumptions. D.Changes in the Total OPEB Liability Total OPEB Liability (a) Balances at December 31, 2022$ 1,490,949 Changes for the Year: Service cost 53,420 Interest 29,486 Changes in assumptions or other inputs (159,927) Benefit payments (140,883) Net Changes (217,904) Balances at December 31, 2023$ 1,273,045 For the fiscal year ending December 31, 2023 the following assumption changes were made: The inflation rate was changed from 2.00% to 2.50% The discount rate was changed from 2.00% to 4.00% For the fiscal year ending December 31, 2023 the following benefit changes were made: No changes in 2023 101 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 6: Postemployment Benefits Other Than Pensions (Continued) E.Changes in Total OPEB Liability total OPEB liability would be if it were calculated using a discount rate that is 1-percentage point lower (3.00 percent) or 1-percentage-point higher (5.00 percent) than the current discount rate: ere calculated using a healthcare cost trend rate that is 1-percentage point lower (4.00 percent) or 1-percentage-point higher (6.00 percent) than the current trend rate: F.OPEB Expense and Deferred Outflows and Deferred Inflows of Resources Related to OPEB Amounts reported as deferred inflows and outflows of resources related to OPEB are as follow: Deferred OutflowsDeferred Inflows of Resourcesof Resources Liability (gains)/losses $ 354,653$ - Changes in actuarial assumptions 61,899 155,425 Contributions to OPEB Subsequent to the Measurement Date 112,849 - Total$ 529,401$ 155,425 Deferred outflows of resources totaling $112,849 related to City contributions to the OPEB plan subsequent to the measurement date will be recognized as a reduction of the OPEB liability and expense in the year ended December 31, 2024 as follows: Year ended December 31: $ 36,999 2024 36,999 2025 36,999 2026 36,999 2027 39,872 2028 73,259 Thereafter 102 City of Hopkins, Minnesota Notes to the Financial Statements December 31, 2023 Note 7: Other Information A.Risk Management The City is exposed to various risks of loss related to torts; theft of, damage to, and destruction of assets; errors and omissions; injuries to employees; and natural disasters. The City participates in a public entity risk pool to mitigate its exposure to these risks. Workers compensation and property and liability coverage are provided through a pooled self- insurance plan with other cities. Settled claims have not exceeded insurance coverage in any of the past three fiscal years and no significant reductions in coverage from the prior year. The City pays an annual premium based on prior claims history for its workers compensation coverage. The public entity risk pool is responsible for the payment of all associated claims. The City has a $20,000 deductible per occurrence with a maximum per year out of pocket of $40,000, for its property and liability coverage. The public entity risk pool is responsible for all losses in excess of $20,000 per occurrence and all losses occurring after the $40,000 maximum City out of pocket costs. B.Tax Increment Financing Districts disallowed claims or misuse of tax increments could become a liability of the applicable fund. Management has indicated that they are not aware of any instances of noncompliance which would have a material effect on the financial statements. only to the extent of the increment received. As a result they are a commitment within the district but they have not met thcriteria to be reported as a liability on the statement of net position. Note 8: Subsequent Event 103 THIS PAGE IS LEFT BLANK INTENTIONALLY 104 REQUIRED SUPPLEMENTARY INFORMATION CITY OF HOPKINS HOPKINS, MINNESOTA FOR THE YEAR ENDED DECEMBER 31, 2023 105 City of Hopkins, Minnesota Required Supplementary Information For the Year Ended December 31, 2023 Schedule of e of PERA Net Pension Liability - General Employees Fund Note: Schedule is intended to show 10-year trend. Additional years will be reported as they become available. Schedule of EmpPERA Contributions - General Employees Fund Contributions in Contributions as Relation to the a Percentage of StatutorilyStatutorilyContributionCity's Covered RequiredRequiredDeficiencyCovered Payroll YearContributionContribution(Excess)Payroll (b/c) Ending(a)(b)(a-b)(c) 12/31/2023$ 483,818$ 483,818$ -$ 6,450,905 %7.50 12/31/2022 453,608 453,608 - 6,048,111 7.50 12/31/2021 428,662 428,662 - 5,715,487 7.50 12/31/2020 421,975 421,975 - 5,626,334 7.50 12/31/2019 428,720 428,720 - 5,716,269 7.50 12/31/2018 421,073 421,073 - 5,614,313 7.50 12/31/2017 399,239 399,239 - 5,323,185 7.50 12/31/2016 390,718 390,718 - 5,209,569 7.50 12/31/2015 355,542 355,542 - 4,740,557 7.50 Note: Schedule is intended to show 10-year trend. Additional years will be reported as they become available. 106 City of Hopkins, Minnesota Required Supplementary Information (Continued) For the Year Ended December 31, 2023 Notes to the Required Supplementary Information - General Employees Fund Changes in Actuarial Assumptions 2023 - The investment return assumption and single discount rate were changed from 6.50 percent to 7.00 percent. 2022 - The mortality improvement scale was changed from Scale MP-2020 to Scale MP-2021. 2021 - The investment return and single discount rates were changed from 7.50 percent to 6.50 percent, for financial reporting purposes. The mortality improvement scale was changed from Scale MP-2019 to Scale MP-2020. 2020 - The price inflation assumption was decreased from 2.50% to 2.25%. The payroll growth assumption was decreased from 3.25% to 3.00%. Assumed salary increase rates were changed as recommended in the June 30, 2019 experience study. The net effect is assumed rates that average 0.25% less than previous rates. Assumed rates of retirement were changed as recommended in the June 30, 2019 experience study. The changes result in more unreduced (normal) retirements and slightly fewer Rule of 90 and early retirements. Assumed rates of termination were changed as recommended in the June 30, 2019 experience study. The new rates are based on service and are generally lower than the previous rates for years 2-5 and slightly higher thereafter. Assumed rates of disability were changed as recommended in the June 30, 2019 experience study. The change results in fewer predicted disability retirements for males and females. The base mortality table for healthy annuitants and employees was changed from the RP-2014 table to the Pub-2010 General Mortality table, with adjustments. The base mortality table for disabled annuitants was changed from the RP- 2014 disabled annuitant mortality table to the PUB-2010 General/Teacher disabled annuitant mortality table, with adjustments. The mortality improvement scale was changed from Scale MP-2018 to Scale MP-2019. The assumed spouse age difference was changed from two years older for females to one year older. The assumed number of married male new retirees electing the 100% Joint & Survivor option changed from 35% to 45%. The assumed number of married female new retirees electing the 100% Joint & Survivor option changed from 15% to 30%. The corresponding number of married new retirees electing the Life annuity option was adjusted accordingly. 2019 - The mortality projection scale was changed from MP-2017 to MP-2018. 2018 - The mortality projection scale was changed from MP-2015 to MP-2017. The assumed benefit increase was changed from 1.00 percent per year through 2044 and 2.50 percent per year thereafter to 1.25 percent per year. 2017 - The Combined Service Annuity (CSA) loads were changed from 0.8 percent for active members and 60 percent for vested and non-vested deferred members. The revised CSA loads are now 0.0 percent for active member liability, 15.0 percent for vested deferred member liability and 3.0 percent for non-vested deferred member liability. The assumed post-retirement benefit increase rate was changed from 1.0 percent per year for all years to 1.0 percent per year through 2044 and 2.5 percent per year thereafter. 2016 - The assumed post-retirement benefit increase rate was changed from 1.0 percent per year through 2035 and 2.5 percent per year thereafter to 1.0 percent per year for all future years. The assumed investment return was changed from 7.9 percent to 7.5 percent. The single discount rate was changed from 7.9 percent to 7.5 percent. Other assumptions were changed pursuant to the experience study dated June 30, 2015. The assumed future salary increases, payroll growth and inflation were decreased by 0.25 percent to 3.25 percent for payroll growth and 2.50 percent for inflation. 2015 - The assumed post-retirement benefit increase rate was changed from 1.0 percent per year through 2030 and 2.5 percent per year thereafter to 1.0 percent per year through 2035 and 2.5 percent per year thereafter. 107 City of Hopkins, Minnesota Required Supplementary Information (Continued) For the Year Ended December 31, 2023 Notes to the Required Supplementary Information - General Employees Fund (Continued) Changes in Plan Provisions 2023 - An additional one-time direct state aid contribution of $170.1 million will be contributed to the Plan on October 1, 2023. The vesting period of those hired after June 30, 2010, was changed from five years of allowable service to three years of allowable service. The benefit increase delay for early retirements on or after January 1, 2024, was eliminated. A one-time, non-compounding benefit increase of 2.5 percent minus the actual 2024 adjustment will be payable in a lump sum for calendar year 2024 by March 31, 2024. 2022 - There were no changes in plan provisions since the previous valuation. 2021 - There were no changes in plan provisions since the previous valuation. 2020 - Augmentation for current privatized members was reduced to 2.0% for the period July 1, 2020 through December 31, 2023 and 0.0% after. Augmentation was eliminated for privatizations occurring after June 30, 2020. 2019 - The employer supplemental contribution was changed prospectively, decreasing from $31.0 million to $21.0 through 2031. 2018 - The augmentation adjustment in early retirement factors is eliminated over a five-year period starting July 1, 2019, resulting in actuarial equivalence after June 30, 2024. Interest credited on member contributions decreased from 4.00 percent to 3.00 percent, beginning July 1, 2018. Deferred augmentation was changed to 0.00 percent, effective January 1, 2019. Augmentation that has already accrued for deferred members will still apply. Contribution stabilizer provisions were repealed. Postretirement benefit increases were changed from 1.00 percent per year with a provision to increase to 2.50 percent upon attainment of 90.00 percent funding ratio to 50.00 percent of the Social Security Cost of Living Adjustment, not less than 1.00 percent and not more than 1.50 percent, beginning January 1, 2019. For retirements on or after January 1, 2024, the first benefit increase is delayed until the retiree reaches normal retirement age; does not apply to Rule of 90 retirees, disability benefit recipients, or survivors. Actuarial equivalent factors were updated to reflect revised mortality and interest assumptions. 2017 - and $6,000,000 thereafter. The Employer Supplemental Contribution for the Minneapolis Employees Retirement Fund changed from $21,000,000 to $ $16,000,000 to $6,000,000 in calendar years 2019 to 2031. 2016 - There were no changes in plan provisions since the previous valuation. 2015 - On January 1, 2015, the Minneapolis Employees Retirement Fund was merged into the General Employees Fund, which increased the total pension liability by $1.1 billion and increased the fiduciary plan net position by $892 million. Upon consolidation, state and employer contributions were revised. 108 City of Hopkins, Minnesota Required Supplementary Information (Continued) For the Year Ended December 31, 2023 Schedule of are of PERA Net Pension Liability - Police and Fire Fund Note: Schedule is intended to show 10-year trend. Additional years will be reported as they become available. Schedule of EmpPERA Contributions - Police and Fire Fund Contributions in Contributions as Relation to the a Percentage of StatutorilyStatutorilyContributionCity's Covered RequiredRequiredDeficiencyCovered Payroll YearContributionContribution(Excess)Payroll (b/c) Ending(a)(b)(a-b)(c) 12/31/2023$ 683,867$ 683,867$ -$ 3,863,655 %17.7 12/31/2022 639,711 639,711 - 3,614,186 17.7 12/31/2021 618,899 618,899 - 3,496,605 17.7 12/31/2020 607,594 607,594 - 3,432,736 17.7 12/31/2019 563,971 563,971 - 3,327,260 17.0 12/31/2018 515,478 515,478 - 3,181,963 16.2 12/31/2017 484,481 484,481 - 2,990,626 16.2 12/31/2016 460,042 460,042 - 2,839,765 16.2 12/31/2015 384,024 384,024 - 2,370,520 16.2 Note: Schedule is intended to show 10-year trend. Additional years will be reported as they become available. 109 City of Hopkins, Minnesota Required Supplementary Information (Continued) For the Year Ended December 31, 2023 Notes to the Required Supplementary Information - Public Employees Police and Fire Fund Changes in Actuarial Assumptions 2023 - The investment return assumption was changed from 6.50 percent to 7.00 percent. The single discount rate changed from 5.40 percent to 7.0 percent. 2022 - The mortality improvement scale was changed from Scale MP-2020 to Scale MP-2021. The single discount rate changed from 6.50 percent to 5.40 percent. 2021 - The investment return and single discount rates were changed from 7.50 percent to 6.50 percent, for financial reporting purposes. The inflation assumption was changed from 2.50 percent to 2.25 percent. The payroll growth assumption was changed from 3.25 percent to 3.00 percent. The base mortality table for healthy annuitants and employees was changed from the RP-2014 table to the Pub-2010 Public Safety Mortality table. The mortality improvement scale was changed from MP-2019 to MN-2020. The base mortality table for disabled annuitants was changed from the RP-2014 healthy annuitant mortality table (with future mortality improvement according to Scale MP-2019) to the Pub- 2010 Public Safety disabled annuitant mortality table (with future mortality improvement according to Scale MP-2020). Assumed rates of salary increase were modified as recommended in the July 14, 2020 experience study. The overall impact is a decrease in gross salary increase rates. Assumed rates of retirement were changed as recommended in the July 14, 2020 experience study. The changes result in slightly more unreduced retirements and fewer assumed early retirements. Assumed rates of withdrawal were changed from select and ultimate rates to service-based rates. The changes result in more assumed terminations. Assumed rates of disability were increased for ages 25-44 and decreased for ages over 49. Overall, proposed rates result in more projected disabilities. Assumed percent married for active female members was changed from 60 percent to 70 percent. Minor changes to form of payment assumptions were applied. 2020 - The mortality projection scale was changed from MP-2018 to MP-2019. 2019 - The mortality projection scale was changed from MP-2017 to MP-2018. 2018 - The mortality projection scale was changed from MP-2016 to MP-2017. As set by statute, the assumed post- retirement benefit increase was changed from 1.0 percent per year through 2064 and 2.5 percent per year, thereafter, to 1.0 percent for all years, with no trigger. 2017 - Assumed salary increases were changed as recommended in the June 30, 2016 experience study. The net effect is proposed rates that average 0.34 percent lower than the previous rates. Assumed rates of retirement were changed, resulting in fewer retirements. The Combined Service Annuity (CSA) load was 30 percent for vested and non-vested deferred members. The CSA has been changed to 33 percent for vested members and 2 percent for non-vested members. The base mortality table for healthy annuitants was changed from the RP-2000 fully generational table to the RP-2014 fully generational table (with a base year of 2006), with male rates adjusted by a factor of 0.96. The mortality improvement scale was changed from Scale AA to Scale MP-2016. The base mortality table for disabled annuitants was changed from the RP-2000 disabled mortality table to the mortality tables assumed for healthy retirees. Assumed termination rates were decreased to 3.0 percent for the first three years of service. Rates beyond the select period of three years were adjusted, resulting in more expected terminations overall. Assumed percentage of married female members was decreased from 65 percent to 60 percent. Assumed age difference was changed from separate assumptions for male members (wives assumed to be three years younger) and female members (husbands assumed to be four years older) to the assumption that males are two years older than females. The assumed percentage of female members electing joint and survivor annuities was increased. The assumed post-retirement benefit increase rate was changed from 1.00 percent for all years to 1.00 percent per year through 2064 and 2.50 percent thereafter. The single discount rate was changed from 5.6 percent to 7.5 percent. 2016 - The assumed post-retirement benefit increase rate was changed from 1.0 percent per year through 2037 and 2.5 percent per year thereafter to 1.0 percent per year for all future years. The assumed investment return was changed from 7.9 percent to 7.5 percent. The single discount rate was changed from 7.9 percent to 5.6 percent. The assumed future salary increases, payroll growth and inflation were decreased by 0.25 percent to 3.25 percent for payroll growth and 2.50 percent for inflation. 110 City of Hopkins, Minnesota Required Supplementary Information (Continued) For the Year Ended December 31, 2023 Notes to the Required Supplementary Information - Public Employees Police and Fire Fund (Continued) 2015 - The assumed post-retirement benefit increase rate was changed from 1.0 percent per year through 2030 and 2.5 percent per year thereafter to 1.0 percent per year through 2037 and 2.5 percent per year thereafter. Changes in Plan Provisions 2023 - Additional one-time direct state aid contribution of 19.4 million will be contributed to the Plan on October 1, 2023. Vesting requirement for new hires after June 30, 2014, was changed from a graded 20-year vesting schedule to a graded 10-year vesting schedule, with 50 percent vesting after five years, increasing incrementally to 100% after 10 years. A one- time, non-compounding benefit increase of 3.0 percent will be payable in a lump sum for calendar year 2024 by March 31, 2024. Psychological treatment is required effective July 1, 2023, prior to approval for a duty disability benefit for s increased, effective July 1, 2023. 2022 - There were no changes in plan provisions since the previous valuation. 2021 - There were no changes in plan provisions since the previous valuation. 2020 - There were no changes in plan provisions since the previous valuation. 2019 - There were no changes in plan provisions since the previous valuation. 2018 - As set by statute, the assumed post-retirement benefit increase was changed from 1.0 percent per year through 2064 and 2.5 percent per year, thereafter, to 1.0 percent for all years, with no trigger. An end date of July 1, 2048 was added to the existing $9.0 million state contribution. New annual state aid will equal $4.5 million in fiscal years 2019 and 2020, and $9.0 million thereafter until the plan reaches 100 percent funding, or July 1, 2048, if earlier. Member contributions were changed from 10.80 percent to 11.30 percent of pay, effective January 1, 2019 and 11.80 percent of pay, effective January 1, 2020. Employer contributions were changed from 16.20 percent to 16.95 percent of pay, effective January 1, 2019 and 17.70 percent of pay, effective January 1, 2020. Interest credited on member contributions decreased from 4.00 percent to 3.00 percent, beginning July 1, 2018. Deferred augmentation was changed to 0.00 percent, effective January 1, 2019. Augmentation that has already accrued for deferred members will still apply. Actuarial equivalent factors were updated to reflect revised mortality and interest assumptions. 2017 - Assumed salary increases were changed as recommended in the June 30, 2016 experience study. The net effect is proposed rates that average 0.34 percent lower than the previous rates. Assumed rates of retirement were changed, resulting in fewer retirements. The combined service annuity (CSA) load was 30.00 percent for vested and non-vested, deferred members. The CSA has been changed to 33.00 percent for vested members and 2.00 percent for non-vested members. The base mortality table for healthy annuitants was changed from the RP-2000 fully generational table to the RP-2014 fully generational table (with a base year of 2006), with male rates adjusted by a factor of 0.96. The mortality improvement scale was changed from Scale AA to Scale MP-2016. The base mortality table for disabled annuitants was changed from the RP-2000 disabled mortality table to the mortality tables assumed for healthy retirees. Assumed termination rates were decreased to 3.00 percent for the first three years of service. Rates beyond the select period of three years were adjusted, resulting in more expected terminations overall. Assumed percentage of married female members was decreased from 65.00 percent to 60.00 percent. Assumed age difference was changed from separate assumptions for male members (wives assumed to be three years younger) and female members (husbands assumed to be four years older) to the assumption that males are two years older than females. The assumed percentage of female members electing joint and survivor annuities was increased. The assumed postretirement benefit increase rate was changed from 1.00 percent for all years to 1.00 percent per year through 2064 and 2.50 percent thereafter. The single discount rate was changed from 5.60 percent per annum to 7.50 percent per annum. 2016 - There were no changes in plan provisions since the previous valuation. 2015 - The post-retirement benefit increase to be paid after attainment of the 90 percent funding threshold was changed, from inflation up to 2.5 percent, to a fixed rate of 2.5 percent. 111 City of Hopkins, Minnesota Required Supplementary Information (Continued) For the Year Ended December 31, 2023 Schedule of Changes in et Pension Liability (Asset) and Related Ratios Note: Schedule is intended to show 10-year trend. Additional years will be reported as they become available. ActuarialActualContribution DeterminedContributionsDeficiency YearContributionPaid(Excess) Ending(a)(b)(a-b) 12/31/23$ 176,193$ 192,374$ (16,181) 12/31/22 136,068 180,068 (44,000) 12/31/21 126,228 178,228 (52,000) 12/31/20 42,000 42,000 - 12/31/19 40,000 40,000 - 12/31/18 40,000 40,000 - 12/31/17 143,749 143,749 - Note: Schedule is intended to show 10-year trend. Additional years will be reported as they become available. 112 City of Hopkins, Minnesota Required Supplementary Information (Continued) For the Year Ended December 31, 2023 20232022202120202019 Total OPEB Liability Service cost$ 53,420$ 72,396$ 69,455$ 58,213$ 49,577 Interest 29,486 21,602 30,328 35,759 33,554 Plan changes - 66,761 - - - Differences between expected and actual experience - 369,886 - 97,907 - Changes in assumptions (159,927) 12,393 49,099 29,358 (25,854) Benefit payments (140,883) (119,046) (115,693) (139,243) (144,260) Net Change in Total OPEB Liability (217,904) 423,992 33,189 81,994 (86,983) Total OPEB Liability - Beginning 1,490,949 1,066,957 1,033,768 951,774 1,038,757 Total OPEB Liability - Ending$ 1,273,045$ 1,490,949$ 1,066,957$ 1,033,768$ 951,774 Covered - Payroll$ 9,482,259$ 9,206,077$ 9,094,678$ 8,808,405$ 8,223,045 City's Total OPEB Liability as a Percentage of Covered Payroll %13.43 %16.20 %11.73 %11.74 %11.57 Note: Schedule is intended to show 10-year trend. Additional years will be reported as they become available. Note: The OPEB plan currently has no assets accumulated in a trust. 113 THIS PAGE IS LEFT BLANK INTENTIONALLY 114 COMBINING AND INDIVIDUAL FUND FINANCIAL STATEMENTS AND SCHEDULES CITY OF HOPKINS HOPKINS, MINNESOTA FOR THE YEAR ENDED DECEMBER 31, 2023 115 City of Hopkins, Minnesota Nonmajor Governmental Funds Combining Balance Sheet December 31, 2023 SpecialCapital RevenueProjectsTotal Assets Cash and temporary investments$ 5,418,242 $ 2,057,152 $ 7,475,394 Receivables Accounts 58,118 166,112 224,230 Leases 973,298 - 973,298 Loans 7,901 - 7,901 Due from other governments 9,323 - 9,323 Prepaid items 1,891 - 1,891 Total Assets$ 6,468,773 $ 2,223,264 $ 8,692,037 Liabilities Accounts and contracts payable$ 1,094,750 $ -$ 1,094,750 Accrued salaries and benefits payable 53,070 - 53,070 Due to other governments 1,039 - 1,039 Unearned revenue 842,115 - 842,115 Due to other funds 995,999 - 995,999 Total Liabilities 2,986,973 - 2,986,973 Deferred Inflows of Resources Unavailable revenues - leases 965,290 - 965,290 Fund Balances Nonspendable 1,891 - 1,891 Restricted 3,523,409 526,100 4,049,509 Committed 73,021 - 73,021 Assigned - 1,697,164 1,697,164 Unassigned (1,081,811) - (1,081,811) Total Fund Balances 2,516,510 2,223,264 4,739,774 Total Liabilities, Deferred Inflows of Resources and Fund Balances$ 6,468,773 $ 2,223,264 $ 8,692,037 116 City of Hopkins, Minnesota Nonmajor Governmental Funds Combining Statement of Revenues, Expenditures and Changes in Fund Balances For the Year Ended December 31, 2023 SpecialCapital RevenueProjectsTotal Revenues Taxes Property$ 347,697 $ -$ 347,697 Tax increment 1,317,240 - 1,317,240 Franchise fees 197,761 659,928 857,689 Intergovernmental 1,574,477 - 1,574,477 Charges for services 853,063 - 853,063 Investment earnings 7,213 23,943 31,156 Miscellaneous 129,312 25,000 154,312 Total Revenues 4,426,763 708,871 5,135,634 Expenditures Current General government 360,253 - 360,253 Public safety 357,448 - 357,448 Public works 174,668 - 174,668 Culture and recreation 1,131,382 - 1,131,382 Urban development and housing 200,946 - 200,946 Capital outlay Public safety 48,443 - 48,443 Public works - 4,881 4,881 Culture and recreation 24,082 82,653 106,735 Urban development and housing 2,318,845 - 2,318,845 Total Expenditures 4,616,067 87,534 4,703,601 Excess (Deficiency) of Revenues Over (Under) Expenditures (189,304) 621,337 432,033 Other Financing Sources (Uses) Transfers in 1,275,000 - 1,275,000 Transfers out (50,000) (470,000) (520,000) Total Other Financing Sources (Uses) 1,225,000 (470,000) 755,000 Net Change in Fund Balances 1,035,696 151,337 1,187,033 Fund Balances, January 1 1,480,814 2,071,927 3,552,741 Fund Balances, December 31$ 2,516,510 $ 2,223,264 $ 4,739,774 117 THIS PAGE IS LEFT BLANK INTENTIONALLY 118 NONMAJOR SPECIAL REVENUE FUNDS Special revenue funds are used to account for revenue derived from specific taxes or other earmarked revenue sources. They are usually required by Minnesota statute or local ordinances to finance particular functions or other activities of government. State Chemical Assessment This fund is entirely supported by state aid for the purpose of chemical assessment training and activity for the State of Minnesota. Hennepin County CDBG This fund accounts for receipt for Community Development Block Grant Funds and the issuance of loans and grants for housing rehabilitation. Parking This fund acquired land, improves and maintains parking lots and a parking ramp and collects monthly maintenance fees from users. Communications -city joint venture cable TV franchise administered under the Southwest Suburban Cable Commission. Art Center This fund accounts for the activities of the Hopkins Center for the Arts. Sources of funds are derived from leases, ticket sales, admission fees, grants and donations. Hopkins Race and Equity Initiative This fund was established to account for the activity of collaborative effort of the City and two outside organization centered on race equity. Depot Coffee House This fund accounts for the operations of the coffee house business and the teen center operations that are supported through grant funds. ARPA This fund was established to record the receipt of American Rescue Plan Act Fund proceeds and the purchases in accordance with the guidelines determined by the U.S. Department of Treasury. Public Safety Aid - This fund was established to record proceeds of a one-time state grant and the related expenditures in accordance with State requirements. Tax Increment Districts These funds were established to record the use of tax increment receipts and bond proceeds as applied in various Tax Increment Districts. th th 5 Avenue Flats This fund was established to account for the project costs of the 5 Avenue Flats project. Originally shown as a tax increment fund though the project changed scope and is no longer in a tax increment district. 119 City of Hopkins, Minnesota Nonmajor Special Revenue Funds Combining Balance Sheet December 31, 2023 314317318325328361327 StateTIFHennepinHopkins Race ChemicalSpendingCountyArtand Equity AssessmentPlanCDBGParkingCommunicationsCenterInitiative Assets Cash and temporary investments$ -$ 2,654,400$ 33$ -$ 30,223$ 34,843$ 46,073 Receivables Accounts - - - - 55,799 1,865 - Leases - - - - - 973,298 - Loans - - 7,901 - - - - Due from other governments 8,258 - - 1,065 - - - Prepaid items - - - 1,891 - - - Total Assets$ 8,258$ 2,654,400$ 7,934$ 2,956$ 86,022$ 1,010,006$ 46,073 Liabilities Accounts payable$ 209$ -$ -$ 167$ 1,858$ 33,871$ - Salaries payable 468 - - 5,725 11,143 24,876 - Due to other governments - - - 906 - 116 - Due to other funds 71,917 - - 79,027 - - - Unearned revenue 35,922 - - 10,673 - 17,197 - Total Liabilities 108,516 - - 96,498 13,001 76,060 - Deferred Inflows of Resources Unavailable revenues - leases - - - - - 965,290 - Fund Balances Nonspendable - - - 1,891 - - - Restricted - 2,654,400 7,934 - - - 46,073 Committed - - - - 73,021 - - Unassigned (100,258) - - (95,433) - (31,344) - Total Fund Balances (100,258) 2,654,400 7,934 (93,542) 73,021 (31,344) 46,073 Total Liabilities, Deferred Inflows of Resources and Fund Balances$ 8,258$ 2,654,400$ 7,934$ 2,956$ 86,022$ 1,010,006$ 46,073 120 32:32132232333:343345344 Tax IncrementTax IncrementTax Increment DepotDistrictPublicDistrictTax IncrementDistrict CoffeeEntertainmentSafetyOaks of5th AvenueDistrictMarketplace HouseARPADistrictAidMainstreetFlatsMolineand MainTotal $ -$ 796,507$ 77,140$ 806,541$ -$ -$ 820,586$ 151,896$ 5,418,242 454 - - - - - - - 58,118 - - - - - - - - 973,298 - - - - - - - - 7,901 - - - - - - - - 9,323 - - - - - - - - 1,891 $ 454$ 796,507$ 77,140$ 806,541$ -$ -$ 820,586$ 151,896$ 6,468,773 $ 304$ 7,338$ -$ 29,081$ -$ -$ 915,574$ 106,348$ 1,094,750 12 10,846 - - - - - - 53,070 17 - - - - - - - 1,039 190,834 - 39,598 - 5,244 399,379 - 210,000 995,999 - 778,323 - - - - - - 842,115 191,167 796,507 39,598 29,081 5,244 399,379 915,574 316,348 2,986,973 - - - - - - - - 965,290 - - - - - - - - 1,891 - - 37,542 777,460 - - - 3,523,409 - - - - - - - - 73,021 (190,713) - (5,244) (399,379) (94,988) (164,452) (1,081,811) (190,713) - 37,542 777,460 (5,244) (399,379) (94,988) (164,452) 2,516,510 $ 454$ 796,507$ 77,140$ 806,541$ -$ -$ 820,586$ 151,896$ 6,468,773 121 City of Hopkins, Minnesota Nonmajor Special Revenue Funds Combining Statement of Revenues, Expenditures and Changes in Fund Balances For the Year Ended December 31, 2023 314317318325328361327 StateTIFHennepinHopkins Race ChemicalSpendingCountyArtand Equity AssessmentPlanCDBGParkingCommunicationsCenterInitiative Revenues Property taxes$ -$ -$ -$ -$ -$ 347,697$ - Tax increments - - - - - - - Franchise fees - - - - 197,761 - - Intergovernmental 62,148 - - - - 178,449 - Charges for services - - - 74,349 - 709,465 - Investment earnings - - - 43 2,537 64 619 Miscellaneous - - - 13,140 - 54,626 36,000 Total Revenues 62,148 - - 87,532 200,298 1,290,301 36,619 Expenditures Current General government - - - - 292,434 - - Public safety 110,721 - - - - - - Public works - - - 174,668 - - - Culture and recreation - - - - - 1,020,359 612 Urban development and housing - - 4,111 - - - - Capital outlay Public safety - - - - - - - Culture and recreation - - - - - 24,082 - Urban development and housing - - - - - - - Total Expenditures 110,721 - 4,111 174,668 292,434 1,044,441 612 Excess (Deficiency) of Revenues Over (Under) Expenditures (48,573) - (4,111) (87,136) (92,136) 245,860 36,007 Other Financing Sources (Uses) Transfers in - - - - - 80,000 - Transfers out - - - - (50,000) - - Total Other Financing Sources (Uses) - - - - (50,000) 80,000 - Net Change in Fund Balances (48,573) - (4,111) (87,136) (142,136) 325,860 36,007 Fund Balances, January 1 (51,685) 2,654,400 12,045 (6,406) 215,157 (357,204) 10,066 Fund Balances, December 31$ (100,258)$ 2,654,400$ 7,934$ (93,542)$ 73,021$ (31,344)$ 46,073 122 32:32132232333:343345344 Tax IncrementTax IncrementTax Increment DepotDistrictPublicDistrictTax IncrementDistrict CoffeeEntertainmentSafetyOaks of5th AvenueDistrictMarketplace HouseARPADistrictAidMainstreetFlatsMolineand MainTotal $ -$ -$ -$ -$ -$ -$ -$ -$ 347,697 - - 56,725 - - - 1,034,609 225,906 1,317,240 - - - - - - - - 197,761 19,500 486,173 - 828,207 - - - - 1,574,477 69,249 - - - - - - - 853,063 - - 1,053 - - - - 2,897 7,213 25,546 - - - - - - - 129,312 114,295 486,173 57,778 828,207 - - 1,034,609 228,803 4,426,763 -67,819 - - - - - - 360,253 - 231,927 - 14,800 - - - - 357,448 - - - - - - - - 174,668 110,411 - - - - - - - 1,131,382 - 173,931 148 - 5,244 - 14,401 3,111 200,946 - 12,496 - 35,947 - - - - 48,443 - - - - - - - - 24,082 - - - - - - 2,106,148 212,697 2,318,845 110,411 486,173 148 50,747 5,244 - 2,120,549 215,808 4,616,067 3,884 - 57,630 777,460 (5,244) - (1,085,940) 12,995 (189,304) 20,000 - - - - - 1,175,000 - 1,275,000 - - - - - - - - (50,000) 20,000 - - - - - 1,175,000 - 1,225,000 23,884 - 57,630 777,460 (5,244) - 89,060 12,995 1,035,696 (214,597) - (20,088) - - (399,379) (184,048) (177,447) 1,480,814 $ (190,713)$ -$ 37,542$ 777,460$ (5,244)$ (399,379)$ (94,988)$ (164,452)$ 2,516,510 123 City of Hopkins, Minnesota State Chemical Assessment Fund Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the Year Ended December 31, 2023 (With Comparative Actual Amounts for the Year Ended December 31, 2022) 2023 2022 Budget Amounts ActualVariance withActual OriginalFinalAmountsFinal BudgetAmounts Revenues Intergovernmental$ -$ -$ 62,148$ 62,148$ 28,720 Miscellaneous 65,000 65,000 - (65,000) - Total Revenues 65,000 65,000 62,148 (2,852) 28,720 Expenditures Current Public safety 65,000 65,000 110,721 (45,721) 54,350 Net Change in Fund Balances - - (48,573) (48,573) (25,630) Fund Balances, January 1 (51,685) (51,685) (51,685) - (26,055) Fund Balances, December 31$ (51,685) $ (51,685) $ (100,258)$ (48,573) $ (51,685) 124 City of Hopkins, Minnesota Parking Fund Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the Year Ended December 31, 2023 (With Comparative Actual Amounts for the Year Ended December 31, 2022) 2023 2022 Budget Amounts ActualVariance withActual OriginalFinalAmountsFinal BudgetAmounts Revenues Intergovernmental$ -$ -$ -$ -$ 65,000 Charges for services 133,000 133,000 74,349 (58,651) 89,365 Investment earnings 250 250 43 (207) - Miscellaneous 10,000 10,000 13,140 3,140 11,872 Total Revenues 143,250 143,250 87,532 (55,718) 166,237 Expenditures Current Public works 158,610 158,610 174,668 (16,058) 163,943 Net Change in Fund Balances (15,360) (15,360) (87,136) (71,776) 2,294 Fund Balances, January 1 (6,406) (6,406) (6,406) - (8,700) Fund Balances, December 31$ (21,766) $ (21,766) $ (93,542) $ (71,776) $ (6,406) 125 City of Hopkins, Minnesota Communications Fund Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the Year Ended December 31, 2023 (With Comparative Actual Amounts for the Year Ended December 31, 2022) 2023 2022 Budget Amounts ActualVariance withActual OriginalFinalAmountsFinal BudgetAmounts Revenues Franchise fees$ 233,000 $ 233,000 $ 197,761 $ (35,239) $ 200,222 Investment earnings - - 2,537 2,537 (189) Total Revenues 233,000 233,000 200,298 (32,702) 200,033 Expenditures Current General government 250,096 250,096 292,434 (42,338) 216,005 Capital outlay General government 3,500 3,500 - 3,500 - Total Expenditures 253,596 253,596 292,434 (38,838) 216,005 Excess (Deficiency) of Revenues Over (Under) Expenditures (20,596) (20,596) (92,136) (71,540) (15,972) Other Financing Sources (Uses) Transfers out (40,000) (40,000) (50,000) (10,000) (50,000) Net Change in Fund Balances (60,596) (60,596) (142,136) (81,540) (65,972) Fund Balances, January 1 215,157 215,157 215,157 - 281,129 Fund Balances, December 31$ 154,561 $ 154,561 $ 73,021$ (81,540) $ 215,157 126 City of Hopkins, Minnesota Art Center Fund Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the Year Ended December 31, 2023 (With Comparative Actual Amounts for the Year Ended December 31, 2022) 2023 2022 Budget Amounts ActualVariance withActual OriginalFinalAmountsFinal BudgetAmounts Revenues Property tax$ 347,697 $ 347,697 $ 347,697 $ -$ 339,318 Intergovernmental 32,000 32,000 178,449 146,449 253,295 Charges for services 695,435 695,435 709,465 14,030 714,092 Investment earnings - - 64 64 - Miscellaneous 9,000 9,000 54,626 45,626 15,717 Total Revenues 1,084,132 1,084,132 1,290,301 206,169 1,322,422 Expenditures Current Culture and recreation 958,397 958,397 1,020,359 (61,962) 919,938 Capital outlay Culture and recreation 145,735 145,735 24,082 121,653 82,477 Total Expenditures 1,104,132 1,104,132 1,044,441 59,691 1,002,415 Excess (Deficiency) of Revenues Over (Under) Expenditures (20,000) (20,000) 245,860 265,860 320,007 Other Financing Sources (Uses) Transfers in 80,000 80,000 80,000 - 80,000 Net Change in Fund Balances 60,000 60,000 325,860 265,860 400,007 Fund Balances, January 1 (357,204) (357,204) (357,204) - (757,211) Fund Balances, December 31$ (297,204)$ (297,204)$ (31,344) $ 265,860 $ (357,204) 127 City of Hopkins, Minnesota Hopkins Race and Equity Initiative Fund Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the Year Ended December 31, 2023 (With Comparative Actual Amounts for the Year Ended December 31, 2022) 2023 2022 Budget Amounts ActualVariance withActual OriginalFinalAmountsFinal BudgetAmounts Revenues Investment earnings$ -$ -$ 619$ 619$ (7) Miscellaneous 6,000 6,000 36,000 30,000 6,000 Total Revenues 6,000 6,000 36,619 30,619 5,993 Expenditures Current Culture and recreation 6,000 6,000 612 5,388 756 Net Change in Fund Balances - - 36,007 36,007 5,237 Fund Balances, January 1 10,066 10,066 10,066 - 4,829 Fund Balances, December 31$ 10,066$ 10,066$ 46,073$ 36,007$ 10,066 128 City of Hopkins, Minnesota Depot Coffee House Fund Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the Year Ended December 31, 2023 (With Comparative Actual Amounts for the Year Ended December 31, 2022) 2023 2022 Budget Amounts ActualVariance withActual OriginalFinalAmountsFinal BudgetAmounts Revenues Intergovernmental$ 19,500$ 19,500$ 19,500$ -$ 19,500 Charges for services 183,224 183,224 69,249 (113,975) 156,339 Miscellaneous 25,500 25,500 25,546 46 28,238 Total Revenues 228,224 228,224 114,295 (113,929) 204,077 Expenditures Current Culture and recreation 263,224 263,224 110,411 152,813 303,760 Excess (Deficiency) of Revenues Over (Under) Expenditures (35,000) (35,000) 3,884 38,884 (99,683) Other Financing Sources (Uses) Transfers in 20,000 20,000 20,000 - 20,000 Net Change in Fund Balances (15,000) (15,000) 23,884 38,884 (79,683) Fund Balances, January 1 (214,597) (214,597) (214,597) - (134,914) Fund Balances, December 31$ (229,597)$ (229,597)$ (190,713)$ 38,884$ (214,597) 129 City of Hopkins, Minnesota Tax Increment District Entertainment District Fund Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the Year Ended December 31, 2023 (With Comparative Actual Amounts for the Year Ended December 31, 2022) 2023 2022 Budget Amounts ActualVariance withActual OriginalFinalAmountsFinal BudgetAmounts Revenues Tax increments$ 45,000$ 45,000$ 56,725$ 11,725$ 61,351 Investment earnings (loss) - - 1,053 1,053 (156) Total Revenues 45,000 45,000 57,778 12,778 61,195 Expenditures Current Urban development and housing 10,000 10,000 148 9,852 2,013 Debt service Interest and other 6,046 6,046 - 6,046 3,327 Total Expenditures 16,046 16,046 148 15,898 5,340 Excess (Deficiency) of Revenues Over (Under) Expenditures 28,954 28,954 57,630 28,676 55,855 Other Financing Sources (Uses) Transfers out - - - - (302,400) Net Change in Fund Balances 28,954 28,954 57,630 28,676 (246,545) Fund Balances, January 1 (20,088) (20,088) (20,088) - 226,457 Fund Balances, December 31$ 8,866$ 8,866$ 37,542$ 28,676$ (20,088) 130 City of Hopkins, Minnesota Tax Increment District of Oaks of Mainstreet Fund Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the Year Ended December 31, 2023 (With Comparative Actual Amounts for the Year Ended December 31, 2022) 2023 2022 Budget Amounts ActualVariance withActual OriginalFinalAmountsFinal BudgetAmounts Revenues Investment earnings$ 250$ 250$ -$ (250)$ 1,590 Expenditures Current Urban development and housing 8,591 8,591 5,244 3,347 6,591 Excess (Deficiency) of Revenues Over (Under) Expenditures (8,341) (8,341) (5,244) 3,097 (5,001) Other Financing Sources (Uses) Transfers out - - - - (9,500) Net Change in Fund Balances (8,341) (8,341) (5,244) 3,097 (14,501) Fund Balances, January 1 - - - - 14,501 Fund Balances, December 31$ (8,341)$ (8,341)$ (5,244)$ 3,097$ - 131 City of Hopkins, Minnesota Tax Increment District Moline Fund Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the Year Ended December 31, 2023 (With Comparative Actual Amounts for the Year Ended December 31, 2022) 2023 2022 Budget Amounts ActualVariance withActual OriginalFinalAmountsFinal BudgetAmounts Revenues Tax increments$ 1,015,000$ 1,015,000$ 1,034,609$ 19,609$ 1,026,145 Expenditures Current Urban development and housing 20,101 20,101 14,401 5,700 26,516 Capital Urban development and housing 2,467,786 2,467,786 2,106,148 361,638 2,723,531 Total Expenditures 2,487,887 2,487,887 2,120,549 367,338 2,750,047 Excess (Deficiency) of Revenues Over (Under) Expenditures (1,472,887) (1,472,887) (1,085,940) 386,947 (1,723,902) Other Financing Sources (Uses) Transfers in 1,500,000 1,500,000 1,175,000 (325,000) 1,500,000 Transfers out - - - - (252,500) Total Other Financing Sources (Uses) 1,500,000 1,500,000 1,175,000 (325,000) 1,247,500 Net Change in Fund Balances 27,113 27,113 89,060 61,947 (476,402) Fund Balances, January 1 (184,048) (184,048) (184,048) - 292,354 Fund Balances, December 31$ (156,935)$ (156,935)$ (94,988)$ 61,947$ (184,048) 132 City of Hopkins, Minnesota Tax Increment District Marketplace and Main Fund Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the Year Ended December 31, 2023 (With Comparative Actual Amounts for the Year Ended December 31, 2022) 2023 2022 Budget Amounts ActualVariance withActual OriginalFinalAmountsFinal BudgetAmounts Revenues Tax increments$ 225,000$ 225,000$ 225,906$ 906$ 203,553 Investment earnings (loss) 1,000 1,000 2,897 1,897 (87) Total Revenues 226,000 226,000 228,803 2,803 203,466 Expenditures Current Urban development and housing 6,410 6,410 3,111 3,299 4,024 Capital outlay Urban development and housing 209,418 209,418 212,697 (3,279) 201,379 Total Expenditures 215,828 215,828 215,808 20 205,403 Net Change in Fund Balances 10,172 10,172 12,995 2,823 (1,937) Fund Balances, January 1 (177,447) (177,447) (177,447) - (175,510) Fund Balances, December 31$ (167,275)$ (167,275)$ (164,452)$ 2,823$ (177,447) 133 THIS PAGE IS LEFT BLANK INTENTIONALLY 134 NONMAJOR CAPITAL PROJECTS FUNDS Capital projects funds are established to account for the resources expended to acquire assets of a relatively permanent nature. (Special revenue and enterprise fund resources are not included in this category.) These funds evolve from the needs for special accounting for bond proceeds, grants and contribution for the acquisition of capital assets. Park Improvements - This fund was established to record construction and improvement costs for park facilities. MSA Construction - accounts for the accumulation of resources for future street improvement capital outlay. Capital Improvement - accounts for the accumulation of resources for future building improvement capital outlay. 135 City of Hopkins, Minnesota Nonmajor Capital Projects Funds Combining Balance Sheet December 31, 2023 412413416 MSA ParkConstructionCapital ImprovementsFundImprovementTotal Assets Cash and temporary investments$ 969,256 $ 1,076,709 $ 11,187$ 2,057,152 Accounts receivable 75,550 - 90,562 166,112 Total Assets$ 1,044,806 $ 1,076,709 $ 101,749$ 2,223,264 Fund Balances Restricted 526,100 - - 526,100 Assigned 518,706 1,076,709 101,749 1,697,164 Total Fund Balances 1,044,806 1,076,709 101,749 2,223,264 Total Liabilities and Fund Balances$ 1,044,806 $ 1,076,709 $ 101,749$ 2,223,264 136 City of Hopkins, Minnesota Nonmajor Capital Projects Funds Combining Statement of Revenues, Expenditures and Changes in Fund Balances For the Year Ended December 31, 2023 412413416 MSA ParkConstructionCapital ImprovementsFundImprovementTotal Revenues Franchise fees$ 299,803 $ -$ 360,125 $ 659,928 Investment earnings - 23,943 - 23,943 Miscellaneous 25,000 - - 25,000 Total Revenues 324,803 23,943 360,125 708,871 Expenditures Capital outlay Public works - 5,001 (120) 4,881 Culture and recreation 82,653 - - 82,653 Total Expenditures 82,653 5,001 (120) 87,534 Excess (Deficiency) of Revenues Over (Under) Expenditures 242,150 18,942 360,245 621,337 Other Financing Sources (Uses) Transfers out (110,000) - (360,000) (470,000) Net Change in Fund Balances 132,150 18,942 245 151,337 Fund Balances, January 1 912,656 1,057,767 101,504 2,071,927 Fund Balances, December 31$ 1,044,806 $ 1,076,709 $ 101,749 $ 2,223,264 137 City of Hopkins, Minnesota Debt Service Funds Combining Balance Sheet (Continued on the Following Pages) December 31, 2023 54454654754:53555455555655755855955:561 2005B G.O.2009B G.O.2009B G.O.2010B2012 G.O.2014A G.O.2014B G.O.2015A G.O.2015B G.O.2015C G.O.2015D G.O.2016A G.O.2016B G.O. TIF RefundingTaxable HousingTaxable HousingG.O. RefundingImprovementImprovementRefundingSROPTax AbatementTax IncrementTax IncrementImprovementTax Abatement BondsBonds (1999A)Bonds (1999B)BondsBondsBondsBondsBondsBondsRefunding BondsRefunding BondsBondsBonds Assets Cash and temporary investments$ -$ 25,097$ -$ -$ 14,301$ 186,901$ 22,623$ 331,840$ 73,466$ 315,162$ 484,030$ 602,278$ 153,671 Receivables Special assessments - - - - - 25,050 - 12,882 - - - 287,763 - Total Assets$ -$ 25,097$ -$ -$ 14,301$ 211,951$ 22,623$ 344,722$ 73,466$ 315,162$ 484,030$ 890,041$ 153,671 Liabilities Due to other funds$ -$ -$ -$ -$ 14,301$ -$ 22,623$ -$ -$ -$ -$ -$ - Deferred Inflows of Resources Unavailable revenues - special assessments - - - - - 25,050 - 12,882 - - - 287,681 - Fund Balances Restricted for debt service - 25,097 - - - 186,901 - 331,840 73,466 315,162 484,030 602,360 153,671 Total Liabilities, Deferred Inflows of Resources and Fund Balances$ -$ 25,097$ -$ -$ 14,301$ 211,951$ 22,623$ 344,722$ 73,466$ 315,162$ 484,030$ 890,041$ 153,671 138 56256356456556756856956:571572573574575576577 2016D G.O.2017A G.O.2017B G.O.2018A G.O.2019A G.O.2019B G.O.2020A G.O.2020A G.O.2020B G.O.2021A G.O.2022A G.O.2022A G.O.2023A G.O.2023A G.O. 2016C G.O.Tax IncrementSROPTax AbatementImprovementImprovementRefundingImprovementEquipmentRefundingImprovementImprovementEquipmentImprovementEquipment BondsRefunding BondsBondsBondsBondsBondsBondsBondsBondsBondsBondsBondsCertificateBondsCertificateTotal $ 248,634$ 307,191$ 822,301$ 269,555$ 820,752$ 147,792$ 48,034$ 818,379$ 300,222$ 521,877$ 401,400$ 523,233$ 83,735$ 306,069$ 6,472$ 7,835,015 - - 329,124 - 357,709 564,177 72,388 1,370,768 - 219,947 - 187,393 - 667,081 - 4,094,282 $ 248,634$ 307,191$ 1,151,425$ 269,555$ 1,178,461$ 711,969$ 120,422$ 2,189,147$ 300,222$ 741,824$ 401,400$ 710,626$ 83,735$ 973,150$ 6,472$ 11,929,297 $ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 36,924 - - 329,115 - 357,061 564,177 72,388 1,369,624 - 219,510 - 187,466 - 667,081 - 4,092,035 248,634 307,191 822,310 269,555 821,400 147,792 48,034 819,523 300,222 522,314 401,400 523,160 83,735 306,069 6,472 7,800,338 $ 248,634$ 307,191$ 1,151,425$ 269,555$ 1,178,461$ 711,969$ 120,422$ 2,189,147$ 300,222$ 741,824$ 401,400$ 710,626$ 83,735$ 973,150$ 6,472$ 11,929,297 139 City of Hopkins, Minnesota Debt Service Funds Combining Schedule of Revenues, Expenditures and Changes in Fund Balances (Continued on the following Pages) For the Year Ended December 31, 2023 54454654754:53555455555655755855955:561 2005B G.O.2009B G.O.2009B G.O.2010B2012 G.O.2014A G.O.2014B G.O.2015A G.O.2015B G.O.2015C G.O.2015D G.O.2016A G.O.2016B G.O. TIF RefundingTaxable HousingTaxable HousingG.O. RefundingImprovementImprovementRefundingSROPTax AbatementTax IncrementTax IncrementImprovementTax Abatement BondsBonds (1999A)Bonds (1999B)BondsBondsBondsBondsBondsBondsRefunding BondsRefunding BondsBondsBonds Revenues Property taxes$ -$ -$ -$ -$ -$ 100,000$ -$ 255,000$ 125,000$ -$ -$ 102,000$ 37,411 Special assessments 293 1,388 1,218 - - 10,099 - 7,398 - - - 61,436 - Investment earnings 4 470 15 3,486 1,220 3,560 4,139 6,632 1,568 5,946 9,142 11,483 2,913 Total Revenues 297 1,858 1,233 3,486 1,220 113,659 4,139 269,030 126,568 5,946 9,142 174,919 40,324 Expenditures Debt service Principal - - - 185,000 185,000 120,000 770,000 265,000 130,000 300,000 455,000 275,000 105,000 Interest and other charges - - - 6,035 3,017 31,796 10,052 61,977 59,825 64,052 113,652 62,077 22,967 Total Expenditures - - - 191,035 188,017 151,796 780,052 326,977 189,825 364,052 568,652 337,077 127,967 Excess (Deficiency) of Revenues Over (Under) Expenditures 297 1,858 1,233 (187,549) (186,797) (38,137) (775,913) (57,947) (63,257) (358,106) (559,510) (162,158) (87,643) Other Financing Sources Transfers in - - - 188,000 14,301 49,934 167,623 68,412 63,750 340,000 529,300 154,666 100,000 Premium on bonds issued - - - - - - - - - - - - - Bonds issued - - - - - - - - - - - - - Transfers out (297) - (1,233) (188,429) - - - - - - - - - Total Other Financing Sources (Uses) (297) - (1,233) (429) 14,301 49,934 167,623 68,412 63,750 340,000 529,300 154,666 100,000 Net Change in Fund Balances - 1,858 - (187,978) (172,496) 11,797 (608,290) 10,465 493 (18,106) (30,210) (7,492) 12,357 Fund Balances, January 1 - 23,239 - 187,978 172,496 175,104 608,290 321,375 72,973 333,268 514,240 609,852 141,314 Fund Balances, December 31$ -$ 25,097$ -$ -$ -$ 186,901$ -$ 331,840$ 73,466$ 315,162$ 484,030$ 602,360$ 153,671 140 56256356456556756856956:571572573574575576577 2016D G.O.2017A G.O.2017B G.O.2018A G.O.2019A G.O.2019B G.O.2020A G.O.2020A G.O.2020B G.O.2021A G.O.2022A G.O.2022A G.O.2023A G.O.2023A G.O. 2016C G.O.Tax IncrementSROPTax AbatementImprovementImprovementRefundingImprovementEquipmentRefundingImprovementImprovementEquipmentImprovementEquipment BondsRefunding BondsBondsBondsBondsBondsBondsBondsBondsBondsBondsBondsCertificateBondsCertificateTotal $ 205,000$ -$ 940,000$ 111,860$ 515,535$ 315,000$ 118,300$ -$ 194,993$ 322,537$ 212,717$ 236,175$ 101,218$ -$ -$ 3,892,746 - - 65,589 - 76,131 79,689 47,946 206,491 - 81,380 - 27,000 - 189,299 - 855,357 5,186 5,746 12,254 4,866 10,105 4,878 740 195,917 4,741 9,869 200,450 317,201 - 219,784 - 1,042,315 210,186 5,746 1,017,843 116,726 601,771 399,567 166,986 402,408 199,734 413,786 413,167 580,376 101,218 409,083 - 5,790,418 215,000 290,000 705,000 100,000 420,000 625,000 180,000 150,000 25,000 305,000 - - - - - 5,805,000 16,040 52,027 327,327 49,090 173,702 389,031 29,140 78,638 9,272 54,572 64,608 101,049 44,105 68,232 3,947 1,896,230 231,040 342,027 1,032,327 149,090 593,702 1,014,031 209,140 228,638 34,272 359,572 64,608 101,049 44,105 68,232 3,947 7,701,230 (20,854) (336,281) (14,484) (32,364) 8,069 (614,464) (42,154) 173,770 165,462 54,214 348,559 479,327 57,113 340,851 (3,947) (1,910,812) - 326,000 - - - 360,000 80,794 - - - - - - - - 2,442,780 - - - - - - - - - - - - - 7,661 419 8,080 - - - - - - - - - - - - - 3,775,000 210,000 3,985,000 - - - - - - - - - - - - - (3,817,443) (200,000) (4,207,402) - 326,000 - - - 360,000 80,794 - - - - - - (34,782) 10,419 2,228,458 (20,854) (10,281) (14,484) (32,364) 8,069 (254,464) 38,640 173,770 165,462 54,214 348,559 479,327 57,113 306,069 6,472 317,646 269,488 317,472 836,794 301,919 813,331 402,256 9,394 645,753 134,760 468,100 52,841 43,833 26,622 - - 7,482,692 $ 248,634$ 307,191$ 822,310$ 269,555$ 821,400$ 147,792$ 48,034$ 819,523$ 300,222$ 522,314$ 401,400$ 523,160$ 83,735$ 306,069$ 6,472$ 7,800,338 141 THIS PAGE IS LEFT BLANK INTENTIONALLY 142 City of Hopkins, Minnesota General Fund Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual (Continued on the Following Pages) For the Year Ended December 31, 2023 (With Comparative Actual Amounts for the Year Ended December 31, 2022) 2023 2022 Budgeted Amounts ActualVariance withActual OriginalFinalAmountsFinal BudgetAmounts Revenues Taxes Property taxes$ 14,020,781$ 14,020,781$ 13,628,350$ (392,431)$ 12,663,858 Franchise taxes 296,200 296,200 304,979 8,779 303,957 Total taxes 14,316,981 14,316,981 13,933,329 (383,652) 12,967,815 Licenses and permits Licenses 118,515 118,515 124,121 5,606 128,161 Permits 565,000 565,000 1,619,974 1,054,974 1,382,580 Total licenses and permits 683,515 683,515 1,744,095 1,060,580 1,510,741 Intergovernmental Federal Other - - 42,000 42,000 62,000 State Local government aid 925,794 925,794 925,794 - 880,066 Police and fire aid 490,000 490,000 536,079 46,079 477,506 Municipal state aid 185,000 185,000 199,648 14,648 206,824 Other 30,000 30,000 181,177 151,177 31,346 County - - - - 44,660 Total intergovernmental 1,630,794 1,630,794 1,884,698 253,904 1,702,402 Charges for services General government 19,950 19,950 63,997 44,047 291,623 Public safety 187,500 187,500 233,127 45,627 195,450 Highways and streets 18,350 18,350 9,538 (8,812) 11,392 Culture and recreation 102,300 102,300 157,967 55,667 116,710 Total charges for services 328,100 328,100 464,629 136,529 615,175 Fines and forfeitures 192,500 192,500 100,924 (91,576) 110,300 Investment earnings 20,000 20,000 159,376 139,376 106,508 Miscellaneous Refunds and reimbursements - - 9,673 9,673 - Contributions and donations 6,000 6,000 2,958 (3,042) 8,013 Other 10,550 10,550 35,715 25,165 60,326 Total miscellaneous 16,550 16,550 48,346 31,796 68,339 Total Revenues 17,188,440 17,188,440 18,335,397 1,146,957 17,081,280 Expenditures Current General government Mayor and city council Personal services$ 46,746$ 46,746$ 46,472$ 274$ 43,619 Supplies 3,025 3,025 1,735 1,290 6,268 Other services and charges 56,079 56,079 61,414 (5,335) 51,509 Total mayor and city council 105,850 105,850 109,621 (3,771) 101,396 Management and administration Personal services 395,771 395,771 501,739 (105,968) 413,459 Supplies 9,300 9,300 11,399 (2,099) 18,890 Other services and charges 135,268 135,268 113,386 21,882 89,843 Total management and administration 540,339 540,339 626,524 (86,185) 522,192 143 City of Hopkins, Minnesota General Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual (Continued) For the Year Ended December 31, 2023 (With Comparative Actual Amounts for the Year Ended December 31, 2022) 2023 2022 Budgeted Amounts ActualVariance withActual OriginalFinalAmountsFinal BudgetAmounts Expenditures (Continued) Current expenditures (continued) Finance Personal services$ 335,679$ 335,679$ 330,039$ 5,640 $ 298,879 Supplies 7,550 7,550 7,597 (47) 9,557 Other services and charges 145,566 145,566 213,653 (68,087) 199,036 Total finance 488,795 488,795 551,289 (62,494) 507,472 City clerk Personal services 93,028 93,028 139,230 (46,202) 77,561 Supplies 200 200 727 (527) 893 Other services and charges 22,357 22,357 18,719 3,638 18,386 Total city clerk 115,585 115,585 158,676 (43,091) 96,840 Municipal building Personal services 116,636 116,636 114,928 1,708 94,932 Supplies 17,000 17,000 11,750 5,250 9,420 Other services and charges 247,195 247,195 363,299 (116,104) 290,797 Total municipal building 380,831 380,831 489,977 (109,146) 395,149 Planning and zoning Personal services 151,003 151,003 153,918 (2,915) 177,780 Supplies 2,000 2,000 2,893 (893) 1,948 Other services and charges 17,839 17,839 8,764 9,075 40,846 Total planning and zoning 170,842 170,842 165,575 5,267 220,574 Elections Personal services 102,966 102,966 61,542 41,424 73,280 Supplies 12,500 12,500 5,017 7,483 6,642 Other services and charges 14,415 14,415 9,240 5,175 17,898 Total elections 129,881 129,881 75,799 54,082 97,820 Assessing Personal services 63,079 63,079 (18,586) 81,665 13,014 Supplies 700 700 421 279 761 Other services and charges 192,310 192,310 185,836 6,474 175,953 Total assessing 256,089 256,089 167,671 88,418 189,728 Legal 225,000 225,000 322,549 (97,549) 320,759 General governmental buildings Personal services - - 2,071 (2,071) 549 Other services and charges 69,200 69,200 15,275 53,925 10,680 Total general governmental buildings 69,200 69,200 17,346 51,854 11,229 144 City of Hopkins, Minnesota General Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual (Continued) For the Year Ended December 31, 2023 (With Comparative Actual Amounts for the Year Ended December 31, 2022) 2023 2022 Budgeted Amounts ActualVariance withActual OriginalFinalAmountsFinal BudgetAmounts Expenditures (Continued) Current expenditures (continued) General government (continued) Information services Personal services$ 311,877$ 311,877$ 344,514$ (32,637)$ 299,300 Supplies 13,350 13,350 11,352 1,998 11,645 Other services and charges 38,463 38,463 21,265 17,198 23,811 Total information services 363,690 363,690 377,131 (13,441) 334,756 Total general government 2,846,102 2,846,102 3,062,158 (216,056) 2,797,915 Public safety Police administration Personal services 1,057,107 1,057,107 1,052,766 4,341 988,814 Supplies 25,236 25,236 30,754 (5,518) 19,528 Other services and charges 223,865 223,865 244,680 (20,815) 220,922 Total police administration 1,306,208 1,306,208 1,328,200 (21,992) 1,229,264 Police services Personal services 4,714,103 4,714,103 4,482,270 231,833 4,291,322 Supplies 166,393 166,393 207,279 (40,886) 196,137 Other services and charges 428,951 428,951 493,118 (64,167) 398,099 Total police services 5,309,447 5,309,447 5,182,667 126,780 4,885,558 Police building Personal services 143,407 143,407 133,211 10,196 129,237 Supplies 7,196 7,196 5,834 1,362 10,181 Other services and charges 44,761 44,761 45,597 (836) 43,693 Total police building 195,364 195,364 184,642 10,722 183,111 System management Supplies 5,070 5,070 7,212 (2,142) 5,749 Other services and charges 142,679 142,679 171,789 (29,110) 98,153 Total system management 147,749 147,749 179,001 (31,252) 103,902 Fire Personal services 846,129 846,129 1,286,050 (439,921) 914,042 Supplies 105,260 105,260 115,712 (10,452) 117,960 Other services and charges 682,002 682,002 918,496 (236,494) 732,497 Total fire 1,633,391 1,633,391 2,320,258 (686,867) 1,764,499 Building Inspection Personal services 873,725 873,725 672,381 201,344 690,456 Supplies 11,385 11,385 6,690 4,695 3,593 Other services and charges 171,708 171,708 146,135 25,573 134,106 Total building inspection 1,056,818 1,056,818 825,206 231,612 828,155 Total public safety 9,648,977 9,648,977 10,019,974 (370,997) 8,994,489 145 City of Hopkins, Minnesota General Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual (Continued) For the Year Ended December 31, 2023 (With Comparative Actual Amounts for the Year Ended December 31, 2022) 2023 2022 Budgeted Amounts ActualVariance withActual OriginalFinalAmountsFinal BudgetAmounts Expenditures (Continued) Current expenditures (continued) Public works Streets and highways Personal services$ 686,056$ 686,056$ 709,174$ (23,118)$ 673,745 Supplies 220,075 220,075 309,068 (88,993) 297,386 Other services and charges 577,750 577,750 643,605 (65,855) 589,593 Total streets and highways 1,483,881 1,483,881 1,661,847 (177,966) 1,560,724 Engineering Personal services 51,892 51,892 (132,282) 184,174 49,514 Supplies 3,400 3,400 2,424 976 2,491 Other services and charges 48,421 48,421 49,168 (747) 38,300 Total engineering 103,713 103,713 (80,690) 184,403 90,305 Snow and ice removal Personal services 170,679 170,679 209,287 (38,608) 173,466 Supplies 74,675 74,675 48,005 26,670 80,196 Other services and charges 21,100 21,100 34,304 (13,204) 15,566 Total snow and ice removal 266,454 266,454 291,596 (25,142) 269,228 Public works administration Personal services 168,449 168,449 (27,629) 196,078 147,133 Supplies 3,500 3,500 4,184 (684) 5,219 Other services and charges 21,561 21,561 13,765 7,796 31,863 Total public works administration 193,510 193,510 (9,680) 203,190 184,215 Total public works 2,047,558 2,047,558 1,863,073 184,485 2,104,472 Parks and recreation Parks Personal services 590,909 590,909 578,307 12,602 553,365 Supplies 156,300 156,300 183,455 (27,155) 156,117 Other services and charges 368,693 368,693 385,936 (17,243) 367,613 Total parks 1,115,902 1,115,902 1,147,698 (31,796) 1,077,095 Forestry Personal services 184,589 184,589 389,762 (205,173) 264,891 Supplies 29,050 29,050 26,030 3,020 20,849 Other services and charges 129,929 129,929 253,618 (123,689) 185,029 Total forestry 343,568 343,568 669,410 (325,842) 470,769 Recreation facilities Personal services 335,603 335,603 353,043 5,312 344,967 Supplies 22,274 22,274 16,962 5,312 17,293 Other services and charges 435,308 435,308 425,521 9,787 354,486 Total recreation facilities 793,185 793,185 795,526 20,411 716,746 Total culture and recreation 2,252,655 2,252,655 2,612,634 (337,227) 2,264,610 146 City of Hopkins, Minnesota General Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual (Continued) For the Year Ended December 31, 2023 (With Comparative Actual Amounts for the Year Ended December 31, 2022) 2023 2022 Budgeted Amounts ActualVariance withActual OriginalFinalAmountsFinal BudgetAmounts Expenditures (Continued) Current expenditures (continued) Community development Community development Personal services$ 119,142$ 119,142$ 70,573$ 48,569$ 110,688 Supplies 1,000 1,000 1,899 (899) 1,008 Other services and charges 6,706 6,706 4,757 1,949 4,481 Total community development 126,848 126,848 77,229 49,619 116,177 Total current 16,922,140 16,922,140 17,635,068 (690,176) 16,277,663 Capital outlay General government 116,000 116,000 130,491 (14,491) 118,452 Public safety 5,300 5,300 18,310 (13,010) 8,058 Public works 125,000 125,000 47,322 77,678 156,486 Parks and recreation - - - - 1,380 Total capital outlay 246,300 246,300 196,123 50,177 284,376 Total Expenditures 17,168,440 17,168,440 17,831,191 (639,999) 16,562,039 Excess (Deficiency) of Revenues Over (Under) Expenditures 20,000 20,000 504,206 484,206 519,241 Other Financing Sources (Uses) Transfers out (20,000) (20,000) (56,924) (36,924) (20,000) Net Change in Fund Balances - - 447,282 447,282 499,241 Fund Balances, January 1 9,013,101 9,013,101 9,013,101 - 8,513,860 Fund Balances, December 31$ 9,013,101$ 9,013,101$ 9,460,383$ 447,282$ 9,013,101 147 THIS PAGE IS LEFT BLANK INTENTIONALLY 148 NONMAJOR PROPRIETARY FUNDS Enterprise Funds are established to account for the financing of self-supporting activities of governmental units, which render services to the general public on a user charge basis. Records are maintained on the accrual basis of accounting. Refuse Utility Fund This fund accounts for the operations of the City owned refuse service. Housing Authority Fund This fund accounts for the operations of the City owned federally subsidized apartment building. 149 City of Hopkins, Minnesota Statement of Net Position Nonmajor Enterprise Funds December 31, 2023 828861 Housing RefuseAuthorityTotals Assets Current Assets Cash and temporary investments$ 1,123,475 $ 726,781 $ 1,850,256 Accounts receivable 74,851 17,233 92,084 Due from other governments - 186,732 186,732 Prepaid items - 11,937 11,937 Total Current Assets 1,198,326 942,683 2,141,009 Noncurrent Assets Capital assets Land - 208,252 208,252 Buildings 309,227 5,804,172 6,113,399 Machinery and equipment 1,136,093 59,907 1,196,000 Less accumulated depreciation (853,019) (4,764,439) (5,617,458) Net Capital Assets 592,301 1,307,892 1,900,193 Total Noncurrent Assets 592,301 1,307,892 1,900,193 Total Assets 1,790,627 2,250,575 4,041,202 Deferred Outflows of Resources Deferred pension resources 44,218 - 44,218 Deferred other postemployment benefits 18,661 13,697 32,358 Total Deferred Outflows of Resources 62,879 13,697 76,576 Liabilities Current Liabilities Accounts payable 93,534 47,800 141,334 Accrued salaries payable 17,889 27,718 45,607 Due to other governments 7,094 - 7,094 Unearned revenue - 156,183 156,183 Other postemployment benefits 10,603 7,783 18,386 Compensated absences payable - current 14,302 6,368 20,670 Total Current Liabilities 143,422 245,852 389,274 Noncurrent Liabilities Other postemployment benefits 34,271 25,155 59,426 Compensated absences payable 3,576 1,592 5,168 Net pension liability 175,216 - 175,216 Total Noncurrent Liabilities 213,063 26,747 239,810 Total Liabilities 356,485 272,599 629,084 Deferred Inflows of Resources Deferred pension resources 55,069 - 55,069 Deferred other post employment benefits 5,479 4,021 9,500 Total Deferred Inflows of Resources 60,548 4,021 64,569 Net Position Investment in capital assets 592,301 1,307,892 1,900,193 Unrestricted 844,172 679,760 1,523,932 Total Net Position$ 1,436,473 $ 1,987,652 $ 3,424,125 The notes to the financial statements are an integral part of this statement. 150 City of Hopkins, Minnesota Statement of Revenues, Expenses and Changes in Net Position Nonmajor Enterprise Funds For the Year Ended December 31, 2023 828861 Housing RefuseAuthorityTotals Operating Revenues Charges for services$ 1,200,980 $ 282,541 $ 1,483,521 Operating Expenses Personal services 295,146 242,562 537,708 Contracted services 352,327 - 352,327 Supplies 100,854 - 100,854 Professional services 413,719 395,526 809,245 Insurance 16,766 - 16,766 Repairs and maintenance 447 - 447 Depreciation 81,572 187,615 269,187 Total Operating Expenses 1,260,831 825,703 2,086,534 Operating Loss (59,851) (543,162) (603,013) Nonoperating Revenues (Expenses) Investment earnings 23,290 - 23,290 Miscellaneous 21 - 21 Intergovernmental grants 37,815 709,787 747,602 Gain on sale of capital assets 11,412 20,365 31,777 Total Nonoperating Revenues (Expenses) 72,538 730,152 802,690 Income Before Transfers 12,687 186,990 199,677 Transfers Out (25,000) - (25,000) Change in Net Position (12,313) 186,990 174,677 Net Position, January 1 1,448,786 1,800,662 3,249,448 Net Position, December 31$ 1,436,473 $ 1,987,652 $ 3,424,125 The notes to the financial statements are an integral part of this statement. 151 City of Hopkins, Minnesota Statement of Cash Flows (Continued on the Following Page) Nonmajor Enterprise Funds For the Year Ended December 31, 2023 828861 Housing RefuseAuthorityTotals Cash Flows from Operating Activities Receipts from customers and users$ 1,176,969$ 414,044$ 1,591,013 Payments to suppliers (872,362) (421,148) (1,293,510) Payments to employees (384,899) (266,025) (650,924) Net Cash Used by Operating Activities (80,292) (273,129) (353,421) Cash Flows from Noncapital Financing Activities Payments on interfund balances - (200,000) (200,000) Intergovernmental receipts 37,815 818,660 856,475 Transfers to other funds (25,000) - (25,000) Net Cash Provided by Noncapital Financing Activities 12,815 618,660 631,475 Cash Flows from Capital Financing Activities Acquisition of capital assets (117,485) (26,477) (143,962) Proceeds from sale of capital assets 11,412 20,365 31,777 Net Cash Provided (Used) by Capital Financing Activities (106,073) (6,112) (112,185) Cash Flows from Investing Activities Interest received (paid) on investments 23,291 - 23,291 Net Increase (Decrease) in Cash and Cash Equivalents (150,259) 339,419 189,160 Cash and Cash Equivalents, January 1 1,273,734 387,362 1,661,096 Cash and Cash Equivalents, December 31$ 1,123,475$ 726,781$ 1,850,256 The notes to the financial statements are an integral part of this statement. 152 City of Hopkins, Minnesota Statement of Cash Flows (Continued) Enterprise Funds For the Year Ended December 31, 2023 828861 RefuseHousing UtilityAuthorityTotals Reconciliation of Operating Loss to Net Cash Used by Operating Activities Operating loss$ (59,851)$ (543,162)$ (603,013) Adjustments to reconcile operating loss to net cash used by operating activities Depreciation 81,572 187,615 269,187 Other income related to operations 21 - 21 (Increase) decrease in assets Receivables Accounts (24,032) (24,680) (48,712) Prepaids - 1,211 1,211 Increase (decrease) in deferred outflows of resources Deferred pension resources 4,073 - 4,073 Deferred other post employment benefit resources 1,604 (1,535) 69 Increase (decrease) in liabilities Accounts payable 23,586 (26,833) (3,247) Accrued salaries payable 586 (25,781) (25,195) Due to other governments (11,835) - (11,835) Unearned revenue - 156,183 156,183 Other postemployment benefits (4,391) 3,371 (1,020) Compensated absences payable 1,482 (3,254) (1,772) Net pension liability (138,747) - (138,747) Increase in deferred inflows of resources Deferred pension resources 40,638 - 40,638 Deferred other post employment benefit resources 5,002 3,736 8,738 Net Cash Used by Operating Activities$ (80,292)$ (273,129)$ (353,421) The notes to the financial statements are an integral part of this statement. 153 THIS PAGE IS LEFT BLANK INTENTIONALLY 154 INTERNAL SERVICE FUNDS Internal Service Funds are used to account for the financing of goods or services provided by one department to other departments of the government, on a cost reimbursement basis. Revenues and expenses are recognized on the accrual basis. Revenues are recognized in the accounting period in which they are earned and become objectively measurable; expenses are recognized in the period incurred, if objectively measurable. Equipment Replacement Fund This fund accounts for the acquisition of machinery and equipment. User charges are billed to the various City departments. Insurance Risk Fund This fund accounts for the dividends and deductibles relating to property and casualty insurance coverage. Deductibles are paid from past dividends. Users are charged only if the fund has a shortfall. Employee Benefits Fund This fund accounts for accrued employee benefits within the governmental funds. User charges are billed to the various departments. 155 City of Hopkins, Minnesota Internal Service Funds Combining Schedule of Net Position December 31, 2023 713731741 EquipmentEmployeeInsurance ReplacementBenefitsRiskTotals Assets Current Assets Cash and temporary investments$ 1,491,321 $ 1,371,446 $ 286,283 $ 3,149,050 Receivables Accounts 21,263 - - 21,263 Total Current Assets 1,512,584 1,371,446 286,283 3,170,313 Noncurrent Assets Capital assets Construction in progress 22,057 - - 22,057 Machinery and equipment 11,026,334 - - 11,026,334 Less accumulated depreciation (6,681,286) - - (6,681,286) Net Capital Assets 4,367,105 - - 4,367,105 Total Assets 5,879,689 1,371,446 286,283 7,537,418 Liabilities Current Liabilities Accounts payable 66,930 - - 66,930 Compensated absences payable - current - 1,165,887 - 1,165,887 Total Liabilities 66,930 1,165,887 - 1,232,817 Net Position Investment in capital assets 4,367,105 - - 4,367,105 Unrestricted 1,445,654 205,559 286,283 1,937,496 Total Net Position$ 5,812,759 $ 205,559 $ 286,283 $ 6,304,601 156 City of Hopkins, Minnesota Internal Service Funds Combining Schedule of Revenues, Expenses and Changes in Net Position For the Year Ended December 31, 2023 713731741 EquipmentEmployeeInsurance ReplacementBenefitsRiskTotals Operating Revenues Charges for services$ 714,679 $ -$ -$ 714,679 Operating Expenses Personal services 9,163 - 17,960 27,123 Capital 439,623 - - 439,623 Depreciation 799,460 - - 799,460 Total Operating Expenses 1,248,246 - 17,960 1,266,206 Operating Loss (533,567) - (17,960) (551,527) Nonoperating Revenues (Expenses) Taxes Property taxes 250,000 - - 250,000 Intergovernmental 3,600 - - 3,600 Investment earnings (loss) - 23,391 4,975 28,366 Miscellaneous 165 - 52,741 52,906 Gain on sale of capital assets 85,778 - - 85,778 Total Nonoperating Revenues (Expenses) 339,543 23,391 57,716 420,650 Income (Loss) Before Transfers (194,024) 23,391 39,756 (130,877) Transfers In 200,000 - - 200,000 Change in Net Position 5,976 23,391 39,756 69,123 Net Position, January 1 5,806,783 182,168 246,527 6,235,478 Net Position, December 31$ 5,812,759 $ 205,559 $ 286,283 $ 6,304,601 157 City of Hopkins, Minnesota Internal Service Funds Combining Schedule of Cash Flows For the Year Ended December 31, 2023 713731741 EquipmentEmployeeInsurance ReplacementBenefitsRiskTotals Cash Flows from Operating Activities Receipts from customers and users$ - $ -$ 71,468$ 71,468 Payment for interfund services 693,581 - - 693,581 Payments to suppliers (375,864) - - (375,864) Payments to employees (9,163) 133,158 (55,038) 68,957 Net Cash Provided (Used) by Operating Activities 308,554 133,158 16,430 458,142 Cash Flows from Noncapital Financing Activities Property taxes received 250,000 - - 250,000 Intergovernmental receipts 3,600 - - 3,600 Transfers from other funds 200,000 - - 200,000 Net Cash Provided (Used) by Noncapital Financing Activities 453,600 - - 453,600 Cash Flows from Capital Financing Activities Acquisition of capital assets (1,035,840) - - (1,035,840) Proceeds from sale of capital assets 85,778 - - 85,778 Net Cash Used by Capital Financing Activities (950,062) - - (950,062) Cash Flows from Investing Activities Interest received (paid) on investments - 23,391 4,975 28,366 Net Increase (Decrease) in Cash and Cash Equivalents (187,908) 156,549 21,405 (9,954) Cash and Cash Equivalents, January 1 1,679,229 1,214,897 264,878 3,159,004 Cash and Cash Equivalents, December 31$ 1,491,321$ 1,371,446$ 286,283$ 3,149,050 158 City of Hopkins, Minnesota Internal Service Funds Combining Schedule of Cash Flows (Continued) For the Year Ended December 31, 2023 Business-type Activities - Enterprise Funds 713731741 EquipmentEmployeeInsurance ReplacementBenefitsRiskTotals Reconciliation of Operating Loss to Net Cash Provided (Used) by Operating Activities Operating income (loss)$ (533,567)$ -$ (17,960)$ (551,527) Adjustments to reconcile operating loss to net cash provided (used) by operating activities Depreciation 799,460 - - 799,460 Other income related to operations 165 - 52,741 52,906 (Increase) decrease in assets Accounts receivable (21,263) - 18,727 (2,536) Prepaids 1,475 - - 1,475 Increase (decrease) in liabilities Accounts payable 62,284 (931) (37,078) 24,275 Compensated absences payable - 134,089 - 134,089 Net Cash Provided (Used) by Operating Activities$ 308,554$ 133,158$ 16,430$ 458,142 159 City of Hopkins, Minnesota Summary Financial Report Revenues and Expenditures For General Operations Governmental Funds For the Years Ended December 31, 2023 and 2022 Percent TotalIncrease (Decrease) 20232022 Revenues Taxes$ 22,990,678$ 22,828,415 0.71% Licenses and permits 1,744,095 1,510,741 15.45 Intergovernmental 4,612,629 2,952,690 56.22 Charges for services 1,324,093 1,581,096 (16.25) Fines and forfeits 100,924 110,300 (8.50) Special assessments 1,176,027 933,901 25.93 Investment earnings 1,783,651 329,445 441.41 Miscellaneous 202,658 483,493 (58.08) Total Revenues$ 33,934,755$ 30,730,081 10.43% Per Capita$ 1,779$ 1,611 10.43% Expenditures Current General government$ 3,422,411 $ 3,031,920 12.88% Public safety 10,377,422 9,048,839 14.68 Public works 2,037,741 2,268,415 (10.17) Parks and recreation 3,744,016 3,489,064 7.31 Urban development and housing 1,579,024 5,103,646 (69.06) Capital outlay General government 130,491 146,323 (10.82) Public safety 66,753 85,562 (21.98) Public works 5,759,497 2,084,951 176.24 Parks and recreation 106,735 245,565 (56.53) Urban development and housing 2,318,845 2,924,910 (20.72) Debt service Principal 5,805,000 5,530,000 4.97 Interest and other charges 1,896,230 2,001,953 (5.28) Total Expenditures$ 37,244,165$ 35,961,148 3.57% Per Capita$ 1,952$ 1,885 3.57% Total Long-term Indebtedness$ 58,795,000$ 60,615,000 (3.00) % Per Capita 3,082 3,177 (3.00) General Fund Balance - December 31$ 9,460,383 $ 9,013,101 4.96% Per Capita 496 472 4.96 160 STATISTICAL SECTION (UNAUDITED) CITY OF HOPKINS HOPKINS, MINNESOTA FOR THE YEAR ENDED DECEMBER 31, 2023 161 THIS PAGE IS LEFT BLANK INTENTIONALLY 162 STATISTICAL SECTION (UNAUDITED) This part of the City of Hopkins understanding what the information in the financial statements, note disclosures, and required supplementary information alth. Financial Trends performance and well-being have changed over time. Revenue Capacity source, the property tax. Debt Capacity These schedules present information to help the reader assess the of out- Demographic and Economic Information These schedules offer demographic and economic indicators to help the reader understand the environment within Operating Information These schedules contain service and infrastructure data to help the reader understand how the information in the Sources: Unless otherwise noted, the information in these schedules is derived from the annual financial reports for the relevant year. 163 City of Hopkins, Minnesota Statistical Section (Unaudited) Net Position by Component Last Ten Fiscal Years (Accrual Basis of Accounting) Fiscal Year 2014201520162017 Governmental Activities $ 31,272,253$ 32,609,356$ 33,833,387$ 32,064,111 Net investment in capital assets 16,967,889 16,967,889 16,967,889 16,967,889 Restricted Unrestricted 1,902,270 (9,447,813) (18,308,556) (17,563,673) Total Governmental Activities Net Position$ 50,142,412$ 40,129,432$ 32,492,720$ 31,468,327 Business-type Activities $ 16,937,928$ 17,893,856$ 21,798,183$ 23,990,746 Net investment in capital assets Unrestricted 1,954,212 1,419,018 435,435 1,433,445 Total Business-type Activities Net Position$ 18,892,140$ 19,312,874$ 22,233,618$ 25,424,191 Primary Government Net investment in capital assets$ 48,210,181$ 50,503,212$ 55,631,570$ 56,054,857 Restricted 16,967,889 16,967,889 16,967,889 16,967,889 Unrestricted 3,856,482 (8,028,795) (17,873,121) (16,130,228) Total Primary Government Net Position$ 69,034,552$ 59,442,306$ 54,726,338$ 56,892,518 The City implemented GASB 68 and GASB 75 in 2015. Years prior to 2015 have not been restated 164 Table 1 Fiscal Year 201820192020202120222023 $ 37,136,053 $ 37,857,254$ 40,389,884$ 40,801,556$ 42,085,537$ 37,145,331 16,547,512 16,056,962 20,092,105 22,955,218 16,293,593 15,545,798 (14,432,266) (14,865,750) (9,862,920) (5,907,384) (1,649,832) 8,629,852 $ 39,251,299$ 39,048,466$ 50,619,069$ 57,849,390$ 56,729,298$ 61,320,981 $ 28,627,563$ 31,184,022$ 27,683,345$ 26,950,711$ 27,274,646 $ 26,094,187 1,733,552 1,863,196 4,083,537 4,765,994 4,327,220 6,264,236 $ 30,361,115$ 33,047,218$ 31,766,882$ 31,716,705$ 31,601,866$ 32,358,423 $ 65,763,616$ 69,041,276$ 68,073,229$ 67,752,267$ 69,360,183$ 63,239,518 16,547,512 16,056,962 20,092,105 22,955,218 16,293,593 15,545,798 (12,698,714) (13,002,554) (5,779,383) (1,141,390) 2,677,388 14,894,088 $ 69,612,414$ 72,095,684$ 82,385,951$ 89,566,095$ 88,331,164$ 93,679,404 165 City of Hopkins, Minnesota Statistical Section (Unaudited) Changes in Net Position (Continued on the Following Pages) Last Ten Fiscal Years (Accrual Basis of Accounting) Fiscal Year 2014201520162017 Expenses Governmental activities General government$ 2,276,155$ 6,656,991$ 10,341,183 $ 6,751,459 Public safety 6,526,230 6,665,974 8,561,759 8,126,086 Health and welfare 171,187 185,248 185,301 179,916 Public works 5,709,009 4,542,014 5,168,939 5,932,978 Urban development and housing 2,247,553 1,249,457 1,398,736 1,354,036 Culture and recreation 1,941,912 2,068,887 2,231,605 2,737,116 Interest on long-term debt 711,697 688,155 952,756 1,335,290 Total Governmental Activities Expenses 19,583,743 22,056,726 28,840,279 26,416,881 Business-type activities Water 1,540,940 1,699,540 1,878,807 1,871,868 Sewer 2,042,106 2,061,180 2,251,291 2,406,027 Storm sewer 508,686 394,707 397,660 460,771 Refuse 834,113 848,685 867,823 874,750 Pavilion/Ice Arena 460,246 462,771 483,035 547,831 Housing and Redevelopment Authority 625,667 610,318 616,653 591,895 Total Business-type Activities Expenses 6,011,758 6,077,201 6,495,269 6,753,142 Total Primary Government Expenses$ 25,595,501 $ 28,133,927 $ 35,335,548 $ 33,170,023 Program Revenues Governmental activities Charges for services General government$ 56,635$ 82,686$ 72,716$ 175,390 Public safety 118,248 79,415 274,661 172,584 Health and welfare 57,235 47,085 58,264 59,645 Public works 96,573 127,221 125,749 125,046 Urban development and housing 242 220,027 190,199 146,491 Culture and recreation 740,147 810,762 770,466 788,549 Operating grants and contributions 2,943,889 4,970,313 4,087,923 8,007,553 Capital grants and contributions 2,728,416 501,029 1,109,278 1,731,738 Total Governmental Activities Program Revenues 6,741,385 6,838,538 6,689,256 11,206,996 Business-type activities Charges for services 1,497,699 1,514,086 1,526,290 1,837,434 Water Sewer 2,025,763 2,172,277 2,215,251 2,698,307 Storm sewer 802,898 805,542 810,142 809,262 906,387 910,672 959,258 956,056 Refuse 31,914 24,876 22,275 37,080 Pavilion/Ice Arena 256,884 277,885 282,125 294,000 Housing and Redevelopment Authority 795,199 622,332 721,677 697,635 Operating grants and contributions Capital grants and contributions - - 702,555 - Total Business-type Activities Program Revenues 6,316,744 6,327,670 7,239,573 7,329,774 Total Primary Government Program Revenues$ 13,058,129 $ 13,166,208 $ 13,928,829 $ 18,536,770 166 Table 2 Fiscal Year 201820192020202120222023 $ 4,361,727$ 5,435,138$ 2,949,580$ 721,904$ 4,226,750$ 5,040,785 7,846,565 9,200,365 8,112,419 7,229,926 9,841,518 11,669,337 196,435 189,917 182,017 37,970 - - 4,562,075 5,175,949 5,554,108 8,435,670 4,149,085 4,495,490 2,015,291 2,385,415 1,959,265 1,965,858 8,036,771 3,908,244 2,352,139 2,431,931 3,281,052 3,023,619 4,183,137 4,308,046 65,784 212,538 1,946,713 1,921,725 1,703,818 1,530,798 21,400,016 25,031,253 23,985,154 23,336,672 32,141,079 30,952,700 1,704,965 2,204,922 1,805,150 2,115,519 2,354,679 2,197,562 2,288,938 2,618,842 2,562,282 2,608,224 2,894,178 2,950,830 461,036 605,214 581,641 577,563 544,962 529,473 910,481 924,090 964,002 1,111,069 1,327,982 1,260,831 689,178 1,081,741 1,038,880 1,138,086 1,096,391 1,061,595 677,169 743,227 642,736 606,643 914,637 825,703 6,731,767 8,178,036 7,594,691 8,157,104 9,132,829 8,825,994 $ 28,131,783$ 33,209,289 $ 31,579,845 $ 31,493,776 $ 41,273,908 $ 39,778,694 $ 43,471$ 207,884$ 152,975$ 363,606$ 2,537,997$ 2,592,754 171,291 912,258 685,188 810,623 174,224 165,122 48,550 220,450 174,717 141,294 - - 165,600 161,687 161,546 399,013 132,884 119,314 961,625 25,264 473,402 535,434 - 123 861,815 1,045,810 564,036 688,346 1,021,994 998,940 11,597,974 2,337,984 5,472,891 846,098 1,536,123 2,873,391 1,630,559 - - 972,490 542,947 1,377,956 15,480,885 4,911,337 7,684,755 4,756,904 5,946,169 8,127,600 1,931,035 1,997,826 1,815,713 2,379,130 2,336,580 2,695,990 2,780,090 2,880,695 2,440,559 3,128,088 3,170,831 3,323,407 806,605 806,193 800,605 802,568 806,213 802,032 954,620 984,085 969,796 975,107 1,182,495 1,200,980 62,161 484,640 316,822 464,169 499,927 510,075 402,899 285,861 244,196 263,898 261,492 282,541 579,401 901,137 360,912 217,609 565,267 844,202 - - - - - - 7,516,811 8,340,437 6,948,603 8,230,569 8,822,805 9,659,227 $ 22,997,696$ 13,251,774 $ 14,633,358 $ 12,987,473 $ 14,768,974 $ 17,786,827 167 City of Hopkins, Minnesota Statistical Section (Unaudited) Changes in Net Position (Continued) Last Ten Fiscal Years (Accrual Basis of Accounting) Fiscal Year 2014201520162017 Net Revenues (Expenses) Governmental activities$ (12,842,358)$ (15,218,188)$ (22,151,023)$ (15,209,885) Business-type activities 304,986 250,469 744,304 576,632 Total Primary Government Net (Expenses) Revenues$ (12,537,372)$ (14,967,719)$ (21,406,719)$ (14,633,253) General Revenues and Other Changes in Net Position Governmental activities Taxes Property taxes$ 11,207,914 $ 11,038,746 $ 11,994,436 $ 12,895,910 Franchise and other taxes - - - - Tax increments 2,700,110 2,920,681 2,959,459 2,146,730 Grants and contributions not restricted to specific programs 20,510 20,510 20,510 20,510 Unrestricted investment earnings 193,546 279,418 124,406 168,437 Gain on sale of capital assets 27,235 27,235 62,013 69,883 Miscellaneous revenues - - - - Transfers 493,093 (864,187) (2,089,914) (3,533,235) Total Governmental Activities 14,642,408 13,422,403 13,070,910 11,768,235 Business-type activities Property taxes - - 63,519 - Grants and contributions not restricted to specific programs - - - - Unrestricted investment earnings (loss) 24,503 64,161 13,231 20,760 Gain on sale of capital assets - 23,477 9,776 (54) Miscellaneous revenues - - - - Transfers (493,093) 864,187 2,089,914 3,533,235 Total Business-type Activities (468,590) 951,825 2,176,440 3,553,941 Total Primary Government$ 14,173,818 $ 14,374,228 $ 15,247,350 $ 15,322,176 Change in Net Position Governmental activities$ 1,800,050$ (1,795,785)$ (9,080,113)$ (3,441,650) Business-type activities (163,604) 1,202,294 2,920,744 4,130,573 Total Primary Government$ 1,636,446$ (593,491)$ (6,159,369)$ 688,923 Note:The City began separately identifying franchise fee revenue in 2019. 168 Table 2 Fiscal Year 201820192020202120222023 $ (5,919,131)$ (20,119,916)$ (16,300,399)$ (18,579,768)$ (26,194,910)$ (22,825,100) 785,044 162,401 (646,088) 73,465 (310,024) 833,233 $ (5,134,087)$ (19,957,515)$ (16,946,487)$ (18,506,303)$ (26,504,934)$ (21,991,867) $ 14,343,939$ 16,937,577 $ 19,934,102 $ 16,768,653 $ 17,536,200 $ 18,630,743 - 1,201,549 1,190,241 1,183,050 1,160,763 1,162,668 2,433,504 3,209,850 3,812,055 4,244,240 4,108,301 3,481,962 56,990 629,159 810,638 906,581 1,356,976 1,771,853 225,337 396,461 129,584 26,182 328,320 1,812,017 45,002 1,162 131,004 46,020 112,496 85,778 - - 34,990 40,079 - - (4,218,053) (2,458,675) 1,828,388 471,762 471,762 471,762 12,886,719 19,917,083 27,871,002 23,686,567 25,074,818 27,416,783 81 40,054 288,525 340,249 417,999 340,000 - 2,648 2,595 646 250,000 - 13,153 17,925 10,174 2,660 (1,052) 23,309 17,210 4,400 8,710 - - 31,777 - - 5,684 4,565 - - 4,218,053 2,458,675 (949,936) (471,762) (471,762) (471,762) 4,248,497 2,523,702 (634,248) (123,642) 195,185 (76,676) $ 17,135,216$ 22,440,785 $ 27,236,754 $ 23,562,925 $ 25,270,003 $ 27,340,107 $ 6,967,588$ (202,833)$ 11,570,603 $ 5,106,799$ (1,120,092)$ 4,591,683 5,033,541 2,686,103 (1,280,336) (50,177) (114,839) 756,557 $ 12,001,129$ 2,483,270$ 10,290,267 $ 5,056,622$ (1,234,931)$ 5,348,240 169 City of Hopkins, Minnesota Statistical Section (Unaudited) Fund Balances of Governmental Funds Last Ten Fiscal Years Fiscal Year 2014201520162017 General Fund Fund balance Nonspendable$ 213,499$ 227,113$ 87,263 $ 135,373 Restricted - - - - Assigned 339,055 340,189 340,857 245,494 Unassigned 5,184,071 5,439,798 5,437,774 5,471,420 Total General Fund$ 5,736,625$ 6,007,100$ 5,865,894$ 5,852,287 All Other Governmental Funds Fund balance Nonspendable$ 201$ 204$ -$ - Restricted 12,683,242 16,720,476 15,207,736 13,114,006 Committed 4,574,733 4,882,609 5,034,095 5,157,831 Assigned 4,162,299 1,249,239 - 1,655,606 Unassigned (2,029,619) (1,960,918) (2,789,907) (1,536,968) Total All Other Governmental Funds$ 19,390,856$ 20,891,610$ 17,451,924$ 18,390,475 170 Table 3 Fiscal Year 201820192020202120222023 $ 192,368$ 211,100$ 189,994$ 245,213$ 292,322$ 316,170 - - - 33,754 - 13,166 245,494 245,494 245,494 245,494 245,494 245,494 5,179,824 5,627,395 6,922,014 7,989,399 8,475,285 8,885,553 $ 5,617,686$ 6,083,989$ 7,357,502$ 8,513,860$ 9,013,101$ 9,460,383 $ -$ 8,740$ 1,233,628$ 15,433 $ 8,498$ 7,822 13,826,248 14,085,841 1,709,561 17,768,230 12,352,557 11,849,847 3,722,663 4,589,273 4,704,059 3,343,340 3,434,292 5,273,080 - - - 341,514 2,517,487 1,867,053 (3,373,861) (3,123,872) (3,420,274) (1,598,838) (1,412,710) (1,589,528) $ 14,175,050$ 15,559,982$ 4,226,974$ 19,869,679$ 16,900,124$ 17,408,274 171 City of Hopkins, Minnesota Statistical Section (Unaudited) Changes in Fund Balances of Governmental Funds Last Ten Fiscal Years Fiscal Year 2014201520162017 Revenues Taxes General property tax$ 11,212,334$ 11,190,091$ 12,181,695$ 13,089,431 Tax increments 2,700,110 2,920,681 2,959,459 2,146,730 Franchise and other taxes - - - - Licenses and permits 569,585 489,373 686,785 811,826 Intergovernmental 3,272,977 2,234,195 2,698,372 3,743,694 Charges for services 835,960 848,775 1,000,847 1,008,699 Fines and forfeitures 229,807 258,924 223,131 230,804 Special assessments 1,202,401 1,003,444 1,404,258 1,753,923 Investment earnings 172,012 257,543 115,925 157,870 Miscellaneous 1,148,505 1,474,048 1,870,874 2,463,487 Total Revenues 21,343,691 20,677,074 23,141,346 25,406,464 Expenditures Current General government 2,126,004 2,586,582 2,886,837 3,285,079 Public safety 6,154,320 6,253,424 6,718,046 7,154,007 Health and welfare 167,088 176,248 181,666 177,734 Public works 4,495,659 3,180,023 3,797,748 4,546,602 Urban development and housing 2,192,453 1,219,526 1,337,387 1,306,327 Culture and recreation 1,747,614 1,851,741 2,016,229 2,107,616 Capital outlay 2,144,714 8,789,979 7,325,037 11,753,941 Debt service Principal 1,970,000 8,570,000 3,075,000 3,080,000 Interest and other charges 709,367 646,387 855,114 1,050,401 Total Expenditures 21,707,219 33,273,910 28,193,064 34,461,707 Excess (Deficiency) or Revenues Over (Under) Expenditures (363,528) (12,596,836) (5,051,718) (9,055,243) Other Financing Sources (Uses) Bonds issued 1,895,000 18,735,000 8,770,000 13,530,000 Issuance of refunding debt 6,345,000 - 3,540,000 - Premium on debt 214,606 425,129 452,971 1,352,173 Refunded bond payment - (3,927,887) (7,305,660) (3,678,549) Transfers in 9,351,659 8,513,635 8,112,133 12,157,526 Transfers out (8,858,566) (9,377,822) (12,098,618) (15,690,761) Total Other Financing Sources (Uses) 8,947,699 14,368,055 1,470,826 7,670,389 Net Change in Fund Balance$ 8,584,171 $ 1,771,219 $ (3,580,892)$ (1,384,854) Debt Service as a Percentage of Noncapital Expenditures13.70%37.60%18.80%18.20% Note: Capital outlay has been adjusted for items not shown as capital expenditures on the entity wide statements and reclassified to their respective expenditure category. 172 Ubcmf!5 Fiscal Year 201820192020202120222023 $ 14,414,205$ 16,198,293$ 17,615,073$ 17,650,766$ 17,559,351$ 18,346,048 2,433,504 3,209,850 3,812,055 4,244,240 4,108,301 3,481,962 - 1,201,549 1,190,241 1,183,050 1,160,763 1,162,668 702,431 813,964 660,802 786,390 1,510,741 1,744,095 8,466,571 2,967,143 3,532,869 3,197,671 2,952,690 4,612,629 933,517 999,088 1,131,867 1,532,034 1,581,096 1,324,093 190,395 196,519 154,458 129,999 110,300 100,924 1,121,267 1,485,089 1,469,269 972,490 933,901 1,176,027 215,005 386,362 124,848 23,737 329,445 1,783,651 1,260,706 2,134,390 256,452 527,768 483,493 202,658 29,737,601 29,592,247 29,947,934 30,248,145 30,730,081 33,934,755 2,872,325 3,734,294 3,158,192 2,988,920 3,031,920 3,422,411 7,600,081 7,994,658 8,406,864 8,476,240 9,048,839 10,377,422 190,623 185,824 179,037 37,978 - - 3,283,862 3,514,461 4,029,879 3,567,039 2,268,415 2,037,741 2,294,347 2,364,752 3,242,027 3,050,907 5,103,646 1,579,024 2,024,126 2,052,975 1,563,283 2,870,586 3,489,064 3,744,016 19,310,698 12,147,357 3,792,987 1,931,480 5,487,311 8,382,321 3,890,000 6,475,000 4,715,000 8,265,000 5,530,000 5,805,000 1,496,932 1,670,990 2,064,981 1,975,385 2,001,953 1,896,230 42,962,994 40,140,311 31,152,250 33,163,535 35,961,148 37,244,165 (13,225,393) (10,548,064) (1,204,316) (2,915,390) (5,231,067) (3,309,410) 6,715,000 13,565,000 5,280,000 3,720,000 2,985,000 3,985,000 - - - - - - 168,423 1,292,974 556,513 136,611 238,981 8,080 - - - - - - 9,870,518 13,748,936 6,822,304 8,469,208 13,077,311 7,725,182 (8,822,290) (16,207,611) (6,127,906) (7,997,446) (13,540,549) (7,453,420) 7,931,651 12,399,299 6,530,911 4,328,373 2,760,743 4,264,842 $ (5,293,742)$ 1,851,235 $ 5,326,595 $ 1,412,983 $ (2,470,324)$ 955,432 22.80%29.10%24.80%32.80%22.11%24.06% 173 Table 5 City of Hopkins, Minnesota Statistical Section (Unaudited) Assessed Value and Actual Value of Taxable Property Last Ten Fiscal Years (in thousands of dollars) Fiscal YearLess:Total Taxable EndedResidentialApartmentCommercialIndustrialOtherTax-ExemptMarketTotal Direct December 31,PropertyPropertyPropertyPropertyPropertyPropertyValueTax Rate 2014$ 838,714 $ 277,435 $ 419,190 $ 177,413 $ 1,492 $ (179,699) $ 1,534,545 64.290 % 2015 917,367 313,183 430,897 181,538 1,506 (179,699) 1,664,792 62.503 2016 961,676 363,334 439,692 191,925 1,604 (179,699) 1,778,532 65.581 2017 999,228 406,566 530,859 198,797 1,350 (254,549) 1,882,251 64.485 2018 1,004,480 449,375 541,376 181,049 1,429 (254,549) 1,923,160 67.833 2019 1,128,890 562,141 580,479 174,975 1,519 (254,549) 2,193,455 71.697 2020 1,188,831 596,056 603,388 200,628 1,585 (254,549) 2,335,939 70.748 2021 1,224,197 609,086 603,812 209,376 1,383 (254,549) 2,393,305 67.664 2022 1,412,130 654,172 598,850 235,625 1,436 (254,549) 2,647,664 66.840 2023 1,468,377 680,242 350,344 310,171 1,518 (254,549) 2,556,103 62.930 Notes: (1) The direct tax rate is applied to the tax capacity of the property which is calculated by applying a statutory formula to the estimated market value of the property. The tax capacity is then multiplied by the direct tax rate to determine the city taxes payable on a specific parcel. (2) Tax exempt property is revalued on a six-year cycle. All other property is revalued on a three year cycle. 174 Table 6 City of Hopkins, Minnesota Statistical Section (Unaudited) Property Tax Capacity Rates - Direct and Overlapping Governments Last Ten Fiscal Years City Direct RateOverlapping RatesOverlapping Rates GeneralTotal Direct and FiscalBasicObligation DebtTotalSchoolHennepinMetroTotalOverlapping Tax YearRateServiceDirect RateDistrictCountyCouncilOtherOverlappingRate 2014 55.743 8.547 64.290 32.358 49.959 3.335 8.716 94.368158.658% 2015 53.884 8.619 62.503 30.340 46.398 3.006 8.094 87.838150.341 2016 55.365 10.216 65.581 28.514 45.356 2.899 7.864 84.633150.214 2017 54.251 10.234 64.485 25.611 44.087 2.821 7.755 80.274144.759 2018 53.153 14.680 67.833 29.035 42.808 2.630 7.984 82.457150.290 2019 53.153 15.870 69.023 27.022 41.861 2.542 7.172 78.597147.620 2020 53.945 16.803 70.748 27.190 41.084 2.461 6.869 77.604148.352 2021 52.361 15.303 67.664 26.478 38.210 2.268 6.565 73.521141.185 2022 52.040 14.800 66.840 26.783 38.535 2.240 6.590 74.148140.988 2023 50.187 12.743 62.930 25.006 34.542 1.973 5.906 67.427130.357 Source: Hennepin County, Minnesota Taxpayer Services Department Notes: The City's basic rate is determined by the city's annual budget requirements as set by the City Council. Rates for debt service are based on each year's requirements. 175 Table 7 City of Hopkins, Minnesota Statistical Section (Unaudited) Principal Property Taxpayers Current Year and Nine Years Ago 20232014 Percent ofPercent of NetNet Total NetTotal Net TaxTax Tax CapacityTax Capacity TaxpayerCapacityRankCapacityRank BOF II MN Excelsior Crossing$ 1,859,170 15.11$ - - %% Piedmont 9320 Excelsior Blvd 942,430 22.59 - - Doran 810 Apartments 741,513 32.04 - - Hopkins Distribution Co LLC 559,250 41.54 - - Individual 527,375 51.45 - - Southwest Real Estate, Inc. 366,843 61.01 225,403 4 1.09 Greenfield Apartments LP 612,538 71.68 169,138 10 0.82 TKG-Storagemart Partnership 301,450 90.83 - - Duke Realty 302,830 80.83 199,490 6 0.97 SuperValu 297,490 100.82 969,890 2 4.71 Colfin Midwest NNN Investment LLC - - 1,453,160 1 7.06 Ramsgate Apartments LLC - - 233,475 3 1.13 Hopkins Apartments LLC - - - - Hopkins Real Estate - - 210,250 5 1.02 Excelsior Crossings, LLC - - - - Westside Property Owner LLC - - 199,250 7 0.97 Interlachen Oaks - - 196,300 8 0.95 Southwest Real Estate, Inc. - - - - Hines Reit Mpls Ind LLC - - - - City Center Ventures - - 170,310 9 0.83 Total$ 6,510,889 17.90 %$ 4,026,666 19.56 % Total City 2023/2014 tax capacity $ 36,368,067$ 20,585,146 Source: Hennipen County, Minnesota Assessor's Office Notes: Tax capacity is a percentage of total market value. 176 Table 8 City of Hopkins, Minnesota Statistical Section (Unaudited) Property Tax Levies and Collections Last Ten Fiscal Years FiscalCollected within the YearTaxes Levied for the Fiscal YearFiscal Year of LevyCollections inTotal Collections to DateOutstandingPercentage EndedOperatingDebtTotalPercentage ofSubsequentPercentage ofDelinquentof Levy December 31,Tax LevyTax LevyTax LevyAmountLevyYears (1)AmountLevyTaxesOutstanding 2014$ 9,268,754 $ 1,421,461 $ 10,690,215$ 10,506,537 98.3%$ 13,474$ 10,520,011 98.4%$ 170,204 1.6% 2015 9,735,801 1,514,844 11,250,645 11,009,239 97.9 44,044 11,053,283 98.2 197,362 1.8 2016 10,338,764 1,907,878 12,246,642 12,120,075 99.0 (9,407) 12,110,668 98.9 135,974 1.1 2017 11,151,866 2,103,366 13,255,232 12,984,829 98.0 21,142 13,005,971 98.1 249,261 1.9 2018 11,403,994 3,149,223 14,553,217 14,187,600 97.5 141,039 14,328,639 98.5 224,578 1.6 2019 12,714,661 3,613,429 16,328,090 16,163,548 99.0 9,739 16,173,287 99.1 154,803 1.0 2020 13,647,481 4,250,154 17,897,635 17,804,266 99.5 (74,163) 17,730,103 99.1 167,532 0.9 2021 14,057,804 4,108,650 18,166,454 18,166,454 100.0 -18,166,454 100.0 -- 2022 14,528,358 4,003,044 18,531,402 18,403,102 99.3 (45,420) 18,357,682 99.1 173,720 0.9 2023 15,325,009 3,892,746 19,217,755 18,753,470 97.6 -18,753,470 97.6 464,285 2.5 Notes: (1)During the years 2014 - 2015, there were a significant number of tax court challenges that resulted in taxes being rebated to taxpayers resulting in higher delinquent taxes for the years 2014 - 2015 177 Table 9 City of Hopkins, Minnesota Statistical Section (Unaudited) Ratios of Outstanding Debt by Type Last Ten Fiscal Years Governmental ActivitiesBusiness-Type Activities GeneralTaxSpecialNetNetTotalPercentage FiscalObligationIncrementAssessmentsFinancedPremiumsRevenuePremiumsPrimaryof PersonalPer (a) Capita YearBondsBondsBondsPurchases(Discounts)Bonds(Discounts)GovernmentIncome 2014$ 15,092,501$ 4,095,716 $ 10,123,177$ 194,868 $ - $ 5,488,002 $ - $ 34,994,264 16.94$ 1,900 2015 15,637,818 15,519,181 8,757,855 149,616 - 4,807,632 -44,872,102 20.752,436 2016 23,522,410 17,869,376 8,155,188 102,128 - 4,422,261 -54,071,363 23.942,812 2017 35,893,456 16,852,700 7,547,520 52,675 - 6,500,290 -66,846,641 28.633,518 2018 36,883,957 19,269,286 6,919,853 - - 9,369,368 -72,442,464 33.683,797 2019 47,657,083 19,269,286 6,919,853 - - 8,661,985 -82,508,207 36.304,185 2020 51,980,000 11,325,000 4,400,000 - 3,530,119 15,800,000 1,032,584 88,067,703 37.654,467 2021 50,855,000 11,105,000 1,200,000 - 3,333,433 17,875,000 1,129,510 85,497,943 34.784,428 2022 49,595,000 9,940,000 1,080,000 - 3,223,446 21,405,000 1,275,093 86,518,539 32.604,535 2023 49,125,000 8,710,000 960,000 - 2,861,543 23,387,000 1,158,040 86,201,583 Not available4,518 Note: Details regarding the City's outstanding debt can be found in the notes to the financial statements. (a) See Table 14 for personal income and population data. 178 Table 10 City of Hopkins, Minnesota Statistical Section (Unaudited) Ratios of Net General Bonded Debt Outstanding Last Ten Fiscal Years Less: AmountPercentage of GeneralTaxAvailable Actual FiscalObligationImprovementRevenueIncrementIn DebtNetTaxable ValuePer (1) (2) of PropertyCapita YearBondsBondsBondsBondsTotalService FundBonded Debt 2014$ 15,092,501 10,123,177 5,488,002 4,095,716 34,799,396 $ 14,373,448$ 20,425,948 1.331$ 1,109 2015 15,637,818 8,757,855 4,807,632 15,519,181 44,722,486 15,540,533 29,181,953 1.753 1,518 2016 23,522,410 8,155,188 4,422,261 17,869,376 53,969,235 11,342,561 42,626,674 2.397 2,217 2017 35,893,456 7,547,520 6,500,290 16,852,700 66,793,966 10,596,245 56,197,721 2.986 2,958 2018 36,883,957 6,919,853 9,369,368 19,269,286 72,442,464 8,599,909 63,842,555 3.320 3,346 2019 47,522,953 4,933,026 8,661,984 18,637,449 79,755,412 6,244,002 73,511,410 3.351 3,759 2020 54,773,025 4,468,576 16,832,583 11,993,519 88,067,703 9,435,593 78,632,110 3.366 3,989 2021 54,108,059 1,259,127 19,004,510 11,126,247 85,497,943 6,363,710 79,134,233 3.306 4,014 2022 52,511,967 1,133,852 22,680,093 10,192,627 86,518,539 7,489,179 79,029,360 2.985 4,142 2023 51,986,543 960,000 24,545,040 8,710,000 86,201,583 7,835,015 78,366,568 3.066 4,107 Notes: Details regarding the City's outstanding debt can be found in note 9 of the notes to the financial statements. (1) See the Assessed and Actual Value of Taxable Property schedule 5 for taxable market value of property data (2) See the Demographic and Economic Statistics schedule 14 for population data 179 THIS PAGE IS LEFT BLANK INTENTIONALLY 180 Table 11 City of Hopkins, Minnesota Statistical Section (Unaudited) Direct and Overlapping Governmental Activities Debt December 31, 2023 Estimated EstimatedShare of DebtPercentageOverlapping Governmental UnitOutstandingApplicable (a)Debt Debt Repaid with Property Taxes School Districts Hopkins ISD #270$ 143,190,000 16.57%$ 23,726,583 St. Louis Park ISD #283 247,260,00057.00% 140,938,200 Other Hennepin County 1,423,815,0001.09% 15,519,584 Hennepin Suburban Park District 59,870,0001.51% 904,037 Hennepin Regional RR Authority 81,665,0001.09% 890,149 Metropolitan Council 1,694,829,00059.00% 999,949,110 Subtotal - Overlapping Debt 1,181,927,662 City of Hopkins Direct Debt (b,c) 61,656,543100.00% 61,656,543 Total Direct and Overlapping Debt$ 1,243,584,205 Source: Hennepin County, Minnesota Taxpayer Services Note: Overlapping governments are those that coincide, at least in part, with the geographic boundaries of the City. This schedule shows the portion of the outstanding debt of those overlapping governments that is borne by the residents and businesses of the City. This process recognizes that, when considering the City's ability to issue and repay long-term debt, the entire debt burden borne by the residents and businesses should be taken into account. However, this does not imply that every taxpayer is a resident, and therefore responsible for repaying the debt, of each overlapping government. (a) The percentage of overlapping debt applicable is estimated using the taxable market values. Applicable percentages were estimated by determining the portion of the county's and school district's taxable market value that is within the City's boundaries. (b) City of Hopkins direct debt includes long-term debt instruments of the City which are bonds and capital leases of the government. (c) Net Debt Outstanding excludes revenue and special assessment debt. 181 City of Hopkins, Minnesota Statistical Section (Unaudited) Legal Debt Margin Information Last Ten Fiscal Years (dollars in thousands) Fiscal Year 2014201520162017 Statutory Debt Limit$ 46,036$ 48,168$ 51,633$ 54,888 Total Net Debt Applicable to Limit 8,736 14,661 21,761 24,401 Legal Debt Margin$ 37,300$ 33,507$ 29,872$ 30,487 Total net debt applicable to the limit as a percentage of debt limit18.98%30.44%42.15%44.46% 182 Table 12 Fiscal Year 201820192020202120222023 $ 57,695$ 64,368$ 68,712$ 71,799$ 79,430$ 76,683 32,175 43,834 42,563 42,723 44,240 54,984 $ 25,520$ 20,534$ 26,149$ 29,076$ 35,190$ 21,699 55.77%68.10%61.94%59.50%55.70%71.70% Legal Debt Margin Calculation for Fiscal Year 2023 Estimated Market Value of Taxable Property$ 2,556,103 Statutory percentage3.0% Statutory debt limit 76,683 Debt applicable to limit 49,125 Less amounts set aside for repayment of general obligation debt 5,859 Total net debt applicable to limit 54,984 Legal debt margin$ 21,699 183 Table 13 City of Hopkins, Minnesota Statistical Section (Unaudited) Demographic and Economic Statistics Last Ten Fiscal Years Per Capita FiscalPersonalPersonalSchoolUnemployment YearPopulation (1)Income (2)Income (2)Enrollment (3)Rate (4) 201418,413$ 206,789,000 $ 49,460 8,489 3.8 % 2015 19,227 216,218,000 51,244 8,495 3.1 2016 19,227 225,882,000 53,121 8,327 3.8 2017 19,000 233,465,000 53,166 8,182 3.6 2018 19,079 215,086,000 59,736 8,152 2.8 2019 19,555 227,292,000 62,889 8,345 2.7 2020 19,713 233,890,000 64,255 8,806 6.0 2021 19,713 245,833,000 67,214 8,139 2.6 2022 19,079 265,392,000 71,912 7,621 2.8 2023 19,079 277,634,965 75,164 7,451 2.2 Sources of data: (1) Metropolitan Council (2) U.S. Department of Commerce Bureau of Economic Analysis data for Minnesota Metropolitan Area (3) Minnesota Department of Education and is for public and non-public schools in Hopkins School District #270 (4) Minnesota Department of Employment and Economic Development, based on December rates 184 Table 14 City of Hopkins, Minnesota Statistical Section (Unaudited) Principal Employers Current Year and Nine Years Ago 20232014 PercentPercent of Cityof City EmployerEmployeesRankEmploymentEmployeesRankEmployment ISD 270 Hopkins (1)1,5501 8.124253 2.31 %% UNFI (SuperValue)1,2002 6.297072 3.84 Colfin Midwest NNN INV LLC (Cargil)1,1733 6.154,0001 21.72 Thermotech4004 2.104004 2.17 US Post Office3145 1.653145 1.71 Oak Ridge Country Club1856 0.972126 1.15 Augustana Chapel View Care Center1857 0.972107 1.14 US Bank1858 0.971858 1.00 City of Hopkins1549 0.811329 0.72 Walser Auto Group 10010 0.52 0.54 100 10 Total 5,446 6,685 Sources: Minnesota Department of Employment and Economic Development, Metropolitan Council and Minnesota State Business Directory Note: (1) Includes total number of employees located in facilities throughout Independent School District 270, Hopkins. 185 City of Hopkins, Minnesota Statistical Section (Unaudited) Full-time Equivalent City Government Employees by Function Last Ten Fiscal Years Full-time Equivalent Employees as of December 31, Function/Program2014201520162017 General Government Administrative Services 5.00 5.00 5.05 5.50 Finance 4.60 4.60 4.00 5.00 Municipal Building 1.45 1.45 1.45 1.45 Community Services 9.70 9.70 8.65 7.20 Public Safety Police 34.50 36.50 36.78 38.45 Fire 1.25 1.25 3.25 3.25 Public Works 17.09 18.09 17.58 18.09 Recreation Activity Center 3.20 3.20 3.25 3.20 Skate Park 0.05 0.05 0.05 0.05 Planning & Zoning 1.35 1.35 1.35 1.35 Community Development 0.85 0.85 1.50 0.85 Total General Government 79.04 82.04 82.91 84.39 Special Revenue Funds Economic Development 1.60 1.60 1.25 1.60 Paratransit - - - - Housing Rehabilitation - - - - Parking 0.72 1.00 0.72 0.72 Communication 0.25 0.25 0.75 1.25 Depot Coffee House 2.50 2.50 5.25 5.25 Art Center 3.80 4.30 4.30 4.30 Total Special Revenue Funds 8.87 9.65 12.27 13.12 Enterprise Funds Water 3.13 3.43 2.60 3.43 Sanitary Sewer 3.46 3.76 3.40 3.76 Refuse 3.89 3.89 4.09 4.09 Storm Sewer 0.63 0.63 0.43 0.63 Pavilion/Ice Arena 2.40 2.90 2.90 2.90 Housing and Redevelopment 2.20 2.20 2.40 2.40 Total General Government 15.71 16.81 15.82 17.21 Total 103.62 108.50 111.00 114.72 186 Table 15 Full-time Equivalent Employees as of December 31, 201820192020202120222023 5.00 4.00 5.00 6.55 6.67 6.67 4.00 4.00 4.00 4.00 3.60 3.60 1.45 1.45 1.45 1.45 1.28 1.28 8.95 8.95 6.95 8.40 9.49 9.49 38.28 38.45 37.28 38.28 37.23 37.23 4.10 4.10 4.10 5.10 5.50 5.50 19.98 20.98 19.98 18.48 20.49 20.49 2.80 3.00 2.00 3.00 3.00 3.00 0.05 0.05 0.05 0.05 0.05 0.05 1.35 1.35 1.35 1.35 1.35 1.35 0.85 0.85 0.85 0.85 0.85 0.85 86.81 87.18 83.01 87.51 89.51 89.51 2.00 2.00 2.00 2.00 2.50 2.50 1.12 1.12 1.12 1.12 1.12 1.12 1.00 1.00 1.00 1.00 1.00 1.00 5.00 4.62 2.75 2.75 2.75 2.75 5.28 5.28 4.66 5.50 4.53 4.53 14.40 14.02 11.53 12.37 11.90 11.90 4.79 3.79 4.79 4.15 4.15 4.15 2.60 2.60 2.60 2.24 2.24 2.24 3.39 3.39 3.39 3.56 3.56 3.56 0.63 0.63 0.63 0.66 0.66 0.66 2.70 2.90 2.40 2.90 2.42 2.42 2.40 2.40 2.40 2.40 2.40 2.40 16.51 15.71 16.21 15.91 15.43 15.43 117.72 116.91 110.75 115.79 116.84 116.84 187 City of Hopkins, Minnesota Operating Indicators by Function/Program Last Ten Fiscal Years Fiscal Year Function/Program2014201520162017 General Government Elections 2 1 2 1 Registered voters 10,912 9,647 10,418 10,366 Number of votes cast 9,130 1,058 9,198 2,164 Voter participation (registered)83.7%11.0%88.3%20.9% Public Safety Police Total Calls for Service 26,140 23,535 24,549 26,724 Sworn Officers 26 28 27 27 Traffic Stops 5,741 6,055 6,910 6,232 Parking Citations 820 725 640 662 Fire Fires 51 18 81 43 False Alarm 100 103 130 123 Fire Runs 428 467 566 415 Medical Runs 195 177 1,277 119 Average Response Time (minutes) 4.2 4.4 4.2 4.2 Inspections Building Permits 455 501 451 485 Value of Building Permits$16,453,985$12,631,596$76,838,870$19,553,988 Public Works Miles of seal coating 5.26 1.81 1.05 1.32 Miles of crack sealing 5.85 5.26 1.54 2.22 Sidewalk repairs in square feet 4,482 6,800 6,286 10,260 Alley repairs in square yards 41 182 180 1,235 Culture and Recreation Art Center Bookings 4,747 5,013 4,981 4,761 Reserved Hours 29,440 31,759 31,320 32,993 Customer Visits for Events/Activities 215,371 216,450 211,969 220,032 Water Gallons of water pumped (in millions) 812 751 760 760 Number of well house inspections 2,510 2,190 1,095 1,095 Number of hydrants flushed 150 120 101 139 Water Rate - Tier One$ 2.10 $ 2.18 $ 2.18 $ 2.44 Water Rate - Tier Two$ -$ -$ 2.81 Water Rate - Tier Thress$ -$ -$ 3.23 Sanitary Sewer Sanitary sewage flow (in millions of gallons) 628.6 614.9 605.0 598.0 Miles of sewer lines jetted 14.6 12.0 15.0 15.0 Number of manholes checked/cleaned 1,400 274 1,025 274 Lift Station Maintenance checks 4,401 4,350 4,283 1,945 Sewer Rate$ 4.10 $ 4.30 $ 4.30 $ 5.81 Refuse Number of refuse accounts 2,709 2,735 2,692 2,687 Tons of refuse collected 2,393 2,136 2,095 2,215 Tons of recycled material (residential) 1,114 726 166 966 Refuse rate$16.85 - 24.30$16.85 - 24.30$17.85 - 25.30$17.85 - $25.30 Recycling rate$ 4.25 $ 4.50 $ 5.00 $ 5.00 Organics Pavilion/Ice Arena Ice time rental hours 1,370 1,365 1,284 1,385 Turf use hours 810 818 749 682 Mezzanine rental use 2,147 2,822 2,847 7,315 Source: Various City Departments Notes: (1) Information not available is labeled N/A. 188 Table 16 Fiscal Year 201820192020202120222023 2 1 2 1 1 1 22,279 10,684 12,613 11,986 10,742 10,820 11,583 1,514 10,598 2,674 7,323 2,072 52.0%14.2%84.0%22.0%68.2%19.1% 26,063 23,996 26,139 21,432 23,718 25,706 27 30 28 28 28 6,212 4,929 3,589 1,720 2,592 4,538 542 499 423N/AN/AN/A 31 39 39 29 38 91 110 29 36 38 147 156 322 235 180 303 293 561 143 111 129 1,208 1,235 1,454 4.2 4.1 4.1 4.6 4.6 4.6 405 506 636 707 455 1,807 $27,785,861$45,193,752$21,124,485$38,156,628$137,019,951$154,683,475 1.18 N/A 1.98 1.53 3.65 N/A 2.33 8.87 1.35 N/A 3.65 N/A 25,905 40,100 4,543 1,202 11,325 N/A 712 45N/AN/A 529 N/A 3,975 3,859 272 425 1,371 3,039 24,901 19,509 1,864 3,157 6,557 13,562 227,291 220,512 41,537 66,204 131,576 146,735 720 656 682 705 692 681 1,095 1,095 1,095 1,095 1,095 365 - 337 337 290 216 250 $ 2.60 $ 2.78 $ 3.04 $ 3.10 $ 3.42 $ 3.97 $ 3.00 $ 3.20 $ 3.49 $ 3.56 $ 3.94 $ 4.57 $ 3.45 $ 3.68 $ 4.01 $ 4.09 $ 4.52 $ 5.24 560.0 448.0 570.0 597.0 600.0 600.0 13.0 14.4 12.0 14.0 13.0 16.5 302 357 528 390 409 578 1,095 1,825 1,825 2,005 365 365 $ 6.12 $ 6.46 $ 6.86 $ 6.86 $ 7.58 $ 7.96 2,698 2,687 2,698 2,707 2,687 2,687 2,162 2,132 3,027 2,193 2,010 1,920 676 676 1,822 941 644 615 $17.85 - $25.30$17.85- $25.30$17.85 - $25.30$17.85 - $25.30$18.85 - $26.30$19.80 - $27.60 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $5.00 - $5.50$5.25 - $5.64 $5.50 - $5.75$ 5.75 1,213 1,174 926 1,433 1,417 1,481 425 446 221 183 615 394 8,892 14,289 20,404 4,551 11,231 6,555 189 City of Hopkins, Minnesota Statistical Section (Unaudited) Capital Asset Statistics by Function/Program Last Ten Fiscal Years Fiscal Year Function/Program2014201520162017 Public Safety Police Stations 1 1 1 1 Patrol Units 11 11 11 11 Fire Stations 1 1 1 1 Public Works Highways (miles) 3.57 3.57 3.57 3.57 County Highways 5.32 5.32 5.32 5.32 City Streets (miles) 47.50 47.50 47.50 47.50 Alleys (miles) 9.52 9.52 9.52 9.52 Streetlights 398 398 398 398 Traffic Signals 44 44 44 44 Refuse collection trucks 3 3 3 3 Culture & Recreation Parks Parks 16 16 16 16 Park Trails 4 4 4 4 Park Acres 104 104 104 104 Park Shelters 11 11 11 11 Playgrounds 11 11 11 11 Skateboard Park/Inline Skating 1 1 1 1 Skating Rinks 7 7 7 7 Hockey Rinks 5 5 5 5 Basketball Courts 6 6 6 6 Pickleball Courts - - - - Softball Fields 4 4 4 4 Swimming Beach 1 1 1 1 Tennis Courts 8 8 8 8 Volleyball Courts 2 2 2 2 Watermains Distribution System (miles) 52.60 52.60 52.60 52.60 Fire Hydrants 560 560 560 560 Storage Capacity (gallons in thous) 3,200 3,200 3,200 3,200 Water Connections 3,168 3,168 3,168 3,168 Sanitary Sewer Collection System (miles) 45.46 45.46 45.46 45.46 Sewer Connections 3,086 3,086 3,086 3,086 Storm Sewer Pipe (miles) 21.40 21.40 21.40 21.40 Parking Parking Lots 7 7 7 7 Parking Ramp 1 1 1 1 Source: Various City Departments 190 Table 17 Fiscal Year 201820192020202120222023 1 1 1 1 1 1 11 11 11 11 11 11 1 1 1 1 1 1 3.57 3.57 3.57 3.57 4.18 4.18 5.32 5.32 5.32 5.32 4.09 4.09 47.50 47.50 47.50 47.50 39.28 39.28 9.52 9.52 9.52 9.52 9.90 9.90 398 398 398 398 557 557 44 44 44 44 43 43 3 3 3 3 3 3 16 16 16 16 14 14 4 4 4 4 4 4 104 104 104 104 127 127 11 11 11 11 11 11 11 11 11 11 10 10 1 1 1 1 1 1 7 7 7 7 7 7 5 5 5 5 4 4 6 6 6 6 6 6 - 1 1 1 1 8 4 4 4 4 8 1 1 1 1 1 1 7 8 8 8 8 7 2 2 2 2 2 2 52.60 52.60 52.60 52.60 57.44 57.44 560 560 560 560 439 439 3,200 3,200 3,200 3,200 3,200 3,200 3,168 3,168 3,168 3,168 3,646 3,646 45.46 45.46 45.46 45.46 43.04 43.04 3,086 3,086 3,086 3,086 3,086 3,086 21.40 21.40 21.40 21.40 36.30 36.30 7 7 7 7 13 13 1 1 1 1 1 1 191