HomeMy WebLinkAbout2022 ACFR C i ' F
NDOVE
1685 CROSSTOWN BOULEVARD N.W. . ANDOVER, MINNESOTA 55304 . (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
Annual Comprehensive Financial Report
of the
City of Andover, Minnesota
For the Year Ended
December 31, 2022
Prepared By: Finance Department
City of Andover
CITY OF ANDOVER,MINNESOTA
TABLE OF CONTENTS
Page
Reference No.
1.INTRODUCTORY SECTION
Letter of Transmittal 2
Organization 9
Organizational Chart 10
Certificate of Achievement 11
11.FINANCIAL SECTION
Independent Auditor's Report 14
Management's Discussion and Analysis 18
Basic Financial Statements:
Government-Wide Financial Statements:
Statement of Net Position Statement 1 31
Statement of Activities Statement 2 32
Fund Financial Statements:
Balance Sheet-Governmental Funds Statement 3 34
Statement of Revenues,Expenditures and Changes in Fund Balances-
Governmental Funds Statement 4 36
Reconciliation of the Statement of Revenues,Expenditures and Changes in
Fund Balances of Governmental Funds to the Statement of Activities Statement 5 39
Statement of Net Position-Proprietary Funds Statement 6 40
Statement of Revenues,Expenses and Changes in Net Position-
Proprietary Funds Statement 7 42
Statement of Cash Flows-Proprietary Funds Statement 8 44
Notes to Financial Statements 46
Required Supplementary Information:
Budgetary Comparison Schedule-General Fund Statement 9 80
Budgetary Comparison Schedule-Community Center Special Revenue Fund Statement 10 82
Budgetary Comparison Schedule-CARES Grant/ARPA Funding Special Revenue Fund Statement 11 83
Schedule of Changes in the Total OPEB Liability and Related Ratios Statement 12 84
Schedule of Proportionate Share of Net Pension Liability-General Employees Retirement Fund Statement 13 85
Schedule of Pension Contributions-General Employees Retirement Fund Statement 14 86
Schedule of Proportionate Share of Net Pension Liability-Public Employees Police and Fire Fund Statement 15 87
Schedule of Pension Contributions-Public Employees Police and Fire Fund Statement 16 88
Notes to Required Supplementary Information:
Budgets 89
Modified Approach for City Streets and Trails Infrastructure Capital Assets 89
OPEB Information 90
Pension Information 90
CITY OF ANDOVER,MINNESOTA
TABLE OF CONTENTS
Page
Reference No.
Combining and Individual Fund Statements and Schedules:
Nonmajor Governmental Funds:
Combining Balance Sheet-Nonmajor Governmental Funds Statement 17 95
Combining Statement of Revenues,Expenditures and Changes in Fund Balances-
Nonmajor Governmental Funds Statement 18 96
Nonmajor Special Revenue Funds:
Subcombining Balance Sheet-Nonmajor Special Revenue Funds Statement 19 98
Subcombining Statement of Revenues,Expenditures and Changes in
Fund Balances-Nonmajor Special Revenue Funds Statement 20 100
Nonmajor Debt Service Funds:
Subcombining Balance Sheet-Nonmajor Debt Service Funds Statement 21 104
Subcombining Statement of Revenues,Expenditures and Changes in
Fund Balances-Nonmajor Debt Service Funds Statement 22 106
Nonmajor Capital Projects Funds:
Subcombining Balance Sheet-Nonmajor Capital Project Funds Statement 23 110
Subcombining Statement of Revenues,Expenditures and Changes in
Fund Balances-Nonmajor Capital Project Funds Statement 24 112
Special Revenue Funds:
Schedules of Revenues,Expenditures and Changes in
Fund Balances-Budget and Actual:
EDA General Statement 25 114
Drainage and Mapping Statement 26 115
LRRWMO Statement 27 116
Forestry Statement 28 117
Right-of-Way Management/Utility Statement 29 118
Charitable Gambling Statement 30 119
Construction Seal Coating Statement 31 120
Internal Service Funds:
Combining Statement of Net Position-Internal Service Funds Statement 32 122
Combining Statement of Revenues,Expenses and Changes in Net Position-
Internal Service Funds Statement 33 123
Combining Statement of Cash Flows-Internal Service Funds Statement 34 124
III.STATISTICAL SECTION
Net Position by Component-Last Ten Fiscal Years Table 1 126
Changes in Net Position-Last Ten Fiscal Years Table 2 128
Fund Balances-Governmental Funds-Last Ten Fiscal Years Table 3 132
Changes in Fund Balances-Governmental Funds-Last Ten Fiscal Years Table 4 134
Assessed and Estimated Actual Value of Taxable Property-Last Ten Fiscal Years Table 5 136
CITY OF ANDOVER,MINNESOTA
TABLE OF CONTENTS
Page
Reference No.
Property Tax Rates-Per$1,000 of Assessed Tax Capacity Value-Direct and Overlapping
Governments-Last Ten Fiscal Years Table 6 137
Property Tax Levies and Collections-Last Ten Fiscal Years Table 7 138
Principal Taxpayers-Current Year and Nine Years Ago Table 8 139
Estimated Market Values and New Construction-Last Ten Fiscal Years Table 9 140
Special Assessment Levies and Collections-Last Ten Fiscal Years Table 10 141
Ratio of Net Bonded Debt to Assessed Value and Net Bonded Debt Per Capita-
Last Ten Fiscal Years Table 11 142
Computation of Direct and Overlapping Debt Table 12 143
Computation of Legal Debt Margin-Last Ten Fiscal Years Table 13 144
Pledged-Revenue Coverage-Last Ten Fiscal Years Table 14 147
Outstanding Debt by Type-Last Ten Fiscal Years Table 15 148
Demographic and Economic Statitistics-Last Ten Years Table 16 150
Principal Employers-Current Year and Nine Years Ago Table 17 151
Full Time Equivalent Employees-City Government Employees by Function/Program-
Last Ten Fiscal Years Table 18 153
Operating Indicators by Function/Program-Last Ten Years Table 19 154
Capital Asset Statistics by Function/Program-Last Ten Years Table 20 156
IV.OTHER INFORMATION
Combined Schedule of Indebtedness Exhibit 1 158
Schedule of Tax Capacity Rates and Levies Exhibit 2 160
Schedule of Deferred Tax Levies-General Obligation Bonds Exhibit 3 161
Schedule of Fund Transfers Exhibit 4 162
I. INTRODUCTORY SECTION
1
I `Ir Y 0 F
NDOVE^
1685 CROSSTOWN BOULEVARD N.W. . ANDOVER, MINNESOTA 55304 e (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
June 6,2023
To the Honorable Mayor and City Council
City of Andover
1695 Crosstown Blvd.NW
Andover,Minnesota 55304
Dear Honorable Mayor and Council Members:
The Annual Comprehensive Financial Report is submitted in conformance with all applicable governing laws and regulations. The
following has set the standards forth:
*Andover City Policy and Code
*The State Auditor,State of Minnesota
*Government Finance Officers Association
*Governmental Accounting Standards Board
RESPONSIBILITY. Responsibility for both the accuracy of the presented data and the completeness of the financial statements
including all disclosures rests with the City. We believe the data,as presented,is accurate in all material aspects. This report has
been presented in a manner designed to fairly set forth the financial position and results of operations as measured by the financial
activity of its various funds.
FINANCIAL STATEMENT FORMAT. This Annual Comprehensive Financial Report is presented in three main sections:
1. Introductory
I1. Financial
I1I. Statistical
The Introduction includes a list of the City's principal officials as of December 31,2022,the table of contents,the public officials,
organizational chart, and this Letter of Transmittal. The Financial Section includes: (1) independent auditor's report; (2)
management's discussion and analysis; (3)government wide and fund financial statements; (4)notes to the financial statements;
(5) required supplementary information; (6) the combining statements, individual fund statements; and (7) the supplemental
information. The Statistical Section includes tables and reports of various economic,social,financial,and fiscal data designed to
reflect trends and ratios.
Generally Accepted Accounting Principles (GAAP) requires 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 of Andover's MD&A
can be found immediately following the report of the independent auditors.
REPORTING ENTITY. All City funds, departments, commissions, and other organizations for which the City of Andover is
financially accountable are presented within the Annual Comprehensive Financial Report. The Andover Firefighters' Relief
Association does not meet the established criteria for inclusion in the reporting entity,and accordingly is excluded from this report.
GENERAL INFORMATION. The city we know today as Andover was first organized in 1857 under the name"Round Lake
Township." However,in 1860 the name was changed to"Grow Township"in honor of Senator Galusha A.Grow of Pennsylvania.
Senator Grow spoke at a political campaign in Anoka that year,and the town name was changed to reflect Senator Grow because
of his strong advocacy of the Union cause. At that time,the population was 330 and included the geographical area we know today
as Ham Lake. In fact,the area of Ham Lake was considered a part of Grow Township until 1871.
In 1972,the Grow Township Board of Supervisors recognized that the town was growing at a very rapid rate. They felt a village
form of government would provide better services to the community. Board supervisors then voted in favor of proceeding with
the incorporation process. The board voted to submit a new name for the village. "Andover Village"was chosen because the name
Andover had historical interest. The historical interest,we believe,came from the Andover train station.
2
To the Honorable Mayor and City Council
City of Andover,Minnesota
You may have heard the popular"train myth"about how Andover received its name. The myth states that a train tipped over in a
swamp, and an eyewitness, relaying the incident, said it"went over and over,"thereby naming the city"Andover." However,
research reveals that the name Andover first appeared in an article dated March 14, 1899 in the Anoka County Union Newspaper-
before train tracks were ever built in the city.
The article stated that the Eastern Minnesota line of the Great Northern Railway was in the process of constructing railroad tracks
from the Coon Creek Cut-off to the North. The railway announced that new railroad stations with mathematical precision were to
be located five miles apart from each other. The new stations(from Coon Creek to the North,along the new railroad line)were to
be named Andover,Cedar,Bethel,Isanti,Cambridge,Stanchfield,Braham,Grasston,Cornell,and Brook Park. On July 4, 1899,
the first train passed through the Andover station. Where the railway came up with the name Andover remains unknown.
Andover Village was established in 1972 and then became the City of Andover,a city of the fourth class,in 1974. Today the City
of Andover's population exceeds 20,000,classifying it as a second-class city.
The City of Andover as it exists today consists of 23,040 acres. Andover has a population estimated at 33,000. A growing suburb
of the northern metropolitan area,the City of Andover is approximately sixteen miles from Minneapolis.
SERVICES PROVIDED. The City of Andover provides various services to the residents in the community. The current services
are:
General Government:
Mayor and City council Financial administration Information systems
Newsletter Elections Facility management
City clerk Assessing Engineering
Administration Legal Risk management
Human resources Planning and zoning
Public Safety:
Police Protective inspection Animal control
Fire protection Civil defense
Public Works:
Streets and highways Street signs Traffic signals
Snow and ice removal Central equipment maintenance Water maintenance
Street lighting
Sanitation:
Storm sewers Sanitary sewer maintenance
Parks and Recreation
Recycling
GOVERNMENT STRUCTURE. Andover is a statutory city with the City Council appointing a City Administrator. The City
Administrator has operating responsibilities for all City functions. A list of public officials and organizational chart can be found
on page 9 and 10,respectively.
ECONOMIC CONDITION AND OUTLOOK
Moderate population growth is expected to continue in 2023 and 2024,with an estimated population of 33,850 by 2023.The rate
of residential growth as compared to the growth in the 1990's and 2000's has significantly declined as the availability of
residentially zoned property decreased. The City has experienced a significant amount of commercial growth from 2000 through
current 2022.Continual commercial growth is anticipated over the next couple years;beyond that,growth will slow as the amount
of undeveloped commercially zoned property also declines.
The City's General Fund has two major categories of revenue,which accounted for 85.0%of the total in 2022. They are general
property taxes at 75.2%and charges for services at 9.8%. In prior years,intergovernmental revenue was the second largest category
of revenue for the General Fund. Intergovernmental revenue includes state aids,such as local government aid(EGA),market value
homestead credit(MVHC), highway maintenance aid, fire relief aid and police aid; and county grants, such as recycling and
community development.
3
To the Honorable Mayor and City Council
City of Andover,Minnesota
During the past several years,the State of Minnesota has made numerous changes to laws pertaining to the distribution of LGA,
Homestead and Agricultural Credit Aid(HACA)and MVHC resulting in significant reductions in intergovernmental revenue.
The City has been able to make up this loss in aid through operational efficiencies and an increased tax levy,the most substantial
increase in the local tax rate took place in 2002. The tax laws that resulted in the 2002 change also greatly reduced school district
property tax levies, resulting in no net tax increase for most residential property owners. Sweeping changes approved in 2003
resulted in the loss of approximately$590,000 in aid to Andover,that loss in aid was originally intended to be for two years(2003
&2004)but that loss was extended to include years 2005 and 2006. The state allowed cities the ability to levy up to 60%of the
lost 2003 aid in 2004. Again,in 2008 through 2012,the State of Minnesota significantly reduced MVHC to help deal with the
state budget deficit. In 2013,the State eliminated MVHC and instituted the new market value exclusion program.
In 2014,LGA was reinstated for the City in the amount of$74,655. Due to the unpredictability of the State,those funds were used
to help offset the growing needs of the Road and Bridge Capital Projects Fund for street improvements/replacements. The City is
not intending to rely on this funding for general operational needs. In 2015,LGA was eliminated again for the City. In 2016,the
City received$2,706 in LGA. Since 2016,the City has not received any LGA funding.
For 1998 through 2000, cities with populations over 2,500 were under levy limit restrictions imposed by the State. Levy limits
severely curb the ability of cities to generate additional tax revenue needed to respond to an increasing demand for services. For
1999 and 2000,the levy limit formula was modified to allow for increases based on commercial and industrial growth.This was a
favorable change for Andover,as the City experienced a surge in commercial growth during that period.Levy limits were lifted
for 2001 but were reinstated for 2002-2004. The 2004 levy limits were so severe that the State did not allow cities the ability to
capture residential and commercial market value growth. Levy limits were lifted from 2005 to 2008 but reinstated for 2009 and
are still in place in some form yet today.
The City's General Fund receives a substantial amount of revenue from licenses and permits. The past ten years are shown below:
Revenues Change
2013 $536,706 n/a
2014 364,430 $ (172,276)
2015 452,422 87,992
2016 625,907 173,485
2017 546,378 (79,529)
2018 562,525 16,147
2019 855,831 293,306
2020 892,279 36,448
2021 891,762 (517)
2022 972,879 81,117
In 2014,there was a decrease in both residential and commercial activity. There was a slight increase in construction activity in
2015. In 2016,there was an increase in both residential and commercial construction. In 2017,there was a decrease in single-
family building permits issued going from 1 I I permits in 2016 to 94 in 2017. The decline in single-family building permits
continued in 2018 to a total of 60,but commercial permit valuations exceeded 2017 by over$10,000,000 thus the increase in 2018.
The increase in 2019 is due to single-family building permits reaching 116,nearly double that of 2018. The growth continued in
2020 and 2021 with single-family building permits topping out at 139 and 140, respectively. In 2022, single-family building
permits decreased to 103 but included one multi-family permit valued at$22 million,a 150-unit apartment complex.
The City's General Fund also receives a considerable amount of revenue from charges for services. The past ten years are shown
below:
Revenues Change
2013 $1,122,461 n/a
2014 998,510 $ (123,951)
2015 804,228 (194,282)
2016 912,219 107,991
2017 843,023 (69,196)
2018 888,947 45,924
2019 1,133,161 244,214
2020 1,070,899 (62,262)
2021 1,036,929 (33,970)
2022 1,295,430 258,501
4
To the Honorable Mayor and City Council
City of Andover,Minnesota
The City analyzes user fees every year as part of the budget process and adjusts where appropriate.In 2014,the decrease in both
residential and commercial activity resulted in a decrease as compared to 2013. A reduction in the scope of roadway projects
accounted for a large part of the reduction in 2015 for engineering fees charged as compared to 2014.The increase in 2016 pertains
to plan check fees associated with the increase in construction activity and engineering fees charged to roadway projects. The
slight decline in 2017 relates to the decrease in housing permits issued as compared to 2016.The increase in 2018 pertains to plan
check fees associated with the commercial construction activity taking place.The increase in 2019 is due to single-family building
permits reaching 116,nearly double that of 2018. There was a lot of commercial activity as well with the school district and city
starting expansion projects. Residential growth continued in 2020 and 2021 but the lack of any commercial activity results in a
decrease compared to 2019. The increase in 2022 is largely due to the increase in construction activity and engineering fees charged
to roadway projects.
In 2022,the City issued 103 new single-family building permits and one multi-family building permit with a total valuation of
$56,329,461 compared to 140 new single-family building permits and zero multi-family building permits with a total valuation of
$43,464,138 the prior year. The past ten years are shown below:
New Residential New Commercial/Industrial
Permits Valuation Permits Valuation
2013 98 $21,027,891 15 $ 9,249,466
2014 52 14,816,971 14 4,285,281
2015 74 21,558,010 16 2,513,609
2016 111 28,893,036 7 14,009,200
2017 94 27,847,716 - -
2018 60 19,703,856 2 2,860,000
2019 116 37,258,817 1 3,381,400
2020 139 45,464,139 - -
2021 140 43,464,138 - -
2022 103 34,328,427 1 22,000,990
Residential Development
New residential final plat approvals included 88 urban lots Fields at Winslow Cove I"Addition and Nightingale Villas. A final
plat for Fields at Winslow Cove phase 2 was submitted but not approved in 2022 for 36 urban lots. The City currently has a supply
of 134 urban lots and 13 rural lots(which includes the final plat lots above).
Commercial Industrial Development
New institutional/commercial/industrial businesses moved to Andover in 2022. These businesses included Pine Ridge Animal
Hospital,Merlin Auto Car,Nystrom&Associates,and Golden Ash Salon. The City also issued a building permit for a 150-unit
market rate apartment complex and a 32 unit assisted living and memory care facility.Both are currently under construction with
completion expected in 2023. Taco Bell completed their foundation in 2022 with the new building expected to be completed in
2023. Andover Crossings was constructed in 2022 and provides almost 5 acres of additional commercial land for future
development.
EMPLOYMENT
The City of Andover's largest employers are government entities.The Anoka-Hennepin School District has a significant presence
in the community and Anoka County's Parks and Highway Departments and Sheriff's Office headquarters are in Andover. The
City of Andover is best classified as a bedroom community since most of the residents commute outside of Andover for employment
opportunities. The City does anticipate with the completion of development of the Andover Station Commercial Park that
additional employment opportunities will be provided to residents soon.
Major employers in Andover are as follows:
5
To the Honorable Mayor and City Council
City of Andover,Minnesota
Number of
Firm Type of Business/Product Employees
Anoka-Hennepin ISD No 11 Elementary and secondary education 816
Wal-Mart Retail 335
Fairview-Andover Clinic Healthcare 300
Anoka County Sheriffs Office County government and services 250
Kottkes'Bus Service,Inc. Bus transportation 225
YMCA Youth organization-fitness center 220
Target Retail 200
TE Connectivity Connector and sensor manufacturing 142
GAF Materials Corp Roofing materials-manufacturing 125
Anoka County Highway Department County government and services 120
MAJOR INITIATIVES
FOR THE YEAR. The City has many accomplishments to report for 2022.The following list is a summary of some of the major
initiatives completed throughout the year.
1) New residential Final Plat approvals included 88 urban lots within Field of Winslow Cove I"Addition and Nightingale
Villas. A final plat for Fields at Winslow Cove phase 2 was submitted but not approved in 2022 for 36 urban lots. The
original preliminary plat for Fields at Winslow Cove that was approved will provide 383 urban lots. The City currently
has a supply of 134 urban lots and 13 rural lots(which includes the lots above).
2) In 2022,the City saw commercial,industrial and institutional construction throughout the community totaling close to
$3.1 million in valuation.Many businesses came to Andover that did extensive tenant finishes,upgrades or remodels
in existing multi-tenant buildings, including as follows: LocoFit, Golden Ash Salon, Nystrom & Associates, Milk
Mom's,Ha's Smoky,T-Mobile,Merlin's Auto Care,Crooked Lake Elementary,Andover Elementary,Andover High
School and Seventh Day Adventist Church.
3) In 2022, Andover Crossings was constructed in 2022 providing for multifamily housing and almost 5 acres of
additional commercial land for future development. In this development the City issued a building permit for a 150-
unit market rate apartment complex(Aurora Vista)and a 32-unit assisted living and memory care facility(Westgate
Senior Living).Both are currently under construction with completion expected in 2023. Taco Bell completed their
foundation in 2022 with the new building expected to be completed in 2023.
4) in 2021,Legacy Christian Academy,a K-12 private school,completed their school expansion project. The expansion
includes a three-story classroom addition (approximately 33,000 sq. ft.)between the existing buildings to replace
temporary classrooms.In late 2022,Legacy Christian Academy and the City are again in discussions for an additional
expansion to meet enrollment demands.
5) Andover High School is receiving close to$30 million in additions totaling 67,000 square feet and other improvements
adding another 5,700 square feet of space in the school.Phase 1 of the additions and remodeling started in 2018 and
was completed in 2019. Part of the project is the removal of 12 portable classrooms. The school was originally
designed for 1,400 students,but today 1,700 students attend the school.Phase 2 construction was completed in 2022
bringing the school's capacity to 2,000 students.The high school in 2022 was focusing on grounds updates including
the installation of artificial turf at the stadium and converting temporary storage to permanent storage buildings.
6) Andover residents continue to have one of the highest recycling rates per person for all recyclable materials in Anoka
County. In 2014,the City added a new Recycling Center to expand the current recycling opportunities for Andover
residents. In 2022,the City continued to host monthly recycling events(on weekends),generally with a specific focus,
such as paper shredding and appliance or electronics collection.
7) A strategic planning session was held with the City Council, a final Council Community Vision and Organization
Goals and Values document was approved at the July 7, 2015 City Council meeting. As part of the 2020 Budget
Development process the Council participated in a new strategic planning process updating the Council Community
Vision and Organization Goals and Values document. For the 2023 Budget development process that document was
integrated into various department work plans and budgets.
8) The City's Annual Comprehensive Financial Report(ACFR)for the year ended December 31,2021 was awarded the
Government Finance Officers Association's "Excellence in Financial Reporting Award." The City completes this
document internally and recognized significant cost savings in the form of reduced financial consulting fees. This is
6
To the Honorable Mayor and City Council
City of Andover,Minnesota
the twentieth consecutive year receiving the award and it is anticipated that the City's ACFR for the year ended
December 31,2022 will also achieve this award.
9) For the twenty first year in a row,the City of Andover was awarded the Government Finance Officers Association
Distinguished Budget Presentation Award for the City's 2022 Annual Budget.This award recognizes excellence in the
preparation of the City's budget document as a policy document, an operations guide, as a financial plan and as a
communications device.
10) Ongoing implementation of a single-family rental housing license program to provide property owners/landlords with
educational materials and checklists on how to inspect and maintain the exterior of the property, a list of potential
ordinance violations that may occur with a rental property,and an exterior inspection of the building and grounds with
city staff. This program was authorized by the Andover City Council in 2009 and is reviewed annually,there were
close to 280 single family rental licenses issued throughout the City in 2022.
11) The City continues to make significant progress on the process of digitally imaging documents retained,this includes
standard and legal documents and large construction plan documents. The imaging project has helped the City reduce
staffing through data storage retrieval efficiencies, eliminated the need for office expansion and has expedited City
research projects.
12) The City continues to utilize updates to our financial management software to improve reporting and operating
efficiencies. These updates continue to yield reduced personnel costs and more timely reports. In 2022, the City
continues to see increased growth in the number of online and counter credit card payments for various City permits
and services. Approximately 60% of the Building Department's permits are done online saving our customers
significant time and travel expenses.
FOR THE FUTURE. The City continues to focus on quality-of-life improvements throughout the City. These efforts cover a
broad array of areas including protecting and improving the environment, revitalization of parks and public areas, expanding
recreational opportunities,providing cost-effective city services, increased communication between city representatives and the
public and added commercial/retail opportunities.
The City utilizes many avenues to reach its residents,whether through community access television,electronic reader boards,the
City newsletter,Facebook,Twitter,or the City's webpage(www.andovermn.gov).It is important to the City that our residents are
informed and can participate in the activities of their City. The City did conduct a community survey in 2006,with the help of a
polling firm,to secure opinions and suggestions from the public. The City initiated and completed a community survey in early
2014,the City received very high marks.
RELEVANT FINANCIAL POLICIES
The City has a policy regarding General Fund reserve balances. The City plans for an unassigned fund balance in the General Fund
equivalent to 6-months of the current year's budgeted expenditures to provide working capital between semi-annual property tax
settlements. Since the property tax settlements are received by the City in July and December, the City needs sufficient cash
reserves to avoid short-term borrowing to finance operations. The City also classifies fund balances for prepaid items,inventories,
and other legal obligations. The City may also classify a portion of fund balance for special purposes.
The primary goal of the City's investment policy is to ensure the safety of the principal invested. Cash temporarily idle during the
year is invested in certificates of deposit,commercial paper,and obligations of the U.S.Treasury and government agencies. Cash
balances from all City funds are pooled into an investment fund and investment income is distributed on a pro-rata basis at the end
of each quarter. Extended maturities are utilized to take advantage of higher yields but staggered in a way to meet projected
liquidity needs.
Capital financing for major improvements is provided through improvement bonds,general obligation bonds,tax increment bonds,
or revenue bonds. Depending on the project, special assessments may be levied upon properties to share in the cost of the
improvement project. The special assessments are collected over a period of time and are used to help satisfy the improvement
bond debt or reimburse the fund used to finance the project.
The City Council has also adopted financial management policies to allow for the planning of adequate funding of services desired
by the public, to manage City finances wisely, and to carefully account for public funds. These policies are reviewed each year
when the annual budget is adopted. The financial management policies included: operating budget policies; revenue policies;
accounting, auditing, and financial reporting policies; investment policies; debt policies; capital improvement policies; and risk
management policies.
7
To the Honorable Mayor and City Council
City of Andover,Minnesota
The City Council has adopted a comprehensive set of internal control procedures. The City's accounting system was developed
and is continually evaluated to assure the adequacy of internal accounting controls. Internal accounting controls are designed to
provide reasonable but not absolute assurance in the areas of safeguarding assets against loss from unauthorized use or disposition,
reliability of financial records, and convenience of access for preparing financial statements and maintaining accountability for
assets. The concept of reasonable assurance adopted by the City Council recognizes that the evaluation of cost and benefits requires
estimates and judgments by management,and the cost of a control should not exceed the benefits likely to be derived. All internal
controls are evaluated against the above criteria. It is our belief that the City's internal accounting controls adequately safeguard
the City's assets and provide reasonable assurance of properly recording financial transactions.
OTHER INFORMATION
AWARDS. The Government Finance Officers Association(GFOA)of the United States and Canada presented a Distinguished
Budget Presentation Award to the City of Andover for its annual budget for the fiscal year beginning January 1,2022. This is the
twenty first year in a row the City of Andover has received this award. To receive this award,a governmental unit must publish a
budget document that meets program criteria as a policy document, as an operations guide, as a financial plan and as a
communications device. This award is valid for a period of one year only. We believe that the annual budget for the fiscal year
beginning January 1,2023 continues to conform to the program requirements and have submitted it to the GFOA to determine its
eligibility for another award.
The GFOA also presented the Certificate of Achievement for Excellence in Financial Reporting Award to the City of Andover for
its 2021 Annual Comprehensive Financial Report. This is the twentieth time the City of Andover has received this award. To
receive this award, a government 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. This award is valid for a period of one year only. We believe this report for 2022 continues to
conform to the Certificate of Achievement Program requirements and have submitted it to the GFOA to determine its eligibility
for another award.
INDEPENDENT AUDIT. State statutes require an annual audit by independent certified public accountants. Redpath and
Company,Ltd.was engaged by the City to render an opinion on the City's financial statements. The auditor's report on the basic
financial statements and combining and individual fund statements and schedules is included in the financial section of this report.
ACKNOWLEDGMENTS. The preparation of this report could not have been accomplished without the efficient set-vices and
dedication of the Finance Department staff and the consultation of the City's auditing firm. Staff members:Lee Brezinka,Melissa
Knutson and Brenda Fildes have my sincere appreciation for their contribution to the preparation of this report.
I also want to express our appreciation to the Mayor and members of the City Council for their interest and support in planning and
conducting the financial operations of the City in a fiscally responsible manner.
Respectfully submitted,
James Dickinson
City Administrator
8
CITY OF ANDOVER,MINNESOTA
ORGANIZATION
December 31,2022
Office Name Term
Mayor Sheri Bukkila January 3,2023
Council Member Jamie Barthel January 3,2023
Council Member Ted Butler January 7,2025
Council Member Valerie Holthus January 3,2023
Council Member Randy Nelson January 7,2025
City Administrator/City Clerk Janes Dickinson Appointed
Community Development Director Joe Janish Appointed
Director of Public Works/City Engineer David Berkowitz Appointed
Finance Manager Lee Brezinka Appointed
Building Official Joe Heidelberger Appointed
Fire Chief Dennis Jones Appointed
Attorney Berglund,Baumgartner,Kimball&Glaser,LLC Appointed
Fiscal Consultants Ehlers&Associates,Inc. Appointed
9
CITY OF ANDOVER
Organizational Chart
City Council
--------------------------
Ciry Attorney Ciry Adminisnmtor Advisory Boards
Administrative Building Inspections Engineering Finance Fire Protection Planning Public Works Police Protection
Services
Administration Civil Defense Engineering Financial Fire Protection Planning&Zoning Streets/Highways
Services Administration Services
Hrunan Resources' Protective Right of-Way Assessing Snow&Ice
Inspections Management Removal
Newsletter Drainage& Facilities Storm Sewer
Mapping Management
Economic Lower Rum River Unallocated Sheet Lighting
Development Watershed Mgmt
Authority Organization
Commurnty Forestry Capital Equipment Signage
Center Reserve
Elections Trail& Debt Service Funds Tratfc Signals
Transportation
Animal Control Construction Uniinanced Projects Parks&Recreation
Seal Coating
Information Water Trunk Tax Increment Recycling
Sys ems Projects
Ciry Cleric Storm Sewer Building Fund Water
Sewer T unk Permanent Sewer
Improvement
Revolving
Road&B dge G.O.Capital Central Equipment
Notes
Park Dedicat on Risk
Projects Management
10
0
Government Finance Officers Association
Certificate of
Achievement
for Excellence
in Financial
Reporting
Presented to
City of Andover
Minnesota
For its Annual Comprehensive
Financial Report
For the Fiscal Year Ended
December 31, 2021
P.
Executive Director/C'EO
11
-This page intentionally left blank-
12
II. FINANCIAL SECTION
13
A IN I Y C CD M P A N V
INDEPENDENT AUDITOR'S REPORT
To the Honorable Mayor and
Members of the City Council
City of Andover,Minnesota
Report on the Audit of the Financial Statements
Opinions
We have audited the accompanying financial statements of the governmental activities,the business-type
activities,each major fund,and the aggregate remaining fund information of the City of Andover,Minnesota,as
of and for the year ended December 31,2022,and the related notes to the financial statements,which
collectively comprise the City of Andover,Minnesota'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, each major fund,and the aggregate
remaining fund information of the City of Andover,Minnesota,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 of Andover,Minnesota and 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.
Report on Summarized Comparative Information
We have previously audited the City of Andover,Minnesota's 2021 financial statements, and we expressed
unmodified audit opinions on the respective financial statements of the governmental activities,the business-
type activities,each major fund,and the aggregate remaining fund information in our report dated May 11,
2022. In our opinion,the summarized comparative information presented herein as of and for the year ended
December 31,2021 is consistent,in all material respects,with the audited financial statements from which it has
been derived,except as discussed in Note 18.
Responsibilities of Management for the Financial Statements
Management is responsible for the preparation and fair presentation of the financial statements in accordance
with accounting principles generally accepted in the United States of America,and for 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.
55 5t"Street East,Suite 1400,St. Paul, MN, 55101 www.redpathcpas.com
14
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 of Andover,Minnesota'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.
In performing an audit in accordance with generally accepted auditing standards and Governmental 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 of Andover,Minnesota'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 of Andover,Minnesota'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 18 to the financial statements,the City of Andover,Minnesota adopted new accounting
guidance for the year ended December 31,2022,Governmental Accounting Standards Board Statement No. 87,
Leases. Our opinions are not modified with respect to this matter.
15
Required Supplementary Information
Accounting principles generally accepted in the United States of America require that the management's
discussion and analysis,the budgetary comparison schedules,and the schedules of OPEB and pension
information,as listed in the table of contents,be presented to supplement the basic financial statements. Such
information is the responsibility of management and,although not a part of the basic financial statements,is
required by the Governmental Accounting Standards Board who considers it to be an essential part of financial
reporting for placing the basic financial statements in an appropriate operational,economic,or historical
context. We have applied certain limited procedures to the required supplementary information in accordance
with auditing standards generally accepted in the United States of America,which consisted of inquiries of
management about 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 of Andover,Minnesota's basic financial statements. The accompanying combining and
individual fund 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,the combining and individual fund
statements and schedules are fairly stated,in all material respects,in relation to the basic financial statements as
a whole.
Other Information
Management is responsible for the other information included in the annual report. The other information
comprises the introductory, statistical and other information 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.
16
Other Reporting Required by Government Auditing Standards
In accordance with Government Auditing Standards,we have also issued our report dated May 25,2023 on our
consideration of the City of Andover,Minnesota'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 of Andover, Minnesota'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
of Andover, Minnesota's internal control over financial reporting and compliance.
REDPATH AND COMPANY,LTD.
St.Paul,Minnesota
May 25,2023
17
CITY OF ANDOVER,MINNESOTA
MANAGEMENT'S DISCUSSION AND ANALYSIS
December 31,2022
As management of the City of Andover,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 on pages 2 through 8 of this
report.
Financial Hi2hliehts
The assets and deferred outflows of resources of the City exceeded its liabilities and deferred inflows of resources at the close of the most
recent fiscal year by$218,949,257(net position). Of this amount,$55,865,126(unrestricted net position)maybe used to meet the government's
ongoing obligations to citizens and creditors in accordance with the City's fund designations and fiscal policies.
The City's total net position increased by $5,410,379 from current year activity, primarily due to the budget savings, an increase in
commercial/residential construction fees and capital contributions from construction activity.
As of the close of the current fiscal year,the City's governmental funds reported combined ending fund balances of$54,263,587.
Special Debt Capital
General Revenue Service Projects Totals
Nonspendable $ 170,128 $ 10,000 $ - $ - $ 180,128
Restricted - 237,411 3,491,233 4,780,108 8,508,752
Committed - 584,224 - - 584,224
Assigned - 1,141,796 - 34,054,474 35,196,270
Unassigned 9,794,213 - - - 9,794,213
$ 9,964,341 $ 1,973,431 $ 3,491,233 $38,834,582 $54,263,587
The City's total long-term liabilities increased by$25,960 during the current fiscal year,primarily due to the increase in net pension liability
offset by the decrease bonds payable.
Beginning Ending
Balance Additions Reductions Balance
Governmental activities:
Bonds payable $46,091,735 $ - $ (2,181,156) $43,910,579
Other post employment benefits 391,331 28,877 - 420,208
Compensated absences 827,066 478,482 (411,414) 894,134
Net pension liability 2,372,519 2,780,936 (99,930) 5,053,525
Total governmental activities 49,682,651 3,288,295 (2,692,500) 50,278,446
Business-type activities:
Bonds payable 1,624,426 - (769,426) 855,000
Other post employment benefits 63,705 4,701 - 68,406
Compensated absences 240,762 4,254 (61,986) 183,030
Net pension liability 319,067 290,083 (37,461) 571,689
Total business-type activities 2,247,960 299,038 (868,873) 1,678,125
Total City long-term liabilities $51,930,611 $ 3,587,333 $ (3,561,373) $51,956,571
Overview of the 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 comprise 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.
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 similar to a private-sector business.
18
CITY OF ANDOVER,MINNESOTA
MANAGEMENT'S DISCUSSION AND ANALYSIS
December 31,2022
The statement of net position presents information on all of the City's assets and liabilities,with the difference between the two 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 (e.g.
uncollected taxes and earned but unused vacation leave).
Both of the government-wide financial statements distinguish functions of the City that are principally supported by taxes and
intergovernmental revenues(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 of the City include general government,public safety,
public works, sanitation,parks and recreation,recycling and economic development. The business-type activities of the City include water,
sewer and storm sewer.
The government-wide financial statements can be found on Statements 1 and 2 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. All of the funds of the City 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-terin inflows and outflows of spendable resources,as well as on balances of spendable resources available at the end of the fiscal
year. Such information may be useful in evaluating a government's near-term financial 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
statement. By doing so,readers may better understand the long-term impact of the City's near-term financial decisions.Both the governmental
fund balance sheet and governmental fund statement of revenues,expenditures and change in fund balances provide a reconciliation to facilitate
this comparison between governmental funds and governmental activities.
The City maintains eight individual major governmental funds. Information is presented separately in the governmental fund balance sheet
and in the governmental fund statement of revenues,expenditures and changes in fund balances for the following major funds: General Fund,
Community Center Special Revenue Fund, CARES Grant/ARPA Funding Special Revenue Fund and the following capital projects funds
(CPF): Water Trunk,Sewer Trunk,Road and Bridge,Tax Increment Projects and 2021A G.O. Street Reconstruction Bonds.
Data from the other governmental funds are combined into a single,aggregated presentation. Individual fund data for each of these non-maj or
governmental funds is provided in the form of combining statements elsewhere in this report.
The City adopts an annual appropriated budget for its general and special revenue funds.
A budgetary comparison statement has been provided for those funds to demonstrate compliance with this budget.
The basic governmental fund financial statements can be found on Statements 3 through 5 of this report.
Proprietary funds. When the City charges customers for the services it provided—whether to outside customers or to other departments of
the City—these services are generally reported in proprietary funds. Proprietary funds are reported in the same way that all activities are
reported in the statement of net position and the statement of revenues,expenses and changes in net position.
The enterprise funds are the same as the business-type activities reported in the government-wide statements but provide more detail and
additional information, such as cash flows,for proprietary funds. The City uses enterprise funds to account for its water, sanitary sewer and
storm sewer operations.
Internal service funds are used to report activities that provide supplies and services for the City's other departments, such as the equipment
maintenance and insurance funds. The internal service funds are reported with governmental activities in the government-wide financial
statements.
The basic proprietary fund financial statements can be found on Statements 6 through 8 of this report.
19
CITY OF ANDOVER,MINNESOTA
MANAGEMENT'S DISCUSSION AND ANALYSIS
December 31,2022
Notes to the financial statements. The notes provide additional information that is essential to a full understanding of the data provided in
the government—wide and fund financial statements. The notes to the financial statements directly follow the Basic Financial Statements.
Other information. The combining statements referred to earlier in connection with non-major governmental funds is presented immediately
following the required supplementary information on budgetary comparisons, the modified approach for streets and trails infrastructure and
pension information. Combining and individual fund statements and schedules can be found on Statements 17 through 34 of this report.
Government-wide Financial Analysis
As noted earlier,the assets and deferred outflows of resources of the City exceeded its liabilities and deferred inflows of resources at the close
of the most recent fiscal year by$218,949,257(net position).
The largest portion of the City's net position ($157,995,298 or 72 percent) reflects its investment in capital assets (e.g. land, buildings,
machinery, and equipment)less any related debt used to acquire those assets that is still outstanding. It does not include any refunding debt
that has not met the refunding date of the original issue.The City uses these capital assets to provide services to citizens;consequently,these
assets are not available for future spending. Although the City's investment in its capital assets is reported net of related debt,it should be noted
that the resources needed to repay this debt must be provided fi-om other sources,since the capital assets themselves cannot be used to liquidate
these liabilities.
CITY OF ANDOVER'S NET POSITION
Governmental Activities Business-Type Activities Totals
2021 2022 2021 2022 2021 2022
Current and other assets $ 65,416,993 $ 68,180,694 $ 12,684,537 $ 13,061,669 $ 78,101,530 $ 81,242,363
Capital assets 153,798,777 153,997,415 45,141,428 44,953,814 198,940,205 198,951,229
Total assets 219,215,770 222,178,109 57,825,965 58,015,483 277,041,735 280,193,592
Deferred outflows of resources 1,949,886 1,888,879 229,221 193,089 2,179,107 2,081,968
Long-term liabilities
outstanding 49,682,651 50,278,446 2,247,960 1,278,125 51,930,611 51,556,571
Other liabilities 3,955,538 5,053,282 535,110 507,158 4,490,648 5,560,440
Total liabilities 53,638,189 55,331,728 2,783,070 1,785,283 56,421,259 57,117,011
Deferred inflows of resources 8,968,713 6,171,018 291,992 38,274 9,260,705 6,209,292
Net position:
Net investment in capital
assets 115,576,274 113,896,484 43,517,002 44,098,814 159,093,276 157,995,298
Restricted 4,465,945 5,088,833 - - 4,465,945 5,088,833
Unrestricted 38,516,535 43,578,925 11,463,122 12,286,201 49,979,657 55,865,126
Total net position $ 158,558,754 $162,564,242 $54,980,124 $56,385,015 $213,538,878 $218,949,257
A portion of the City's net position represents resources that are subject to external restrictions on how they may be used. The remaining
balance of unrestricted net position($55,865,126)may be used to meet the City's ongoing obligations to citizens and creditors.
At the end of the current fiscal year, the City is able to report positive balances in all three categories of net position,both for the City as a
whole,as well as for its separate governmental and business-type activities.
Effective January 1,2022,the City implemented GASB Statement No. 87, Leases. The standard required retroactive implementation for all
periods presented in the financial statements. As such, 2021 comparative amounts in the management's discussion and analysis have been
restated.
20
CITY OF ANDOVER,MINNESOTA
MANAGEMENT'S DISCUSSION AND ANALYSIS
December 31,2022
Government-wide Activities
Governmental activities increased the City's net position by$4,005,488 and business-type activities increased net position by$1,404,891. Key
elements of the activities are as follows:
City of Andover's Changes in Net Position
Governmental Activities Business-Type Activities Total
2021 2022 2021 2022 2021 2022
Revenues:
Program revenues:
Charges for services $ 5,970,816 $ 5,993,843 $ 6,836,735 $ 6,844,161 $ 12,807,551 $ 12,838,004
Operating grants
and contributions 1,242,650 3,214,092 - 3,600 1,242,650 3,217,692
Capital grants
and contributions 2,112,499 5,156,356 2,508,801 1,266,143 4,621,300 6,422,499
General revenues:
Property taxes 14,934,589 16,036,590 - - 14,934,589 16,036,590
Tax increment 103,474 93,862 - - 103,474 93,862
Grants and contributions
not restricted to
specific programs 3,578 4,417 - - 3,578 4,417
Unrestricted investments
earnings (71,710) (1,165,410) (17,603) (260,113) (89,313) (1,425,523)
Gain on sale of capital
assets 18,800 50,113 - - 18,800 50,113
Total revenues 24,314,696 29,383,863 9,327,933 7,853,791 33,642,629 37,237,654
Expenses:
General government 3,202,342 3,832,215 - - 3,202,342 3,832,215
Public safety 5,814,286 6,245,503 - - 5,814,286 6,245,503
Public works 4,726,280 8,393,927 - - 4,726,280 8,393,927
Parks and recreation 4,676,676 5,312,290 - - 4,676,676 5,312,290
Recycling 245,755 180,188 - - 245,755 180,188
Economic development 293,594 677,828 - - 293,594 677,828
Interest on long-term debt 1,184,349 1,191,104 - - 1,184,349 1,191,104
Water - - 2,546,637 2,743,148 2,546,637 2,743,148
Sewer - - 2,435,302 2,581,604 2,435,302 2,581,604
Storm sewer - - 611,579 669,468 611,579 669,468
Total expenses 20,143,282 25,833,055 5,593,519 5,994,220 25,736,800 31,827,275
Increase(decrease)in net position
before transfers 4,171,414 3,550,808 3,734,415 1,859,571 7,905,829 5,410,379
Transfers 119,523 454,680 (119,523) (454,680) - -
Change in net position 4,290,937 4,005,488 3,614,892 1,404,891 7,905,829 5,410,379
Net position-beginning 154,267,817 158,558,754 51,365,232 54,980,124 205,633,049 213,538,878
Net position-ending $158,558,754 $ 162,564,242 $ 54,980,124 $ 56,385,015 $213,538,878 $218,949,257
21
CITY OF ANDOVER,MINNESOTA
MANAGEMENT'S DISCUSSION AND ANALYSIS
December 31,2022
Governmental Activities
Following are specific graphs that provide comparisons of the governmental activities revenues and expenses:
Governmental Activities-Revenues
Unrestricted
investments earnings
-4.0% Charges for services
20.4%
Tax increment Grants and
contributions not
0.3% restricted to specific
programs
0.0%
Gain on sale of capital
assets
0.2%
Property taxes
54.7%
Capital grants and
contributions
17.5%
Operating grants and
contributions
10.9%
Governmental Activities-Expenses
Interest on long-term
debt
4.6% General government
Economic 14.8%
development
2.6%
Recycling
0.7%
Parks and recreation
20.6%
Public safety
24.2%
Public works
32.5%
22
CITY OF ANDOVER,MINNESOTA
MANAGEMENT'S DISCUSSION AND ANALYSIS
December 31,2022
Business-Type Activities
Following are graphs showing the business-type activities revenue and expense comparisons:
Business-Type Activities-Revenues
Operating
Capital grants grants and
and contribution
contributions 0.05%
16.12
Unrestricted
investments
earnings
Charges for
scil iccs
87.14%
Business-Type Activities-Expenses
Storm sewer
11.17%
Watcr
45.76%
r
Sewer
43.07%
23
CITY OF ANDOVER,MINNESOTA
MANAGEMENT'S DISCUSSION AND ANALYSIS
December 31,2022
Financial Analysis of the Government'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. In particular,unrestricted fund balance may
serve as a useful measure of a government's net resources available for spending at the end of the fiscal year.
At the end of the current fiscal year,the City's governmental funds reported combined ending fund balances of$54,263,587. Approximately
18.1 percent of this total amount($9,794,213) constitutes unassigned fund balance. The remainder of the fund balance($44,469,374)is not
available for new spending because it is either 1)nonspendable($180,128),2)restricted($8,508,752),3)committed($584,224)or 4)assigned
($35,196,270).
Major Funds
The general fund increased by$337,875 in 2022,which was a$1,359,323 change from the final budget and$365,927 greater than last years
decrease in fund balance. The final budget showed a decrease in fund balance of$1,021,448. The change in fund balance is due to various
departments under-spending and revenues exceeding budgets related to residential and commercial construction activity. The City Council
also approved a five percent increase in the general fund levy for 2022. The major change compared to the adopted budget is largely due to
the one-time transfer of$400,000 to the trail and transportation CPF in 2022.
The community center SRF increased by$215,632 primarily due to court and ice rental exceeding expectations and savings in operational
expenditures.
The cares grant/arpa funding SRF balance increased by$15,005 as the City allocates the use of federal funds.
The water and sewer trunk CPF's fluctuate based on development activity and whether there is any cost sharing for pipe over-sizing, extra
depth, etc. The addition of the following developments has increase connection fees and special assessments: Fields of Winslow Cove,
Nightingale Villas,Shadowbrook North,Meadows at Petersen Farms,and the 150-unit apartment complex. The water trunk fund($300,000)
and sewer trunk fund($400,000)continue to receive funds from the water and sewer enterprise funds to be set aside for future infrastructure
replacements.
The road and bridge CPF increased by$1,826,588 as the majority of street reconstruction expenditures are recorded in the 2021A G.O. street
reconstruction bonds while still receiving special assessment revenues and a 5 percent increase in tax levy.
The tax increment CPF decreased by$435,935 primarily due to the purchase of the rental properties for future redevelopment.
The 2021 A G.O.street reconstruction bonds CPF decreased by$3,436,982 as bond proceeds are spent towards street reconstruction projects.
Nonmajor Funds
The 2018A G.O. capital improvements plan bonds DSF increased by$177,408 due to the timing of when tax revenue is collected and when
debt service payments are made.
The 2021A C.O. street reconstruction bonds DSF increased by $912,487 due to the timing of when tax revenue is collected and when debt
service payments are made.
The park dedication CPF increased by$947,857 as park dedication fees are collected when developments are started. The 150-unit apartment
complex accounted for over 50%of the park dedication fees collected in 2022.
The trail and transportation CPF increased by$777,243 as trail fees are collected when developments are started. 2022 included in increase in
hail fees collected due to the 150-unit apartment complex and a one-time transfer from the general fund for additional trail segments within
the City.
The capital equipment reserve CPF decreased by$198,747 primarily due to equipment purchases and the cost-sharing of a county dog park.
The 2021A G.O.equipment certificates CPF decreased by$592,206 due to the purchase of equipment in 2022.
The permanent improvement revolving CPF decreased by$421,549 due to the transfer of$400,000 to the 2021A G.O street reconstruction
bonds DSF for future debt service payments.
Proprietary funds. The City's proprietary funds provide the same type of information found in the government-wide financial statements,
but in more detail.
24
CITY OF ANDOVER,MINNESOTA
MANAGEMENT'S DISCUSSION AND ANALYSIS
December 31,2022
The unrestricted net position in the respective proprietary funds are enterprise funds of$12,217,398(water$6,676,318,sewer$4,119,534 and
storm sewer$1,421,546)and internal service funds of$770,306. The enterprise funds had a net increase in net position from current year
activity of$1,433,870(water$1,150,051,sewer($108,453)and storm sewer$392,272). Internal service funds had a net decrease in net position
of$193,198. Net position changes in the enterprise funds are due to: water - increased water sales because of the drought and capital
contributions from developers;sewer&storm—capital contributions offsetting operational shortages and transfers out.
Capital Asset and Debt Administration
Capital assets. The City's investment in capital assets for its governmental and business-type activities as of December 31,2022,amounts to
$198,951,229 (net of accumulated depreciation). This investment in capital assets includes land, buildings, infrastructure, machinery and
equipment.
The City has elected to use the modified approach as defined in GASB Statement No. 34 for infrastructure reporting for its Pavement
Management Program,which includes streets and trails. Under GASB Statement No.34,eligible infrastructure capital assets are not required
to be depreciated under the following requirements:
1) The City manages the eligible infrastructure capital assets using an asset management system with characteristics of(a)an up-to-date
inventory;(b)perform condition assessments and summarize the results using a measurement scale;and(c)estimate annual amount
to maintain and preserve at the established condition assessment level.
2) The City documents that the eligible infrastructure capital assets are being preserved approximately at or above the established and
disclosed condition assessment level.
The continuous scale was from 0 to 10, where 0 is assigned to the least acceptable physical condition and 10 is assigned the physical
characteristics of a new street or trail. The City's policy is to achieve an average rating of good which is 6—6.9 (56—70 old scale)for all
streets and trails. In the fall of 2022,the City conducted a physical condition assessment of the streets and trails constructed since 1974. This
assessment will be completed every three years. As of December 31,2022,the City's street and trail system was rated at an Overall Condition
Index(OCI)of 6.0.
The City's streets and trails are constantly deteriorating resulting from the following factors: (1)traffic using the system; (2)the sun's ultra-
violet rays drying out and breaking down the top layer of pavement; (3)utility company/private development trenching operations;(4)water
damage from natural precipitation;and(5)frost heave. The City is continuously taking actions to prolong the life of the system through short-
term maintenance activities such as pothole patching,crack sealing,seal coating and overlaying. The City expended$4,159,982 on street and
hail maintenance for the year ending December 31,2022. These expenditures delayed deterioration and the overall condition of the system
remains at an appropriate OCT level through these maintenance expenditures. The City has estimated that the amount of annual expenditures
required to maintain the City's street and trail system at the average OCT rating of good is approximately$2,750,000.
Maintenance Actual OCT
Year Estimate Expenditures Rating
2013 $1,150,000 $ 2,471,123 6.9
2014 1,150,000 2,029,026 6.7
2015 1,150,000 1,114,900 6.7
2016 1,150,000 1,585,756 6.3
2017 1,150,000 3,548,327 6.4
2018 1,150,000 2,274,146 6.4
2019 1,150,000 3,701,063 5.3
2020 1,150,000 2,667,008 5.4
2021 2,500,000 2,160,714 5.9
2022 2,750,000 4,159,982 6.0
25
CITY OF ANDOVER,MINNESOTA
MANAGEMENT'S DISCUSSION AND ANALYSIS
December 31,2022
Primary Government
Beginning Ending
Balance Additions Deletions Balance
Governmental activities:
Land and improvements $ 11,321,133 $ - $ (115,793) $ 11,205,340
Streets and trails 91,057,516 1,105,671 - 92,163,187
Construction in progress 15,000 40,807 (15,000) 40,807
Buildings and improvements 62,021,145 361,542 (46,164) 62,336,523
Furniture and equipment 1,262,725 462,892 - 1,725,617
Machinery and equipment 10,232,367 818,287 (221,925) 10,828,729
Other park improvements 8,663,018 586,950 (46,966) 9,203,002
Total capital assets 184,572,904 3,376,149 (445,848) 187,503,205
Less accumulated depreciation for:
Buildings and improvements 17,862,028 2,075,985 (46,164) 19,891,849
Furniture and equipment 738,055 128,106 - 866,161
Machinery and equipment 7,043,034 507,045 (221,925) 7,328,154
Other park improvements 5,131,010 335,582 (46,966) 5,419,626
Total accumulated depreciation 30,774,127 3,046,718 (315,055) 33,505,790
Governmental activities
capital assets-net 153.798,777 329,431 (130,793) 153,997,415
Business-type activities:
Land and improvements 730,243 - - 730,243
Construction in progress 1,709,054 35,063 (1,709,054) 35,063
Buildings and improvements 15,877,590 - - 15,877,590
Furniture and equipment 27,936 1,191,958 - 11219,894
Machinery and equipment 1,579,415 83,186 (4,483) 1,658,118
Collection and distribution 65,982,488 2,099,782 - 69,082,270
Total capital assets
being depreciated 85,906,726 3,409,989 (1,713,537) 87,603,178
Less accumulated depreciation for:
Buildings and improvements ll,184,351 404,557 - 11,588,908
Furniture and equipment 23,662 40,182 - 63,844
Machinery and equipment 1,051,967 95,670 (4,483) 1,143,154
Collection and distribution 28,505,318 1,348,140 - 29,853,458
Total accumulated depreciation 40,765,298 1,888,549 (4,483) 42,649,364
Business-type activities
capital assets-net 45,141,428 1,521,440 (1,709,054) 44,953,814
Total capital assets-net $ 198,940,205 $ 1,850,871 $ (1,839,847) $ 198,951,229
Additional information on the City's capital assets can be found in Note 6.
Long-term debt. At the end of the current fiscal year,the City had total long-term debt outstanding of$45,842,743,an decrease of$2,941,246
from 2021. General obligation abatement bonds ($24,595,000)were used to refund the 2006 and 2007 EDA lease revenue refunding bonds
and expand the existing community center. General obligation revenue bonds($855,000)were used for an addition to the water treatment plant
and the refunding of portions of the water treatment plant bonds. Certificates of indebtedness ($1,305,000) financed capital equipment
purchases. Capital improvement bonds ($9,660,000)were used to construct a new vehicle maintenance facility with a washbay and a cold
storage building. Street reconstruction bonds($7,135,000)were used to reconstruct roadways in the City.
Additional long-term debt in the amount of$1,215,579 for issuance premiums and$1,077,164 is for compensated absences.
26
CITY OF ANDOVER,MINNESOTA
MANAGEMENT'S DISCUSSION AND ANALYSIS
December 31,2022
City of Andover's Outstanding Debt
Governmental Business-Type
Activities Activities Total
Bonds payable:
Abatement bonds $ 24,595,000 S - S 24,595,000
G.O.revenue bonds - 855,000 855,000
Certificates of indebtedness 1,305,000 - 1,305,000
Capital improvement bonds 9,660,000 - 9,660,000
Street reconstruction bonds 7,135,000 - 7,135,000
Total bonds payable 42,695,000 855,000 43,550,000
Issuance premiums 1,215,579 - 1,215,579
Compensated absences 894,134 183,030 1,077,164
Total $ 44,804,713 $ 1,038,030 $ 45,842,743
The City maintains an AA+rating with a stable outlook from Standard and Poor's.
State statutes limit the amount of general obligation debt a Minnesota city may issue to 3% of total Estimated Taxable Market Value. The
current debt limitation for the City is$114,826,589. Only$39,259,233 of the City's outstanding debt is counted within the statutory limitation.
Additional information on the City's long-term debt can be found in Notes 7 and 8.
Requests for information. This financial report is designed to provide a general overview of the City of Andover's finances for all those with
an interest in the government's finances. Questions concerning any of the information provided in this report or requests for additional financial
information should be addressed to the City of Andover,Attn:Finance Manager,1685 Crosstown Boulevard NW,Andover,Minnesota 55304
or by calling 763-755-5100.
27
-This page intentionally left blank-
28
BASIC FINANCIAL STATEMENTS
29
-This page intentionally left blank-
30
CITY OF ANDOVER,MINNESOTA
STATEMENT OF NET POSITION Statement 1
December 31,2022
With Comparative Totals For December 31,2021
Primary Government
Government Business-Type Totals
Activities Activities 2022 2021
Assets:
Cash and investments $ 57,923,802 $ 11,136,922 $ 69,060,724 $ 66,487,171
Accrued interest 343,956 40,728 384,684 256,169
Due from other governmental units 230,524 8,458 238,982 32,025
Accounts receivable-net 284,008 1,584,713 1,868,721 1,667,960
Prepaid items 261,840 - 261,840 270,498
Property taxes receivable:
Unremitted 204,960 204,960 177,788
Delinquent 131,857 - 131,857 156,518
Special assessments receivable:
Unremitted 3,295 3,185 6,480 9,748
Delinquent 19,128 259,733 278,861 248,237
Deferred 1,669,301 467 1,669,768 1,411,869
Lease receivable 5,994,827 - 5,994,827 6,375,682
Inventories-at cost 273,196 27,463 300,659 242,865
Land held for resale 940,000 - 840,000 765,000
Capital assets-net:
Nondepreciable 103,409,334 765,306 104,174,640 104,832,946
Depreciable 50,588,081 44,188,508 94,776,589 94,107,259
Total assets 222,178,109 58,015,483 280,193,592 277,041,735
Deferred outflows of resources:
Related to other post employment benefits 18,822 2,924 21,746 10,892
Related to pensions 1,870,057 190,165 2,060,222 2,168,215
Total deferred outflows ofresources 1,888,879 193,089 2,081,968 2,179,107
Liabilities:
Interfund payable 68,803 (68,803) - -
Accounts payable 336,947 95,803 432,750 440,733
Contracts payable 161,612 6,921 168,533 573,650
Deposits payable 783,722 2,234 785,956 684,460
Due to other governmental units 1,102,144 32,300 1,134,444 80,918
Salaries payable 245,436 30,081 275,517 263,789
Unearned revenue 1,861,827 - 1,861,827 1,909,704
Accrued interest payable 492,791 8,622 501,413 537,394
Other post employment benefits:
Due in more than one year 420,208 68,406 488,614 455,036
Compensated absences:
Due within one year 134,120 27,455 161,575 160,174
Due in more than one year 760,014 155,575 915,589 907,654
Bonds/notes payable(net of unamortized premiums):
Due within one year 3,125,000 770,000 3,895,000 2,865,000
Due in more than one year 40,785,579 85,000 40,870,579 44,851,161
Net pension liability:
Due in more than one year 5,053,525 571,689 5,625,214 2,691,586
Total liabilities 55,331,728 1,785,283 57,117,011 56,421,259
Deferred inflows of resources:
Related to leases 5,994,827 - 51994,827 6,375,682
Related to pensions 176,191 38,274 214,465 2,885,023
Total deferred inflows of resources 6,171,018 38,274 6,209,292 9,260,705
Net position:
Net investment in capital assets 113,896,484 44,098,814 157,995,298 159,093,276
Restricted for:
Debt service 3,024,557 - 3,024,557 2,064,237
Tax increment purposes 1,810,878 1,810,878 2,172,641
Public services 253,398 - 253,398 229,067
Unrestricted 43,579,925 12,286,201 55,865,126 49,979,657
Total net position $ 162,564,242 $ 56,385,015 $ 218,949,257 S 213,538,878
The accompanying notes arc an integral part of these financial statements.
31
CITY OF ANDOVER,MINNESOTA
STATEMENT OF ACTIVITIES
For The Year Ended December 31,2022
With Comparative Actual Amounts For The Year Ended December 31,2021
Program Revenues
Charges Operating Capital
For Grants and Grants and
Expenses Services Contributions Contributions
Functions/Programs
Primary government:
Government activities:
General government $ 3,832,215 $ 2,114,479 $ 144,190 $ -
Public safety 6,245,503 1,251,620 637,366 200,000
Public works 8,393,927 324,440 2,314,777 3,495,752
Parks and recreation 5,312,290 2,073,350 - 1,460,604
Recycling 180,188 50,925 117,759 -
Economic development 677,829 179,029 - -
Interest on long-term debt 1,191,104 - - -
Total government activities 25,833,055 5,993,843 3,214,092 5,156,356
Business-type activities:
Water 2,743,148 3,683,763 3,600 383,327
Sewer 2,581,604 2,497,153 - 414,380
Storm sewer 669,468 663,245 - 468,436
Total business-type activities 5,994,220 6,844,161 3,600 1,266,143
Total primary government $ 31,827,275 $ 12,838,004 $ 3,217,692 $ 6,422,499
The accompanying notes are an integral part of these financial statements.
32
Statement 2
Net(Expense)Revenue and Changes in Net Position
Primary Government
Governmental Business-Type Totals
Activities Activities 2022 2021
$ (1,573,546) $ - $ (1,573,546) $ (796,373)
(4,156,517) - (4,156,517) (4,180,471)
(2,258,958) - (2,258,958) (2,563,500)
(1,778,336) - (1,778,336) (1,971,990)
(11,504) - (11,504) (60,352)
(498,799) - (498,799) (60,282)
(1,191,104) - (1,191,104) (1,184,349)
(11,468,764) - (11,468,764) (10,817,317)
- 1,327,542 1,327,542 2,033,562
- 329,929 329,929 805,559
- 462,213 462,213 912,897
- 2,119,684 2,119,684 3,752,018
(11,468,764) 2,119,684 (9,349,080) (7,065,299)
General revenues:
General property taxes 16,036,590 - 16,036,590 14,934,589
Tax increment collections 93,862 - 93,862 103,474
Grants and contributions not
restricted to specific programs 4,417 - 4,417 3,578
Unrestricted investment earnings (1,165,410) (260,113) (1,425,523) (89,313)
Gain on sale of capital assets 50,113 - 50,113 18,800
Transfers 454,680 (454,680) - -
Total general revenues,gain on sale of
capital assets and transfers 15,474,252 (714,793) 14,759,459 14,971,128
Change in net position 4,005,488 1,404,891 5,410,379 7,905,829
Net position-beginning 158,558,754 54,980,124 213,538,878 205,633,049
Net position-ending $ 162,564,242 $ 56,385,015 $ 218,949,257 $ 213,538,878
33
CITY OF ANDOVER,MINNESOTA
BALANCESHEET
GOVERNMENTALFUNDS
December 31,2022
With Comparative Totals For December 31,2021
Community CARES Grant/
Center ARPA Funding Water Trunk Sewer Trunk
General SRF SRF CPF CPF
Assets:
Cash and investments $ 10,471,766 $ 1,085,752 $ 1,869,351 $ 8,168,936 $ 8,180,077
Accrued interest 30,359 121,834 10,329 34,689 35,108
Due from other governmental units 123,012 - - - -
Accounts receivable-net 98,982 96,341
Prepaid items 35,152 -
Property taxes receivable:
Umemitted 127,567 1,980
Delinquent 84,848 1,317
Special assessments receivable:
Unremitted 90 -
Delinquent 12,120 -
Deferred - - 222,757
Lease receivable 214,827 5,780,000 -
Inventories-at cost 134,976 -
Land held for resale - - - -
Total assets $ 11,333,699 $ 7,087,224 $ 1,879.680 $ 8,426,382 $ 8,215,185
Liabilities,Deferred Inflows of Resources,and Fund Balances
Liabilities:
Accounts payable $ 177,344 66,840 8,062 $ 1,648 $ 1,648
Contracts payable 19,234 - 59,199 - -
Deposits payable 634,865 104,532 - 5,741 5,741
Due to other governmental units 21,104 3,449 - -
Salaries payable 205,016 27,374 -
Unearned revenue - - 1,783,570 - -
Total liabilities 1,057,563 202,195 1,850,931 7,389 7,389
Deferred inflows of resources:
Related to leases 214,827 5,780,000 - - -
Unavailable revenues 96,968 1,317 222,757
Total deferred inflows of resources 311,795 5,781,317 222,757
Fund balances(deficit):
Nonspendable 170,128 - -
Restricted -
Committed - - - -
Assigned - 1,103,712 28,949 9,196,236 8,207,796
Unassigned 9,794.213 - - - -
Total fund balances 9,964,341 1,103,712 28.849 8,196,236 8,207,796
Total liabilities,deferred inflows of resources,
and fund balances(deficit) $ 11,333,699 $ 7,087,224 $ 1,879,680 $ 8,426,382 $ 8,215,185
Fund balance reported above
Amounts reported for governmental activities in the statement of net position are different because:
Capital assets used in governmental activities are not financial resources and,therefore,are not reported in the funds.
Deferred outflows of resources-related other post employment benefits and pensions are not current financial resources and,therefore,are not reported in the funds.
Other long-term assets are not available to pay for current-period expenditures and,therefore,are reported as unavailable revenue in the funds.
Internal service funds are used by management to charge the cost of equipment maintenance and insurance to individual funds.
The assets and liabilities are included in the governmental activities statement of net position along with a deduction of net
revenue attributable to business-type activities.
Long-term liabilities,including bonds payable,other post employment benefits and net pension liability,are not due and payable in the
current period and,therefore,are not reported in the funds.
Deferred inflows of resources-pension related are associated with long-term liabilities that are not due and payable in the current period and,
therefore,are not reported in the funds.
Net position of governmental activities
The accompanying notes are an integral part of these financial statements.
34
Statement 3
2021A G.O
Tax Street
Road& Increment Reconstruction Other Totals
Bridge Projects Bonds Governmental Governmental Funds
CPF CPF CPF Funds 2022 2021
$ 12,345,132 $ 970,165 $ 3,826,405 $ 10,529,692 $ 57,447,276 $ 54,890,674
48,813 4,487 16,295 39,077 340,991 229,334
- - - 107,512 230,524 21,985
61,935 4,900 21,850 284,008 185,517
- - 10,000 45,152 49,800
19,357 - 56,056 204,960 177,788
12,975 418 32,399 131,857 156,518
3,205 - - 3,295 6,370
7,008 - 19,128 18,258
1,355,640 90,904 1,669,301 1,410,955
- - 5,994,827 6,375,682
- 134,976 122,856
- 840,000 - 840,000 765,000
$ 13,853.965 $ 1,819,970 $ 3,842,700 $ 10,887,490 $ 67,346,295 $ 64,410,737
$ 3,538 $ 3,653 $ - $ 21,996 $ 284,729 $ 361,750
- - 83,179 - 161,612 72,451
2,939 5,439 - 24,465 783,722 682,226
1,021,014 - 56,577 1,102,144 48,340
- 1,171 233,561 218,719
- - - 78,257 1,861,827 1,909,704
1,027,491 9,092 83,179 182,466 4,427,595 3,293,190
- - - - 5,994,827 6,375,682
1,375,523 840,418 123,303 2,660,286 2,350,731
1,375,523 840,418 123,303 8,655,113 8,726,413
- - - 10,000 180,128 172,656
970,460 3,759,521 3,778,771 8,508,752 12,033,034
- - - 584,224 584.224 499,284
11,450,951 6,208,726 35,196,270 30,214,430
- - - - 9,794.213 9,471,730
11,450,951 970,460 3,759,521 10,581,721 54,263,587 52,391,134
$ 13,853,965 $ 1,819,970 $ 3,842,700 $ 10,887,490 $ 67,346,295 $ 64,410,737
$ 54,263,587 $ 52,391,134
153,997,415 153,798,777
1,888,879 1,949,886
2,660,286 2,350,731
701,503 865,722
(50,771,237) (50,204,465)
(176,191) (2,593,031)
$ 162,564,242 $ 158,558,754
35
CITY OF ANDOVER,MINNESOTA
STATEMENT OF REVENUES,EXPENDITURES AND
CHANGES IN FUND BALANCE
GOVERNMENTALFUNDS
For The Year Ended December 31,2022
With Comparative Actual Amounts For The Year Ended December 31,2021
Community CARES Grant/
Center ARPA Funding Water Trunk Sewer Trunk
General SRF SRF CPF CPF
Revenues:
General property taxes $ 9,974,141 $ 154,614 $ $ $
Tax increment collections - -
Licenses and permits 972,879
Intergovernmental 963,289 1,834,877 52,196 -
Special assessments - - - 4,113 10,971
Charges for services 1,295,430 1,238,744 - -
Fines 55,983 - -
Investment income (189,494) (21,173) 15,005 (213,060) (220,494)
Miscellaneous:
Park dedication fees - - -
Connection charges - 1,681,295 281,083
Rent - 624,508 - -
Other 188,395 239,090 - - -
Total revenues 13,260,623 2,235,783 1,849,882 1,524,544 71,560
Expenditures:
Current:
General government 3,222,598 - - - -
Public safety 5,705,354 345 - -
Public works 1,957,322 - 1,361,295 93,893 1,668
Parks and recreation 1,362,086 1,682,793 8,307 - -
Recycling 169,169 - -
Economic development -
Unallocated 17,396
Capital outlay:
General government - -
Public safety 200,000
Public works - - -
Parks and recreation 135,904 37,358 40,807
Economic development - - -
Debt service:
Principal retirement
Interest
Paying agent fees - - -
Construction/acquisition costs - - 224,123 13,424 151,377
Total expenditures 12,569,829 1,720,151 1,834,877 107,317 153,045
Revenues over(under)expenditures 690,794 515,632 15.005 1,417,227 (81,485)
Other financing sources(uses):
Transfers in 197,081 - - 300,000 400,000
Transfers out (550,000) (300,000) (152,877) -
Bonds issued
Bond premium
Proceeds from sale of capital assets - -
Total other financing sources(uses) (352,919) (300,000) - 147,123 400,000
Net increase(decrease)in fund balance 337,875 215,632 15,005 1,564,350 318,515
Fund balance-January 1 9,626,466 888,080 13,844 6,631,886 7,889,281
Fund balance-December 31 $ 9,964,341 $ 1,103,712 $ 28,849 $ 8,196,236 $ 8,207,796
The accompanying notes are an integral part of these financial statements.
36
Statement 4
2021A G.O
Tax Street
Road& Increment Reconstruction Other Infra Totals
Bridge Projects Bonds Governmental Activity Governmental Funds
CPF CPF CPF Funds Eliminations 2022 2021
$ 1,511,780 $ $ $ 4,419,877 $ $ 16,060,412 $ 14,924,342
- 94,701 - 94,701 103,474
- - - 972,879 891,762
576,233 166,779 3,593,374 1,102,318
691,255 3,525 709,864 696,591
- 112,241 2,646,415 2,393,518
- 55,983 53,747
(302,562) (30,098) 48,085 (231,979) (1,145,770) (67,052)
- 1,360,540 1,360,540 622,680
- 1,962,378 926,982
- - 624,508 635,026
- 155,629 - 495,968 (30,600) 1,048,482 817,623
2,476,706 220,232 48,085 6,326,951 (30,600) 27,983,766 23,101,011
- - - 267,818 3,490,416 3,203,054
- - 60,263 5,765,962 5,533,004
657,518 3,485,067 91,708 7,648,471 4,361,714
- - 180,064 3,233,250 2,799,832
- - 169,169 239,606
656,156 87,035 743,191 297,628
- - 17,396 16,109
296,850 296,850 197,071
384,126 584,126 752,041
543,654 543,654 81,261
589,161 803,230 566,544
27,618 27,618 -
2,110,000 2,110,000 1,899,000
1,291,283 1,291,283 1,278,030
5,200 5,200 5,500
- - - - 388,924 743,203
657,518 656,156 3,485,067 5,934,780 27,118,740 21,973,597
1,819,188 (435,924) (3,436,982) 392,171 (30,600) 865,026 1,127,414
7,400 1,736,271 (1,644,271) 996,481 1,011,431
- (824,871) 1,674,871 (152,877) (148,705)
- 7,765,000
- - 188,834
- 163,823 - 163,823 18,800
7,400 1,075,223 30,600 1,007,427 8,835,360
1,826,588 (435,924) (3,436,982) 1,467,394 - 1,872,453 9,962,774
9,624,363 1,406,384 7,196,503 9,114,327 52,391,134 42,428,360
$ 11,450,951 $ 970,460 $ 3,759,521 $ 10,581,721 $ $ 54,263,587 $ 52,391,134
37
-This page intentionally left blank-
38
CITY OF ANDOVER,MINNESOTA
RECONCILIATION OF THE STATEMENT OF REVENUES, Statement 5
EXPENDITURES AND CHANGES IN FUND BALANCES OF
GOVERNMENTAL FUNDS TO THE STATEMENT OF ACTIVITIES
For The Year Ended December 31,2022
With Comparative Actual Amounts For The Year Ended December 31,2021
2022 2021
Amounts reported for governmental activities in the
statement of activities(Statement 2)are different because:
Net changes in fund balances-total governmental funds(Statement 4) $ 1,872,453 $ 9,962,774
Governmental funds report 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. (402,316) (622,206)
The net effect of various miscellaneous transactions involving capital assets is to increase
(decrease)net position(i.e.,sales,trade-ins,and donations). 989,878 1,471,520
Revenues in the statement of activities that do not provide current financial resources are not
reported as revenues in the funds. 309,555 (265,777)
The issuance of long-term debt(e.g.,bonds,leases)provides current financial resources to
governmental funds,while the repayment of the principal of long-term debt consumes the
current financial resources of governmental funds. Neither transaction,however,has any
effect on net position. This amount is the net effect of these differences in the treatment of
long-term debt and related items. 2,181,156 (5,794,844)
Vested post employment benefits are reported in the governmental funds when amounts are
paid. The statement of activities reports the benefits earned during the years. This amount (19,352) (69,746)
is the net effect of employee benefits earned and paid during the year.
Transfer out of governmental capital assets contributed to Enterprise Funds. (388,924) (743,203)
Some expenses reported in the statement of activities do not require use of current financial
resources and,therefore,are not reported as expenditures in governmental funds. (38,045) 36,228
Governmental funds report pension contributions for defined benefit plans as expenditures,
however,pension expense is reported in the Statement of Activities. This is the amount by
which pension expense differs from pension contributions. (334,698) 358,281
Internal service funds are used by management to charge the cost of equipment maintenance
and insurance to individual funds. This amount is the portion of net revenue attributable to
governmental activities. (164,219) (42,090)
Change in net position of governmental activities(Statement 2) $ 4,005,488 $ 4,290,937
The accompanying notes are an integral part of these financial statements.
39
CITY OF ANDOVER,MINNESOTA
STATEMENT OF NET POSITION
PROPRIETARY FUNDS
December 31.2022
With Comparative Totals For December 31,2021
Water Sewer Storm Sewer
Assets:
Current assets:
Cash and cash equivalents $ 6,340,316 $ 3,579,185 $ 1,217,421
Accrued interest 22,823 13,191 4,714
Due from other governmental units - 8,458 -
Accounts receivable-net 694,094 680,151 210,468
Prepaid items - - -
Special assessments receivable
Umetnittcd 1,537 1,279 369
Delinquent 125,262 102,608 31,863
Deferred - - 467
Inventories-at cost 27,463
Total current assets 7,211,495 4,384,872 1,465,302
Noncurrent assets:
Capital assets:
Land 730,243
Buildings and structures 15,877,590 - -
Machinery and equipment 1,529,756 790,755 557,501
Distribution and collection system 22,490,083 30,580,476 15,011,711
Construction in progress 26,361 8,702
Total capital assets 40,627,672 31,397,592 15,577,914
Less: Allowance for depreciation (21,083,777) (15,091,224) (6,474,363)
Total noncurrent assets 19,543,895 16,306,368 9,103,551
Total assets 26,755,390 20,691,240 10,568,853
Deferred outflows ofresources:
Related to other post employment benefits 1,798 1,126 -
Related to pensions 113,420 76,745
Total deferred outflows of resources 115,218 77,871
Liabilities:
Current liabilities:
Accounts payable 90,461 3,513 1,829
Contracts payable 1,873 2,102 2,946
Deposits payable 2,234 - -
Interest payable 8,622 -
Due to other governmental units 24,201 9,099 -
Salaries payable 16,469 9,476 4,136
Bonds payable-due within one year 770,000 - -
Compensated absences payable-due within one year 15,749 6,479 5,227
Total current liabilities 929,609 29,669 14,138
Noncurrent liabilities:
Other post employment benefits-due in more than one year 39,089 29,317 -
Bonds payable-due in more than one year 85,000 - -
Compensated absences payable-due in more than one year 89,246 36,711 29,618
Net pension liability-due in more than one year 329,176 242,513
Total noncurrent liabilities 542,511 308,541 29,618
Total liabilities 1,472,120 338,210 43,756
Deferred inflows ofresources:
Related to pensions 33,275 4,999
Net position:
Net investment in capital assets 18,688,895 16,306,368 9,103,551
Unrestricted 6,676,318 4,119,534 1,421,546
Total net positiou $ 25,365,213 $ 20,425,902 $ 10,525,097
Net position reported above
Amounts reported for business-type activities in the statement of netposition are different because:
Internal service funds are used by management to charge the cost of equipment maintenance
and insurance to individual funds. This amount is the portion of net revenue attributable to
business-type activities.
Net position of business-type activities
The accompanying notes are an integal part of these financial statements.
40
Statement 6
Totals
Governmental Activities-
Totals Internal Service Finds
2022 2021 2022 2021
$ 11,136,922 $ 10,909,733 $ 476.526 $ 686,764
40,728 24,647 2,965 2,188
8,458 10,040 - -
1,584,713 1,482,443 - -
- - 216.688 220,698
3,185 3,378 - -
259,733 229,979
467 914 - -
27,463 23,403 138,220 96,606
13,061,669 12,684,537 834,399 1,006,256
730,243 730,243 - -
15,877,590 15,877,590
2,878,012 1,607,351
68,082,270 65,982,488
35,063 1,709,054
87,603,178 95,906,726
(42,649,364) (40,765,298)
44,953,814 45,141,428
58,015,483 57,825,965 834.399 1,006,256
2,924 1,595 - -
190,165 227,626
193,089 229,221
95,803 47,545 52,218 31,438
6,921 501,199 - -
2,234 2,234
8,622 15,580
32,300 32,578 - -
30,081 33,756 11,875 11,314
770,000 755,000 - -
27,455 36,114
973,416 1,424,006 64,093 42,752
68,406 63,705 - -
85,000 869,426
155,575 204,648
571,689 319,067
880,670 1,456,846
1,854,086 2,880,852 64.093 42,752
38,274 291,992
44,098,814 43,517,002 - -
12,217,398 11,365,340 770,306 963,504
$ 56,316,212 $ 54,882,342 $ 770,306 $ 963,504
$ 56,316,212 $ 54,892,342
68,803 97,792
$ 56,385,015 $ 54,980,124
41
CITY OF ANDOVER,MINNESOTA
STATEMENT OF REVENUES,EXPENSES AND
CHANGES IN NET POSITION
PROPRIETARY FUNDS
For The Year Ended December 31,2022
With Comparative Actual Amounts For The Year Ended December 31,2021
Water Sewer Storm Sewer
Operating revenues:
User charges $ 3,567,061 $ 2,496,539 $ 663,245
Meters 49,416 - -
Other 67,286 614 -
Total operating revenues 3,683,763 2,497,153 663,245
Operating expenses:
Personal services 585,764 358,685 219,075
Supplies 364,849 19,284 7,140
Other service charges 881,846 186,962 111,250
Disposal charges - 1,364,778 -
Depreciation 905,486 655,345 327,718
Total operating expenses 2,737,945 2,585,054 665,183
Operating income(loss) 945,818 (87,901) (1,938)
Nonoperating revenues(expenses):
Intergovernmental revenue 3,600 - -
Investment income (146,718) (84,330) (29,065)
Interest expense (7,659) - -
Total nonoperating revenues(expenses) (150,777) (84,330) (29,065)
Income(loss)before contributions
and transfers 795,041 (172,231) (31,003)
Capital contributions 620,874 565,757 468,436
Transfers:
Transfers in 152,877 - -
Transfers out (418,741) (501,979) (45,161)
Total transfers (265,864) (501,979) (45,161)
Change in net position 1,150,051 (108,453) 392,272
Net position-January 1 24,215,162 20,534,355 10,132,825
Net position-December 31 $ 25,365,213 $ 20,425,902 $ 10,525,097
Net changes in net position reported above
Amounts reported for business-type activities in the statement of activities are different because:
Internal service funds are used by management to charge the cost of equipment maintenance
and insurance to individual funds. This amount is the portion of net revenue attributable to
business-type activities.
Change in net position of business-type activities
The accompanying notes are an intregral part of these financial statements.
42
Statement 7
Totals
lntra Governmental Activities-
Activity Totals Internal Service Funds
Eliminations 2022 2021 2022 2021
$ - $ 6,726,845 $ 6,740,115 $ 1,453,013 $ 1,321,744
- 49,416 44,946 - -
- 67,900 51,674 60,717 80,211
- 6,844,161 6,836,735 1,513,730 1,401,955
- 1,163,524 1,176,277 605,647 546,835
- 391,273 337,097 456,270 360,128
(30,600) 1,149,458 1,037,679 625,371 542,677
- 1,364,778 1,208,563 - -
- 1,888,549 1,798,222 - -
(30,600) 5,957,582 5,557,838 1,687,288 1,449,640
30,600 886,579 1,278,897 (173,558) (47,685)
- 3,600 - - -
- (260,113) (17,603) (19,640) (4,658)
- (7,659) (25,427) - -
- (264,172) (43,030) (19,640) (4,658)
30,600 622,407 1,235,867 (193,198) (52,343)
- 1,655,067 3,252,004 - -
- 152,877 148,705 - -
(30,600) (996,481) (1,011,431) - -
(30,600) (843,604) (862,726) - -
- 1,433,870 3,625,145 (193,198) (52,343)
- 54,882,342 51,257,197 963,504 1,015,847
$ - $ 56,316,212 $ 54,882,342 $ 770,306 $ 963,504
$ 1,433,870 $ 3,625,145
(28,979) (10,253)
$ 1,404,891 $ 3,614,892
43
CITY OF ANDOVER,MINNESOTA
STATEMENT OF CASH FLOWS
PROPRIETARY FUNDS
For The Year Ended December 31,2022
With Comparative Actual Amounts For The Year Ended December 31,2021
Water Sewer Storm Sewer
Cash flows from operating activities:
Receipts from customers and users $ 3,606,046 $ 2,459,088 $ 649,225
Payment to suppliers (1,682,581) (1,578,890) (124,996)
Payment to employees (597,675) (363,650) (223,869)
Net cash flows from operating activities 1,325,790 516,548 300,360
Cash flows from noncapital financing activities:
Intergovernmental revenues 3,600 - -
Transfers in 152,877
Transfers out (418,741) (501,979) (45,161)
Net cash flows from noncapital financing activities (262,264) (501,979) (45,161)
Cash flows from capital and related financing activities:
Acquisition of capital assets (28,465) (8,701) (8,702)
Interest paid on debt (29,043)
Payment of bonds (755,000)
Net cash flows from capital and related financing activities (812,508) (8,701) (8,702)
Cash flows from investing activities:
Investment income (155,324) (89,370) (31,500)
Net increase in cash and cash equivalents 95,694 (83,502) 214,997
Cash and cash equivalents-January 1 6,244,622 3,662,687 1,002,424
Cash and cash equivalents-December 31 $ 6,340,316 $ 3,579,185 $ 1,217,421
Reconciliation of operating income to net cash provided
(used)by operating activities:
Operating income(loss) $ 945,818 $ (87,901) $ (1,938)
Adjustments to reconcile operating income(loss)
to net cash flows from operating activities:
Depreciation 905,486 655,345 327,718
Changes in assets,deferred outflows of resources,
liabilities and deferred inflows of resources:
Decrease(increase)in due from other governmental units - 1,582 -
Decrease(increase)in accounts receivable (64,951) (26,905) (10,414)
Decrease(increase)in prepaid items
Decrease(increase)in special assessments (12,766) (12,742) (3,606)
Decrease(increase)in inventory (4,060) -
Decrease(increase)in deferred outflows of resources 19,514 16,618
Increase(decrease)in accounts payable 57,871 (6,050) (3,563)
Increase(decrease)in contracts payable (489,065) (2,170) (3,043)
Increase(decrease)in due to other governmental units (632) 354 -
Increase(decrease)in salaries payable (1,753) (2,355) 433
Increase(decrease)in other post employment benefits 2,686 2,015 -
Increase(decrease)in compensated absences (31,761) (20,744) (5,227)
Increase(decrease)in net pension liability 137,568 115,054
Increase(decrease)in deferred inflows ofresources (138,165) (115,553) -
Total adjustments 379,972 604,449 302,298
Net cash provided(used)by operating activities $ 1,325,790 $ 516,548 $ 300,360
Noncash investing,capital and financing activities:
Assets contributed to the Enterprise Funds $ 620,874 $ 565,757 $ 468,436
The accompanying notes are an integral part of these financial statements.
44
Statement 8
Totals
Governmental Activities-
Totals Internal Service Funds
2022 2021 2022 2021
$ 6,714,359 $ 6,778,903 $ 1,513,730 $ 1,401,955
(3,386,467) (2,149,535) (1,098,465) (1,124,130)
(1,185,194) (1,192,706) (605,086) (545,916)
2,142,698 3,436,662 (189,821) (268,091)
3,600 -
152,877 148,705
(965,881) (980,831)
(809,404) (832,126)
(45,868) (972,851)
(29,043) (45,493)
(755,000) (735,000)
(829,911) (1,753,344)
(276,194) (3,377) (20,417) (2,558)
227,189 847,815 (210,238) (270,649)
10,909,733 10,061,918 686,764 957,413
$ 11,136,922 $ 10,909,733 $ 476,526 $ 686,764
$ 855,979 $ 1,248,297 $ (173,558) $ (47,685)
1,888,549 1,798,222
1,582 2,827
(102,270) (82,810) -
- 4,010 (220,698)
(29,114) 22,151 -
(4,060) (5,016) (41,614) (4,923)
36,132 (192,107) - -
48,258 (12,565) 20,780 4,296
(494,278) 478,678 - -
(278) 3,307 - -
(3,675) 5,431 561 919
4,701 10,386 - -
(57,732) 5,560
252,622 (114,357)
(253,718) 268,658
1,286,719 2,188,365 (16,263) (220,406)
$ 2,142,698 $ 3,436,662 $ (189,821) $ (268,091)
$ 1,655,067 $ 3,252,004 $ $
45
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
Note 1 SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
The City of Andover was incorporated in 1974 and operates under the State of Minnesota Statutory Plan A form of government. The
governing body consists of a five-member City council elected by voters of the City.
The financial statements of the City have been prepared in conformity with generally accepted accounting principles as applied to
governmental units by the Governmental Accounting Standards Board(GASB). The following is a summary of the significant accounting
policies.
A. FINANCIAL REPORTING ENTITY
As required by generally accepted accounting principles,the financial statements of the reporting entity include those of the City
(the primary government)and its component units. The component units discussed below are included in the City's reporting entity
because of the significance of their operational or financial relationships with the City.
COMPONENT UNITS
In conformity with generally accepted accounting principles,the financial statements of the component units have been included
in the financial reporting entity as blended component units.
The Andover Economic Development Authority(EDA)is an entity legally separate from the City. However,for financial reporting
purposes,the EDA is reported as if it were part of the City's operations because the members of the City Council serve as EDA
Board Members and its purpose is to promote development within the City. The activity of the EDA is reported in the EDA General
Special Revenue Fund. Separate financial statements are not prepared for the EDA.
B. GOVERNMENT-WIDE AND FUND FINANCIAL STATEMENTS
The government-wide financial statements(i.e.,the statement of net position and the statement of activities)report information on
all of the nonfiduciary activities of the primary government and its component units. For the most part, the effect of interfund
activity has been removed from these statements. Governmental activities, which normally are supported by taxes and
intergovernmental revenues, are reported separately from business-(ype 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 business-type activity are
offset by program revenues. Direct expenses are those that are clearly identifiable with a specific function or business-type activity.
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 business-type activity and 2)grants and contributions that are restricted to meeting the
operational or capital requirements of a particular function or business-type activity. Taxes and other items not included among
program revenues are reported instead as general revenues.
Separate financial statements are provided for governmental funds and proprietary funds. Major individual governmental funds
and major individual enterprise funds are reported as separate columns in the fund financial statements.
C. MEASUREMENT FOCUS,BASIS OF ACCOUNTING,AND FINANCIAL STATEMENT PRESENTATION
The government-wide financial statements are reported using the economic resources measurement focus and the accrual basis of
accounting,as are the Proprietary 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 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
to be available when they are collectible within the current period or soon enough thereafter to pay liabilities of the current period.
For this purpose,the City considers all revenues,except reimbursement grants,to be available if they are collected within 60 days
of the end of the current fiscal period. Reimbursement grants are considered available if they are collected within one year of the
end of the current fiscal period. Expenditures generally are recorded when a liability is incurred, as under accrual accounting.
However, debt service expenditures, as well as expenditures related to compensated absences and claims and judgments, are
recorded only when payment is due.
Property taxes,special assessments,intergovernmental revenues,charges for services and interest associated with the current fiscal
period are all considered to be susceptible to accrual and so have been recognized as revenues of the current fiscal period. Only
46
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
the portion of special assessments receivable due within the current fiscal period is considered to be susceptible to accrual as
revenue of the current period. All other revenue items are considered to be measurable and available only when cash is received
by the City.
The City reports the following major governmental funds:
The General Fund is the City's primary operating fund. It accounts for all financial resources of the general government,
except those required to be accounted for in another fund.
The Communitv Center Special Revenue Fund(SRF)is used to account for the operations of the Andover YMCA/Community
Center,particularly the sports complex,ice arena,field house and concessions. The aquatics portion of the Community Center
is under the operations of the YMCA.
The CARES Grant/ARPA Funding SRF is used to account for money distributed to local governments to assist with the
financial strain of COVID-19.
The Water Trunk Capital Projects Fund(CPF) is used to account for water access fees and trunk improvements as part of
development. It is also used to reserve monies that will be needed for capital infrastructure replacements in the future.
The Sewer Trunk CPF is used to account for sewer access fees and sanitary sewer improvements.
The Road and Bridge CPF accounts for all road projects and the pavement management program,which includes annual seal
coating,crack sealing and overlays for roads.
The Tax Increment Projects CPF is used to account for activities in TIF districts 1-2, 1-5, 1-6 and all TIF land sales and
expenditures to reach the goals of the TIF district plans.
The 2021A G.O.Street Reconstruction Bonds CPF accounts for the bond proceeds issued to reconstruct roadways within the
City.
The City reports the following major proprietary funds:
The Water Fund accounts for the water service charges,which are used to finance the water system operating expenses.
The Sewer Fund accounts for the sewer service charges, which are used to finance the sanitary sewer system operating
expenses.
The Storm Sewer Fund accounts for the storm sewer utility charges, which are used to finance the storm sewer operating
expenses.
Additionally,the City reports the following fund type:
Internal Service Funds(ISF)are used to provide equipment maintenance and insurance to other departments of the City on a
cost reimbursement basis.
As a general rule the effect of interfund activity has been eliminated from the government-wide financial statements. Exceptions
to this general rule are transactions that would be treated as revenues, expenditures or expenses if they involved external
organizations,such as buying goods and services or payments in lieu of taxes,are similarly treated when they involve other funds
of the City. Elimination of these charges would distort the direct costs and program revenues reported for the various functions
concerned.
Amounts reported as program revenues include l)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.
Proprietary funds distinguish operating revenues and expenses from nonoperating items. Operating revenues and expenses
generally result from providing services and producing and delivering goods in connection with a proprietary fimd's principal
ongoing operations. The principal operating revenues of the water and sewer enterprise funds are charges to customers for sales
and services. Operating expenses for enterprise funds include the cost of sales and services, administrative expenses, and
depreciation on capital assets. All revenues and expenses not meeting this definition are reported as nonoperating revenues and
expenses.
47
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
When both restricted and unrestricted resources are available for an allowable use,it is the City's policy to use restricted resources
first,and then unrestricted resources as they are needed.
D. BUDGETS
Budgets are legally adopted on a basis consistent with generally accepted accounting principles. Annual appropriated budgets are
legally adopted for the General and Special Revenue Funds. Budgeted expenditure appropriations lapse at year-end.
Encumbrance accounting, under which purchase orders, contracts, and other commitments for the expenditure of monies are
recorded in order to reserve that portion of the appropriation,is not employed by the City because it is at present not considered
necessary to assure effective budgetary control or to facilitate effective cash management.
E. LEGAL COMPLIANCE-BUDGETS
The City follows these procedures in establishing the budgetary data reflected in the financial statements:
l. The City Administrator submits to the City Council a proposed operating budget for the fiscal year commencing the
following January 1. The budget includes proposed expenditures and the means of financing them.
2. Public hearings are conducted to obtain taxpayer comments.
3. The budget is legally enacted through City Council action.
4. Expenditures may legally exceed budgeted appropriations at the fund level through City Council action. Also,the City
Council may authorize transfers of budgeted amounts between departments within any fund.
5. Formal budgetary integration is employed as a management control device during the year for the General Fund and
Special Revenue Funds. Budgetary control for Capital Projects Funds is accomplished through the use of project controls.
6. The legal level of budgetary control is at the department level for the General Fund and at the fund level for the Special
Revenue Funds. Also inherent in this controlling function is the management philosophy that the existence of a particular
item or appropriation in the approved budget does not automatically mean that it will be spent. The budget process has
flexibility in that,where need has been properly demonstrated,an adjustment can be made within the department budget
by the City Administrator or between departments by the City Council.
7. The City Council made supplemental budget appropriations throughout the year. Individual amendments were not
material in relation to the original appropriations which were adjusted.
The following is a listing of Special Revenue Funds whose expenditures exceed budget appropriations:
Final Over
Budget Actual Budget
Special Revenue Funds:
CARES Grant/ARPA Funding $ 1,500,000 $ 1,834,877 $ 334,877
Construction Seal Coating 10,000 17,397 7,397
Charitable Gambling 35,000 81,543 46,543
The expenditures over budget were funded by greater than anticipated revenues and/or available fund balance.
F. CASH AND INVESTMENTS
Cash balances from all funds are combined and invested to the extent available in authorized investments. Earnings from such
investments are allocated to the individual funds on the basis of applicable cash balance participation of each fund.
The City provides temporary advances to finds that have insufficient cash balances by means of an advance from another fund
shown as interfund receivables in the advancing fund,and an interfund payable in the fund with the deficit,until adequate resources
are received. These interfund balances are eliminated on the government-wide financial statements.
48
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
Investments are stated at fair value, except for investments in external investment pools that meet GASB 79 requirements, are
stated at amortized cost. Short-term investments, such as commercial paper and banker's acceptances,are reported at amortized
cost.
For purposes of the Statement of Cash Flows of Proprietary Fund Types,cash equivalents are defined as short-tern,highly liquid
investments that are both:
a. readily convertible to known amounts of cash,or
b. so near their maturity that they present insignificant risk of changes in value because of changes in interest rates.
The City's policy considers cash equivalents to be those that meet the above criteria and have original maturities of three months
or less.
G. RECEIVABLES AND PAYABLES
During the course of operations,numerous transactions occur between individual funds for goods provided or services rendered.
Short-tern interfumd loans are classified as"interfund receivables/payables." Long-term interfund loans are classified as"interfund
loan receivable/payable." Any residual balances outstanding between the governmental activities and business-type activities are
reported in the government-wide financial statements as"internal balances."
Interfund loan receivables,as reported in the fund financial statements,are offset by a fund balance reserve account in applicable
governmental funds to indicate that they are not available for appropriation and are not expendable,available financial resources.
Property taxes and special assessments receivable have been reported net of estimated uncollectible accounts. (See Note 1 H and
1). Because utility bills are considered liens on property,no estimated uncollectible amounts are established. Uncollectible amounts
are not material for other receivables and have not been reported.
H. PROPERTY TAX REVENUE RECOGNITION
The City levies its property tax for the subsequent year during the month of December and it is certified to Anoka County.
December 30th is the last day the City can certify a tax levy to the County Auditor for collection the following year. Such taxes
become a lien on the following January 1. Anoka County is the collecting agency for the levy and remits the collections to the City
three times a year. Taxes not collected as of December 31 each year are shown as delinquent taxes receivable.
The County Auditor prepares the tax list for all taxable property in the City,applying the applicable tax rate to the tax capacity of
individual properties,to arrive at the actual tax for each property. The County Auditor also collects all special assessments,except
for certain prepayments paid directly to the City.
The County Auditor submits a list of taxes to be collected on each parcel of property to the County Treasurer in January of each
year. The County Treasurer collects all taxes and is required to mail copies of all personal property tax statements by April 15,and
copies of all real estate tax statements by April 15,of each year. Property owners are required to pay one-half of their real estate
taxes due by May 15 and the balance by October 15.
If taxes due May 15 are not paid on time, a penalty of 3% is assessed on homesteaded property and 7% on non-homesteaded
property. An additional 1%penalty is added each month the taxes remain unpaid,until October 15. If the taxes due May 15 are
not paid by October 15,a 2%penalty per month is added to homesteaded property and 4%per month to non-homesteaded property
until January 1.
If the taxes are not paid by January 1,further penalties are added. Penalties and interest apply to both taxes and special assessments.
There are some exceptions to the above penalties,but they are not material.
Within 30 days after the tax settlement date,the County Treasurer is required to pay 70%of the estimated collections of taxes and
special assessments to the City Treasurer. The County Treasurer must pay the balance to the City Treasurer within 60 days after
settlement,provided that after 45 days interest accrues at the rate of 8%per annum.
GOVERNMENT-WIDE FINANCIAL STATEMENTS
The City recognizes property tax revenue in the period for which the taxes were levied. Uncollectible property taxes are not
material and have not been reported.
49
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
GOVERNMENTAL FUND FINANCIAL STATEMENTS
The City recognizes property tax revenue when it becomes both measurable and available to finance expenditures of the current
period. In practice,current and delinquent taxes and State credits received by the City in July,December and January are recognized
as revenue for the current year. Taxes collected by the County by December 31 (remitted to the City the following January)and
taxes and credits not received at the year-end are classified as delinquent and due from County taxes receivable. The portion of
delinquent taxes not collected by the City in January is fully offset by deferred inflow of resources because they are not available
to finance current expenditures.
L SPECIAL ASSESSMENT REVENUE RECOGNITION
Special assessments are levied against benefited properties for the cost or a portion of the cost of special assessment improvement
projects in accordance with State Statutes. These assessments are collectible by the City over a term of years usually consistent
with the term of the related bond issue. Collection of annual installments(including interest)is handled by the County Auditor in
the same manner as property taxes. Property owners are allowed to(and often do)prepay 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 allowed to go
delinquent,the property is subject to tax forfeit sale. Proceeds of sales from tax forfeit properties are allocated first to the County's
costs of administering all tax forfeit properties. Pursuant to State Statutes,a property shall be subject to a tax forfeit sale after three
years unless it is homesteaded, agricultural or seasonal recreational land in which event the property is subject to such sale after
five years.
GOVERNMENT-WIDE FINANCIAL STATEMENTS
The City recognizes special assessment revenue in the period that the assessment roll was adopted by the City Council.
Uncollectible special assessments are not material and have not been reported.
GOVERNMENTAL FUND FINANCIAL STATEMENTS
The City recognizes revenue from special assessments when it becomes measurable and available to finance expenditures of the
current fiscal period. In practice,current and delinquent special assessments received by the City are recognized as revenue for the
current year. Special assessments that are collected by the County by December 31 (remitted to the City the following January)
are also recognized as revenue for the current year. All remaining delinquent,deferred and special deferred assessments receivable
in governmental funding are completely offset by deferred inflow of resources.
J. INVENTORIES
Inventories of the Governmental Funds and the Proprietary Funds are stated at cost,which approximates market,using the first-in,
first-out(FIFO)method.
Inventories of Governmental Funds are recorded as expenditures when consumed rather than when purchased.
K. PREPAID ITEMS
Certain payments to vendors reflect costs applicable to future accounting periods and are recorded as prepaid items in both
government-wide and fund financial statements. Prepaid items are reported using the consumption method and recorded as
expenditures/expenses at the time of consumption.
L. LEASE RECEIVABLE
The City's lease receivable is measured at the present value of lease payments expected to be received during the lease term. Under
the lease agreement,the City may receive variable lease payments that are dependent upon the lessee's revenue/the lessee's usage
levels.
A deferred inflow of resources is recorded for the lease. The deferred inflow of resources is recorded at the commencement of the
lease in an amount equal to the initial recording of the lease receivable and is recognized as revenue over the lease term.
50
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
M. LAND HELD FOR RESALE
Land held for resale represents various property purchases made by the City with the intent to sell in order to increase tax base or
attract new business. These assets are stated at the lower of cost or net realizable value.
N. CAPITAL ASSETS
Capital assets,which include property,plant,equipment and infrastructure assets(e.g.,roads,bridges,sidewalks,and similar items)
and intangible assets such as easements and computer software, are reported in the applicable governmental or business-type
activities columns in the government-wide financial statements. Capital assets are defined by the City as assets with an initial,
individual cost of more than $5,000 (except for easements which is$10,000) and an estimated useful life in excess of one year.
Such assets are recorded at historical cost or estimated historical cost if purchased or constructed. Donated capital assets are
recorded at acquisition value at the date of donation. The City has chosen the modified approach for reporting street and trail
system capital assets.
The costs of normal maintenance and repairs that do not add to the value of the asset or materially extend assets lives are not
capitalized.
The City implemented GASB Statement No. 51.Accounting and Financial Reporting.for Intangible Assets effective January 1,
2010 which required the City to capitalize and amortize intangible assets. Intangible assets include easements and computer
software. Pursuant to GASB Statement 51,in the case of initial capitalization of intangible assets, the City chose to capitalize
intangible assets retroactively to 1980, except for permanent easements and internally generated software. The City has already
accounted for computer software at historical cost and therefore retroactive reporting was not necessary. The City does not have
any temporary easements to record that meet the threshold of$10,000.
Property, plant and equipment of the primary government, as well as the component units, are depreciated/amortized using the
straight line method over the following estimated useful lives:
Assets Life
Buildings and improvements 10-30 years
Furniture and equipment(including software) 5- 10 years
Machinery and equipment 5- 10 years
Other park improvements 10-30 years
Storm sewer 50 years
Distribution and collection systems 50 years
Temporary easements 5- 15 years
The City elected to use the modified approach as defined by GASB Statement No.34 for infrastructure reporting of its streets and
trails. The City conducted a physical assessment in the fall of 2022 of the condition of the streets and trails constructed since 1974.
This condition assessment will be performed every 3 years. Each segment of City owned street or trail was assigned a physical
condition based on potential defects. An Overall Condition Index(OCI)was assigned to each segment. The index is expressed in
a continuous scale from 0 to 10,where 0 is assigned to the least acceptable physical condition and 10 is assigned to those segments
that have the characteristic of a new street or trail. The following conditions were defined:
Range Description
8- 10 Excellent
7-7.9 Very good
6-6.9 Good
4-5.9 Fair
2-3.9 Poor
1 - 1.9 Very poor
0-.9 Substandard
The City's policy relative to maintaining the street and trail assets is to achieve an average rating of"Good"for all segments. This
acceptable rating allows minor cracking and patching of the pavement along with minor roughness that could be noticeable to the
users of the system.
51
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
O. COMPENSATED ABSENCES
City employees earn vacation and sick pay accruing each payroll period. Unused vacation can be accrued by the employees up to
a maximum of 200 hours(240 hours if on the annual leave plan) as of the anniversary date of the individual's employment with
the City,unless a specific authorization is granted to an employee. All vacation pay is accrued when incurred in the government-
wide and proprietary fund financial statements. A liability for these amounts is reported in governmental funds only if they have
matured,for example,as a result of employee resignations and retirements.
Employees can also accrue an unlimited amount of unused sick leave. Employees with two or more years of service are entitled to
receive severance pay equal to a percentage of unused sick pay ranging from 20-50 percent based on years of service,up to a
maximum of 400 hours. The liability for severance pay is accounted for the same as accrued vacation pay.
P. LONG-TERM OBLIGATIONS
In the government-wide financial statements and proprietary fund types in the fund financial statements,long-term debt and other
long-term obligations are reported as liabilities in the applicable governmental activities, business-type activities, or proprietary
fund type statement of net position. Bond premiums and discounts,if material,are amortized over the life of the related debt.
In the fund financial statements,governmental fund types recognize bond premiums and discounts during the current period. The
face amount of debt issued is reported as other financing sources. Premiums received on debt issuances are reported as other
financing sources while discounts on debt issuances are reported as other financing uses.
Q. 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.
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. These constraints are established by Resolution of the City Council.
Assigned—consists of internally imposed constraints. These constraints reflect the specific purpose for which it is the City's
intended use. These constraints are established by the City Council and/or management. Pursuant to City Council Resolution,
the City's Administrator and Finance Director are authorized to establish assignments of fund balance.
Unassigned—is the residual classification for the general fund and 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,and then
use unrestricted resources as they are needed. When unrestricted 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.
R. INTERFUND TRANSACTIONS
Interfund services provided and used are accounted for as revenues, expenditures or expenses. Transactions that constitute
reimbursements to a fund for expenditures/expenses initially made from it that are properly applicable to another fund,are recorded
as expenditures/expenses in the reimbursing fund and as reductions of expenditures/expenses in the fiend that is reimbursed.
lnterfimd loans are reported as an interfund loan receivable or payable which offsets the movement of cash between funds. All
other interfund transactions are reported as transfers.
S. USE OF ESTIMATES
The preparation of financial statements in accordance with generally accepted accounting principles(GAAP)requires management
to make estimates that affect amounts reported in the financial statements during the reporting period. Actual results could differ
from such estimates.
T. RECLASSIFICATIONS
Certain amounts presented in prior year data have been reclassified in order to be consistent with the current year's presentation.
52
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
U. COMPARATIVE TOTALS
The basic financial statements and combining and individual fund financial statements and schedules include certain prior year
summarized comparative information in total but not at the level of detail required for a presentation in conformity with generally
accepted accounting principles. Accordingly, such information should be read in conjunction with the government's financial
statements for the year ended December 31,2021,from which the summarized information was derived.
V. DEFERRED OUTFLOWS/INFLOWS OF RESOURCES
In addition to assets, the statement of financial position will sometimes report a separate section for deferred outflows of
resources. This separate financial statement element, deferred outflows of resources,represent a consumption of net assets that
applies to a future period(s) and so will not be recognized as an outflow of resources (expense/expenditure) until then. The
government has two items that qualify for reporting in the category. It is other post employment benefits and the pension related
deferred outflows of resources reported in the government-wide Statement of Net Position and the proprietary funds Statement of
Net Position.
In addition to liabilities, the statement of financial position will sometimes report a separate section for deferred inflows of
resources. This separate financial statement element, deferred inflows of resourees, represent an acquisition of net assets that
applies to a future period(s)and so will not be recognized as an inflow of resources(revenue)until that time. The government has
pension related deferred inflows of resources reported in the government-wide Statement of Net Position and the proprietary funds
Statement of Net Position and lease related deferred inflows reported in the government-wide Statement of Net Position and
governmental funds Balance Sheet. The government also has a type of item,which arises only under a modified accrual basis of
accounting, that qualifies for reporting in this category. Accordingly, the item, unavailable revenue, is reported only in the
governmental funds balance sheet. The governmental funds report unavailable revenues from the following sources: property
taxes,tax increment,special assessments,certified bills and land held for resale.
W. DEFINED BENEFIT PENSION PLANS-STATEWIDE
Pensions. For purposes of measuring the net pension liability, deferred outflows/inflows of resources, and pension expense,
information about the fiduciary net position of the Public Employees Retirement Association(PERA)and additions to/deductions
from PERA's fiduciary net position have been determined on the same basis as they are reported by PERA except that PERA's
fiscal year end is June 30. 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.
X. RECONCILIATION OF GOVERNMENT-WIDE AND FUND FINANCIAL STATEMENTS
1. EXPLANATION OF CERTAIN DIFFERENCES BETWEEN THE GOVERNMENTAL FUND BALANCE SHEET AND
THE GOVERNMENT-WIDE STATEMENT OF NET POSITION
The governmental fund balance sheet includes a reconciliation between fund balance— total governmental funds and net
position — governmental activities as reported in the government-wide statement of net position. One element of that
reconciliation explains that"long-term liabilities,including bonds payable, other post employment benefits and net pension
liability, are not due and payable in the current period and therefore are not reported in the funds." The details of this
($50,771,237)difference are as follows:
Bonds payable $(43,910,579)
Accrued interest payable (492,791)
Other post employment benefits (420,208)
Compensated absences (894,134)
Net pension liability (5,053,525)
Net adjustment to reduce fund balance-total governmental
funds to arrive at net position-governmental activities $(50,771,237)
Another element of that reconciliation states that "internal service funds are used by management to charge the cost of
equipment maintenance and insurance to individual funds. The assets and liabilities are included in the governmental activities
statement of net position along with a deduction of net revenue attributable to business-type activities." The details of this
$701,503 difference are as follows:
53
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
Internal Service Funds net position $ 770306
Net revenue attributable to business-type activities (68,803)
Net adjustment to increase fund balance-total governmental
funds to arrive at net position-governmental activities $ 701,503
2. EXPLANATION OF CERTAIN DIFFERENCES BETWEEN THE GOVERNMENTAL FUND STATEMENT OF
REVENUES, EXPENDITURES. AND CHANGES IN FUND BALANCES AND THE GOVERNMENT-WIDE
STATEMENT OF ACTIVITIES
The governmental fund statement of revenues,expenditures,and changes in fund balances includes a reconciliation between
net changes in.fund balances—total governmental fiends and changes in net position ofgovernrnental activities as reported in
the government-wide statement of activities. One element of that reconciliation explains that"Governmental Funds report
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." The details of this($402,316)difference are as follows:
Capital outlay $ 2,255,478
Construction/acquisition costs 388,924
Depreciation expense (3,046,718)
Net adjustment to increase net changes in fund balances-total governmental
funds to arrive at changes in net position of governmental activities $ (402,316)
Another element of that reconciliation states that"The net effect of various miscellaneous transactions involving capital assets
(i.e., sales, trade-ins, and donations) is to increase (decrease)net position." The details of this $989,878 difference are as
follows:
In the statement of activities,only the gain on the sale of capital assets is
reported. However,in the governmental funds,the proceeds from the sale
increase financial resources. Thus,the change in net position differs from the
change in fund balance by the cost of the capital assets sold. S (115,793)
Donations of capital assets increase net position in the statement of activities,
but do not appear in the governmental funds because they are not financial
resources. S 1,105,671
Net adjustment to decrease net changes in fund balances-total governmental
funds to arrive at changes in net position of governmental activities. $ 989,878
Another element of that reconciliation states"Revenues in the Statement of Activities that do not provide current financial
resources are not reported as revenues in the funds." The details of this$309,555 difference are as follows:
54
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
Unavailable revenue-general property taxes:
At December 31,2021 $ (155,261)
At December 31,2022 131,439
Unavailable revenue-tax increment taxes:
At December 31,2021 (1,257)
At December 31,2022 418
Unavailable revenue-special assessments:
At December 31,2021 (1,429,213)
At December 31,2022 1,688,429
Unavailable revenue-land held for resale:
At December 31,2021 (765,000)
At December 31,2022 840,000
Net adjustments to decrease net changes in fund balances-total governmental
funds to arrive at changes in net position of governmental activities $ 309,555
Another element of that reconciliation states"the issuance of long-term debt(e.g.,bonds,leases)provides current financial
resources to governmental funds, while the repayment of the long-term debt consumes the current financial resources of
governmental funds." Neither transaction,however,has any effect on net position. The details of this$2,181,156 difference
are as follows:
Principal repayments:
Abatement bonds $ 1,490,000
Certificates of indebtedness 320,000
Capital improvement bonds 130,000
Referendum bonds 170,000
Amortization of bond premium 71,156
Net adjustment to increase net changes in fund balances-total governmental
funds to arrive at changes in net position of governmental activities $ 2,181,156
Another element of that reconciliation states that"Some expenses reported in the statement of activities do not require the use
of current financial resources and therefore are not reported as expenditures in governmental funds." The details of this
($38,045)difference are as follows:
Compensated absences $ (67,068)
Accrued interest 29,023
Net adjustment to decrease net changes in fund balances-total governmental
funds to arrive at changes in net position of governmental activities $ (38,045)
Another element of that reconciliation states that "internal service funds are used by management to charge the cost of
equipment maintenance and insurance to individual funds. This amount is the portion of net revenue attributable to
governmental activities." The details of this($164,219)difference are as follows:
Internal Service Funds change in net position $ (193,198)
Net revenue attributable to business-type activities 28,979
Net adjustment to increase fimd balance-total governmental
funds to arrive at net position-governmental activities $ (164,219)
55
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
Note 2 DEPOSITS AND INVESTMENTS
DEPOSITS
In accordance with Minnesota Statutes,the City maintains deposits at those depository banks authorized by the City Council. All such
banks are members of the Federal Reserve System.
Minnesota Statutes require that all City deposits be protected by insurance, surety bond, or collateral. The market value of collateral
pledged must equal 110%of the deposits not covered by insurance or bonds. Securities pledged as collateral are required to be held in
safekeeping by the City Clerk/Treasurer or in a financial institution other than that furnishing the collateral. Minnesota Statute 118A.03
identifies allowable forms of collateral.
Custodial Credit Risk—Deposits: Custodial credit risk is the risk that in the event of a bank failure,the City's deposits may not be
returned to it. As of December 31,2022,the bank balance of the City's deposits was covered by federal depository insurance or covered
by perfected collateral pledged and held in the City's name. The City has no additional deposit policies addressing custodial credit risk.
INVESTMENTS
Subject to rating,yield,maturity and issuer requirements as prescribed by statute,Minnesota Statutes 118A.04 and 118A.05 authorize
the City to invest in United States securities,state and local securities,commercial paper,time deposits,temporary general obligation
bonds,repurchase agreements,Minnesota joint powers investment trust and guaranteed investment contracts.
As of December 31,2022,the City had the following investments and maturities:
Investment Maturities(in Years)
Credit Fair Less Than More Than
Investment Type Rating Value 1 1-5 6- 10 10
Money market funds N/A $ 7,278,475 $ 7,278,475 $ - $ - $ -
Minnesota Municipal
Money Market Fund(4M) N/A 1,833,198 1,833,198 - - -
Certificates of deposit N/A 11,924,527 6,289,794 5,634,733 - -
Local/State governments A/A1/A2 59,896 59,896 - - -
AAl/AA2/AA3 9,031,435 1,971,256 6,741,277 318,902 -
AAA 8,403,470 1,803,280 5,927,452 672,738 -
U.S.agencies AAA 27,798,814 13,182,619 14,080,167 536,028 -
Total investments 66,329,815 $32,418,518 $32,383,629 $ 1,527,668 $ -
Deposits 2,730,909
Total cash and investments $69,060,724
The City categorizes its fair value measurements within the fair value hierarchy established by generally accepted accounting principles.
The hierarchy is based on the valuation inputs used to measure the fair value of the asset. The hierarchy has three levels. Level 1
investments are valued using inputs that are based on quoted prices in active markets for identical assets. Level 2 investments are valued
using inputs that are based on quoted prices for similar assets or inputs that are observable, either directly or indirectly. Level 3
investments are valued using inputs that are unobservable.
The City has the following recurring fair value measurements as of December 31,2022:
56
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
Fair Value Measurement Using
Investment Type 12/31/2022 Level 1 Level 2 Level 3
Investments at fair value:
Federal Home Loan Bank $ 10,553,299 $ - $ 4,585,563 $ -
Federal Farm Credit Bank 8,070,854 - 6,860,461 -
Federal Home Loan Mortgage Corporation 5,617,486 - 6,354,806 -
Federal National Mortgage Association 3,557,175 - 3,699,035 -
Municipal Bonds 17,494,801 - 14,419,753 -
Brokered Certificates of Deposit 11,924,527 - 13,235,458 -
Total investments at fair value 57,218,142 $ - $ 49,155,076 $ -
Investments not categorized:
External investment pool:
4M 1,833,198
Money Market 7,278,475
Total investments not categorized 9,111,673
Total S 66,329,815
The 4M Fund is an external investment pool investment which is regulated by Minnesota Statutes and the Board of Directors of the
League of Minnesota Cities. It is an unrated pool and the fair value of the position in the pool is the same as the value of pool shares.
The pool is managed to maintain a portfolio weighted average maturity of no greater than 60 days and seeks to maintain a constant net
asset value(NAV)per share of$1. The pool measures their investments in accordance with Government Accounting Standards Board
Statement No.79,at amortized cost.The 4M Plus Fund requires funds to be deposited for a minimun of 14 calendar days. Withdrawals
prior to the 14-day restriction period are subject to a penalty equal to 7 days interest on the amount withdrawn.
Custodial Credit Risk-Investments—For investments in securities,custodial credit risk is the risk that in the event of a failure of the
counteiparty,the City will not be able to recover the value of its investment securities that are in the possession of an outside party. As
of December 31, 2022, $250,000 of the City's S66,329,815 investments was iminsured and unregistered, with securities held in the
City's name.
Interest Rate Risk-The City has a formal investment policy that states the City will minimize the risk that the market value of securities
in the portfolio will fall due to the changes in general interest rates,by:
1) Structuring the investment portfolio so that securities mature to meet cash requirements for ongoing operations, thereby
avoiding the need to sell securities on the open market prior to maturity.
21) Investing operating funds primarily in shorter-term securities,money market mutual funds or similar investment pools.
Credit Risk-The City has a formal investment policy that states the City will minimize the credit risk,the risk of loss due to the failure
of the security issuer or backer,by:
1) Limiting investments to the safest types of securities.
2) Pre-qualifying the financial institutions,broker/dealers,intermediaries and advisers with which the City will do business.
A list will be maintained of financial institutions authorized to provide investment services. In addition, a list also will be
maintained of approved security broker/dealers selected by creditworthiness. These may include"primary"dealers or regional
dealers that qualify under Securities and Exchange Commission(SEC)Rule 15C3-1.
All financial institutions and broker/dealers who desire to become qualified for investment transactions must supply:audited
financial statements, proof of National Association of Securities Dealers (NASD) certification,proof of state registration,
completed broker/dealer questionnaire,and certification of having read and understood and agreeing to comply with the City's
investment policy.
An annual review of the financial condition and registration of qualified financial institutions and broker/dealers will be
conducted by the City Administrator.
57
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
Concentration of Credit Risk-More than 42%of the City's investments are in various holdings with U.S.agencies;Federal Home Loan
Bank(15.9%),Federal Farm Credit Bank(12.2%),Federal National Mortgage Association(5.4%)and Federal Home Loan Mortgage
Corporation(8.8%). The City's policy on concentration of investments is as follows:
1) Diversification-The investments shall be diversified by:
a) investments to avoid over concentration in securities from a specific issuer or business sector (excluding U.S.
Treasury securities),
b) limiting investment in securities that have higher credit risks,
c) investing in securities with varying maturities,and
d) continuously investing a portion of the portfolio in readily available funds such as local government investment
pools (LGIPs), money market funds or overnight repurchase agreements to ensure that appropriate liquidity is
maintained in order to meet ongoing obligations.
21) Maximum Maturities - To the extent possible, the City shall attempt to match its investments with anticipated cash flow
requirements. Unless matched to a specific cash flow,the City will not directly invest in securities maturing,or having average
lifes,of more than five(5)years from the date of purchase or in accordance with state and local statutes and ordinances.
Reserve funds and other funds with longer-tenn investment horizons may be invested in securities exceeding five(5)years if
the maturity of such investments are made to coincide as nearly as practicable with the expected use of funds. The intent to
invest in securities with longer maturities shall be disclosed in writing to the legislative body.
Because of inherent difficulties in accurately forecasting cash flow requirements, a portion of the portfolio should be
continuously invested in readily available funds such as local government investment pools,money market funds,or overnight
repurchase agreements to ensure that appropriate liquidity is maintained to meet ongoing obligations.
Note 3 RECEIVABLES
Significant receivable balances not expected to be collected within one year of December 31,2022 are as follows:
Delinquent Delinquent Special
Property Tax Assessment Lease
Taxes Increment Receivable Receivable Total
Major Funds:
General Fund $ 41,575 $ - $ 12,120 $ 174,570 $ 228,265
Community Center SRF 645 - - 5,420,000 5,420,645
Water Trunk CPF - - 220,264 - 220,264
Road and Bridge CPF 6,309 - 1,108,991 - 1,115,300
Tax Increment Projects CPF - 418 - - 418
Nonmajor Funds 15,876 - 88,249 - 104,125
Total $ 64,405 $ 418 $ 1,429,624 $5,594,570 $7,089,017
Note 4 LEASE RECEIVABLE
The City leases a portion of the Community Center to the YMCA for the purpose of operating an aquatic and fitness center and other related
programming. This lease is non-cancelable for a period of 12 years,with six renewal periods of 10 years at the lessee's option. The City
considers the likelihood of these options being exercised to be greater than 50%. However,future lease payments cannot be estimated at this
time. The agreement calls for variable annual lease payments between$624,508-$634,868 through February 1,2034. The lease payment
schedule is tied directly to the debt service schedule of the corresponding bonds that built the community center;therefore,the present value
of fixture minimum lease payments equals the principal amount outstanding as stated in the lease agreement.
The City leases a portion of its water tower for a cellular antenna site. This lease is non-cancelable through December 31,2026,with three
renewal periods of 5 years at the lessee's option. The City considers the likelihood of these options being exercised to be less than 50%. The
agreement calls for monthly payments of$2,434 with increases of 3% each year. The lease receivable is measured at the present value of
the future minimum lease payments expected to be received during the lease term at a discount rate of 3.00%which is based on the rate
available to finance acquisitions over the same time periods.
58
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
The City leases a portion of an emergency siren tower for a cellular antenna site. This lease is non-cancelable for a period of 9 months,with
three renewal periods of 5 years at the lessee's option. The City considers the likelihood that one renewal period being exercised to be greater
than 50%. The agreement calls for annual payments of$15,250 with increases of$1,000 each year. The lease receivable is measured at the
present value of the future minimum lease payments expected to be received during the lease term at a discount rate of 3.00%which is based
on the rate available to finance acquisitions over the same time periods.
At December 31,2022,the City recorded$5,994,827 in lease receivable and deferred inflows of resources; and the City recognized lease
revenue of$668,966 during the year,which included interest revenue of S288,111.
Note 5 UNAVAILABLE REVENUES
Governmental funds report deferred inflows of resources in connection with receivables for revenues that are not considered to be available
to liquidate liabilities of the current period. At the end of the current fiscal year,the various components of unavailable revenue reported in
the governmental funds were as follows:
Property Tax Special Land Held
Taxes Increment Assessments for Resale Total
Major Funds:
General Fund $ 84,848 $ - $ 12,120 $ - $ 96,968
Community Center SRF 1,317 - - - 1,317
Water Trunk CPF - - 222,757 - 222,757
Road and Bridge CPF 12,875 - 1,362,648 - 1,375,523
Tax Increment Projects CPF - 418 - 840,000 840,418
Nonmajor Funds 32,399 - 90,904 - 123,303
Total $ 131,439 $ 418 $1,688,429 $ 840,000 $2,660,286
Note 6 CAPITAL ASSETS
In accordance with GASB Statement No.34,the City has reported all capital assets including infrastructure in the government-wide statement
of net position. The City elected to use the modified approach as defined by GASB Statement No. 34 for infrastructure reporting for its
streets and trails. As a result, no accumulated depreciation or depreciation expense has been recorded for this system. A more detailed
discussion of the modified approach is presented in the Required Supplementary Information section of this report. All other capital assets
including other infrastructure systems were reported using the basic approach whereby accumulated depreciation and depreciation expense
have been recorded. Capital asset activity for the year ended December 3 I,2022 was as follows:
59
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
Beginning Ending
Primary Government Balance Additions Deletions Balance
Governmental activities:
Capital assets not being depreciated:
Land and improvements $ 11,321,133 $ - $ (115,793) $ 11,205,340
Streets and trails 91,057,516 1,105,671 - 92,163,187
Construction in progress 15,000 40,807 (15,000) 40,807
Total capital assets not being depreciated 102,393,649 1,146,478 (130,793) 103,409,334
Capital assets being depreciated:
Buildings and improvements 62,021,145 361,542 (46,164) 62,336,523
Furniture and equipment(including software) 1,262,725 462,892 - 1,725,617
Machinery and equipment 10,232,367 818,287 (221,925) 10,828,729
Other park improvements 8,663,018 586,950 (46,966) 9,203,002
Total capital assets being depreciated 82,179,255 2,229,671 (315,055) 84,093,871
Less accumulated depreciation for:
Buildings and improvements 17,862,028 2,075,985 (46,164) 19,891,849
Furniture and equipment 738,055 128,106 - 866,161
Machinery and equipment 7,043,034 507,045 (221,925) 7,328,154
Other park improvements 5,131,010 335,582 (46,966) 5,419,626
Total accumulated depreciation 30,774,127 3,046,718 (315,055) 33,505,790
Total capital assets being depreciated-net 51,405,128 (817,047) - 50,588,081
Governmental activities capital assets-net $ 153,798,777 S 329,431 $ (130,793) S 153,997,415
Business-type activities:
Capital assets not being depreciated:
Land and improvements $ 730,243 S - $ - S 730,243
Construction in progress 1,709,054 35,063 (1,709,054) 35,063
Total capital assets not being depreciated 2,439,297 35,063 (1,709,054) 765,306
Capital assets being depreciated:
Buildings and improvements 15,877,590 - - 15,877,590
Furniture and equipment(including software) 27,936 1,191,958 - 1,219,894
Machinery and equipment 1,579,415 83,186 (4,483) 1,658,118
Collection and distribution 65,982,488 2,099,782 - 68,082,270
Total capital assets being depreciated 83,467,429 3,374,926 (4,483) 86,837,872
Less accumulated depreciation for:
Buildings and improvements 11,184,351 404,557 - 11,588,908
Furniture and equipment 23,662 40,182 - 63,844
Machinery and equipment 1,051,967 95,670 (4,483) 1,143,154
Collection and distribution 28,505,318 1,348,140 - 29,853,458
Total accumulated depreciation 40,765,298 1,888,549 (4,483) 42,649,364
Total capital assets being depreciated-net 42,702,131 1,486,377 - 44,188,508
Business-type activities capital assets-net $ 45,141,428 S 1,521,440 $ (1,709,054) S 44,953,814
60
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
Depreciation/amortization expense was charged to functions/programs of the primary government as follows:
Governmental activities:
General government $ 121,056
Public safety 367,770
Public works 597,124
Parks and recreation 1,944,269
Recycling 6,862
Economic development 9,637
Total depreciation/amortization expense-governmental activities $ 3,046,718
Business-type activities:
Water $ 905,486
Sewer 655,345
Storm sewer 327,718
Total depreciation/amortization expense-business-type activities $ 1,888,549
CONSTRUCTION COMMITMENTS
At December 31,2022,the City did not have any construction commitments.
61
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
Note 7 LONG-TERM DEBT
The City issues general obligation bonds,equipment certificates and promissory notes to provide funds for the acquisition and construction
of major capital facilities. The reporting entity's long-term debt is segregated between the amounts to be repaid from governmental activities
and amounts to be repaid from business-type activities.
Issue Maturity Interest Original Payable
Date Date Rate Issue 12/31/22
GOVERNMENTAL ACTIVITIES:
Abatement Bonds:
2012C G.O.Abatement Bonds 12/27/2012 2/1/2031 1.00-3.00% $ 17,315,000 $ 9,605,000
2019A G.O.Abatement Bonds 8/1/2019 2/1/2040 3.00-5.00% 15,770,000 14,990,000
Total abatement bonds 33,085,000 24,595,000
Certificates of Indebtedness:
2020A G.O.Equipment Certificates 3/19/2020 2/1/2024 4.00% 1,310,000 675,000
2021A G.O.Equipment Certificates 12/28/2021 2/1/2026 2.00% 630,000 630,000
Total certificates of indebtedness 1,940,000 1,305,000
Capital Improvement Bonds:
2018A C.O.Capital Improvement Plan Bonds 12/27/2018 2/1/2044 3.00-5.00% 10,000,000 9,660,000
Street Reconstruction Bonds:
2021A G.O.Street Reconstruction Bonds 12/28/2021 2/l/2030 1.00-2.00% 7,135,000 7,135,000
Total-bonded indebtedness 52,160,000 42,695,000
Issuance premiums - 1,215,579
Compensated absences payable - 894,134
Total governmental activities indebtedness 52,160,000 44,804,713
BUSINESS-TYPE ACTIVITIES:
General Obligation Revenue Bonds:
2009A G.O.Water Revenue Bonds 3/26/2009 2/1/2024 2.00-4.25% 1,025,000 165,000
2016B G.O.Water Revenue Refunding Bonds 12/7/2016 2/1/2023 2.00% 3,925,000 690,000
Total general obligation revenue bonds 4,950,000 855,000
Compensated absences payable - 183,030
Total business-type activities indebtedness 4,950,000 1,038,030
Total City indebtedness $ 57,1 10,000 $45,842,743
For the governmental activities,compensated absences are generally liquidated by the General and Special Revenue Funds.
62
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
Annual debt service requirements to maturity for general obligation bonds are as follows:
Governmental Activities
Abatement Bonds Certificates of Indebtedness Capital Improvement Bonds
Principal Interest Principal Interest Principal Interest
2023 $ 1,530,000 $ 786,181 $ 480,000 $ 31,500 $ 290,000 $ 334,006
2024 1,585,000 735,650 500,000 14,950 300,000 319,256
2025 1,635,000 681,256 160,000 4,900 315,000 303,881
2026 1,690,000 622,925 165,000 1,650 335,000 287,631
2027 1,750,000 561,025 - - 350,000 270,506
2028-2032 8,540,000 1,834,097 - - 1,955,000 1,165,456
2033-2037 4,695,000 835,875 - - 2,260,000 846,332
2038-2042 3,170,000 144,600 - - 2,660,000 445,110
2043-2044 - - - - 1,195,000 42,263
Total $24,595,000 $ 6,201,609 $ 1,305,000 $ 53,000 $ 9,660,000 $ 4,014,441
Governmental Activities Business-Type Activities
Street Reconstruction Bonds G.O.Revenue Bonds
Principal Interest Principal Interest
2023 $ 825,000 $ 109,310 $ 770,000 $ 12,153
2024 855,000 92,510 85,000 1,806
2025 870,000 75,260 - -
2026 885,000 57,710 - -
2027 905,000 39,810 - -
2028-2031 2,795,000 48,170 - -
$ 7,135,000 $ 422,770 $ 855,000 $ 13,959
It is not practical to determine the specific year for payment of long-term accrued compensated absences.
CHANGE IN LONG-TERM LIABILITIES
Long-term liability activity for the year ended December 31,2022,was as follows:
Beginning Ending Due Within
Balance Additions Reductions Balance One Year
Governmental activities:
Bonds payable:
Abatement bonds $26,085,000 $ - $ (1,490,000) $24,595,000 $ 1,530,000
Certificates of indebtedness 1,625,000 - (320,000) 1,305,000 480,000
Capital improvement bonds 9,790,000 - (130,000) 9,660,000 290,000
Street reconstruction bonds 7,135,000 - - 7,135,000 825,000
Referendum bonds 170,000 - (170,000) - -
Total bonds payable 44,805,000 - (2,110,000) 42,695,000 3,125,000
Issuance premiums 1,286,735 - (71,156) 1,215,579 -
Compensated absences 827,066 478,482 (411,414) 894,134 134,120
Total governmental activities
long-term liabilities $46,918,801 $ 478,482 $ (2,592,570) S 44,804,713 S 3,259,120
63
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
Beginning Ending Due Within
Balance Additions Reductions Balance One Year
Business-type activities:
Bonds payable:
G.O.revenue bonds $ 1,610,000 $ - $ (755,000) $ 855,000 $ 770,000
Issuance premiums 14,426 - (14,426) - -
Compensated absences 240,762 4,254 (61,986) 183,030 27,455
Total business-type activities
longterm liabilities $ 1,865,188 $ 4,254 $ (831,412) $ 1,038,030 $ 797,455
For the governmental activities,bonds can be summarized in the following categories:
The abatement bonds were used to purchase the 132,000 square foot building from the EDA and expand the building.The bonds
are general obligations of the City for which it pledges its full faith,credit and taxing powers to the payment of principal and interest
on the bonds.
The certificates of indebtedness are used to finance the purchase of capital equipment. The certificates are general obligations of
the City for which it pledges its full faith,credit and taxing powers to the payment of principal and interest on the certificates.
The capital improvement bonds are used to finance the construction of the public works maintenance facility with a wash bay and
a cold storage building.The bonds are general obligations of the City for which it pledges its full faith,credit and taxing powers to
the payment of principal and interest on the bonds.
The street reconstruction bonds are used to finance the reconstruction of roadways in the City.The bonds are general obligations
of the City for which it pledges its fall faith,credit and taxing powers to the payment of principal and interest on the bonds.
The referendum bonds were used to finance various land acquisitions for open space preservation within the City. The bonds are
general obligations of the City for which it pledges its full faith,credit and taxing powers to the payment of principal and interest
on the certificates.
For the business-type activities,the G.O.revenue bonds were used to finance the construction of a water treatment plant. The bonds are
payable from net revenues of the water system and are general obligations of the City for which its full faith,credit and taxing powers
are pledged.
REVENUESPLEDGED
2012C G.O. Abatement Bonds. The City has pledged future lease revenue, operating revenues (net of operating expenses) and, if
necessary,a debt service tax levy to repay the$17,315,000 bonds issued in December 2012. Proceeds from this bond refunded the 2004
EDA Public Facility Lease Revenue Bonds.Lease revenues were projected to produce 100%of the debt service requirements over the
life of the bonds. Total principal and interest remaining on the bonds is$10,894,384,payable through February 2031. For the current
year,principal and interest paid and total property tax revenues were$1,213,932 and$971,246,respectively.
2019A G.O. Abatement Bonds. The City has pledged future lease revenue, operating revenues (net of operating expenses) and, if
necessary,a debt service tax levy to repay the$15,770,000 bonds issued in August 2019. Proceeds from this bond were used to finance
the expansion of the community center. Total principal and interest remaining on the bonds is$19,902,225,payable through February
2040. For the current year,principal and interest paid and total property tax revenues were$1,109,776 and$1,010,546,respectively.
2020A G.O.Equipment Certificates. The City has pledged future property tax revenue to repay the$1,310,000 bonds issued in March
2020. Proceeds from the bonds were used to finance the purchase of capital equipment. Property taxes were projected to produce 100%
of the debt service requirements over the life of the bonds. Total principal and interest remaining on the bonds is$702,300,payable
through February 2024. For the current year,principal and interest paid and total property tax revenues were$353,400 and$373,549,
respectively.
64
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
2021A G.O.Equipment Certificates. The City has pledged future property tax revenue to repay the$630,000 bonds issued in December
2021. Proceeds from the bonds were used to finance the purchase of capital equipment. Property taxes were projected to produce 100%
of the debt service requirements over the life of the bonds. Total principal and interest remaining on the bonds is $655,700,payable
through February 2026. For the current year,principal and interest paid and total property tax revenues were $7,455 and$169,410,
respectively.
2018A G.O. Capital Improvement Plan Bonds. The City has pledged future property tax revenue to repay the$10,000,000 bonds issued
in December 2018. Proceeds from the bonds were used to finance the construction of a public works maintenance facility with a wash
bay and a cold storage building. Property taxes were projected to produce 100%of the debt service requirements over the life of the
bonds. Total principal and interest remaining on the bonds is $13,674,441, payable through February 2044. For the current year,
principal and interest paid and total property tax revenues were$474,507 and$615,376,respectively.
2021A G.O. Street Reconstruction Bonds. The City has pledged future property tax revenue to repay the$7,135,000 bonds issued in
December 2021. Proceeds from the bonds were used to finance the reconstruction of roadways in the City. Property taxes were projected
to produce 100% of the debt service requirements over the life of the bonds. Total principal and interest remaining on the bonds is
$7,557,770, payable through February 2030. For the current year, principal and interest paid and total property tax revenues were
$69,557 and$597,918,respectively.
2009A C.O. Water Revenue Bonds. The City has pledged future water customer revenues, net of operating expenses, to repay the
$1,025,000 bonds issued in March 2009. Proceeds of the bonds provided financing for the addition to the water treatment plant. The
bonds are payable from water customer net revenues and are payable through 2024. The total principal and interest remaining on the
bonds is$172,059. The principal and interest paid for the current year and total customer net revenues were$88,492 and$1,585,440,
respectively.
2016B G.O. Water Revenue Refunding Bonds. The City has pledged future water customer revenues,net of operating expenses,to repay
the$3,925,000 bonds issued in December 2016. Proceeds of the bonds refunded the Series 2007B Bonds. The bonds are payable from
water customer net revenues and are payable through 2023. The total principal and interest remaining on the bonds is$696,900. The
principal and interest paid for the current year and total customer net revenues were$695,550 and$1,585,440,respectively.
Note 8 LEGAL DEBT MARGIN
The City is subject to a statutory limitation by the State of Minnesota for bonded indebtedness payable principally from property taxes. The
City's legal debt margin for 2022 and 2021 is computed as follows:
December 31,
2022 2021
Estimated taxable market value $3,827,552,964 $3,543 956.78 1
Debt limit(3%of market value) 114,826,589 106,318,703
Amount of debt applicable to debt limit:
Total bonded debt $ 43,550,000 $ 46,415,000
Less: Nonapplicable debt
G.O.water revenue bonds (855,000) (1,610,000)
Less: Cash and investments in related
debt service funds (3,435,767) (2,516,818)
Total debt applicable to debt limit 39,259,233 42,288,182
Legal debt margin $ 75,567,356 $ 64,030,521
65
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
Note 9 DEFINED BENEFIT PENSION PLANS-PERA
A. PLAN DESCRIPTION
The City participates in the following cost-sharing multiple-employer defined benefit pension plans 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 under
Section 401(a)of the Internal Revenue Code.
1. General Employees Retirement Fund(GERF)
All full-time(with exception of employees covered by PEPFF)and certain part-time employees of the City are covered by the
GERF. GERF members belong to the Coordinated Plan. Coordinated Plan members are covered by Social Security.
2. Public Employees Police and Fire Plan(PEPFF)
The PEPFF,originally established for police officers and firefighters not covered by a local relief association,now covers all
police officers and firefighters hired since 1980. Effective July 1, 1999,the PEPFF also covers police officers and firefighters
belonging to a local relief association that elected to merge with and transfer assets and administration to PERA.
B. BENEFITS PROVIDED
PERA provides retirement, disability, and death benefits. Benefit provisions are established by state statute and can only be
modified by the state legislature. Vested,terminated employees who are entitled to benefits,but are not receiving them yet are
bound by the provisions in effect at the time they last terminated their public service.
1. GERF 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 Plan members is 1.2%for each of the first ten 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% 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 SSA, with a minimum increase of at least 1% 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 the 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.
2. PEPFF
Benefits for PEPFF members first hired after June 30,2010 but before July 1,2014,vest on a prorated basis from 50%after
five years up to 100%after ten years of credited service. Benefits for PEPFF members first hired after June 30,2014 vest on
a prorated basis from 50%after ten years up to 100%after twenty years of credited service. The annuity accrual rate is 3%
of average salary for each year of service. For PEPFF members who were first hired prior to July 1, 1989, a full annuity is
available when age plus years of service equal at least 90.
Benefit increases are provided to benefit recipients each January. The postretirement increase will be fixed at 1%. Recipients
that have been receiving the annuity or benefit for at least 36 months as of June 30 before the effective date of the increase
will receive the full increase. Recipients receiving the annuity or benefit for at least 25 months but less than 36 months as of
the June 30 before the effective date of the increase will receive a reduced prorated increase.
66
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
C. CONTRIBUTIONS
Minnesota Statutes Chapter 353 sets the rates for employer and employee contributions. Contribution rates can only be modified
by the state legislature.
1. GERF Contributions
Coordinated Plan members were required to contribute 6.5%of their annual covered salary in fiscal year 2022 and the City
was required to contribute 7.5%. The City's contributions to the GERF for the year ended December 31,2022 were$349,150.
The City's contributions were equal to the required contributions as set by state statute.
2. PEPFF Contributions
Police and Fire members were required to contribute 11.8%of their annual covered salary in fiscal year 2022 and the City
was required to contribute 17.70%. The City's contributions to the PEPFF for the year ended December 31, 2022 were
$47,226. The City's contributions were equal to the required contributions as set by state statute.
D. PENSION COSTS
1. GERF Pension Costs
At December 31, 2022, the City reported a liability of$4,854,980 for its proportionate share of the GERF'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,340.
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 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 of PERA's participating
employers. The City's proportionate share was 0.0613%at the end of the measurement period and 0.0601%for the beginning
of the period.
City's proportionate share of the net pension liability $ 4,854,980
State of Minnesota's proportionate share of the net pension
liability associated with the City 142,340
Total $ 4,997,320
For the year ended December 31, 2022 the City recognized pension expense of$678,577 for its proportionate share of the
GERF's pension expense. In addition,the City recognized an additional$21,269 of pension expense(and grant revenue)for
its proportionate share of the State of Minnesota's contribution of$16 million to the GERF.
At December 31,2022,the City reported its proportionate share of the GERF's deferred outflows of resources and deferred
inflows of resources related to pensions from the following sources:
67
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
Deferred Deferred
Outflows Inflows
of Resources of Resources
Differences between expected and actual economic experience $ 40,552 $ 51,908
Changes in actuarial assumptions 1,098,770 19,939
Difference between projected and actual investment earnings 85,531 -
Changes in proportion 107,802 -
Contributions paid to PERA subsequent to the measurement date 174,772 -
Total $ 1,507,427 $ 71,847
The$174,772 reported as deferred outflows of resources related to pensions resulting from City 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 inflows of resources related to pensions will be recognized in pension
expense as follows:
Year Ended Pension Expense
December 31, Amount
2023 $ 474,685
2024 484,340
2025 (137,277)
2026 439,060
2027 -
Thereafter -
2. PEPFF Pension Costs
At December 31,2022,the City reported a liability of$770,234 for its proportionate share of the PEPFF's net pension liability.
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 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 of PERA's participating
employers. The City's proportionate share was 0.0177%at the end of the measurement period and 0.0162%for the beginning
of the period.
The State of Minnesota also contributed $18 million to PEPFF during the plan fiscal year ended June 30, 2022. The
contribution consisted of$9 million in direct state aid that does meet the definition of a special funding situation and$9 million
in supplemental state aid that does not meet the definition of a special funding situation. The direct state aid was paid on
October 1,2021. Thereafter,by October 1 of each year,the state will pay$9 million to the PEPFF until full funding is reached
or July 1,2048,whichever is earlier. The$9 million in supplemental state aid will continue until the fund is 90%funded,or
until the State Patrol Plan(administered by the Minnesota State Retirement System)is 90%funded,whichever occurs later.
The State of Minnesota is included as a non-employer contributing entity in the PEPFF Schedule of Employer Allocations
and Schedule of Pension Amounts by Employer, Current Reporting Period Only(pension allocation schedules) for the $9
million in direct state aid. PEPFF employers need to recognize their proportionate share of the State of Minnesota's pension
expense(and grant revenue)under GASB 68 special funding situation accounting and financial reporting requirements. For
the year ended December 31,2022,the City recognized pension expense of$90,454 for its proportionate share of the Police
and Fire Plan's pension expense. The City recognized an additional $6,536 as pension expense(and grant revenue)for its
proportionate share of the State of Minnesota's contribution of$9 million to the PEPFF.
The State of Minnesota is not included as a non-employer contributing entity in the Police and Fire Pension Plan pension
allocation schedules for the$9 million in supplemental state aid. The City also recognized$1,593 for the year ended December
31,2022 as revenue and an offsetting reduction of net pension liability for its proportionate share of the State of Minnesota's
on-behalf contributions to the Police and Fire Fund.
68
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
At December 31,2022,the City reported its proportionate share of the PEPFF's deferred outflows of resources and deferred
inflows of resources related to pensions from the following sources:
Deferred Deferred
Outflows Inflows
of Resources of Resources
Differences between expected and actual economic experience $ 47,015 $ -
Changes in actuarial assumptions 453,401 4,508
Difference between projected and actual investment earnings 10,897 -
Changes in prop ortion 14,218 138,109
Contributions paid to PERA subsequent to the measurement date 27,264 -
Total $ 552,795 $ 142,617
$27,264 reported as deferred outflows of resources related to pensions resulting from City 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 inflows of resources related to pensions will be recognized in pension expense as
follows:
Year Ended Pension Expense
December 31, Amount
2023 $ 14,544
2024 77,874
2025 70,438
2026 153,129
2027 66,929
Thereafter -
The net pension liability will be liquidated by the general,water and sewer funds.
E. ACTUARIAL ASSUMPTIONS
The total pension liability in the June 30,2022 actuarial valuation was determined using an individual entry-age normal actuarial
cost method and the following actuarial assumptions:
Inflation 2.25%per year
Investment Rate of Return 6.50%
The long-term investment rate of return is based on a review of inflation and investment return assumptions from a number of
national investment consulting firms. The review provided a range of investment return rates deemed to be reasonable by the
actuary. An investment return of 6.50%was deemed to be within that range of reasonableness for financial reporting purposes.
Benefit increases after retirement are assumed to be 1.25%for the GERF. The PEPFF benefit increase is fixed at 1.00%per year
and that increase was used in the valuation.
Salary growth assumptions in the GERF range in annual increments from 10.25%after one year of service to 3.0%after 27 years
of service. In the PEPFF,salary growth assumptions range from 11.75%after one year of service to 3.0%after 24 years of service.
Mortality rates for GERF were based on the Pub-2010 General Employee Mortality Table. Mortality rates for PEPFF were based
on the Pub-2010 Public Safety Employee Mortality tables. The tables are adjusted slightly to fit PERA's experience.
Actuarial assumptions for GERF are reviewed every four years. The most recent four-year experience study for GERF was
completed in 2019. The assumption changes were adopted by the Board and become effective with the July 1, 2020 actuarial
valuation. The most recent four-year experience study for PEPFF was completed in 2020 and adopted by the Board and became
effective with the July 1,2021 actuarial valuation.
69
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
The following changes in actuarial assumptions and plan provisions occurred in 2022:
General Employees Fund
Changes in Actuarial Assumptions:
• The mortality improvement scale was changed from Scale MP-2020 to Scale MP-2021.
Police and Fire Fund
Changes in Actuarial Assumptions:
• The single discount rate was changed from 6.50%to 5.40%.
• The mortality improvement scale was changed from Scale MP-2020 to Scale MP-2021.
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 remm 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:
Target Long-T erm Expected
Asset Class Allocation Real 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%
F. DISCOUNT RATE
The discount rate for the GERF used to measure the total pension liability in 2022 was 6.5%. The projection of cash flows used to
determine the discount rate assumed that contributions from plan members and employers will be made at rates set in Minnesota
Statutes. Based on these assumptions,the fiduciary net position of the GERF 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.
In the PEPFF,the fiduciary net position was projected to be available to make all projected future benefit payments of current plan
members through June 30, 2060. Beginning in fiscal year ended June 30, 2061, projected benefit payments exceed the funds'
projected fiduciary net position. Benefit payments projected after were discounted at the municipal bond rats of 3.69%(based on
the weekly rate closest to but not later than the measurement date of the Fidelity"20-Year Municipal GO AA Index").The resulting
equivalent single discount rate of 5.40%for the PEPFF was determined to give approximately the same present value of projected
benefits when applied to all years of projected benefits as the present value of projected benefits using 6.5%applied to all years of
projected benefits through the point of asset depletion and 3.69%thereafter.
G. 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:
70
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
1%Decrease in 1%Increase in
Discount Rate Discount Rate Discount Rate
Proportionate share of the
GERF net pension liability $ 7,668,696 $ 4,854,980 $ 2,547,299
Proportionate share of the
PEPFF net pension liability 1,165,650 770,234 450,564
H. PENSION PLAN FIDUCIARY NET POSITION
Detailed information about each 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 at www.mnpera.org.
I. PENSION EXPENSE
Pension expense recognized by the City for the fiscal year ended December 31,2022 is as follows:
GERF $ 699,846
PEPFF 96,990
Total $ 796,836
For the governmental activities,pension liabilities are generally liquidated by the General and Special Revenue Funds.
Note 10 DEFINED CONTRIBUTION LUMP SUM SERVICE PENSION PLAN — VOLUNTEER FIREFIGHTERS RELIEF
ASSOCIATION
PLAN DESCRIPTION
Members of the City's volunteer fire department are members of the Andover Firefighters' Relief Association. The Association is the
administrator of a single-employer defined contribution plan available to firefighters that was established October 9, 1979 and operates
under the provisions of Minnesota Statutes Section 424A. It is governed by a board of six members elected by the members of the
Association for three-year terms. The City's Mayor,Finance Manager and Fire Chief are ex-officio members of the Board of Trustees.
The Association provides retirement benefits as well as disability benefits to members,and benefits to survivors upon death of eligible
members.
1. Twenty-Year Service Pension—In order to be entitled to a pension benefit,a firefighter must have completed a minimum of five
years of service with the Department and five years membership in the Association and attain the age of 50 years. The firefighter
will then be 40%vested. This percentage increases 4%per year until the twentieth year when 100%vesting will occur. Because
this is a defined contribution plan,the amount of the retirement benefit is not predetermined,but rather is based on the individual
member's allocable portion of contributions made during the participation period.
2. Deferred Pension—If the retired or terminated member has not attained age 50 and is otherwise eligible for the pension benefit,
the balance of the member's account will be credited with earned interest at the rate permitted by Minnesota Statutes Section
424.A02,Subd.7.
3. Disability Benefit—If a member of the Association becomes totally and permanently disabled due to injury,disability,sickness
or dismemberment as a result of performance of duty,a disability payment will be made after one hundred days of disability.
4. Death Benefit—In the event of death of an active member or deferred pensioner,the member's individual account balance will
be paid to the surviving spouse,surviving children or the estate of the member after approval by the Board.
The Association issues a publicly available financial report that includes financial statements and required supplementary information.
That report may be obtained by writing to Andover Firefighters' Relief Association, 13875 Crosstown Boulevard NW, Andover,
Minnesota 55304.
71
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
FUNDING POLICY
The State of Minnesota contributes amortization aid,or two percent fire aid,in accordance with state statute requirements. Plan members
are not required to contribute to the plan. The state legislature may amend contribution requirements of the City and State. The City is
allowed to make voluntary contributions of other public funds pursuant to Minnesota Statutes Section 424A. The City receives the State
aid contribution and is required by state statutes to pass this through as payment to the Association. This transaction is recorded as
revenue and expenditure in the City's financial statements.Contributions for the last three years are as follows:
Year
Ending City State Total
12/31/2020 $ 55,000 $ 194,699 $ 249,699
12/31/2021 - 202,747 202,747
12/31/2022 41,000 219,669 260,669
Note 11 OTHER POST EMPLOYMENT BENEFITS(OPEB)
A. PLAN DESCRIPTION
In addition to providing the pension benefits described in Note 9, the City provides post-employment health care benefits (as
defined in paragraph B)for retired employees through a single employer defined benefit plan. The tern plan refers to the City's
requirement by State Statute to provide retirees with access to health insurance. The OPEB plan is administered by the City. The
authority to provide these benefits is established in Minnesota Statutes Sections 471.61 Subd. 2a, and 299A.465. The benefits,
benefit levels,employee contributions and employer contributions are governed by the City and can be amended by the City through
its personnel manual and collective bargaining agreements with employee groups. The Plan is not accounted for as a trust fund,as
an irrevocable trust has not been established to account for the plan. The Plan does not issue a separate report.
B. BENEFITS PROVIDED
Retirees
The City is required by State Statute to allow retirees to continue participation in the City's group health insurance plan if the
individual terminates service with the City through service retirement or disability retirement. Employees who satisfy the Rule of
90 or attain age 55 and have completed 10 years of service at termination can immediately commence medical benefits. Retirees
may obtain dependent coverage while the participating retiree is under age 65. Covered spouses may continue coverage after the
retiree's death. The surviving spouse of an active employee may continue coverage in the group health insurance plan after the
employee's death.
All health care coverage is provided through the City's group health insurance plan. The retiree is required to pay 100%of their
premium cost for the City-sponsored group health insurance plan. The premium is a blended rate determined by the entire active
and retiree population. Since the projected claims costs for retirees exceed the blended premium paid by retirees,the retirees are
receiving an implicit rate subsidy(benefit). The coverage levels are the same as those afforded to active employees. Upon a retiree
reaching age 65 years of age,Medicare becomes the primary insurer and the City's plan becomes secondary.
C. PARTICIPANTS
As of the actuarial valuation dated December 2020,participants consisted of:
Retirees and beneficiaries currently
purchasing health insurance through the City 0
Active employees 49
Total 49
Participating employers 1
72
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
D. TOTAL OPEB LIABILITY AND CHANGES IN TOTAL OPEB LIABILITY
The City's total OPEB liability of$488,614 was measured as of December 31,2021 and was determined by an actuarial valuation
using the alternative measurement method as of December 31,2021. Changes in the total OPEB liability during 2022 were:
Balance-beginning of year $ 455,036
Changes for the year:
Service Cost 29,835
Interest 9,589
Changes of benefit terms -
Differences between expected and actual experience -
Changes in assumptions 5,046
Benefit payments (10,892)
Net Changes 33,578
Balance-end of year $ 488,614
For governmental activities,OPEB liabilities are generally liquidated by the General and Special Revenue Funds.
E. ACTUAL ASSUMPTIONS AND OTHER INPUTS
The total OPEB liability in the December 31,2020 actuarial valuation was determined using the following actuarial assumptions
and other inputs,applied to all periods included in the measurement,unless otherwise specified:
Inflation 2.25%
Salary increases 3.00%
Discount rate 1.84%
Investment rate of return 2.00%
Healthcare cost trend rates 6.30%for FY2021,gradually decreasing over several decades to an ultimate rate
of 3.80%in FY2075 and later years.
Retirees'share of benefit-related costs 100%
Since the plan is funded on a pay-as-you-go basis,both the discount rate and the investment rate of return was based an index rate
for 20-year tax-exempt municipal bonds(Fidelity 20-Year Municipal G.O.AA Index).
Mortality rates were based on the RP-2014 mortality tables with projected mortality improvements based on scale MP-2019,and
other adjustments.
Based on past experience of the plan, 75% of future retirees are assumed to continue medical coverage until age 65. 50% of
police/fire employees are assumed to retire at age 55,the balance at 65. 50%of other City employees are assumed to retire at age
62,the balance at age 65.
F. SENSITIVITY OF THE TOTAL OPEB LIABILITY TO CHANGES IN THE DISCOUNT RATE
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%lower(0.84%)or 1%higher(2.84%)than the current rate:
1%Decrease in 1%Increase in
Discount Rate Discount Rate Discount Rate
(0.84%) (1.84%) (2.84%)
Total OPEB liability $ 520,911 $ 488,614 $ 457,613
G. SENSITIVITY OF THE TOTAL OPEB LIABILITY TO CHANGES IN THE HEALTHCARE COST TREND RATES
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%lower or 1%higher than the current rate:
73
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
1%Decrease in 1%Increase in
Healthcare Cost Healthcare Cost Healthcare Cost
Trend Rate Trend Rate Trend Rate
Total OPEB liability $ 439,811 $ 488,614 $ 545,160
H. OPEB EXPENSE AND DEFERRED OUTFLOWS AND INFLOWS OF RESOURCES RELATED TO OPEB
For the year ended December 31,2022,the City recognized S22,724 of OPEB expense. At December 31,2022,the City reported
deferred outflows and inflows of resources related to OPEB from the following sources:
Deferred Outflows Deferred Inflows
of Resources of Resources
Contributions between measurement
date and reporting date $ 21,746 $ -
$21,746 reported as deferred outflows of resources related to OPEB resulting from City contributions subsequent to the
measurement date will be recognized as a reduction of the OPEB liability in the year ended December 31,2023.
Note 12 INTERFUND RECEIVABLES/PAYABLES.LOANS AND TRANSFERS
The City made the following interfund transfers during the year:
Transfer In Transfer Out Amount Purpose
General Fund Water Fund $ 96,091 Admin allocation
General Fund Sewer Fund 79,329 Admin allocation
General Fund Storm Sewer Fund 21,661 Admin allocation
Water Trunk CPF Water Fund 300,000 Replacement reserve
Sewer Trunk CPF Sewer Fund 400,000 Replacement reserve
Road&Bridge CPF Nonmaj or Fund 7,400 Roadway degredation
Water Fund Water Trunk Fund CPF 152,877 Debt service allocation
Nonmajor Fund General Fund 150,000 Concrete median
Nonmajor Fund General Fund 400,000 Pedestrian trail system
Nonmajor Fund Community Center SRF 300,000 Debt service allocation
Nonmajor Fund Water Fund 22,650 Debt service allocation
Nonmajor Fund Sewer Fund 22,650 Debt service allocation
Nonmajor Fund Storm Sewer Fund 23,500 Debt service allocation
Nonmajor Fund Nonmajor Fund 163,143 Debt service allocation
Nonmajor Fund Nonmajor Fund 400,000 Debt service allocation
Nonmajor Fund Nonmajor Fund 84,328 Close Fund
Nonmajor Fund Nonmajor Fund 170,000 Equipment purchases
$ 2,793,629
Additionally,computer service fees paid by the Water,Sewer and Storm Sewer Enterprise Funds to the General Fund have been reclassified
as transfers on the Government-Wide Statement of Activities as follows:
74
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
Transfer In Transfer Out
Governmental Activities $ 30,600 $ -
Business-Type Activities - 30,600
Total S 30,600 $ 30,600
Note 13 TAX INCREMENT DISTRICTS
The City is the administering authority for the following tax increment finance districts:
1 . Name of District: Tax Increment Financing District 1-5
Type of District: Redevelopment
Authorizing Law: M.S. Section469
Established: 2012
Duration of District: Through 2039
Original net tax capacity: $ 6,139
Current net taxcapacity: 92,966
Captured net tax capacity -retained by the City $ 86,827
2 Name of District: Tax Increment Financing District 1-6
Type of District: Redevelopment
Authorizing Law: M.S. Section469
Established: 2014
Duration of District: Through 2024
Original net tax capacity: $ 21,998
Current net tax capacity: 83,576
Captured net tax capacity -retained by the City $ 61,578
Note 14 CONTINGENCIES
A. RISK MANAGEMENT
The City is exposed to various risks of loss related to torts, theft of, damage to and destruction of assets; errors and omissions;
injuries to employees;and natural disasters. The City participates in the League of Minnesota Cities Insurance Trust(LMCIT),a
public entity risk pool for its general property and casualty,workers'compensation,and other miscellaneous insurance coverages.
Workers compensation coverage is provided through a pooled self-insurance program through the LMCIT. The City pays an
annual premium to LMCIT. The City is subject to supplemental assessments if deemed necessary by the LMCIT. The LMCIT
reinsures through Workers Compensation Reinsurance Association (WCRA) as required by law. The City also has a $2,500
deductible per occurrence to further decrease the cost of coverage. Final premiums are determined after an audit of payroll
subsequent to the close of the agreement year and are subject to revisions in rates, payrolls and experience modification. The
amount of premium adjustment,if any,is considered immaterial and not recorded until received or paid.
Property,casualty,and automobile insurance coverage are provided through a pooled self-insurance program through the LMCIT.
The City pays an annual premium to the LMCIT. The LMCIT reinsures through commercial companies for claims in excess of
various amounts. The City retains risk for the deductible portions. These deductibles are considered immaterial to the financial
statements.
The City continues to carry commercial insurance for all other risks of loss,including employee health and disability insurance.
There were no significant reductions in insurance from the previous year or settlements in excess of insurance coverage for any of
the past three fiscal years.
75
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
B. LITIGATION
The City is not aware of any existing or pending lawsuits,claims or other actions in which the City is a defendant.
C. FEDERAL AND STATE FUNDS
The City receives financial assistance from federal and state govemmental agencies in the form of grants. The disbursement of
funds received under these programs generally requires compliance with the terms and conditions specified in the grant agreements
and are subject to audit by the grantor agencies. Any disallowed claims resulting from such audits could become a liability of the
applicable fund. However,in the opinion of management,any such disallowed claims will not have a material effect on any of the
financial statements of the individual fund types included herein or on the overall financial position of the City at December 31,
2022.
D. TAX INCREMENT DISTRICTS
The City's tax increment districts are subject to review by the State of Minnesota Office of the State Auditor (OSA). Any
disallowed claims or misuse of tax increments could become a liability of the applicable fund. Management has indicated that they
are not aware of any instances of noncompliance that would have a material effect on the financial statements.
E. TAX ABATEMENTS-PAY-AS-YOU-GO TAX INCREMENT
The City provides tax abatements pursuant to Minnesota Statutes 469.174 to 469.1794(Tax Increment Financing)through a pay-
as-you-go note program. Tax increment financing(TIF)can be used to encourage private development,redevelopment,renovation
and renewal,growth in low-to-moderate-income housing,and economic development within the City. TIF captures the increase
in tax capacity and property taxes from development or redevelopment to provide funding for the related project.
The City has one tax increment pay-as-you-go agreement. The agreement is not a general obligation of the City and is payable
solely from available tax increment. Accordingly,this agreement is not reflected in the financial statements of the City. Details of
the pay-as-you-go are as follows:
TIF District#1-5,Arbor Oaks Project:
Issued in 2012 in the principal sum of$540,000 with an interest rate of 5.00%per annum. Principal and interest shall be paid
on August 1,2014 and each February and August thereafter to and including February 1,2029. Payments are payable solely
from available tax increment derived from the developed/redeveloped property and paid to the City. The pay-as-you-go note
provides for payment to the developer equal to 90% of all tax increment received in the prior six months. The payment
reimburses the developer for street, utilities, right-of-way,land acquisition, and other public improvements. Principal and
interest payments will be completed February 1,2029. The City shall have no obligation to pay any unpaid balance of principal
or accrued interest that may remain after the final payment on February 1, 2029. The current year abatement (TIF note
payments)amounted to$65,917. At December 31,2022,the principal amount outstanding on the note was$201,922.
Note 15 DEFERRED AD VALOREM TAX LEVIES-BONDED DEBT
General Obligation bond issues sold by the City are financed by ad valorem tax levies and special assessment bond issues sold by the City
are partially financed by ad valorem tax levies in addition to special assessments levied against the benefiting properties. When a bond issue
to be financed partially or completely by ad valorem tax levies is sold, specific annual amounts of such tax levies are stated in the bond
resolution and the County Auditor is notified and instructed to levy these taxes over the appropriate years. The future tax levies are subject
to cancellation when and if the City has provided alternative sources of financing. The City Council is required to levy any additional taxes
found necessary for full payment of principal and interest.
These future scheduled tax levies are not shown as assets in the accompanying financial statements at December 31,2022. Future scheduled
tax levies for all bonds outstanding at December 31,2022 totaled$52,338,526.
76
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
Note 16 FUND BALANCE
A. CLASSIFICATIONS
At December 31,2022,a summary of the governmental fund balance classifications are as follows:
Water 2021 A G.O.
CARPS and Tax Street
Community Grant/ARPA Sewer Road& Increment Reconstruction Other
Center Funding Trunk Bridge Projects Bonds Governmental
General SRF SRF CPF CPF CPF CPF Funds Total
Nonspendable:
Prepaid items $ 35,152 $ - $ - $ - $ - $ - $ - $ 10,000 $ 45,152
Inventory 134,976 134,976
Total nonspendable 170,128 - - - - - - 10,000 180,128
Restricted for:
Debt service - - - - - - - 3,491,233 3,491,233
Street rehabilitation - - - - - - 3,759.521 - 3,759,521
Tax increment 970,460 - - 970,460
Capital improvements - - - - - - - 50,127 50,127
Public services 237.411 237,411
'total restricted 970,460 3,759,521 3,778,771 8,509,752
Committed to:
Economic development - - - - - - - 196,839 196,839
City's mapping system - - - - - - - 182,602 182,602
Surface water mgmt. - - - - - - - 100,887 100,897
Public right ofwaysmgmt. - - - - - - - 102,444 102,444
Seal coating new dev. - - - - - - - 1,452 1,452
Total committed 584,224 584,224
Assigned to:
Water system 8,196,236 - 8,196,236
Sanitary sewer system - - - 8,207,796 - - - - 8,207,796
Street rehabilitation - - - - 11,450,951 - - - 11,450,951
Development purposes - - - - - - - 782,940 782,840
Community center - 1,103,712 - - - - - - 1,103,712
Forest resources programs - - - - - - - 3,248 3,248
Public services - - - - - - - 5,987 5,987
Park improvements - - - - - - - 1,966,548 1,966,543
Facilities management - - - - - - - 694,265 694,265
Pedestrian trails - - 28,849 - - - - 1,026,488 1,055,337
Capital improvements - - - - - - - 1,729,350 1,729,350
Total assigned 1,103,712 28,849 16,404,032 11.450,951 6,208,726 35,196,270
Unassigned 9,794,213 - - - - - - - 9,794,213
Total $ 9.964,341 $ E103,712 S 28,849 $ 16,404.032 $ 11.450,951 $ 970,460 S 3,759,521 $ 10,581,721 $ 54,263,587
B. MINIMUM UNASSIGNED FUND BALANCE POLICY
The City Council has formally adopted a policy regarding the minimum unassigned fund balance for the General Fund. The most
significant revenue source of the General Fund is property taxes. This revenue source is received in two installments during the
year-July and December. As such,it is the City's goal to begin each fiscal year with sufficient working capital to fund operations
between each semi-annual receipt of property taxes.
The policy established a year-end targeted unassigned fund balance amount for cash-flow timing needs in the range of 51-53%of
the subsequent year's budgeted expenditures. At December 31,2022,the unassigned fund balance of the General Fund targeted
for cash-flow needs was 70%of the subsequent year's budgeted expenditures.
77
CITY OF ANDOVER,MINNESOTA
NOTES TO FINANCIAL STATEMENTS
December 31,2022
Note 17 CONDUIT DEBT OBLIGATION
Conduit debt obligations are certain limited-obligation revenue bonds or similar debt instruments issued for the express purpose of providing
capital financing for a specific third party. The City has issued various revenue bonds to provide funding to private-sector entities for projects
deemed to be in the public interest. Although these bonds bear the name of the City,the City has no obligation for such debt beyond the
resources provided by related leases or loans and has not made any commitments to pay the debt. Accordingly,the bonds are not reported
as liabilities in the financial statements of the City.
As of December 31,2022,the following revenue bonds were outstanding:
Date of Original Outstanding
Project Issue Issue Retired 12/31/2022
Presbyterian Homes of Andover,Inc. 11/l/2003 $ 13,145,000 $ (5,911,715) $ 7,233,285
YMCA of the Greater Twin Cities 12/1/2019 6,650,000 (1,830,000) 4,820,000
Note 18 CHANGE IN ACCOUNTING PRINCIPLE
Effective January 1, 2022, the City implemented GASB Statement No. 87, Leases. The statement establishes a single model for lease
accounting based on the principle that leases are financing of a right to use an underlying asset. See Note 4 for further information.
The standards required retroactive implementation for all periods presented in the financial statements. As a result of implementing the
standard,net position and fund balance was restated as follows:
Governmental Community Center
Activities SRF
Net position/fund balance-December 31,2021,as previously reported $ 158,433,554 $ 762,880
Prior period adjustment-effect of implementing GASB Statement No. 87 125,200 125,200
Net position/fund balance-January 1,2022,as restated $ 158,558,754 $ 888,080
Note 19 RECENTLY ISSUED ACCOUNTING STANDARDS
The Governmental Accounting Standards Boards(GASB)recently approved the following statements which were not implemented for these
financial statements:
Statement No. 94 Public-Private and Public-Public Partnerships and Availability Payment Arrangements. The provisions of this
Statement are effective for reporting periods beginning after June 15,2022.
Statement No. 96 Subscription-Based Information Technology Arrangements. The provisions of this Statement are effective for
reporting periods beginning after June 15,2022.
Statement No.99 Omnibus 2022.The provisions of this Statement contain multiple effective dates,the first being for reporting periods
beginning after June 15,2022.
Statement No. 100 Accounting Changes and Error Corrections—an amendment of GASB Statement No. 62. The provisions of this
Statement are effective for reporting periods beginning after June 15,2023.
Statement No. 101 Compensated Absences. The provisions of this Statement are effective for reporting periods beginning after June
15,2023.
The effect these standards may have on future financial statements is not determinable at this time,but it is expected that Statement No. 96
may have a material impact.
78
REQUIRED SUPPLEMENTARY INFORMATION
79
CITY OF ANDOVER,MINNESOTA
REQUIRED SUPPLEMENTARY INFORMATION Statement 9
BUDGETARY COMPARISON SCHEDULE-GENERAL FUND
For The Year Ended December 31,2022
With Comparative Actual Amounts For The Year Ended December 31,2021
Variance with
Final Budget-
Budgeted Amounts 2022 Positive 2021
Original Final Actual (Negative) Actual
Revenues:
General property taxes $ 10,076,370 $ 10,076,370 $ 9,974,141 $ (102,229) $ 9,527,670
Licenses and permits 535,500 535,500 972,879 437,379 891,762
Intergovernmental 817,284 917,431 963,289 45,858 939,174
Charges for services 799,110 799,110 1,295,430 496,320 1,036,929
Fines 50,500 50,500 55,983 5,493 53,747
Investment income 75,000 75,000 (189,494) (264,494) (15,183)
Miscellaneous 148,300 148,300 188,395 40,095 167,318
Total revenues 12,502,064 12,602,211 13,260,623 659,412 12,601,417
Expenditures:
Current:
General government:
Mayor and City council 107,347 107,347 95,366 11,981 95,659
Administration 238,442 256,442 245,223 11,219 229,314
Newsletter 27,300 27,300 24,631 2,669 22,945
Human resources 34,661 34,661 19,906 14,755 20,836
Legal 212,041 212,041 206,399 5,642 199,809
City clerk 185,278 185,278 184,317 961 175,177
Elections 77,188 77,188 75,115 2,073 20,260
Financial administration 337,466 337,466 320,730 16,736 307,009
Assessing 161,000 161,000 131,097 29,903 128,829
Information systems 226,601 226,601 226,589 12 185,642
Planning and zoning 526,669 526,669 490,576 36,093 491,395
Engineering 652,908 652,908 649,664 3,244 594,717
Facility management 717,688 715,688 552,985 162,703 548,747
Total general government 3,504,589 3,520,589 3,222,598 297,991 3,020,339
Public safety:
Police 3,337,486 3,296,486 3,261,423 35,063 3,287,046
Fire protection 1,841,166 1,982,313 1,961,913 20,400 1,698,558
Protective inspection 529,812 529,812 464,559 65,253 519,787
Civil defense 29,003 29,003 12,295 16,708 15,202
Animal control 5,950 5,950 5,164 786 3,517
Total public safety 5,743,417 5,843,564 5,705,354 138,210 5,524,110
Public works:
Streets and highways 868,864 860,864 788,330 72,534 803,391
Snow and ice removal 702,923 702,923 752,396 (49,473) 540,226
Sheet signs 230,094 230,094 194,276 35,818 195,783
Traffic signals 40,000 40,000 28,151 11,849 33,362
Street lighting 220,900 220,900 194,169 26,731 193,374
Total public works $ 2,062,781 $ 2,054,781 $ 1,957,322 $ 97,459 $ 1,766,136
(Continued)
80
CITY OF ANDOVER,MINNESOTA
REQUIRED SUPPLEMENTARY INFORMATION Statement 9
BUDGETARY COMPARISON SCHEDULE-GENERAL FUND (Continued)
For The Year Ended December 31,2022
With Comparative Actual Amounts For The Year Ended December 31,2021
Variance with
Final Budget-
Budgeted Amounts 2022 Positive 2021
Original Final Actual (Negative) Actual
Expenditures:
Current:(continued)
Parks and recreation $ 1,442,397 $ 1,420,897 $ 1,362,086 $ 58,811 $ 1,337,582
Recycling 237,981 237,981 169,169 68,812 239,606
Unallocated 95,928 47,928 17,396 30,532 16,109
Total current 13,087,093 13,125,740 12,433,925 691,815 11,903,882
Capital outlay:
Public safety - - - - 8,317
Public works - - - - 2,000
Parks and recreation 145,000 145,000 135,904 9,096 177,301
Total capital outlay 145,000 145,000 135,904 9,096 187,618
Total expenditures 13,232,093 13,270,740 12,569,829 700,911 12,091,500
Revenues over(under)expenditures (730,029) (668,529) 690,794 1,359,323 509,917
Other financing sources(uses):
Transfers in 197,081 197,081 197,081 - 212,031
Transfers out (150,000) (550,000) (550,000) - (750,000)
Total other financing sources(uses) 47,081 (352,919) (352,919) - (537,969)
Net increase(decrease)in fund balance $ (682,948) $ (1,021,448) 337,875 $ 1,359,323 (28,052)
Fund balance-January 1 9,626,466 9,654,518
Fund balance-December 31 $ 9,964,341 $ 9,626,466
See accompanying notes to the required supplementary information.
81
CITY OF ANDOVER,MINNESOTA
REQUIRED SUPPLEMENTARY INFORMATION Statement 10
BUDGETARY COMPARISON SCHEDULE-COMMUNITY CENTER SPECIAL REVENUE FUND
For The Year Ended December 31,2022
With Comparative Actual Amounts For The Year Ended December 31,2021
Variance with
Final Budget-
Budgeted Amounts 2022 Positive 2021
Original Final Actual (Negative) Actual
Revenues:
General property taxes $ 155,000 $ 155,000 S 154,614 $ (386) $ 154,534
Charges for services 1,112,500 1,112,500 1,238,744 126,244 1,279,384
Investment income - - (21,173) (21,173) 2,817
Miscellaneous:
Rent 638,000 638,000 624,508 (13,492) 635,026
Other 138,000 182,000 239,090 57,090 134,072
Total revenues 2,043,500 2,087,500 2,235,783 148,283 2,205,833
Expenditures:
Current:
Parks and recreation 1,676,968 1,718,969 1,682,793 36,175 1,375,835
Capital outlay:
Parks and recreation 30,000 42,000 37,358 4,642 -
Total expenditures 1,706,968 1,760,968 1,720,151 40,817 1,375,835
Revenue over(under)expenditures 336,532 326,532 515,632 189,100 829,998
Other financing sources(uses)
Transfers out (300,000) (300,000) (300,000) - (300,000)
Net increase(decrease)in fund balance $ 36,532 $ 26,532 215,632 $ 189,100 529,998
Fund balance(deficit)-January 1 888,080 358,082
Fund balance(deficit)-December 31 $ 1,103,712 $ 888,080
82
CITY OF ANDOVER,MINNESOTA
REQUIRED SUPPLEMENTARY INFORMATION Statement 11
BUDGETARY COMPARISON SCHEDULE-CARES GRANT/ARPA FUNDING SPECIAL REVENUE FUND
For The Year Ended December 31,2022
With Comparative Actual Amounts For The Year Ended December 31,2021
Variance with
Final Budget-
Budgeted Amounts 2022 Positive 2021
Original Final Actual (Negative) Actual
Revenues:
Intergovernmental $ 1,753,388 $ 1,953,388 S 1,834,877 $ (118,511) $ 3,166
Investment income - - 15,005 15,005 13,844
Total revenues 1,753,388 1,953,388 1,849,882 (103,506) 17,010
Expenditures:
Current:
Public safety 10,000 10,000 345 9,655 3,166
Public works 1,240,000 1,015,000 1,361,295 (346,295) -
Parks and recreation 50,000 9,000 8,307 693 -
Capital outlay:
Public safety - 200,000 200,000 - -
Parks and recreation - 41,000 40,807 193 -
Construction/acquisition costs - 225,000 224,123 877 -
Total expenditures 1,300,000 1,500,000 1,834,877 (334,877) 3,166
Net increase(decrease)in fund balance $ 453,388 $ 453,388 15,005 $ (438,383) 13,844
Fund balance(deficit)-January 1 13,844 -
Fund balance(deficit)-December 31 $ 28,849 $ 13,844
83
CITY OF ANDOVER,MINNESOTA
REQUIRED SUPPLEMENTARY INFORMATION Statement 12
SCHEDULE OF CHANGES IN THE TOTAL OPEB LIABILITY AND RELATED RATIOS
For the Last Ten Years
2018 2019 2020 2021 2022
Total OPEB liability:
Service cost $ 14,090 $ 16,135 $ 17,068 $ 21,330 $ 29,835
Interest 10,482 10,008 12,944 11,060 9,589
Changes of benefit terms - - - - -
Differences between expected
and actual experience - 28,866 - 62,605 -
Changes in assumptions 11,969 3,219 25,462 (20,807) 5,046
Benefit payments (5,813) (12,311) (12,922) - (10,892)
Net change in total OPEB liability 30,728 45,917 42,552 74,188 33,578
Total OPEB liability-beginning 261,651 292,379 338,296 380,848 455,036
Total OPEB liability-ending $ 292,379 $ 338,296 $ 380,848 $ 455,036 $ 488,614
Covered-employee payroll $ 4,469,146 $ 4,620,961 $ 4,562,782 $ 4,848,511 $ 5,665,943
Total OPEB liability as a percentage of
covered-employee payroll 6.5% 7.3% 8.3% 9.4% 8.6%
See accompanying notes to the required supplementary information.
The schedule is provided prospectively beginning with the City's fiscal year ended December 31,2018 and is intended to
show a ten year trend. Additional years will be added as they become available.
84
CITY OF ANDOVER,MINNESOTA
REQUIRED SUPPLEMENTARY INFORMATION Statement 13
SCHEDULE OF PROPORTIONATE SHARE OF NET PENSION LIABILITY*
GENERAL EMPLOYEES RETIREMENT FUND
For the Last Ten Years
City's
States Proportionate Share City's
Proportionate of the Net Pension Proportionate
City's City's Share(Amount) Liability and the Share of the
Proportionate Proportionate of the Net State's Proportionate Net Pension Plan Fiduciary
Share Share(Amount) Pension Share of the Net Liability as a Net Position as
Measurement Fiscal Year (Percentage)of of the Net Liability Pension Liability Percentage of its a Percentage
Date Ending the Net Pension Pension Associated with Associated with Covered Covered of the Total
June 30 December 31 Liability Liability(a) City(b) City(a+b) Payroll(c) Payroll(a+b/c) Pension Liability
2015 2015 0.0609% $ 3,156,154 $ - $ 3,156,154 $ 3,578,755 88.2% 78.2%
2016 2016 0.0590% 4,790,507 62,597 4,853,104 3,623,880 133.9% 68.9%
2017 2017 0.0594% 3,792,057 47,673 3,839,730 3,825,146 100.4% 75.9%
2018 2018 0.0587% 3,256,435 106,772 3,363,207 3,944,067 85.311,, 79.5%
2019 2019 0.0576% 3,184,575 98,996 3,283,571 4,076,586 80.5°+0 80.2%
2020 2020 0.0583% 3,495,351 107,788 3,603,139 4,156,037 86.7°/,, 79.1%
2021 2021 0.0601% 2,566,539 78,332 2,644,871 4,324,969 61.2°/,, 87.0%
2022 2022 0.0613% 4,854,980 142,340 4,997,320 4,591,680 108.8% 76.7%
See accompanying notes to the required supplementary information.
*The schedule is provided prospectively beginning with the City's fiscal year ended December 31,2015 and is intended to
show a ten year trend. Additional years will be repm-ted as they become available.
85
CITY OF ANDOVER,MINNESOTA
REQUIRED SUPPLEMENTARY INFORMATION Statement 14
SCHEDULE OF PENSION CONTRIBUTIONS*
GENERAL EMPLOYEES RETIREMENT FUND
For the Last Ten Years
Statutorily Contributions in Contribution Contributions as a
Required Relation to the Deficiency Covered Percentage of
Fiscal Year Contribution Statutorily Required (Excess) Payroll Covered
Ending (a) Contribution(b) (a-b) (c) Payroll(b/c)
December 31,2015 $ 268,490 S 268,490 S - S 3,579,867 7.5%
December 31,2016 283,158 283,158 - 3,775,440 7.5%
December 31,2017 284,139 284,139 - 3,788,520 7.5%
December 31,2018 301,507 301,507 - 4,020,093 7.5%
December 31,2019 310,033 310,033 - 4,133,993 7.5%
December 31,2020 317,872 317,872 - 4,238,286 7.5%
December 31,2021 335,268 335,268 - 4,470,240 7.5%
December 31,2022 349,150 349,150 - 4,655,333 7.5%
See accompanying notes to the required supplementary information.
*The schedule is provided prospectively beginning with the City's fiscal year ended December 31,2015 and is intended to
show a ten year trend. Additional years will be reported as they become available.
86
CITY OF ANDOVER,MINNESOTA
REQUIRED SUPPLEMENTARY INFORMATION Statement 15
SCHEDULE OF PROPORTIONATE SHARE OF NET PENSION LIABILITY*
PUBLIC EMPLOYEES POLICE AND FIRE FUND
For the Last Ten Years
Proportionate Proportionate Share Plan Fiduciary
Proportion Share(Amount) of the Net Pension Net Position as
Measurement Fiscal Year (Percentage)of of the Net Liability as a a Percentage
Date Ending the Net Pension Pension Covered Percentage of its of the Total
June 30 December 31 Liability Liability(a) Payroll(b) Covered Payroll(a/b) Pension Liability
2015 2015 0.0210% $ 238,609 $ 194,274 122.8% 86.6%
2016 2016 0.0280% 1,123,689 283,389 396.5% 63.9%
2017 2017 0.0280% 378,033 287,895 131.3% 85.4%
2018 2018 0.0267% 284,595 281,901 101.0% 88.8%
2019 2019 0.0272% 289,571 287,498 100.7% 89.3%
2020 2020 0.0205% 270,212 232,475 116.2% 87.2%
2021 2021 0.0162% 125,047 190,876 65.5% 93.7%
2022 2022 0.0177% 770,234 214,865 358.5% 70.5%
See accompanying notes to the required supplementary information.
*The schedule is provided prospectively beginning with the City's fiscal year ended December 31,2015 and is intended to
show a ten year trend. Additional years will be reported as they become available.
87
CITY OF ANDOVER,MINNESOTA
REQUIRED SUPPLEMENTARY INFORMATION Statement 16
SCHEDULE OF PENSION CONTRIBUTIONS*
PUBLIC EMPLOYEES POLICE AND FIRE FUND
For the Last Ten Years
Statutorily Contributions in Contribution Contributions as a
Required Relation to the Deficiency Covered Percentage of
Fiscal Year Contribution Statutorily Required (Excess) Payroll Covered
Ending (a) Contribution(b) (a-b) (c) Payroll(b/c)
December 31,2015 $ 38,121 $ 38,121 $ - S 235,315 16.2%
December 31,2016 45,909 45,909 - 283,389 16.2%
December 31,2017 45,604 45,604 - 281,506 16.2%
December 31,2018 46,365 46,365 - 286,204 16.2%
December 31,2019 46,269 46,269 - 272,993 16.9%
December 31,2020 34,168 34,168 - 193,040 17.7%
December 31,2021 35,706 35,706 - 201,729 17.7%
December 31,2022 47,226 47,226 - 266,814 17.7%
See accompanying notes to the required supplementary information.
*The schedule is provided prospectively beginning with the City's fiscal year ended December 31,2015 and is intended to
show a ten year trend. Additional years will be reported as they become available.
88
CITY OF ANDOVER,MINNESOTA
REQUIRED SUPPLEMENTARY INFORMATION
NOTES TO REQUIRED SUPPLEMENTARY INFORMATION
December 31,2022
Note A BUDGETS
The General Fund budget is legally adopted on a basis consistent with accounting principles generally accepted in the United States of
America. The legal level of budgetary control is at the departmental level for the General Fund. The following is a listing of General
Fund departments whose expenditures exceed budget appropriations.
Final Over
Budget Actual Budget
General Fund:
Current:
Public Works:
Snow and ice removal S 702,923 S 752,396 $ 49,473
Note B MODIFIED APPROACH FOR CITY STREETS AND TRAILS INFRASTRUCTURE CAPITAL ASSETS
In accordance with GASB Statement No.34,the City is required to account for and report infrastructure capital assets. The City defines
infrastructure as the basic physical assets including the street and trail system; water treatment and distribution system; wastewater
collection system;park and recreation lands and improvement system; storm water conveyance system;and building combined with site
amenities such as parking and landscape areas used by the City in the conduct of its business. Each major infrastructure can be divided
into subsystems. For example,the street and trail system can be divided into pavement widths,curb type and sidewalk. City owned streets
could further be classified as collector or local. Subsystem detail is not presented in these basic financial statements;however, the City
maintains detailed information on these subsystems.
The City has elected to use the modified approach as defined in GASB Statement No. 34 for infrastructure reporting for its Pavement
Management Program. Under GASB Statement No. 34,eligible infrastructure capital assets are not required to be depreciated under the
following requirements:
1) The City manages the eligible infrastructure capital assets using an asset management system with characteristics of(1)an up to-
date inventory;(2)perform condition assessments and summarize the results using a measurement scale;and(3)estimate annual
amount to maintain and preserve at the established condition assessment level.
2) The City documents that the eligible infrastructure capital assets are being preserved approximately at or above the established
and disclosed condition assessment level.
The City's policy relative to maintaining the street and trail assets is to achieve an average rating of"Good" for all segments. This
acceptable rating allows minor cracking and patching of the pavement along with minor roughness that could be noticeable to the users of
the system.
In the fall of 2022,the City conducted a physical condition assessment of the streets and trails constructed since 1974. This assessment
will be performed every three years. Each street and trail segment was assigned a physical condition based on potential defects. An Overall
Condition Index(OCI) was assigned to each street and trail and expressed in a continuous scale. The continuous scale is from 0 to 10,
where 0 is assigned to the least acceptable physical condition and 10 is assigned the physical characteristics of a new street or trail. The
following conditions were defined:
Rating
Condition Scale
Excellent 8- 10
Very Good 7-7.9
Good 6-6.9
Fair 4-5.9
Poor 2-3.9
Very Poor 1 - 1.9
Substandard 0-.9
As of December 31,2022,the City's street and trail system was rated at an OCI index of 6.0 on the average with detail condition as follows:
89
CITY OF ANDOVER,MINNESOTA
REQUIRED SUPPLEMENTARY INFORMATION
NOTES TO REQUIRED SUPPLEMENTARY INFORMATION
December 31,2022
%of Street
Condition and Trails
Excellent to Good 70.5%
Fair 20.8%
Poor to Substandard 8.7%
The City's streets and trails are constantly deteriorating resulting from the following factors:(1)traffic using the system;(2)the sun's ultra-
violet rays drying out and breaking down the top layer of pavement; (3)utility company/private development trenching operations; (4)
water damage from natural precipitation; and(5) frost heave. The City is continuously taking actions to prolong the life of the system
through short-term maintenance activities such as pothole patching, crack sealing, seal coating and overlaying. The City expended
$4,159,982 on street and trail maintenance for the year ending December 31,2022. These expenditures delayed deterioration;however,
the overall condition of the system was not improved through these maintenance expenditures. The City has estimated that the amount of
annual expenditures required to maintain the City's street and trail system at the average OCI rating of good is approximately$2,750,000.
Maintenance Actual OCI
Year Estimate Expenditures Rating
2013 $1,150,000 $ 2,471,123 6.9
2014 1,150,000 2,029,026 6.7
2015 1,150,000 1,114,900 6.7
2016 1,150,000 1,585,756 6.3
2017 1,150,000 3,548,327 6.4
2018 1,150,000 2,274,146 6.4
2019 1,150,000 3,701,063 5.3
2020 1,150,000 2,667,008 5.4
2021 2,500,000 2,160,714 5.9
2022 2,750,000 4,159,982 6.0
The City has an on-going street and trail rehabilitation program funded in the Capital Improvement Program that is intended to improve
the condition rating of the City streets and trails. The rehabilitation program is formulated based on the deficiencies identified as a part of
its Pavement Management Program.
Note C OPEB INFORMATION
No assets are accumulated in a trust that meets the criteria in paragraph 4 of GASB Statement No.75 to pay related benefits. There are no
factors that affect trends in the amounts reported,such as changes in benefit terms or assumptions.
Note D PENSION INFORMATION
PERA—General Employees Retirement Fund
2022 Changes in Actuarial Assumptions:
• The mortality improvement scale was changed from Scale MP-2020 to Scale MP-2021.
2021 Changes in Actuarial Assumptions:
• The investment return and single discount rates were changed from 7.50%to 6.50%for financial reporting purposes.
• The mortality improvement scale was changed from Scale MP-2019 to Scale MP-2020.
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%.
• As recommended in the June 30,2019 experience study,assumed salary increase rates were decreased 0.25%and assiuned
rates of retirement were changed resulting in more unreduced(normal)retirements and slightly fewer Rule of 90 and early
retirements. Assumed rates of termination and disability were also changed.
• The base mortality tables were changed from RP-2014 to Pub-2010 tables,with adjustments.
90
CITY OF ANDOVER,MINNESOTA
REQUIRED SUPPLEMENTARY INFORMATION
NOTES TO REQUIRED SUPPLEMENTARY INFORMATION
December 31,2022
• 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 100% Joint& Survivor option changed from 15%to 30%.
The corresponding number of married new retirees electing the Life annuity option was adjusted accordingly.
2020 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.
2019 Changes in Actuarial Assumptions:
• The mortality projection scale was changed from MP-2017 to MP-2018.
2019 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 Assumptions:
• The mortality projection scale was changed from MP-2015 to MP-2017.
• The assumed benefit increase was changed from 1.0 percent per year through 2044 and 2.5 percent per year thereafter to
1.25 percent per year.
2017 Changes in Actuarial Assumptions:
• The Combined Service Annuity(CSA)loads were changed from 0.8 percent for active members and 60 percent for vested
and non-vested members. The revised CSA loads are now 0.0 percent for active member liability, 15.0 percent for vested
deferred member liability and 3.0 percent for non-vested deferred member liability.
• The assumed post-retirement benefit increase rate was changed from 1.0%per year for all years to 1.0%per year through
2044 and 2.5 percent per year thereafter.
2016 Changes in Actuarial Assumptions:
• The assumed post-retirement benefit increase rate was changed from 1.0% per year through 2035 and 2.5% per year
thereafter to 1.0%per year for all future years.
• The assumed investment return was changed from 7.9%to 7.5%. The single discount rate was changed from 7.9%to 7.5%.
• Other assumptions were changed pursuant to the experience study dated June 30,2015. The assumed future salary increases,
payroll growth,and inflation were decreased by 0.25%to 3.25%for payroll growth and 2.5%for inflation.
PERA-Public Employees Police and Fire
2022 Changes in Actuarial Assumptions:
• The single discount rate was changed from 6.50%to 5.40%.
• The mortality improvement scale was changed from Scale MP-2020 to Scale MP-2021.
2021 Changes in Actuarial Assumptions:
• The investment return and single discount rates were changed from 7.50%to 6.50%for financial reporting purposes.
• The inflation assumption was changed from 2.50%to 2.25%.
• The payroll growth assumption was changed from 3.25%to 3.00%.
• The base mortality tables for healthy annuitants,disabled annuitants and employees were changed from RP-2014 tables to
Pub-2010 Public Safety Mortality tables. The mortality improvement scale was changed from MP-2019 to MN-2020.
• Assumed salary increase and retirement rates were modified as recommended in the July 14,2020 experience study. The
changes result in a decrease in gross salary increase rates, slightly more unreduced retirements and fewer assumed early
retirements.
• Assumed rates of withdrawal were changed from select and ultimate rates to service-based rates.The changes result in more
assumed terminations.
• Assumed rates of disability were increased for ages 25-44 and decreased for ages over 49. Overall,proposed rates result in
more projected disabilities.
• Assumed percent married for active female members was changed from 60%to 70%.
91
CITY OF ANDOVER,MINNESOTA
REQUIRED SUPPLEMENTARY INFORMATION
NOTES TO REQUIRED SUPPLEMENTARY INFORMATION
December 31,2022
2020 Changes in Actuarial Assumptions:
• The mortality projection scale was changed from MP-2018 to MP-2019.
2019 Changes in Actuarial Assumptions:
• The mortality projection scale was changed from MP-2017 to MP-2018.
2019 Changes in Plan Provisions:
• There have been no changes since the prior valuation.
2018 Changes in Actuarial Assumptions:
• The mortality projection scale was changed from MP-2016 to MP-2017.
2017 Changes in Actuarial Assumptions:
• The single discount rate was changed from 5.6 percent to 7.5 percent.
• Assumed salary increases were changed as recommended in the June 30,2016 experience study. The net effect is proposed
rates that average 0.34 percent lower than the previous rates.
• Assumed rates of retirement were changed,resulting in fewer retirements.
• The Combined Service Annuity (CSA) load was 30 percent for vested and non-vested deferred members. The CSA has
been changed to 33 percent for vested members and 2 percent for non-vested members.
• The base mortality table for healthy annuitants was changed from the RP-2000 fully generational table to the RP-2014 fully
generational table(with a base year of 2006),with male rates adjusted by a factor of 0.96. The mortality improvement scale
was changed from Scale AA to Scale MP-2016. The base mortality table for disabled annuitants was changed from the RP-
2000 disabled mortality table to the mortality tables assumed for healthy retirees.
• Assumed termination rates were decreased to 3.0 percent for the first three years of service. Rates beyond the select period
of three years were adjusted,resulting in more expected terminations overall.
• Assumed percentage of married female members was decreased from 65 percent to 60 percent.
• Assumed age difference was changed from separate assumptions for male members (wives assumed to be three years
younger)and female members(husbands assumed to be four years older)to the assumption that males are two years older
than females.
• The assumed percentage of female members electing Joint and Survivor annuities was increased.
• The assumed post-retirement benefit increase rate was changed from 1.00 percent for all years to 1.00 percent per year
through 2064 and 2.5 percent thereafter.
2016 Changes in Actuarial Assumptions:
• The assumed post-retirement benefit increase rate was changed from 1.0% per year through 2037 and 2.5% per year
thereafter to 1.0%per year for all future years.
• The assumed investment return was changed from 7.9%to 7.5%. The single discount rate was changed from 7.9%to 5.6%.
• The assumed future salary increases,payroll growth,and inflation were decreased by 0.25%to 3.25%for payroll growth
and 2.5%for inflation.
92
COMBINING AND INDIVIDUAL FUND STATEMENTS AND SCHEDULES
93
NONMAJOR GOVERNMENTAL FUNDS
SPECIAL REVENUE FUNDS
A Special Revenue Fund is used to account for the proceeds of specific revenue sources that are legally restricted to
expenditures for specified purposes. Revenues for these funds can come from a variety of sources,such as taxes,fees,
gifts and grants or contributions from other governmental entities. Expenditures from these funds are normally
restricted by statute, local ordinance or grant agreements. The funds may be used for either operations or capital
outlay as legal restrictions mandate.
DEBT SERVICE FUNDS
A Debt Service Fund accounts for the accumulation of resources for,and the payment of general long-term principal,
interest and other related costs.
CAPITAL PROJECTS FUNDS
A Capital Projects Fund is used to account for acquisition or construction of major capital facilities financed mainly
with governmental fund resources, general obligation debt, special assessments, special assessment debt, grants or
other resources that are not part of Proprietary Funds or Trust Funds.
94
CITY OF ANDOVER,MINNESOTA
COMBINING BALANCE SHEET Statement 17
NONMAJOR GOVERNMENTAL FUNDS
December 31,2022
With Comparative Totals For December 31,2021
Totals
Special Debt Capital Nonmajor Governmental Funds
Revenue Service Projects 2022 2021
Assets:
Cash and investments $ 943,190 $ 3,435,767 $ 6,150,735 $ 10,529,692 $10,005,128
Accrued interest 4,024 8,231 26,822 39,077 18,229
Due from other governmental units 5,950 - 101,562 107,512 -
Accounts receivable-net 15,921 - 5,929 21,850 106,951
Prepaid items 10,000 - - 10,000 16,000
Property taxes receivable:
Unremitted 551 47,235 8,270 56,056 46,810
Delinquent 449 26,115 5,835 32,399 38,310
Special assessments receivable:
Deferred - - 90,904 90,904 93,415
Inventories-at cost - - - - 1,920
Total assets $ 980,085 $ 3,517,349 $ 6,390,057 $ 10,887,490 $10,326,763
Liabilities,Deferred Inflows of Resources and Fund Balances
Liabilities:
Accounts payable $ 7,730 $ - $ 14,266 $ 21,996 $ 74,256
Contracts payable - - - - 20,882
Deposits payable - - 24,465 24,465 79,787
Due to other governmental units 51,608 - 4,969 56,577 11,574
Salaries payable 1,171 - - 1,171 29,268
Unearned revenue 78,257 - - 78,257 102,064
Total liabilities 138,766 - 43,700 182,466 317,831
Deferred inflows of resources:
Unavailable revenues 449 26,115 96,739 123,303 131,725
Fund balance(deficit):
Nonspendable 10,000 - - 10,000 17,920
Restricted 237,411 3,491,233 50,127 3,778,771 3,430,147
Committed 584,224 - - 584,224 499,284
Assigned 9,235 - 6,199,491 6,208,726 5,929,856
Total fund balance(deficit) 840,870 3,491,233 6,249,618 10,581,721 9,877,207
Total liabilities,deferred inflows of
resources,and fund balances(deficit) $ 980,085 $ 3,517,348 $ 6,390,057 $ 10,887,490 $ 10,326,763
95
CITY OF ANDOVER,MINNESOTA
COMBINING STATEMENT OF REVENUES,EXPENDITURES AND Statement 18
CHANGES IN FUND BALANCES
NONMAJOR GOVERNMENTAL FUNDS
For The Year Ended December 31,2022
With Comparative Totals For The Year Ended December 31,2021
Totals
Special Debt Capital Nonmajor Governmental Funds
Revenue Service Projects 2022 2021
Revenues:
General property taxes $ 39,873 $ 3,738,045 $ 641,959 $ 4,419,877 $ 3,948,410
Intergovernmental 5,950 - 160,829 166,779 11,224
Special assessments - - 3,525 3,525 3,569
Charges for services 112,241 - - 112,241 1,231,389
Investment income (20,540) (50,825) (160,614) (231,979) (8,073)
Miscellaneous:
Park dedication fees - - 1,360,540 1,360,540 622,680
Rent - - - - 635,026
Other 112,870 - 383,098 495,968 476,429
Total revenues 250,394 3,687,220 2,389,337 6,326,951 6,920,654
Expenditures:
Current:
General government 81,543 - 186,275 267,818 182,715
Public safety - - 60,263 60,263 5,728
Public works 89,669 - 2,039 91,708 102,297
Parks and recreation - - 180,064 180,064 1,462,250
Economic development 87,035 - - 87,035 38,851
Capital outlay:
General government - - 296,850 296,850 197,071
Public safety - - 384,126 384,126 743,724
Public works - - 543,654 543,654 79,261
Parks and recreation - - 589,161 589,161 389,243
Economic development 27,618 - - 27,618 -
Debt service:
Principal retirement - 2,110,000 - 2,110,000 1,899,000
Interest - 1,291,283 - 1,291,283 1,278,030
Paying agent fees - 5,200 - 5,200 5,500
Total expenditures 285,865 3,406,483 2,242,432 5,934,780 6,383,670
Revenues over(under)expenditures (35,471) 280,737 146,905 392,171 536,984
Other financing sources(uses):
Transfers in 150,000 908,443 677,828 1,736,271 612,091
Transfers out (7,400) (254,328) (563,143) (824,871) (548,291)
Bonds issued - - - - 630,000
Bond premium - - - - 21,663
Proceeds from sale of capital assets - - 163.823 163,823 18,800
Total other financing sources(uses) 142,600 654,115 278,508 1,075,223 734,263
Net increase(decrease)in fund balance 107,129 934,852 425,413 1,467,394 1,271,247
Fund balance-January 1 733,741 2,556,381 5,824,205 9,114,327 8,605,960
Fund balance-December 31 $ 840,870 $ 3,491,233 $ 6,249,618 $ 10,581,721 $ 9,877,207
Reconciliation of beginning find balance to prior year ending funding balance:
Prior year ending fund balance reported above $ 9,877,207
Fund balance of Community Center fund reported as nonmajor in
prior year,major in current year (762,880)
Current year beginning fund balance $ 9,114,327
96
NONMAJOR SPECIAL REVENUE FUNDS
The City of Andover had the following Special Revenue Funds during the year:
EDA General-This fund was established to account for activities designed to promote quality economic development
within the community.
Drainage and Mapping- This fund accounts for resources necessary to maintain existing maps and developing new
maps and mapping systems for the City.
LRRWMO - This fund is used to account for the City's involvement with the Lower Rum River Watershed
Management Organization(LRRWMO).
Fores -This fund was established to account for the protection of forest resources and the development of control
plans to ensure preservation or restoration of these resources.
Right-of-Way Management/Utility-This fund is used to account for activity associated with the management of the
public right-of-ways.
Charitable Gambling-This fund accounts for the 10%of net profits received from gambling activities by local non-
profit organizations. According to state statute,all expenditures from this fund must be for public services and police,
fire and other emergency or public safety-related services,equipment,and training,excluding pension obligations.
Construction Seal Coating-This fund accounts for the contributions associated with land development to be used for
the respective developments first application of crack seal and seal coat.
97
CITY OF ANDOVER,MINNESOTA
SUBCOMBINING BALANCE SHEET
NONMAJOR SPECIAL REVENUE FUNDS
December 31,2022
With Comparative Totals For December 31,2021
Drainage
EDA and
General Mapping LRRWMO Forestry
Assets:
Cash and investments $ 235,920 S 182,144 $ 100,430 S 3,248
Accrued interest 961 779 372 -
Due from other governmental units - - - 5,950
Accounts receivable-net 13,130 - - -
Prepaid items - - - -
Property taxes receivable:
Unremitted - - 551 -
Delinquent - - 449 -
Inventories-at cost - - - -
Total assets $ 250,011 $ 182,923 $ 101,802 $ 9,198
Liabilities,Deferred Inflows of Resources and Fund Balances
Liabilities:
Accounts payable $ 1,526 $ 34 $ 172 $ 5,950
Deposits payable - - - -
Due to other governmental units 51,608 - - -
Salaries payable 38 287 294 -
Unearned revenue - - - -
Total liabilities 53,172 321 466 5,950
Deferred inflows of resources:
Unavailable revenues - - 449 -
Fund balance(deficit):
Nonspendable - - - -
Restricted - - - -
Committed 196,839 182,602 100,887 -
Assigned - - - 3,248
Total fund balance(deficit) 196,839 182,602 100,887 3,248
Total liabilities,deferred inflows of
resources,and fund balances(deficit) $ 250,011 $ 182,923 $ 101,802 $ 9,198
98
Statement 19
Right-of-Way Totals
Management/ Charitable Construction Nonmajor Special Revenue Funds
Utility Gambling Seal Coating 2022 2021
$ 99,837 $ 242,407 $ 79,204 $ 943,190 $ 1,635,269
416 991 505 4,024 3,179
- - - 5,950 -
2,791 - - 15,921 106,951
- 10,000 - 10,000 16,000
- - - 551 2,444
- - - 449 2,028
- - - - 1,920
$ 103,044 $ 253,398 $ 79,709 $ 980,085 $ 1,767,791
$ 48 $ - $ - $ 7,730 $ 70,051
- - - - 63,675
- - - 51,608 4,084
552 - - 1,171 29,268
- - 78,257 78,257 102,064
600 - 78,257 138,766 269,142
- - - 449 2,028
- 10,000 - 10,000 17,920
- 237,411 - 237,411 201,037
102,444 - 1,452 584,224 499,284
- 5,987 - 9,235 778,380
102.444 253,398 1,452 840,870 1,496,621
$ 103,044 $ 253,398 $ 79,709 $ 980,085 $ 1,767,791
99
CITY OF ANDOVER,MINNESOTA
SUBCOMBINING STATEMENT OF REVENUES, EXPENDITURES
AND CHANGES IN FUND BALANCES
NONMAJOR SPECIAL REVENUE FUNDS
For The Year Ended December 31,2022
With Comparative Totals For The Year Ended December 31,2021
2110 2210 2220 2230
Drainage
EDA and
General Mapping LRRWMO Forestry
Revenues:
General property taxes $ - $ - $ 39,873 $ -
Intergovernmental - - - 5,950
Charges for services 22,447 27,546 - -
Investment income (5,432) (4,913) (2,019) (256)
Miscellaneous:
Rent - - - -
Other 953 - - -
Total revenues 17,968 22,633 37,854 5,694
Expenditures:
Current:
General government - - - -
Public works - 18,883 22,751 7,836
Parks and recreation - - - -
Economic development 87,035 - - -
Capital outlay:
Economic development 27,618 - - -
Total expenditures 114,653 18,883 22,751 7,836
Revenues over(under)expenditures (96,685) 3,750 15,103 (2,142)
Other financing sources(uses):
Transfers in 150,000 - - -
Transfers out - - - -
Total other financing sources(uses) 150,000 - - -
Net increase(decrease)in fund balance 53,315 3,750 15,103 (2,142)
Fund balance(deficit)-January 1 143,524 178,852 85,784 5,390
Fund balance(deficit)-December 31 $ 196,839 $ 182,602 $ 100,887 $ 3,248
Reconciliation of beginning fund balance to prior year ending funding balance:
Prior year ending fund balance reported above
Fund balance of Community Center fund reported as nonmajor in
prior year,major in current year
Current year beginning fund balance
100
Statement 20
2250 2320 2410
Right-of-Way Totals
Management/ Charitable Construction Nonmajor Special Revenue Funds
Utility Gambling Seal Coating 2022 2021
39,873 $ 194,718
- - - 5,950 -
49,284 - 12,964 112,241 1,231,389
(2,605) (6,043) 728 (20,540) 1,603
- - - - 635,026
- 111,917 - 112,870 275,896
46,679 105,874 13,692 250,394 2,338,632
- 81,543 - 81,543 47,860
22,802 - 17,397 89,669 82,382
- - - - 1,375,835
- - - 87,035 38,851
- - - 27,618 -
22,802 81,543 17,397 285,865 1,544,928
23,877 24,331 (3,705) (35,471) 793,704
- - - 150,000 -
(7,400) - - (7,400) (305,000)
(7,400) - - 142,600 (305,000)
16,477 24,331 (3,705) 107,129 488,704
85,967 229,067 5,157 733,741 1,007,917
$ 102,444 $ 253,398 $ 1,452 $ 840,870 $ 1,496,621
$ 1,496,621
(762,880)
$ 733,741
101
-This page intentionally left blank-
102
NONMAJOR DEBT SERVICE FUNDS
The City's Debt Service Funds account for four types of bonded indebtedness:
• Certificates of Indebtedness
• Capital Improvement Bonds
• Abatement Bonds
• Referendum Bonds
Certificates of Indebtedness - (G.O. Equipment Certificates - 2020A and 2021A) are repaid primarily from general
property taxes.
Capital Improvement Plan Bonds — (G.O. Capital Improvement Plan Bonds of 2018A) are repaid primarily from
general property taxes.
Abatement Bonds - (G.O. Abatement Bonds of 2012C and 2019A) are repaid from annual lease payments from the
YMCA,Community Center operations and general property tax.
Street Reconstruction Bonds — (G.O. Street Reconstruction Bonds of 2021A) are repaid primarily from general
property taxes.
Referendum Bonds—(Open Space Referendum Bonds of 2010A) are used to finance the purchase of land to remain
as open space.
103
CITY OF ANDOVER,MINNESOTA
SUBCOMBINING BALANCE SHEET
NONMAJOR DEBT SERVICE FUNDS
December 31,2022
With Comparative Totals For December 31,2021
G.O.
G.O. G.O. Capital G.O.
Equipment Equipment Improvement Abatement
Certificate Certificate Plan Bonds Bonds
2020A 2021A 2018A 2012C
Assets:
Cash and investments $ 383,102 $ 156,491 $ 540,414 $ 473,248
Accrued interest 991 376 1,248 358
Property taxes receivable:
Unremitted 4,721 2,141 7,776 12,273
Delinquent 2,610 1,184 4,299 6,785
Total assets $ 391,424 $ 160,192 $ 553,737 $ 492,664
Deferred Inflows of Resources and Fund Balances
Deferred inflows of resources:
Unavailable revenues $ 2,610 $ 1,184 4,299 $ 6,785
Fund balance(deficit):
Restricted 388,814 159,008 549,438 485,879
Total deferred inflows of resources,and
and fund balances(deficit) $ 391,424 $ 160,192 $ 553,737 $ 492,664
104
Statement 21
G.O.
G.O. Street
Abatement Reconstruction Totals
Bonds Bonds Nonmajor Debt Service Funds
2019A 2021A 2022 2021
$ 990,394 $ 902,118 $ 3,435,767 $ 2,516,818
2,444 2,914 8,231 2,601
12,769 7,555 47,235 36,962
7,060 4,177 26,115 29,670
$ 1,002,667 $ 916,664 $ 3,517,348 $ 2,586,051
$ 7,060 4,177 $ 26,115 $ 29,670
995,607 912,487 3,491,233 2,556,381
$ 1,002,667 $ 916,664 $ 3,517,348 $ 2,586,051
105
CITY OF ANDOVER,MINNESOTA
SUBCOMBINING STATEMENT OF REVENUES, EXPENDITURES AND
CHANGES IN FUND BALANCES
NONMAJOR DEBT SERVICE FUNDS
For The Year Ended December 31,2022
With Comparative Totals For The Year Elided December 31,2021
G.O.
G.O. G.O. Capital G.O.
Equipment Equipment Improvement Abatement
Certificate Certificate Plan Bonds Bonds
2020A 2021A 2018A 2012C
Revenues:
General property taxes S 373,549 S 169,410 S 615,376 S 971,246
Investment income (6,529) (2,601) (7,736) (2,779)
Total revenues 367,020 166,809 607,640 968,467
Expenditures:
Debt service:
Principal retirement 320,000 - 130,000 945,000
Interest 33,400 7,455 344,507 268,932
Paying agent fees 1,025 525 1,025 1,025
Total expenditures 354,425 7,980 475,532 1,214,957
Revenues over(under)expenditures 12,595 158,829 132,108 (246,490)
Other financing sources(uses):
Transfers in - - 45,300 300,000
Transfers out - (170,000) - -
Total other financing sources(uses) - (170,000) 45,300 300,000
Net increase(decrease)in fund balance 12,595 (11,171) 177,408 53,510
Fund balance-January 1 376,219 170,179 372,030 432,369
Fund balance-December 31 S 388,814 $ 159,009 S 549,438 $ 485,879
106
Statement 22
G.O.
G.O. Street Open Space
Abatement Reconstruction Referendum Totals
Bonds Bonds Bonds Nonmajor Debt Service Funds
2019A 2021A 2010A 2022 2021
$ 1,010,546 $ 597,918 $ - S 3,738,045 S 3,133,512
(15,831) (15,349) - (50,825) (1,694)
994,715 582,569 - 3,687,220 3,131,818
545,000 - 170,000 2,110,000 1,899,000
564,776 69,557 2,656 1,291,283 1,278,030
1,075 525 - 5,200 5,500
1,110,851 70,082 172,656 3,406,483 3,182,530
(116,136) 512,487 (172,656) 280,737 (50,712)
163,143 400,000 - 908,443 547,904
- - (84,328) (254,328) (40,687)
163,143 400,000 (84,328) 654,115 507,217
47,007 912,487 (256,984) 934,852 456,505
948,600 - 256,984 2,556,391 2,099,876
$ 995,607 $ 912,497 $ - S 3,491,233 $ 2,556,381
107
-This page intentionally left blank-
108
NONMAJOR CAPITAL PROJECTS FUNDS
The City of Andover had the following Capital Projects Funds during the year:
Park Dedication-This fund was established to account for contributions associated with land development to be used
for constructing and upgrading the City's park system.
Building Fund-This fund was established to account for miscellaneous building improvements for all facilities.
Trail and Transportation-This fund is used to account for contributions associated with land development to be used
for constructing and upgrading the City's trail system.
Capital Equipment Reserve - This fund is used to account for the capital equipment/projects levy and the various
capital expenditures it will be used for.
Equipment Certificates 2021A-This fund was established to account for the purchase of capital equipment that was
financed through the issuance of capital notes.
2018A G.O.Capital Improvement Plan Bonds—This fund accounts for the construction of a new vehicle maintenance
facility with a wash bay and a cold storage building.
rooms.
Permanent Improvement Revolving- This fund serves as a long-term funding source for large capital improvement
expenditures.
109
CITY OF ANDOVER,MINNESOTA
SUBCOMBINING BALANCE SHEET
NONMAJOR CAPITAL PROJECTS FUNDS
December 31,2022
With Comparative Totals For December 31,2021
Capital
Park Building Trail& Equipment
Dedication Fund Transportation Reserve
Assets:
Cash and investments $ 1,957,920 $ 686,869 $ 1,022,663 $ 1,640,026
Accrued interest 8,439 2,871 4,140 8,012
Due from other governmental units - - - 101,562
Accounts receivable-net - - - 5,929
Property taxes receivable:
Unremitted 189 4,525 - 3,556
Delinquent 125 3,010 - 2,700
Special assessments receivable:
Deferred - - - -
Total assets $ 1,966,673 $ 697,275 $ 1,026,803 $ 1,761,785
Liabilities,Deferred Inflows of Resources and Fund Balances
Liabilities:
Accounts payable $ - $ - $ 315 $ 301
Contracts payable - - - -
Deposits payable - - - 24,465
Due to other government units - - - 4,969
Total liabilities - - 315 29,735
Deferred inflows of resources:
Unavailable revenues 125 3,010 - 2,700
Fund balance(deficit):
Restricted - - - -
Assigned 1,966,548 694,265 1,026,488 1,729,350
Total fund balance(deficit) 1,966,548 694,265 1,026,488 1,729,350
Total liabilities,deferred inflows of
resources,and fund balances(deficit) $ 1,966,673 $ 697,275 $ 1,026,803 $ 1,761,785
110
Statement 23
Equipment Permanent Totals
Certificates Improvement Nonmajor Capital Projects Funds
2021A Revolving 2022 2021
$ 63,777 $ 779,480 $ 6,150,735 $ 5,853,041
- 3,360 26,822 12,449
- - 101,562 -
- - 5,929 -
- - 8,270 7,404
- - 5,835 6,612
- 90,904 90,904 93,415
$ 63,777 $ 873,744 $ 6,390,057 $ 5,972,921
$ 13,650 $ - $ 14,266 $ 4,205
- - - 20,882
- - 24,465 16,112
- - 4,969 7,490
13,650 - 43,700 48,689
- 90,904 96,739 100,027
50,127 - 50,127 672,729
- 782,940 6,199,491 5,151,476
50,127 782,840 6,249,618 5,824,205
$ 63,777 $ 873,744 $ 6,390,057 $ 5,972,921
111
CITY OF ANDOVER,MINNESOTA
SUBCOMBINING STATEMENT OF REVENUES, EXPENDITURES AND
CHANGES IN FUND BALANCES
NONMAJOR CAPITAL PROJECTS FUNDS
For The Year Ended December 31,2022
With Comparative Totals For The Year Ended December 31,2021
Capital
Park Building Trail& Equipment
Dedication Fund Transportation Reserve
Revenues:
General property taxes S 14,725 $ 353,403 S - $ 273,831
Intergovernmental - - - 160,829
Special assessments - - - -
Investment income (49,930) (17,663) (24,302) (49,459)
Miscellaneous:
Park dedication fees 1,360,540 - - -
Other 13,515 - 291,975 77,608
Total revenues 1,338,850 335,740 267,673 462,809
Expenditures:
Current:
General government - 151,003 - 4,769
Public safety - - - 60,263
Public works - - - -
Parks and recreation - - 4,140 175,924
Capital outlay:
General government - 241,526 - 11,004
Public safety - - - 317,861
Public works - - - 26,480
Parks and recreation 227,850 - - 223,196
Total expenditures 227,850 392,529 4,140 819,497
Revenues over(under)expenditures 1,111,000 (56,789) 263,533 (356,688)
Other financing sources(uses):
Transfers in - - 400,000 107,828
Transfers out (163,143) - - -
Bonds issued - - - -
Bond premium - - - -
Proceeds from sale of capital assets - - 113,710 50,113
Total other financing sources(uses) (163,143) - 513,710 157,941
Net increase(decrease)in fund balance 947,857 (56,789) 777,243 (198,747)
Fund balance(deficit)-January 1 1,018,691 751,054 249,245 1,928,097
Fund balance(deficit)-December 31 S 1,966,548 $ 694,265 S 1,026,488 $ 1,729,350
112
Statement 24
2018A
Equipment G.O.Capital Permanent Totals
Certificates Improvement Improvement Nonmajor Capital Projects Funds
2021A Plan Bonds Revolving 2022 2021
$ 641,959 S 620,180
- - - 160,829 11,224
- - 3,525 3,525 3,569
3,668 107 (23,035) (160,614) (7,982)
- - - 1,360,540 622,680
- - - 383,099 200,533
3,668 107 (19,510) 2,389,337 1,450,204
- 30,503 - 186,275 134,855
- - - 60,263 5,728
- - 2,039 2,039 19,915
- - - 180,064 86,415
44,320 - - 296,850 197,071
66,265 - - 384,126 743,724
517,174 - - 543,654 79,261
139,115 - - 589,161 389,243
765,874 30,503 2,039 2,242,432 1,656,212
(762,206) (30,396) (21,549) 146,905 (206,008)
170,000 - - 677,829 64,187
- - (400,000) (563,143) (202,604)
- - - - 610,000
- - - - 21,663
- - - 163,823 18,800
170,000 - (400,000) 278,508 532,046
(592,206) (30,396) (421,549) 425,413 326,038
642,333 30,396 1,204,389 5,824,205 5,498,167
$ 50,127 $ - $ 782,840 $ 6,249,618 $ 5,824,205
113
CITY OF ANDOVER,MINNESOTA
SPECIAL REVENUE FUND-EDA GENERAL Statement 25
SCHEDULE OF REVENUES,EXPENDITURES AND
CHANGES 1N FUND BALANCES-BUDGET AND ACTUAL
For The Year Ended December 31,2022
With Comparative Actual Amounts For The Year Ended December 31,2021
Variance with
Final Budget-
Budgeted Amounts 2022 Positive 2021
Original Final Actual (Negative) Actual
Revenues:
Charges for services $ 15,000 $ 15,000 S 22,447 $ 7,447 $ 27,527
Investment income 2,000 2,000 (5,432) (7,432) (440)
Miscellaneous - - 953 953 1,308
Total revenues 17,000 17,000 17,968 968 28,395
Expenditures:
Current:
Economic development 253,686 223,686 87,035 136,651 38,851
Capital outlay:
Economic development - 30,000 27,618 2,382 -
Total expenditures 253,686 253,686 114,653 139,033 38,851
Revenues over(under)expenditures (236,686) (236,686) (96,685) 140,001 (10,456)
Other financing sources(uses):
Transfers in 150,000 150,000 150,000 - -
Net increase(decrease)in fund balance $ (86,686) $ (86,686) 53,315 $ 140,001 (10,456)
Fund balance(deficit)-January 1 143,524 153,980
Fund balance(deficit)-December 31 $ 196,839 $ 143,524
114
CITY OF ANDOVER,MINNESOTA
SPECIAL REVENUE FUND-DRAINAGE AND MAPPING Statement 26
SCHEDULE OF REVENUES,EXPENDITURES AND
CHANGES 1N FUND BALANCES-BUDGET AND ACTUAL
For The Year Ended December 31,2022
With Comparative Actual Amounts For The Year Ended December 31,2021
Variance with
Final Budget-
Budgeted Amounts 2022 Positive 2021
Original Final Actual (Negative) Actual
Revenues:
Charges for services $ 9,000 $ 9,000 $ 27,546 $ 18,546 $ 4,137
Investment income 1,200 1,200 (4,913) (6,113) (648)
Total Revenues 10,200 10,200 22,633 12,433 3,489
Expenditures:
Current:
Public works 36,551 36,551 18,883 17,668 16,920
Net increase(decrease)in fund balance $ (26,351) $ (26,351) 3,578 $ 29,929 (13,431)
Fund balance(deficit)-January 1 178,852 192,283
Fund balance(deficit)-December 31 $ 182,430 $ 178,852
115
CITY OF ANDOVER,MINNESOTA
SPECIAL REVENUE FUND-LRRWMO Statement 27
SCHEDULE OF REVENUES,EXPENDITURES AND
CHANGES 1N FUND BALANCES-BUDGET AND ACTUAL
For The Year Ended December 31,2022
With Comparative Actual Amounts For The Year Ended December 31,2021
Variance with
Final Budget-
Budgeted Amounts 2022 Positive 2021
Original Final Actual (Negative) Actual
Revenues:
General property taxes $ 40,000 $ 40,000 S 39,873 $ (127) $ 40,184
Investment income 200 200 (2,019) (2,219) 10
Total revenues 40,200 40,200 37,854 (2,346) 40,194
Expenditures:
Current:
Public works 30,206 30,206 22,751 7,455 29,311
Net increase(decrease)in fund balance $ 9,994 $ 9,994 15,103 $ 5,109 10,883
Fund balance(deficit)-January 1 85,784 74,901
Fund balance(deficit)-December 31 $ 100,887 $ 85,784
116
CITY OF ANDOVER,MINNESOTA
SPECIAL REVENUE FUND-FORESTRY Statement 28
SCHEDULE OF REVENUES,EXPENDITURES AND
CHANGES 1N FUND BALANCES-BUDGET AND ACTUAL
For The Year Ended December 31,2022
With Comparative Actual Amounts For The Year Ended December 31,2021
Variance with
Final Budget-
Budgeted Amounts 2022 Positive 2021
Original Final Actual (Negative) Actual
Revenues:
Intergovernmental $ 12,500 $ 12,500 S 5,950 $ (6,550) $ -
Investment income 50 50 (256) (306) 55
Total revenues 12,550 12,550 5,694 (6,856) 55
Expenditures:
Current:
Public works 15,000 15,000 7,836 7,164 -
Net increase(decrease)in fund balance $ (2,450) $ (2,450) (2,142) $ 308 55
Fund balance(deficit)-January 1 5,390 5,335
Fund balance(deficit)-December 31 $ 3,248 $ 5,390
117
CITY OF ANDOVER,MINNESOTA
SPECIAL REVENUE FUND-RIGHT-OF-WAY MANAGEMENT/UTILITY Statement 29
SCHEDULE OF REVENUES,EXPENDITURES AND
CHANGES 1N FUND BALANCES-BUDGET AND ACTUAL
For The Year Ended December 31,2022
With Comparative Actual Amounts For The Year Ended December 31,2021
Variance with
Final Budget-
Budgeted Amounts 2022 Positive 2021
Original Final Actual (Negative) Actual
Revenues:
Charges for services $ 24,000 $ 24,000 S 49,284 $ 25,284 $ 36,164
Investment income 500 500 (2,605) (3,105) (166)
Total revenues 24,500 24,500 46,679 22,179 35,998
Expenditures:
Current:
Public works 38,958 38,958 22,802 16,156 26,774
Revenue over(under)expenditures (14,458) (14,458) 23,877 38,335 9,224
Other financing sources(uses):
Transfers out (7,400) (7,400) (7,400) - (5,000)
Net increase(decrease)in fund balance $ (21,858) $ (21,858) 16,477 $ 38,335 4,224
Fund balance(deficit)-January 1 85,967 81,743
Fund balance(deficit)-December 31 $ 102,444 $ 85,967
118
CITY OF ANDOVER,MINNESOTA
SPECIAL REVENUE FUND-CHARITABLE GAMBLING Statement 30
SCHEDULE OF REVENUES,EXPENDITURES AND
CHANGES 1N FUND BALANCES-BUDGET AND ACTUAL
For The Year Ended December 31,2022
With Comparative Actual Amounts For The Year Ended December 31,2021
Variance with
Final Budget-
Budgeted Amounts 2022 Positive 2021
Original Final Actual (Negative) Actual
Revenues:
Investment income $ 750 $ 750 S (6,043) $ (6,793) $ (27)
Miscellaneous 30,000 30,000 111,917 81,917 140,516
Total revenues 30,750 30,750 105,874 75,124 140,489
Expenditures:
Current:
General government 35,000 35,000 81,543 (46,543) 47,860
Net increase(decrease)in fund balance $ (4,250) $ (4,250) 24,331 $ 28,581 92,629
Fund balance(deficit)-January 1 229,067 136,438
Fund balance(deficit)-December 31 $ 253,398 $ 229,067
119
CITY OF ANDOVER,MINNESOTA
SPECIAL REVENUE FUND-CONSTRUCTION SEAL COATING Statement 31
SCHEDULE OF REVENUES,EXPENDITURES AND
CHANGES 1N FUND BALANCES-BUDGET AND ACTUAL
For The Year Ended December 31,2022
With Comparative Actual Amounts For The Year Ended December 31,2021
Variance with
Final Budget-
Budgeted Amounts 2022 Positive 2021
Original Final Actual (Negative) Actual
Revenues:
Charges for services $ 10,000 $ 10,000 S 12,964 $ 2,964 $ 9,377
Investment income 500 500 728 228 2
Total revenues 10,500 10,500 13,692 3,192 9,379
Expenditures:
Current:
Public works 10,000 10,000 17,397 (7,397) 9,377
Net increase(decrease)in fund balance $ 500 $ 500 (3,705) $ (4,205) 2
Fund balance(deficit)-January 1 5,157 5,155
Fund balance(deficit)-December 31 $ 1,452 $ 5,157
120
INTERNAL SERVICE FUNDS
Internal Service Funds are used to account for the financing of goods or services provided by one department or agency
to other departments or agencies of the government and to other government units, on a cost reimbursement basis.
The City of Andover had the following Internal Service Funds during the year:
Central Equipment Maintenance—This fund accounts for the maintenance of the equipment for the City.
Risk Management— This fund accounts for the expenditures in payment of insurance deductibles, loss reduction,
safety training and administrative expense.
121
CITY OF ANDOVER,MINNESOTA
COMBINING STATEMENT OF NET POSITION Statement 32
INTERNAL SERVICE FUNDS
December 31,2022
With Comparative Totals for December 31,2021
Central
Equipment Risk Totals
Maintenance Management 2022 2021
Assets:
Current assets:
Cash and cash equivalents $ 138,295 $ 338,231 $ 476,526 $ 686,764
Accrued interest 974 1,991 2,965 2,188
Prepaid items - 216,688 216,688 220,698
Inventories-at cost 138,220 - 138,220 96,606
Total assets 277,489 556,910 834,399 1,006,256
Liabilities:
Current liabilities:
Accounts payable 49,410 2,808 52,218 31,438
Salaries payable 11,268 607 11,875 11,314
Total liabilities 60,678 3,415 64,093 42,752
Net position:
Unrestricted $ 216,811 $ 553,495 $ 770,306 $ 963,504
122
CITY OF ANDOVER,MINNESOTA
COMBINING STATEMENT OF REVENUES,EXPENSES AND Statement 33
CHANGES IN NET POSITION
INTERNAL SERVICE FUNDS
For The Year Ended December 31,2022
With Comparative Totals For The Year Ended December 31,2021
Central
Equipment Risk Totals
Maintenance Management 2022 2021
Operating revenues:
User charges $ 898,000 $ 555,013 $ 1,453,013 $ 1,321,744
Other 75 60,642 60,717 80,211
Total operating revenues 898,075 615,655 1,513,730 1,401,955
Operating expenses:
Personal services 351,941 253,706 605,647 546,835
Supplies 430,117 26,153 456,270 360,128
Other service charges 216,576 408,795 625,371 542,677
Total operating expenses 998,634 688,654 1,687,288 1,449,640
Operating income(loss) (100,559) (72,999) (173,558) (47,685)
Nonoperating revenues(expenses):
Investment income (6,511) (13,129) (19,640) (4,658)
Change in net position (107,070) (86,128) (193,198) (52,343)
Net position-January 1 323,881 639,623 963,504 1,015,847
Net position-December 31 $ 216,811 $ 553,495 $ 770,306 $ 963,504
123
CITY OF ANDOVER,MINNESOTA
COMBINING STATEMENT OF CASH FLOWS Statement 34
INTERNAL SERVICE FUNDS
For The Year Ended December 31,2022
With Comparative Totals For The Year Ended December 31,2021
Central
Equipment Risk Totals
Maintenance Management 2022 2021
Cash flows from operating activities:
Receipts from customers and users $ 898,075 $ 615,655 $ 1,513,730 $ 1,401,955
Payment to suppliers (668,971) (429,494) (1,098,465) (1,124,130)
Payment to employees (351,398) (253,688) (605,096) (545,916)
Net cash flows from operating activities (122,294) (67,527) (189,821) (268,091)
Cash flows from investing activities:
Investment income (6,643) (13,774) (20,417) (2,558)
Net increase(decrease)in cash and cash equivalents (128,937) (81,301) (210,238) (270,649)
Cash and cash equivalents-January 1 267,232 419,532 686,764 957,413
Cash and cash equivalents-December 31 $ 138,295 $ 338,231 $ 476,526 $ 686,764
Reconciliation of operating income to net cash provided
(used)by operating activities:
Operating income(loss) $ (100,559) $ (72,999) $ (173,558) $ (47,685)
Adjustments to reconcile operating income(loss)
to net cash flows from operating activities:
Changes in assets and liabilities:
Decrease(increase)in prepaid items 4,010 4,010 (220,698)
Decrease(increase)in inventory (41,614) - (41,614) (4,923)
Increase(decrease)in accounts payable 19,336 1,444 20,780 4,296
Increase(decrease)in salaries payable 543 18 561 919
Total adjustments (21,735) 5,472 (16,263) (220,406)
Net cash provided(used)by operating activities $ (122,294) $ (67,527) $ (189,821) $ (268,091)
124
III. STATISTICAL SECTION
This part of the City of Andover's comprehensive annual financial report presents detailed information as a context for
understanding what the infonmation in the financial statements,note disclosures, and required supplementary information
says about the City's overall financial health.
Contents Page
Financial Trends 126
These tables contain trend information to help the reader understand how the City's financial performance
and well-being have changed over time.
Revenue Capacity 136
These tables contain information to help the reader assess the City's most significant local revenue source,
the property tax.
Debt Capacity 142
These tables present information to help the reader assess the affordability of the City's current levels of
outstanding debt and the City's ability to issue additional debt in the future.
Demographic and Economic Information 150
These tables offer demographic and economic indicators to help the reader understand the environment
within which the City of Andover's financial activities take place.
Operating Information 153
These tables contain service and infrastructure data to help the reader understand how the information in
the City's financial report relates to the services the City provides and the activities it performs.
125
CITY OF ANDOVER,MINNESOTA
NET POSITION BY COMPONENT
Last Ten Fiscal Years
(accrual basis of accounting)
2013 2014 2015 2016
Governmental Activities
Net investment in capital assets $ 93,393,474 $ 94,533,473 $ 95,998,027 $ 99,539,838
Restricted 3,792,323 4,776,047 5,755,162 5,787,072
Unrestricted 22,936,032 23,175,077 24,457,253 26,085,240
Total governmental activities net position 120,121,829 122,484,597 126,210,442 131,412,150
Business-Type Activities
Net investment in capital assets 34,864,659 34,787,382 35,507,395 37,531,815
Unrestricted 6,310,830 6,292,850 7,004,563 7,652,339
Total business-type activities net position 41,175,489 41,080,232 42,511,948 45,184,154
Primary Government
Net investment in capital assets 128,258,133 129,320,855 131,505,412 137,071,653
Restricted 3,792,323 4,776,047 5,755,162 5,787,072
Unrestricted 29,246,862 29,467,927 31,461,816 33,737,579
Total primary government net position $ 161,297,318 $ 163,564,829 $ 168,722,390 $ 176,596,304
GASB 68 was implemented in 2015. Net position was restated for 2014 to reflect the reporting of net pension liability and pension
related deferred outflows and inflows of resources. Net position for years prior to 2014 were not restated.
126
Table 1
2017 2018 2019 2020 2021 2022
$ 101,602,647 $ 103,577,524 $ 106,637,436 $ 114,441,287 $ 115,576,274 $ 113,896,484
4,935,375 5,081,230 5,294,610 3,851,631 4,465,945 5,088,833
27,673,920 28,319,303 30,608,612 35,974,899 38,516,535 43,578,925
134,211,942 136,978,057 142,540,658 154,267,817 158,558,754 162,564,242
37,174,817 37,068,699 38,547,614 40,342,053 43,517,002 44,098,814
8,446,942 9,825,681 9,982,550 11,023,179 11,463,122 12,286,201
45,621,759 46,894,380 48,530,164 51,365,232 54,980,124 56,385,015
138,777,464 140,646,223 145,185,050 154,783,340 159,093,276 157,995,298
4,935,375 5,081,230 5,294,610 3,851,631 4,465,945 5,088,833
36,120,862 38,144,984 40,591,162 46,998,078 49,979,657 55,865,126
$ 179,833,701 $ 183,872,437 $ 191,070,822 $ 205,633,049 $ 213,538,878 $ 218,949,257
127
CITY OF ANDOVER,MINNESOTA
CHANGES IN NET POSITION
Last Ten Fiscal Years
(accrual basis of accounting)
2013 2014 2015 2016
Expenses
Governmental activities:
General government $ 3,061,867 $ 2,791,507 $ 2,823,408 $ 2,904,102
Public safety 4,495,447 4,747,142 4,774,033 5,140,347
Public works 4,465,153 4,430,295 2,967,957 3,905,703
Parks and recreation 3,029,917 3,229,894 3,340,561 3,321,814
Recycling 124,515 111,760 98,016 133,614
Economic development 318,646 676,039 192,265 411,958
Interest on long-term debt 1,399,172 542,139 454,808 437,513
Total governmental activities expenses 16,894,717 16,528,776 14,651,048 16,255,051
Business-type activities:
Water 2,275,363 2,308,552 2,316,651 2,454,931
Sewer 1,964,911 1,951,785 2,002,623 2,128,814
Storm sewer 561,807 848,745 595,902 546,526
Total business-type activities expenses 4,802,081 5,109,082 4,915,176 5,130,271
Total primary government expenses $ 21,696,798 $ 21,637,858 $ 19,566,224 $ 21,385,322
Program Revenues
Governmental activities:
Charges for services:
General government $ 843,304 $ 801,458 $ 1,381,113 $ 2,124,665
Public safety 704,119 492,665 624,430 832,412
Public works 321,114 318,018 298,143 661,788
Parks and recreation 1,463,579 1,545,794 1,514,900 1,521,585
Recycling 42,544 41,440 32,976 42,768
Economic development 239,570 96,772 50,628 174,754
Operating grants and contributions 1,1 19,778 946,540 965,986 992,194
Capital grants and contributions 1,425,815 4,677,704 863,155 2,703,429
Total governmental activities program revenue 6,159,823 8,920,391 5,731,331 9,053,595
Business-type activities:
Charges for services:
Water 2,495,561 2,347,763 2,593,303 2,575,920
Sewer 2,065,467 2,117,624 2,129,201 2,144,794
Storm sewer 399,417 421,056 444,335 464,928
Operating grants and contributions - 9,506 - 2,681
Capital grants and contributions - 990,412 1,524,088 2,670,641
Total business-type activities program revenue 4,960,445 5,886,361 6,690,927 7,858,964
Total primary government program revenues 11,120,268 14,806,752 12,422,258 16,912,559
Net(Expense)/Revenue
Governmental activities (10,734,894) (7,608,385) (8,919,717) (7,201,456)
Business-type activities 158,364 777,279 1,775,751 2,728,693
Total primary government net expense $ (10,576,530) $ (6,831,106) $ (7,143,966) $ (4,472,763)
128
Table 2
2017 2018 2019 2020 2021 2022
$ 2,937,380 $ 3,209,512 $ 3,159,045 $ 3,193,326 $ 3,202,342 $ 3,832,215
5,167,930 5,263,071 5,426,472 6,002,090 5,814,286 6,245,503
5,428,350 4,257,014 5,939,704 4,964,909 4,726,280 8,393,927
3,385,001 3,321,793 3,507,705 3,997,558 4,676,676 5,312,290
169,100 206,335 231,625 234,475 245,755 180,188
1,098,300 249,669 202,192 4,240,712 293,594 677,828
403,200 377,314 917,913 1,226,839 1,184,349 1,191,104
18,589,261 16,884,708 19,384,646 23,859,909 20,143,282 25,833,055
2,263,748 2,306,013 2,280,247 2,449,287 2,546,637 2,743,148
2,190,453 2,175,331 2,289,555 2,454,250 2,435,302 2,581,604
684,708 614,816 737,954 617,883 611,579 669,468
5,138,909 5,096,160 5,307,656 5,521,420 5,593,518 5,994,220
$ 23,728,170 $ 21,980,868 $ 24,692,302 $ 29,381,329 $ 25,736,800 $ 31,827,275
$ 925,639 $ 647,452 $ 909,139 $ 757,188 $ 2,241,593 $ 2,114,479
680,729 721,078 1,091,260 1,154,232 1,078,065 1,251,620
334,273 331,620 357,231 296,533 279,191 324,440
1,465,562 1,504,647 1,677,991 1,301,624 2,068,652 2,073,350
43,062 49,453 44,099 48,705 70,003 50,925
461,294 87,891 96,176 126,596 233,312 179,029
1,186,721 1,407,217 1,662,842 3,453,564 1,242,650 3,214,092
3,414,161 1,609,129 4,950,131 12,006,951 2,112,499 5,156,356
8,511,441 6,357,487 10,788,869 19,145,393 9,325,965 14,364,291
2,716,239 3,061,920 2,756,944 3,349,237 3,806,408 3,683,763
2,301,077 2,325,456 2,329,462 2,355,039 2,395,512 2,497,153
499,974 537,422 564,154 594,524 634,815 663,245
- - - - - 3,600
481,343 504,267 712,976 2,807,445 2,508,801 1,266,143
5,998,633 6,429,065 6,363,536 9,106,245 9,345,536 8,113,904
14,510,074 12,786,552 17,152,405 28,251,638 18,671,501 22,478,195
(10,077,820) (10,527,221) (8,595,777) (4,714,516) (10,817,317) (11,468,764)
859,724 1,332,905 1,055,880 3,584,825 3,752,018 2,119,684
$ (9,218,096) $ (9,194,316) $ (7,539,897) $ (1,129,691) $ (7,065,299) $ (9,349,080)
(Continued)
129
CITY OF ANDOVER,MINNESOTA
CHANGES IN NET POSITION
Last Ten Fiscal Years
(accrual basis of accounting)
2013 2014 2015 2016
General Revenues and Other Changes in Net Position
Governmental activities:
Taxes:
General property taxes $ 10,608,678 $ 10,863,912 $ 11,120,449 $ 11,770,304
Tax increment collections 320,822 353,773 210,625 69,772
Grants and contributions not restricted to
specific programs 12,511 87,179 15,327 16,260
Unrestricted investment earnings 571,307 747,621 348,885 399,021
Gain on sale of capital assets 23,650 228,639 548,950 20,360
Transfers (323,654) 606,793 401,326 127,447
Total governmental activities 11,213,314 12,887,917 12,645,562 12,403,164
Business-type activities:
Unrestricted investment earnings (21,533) 115,425 57,291 68,768
Gain on sale of capital assets 8,000 - - 2,192
Transfers 323,654 (606,793) (401,326) (127,447)
Total business-type activities 310,121 (491,368) (344,035) (56,487)
Total primary government $ 11,523,435 $ 12,396,549 $ 12,301,527 $ 12,346,677
Change in Net Position
Governmental activities $ 478,420 $ 5,279,532 $ 3,725,845 $ 5,201,708
Business-type activities 468,485 285,911 1,431,716 2,672,206
Total primary government $ 946,905 $ 5,565,443 $ 5,157,561 $ 7,873,914
GASB 68 was implemented in 2015. Expenses for years prior to 2015 were not restated.
130
Table 2
(Continued)
2017 2018 2019 2020 2021 2022
$ 11,874,354 $ 12,423,060 $ 13,011,406 $ 14,479,488 $ 14,934,589 $ 16,036,590
74,771 82,874 89,414 100,979 103,474 93,862
13,638 12,917 14,053 4,129 3,578 4,417
373,585 560,133 1,346,685 930,876 (71,710) (1,165,410)
20,489 36,431 24,550 3,000 18,800 50,113
520,775 177,921 (327,730) 923,203 119,523 454,680
12,877,612 13,293,336 14,158,378 16,441,675 15,108,254 15,474,252
65,801 117,637 236,356 173,446 (17,603) (260,113)
32,855 - 15,818 - - -
(520,775) (177,921) 327,730 (923,203) (119,523) (454,680)
(422,119) (60,284) 579,904 (749,757) (137,126) (714,793)
$ 12,455,493 $ 13,233,052 $ 14,738,282 $ 15,691,918 $ 14,971,128 $ 14,759,459
$ 2,799,792 $ 2,766,115 $ 5,562,601 $ 11,727,159 $ 4,290,937 $ 4,005,488
437,605 1,272,621 1,635,784 2,835,068 3,614,892 1,404,891
$ 3,237,397 $ 4,038,736 $ 7,198,385 $ 14,562,227 $ 7,905,829 $ 5,410,379
131
CITY OF ANDOVER,MINNESOTA
FUND BALANCES-GOVERNMENTAL FUNDS
Last Ten Fiscal Years
(modified accrual basis of accounting)
2013 2014 2015 2016
General Fund
Nonspendable S 106,445 $ 137,001 S 131,813 $ 146,417
Unassigned 6,853,791 7,065,133 7,136,091 7,650,328
Total general fund 6,960,236 7,202,134 7,267,904 7,796,745
All Other Governmental Funds
Nonspendable 1,316 1,562 1,800 2,027
Restricted 21,274,444 5,022,967 5,674,417 5,852,444
Committed 588,516 591,289 531,729 513,916
Assigned 13,481,786 16,095,395 17,907,929 19,109,145
Unassigned (276,829) (114,344) (63,357) (64,193)
Total all other governmental funds 35,069,233 21,596,869 24,052,518 25,413,339
Total governmental funds $ 42,029,469 $ 28,799,003 $ 31,320,422 $ 33,210,084
132
Table 3
2017 2018 2019 2020 2021 2022
$ 117,253 $ 112,971 $ 122,993 $ 140,602 $ 154,736 $ 170,128
7,672,363 8,023,365 9,240,458 9,513,916 9,471,730 9,794,213
7,789,616 8,136,336 9,363,451 9,654,518 9,626,466 9,964,341
2,041 2,386 1,957 2,123 17,920 10,000
4,550,557 14,225,839 19,696,883 4,651,447 12,033,034 8,508,752
530,505 518,617 518,312 508,062 499,284 584,224
20,855,184 21,327,036 22,569,932 27,612,210 30,214,430 35,196,270
(65,185) (66,263) - - - -
25,873,102 36,007,615 42,787,084 32,773,842 42,764,668 44,299,246
$ 33,662,718 $ 44,143,951 $ 52,150,535 $ 42,428,360 $ 52,391,134 $ 54,263,587
133
CITY OF ANDOVER,MINNESOTA
CHANGES IN FUND BALANCES-GOVERNMENTAL FUNDS
Last Ten Fiscal Years
(modified accrual basis of accounting)
2013 2014 2015 2016
Revenues
General property taxes S 10,682,975 S 10,894,301 S 11,148,149 S 11,809,352
Tax increment collections 375,040 377,733 213,020 91,808
Licenses and permits 536,706 364,430 452,422 625,907
Intergovernmental 1,115,047 3,464,985 959,790 1,564,848
Special assessments 1,045,000 733,425 690,161 818,065
Charges for services 1,806,919 1,720,972 1,499,909 1,613,941
Fines 96,130 94,375 99,304 88,600
Investment income 573,256 735,325 341,392 389,114
Miscellaneous:
Park dedication fees 205,080 156,384 170,144 431,784
Connection charges 436,628 676,826 405,967 445,698
Rent 639,423 639,000 638,220 656,604
Other 1,698,964 564,057 542,473 1,189,179
Total revenues 19,211,168 20,421,813 17,160,951 19,724,900
Expenditures
General government 2,647,278 2,588,950 2,639,821 2,686,308
Public safety 4,301,698 4,537,264 4,521,129 4,709,083
Public works 4,251,454 4,145,404 2,747,550 3,694,911
Parks and recreation 1,990,457 2,139,552 2,277,576 2,226,454
Recycling 123,595 106,587 91,940 124,860
Economic development 408,210 665,325 181,551 401,244
Unallocated 75,517 81,183 56,720 33,077
Capital outlay 2,763,351 2,816,375 941,213 2,220,253
Debt service:
Principal retirement 1,689,000 2,336,719 1,961,719 1,966,719
Interest 1,262,302 900,504 470,687 444,144
Other 5,509 7,895 5,009 1,325
Construction/acquisition costs 946,942 - 167,955 414,987
Total expenditures 20,465,313 20,325,758 16,062,870 18,923,365
Revenues over(under)expenditures (1,254,145) 96,055 1,098,081 801,535
Other Financing Sources(Uses)
Transfers in 627,530 627,530 627,530 627,530
Transfers out (4,242) (20,737) (58,249) (85,096)
Bonds issued - 1,555,000 - 520,000
Redemption of refunded bonds (1,900,000) (16,455,000) - -
Bond premium - 44,278 - -
Proceeds from the sale of capital assets 76,184 922,408 854,057 25,693
Total other financing sources(uses) (1,200,528) (13,326,521) 1,423,338 1,088,127
Net increase(decrease)in fund balance S (2,454,673) S (13,230,466) S 2,521,419 S 1,889,662
Debt service as a percentage of
noncapital expenditures 16.67% 18.49% 16.09% 14.43%
134
Table 4
2017 2018 2019 2020 2021 2022
$ 11,923,097 $ 12,433,651 $ 12,985,096 $ 14,451,737 $ 14,924,342 $ 16,060,412
82,448 86,794 90,189 100,979 103,474 94,701
546,378 562,525 855,831 892,279 891,762 972,879
3,150,578 1,641,806 2,786,445 6,211,801 1,102,318 3,593,374
832,528 554,471 721,950 631,999 696,591 709,864
1,574,242 1,656,254 1,941,637 1,672,023 2,393,518 2,646,415
75,287 73,719 62,349 47,630 53,747 55,983
362,974 543,672 1,316,876 913,671 (67,052) (1,145,770)
95,198 75,798 472,753 389,033 622,680 1,360,540
412,691 444,989 1,152,759 1,136,882 926,982 1,962,378
641,691 637,150 636,803 635,629 635,026 624,508
428,186 525,667 1,462,431 862,805 817,623 1,048,482
20,125,298 19,236,496 24,495,119 27,946,468 23,101,011 27,983,766
2,754,189 3,115,956 3,011,191 3,079,344 3,203,054 3,490,416
4,822,435 4,956,350 5,096,029 5,754,243 5,533,004 5,765,962
5,208,862 4,298,845 5,691,654 4,588,958 4,361,714 7,648,471
2,253,370 2,214,415 2,371,437 2,495,594 2,799,832 3,233,250
169,956 199,182 224,574 228,124 239,606 169,169
1,087,586 538,955 191,468 4,154,244 297,628 743,191
14,875 11,940 15,001 12,778 16,109 17,396
1,484,422 2,102,030 14,925,106 16,830,198 1,596,917 2,255,478
1,996,719 1,612,717 1,444,000 1,561,000 1,899,000 2,110,000
418,419 385,555 568,864 1,290,844 1,278,030 1,291,283
3,095 3,095 1,000 5,000 5,500 5,200
52,527 164,399 1,564,585 7,145 743,203 388,924
20,266,455 19,603,439 35,004,909 40,007,472 21,973,597 27,118,740
(141,157) (366,943) (10,519,790) (12,061,004) 1,127,414 865,026
627,530 643,729 1,323,739 990,088 1,011,431 996,481
(54,228) (114,850) (58,110) (59,740) (148,705) (152,877)
- 10,000,000 15,770,000 1,310,000 7,765,000 -
- 254,260 1,458,695 95,481 188,834 -
20,489 65,037 32,050 3,000 18,800 163,823
593,791 10,848,176 18,526,374 2,338,829 8,835,360 1,007,427
$ 452,634 $ 10,481,233 $ 8,006,584 $ (9,722,175) $ 9,962,774 $ 1,872,453
12.86% 11.42% 9.97% 12.30% 15.59% 13.68%
135
CITY OF ANDOVER,MINNESOTA
ASSESSED AND ESTIMATED ACTUAL VALUE OF TAXABLE PROPERTY Table 5
Last Ten Fiscal Years
Real Property Personal Property Total Total Net Tax Capacity
Taxable Net Tax Taxable Net Tax Taxable Net Tax Direct as a Percentage
Year Market Value Capacity Market Value Capacity Market Value Capacity Tax Rate ofMarket Value
2013 S 2,097,459,658 $ 22,048,362 $ 26,136,700 $ 520,656 $2,123,596,358 $ 22,569,018 41.170% 1.06%
2014 2,045,873,681 21,462,221 25,938,600 516,101 2,071,812,281 21,979,322 43.657% 1.06%
2015 2,411,059,312 25,213,801 24,711,300 491,549 2,435,770,612 25,705,350 37.460% 1.06%
2016 2,513,051,767 26,316,855 26,635,100 530,418 2,539,686,867 26,847,273 38.667% 1.06%
2017 2,605,298,959 27,358,838 28,181,200 561,340 2,633,480,159 27,920,178 37.738% 1.06%
2019 2,929,062,970 30,682,357 30,348,500 604,696 2,959,411,470 31,287,043 34.952% 1.06%
2019 3,089,514,579 32,331,885 32,283,200 643,380 3,121,797,779 32,975,265 35.621% 1.06%
2020 3,392,964,562 35,504,632 29,961,600 594,907 3,422,826,162 36,099,539 35.942% 1.05%
2020 3,392,964,562 35,504,632 29,861,600 594,907 3,422,826,162 36,099,539 35.942% 1.05%
2021 3,510,521,981 36,700,449 33,434,800 666,326 3,543,956,781 37,366,775 35.845% 1.05%
2022 3,802,290,264 39,706,613 25,262,700 502,883 3,827,552,964 40,209,496 36.245% 1.05%
Source: Anoka County Property Tax Division
136
CITY OF ANDOVER,MINNESOTA
PROPERTY TAX RATES-PER$1,000 OF ASSESSED TAX CAPACITY VALUE Table 6
DIRECT AND OVERLAPPING GOVERNMENTS
Last Ten Fiscal Years
Direct City
General Debt Lower
Taxes Oper Service Rum Overlapping Governments
Payable Levy Levy Watershed Total School County Other Total Total
2014 35.486% 7.711% 0.460% 43.657% 28.265% 43.239% 4.354% 75.858% 119.515%
2015 30.441% 6.628% 0.391% 37.460% 22.482% 38.123% 4.104% 64.709% 102.169%
2016 31.898% 6.381% 0.388% 38.667% 20.885% 38.894% 4.949% 64.728% 103.395%
2017 33.128% 4.246% 0.364% 37.738% 18.590% 36.841% 3.952% 59.383% 97.121%
2018 30.607% 4.020% 0.325% 34.952% 18.392% 35.334% 3.906% 57.632% 92.584%
2019 29.830% 5.480% 0.311% 35.621% 16.330% 34.473% 3.478% 54.281% 89.902%
2020 28.390% 7.266% 0.286% 35.942% 16.893% 33.361% 3.157% 53.411% 89.353%
2021 29.367% 7.207% 0.271% 35.845% 17.801% 30.935% 3.146% 51.882% 87.727%
2022 27.590% 8.403% 0.250% 36.243% 16.319% 29.254% 3.091% 48.664% 84.907%
2023 24.046% 6.827% 0.200% 31.073% 13.671% 24.176% 2.655% 40.502% 71.575%
Source: Anoka County Property Tax Division
137
CITY OF ANDOVER,MINNESOTA
PROPERTY TAX LEVIES AND COLLECTIONS Table 7
Last Ten Fiscal Years
Collected Within the Fiscal Year of Levy
Total Market Value Collections In Total Collections to Date
Tax Tax Homestead Total Percentage Subsequent Percentage
Year Levy Levy Credit Collected of Levy Years Amount of Levy
2013 $ 10,631,299 $ 10,535,521 $ 1,246 $ 10,536,767 99.11% $ 94,532 $ 10,631,299 100.00%
2014 10,843,925 10,776,635 - 10,776,635 99.38% 67,290 10,843,925 100.00%
2015 11,143,925 11,054,157 - 11,054,157 99.19% 69,316 11,123,473 99.82%
2016 11,593,925 11,525,770 3,461 11,529,231 99.44% 22,980 11,552,211 99.64%
2017 11,938,555 11,858,376 3,545 11,861,921 99.36% 13,323 11,875,244 99.47%
2018 12,416,357 12,342,648 2,824 12,345,471 99.43% 4,590 12,350,062 99.47%
2019 13,103,487 12,974,413 3,960 12,978,373 99.05% 58,742 13,037,116 99.49%
2020 14,479,586 14,391,252 4,128 14,395,381 99.42% 49,410 14,444,791 99.76%
2021 14,913,945 14,853,700 3,578 14,857,278 99.62% 44,201 14,901,479 99.92%
2022 16,107,254 16,029,549 4,417 16,033,966 99.54% F Not Available
138
CITY OF ANDOVER,MINNESOTA
PRINCIPAL TAXPAYERS Table 8
Current Year and Nine Years Ago
2022 2013
Net Percentage of Net Percentage of
Tax Total City Tax Total City
Taxpayers Capacity Rank Tax Capacity Capacity Rank Tax Capacity
Minnegasco,Inc. $ 304,238 1 0.81% $ 211,244 1 0.96%
Presbyterian Homes of Andover 251,795 2 0.67% 140,847 5 0.64%
Connexus Energy 245,398 3 0.66% 193,140 3 0.88%
Wal-Mart 186,388 4 0.50%
Arbor Oaks Senior Living Realty 181,781 5 0.49%
Target Corporation 166,692 6 0.45% 160,049 4 0.73%
Andover Limited Partnership 147,260 7 0.39% 117,528 6 0.53%
Great River Energy 142,857 8 0.38% 194,039 2 0.88%
Andover Station 2016 LLC 120,860 9 0.32% 97,182 7 0.44%
PC Arbor Oaks LLC 120.330 10 0.32%
DST Properties LLC 81,678 8 0.37%
Fairbanks Properties LLC 65,926 9 0.30%
Columbia Park Properties 59,878 10 0.27%
Total $ 1,867,599 4.99% $ 1,321,509 6.00%
Net Tax Capacity $ 37,366,775 $ 21,978,322
Source: Anoka County Property Tax Division
139
CITY OF ANDOVER,MINNESOTA
ESTIMATED MARKET VALUES AND NEW CONSTRUCTION Table 9
Last Ten Fiscal Years
Estimated Market Values New Construction
Commercial/ Connnercial/Industrial Residential
Year Industrial(1) Residential Total Permits Value Permits Value
2013 $ 174,971,400 $ 2,141,898,900 $ 2,316,870,300 15 $ 9,249,466 98 $ 20,351,892
2014 166,531,500 2,103,536,600 2,270,068,100 14 4,295,281 52 13,926,901
2015 173,717,700 2,437,681,500 2,611,399,200 16 2,513,609 74 19,631,775
2016 184,083,400 2,530,046,700 2,714,130,100 7 14,009,200 111 28,893,036
2017 196,837,900 2,610,055,500 2,806,893,400 - 94 27,847,717
2018 207,569,200 2,908,606,300 3,116,175,500 2 2,860,000 60 19,703,857
2019 214,417,500 3,057,490,800 3,271,908,300 2 3,901,376 116 37,258,817
2020 229,402,926 3,332,915,773 3,561,318,699 - 139 45,464,139
2021 235,287,000 3,450,673,800 3,685,960,800 - 141 43,949,250
2022 226,699,000 3,731,908,100 3,958,607,100 3 6,993,400 103 55,992,019
Note: (1)Also includes agricultural,public utility,railroad operating property,and personal property.
140
CITY OF ANDOVER,MINNESOTA
SPECIAL ASSESSMENT LEVIES AND COLLECTIONS Table 10
Last Ten Fiscal Years
Total Delinquent
Collections Assessments
Current Current Percent of Delinquent Total as a Percent of Outstanding as a Percent of
Assessments Assessments Assessments Assessment Assessment Current Delinquent Current
Year Due(1) Collected Collected Collections Collections Assessments Due Assessments Assessments Due
2013 $ 338,411 $ 387,584 114.53% $ 168,941 $ 556,525 164.45% $ 82,826 24.47%
2014 326,597 387,651 118.69% 3,788 391,439 119.85% 215,970 66.13%
2015 334,054 514,868 154.13% 4,003 518,871 155.33% 269,754 80.75%
2016 267,704 510,275 190.61% 2,153 512,429 191.42% 268,716 100.38%
2017 265,163 513,140 193.52% 212 513,352 193.60% 272,101 102.62%
2019 305,249 555,684 182.04% 412 556,096 182.19% 283,528 92.88%
2019 272,670 532,268 195.21% 1,579 533,847 195.79% 295,781 108.48%
2020 272,526 524,787 192.56% 5,684 530,471 194.65% 272,865 100.12%
2021 270,334 504,303 186.55% 8,024 512,328 189.52% 248,237 91.83%
2022 269,026 483,558 179.74% 6,925 490,482 182.32% 278,861 103.66%
Note: (1) Only includes assessments certified to Anoka County.
141
CITY OF ANDOVER,MINNESOTA
RATIO OF NET BONDED DEBT Table 11
TO ASSESSED VALUE AND NET BONDED DEBT PER CAPITA
Last Ten Fiscal Years
General Bonded Debt Outstanding(2)
Gross Amount Net Percentage Net Bonded
Fiscal Estimated Bonded Restricted For Bonded of Estimated Debt
Year Population(1) Market Value Debt Debt Service Debt Market Value Per Capita
2013 31,392 $ 2,316,870,300 $ 37,460,000 $ (17,415,812) $ 20,044,189 0.87% $ 638.51
2014 31,574 2,270,068,100 21,035,000 (942,607) 20,092,393 0.89% 636.36
2015 31,704 2,611,399,200 19,330,000 (1,064,634) 18,265,366 0.70% 576.12
2016 32,335 2,714,130,100 18,080,000 (1,163,486) 16,916,514 0.62% 523.16
2017 32,470 2,806,893,400 16,280,000 (800,214) 15,479,796 0.55% 476.74
2018 32,728 3,116,175,500 24,864,000 (899,986) 23,964,014 0.77% 732.22
2019 32,882 3,271,908,300 40,619,047 (917,364) 39,701,693 1.21% 1,207.40
2020 33,448 3,561,318,700 40,296,891 (1,582,258) 38,714,633 1.09% 1,157.46
2021 32,708 3,685,960,800 46,091,735 (2,064,237) 44,027,498 1.19% 1,346.08
2022 33,058 3,958,607,100 43,910,579 (3,024,557) 40,886,022 1.03% 1,236.80
Notes: (1) SoLu-ce: Metropolitan Council
(2) Only includes debt supported by tax levy.
142
CITY OF ANDOVER,MINNESOTA
COMPUTATION OF DIRECT AND OVERLAPPING DEBT Table 12
December 31,2022
Gross General
Obligation Percentage Net Amount
Bonded Debt Applicable Applicable
Outstanding to City(2) to City
Direct:
City of Andover $ 43,910,579 100.0000% $ 43,910,579
Overlapping:
Anoka County 49,315,000 (1) 9.1237% 4,499,353
ISD No. 11 Anoka-Hennepin 251,620,000 (1) 12.8635% 32,367,139
ISD No. 15 St.Francis 85,080,000 (1) 6.2198% 5,291,806
Anoka County Regional Railroad Authority 18,860,000 (1) 9.1237% 1,720,730
Metropolitan Council 193,320,000 (1) 0.8470% 1,637,420
Total overlapping debt 45,516,448
Total overlapping and direct debt $ 99,427,027
Notes: (1) Information obtained from Anoka County.
(2) Overlapping governments are those that coincide with the geographical 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 City's ability to issue and repay long-term debt,the entire debt burden
borne by the residents and businesses should be taken into account. However,this does not imply that every taxpayer is a
resident,and therefore responsible for repaying the debt of each overlapping government.
143
CITY OF ANDOVER,MINNESOTA
COMPUTATION OF LEGAL DEBT MARGIN
Last Ten Fiscal Years
2013 2014 2015 2016
Estimated Taxable Market Value $ 2,123,596,358 $ 2,071,812,281 $ 2,435,770,612 $ 2,539,686,867
Debt limitation:
Debt limit percent 3% 3% 3% 3%
Debt limit in dollars 63,707,891 62,154,368 73,073,118 76,190,606
Debt applicable to limit:
Total bonded debt 45,010,000 27,405,000 25,050,000 27,110,000
Less: Nonapplicable debt
G.O.water revenue bonds (6,875,000) (6,310,000) (5,720,000) (9,030,000)
Permanent improvement
revolving bonds (385,000) - - -
State aid bonds (290,000) (60,000) - -
Less: Cash and investments in
related debt service funds (17,415,812) (942,607) (1,191,519) (1,299,334)
Total debt applicable to limitation 20,044,188 20,092,393 18,138,481 16,780,666
Legal debt margin $ 43,663,703 $ 42,061,975 $ 54,934,637 $ 59,409,940
Total debt applicable to the limit as
a percentage of debt limit 31.46% 32.33% 24.82% 22.02%
144
Table 13
2017 2018 2019 2020 2021 2022
$ 2,633,480,159 $ 2,959,411,470 $ 3,121,797,779 $ 3,422,826,162 $ 3,543,956,781 $ 3,827,552,964
3% 3% 3% 3% 3% 3%
79,004,405 88,782,344 93,653,933 102,684,785 106,318,703 114,826,589
20,740,000 28,639,000 42,260,000 41,284,000 46,415,000 43,550,000
(4,460,000) (3,775,000) (3,070,000) (2,345,000) (1,610,000) (855,000)
(943,862) (1,032,604) (1,418,376) (2,021,047) (2,516,818) (3,435,767)
15,336,138 23,831,396 37,771,624 36,917,953 42,288,182 39,259,233
$ 63,668,267 $ 64,950,948 $ 55,882,309 $ 65,766,832 $ 64,030,521 $ 75,567,356
19.41% 26.84% 40.33% 35.95% 39.77% 34.19%
145
-This page intentionally left blank-
146
CITY OF ANDOVER,MINNESOTA
PLEDGED-REVENUE COVERAGE Table 14
Last Ten Fiscal Years
Water Revenue Bonds
Water Enterprise Fund
Fiscal Operating Less:Operating Transfers Net Available Debt Service
Year Revenues Expenses(1) In(2) Revenue Principal Interest Coverage
2013 $ 2,495,561 $ 1,285,188 $ 4,242 $ 1,214,615 $ 545,000 $ 276,458 1.48
2014 2,347,763 1,320,552 20,737 1,047,948 565,000 254,715 1.28
2015 2,593,303 1,373,362 58,249 1,278,190 590,000 231,978 1.56
2016 2,575,920 1,535,224 85,096 1,125,792 615,000 208,122 1.37
2017 2,716,239 1,441,224 54,228 1,329,243 645,000 71,818 1.85
2018 3,061,920 1,448,248 114,850 1,728,522 685,000 85,770 2.24
2019 2,756,944 1,912,710 58,110 902,344 705,000 70,668 1.16
2020 3,349,237 1,983,821 59,740 1,425,156 725,000 54,910 1.83
2021 3,806,408 2,119,084 148,705 1,836,029 735,000 38,743 2.37
2022 3,683,763 2,251,200 152,877 1,585,440 755,000 22,084 2.04
2004 FDA Public Facility Lease Revenue Bond(3)&2012 and 2019 Abatement Bonds
Community Center Special Revenue Fund Debt Service
Fiscal Operating Less:Operating Net Available General Property Debt Service
Year Revenue Expenses Revenue Tax Revenue Principal Interest Coverage
2013 $ 1,381,573 $ 971,108 $ 410,465 $ 1,029,949 $ 425,000 $ 878,534 1.11
2014 1,462,169 1,058,467 403,702 924,057 790,000 820,054 0.82
2015 1,449,851 1,045,347 404,504 974,822 835,000 379,906 1.14
2016 1,428,771 1,048,452 380,319 979,038 845,000 371,506 1.12
2017 1,445,784 1,041,714 404,070 973,161 855,000 358,731 1.13
2018 1,490,157 1,045,141 445,016 970,085 870,000 341,481 1.17
2019 1,506,473 1,047,404 459,069 960,618 885,000 323,931 1.17
2020 1,266,968 1,153,500 113,468 1,969,617 910,000 896,131 1.15
2021 2,080,633 1,375,835 704,798 1,950,295 1,160,000 871,906 1.31
2022 2,235,783 1,720,151 515,632 1,981,792 1,490,000 833,708 1.07
Special Assessment and Permanent Improvement Revolviniz Bonds
Fiscal Special Assessment Debt Service
Year Revenue Principal Interest Coverage
2013 $ 598,889 $ 375,000 $ 11,450 1.55
2014 102,380 395,000 3,850 0.26
2015 126,628 No outstanding debt
2016 78,189 No outstanding debt
2017 228 No outstanding debt
2018 28,848 No outstanding debt
2019 136,450 No outstanding debt
2020 4,215 No outstanding debt
2021 3,569 No outstandingdebt
2022 3,525 No outstanding debt
Notes: Details regarding the City's outstanding debt can be found in the notes to the financial statements.
(1)Operating expenses includes transfers out because the administrative allocation and replacement reserve transfer
is built into the user fees. Operating expenses does not include interest and depreciation.
(2)The transfer in is included because a portion of the trunk connection charge associated with adding additional users to the water
system is designated to compensate prior years capital investment in water utility infrastructure and the treatment plant.
(3)Half of the facility financed by these bonds is leased to the Greater Minneapolis YMCA,their lease payments started
in 2008. Future YMCA lease payments will significantly reduce the City's obligation on debt service payments.
147
CITY OF ANDOVER,MINNESOTA
OUTSTANDING DEBT BY TYPE
Last Ten Fiscal Years
2013 2014 2015 2016
Cite of Andover's Outstanding Debt
Governmental activities
Revenue bonds $ 16,925,000 S - -
Abatement bonds 16,995,000 16,675,000 15,840,000 14,995,000
Certificates of indebtedness 680,000 2,140,000 1,915,000 2,125,000
Capital improvement bonds 1,470,000 970,000 470,000 -
Permanent improvement
revolving bonds 385,000 - - -
State aid bonds 290,000 60,000 - -
Street reconstruction bonds - - - -
Referendum bonds 1,390,000 1,250,000 1,105,000 960,000
Promissory note payable 983,593 786,874 590,155 393,436
Issuance premiums - - - -
Total governmental activities 39,119,593 21,881,974 19,920,155 18,473,436
Business-type activities
G.O.revenue bonds 6,875,000 6,310,000 5,720,000 9,030,000
Issuance premiums - - - 81,006
Total business-type activities 6,875,000 6,310,000 5,720,000 9,111,006
Total outstanding debt $ 45,993,593 $ 28,191,874 $ 25,640,155 $ 27,584,442
Total outstanding debt as a
percentage of personal income 4.84% 2.91% 2.57% 2.68%
Total outstanding debt per capita $ 1,465 S 893 $ 809 $ 853
148
Table 1.5
2017 2018 2019 2020 2021 2022
14,140,000 13,270,000 28,155,000 27,245,000 26,085,000 24,595,000
1,330,000 939,000 540,000 1,444,000 1,625,000 1,305,000
- 10,000,000 10,000,000 9,915,000 9,790,000 9,660,000
- - - - 7,135,000 7,135,000
810,000 655,000 495,000 335,000 170,000 -
196,717 - - - - -
- - 1,429,047 1,357,891 1,286,735 1,215,579
16,476,717 24,964,000 40,619,047 40,296,891 46,091,735 43,910,579
4,460,000 3,775,000 3,070,000 2,345,000 1,610,000 855,000
67,690 54,374 41,058 27,742 14,426 -
4,527,690 3,829,374 3,111,058 2,372,742 1,624,426 855,000
$ 21,004,407 $ 28,693,374 $ 43,730,105 $ 42,669,633 $ 47,716,161 $ 44,765,579
1.96% 2.55% 3.71% 3.45% 3.86% 3.38%
$ 647 $ 877 $ 1,330 $ 1,276 $ 1,459 $ 1,354
149
CITY OF ANDOVER,MINNESOTA
DEMOGRAPHIC AND ECONOMIC STATISTICS Table 16
Last Ten Years
City of Andover Anoka.County
Personal Personal Per Capita Unemployment
Year Population(1) Income(2) Population(3) Income(2) Income(3) Percentage
2013 31,692 S 960,235,908 339,534 S 10,287,540,666 S 30,299 5.0%
2014 31,874 976,842,478 341,864 10,477,106,008 30,647 4.2%
2015 31,704 997,851,696 342,500 10,779,845,000 31,474 3.6%
2016 32,335 1,027,444,625 345,957 10,992,783,675 31,775 3.8%
2017 32,470 1,073,165,970 348,357 11,513,547,207 33,051 3.5%
2018 32,728 1,089,842,400 350,357 11,666,888,100 33,300 2.8%
2019 32,882 1,177,372,892 356,921 12,779,913,326 35,806 3.1%
2020 33,448 1,236,840,144 358,921 13,272,180,738 36,978 5.4%
2021 32,708 1,236,591,356 367,018 13,875,849,526 37,807 2.6%
2022 33,058 1,324,204,306 369,018 14,781,754,026 40,057 1.8%
Notes: (1)Estimates from Metropolitan Council
(2)The personal income is calculated by taking the per capita income of Anoka County and multiplying it
by the population for both the City and County.
(3)Information from U.S.Census Bureau
150
CITY OF ANDOVER,MINNESOTA
PRINCIPAL EMPLOYERS Table 17
Current Year and Nine Years Ago
2022 2013
Percentage Percentage
of Total City of Total City
Taxpayer Employees Rank Employment Employees Rank Employment
Anoka Hennepin I.S.D.No.11 816 (1) 1 29.9% 760 1 31.8%
Walmart 335 2 12.3% 210 5 8.8%
Fairview Andover Clinic 300 3 11.0% 300 2 12.6%
Anoka County Sheriffs Office 250 4 9.1% 250 3 10.5%
Kottkes'Bus Service,Inc. 225 5 8.2% 225 4 9.4%
YMCA 220 6 8.0% 196 6 7.8%
Target 200 7 7.3% 170 7 7.1%
TE Connectivity 142 8 5.2% -
GAF Materials Corp 125 9 4.6% -
Anoka County Highway Department 120 10 4.4% 103 8 4.2%
Banker Hills Regional Park/Activity Center - 100 9 4.2%
Andover County Market - 85 10 3.6%
Total 2,733 100.0% 2,389 100.0%
Source: Minnesota Department of Employment and Economic Development
(1)Number of district employees that work in school buildings located within the City.
151
-This page intentionally left blank-
152
CITY OF ANDOVER,MINNESOTA
FULL TIME EQUIVALENT EMPLOYEES Table 18
CITY GOVERNMENT EMPLOYEES BY FUNCTION/PROGRAM
Last Ten Fiscal Years
Function/Program 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022
Governmental:
Administration 1.15 1.05 1.05 1.18 1.13 1.13 1.15 1.05 1.08 1.26
Human resources 0.02 0.03 0.03 0.03 0.03 0.03 0.03 0.07 0.08 0.08
City clerk 1.34 1.84 1.84 1.89 1.89 1.89 1.89 1.88 1.91 1.92
Elections 0.10 0.10 0.10 0.10 0.15 0.15 0.15 0.25 0.14 0.14
Financial administration 1.85 1.91 1.91 1.97 1.94 1.94 1.94 1.98 1.99 1.99
Information systems 0.91 0.91 0.91 0.91 0.91 0.91 0.91 0.91 0.91 0.91
Planning and zoning 3.70 3.90 3.90 4.00 4.03 4.03 4.05 4.05 4.05 3.70
Engineering 4.33 4.20 4.20 4.40 4.48 4.48 4.48 4.51 4.48 5.04
Facility Management 0.22 0.22 0.22 0.16 1.05 1.05 0.96 0.81 0.85 0.85
EDA general 0.85 0.35 0.35 0.10 0.05 0.05 - - - -
LRRWMO 0.20 0.15 0.15 0.07 0.07 0.07 0.07 0.09 0.09 0.08
Risk management 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10
Public Safety:
Fire 3.10 3.10 3.10 3.21 3.21 3.21 3.21 4.58 4.48 5.02
Protective inspection 3.93 3.93 3.93 4.05 4.03 4.03 4.03 4.18 4.19 3.60
Emergency management 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.02 0.05
Public Works:
Streets and highways 4.97 4.88 5.34 5.68 5.37 5.19 5.22 5.52 6.14 5.63
Snow and ice 3.44 3.95 1.98 2.23 1.83 2.83 3.79 1.85 1.92 2.95
Street signs 1.34 1 30 1.70 1.42 1.57 1.52 1.46 1.69 1.57 1.30
Natural Resource Preservation - - - 0.03 0.01 0.01 - - - -
Drainage and mapping - - - - - - - - 0.04 0.10
ROW management/utility 0.20 0.20 0.20 0.08 0.08 0.08 0.08 0.08 0.12 0.16
Water 4.56 452 4.39 4.87 4.55 4.52 4.86 5.22 5.25 5.41
Sewer 3.49 3.06 3.36 2.91 2.82 3.08 2.80 3.27 3.48 3.18
Storm sewer 2.23 2.25 2.50 2.39 2.94 2.38 2.08 1.95 1.58 2.12
Central equipment 2.91 2.81 3.10 3.07 3.31 3.25 3.19 3.43 3.41 3.40
Park&Recreation:
Park and recreation 7.14 733 8.77 8.58 8.65 8.30 7.80 9.00 8.34 8.16
Community center 3.10 3.10 3.10 3.16 3.22 3.22 332 3.33 4.10 4.74
Recycling 0.77 0.76 0.72 0.79 1.03 1.00 0.88 0.79 0.95 0.83
56.00 56A0 57.00 57.43 58.50 5850 58.50 60.64 61.27 62.72
Source: City Finance Deparhoent
Note: Employees are allocated to various departments based on the functions that they perform.
153
CITY OF ANDOVER,MINNESOTA
OPERATING INDICATORS BY FUNCTION/PROGRAM
Last Ten Years
Function/Program 2013 2014 2015 2016 2017
General government:
Registered voters n/a 19,772 n/a 22,051 n/a
Number of precincts n/a 10 n/a 10 n/a
Public safety:
Police:
Number of calls for services 10,659 10,319 10,400 14,736 15,636
Number of traffic citations 2,480 2,536 2,066 1,614 1,491
Number of patrol hours 29,200 29,200 29,200 29,200 29,200
Fire:
Fire responses 308 257 262 378 350
Emergency medical responses 863 838 336 594 500
Protective inspections:
Inspections 3,766 2,840 3,100 3,562 2,785
Residential permits 98 52 74 111 95
Other permits 1,716 1,898 2,744 2,536 2,653
Public works:
Streets and highways:
Asphalt streets maintained(miles) 192 195 200 204 190
Gravel roads maintained(miles) 7 7 6 6 6
Cul-de-sacs and dead ends maintained 328 332 345 348 350
Parks and recreation:
Number of City parks 50 51 52 53 53
Total acreage mowed 318 332 332 332 332
Ballfields maintained 28 28 29 27 27
Number of playgrounds 39 38 38 41 41
Soccer fields maintained 20 16 16 18 18
Trail maintained(miles) 35 33 33 34 34
Community center bookings(hrs):
Fieldhouse 11,831 12,182 11,919 12,701 12,900
Ice arena 2,543 2,593 2,643 2,606 2,702
Water:
New connections 108 43 57 97 91
Total customers 6,375 6,418 6,475 6,572 6,663
Annual consumption
(thousands of gallons) 947,201 827,574 885,886 850,307 873,457
Sanitary Sewer:
New connections 108 43 57 101 92
Total customers 7,281 7,324 7,381 7,482 7,574
Storm Sewer:
Total customers 10,583 10,626 10,700 10,812 10,948
Storm sewer lines maintained(miles) 73 75 76 77 78
Source: Various City Departments
154
Table 19
2018 2019 2020 2021 2022
20,433 n/a 23,545 n/a 23,227
10 n/a 10 n/a 10
14,724 18,164 14,080 13,114 12,846
1,585 1,246 908 884 898
29,200 29,200 29,200 29,200 28,480
365 472 375 404 545
740 790 667 1,340 1,528
2,844 3,574 4,791 5,100 4,917
58 116 139 140 100
2,396 2,758 2,983 3,427 2,949
194 195 202 205 205
7 7 7 7 7
353 357 358 363 364
53 53 53 53 53
336 336 338 340 340
27 27 27 27 27
42 42 42 42 42
20 20 20 20 20
37 39 40 41 41
13,796 13,891 7,771 16,200 16,524
3,288 3,156 2,585 4,650 4,743
62 90 187 203 220
6,725 6,815 6,912 7,018 7,132
975,387 829,721 1,024,844 1,144,573 1,051,087
58 36 123 124 231
7,632 7,668 7,755 7,792 7,986
10,971 11,118 11,249 11,304 11,153
78 80 81 85 86
155
CITY OF ANDOVER,MINNESOTA
CAPITAL ASSET STATISTICS BY FUNCTION/PROGRAM Table 20
Last Ten Years
Function/Program 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022
Public Safety:
Fire:
Stations 3 3 3 3 3 3 3 3 3 3
Fire vehicles 20 21 19 20 18 19 17 16 17 18
Protective inspections:
Vehicles 4 4 4 4 4 4 5 5 5 5
Public Works:
Sheets and Highways:
Streets(miles) 192 195 200 204 190 194 195 202 205 205
Street lights 1,231 1,240 1,248 1,260 1,268 1,282 1,301 1,326 1,348 1,373
Traffic signals 24 24 25 25 26 26 27 27 27 28
Parks and Recreation:
Parks 50 51 52 53 53 53 53 53 53 53
Ball fields 28 28 29 27 27 27 27 27 27 27
Soccer fields 20 16 16 18 18 20 20 20 20 20
Playgrounds 39 38 38 41 41 42 42 42 42 42
Trails(miles) 35 33 33 34 34 37 39 40 41 41
Community centers 1 1 1 1 1 1 1 1 1 1
Water:
Water treatment plants 1 1 1 1 1 1 1 1 1 1
Storage facilities 2 2 2 2 2 2 2 2 2 2
Water main(miles) 112 115 116 118 119 120 121 122 123 125
Connections 6,375 6,418 6,475 6,635 6,663 6,725 6,815 6,912 7,018 7,132
Sanitary sewer:
Sewer main(miles) 94 95 96 96 98 99 100 101 103 105
Connections 7,281 7,324 7,381 7,482 7,574 7,632 7,668 7,755 7,792 7,986
Number of lift stations 9 9 9 9 9 9 10 10 11 11
Storm sewer:
Storm sewer Lines(miles) 73 75 76 77 78 78 8o 81 85 86
156
IV. OTHER FINANCIAL INFORMATION
157
CITY OF ANDOVER,MINNESOTA
COMBINED SCHEDULE OF INDEBTEDNESS
December 31,2022
Authorized
Issue Maturity Interest and
Date Date Rate issue
GOVERNMENTAL ACTIVITIES:
Abatement Bonds:
2012C G.O.Abatement Bonds 12/27/2012 2/1/2031 1.00-3.00% S 17,315,000
2019A G.O.Abatement Bonds 8/1/2019 2/l/2040 3.00-5.00% 15,770,000
33,085,000
Certificates of Indebtedness:
2020A G.O.Equipment Certificates 3/19/2020 2/l/2024 4.00% 1,310,000
2021A G.O.Equipment Certificates 12/28/2021 2/l/2026 2.00% 630,000
Total certificates of indebtedness 1,940,000
Capital Improvement Bonds:
2018A G.O.Capital Improvement Plan Bonds 12/27/2018 2/1/2044 3.00-5.00% 10,000,000
Street Reconstruction Bonds:
2021A G.O.Street Reconstruction Bonds 12/28/2021 2/1/2030 1.00-2.00% 7,135,000
Referendum Bonds:
2010A G.O.Open Space Referendum Bonds 2/18/2010 2/1/2022 2.00-3.12% 1,660,000
Total bonded indebtedness 53,820,000
Issuance premiums -
Compensated absences payable -
Total governmental activities indebtedness 53,820,000
BUSINESS-TYPE ACTIVITIES:
General Obligation Revenue Bonds:
2009A G.O.Water Revenue Bonds 3/26/2009 2/1/2024 2.00-4.25% 1,025,000
2016B G.O.Water Revenue Refunding Bonds 12/7/2016 2/1/2023 2.00% 3,925,000
Total general obligation revenue bonds 4,950,000
Compensated absences payable -
Total business-type activities indebtedness 4,950,000
Total City indebtedness $ 58,770,000
158
Exhibit 1
Principal Payments
Prior Current Outstanding 2023 Payment
Years Year 12/31/22 Principal Interest Total
$ 6,765,000 $ 945,000 $ 9,605,000 $ 960,000 $ 249,281 $ 1,209,281
235,000 545,000 14,990,000 570,000 536,900 1,106,900
7,000,000 1,490,000 24,595,000 1,530,000 786,181 2,316,181
315,000 320,000 675,000 330,000 20,400 350,400
- - 630,000 150,000 11,100 161,100
315,000 320,000 1,305,000 480,000 31,500 511,500
210,000 130,000 9,660,000 290,000 334,006 624,006
- - 7,135,000 825,000 109,310 934,310
1,490,000 170,000 - - - -
9,015,000 2,110,000 42,695,000 3,125,000 1,260,997 4,385,997
- - 1,215,579 - - -
- - 894,134 - - -
9,015,000 2,110,000 44,804,713 3,125,000 1,260,997 4,385,997
790,000 80,000 165,000 80,000 5,252 85,252
2,560,000 675,000 690,000 690,000 6,900 696,900
3,340,000 755,000 855,000 770,000 12,152 782,152
- - 183,030 - - -
3,340,000 755,000 1,038,030 770,000 12,152 782,152
$ 12,355,000 $ 2,865,000 $ 45,842,743 $ 3,895,000 $ 1,273,149 $ 5,168,149
159
CITY OF ANDOVER,MINNESOTA
SCHEDULE OF TAX CAPACITY RATES AND LEVIES Exhibit 2
Taxes Payable
2023 2022
Tax capacity values $ 40,210,548 $ 40,209,496
Captured tax increment value (122,976) (123,268)
Fiscal disparities-contribution (1,414,808) (1,414,808)
Local taxable value 38,672,764 38,671,420
Fiscal disparities-distribution 6,037,850 6,037,850
Adjusted tax capacity $ 44,710,614 $ 44,709,270
2023 2022
Certified Tax Capacity Certified Tax Capacity
Levy Rate Levy Rate
General Revenue Levy:
General Fund $ 10,736,789 $ 9,998,370
Community Center Operations Levy 155,000 155,000
Capital Equipment/Projects 275,000 275,000
Facility Maintenance Reserve 355,000 355,000
Parks Projects 15,000 15,000
Road and Bridge 1,619,190 1,409,579
Pedestrian Trail Maintenance 110,408 108,243
Total General Revenue Levy 13,266,387 24.046% 12,316,192 27.591%
Debt Service Levy:
2012C G.O.Abatement Bonds 969,745 974,628
2018A G.O.Capital Improvement Plan Bonds 612,794 617,519
2019A G.O.Abatement Bonds 1,028,792 1,014,065
2020A G.O.Equipment Certificate 376,740 374,850
2021A G.O.Equipment Certificate 174,773 170,000
2021A G.O.Street Recon 603,863 600,000
Total Debt Service Levy 3,766,697 6.827% 3,751,062 8.403%
Lower Rum River Watershed 40,000 0.200% 40,000 0.251%
Total $ 17,073,084 31.073% $ 16,107,254 36.245%
160
CITY OF ANDOVER,MINNESOTA
SCHEDULE OF DEFERRED TAX LEVIES Exhibit 3
GENERAL OBLIGATION BONDS
December 31,2022
Capital Street
Abatement Abatement Certificates of Certificates of Improvement Reconstruction Total
Taxes Bonds Bonds indebtedness Indebtedness Plan Bonds Bonds Deferred Tax
Payable 2012C 2019A 2020A 2021A 2018A 2021A Levies
2023 $ 969,745 $ 1,028,782 $ 376,740 $ 174,773 $ 612,794 $ 603,863 $ 3,766,697
2024 1,273,650 1,178,782 - 174,825 658,094 1,001,658 4,287,009
2025 1,269,824 1,177,207 - 176,715 662,557 999,138 4,285,441
2026 1,268,689 1,179,307 - - 660,719 1,001,553 4,110,268
2027 1,265,513 1,174,320 - - 663,344 1,003,548 4,106,725
2028 1,265,404 1,178,257 - - 662,189 999,086 4,104,936
2029 1,273,309 1,177,627 - - 660,719 998,844 4,110,499
2030 1,274,070 1,175,737 - - 658,934 - 3,108,741
2031 1,278,900 1,177,837 - - 662,084 - 3,118,821
2032 - 1,176,997 - - 659,512 - 1,836,509
2033 - 1,175,370 - - 661,874 - 1,837,244
2034 - 1,178,205 - - 658,514 - 1,836,719
2035 - 1,174,845 - - 659,498 - 1,834,343
2036 - 1,175,947 - - 659,380 - 1,835,327
2037 - 1,176,105 - - 658,750 - 1,834,855
2038 - 1,175,317 - - 662,858 - 1,838,175
2039 - 1,178,835 - - 660,358 - 1,839,193
2040 - - - - 662,576 - 662,576
2041 - - - - 663,364 - 663,364
2042 - - - - 658,166 - 658,166
2043 - - - - 662,918 - 662,918
$11,139,104 $19,859,477 $ 376,740 $ 526,313 $ 13,829,202 $ 6,607,690 $52,338,526
161
CITV OF ANDOVER,MINNESOTA
SCHEDULE OF FUND TRANSFERS Exhibit 4
De-robe,31,2022
Transfer Transfer
In Out
General Fund
Water EF S 96.091 S - General Fund Admin Allocation
Scorer EF 79.329 - General Fund Admin Allocation
Storm Sewer EF 21.661 - General Fund Admin Allocation
Economic Development Authority SRF - 150,000 Concrete median on Bunker Lake Blvd NW
Trail and Tmasportaton CPF 400,000 Pedestrian Trail System
Total General Fund 197,081 550,000
Special Revenue Funds(SRF)
Economic De-clopment Authority SRF
General Fund 150.000 Concrete median on Bunker Lake Blvd NW
Community Center SRF
2012C GO Abatement Bonds DST 300,000 Debt Service Allocation
Right of Way Management/Utility SRF
Road and Bridge CPF 7,400 Roadway Degradation
Total Special Revenue Funds 150,000 307,400
Debt Service Funds(DSF)
2010 GO Open Space Referendum DSF
Capital Equipment Reserve CPF 84,328 Close Debt Service Fund
2012C 00 Abatement Bond,,DSF
Community Center SRF 300.000 Dcbt Scrvicc Allocation
201 SA GO Capital improvement Plan Bonds DSF
Water EF 22.650 - Debt Service Allocation
Sewer EF 22.650 Debt Service Allocation
45.300
2019A GO Abatement Bonds DSF
Park Dedication CPF 163,143 Debt Service Allocation
2021 A GO Street Reconstruction Bonds DSF
Permanent Improvement Revolving CPF 400,000 Debt Service Allocation
2021 A GO Equipment Certificates DSF
2021 A GO Equipment Certificates CPF 170,000 2021 Equipment Levy
Total Debt Service Funds 908,443 254,328
Capital Projects Funds(CPF)
Water Trunk CPF
Water EF 300,000 - Replacement Reserve
Water EF 152,877 Debt Service Allocation
300.000 152,877
Sewer Trunk CPF
Sewer EF 400.000 Replacement Reserve
Road and Bridge CPF
Right of Way Management/Utility SRF 7.400 Roadway Degredation
Park Dedication CPF
2019A GO Abatement Bonds DST 163,143 Debt Service Allocation
Trail and Transponaloo CPF
General Fund 400.000 Pedestrian Trail System
Capital Equipment Reserve CPF
2010 GO Open Space Referendum DSF 84.328 - Close Debi Service Fund
Storm Sewer EF 23.500 Debt Service Allocation
107,828
2021A GO Equipment Certificates CPF
2021 A GO Equipment Certicates DSF 170,000 2021 Equipment Levy
Permanent Improvement Revolving CPF
2021 A GO Street Reconstruction Bonds DSF 400,000 Debt Service Allocation
Total Capital Projects Funds 1,385,228 716,020
Enterprise Funds(EF)
Water EF
Water Trunk CPF 152.877 - Debt Service Allocation
General Fund - 96,091 General Fund Admin Allocation
Water Trunk CPF - 300,000 Replacement Reserve
2018A GO Capital Improvement Plan Bonds CPF 22,650 Debt Service Allocation
152.877 418,741
Sewer EF
General Fund - 79,329 General Fund Admin Allocation
Sewer Trunk CPF - 400,000 Replacement Reserve
2018A GO Capital Improvement Plan Bonds CPF 22,650 Debt Service Allocation
501,979
Storm Sewer EF
General Fund - 21,661 General Fund Admin Allocation
Capital Equipment Reserve CPF 23,500 General Fund Admin Allocation
45,161
Total Enterprise Funds 152,877 965,881
Total All Funds $ 2,793,629 S 2,793,629
162