2002 City of Hopkins, MN Annual Report COMPREHENSIVE ANNUAL
FINANCIAL REPORT
of the
CITY OF HOPKINS
1010 FIRST STREET SOUTH
HOPKINS, MINNESOTA 55343
for the
Year Ended
December 31, 2002
DEPARTMENT OF FINANCE
Lori Yager, Finance Director
MEMBER OF GOVERNMENT FINANCE OFFICERS' ASSOCIATION
OF THE UNITED STATES AND CANADA
TELEPHONE: (952) 935-8474
(This page intentionally left blank)
THE CITY OF HOPKINS, MINNESOTA
COMPREHENSIVE ANNUAL FINANCIAL REPORT
YEAR ENDED DECEMBER 31, 2002
TABLE OF CONTENTS
Exhibit Pave
L INTRODUCTORY SECTION
City Officials 2
Administrative Organization Chart 3
Letter of Transmittal from the City Manager
and Finance Director 5
Certificate of Achievement for Excellence in
Financial Reporting 18
II. FINANCIAL SECTION
Independent Auditors' Report 20
A. General Purpose Financial Statements
Combined Balance Sheet - All Fund Types and
Account Groups A 22
Combined Statement of Revenues, Expenditures,
and Changes in Fund Balances - All
Governmental Fund Types A-1 24
Combined Statement of Revenues, Expenditures,
and Changes in Fund Balances - Budget and
Actual - General and Special Revenue Fund Types A-2 26
Combined Statement of Revenues, Expenses, and
Changes in Retained Earnings - All
Proprietary Fund Types A-3 28
Combined Statement of Cash Flows - All
Proprietary Fund Types A-4 29
Notes to Financial Statements 30
THE CITY OF HOPKINS, MINNESOTA
COMPREHENSIVE ANNUAL FINANCIAL REPORT
YEAR ENDED DECEMBER 31, 2002 _
Exhibit Page
B. Combininiz Individual Funds and Account
Groups Statements and Schedules
General Fund
Balance Sheet B 49
Statement of Revenues, Expenditures, and Changes —
in Fund Balance - Budget and Actual B-1 50
Schedule of Revenues - Budget and Actual B-2 51
Schedule of Expenditures - Budget and Actual B-3 52 —
Special Revenue Funds
Combining Balance Sheet C 58
Combining Balance Sheet - Tax Increment Ca 60
Combining Statement of Revenues, Expenditures, and —
Changes in Fund Balances C-1 62
Combining Statement of Revenues, Expenditures, and
Changes in Fund Balances - Tax Increment Ca-1 64
Statements of Revenues, Expenditures, and Changes
in Fund Balance - Budget and Actual:
State Chemical Assessment Team Fund C-2 66 _
Economic Development Fund C-3 67
Real Estate Purchases and Sales Fund C-4 68
Para-Transit Fund C-5 69 _
Housing Rehab Fund C-6 70
Parking Fund C-7 71
Section 8 Housing Fund C-8 72 _
Cable TV Fund C-9 73
Depot Coffee House Fund C-10 74
Art Center Fund C-11 75
Tax Increment 1.1 Fund C-12 76 —
Tax Increment 1.2 Fund C-13 77
Tax Increment 2.1 Fund C-14 78
Tax Increment 2.6 Fund C-15 79 —
Tax Increment 2.7 Fund C-16 80
Tax Increment 2.8 Fund C-17 81
Tax Increment 2.9 Fund C-18 82 —
Tax Increment 2.10 Fund C-19 83
Tax Increment 2.11 Fund C-20 84
THE CITY OF HOPKINS, MINNESOTA
COMPREHENSIVE ANNUAL FINANCIAL REPORT
YEAR ENDED DECEMBER 31, 2002
Exhibit Page
Debt Service Funds
Combining Balance Sheet D 86
Combining Statement of Revenues, Expenditures,
and Changes in Fund Balance D-1 88
Capital Projects Funds
Combining Balance Sheet E 91
Combining Statement of Revenues, Expenditures, and
Changes in Fund Balance E-1 92
Enterprise Funds
Combining Balance Sheet F 94
Combining Statement of Revenues, Expenses, and
Changes in Retained Earnings F-1 96
Combining Statement of Cash Flows F-2 98
Internal Service Fund
Balance Sheet G 101
Statement of Revenues, Expenses, and
Changes in Retained Earnings G-1 102
Statement of Cash Flows G-2 103
Agency Fund
Statement of Changes in Assets and Liabilities H 105
Account Groups
Schedule of General Fixed Assets I 107
Schedule of General Fixed Assets by Function
and Activity I-1 108
Schedule of Changes in General Fixed Assets
by Function and Activity I-2 109
Statement of General Long-Term Debt J 110
THE CITY OF HOPKINS, MINNESOTA
COMPREHENSIVE ANNUAL FINANCIAL REPORT
YEAR ENDED DECEMBER 31, 2002 -
Table Page
III. STATISTICAL SECTION
Governmental Fund Types - Expenditures by Function 1 113 —
Governmental Fund Types - Revenues by Source II 114
Property Tax Levies and Collections III 115 —
Assessed Value/Tax Capacity Value and Market Value
of All Taxable Property IV 116 —
Property Tax Rates - Direct and Overlapping Governments V 117
Special Assessments Billings and Collections VI 118
Ratio of Net Bonded Debt to Assessed Value/Tax —
Capacity Value and Net Bonded Debt Per Capita VII 120
Computation of Legal Debt Margin VIII 122 —
Computation of Direct and Overlapping Debt
Including Debt Ratios IX 123
Ratio of Annual Debt Service Expenditures for General
Bonded Debt to Total General Expenditures X 124 —
Revenue Bond Coverage - Water, Sewer and Storm Sewer
Revenue Bonds XI 125 —
Demographic Statistics XII 126
Construction and Property Value XIII 127 —
Principal Taxpayers XIV 128
Miscellaneous Statistical Facts XV 129
I
NOI1D3S AIO1D(1a0211N
NOUDIS
12 WIN IVIDNVNIA ivnNNV IAISNIH321dW0:)
V-LOSINNIW 'SNINdOH AO Alli
THE CITY OF HOPKINS, MINNESOTA
COMPREHENSIVE ANNUAL FINANCIAL REPORT
YEAR ENDED DECEMBER 31, 2002 _
CITY OFFICIALS
December 31, 2002
CITY COUNCIL
Term
Expires
Eugene Maxwell, Mayor 12-31-03
Bruce Rowan Councilmember 12-31-05
Diane Johnson Councilmember 12-31-03
Karen Jensen Councilmember 12-31-03
Rick Brausen Councilmember 12-31-05
CITY MANAGER
Steven C. Mielke
FINANCE DIRECTOR
Lori Yager
2
CITIZENS
Boards & CITY
Commissions COUNCIL City Attorney
Administrative City Manager MIS
Services City of
Minnetonka
Community Planning & Fire Police Public Works Recreation
Services Finance Economic
W Development
• Economic Building Maint. &
Assessing
• Fire & Medical Patrol
Development Investigation Res Equipment
• City Clerk Accounting p
Housing Services
• Elections Payroll Prevention Communication
• Planning & Engineering
• Inspections Utility Billing Emergency Crime
Reception Zoning Preparedness Prevention Parks & Forestry
p Public Housing Street/Traffic/
Refuse
• Water& Sewer
• Facilities Mgmt.
Activity Center
Center for the Arts
Depot
Pavilion/Ice Arena
(This page intentionally left blank)
4
City of qfopkins
1010 First Street South •Hopkins, 55343-7573 • Phone:952-935-8474 • Fax•952-935-1834
Wed address:www.hopkinsmn.com
June 6, 2003
To the Honorable Mayor, Members of the Hopkins City Council and the Citizens of the
City of Hopkins, Minnesota :
The Comprehensive Annual Financial Report (CAFR) of the City of Hopkins, Minnesota (the City)
for the fiscal year ended December 31, 2002 is hereby submitted. This report was prepared by the
City's Finance Department. Responsibility for both the accuracy of the presented data and the
completeness and fairness of the presentation, including all disclosures, supporting schedules,
statistical tables, etc., rests with the City. We believe the data, as presented, is accurate in all
material respects; that it is presented in a manner designed to fairly set forth the financial position
and results of operations of the City as measured by the financial activity of its various funds; and
_ that all disclosures necessary to enable the reader to gain the maximum understanding of the City's
financial affairs have been included.
The organization, form and contents of this report were prepared in accordance with standards
prescribed by the Governmental Accounting Standards Board (GASB), the Government Finance
Officers Association of the United States and Canada, the American Institute of Certified Public
_ Accountants,the State Auditor's Office— State of Minnesota and the City Charter.
The CAFR is presented in three sections: introductory, financial and statistical. The introductory
section includes a list of principal officials, the organizational chart, the City Manager's letter and
this transmittal letter. The financial section includes the independent auditors' report on the
financial statements, the general-purpose financial statements and the combining and individual
funds and account group financial statements. The statistical section contains selected financial and
demographic information pertinent to the City and is generally presented on a multiyear basis.
Reporting Entity Components
The report includes all funds and account groups of the City, including the city's Housing and
Redevelopment Authority (HRA). The City provides a full range of services including general
government, public safety, public works, community development and parks and recreation. In
addition to general municipal activities, the City provides water, sewer, storm sewer, and refuse
services. Low income rental housing is a function of the HRA. The Hopkins Fire Relief
Association has not met the established criteria for inclusion in the reporting entity, and accordingly
is excluded from this report.
5
Partnering with the Community to Enhance the Quality of Life
•Inspire•Educate•Involve•Communicate•
Governmental Structure
Background
Hopkins was first settled in 1853 and was incorporated as the Village of West Minneapolis in 1893.
The name was changed in 1928 to Hopkins after one of the early residents. The original territory of
incorporation was three square miles, but successive annexation since 1946 has enlarged this area by —
one-third. In 1947, the residents of the area adopted a City Charter with a Council/Manager form of
government. The governing council is responsible, among other things, for passing ordinances, —
adopting the budget, appointing committees and hiring the government's manager and the
government's attorney. The government's manager is responsible for carrying out the policies and
ordinances of the government, for overseeing day-to-day operations of the government and for —
appointing the heads of the government's departments.
The City of Hopkins, consisting of 2,504 acres, is located in Hennepin County on the westerly —
fringe of the Minneapolis urban area. The City, as part of the Minneapolis-St. Paul metropolitan
complex, is readily accessible by the many highways and railways leading into the area. This easy
access prompted steady growth for the City of Hopkins during its formative years. In response to —
this growth the City developed goals of working towards a planned community, with its policies
directed toward sound ratios of residential, commercial and industrial components, with the current
tax base approximately 76% single family residential and apartments, and 24% commercial-
industrial. The city's population has stabilized due to the fact that the City is largely developed and
the national trend toward the lowering of persons per household.
The city council and staff along with an organized group of concerned partners, determined what the
Vision and the Mission of the City of Hopkins should be. Participation in this project was very high
and the resulting Vision and Mission are as follows: —
Communi . Vision
Creating a Spirit of Unity—Hopkins will be a community where —
• People are treated with respect
• People participate in building culture, character and common bonds —
• Business growth throughout the City is supported while maintaining a vibrant City center
• People feel safe, support outstanding schools and celebrate cultural heritages
• People enjoy quality public services, parks and housing —
City of Hopkins Mission
Partnering with the Community to enhance the quality of life,
— Inspire, Educate, Involve, Communicate
Economic Condition and Outlook
Although the nation is experiencing a weak economy, Hopkins continues to show strong economic
and redevelopment activities within the city. The valuation of new construction in 2002 was $17.9 —
million dollars. This development activity has been the result of a good development market in the
Hopkins area along with successful planning on the part of the city council and city staff.
6
Significant projects completed or begun in 2002 include the following:
Actiyiiy Valuation
Commercial Additions/Alterations:
Hopkins House $ 700,000
Market Place Lofts $ 8,000,000
Walgrens $ 900,000
Walser addition $ 2,000,000
St. Therese $15,200,000
Nine Mile Cove $10,800,000
Regency Residential Development $ 9,900,000
Tech Center $ 900,000
Blake School $ 2,700,000
Efforts are being made for continued development and growth for 2003 and beyond. It is
anticipated that approximately $84,000,000 of construction will also take place in the City of
Hopkins during 2003/2004.
Some anticipated projects during this period include the following:
Project Valuation
North Annex Redevelopment $40,000,000
—. Alliant Tech Center $ 2,000,000
Excelsior Boulevard Reconstruction $10,000,000
Market Place Lofts $ 8,000,000
Regency residential development $10,200,000
Public Works and Fire Facility $10,760,000
Police Facility remodel $ 3,000,000
The City of Hopkins has developed a strategic plan for economic development. As a part of this
plan, the City of Hopkins intends to pursue various development and redevelopment efforts
throughout the City. Several projects are anticipated.
In 2003, projects to be constructed include the redevelopment of the eastside of downtown, the
redevelopment of the Alliant Tech property and parking lots and the public works and fire station
_ facilities. These developments will have major impacts on the community. Specialized planning is
taking place to ensure that these developments occur so as to benefit the community and residential
neighborhoods.
Over the course of about six years, major improvements will continue to be made to County Road 3
along its entire length in Hopkins. The first phase of improvements occurred in 1998 between
Shady Oak Road and 11th Avenue South. The second phase occurred in 1999 and 2001, between
Highway 169 to 11th Avenue South. The third phase will occur in the year 2002 and 2003 between
Highway 169 and Blake Road. The final phase runs from Blake Road to Meadowbroke Road and
should occur in 2004 and 2005.
7
Major Initiatives
For the Year —
For 2002, the staff, following specific directives of the council and the manager, has been involved
in a variety of projects throughout the year. These projects reflect the government's commitment to '—
ensuring that its citizens are able to live and work in a safe environment and that the needs for
services are met.
In 2002 we accomplished our annual street repair and improvements, at a cost of approximately
$2,255,000. The projects included replacing infrastructure, roadway surface, curb and gutters, _
parking lot surfaces and alley reconstruction. The city began architectural designs of its public
works and fire station facility projects in 2002. The water department continues to convert its'
meter reading system to radio read. Storm Sewer reconstruction projects totaling $329,000, were —
completed in 2002.
Major redevelopment of a section of the east end of downtown between 7th and 8th Avenues, began —
in 2001 and will be completed in 2003. The redevelopment is called "Market Place Lofts" and
consists of a combination of residential condominiums above retail space. The project is a huge
success with the residential values ranging from $180,000 to $400,000 per unit. Another area of —
redevelopment is also on the east side of town in an area that has light manufacturing and
residential. New single and multiple family residential properties were being built in 2002 and will
be completed in 2003. This redevelopment project is also a huge success, turning an old parking lot
into valuable property.
The city is also in the process of remodeling the old fire station to provide more space for the police —
department. This department is very crowded and currently falls short of meeting some basic
standards for the handling of witnesses and criminals.
For the Future
A systematic citywide sidewalk rehab program was initiated in 1992. Each year one quadrant is —
inspected and necessary repairs made. A sidewalk/trail plan was developed and implemented in
2002, which guides future improvements and connections to regional trails.
Hennepin County has included in its five year CIP an improvement project relating to County Road
3 extending through the entire City of Hopkins. Improvements include street surface, widening,
lighting, landscaping, sidewalks, and trails. These improvements will continue to take place during
2003-2005.
The City has established a street reconstruction and storm sewer program based on a street condition
survey and storm water management program. The streets found in poor condition and future
problem streets will be systematically included for repairs in the five-year Capital Improvement _
Plan.
8
Financial Information
The City's accounting records are maintained on the accrual, or modified accrual basis, as
appropriate. Budgetary control is maintained by Department Managers and an encumbrance system
whereby purchase orders are audited to ensure the adequacy of funds prior to their release to
vendors. The budget is adopted by, and can be amended by, the City Council. The expenditure
budget may not legally be exceeded at the level of control presented in Exhibit A-2. A contingency
appropriation is established for this purpose.
In developing and evaluating the City's accounting system, consideration is given to the adequacy of
internal accounting controls. These controls are designed to provide reasonable, but not absolute
assurance regarding (1) the safeguarding of assets against loss from unauthorized use or disposition;
and (2) the reliability of financial records for preparing financial statements and accountability for
assets. The concept of reasonable assurance recognizes that: (1) the cost of control should not
_ exceed the benefits likely to be derived, and (2) the evaluation of cost and benefits requires
estimates and judgments by management.
All internal control evaluations occur within the above framework. We believe that the City's
internal accounting controls adequately safeguard assets and provide reasonable assurance of proper
recording of financial transactions.
Capital financing of the major City improvements is provided for the most part through the
Permanent Improvement Revolving (PIR) Fund financed by the issuance of improvement bonds.
Another source of capital financing is through general obligation bonds, tax increment bonds, or
revenue bonds.
Time lags in revenue collections in some of the funds may make it necessary to arrange short-term
operating loans between funds from time to time. These loans are most often arranged through the
General Fund, but at times may be arranged through other fund groups, such as Special Revenue,
-- Enterprise or Capital Projects groups.
General Government Functions
General municipal services are accounted for in the City's General Fund. Specific special
governmental activities are presented within the City's Special Revenue funds. Exhibit A-2
indicates the transactions for these funds compared to the budgeted amounts. Actual revenues for
the general fund were under budget by $7,765. Actual revenues for the special revenue funds were
under budget by $530,000.
Property taxes make up 70% of the general fund revenue sources. Current property tax collections
were 93.7% of the tax levy in the year 2002. The next largest source for the general fund is
intergovernmental revenues, at 18%. Intergovernmental revenues increased in 2002, as a result of
two new aids. Market Value Credit aid, which is a direct reduction of the amount of property taxes
collected from taxpayers, and Rental Credit aid, which is an aid to assist cities with large rental
property tax capacity values that were lowered in 2001. The other revenues in the general fund
represent only 12% of the funding sources and include interest, charges for services, permits,
_ licenses and fines.
9
The following chart presents a comparative analysis of general fund revenues and other financing
sources:
General Fund Revenue and Other Financing Sources, 2002, 2001, 2000 and 1999
Actual
Other
Interest
Charges ❑1999
■2000
Fines
132001
—
Intergov't ■2002
License & Permits
Taxes .
$0 $1,000 $2,000 $3,000 $4,000 $5,000 $6,000 —
(in thousands)
Total net tax capacity of the City for taxes collected in 2002 (including the fiscal disparities tax
capacity contribution and distribution) was $10,658,607. This 2002 tax base reflects a decrease of
$2.8 million over 2001. The decrease is a direct result of changes made to the classification rates by
the state legislature. The total tax capacity value figure is also net of the tax capacity pledged to tax —
increment projects, which amounted to $1,578,808, which is 14% of the gross tax capacity base.
General Fund expenditures and transfers totaled $8,154,487 in 2002, an overall increase of
approximately 6.1% from the comparable figure for 2001. This increase over 2001 is primarily
from an increase in salaries and benefits. Salaries and benefits represent 75% of general fund
expenditures. Total expenditures were below budgeted amounts by $224,979. The general —
government budget within the general fund was decreased by $53,350 to use in 2003 for additional
contingency budget to cover unforeseen increases in operational costs. The public safety budget
was decreased by $6,548 to carry over unspent grant revenues in the police area. The community —
development budget was increased by $15,000 from 2001 carryovers of budget for unfinished
projects. The public works budget was decreased by $6,400 to carry over unspent materials and —
supplies into 2003. The recreation budget was by increased by $5,300 from a 2001 budget carry
over for the Activity Center. The capital expenditure budget increased by $109,275 primarily for
police mobile data transmitters which the city received a grant for in 2002.
10
The following table shows previous year-end General Fund equities, as compared to the adopted
appropriations for the following year:
-- Original Fund Equity
General Fund Beginning of Year % of
Budget Amount Budget
1999 7,158,664 2,834,758 39.6
2000 7,418,723 2,877,512 38.8
2001 7,740,084 3,126,627 40.0
2002 8,346,588 3,198,705 38.0
The following chart presents a comparative analysis of general fund expenditures and other uses:
General Fund Expenditures and Other Financing Uses
2002, 2001, 2000 and 1999
$4,000_'----
i
$3,500
$3,000 1
$2,500
- $2,000 ■2002
1
02001
$1,500 ■2000
$1,000 01999
$500
_ $0
General Public Comm. Public Recreation Capital
Gov. Safety Dev. Works
Li uidi
_ The City's financial position remained strong during 2002. Unrestricted cash and investment
balances at year-end totaled $21,948,909, which provides the liquidity necessary to avoid short-term
borrowing.
The unreserved General Fund balance is available to provide funding for working capital until tax
settlements and state aids are received in June and December of each year, to provide funds for
unknown events and emergencies, which could have an adverse effect on the fund. A strong fund
balance should be at least 50% of the "gross" General Fund property tax levy (before netting of
fiscal disparities distribution) for the following year. Through sound financial management, the
City has achieved this goal in 2002 as well as previous years.
In addition to the City's strong financial position in the General Fund, the other city fund groups
remained strong as well. The Special Revenue Fund groups have a fund balance of $8,086,307,
11
which is 165% of the expenditures and other financing uses incurred in 2002. The excess of special
revenue funds are ear marked to be used on redevelopment projects for the city and early retirement
of debt service in TIF districts. The capital project funds currently have $14,213,577 in fund
balance, which is to be spent in 2003 - 2004 primarily on the new fire station and public works
facility project and on the County Road 3 project. The Enterprise Funds have a working capital
balance in excess of$2,176,917, which will provide funds for the upcoming water, sewer and street
projects. The Internal Service Funds have a working capital balance in excess of$2,084,864, which
will provide funds for future capital purchases and deductible insurance claims.
Special Revenue Funds
State Chemical Assessment Fund
This fund is established to record the activity of the Chemical Assessment Team. The source of
revenue for this fund is a State Chemical Assessment Grant which fully reimburses the City for its'
expenditures relating to chemical assessment team expense.
Economic Development
The development of the City is enhanced through this fund. Revenues received are designated for
housing and development projects that are in line with strategic plans of the council and the
community for the City of Hopkins. The undesignated fund balance is currently $760,249.
Real Estate Purchases & Sales
The proceeds of this fund are to be used to improve city buildings. The fund balance is currently
$60,705.
Community Development Block Grant
This revenue source continues to provide financial support and facilities for lower income areas and
individuals through housing rehabilitation grants and loans. Grant revenues to the City were
$211,593.
Tax Increment Funds
The City has established several tax increment financing districts, which have assisted with the
redevelopment of its City. The positive impact of these districts can be seen in a variety of projects
such as the Oaks of Mainstreet development and the Entertainment Center downtown. The _
revenues generated in these funds are designated to pay for debt that was issued to help pay for the
projects or to finance the projects themselves. The total fund balance of all tax increment districts is
currently $4,114,849 and is reserved for debt service payments, specific projects within each district _
and for an outstanding receivable.
Para-Transit
This fund accounts for revenues received from the Metropolitan Council and from user fees to
provide for low cost transportation in Hopkins. This fund is partially funded through the general
fund if necessary.
12
— HousingRehab
ehab
This fund receives money primarily from the Community Development Block Grant program,
housing fees and loan interest. This fund accounts for housing rehabilitation activities in the City of
Hopkins. The fund balance is currently $1,109,843.
Parking
This fund records and accounts for parking fees and operations, assessments charged to users and
maintenance of the parking facilities. The fund balance is currently $295,483.
— Section 8 Housing
This fund administers the HUD Section 8 rental assistance program. Current fund balance is
$78,317.
Cable TV
This fund records and accounts for franchise fee revenue from a five-city joint venture cable TV
franchise administered under the Southwest Suburban Cable Commission. The fund balance is
currently $291,896.
Depot Coffee House
The Depot Coffee House is a student-run gathering place for students. Here the City records the
_ expense and revenue of retailing coffee and miscellaneous food products. The teen center, which is
part of the Depot Coffee House, is funded by grants and contribution from local supporters.
Art Center
The Art Center has been in operation for five years. In 2002, the city merged the Art Center
Construction special revenue fund with the Art Center enterprise fund to make one special revenue
fund for the Art Center operations called the "Art Center". Socially, the Art Center is a success in
many aspects and the city is very happy to have constructed such a structure in its' downtown area.
The Art Center is financially supported by the economic development fund and the cable franchise
fund. The working capital balance for the fund is a negative $254,671. The negative working
capital is a combination of operating losses and the continued payback of a loan from the general
fund. The city is determined to have the Art Center continue to be a wonderful community asset.
Debt Administration
Net bonded debt per capita and percentages of net debt to market value are useful indicators of a
city's debt position to municipal management, citizens, and investors. Total outstanding bonded
_ debt as of December 31, 2002, totaled $33,301,194. Redevelopment issues total $7,841,194, the
last bond matures February 1, 2023; $1,305,000 are park and recreational bonds - due February 1,
2011; $4,800,000 are revenue bonds - due February 1, 2015; $2,490,000 are special assessment
_ bonds - due February 1, 2013; $6,105,000 are housing improvement bonds — due February 1, 2021
and $10,760,000 are Housing and Redevelopment Authority (HRA) lease revenue bonds — due
February 1, 2023. Repayment plans for bonds and interest are well on course. Tax levy is
_ anticipated for the park and recreation bonds, special assessment bonds and the HRA lease revenue
bonds.
13
The City has maintained its Al rating from Moody's Investors Service on all issues for several
years. In 2000 the city received an upgrade in its rating from Standard and Poors from A+to a AA-.
The upgrade in rating is attributed to continued development of commercial and residential —
properties, strong growth in market values, above average and increasing wealth levels, balanced
operations and solid fund balances and moderate debt levels. At December 31, 2002, $11,762,000
of general obligation debt was applicable to the legal debt limit of$19,424,044. --
Capital Project Funds
The proceeds of general obligation bond issues, federal, state and local grants, special assessments
and park dedication fees are accounted for in Capital Project Funds until the particular projects are _
completed. The City utilizes a five-year Capital Improvement Plan, outlining projected costs and
probable sources of funding for proposed various capital improvement projects. Any unreserved
fund balances are used as proposed in the Capital Improvement Plan, when projects are ordered by —
the city council.
Enterprise Funds —
Water Utility Fund -- The City maintains a complete water delivery system from wells through
filtration plants to the tap. The net working capital position for the water utility fund is currently —
$981,609, a decrease of$214,165 over 2001. This fund issued bonds in the amount of$2,060,000
in 2000 to pay for repainting of two water towers, repair of a lift station and implementation of radio
read. The fund experienced a net loss this year of$(23,895). The water utility rate is projected to
increase in 2005 to help pay for debt and future projects.
Sewer Utility Fund -- The City maintains a sewer collection system only, with the treatment —
operation being performed by the Metropolitan Waste Control Commission. The City then pays a
treatment fee based on sewage flow. Working capital balance has remained very strong in this fund
prompting a rate decrease in 1999. It is projected in the capital improvement plan that the city will
be using approximately $500,000 of the working capital balance in 2004 to reconstruct lift station
#7. The current working capital balance for this fund is $1,158,778, a decrease of$170,260 over
2001. The sewer fund experienced a net loss this year of($218,345). The sewer utility rate may
need to increase in 2006 to replenish the working capital balance.
Refuse Utility Fund -- City employees and equipment provides a fully automated refuse service and —
a recycling operation. The City assumed the refuse pickup function from a contractor in 1986. The
refuse rates have remained stable since 1991. The recycling rates increased in 2002 to support the —
cost of recycling. A brush and yardwaste charge may be implemented in 2003 to offset the costs of
providing this service to our citizens. This fund realized a net loss this year of $(2,181). The
working capital balance for this fund is $598,396, an increase of$20,605 over 2001. _
Storm Sewer Utility Fund -- This fund was created in 1989 to consolidate infrastructure replacement
activities. A storm sewer fee was added to all properties, based on acreage contribution of runoff. _
The initial fee was inadequate and has been increased in 1991, 1992, 1993, 1998 and 1999. The city
issued bonds in 1999 to pay for storm sewer projects in 1999 and 2000. The fund had also been
dealing with a negative working capital balance. To resolve this, a substantial rate change was
implemented in 1999. The Storm Sewer fund incurred many capital project costs and therefore was
14
cash poor. The increased rates and the revenue bond issue had brought the working capital balance
to a positive amount. In 2002, however,the working capital balance is again negative at $(645,470),
a decrease of ($413,540) over 2001. To resolve the negative working capital the city intends on
issuing storm sewer revenue bonds in 2003 and increasing the storm sewer rate in 2004 to pay for
the new bond issue. This should enable the fund to meet its' infrastructure costs and pay back its'
debt. The net income in the Storm Sewer fund is $243,913.
Pavilion/Ice Arena Fund -- This fund was established in 1991 to record operating revenues and
expenditures for the pavilion. Small operating profits have been generated each year since 1992.
The fund realizes net losses due to depreciation of the building and equipment. This year the net
loss is $(35,514). The working capital balance for this fund is currently $27,640, a decrease of
$46,511. The reason for the decrease in working capital is the purchase of an ice resurfacer.
Skate Park — This fund was established in 2000 to record operating revenues and expenditures for
the newly constructed skate park. This is the third year of operations and it will need some
adjusting to continue successfully. The park experienced a net loss of$(24,810). Working capital
balance is negative ($10,764), a decrease of($21,772) over 2001. Changes are occurring for 2003
to increase revenues and decrease costs.
Housing Authority -- The authority manages low-income rental units acquired through HUD. The
asset ownership remains with HUD until the bonds are retired, then the assets convert to City
ownership.
Cash Mana eg ment
Cash temporarily available for short-term investment during the year was invested as authorized by
Minnesota Statutes Chapter 475 and the City's Investment Policy.
The City of Hopkins subscribes to the "pooled cash" concept of investing which means that all
funds with cash balances participate in an investment pool. This permits some funds to be
overdrawn and others to show cash balances when, in fact, the City has a cash balance. This pooled
cash concept provides for investing greater amounts of money at more favorable rates. Interest
earnings are then allocated on a monthly basis to the participating funds.
The City's primary investment policy goal is to minimize investment market risks while realizing a
_ competitive yield on its portfolio. The classification of the category of credit risk is shown in Note
2 to the financial statements. The City has the ability and intent to hold its investments to maturity
and therefore intends to recover the full value of its investment portfolio upon maturity. The portion
of the City's investments, which mature in less than one year, is 44%. During 2002, the City of
Hopkins earned $721,791 as compared to 2001 earnings of $901,168. The reduced earnings are
attributed to the sluggish economy in 2002.
15
At year-end, the City's cash and investment resources (including restricted cash) were held as
follows:
Cost –'
Cash 3.1% $ 1,013,655
Commercial Paper 20.4% 6,739,208
U.S. Government Agency Securities 76.5% 25,333,713
Total Investments and Deposits $ 33,086,576
Risk Mana eg ment
The City continues to maintain insurance coverage at state required levels for various types of
exposure - general and auto liability, worker's compensation, boiler, and employee bonds.
General Fixed Assets
The general fixed assets of the City are those fixed assets used in the performance of general
governmental functions and exclude the fixed assets of the enterprise funds. As of December 31,
2002, the general fixed assets of the City amounted to $34,130,684 based on original or estimated
historical cost and is considerably less than the replacement value. Depreciation on general fixed —
assets is not recognized in the City's accounting system or in these financial statements.
Independent Audit —
Section 7.13 of the City Charter requires that the City Manager report to the City Council
concerning the entire financial operations of the City. The City's entire financial operations are
audited each year(Charter Section 2.08) by independent auditors. The firm of KPMG LLP has been
retained for that purpose and their report has been included in the financial section of this report.
Certificate of Achievement For
Excellence in Financial Reporting —
The Government Finance Officers Association of the United States and Canada (GFOA) awarded a
Certificate of Achievement for Excellence in Financial reporting to the City of Hopkins for its —
comprehensive annual finance report for the fiscal year ended December 31, 2001. In order to be
awarded a Certificate of Achievement for Excellence in Financial Reporting, a governmental unit
must publish an easily readable and efficiently organized comprehensive annual financial report.
This report must satisfy both generally accepted accounting principles and applicable legal
requirements.
A Certificate of Achievement is valid for a period of one year only. We believe our current
comprehensive annual financial report continues to meet the Certificate of Achievement Program's
requirements and we are submitting it to the GFOA to determine its eligibility for another —
certificate.
16 _
Acknowledgments
We wish to express our appreciation to the Mayor and City Council for their continued interest and
support in planning and conducting the financial operations of the City in a responsible and
progressive manner. We also want to express our appreciation to Deborah Dahlheimer, Lee
Goodman and Pat Weigel of the Finance Department staff for their work in preparing this report.
Respectfully submitted,
Steven C. Mielke Lori K. Yager
City Manager Finance Director
17
Certificate of
Achievement
for Excellence _
in Financial
Reporting
Presented to --
City of Hopkins, _
Minnesota
For its Comprehensive Annual
Financial Report _
for the Fiscal Year Ended
December 31,2001
A Certificate of Achievement for Excellence in Financial
Reporting is presented by the Government Finance Officers
Association of the United States and Canada to _
government units and public employee retirement
systems whose comprehensive annual financial
reports(CAFRs) achieve the highest
standards in government accounting
and financial reporting.
�iGE OFpj� m C,/�P�CivGti►s'v� a '
k�
OF UN
�111E5 p �'
CWOPA ON s President
>� ao.
AAICA60
Executive Director
18
6[
NOII:AS IVDN`dN IJ _
II NOIIDIS _
AOdRI IVIDN`dNl3 I` nNNb 3AISNIHRldW0D
VIOSINNIW 'SNI)IdOH JO Alli
4200 Wells Fargo Center Telephone 612 305 5000 T
90 South Seventh Street Fax 612 305 5100
Minneapolis,MN 55402
Independent Auditors' Report
The Honorable Mayor and Members of the City Council
City of Hopkins,Minnesota:
We have audited the general-purpose financial statements of the City of Hopkins, Minnesota (the City), as of �-
and for the year ended December 31, 2002, as listed in the accompanying table of contents. These general-
purpose financial statements are the responsibility of the City's management. Our responsibility is to express
an opinion on these financial statements based on our audit.
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. Those standards require that we plan and perform the audit to
obtain reasonable assurance about whether the general-purpose financial statements are free of material
misstatement. An audit includes examining,on a test basis,evidence supporting the amounts and disclosures in
the general-purpose financial statements. An audit also includes assessing the accounting principles used and
significant estimates made by management, as well as evaluating the overall financial statement presentation.
We believe that our audit provides a reasonable basis for our opinion.
In our opinion, the general-purpose financial statements referred to above present fairly, in all material
respects, the financial position of the City as of December 31, 2002, and the results of its operations and cash
flows of its proprietary fund types for the year then ended in conformity with accounting principles generally
accepted in the United States of America. ..
In accordance with Government Auditing Standards, we have also issued our report dated June 6, 2003 on our
consideration of the City's internal control over financial reporting and on our tests of its compliance with _
certain provisions of laws, regulations, contracts, and grants. That report is an integral part of an audit
performed in accordance with Government Auditing Standards and should be read in conjunction with this
report in considering the results of our audit.
Our audit was made for the purpose of forming an opinion on the general-purpose financial statements taken as
a whole. The combining, individual fund, and account group financial statements and schedules in the
accompanying table of contents are presented for purposes of additional analysis and are not a required part of ..
the general-purpose financial statements of the City. Such information has been subjected to the auditing
procedures applied in the audit of the general-purpose financial statements and, in our opinion, is fairly stated,
in all material respects,in relation to the general-purpose financial statements taken as a whole.
The data designated as the statistical section and supplementary information listed in the accompanying table
of contents is presented for purposes of additional analysis and is not a required part of the general-purpose
financial statements. Such information has not been subjected to the auditing procedures applied in the audit of ,.
the general-purpose financial statements and,accordingly,we express no opinion on it.
KPI 1 C, LLQ
June 6,2003
20
KPMG LLP.KPMG LLP,a U.S.limited liability partnership,is
a member of KPMG International,a Swiss association. ""
CITY OF HOPKI NS, MINNESOTA
COMPREHENSIVE ANNUAL FINANCIAL REPORT
SECTION IIA
GENERAL PURPOSE FINANCIAL STATEMENTS
The Combined Statements are intended to provide an overview and broad
perspective of the city's financial position and operations. These general purpose
financial statements are at a summary level by fund types and account groups and
include aggregate data to analyze current operations and to determine compliance
with legal and budgetary limitations and to assist in financial planning.
It is emphasized that the total figures contained in these statements are a
combination of unlike purpose groups. The total columns (labeled "Memorandum
Only") are not comparable to a consolidation because the same basis of accounting
is not used by all funds and interfund transactions and balances are not eliminated.
The following combined statements and schedules are presented:
Combined Balance Sheet - All Fund Types and Account Groups
Combined Statement of Revenues, Expenditures, and Changes in Fund
Balances - All Governmental Fund Types
Combined Statement of Revenues, Expenditures, and Changes in Fund
Balances - Budget and Actual - General and Special Revenue Fund Types
Combined Statement of Revenues, Expenses, and Changes in Retained
Earnings - All Proprietary Fund Types
Combined Statement of Cash Flows - All Proprietary Fund Types
21
CITY OF HOPKINS,MINNESOTA
COMBINED BALANCE SHEET-ALL FUND TYPES AND ACCOUNT GROUPS
December 31,2002 _
With Comparative Totals for December 31,2001
Governmental Fund Types
Special Debt Capital
General Revenue Service Projects
ASSETS AND OTHER DEBITS _
Assets:
Cash,cash equivalents,and investments $ 3,543,736 $ 7,322,407 $ 2,572,908 $ 3,705,769
Taxes receivable 79,421 19,759 4,367 -
Special assessments receivable - - 10,322,976 2,335,503
Accounts receivable 45,634 150,097 - 44,660
Rehabilitation loans receivable - 470,051 - -
Accrued interest receivable 28,264 46,778 16,021 22,392 _
Due from other funds 141,291 2,422,591 - 53,660
Due from other governments 16,596 104,271 - 433,519
Inventory 84,993 - - -
Prepaid items 295 - - -
Restricted cash and investments - 49,000 129,120 10,557,451
Advance to other funds 495,174 300,000 -
Long term loans receivable - 2,030,552
Property and equipment,net - - - -
Other debits:
Amount available in debt service funds - - - -
Amount to be provided for retirement of general
long-term debt - - - -
Total Assets and Other Debits 4,435,404 12,915,506 13,045,392 17,152,954
LIABILITIES, EQUITY AND OTHER CREDITS
Liabilities:
Accounts payable $ 316,712 $ 1,030,383 $ - $ 199,583
Accrued interest payable - - - -
Compensated absences payable 559,404 99,144 - -
Due to other funds 56,280 2,448,311 - 408,400
Due to other governments - 250
Deferred revenue 118,705 455,937 10,317,301 2,331,394
Deposits payable 7,900 - - -
Advance from other funds - 795,174 - -
Long-term debt - - - -
Total Liabilities 1,059,,001 4,829,199 10,317,301 2,939,377
Equity and Other Credits: _
Contributed capital - - - -
Investment in general fixed assets - - - -
Retained earnings:
Reserved - - - -
Unreserved - - - -
Fund balances:
Reserved 580,462 4,989,862 2,728,091 10,107,076 ,
Unreserved
Designated 2,753,990 148,981 - 3,709,832
Undesignated 41,951 2,947,464 - 396,669
Total Equity and Other Credits 3,376,403 8,086,307 2,728,091 14,213,577
Total Liabilities, Equity and Other Credits 4,435,404 12,915,506 $ 13,045,392 17,152,954
See accompanying Notes to Financial Statements. _
22
A
Proprietary Fudiciary
Fund Types Fund Type Account Groups
General General Totals
Internal Trust and Fixed Long-Term (Memorandum Only)
Enterprise Service Agency Assets Debt 2002 2001
$ 2,468,182 $ 2,075,658 $ 260,249 $ - $ - $ 21,948,909 $ 20,651,266
103,547 272,194
12,658,479 13,142,547
324,602 418 - - - 565,411 656,611
470,051 652,648
16,742 9,623 1,579 - - 141,399 244,857
_ 1,093,400 - - - - 3,710,942 2,986,105
- 24,832 - - 579,218 380,719
24,883 - - - - 109,876 102,604
7,846 - - - - 8,141 11,452
402,096 - - - - 11,137,667 1,962,960
795,174 834,783
2,030,552 2,070,827
16,902,010 1,613,862 - 34,130,684 - 52,646,556 50,318,257
2,728,091 2,728,091 4,727,313
25,773,103 25,773,103 13,595,383
21,239,761 3,699,561 286,660 34,130, 4 28,5 1,194 -9-135,407,116 112,610,526
$ 229,857 $ 835 $ 9,160 $ - $ - $ 1,786,530 $ 971,557
113,031 - - - - 113,031 113,031
120,052 - - - - 778,600 731,720
797,951 - - - - 3,710,942 2,986,105
142,187 - 277,500 - - 419,937 239,964
_ 660 - - - - 13,223,997 13,712,013
- 7,900 7,889
- 795,174 834,783
4,800,000 - - - 28,501,194 33,301,194 25,062,696
61203,738 835 286,660 - 28,501,194 54,137,305 44,659,758
_ 2,557,709 2,687,227 - - - 5,244,936 9,065,554
34,130,684 - 34,130,684 27,922,275
402,096 - - - - 402,096 1,913,960
12,076,218 1,011,499 - - - 13,087,717 10,235,747
- - - 18,405,491 10,161,525
- - 6,612,803 6,455,186
- - - - - 3,386,084 2,196,521
15,036,023 3,698,726 - 34,130,684 - 81,269,811 67,950,768
21,239,767 3,699,561 286,660 34,130,694- 28,501,194 135, 07,116 112,610,-5-26-
23
12,61 ,5223
CITY OF HOPKINS, MINNESOTA -
COMBINED STATEMENT OF REVENUES,EXPENDITURES,AND CHANGES IN FUND
BALANCES-ALL GOVERNMENTAL FUND TYPES
Year Ended December 31,2002
With Comparative Totals for Year Ended December 31,2001
Governmental Fund Types -
Special Debt Capital
General Revenue Service Projects -
Revenues:
Property taxes $ 5,799,310 $ 93,668 $ 322,216 $ -
Tax Increments - 2,003,743 - -
Special assessments - 17,000 679,503 666,664 -
Intergovernmental 1,521,976 777,425 - 531,405
Licenses and permits 468,312 - - -
Franchise fee - 146,574 - - -
Fines and forfeitures 115,354 32,758 - -
Charges for services 296,523 545,887 - 56,486
Investment earnings 116,211 161,177 (14,385) 321,235 _
Other 14,499 287,949 - 11,400
Total Revenues 8,332,185 4,066,181 987,334 1,587,190
Expenditures: -
Current:
General government 874,288 187,672 - -
Public safety 3,625,449 64,919 - - -
Community development 693,193 464,767 - -
Public works 1,547,079 105,064 - -
Recreation 479,277 547,966 - -
Other 93,508 - - - -
Capital outlay 786,315 1,568,852 - 2,124,891
Debt service:
Principal payments - - 3,991,502 - -
Interest, fiscal charges and issuance cost - 40,192 1,058,809 246,810
Total Operating Expenditures 8,099,109 2,979,432 5,050,311 2,371,701
Excess(deficiency)of revenues over(under)
expenditures 233,076 1,086,749 (4,062,977) (784,511)
Other Financing Sources(Uses): -
Proceeds from bond issuance - 2,450,000 - 11,720,000
Operating transfers in - 131,078 2,063,755 160,360
Operating transfers out (55,378) (1,905,743) - (367,120) -
Total Other Financing Sources(Uses) (55,378) 675,335 2,063,755 11,513,240
Excess(deficiency)of revenues and other financing -
sources over(under)expenditures and other
financing uses 177,698 1,762,084 (1,999,222) 10,728,729
Fund Balances-January 1 3,198,705 7,402,366 4,727,313 3,484,848
Residual equity transfer in(out) - (1,078,143) - -
Fund Balances-December 31 $ 3,376,403 $ 8,086,307 $ 2,728,091 $ 14,213,577
See accompanying Notes to Financial Statements. -
24
A-1
Totals
(Memorandum Only)
2002 2001
$ 6,215,194 $ 5,087,313
2,003,743 2,730,232,
1,363,167 1,253,592
2,830,806 3,096,853
468,312 377,048
146,574 138,614
_ 148,112 167,252
898,896 471,515
584,238 627,909
313,848 199,929
14,972,890 14,150,257
1,061,960 1,043,394
3,690,368 3,398,981
_ 1,157,960 1,141,409
1,652,143 1,693,361
1,027,243 667,410
93,508 34,290
4,480,058 4,667,505
3,991,502 995,847
1,345,811 1,141,290
18,500,553 14,783,487
(3,527,663) (633,230)
14,170,000 2,125,000
2,355,193 2,092,153
(2,328,241) (2,090,379)
14,196,952 2,126,774
10,669,289 1,493,544
18,813,232 17,319,688
(1,078,143) -
$ 28,404,378 $ 18,813,232
25
CITY OF HOPKINS, MINNESOTA
COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES
BUDGET AND ACTUAL-GENERAL AND SPECIAL REVENUE FUND TYPES -
Year Ended December 31, 2002
General Fund
Variance--
favorable -
Budget Actual (unfavorable)
Revenues:
Property taxes $ 6,171,140 $ 5,799,310 $ (371,830) -
Tax Increments - - -
Special Assessments - - -
Licenses and permits 426,105 468,312 42,207 -
Intergovernmental 1,197,987 1,521,976 323,989
Franchise fee - - -
Fines and forfeitures 140,000 115,354 (24,646)
Charges for services 229,618 296,523 66,905
Investment earnings 163,000 116,211 (46,789)
Other 12,100 14,499 2,399
Total Revenues 8,339,950 8,332,185 (7,765) -
Expenditures:
General government 945,731 874,288 71,443 -
Public safety 3,607,757 3,625,449 (17,692)
Community development 741,084 693,193 47,891
Public works 1,680,418 1,547,079 133,339 -
Recreation 502,317 479,277 23,040
Other 47,527 93,508 (45,981)
Debt service issuance cost - - - --
Capital outlay 830,132 786,315 43,817
Total Expenditures 8,354,966 8,099,109 255,857
Excess(deficiency)of revenues over(under)expenditures (15,016) 233,076 248,092
Other Financing Sources(Uses): -
Proceeds from bond issuance - - -
Operating transfers in - - -
Operating transfers out (24,500) (55,378) (30,878)
Total Other Financing Sources (Uses) (24,500) (55,378) (30,878)
Excess(deficiency)of revenues and other financing sources -
over(under)expenditures and other financing uses (39,516) 177,698 217,214
Fund Balances- January 1 3,198,705 3,198,705 - -
Residual equity transfer in (out) - - -
Fund Balances- December 31 $ 3,159,189 $ 3,376,403 $ 217,214
See accompanying Notes to Financial Statements -
26
A-2
Total
Special Revenue Funds (Memorandum Only)
Variance-- Variance--
favorable favorable
Budget Actual (unfavorable) Budget Actual (unfavorable)
$ 100,000 $ 93,668 $ (6,332) $ 6,271,140 $ 5,892,978 $ (378,162)
2,239,627 2,003,743 (235,884) 2,239,627 2,003,743 (235,884)
16,000 17,000 1,000 16,000 17,000 1,000
426,105 468,312 42,207
_ 929,977 565,832 (364,145) 2,127,964 2,087,808 (40,156)
136,000 146,574 10,574 136,000 146,574 10,574
45,000 32,758 (12,242) 185,000 148,112 (36,888)
399,400 545,887 146,487 629,018 842,410 213,392
155,100 161,177 6,077 318,100 277,388 (40,712)
363,024 287,949 (75,075) 375,124 302,448 (72,676)
4,384,128 3,854,588 (529,540) 12,724,078 12,186,773 (537,305)
186,861 187,672 (811) 1,132,592 1,061,960 70,632
64,850 64,919 (69) 3,672,607 3,690,368 (17,761)
439,813 428,406 11,407 1,180,897 1,121,599 59,298
136,945 105,064 31,881 1,817,363 1,652,143 165,220
571,781 547,966 23,815 1,074,098 1,027,243 46,855
- - - 47,527 93,508 (45,981)
40,192 40,192 - 40,192 (40,192)
5,162,380 1,376,483 3,785,897 5,992,512 2,162,798 3,829,714
6,562,630 2,750,702 3,892,312 14,917,596 10,849,811 4,067,785
(2,178,502) 1,103,886 3,362,772 (2,193,518) 1,336,962 3,530,480
2,450,000 2,450,000 - 2,450,000 2,450,000
1,417 131,078 129,661 1,417 131,078 129,661
(1,766,658) (1,905,743) (139,085) (1,791,158) (1,961,121) (169,963)
(1,765,241) 675,335 2,440,576 (1,789,741) 619,957 2,409,698
(3,943,743) 1,779,221 5,803,348 (3,983,259) 1,956,919 5,940,178
7,316,831 7,316,831 - 10,515,536 10,515,536 -
$ 3,373,088 $ 9,096,052 $ 5,803,348 $ 6,532,277 $ 12,472,455 $ 5,940,178
27
CITY OF HOPKINS,MINNESOTA A-3
COMBINED STATEMENT OF REVENUES,EXPENSES,AND CHANGES IN _
RETAINED EARNINGS-ALL PROPRIETARY FUND TYPES
Year Ended December 31,2002
With Comparative Totals for Year Ended December 31,2001
Totals
Internal (Memorandum Only)
Enterprise Service 2002 2001
Operating revenues:
Charges for services $ 3,896,512 $ 570,480 $ 4,466,992 $ 4,830,549 -
Other 140,954 - 140,954 68,037
Total Operating Revenues 4,037,466 570,480 4,607,946 4,898,586
Operating expenses(excluding depreciation):
Salaries and employee benefits 1,018,604 - 1,018,604 1,241,199
Materials,supplies and services 1,362,537 33,881 1,396,418 1,470,182
Disposal costs 941,613 - 941,613 923,092
Total Operating Expenses 3,322,754 33,881 3,356,635 3,634,473
Operating income before depreciation expense 714,712 536,599 1,251,311 1,264,113
Depreciation expense 685,297 362,568 1,047,865 1,173,782
Operating income 29,415 174,031 203,446 90,331
Nonoperating revenue(expense): _
Investment earnings 78,315 59,238 137,553 273,259
Interest/fiscal agent expense (238,047) - (238,047) (380,560)
Intergovernmental grants 175,145 - 175,145 61,219
Bond issuance expense - - - (12,248)
Other 47 18,845 18,892 86,052
Total nonoperating revenues(expenses) 15,460 78,083 93,543 27,722
Income before operating transfers 44,875 252,114 296,989 118,053
Other revenues(expenses): _
Operating transfers from another fund 166,108 - 166,108 61,000
Operating transfers to another fund (193,060) - (193,060) (62,774)
Total other revenues(expenses) (26,952) - (26,952) (1,774) _
Net income 17,923 252,114 270,037 116,279
Fund equity:
Retained earnings-January 1 11,390,322 759,385 12,149,707 12,033,428
Residual equity transfer 1,070,069 - 1,070,069 -
Retained earnings-December 31 $ 12,478,314 $ 1,011,499 $ 13,489,813 $ 12,149,707
See accompanying Notes to Financial Statements.
28 -
CITY OF HOPKINS, MINNESOTA A-4
COMBINED STATEMENT OF CASH FLOWS
ALL PROPRIETARY FUND TYPES
Year Ended December 31, 2002
With Comparative Totals for Year Ended December 31, 2001
Totals
Internal (Memorandum Only)
Enterprise Service 2002 2001
Cash Flows from Operating Activities:
Operating(loss) income $ 29,415 $ 174,031 $ 203,446 $ 90,331
Adjustments to reconcile operating income to net cash
provided by operating activities:
Depreciation expense 685,297 362,568 1,047,865 1,173,782
Gain on sale of property and equipment - 18,845 18,845 -
Increase decrease in:
Accounts and accrued interest receivable 132,713 3,222 135,935 (27,474)
Due from other funds (1,093,400) - (1,093,400) -
Due from other governments 11,162 - 11,162 (5,664)
Inventory (520) - (520) 330
Prepaid expense (758) - (758) (793)
Accounts,compensated absences and accrued
interest payable 36,100 835 36,935 (105,407)
Due to other funds (472,963) - (472,963) 4,647
Due to other governments 104,483 - 104,483 13,447
'- Deferred revenue (206,103) - (206,103) 55,289
Cash Provided(Used)by Operating Activities (774,574) 559,501 (215,073) 1,198,488
Cash Flows from Noncapital Financing Activities:
Intergovernmental grants 175,145 - 175,145 61,219
_ Other contributions 8,074 - 8,074 53,237
Operating transfer in 166,108 - 166,108 61,000
Operating transfer out 877,009 - 877,009 (62,774)
Cash Provided By Noncapital Financing Activities 1,226,336 - 1,226,336 112,682
Cash Flows from Capital and Related Financing Activities:
Purchases of property and equipment (715,672) (285,572) (1,001,244) (1,407,099)
Gain on sale of property and equipment 3,470 1,375 4,845 32,815
Proceeds from issuance of bonds - - - 1,610,000
Interest and other payments (238,047) - (238,047) (392,808)
Bond payments (1,940,000) - (1,940,000) (345,000)
Cash Used in Capital and Related Financing Activities (2,890,249) (284,197) (3,174,446) (502,092)
Cash Provided by Investing Activities-interest received 78,315 59,238 137,553 273,259
Increase(Decrease)in Cash and Cash Equivalents (2,360,172) 334,542 (2,025,630) 1,082,337
Cash and Cash Equivalents-January 1 5,230,450 1,741,116 6,971,566 5,889,229
Cash and Cash Equivalents-December 31 $ 2,870,278 $ 2,075,658 $ 4,945,936 $ 6,971,566
Cash and Cash Equivalents Components:
Cash and Cash Equivalents 2,468,182 2,075,658 4,543,840 5,057,606
Restricted Cash and Cash Equivalents 402,096 - 402,096 1,913,960
Total Cash and Cash Equivalents ,
See accompanying Notes to Financial Statements
29
City of Hopkins, Minnesota
NOTES TO FINANCIAL STATEMENTS -CONTINUED
December 31,2002 —
1 SUMMARY OF SIGNIFICANT ACCOUNT POLICIES
The City of Hopkins, Minnesota (the City) is a charter city which was approved December 2, 1947. The City
operates pursuant to applicable Minnesota laws and statutes. The governing body of the City is a Council - Manager
form of government.
The financial statements of the City have been prepared in conformity with accounting principles generally accepted
in the United States of America, as applied to governmental units by the Government Accounting Standards Board
(GASB). The more significant accounting policies of the City are described below.
A. REPORTING ENTITY
In accordance with GASB pronouncements, the City's financial statements include all funds, account groups, and
departments of the City and its component units, for which the City is considered to be financially accountable.
Blended component units, although legally separate entities are, in substance, part of the City's operations and so
data from these units are combined with data of the primary government. The City's blended component unit has —
a December 31 year-end.
Blended Component Unit —
Housing and Redevelopment Authority in and for the City of Hopkins(HRA)
The HRA was created by the City to carry out certain redevelopment projects and low income rental housing.
Individuals on the City Council represent the governing board of the HRA. The housing activity is self-sustaining
for current operating expenses; however, HUD retains ownership of the housing units and funds the debt issued
for their purchase. The City provides development financing through tax increment. The HRA is included in the
City's enterprise funds.
B. FUND ACCOUNTING —
The accounts of the City are organized on the basis of funds and account groups, each of which is considered a
separate accounting entity. The operations of each fund are accounted for with a separate set of self-balancing
accounts that comprise its assets, liabilities, fund equity, revenues and expenditures, or expenses, as appropriate. —
Government resources are allocated to and accounted for in individual funds based upon the purposes for which
they are to be spent and the means by which spending activities are controlled. The various funds are grouped, in
the financial statements of this report, into seven generic fund types and three broad fund categories as follows: —
Governmental Funds
General Fund-The general fund is the general operating fund of the City. It is used to account for all financial
resources except those required to be accounted for in another fund.
Special Revenue Funds - Special revenue funds are used to account for the proceeds of specific revenue —
sources that are legally restricted to expenditures for specified purposes.
Debt Service Funds - Debt service funds are used to account for the accumulation of resources for, and the —
payment of,general long-term debt principal, interest, and related costs.
Capital Project Funds - Capital project funds are used to account for financial resources to be used for the _
acquisition or construction of major capital facilities and infrastructure, other than those financed by
proprietary funds or special revenue funds.
30
City of Hopkins,Minnesota
NOTES TO FINANCIAL STATEMENTS-CONTINUED
December 31,2002
Proprietary,Funds
Enterprise Funds - Enterprise funds are used to account for operations that are financed and operated in a
manner similar to private business enterprises, where the intent of the governing body is that the costs
(expenses, including depreciation) of providing goods or services to the general public on a continuing basis,
be financed or recovered primarily through user charges.
Internal Service Funds — Internal service funds are used to account for the financing of goods and services
provided by one department to other departments of the City on a cost-reimbursement basis.
Fiduciary Funds
Agency Funds — Agency funds are custodial in nature and do not present results of operations or have a
measurement focus. Agency funds are accounted for using the modified accrual basis of accounting. This
fund is used to account for assets that the government holds for others in an agency capacity
C. BASIS OF ACCOUNTING
The accounting and reporting treatment applied to a fund is determined by its measurement focus. Governmental
funds are accounted for using a current financial resources measurement focus. With this measurement focus,
only current assets and current liabilities generally are included on the balance sheet. Reported fund balance is
considered a measure of "available spendable resources." Governmental fund operating statements represent
increases (i.e., revenues and other financing sources) and decreases(i.e., expenditures and other financing uses) in
net current assets.
Proprietary funds are accounted for on a flow of economic resources measurement focus. This means that all
assets, including fixed assets, and all liabilities, including long-term liabilities, associated with their activity are
included on their balance sheets. Their reported fund equity is segregated into contributed capital and retained
earnings components. Proprietary fund type operating statements present increases (i.e., revenues) and decreases
(i.e.,expenses)in net total assets.
Governmental funds are accounted for using the modified accrual basis of accounting. Their revenues are
recognized when susceptible to accrual (i.e., when they become measurable and available). "Measurable" means
_ the amount of the transaction can be determined and "available" means collectible with the current period or soon
enough thereafter to be used to pay liabilities of the current period.
Fiduciary funds account for assets held by the government in a trustee capacity or as an agent on behalf of others.
Major revenues that are susceptible to accrual include property taxes (excluding delinquent taxes received over
sixty days after year-end), special assessments, intergovernmental revenues, charges for services, and investment
earnings. Major revenues that are not susceptible to accrual include fees and miscellaneous revenues; such
revenues are recorded only as received because they are not measurable until collected.
Expenditures are generally recognized under the modified accrual basis of accounting when the related fund
liability is incurred,except for principal and interest on general long-term debt which is recognized when due.
Proprietary funds are accounted for using the accrual basis of accounting. Revenues are recognized when earned,
and expenses are recorded at the time the liabilities are incurred. Unbilled utility service receivables are recorded
at year end.
The City reports deferred revenue on its combined balance sheet. Deferred revenues arise when a potential
revenue does not meet both the "measurable" and "available" criteria for recognition in the current period.
Deferred revenues also arise when resources are received by the City before it has a legal claim to them. In
31
City of Hopkins, Minnesota
NOTES TO FINANCIAL STATEMENTS -CONTINUED
December 31,2002 —
subsequent periods,when all revenue recognition criteria are met,the liability for deferred revenue is removed and
revenue is recognized.
D. BUDGETS AND BUDGETARY ACCOUNTING
The City follows these procedures in establishing the budgetary data reflected in the financial statements and set
forth in Section 7.04 of the City Charter.
1. The City Manager shall, at the first regular council meeting in September, submit to the Council a proposed —
budget and an explanatory budget message in a form and manner as prescribed by the City Charter.
2. The Council shall determine the plan and time of the public hearings on the budget to obtain taxpayer
comments.
3. The Council shall adopt the tax levy by resolution no later than a December date, which is annually established
by law for the county auditor to levy taxes. The budget shall set forth the total for each budgeted fund with such
segregation as to objects and purposes of expenditures as the Council deems necessary for purposes of budget
control.
4. The City Manager is authorized to transfer budgeted amounts between departments within any fund; however,
any revisions that alter the total expenditures of any fund must be approved by the City Council and are limited to
the amount revenues exceed the budgets or authorize the transfer of sums from unexpended balances to other
purposes. Budgeted expenditure appropriations lapse at year end. The level of legal control is at the fund level. —
5. Supplemental budgetary appropriations were necessary during 2002. The effect of the supplemental
amendments are as follows: —
Original Budget Budget adjustments Final Budget
General Fund $8,346,588 $ 32,878 $8,379,466 _
State Chemical Assess. $ 40,000 $ 24,850 $ 64,850
Economic Development $1,568,546 $ (40,000) $1,528,546
Para-Transit $ 104,917 $ 15,077 $ 119,994
Cable TV $ 190,119 $ 32,000 $ 222,119 —
Tax Increment 1-1 $1,270,000 $ 65,000 $1,335,000
Tax Increment 1-2 $ 50,718 $ 32,000 $ 82,718
Tax Increment 2-7 $ 58,111 $ 48,611 $ 106,722 —
Tax Increment 2-8 $ 34,032 $ 5,400 $ 39,432
Tax Increment 2-9 $ 132,399 $ 1,000 $ 133,399
Tax Increment 2-10 $ 49,862 $ 5,500 $ 55,362 —
6. The budgets for the General Fund are prepared on a modified accrual basis of accounting, which is consistent
with accounting principles generally accepted in the United States of America. Certain Special Revenue Funds —
are budgeted and those budgets are prepared on a modified accrual basis of accounting. The Community Block
Grant Special Revenue Fund is not budgeted. The Art Facility Construction fund is renamed the Art Center fund.
7. A capital improvement plan is reviewed annually by the City Council for the Capital Projects funds, certain
Special Revenue funds and Utility funds. However, appropriations for major projects are not adopted until the
actual bid award of the improvement. The appropriations are not reflected in the financial statements.
32
City of Hopkins,Minnesota
NOTES TO FINANCIAL STATEMENTS-CONTINUED
December 31,2002
E. CASH, CASH EQUIVALENTS AND INVESTMENTS
Cash balances from all funds are combined and invested to the extent available in authorized investments, (See
Note 2). Earnings from such investments are allocated to the respective funds on the basis of applicable cash
balance participation by each fund. Investments in commercial paper with maturity date of less than one year at
the date of purchase, are reported at cost or amortized cost, which approximates fair value. Investments other than
commercial paper are reported at fair value,based on quoted market price.
The City accounts for its cash, cash equivalents and investments in an entity-wide cash management pool, which
is used essentially as a demand deposit account. For purposes of the statement of cash flows, the proprietary
funds consider all investments to be cash equivalents. Restricted cash and investments are also included with cash
equivalents for purposes of the statement of cash flows.
F. SHORT TERM INTERFUND RECEIVABLES/PAYABLES
During the course of operations, numerous transactions occur between individual funds for goods provided or
_ services rendered. These receivables and payables are classified as "due from other funds" and "due to other
funds", respectively on the balance sheet(See Note 6).
G. ADVANCE TO/FROM OTHER FUNDS
Noncurrent portions of long-term interfund loan receivables are reported as advances and are offset equally by a
fund balance reserve account which indicates that they do not constitute expendable available financial resources
and therefore are not available for appropriation.
H. INVENTORY
Inventory is valued at cost (FIFO basis) based on physical counts for the General, Water and Sewer Funds. The
cost of inventory is recorded as an expenditure/expense at the time of consumption.
I. RESTRICTED ASSETS
Certain proceeds of enterprise fund revenue bonds, special revenue fund revenue bonds, debt service fund revenue
bonds and capital improvement revenue bonds, as well as certain resources set aside for their repayment, are
classified as restricted assets on the balance sheet because their use is limited by applicable bond covenants or
developer agreements.
J. FIXED ASSETS
Fixed assets used in governmental fund type operations (general fixed assets) are recorded at historical cost and
accounted for in the General Fixed Assets Account Group. Public domain ("infrastructure") general fixed assets,
including roads, bridges, curbs and gutters, streets and sidewalks, drainage systems, and lighting systems, are
capitalized along with other general fixed assets. No depreciation has been provided on general fixed assets.
Fixed assets used in proprietary funds are recorded at historical cost and accounted for in the enterprise funds.
Depreciation of all exhaustible fixed assets used by proprietary funds is charged as an expense against their
operations. Accumulated depreciation is reported on proprietary fund balance sheets. Depreciation has been
provided over the estimated useful lives using the straight-line method.
33
City of Hopkins, Minnesota
NOTES TO FINANCIAL STATEMENTS -CONTINUED
December 31,2002 —
The estimated useful lives are as follows:
Buildings 25 - 50 years —
Mains and Lines 50- 100 years
Improvements 10- 20 years
Equipment 3 - 20 years —
K. COMPENSATED ABSENCES
The City compensates all employees upon termination for unused vacation or flex leave. Vacation and flex leave
pay is accrued when incurred in the proprietary funds and reported as compensated absences payable. Vacation
and flex leave pay that is expected to be liquidated with expendable available financial resources is reported as an
expenditure, and compensated absences payable of the governmental fund that will pay it. —
Employees hired prior to August 1, 1998 may opt to have sick leave, at the rate of 8 hours for each calendar month
of full-time service, instead of flex leave. Sick pay is expensed as paid. No liability is reported for unpaid —
accumulated sick leave.
Employees hired prior to August 1, 1998, shall be entitled to severance pay, after completion of five years of
continuous City employment. Severance pay is calculated by multiplying the total number of continuous years in —
the City employ and/or accumulated sick leave by the daily wage rate prevailing at date of severance, at one day
per year of such employment, to a maximum of 20 days. Such severance money shall be paid in case of
separation caused by death, eligible retirements, medically attested disability preventing an employee from --
performing the major duties of the position or separation for non-disciplinary reasons. Severance pay is accrued
when incurred in the proprietary funds and reported as a compensated absences payable. Severance pay that is
expected to be liquidated with expendable available financial resources is reported as an expenditure and —
compensated absences payable of the governmental fund that will pay it.
In addition to the pension benefits described in Note 8, the City provides post-retirement health care benefits to
employees who were hired prior to July 1, 1993 and have been with the City for at least ten years and are either —
(1) age 60 years or older, or (2) eligible for full PERA retirement benefits. These employees may retire and
receive full single health and life insurance coverage until age 65. Currently 7 employees meet those eligibility
requirements. During the year expenditures of approximately $17,000 were incurred for post-retirement health —
care benefits.
L. LONG-TERM OBLIGATIONS
Long-term obligations expected to be financed from governmental funds are accounted for in the general long-
term debt account group. For other long-term obligations, only that portion expected to be financed from
expendable available financial resources is reported as a fund liability of a governmental fund.
Long-term obligations expected to be financed from proprietary funds are accounted for in those funds.
In governmental fund types, bond discounts and issuance costs are recognized in the current period. Bond
discounts and issuance costs for proprietary fund types are deferred and amortized over the term of the bonds
using the bonds-outstanding method,which approximates the effective interest method.
M. FUND EQUITY
Contributed capital is recorded in proprietary funds that have received capital grants or contributions. Reserves —
represent those portions of fund equity not appropriable for expenditure or legally segregated for a specific future
use. Designated fund balances represent tentative plans for future use of financial resources(See Note 5).
34
City of Hopkins,Minnesota
NOTES TO FINANCIAL STATEMENTS -CONTINUED
December 31,2002
N. INTERFUND TRANSACTIONS
Quasi-external transactions are accounted for as revenues and expenditures. Transactions that constitute
reimbursements to a fund for expenditures initially made from it that are properly applicable to another fund are
recorded as expenditures in the reimbursing fund and as reductions of expenditures in the fund that is reimbursed.
_ All other interfund transactions are reported as transfers. Non-recurring or non-routine permanent transfers of
equity are reported as residual equity transfers. All other interfund transfers are reported as operating transfers.
O. TOTAL COLUMNS ON COMBINED STATEMENTS
Total columns on the combined statements are captioned "Memorandum Only"to indicate that they are presented
only to facilitate financial analysis. Data in these columns do not present financial position, results of operations,
or cash flows in conformity with accounting principles generally accepted in the United States of America.
Interfund eliminations have not been made in the aggregation of this data.
P. PROPERTY TAXES
Property tax levies are set by the City Council in December of each year, and are certified to Hennepin County
(the County) for collection in the following year. In the State of Minnesota, counties act as collection agents for
all property taxes. The County spreads all levies over assessable property. Such taxes become a lien on January 1
and are recorded as receivables by the City at that date.
Real property taxes are payable by taxpayers in two equal installments, on May 15 and October 15. Personal
property taxes are also payable by taxpayers in two equal installments, on February 28 and June 30. The County
provides tax settlements to cities and other local governments three times a year, on or before January 25, July 6
and November 30.
Property taxes are accrued and recognized as revenue for collections within 60 days of year-end. Taxes that
remain unpaid at the County on December 31 are classified as delinquent taxes receivable, and are fully offset by
deferred revenues because they are not available to finance current expenditures. No allowance for uncollectible
taxes has been provided because such amounts are not expected to be material.
Q.CONDUIT DEBT OBLIGATIONS
From time to time, the City has issued Commercial Development Revenue Note/Bonds in accordance with the
Minnesota Municipal Industrial Development Act. These obligations are issued to provide financial assistance to
private-sector entities for the acquisition and construction of industrial and commercial facilities deemed to be in
the public interest. The obligations are secured by the property financed and are payable solely from payments
received on the underlying mortgage loans. Upon repayment of the obligations, ownership of the acquired
facilities transfers to the private-sector entity served by the debt issuance. Neither the City, the State, nor any
political subdivision thereof is obligated in any manner for repayment of the obligations. Accordingly,the bonds
are not reported as liabilities in the accompanying financial statements. As of December 31, 2002,there were 16
note/bond issues outstanding, with an aggregate principal amount payable of approximately$50.8 million.
R. GASB STATEMENT NO. 20
In September 1993, the Government Account Standards Board (GASB) released GASB Statement No. 20
(Statement), Accounting and Financial Reporting for Proprietary Funds and Other Governmental Entities That
Use Proprietary Fund Accounting. The Statement provides that proprietary and similar trust funds may apply all
GASB pronouncements, as well as all Financial Accounting Standards Board (FASB) Statements and
Interpretations, Accounting Principles Board (APB) Opinions and Accounting Research Bulletins (ARBs) to the
extent they do not conflict with GASB pronouncements.
35
City of Hopkins,Minnesota
NOTES TO FINANCIAL STATEMENTS-CONTINUED
December 31,2002 _
The City's proprietary funds comply with all applicable GASB pronouncements. The City also applies all FASB
Statements and Interpretations, APB Opinions and ARBs issued on or before November 30, 1989, to the extent
they do not conflict with GASB pronouncements. The City has not elected to follow guidance of FASB —
Statements and Interpretations,APB Opinions and ARBs issued after November 30, 1989.
S. USE OF ESTIMATES _
The preparation of financial statements in conformity with accounting principles generally accepted in the United
States of America, requires management to make estimates and assumptions that affect the reported amounts of _
assets and liabilities and disclosure of contingent assets and liabilities at the date of the financial statements and
the reported amounts of revenues and expenses during the reporting period. Actual results could differ from those
estimates.
2 CASH,CASH EQUIVALENTS,AND INVESTMENTS
A. DEPOSITS _
In accordance with Minnesota Statues, the City maintains deposits at financial institutions within the state,
designated as official depositories by the City Council, all of which are members of the Federal Reserve System.
Balances at December 31, 2002,were as follows:
Fair Value Bank Balance
$1,013,655 $1,159,260
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 (140% in the case
of mortgage notes pledged). Authorized collateral includes the legal investments described below, as well as
certain first mortgage notes, and certain other state or local government obligations. Minnesota Statutes require
that securities pledged as collateral be held in safekeeping by the City treasurer or in a financial institution other —
than that furnishing the collateral. At December 31, 2001 the City had no deposits that were uninsured or
uncol lateral ized. The deposits were insured or collateralized by securities held by the City's agent in the City's
name. _
B. INVESTMENTS
The City is authorized by Minnesota Statutes to invest in the following:
(a)Direct obligations or obligations guaranteed by the United States or its agencies.
(b) Shares of investment companies registered under the Federal Investment Company Act of 1940 and whose
only investments are in securities described in(a)above.
(c)General obligations in the State of Minnesota or any of its municipalities;
(d)Bankers' acceptances of United States banks eligible for purchase by the Federal Reserve System;
(e) Commercial paper issued by United States corporations or their Canadian subsidiaries, of the highest quality,
and maturity in 270 days or less; and
(f)Guaranteed investment contracts issued or guaranteed by United States commercial banks or domestic branches
of foreign banks or United States insurance companies or their subsidiaries.
36
City of Hopkins,Minnesota
NOTES TO FINANCIAL STATEMENTS-CONTINUED
December 31,2002
(g) Repurchase or reverse repurchase agreements with banks that are members of the Federal Reserve System with
capitalization exceeding $10,000,000, a primary reporting dealer in U.S. Government securities to the Federal
Reserve Bank of New York,or certain Minnesota securities broker-dealers.
The City's investments are categorized below to give an indication of the level of risk assumed at year-end.
Category I includes investments that are insured or registered or for which the securities are held by the City or its
agent in the City's name. Category 2 includes uninsured and unregistered investments for which the securities are
held by the counterparty's trust departments or agent in the City's name. Category 3 includes uninsured and
unregistered investments for which the securities are held by the counterparty, or by its trust department or agent,
but not in the City's name. The City has the ability and intent to hold its investments to maturity and therefore
intends to recover the full carrying value of its investment portfolio upon maturity.
Investment balances at December 31, 2000,were as follows:
Credit Risk Category
Securities Type 1 2 3 Fair Value
U.S. Government
Agency Securities $25,333,713 $ - $ - $25,333,713
Commercial Paper 6,739,208 - - 6,739,208
Total Investments $32,072,921 $ - $ - $32,072,921
Total Deposits(See Note 2A) 1,013,655
Total Investments and Deposits 33,086,576
Less Restricted Cash and Investments 11,137,667
Net Cash,Cash Equivalents and Investments $ 21,948,909
-- In fiscal 2002,the City recorded an unrealized gain of$55,862 for certain investments. This gain is unlikely to occur
do to the fact that the City generally holds its investments until maturity.
3 FIXED ASSETS
Changes in the General Fixed Assets Account Group during 2002 were as follows:
Balance Transfers/ Balance
Jan 1,2002 Additions Deletions Dec 31, 2002
Land $ 4,970,938 $ 776,164 $ - $ 5,747,102
Buildings 2,592,546 3,564,823 - 6,157,369
Other Improvements 18,783,113 1,133,733 - 19,916,846
_ Vehicles 195,674 - - 195,674
Machinery &Equipment 1,380,004 271,835 - 1,651,839
Construction in Progress - 461,854 - 461,854
Total $27,922,275 $6,208,409 $ - $34,130,684
37
City of Hopkins, Minnesota
NOTES TO FINANCIAL STATEMENTS -CONTINUED
December 31,2002 —
Changes in proprietary fund type property and equipment during 2002 were as follows:
Balance Transfers/ Balance —
Jan 1, 2002 Additions Deletions Dec 31, 2002
Land $ 348,397 $ - $ 300,000 $ 48,397
Buildings 6,569,508 8,138 3,820,618 2,757,028
Other Improvements 20,484,036 613,987 393,400 20,704,623
Machinery &Equipment 6,214,289 464,079 110,176 6,568,192
Construction in Progress 83,873 308,830 3,814 388,889
Total $33,700,103 $ 1,395,034 $4,628,008 $30,467,129
Less: Accumulated depreciation 11,951,257 —
Net Fixed Assets $18,515,872
4 LONG-TERM DEBT —
Changes in long-term debt during 2002 were as follows:
Balance Balance
Jan 1, 2002 Additions Deductions Dec 31,2002
General Obligation Bonds $15,777,696 $2,450,000 $2,976,502 $15,251,194 —
Special Assessment Bonds 2,545,000 960,000 1,015,000 2,490,000
HRA Lease Revenue Bonds - 10,760,000 - 10,760,000
Total 18,322,696 14,170,000 3,991,502 28,501,194 —
Enterprise Revenue Bonds 6,740,000 - 1,940,000 4,800,000
Total $25,062,696 $14,170,000 $ 5,931,502 $33,301,194
The long-term debt obligations outstanding at year-end are summarized as follows:
Bonds Maturities Interest Rate Dec 31, 2002 —
General Obligation Bonds 2003-2023 2.00-8.10% $ 15,251,194
Special Assessment Bonds 2003-2010 1.65-4.80% 2,490,000 —
Revenue Bonds 2003-2015 2.75-5.50% 4,800,000
HRA Lease Revenue Bonds 2003-2023 3.00-5.00% 10,760,000
38
City of Hopkins, Minnesota
NOTES TO FINANCIAL STATEMENTS -CONTINUED
December 31,2002
Long-term debt maturities (including interest of$15,882,649) are as follows:
_ Year Ending Special
December 31 General Revenue Assessment Total
2003 2,446,026 559,183 269,276 3,274,485
2004 2,879,188 570,675 370,780 3,820,643
2005 3,199,531 571,048 371,651 4,142,230
2006 2,320,856 565,548 361,927 3,248,331
2007 2,204,987 568,899 361,378 3,135,264
2008 2,195,407 570,821 354,854 3,121,082
2009 2,186,350 561,596 224,865 2,972,811
2010 2,071,096 561,464 226,534 2,859,094
2011 2,262,894 334,360 120,195 2,717,449
Thereafter 18,339,073 1,330,340 223,041 19,892,454
Less: Interest 14,094,214 1,393,934 394,501 15,882,649
$ 26,011,194 $ 4,800,000 $ 2,490,000 $ 33,301,194
During 2002,the HRA issued$10,760,000 in Housing and Redevelopment Authority Lease Revenue Bonds, Series
2002A in and for the city. The net proceeds of$10,686,572 are to be used to finance the construction of a new public
works facility and fire station. The proceeds are being retained in debt service reserve and in the capital project fund.
The city issued $2,450,000 General Obligation Tax Increment Bonds, Series 2002A. The net proceeds of$2,405,470
_ are to be used to finance a portion of public improvements in Tax Increment District 2-11. The city also issued
$960,000 in General Obligation Permanent Improvement Revolving(PIR)Fund Bonds, Series 2002B. The net
proceeds of$933,085 are to be used to reimburse the city for project costs incurred in the PIR fund.
General Obligation Bonds are backed by the full faith, credit and taxing power of the City, and are serviced by
General and Tax Increment levies and also by fees assessed against benefited properties.
Revenue Bonds are backed by the full faith, credit and taxing power of the City, and are serviced by the Water and
Storm Sewer Utility Funds current revenues.
City Special Assessment Bonds are backed by the full faith, credit and taxing power of the City, and repayment
monies are generated by the collection of special assessments and general levies.
Housing and Redevelopment Authority bonds are backed by the full faith, credit and taxing power of the HRA, and
repayment monies are generated by annual lease appropriations from the city.
The City is subject to a statutory limit of bonded indebtedness equaling 2.0 percent of market value. At December
31, 2002, the debt limit for the City is$19,424,044. Of the total debt, $11,762,426 of general obligation and revenue
bonds is applicable to the limit. The legal debt margin is$7,661,618.
5 DESIGNATIONS AND RESERVES OF FUND EQUITY
Fund equity in the various funds has been reserved or designated at December 31,2002 as follows:
Reserved
General Fund:
Inventories $ 84,993
_ Advance to other funds 495,174
Prepaid items 295
Total $ 580,462
39
City of Hopkins, Minnesota
NOTES TO FINANCIAL STATEMENTS -CONTINUED
December 31,2002 _
Special Revenue Funds:
Loans receivable 470,051
Long term receivables 2,330,552 '
Tax Increment projects 2,084,297
Valley Park Condominiums 55,100
Patio Homes 49,862
Total 4,989,862
Debt Service Funds:
Debt service 2,728,091 _
Capital Projects Funds:
Phase I facility project 10,107,076
Enterprise Funds:
Storm Sewer Utility Fund:
Bonds and Interest 402,096
Total Reserved $18,227,125
Designated
General Fund:
Budget Carryovers 144,300
Working Capital 2,609,690
Total 2,753,990
Special Revenue Funds
Housing Rehab 95,000
Market Place Lofts 40,000
State Chemical Assessment 13,981
Total 148,981 _
Capital Projects Funds:
Street Improvements 3,709,832
Total Designated $ 6,612,803 '
6 INTERFUND RECEIVABLES AND PAYABLES
The following funds had amounts receivable from other funds, and the respective funds had equal amounts payable to
other funds at December 31,2002:
Interfund Interfund _
Fund Receivable Payable
General Fund $ 141,291 $ 56,280
Special Revenue Funds:
State Chemical Assessment Fund - 3,000
Economic Development Fund 1,600,730 -
Tax Increment 1.1 Fund 731,738 -
Community Development Block Grant Fund 629 50,000
Tax Increment 1.2 Fund - 1,858,203
Paratransit Fund - 14,000
Housing Rehabilitation Fund 50,000 629 _
Cable TV Fund - -
Depot Coffee House Fund - 65,000
Tax Increment 2.6 Fund - 457,479
Tax Increment 2.9 Fund 14,494 -
Art Center 25,000 -
40
City of Hopkins,Minnesota
NOTES TO FINANCIAL STATEMENTS-CONTINUED
December 31,2002
Capital Project Funds:
Permanent Improvement Revolving Fund 53,660 393,400
Municipal State Aid Fund - 15,000
Enterprise Funds:
Water Utility Fund 300,000 3,125
Sanitary Sewer Fund 400,000 5,500
Storm Sewer Utility Fund 393,400 745,035
Housing and Redevelopment Authority Fund - 33,291
Skate Park - 11,000
Total 3.710.942 3.710.942
7 SEGMENT INFORMATION FOR ENTERPRISE FUNDS
The City maintains seven Enterprise funds which account for water, sewer, refuse, storm sewer utility operations,
pavilion/ice arena operations, skate park operations and low income housing rentals. Segment information for the
year ended December 31, 2002 is as follows:
Storm
Water Sewer Refuse Sewer Total
Utility Utility Utility Utility Utility
Fund Fund Fund Fund Funds
Operating Revenues $ 855,683 $ 1,334,592 $ 614,643 $ 708,852 $ 3,513,770
Depreciation Expense 274,744 146,070 31,619 171,751 624,184
Operating Income(Loss) (132,242) (87,244) (52,024) 431,578 160,068
_ Operating Transfer In 166,108 - - - 166,108
Operating Transfer Out - 166,108 - 26,952 193,060
Net Income(Loss) (23,895) (218,345) (2,181) 243,913 (508)
Grants - - 28,898 - 28,898
Property and Equipment:
Additions 208,068 101,648 8,070 722,605 1,040,391
Deletions 150 3,664 - 393,400 397,214
Net Working Capital 981,609 1,158,778 598,396 (645,470) 2,093,313
Total Assets 6,207,458 4,508,467 1,080,477 7,270,493 19,066,895
Bonds Payable/Advance 1,845,000 - - 23955,000 4,800,000
Contributed Capital - 472,684 - - 472,684
Total Equity $ 4,220,093 $ 4,311,036 $ 1,016,292 $ 3,469,704 $ 13,017,125
41
City of Hopkins, Minnesota
NOTES TO FINANCIAL STATEMENTS -CONTINUED
December 31,2002 _
7 SEGMENT INFORMATION FOR ENTERPRISE FUNDS,(continued)
Pavilion/ Total
Ice Art Skate Housing All
Arena Center Park Authority Enterprise
Fund Fund Fund Fund Funds _
Operating Revenues $ 276,097 $ - $ 17,314 $ 230,285 $ 4,037,466
Depreciation Expense 58,075 - 3,038 - 685,297
Operating Income(Loss) (38,697) - (24,716) (67,240) 29,415
Operating Transfer In - - - - 166,108
Operating Transfer(Out) - - - - 193,060
Net Income(Loss) (35,514) - (24,810) 78,755 17,923 --
Grants - - - 146,247 175,145
Property and Equipment:
Additions 69,072 - - - 1,045,954 _
Deletions/Transfers - 4,148,603 - - 4,545,817
Net Working Capital 27,640 - (10,764) 66,728 2,176,917
Total Assets 2,015,719 - 21,840 135,307 21,239,761
Bonds Payable/Advance - - - - 4,800,000
Contributed Assets 2,085,025 - - - 2,557,709
Total Equity $ 1,941,667 $ - $ 10,503 $ 66,728 $ 15,036,023
8 PENSION PLANS
A. Defined Benefit Pension Plans-Statewide
1. Plan Description
All full-time and certain part-time employees of the City of Hopkins are covered by defined benefit plans
administered by the Public Employees Retirement Association of Minnesota (PERA). PERA administers the
Public Employees Retirement Fund (PERF), the Public Employees Police and Fire Fund (PEPFF) and the Local _
Government Correctional Service Retirement Fund, called the Public Employees Correctional Fund (PECF),
which are cost sharing, multiple-employer retirement plans. These plans are established and administered in
accordance with Minnesota Statutes,Chapters 353 and 356.
PERF members belong to either the Coordinated Plan or the Basic Plan. Coordinated Plan members are covered
by Social Security and Basic Plan members are not. All new members must participate in the Coordinated Plan.
All police officers, fire fighters and peace officers who qualify for membership by statute are covered by PEPFF. --
Members who are employed in a county correctional institution as a correctional guard or officer, a joint
jailer/dispatcher, or as a supervisor of correctional guards or officers or of joint jailers/dispatchers and are directly
responsible for the direct security, custody, and control of the county correctional institution and its inmates are _
covered by the PECF.
PERA provides retirement benefits as well as disability benefits to members, and benefits to survivors upon death
of eligible members. Benefits are established by State Statute, and vest after three years of credited service. The
defined retirement 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 PERF's Coordinated and Basic Plan members. The retiring
member receives the higher of a step-rate benefit accrual formula(Method 1) or a level accrual formula(Method
2). Under Method 1,the annuity accrual rate for a Basic Plan member is 2.2 percent of average salary for each of _
42
City of Hopkins, Minnesota
NOTES TO FINANCIAL STATEMENTS -CONTINUED
December 31,2002
the first 10 years of service and 2.7 percent for each remaining year. The annuity accrual rate for a Coordinated
Plan member is 1.2 percent of average salary for each of the first 10 years and 1.7 percent for each remaining year.
_ Under Method 2, the annuity accrual rate is 2.7 percent of average salary for Basic Plan members and 1.7 percent
for Coordinated Plan members for each year of service. For PEPFF members, the annuity accrual rate is 3.0
percent for each year of service. The annuity accrual rate is 1.9 percent for each year of service for PECF. For all
PEPFF members, PECF members and PERF members hired prior to July 1, 1989 whose annuity is calculated using
Method 1, a full annuity is available when age plus years of service equal 90. Normal retirement age is 55 for
PEPFF and PECF members and 65 for Basic and Coordinated members hired prior to July 1, 1989. Normal
retirement age is the age for unreduced Social Security benefits capped at 66 for Coordinated members hired on or
after July 1, 1989. A reduced retirement annuity is also available to eligible members seeking early retirement.
There are different types of annuities available to members upon retirement. A single-life annuity is a lifetime
_ annuity that ceases upon the death of the retiree--no survivor annuity is payable. There are also various types of
joint and survivor annuity options available which will be payable over joint lives. Members may also leave their
contributions in the fund upon termination of public service in order to qualify for a deferred annuity at retirement
age. Refunds of contributions are available at any time to members who leave public service, but before
retirement benefits begin.
The benefit provisions stated in the previous paragraphs of this section are current provisions and apply to active
plan participants. 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.
PERA issues a publicly available financial report that includes financial statements and required supplementary
information for PERF, PEPFF, and PECF. That report may be obtained on the web at mnpera.com, by writing to
PERA,60 Empire Drive#200, St.Paul, Minnesota,55103-2088 or by calling(651)296-7460 or 1-800-652-9026.
2. Funding Policy
Minnesota Statutes Chapter 353 sets the rates for employer and employee contributions. These statutes are
established and amended by the state legislature. The City makes annual contributions to the pension plans equal
to the amount required by state statutes. PERF Basic Plan members and Coordinated Plan members are required
to contribute 9.1% and 5.1%, respectively, of their annual covered salary. PEPFF members are required to
contribute 6.20% of their annual covered salary. PECF members are required to contribute 5.83%of their annual
covered salary. The City of Hopkins is required to contribute the following percentages of annual covered
payroll: 11.78% for Basic Plan PERF members, 5.53% for Coordinated Plan PERF members, 9.3% for PEPFF
members, and 8.75% for PECF members. The City's contributions to the Public Employees Retirement Fund for
the years ending December 31, 2002, 2001, and 2000 were $219,858, $196,695 and $183,408, respectively. The
City's contributions to the Public Employees Police & Fire Fund for the years ending December 31, 2002, 2001,
and 2000 were $142,797, $143,516 and $135,288, respectively. The City's contributions were equal to the
contractually required contributions for each year as set by state statute.
B. Hopkins Fire Relief Association(HFRA)
Plan Description
The City contributes to the Hopkins Fire Relief Association(Association); a single employer defined benefit plan.
The Association administers the plan and issues separate financial statements that can be obtained by contacting
the Association.
Volunteer firefighters of the City are members of the Association. The plan provides for permanent and short
term disability benefits, death benefits and pensions with a set value for the annual withdrawal amount. Full
vesting in the plan requires a member to have served for at least 5 years, to have reached the age of 50 years and
43
City of Hopkins, Minnesota
NOTES TO FINANCIAL STATEMENTS -CONTINUED
December 31,2002 _
to have been a member of the Association for at least 20 years. These benefit provisions and all other
requirements are consistent with enabling statutes. _
Funding Policy and Annual Pension Information
The governing board of the Association requests changes in benefit levels and contribution requirements that must
be approved by the City Council. The funding policy provides that contributions from the City and from the State
of Minnesota are in amounts sufficient to accumulate assets to pay benefits when due. The City passes through
state aids allocated to the plan, in accordance with state statutes. The annual pension information is as follows:
2002 Contributions: City $29,870
State $65,013 _
Actuarial valuation date: 12/31/02
Actuarial cost method: Entry age normal actuarial cost method
Assumed rate of return: 5%
Actuarial valuation period Open '
Amortization method Level dollar–open
Amortization period Ten years
Inflation rate None
Projected salary increases Not applicable
Post retirement benefit increases $200 per year of service
Annual Pension Benefit Cost for Past Three Years
Annual Pension %of Annual Pension Net Pension Obligation
Year Ended Cost(APC) Cost Contributed At Year Ended
12/31/02 $ 29,870 100% $0
12/31/01 $ 29,000 100% $0
12/31/00 $ 29,000 118% $0 —
Actuarial Valuations(unaudited)
Actuarial Actuarial Accrued Excess(Under) '
Actuarial Value of Liability (AAL) Of Assets Funded
Valuation Assets Entry Age Over AAL Ratio
Date (a) (b) (a-b) (a/b) —
12/31/01 $2,423,167 $2,691,355 $(268,188) 90%
12/31/01 $2,726,858 $2,610,924 $ 115,934 104%
12/31/00 $2,694,630 $2,436,824 $257,406 111%
The estimated accrued liability of$2,691,355 at December 31, 2002 was calculated using the State of Minnesota
Schedule I form for lump sum pension plans. This results in negative net assets available for benefits of
($268,188), as of December 31, 2002. The Hopkins Fire Department is a volunteer organization and therefore '
does not have payroll to disclose.
9. BUDGET INFORMATION
For the year ended December 31, 2002, actual expenditures exceeded th; budgeted amount in the State Chemical
Assessment fund and the Cable TV fund,by$69 and$1,433, respectively. —
Budgets are adopted for some special revenue fund types but not all. Excluded from the budget adoption process are
funds that are completely reimbursable from the federal government. The Community Development Block Grant is a
44
City of Hopkins,Minnesota
NOTES TO FINANCIAL STATEMENTS-CONTINUED
December 31,2002
non-budgeted fund. Following is a reconcilement of budgeted and non-budgeted funds actual revenues and
expenditures:
Budgeted Special Non-budgeted Total Special
Revenue Funds Funds Revenue Funds
_ Total Revenue $ 3,854,588 $ 211,593 $ 4,066,181
Total Expenditure $ 2,750,702 $ 228,730 $ 2,979,432
10 FUND BALANCE AND RETAINED EARNINGS DEFICITS
At December 31, 2002, the following funds had deficit fund balances or retained earnings. These deficits will be
corrected through future tax levies, contributions or charges for services:
Art Center $1,049,845
Tax Increment 2.6 $ 438,326
Pavilion/Ice Arena $ 143,358
11 REHABILITATION LOANS RECEIVABLE
—' The City makes rehabilitation loans to residential and commercial entities within the City. Residential loans are made
for 20 year periods at 3%interest. A mortgage against the property improved is required and City staff is responsible
to follow-up any delinquent accounts. Loan repayments are made to Matrix Financial Services,a loan service bureau,
which charges a fee of$5.95 per month per loan. Principal and interest are forwarded to the City monthly with loan
collection and loan status reports. Rehabilitation loan activity is a function of the Economic Development Fund, the
Hennepin County CDBG and the Housing Rehab Funds. Loans become due in full upon sale of property.
Rehabilitation loans receivable amounted to$470,051 at December 31,2002.
12 CLAIMS AND LITIGATION
The City had the usual and customary types of miscellaneous claims pending at year-end, which are of a minor nature
and usually all covered by insurance carried for that purpose. The City carries a$1,000,000 Public Official Liability
Insurance policy with public entity and employee endorsement.
13 SUBSEQUENT EVENTS
On May 20, 2003, the City issued Housing and Rehabilitation Authority (HRA) bonds in the amount of$3,050,000
and Storm Sewer Revenue bonds in the amount of$1,265,000. The proceeds of the bonds will be used for the police
facility remodeling project and storm sewer projects respectively.
14 RISK MANAGEMENT
The City is exposed to various risks of loss related to torts; theft of, damage to, and destruction of assets; errors and
omissions; injuries to employees; and natural disasters. The City participates in a public entity risk pool to mitigate
its exposure to these risks. Workers compensation and property and liability coverage's are provided through a
pooled self-insurance plan with other cities. Settled claims have not exceeded insurance coverage in any of the past
three fiscal years. The city pays an annual premium based on prior claims history for its workers compensation
coverage. The public entity risk pool is responsible for the payment of all associated claims. The City has a$20,000
deductible per occurrence with a maximum per year out of pocket of$40,000, for its property and liability coverage.
The public entity risk pool is responsible for all losses in excess of$20,000 per occurrence and all losses occurring
after the$40,000 maximum city out of pocket costs.
45
City of Hopkins, Minnesota
NOTES TO FINANCIAL STATEMENTS -CONTINUED
December 31,2002 —
15 RESIDUAL EQUITY TRANSFER
The City transferred its Art Center enterprise fund's equity to the Art Facility Construction special revenue fund and —
general fixed asset account group. The transfer consisted of ($1,070,069) of retained earnings and ($8,074) of
contributed capital,totaling($1,078,143). The fund was renamed Art Center fund. The Art Center fund will be used
to pay for operating expenditures of the Hopkins Art Center. —
16 NEW ACCOUNTING STANDARDS
In June 1999, the Governmental Accounting Standards Board (GASB) issued its statement on financial reporting, —
GASB 34, "Basic Financial Statements – and Management Discussion and Analysis – For State and Local
Governments" The new financial reporting model required by the statement changes the presentation of
governments' external financial statements. The effective date of the new pronouncement will require —
implementation by the City for its year ending December 31, 2003. Management is currently studying the impact of
adopting GASB No. 34 and other related pronouncements.
46
CITY OF HOPKI NS, MINNESOTA
COMPREHENSIVE ANNUAL FINANCIAL REPORT
SECTION IIB
COMBINING, INDIVIDUAL FUNDS AND
ACCOUNT GROUPS
- STATEMENTS AND SCHEDULES
47
CITY OF HOPKINS, MINNESOTA -
COMPREHENSIVE ANNUAL FINANCIAL REPORT _
GENERAL FUND
The Home Rule Charter of the City of Hopkins provides in Section 7.11 "There shall
be maintained in the City Treasury a general fund for the payment of such expenses
as the Council may deem proper. Into this fund shall be paid all moneys levied for
this fund and all moneys not required to be placed in some other fund."
The General Fund is established to account for the revenue and expenditures to
carry out basic governmental activities of the city such as general government,
public safety, public works, community development and parks and recreation.
Revenue is recorded by source; i.e., taxes, licenses, and General Fund expenditures w
are made primarily for current day-to-day operations and operating equipment and
are recorded by major functional classifications and by operating departments.
48 _
CITY OF HOPKINS, MINNESOTA B
GENERALFUND
BALANCESHEET
December 31, 2002
With Comparative Amounts for December 31, 2001
2002 2001
ASSETS
Cash and investments $ 3,543,736 $ 3,110,992
Taxes receivable 79,421 193,961
Accounts receivable 45,634 23,632
Accrued interest receivable 28,264 40,018
Due from other funds 141,291 132,883
Due from other governments 16,596 41,733
Prepaid items 295 4,364
Advance to other funds 495,174 534,783
Inventory 84,993 78,241
Total Assets $ 4,435,404 $ 4,160,607
LIABILITIES AND FUND BALANCE
Liabilities:
Accounts payable $ 316,712 $ 253,502
_ Compensated absences payable 559,404 541,230
Due to other funds 56,280 -
Deferred revenue 118,705 159,281
Deposits payable 7,900 7,889
Total Liabilities 1,059,001 961,902
Fund Balance:
Reserved:
Inventory 84,993 78,241
Advance to other funds 495,174 534,783
Prepaid Items 295 4,364
Unreserved:
Designated for downtown park stage - 32,000
Designated for Shady Oak Beach Development - 122,816
Designated for budget carryovers 144,300 61,000
Designated for capital improvement fund - 50,000
Designated for working capital 2,609,690 2,295,610
Undesignated 41,951 19,891
Total Fund Balance 3,376,403 3,198,705
Total Liabilities and Fund Balance $ 4,435,404 $ 4,160,607
49
CITY OF HOPKINS,MINNESOTA B-1
GENERAL FUND -
STATEMENT OF REVENUES, EXPENDITURES,AND
CHANGES 1N FUND BALANCE-BUDGET AND ACTUAL
Year Ended December 31, 2002 -
With Comparative Actual Amounts for Year Ended December 31, 2001
2002
Variance--
favorable 2001
Budget Actual (unfavorable) Actual -
Revenues:
Property taxes $ 6,171,140 $ 5,799,310 $ (371,830) $ 4,740,931
Licenses and permits 426,105 468,312 42,207 377,048
Intergovernmental 1,197,987 1,521,976 323,989 2,175,051
Fines and forfeitures 140,000 115,354 (24,646) 113,353
Charges for services 229,618 296,523 66,905 193,337 -
Investment earnings 163,000 116,211 (46,789) 160,343
Other 12,100 14,499 2,399 95,428
Total Revenues 8,339,950 8,332,185 (7,765) 7,855,491 -
Expenditures:
General government 945,731 874,288 71,443 827,483 _
Public safety 3,607,757 3,625,449 (17,692) 3,359,401
Community development 741,084 693,193 47,891 759,178
Public works 1,680,418 1,547,079 133,339 1,573,614 _
Recreation 502,317 479,277 23,040 480,186
Other 47,527 93,508 (45,981) 34,290
Capital outlay 830,132 786,315 43,817 617,882
Total Expenditures 8,354,966 8,099,109 255,857 7,652,034
Excess(Deficiency)of revenues over(under)
expenditures (15,016) 233,076 248,092 203,457
Other Financing Sources(Uses):
Operating transfers out: (24,500) (55,378) (30,878) (31,379) -
Excess(Deficiency)of revenues over(under)
expenditures and other financing sources(uses) (39,516) 177,698 217,214 172,078
Fund Balance-January 1 3,198,705 3,198,705 - 3,126,627
Residual equity transfer out - - - (100,000)
Fund Balance- December 31 $ 3,159,189 $ 3,376,403 $ 217,214 $ 3,198,705
50 -
CITY OF HOPKINS,MINNESOTA B-2
GENERALFUND
SCHEDULE OF REVENUES -BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31, 2001
_ 2002
Variance--
Adjusted favorable 2001
_ Budget Actual (unfavorable) Actual
Taxes
General property taxes $ 5,430,411 $ 5,110,215 $ (320,196) $ 4,093,235
Fiscal disparities 740,729 689,095 (51,634) 647,696
Total Taxes 6,171,140 5,799,310 (371,830) 4,740,931
Licenses and permits
Business 117,030 123,700 6,670 129,606
Non-business 309,075 344,612 35,537 247,442
Total Licenses and permits 426,105 468,312 42,207 377,048
Intergovernmental
Local government aids 807,989 964,975 156,986 840,291
_ Market value aid credit - 156,986 156,986 -
Homestead credit - - - 991,632
State grants 43,610 52,112 8,502 125,601
Insurance premium -police 139,800 147,490 7,690 145,043
- Insurance premium- fire 65,013 65,013 - 56,885
Federal grants 126,375 119,123 (7,252) 11,843
Other grants 15,200 16,277 1,077 3,756
- Total Intergovernmental 1,197,987 1,521,976 323,989 2,175,051
Fines and forfeitures
- Court fines 140,000 115,354 (24,646) 113,353
Charges for services
General government - 2,915 2,915 22,817
Public safety 35,100 58,189 23,089 50,596
Public works 7,640 3,409 (4,231) 4,613
Recreation 70,100 58,207 (11,893) 44,441
Community Development 116,778 173,803 57,025 70,870
Total Charges for services 229,618 296,523 66,905 193,337
Other
Investment earnings 163,000 116,211 (46,789) 160,343
Miscellaneous 12,100 14,499 2,399 95,428
- Total Other 175,100 130,710 (44,390) 255,771
Total Revenues $ 8,339,950 $ 8,332,185 $ (7,765) $ 7,855,491
51
CITY OF HOPKINS, MINNESOTA B-3
GENERAL FUND -
SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL
Year Ended December 31, 2002 _
With Comparative Actual Amounts for Year Ended December 31, 2001
2002 _
Variance
favorable 2001
GENERAL GOVERNMENT Budget Actual (unfavorable) Actual -
Mayor and Council
Salaries and employee benefits $ 26,279 $ 26,497 $ (218) $ 26,267
Materials, supplies and services 87,243 56,466 30,777 77,168 -
Total 113,522 82,963 30,559 103,435
Administrative Services -
Salaries and employee benefits 395,710 392,270 3,440 336,146
Materials, supplies and services 91,208 71,099 20,109 60,502
Capital outlay 5,898 6,898 (1,000) 5,135
Total 492,816 470,267 22,549 401,783
Less expenditures charged to other activities (104,083) (104,088) 5 (95,188)
Net 388,733 366,179 22,554 306,595
Finance
Salaries and employee benefits 260,322 260,006 316 237,912
Materials, supplies and services 37,600 37,077 523 39,523
Capital outlay 25,626 25,626 - 24,727 _
Total 323,548 322,709 839 302,162
Less expenditures charged to other activities (169,645) (169,296) (349) (159,273)
Net 153,903 153,413 490 142,889 -
Legal Services
Materials, supplies and services 122,950 112,749 10,201 97,517 -
Municipal Building
Salaries and employee benefits 80,209 70,356 9,853 93,124 -
Materials, supplies and services 160,690 156,401 4,289 164,538
Capital outlay 19,976 19,771 205 31,961
Total 260,875 246,528 14,347 289,623 -
Less expenditures charged to other activities (167,760) (167,880) 120 (175,741)
Net 93,115 78,648 14,467 113,882
Elections
Salaries and employee benefits 11,964 14,557 (2,593) 10,349
Materials, supplies and services 17,588 16,603 985 9,385 -
Total 29,552 31,160 (1,608) 19,734
52 -
CITY OF HOPKINS, MINNESOTA B-3
GENERAL FUND
SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31, 2001
2002
Variance-
favorable 2001
GENERAL GOVERNMENT(continued) Budget Actual (unfavorable) Actual
City Clerk and Reception
Salaries and employee benefits $ 107,135 $ 115,119 $ (7,984) $ 112,883
Materials, supplies and services 9,921 7,856 2,065 13,871
Capital outlay 2,060 2,060 - 1,994
Total 119,116 125,035 (5,919) 128,748
Less expenditures charged to other activities (21,600) (21,504) (96) (21,500)
Net 97,516 103,531 (6,015) 107,248
TOTAL GENERAL GOVERNMENT 999,291 928,643 70,648 891,300
PUBLIC SAFETY
Police
Police Administration
Salaries and employee benefits 260,591 290,243 (29,652) 229,301
Materials, supplies and services 65,457 53,284 12,173 78,829
Capital outlay 23,023 23,023 - 61,607
Total 349,071 366,550 (17,479) 369,737
Less expenditures charged to other activities (300,000) (300,840) 840 (335,760)
Net 49,071 65,710 (16,639) 33,977
Police Patrol and Investigation
Salaries and employee benefits 1,795,629 1,736,177 59,452 1,638,168
Materials, supplies and services 453,794 529,983 (76,189) 463,480
Capital outlay 209,315 177,536 31,779 105,649
Total 2,458,738 2,443,696 15,042 2,207,297
_ Police Services
Salaries and employee benefits 678,633 667,441 11,192 614,746
Materials, supplies and services 178,119 171,836 6,283 193,008
Capital outlay 130,351 145,930 (15,579) 37,211
Total 987,103 985,207 1,896 844,965
Total Police 3,494,912 3,494,613 299 3,086,239
53
CITY OF HOPKINS, MINNESOTA B-3
GENERALFUND -
SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL
Year Ended December 31, 2002 -
With Comparative Actual Amounts for Year Ended December 31,2001
2002 _
Variance--
favorable 2001
PUBLIC SAFETY(continued) Budget Actual (unfavorable) Actual -
Fire
Salaries and employee benefits 299,836 309,723 (9,887) 308,746
Materials, supplies and services 175,698 167,602 8,096 168,883 -
Capital outlay 113,787 113,280 507 133,046
Total 589,321 590,605 (1,284) 610,675
TOTAL PUBLIC SAFETY 4,084,233 4,085,218 (985) 3,696,914
COMMUNITY DEVELOPMENT -
Planning and Economic Development
Salaries and employee benefits 81,835 75,968 5,867 111,609
Materials, supplies and services 22,826 10,169 12,657 58,382 -
Capital outlay 1,165 1,165 - 1,150
Total 105,826 87,302 18,524 171,141
Assessing
Salaries and employee benefits 207,867 209,644 (1,777) 203,186
Materials, supplies and services 22,050 19,781 2,269 23,178 -
Capital outlay 2,938 2,938 - 3,239
Total 232,855 232,363 492 229,603
Inspections
Salaries and employee benefits 346,233 329,786 16,447 315,163 _
Materials, supplies and services 60,273 47,845 12,428 47,660
Capital outlay 4,694 11,694 (7,000) 4,535
Total 411,200 389,325 21,875 367,358 -
TOTAL COMMUNITY DEVELOPMENT 749,881 708,990 40,891 768,102
54
CITY OF HOPKINS, MINNESOTA B-3
GENERAL FUND
SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31, 2001
2002
Variance-
favorable 2001
PUBLIC WORKS Budget Actual (unfavorable) Actual
_ Public Works Buildings & Equipment Services
Salaries and employee benefits 178,195 172,216 5,979 168,719
Materials, supplies and services 54,864 48,622 6,242 50,714
Capital outlay 2,624 2,624 - 2,849
Total 235,683 223,462 12,221 222,282
Less expenditures charged to other activities (192,803) (185,536) (7,267) (189,826)
Net 42,880 37,926 4,954 32,456
Public Works Administration and Engineering
Salaries and employee benefits 264,231 270,806 (6,575) 244,960
Materials, supplies and services 41,165 45,318 (4,153) 45,604
Capital outlay 9,913 10,013 (100) 9,765
Total 315,309 326,137 (10,828) 300,329
Less expenditures charged to other activities (199,338) (203,822) 4,484 (205,755)
Net 115,971 122,315 (6,344) 94,574
Streets and Alleys:
Salaries and employee benefits 397,482 335,313 62,169 359,846
Materials, supplies and services 244,132 218,243 25,889 266,414
Capital outlay 96,252 98,625 (2,373) 82,715
_ Total 737,866 652,181 85,685 708,975
Less expenditures charged to other activities (95,987) (95,987) - (104,571)
Net 641,879 556,194 85,685 604,404
Sidewalk Repair and Mall Maintenance:
Salaries and employee benefits 20,706 29,413 (8,707) 19,570
Materials, supplies and services 36,760 31,628 5,132 17,791
Capital outlay 5,247 5,247 - 4,579
Total 62,713 66,288 (3,575) 41,940
Signs, Signals and Lighting:
Salaries and employee benefits 66,943 77,617 (10,674) 74,911
Materials, supplies and services 196,730 167,732 28,998 179,671
Capital outlay 5,247 5,247 - 17,151
Total 268,920 250,596 18,324 271,733
55
CITY OF HOPKINS, MINNESOTA B-3
GENERALFUND -
SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL
Year Ended December 31, 2002 _
With Comparative Actual Amounts for Year Ended December 31,2001
2002
Variance--
favorable 2001
PUBLIC WORKS (continued) Budget Actual (unfavorable) Actual _
Municipal Parks and Tree Service:
Salaries and employee benefits 500,428 496,734 3,694 493,192
Materials, supplies and services 166,910 138,782 28,128 152,374
Capital outlay 42,156 41,407 749 59,985
Total 709,494 676,923 32,571 705,551
TOTAL PUBLIC WORKS 1,841,857 1,710,242 131,615 1,750,658
RECREATION: -
Activity Center
Salaries and employee benefits 186,179 176,053 10,126 173,814
Materials, supplies and services 95,315 95,037 278 97,569 -
Capital outlay 7,044 7,045 (1) 5,584
Total 288,538 278,135 10,403 276,967
Park and Recreation
Salaries and employee benefits 75,323 55,451 19,872 68,001
Materials, supplies and services 145,500 152,736 (7,236) 140,802
Capital outlay 122,816 86,186 36,630 25,000
Total 343,639 294,373 49,266 233,803
TOTAL RECREATION 632,177 572,508 59,669 510,770
UNALLOCATED:
Materials, supplies and services 47,527 93,508 (45,981) 34,290
Transfer out 24,500 55,378 (30,878) 31,379 _
TOTAL UNALLOCATED 72,027 148,886 (76,859) 65,669
TOTAL EXPENDITURES $ 8,379,466 $ 8,154,487 $ 224,979 $ 7,683,413
56
CITY OF HOPKINS, MINNESOTA
COMPREHENSIVE ANNUAL FINANCIAL REPORT
SPECIAL REVENUE FUNDS
_ Special Revenue Funds are used to account for revenues derived from specific taxes or
other earmarked revenue sources. Expenditures are restricted by law or administrative
regulation for specified purposes.
State Chemical Assessment Fund — This fund is entirely supported by state aid for the
purpose of chemical assessment training and activity for the State of Minnesota.
Economic Development Fund - This fund was established to fund development
opportunities. Sources of funds are derived from the administration of loans and rental
property acquired with bonds and grants.
Real Estate Purchases and Sales Fund - This fund records the acquisition and disposition of
various properties with the proceeds used to improve city buildings.
Hennepin County CDBG - This fund accounts for receipt for Community Development
Block Grant funds and the issuance of loans and grants for housing rehabilitation.
Tax Increment Funds - These funds were established to record the use of tax increment
receipts and bond proceeds as applied in various Tax Increment Districts.
Paratransit Fund - This fund was established to account for the receipt of grants and rider
fees and expenditures for transit service.
Housing Rehab Fund - This fund was established to account for funds received under the
Community Development Block Grant funds and Section 8.
Parking Fund -This fund acquired land, improves and maintains parking lots and a parking
ramp and collects monthly maintenance fees from users.
Section 8 Housing Fund — This fund administers the HUD Section 8 Rental Assistance
Program.
Cable TV Fund - This fund records the City's share of a five city joint venture cable TV
franchise administered under the Southwest Suburban Cable Commission.
Depot Coffee House Fund — This fund accounts for the operations of the coffee house
business and the teen center operations which are supported through grant funds.
Art Center Fund — This fund accounts for the operations of the Hopkins Art Center which is
supported through leases, state aids, contributions, sales and intergovernmental transfers.
57
CITY OF HOPKINS,MINNESOTA
SPECIAL REVENUE FUNDS
COMBINING BALANCE SHEET
December 31,2002
With Comparative Totals for December 31,2001
State Real Estate Hennepin Tax
Chemical Economic Purchases County Art Increment
Assessment Development &Sales CDBG Center Districts
ASSETS
Cash and investments $ 851 $ 1,649,206 $ 60,329 $ 1,051 $ 1,992 $ 3,879,607
Taxes receivable - 761 - - - 18,998
Special assessments receivable - - - - - -
Accounts receivable - 24,797 - - 2,670 10,518
Rehabilitation loans receivable - 360,592 - 108,380 - -
Accrued interest receivable - 10,658 376 - (249) 24,768
Due from other funds - 1,600,730 - 629 25,000 746,232
Due from other governments 16,776 - - 48,320 -
Advance to other funds - 300,000 - - -
Long term loans receivable - - - - 2,030,552
Restricted cash and investments -
Total Assets $ 17,627 $ 3,946,744 $ 60,705 $ 158,380 $ 29,413 $ 6,710,675
LIABILITIES AND FUND BALANCE
Liabilities:
Accounts payable $ 646 $ 631,903 $ - $ - $ 16,976 $ 280,144
Compensated absences payable 52,775 - - 30,484
Due to other funds 3,000 - - 50,000 2,315,682
Due to other governments - - - - - -
Deferred revenue - 200,495 - - 236,624 -
Advance from other funds - - - - 795,174
Total Liabilities 3,646 885,173 - 50,000 1,079,258 2,595,826
Fund balances:
Reserved for loans receivable - 360,592 - 108,380 -
Reserved for Patio Homes - - - - -
Reserved for Valley Park Condominiums
Reserved for Tax Increment Projects - - - - - 2,084,297
Reserved for advance to other funds - 300,000 - - - 2,030,552
Unreserved:
Designated for Equipment - - - - -
Designated for Cornerstone Project - - - - - -
Designated for Marketplace Lofts Project - 40,000 - - - -
Designated for State Chemical Assess. 13,981 - - - - -
Designated for Housing Rehab - - - - - -
Undesignated - 2,360,979 60,705 - (1,049,845)
Total Fund Balances 13,981 3,061,571 60,705 108,380 (1,049,845) 4,114,849
Total Liabilities and Fund Balance $ 17,627 $ 3,946,744 $ 60,705 $ 158,380 $ 29,413 $ 6,710,675
58
C
Depot
Housing Section 8 Coffee Totals
Para-Transit Rehab Parking Housing Cable TV House 2002 2001
$ 403 $ 1,013,576 $ 314,464 $ 69,166 $ 329,872 $ 1,890 $ 7,322,407 $ 4,808,949
19,759 64,911
36,554 75,558 150,097 121,995
1,079 - - - 470,051 652,648
6,626 1,853 432 2,314 46,778 52,697
50,000 - - - - 2,422,591 2,468,314
25,019 2,404 11,752 - 104,271 33,168
300,000 300,000
2,030,552 2,070,827
49,000 - - - 49,000 49,000
$ 25,422 $ 1,120,281 $ 318,721 $ 81,350 $ 368,740 $ 77,448 $ 12,915,506 $ 10,622,509
$ 9,181 $ 3,315 $ 3,820 $ 2,056 $ 73,513 $ 8,829 $ 1,030,383 $ 413,850
2,241 6,244 600 977 3,331 2,492 99,144 46,710
14,000 629 - - - 65,000 2,448,311 2,539,667
250 - - - - 250 250
18,818 - - - 455,937 219,666
- - - 795,174 -
25,422 10,438 23,238 3,033 76,844 76,321 4,829,199 3,220,143
1,079 - - - - 470,051 2,341,035
49,862 - - - - 49,862 49,862
55,100 55,100 55,100
- - - - 2,084,297 -
- - - - 2,330,552 2,370,827
2,000
525,000
- - - 40,000 -
13,981 24,754
95,000 - - 95,000 85,000
908,802 295,483 78,317 291,896 1,127 2,947,464 1,948,788
1,109,843 295,483 78,317 291,896 1,127 8,086,307 7,402,366
$ 25,422 $ 1,120,281 $ 318,721 $ 81,350 $ 368,740 $ 77,448 $ 12,915,506 $ 10,622,509
59
CITY OF HOPKINS, MINNESOTA —
TAX INCREMENT FUNDS
COMBINING BALANCE SHEET —
December 31, 2002
With Comparative Totals for December 31, 2001 —
Tax Tax Tax Tax —
Increment Increment Increment Increment
1.1 1.2 2.1 2.6
ASSETS —
Cash and investments $ 231,989 $ 15,444 $ 388,360 $ 8,677
Taxes receivable 17,365 - - -
Accounts receivable - - - 10,422
Accrued interest receivable 1,445 96 2,419 54
Due from other funds 731,738 - - -
Long term loans receivable - 2,030,552 - -
Restricted cash and investments - - - -
Total Assets $ 982,537 $ 2,046,092 $ 390,779 $ 19,153
LIABILITIES AND FUND BALANCE
Liabilities:
Accounts payable $ - $ - $ 165,627 $ - —
Due to other funds - 1,858,203 - 457,479
Total Liabilities - 1,858,203 165,627 457,479
Fund Balance(Deficit):
Reserved for Tax Increment projects 982,537 (1,842,663) 225,152 (438,326)
Reserved for long term loan receivable - 2,030,552 - - —
Unreserved:
Undesignated - - - -
Total Fund Balance 982,537 187,889 225,152 (438,326)
Total Liabilities and Fund Balance $ 982,537 $ 2,046,092 $ 390,779 $ 19,153
60
Ca
Tax Tax Tax Tax Tax
Increment Increment Increment Increment Increment Totals
2.7 2.8 2.9 2.10 2.11 2002 2001
$ 63,816 $ 42,243 $ 164,824 $ 36,266 $ 2,927,988 $ 3,879,607 $ 1,792,418
- 1,633 - - 18,998 64,911
- - 96 10,518 11,200
1,003 263 1,027 226 18,235 24,768 19,575
14,494 - - 746,232 755,227
- - 2,030,552 2,070,827
$ 64,819 $ 42,506 $ 181,978 $ 36,492 $ 2,946,319 $ 6,710,675 $ 4,714,158
$ - $ 28,298 $ - $ 21,280 $ 64,939 $ 280,144 $ 372,006
- - 2,315,682 2,442,167
28,298 - 21,280 64,939 2,595,826 2,814,173
64,819 14,208 181,978 15,212 2,881,380 2,084,297 -
- - - - - 2,030,552 2,070,827
- - - - - - (170,842)
64,819 14,208 181,978 15,212 2,881,380 4,114,849 1,899,985
$ 64,819 $ 42,506 $ 181,978 $ 36,492 $ 2,946,319 $ 6,710,675 $ 4,714,158
61
CITY OF HOPKINS,MINNESOTA
SPECIAL REVENUE FUNDS
COMBINING STATEMENT OF REVENUES,EXPENDITURES,AND CHANGES IN FUND BALANCES
Year Ended December 31,2002
With Comparative Totals for Year Ended December 31,2001
State Real Estate Hennepin Tax
Chemical Economic Purchases County Art Increment
Assessment Development &Sales CDBG Center Districts
Revenues:
Taxes:
Property tax $ - $ 93,668 $ - $ - $ - $
Tax increment - - - - 2,003,743
Special assessments - - - - -
Intergovernmental:
Federal - - 211,593 - -
State of Minnesota 54,146 - - - 50,000 31,280
Metropolitan Grant 200,000 - - -
Franchise fee - - - - -
Fines and forfeitures - - - - -
Charges for services - 106,533 3,700 - 214,117 14,853
Investment earnings - 36,131 2,013 - (852) 61,667
Other - 220,312 - - 43,200 10,423
Total Revenues 54,146 656,644 5,713 211,593 306,465 2,121,966
Expenditures:
Salaries and employee benefits 26,918 134,481 - - 252,856 -
Materials,supplies and services 38,001 118,528 - 36,361 94,899 52,895
Debt service issuance cost - - - - 40,192
Capital outlay:
Office equipment&furnishing -
Land acquisitions - 385,184 - - 20,280
Site improvements - 391,471 - - - 305,511
Other improvements - - 192,369 - 144,367
Other equipment - 1,669 - - 2,316
Total Expenditures 64,919 1,031,333 - 228,730 350,071 563,245
Less expenditures charged to other
activities (46,500) - - -
Net 64,919 984,833 - 228,730 350,071 563,245
Excess(deficiency)of revenues over
(under)expenditures (10,773) (328,189) 5,713 (17,137) (43,606) 1,558,721
Other Financing Sources(Uses):
Bond proceeds - - - - 2,450,000
Operating transfers in - - - - ✓111,886 -
Operating transfers out - (61,000) - - - (1,793,857)
Total Other Financing Sources(Uses) - (61,000) - - 111,886 656,143
Excess(deficiency)of revenues and other
financing sources over(under)expenditures
and other financing uses (10,773) (389,189) 5,713 (17,137) 68,280 2,214,864
Fund Balance(Deficit)-January 1 24,754 3,450,760 54,992 125,517 (39,982) 1,899,985
Resdidual equity transfer - - - - (1,078,143)
Fund Balance(Deficit)-December 31 $ 13,981 $ 3,061,571 $ 60,705 $ 108,380 $ (1,049,845) $ 4,114,849
62
C-1
Depot
.. Housing Section 8 Coffee Totals
Para-Transit Rehab Parking Housing Cable TV House 2002 2001
^ $ - $ - $ - $ - $ - $ - $ 93,668 $ -
2,003,743 2,730,232
17,000 - - - 17,000 16,000
114,329 - - 325,922 159,859
100,077 - - - - 16,000 251,503 130,500
- 200,000 -
_ - 146,574 - 146,574 138,614
32,758 - - - 32,758 53,899
15,342 150 29,672 - 161,520 545,887 214,450
37,793 11,457 1,850 11,118 - 161,177 228,065
160 - - 13,854 287,949 104,501
115,419 38,103 90,887 116,179 157,692 191,374 4,066,181 3,776,120
12,049 74,736 63,029 54,472 40,948 88,647 748,136 460,750
108,933 23,309 42,035 16,485 25,742 111,564 668,752 545,943
40,192
617 - - 617 1,904
- - 405,464 881,896
- - 696,982 613,432
- - 336,736 644,744
879 43,193 - 76,204 4,792 129,053 35,638
^ 120,982 98,924 148,257 71,574 142,894 205,003 3,025,932 3,184,307
- - (46,500) (62,000)
_ 120,982 98,924 148,257 71,574 142,894 205,003 2,979,432 3,122,307
(5,563) (60,821) (57,370) 44,605 14,798 (13,629) 1,086,749 653,813
- 2,450,000 -
_ 5,563 - - 13,629 131,078 199,379
(50,886) - (1,905,743) (1,902,000)
5,563 - - (50,886) 13,629 675,335 (1,702,621)
(60,821) (57,370) 44,605 (36,088) - 1,762,084 (1,048,808)
1,170,664 352,853 33,712 327,984 1,127 7,402,366 8,451,174
(1,078,143) -
$ $ 1,109,843 $ 295,483 $ 78,317 $ 291,896 $ 1,127 $ 8,086,307 $ 7,402,366
63
CITY OF HOPKINS, MINNESOTA
TAX INCREMENT FUNDS
COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND
CHANGES IN FUND BALANCE
Year Ended December 31, 2002
With Comparative Totals for Year Ended December 31, 2001
Tax Tax Tax Tax
Increment Increment Increment Increment
1.1 1.2 2.1 2.6
Revenues: _
Taxes
Tax increment $ 970,795 $ 44,186 $ 342,549 $ 8,571
Intergovernmenal
Market value aid credit 16,786 - - -
Charges for services 14,853 - - -
Investment earnings 16,163 749 9,631 148 _
Other - - - 10,423
Total Revenues 1,018,597 44,935 352,180 19,142
Expenditures:
Materials, supplies and services - 4,384 6,123 530
Bonds issuance expense - - - -
Capital outlay:
Land acquisitions - - - -
Construction - - - -
Public improvemnts - - - - �-
Site improvements - 63,539 165,564 -
Total Expenditures - 67,923 171,687 530
Excess(deficiency)of revenues over(under) 1,018,597 (22,988) 180,493 18,612
expenditures
Other Financing Sources(Uses)
Bonds proceeds - - - -
Operating transfer to debt service (1,335,000) - (220,000) -
Total Other Financing Sources(Uses) (1,335,000) - (220,000) -
Excess(Deficiency)of revenues over(under)
expenditures and other financing uses (316,403) (22,988) (39,507) 18,612
Fund Balance(Deficit)- January 1 1,298,940 210,877 264,659 (456,938) _
Fund Balance(Ddeficit)- December 31 $ 982,537 $ 187,889 $ 225,152 $ (438,326)
64
C-1 a
Tax Tax Tax Tax Tax
Increment Increment Increment Increment Increment Totals
2.7 2.8 2.9 2.10 2.11 2002 2001
$ 66,461 $ 38,338 $ 1.00,307 $ 59,112 $ 373,424 $ 2,003,743 $ 2,730,232
14,494 - - 31,280 -
14,853 15,325
4,446 812 6,328 410 22,980 61,667 59,669
10,423 11,300
70,907 39,150 121,129 59,522 396,404 2,121,966 2,816,526
-' 9,061 9,982 2,342 3,567 16,906 52,895 82,917
_ - 40,192 40,192 -
20,280 20,280 871,896
- 365,558
144,367 144,367 279,186
- 28,298 - 48,110 - 305,511 371,926
9,061 38,280 2,342 51,677 221,745 563,245 1,971,483
61,846 870 118,787 7,845 174,659 1,558,721 845,043
2,450,000 2,450,000
(97,222) - (131,000) - (10,635) (1,793,857) (1,673,000)
(97,222) - (131,000) - 2,439,365 656,143 (1,673,000)
(35,376) 870 (12,213) 7,845 2,614,024 2,214,864 (827,957)
100,195 13,338 194,191 7,367 267,356 1,899,985 2,727,942
$ 64,819 $ 14,208 $ 181,978 $ 15,212 $ 2,881,380 $ 4,114,849 $ 1,899,985
65
CITY OF HOPKINS,MINNESOTA C-2
STATE CHEMICAL ASSESSMENT TEAM FUND —
STATEMENT OF REVENUES, EXPENDITURES, AND
CHANGES IN FUND BALANCE-BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31, 2001
2002
Variance--
favorable 2001 —
Budget Actual (unfavorable) Actual
Revenues:
Intergovernmental revenue:
State grant $ 62,500 $ 54,146 $ (8,354) $ 54,452
Expenditures: —
Salaries and employee benefits 27,000 26,918 82 17,913
Materials, supplies and services 37,850 38,001 (151) 21,667
Total Expenditures 64,850 64,919 (69) 39,580
Excess(deficiency) of revenues over(under)
expenditures (2,350) (10,773) (8,423) 14,872 —
Fund Balance -January 1 24,754 24,754 - 9,882
Fund Balance - December 31 $ 22,404 $ 13,981 $ (8,423) $ 24,754
66 —
CITY OF HOPKINS, MINNESOTA C-3
ECONOMIC DEVELOPMENT FUND
STATEMENT OF REVENUES,EXPENDITURES, AND
CHANGES IN FUND BALANCE- BUDGET AND ACTUAL
Year Ended December 31,2002
With Comparative Actual Amounts for Year Ended December 31, 2001
2002
Variance--
favorable 2001
Budget Actual (unfavorable) Actual
Revenues:
General property taxes $ 100,000 $ 93,668 $ (6,332) $ -
Intergovernmental:
Metropolitan grant 620,000 200,000 (420,000) -
Charges for services 15,500 106,533 91,033 35,721
Investment earnings 10,000 36,131 26,131 69,967
Other 300,000 220,312 (79,688) 20,613
Total Revenues 1,045,500 656,644 (388,856) 126,301
Expenditures:
_ Salaries and employee benefits 151,231 134,481 16,750 115,148
Materials, supplies and services 81,146 118,528 (37,382) 50,832
Capital outlay:
_ Land 400,000 385,184 14,816 10,000
Site improvements 885,000 391,471 493,529 120,478
Other equipment 1,669 1,669 - 1,695
_ Total 1,519,046 1,031,333 487,713 298,153
Less expenditures charged to other activities (51,500) (46,500) (5,000) (62,000)
Net 1,467,546 984,833 482,713 236,153
Excess (deficiency)of revenues over(under)
expenditures (422,046) (328,189) 98,857 (109,852)
Other Financing Uses:
Operating transfer to Art Center Fund (61,000) (61,000) - (229,000)
Excess(deficiency)of revenues over(under)
expenditures and other financing uses (483,046) (389,189) 93,857 (338,852)
Fund Balance- January 1 3,450,760 3,450,760 - 3,789,612
Fund Balance-December 31 $ 2,967,714 $ 3,061,571 $ 93,857 $ 3,450,760
67
CITY OF HOPKINS,MINNESOTA C-4
REAL ESTATE PURCHASES AND SALES FUND
STATEMENT OF REVENUES,EXPENDITURES, AND
CHANGES IN FUND BALANCE -BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31, 2001
2002
Variance--
favorable 2001 —
Budget Actual (unfavorable) Actual
Revenues:
Charges for services $ 3,700 $ 3,700 $ - $ 3,700 —
Investment earnings 2,800 2,013 (787) 2,668
Total Revenues 6,500 5,713 (787) 6,368
Expenditures: - - - _
Excess of revenues over expenditures 6,500 5,713 (787) 6,368 —
Fund Balance- January 1 54,992 54,992 - 48,624
Fund Balance - December 31 $ 61,492 $ 60,705 $ (787) $ 54,992
68 —
CITY OF HOPKINS, MINNESOTA C-5
PARA-TRANSIT FUND
STATEMENT OF REVENUES, EXPENDITURES, AND
CHANGES IN FUND BALANCE- BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31,2001
2002
Variance--
favorable 2001
Budget Actual (unfavorable) Actual
Revenues:
Intergovernmental:
State grant(Para-Transit) $ 100,077 $ 100,077 $ - $ 60,273
_ Charges for services 18,500 15,342 (3,158) 16,780
Total Revenues 118,577 115,419 (3,158) 77,053
Expenditures:
Salaries and employee benefits 9,982 12,049 (2,067) 8,684
Materials, supplies and services 110,012 108,933 1,079 87,968
Total Expenditures 119,994 120,982 (988) 96,652
Deficiency of revenues over expenditures (1,417) (5,563) (4,146) (19,599)
Other Financing Sources:
Operating transfer from the General Fund 1,417 5,563 4,146 19,599
Deficiency of revenues and other financing
sources over(under) expenditures - - - -
Fund Balance- January 1 - - - -
Fund Balance-December 31 $
69
CITY OF HOPKINS, MINNESOTA C-6
HOUSING REHAB FUND
STATEMENT OF REVENUES,EXPENDITURES, AND
CHANGES IN FUND BALANCE- BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31, 2001
2002
Variance--
favorable 2001
Budget Actual (unfavorable) Actual
Revenues:
Intergovernmental: —
State grants $ - $ - $ - $ 5,775
Charges for services - 150 150 368 _
Investment earnings 65,000 37,793 (27,207) 62,241
Other - 160 160 709
Total Revenues 65,000 38,103 (26,897) 69,093 —
Expenditures:
Salaries and employee benefits 70,564 74,736 (4,172) 67,553 —
Materials, supplies and services 31,753 23,309 8,444 26,436
Capital outlay:
Office equipment& furnishings - - - 1,000 —
Other equipment 879 879 - -
Patio Homes - - - 121,028
Total Expenditures 103,196 98,924 4,272 216,017
Deficiency of revenues under expenditures (38,196) (60,821) (22,625) (146,924)
Fund Balance -January 1 1,170,664 1,170,664 - 1,317,588
Fund Balance-December 31 $ 1,132,468 $ 1,109,843 $ (22,625) $ 1,170,664 —
70
C-7
CITY OF HOPKINS, MINNESOTA
PARKING FUND
STATEMENT OF REVENUES, EXPENDITURES,AND
CHANGES IN FUND BALANCE- BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31, 2001
2002
Variance-
favorable 2001
Budget Actual (unfavorable) Actual
Revenues:
Special assessments $ 16,000 $ 17,000 $ 1,000 $ 16,000
Court fines 45,000 32,758 (12,242) 53,899
_ Charges for services 25,000 29,672 4,672 27,431
Investment earnings 12,000 11,457 (543) 17,697
Total Revenues 98,000 90,887 (7,113) 115,027
Expenditures:
Salaries and employee benefits 73,740 63,029 10,711 67,078
Materials, supplies and services 63,205 42,035 21,170 52,669
Capital outlay:
Other equipment 43,193 43,193 - 576
Total Expenditures 180,138 148,257 31,881 120,323
Excess (deficiency)of revenues over(under)
expenditures (82,138) (57,370) 24,768 (5,296)
Fund Balance-January 1 352,853 352,853 - 358,149
Fund Balance-December 31 $ 270,715 $ 295,483 $ 24,768 $ 352,853
71
CITY OF HOPKINS, MINNESOTA C-8
SECTION 8 HOUSING FUND --
STATEMENT OF REVENUES,EXPENDITURES, AND
CHANGES IN FUND BALANCE- BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31, 2001
2002
Variance--
favorable 2001
Budget Actual (unfavorable) Actual
Revenues:
Intergovernmental:
Federal - Section 8 $ 87,400 $ 114,329 $ 26,929 $ 84,566 _
Investment earnings 600 1,850 1,250 1,092
Total Revenues 88,000 116,179 28,179 85,658
Expenditures:
Salaries and employee benefits 55,417 54,472 945 52,682
Materials, supplies and services 15,853 16,485 (632) 16,428 _
Capital outlay 617 617 - 904
Total Expenditures 71,887 71,574 313 70,014
Excess of revenues over expenditures 16,113 44,605 28,492 15,644
Fund Balance-January 1 33,712 33,712 - 18,068
Fund Balance-December 31 $ 49,825 $ 78,317 $ 28,492 $ 33,712 _
72
CITY OF HOPKINS, MINNESOTA C-9
CABLE TV FUND
STATEMENT OF REVENUES, EXPENDITURES, AND
CHANGES IN FUND BALANCE- BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31, 2001
2002
Variance--
- favorable 2001
Budget Actual (unfavorable) Actual
Revenues:
Franchise fees $ 136,000 $ 146,574 $ 10,574 $ 138,614
Investment earnings 15,000 11,118 (3,882) 14,731
Total Revenues 151,000 157,692 6,692 153,345
Expenditures:
_ Salaries and employee benefits 39,726 40,948 (1,222) 61,205
Materials, supplies and services 27,141 25,742 1,399 58,054
Capital outlay 74,594 76,204 (1,610) 33,367
Total Expenditures 141,461 142,894 (1,433) 152,626
Excess of revenues over expenditures 9,539 14,798 5,259 719
Other Financing Uses:
Operating transfer to Art Center Fund (80,658) (50,886) 29,772 -
Excess (deficiency)of revenues over(under)
expenditures (71,119) (36,088) 35,031 719
Fund Balance - January 1 327,984 327,984 - 327,265
Fund Balance-December 31 $ 256,865 $ 291,896 $ 5,259 $ 327,984
73
CITY OF HOPKINS, MINNESOTA C-10
DEPOT COFFEE HOUSE FUND
STATEMENT OF REVENUES, EXPENDITURES, AND
CHANGES IN FUND BALANCE- BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31, 2001
2002
Variance-- _
favorable 2001
Budget Actual (unfavorable) Actual
Revenues:
Intergovernmental:
State grant $ 10,000 $ 16,000 $ 6,000 $ 10,000 _
Charges for services 126,000 161,520 35,520 115,125
Contributions 52,000 13,854 (38,146) 48,379
Total Revenues 188,000 191,374 3,374 173,504
Expenditures:
Salaries and employee benefits 76,843 88,647 (11,804) 70,487 _
Materials, supplies and services 134,570 111,564 23,006 116,737
Capital outlay - 4,792 (4,792) -
Total Expenditures 211,413 205,003 6,410 187,224 _
Excess(deficiency) of revenues over(under)
expenditures (23,413) (13,629) 9,784 (13,720) _
Other Financing Sources
Operating transfer from the General Fund 23,000 13,629 (9,371) 11,780 _
Excess(deficiency) of revenues and other financing
sources over(under)expenditures (413) - 413 (1,940) -
Fund Balance- January 1 1,127 1,127 - 3,067
Fund Balance-December 31 $ (22,286) $ 1,127 $ 413 $ 1,127
74
CITY OF HOPKINS, MINNESOTA C-11
ART CENTER FUND
STATEMENT OF REVENUES,EXPENDITURES, AND
CHANGES IN FUND BALANCE- BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31, 2001
2002
Variance-
favorable 2001
Budget Actual (unfavorable) Actual
Revenues:
Intergovernmental:
State grant $ 50,000 $ 50,000 $ - $ -
Charges for services 210,700 214,117 3,417 -
Interest earnings - (852) (852) -
Other - 43,200 43,200 23,500
Total Revenues 260,700 306,465 45,765 23,500
Expenditures:
_ Salaries and employee benefits 252,577 252,856 (279) -
Materials, supplies and services 107,791 94,899 12,892 165
Capital outlay 2,316 2,316 - -
Total Expenditures 362,684 350,071 12,613 165
Excess(deficiency)of revenues over(under)
expenditures (101,984) (43,606) 58,378 23,335
Other Financing Sources
Operating transfer from other funds 141,658 111,886 (29,772) 168,000
Excess of revenues and other financing sources
over expenditures 39,674 68,280 28,606 191,335
Fund Balance- January 1 (39,982) (39,982) - (231,317)
Residual Equity transfer (1,078,143) (1,078,143) - -
Fund Balance-December 31 $ (1,078,451) $ (1,049,845) $ 28,606 $ (39,982)
75
CITY OF HOPKINS,MINNESOTA C-12
TAX INCREMENT 1.1 FUND —
STATEMENT OF REVENUES, EXPENDITURES, AND
CHANGES IN FUND BALANCE- BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31, 2001
2002
Variance-- —
favorable 2001
Budget Actual (unfavorable) Actual
Revenues: —
Taxes:
Tax increment $ 1,009,000 $ 970,795 $ (38,205) $ 1,337,408
Intergovernmenal —
Market value aid credit - 16,786
Investment earnings 20,000 16,163 (3,837) 22,334 _
Charges for services - 14,853 14,853 15,325
Total Revenues 1,029,000 1,018,597 (42,042) 1,375,067
Expenditures:
Materials, supplies and services - - - 6,268
Capital outlay: _
Land acquisition - - - 871,896
Total Expenditures - - - 878,164
Excess(deficiency)of revenues over expenditures 1,029,000 1,018,597 (10,403) 496,903
Other Financing Uses: _
Operating transfer to Bonds of 1992 - Refunding (345,000) (345,000) - (355,000)
Operating transfer to Bonds of 1993A- Refunding (135,000) (135,000) - (150,000)
Operating transfer to Bonds of 1993C - Refunding (855,000) (855,000) - (895,000) —
Total Other Financing Uses (1,335,000) (1,335,000) - (1,400,000)
Deficiency of revenues under expenditures and other
financing uses (306,000) (316,403) (10,403) (903,097)
Fund Balance- January 1 1,298,940 1,298,940 - 2,202,037
Fund Balance- December 31 $ 992,940 $ 982,537 $ (10,403) $ 1,298,940
76 —
CITY OF HOPKINS, MINNESOTA C-13
TAX INCREMENT 1.2 FUND- ENTERTAINMENT CENTER
STATEMENT OF REVENUES, EXPENDITURES, AND
CHANGES IN FUND BALANCE- BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31, 2001
2002
Variance—
favorable 2001
Budget Actual (unfavorable) Actual
Revenues:
Taxes:
Tax increment $ 46,639 $ 44,186 $ (2,453) $ 60,866
Investment earnings 1,500 749 (751) 598
Total Revenues 48,139 44,935 (3,204) 61,464
_ Expenditures:
Materials, supplies and services 4,500 4,384 116 2,415
Capital outlay:
_ Construction - - - 200,000
Public improvements 78,218 63,539 14,679 -
Total Expenditures 82,718 67,923 14,795 202,415
Excess (deficiency)of revenues over(under)
expenditures (34,579) (22,988) 11,591 (140,951)
Fund Balance- January 1 210,877 210,877 - 351,828
Fund Balance-December 31 $ 176,298 $ 187,889 $ 11,591 $ 210,877
77
CITY OF HOPKINS,MINNESOTA C-14
TAX INCREMENT 2.1 FUND
STATEMENT OF REVENUES, EXPENDITURES, AND
CHANGES IN FUND BALANCE- BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31,2001
2002
Variance--
favorable 2001
Budget Actual (unfavorable) Actual
Revenues: —
Taxes:
Tax increment $ 413,000 $ 342,549 $ (70,451) $ 523,385 _
Investment earnings 15,000 9,631 (5,369) 16,140
Total Revenues 428,000 352,180 (75,820) 539,525
Expenditures: —
Materials, supplies and services 6,000 6,123 (123) 58,303
Capital outlay:
Site improvements- R.L. Johnson 195,000 165,564 29,436 255,680
Total Expenditures 201,000 171,687 29,313 313,983
Excess of revenues over expenditures 227,000 180,493 (46,507) 225,542
Other Financing Uses —
Operating transfer to debt service, 1997 - HRA (220,000) (220,000) - (225,000)
Excess(deficiency)of revenues over(under) —
expenditures and other financing uses 7,000 (39,507) (46,507) 542
Fund Balance - January 1 264,659 264,659 - 264,117 —
Fund Balance - December 31 $ 271,659 $ 225,152 $ (46,507) $ 264,659
78 —
CITY OF HOPKINS, MINNESOTA C-15
TAX INCREMENT 2.6 FUND
STATEMENT OF REVENUES, EXPENDITURES, AND
CHANGES IN FUND BALANCE-BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31, 2001
2002
Variance—
favorable 2001
Budget Actual (unfavorable) Actual
Revenues:
Taxes:
Tax increment $ 8,000 $ 8,571 $ 571 $ 7,824
Investment earnings - 148 148 -
Other 11,024 10,423 (601) 11,200
19,024 19,142 118 19,024
Expenditures:
Materials, supplies and services 800 530 270 286
Excess of revenues over expenditures 18,224 18,612 388 18,738
Fund Balance(Deficit)- January 1 (456,938) (456,938) - (475,676)
Fund Balance(Deficit)-December 31 $ (438,714) $ (438,326) $ 388 $ (456,938)
79
CITY OF HOPKINS,MINNESOTA C-16
TAX INCREMENT 2.7 FUND
STATEMENT OF REVENUES, EXPENDITURES, AND
CHANGES IN FUND BALANCE- BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31,2001
2002
Variance—
favorable 2001
Budget Actual (unfavorable) Actual
Revenues: —
Taxes:
Tax increment $ 74,678 $ 66,461 $ (8,217) $ 99,571 _
Investment earnings 2,500 4,446 1,946 1,585
Total Revenues 77,178 70,907 (6,271) 101,156
Expenditures:
Materials, supplies and services 9,500 9,061 439 6,396
Capital outlay: —
Construction - - - 165,558
Site improvements - - - 41,002
Total Expenditures 9,500 9,061 439 212,956 —
Excess (deficiency)of revenues over(under)
expenditures 67,678 61,846 (6,710) (111,800) —
Other Financing Uses:
Operating transfer to PIR Fund (97,222) (97,222) - - —
Deficiency of revenues (under) expenditures and
other financing uses (29,544) (35,376) (5,832) (111,800) —
Fund Balance- January 1 100,195 100,195 - 211,995
Fund Balance-December 31 $ 70,651 $ 64,819 $ (5,832) $ 100,195
80 —
CITY OF HOPKINS, MINNESOTA C-17
TAX INCREMENT 2.8 FUND
STATEMENT OF REVENUES, EXPENDITURES, AND
CHANGES IN FUND BALANCE- BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31, 2001
2002
Variance—
favorable 2001
Budget Actual (unfavorable) Actual
Revenues:
Taxes:
Tax increment $ 35,000 $ 38,338 $ 3,338 $ 46,362
_ Investment earnings 2,000 812 (1,188) 2,506
Total Revenues 37,000 39,150 2,150 48,868
_ Expenditures:
Materials, supplies and services 9,900 9,982 (82) 814
Capital outlay:
_ Site improvements 29,532 28,298 1,234 68,306
Total Expenditures 39,432 38,280 1,152 69,120
Excess(deficiency)of revenues over(under)
expenditures (2,432) 870 3,302 (20,252)
Fund Balance-January 1 13,338 13,338 - 33,590
Fund Balance-December 31 $ 10,906 $ 14,208 $ 3,302 $ 13,338
81
CITY OF HOPKINS, MINNESOTA C-18
TAX INCREMENT 2.9 FUND —
STATEMENT OF REVENUES, EXPENDITURES, AND
CHANGES IN FUND BALANCE- BUDGET AND ACTUAL
Year Ended December 31, 2002
With Comparative Actual Amounts for Year Ended December 31, 2001
2002
Variance
favorable 2001
Budget Actual (unfavorable) Actual
Revenues:
Taxes
Tax increment $ 92,500 $ 100,307 $ 7,807 $ 130,297 _
Intergovernmenal
Market value aid credit - 14,494 14,494 -
Investment earnings 3,500 6,328 2,828 7,341 _
Total Revenues 96,000 121,129 25,129 137,638
Expenditures _
Materials, supplies and services 2,399 2,342 57 2,290
Excess of revenues over expenditures 93,601 118,787 25,186 135,348 _
Other Financing Uses:
Operating transfer out for debt service (131,000) (131,000) - (48,000) _
Excess(deficiency)of revenues over(under) —
expenditures and other financing uses (37,399) (12,213) 25,186 87,348
Fund Balance-January 1 194,191 194,191 - 106,843
Fund Balance-December 31 $ 156,792 $ 181,978 $ 25,186 $ 194,191
82
CITY OF HOPKINS,MINNESOTA C-19
TAX INCREMENT 2.10 FUND
STATEMENT OF REVENUES,EXPENDITURES,AND
CHANGES IN FUND BALANCE-BUDGET AND ACTUAL
Year Ended December 31,2002
With Comparative Actual Amounts for Year Ended December 31,2001
2002
Variance
favorable 2001
Budget Actual (unfavorable) Actual
Revenues:
Taxes:
Tax increment $ 60,810 $ 59,112 $ (19698) $ 17,344
Investment earnings 200 410 210 114
Total Revenues 61,010 59,522 (1,488) 17,458
Expenditures:
Materials, supplies and services 4,000 3,567 433 3,153
Capital outlay:
Site improvements 51,362 48,110 3,252 6,938
-, Total Expenditures 55,362 51,677 3,685 10,091
_ Excess of revenues over expenditures 5,648 7,845 2,197 7,367
Fund Balance - January 1 7,367 7,367 - -
Fund Balance- December 31 $ 13,015 $ 15,212 $ 2,197 $ 7,367
83
C-20
CITY OF HOPKINS, MINNESOTA
TAX INCREMENT 2.11 FUND
STATEMENT OF REVENUES, EXPENDITURES, AND
CHANGES IN FUND BALANCE- BUDGET AND ACTUAL
Year Ended December 31,2002
With Comparative Actual Amounts for Year Ended December 31, 2001 -
2002 -
Variance--
favorable 2001
Budget Actual (unfavorable) Actual
Revenues:
Taxes:
Tax Increments $ 500,000 $ 373,424 $ (126,576) $ 507,175
Investment earnings 5,000 22,980 17,980 9,051
Charges for services - - - 100 _
505,000 396,404 (108,596) 516,326
Expenditures: _
Materials, supplies and services 48,250 16,906 31,344 2,992
Debt service issuance cost - 40,192 (40,192) -
Capital outlay: -
Land - 20,280 (20,280) -
Streets and Sidewalks 3,000,000 144,367 2,855,633 279,186
Site Improvements 400,000 - 400,000 - -
Total Expenditures 3,448,250 221,745 3,226,505 282,178
Excess(deficiency)of revenues over(under) -
expenditures (2,943,250) 174,659 3,117,909 234,148
Other Financing Sources(Uses): -
Bond proceeds 3,000,000 2,450,000 (550,000) -
Operating transfer out for debt service - (10,635) (10,635) -
Total Other Financing Sources(Uses) 3,000,000 2,439,365 (560,635) -
Excess of revenues and other financing sources over
expenditures and other financing(uses) 56,750 2,614,024 2,557,274 234,148 -
Fund Balance-January 1 267,356 267,356 - 33,208
Fund Balance-December 31 $ 324,106 $ 2,881,380 $ 2,557,274 $ 267,356
84 -
CITY OF HOPKINS, MINNESOTA
COMPREHENSIVE ANNUAL FINANCIAL REPORT
DEBT SERVICE FUNDS
_ Debt Service Funds are established to finance and account for the payment of
interest and principal on all general obligation debt other than debt issued for and
serviced by a governmental enterprise. Provisions are made in the City's general
property tax levy for money sufficient to meet the general obligation debt.
85
CITY OF HOPKINS,MINNESOTA
DEBT SERVICE FUNDS _
COMBINING BALANCE SHEET
December 31,2002
With Comparative Totals for December 31,2001 -
Taxable _
Redevelopment Redevelopment Redevelopment Taxable D Tax Increment
Refunding Refunding C Refunding A Housing Redevelopment Redevelopment Redevelopment
Bonds of Bonds of Bonds of Bonds of Bonds of Bonds of Bonds of
1992 1993 1993 1995 1996 1996 1997
ASSETS
Cash and investments $ 188,664 $ 677,382 $ 140,492 $ 135,920 $ 91,552 $ 26,687 $ 208,133
Taxes receivable
Special assessments receivable - 891,396
Accrued interest receivable 1,175 4,219 875 842 571 167 1,296
Due from other funds -
Restricted cash and investments -
Total Assets $ 189,839 $ 681,601 $ 141,367 $ 1,028,158 $ 92,123 $ 26,854 $ 209,429
LIABILITIES AND FUND BALANCE
Liabilities:
Due to other funds $ $ $ $ - $ $ $
Deferred revenue 890,787
Total Liabilities 890,787 _
Fund Balance:
Reserved for debt service 189,839 681,601 141,367 137,371 92,123 26,854 209,429
Total Liabilities and Fund Balance $ 189,839 $ 681,601 $ 141,367 $ 1,028,158 $ 92,123 $ 26,854 $ 209,429
86
D
Improvement Park and
Taxable A Taxable B Revolving Recreational
Housing Housing Improvement Bonds of 1992, Refunding D HRA Lease Tax
Housing Improvement Improvement Revolving Refunding Bonds of 1993, Revenue Increment
Bonds of Bonds of Bonds of Bonds of Bonds Refunding bonds Bonds of Bonds of Totals
1997 1999 1999 1999 2001 2001 2002 2002B 2002 2001
$ 158,969 $ 145,214 $ 269,602 $ 140,070 $ 207,654 $ 171,949 $ $ 10,620 $ 2,572,908 $ 4,660,378
- - - 620 982 2,765 4,367 13,322
2,627,964 2,445,808 4,357,808 10,322,976 10,998,862
999 908 1,670 872 1,289 1,071 67 16,021 50,634
- 1,465
_ _ _ _ 129,120 129,120
$ 2,787,932 $ 2,591,930 $ 4,629,080 $ 141,562 $ 209,925 $ 175,785 $ 129,120 $ 10,687 $ 13,045,392 $ 15,724,661
$ $ $ - $ $ $ $ $ $ $ 1,465
2,625,735 2,443,010 4,354,139 472 827 2,331 10,317,301 10,995,883
2,625,735 2,443,010 4,354,139 472 827 2,331 10,317,301 10,997,348
162,197 148,920 274,941 141,090 209,098 173,454 129,120 10,687 2,728,091 4,727,313
$ 2,787,932 $ 2,591,930 $ 4,629,080 $ 141,562 $ 209,925 $ 175,785 $ 129,120 $ 10,687 $ 13,045,392 $ 15,724,661
87
CITY OF HOPKINS,MINNESOTA
DEBT SERVICE FUNDS _
COMBINING STATEMENT OF REVENUES,EXPENDITURES,AND
CHANGES IN FUND BALANCE
Year Ended December 31,2002 -
With Comparative Totals for Year Ended December 31,2001
Taxable
Redevelopment Redevelopment Redevelopment Taxable D Tax Increment
Refunding Refunding C Refunding A Housing Redevelopment Redevelopment Redevelopment
Bonds of Bonds of Bonds of Bonds of Bonds of Bonds of Bonds of _
1992 1993 1993 1995 1996 1996 1997
Revenues:
Taxes:
General property taxes $ - $
Fiscal disparities
Special assesments - 98,203 -Investment earnings (470) (6,364) 3,630 2,145 937 324 930
Total Revenues (470) (6,364) 3,630 100,348 937 324 930
Expenditures: _
Principal payments 161,502 890,000 150,000 40,000 125,000
Interest on bonds 188,498 111,320 8,918 51,473 50,823 28,500 87,333
Fiscal agent charges 450 398 300 300 300 300 300
Total Expenditures 350,450 1,001,718 159,218 91,773 51,123 28,800 212,633
Excess(deficiency)of revenues
over expenditures (350,920) (1,008,082) (155,588) 8,575 (50,186) (28,476) (211,703)
Other Financing Sources(Uses):
Proceeds from bond issuance -
Bond issuance expense - -
Operating transfer from Capital - - - -
Operating transfer from P.I.R. - -
Operating transfer from TIF 1.1 345,000 855,000 135,000
Operating transfer from TIF 2.1 - - - - - 220,000
Operating transfer from TIF 2.9 - - - 102,000 29,000 -
Operating transfer from TIF 2.11 - -
Total Other Financing Sources 345,000 855,000 135,000 102,000 29,000 220,000
Excess(deficiency)of revenues
and other financing sources
(uses)over expenditures (5,920) (153,082) (20,588) 8,575 51,814 524 8,297
Fund Balance-January 1 195,759 834,683 161,955 128,796 40,309 26,330 201,132
Fund Balance-December 31 $ 189,839 $ 681,601 $ 141,367 $ 137,371 $ 92,123 $ 26,854 $ 209,429 _
88 _
D-1
Improvement Park and
Revolving Recreational
Taxable A Taxable B Bonds of Refunding D
Housing Housing Improvement 1992, Bonds of Improvement Tax
Housing Improvement Improvement Revolving Refunding 1993,Refunding Revolving Increment
Bonds of Bonds A of Bonds B of Bonds of Bonds Bonds Bonds of Bonds of Totals
1997 1999 1999 1999 2001 2001 2002A 2002B 2002 2001
51,143 $ 54,041 $ 178,706 $ $ $ 283,890 $ 298,952
6,948 7,284 24,094 38,326 47,430
176,630 146,350 258,320 - - 679,503 670,660
1,301 1,639 3,197 1,031 (8,506) (14,231) - 52 (14,385) 73,248
177,931 147,989 261,517 59,122 52,819 188,569 52 987,334 1,090,290
_ 50,000 40,000 65,000 70,000 945,000 1,455,000 - - 3,991,502 995,847
116,514 96,075 176,799 33,687 42,046 61,892 - - 1,053,878 1,110,907
733 607 633 225 182 203 - 4,931 5,227
167,247 136,682 242,432 103,912 987,228 1,517,095 5,050,311 2,111,981
10,684 11,307 19,085 (44,790) (934,409) (1,328,526) - 52 (4,062,977) (1,021,691)
2,125,000
r (25,156)
_ 129,120 129,120 -
78,000 160,000 238,000 157,000
1,335,000 1,400,000
220,000 225,000
131,000 48,000
10,635 10,635
78,000 160,000 - 129,120 10,635 2,063,755 3,929,844
10,684 11,307 19,085 33,210 (774,409) (1,328,526) 129,120 10,687 (1,999,222) 2,908,153
_. 151,513 137,613 255,856 107,880 983,507 1,501,980 4,727,313 1,819,160
$ 162,197 $ 148,920 $ 274,941 $ 141,090 $ 209,098 $ 173,454 $ 129,120 $ 10,687 $ 2,728,091 $ 4,727,313
89
CITY OF HOPKINS, MINNESOTA -
COMPREHENSIVE ANNUAL FINANCIAL REPORT _
CAPITAL PROJECTS FUNDS
Capital Projects Funds are established to account for the resources expended to
acquire assets of a relatively permanent nature. (Special revenue and enterprise
fund resources are not included in this category.) These funds evolve from the
needs for special accounting for bond proceeds, grants and contributions for the
acquisition of capital assets.
Park Improvements Fund - This fund was established to record construction and
improvement costs for park facilities.
Capital Improvement Fund - This fund was established to record construction and
improvement costs for city facilities and infrastructure.
Municipal State Aid For Highway Construction Fund - This fund is used to account
for the City's allocation of the state collected highway user tax. The allocation is _
based on population and need for construction of designated state aid streets in the
City.
Permanent Improvement Revolving Fund - The Permanent Improvement Revolving _
Fund is employed to finance and account for the construction and financing of
certain public improvements such as residential streets, sidewalks, or storm sewers _
or the provision of services which are to be paid for wholly or in part from special
assessments levied against benefitted property. The fact that special assessment
improvements are paid for completely or in part by property owners in a limited —
geographical area deemed to be specially benefitted distinguishes them from
improvements which benefit the entire community and which are paid for out of
general revenues or through the issuance of general obligation bonds. —
The PIR Fund also accounts for the collection of special assessments and other
revenues pledged for the payment of principal and interest on outstanding special —
assessment bonds.
90
CITY OF HOPKINS,MINNESOTA E
CAPITAL PROJECTS FUNDS
COMBINING BALANCE SHEET
December 31,2002
With Comparative Totals for December 31,2001
_ Municipal Permanent
Park State Aid Capital Improvement Totals
Improvements Construction Improvements Revolving 2002 2001
ASSETS
Cash and investments $ 199,108 $ 2,271,031 $ (163,286) $ 1,398,916 $ 3,705,769 $ 2,833,348
Special assessments receivable - - 2,335,503 2,335,503 2,143,685
Accounts receivable - 6,742 - 37,918 44,660 93,447
Accrued interest receivable 1,014 13,915 (964) 8,427 22,392 29,791
Due from other funds - - - 53,660 53,660 383,443
Due from other governments - 325,002 108,517 433,519 265,903
Restricted cash and investments - - 10,557,451 - 10,557,451
Total Assets $ 200,122 $ 2,616,690 $ 10,393,201 $ 3,942,941 $ 17,152,954 $ 5,749,617
LIABILITIES AND FUND BALANCE
Liabilities:
Accounts payable $ 1,000 $ 1,577 $ 88,578 $ 47,312 $ 138,467 $ 27,860
Retainage payable - 34,628 26,488 61,116 97,646
Due to other funds - 15,000 - 393,400 408,400 8,843
Deferred revenue - - - 2,331,394 2,331,394 2,130,420
Total Liabilities 1,000 51,205 88,578 2,798,594 2,939,377 2,264,769
Fund Balance:
Reserved for Phase I facility project - - 10,107,076 - 10,107,076 -
Unreserved:
-' Designated for street improvements - 2,565,485 - 1,144,347 3,709,832 3,257,006
Undesignated 199,122 - 197,547 - 396,669 227,842
Total Fund Balance 199,122 2,565,485 10,304,623 1,144,347 14,213,577 3,484,848
Total Liabilities and
Fund Balance $ 200,122 $ 2,616,690 $ 10,393,201 $ 3,942,941 $ 17,152,954 $ 5,749,617
91
CITY OF HOPKINS,MINNESOTA E-1
CAPITAL PROJECTS FUNDS
COMBINING STATEMENT OF REVENUES,EXPENDITURES,AND _
CHANGES IN FUND BALANCE
Year Ended December 31,2002 _
With Comparative Totals for Year Ended December 31,2001
Municipal Permanent
Park State Aid Capital Improvement Totals
Improvements Construction Improvements Revolving 2002 2001
Revenues:
Special assessments $ - $ - $ - $ 666,664 $ 666,664 $ 566,932
Intergovernmental:
State of Minnesota - 531,405 - 531,405 631,443
Charges for services 38,486 - 18,000 - 56,486 63,728 --
Investment earnings 4,735 157,501 150,092 8,907 321,235 166,253
Donations 11,400 - - - 11,400 -
Total Revenues 54,621 688,906 168,092 675,571 1,587,190 1,428,356 _
Expenditures:
Bond issue expense - 222,314 24,496 246,810 _
Capital Outlay
Projects - - - - 128,551
Buildings and improvements 368,540 368,540
Park improvements 23,022 - - - 23,022 -
Street improvements - 735,667 - 963,646 1,699,313 1,696,545
Environmental - - 575 575 45,910
Alley reconstruction - - - 33,441 33,441 1,003
Total Expenditures 23,022 735,667 590,854 1,022,158 2,371,701 1,872,009
Excess(deficency)of revenues
over expenditures 31,599 (46,761) (422,762) (346,587) (784,511) (443,653)
Other Financing Sources(Uses) -
Bond Proceeds - - 10,760,000 960,000 11,720,000 -
Operating transfer from General 36,186 - - - 36,186 -
Operating transfer from Utility - - 26,952 26,952 62,774 _
Operating transfer from Tax Incr. 97,222 97,222 -
Operating transfer to Debt - - (129,120) (238,000) (367,120) (157,000)
Total Other Financing T
Sources(Uses) 36,186 - 10,630,880 846,174 11,513,240 (94,226)
Excess(deficency)of revenues
and other financing sources
over expenditures and other
financing uses 67,785 (46,761) 10,208,118 499,587 10,728,729 (537,879)
Fund Balance-January 1 131,337 2,612,246 96,505 644,760 3,484,848 3,922,727
Residual equity transfer in - - - - - 100,000 -
Fund Balance-December 31 $ 199,122 $ 2,565,485 $ 10,304,623 $ 1,144,347 $ 14,213,577 $ 3,484,848
92
CITY OF HOPKINS, MINNESOTA
COMPREHENSIVE ANNUAL FINANCIAL REPORT
ENTERPRISE FUNDS
Enterprise Funds are established to account for the financing of self-supporting
activities of governmental units which render services to the general public on a
user charge basis. Records are maintained on the accrual basis of accounting.
The Authority for these types of funds is derived from Section 11.01 of the City
Charter which allows for utility or other public service enterprise funds.
The City has seven Enterprise Funds:
Water Utility Fund
Sewer Utility Fund
Refuse Utility Fund
Storm Sewer Utility Fund
Pavilion/Ice Arena Fund
_ Skate Park Fund
Housing Authority Fund
93
CITY OF HOPKINS,MINNESOTA
ENTERPRISE FUNDS
COMBINING BALANCE SHEET
December 31,2002
With Comparative Totals for December 31,2001
Water Sewer Refuse ._
Utility Utility Utility
ASSETS
Current assets:
Cash and cash equivalents $ 759,430 $ 882,815 $ 626,753
Accounts receivable 147,431 58,094 31,311
Accrued interest receivable 7,025 6,110 3,912
Due from other governments
Due from other funds 300,000 400,000 -
Inventory 15,088 9,190 605
Prepaid expenses - -
Total current assets 1,228,974 1,356,209 662,581 -
Property and equipment
Land and land improvements 16,447 5,150
Buildings and structures 44,486 - 302,727
Distribution system 7,556,364 5,509,606 2,584
Water meters 555,665 - -
Machinery and equipment 310,192 307,236 432,675 -
Construction in progress - -
Total property and equipment 8,483,154 5,821,992 737,986
Less accumulated depreciation 3,656,766 2,669,734 320,090
Net property and equipment 4,826,388 3,152,258 417,896
Other Assets:
Restricted cash and cash equivalents-debt service 152,096 - -
Total Assets $ 6,207,458 $ 4,508,467 $ 1,080,477
LIABILITIES AND FUND EQUITY
Current Liabilities:
Accounts payable $ 54,981 $ 26,689 $ 32,259
Compensated absences payable 36,136 38,992 19,186
Due to other funds 3,125 5,500
Due to other governments 2,889 126,250 12,740
Deferred revenue - - -
Accrued interest payable 45,234 - -
Bonds payable 105,000 - -
Total Current Liabilities 247,365 197,431 64,185
Long-term Liabilities:
Advance from other funds(net of current portion) - - -
Bonds payable(net of current portion) 1,740,000 - -
Total Long-term Liabilities 1,740,000 - -
Total Liabilities 1,987,365 197,431 64,185
Fund Equity:
Contributed capital -governmental grant - 472,684 -
Contributed capital - - -
Retained Earnings:
Reserved for debt service 152,096 - -
Unreserved 4,067,997 3,838,352 1,016,292
Total Retained Earnings 4,220,093 3,838,352 1,016,292
Total Fund Equity 4,220,093 4,311,036 1,016,292
Total Liabilities and Fund Equity $ 6,207,458 $ 4,508,467 $ 1,080,477 _
94
F
Storm Sewer Pavilion/ Housing Totals
Utility Ice Arena Art Center Skate Park Authority 2002 2001
$ 5,218 $ 68,184 $ - $ 626 $ 125,156 $ 2,468,182 $ 3,316,490
52,378 33,083 - - 2,305 324,602 417,414
(677) 425 - (53) - 16,742 56,643
_ _ - 11,162
393,400 - - - - 1,093,400 -
'- - 24,883 24,363
7,846 7,846 7,088
450,319 101,692 - 573 135,307 3,935,655 3,833,160
26,800 - - - - 48,397 348,397
2,379,434 - 30,381 - 2,757,028 6,569,508
7,583,343 52,726 - - - 20,704,623 20,484,036
_ - 555,665 451,789
12,876 127,847 - - - 1,190,826 1,144,179
388,889 - - 388,889 83,873
8,011,908 2,560,007 - 30,381 - 25,645,428 29,081,782
1,441,734 645,980 - 9,114 - 8,743,418 8,378,033
6,570,174 1,914,027 - 21,267 - 16,902,010 20,703,749
250,000 - - - - 402,096 1,913,960
$ 7,270,493 $ 2,015,719 $ - $ 21,840 $ 135,307 $ 21,239,761 $ 26,450,869
- $ 27,443 $ 60,087 $ - $ 337 $ 28,061 $ 229,857 $ 170,029
5,514 12,997 - - 7,227 120,052 143,780
745,035 - - 11,000 33,291 797,951 436,130
308 - - - 142,187 37,704
660 - - - 660 206,763
67,797 - - - - 113,031 113,031
250,000 - - - - 355,000 1,940,000
1,095,789 74,052 - 11,337 68,579 1,758,738 3,047,437
834,783
2,705,000 - - - - 4,445,000 4,800,000
2,705,000 - - - - 4,445,000 5,634,783
3,800,789 74,052 - 11,337 68,579 6,203,738 8,682,220
_ _ _ _ - 472,684 972,684
2,085,025 - - - 2,085,025 5,405,643
250,000 - - - - 402,096 1,913,960
3,219,704 (143,358) - 10,503 66,728 12,076,218 9,476,362
3,469,704 (143,358) - 10,503 66,728 12,478,314 11,390,322
3,469,704 1,941,667 - 10,503 66,728 15,036,023 17,768,649
$ 7,270,493 $ 2,015,719 $ - $ 21,840 $ 135,307 $ 21,239,761 $ 26,450,869
95
CITY OF HOPKINS,MINNESOTA _
ENTERPRISE FUNDS
COMBINING STATEMENT OF REVENUES,
EXPENSES,AND CHANGES IN RETAINED EARNINGS
Year Ended December 31,2002
With Comparative Totals for Year Ended December 31,2001
Water Sewer Refuse
Utility Utility Utility
Operating revenues:
Charges for services $ 806,278 $ 1,298,101 $ 614,643
Admissions and fees
Rental
Leases 18,753 - -
Other 30,652 36,491 -
Total Operating Revenues 855,683 1,334,592 614,643
Operating expenses(excluding depreciation)
Salaries and employee benefits 312,759 173,420 238,502
Materials,supplies and services 400,422 256,844 300,435
Disposal costs - 845,502 96,111
Total Operating Expenses(excluding depreciation) 713,181 1,275,766 635,048
Operating income(loss)before depreciation expense 142,502 58,826 (20,405)
Depreciation expense 274,744 146,070 31,619 _
Operating income(loss) (132,242) (87,244) (52,024)
Nonoperating revenue(expense)
Interest income 38,860 35,007 20,945
Interest/fiscal agent expense (96,668) - -
Intergovernmental grants - - 28,898 _
Bond issuance expense - -
Other 47 - -
Total nonoperating revenues(expenses) (57,761) 35,007 49,843 _
Income(loss)before operating transfers (190,003) (52,237) (2,181)
Other revenues(expenses)
Operating transfer from Sanitary Sewer 166,108 - -
Operating transfer from Economic Development fund
Operating transfer to Water - (166,108) -
Operating transfer to PIR fund - -
Total other revenues(expenses) 166,108 (166,108) -
Net income(loss) (23,895) (218,345) (2,181)
Fund Equity
Retained Earnings-January 1 4,243,988 4,056,697 1,018,473
Residual equity transfer - -
Retained Earnings-December 31 $ 4,220,093 $ 3,838,352 $ 1,016,292 --
96
F-1
Storm Sewer Pavilion/ Art Skate Housing Totals
Utility Ice Arena Center Park Authority 2002 2001
$ 684,081 $ - $ - $ - $ 203,361 $ 3,606,464 $ 3,701,961
17,314 - 17,314 124,070
- 253,981 - - - 253,981 302,983
18,753 165,202
24,771 22,116 - - 26,924 140,954 68,037
708,852 276,097 - 17,314 230,285 4,037,466 4,362,253
23,264 167,752 - 29,335 73,572 1,018,604 1,241,199
82,259 88,967 - 9,657 223,953 1,362,537 1,456,897
941,613 923,092
105,523 256,719 - 38,992 297,525 3,322,754 3,621,188
603,329 19,378 - (21,678) (67,240) 714,712 741,065
171,751 58,075 - 3,038 - 685,297 768,236
431,578 (38,697) - (24,716) (67,240) 29,415 (27,171)
(19,334) 3,183 - (94) (252) 78,315 206,161
(141,379) - - - - (238,047) (380,560)
146,247 175,145 61,219
(12,248)
_ - 47 53,237
(160,713) 3,183 - (94) 145,995 15,460 (72,191)
270,865 (35,514) - (24,810) 78,755 44,875 (99,362)
166,108 -
_ 61,000
(166,108)
(26,952) - - - - (26,952) (62,774)
(26,952) - - - - (26,952) (1,774)
243,913 (35,514) - (24,810) 78,755 17,923 (101,136)
3,225,791 (107,844) (1,070,069) 35,313 (12,027) 11,390,322 11,491,458
1,070,069 - - 1,070,069 -
$ 3,469,704 $ (143,358) $ - $ 10,503 $ 66,728 $ 12,478,314 $ 11,390,322
97
CITY OF HOPKINS,MINNESOTA
ENTERPRISE FUNDS
COMBINING STATEMENT OF CASH FLOWS
Year Ended December 31,2002
With Comparative Totals for Year Ended December 31,2001
Water Sewer Refuse
Utility Utility Utility
Cash Flows from Operating Activities:
Operating income(loss) $ (132,242) $ (87,244) $ (52,024)
Adjustments to reconcile operating income(loss)to net cash
provided by operating activities:
Depreciation expense 274,744 146,070 31,619
(Increase)decrease in:
Accounts and accrued interest receivable 27,407 50,835 20,613 _
Due from other funds (300,000) (400,000) -
Due from other governments - - -
Inventory (783) 318 (55)
Prepaid expense - - -
Due from Metropolitan Waste Control Commission - - -
Accounts,compensated absences and accrued interest payable 9,428 8,302 (2,374)
Due to other funds (72,326) 5,060 -
Due to other governments (127) 95,900 8,685
Deferred revenue - - -
Cash Provided by(used)Operating Activities (193,899) (180,759) 6,464
Cash Flows from Noncapital Financing Activities:
Intergovernmental grants - - 28,898
Other contributions - - -
Operating transfer in 166,108 - -
Operating transfer out - (166,108) -
Cash Provided by (used)Noncapital Financing Activities 166,108 (166,108) 28,898
Cash Flows from Capital and Related Financing Activities:
Purchases of property and equipment (207,918) (101,408) (8,070)
Sale of property and equipment 47 3,423 -
Proceeds from issuance of bonds - - -
Interest and other payments (96,668) - -
Bond payments (100,000) - -
Cash Provided by(used)in Capital and Related Financing Activities (404,539) (97,985) (8,070)
Cash Provided by Investing Activities-interest received 38,860 35,007 20,945
Increase(decrease) in Cash and Cash Equivalents (393,470) (409,845) 48,237
Cash and Cash Equivalents-January 1 1,304,996 1,292,660 578,516
Cash and Cash Equivalents-December 31 $ 911,526 $ 882,815 $ 626,753
Cash and Cash Equivalents Components: --
Cash and Cash Equivalents 759,430 882,815 626,753
Restricted Cash and Cash Equivalents 152,096 - -
Total Cash and Cash Equivalents 911,526 882,815 626,753
98
F-2
Storm Sewer Pavilion/ Art Skate Housing Totals
Utility Ice Arena Center Park Authority 2002 2001
$ 431,578 $ (38,697) $ - $ (24,716) $ (67,240) $ 29,415 $ (27,171)
171,751 58,075 - 3,038 - 685,297 768,236
28,044 1,829 5,066 578 (1,659) 132,713 (28,683)
(393,400) - - - - (1,093,400) -
-' - 11,162 - - - 11,162 (5,664)
- (520) 330
- - (758) (758) (793)
17,939 49,499 (40,567) (683) (5,444) 36,100 (105,308)
437,356 - (844,784) 11,000 (9,269) (472,963) 4,647
44 - (19) - 104,483 13,447
(491) (205,612) - - (206,103) 55,289
693,268 81,421 (1,085,897) (10,802) (84,370) (774,574) 674,330
- - - 146,247 175,145 61,219
8,074 - - 8,074 53,237
166,108 61,000
(26,952) - 1,070,069 - - 877,009 (62,774)
(26,952) - 1,078,143 - 146,247 1,226,336 112,682
(329,204) (69,072) - - - (715,672) (1,045,954)
3,470 -
1,610,000
(141,379) - - - - (238,047) (392,808)
(1,840,000) - - - - (1,940,000) (345,000)
(2,310,583) (69,072) - - - (2,890,249) (173,762)
(19,334) 3,183 - (94) (252) 78,315 206,161
(1,663,601) 15,532 (7,754) (10,896) 61,625 (2,360,172) 819,411
1,918,819 52,652 7,754 11,522 63,531 5,230,450 4,411,039
$ 255,218 $ 68,184 $ - $ 626 $ 125,156 $ 2,870,278 $ 5,230,450
5,218 68,184 626 125,156 2,468,182 3,316,490
250,000 - - - - 402,096 1,913,960
255,218 68,184 626 125,156 3 2,870,278 5,230,450
CITY OF HOPKI NS, MINNESOTA -
COMPREHENSIVE ANNUAL FINANCIAL REPORT _
INTERNAL SERVICE FUND
Internal Service Funds are used to account for the financing of goods or services
provided by one department to other departments of the government, on a cost
reimbursement basis. Revenues and expenses are recognized on the accrual basis. _
Revenues are recognized in the accounting period in which they are earned and
become objectively measurable; expenses are recognized in the period incurred, if
objectively measurable.
Equipment Replacement Fund - This fund accounts for the acquisition of machinery
and equipment. User charges are billed to the various City departments. -'
Insurance Risk Fund - This fund accounts for the dividends and deductibles relating
to property and casualty insurance coverage. Deductibles are paid from past
dividends. Users are charged only if fund has a shortfall.
100 _
CITY OF HOPKINS,MINNESOTA G
INTERNAL SERVICE FUND
BALANCESHEET
December 31,2002
With Comparative Totals for December 31,2001
Equipment Insurance Totals
Replacement Risk 2002 2001
ASSETS
Current assets:
Cash and cash equivalents $ 1,992,453 $ 83,205 $ 2,075,658 $ 1,741,116
Accounts receivable 418 - 418 123
Accrued interest receivable 9,104 519 9,623 13,140
Total current assets 2,001,975 83,724 2,085,699 1,754,379
Property and equipment
Machinery and equipment 4,821,701 - 4,821,701 4,618,321
Total property and equipment 4,821,701 - 4,821,701 4,618,321
Less accumulated depreciation (3,207,839) - (3,207,839) (2,926,088)
Net property and equipment 1,613,862 - 1,613,862 1,692,233
Total Assets $ 3,615,837 $ 83,724 $ 3,699,561 $ 3,446,612
LIABILITIES AND FUND EQUITY
Current Liabilities:
Accounts payable $ - $ 835 $ 835 $ -
Fund Equity:
Contributed capital 2,687,227 - 2,687,227 2,687,227
Retained Earnings:
Unreserved 928,610 82,889 1,011,499 759,385
Total Retained Earnings 928,610 82,889 1,011,499 759,385
Total Fund Equity 3,615,837 82,889 3,698,726 3,446,612
Total Liabilities and Fund Equity $ 3,615,837 $ 83,724 $ 3,699,561 $ 3,446,612
101
G-1
CITY OF HOPKINS,MINNESOTA
INTERNAL SERVICE FUND
STATEMENT OF REVENUES,EXPENSES,AND
CHANGES IN RETAINED EARNINGS
Year Ended December 31,2002
With Comparative Totals for December 31,2001
Equipment Insurance Totals
Replacement Risk 2002 2001
Operating revenues:
Charges for services $ 520,328 $ 50,152 $ 570,480 $ 536,333
Operating expenses(excluding depreciation):
Materials,supplies and services 21,099 12,782 33,881 13,285
Operating income before depreciation 499,229 37,370 536,599 523,048
Depreciation expense 362,568 - 362,568 405,546
Operating income 136,661 37,370 174,031 117,502
Nonoperating revenue:
Investment earnings 57,108 2,130 59,238 67,098
Gain on sale of property and equipment 18,845 - 18,845 32,815
Total nonoperating revenues 75,953 2,130 78,083 99,913
Net Income 212,614 39,500 252,114 217,415
Fund Equity:
Retained earnings-January 1 715,996 43,389 759,385 541,970
Retained earnings-December 31 $ 928,610 $ 82,889 $ 1,011,499 $ 759,385
102
G-2
CITY OF HOPKINS,MINNESOTA
INTERNAL SERVICE FUND
STATEMENT OF CASH FLOWS
Year Ended December 31,2002
With Comparative Totals for Year Ended December 31,2001
_ Equipment Insurance Totals
Replacement Risk 2002 2001
Cash Flows from Operating Activities:
Operating income $ 136,661 $ 37,370 $ 174,031 $ 117,502
Adjustments to reconcile operating income to net cash
provided by operating activities:
Depreciation expense 362,568 - 362,568 405,546
Gain on the sale of property and equipment 18,845 - 18,845 -
(Increase)decrease in:
Accounts and accrued interest receivable 3,741 (519) 3,222 1,209
Accounts payable - 835 835 (99)
Cash Provided by Operating Activities 521,815 37,686 559,501 524,158
Cash Flows from Capital and Related Financing Activities:
Purchases of property and equipment (285,572) - (285,572) (361,145)
Proceeds from sale of property and equipment 1,375 - 1,375 32,815
Cash(used in)Capital and Related Financing Activities (284,197) - (284,197) (328,330)
Cash Provided by Investing Activities- interest received 57,108 2,130 59,238 67,098
Increase in Cash and Cash Equivalents 294,726 39,816 334,542 262,926
Cash and Cash Equivalents-January 1 1,697,727 43,389 1,741,116 1,478,190
Cash and Cash Equivalents-December 31 $ 1,992,453 $ 83,205 $ 2,075,658 $ 1,741,116
103
CITY OF HOPKINS, MINNESOTA
COMPREHENSIVE ANNUAL FINANCIAL REPORT
AGENCY FUNDS
Agency Funds are established to account for custodial activities of assets held by the
City as a custodian of the funds.
Northwest Metro Drug Task Force - This fund accounts for the federal portion of
funds confiscated by the Northwest Metro Drug Task Force.
104
H
CITY OF HOPKINS,MINNESOTA
NORTHWEST METRO DRUG TASK FORCE AGENCY FUND
STATEMENT OF CHANGES IN ASSETS AND LIABILITIES
Year Ended December 31,2002
Balance Balance
January 1, December 31,
NW Metro Drup Task Force 2002 Additions Deductions 2002
-` ASSETS
Cash and cash equivalents $ 179,993 $ 290,579 $ 210,323 $ 260,249
Accrued interest receivable 1,934 21,690 22,045 1,579
Due from other governments 28,753 24,832 28,753 24,832
Total Assets $ 210,680 $ 337,101 $ 261,121 $ 286,660
LIABILITIES
Accounts Payable $ 8,670 $ 165,590 $ 165,100 $ 9,160
Due to NW Metro Drug Task Force 202,010 277,500 202,010 277,500
_ Total Liabilities $ 210,680 $ 443,090 $ 367,110 $ 286,660
105
CITY OF HOPKINS, MINNESOTA -
COMPREHENSIVE ANNUAL FINANCIAL REPORT
ACCOUNT GROUPS
General Fixed Assets - Those fixed assets of a governmental jurisdiction which are —
not accounted for in an Enterprise Fund. To be classified as a fixed asset in this
category, a specific piece of property must possess three attributes: (1) tangible
nature; (2) a life longer than the current fiscal year; and (3) a significant value.
General Long-Term Debt - General obligation bonds and other forms of long-term —
debt supported by general revenues are obligations of a governmental unit as a
whole and not its individual constituent funds. Moreover, the proceeds of such
debt may be spent on facilities which are utilized in the operations of several funds.
For these reasons, the amount of unmatured, long-term debt indebtedness which is
backed by the full faith and credit of the government should be recorded and
accounted for in a separate self-balancing group of accounts titled the "General —
Long-Term Debt Account Group". This debt group will include, in addition to the
conventional general obligation bonds, time warrants and notes which have a _
maturity of more than one year from date of issuance. This account group does not
include general obligation water and sewer bonds, which are reflected in their
respective funds. _
106
— I
CITY OF HOPKINS, MINNESOTA
GENERAL FIXED ASSETS ACCOUNT GROUP
SCHEDULE OF GENERAL FIXED ASSETS
December 31,2002
With Comparative Amounts for December 31, 2001
2002 2001
GENERAL FIXED ASSETS:
Land $ 5,747,102 $ 4,970,938
Buildings 6,157,369 2,592,546
Improvements other than buildings 19,916,846 18,783,113
Vehicles 195,674 195,674
Machinery and equipment 1,651,839 1,380,004
Construction in progress 461,854
Total General Fixed Assets $ 34,130,684 $ 27,922,275
INVESTMENT IN GENERAL FIXED ASSETS:
Investments in assets acquired prior to January 1, 1981 $ 5,391,126 $ 5,391,126
Investments in assets acquired after January 1, 1981:
General Fund 2,498,379 1,816,954
Special Revenue Funds 10,008,701 5,653,111
Capital Projects Funds 7,522,476 6,850,019
Special Assessments 8,248,148 7,808,018
Construction in progress 461,854 403,047
Total Investment in General Fixed Assets $ 34,130,684 $ 27,922,275
107
I-1
CITY OF HOPKINS,MINNESOTA
GENERAL FIXED ASSETS ACCOUNT GROUP
SCHEDULE OF GENERAL FIXED ASSETS BY FUNCTION AND ACTIVITY
December 31,2002
Buildings Improvements Equipment
and Otherthan and
Function and Activity Total Land Structures Buildings Vehicles
Administration $ 1,793,258 $ 1,181,828 $ - $ 547,498 $ 63,932
Finance 4,208 - - - 4,208 -
Government buildings 704,920 - 642,821 - 62,099
Community services 55,304 - - - 55,304
Community development 1,414,503 1,410,799 - - 3,704 -
Activity center 914,419 - 843,914 - 70,505
Police 594,084 - 20,649 11,026 562,409
Fire 95,997 - - - 95,997 -
Public works 19,551,251 422,940 788,748 17,912,146 427,417
Parks 3,061,779 1,088,518 305,253 1,338,044 329,964
Special Revenue 5,302,491 1,572,317 3,555,984 2,216 171,974 -
Park Improvements 105,916 - - 105,916 -
State Aid 70,700 70,700 - - -
Construction in Progress 461,854 - 461,854 - -
Total $ 34,130,684 $ 5,747,102 $ 6,619,223 $ 19,916,846 $ 1,847,513
108 -
I-2
CITY OF HOPKINS,MINNESOTA
GENERAL FIXED ASSETS ACCOUNT GROUP
SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS
BY FUNCTION AND ACTIVITY
Year Ended December 31, 2002
General General
Fixed Assets Fixed Assets
January 1, December 31,
Function and Activity 2002 Additions Deductions 2002
Administration $ 1,782,659 $ 10,599 $ - $ 1,793,258
Finance 4,208 - - 4,208
Government buildings 696,875 8,045 - 704,920
Community services 53,304 2,000 - 55,304
Community development 1,414,503 - - 1,414,503
Activity center 912,562 1,857 - 914,419
Police 432,411 161,673 594,084
Fire 93,004 2,993 - 95,997
Public works 18,525,121 1,026,130 - 19,551,251
Parks 2,974,542 87,237 - 3,061,779
Special Revenue 946,900 4,355,591 5,302,491
Park Improvements 86,186 19,730 - 105,916
State Aid - 70,700 - 70,700
Construction in Progress - 461,854 - 461,854
Total $ 27,922,275 $ 6,208,409 $ - $ 34,130,684
109
J
CITY OF HOPKINS, MINNESOTA
GENERAL LONG-TERM DEBT ACCOUNT GROUP
STATEMENT OF GENERAL LONG-TERM DEBT
December 31,2002
With Comparative Amounts for December 31, 2001
2002 2001
AMOUNT AVAILABLE AND TO BE PROVIDED FOR _
THE PAYMENT OF GENERAL LONG-TERM DEBT:
Amount available in debt service funds $ 2,728,091 $ 4,727,313
Amount to be provided by tax levies,tax increments,annual fees
and annual operating appropriations 25,773,103 13,595,383
Total Available and to be Provided $ 28,501,194 $ 18,322,696
GENERAL LONG-TERM DEBT PAYABLE:
General obligation redevelopment bonds payable $ 15,251,194 $ 15,777,696 —
Special assessment debt with governmental commitment 2,490,000 2,545,000
Public facility lease revenue bonds payable 10,760,000 -
Total General Long-Term Debt Payable $ 28,501,194 $ 18,322,696 —
110 —
NOILAS lVD11SUVIS _
III NOUDIS
AOdIN IVIDNVNIJ lVnNNV ]AlSN3HRldW0D
VIOSINNIW 'SNI)IdOH AO A-LD
(This page intentionally left blank)
112 —
Table I
CITY OF HOPKINS, MINNESOTA
GOVERNMENTAL FUND TYPES - EXPENDITURES BY FUNCTION
Years 1993 Through 2002
(Amounts expressed in thousands)
(Unaudited)
Fiscal General Public Community Public Capital
Year Government Safety Development Works Recreation Other Outlay Total
1993 $ 1,517 $ 2,325 $ 741 $ 1,536 $ 132 $ - $ 2,599 $ 8,850
1994 1,610 2,481 956 1,574 113 - 4,717 11,451
1995 1,794 2,572 1,707 1,559 127 - 2,335 10,094
1996 1,240 2,727 634 1,587 146 - 4,265 10,599
1997 1,255 2,807 1,535 1,518 317 - 11,922 19,354
1998 945 3,311 1,201 1,732 576 - 4,085 11,850
1999 938 3,401 1,176 1,732 716 - 6,931 14,894
2000 1,033 3,196 1,080 1,592 659 1 2,665 10,226
2001 1,043 3,399 1,141 1,693 667 34 4,668 12,645
2002 1,062 3,690 1,158 1,652 1,027 94 4,480 13,163
Note:
Includes General, Special Revenue and Capital Projects Funds.
113
Table II
CITY OF HOPKINS, MINNESOTA
GOVERNMENTAL FUND TYPES -REVENUES BY SOURCE
Years 1993 Through 2002 -
(Amounts expressed in thousands)
(Unaudited)
Charges
Taxes Use of For
and Money Services Licenses
Fiscal Special Intergovern- and and Other and Fines and
Year Assessments mental Property Revenue Permits Forfeitures Total -
1993 $ 5,707 $ 2,481 $ 937 $ 985 $ 226 $ 129 $ 10,465
1994 5,536 2,984 612 992 264 114 10,502
1995 6,383 2,606 800 736 320 102 10,947 -
1996 6,130 3,018 797 932 352 83 11,312
1997 6,132 4,155 763 (1) 5,540 (2) 372 98 17,060
1998 7,026 2,424 608 (1) 5,090 (2) 337 134 15,618 -
1999 7,453 4,206 522 (1) 1,541 470 151 14,343
2000 7,998 3,719 745 (1) 914 428 148 13,952
2001 9,071 3,097 628 (1) 810 377 167 14,150
2002 9,582 2,791 584 (1) 1,361 468 148 14,934
Note:
Includes General, Special Revenue, Debt Service and Capital Projects Funds. -
(1) Includes only investment earnings
(2) Includes Oaks of Mainstreet real estate sales.
114 -
Table III
CITY OF HOPKINS, MINNESOTA
PROPERTY TAX LEVIES AND COLLECTIONS
Years 1993 Through 2002
(Unaudited)
Collection Percentage Collection
of Current of Levy of Prior Percentage
Year's Taxes Collected Year's Taxes Market of Total
Year Total Tax During Fiscal During Fiscal During Fiscal Total Value Collections
Collect Le 1 Period Period Period Collections Credit 2 to Tax Levy
1993 $ 3,925,100 $ 3,840,652 97.8% $ (10,395) $ 3,830,257 $ 0 97.6%
1994 3,987,216 3,882,651 97.4% (36,765) 3,845,886 0 96.5%
1995 3,975,854 3,903,806 98.2% (43,761) 3,860,045 0 97.1%
1996 4,178,410 4,085,963 97.7% 21,978 4,107,941 0 98.3%
1997 4,217,627 4,166,717 98.8% 29,181 4,195,898 0 99.5%
1998 4,232,961 4,203,506 99.3% 34,612 4,238,118 0 100.1%
1999 4,421,906 4,336,971 98.1% 20,552 4,357,523 0 98.5%
2000 4,672,756 4,611,366 98.7% 44,602 4,655,968 0 99.6%
2001 5,012,361 4,980,059 99.4% 83,221 5,063,280 0 101.0%
2002 (a) 6,591,140 6,174,839 93.7% 40,356 6,215,195 188,266 97.2%
(1)Tax levy is net of Homestead and Agricultural Credit Aid.
(2) In 2002,the State of Minnesota offset property tax collections with an aid- "Market Value Credit"
This aid directly offsets the amount of taxes the city collects from its taxpayers.
(a) Homestead and Agricultural Credit Aid is eliminated and Housing and Redevelopment Levy is immplemented
115
Table IV
CITY OF HOPKINS, MINNESOTA
TAX CAPACITY VALUE AND MARKET VALUE OF ALL TAXABLE PROPERTY
Levy Years 1993 Through 2002 -
(Amounts expressed in thousands)
(Unaudited)
Real Property Personal Property Total Ratio of Total
Fiscal Tax Capacity Market Tax Capacity Market Tax Capacity Market Tax Capacity Value to
Year Value Value Value Value Value Value Total Market Value
1993 $ 16,034 $ 593,160 $ 243 $ 5,066 $ 16,277 $ 598,226 2.7 -
1994 15,314 591,809 269 5,627 15,583 597,436 2.6
1995 15,350 602,136 278 6,044 15,628 608,180 2.6
1996 15,772 621,378 285 6,188 16,057 627,566 2.6 -
1997 14,734 662,246 250 6,254 14,984 668,500 2.2
1998 14,524 725,856 271 7,754 14,795 733,610 2.0
1999 15,507 787,397 264 7,784 15,771 795,182 2.0 _
2000 17,559 877,055 261 7,703 17,820 884,758 2.0
2001 13,406 963,398 155 7,803 13,562 971,202 1.4
2002 14,033 1,058,054 158 7,981 14,191 1,066,035 1.3
116
Table V
CITY OF HOPKINS, MINNESOTA
PROPERTY TAX RATES -
DIRECT AND OVERLAPPING GOVERNMENTS
Years 1993 Through 2002
(Unaudited)
Payable
Fiscal Metro
Year CAy- School Counjy Council Other 1 Total
1993 26.36 65.18 35.84 6.04 1.59 135.01
1994 27.50 67.34 37.44 6.23 1.28 146.02
1995 27.19 75.08 37.45 6.36 2.33 148.41
1996 27.65 61.88 35.52 4.93 3.05 133.03
1997 30.46 61.06 38.39 5.65 2.50 138.06
1998 32.44 58.94 40.99 6.04 3.35 141.76
1999 32.19 56.56 39.66 6.04 3.04 137.49
2000 31.13 44.22 37.62 5.82 2.31 121.74
2001 54.79 15.03 50.49 3.53 5.16 128.94
2002 56.10 20.59 50.61 3.83 6.01 137.14
(1) The City is divided basically into Watershed Districts No. 1 and No. 3. The
difference in the tax capacity rates ranges from zero to less than 0.8%. In this
table, district No. 1 was used, as it is the higher rate. Also included in the "other"
column is the Vo-Tech School rate which is dropped after 1995. Beginning in
1996 the County Park tax rate is added.
117
CITY OF HOPKINS, MINNESOTA
SPECIAL ASSESSMENT BILLINGS AND COLLECTIONS
Years 1993 Through 2002
(Unaudited)
Current Special Percentage of
Assessment Current Special Current Collected
Fiscal Becoming Due Assessments During Fiscal _
Period During Fiscal Period Collected Period
1993 $412,221 $345,557 83.8 _
1994 491,094 462,454 94.2
1995 555,611 506,417 91.2
1996 566,624 502,634 88.7
1997 523,252 424,691 81.2
1998 486,705 465,226 95.6
1999 569,282 530,137 93.1
2000 1,105,792 1,035,393 93.6
2001 1,113,328 1,078,741 96.9 —
2002 1,158,625 1,281,498 110.6
118
Table VI
Total Deferred Special Assessment
Delinquent Specials Special Assessments Collected Balance End
Collected During Delinquent at End Fiscal of Fiscal
Fiscal Period of Fiscal Period Period Period
$48,647 $78,188 $244,961 $2,802,907
6,924 78,909 86,859 3,081,957
15,839 111,438 406,675 2,535,709
83,738 36,057 115,715 2,231,205
12,829 137,002 127,083 2,253,656
6,742 36,136 45,676 6,931,540
9,733 73,870 146,916 14,550,745
33,701 111,264 87,383 13,513,832
66,121 79,732 98,743 12,920,307
45,013 108,843 36,656 12,536,223
119
CITY OF HOPKINS, MINNESOTA
RATIO OF NET BONDED DEBT
TO TAX CAPACITY VALUE AND NET BONDED DEBT PER CAPITA
Pay Years 1993 Through 2002 —
(Unaudited)
Tax Capacity
Value Gross Cash and —
Population After Fiscal Bonded Investments
Year (1) Disparities Debt 2 on Hand/Escrowed
1993 16,534 $ 14,147,542 $ 15,622,343 (3)$ 1,302,870
1994 16,534 13,100,726 14,701,243 1,019,541 —
1995 16,534 12,556,761 14,605,143 932,467
1996 16,534 12,910,496 22,228,543 (4) 1,125,661
1997 16,665 13,194,123 23,418,543 (5) 1,617,274
1998 16,559 11,936,742 16,588,543 1,425,491
1999 16,887 11,749,307 21,533,543 1,625,660 —
2000 17,145 12,526,355 22,668,543 1,781,809
2001 17,145 13,451,356 25,062,696 4,660,378
2002 17,250 10,658,607 33,301,194 3,104,124 —
(1) Source of population data: Metropolitan Council and Bureau of Census.
(2)Includes all long-term general obligation, special assessment and revenue bonded indebtedness
(3)The $8,720,000 of advance refunding bonds were escrowed to retire $7,750,000 bonds by —
February 1, 1998.
(4) Includes $3,795,000 of GO bonds and $3,795,000 of GO revenue bonds to be retired in 1998
from proceeds of Oaks of Mainstreet real estate sales. —
(5)Includes $3,795,000 of GO bonds and $1,970,000 of GO revenue bonds to be retired in 1998
from proceeds of Oaks of Mainstreet real estate sales.
120 —
Table VII
Ratio of
Debt Payable Delinquent Net Bonded Net
From Enterprise and Deferred Net Debt to Bonded
Revenues and Special Bonded Tax Capacity Debt per
Housing Fees Assessments Debt Value Capita
$ 3,143,800 $ 2,881,095 $ 8,294,578 58.63% 502
2,992,700 3,160,866 7,528,136 57.46% 455
3,656,600 (b) 2,647,147 7,368,929 58.68% 446
3,290,000 (b) 2,267,262 7,955,620 (a) 61.62% 481
4,865,000 (b) 2,201,321 8,969,948 (a) 67.98% 538
4,705,000 (b) 2,328,409 8,129,643 68.11% 491
10,075,000 (b) 2,243,626 7,589,257 64.59% 449
11,855,000 (b) 1,968,660 7,063,074 56.39% 412
13,040,000 (b) 2,143,685 5,218,633 38.80% 304
10,905,000 (b) 2,335,503 16,956,567 159.09% 983
(a)excludes Oaks of Mainstreet debt to be paid from real estate sales.
(b) includes Housing Improvement debt to be paid from fees charged to the benefited
properties.
121
CITY OF HOPKINS, MINNESOTA Table VIII
COMPUTATION OF LEGAL DEBT MARGIN —
December 31, 2002
(Unaudited) —
MARKET VALUE $ 971,202,200
DEBT LIMIT 2% OF MARKET VALUE(Note A) $ 19,424,044
TOTAL BONDED DEBT $ 33,301,194 —
DEDUCTIONS (Note B):
Tax Increment Bonds $ 7,841,194 —
Revenue Bonds 4,800,000
Housing Improvement Bonds 6,105,000
Special Assessment Bonds 2,490,000
21,236,194
Amount Available in Debt Service Funds 302,574
Total Deductions 21,538,768
TOTAL DEBT APPLICABLE TO DEBT LIMIT 11,762,426 —
LEGAL DEBT MARGIN $ 7,661,618
Note (A):
M.S.S. Section 4753.53 (Limit on Net Debt)
"Subdivision 1. Generally. Except as otherwise provided in sections 475.51 to 475.75, no municipality
...shall incur or be subject to net debt in excess of two percent of the market value of taxable property in —
the municipality."
Note (B):
M.S.S. Section 475.51 Definitions: —
"Subdivision 4. "Net debt" means the amount remaining after deducting from its gross debt the amount
of current revenues which are applicable within the current fiscal year to the payment of any debt and
the aggregate of the principal of the following: —
(1)Obligations issued for improvements which are payable wholly or partly from the proceeds of special
assessments levied upon property specially benefited thereby...
(2) Warrants or orders having no definite or fixed maturity. —
(3)Obligations payable wholly from the income from revenue producing conveniences.
(4)Obligations issued to create or maintain a permanent improvement revolving fund.
(5)Obligations issued for the acquisition, and betterment of public water work systems...or for any other
public convenience from which a revenue is or may be derived. —
(6)Amount of all money and the face value of all securities held as a debt service fund for the extinguish-
ment of obligations other than those deductible under this subdivision.
(7)All other obligations which under the provisions of law authorizing their issuance are not to be included
in computing the net debt of the municipality.
"Valuation before effect of"fiscal disparity" legislation; Minnesota laws 1971, Chapter 24. See Table IV.
122
_ Table IX
CITY OF HOPKINS, MINNESOTA
COMPUTATION OF DIRECT AND OVERLAPPING DEBT
INCLUDING DEBT RATIOS
December 31,2002
(Unaudited)
Net General Percentage
Obligation Applicable City Share
Debt 1 to City of Debt
Direct Debt
City of Hopkins $ 7,628,310 100.00% $ 7,628,310
Overlapping Debt
Hennepin County 416,390,000 1.24 3,973,650
Independent School District#270 (Hopkins) 84,660,367 15.89 13,427,134
Independent School District#283 51,267,601 0.44 225,577
Hennepin Suburban Park District 25,281,217 1.77 447,478
Metropolitan Council 155,050,000 0.09 1,426,460
Hennepin Regional RR Authority 48,803,803 1.33 649,091
-- Total Overlapping Debt 20,149,390
Total Direct and Overlapping Debt $ 27,777,700
Direct Overlapping Total
Debt Ratios Debt Debt Debt
Ratio of Debt Per Capita(17,250 Population) $442 $1,168 $1,610
Ratio of Debt to Tax Capacity Valuation
(after fiscal disparities)of$10,658,607 (2) 71.57% 189.04% 260.61%
Ratio of Debt to Estimated Market Valuation
of$971,202,200 0.79% 2.07% 2.86%
(1) Excludes Revenue, Special Assessment and HRA Lease Revenue Bonds.
(2)Tax Capacity Values are based on payable 2002 figures.
Source: County Auditor
123
Table X
CITY OF HOPKINS, MINNESOTA
RATIO OF ANNUAL DEBT SERVICE EXPENDITURES FOR —
GENERAL BONDED DEBT TO TOTAL GENERAL EXPENDITURES
Years 1993 Through 2002 —
(Unaudited)
Percentage
Total Total of Debt
Debt General to General
Year Principal Interest Service Expenditures(1) Expenditures
1993 $ 190,000 $ 293,470 $ 483,470 $ 8,893,367 5.4
1994 345,000 229,346 574,346 11,541,044 4.9
1995 340,000 231,467 571,467 10,129,132 5.6
1996 315,000 213,706 528,706 8,817,705 6 —
1997 345,000 195,453 540,453 19,377,504 2.8
1998 345,000 176,616 521,616 11,922,576 4.4
1999 345,000 159,057 504,057 14,936,841 3.4 —
2000 345,000 180,332 525,332 10,225,789 5.1
2001 410,000 162,032 572,032 13,039,750 4.4
2002 2,470,000 (2) 137,625 2,607,625 12,888,094 20.2 —
Note: Only debt that is considered applicable to the legal debt limit is included. All remaining debt is
paid through tax increments, enterprise funds or housing fees.
(1) Includes all governmental fund type expenditures except debt service.
(2)Includes refunded debt in the amount of$2,110,000.
124
Table XI
CITY OF HOPKINS,MINNESOTA
REVENUE BOND COVERAGE
WATER, SEWER AND STORM SEWER REVENUE BONDS
Years 1993 Through 2002
(Unaudited)
Net
Fiscal Gross Operating Revenue Debt Service Coverage
Year Revenue Expenses(1) Available Principal Interest Total Ratio
1993 $ 560,295 $ 87,893 $ 472,402 $ 80,000 $ 169,638 $ 249,638 1.89 to 1
1994 517,325 67,007 450,318 110,000 108,058 218,058 2.06 to 1
1995 517,029 71,911 445,118 110,000 124,825 234,825 1.90 to 1
1996 513,513 103,677 409,836 120,000 118,238 238,238 1.72 to 1
1997 469,938 88,715 381,223 125,000 155,973 280,973 1.36 to 1
1998 554,622 110,294 444,328 135,000 104,870 239,870 1.91 to 1
1999 643,303 84,280 559,023 140,000 98,750 238,750 2.34 to 1
-- 2000 661,776 123,082 538,694 205,000 162,992 367,992 1.47 to 1
2001 1,665,217 814,419 850,798 345,000 369,893 714,893 1.19 to 1
2002 1,564,535 818,704 745,831 1,940,000 237,382 2,177,382 0.34 to 1
(1) Excludes depreciation and debt expense.
125
Table XII
CITY OF HOPKINS, MINNESOTA
DEMOGRAPHIC STATISTICS
Year 1993 Through 2002
(Unaudited)
(2) (3)
Fiscal (1) School % Unemployment
Year Population Enrollment Rate* —
1993 16,534 7,980 3.0%
1994 16,534 7,804 3.0%
1995 16,534 7,942 2.9%
1996 16,534 8,027 2.5%
1997 16,665 8,036 2.4%
1998 16,559 8,313 1.9%
1999 16,887 8,367 2.8%
2000 17,145 8,227 2.5% —
2001 17,145 8,137 3.2%
2002 17,250 8,091 4.2%
Sources: —
(1)Metropolitan Council
(2) School districts within Hopkins
(3)Minnesota Department of Labor and Industry —
*Hennepin County
126 —
_ Table XIII
CITY OF HOPKINS, MINNESOTA
CONSTRUCTION AND PROPERTY VALUE
Years 1993 Through 2002
(Amounts expressed in thousands)
(Unaudited)
(1) (1)
Commercial Residential (2)
Construction Construction Property Value
Fiscal Number of
Year Value Units Value Commercial Residential Nontaxable
1993 5,401 238 3,578 159,533 420,190 78,897
1994 7,967 380 3,320 162,499 429,955 78,897
1995 3,567 289 11,082 159,540 442,910 78,897
1996 12,499 344 5,893 163,722 459,066 78,897
1997 7,672 121 13,162 175,193 489,029 78,897
1998 7,478 371 4,214 187,238 542,793 85,491
1999 32,791 493 10,037 204,988 582,540 85,491
2000 6,818 227 10,234 236,557 640,831 85,491
2001 3,855 520 13,215 251,089 775,236 85,491
_ 2002 3,617 210 22,306 260,337 797,543 85,491
Sources:
(1)City Community Services Department
(2)City Assessor's Office
127
Table XIV
CITY OF HOPKINS, MINNESOTA
PRINCIPAL TAXPAYERS
December 31,2002
(Unaudited)
Amount of —
Percentage Estimated
Tax of Total Tax Tax City
Taxpayer Type of Business Capacity Capaci1y Receives
1. Super Valu Grocery Warehouses 1,054,250 7.51% $ 432,242
2. Duke Realty Office/Warehouses 282,420 2.01% 115,792 —
3. St. Therese Apartments 277,305 1.98% 155,290
4. Ramsgate Apartments Apartments 227,965 1.62% 127,660
5. Westside Village Apartments 194,870 1.39% 109,127 —
6. Greenfield(Phase I) Apartments 173,010 1.23% 96,885
7. Auburn North Townhouses 158,685 1.13% 88,863
8. Greenfield (Phase II) Apartments 158,310 1.13% 88,653 —
9. Edco Products, Inc. Office/Warehouse 131,884 0.94% 73,855
10. Rosewood West Apartments 126,990 0.90% 71,114
11. Gateway Foods Office/Warehouse 121,870 0.87% 49,966 —
12. Creekwood Estates Apartments 119,028 0.85% 66,655
13. Thermotech Office/Warehouse 111,710 0.80% 45,801
14. Christian Salvesen Warehouse 110,490 0.79% 45,300
15. Knollwood Towers West Apartments 108,255 0.77% 60,622 —
16. Buffalo Associates Bank/Office 100,250 0.71% 41,102
17. Oak Ridge Country Club Golf Course 85,150 0.61% 34,873
18. Reuter, Inc. Office/Warehouse 70,370 0.50% 28,851
19. Knox Lumber Retail 58,062 0.41% 23,805
20. Alliant Techsystems Office/Warehouse 52,422 0.37% 21,493
Total 3,723,296 26.53% $ 1,777,949
Total City 2002/2003 tax capacity= 14,033,663 100.00%
Notes:
1)Tax capacity is a percentage of total market value. For taxes payable in 2003 these class rates are
1.5%for apartments and 1.5% of first$150,000 with balance at 2.0% for commercial/industrial properties.
2)The City of Hopkins receives approximately 40%of the total estimated tax for 2002, not including
fiscal disparities and tax increment adjustments. —
3)The estimated tax is based on the tax rates for payable 2003.
128
Table XV
CITY OF HOPKINS, MINNESOTA
MISCELLANEOUS STATISTICAL FACTS
December 31, 2002
(Unaudited)
Dated of Incorporation November 27, 1893
Date of Adoption of City Charter December 2, 1947
Form of Government Council- Manager
Fiscal Year Begins January 1
Area of City 4.0 Square Miles
Miles of Streets and Alleys:
Trunk Highways 1.6
County 6.3
City Streets 55.0
Alleys 9.9
Miles of Sewers:
Storm Sewers 21.4
Sanitary Sewers 43.4
Miles of Watermains 52.6
'— Building Permits:
1993 304
1994 457
1995 390
1996 441
1997 886
1998 463
1999 587
2000 443
2001 498
2002 488
Estimated Cost:
1993 $8,979,218
1994 11,286,814
1995 14,648,615
1996 18,391,797
1997 20,834,150
1998 11,692,315
1999 42,828,312
2000 17,051,981
2001 17,070,262
2002 34,562,884
129
Table XV
CITY OF HOPKINS, MINNESOTA
MISCELLANEOUS STATISTICAL FACTS -CONTINUED
December 31, 2002
(Unaudited)
Fire Protection: _
Number of Stations 1
Number of Employees -Volunteer 35
Police Protection:
Number of Stations 1
Number of Employees 39
Parks:
City Parks 12
Playgrounds 1 _
Skating Rinks 18
Employees:
Regular 112
Part Time 4
Elections: —
Registered Voters- last general election 9,138
Number of votes cast last general election 6,629
Election day registrations 1,336 _
Percentage of registered voters voting 63%
Population:
1920 3,055 —
1930 3,834
1940 4,100
1950 7,595 ,
1960 11,380
1970(census) 13,395
1980(census) 15,336
1991 (census) 16,534
1992 16,534
1993 16,534
1994 16,534 —
1995 16,534
1996 16,534
1997 16,665 —
1998 16,559
1999 16,887
2000 17,145
2001 17,145 —
2002 17,250
130