HomeMy WebLinkAbout1987 CAFR1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
COMPREHENSIVE
ANNUAL
FINANCIAL REPORT
COLUMBIA
590
OF
CITY
HEIGHTS,
FORTIETH
THE
OF
MINNESOTA
AVENUE
55421
N. E.
FOR THE YEAR ENDING
DECEMBER 31, 1987
FINANCE DEPARTMENT
WILLIAM, FINANCE DIRECTOR
M -?D3ER OF GOVERNMENT FINANCE OFFICERS' ASSOCIATION
OF THE UNITED STATES AND CANADA
telephone: 788 -9221 (612)
ANNUAL FINANCIAL REPORT
YEAR ENDED DECEMBER 31, 1987
CITY COUNCIL
Bruce G. Nawrocki, Mayor
Dale V. Hadtrath, Mayor -Elect
Russell D. Paulson
Rita M. Petkoff
Gary L. Peterson
Edward M. Carlson
Robert S. Bocwinski
CITY MANAGER
FINANCE DEPARTMENT
Councilmember
Councilmember
Councilmember
Councilmember
William Elrite Director
CITY OF COLUMBIA HEIGHTS
COMPREHENSIVE ANNUAL FINANCIAL REPORT
YEAR ENDED DECEMBER 31, 1987
' TABLE OF CONTENTS
' INTRODUCTORY SECTION
Title Page
Table of Contents
' Finance Directors Letter of Transmittal
FINANCIAL SECTION
'
Page
Exhibit
Number
Auditors Opinion
11-
'
Combined Balance Sheet - All Fund Types and
Account Groups
I
12 -13
Combined Statement of Revenues, Expenditures,
'
and Changes in Fund Balances - All
Governmental Fund Types
2
14 -15
Combined Statement of Revenues, Expenditures,
and Changes in Fund Balances - Budget and
Actual - General and Special Revenue Fund
Types
3
16 -17
Combined Statement of Revenues, Expenses and
Changes in Retained Earnings - All
'
Proprietary Fund Types
4
18
Combined Statement of Changes in Financial
Position - All Proprietary Fund Types
5
19 -20
Combined Statement of Revenues, Expenditures,
and Changes in Fund Balances Governmental
'
Fund Types - Housing and Redevelopment Authority
6
21
Notes to Financial Statements
22 -49
'
Statement/
Page
Schedule
Number
Financial Statements of Individual Funds:
'
General Fund:
Comparative Balance Sheet
A -1
50
Schedule of Revenues, Expenditures, and Changes
in Fund Balance
A -2
51
Schedule of Revenues, Budget and Actual
A -3
52 -53
Schedule of Expenditures Budget and Actual
A -4
54 -58
L
Statement/
Schedule
Special Revenue Funds:
Combining Balance Sheet
Combining Statement of Revenues, Expenditures,
and Changes in Fund Balance
Statements of Revenues, Expenditures and Changes
in Fund Balance
Revenue Sharing Fund
Municipal State Aid Street Fund
Cable Television Fund
Paratransit Fund
Combining Recreation and Community Service Funds
Recreation and Community Service Funds
Trips and Outings Fund
Senior Citizens Fund
Early Childhood and Family Education Fund
Latch Rey Fund
Adult Basic and Continuing Education Fund
Special Projects Fund
Incentive Grant Fund
Public Information & Education Grant
Demonstration Grant Fund
Debt Service Funds:
Combining Balance Sheet
Combining Statement of Revenues, Expenditures and
Changes in Fund Balances
Capital Projects Funds:
Combining Balance Sheet
Combining Statement of Revenues, Expenditures and
Changes in Fund Balances
Enterprise Funds- Liquor,Water,Sever,Refuse:
Combining Balance Sheet
Combining Statement of Revenues, Expenditures and
Changes in Retained Earnings
Combining Statement of Changes in Financial Position
B -1
B -2
B -3
B -4
B -5
B -6
B -7
B -8
B -9
B -10
B -11
B -12
B -13
B -14
B -15
B -16
B -17
C -1
C -2
D -1
Lfflp-j
Page
Number
59 -60
61 -62
63
64
65
66
67 -68
69
70
71
72
73
74
75
76
77
78
79 -80
81 -82
83 -84
85 -86
E -1 E -2 87 -90 '
E -3 91 -92
E -4 93 -94
III
1111
1 <,
FJ
Statement/
Schedule
'
Municipal Liquor
Fund:
Comparative
Balance Sheet
E -5
'
Comparative
Statement
of Revenues, Expenditures
and
Changes in Retained
Earnings
E -6
'
Comparative
Statement
of Changes in
Financial Position
E -7
Comparative
Schedule
of Gross Profit
E -8
'
Schedule of
Property,
Equipment and
Accumulated
Depreciation
E -9
Vater Utility
Fund:
'
Comparative
Balance Sheet
E -10
Comparative
Statement
of Changes in
Fund Equity
E -11
Expenditures
E
Comparative
Statement
of Revenues and
-12
Comparative
Statement
of Changes in
Financial
'
Position
E -13
Schedule of
Property,
Equipment and
Accumulated
'
Depreciation
E -14
Sewer Utilty Fund:
'
Comparative
Balance Sheet
E -15
Comparative
Statement
of Revenues and Expenditures
E -16
'
Comparative
Statement
of Changes in
Fund Equity
E -17
Comparative
Statement
of Changes in
Financial
'
Position
E -18
Schedule of
Property,
Equipment and
Accumulated
Depreciation
E -19
'
Refuse Utility
Fund:
Comparative
Balance Sheet
E -20
'
Comparative
Statement
of- Revenues and Expenditures
E -21
Comparative
Statement
of Changes in
Financial
'
Position
E-22
Schedule of
Property,
Equipment and
Accumulated
Depreciation
E -23
Page
Number
95
96 -97
98
99 -100
101 -102
103
104
105
106
107 -108
109
110
111
112
113 -114
115
116
117
118 -119
O
Statement/
Page
Schedule
Number
'
Internal Service Fund Central Garage Fund
'
-
Comparative Balance Sheet
F -1
120
'
Comparative Statement of Revenues, Expenditures,
and
Changes in Retained Earnings
F -2
121
Comparative Statement of Changes in Financial
'
Position
F -3
122
Schedule of Property, Equipment, and Accumulated
,
Depreciation
F -4
123 -124
Housing and Redevelopment Authority:
'
Combined Balance Sheet
G -1
125 -126
Combined Statement of Revenues, Expenditures, and
'
Changes in Fund Balance - Budget and Actual
G -2
127 -128
Combining Balance Sheet - Special Revenue Funds
G -3
129 -130
,
Combining Sstatement of Revenues, Expenditures,
and Changes in Fund Balance- Special Revenue Funds
G -4
131 -132
General Fixed Assets Account Group:
'
Statement of General Fixed Assets
H -1
133
'
General Long -Term Debt Account Group:
Statement of General Long -Term Debt
I -1
134
i
,
Schedule of Funding Available
I -2
135
Schedule of Service Requirements to Maturity
I -3
136
'
STATISTICAL SECTION
Table
,
Assessed Value and Market Value of all
.
Taxable Property
I
137 -138
II
139
'
Property Tax Rates
City Tax Levy
III
140
'
Tax Levies and Tax Collections
IV
141 -142
Special Assessment Collections
V
141 -142
'
Table
Revenues -Other than Property Taxes
and Special Assessments
VI
143
Expenditures for Selected Functions
VII
143
Statement of Legal Debt Margin
VIII
144
Combining Schedule of Bonds Payable
IX
145 -152
Schedule of Investments
X
153
Schedule of Insurance in Force
XI
154
Schedule of Sources and Users of Public Funds
XII
155 -156
Miscellaneous Statistics
XIII
157 -159
0
DEPARTMENTS
Accounting
City Clerk
Elections
Utility Billing
Collections
Liquor
No. 1 Off Sale
No. 2 Off Sale
No. 3 Off Sale
DIVISIONS
Civil Defense
Regular
Reserves
Regular
Volunteers POLICE
Reserves
FIRE
FINANCE
Cable TV
Para Transit
Inspections
Licenses b Permits JADMINISTRATIV
Planning SERVICES
Assessing
Refuse
Recycling
Engineering
Streets
Water Maintenance
Sewer Maintenance
Parks - Admin. 6
Maintenance
Central Garage
PUBLIC
WORKS
LIBRARY
GENERAL
GOVERNMENT
BUILDINGS
LEGAL
I CITY OF COLUMBIA NEIGHTS, MINNESOTA
CITY
MANAGER
ADMINISTRATIVE
ORGANIZATION
CITY OF COLUMBIA
HEIGHTS, MINNESOTA
MAYOR
COUNCIL
MEMBERS
RECREATION b
COMMUNITY
SERVICES
COMMISSION '
RECREATION a
COMMUNITY/
SERVICES
ELECTORS
INDEPENDENT
SCHOOL DIS-
TRICT !!13
COMMISSIONS AND BOARDS
Cable Communications
Science jech. & Energy
Merit
Insurance
Planning and Zoning
Recreation & Community
Services
Park
Traffic
HRA
Library
Human Services
Police & Fire Civil
Service
Charter
ANNUAL FINANCIAL REPORT
CITY
June 27, 1988
Mr. Robert S. Bocwinski
City Manager
City of Columbia Heights
Dear Mr. Bocwinski:
The Comprehensive Annual Financial Report of the City of Columbia Heights,
Minnesota, for the fiscal year ended December 31, 1987, is submitted
herewith. We believe the data, as presented, is accurate in all material
aspects; that it is presented in a manner designed to fairly set forth 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 Government Finance Officer's
Association of the United States and Canada; the Governmental Accounting
Standards Board; the American Institute of Certified Public Accountants;
the State Auditor's Office, State of Minnesota; and the City Charter. The
report consists of three sections: Section I is the introductory section
and contains the Table of Contents, Letter of Transmittal and
Administrative Organization. Section II is the financial section and
contains the Auditor's report, general purpose financial statements, notes
to financial statements and the combining and individual fund and account
group statements and schedules. Section III is the statistical section
and contains comparative statistical tables and data for the past ten
years having reference value for citizens and investors.
ACCOUNTING SYSTEM AND BUDGETARY CONTROL
The City maintains complete self - balancing account groups for each entity
of the City in accordance with the organizational chart of the city. This
results in a classification of transactions according to specific
functions, separate and distinct from those pertaining to unrelated
activities.
Dale V. Hadtrath, Mayor
Rita M. Petkoff, Councilmember Russell D. Paulson, Councilmember
Edward M. Carlson, Councilmember -1- Gary L. Peterson, Councilmember
EQUAL OPPORTUNITY EMPLOYER
The City's accounting records are maintained on the accrual, or modified
accrual basis, as appropriate. Budgetary control is maintained by an
encumbrance system whereby purchase requests are pre- audited as to
authorization and availability of funds prior to their release to
vendors. Also, inherent in this controlling function is the management
philosophy that the existence of a particular item or appropriation in the
approved budget does not automatically mean that it will or must be
spent. The budget process has flexibility in that, where need has been
adequately demonstrated, an adjustment can be made within the department
budget by the City Manager, or between departments and funds by the City
Council. Therefore, there is a constant reviewal process and expenditures
are not approved until it has been determined that (1) adequate funds were
appropriated, (2) the expenditure is still necessary and (3) funds are
available.
THE REPORTING ENTITY AND ITS SERVICES
The City, which is a suburb located north of the City of Minneapolis in
Anoka County, Minnesota, was originally incorporated as a village in
1898. In 1921, pursuant to adoption of a home rule City Charter by the
qualified voters of the City, the City instituted a Council- Manager form
of government. The City covers an area of 3.52 square miles and its
population is currently estimated to be 19,430.
The City Council is the legislative and policy making body of the City.
Four Councilmembers are elected for four -year staggered terms. The Mayor,
who presides over council meetings, is elected at large for a two -year
term. The responsibilities of the City Council include:
(a) enacting ordinances, resolutions and orders necessary for the
proper governing of the City's affairs;
(b) reviewing and adopting the annual budget;
(c) reviewing and deciding on recommendations from various boards and
commissions;
(d) appointing a City Manager and citizens to various boards and
commissions;
(e) establishing policies and measures to promote the general welfare
of the city and safety and health of its citizens; and
(f) representing the city at official functions with other
organizations and governmental agencies.
Various departments of the city provide the following services for the
residents of the city:
Public Works Department. The Public Works department is responsible for
the maintainance of the public roadways within the City, including
patching, resurfacing, snow and ice removal, sweeping, tree removal, as
well as the maintenance and repair on all City owned vehicles and
motorized equipment. The department provides for the maintenance of
public lands and recreational facilities within the City. The City
presently maintains 14 parks.
-2-
' The City operates its own municipal water system, purchasing all water
from the City of Minneapolis. The City also maintains it's own sanitary
and storm sewer system which is serviced by -the Metropolitan Waste Control
' System.
Police Department. The Police department employs 25 persons of which 18
' are sworn full -time police officers. The department is responsible for
the preservation of life and property, maintenance of public peace and
order, prevention of crime, apprehending criminals and investigating
criminal acts and civil wrongs.
' Fire Department. The City provides fire protection to residents within
the City through trained and equipped volunteers and paid firefighters,
and through a program of fire inspection and fire prevention education.
The Fire Department includes one full -time Fire Chief and six full -time
firefighters. The City has a mutual aid agreement with the adjacent
cities of Fridley and St.Anthony.
' Assessing. The City is the public agency responsible for establishing
estimated market value on all residential, vacant, commercial and
industrial properties within the city in accordance with the applicable
' laws of the State.
Recreation. The City provides various recreational programs to all areas
of the city including recreation classes for all ages, youth sports,
senior citizen activities, public-ice skating facilities, public swimming
beaches, playgrounds, day camps, handicapped adult programs and community
theatre and symphony programs. Those programs are sponsored by the joint
' cooperative effort of Independent School District No. 13 and the City of
Columbia Heights, supported financially by both governmental units and
administered by the Recreation and Community Services Commission.
Library. The Public Library provides recreational and informational
services for the city residents. The Library participates in MELSA, a
program which makes available to residents material and services from
' other library organizations in the Twin Cities area. In 1987, the library
went on -line with an automated circulation system. All the public
libraries in Anoka County may now be accessed through computer terminals,
and all the libraries share common patron and material databases.
The Housing and Redevelopment Authority. Created in 1969, the Authority
assists the City in identifying its needs in the areas of housing and
' community development. A variety of programs are offered to city
residents by the Housing and Redevelopment Authority, including senior
citizen housing; rental assistance program; and low interest home
improvement loan and grant program and a single family mortgage program to
' low income individuals or families.
Since 1974, the Authority has been working toward redevelopment of its
downtown central business district resulting in the construction of
Columbia Heights Center. Completed work in connection with the Downtown
Central Business District Revitalization Project includes the 100,000
square foot Columbia Heights Mall, an enclosed mall offering the area
expanded and updated retail shopping; the Columbia Heights office plaza, a
100,000 square foot office tower; the 4111 office building, a 34,400
square foot office facility; and Columbia Park Clinic, a 35,000 square
foot medical clinic. Also, completed are the La Belle Park condominiums,
a 204 -unit project, Parkview Villa, a 101 - unit senior citizen highrise,
and a 153 -unit town house project.
Planning and Inspectional Services. The City's Planning and Building
Inspections Department is responsible for the coordination of physical,
social and economic changes in the City and to develop and refine
ordinances which implement city growth. The Inspections Department
enforces environmental housing and zoning codes in the City thorugh the
review of construction plans, issuance of building permits, inspection of
all structures, issuance of occupancy permits and registration of multiple
units. Business licensing functions are also the responsibility of this
department.
GENERAL GOVERNMENTAL FUNCTIONS
All activities of the City of Columbia Heights are reflected in this
annual report. As the General Fund receives all City revenues not
designated for specific use by statutes or the City Charter, the following
information relative to the General Fund's revenues, expenditures and fund
balance is included.
REVENUES
Revenues for the General Fund totaled $5,959,541 in 1987, an increase of
23.8 percent over 1986. General property taxes produced 27.3 percent of
general revenues compared to 28.7 last year. The amount of revenues from
various sources and the increase (decrease) over last year are shown in
the following tabulation:
Increase
1987 Percent (Decrease)
Revenue Source Amount of Total from 1986
General Property.Taxes
1,628,970
27.32
246,413
Licenses and Permits
131,351
2.2
(56,458)
Intergovernmental Revenues
2,512,297
42.2
115,581
Charges for Services
178,887
3.0
63,905
Fines and Forfeits
123,813
2.1
15,655
Miscellaneous Revenue
658,675
11.0
409,243
Expenditure Reimbursements
51,419
.9
44,049
Transfers -In
674,129
11.3
308,235
Totals
$5,959,541
100.02
$1,146,623
-4-
From the above table, it is apparent that the major sources available for
funding general operations are the property tax and.intergovernmental
revenue (primarily state aids). Both of these sources are controlled in
' the amount they can increase by what is known as the Levy Limitation Law.
LEVY LIMITATION
' State law limits the amount by which the City (as well as other political
subdivisions) may increase its tax levy from one year to the next. The
levy limit base may be increased each year by a formula pursuant to state
law. Provisions are made to allow the limitations to be increased or
' decreased based on a number of circumstances, including population or
boundary changes; transfer of a governmental function or service or by way
of a direct referendum. The following table is a summary of the City's
status in complying with the law for.1987 and 1988.
1 Beginning 1988 Levy Limit Base ,$ 3,846,375
Adjustment Growth in Population or Households
' (Use the larger of the following ratios)
Population Households
a. 1987 19,430 7,878
b. 1986 19,426 7,746
' c. Ratio (1987/86) 1.00 1.017 65,388
Population /Household adjusted 1988 Levy Limit Base $ 3,911,763
' Inflation Adjustment $ 117,353
Adjusted Levy Base $ 4,029,116
1988 Local Government Aids $1,770,244
1988 Final Levy Limitation $ 2,258,872
FISCAL DISPARITIES
The Metropolitan Fiscal Disparities Act was first implemented for taxes
payable in 1975. It established a new property tax system for the seven
metropolitan counties of Anoka, Carver, Dakota, Hennepin, Ramsey, Scott
and Washington. The law provides for the pooling of a percentage of all
new commercial /industrial property valuation or growth in the seven county
area to be redistributed to the taxing jurisdictions according to
specified criteria. The impact on the taxable valuations of the city for
taxes collectible in 1985 through 1987 is as follows:
-5-
1986
$ 1,547,299
114.767.361
$116,314,660
$ (5,778,176)
15,650,911
$ 9,872,735
$126,187,395
1985
$ 11500,988
113,721,411
$115,222,399
$ (4,407,361)
14,264,696
$ 9,857,335
$125,079,734
1987
City's taxable value:
Personal property
$ 1,679,868
Real estate
116,413,206
Sub Total
$118,093,074
Areawide Allocation:
Contribution to 'pool"
$ (5,180,460)
Distribution from "pool" 17,871,259
Net Increase
$ 12,690,799
Combined Value
$130,783,873
-5-
1986
$ 1,547,299
114.767.361
$116,314,660
$ (5,778,176)
15,650,911
$ 9,872,735
$126,187,395
1985
$ 11500,988
113,721,411
$115,222,399
$ (4,407,361)
14,264,696
$ 9,857,335
$125,079,734
PROPERTY TAX AND SPECIAL ASSESSMENT COLLECTIONS
It is the City's policy to offset any property taxes not received with an
equal allowance for uncollectible amounts. Therefore, any delinquent
taxes, or un remitted current taxes are not recognized as revenue until
received in cash, and are used to finance the budget in the year in which
they are received.
EXPENDITURES
Expenditures for the General Fund totalled $4,607,346, an increase of
7.7 percent over 1986. Increases in levels of expenditures for major
functions of the city over the preceding year are shown in the following
* A hI l l A* 7 AT .
Function
General Government
Public Safety
Highways and Streets
Sanitation
Parks
Library
Contingencies and Transfers
Total
Amount
$919,991
1,915,895
704,081
8,950
518,333
261,583
278,513
$4,607,346
Percent of
Total
20.OZ
41.6
15.3
0.2
11.2
5.7
6.0
100.0
Increase
(Decrease)
from 1986
34,648
30,241
73,156
4,018
41,269
(2,067)
147,017
$328,282
FUND BALANCE
On December 31, 1987, the
fund balance of the General Fund totaled
'
$4,494,576 up $1,352,195 from
the preceding year. This fund balance is
adequate, but it should be
pointed out that this represents working
capital for general operations
that is used extensively during the first
seven months until current
taxes and state aids- are received.
'
The following table shows
previous year -end General Fund balances, as
compared to adopted budget
of the following year.
'
General Fund
Total of Appropriated and
Budget
Unappropriated Fund Balance
Beginning of Year
Beginning of Year
'
Amount. Z of Budget
1979 3,078,785
957,562 31.1
1980 3,407,235
1,312,026 38.5
'
1981 3,978,165
1,508,906 37.9
1982 4,342,875
1,538,691 35.4
1983 4,245,909
1,734,848 40.9
1984 4,536,850
2,142,151 47.2
,
1985 4,443,220
2,612,770 58.8
1986 4,778,107
2,608,527 54.6
1987 59383,121
3,142,381 58.4
1988 5,534,098
4,494,576 81.2
'
I
' SPECIAL REVENUE FUNDS
The Revenue Sharing Fund was established to account for the receipt and
' expenditure of federal general revenue sharing funds. Revenue Sharing was
enacted in 1972, and covered the period from January 1, 1972 through
December 31, 1976. Federal amendments to the law reauthorized
appropriations through December 31, 1986. The following table summarizes
' revenues and expenditures of the Revenue Sharing Fund for the past ten
years.
Rev Sharing Interest Capital Trf.to Fund Bal.
Revenue Earnings Total Projects Operat. Other Fd. Total Yr.End
1978 178,817 5,800 184,617 179,120 12,723 191,843 66,060
' 1979 176,635 9,584 186,219 112,904 18,189 131,093 121,186
1980 160,131 12,872 173,003 110,709 29,357 140,066 154,123
1981 160,957 20,936 181,353 135,903 3,951 139,854 195,622
1982 141,743 24,207 165,950 59,318 1,832 61,150.300,422
1983 113,225 29,368 142,593 125,750 2,737 128,487 314,528
1984 112,599 51,406 164,005 40,912 14 40,926 437,607
1985 110,091 38,667 148,758 231,408 9,918 58,500 299,826 286,540
' 1986 69,207 23_449 92,656 142,295 6,703 148,998 230,198
1987 34,541 - 114,917 149,458 80,740
The Municipal State Aid Street Fund was established to receive gasoline
' tax apportionments from the State which are used to construct State -Aid
Streets.
The Cable Television Fund is used to account for revenues from franchise
fees and related expenditures.
The Para - Transit Fund is established by agreement with the Minnesota
.' Department -of Transportation to account for the receipt of State grants
and rider fees and related expenditures.
' In 1978 the Recreation Commission was expanded to include a Community
Services function. The Recreation and Community Services Commission Funds
are funded and directed in cooperation with Independent School District
No. 13 through a six - member board. In 1987, the Recreation and Community
' Services Fund was sub - divided in order to provide better accountability
for those activities funded by outside sources such as state and federal
grants.
' Recycling Funds were established for the receipt of grant monies and
related expenditures in connection with the development of recycling
programs and the dissemination of information to the public to promote
' recycling.
CAPITAL PROJECTS FUNDS
Capital Project Funds are maintained to account for the construction of
major capital facilities. Project applications are a combination of
several revenue sources, such as municipal state aid streets, special
assessments, water and sewer utility funds, other governmental units, etc.
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 Enterprise and Internal Service Funds. As of December 31, 1987, the
general fixed assets of the City amounted to $ 9,053,162. This amount
represents the original cost of land, buildings and equipment and is
considerably less than their present balue. Depreciation of the general
fixed assets is not recognized, as is customary in governmental
accounting, in the City's accounting system. Depreciation of assets is
recognized in the proprietary funds for rate setting purposes, etc.
An appraisal of buildings, structures and equipment (excluding vehicles
for which the City had cost information) was accomplished in 1979. These
values plus the original assessed cost of water and sewer lines were
established on the City's accounting.records.
ENTERPRISE FUNDS
LIQUOR OPERATIONS. Total sales from the City's three off -sale locations
amounted to $ 3,748,248 an increase of $222,080 from 1986. This resulted
in a total net operating income of $ 220,460, an increase of $6,953. In
1987, the decision was made to close the store on 40th Ave. N.E. at the
end of the first quarter of 1988. It is anticipated that 75 -80Z of the
existing business at 40th Ave. will be absorbed by Top Valu on Central
Avenue and Heights Liquor at 53rd and University.
WATER, SEWER AND REFUSE UTILITIES.
The Water, Sewer and Refuse Utility Funds continued to show moderate gains
in operating revenues and net income for 1987. Data for the fiscal year
are presented in the following tabulation.
1987 Operating Revenues
1987 Net Income
1986 Net Income
Percentage Increase
(Decrease)
Water
Sewer
Refuse
$888,545
$827,512
$597,424
117,065
312,049
29,938
25,855
312,769
44,889
452.82
(0.2Z)
(33.3x)
INTERNAL SERVICE FUND
The Central Garage Fund was established
service shop and to allocate such cost
maintained on a self- sustaining basis.
unreserved fund balance of $127,709 as
IM
in 1977 to record expenses of the
to the using departments.. This is
Retained earnings has an
of December 31, 1987.
I
n
0
I I
III
C
TRUST AND AGENCY FUNDS
The Investment Trust Fund was created in 1974 to record all investment
transactions except direct investments of bonds of the city purchased by
other funds. Interest earnings from these investments are allocated to
all funds of the city, except construction accounts and the trust and
agency funds, on the basis of the average cash balances during the year.
Investment principal at December 31, at book value, is also allocated to
the individual funds. The allocation of interest earnings to December 31,
includes accrued interest receivable, which is added to the book value of
the investments. Interest earnings for the past ten years are as follows:
Year
Earnings
Yield
1977
114,186
5.691
1978
119,918
6.291
1979
181,797
9.211
1980
229,978
11.141
1981
324,608
12.301
1982
364,565
11.401
1983
587,366
10.691
1984
905,514
9.411
1985
894,223
8.011
1986
948,378
9.211
1987
716,820
7.281
The 1987 earnings were distributed to the following funds:
General
$ 199,565
Cable Television
9,699
Debt Service
219,925
Capital Improvements
41,710
Water
39,223
Sewer
138,145
Liquor
60,198
Central Garage
8,355
$ 716,820
INDEPENDENT AUDIT
The City Charter requires an annual audit of the books of accounts,
financial records, and transactions of all administrative departments of
the city by independent certified public accountants selected by the City
Council. This requirement has been complied with and the auditor's
opinion has been included in this report.
ACKNOWLEDGEMENTS
The preparation of this, report on a timely basis could not be accomplished
without the efficient and dedicated services of the entire staff of the
Finance Department. I would like to express my appreciation to all
members of the Department who assisted and contributed to its
preparation. I would also like to thank the Mayor and City Council for
their interest and support in planning and conducting the financial
operations of the City in a responsible and progressive manner.
Respectfully submitted,
William Elrite
Finance Director
-10-
GENERAL PURPOSE
FINANCIAL STATEMENTS
These General Purpose Financial Statements are part of the
Comprehensive Annual Financial Report, presenting only aggregate
data by fund type and account group, together with notes to the
financial statements and constitutes "fair presentation in con-
formity with generally accepted accounting principles,"
It is felt that these General Purpose Statements will be a
benefit to users requiring less detailed information about our
City's finances.
BERGREN, HOLMGREN & LOBERG, LTD.
' CERTIFIED PUBLIC ACCOUNTANTS
OFFICES IN:
501 EAST HIGHWAY 13 New Prague, MN
BURNSVILLE, MN 55337
PHONE (612) 894 -2111
' To the Honorable Mayor and
Members of the City Council
City of Columbia Heights, Minnesota
s
We have examined the combined financial statements of the City of Columbia
' Heights, Minnesota and its combining and individual fund and account group
financial statements as of and for the year ended December 31, 1987 as listed in
the Table of Contents. Our examination as made in accordance with generally
accepted auditing standards and, accordingly, included such tests of the
' accounting records and such other auditing procedures as we considered necessary
in the circumstances.
In our opinion, the combined financial statements referred to above present
fairly the financial position of the City of Columbia Heights, Minnesota at
December 31, 1987 and the results of its operations and the changes in financial
position of its proprietary fund types for the year then ended, in conformity
' with generally accepted accounting principles applied on a basis consistent with
that of the preceding year after giving retroactive effect to the change, with
which we concur, in accounting for special assessments as described in note 16
to the financial statements. Also, in our opinion, the combining and individual
fund and account group financial statements referred to above present fairly the
financial position of the individual funds and account groups of the City of
' Columbia Heights, Minnesota at December 31, 1987 and the results of operations
of such funds and the changes in financial position of individual proprietary
funds for the year then ended, in conformity with generally accepted accounting
principles applied on a basis consistent with that of the preceding year after
' giving retroactive effect to the change, with which we concur, in accounting for
special assessments as described in note 16 to the financial statements.
' Our examination was made for the purpose of forming an opinion on the combined
financial statements taken as a whole on the combining and individual fund and
account group financial statements. The accompanying financial information
' listed as supporting schedules in the Table of Contents is presented for
purposes of additional analysis and are not a required part of the combined
financial statements of the City of Columbia Heights, Minnesota. The
information has been subjected to the auditing procedures applied in the
' examination of the combining, and individual fund and account group, financial
statements, and, in our opinion, is fairly stated in all material respects in
relation to the combined financial statements taken as a whole. Our examination
' did not include the statistical information listed in the Table of Contents.
i�� 104
June 10, 1988 _1
' MEMBERS OF AMERICAN NJSTITUTE OF CERTFIED PUBLIC ACCOUNTANTS
4
ti
n
A
n r+ •?
N NN m M
^
W
1m1
M I
9
G
H
n
eYT�i'
1,�aS�3' vlp�
1 N R M g � f�
My �+
IA
A
aP
I QRI C t�yp1�
i'
r
M
t�
1--
at
11.
.Q
Q
G
g
1=
x
ii
c
M
YI tO �np kG QQ11 2M1 m-. E 6
d ail r+ M � .� t11 � M � M •�f � 1�
W 1 M � ayp� N 1M�7
f^°7 ^N N M h RI M a0 Y7
to i a° coil
ai cu' cv
LA
�
{+ � I
w� ry N M
U.�
Rd-A
d t'!T I 1 .+ I 1 1 I 1 1 1 1 1 1 1 1 1 1 1 ► I
•w
it �My
�� 1 ± I 1� 1 1 ► ^ 1 1 ^ 1 1 1 1 1 1 1 1 I 1
N
CL
w
.+ sl d � i � •w IY •+ � � �+ � �1 1�+
Imo s
YI � 07 � .•n F > YLI O � � -0 M Im
1.0 LLJJ w
'�
�Ny 1�� C Q � � F+ MRRR CL W � C �yy Q L] T� w �4w. � � ■
—12—
n
A
n r+ •?
N NN m M
^
O�
1m1
M I
yP ..
N t'+J 1 1
aj� .F1 t0
eYT�i'
1,�aS�3' vlp�
1 N R M g � f�
9
IA
m
aP
N P*
2
Fd
��yL
a^0
1'� �Mpp
a0 •P MAO' KI
�My
d N'
M If� It"J .r C11 N
f�
11%
M
N
- -
U9 N•?
t6
1 1
I 1 1' 1 1 1
1 I 1 I 1
1 I N M ��y 1
6 n n m K1
1
1
I
� 1 I I I 1
I 1 m I I
1 i 1 I n� n
I
1
,,;�•
YI tO �np kG QQ11 2M1 m-. E 6
d ail r+ M � .� t11 � M � M •�f � 1�
W 1 M � ayp� N 1M�7
f^°7 ^N N M h RI M a0 Y7
to i a° coil
ai cu' cv
LA
�
{+ � I
w� ry N M
U.�
Rd-A
d t'!T I 1 .+ I 1 1 I 1 1 1 1 1 1 1 1 1 1 1 ► I
•w
it �My
�� 1 ± I 1� 1 1 ► ^ 1 1 ^ 1 1 1 1 1 1 1 1 I 1
N
CL
w
.+ sl d � i � •w IY •+ � � �+ � �1 1�+
Imo s
YI � 07 � .•n F > YLI O � � -0 M Im
1.0 LLJJ w
'�
�Ny 1�� C Q � � F+ MRRR CL W � C �yy Q L] T� w �4w. � � ■
—12—
a
E�
F^�
M
1
S
M
M Ili
I
I
I
J
!6
M
Ii
Ib
C
W
a
CL of I
�5
Imo!
r"
rg;
H
ti
J
cy, At
�, tppcLLs�
cu
eu" r�T -• Iri cvw '„r � I
N
Nw Ifr N N M ^ -IF i~
N w N
1 I I 1 1 I 1 pro 1 1 1 I I I I 1 1 1 N
N
I _
N N I N
i
+{ N M M
cm
CN I M N M
t 1 ^ 1 1 I 1 1 1 1 1 1 IfJ 1 N I N
In i 1j} !i
1
ro ri w;
If
N
N N ~ 1
�i
N { M M
All
a _
ik
3.
in
� � a •• � a a ^ � � � � 8i it P � i
aup
J LL 1—
—13—
COMBINED STATEMENT OF REVENUES,
EXPENDITURES
AND .CHANGES IN
FUND
BALANCES - ALL GOVERNMENTAL FUND TYPES
Year Ended December 31, 1987
Special
Debt
General
Revenue
Service
REVENUES:
----- - - - - --
---- - - - - --
----- - - -��.
General property taxes
$1,628,970
$ -
$19104,964
Homestead credit
559,922
-
147,363
Special assessments
-
_
524,854
Licenses and permits
131,351
-
_
Fines and forfeitures
123,813
-
_
Interest and rents
658,675
9,699
324,300
Intergovernmental revenues
1,952,375
331,267
-
Charges for services
178,887
210,655
-
Other revenue
51,419
----- - - - - --
18,166
31,683
Total Revenues
$5,285,412
---- - - - - --
$569,787
------ - - - - --
$2,132,364
OTHER FINANCING SOURCES:
Operating transfers in
674,129
145,388
2,966,308
Proceeds from sale of bonds
-
----- - - - - --
-
----
12,420,000
Total Revenues and Other Sources
$5,959,541
- - - - --
$715,175
------ - - - - --
$17,518,672
EXPENDITURES:
Current:
General government
$919,991
-
-
Public safety
1,915,895
-
_
Public works
704,081
-
-
Sanitation
8,950
_
_
Library
261,583
-
-
Parks and recreation
518,333
478,432
-
Other
19,262
125,586
5,497
Capital outlay
-
38,212
-
Debt service:
Principal retirement
-
-
335,000
Interest and fiscal charges
-
----- - - - - --
-
1,466,910
Total Expenditures
$4,348,095
---- - - - - --
$642,230
------ - - - - --
$1,807,407
OTHER FINANCING USES:
Operating Transfers Out
259,251
----- - - - - --
226,695
----
4,259,580
-
Total. Expenditures and Other Uses
$4,607,346
- - - - --
$868,925
------ ---- --
$6,066,987
EXCESS OF REVENUES AND OTHER SOURCES
----- - - - - --
---- - - - - --
-----------
OVER (UNDER) EXPENDITURES AND OTHER USES
$1,352,195
($153,750)
$11,451,685
FUND BALANCE AT BEGINNING OF YEAR
3,142,381
765,058
1,698,216
FUND BALANCE AT END OF YEAR
$4,4949576
$611,308
$13,1419901
== asosa�z=
aa= aaxaoam
aaaa =saws
The.notes to the financial statement
are an integral part of this statement
-14-
Capital
Projects
41,709
72,558
2, 323
-------- - - - - --
$116, 590
1,342,067
$1,458,657
1, 126,054
$1,126,054
$1,126,054
$332,603
(305,654)
$26,949
Exhibit 2
Total
(Memorandum
Only)
-----------------------------
1987
1986
------ - - - - --
------ - - - - --
$2,733,934
$2,275,432
707,285
589,181
524,054
40S,239
131,351
187, 809
123, 813
108,158
1, 034, 383
516,078
2,356,200
2,556,560
389,542
351,897
103,591
- - - --
311,513
------ - - - - --
------ -
$8,104,153
$7,304,867
5,127,892
12, 420, 000
$25,652,045
$919,991
1,915,895
704, 081
8,950
261,583
996,765
150,345
1,164,266
335,000
1,466,910
$7,923,786
4,745,526
$12,669,312
$12,982,733
5,292,001
$18, 274, 734
1,964,014
$9,268,881
$885,343
1,993,156
649,075
4,932
281,040
871,325
59,953
3,456,174
280,000
1, 108, 083
$9,589,081
1,306,266
$10,895,347
($1,626,466)
6,918,467
$5,2w,601
-15-
COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND
BALANCES - BUDGET AND ACTUAL - GENERAL AND SPECIAL REVENUE FUND TYPES
Year Ended December 31, 1987
GENERAL FUND
REVENUES:
General property taxes
Homestead Credit
Licenses and permits
Fines and forfeitures
Interest and rents
Intergovernmental revenue
Charges for services
Other revenue
Total Revenue
OTHER FINANCING SOURCES:
Transfers from other funds
Total Revenues and
Other Sources
EXPENDITURES:
General government
Public safety
Public works
Sanitation
Library
Parks and recreation
Other
Capital Outlay
Total Expenditures
OTHER FINANCING USES:
Operating Transfers Out
Total Expenditures and
Other Uses
EXCESS OF REVENUES AND OTHER
SOURCES OVER (UNDER) EXPEND -
TURES AND OTHER USES
FUND BALANCE AT BEGINNING
Original Revised
Budget Budget Actual
------ - - - - -- ----- - - - - -- - - - - - --
$1, 688, 115 $1,688,115 $1,628,970
500,000
500,000
559,922
151,075
151,075
131,351
80,700
80,700
123,813
143,481
143,481
658,675
1,915,590
1,953,704
1,952,375
89,614
140,614
178,887
14,000
14,000
51,419
$4,582,575 $4,671,689 $5,285,412
519,659 530,854 674,129
----- - - - - -- ----- - - - - -- ---- - - - - --
$5,102,234- $5,202,543- $5,959,541
$950,528
$994,171
$919,991
2,126,363
2,058,899
1,915,895
803,208
945,053
704,081
12,073
8,725
8,950
28S,470
299,332
261,583
555,339
550,083
518,333
200,000
100,000
19,262
Variance
Over(Under)
($59,145)
59,922
(19,724)
43,113
515,194
(1,329)
38,273
37,419
$613,723
143,275
--- $756,998
$74, 180
143,004
240,972
(225)
37,749
31,750
80,73B
------ - - - - -- ----- - - - - -- ----- - - - - -- ----- - - - - --
$4,935,981 $4,956,263 $4,348,095 $608,168
146,253
----- - - - - --
146,253
----- - - - - --
259,251
----- - - - - --
(112,998)
------ - - - - --
$5,082,234 -
$5,102,516 -
$4,607,346 -
-- -$495, 170-
20,000
100,027
1,352,195
1,252,168
OF YEAR 3,142,381 3 142 381 3,142,381
- - - - -- - - -- , -
----- - - - - -- ----- - - - - -- ------ - - - - --
FUND BALANCE AT END OF YEAR $3,162,381 $3,242,408 $4,494,576 $1,252,168
The notes to the financial statement are an
integral part of this statement
-16-
I
1
[1
rJ
[J
[J
n
[1
' Exhibit 3
' SPECIAL REVENUE FUNDS
Total
--- - - - - -- ------
- - - - --
(Memorandum
Only)
'
Variance
------------------------------------
Revised
Variance
Budget
----- - - - - --
Actual
--- - - - - --
Over(Under)
----- - - - - --
Budget
----- - - - - --
Actual
----- - - - - --
Over(Under)
------ - - - - --
'
$ -
$ -
$ -
$1,688,115
$1,628,970
( #59,145)
500,000
559,922
59,922
151,075
131,351
(19,724)
-
-
-
80,700
123,813
43,113
5,000
9,699
4,699
148,481
668,374
519,893
'
506,409
331,267
(175, 142)
2,460,113
2,283,642
(176, 471)
305,806
210,655
(95,151)
446,420
389,542
(56,878)
-
18,166
18,166
14,000
- - - - - -
69,585
----- - - - - --
55,585
------ - - - - --
' --- - - - - -
--$817,215 -
--- - - - - -----
$569,787 -
- - - - --
-($247,428)
-----
$5,488,904
$5,855,199
$366,295
114,475-
145,388
30,913
645,329
819,517
174,188
---
$931,690
----- - - - - --
$715,175
--- - - - - --
($216,515)
-----------
$6,134,233
----- - - - - --
$6,674,716
----- - - - - --
$540,483
------ - - - - --
$ -
$ -)
$ -
$994,171
$919,991
$74,180
-
-
-
2,058,899
1,915,895
143, 004
945,053
704,081
240,972
' -
-
_
$,725
8,950
(225)
-
-
-
299,332
261,583
37,749
473,161
478,432
(5,271)
1,023,244
996,765
26,479
' 140,509
- 125,586
14,923
240,509
144,848
95,661
38,212
(38,212)
----- - - - - --
38,212
----- - - - - --
(38,212)
------ - - - - --
----- - - - - --
' $613,670
--- - - - - --
$642,230
----- - - - - --
($28,560)
$5,569,933
$4,990,325
$579,608
' 516,347
226,695
289,652
662,600
485,946
176,654
$1,130,017
----- - - - - --
$868,925
--- - - - - --
$261,092
----- - - - - --
$61232,533
----- - - - - --
$5,476,271
----- - - - - --
$756,262
------ - - - - --
(198, 327)
(153, 750)
44,577
(98, 300)
1,198,445
1,296,745
765,058
765,e58
-
3,907,439
3,907,439
-
' -- $566,731 -
$611,308-
- -- $44,577-
$3,809,139-
$5,105,884-
- $1,296,745-
' -17-
Exhibit 4
COMBINED STATEMENT OF REVENUES, EXPENSES, AND
CHANGES IN
'
RETAINED EARNINGS - ALL PROPRIETARY FUND TYPES
Year Ended December 31, 1987
Total
(Memorandum Only)
Internal
Enterprise
Service
19871986
OPERATING REVENUES:
----- - - - - --
--- - - - - --
--------------------
- --
Sales
$6,089,931
$169,422
$6,259,353
$5,79S,357
'
Cost of sales
- 3,109,599-
--- - - - - --
- 3,109,599
-
2,879,282
-
Gross Profit
$2,980,332
$ 169,422
$3,149,754
$2,919,075
'
OPERATING EXPENSES:
----- - - - - --
--- - - - - --
----- - - - - --
----- - - - - --
Personal services
$461,803
$89,647
$551,450
$528, 005
Other services and charges
248,680
38,746
287,426
358,162
'
Supplies
82,085
20,951
103,036
72,129
Source of supply /Disposal charges
1,437,039
----- - - - - --
--- - - - - --
1,437,039
----- - - - - --
1,317,079
----- - - - - --
'
Total
$2,229,607
-
$149, 344-
$2, 378, 951-
$2, 275, 375
-
OPERATING INCOME BEFORE DEPRECIATION $750,725
$20,078
$770,803
$643,700
'
DEPRECIATION
139,745-
5,168-
144,913
152,450
OPERATING INCOME
- --
$610,960
- --
$14,910
----- - - - - --
$625,890
----- - - - - --
$491,250
NONOPERATING REVENUES (EXPENSES)
Interest income
$247,229
$8,355
$255,584
$319,115
'
Other income (expense) - net
17,613
-----------
1,442
-- -- ; - - --
19,055
-----------
2,744
- - - - - -; - - --
Total
$264,642
$9,797
$274,639
$321,859
'
Net Income before transfers
----- - - - - --
$875,822
--- - - - - --
$24,707
----- - - - - --
$900,529
----- - - - - --
$813,109
Operating Transfers Out
383,827
8,580
392,407
651,816
'
Operating Transfers In
-_ -- 15,955
-
- -
15,955
- -- -
-
-
Net Transfers.
$367,872
$8,580
$376,452
$651,816
'
Net Income
----- - - - - --
$507,950
--- - - - - --
$16,127
----- - - - - --
$524,077
----- - - - - --
$161,293
TRANSFER DEPRECIATION ON CONTRIBUTED
ASSETS 65,229
-
65,229
65,229
'
Income Transferred to Retained
----- - - - - --
Earning $573,179
--- - - - - --
$16,127
----- - - - - --
$589,306
----- - - - - --
$226,522
- -
'
RETAINED,EARNINGS, BEGINNING OF YEAR
----- - - - - --
- 4,980,534-
--- - - - - --
- 111,681-
----- - - --
$5,092,215-
----- - - - - --
$4,865,693
RETAINED EARNINGS, END OF YEAR
$5,553,713
$127,808
$5,681,521
$5,092,215
'
-18-
COMBINED STATEMENT OF CHANGES IN FINANCIAL POSITION
ALL PROPRIETARY FUND TYPES
Year Ended December 31, 1987
SOURCES OF WORKING CAPITAL:
Operations:
Net income (loss)
Items not requiring (providing) working capital
Depreciation
Working Capital Provided by Operations
Decrease in long term contract receivable
Decrease in deferred receivable- reserve capacity
Total Sources of Working Capital
USES OF WORKING CAPITAL:
Additions to property and equipment -net
INCREASE IN WORKING CAPITAL
ELEMENTS OF INCREASE IN WORKING CAPITAL:
Cash
Accounts receivable
Inventory
Accounts payable
Due from /to other governmental units
Accrued liabilities
Net Increase in Working Capital
-19-
Internal
Enterprise Service
---- - - - - -- --- - - - - --
$507,950 $16,127
139,746 4,768
$647,696 $20,895
12,862 -
4,535 -
$665,093 $20,895
44,335
---- - - - - --
4,038
- - - - -��
$620,758
$16,857
$539,327
$22,847
(10,832)
40
87,168
(11,167)
(10,729)
9,094
17,078
-
(1, 254)
(3,957)
$620,758
$16,857
Exhibit 5
Total
(Memorandum Only)
1987 1986
-------------- - - - - --
$524,077 $161,293
144,514
150, 051.
$668,591
$311,344
12,862
12,367
4,535
5,108
$685,988
---- - - - - --
$328,819
---- - - - - --
48,373 17,773
---- - - - - -- ---- - - - - --
$637, 615 $311,046
$562,174
$419,008
(10, 792)
(36, 765)
76,001
10,121
(1,635)
(120, 159)
17, 078
(3,869)
(5,211)
---- - - - - --
42,710
---- - - - - --
$637,615
$311,046
-20-
Exhibit 6
HOUSING AND REDEVELOPMENT AUTHORITY OF COLUMBIA HEIGHTS
COMBINED STATEMENT OF REVENUES, EXPENDITURES
AND CHANGES IN FUND BALANCE - ALL GOVERNMENTAL FUND TYPES
Year Ended Decernber 31, 1987
Revenues:
Taxes
Rents
Cominunity development block grant
Housing and urban development
Obligation bond proceeds
Grant draw downs
Project reimbursement
Interest
Miscellaneous
Total Revenues
Expenditures:
Administration
94,610
Totals
$193,387
162,498
(Memorandum Only)
General
Special
-------------------
- - - - --
Fund
--- - - - - --
Revenue
----- -
1987
1986
$35, 891
- - - --
-
------- - - - - --
$35,891
----- - - - ---
$36,077
-
$171,167
171,167
$159,077
-
106,677
106,677
57,814
-
187,415
187,415
187,415
-
-
-
1,413,694
-
1,055,146
1,055,146
-
29,476
11,483
40,959
46,442
36,214
--- - - - - --
8,198
----- - - - - --
44,412
------- - - - --
76,326
$101,581
--- - - - - --
$1,540,086
----- - - - - --
-
$1,641,667
------- - - - - --
----- - - - - --
$1,976,845
----- - - - - --
Expenditures:
Administration
94,610
98,777
$193,387
162,498
'
Utilities, rnaintenance and operations
-
127,137
127,137
141,856
Loans and grants
-
18,107
18,107
22,582
Property acquisition /improvements
-
890,945
890,945
1,360,852
,
Relocation assistance
-
84,600
84,600
5,825
Legal
23
38,125
38,148
30
Interest
-
154,452
154,452
287,527
Development costs
-
20,190
20,190
73,307
'
Miscellaneous
-
85,965
85,965
33,308
Total Expenditures
- $94,633-
$1,518,298-
$1,612,931-
$2,087,785-
'
Other Sources and Uses;
--
Increase in note principal
-
-
-
24,649
'
Excess (deficiency) of Revenues and Other
Sources over Expenditures and Other Uses
$6,94S
$21,788
$28,736
($86,291)
Fund balance at beginning of year
1,454
356,202
357,656
443,947
Fund balance at end of year --
$8,402-
-- $377,990-
- - -- $386,392-
-- $357,656-
,
11
1- 11
NOTES TO FINANCIAL STATEMENTS
DECEMBER 31, 1987
Note 1 - Summary of Significant Accounting Policies
The City operates under a Home Rule Charter which prescribes the
council- manager form of government. The following services are provided:
public safety, highways and streets, sanitation, health and social
services, culture- recreation, public improvements, planning and zoning,
and general administrative services.
The financial statements included in the report cover all commissions,
boards, authorities, and bodies that are dependent on or controlled by the
City's executive and legislative branches. The criteria used to determine
the financial reporting entity are in conformance with NCGA Statement 3,
Defining the Governmental Reporting Entity and Statement 7, Financial
Reporting for Component Units within the Governmental Reporting Entity
The accounting policies of the City conform to generally accepted
accounting principles as applicable to governments. The following is a
summary of the more significant policies.
A. 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 in this report, into seven generic fund
types and two broad fund categories as follows:
Governmental Funds- -
General Fund - The General Fund is the primary 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 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. Special
assessment debt is now accounted.for in Debt Service Funds in
accordance with Statement No. 6 of the Government Accounting
Standards Board, Accounting and Financial Reporting for Special
Assessments. In previous years this debt was reported in special
assessment funds.
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.
-22-
NOTES TO FINANCIAL STATEMENTS (CONTINUED) '
DECEMBER 31, 19.87
Note 1 Summary of Significant Accounting Policies (Continued) '
A. FUND ACCOUNTING (Continued)
Proprietary Funds
Enterprise Funds - Enterprise Funds are used to account for
operations '
(a) 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;
or,
(b) where the governing body has decided that periodic
determination of revenues earned, expenses incurred, and /or net
income is appropriate for capital maintenance, public policy,
management control, accountability, or other purposes.
Internal Service Funds - Internal Service Funds are used to '
account for the financing of goods or services provided by one
department or agency to other departments or agencies of the '
City, on to other . governments, on a cost - reimbursement basis.
B. MEASUREMENT FOCUS
The accounting and reporting treatment applied to the fixed '
assets and long -term liabilities associated with a fund are
determined by its measurement focus. All governmental funds are '
accounted for on a spending or "financial flow" measurement
focus. This means that only current assets and current
liabilities are generally included in their balance sheets.
Their reported fund balance is considered a measure of "available '
spendable resources ". Governmental fund operating statements
present increases and decreases in net current assets.
Accordingly, they are said to present a summary of sources and
uses of "available spendable resources" during a period. '
Fixed assets used in governmental fund types operations (general
fixed assets) are accounted for in'the General Fixed Assets '
Account Group, rather than in governmental funds. Public domain
general fixed assets consisting of certain improvements other
than buildings, including roads, bridges, curbs and gutters,
streets and sidewalks, drainage systems, and lighting systems, '
are not capitalized with other general fixed assets.- No
depreciation has been provided on the general fixed assets.
-23- ,
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
' DECEMBER 31, 1987
Note 1 - Summary of Significant Accounting Policies (Continued)
' Fixed assets of proprietary funds are recorded therein in historical
cost. Depreciation is charged as an expense against operations and
accumulated depreciation is reported on proprietary fund balance
' sheets. Depreciation has been provided over the estimated useful
lives using the straight -line method. The estimated useful lives are
as follows:
' Building 40 to 50 years
Machinery and equipment 5 to 20 years
Structures 5 to 20 years
Mains & Lines 50 to 100 years
' Donated fixed assets are valued at the fair market value as of the
date received.
I
C. BASIS OF ACCOUNTING
All governmental funds are accounted for using the modified accrual
' basis of accounting. Revenues are recognized when they become
measurable and available. Substantially all sources of revenue are
accrued.
-24-
B. MEASUREMENT FOCUS (Continued)
Long term liabilities expected to be financed from governmental funds
are accounted for in the General Long -Term Debt Account Group, not in
'
the governmental funds.
The two account groups are not "funds ". They are concerned only with
the measurement of financial position. They are not involved with
measurement of results of operations.
Proprietary funds are accounted for on a cost of services or "capital
maintenance" measurement focus. This means that all assets and all
'
liabilities (whether current or non - current) 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 (revenues) and decreases (expenses) in net total assets.
' Fixed assets of proprietary funds are recorded therein in historical
cost. Depreciation is charged as an expense against operations and
accumulated depreciation is reported on proprietary fund balance
' sheets. Depreciation has been provided over the estimated useful
lives using the straight -line method. The estimated useful lives are
as follows:
' Building 40 to 50 years
Machinery and equipment 5 to 20 years
Structures 5 to 20 years
Mains & Lines 50 to 100 years
' Donated fixed assets are valued at the fair market value as of the
date received.
I
C. BASIS OF ACCOUNTING
All governmental funds are accounted for using the modified accrual
' basis of accounting. Revenues are recognized when they become
measurable and available. Substantially all sources of revenue are
accrued.
-24-
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
Note 1 - Summary of Significant Accounting_ Policies (Continued)
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 are recognized
when due.
All proprietary funds are accounted for using the accrual basis of
accounting. Revenues are recognized when they are earned, and expenses
are recognized when they are incurred.
D. BUDGETS AND BUDGETARY ACCOUNTING
The City follows these procedures in establishing the budgetary data
reflected in the financial statements.
(a) Prior to January 1, the budget is adopted by the City
Council.
(b) Formal budgetary integration is employed as a management
control device during the year for the General Fund and
Special Revenue Funds.
(c) Budgets for the General and Special Revenue Funds are adopted on
a basis consistent with generally accepted accounting
principles.
(d) Section 62 of the City Charter requires an annual budget.
Budget revisions are authorized by the City Council in
accordance with the City Charter at the request of the City
Manager.. The accompanying statements of revenue and expend-
itures compared with the budget estimates reflect these
revisions, if any. All appropriations lapse at the end of
the budget year to the extent that they have not been
expended or lawfully encumbered.
E. ASSETS AND LIABILITIES
Cash and Investments - Cash balances from all funds are pooled and
invested in allowable investments. Investment earnings are allocated
to the individual funds on the basis of average cash and investment
balances. Invested amounts for the city totaled $12,561,441 and
$10,293,923 at December 31, 1987 and 1986 respectively. Investments
for HRA totaled $102,126 and $96,822 at December 31, 1987 and 1986
respectively.
Cash in Escrow(s) - Cash in the amount of $8,863,500 has been placed
in escrow(s) with Marquette Bank for the purpose of refunding Tax
Increment Bonds of 1980 and Tax Increment Bonds of 1985 in 1990 and
1991 respectively.
Property Taxes - Property taxes are set by the City Council in October
each year, and are certified to Anoka County for collection in the
following year. Such taxes constitute a lien on the property on
January 1 of the year collectible.
-25-
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
Note 1 - Summary of Significant Accounting Policies (Continued)
E. ASSETS AND LIABILITIES (Continued)
The County provides tax settlement to the City three times a
year.
Allowances have been provided for property taxes receivable which
were not paid to the County by December 31.
Assessments receivable - Special assessments are levied against
the benefited properties for the assessable costs of special
assessment improvement projects in accordance with State
Statutes. The City usually adopts the assessment rolls when the
individual projects are complete or substantially complete. The
assessments are collectible over a term of years generally
consistent with the term of years of the related bond issue.
Collection of annual installments (including interest) is handled
by the City with only delinquent balances being certified to the
County. Property owners are allowed to prepay total future
installments without interest or prepayment penalties.
Special assessments receivable include the following components:
Unremitted - amounts collected by County but not remitted
to City at December 31.
Delinquent - amounts billed to property owners but not paid.
Deferred - assessment installments which will be billed to
property owners in future years.
Inventories - Inventories of the proprietary funds are stated at
the lower of FIFO cost (first -in, first -out) or market.
Deferred Revenues - Deferred revenues represent assessments of
one year or longer which will be billed to property owners as
each installment becomes due.
Accumulated Unpaid Vacation and Sick Pay - Accumulated vacation
and sick pay is recorded as a liability at the balance sheet date
in accordance with NCGA Statement No. 4 and City policy.
F. REVENUES AND EXPENDITURES
Certain grants received by the City require that eligible
expenditures be made in order to earn the grant. Revenue for
these grants is recorded in the period in which eligible
expenditures are made.
Utility service charges are recognized when earned. Unbilled
utility service charges are included in receivables at year -end.
Interest on bonded indebtedness is recorded as an expenditure
when paid in the governmental fund types.
-26-
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
G. COMPARATIVE DATA
Comparative data for the prior year have been presented to
provide an understanding of changes in the City's financial
position and operation.
H. 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 changes in
financial position in conformity with generally accepted
accounting principles. Neither are such data comparable to a
consolidation. Interfund eliminations have not been made in the
aggregation of these data.
Note 2 - Due from Other Governmental Units
General Fund
Anoka County - Street Maintenance 18,060
- Court Fines 9,827 27,887
Special Revenue Funds
Para Transit
3,489
3,489
Capital Projects Funds
State - State Aid
9,700
9,700
Enterprise Funds
Sever Fund - MWCC
1
Refuse Fund - Anoka County
17,078
17,079
HRA
Department of Housing and Urban
Development
562,244
Anoka County
22,076
City of Columbia Heights
2,594
Minnesota Housing Finance Agency
14,850
Metro Council
7,418
609.182
$667,337
xxxxaxx
-27-
' NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
' Note 3 - Proprietary Funds Contract Receivable and Deferred Receivable
A. INTERCEPTOR ACQUISITION CONTRACT RECEIVABLE .
' As of January 1, 1971, the Metropolitan Waste Control Commission
(M.W.C.C.) assumed ownership of all existing interceptors and
treatment works. Under the terms of the agreement with M.W.C.C.,
' the City is to be reimbursed for the value at the time of
transfer of such facilities.
' The contract represents the value of the facilities acquired by
the M.W.C.C. and was determined to be $400,533 at the date of
takeover by the M.W.C.C. This amount is being amortized through
credits received against annual sewer service billings from the
' M.W.C.C. over a thirty -year period with interest at 4X.
Prior to 1987, the City received credits against M.W.C.C.
' billings totaling $356,352, of which $165,272 was treated as a
reduction of principal. During 1987, the City received a credit
of $22,272, of which $12,862 was a reduction of principal. As of
December 31, 1987, a balance of $222,399 remained to be collected
E over the next thirteen years.
B. DEFERRED RECEIVABLE
' The City was required to advance funds to the M.W.C.C. for
deferments of reserve capacity costs granted to other
communities. The balance of this receivable from the M.W.C.C. at
December 31, 1987 was $14,176 and is collectible over the next
seven years. During 1987, the City received $4,789 related to
this receivable, of which $4,535 represented a reduction of
principal.
' Note 4 - Interfund Receivable and Payable Balances
Receivable Payable
' HRA General Fund $ 2,515 $ 21,389
HRA Special Revenue Funds
Downtown Development Fund 48,765
Low Income Housing Fund 1,088 -
' Anoka County Community Development
Block Grant Fund 30,979
$ 52,368 $ 52,368
sassasasas a�sas :ss
-28-
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
Note 5 - Changes in General Fixed Assets
Changes in General Fixed Assets Account Group during 1987 were as follows:
Note 6 - HRA Property and Equipment
Balance Adjustments &
Jan 1,1987 Additions Retirements
Land $ 69,688 $ - $
Building 2,243,019 22,354 -
Equipment 274,665 - -
$2,587,372 $ 22,354 $ -
aaaaaaasaa aaaasasasa aaaaaaaaaaaa
Note 7 - Proprietary Fund Types Property and Equipment
Balances
Dec 31.1987
$ 69,688
2,265,373
274.665
$2,609,726
aassasasass
A summary of the enterprise funds property and equipment at December 31, 1987
follows:
Water
Adjustments
Balance
Liquor Utility
and
Balance
Total
Jan 1, 1987
Additions
Retirements
Dec. 31, 1987
Land
$3,028,500
$ -
80,783
$3,028,500
Bldgs.& Structures
3,'499,864
27,360
Improvments Other than
3,527,224
Furniture, Fixtures
Buildings
& Office Equip.
821,765
55,653
4,094
873,324
Machinery & Equip.
1,459,070
195,675
30,631
1,624,114
TOTAL
$8,809,199
saasaaasa
$278,688
sssaaaaas
$34,725
sasasaaa
$9,053,162
assssassaa
Note 6 - HRA Property and Equipment
Balance Adjustments &
Jan 1,1987 Additions Retirements
Land $ 69,688 $ - $
Building 2,243,019 22,354 -
Equipment 274,665 - -
$2,587,372 $ 22,354 $ -
aaaaaaasaa aaaasasasa aaaaaaaaaaaa
Note 7 - Proprietary Fund Types Property and Equipment
Balances
Dec 31.1987
$ 69,688
2,265,373
274.665
$2,609,726
aassasasass
A summary of the enterprise funds property and equipment at December 31, 1987
follows:
Garage
Buildings & Improvements $ 25,027
Office Furniture & Equipment 741
Machinery & Equipment 77,097
$102,865
Less Accumulated Depreciation 75,745
$ 27,120
saaaasss
-29-
Water
Sewer
Liquor Utility
Utility
Refuse
Total
Land
$ 7,125
$ 45,223
$ 36,586
$ -
$ 88,934
Buildings
80,783
212,924
26,245
319,952
Improvments Other than
Buildings
103,859
2,229,619
2,475,155
2,890
4,811,523
Office Furniture & Equi.
24,522
3,722
3,414
-
31,658
Machinery & Equipment
149,421
123,467
226,218
175
499,281
Less Accumulated Depr.
147,997
1,250,700
1,432,723
99
2,831,519
$
axaaaaaass
217,713
$1,364,255
aaaaaaamsa
$1,334,895
aaaasaasaa
$ 2,966
aasaaas
$2,919,829
A summary of the Internal
Service
Funds, property and equipment at
sax :sa :sax
December 31,
1987 follows:
Central
Garage
Buildings & Improvements $ 25,027
Office Furniture & Equipment 741
Machinery & Equipment 77,097
$102,865
Less Accumulated Depreciation 75,745
$ 27,120
saaaasss
-29-
' NOTES TO FINANCIAL STATEMENTS (Continued)
DECEMBER 31, 1987
' Note 8 - Long -Term Debt
Changes in long -term debt during the year ended December 31, 1987 are
' summarized below (in 0001x)
Balance Balance
Jan 1,1987 Issued Retired December 31,1987
' Tax Increment Bonds $ 11,045 $ 10,190 $ 335 $ 20,900
Special Assessment 2,390 2,230 2,390 2,230
Total $ 13,435 $ 12,420 $ 2,725 $ 23,130
' - ---- ---- -- sssssss - assess s-- samsss --
Bonds payable at December 31, 1987 are comprised of the following issues.
' Tax Increment Bonds --
Refunded --
' Tax Increment Bonds of 1980, 8.0 2- 8.75x, Payable in
Varying Annual Amounts to 2002 in 1990 $7,825,000
General Obligation Tax Increment Bonds of 1985,
Series A, payable
in varying annual amounts to 2002,
callable in 1991
2,000,000
9,825,000
' General Obligation
Tax Increment Bonds of 1984, 7.0 -9.4X,
payable in varying annual amounts, 1986 to 1994
885,000
General Obligation
Tax Increment Refunding Bonds of
'
1987, Series A, payable in varying annual amounts,
1991 to 2002
9,090,000
' General Obligation
Tax Increment Taxable Bonds of
1987, Series A, payable in varying annual amounts,
1991 to 1997
1,100,000
' Public Improvement
Refunding Bonds of 1987, Series A,
payable in varying
annual amounts, 1988 to 1995
2,230,000
23,130,000
aaaaaa
'
The annual requirements in thousands
of dollars to amortize all
sass
bonded debt
outstanding at December 31,
1987, including interest payments of
$9,874,557
are as follows in (000's)
'
Year Ending
December 31,
Total
1988
2,371
'
1989
2,394
1990
9,331
1991 -95
11,453
'
1996 -99
5,260
2000 -02
2,196
33,005
' -30-
NOTES TO FINANCIAL STATEMENTS (Continued)
DECEMBER 31, 1987
Note 8 - Long - Term Debt (Continued)
These figures include refunding payments of $6,925,006 in 1990 for Tax
Increment Bonds of 1980 and $1,800,000 in 1991 for Tax Increment Bonds of 1985
to be paid in full from an escrow account managed by Marquette Bank Trust
Services. Until the crossover refunding dates, interest payments for Tax
Increment Refunding Bonds of 1987 will be paid from interest income generated
by the escrow account.
$13,141,901 is available in Debt Service Funds to service the general
obligation and tax increment bonds. There are a number of limitations and
restrictions contained in the various bond indentures. The City is in
compliance with all significant limitations and restrictions.
The Tax Increment Bonds are payable from the amount of increase in the property
taxes on the property in the Tax Increment District. The Special Assessment
Bonds are payable primarily from special assessments. Any deficiencies in
revenue from these sources will be provided by general property taxes.
Note 9 - Long Term Debt - Other
The City of Columbia Heights is the administrating authority for the following
tax increment finance districts:
1. 1977 Downtown CBD Revitalization Plan A3
Type of district: Redevelopment
Authorizing Law: HRA (MN. Stats. & 462.545 and Mn. Stats. &
462.585) '
Duration of District: August 1, 2009
Original assessed value: 2,212,911
Current assessed value: 12,746,900 '
Captured assessed value: 10,533,989
Total captured value retained: 10,533,989
Total bonds issued in 1987: -0- '
Total loans incurred: -0-
2. 1984 Modification to the Downtown CBD Revitalization Plan C7 '
Type of district: Redevelopment
Authorizing law: HRA (Mn. Stats. & 462.545 and Mn.Stats. & '
462.585)
Duration of district: August 1, 2009
Original assessed value: 270,529 '
Current assessed value: 435,935
Captured assessed value: 165,406
Total captured value retained: 165,406 '
Total bonds issued in 1987: -0-
Total loans incurred: -0-
-31- 1
' NOTES TO THE FINANCIAL STATEMENTS
DECEMBER 31, 1987
' Note 9 -.Long -Term Debt - Other (Continued)
3. 1984 University Avenue Redevelopment C8
' Type of district: Redevelopment
Authorizing law: HRA (Mn. Stats. & 462.545
and Mn.
Stats.
462.585)
' Duration of district: August 1, 2009
Original assessed value:
252,797
Current assessed value:
1,644,289
'
Captured assessed value:
1,391,492
Total captured value retained:
1,391,492
Total bonds issued in 1987:
-0-
'
Total loans incurred:
-0-
4.. 1987 Sullivan Lake Development H2
'
Type of district: Economic
Authorizing law: HRA (Mn. Stats. & 462.545
and Mn.
Stats.
' & 462.585)
Original assessed value:
407,065
Current assessed value:
402,746
' Captured assessed value:
-0-
Total captured value received:
-0-
Total bonds issued in 1987:.
1,100,000
'
Total loans incurred:
-0-
All tax increment districts are pooled into
one fund.
Note 10 - Reserved -Fund Equity
The following reservations of fund equity have been made as
of December 31,
1987
Debt Service Funds
1987
Debt Service
$13,141,901
HRA
'
Reserved for Community Development
$
654,820
Reserved for Future Operations
$
105,906
General Fund
'
Reserved for Insurance
189,292
Reserved for Encumbrances
195,662
Special Revenue Funds
Cable Television
10,000
'
Capital Projects Funds
Capital Projects
780
Enterprise Funds
' Liquor
40,000
Water
4,659
Sewer
3,649
Refuse
2,000
'
Internal Service
Central Garage
99
' -32-
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
Note 11 - Segment Information - Enterprise Funds
The City maintains four enterprise funds. Segment information for the year
ended December 31, 1987 is as follows:
Water Sewer Refuse
Liquor Utility Utility Utility Total
Sales, less cost of sales
of $3,109,599
Operating Revenue
Depreciation
Depreciation Transferred to
Contributions
Operating Income
Operating Transfers Out
Net Income
Property & Equip.- Additions
Net Working Capital
Total Assets
Total Equity- Contributed
Total Equity - Retained
Earnings
Note 12 - Retirement Plans
$ 638,649 $
25,464
220,460
(240,808)
( 48,898)
- $ - $ - $ 638,649
888,545 827,512 625,626 2,341,683
50,379 63,803 99 139,745
(26,294)
115,788
(39,373)
117,065
(38,935)
186,955
(29,852)
312,049
1,065,898 837,150 2,289,793
1,544,618 2,256,485 3,873,502
- 988,278 901,747
1,283,611 1,213,127 2,959,516
(65,229)
87,777 610,980
(73,794) (383,827)
29,938 507,950
94,493 4,534,547
120,575 7,795,180
- 1,890,025
97,459 5,553,804
The Columbia Heights Police Relief Association provides a pension plan for all
sworn police officers hired prior to June 15, 1972. The Columbia Heights Fire
Department Relief Association provides a pension plan for all regular fire
fighters hired prior to December 31, 1974 and all volunteer firefighters. All
public safety employees hired after aforementioned dates, under Minnesota
Statutes, Chapter 374, are covered by Public Employees, Police and Fire Fund (a
special fund of the Public Employees Retirement Association - P.E.R.A.). By
agreement, the Fire Relief Association was split into two divisions - paid and
volunteers as of January 1, 1978.
The City levies annually and applies state aid for pension contributions to the
associations. In 1987 the amounts were:
Levy
State -Aid
Total
Police Relief $ 62,193
$ 97,799
$ 159,992
'
Fire Relief - Paid 53,945
59,987
113, 9
Fire Relief - Volunteer 14,110
-
14,110
$130,248
$157,786
$ 288,034
,
1
-33-
' NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
' Note 12 - Retirement Plans (Continued)
The pension levy meets the minimum requirements of the Police and Firemen's
Relief Association Guidelines Act of 1969, which became effective July 1, 1971,
' and which required that contributions shall cover the normal cost plus interest
at 5Z of the unfunded liability. In accordance with the Police and Firemen's
Relief Associations Guidelines Act of 1969 as amended by Laws of Minnesota
1918, Chapter.563, the annual levy includes an amount for the amortization of
' the unfunded pension liability by the year 2005.
The following schedule of accrued liabilities was obtained from the latest
' actuarial surveys dated December 31, 1987.
Accrued Actuarial Accrued Funded (Unfunded)
Assets Liability Accrued Liability
' Police Relief $ 2,139,117 $ 3,831,372 $ (1,692,255)
Fire Relief -Paid 1,108,670 2,629,867 (1,521,197)
Fire Relief - Volunteer 660,434 388,081 272,353
(Dated December 31, 1986)
' Columbia Heights Police Relief Association
Benefit Provisions
' Age & Service Retirement- -
Eligibility-- 20 years of service and 50 years of age.
Amount -- For first 20 years of service, 35/80 of base pay at retirement.
For each year in excess of 20, an additional 1/80 is added up to a maximum of
' 40/80 of base pay for 25 or more years of service. In addition, and not
subject to the above maximum, for each year over 25, a benefit of 1/2 Z of base
,pay is added to the benefit. (The additional benefit is not subject to the
post- retirement adjustment provisions.)
Pay Used for Plan Purposes -- "Base pay" means the salary of a top
patrolman. . _
Disability Requirement--
' Eligibility -- Disabled to the extent that unable to perform duties of
patrolman before being eligible for age & service retirement.
Amount- -35/80 of salary at time of disability
Members Death While Active, Or In Deferred Status, or Retired- -
Eligibility--
Spouse-- Legally married to member at separation from service and residing
' with member at time of death. Benefits terminate upon remarriage
Child -- Younger than age 18
Amount --
' Spouse - -2/3 of amount member was receiving or would have received.
Minimum benefit based on 20 years of service and base pay.
Child- $600 per year per child.
Maximum Family Benefit -- Amount member was receiving or would have been
' receiving.
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
Note 12 - Retirement Plans (Continued)
Vested Deferred - -20 years of service and separated before age 50. Payment
beginning is deferred to attainment of age 50.
Post Retirement Adjustments ( "Escalator "). Each time base pay is changed
payments to age & service and surviving spouse benefit recipients are
changed by the same percent that base pay changes. Disibility benefits
are changed by the percent change in the salary of an active patrolman
holding the rank that the disabled member held at athe time of the
disability. Children's benefits are not escalated.
Member Contributions--8X of base pay. Total contributions are refundable,
without interest, if no benefit is payable upon separation from service.
When member has 25 years of service, contributions cease.
Pension Benefit Obligation
The amount shown below as the "pension benefit obligation" is a standardized
disclosure measure of -the present value of pension benefits; adjusted for the
effects of projected salary increases, estimated to be payable in the future as
a result of employee service to date. The measure is the actuarial present
value of credited-projected benefits and is intended to (i) help users assess
the plan's funding status on a going- concern basis, (ii) assess progress being
made in accumulating sufficient asssets to pay benefits when due, and (iii)
allow for comparisons among public employee retirement.plans. The measure is
independent of the actuarial funding method used to determine contributions to
the plan.
The pension benefit obligation was determined as part of an actuarial valuation
of the plan as of December 31, 1987. Significant actuarial assumptions used in
determining the pension benefit obligation include (a) a rate of return on the
investment of present and future assets of S.OX per year compounded annually,
(b) projected salary increases of 3.5X per year compounded annually,
attributable to inflation, and (c) the assumption that benefits will increase
3.5X per year after retirement.
At December 31, 1987, the unfunded pension benefit obligation was $1,635,540,
determined as follows:
Pension Benefit Obligation:
Retirees and beneficiaries currently receiving benefits
and terminated employees not yet receiving benefits $2,733,900
Current employees --
Accumulated employee contributions including
allocated investment income 134,505
Employer financed 896,875
Total Pension Obligation $3,765,280
Net assets available for benefits, at cost
(market value was $2,157,871)
Unfunded Pension Benefit Obligation
2,129,740 '
$1,635,540
The total pension benefit obligation as of January 1, 1987 was $3,648,804. I
During the year, the plan experienced a net change of $116,476 in the pension
benefit obligation
-35- 1
' NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
' Note 12 - Retirement Plans (Continued)
Contributions Required and Contributions Made.
The Association's funding policy provides for periodic employer contributions
at actuarially determined rates that, expressed as percentages of annual
covered payroll, are designed to accumulate sufficient assets to pay benefits
' when due. The normal cost and actuarial accrued liability are determined using
an entry age actuarial funding method. Unfunded actuarial accrued liabilities
are being amoratized as a level dollar amount over a period of 22 years.
' During the year ended December 31, 1987, contributions totaling $171,817 --
$159,992 employer.-and $11,825 employee -- were made in accordance with
contribution requirements determined by an actuarial valuation of the plan as
' of December 31, 1985. The employer contributions consisted of $33,247 for
normal cost and $126,745 for amortization of the unfunded actuarial accrued
liability. Employer contributions represented 104.572 of covered payroll.
' Significant actuarial assumptions used to compute contribution requirements
were the same as those used to compute the standardized.measure of the pension
benefit obligation.
' Computed Contribution Comparative Schedule
Contribution Rates
' Fiscal Valuation Normal Cost Dollar Cont.
Year Date 2 of Valuation UAAL ' Valuation For Fiscal Year
December 31 December 31 Payroll Dollars Payroll Computed Actual
' 1987 1985 21.732 $127,007 $153,000 $160,254 $159,992
1988 1986 22.73 125,356 159,840 161,688
1989 1987 23.73 125,451 166,260 164,904
' Required Supplementary Information
Analysis of Funding Progress
(2) (6)
(1) Pension (3) (4) (5) Unfunded PBO
Valuation Net Assets Benefit Percent Unfunded Annual as a Percentage
Date Available Obligation Funded PBO Covered of Covered Payroll
Dec.31 for Benefits (PBO) (1)/(2) (2) -(1) Payroll (4)/(5)
' 1987 $ 2,129,770 $3,765,280 56.62 $1,635,540 $166,260 983.72
1
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
Note 12 - Retirement Plans (Continued)
Analysis of the dollar amounts of net assets available for benefits, pension
benefit obligation, and unfunded pension benefit obligation in isolation can be
misleading. Expressing the net assets available for benefits as a percentage
of the pension benefit obligation provides one indication of the plan's funded
status on a going- concern basis. Analysis of this percentage over time
indicates whether the system is becoming financially stronger or weaker.
Generally, the greater this percentage, the stronger the plan. The unfunded
pension benefit obligation and annual covered payroll are both affected by
inflation. Expressing the unfunded pension benefit obligation as a percentage
of annual covered payroll approximately adjusts for the effects of inflation
and aids analysis of the progress being made in accumulating sufficient assets
to pay benefits when due. Generally, the smaller this percentage, the stronger
the plan.
Columbia Heights Fire Department Relief Association (Paid Division)
Benefit Provisions
Age & Service Retirement- -
Eligibility - -20 years of service and 50 years of age
Amount -- For first 20 years of service, 35/80 of base pay. For each year
in excess of 20, an addit znal 1 /80 is added up to a maximum of 45/80
of base pay for 30 or more years of service. In addition, and not subject
to the above maximum, for each year over 25, a benefit of 1 /2X of base pay
is added to the benefit. (The additional benefit is not subject to the
post retirement adjustment provisions.)
Pay Used for Plan Purposes -- "Base pay" means the salary of a first grade
fireman.
Disability Retirement- -
Eligibility-- Disabled to the extent that no longer able to perform the
duties of a fireman before being eligible for age & service retirement.
Amount- -
(1) Less than 10 years service -30/80 of base pay
(2) 10 to 15 years service -35/80 of base pay
(3) 15 or more years service -40/80 of base pay to age 50 at which time
the benefit is recomputed based on service assuming a minumum of 20
years of service.
Members Death While Active, Or In Deferred Status, or Retired
Eligibility- -
Spouse-- Legally married to member at least 1 year before separation
from service and residing with member at time of death.
Benefits terminate upon remarriage.
Child -- Younger than age 18, or 22 if full time student.
Amount- -
Spouse- -32/80 of base pay
Child -- 4/80 of base pay per child. Children's maximum is 8/80 of
base pay if spouse is receiving or 12/80 of base pay if no
spouse is receiving.
Vested Deferred - -20 years of service and separated before age 50. Payment
beginning is deferred to attainment of age 50.
-37-
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
Note 12 - Retirement Plans (Continued)
Post - Retirement Adustments ( "Escalator ") -Each time base pay is changed,
payments to all benefit recipients are simultaneously changed by the same
percent that base pay is changed.
Member Contributions - -81 of base pay. Total member contributions are
refundable, without interest, upon separation from service if no monthly
benefit is payable.
Pension Benefit Obligation
The amount shown below as the "pension benefit obligation" is a standardized
disclosure measure of the present value of pension benefits, adjusted for the
effects of projected salary increases, estimated to be payable in the future as
a result of employee service to date. The measure is the actuarial present
value of credited projected benefits and is intended to (i) help users assess
the plan's funding status on a going - concern basis, (ii) assess progress being
made in accumulating sufficient assets to pay benefits when due, and (iii)
allow for comparisons among public employee retirement plans. The measure is
independent of the actuarial funding method used to determine contributions to
the plan.
The pension benefit obligation was determined as part of an actuarial valuation
of the plan as of December 31, 1987. Significant actuarial assumptions used in
determining the pension benefit obligation include (a) a rate of return on the
investment of present and future assets of S.OI per year compounded annually,
(b) projected salary increases of 3.5I per year compounded annually,
attributable to inflation, and (c) the assumption that benefits will increase
3.5I per year after retirement.
At December 31, 1987m the unfunded pension benefit obligation was
determined as follows:
Pension Benefit Obligation:
Retirees and beneficiaries currently receiving benefits
and terminated employees not yet receiving benefits
Current employees- -
Accumulated employee contributions including
allocated investment income
Employer financed
Total Pension Benefit Obligation
Net assets available for benefits, at cost
(market value was $1,119,206)
Unfunded Pension Benefit Obligation
The total pension benefit obligation as of January 1,
$1,512,348,
$2,430,504
25,400
159,846
$2,615,750
1,103,402
$1,512,348
1987 was $2,573,278.
During the year the plan experienced a net change of $42,472 in pension benefit
obligation.
-38-
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
Note 12 - Retirement Plans (Continued)
Contributions Required and Contributions Made
The Associations's funding policy providesfor periodic employer contributions
at actuarially determined rates that, expressed as percentages of annual
covered payroll, are designed to accumulate sufficient assets to pay benefits
when due. The normal cost and actuarial accrued liability are determined using
an entry age actuarial funding method. Unfunded actuarial accrued liabilities
are being amortized as a level dollar amount over a period of 22 years.
During the year ended December 31, 1987 contributions totaling $114,250 --
$111,952 employer and $2,298 employee -- were made in accordance with
contribution requirements determined by an actuarial valuation of the plan as
of December 31,1985. The employer contributions consisted of $6,298 for normal
cost and $105,654 for amortization of the unfunded actuarial accrued liability.
Employer contributions represented 404.77X of covered payroll.
Significant actuarial assumptions used to compute contribution requirements
were the same as those used to compute the standardized measure of the pension
benefit obligation.
Computed Contribution Comparative Schedule
Cl
[J
Contribution Rates
Fiscal
Valuation
Normal Cost
Dollar Contribution
Year
Date x
of Valuation UAAL Valuation
For Fiscal Year
'
Dec.31
Dec. 31
Payroll Dollars Payroll
Computed Actual .
1987
1985
22.77x $106,347 $27,658
$112,645 $111,952
'
1988
1986
22.77 111,449 29,916
118,261
1989
1987
22.78 112,770 31,113
119,858
Required Supplementary Information
,
Analysis of Funding Progress
(2)
(6)
(1)
Pension (3) (4) (5)
Unfunded PBO
'
Valuation
Net Assets
Benefit Percent Unfunded Annual
as a Percentage
Date
Available Obligation Funded PBO Covered
of a Covered Payroll
Dec 31.
for Benefits
(PBO) (1)/(2) (2) -(1) Payroll
(4)/(5)
1987
$1,103,402
$2,615,750 42.2X $1,512,348 $31,113 4,860.8 Z
Cl
[J
I NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
' Note 12- Retirement Plans (Continued)
Analysis of the dollar amounts of net assets available for benefits, pension
benefit obligation, and unfunded pension benefit obligation in isolation can be
' misleading. Expressing the net assets available for benefits as a percentage
of the pension benefit obligation provides one indication of the plan's funded
status on a going- concern basis. Analysis of this percentage over time
' indicates whether the system is becoming financially stronger or weaker.
Generally, the greater this percentage, the stronger the plan. The unfunded
pension benefit obligation and annual covered payroll are both affected by
inflation. Expressing the unfunded pension benefit obligation as a percentage
' of annual covered payroll approximately adjusts for the effects of inflation
and aids analysis of the progress being made in accumulating sufficient assets
to pay benefits when due. Generally, the smaller this percentage, the stronger
' the plan.
Columbia Heights Fire Department Relief Association (Volunteer Division)
Benefit Provisions
Age & Service Retirement- -
Eligibility--20 Years ofservice and 50 years of age
' Amount -- For first 20 years of service, $2,472 per year. For each year in
excess of 20, an additional $48 per year is added up to a mazimum of $2,952
per year for 30 or more years of service. Member may elect to receive an
optional lump sum benefit of $12,000 rather than monthly benefits.
' Disability Retirement—
Eligiblilty -- Disabled to the extent that no longer able to perform services
required of a firefighter before being eligible for age & service
- retirement. If duty related, there is no service requirement. If non -duty
related, member must have at least 10 years of service to qualify.
Amount - -(1) Duty Related. Same as regular retirement assuming a minmum
' of 20 years of service.
(2) Non Duty Related. For 10 years of service, $744 per year.
For each year in excess of 10, an additional $96 per year is
added up to a maximum of $1,704 per year. Non -duty benefit
' payments do not begin until member reaches age 50.
Death Benefits
' Eligibility- -
Spouse-- Legally married to member while active and at least 3 years
prior to death and residing with member at time of death.
Child -- Younger than 16 or, if full time student, younger than 18.
1
-40-
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
Note 12 - Retirement Plans (Continued)
Amount- 1. If Death Occurs After 20 Years Service as Volunteer
Spouse - -. $996 per year for first 20 years service.
For each year in excess of 20, an additional $24 per year to
a maximum of $1,236 per year for 30 or more years of service
Child -$120 per year per child with $240 maximum per year.
Spouse and child benefits are not payable until such time
as member would have reached age 50 hada the member survived.
2. If Death Occurs Prior to Completion of 20 Years Service But
After 10 Years Service and Death is Not Duty Related.
Spouse -Lump sum payment of $1,650 for first 10 years service
plus $220 for each full year in excess of 10 but less than
16 plus $275 for each full year in excess of 15.
Child.(maximum of 2) -Lump sum payment of $206 for first 10
years service plus graded increases for,each full year in
excess of 10 to a maximum of $481 for 20 years of service.
3. If Death is Duty Related.
Spouse and Child- Sameas benefit under 1. except that (i)
benefits are payable immediately and (ii) if member was younger
than 50, benefits are based on 20 years service regardless
of amount of actual service. At the time the member would
have reached age 50, the benefit is recomputed to give credit
for any actual service over 20 years.
Lump Sum Payment of $1,375 is paid to the surviving spouse or
nearest living relative in additon to the benefits listed above.
Vested Deferred -
10 But Less Than 20 Years Service -
Lump sum payment of $6,000 for first 10 years plus $600 per year
for each full year in excess of 10. Payment is deferred to age
50 and termination of service must have resulted from
circumstances beyond the member's control.
More Than 20 Years Service and Separated Before Age 50.
Benefit amount is same as age & service benefit and payment
beginning is deferred to attainment of age 50.
Member Contributions -None.
Pension Benefit Obligation
Amount shown below as the "pension benefit obligation" is a standardized
disclosure measure of the present value of pension benefits, adjusted for the
effects of projected salary increases, estimated to be payable in the future as
a result of employee service to date. The measure is the actuarial present
value of credited projected benefits and is intended to (i) help users assess
the plan's funding status on a going - concern basis, (ii) assess progress being
made in accumulating sufficient assets to pay benefits when due, and (iii)
allow for comparisons among public employee retirement plans. The measure is
independent of the acturial funding method used to determine contributions to
the plan.
-41-
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
Note 12 - Retirement Plans (Continued)
The pension benefit obligation was determined as part of an actuarial valuation
of the plan as of December 31, 1986. Significant actuarial assumptions used in
determining the pension benefit obligation include (a) a rate of return on the
investment of present and future assets of S.OX per year compounded annually,
and (b) the assumption that benefits will not increase after retirement.
At December 31, 1986, the assets in excess of the pension benefit
were $280,733, determined as follows:
Pension Benefit Obligation:
Retirees and beneficiaries currently receiving benefits
and terminated employees not yet receiving benefits
Current employees --
Accumulated employee contributions including allocated
investment income
Employer financed
Total Pension Benefit Obligation
Net assets available for benefits, at cost
(market value was $691,128)
Assets in excess of the Pension Benefit Obligation
Public Employee's Retirement Association
A.. Plan Description
obligation
$271,836
0
92,518
$364,354
645,087
$280,733
All full -time and certain part -time employees of the City of Columbia Heights
are covered by defined benefit pension plans administered by the Public
Employees Retirement Association of Minnesota (PERA). The PERA administers the
Public Employees Retirement Fund and the Public Employees Police and Fire Fund
' which are cost - sharing multiple - employer public employee retirement systems.
The payroll for employees covered by PERA plans for the year ended December 31,
1987 was $2,610,251; the City's total payroll was $3,171,298.
All full -time employees and certain part -time employees are eligible to
participate in the PERA plans. Public Employees Retirement Fund members belong
to either the Coordinated Fund or the Basic Fund. Coordinated members are
covered by Social Security and Basic members are not. All police officers,
fire fighters and peace officers who qualify for membership by statute are
covered by the Police and Fire Fund. The PERA plans provide pension benefits,
deferred annuity, and death and disability benefits. Benefits are established
by State statute.
-42-
H
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
,
DECEMBER 31, 1987
Note 12-
Retirement Plans (Continued)
'
Retirement
benefits for members of the Basic and Coordinated Funds are as
follows:
(a)
When age plus years of service equal 90, the full unreduced normal
'
annuity is payable.
(b)
When age plus years of service equal 85, the full unreduced normal
annuity is payable. Minimum age is 55. To retire under the Rule of
'
85, a member must qualify by December 31, 1986, and must retire by
June 30, 1987.
(c)
As early as age 55 with at least 5 years of paid service credit;
annuity reduced 1 /4X for each month under age 65.
'
(d)
Any age with at least 30 years, reduced by 1 /4I for each month under
age 62.
(e)
Age 65 or older with at least one but less than 5 years of paid
service credit (proportionate annuity). Must terminate service at
,
age 65 or older.
(f)
At 55 with at least 5 years of paid service credit or any age with
at least 30 years representing PERA service combined with other fund
'
coverage.
Retirement
benefits for members of the Police and Fire Funds are as follows:
(a)
When age plus years of service equal 90, the full unreduced normal
'
annuity is payable.
(b)
Age 55 or older with at least 5 years service credit.
(c)
Age 55 or older with at least 5 years paid service credit
'
representing PERA service combined with other fund coverage.
(d)
Age 65 or older with at least 5 years of paid service at age 65
or older.
Pension
provisions include a deferred annuity. A member who terminates public
'
service
with 5 or more years of credited allowable service may leave his or her
amount in the fund to qualify for an annuity at retirement age. The annuity as
determined
under the formula will be increased from the first of the month
'
following
date of termination at prescribed interest rates. The former member
may accept
a refund at any time prior to the date retirement annuity begins.
Pension
provisions include death and disability benefits. whereby the disabled
,
employee
or surviving spouse is entitled to receive amounts determined as
follows:
Survivor
(Death) Benefits:
'
(1)
Death of member or former member before retirement and no survivor
benefits payable. Designated beneficiary is entitled to a refund of
the decendent's balance with interest compounded annually. If no
designated beneficiary survives, refund is due the surviving spouse;
,
or, if none, the legal representative of the estate of the deceased.
(2)
Death of member before retirement or upon death of disabled member
receiving disability benefits.
'
H
' NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
Note 12 - Retirement Plans (Continued)
Basic Member:
Surviving spouse will receive 501 of member's average salary over the last six
' full months of service preceding death, for life or until remarriage. Each
dependent child, 101 of the above salary. Family maximum is $1,000 per month.
' Coordinated member:
No surviving spouse benefits are provided. These benefits are provided under
the Social Security Act.
' Police and Fire Member:
Surviving spouse will receive 301 of member's average salary over last six full
months of service preceding death, for life or until remarriage. Each
dependent child, 101 of the above salary. Family maximum is 501 of salary over
last six full months worked.
Surviving spouse optional annuity, death of retired annuitant, deceased member
with no children, death of "old law" retiree, and death of retiree who is
receiving optional annuity provisions are also provided for.
Disability Benefits:
Basic Members: Disability benefit is equal to a the normal annuity payable to
a member who has reached age 65 with the same number of years of allowable
service and the same average salary, plus a monthly supplement, depending'upon
age when disabled. If death occurs before age 65, surviving spouse would
receive a benefit amounting to 501 of average salary over the last six full
months.disabilitant was employed in public service and each dependent child
would recieve 101 of such average salary, but the maximum family benefit is
limited to $1,000 per month.
Coordinated Members:
Disability benefit is equal to the normal annuity payable to a member who has
reached age 65 with the same number of years of allowable service and same
average salary. If death occurs before age 65, a refund of any balance in
account would be paid to designated beneficiary. No survivor benefits payable.
' Police and Fire Members:
The disability benefit is based on the same formula as for a normal annuity,
payable at age 55. Additional provisions relate to whether the disability was
' sustained in the line of duty or not. If death occurs before age 55, a
surviving spouse would receive a benefit amounting to 301 of average salary
over the last six full months, disabilant was employed in public service and
each dependent child would receive 101 of such average salary, but maximum
' family benefit is limited to 501 of the average salary. Certain optional
payments are also available.
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
Note 12 - Retirement Plans (Continued)
B. Contributions Required and Made
Covered employees are required by State Statute to contribute fixed
percentages of their gross earnings to the pension plans. The city makes
annual contributions to a the pension plans equal to the amount required by
State Statutes. Current contribution rates for the plans are as follows:
Additional
Total contributions made during fiscal year 1987 amounted to $325,937 of which
$182,454 was made by the city and $143,483 was made by employees. These
contributions represented 56Z (city) and 44Z (employees) of the covered
payroll.
C. Funding Status and Progres
The "pension benefit obligation' is a standardized disclosure measure of the
present value of pension benefits, adjusted for the effects of projected
salary increases and step -rate benefits estimated to be payable in the future
as a result of employee service to date. The measure, which is the actuarial
present value of credited projected benefits, is intended to help users assess
the PERA's funding status on a going- concern basis, assess progress made in
accumulating sufficient assets to pay benefits when due, and make comparisons
among Public Employee Retirement Systems and employers. The PERA does not make
separate measurements of assets and pension benefit obligation for individual
employers.
The pension benefit obligations of the PERA as of June 30, 1987, were as
follows:
Total pension benefit obligations
Net.assets available for benefits, at market
Public
Employee
Employer
Employer
Public Employees Retirement Fund:
Police &
Fund
Fire Fund
Basic Fund
8Z
81
2 1 /2Z
Coordinated Fund
4Z
4Z
1/41
Police and Fire Fund
8Z
12Z
0
Total contributions made during fiscal year 1987 amounted to $325,937 of which
$182,454 was made by the city and $143,483 was made by employees. These
contributions represented 56Z (city) and 44Z (employees) of the covered
payroll.
C. Funding Status and Progres
The "pension benefit obligation' is a standardized disclosure measure of the
present value of pension benefits, adjusted for the effects of projected
salary increases and step -rate benefits estimated to be payable in the future
as a result of employee service to date. The measure, which is the actuarial
present value of credited projected benefits, is intended to help users assess
the PERA's funding status on a going- concern basis, assess progress made in
accumulating sufficient assets to pay benefits when due, and make comparisons
among Public Employee Retirement Systems and employers. The PERA does not make
separate measurements of assets and pension benefit obligation for individual
employers.
The pension benefit obligations of the PERA as of June 30, 1987, were as
follows:
Total pension benefit obligations
Net.assets available for benefits, at market
Public
Public
Employees
Employees
Retirement
Police &
Fund
Fire Fund
in (millions)
$ 2,839
$ 437
2,609
550
Funded (Unfunded)pension benefit obligation $ ( 230) 113
The actuarial calculations of annual contributions include amounts that would
be required to achieve full (1001) funding by the year 2009.
The measurement of the pension benefit obligation is based on an actuarial
valuation as of June 30, 1987. Net assets available to pay pension benefits
were valued as of June 30, 1987.
-45-
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
Note 12 - Retirement Plans (Continued)
The City's contribution for the year ended June 30, 1987 to PERA plans
represented 0.2X of total contributions required of all partricipating
entities.
Ten -year historical trend information is presented in PERA's State PERS
comprehensive annual financial report for the year ended June 30, 1987. This
information is useful in assessing the pension plan's accumulation of
sufficient assets to pay pension benefits as they become due.
E. Related Party Investments
During 1987 and as of June 30, 1987 PERA held no securities issued by the City
or other related parties.
Note 13 - Contingent Liability
The city participates in a number of federally assisted grant programs,
principal of which are the General Revenue Sharing and Community Development
Block Grant. These programs are subject to program compliance audits by the
grantors or their representatives. The audits of these programs for or
including the year ended December 31, 1987 have not yet been conducted.
Accordingly, the city's compliance with the applicable grant requirements will
be established at some future date. The amount, if any, of expenditures which
may bedisallowed by the granting agencies cannot be determined at this time
although the city expects such amounts, if any, to be immaterial.
Note 14 - Claims and Litigation
The City had the usual and customary types of miscellaneous claims pending at
year -end, mostly of minor nature and usually all covered by insurance carried
for that purpose.
Note 15 - Commitment
The City has leased premises for a liquor store under a five year agreement
expiring in 1989 and requiring total annual rental payments of $58,250.
Note 16 - Cash and Investments
The City maintains a cash and investment pool that is available for use by all
funds. Each fund type's portion of this pool is displayed on the Combined
Balance Sheet as "Cash and Investments ".
Deposits
At year end, the carrying amount of the city's deposits was $178,750 and the
bank balance was $543,499 of the bank balance, $543,499 was covered by federal
depository insurance or collateral held by a trust department of another bank.
-46-
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
Note 16 - Cash and Investments (Continued)
Tnvactmanta
Minnesota Statutes authorize the City to invest in obligations of the U.S.
Treasury, agencies, and instrumentalities, commercial paper rated A -1 by
Standard and Poor's Corporation or P -1 by Moody's Commercial Paper record,
bankers' acceptances and repurchase agreements.
The City's investments are categorized as follows to give an indication of the
level of risk assumed by the entity at year -end. Category 1 includes
investments that are insured or registered or for which 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 broker's or
dealer's trust department or agent in the City's name. Category 3 includes
uninsured and unregistered investments for which the securities are held by the
broker or dealer, but not in the City's name.
Repurchase
Agreements
U.S. Government
Securities
Category
1 3
500,000
9,703,856
Certificates of
Deposits held
by broker 1,457,585 900,000
--- - - - - -- ---- - - - - --
1,957,585 10,603,856
sass ---- -- s- sss - -sss
Carrying Market
Amount Value
500,000 500,000
9,703,856 9,813,103
2,357,585 2,357,585
---- - - - - -- ---- - - - - --
12,561,441 12,680,688
--- ======== s -- ssssss
Note 17 - Change in Accounting for Special Assessments
The City has implemented the provisions of Statement No. 6 of the Governmental
Accounting Standards Board, Accounting and Financial Reporting for Special
Assessments. In the past, special assessments (improvement) projects and
related debt were accounted for in special assessment funds in a separate fund
type. Statement No. 6 provides that such projects are to be accounted for in
capital projects funds, and the general obligation debt is to be accounted for
in the general long -term debt account group and related debt service funds.
The change in accounting for special assessments has been applied retroactively
in the accompanying financial statements. The effect of the change was to
eliminate the special assessment funds, decrease the January 1, 1986 fund
balances in the debt service fund type and capital projects fund type by
$326,523 and $54,656, respectively, and transfer the special assessment
(improvement) bonds outstanding of $2,460,000 at January 1, 1986, to the
general long -term debt account group.
-47-
' NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER
31, 1987
' Note 17 - Change in Accounting for Special Assessments. (Continued)
Individual fund balances were restated as
follows:
'
As Previously
Fund
Reported
As Restated
Special Assessments Funds:
' Permanent Improvement Revolving Fund
$ 2,035,935
$ =
Permanent Improvement Revolving Bond
Fund (2,435,114)
' Total Special Assessment Funds
$ (381,179)
aaaxxxssasza
$ -
zsszaazzazs
As Previously
'
Reported
As Restated
Debt Service Funds:
Tax Increment Bonds 1980
$ 2,068,577
$ 2,068,577
Tax Increment Bonds of 1984
-
'
Tax Increment Bonds of 1985
Special Assessment Bonds of 1985
(362,523)
' Total Debt Service Bonds
----- - - - - --
$ 2,068,577
aaxxxaxaxxs
----- - - - - --
$ 1,742,054
xxaaasaxxax
-Capital Projects Funds:
'
Capital Improvement Fund 401
$ 170,279
$ 115,623
Downtown Land Acq. Fund 405
55,835
55,835
Columbia Park Clinic Fund 406
1,444,534
1,444,534
Sullivan Lake Dev. Fund 407
'
Capital Improvement Fund 408
Murzyn Hall Ren. Fund 410
431,938
431,938
Cap.Imp.Gov't.Bldg.Fund 411
-
-
' Cap.Imp.Parks Fund 412
-
-
SullivanLake Fund 887
18,910
18,910
' Total Capital Projects Fund
----- - - - - --
$ 2,121,496
sxaxxxxssaxx
---- - - - - --
$ 2,066,840
sxxaxsaaaxa
Additionaly, as a result of this change,
the excess of revenues
and other
' sources over expenditures and other uses
for the debt service
fund type
increased $7,049 in 1986, and for the capital
projects fund type
decreased
$159,707 in 1986. Individual funds were
affected as follows:
Fund
(Decrease)
'
1986
Debt Service Funds:
Tax Increment Bonds of 1980
-
Tax Increment Bonds of 1984
'
Tax Increment Bonds of 1985
Special Assessment Bonds of 1985
7,049
' Total Debt Service Funds
$ 7,049
aszazsa
-48-
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1987
Note 17 - Change in Accounting for Special Assessments (Continued)
Capital Projects Funds:
Capital Improvement Fund 401
Downtovn Land Acq.Fund 405
Col.Pk.Clinic Fund 406
Sull.Lake Dev.Fund 407
Capital Imp.Fund 408
Murzyn Hall Ren.Fund 410
Cap.Imp.Gov't.B1dg.Fund 411
Cap.Imp.Park Fund 412
Sullivan Lake Fund 887
Total Capital Projects Funds
-49-
$(159,707)
$(159,707)
aaaaaaaaa
GBERAL FUND
The Home Rule Charter of the Citv of Columbia Heights provides
in Section 69 Subdivision (c): "A General Fund for the support
of such other funds and for the payment of such expenses of the
city as the council may deem proper. Into this fund shall be
paid all moneys not herein provided to paid (sic) into any other
fund."
1
1
1
1
1
1
1
1
GENERAL FUND
COMPARATIVE BALANCE SHEET
December 31, 1987 and 1986
ASSETS
Cash:
Cash and Investments
Imprest cash and change funds
Total Cash
Taxes receivable -- unremitted
Taxes receivable -- delinquent
Less: Allowance fotible taxes
Accounts receivable:
Unbilled services
Other
Due from other governmental units
Prepaid insurance
Total Assets
LIABILITIES, AND FUND BALANCE
Liabilities:
Accounts payable
Accrued salaries and withholdings
Deposits
Due to other governmental units
Deferred revenue
Total Liabilities
Fund Balance:
Reserved
Unreserved
Designated'for subsequent year's
Expenditures
Undesignated
Total Fund Balance
Total Liabilities, and Fund Balance
-50-
Farm A -1
1987 1986
- - - -- ------ - - - - --
$4,543,600 $2,924,668
1,940
----- - - - - --
1,140
------ - - - - --
$4,545,540
$2,925,808
120,634
481,435
55,101
53,140
(55,101)
(53, 140 )
24,110 58,590
27,887 18,182
- - - -- 11,921 58,569
$4,730,092 $3,542,584
$26,996
$233,440
119,812
105,928
18,307
15,330
55,401
33,941
159000
------ - - - - -- ------
11,564
- - - - --
$235,516
------ - - - - -- ------
$400,203
- - - - --
$384,954 $141,938
184,079 -
3,925,543 3,000,443
------ - - - - -- ------ - - - - --
$4,494,576 $3,142,381
$4,730,092 $3,542,584
GENERAL FUND
STATEMENTS OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE
Year Ended December 31, 1987
With Comparative Actual Amounts for Year Ended December 31, 1986
Revenues:
Taxes
Licenses and permits
Fines and forefeitures
Intergovernmental revenues
Charges for current services
Miscellaneous
Refunded reimbursements
Total Revenues
.Other Financing Sources:
Operating Transfer In
Total Revenues and Other
Sources
Expenditures:
General government
Public safety
Public works
Sanitation,
Library
Parks
Other
Total Expenditures
Other Financing Uses:
Operating Transfers Out
Total Expenditures and
Other Uses
Excess of revenues and
other sources over
(under) expenditures and
other uses
Fund balance at beginning of
year
Fund balance at end of year
Forty A-2 1)
$5,202,543 $5,959,541 $756,998 $4,812,916
$994,171
1987
2, 058, 899
1986
-- -
- - - -
- - -- -
Variance
8,95e,
Revised
261,583
Favorable
518,333
Budget
Actual
(Unfavorable)
- - - - -- ----
Actual
- - -���
--------------------------------
$1,688,115
$1,628,970
($59,145)
$1,382,557
151,075
131,351
(19,724)
187,809
80,700
123,813
43,113
108,158
2,453,704
2,512,297
58,593
21396,716
140,614
178,887
38,273
114,9W
143,481
658,675
515,194
249,432
14, NO
51,419
37,419
7,370
*4,671,689
$5,285,412
$613,723
$4,447,024
- -- 530,854
674,129
143,275 ---
M365,894
$5,202,543 $5,959,541 $756,998 $4,812,916
$994,171
$919,991
2, 058, 899
11915,895
945,053
704,081
8,725
8,95e,
299,332
261,583
550,683
518,333
100,000
19,262
$4,956,263 $4,348,095
$74,180 $885,343
143,004 118659654
240,972
630,925
(225)
4,932
37,749
263,650
319750
4779064
80,738
10,813
$6081168
$4,158,361
- - -- 146,253 259,251 (112,9%) 120,683 I
$5,162,516 $4,607,346 $495,170 $4,279,064 I
$100,027 $1,352,195 $1,2529168 $533,854 '
3,142,381 3,142,381 - 2,608,527
$3,242,408 $4,494,576 $1,252,168 $3,1429381 '
= s.csna.ea.c a.ccs.asaaae = zc.rsaaors= ssaxcasasssss
-51- 1
GENERAL FUND
SCHEDULE OF REVENUES - BUDGET AND ACTUAL
Year Ended December 31, 1987
Revised
Budget
Revenue
General property taxes:
Current ad valorem
Delinquent ad valorem
Penalties and interest
Total
Licenses and permits:
Business regulatory licenses
Nan - business licenses and permits
Total
Fines and forefeitures:
Court fines
Other
Total
Revenue from other agencies:
Shared state taxes:
Local government aid
Property tax relief (Homestead)
Insurance premium tax
Other
Anoka county:
Street maintenance
Federal aid:
Civil defense reimbursement
Total
Form A -3
Variance
Actual Favorable
Revenue (Unfavorable)
- ------ - - - - -- ------- - - - - --
$1,681,115
$1,577,599
($103,516)
-
41,633
41,633
7, 000
------ - - - - --
9,738
------ - - - - -- -------
2,738
- - - - --
$1,688,115
------ - - - - --
$1,628,970
------ - - - - -- -------
($59,145)
- - - - --
$61,250
$61,370
$120
89,825
69,941
(19, 844)
$151,075 $131,351 ( #19,724)
--- - - - - -- ------ - - - - -- ------- - - - - --
$80, 000
$119,653
$39,653
700
4,160
3,460
------ - - - - --
$80,700
------ - - - - --
------ - - - - -- -------
$123,813
------ - - - - -- -------
- - - - --
$43,113
- - - - --
$1,770,244
$1,770,267
$23
500,000
559,922
59,922
118,000
119,315
1,315
42,900
41,297
(1, 603)
18,060
18,060
-
4,500
------ - - - - --
3,436
------ - - - - -- -------
(1,064)
- - - - --
$2,453,704
------ - - - - --
$2,512,297
------ - - - - -- -------
$58,593
- - - - --
-52-
GENERAL FUND
SCHEDULE OF REVENUES - BUDGET AND ACTUAL (CONTINUED)
Year Ended December 31, 1987
Revised
Budget Actual
Revenue Revenue
Other revenue:
Interest earnings --
Investment Trust Fund
Sale of land
Gain sale equipment
Miscellaneous
Total
Charges for current services:
General government
Public safety
Public works
Library
Parks
Total
Refunds and reimbursements:
Construction labor
reimbursement
En.,uipment rental
eimbursement
:.ether reimbursements
Total
Total Revenue
Other Financing Sources:
Operating Transfers In
-Grand Total
Form A3
Variance
Favorable
(Unfavorable)
$100,000
$199,565
$99,565
2,000
432,550
430,550
-
8,752
8,752
41,481
------ - - - - --
17,808
------ - - - - -- -------
(23, 673)
- - - - --
$143, 481
$658,675
$515,194
$2,700
$29,933
$27,233
65,414
66,277
863
17,800
30,087
12,287
4,900
3, 030
(1,870)
49,800
49,560
(240)
- - - --
------ - - - - --
$140, 614
------ - - - - --
------ - - - - -- -------
$178,887
------ - - - - -- -------
-
$38,273
- - - - --
9,000
14,836
5,836
5, 000
------ - - - - --
36,583.
------ - - - - -- -------
31,583
- - - - --
$14, 000
------ - - - - --
$51,419
------ - - - - -- -------
$37,419
- - - - --
$4,671,689
$5,285,412
$613,723
530,854
------ - - - - --
674,129
------ - - - - -- -------
143,275
- - - - --
$5,202,543
------ - - - - --
------------
$5,959,541
------ - - - - -- -------
------ - - - - -- -------
$756,998
- - - - --
- - - - --
-53-
'
Form A-4
GENERAL
FUND
SCHEDULE OF
EXPENDITURES
BUDGET AND ACTUAL
Year Ended December 31, 1987
'
1987
'
----------------------------------------------------
Variance
Original
Budget
Favorable
Budget
(Revised)
Expenditures (Unfavorable)
GENERAL GOVERNMENT:
----------------------------------------------------
'
Mayor and Council:
Personal services
$76,156
74,467
$74,355
$112
Other services and
charges
52,435
42,890
41,554
1,336
'
Supplies
1,400
1,200
476
724
Contingencies
5,000
Tot a1
------ - - - - --
$134,991
------ - - - - --
------ - - - - --
$118,557
------ - - - - --
------ - - - --- -------------
$116,385 � $2,172
------ - - - - -- ------- - - - - --
City Manager:
Personal services
$119,873
135,168
$137,880
($2,712)
'
Other services and
charges
30,035
35,755
30,289
5,466
Supplies
1,250
850
920
(70)
Capital Outlay
1,750
2,150
710
1,440
------ - - - - --
--=--- - - - - --
------ - - - - -- -}
---- - - - - --
Total
$152,908
- - --
$173,923
------ - - - - --
$169, 799 /
------ - - - - -- -------
$4,124
- - - - --
Finance Clerk:
------ - -
'
Personal services
221,800
$228,913
$229,986
($1,073)
Other services and
charges
39,459
42,699
34,904
7,795
Supplies
4,60271
8,200
8,579
( 379)
'
Capital Outlay
79,015-
70,000
38,256
31,744
Total
- - - --
$344,874
------ - - - - --
- ----- - - - - --
$349,812
------ - - - - --
------ - - - - -- --
$311,725 i'
------ - - - - -- -------
- - -- - - --
$38,087
- - - - --
Elections:
Personal services
1,350
14,430
6,176
$8,254
Other services and
charges
14,566
5,100
388
4,712
Supplies
1,500
1,600
630
970
------ -; - - --
------ -; - - --
------ -� - - -- 7- --- -- -� - - --
Total
$17,416
$21,130
------ - - - - --
$7,194 ✓
------ - - - - -- -------
$13,936
- - - - --
'
Assessing:
------ - - - - --
Personal services
$31,693
$32,387
$31,840
$547
Other services and
charges
35,554
35,000
40,926
(5,926)
'
Supplies
500
700
304
396
Total
------ - - - - --
$67,747
------ - - - - --
$68,087
------ - - - - -- -------
$73, 070
- - - - --
($4,983)
Legal:
Other services and
charges
74,750
119,050
115,242
3,808
'
Total
-- - - - - -� - - --
$74,750
------ - - - - --
-- - - - - -� - - --
$119,050
------ - - - - --
------------
$115,242
------ - - - - -- -------
- - - - - -� - - --
$3,808
- - - - --
'
-54-
GENERAL
FUND
Form A -4
SCHEDULE OF EXPENDITURES (CONTINUED)
BUDGET
AND ACTUAL
Year Ended December 31,
1987
1987
Variance
Original
Budget
Favorable
Budget
(Revised)
Expenditures (Unfavorable)
GENERAL GOVERNMENT (continued):
----------------------------------------------------
Planning:
Other services and charges
$11,600
$11,850
$10,501
$1,349
Supplies
350
350
-
350
Total
------ - - - - --
$11,950
- - - - --
------ - - - - --
$12,200
------ - - - - --
------ - - - - -- -------
$10,5011/
------ - - - - -- -------
- - - - --
$1,699
- - - - --
General Government Buildings:
------
Personal services
$22,043
$23,788
$22,655
$1,133
Other services and charges
95,729
79,504
72,565
6,939
Supplies
11,150
11,150
.9,771
1,379
Capital Outlay
16,970
16,970
11,084
5,886
�. - - -------- -
- - - --------
- - - - - - -- - - --
- - - - -- - - --
Total
$145,892
$131,412
--
$116 075
S
------ - - - - -- -------
$1., 337
;
- - - - --
TOTAL GENERAL GOVERNMENT
------ - - - - --
$950,528
------ - - - -
$994,171
$919,991
$74,180
PUBLIC SAFETY:
Police Protection:
Personal services
$1,117,184
$1,147,732
$1,115,200
$32,532
Other services and charges
74,577
49,121
46,216
2,905
Supplies
45,275
46,375
38,362
8,013
Capital Outlay
33,475
------ - - - - --
33,436
------ - - - - --
27,988
------ - - - - -- -------
5,448
- - - - --
Total
$1,270,511
------ - - - - --
$1,276,664
------ - - - - --
$1,227,766
------ - - - - -- -------
$48,898
- - - - --
Fire Protection:
Personal services
$577,281
$518,499
$488,062
$30,437
Other services and charges
31,885
23,850
19,487
4,363
Supplies
31,379
26,568
24,884
1,684
Capital Outlay
32,235
------ - - - - --
29,135
------ - - - - --
1,022
------ - - - - -- -------
28,113
- - - - --
Total
$672,780
------ - - - - --
$598,052
------ - - - - --
$533,455
------ - - - - -- -------
$64,597
- - - - --
Protective Inspection:
Personal services
$104,039
$108,814
$105,011
$3,803
Other services and charges
10,099
9,905
7,840
2,065
Supplies
1,805
- - - - --
1,735
------ - - - - --
1,219
------ - - - - -- -------
516
- --- --
Total
------
$115,943
------ - - - - --
$120,454
------ - - - - --
$114,070
------ - - - - -- -------
$6,384
- - - ---
Civil Defense:
Personal services
$13,342
$11,851
$14,212
($2,361)
Other services and charges
9,887
7,178
8,463
(1,285)
Supplies
1,150
1,450
1,145
305
Capital Outlay
25, 000
------ - - - - --
25, 000
------ - - - - --
-
------ - - - - -- -------
25, 000
- - - - --
Total
$49,379
------ - - - - --
$45,479
------ - --- --
$23,820
------ - - - - -- -------
$21,659
- - - - --
-55-
GENERAL FUND
SCHEDULE OF EXPENDITURES (CONTINUED)
BUDGET AND ACTUAL
Year Ended December'31, 1987
PUBLIC SAFETY: (continued)
Animal Control:
Other services and charges
Supplies
Total
TOTAL PUBLIC SAFETY
PUBLIC WORKS:
Engineering:
Personal services
Other services and charges
Supplies
Capital Outlay
Total
Street Maintenance:
Form A -4
1987
----------------------------------------------------
Variance
Original Budget Favorable
Budget (Revised) Expenditures (Unfavorable)
---------------------------------------------- - - - - --
$17,500
$18,000
$16,404
$1,596
250
250
380
(130)
$17,750
$18,250
------ - - - - --
$16,784
------ - - - - -- -------
$1,466
- - - - --
------ - - - - --
$2,126,363
$2,058,899
$1,915,895
$143,004
$163,723
$171,267
$114,767
$56,500
18,322
14,230
13,795
435
7,781
17,596
5,210
12,386
1,350
1,350
682
668
------ - - - - --
$191,176
------ - - - - --
------ - - - - --
$204,443
------ - - - - --
------ - - - - -- -------
$134,454 i✓
------ - - - - -- -------
- - - - --
$69,989
- - - - --
Personal services
$191,787
$223,966
$142,223
$81,743
'
Other services and charges
82,01
72,097
73,295
(1,198)
Supplies
72,300
68,446
45,568
22,878
Capital Outlay
23,000
144,964
111,496
33,468
' Transfers Out State Aid
-
-
5,913-
(5,913)
Total
$369,288
------ = - - - -- ------
$509,473
- - - - --
- - - - -- - - -
$378,495L---'
------ - - - - -- -------
- --
$130,978
- - - - --
'
Street Lighting:
Personal services
$1,051
$1,074
$691
$383
Other services and charges
73,500_ _
74,940-
72,721-
2,219-
' Total
- -
-- - -$74, 551
------ - - - - -- ------
- --
$76,014
- - - - --
- - - -- -------
$73,412 `�
------ - - - - -- -------
$2,602
- - - - --
' Traffic Signs and Signals:
Personal services
$20,298
$18,889
$20,056
($1,167)
Other services and charges
17,672
16,712
13,803
2,909
Supplies
15,876
15,106
12,526
- - - -- - - - - -- -
- - - -- - - - - --
----- - - - - -- V / -
- - - - - - - - --
Total
$53,846
------ - - - - -- ------
$50,707
- - - - --
$46,3S5
------ - - - - -- -------
$4,322
- - - - --
' Tree Trimming and Removal:
Personal services
$21,567
$19,256
$17,546
$1,710
Other services and charges
92,205
84,685
52,500
32,185
' Supplies
1,289
(814)
Total
- - - - - -- -575-
$114,347
-- ----
$104,416
- - - - --
- - - - -- - - - -
$71, 335 ✓
------ - - - - -- -------
- - -- -
$33,081
- - - - --
' TOTAL PUBLIC WORKS
------ - - - - -- ------
$803,208
$945,053
$704,081
$240,972
-56-
Form A -4
GENERAL FUND
SCHEDULE OF EXPENDITURES (CONTINUED)
BUDGET AND ACTUAL
Year Ended December 31, 1987
1987
--------------------------7-------------------------
Variance
Original Budget Favorable
Budget Revised Expenditures (Unfavorable)
---------------------------------------------- - - - - =-
SANITATION
Weed Control:
Personal services
Other services and charges
Total
LIBRARY:
Personal services
Other services and charges
Supplies
Capital Outlay
Total -
$2,473
$2,075
$5,464
($3,389)
9,600
6,650
3,486
3,164
------ -� - - --
------ -� -- -- -------
- - -- /- -----
- - - - --
$12 073
$8,725
$8,95141
i
($225)
$164,579
$171,170
$158,570
$12,600
49,664
51,998
37, 142
14,856
58,703
59,278
58,971
307
15,524
16,886
6,900
9,986
------------
------------ ------
-
- -- - - --
- - - - - -- --
$288,470
$299,332
$261,583
$37,749
MUNICIPAL PARKS;
Administration and Maintenance:
Personal services
$322,891
$331,335
$316,911
$14,424
Other services and charges
- 132,373
116,253
12,750
(6,497)
Supplies
78,475
79,745
71,218
8,527
Capital Outlay
------
21,600
- - - - -- ------
22,750
- - - - --
7,454
------ - - - - -- -------
15,296
- - - -
Total
$555,339
$550,083
$518,333
--
$31,750
=57-
Farm A -4
GENERAL FUND
SCHEDULE OF EXPENDITURES (CONTINUED)
BUDGET AND ACTUAL
Year Ended December 31, 1987
1987
-----------------------------=---------------- - - - - --
Variance
Original Budget Favorable
Budget (Revised) Expenditures (Unfavorable)
---------------------------------------------- - - - - --
UNALLOCATED EXPENSE:
Other services and charges $ - $ - $1,741 (1,741)
Contingencies 200,000 100,000 17,521 82,479
------ - - - - -- ------ - - - - -- ------ - - - - -- ------- - - - - --
Total Unallocated $200,000 $100,000 $19,262 $80,738
------ - - - - -- ------ - - - - -- ------ - - - - -- ------- - - - - --
Total Expenditures $4,935,981 $4,956,263. $4,348,095 $608,168
Other Financing Uses:
OPERATING TRANSFERS OUT
Recreation
$104,475
$104,475
$104,475 $
-
PARA Transit Fund
10,000
10,000
10,000
-
Murzyn "Hall
31,778
31,778
35,287
(3,509)
Insurance Fund
-
-
109,489
(109,489)
Total Transfers
------ - - - - --
$146,253
------ - - - - --
$146,253
------ - - - - -- -------
$259,251
- --
- - - - --
($112,998)
- - - - --
Grand Total
------ - - - - --
$5,082,234
------ - - - - --
$5,102,516
------ - - - -------
$4,607,346
$495,170
MRIS
SPECIAL REVENUE FUNDS
Special Revenue Funds are used to account for the proceeds
of specific revenue sources which finance specified activities
as required by law or administrative regulation.
Revenue Sharing Fund - established by federal legislation
to account for the receipt and expenditure of general
revenue sharing funds.
Municipal State Aid - maintained according to State
Statute for the maintenance and construction of streets
or municipal state -aid system.
Cable Television - established to account for revenues
and expenditures associated with cable television franchise.
Paratransit - established by agreement with the Minnesota
Department of Transportation to account for the receipt
of state grants and rider fees and expenditures for service.
Recreation and Community Service Funds - governed by a
commission established by an agreement between the City
and Independent School District 413 school board.
Incentive Grant, Public Information and Education Grant,
Demonstration Grant Funds - established to account for
the receipt of grant revenues for recycling and expenditures
for the promotion of recycling in the city.
SPECIAL REVENUE FUNDS
COMBINING BALANCE SHEET
December 31, 1987
With Comparative Totals for.December 31, 1986
ASSETS
Cash and Investments
Total Cash and Investments
Accounts receivable
Due from other governmental units:
Due from Federal- Revenue Sharing
Due from State of Minnesota
Total Assets
LIABILITIES AND FUND BALANCE
---------------------- - - - - --
Liabilities:
Municipal
Revenue State Cable
Sharing Aid Television Aaratransit
---- - - - - -- ---- - - - - -- ---- - - - - -- ---- - - - - --
$80,740 $308,675 $107,972 $15,4S7
---- - - - - -- ---- - ----- ---- - - - - -- ----------
$SO, 740 $30S,675 $107,972 $15,4S7
3,500 18, 598 168
- - -
3,4S9
---- - - - - -- ---- - - - - -- ---- - - - - -- ---- - - - - --
$S0,740 $312,175 $126,570 $19,144
Accounts payable $
-
$3,355
$310
$2,529
Accrued salaries payable
-
989
-
-
Accrued F. I. C. A /P. E. R. A. payable
-
-
-
-
Due to other government units
-
160
-
-
----
Total Liabilities $
----
- - - - --
-
- - - - --
---- - - - - --
$4,504
---- - - - - --
---- - - - - --
$310
---- - - - - --
---- - - - - --
$2,529
---- - - - - --
Fund Balance:
Reserved for encumbrances $
-
$ -
$10,000
$ -
Unreserved:
Designated for subsequent year's
expenditures
80,740
307,671
33,425
-
Undesignated
----
-
- - - - --
-
---- - - - - --
82,835
---- - - - - --
16,615
---- - - - - --
Total Fund Balance
----
$80,740
- - - - --
$307,671
---- - - - - --
$126,260
---- - - - - --
$16,615
---- - - - - --
Total Liabilities and Fund Balance
$80,740
$312,175
$126,570
$19,144
-59-
Public
Recreation Information
& Community Incentive & Education Demonstration -- - - - - --
Services Grant Grant Grant 1987
Farm A -1
Totals
1986
$71,144
($20,154) $3,711
------ - - - - -- -------
$15,710 $583,285
- - - - -- ------ - - - - -- ------
$740,355
- - - - --
---- - - - - --
$71, 144
--------- ---
($20,154) $3,711
$15,710 $583,285
$740,355
35,402
- -
- 57,668
54,266
-
- -
- -
1,812
-
- -
=-
- 3,489
- - - - -- ------ - - - - -- ------
1,999
- - - - --
---- - - - - --
$ 106, 546
---- - - - - -- ------ - - - - -------
. ( $20, 154) $3,711
$15,710 $644,442
$798,432
$9,763 $ - $ - $ - $15,957 $21,038
13,979 - - 744 15,712 11,646
1,218 - - 87 1,305 690
- - - - 160 -
---- - - - - -- ---- - - - - -- ------ - - - - -- ------- - - - - -- ------ - - - - -- ------ - - - - --
$24, 960 $ - $ - $831 $33,134 $33,374
---- - - - - -- ---- - - - - -- ------ - - - - -- ------- - - - - -- ------ - - - - -- ------ - - - - --
$ - $ - $ - $ - $1Q1,000 $20,476
(20,154) 3,711 14,879 420,272 612,685
81,586 - - - 181,036 131,897
---- - - - - -- ---- - - - - -- ------ - - - - -- ------- - - - - -- ------ - - - - -- ------ - - - - --
$81, 586 ($20,154) $3,711 $14,879 $611,308 $765,058
---- - - - - -- ---- - - - - -- ------ - - - - -- ------- - - - - -- ------ - - - - -- ------ - - - - --
$106, 546 (*20,154) $3,711 $15,710 $644,442 $798,432
-60-
SPECIAL REVENUE FUNDS
-
$27,529
COMBINING STATEMENT OF REVENUES, EXPENDITURES
AND CHANGES
IN FUND BALANCE
Year Ended December
31, 1987
Other services and charges
-
With Comparative Totals for Year Ended December 31, 1986
17,403
Capital outlay
34,541
Municipal
3,400
Maintenance and construction costs
Revenue
State
Cable
- ------
Sharing
- - - - -- ------
Aid
- - - - --
Television
------ - - - - --
Revenues:
Revenue from other agencies:
114,917
- - --
22,285
------ - - - - -- ------
60,068
- - - - --
Federal
-
-
-
State of Minnesota
-
65,500
-
Independent School District X113
-
-
-
Interest earnings
-
-
9,699
Fees
-
-
48, 284
Contributions
-
-
-
Miscellaneous
-
-- ------
-
- - - - --
3,704
------ - - - - --
------
Total Revenues $
- - - -
-
$65,500
$61,687
Other Financing Sources:
Operating transfers in
-
5,913
- - - - --
-
------ - - - - --
------
Total Revenues and Other Sources $
------
- - - - -- ------
-
- - - - -- ------
$71,413
- - - - --
$61,687
------ - - - - --
Expenditures:
Personal services
-
$27,529
-
Supplies
-
17,657
498
Other services and charges
-
27,435
17,403
Capital outlay
34,541
-
3,400
Maintenance and construction costs
-
-
- - - - -- ------
-
- - - - --
------
Total Expenditures
- - - - --
$34,541
------
$72,621
$21,301
Other Financing Uses:
Operating Transfers Out
114,917
- - --
22,285
------ - - - - -- ------
60,068
- - - - --
------
Total Expenditures and Other Uses
------
- -
$149,458
- - - - --
$94,906
------ - - - - -- ------
$81,369
- - - - --
Excess of Revenues and Other Sources
over (under) Expenditures and Other
Uses
149,458
(23, 493)
(19,6S2)
Fund balance at beginning of year
------
230,198
- - - - --
331,164
------ - - - - -- ------
145,942
- - - - --
Fund balance at end of year
$80,740
$307,671
$126,260
-61-
Farm R -2
Dubl is
'
Recreation
Information
Totals
8 Community
Incentive
& Education
Demonstration
-----------------------
Paratransit
' ----- - - - - --
Services
----- - - - - --
Grant
----- - - - - --
Grant
----- - - -- --
Grant
------ - - - - --
1987
----- - - - - --
1986
----- - - - - --
-
$33, 003
-
-
-
$33,003
$77,934
' 15,620
-
1,104
5,000
_
87,224
301,547
-
192,520
192,520
102,778
_
_
_
-
-
9,699
33,726
' 8,015
1727 876
-
_
_
229,175
236,915
12, 462
12, 462
4,162
-
-
2,000
-
-
5,704
-
$23,635
$410,861
$3,104
$5,000
$
$569,787
$757,062
10,000
*
104,475
- - - - --
-
----- - - - - --
- -- 25,000
-- - --
145,388
----- - - - - --
113,933
----- - - - - --
----- - - - --
$33,635
' ----- - - - - --
----- -- - --- -----
$515,336
----- - - - - --
$3,104
----- - - - - --
$5,000
----- - - - - --
-
$25,000
------ - - - - --
$715,175
----- - - - - --
$870,995
----- - - - - --
-
$349,839
-
-
$8,796
$386,164
$280,476
' 375
43,327
26
227
186
62,296
18,225
21,798
85,266
2,517
-
1,139
155,558
112,258
-
271
-
-
-
38,212
156,165
-
19,319
- - - - --
----- - - - - --
$22,173
----- - - - - --
$478,703
----- - - - - --
$2,543
----- - - - - --
$227
------ - - - - --
$10,121
----- - - - - --
$642,230
-----
$586,443
3,615
4,033
20,715
- - - --
1,062
----- - - - - --
-
------ - - - - --
226,695
----- - - - - --
20,540
----- - - - - --
----- - - - - --
$25,788
' --
----- - - - - --
$482,736
----- - - - - --
----- -
$23,258
----- - - - - --
$1,289
----- - - - - --
$10,121
------ - - - - --
$868,925
----- - - - - --
$606,983
----- - - - - --
7,847
32,600
(20, 154)
3,711
14,879
(153, 750)
$264,012
' 8,768
48 - 986
-
-
-
------------
765,058
-----------
501,046
-----------
$16,615
-----------
$81,586
-----------------------
($20,154)
$3,711
$14,879
$611,308
$765,058
'
-62-
Form P -3
REVENUE SHARING FUND
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE
Year Ended December 31, 1987
With Comparative Totals for Year Ended December 31, 1986
1987
------------------------------
Variance
Favorable 1986
Budget Actual (Unfavorabl Actual
--- - - - - -- --- - - - - -- ---- - - - - -- --- - - - - --
Revenues:.
Revenue from other agencies:
Federal Revenue Sharing - - - 69,207
Interest earnings - - - 23,449
--- - - - - -- --- - - - - -- ---- - - - - -- --- - - - - --
Total Revenues $ - $ - - $92,656
Other Financing Sources;
Operating.transfers in
--- - - - - -- --- - - - - -- ---- - - - - -- --- - - - - --
Total Revenues and Other Sources $ - - $ - $92,656
--- - - - - -- --- - - - - -- ---- - - - - -- --- - - - - --
Expenditures:
Capital Outlay:
Public Safety
-
574
(574)
100,799
Street & Engineering
-
33,967
(33,967)
18, 150
Library
-
-
-
17,390
Parks
-
-
-
5,956
Other:
Public Safety
-
--- - - - - --
-
--- - - - - --
-
---- - - - - --
6,703
--- - - - - --
Total Expenditures
$ -
$34.541
($34,541)
$148,998
Other Financing Uses:
Operating Transfers Out
130,000
114,917
- - --
15,083
- - - - --
-
--- - - - - --
Total Expenditures and Other
--- - - - - --
Uses$136,000
--- - - - - --
--- - -
$149,458
--- - - - - --
----
( #19,458)
---- - - - - --
$148,998
--- - - - - --
Excess of Revenues and Other
Sources
over (under) Expenditures and Other
Uses
(130, 000)
(149,458)-
(19, 458)
($56,342)
Fund balance at beginning of year
230,198
230,198
-
286,540
Fund balance at end of year
$100,198
$80,740
($19,458)
$230,198
-63-
MUNICIPAL STATE -AID STREET FUND
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE
Year Ended December 31, 1987
With Comparative Totals for Year Ended December 31, 1986
Revenues:
Revenue from other agencies:
State of Minnesota
Gasoline tax apportionment -
Maintenance
Construction
Total Revenues
Other Financing Sources:
Operating transfers in
Total Revenues and Other Sources
Expenditures:
Maintenance:
Personal services
Supplies
Other services and charges
Construction:
Personal services
Supplies
Other services and charges
Total Expenditures
Other Financing Uses:
Operating Transfers Out:
Maintenance
Construction
Total Expenditures and Other Uses
Excess of Revenues and Other Sources
over (under) Expenditures and Other
Uses (2,158) (23,493) (21,335) $267,450
331,164 331,164 - 63,714
--- - - - - -- --- - - - - -- ------ - - - - -- --- - - - - --
$329,006 $307,671 ($21,335) $331,164
Form P -4
1987
--------------------------------
Variance
Favorable 1986
Budget Actual (Unfavorable) Actual
--- - - - - -- --- - - - - -- ------ - - - - -- --- - - - - --
58,000
35,000
(23, 000)
17,280
325,000
--- - - - - --
30,500
--- - - - - --
(894,500)
------ - - - - --
269,489
--- - - - - --
$383,000
$65,501
($317,500)
$286,769
-
--- - - - - --
5,913
--- - - - - --
5,913
------ - - - - --
-
--- - - - - --
$383, 000
$71,413
($311,587)
$286,769
12,928
$9,147
3,781,
$5,684
3,500-
177
3,323
1,573
43,730
23,679
20,051
4,092
-
18,382
(18, 382)
1,895
-
17,480
(17,480)
-
-
3,756
(3,756)
144
$60,158
$72,621
($12,463)
$13,388
- 7,910
325,000 14,375
--- - - - - -- -- - - - - --
$385,158 $94,906
(7,910) 5,931
310,625 -
--- - - - - -- --- - - - - --
$290,252 $19,319
Fund .balance at beginning of year
Fund balance at end of year
-64-
CABLE TELEVISION FUND
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE
Year Ended December 31, 1987
With Comparative Totals for Year Ended December 31, 1986
Revenues:
Revenue from other agencies:
Franchise fees
Other services
Interest earnings
Total Revenues
Other Financing Sources:
Operating transfers in
Total Revenues and Other Sources
Expenditures:
Form P -5
--- - - - - -- --- - - - - -- ----- - - - - -- --- - - - - --
$50,500 $61,687 $11,187 $61,198
--- - - - - -- --- - - - - -- ----- - - - - -- --- - - - - --
Personal services
1987
-
$700
------------------------------
Supplies
Variance
498
1,102
930
Favorable
1986
Budget
Actual
(Unfavorable
Actual
-- - - - - --
--- - - - - --
----- - - - - --
--- - - - - --
45,500
48,284
$2,784
-
-
3,704
3,704
50,921
5,000
-- - - - - --
9,699
--- - - - - --
4,699
----- - - - - --
10,277
--- - - - - --
$50,500
$61,687
$11,187
$61,198
--- - - - - -- --- - - - - -- ----- - - - - -- --- - - - - --
$50,500 $61,687 $11,187 $61,198
--- - - - - -- --- - - - - -- ----- - - - - -- --- - - - - --
Personal services
$700
-
$700
$350
Supplies
1,600
498
1,102
930
Other services and charges
18,825
17,403
1,422
3,580
Capital outlay
34,200
--- - - - - --
3,400
--- - - - - -- -----
30,800
- - - - --
2,030
--- - - - - --
Total Expenditures
$55,325
$21,301
$34,024
$6,810
Other Financing Uses:
Operating Transfers Out
56,975
- - - - --
60,068
--- - - - - -- ------
(3,093)
- - - ---
16, 008
--- - - - - --
Total Expenditures and Other
---
Uses $112,300
--- - - - - --
$81,369
--- - - - - -- -----
$31,931
- - - - --
$22,818
--- - - - - --
Excess of Revenues and Other
Sources
over (under) Expenditures and Other
Uses
($61,800)
(19,682)
42,118
$38,380
Fund balance at beginning of year
145,942
145,942
-
107,562
Fund balance at end of year
$84,142
$126,260
$42,118
$145,942
-65-
Farm P -6
PARATRANSIT FUND
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE
Year Ended December 31, 1987
With Comparative Totals for Year Ended December 31, 1986
1987
Variance
Favorable 1986
Budget Actual (Unfavorable) Actual
---- - - - - -- ---- - - - - -- ------ - - - - -- ---- - - - - --
Revenues:
Revenue from other agencies:
State of Minnesota 18,934
Interest earnings
Paratransit fares 6,095
Total Revenues $25,029
Other Financing Sources:
Operating transfers in 10,000
Total Revenues and Other Sources $35,029
15,620 ($3,314) 14,77S
8,015 1, 920 9,065
-- - - - - -- ------ - - - - -- ---- - - - - --
$23, 635 ($1,394) $23,843 .
10,000
$33,635
($1,394)
11,155
$34,998
Expenditures:
Personal services
Supplies
-
375
(375)
-
Other services and charges
27,164
21,798
5,386
23,011
Capital outlay
---- - - - - --
---- - - - - -- ------
- - - - --
---- - - - - --
Total Expenditures
$27,184
$22,173
$5,011
$23,011
Other Financing Uses:
Operating Transfers Out
4,372
---- - - - - --
3,615
---- - - - - -- ------
757
- - - - --
3,219
---- - - - - --
Total Expenditures and Other
Uses $31,556
---- - - - - --
$25,788
---- - - - - -- ------
$5,768
- - - - --
$26,230
---- - - - - --
Excess of Revenues and Other
Sources
over (under) Expenditures and Other
Uses
3,473
$7,847
$4,374
$8,768
Fund balance at beginning of year
8,768
---- - - - - --
8,768
---- - - - - -- ------
-
- - - - --
-
---- - - - - --
Fund balance at end of year
$12,241
$16,615
$4,374
$8,768
Q'SZ
V
RECREATION AND COMMUNITY SERVICES FUNDS
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE
Year Ended December 31, 1987
With Comparative Totals for Year Ended December 31, 1986
Revenues:
Revenue from other agencies:
Federal
Independent School District $13
Fees
Contributions
Total Revenues
Other Financing Sources:
Operating transfers in
Total Revenues and Other.Sources
Expenditures:
Personal services
Supplies
Other services and charges
Capital outlay
Total Expenditures
Other Financing Uses:
Operating Transfers Out
Total Expenditures and Other Uses
Excess of Revenues and Other Sources
over (under) Expenditures and Other
Trips Senior
Recreation Outings Citizens
----- - - - - -- ------ - - - - -- ---- - - - - --
104,475 - 92,841 18,520 318
7,110 - 44
--- - - - - -- ------ - - - - -- ------ - - - - --
$204, 426 $18,520 $33,365
104,475 - -
--- - - - - -- ------ - - - - -- ------ - - - - --
$308, 901 $18,520 $33,365
--- - - - - -- ------ - - - - -- ------ - - - - --
$226,555
- $23,469
24,165
37 3,173
54,202
15,527 2,237
271
- -
$305,193
$15,564 $28,879
4,033 - -
--- - - - - -- ------ - - - - -- ------ - - - - --
$309,226 $15,564 $28,879
Uses ($325) $2,956 $4,486
Fund balance at beginning of year 48,986 - -
------ - - - - -- ------ - - - - -- ----- - - - - --
Fund balance at end of year $48,661 $2,956 $4,486
-67-
Form B -7
Early Adult
Childhood Basic & Totals
& Family Latch Continuing Special -------------------------
Education Key Education Projects 1987 1986
----- - - - - -- ------ - - - - -- ------ - - - - -- ------ - - - - -- ------ - - - - -- ------ - - - - --
88,045 -
7,692 51,559
1,083 -
------ - - - - -- ------ - - - - --
$96,820 $51,559
------ - - - - -- ------ - - - - --
$96, 820 $51,559
------ - - - - -- ------ - - - - --
517 1,429
4,225
-- - - - - -- ----- - - - - --
$517 $5,654
$33,003 $8,727
192,520 102,778
172,876 176,929
12,462 4, 162
--- - - - - -- ------ - - - - --
$410, 861 $292,596
104,475 102, 778
- - - - - -- ------ - - - - -- ------ - - - - -- ------ - - - - --
$517 $5,654 $515,336 $395,374
- - - - - -- ------ - - - - -- ------ - - - - -- ------ - - - - --
$66,702
$28,217
$4,896
- $34.9,_839_
$280,126
9,049
6,272
365
266 43,327
17,295
3, 856
2,529
5,02
1,513 85,266
85,747
-
-
-
- 271
5,137
---
------ -- - - -- -
$79,607
----- - - - - -- ------
$37,018
- - - - -- --
$10,663
---- - - - - -- ------ - - - - -- ------
$1,779 $478,703
- - -
$388,305
------ - - - - -- ------ - - - - -- --
$79, 607 $37, 018
------ - - - - -- ------ - - - - -- --
-- - - - - -- ------ - - - - -- -
$10, 663 $1,779
-- - - - - -- ------ - - - - -- -
4,033 1,313
--- - - - - -- ------ - - - - --
$482, 736 $389,618
--- - - - - -- ------ - - - - --
$17,213 $14,541 ($10,146) $3,875 $32,600 $5,756
- - - - 48,986 43,230
------ - - - - -- ------ - - - - -- ------ - - - - -- ------ - - - - -- ------ - - - - -- ------ - - - - --
$17,213 $14,541 ($10,146) $3,875 $81,586 $48,986
.:
Farm P -8
RECREATION AND COMMUNITY SERVICES
FUND
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE
Year Ended
December 31, 1987
With Comparative Totals for Year Ended
December
31, 1986
1987
---------------------------------
Variance
Favorable
1986
Budget
---- - - - - --
Actual
--- - - - - --
(Unfavorable)
------ - - - - -- -----
Actual
- - - - --
Revenues:
Revenue from other agencies:
Federal
State of Minnesota
Independent School District #13
104,475
104,475
-
102,778
Interest earnings
Fees
94,579
92,841
(1,738)
62,275
Contributions
-
7,110
--- - - - - --
7,110
------ - - - - -- -----
4,162
- - - - --
Total Revenues
---- - - - - --
$199,054
$204,426
$5,372
$169,215
Other Financing Sources:
Operating transfers in
104,475
104,475
-
------ - - - - -- -----
102,778
- - - - --
--------------------
Total Revenues and Other Sources $303,529
---- - - - - --
$308,901
--- - - - - --
$5,372
------ - - - - -- -----
$271,993
- - - - --
Expenditures:
Personal services
$219,381
$226,555
($7,174)
$200,078
Supplies
24,325
24,165
160
9,401
Other services and charges
56,677
54,202
2,475
51,431
Capital outlay
-
271
(271)
4,014
Contingencies
6,057
---- - - - - --
-
--- - - - - --
$6,057
------ - - - - -- -----
-
- - - - --
Total Expenditures
$306,440
$305,193
$1,247
$264,924
Other Financing Uses:
Operating Transfers Out
-
---- - - - - --
4,033
--- - - - - --
($4,033)
------ - - - - -- -----
1,313
- - - - --
Total Expenditures and Other
Uses $306,440
---- - - - - --
$309,226
--- - - - - --
($2,786)
------ - - - - -- -----
$266,237
- - - - --
Excess of Revenues and Other
Sources
over (under) Expenditures and Other
Uses
($2,911)
(325)
2,586
$5,756
Fund balance at beginning of year
48,986
---- - - - - --
48,986
--- - - - - --
-
------ - - - - -- -----
43,230
- - - - --
Fund balance at end of year
$46,075
$48,661
$2,586
$48,986
Me=
Form B -9
TRIPS & OUTINGS
FUND
COMBINING STATEMENT OF REVENUES, EXPENDITURES
AND CHANGES IN FUND
BALANCE
Year Ended December
31, 1987
With Comparative Totals for Year
Ended December 31,
1986
1987
-----------------------------------
Variance
Favorable
1986
-----
Budget
- - - - --
Actual
---- - - - - --
(Unfavorable)
------ - - - - -- ----
Actual
- - - - --
Revenues:
Revenue from other agencies:
Federal
-
-
-
-
State of Minnesota
-
-
-
-
Independent Schaal District X113
-
-
-
-
Interest earnings
-
-
-
-
Fees
18,000
18,520
520
17,022
Contributions
-
- --
-
---- - - - - --
-
------ - - - - -- ----
-
- - - - --
-----
Total Revenues
- - -
$18,000
$18,520
$520
$17,022
Other Financing Sources:
Operating transfers in
-
-
- - - - --
-
------ - - - - -- ----
-
- - - - --
-----
Total Revenues and Other Sources
-----
- - - - --
$18,000
- - - - --
----
$18,520
---- - - - - --
$520
------ - - - - -- ----
$17,022
- - - ---
Expenditures:
Personal services
-
-
-
$234
Supplies
-
37
(37)
512
Other services and charges
15,250
15,527
(277)
16,276
Capital outlay
-----
- - - - --
---- - - - - --
------ - - - - -- ----
- - - - --
Total Expenditures
$15,250
$15,564
($314)
$17,022
Other Financing Uses:
Operating Transfers Out
-----
-
- - - - --
-
---- - - - - --
-
------ - - - - -- ----
-
- - - - --
Total Expenditures and Other Uses
-----
$15,250
- - - - --
$15,564
---- - - - - --
($314)
------ - - - - -- ----
$17,022
- - - - --
Excess of Revenues and Other Sources
over (under) Expenditures and Other
Uses
2,750
$2,956
$206 $
-
Fund balance at beginning of year
-----
- - - - --
---- - - - - --
------ - - - - -- ----
- - - - --
Fund balance at end of year
$2,750
$2,956
$206 $
-
-70-
Farm B -10
SENIOR CITIZENS
FUND
$23,469
$564
COMBINING STATEMENT OF REVENUES,
EXPENDITURES
AND CHANGES IN FUND BALANCE
Year Ended December
31, 1987
866
Other services and charges
With Comparative Totals for Year Ended December. 31, 1986
2,237
2,328
1987
Capital outlay
-
-- - - - - --
-
-- - - - - -- ------
------------------------------
405
- - - - --
Variance
$30,683
$28,879
$1,804
$8,795
Favorable
1986
Budget
-- - - - - --
Actual
-- - - - - --
(Unfavorable)
------ - - - - --
Actual
-- - - - - --
Revenues:
-
- - - - --
-
Total Expenditures and Other,
-- - - - - --
$30,683
Revenue from other agencies:
---
$1,804
- - - -
- - - - --
$8,795
--
Excess of Revenues and Other
-- - - - - --
Sources
Federal
$29,118
$33,003
$3,885
$8,727
State of Minnesota
Uses
($1,565)
$4,486
Independent School District
#13
Fund balance at beginning of year
-
-- - - - - --
-
-- - - - - -- ------
Interest earnings
-
- - - - --
Fund balance at end of year
($1,565)
$4,486
Fees
-
318
318
68
Contributions
-
44
44
- - - --
-
Total Revenues
-- - - - - --
$29,118
-- - - - - --
$33,365
------ -
$4,247
-- - - - - --
$8,795
Other Financing Sources:
Operating transfers in
-
-
-
-
Total Revenues and Other
-- - - - - --
Sour$29,118
-- - - - - --
-- - - - - --
$33,365
-- - - - - --
------ - - - - --
$4,247
------ - - - - --
-- - - - - --
$8,795
-- - - - - --
Expenditures:
Personal services
$24,033
$23,469
$564
$6,612
Supplies
2,085
3,173
(1,088)
866
Other services and charges
4,565
2,237
2,328
912
Capital outlay
-
-- - - - - --
-
-- - - - - -- ------
-
- - - - -- ---
405
- - - - --
Total Expenditures
$30,683
$28,879
$1,804
$8,795
Other Financing Uses:
Operating Transfers Out
-
-
-
- - - - --
-
Total Expenditures and Other,
-- - - - - --
$30,683
-- - - - - -- ------
$28,879
------
---
$1,804
- - - -
- - - - --
$8,795
--
Excess of Revenues and Other
-- - - - - --
Sources
-- - - - - --
-- ---
- - - -
over (under) Expenditures and Other
Uses
($1,565)
$4,486
$6,051 $
-
Fund balance at beginning of year
-
-- - - - - --
-
-- - - - - -- ------
-
- - - - -- ---
-
- - - - --
Fund balance at end of year
($1,565)
$4,486
$6,051 $
-
-71-
Farm P -II
EARLY CHILDHOOD & FAMILY EDUCATION FUND
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE
Year Ended December 31, 1987
With Comparative Totals for Year Ended December 31, 1986
1987
----------------------------------
Variance
Favorable 1986
Budget Actual (Unfavorable) Actual
Revenues:
Revenue from other agencies:
Federal
State of Minnesota $ - $ - $ - $ -
Independent School District #13 - 88,045 88,045 -
Interest earnings
Fees 76,546 7,692 (68, 854) 53,947
Contributions - 1,083 1,083 -
---- - - - - -- ---- - - - - -- ------ - - - - -- ---- - - - - --
Total Revenues $76,546 $96,820 $20,274 $53,947
Other Financing Sources:
Operating transfers in - - - -
---- - - - - -- ---- - - - - -- ------ - - - - -- ---- - - - - --
Total Revenues and Other Sources $76,546 $96,621Z $20,274 $53,947
---- - - - - -- ---- - - - - -- ------ - - - - -- ---- - - - - --
Expenditures:
Personal services
$65,939
$66,702
($763)
$47,567
Supplies
4,998
9,049
(4,051)
2,163
Other services and charges
4,300
3,856
444
3,498
Capital outlay
-
-
-
719
Contingencies
1,309
--
-
---- - - - - -- ------
1,309
- - - - --
-
---- - - - - --
Total Expenditures
---- - - - -
$76,546
$79,607
($3,061)
$53,947
Other Financing Uses:
Operating Transfers Out -
Total Expenditures and Other Use $76,546
Excess of Revenues and Other Sources
over (under) Expenditures and Other
Uses $ -
Fund balance at beginning of year
Fund balance at end of year
I
$79,607 ($3,061) $53,947
---- - - - - -- ------ - - - - -- ---- - - - - --
17,213 $17,213 $ -
---- - - - - -- ---- - - - - --
$ - $17,213
-79-
-- - - - - -- ---- - - - - --
$17,213 $ -
_______= Dear =aaoa
Fund P -12
Expenditures:
Personal services
LATCH KEY FUND
$28,217
($3,914)
$8,443
COMBINING STATEMENT OF REVENUES,
EXPENDITURES AND
CHANGES IN
FUND BALANCE
2,527
Year Ended December 31,
1987
2,529
3,027
With Comparative Totals for Year Ended December
31, 1986
-
---- - - - - --
-
---- - - - - -- ------
-
- - - - --
1987
Total Expenditures
$35,968
$37,018
----------------------------------
$11,995
Variance
Favorable
1986
-
- - -- ------
Budget
---- - - - - --
Actual
---- - - - - --
(Unfavorable)
------ - - - - -- ----
Actual
- - - - --
Revenues:
($1,050)
- - - - --
$11,995
---- - - - - --
Excess of Revenues and Other
Sources
Revenue from other agencies:
over (under) Expenditures and Other
Federal
-
-
-
-
State of Minnesota
-
-
-
-
Independent School District
X13 -
-
-
-
Interest earnings
-
-
-
-
Fees
35,968
51,559
15,591
11,995
Contributions
-
-
---- - - - - --
-
------ - - - - -- ----
-
- - - - --
Total Revenues
---- - - - - --
$35,968
$51,559
$15,591
$11,995
Other Financing Sources:
Operating transfers in
-
-
- - --
-
------ - - - - -- ----
-
- - - - --
Total Revenues and Other
---- - - - - --
Sources $35,968
---- - - - - --
---- - -
$51,559
---- - - - - --
$15,591
------ - - - - -- ----
$11,995
- - - - --
Expenditures:
Personal services
$24,303
$28,217
($3,914)
$8,443
Supplies
6,109
6,272
(163)
2,527
Other services and charges
5,556
2,529
3,027
1,025
Capital outlay
-
---- - - - - --
-
---- - - - - -- ------
-
- - - - --
-
---- - - - - --
Total Expenditures
$35,968
$37,018
($1,050)
$11,995
Other Financing Uses:
Operating Transfers Out
-
-
- - -- ------
-
- - - - --
-
---- - - - - --
Total Expenditures and Other
---- - - - - --
Use $35,968
---- - - - - --
---- - -
$37,018
---- - - - - -- ------
($1,050)
- - - - --
$11,995
---- - - - - --
Excess of Revenues and Other
Sources
over (under) Expenditures and Other
Uses
$ -
$14,541
$14,541
$ -
Fund balance at beginning of year
-
---- - - - - --
-
---- - - - - -- ------
-
- - - - --
-
---- - - - - --
Fund balance at end of year
$ -
$14,541
$14,541
$ -
__________
-73-
Form A -13
ADULT BASIC & CONTINUING EDUCATION FUND
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE
Year Ended December 31, 1987
With Comparative Totals for Year Ended December 31, 1986
1987
----------------------------------
" Variance
Favorable 1986
Budget Actual (Unfavorable) Actual
---- - - - - -- ---- - - - - -- ------ - - - - -- ---- - - - - --
Revenues:
Revenue from ether agencies:
Federal $ - $ - $ - $ -
State of Minnesota - - - -
Independent School District 1113 - - - -
Interest earnings - - - -
Fees - 517 517 20,448
Contributions - - - -
Total Revenues $ - $517 $517 $20,448
Other Financing Sources:
Operating transfers in
-
- - - - --
-
---- - - - - -- ------
-
- - - - --
-
---- - - - - --
----
Total Revenues and Other Sources $
----
-
- - - - --
$517
---- - - - - -- ------
$517
- - - - --
$20,448
---- - - - - --
Expenditures:
Personal services
$3,972
$4,896
(` &924)
$17,164
Supplies
-
365
(365)
1,752
Other services and charges
4,302
5,402
(1,100)
1,532
Capital outlay
----
-
- - - - --
-
---- - - - - -- ------
-
- - - - --
-
---- - - - - --
Total Expenditures
$8,274
$10,663
( #2,389)
$20,448
Other Financing Uses:
Operating Transfers Out
-
-
- - - - -- ------
-
- - - - --
-
---- - - - - --
----
Total Expenditures and Other Uses
- - - - --
$8,274
----
$10,663
- - - - -- ------
($2,389)
- - - - --
$20,448
---- - - - - --
----
Excess of Revenues and Other Sources
- - - - --
----
over (under) Expenditures and Other
Uses
(8,274)
(10,146)
(1,872)
$ -
Fund balance at beginning of year
----
-
- - - - --
-
---- - - - - -- ------
-
- - - - --
-
---- -- - - --
Fund balance at end of year
($8,274)
($10,146),
($1,872)
$ -
-74-
-75-
Form R -14
SPECIAL PROJECTS FUND
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND
CHANGES IN
FUND BALANCE
Year Ended December 31,
1987
With Comparative Totals for Year Ended December 31, 1986
-------------------------------
1987
Variance
Favorable
1986
Budget
Actual
(Unfavorable Actual
--- - - - - --
?-venues:
--- - - - - --
----- - - - - --
--- - - - - --
.• °enue from other agencies:
Federal $ -
$ -
$ _
$ _
State of Minnesota -
-
-
_
Independent School District #13 -
-
-
-
Interest earnings -
-
-
_
Fees -
1,459
1,429
11,174
Contributions -
--- - - - - --
4,225
4,225
-
Total Revenues $ -
--- - - - - --
$5,654
----- - - - - --
$5,654
--- - - - - --
$11,174
Other Financing Sources:
Operating transfers in -
-
-
-
--- - - - - --
Total Revenues and Other Sources $ -
--- - - - - --
--- - - - - --
$5,654
--- - - - - --
----- - - - - --
.$5,654
----- - - - - --
--- - - - - --
$11,174
--- - - - - --
Expenditures:
Personal services $ -
$ -
$ _
$28
Supplies -
266
(266)
74
Other services and charges -
1,513
(1,513)
11,072
Capital outlay -
-
_
_
--- - - - - --
Total Expenditures $ -
--- - - - - --
$1,779
----- - - - - --
($1,779)
--- - - - - --
$11,174
Other Financing Uses:
Operating Transfers Out -
-
-
_
--- - - - - --
Total Expenditures and Other Uses$ -
--- - - - - --
--- - - - - --
$1,779
--- - - - - --
----- - - - - --
($1,779)
-----
--- - - - - --
$11,174
Excess of Revenues and Other Sources
- - - - --
--- - - - - -- -
over (under) Expenditures and Other
Uses -
3,875
3,875
-
Fund balance at beginning of year -
-
-
_
--- - - - - --
Fund balance at end of year $ -
--- - - - ---
$3,875
----- - - - - --
$3,875
--- - - - - --
$ -
-75-
Farm B -15
INCENTIVE GRANT FUND
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE
Year Ended December 31, 1987
With Comparative Totals for Year Ended December 31, 1986
' -- -1987
----- - - - - -- ---------------
Variance
Favorable 1986
Budget Actual (Unfavorable) Actual
--- - - - - -- ---- - - - - -- ---- - - - - -- -- - - - - --
Revenues:
'
Revenue from other agencies:
State of Minnesota
$ -
1,104
1,104
$ -
Refunds & reimbursements
-
2,000
2,000
-
'
--- - - - -
-- ---- -- - --
---- -- - --
$3,104
-------
$
Total Revenues
$ -
$3,104
Other Financing Sources:
'
Operating transfers in
-
-
- - - - --
-
---- - - - - --
-
-- - - - - --
'
--- - - - -
Total Revenues and Other Sources $ -
--- - - - -
-- ----
$3,104
-- ---- - - - - --
$3,104
---- - - - - --
$ -
-- - - - - --
Expenditures:
Supplies
=
26
(26)
Other 'services and charges
--- - - - -
2,517
-- ---- - - - - --
(2,517)
---- - - - - --
-- - - - - --
'
Total Expenditures
$ -
$2,543
($2,543)
$ -
Other Financing Uses:
'
Operating Transfers Out
-
- - - - - --
20,715
---- - - - - --
(20,715)
---- - - - - --
-
-- - - - - --
Total Expenditures and Other
Uses $ -
-
$23,258
-- - - - - --
($23,258)
---- - - - - --
$ -
-- - - - - --
Excess of,Revenues and Other
--- - - -
Sources
----
over (under) Expenditures and Other
Uses
-
(20,154)
(20,154)
-
'
Fund balance at beginning of year
-
--- - - - -
-
-- ---- - - - - --
-
---- - - - - --
-
-- - - - ---
Fund balance at end of year
$ -
($20,154)
($20,154)
$ -
Form B -16
PUBLIC INFORMATION & EDUCATION
GRANT
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND
BALANCE
Year Ended December 31, 1987
With Comparative Totals for Year Ended
December 31,
1986
-1987
Variance
Favorable
1986
Budget
Actual
(Unfavorable)
Actual
,
Revenues:
'
Revenue from other agencies:
State of Minnesota -
5+ 000
- - - - --
---- - - - - --
---- - - - - --
Total Revenues $ -
---- - - - - --
$5 +000
------
$5,000
$
Other Financing Sources:
Operating transfers in
---- - - - - --
------ - - - - --
---- - - - - --
,
---- - - - - --
Total Revenues and Other Sources $ -
$5,000
$5,000
$ -
- --
---- - - - - --
---- - - - - --
------ - - - - --
---- - - -
'
Expenditures:
-
$227
($227)
_
Supplies
---- - - - -
-- ---- - - - - --
------ - - - - --
---- -- - - --
Total Expenditures $ -
$227
($227)
$
'
Other Financing Uses:
Operating Transfers Out -
----------
1,062
---- - - - - --
ti,06-
------ - - - - --
---- - - - - --
Total Expenditures and Other Uses $ -
---- - - - -
-- -- $1,289-
($1+289)
------ - - - - --
$ -
---- - - - - --
,
Excess of Revenues and Other Sources
over (under) Expenditures and Other
Uses $ -
$3, 711
$3, 711
$
Fund balance at beginning of year
Fund balance at end of year $ -
$3,711
$3,711
$ -
-77-
Farm B -17
DEMONSTRATION GRANT FUND
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE
Year Ended December 31, 1987
With Comparative Totals for Year Ended December 31, 1986
1987'
------=-----------------------
Variance
Favorable 1986
Budget Actual (Unfavorable) Actual
-- - - - - -- -- - - - - -- ------ - - - - -- ---- - - - - --
Revenues:
Revenue from other agencies:
Federal $
State of Minnesota
Independent School District #13
Interest earnings
Fees
Contributions
Total Revenues $
Other Financing Sources:
,Operating transfers in
Total Revenues and Other Sources $
Expenditures:
- 85,000 25,000 -
- $25,000 $25,000 $ -
- -- -- - - - - -- ------ - - - - -- ---- - - - - --
Personal services
$
- $8,796
- -- -- - - -
- -- ------ -
- - - -- ---- - - - - --
- 85,000 25,000 -
- $25,000 $25,000 $ -
- -- -- - - - - -- ------ - - - - -- ---- - - - - --
Personal services
$
- $8,796
($8,796)
$ -
Supplies
- 186
(186)
-
Other services and charges
- 1,139
(1,139)
-
Capital outlay
-- -
- -
- - - -- -- - - - - -- ------
-
- - - - --
-
---- - - - - --
Total Expenditures
$
- $10,121
($10,121)
$ -
Other Financing Uses:
Operating Transfers Out
-- -
- -
- - - -- -- - - - - -- ------
-
- - - - --
-
---- - - - - --
Total Expenditures and Other
Uses $
-- -
- $10,121
- - - -- -- - - - - -- ------
($10,121)
- - - - --
$ -
---- - - - - --
Excess of Revenues and Other
Sources
over (under) Expenditures and Other
Uses
$
- $14,879
14,879
$ -
Fund balance at beginning of year
-- -
- -
- - - -- -- - - - - -- ------
-
- - - - --
-
---- - - - - --
Fund balance at end of year
$0 $14,879
$14,879
$ -
-78-
DEBT SERVICE FUIDS
Debt Service Funds are used to account for the collection of
tax levies and other revenues and to record the payment of
principal and interest on outstanding General Obligation Bonds.
DEBT SERVICE FUNDS
COMBINING BALANCE SHEET
December 31, 1987
With Comparative Totals for December 31, 1985
ASSETS
Cash and investments
Cash deposited with fiscal agents
Cash in escrow
Taxes receivable - unremitted
Taxes receivable - delinquent
Less: Allowance for uncollectable taxes
Special assessments receivable
Unremitted
Delinquent
Deferred
Allowance for delinquent assessments
Total Assets
LIABILITIES AND FUND BALANCE
----------------------------
Liabilities:
Deferred revenue
Accounts payable
Bonds payable
Matured interest payable
Total Liabilities
Tax Increment Tax Increment Tax Increment
Bonds of Bonds of Bonds of
1980 1984 1985
------- - - - - -- ------- - - - - -- ------- - - - - --
$2,192,278 $ - $ -
5,
108,82s - -
t108,825) - -
------- - - - - -- ------- - - - - -- ------- - - - - --
$2,197,459 $ - $ -
------- - - - - -- ------- - - - - -- -
$5,181 $ - $
------- - - - - -- ------- - - - - -- -
Fund Balance:
Fund Balance:
Reserved for debt service $2,192,278 $ - $ -
Reserved for refunding T11980 & TI198 - - -
------- - - - - -- ------- - - - - -- ------- - - - - --
Total Liabilities and Fund Balance $2,197,459 $ - $
-74-
Farm C -1
Special Special
Tax Increment Tax Increment Assessment Assessment Totals
Ponds of Ponds of Ponds of Ponds of --------------- --
1987 1987A 1985• 1987 1987 1986
------- - - - - -- ------- - - - - -- ------ - - - - -- ------- - - - - -- ------- - - - - -- -- - - - - --
($28,687) $17,054 $ - $2,120,401 $4,301,046 $4,006,133
- - - 5,181 5,780
8,863,500 - - - 8,863,500 -
- - - 1,248 1,248 -
- -
108,825 67,574
(108,825) (67,574)
- 68,303
-
108,729 108,729 110, 886
616,994 616,994 697,064
- (108,729) (108,729) (110,886)
------- - - - - -- ------- - - - - -- ------ - - - - -- ------- - - - - -- ------- - - - - -- ------- - - - - --
$8,834,813 $17,054 $ - $2,738,643 $13,787,969 $4,777,280
_ -
17-1054 -
------- - - - - -- ------- - - - - -- ------ - - - - --
$ - $17,054 $ -
------- - - - - -- ------- - - - - -- ------ - - - - --
$616,994 $616,994 $697,064
6,839 23,1893 - -
- - 2,390,000
5,181 -
--- - - - - -- ------- - - - - -- ------- - - - - --
$623, 833 $646,068 $3,087,064
--- - - - - -- ------- - - - - -- ------- - - - - --
($28,687) $ - $ - $2,114,810 $4,278,401 $1,690,216
8, 863, 500 - - - 8,863,500 -
------- - - - - -- ------- - - - - -- ------ - - - - -- ------- - - - - -- ------- - - - - -- ------ - - - - --
$8,834,813 $17,054 $ - $2,738,643 $13,787,969 $4,777,280
-80-
-81-
DEBT SERVICE FUNDS
COMBINING STATEMENT OF REVENUES,
EXPENDITURES
AND
,
CHANGES IN FUND BALANCES
Year Ended December 31, 1987
With Comparative Totals for Year Ended December
31, 1986
'
Tax Increment
Tax Increment
Tax Increment
Bonds of
Bands of
Bands of
1980
1984
1985
'
Revenues:
----- - - - - --
��
------- - - - - --
CA
------ - - - - --
h
General property taxes:
Collected by county
Current ad valorem
$1,092,062
$ -
$ -
Delinquent ad valorem
12,902
Revenue from other sources:
Property tax relief (Homestead)
147,363
-
-
Sale of land
12,719
Special assessments
Special assessment collections
-
-
-
Penalties and interest
Interest earnings:
-
-
-
'
Investment Trust Fund
168,.224
-
-
Other interest
-
-
-
Bond Proceeds
Other miscellaneous revenue
-
----- - - - - --
-
------- - - - - --
-
------ - - - - --
Total Revenues
$1,433,270
$ -
$ -
'
Other Financing Sources:
Transfers from:
Tax Increment Bonds of 1980
-
177,695
224,124
'
Special Assessment Fund
-
-
-
PIR Bonds 1987
-
-
-
Total Revenues and Other Sources
----- - - - - --
$1,433,270
------- - - - - --
$177,695
------ - - - - --
$224,124
Expenditures:
Bonds matured
$190,000
$95,000
$509000
Interest on bonds
658,330
81,320
172,690
'
Fiscal agent charges
532
1,375
1,434
Bond issue costs
-
-
-
Miscellaneous
----- - - - - --
------- - - - - --
------ - - - - --
Total Expenditures
$848,862
$177,695
$224,124
Other Uses;
Operating transfers out
401,819
----- - - - - --
-
------- - - - - --
-
------ - - - - --
'
Total Expenditures and Other Uses
$1,250,681
$177,695
$224,124
'
Excess of Revenues and Other Sources
over (under) Expenditures
$182,589
-
-
$2,009,689
Fund Balance at beginning of year
----- - - - - --
------- - - - - --
------ - - - - --
Fund Balance at end of year
$2,192,278
$ - _ - - --
$
-81-
Farm C -2
Special
Special
Tax Increment
Tax Increment
Assessment
Assessment
Totals
Bands of
Bonds of
Bonds of
Bands of
---------------
--
1987
1987A
1985
1987
1987
1986
------- - - - - --
------- - - - - --
------- - - - - --
------- - - - - --
------ - - - - --
------ - - - - --
$ -
$ -
$ -
$ -
$1,092,062
$875,653
-
-
-
-
12,902
17,222
-
-
-
-
147,363
99,948
-
-
-
-
12,719
8,826
-
-
-
433,568
433, 568
408,239
-
-
-
90,486
90,486
238,612
-
-
-
51,701
219,925
145,618
38,163
1,433
-
64,779
104,375
-
9,090,000
1, 100, 000
-
2,230,000
12, 420, 000
-
-
------- - - - - --
-
------- - - - - --
-
------- - - - - --
18,964
-------
18,964
26,777
$9,128,163
$1,101,433
- - - - --
$2,889,498
------ - - - - --
$14,552,364
------ - - - - --
$1,821,095
-
-
-
-
401,819
405,359
-
-
369,489
-
369,489
227,340
-
------- - - - - --
-
------- - - - - --
2,195,000
------- - - - - --
-
------- - - - - --
2,195,0e@
------
-
$9,128,163
$1,101,433
$2,564,489
$2,889,498
- - - - --
$17,518,672
------ - - - - --
$2,453,794
-
-
-
-
$335,000
$280,000
72,922
-
172,435
32,782
1,190,479
1,102,804
-
-
2,054
-
5,395
5,278
220,428
17,054
-
33,554
271,036
-
-
------- - - - - --
-
------- - - - - --
-
------- - - - - --
5,497
------- - - - - --
5,497
------ - - - -
1,988
$293,350
$17,054
$174,489
$71,833
--
$1,807,407
------ - - - - --
$1,390,070
-
------- - - - - --
1,084,379
------- - - - - --
-
------- - - - - --
2,773,382
------- - - - - --
4,259,580
------ - - - - --
1,115,562
------ - - - - --
. $293,350
------- - - - - --
$1,101,433
------- - - - - --
$174,489
------- - - - - --
$2,845,215
------- - - - - --
$6,066,987
------ - - - - --
$2,505,632
------ - - - - --
8,834,813
-
$2,390,000
$44,283
$11,451,685
($51,838)
-
------- - - - - --
-
------- - - - - --
(2,390,000)
------- - - - - --
2,070,527
------- - - - - --
1,690,216
------ - - - - --
1,742,054
------ - - - - --
$8,834,813
$ -
$ -
$2,114,810
$13,141,901
$1,690,216
J
CAPITAL PROJECT FUNDS
Capital Project Funds are maintained to account for the
construction of major capital facilities. Project appli-
cations are a combination of several revenue sources, such
as municipal state -aid streets, special assessments, sewer
utility fund, other governmental units, State and Federal
Grants, etc.
CAPITAL PROJECTS FUNDS
COMBINING BALANCE SHEET
December 31, 1987
With Comparative Totals for December
31, 1986
Capital
Downtown
Columbia Pk,
Improvement
Land Acq.
Clinic
Fund 401
Fund 405
Fund 406
ASSETS
----- - - - - --
----- - - - - --
---- - - - - --
Cash and investments
0728,981)
$93,108
$2,603
Accounts receivable
1,150
-
-
Due from other government units.
9,700
----- - - - - --
-
----- - - - - --
-
---- - - - - --
Total Assets
($718,131)
----- - - - - --
-----------
$93,108
----- - - - - --
----- - - - - --
$2,603
---- - - - - --
---- - - - - --
LIABILITIES AND FUND BALANCE
----------------------------
Liabilities:
Accounts payable $ - $3,254 $ -
Contracts payable - retained % 1,888 - -
Accrued salaries payable 1,537 - -
Deposits - -
----- - - - - -- ----- - - - - -- ---- - - - - --
Total Liabilities $3,425 $3,254 $ -
----- - - - - -- ----- - - - - -- ---- - - - - --
Fund Balance:
Reserved 780 - -
Unreserved
Designated for subsequent years expenditures ($722,336) $89,854 $ -
Undesignated - - $2,603
----- - - - - -- ----- - - - - -- ---- - - - - --
Total Fund Balance ($721,556) $89,854 $2,603
----- - - - - -- ----- - - - - -- ---- - - - - --
Total Liabilities and Fund Balance ($718,131) $93,108 $2,603
-83-
Capital Capital
Sullivan Lake Capital Murzyn Hall Improvement Improvement Sullivan
0� Development Improvement Renovation Gov't Bldg. Parks Lake
-- Fund 407 Fund 408 Fund 410 Fund 411 Fund 412 Fund 887
__________ __________ __________ ___________ __________ __________
Form D-1
Totals
_____________
1987 1986
_______ _______
$470,779
$5,931
$6,486
$168,824
-
$1E4910
$37,660
($245,415)
-
-
23,700
-
-
-
24,850
-
-
-
-'
-
9,700
----------
144,631
----------
----------
$470,779
----------
$5,931
----------
$30,186
-----------
$168,824
----------
$
----------
- $18,910
$72,210
($100,784)
$ -
$ -
$9,159
$16,070
$ -
$ -
$28,483
$56,574
-
-
13,353
-
-
-
15,241
137,732
-
-
-
-
1,537
2,054
_
-
-
-
-
-
-
----------
8,510
----------
----------
0� $ -
----------
-_-_------
$ -
----------
----------
$22,512
----------
-----------
$16,07N
-----------
$ -
---------
----------
$ -
- ----------
$45,261
----------
$2N4,87W
----------
-
-
_
_
_
-
780
-
$470,779
$5,931
$7,674
$152,754
$ -
$1E,910
$23,566
($399,187)
N� _
_
-
-
-
-
2,603
93,533
__________
__________
$470,779
__________
$5,931
__________
$7,674
___________
$152,754
-----------
__________
$ -
----------
__________
$18,910
----------
__________
$26,949
----------
($305,654)
----------
----------
$470,779
==========
----------
$5,931
==========
----------
$30,188
==========
$188,824
===========
$ -
==========
$18,910
==========
$72,210
==========
($100,784)
==========
CAPITAL PROJECTS FUNDS
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND
CHANGES IN FUND BALANCES
Year Ended December 31, 1987
With Comparative Totals for Year Ended December 31, 1986
Capital Downtown Columbia Pk.Sullivan Lake
Other Financing Sources:
Operating transfers in
Improvement
Land Acq.
Clinic
Development
Other reimbursements
Fund 401
Fund 405
Fund 406
Fund 407
Revenues:
----- - - - - --
--- - - - - --
---- - - - - --
------- - - - - --
State Grant
$ -
$ -
$ -
$ -
Interest earnings -
Investment Trust FD -
6,698
2,603
26,731
Miscellaneous
1,150
----- - - - - --
-
--- - - - - --
-
---- - - - - --
-
------- - - - - --
Other project expenditures
$1, 150
$6,698
$2,603
$26,731
Other Financing Sources:
Operating transfers in
192,401
-
-
1,084,379
Other reimbursements
-
-
-
-
Contributions
-
-
-
-
-
Total Revenues and Other Sour
----- - - - - --
$193,551
----- - - - - --
--- - - - - --
$6,698
--- - - - - --
---- - - - - --
$2,603
---- - - - - --
------- - - - --
$1,111,110
------- - - - - --
Expenditures:
Construction contracts
$ -
$ -
$ -
$ -
Other project expenditures
320,907
----- - - - - --
12,689
--- - - - - --
87,602
---- - - - - --
640,331
------- - - - - --
Total Expenditures
$320,907
$12,689
$87,602
$640,331
Other Financing Uses:
Operating transfers out
-
-
-
-
-
Total Expenditures and Other
----- - - - - --
$320,907
----- - - - - --
--- - - - - --
$12,689
--- - - - - --
---- - - - - --
$87,602
---- - - - - --
------- - - - --
$640,331
------- - - - - --
Excess of Revenues and Other
Sources
over (under) Expenditures
($127,356)
($5,991)
($84,999)
$470,779
Fund Balance at beginning of year
(594,200)
----- - - - - --
95,845
--- - - - - --
87,602
---- - - - - --
-
------- - -
Fund Balance at end of year
($721,556)
$89,854
$2,603
- - --
$470,779
-E 5-
-86-
Form D -2
Capital
Capital
Capital
Murzyn Hall
Improvement
Improvement
Sullivan
Totals
Improvement
Renovation
Gov't Bldg.
Parks
Lake
-----------------
'Fund 408
----- - - - - --
Fund 410
----- - - - - --
Fund 411
----- - - - - --
Fund 412
----- - - - - --
Fund 887
----- - - - - --
1987 - -_ -1986
----- - - - - -- - - --
$ -
$72,558
$ -
$ -
$ -
$72,558 -$ -
5,677
-
41, 709 '� 97,842
'
_
1, 150 --' 174,148
- - - -- ------ - - - - --
----- - - - - --
' $ -
----- - - - - --
$72,558
----- - - - - --
$5,677
----- - - - - --
$ -
----- - - - - --
$ -
----- -
$115,417 $271,990
-
35,287
30,000
-
-
1,342,067 851,489
23
23 145
1,150
-
-
----- - - - - --
_
----- - - - - --
1,150 7,550
----- - - - - -- ------ - - - - --
----- - - - - --
' $ -
----- - - - - --
----- - - - - --
$109,018
----- - - - - --
----- - - - - --
$35,677
----- - - - - --
$ -
----- - - - - --
$ -
----- - - - - --
$1,458,657 $1,131,174
----- - - - - -- ------ - - - - --
$ -
$29,482
$ -
$ -
$ -
$29,482 $2,535,347
'
-
18,973
16,070
-
----- - - - - --
-
----- - - - - --
1,096,572 920,82E
----- - - - - -- ----- - - - - --
----- - - - - --
$ -
----- - - - - --
$48,455
----- - - - - --
$16,070
$ -
$ -
$1,126,054 $3,456,175
_
_
-
_
-
- 47,493
----- - - - - -- ------ - - - - --
' ----- - - - - -=
$ -
----- - - - - --
----- - - - - --
$48,455
----- - - - - --
----- - - - - --
$16,070
----- - - - - --
---- - - - - - --
$ -
----- - - - - --
-----------
$
----- - - - - --
$1,126,054 $3,5e3,668
----- - - - - -- ------ - - - - --
' $ -
$60,563
$19,607
$ -
$ -
$332,603 ($2,372,494)
5,931
(52,889)
133, 147
-
$18,910
(305,654) 2, 066, 840
--($305,654)
---$26,949-
$-5-,-9-3-1
$-7-,-6-7-4--
7 674
--$--15-2-,-7-5-4--
152 754
$
$18,910-
-86-
ENTERPRISE FUNDS
The Authority for these types of funds is derived from Section 69
(b) of the Citv Charter which allows for utility or other public
service enterprise funds.
The Enterprise Funds are a member of the proprietary fund category,
and as such, are accounted for on the accrual basis of accounting.
Revenues in the enterprise fund are recognized when they are earned
and their expenses are recognized when they are incurred.
The Enterprise Funds are used to account for operations that
are either financed and operated in a manner similar to private
business enterprises or where the governing body has decided that
periodic determination of revenues earned, expenses incurred,
and /or net income is appropriate for capital maintenance, public
policy, management control, accountability, or other purposes.
ENTERPRISE FUNDS - COMBINING BALANCE SHEET
'
December 31, 1987
With Comparative Totals
for December 31, 1986
Enterprise
---------------------------------------------------
Liquor
Water
Utility
Sewer
Utilty
Refuse
Utility
Fund
Fund
Fund
Fund
- - - - --
ASSETS---
----- - - - - --
------- - - - - --
------ - - - - --
------
,
Current Assets:
Cash & Investments
$830,437
$718,736
$2,128,330
($36,015)
Receivables (net of allowances
'
for uncollectables ):
Accounts receivable
Unbilled accounts receivable
140
-
39,552
130,903
39,744
133,957
31,244
105,302
'
Due from other governmental units -
-
1
17,078
Inventories, at cost
496,328
3,039
-
-
Total Current Assets
----- - - - - --
$1,326,905
----- - - - - --
------- - - - - --
$892,230
------- - - - - --
------ - - - - --
$2,302,032
------ - - - - --
--=--- - - - - --
$117,609
------ - - - - --
Deferred Receivables:
Contracts receivable
$ -
$
- - - - --
- $236,575-
-
$ -
------ - - - - --
Total Deferred Receivables
----- - - - - --
-
-------
-
236,575
-
Property and Equipment:
Land
$7,125
$45,223
$36,586
$ -
Buildings
80,783
212,924
26,245
-
Improvements other than buildings
103,859
2,229,619
2,475,155
2,890
'
Office furniture and equipment
24,522
3,722
3,414
-
Machinery and equipment
- -- 149,421-
- - - -- 123,467-
r
- -- 226,218
175
,
Total
$365,710
$2,614,955
$2,767,618
$3,065
Less: Accumulated depreciation
1471997
1,250,700
- - - - --
1,432,723
------ - - - - --
- ----- - - -99-
'
Net property and Equipment
----- - - - - --
$217,713
-------
$1,364,255
$1,334,895
$2,966
Total Assets
----- - - - - --
$1,544,618
------- - - - - --
$2,256,485
------ - - - - --
$3,873,502
------ - - - - --
$120,575
'
Farm E -1
--------------- - --
Totals
1987 1986
-- - - - - -- ------- - - - - --
$3,641,488 $3,102,161
110,680
100,786
370,162
343,138
17,079
47,751
499,367
------ - - - - --
412,199
------- - - - - --
$4,638,776
------ - - - - --
$4,006,035
------- - - - - --
$236,575 $253,972
------ - - - - -- ------- - - - - --
236,575 253,972
------ - - - - -- ------- - - - - --
$88,934 $88,934
319,952 319,782
4,811,523 4,808,633
31,658 24,522
499,281 466,700
------ - - - - -- ------- - - - - --
$5,751,348 $5,708,571
2,831,519 2,693,331
----- - - - - -- ------ - - - - --
$2,919,829 $3,015,240
----- - - - - -- ------ - - - - --
$7,795,180 $7,275,247
-88-
ENTERPRISE FUNDS - COMBINING BALANCE SHEET (CONTINUED)
December 31, 1987
Enterprise
---------------------------------------------
Water Sewer Refuse
Liquor Utility Utilty Utility
Fund Fund Fund Fund
----- - - - - -- ----- - - - - -- ----- - - - - -- --- - - - - --
LIABILITIES AND FUND EQUITY
------------------------------
Current Liabilities:
Accounts payable $207,447 $37,315 $2,667 $23,116
Accrued salaries & withholding 22,070 15,680 9,572 -
Due to other governmental unit 31, 490 2,085 - -
----- - - - - -- ----- - - - - -- ----- - - - - -- --- - - - - --
Total Current Liabilities $261,007 $55,080 $12,239 $23,116
----- - - - - -- ----- - - - - -- ----- - - - - -- --- - - - - --
Fund Equity:
Contributions $ - $988,278 $901,747 $ -
Retained earnings
Reserved 40,000 4,659 3,649 2,000
Unreserved 1,243,611 1,208,468 2,955,867 95,459
----- - - - - -- ----- - - - - -- ----- - - - - -- --- - - - - --
Total Fund Equity $1,283,611 $2,201,405 $3,861,263 $97,459
Total Liabilities and Fund
Equity $1,544,618 $2,256,485 $3,873,502 $120,575
Form E -2
------------------- - - - - --
Totals
1987 1986
----- - - - - -- ----- - - - - --
$270,545 $291,476
47,322 46,362
3:3,575 1,621
$351,442 $339,459
----- - - - - -- ---- - - - - --
$1, 890, 025 $1,955,254
50, 308 -
5,503,405 4,980,534
$7,443,738 $6,935,788
$7,795,180 $7,275,247
1
1
1
-90-
ENTERPRISE FUNDS -
COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN
RETAINED EARNINGS
Year Ended December 31, 1987
With Comparative Totals for Year Ended December 31, 1986
Liquor Water
OPERATING REVENUES: ------ - - - - -- -----------
sales $3,74a,248 *888,545
Cast of sales 3,109,599 -
------ - - - - -- ------ - - - - --
Grass Profit #638,649 $888,545
------ - - - - -- ------ - - - - --
OPERATING EXPENSES:
Personal services
Other services and charges
Supplies
Source of supply /disposal charges
Total
OPERATING INCOME BEFORE DEPRECIATION
DEPRECIATION
OPERATING INCOME (LOSS)
NON- OPERATING REVENUES (EXPENSES)
Interest income
Other income (expense) - net
Total
Income before transfers
Operating Transfers Out
Operating Transfers In
Net Transfers
Net Income
TRANSFER DEPRECIATION ON CONTRIBUTED ASSETS
Income Transferred to Retained Earnings
RETAINED EARNINGS BEGINNING OF YEAR
RETAINED EARNINGS, END OF YEAR
Ma
$229,878
$128,681
151,025
51,921
11, 822
29,648
-
------ - - - - --
512,128
------ - - - - --
$392,725
------ - - - - --
$722,378
------ - - - - --
$245, 924
$166,167
25,464
------ - - - - --
50,379
------ - - - - --
$220,460
$115,788
$60,198
$39,223
9,048
------ - - - - --
1,427
------ - - - - --
$69,246
------ - - - - --
$40,650
------ - - - - --
$289,706
------ - - - - --
$156,438
------ - - - - --
240,808
39,373
------ - - - - --
$240,808
------ - - - - --
------ - - - - --
$39,373
------ - - - - --
48,898
117,1065
-
------ - - - - --
26,294
------ - - - - --
$48, 898
------ - - - - --
$143,359
------ - - - - --
$1,234,713
------ - - - - --
$1,069,768
------ - - - - --
$1,283,611
$1,213,127
-92-
'
Farm E -3
'
Totals
'
Sewer
- -- - - --
Refuse
--
--------- - -
1987
- - --
1986
$827,512
--
$625,626
- - -- - - --
$6,089,931
---- - - --
$5,629,226
'
3,109,599-
2,879, ----
------ - - - - --
$827,512
------ - - - - --
---- - - - - --
$625,626
---- - - - - --
--
$2,980,332
------ - - - - --
--
$2,'749,944
------ - - - - --
'
$101,108
$2,136
$461,803
$444,886
36,831
8, 903
248,660
312,360
39,340
1,275
82,085
63,481
399,475
525,436
1,437,039
1,317,079
------ - - - - --
---- - - - - --
$537,750
------ - - - - --
$2,229,607
------ - - - - --
$2,137,806
'$576,754-
$250,758
$87,876
$750,725
$612,138
'
63,803
- - - -- -
---- - - - ---
139,745
- - -- -
0
$186,955
------ - - - - --
$87,777
---- - - - - --
$610,980
------ - - - - --
------ - ----
$465,136
------ - - - - --
'
$147, 808
$ -
$247,229
$308,752
7,138
-
17,613
2,269
'
$154,946
$ -
$264,842
$311,021
'
- -- $341,901
- - --
$87,777
---- - - - - --
$875,822
------ - - - - --
$776 - 159
29,852
73,794
383,827
------ -- - --
651,816
'
-
15,955
15,955
-
$29, 852
------ - - - - --
$57,839
---- - - - - --
$367,872
------ - - - - --
$651,816
'
312,049
29,938
507,950
------ - - - - --
124,343
38,935
------------
65,229
65,229
'
- -- $350,984-
---- - - - - --
$29,938
---- - - - - --
------ - - - - --
$573,179
------ - - - - --
------ - - - - --
$189,572
------
$2,606,532
$67,521
$4,980,534
- - - - --
$4,790,962
'
$2,959,516 _
= =$97, 459-
$5,553,713 -
$4,980,534 -
-92-
ENTERPRISE FUNDS - COMBINING STATEMENT OF CHANGES.IN
FINANCIAL POSITION
Year Ended December 31, 1987
With Comparative Totals for Year Ended December 31, 1986
SOURCES OF WORKING CAPITAL:
Operations:
Net Income
Items not requiring (providing) working capital
Depreciation
Working Capital Provided by Operations
Decrease in long term contract receivable
Decrease in deferred receivable- reserve capacity
Total Sources of Working Capital
USES OF WORKING CAPITAL:
Additions to property and equipment -net
INCREASE IN WORKING CAPITAL
ELEMENTS OF NET INCREASE IN WORKING CAPITAL
Cash
Accounts receivable
Inventory
Accounts payable
Due from /to other government units
Accrued liabilities
Net increase (Decrease) in Working Capital
=93-
Liquor Water
$48,898
$117,965
25,465
58,379
$74,363
$167,444
$74,363 $167,444
2,663 2,512
$71,788 $164,932
$25,176 $138,581
(928) 17,388
87,168 -
(35, 249) 7,494
(4,475) 1,557
$71,788 $164,932
Farm E -4
Totals
-------- --- - --
Sewer -- - - - - -- Refuse 1987 1986
- - - - -- -------- - - - - -- -------- - - - - -- - - - - --
$312,049
$29,938
$507,950
$124,343
63,803
99
139,746
144,601
$375,852
$30,037
$647,696
$268,944
12,862
-
12,862
12,367
4,535
-- --- --- - - - - -- --------
-
- - - - -- --------
4,535
- - - - -- --------
5,108
- - - - --
$393, 249
- ---- ------ - -- --------
$30,037
- - - - -- --------
$665,093
- - - - -- --------
$286,419
- - - - --
36,095
-------- - - - - -- --------
3,065
- - - - -- --------
44,335
- - - - -- --------
4,947
- - - - --
$357, 154
$26,972
$620,758
$281,472
$363,232
$12,338
$539,327
$386,590
(36,152)
8, 940
(10,832)
( 36, 765)
-
-
87,168
6,310
28,410
(11,384)
(10, 729 )
(114,652)
-
17, 078
17,078
(3,869)
-- - - - - -- 1,664-
--------------
- -
- - - -- (1,254) -------
-- -----
$357, 154
-------- - - - - -- --------
$26,972
- - - - -- --------
$620,758
- - - - -- --------
$281,472
- - - - --
-94-
'
Farm E -5
' MUNICIPAL LIQUOR FUND
COMPARATIVE BALANCE SHEET
December 31, 1987 and 1986
'
1987
19$6
ASSETS --------
- - - - --
-------- - - - - --
' Current Assets:
Cash:
Cash & Investments
$826,437
$800,761
Imprest cash and change funds
4,000
4,500
--------
Total Cash
- - - - --
$830,437
-------- - - - - --
$805,261
' Accounts receivable
140
1,060
Merchandise inventory, at cast
496,328
409,160
' Total Current Assets
$1,326,905
1 $1,215,481
--------
Property and Equipment:
- - - - --
-------- - - - - --
'
Land
$7,125
$7,125
Buildings
80,783
80,613
Improvements other than buildings
103,859
103,859
' Office furniture and equipment
24,522
24,522
Store equipment
--------
149,421
- - - - --
148,486
-------- - - - - --
' Total
$365,710
$364,605
Less: Accumulated depreciation
--------
147,997
- - - - --
124,090
-------- - - - - --
' Net Property and Equipment
$217,713-
$240,515
-
Total Assets
- - --
$1,544,618
- - - --
$1,455,996
LIABILITIES AND RETAINED EARNINGS
--------------------------------
'
Current Liabilities:
Accounts payable
$207,447
$203,212
Accrued salaries & withholding payable
22,070
17,595
' Due to other governmental units
31,490-
476
-
Total Current Liabilities
- - - - --
$261,007
$221,283
Retained Earnings
Reserved
$40,000
$ -
' Unreserved
1,243,611
1,234,713
--------
Total Liabilities and Retained Earnings
- - - - --
$1,544,618
-------- - - - - --
$1,455,996
'-95-
Sales
Cast of Sales:
Inventory, Beginning
Purchases
Total Merchandise Available for Sale
Less: Inventory, Ending
Cost of Sales
Gross Profit on Sales
Percentage of Gross Profit to Sales
Less: Operating Expense
Personal Services
Other Services & Charges
Supplies
Total Operating Expense
Operating Income before Depreciation
Less: Depreciation
Operating Income
Nonoperating Revenues (Expenses):
Interest earnings - Trust Fund
Machine commissions
Other income
Cash short
Other expense
Total
Net income before transfers
Operating Transfers Out
Net Income
Retained Earnings at beginning of year
Retained earnings at end of year
MUNICIPAL LIQUOR FUND
COMPARATIVE STATEMENT OF REVENUES,
EXPENDITURES
'
AND CHANGES IN RETAINED EARNINGS
Years Ended
December 31, 1987 and 1986
'
Totals All
Stores
STORE ND.
1987
1986
1987
-------- - - - - --
-_ -$3, 748, 248_
-------- - - - - -- --------
$3,526,168
-------- - - - - -- --------
- - - - --
$2,684 1 164
- - - - --
'
$409,160
$402,851
$293,569
- - - -3,196,767
- - --
2,885,591
-------- - - - - -- --------
2,335,59t_
- - - - -
'
$3,605,927
$3,288,442
$2,629,165
496,328
-------- - - - - --
409,160
-------- - - - - -- --------
366,589
- - - - --
'
- - -$3,109,599 -
-------------------------------
- - -$2,879,282 - - -
-$2,262,576
'
$638,649
$646,886
$421,588
17.04%
18.35%
15.71%
'
$229,878
213,399
146,901
151,025
182,907
120,401
,
11,822
10,456
7,619
-------- - - - - --
$392,725
- ----
-------- - - - - -- --------
$406,762
-------- - - - - -- --------
- - - - --
$274,921
- - - - --
,
-------- -
$245,924
$240,124
$146,667
25,464-
------- -- ----
-- 22,161-
,
- - - - - --
$220,460
$213,507
$124,506
-------- - - - - --
-------- - - - - -- --------------
'
$60,198
$105,957
$1,096
1,722
$10,701
2,181
'
($2,649)
(2,953)
($100)
-
-------- - - - - --
$69,246
-------- - - - - --
$106,907
'
-------- - - - - --
-------- - - - - --
$289,706
320,414
240,808
- - - - -- -
579,494
- -_ -- -
,
$48,898
($259,080)
- - - -1, 234, 713-
1,493,793
-------- - - - - --
'
$1,2S3,611
$1,234,713
-9.6-
1
'
Farm E -6
1
STORE NO.
. 2
STORE NO.
3
' - - - - --
1986
-------- - - - - --
-------- -
1987 •
- - - -- 1986
19-------- -
87
- - - --
1986
--------
$2,520,351
' ______ _____ _ __ ___
- - - - --
$434,592
__ ___ ____ __
-------- - - - - -- --------
$436,313
____ ______ ____ ___
- - - - --
$629,492
____ ___ ____
-------- - - - - --
$569,504
__ __ __________
$287,897
$48,795
$47,326
$66,796
$67,628
2,084,405
-------- - - - - -- --------
347,449
- - - - --
- -__ -- 352,079- -----
513,722-
------ 449,107
$2,372,302
$396,244
$399,405
$580,518
$516,735
' 293, 569
- __ C__ _ _______
48,606
------
48,795
------
81,133
_______
66,796
____ __________
$2,078,733
----- -$ - - - - -618 - --------
$347,638
- - - --
$350,610
-------- - - - -- --------
$499,385
- - - - --
$449,939
------ - - - --
'
$441-- ,
$86- , 954
$85- , 703
$130, 107
$1-- 19- , 565
17.52X
20.01%
19.64X
20.67%
20.99%
134,187
39,449
38,202
43,528
41,010
'
141,742
13,851
17,929
16,773
23,236
7,701
-------- - - - - -- --------
2,000
- - - - --
1,448
-------- - - - - -- --------
2,203
- - - - --
1,307
-------- - - - - --
'$283,630
-------------- --------------
$55,300
$57,579
- - --------------
$62,504
$65,553
------ -
$157,988
$31,654
$28,124
$67,603
$54,012
' 23,342
1,462
1,462
-------- - - - - -- --------------
1,841
1,813
-------- = - - - --
$ 134,646
$30,192
$26,662
$65,762
$52,199
'
-97-
1 .
Form E -7
MUNICIPAL LIQUOR FUND
COMPARATIVE STATEMENT CHANGES IN FINANCIAL POSITION
Years Ended December 31, 1987 and 1986
1987 1986
-------- - - - - -- -------- - - - - --
Sources of Wanking Capital:
Operations:
Net income $48,898 ($259,080)
Items not requiring (providing) working capital
Depreciation 25,465 26,617
-------- - - - - -- -------- - - - - --
Total Sources of Working Capital $74,363 ($232,463)
Uses of Working Capital:
Acquisition of property and equipment 2,663 5,818
-------- - - - - -- -------- - - - - --
Increase in Working Capital $71,700 ($238,281)
Elements of Increase in Working Capital:
Cash & Investments $25,176 ($206,363)
Accounts receivable (920) 486
Inventory 87,168 6,309
Accounts payable (35,249) (79,617)
Accrued liabilities (4,475) 40,904
-------- - - - - -- -------- - - - - --
Increase in Working Capital $71,700 ($238,281)
-98-
NO. 1
Sales
Cast of Sales:
Inventory, Beginning
Purchases
MUNICIPAL LIQUOR FUND '
COMPARATIVE SCHEDULE OF GROSS PROFIT
Years Ended December 31, 1987 and 1986
1987
------------------------------------------------
Total Liquor Beer
______________ ______________ ____________ i
$2,684,164.
2, 684, 164 $1,289,205 $1,235,479
-------- - - - - -- -------- - - - - -- -------- - - - - -- '
Total Merchandise Available for Sale
Less: Inventory, Ending
Cost of Sales
Gross Profit on Sales
Percentage of Grass Profit to Sales
NO. 2
Sales
Cost of Sales:
Inventory, Beginning
Purchases
Total Merchandise Available for Sale
Less: Inventory, Ending
Cost of Sales
Gross Profit on Sales
Percentage of Gross Profit to Sales
NO. 3
Sales
Cast of Sales:
Inventory, Beginning
Purchases
Total Merchandise Available for Sale
Less: Inventory, Ending
Cost of Sales
Gross Profit on Sales
Percentage of Gross Profit to Sales
$293,569
$224,369
$62,596
335, 596
1, 100, 361
1, 097, 907 '
----2,335,596
- - -2, - - --
$2,629,165
-------- - - - - -- --------
$1,324,730
- - - - --
$1,160,503
366,589
-------- - - - - --
247,275
-------- - - - - --
91,841
-------- - - - - --
2,262,576 -
--- ----------------------------------
-- $1,077,455 -
-- $1,068,662
$421,58S
$211,750
'
$166, 817
-------- 15.71X --
- - - - -- 1642% --
____ -- 1350%
$434,592 $148,344 $272,223 '
--- - - - - -- -------- - - - - -- -------- - - - - --
$48,795
$29,277
$17,668
,
347,449
- - - - -- --------
115,718
- - - - -- --------
215,964
- - - - --
--------
$396, 244
$144,995
$233,632
,
48,606
28,750
18,151
-------- - - - - -- --------
$347,638- -_
- - - - -- --------
- -- $116,245- -
- - - - --
- -- $215,481-
,
----
$86,954
$32,099
$56,742
20.67%
28.16%
20.84%
20.01%
21.64X
,
$629,492 $236,982 $370,095 '
$66,796
$46,213
$18,150
513,722
181,106
310,011
- - - - --
-------- - - - - -- --------
$580, 518
- - - - -- --------
$227,319
$328,161
81,133
57,074
21,050
-------- - - - - -- --------
$499,385
- -- --------
- -- - -- --------
$170,245
- - - - -- --------
- - - - --
$307,111
- - - - --
'
-------- - - -
$130,107
$66,737
$62,984
20.67%
28.16%
17.02%
-99-
,
1986
-------- - - - - -- ------------------------------
Other Total Liquor
-------- - - - - -- -------- - - - - -- -------- - - - - --
$159,480 $2,520,351 $1,325,775
-------- - - - - -- -------- - - - - -- ------- - - - - --
Form E -8
------------------- - - - - --
Peer Other
--- - - - - -- -------- - - - - --
$1,119,248 $75,328
-------- - - - - -- ------ - - - - --
$6,604
$287,897
$237,200
$42,997
$7,700
137,328
2,084,405
1,068,923
964,713
- - - - -- --------
50,769
- - - - --
-------- - - - - --
$143, 932
-------- - - - - --
$2,372,302
-------- - - - - -- --------
$1,306,123
$1,007,710
$58,469
27,473
293,569
224,369
62,596
- - -- --------
6,604
- - - - --
-------- - - - - --
$116, 459
-------- - - - - --
$2,078,733
- - - - --
-------- - - - - -- --------
$1,081,754
-------- - - - - -- --------
- -
$945,114
- - - - -- --------
$51,865
- - - - --
-------- - - - - --
$43,021
--------
$441,618
$244,021
$174,134
$23,463
26.98%
17.52%
18.41%
15.56%
31.15%
$14,025
-------- - - - - -- --------
$436,313
- - - - -- --------
$164,313
- - - - -- --------
$256,741
- - - - -- --------
$15,259
- - - - --
$1,850
$47,326
$ 32, 063
$13,411
$1,852
15,767
352,079
- - - --
112,212
-------- - - - - -- --------
228,931
- - - - -- --------
10,936
- - - - --
-------- - - - - -- --------
$17,617
-
$399,405
$144,275
$242,342
$12,788
1,705
-------- - - - - -- --------
48,795
- - - - -- --------
29,277
- - - - -- --------
17,668
- - - - -- --------
1,850
- - - - --
$15,912
$350,610
$114,998
$224,674
- - - - -- --------
$10,938
- - - - --
-------- - - - - -- --------
($1,887)
- - - - -- --------
$85, 703
- - - - -- --------
$49,315
$32,067
$4, 321
- 13.45%
19.64%
30.01%
12.49%
28.32%
$22,415
-------- - - - - -- --------
$569,504
- - - - -- --------
$242,176
- - - - -- --------
$307,180
- - - - -- --------
$20,148
- - - - --
$2, 433
$67,628
$48,374
$16,149
$3,105
22,605
449,107
- - - - -- --------
163,064
- - - - -- --------
271,863
- - - - -- --------
14,180
- - - - --
-------- - - - - -- --------
$25, 038
$516,735
$211,438
$288,012
$17,285
3, 009
- - - - -- --------
66,796
- - - - -- --------
46,213
- - - - -- --------
18,150
- - - - -- --------
2,433
- - - - --
--------
$22, 029
- --------
$449,939
- - - - -- --------
$165,225
- - - - -- --------
$269,862
- - - - -- --------
$14,852
- - - - --
-------- - - - --
$386
$119,565
$76,951
$37,318
$5,296
1.72%
20.99%
31.77%
12.15%
26.29%
-100-
MUNICIPAL
LIQUOR FUND
SCHEDULE OF PROPERTY, EQUIPMENT AND
,
ACCUMULATED
DEPRECIATION
Year Ended
December 31,
1987
,
--------- - - - ---
Property- and -
Equipment
'
Balances
(Deletions)
Balances
1 -1 -87
Additions
12 -31 -87
Off Sale No, I
Store:
Improvements
other
than buildings
$87,645
$ -
$87,645
Fixtures
978
-
978
Equipment
140,010
-------- - - - - --
935
-------- - - - - --
140,945
-------- - - - - --
,
Total
- - - -- $228,633-
-- - - - - -- -$935
- - -- $229,568-
'
Off Sale No. 2
Store:
Land
$2,765
$ -
$2,765
Building
32,335
-
32,335
,
Improvements
other
than buildings
4,489
-
4,489
Fixtures
7,342
-
7,342
Equipment
- -- 6,441-
-
- - - - - -- 6,441-
'
Total
$53,372
$ -
$53,372
Off Sale No. 3
Store:
-------------
-------- - - - - --
-------- - - - - --
'
Land
$4,360
$ -
$4,360
Building
52,978
170
53,147
Improvements
other
than buildings
7,025
-
7,025
'
Fixtures
15,085
-
15,085
Equiprent
3,153
-
3,153
Total
- - - - -- -
$82,600
-- - - - - -- --
$170
-------- - - - - --
- - - - -- $82,770
-------- - - - - --
'
Grand Totals
-------- - - - - --
$364,605
$1,105
$365,710
-101-
'
1
1
1
Farm E -9
1
Accumulated Depreciation
--------------
--------------------------------------------------------------
Balances
Depreciation
Balances
Net Asset
1 -1 -87
--------------------------------------------------------
Taken
Adjustments 12 -31 -87
- - - - --
Value
-------- - - - - --
$17,505
$7,563
$
- $25,068
$62,577
328
157
- 485
493
3+3,003-
14,440-
--------------
- - - - - - -- 44,443
-
96,502
- - - - -- -
- - - - - --
$47,836
-------- - - - - --
- - - - - --
$22,160
-------- - - - - --
$
--------
- $69,996
- - - - -- -------- - - - - --
$159,572
-------- - - - - --
$ -
$ -
$
- $ -
2,765
16,128
666
16,794
15,541
1,885
225
_
2,110
2,379
7,205
68
- 7,273
69
4,8611
- - - - --
503
-------- - - - - --
------
- 5,371
- - - - -- -------- - - - - --
1,070
-------- - - - - --
--------
$30, 086
-------- - - - - --
$1,462
-------- - - - - --
$
--------
--
$31,548
- - - - -- -------- - - - - --
$21,824
-------- - - - - --
$ -
$ -
$
- $ -
4,360
24,660
1,215
(1,558) 24, 317
28,830
3,736
339
4,075
2,950
15,085
-
15,085
=
-
2,688
288
2,976
- - - - --
177
-------- - - - - --
-------- - - - - --
$46,-169
-------- - - - - --
$1,842-
--------
--------------
- - - - -- --------
() - - - -- $46,453
-
$36,317
- - - -- -
- - - - -- ---
$124,091
1
1
- - - - --
$25,464
($1,558) $147, 997
$217,713
1
t
'-102-
Form E -10
WATER UTILITY FUND
COMPARATIVE BALANCE SHEET
December 31, 1987 and 1986
1987 1986
------- - - - - -- ------- - - - - --
ASSETS
Current Assets:
Cash & Investments
$718,736
$580,155
Accounts receivable:
Unbilled.services
130,903
116,435
Special assessments:
Delinquent
-
-
Other
39,552
36,720
Meter Inventory, at cost
3,039
- - --
3,039
------- - - - - --
Total Current Assets
------- - -
$892,230
------- - - - - --
$736,349
------- - - - - --
Property and Equipment:
Land
45,223
45,223
Buildings
212,924
212,924
Improvements other than `_ ;z'; :< .;
2,229,619
2,229,619
Office furniture and equipment
3,722
3,722
Machinery and equipment
123,467
------- - - - - --
120,955
------- - - - - --
Total
$2,614,955
$2,612,443
Less: Accumulated depreciation
1,250,700
------- - - - - --
1,200,321
------- - - - - --
Net Property and Equipment
$1,364,255
------- - - - - --
$1,412,122
------- - - - - --
Total Assets
$2,256,485
$2,148,471
LIABILITIES, AND FUND EQUITY
---------------------------
Current Liabilities:
Accounts payable
$37,315
$45,749
Accrued salaries & withholding payable
15,680
17,237
Due to other governmental units
2,085
------- - - - - --
1,145
------- - - - - --
Total Current Liabilities
$55,080
------- - - - - --
$64,131
------- - - - - --
Total Liabilities
$55,080
------- - - - - --
$64,131
------- - - - - --
Fund equity:
Contributed Capital
988,278
1,014,572
Retained earnings unreserved
Reserved
4,659
-
Unreserved
1,208,468
------- - - - - --
1,069,768
------- - - - - --
Total Fund Equity
$2,201,405
------- - - - - --
$2,084,340
------- - - - - --
Total Liabilities, and Fund Equity
$2,256,485
$2,148,471
-103-
WATER UTILITY FUND
COMPARATIVE STATEMENT OF CHANGES IN FUND EQUITY
Years Ended December 31, 1987 and 1986
1987
--------------------- - - - - -- - --
Form E -11
1986
-104-
Contributed
Retained
Contributed
Retained
Capital
Earnings
Capital
Earnings
Balance, January 1
------- - - - - --
------- - - - - --
------- - - - - --
------- - - - - --
$1,014,572
$1,069,768
$1,040,866
$1,017,619
Income transferred to
retained earnings
-
143,359
-
52,149
Depreciation on
contributed assets
(26,294)
-
(26,294)
-
Balance, December 31
------- - - - - --
------- - - - - --
------- - - - - --
------- - - - - --
$988, 278
$1,213,127
$1,014,572
$1,069,768
-104-
1
1
1
1
1
1
1
1
1
Farm E -12
WATER UTILITY FUND
COMPARATIVE STATEMENT OF REVENUES AND EXPENDITURES
Years Ended December 31, 1987 and 1986
Operating Expenses:
Source of supply
Distribution:
Personal services
Other services and charges
Supplies
Administration and General:
Personal services
Other services and charges
Supplies
Total Operating Expenses
Operating Income Before
Depreciation
Less: Depreciation
Operating Income
Nonoperating Revenues (Expenses):
$512,128 $502,422
128,661
1987
1986
Operating Revenues:
-° °-- - ----- -
- -°° -� °°
Water sales
$863,070
$749,333
Hydrant rental
-
-
Meter sales
6,761
8,496
Customer service
1,492
1,349
Penalties
17,222
------- - - - - -- -------
16,049
- - - - --
Total Operating Revenue
$888,545
------- - - - - -- -------
$775,227
- - - - --
Operating Expenses:
Source of supply
Distribution:
Personal services
Other services and charges
Supplies
Administration and General:
Personal services
Other services and charges
Supplies
Total Operating Expenses
Operating Income Before
Depreciation
Less: Depreciation
Operating Income
Nonoperating Revenues (Expenses):
$512,128 $502,422
128,661
130,679
4,438
50,641
28,363
25,000
-
Be
9,483
11,630
1,285
- --
773
-
$722,378
$721,225
$166,167 $54,002
524,379 51,157
$115,788 $2,845
Interest earnings - Trust Fund $39,223 $44,597
Miscellaneous 1,427 314
Interest expense - -
Total $40,650 $44,911
------- - - - - -- ------- - - - - --
Net Income before transfers $156,438 $47,756
Operating Transfer Out 39,373 21,901
------- - - - - -- ------- - - - - --
Net Income $117,065 $25,855
Transfer depreciation on contributed assets 26,294 26,294
------- - - - - -- ------- - - - - --
Income transferred to retained earnings - - -- $143,359- ----- $52,149-
-105-
Form E -13
WATER UTILITY FUND
COMPARATIVE STATEMENT OF CHANGES IN FINANCIAL POSITION
Years Ended December 31, 1987 and 1986
1987 1986
------- - - - - -- -- - - - - --
Source of Working Capital:
Operations:
Net income (loss)
Items not requiring (providing) working capital:
Depreciation
Total Sources of Working Capital
Uses of Working Capital:
Acquisition of property and equipment
Net Increase in Working Capital
Elements of Net Increase in Working Capital:
Cash and Investments
Accounts receivable
Inventory
Accounts payable
Accrued expenses
Due to other funds
Net Increase in Working Capital
-106-
$117,065
$25,855
50,379
--- - - - - -- -------
51,156
- - - - --
$167,444
$77,011
2,512 584
------- - - - - -- ------ - - - - --
$164,932
$76,427
138,581
813,527
17,300
(17, 551)
0
1
7,494
2,823
1,557
2,627
------- - - - - -- -------
$164, 932
- - - - --
$76,427
WATER UTILITY FUND
SCHEDULE OF PROPERTY, EQUIPMENT AND
ACCUMULATED DEPRECIATION
Year Ended December 31, 1987
Land
Bw i dings
Improvements other than buildings
Machinery and equipment
Office furniture and equipment
Grand Totals
Balances
1 -1 -87
Property and Equipment
----------------------- - - - - --
Additions Deletions
---------------------- - - - - --
45,223 - -
212,9 24 - -
2,229,619 - -
120,955 2,51a -
3,722 - -
------- - - - - -- ------- - - - - -- ------- - - - - --
$2,612,443 $2,512 $ -
-107-
Farm E -14
-108-
Accumulated Depreciation
-- ------- -
------- - - - - --
Balances
-------------------------------------------------
Balances
Depreciation
- - - -
Balances
- - - --
Net Assets
12 -31 -87
------- - - - - --
1 -1 -87
-------------------------------------------------
Taken Adjustments
12 -31 -87
- - - - --
Value
------- - - - - --
45,223
-
- -
-
$45,223
212,924
83,736
7,162 -
90,898
122,026
2,229,619
1,006,946
38,931 -
1,045,877
1,183,742
123,467
107,258
3,951 -
111,209
12,258
3,722
2,381
335 -
2,716
--
1,006
-------
-------------
$2,614,955
-------------
$1,200,321
------- - - - - -- ------- - - - - --
$50,379 $ -
------- - - - -
$1,250,700
- - - - --
$1,364,255
-108-
Form E -15
SEWER UTILITY FUND
COMPARATIVE BALANCE SHEET
December 31, 1987 and 1986
1987 1986
ASSETS------- - - - - -- ------- - - - - --
Cash & Investments
Accounts receivable:
Unbilled services
Other
Due from other governmental units
Total Current Assets
Due from Metropolitan Waste Control Comm.:
Reserve capacity
Interceptor acquisition contract
Total Deferred Assets
Property and Equipment:
Land
Buildings
Improvements other than buildings
Office furniture and equipment
Machinery and equipment
Total
Less: Accumulated depreciation
Net property and Equipment
Total Assets
LIABILITIES, AND FUND EQUITY
------------------------------------
Current Liabilities:
Accounts payable
Accrued salaries and withholding payable
Total Current Liabilities
Fund Equity:
Contributed Capital
Retained earnings
Reserved
Unreserved
Total Fund Equity
Total Liabilities, Contributions,
and Retained Earnings
-109-
$2,128,330 $1,765,098
133,957 126,849
39,744
1 47,751
------- - - - - -- ------- - - - - --
$2,302,032 $1,974,952
------- - - - - -- ------- - - - - --
$14,176 $18,711
222,399 235,261
------- - - - - -- ------- - - - - --
$236,575 $253,972
------- - - - - -- ------- - - - - --
$36,586
26,245
2,475,155
3,414
226,218
$2,767,618
1,432,723
$36,586
26,245
2,475,155
3,414
190,123
$2,731,523
1,368,920
$1,334,895 $1,362,603
------- - - - - -- ------- - - - - --
$3,873,502 $3,591,527
------- - - - - -- ------- - - - - --
------------- ------- - - - - --
$2,667
$31,077
9,572
------- - - - - -- -------
11,236
- - - - --
$12, 239
------- - - - - -- -------
$42,313
- - - - --
$901,747 $940,682
3,649 -
2,955,867 2,608,532
------- - - - - -- ------- - - - - --
$3,861,263 $3,549,214
------- - - - - -- ------- - - - - --
$3,873,502 $3,591,527
Form E -16
SEWER UTILITY FUND
COMPARATIVE STATEMENT OF REVENUES AND EXPENDITURES
Years Ended December 31, 1987, and 1986
1987 1986
Dperating Revenues: ------ - - - - -- - -- - - - - - --
Sewer service charges - general customers
and interdepartmental
Refunds and Reimbursements;
Metropolitan Waste Control Commission
Interceptor maintenance
S.A. C. charge refund
Total Operating Revenues
Operating Expenses;
Disposal - Metro Waste Control Commission
Collections:
Other services and charges
Supplies
Administration:
Personal services
Other services and charges
Supplies
Total Operating Expenses
$807,328 $789,181
20,153 18,66e
31 648
$827,512 $808,483
------ - - - - -- ----- - - - - --
$399,475
$397,727
35,137
38,040
29,177
17,177
1,694
10,878
10,163
------ - - - - --
717
----- - - - - --
$576, 754
------ - - - - --
$564,201
----- - - - - --
Operating Income Before
Depreciation $250,758 $244,282
Less: Depreciation 63,803 69,226
------ - - - - -- ----- - - - - --
Operating Income $186,955 $175,056
------ - - - - -- ----- - - - - --
Nonoperating Revenues (Expenses):
Interest earnings $138,145 .$147,230
Metro Wste Control Commission
Interest on deferred current value credit 9,410 9,905
Interest on reserve capacity deferred charge 253 1,063
Other income (Expense) 7,138 -
------ - - - - -- ----- - - - - --
Total $154,946 $158,198
------ - - - - -- ----- - - - - --
Net Income before transfers $341,901 $333,254
Transfer to General Fund 29,852 20,575
------ - - - - -- ----- - - - - --
Net Income (Loss) $312,049 $312,679 .
Transfer depreciation on contributed assets 38,935 38,935
------ - - - - -- ----- - - - - --
Income transferred to retained earnings $350,984 $351,614
------------ ----- - - - - --
-110-
SEWER UTILITY FUND
COMPARATIVE STATEMENT OF CHANGES IN FUND EQUITY
Years Ended December 31, 1987 and 1986
1987
Farm E -17
1986
-111 -
Contributed
Retained
Contributed
Retained
Capital
------- - - - - --
Earnings
------- - - - - --
Capital
----- - - - - --
Earnings
----- - - - - --
Balance, January 1
$940,682
$2,608,532
$979,617
$2,256,918
Income transferred to retained
earnings
-
350,984
-
351,614
Depreciation on contributed
assets
(38,935)
-
- - --
(38,935)
----- - - - - --
-
-----------
Balance, December 31
------- - - - - --
$901,747
------- - -
$2,959,516
$940,662
$2,60S,532
-111 -
Farm E -18
SEWER UTILITY FUND
COMPARATIVE STATEMENT OF CHANGES IN FINANCIAL POSITION
Years Ended December 31, 1987 and 1986
1987
1986
Source of Working Capital:
---- - - - - - --
-----------
Operations:
Net income
$312,049
$312,679
Items not requiring (providing) working capital:
Depreciation
63,803
----- - - - - --
66,828
----- - - - - --
Working Capital Provided from Operations
$375,852
$379,507
Metropolitan Waste Control Commission:
Decrease in long -term contract receivable
12,862
12,367
Decrease in deferred receivable - Reserve Capacity
charge
4,535
----- - - - - --
5,108
----- - - - - --
Total Metropolitan Waste Control Commission
$17,397
----- - - - - --
$17,475
----- - - - - --
Total Sources of Working Capital
-----
$393,249
- - - - --
$396,982
----- - - - - --
Uses of Working Capital:
Addition to property and equipMent
36,095
----- - - - - --
(1,455)
----- - - - - --
Net Increase in Working Capital
$357,154
$398,437
Elements of Net Increase (Decrease) in Working Capital
Cash and Investments
363,232
468,514
Accounts receivable
(36,152)
(43,857)
Accounts payable
28,410
(26,547)
Accrued expenses
1,664
327
Due to other governmental units
Net Increase in Working Capital
-----
-----------
$357,154
- - - - --
$398,437
----- - - - - --
----- - - - - --
-112-
SEWER UTILITY FUND
SCHEDULE OF PROPERTY, EQUIPMENT AND
ACCUMULATED DEPRECIATION
Year Ended December 31, 1987
Land
Buildings
Improvements other than building
Machinery and equipment
Office furniture and equipment
Grand Total
-113-
Property and Equipment
------ - - - - -- --------------------------
Balances
1 -1 -87 Additions Transfers
------ - - - - -- --------------------------
$36, 586 $ - $
26,245 - -
2,475,155 - -
190,123 36,095 -
3,414 - -
------ - - - - -- ----- - - - - -- ----- - - - - --
$2,731,522 $36,095 $ -
Farm E -19
----- - - - - --
Balances
-------------------------------------------------
Balances
Depreciation
- - - - --
Balances
------- - - - - --
Net Assets
18 -31 -87
----- - - - - --
1 -1 -87
Taken Deductions
12 -31 -87
Value
$36,586
------ -------------------------------------------------
$ -
$ - $ -
$ -
------- - - - - --
$36,586
26,245
12,475
983 -
13,458
12,787
2,475,155
1,185,281
52,960 -
1,238,241
1,236,914
226,218
169,084
9,348 -
178,432
47,786
3,414
----- - - - - --
2,080
-------
512 -
2,592
822
$2,767,618
- - - - --
1,368,920
------- - - - - -- ------- - - - - --
$63,803 $ -
------- - - - - --
$1,432,723
------- - - - - --
$1,334,895
-114-
Farm E -20
REFUSE UTILITY FUND
COMPARATIVE BALANCE SHEET
December 31, 1987 and 1986
1987
ASSETS
Current Assets:
Cash and Investments
Accounts receivable:
Unbilled services
Other
Due Fm.Other Gov't Units
Total Current Assets
Property and Equipment
Improvements other than buildings
Machinery and equipment
Total
Less: Accumulated depreciation
Net property and Equipment
Total Assets
($36,015)
105,302
31,244
17,078
$117,609
1986
($48,353)
99,854
27,752
$79,253
2,890 -
175 -
-------- - - - - -- -------- - - - - --
3,065 -
99 -
-------- - - - - -- -------- - - - - --
2,966 -
-------- - - - - -- -------- - - - - --
$120, 575 $79,253
LIABILITIES, AND FUND EQUITY
Current Liabilities:
Accounts payable $23,116 $11,438
Accrued salaries and withholding payab - 294
-------- - - - - -- -------- - - - - --
Total Liabilities $23,116 $11,732
-------- - - - - -- -------- - - - - --
Fund equity:
Retained earnings
Reserved $2,000 $ -
Unreserved 95,459 67,521
-------- - - - - -- -------- - - - - --
Total Fund Equity $97,459 $67,521
-------- - - - - -- -------- - - - - --
Total Liabilities, and Fund Equity $120,575 $79,253
-115-
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
R
1
9
REFUSE UTILITY FUND
COMPARATIVE STATEMENT OF REVENUES AND EXPENDITURES
Years Ended December 31, 1987 and 1986
-116-
Farm E -21
1987
1986
Operating Revenues: --------
- - - - -- --------
- - - - --
Refuse Serv.Charge
$597,424
$489,348
Federal R State Grants
--------
28,202
- - - - -- --------
30,000
- - - - --
Total Operating Revenue
--------------
$625,626
$519,348
- - --
Operating Expenses:
Disposal - Service contract
525,436
416,930
Operating Expense:
Personal services
2,136
1,066
Other services and charges
6,903
18,264
Supplies -- -
- -
- - - -- 1,275
9,358
- - - - -- -
Total Operating Expenses
$537,750
$445,618
Operating Income Before Depreaciat
$87,876
$73,730
Depreciation
99
-
Operating Income
--------
$87,777
- - - - -- --------
$73,730
- - - - --
Nonoperating Revenues (Expenses).
Interest earnings - Trust Fund
-
-
Miscellaneous
-
1,005
- --
--------
Total $
- - - - -- --------
- - - -- -
- - -
------ $1,005-
--------
Net Income before transfers
-
$87,777
- - --
$74,735
- - - - --
--------
Operating Transfers Out
- - --------
73,794
29,846
Operating Transfers In
--------
15,955
- - - - -- --------
-
- - - - --
Net Transfers
$57,839
- -------
$29,846
------
Net Income
$29,938
$44,889
Retained Earnings at beginning of year
--------
67,521
- - - - -- --------
22,632
- - - - --
Retained Earnings at end of year
$97,459
$67,521
-116-
Farm E -21
REFUSE UTILITY FUND
COMPARATIVE STATEMENT OF CHANGES IN FINANCIAL POSITION
Years Ended December 31, 1987 and 1986
Source of Working Capital:
Operations:
Net income (loss) -- Form
Items not requiring (providing) working capital:
Depreciation
Total Sources of Working Capital
Uses of Working Capital:
Acquisition of property and equipment
Net Increase in Wanking Capital
Elements of Net Increase in Wanking Capital:
Cash
Accounts receivable
Accounts payable
Due Fm.Other Govt Units
Net Increase in Working Capital
-117-
Farm E -22
1987 1986
-------- - - - - -- -------- - - - - --
$29,938
$44,889
99
-
30,037
44,889
3,065
-------- - - - - -- --------
-
- - - - --
$26,972
-------- - - - - -- --------
$44,889
- - - - --
$12,338
$35,912
8,940
24,157.
(11,384)
(11,311)
17,078
-------- - - - - -- --------
(3,869)
- - - - --
$26, 972
-------- - - - - -- --------
$44,889
- - - - --
REFUSE UTILITY FUND
SCHEDULE OF PROPERTY, EQUIPMENT AND
ACCUMULATED DEPRECIATION
Year Ended December 31, 1987
Property and Equipment
Land
Buildings
Improvements other than buildings
Machinery and equipment
Office furniture and equipment
Grand Totals
Balances
1 -1 -87 Additions Deletions
--------------------------------- - - - - --
175 -
-------- - - - - -- -------- - - - - -- -------- - - - - --
$3,065 $ -
-------- - - - - -- -------- - - - - -- -------- - - - - --
-------------- -------- - - - - -- -------- - - - - --
-118-
1
1
1
------ - - - - -- --------------------------
Balances Balances Depreciation
12 -31 -87 1 -1 -87 Taken
------ - - - - -- --------------------------
' 2,890 - 96
' 175 - 3
------ - - - - -- ------ - - - - -- ----- - - - - --
' X3,065= $___________ $99-
1
Farm E -23
Accumulated Depreciation
------------------- - - - - -- ------ - - - - --
Balances Net Assets
Adjustments 12 -31 -87 Value
------------------- - - - - -- ------ - - - - --
96 2,794
3 172
------ - - - - -- ----- - - - - -- ------ - - - - --
-119-
INTERNAL SERVICE FUND
Central Garage Fund - To account for the costs of operating a
maintenance facility for automotive equipment used by other
city departments. Such costs are billed to other departments
at actual cost plus a fixed overhead factor. The automotive
equipment itself is acquired by the various user departments
which are responsible for financing replacement vehicles as
necessary.
Form F -1
CENTRAL GARAGE FUND
COMPARATIVE BALANCE SHEET
December 31, 1987 and 1986
`
1987
1986
ASSETS--------
- - - - -- --------
- - - - --
Current Assets:
Cash & Investments
$155,054
$132,207
Inventory, at cost
65,581
76,748
Accounts receivable
40
- - -- --------------
-
--------
Total Current Assets
--------
- -
$220,675
- - - - -- --------
$208,955
- - - - --
Property and Equipment:
Buildings and improvements
$25,027
$25,026
Office furniture and equipment
741
741
Machinery and equipment
77,097
- - - - -- --------
73,060
- - - - --
--------
Total
$102,865
$98,827
Less: Accumulated depreciation
--------
75,745
- - - - -- --------
70,977
- - - - --
Net Property and Equipment
$27,120
$27,850
--------
Total Assets
- - - - -- --------
$247,795
- - - - --
$236,805
LIABILITIES AND FUND EQUITY
Current Liabilities:
Accounts payable
$5,231
$14,325
Accrued salaries and withholding payable
20,103
--------
16,146
-
--------
Total Current Liabilities
--------
- - - - --
$25,334
- - - - -- --------
- - - --
$30,471
- - - - --
Fund Equity:
Contributed - other city funds
$94,653
$94,653
Retained earnings --------
- - - - -- --------
- - - - --
Reserved for improvements
$99 $
-
Unreserved
127,709
- - -- --------
111,681
-
--------
Total Retained Earnings
- -
$127,808
-
- - - --
$111,681
--------
Total Fund Equity
- - - -- --------
$222,461
- - - - --
$206,334
Total Liabilities and Fund Equity
$247,795
$236,805
-120-
CENTRAL GARAGE FUND
COMPARATIVE STATEMENT OF REVENUES, EXPENSES, AND CHANGES
IN RETAINED EARNINGS
Years Ended December 31, 1987 and 1986
Pilling to Departments
Operating Expense:
Mechanics labor
Other services and charges
Supplies
Total Operating Expense
Operating Income before depreciation
Less: Depreciation
Operating Income
Nonoperating Revenues (Expenses):
Sale of materials
Interest income
Total
Net Income before transfers
Operating Transfers Out
Net Income
Retained earnings, beginning of year
Retained Earnings End of Year
i
1987 1986
-------- - - - - -- -------- - - - - --
- - - -- $169,422 $169,131
- - -- -------- - - - - --
-121-
$89,647
38,746
20,951
$149,344
$20,078
5,168
$14,910
$1,442
-- -8,355
$9,797
$24,707
8580
16,127
111,681
$127,808
$83,119
45,802
8,648
$137,569
$31,562
5,450
$26,112
$475
- -10, 363
$10,838
$36,950
$36,950
74,731
$111,681
Foray F -2
CENTRAL GARAGE FUND
COMPARATIVE STATEMENT OF CHANGES IN FINANCIAL POSITION
Years Ended December 31, 1987 and 1986
Sources of Working Capital:
Operations:
Net income
Items riot requiring (providing) working capital:
Depreciation
Total Sources of Working Capital
Uses of Working Capital:
Acquisition of property and equipment
Increase in Working Capital
Elements of Increase in Working Capital:
Cash and Investments
Accounts receivable
Inventory
Accounts payable
Accrued expenses
Increase in Working Capital
-122-
Farm F -3
1987 1986
--- - - - - -- -------- - - - - --
$16,127
$36,950
4,768
-- - - - - -- --------
5,450
- - - - --
$20, 895
$42,400
4,038
-------- - - - - -- --------
12,826
- - - - --
$16,857
X29, 574
$22,847
$32,418
40
-
(i1,167)
3,811
9,094
(5,507)
(3,957)
-------- - - - - -- --------
(1,148)
- - - - --
$16,857
$29,574
CENTRAL GARAGE FUND
SCHEDULE OF PROPERTY, EQUIPMENT, AND ACCUMULATED DEPRECIATION
Year Ended December 31, 1987
Property and Equipment
------ - - - - -- ----------------------- - - - - -- ---------------
Balances Balances Balances
1 -1 -87 Additions 12 -31 -87 1 -1 -87
------ - - - - -- ----------------------- - - - - -- ---------------
Buildings $25,026 $ - $25,026 $8,868
Office Turn. and equip. 741 - 741 701
Machinery and equip. 73,060 4,038 77,098 61,408
------ - - - - -- -------- - - - - -- -------- - - - - -- -------- - - - - --
Total $98,827 $4,038 $102,865 $70,977
-123-
Farm F -4
Allowance for Depreciation
-------------------------------------- - - - - -- -------- - - - - --
Depreciation Balances Net Assets
Adjustments Taken 12 -31 -97 Value
-------------------------------------- - - - - -- -------- - - - - --
$ - $2,253 $11,121 $13,905
16 717 24
( 400) 2,899 63,907 13,191
-------- - - - - -- -------- - - - - -- -------- - - - - -- -------- - - - - --
S $400? $5,168 $75,745 $27,120
-124-
HOUSING AND
REDEVELOPMENT
AUTHORITY
Created in 1969, the Authoritv assists the city__in identifying
its needs in the areas of housing and community development,
A variety of programs are offered to city residents by the
Housing and Redevelopment Authority, including senior citizen
housing; rental assistance program; and low interest home
improvement loan and grant program and a single family mortgage
program to low income individuals or families.
I
s.
O
LL
-125-
I
11
1
1
M .+ t0 to U7
If1 M +�+ H7
CO T It7 c0 tD !
Q'� II
1
I
MaQ�CnM
tOt`tUlAttl6tL+AM
1
n II
I
I w w w w
w w w 1
w II
.,
I
m I
—v M M M A
c�- ,mMmra
-triln I
., If
>,
I
LT I
Cn
WM
(0 dr� -t -4 I
Cr 11
-+
I
I
W
4 ►+
N N tL 1
O
1
N N
ID
i
11
.I 3
i
1
••
I
If
m m I
I
It co r- - kilcuANCb
-'N
coM1f) A40 1
4 II
+2 C I
1
,- 4"kuNI-I-I-a0a0m14
c0 #,-14 4 G 1
M 11
O m 1
I
6 M �+ '" En co
CU -9 r,- eu
tD m kn AD -+ I
U7 11
!-' I
h I
w w w w w
w w w w w
.
w w w w w I
w 11
G I
c0 I
coMd4 +- �^+CntiLI-MCntn4fv)M
t
a u
a I
Cn I
-+ --
G u7 N
W t.O l- s -. 1
CC e
a I
-+ I
m
W
N N cu 1.4t
II
1
H
I
(1J N I
W
1
I
I
iF 11
It 6 I
11
1
S.
I
If
I
m
a
I
I I 1 I I I
1 I I I I
1 I I t0 �+ 1
1", 11
S.
1
Tirol
NO it
N I
C
[n
at I
't -+ 1
0 11
a I
a
c
A I
N I
N 11
01CDJ
1
N Icu11
S.
C�
(9 I
z
+i i I
Cp M p7 I
kn 11
CJ
C I
1
c9 n ko I
N 11
1
m
Ut I
I 1 I 1 I I
I I I I 1
t0 M W I I I
r 11
im
x
uiaXmi
cnIna
U I
S:
•M
N 1
W I` 16
11
a
a
LL
A
ku lU I
`° 11
1
CD
1,
G4
t
I
Cu I
N 11
I
I
I
IB II
M
to
I
G
IA 1
+
III I
�S i I I T M
I -T 't I N
1 I 1 1 I
N If
U
o
b I
sa
V
Tr w In
" In 40
I
U7 11
F-• a
C I
-
:;:,
4 on
Ch as N
I
u w 11
LL
CO
z I
i
cl
w w w
W
O
W h
LL I
a>
i
CC.
W m M
1
m II
T I- co
I
a
a i
N
Go -9'•
1
t0 11
>
Ul z Cn
+� I
In
m I
M
ul
I
m 11
O"
1
1
0
1
0 11
►~-�
W
of
cr
U U w
E I
I
�►
I
II
O
zU+-+
C 1
1
4 Anr-r-m0Aas
1
1 1 1 1 1 1
N 11
Z
a(Irl
S. I
m I
6 11
F-
J
a I
S, I
CnM r+*�117CT
NN1l7n
I
V7 II
Q A S.
> 1
a 1
w w
w w w
a
tLZ a
O 1
C I
mMa a
NNn
I
c0 If
a s
Co I
a I
m
N N
I
a 11
r•-
A s
I
C7 I
d
++
I
W II
I
I
iR
I
1F
W
z W u II
E
"u a
of
J
D
Of
W
U A
N
>
z
++ .4
W
=1
m to
A
LL.
of
W
V 70
J
F? 4;-
� c
a
I a
0.
z
N
r 8
�-+
x
O O
•, +A
U►
m
S.
T
++
o N O 0
> r
of
a w 4-
••, a
S to
as
a10 v
to
aio
zm'a
4 m a s
u
m
C S.•.,4-1
> C
74A .1•ti
N
all D 11
0 7 at
S. x >>
IA
6 !n N a m m
GI 4- a U
+y rq O O
a
+� a s >>
a .q C
m 4- L S.
m x x .+ •.+
IA s S. 1Q m
a Cl.
III m m S. a a
C a a in S.
12
m
> 4, -P O D U
a t > L
c a a
S: 4- a a
a 4 r N
m to 4.0
O
S S,
O O
A
~
of C a
41 u
IA a O O
�4.% a U IA-P
a
cn S.+A -P
to I
C 4a h C -P W
12 O i+ io
C=
F- 1
mti m r at
S.
•14 4;1 4-h-P
W I
$ 3 Z S.
m w 4. IA m
ZI ••+ C C
O O a
a !C n.
M s s
N 1
ILA L 1-+ -9 U ++
OI a s 4 a
C •+ S G O
a 1
U:3Aaa�-C+ao6
-1 a
JIi1LL.aa
-125-
L7
O
LL
N
H
W �+
2 �D
G �
.ti y
C
O V
LL W to
O = _ CD
>- In O tT
t- a -�
�+ w co
2 a 2 M
a COof
? 2 Of
W U W
> a
a �
a
LL
J
� a
N 1
p 1
G I
g1
�• I
I
lA
CL
G
C9
U
u
a
N I
7 II
LL
C
O1
I
I
d
t;
-126-
1j
14 I co
M
I
S- +MM�nIniU,
n 1
tG 1
nCU6—
I S I
t0 N
10 I Ct
I
tD VId'd'nmtuInla
M I
O 1
MmV]CU
I Im I
n 11
S 1
tD 16
11
S. I CU I
In
I M
1 I
I
co 1
CU M r+ S CU -+ M
In I
M I
� f
1 1 1
QI N
c I I IT
MI► ~
-y
1
�
`a 1
4 I
N N
I
ta I
In t0 -" CU
1 In I
. If
I N I
I
I
CU
I'
CV I
IN
I M 1�,
N
I
1
t0 II
1
I
1 I
VAN
I
S -' m C1 co 6 CU 6 '
I
tD I
to S to to I
cc I
A q
I
InW15In4 (4) in -T
6r I
M 1
tLCU64
I T 1
M N
1
int 4pinMM�+N14
^+ 1
In I
nm01Vf
I Ct 1
In N
n l
m l
w w w w w w w w
nM�- +tunM -+M
w I
M I
w I
U1 I
w w w
mdVl�
I w 1
11
w N
t o
Qt I
M -+ V] -4 Ot 4t
-4 I
n l
6 VI S M
I I
I
cc N
1
0 CU
I
ca I
tII to -+ CU
I 1-t
N
4A
m CL to
CU
N I
CU
I M 1
tl► q
1
LL
I
I
1
6 I
1
1
1 1
I 1
II
h
If
c
01 ti
y
a
W
L I
1 1 I 1 1 I 1 1 M
M 1
t0 I
I I 1 1
I I I
1 11
O
pt of 1
-+ 1
V] 1
>:
1 1
11
0
A
to
1
n. I
I I
If
v I
J 1
Al
I
to 1
U
1 1
II
4A
of
c
I
I y► 1�
II
1
I
I
I
I
1
1
II
CU
d I
4A
I
tL
CU II
10 1 IA
?
.0
•�
i
t i
n ii
d
X m l
I I I 1 I I I I I
I I
1 1
LT I I I I�
1
Q1 II
I
I
11
II
0a1
LL N I
c
Ai
tSL
t6G
C7
a I
.4
I
I
w I
to 1
w l
1
w l)
0 11
Z I
1
y0
1
1
>,
DI ++
III
.+ 01 1
CU4toOtT6NG
I
ni I
Stogy
16 I
{U II
i0 7 1
InwnMnM —V)
I
td 1
�y I
CT I
In 11
LL I W
�+ C I
d
I
V] I
1 Ch 01 �'
1 m I
In 11
Ej 01 I
w w w w w
I
w I
w w
>
U
7
a 01 I
M M .+ Q1
I
C1 I
d 6 M I
n I
w II
1 •, •.,
En tx
4A -T
1
0 1
o I
M I
M 11
1
01
1 1A
a14•
01 v
-126-
1j
14 I co
M
1 Is 1
6
ni I
CU I
CU
10 I Ct
M
c0
1 CU 1
co
S 1
tD 16
11
S. I CU I
In
I M
1 I
I
1
I I CU I
I t9 1
It 1
CU I
In N
c I I IT
.;
I r; 1
�
`a 1
i
s ii
III
CU
I N I
I
td
I
to I
t0 II
I
I I
1
1
M II
i�
•p
UOI 01
�
++ 01
4A
m CL to
10
G
LL
G
OBI S
c
01 ti
y
a
a
14 m m
+ a
> 1
S.
>:
4- V S.
Id to
U
III
N CL
4A
of
c
d I
4A
A
C
?
.0
•�
C O
.,
u 4-
�'
a'>�z
w
c
Ai
%
.4
-11
Z I
la
t0
>,
DI ++
III
O I
01
S. N
d
++
t0
G z
01
„ f.
LL I W
7c
d
to
C U 4-
a
Q
d +�
10
>
v m
7
J
li
J
1 •, •.,
v
G �
IA
i i
01
1 1A
a14•
01 v
C
a
u1 O O
••
••
t .+
•M
01
d IY
t0
+t 4. 4-
10
10
+0 A
I >, a
0
i L
of
>
�•M
4A
y
+>
i
O I m 01
to
of a+A
•+
41
.0
O
>+ lo m
>
S.
O
G
G en
01
W I a 1
t L
C 11
i
41
IA I-
y 01 a
I.-
I-I L4 >,
►-41 v -t
�+�mml�
.r+ma+bC
�as_s,a
c00mm
to
d•�
J 1 !
A
O G
IN
L
41
d
W>
W 1 G 7
7
S. III
01
01 •.,
W
L }•,
10
a I U u
to
01 at
U t
4-
v ++
r-+1 umczzu-
pamomm
mot
J I am
- +AAa02w
LL
m
-126-
HOUSING AND REDEVELOPMENT AUTHORITY OF COLUMBIA HEIGHTS
COMBINED STATEMENT OF REVENUES, EXPENDITURES
AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL
Year Ended December 31, 1987
Revenues:
Taxes
Rents
Community development black grant
Housing and urban development
Grant draw downs
Project reimbursement
Interest
Miscellaneous
Total Revenues
Expenditures:
Administration
Utilities, maintenance and operations
Loans and grants
Property acquisition /improvements
Relocation assistance
Legal.
Interest
Development costs
Miscellaneous
Total Expenditures
Other Sources and Uses:
Increase in note principal
Excess (deficiency) of Revenues and Other
Sources over Expenditures and Other Uses
Fund balance at beginning of year
Fund balance at end of year
The notes to the financial statement
are an integral part of this statement
-127-
General Fund
$4,423 $6,948 $2,525
1,454 1,454 -
--- - - - - -- --- - - - - -- ------- - --- --
$5,877 $8,402 $2,525
Variance
Favorable
Budget
--
Actual
--- - - - - --
(Unfavorable)
------- - - - - --
--- - - - -
$35,803
$35,891
$88
25,300
29,476
4,176
33,210
36,214
- --
3,004
------- - - - - --
--- - - - - --
$94,313
--- - - - - --
--- - - -
$101,581
--- - - - - --
$7,268
------- - - - - --
89,890
94,610
(4,720)
-
23
(23)
--- - - - - --
$89,890
--- - - - - --
--- - - - - --
$94,633
--- - - - - --
------- - - - - --
($4,743)
------- - - - - --
$4,423 $6,948 $2,525
1,454 1,454 -
--- - - - - -- --- - - - - -- ------- - --- --
$5,877 $8,402 $2,525
Farm G -2
-129-
Totals
--------------------------------
Special Revenue
Fund
- - - - --
(Memorandum Only)
-----------------------------------
Variance
Variance
Favorable
Favorable
Budget
Actual
(Unfavorable)
Budget
Actual (Unfavorable)
----- - - - - --
-
----- - - - - --
-
------- - - - - --
-
--- - - - - --
$35,803
----- - - - - --
$35,891v/,/,
35, 891
----- - - -
$88
$160,800
$171,167
$10,367
160,800
171,167----
71, 167 ✓
10,367
-
106,677
106,677
-
106,677✓
106,677
-
187,415
187,415
-
187,415 ✓
187,415
55,;-90
-
(55, 290)
55,290
-
(55, 290)
-
1,055,146
1,055,146
-
1,055,146
1,055,146
8,000
11,483
3,483
33,300
40,959
7,659
3,400
----- - - - - --
8,198
----- - - - - --
4,798
------- - - - - --
36,610
--- - - - - --
44, 412 ✓
----- - - - - -- -------
7,802
- - - - --
$227, 490
----- - - - - --
$1,540,086
----- - - - - --
$1,312,596
------- - - - - --
$321,803
--- - - - - --
$1, 641, 667
----- - - - - -- -------
$1,319,864
- - - - --
90,440
98,777
(8,337)
180,330
193,387
(13, 057)
156,460
127,137
29,323
156,460
127,137
29,323
-
18,107
(18, 107)
-
18,107
(18,107)
-
890,945
(890, 945)
-
890,945
(890, 945)
-
84,600
(84, 600)
-
84,600
(84,600)
-
38,125
(38, 125)
-
38,148
(38, 148)
-
154,452
(154, 452)
-
154,452
(154, 452)
29,200
20,190
9,010
29,200
20,190
9,010
-
851965
(85,965)
-
85,965
(85,965)
----- - - - - --
$276,100
----- - - - - --
$1,518,298
------- - - - - --
($1,242,198)
--- - - - - --
$365,990
----- - - - - -- -- - - - - --
$1,612,931 ($1,246,941)
----- - - - - --
----- - - - - --
------- - - - - --
--- - - - - --
----- - - - - -- -------
- - - - --
-----------
($48,610)
----- - - - - --
$21,788
------- - - - - --
$70,398
--- - - - - --
($44,187)
----- - - - - -- -------
$28,736
- - - - --
$72,923
356,202
356,202
-
357,656
--- - - - - --
357,656
----- - - - - -- -------
-
- - - - --
----- - - - - --
$307, 592
----- - - - - --
$377,990
----- --------
$70,398
$313,469
$386,392
$72,923
-129-
HOUSING AND REDEVELOPMENT AUTHORITY
OF COLUMBIA HEIGHTS, MINNESOTA
COMBINING BALANCE SHEET
SPECIAL REVENUE FUNDS
December 31, 1987
With Comparative Totals for December 31, 1986
ASSETS
Cash and investments
Accounts receivable
Interest receivable
Due from other governments
Due from other funds
Prepaid insurance
Total Assets
LIABILITIES AND FUND EQUITY
Liabilities:
Accounts payable
Security deposits
Insurance and taxes in escrow
Deferred revenue
Due to other governments
Due to other funds
Accrued interest payable
Deferred revenues
Other liabilities
Total Liabilities
Fund Equity:
Reserved for Community Development
Reserved for future operations
Unreserved
Total Fund Equity
Total Liabilities and
Fund Equity
Anoka County
$9,050
$23,023 $179
Community
Downtown
Low - Income
Development
Development
Housing
Block Grant
Fund
----- - - - - --
Fund
----- - - - - --
Fund
------ - - - - --
$146,776
$132,110
$49,214
469
-
-
-
953
-
2,594
562,244
22,076
48,766
1,088
-
-
3,262
-
- - - - --
----- - - - - --
$198,605
----- - - - - --
$699,657
------
$71,290
$9,050
$23,023 $179
-
3,664 -
876
- -
-
i i , 599 -
- 30,979
-
417,330 -
91,750
- -
-
3,112 -
------ - - - - --
----- - - - - --
$101,676
----- - - - - --
----- - - - - --
$458,728 $31,158
----- - - - - -- ------ - - - - --
- 41,940
- 105,906 -
96,929 135,023 (1,808)
----- - - - - -- ----- - - - - -- ------ - - - - --
$96,929 $240,929 $40,132
----- - - - - -- ----- - - - - -- ------ - - - - --
$198,605 $699,657 $71,290
-129-
Farm G -3
Totals
-------------- - - - - --
1987 1986
--- - - - - -- --- - - - - --
$328,100
$235,322
469
37,429
953
-
586,914
382,566
49,854
48,783
3,262
--- - - - - --
3,555
--- - - - - --
$969, 552
$707,655
$32,252
$ 30, 191
m 3,664
3,514
876
1,237
-
1,929
11,599
9,971
30,979
41,474
417,330
262,878
91,750
-
3,112
259
$591,562
--- -- - - --
$351,453
- -- - - - - --
41,940
41,940
105,906
104,500
230,144
209,762
$377,990 $356,202
--- - - - - -- -- - - - - --
$969,552 $707,655
-130-
HOUSING AND REDEVELOPMENT AUTHORITY
OF COLUMBIA HEIGHTS, MINNESOTA
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND
CHANGES IN FUND BALANCE
SPECIAL REVENUE FUNDS
Year Ended December 31, 1987
With Comparative Totals for Year Ended December 31, 1986
Anoka County
-131-
Community
Downtown
Low - Income
Development
Development
Housing
Black Grant
Fund
Fund
Fund
Revenues:
----- - - - - --
----- - - - - --
------ - - - - --
Rents
-
$171,167
-
Community Development Black Grant
-
-
106,677
Housing and urban developments
-
187,415
-
Obligation band proceeds
Grant draw dawns
-
-
-
Project reimbursement
1,055,146
-
-
Interest
2,625
6,273
2,585
Miscellaneous
4,462
----- - - - - --
3,736
----- - - - - --
-
------ - - - - --
Total Revenues
$1,062,233
----- - - - - --
$368,591
----- - - - - --
$109,262
------ - - - - --
Expenditures:
Administration
$59,150
$32,629
$6,998
Utilitites, maintenance amd operations -
127,137
-
Loans and grants
-
-
18,107
Property acquisition /improvement
890,945
-
-
Relocation assistance
84,600
-
-
Legal
38,125
-
-
Principal reduction
-
-
-
Interest
-
154,452
-
Development costs
-
20,190
-
Miscellaneous
-
-
85,965
Total Expenditures
----- - - - - --
$1,072,820
----- - - - - --
----- - - - - --
$334,408
----- - - - - --
------ - - - - --
$111,070
------ - - - - --
Other Sources and Uses:
Increase in note principal
-
- - --
-
- - - -
-
Excess of Revenues and Other Sources
----- - -
----- --
------ - - - - --
Over (Under) Expenditures and Other
Uses ($10,587)
$34,183
Fund balance at beginning of year
107,516
206,746
41,940
Fund balance at end of year
----- - - - - --
$96,929
----- - - - - --
$240,929
------ - - - - --
$40,132
-131-
Farm G -4
Totals
------------------ - - - - --
1987
1986
----- - - - - --
$171,167
----- - - - - --
$159,077
106,677
57,814
167,415
187,415
-
1,413,694
1,055,146
-
11,483
16,473
8,198
----- - - - - --
46,989
----- - - - - --
#.1 �'w O86
----- - - - - --
----- - - - - --
$96,777
$79,019
127,137
141,856
18,107
18,129
890,945
1,360,852
84,600
5,825
38,125
-
154,452
287,527
20,190
73,307
85,965
33,308
$1,518,298 $1,999,823
----- - - - - -- ---- - - - - --
24,649
----- - - - - -- ----- - - - - --
$21,788 ($93,712)
356,202 449,914
----- - - - - -- ----- - - - - --
$377, 990 $356,202
-132-
GENERAL FIXED ASSETS
GROUP OF ACCOUNTS
General fixed assets are those fixed assets and capital
additions of the city which are not accounted for in
proprietary funds.
STATEMENT OF GENERAL FIXED ASSETS
December 31, 1987
General Fixed Assets:
Land
Buildings
Improvements other than buildings
Office furniture and equipment
Machinery and equipment i
Total
Investment in General Fixed Assets:
General obligation bonds:
Library bonds of 1966
Municipal building bonds of 1959
Park bonds of 1962
City garage bands of 1972
Capital improvement bands of 1976
Total General Obligation Bonds
Grants:
Federal E. D. A. and H. U. D.
State
Total Grants
Revenue Sharing:
Federal
Anoka County
Total Revenue Sharing
Balance from current revenues and contributions
Total Investments in General Fixed Assets
-133-
Form H -1
$3,028,500
2,794,279
732,945
873,324
1,624,114
$9,053,162
$90,000
150,000
325,000
510,000
929,475
$2,004,475
$526,290
267,203
$793,493
$1,680,577
51,550
$1,732,127
$4,523,067
$9,053,162
GENERAL LOIG -TERM DEBT
GROUP OF ACCOUNTS
This self balancing account group is used to account for all
long -term debt which is backed by the full faith and credit
of the city and other long -term debt which is secured by
general fund revenues.
STATEMENT OF GENERAL LONG -TERM DEBT
December 31, 1987
AMOUNT AVAILABLE AND TO BE PROVIDED FOR THE
PAYMENT OF GENERAL LONG -TERM DEBT
Arnaunt available in debt service funds
Amount to be provided for retirement of:
Long Term Debt
Vacation and Sick Leave Payable
GENERAL LONG -TERM DEBT PAYABLE
General obligation bands payable
Vacation and sick leave payable
-134-
$13,141,901
$9,988,099
282,466
$23,412,466
$23,130,000
282,466
$23,412,466
Form I -1
SCHEDULE OF FUNDING AVAILABLE
AND FUNDS REQUIRED
December 31, 1987
Cash and Investments
Cash in escrow
Total
Levy /Payable Years;
1987/88
1988/69
1989/90
1990/91
1991/92
1992/93
1993/94
1994/95
1995/,96
1996/97
1997/98
1998/99
1999/00
2000/01
2001/02
Total
FUNDING AVAILABLE
Bands /Future Interest Payable
----------------------- - - - - --
Bonds
Future Interest
FUNDS REQUIRED
BALANCE
-135-
Total
$4,278,401
8,863,500
13, 141, 901
2,370,936
2,394,280
2,406,398
2,084,904
1,937,820
1,920,540
1,895,913
1,813,080
1,502,058
1,435,545
1,209,865
1,112,305
1,015,975
925,750
254,188
$24,279,557
$37,421,458
$23,130,000
9,874,557
$33,004,557
$4,416,901
Farm I -2
Form I -3
SCEDULE OF DEBT SERVICE REQUIREMENTS TO MATURITY
-136-
December 31, 1987
General
Obligation
-----------------------------------
Bonds
Principal
Interest
1988
$645,000
$1,725,936
1989
715,000
1,679,280
1990
7,705,000
1,626,398
1991
2,895,000
989,904
1992
1,180,000
757,820
1993
1,245,000
675,540
1994
1,310,000
585,913
1995
1,320,000
493,080
1996
1,095,000
407,058
1997
1,110,000
325,545
1998
960,000
249,865
1999
930,000
182,305
2000
900,000
115,975
2001
875,000
50,750
2002
245,000
------- - - - - --
9,188
------- - - - - --
$23,130,000
------- - - - - --
-------------
$9,874,557
------- - - - - --
------- - - - - --
-136-
STATISTICAL SECTION
ASSESSED VALUE
AND MARKET VALUE
OF ALL TAXABLE PROPERTY
LEVY YEARS 1977 Through 1986
,
1978
1979
1980
1981
Population
---- - - - - --
------- - - - - --
21,300
------- - - - - --
------- - - - - --
21,270
------- - - - - --
------ ' - - - - --
20,029
------- - - - - --
------- - - - - --
19, 800
------- - - - - --
'
Real- Property
'
Assessed Value
$71,601,406
$73,741,181
$85,721,087
$96,391,052
Area -wide alloc.
------- - - - - --
------- - - - - --
------- - - - - --
------- - - - - --
Contribution
($1,491,381)
($1,840,970)
($2,000,000)
($3,908,286)
,
Distribution
$4, 062, 894
$4,062,894
$4,383,409
$8,183,307
------- - - - - --
Market Value
------- - - - - --
$288,414,300
------ - ------
$355,767,800
------- - - - - --
$399,395,650
$430,688,578
Personal Property
--- - - - - -- -
--- - - - - -- -
--- - - - - -- -
- - - -- -
'
Assessed Value
$1,221,501
$1,218,792
$1,295,504
$1,344,094
Market-commercial
------- - - - - --
$2,840,700
- - - - --
------- - - - - --
$2,834,400
------- - - - - --
------- - - - - --
$3,012,800
------- - - - - --
-------------
--$3,125,800 -
'
Total Real and Per-
-------
----- --------
sonal Property - - --
�'
Assessed Value
$74,642,528
$77,181,897
$89,400,000
$102,010,167
'
Market Value
$251,741,743
$291,248,700
$358,780,600
$402,521,450
Ratio Total- Assess-
------- - - - - --
-------------
------- - - - - --
------- - - - - --
------- - - - - --
------- - - - - --
'
-of-
ed Value to Total
--------------- --
Market Value
:3504
:2650
:2492
:2534
Per Capita Valuations
--------------- - - - - --
'
Assessed Value
3,504
3,629
4,563
5,152
------- - - - - --
------- - - - - --
13,693
------- - - - - --
17,913
20,329
'
Market Value
11,819
------- - - - - --
------- - - - - --
------- - - - - --
------- - - - - --
-137-
,
1982
------- - - -
1983
1984
- --
19,670
------- - - - - --
------- - - - - --
19,560
------- - - - - --
------- - - - - --
19,530
------- - - - - --
$104,783,933
------- - - - - --
$ 105, 913, 390
------- - - - - --
$108,671,288
----=-- - - - - --
($4,487,006)
($5,178,793)
( $4, 695, 234 )
$10,544,639
------- - - - - --
$12,001,080
------- - - - - --
$13,663,552
------- - - --
$445,177,400
------- - - - - --
$455,177,400
------- - - - - --
- -
$462,786,700
------- - - -
$1,333,301
------- - - - - --
$1,426,869
------- - - - - --
- --
$1,426,869
------- - - - - --
$3,100,700
------- - - - - --
$3,318,300
------- - - - - --
$3,414,600
------- - - - - --
Table I
1985
--
1986
1987
------- - - - -
19,540
------- - - - - --
------- - - - - --
19,426
------- - - - - --
------ - - - - --
19,430
------ - - - - --
$113,721,411
------- - - - - --
$ 114, 767, 361
------- - - - - --
$116,314,660
------ - - - - --
($4,407,361)
($5,778,163)
($5, 180, 460
$14,264,696
------- - - - - --
$15,650,911
------- - - - - --
$ 17, 871, 259
------ - - - - --
$476,771,500
------- - - - - --
$484,669,200
------- - - - - --
$507,684,800
------ - - - - --
$1,500,988
------- - - - - --
$1, 547, 299
------- - - - - --
$1,679,868
------ - - - - --
$3,511,600
------- - - - - --
$3,619,300
------- - - - - --
$3,927,600
------ - - - - --
$112,174,867
$114,162,!46
$ 119, 107, 884
$125,079,734
$126,187,395
$130,685,327
$433,789,278
$448,495,700
$465,201,300
$480,283,100
$488,288,500
$511,612,400
:2586
:545
:2560
:2604
:2584
:2554
5,702
5,837
6, 099
6,398
6,496
6,726
22,053
------- - - - - -- -------
22,929
- - - - -- -------
23,820
- - - - -- -------
24,579
- - - - -- -------
25,136
- - - - -- ------
26,33-A
- - - - --
-138-
Table II
TAX RATES
Years 1978 Through 1987
Fiscal
Year
--- - - - - --
City
--- - - - - --
School
--- - - - - --
County
--- - - - - --
Metro
--- - - - - --
Other(A)
--- - - - - --
Total
-- - - - - --
1978
22.13
46.53
22.02
2.73
0.59
94.00
1979
21.847
45.036
21.913
2.913
0.923
92.632
1985
21.101
46.727
23.349
2.990
0.839
95.006
1981
18.153
41.483
25.005
3.832
0.771
89.244
1982
17.303
48.266
24.085
3.556
0.747
93.957
1983
1 S. 438
50.156
24.492
3.877
0.576
94.539
1984
16.610
56.227
26.088
4.197
0.944
104.066
1985
16.300
50.487
23.868
4.250
1.048
95.953
1986
16.420
53.797
25.537
3.574
1.330
100.658
1987
19.472
63.234
29.414
4.223
1.136
117.479
(A) Rice Creek Watershed, Mosquito Control and 113 mill for the Housing
and Redevelopment Authority
-139-
Table III
CITY TAX LEVY
Years 1978 Through 1987
(A) In 1979 Civil Defense Fund became a part of the General Fund.
-140-
City
Rands
Fiscal
Levy
General
Police
Fire
Civil and
Year
--- - - - - --
Total
---- - - - - --
Fund
---- - - - - --
Relief
--- - - - - --
Relief
--- - - - - --
Defense (A) Interest
--- - - - - -- -- - - - - --
1978
1,583,156
1,188,556
78,500
r
47,000
8,600 260,500
1979
1,631,608
1,261,108
78,500
47,000
245,000
1980
1,631,608
1,151,808
104,000
85,800
290,000
1981
1,631,608
1,245,106
64,500
47,000
275,000
1982
1,759,284
1,356,029
125,305
57,950
220,000
1983
1,740,623
1,453,033
92,155
55,435
140,000
1984
1,757,487
1,617,500
77,313
62,673
1985
1,825,192
1,662,532
79,700
82,960
1986
1,886,616
1,725,956
79,700
82,960
1987
2,181,115
2,008,455
89,700
82,960
(A) In 1979 Civil Defense Fund became a part of the General Fund.
-140-
-141-
TAX
LEVIES AND TAX COLLECTIONS
Years 1978
Through 1987
Years 1978 Through
1987
Percentage of
'
Current Special
Collections
Percentage
Collection
Current Special
During Fiscal
Period
--- - - - - --
During Fiscal Period
---------------------- - - - - --
of Current
of Levy
of Prior
107,635
'
63.2%
1979
Years Taxes
Collected
Year's Taxes
1980
129,773
Year
Total Tax
During Fiscal
During Fiscal During Fiscal
Total
54.0%
Collected
--- - - - - --
Levy*
--- - - - - --
Period - --
-- - - - - --
Period
- - --
Year
- - - - - --
Collections
----- - - - - --
'
1978
1,220,013
1,186,640
97.3
16,687
1,203,327
236,686
1979
1,253,698
1,236,676
98.6
20,648
1,257,324
,
1980
1,150,273
1,122,161
97.6
21,268
1,143,429
1981
1,090,455
1,074,134
98.5
39,938
1, 114, 072
1982
1,262,780
1,236,497
97.9
19,120
1,255,617
1983
1; 249,.602
1,206,840
97.4
26,702
1,235,542
,
1984
1,285,324
1,253,906
97.6
210,640
1,274,548
1985
1,286,626
1,256,387
97.6
25,184
1,281,571
1986
1,388,616
1,357,255
97.7
15,494
1,372,749
,
1987
1,621,193
1,577,599
97.3
41,633
1,619,232
* Tax levy
has been adjusted
by the Homestead Credit
(Property tax replacement)
'
which
is a revenue
from other agencies
and has been
incorporated into Table VI.
-141-
SPECIAL ASSESSMENT
COLLECTIONS
Years 1978
Through 1987
Percentage of
Current Special
Current Collected
Fiscal
Assessment Becoming Due
Current Special
During Fiscal
Period
--- - - - - --
During Fiscal Period
---------------------- - - - - --
Assessments Collected
-------------- - - - - --
Period
---------------------
1978
107,635
68,029
63.2%
1979
160,087
110,534
69.0%
1980
129,773
70,627
54.4%
1981
190,708
102,985
54.0%
1982
217,927
107,932
49.5%
1983
285,780
150,561
52.7%
1984
299,748
186,870
62.3%
1 985
236,686
126,759
53.6%
1986
179,812
99,342
55.2%
1987
165,293
110,318
66.7%
-141-
Ratio
of Total
Collections
To Tax Levy
Accumulated
Delinquent
Taxes
Ratio
Accumulated
Delinquent
Taxes to
Current Year
Tax Levy
.9863:1
64, 287
.0527 :1
1.0029:1
31,977
.0255:1
.9940:1 -
18,864
.0163:1
1.0217 :1
25,547
.0234 :1.
.9943:1
12,888
.0102 :1
. 9959:1
49,644
.0400:1
. 9916:1
36,290
.02823:1
. 9961 :1
51,764
.04023:1
.9886:1
53,140
.03827 :1
.9988-.1
55,101
.03400 :1
Delinquent Specials Total Special
Collected During Assessments Delinquent
Fiscal period (A) At End of Fiscal period
-------- - - - - -- ----------------- - - - - --
Table IV
Table V
Deferred Special Assessments
Collected Balance Fund
Fiscal period of Fiscal period
---------------------------- - - - - --
46,218
66,142
155,037
436,962
43,693
71,605
78,080
411,494
41,215
87,512
136,281
602,047
70,016
111,314
287,194
509,999
94,298
94,702
301,367
1,335,493
130,298
152,744
313,682
1,048,215
119,372
154,154
236,474
857,906
140,515
132,031
92,257
640,691
118,938
110,886
223,656
697,945
86,741
108,729
236,510
616,994
(A) The City bills
the property owner directly when a special assessment
installment becomes
due. If the installment
becomes delinquent,
it is certified
to the county
for inclusion on the following
years property tax
statement and
is shown as a
delinquent collection.
-142-
Table VI 1
EXPENDITURES FOR SELECTED FUNCTIONS
Years 1978 Through 1987
(B)
Fiscal General Public Public Sani
Year Government Safety Works tation
- - - - - -- -------- - - - - -- ---- - - - - -- ------- - - - - -- ----- - - - - --
Table VII '
Parks and '
Library Recreation
----- - - - - -- ------- - - - - --
1978
424,527
1,070,279
606,541
246,957
121,968
1979
'
1,160,243
515,417
REVENUES -OTHER
THAN PROPERTY TAXES
1980
516,593
1, 315, 8.26
566,643
268,793
163,801
AND SPECIAL
ASSESSMENTS
1,380,692
576,754
336,997
188,440
1982
536,804
Years 1978
Through 1987
403,670
188,343
1983
,
1,537,897
561,632
431B,126
Charges for
Licenses
563,717
1,654,871
645,265
Fiscal
Revenues from
Use of Money
Service and
and
Fines and
Profits of
221,532
Year
- - - - - --
Other Agencies
-------- - - - - --
and Property
---- - - - - --
Other Revenue
------- - - - - --
Permits
----- - - - - --
Forfeitures
----- - - - - --
Proprietaries
------- - - - - --
'
1978
2,059,462
135,292
313,456
76,870
38,191
106,014
,
1979
2,096,084
179,135
369,891
78,164
49,067
32,521
1980
2,272,119
474,873
419,930
68,710
72,274
106,845
1981
2,857,636
966,078
997,236
104,027
67,301
835, 981
1982
2,310,131
545,881
1,248,375
148,773
47,073
444,962
'
1983
2,990,623
530,037
1,009,358
156,410
51,870
693,691
1984
2,470,131
602,397
802,756
215,942
51,00-3
694,436
1985
2,625,357
645,183
637,192
139,470
104,741
675,137
'
1986
2,683,485
616,933
606,552
187,809
108,158
813,109
1987
2,897,602
814,115
497,761
131,351
123,813
900,529
EXPENDITURES FOR SELECTED FUNCTIONS
Years 1978 Through 1987
(B)
Fiscal General Public Public Sani
Year Government Safety Works tation
- - - - - -- -------- - - - - -- ---- - - - - -- ------- - - - - -- ----- - - - - --
Table VII '
Parks and '
Library Recreation
----- - - - - -- ------- - - - - --
1978
424,527
1,070,279
606,541
246,957
121,968
1979
460,152
1,160,243
515,417
255,693
143,018
1980
516,593
1, 315, 8.26
566,643
268,793
163,801
1981
538,618
1,380,692
576,754
336,997
188,440
1982
536,804
1,454,404
581,121
403,670
188,343
1983
548,977
1,537,897
561,632
431B,126
265,803
1984
563,717
1,654,871
645,265
450,010
212,379
1985
832,847
1,776,721
702,942
4,097
221,532
1986
885,343
1,885,654
630,925
4,932
263,650
1987
919,991
1,915,895
704,081
8,950
261,583
(B) The Years 1978 -1984 include Refuse Collection and Disposal
676,027 ,
547,525
622,154 '
652,611
634,395
625,030
753,430 '
790,446
866,682
1,001,069 '
-143- 11
1
' STATEMENT OF LEGAL DEBT MARGIN
December 31, 1987
Assessed Value
' Debt Limit 7 -1 /3% of Assessed Value (Note A)
' Amount of Debt Limit Applicable to Debt Limit:
Total bonded debt
Less Note B:
Tax Increment 20, 900, 000
'
60 Refunding Improvement 2,230,000
- -
Total Debt Applicable to Debt Limit
23, 130, 000
14, 405, 000
Table VIII
130, 685, 327
9,583,590
-0-
Legal Debt Margin 9,583,590
'Note 1A):
M.S.A. Section 475.53 (Limit on Net Debt)
Subdivision 1. Generally. Except as otherwise provided in sections 475.51 to
to 475.75, no municipality, except a school district or a city of the
' first class, shall incur or be subject to a net debt in excess of 7 -1/3
percent of the assessed value."
'Note (B) :
M.S.A. 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
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, including those which are general
obligations of the municipal issuing them, if the municipality is
' entitled to reimbursement in whole or in part from the proceeds of the
special assessments.
(2) Warrents 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 waterworks systems, and public lighting, heating or power
systems, and of any combination thereof or for any other public convenience from
which a revenue can be derived.
' (6) Debt service loans and capital loans made to a school district
under the provisions of sections 124.42. and 124.43.
(7) Amount of all money and face value of all securities held as a
' debt service fund for the extinguishment of obligations other than
those deductible under this subdivision.
(8) 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.
-144-
COMBINING SCHEDULE OF BONDS PAYABLE ,
December 31, 1987
Interest
Rates and Issue Maturity'
Dates Date Date
-------- - - - - --
PERMANENT IMPROVEMENT BONDS: --- - - - - -- --- - - - - --
'
General Obligation Refunding Bonds of 1985 9/1/85 3/1/96
-----------------------------------------
Bonds issued for the purpose of refunding in 6.50% 3 \1 -9 \1
advance of maturity the outstanding principal 7.00%
amount of the Permanent Improvement Revolving 7.20% '
Bands of 1984. 7.40%
7.60%
All bonds maturing on or after March 1,1988 being 7.80% '
subject to redemption at the option of the 8.00%
Issuer on March 1, 1987 and e.ny interest payment 8.20%
date thereafter at par and accrued .interest. 8.40%
General - Obligation- Refunding - Improvement -Bonds -1987 6 \1 \87 3 \1 \95
All Bands maturing on or after March 1, 1992, 5.00% 2\1
shall be subject to redemption and prior payment 5.25% '
in whale or inpart in inverse order of maturity 5.50%
and by lot within maturity at the option of 5.75%
the issue on March 1, 1991, and any interest 6.00%
payment date thereafter at a price of the 6.20% ,
principle amount thereof plus accrued interest. 6.40%
6.60%
Total Permanent Improvement Bands
K
I �
I
-145- 1
Table IX
Annual Interest
Orginal Serial Balance Balance Paid in
Issue Payments 1 -1 -87 Sold Retired 12 -31 -87 Cur.Year
------- - - - - -- ---- - - - - -- ----- - - - - -- ----- - - - - -- ----- - - - - -- ----- - - - - -- -- - - - - --
$2,460,000 $2,390,000 $ - $2,390,000 - $172,435
05,000 (88)
220,000 (89)
230, 000 (90)
245,000 (91)
260,000 (92 )
28o,000 (93 )
300,000 (94 )
325,000 (95)
130,000 (96)
X2,230,000
245,000
260,000
265, 000
275,000
275,000
280,000
300, 000
330,000
$2,230,000 $2,230,000 $32,782
(88)
(89)
(90)
(91)
(92)
(93)
(94)
(95)
----- - -- - -- ----- - - - - -- ----- - - - - -- ----- - - - - -- --- - - -- --
$2,390,000 $2,230,000 $2,390,000 $2,230,000 $205,217
----- - - - - -- ----- - - - - -- ----- - - - - -- ----- - - - - -- --- - - - - --
-146-
COMBINING SCHEDULE OF PONDS PAYABLE
December 31, 1987
Tax Increment Ponds of 1960
Bonds maturing in 1991 and later
years will be subject to redemption
and prepayment at the option of the
city in inverse order of serr;r.
numbers on March 1, 1990
r
Tax Increment Bonds of 1984
--------------------- - - - - --
Bands maturing on or after March 1, 1996 will
be subject to redemption and prepayment at
the option of the City in inverse order,
on March 1, 1991 and any interest payment
date thereafter at 100% of their
principal plus accrued interest.
-147-
Interest
Rates and Issue Maturity
Dates Date Date
------ - - - - -- --- - - - - -- --- - - - - --
8.00% 3/1-9/1
8.00%
8.00%
8.00%
8.00%
8.00%
8.00%
8.00%
8.10%
8.85%
8.40%
8.50.%
8.60%
8.75%
8.75%
8.00% 3/1-9/1
8.25%
8.50%
8.75%
9.00%
9.20%
9.40%
9 \1 \80 3 \1 \02
6/1/84 3/1194
Table IX
Annual
Interest
rginal Serial
Balance
Balance Raid in
ssue Payments
---- - - - - -- --- - - - - --
1 -1 -87 Sold
----- - - - - -- --- - - - -
Retired 18 -31 -87 Cur.Year
-- --- - - - - -- ----- - - - - -- --- - - - - --
8,175,000
$8,015,000 $ -
$-190,000 $7,825,000 $652,550
250,000
(86)
300,000
(89 )
350,000
(9 0 )
425,000
(91)
475,000
(92 )
525,000
(9-3)
550,000
(94)
650,000
(95 )
700,000
(96)
700,000
(97)
700,000
(98)
700,000
(99)
700.000
(00)
700,000
(k) 1 )
100,000
(0 2)
1,070,000
100, 000
105, 000
115, 000
125, 000
135, 000
145,000
160,000
$ 980, 000 $ - $95,000 $885,000 $81,320
(88)
(89)
(90)
(91 )
(92)
(93)
(94)
-148-
COMBINING SCHEDULE OF BONDS PAYABLE (Continued)
December 31, 1987
.Interest
Rates and Issue Maturity
Dates Date Date
-------- - - - - -- --- - - - - -- --- - - - - --
Tax Increment Bonds of 1985 9/1/85 3/1/02
--------------------- - - - - --
Bonds maturing on or after March 1, 1992 6.50%
will be subject to redemption and pre- 7.00%
payment at the option of the Issuer in 7.20%
inverse order of serial numbers, on 7.40%
March 1, 1991 and any interest payment date 7.60%
thereafter at a price equal to par plus 7.80%
accrued interest to the date of 8.00%
redemption. 8.2011
8.40%
8.60%
8.80%
9.00%
9.00%
9.00%
9.00%
GO TI Refunding Bands of 1987,Series A 6/1/87 3/1/02
--------------------------------- - - - - --
Bonds maturing on or after March,l, 1995 shall 5.75%
be subject to redemption and prior payment 6.00%
in whale or in part in inverse order of maturity 6.20%
at the - option of the issuer on March 1, 1994 6.40%
and any interest payment date thereafter at 6.60%
a price of the principal amount thereof plus 6.80%
accrued interest. 7.00%
7.10%
7.20%
7.30%
7.40%
7.50%
-149-
Table IX
Annual Interest
Orginal Serial Balance Balance Paid in
Issue Payments 1 -1 -87 Sold Retired 12 -31 -87 Curr.Yr.
----- - - - - -- --- - - - - -- ------ - - - - -- ----- - - - - -- ----- - - - - -- ------ - - - - -- ----- - - - - --
$2, 100, 000 $2,050,000 - $50,000 $2,000,000 $172,690
$9,090,000
50,000 (88 )
50,000 (89)
50,000 (90)
50,000 (91)
55,000 (92)
55,000 (93)
55,000 (94)
100,000 (95 )
150,000 (96 )
175,000 (97 )
240,000 '(96)
240, 000 (99 )
240,000 (00 )
240,000 (01)
250,000 (02 )
525,000 (91)
640,000 (92 )
680,000 (93)
695,000 (94 )
820,000 (95)
910,000 (96 )
910,000 (97)
960,000 (98 )
930,000 (99)
900,000 (00)
-150-
$9, 090, 000 $ 37,922
COMBINING SCHEDULE OF BONDS PAYABLE (Continued)
December 31, 1987
Interest
Rates and Issue Maturity
Dates Date Date
-------- - - - - -- --- - - - - -- --- - - - - --
GO Taxable TI Bonds of 1987 8 \1 \87 2 \1 \97
---------------------------
All Bands maturing on or after February 1, 8.40% 2 \1
1994, shall be subject to redemption and 8.60%
prior payment in whole or in part in inverse 8.75%
order of maturity and by lot within maturity 8.90%
at the option of the issuer on February 1, 9.00%
1993, and any interest payment date thereafter 9.10%
at a price of par plus accrued interest. 9.10
Total General Obligation Bands
Total Bonds Payable - All Funds
-151-
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Annual
Original Serial
Issue Payments
10,000 (91)
130, 000 ( 9 )
140, 000 (93)
155,000 ( 94 )
170,000 (95)
185,000 ( 96 )
200,000 ( 97 )
Balance
1 -1 -87
Interest
Balance Paid in
Sold Retired 12 -31 -87 Curr. Ir.
$1,100,000 - $1,100,000 -
------ - - - - -- ------ - - - - -- ----- - - - - -- ------ - - - - -- ----- - - - - --
$11,045,000 $10,190,000 $335,000 $20,900,000 $944,482
------ - - - - -- ------ - - - - -= ----- - - - - -- ------ - - - - -- ----- - - - - --
$13,435,000 $12,420,000 $2,75,000 $23,130,000 $1,149,699
-152-
Table X
SCHEDULE OF INVESTMENTS
December 31, 1987
DESCRIPTION
YIELD
COUPON
PURCHASE
MATURITY
PAR
DATE
DATE
MAW SOLD
REPURCHASES AGREEMENT
6.25
6.25
31- Dec -87
01- Jan -88
500,000
MONEY MARKET
5.55
5.55
31- Dec -87
01- Jan -88
7,585
GNMA
7.50
7.50
31- Dec -87
01- Jan -88
170,665
CD ALLSTATE S & L
11.90
11.90
19- Sep -83
19- Sep -88
100,000
CD COLUMBIA S & L
11.35
10.50
02- Feb -84
09- Mar -88
100,000
CD FIRST FEDERAL S & L
11.15
11.70
20- Oct -83
28- Sep -88
100,000
CD GLENDALE S & L
6.60
11.40
17- Mar -86
06- Mar -90
100,000
C +' ---:;-DOME
7.12
12.75
09- Sep -86
12- Sep -89
100, 000
CLI • ,DLD SAVINGS ASN
7.16
11.75
09- Sep -86
02- Sep -89
100,000
CD mt,,_ - r. .IDLAND BANK
14.25
14.65
18- May -84
03- Oct -94
100,000
CD MERI;,�.' SAVINGS BANK
7.98
10.15
17- Mar -86
07- Aug -90
100,000
CD NE STATE BANK
7.50
7.50
16- Dec -87
15- Jan -88
200,000
CD NE STATE BANK
7.50
7.50
17- Dec -87
04- Jan -88
500,000
CD NE STATE BANK
7.50
7.50
16- Dec -87
15- Jan -88
750,000
CD SAVINGS BANK PU►GET SOUND
7.11
12.70
09- Sep -86
29- Aug -89
100,000
FHAN CBO
7.35
6.00
30- Mar -87
03- Nov -91
733,191
FHLB
6.88
7.45
16- Apr -86
27- Mar -89
500,000
FHLB
7.40
7.40
27- May -86
25- May -89
1,000,000
FHLB
7.25
7.25
26- Jun -86
27- Jur, -88
1,000,000
FHLB
11.90
11.90
26- Mar -84
25- 14ar -88
100,000
FNMA
9.45
9.50
18- Jul -85
12- Jun -89
500,000
FNMA
7.00
11.15
13- Nov -86
11- May -90
700,000
FNMA
7.21
8.75
14- Aug -86
10- Jan -91
1,000,000
FNMA
7.28
12.75
14- Jul -86
10- Oct -89
1,000,000
FNMA
----------------------------------------------------------------------
7.24
10.45
11- Dec -87
11- Jan -88
3,000,000
- - - - --
Total at Par
Unamortized Premium
Unamortized Discount
Accrued Interest
Book Value
-153-
12, 561, 441
223,276
(34,804)
328,922
-------- - - - - --
13, 078, 835
Type of Coverage
Table XI
SCHEDULE OF INSURANCE IN FORCE
December 31, 1987
Period Period Building
from to or Structure Contents
- - - - -- - - - - -- ------- - - - - -- -- - - - - --
(80% Coinsurance - $1,000 Deductible)
City Hall
$2,331,586
$551,982
Library
1,007,000
1,302,530
City Garage
1,826,321
140,792
Liquor Store -40th Ave.
109,578
90,322
Liquor Store - University Ave.
169,324
112,662
Liquor Stare - Central Ave.
630,178
Community Center
2,500,000
500,000
Sullivan Park
108,129
392,478
Water Tower
346,649
Parking Ramp
1,300,000
$9, 698, 587 $3,720,944
Workers Compensation 2 \13 \87 2 \13 \86 Statutory
The City maintains self - insurance coverage for general liability and auto.
-154-
H
H
v
ro
H
-155-
�+ �+ •+ �+
�+
v
O
N .-I
0-4 t0
(P
N
000000
m
%D
0
C0 Co
O A T
In
n
OWOOOa
.,
O
o
n�
om�o
v
�•
.4 Cl) 0 O 0 1n
0
•
•
c
• • • • • • I
n
In
m to
O r+ v
m
CO
1 0 N N0 V 0 0
N
�
M
1-InN
v
4 c
or+Omwo., I
N
m
•-n
COmN
CO
n
c -M
1 0 In m —
IL
m
0 a
v
v
rl
N
4J
..
u
4 1Z
0
8k
�
O N In
N
%0
+�
C0
In
o %D n
C0
•-I
m
On N0 T
(P
v
I
1
0 N N I
0
C0
-i
O N 0 0 1 1 -4 1
C0
0
o
00
k % %0
a
•
a
+I
0MCD000N
I
In It) n
UJ
c
•••• I I % I
CO
N
m CO
m
m
m 0
0Nm0 N
N
n
mm
m
%D
9
$4
'~
0NNN
O
T
U
a
m
fi. G4
-4
c
$4
0 �CD0 O wo
U)
.-I
O
N0)
00 -4 (r1
C4
m
4 0
T 0
O CD O m O N 0
v
T
v
CD -4
O 0 N
CO
m A a
d o 01
O N U) 0 0 CO O N
m
01
N CD
O n 01 N
C0
CO
+J a 0
4J -i >-
. . % . . 1 . 4
4
.
.
. .
. . . a
I
Ak
.496 64
c
InNComNOCOo0
N
01
vr1
O 40
n
N
IT u
a Sr 14
0) 0 In NCO I v n
t0
m
N CO
In %D m %0 -I
Uf
.i41 c
0 0 0
nnNn v
m
n
-4
vv
nvr+ CD
O
m
m 0Hn
u44-M
• • •
•
•
• •
x CO
U 6
N
n
In
m
v-4
n
m x m
•c a
0-4
fi
0
of-
40
O 000000
0
0
Oo
omoom
m
m> >.�+
O m000
m
0
0
OO
00000
n
P +J1m
0 %DOOOOO
0
0
00
Oven
v
n
I I v Tl
'v
% . . . . a
a
.
.
. .
. . . I
a
.
0 c k k
f 4
U) 1 1 mNOn0O
0
1n .Nn
�com
u 0 0 0
v 0
0000-10
n
N
m
Nao
m-4n
In
.4A
c v
0 1 1 N my
CD
v
m-4
COCDmn
n
44 m 4J 4
01 'v
• .
•
.
. •
•
0020
�a
N rl
UJ
t0
v
Nv
tD
u u
40
>• S� 01
tR
8!
A
-M 0 r
U U) 01
O 00
o
O
O
0 0
O UJ O o
in
In
a
1+
O m O
m
O
O
00
ONOO
M
0 4t a
0 4J
O w O
O
o
00
O m 0 0
m
%D
A 0 0
c Al
. I I . . 1 I I
1
.
•
% o.
. . . a
4
.
F •4
-M V
NOONUIO O
N
O
O
010
If) 94 t0
m
0 0
01-0-
n 1 1 0 r4 1 I 1
0)
O
0
N 0
n m %0
O
>
-.+ a
�4 n v
N
Co
.,
m 0
Pq O N N
n
In
a 41
$4 ao
%
%I
% b, a
a
•
VV
0
0
o
v
N
Iwo
n
r 0
-4
V
is
u
m
v
m 10
IV
c to
c
c
r +J
w
v a
r c
>
0 r
9
u�
°92960
2
e
9
a
r a
m
;J 96
0 64
0
o
:♦ r r
c
C 4
9
-4 a
u
> p-I 01
a
0 c
041
0
9
9 c 0 c
w
-M r
u 0VviDo
c
'a
s,
••
TI
m aJ m T+
4J S
c 4
0
c
0
0
mV
c $4
41
*+0
c
a u0
-94
9
G4
'va01c01
0
0
m >00
,,
41
w01
a
0 m O4JEn r
m
m
a $44J4J
OAA 4
4d0
41
v4
m0$44J4Jc
-4
k u 0 d a 0 0
r
u
V
c
v'aao•+a>.+4r
0Akr40A4U
k 4
C^
•+;J
4lacrals420
$4
a
0-+0^1+1
ac
0-M
ao
0
+I $4 o+c 54
a
ko
96 aP4
$4
-441 c $4
r
I:
>
d2
x4J o<.> CAM
4,
24
> Imo+.4
CaH
0A=
u
r
0 0 c 00 x 0 41
0
0.4
a c
0 4 0
V 4J
44
.aN
H
0 t
4c
d
4
�OOFH�W�..1O
m
a
+J
r
4J
c 'v
0
0
9
0
2
U1
F
F
t+4
-155-
ITable XII
Note (1) Sources of Funds
teal Estate Land Sales
Lend Sale
'Columbia Heights Office Plaza 0 133,500 10181
Evenson Properties
�.aBelle Perk Condo #1 137,464 10/81
The Gaughan Companies
�olumbie Heights Mall 138,167 2/82
Evenson Properties
�aRelle Perk Condo. #2 168,498 3/82
The Gaughan Companies
�aBelle Park Condo. #3 126,000 9/82
The Gaughan Companies
University Heights Housing 1 9/84
Lolumbia Park Medical Clinic 20,000 11/85 306,041
Columbia Park Properties
' Subtotal 723,630 5,770,249
'Sullivan Lake Housing r 420,000 11/87
Total 1,143,630 5,770,249
'Note (2)
Tax exempt obligation issued on behalf of private entities
' DAvelopment Amount Issue Type
Columbia Heights Office Plaza S 6,000,000 Commercial Redevelopment
IEvenson Properties Revenue Bonds Series 1981
Columbia Heights Mall 4,000,000 Commercial Development
' Evenson Properties Revenue Bonds Series 1981
4111 Building South 775,000 Commerical Development
' Ruvelson and Associates Revenue Bonds Series 1981
LaBelle Park Condominiums 9,000,000 Housing Development Revenue
The Gaughan Companies Bond Series 1980
'Columbia Park Medical Clinic 5,000,000 Commerical Development
Columbia Park Properties Revenue Bonds Series 1985
I
-156-
Table XIII I
In addition to the positions listed above where bond amounts appear, the City '
has a 510,000 Faithful Performance Blank Position Bond on all City Employees.
1
III
-157- ,
PRINCIPAL CITY OFFICIALS
,
AND SURETY BONDS
Year Ended December 31, 1987
Name
Official Title
Mayor and Council:
'
Bruce G. Nawrocki
Mayor
Dale V. Hadtrath
Russell D. Paulson
Mayor Elect
Councilmember
Rita M. Petkoff
Councilmember
Edward M. Carlson
Councilmember
Gary L. Peterson
Councilmember
Administration:
Robert S. Bocwinski
City Manager
Linda Magee
Administrative Assistant
William Elrite
City Clerk- Treasuere- Finance
'
Director - Liquor Operations
Manager
Ronald Kalina
City Att,n- f-,s,-
'
Fred Salsbury
Publio, -J`:rector/City Engineer
Stuart Anderson
Chief o a,..._.
Charles Kewatt
Chief of F ax v�
LeRoy Goranson
Building Inspector
,
Martin Gavic
Plumbing Inspector
LeRoy Goranson
Heating Inspector
Dennis Joriman
Electrical Inspector
'
Donald Jolly
Superintendent of Public Works
John Tiggas
° Recreation and Community Services
Director
'
Rebecca Loader
Librarian
In addition to the positions listed above where bond amounts appear, the City '
has a 510,000 Faithful Performance Blank Position Bond on all City Employees.
1
III
-157- ,
MISCELLANEOUS STATISTICAL FACTS
1987
Date of Incorporation
City Charter
Form of Government
Fiscal Year Begins
Area of City
Mlles of Streets and Alleys:
Trunk Highways
County
City Streets
Alleys
Mlles of Sewers:
Store Sewers
Sanitary Sewers
Watermain Miles
Building Permits:
1978
1979
1980
1981
1982
1983
1984
1985
1986
1987
Estimated Cost:
1978
1979
1980
1981
1982
1983
1984
1985
1986
1987
-158-
Table 1111
March 14, 1898
July 21, 1921
Council- Manager
January 1
3.52 Square Miles
3.0
6.2
61.8
18.9
33.6
59.0
66.1
687
663
555
644
519
540
525
508
513
577
6,996,678
3,316,115
3,264,460
8,822,479
13,757,934
7,829,198
12,059,779
4,938,226
13,269,300
4,215,085
!MISCELLANEOUS STATISTICAL FACTS (Continued)
Fire Protection:
Table XIII
Number of Stations
1
Number of Employees:
123
Full Time
7
Volunteer
24
Police Protection:
6,035
Number of Stations
1
Number of Employees
25
Parka:
23,997
City Parks
13
Playground
11
County Park
1
Schools:
19,670
Senior High
1
Junior High
1
Elementry
3
Prochial Elementary
1
Employees: (as of December 31, 1987)
19,430
Regular
101
Part Time and temporary
427
528
Elections: Registered voters — last city general election
11,581
Number of votes cast last city general election
3,960
Percentage of registered voters voting
34.7%
Population:
1900
123
1920
2,968
1930
5,613
1940
6,035
1950
8,175
1960
17,533
1970
23,997
1975 (mid- decade census)
23,316
1980 (census)
20,029
1981
191800
1982
19,670
1983
19,560
1984
19,530
1985
19,540
1986
19,426
1987
19,430
-159-