HomeMy WebLinkAbout1982 CAFR1
1
1
1
1
1
1
1
1
1
1
1
PRELIMINARY
ANNUAL FINANCIAL REPORT
OF THE
CITY OF
COLUMBIA HEIGHTS, MINNESOTA 55421
590 FORTIETH AVENUE N.E.
FOR THE YEAR ENDING
DECEMBER 31, 1982
FINANCE DEPARTMENT
l:illiam Elrite, Finance Director
MEMBER OF MUNICIPAL FINANCE OFFICERS' ASSOCIATION
OF THE UNITED STATES AND CANADA
telephone: 788 -9221 (612)
' DEPARTMENTS DIVISIONS
Civi Defense
' Regular
Reserves
IFITY OF COLUMBIA HEIGHTS, MINNESOTA
POLICE
CITY
MANAGER
ADMINISTRATIVE
ORGANIZATION
CITY OF COLUMBIA
HEIGHTS, MINNESOTA
MAYOR
COUNCIL
MEMBERS
ELECTORS
RECREATION
b INDEPENDENT
COMMUNITY
'
SERVICES
Regular
Volunteers
COMMISSION
Reserves
COMMISSIONS AND BOARDS
Planning and Zoning
Accounting
Services
City Clerk
Park
Elections
RECREATION E
'
Utility Billing
FIRE
SERVICES
Collect ions
Police E Fire Civil
Liquor
Service
No. 2 Off Sale
Downtown Development
No. 3 Off Sale
ANNUAL FINANCIAL REPORT
rFINANCE
Inspections
'Licenses
& Permits
ADMINISTRATIV
Planning
SERVICES
Assessing
�.
Engineering
PUBLIC
WORKS
Streets
Water Maintenance
L
Sewer Maintenance
Parks - Admin. 6
Maintenance
LIBRARY
Central Garage
Civil Defense
GENERAL
'
GOVERNMENT
BUILDINGS
LEGAL
IFITY OF COLUMBIA HEIGHTS, MINNESOTA
POLICE
CITY
MANAGER
ADMINISTRATIVE
ORGANIZATION
CITY OF COLUMBIA
HEIGHTS, MINNESOTA
MAYOR
COUNCIL
MEMBERS
ELECTORS
RECREATION
b INDEPENDENT
COMMUNITY
SCHOOL DIS-
SERVICES
TRICT #13
COMMISSION
COMMISSIONS AND BOARDS
Planning and Zoning
Recreation & Community
Services
Park
Traffic
RECREATION E
HRA
COMMUNITY
Library
SERVICES
Human Services
Police E Fire Civil
Service
Charter
Downtown Development
ANNUAL FINANCIAL REPORT
ANNUAL FINANCIAL REPORT
YEAR ENDED DECEMBER 31, 1982
CITY COUNCIL
Bruce G. Nawrocki, Mayor
Kenneth E. Hentges Councilmember
Gayle R. Norberg Councilmember
Arden Hovland Councilmember
Rita M. Petkoff Councilmember
CITY MANAGER
Robert S. Bocwinski
FINANCE DEPARTMENT
William Elrite
CITY OF COLUMBIA NEIGNTS, MINNESOTA
Director
ANNUAL FINANCIAL REPORT '
I
HE CIT� OF COLUMPIA HEIGHTS, MINNESOTA
EAR
A�NDEDAVECEMBERP Q 1,1982
TABLE OF CONTENTS
Page
I. INTRODUCTORY SECTION Reference Number
Adminstrative Organization
Finance Directors Letter of Transmittal 1 -7
Auditors Report 8
II. FINANCIAL SECTION
A. General Purpose Financial Statements
Combined Balance Sheet - All Fund Types and
Account Groups
Form A
9 -10
Combined Statement of Revenues,
Expenditures,
and Changes in Fund Balances
- All
Governmental Fund Types
From A -1
11 -12
Combined Statement of Revenues,
Expenditures,.
and Changes in Fund Balances
- Budget and
Actual - General and Special
Revenue Fund
Types
Form A -2
13 -14
Combined Statement of Revenues,
Expenses, and
Changes in Retained Earnings
- All
Proprietary Fund Types
Form A -3
15 -16
Combined Statement of Changes in
Financial
Position - All Proprietary Fund
Types
Form A -4
17 -18
Notes to Financial Statements
19 -30
B. Combining and Individual Fund and
Account Group Statements and Schedules
General Fund
Form B
31 -39
Special Revenue Funds
Form C
40 -50
K A
I
HE CITX OF COLUM IA HEIGHTS, MINNESOTA
KEPQRT
NNUA TINA CIAL
EAR �NDED �ECEMBER 31,198 2
Debt Service Funds
Form D
51 -54
Capital Projects Funds
Form E
55 -58
Special Assessment Funds
Form F
59 -60
Enterprise Funds:
Combining Balance Sheet
Form G
61 -62
Combining Statement of Revenues, Expenses,
Form G -1
63 -64
.and Changes in Retained Earnings
Combining Statement of Changes in Financial
Form G -2
65 -66
Position
Municipal Liquor Fund
Form H
67 -76
Water Utility Fund
Form 1
77-82
Sewer Utility Fund
Form J
83-88
Internal Service Fund:
Central Garage Fund
Form K
89-92
Statement of General Fixed Assets
Form L
93
Statement of General Long -term Debt
Form M
94 -96
III. STATISTICAL SECTION
Assessed Value and Market Value of all
Table 1
97-98
Taxable Property
Table II
99
Tax Rates
Table III
100
City Tax Levy
Tax Levies and Tax Collections
Table IV
101 -102
Special Assessment Collections
Table V
101-102
Revenues - Other than Property Taxes
Table VI
103
and Special Assessments
Expenditures for Selected Functions
Table VII
103
1
1
0
Tuc f TTv nc fni I,mn T A Uc TcuTC _ M TNticcnTe
F�T■
May 31, 1983
MBIA HEIGHTS
Mr. Robert S. Bocwinski
' City Manager
City of Columbia Heights
' Dear Mr. Bocwinski:
The annual financial report of the City of Columbia Heights, Minnesota
' for the year ended December 31, 1982 is submitted herewith. The organiz-
ation, form and contents of this report were prepared in accordance with
standards prescribed by the Municipal Finance Officers Association of
the United States and Canada, the American Institute of Certified Public
' Accountants, State Auditor's Office, State of Minnesota, and the City
Charter. The format has been modified from prior years to incorporate
changes recommended by the National Council on Governmental Accounting
' which incorporates pertinent aspects of Audits of State and Local Govern-
mental Units..
' The report consists of three sections: Section I is the introductory
section and contains-the Table of Contents, Letter of Transmittal, Admin-
istrative ;organization and Auditors report. Section II is the financial
section and contains the general purpose financial statements, notes to
financial statements and the combining and individual fund and account
group statements and schedules. Section Ill is the statistical section
and contains comparative statistical tables and data having reference
value for citizens and investors.
ACCOUNTING SYSTEM AND REPORTS
' The City maintains complete self - balancing account groups for each entity
of the City in accordance with the orgainizationl chart of the City. This
results in a classification of transactions according to specific functions,
' separate and distinct from those pertaining to unrelated activities.
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
• I
Bruce G., Nawrocki, Mayor
Gayle R. Norberg, Councilmember Kenneth E. Hentges, Councilmember
' Rita M. Petkoff, Councilmember Arden Hovland, Councilmember
EQUAL OPPORTUNITY EMPLOYER
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 lias •f.lexibi 1 ity- in" that, where need has been adequately
demonstrated, ad-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;cons.tant r.eviewal process and expenditures are not
approved until it has been determined that (1) adequate funds were app-
ropriated, (2) the expenditure is still necessary and (3) funds are
available.
FINANCIAL STATEMENTS FOR INDIVIDUAL FUNDS
These are indexed in the preceding table of contents. In addition the
header for each type of fund provides a description of the basis for
establishment of the fund and another table of contents of the financial
statements pertaining to the individual fund. Each statement of the General
Fund, Special Revenue Funds (where applicable) Enterprise Funds and
Internal Services Funds are presented with comparative information to 1981.
GENERAL FUND
On December 31, 1982 the fund balance of the General Fund totaled
$1,734,848 of which $94,069 is appropriated for the 1983 budget. This
leaves an unappropriated fund balance which is adequate., but it should
be pointed out that this represents a working capital for general opera-
tions 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 following year.
General Fund
Budget
Beginning of Year
Total of Appropriated and
Unappropriated Fund Balance
Beginning of Year
Estimated and actual revenues for the current year are presented in Form
B -2. Revenues received for general government operations totaled $3,919,228
in 1982, an increase of $526 over the previous year. The following table
presents an analysis of the major revenue sources of the General Fund for
1982 and its change from 1981.
CITY OF COLUMBIA, HEIGHTS, MINNESOTA _ 2 ANNUAL FINANCIAL REPORT
Amount
% of Budget
1975
$ 2,179,705
$ 107,376
4.9%
1976
2,329,365
292,898
12.6
1977
2,549,629
591,399
23.2.
1978
2,917,260
863;828
29.6
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
Estimated and actual revenues for the current year are presented in Form
B -2. Revenues received for general government operations totaled $3,919,228
in 1982, an increase of $526 over the previous year. The following table
presents an analysis of the major revenue sources of the General Fund for
1982 and its change from 1981.
CITY OF COLUMBIA, HEIGHTS, MINNESOTA _ 2 ANNUAL FINANCIAL REPORT
L�
fl
LEVY LIMITATION
The Levy Limitation Law was first implemented in 1972 and, in-general.,
has placed a limitation on the amount of increased revenue that can be
derived from the property tax and local government aid. This amount of
increase is stated in terms of 8 %. Since enactment, various amendments
to the law have been enacted, but the basic principle remained the same.
The following table summarized the City's status in complying with the law
for 1982 and 1983.
1. Payable 1982 Total Property Tax Levy
2. Payable 1982 Total Special Levies
3. Payable 1983 Levy Limit Base (1 -2)
4. Payable 1982 Debt Levy
5. Payable 1983 Revised Levy Limitation Base (3 -4)
6. 1981 Homestead Count
5,103
7. 1980 Homestead Count 5,133
8. Payable 1983 Homestead Adjustment Ratio (6 : 7)
9. Payable 1,983 Homestead Adjustment Base (5 X 8)
10. Payable 1983 Levy Limitation (9 X 1.08)
$1,759,284
375,560
$1,383,724
220-,000
$1,163,724
1.00
$1,163,724
$1,256,822
CITY OF COLUMBIA NEIGNTS, MINNESOTA ANNUAL FINANCIAL REPORT
3
1982
Percent
Increase (Decrease)
Revenue Source
Amount
of Total
From 1981
General Property Taxes
$1,049,992
26.8
$ 143,918
Licenses and Permits
. 148,773
3.8
44,744
Intergovernmental Revenue
1,874,876,"'
47.8
(69,625)
Charges for Services
551,506
14.1
133,902
Fines and Forfeits
47,073
1.2
(20,228)
Miscellaneous Revenue
145,079
3.7
(2,873)
Expenditure Reimbursements 65,523
1.7
5,170
Transfers - In
36,406
.9
(234,484)
Totals
$3,919,228
100.00
$ 526'
From the above table,
it is apparent that
the major sources available
for funding the general operations is the
property tax
(26.8 %) and inter-
governmental revenue
(47.8 %), primarily state
aids. Both of these sources
are controlled in the
amount that they can
increase by
what is known as the
Levy Limitation Law.
LEVY LIMITATION
The Levy Limitation Law was first implemented in 1972 and, in-general.,
has placed a limitation on the amount of increased revenue that can be
derived from the property tax and local government aid. This amount of
increase is stated in terms of 8 %. Since enactment, various amendments
to the law have been enacted, but the basic principle remained the same.
The following table summarized the City's status in complying with the law
for 1982 and 1983.
1. Payable 1982 Total Property Tax Levy
2. Payable 1982 Total Special Levies
3. Payable 1983 Levy Limit Base (1 -2)
4. Payable 1982 Debt Levy
5. Payable 1983 Revised Levy Limitation Base (3 -4)
6. 1981 Homestead Count
5,103
7. 1980 Homestead Count 5,133
8. Payable 1983 Homestead Adjustment Ratio (6 : 7)
9. Payable 1,983 Homestead Adjustment Base (5 X 8)
10. Payable 1983 Levy Limitation (9 X 1.08)
$1,759,284
375,560
$1,383,724
220-,000
$1,163,724
1.00
$1,163,724
$1,256,822
CITY OF COLUMBIA NEIGNTS, MINNESOTA ANNUAL FINANCIAL REPORT
3
FISCAL DISPARITIES
In 1971 the legislature enacted a Fiscal Disparity Law which was not
implemented until taxes payable in 1975 due to a constitutional challenge.
The law provides for the pooling of 40% 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.
Although it is difficult to determine the future impact of the law on
the City, it appears that the City will gain in nominal amounts. The
impact on the taxable valuations of the City for taxes collectible in 1980
through 1982 was as follows:
City's taxable value:
Personal property
Real estate
Sub -Total
1982 1981
$ 1,344,094 $ 1,295,504
96,391,052 85,721,087
$ 97,735,146 $ 87,016,591
$ 1,218,792
73,741,181
$ 74,959,973
Areawide allocation:
Contribution to "pool" $ (3,908,286) $ (2,000,000) $ (1,840,970)
Distribution from "pool" 8,183,307 4,383,409 4,062,894
Net Increase ,275,021 $ 2,383,409 $ 2,221,92
Combined Value $102,010,167 $ 89,400,000 $ 77,181,897
Actual taxes received from the fiscal disparities allocation amounted to
$146,150 in 1982, $118,108 in 1981, and $85,771 in 1980. This represents
a small amount of property tax relief to Columbia Heights taxpayers.
It should be remembered that, regardless of how much "new - revenue" is re-
ceived from fiscal disparities, the revenue is part of the tax controlled
by the levy limit within which the City must still operate.
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 unremitted 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.
SPECIAL REVENUE FUNDS
The municipal State -Aid Street Fund was established to receive gasoline
tax apportionments from the state which are used to construct state -aid
streets. In 1981 this fund was restated in accordance with N.C.G.A.
statement Number 2. Previously revenue was recorded at the time of
apportionment from the State of Minnesota. Under the restatement, revenue
is,not recorded until it is earned. In 1982, revenue earned and interest
received totaled $102,314. The fund balance dedicated to construction of
state -aid streets, at December 31, 1982 is $42,647.
CITY OF COLUMBIA NEIGNTS, MINNESOTA
4
ANNUAL FINANCIAL REPORT
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 to December
31, 1976, Federal amendments to the law reauthorized appropriations through
September 30, 1983. The following table reflects the use of Revenue Sharing
through December 31, 1982:
In 1978 the Recreation Commission was expanded to include a Community Services
function. The revised Recreation and Community Services Commission Fund
is funded and directed in co= operation with Independent School District No. 13
through a six member board. The activity of this fund covers year round
recreation programs in the schools, city parks and outside the community.
In 1982 revenues of $204,479 exceeded expenditures by $13,947 increasing the
fund balance to $34,864.
FIXED ASSETS
The general fixed assets of the City are those fixed assets used in the
performance of general governmental functions, but exclude the fixed assets of
the propietary funds. As of December 31, 1982, the. general fixed assets of
the City thus far recorded amount to $8,318,349. This amount represents the
original cost of land, buildings and equipment and is considerably less than
their present value. Depreciation of the general fixed assets is not re-
cognized, as is customary in municipal accounting, in the City's accounting
system, but depreciation of assets is recognized in the propietary 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 estab-
lished on the City's accounting records. In 1983 further work is planned
to develop values for roads, curbs and gutters and similar assets that are
immovable and incorporate these values into the General Fixed Asset group
of accounts. Replacement values for insurance purposes were also established
from the appraisal.
CITY OF COLUMBIA HEIGHTS, MINNESOTA
11
ANNUAL FINANCIAL REPORT
....Fund
...
Revenue Sharing
Interest
Capital
Balance
Revenue
Earnings
Total
Projects
Operations
Total
Year End
1972
$ 120,859
$ -
$120,859
$ -
$ - $
-
$120,859
1973
140,575
9,202
149,777
110,239
14,606
124,845
145,791
1974
144,256
12,834
157,090
145,830
4,158
149,988
152,893
1975
154,036
11,530
165,566
187,572
30,488
218,060
100,399
1976
157,339
10,907
168,246
158,164
68,528
226,692
41,953
1977
159,482
6,257
165,739
108,928
25,478
134,406
73,286
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,396
181,353
1359903
3,951
139,854
195,622
1982
141,743
24,207
165,950
59,318
1,832
61,150
300,422
In 1983
it is estimated
that the
City will
receive
$86,720 in revenue
sharing
payments
and $8,500 interest
earnings. The
adopted
1983 budget
includes $3,750
for general
operations
and $214,015 for capital
projects,
leaving
an estimated
fund balance of $10,100
as of December 31,
1983•
In 1978 the Recreation Commission was expanded to include a Community Services
function. The revised Recreation and Community Services Commission Fund
is funded and directed in co= operation with Independent School District No. 13
through a six member board. The activity of this fund covers year round
recreation programs in the schools, city parks and outside the community.
In 1982 revenues of $204,479 exceeded expenditures by $13,947 increasing the
fund balance to $34,864.
FIXED ASSETS
The general fixed assets of the City are those fixed assets used in the
performance of general governmental functions, but exclude the fixed assets of
the propietary funds. As of December 31, 1982, the. general fixed assets of
the City thus far recorded amount to $8,318,349. This amount represents the
original cost of land, buildings and equipment and is considerably less than
their present value. Depreciation of the general fixed assets is not re-
cognized, as is customary in municipal accounting, in the City's accounting
system, but depreciation of assets is recognized in the propietary 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 estab-
lished on the City's accounting records. In 1983 further work is planned
to develop values for roads, curbs and gutters and similar assets that are
immovable and incorporate these values into the General Fixed Asset group
of accounts. Replacement values for insurance purposes were also established
from the appraisal.
CITY OF COLUMBIA HEIGHTS, MINNESOTA
11
ANNUAL FINANCIAL REPORT
ENTERPRISE FUNDS
Liquor Operation
Total Off -Sales were $966,970, a decrease from 1981 of $5,888. Total Net
operating income was $27,307, a decrease of $17,242.from 1981.
WATER & SEWER UTILITY
The Water Utility Fund had a 1982 net income of $1,864 on a .49% increase
in revenues compared to a net income of $15,828 in 1981.
The Sewer Utility Fund with a 2.21% increase in revenues had a net income
of $273,094 in 1982 compared to a net income of $107,475 in 1981. The Sewer
Fund transferred $15,000 to Debt Service Funds in 1982
In 1982 the Financial Reports for both the water and sewer funds were
restated to take depreciation expense against customer contributions. This
resulted in an increase to retained earnings and a decrease to customer
contributions of $747,786 in the water fund. The result in the sewer fund
was an increase to retained earnings and a decrease to customer contributions
of $794,706. This accounting change was made to reflect the intent of the
City Council to assess customers,for the replacement of water and sewer lines.
SPECIAL ASSESSMENT FUNDS
Special Assessment Funds are used to finance and account for the construction
and financing of certain public improvements such as residential streets,
storm sewers, sanitary sewers, and water mains which are to be paid for
wholly or in part from special assessments levied against benefited property.
The Special Assessment Funds are also used to account for assessments levied
against the individual property owners which, are usually paid in installments
over a period of years. During 1982, the City assessed $965,044 of benefits
to property owners.
CENTRAL GARAGE FUND
The Central Garage Fund was established in 1977 to record expenses of the
service shop and to allocate such cost to the using departments. It is
intended to maintain this fund on a self- sustaining basis with the establish-
ment of fixed assets-and related depreciation for the garage in 1979, re-
tained earnings has an unreserved fund balance of $9,480 as of December 31,
1982. Depreciation, although not considered in the initial years, will
be a factor in future user rates.
TRUST AND AGENCY FUNDS
Investment Trust Fund
The Investment Trust Fund was created in 1974 to record all investment trans-
actions 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.
CITY OF COLUMBIA HEIGHTS, MINNESOTA
2
ANNUAL FINANCIAL REPORT
1
1
1
Interest rates were slightly lower in 1982 than in the preceding year,
and the average amount of idle funds increased only slightly in 1982..
Interest earnings for the past nine years are as follows:
Year Earnings Yield
1974 $10— 1,498 -
1975 87,612 8.34%
1976 121,051 7.75%
1977 114,186 5.69%
1978 119,918 6.29%
1979 181,797 9:21%
1980 229,978 11.14%
1981 324,608 12.30%
1982 364,565 11.40%
The 1982 earnings were distributed to the following funds:
General $ 58,731
Revenue Sharing 24,207
Municipal State -Aid Street -
Capital Improvements 12,796
Debt Service 102,554
Liquor 125,957
Water 6,817
Sewer 26,613
Garage 3,901
Park Dedication 2,989
$364,565
NEW LEGISLATION
The 1978 Minnesota Legislature enacted Chapter 787 to standardize and
improve municipal financial reporting. Beginning in 1979, the fiscal year
of all Minnesota cities is the calendar year. Also, cities failing to meet
the new financial reporting requirements will have the State Auditor's office
or its appointee prepare their financial statements.' Fees for this service
will be withheld from the City's share of Municipal State Aid. This report
meets or exceeds all state reporting requirements.
ACKNOWLEDGEMENTS
.I would like to thank your office and the members of the City Council for
their interest and support in planning and conducting the financial operations
of the City. 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. Special recognition should be given to
John Irgens, Barb Sandberg and Jackie Niccum for their assistance in pre-
paring this report.
Respectfully submitted,
;ol
l!v
William Elrite
Finance Director
CITY OF COLUMBIA HEIGHTS, MINNESOTA ? ANNUAL FINANCIAL REPORT
HE CITY OF��VVCOLUM$IAQQHEIGHTS.. MINNESOTA
Mn
NNUA
ECEMBER
ALPSl
# # 1�3�
GEXERAL PURPOSE
FINARIAL 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 conformity with generally accepted
accounting principles."
It is felt that these General Purpose Financial Statements will be a
benefit to users requiring less detailed information about our City's
finances.
TABLE OF CONTENTS
Auditors Report
Combined Balance Sheet - All Fund Types and
,Account Groups
Combined Statement of Revenues, Expenditures,
and Changes in Fund Balances - All
Governmental Fund Types
Combined Statement of Revenues, Expenditures,
and Changes in Fund Balances - Budget and
Actual,- General and Special Revenue Fund
Types
Combined Statement of Revenues, Expenses and
Changes in Retained Earnings - All Proprietary
Fund Types
Combined Statement of Changes in Financial Position
-All Proprietary Fund Types _
Notes to Financial Statements
Page
8
Form
A
9 -10
Form
A -1
11 -12
Form
A -2
13 -14
Form
A -3
15 -16
Form
A -4
17 -18
19 -30
GEORGE M. HANSEN COMPANY, P.A.
GMHCo
' A Professional Corporation of Certified Public Accountants
AUDITORS' OPINION
' The City Council of
Columbia Heights, Minnesota
We have examined the combined financial statements of the City of Columbia Heights,
' Minnesota as of and for the year ended December 31, 1982 as listed in the table
of contents. Our examination was 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, 1982,
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 the method
of accounting for depreciation in the proprietary fund types (utility funds) as
described in Note 2 to the financial statements.
' Our examination was made for the purpose of forming an opinion on the combined
financial statements taken as a whole. The combining, individual fund and account
group financial statements and schedules listed in the table of contents are
' 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 combined 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.
May 27, 1983
M-41
'
175 SOUTH PLAZA BUILDING WAYZATA BOULEVARD AT HIGHWAY 100. MINNEAPOLIS, MINNESOTA 55416 612/546-2566
Q
E
L
W
0 m N�f>D ^J u1 OW1> wJ.T 01O V1O0101 _�
J LA %O TOE �01J O N M^ MUN MMO hfY�J IA
^
44 00 to d •�M ^%D^ U1 ^01111OOD MJ OqD n h N �
_ 1 O h01 cc co N1Mv1\f1/V /f1^ 01Nd 10%000 O10oo • 01 % C EM01 ANd JN ^D1ph^ MU%04 0 f. %P. -01 01
o U L
C d M1 1V d ^ N A h
H hMN dQ1 d�CppphM ^ nJ 01 g001N%0dM h h
T�0 N 010101p%�0 ^N M -T Md V1 Mm O1M Q1 O f>D
L O D N M 01 M h h L f 1 1 f 1 01 O 0 N O h M h 0 J
1• M N •M0%Cca%h 1 O11 ^^ •MJO\....�%0 J
E M N ^ W . M ^ O1 h N OO 01 ^ M %0 M1 In to W
O- ^Md ^N^ N ^Q\N %O MMN NO ON J
1H N
r OM1 O O
L O 01 O
M _O
Y C Cl LA LA
00 O �O O
L J
0 N
V
C ^ N f__Y M M M
O q 9 1 1 1 1 1 1 1 1 1 1 1 1 1 1/1N hN 01^ 1 1 1
u L Y .+
u Y x Y N h 01 f••1 h^ ^
f7 -c M N f<7
N N
O O O 611 ^ h 1f1 tD
%O h M h h M 1"a N
d q Y 1 1 1 1 1 1 • 1 1 1 1 • 1 1 1 1
LM L. c •� 1 J to ^ 10 ? N
O ~ w L v
O t C Y
C N
O 7
F W N N
2
0 m N %O %0 O 01 •� 01M ^ hJ v1 f-N� 01 Q1
L) 61 4 O\ N co d O0 N M M J M U1 N h M h
Q
L M I N • O Q\ 1!1
•` ^ 1 • 1 • 1 1 • 1 1 1
u1 v\ h 00 N J O1 w 61 u1 J %O M
�_ �• N CO -T M N N W m O N O 10
O Y %0 N N^ N M 1A M N �O
Q L a.l
Q. C ^ d 4 LA
W W N N
0. 1f1 O N M �O co co C4
I- ^ 1 •� %0
1= ^ q 0
Lf\ fA 01 f N f M l f 1 1 1 1 1 1 1 1 i 1 1 1 1
Z • •U 0 y- a N •hJ
^ 0 /n C ^ ^ M
J L 1n Q E N N
J d N O C4 co C-4
00 O
Q � y ^ u1 M O
W a v y
1 �0 I I I M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
W a O
N h' L1 0. N ^ N
W
V c Y NIOJ ? ?
u
W �•� N O 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 co
m C G Y % ^ q
EVI N N
W C
2 L
M > 7 ? Oco1 1Jf1 �0
V•O J ; 1 • 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
v N %0 Go
N fY U1 LA
N N CrA
UN M 6n Lr% O
L.
L 170 ^
• 1 • 1 • 1 • 1 1 1 1 1 1 1 1 1 I I 1 1 1
Y ^ �O ^ N %0 N O
C O J fn N �0
tl
N ^ w N
C
7
4..
r l _� Y 01 Y O
4).Q c u
N ^ q Y C q - �+ •� w
jY a > ^ > > C > C 41 O U Y Y C •LI a N C N
_ Y U N •- Y C 0' �+ ul O a w
L �+
a+ Y N uo E Y g Y C Y •- Y Y a
C q •• a+ L C •• u.0 L L a+ y L Y
Y .+ z a In c ,n L 0 a c q .,+ V cn q V
N Ot N W Ill q w �1 ♦+ o Y Y Y '>O ! C O •- C L N
g O 0 Y> c E 14 C> �+ E •- L q •� L u •! O E �
W I U ^ 7 0 Y 3 O N a s •- N Y Y 7 a Y U. L W
Vf O
".0 Y O In L H, 010 g q Y 0 u L 0 O' L Y Y N
Y q u u Y Y v >> u Y Y �+ L V C a ^'0 �+ N
< - q C 0 � L L Y w L 0 7 - Y a Y I dc
!• U L g N C Y Y Y Y Y L 0 ♦'a a q 'O OI
q Y q •- L L q U u q 0 N •- C C - • C J
v Y N �+ �+ C g 0'0-- > O Q
V M V ^-c O O L L w .- U C L .- Y q 0^ F
a+ a
LL E 7 ^2 0 0
- L U g q + aE q U ^ U L 0 0 b Y O u C Y
> C a Y v L L 0 u L. x u Y c > Y C
In - U C a U L q u a 0 O U- + ^ L0
Y Y
,
1-
LIONS Y YF•QNL19^ L•-L ul 7 7 7 C
N N> U O Y Y! w C •- a 1►• U C U
ICU C C W J .11 0Y i O D C C O u
Q
E
L
O
C
d
C
y
C
O
V
N
a
0
IY
f.7
H
O
V
v
Q
O
2
Q
N
W
0.
I..
N
O
2
W
J
J
a
1
1 ••
W
W
2
N
W
ZV
J
Q
m
0
W
2
m
O
V
CL 'c
a
W w
= l V
d E
W «
O N C C
2
Q d d 9 L A
LA = A O 7
_W t0 OIw C
T 10 , L L > X61
J a a A C C L L A u
m N N v O O o N 9 41 V
Q
- uy c u v d �yy c yCy.w
u 0< S C G O O C
J 10
L.1
L11 O - C7
N p O\ O1
- ^ N
- H
O s CO
O ? Ch s
N N co ^
V►
'O
O
O
1 1 1
O
01
V► V►
s .T
1 I
CO OD
/b co
Vt• N
0 co co
co M N
s rn N
1
Q\ �O LJ1
VL Vf
f� O1
O P.
1 t
O
LA %0
�D
M1 L1\
Vf
T 1 N
4^ 411
L N N
M
O ON O O
L/% co l
to GO 1\ co
vt
N
O �
LD GIO
LA co M
rn m M C1D
C N 1D
L O %D tb
In �
V1
P� co S
O O cl
2 CO s O
ON " n %D
Vf
H
d
N W
V
v O
N 2
N Q
N m
t0 L Q
++ C N W J
L O
a •n of c M M m
m f0 • L C Q
M 41
J U C L d 47 m 4 J
_ v tou'o c _
to > u c; to Q
0" ^� " C� N d•N-0 f0
7 L N^ L N N C
W C> w c L O=
�{0 COCW O
c
LL
d
10
N
M
Cy
E c
v
N V
N tp
V
^ N
t0
C L
C r
-
w
L► O
d M
t L
4+ tp
CL
O
A
N L
V �
C C
H m
�D M %D M O\.? 0-700
Ch N
f�
? N s IA LA = O Ch-
fl 01
01 �D IT w O O Lm ►m
10
M O1W
N
• 1
M -N ^ -111 IA^N
MAN
LM CM
O
c M o
N
t o N O
%a
U L. —
GID
O
M —
-
- 7 O
N n,
-
N
w eLD
to CO O\ 00 O M s
�, u -O O -D f, O
O
M O1 fl.
N •.T O
O
LO
�D M N; %O 1� UN f� %D Ln
1I
O
Go M 11'1
-
Q
E M N
s ink O� tr ao co f� 61%
00000
E
Go
6*1 �f�l1D -
co
S U L cr%
-- •- f� N
s
M M
10
vQQ-
.-
NW M
\
Vf
Vf
N
' O
O
E
1 OO
O
N
1 1 1 1 1 1 1 1
O
O
T
O
O
OI
Lm C C
01
�+ L.7 J O
Vf
to
V►
C
7
U
L/ L
Q C X H
,M
tJV LL Q
W
N
Vf
Vt•
N
Q7
O
M
LA
— d
to 1On
LA
�D
N
f0 U
'�
1 ` 1 I 1 1 1 1 1
` 1 1
`
L
L; M
V n
C C N
7 —
W
Vf
Vf
Vf
L
w N
-
f. O
tu _
s o1s
o1
Ln
'L
06
n s Ln
co
co
L
f� .•• —
LA
111
to
1
N N
i
a c
N r,
W
N
co
10 U, _T Co =_T
Co
T ^"D O^11
M? tr 111
�D
tO N
` 1 1 1 1
1l1 �
-•
1 1 1
I
` N N
.d
^ LA cc
C,.•
M N
LA N
GIO
QCQ11.
L La G E
N
N
N
N
N
E�
QI N
U - V
LT
Ln
O�
Ln
N
N
N
v aO
m L
V a
N
N
H
N
ON
C r _V
1 I 1 t 1 1 1 LD 1 1
10
O
W 4)
N
N
10
O L
co
C N
L
V1
VL
Vf
_
v
M CO
N
L 10 2
co z
LA
•U
Lp N M
s
> 61
`
f0 a >
^ M M
O
N
N
Vf
4
Vf
%0
N
�
-7 �O O1 O LO
LD q0 �D LA
OO
f\
L
CO 0 O co f�
N
N
d
'-
L.7
4^
V►
N
CL 'c
a
W w
= l V
d E
W «
O N C C
2
Q d d 9 L A
LA = A O 7
_W t0 OIw C
T 10 , L L > X61
J a a A C C L L A u
m N N v O O o N 9 41 V
Q
- uy c u v d �yy c yCy.w
u 0< S C G O O C
J 10
L.1
L11 O - C7
N p O\ O1
- ^ N
- H
O s CO
O ? Ch s
N N co ^
V►
'O
O
O
1 1 1
O
01
V► V►
s .T
1 I
CO OD
/b co
Vt• N
0 co co
co M N
s rn N
1
Q\ �O LJ1
VL Vf
f� O1
O P.
1 t
O
LA %0
�D
M1 L1\
Vf
T 1 N
4^ 411
L N N
M
O ON O O
L/% co l
to GO 1\ co
vt
N
O �
LD GIO
LA co M
rn m M C1D
C N 1D
L O %D tb
In �
V1
P� co S
O O cl
2 CO s O
ON " n %D
Vf
H
d
N W
V
v O
N 2
N Q
N m
t0 L Q
++ C N W J
L O
a •n of c M M m
m f0 • L C Q
M 41
J U C L d 47 m 4 J
_ v tou'o c _
to > u c; to Q
0" ^� " C� N d•N-0 f0
7 L N^ L N N C
W C> w c L O=
�{0 COCW O
c
LL
d
10
N
M
Cy
E c
v
N V
N tp
V
^ N
t0
C L
C r
-
w
L► O
d M
t L
4+ tp
CL
O
A
N L
V �
C C
H m
COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND
BALANCES - ALL GOVERNMENTAL FUND TYPES
Year Ended December 31, 1982
Special
The notes to the financial statement are an
integral part of this statement
[CITY OF COLUMBIA NEIGNTS, MINNESOTA
ANNUAL FINANCIAL REPORT
General
Revenue
REVENUES:
General property taxes
$ 1,049,992
$ -
Homestead credit
434,392
-
Special assessments
-
-
Licenses and permits
148,773
-
Fines and forfeitures
47,073
-
Interest and rents
145,079
27,197
Intergovernmental revenues
1,440,484
348,040
Charges for services
551,506
117,335
Other revenue
65,523
6,018
Total Revenues
3,882,822
498,590
OTHER FINANCING SOURCES:
Transfers from other funds
36,406
91,886
Total Revenues and Other Sources
3,919,228
590,476
EXPENDITURES:
Current:
General government
532,444
4,360
Public safety
1,454,404
-
Public works
581,121
-
Sanitation
403,670
-
Library
188,343
-
Parks and recreation
443,863
190,532
Other
27,340
26,947
Capital outlay
-
59,318
Debt service:
Principal retirement
-
-
Interest and fiscal charges
-
-
Total Expenditures
.3,631,185
.281,157
OTHER USES:
Transfers to other funds:
91,886
72,914
Total Expens i tures and Other Uses
1,723,071-
►, �T
EXCESS OF REVENUES AND OTHER SOURCES
OVER (UNDER) EXPENDITURES AND OTHER USES
196,157
236,405
FUND BALANCE AT BEGINNING OF YEAR
1,538$691
229,828
FUND BALANCE AT END OF YEAR
$1,734,848
$466,233
The notes to the financial statement are an
integral part of this statement
[CITY OF COLUMBIA NEIGNTS, MINNESOTA
ANNUAL FINANCIAL REPORT
15,000
36,406
---726,107
445,612
Form A -1
3,229,220
812,312
,
679,338
3,793,173
Total
Debt
Capital
Special
(Memorandum Only)
Service
Projects
Assessment
1982 1981
$ 207,949
$ -
$
$1,257,941' $1,182,811
62,112
-
-
496,504 541,153
-
-
965,044
965,044. 194,654
_
-
-
148,773 104,027
_
-
-
47,073 67,301
76,002
208,623
88,980
545,881 966,078
-
25,t03
-
1,813,627 2,316,483
74,976
743,817 457,505
409,160
-
23,857
504,558 539,731
755,223
233,726
1,152,857
6,523,218 6,369,743
15,000
36,406
---726,107
445,612
2,640,316
3,229,220
812,312
770,223
679,338
3,793,173
9,752,438
7,182,055
704,896
536,804 572,516
1,454,404 1,380,692
581,121 576,754
403,670 336,997
- 188,343 188,440
- - 634,395 851,003
- 5,500 59,787 175,872
389,701 965,606 1,414,625 7,004,884
340,000 - - 340,000 320,000
702,879 - - 702,879 689,650
1,042,879 389,701 971,106 ✓ 6,316,028 12,096,808
-
36,406
---726,107
2,530,30
3,501,'414
2,731,514
9,047,5
364 823
12,461, 31
1,042; 79
(272,656)
253,231_
291,759
704,896
(5,279,576)
928,749
1,624,176
5,775
4,327,219
9,606,795
$ 656,093
$1,877,407
$ 297,534
$5,032,115
$4,327,219
CITY OF COLUMBIA NEIGNTS, MINNESOTA
12
ANNUAL FINANCIAL REPORT_.
COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND
BALANCES - BUDGET AND ACTUAL- GENERAL AND SPECIAL REVENUE FUND TYPES
Year Ended December 31, 1982
REVENUES:
General property taxes
Homestead credit
Licenses and permits
Fines and forfeitures
Interest and rents
Intergovernmental revenue
Charges for services
Other revenue
Total Revenues
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
GENERAL FUND
Original Revised
Budget Budget
$ 943,655 $ -
598,625 -
92,440. -
61,200 -
122,460 -
1,615,305 -
565,200 -
17,000 -
4,015,885 -
Variance
Actual Over (Under)
$1,049,992
$ 106,337
434,392
(164,233)
148,773
56,333
47,073
(14,127)
145,079
22,619
1,440,484
(174,821)
551,506
(13,694)
65,523
3,882,822
_ 48,523
133,063
68,370 - 36,406 (31,964)
4,084,255
-
3,919,228
(165;027)
572,815
561,623
532,444
29,179
1,551,920
1,501,363
1,454,404
46,959
656,650
620,390
581,121
39,269
491,155
491,155
403,670
87,485
189,520
188,485
188,343
142
493,820
462,700
443,863
18,837
183,500
86,250
27,340
58,910
4,139,3 39,3$0 3,911,966 3,631,1 F5 280,781
OTHER USES:
Transfers to other funds 203,495 94,495 91,886 2,609
Total Expenditures and Other
Uses 4,342,875 4,006,461 3,723,071 283,390
EXCESS OF REVENUES AND OTHER SOURCES
(UNDER) EXPENDITURES AND OTHER USES (258,620) 77,794 196,157 118,363
FUND BALANCE AT BEGINNING OF YEAR 1,538,691 1,538,691 1,538,691 -
FUND BALANCE AT END OF YEAR $1,280,071 $1,616,485 $1,734,848 $ 118,363
The notes to the financial statement are an
integral part of this statement
[CITY OF COLUMBIA NEIGNTS, MINNESOTA
13
ANNUAL FINANCIAL REPORT
ii
li
Form A -2
d
CITY OF COLUMBIA NEIGNTS, MINNESOTA 14
ANNUAL FINANCIAL REPORT
Total
SPECIAL REVENUE FUNDS
(Memorandum
Only)
Variance
Revised
Variance
Budget
Actual
Over (Under)
Budget
Actual
Over (Under)
$ -
$ -
$ -
$ 943,655
$ 1,049,992
$ 106,337
-
-
-
598,625
434,392
(164,233)
-
-
-
92,440
148,773
56,333
61,200
47,073
(14,127)
8,500
27,197
� 1 18,697
130,960
172,276
. 41,316
456,495
348,040
3 ���(108,455)
'I
2,071,800
1,788,524
(283,276)
48,615
117,335
68,720
613,815
668,841
55,026
-
513,610.
6,018
498,590
;,0� 6,O18
15,020
17,000
4 -,5 2-9-, T 95
71,541
4,381,412
54,541
14 -,05-9-3)
103;495
91,886
(11,609)
171,865
.128,292
(43,573)
617,105
590,476
(26,629)
4,701,360
4,509,704
(191,656)
8,400
4,360
4,040
570,023
536,804
'33,219
-
-
-
1,501,363
1,454,404
46,959
-
-
-
620,390
581,121
39,269
-
-
-
491,155
403,670
87,.485
-
-
-
188,485
188,343
142
229,605
190,532
39,073,
692,305
634,395
57,910
32,14.0
26,947
5,193
118,390
54,287
64,103
176,435
446,50
59,318
2�i,157
117,117
165,423
176 435
4,358,5
59 318
3,912,3 2
117,117
446,204
336,300
72,914
263,386
430,795
164,800
,265,995
782,880
354,071
428,809
4,789,341
4,077,142
712,199
.(165,775)
236,405
402,180
(87,981)
432,562
520,543
229,828
229,828
-
1,768,519
1,768,519
-
$ 64,053
$466,233
$ 402,180
$1,680,538
$2,201,081
$ 520,543 ,
CITY OF COLUMBIA NEIGNTS, MINNESOTA 14
ANNUAL FINANCIAL REPORT
COMBINED STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN
RETAINED EARNINGS - ALL PROPRIETARY FUND TYPES
Year Ended December 31, 1982
OPERATING REVENUES:
Sales
Cost of sales
Gross Profit
OPERATING EXPENSES:
Personal services
Other services and charges
Supplies
Source of supply /Disposal charges
Total
OPERATING INCOME BEFORE DEPRECIATION
DEPRECIATION
OPERATING INCOME
NONOPERATING REVENUES (EXPENSES):
Interest income
Interest expense
Other income (expense) - net
Total
Net Income
Transfer from other funds
Transfers to other funds
Transfer depreciation on contributed assets
Extraordinary income
RETAINED EARNINGS (DEFICIT)
AT BEGINNING OF YEAR
RETAINED EARNINGS (DEFICIT)
AT END OF YEAR
CITY OF COLUMBIA NEIGNTS, MINNESOTA 15
Enterprise
2,427,915
781,624
1,646,291
367,772
135,676
46,471
699,575
1,249,494
396,797
101,189
295,608
172,135
(1,485)
(23,559)
147,091
442,699
(52,094)
65,229
292,518
2,540,155
$3,288,507
ANNUAL FINANCIAL REPORT
�I
Internal
Service
$ 136,938
136,938
76,668
43,026
11,100
130,794
0
6,144
5,155
989
3,901
78
3,979
4,968
16,717
$ 21,685
CITY OF COLUMBIA NEIGNTS, MINNESOTA
Form A -3
Total
(Memorandum Only)
1982 1981
$ 2,564,853 $ 2,77 ,900
781,624. 852,135
1,783,229 1,922,765
444,440
178,702
57,571
699,575
1,380,288
402,941
106,344
296,597
585,417
196,544
62,597
818,179
662,727
260,028
113,141
146,887
176,036
95,535
(1,485)
(1,851)
(23,481)
595,410
151,070
689,094
447,667
835,981
-
26,000
(52,094)
(61,000)
65,229
-
292,518
-
2,556,872 278,628
ci u n i4q ti n7a Ana
16 ANNUAL FINANCIAL REPORT
COMBINED STATEMENT OF CHANGES IN FINANCIAL POSITION
ALL PROPRIETARY FUND TYPES
Year Ended December 31, 1982
SOURCES OF WORKING CAPITAL:
Operations:
Net income (loss)
Items not requiring (providing)' working capital
Depreciation
Gain on disposal fixed assets
Proceeds from sale of fixed assets
Working Capital Provided by Operations
Extraordinary income
Decrease in long term contract receivable
Increase in deferred credit - revaluation MWCC
Decrease in deferred receivable- reserve capacity
Transfers from other funds
Total Sources of Working Capital
USES OF WORKING CAPITAL:
Additions to property and equipment -net
Reduction of due to other funds
Decrease deferred credit - revaluation gain
Increase long -term contract receivable MWCC
Transfers to other funds
Total Uses of Working Capital
INCREASE (DECREASE) IN WORKING CAPITAL
ELEMENTS OF NET INCREASE (DECREASE) IN WORKING CAPITAL:
Cash
Investments
Accounts receivable
Inventory
Accounts payable
Due to other funds
Due from /to Metro Waste Control Commission
Accrued liabilities
Net Increase (Decrease) in Working Capital
CITY OF COLUMBIA NEIGNTS, MINNESOTA
17
Enterprise
$ 390,605
101,189
491,7_9T
292,518
10,571
1,597
796,480
20,429
15,400
292,518
328,347
468,133
(3,864)
176,776
225,125
5,444
68,625
(1,100)
(2,873)
x,133
ANNUAL FINANCIAL REPORT
'
Form A -4
a
Total
Internal (Memorandum Only)
'
Service 1982 1981
$ 4,968 $ 395,573 $ 800,981
'
5,155 106,344 113,141
(576,975)
651,611
'
$ 10,123 501,917 $ 988,758
- 292,518 -
'
_ 10,571 10,165
- 1,597 1,502
- - 26,000
10,123 806,603 1,026,425
'
14,837 35,266 23,024
- 15,400 14,300
292,518 10,165
- - 26,000
'
14,837 343,184 73,489
(11,714) .463,419 952,936
(1,445) (5,309) (7,252)
1,700 178,476 1,032,000
'
(150) 224,975 39,770
(66) 5,378 (252)
- (4- 753)- - -- - - 63;872- --0-1-8- 501I
(1,100) (2,750)
7,604
(2,873) 2,317
,71 3 +19 952,
CITY Of COLUMBIA NEIGNTS, MINNESOTA 18 ANNUAL FINANCIAL REPORT
11
CITY OF COLUMBIA HEIGHTS, MINNESOTA
NOTES TO FINANCIAL STATEMENTS
DECEMBER 31, 1982
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, high-
ways and streets, sanitation, health and social services, culture- recreation,
public improvements, planning and zoning, and general administrative services.
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.
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.
Special Assessment Funds - Special Assessment Funds are used to account
for the financing of public improvements or services deemed to benefit
the properties against which special assessments are levied.
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
ITT OF COLUMBIA NEICNTS, MINNESOTA 19 ANNUAL RNANC1AL REPORT
CITY OF COLUMBIA HEIGHTS, MINNESOTA
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1982
Note 1 - Summary of Significant Accounting Policies (Continued)
A. FUND ACCOUNTING (Continued)
Proprietary Funds (Continued) --
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, accounta-
bility, 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 their departments or agencies of the City, or 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 spend-
ing or "financial flow" measurement focus. This means that only current
assets and current liabilities are generally included on their balance
sheets. Their reported fund balance is considered a measure of "avail-
able spending 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 .along with other general fixed assets.
No depreciation has been provided on general fixed assets.
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 single exception to this general rule is for
special assessment bonds, which are accounted for in Special Assessment
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.
All proprietary funds are accounted for on a cost of services or "capital
maintenance" measurement focus. This means that all assets and all lia-
bilities associated with their activity are included on their balance
sheets. Their reported fund equity is segregated into contributed capital
CITY OF COLUMBIA NEIGNTS, MINNESOTA 20 ANNUAL FINANCIAL REPORT
e
CITY OF COLUMBIA HEIGHTS, MINNESOTA
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1982
' Note 1 = Summary of Significant Accounting Policies (Continued)
B. MEASUREMENT FOCUS (Continued)
and retained earnings components. Proprietary fund type operating state-
ments present increases (revenues) and decreases (expenses) in net total
' assets.
C. BASIS OF ACCOUNTING
Basis of accounting refers to when revenues and expenditures or expenses
are recognized in the accounts and reported in the financial statements.
Basis of accounting relates to the timing of the measurements made, re-,
' gardless of the measurement focus applied.
All governmental funds are accounted for using the modified accrual basis
of accounting. Their revenues are recognized when they become measurable
and available as net current assets.
Expenditures are generally recognized under the modified accrual basis
of.accounting when the related fund liability is incurred. Exceptions
to this general rule include:
(a) accumulated unpaid vacation, sick pay, and other employee amounts
which are not accrued; and,
(b) principal and interest on general long -term debt which is recognized
when due.
All proprietary funds are accounted for using the accrual basis of account-
ing. Their revenues are recognized when they are earned, and their ex-
penses are recognized when they are incurred. Unbilled utility service
receivables are recorded at year end.
D. BUDGETS AND BUDGETARY ACCOUNTING
The City follows these procedures in establishing the budgetary data
reflected in the financial statement's.
(a) Prior to January 1st, the budget is adopted
(b) Formal budgetary integration is employed as
device during the year for the General Fund
Funds. Formal budgetary integration is not
funds.
(c) Budgets for the General and Special Revenue
basis consistent with generally accepted ac,
(GAAP).
by the City Council.
a management control
and Special Revenue
employed for other
are adopted on a
:ounting principles
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 expenditures 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.
CITY OF COLUMBIA NEIGNTS, MINNESOTA 21 ANNUAL FINANCIAL REPORT
CITY OF COLUMBIA HEIGHTS, MINNESOTA
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
t
DECEMBER 31, 1982
Note 1 - Summary of Significant Accounting Policies (Continued)
'
E. ASSETS AND LIABILITIES
Cash and Temporary Investments - Cash available,in excess of immediate
needs, is invested temporarily in savings accounts, savings certificates,
and short -term government obligations. Interest income is recognized
'
as earned and is recorded in the fund from which the investment was pur-
chased.
Advance to Other Funds - Noncurrent portions of long -term interfund
,
loans receivable are offset by a fund balance reserve account which
indicates that they do not constitute "available resources" since they
are not a component of net current assets. Current portions of long -term
'
interfund loans receivable are considered "available spendable resources ".
Taxes Receivable - Allowances are provided for the full amount of delin-
quent taxes receivable. This has the effect of recognizing property tax
revenues at the time property taxes are collected.
Inventories - Inventories of the proprietary funds are stated at the
lower of FIFO cost (first -in, first -out) or replacement market.
Fixed Assets /Property and Equipment - All fixed assets are valued at
'
historical cost or estimated historical cost if actual historical cost
is not available. Donated fixed assets are valued'at their estimated
fair value on the date donated.
'
Depreciation of all exhaustible fixed assets used by proprietary funds
is charged as an expense against their operations.* Accumulated depre-
ciation 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.
Buildings 40 -50 Years
Mains & Lines 50 -100 Years
'
Structures 5 -20 Years
Equipment 5 -20 Years
*Depreciation
'
on contributed assets in the water and sewer utility funds
is added back to income.transferred to retained earnings and is deducted
from contributed fund equity.
'
Accumulated Unpaid Vacation, Sick Pay, and Other Employee
Benefit Amounts - The City compensates all employees upon termination
for unused vacation up to a maximum based upon length of service. The
expense for vacation pay is recognized when payment is made. The accumu-
lated liability for unpaid vacation benefits at December 31, 1982, was
approximately $102,679.
'
City employees are entitled to sick leave at the rate of eight (8) hours
for each calendar month of full -time service. Sick pay is expensed as
paid. In addition, there is a contingent liability for unused sick leave
,
:ITY OF COLUMBIA NEIGNTS, MINNESOTA ANNUAL FINANCIAL REPORT
'
22
CITY OF COLUMBIA HEIGHTS, MINNESOTA
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1982
Note 1 - Summary of Significant Account!nq Policies (Continued)
E. ASSETS AND LIABILITIES (Continued)
Accumulated Unpaid Vacation, Sick Pay, and Other Employee.
Benefit Amounts (Continued) -
earned, approximately $390,470 which would be payable in the event sick-
ness occurred or upon termination 1/3 of earned sick leave (maximum 40
days) would be paid. Certain job classifications would be entitled the
one - fourth payment of earned sick leave only if termination was for the
reasons of retirement or death. Additionally, after an employee has
accumulated the maximum of 120 days, one -half of the excess sick leave
earned shall be granted as additional vacation leave at the end of the
year. These liabilities are stated at the 1982 rate of pay and are not
recorded as liabilities in the individual fund balance sheets.
F. .ENCUMBRANCES
Encumbrance accounting, under which purchase orders, contracts, and other
commitments, for the expenditure of monies are recorded in order to reserve
that portion of the applicable appropriation, is employed as an extension
of formal budgetary integration in the General Fund, Special Revenue Funds,
Capital Projects Funds, and Special Assessment Funds. Encumbrances out-
standing at year end are reported as reservations of fund balances since
they do not constitute - expenditures or liabilities.
G. COMPARATIVE DATA
Comparative data for the prior year has been presented to provide an under-
standing of changes in the City's financial position and operation.
H. TOTAL COLUMNS ON COMBINED STATEMENTS - OVERVIEW
Total columns on the Combined Statements - Overview are captioned
Memorandum Only to indicated 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.
CITY OF COLUMBIA NEIGNTS, MINNESOTA
23
ANNUAL FINANCIAL. REPORT
CITY OF COLUMBIA HEIGHTS, MINNESOTA
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31 1982
Note 2 - Accounting Change
In 1982, the City changed its accounting policy with respect to depreciation on
contributed assets in the Water and Sewer Utility Funds. Property and equipment
in the Water and Sewer Funds include assets financed by customer contributions
(assessments) and Government Grants. Prior to 1982, depreciation on these assets
was included as an expense in determining net income transferred to retained
earnings. In 1982, the.decision was made to charge depreciation on contributed
assets to contributed fund equity. This accounting change reflects the intent
of the City Council not to provide for replacement of water and sewer systems
from fund operations. The results for 1981 have been restated to show the result
of the accounting change which is summarized below. ,
Water Fund Sewer Fund
Accumulated Depreciation, January 1, 1981 $695,198 $716,836
1981 Depreciation 26,294 38,935
1982 Depreciation 26,294 38.935
Increase in retained earnings /decrease in
contributions, December 31, 1982 $747,786 $794,706
Note 3 - Deficit Fund Balance
The Permanent Improvement Revolving Bond Fund had a deficit balance of $2,544,057
at December 31, 1932. This deficit will be offset by the collection of special
assessments in future years.
Note 4 - Proprietary Funds Contract Receivable and Deferred Receivable
A. INTERCEPTOR ACQUISITION CONTRACT RECEIVABLE
As of January 1, 1971, the Metropolitan ',taste Control Commission (M.W.C.C.)
assumed ownership of all existing interceptors and treatment works. Under the
terms of the agreement with the M.W.C.C., the City is to be reimbursed for
the value at the time of transfer of such facilities.
CITY OF COLUMBIA NEIGNTS, MINNESOTA
24
ANNUAL FINANCIAL REPORT
' CITY OF COLUMBIA HEIGHTS, MINNESOTA
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1982
' Note 4 - Proprietary Funds Contract Receivable and Deferred Receivable
Continued
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 4 %.
Prior to 1982, the City received credits against M.W.C.C. billings totaling
' $244,992, of which $108,015 was treated as a reduction of principal. During
1982, the City received a credit of $22,272, of which $10,571 was a re-
duction of principal. As of December 31, 1982, a balance of $281,947 re-
' mained to be collected over the next nineteen 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, 1982 was $29,531 and is
' collectible over the next eight years. During 1982, the City received
$2,645 related to this receivable, of which $1,598 represented a reduction
of principal.
As stated in Note 2, the City recognized the deferred gain in 1982 repre-
sented by these receivables.
Note'5 - Changes in General Fixed Assets
Changes in General Fixed Assets Group of Accounts.during 1982 were as follows.
TOTAL $ 8,235,979 $ 573,749 $ 491,379 $ 8,318,349
CITY OF COLOMBIA NEICNTS, MINNESOTA 25 ANNUAL FINANCIAL REPORT I
Adjustments
Balance
and
Balance
Jan.l, 1982
Additions
Retirements
Dec. 31, 1982
Land
$ 3,794,970
$ 458,474
$ 3,336,496
Buildings S Structures
2,872,629
$ 497,401
3,370,030
Furniture, Fixtures
624,817
7,669
632,486
Office Equipment
Machinery & Equipment
943,563
68,679
32,905
979,337
TOTAL $ 8,235,979 $ 573,749 $ 491,379 $ 8,318,349
CITY OF COLOMBIA NEICNTS, MINNESOTA 25 ANNUAL FINANCIAL REPORT I
C
CITY OF COLUMBIA HEIGHTS, MINNESOTA
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1982
Note 6 -'Proprietary Fund Types Property and Equipment
A summary of the enterprise funds property and equipment at December 31, 1982
follows.
$ 66,283 $1,514,140 $1,447,584 $3,028,007
A summary of the internal service funds property and equipment at December 31,
1982 follows.
Central
Garage
Buildings & Improvements $13,795
Office Furniture & Equipment 741
Machinery & Equipment 66,357
$80,893
Less Accumulated Depreciation 49,815
$31,078'
Note 7 - Retirement Plans
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 - PERA). By agreement, the Fire Relief Associa-
tion 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 1982 the amounts were:
Levy
Police Relief (7) $100,512
Fire Relief - Paid (5) 65,976
Fire Relief - Volunteer (18) 8,185
ITT OF COLUMBIA NEIGNTS, MINNESOTA $174,67-3
State -Aid Total
$51,3i8 $151,830
32,156 98,132
8,185
$ T +7 - $25T,1 —7
26 ANNUAL FINANCIAL REPORT
Water
Sewer
Liquor
Utility
Utility
Total
Land
$ 7,125
$ 45,223
$ 36,586
$ 88,934
Buildings
70,260
210,987
24,308
305,555
Improvements other than
Buildings
19,665
2,162,452
2,333,410
4,515,527
Office Furniture & Equipment
32,948
32,948
Machinery & Equipment
872
111,601
179,489
291,962
$130,870
$2,530,263
$2,573,793
$5,234,926
Less Accumulated Depreciation
64,587
1,016,123
1,126,209
2,206,919
$ 66,283 $1,514,140 $1,447,584 $3,028,007
A summary of the internal service funds property and equipment at December 31,
1982 follows.
Central
Garage
Buildings & Improvements $13,795
Office Furniture & Equipment 741
Machinery & Equipment 66,357
$80,893
Less Accumulated Depreciation 49,815
$31,078'
Note 7 - Retirement Plans
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 - PERA). By agreement, the Fire Relief Associa-
tion 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 1982 the amounts were:
Levy
Police Relief (7) $100,512
Fire Relief - Paid (5) 65,976
Fire Relief - Volunteer (18) 8,185
ITT OF COLUMBIA NEIGNTS, MINNESOTA $174,67-3
State -Aid Total
$51,3i8 $151,830
32,156 98,132
8,185
$ T +7 - $25T,1 —7
26 ANNUAL FINANCIAL REPORT
11
f
CITY OF COLUMBIA HEIGHTS, MINNESOTA
NOTES TO.FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1982
Note 7 —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 5% of the unfunded liability. In accordance with the Police and Firemen's
Relief Associations Guidelines Act of 1969 as amended by Laws of Minnesota 1978,
Chapter 563, the annual levy includes an amount for the amortization of the un-
funded pension liability by the year 2005.. In prior years, as allowed by State
Law, contributions did not provide for the amortization of the unfunded liability.
The following schedule
of accrued liabilities was obtained,from the latest
actuarial surveys dated
December 31,
1982.
Funded
Accrued
Funded (Unfunded)
Reserves
Liability
Accrued Liability
Police Relief
$1,145,069
$2,795,300
$(1,650,231)
Fire Relief - Paid
762,282
2,148,813
(1,386,531)
Fire Relief - Volunteer
505,717
316,148
189,569
The City participates in a contributory pension plan under the Public Employees
Retirement Association (PERA), Minnesota Statutes, Chapter 353, which covers
substantially all employees except those qualifying as temporary or seasonal
employees or those public safety police and fire personnel covered by the relief
associations. The City's contribution for the coordinated plan (PERA and Social
Security) to PERA is equal to 5.5% of the total salary of each individual (em-
ployee share 4 %). For the basis plan, the City's contribution is equal to 10.5%
of each individual's salary (employee share 8 %). For Police and Fire PERA, the
City's contribution is equal to 12% of each individual's salary (employee share
8 %). The pension cost including amortization of estimated prior service cost
was $ for the year ended�December 31, 1982. It is State Law that the
City fund this pension cost as it accrues. Prior service cost is being amortized,
over a period of 40 years with full funding required by the year 1997, as a per-
cent of gross wages by all employees participating in the state association. The
amount of unfunded prior service cost attributable to individual reporting entities
is not determinable.
The City's contribution to the Federal Insurance Corporation of America (Social
Security) for those individuals belonging to the coordinated plan is equal to
6.7% of the first $ 32, 400 in 1982 or total of $69,053.
Note 8 - Changes in Long -Term Debt
Changes in bonds payable during 1982 are summarized as follows (in thousands
of dollars).
CITY OF COLUMBIA NEIGNTS, MINNESOTA 27 ANNUAL FINANCIAL REPORT
,
CITY OF COLUMBIA HEIGHTS MINNESOTA
NOTES TO FINANCIAL STATEMENTS
(CONTINUED)
'
DECEMBER 31, 1982
Note 8 - .Changes in Long -Term Debt (Continued)
'
Balance
Jan. 1, 1982 Issued
Balance
Retired December 31, 1982
'
General Bonds 725
340
385
Tax Increment Bonds 8,175 450
8,625
Special Assessment 5 2,550
5
2,550
'
Total 8,905 3,000
345
11,560
Bonds payable at December 31, 1982 are comprised of
the following issues.
General Bonds--
'
Storm Sewer Bonds of 1965, 3.60, Payable
$130,000 in 1983 and $140,000 in 1984
$270,000
Capital Improvement Bonds of 1976, 4.45 % -
'
4.6%, Payable in 1983
$115,000
$385,000
'
Tax Increment Bonds- -
Tax Increment Bonds of 1980, 8.0 %- 8.75 %,
'
Payable in Varying Annual Amounts to $2,002
$8,175,000
Tax Increment Bonds of 1982, 6.7 %, Payable
in 1985
$ 450,000
'
$8,625,000
'
Special Assessment Bonds --
Permanent Improvement Revolving Bonds of 1982,
6.7 %, Payable in 1985
$2,550,000
'
$11,560,000
,
The annual requirements to amortize all.bonded debt
outstanding at December 31,
1982, including interest payments of $8,795,925 are
as follows.
'
Year Ending General Tax
Special
December 31 Obligation Increment
1983 260 713
Assessment
171
Total
1,144
,
1984 145 712
171
1,028
1985 -- 1,152
2,721
3,873
1986 -- 8o6
--
806
'
1987 -- 843
--
843
1988 -92 -- 4,711
--
4,711
1993 -97 -- 5,043
--
5,043
'
1998 -02 -- 3,423
--
3,423
—TO-5 17 70-3
—3—,06-3— 201
:ITY OF COLUMBIA NEIGNTS, MINNESOTA 28
ANNUAL
FINANCIAL REPORT
'
CITY OF COLUMBIA HEIGHTS, MINNESOTA
' NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1982
' Note 8 -Changes in Long -Term Debt (Continued)
' $656,093 is available in the Debt Service Funds to service the general obligation
and tax increment bonds. There are a number of limitations and restrictions con-
tained in the various bond indentures. The City is in compliance with all signi-
ficant limitations and restrictions.
The General Obligation Bonds are payable primarily from general property taxes.
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 with any deficiencies to
be provided by general property taxes.
Note 9 - Interfund Receivable and Payable Balances
' Receivable Payable
Special Revenue Funds
' Municipal State Aid Fund $103,368
Debt Service Funds
Storm Sewer Bonds of 1965' $ 15,400
' Special Assessment Funds
Permanent Improvement Revolving Fund $105;368
Enterprise Funds
Water Utility Fund $ 15,400
' $118,768 $118,768
Note 10 - Segment Information - Enterprise Funds
The City maintains three enterprise funds.
December 31, 1982 is as follows.
Sales., less cost of sales
of $781,624
Operating Revenue
Depreciation
Depreciation Transferred to
Contributions
Operating Income
Operating Transfers Out
Extraordinary Item
Net Income Before Extr. Item
Property & Equipment-Additions
Net Working Capital
Total Assets
Total Equity- Contributed
Total Equity- Retained Earnings
CITY OF COLUMBIA NEIONTS, MINNESOTA
Liquor
$185,346
4,116
27,307
Segment information for the year ended
.Water Sewer
Utility Utility Total
$711,433
41,772
(26,294)
(4,793)
136,995
1,864
950
2,537
1,354,326
264,795
1,460,190
1,839,016
1,119,748
1,420,609
659,187
$749,512
55,301
(33,935)
273,094
52,094
292,518
303,840
16,942
546,071
2,364,373
!1,096,422
1,208,701
$185,346
$1,460,945
101,188
(60,229)
295,608
52,094
292,518
442,699
20,429
2,165,192
5,663,579
2,216,170
3,288,497
ANNUAL FINANCIAL REPORT
CITY OF COLUMBIA HEIGHTS, MINNESOTA
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
DECEMBER 31, 1982
Note 11 - Reserved Fund Equity
The following reservations of fund equity have been made as of December 31, 1982.
General Fund
Encumbrances $ 12,762
Debt service funds
Debt service 656,093
Internal service funds - Central Garage
Improvement costs 12,205
$ 681,060
Note 12 - Contingent Liability
The City participates in a number of federally assisted grant programs, principal
of which are the General Revenue Sharing & Community Development Block Grant. These
programs are subject to program compliance audits by the grantors or their repre-
sentatives. The audits'of these programs for or including the year ended December
31, 1982 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 be disallowed by the granting agencies cannot be
determined at this time although the City expects such amounts, if any, to be
immaterial.
Note 13 - 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 14 - Extraordinary Income - Enterprise Funds (Sewer Fund)
In 1982, the remaining balance of the deferred credit in the Sewer Fund balance
sheet, representing the deferred gain on the interception sale to the Metropolitan
Waste Control Commission was recognized as income. Previously, the gain was
recognized through annual reductions in disposal charges. The amount of the gain
recognized in 1982, $292,518, is shown as extraordinary income in the Sewer Fund's
Statement of Revenue and Expense.
CITY Of COLUMBIA NEIGNTS, MINNESOTA
30
ANNUAL FINANCIAL REPORT
I
0
G
i
i
HE CITX OF COLUM IA HEIGHTS, MINNESOTA
NNUA TINACIAL KEP RT
EAR kNDED BECEMBER 31, 1982
GENERAL FUND
The Home Rule Charter of the City 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."
TABLE OF CONTENTS
Page
Balance Sheet
Form
B
31
Statement of Revenues, Expenditures and
Changes in Fund Balance
Form
B -1
32
Schedule of Revenues - Budget and Actual
Form
B -2
33 -34
Schedule of Expenditures - Budget
and Actual
Form,B
-3
35 -39
Form B
GENERAL FUND
COMPARATIVE BALANCE SHEET
December 31, 1982 and 1981
LCITY OF COLUMBIA NEIGNTS, MINNESOTA ANNUAL FINANCIAL REPORT
31
1982
1981
ASSETS
Cash:
Treasurer's balance
$ 184
$ 921
Imprest cash and change funds
1,675
1,075
Total Cash
$ 1,859
$ 1,99
Investments, at cost
1,706,190
349,000
Taxes receivable -- delinquent
12,888
29,510
Less: Allowance for uncollectible taxes
(12,888)
(29,510)
Accounts receivable:
Unbilled services
82,650
63,057
Accrued interest receivable
- 26,010
45,893
Other
4.1,156
15,104
Due from other funds
-
595,000
Due from other governmental units
2,849
552,967
Total Assets
$1,860,714
$1,623,017
LIABILITIES, AND FUND BALANCE,
Liabilities:
Accounts payable
$ 38,640
$ 32,979
Accrued salaries and withholdings
60,865
46,264
Deposits
7,164
5,083
Due to other governmental units
10,697
-
Deferred revenue
8,500
-
Total Liabilities
$ 125,866
$ 84,326
Fund Balance:
Reserved for laon to Permanent Improvement
Revolving fund
$ -
$ 595,000
Reserved for encumbrances
12,762
-
Unreserved
Designated for subsequent year's expenditures
94,069
258,620
Undesignated
1,628,017
685,071
Total Fund Balance -- Form B -1
$1,734,848
$1,538,691
Total Liabilities, and Fund Balance
$1,860,714
$1,623,017
LCITY OF COLUMBIA NEIGNTS, MINNESOTA ANNUAL FINANCIAL REPORT
31
Form B -1
GENERAL FUND
Other Financing Uses:
Transfers to other funds 94,495 91,886 2,609 93,933
Total Expenditures and
Other Uses $4,006,461 $3,723,071 $ 283,390 $ 3,888,917
Excess of revenues and
other sources over
(under) expenditures
and other uses
$ 77,794 $ 196,157
Fund' balance at beginning of
year 1,538,691 1,538,691
J
Fund balance at end of year $1,616,485 $1,734.,848
CITY OF COLUMBIA NEIGNTS, MINNESOTA
M
$ 118,363 $ 29,785
- 1,508,906
$ 118,363 $ 1,538,691
ANNUAL FINANCIAL REPORT
STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE
Year Ended December 31, 1982
With Comparative Actual Amounts
for Year Ended
December 31,
1981
'
1982 9
1981
Variance
1
Favorable
Budget
Actual
(Unfavorable)
Actual
Revenues:
Taxes
$ 943,655
$1,049,992
$ 106,337
$
906,074
Licenses and permits
92,440
148,773
56,333
104,027
Fines and forefeitures
61,200
47,073
(14,127)
67,301
Intergovernmental revenues
2,213,930
1,874,876 -1'
(339,054)
1,944,501
'
Charges for current services 565,200
.551,506
(13,694)
417,604
Miscellaneous
127,460
159,133
31,673
208,305
Refunded reimbursements
12,000
51,469
39,469
-
Total Revenues
$4,015,885
$3,882,822
$(133,063)
$
3,647,812
Other Financing Sources:
Transfers from other funds
68,370
-
36,406
(31,964)
270,890
Total Revenues and Other
Sources
$4,084,255
$3,919,228
$ (165,027)
$
3,918,702
Expenditures:
General government
$ 561,623
$ 532,444
$ 29,179
$
538,618
'
Public safety
1,501,363
1,454,404
46,959
1,380,692
Public works
620,390
581,121
39,269
576,754
Sanitation
491,155
403,670
87,485
336,997
Library
188,485
188,343
142
188,440
Parks
462,700
443,863
18,837
652,611
Other
86,250
27,340
58,910
120,872
Total Expenditures
$3,911,966
$3,631,185
$ 280,781
$
3,794,984
Other Financing Uses:
Transfers to other funds 94,495 91,886 2,609 93,933
Total Expenditures and
Other Uses $4,006,461 $3,723,071 $ 283,390 $ 3,888,917
Excess of revenues and
other sources over
(under) expenditures
and other uses
$ 77,794 $ 196,157
Fund' balance at beginning of
year 1,538,691 1,538,691
J
Fund balance at end of year $1,616,485 $1,734.,848
CITY OF COLUMBIA NEIGNTS, MINNESOTA
M
$ 118,363 $ 29,785
- 1,508,906
$ 118,363 $ 1,538,691
ANNUAL FINANCIAL REPORT
GENERAL FUND
SCHEDULE OF REVENUES - BUDGET, AND ACTUAL
Year Ended December 31, 1982
General property taxes:
Current ad valorem
Delinquent ad valorem
Penalties and interest
Total
Licenses and permits:
Business regulatory licenses
Non - business licenses and permits
Total
Fines and forfeitures:
Court fines
Other
Total
Revenue from use of money and property:
Interest earnings --
Investment Trust Fund
Loan to PIR fund
Rents
Total
Revenue from other agencies:
Shared state taxes:
Local government aid
Property tax relief (Homestead)
Insurance premium tax
Municipal state aid - maintenance
Attached machinery aid
State grant -- shade tree aid
Other
Anoka county:
Street maintenance
Federal aid:
Civil defense reimbursement
Total
CITY OF COLUMBIA NEIGNTS, MINNESOTA
Form B -2
Variance
Budget Actual Favorable
Revenue Revenue (Unfavorable)
$ 940,655 $ 1,032,1.65 $ 91,510
- 15,503 15,503
3,000 2,324 (676)
$ 943,655 $ 1,049,992 $ 106,337,
$ 27,240 $ 48,841 $ 21,601
65,200 99,93? 34,732
$ 92,440 $ 148,773 $ 56,333
$ 60,000 $ 45,650 $ (14,350)
1,200 1,423 223
$ 61,200 $ 47,073 $ (14,127)
$ 100,000 $ 58,741 $ (41,259)
- 65,450 65,450
22,460 20,888 (1,572)
$ 122,460 $ 145,079 $ 22,619
$.1,449,525 $ 1,268,029 $ (181,496)
598,625
434,392
(164,233)
83,000
83,474
474
15,000
13,838,'
(1,162)
5,j40
5,6491
(91)
12,000
5,553;
(6,447)
38,020
44,054,
I
6,034
6,020
12,040 j
6,020
6,000 7,8471 1,847
$2,213f930 $ 1,874,876 $ (339,054)
33 ANNUAL nNANC1AL REPORT
Form B -2
GENERAL FUND
SCHEDULE OF REVENUES - .BUDGET AND ACTUAL (CONTINUED)
Year Ended December 31, 1982
CITY OF COLUMBIA NEIGNTS,- MINNESOTA
34
ANNUAL FINANCIAL REPORT
Variance
Budget
Actual
Favorable
Revenue
Revenue
(Unfavorable)
Other revenue:
Sale of land
$
-
$ 199
$
199
Gain sale equipment
2,000
8,061
6,061
Miscellaneous
3,000
5,794
2,794
Total
$
5,000
$ 14,054
$
9,054
Charges for current services:
General government
$
2,300
$ 3,321
$
1,021
Public safety
34,250
38,379
4,129
Public works
6,050
15,821
9,771
Library
3,100
4,044
944
Parks
29,500
31,860
2,360
Refuse collection
490,000
457,058
(32,942)
Other
-
1,023
1,023
Total
$
565,200
$ 5.51,506
$
(13,694)
Refunds and reimbursements:
Construction labor
reimbursement
$
7,000
$ 16,562
$
9,562
Equipment rental
reimbursement
4,000
8,880
-4,880
Other reimbursements
1,000
26,027
25,027
Total
$
12,000'
$ 51,469
$
39,469
Total Revenue
$4,015,885
$ 3,882,822
$
(133,063)
Other Sources:
Transfers from other funds
Sullivan Lake Fund
68,370
36,406
(31,964)
Grand Total
$4,084,255
$ 3,919,228
$ (165,027)
CITY OF COLUMBIA NEIGNTS,- MINNESOTA
34
ANNUAL FINANCIAL REPORT
GENERAL FUND
SCHEDULE OF EXPENDITURES
BUDGET AND ACTUAL
Year Ended December 31, 1982
GENERAL GOVERNMENT:
Mayor and Council:
Personal services
Other services and charges
Supplies
Total
City Manager:
Personal services
Other services and charges
Supplies
Total
Finance - Clerk:
Personal services
Other services and charges
Supplies
Total
Elections:
Personal services
Other services and charges
Supplies
Total
Assessing:
Personal services
Other services and charges
Supplies
Total
Lega 1 :
Other services and charges
[CITY OF COLUMBIA NEICNTS, MINNESOTA
Form B -3
1982
Unemcumbered
Original Budget (Overexpended)
Bud _get (Revised) Expenditures Balance
$ 44,255 $ 56,420 $' 56,371
68,805 46,155 44,116.
900 900 913
113,9 Z 0 $ 10$ 10+ 3+75 $ 101,400
$ 79,495 $ 82,425 $ 82,391
16,000 19,660 19,637
500 500 154
99 5,995 $ 102,5`5 $ 102_,1T2_
$ 49
2,039
(13)
$ 2,075
$ 34
23
346
$ 403
$ 77,140
$ 77,140
$ 75,305
$ 1,835
29,555
29,555
30,839
(1,284)
1,700
1,700
1,732
(32)
10 ,395
10 8,395
107,87-6 '�
519
$ 8,000
$ 8,000
$ 7,675
$ 325
1,150
1,150
986
164
400
40o
53
347
$ 9,550
$ 9,550
$ 8,714 ./
$ 836
$ 52,025 $ 57,425 $ 64,805
11,770 9,070 1,653
600 600 484
x,395 $ 67,095 $ 66,942
$ 66,950 $ 66,950 $ 53,861 J
35
$ (7,380)
7, 41.7
116
$ 153
$ 13,089
ANNUAL FINANCIAL REPORT
7
Form B -3
GENERAL FUND
SCHEDULE OF EXPENDITURES (CONTINUED)
BUDGET AND ACTUAL
Year Ended December 31, 1982
1982 '
Unencumbered
Original Budget (Overexpended)
Budget- (Revised) Expenditures Balance
General Government Buildings:
Personal services $ 12,215
GENERAL GOVERNMENT (continued):
$ 10,789 $
1,426
Other services and charges 56,085
56,085
48,390
Planning:
Supplies 8,900
8,900
6,681
'
Personal services
$ 33,590
$ 23,773 $
24,820 $
(1, 047)
$ 854,599
Other services and charges
1,475
1,470
640
830
'
Supplies
Total
- 1,305
$
1 130
373 $
149
81
76
25,6094/ $
40,000
36,900
General Government Buildings:
Personal services $ 12,215
$ 12,215
$ 10,789 $
1,426
Other services and charges 56,085
56,085
48,390
7,695
Supplies 8,900
8,900
6,681
2,219
Total 77,200
77,200
65,-BTO-f
11,340
Total General Government$572,815 $ 561,623 $ 532,444 $ -29,179
'
PUBLIC SAFETY:
Police Protection:
Personal services
$881,385
$ 854,599
$ 848,602
$ 5,997
'
Other services and
charges
46,405
38,655
40,526
(1,871)
Supplies
40,000
36,900
30,393
6,507
Total
967,790
$ 93- 0
$ 919,521°
$ 10,633
'
Fire Protection:
Personal services
$425,335
$ 410,059
$' 387,174
$ 22,885
Other services and
charges
36,750
32,120
25,011
7,109
'
Supplies
Total
-
17,495
7� 9,5 0
16,780
$ 458,95-9
10 959
$ 4231144
5,821
35,815
Protective Inspection:
'
Personal services
$ 60,725
$ 64,125
$ 64,083
$ 42
Other services and
charges
10,345
16,045
15,961
84
'
Supplies
Total
1,660
72,730
1,660
81,830 _
1,356
$ 81, -4OO V
304
$ 430
Civil.Defense:
'
Personal services
$ 15,990
$ 16,090
$ 17,731
$ (1,641)
Other services and
charges
8,355
8,055
6,376
1,679
Supplies
1,075
525
530
(5)
Total
25, 20
24,67-6
24,6Mr
T 33
CITY OF COLUMBIA NEIGNTS, MINNESOTA
36
ANNUAL FINANCIAL REPORT
Form B -3
GENERAL FUND
SCHEDULE OF EXPENDITURES (CONTINUED)
BUDGET AND ACTUAL
Year Ended December 31, 1982
'Unencumbered
Original Budget (Overexp.ended)
Budget (Revised) Expenditures Balance
PUBLIC SAFETY: (continued)
Animal Control:
Other services and charges $ 6,000 $ 5,750 $ 5,702 $ 48
Supplies 400 - - -
Total $ 6,400 $ 5,750 $ 5,702,'' $ 48
Total Public Safety $1,551,920 $1,501,363 $1,454,404 $ 46,959
PUBLIC WORKS:
$ 204,750
$ 204,750
$
188,388
Engineering:
Other services and charges
67,170
61,170
(1,178)
Personal services
$ 141,405 $
138,090
$ 136,414
$ 1,676
Other services and charges
14,535
10,975
9,101
1,874
Supplies
6,300
6,300
4,043
2,257
Total
$ 162,240 $
155,365
$ 149,55V/
Street Maintenance:
Personal services
$ 204,750
$ 204,750
$
188,388
$ 16,362
Other services and charges
67,170
61,170
(1,178)
67,520
(6,350)
Supplies
48,800
45,800
Supplies
Total
34,152 !
1
11 648
Total
$- 320,720
$ 311,720
$
290,060
$$ 2
Street Lighting:
Personal services
$ 700
$ 700
$
181
$ 519
Other services and charges
61,000
65,500
65,021
J
479
Total
1,700
,200
$
65,202
$ 991
Traffic Signs and Signals:
14,190
$ 12,264 $
1,926
Other services and charges 57,685
Personal services
$ 15,700
$ 13,500 $
14,678 $
(1,178)
Other services and charges
11,040
11,040
11,180
(140)
Supplies
Total
13,200
-39-,-97 0
10 400
$940 $
7,428
33,286 T-1,654
2,972
Tree Trimming and Removal:
Personal services $ 14,190 $
14,190
$ 12,264 $
1,926
Other services and charges 57,685
37,800
30,725
7,075
Supplies 175
175
26
149
Total 72,050 $
52,165
$ 43,015 $
9,150
Total Public Works
I CITY OF COLUMBIA NEIGNTS, MINNESOTA
$ 656,650 $ 620,390 $ 581,121 $ 39,269
37
ANNUAL FINANCIAL REPORT
MUNICIPAL PARKS:
Administration and Maintenance:
Personal services
Other services and charges
Supplies
Capital outlay
Total
$ 282,225 $ 269,880 $ 259,030 $ 10,850
103,090
87,690
105,760
(18,070)
40,135
36,760
30,166
Form B -3
68,370
68,370
48,907
19,463
GENERAL FUND
$
$ 443,86T ✓
$ 18,837
'
SCHEDULE
OF EXPENDITURES
(CONTINUED)
BUDGET AND
ACTUAL
'
Year
Ended December
31, 1982
'
1982
Unencumbered
Original
Budget
(Overexpended)l
'
Budget
Revised
Expenditures
Balance
SANITATION:
Refuse Collection and
Disposal:
Personal services
$ 8,375
$
8,375
$
13,132
$ (4,757)
Other services and
charges
477,850
477,850
386,733
91,117
'
Supplies
750
750
495
255
Total
$ 486,975
$$
486,975
$
00,360,`/
$ 86,615
Weed Control:
'
Personal services
$ 4,000
$
4;000
$
3,154
$ 846
Other services and
charges
180
180
156
24
Total
$ 4,180
$
4,180
$
3,310"
$ 870
'
Total Sanitation
$ 491,155
$
491,155
$
403,670
$ 87,485
LIBRARY:
'
Personal services
$ 115,280
$
124,980
$
124,956
$ 24
Other services and
charges
25,425
24,650
24,310
340
Supplies
48,815
38,855
38,916
(61)
Capital outlay
-
-
161
(161)
Total
$ 189,520
$
188,485
$
188,343v
$ 142
MUNICIPAL PARKS:
Administration and Maintenance:
Personal services
Other services and charges
Supplies
Capital outlay
Total
$ 282,225 $ 269,880 $ 259,030 $ 10,850
103,090
87,690
105,760
(18,070)
40,135
36,760
30,166
6,594
68,370
68,370
48,907
19,463
493,825'
$
$ 443,86T ✓
$ 18,837
CITY OF COLUMBIA NEIGNTS, MINNESOTA 38 ANNUAL FINANCIAL REPORT
w
Form B -3
GENERAL FUND
SCHEDULE OF EXPENDITURES (CONTINUED)
BUDGET AND ACTUAL
Year Ended December 31, 1982
Unencumbered
Original Budget (Overexpended)
Budget (Revised) Expenditures Balance
UNALLOCATED EXPENSE:
Insurance
$ 6,000
$ 6,000
$ 275
$ 5,725
Taxes and licenses
500
500
976
(476)
Cable TV expense
-
-
9,573
(9,573)
Vandalism
1,000
1,000
-
1,000
Other miscellaneous
176,000
78,750
16,516
62,234
Total Unallocated
$ 183,500
$ 86,250
$ 27,340
$ 58,910.
Total Expenditures
$4,139,380
$3,911,966
$3,631,185
$ 280,781
Other Uses:
TRANSFERS TO OTHER FUNDS
Recreation
PARA Transit Fund
Community Center
Total Transfers
Grand Total
LCITY OF COLUMBIA NEIGNTS, MINNESOTA
$ 92,995 $ 83,995 $ 83,995 $ -
10,500 10,500 7,891 2,609
100,000 - - -
$ 203,495 $ 94,495 $ 91,886 $ 2,609
$4,342,875 $4,006,461 $3,723,071 $ 283,390
39
ANNUAL FINANCIAL REPORT
HE CITY OF COLUMZIA HEIGHTS, MINNESOTA
NNUA TINANCIAL EP RT
EAR LNDED DECEMBER S1, 1982
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.
The Revenue Sharing Fund is established by federal legislation to
account for the receipt and expenditure of general revenue sharing
funds. The Paratransit Fund is established by agreement with the
Minnesota Department of Transportation to account for the receipt
of state grants and rider fees and expenditures for service. The
Recreation and Community Service Fund is governed by a commission
established by an agreement between the City and I.D.S. #13 School
Board. The Municipal State -Aid Street Fund is maintained according
to state statute for the maintenance and construction of streets on
Municipal State -Aid System.
TABLE OF CONTENTS
Page
Combining Balance Sheet
Form
C
40 -41
Combining Statement of Revenues, Expenditures
and Changes in Fund Balances
Form
C -1
42 -43
Statements of Revenues, Expenditures and
Changes in Fund Balance:
Revenue Sharing Fund
Form
C -2
44
Park Dedication Fees
Form
C -3
45
Recreation and Community Services Fund
Form
C -4
46
Paratransit Fund
Form
C -5
47
Municipal State Aid Street Fund
Form
C -6
48
Cable Television Fund
Form
C -7
49
C.E.T.A. Fund
Form
C -8
50
SPECIAL REVENUE FUNDS
COMBINING BALANCE SHEET
December 31, 1982
With Comparative Totals for December 31, 1981
Park Recreation
Revenue Dedication S Community
Sharing Fee Services
ASSETS
Cash:
Treasurer's balance (deficit)
$ 38
$
36
$
40
Imprest cash
50
Total Cash
$
$
36
$
90
Investments, at cost
281,100
83,800
38,000
Accounts receivable
-
-
_
Due from other governmental units:
Due from Federal - Revenue Sharing
28,533
-
-
Due from State of Minnesota
-
Due from Anoka-County
Total Assets
$309,671
$
83,836
$
38,090
LIABILITIES, AND FUND BALANCE
Liabil.ities:
Accounts .payable
$ 9,249
$
-
$
25
Accrued salaries payable
-
-
3,201
Accrued social security/P.-E.R.A. payable
-
-
-
Due to Other Funds
-
-
-
Total Liabilities
$ 9,249
$
-
$
3,226
Fund Balance Unreserved:
Designated for subsequent year's
expenditures
$122,545
$
33,590
$
Undesignated
177,877
50,246
34,864
Total Fund Balance
$300,422
$
83,836
$
34,864
Total Liabilities, and
Fund Balance
$309,671
$
83,836
$
38,090
CITY OF COLUMBIA NEIGNTS, MINNESOTA
40
ANNUAL FINANCIAL REPORT
Paratransit
$ 30
30
3,500
76
3.003
$ 6,609
$ 6,609
$ 6,609
$ 6,609
Municipal
State Cable
Aid Television
$ (6,668) $ -
T --- (;-,-67M -
119,580 -
4,464
33,103 -
$ 146,015 $ 4,464
103,368
$ 1031368 $ -
Fo rm C
Totals
1982 1981
$ (6,524) $ (4,560)
50 50
(6,477) ,510)
525,980 186,000
4,540
28,533 37,736
36,106 54,508
1
$ 15,883 . $ 11,036
3,201 2,187
- 229
103,368 40,454
$ 122,452 $ 43,906
$ $ $ 156,135 $ 19,335
42,647 4,464 310,098 210,493
$ 42,647 $ 4,464 $ 466,233 $ 229,828
a CITY OF COLUMBIA NEIGNTS, MINNESOTA
41 ANNUAL FINANCIAL REPORT
SPECIAL REVENUE FUNDS
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE
Year Ended December 31, 1982
With Comparative Totals for Year Ended December 31, 1981
Recreation &
Other Uses:
Revenue
Park
Community
Revenues:
Sharing
Dedication
Services
Revenue from other agencies:
-
Total Expenditures and other uses
$
611150
Federal
$ 141,743
$
-
$
-
State of Minnesota
-
(under) Expenditures and other uses
-
-
Independent School District #13
Fund balance at beginning of year, before
adjustment
83,995
Interest earnings
24,207
Adjustment to remove receivable from
2,990
-
Fees
-
State for unearned State Aid
80,846
-
36,489'`
Other revenue
-
Fund balance beginning of year, restated
-
195,622
-
Total Revenues
$ 165,950
$
83,836
$
120,484
Other Financing Sources:
34,864_
Transfers from other funds
-
-
83,995
Total Revenues and Other Sources
$ 165,950
$
83,836
$
204,479
Expenditures:
Public safety
$ 41,841
$
-
$
-
Parks
-
'
Street and engineering
14,919
-
-
Library
2,558
-
-
Recreation
-
-
190,532
Downtown development
-
-
-
State -aid construction
-
-
-
Parking lot
-
-
-
Para transit
-
-
-
C.E.T.A.
-
-
-
Miscellaneous
1.832
-
-
>>
I
Total Expenditures
$ 61,150
$
-
$
190,532
Other Uses:
Transfer to other funds
-
-
Total Expenditures and other uses
$
611150
$ -
$
190,532
Excess of Revenues and Other over
$
104,800
$ 83,836
$
13,947
(under) Expenditures and other uses
Fund balance at beginning of year, before
adjustment
Adjustment to remove receivable from
State for unearned State Aid
-
-
-
Fund balance beginning of year, restated
$
195,622
$ -
$
20,917
Fund balance end of year
$
300,422
$ 83,836
$
34,864_
CITY OF COLUMBIA NEICNTS, MINNESOTA
42
ANNUAL FINANCIAL REPORT
Form C -1
7,891 - -
Municipal
93,933
$ 29,433 $ 102,314 $ 4,464
$ 590,476
$ 794,424` r
State
Cable
$ 35,739
Totals
Paratransit
Aid
Television
1982
1981
$ -
$ -
$ -
$ 141,743
$ 165,051
.15,524
102,314
-
117,838'
375,970
-
25,853
-
83,995/
87,000
- - -
1,832
3 =951
27,197
32,396
6,018
-
4,464
127,817
39,901
'
-
-
$ -
173
$ 21,542
$ 102,314
$ 4,464
$ 498,590
$ 700,491
7,891 - -
91,886
93,933
$ 29,433 $ 102,314 $ 4,464
$ 590,476
$ 794,424` r
$ = $ - $ -
$ 41,841
$ 35,739
- -
14,919
36,730
$
._.2,558.
40,- 543
-
190,532
- -J - --
199,968
- 42 -
42
1,664
- -
-
22,891
29,433 - -
29,433
25,853
-
$
4,094
- - -
1,832
3 =951
$ _29,433(,? $ 42f $
$ 281,157
$ 371,433
-
72,914
-
72,914
342,o4o
$ 29,433
$
72,956
$ -
$
354,071
$
713,473
$
$
29,358
$ 4,464
$
236,405
$
80,951
$ -
$
-
$
$
572,381
-
-
-
-
(423,504)
$
$
13,289
$ -
$
229,828
$
148,877
$ -
$
42,647
$ 4,464
$
466,233
$
2292828
CITY OF COLUMBIA NEIGNTS, MINNESOTA
43
ANNUAL FINANCIAL REPORT
Form C -2
REVENUE SHARING FUND
STATEMENT OF REVENUES, EXPENDITURES AND
CHANGES IN FUND BALANCE
Year Ended December 31, 1982
With Comparative Actual Amounts for Year Ended December 31, 1981
Revenues:
Revenue from other agencies:
Federal Revenue Sharing
Revenue from use of money and property
Interest earnings - Investment
Trust Fund
Other revenue
Total Revenue
Expenditures:
Capital outlay:
Public safety
Parks
Street and engineering
Library
Voss parking lot
Professional services:
Downtown development
Other general government
Total Expenditures
Excess of Revenues over
(under) Expenditures
Fund balance at beginning of year
Fund balance at end of year
[CITY OF COLUMBIA NEICNTS, MINNESOTA
1982
Variance
Favorable 1981
Budget Actual (Unfavorable) Actual
$152,500 $141,743 $ (10,757) $ 160,957
8,500 24,207 15,707
$161,000 1165,950 $ 4,950
$124,760 $ 41,841
39,175 14,919
12,500 2,558.
$ 82,919
24,256
9,942
20,223
173
$ 181,353
$ 35,739
36,730
40,543
22,891
3,900
1,832
2,068
3,951
$180,335
$ 61,150
$ 119,185
$ 139,854
$09,335= e- 04,800 $ 124,135 $ 41,499
195,622 •- 154,123
$(19,335) $300,422 1 124,135 $ 195,622
(Form C)
44
ANNUAL FINANCIAL REPORT
Form C -3
PARK DEDICATION FEES
STATEMENT OF REVENUE, EXPENDITURES AND
CHANGES IN FUND BALANCE
Year Ended December 31, 1982
With Comparative Amounts for Year Ended December 31, 1981
1982
Variance
Favorable
Budget Actual (Unfavorable)
Revenues:
Revenue from other agencies
Park Dedication Fees
Revenue from use of money and property
Interest earnings - Investment
Trust Fund
Total Revenue
Expenditures:
Total Expenditures
Excess of Revenue over
(under) Expenditures
Fund balance at beginning of year
Fund balance at end of year
CITY OF COLUMBIA NEIGNTS, MINNESOTA
$ - $ 80,846 $ 80,846
2,990 2,990
$ - $ 83,836 $ 83,836
1981
Actual
$ - $ 83,836 $___83,836 $ -
(Form C)
45
ANNUAL FINANCIAL REPORT
Form C -4
RECREATION AND COMMUNITY SERVICES FUND
STATEMENT OF REVENUES, EXPENDITURES AND
CHANGES IN FUND BALANCE
Year Ended December 31, 1982
With Comparative Actual Amounts for Year Ended December 31, 1981
Revenues:
Revenue from other agencies:
Independent School District #13
Fees
Total Revenues
Other Financing Sources:
Transfers from other funds
Total Revenues and Other
Sources
Expenditures:
Personal services
Other services and charges
Supplies
Capital outlay
Other expenses:
Playground
Athletic supplies
Beach program
Traveling teams
Miscellaneous
Total Expenditures
Excess of Revenues and Other
over (under) Expenditures
Fund balance at beginning of year
Fund balance at end of year
L CITY OF COLUMBIA NEIGNTS, MINNESOTA
$229,605 $204,479 $ (25,126) $ 209,039
$168,060 $147,536 $ 20,524 $ 153,394
19,145 17,354 1,791 19,424
3,745 3,235 510 9,347
- - - 1,576
3,230
1982
1,067
-
3,050
2,935
Variance
-
6,050
5,813
Favorable
1981
Budget
Actual
(Unfavorable)
Actual
14,765
$ 92,995
$ 83,995
$ (9,000)
$ 87,000
43,615
36,489
(7,126)
35,039
$136,610
$120,484
$ (16,126)
$ 122,039
92,995
83,995
(9,000)
87,000
$229,605 $204,479 $ (25,126) $ 209,039
$168,060 $147,536 $ 20,524 $ 153,394
19,145 17,354 1,791 19,424
3,745 3,235 510 9,347
- - - 1,576
3,230
2,163
1,067
-
3,050
2,935
115
-
6,050
5,813
237
5,686
11,560
11,496
64
10,541
14,765
-
14,765
-
$229,605
" $190,532 $
39,073
$ 199,968
$ -
$ 13,947 $
13,947
$ 9,071
-
20,917
-
11,846
$ -
$ 34,864 $
13,947
$ 20,917
(Form C)
46 ANNUAL FINANCIAL REPORT
■
Form C -5
PARATRANSIT FUND
STATEMENT OF REVENUES, EXPENDITURES AND
CHANGES IN FUND BALANCE
Year Ended December 31, 1982
With Comparative Actual Amounts for Year Ended December 31, 1981
Revenues:
Revenue from other agencies
State grant
Paratransit fares
Total Revenues
Other Financing Sources:
Transfer from General Fund
Total Revenues and
Other Sources
Expenditures:
Personal services
Other services and charges
Total Expenditures
Excess of Revenues and
Other Sources over (under)
Expenditures
Fund balance at beginning of year
Fund balance at end of year
CITY OF COLUMBIA NEIGNTS, MINNESOTA
1982
Variance
Favorable 1981
Budget Actual (Unfavorable) Actual
$ 21,000 $ 15,524 $ (5,476) $ 14,052
5,000 6,018 1,0'18 4,862
$ 26,000 $ 21,542 $ (4,458) $ 18,914
10,500
7,891
.(2,609)
6,933
$ 36,500
$ 29,433 $
(7,067)
$ 25,847
$ 4,500
$ 2,528 $
1,972
$ 4,412
32,000
26,905
5,095
1 21,441
$ 36,500
$ 29,433 $
7,067
$ 25,853
47
6
(Form C)
ANNUAL FINANCIAL REPORT
Form C -6
MUNICIPAL STATE -AID STREET FUND
STATEMENT OF REVENUES, EXPENDITURES AND
CHANGES IN FUND BALANCE
Year Ended December 31, 1982
With Comparative Actual Amounts for Year Ended December 31, 1981
Revenues:
State of Minnesota:
Gasoline tax apportionment -
construction
Interest earnings- Investment
Trust Fund
Total Revenue
Expenditures:
Construction costs
Other Uses:
Transfers
Total Expenditures
and Other Uses
Excess of Revenues over
(under) Expenditures and
Other Uses
Fund balance at beginning of year
before adjusted
Adjustment for restatement
Restated beginning fund balance
Fund balance at end of year
1982
Variance
Favorable 1981
Budget Actual (Unfavorable) Actual
$ 190,000 $102,314 $ (87,686) $ 361,918
12,173
$ 190,000 $102,3'14 $ (87,686) $ 374,091
$ 140 $ 42 $ 98 $ 1,664
336,300 72,914 263,386 342,040
$ 336,440 $ 72,956 $ 263,484 $ 343,704
$(146,440) $ 29,358 $ 175,798 $ 30,387
13,289 - 406,406
- - - (423,504)
- - (17,098)
$ - $ 42,647 $ - $ 13,289
(Form C)
1980 was restated.in 1981 in accordance with N.C.G.A. statement Number 2.
.Previously, revenue was recorded at the time of the apportionment from the
State of Minnesota. Under the restatement, revenue is not recorded until
it is earned.
CITY OF COLUMBIA NEIGNTS, MINNESOTA 48 ANNUAL FINANCIAL REPORT
�I
Form C -7
CABLE TELEVISION FUND
STATEMENT OF REVENUE, EXPENDITURES AND
CHANGES IN FUND BALANCE
Year Ended December 31, 1982
With Comparative Amounts for Year Ended December 31, 1981
1982
Variance
Favor -able 1981
Budget Actual (Unfavorable) Actual
Revenues:
Revenue from other agencies:
Franchise fees $ - $ 4,464 $ 4,464 $ -
Revenue from use of money and property
Interest earnings - Investment
Trust Fund - - - -
Total Revenue $ - $ 4,464 $ 4,464 $ -
Expenditures:
Total Expenditures
Excess of Revenue over
(under) Expenditures - - - -
Fund balance at beginning of year - - - -
Fund balance at end of year $ - $ L,464' $ 4,464 $ -
(Form C)
CITY OF COLUMBIA 1111EIONT3_ NIUMMOTA
49
ANNUAL FINANCIAL REPORT
Form C -8
C.E.T.A. FUND
STATEMENT OF REVENUES, EXPENDITURES AND
CHANGES IN FUND BALANCE
Year Ended December 31, 1982
With Comparative Actual Amounts for Year Ended December 31, 1981
1982 1981
Revenues:
Federal grant $ - $ 4,094
Expenditures:
Personal services - 4,094
Other services and charges - -
Total Expenditures $ - $ 4,094
Excess of Revenues over
(under) Expenditures $ - $ -
Fund balance at beginning of year - -
Fund balance at end of year $ - $ -
[CITY OF COLUMBIA NEIGNTS, MINNESOTA
50
ANNUAL FINANCIAL REPORT
HE CITX OF COLUM IA HEIGHTS, MINNESOTA
NNUA TINANCIAL KEPQRT
EAR LNDED DECEMBER S1, 1982
DEBT SERVICE F1110S
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.
TABLE OF CONTENTS
Page
Combining Balance Sheet Form D 51`52
Combining Statement of Revenues, Expenditures
and Changes in Fund Balances Form D -1 53 -54
ASSETS
Cash:
DEBT SERVICE FUNDS
COMBINING BALANCE SHEET
December 31, 1982
With Comparative Totals for December 31, 1981
Storm Sewer City Garage
Bond of Bonds of
1965 1972
Cap tal
Improvements
Bonds of
1976
Treasurer's balance
$
77
$
89
$
60
Deposited with paying agent
112,110
61,290
-
Investments, at cost
164,900
9,500
158,600
Taxes receivable - delinquent
(944)
40
(1,390)
Less: Allowance for uncollectible taxes
944
(40)
1,390
Due from other governmental units
Due from other funds
15,400
-
-
Total Assets
$
292,487
$
70,879
$
158,660
Liability:
Matured bonds and interest payable
$
112,110
$
61,290
$
-
Fund Balance- reserved for debt service
- -Form D -1
180,377
9,589
158,660
Total Liabilities and Fund Balance
$
292,487
$
70,879
$
158,660
CITY OF COLUMBIA NEI6NTS, MINNESOTA
51
ANNUAL FINANCIAL REPORT
Tax Increment Tax Increment
Bonds of Bonds of
1980 1982
$ 17 $ 50
9,255 -
307,400 -
$ 316,672 $ 50
$ 9,255 $ -
307,417 50
$ 3161672 $ 50
Totals
1982 1981
$ 293
182,655
640,400
(2,294)
2,294
15,400
$ 838,748
$ 182,655
656,093
$ 838,748
Form D
$ 11,154
166,695
885,000
303
(303)
2,895
29,700
$ 1,095,444
$ 166,695
928,749
$ 1,095,444
CITY OF COLUMBIA NEIGNTS, MINNESOTA 52 ANNUAL FINANCIAL REPORT
DEBT SERVICE FUNDS
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND
CHANGES IN FUND BALANCES
Year Ended December 31, 1932
With Comparative Totals for Year Ended December 31, 1981
CITY OF COLUMBIA NEIGNTS, MINNESOTA
53
ANNUAL FINANCIAL REPORT
Storm Sewer
City Garage
-
Bonds of
Bonds
1965
1972
Revenues:
General property taxes:
Collected by county
Current ad valorem
$
67,033
$
-
Delinquent ad valorem
1,644
-
Revenue from other sources:
Property tax relief (Homestead)
28,251
-
Sale of land
-
-
Miscellaneous
-
-
Interest earnings:
Investment Trust Fund
15,749
6,562
Inter -fund loans
1,485
-
Total Revenues
$
114,162
$
6,562
Other Financing Sources:
Bond proceeds
Transfers from:
Water Utility Fund
-
-
Sewer Utility Fund
15,000
-
Total Revenues and Other Sources
$
129,162
$
6,562
Expenditures:
Bonds matured
$
105,000
$
60,000
Interest on bonds
13,500
2,58o
Fiscal agent charges
78
98
Total Expenditures
$
118,578
$
62,678
Excess of Revenues and Other Sources
over (under) Expenditures and Other Uses
$
10,584
$
(56,116)
Fund balance at beginning of year
169,793
65,705
Fund balance at end of year
$
180,377
$
91539
CITY OF COLUMBIA NEIGNTS, MINNESOTA
53
ANNUAL FINANCIAL REPORT
Form D -1
Capital
Improvement Tax Increment Tax Increment
Bonds of Bonds of Bonds of Totals
1976 1980 1982 1982 1981
$ 80,455
1,973
33,861
17,062
$ 133,351
$ 133,351
$ 175,000
13,078
104
$ 188,182
$ (54.,831)
213,491
$ 158,660
$ 56,844
409,110
35,144
$ 501,098
$ 501,098
672,950
491
$ 673,441
$ (172,343)
479,760
$ 307,417
CITY OF COLUMBIA HEIGHTS, MINNESOTA
50
$ 50
$ 204,332
3,6171,
62,112
409,110
50
74,517
1,485
$ 755,223
15,000
$ 50 $ 770,223
$ $ 340,000
702,108
7.71
$ - $ 1,042,879
$ 50 $ (272,656)
928,749
$ 50 $ 656,093
54
$ 271,717
5,020
79,910
429,731
80,147
1 ,851
�rs�z::
10,000
25,000
$ 903,376
$ 320,000
688,887
763
$ 1,009,650
$ (106,274)
1,035,023
t nn4 -,I.n
ANNUAL FINANCIAL REPORT
HE CITX OF COLUM IA HEIGHTS, MINNESOTA
NNUAjJ� TINANCIAL KEPQRT
EAR LNDED DECEMBER S1, 1982
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.
TABLE OF CONTENTS
Combining Balance Sheet
Combining Statement of Revenues, Expenditures
and Changes in Fund Balances
i
i
Page
Form E 55 -56
Form E -1 57 -58
CAPITAL PROJECTS FUNDS
COMBINING BALANCE SHEET
December 31, 1982
With Comparative Totals for December 31, 1981
ASSETS
Cash:
Treasurer's balance
Investments at cost
Accounts Receivable:
Accrued interest
Due from other government units
Total Assets
LIABILITIES AND FUND BALANCE
Liabilities:
Accounts payable
Contracts payable
Total Liabilities
Fund balance:
Reserved for encumbrances
Unreserved
Designated for subsequent year's expenditures
Undesignated
Total Fund Balance
Total Liabilities and Fund Balance
CITY OF COLUMBIA NEIGNTS, MINNESOTA
55
Capital
Improvment
Fund 308
$ 2
64,200
$ 64,202
64,202
$ 64,202
Ah qnq
ANNUAL FINANCIAL REPORT
Sullivan
La ke
Fund 807
$ 97
24,600
$ 24,697
S -
24,697
$ 24,697
$ 24,697
Form E
Downtown Land
Acquisition Totals
Fund 312 1982 1981
$ 13
$
112
$
23,724
1,777,702
1,866,502
1,532,077
13,388
13,388
17,488
-
-
97,585
$.1,791,103
$
1,880,002
$
1,670,874
$ 2,595
$
2,595
$
-
-
-
46,698
$ 2,595
$
2,595
$
46,698
1,788,508
$ 1,788,508
$ 1,791,103
$ - $ 31,644
1',788,508 1,534,637
88,899 57,895
$ 1,877,407 $ 1,624,176
$ 1,880,002 $ 1,670,874
CITY OF COLUMBIA NEIGNTS, MINNESOTA 56 ANNUAL FINANCIAL REPORT
CAPITAL PROJECTS FUNDS
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND
CHANGES IN FUND BALANCES
Year Ended December 31, 1982
With Comparative Totals for year ended December 31, 1981
Rev. >,,!?es :
Interest earnings - Investment Trust Fund
State Grant
Other Revenue
Total Revenues
Other Financing Sources:
Bond proceeds
Transfers from - Capital Improvements Fund
Total Revenues and Other Sources
Expenditures:
Construction contracts
Other project expenditures
Total Expenditures
Other Financial Uses:
Transfers to other funds
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
Capital
Improvement
Fund 308
$ 6,307
$ 6,307
$ 6,307
$ 6,307
57,895
$ 64,202
CITY OF COLUMBIA NEIGNTS, MINNESOTA 5 7 ANNUAL FINANCIAL REPORT
..
Form E -1
0 CITY OF COLUMBIA NEIGNTS, MINNESOTA
58
ANNUAL FINANCIAL REPORT
Sullivan
Downtown Land
Lake
Acquisition
Totals
Fund 807
Fund 312
1982
1981
$
6,489
$
195,827
$
208,623
$ 675,975
25,103
-
25,103
150,488
-
-
-
275
$
31,592
$
195,827
$
233,726
$ 826,738
-
445,612
445,612
-
$
31,592
S
641,439
$
679,338
$ 826,738
I
$
26,711
$
-
$
26,711
$. 284,229
-
362,990
362,990
5,226,903
$
26,711
$
362,990
$
389,701
$5,511,132
36,406
-
36,406
270,890
$
63,117
$
362,990
$
426,107
$5,782,022.
$
(31,525)
$
278,449
$
253,231
$(4,955,284)
56,222
1,510,059
1,624,176
6,579,460
$
24,697
$
1,788,508
$1,877.,407
$ 1,624,176
0 CITY OF COLUMBIA NEIGNTS, MINNESOTA
58
ANNUAL FINANCIAL REPORT
1
1
HE CIT� OF COLUM$IA HEIGHTS, MINNESOTA
NNUA INAVj CIAL REPQQRT
.EAR LNDED DECEMBER S1, 1982
SPECIA ISSESSMENT FONDS
The Permanent Improvement Revolving Fund is used to advance to
local improvement funds.the cost of improvements for which
assessments are to be levied.
Special Assessment Bonds are established according to Chapter 8
of the home rule charter and Minnesota Statutes, Chapter 429.
They are used to record the proceeds of bonds used to construct
public improvements which, in turn, are fully or partially assessed
against individual benefited properties.
TABLE OF CONTENTS
Combining Balance Sheet
Combining Statement of Revenues, Expenditures
and Changes in Fund Balances
It
Page
Form F 59
Form F -1 60
Form F
SPECIAL ASSESSMENT FUNDS
COMBINING BALANCE SHEET
December 31, 1982
With Comparative Totals four December 31, 1981
Permanent Permanent
Improvement Improvement
Revolving Revolving Totals
Fund Bond Fund 1982 1981
ASSETS
Cash:
Treasures's balance (deficit)
Deposited with paying agent
Investments, at cost
Accounts receivable
Taxes receivable deferred
Special assessments receivable:
Delinquent
Deferred
Due from State Aid Fund
Total Assets
LIABILITIES AND FUND BALANCE
Liabilities:
Accounts payable
Accrued payroll
Interest payable
Contracts payable
Deposits
Bonds payable
Matured bonds and interest payable
Due to General Fund
Deferred revenue
Total Liabilities
Fund Balance:
Reserved for encumbrances
Unreserved- Undesignated
Total Fund Balance
Total Liabilities and Fund
Balance
CITY OF COLUMBIA NEIGNTS, MINNESOTA
$ 8 $ 43
5,108
1,562,724 5,900
29,418 -
137,120 -
1,335,493 -
103,368 -
$3,168,131 $ 11,051
$ 14,746 $ -
464 -
15,315 -
8,511 -
- 2,550,000
5,108
287,504 -
$ 326,540 $2,555,108
2,841,591 (2,544,057)
$2,841,591 $(2,544,057)
$3,168,131 $ 11,051
59
$ 51
$ 7,311
5,108
51,158
1,568,624
-
29,418
16,499
-
5,500
137,120
111,314
1,335,493
509,998
103,368
30,454
$3,179,182 $ 7;x2,234
$ 14,746
$ 967
464
683
-
215
15,315
64,925
8,511
- 8,511
2,550,000
5,000
5,108
51,158
-
595,000
287,504
-
$2,881,648 $ 726,459
$ - $ 44,874
297,534 (39,099)
$ 297,534 $ 5,775
$3,179,182 $ 732,234
ANNUAL FINANCIAL REPORT
Form F -1
SPECIAL ASSESSMENT FUNDS
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND
CHANGES IN FUND BALANCES
Year Ended December 31, 1982
With Comparative Totals for Year Ended December 31, 1981
Permanent Permanent
Improvement Improvement
Revolving Revolving
Fund Bond Fund
' Revenues: -
Increase in assessments $ 965,044 $
Interest and penalties on special
assessments
' Interest earnings
Administration charges to projects
Miscellaneous
Total Revenues
62,290 -
26,143 547
74,976 -
23,857 -
$1,152,310 $ 547
Other Financing Sources:
Transfers from:
Permanent Improvement Revolving
Fund 2,525,138 5,170
Sewer Utility Fund 37,094 -
State Aid Fund 72,914 -
General Fund - -
Tota 1 s
1982 1981
$ 965,044 $ 194,654
62,290 55,068
26,690 -
74,976 54,716
23,857 21,888
$1,152,857 $ 326,326
2,530,308 5,100
37,094 5,114
72,914 342,040
- 65,335
Total Revenues and other
Sources $3,787,456 $ 5,717 $3,793,173 $ 743,915
Expenditures:
Capital project expenditures:
Construction contracts $ 613,048 $ -
Other project costs 214,218
Administration costs 113,461
Bond discount - 24,862
Fiscal agent charges - 17
' Total Expenditures $ 940,727 $ 24,879
1 Other Financing Uses:
Transfer to Permanent Improvement
Revolving Bond Fund 5,170 -
' Deferred tax levies (1981) cancelled _ 5,500'
Adjust assessments 2,525,138
Total Expenditures and Other
Uses $ 945,897 $2,555,517
Excess of Revenues and Other
Sources over (under) Expenditures
;CITYand Other Uses $2,841,559 $(2,549,800)
Fund balance at beginning of •year 32 5,743
Fund balance at end of year - -Form F $2.841,591 $(2,544,OS7)
Of COLUMBIA NEIGNTS, MINNESOTA
An
$ 613,048 $ 740,273
214,218 198,418
113,461 73,792
24,862 -
17 86
$ 965,606 $1,012,569
5,170 5,100
5,500 55,000
2,525,138 -
$3,501,414 $1,072,669
$ 291,759 $ (328,754)
5,775 334,529
S 297,534 S 5,,,7ZG
AL FINANCT REPORT
1
HE CITX OF COLUM IA HEIGHTS, MINNESOTA
NNUA tINABCIAL KEPQRT
EAR kNDED 1lECEMBER 51, 1982
ENTERPRISE FUNDS
The Authority for these types of funds is derived from Section 69
(b) of the City Charter which allows for utility or other public
service enterprise funds. Enterprise fund operations are financed
solely by user charges.
Combining Balance Sheet
Combining Statement of Revenues, Expenses, and
Changes in Retained Earnings
Combining Statement of Changes in Financial
Position
Municipal Liquor Fund:
Balance Sheet
Statement of Revenues, Expenses and Changes
in Retained Earnings
Statement of Changes in Financial Position
Schedule of Revenues - Off Sale
Schedule of Operating Expenses
Schedule of Property, Equipment and Accumulated
Depreciation
Water Utility Fund:
Balance Sheet
Statement of Changes in Fund Equity
Statement of Revenues and Expenses
Statement of Changes in Financial Position
Schedule of Property, Equipment and Accumulated
Depreciation
Sewer Utility Fund:
Balance Sheet
Statement of Changes in Fund Equity
Statement of Revenues and Expenses
Statement of Changes in Financial Position
Schedule of Property, Equipment and Accumulated
Depreciation
Fo rm G
Form G -1
Form G -2
Pace
61 -62
63 -64
65 -66
Form H 67
Form
H -1
68 -69
Form
H -2
70
Form
H -3
71-72
Form
H -4
73-74.
Form H -5 75-76
Form I
Form 1 -1
Form 1 -2
Form 1 -3
Form 1 -4
Form J
Form J -1
Form J -2
Form J -3
Form J -4
77
78
79
80
81 -82
83
84
85
86
::
IN
C7
E
L
0
LL-
T
rD
O
H
M
O O
01 O -4'
011
N
00 00
\D
-:I* LA M N I�
r"
01
00
%D
011 N
\D Lr1
O - Ol
o0
•- 1�
N -
-:r
M L11 O 1�l N
01
N
\.O
N
^ M N .-
O -Z
01 1-
%.0
\D
-
Ol
01 Lr\ 0 00 -
-T
n
n
O
O 00
Lr\ Ol
^
M
Lr1 m
-?
w
-:r
-0 00
U1 L11
1- co N -1,
-T
-0 011
011 00
\D U'\ -
1 00
O
- N
M
00 Lr1 O 01
N
LA
00
M
E
-'r
-N
O
N
M01
N
0000
N N
O
O
ur
0
�
- N
O
Ol
N
M
M Lr> M
N
r
i- O 4-J
M
U
^
•
fp L 4-
N
N
N
N
U) U IV
L11
(u
M
LJ1
CL
w m •-
en
U �+
U1
N
M
111
O
N
¢
L
J rp
O n
¢ a
c
m E
L)-
LT
to
c 0
- Li
L7 U
m cu c
J
Z
- L
- G -
M
�O �O
O 011 01 M)
w
r-
00
-:3- Lr1 1- N 00
%0
01
Il_
01
011 N
00 -41 00 N M
01
M -:r
•- 1�
M L11 N I�l M
N
01
O
Z
L
.- LV
^ M N .-
O
Lr1 01
LL
01 Lr1 Lr1 00 O
011
Ol
O
Ln
N N
00
=)
N L
Lr\ Ol
N
M
Lr1 m
-?
w
-:r
-0 00
U1 L11
1- co N -1,
-T
M ^
M -T
00 Lr1 Ln .:'
_:r
--O
00
M
E M
N
00 - M N
N
N CO
w m
000- N
M
O
N
\.O
O •-
\10
N N
M
N
M
M Lr1 M
N
N
O
�O
U
^
L fo
C
i- O 4-J
w
w -0 O
•
fp L 4-
N
N
N
N
U) U IV
L11
N
M
LJ1
CL
w m •-
en
U �+
m
L
E m O•- U 0 0
IT
N
¢
L
J rp
O n
¢ a
c
m E
O O 4- Q O N O
LT
N
%O
w
c �
M M
G.
%0
%D O --r 011 00 01
n
H 00
M lO
m
Q1
•- 1�
>�
\0 00 O
01
L y.1
Z
-:r
O •- -0
O ^
\,O Lr1
3: - C
LL
M -:r
O •- m
000-
00
01
w
00
=)
N L
Lr\ Ol
N
M
Lr1 m
-?
w
-:r
^
C E
Lr\
M
m O
M -T
1 N 1
w V
01 •-
Lr1 O
F- N N
I m
M
Z 00 a
O
�
w m
V)
T
O
•L
•-
J O
1�
N •- 'o
N
?
a —
L
m m
M Ln
N 3 -W LL
1
4-J
M
L fo
C
i- O 4-J
w
w -0 O
•
fp L 4-
w E F-
N
Ln 1n O to -0 yd O
N
U) U IV
N
N.>
N
c i C C •- r0 >
w m •-
en
U �+
m
L
E m O•- U 0 0
IT
Q
¢
L
J rp
O n
¢ a
c
m E
O O 4- Q O N O
LT
O
c 0
- Li
L7 U
m cu c
J
Z
- L
- G -
Z +•+
L
s Q)
000 M M •-
%O
O N
c �
M M
O
%0
%D O --r 011 00 01
n
1� \.D
M lO
m
M
•- 1�
00
\0 00 O
01
M
m
-:r
M
M N
\,O Lr1
N
c .> N U
M -:r
1-
000-
00
01
O
00
n
L11
Lr\ Ol
N
M
Lr1 m
-?
Lr\ M ?
-:r
^
N
Lr\
M
-zr
M -T
1 N 1
LA
01 •-
Lr1 O
M
I m
M
lO
r�
�
O
-Zr N
M
O
N 00
•-
M N M
1�
^
N
?
\O
N
-
N
\D
N
M
M
to C 0 v U to L N
Lm
>
M
m a
•
fp L 4-
•m
N
Ln 1n O to -0 yd O
N
+-1
N
N
c i C C •- r0 >
4-J -
en
N m m- •- E L
m
E m O•- U 0 0
IT
¢
J d > L' U N L 4-1
U
v+ •- O u c 0.4- c
L
4J L
O O 4- Q O N O
000 M M •-
%O
O N
M 1� N
M M
O
%0
%D O --r 011 00 01
n
N 00 Lr\ O
%D N
-zr
M
O -Zl- t\ M
00
N -0 > > to
N 01-T %D
N
N
O
Lr\ 1- O
M
c .> N U
n O 011 N
O
�O
O
M M M .- M
?
I I
I
UN O N
M %D
\.O
�O
Lr\ -:3' N
N
a
- "D
M
M
M
N r- •-
Lr1 O
Ln
00
N
M 4- .- m -W O N •_
N
N
O 01.0 .> c E >
N
w
U m •= 7 0 O a
E
N
ih
O --T N
n
O N
Lr\ Cl LA N CO
I Cl 1l_
M
O
I
vri l
T
n 00
00
M
O 1-. 01
Ol
N -0 > > to
N %D 00 m
00 LJ1
N
U M •- O
Lr\ 1- O
M
c .> N U
n O 011 N
O
�O
O
\D I I I N
01
I I
I
^ .- M
M %D
\.O
�O
N
M
a
•N
E
m
m 3
q/
O N
I
I
vri l
U
Ln t0 C
N -0 > > to
U M •- O
c .> N U
m -- u r0
•u
O i
1p
a
•N
E
+.1 O _D to c L-O
N
M 4- .- m -W O N •_
F-
O 01.0 .> c E >
w
U m •= 7 0 O a
E
N
4-1 +-1 0 0 0 rn a
ro
Ln
4.1 O u U u 0 m
Q
a
to C 0 v U to L N
>
m a
•
fp L 4-
•m
N
Ln 1n O to -0 yd O
-
•O
+-1
+-1 N U 4-J N •- O
N
c i C C •- r0 >
4-J -
en
N m m- •- E L
m
E m O•- U 0 0
IT
¢
J d > L' U N L 4-1
U
v+ •- O u c 0.4- c
L
4J L
O O 4- Q O N O
W
c 0
> U O >
m cu c
O l0
c 0 m C
L U
- G -
L
s Q)
a�
v
¢
a�
U
CITY OF COLUMBIA
NEIGNTS,
MINNESOTA
61 1 ANNUAL FINANCIAL REPORT
q/
I
I
vri l
•N
a k
a)
++
E
ro
•- E
�o
a
>
m a
•U
•m
to
-
•O
-0 •-
4-J -
m
(u
IT
O
L ,
U
c Q -W
L
w
W
cu
m cu c
a
ul
s Q)
a�
v
¢
a�
-E
v
c
+�
.- �
ci
C
L tp •-
�
C
U1 /o
L
O
N m
O
>•
Vf
O
O rp >
L
E
t N cr
4J
4-J
41
L
> •-
c>
a
4-J L Ill
m
L
a�
L
•- c)
4-
-
•m
O m
N
to •+
m
m N U
N
4-J •0
7
a
to
U
> u 0)
o
U
to •- C
E
O
Q
— (y L
-O
w
.61 C m
m
L
L
C L
U
0-
rp
U Ln
to
'G
0
O 7 >-
rp
U
10
41
N to 4-J
4-J
c
O
E 4- L
+-1
Q
4-1
4-1
O
U
O
m
C
N O
O
N
O
F-
c to
H
•-
> 4) c
F-
z
w-
v m L
>
v
o U •-
N O 4-1
4J
'0
L ._ L
0
L U c
L
C •-
a 4- U
to
L u 0
O
m =,E
4- ro
N
4-
0
N
L
gm
d
61 1 ANNUAL FINANCIAL REPORT
U
E
L
0
LL
a)
7
C
c
0
u
N
w
CL
r
F-
G
Z
LL
w N
Ln 00
CL
W
w .-
�- M
z
w L
Q)
J
J E
Q a)
u
I Q)
G
F-
w
w
S
N
w
U
Z
Q
J
Q
m
(.7
Z
_
M
-
Z
L
M N
01%0
_:r
00 O
00
N N
?
%D
a)
01 O
LfN O
ul%
r- C)
%001%
L1\
N
m
-000
L11 %0
O M
Lr%
Lr%?
Ol
%.000
Ln
O
EM
^ ^
1 ^ ^
^ ^
^
^
O
0) .-
IO -
- .?
M
N LA
r
00 N
M
U
u
00
�
N
Ol
O
Lt1 %D
N
Lr%
a)
++ (t1
•-
N
N
M
t\ O
00
M
D
C 41
-
Ln
a) •- C
m
4-
M
N
LA
(p
D
t/}
i
a)
41
a)
N•
Z
U-0 E
-
O
F-
u-
a) L (0 L w
4-.1
Ln
J
cr
•-
^
01_
N O
N
N
O t"
1�
01
M
U1 a) 4 LA Vf i C
O
C
L
0)
•-
Z
a) •- a) -0 O 7
01 -*'
01
Q)
Ol
Ll�
�D
Lf1
L
^
I
W •- 4-
I I
•C
O N
(\
7
00
+•1
00
%D 00
�
M
-
-0 00
•— .0 E .0 L L
U-% .-
Ul
O
Lr%
^ 00
O
�D
E 0')
(0 (t) O a) Q)
41 L a)
r-
N N
Lf\
%D
a)
— D_•— L -o t L
•— u .t
— W
—
•�
U
-0 � 4 N 4-1 4J
(0
� i.1
N
•• �.+
N M
U1
L(1
a)
C
VT
V?
Oy
O
O
H
O
N
M
M
m
7 D (t1 4J 4
- a) }+
-T
N
M
n
L ++
Ln I-
00
N
N
? t\
M
a) •- -0
^ ^
1 ^ I
4- a)
I 1
w C +J
'
3 C
?
01
01
m
%D 00
Ln
d
•—
LQQCL C)0
-zr
L11
U\
0') o
O
%D
N 4-.1 LL.
L
L
C
O N
M
M
3
+•1
7
U
O
LL
N
N
O
n -T
p
-
•-
00
VI
>.
1\ O
p
00
00
-T 00
M
•_
L 4-1
00 00
-T
O
O
n •--
01
O
L
a) •- -0
t
I 1
cl
++ C
• - N
O
O
al al
00
01
L
t0 •- 7
n
M
Q)
3 ++ w
^
00
4
^
c
•-
w
t/}
N•
M %D
N
m
01
O
U'1
0p
00
O
O
Ol
CO
O
LrN
Lr%
%D
%D
^
t 1
1 1
I
O M
Lr
01
cl
O
O
O
L
M
M
M
N
N
%0
0 -0
7 c
D' 7
._ LL.
Z
_
-
Z
Ln +r
Ln
C
4� 4-J • -
a)
7
m
?
() 0 C
-
•4-1
Ln
LL.
to a) 7
O
Ln L
•-
-
+•'
U
O
ID Q) -
�
+•�
-
•u
C
01
++ (t1
•-
(I)
w
C 41
-
a) •- C
m
4-
�^
N
D
4-1 a)
i
a)
41
a)
Z
U-0 E
-
u-
a) L (0 L w
4-.1
Ln
J
cr
•-
- •4) a) 'D
C
-0
Ln
w
C
U1 a) 4 LA Vf i C
O
C
L
0)
•-
Z
a) •- a) -0 O 7
L
•• +J 7
Q)
c
G
a
Q
- - L C 0) 4-
L
W •- 4-
-c
•C
++ O •- O
7
() 'O
+•1
W
7
-
N
•— .0 E .0 L L
U
— a) L-
O
C L
LL-
J>.
w
(0 (t) O a) Q)
41 L a)
O m
+�
— D_•— L -o t L
•— u .t
— W
—
•�
E-
-0 � 4 N 4-1 4J
(0
� i.1
N
•• �.+
(0
(0
J C O O
F-
It) L O
H
— C
•7 •L
F-
F-
m
7 D (t1 4J 4
- a) }+
•-
Q
0 L m i
J 4-
tS aJ (0
C u u>� a) a)
4- a)
w C +J
'
J
0 u u (0 :3 7
L 0) D
O a)
LQQCL C)0
a)cc
•DUG.'
,
L
L
C
3
+•1
7
U
O
LL
CITY OF COLUMBIA NEIGNTS, MINNESOTA 62 ANNUAL FINANCIAL REPORT
COMBINING STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN
RETAINED EARNINGS - ALL ENTERPRISE FUND TYPES
Year Ended December 31, 1982
With Comparative Totals for Year Ended December 31, 1981
CITY OF COLUMBIA NEIGNTS, MINNESOTA 63 ANNUAL FINANCIAL REPORT
Liquor
OPERATING REVENUES:
Sales
$ 966,970
Cost of sales
781,624
Gross Profit
$ 185,346
OPERATING EXPENSES:
Personal services
112,817
Other services and charges
36,576
Supplies
4,530
Source of supply /disposal charges
-
Total
1539923
OPERATING INCOME BEFORE DEPRECIATION
31,423
DEPRECIATION
4,116
OPERATING INCOME (LOSS)
27,307
,ION- OPERATING REVENUES (EXPENSES):
Interest income
125,957
Interest expense
-
Other income (expense) - net
(16,269)
Total
109,688
Net Income
136,995
Transfers to other funds
-
Transfer depreciation on contributed assets
-
Extraordinary income
-
RETAINED EARNINGS
AT BEGINNING OF YEAR
1,283,614
RETAINED EARNINGS
AT END OF YEAR
S 1.420.609
CITY OF COLUMBIA NEIGNTS, MINNESOTA 63 ANNUAL FINANCIAL REPORT
6,817
39,361
172,135
Totals
Water
Sewer
1982
19 1
$ 711,433
$ 749,512
$ 2,427,915
$ 2,647,507
-
-
781,624
852,135
$ 711,433
$ 749,512
$ 1,646,291
$ 1,795,372
127,711
127,244
367,772
508,905
49,872
49,228
135,676
172,360
20,120
21,821
46,471
49,323
476,751
222,824
699,575
818,179
674,454/
421,117 ✓
1,249,494
1,548,767
36,979
328,395
396,797
246,605
41,772 ✓
55,301 ✓
101,188
108,249
(4,793)
273,094
295,608
138,356
6,817
39,361
172,135
93,977
(1,485)
-
(1,485)
(1,851)
1,325
(8,615)
(23,559)
594,406
6,657
30,746
147,091
686,532
1,864
303,840
442,699
824,888
-
(52,094)
(52,094)
(61,000)
26,294
38,935
65,229
-
-
292,518
292,518
-
631,029
625,512
2,540,155
299,004
S 659,187
$1,208,711
$ 3,288,507
$ 19-062,892
CITY OF COLUMBIA NEIGNTS, MINNESOTA
Form G -1
64 ANNUAL FINANCIAL REPORT`
COMBINING STATEMENT OF CHANGES IN FINANCIAL POSITION
ALL ENTERPRISE FUND TYPES
Year Ended December 31, 1982
With Comparative Totals for Year Ended December
31, 1981
Liquor
SOURCES OF WORKING CAPITAL:
Operations:
Net income
$
136,995
Items not requiring (providing) working capital
Depreciation
4,116
Gain on disposal fixed assets
-
Proceeds from sale of equipment
-
Working Capital Provided by Operations
$
141,111
Extraordinary income
-
Decrease in long term contract receivable
-
Increase in deferred credit - revaluation MWCC
-
Decrease in deferred receivable-reserve capacity
-
Total Sources of Working Capital
$
141,111
USES OF WORKING CAPITAL:
Additions to property and equipment -net
$
950
Peduction of due to other funds
-
_... deferred credit - revaluation gain
-
Increase long -term contract receivable MWCC
-
Transfers to other funds
-
Total Uses of Working Capital
$
950
INCREASE (DECREASE) IN WORKING CAPITAL
$
140,161
ELEMENTS OF NET INCREASE (DECREASE)AN WORKING CAPITAL
Cash $ (309)
Investments 127,700
Accounts receivable 174
Inventory 5,444
Accounts payable 12,746
Due to other funds -
Due from /to Metro Waste Control Commission -
Accrued liabilities (5,594)
Net Increase (Decrease) in Working Capital $ 140,161
CITY OF COLUMBIA NEIGNTS, MINNESOTA
65
ANNUAL FINANCIAL REPORT
'
Form G -2
'
Totals
Water
Sewer
1982
1981
$
1,864
$
251,746
$
390,605
$
789,888
'
41,772
55,301
101,189
108,249
-
-
-
(576,975)
'
-
-
-
651,611
$
43,636
$
307,047
$
491,794
$
972,773
_
292,518
292,518
-
'
10,571
10,571
10,165
-
1,597
1,597
1,502
$
43,636
$
611,733
$
796,480
$
984,440
'
$
2,537
$
16,942
$
20,429
$
21,621
15,400
-
15,400
14,300
292,518
292,518
10,165
-
-
-
26,000
'
$
17,937
$
309,460
$
328,347
$
72,086
$
25,699
$
302,273
$
468,133
$
912,354
$
(822)
$
(?,733)
$
(3,864)
$
(7,111)
'
96,000
(46,924)
176,776
999,000
(64,177)
289,128
.225,125
39,620
5,444
(5,544)
(6,923)
62,802
68,625
(120,782)
'
(11100)
(11100)
(2,750)
-
-
-
7,604
2,721
-
(2,873)
2,317
'
$
25,699
$
302,273
$
468,133
$
912,354
a
CITY OF COLUMBIA NEIGNTS, MINNESOTA 66 ANNUAL FINANCIAL REPORT
MUNICIPAL LIQUOR FUND
COMPARATIVE BALANCE SHEET
December 31, 1982 and 1981
ASSETS
Current Assets:
Cash:
Treasurer's balance
Imprest cash and change funds
Total Cash
Investments, at cost
Accounts receivable
Merchandise inventory, at cost
Total Current Assets
Property and Equipment:
Land
Buildings
Improvements other than buildings
Office furnitu.re and equipment
Store equipment
Total
Less: Accumulated, depreciation
Net Property and Equipment -- Form H -5
Total Assets
LIABILITIES AND RETAINED EARNINGS
Current Liabilities:
Form H
1982 . 1981
$ 91
$ 300
5,000
5,100
$ 5,091
$ 5,400
1,267,700
1 ,1110,000
174
-
120,942
115,498
$1,393,907 $1,260,898
$ 7,125
$ 7,125
70,260
70,260
19,665
19,665
872
872
32,948
31,998
$ 130,870 $ 129,920
64,587 60,471
$ 66,283 $ 69,449
$1,460,190 $1,330,347
Accounts payable $ 30,713 $ 43,459
Accrued salaries payable 3,434 3,073
Accrued social /security /P.E.R.A. payable 382 201
Due to other governmental units 5,052 -
Total Current Liabilities $ 39,581 $ 46,733
Retained Earnings -- Unreserved Form H -1 $1,420,609 $1,283,614
Total Liabilities and Retained Earnings $1,460,190 $1,330,347
CITY OF COLUMBIA NEIGNTS, MINNESOTA
67
ANNUAL FINANCIAL REPORT
MUNICIPAL LIQUOR FUND
COMPARATIVE STATEMENT OF REVENUES, EXPENSES,
AND CHANGES IN RETAINED EARNINGS
COMBINED ON -SALE AND OFF -SALE
Years Ended December 31, 1982 and 1981
Sales
Cost of Sales:
Inventory, Beginning
Purchases
f-al Merchandise Available
Sale
Totals All Stores
1982 1981
$ 966,970 $ 1,205,801
$ 115,498 $ 122,366
787,068 845,267
On -Sale Store
1982 1981
$ - $ 232,943
$ - $ 12,128
- 63,441
$ 902,566 $ 967,633 $ - $ 75,569
Less: Inventory, Ending
6,254
1,791
120,942
115,418
Cost of Sales
-
$
781,624 -�'$
852,135
Gross Profit on Sales
$
185,346 $
353,666
Percentage of Gross Profit
to Sales
19.17%
29.33%
Less: Operating Expense --
Form H -4
$
153,923 $
325,111
Operating Income before
Depreciation
$
31,473 $
28,555
Less: Depreciation - Form-H-5
4,116-'
7,714
Operating Income
$
27,307 $
20,841
Nonoperating Revenues (Expenses):
Interest earnings - Trust Fund
Machine commissions
Other income
Cash short
Gain /Loss on disposal of assets
Other expense
Total
Net Income
$ 125,957 $ 72,322
939
6,254
1,791
-
(405)
(1,923)
-
576,975
(18,594)
(716)
$ 109,688 $ 652,912
$ 136,995 $ 673,753
Retained Earnings at beginning of year $1,283,614 $ 609,861
Retained Earnings at end of year $1,420,609 $ 1,283,614
$ - $ 75,569
$ - $ 157,374
- 67.56%
$ - $ 177,104
$ - $ (19,730)
3,978
$ - $ (23,708)
$ - $ 67,006
5,223
(541)
576,975
(710)
$ - $ 647,953
$ - $ 624,245
CITY OF COLUMBIA NEIGNTS, MINNESOTA 68 ANNUAL FINANCIAL REPORT
n
n
11
Form H -1
Off -Sale Stores
Totals
$
NO. 2
$
NO. 3.
1982
1981
1982
1981
1982 1281
$. 966,970 $
972,858
$ 429,003 $
441,978
$ 537,967 $ 530,880
$ 115,498 $
110,238
$ 53,502 $
47,736
$ 61,996 $ 62,502
787,068
781,826
344,647
362,582
442,421 419,244
$ 902,566
$
892,064
$
398,149
$
410,318
$
504,417
$
481,746
120,942
115,498
50,262
53,502
70,680
61,996
$ 781,624
$
776,566
$
347,887
$
356,816
$
433,737
$
419,750
$ 185,346
$
196,292
$
81,116
$
85,162 -
$
104,230
$
111,130
19.17%
20.18%
18.91%
19.27%
19.37%
20.93%
$ 153,923
$
148,007
$
72,262
$
71,440
$
81,661
$
76,567
$ 31,473
$
48,285
$
8,854
$
13,722
$
22,569
$
34,563
4,116
3,736
1,572
1,405
2,544
2,331
$ 27,307
$
44,549
$
7,282
$
12,317
$
20,025
$
32,232
$ 125,957
$
5,316
$
55,880
$
1,418
$
70,077
$
3,898
939.
1,031
439
490
500
541
1,791
-
816
-
975
-
(405)
(1,382)
(359)
(1,004)
(46)
(378)
(18,594)
(6)
(8,116)
(3)
(10,478)
(3)
$ 109,688
$
4,959
$
48,660
$
901
$
61,028
$
4,058
$ 136,995
$
49,508
$
55,942
$
13,218
$
81,053
$
36,290
CITY OF COLUMBIA NEICNTS, MINNESOTA
69 ANNUAL FINANCIAL REPORT
Form H -2
MUNICIPAL LIQUOR FUND
COMPARATIVE STATEMENT OF CHANGES IN FINANCIAL POSITION
Years Ended December 31, 1982 and 1981
Sources of Working Capital:
Operations:
Net income -- Form H -1
Items not requiring (providing) working capital:
Depreciation -- Form H -5
Gain on disposal of fixed assets
Proceeds from sale of equipment
Total Sources of Working Capital
Uses of Working Capital:.
Acquisition.of property and equipment -- Form H -5
Net Increase in Working Capital
Elements of Net -Increase in Working Capital:
Cash
Investments
Accounts receivable
- Inventory
Accounts payable
Accrued liabilities
Net Increase in Working Capital
[CITY OF COLUMBIA NEIGNTS, MINNESOTA
70
1982 1981
$ 136,995 $ 673,753
4,116 7,714
- (576,975)
- 651,611
$ 141,111 $ 756,103
$ 950
$
3,665
785,000
$ 140,161
$
7522438
(6,869)
$ (309)
$ (6,536)
127,700
785,000
174
(164)
5,444
(6,869)
12,746
(22,828)
(5,594)
3,835
$ 140,161 $ 752,438
ANNUAL FINANCIAL REPORT
MUNICIPAL LIQUOR FUND
COMPARATIVE SCHEDULE OF GROSS PROFIT - OFF SALE
Years Ended December 31, 1982 and 1981
1982
Total Liquor
TOTAL OFF SALE
Sales
Sales
537,967
$ 218,118
Cost of Sales:
Cost of Sales:
Inventory, Beginning
$
61,996
Inventory, Beginning
Purchases
442,421
180,173
Purchases
$ 504,7+17
$ 231,682
Less: Inventory, Ending
Total Merchandise Available for Sale
56,47.5
Cost of Sales
$
433,737
Less: Inventory, Ending
Gross Profit (Loss) on Sales
$
1042230
$ 42,911
Cost of Sales
19.37%
19.67%
Gross Profit (Loss) on Sales -- Form H -1
Percentage of Gross Profit to Sales
NO. 2
Sales
$
429,003
$
165,724
Cost of Sales:
Inventory, Beginning
$
53,502
$
43,833
Purchases
344,647
126,929
Total Merchandise Available for Sale
398,149
170,762
Less: Inventory, Ending
50,262
38,255
Cost of Sales
$
347,887
$
132,507
Gross Profit (Loss) on Sales
$
81,116
$
33,217
Percentage of Gross Profit to Sales
18.91%
20.04%
NO. 3
Sales
$
537,967
$ 218,118
Cost of Sales:
Inventory, Beginning
$
61,996
$, 51,509
Purchases
442,421
180,173
Total Merchandise Available for Sale
$ 504,7+17
$ 231,682
Less: Inventory, Ending
70,680
56,47.5
Cost of Sales
$
433,737
$ 175,207
Gross Profit (Loss) on Sales
$
1042230
$ 42,911
Percentage of Gross Profit to Sales
19.37%
19.67%
LCITY OF COLUMBIA NEIGNTS, MINNESOTA
71
ANNUAL FINANCIAL REPORT
'
Form
H -3
1381
Beer
Other
Total
Liquor
--Beer
Other
'
$
972,858
$
385,970
$
568,8 47
$
18,041
'
$
110,238
$
87,380
$
19,905
$
2,953
781,826
301,2 (11
458,687
21,876
T-r92,064
$388 , W3-
$ 478,592
$ '24,829
'
115,498
95,342
18,307
1,849
$
776,566
$
293,301
$
460,285
$
22,980
'
$
196,292
$
92,669
$
108,562
$
(4,939)
'
20.18%
24.01%
19.08%
- %
'
$
249,576
$
13,703
$
441,978
$
172,312
$
262,284
$
7,382
$
8,751.
$
918
$
47,736
$
37,402
$
9,121
$
1,213
'204,823
12,895
362,582
138,783
213,444
10,355
$
213,574
$
13,813
$
410,318
$
176,185
$
222,565
$
11,568
10,318
1,689
53,502
43,833
8,751
918
'
$
203,256
$
12,124
$
356,816
$
132,352
$
213,814
$
10,650
$
46,320
1,579
85,,162
39,960
48,470
(3,268)
'
18.56%
11.52%
19.27%
23.19%
18.48%
- %
$
302,715
$
17,134
$
530,880
$
213,658
$
306,563
$
10,659
'
$
9,556
$
931
$
62,502
$
49,978
$
10,784
$
1,740
245,088
17,160
419,244
162,480
245,243
11,521
'
$$ 25+,644
$
18,091
$
481,746
$
212,458
$
256,027
$
13,261
112250
2,955
61,996
1
51,509
9,556
931
$
243,394
$
15,136
$
419,750
$
160,949
$
246,471
$
12,330
'
$
59,321
$
1,998
$
111,130
$
52,709
$
60,U92
$
(11671)
19.60%
11.66%
20.93%
24.67%
19.60%
- %
'
CITY OF COLUMBIA
NEIGNTS,
MINNESOTA
72
ANNUAL FINANCIAL
REPORT.
MUNICIPAL LIQUOR FUND
COMPARATIVE SCHEDULE OF OPERATING EXPENSES
COMBINED ON -SALE AND OFF -SALE
Years Ended December 31, 1982 and 1981
1982
Total On -Sale
PERSONAL SERVICES:
Salaries - regular employees
$ 52,209 $ -
Salaries - overtime and part time employees
44,541 -
Interdepartmental labor services
2,026 -
City contribution to PERA and FICA
8,477 -
Hospitalization - Life insurance
3,812 -
Workmen's and unemployment compensation
1,752 -
Total Personal Services
$ 112,817 -
OTHER SERVICES & CHARGES:
Contractural maint & repair
$ 2,688 $ -
Professional services
2,332 -
Communications
2,489 -
Travel - subscriptions
869 -
Utility
8,367 -
Insurance & bonds
11,453 -
Other contractural services
4,339 -
Other charges
4,039 -
Total Other Services & Charges
$ 36,576 $ -
SUPPLIES:
General supplies $ 4,530 $ -
Bar supplies - -
Total Supplies $ 4,530 $ -
Total Operating Expense $11 153,923 $
{Form II -1 )
CITY OF COLUMBIA NEIGNTS, MINNESOTA
73
ANNUAL FINANCIAL REPORT
Form H -4
$ 2,131
$ 2,131
$ 72,262
$ 2,399
$ 2,399
$ 81,661
CITY OF COLUMBIA HEIGHTS, MINNESOTA
$ 5,246 $ 1,000
2,152 2,152
$ 7,398 3,152
$ 325,111 $ 177;104
(Form H -1
74
$ 1, 797 $ 2,449
$ 1,797 $ 2,449
$ 71,440 $. 76,567
ANNUAL FINANCIAL REPORT
1982
1981
No. 2
No. 3
Total
On -Sale
No. 2
No. 3
$ 27,678
$
24,531
$ 113,081
$
48,590
$
32,557
$
31,934
14,722
29,819
79,804
44,567
16,848
18,389
6,181
(4,155)
4,040
1,895
174
1,971
3,764
4,713
19,570
10,394
4,255
4,921
2,019
1,793
6,345
2,809
2,014
1,482
,502
$$ 54,866
$
1,250
57,951_
10,978
$ 233,778
$
9,260
117,515
739
$ 56,587
$
$ 840
$
.1,848
$ 1,.933
$
342
$
931
$
660
1,124
1,208
25,830
24,149
830
851
1,275
1,214
2,658
865
890
903
368
501
702
186
258
258
-3,420
4,947
13,156
5,687
3,412
4,057
4,572
6,881
27,180
20,009
3,478
3,693
1,615
2,724
4,377
1,517
1,059
1,801
2,051
1,988
8,099
3,682
2,198
2,219
$ 15,265
$
21,311
$ 83,935
$
56,437
$
13,056
$
14,442
$ 2,131
$ 2,131
$ 72,262
$ 2,399
$ 2,399
$ 81,661
CITY OF COLUMBIA HEIGHTS, MINNESOTA
$ 5,246 $ 1,000
2,152 2,152
$ 7,398 3,152
$ 325,111 $ 177;104
(Form H -1
74
$ 1, 797 $ 2,449
$ 1,797 $ 2,449
$ 71,440 $. 76,567
ANNUAL FINANCIAL REPORT
MUNICIPAL LIQUOR FUND
SCHEDULE OF PROPERTY, EQUIPMENT AND
ACCUMULATED DEPRECIATION
Year Ended December 31, 1982
Property and Equipment
Balances Deletions Balances
1 -1 -82 Additions 12 -31 -82
Off Sale No. 2 Store:
Land_
$
2,765
$
-
$
2,765
Building
27,637
-
27,637
irnprovements other than buildings
11,463
-
11,463
Fixtures
7,054
-
7,054
Equipment:
Store
3,580
950
4,530
Office
502
-
502
Total
$
53,001
$
950
$
53,951
Off Sale No. 3 Store:
Land
$
4,360
$
-
$
4,360
Building
42,623
-
42,623
Improvements other than buildings
8,202
-
8,202
Fixtures
14,791
-
14,791
Equipment:
Store
6,573
-
6',573
Office
370
-
370
Total
$
76,919
$
-
$
76,919
Grand Totals
$
129,920
$
950
$
130,870
(Form H -2)
(Form H)
CITY OF COLUMBIA NEIGNTS, MINNESOTA
ANNUAL FINANCIAL REPORT
75
1
1
Balances
Depreciation
Balances
'
1 -1 -82
Taken
12 -31 -82
9,535
553/
10,6nl
5,066
42,3
5,489.
'
6,568
71�
6,639
1,223
461✓
1,684
263
64,/
327
$
22,655
$
1,572
$
24,227
$
-
. $
-
$
-
16,129
872
17,001
5,272
302
5,574
'
13,337
740
14,077
2,818
603
3,421
'
26o
27
287
$
37,816
$
2,544
$
40,360
t$
60,471
$
4,116
$
64,587
Form H -1
(Form H
CITY OF COLUMBIA NEICNTS, MINNESOTA 76
Form H -5
Net Asset
Value
$ 2,765
17,549
5,974
415
2,8146
175
$ 29,724
$ 4,360
25,622
2,628
714/ X577
3,152
8j)
$ 36,559
$ 66,283
(Form H)
ANNUAL FINANCIAL REPORT
Form I
WATER UTILITY FUND
COMPARATIVE BALANCE SHEET
December 31, 1982 and 1981
. 1981
ASSETS
1982
Restated
Current Assets:
Cash - treasurer's balance
$
68
$
890
Investments, at cost
153,000
57,000
Accounts receivable:
Unbilled services
123,793
114,291
Special assessments:
p Current
-
-
Delinquent
1,381
1,794
Other
43,443
116,709
Meter inventory, at cost
3,191
3,191
> Total Current Assets
$
324,876
$
293,875
Property and Equipment:
Land
$
45,223
$
45,223
Buildings
210,987
210,987
Improvements other than buildings
2,162,452
2,162,205
Machinery and equipment
111,601
109,311
Total
2,530,263
$ 2,527,72
Less: Accumulated depreciation
1,016,123
974,351
Net Property and Equipment -- Form 1 -4
$
1,514,140
$
1,553,375
Total Assets
$
1,839,016
$
1,8479250
LIABILITIES, AND FUND EQUITY
Current Liabilities:
Accounts payable $ 41,877 $ 34,954
Accrued salaries payable 2,369 5,008
Accrued FICA /P.E.R.A. payable 435 517
Due to other governmental units - -
Due to general obligation bonds of 1965 15,400 14,300
Total Liabilities $ 60,081 $ 54,779
Other Liabilities (less current portion above):
Due to general obligation bonds of 1965 - 15,400
Total Liabilities S 60,081 $ .70,179
Fund equity:
Contributed $ 1,119,748 $ 1,146,042
Retained earnings unreserved -- Form 1 -1 659,187 631,029
Total Fund Equity $ 1;778,935 $ 1,777,071
Total Liabilities, and Fund Equity $ 1,839,016 $ 1,847,250
CITY OF COLUMBIA NEIGNTS, MINNESOTA 77 ANNUAL FINANCIAL REPORT
i
i
i
i
I
1
1
1
I
Form 1 -1
WATER UTILITY FUND
COMPARATIVE STATEMENT OF CHANGES IN FUND EQUITY
Years Ended December 31, 1982 and 1981
1982 1981
Retained Retained
Contributions Earnings Contributions Earnings
Balance, January 1, as
originally reported $.1,867,534 $ (90,463) $ 1,867,534 $ (83,291')
Adjustments to transfer
accumulated depreciation
on contributed assets
to contributions
As adjusted
Income transferred to
retained earnings
Depreciation on contributed
assets
Transfer to Central Garage
Fund
Balance, December 31
(721,492) 721,492
$ 1,146,042 $ 631,029
(26,294)
$ 1,119,748 $ 659',187
CITY OF COLUMBIA NEIGNTS, MINNESOTA 78
(695,198) 695,198
$ 1,172,336 $ 611,907
32,122
(26,294)
(13,000)
it > > LA nLq t 4*21 n)o
ANNUAL FINANCIAL REPORT
Form 1 -2
WATER UTILITY FUND
COMPARATIVE STATEMENT OF REVENUES AND EXPENSES
Years Ended December 31, 1982 and 1981
1981.
1982 Restated
Operating Revenues:
Water sales $ 691,804 $ 696,913
Hydrant rental 500 500
Meter sales (less cost of sales) 651 759
Customer service 11',234 1,891
Penalties 7,244 8,337
Total Operating Revenue $ 711,433 $ 708,400
Operating Expenses:
Source of supply
$
476,751
$
438,397
Distribution:
Personal services
109,591
134,465
Other services and charges
38,761
32,180
Supplies
19,609
17,485
Administratio^ & General:
Personal services
18,120
17,768
Other services and charges
11,111
14,473
Supplies
51.1
122
Total Operating Expenses
$
674,454'
$
654,890
Operating Income Before Depreciation
$
36,979
$
53,510
Less: Depreciation -Form 1 -4
41,772f
43,470,'
Operating Income (Loss)
$
(4,793)
$
10,040
Nonoperating Revenues (Expenses):
Interest earnings - Trust Fund
$
6,817
$
7,012
Miscellaneous
1,325
627
Interest expense
(1,485)
(1,851)
Total
$
6,657
$
5,788
Net Income before transfers
$
1,864
$
15,828
Transfer to Debt Service Funds - City Garage
-
10,000
Net Income - Form 1 -1
$
1,864
$
5,828
Transfer depreciation on contributed assets
26,294
26,294
Income transferred to retained earnings
$
28,158
$
32,122
CITT' OF COLUMBIA NEIGNTS, MINNESOTA 79 ANNUAL FINANCIAL REPORT
For__
WATER UTILITY FUND
COMPARATIVE STATEMENT OF CHANGES IN FINANCIAL POSITION
Years Ended December 31, 1982 and 1981
Source of Working Capital:
Operations:
Net income (loss) -- Form 1 -2
Items not requiring (providing) working capital:
Depreciation -- Form 1-4
Total Sources of Working Capital
Uses of Working Capital:
Transfer to Central Garage
Acquisition of property and equipment -- Form 1 -4
Reduction in amount due to other funds
Total Uses of Working Capital
Net Increase (Decrease) in Working Capital
Elements of Net Increase (Decrease) in Working Capital:
Cash
Investments
Accounts receivable
Inventory
Accounts payable
Accrued expenses
Due to other governmental units
Due to other funds
Net Increase (Decrease) in Working Capital
I CITY OF COLUMBIA NEICNTS, MINNESOTA
F:
1982 1981
$ 1,864 $ 5,828
41,772 43,470
$ 43,636 $ 49,298
$ $ 13,000
2,537 3,302
15,400 14,300-
$ 17,937
$
30,602
$ 25,699
$
18,696
$ (822)
$ (656)
96,000 .
(15,000)
(64,177)
29,405
-
1,325
(6,923)
(33,255)
2,721
(1,518)
-
41,145
(1,100)
(2,750)
$ 25,699
$ 18,696
ANNUAL FINANCIAL REPORT
WATER UTILITY FUND
SCHEDULE OF PROPERTY, EQUIPMENT AND
ACCUMULATED DEPRECIATION
Year Ended December 31, 1982
Land
Buildings
Improvements other than buildings
Machinery and equipment
Office furniture and equipment
Grand Totals
I CITY OF COLUMBIA NEIGNTS, MINNESOTA
Property and Eauipment
Balances Balances
1 -1 -82 Additions Transfers 12 -31 -82
$ 45,223 $ - $ - $ 45,223
210,987 - - 210,987
2,162,205 247 - 2,162,452
106,483 2,290 - 108,773
2,828 - - 2,828
$2,527,726 $ 2,537 $ - $2,530,263
ANNUAL FINANCIAL REPORT
'
Form 1 -4
0
Accumulated Depreciation
Balances
Depreciation
Balances
Net Assets
1 -1 -82
Taken Deductions
12 -31 -82
Value
$ - $
_ $ _ $
_
$ 45,223
'
49,014
6,789 -
55,803
155,184
834,826
30,424 -
865,250
1,297,202
'
87,978
4,487 -
92;465
16,308
2,533
72 -
2,605
223
1
$ .974,351 $
41,772 $ - $
1,016,123
$ 1,514,140
1
11CITY
OF COLUMBIA
NEIGNTS, MINNESOTA 82
ANNUAL FINANCIAL REPORT
LIABILITIES, AND FUND EQUITY
Form J
, SEWER UTILITY FUND
COMPARATIVE BALANCE SHEET
$ 4,571
$
8,180
December 31, 1982 and 1981
4,364
2,803
Accrued FICA and PERA payable
1982
1981
ASSETS
49,870
111,059
Current Assets:
$ 59,240
$
122,042
Cash - Treasurer's balance
$ 37
$
2,770
Investments, at cost
204,526
251,450
Accounts receivable:
Unbilled services
124,956
$
111,619
Other,
43,563
-
Due from other governmental units
232,229
$
-
Total Current Assets
$ 605,311
$
365,839
Deferred .AsF -ts:
$2,305,133
$
1,760,869
Metropolitan Waste Control Commission:
:X ve capacity
$ 29,531
$
31,128
Interceptor acquisition contract
281,947
292,518
Total Deferred Assets
$ 311,478
$
323,646
Property and Equipment:
Land
$ 36,586
$
36,586
Buildings
24,308
24,308
Improvements other than buildings
2,333,410
2,318,139
Machinery and equipment
179,489
177,818
Total
$2,573,793
$
2,556,851
Less: Accumulated depreciation
1,126,209
1,0701907
Net Property and Equipment -- Form J -4
$1,447,584
$
1,485,,944
Total Assets
$2,364,373
$
2,175,429
LIABILITIES, AND FUND EQUITY
Current Liabilities:
Accounts payable
$ 4,571
$
8,180
Accrued salaries payable
4,364
2,803
Accrued FICA and PERA payable
435
-
'Due to other governmental units
49,870
111,059
Total Current Liabilities
$ 59,240
$
122,042
Deferred Credits:
Revaluation gain:
Interceptor acquisition by Metropolitan Waste Control
Commission
$ -
$
292,518
Fund Equity:
Contributions from customers
$1,096,422
$
1,135,357
Retained earnings unreserved -- Form J-1
1,208,711
625,512
Total Fund Equity
$2,305,133
$
1,760,869
Total Liabilities, 'Contributions, and Retained
Earnings
$2,364,373
$
2,175,429
CITY OF COLUMBIA NEIGNTS, MINNESOTA 83
ANNUAL FINANCIAL REPORT
Form J -1
SEWER UTILITY FUND
COMPARATIVE STATEMENT OF CHANGES IN FUND EQUITY
Years Ended December 31, 1982 and 1981
Balance, January 1,
as.originally reported
Adjustment to transfer
accumulated
depreciation on
contributed assets
to customer contributions
As Adjusted
Income transferred to retained
earnings
Depreciation on contributed
assets
Transfer. to Central Garage
Fund
Balance, December 31
CITY OF COLUMBIA NEIGNTS, MINNESOTA
1982 1981
Customer Retained Customer Retained
Contributions Earnings Contributions Earnings
$ 1,891,128 $ (130,259) $ 1,891,128 $ (227,566)
(755,771)
755,771
(716,836)
716,836
$ 1,135,357 $
625,512
$ 1,174,292 $
489,270
583,199
(38,935)
(38,935)
149,242
(13,000)
$ 1,096,422 $ 1,208,711 $.1;135,357 $ 625,512
w
ANNUAL FINANCIAL REPORT
SEWER UTILITY FUND
Form J -2
COMPARATIVE STATEMENT OF REVENUES AND EXPENSES
Years Ended December 31, 1982 and 1981
1981
Operating Revenues: 1982 Restated
Sewer service charges - general customers
and interdepartmental $ .721,937 $ 730,131
Refunds and Reimbursements:
Metropolitan Waste Control Commission:
Interceptor maintenance 26,916 2,645
S.A.C. charge refund 659 530
Total Operating Revenues 749,512 $ 733,306
Operating Expenses:
Disposal - Metro Waste Control Commission
$ 222,824
$ 443,683
Deduct experience adjustment for prior years
-
(63V900
-2
Net Disposal Charges
222,824
$$ 222,�
$$ 379,7$
Collections:
1,048
889
Personal services
111,321
103,350 '
Other services and charges
38,129
27,582
Supplies
21,292
24,237
Administration:
-
-
Personal services
15,923
19,544
Other services and charges
11,099
14,190
Supplies
529
81
Total Operating Expenses
421,117
$ 568,766
Operating Income Before Depreciation
$ 328,395
$ 164,540
Less : Depreciation -- Form J -4
55 301
57,065
Operating Income (Loss)
273)094
107,475
Nonoperating Revenues (Expenses):
Interest earnings
$ 26,612
$ 14,643
Metro Waste Control Commission
Interest on deferred current value credit
11,701
12,107
Interest on reserve capacity deferred charges
1,048
889
Inflow grant
77,429
-
Other income (Expense)
-
193
Inflow study expense
(86,044)
-
Interest expense
-
-
Total
$$ 37�6
$$ 27,832
Net Income before transfers and extraordinary item
303; 640
135,307
Transfers to:
Debt Service Funds - City Garage
$ -
$ 10,000
Debt Service Funds - Storm Sewer
15,000
15,000
PIR Fund - Storm Sewer Construction
37,094
-
Net Income (Loss) before extraordinary item -
Form J -1
$ 251,746
$ 110,307
Extraordinary Item-recognition of remaining deferred gain
on Interceptor Acquisition by M.W.C.C.
292,518
-
Net Income
$$ 544,264
$ 110,307
Transfer depreciation on contributed assets
38,935
_583,199
38,935
Income transferred to retained earnings
$$ 149,242
CITY OF COLUMBIA NEICNTS, MINNESOTA 85 ANNUAL FINANCIAL REPORT
CITY OF COLUMBIA NEIGNTS, MINNESOTA 86 ANNUAL FINANCIAL REPORT
Form J -3
'
SEWER UTILITY FUND
COMPARATIVE STATEMENT OF CHANGES IN FINANCIAL
POSITION
Years Ended December 31, 1982 and 1981
'
1982
1981
Source of Working Capital:
'
Operations:
Net income (loss)before extraordinary item - Form J -2
$
251,746
$
110,307
Items not requiring (providing) working capital:
'
Depreciation - Form J -4
55,301
57,065
Working Capital Provided from Operations before
$
307,047
$
167,372
extraordinary item
Extraordinary Item - recognition of remaining deferred
gain on interceptor acquisition by MWCC
292,518
-
Total Working Capital Provided
$
599,565
$
167,372
'
Metropolitan Waste Control Commission:
Decrease in long -term contract receivable
$
10,571
$
10,165
Decrease in deferred receivable - Reserve Capacity
charge
1,597
1,502
Total Metropolitan Waste Control Commission
$
12,168
$
11,667
'
Total Sources of Working Capital
$
611,733
$
179,039.
'
Uses of Working Capital:
Decrease in deferred credit - revaluation
gain on sale of fixed assets
292,518
$
10,165
Transfer to Central Garage Fund
-
13,000
'
Additions to property and equipment -- Form J -4
16,942.
14,654
Total Uses of Working Capital
$
309,460-
$
37,819
Net Increase in Working Capital
$
302,273'
$
141,220
'
Elements of Net Increase (Decrease) in Working Capital
Cash
$
(2)-733)
$
81
Investments
(46,9244)
229,000
Accounts receivable
289,128.
10,379
'
Accounts payable
62,802
(64,699)
Due to Bonds of 1976 Fund
-
-
Due from /to Metro Waste Control Commission
-
(33,541)
'
Net Increase in Working Capital
$
302,273
$
141 220
CITY OF COLUMBIA NEIGNTS, MINNESOTA 86 ANNUAL FINANCIAL REPORT
SEWER UTILITY FUND
SCHEDULE OF PROPERTY, EQUIPMENT AND
ACCUMULATED DEPRECIATION
Year Ended December 31, 1982
Land
Buildings
Improvements other than building
Machinery and equipment
Office furniture and equipment
Grand Total
CITY OF COLUMBIA NEIGNTS, MINNESOTA
87 ANNUAL FINANCIAL REPORT
Property and Equipment
Balances
Balances
1 -1 -82
Additions Transfers
12 -31 -82
$ 36,586
$ - $ -
$ 36,586
24,308
- -
24,308
2,318,139
15,271 -
2,333,410
176,2.55
1,671 -
177,926
1,563
- -
1,563
$2,556,851
$ 16,942 S -
$2,573,793
87 ANNUAL FINANCIAL REPORT
C
Form J -4
Net Assets
Value
$ 36,586
15,046
1,364,779
31,032
$1,447,584
CITY Of COLUMBIA NEIGNTS, MINNESOTA 88 ANNUAL FINANCIAL REPORT
'
Balances
Accumulated Depreciation
Depreciation
Balances
1 -1 -82
Taken Deductions
12 -31 -82
'
$
$ $
$
8,652
610 -
9,262
'
921,194
47,437 -
968,631
139,701
7,193 -
146,894
1,361
61 -
1,422
$1,070,908
$ 55,301 $ -
$ 1,126,209
C
Form J -4
Net Assets
Value
$ 36,586
15,046
1,364,779
31,032
$1,447,584
CITY Of COLUMBIA NEIGNTS, MINNESOTA 88 ANNUAL FINANCIAL REPORT
HE CITX OF COLUM IA HEIGHTS, MINNESOTA
NNUA tINACIAL KEPRT
EAR kNDED BECEMBER ill 1082
EITERNAL SERVICE FOND
The Central Garage Fund is a self sustaining fund providing service
to other departments within the city and for which user fees are
paid by the using department. This fund was established in 1977.
TABLE OF CONTENTS
Central Garage Fund:
Balance Sheet
Statement of Revenues, Expenses, and
Changes in Retained Earnings
Statement of Changes in Financial Position
Schedule of Property, Equipment and
Accumulated Depreciation
Page
Form
K
89
Form
K -1
90
Form
K -2
91
Form
K -3
92
CENTRAL GARAGE FUND
COMPARATIVE BALANCE SHEET
December 31, 1982 and 1981
ASSETS
Current Assets:
Cash - Treasurer's balance
Investments, at cost
Accounts receivable
Inventory, at cost
Total Current Assets
Property and Equipment:
Buildings and improvements
Office furniture and equipment
Machinery and equipment
Total
Less: Accumulated depreciation
Net Property and Equipment -- Form K-3
Total Assets
LIABILITIES, CONTRIBUTIONS, AND RETAINED EARNINGS
Form K
1982 1981
$ 60 $ 1,505
40,700 39,000
- 150
53,390 53,456
$ 94,150 $ 94
$ 13,795 $ -
741 741
66,357 65,315
T-$O,893 $ 66YO56
49,815 44,660
$ 31,078 $ 21,396
$ 125,228 $ 115,507
Current Liabilities:
Accounts payable
$
51581
$
2,371
Accrued salaries payable
2,935
1,548
Accrued social security /P.E.R.A.,
374
218
Total Current Liabilities
$
8,890
$
4,137
Fund Equity:
Contributed - other city funds
$
94,653
$
94,653
Retained earnings (deficit)
Reserved for improvements
$
12,205
$
26,000
Unreserved
9,480
(9,283)
Total Retained Earnings
$$ 21,65
$
16,717
Total Fund Equity
Total Liabilities and Fund Equity
CITY OF COLUMBIA NEIGNTS, MINNESOTA
.
$ 116,338 $ 111,370
$ 125,228 $ 115,507
ANNUAL FINANCIAL REPORT
q
Form K -1
CENTRAL GARAGE FUND
COMPARATIVE STATEMENT OF REVENUES, EXPENSES, AND CHANGES
IN RETAINED EARNINGS
Years Ended December 31, 1982 and 1981
Billing to Departments
Operating Expense:
Mechanics labor
Other services and charges
Supplies
Contractural services
Total Operating Expense
Operating Income before depreciation
Less: Depreciation -- Form K -3
Operating Income
Nonoperating Revenues (Expenses):
Sale of materials
Interest income
Interest expense
Total
Net Income
Retained Earnings (deficit) at beginning of year
Transfers from Enterprise Funds
Retained Earnings (deficit) at end of year
CITY Of COLUMBIA NEIGNTS, MINNESOTA 90
1982 1981
$136,938 $ 127,393
$ 76;668 $ 76,512
37,689 24,184
11,100 8,052
5,337 5,222
$ 130,794 $ 113,970
$ 6,144 $ 13,423
5,155 4,892
$ 989 $ 8,531
$ 78
$
1,004
3,901
1,558
$ 3,979
$
2,562
$ 4,968
$
11,093
16,717
(20,376)
26,000
9 "s
$ 2- 1-,685
$
16,717
U
ANNUAL FINANCIAL REPORT
Form K -2
CENTRAL GARAGE FUND
COMPARATIVE STATEMENT OF CHANGES IN FINANCIAL POSITION
Years Ended December 31, 1982 and 1981
Sources of Working Capital:
Operations:
Net income -- Form K -1
Items not requiring (providing) working capital:
Depreciation -- Form K -3
Working Capital Provided by Operations
Transfers from other funds
Total Sources of Working Capital
Uses of Working Capital:
Acquisition of property and equipment -- Form K -3
Total Uses of Working Capital
Net Increase in Working Capital
Elements of Net Increase in Working Capital:
Cash
Investments
Accounts receivable
Inventory
Accounts payable
Due to other funds
Net Increase in Working Capital
CITY OF COLUMBIA NEIGHTS, MINNESOTA
R
J
1982 1981
$ 4,968. $ 11,093
5,155 4,892
$ 10,123 $ 15,985
26,000
$ 10,123 $ 41,985
$ 14,837
$
1,403
$ 14,837
$
1,403
L(4,714)
$
40,582
$ (1,445) $ (141)
1,700 33,000
(150). 150
(66) 5,292
(4,753) 2,281
1_(4,714) $ 40,582
ANNUAL FINANCIAL REPORT
G
z
LL.
LLJ
C9
Q
Q
C7
J
Q
H
z
Lu
U
Z
O
H
Q
U
W
a
W
G
G
W
Q
J N
00
01
U
U
Q ^
M
0
z L
Q N
.D
E
LU
W N
C
a
— v
a�
W C
Lit
>. L
H 10
w (1)
W >-
a
0
o`
d
0
Lu
J
92
Form K -3
ANNUAL FINANCIAL REPORT
N
W
ON
o
1"
r�
N U
^
O
C
N 7
O
Q
M
n
f6
^
M
m
Ill
•-
Z
U
tJf
VT
N
L
N N
CL
O 00
r�
00
Ln
N
U I
M
n
G
C ^
I
ID
00
10 M
L
•- I
M
01
O
to N
_:r
?
U
v>•
yr
U
C
C
O
r0
•-
3
+j
0
ca c
01%
LlN
•- U
I
^
M
Ll\
U ,C
Q
Cu M
L
Ll\
U1
CL
0)
N
01
O
U N
N
M
\.O
U 00
%D
O
.D
c I
1
r0 ^
-zr
0]
Ln
n
M
01
-::r
Ll1
M
N
^
f\
M
00
QJ 4
C
U I
M
lD
O.
N
C ^
^
\D
00
E
O M
4^
I
•-
(0 N
cr
W
LL1
N
r�
N
M
_zr
M
C
c
n
O
00
M
0
1
�.
4-J
^
+,
•-
L
"O
U
'D
d
Q
v>
yr
O
L
L(\
%D
N
_::r
LA
CL) N
I
n
M
O
U 00
\D
•- 1
m ^
m
to
va
c
CU
E
a
U
C
O
E
c
a
a�
Q
L
tV
7
aJ
• -
C
M
C
10
+i
L
O
N
r-
Q1
4-
L
c
U
-
4)
c
M
U
^
L
-
•7
4-
U
4-
10
m
O
i
92
Form K -3
ANNUAL FINANCIAL REPORT
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
HE CIT''OF COLUM$IA HEIGHTS, MINNESOTA
NNUA �INAVCIAL REP RT
EAR �NDED ECEMBER 31, 1982
GENERAL FIRED ASSETS
GROUP OF ACCOUNTS
TABLE OF CONTENTS
Statement of General Fixed Assets
ti
Form L
Page
93
li
L
STATEMENT OF GENERAL FIXED ASSETS
December 31, 1982
General Fixed Assets:
Land
Buildings
Improvements other than buildings
Office furniture and equipment
Machinery and equipment
Construction in progress
.Total - Form A
Investment in General Fixed Assets:
General obligation bonds:
Library bonds of 1966
Municipal building bonds of 1959
Park bonds of 1962
City garage bonds of 1972
Capital improvement bonds 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
CITY OF COLUMBIA NEICNTS, MINNESOTA
a
Form L
$ 3,025, 100
2,672,299
697,731
632,486
979,337
311,396
$ 8,318,349
$ 90,000
150,000
325,000
510,000
929,475
$ 2,004,475
$ 526,290
267,203
$ 793,493
$ 1,223,625
51,550
$ 1,275,175
$ 4,245,206
$ 8,318,349
ANNUAL FINANCIAL REPORT
1
1
1
1
1
1
1
1
1
1
1
1
HE CITY OF COLUMDIA HEIGHTS, MINNESOTA
NNUA INA CIAL EPQRT
EAR kNDED llECEMBER S1, 1982
GENERAL LONG-TERM DEBT
GROUP OF ACCOUNTS
TABLE OF CONTENTS
Page
Statement of General Long -Term Debt Form M 94
Schedule of Funding Available and Funds.
Required Form.M -1 95
Schedule of Debt Service Requirements to
Maturity Form M -2 96
Form M
STATEMENT OF GENERAL LONG -TERM DEBT
December 31, 1982
AMOUNT AVAILABLE AND TO BE PROVIDED FOR THE
PAYMENT OF GENERAL LONG -TERM DEBT
Amount available in debt service funds $ 656,093
Amount to be provided by future tax levies 8,353,907
Total Available and to be Provided $ 9,010,000
GENERAL LONG -TERM DEBT PAYABLE
General obligation bonds payable $ 9,010,000
In addition to the long -term debt exhibited in this statement, the
City of Columbia Heights has a contingent liability against its full faith
and credit on $2,550,000 of special assessment bonds recorded in the Special
Assessment Funds. The general credit of the municipality is obligated only
to the extent that liens foreclosed against properties involved in the special
assessment district are insufficient to retire outstanding bonds.
CITY ; OF COLUMBIA NEIGNTS, MINNESOTA
94
ANNUAL FINANCIAL REPORT
SCHEDULE OF FUNDING AVAILABLE
AND FUNDS REQUIRED
December 31, 1982
Cash, Investments, and Receivables
Deferred Tax Levies
Levy /Payable Years:
1982/83
1983/84
1984/85
1985/86
1986/87
1987/88
1988/89
1989/90
1990/91
1991/92
1992/93
1993/94
1994/95
1995/96
1996/97
1997/98
1998/99
1999/00
2000/01
Total
FUNDING AVAILABLE
Bonds /Future Interest Payable
Bonds
Future interest
FUNDS REQUIRED
BALANCE
Form M-1
Total
$ 656,093
893,108
887,368
1,332,068
892,658
939,698
971,198
998,498
1,047,848
1,064,648
1,077,248
1,059,398
1,118,198
1,116,098
1,056,563
995,925
934,185
871,710
808,500
114,188
$18,179,105
$18,835,198
$ 9,010,000
8,795,925
$17,805,925
C 1 n7a 772
CITY OF COLUMBIA NEIGNTS, MINNESOTA ANNUAL FINANCIAL REPORT '
95
Form M -2
SCHEDULE OF DEBT SERVICE REQUIREMENTS TO MATURITY
December 31, 1982
1983
1984
1985
1986
1987
1988
1989
1990
1991
1992
1993
1994
1995
1996
1997
1998
1999
2000
2001
2002
I CITY OF COLUMBIA NEIGNTS, MINNESOTA
M
General
Obliaation Bonds
Principal
Interest
$ 255,000
$ 717,710
150,000
706,940
450,000
701,500
140,000
665,750
190,000
652,550
250,000
634,950
300,000
612,950
350,000
586,950
425,000
555,950
475,000
519,950
525,000
479,950
550,000
436,950
650,000
388,950
700,000
334,600
700,000
277,375
700,000
219,100
700,000
159,950
700,000
100,100,
700,000
39,375
100,000
4,375
$9,010,000
$8,795,925
ANNUAL FINANCIAL REPORT
HE CITX OF COLUM IA HEIGHTS, MINNESOTA
NNUA t'INANCIAL KEP RT
EAR LNDED DECEMBER 31, 1Q82
STATISTICAL SECTION
TABLE OF CONTENTS
Page
Assessed Value and Market Value
of all Taxable Property
Table
1
97 -98
Tax Rates
Table
II
99
City Tax Levy
Table
111
100
Tax Levies and Tax Collections
Table
IV
101 -102
Special Assessment Collections
Table
V
101 -102
Revenues - Other than Property Taxes and
Special Assessments
Table
VI
103
Expenditures for Selected Functions
Table
VII
103
Statement of Legal Debt Margin
Table
VIII
104
Combining Schedule of Bonds Payable
Table
IX
105 -108
Schedule of Investments
Table
X
109 -110
Schedule of Insurance in Force
Table
XI
111 -112
Principal City Officials and Surety
Bonds
Table
XII
113
Miscellaneous Statistical Facts
Table
XIII
114 -115
ASSESSED VALUE AND MARKET VALUE
OF ALL TAXABLE PROPERTY
LEVY YEARS 1981 THROUGH 1982
1975 (1) 1976 1977 1978
Population
23,316
22,324
21,890
21,300
Real Property
9
Assessed Value
$
62,74$,967
$
67,746,917
$
68,981,490
$
71,601,406
Area -wide allocation
Contribution
$
(850,697)
$
(850,697)
$
(1,085,236)
$
(1,491,381)
Distribution
$
2,619,939
$
2,355,131
$
2,641,684
$
3,311,002
Market Value
$
181,360,401
$
198,140,355
$
219,125,884
$
248,901,043
Personal Property
Assessed Value
$
1,230,101
$
1,220,899
$
1,213,202
$
1,221,501
Market - commercial
$
2,860,700
$
2,839,300
$
2,821,400
$
2,840,700
Total Real and Per-
sonal Property
Assessed Value
$
65,748,310
$
70,472,250
$
71,751,140
$
74,642,528
Market Value
$
184,221,101
$
200,979,655
$
221,947,284
$
251,741,743
Ratio of Total Assess-
ed Value to Total
Market Value
:3569
:3506
:3233
:2965
Per Capita Valuations
Assessed Value
$
2,820
$
3,157
$
3,279
$
3,504
Market Value
$
7,901
$
9,003
$
10,139
$
11,819
(1) 1975 and subsequent, property values include net amount allocated
pursuant to the "fiscal disparities law ", Laws 1971 Extra Session.
Chapter 24, from area -wide (metropolitan) "pool ".
[CITY OF COLUMBIA NEIGNTS, MINNESOTA
M
ANNUAL FINANCIAL REPORT
u
1979
1980
1981
1982
21,270
20,029
19,800
19,670
$ 73,741,181
$
85,721,087
$
96,391,052
$
104,783,933
$ (1,840,970)
$
(2,000,000)
$
(3,908,286)
$
(4,487,006)
$ 4,062,894
$
4,383,409
$
8,183,307
$
10,544,639
$ 288,414,300
$
355,767,800
$
399,395,650
$
430,688,578
$ 1,218,792
$
1,295,504
$
1,344,094
$
1,333,301
$ 2,834,400
$
3,012,800
$
3,125,800
$
3,100,700
$ 77,181,897
$
89,400,000
$
102,010,167
$
112,174,867
$ 291,248,700
$
358,780,600
$
402,521,450
$
433,789,278
:2650
:2492
:2534
:2586
$ 3,629
$
4,563
$
5,152
$
5,702
$ 13,693
$
17,913
$
20,329
$
22,053
CITY OF COLUMBIA NEIGNTS, MINNESOTA
.;
Table I
ANNUAL FINANCIAL REPORT
Table II
TAX
RATES
YEARS 1972
THROUGH 1982
Fiscal
Metro
Year City
School
County
Council
Other (B)
Total
1972
66.59
162.66
67.59
5.01
301.85
1973
20.14
49.88
19.81
1.79
.74
92.36 (A)
1974
20.10
53.49
18.47
2.52
•99
95.57
1975
22.40
54.12
19.96
4.42
.6o
101.50
1976
21.75
49.16
19.73
2.73
.69
94.06
1977
20.41
47.26
19.84
3.00
.61
91.12
1978
22.13
46.53
22.02
2.73
•59
94.00
1979
21.847
45.036
21.913
2.913
•923
92.632
1980
21.101
46.727
23.349
2.990
•839
95.006
1981
18.153
41.483
25.005
3.832
.771
89.224
1982
17.303
48.266
24.085
3.556
.747
93.957
(A)
Determination
of assessed
valuation calculation
changed by
state
law - enacted
in 1971,
Extra Session, Chapter 31,
as amended
(B)
Rice Creek
Watershed
and 1/3 mill
for the Housing and Redevelopment
Authority
CITY OF COLUMBIA NEIGNTS,
MINNESOTA
ANNUAL
FINANCIAL REPORT
99
a
CITY TAX LEVY
YEARS 1972 THROUGH 1982
Table III.
(A) All for Storm Sewer Construction except 1976 the $100,000
is for settlement of Sullivan law suit.
(B) In 1979 Civil Defense Fund became a part of the General Fund.
CITY OF COLUMBIA - NEICNTS, MINNESOTA 100 ANNUAL nmANCIAL . REPORT
City
Bonds
Fiscal
Levy
General
Police
Fire
Civil
and
Year
Total
Fund
Relief
Relief
Defense(B)
Interest
Other (A)
1972
$1,105,517
$. 846,967
$ 50,000
$ 30,000
$ 11,000
$ 152,550
$ 15,000
1973
1,120,000
874,115
67,000
36,085
10,600
117,200
15,000
1974
1,156,540
899,045
67,000
42,700
17,000
115,795
15,000
1975
1,331,715
1,101,925
65,850
46,000
4,000
113,940
1976
1,429,510
396,270
66,000
47,000
20,240
300,000
100,000
1977
1,441,044
1,069,044
66,300
47,000
35,700
223,000
1978
1,583,156
1,188,556
78,500
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,108
64,500
47,000
275,000
1982
1,759,284
1,356,029
125,305
57,950
220,000
(A) All for Storm Sewer Construction except 1976 the $100,000
is for settlement of Sullivan law suit.
(B) In 1979 Civil Defense Fund became a part of the General Fund.
CITY OF COLUMBIA - NEICNTS, MINNESOTA 100 ANNUAL nmANCIAL . REPORT
Year
Collected
1974
1975
1976
1977
1978
1979
1980
1981
1982
Total Tax
Levy;;
$ 874,954
1,022,810
1,139,240
1,136,825
1,220,013
1,253,698
1,150,273
1,090,455
1,262,780
TAX LEVIES AND TAX COLLECTIONS
Years 1974 Through 1982
Collections
of Current
Years Taxes
During Fiscal
Period
$ 863,795
995,242
1,117,070
1,123,704
1,186,640
1,236,676
1,122,161
1,074,134
1,236,497
Percentage
of Levy
Collected
During Fiscal
Period
98.7
97.3
98.0
98.8
97.3
.98.6
97.6
98.5
97.9
Collection
of Prior
Year's Taxes
During Fiscal
Period
$ 10,136
16,563
18,377
22,470
16,687
20.648•
21,268
39,938
19,120
Total
$ 873,931
1,011,805
1,135,447
1,146,174
1,203,327
1,257,324
1,143,429
1,114,072
1,255,617
Tax levy has been adjusted by the 50% forgiveness (property tax replacement)
which is a revenue from other agencies and has been incorporated into Table VI.
SPECIAL ASSESSMENT COLLECTIONS
Years 1975 Through 1982
Information for a limited number of years is presented as undo effort would be
required to reconstruct this information from the prior system of record keeping.
I CITY OF COLUMBIA NEIGNTS, MINNESOTA
ffil
ANNUAL FINANCIAL REPORT
Percentage of
Current Special
Current Collected
Fiscal
Assessment Becoming Due
Current Special
During Fiscal.
Period
During Fiscal Period
Assessments Collected
Period
1975
$ 90,045
$ 49,149
54.6%
1976
107,784
60,320
56.0%
1977
114,673
70,635
61.6%
1978
107,635
68,029
63.2%
1979
160,087
110,534
69.o%
1980
129,773
70,627
54.4%
1981
190,708
102,985
54.0%
1982
217,927
107,932
49.5%
Information for a limited number of years is presented as undo effort would be
required to reconstruct this information from the prior system of record keeping.
I CITY OF COLUMBIA NEIGNTS, MINNESOTA
ffil
ANNUAL FINANCIAL REPORT
Table IV
Table V
Delinquent Specials
Total Special
Ratio
Assessments
Collected During
Accumulated
Ratio
Balance Fund
Delinquent'
Of Total
Accumulated
Taxes to
Collections
Delinquent
Current Year
To Tax Levy
Taxes
Tax Levy
.9988:1
$ 56,751
.0648:1
•9892:1
66,224
:0647:1
•9965:1
70,606
.0619:1
1.0082:1
59,211
.0520:1
•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
Table V
Delinquent Specials
Total Special
Deferred Special
Assessments
Collected During
Assessments Delinquent
Collected
Balance Fund
Fiscal Period (A)
At End of Fiscal Period
Fiscal Period of Fiscal Period
$ 71,642
$ 116,642
$ 75,305
$ 372,361
67,434
111,221
206,197
388,565
65,345
98,553
104,930
388,481
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
(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.
' CITY OF COLUMBIA NEIGNTS, MINNESOTA
102
ANNUAL FINANCIAL REPORT
Table VI
(A)
REVENUES -
OTHER THAN PROPERTY TAXES
Forfeitures
Proprietaries
AND SPECIAL
ASSESSMENTS
21,680
308,080
20,181
Years
1972 Through
1982
47,096
261,837
50,406
Charges for
Licenses
Fiscal
Revenues from
Use of Money
Service and
and
Year
Other Agencies
and Property
Other Revenue
Permits
311,850
698,704
432,422
1972
$ 817,715
$ 44,535
$ 311,790
$ 33,823
1973
1,285,224
37,473
312,824
37,216
1974
1,070,363
112,407
329,122
41,259
1975
1,304,408
89,266
341,341
47,807
1976
1,635,915
172,632
295,683
62,079
1977
1,883,756
144,293
342,277
71,228
1978
2,059,462
135,292
313,456
76,870
1.979
2,096,084
179,135
369,891
78,164
1980
2,272,119
474,873
419,930
68,710
1981
2,857,636
966,078
997,236
104,027
1982
2,310,131
545,881
1,248,375
148,773
Table VI
(A) The years 1972 -77 do not include depreciation for Sewer and Water Funds.
Table VII
EXPENDITURES FOR SELECTED FUNCTIONS
Years 1972 through 1982
Fiscal
(A)
Fines and
Profits of
Forfeitures
Proprietaries
$ 13,557
$ 238,732
21,680
308,080
20,181
361,747
29,573
298,283
47,096
261,837
50,406
128,169
38,191
106,014
49,067
32,521
72,274
106,845
67,301
835,981
47,073
447,667
(A) The years 1972 -77 do not include depreciation for Sewer and Water Funds.
Table VII
EXPENDITURES FOR SELECTED FUNCTIONS
Years 1972 through 1982
Fiscal
General
Public
Public
Parks and
Year
Government
Safety
Works
Sanitation
Library
Recreation
1972
$ 226,527
$ 605,120
$ 357,901
$ 196,700
$ 75,500
$ 333,047
1973
353,833
685,606
391,057
186,850
77,300
369,402
1974
311,850
698,704
432,422
208,752
82,500
420,323
1975
310,540
860,723
457,316
224,569
147,851
463,877
1976
374,191
875,714
511,377
227,055
103,280
512,066
1977
406,864
981,059
577,072
233,598
109,635
537,332
1978
424,527
1,070,279
606,541
246,957
121,968
676,027
1979
460,152
1,160,243
515,417
255,693
143,018
547,525
1980
516,593
1,315,826
566,643
268,793
163,801
622,154
1981
538,618
1,380,692
576,754
336,997
188,440
652,611
1982
532,444
!,454,404
581,121
403,670
188,343
443,863
:ITY OF COLUMBIA NEIGNTS, MINNESOTA 103 ANNUAL FINANCIAL REPORT
Table VIII
STATEMENT OF LEGAL DEBT MARGIN
December 31, 1982
Assessed Value ��
$112,174 811*
ti3 !�
if
Debt Limit 6.67% of Assessed Value (Note A) 7,482,064
Amount of Debt Limit Applicable to Debt Limit:
Total bonded debt $11,560,000
Less Not B:
Tax Increment $8,625,000
Special Assessment Bonds 2,550,000 11,175,000
Total Debt Applicable to Debt Limit 385,000
Legal Debt Margin $ 7,097,064
Note (A):
�
M.S.A. Section 475.53 (Limit on Net Debt)
"Subdivision 1. Generally. -Except as otherwise provided in sections 475.51 to 475.70,
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 6.67 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 the current fiscal
year to the payment of any debt and the aggregate of the principal of the following:
(1) Ob Vigations 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) Wa.rrents 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 is or may 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 the 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.
Includes valuation from "fiscal disparity" legislation; Minnesota laws 1971, Extra
Session, Chapter 24. See Table I.
CITY OF COLUMBIA NEIGNTS, MINNESOTA
Inh
ANNUAL FINANCIAL REPORT
COMBINING SCHEDULE OF BONDS PAYABLE
December 31, 1982
SPECIAL ASSESSMENT BONDS:
Permanent _Improvement Revolving Bonds of 1972
Non - Callable
4.30%
Total P.I.R. Bonds of 1972
Permanent Improvement Revolving Bonds of 1932
All Callable in inverse order on
December 1, 1983 at 105% of their
6.70%
principal and on any interest payment
6.701
date thereafter at 100% of their
6.70%
principal
Total P.I.R. Bonds of 1982
GENERAL OBLIGATION BONDS:
Storm Sewer Bonds of 1965
All Callable after January 1, 1980 in
inverse order at par and accrued
3.60%
interest plus a premium of $50 per bond
3.60 °0
Total Storm Sewer Bonds of 1965
City Garage Bonds of 1972
Non - Callable
4.30%
Total City Garage Bonds of 1972
Capital Improvement Bonds of 1976
Non - Callable
4.60%
Total Capital Improvement Bonds of 1976
Interest Final
Pates and Issue Maturity
Dates Date Date
7 -1 -72 1 -1 -83
1/1 -7/1
1
12 -1 -82 12 -1 -85
12/1 -6/1
10 -1 -65 1 -1 -85
1/1 -7/1
7 -1 -72 1 -1 -83
1/1 -7/1
4 -1 -76 10 -1 -83
CITY OF COLUMBIA NEIGNTS, MINNESOTA 105 I ANNUAL FINANCIAL REPORT
Table IX
Annual
Authorized
Sertal'
And
Payments
Issued
Matured
Outstanding
$
$ 455,000
$
455,000
$
-
$ 455,000
$
455,000
$
-
-
(83)
(84)
2,550,000
(85)
2,550,000
-
2,550,000
$2,550,000 J
$
-
$
2,550,000
$ -
$ 645,000
$
645,000
$
-
130,000
(83)
130,000
-
130,000
140,000
(84)
140,000
-
140,000
$ 915,000
$
645,000
$
270,000
$
$ 510,000
$
510,000
$
-
$ 510,000
$
510,000
$
-
$ _
$ 905,000
$
905,000
$
-
115,000
(83)
115,000
-
115,000
$1,020,000
$
905,000
$
115,000
ti
CITY OF COLUMBIA NEIGNTS,
MINNESOTA
/
ANNUAL
FINANCIAL REPORT
106
COMBINED SCHEDULE OF BONDS PAYABLE (Continued)
December 31,'1982
CITY OF COLUMBIA NEIGNTS, MINNESOTA ANNUAL FINANCIAL REPORT
Interest
Fine
Rates and
Issuee Maturity
Dates
Date. Date
GENERAL OBLIGATION BONDS (Continued):
Tax Increment Bonds of 1980
9 -1 -80 3 -1 -02
Bonds maturing in 1991 and later
8.00% 3/1 -91
years will be subject to redemp-
8.00
tion and prepayment at the option
8.00
of the City in inverse order of
8.00
serial numbers on March 1, 1990.
8.00
8.00
8.00
8.00
8.00
8.00
8.00
8.00
8.00
8.10
8.25
8.40
8.50
8.60
8.75
8.75
Total Tax Increment Bonds of 1980
-
Tax Increment Bonds of 1982
j 12 -1 -82 12 -1 -85
All callable in inverse order on
6.70%
I
December 1, 1983 at 105% of their
6.70
principal and on any interest
6.70
payment date thereafter at 100%
of their principal.
Total Tax Increment Bonds of 1982
Total General Obligation Bonds
Total Bonds Payable - All Funds
CITY OF COLUMBIA NEIGNTS, MINNESOTA ANNUAL FINANCIAL REPORT
Annual Authorized
Serial and
Payments Issued
10,000
(83)
10,000
10,000
(84)
10,000
(85)
140,000
(86)
140,000
190,000
(87)
190,000
250,000
(88)
250,000
300,000
(89)
300,000
350,000
(90)
350,000
425,000
(91)
425,000
475,000
(92)
475,000
525,000
_(93)
525,000
550,000
(94)
550,000
650,000
(95)
650,000
700,000
(96)
700,000
700,000
(97)
700,000
700,000
(98)
700,000
700,000
(99)
700,000
700,000
(00)
700,000
700,000
(01)
700,000
100,000
(02)
100,000
$8,175,000
_
(83)
_
-
(84)
-
450,000
(85)
450,000
$ 450,000
CITY OF COLUMBIA NEIGNTS, MINNESOTA
a
108
Table 1X
Matured Outstanding
10,000
10,000
140,000
190,000
250,000
300,000
350,000
425,000
475,000
525,000
550,000
650,000
700,000
700,000
700,000
700,000
700,000
700,000
100,000
$ - $ 8,175,000
450,000 G1
$ - $ 450,000
$ 9,010,000
$11,560,000
ANNUAL FINANCIAL REPORT
SCHEDULE OF INVESTMENTS
December 31, 1982
I CITY OF COLUMBIA NEIGNTS, MINNESOTA 109
Date
Acquired
10 -01 -69
12 -06 -83
12 -27 -83
12 -31 -82
3 -23-77
6 -30 -80
11-02 -81
9 -10 -82
10 -04 -82
10 -12 -82
10 -01 -82
12 -06 -82
12 -06 -82
12 -06 -82
Maturity Par
Date Value
1 -01 -84 $ 10,000
3 -06 -83 564,000
3 -26 -83 600,000
1 -03-83 1,771,204
3 -01 -06 187,183
6 -30 -84 100,000
8 -15 -85 500,000
3-09 -83 790,000
9 -29 -83 500,000
4 -11 -83 300,000
1 -31 -83 365,000
12 -01 -83 485,000
6 -09 -83 350,000
2 -10 -84 1,500,000
$8,022,387
ANNUAL FINANCIAL REPORT
Yield
City of Columbia Heights
Storm Sewer Bonds
1965 4.83
Certificate of Deposit - Twin City Federal
8.76
Certificate of Deposit - American National
Bank 8.40
Repurchase Agreement
10.25
Ginny Mae
7.58
U.S. Treasury Note
9.2
U.S. Treasury Note
8.95
Federal National Mortgage
Association
10.25
Federal National Mortgage
Association
10.50
Federal National Mortgage
Association
8.39
Federal National Mortgage
Association
9.25
Federal National Mortgage
Association
9.15
Federal National Mortgage
Association
9.89
Federal National Mortgage
Association
9.63
I CITY OF COLUMBIA NEIGNTS, MINNESOTA 109
Date
Acquired
10 -01 -69
12 -06 -83
12 -27 -83
12 -31 -82
3 -23-77
6 -30 -80
11-02 -81
9 -10 -82
10 -04 -82
10 -12 -82
10 -01 -82
12 -06 -82
12 -06 -82
12 -06 -82
Maturity Par
Date Value
1 -01 -84 $ 10,000
3 -06 -83 564,000
3 -26 -83 600,000
1 -03-83 1,771,204
3 -01 -06 187,183
6 -30 -84 100,000
8 -15 -85 500,000
3-09 -83 790,000
9 -29 -83 500,000
4 -11 -83 300,000
1 -31 -83 365,000
12 -01 -83 485,000
6 -09 -83 350,000
2 -10 -84 1,500,000
$8,022,387
ANNUAL FINANCIAL REPORT
Table X
Unamortized
Unamortized
Book
Discount
Premium
Value
Summary by Fund
$ 2,550
$ -
$ 7,4500%
General Fund -
$1,706,190
-
-
564,000
Form B
Special Revenue Funds- 525,980
-
-
600,000 #"
Form C
-
-
1,771,204'! #�
Debt Service Funds -,
64.0,400
Form D
-
-
187,183
Capital Projects
399
-
99,601�A
Funds -
1,866,502
-
6,903
506,903 ,
Form E
Special Assessment
38,512 -
-
751,488`
Funds -
1,568,624
47,500 -,
-
452,500 l;
Form F
Enterprise Funds -
1,625,226
12,067 -;
-
287,933
Form G
10,919
-
354,081
Central Garage Funds
- 40,700
Form K
40,869 *
-
444,131
$7,973,622
15,027
-
334,973-,
-
27,450
1,,527,450
( Q
\$7,888,897 '\,-
1 vl
$ 167,843
$ 34,353
}
Accrued Interest Receivable
4,725-
$7,973,622
Represents.interest
to be
received at maturity
on FNMA discount notes
CITY Of COLUMBIA NEIGNTS, MINNESOTA 110
ANNUAL FINANCIAL REPORT
SCHEDULE OF INSURANCE IN FORCE
December 31, 1982
Type of Coverage
All Risk Coverage under the Public and
Institutional Property Policy
(90% Coinsurance -$500 Deductible)
40th Avenue Liquor Store
University Avenue Liquor Store
Policy Period Building
from to or Structure Contents
1 -1 -82 12 -31 -82
$ 70,000
80,000
$150,000
(90% Coinsurance -$500 Deductible)
City Hall
$1,385,218
$266,200
Library
516,203
222,541
City Garage
1,381,228
106,480
Liquor Store -40th Avenue
82,873
8,943
Liquor Store - University Avenue
128,058
13,541
Community Center
706,578
36,608
Parks (11)
877,874
2,398
Well House - LaBelle Park
12,575
Band Stand
32,245
Bath House -Siver Lake
42,683
Warming House - Silver Lake
9,680
Lift Stations (3)
63,422
Water Tower
275,275
Pump Stations (2)
73,939
61,171
Warehouse- Cement
39,566
1,463
Warehouse -Metal
9,968
Water Meter Vault
8,745
3,993
Tema House
18,150
$5,664,280
$723,338
($100 Deductible)
Personal property consisting of road construction
equipment, maintenance equipment, and other
equipment stored•.in municipal buildings
($500 Deductible on Police and Fire only)
Personal property consisting of motor vehicles
I CITY OF COLUMBIA NEIONTS, MINNESOTA 1+1
$759,410
$844,908
ANNUAL FINANCIAL REPORT
Table XI
Type of Coverage
Policy
Period
from
to
Boiler explosion
1 -1 -82
12 -31 -82
$100,000 per accident
Workmen's Compensation
1 -1 -82
12 -31 -82
Statutory
Comprehensive Auto Liability
1 -1 -82
12 -31 -82
Bodily Injury
$500,000
Property Damage
$500,000 $250 Deductible
Uninsured Motorists
$ 50,000
Automotive Physical Damage
$ 500 Deductible
$132,890 Fire
Comprehensive Bus Liability
4 -13 -82
4 -13 -83
Bodily Injury
$500/500,000
Property Damage
$500,000
Uninsured Motorists
$25/50,000
Comprehensive General Liability
1 -1 -82
12 -31 -82
Bodily Injury $500,000
Property Damage $500,000
t
Statutory Liquor Legal Liability 1 -1 -82 12 -31 -82 $500,000
Public Official Liability 1 -29 -82 1 -29 -83 $1,000,000
Umbrella Liability 6 -9 -82 6 -9 -83 $3,000,000 $10,000 Retention
-� The comprehensive general liability - includes the following additional coverages:
(a) Personnel injury coverage to include false arrest, libel, slander, wrongful
entry or eviction or invasion of right of privacy (b) Loss of business income
(c) All employees as additional insureds (d) Comprehensive glass and neon sign
breakage (e) Miscellaneous property floater.
r
CITY OF COLUMBIA NEIGNTS, MINNESOTA
112
ANNUAL FINANCIAL REPORT
Table XI
PRINCIPLE CITY OFFICIALS
AND SURETY BONDS
Year Ended December 31, 1982
In addition to the positions listed above where bond amounts appear, the
City has a $25,000 Faithful Performance Blank-Position Bond on all City
employees.
[CITY OF COLUMBIA NEIGNTS, MINNESOTA
113
ANNUAL FINANCIAL REPORT
Amount of
Name
Official Title
Surety Bond
Mayor and Council:
Bruce G. Nawrocki
Mayor
Kenneth E. Hentges
Councilmember
Gayle R. Norberg
Councilmember
Arden Hovland
Councilmember
Rita M. Petkoff
Councilmember
Administration:
Robert S. Bocwinski
City Manager
Linda Magee
Administrative Assistant
William Elrite
City Clerk- Treasurer - Finance Director-
Liquor Operations Manager
$50,000,
Ronald Kalina
City Attorney
Fred Salsbury
Public Works /Director /City Engineer
Karen Meuleners
City Assessor
$50,000
Stuart Anderson
Chief of Police
Donald Johnson
Chief of Fire
LeRoy Goranson
Building Inspector
Martin Gavic
Plumbing Inspector
LeRoy Goranson
Heating Inspector
Donald Weinand
Electrical Inspector
Mitch DeMars
Street Superintendent /Park Superintendent
Donald Jolly
Water and Sewer Superintendent
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 $25,000 Faithful Performance Blank-Position Bond on all City
employees.
[CITY OF COLUMBIA NEIGNTS, MINNESOTA
113
ANNUAL FINANCIAL REPORT
i
n
MISCELLANEOUS STATISTICAL FACTS
1982
Date of Incorporation
Date of Adoption of City Charter
Form of Government
Fiscal Year Begins
Area of City
Miles of Streets and Alleys:
Trunk Highways
County
City Streets
Alleys
Miles of Sewers:
Storm Sewers
Sanitary Sewers
Watermain- Miles
Building Permits:
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
1982
Estimated Cost:
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
1982
CITY Of COLUMBIA NEIGNTS, MINNESOTA
Table XIII
March 14, 1898
July 21, 1921
Council- Manager
January 1
3.52 Square Miles
3.0
6.2
61.7
33.1
59.0
65.7
518
529
485
608
595
658
687
663
555
644
519
$2,180,740
2,032,525
2,916,519
3,148,524
3,412,415
4,701,644
6,996,678
3,31.6,115
3,264,460
8,822,479
13,757,934
114 ANNUAL FINANCIAL REPORT
MISCELLANEOUS STATISTICAL FACTS (Continued)
Fire Protection:
Number of Stations
Number of Employees:
Full time
Volunteer
Police Protection:
Number of Stations
Number of Employees
Parks:
City Parks
Playground
County Park
Schools:
Senior High
Junior High
Elementary
Prochial Elementary
Employees: (as of December 31, 1982)
Regular
Part time
Temporary
Elections:
Registered voters - last city general election
Number of votes cast last city general election
Percentage of registered voters voting
Population:
1900
1920
1930
1940
1950
1960
1965 .(mid- decade census)
1970 (census)
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
1982
CITY OF COLUMBIA NEIGNTS, MINNESOTA 115
Table XIII
1
7
21
1
22
13
11
1
1
1
3
1
91
51
12
154
12,022
3,563
2,964
123
2,968
5,613
6,035
8,175
17,533
23,283
23,997
24,079
24,079
23,503
23,316
22,324
21,890
21,300
21,270
20,029
19,800
19,670
ANNUAL FINANCIAL REPORT