Loading...
2022 Monticello Annual Comprehensive Financial ReportAnnual Comprehensive Financial Report For the Year Ende d December 31, 2022 City of Monticello, Minnesota 505 Walnut Street • 763-295-2711 • ci.monticello.mn.us City of Monticello Wright County, Minnesota Annual Comprehensive Financial Report FOR THE YEAR ENDED DECEMBER 31, 2022 Prepared by THE FINANCE DEPARTMENT Sarah Rathlisberger, Finance Director ● Liz Lindrud, Finance Manager Julie Cheney, Finance Assistant ● Cheri Butler, Payroll Clerk Debbie Gulbrandson, Finance Clerk ● Pat Kovich, Utility Billing Specialist CITY OF MONTICELLO Financial Statements Table of Contents December 31, 2022 INTRODUCTORY SECTION Page Letter of Transmittal 1 GFOA Certificate of Achievement for Excellence in Financial Reporting 4 Organization Chart 5 Directory of Officials 6 FINANCIAL SECTION Independent Auditor's Report 8 Management's Discussion and Analysis 13 Basic Financial Statements Government-wide Financial Statements Statement of Net Position 22 Statement of Activities 23 Fund Financial Statements Balance Sheet - Governmental Funds 25 Reconciliation of the Governmental Funds Balance Sheet to the Statement of Net Position 26 Statement of Revenues, Expenditures and Changes in Fund Balance - Governmental Funds 27 Reconciliation of the Statement of Revenues, Expenditures and Changes in Fund Balances of Governmental Funds to the Statement of Activities 28 Statement of Net Position - Proprietary Funds 29 Statement of Revenues, Expenses and Changes in Net Position - Proprietary Funds 31 Statement of Cash Flows - Proprietary Funds 33 Notes to the Financial Statements 35 Required Supplementary Information Schedule of Employer's Share and Non-Employer Proportionate Share of Net Pension Liability -Public Employees Retirement Association 65 Schedule of Employer's Pension Contibutions - Public Employees Retirement Association 65 Schedule of Changes in the Fire Relief Association's Net Pension Liability (Asset) and Related Ratios 66 Schedule of Employer's Pension Contributions - Monticello Fire Department Relief Association 66 Schedule of Changes in the City's Total OPEB Liability and Related Ratios 67 Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual - General Fund 68 Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual - Community Center Fund 69 Notes to the Required Supplementry Information 70 Combining and Individual Fund Financial Statements and Schedules Nonmajor Governmental Funds Combining Balance Sheet 76 Combining Statement of Revenues, Expenditures and Changes in Fund Balance 77 Internal Service Funds Combining Statement of Net Position 80 Combining Statement of Revenues, Expenses and Changes in Net Position 81 Combining Statement of Cash Flows 82 Other Supplementry Schedules Schedule of Revenues (Sources) and Expenditures (Uses) - General Fund 84 Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual - Small Cities 86 Development Program Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual - Cemetery Fund 87 Schedule of Assets, Liabilities, Deferred Inflows of Resources and Fund Balances - Debt Service Activities 88 Schedule of Revenues, Expenditures and Other Financing Sources (Uses) - Debt Service Activities 89 Balance Sheet/Statement of Net Position - Discretely Presented Component Unit - Economic Development Authority 91 Schedule of Revenues, Expenditures and Other Financing Uses - Discretely Presented Component Unit - Economic Development Authority 93 (continued) I CITY OF MONTICELLO Financial Statements Table of Contents December 31, 2022 (continued) STATISTICAL SECTION Financial trends Net Position by Component - Last Ten Fiscal Years 95 Changes in Net Position - Last Ten Fiscal years 96 General Governmental Tax Revenues by Source - Last Ten Fiscal Years 98 Fund Balances of Governmental Funds - Last Ten Fiscal Years 99 Changes in Fund Balances of Governmental Funds - Last Ten Fiscal Years 100 Governmental Funds Tax Revenues by Source - Last Ten Fiscal Years 101 Revenue capacity Tax Capacity Value and Estimated Market Value of Taxable Property - Last Ten Fiscal Years 102 Property Tax Rates - All Direct and Overlapping Governments - Last Ten Fiscal Years 103 Property Tax Levies and Collections - Last Ten Fiscal Years 104 Principal Property Taxpayers - Current Year and Nine Years Ago 105 New Construction and Bank Deposits - Last Ten Fiscal Years 106 Water Sold by Customer Type - Last Ten Fiscal Years 107 Water and Sewage Utility Rates - Last Ten Fiscal Years 108 Debt capacity 109 110 111 112 Ratios of Outstanding Debt by Type - Last Ten Fiscal Years Ratios of Net General Obligation Bonded Debt Outstanding - Last Ten Fiscal Years Legal Debt Margin Information - Last Ten Fiscal Years Computation of Direct and Overlapping Debt - As of December 31, 2022 Schedule of General Obligation Revenue Bond Coverage - Last Ten Fiscal Years 113 Economic and demographic information Demographic and Economic Statistics - Last Ten Fiscal Years 114 Principal Employers - Current Year and Nine Years Ago 115 Operating information 116 117 119 City Government Employees by Function/Program - Last Ten Fiscal Years Operating Indicators by Function - Last Ten Fiscal Years Capital Assets Statistics by Function - Last Ten Fiscal Years Schedule of Cash Flows Adjusted for Additional City Funding of Fiber Optics Fund -Last Eight Fiscal Years 120 II INTRODUCTORY SECTION June 20, 2023 To the Honorable Mayor, Members of the City Council, and the Residents of the City of Monticello: The city is pleased to present the Annual Comprehensive Financial Report (ACFR) of the City of Monticello, Minnesota (the city) for the fiscal year ended December 31, 2022. Responsibility for both the accuracy of the data and the completeness and fairness of the presentation, including all disclosures, rests with the city. To the best of our knowledge and belief, the enclosed data is accurate, in all material respects, and is reported in a manner designed to present fairly the financial position and results of operations of the various funds of the city. All disclosures necessary to enable the reader to gain an understanding of the city’s financial activities have been included. The city’s ACFR has been audited by Abdo, a firm of licensed certified public accountants. The goal of the independent audit is to provide reasonable assurance that the financial statements of the city for the fiscal year ended December 31, 2022, are free of material misstatements. The independent audit involved examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements, assessing the accounting principles used and significant estimates made by management, and evaluating the overall financial statement presentation. The independent auditor concluded, based upon the audit, that there was a reasonable basis for rendering an unmodified opinion that the city’s financial statements for the fiscal year ended December 31, 2022 are fairly presented in conformity with accounting principles generally accepted in the United States of America. The independent auditor’s report is presented as the first component of the financial section of this report. The preparation of this ACFR is a requirement of state law. Also, the ACFR is required by bond rating agencies before they will rate the city’s bonds. The report can be used by the city council and residents of the city to gain a better understanding of the financial condition of the city. Accounting principles generally accepted in the United States of America require that management provide a narrative introduction, overview, and analysis to accompany the basic financial statements in the form of Management’s Discussion and Analysis (MD&A). This letter of transmittal is designed to complement the MD&A and should be read in conjunction with it. The city’s MD&A can be found immediately following the independent auditor’s report. PROFILE OF THE CITY The city is situated in a prime location on Interstate 94 between the cities of Minneapolis/St. Paul and St. Cloud. The city has experienced remarkable growth within the last 10 years in the residential, commercial, office, and retail sectors. The city is a freestanding urban fringe community encompassing approximately 6,000 acres and a population of 14,619. The city is home to one of Minnesota’s two nuclear power plants, both owned by Xcel Energy, Inc. (NYSE: XEL). With a small carbon footprint, the Xcel plant is also the city’s largest property taxpayer and the second largest employer. Additionally, Monticello’s business friendly environment provides a home for Cargill Kitchen Solutions. The privately-owned, agri-giant is the city’s largest customer of water and sewer utility services. The city was founded by second-generation Americans who migrated west in the mid-1800s. Early settlers found the gently sloping banks and shallow levels of the Mississippi River made a logical place for a river crossing. Incorporated in 1856, the city grew quickly during the early settlement years and then levelled off to a population of about 1,300. It was this original settlement that became the core city and survives today as downtown Monticello. The city is categorized as a 501(a) entity by IRS Code and operates under the “Optional Plan A” form of government as defined in Minnesota Statutes. Under this plan, the government of the city is directed by a city council composed of an elected mayor and four elected city council members. The city council exercises legislative authority and determines all matters of policy. The city council appoints personnel responsible for the proper administration of all affairs relating to the city. Council members serve four-year terms, with 1 two members elected every two years. The mayor is elected for a two-year term. The mayor and members of the city council are elected at large. The city provides a full range of services: the construction and maintenance of streets and other infrastructure; snow removal; park and cemetery maintenance; recreational and cultural activities; water, sewer, stormwater, and residential garbage and recycling systems; community development, building inspection, planning, police, fire, liquor store, and deputy registrar operations; a city-run fiber optic system and community center; and general government operations, including administration, finance/accounting, human resources, information systems, and general government buildings. The city council is required to adopt a final budget by late December for the subsequent year. The budget is prepared by fund, function (e.g. public works), and department (e.g. streets and alleys). Transfers of appropriations between funds require the approval of the city council. The legal level of budgetary control is the department level in the General Fund and fund level in all other funds. Budget amendments require city council approval. FINANCIAL PLANNING AND THE LOCAL ECONOMY The city is in line for continued growth. The location on Interstate 94 is a catalyst for interest from developers to build in the city. Several residential neighborhoods and multi-family dwellings are under construction with more on the horizon. The nuclear power plant provides the city with a relatively stable tax and employment base, although year-to-year valuations of the nuclear plant can cause tax shifts between property tax types. During the economic downturn, the city lost very few of its local businesses, although some reduced their workforce and scaled back operations. New commercial development came to a virtual standstill, however, interest in the commercial sector to expand or relocate to Monticello is increasing. The economy and housing market have also affected city revenues for building permits. The city issued 659 building permits in 2013 with a total valuation of $15,821,223. In 2022, the city issued 909 permits with a total valuation of $41,989,848, nearing the activity in the early 2000s. Due to the nuclear plant and local development, the city does not rely on the state as a major funding source (LGA), so the city’s finances are relatively insulated from the state’s budget impacts. In addition, the city has budgeted conservatively over the years, resulting in very modest growth in the property tax levy. To assist external stakeholders, the city is continuously exploring various ways to better represent its financial position. Other initiatives include implementing a proposed future local option sales tax, obtaining increased amounts of state and federal funding, evaluating expenses shared across departments for proper allocation, and aggregating similar costs for distribution as single amounts to each budget unit. Further, staff continue to refine the chart of accounts with the goal of providing better information to decision makers. MAJOR INITIATIVES The city has several major ongoing initiatives in 2022. The first ongoing initiative is the revitalization of its historic downtown. The downtown is the oldest part of the city, and many buildings need maintenance or demolition. In addition, the amount of traffic on State Highway 25 and County Road 75 makes it difficult for both vehicle and pedestrian traffic to move from one area of the downtown to another. The city’s goal is to make the downtown area a vibrant shopping and resident destination once again, which is driven by the Embracing Downtown Monticello initiative and 2017 Downtown Small Area Plan. Several properties were acquired by the Monticello Economic Development Authority (EDA), which were platted and sold to a developer in 2022. The challenge moving forward will be the implementation of the plan and creating additional development opportunities within the downtown area for new and existing businesses. The city’s Monti:2040 Comprehensive Plan, completed in 2020, includes downtown revitalization as a priority focus through 2040. The Downtown Pedestrian and Roadway Improvements project is budgeted for 2023. The second major focus of the City Council is the construction of a new Public Works Facility, as the current location was built in the 1970s and would need significant maintenance to continue supporting operations. Land was purchased in 2021 for the new site, and an architect was hired in 2022. Design will continue in 2023 with construction expected in 2024 and 2025. Third, the City Council identified the Pointes at Cedar development area, a 100-acre site in the middle of the city, as a prime area for growth, which will aid in lessening the impacts of a future Xcel plant decommissioning. While Xcel’s preferred scenario is to extend the licensure of the Monticello plant past its 2 current expiration in 2030, re-licensure is an extensive process, and the city realizes that planning for the future needs to happen today. The fourth ongoing initiative is the joint operation with Wright County of Bertram Chain of Lakes properties. The 1,258-acre site includes four pristine lakes and woodlands, which, when developed, will become a regional park. Wright County and the city obtained matching grants from the state to purchase much of the acreage in the park. Construction of phase 1 of park improvements was completed in 2021. Safety improvements to accessibility is budgeted for 2023. INTERNAL CONTROL The management of the city is responsible for establishing and maintaining a system of internal controls designed to ensure that the assets of the city are protected from loss, theft, or misuse and that adequate and accurate accounting data is compiled to allow for the preparation of financial statements in conformity with accounting principles generally accepted in the United States of America. The city’s internal controls are designed to provide reasonable, but not absolute assurance that these objectives are met. The concept of reasonable assurance recognizes that: 1) the cost of a control should not exceed the benefits likely to be derived, and 2) the valuation of cost and benefit requires estimates and judgments by management. The city’s internal controls are subject to periodic evaluation by management and the finance department staff of the city. Management assumes full responsibility for the completeness and reliability of the information contained in this report, based upon a comprehensive framework of internal control that it has established for this purpose. BUDGETING CONTROLS The city maintains budgetary controls to assure compliance with legal provisions embodied in the annual appropriated budget approved by the city council. The activities of the General Fund are included in the annual appropriated budget. The level of budgetary control (that is, the level at which expenditures cannot legally exceed the appropriated amount) is established by department within the General Fund. The city council also adopts a ten-year Capital Improvement Plan as a financial planning document for major purchases. As demonstrated by the statements and schedules included in the financial section of this report, the city continues to meet its responsibility for sound financial management. ACKNOWLEDGEMENTS 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 for its ACFR for the fiscal year ended December 31, 2021. This was the twelfth year that the city has achieved this prestigious award. To be awarded a Certificate of Achievement, the city had to publish an easily readable and efficiently organized ACFR. This report must satisfy both accounting principles generally accepted in the United States of America and applicable legal requirements. A Certificate of Achievement is valid for a period of one year only. The city believes our current ACFR continues to meet the Certificate of Achievement Program’s requirements, and the city is submitting it to the GFOA to determine its eligibility for the award. The 2022 ACFR meets the highest professional standards and was prepared in a timely and cost-effective manner. The preparation of this report would not have been possible without the efficient and dedicated service of the entire staff of the finance department, other city department heads, and through the helpful guidance and assistance from our auditing firm, MMKR. City management expresses our appreciation to all parties who assisted and contributed to the preparation of this report. Credit also must be given to the mayor and city council for their unfailing support for maintaining the highest standards of professionalism in the management of the city’s finances. Respectfully submitted, Sarah Rathlisberger Finance Director 3 The Government Finance Officers Association of the United States and Canada (GFOA) awarded a Certificate for Excellence in Financial Reporting to the City of Monticello, Minnesota for its Annual Comprehensive Financial Report for the fiscal year ended December 31, 2021. The Certificate of Achievement is a prestigious national award recognizing conformance with the highest standards for preparation of state and local government reports. To be awarded a Certificate of Achievement, a governmental unit must publish an easily readable and efficiently organized Annual Comprehensive Financial Report, whose contents conform to program standards. Such reports must satisfy both generally accepted accounting principles and applicable legal requirements. A Certificate of Achievement is valid for a period of one year only. We believe our current report continues to conform to Certificate of Achievement program requirements, and we are submitting it to the GFOA. Government Finance Officers Association Certificate of Achievement for Excellence in Financial Reporting Presented to City of Monticello Minnesota For its Annual Comprehensive Financial Report For the Fiscal Year Ended December 31, 2021 Executive Director 4 5 MAYOR & CITY COUNCIL Position Name Term Expires Mayor ...................................................................................... Lloyd Hilgart 12/31/2024 Council ....................................................................................... Lee Martie 12/31/2024 Council .................................................................................... Sam Murdoff 12/31/2024 Council .............................................................................. Charlotte Gabler 12/31/2026 Council ....................................................................................... Tracy Hinz 12/31/2026 CITY STAFF City Administrator ........................................................................................ Rachel Leonard Public Works Director/City Engineer ............................................................... Matt Leonard Finance Director ....................................................................................Sarah Rathlisberger Community Development Director .......................................................... Angela Schumann Parks, Arts & Recreation Director ..................................................................... Tom Pawelk City Clerk ................................................................................................. Jennifer Schreiber Finance Manager ................................................................................................ Liz Lindrud Human Resource Manager ............................................................................... Tracy Ergen Communications & Marketing Specialist .......................................................... Haley Foster Street Superintendent...................................................................................... Mike Haaland Parks Superintendent ................................................................................. Josh Berthiaume Utilities Superintendent......................................................................................... Mat Stang Facilities Maintenance Manager ...................................................................... Jerry Hanson Deputy Registrar Manager ......................................................................... Carolyn Granger Liquor Store Manager ................................................................................. Randall Johnsen Economic Development Manager ....................................................................... Jim Thares Chief Building Official ............................................................................ Ron Hackenmueller Fire Chief .......................................................................................................... Mike Mossey PROFESSIONAL SERVICES Law Enforcement ................................................................... Wright County Sheriff’s Office City Attorney ................................................................................... Campbell Knutson, P.A. City Planning Consultant ................................................ Northwest Associated Consultants Financial Advisor ........................................................................... Northland Securities, Inc Fibernet Management Services .................................................................................. Arvig 6 FINANCIAL SECTION 7 INDEPENDENT AUDITOR’S REPORT Honorable Mayor and City Council City of Monticello, Minnesota Opinions We have audited the accompanying financial statements of the governmental activities, the business-type activities, the discretely presented component unit, each major fund and the aggregate remaining fund information of the City of Monticello, Minnesota (the City), as of and for the year ended December 31, 2022, and the related notes to the financial statements, which collectively comprise the City’s 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, the discretely presented component unit, each major fund and the aggregate remaining fund information of the City as of December 31, 2022, and the respective changes in financial position and, where applicable, cash flows thereof 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 the United States. Our responsibilities under those standards are further described in the Auditor’s Responsibilities for the Audit of the Financial Statements section of our report. We are required to be independent of the City 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 preparation and 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’s ability to continue as a going concern for twelve months beyond the financial statement date, including any currently known information that may raise substantial doubt shortly thereafter. Auditor’s Responsibilities for the Audit of the Financial Statements Our objectives are to obtain reasonable assurance about whether the financial statements as a whole are free from material misstatement, whether due to fraud or error, and to issue an auditor’s report that includes our opinions. 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. 8 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 City’s internal 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 the City’s ability 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. Change in Accounting Principle As described in Note 7 to the financial statements, the City adopted the provisions of Governmental Accounting Standard Board (GASB) Statement No. 87, Leases, for the year ended December 31, 2022. Adoption of the provisions of these statements results in significant change to the classifications of the components of the financial statements. Our opinion is not modified with respect to this matter. Required Supplementary Information Accounting principles generally accepted in the United States of America require that the Management’s Discussion and Analysis starting on page 13 and the required supplementary information (RSI), as listed in the table of contents, starting on page 65 be presented to supplement the basic financial statements. Such information, 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 RSI in accordance with auditing standards generally accepted in the United States of America, which consisted of inquiries of management about the methods of preparing the information and comparing the information for consistency with management’s responses 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. Supplementary Information Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the City’s basic financial statements. The combining and individual fund financial statements and schedules are 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, combining and individual fund financial statements and schedules are fairly stated, in all material respects, in relation to the basic financial statements as a whole. 9 Other Information Management is responsible for the other information included in the annual report. The other information comprises the introductory and statistical sections but does not include the basic financial statements and our auditor’s report 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 June 20, 2023, on our consideration of the City’s internal control over financial reporting and on our tests of its compliance with certain 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 the City’s 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 City’s internal control over financial reporting and compliance. Abdo Minneapolis, Minnesota June 20, 2023 10 (This page left blank intentionally) 11 MANAGEMENT'S DISCUSSION AND ANALYSIS 12 Management’s Discussion and Analysis As management of the City of Monticello, Minnesota (the city), we offer readers of the city’s financial statements this narrative overview and analysis of the financial activities of the city for the fiscal year ended December 31, 2022. We encourage readers to consider the information presented here in conjunction with additional information that we have furnished in our letter of transmittal, which can be found starting on page 1 of this report. Financial Highlights •The assets and deferred outflows of resources of the city exceeded its liabilities and deferred inflows of resources at year-end by $142,581,457 (net position). Of this amount, $47,609,546 (unrestricted net position) may be used to meet the city’s ongoing obligations to citizens and creditors. •As of the close of the current fiscal year, the city’s governmental funds reported combined ending fund balances of $22,917,518, a decrease of $369,458, or 1.6%. Nonspendable, restricted, and assigned uses of fund balance totaled $15,988,252, leaving an unassigned fund balance of $6,929,266 which is $447,330, or 6.9%, higher than the 2021 ending unassigned balance. •At the end of the current fiscal year, unassigned fund balance for the General Fund was $6,929,266, or 65.7%, of total General Fund expenditures for 2022. It is the city’s policy to have an ending General Fund balance at 60-75% of the following year’s expenditure budget, which provides a reserve for cash flow during the first six months of each subsequent year until property tax receipts are distributed by the county to the local levels of government. Additionally, this reserve threshold provides temporary financing for unforeseen emergencies. •In 2022, government-wide capital assets decreased by $2,016,599. Governmental activities included the 2022 street project and the completion of the new restroom at Ellison Park. Parks, public works, fire, and the building department purchased new vehicles and equipment. Other new additions were the installation of security cameras and the library roof replacement. •The city’s total long-term bonded indebtedness decreased by $2,681,000, or 11.0%, in 2022. Principal payments of $2,681,000 were paid in 2022. They city did not issue any new bonds in 2022. Overview of the Basic Financial Statements The discussion and analysis are intended to serve as an introduction to the city’s basic financial statements. The city’s basic financial statements are comprised of three components: 1) government-wide financial statements, 2) fund financial statements, and 3) notes to the financial statements. This report also contains other supplementary information in addition to the basic financial statements themselves. COMPONENTS OF THE ANNUAL COMPREHENSIVE FINANCIAL REPORT Management’s Discussion and Analysis Basic Financial Statements Required Supplementary Information Government-Wide Financial Statements Fund Financial Statements Notes to the Financial Statements Summary Detail 13 Government-Wide Financial Statements – The government-wide financial statements are designed to provide readers with a broad overview of the city’s finances, in a manner like private sector businesses. The Statement of Net Position presents information on all the city’s assets and deferred outflows of resources, and liabilities and deferred inflows of resources, with the difference reported as net position. 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 Statement of Activities presents information showing how the city’s net 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, regardless of the timing of related cash flows. Thus, revenues and expenses are reported in this statement for some items that will only result in cash flows in future fiscal periods (delinquent taxes and special assessments, for example). Both government-wide financial statements distinguish functions of the city that are principally supported by taxes and intergovernmental revenue (governmental activities) from other functions that are intended to recover all or a significant portion of their costs through user fees and charges (business-type activities). The governmental activities provided by the city include general government, public safety, public works, sanitation, recreation and culture, economic development and interest and fiscal charges. Business-type activities include the water, sewer, stormwater, liquor, fiber optics, and deputy registrar enterprises. The government-wide financial statements include not only the city itself (known as the primary government), but also the Economic Development Authority (EDA). The EDA is a legally separate entity which provides redevelopment and other economic development assistance through the administration of various programs. Financial information for this component unit is discretely presented in the government-wide financial statements. The government- wide financial statements can be found starting on page 22 of this report. Fund Financial Statements – A fund 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. These statements focus on individual parts of the city government, reporting the city’s operations in more detail than the government- wide statements. All the city’s funds can be divided into two categories: governmental funds and proprietary funds. Governmental Funds – Governmental funds are used to account for essentially the same functions reported as governmental activities in the government-wide financial statements. However, unlike the government-wide financial statements, governmental fund financial statements focus on near-term inflows and outflows of spendable resources, as well as the balances of spendable resources available at the end of the fiscal year. Such information may be useful in evaluating a government’s near-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 governmental funds with similar information presented for governmental activities in the government-wide financial statements. By doing so, readers may better understand the long-term impact of the government’s near-term financing decisions. Both the governmental funds Balance Sheet and Statement of Revenue, Expenditures and Changes in Fund Balances provide a reconciliation to facilitate the comparison between governmental funds and governmental activities. The city maintains several individual governmental funds. Information is presented separately in the governmental funds Balance Sheet and in the governmental funds Statement of Revenue, Expenditures and Changes in Fund Balance for the General Fund, Community Center (special revenue) Fund, Debt Service Fund, and Capital Projects Fund, all of which are major funds. Data from the remaining 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 combining statements or schedules elsewhere in this report. The city adopts an annual budget for its General Fund and special revenue funds. A budgetary comparison schedule has been provided within the required supplementary information for the General Fund and Community Center Fund to demonstrate compliance with the adopted budgets. The governmental fund financial statements can be found starting on page 24 of this report. Proprietary Funds – The city maintains two distinct types of proprietary funds. Enterprise funds are used to report the same functions presented as business-type activities in the government-wide financial statements. The city maintains six enterprise funds which are used to account for its water, sewer, and stormwater services, municipal liquor store sales, fiber optics network, and deputy registrar. Internal service funds are an accounting device used to accumulate and allocate costs internally among the city’s various functions. The city uses internal service funds to account for benefit accruals, central equipment acquisitions, information technology (IT) services, and facilities maintenance. Because these internal service fund activities predominantly benefit governmental rather than business-type functions, they have been included within governmental activities in the government-wide financial statements. 14 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 operations. The internal service funds are combined into a single, aggregated presentation in the proprietary fund financial statements. Individual fund data for the internal service funds is provided in the form of combining statements elsewhere in this report. The proprietary fund financial statements can be found starting on page 29 of this report. Notes to Basic Financial Statements – The notes to basic financial statements provide additional information that is essential to obtaining a full understanding of the data provided in the government-wide and fund financial statements. The notes to the basic financial statements can be found starting on page 35 of this report. Required Supplementary Information. In addition to the basic financial statements and accompanying notes, this report also presents certain required supplementary information concerning the City of Monticello’s share of net pension liabilities (assets) for defined benefit 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 65 of this report. Other Information –Combining and individual fund financial statements and schedules for nonmajor governmental funds, internal service funds, and other supplementary schedules are presented immediately following the required supplemental information. Combining and individual fund statements and schedules can be found starting on page 76. GOVERNMENT-WIDE FINANCIAL ANALYSIS NET POSITION By the far the largest portion of the city’s net position (64.3%) reflects investment in capital assets (e.g., land, buildings, structures, systems, machinery, equipment, infrastructure, and intangible assets), net of any related debt used to acquire those assets that is still outstanding. The city uses assets to provide services to citizens; consequently, these assets are not available for future spending. Although the city’s investment in capital assets is reported net of related debt, it should be noted that resources needed to repay this debt must be provided from other sources since capital assets themselves cannot be used to liquidate these liabilities. A small portion of the city’s net position (2.4%) represents resources that are subject to external restrictions on how they can be used. The remaining unrestricted net position of $47,609,546 may be used to meet the ongoing obligations to citizens and creditors. The unrestricted governmental activities net position increased $1,186,496 (5.5%), and business-type activities unrestricted net position increased $3,350,387 (15.5%). The government-wide total unrestricted net position increased $4,536,883 (10.5%) reflecting revenues exceeding conservative budgeted estimates and expenditures below liberal estimates. The $720,112 (1.0%) decrease in governmental activities capital assets is reflective of depreciation and disposals exceeding capital asset purchases and reinvestment. Business-type capital assets decreased $1,296,487 (3.0%) due to depreciation more than additions. Total net investment in capital assets, which is capital assets less related debt, decreased because capital asset acquisitions less the amount of debt borrowed to acquire assets exceeded capital asset disposals and depreciation. 2022 2021 2022 2021 2022 2021 Current and other assets 32,226,452$ 32,081,346$ 27,571,905$ 23,156,505$ 59,798,357$ 55,237,851$ Capital assets 71,967,819 72,687,931 41,944,998 43,241,485 113,912,817 115,929,416 Total assets 104,194,271 104,769,277 69,516,903 66,397,990 173,711,174 171,167,267 Deferred outflows of resources 1,415,999 1,397,817 504,058 465,507 1,920,057 1,863,324 Long-term liabilities 22,682,238 23,513,828 4,549,652 3,922,878 27,231,890 27,436,706 Other liabilities 2,388,747 1,853,526 1,010,987 595,714 3,399,734 2,449,240 Total liabilities 25,070,985 25,367,354 5,560,639 4,518,592 30,631,624 29,885,946 Deferred inflows of resources 1,730,675 3,309,992 687,475 626,214 2,418,150 3,936,206 Net position Net investment in capital assets 52,824,487 52,035,838 38,793,527 40,089,758 91,618,014 92,125,596 Restricted 3,353,897 4,010,180 - - 3,353,897 4,010,180 Unrestricted 22,630,226 21,443,730 24,979,320 21,628,933 47,609,546 43,072,663 Total net position 78,808,610$ 77,489,748$ 63,772,847$ 61,718,691$ 142,581,457$ 139,208,439$ Governmental Activities Business-Type Activities Total 15 CHANGE IN NET POSITION Governmental Activities. The most significant revenue source for governmental activities is property taxes at 60.6% of total revenues. Property taxes support the General, Community Center, Capital Project, and Debt Service funds. Charges for services account for 22.9% of revenues, with about 23.3% of that generated by the Community Center. Community Center usage continues to recover from the COVID-19 pandemic. Capital grants and contributions include special assessments and revenues from other sources restricted to capital asset acquisition. Investment earnings include both interest earnings received and the change in the investment fair values. Tax increments are property taxes collected in tax increment financing districts and are restricted for development purposes. Governmental activities revenues decreased $2,357,468 (11.6%) in the current year. Charges for services increased $495,176 (13.0%) with increased operations at the Community Center compared to 2021. Additionally, unrestricted grants and aids decreased $2,170,560. Property taxes increased by $276,169 (2.5%) while investment earnings decreased $747,255 (443.2%) because the fair value decreases as interest rates increase. Public works (engineering, streets, ice and snow removal, shop and garage, street lighting, etc.) expenses are the most significant (33.3%), followed by recreation and culture (23.3%), public safety (19.0%), general government (16.8%), sanitation (4.7%), and interest and fiscal charges (2.9%). Included in these amounts is depreciation expense, which is 24.3% of the total expenses for governmental activities. Governmental activities expenses increased $1,530,558 (10.1%) in the current year. The most significant changes in program expenses were as follows: • Recreation and culture increased $683,849 (21.4%). Park operations increased due to an additional full-time parks operator. The Monticello Community Center expenses increased due to increased staffing costs as memberships and usage increased post COVID-19 pandemic. • Public Works increased $723,185 (15.0%) due to a few factors. Utility and fuel prices increased as did the cost of supplies. The engineering inspections costs increased due to the increase in development projects, these costs are offset with revenues. • General government expenses increased $188,991 (7%) due to expenses related to a Community Energy Transitions (CET) grant, which provided funds for studies related to the future decommissioning of the Xcel Nuclear Generating Plant. General government expenses also increased with the addition of a full-time administrative employee, an increase in pension expense and expenses associated with the 2022 elections. 2022 2021 2022 2021 2022 2021 Revenues Program revenues Charges for services 4,330,832$ 3,819,070$ 15,489,232$ 14,821,453$ 19,820,064$ 18,640,523$ Operating grants and contributions 1,192,748 1,539,082 297,608 95,601 1,490,356 1,634,683 Capital grants and contributions 1,529,488 3,314,487 1,522,921 1,842,947 3,052,409 5,157,434 General revenues Property taxes 11,456,764 11,180,595 - - 11,456,764 11,180,595 Tax increments - - - - - - Franchise taxes 388,074 383,045 53,000 53,942 441,074 436,987 Unrestricted grants and aids - - - - - - Unrestricted investment earnings (915,858) (168,603) (817,755) (101,693) (1,733,613) (270,296) Gain on sale of assets - 271,840 - - - 271,840 Total revenues 17,982,048 20,339,516 16,545,006 16,712,250 34,527,054 37,051,766 Expenses General government 2,798,491 2,604,600 - - 2,798,491 2,604,600 Public safety 3,168,835 3,089,673 - - 3,168,835 3,089,673 Public works 5,556,590 4,833,405 - - 5,556,590 4,833,405 Sanitation 784,052 754,132 - - 784,052 754,132 Recreation and culture 3,874,315 3,190,466 - - 3,874,315 3,190,466 Economic development - - - - - - Interest and fiscal charges 480,903 660,352 - - 480,903 660,352 Water - - 1,348,348 1,265,578 1,348,348 1,265,578 Sewer - - 3,232,878 3,048,580 3,232,878 3,048,580 Stormwater - - 797,995 732,851 797,995 732,851 Liquor - - 6,320,611 6,117,772 6,320,611 6,117,772 Fiber optics - - 2,005,196 2,081,312 2,005,196 2,081,312 Deputy registrar - - 785,822 596,933 785,822 596,933 Total expenses 16,663,186 15,132,628 14,490,850 13,843,026 31,154,036 28,975,654 Increase in net position before transfers 1,318,862 5,206,888 2,054,156 2,869,224 3,373,018 8,076,112 Transfers - (200,000) - 200,000 - - Change in net position 1,318,862 5,006,888 2,054,156 3,069,224 3,373,018 8,076,112 Net position, January 1, as previously reported 77,489,748 78,950,000 61,718,691 58,649,467 139,208,439 137,599,467 Reclassification of component unit - (6,467,140) - - - (6,467,140) Net position, January 1 77,489,748 72,482,860 61,718,691 58,649,467 139,208,439 131,132,327 Net position, December 31 78,808,610$ 77,489,748$ 63,772,847$ 61,718,691$ 142,581,457$ 139,208,439$ Governmental Activities Business-Type Activities Total 16 Business-type Activities. Business-type activities increased the city’s net position by $2,054,156, which is $1,015,068 less than the prior fiscal year’s increase in business-type net position. The change is mostly attributable to a larger investment loss from a decline in investment value. Investment values held to maturity will regain value over time. FINANCIAL ANALYSIS OF THE CITY’S FUNDS Governmental funds. The focus of the city’s governmental funds is to provide information on near-term inflows, outflows, and balances of spendable resources. Such information is useful in assessing the city’s financing requirements. Spendable fund balances may serve as a useful measure of a government’s net resources available for expenditure at the end of the fiscal year. On December 31, 2022, the city’s governmental funds reported total ending fund balances of $22,917,518, a decrease of $369,458 (1.6%) when compared with the prior year. Approximately 9.1% or $2,090,545 of the total ending fund balances constituted restricted fund balances, which are considered unavailable for appropriation for general operations. The $139,980 nonspendable fund balance accounted for 0.6% of total governmental fund balances and is comprised of prepaid items. At the end of the fiscal year, the General Fund reported a fund balance of $7,042,796, increasing $418,014 (6.3%) from the prior year. General fund revenues were $2685,566 (2.6%) more than the prior fiscal year and expenditures increased by $702,099 (6.7%). General government expenditures increased $45,434 (1.7%) due to the addition of a full-time administrative employee and the 2022 elections. Public safety expenditures increased $115,700 (4.0%) due to repairs to fire engine 12 and the first year of an additional full-time building inspector. Public works expenditures increased $276,657 (13.0%) due to increased fuel and supply costs as well as the first full year of an additional employee in the engineering department. Recreation and culture expenditures increased by $234,388 (16.1%) due to increased public arts projects, increases in fuel and supply costs, and an additional full-time employee in the parks department. The fund balance in the Community Center Fund increased $59,681 (15.3%) to $449,419 due to the city’s allocation of a portion of the American Rescue Plan Act funding for lost revenues and an increase in charges for services for memberships and day passes. The Community Center continued to recover from the impacts of the COVID-19 pandemic. Charges for services increased $259,653 (25.8%) to $1,007,790 in 2022. Expenditures increased $636,000 (34.2%) to $1,858,328 as usage increased and staffing levels were increased. 17 The fund balance in the Debt Service Fund decreased $149,905 (13.3%) to $974,305. This fund balance decrease reflects the prior year accumulation of resources to make scheduled bond payments. Special assessment revenue increased $44,320 (9.4%) to $317,269 due to several prepaid assessments related to the 2022 street project. In governmental funds, assessments are recorded as a revenue when collectible, which occurs when it is in the current period or soon thereafter. The Capital Projects Fund provides the accounting for acquisition of general government capital assets. Accordingly, the fund accumulates resources from various sources and expenditures may or may not occur in the same year of accumulation. Consequently, the fund balance in the Capital Projects Fund decreased $993,870 (8.4%) to $10,868,750. Proprietary funds. The proprietary funds provide the same type of information found in the business-type activities in the government-wide financial statements, but in more detail. Water Fund operating expenses increased $80,143 (6.4%). Utility employee personal service costs are divided between the Water Fund and Sewer Fund based on activity. The Water Fund operating revenues decreased $12,680 (0.7%) with an increase in rates but a decrease in consumption. The fund’s net position increased $530,691 (3.7%) to $15,043,024 due to commercial development trunk and access fees received. Depreciation expense for the fund totaled $497,021. Sewer Fund expenses increased $200,021 (6.7%) and operating revenues increased $239,472 (8.9%). The 2022 capital contributions of $1,082,894 were from sewer access and trunk charges. The fund’s net position increased $615,143 (2.5%) to $24,798,517. Depreciation expense for the fund totaled $1,199,870. The Stormwater Fund was established in 2019. Stormwater operating expenses increased $65,144 (8.9%). Stormwater operating revenues increased $172,688 (48.4%), due to an increase in rate along with an increased number of accounts in 2022. The fund’s net position decreased $87,821 (1.4%) to $6,353,0015. Depreciation expense for the fund totaled $467,342. The Liquor Fund’s net position increased $777,760 (40.3%) to $2,708,099. Liquor and related product sales increased $64,017 (0.9%) to $7,168,374. Profits from the liquor store are held until transferred out for another city use. Gross profit increased $8,529 (0.4%) for a total gross profit of $1,912,345. Operating expenses increased $144,854 (15.9%) to $1,058,027, and depreciation expense for the fund totaled $20,923. The Fiber Optics Fund’s net position increased $209,014 (1.7%) to $12,476,588. The fund’s 2022 charges for services increased $33,373 (1.7%) to $1,978,590. Excluding depreciation, the operating income was $573,904 in 2022. Depreciation expense for the fund totaled $380,890. The city contracted for FiberNet operations management in July 2016 and renewed the contract for an additional five-year term in 2021. The Deputy Registrar Fund (DMV) net position increased $41,701 (1.8%) to $2,356,053. Charges for services decreased $52,308 (5.6%) to $895,494 and operating expenses increased $184,982 (31.2%) to $777,236. Depreciation for the fund totaled $20,975. Other factors of the changes in income from operations have previously been discussed in the government-wide financial analysis of business-type activities. GENERAL FUND BUDGETARY HIGHLIGHTS During the year, there were no amendments to the budget. General Fund revenues and other financing sources totaled $11,119,229 and exceeded the budget by $589,229 (5.6%). Other revenues, charges for services, intergovernmental revenues, licenses and permits and charges for services, were $314,307 (49.5%), $238,291 (21%), $146,105 (31.6%), and $141,914 (30.1%) higher than budget, respectively. Other revenues include donations and solar investment rebates, charges for services include charges to developers for private project related activity, intergovernmental revenues include grants from other governmental entities, and licenses and permits include building permits fees. These revenues can be difficult to predict, and are, therefore, budgeted conservatively. General Fund expenditures totaled $10,551,215 and were $27,215 (0.3%) over the budget. Other financing uses consisted of unbudgeted transfers out of $150,000 to the Facilities Maintenance Fund to establish a fund reserve balance. This transfer is in line with the General Fund balance policy of 60-75% of the following year’s budgeted expenditures. While spending in some budget units exceeded appropriations, conservative spending in other units and revenues more than budget allowed for an overall increase in fund balance. The General government function exceeded budget due to unbudgeted planning and zoning projects that are offset by grant funding and charges for services revenues. The public safety function exceeded budget because of unbudgeted expenditures in the building department; increased building activity allowed the use of these one-time revenues to fund one-time unbudgeted expenditures including investment in staff vehicles. Within the expenditure functions, twelve of twenty-eight reporting units exceeded budget. 18 The General Fund year end fund balances for the past ten years are as follows: CAPITAL ASSETS AND DEBT ADMINISTRATION CAPITAL ASSETS Capital assets. The city’s investment in capital assets for its governmental and business-type activities on December 31, 2022 totaled $113,912,817 (net of accumulated depreciation). This investment in capital assets includes land, construction in progress, buildings, and systems (including infrastructure), and machinery and equipment (including intangible assets). Major governmental activities capital assets changes: the purchases of land for a future public works facility site and a separate land purchase for the Pointes at Cedar development project, the completion of phase 1 of Bertram Chain of Lakes Park improvements, the completion of the Walnut Street Pedestrian improvement project, and equipment purchases. Business-type capital assets include a storm pond expansion and the completion of the DMV relocation. The total decrease from the prior fiscal year was 1.7%; governmental activities decreased 1.0% and business-type activities decreased 3.0%. Additional information on the city’s capital assets can be found in the notes to the financial statements starting on page 46. DEBT ADMINISTRATION Long-term Debt. The city’s outstanding long-term debt, including general obligation bonds, special assessment bonds, tax abatement bonds, and a Public Facilities Authority (PFA) revenue note, totaled $21,725,000 on December 31, 2022. Business-type long-term debt decreased with regularly scheduled payments. No new debt was issued in 2022. Additional information on the city’s long-term liabilities can be found in the notes to the financial statements starting on page 47 of this report. 2022 2021 2022 2021 2022 2021 Land 16,903,464$ 16,903,464$ 804,010$ 786,010$ 17,707,474$ 17,689,474$ Construction in progress 1,696,704 700,918 921,047 365,874 2,617,751 1,066,792 Buildings and systems 105,739,455 104,840,572 106,413,498 105,904,418 212,152,953 210,744,990 Machinery and equipment 10,055,983 9,052,011 3,570,582 3,377,654 13,626,565 12,429,665 Less: Accumulated depreciation (62,427,787) (58,809,034) (69,764,139) (67,192,471) (132,191,926) (126,001,505) Net total 71,967,819$ 72,687,931$ 41,944,998$ 43,241,485$ 113,912,817$ 115,929,416$ Governmental Activities Business-Type Activities Total 2022 2021 2022 2021 2022 2021 General obligation bonds 5,435,000$ 5,960,000$ 1,325,000$ 1,525,000$ 6,760,000$ 7,485,000$ Special assessment bonds 6,780,000 8,050,000 - - 6,780,000 8,050,000 Tax abatement bonds 6,700,000 7,280,000 - - 6,700,000 7,280,000 Public Facilities Authority revenue note - - 1,485,000 1,591,000 1,485,000 1,591,000 Total 18,915,000$ 21,290,000$ 2,810,000$ 3,116,000$ 21,725,000$ 24,406,000$ Activities Activities Total Governmental Business-Type 19 ECONOMIC FACTORS AND NEXT YEAR’S BUDGETS AND RATES • The effects of the Coronavirus (COVID-19) pandemic were still an impact, although a lessening impact, to the city. While the overall long-term effects of the pandemic are difficult to predict, the city expects manageable impacts and continues to look for ways to reduce costs as needed to ensure continued sound financial standing. • The unemployment rate for the Wright County, Minnesota area for December 31, 2022 was 3.6%, which is higher than the state average (3.1%) and equal to the national average (3.6%). • New commercial and residential development continued to grow at a sustainable pace in 2022 and have not indicated a significant downward trend yet in 2023. • The occupancy rate of the city’s business district has remained constant over the last few years and new commercial construction is continuing to grow. • The prospects for continued residential and large commercial growth in 2023 look promising. • Inflationary trends in the region have compared favorably to national indices in the last few years; however, the nationwide effects of inflation in housing prices are found in Monticello as well. • The property valuation of the city’s largest taxpayer, the Xcel Energy Nuclear Generating Plant, is assessed by the State of Minnesota and can experience notable volatility. The city continues to advocate for host communities at the state level through the Coalition of Utility Cities to minimize impacts on its residents and businesses. REQUESTS FOR INFORMATION This financial report is designed to provide a general overview of the city’s finances for all those interested in governmental finance. Questions concerning any information in the report or requests for additional information should be addressed to City of Monticello, Finance Department, 505 Walnut Street, Suite 1, Monticello, MN 55362. 20 BASIC STATEMENTS 21 CITY OF MONTICELLO Statement of Net Position December 31, 2022 Component Unit Economic Governmental Business-type Development Activities Activities Total Authority ASSETS Cash and investments 26,029,454$ 24,532,640$ 50,562,094$ 4,404,995$ Receivables Unremitted taxes 77,500 - 77,500 12,121 Delinquent taxes 53,845 - 53,845 4,409 Unremitted special assessments 4,226 2,357 6,583 - Delinquent special assessments 14,612 31,182 45,794 - Deferred special assessments 3,613,654 758,077 4,371,731 - Accrued interest 124,977 - 124,977 - Accounts 366,804 842,414 1,209,218 16,103 Due from other governmental units 20,655 129,035 149,690 - Leases 792,512 646,977 1,439,489 - Internal balances (37,551) 37,551 - - Inventory - 530,707 530,707 - Prepaid items 197,760 60,965 258,725 2,362 Notes receivable 130,422 - 130,422 433,743 Land held for resale 837,582 - 837,582 2,169,536 Capital assets Nondepreciable 18,600,168 1,725,057 20,325,225 - Depreciable, net 53,367,651 40,219,941 93,587,592 - Total Assets 104,194,271 69,516,903 173,711,174 7,043,269 DEFERRED OUTFLOWS OF RESOURCES Deferred other post-employment benefits resources 8,580 4,290 12,870 237 Deferred pension resources 1,407,419 499,768 1,907,187 37,622 Total Deferred Outflows of Resources 1,415,999 504,058 1,920,057 37,859 LIABILITIES Accounts and contracts payable 697,714 700,392 1,398,106 152,474 Accrued interest payable 18,484 9,229 27,713 - Other accrued liabilities 286,263 10,123 296,386 - Due to other governmental units 46,350 291,243 337,593 326 Unearned revenue 445,328 - 445,328 - Escrow deposits 894,608 - 894,608 - Noncurrent liabilities Due within one year Bonds, notes, leases, claims, compensated absences 2,495,669 404,092 2,899,761 12,372 Due in more than one year Net pension liability - PERA 3,168,476 1,583,165 4,751,641 119,179 Net pension liability - FRA 180,758 - 180,758 - Net OPEB liability 111,705 54,162 165,867 2,537 Bonds, notes, leases, claims, compensated absences 16,725,630 2,508,233 19,233,863 1,375 Total Liabilities 25,070,985 5,560,639 30,631,624 288,263 DEFERRED INFLOWS OF RESOURCES Deferred other post-employment benefits resources 55,287 25,450 80,737 487 Deferred pension resources 224,385 21,867 246,252 1,646 Deferred MSA state aid and grants 675,077 - 675,077 - Deferred lease resources 775,926 640,158 1,416,084 - Total Deferred Inflows of Resources 1,730,675 687,475 2,418,150 2,133 NET POSITION Net investment in capital assets 52,824,487 38,793,527 91,618,014 - Restricted for Debt service 2,237,657 - 2,237,657 - Economic development 898,209 - 898,209 1,411,774 Cemetery maintenance 117,325 - 117,325 - Park improvements 100,706 - 100,706 Tax increment - - - 509,401 Unrestricted 22,630,226 24,979,320 47,609,546 4,869,557 Total Net Position 78,808,610$ 63,772,847$ 142,581,457$ 6,790,732$ Primary Government The notes to the financial statements are an integral part of this statement.22 Statement of Activities For the Year Ended December 31, 2022 Operating Capital Charges for Grants and Grants and Expenses Services Contributions Contributions Governmental activities General government 2,798,491$ 989,086$ 88,183$ -$ Public safety 3,168,835 956,541 244,488 - Public works 5,556,590 147,269 231,322 1,379,488 Sanitation 784,052 750,623 20,112 - Recreation and culture 3,874,315 1,473,281 410,718 150,000 Economic development - 14,032 - - Interest and fiscal charges 480,903 - 197,925 - Total governmental activities 16,663,186 4,330,832 1,192,748 1,529,488 Business-type activities Water 1,348,348 1,769,524 76,233 259,504 Sewer 3,232,878 2,925,917 166,458 1,082,894 Stormwater 797,995 529,146 54,917 180,523 Liquor 6,320,611 7,174,059 - - Fiber Optics 2,005,196 2,195,092 - - Deputy Registrar 785,822 895,494 - - Total business-type activities 14,490,850 15,489,232 297,608 1,522,921 Total primary government 31,154,036$ 19,820,064$ 1,490,356$ 3,052,409$ Component Unit Economic Development Authority 2,508,996$ 976,553$ 375,547$ -$ General Revenues Property taxes Tax increments Franchise taxes Unrestricted investment earnings (loss) Total general revenues Change in Net Position Net Position, January 1 Net Position, December 31 Program Revenues Functions/Programs The notes to the financial statements are an integral part of this statement.23 CITY OF MONTICELLO Component Unit Economic Governmental Business-type Development Activities Activities Total Authority (1,721,222)$ -$ (1,721,222)$ -$ (1,967,806) - (1,967,806) - (3,798,511) - (3,798,511) - (13,317) - (13,317) - (1,840,316) - (1,840,316) - 14,032 - 14,032 - (282,978) - (282,978) - (9,610,118) - (9,610,118) - - 756,913 756,913 - - 942,391 942,391 - - (33,409) (33,409) - - 853,448 853,448 - - 189,896 189,896 - - 109,672 109,672 - - 2,818,911 2,818,911 - (9,610,118) 2,818,911 (6,791,207) - - - - (1,156,896) 11,456,764 - 11,456,764 390,432 - - - 720,301 388,074 53,000 441,074 - (915,858) (817,755) (1,733,613) (115,830) 10,928,980 (764,755) 10,164,225 994,903 1,318,862 2,054,156 3,373,018 (161,993) 77,489,748 61,718,691 139,208,439 6,952,725 78,808,610$ 63,772,847$ 142,581,457$ 6,790,732$ Net (Expense) Revenue and Changes in Net Position The notes to the financial statements are an integral part of this statement.24 CITY OF MONTICELLO Balance Sheet Governmental Funds 401 101 226 Linked 402 400 Total Total Community Debt Capital Nonmajor Governmental General Center Service Projects Funds Funds ASSETS Cash and investments 8,412,721$ 473,255$ 972,580$ 10,913,353$ 3,407,777$ 24,179,686$ Receivables Unremitted taxes 77,500 - - - - 77,500 Delinquent taxes 53,845 - - - - 53,845 Unremitted special assessments - - 4,226 - - 4,226 Delinquent special assessments - - 11,461 3,151 - 14,612 Deferred special assessments 146 - 1,270,376 2,338,901 4,231 3,613,654 Accrued interest 124,977 - - - - 124,977 Accounts 242,615 79,658 - - 44,531 366,804 Due from other governmental units 20,172 - - - - 20,172 Leases 792,512 - - - - 792,512 Prepaid items 113,530 25,932 - - 518 139,980 Notes receivable - - - - 130,422 130,422 Land held for resale - - - 837,582 - 837,582 Total Assets 9,838,018$ 578,845$ 2,258,643$ 14,092,987$ 3,587,479$ 30,355,972$ LIABILITIES Accounts and contracts payable 367,994$ 54,279$ 2,502$ 207,108$ 1,000$ 632,883$ Other accrued liabilities 266,814 19,449 - - - 286,263 Due to other governmental units 37,001 9,258 - - - 46,259 Unearned revenue 398,888 46,440 - - - 445,328 Escrow deposits 894,608 - - - - 894,608 Total liabilities 1,965,305 129,426 2,502 207,108 1,000 2,305,341 DEFERRED INFLOWS OF RESOURCES Unavailable revenue - property taxes 53,845 - - - - 53,845 Unavailable revenue - special assessments 146 - 1,281,836 2,342,052 4,231 3,628,265 Unavailable revenue - MSA state aid and grants - - - 675,077 - 675,077 Deferred lease resources 775,926 - - - - 775,926 Total deferred inflows of resources 829,917 - 1,281,836 3,017,129 4,231 5,133,113 FUND BALANCES Nonspendable 113,530 25,932 - - 518 139,980 Restricted - - 974,305 - 1,116,240 2,090,545 Assigned - 423,487 - 10,868,750 2,465,490 13,757,727 Unassigned 6,929,266 - - - - 6,929,266 Total fund balance 7,042,796 449,419 974,305 10,868,750 3,582,248 22,917,518 Total Liabilities, Deferred Inflows Of resources, and Dun Balances 9,838,018$ 578,845$ 2,258,643$ 14,092,987$ 3,587,479$ 30,355,972$ December 31, 2022 The notes to the financial statements are an integral part of this statement.25 CITY OF MONTICELLO Reconciliation of the Governmental Funds Balance Sheet to the Statement of Net Position December 31, 2022 Amounts reported for governmental activities in the Statement of Net Position are different because: Total fund balances - governmental funds 22,917,518$ Capital assets used in governmental activities are not financial resources and, therefore, are not reported in the funds. Land 16,903,464$ Construction in progress 1,696,704 Buildings and systems 105,739,455 Machinery and equipment 5,636,889 Accumulated depreciation (60,901,374)69,075,138 Governmental funds do not report long-term amounts related to other post-employment benefits and pensions. Deferred outflows of resources - OPEB 8,580$ Deferred outflows of resources - pensions 1,407,419 Deferred inflows of resources - OPEB (55,287) Deferred inflows of resources - pensions (224,385) 1,136,327 Long-term liabilities that pertain to governmental funds, including bonds payable, are not due and payable in the current period, and, therefore, are not reported as fund liabilities. All liabilities, both current and long-term, are reported in the Statement of Net Position. Bonds payable (18,795,000)$ Other post-employment benefits liability (111,705) Net pension liability - PERA (3,168,476) Net pension liability - FRA (180,758) (22,255,939) Internal service funds are used by management to charge the costs of facilities maintenance, equipment, information technology, and benefit accrual services to individual funds. The assets and liabilities of the internal service funds are included in governmental activities in the Statement of Net Position. Internal service fund net position included in the governmental activities 4,309,342$ Less internal services net position allocated to business-type activities (37,551) 4,271,791 Some of the city's property taxes, special assessments, and notes receivable will be collected after year-end, but are not available soon enough to pay for current period expenditures and, therefore, are reported as deferred inflows of resources in the governmental funds.3,682,110 Interest on long-term debt is not accrued in governmental funds, but rather is recognized as an expenditure when due. Accrued interest for general obligation bonds is included in the Statement of Net Position.(18,335) Net position of governmental activities 78,808,610$ The notes to the financial statements are an integral part of this statement.26 CITY OF MONTICELLO Statement of Revenues, Expenditures and Changes in Fund Balance Governmental Funds For the Year Ended December 31, 2022 401101226Linked402 Linked 400 Total Total Community Debt Capital Nonmajor Governmental General Center Service Projects Funds Funds Revenues Property taxes 7,485,252$ 485,000$ 2,311,400$ 1,153,476$ -$ 11,435,128$ Franchise taxes 226,690 - - - 161,384 388,074 Special assessments 418 - 317,269 400,236 850 718,773 Licenses and permits 613,014 - - - - 613,014 Intergovernmental 609,105 385,718 - 596,684 150,000 1,741,507 Charges for services 1,398,877 1,007,790 - 26,865 212,670 2,646,202 Fines and forfeitures 36,808 - - - - 36,808 Investment earnings (loss)(200,442) (10,799) (53,739) (459,248) (121,300) (845,528) Interest on loans - - - - 3,873 3,873 Other revenues 949,507 50,300 197,925 7,088 - 1,204,820 Total revenues 11,119,229 1,918,009 2,772,855 1,725,101 407,477 17,942,671 Expenditures Current General government 2,684,854 - - - - 2,684,854 Public safety 2,989,883 - - - - 2,989,883 Public works 2,400,555 - - 5,654 - 2,406,209 Sanitation 784,052 - - - - 784,052 Recreation and culture 1,691,871 1,764,309 - - 27,160 3,483,340 Capital outlay Public safety - - - 727,239 - 727,239 Public works - - - 2,094,879 37,993 2,132,872 Recreation and culture - 94,019 - - 45,702 139,721 Debt service Principal - - 2,315,000 - - 2,315,000 Interest and fiscal charges - - 498,959 - - 498,959 Total expenditures 10,551,215 1,858,328 2,813,959 2,827,772 110,855 18,162,129 Excess (deficiency) of revenues over (under) expenditures 568,014 59,681 (41,104) (1,102,671) 296,622 (219,458) Other financing sources (uses) Transfers in - - - 108,801 - 108,801 Transfers out (150,000) - (108,801) - - (258,801) Total other financing sources (uses)(150,000) - (108,801) 108,801 - (150,000) Net change in fund balances 418,014 59,681 (149,905) (993,870) 296,622 (369,458) Fund balance at beginning of year 6,624,782 389,738 1,124,210 11,862,620 3,285,626 23,286,976 Fund balance at end of year 7,042,796$ 449,419$ 974,305$ 10,868,750$ 3,582,248$ 22,917,518$ The notes to the financial statements are an integral part of this statement.27 CITY OF MONTICELLO Reconciliation of the Statement of Revenues, Expenditures and Changes in Fund Balances of Governmental Funds to the Statement of Activities For the Year Ended December 31, 2022 Amounts reported for governmental activities in the Statement of Activities are different because Net change in fund balances - governmental funds (369,458)$ Governmental funds reported capital outlays as expenditures. However, in the Statement of Activities the cost of those assets is allocated over their estimated useful lives and reported as depreciation expense. This is the amount by which capital outlays exceeded depreciation in the current period. Capital outlays 2,719,930$ Depreciation (3,637,979) (918,049) Repayment of long-term debt principal is an expenditure in the governmental funds, but the repayment reduces long-term liabilities in the Statement of Net Position.2,315,000 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 the governmental funds. Amortization of bond premiums 18,869$ Change in total OPEB liability and deferred outflows/inflows of resources 12,608 Change accrued interest payable 4,338 35,815 Long-term pension activity is not reported in governmental funds Pension revenue from state contributions 13,881 Pension expense (55,662) Deferred inflows of resources are revenues included in the change in net position, but are excluded from the change in fund balances until they are available to liquidate liabilities of the current period. Taxes 21,636$ Special assessments 64,031 85,667 Internal service funds are used by management to charge the costs of certain activities to individual funds. The net revenue of the internal service funds is reported with governmental activities. Internal service fund activity included in governmental activities 179,336$ Subtract internal service fund activity allocated to business-type activities 32,332 211,668 Change in net position of governmental activities 1,318,862$ The notes to the financial statements are an integral part of this statement.28 Statement of Net Position Proprietary Funds December 31, 2022 661 662 663 601 602 652 Water Sewer Stormwater ASSETS Current assets Cash and investments 6,769,830$ 9,856,687$ 1,627,949$ Receivables Unremitted special assessments Unremitted special assessmentsUnremitted special assessments 2,357 - - Delinquent special assessments Delinquent special assessmentsDelinquent special assessments 7,978 23,204 - Deferred special assessments Deferred special assessmentsDeferred special assessments 344,299 300,471 113,307 Account receivable Account receivableAccounts 190,347 477,831 35,574 Account receivable Account receivableDue from other governmental units - - - Lease 16,187 - - Inventory - - - Prepaid items 17,000 29,896 3,336 Total current assets 7,347,998 10,688,089 1,780,166 Noncurrent assets Lease Receivable 630,790 - - Capital assets Land 208,143 516,952 73,315 Buildings and systems 21,304,719 48,618,921 19,558,516 Machinery and equipment 326,043 2,594,663 150,803 Construction in progress 399,008 399,009 123,030 Total capital assets Total capital assets 22,237,913 52,129,545 19,905,664 Less accumulated depreciation (14,204,028) (34,830,422) (15,230,343) Total capital assets (net)8,033,885 17,299,123 4,675,321 Total noncurrent assets Total noncurrent assets Total noncurrent assets Total noncurrent assets 8,664,675 17,299,123 4,675,321 Total Assets 16,012,673 27,987,212 6,455,487 DEFERRED OUTFLOWS OF RESOURCES Deferred other post-employment benefits resources 824 912 487 Deferred pension resources 69,963 96,966 37,529 Total Deferred Outflows of Resources 70,787 97,878 38,016 LIABILITIES Current liabilities Accounts and contracts payable 114,677 114,524 12,743 Accrued interest payable - 9,229 - Other accrued liabilities 7,583 - - Due to other governmental units 13,928 2,451 - Bonds and loans payable - current - 312,000 - Compensated absences due within one year 19,490 19,490 - Total current liabilities 155,678 457,694 12,743 Noncurrent liabilities Bonds and loans payable - net current portion - 2,498,000 - Compensated absences payable 2,166 2,166 - Total OPEB liability 11,517 11,987 5,323 Net pension liability 221,629 307,169 118,885 Total noncurrent liabilities 235,312 2,819,322 124,208 Total Liabilities 390,990 3,277,016 136,951 DEFERRED INFLOWS OF RESOURCES Deferred other post-employment benefits resources 6,227 5,314 1,895 Deferred pension resources 3,061 4,243 1,642 Deferred lease resources 640,158 - - Total Deferred Inflows of Resources 649,446 9,557 3,537 NET POSITION Net investment in capital assets 7,922,485 14,377,723 4,663,002 Unrestricted 7,120,539 10,420,794 1,690,013 Total Net Position 15,043,024$ 24,798,517$ 6,353,015$ Business-Type Activities – Enterprise Funds The notes to the financial statements are an integral part of this statement.29 CITY OF MONTICELLO Governmental Activities - 609 656 653 Deputy Internal Liquor Fiber Optics Registrar Totals Service Funds 2,809,741$ 1,228,402$ 2,240,031$ 24,532,640$ 1,849,768$ - - - 2,357 - - - - 31,182 - - - - 758,077 - - 137,662 1,000 842,414 - - 53,000 76,035 129,035 483 - - - 16,187 - 530,707 - - 530,707 - 8,118 1,000 1,615 60,965 57,780 3,348,566 1,420,064 2,318,681 26,903,564 1,908,031 - - - 630,790 - 5,600 - - 804,010 - 848,997 15,466,136 616,209 106,413,498 - 152,672 305,726 40,675 3,570,582 4,419,094 - - - 921,047 - 1,007,269 15,771,862 656,884 111,709,137 4,419,094 (930,926) (4,477,819) (90,601) (69,764,139) (1,526,413) 76,343 11,294,043 566,283 41,944,998 2,892,681 76,343 11,294,043 566,283 42,575,788 2,892,681 3,424,909 12,714,107 2,884,964 69,479,352 4,800,712 1,281 - 786 4,290 - 163,306 - 132,004 499,768 - 164,587 - 132,790 504,058 - 220,203 237,519 726 700,392 64,831 - - - 9,229 149 2,540 - - 10,123 - 72,419 - 202,445 291,243 91 - - - 312,000 60,000 35,459 - 17,653 92,092 275,669 330,621 237,519 220,824 1,415,079 400,740 - - - 2,498,000 60,000 3,940 - 1,961 10,233 30,630 15,230 - 10,105 54,162 - 517,320 - 418,162 1,583,165 - 536,490 - 430,228 4,145,560 90,630 867,111 237,519 651,052 5,560,639 491,370 7,141 - 4,873 25,450 - 7,145 - 5,776 21,867 - - - - 640,158 - 14,286 - 10,649 687,475 - 76,343 11,187,691 566,283 38,793,527 2,751,458 2,631,756 1,288,897 1,789,770 24,941,769 1,557,884 2,708,099$ 12,476,588$ 2,356,053$ 63,735,296 4,309,342$ Adjustment to reflect the cumulative internal balance for the net effect of the activity between the internal service funds and the enterprise funds over time 37,551 Net position of business-type activities (pg. 19)63,772,847$ Business-Type Activities – Enterprise Funds The notes to the financial statements are an integral part of this statement.30 Statement of Cash Flows Proprietary Funds For the Year Ended December 31, 2022 661 662/602 663/652 601 602 652 Water Sewer Stormwater Cash flows from operating activities Cash received from customers and users 1,717,471$ 2,891,744$ 557,811$ Cash from interfund services provided - - - Cash paid to suppliers for goods and services (473,153) (1,453,471) (103,108) Cash paid to employees (309,857) (426,448) (171,721) Cash paid to other funds for services provided (42,271) (26,661) - Net cash provided by operating activities 892,190 985,164 282,982 Cash flows from noncapital financing activities Transfers from other funds - - - Franchise fees - - - Intergovernmental revenues 76,233 166,458 54,917 Net cash provided by noncapital financing activities 76,233 166,458 54,917 Cash flows from capital and related financing activities Capital contributions 283,058 1,230,073 205,209 Acquisition of capital assets (179,331) (263,328) (279,514) Principal paid on long-term debt - (306,000) - Interest and fiscal charges paid on long-term debt - (61,817) - Net cash provided (used) by capital and related financing activities 103,727 598,928 (74,305) Cash flows from investing activities Interest on investments (loss)(232,824) (334,719) (54,412) Net increase (decrease) in cash and cash equivalents 839,326 1,415,831 209,182 Cash and cash equivalents, January 1 5,930,504 8,440,856 1,418,767 Cash and cash equivalents, December 31 6,769,830$ 9,856,687$ 1,627,949$ Operating income (loss)427,778$ (254,039)$ (268,849)$ Adjustments to reconcile operating income (loss) to net cash provided by operating activities Depreciation 497,021 1,199,870 467,342 OPEB expense 438 511 (2,686) (Increase) decrease in assets Special assessments receivable (25,796) (22,072) - Accounts receivable (23,718) (34,703) (10,467) Due from other governmental units 9,590 22,602 39,132 Leases (646,977) - - Inventory - - - Prepaid items (1,419) 57,413 1,614 (Increase) decrease in deferred outflows Deferred other post-employment benefits resources 5 5 3 Deferred pension resources 988 (8,275) (37,529) Increase (decrease) in liabilities Accounts and contracts payable (16,021) (49,516) (28,000) Other liabilities (5,310) - - Due to other governmental units 961 (41) - Compensated absences 1,549 1,549 - Net pension liability 122,556 183,325 118,885 Increase (decrease) in deferred inflows Deferred other post-employment benefits resources (1,625) (1,895) 1,895 Deferred pension resources (87,988) (109,570) 1,642 Deferred lease resources 640,158 - - Net cash provided by operating activities 892,190$ 985,164$ 282,982$ Schedule of noncash investing, capital and financing activities: Net amortization of bond premium (discount)-$ 15,553$ -$ Capital assets purchased on account 111,400$ 111,400$ 12,319$ Business-Type Activities – Enterprise Funds The notes to the financial statements are an integral part of this statement.31 CITY OF MONTICELLO Governmental Activities 609 656 653 Deputy Internal Liquor Fiber Optics Registrar Totals Service Funds 7,174,142$ 2,146,870$ 952,424$ 15,440,462$ -$ - - - - 1,568,426 (5,432,435) (1,669,489) (54,860) (9,186,516) (788,598) (745,265) - (551,017) (2,204,308) (227,831) (29,061) (820) (35,020) (133,833) - 967,381 476,561 311,527 3,915,805 551,997 - - - - 150,000 - 53,000 - 53,000 - - - - 297,608 - - 53,000 - 350,608 150,000 - - - 1,718,340 - (18,810) (199,209) (13,523) (953,715) (609,694) - - - (306,000) (60,000) - - - (61,817) (5,220) (18,810) (199,209) (13,523) 396,808 (674,914) (82,243) (37,000) (76,557) (817,755) (70,330) 866,328 293,352 221,447 3,845,466 (43,247) 1,943,413 935,050 2,018,584 20,687,174 1,893,015 2,809,741$ 1,228,402$ 2,240,031$ 24,532,640$ 1,849,768$ 860,003$ 193,014$ 118,258$ 1,076,165$ 104,817$ 20,923 380,890 20,975 2,587,021 411,756 730 - 1,229 222 - - - - (47,868) - - 1,836 (1,000) (68,052) 50,722 - (50,058) (9,590) 11,676 (483) - - - (646,977) - (106,911) - - (106,911) - 1,182 - 1,657 60,447 (4,279) 8 - (786) (765) - 31,814 - (25,575) (38,577) - 155,532 (49,121) (1,340) 11,534 (19,972) 83 - - (5,227) - 4,520 - 67,520 72,960 11 583 - 3,054 6,735 9,425 244,867 - 269,550 939,183 - (2,708) - (1,625) (5,958) - (243,245) - (130,800) (569,961) - - - - 640,158 - 967,381$ 476,561$ 311,527$ 3,915,805$ 551,997$ -$ -$ -$ 15,553$ -$ -$ 106,352$ -$ 341,471$ 21,223$ Business-Type Activities – Enterprise Funds The notes to the financial statements are an integral part of this statement.32 Statement of Revenues, Expenses and Changes in Net Position Proprietary Funds For the Year Ended December 31, 2022 661 662 663 601 602 652 Water Sewer Stormwater Sales and cost of sales Net sales Cost of sales Gross profit Operating revenues Charges for services 1,704,725$ 2,924,255$ 522,851$ Other 64,799 1,662 6,295 Total operating revenues 1,769,524 2,925,917 529,146 Operating expenses Personal services 345,780 492,098 253,931 Materials and supplies 163,865 151,579 2,089 Other services and charges 335,080 1,336,409 74,633 Depreciation 497,021 1,199,870 467,342 Total operating expenses 1,341,746 3,179,956 797,995 Operating income (loss)427,778 (254,039) (268,849) Nonoperating revenues (expenses) Franchise taxes - - - Investment earnings (loss)(232,824) (334,719) (54,412) Intergovernmental revenues 76,233 166,458 54,917 Interest expense - (45,451) - Total nonoperating revenues (expenses)(156,591) (213,712) 505 Income (loss) before capital contributions and transfers 271,187 (467,751) (268,344) Capital contributions 259,504 1,082,894 180,523 Transfers in - - - 530,691 615,143 (87,821) Change in net position - - - Net Position, January 1 14,512,333 24,183,374 6,440,836 Net Position, December 31 15,043,024$ 24,798,517$ 6,353,015$ Business-Type Activities – Enterprise Funds The notes to the financial statements are an integral part of this statement.33 CITY OF MONTICELLO Governmental Activities -609 656 653 Linked Deputy Internal Liquor Fiber Optics Registrar Totals Service Funds 7,168,374$ 7,168,374$ (5,256,029) (5,256,029) 1,912,345 1,912,345 - 1,978,590$ 889,451$ 8,019,872 1,422,052$ 5,685 216,502 6,043 300,986 96,135 5,685 2,195,092 895,494 8,320,858 1,518,187 777,314 - 666,064 2,535,187 237,256 24,696 87,515 7,807 437,551 106,065 235,094 1,533,673 82,390 3,597,279 658,293 20,923 380,890 20,975 2,587,021 411,756 1,058,027 2,002,078 777,236 9,157,038 1,413,370 860,003 193,014 118,258 1,076,165 104,817 - 53,000 - 53,000 - (82,243) (37,000) (76,557) (817,755) (70,330) - - - 297,608 - - - - (45,451) (5,151) (82,243) 16,000 (76,557) (512,598) (75,481) 777,760 209,014 41,701 563,567 29,336 - - - 1,522,921 - - - - - 150,000 777,760 209,014 41,701 2,086,488 179,336 - - - - 1,930,339 12,267,574 2,314,352 4,130,006 2,708,099$ 12,476,588$ 2,356,053$ 4,309,342$ Adjustment to reflect the consolidation of internal service fund related to enterprise funds (32,332) Change in net position of business-type activities (pg. 21)2,054,156$ Business-Type Activities – Enterprise Funds The notes to the financial statements are an integral part of this statement.34 NOTE 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES The basic financial statements of the City of Monticello, Minnesota (the city) have been prepared in conformity with accounting principles (GAAP) generally accepted in the United States of America as applied to governmental units by the Governmental Accounting Standards Board (GASB). GASB is the accepted standard-setting body for establishing governmental accounting and financial reporting principles. A. Reporting entity Incorporated in 1856, the City of Monticello is designated as a third-class city (population 10,001 to 20,000) and governed by statutory city code under Optional Plan A in Minnesota statutes. The city falls under section 501(a) of the Internal Revenue Code. The five-member mayor-council is elected on staggered, even-numbered years. Councilors are elected at-large to four-year terms while the mayor is elected to a two-year term. The governing body appoints an administrator to implement policies and oversee daily operations. The accompanying financial statements include all funds, departments, agencies, boards, commissions, and other organizations that comprise the city, along with any component units. Component units are legally separate entities for which the city (primary government) is financially accountable, or for which the exclusion of the component unit would render the financial statements of the primary government misleading. Criteria used to determine if the primary government is financially accountable for a component unit includes whether or not the primary government appoints the voting majority of the potential component unit’s governing body, is able to impose its will on the potential component unit, is in a relationship of financial benefit or burden with the potential component unit, or is fiscally depended upon by the potential component unit. The Monticello Economic Development Authority (EDA) is a legally separate entity created pursuant to Minnesota Statutes § 469.090 through § 469.108 to carryout economic and industrial development and redevelopment within the city in accordance with policies established by the City Council. The seven- member Board of Directors consists of two councilmembers and five members from the community appointed by the City Council. Management of the city has complete operational responsibility of the EDA’s activities, and the City Council reviews and approves the tax levy and all expenditures for the EDA. Because the council does not make up a majority of the EDA board and there is no financial burden or benefit relationship between the city and EDA, the EDA is reported as a discretely presented component unit of the city as a separate column in the government-wide financial statements. Separate financial statements are not issued for this component unit. The Mayor and Council are responsible for appointing some members of other organizations. However, the city’s accountability for these organizations does not extend beyond making appointments. 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 the activities of the primary government 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 segment are offset by program revenues. Direct expenses are those that are clearly identifiable with a specific function. 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 operation 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. Aggregated information for the remaining nonmajor funds is reported in single columns in the respective fund financial statements. 35 The city applies restricted resources first when an expense is incurred for which both restricted and unrestricted resources are available. Depreciation expense is included in the direct expense of each function. Interest on long-term debt of governmental activities is considered an indirect expense and is reported separately on the Statement of Activities. 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 fund 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 and special assessments, if levied, 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. 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 available when they are collectible in 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 are recorded when a liability is incurred, as under accrual accounting. However, debt service expenditures, as well as expenditures related to claims and judgments, compensated absences, other post-employment benefits, and net pension liabilities, are recognized as expenditures to the extent they have matured. Capital asset acquisitions are reported as capital outlay expenditures in the governmental funds. Proceeds from long-term debt are reported as other financing sources. Property taxes, franchise taxes, licenses, and investment interest associated with the current fiscal period are all considered to be susceptible to accrual and have been recognized as revenues of the current fiscal period. Only the portion of special assessments receivable due within the current fiscal period is susceptible to accrual as revenue of the current period. All other revenue items are 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 recourses to be used for specified purpose, and expenditure requirements, in which the resources are provided to the city of a reimbursement basis. On a modified accrual basis, revenue from non-exchange transactions must also be available before it can be recognized. Major Governmental Funds – The major governmental funds reported by the city are as follows: General Fund – The General Fund is used to account for all financial resources except those required to be accounted for in another fund. Community Center Fund – The Community Center (special revenue) Fund accounts for the revenues and expenditures related to the operations of the community center. In addition to a property tax allocation, the community center generates significant revenue from charges for memberships, program activities, and space rentals. Debt Service Fund – The Debt Service Fund is used to account for the accumulation of resources for and the payment of long-term debt principal, interest, and related costs. Capital Projects Fund – The Capital Projects Fund is used to account for financial resources to be used for the acquisition or construction of major capital facilities and infrastructure (other than those financed by proprietary funds). 36 Major Proprietary Funds – The city reports the following major proprietary (enterprise) funds: Water Fund – The Water Fund is used to account for all activities necessary to provide water services to the residents and businesses of the city. Sewer Fund – The Sewer Fund is used to account for all activities necessary to provide sewer services to the residents and businesses of the city. Stormwater Fund – The Stormwater Fund is used to account for all activities necessary to provide stormwater maintenance and street sweeping services to the residents and businesses of the city. Liquor Fund – The Liquor Fund is used to account for the operations of the city’s liquor store. Fiber Optics Fund – The Fiber Optics Fund is used to account for all activities necessary to provide fiber optic services to the residents and businesses of the city. Deputy Registrar Fund – The Deputy Registrar Fund is used to account for the operation of the city’s department of motor vehicles. Additionally, the city reports the following fund type: Internal Service Funds – These funds account for the city’s benefit accrual, central equipment, and information technology services. Internal service funds operate in a manner similar to enterprise funds; however, they provide services primarily to other city departments. As a general rule, the effect of interfund activity has been eliminated from the government-wide financial statements. Exceptions to this general rule are charges between the city’s enterprise funds and various other functions of the city. Elimination of these charges would distort the direct costs and program revenues of the various functions involved. Amounts reported as program revenues include 1) charges to customers or applicants for goods, services, or privileges provided, 2) operating grants and contributions, and 3) capital grants and contributions, including special assessments. Internally dedicated resources are reported as general revenues rather than as program revenues. Likewise, general revenues include all taxes the city has the authority to impose. Proprietary funds distinguish operating revenues and expenses from non-operating items. Operating revenues and expenses generally result from providing services and producing and delivering goods in connection with a proprietary fund’s principal ongoing operations. The principal operating revenues of the city’s enterprise and internal service funds are charges to customers for sales and services. Operating expenses for enterprise and internal service funds include cost of sales and services, administrative expenses, and depreciation on capital assets. All revenue and expenses not meeting this definition are reported as non-operating revenues and expenses. Aggregated information for the internal service funds is reported in a single column in the proprietary fund financial statements. Because the principal user of the internal services is the city’s governmental activities, the financial statements of the internal service funds are consolidated into the governmental column when presented in the government-wide financial statements. The cost of these services is reported in the appropriate functional activity. D. Cash and Investments Cash and investments include balances from all funds that are combined and invested to the extent available in savings accounts, certificates of deposit, U.S. government obligations, and other securities authorized by state statutes. Earnings from investments are allocated to the respective funds based on participation by each fund. For purposes of the Statement of Cash Flows, the city considers all highly liquid debt instruments with an original maturity from the time of purchase by the city of three months or less to be cash equivalents. The proprietary fund’s equity in the government-wide cash and investment management pool is considered cash equivalent. Investments are generally stated at fair value, except for investments in external investment pools, which are stated at amortized cost. Short-term highly liquid debt instruments (including commercial paper, banker’s acceptances, and U.S. treasury and agency obligations) purchased with a remaining maturity 37 of one year or less are reported at amortized cost. Investment income is accrued at the balance sheet date. The city categorizes its fair value measurements within the fair value hierarchy established by accounting principles generally accepted in the United States of America. The hierarchy is based on the valuation inputs used to measure the fair value of the asset as follows: • Level 1 inputs are quoted prices in active markets for identical assets. • Level 2 inputs are significant other observable inputs. • Level 3 inputs are significant unobservable inputs. Debt securities classified in Level 2 of the fair value hierarchy are valued using a matrix pricing technique. Matrix pricing is used to value securities based on the securities’ relationship to benchmark quoted price as outlined in Note 2. E. Property Taxes The city council sets property tax levies each year which are certified to Wright County for collection in the following year. In Minnesota, counties function as collection agents for all property taxes. Wright County spreads all levies over taxable property. Such taxes become a lien on January 1 and are recorded as receivables by the city on that date. Most property taxes can be paid without penalty and interest by taxpayers in two equal installments on May 15 and October 15. Wright County provides tax settlements to cities and other taxing districts three times throughout the year. Within the governmental fund financial statements, the city recognizes property tax revenue when it becomes both measurable and available to finance expenditures of the current period. Taxes which remain unpaid at December 31 are classified as delinquent taxes receivable and are offset by deferred inflows of resources because it is not available to finance current expenditures. Deferred inflows of resources in governmental activities are susceptible to full accrual on the government-wide financial statements. F. Special Assessments Special assessments are levied against the benefiting properties for the assessable costs of special assessment improvement projects in accordance with Minnesota Statutes. The city usually adopts assessment rolls when individual public improvement projects are complete or substantially complete. The assessments are collectible over a term of years generally consistent with the term of years for the related bond issue. Collection of annual installments (including interest) is managed by the county in the same manner as property taxes. Property owners are allowed to prepay total future installments without interest or prepayment penalties. Once a special assessment roll is adopted, the amount attributed to each parcel is a lien upon that property until full payment is made or the amount is determined to be excessive by the city council or court action. If special assessments are left unpaid, the property is subject to tax forfeited sale and the first proceeds of that sale (after costs, penalties, and expenses of sale) are remitted to the city in payment of delinquent special assessments. Generally, the city will collect the full amount of its special assessments not adjusted by city council or court action. Pursuant to state statutes, a property shall be subject to tax forfeit sale after three years of delinquency except for homesteaded, agricultural or seasonal recreational property, which is subject to sale after five years. These assessments are recorded as delinquent (levied, but not yet paid) and deferred (certified, but not yet levied) special assessments receivable, and are offset by deferred inflows of resources in the governmental fund financial statements. Unremitted special assessments are amounts collected by Wright County, but not paid to the city before year-end. 38 G.Receivables Utility and miscellaneous accounts receivable are reported at gross value. Since the city is generally able to certify delinquent amounts to the county for collection as special assessments, no allowance for uncollectible accounts has been provided on current receivables. The city contracted with a third party to manage Fibernet beginning on July 1, 2016. On a monthly basis, the city receives amounts billed by Arvig with an estimated portion withheld for uncollectible accounts. Customer receivable balances are carried by Arvig rather than the city. Therefore, no allowance for uncollectible accounts is set up in the proprietary Fiber Optics Fund. A receivable is considered past due if any portion of the receivable balance is outstanding for more than 30 days. Interest is charged on receivables that are considered past due. Accrual of interest is not suspended until a receivable is determined to be uncollectible. Provisions for bad debts would be insignificant and none have been made for 2022. Interest receivable is recorded as revenue in the year the interest is earned and is available to pay liabilities of the current period. The interest receivable balance is reported as one amount in the General Fund while all other funds receive interest revenue distributions in cash. H.Lease Receivable The City’s lease receivable is measured at the present value of lease payments expected to be received during the lease term. 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. I.Inventories The inventories of the proprietary funds are stated at cost using the first-in, first-out (FIFO) method. Enterprise fund inventory consists of merchandise held for resale at the city-owned Hi-Way Liquors store. J.Prepaid Items Payments to vendors for services that will benefit future accounting periods are recorded as prepaid. Prepaid items are accounted for using the consumption method. Fund balance in an amount equal to the prepaid balance in the related funds is not available for appropriation, and is, therefore, classified as nonspendable. K.Notes Receivable Notes receivable consist of loans made by the city or EDA to area businesses for development or redevelopment purposes. The terms and interest rates of the individual loans vary. Notes receivable that are passed through to another entity are offset by deferred inflows of resources in the governmental funds. L.Land Held for Resale Land held for resale is recorded in the governmental Capital Project Fund and discretely presented Economic Development Authority Fund component unit at the lower of cost or acquisition value. Fund balances are reported as restricted or assigned in an amount equal to the land’s carrying value as these assets are not available for appropriation. M.Capital Assets Capital assets, which include property, plant, equipment, and infrastructure assets (roads, bridges, sidewalks, and similar items) are reported in the applicable governmental or business-type activities columns in the government-wide financial statements and are not reported in the governmental funds financial statements. Such assets are capitalized at historical cost or estimated historical cost for assets where actual historical cost is not available. 39 Donated capital assets are recorded at their estimated acquisition value at the date of donation. The city’s capitalization policy divides each asset into a class with a related threshold and useful life as follows: Class of Asset Threshold Level Useful Life (Years) Land $1 N/A Land improvements $50,000 10 – 20 Building/building improvements $20,000 12 – 40 Primary infrastructure and utility $75,000 10 – 40 Secondary infrastructure $25,000 10 – 40 Equipment $10,000 5 – 20 Software and non-tangible $10,000 5 – 20 The cost of normal maintenance and repairs that does not add to the value of the asset or materially extend an asset’s useful life is not capitalized. In the case of initial capitalization of general infrastructure assets, the city elected to fully capitalize the infrastructure capital assets regardless of their acquisition date or amount. Capital assets are depreciated using the straight-line method over their estimated useful lives shown in the previous table. Since surplus assets are generally sold for an immaterial amount when no longer needed for city purposes, no salvage value is taken into consideration for depreciation purposes. Capital assets not being depreciated include land and construction in progress. M.Deferred Outflows of Resources In addition to assets, the Statement of Net Position and/or balance sheet will sometimes report a separate section for deferred outflows of resources. This separate financial statement element represents a consumption of net assets that applies to future periods and so will not be recognized as an outflow of resources (expense/expenditure) until that time. The city has two types of items, which arise under a full accrual basis of accounting, that qualify for reporting in this category. Accordingly, the items, deferred other post-employment benefits resources and deferred pension resources, are reported only in the Statement of Net Position. These items result from other post-employment benefits and pension-related actuarial calculations and current year contributions made subsequent to the measurement date. N.Long-Term Liabilities In the government-wide and proprietary fund financial statements, long-term debt and other long-term obligations are reported as liabilities. Bond premiums and discounts, if material, are deferred and amortized over the life of the bonds using the straight-line method. In the fund financial statements, governmental fund types recognize bond premiums and discounts during the period of issuance. Premiums received on debt issuances are reported as other financing sources while discounts on debt issuances are reported as other financing uses. The par amount of debt issued is reported as other financing sources. Issuance costs, whether withheld from the actual debt proceeds received or not, are reported as debt service expenditures. O.Compensated Absences Payable City employees earn vacation and sick leave or paid-time-off (PTO) based upon the number of completed years of service and employment status. All new full-time employees receive PTO, while one employee still receives vacation and sick leave benefits. Full-time employees who resign or leave city employment voluntarily and in good standing, after giving proper notice, shall be compensated for unused days under their respective plan upon termination of employment. PTO is credited at the beginning of each fiscal year for existing employees and prorated for the fiscal year for new and terminated employees. Vacation and sick leave are accrued by pay period. PTO benefit: Up to 320 hours accrued at year-end plus any current year hours earned to their date of severance multiplied by their hourly rate at the time of severance. 40 Vacation benefit: Up to 1-½ times the employees annual accrual multiplied by their hourly rate at the time of severance. Sick leave benefit: One-half of the unused sick leave up to 800 hours and all unused sick leave above 800 hours times their hourly rate at the time of severance. All compensated absences are accrued when incurred in the government-wide and proprietary fund financial statements. The liability for governmental funds is recorded in the Benefit Accrual (internal service) Fund. Resignations and retirements of employees reduce the liability in the Benefit Accrual Fund or the applicable enterprise fund. P.Pensions For purposes of measuring the net pension liability (asset), deferred outflows/inflows of resources, and pension expense, information about the fiduciary net position of the Public Employees Retirement Association (PERA) and Monticello Fire Relief (FRA) and additions to/deductions from each plan’s fiduciary net position have been determined on the same basis as they are reported by each plan. 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 Fund or applicable enterprise fund will be used to liquidate these liabilities. The following is a summary of the net pension liabilities, deferred outflows and inflows of resources, and pension expense reported for the PERA and FRA pension plans as of the year ended December 31, 2022: Deferred Deferred Net Pension Outflows of Inflows of Pension Pension Plan Liability Resources Resources Expense State-wide, mulit- employer - PERA 4,870,820$ 1,537,606$ 67,277$ 806,224$ Single-employer - FRA 180,758 407,203 180,621 137,845 5,051,578$ 1,944,809$ 247,898$ 944,069$ Q.Deferred Inflows of Resources In addition to liabilities, the Statement of Net Position and/or balance sheet will sometimes report a separate section for deferred inflows of resources. This separate financial statement element represents an acquisition of net assets that applies to future periods and so will not be recognized as an inflow of resources (revenue) until that time. The city has four types of items that qualify for reporting in this category. First, deferred other post-employment benefits and pension resources, which arise under a full-accrual basis of accounting, is reported only in the Statement of Net Position. These amounts are the result of actuarial calculations involving net differences between expected and actual economic experience, changes in actuarial assumptions, net differences between projected and actuarial earnings, and changes in proportion and are deferred and recognized as an inflow of resources in accordance with actuarial calculations. Second, deferred MSA state aid is reported. This amount is the result of an advance of state aid allocated to future periods. Third, unavailable revenue, which arises under the modified accrual basis of accounting, is reported in the governmental funds balance sheet. Governmental funds report unavailable revenue from three sources: property taxes, special assessments, and MSA state aid and grants. These amounts are deferred and recognized as an inflow of resources in the period the amounts become available or are allocated to the city. Fourth, Deferred lease resources are reported in both the fund financial statements and the statement of net position and results from present value calculations related to the lease receivable. 41 R.Net Position In the government-wide and proprietary fund financial statements, 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: •Net investment in capital assets – Consists of capital assets, net of accumulated depreciation, reduced by any outstanding debt attributable to acquire capital assets. •Restricted net position – Consists of net position restricted when there are limitations imposed on their use through external restrictions imposed by creditors, grantors, or laws or regulations of other governments. •Unrestricted net position – All other net position that does not meet the definition of “net investment in capital assets” or “restricted.” S.Fund Balance Classifications In the fund financial statements, governmental funds report fund balance in classifications that disclose constraints for which amounts in those funds can be spent. These classifications are as follows: •Nonspendable – Consists of amounts that are not in spendable form, such as prepaid items, inventory, and other long-term assets. •Restricted – Consists of amounts related to externally imposed constraints established by creditors, grantors, or contributors; or constraints imposed by state statutory provisions. •Committed – Consists of internally imposed constraints that are established by resolution by the city council, which is the city’s highest level of decision-making authority. Those committed amounts cannot be used for any other purpose unless the city council modifies or rescinds the commitment by resolution. •Assigned – Consists of internally imposed constraints. These constraints consist of amounts intended to be used by the city for specific purposes but do not meet the criteria to be classified as restricted or committed. In governmental funds, assigned amounts represent intended uses established by the governing body itself or by an official to which the governing body delegates the authority. Pursuant to city council resolution, the council, city administrator, or finance director are authorized to establish assignments of fund balance. •Unassigned – The residual classification for the General Fund which also reflects negative residual amounts in other funds. When both restricted and unrestricted resources are available for use, it is the city’s policy to first use restricted resources, then use unrestricted resources as they are needed. When committed, assigned, or unassigned resources are available for use, it is the city’s policy to use resources in the following order: 1) committed, 2) assigned, and 3) unassigned. T.Budget Budgets for the General Fund and all special revenue funds are adopted on a basis consistent with accounting principles generally accepted in the United States of America. Reported budget amounts are as originally adopted or as amended by the city council-approved supplemental appropriations and budget transfers. No budget amendments were adopted during the year. Budget appropriations lapse at year-end. The legal level of budgetary control is at the department level in the General Fund and at the fund level in the major special revenue fund. U. Use of Estimates 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 the reported amounts of assets, liabilities, and deferred outflows/inflows and disclosure of contingent assets, liabilities, and deferred outflows/inflows at the date of the financial statements and the reported amounts of revenues and expenses/expenditures during the reporting period. Actual results could differ from those estimates. 42 NOTE 2. CASH, CASH EQUIVALENTS, AND INVESTMENTS A.Components of Cash and Investments Cash and investments at year-end consist of the following: Total Primary Component Reporting Government Unit - EDA Entity Deposits 4,851,474$ 4,544,081$ 9,395,555$ Investments 45,702,475 (139,086) 45,563,389 Cash on hand 8,145 - 8,145 Total cash and investments – Statement of Net Position 50,562,094$ 4,404,995$ 54,967,089$ B.Deposits In accordance with applicable Minnesota Statutes, the city maintains deposits at depository banks authorized by the city council, including checking accounts and non-negotiable certificates of deposit. The following is considered the most significant risk associated with deposits. Custodial Credit Risk – In the case of deposits, this is the risk that in the event of a bank failure, the city’s deposits may be lost. Minnesota Statutes require that all deposits be protected by federal deposit insurance, corporate surety bond, or collateral. The fair value of collateral pledged must equal 110% of the deposits not covered by federal deposit insurance or corporate surety bonds. Authorized collateral includes treasury bills, notes, and bonds; issues of U.S. government agencies; general obligations rated “A” or better; revenue obligations rated “AA” or better; irrevocable standard letters of credit issued by the Federal Home Loan Bank; and certificates of deposit. Minnesota Statutes require that securities pledged as collateral be held in safekeeping in a restricted account at the 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 city’s investment policy does not provide further requirements regarding custodial credit risk. At year-end, the carrying amount of the city’s deposits, including the EDA, was $9,395,555 while the balance on bank records was $9,837,991. All deposits were covered by federal depository insurance, surety bonds, or by collateral held by the city’s agent in the city’s name. The primary government and the EDA component unit deposits and investments are pooled. C.Investments Custodial Credit Risk – For investments, this is the risk that in the event of a failure of the counterparty to an investment transaction (typically a broker-dealer) the city would not be able to recover the value of its investments or collateral securities that are in the possession of an outside party. The city’s investment policy does not provide additional requirements beyond state statutes, but the city typically limits its exposure by purchasing insured or registered investments, or by the control of who holds the securities. Credit Risk – This is the risk that an issuer or other counterparty to an investment will not fulfill its obligations. Minnesota Statutes limit the city’s investments to direct obligations or obligations guaranteed by the United States or its agencies; shares of investment companies registered under the Federal Investment Company Act of 1940 that receive the highest credit rating, are rated in one of the two highest rating categories by a statistical rating agency, and all of the investments have a final maturity of 13 months or less; general obligations rated “A” or better; revenue obligations rated “AA” or better; general obligations of the Minnesota Housing Finance Agency rated “A” or better; bankers’ acceptances of United States banks eligible for purchase by the Federal Reserve System; commercial paper issued by United States corporations or their Canadian subsidiaries, rated of the highest quality category by at least two nationally recognized rating agencies, and maturing in 270 days or less; Guaranteed Investment Contracts guaranteed by a United States commercial bank, domestic branch of a foreign bank, or a 43 United States insurance company, and with a credit quality in one of the top two highest categories; repurchase or reverse purchase agreements and securities lending agreements with financial institutions qualified as a “depository” by the government entity, with banks that are members of the Federal Reserve System with capitalization exceeding $10,000,000; that are a primary reporting dealer in U.S. government securities to the Federal Reserve Bank of New York; or certain Minnesota securities broker-dealers. The city’s investment policy does not further address credit risk. Concentration Risk – This is the risk associated with investing a significant portion of the city’s investment (5% or more) in the securities of a single issuer, excluding U.S. guaranteed investments (such as treasuries), investment pools, and mutual funds. The city’s investment policy requires that no more than 5% of the overall portfolio may be invested in the securities of a single issuer, except for the securities of the U.S. government and in agencies or an external investment pool. Other than the federal government, no single issuer held more than 5% of the city’s total investments at December 31, 2022. Interest Rate Risk – This is the risk of potential variability in the fair value of fixed rate investments resulting from changes in interest rates (the longer the period for which an interest rate is fixed, the greater the risk). The city’s investment policy does not further address the duration of investments. The Minnesota Municipal Money Market Fund (4M Fund) is a common-law trust organized in accordance with the Minnesota Joint Powers Act, which invests only in investment instruments allowable under Minnesota Statutes. It is an external investment pool regulated by Minnesota statutes and the Board of Directors of the League of Minnesota Cities. The 4M Fund is not registered with the Securities Exchange Commission (SEC), but it follows the same regulatory rules of the SEC. The fair value of the city’s position in the pool is the same as the value of the pool shares. The 4M Fund does not have any restrictions on participant withdrawals. The city’s investment in the 4M Fund is measured at the net asset value per share provided by the pool, which is based on an amortized cost method that approximates fair value. The city’s cash management and investment policy complies with all statutory requirements. Fair Value Measurements Less More Percent of Rating Agency Using Than 1 1 to 5 5 to 10 Than 10 Total Holdings U.S. agency securities Federal Farm Credit Bank AA+S&P Level 2 -$ 1,387,128$ 525,451$ -$ 1,912,579$ 4.2% Federal Agriculture Mortgage Corporation N/R N/A Level 2 - - 642,689 - 642,689 1.4% Federal Home Loan Bank AA+S&P Level 2 497,775 1,712,538 417,628 309,481 2,937,422 6.4% Federal Home Loan Bank AAA Moody's Level 2 350,476 227,070 - - 577,546 1.3% Federal Home Loan Mortgage Corporation AA+S&P Level 2 - 774,114 - - 774,114 1.7% Negotiable certificates of deposit N/R N/A Level 2 1,611,672 12,555,367 2,415,173 - 16,582,212 36.5% Local government securities AAA S&P Level 2 - - 80,806 - 80,806 0.2% Local government securities AA S&P Level 2 296,799 283,924 922,204 150,450 1,653,377 3.6% Local government securities Aaa Moody’s Level 2 - 404,784 375,408 - 780,192 1.7% Investment pools and mutual funds N/R N/A Amortized Cost 19,604,257 - - - 19,604,257 42.9% Investment pools and mutual funds AAA S&P Amortized Cost 18,195 - - - 18,195 0.0% Total investments 22,379,174$ 17,344,925$ 5,379,359$ 459,931$ 45,563,389$ 100.0% Credit Risk Interest Risk - Maturity Duration in Years Investment Type D.Cash on hand Cash on hand consists of cash in the possession of the city, including petty cash and change funds. 44 NOTE 3. LEASE RECEIVABLE The City had the following lease receivables as of December 31, 2022: Current Year Issue Maturity Inflow of Balance at Date Date Resources Year End Antenna Lease Agreements Great River Soccer Club - Building Space 08/24/21 05/31/26 1.80 %14,124$ 46,769$ Verizon Wireless - Monopole Antenna 10/01/14 10/01/44 1.80 29,738 745,743 Verizon Wireless - Water Tower Antenna 05/01/17 05/01/44 1.80 27,154 646,977 Total Lease Receivable 1,439,489$ Discount Description Rate The City leases building space located at 101 Chelsea Road, Monticello, Minnesota, to the Great River Soccer club at the above terms. The lease of this former bowling alley is for the use of recreational areas for soccer practice. The City leases monopole and water tower space to Verizon Wireless to provide for the use of city property to operate and maintain communication equipment. 45 NOTE 4. CAPITAL ASSETS Capital asset activities for the year ended December 31, 2022 are as follows: January 1,Transfers and December 31, Beginning Completed Ending Balance Additions Deletions Construction Balance Governmental activities Nondepreciable capital assets Land 16,903,464$ -$ -$ -$ 16,903,464$ Construction in progress 700,918 1,595,033 - (599,247) 1,696,704 Total capital assets not depreciated 17,604,382 1,595,033 - (599,247) 18,600,168 Depreciable capital assets Buildings and systems 104,840,572 303,634 - 595,249 105,739,455 Machinery and equipment 9,052,011 1,430,956 (430,982) 3,998 10,055,983 Total capital assets depreciated 113,892,583 1,734,590 (430,982) 599,247 115,795,438 Less accumulated depreciation for Buildings and systems (54,101,519) (3,519,374) - - (57,620,893) Machinery and equipment (4,707,515) (530,361) 430,982 - (4,806,894) Total accumulated depreciation (58,809,034) (4,049,735) 430,982 - (62,427,787) Net capital assets depreciated 55,083,549 (2,315,145) - 599,247 53,367,651 Total governmental activities 72,687,931$ (720,112)$ -$ -$ 71,967,819$ Business-type activities Nondepreciable capital assets Land 786,010$ 18,000$ -$ 804,010$ Construction in progress 365,874 564,123 - (8,950) 921,047 Total capital assets not depreciated 1,151,884 582,123 - (8,950) 1,725,057 Depreciable capital assets Buildings and systems 105,904,418 500,130 - 8,950 106,413,498 Machinery and equipment 3,377,654 208,281 (15,353) - 3,570,582 Total capital assets depreciated 109,282,072 708,411 (15,353) 8,950 109,984,080 Less accumulated depreciation for Buildings and systems (65,146,079) (2,466,069) - - (67,612,148) Machinery and equipment (2,046,392) (120,952) 15,353 - (2,151,991) Total accumulated depreciation (67,192,471) (2,587,021) 15,353 - (69,764,139) Net capital assets depreciated 42,089,601 (1,878,610) - 8,950 40,219,941 Total business-type activities 43,241,485$ (1,296,487)$ -$ -$ 41,944,998$ Depreciation for the year ended December 31, 2022 was charged to functions/programs as follows: Governmental activities General government 35,611$ Public safety 256,803 Public works 2,663,553 Recreation and culture 682,012 Capital assets held by the City’s internal service funds – charged to the various functions based on usage of assets 411,756 Total depreciation expense – governmental activities 4,049,735$ Business-type activities Water 497,021$ Sewer 1,199,870 Stormwater 467,342 Liquor 20,923 Fiber Optics 380,890 Deputy Registrar 20,975 Total depreciation expense – business-type activities 2,587,021$ 46 NOTE 5. COMMITMENTS The city has awarded contracts for various improvement projects. The city’s commitments for uncompleted work on these contracts at December 31, 2022 are as follows: Amount Contract Paid Remaining Project Description Amount To-Date 12/31/2022 Capital Projects 2022 Street Improvements 950,383$ 902,864$ 47,519$ Water SCADA Improvements 336,125 319,319 16,806 Sewer SCADA Improvements 336,125 319,319 16,806 Stormwater Stormwater Improvements 481,925 469,606 12,319 2,104,558$ 2,011,108$ 93,450$ Fund In 2019, the city entered into an investment agreement with Novel Solar Two LLC (Novel) at a solar farm. The city pays Novel $0.119 per kilowatt-hour (kWh) generated. Novel then sells the produced solar energy to Xcel Energy, and, in return, the city receives an energy credit on its monthly electric bills from Xcel Energy. Payments on the contract began in 2020, but amounts vary each month based on kilowatt- hours produced. NOTE 6. LONG-TERM LIABILITIES A.Description The city has the following types of long-term liabilities outstanding at December 31, 2022: •General Obligation Bonds – The general obligation bond issues financed a settlement with telecommunication revenue bondholders, capital equipment purchases in the Central Equipment and Capital Projects funds, and construction of a new fire station. •Special Assessment Bonds – These bonds are payable primarily from special assessments levied on the properties benefiting from the improvements funded by these issues. Any deficiencies in revenue to fund these issues will be provided from general property taxes. •Tax Abatement Bonds – The principal balances on these bonds are payable primarily from a special tax abatement levy, and interest is paid from general property taxes. •General Obligation Revenue Bonds – The outstanding general obligation revenue bond financed improvements to the city’s sewer system. They will be repaid from revenues pledged and are backed by the taxing power of the city. Net operating revenues were $2,925,917 and principal and interest payments were $244,405 for a percentage of revenues of 8.4%. •PFA Revenue Note – This note was issued for improvements to the wastewater treatment plant and is payable primarily from user fees which benefit from the improvements. •Compensated Absences – The city provides vacation and sick or paid-time-off (PTO) leave benefits to eligible employees. The liability will be repaid by the Benefit Accrual fund or respective enterprise fund for which each employee is employed. •Total OPEB Liability – The city provides post-employment benefits to certain eligible employees through the city’s OPEB Plan. The liability will be repaid based on a pay-as-you-go financing requirement from the General fund or applicable enterprise fund. •Net Pension Liability – City employees participate in one state-wide, multiple-employer, defined benefit pension plan administered by the Public Employees Retirement Association (PERA) per Minnesota state statute. The liability reflects the city’s portion of the total net pension liability of the PERA plan based on a percentage of contributions into the plan. The liability will be repaid by the General fund or applicable enterprise fund. 47 Long-term liabilities at year-end are summarized as follows: Final Original Interest Maturity Balance – Issue Rate %Issue Date Date End of Year Governmental activities General obligation bonds 2014A General obligation bonds equipment portion 515,000$ 1.00 - 3.05%12/18/2014 12/15/2024 120,000$ 2019A General obligation bonds CIP portion 5,350,000 2.00 - 2.30 09/18/2019 12/15/2034 4,425,000 equipment portion 1,290,000 2.00 09/18/2019 12/15/2028 890,000 Special assessments bonds 2015B General obligation bonds 2,605,000 1.50 - 3.00 11/01/2015 12/15/2030 1,500,000 2016A General obligation bonds 4,900,000 2.00 - 3.00 11/15/2016 12/15/2030 2,225,000 2017A General obligation bonds 2,040,000 2.00 - 2.50 10/24/2017 12/15/2027 1,075,000 2019A General obligation bonds 320,000 2.00 09/18/2019 12/15/2028 220,000 2020A General obligation bonds 2,155,000 0.45 - 2.00 09/09/2020 12/15/2030 1,760,000 Tax abatement bonds 2017A General obligation bonds 2,960,000 2.00 - 3.00 10/24/2017 12/15/2032 2,085,000 2018A General obligation bonds 5,000,000 3.00 - 3.38 10/23/2018 12/15/2032 3,790,000 2019A General obligation bonds 1,040,000 2.00 - 2.20 09/18/2019 12/15/2032 825,000 Compensated absences payable 306,299 Total governmental activities 19,221,299$ Business-type activities General obligation revenue bonds 2013B Wastewater treatment bonds 3,000,000$ 2.00 - 3.35 % 12/01/2013 12/01/2028 1,325,000$ Public Facility Authority G.O. Sewer Revenue Note (2015A)2,214,632 1.06 08/26/2015 08/20/2035 1,485,000 Compensated absences payable 102,325 Total business-type activities 2,912,325$ B. Changes in Long-Term Liabilities January 1,December 31,Due Within 2022 Additions Retirements 2022 One Year Governmental activities General obligation bonds 5,960,000$ -$ (525,000)$ 5,435,000$ 530,000$ Special assessment bonds 8,050,000 - (1,270,000) 6,780,000 1,100,000 Tax abatement bonds 7,280,000 - (580,000) 6,700,000 590,000 Add premiums on bonds 18,869 - (18,869) - - Compensated absences payable 296,874 273,568 (264,143) 306,299 275,669 Total governmental activities 21,605,743$ 273,568$ (2,658,012)$ 19,221,299$ 2,495,669$ Business-type activities General obligation revenue bonds 1,525,000$ -$ (200,000)$ 1,325,000$ 205,000$ PFA Revenue Note 1,591,000 - (106,000) 1,485,000 107,000 Add premiums on bonds 15,553 - (15,553) - - Compensated absences payable 95,590 97,675 (90,940) 102,325 92,092 Total business-type activities 3,227,143$ 97,675$ (412,493)$ 2,912,325$ 404,092$ Component Unit activities Compensated absences payable 12,010$ 7,236$ (5,499)$ 13,747$ 12,372$ 48 C.Minimum Debt Payments Minimum annual principal and interest payments to maturity for bonds payable are as follows: Year Ending December 31,Principal Interest Principal Interest Principal Interest Principal Interest Principal Interest 2023 530,000$ 113,288$ 1,100,000$ 143,743$ 590,000$ 186,573$ 205,000$ 39,705$ 107,000$ 15,786$ 2024 540,000 102,148 1,120,000 120,893 605,000 171,473 210,000 34,375 108,000 14,648 2025 490,000 90,718 1,145,000 97,618 625,000 155,973 215,000 28,600 109,000 13,500 2026 500,000 80,918 1,165,000 77,150 640,000 139,973 225,000 22,150 111,000 12,341 2027 510,000 70,918 730,000 51,825 655,000 122,573 230,000 15,400 112,000 12,341 2028 - 2032 2,050,000 216,503 1,520,000 64,950 3,585,000 327,965 240,000 8,040 577,000 37,726 2033 - 2037 815,000 27,973 - - - - - - 361,000 7,707 5,435,000$ 702,466$ 6,780,000$ 556,178$ 6,700,000$ 1,104,528$ 1,325,000$ 148,270$ 1,485,000$ 114,050$ Business-Type Activities PFA Revenue Note Governmental Activities General Obligation BondsGeneral Obligation Bonds Tax Abatement Bonds Special Assessment Bonds D.Legal Debt Margin Under Minnesota State Statutes, the general obligation bonded debt issued by the city is subject to a legal debt limitation based on 3 percent of market value. At December 31, 2022, the city’s legal debt margin was $65,668,876. The statutes provide that debt issues supported by tax increment, special assessment revenues or available dedicated reserves are excluded from the total limited debt. E.Conduit Debt From time to time, the city has issued bonds or notes to provide financial assistance to private sector entities for the acquisition and construction of housing or commercial facilities deemed to be in the public interest. The bonds or notes are secured by the property financed and are payable solely from payments received on the underlying mortgage loans or leases. Upon repayment of the bonds, ownership of the acquired facilities transfers to the private sector entity served by the bond issuance. The city is not obligated in any manner for repayment of the bonds or notes. Accordingly, the bonds are not reported as liabilities in the accompanying financial statements. No new conduit debt was issued in 2022. F. Pay-As-You-Go Tax Increment Notes The city, in order to spur economic development and redevelopment, has entered into private development and redevelopment agreements to encourage developers to construct, expand, or improve new or existing properties and buildings or clean-up and redevelop blighted areas. These agreements may in substance be a tax abatement but will depend on their individual circumstances. G.Abatements The city is authorized to create a tax increment financing plan under Minnesota Statute 469.175. The criteria that must be met under the statute are that, in the opinion of the municipality: •the proposed development or redevelopment would not reasonably be expected to occur solely through private investment within the reasonably foreseeable future; and •the increased market value of the site that could reasonably be expected to occur without the use of tax increment financing would be less than the increase in the market value estimated to result from the proposed development after subtracting the present value of the projected tax increments for the maximum duration of the district permitted by the plan. The requirements of this item do not apply if the district is a housing district; •that the tax increment financing plan conforms to the general plan for the development or redevelopment of the municipality as a whole; and •that the tax increment financing plan will afford maximum opportunity, consistent with the sound needs of the municipality as a whole, for the development or redevelopment of the project by private enterprise. Entity Issue Date Original Issue Current Balance Ice Arena Project 2014 Revenue Refunding Note 9/4/2014 $ 1,111,000 $640,754 Swan River 2017A and 2017B Educational Facilities Revenue Notes 10/2/2017 2,225,000 1,782,392 $2,423,146 Note: No conduit debt issued by the City in 2022. 49 The city has development agreements with private developers for properties in the city’s tax increment districts. As part of the agreements, the city has agreed to reimburse the developers for certain costs through pay-as-you-go tax increment notes. These notes provide for the payment of principal equal to the developers’ costs, plus interest at rates ranging from 5.5% to 8.5% (interest accrual commencing upon the developer completing the project). Payments of the notes will be made at the lesser of the scheduled note payments or the actual net tax increment received during the period specified in the agreement. The notes, classified as abatements, will be canceled at the end of the agreement term, whether it has been fully repaid or not. The city currently has two agreements that would be considered tax abatements under GASB Statement 77. The outstanding principal balances as of December 31, 2022 are listed in the following table. These notes are not included in the city’s long-term debt, because repayment is required only to the extent sufficient tax increments are received. The city’s position is that this is an obligation to assign future and uncertain revenue sources and is not actual debt in substance. Name Purpose 1-22 Downtown District Redevelopment activities in 1997 Downtown and 2010 Embracing Downtown plans 1-40 Briggs 60-unit elderly (senior citizen) housing facility Amount of taxes abated during the fiscal year Outstanding principal balance at year-end Date of required decertification 44,603$ 785,000$ 12/31/2045 12,191$ 184,816$ 12/31/2024 H. Arbitrage Rebate In accordance with the provisions of Section 148(f) of the Internal Revenue Code of 1986, as amended, bonds must satisfy certain arbitrage rebate requirements. Positive arbitrage is the excess of (1) the amount earned on investments purchased with bond proceeds over (2) the amount that such investments would have earned had such investments been invested at a rate equal to the yield on the bond issue. To comply with the arbitrage rebates requirements, positive arbitrage must be paid to the U.S. treasury at the end of each five-year anniversary date of the bond issue. As of December 31, 2022, there are no arbitrage rebates owed. I. Revenue Pledged Future revenue pledged for the payment of long-term debt is as follows: 2013B G.O. Wastewater Treatment Bonds PFA Note Use of proceeds Sewer Fund Sewer Fund Revenue pledged Type Utility charges Utility charges Percent of total debt service 48%52% Term of pledge 2013-2028 2015-2035 Remaining principal & interest 1,473,270$ 1,599,050$ Current year Principal and interest paid 244,405$ 122,912$ Pledged revenue received 1,404,440$ 1,521,477$ Description NOTE 7. DEFINED BENEFIT PENSION PLANS – STATE-WIDE A. Plan Description The city participates in the General Employees Retirement Fund (GERF) cost-sharing multiple-employer defined benefit pension plan administered by the Public Employees Retirement Association of Minnesota (PERA). PERA’s defined benefit pension plans are established and administered in accordance with Minnesota Statutes, Chapters 353 and 356. PERA’s defined benefit pension plans are tax qualified plans 50 under Section 401 (a) of the Internal Revenue Code. General Employees Retirement Fund (General Employees 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. 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 Employees Plan Benefits Benefits are based on a member’s highest average salary for any five successive years of 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% of average salary for each of the first 10 years of service and 1.7% of average salary for each additional year. Under Method 2, the accrual rate for Coordinated members is 1.7% of 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% of the cost-of-living adjustment (COLA) announced by the Social Security Administration, with a minimum increase of at least 1.0% and a maximum of 1.5%. 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 June 30 before the effective date of the increase will receive a reduced prorated increase. For members retiring on January 1, 2024, or later, the increase will be delayed until normal retirement age (age 65 if hired prior to July 1, 1989, or age 66 for individuals hired on or after July 1, 1989). Members retiring under Rule of 90 are exempt from the delay to normal retirement. 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% of their annual covered salary in fiscal year 2022, and the city was required to contribute 7.50% for Coordinated Plan members. The city’s contributions to the General Employees Fund for the year ended December 31, 2022, were $363,693. The city’s contributions were equal to the required contributions as set by state statute. D. Pension Costs General Employees Fund Pension Costs At December 31, 2022, the city reported a liability of $4,870,820 for its proportionate share of the General Employees Fund’s net pension liability. The city’s net pension liability reflected a reduction due to the State of Minnesota’s contribution of $16 million. The State of Minnesota is considered a non-employer contributing entity and the state’s contribution meets the definition of a special funding situation. The State of Minnesota’s proportionate share of the net pension liability associated with the city totaled $142,791. The net pension liability was measured as of June 30, 2022, and the total pension liability used to calculate the net pension liability was determined by an actuarial valuation as of that date. The city’s proportionate share of the net pension liability was based on the city’s contributions received by PERA 51 during the measurement period for employer payroll paid dates from July 1, 2021, through June 30, 2022, relative to the total employer contributions received from all PERA’s participating employers. The city’s proportionate share was 0.0615%, which was an increase of 0.0035% from its proportionate share at June 30, 2021. For the year ended December 31, 2022, the city recognized pension expense of $784,888 for its proportionate share of the General Employees Fund’s pension expense. In addition, the city recognized an additional $21,336 as pension expense (and grant revenue) for its proportionate share of the State of Minnesota’s contribution of $16 million to the General Employees Fund. At December 31, 2022, the city reported its proportionate share of the General Employees Plan’s deferred outflows of resources and deferred inflows of resources related to pensions from the following sources: Deferred Outflows Deferred Inflows Deferred Outflows Deferred Inflows of Resources of Resources of Resources of Resources Differences between expected and actual economic experience 39,689$ 47,782$ 995$ 1,198$ Changes in actuarial assumptions 1,016,031 17,849 25,484 448 Net collective difference between projected and actual investment earnings 172,028 - 4,315 - Changes in proportion 94,989 - 2,382 - Contributions paid to PERA subsequent to the measurement date 177,247 - 4,446 - Total 1,499,984$ 65,631$ 37,622$ 1,646$ Primary Government Component Unit - EDA $181,693 reported as deferred outflows of resources related to pensions resulting from the city and component unit’s contributions subsequent to the measurement date will be recognized as a reduction of the net pension liability in the year ended December 31, 2023. Other amounts reported as deferred outflows and deferred inflows of resources related to pensions, excluding the contributions subsequent to the measurement date, will be recognized in pension expense as follows: Year ended Primary Component December 31, Government Unit - EDA 2023 474,665$ 11,905$ 2024 469,709 11,781 2025 (116,982) (2,934) 2026 429,714 10,778 1,257,106$ 31,530$ 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: Long-Term Target Expected Real Allocation Rate 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% Asset Class 52 F. Actuarial Methods and Assumptions The total pension liability in the June 30, 2022, 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 6.5 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 6.5 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. Benefit increases after retirement are assumed to be 1.25 percent for the General Employees 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. Mortality rates for the General Employees Plan are based on the Pub-2010 General Employee Mortality Table. The tables are adjusted slightly to fit PERA’s experience. 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 2019. The assumption changes were adopted by the Board and became effective with the July 1, 2020 actuarial valuation. The following changes in actuarial assumptions and plan provisions occurred in 2022: • Changes in Actuarial Assumptions: The mortality improvement scale was changed from Scale MP-2020 to Scale MP-2021. • Changes in Plan Provisions: There were no changes in plan provisions since the previous valuation. G. Discount Rate The discount rate used to measure the total pension liability in 2022 was 6.50%. The projection of cash flows used to determine the discount rate assumed that contributions from plan members and employers will be made at the rates set in Minnesota Statutes. Based on these assumptions, the fiduciary net position of the General Employees Fund was 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 The following presents the city’s proportionate share of the net pension liability calculated using the discount rate disclosed in the preceding paragraph, as well as what the city’s proportionate share of the net pension liability would be if it were calculated using a discount rate 1 percentage point lower or 1 percentage point higher than the current discount rate: 1% Decrease Discount 1% Increase (5.50%) Rate (6.50%) (7.50%) General Employees Fund Primary Government 7,505,467$ 4,751,641$ 2,555,610$ Component Unit - EDA 188,249 119,179 62,530 Total 7,693,716$ 4,870,820$ 2,618,140$ City Proportionate Share of NPL I. Pension Plan Fiduciary Net Position Detailed information about the General Employees Fund pension plan’s fiduciary net position is available in a separately issued PERA financial report that includes financial statements and required supplementary information. That report may be obtained on the Internet at www.mnpera.org. 53 NOTE 8. PUBLIC EMPLOYEES DEFINED CONTRIBUTION PENSION PLANS All council members of the city are covered by the Public Employees Defined Contribution Plan, a multiple-employer deferred compensation plan administered by PERA. However, only two of the five Council members choose to participate in the plan. The Defined Contribution Plan is a tax qualified plan under Section 401(a) of the Internal Revenue Code and all contributions by or on behalf of employees are tax deferred until time of withdrawal. Plan benefits depend solely on amounts contributed to the plan plus investment earnings, less administrative expenses. Minnesota Statutes, Chapter 353D.03, specifies plan provisions, including the employee and employer contribution rates for those qualified personnel who elect to participate. An eligible elected official who decides to participate contributes 5% of salary which is matched by the elected official's employer. Employer and employee contributions are combined and used to purchase shares in one or more of the seven accounts of the Minnesota Supplemental Investment Fund. For administering the plan, PERA receives 2% of employer contributions and twenty-five hundredths of 1% (0.25%) of the assets in each member's account annually. Total contributions made by the city during fiscal year 2022 were: Required Employee Employer Employee Employer Rate 705$ 705$ 5.00% 5.00% 5.00% Contribution Amount % of Covered Payroll NOTE 9. DEFINED BENEFIT PENSION PLAN - MONTICELLO FIRE RELIEF ASSOCIATION A. Plan Description All members of the Monticello Fire Department (the Department) are covered by a defined benefit plan administered by the Monticello Fire Relief Association (the Association). As of December 31, 2022, the plan covered 30 active firefighters and 6 retirees and beneficiaries. The plan is a single-employer retirement plan that is established and administered in accordance with Minnesota statute, chapter 69. The Association maintains a separate Special fund to accumulate assets to fund the retirement benefits earned by the Department’s membership. Funding for the Association is derived from voluntary contributions from the city and 2% fire aid from the State of Minnesota, as well as from investment income. B. Benefits Provided Upon approval by the Board of Trustees, lump sum retirement benefits are paid or deferred as follows: Each member who is at least 50 years of age, has retired from the fire department, has served at least 10 years of active service with such department before retirement and has been a member of the Association in good standing at least 10 years prior to such retirement, shall be entitled to a lump sum service pension in the amount of $5,100 for each year of service but not exceeding the maximum amount per year of service allowed by law for the minimum average amount of available financing per firefighter as prescribed by laws. A year of service may be prorated to twelve monthly slices if a full year of active service is not reached. If a member of the Association shall become permanently and totally disabled, the Association shall pay the sum of $5,100 for each year the member was an active member of the Association. If a member who received a disability pension subsequently recovers and returns to active duty, the disability pension is deducted from the service pension as approved by the Board of Trustees. According to the bylaws of the Association and pursuant to Minnesota Statutes, 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 an applicable nonforfeitable percentage. During the time a member is on deferred vested pension (not yet reached age 50), they will earn interest on the deferred benefit amount at a rate determined by the Board of Trustees, up to 5%, compounded annually. A deferred vested member will not be eligible for disability benefits. 54 C. Contributions Minnesota statutes, chapters 424 and 424A authorize pension benefits for volunteer fire relief associations. Contributions by the city are determined as follows: • Normal cost for next year (increase in pension benefit obligation) • Plus, estimated expenses for next year and 10% of any deficits • Less anticipated income next year and 10% of any surplus 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,181 in fire state aid to the plan on behalf of the city Fire Department for the year ended December 31, 2022, which was recorded as a revenue. Required employer contributions are calculated annually based on statutory provisions. The city’s statutorily required contributions to the plan for the year ended December 31, 2022 were $146,181. The city’s contributions were equal to the required contributions as set by state statute. The city made no voluntary contributions to the plan. Furthermore, the members have no obligation to contribute to the plan. D. Actuarial Assumptions The total pension liability at December 31, 2022 was determined using the entry age cost method and the following assumptions: Retirement eligibility at 100% service pension at age 50 and 20 years of service, early vested retirement at age 50 with 10 years of service vested at 60% and increased by 4% for each additional year of service up to 20 and eligibility for deferred service pension payable at age 50 and 20 years of service. Benefit increases 2.00% per year Cost of living increases 2.10% per year Investment rate of return 3.57% 20 year municipal bond yield 2.06% E. Pension Costs At December 31, 2022, the city reported a net pension liability of $180,758 for the FRA plan. The total pension liability used to calculate the net pension liability in accordance with GASB 68 was determined by Robinson Associates LLC applying an actuarial formula to specific census data certified by the fire department as of December 31, 2022. For the year ended December 31, 2022, the Fire Department recognized a pension expense of $137,845. At December 31, 2022, the fire relief reported deferred outflows/inflows of resources as follows: Deferred Deferred Outflows Inflows of Resources of Resources Differences between expected and actual economic experience 225,256$ 174,874$ Changes in actuarial assumptions 43,205 5,747 Net difference between projected and actual investment earnings 138,742 - 407,203$ 180,621$ 55 Amounts reported as deferred outflows and inflows of resources related to pensions will be recognized in pension expense as follows: Pension Year ended Expense December 31, Amount 2023 10,459$ 2024 35,288 2025 52,445 2026 63,571 2027 5,755 Thereafter 59,064 226,582$ The 3.57% 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 asset class using the plan’s target investment allocation along with long-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 arithmetic real rates of return for each major asset class are summarized in the following table: Long-term Target Expected Real Allocation Rate of Return Cash 1.1%-1.09% Mutual funds 98.9%2.47% 100.0% Asset Class F. Changes in the Net Pension Liability (Asset) Total Plan Net Pension Pension Fiduciary Liability Liability (TPL)Net Position (Asset) (a)(b)(a-b) Beginning balance 12/31/2021 1,459,556$ 1,712,617$ (253,061)$ Changes for the year Service cost 111,576 - 111,576 Interest on total pension liability 50,536 - 50,536 Differences between actual and expected experience in measurement of TPL 185,765 - 185,765 Contributions from employer - 146,181 (146,181) Supplemental benefits reimbursed - 3,000 (3,000) Net investment income - (228,981) 228,981 Benefit payments (199,527) (199,527) - Administrative expenses - (6,141) 6,141 Ending balance 12/31/22 1,607,907$ 1,427,149$ 180,758$ 56 G. Discount Rate The discount rate used to measure the total pension liability was 3.57%. The projection of cash flows used to determine the discount rate assumed that contributions to the FRA 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. H. Pension Asset Sensitivity The following presents the city’s net pension liability (asset) for the FRA plan, calculated using the discount rate disclosed in the preceding paragraph, as well as what the city’s net pension liability (asset) would be if it were calculated using a discount rate 1 percentage point lower or 1 percentage point higher than the current discount rate: 1% Decrease 1% Increase In Discount Discount In Discount Rate (2.57%) Rate (3.57%) Rate (4.57%) Net Pension Liability 275,285$ 180,758$ 103,391$ I. Pension Plan Fiduciary Net Position The Association issues a publicly available financial report that includes financial statements and required supplementary information. A copy of the report may be obtained at Monticello City Hall. NOTE 10. OTHER POST-EMPLOYMENT BENEFITS (OPEB) PLAN A. Plan Description The city provides post-employment insurance benefits to certain eligible employees through its OPEB Plan, a single-employer defined benefit plan administered by the city. All post-employment benefits are based on contractual agreements with employee groups. Eligibility for these benefits is based on years of service and/or minimum age requirements. These contractual agreements do not include any specific contribution or funding requirements. The Retiree Health Plan does not issue a publicly available financial report. No plan assets are accumulated in a trust that meets the criteria in paragraph 4 of GASB Statement No. 75. B. Benefits Provided All retirees of the city upon retirement have the option under state law to continue their medical insurance coverage through the city. For members of certain employee groups, the city pays for all or part of the eligible retiree’s premiums for medical and/or dental insurance from the time of retirement until the employee reaches the age of eligibility for Medicare. Benefits paid by the city differ by bargaining unit and date of hire, with some contracts specifying a certain dollar amount per month, and some covering premium costs as defined within each collective bargaining agreement. Retirees not eligible for these city-paid premium benefits must pay the full city premium rate for their coverage. The city is legally required to include any retirees for whom it provides health insurance coverage in the same insurance pool as its active employees until the retiree reaches Medicare eligibility, whether the premiums are paid by the city or the retiree. Consequently, participating retirees are considered to receive a secondary benefit known as an “implicit rate subsidy.” This benefit relates to the assumption that the retiree is receiving a more favorable premium rate than they would otherwise be able to obtain if purchasing insurance on their own, due to being included in the same pool with the city’s younger and statistically healthier active employees. C. Contributions The required contribution is based on projected pay-as-you-go financing requirements, with additional amounts to prefund benefits as determined periodically by the city. The city’s current year required pay- as-you-go contributions to finance the benefits described in the previous section totaled $7,684. 57 D. Membership Membership in the plan consisted of the following as of the latest actuarial valuation: Primary Component Government Unit - EDA Total Retirees and beneficiaries receiving benefits 1 - 1 Active plan members 37 1 38 Total members 38 1 39 E. Total OPEB Liability of the City The city’s total OPEB liability of $168,404 as of year-end was measured as of January 1, 2022 and was determined by an actuarial valuation as of January 1, 2022. F. Actuarial Assumption The total OPEB liability was determined by an actuarial valuation as of January 1, 2022, using the following actuarial assumptions, applied to all periods included in the measurement, unless otherwise specified: Discount rate 2.00% 20-year municipal bond yield 2.00% Inflation rate 2.00% Salary increases 3.00% 6.5% grading to 5.0% over 6 years, then to 4.0% over 48 yearsMedical trend rate The actuarial assumptions used in the latest valuation were based on those used to value pension liabilities for Minnesota city employees. The state pension plans base their assumptions on periodic experience studies. Economic assumptions are based on input from a variety of published sources of historical and projected future financial data. Each assumption was reviewed for reasonableness with the source information as well as for consistency with the other economic assumptions. Since the plan is not funded by an irrevocable trust, the discount rate is equal to the 20-year municipal bond yield rate of 2.00%, which was set by considering published rate information for 20-year high quality, tax-exempt, general obligation municipal bonds as of the measurement date. Mortality rates were based on the Pub-2010 Public Retirement Plans General Headcount-Weighted Mortality Tables with MP-2020 Generational Improvement Scale. Future retirees electing coverage is assumed to be 50% with 30% of those electing family coverage. G. Changes in the Total OPEB Liability Primary Component Total OPEB Government Unit - EDA Liability Beginning balance 158,790$ 2,318$ 161,108$ Changes for the year Service cost 11,253 349 11,602 Interest 3,277 101 3,378 Changes in assumptions - - - Differences between expected and actual experience - - - Benefit payments – employer financed (7,453) (231) (7,684) 7,077 219 7,296 Ending balance 165,867$ 2,537$ 168,404$ 58 Assumption changes since the prior measurement date include the following: • The health care trend rates were changed to better anticipate short term and long-term medical increases. • The mortality tables were updated from the RP-2014 White Collar Mortality Tables with MP- 2018 Generational Improvement Scale to the Pub-2010 Public Retirement Plans General Headcount-Weighted Mortality Tables with MP-2020 Generational Improvement Scale. • The salary increase rates were changed from a flat 3.00% per year for all employees to rates which vary by service. • The retirement and withdrawal tables were updated. • The inflation rate was changed from 2.50% to 2.00%. • The discount rate was changed from 3.80% to 2.00%. H. Total OPEB Liability Sensitivity to Discount and Health-Care Cost Trend Rate Changes The following presents the total OPEB liability of the city, as well as what the city’s total OPEB liability would be if it were calculated using a discount rate that is 1 percentage point lower or 1 percentage point higher than the current discount rate: 1% Decrease in Discount 1% Increase in Discount Rate Rate Discount Rate OPEB discount rate 1.00%2.00%3.00% Primary Government $172,819 $165,867 $154,149 Component Unit - EDA 5,345 2,537 4,768 Discount Sensitivity The following presents the total OPEB liability of the city, as well as what the city’s total OPEB liability would be if it were calculated using healthcare cost trend rates that are 1 percentage point lower or 1 percentage point higher than the current healthcare cost trend rates: 1% Decrease in Healthcare Trend 1% Increase in Healthcare Trend Rate Rate Healthcare Trend Rate OPEB medical trend rate 5.25% decreasing to 6.25% decreasing to 7.25% decreasing to 4.00% over 5 years 5.00% over 5 years 6.00% over 5 years Primary Government $147,215 $165,867 $182,281 Component Unit - EDA 4,553 2,537 5,638 I. OPEB Expense and Related Deferred Outflows of Resources and Deferred Inflows of Resources For the current year ended, the city recognized OPEB expense of ($10,996). As of year-end, the city reported deferred outflows of resources and deferred inflows of resources related to OPEB from the following sources: Deferred Deferred Deferred Deferred Outflows Inflows Outflows Inflows of Resources of Resources of Resources of Resources Liability gains 4,188$ 79,867$ 77$ 482$ Assumption changes 136 870 2 5 Benefit payments after the measurement date 8,546 - 158 - Total 12,870$ 80,737$ 237$ 487$ Primary Government Component Unit - EDA 59 Amounts reported as deferred outflows and inflows of resources related to OPEB, excluding benefit payments after the measurement date, will be recognized in OPEB expense as follows: Year Ending Primary Component December 31,Government Unit - EDA 2022 (25,838)$ (138)$ 2023 (25,838) (138) 2024 (25,828) (138) 2025 1,091 6 (76,413)$ (408)$ NOTE 11. FUND BALANCES At December 31, 2022, a summary of the city’s governmental fund balance classifications are as follows: Component Unit Debt Economic General Community Service Capital Nonmajor Development Fund Center Fund Projects Funds Total Authority Nonspendable Prepaid items 113,530$ 25,932$ -$ -$ 518$ 139,980$ 2,362$ Restricted Debt service - - 974,305 - - 974,305 - Economic development - - - - 898,209 898,209 1,280,119 Perpetual cemetery care - - - - 117,325 117,325 - Tax increment - - - - - - 636,647 Total restricted - - 974,305 - 1,015,534 1,989,839 1,916,766 Assigned Capital improvements - - - 10,868,750 2,566,196 13,434,946 - Economic development - - - - - - 4,966,932 Community center operations - 423,487 - - - 423,487 - Total assigned - 423,487 - 10,868,750 2,566,196 13,858,433 4,966,932 Unassigned 6,929,266 - - - - 6,929,266 - Total 7,042,796$ 449,419$ 974,305$ 10,868,750$ 3,582,248$ 22,917,518$ 6,886,060$ NOTE 12. INTERFUND TRANSFERS Interfund transfers for the year ended December 31, 2022 are as follows: Transfers In Transfers Out Governmental funds General -$ 150,000$ Debt Service - 108,801 Capital Projects 108,801 - Total governmental funds 108,801 258,801 Internal service funds Facilities Maintenance 150,000 - 258,801$ 258,801$ The following schedule reflects each fund transfer: Amount Capital Projects 2011A GO Bond 108,801 (1) Facilities Maintenance General Fund 150,000 (2) Total 258,801$ (1) Transfer to close 2011A Bond Fund (2) Transfer to create fund reserves in internal service fund created in 2021 Transfers In Transfers Out 60 NOTE 13. RISK MANAGEMENT AND LITIGATION The city is exposed to various risks of losses related to torts; theft of, damage to, and destruction of assets; errors and omissions; injuries to employees; and natural disasters. For the past several years, the city has obtained insurance coverage from various trusts administered by the League of Minnesota Cities Insurance Trust (LMCIT). Additionally, the city has effectively managed risk through various employee education and prevention programs. All risk management activities are accounted for in the appropriate fund. Expenditures and claims are recognized when it is probable that a loss has occurred, the amount of the loss can be reasonably estimated, and the loss amount exceeds insurance coverage. In determining claims, events that might create claims, but for which none have been reported, are considered. The city attorney estimates that the amount of actual or potential claims against the city as of December 31, 2022 will not materially affect the financial condition of the city. Workers compensation coverage is procured through Travelers Insurance, a private insurance company. The city has never had to contribute any additional funds beyond the annual standard premium and deductibles, which is $1,000 per occurrence. The city’s annual premium reflects a base rate based on number of employees, total employee compensation, and history of workplace injuries. The city provides health benefit coverage to all full-time employees and certain part-time employees who meet personnel policy set criteria. The city pays a portion of the premium, which is set annually by council action, and is not obligated to make any other payments. The city also purchases property, vehicle, liability, and various other insurance coverages from the LMCIT. The standard deductible for most claims is $1,000. State statute sets tort limits for most liability claims at $500,000 per individual and $1,500,000 for all claimants for one incident. Annually, the council can waive the tort limits, but has chosen not to without exception. The city periodically receives a dividend from LMCIT and has never had to contribute additional funds beyond premiums and deductibles. There were no significant reductions in insurance coverage from the previous year and there were no settlements in excess of insurance coverage in each of the past three years. NOTE 14. CLAIMS AND JUDGMENTS The city participates in several federal and state programs that are fully or partially funded by grants received from other governmental units. Expenditures financed by grants are subject to audit by the appropriate grantor government. If expenditures are disallowed due to noncompliance with grant program regulations, the city may be required to reimburse the grantor government. As of December 31, 2022, certain amounts of grant expenditures have not been audited by the granting agency, but the city believes that disallowed expenditures discovered in subsequent audits, if any, will not have a material effect on any of the individual funds or the overall financial position of the city. NOTE 15. CONCENTRATION OF REVENUES Cargill Kitchen Solutions is the largest customer of water and sewer services. The company’s water purchases account for $95,869, or 5.4%, of Water Fund operating revenue; and the company’s sewer charges account for $467,032, or 16.0%, of Sewer Fund operating revenue. Additionally, Northern States Power Company’s (Xcel Energy) net tax capacity for property taxes payable in 2022 is $15,516,287, or 49.9 percent, of the total net capacity of $31,073,603. Accordingly, Xcel Energy’s share of the $11.741 million city property tax levy is $5.86 million. The tax capacity on January 1, 2022, is based on market values certified to the state on January 1, 2021. 61 NOTE 16: CHANGE IN ACCOUNTING STANDARD For fiscal year 2022, the City implemented Governmental Accounting Standards Board (GASB) Statement No. 87, Leases. GASB Statement No. 87 enhances the relevance and consistency of information of the government’s leasing activities. It establishes requirements for lease accounting based on the principle that leases are financings of the right to use an underlying asset. A lessee is required to recognize a lease liability and an intangible right to use lease asset, and a lessor is required to recognize a lease receivable and a deferred inflow of resources. These changes were incorporated in the City’s 2022 financial statements. The City’s recognition of the beginning balances related to the lease receivable and the related deferred inflow of resources were equal balances and had no effect on the beginning net position of the Governmental Activities. 62 (This page left blank intentionally) 63 REQUIRED SUPPLEMENTARY INFORMATION 64 CITY OF MONTICELLO Required Supplementary Information Schedule of Employer's Share and Non-Employer Proportionate Share of Net Pension Liability (1) PERA Fiscal Year Ending June 30, Employer's Proportion (Percentage) of the Net Pension Liability Employer's Proportionate Share (Amount) of the Net Pension Liability Employer's Proportionate Share of the State of Minnesota's Proportionate Share of the Net Pension Liability Total Employer's Proportionate Share of the Net Pension Liability (2) Covered Payroll Employer's Proportionate Share of the Net Pension Liability as a Percentage of Covered Payroll Plan Fiduciary Net Position as a Percentage of the Total Pension Liability 2015 0.0578%$2,995,496 $0 $2,995,496 $3,395,756 88.21%78.2% 2016 0.0588%4,774,268 62,387 4,836,655 3,651,024 130.77%68.9% 2017 0.0549%3,504,780 44,041 3,548,821 3,534,506 99.16%75.9% 2018 0.0550%3,051,175 100,077 3,151,252 3,697,145 82.53%79.5% 2019 0.0565%3,123,758 96,996 3,220,754 3,997,826 78.14%80.2% 2020 0.0568%3,405,420 104,919 3,510,339 4,048,023 84.13%79.1% 2021 0.0580%2,476,859 75,675 2,552,534 4,176,545 59.30%87.0% 2022 0.0615%4,870,820 142,791 5,013,611 4,608,333 105.70%76.7% Schedule of Employer's Pension Contributions (1) Public Employees Retirement Association - General Employees Retirement Fund Fiscal Year Ending December 31, Statutorily Required Contributions (a) Contribution Deficiency (Excess) (a-b) (2) Covered Payroll (c) 2015 266,042$ -$ 3,547,217$ 2016 267,516 - 3,566,884 2017 269,721 - 3,596,280 2018 287,700 - 3,835,998 2019 308,216 - 4,109,547 2020 304,809 - 4,064,114 2021 321,643 - 4,288,573 2022 363,693 - 4,849,241 (1) The city implemented GASB Statement No. 68 in fiscal 2015 (using a June 30, 2015 measurement date). This schedule is intended to present 10-year trend information. Additional years will be added as they become available. (2) For purposes of this schedule, covered payroll is defined as "pensionable wages." 269,721 287,700 308,216 7.5% 7.5% 7.5% 7.5% Public Employees Retirement Association - General Employees Retirement Fund Contributions as a Percentage of Covered Payroll (b/c) 7.5% Contributions in Relation to the Statutorily Required Contributions (b) $266,042 267,516 363,693 7.5% 321,643 7.5% 304,809 7.5% 65 CITY OF MONTICELLO Required Supplementary Information Schedule of Changes in the Fire Relief Association's Net Pension Liability (Asset) and Related Ratios (1) 2015 2016 2017 2018 2019 2020 2021 2022 Total pension liability Service cost 77,343$ 79,730$ 66,097$ 71,325$ 69,774$ 69,921$ 111,407$ 111,576$ Interest 41,888 44,224 49,857 49,897 50,829 43,168 40,329 50,536 Changes in benefit terms - 90,761 67,016 74,540 - - 207,898 - Experience gain/(loss)- (53,156) (30,666) 94,235 (148,892) (20,335) (18,598) 185,765 Effect of changes in assumptions - - (10,673) - 8,770 - 44,564 - Benefit payments, including refund of member contributions (128,101) (1,168) (164,699) (121,900) (321,833) - - (199,527) Net change in total pension liability (8,870) 160,391 (23,068) 168,097 (341,352) 92,754 385,600 148,350 Total pension liability - beginning 1,026,005 1,017,135 1,177,526 1,154,458 1,322,555 981,203 1,073,957 1,459,557 Total pension liability - ending (A)1,017,135$ 1,177,526$ 1,154,458$ 1,322,555$ 981,203$ 1,073,957$ 1,459,557$ 1,607,907$ Plan fiduciary net position Contributions - State 120,027$ 123,656$ 125,764$ 130,874$ 122,639$ 128,638$ 134,691$ 146,181$ Supplemental benefits reimbursements 2,000 - 2,000 1,000 5,068 - - 3,000 Net investment income (17,673) 55,902 126,579 (54,150) 172,359 139,820 110,486 (228,981) Benefit payments, including refund of member contributions (128,101) (1,168) (164,699) (121,900) (321,833) - - (199,527) Administrative expenses (3,532) (4,144) (4,331) (4,929) (5,204) (5,453) (5,508) (6,141) Net change in plan fiduciary net position (27,279) 174,246 85,313 (49,105) (26,971) 263,005 239,669 (285,468) Plan fiduciary net position - beginning 1,053,739 1,026,460 1,200,706 1,286,019 1,236,914 1,209,943 1,472,948 1,712,617 Plan fiduciary net position - ending (B)1,026,460$ 1,200,706$ 1,286,019$ 1,236,914$ 1,209,943$ 1,472,948$ 1,712,617$ 1,427,149$ Net pension liability (asset) - ending (A)-(B)(9,325) (23,180) (131,561) 85,641 (228,740) (398,991) (253,060) 180,758 Plan fiduciary net position as a percentage of the total pension liability 100.9%102.0%111.4%93.5%123.3%137.2%117.3%88.8% Covered employee payroll (2)N/A N/A N/A N/A N/A N/A N/A N/A Net pension liability as a percentage of covered employee payroll (2)N/A N/A N/A N/A N/A N/A N/A N/A Schedule of Employer's Pension Contributions - Monticello Fire Department Relief Association (1) (1) The city implemented GASB Statement No. 68 in fiscal 2015 using a December 31, 2015 measurement date. This schedule is intended to present 10-year trend information. Additional years will be added as they become available. (2) The Association is comprised of volunteers, therefore, there are no payroll expenditures (i.e., there are no covered employee payroll percentage calculations). 2021 2022 146,181 2018 2019 2020 134,691 122,639 128,638 130,874 - - - - - - Statutorily Required Contributions (a) City Fiscal Year Ending December 31, 2015 2016 2017 -$ Non-Employer Contribution - State 2% Fire Aid 120,027$ 123,656 125,764 - Actual Contributions Paid (b) -$ - - - - - - - - - - - Contribution Deficiency (Excess) (a-b) -$ - - - 66 CITY OF MONTICELLO Required Supplementary Information Schedule of Changes in the City's Total OPEB Liability and Related Ratios (1) 2018 2019 2020 2021 2022 Total OPEB liability Service cost 24,158$ 10,152$ 10,457$ 11,264$ 11,602$ Interest 9,998 10,347 5,210 5,726 3,378 Changes in assumptions - (2,047) - 208 - Differences between expected and actual experience - (187,489) - 6,399 - Benefit payments (5,938) (13,277) (2,040) (3,765) (7,684) Net change in total OPEB liability 28,218 (182,314) 13,627 19,832 7,296 Total OPEB liability - beginning 281,745 309,963 127,649 141,276 161,108 Total OPEB liability - ending 309,963$ 127,649$ 141,276$ 161,108$ 168,404$ Covered employee payroll 3,130,628$ 2,462,725$ 2,536,607$ 2,763,483$ 2,846,387$ Net OPEB liability as a percentage of covered employee payroll 10%5%6%6%6% (1) The city implemented GASB Statement No. 75 in fiscal 2018 using a January 1, 2018 measurement date. This schedule is intended to present 10-year trend information. Additional years will be added as they become available. (2) No plan assets are accumulated in a trust that meets the criteria in paragraph 4 of GASB Statement No. 75. 67 CITY OF MONTICELLO Schedule of Revenues, Expenditures and Changes in Fund Balance Budget and Actual - General Fund For the Year Ended December 31, 2022 101 Original and Final Variance with Budget Actual Final Budget Revenues Property taxes 7,496,000$ 7,485,252$ (10,748)$ Franchise taxes 237,000 226,690 (10,310) Special assessments 100 418 318 Licenses and permits 471,100 613,014 141,914 Intergovernmental 463,000 609,105 146,105 Charges for services 1,144,000 1,398,877 254,877 Fines and forfeitures 51,600 36,808 (14,792) Investment earnings (loss)32,000 (200,442) (232,442) Other revenues 635,200 949,507 314,307 Total revenues 10,530,000 11,119,229 589,229 Expenditures: Current General government Mayor and council 59,262 55,262 (4,000) City administration 1,075,361 938,931 (136,430) City clerk 195,337 227,096 31,759 Finance 615,515 625,523 10,008 Legal 27,500 24,524 (2,976) Human resources 148,810 139,338 (9,472) Planning and zoning 308,957 598,178 289,221 City hall 70,687 76,002 5,315 Public safety Law enforcement 1,650,816 1,633,774 (17,042) Fire and rescue 553,127 546,373 (6,754) Fire relief 140,000 146,181 6,181 Building inspections 567,751 583,073 15,322 Emergency Management 25,225 6,935 (18,290) Animal control 59,971 59,148 (823) National Guard 14,000 14,399 399 Public works Public works administration 157,673 140,020 (17,653) Public works inspections 359,683 263,931 (95,752) Streets and alleys 1,124,296 1,153,418 29,122 Ice and snow removal 407,126 320,884 (86,242) Shop and garage 315,246 295,613 (19,633) Street lighting 237,000 226,689 (10,311) Sanitation Refuse and recycling collection 802,878 784,052 (18,826) Recreation and culture Senior center 106,363 108,122 1,759 Park operations 1,230,204 1,235,095 4,891 Park ballfields 27,400 59,754 32,354 Shade tree 118,175 94,217 (23,958) Public arts 72,241 146,282 74,041 Library 53,396 48,401 (4,995) Total expenditures 10,524,000 10,551,215 27,215 Excess (deficiency) of revenues over expenditures 6,000 568,014 562,014 Other financing uses Transfers out (6,000) (150,000) (144,000) Net change in fund balance - 418,014 418,014 Fund balance at beginning of year 6,624,782 6,624,782 - Fund balance at end of year 6,624,782$ 7,042,796$ 418,014$ 68 CITY OF MONTICELLO Schedule of Revenues, Expenditures and Changes in Fund Balance Budget and Actual - Community Center Fund For the Year Ended December 31, 2022 226 Original and Final Variance with Budget Actual Final Budget Revenues Property taxes 485,000$ 485,000$ -$ Intergovernmental 400,000 385,718 (14,282) Charges for services 899,000 1,007,790 108,790 Investment earnings (loss)1,000 (10,799) (11,799) Other revenues 15,000 50,300 35,300 Total revenues 1,800,000 1,918,009 118,009 Expenditures Current Recreation and culture Operations 482,950 479,233 (3,717) Rentals 11,379 7,624 (3,755) Aquatics 189,639 236,489 46,850 Concessions & guest services 191,552 195,779 4,227 Maintenance 720,456 672,613 (47,843) Programming 204,024 172,571 (31,453) Capital outlay Aquatics - 12,460 12,460 Programming - 81,559 81,559 Total expenditures 1,800,000 1,858,328 58,328 Net change in fund balance - 59,681 59,681 Fund balance at beginning of year 389,738 389,738 - Fund balance at end of year 389,738$ 449,419$ 59,681$ 69 NOTE 1. SCHEDULE OF EMPLOYER’S SHARE AND NON-EMPLOYER PROPORTIONATE SHARE OF NET PENSION LIABILITY – PUBLIC EMPLOYEES RETIREMENT ASSOCIATION The following changes were reflected in the valuation performed on behalf of the Public Employees Retirement Association for the year ended June 30: 2022 Changes in Actuarial Assumptions • The mortality improvement scale was changed from Scale MP-2020 to Scale MP-2021. Changes in Plan Provisions • There were no changes in plan provisions since the previous valuation. 2021 Changes in Actuarial Assumptions • 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. Changes in Plan Provisions • There were no changes in plan provisions since the previous valuation. 2020 Changes in Actuarial Assumptions • 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. Changes in Plan Provisions • 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. 70 2019 Changes in Actuarial Assumptions • The mortality projection scale was changed from MP-2017 to MP-2018. Changes in Plan Provisions • The employer supplemental contribution was changed prospectively, decreasing from $31.0 million to $21.0 million per year. The State’s special funding contribution was changed prospectively, requiring $16.0 million due per year through 2031. 2018 Changes in Actuarial Assumption • The morality projection scale was changed from MP-2015 to MP-2017. • The assumed benefit increase was changed from 1.00% per year through 2044 and 2.50% per year thereafter to 1.25% per year. Changes in Plan Provisions • 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% to 3.00%, beginning July 1, 2018. • Deferred augmentation was changed to 0.00%, 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% per year with a provision to increase to 2.50% upon attainment of 90.00% funding ratio to 50.00% of the Social Security Cost of Living Adjustment, not less than 1.00% and not more than 1.50%, 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 Changes in Actuarial Assumption • The Combined Service Annuity (CSA) loads were changed from 0.8% for active members and 60% for vested and non-vested deferred members. The revised CSA loads are now 0.00% for active member liability, 15.00% for vested deferred member liability, and 3.00% for nonvested deferred member liability. The assumed post-retirement benefit increase rate was changed from 1.00% per year for all years to 1.00% per year through 2044, and 2.50% per year thereafter. Changes in Plan Provisions • The State’s contribution for the Minneapolis Employees Retirement Fund equals $16,000,000 in 2017 and 2018, and $6,000,000 thereafter. • The Employer Supplemental Contribution for the Minneapolis Employees Retirement Fund changed from $21,000,000 to $31,000,000 in calendar years 2019 to 2031. The state’s contribution changed from $16,000,000 to $6,000,000 in calendar years 2019 to 2031. 71 2016 Changes in Actuarial Assumptions • The assumed postretirement benefit increase rate was changed from 1.00% per year through 2035 and 2.50% per year thereafter to 1.00% per year for all years. • The assumed investment return was changed from 7.90% to 7.50%. The single discount rate changed from 7.90% to 7.50%. • Other assumptions were changed pursuant to the experience study June 30, 2015. The assumed future salary increases, payroll growth, and inflation were decreased by 0.25% to 3.25% for payroll growth and 2.50% for inflation. Changes in Actuarial Plan Provisions • There have been no changes since the prior valuation. 2015 Changes in Actuarial Assumptions • The assumed postretirement benefit increase rate was changed from 1.00% per year through 2030 and 2.50% per year thereafter to 1.00% per year through 2035 and 2.50% per year thereafter. Changes in Plan Provisions • 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 increase the fiduciary plan net position by $892 million. Upon consolidation, state and employer contributions were revised; the State’s contribution of $6.0 million, which meets the special funding situation definition, was due September 2015. NOTE 2. SCHEDULE OF CHANGES IN THE FIRE RELIEF ASSOCIATION’S NET PENSION LIABILITY (ASSET) AND RELATED RATIOS Changes in Actuarial Assumptions and Benefit Terms • 2021 – The discount rate was decreased from 4.25% to 3.57%, which is primarily due to a lower weighted average rate of return on the FRA’s asset classes of investment. The benefit level was increased from $4,200 to $5,100 per year of service. • 2019 – The discount rate was decreased from 4.42% to 4.25%, which is primarily due to a lower weighted average rate of return on the FRA's asset classes of investments. • 2018 – The benefit level was increased from $3,900 to $4,200 per year of service. • 2017 – The annual turnover rate was changed from 10% to 1%. The discount rate was increased from 4.19% to 4.42%, which is primarily due to a reduction in the portfolio's average expense load. The benefit level was increased from $3,600 to $3,900 per year of service. • 2016 – The benefit level was increased from $3,300 to $3,600 per year of service. NOTE 3. SCHEDULE OF CHANGES IN THE CITY’S TOTAL OPEB LIABILITY AND RELATED RATIOS Changes in Actuarial Assumptions • 2021 – The healthcare trend rates were changed to better anticipate short term and long-term medical increases. The mortality tables were updated from the RP-2014 White Collar Mortality Tables with the MP-2018 Generational Improvement Scale to the Pub-2010 Public Retirement Plans General Headcount-Weighted Mortality Tables with MP-2020 Generational Improvement Scale. The salary increase rates were changed from a flat 3% per year for all employees to rates which vary by service. The retirement and withdrawal rates were updated. The inflation rate changed from 2.50% to 2.00%. The discount rate was changed from 3.80% to 2.00%. • 2020 – The healthcare trend rate was changed to better anticipate short-term and long-term medical increases. 72 • 2019 – The discount rate was increased from 3.3% to 3.8%. The health care trend rates were changed to better anticipate short term and long-term medical increases. The mortality tables were updated from the RP-2014 White Collar Mortality Tables with MP-2016 Generational Improvement Scale to the RP-2014 White Collar Mortality Tables with MP-2018 Generational Improvement Scale. The percentage of retirees electing single or family coverage was updated to reflect that the city sponsored plan has separated single and family premium rates, rather than a composite rate. The assumption was changed that 50% of eligible retirees will elect to continue coverage and 30% of retirees with coverage will elect family coverage. • 2018 – The discount rate was decreased from 3.5% to 3.3%. NOTE 4. BUDGETARY INFORMATION A. Budgetary basis of accounting The city follows these procedures in establishing the budgetary data reflected in the basic financial statements: A. Prior to September 1, the city administrator submits to the city council a proposed operating budget for the fiscal year commencing the following January 1. The operating budget includes proposed expenditures and the means of financing them. The city council provides input and adjustments. Based on the proposed budget, the city council certifies the proposed property tax levy to the county auditor according to Minnesota Statutes before September 30. B. Public hearings are conducted at the city council’s chambers in the Monticello Community Center. C. On or before December 28, the final budget is legally enacted by city council resolution and the final property tax levy is certified to the county auditor. D. Management is authorized to transfer budgeted amounts between departments within a fund; however, any revisions that alter the total expenditures of any fund must be approved by the city council. E. The city has legally adopted budgets for the General Fund and all special revenue funds. Expenditures may not legally exceed budgeted appropriations at the total fund level. Monitoring of budgets is maintained at the department level. All amounts over budget have been approved by the city council through the disbursement process. The city is not legally required to adopt an annual budget for the nonmajor special revenue funds, the Debt Service Fund, and the Capital Projects Funds. Project-length financial plans are adopted for the Debt Service and Capital Projects Funds. F. Budgets are adopted on a basis consistent with accounting principles generally accepted in the United States of America. Budgeted amounts are as originally adopted or amended by the city council. All annual appropriations lapse at year-end. B. Excess of expenditures over appropriations For the year ended December 31, 2022, expenditures exceeded appropriations in the General Fund and the Community Center Fund. The General Fund expenditures were over budget by $27,215, which was funded by revenues in excess of budget. The Community Center special revenue fund expenditures exceeded the budget by $58,328. The excess of expenditures was related to unbudgeted capital outlay to replace the indoor play structure. Revenues above budget were used to fund the additional expenditure. 73 NONMAJOR GOVERNMENTAL FUNDS 74 NONMAJOR GOVERNMENTAL FUNDS SPECIAL REVENUE FUNDS are used to account for revenue derived from specific taxes or other earmarked revenue sources (other than for major capital projects) that are restricted by law or administrative action to expenditures for specified purposes. Small Cities Development Program (SCDP) Fund - Established to account for the administration of loans to local businesses while following state and federal guidelines. Cemetery Fund – Established to account for the activities of cemetery operations at Riverside Cemetery. CAPITAL PROJECTS FUNDS are used to account for resources used for the acquisition and construction of capital assets by the city, except for those financed by proprietary funds. Street Lighting Improvement Fund – This fund was established to account for activities incorporating street lighting into designated areas throughout the city. A portion of the city’s electric franchise fee is the main revenue source for this fund. Park & Pathway Improvement Fund – This fund was established to account for the accumulation of unrestricted resources from other sources used for park and pathway improvements. Park Dedication Fund – This fund was established to account for restricted fees collected from developers for park land acquisition and for park and pathway improvements. 75 CITY OF MONTICELLO Combining Balance Sheet Nonmajor Governmental Funds December 31, 2022 221 215 403 404 405 Small Cities Street Development Lighting Park &Park Program Cemetery Improvement Pathway Dedication Total ASSETS Cash and investments 767,787$ 118,325$ 1,213,352$ 1,207,607$ 100,706$ 3,407,777$ Receivables Deferred special assessments - - - - 4,231 4,231 Accounts - - 44,531 - - 44,531 Prepaid items - 518 - - - 518 Notes receivable 130,422 - - - - 130,422 Total assets 898,209$ 118,843$ 1,257,883$ 1,207,607$ 104,937$ 3,587,479$ LIABILITIES Accounts and contracts payable -$ 1,000$ -$ -$ -$ 1,000$ DEFERRED INFLOWS OF RESOURCES Unavailable revenue - special assessments - - - - 4,231 4,231 FUND BALANCES Nonspendable - 518 - - - 518 Restricted Economic development 898,209 - - - - 898,209 Cemetery maintenance - 117,325 - - - 117,325 Park improvements - - - - 100,706 100,706 Assigned for capital improvements - - 1,257,883 1,207,607 - 2,465,490 Total fund balances 898,209 117,843 1,257,883 1,207,607 100,706 3,582,248 Total liabilities, deferred inflows of resources, and fund balances 898,209$ 118,843$ 1,257,883$ 1,207,607$ 104,937$ 3,587,479$ Capital Projects FundsSpecial Revenue Funds 76 CITY OF MONTICELLO Combining Statement of Revenues, Expenditures and Changes in Fund Balance Nonmajor Governmental Funds For the Year Ended December 31, 2022 245 221 215 403 404 405 Small Cities 651 Street Development Lighting Park &Park Program Cemetery Improvement Pathway Dedication Total Revenues Franchise taxes -$ -$ 161,384$ -$ -$ 161,384$ Special assessments - - - - 850 850 Intergovernmental - - - 150,000 - 150,000 Charges for services - 67,838 - - 144,832 212,670 Investment earnings (loss)(30,286) (3,519) (45,715) (42,465) 685 (121,300) Interest on loans 3,873 - - - - 3,873 Total revenues (26,413) 64,319 115,669 107,535 146,367 407,477 Expenditures Current Recreation and culture - 26,660 - 500 - 27,160 Capital outlay Public works - - 37,993 - - 37,993 Recreation and culture - - - - 45,702 45,702 Total expenditures - 26,660 37,993 500 45,702 110,855 Net change in fund balance (26,413) 37,659 77,676 107,035 100,665 296,622 Fund balance at beginning of year 924,622 80,184 1,180,207 1,100,572 41 3,285,626 Fund balance at end of year 898,209$ 117,843$ 1,257,883$ 1,207,607$ 100,706$ 3,582,248$ Special Revenue Funds Capital Projects Funds 77 INTERNAL SERVICE FUNDS 78 INTERNAL SERVICE FUNDS INTERNAL SERVICE FUNDS are used to account for the financing of centralized services to city departments on a cost-reimbursement basis (including depreciation). Benefit Accrual Fund – This fund was established to account for resources accumulated to satisfy paid- time-off (PTO) and vacation/sick leave liabilities of governmental fund employees. Central Equipment Fund – This fund was established to account for equipment purchases and rental to various governmental fund departments. Information Technology (IT) Services Fund – This fund was established to account for the accumulation and distribution of various IT related costs, including communications, software support, capital and non-capital equipment, and software purchases. Facilities Management Fund – This fund was established to account for the accumulation and distribution of various Facility Maintenance related costs across the city owned properties. 79 CITY OF MONTICELLO Combining Statement of Net Position Internal Service Funds December 31, 2022 704 703 702 701 Benefit Central IT Facilities Accrual Equipment Services Maintenance Total ASSETS Current assets Cash and investments 304,360$ 1,383,686$ 86,813$ 74,909$ 1,849,768$ Due from other governmental units - 483 - - 483 Prepaid items - - 55,473 2,307 57,780 Total current assets 304,360 1,384,169 142,286 77,216 1,908,031 Noncurrent assets Capital assets Machinery and equipment - 4,110,695 308,399 - 4,419,094 Less accumulated depreciation - (1,425,367) (101,046) - (1,526,413) Total noncurrent assets - 2,685,328 207,353 - 2,892,681 Total Assets 304,360 4,069,497 349,639 77,216 4,800,712 LIABILITIES Current liabilities Accounts payable - - 39,184 25,647 64,831 Accrued interest payable - 149 - - 149 Due to other governmental units - - - 91 91 Bonds payable due within one year - 60,000 - - 60,000 Compensated absences due within one year 261,401 - 252 14,016 275,669 Total current liabilities 261,401 60,149 39,436 39,754 400,740 Noncurrent liabilities Bonds payable, net current portion - 60,000 - - 60,000 Compensated absences payable 29,045 - 28 1,557 30,630 Total noncurrent liabilities 29,045 60,000 28 1,557 90,630 Total Liabilities 290,446 120,149 39,464 41,311 491,370 NET POSITION Net investment in capital assets - 2,565,328 186,130 - 2,751,458 Unrestricted 13,914 1,384,020 124,045 35,905 1,557,884 Total Net Position 13,914$ 3,949,348$ 310,175$ 35,905$ 4,309,342$ 80 CITY OF MONTICELLO Combining Statement of Revenues, Expenses and Changes in Net Position Internal Service Funds For the Year Ended December 31, 2022 701 704 703 702 701 Benefit Central IT Facilities Accrual Equipment Services Maintenance Total Operating revenues Charges to other funds 9,325$ 578,400$ 421,000$ 413,327$ 1,422,052$ Other revenues - 33,529 2,450 60,156 96,135 Total operating revenues 9,325 611,929 423,450 473,483 1,518,187 Operating expenses Personal services 9,325 - 96,554 131,377 237,256 Materials and supplies - - 40,877 65,188 106,065 Other services and charges - - 301,136 357,157 658,293 Depreciation - 379,442 32,314 - 411,756 Total operating expenses 9,325 379,442 470,881 553,722 1,413,370 Operating income (loss)- 232,487 (47,431) (80,239) 104,817 Nonoperating revenues (expenses) Investment earnings (loss)(11,885) (51,466) (6,977) (2) (70,330) Interest expense - (5,151) - - (5,151) Total nonoperating revenues (expenses)(11,885) (56,617) (6,977) (2) (75,481) Income before transfers (11,885) 175,870 (54,408) (80,241) 29,336 Transfers in - - - 150,000 150,000 Change in net position (11,885) 175,870 (54,408) 69,759 179,336 Net position at beginning of year 25,799 3,773,478 364,583 (33,854) 4,130,006 Net position at end of year 13,914$ 3,949,348$ 310,175$ 35,905$ 4,309,342$ 81 CITY OF MONTICELLO Combining Statement of Cash Flows Internal Service Funds For the Year Ended December 31, 2022 704 703 702 701 Benefit Central IT Facilities Accrual Equipment Services Maintenance Total Cash flow from operating activities Cash received from internal services provided 9,325$ 662,168$ 423,450$ 473,483$ 1,568,426$ Cash paid to suppliers for goods and services - (51,722) (316,732) (420,144) (788,598) Cash paid to employees - -(97,194) (130,637) (227,831) Net cash provided (used) by operating activities 9,325 610,446 9,524 (77,298) 551,997 Cash flows from noncapital financing activities Transfers from other funds - - - 150,000 150,000 Cash flows from capital and related financing activities Acquisition of capital assets - (521,963) (87,731) - (609,694) Principal payments on long-term debt - (60,000) - - (60,000) Interest and fiscal charges paid on long-term debt - (5,220) - - (5,220) Net cash (used) by capital and related financing activities - (587,183) (87,731) - (674,914) Cash flows from investing activities Interest on investments (loss)(11,885) (51,466) (6,977) (2) (70,330) Increase (decrease) in cash and cash equivalents (2,560) (28,203) (85,184) 72,700 (43,247) Cash and cash equivalents - January 1 306,920 1,411,889 171,997 2,209 1,893,015 Cash and cash equivalents - December 31 304,360$ 1,383,686$ 86,813$ 74,909$ 1,849,768$ Reconciliation of operating income (loss) to net cash provided by operating activities: Operating income (loss)-$ 232,487$ (47,431)$ (80,239)$ 104,817$ Adjustments to Reconcile Operating Income (Loss) to Net Cash Provided by Operating Activities: Depreciation - 379,442 32,314 - 411,756 Changes in assets and liabilities: (Increase) decrease in prepaid items - - (1,972) (2,307) (4,279) (Increase) decrease in due from other government units - (483) - - (483) Increase (decrease) in accounts payable - (51,722) 27,253 4,497 (19,972) Increase (decrease) in due to other government units - -- 11 11 Increase (decrease) in compensated absences 9,325 - (640) 740 9,425 Net cash provided (used) by operating activities 9,325$ 559,724$ 9,524$ (77,298)$ 501,275$ Schedule of noncash capital and related financing activities: Capital assets purchased on account -$ -$ 21,223$ -$ 21,223$ 82 OTHER SUPPLEMENTARY SCHEDULES 83 CITY OF MONTICELLO Schedule of Revenues (Sources) and Expenditures (Uses) General Fund For the Year Ended December 31, 2022 With Comparative Actuals for the years Ended December 31, 2018 - 2021 2022 Variance with 2018 2019 2020 2021 Final 2022 Final Actual Actual Actual Actual Budget Actual Budget Revenue and other sources - summary Property taxes 6,634,769$ 6,689,647$ 6,797,640$ 7,233,198$ 7,496,000$ 7,485,252$ (10,748)$ Franchise taxes 245,000 211,000 194,000 193,585 237,000 226,690 (10,310) Special assessments 206 802 166 468 100 418 318 Licenses and permits 504,464 603,925 521,369 804,889 471,100 613,014 141,914 Intergovernmental 428,443 431,004 737,650 625,382 463,000 609,105 146,105 Charges for services 590,106 792,311 936,731 1,274,062 1,144,000 1,398,877 254,877 Fines and forfeitures 45,350 40,054 31,852 49,566 51,600 36,808 (14,792) Investment earnings (loss)106,767 228,216 138,968 (38,486) 32,000 (200,442) (232,442) Other 134,688 236,037 431,683 690,999 635,200 949,507 314,307 Other Financing Sources 15,000 54,340 - - - - - Total Revenues & Other Sources 8,704,793 9,287,336 9,790,059 10,833,663 10,530,000 11,119,229 589,229 Revenue and other sources - detail Property taxes Property tax - current 6,567,152 6,649,999 6,758,778 7,159,058 7,475,000 7,436,942 (38,058) Property tax - delinquent 46,482 17,832 15,998 49,891 - 20,753 20,753 Mobile home tax 18,984 18,202 20,152 22,033 18,500 - (18,500) Penalties and interest - taxes 2,151 3,614 2,712 2,216 2,500 27,557 25,057 Franchise taxes Franchise taxes - electric 245,000 211,000 194,000 193,585 237,000 226,690 (10,310) Special assessments Assessment for services/projects 206 802 166 468 100 418 318 Licenses and permits Liquor license 50,295 52,303 37,512 1,500 48,100 63,198 15,098 Beer license 1,988 - - - - - - Other business licenses & permits 6,840 7,540 6,430 4,378 6,000 5,023 (977) Building permits 427,644 520,409 461,383 770,800 400,000 529,120 129,120 Variance/conditional use permits - - 200 - - - - Driveway permits 180 510 275 155 200 675 475 Mobile home permits 720 2,551 540 5,954 300 1,000 700 Excavation permits 7,410 6,720 8,375 11,025 5,000 7,360 2,360 Right-of-way permits 3,707 4,567 3,061 2,674 3,000 2,542 (458) Sign/banner permits 4,815 6,020 2,840 5,623 4,500 3,430 (1,070) Animal licenses 865 3,305 753 2,780 4,000 666 (3,334) Intergovernmental Pera increase aid 6,849 6,741 - - - - - Homestead and ag credit - - - 181 - 188 188 Federal - operating - - 274,315 10,000 - - - State highway aid - operating 155,374 155,211 171,913 179,842 152,000 198,895 46,895 Fire department aid - operating 130,874 123,640 131,638 134,691 140,000 146,181 6,181 Police department aid - operating 71,834 81,708 84,631 82,526 81,000 90,713 9,713 County operating grant - street/highway 27,353 26,428 30,947 27,870 26,000 32,427 6,427 County operating grant - emergency management 12,331 7,531 3,977 11,111 19,000 7,594 (11,406) County operating grant - recycling 19,978 19,745 20,944 19,546 19,000 20,112 1,112 Operating grant - other 3,850 10,000 19,285 159,615 26,000 112,995 86,995 Charges for services Assessment searches 10,695 13,940 17,530 18,691 13,000 9,030 (3,970) County assessor fee - - - 400 - 2,950 2,950 Blight notice fee - - - 120 - 300 300 Planning administration fee 5,876 24,571 5,550 6,600 4,000 6,425 2,425 NSF fee 30 - - 30 - 30 30 Inspection/construction fees 764 907 827 1,306 300 560 260 Contractor licensing fee 290 720 340 475 - 175 175 Fire protections fees - townships 142,374 142,740 143,533 143,899 143,000 144,570 1,570 Fire emergency response fee 19,995 19,210 57,650 5,160 15,000 2,380 (12,620) Fire inspection fee - - - 50 - - - Fire - other fees 11,808 3,345 2,359 13,011 3,000 3,815 815 Blight mowing fees - - - 470 - 940 940 Rental housing fees 45,500 42,835 45,365 45,910 41,000 58,565 17,565 Animal control fees 45,232 38,915 40,428 49,002 45,000 58,544 13,544 Miscellaneous pubic works 8,621 - - - - - - Tree and brush removal charge 2,365 2,580 2,730 2,275 2,300 3,300 1,000 Recycling charge 30 - 54,259 104,305 205,400 195,197 (10,203) Garbage fee - taxable 169,217 381,328 467,829 518,244 562,000 555,426 (6,574) Garbage surcharge - not taxable 90 - - - - - - Field/Tourney fees 14,400 13,200 4,415 30,980 32,000 35,700 3,700 Park rental fees 9,051 5,751 5,386 11,798 5,000 11,212 6,212 Alcohol Fees - - - - - 360 360 Concessions - - - - - 1,297 1,297 Arts activity fees - 400 - - - - - Developer cost reimbursement 16,429 19,498 13,656 233,371 46,000 223,120 177,120 Billboard land rental 22,881 23,475 21,714 24,367 - 22,101 22,101 Lease - Prairie Center 28,548 30,154 24,098 32,501 - -- Lease - Soccer Club - - - - - 14,468 14,468 Lease - communication tower 29,213 26,300 26,959 28,872 27,000 45,980 18,980 General charges for services 6,697 2,442 2,103 2,225 - 2,432 2,432 84 CITY OF MONTICELLO Schedule of Revenues (Sources) and Expenditures (Uses) General Fund For the Year Ended December 31, 2022 (Continued) With Comparative Actuals for the years Ended December 31, 2018 - 2021 2022 Variance with 2018 2019 2020 2021 Final 2022 Final Actual Actual Actual Actual Budget Actual Budget Fines and forfeitures Court fines 44,450$ 38,454$ 31,170$ 47,866$ 50,000$ 35,658$ (14,342)$ Animal impound fines 400 1,100 682 700 1,600 650 (950) Liquor license violation 500 500 - 1,000 - 500 500 Investment earnings Investment earnings (loss)106,767 228,216 138,968 (38,486) 32,000 (200,442) (232,442) Other Solar investment rebates - - 326,917 427,842 570,000 496,430 (73,570) City property rental 1,600 1,600 277 1,600 1,600 1,900 300 Contributions 13,543 42,567 2,218 36,707 2,500 128,953 126,453 Sale of city property 5,724 3,096 16,945 12,475 2,500 23,502 21,002 Sale of lock boxes 920 2,400 3,544 38,097 1,800 10,812 9,012 Tree Sales 7,073 6,752 5,346 9,127 7,000 9,453 2,453 Copies 15 47 87 27 - 38 38 Refunds & reimbursables 42,297 21,663 24,026 75,692 - 55,822 55,822 Assessment fee reimbursement 21,300 16,575 15,300 14,700 15,000 16,875 1,875 Fire contributions 2,973 84,149 3,764 28,009 - 16,999 16,999 Insurance claims - 1,867 - 6,944 - 140,257 140,257 Other miscellaneous 39,243 55,321 33,259 39,779 34,800 48,466 13,666 Other Financing Sources Sales of capital assets 15,000 29,340 - - - - - Transfers from other funds - 25,000 - - - - - Total revenues and other sources 8,704,793$ 9,287,336$ 9,790,059$ 10,833,663$ 10,530,000$ 11,119,229$ 589,229$ Expenditures and other uses - summary General government 1,654,538$ 1,775,332$ 2,168,641$ 2,639,420$ 2,501,429$ 2,684,854$ 183,425$ Public safety 2,356,471 2,451,784 2,745,974 2,874,183 3,010,890 2,989,883 (21,007) Public works 2,079,091 2,222,034 1,899,315 2,123,898 2,601,024 2,400,555 (200,469) Sanitation 615,586 610,944 681,948 754,132 802,878 784,052 (18,826) Transit 18,333 - - - - - - Recreation and culture 1,200,388 1,209,429 1,331,196 1,457,483 1,607,779 1,691,871 84,092 Transfers out and other uses 700,000 1,450,040 1,000,000 1,000,000 6,000 150,000 144,000 Total expenditures and other uses 8,624,407$ 9,719,563$ 9,827,074$ 10,849,116$ 10,530,000$ 10,701,215$ 171,215$ Expenditures and other uses - divisions General government Mayor and council 53,928$ 57,409$ 52,589$ 57,171$ 59,262$ 55,262$ (4,000)$ City administration 449,100 443,963 789,820 951,793 1,075,361 938,931 (136,430) City clerk 130,948 121,197 180,824 125,286 195,337 227,096 31,759 Finance 430,924 456,902 451,819 455,839 615,515 625,523 10,008 Audit 40,531 45,940 39,559 44,797 - - - City assessing 66,190 64,554 70,115 77,600 - - - Legal 27,967 41,837 29,340 25,883 27,500 24,524 (2,976) Human resources 126,581 142,812 142,232 131,469 148,810 139,338 (9,472) Planning and zoning 239,045 315,091 339,005 685,172 308,957 598,178 289,221 City hall 66,111 66,422 60,501 68,094 70,687 76,002 5,315 Prairie center building 25,232 21,225 14,857 16,316 - - - Public safety Law enforcement 1,362,411 1,455,727 1,524,150 1,602,876 1,650,816 1,633,774 (17,042) Fire and rescue 435,068 477,941 414,399 459,593 553,127 546,373 (6,754) Fire relief 132,874 123,640 131,638 134,691 140,000 146,181 6,181 Building inspections 351,511 324,072 354,251 599,569 567,751 583,073 15,322 Emergency management 12,332 8,253 257,565 13,725 25,225 6,935 (18,290) Animal control 46,608 46,709 49,522 50,586 59,971 59,148 (823) National guard 13,649 13,423 12,429 13,143 14,000 14,399 399 Public works Public works administration 196,851 228,625 221,881 244,352 157,673 140,020 (17,653) Engineering 126,179 111,710 80,432 93,848 - - - Public works inspections 83,560 90,047 102,110 107,587 359,683 263,931 (95,752) Streets and alleys 891,117 920,384 777,633 919,550 1,124,296 1,153,418 29,122 Ice and snow 344,974 454,607 326,120 294,312 407,126 320,884 (86,242) Shop and garage 168,049 178,063 199,310 269,193 315,246 295,613 (19,633) Stormwater 23,883 27,650 - - - - - Street lighting 244,478 210,948 191,829 195,056 237,000 226,689 (10,311) Sanitation Refuse and recycling collection 615,586 610,944 681,948 754,132 802,878 784,052 (18,826) Transit Bus service 18,333 - - - - - - Recreation and culture Senior center 103,226 102,169 103,662 105,689 106,363 108,122 1,759 Park operations 916,335 925,482 1,040,665 1,098,446 1,230,204 1,235,095 4,891 Park ballfields 21,063 19,836 23,685 28,072 27,400 59,754 32,354 Shade tree 80,916 61,396 79,024 87,525 118,175 94,217 (23,958) Public arts 29,876 46,954 36,092 93,245 72,241 146,282 74,041 Library 48,972 53,592 48,068 44,506 53,396 48,401 (4,995) Transfers out and other uses Transfers out 700,000 1,450,040 1,000,000 1,000,000 6,000 150,000 144,000 Total expenditures & other uses 8,624,408$ 9,719,564$ 9,827,074$ 10,849,116$ 10,530,000$ 10,701,215$ 171,215$ Revenue and other sources over (under) expenditures and other uses 80,385$ (432,228)$ (37,015)$ (15,453)$ -$ 418,014$ 418,014$ 85 CITY OF MONTICELLO Schedule of Revenues, Expenditures and Changes in Fund Balance Budget and Actual - Small Cities Development Program For the Year Ended December 31, 2022 221 Original and Final Variance with Budget Actual Final Budget Revenues Investment earnings (loss)8,000$ (30,286)$ (38,286)$ Interest on loans - 3,873 3,873 Total revenues 8,000 (26,413) (34,413) Fund balance at beginning of year 924,622 924,622 - Fund balance at end of year 932,622$ 898,209$ (34,413)$ 86 CITY OF MONTICELLO Schedule of Revenues, Expenditures and Changes in Fund Balance Budget and Actual - Cemetery Fund For the Year Ended December 31, 2022 215 Original and Final Variance with Budget Actual Final Budget Revenues Charges for services 32,900$ 67,838$ 34,938$ Investment earnings (loss)100 (3,519) (3,619) Total revenues 33,000 64,319 31,319 Expenditures Current Recreation and culture Cemetery operations 33,000 26,660 (6,340) Net change in fund balance - 37,659 37,659 Fund balance at beginning of year 80,184 80,184 - Fund balance at end of year 80,184$ 117,843$ 37,659$ 87 CITY OF MONTICELLO Schedule of Assets, Liabilities, Deferred Inflows of Resources and Fund Balances Debt Service Activities December 31, 2022 312 319 320 321 322 323 324 2011A 2015B 2016A 2017A 2018A 2019A 2020A Refunding Bonds Bonds Bonds Bonds Bonds Bonds Total ASSETS Cash and cash equivalents -$ 122,122$ 311,260$ 273,828$ 79,916$ 49,151$ 136,303$ 972,580$ Receivables Unremitted special assessments - - 2,887 948 - - 391 4,226 Delinquent special assessments - 10,403 77 51 - - 930 11,461 Deferred special assessments - 51,585 246,567 150,373 - 61,380 760,471 1,270,376 Total assets -$ 184,110$ 560,791$ 425,200$ 79,916$ 110,531$ 898,095$ 2,258,643$ LIABILITIES Accounts and contracts payable -$ 417$ 417$ 417$ 417$ 417$ 417$ 2,502$ DEFERRED INFLOWS OF RESOURCES Unavailable revenue - special assessments - 61,988 246,643 150,424 - 61,380 761,401 1,281,836 FUND BALANCES Restricted for debt service - 121,705 313,731 274,359 79,499 48,734 136,277 974,305 Total liabilities, deferred inflows of resources, and fund balances -$ 184,110$ 560,791$ 425,200$ 79,916$ 110,531$ 898,095$ 2,258,643$ General Obligation Bonds 88 CITY OF MONTICELLO Schedule of Revenues, Expenditures and Changes in Fund Balance Debt Service Activities For the Year Ended December 31, 2022 312 319 320 321 322 323 324 2011A 2015B 2016A 2017A 2018A 2019A 2020A Refunding Bonds Bonds Bonds Bonds Bonds Bonds Total Revenues Property taxes -$ 192,650$ 406,929$ 427,367$ 451,812$ 709,446$ 123,196$ 2,311,400$ Special assessments - 10,402 83,116 49,837 - 13,811 160,103 317,269 Investment earnings (loss)(1) (6,507) (17,733) (13,566) (5,361) (5,948) (4,623) (53,739) Other revenue 197,925 - - - - - - 197,925 Total revenues 197,924 196,545 472,312 463,638 446,451 717,309 278,676 2,772,855 Expenditures Debt service Principal 195,000 165,000 470,000 385,000 320,000 575,000 205,000 2,315,000 Interest and fiscal charges 3,675 45,717 57,265 85,257 127,455 143,355 36,235 498,959 Total expenditures 198,675 210,717 527,265 470,257 447,455 718,355 241,235 2,813,959 Excess (deficiency) of revenues over expenditures (751) (14,172) (54,953) (6,619) (1,004) (1,046) 37,441 (41,104) Other financing uses Transfers out (108,801) - - - - - - (108,801) Net change in fund balance (109,552) (14,172) (54,953) (6,619) (1,004) (1,046) 37,441 (149,905) Fund balance at beginning of year 109,552 135,877 368,684 280,978 80,503 49,780 98,836 1,124,210 Fund balance at end of year -$ 121,705$ 313,731$ 274,359$ 79,499$ 48,734$ 136,277$ 974,305$ General Obligation Bonds 89 DISCRETELY PRESENTED COMPONENT UNIT - ECONOMIC DEVELOPMENT AUTHORITY 90 Schedule of Assets, Liabilities, Deferred Inflows of Resources and Fund Balances Discretely Presented Component Unit - Economic Development Authority December 31, 2022 TIF 6 (d)TIF 19 TIF 20 (d)TIF 22 TIF 24 EDA General GMEF TIF Future Raindance MS Shores Prairie West Downtown St. Henry's ASSETS Cash and investments 2,745,696$ 937,668$ -$ 18,001$ -$ 104,172$ 437,082$ -$ Receivables Unremitted taxes 12,121 - - - - - - - Delinquent taxes 1,722 - - - - - 2,687 - Accounts 16,103 - - - - - -- Intrafund receivable 124,149 - - 731,000 - - - - Prepaid items 2,362 - - - - - - - Notes receivable 127,246 306,497 - - - - - - Land held for resale 2,006,336 - - - - - 163,200 - Total Assets 5,035,735$ 1,244,165$ -$ 749,001$ -$ 104,172$ 602,969$ -$ LIABILITIES Accounts and contracts payable 19,030$ -$ -$ -$ -$ -$ 6,198$ -$ Due to other governmental units 326 - - - - - - - Intrafund payable - - 45,363 - - - - - Unearned revenue - - - - - - 163,200 - Total liabilities 19,356 - 45,363 - - - 169,398 - DEFERRED INFLOWS OF RESOURCES Unavailable revenue - property taxes 1,722 - - - - - 2,687 - FUND BALANCES Nonspendable 2,362 - - - - - - - Restricted - 1,244,165 - 749,001 - 104,172 430,884 - Assigned 5,012,295 - (45,363) - - - - - Total fund balance 5,014,657 1,244,165 (45,363) 749,001 - 104,172 430,884 - Total Liabilities, Deferred Inflows of Resources, And Fund Balances 5,035,735$ 1,244,165$ -$ 749,001$ -$ 104,172$ 602,969$ -$ Required or Actual Decertification Date 12/9/2013 12/31/2023 12/10/2018 12/31/2024 12/31/2026 TIF District Type Redevelopment Housing Redevelopment Housing &Housing (d) = decertified Redevelopment 91 CITY OF MONTICELLO TIF 29 TIF 30 TIF 34 TIF 40 TIF 41 TIF 43 GAAP Total Front Porch CMHP Interchange Briggs UMC Headwaters Reconciliation EDA -$ 78,500$ 77,370$ 6,506$ -$ -$ -$ 4,404,995$ - - - - - - - 12,121 - - - - - - - 4,409 - - - - - - - 16,103 - - - - - - (855,149) - - - - - - - - 2,362 - - - - - - - 433,743 - - - - - - - 2,169,536 -$ 78,500$ 77,370$ 6,506$ -$ -$ (855,149)$ 7,043,269$ -$ -$ -$ -$ -$ 127,246$ -$ 152,474$ - - - - - -- 326 - 78,500 - - 731,286 - (855,149) - - - - - - - (163,200) - - 78,500 - - 731,286 127,246 (1,018,349) 152,800 - - - - - - - 4,409 - - - - - - - 2,362 - - 77,370 6,506 (731,286) (127,246) 163,200 1,916,766 - - - - - - - 4,966,932 - - 77,370 6,506 (731,286) (127,246) 163,200 6,886,060 -$ 78,500$ 77,370$ 6,506$ -$ -$ (855,149)$ 7,043,269$ 12/31/2029 12/31/2029 12/31/2022 12/31/2045 12/31/2030 Housing Housing Redevelopment Housing Economic Development Total fund balances - Economic Development Authority 6,886,060$ Some of the EDA's property taxes will be collected after year-end, and, therefore, are reported as deferred inflows of resources in the governmental funds.4,409 Noncurrent liabilities are not due and payable in the current period and, therefore, are not reported as liabilities in the fund. Compensated absences (13,747) Total OPEB liability (2,537) Net pension liability (119,179) Governmental funds do not report long-term amounts related to pensions and other post-employment benefits. Deferred outflows of other post-employment benefits resources 237 Deferred outflows of pension resources 37,622 Deferred inflows of other post-employment benefits resources (487) Deferred inflows of pension resources (1,646) Total net position - governmental activities 6,790,732$ 92 Schedule of Revenues, Expenditures and Changes in Fund Balance Discretely Presented Component Unit - Economic Development Authority For the Year Ended December 31, 2022 TIF 6 (d)TIF 19 TIF 20 (d)TIF 22 EDA General GMEF TIF Future Raindance MS Shores Prairie West Downtown Revenues Property taxes 388,291$ -$ -$ -$ -$ -$ -$ Tax increments - - - - 41,053 - 296,000 Intergovernmental 375,547 - - - - - - Charges for services 130,973 - - - - - - Investment earnings (loss)(115,830) - - - - - - Interest on loans 2,286 9,114 - - - - - Other revenues 836,466 - - - - - - Total revenues 1,617,733 9,114 - - 41,053 - 296,000 Expenditures Current Salary and wages 124,897 - - - - - - Benefits 46,365 - - - - - - Supplies 374 - - - - - - Professional services - legal 10,497 - - - - - - Professional services - other 278,004 - - - 249 - 1,286 LPV Insurance 1,668 - - - - - - Legal and general publications 203 - - - 48 48 48 Property taxes 13,664 - - - - - - Marketing 26,766 - - - - - - Dues and membership 8,091 - - - - - - Utilities 7,334 - - - - - - IT services 3,659 - - - - - - Travel and conferences 1,996 - - - - - - Land adjustment to market 7,479 - - - - - - Qualifying TIF expenditures - - - - 172,703 - 170,361 Other expenditures 520,119 - - - - - - Excess increments - - - - - - 188,360 Interest on intrafund loans - - - - - - - PAYG payments to third parties - - - - - - 12,191 Total expenditures 1,051,116 - - - 173,000 48 372,246 Net change in fund balances 566,617 9,114 - - (131,947) (48) (76,246) Fund balance at beginning of year 4,448,040 1,235,051 (45,363) 749,001 131,947 104,220 507,130 Fund balance at end of year 5,014,657$ 1,244,165$ (45,363)$ 749,001$ -$ 104,172$ 430,884$ Required or Actual Decertification Date 12/9/2013 12/31/2023 12/10/2018 12/31/2024 TIF District Type Redevelopment Housing Redevelopment Housing & (d) = decertified Redevelopment 93 STATISTICAL SECTION 94 CITY OF MONTICELLO Net Position by Component Last Ten Fiscal Years (accrual basis of accounting) 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Governmental activities Net investment in capital assets 44,268,757$ 48,253,810$ 38,099,568$ 41,077,683$ 41,535,637$ 43,517,983$ 40,008,410$ 40,836,892$ 52,035,838$ 52,824,487$ Restricted 18,118,070 10,453,449 12,633,770 10,569,693 11,599,951 9,649,085 8,690,172 5,451,441 4,010,180 3,353,897 Unrestricted 13,487,299 14,792,521 18,144,067 20,824,170 20,899,110 23,422,548 27,133,699 32,661,667 21,443,730 22,630,226 Total governmental net position 75,874,126$ 73,499,780$ 68,877,405$ 72,471,546$ 74,034,698$ 76,589,616$ 75,832,281$ 78,950,000$ 77,489,748$ 78,808,610$ Business-type activities Net investment in capital assets 20,496,832$ 42,117,264$ 40,722,087$ 41,014,122$ 39,944,797$ 39,250,211$ 42,808,003$ 41,000,179$ 40,089,758$ 38,793,527$ Restricted - - - - - - - - - - Unrestricted 6,463,638 9,121,952 8,163,982 9,052,590 11,905,058 13,261,505 14,855,640 17,649,288 21,628,933 24,979,320 Total business-type net position 26,960,470$ 51,239,216$ 48,886,069$ 50,066,712$ 51,849,855$ 52,511,716$ 57,663,643$ 58,649,467$ 61,718,691$ 63,772,847$ Primary government Net investment in capital assets 64,765,589$ 90,371,074$ 78,821,655$ 82,091,805$ 81,480,434$ 82,768,194$ 82,816,413$ 81,837,071$ 92,125,596$ 91,618,014$ Restricted 18,118,070 10,453,449 12,633,770 10,569,693 11,599,951 9,649,085 8,690,172 5,451,441 4,010,180 3,353,897 Unrestricted 19,950,937 23,914,473 26,308,049 29,876,760 32,804,168 36,684,053 41,989,339 50,310,955 43,072,663 47,609,546 Total primary government net position 102,834,596$ 124,738,996$ 117,763,474$ 122,538,258$ 125,884,553$ 129,101,332$ 133,495,924$ 137,599,467$ 139,208,439$ 142,581,457$ Note 1: In fiscal years 2012 and 2013, the city had a change in accounting principle, a change in fund structure, and prior period adjustments. In addition, the city implemented GASB Statement No. 68 and GASB Statement No. 71 in fiscal year 2015, and GASB Statement No. 75 in fiscal year 2018. Prior years have not been adjusted to reflect these changes. Note 2: In 2021, the city used existing resources to purchase land for future capital construction and redeemed the judgment portion of the 2014A bonds early, accounting for $10,242,136 of the increase in the net investment in capital assets and decrease in unrestricted net position for governmental activities. $- $20 $40 $60 $80 $100 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022MillionsPrimary Government Net Position Net investment in capital assets Restricted net position Unrestricted net position 95 CITY OF MONTICELLO Changes in Net Position Last Ten Fiscal Years (accrual basis of accounting) Expenses 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Governmental activities General government 1,623,727$ 1,488,243$ 1,447,725$ 1,694,111$ 1,656,666$ 1,614,613$ 1,927,752$ 2,335,614$ 2,604,600$ 2,798,491$ Public safety 1,884,981 1,880,193 1,960,009 2,187,363 2,208,971 2,377,661 2,406,748 2,658,246 3,089,673 3,168,835 Public works 5,163,461 5,223,345 5,312,612 5,480,074 5,292,743 5,548,199 5,765,576 4,777,282 4,833,405 5,556,590 Sanitation 487,268 517,956 563,477 600,300 614,328 615,586 610,944 681,948 754,132 784,052 Transit - 10,000 40,000 41,250 3,191 18,333 - - - - Recreation and culture 2,875,260 2,882,127 3,524,979 3,998,945 3,521,756 3,460,887 3,636,958 3,289,716 3,190,466 3,874,315 Economic development 1,005,813 1,084,620 1,547,875 756,620 488,380 1,206,067 872,984 1,914,825 - - Interest and fiscal charges 235,265 649,854 735,753 565,774 514,558 617,344 752,595 756,546 660,352 480,903 Total governmental activities 13,275,775 13,736,338 15,132,430 15,324,437 14,300,593 15,458,690 15,973,557 16,414,177 15,132,628 16,663,186 Business-type activities Water 1,009,600 1,084,882 1,102,610 1,168,473 1,157,506 1,235,055 1,216,446 1,212,656 1,265,578 1,348,348 Sewer 2,466,660 2,762,357 2,661,990 2,618,887 2,708,053 2,932,413 2,889,438 2,960,153 3,048,580 3,232,878 Stormwater - - - - - - - 658,771 732,851 797,995 Liquor 4,457,207 4,569,673 4,768,218 4,873,033 5,104,937 5,394,968 5,577,481 6,395,558 6,117,772 6,320,611 Fiber optics 5,240,871 2,919,170 2,536,461 2,483,262 2,252,287 2,276,015 1,990,052 2,063,712 2,081,312 2,005,196 Deputy registrar 293,531 300,236 313,968 345,492 390,658 421,662 458,695 538,625 596,933 785,822 Total business-type activities 13,467,869 11,636,318 11,383,247 11,489,147 11,613,441 12,260,113 12,132,112 13,829,475 13,843,026 14,490,850 Total primary government expenses 26,743,644$ 25,372,656$ 26,515,677$ 26,813,584$ 25,914,034$ 27,718,803$ 28,105,669$ 30,243,652$ 28,975,654$ 31,154,036$ Program Revenues Governmental activities Charges for services General government 147,244$ 180,145$ 214,087$ 274,309$ 239,460$ 207,802$ 232,336$ 523,919$ 837,564$ 989,086$ Public safety 163,366 164,616 320,158 894,311 851,307 780,236 921,916 799,227 1,305,778 956,541 Public works 544,404 371,671 521,697 527,425 283,241 217,675 373,581 156,657 94,452 147,269 Sanitation 16,653 48,385 104,786 89,956 80,774 169,337 381,328 522,088 622,549 750,623 Recreation and culture 1,307,149 1,331,581 1,488,197 1,437,659 1,493,651 1,630,915 1,602,473 652,729 948,130 1,473,281 Economic development - - 14,653 301,232 13,846 2,832 14,149 10,915 10,597 14,032 Operating grants and contributions 293,710 295,828 355,041 389,005 429,697 428,443 431,004 463,335 1,539,082 1,192,748 Capital grants and contributions 1,079,738 1,774,628 2,667,710 3,297,265 1,996,441 2,044,698 1,024,891 1,289,990 3,314,487 1,529,488 Total governmental activities program revenues 3,552,264 4,166,854 5,686,329 7,211,162 5,388,417 5,481,938 4,981,678 4,418,860 8,672,639 7,053,068 Business-type activities Charges for services Water 1,214,570 1,117,226 1,126,718 1,172,258 1,415,441 1,432,194 1,300,191 1,541,694 1,782,204 1,769,524 Sewer 1,981,491 2,081,660 2,083,122 2,223,252 2,472,774 2,581,833 2,443,856 2,559,354 2,686,445 2,925,917 Stormwater - - - - - - 61,757 241,873 356,458 529,146 Liquor 5,085,924 5,166,066 5,493,925 5,450,630 5,755,166 6,090,981 6,377,457 7,405,960 7,105,934 7,174,059 Fiber optics 1,606,720 1,761,978 1,642,403 1,739,566 1,757,134 1,736,243 1,795,435 1,851,845 1,947,738 2,195,092 Deputy registrar 456,285 497,798 535,931 562,891 594,777 694,263 953,855 801,502 942,674 895,494 Operating grants and contributions - - - - - - - - 95,601 297,608 Capital grants and contributions - 488,628 1,454,980 2,000,456 699,901 925,195 1,646,123 1,488,339 1,842,947 1,522,921 Total business-type activities program revenues 10,344,990 11,113,356 12,337,079 13,149,053 12,695,193 13,460,709 14,578,674 15,890,567 16,760,001 17,309,761 Total primary government program revenues 13,897,254$ 15,280,210$ 18,023,408$ 20,360,215$ 18,083,610$ 18,942,647$ 19,560,352$ 20,309,427$ 25,432,640$ 24,362,829$ (continued) 96 CITY OF MONTICELLO Changes in Net Position Last Ten Fiscal Years (accrual basis of accounting) 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Net (expense)/revenue Governmental activities (9,723,511)$ (9,569,484)$ (9,446,101)$ (8,113,275)$ (8,912,176)$ (9,976,752)$ (10,991,879)$ (11,995,317)$ (6,459,989)$ (9,610,118)$ Business-type activities (3,122,879) (522,962) 953,832 1,659,906 1,081,752 1,200,596 2,446,562 2,061,092 2,916,975 2,818,911 Total primary government net expense (12,846,390)$ (10,092,446)$ (8,492,269)$ (6,453,369)$ (7,830,424)$ (8,776,156)$ (8,545,317)$ (9,934,225)$ (3,543,014)$ (6,791,207)$ General Revenues and Other Changes in Net Position Governmental activities Taxes Property taxes 7,961,229$ 8,393,374$ 8,683,585$ 9,270,592$ 9,560,482$ 9,972,166$ 10,375,714$ 10,874,313$ 11,180,595$ 11,456,764$ Tax increment 965,935 826,363 727,617 668,352 648,031 638,278 679,925 707,824 - - Franchise taxes 320,640 357,409 333,484 412,217 436,248 386,622 432,934 418,030 383,045 388,074 Unrestricted grants and contributions 65,228 27,502 - - - - - 886,544 - - Investment earnings (189,128) 784,347 278,465 375,614 379,107 364,364 969,216 666,325 (168,603) (915,858) Other 3,885 217,643 30,473 11,180 - - - - - - Gain on sale of capital assets 489,782 - - - 1,725 15,000 - - 271,840 - Transfers 278,500 (3,411,500) 2,301,045 969,461 (550,265) 1,000,000 (2,223,245) 1,560,000 (200,000) - Total governmental activities 9,896,071 7,195,138 12,354,669 11,707,416 10,475,328 12,376,430 10,234,544 15,113,036 11,466,877 10,928,980 Business-type activities Franchise taxes - - - - - - - - 53,942 53,000 Unrestricted grants and contributions - - - - - - - 151,794 - - Investment earnings (117,175) 399,757 108,191 128,080 151,126 162,003 482,120 332,938 (101,693) (817,755) Miscellaneous 65,468 - 88,157 5,218 - 379,246 - - - - Gain on extinguishment of debt - 20,990,451 - - - - - - - - Contribution of land to County - -(5,511,547) - - - - - - - Transfer of operations - -- 356,900 - - - - - - Transfers (278,500) 3,411,500 (2,301,045) (969,461) 550,265 (1,000,000) 2,223,245 (1,560,000) 200,000 – Total business-type activities (330,207) 24,801,708 (7,616,244) (479,263) 701,391 (458,751) 2,705,365 (1,075,268) 152,249 (764,755) Total primary government 9,565,864$ 31,996,846$ 4,738,425$ 11,228,153$ 11,176,719$ 11,917,679$ 12,939,909$ 14,037,768$ 11,619,126$ 10,164,225$ Changes in Net Position Governmental activities 172,560$ (2,374,346)$ 2,908,568$ 3,594,141$ 1,563,152$ 2,399,678$ (757,335)$ 3,117,719$ 5,006,888$ 1,318,862$ Business-type activities (3,453,086) 24,278,746 (6,662,412) 1,180,643 1,783,143 741,845 5,151,927 985,824 3,069,224 2,054,156 Total primary government (3,280,526)$ 21,904,400$ (3,753,844)$ 4,774,784$ 3,346,295$ 3,141,523$ 4,394,592$ 4,103,543$ 8,076,112$ 3,373,018$ Note 1: The city made a fund structure change for the period ending December 31, 2013. Prior year data has not been restated as a result of this change. Note 2: The city implemented GASB Statement No. 68 and GASB Statement No. 71 in fiscal year 2015, and GASB Statement No. 75 in fiscal year 2018. Prior years have not been adjusted to reflect these changes. Note 3:The city created a new Stormwater enterprise fund in 2019. As part of creating the fund, all balances of the Storm Water Access capital projects fund were transferred to this fund. 97 CITY OF MONTICELLO General Governmental Tax Revenues by Source Last Ten Fiscal Years (accrual basis of accounting) Property Tax Franchise Year Tax Increment Tax Total 2013 7,961,229$ 965,935$ 320,640$ 9,247,804$ 2014 8,393,374 826,363 357,409 9,577,146 2015 8,683,585 727,617 333,484 9,744,686 2016 9,270,592 668,352 412,217 10,351,161 2017 9,560,482 648,031 436,248 10,644,761 2018 9,972,166 638,278 386,622 10,997,066 2019 10,375,714 679,925 432,934 11,488,573 2020 10,874,313 707,824 418,030 12,000,167 2021 11,180,595 - 383,045 11,563,640 2022 11,456,764 - 388,074 11,844,838 Change 2013-2022 43.9%-100.0%21.0%28.1% Note 1: The Economic Development Authority Fund was reclassified from a blended component unit to a discretely presented component unit in 2021. Tax increments are no longer reported in primary government. Prior years were not restated. Source: Finance Department $- $2 $4 $6 $8 $10 $12 $14 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022MillionsTax Revenues by Source Property Tax Tax Increment Franchise Tax 98 CITY OF MONTICELLO Fund Balances of Governmental Funds Last Ten Fiscal Years (modified accrual basis of accounting) 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 General Fund Nonspendable 258,100$ 126,327$ 113,302$ 134,245$ 110,869$ 124,650$ 135,139$ 145,603$ 142,846$ 113,530$ Unassigned 3,656,463 4,204,731 4,873,494 6,142,475 6,918,224 6,984,828 6,542,111 6,494,632 6,481,936 6,929,266 Total general fund 3,914,563$ 4,331,058$ 4,986,796$ 6,276,720$ 7,029,093$ 7,109,478$ 6,677,250$ 6,640,235$ 6,624,782$ 7,042,796$ All other governmental funds Nonspendable 1,822,926$ 1,815,087$ 4,259,743$ 3,690,330$ 23,488$ 47,614$ 72,028$ 27,600$ 29,474$ 26,450$ Restricted 10,928,985 10,453,449 8,619,905 6,987,234 7,924,461 5,867,997 7,567,522 5,008,177 2,948,572 2,090,545 Assigned 6,485,727 7,321,744 11,109,806 13,320,718 16,910,080 17,145,463 21,227,605 24,358,352 13,684,148 13,757,727 Total all other governmental funds 19,237,638$ 19,590,280$ 23,989,454$ 23,998,282$ 24,858,029$ 23,061,074$ 28,867,155$ 29,394,129$ 16,662,194$ 15,874,722$ Note 1: The City made a fund structure change for the period ending December 31, 2013. Prior year data has not been restated as a result of this change. Note 2: The Economic Development Authority Fund was reclassified from a blended component unit to a discretely presented component unit in 2021. Tax increments are no longer reported in primary government. Prior years were not restated. 99 CITY OF MONTICELLO Changes in Fund Balances of Governmental Funds Last Ten Fiscal Years (modified accrual basis of accounting) 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Revenues Property taxes 7,985,695$ 8,407,627$ 8,638,401$ 9,295,983$ 9,593,445$ 9,967,550$ 10,375,468$ 10,860,311$ 11,196,762$ 11,435,128$ Tax increments 965,935 826,363 727,617 668,352 648,031 638,278 679,925 707,824 - - Franchise taxes 320,640 357,409 333,484 412,217 436,248 386,622 432,934 418,030 383,045 388,074 Special assessments 2,065,944 1,912,932 3,318,901 984,390 946,669 700,190 712,681 633,016 1,699,141 718,773 Licenses and permits 331,711 378,810 461,049 668,602 600,933 504,464 603,925 521,369 804,889 613,014 Intergovernmental 1,264,781 732,366 1,520,239 2,041,362 1,340,094 911,477 896,638 1,656,228 3,912,067 1,741,507 Charges for services 1,846,919 1,722,974 2,063,520 2,222,475 1,909,357 2,098,362 2,297,568 1,474,527 2,099,582 2,646,202 Fines and forfeitures 1,725 1,900 42,474 30,656 36,702 45,350 40,054 31,852 49,566 36,808 Investment earnings (183,242) 738,956 261,856 357,112 364,786 351,620 930,128 641,446 (164,300) (845,528) Interest on loans - - - - - - 10,929 8,635 4,392 3,873 Other revenues 700,776 413,113 475,170 589,394 335,530 302,469 436,264 521,109 1,046,419 1,204,820 Total revenues 15,300,884 15,492,450 17,842,711 17,270,543 16,211,795 15,906,382 17,416,514 17,474,347 21,031,563 17,942,671 Expenditures General government 1,576,653 1,450,930 1,465,458 1,489,892 1,617,680 1,656,557 1,777,352 2,170,661 2,639,420 2,684,854 Public safety 1,805,434 1,845,073 1,972,986 2,036,777 2,178,728 2,354,453 2,449,765 2,743,954 2,874,183 2,989,883 Public works 1,707,576 1,793,162 1,734,562 1,941,750 2,009,481 2,079,305 2,393,638 1,899,315 2,123,898 2,406,209 Sanitation 505,996 517,956 563,477 600,300 614,328 615,586 610,944 681,948 754,132 784,052 Transit - 10,000 40,000 41,250 3,191 18,333 - - - - Recreation and culture 2,472,987 2,386,832 2,622,991 2,756,372 2,940,313 3,034,496 3,137,153 2,614,095 2,708,575 3,483,340 Economic development 1,011,961 1,084,620 1,237,107 530,746 486,706 1,210,053 871,950 1,917,973 - - Capital outlay 1,357,254 2,220,883 2,238,365 6,235,029 5,430,272 9,708,481 7,941,452 4,910,889 7,405,428 2,999,832 Debt service Principal 5,290,750 5,411,000 5,028,000 5,681,653 3,921,000 2,285,000 2,855,000 3,385,000 6,555,000 2,315,000 Interest and fiscal charges 930,982 658,983 570,753 529,116 470,508 522,220 634,241 756,908 697,793 498,959 Bond issuance costs - - 71,358 107,050 93,300 94,350 138,350 53,475 - - Total expenditures 16,659,593 17,379,439 17,545,057 21,949,935 19,765,507 23,578,834 22,809,845 21,134,218 25,758,429 18,162,129 Excess of revenues over (under) expenditures (1,358,709) (1,886,989) 297,654 (4,679,392) (3,553,712) (7,672,452) (5,393,331) (3,659,871) (4,726,866) (219,458) Other financing sources (uses) Long-term debt issued - 6,080,000 2,605,000 4,900,000 5,000,000 5,000,000 8,000,000 2,155,000 - - Premium (discount) on debt issued - (12,374) 46,898 97,503 78,814 40,882 131,662 101,280 - - Refunded bonds redeemed (10,690,000) - - - - - - - - - Sale of capital assets 12,428 - 30,473 11,180 1,725 15,000 29,340 333,550 271,840 - Transfers in 6,906,770 4,914,385 4,261,817 2,192,636 1,029,628 2,082,845 5,928,040 2,760,000 6,977,964 108,801 Transfers out (7,158,933) (8,325,885) (2,186,930) (1,223,175) (944,335) (1,182,845) (3,321,858) (1,200,000) (8,751,621) (258,801) Total other financing sources (uses)(10,929,735) 2,656,126 4,757,258 5,978,144 5,165,832 5,955,882 10,767,184 4,149,830 (1,501,817) (150,000) Net change in fund balances (12,288,444)$ 769,137$ 5,054,912$ 1,298,752$ 1,612,120$ (1,716,570)$ 5,373,853$ 489,959$ (6,228,683)$ (369,458)$ Debt service as percentage of noncapital expenditures 41.7%40.0%35.1%38.0%30.4%20.1%26.4%24.9%39.2%18.2% Note 1: The city made a fund structure change for the period ending December 31, 2013. Prior year data has not been modified to reflect this change. Note 2: The city redeemed the judgment portion of the 2014A bonds early in 2021. 100 CITY OF MONTICELLO Governmental Funds Tax Revenues by Source Last Ten Fiscal Years (modified accrual basis of accounting) Property Tax Franchise Year Tax Increment Tax Total 2013 7,985,695$ 965,935$ 320,640$ 9,272,270$ 2014 8,407,627 826,363 357,409 9,591,399 2015 8,638,401 727,617 333,484 9,699,502 2016 9,295,983 668,352 412,217 10,376,552 2017 9,593,445 648,031 436,248 10,677,724 2018 9,967,550 638,278 386,622 10,992,450 2019 10,375,468 679,925 432,934 11,488,327 2020 10,860,311 707,824 418,030 11,986,165 2021 11,196,762 - 383,045 11,579,807 2022 11,435,128 - 388,074 11,823,202 Change 2013-2022 43.2%-100.0%21.0%27.5% Note 1: The Economic Development Authority Fund was reclassified from a blended component unit to a discretely presented component unit in 2021. Tax increments are no longer reported in primary government. Prior years were not restated. Source: Finance Department $- $2 $4 $6 $8 $10 $12 $14 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022MillionsTax Revenues by Source Property Tax Tax Increment Franchise Tax 101 CITY OF MONTICELLO Tax Capacity Value and Estimated Market Value of Taxable Property Last Ten Fiscal Years Total Net Tax Taxable Net Capacity as a Fiscal Residential % of Commercial % of Personal % of Ag/Misc % of Tax Capacity % of Total Direct Total Percentage of Year Property Total Property Total Property Total Property Total Value Total Tax Rate Market Value Market Value 2013 4,824,117$ 25.4%13,793,916$ 72.5%239,129$ 1.3%164,609$ 0.9%19,021,771$ 100.0%42.262 1,201,075,800$ 1.6% 2014 5,408,138 21.9%18,818,097 76.4%235,713 1.0%184,750 0.7%24,646,698 100.0%44.709 1,513,570,400 1.6% 2015 5,861,759 22.1%20,316,219 76.4%238,732 0.9%164,516 0.6%26,581,226 100.0%35.737 1,712,125,200 1.6% 2016 6,505,649 23.0%21,386,874 75.6%248,668 0.9%166,437 0.6%28,307,628 100.0%34.471 1,828,437,600 1.5% 2017 7,325,880 24.2%22,510,588 74.4%272,344 0.9%141,596 0.5%30,250,408 100.0%33.172 1,962,020,100 1.5% 2018 8,086,159 27.1%21,262,918 71.4%286,580 1.0%148,899 0.5%29,784,556 100.0%32.333 1,974,154,400 1.5% 2019 8,924,604 29.2%21,267,629 69.5%274,720 0.9%143,962 0.5%30,610,915 100.0%34.262 2,054,313,700 1.5% 2020 9,422,801 29.6%21,941,590 69.0%296,422 0.9%135,311 0.4%31,796,124 100.0%34.967 2,135,371,400 1.5% 2021 10,298,432 32.4%21,153,822 66.5%188,572 0.6%187,144 0.6%31,827,970 100.0%35.659 2,173,573,500 1.5% 2022 12,798,435 36.3%22,043,296 62.5%213,032 0.6%223,509 0.6%35,278,272 100.0%36.536 2,404,352,474 1.5% Note 1: The fiscal year is for the values in the year levied (for taxes collectible in the following year). Note 2: Tax exempt property values are not included in total taxable net tax capacity value. Source: Wright County Certificate of Taxes and Taxable Properties. Real Property $- $5 $10 $15 $20 $25 $30 $35 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022MillionsTotal Taxable Net Tax Capacity Value (Excludes Personal and Ag/Misc Property) Residential Commercial 102 CITY OF MONTICELLO Property Tax Rates - All Direct and Overlapping Governments Last Ten Fiscal Years Monticello Total (1) City Wright School Special Direct and Year of Monticello County District #882 Districts Overlapping 2013 42.26 44.29 26.23 0.61 113.39 2014 44.71 43.45 28.27 -116.43 2015 35.74 40.59 22.88 -99.21 2016 34.47 39.97 20.86 1.08 96.38 2017 33.17 39.60 16.24 1.02 90.03 2018 32.33 39.95 15.62 1.09 89.00 2019 34.26 44.27 19.97 1.20 99.70 2020 34.97 44.42 15.87 1.18 96.44 2021 35.66 43.72 15.39 1.18 95.95 2022 36.54 43.75 15.46 1.25 97.00 Note 1: Source:Wright County Overlapping Taxing Districts Information reflects total tax rates levied by each entity. Tax rates are expressed in terms of “net tax capacity.” A property’s tax capacity is determined by multiplying its taxable market value by a state determined class rate. Class rates vary by property type and change periodically based on state legislation. Components of the direct rate are not 0 5 10 15 20 25 30 35 40 45 50 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022Rate %Property Tax Rates For the three highest taxing authorities Wright County School District #882 City of Monticello 103 CITY OF MONTICELLO Property Tax Levies and Collections Last Ten Fiscal Years PROPERTY TAXES Net Tax Collections in Abatements Fiscal Levy for % of Subsequent % of and % of Year Fiscal Year Amount Net Levy Years Amount Net Levy Adjustments Amount Net Levy 2013 7,900,724$ 7,827,356$ 99.1%40,584$ 7,867,940$ 99.6%(31,626)$ 1,158$ 0.0% 2014 8,151,086 8,109,373 99.5%33,788 8,143,161 99.9%(7,013) 912 0.0% 2015 8,535,565 8,498,745 99.6%23,627 8,522,372 99.8%(12,524) 669 0.0% 2016 9,205,700 9,177,787 99.7%24,415 9,202,202 100.0%(3,430) 68 0.0% 2017 9,430,000 9,416,303 99.9%12,151 9,428,454 100.0%(1,546) - 0.0% 2018 9,870,000 9,850,163 99.8%11,274 9,861,437 99.9%(8,563) - 0.0% 2019 10,310,000 10,289,339 99.8%27,565 10,316,904 100.1%9,829 2,925 0.0% 2020 10,800,000 10,770,454 99.7%1,916 10,772,370 99.7%(23,797) 3,833 0.0% 2021 11,063,700 11,053,758 99.9%14,556 11,068,314 100.0%11,657 7,043 0.1% 2022 11,353,000 11,314,942 99.7%- 11,314,942 99.7%(1,333) 36,725 0.3% Source: Wright County Collected within the Total Collections Year of the Net Levy to Date Total Uncollected 104 CITY OF MONTICELLO Principal Property Taxpayers Current Year and Nine Years Ago Percentage Percentage Taxable Total Taxable Total (1)Net Tax Net Tax Net Tax Net Tax Market Capacity Capacity Market Capacity Capacity Taxpayer Value Value Rank Value Value Value Rank Value Xcel Energy (Northern States)796,071,000$ 15,905,303$ 1 45.1%495,349,400$ 9,901,516$ 1 52.1% IRET Properties 35,840,200 448,003 2 1.3% Mills Fleet Farm (Venturian Holdings)13,211,000 261,220 3 0.7% Monticello Sr. Housing Own LLC 12,318,000 153,975 4 0.4% Target Corporation 10,300,000 205,250 5 0.6%11,819,200 235,634 3 1.2% Walmart Real Estate Bus Trust 9,980,000 198,850 6 0.6%12,804,100 255,332 2 1.3% Clear Creek Land Company, LLC 9,698,400 192,468 7 0.5% RCG-Monticello MN, LLC 9,204,900 179,598 8 0.5% Bluffs in Monticello LLC 8,245,600 103,244 9 0.3% UMC Real Estate LLC 7,804,500 154,590 10 0.4% CentraCare Medical Center (New River)0.0%7,544,100 150,882 4 0.8% Home Depot USA, Inc.0.0%7,225,200 143,754 5 0.8% BBF Properties 3,977,400 78,798 9 0.4% Spirit Master Funding (Muller Theatres)5,536,400 109,597 6 0.6% AX TC Retail, LP 5,154,800 101,596 7 0.5% RCE Property LLC 4,788,600 95,022 8 0.5% Minnegasco Inc 3,983,100 79,662 10 0.4% 912,673,600$ 17,802,501$ 50.5%558,182,300$ 11,151,793$ 58.6% (1) The market value and taxable net tax capacity value is for taxes levied in 2021, which are payable in 2022. Source: Wright County Certificate of Taxes and Taxable Properties and 2012 City of Monticello Financial Report 2022 2013 105 CITY OF MONTICELLO New Construction and Bank Deposits Last Ten Fiscal Years New New New New Total New Commercial Commercial Residential Residential Residential &Percent Year Permits Value Permits Value Commercial Total (1)Change 2013 3 1,790,000$ 52 8,920,580$ 10,710,580$ 1,425,497$ 1.3% 2014 3 2,106,000 72 12,317,617 14,423,617 1,486,376 4.3% 2015 2 763,000 44 8,836,399 9,599,399 1,557,782 4.8% 2016 7 19,425,000 61 12,750,071 32,175,071 1,643,984 5.5% 2017 3 3,270,264 64 13,358,118 16,628,382 1,765,565 7.4% 2018 4 6,783,829 58 12,148,575 18,932,404 1,827,691 3.5% 2019 4 7,228,571 56 10,712,880 17,941,451 1,915,042 4.8% 2020 1 1,050,000 68 12,473,308 13,523,308 2,387,138 24.7% 2021 4 6,112,240 95 21,993,822 28,106,062 2,736,992 14.7% 2022 5 23,075,719 35 9,763,675 32,839,394 2,828,229 3.3% (1) Reported for Wright County as of June 30 Source: City of Monticello building department and FDIC Market Share Reports Bank Deposits (000s)Building Permits $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 New Residential and Commercial Construction Residential Commercial 106 CITY OF MONTICELLO Water Sold by Customer Type Last Ten Fiscal Years (gallons) Total % of % of % of % of Water % of Year Residential Total Commercial Total Industrial Total Government Total Sold Total 2013 383,079,041 68.8%85,819,687 15.4%45,954,136 8.2%42,206,803 7.6%557,059,667 100.0% 2014 328,835,772 68.2%79,370,922 16.5%38,308,124 7.9%35,566,000 7.4%482,080,818 100.0% 2015 325,188,041 68.1%76,283,322 16.0%38,897,216 8.1%37,005,919 7.8%477,374,498 100.0% 2016 329,068,876 67.7%77,795,226 16.0%42,407,860 8.7%36,647,583 7.5%485,919,545 100.0% 2017 371,596,967 67.7%93,770,712 17.1%43,220,312 7.9%40,409,649 7.4%548,997,640 100.0% 2018 352,322,681 67.3%89,911,481 17.2%43,067,083 8.2%38,128,401 7.3%523,429,646 100.0% 2019 307,411,101 64.0%93,783,767 19.5%44,120,527 9.2%35,187,913 7.3%480,503,308 100.0% 2020 392,258,038 70.1%92,058,431 16.5%39,630,515 7.1%35,351,965 6.3%559,298,949 100.0% 2021 442,964,466 71.6%97,483,202 15.8%39,768,999 6.4%38,252,736 6.2%618,469,403 100.0% 2022 409,192,333 69.5%96,391,875 16.4%45,202,637 7.7%37,749,850 6.4%588,536,695 100.0% Source: City of Monticello utility billing department 0 100 200 300 400 500 600 700 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022MillionsWater Sold by Customer Type (gallons) Government Industrial Commercial Residential 107 CITY OF MONTICELLO Water and Sewer Utility Rates Last Ten Fiscal Years Rate Tier 1 Rate Tier 2 Rate Tier 3 Rate Tier 4 State of Rate Tier 1 Rate Tier 1 Base Rate 501–4,000 4,001–13,369 Over 13,369 Minnesota Base Rate Over 500 Fiscal First 500 per 100 per 100 per 100 Connection First 500 per 100 Year Cubic Feet Cubic Feet Cubic Feet Cubic Feet Fee Cubic Feet Cubic Feet 2013 17.00$ 1.13$ 1.31$ 1.43$ -$ 20.65$ 3.70$ 2014 17.00 1.13 1.31 1.43 - 20.65 3.70 2015 17.85 1.19 1.38 1.50 - 21.69 3.89 2016 18.85 1.22 1.41 1.50 - 22.69 3.97 Rate Tier 1 Rate Tier 2 Rate Tier 3 Rate Tier 4 State of Rate Tier 1 Rate Tier 1 Base Rate 1,001–10,000 10,001–33,000 Over 33,000 Minnesota Base Rate Over 1,000 Fiscal First 1,000 per 1,000 per 1,000 per 1,000 Connection First 1,000 per 1,000 Year Gallons Gallons Gallons Gallons Fee Gallons Gallons 2017 6.45 1.66 1.92 2.09 - 8.05 5.48 2018 6.95 1.70 1.97 2.15 - 8.75 5.63 2019 7.10 1.74 2.02 2.21 - 9.00 5.77 2020 7.10 1.74 2.02 2.21 0.81 9.18 5.89 2021 7.81 1.83 2.12 2.32 0.81 10.10 6.19 2022 8.04 1.88 2.18 2.39 0.81 10.40 6.38 Note: The city began billing monthly in 2017. Source: City of Monticello fee schedule Residential & Commercial Residential & Commercial Water Sewer Water Sewer 108 CITY OF MONTICELLO Ratios of Outstanding Debt by Type Last Ten Fiscal Years 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Governmental activities General obligation bonds Special assessment 13,010,000$ 12,203,653$ 11,689,653$ 12,730,000$ 12,695,000$ 10,925,000$ 9,200,000$ 9,290,000$ 8,050,000$ 6,780,000$ Other 7,506,653 10,487,000 9,563,000 7,686,000 5,785,000 5,375,000 11,600,000 10,770,000 5,960,000 5,435,000 Tax abatement - - - - 2,960,000 7,800,000 8,390,000 7,845,000 7,280,000 6,700,000 Net premium (discount)265,320 67,350 190,196 159,266 128,336 105,777 69,187 44,028 18,869 - Total GO bonds 20,781,973 22,758,003 21,442,849 20,575,266 21,568,336 24,205,777 29,259,187 27,949,028 21,308,869 18,915,000 Certificates of indebtedness 445,000 385,000 325,000 265,000 200,000 135,000 70,000 - - - Total general obligation debt 21,226,973 23,143,003 21,767,849 20,840,266 21,768,336 24,340,777 29,329,187 27,949,028 21,308,869 18,915,000 Non-general obligation bonds Revenue bonds 1,782,784 985,000 - - - - - - - - Total governmental activities 23,009,757$ 24,128,003$ 21,767,849$ 20,840,266$ 21,768,336$ 24,340,777$ 29,329,187$ 27,949,028$ 21,308,869$ 18,915,000$ Business-type activities General obligation revenue bonds 3,479,347$ 3,206,347$ 2,930,347$ 2,460,000$ 2,280,000$ 2,095,000$ 1,910,000$ 1,720,000$ 1,525,000$ 1,325,000$ Non-general obligation Revenue bonds 26,445,000 - - - - - - - - - PFA notes - - 615,268 1,927,850 1,998,402 1,903,000 1,800,000 1,696,000 1,591,000 1,485,000 Net premium (discount)(360,211) 31,941 30,339 27,354 23,495 21,510 19,524 17,539 15,553 - Total business-type activities 29,564,136$ 3,238,288$ 3,575,954$ 4,415,204$ 4,301,897$ 4,019,510$ 3,729,524$ 3,433,539$ 3,131,553$ 2,810,000$ Total primary government 52,573,893$ 27,366,291$ 25,343,803$ 25,255,470$ 26,070,233$ 28,360,287$ 33,058,711$ 31,382,567$ 24,440,422$ 21,725,000$ % of personal income (1)10.1%5.1%4.4%4.2%4.2%4.4%4.8%4.4%3.1%2.5% Per capita debt (1)4,055$ 2,106$ 1,931$ 1,899$ 1,944$ 2,093$ 2,399$ 2,260$ 1,691$ 1,486$ (1) See the Schedule of Demographic and Economic Statistics. Source: Details regarding the city’s outstanding debt can be found in the notes to basic financial statements. 109 CITY OF MONTICELLO Ratios of Net General Obligation Bonded Debt Outstanding Last Ten Fiscal Years Percentage of Less Net Estimated General Position Actual Market Obligation Restricted for Value of Year Bonds (1)Debt Service Total Property (2)Per Capita (3) 2013 24,706,320$ 9,660,316$ 15,046,004$ 1.25%1,161$ 2014 26,349,350 9,942,901 16,406,449 1.08%1,263 2015 24,728,535 9,266,800 15,461,735 0.90%1,178 2016 23,327,620 7,009,231 16,318,389 0.89%1,227 2017 24,071,831 6,359,147 17,712,684 0.90%1,321 2018 26,457,287 6,082,504 20,374,783 1.03%1,503 2019 31,258,711 5,251,080 26,007,631 1.27%1,887 2020 29,686,567 2,565,047 27,121,520 1.27%1,953 2021 22,849,422 2,185,818 20,663,604 0.95%1,430 2022 20,240,000 2,237,657 18,002,343 0.75%1,231 (1) Does not include revenue bonds. (2) See the Schedule of Taxable Net Tax Capacity Value and Estimated Market Value of Taxable Property for the estimated actual market value. (3) See the Schedule of Demographic and Economic Statistics. Source: Details regarding the city’s outstanding debt can be found in the notes to basic financial statements. 110 CITY OF MONTICELLO Legal Debt Margin Information Last Ten Fiscal Years 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 35,671,296$ 45,407,112$ 51,363,756$ 54,853,128$ 58,860,603$ 59,224,632$ 61,629,411$ 64,061,142$ 65,207,205$ 73,983,876$ Total net debt applicable to debt limit 6,200,000 10,872,000 9,888,000 7,951,000 8,945,000 13,310,000 20,060,000 14,390,000 9,215,000 8,315,000 Legal debt margin 29,471,296$ 34,535,112$ 41,475,756$ 46,902,128$ 49,915,603$ 45,914,632$ 41,569,411$ 49,671,142$ 55,992,205$ 65,668,876$ Total net debt applicable to debt limit as a percentage of debt limit 17.4%23.9%19.3%14.5%15.2%22.5%32.5%22.5%14.1%11.2% Market value for fiscal year 2021 (payable 2022)2,466,129,200$ Debt limit (3% of market value)73,983,876$ Debt applicable to limit General obligation bonds 20,240,000$ Less amounts for general obligation bonds not subject to debt limit (11,925,000) Total net debt applicable to limit 8,315,000 Legal debt margin 65,668,876$ Source: Details regarding the city’s outstanding debt can be found in the notes to basic financial statements. Market value data provided in Wright County Certificate of Taxes and Taxable Properties. Legal Debt Margin Calculation Fiscal Year Legal debt limit 111 CITY OF MONTICELLO Computation of Direct and Overlapping Debt As of December 31, 2022 Estimated Gross Percentage Amount Bonded Debt Applicable Applicable to Jurisdiction Outstanding to City (1)City DIRECT DEBT: City of Monticello 18,915,000$ 100.0%18,915,000$ OVERLAPPING DEBT: I.S.D. 882 44,393,291 74.7%33,161,788 Wright County 148,576,431 14.4%21,395,006 Total Overlapping Debt 54,556,794 Total direct and overlapping debt 73,471,794$ (1) Note: Source: The Wright County auditor provided the debt outstanding and estimated applicable percentages for the school district and county. The percentage of overlapping debt applicable is estimated using taxable assessed property values. Applicable percentages were estimated by determining the portion of the government’s taxable assessed value that is within the City’s boundaries and dividing it by the government’s total taxable assessed value. Overlapping governments are those that coincide, at least in part, with the geographic boundaries of the City. This schedule estimates 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 government’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. 112 CITY OF MONTICELLO Schedule of General Obligation Revenue Bond Coverage Last Ten Fiscal Years Sewer Fund: Net Revenue Gross Operating Available for Year (3)Revenues (1)Expenses(2)Debt Service Principal Interest Total Coverage 2014 2,081,660$ 1,570,197$ 511,463$ 273,000$ 91,963$ 364,963$ 140.1% 2015 2,083,122 1,479,157 603,965 276,000 84,158 360,158 167.7% 2016 2,223,252 1,411,831 811,421 570,830 78,002 648,832 125.1% 2017 2,472,774 1,552,617 920,157 289,000 63,823 352,823 260.8% 2018 2,581,833 1,674,428 907,405 287,149 81,125 368,274 246.4% 2019 2,443,856 1,596,714 847,142 288,000 76,826 364,826 232.2% 2020 2,559,354 1,663,234 896,120 294,000 72,972 366,972 244.2% 2021 2,686,445 1,777,133 909,312 300,000 67,126 367,126 247.7% 2022 2,925,917 1,980,086 945,831 306,000 61,817 367,817 257.1% (1) Total revenues does not include investment earnings. (2) Total operating expenses excluding depreciation. Source: Finance Department Debt Service Requirements (3) 113 CITY OF MONTICELLO Demographic and Economic Statistics Last Ten Fiscal Years Per Estimated Capita Unemployment School Personal Personal Year Population (1)rate (2)Enrollment (3)Income (4)Income (5) 2013 12,964 4.6%4,031 520,193,464$ 40,898$ 2014 12,993 3.8%4,010 531,660,567 41,844 2015 13,125 3.7%4,115 570,058,125 43,710 2016 13,299 4.3%4,027 603,960,786 45,458 2017 13,409 3.5%4,075 620,461,248 46,333 2018 13,553 3.4%4,158 644,811,081 48,370 2019 13,782 3.8%4,053 691,594,542 50,480 2020 13,886 4.4%4,099 716,642,574 51,609 2021 14,455 2.5%4,113 798,176,190 55,218 2022 14,619 3.6%4,206 858,953,964 58,756 Notes/sources: (1) (2) (3) (4) (5) Minnesota State Demographic Center population estimates. ISD No. 882 enrollment information was obtained from the District's Financial Report for the year ended June 30, 2022. This estimated personal income number is calculated by taking the per capita personal income and multiplying it by the City’s population. Also see note (5) regarding the per capita personal income figures. Per capita personal income data is provided by the Bureau of Economic Analysis. Monticello's estimates are based on Wright County information. Wright County, where Monticello is located, is the smallest, relevant statistical tracking area. Data is subject to annual revisions by the Bureau of Economic Analysis. Annual average unemployment rate for Wright County provided by the Minnesota Department of Employment & Economic Development. 114 CITY OF MONTICELLO Principal Employers Current Year and Nine Years Ago Percentage of Percentage of Total City Total City Employer Employees Rank Employment (1)Employees Rank Employment (1) ISD No. 882 (Monticello)684 1 8.5%544 2 5.5% Xcel Energy (Northern States)650 2 8.1%2,000 1 20.2% CentraCare Medical Center (New River)577 3 7.2%500 3 5.1% Cargill Kitchen Solutions (Sunny Fresh)425 4 5.3%350 4 3.5% Target 307 5 3.8% Wal-Mart Supercenter 225 6 2.8%325 5 3.3% Ultra Machine Corporation 215 7 2.7%173 7 1.8% City of Monticello 176 8 2.2%127 9 1.3% Home Depot 157 9 2.0%160 8 1.6% WSI Industries, Inc.120 10 1.5% Cub Foods 180 6 1.8% Hoglund Bus/Hoglund Truck 88 10 0.9% 2,852 40.4%3,903 39.5% Source: City of Monticello 2022 Survey and 2013 City of Monticello ACFR. 2022 2013 (1) The city estimates its workforce by using the city's percentage of total county population and multiplying that number by the county's total workforce. 115 CITY OF MONTICELLO City Government Employees by Function/Program Last Ten Fiscal Years 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Employees by function General Fund General government 11.00 12.50 12.50 13.50 11.50 11.50 11.50 11.75 10.75 11.75 Public safety Building 3.00 3.00 4.00 4.00 4.00 3.00 3.00 3.00 4.00 4.00 Fire marshal - - - - - 1.00 1.00 1.00 1.00 - Public works Engineering 1.00 1.00 1.00 1.00 1.00 2.00 2.00 2.00 3.00 3.00 Maintenance(1)19.00 18.50 18.50 18.50 10.50 9.50 9.60 8.80 8.60 8.30 Recreation and culture Parks (1)5.00 5.00 5.00 5.00 13.00 10.00 8.90 9.90 10.70 11.10 Community development 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 Special Revenue Funds Recreation and culture Community center - FT 8.00 7.50 7.50 7.50 7.50 7.50 7.50 7.50 6.00 6.00 Community center - PT(2)36.50 36.50 36.50 36.50 38.10 37.30 35.00 14.70 16.80 25.70 Enterprise Funds Sewer/water 4.00 4.00 5.00 5.00 6.00 6.00 6.50 6.50 7.50 8.90 Deputy registrar 5.00 5.00 5.00 5.00 7.50 7.00 7.60 6.80 8.90 9.20 Liquor store 10.00 11.50 11.50 11.50 12.40 13.10 14.20 11.90 12.50 13.20 FiberNet (3)8.50 8.50 8.50 - - - - - - - Internal Services Funds Facilities maintenance - - - - - - - - 1.00 1.00 Information technology - - - - - - - - 1.00 1.00 Total 113.00 115.00 117.00 109.50 113.50 109.90 108.80 85.85 93.75 105.15 Employees by fund type General Fund 41.00 42.00 43.00 44.00 42.00 39.00 38.00 38.45 40.05 40.15 Special Revenue Funds 44.50 44.00 44.00 44.00 45.60 44.80 42.50 22.20 22.80 31.70 Enterprise Funds 27.50 29.00 30.00 21.50 25.90 26.10 28.30 25.20 30.90 33.30 113.00 115.00 117.00 109.50 113.50 109.90 108.80 85.85 93.75 105.15 FT = Full-time PT = Part-time (1) Includes seasonal employees (2) 2013 was estimated using 2014 levels as data was not previously tracked. Reduction in 2020 was due to COVID-19 pandemic. (3) Management and operations were contracted out beginning July 1, 2016. Source: City of Monticello Human Resources Department Fiscal Year 116 CITY OF MONTICELLO Operating Indicators by Function Last Ten Fiscal Years 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Function Fire Calls for service 270 286 262 270 312 269 294 272 373 384 Public works Salt (tons)475 385 534 525 461 585 752 730 700 600 Sand (tons)325 600 285 300 397 329 432 400 - 24 Crack sealant (pounds)25,739 23,282 29,580 49,039 46,721 46,868 47,176 44,456 18,276 - Asphalt repairs (tons of asphalt)225 190 293 220 167 164 492 443 527 664 Recreation and culture Shade trees planted 275 270 257 280 320 305 314 220 300 75 Diseased trees removed 71 46 208 60 40 12 15 6 25 15 Trails maintained (miles)17 18 18 20 40 40 41 41 42 43 Community center users 211,234 204,134 199,228 197,523 188,124 183,523 183,521 71,632 94,448 117,942 Program sales 192,708$ 184,125$ 213,924$ 193,628$ 162,461$ 183,194$ 112,506$ 17,930$ 44,837$ 62,486$ Rental revenue 163,329$ 150,964$ 154,938$ 168,353$ 190,343$ 199,200$ 197,351$ 73,096$ 127,144$ 155,364$ Library Items checked out 263,220 199,182 195,235 190,433 182,986 182,691 171,460 112,334 143,223 138,428 Programs offered 173 169 167 212 290 287 243 102 104 133 Program participants 3,773 3,788 3,919 4,306 5,336 5,059 4,788 4,810 1,772 3,317 Economic development Permits issued 659 721 768 802 911 856 837 957 1,008 909 Permit valuation 15,821,223$ 19,714,895$ 36,242,742$ 59,426,683$ 43,853,123$ 33,125,788$ 45,723,446$ 32,453,366$ 66,827,121$ 41,989,848$ New residential dwellings 52 72 44 61 64 58 56 68 95 35 Water Meters read 15,815 16,099 16,520 16,800 51,240 52,092 52,752 53,496 54,564 56,402 Meters/remotes replaced 235 598 694 991 734 606 426 54 58 75 Water valves maintained 100 242 436 400 400 401 447 120 533 479 Hydrants maintained 300 203 430 250 177 172 428 153 216 225 Residential water gallons used 383,079,041 328,835,772 325,188,041 329,068,876 371,596,967 352,322,681 307,411,101 392,258,038 442,964,466 409,192,333 Sewer Sewer flow (MG)392 435 417 432 445 434 473 446 482 425 Thickened sludge (wet tons)n/a 1,924 1,549 1,449 1,578 2,115 2,145 2,072 2,207 2,231 Thickened sludge (dry tons)n/a 264 236 216 229 333 336 314 336 317 Dry tons as % of wet tons n/a 13.72%15.24%14.91%14.51%15.74%15.66%15.48%15.22%14.21% Fiscal Year 117 CITY OF MONTICELLO Operating Indicators by Function Last Ten Fiscal Years (continued) 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Fiber optics Customers n/a 1,539 1,574 1,630 1,671 1,639 1,701 1,851 1,842 1,786 Service subscriptions n/a 2,755 2,656 2,589 2,528 2,388 2,381 2,439 2,394 2,283 TV customers n/a 813 714 641 543 458 395 323 289 256 Phone customers n/a 582 518 461 431 386 362 315 297 275 Internet customers n/a 1,360 1,424 1,487 1,554 1,544 1,624 1,801 1,808 1,752 Liquor store Transactions n/a 229,236 237,535 235,901 248,356 261,071 267,276 260,957 250,962 249,604 Average liquor sale transaction n/a 22$ 22$ 22$ 22$ 23$ 23$ 27$ 27$ 28$ Beer sales 2,539,168$ 2,604,942$ 2,763,478$ 2,768,394$ 2,933,853$ 3,074,408$ 3,252,142$ 3,838,912$ 3,665,223$ 3,695,676$ Liquor sales 1,506,776$ 1,546,118$ 1,634,198$ 1,624,908$ 1,739,562$ 1,909,953$ 2,019,096$ 2,351,072$ 2,276,808$ 2,340,709$ Wine sales 860,817$ 868,779$ 927,732$ 889,082$ 894,151$ 904,385$ 894,005$ 982,113$ 915,444$ 882,772$ Other sales 138,854$ 145,903$ 166,654$ 171,420$ 192,615$ 201,482$ 212,052$ 232,452$ 249,112$ 253,581$ Gross profit margin % - beer 22.5%21.4%25.6%21.1%23.2%21.4%22.5%21.2%23.8%24.5% Gross profit margin % - liquor 27.7%30.3%29.8%29.0%26.6%29.0%30.1%30.7%28.9%30.9% Gross profit margin % - wine 29.7%30.7%31.5%32.5%34.4%32.5%31.8%33.4%29.6%27.0% Annual sales increase 4.1%2.4%6.3%-0.7%5.6%5.7%4.7%16.1%-4.0%0.9% Deputy registrar (DMV) Motor vehicle transactions 55,261 60,051 64,927 67,508 70,605 110,574 129,825 115,466 88,875 77,515 DNR transactions 5,727 5,949 5,914 6,318 5,873 7,009 8,148 8,424 8,759 9,984 Game/fish transactions 445 433 387 600 647 549 709 311 265 245 Drivers licenses transactions 951 1,462 1,294 1,465 1,390 1,411 1,283 2,927 3,885 3,334 Total transactions 62,384 67,895 72,522 75,891 78,515 119,543 139,965 127,128 101,784 91,078 Dealerships serviced 19 19 19 21 27 28 30 32 32 43 Net revenue per transaction 2.68$ 2.91$ 3.02$ 3.05$ 2.66$ 2.21$ 3.48$ 2.15$ 1.16$ 1.30$ N/A = Not Available MG = Millions of Gallons Notes: Indicators are not available for the general government function. The City transitioned from quarterly to monthly utility billing in 2017. State implementation of MNLARS changed how transactions are counted in 2018. In late 2020, the DMV's system changed again to MNDrive, which also counts transactions differently. Sources: Various city departments (continued) Fiscal Year 118 CITY OF MONTICELLO Capital Assets Statistics by Function Last Ten Fiscal Years 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Function Public safety Fire Fire stations in service 1 1 1 1 1 1 1 1 1 1 Number of volunteers 30 30 30 30 30 30 30 30 30 30 Public works Streets (miles)68.0 68.0 68.0 68.0 69.0 70.0 70.0 70.0 70.0 81.0 Recreation and culture Parks acreage maintained 180 180 180 185 320 320 360 360 365 365 Parks 28 30 30 30 30 30 30 30 30 30 Park buildings 15 15 15 15 15 18 18 18 19 19 Community center (sq. ft.)82,000 82,000 82,000 82,000 82,000 82,000 82,000 82,000 82,000 82,000 Water Fire hydrants 700 700 700 700 700 700 700 700 700 700 Note: No capital asset indicators are available for the general government and economic development functions. Note: The city contributed jointly-owned land at the Bertram Chain of Lakes to Wright County in 2015. Source: Various city departments 119 CITY OF MONTICELLO Schedule of Cash Flows Adjusted for Additional City Funding of Fiber Optics Fund Last Eight Fiscal Years 2015 2016 2017 2018 2019 2020 2021 2022 Cash flows from operating activities Cash received from customers and users 1,733,236$ 1,613,032$ 1,886,377$ 1,679,899$ 1,789,793$ 1,819,710$ 1,924,721$ 2,146,870$ Cash paid to suppliers for goods and services (1,332,231) (1,657,929) (1,955,033) (1,877,048) (1,465,167) (1,545,323) (1,811,460) (1,669,489) Cash paid to employees (565,657) (322,670) (18,367) (205) (244) (4,086) (2,265) - Cash paid to other funds for services provided (24,291) (26,929) - (1,530) (1,194) (1,050) (1,050) (820) Net cash used by operating activities (188,943) (394,496) (87,023) (198,884) 323,188 269,251 109,946 476,561 Cash flows from noncapital financing activities Transfers from other funds 450,000 350,000 180,000 130,000 - - - - Franchise fees - - - - - - - 53,000 Intergovernmental revenues - - - - - 82,063 - - Net cash provided by noncapital financing activities 450,000 350,000 180,000 130,000 - 82,063 - 53,000 Cash flows from capital and related financing activities Sale of assets 29,850 - - - - - - - Acquisition of capital assets - - - - - (171,210) (92,701) (199,209) Net cash provided (used) by capital and related financing activities 29,850 - - - - (171,210) (92,701) (199,209) Cash flows from investing activities Interest on investments 8,255 5,783 4,490 3,216 16,259 14,001 (4,496) (37,000) Net increase (decrease) in cash and cash equivalents 299,162 (38,713) 97,467 (65,668) 339,447 194,105 12,749 293,352 Additional city funding Transfer from liquor fund (450,000) (350,000) (180,000) (130,000) - - - - 2014A debt service paid by property tax levy/fund balance (163,712) (515,519) (512,086) (512,665) (512,357) (511,638) (4,438,821) - Adjusted net decrease in cash and cash equivalents (314,550)$ (904,232)$ (594,619)$ (708,333)$ (172,910)$ (317,533)$ (4,426,072)$ 293,352$ $(5,000,000) $(4,000,000) $(3,000,000) $(2,000,000) $(1,000,000) $- $1,000,000 2015 2016 2017 2018 2019 2020 2021 2022 Fiber Optics Fund Cash Flows Net increase (decrease) in cash and cash equivalents Transfer from liquor fund 2014A debt service paid by property tax levy/fund balance Adjusted net decrease in cash and cash equivalents 120