Loading...
HomeMy WebLinkAbout1981 CAFRANNUAL FINANCIAL REPORT COLUMBIA 590 OF THE CITY OF HEIGHTS, MINNESOTA FORTIETH AVENUE 55421 N. E. FOR THE YEAR ENDING DECEMBER 31, 1981 FINANCE DEPARTMENT WILLIAM ELRITE, ACTING FINANCE DIRECTOR MEMBER OF MUNICIPAL FINANCE OFFICERS' ASSOCIATION OF THE UNITED STATES AND CANADA telephone: 788 -9221 (612) ANNUAL FINANCIAL REPORT YEAR ENDED DECEMBER 31, 1g81 CITY COUNCIL Bruce G. Nawrocki, Mayor E. "Sebe" Heintz Councilmember Kenneth E. Hentges Councilmember Walter S. Logacz Councilmember Gayle R. Norberg Councilmember COUNCILMEMBERS ELECT Arden Hovland Rita M. Petkoff CITY MANAGER Robert S. Bocwinski FINANCE DEPARTMENT William Elrite Director CITY OF COLUMBIA NEIGNTS, MINNESOTA ANNUAL FINANCIAL REPORT DEPARTMENTS DIVISIONS e x� �e Regular �� Reserves Regular Volunteers POLICE Reserves Accounting City Clerk Elections Utility Billing FIRE Collections Liquor No. 2 Off Sale No. 3 Off Sale FINANCE Inspections Licenses b Permits ADMINISTRATI Planning SERVICES Assessing Engineering Streets Water Maintenance Sewer Maintenance Parks - Admin. b Maintenance Central Garage PUBLIC WORKS LIBRARY GENERAL GOVERNMENT BUILDINGS LEGAL CiTY OF COLUMBIA NEIGNTS, MINNESOTA CITY MANAGER ADMINISTRATIVE ORGANIZATION CITY OF COLUMBIA HEIGHTS, MINNESOTA MAYOR COUNCIL MEMBERS — 1 . RECREATION b COMMUNITY SERVICES COMMISSION ' RECREATION b COMMUNITY SERVICES ELECTORS) INDEPENDENT SCHOOL DIS- TRICT 113 COMMISSIONS AND BOARDS Planning and Zoning Recreation t Community Services Perk Traffic HRA Library Human Services Police t Fire Civil Service Charter Downtown Development ANNUAL FINANCIAL R --.PORT HE CITX OF��I1COLUMgIA HEIGHTS, MINNESOTA NNU iEARAjNDrED ECEMBEER ADp .51, 1981 TABLE OF CONTENTS I. INTRODUCTORY SECTION Reference Page Number Administrative 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 Form 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 -29 B. Combinin_ and Individual Fund and Account Group Statements and Schedules General Fund Form B 30 -38 Special Revenue Funds Form C 39-47 JHE CIT�IOF COLD IA HEIGHTSa MINNESOTA NN UALL NA�V C OAL KEP RT EAR tNDED DECEMBER 1, 1931 Debt Service FU#hds Capital Projects Funds Special Assessment Funds Enterprise Funds: Combining Balance Sheet Combining Statement of Revenues, Expenses, and Changes in Retained Earnings Combining Statement of Changes in Financial Position Municipal Liquor Fund Water Utility Fund Sewer Utility Fund Internal Service Fund: Central Garage Fund Statement of General Fixed Assets Statement of General Long -term Debt III. STATISTICAL SECTION Assessed Value and Market Value of all Taxable Property Tax Rates City Tax Levy Tax Levies and Tax Collections Special Assessment Collections Revenues - Other than Property Taxes and Special Assessments Expenditures for Selected Functions Form D 48 -51 Form E 52-55 Form F 56-57 Form G 58-59 Form G -1 60 -61 Form G -2 62 -63' Form H 64 -73 Form 1 74 -79 Form J 80 -86 Form K 87 -90 Form L 91 Form M 92 -94 Table I 95-96 Table II 97 Table 111 98 Table IV 99-100 Table V 99-100 Table VI 101 Table VII 101 JH OF COLDMIA HEiraws, MINNESOTA NN'UCAL,� 1 I NA CIAL EP RT EAR 'ED DECEMBER 31, 19$1 Statement of Legal Debt Margin Table VIII 102 Combining Schedule of Bonds Payable Table IX 103-106 Schedule of Investments Table X 107 -108 Schedule of Insurance in Force Table XI i05 -110 Principal City Officials and Surety Bonds Table XII 111 Miscellaneous Statistical Facts Table XIII 112 -113 rN Mr. Robert S. Bocwinski City Manager City of Columbia Heights Dear Mr. Bocwinski: June 30, 1982 The annual financial report of the City of Columbia Heights, Minnesota for the year ended December 31, 1981 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 in Statement 2 of Governmental Accounting , Auditing, and Financial Reporting 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 11 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 III 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 organizational chart of the City. This results in a classification, of transactions according to specific functions, separate and distinct from those pertaining to unrelated activities. 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 Bruce G. Nawrocki, Mayor Gayle R. Norberg, Councilmember Kenneth E. Hentges, Councilmember Rita M. Petkoff, Councilmember Arden Hovland, Councilmember EQUAL OPPORTUNITY EMPLOYER that the exi.istence`of a particular item or appropriation in the approved budget does not automatically mean that it will or must be spent. The budget process has 'flekibi`lIity in that, where need has been adequately demonstrated, an adjustment can,be made within the department budget by the City Manager, or between departments and. funds by the City-Council. Therefore, there is a constant reviewal process and expenditures are not approved untit -it has been determined that (1) adequate funds were app- ropriated, (2) the expenditure 1s 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 1980. CITY FINANCIAL ACTIVITY HIGHLIGHTS DURING 1981 * The payment of $1,009,650 in principal and interest of scheduled bond maturities. * Interest earnings were at a total of $370,501 * General Fund Revenues exceeded expenditures by $29,785 GENERAL FUND On December 31, 1981 the fund balance of the General Fund totaled $1,538,691 of which $258,620 is appropriated for the 1982 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. CITY Of COLUMBIA MEIGNT51. ■INNESOTA. 2 MINUAL i1NANCIAL REPORT Total of Appropriated and General Unappropriated Fund Balance Fund Budget Beginning of Year Amount % of Bud et 1975 2,179,705 2,329,365 107,376 .9 292,898 12.6 1976 1977 2,549,629 591,399 23.2 863,828 29.6 1978 2,917,260 3,078,785 957,562 31.1 1979 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 CITY Of COLUMBIA MEIGNT51. ■INNESOTA. 2 MINUAL i1NANCIAL REPORT Estimated and actual revenues for the current year are presented in Form B -2. Revenues received for general government operations totaled $3,918,702 In 1981, an increase of $408,620 or 11.6% over the previous year. The following table presents an analysis of the major revenue sources of the General Fund for 1981 and its change from 1980. 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 6% per capita. Since enactment, various amendments to the law have been enacted, but the basic principle remained the same. The follow- ing table summarized the City's satus in complying with the law for 1981 and 1980. Levy Limit Base Less: State aids applicable to levy limitations Add: Base Adjustment Levy Limit before special levies Plus: Special levies allowed: Debt Service Other Total allowable levy Total levy certified CITY V COLUNEIA NEICYTS, MINNESOTA 1981 1980 $ 2,520,390 $ 2,304,871 (1,338,072) (1,305,720) 27,400 1,182,318 1,02 ,551 275,000 290,000 946,409 438,140 $ 2,403,727 $ 1,7542691 $ 1,631,608 $ 1,631,608 MNU L FINANCIAL REPORT 1981 Percent Increase (Decrease) Revenue Source Amount of Total from 1980 General Property Taxes $ 906,074 23.1% $ (37,898) Licenses and Permits 104,027 2.7 35,317 Intergovernmental Revenue 1,944,501 49.6 116,461 Charges for Services 417,604 10.7 63,665 Fines and Forfeits 67,301 1.7 (4,973) Miscellaneous Revenue 147,952 3.8 (8,041) Expenditure Reimbursements 60,353 1.5 44,234 Transfers - In 270;890 6.9 199,855 Totals $3,918,702 100.0% $ 408,620 From the above table, it is apparent that the major sources available for funding the general operations is the property tax (23.1 %) and inter- governmental revenue (49.6 %), 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 6% per capita. Since enactment, various amendments to the law have been enacted, but the basic principle remained the same. The follow- ing table summarized the City's satus in complying with the law for 1981 and 1980. Levy Limit Base Less: State aids applicable to levy limitations Add: Base Adjustment Levy Limit before special levies Plus: Special levies allowed: Debt Service Other Total allowable levy Total levy certified CITY V COLUNEIA NEICYTS, MINNESOTA 1981 1980 $ 2,520,390 $ 2,304,871 (1,338,072) (1,305,720) 27,400 1,182,318 1,02 ,551 275,000 290,000 946,409 438,140 $ 2,403,727 $ 1,7542691 $ 1,631,608 $ 1,631,608 MNU L FINANCIAL REPORT 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 1979 through 1981 was as follows: City's taxable value: Personal property Real estate Sub -Total Areawide allocation: Contribution to "pool" Distribution from "pool" Net Increase Combined Value 1981 1980 $ 1,295,504 85,721,087 $ 87,016,591 $ (2,000,000) 4,383,409 $ 2,383,409 $ 1,218,792 73,741,181 $ 74,959,973 $ (1,840,970) 4 o62,894 $ 2,221,92 $ 89;400,000 $ 77,181,897 1979 $ 1,221,501 71,601,406 $ 72,822,907 $ (1,491,381) 3 311,002 $ 1,819,621 $ 74,642,528 Actual taxes received from the fiscal disparities allocation amounted to $118,108 in 1981, $85,771 in 1980, and $70,023 in 1979. 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 1981, revenue earned and interest received totaled $374,091. The fund balance dedicated to construction of state -aid streets, at December 31, 1981 is $264,415. CITY CF COLUMBIA NVONTS, MINNESOTA 4 ANNUAL FINANCIAL KPORT 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, 1981: Fund Balance Revenue Sharing Interest Capital Year Revenue Earnings Total Projects Operations Total 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 1879572 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 135,903 3,951 139,854 195,622 In 1982 it is estimated that the City will receive $161,000 in revenue sharing payments and $8,500 interest earnings. The adopted 1982 budget includes $3,000 for general operations and $177,335 for capital projects, leaving an estimated fund balance of $184,787 as of 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 1981 revenues of $209,039 exceeded expenditures by $9,071 increasing the fund balance to $20,917. 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, 1981, the general fixed assets of the City thus far recorded amount to $8,235,979• 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 system, but depreciation of assets is for rate setting purposes, etc. accounting, in the City's accounting recognized in the propietary funds 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 1982 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 4W 0OLUM6IA NEIGNTS. MINNESOTA MNUAL FINANCIAL WORT ENTERPRISE FUNDS Liquor Operation Total sales were $1,205,801, a decrease from 1980 of $96,055. Total Net operating income was $20,841, a decrease of $39,365 from 1980. During 1981 the on sale store was sold for a gain of $576,975. WATER UTILITY The Water Utility Fund had a 1981 net operating income of $15,828 on a 15.4% increase in revenues compared to a net loss of $13,172 in 1980. The Water Fund transferred $10,000 to Debt Service Funds leaving a net income of $5,828. SEWER UTILITY The Sewer Utility Fund with a 22.9% increase in revenues had a net income of $135,307 in 1981 compared to a net income of $6,961 in 1980. The Sewer Fund transferred $25,000 to Debt Service Funds in 1981 leaving a net income of $110,307. 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 1981, the City assessed $194,654 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 deficit of 59,283 as of December 31, 1.981. 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 transactions except direct investments of bonds of the City purchased by other funds. Interest earnings from these investments are allocated to all funds of the City, except construction accounts and the trust and agency funds, on the basis of the average cash balances during the year. Investment principal at December 31, at book value, is also allocated to the individual funds. The allocation of interest earnings to December 31, includes accrued interest receivable, which results in a cash overdraft in the fund of a like amount. CITY OF COLUMBIA MEIGNTS, MINNESOTA J NINUAL FINANCIAL IMPORT Interest rates were substantially higher in 1981 than in preceding years and the average amount of idle funds increased only slightly in 1984. Interest earnings for the past six 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% The 1981 earnings were distributed to the following funds: General $ 68,622 Revenue Sharing 20,223 Municipal State-Aid Street 12,173 Capital Improvements 42,881 Debt Service 85,533 Liquor 72,323 Water 7,012 Sewer 14,283 Garage 1 558 $327+ 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 Barb Sandberg and Jackie Niccum for their assistance in pre- paring this report. Respectfully submitted, LA) William Elrite Acting Finance Director CITY Of COLUMBIA NEICNTB, MINNESOTA ANNUAL FINANCIAL KPORT HE CITx OFj�VVCOL IA HEIGHTS, MINNESOTA EARINDEDADECEMBERP31, 1931 GENERIL PURPOSE FININCUL STITEMENTS These General Purpose Financial Statements are part of the Comprehensive Annual Financial Reprt, presenting only aggregate data by fund type and account group, together with notes to the financial statements and constitues "fair presentation in con- formity 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 Page Auditors Report 8 Combined Balance Sheet - All Fund Types and Account Groups Forrrr, A 9 -10 Combined Statement of Revenues, Expenditures, and Changes in Fund Balances - All Governmental Fund Types Form A -1 11 -12 Combined Statement of Revenues, Expenditures, and Changes in Fund Balances - Budget and Actual - General and Special Revenue Fund Types Fgrm 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 -29 GMHCo The City Council of Columbia Heights, Minnesota GEORGE M. HANSEN COMPANY. P.A. A Pf*&40W1 COM"don ojCm#kd Pubfir Aerormranu ACCOUNTANTS' REPORT We have examined the combined financial statements of the City of Columbia Heights, Minnesota as of and for the year ended December 31, 1981, 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, 1981 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, except for the changes to the prior period as described in Note 2, on which we concur. 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 pre- sented 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. June 26, 1982 10 175 SOUTH PLAZA BUILDING WAYZATA BOULEVARD AT HIGHWAY 100 MINNEAPOLIS. MMINESOTA 36415 612/546 -2566 Q L ti N d O C C7 O u D S Q H W rd _ F � C • M J L J Y 1 r u W f� W S N W =u J Q m O W Z ID O V 1 V1 u Y wN+ ^ - 1 N d N I\ N n 1 O « w Y N M A0 V d N d In O Y !�',00'S «� > - %oo coo N a q 2 Ih O u u .t I .o {1 V V co NCC H Y •. w Y M 67 N N MIT M0-1� d M M.0 Ln ID ON • M MIA m /D .M. M H% &A /A %D Inds N- %ON- �S I 1 1 1 1 0 1 1 o Ian M O 0 r a n 01f� �O N - 1 1 1 d � m &A m d Ln 1 1 1^ 1^ 1 ch O If% n � 1 1 1 1 • 1 W% N N d N I I I I I N I IT d1-� MO^ 0O Go 0c%0 1 1 • • 1 LA r% Lf% Lr%N %o d in LA M %D a Y c ' _ . �2 N w C u L `Y _ N L N u - 7 C Q« N « C N L 171N Y. Y� N YEC Y 1 0 1 1 s V < 1 1 « c � N L c QO c A c «'� A Y a O q a ° G H L -' OMIT CITY Of COLUMBIA •EIGHTS, MINNESOTA 9 i a+ � L N co Ln uuu C� LON::�M L N d 7 N d EE C N w N c cr O� v L rCC � 1 1 1 � Y«a 2 r L O J 0 J3 t7 N « n 4 •- N Y r Y O• L 0 Y N • I I I I q 9 « 1 1 1 l „ 1 � Y V X Ito Y M U C •� N V V • < Y W Q Nr c 1. Y q O L «emu N�1 oa• « « >o N N Y Y c> 2, N c — In o L K u Y L > O r Y L « Y loin o V c IM - OSIo-Y O M MMUAl FINANCIAL KPORT W N Y 1 1 1 1 1 1 O O w 1 N L O d L L « L W 4r IL N N 1 V1 u Y wN+ ^ - 1 N d N I\ N n 1 O « w Y N M A0 V d N d In O Y !�',00'S «� > - %oo coo N a q 2 Ih O u u .t I .o {1 V V co NCC H Y •. w Y M 67 N N MIT M0-1� d M M.0 Ln ID ON • M MIA m /D .M. M H% &A /A %D Inds N- %ON- �S I 1 1 1 1 0 1 1 o Ian M O 0 r a n 01f� �O N - 1 1 1 d � m &A m d Ln 1 1 1^ 1^ 1 ch O If% n � 1 1 1 1 • 1 W% N N d N I I I I I N I IT d1-� MO^ 0O Go 0c%0 1 1 • • 1 LA r% Lf% Lr%N %o d in LA O I�dt7O dtD 01 MO�MN IA100�0�0O1d M N�INO tT N w ppNNN M%D/V 1 MOY�If� d /D �p Mp O N I, N M N d %a M cc /D �O M- O It�O Mn� O . w N 9!9 co to d d O% O U.% O a% a% In N N O aD M a pcc 1'�': I: N ID IA�M0� ^O�p cc N QI It M /V d N v /y � � O 1 1 1 1 1 1 1 1 1 1 1- N S m • O 94 O^w W%ft 94r fmoN us p� N I I I I� N M /D IA ID 01 • 1 1 O *O N %O Om n N MN N 1 1 1 1 1 1 1^ M 1 �0 1 IOA N d In �G d V r N m W d to 01 N 1.� a% `p I M I f4 I ci 2 6 0 Ch O 1 M N M Ln M "N a V W N M %D a Y c ' C A q > Y q q u> « u L `Y _ N L N u - 7 C Q« N « C N L 171N Y. Y� N YEC Y 1 1~N N 1 1 q 0 Y Y Q v c C u u 0 L L < 1 1 V M A 1p t R � « « Y 3 Nv_ O L c QO c A c «'� A Y a O q a ° G c u {.i Lj C CITY Of COLUMBIA •EIGHTS, MINNESOTA 9 O I�dt7O dtD 01 MO�MN IA100�0�0O1d M N�INO tT N w ppNNN M%D/V 1 MOY�If� d /D �p Mp O N I, N M N d %a M cc /D �O M- O It�O Mn� O . w N 9!9 co to d d O% O U.% O a% a% In N N O aD M a pcc 1'�': I: N ID IA�M0� ^O�p cc N QI It M /V d N v /y � � O 1 1 1 1 1 1 1 1 1 1 1- N S m • O 94 O^w W%ft 94r fmoN us p� N I I I I� N M /D IA ID 01 • 1 1 O *O N %O Om n N MN N 1 1 1 1 1 1 1^ M 1 �0 1 IOA N d In �G d V r N m W d to 01 N 1.� a% `p I M I f4 I ci 2 6 0 Ch O 1 M N M Ln M "N a V W N %D N O g V �+ _ N 7 C 1 a: 1 1 1 1 1 1 1 1 1 N � Y L c u O a+ M L Y 7 N L w N c cr O� v Y«a r �Cgt ` L9 r 1«0° v+ 0 J3 n = >�1= uq�iCLu� n 4 •- N Y r Y O• L 0 Y • I I I I I I i l l l l 1 � c = c Q Y M N V V • q Nr c 1. Y q O L «emu N�1 oa• « « >o �o V c q q IT E w L U g q« c> 2, N Y C 7«« Iq. L K u Y 7 o u - « c c Y d H IM - OSIo-Y O a MMUAl FINANCIAL KPORT 1 1 1 1 1 1 1 1 1 1 0 1 N O N M 1 1 1 1 1 1 1 1 1 1 1 1 M n N n O N %D N O V �+ _ N 7 C 1►. Y E Y L c u a+ L Y 7 N L w c cr O� v Y«a r �Cgt ` L9 r 1«0° v+ 0 J3 >� = >�1= uq�iCLu� n 4 •- N Y r Y O• L 0 Y L. Y �e _i+ Q >u YY �Y Y7 4 u L c = c Q Y M N V V • q Nr c 1. Y q O L «emu N�1 oa• « « >o r V c q q IT E w L U g q« c> 2, V O U w Y C 7«« Iq. L K u Y 7 o u - « c c Y H IM - OSIo-Y O MMUAl FINANCIAL KPORT Y N « qq A W a Y aj V 41 N W p C Y Y CCCE 1 L Y ^ L YI _« C N cm W .J E^ oc t Y t Y C � _« L O 0 A C ~ Y Y 04, We J m CL.! U 0 Y U 9 '« p Y 'aC A C Q N N ^.X Y+ «« O 1p:1. M 7 QCy � M O O L .- L f Y � >> C J N V 9 O O p M O O E Y t0 L L OI N Y C 4 Y Y ^A�0 0c4-0 dd3 66 Z0 19'a N '02 W« Y A eIU«)J.cS Y Y Y NY Sc i 'Gp 0A.1 — W U A J � W CITY NF COLUMBIA NEICNTSI MINNESOTA 10 « Q W 9 C 7 W A 10- a W O Q N W m Q J Q O f' Y L A N « C qi « /E1 C « A Y « « N N N � N C « w O Y « « A a M ^ A w V C C ANNUAL FINANCIAL KPORT m %O d �O to$ N 1 �Od � �Mp1aNf\O tAQOi�"Iwr.Ai000�G O MStC �CcD^Lo% *A m IANONN tO M ^ID d� � C E "No O ��Ov 1+1� ^ M 1�+1 N p ? ^ N r� ^ OD Up L. sal— l^ 0� O ^ 1 ;O\ ^N ON 0 N (/ �� ^ M N^ N �O N N N iP- O\��O 0100 O ^ O IA �O M Ot w N N O ^ O) M^ 1 MI^ N?f\ �• IoA M N CYN ON W% M �D N N O 01 Q ii co M^ fir" ^ N O OD N O �C tD 0% d cm Z U L w►ao•� € o o _ N p O VI c 1 1 1 1 1 1 1 O OCOtd g S g o, 6 o o Om O J cc 'D « N N A r p L {) Y 1 t 1 1 1 1 1 1 1 1 1 1 Q\ 1 1 1 1 01 ..� U Y X N N Q W Q N N N N cc 0; _C «C O Y � � � S ^ � o ` ON P� IMn m LIN C d I I l l l t l l d d l l 1 a C N N ^ O� N ^ 99 W N i.7 N L M N ON O co N N N N = w MA %D cc N O O Y L CL %D 1 1^ M I I I N c I N 1 1 1 M QL L to ^ N N ^ O Go ON co Y Q 01 d W N N cm A. T M A N N N 01 V1 01 V% co O O u1 d CO F- L Y v u« Y N • 1 t d 'N 1 N iD I 1 1 1 0 E yC ON Z Y to Q E N N N {Oy p 170 cri c 1 O F Y6 W V Lai Vt 4 u f 1 1 t� 1 1 d u « c Y 2 O Y E N ^ Q> N O N Ar Co O O A 7 M O d d O M MO\ N M W Z /a c U Y 1 1 1 I i l l 1 1 1 1 N M O m 6> ^ d ^ N N N n N O Vt N N N V w N S _ N _ ^ � eo f\ Ot N 0 M O %0 c �0 O V I I f 1 1 1 1 1 1 t v M ? co 01 lA 00 M N V, 1A N %0 N %0 N N ^ N Y N « qq A W a Y aj V 41 N W p C Y Y CCCE 1 L Y ^ L YI _« C N cm W .J E^ oc t Y t Y C � _« L O 0 A C ~ Y Y 04, We J m CL.! U 0 Y U 9 '« p Y 'aC A C Q N N ^.X Y+ «« O 1p:1. M 7 QCy � M O O L .- L f Y � >> C J N V 9 O O p M O O E Y t0 L L OI N Y C 4 Y Y ^A�0 0c4-0 dd3 66 Z0 19'a N '02 W« Y A eIU«)J.cS Y Y Y NY Sc i 'Gp 0A.1 — W U A J � W CITY NF COLUMBIA NEICNTSI MINNESOTA 10 « Q W 9 C 7 W A 10- a W O Q N W m Q J Q O f' Y L A N « C qi « /E1 C « A Y « « N N N � N C « w O Y « « A a M ^ A w V C C ANNUAL FINANCIAL KPORT m COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES - ALL GOVERNMENTAL FUND TYPES Year Ended December 31, 1981 The notes to the financial statement are an integral part of this statement CITY OF COLUMBIA NEIGNTS, MINNESOTA �� ANNUAL FINANCIAL REPORT Special General Revenue REVENUES: General property taxes $ 906,074 $ - Homestead credit 461,243 - Special assessments - - Licenses and permits 104,027 - Fines and forfeitures 67,301 - Interest and rents 120,641 32,396 Intergovernmental revenues 1,483,258 628,021 Charges for services 417,604 39,901. Other revenue 87,664 173 Total Revenues 3,647,812 700,491 OTHER FINANCING SOURCES: Bond proceeds - - Transfers from other funds 270,890 93,933 Total Revenues and Other Sources 3,918,702 794,424 EXPENDITURES: Current: General government 538,618 33,898 Public safety 1,380,692 - Public works 576,754 - Sanitation 336,997 - Library 188,440 - Parks and recreation 652,611 198,392 Other 120,872 - Capital outlay - 481,183 Debt service: Principal retirement - - Interest and fiscal charges - - Total Expenditures 3,794,984 713,473 OTHER USES: Transfers to other funds: 93,933 - Total Expenditures and Other Uses 31,19—,917 713777-3 EXCESS OF REVENUES AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES 29,785 80,951 FUND BALANCE AT BEGINNING OF YEAR 1,508,906 148,877 FUND BALANCE AT END OF YEAR $1,538,691 $ 229,828 The notes to the financial statement are an integral part of this statement CITY OF COLUMBIA NEIGNTS, MINNESOTA �� ANNUAL FINANCIAL REPORT Debt Service $ 276,737 79,910 81,998 429,731 868,376 35,000 903,376 7 Capital Projects 675,975 150,488 275 826,738 826,738 Form A -1 Total Special (Memorandum Only) Assessment 1981 1980 194,654 55,068 54,716 21.888 326,326 412,489 738,815 - - 55,000 5,511,132 1,012,569 320,000 689,650 1,009,650 1,009, 650 (106,274) 1,035,023 S 928,749 5,511,132 270,890 5,7 2,022 (4,955,284) 6,579,460 ,$1,624,176 1,067,569 1,0 7,569 (328,754) 334,529 S 5,775 CITY OF COLUMBIA NEIGNTS, MINNESOTA $ 1,182,811 541,153,> 194,654 104,027 67,301 966,078 2,316,483 457,505 '539,731 6,369,743 812,312 7,182,055 572,516 1,380,692 576,754 336,997 188,440 851,003 175,872 7,004,884 320,000 689,650 12,096,808 364,823 12,461 31 (5,279,576) 9,606,795 $ 4,327,219 $ 1,146,688 481,335 418,838 68,710 72,274 511,832 1,876,318 379,888 70,237 5,026,120 8,086,239 211,933 13,324,292 552,476 1,277,400 555,918 268,793 161,085 603,102 101,897 369,083 285,000 79,963 4,254,717 1,790,972 6-,07 55 689 7,278,603 2,751,696 $10?030,299 1 V ANNUAL FINANCIAL KPORT COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL - GENERAL AND SPECIAL REVENUE FUND TYPES Year Ended December 31, 1981 .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 270,890 270,89o, - 3,691,135 3,918,702 227,567 557,997 538,618 GENERAL FUND 1,391,031 1,380,692 10,339 591,308 576,754 Variance 340,446 Budget Actual Over (Under) REVENUES: 5,173 656,490 652,611 General property taxes $ 898,365 $ 906,074 $ 7,709 Homestead credit 461,243 461,243 - Licenses and permits 76,045 104,027 27,982 Fines and forfeitures 41,200 67,301 26,101 Interest and rents 50,625 120,641 70,016 Intergovernmental revenue 1,480,977 1,483,258 2,281 Charges for services 399,590 4179604 18,014 Other revenue 12,200 87 664 75,464 Total Revenues _ 3,720,245 - 3,647,812 227,567 .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 270,890 270,89o, - 3,691,135 3,918,702 227,567 557,997 538,618 19,379 1,391,031 1,380,692 10,339 591,308 576,754 14,554 340,446 336,997 3,449 193,613 188,440 5,173 656,490 652,611 3,879 152,070 120,872 31,198 3,882,955 3,794,984 87,971 OTHER USES: Transfers to other funds Total Expenditures and 95,210 Other Uses 3,978,165 93 933 3, ,917 1,277 89,248 EXCESS OF REVENUES AND OTHER SOURCES (UNDER) EXPENDITURES AND OTHER USES (287,030) 29,785 FUND BALANCE AT BEGINNING OF YEAR 1,508,906 1,508,906 FUND BALANCE AT END OF YEAR $1,221,876 $1,538,691 The notes to the financial statement are an integral part of this statement CITY OF COLUMBIA NEI6NTS, MINNESOTA 1� 316,815 $ 316,815 ANNUAL FINANCIAL KPORT SPECIAL REVENUE FUNDS Variance Budget Actual Over (Under) Form A -2 Total (Memorandum Only) Variance Budget Actual Over (Under) $ - $ - $ - $ 898,365 $ 906,074 $ 7,709 - - - 461,243 461,243 - - - - 76,045 104,027 27,982 - - - 41,200 67,301 26,101 5,000 32,396 27,396 55,625 153,037 97,412 443,504 628,021 184,517 1,924,481 2,111,279 186,798 40,035 39,901 (134) 439,625 457,505 17,880 - 173 173 12,200 87,837 75,637 488,539 700,491 211,952 3,908,784 4,348,303 439,519 97,210 93,933 (31277) 368,100 364,823 (3,277) 585,749 794,424 208,675 4,276,884 4,713,126 436,242 110,014 33,898 76,116 668,011 572,516 95,495 - - - 1,391,031 1,380,692 10,339 - - - 591,308 576,754 14,554 - - - 340,446 336,997 3,449 - - - 193,613 188,440 5,173 212;640 198,392 14,248 869,130 851,003 18,127 - - - 152,070 120,872 31,198 538,445 61 ,099 481,183 57,262 147,629 538,445 4,7+4,05 481,183 4,508,457 57,262 713,473 235,597 61 -' 14 7-, 95,210 39,2 93,933 -+,�2 390 1 277 236.874 713,473 ,099 (275,350) 80,951 356,301 148,877 148,877 - $ (126,473) $ 229,828 $ 356,301 CITY Of COLUMBIA NEIGNTS MINNESOTA 14 (562,380) 110,736 673,116 1,657,783 1,657,783 - $1,095,403 $1,768,519 $ 673,116 ANNUAL FINANCIAL KPORT COMBINED STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - ALL PROPRIETARY FUND TYPES Year Ended December 31, 1981 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 RETAINED EARNINGS (DEFICIT) AT BEGINNING OF YEAR RETAINED EARNINGS (DEFICIT) AT END OF YEAR CITY OF COLUMBIA NEIGNTS, MINNESOTA 15 Enterprise $ 2,647,507 852,135 •1,795,372 508,905 172,360 49,323 818,179 1,548,767 246,605 108,249 138,356 93,977 (1,851) 594,406 686,532 824,888 (61,000) 299,004 $ 1,062,892 ANNUAL FINANCIAL KPORT Form A -3 I CITY OF COLUMBIA NEIGNTS, MINNESOTA J 16 ONNUAL FINANCIAL REPORT Total Internal (Memorandum Only) Service 1981 1980 $ 127,393 $ 2,774,900 $ 2,603,70 - 852,135 868,704 127,393 1,922,765 1,735,004 76,512 585,417 630,124 24,184 196,544 191,167 13,274 62,597 63,794 - 818,179 683,048 113,970 1,662,737 1,568,133 13,423 260,028 166,871 4,892 113,141 04,538 8,531 146,887 52,333 1,558 95,535 59,188 - (1,851) (8,418) 1,004 595,410 3,742 2,562 689,094 54,512 11,093 835,981 106,845 26,000 26,000 - - (61,000) (45,000) (20,376) 278,628 216,783 $ 16,717 $ 1,079,609 $ 278,628 I CITY OF COLUMBIA NEIGNTS, MINNESOTA J 16 ONNUAL FINANCIAL REPORT COMBINED STATEMENT OF CHANGES IN FINANCIAL POSITION ALL PROPRIETARY FUND TYPES Year Ended December 31, 1981 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 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 MEICMTS, MINNESOTA 17 Enterprise $ 789,888 108,249 (576,975) 651,611 972,773 10,165 1,502 984,440 21,621 14,300 10,165 26,000 72,086 912,354 (7,111) 999,000 39,620 (5,544) (120,782) (2,750) 7,604 2,317 $ 912,354 ANNUAL FINANCIAL REPORT Form A -4 Total Internal (Memorandum Only) Service 1981 1980 $ 11,093 $ 800,981 $ 106,845 4,892 113,141 114,538 - (576,975) - 651 611 _ - 15,9 5 988,758 221,383 - 10,165 9,774 - 1,502 1,323 26,000 26,000 - 41,985 1,026,425 232,480 1,403 23,024 13,168 - 14,300 11,550 - 10,165 9,774 - 26,000 45,000 1,403 73,489 79,492 40,582 952,936 152,988 (141) (7,252) (16,250) 33,000 11032,000 88,000 150 39,770 64,324 5,292 (252) 34,191 2,281 (118,501) (30,395) - (2,750) 50,900 - 7,604 (37,782) 4 0 2 2 317 $ 952,93 $ -1-52--9T8- COLUMBIA E16NTS MINNESOTA ANNUAL FINANCIAL REPORT CITY OF COLD N t 8 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS DECEMBER 31, Note 1 - Summary of Significant Accounting Policies The City operates under a Home Rule-Charter which prescribes the council - manager form of government. The following services are provided: public safety, highways and streets, sanitation, health and social services, culture - recreation, public improvements, planning and zoning, and general administra- tive services. The accounting policies of the city conform to generally accepted accounting prin- ciples 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 Projects 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. CITY OF COLUMBIA NEIGNTS, MINNESOTA 19 ANNUAL FINANCIAL REPORT CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1981 Note 1 - Summary of Significant Accounting Policies (Continued) A. Fund Accounting (Continued) PROPRIETARY FUNDS Enterprise Funds - Enterprise Funds are used to account for operations (a) that are financed and operated in a manner similar to private business enterprises - where the intent of the governing body is that the costs (expenses, including depreciation) of providing goods or services to the general public on a continuing basis be financed or recovered primarily through user charges; or (b) where the governing body has decided that periodic determination of revenues earned, ex- penses incurred, and /or net income is appropriate for capital mainten- ance, public policy, management control, accountability, or other purposes. Internal Service Funds - Internal Service Funds are used to account for the financing of goods or services provided by one department or agency to 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 spendable resources." Governmental fund operating statements present increases and decreases in net current assets. Accordingly, they are said to present a summary of sources and uses of "available spendable resources" during a period. Fixed assets used in governmental fund types operations (general fixed assets) are accounted for in the General Fixed Assets Account Group, rather than in governmental funds. Public domain general fixed assets consisting of certain improvements other than buildings, including roads, bridges, curbs and gutters, streets and sidewalks, drainage systems, and lighting systems, are not capitalized along with other general fixed assets, No depreciation has been provided on general fixed assets. 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. 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. CITY OF COLUMBIA NEIGNTS, MINNESOTA 20 RNNUAL FINANCIAL REPORT CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1981 Note 1 - Summary of Significant Accounting Policies (Continued) B. Measurement Focus (Continued) 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 maintanance" measurement focus. This means that all assets and all liabilities associated with their activity are included on their balance sheets. Their reported fund equity is segregated into contributed capital and retained earnings components. Proprietary fund type operat- ing statements present increases (revenues) and decreases (expenses) in net total assets, Depreciation of all exhaustible fixed assets used by proprietary funds is charged as an expense against their operations. Accumulated depreciation is reported on proprietary fund balance sheets. Depreciation has been provided over the estimated useful lives using the straight line method. The estimated useful lives are as follows: Buildings 40 -50 years Mains and lines 50 -100 years Structures 5 -20 years Equipment 5 -20 years 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, regardless 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: (1) accmulated unpaid vacation, sick pay, and other employee amounts which are not accrued; and.(2) 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 expenses are recognized when they are incurred. Unbilled utility service receivables are recorded at year end. CITY OF COLUMBIA NEIGNTS, MINNESOTA 21 RNNUAL FINANCIAL REPORT CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 19 1 Note 1 - Summary of Significant Accounting Policies (Continued) D. Budgets and Budgetary Accounting The City follows these procedures in establishing the budgetary data reflected in the financial statements: I. Prior to January 1, the budget is adopted by the City Council, 2. Formal budgetary integration is employed as a management control device during the year for the General Fund and Special Revenue Funds. Formal budgetary integration is not employed for other funds. 3. Budgets for the General and Special Revenue are adopted on a basis consistent with generally accepted accounting principles (GAAP). 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. E. Encumbrances Encumbrance accounting, under which purchase orders, contracts, and other commitments for the expenditure of monies.are recorded in order to reserve that poriton 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 constitue expenditures or liabilities. F. Investments Investments are stated at cost or amortized cost, which approximates market. G. Advance to Other Funds Noncurrent portions of long -term interfund loans receivable are equally offset by a fund balance reserve account which indicates that they do not constitute "available spendable resources" since they are not a component of net current assets. Current portions of long -term interfund loans receivable are considered "available spendable resources." CITY OF COLUMBIA NEIGNTS, MINNESOTA 1 22 ANNUAL FINANCIAL REPORT CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1981 Note 1 - Summary of Significant Accounting Policies (Continued) H. 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 accumulated liability for unpaid vacation benefits at December 31, 1981 was approximately $100,750. City employees are entitled to sick leave at the rate of eight (a) 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 earned, approximately $380,500 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 1/4 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, 1/2 of the excess sick leave earned shall be granted as additional vacation leave at the end of each year. These liabilities are stated at the 1981 rate of pay and are not recorded as liabilities in the individual fund balance sheets. I. Comparative Data Comparative data for the prior year have been presented to provide an under- standing of changes in the City's financial position and operation. Certain 1980 amounts have been reclassified to conform to the 1981 presentation. J. Total Columns on Combined Statements - Overview 1. Total columns on the Combined Statements - Overview are captioned Memo- randum Only to indicate that they are presented only to facilitate finan- cial 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 is such data comparable to a consolidation. Interfund eliminations have not been made in the aggregation of this data. K. Property Taxes Allowances are provided for the full amount of delinquent taxes receivable. This has the effect of recognizing property tax revenues at the time property taxes are collected. L. Inventories Inventories of the proprietary funds are stated at the lower of FIFO cost (first-in, first -out) or replacement market. CITY OF COLUMBIA NEIGNTS, MINNESOTA 23 ANNUAL FINANCIAL WORT CITY OF COLUMBIA HEIGHTS MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) . DECEMBER 31, 1981 Note 2 - Prior Period Adjustment The fund balance at December 31., 1980 for the special revenue funds (Municipal State Aid Fund) has been restated to reflect a change in accounting policy. Prior to 1981 the city recorded revenue from the State of Minnesota at the time of the State allotment, irregardless as to when the allotment was earned. Effective January 1,1981 the city is recording the revenue when earned: accordingly the following adjustment was made to the December 31, 1980 fund balance: Fund balance, before adjustment $ 406,406 Adjustment to remove unearned receivable (423,504) Fund balance (deficit), restated (171098) Note 2 - Proprietary Funds Contract Receivable and Deferred Receivable A. Interceptor Acquisition Contract Receivable As of January 1, 1971, the Metropolitan Waste Control Commission (MWCC) assumed ownership of all existing interceptors and treatment works Under the terms of the agreement with the MWCC, the City is to'be reimbursed for the value at the time of transfer of such facilities. The contract represents the value of the facilities acquired by the MWCC, and was determined to be $400,533 at the date of takeover by the MWCC. This amount is being amortized through credits received against annual sewer service billings from the MWCC over a thirty-year period with interest at 49. Prior to 1981 the City received credits against MWCC billings totaling $222,720, of which $97,850 was treated as a reduction of principal. During 1981 the City received a credit of $22,272, of which $10,165 was a re- duction of principal. As of December 31, 1981, a balance of $292,518 remained to be collected over the next.nineteen years. B. Deferred Receivable The City was required to advance funds to the MWCC for deferments of reserve capacity costs granted to other communities. The balance of this receivable from the MWCC at December 31, 1981 was $31,128 and is collectible over the next nine years. During 1981, the City received $2,390 related to this receivable, of which $1,502 represented a reduction of principal. CITY OF COLUMBIA NEIGHTS, MINNESOTA 24 ANNUAL FINANCIAL REPORT CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1981 Note 3 - Changes in General Fixed Assets Changes in the General Fixed Assets Group of Accounts during 1981 were as follows: Adjustments Balance and Balance Jan 1, 1981 Additions Retirements Dec. 31, 1981 Land $ 4,765,293 $ 653,716 $ 1,624,039 $ 3,794,970 Buildings and structures 2,863,730 8,899 - 2,872,629 Furniture, Fixtures and $ 7,125 $ 45,223 $ office equipment 624,807 5,640 5,630 624,817 Machinery and equipment 903,578 47,917 7,932 943,563 Total $ 9,157,408 $ 716,172 $ 1L637,601 $ 8,235,979 Note 4 - Proprietary Fund TyRes Property and Equipment A summary of the enterprise funds property and equipment at December 31, 1981 follows: 3.50-4.60% Water Sewer 8,175 Land Liquor utility Utilit Total $ 7,125 $ 45,223 $ $ X8,934 Buildings 70,260 210,987 24,308 305,555 Improvements other than buildings 19,665 2,162,205 2,318,139 4,500,009 Office furniture and equipment 22,841 22,841 Machinery and equipment 10,029 109,311 177,818 297,158 $ 29,920 $2,527,726 $2,556,851 $5,214,497 Less accumulated depreciation 60,471 $C9, 799 974,351 $1,553,375 1,070,907 2 105 729 _$1,485,944 $3,108,768 A summary of the internal service funds property and equipment at December 31, 1981 follows: Central Ga�ra e� Office furniture and equipment $ 741 Machinery and equipment 65,315 $ 66,056 Less accumulated depreciation 44,660 $ 21,396 Note 5 - Long -Term Debt The long term debt obligations outstanding at year -end are summarized as follows (in thousands of dollars): Bonds Maturities General bonds 1982-1984 Tax Increment bonds 1983 -2002 Special Assessment bonds 1982 -1982 CITY OF COLUMBIA NEIGNTS, MINNESOTA 25 Interest December 31, Rates 1981 3.50-4.60% 725 8.00 -8.75% 8,175 4.20 -4.30% 5 _T_905 MNUAL FINANCIAL REPORT CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1981 Note 5 - Long Term Debt (Continued) Changes in bonds payable during 1981 are summarized as follows ( in thousands of dollars) : Annual Requirements to Amortize Long -Term Debt Including Interest of $9,407,798 December 31, 1981 (in thousands of dollars) Year ending Balance Tax Special Balance December 31 Jan 1, 1980 Issued Retired December 31, 1980 General bonds 1,747 320 725 Tax increment bonds 8,175 683 8,175 Special assessment 55 50 5 Total 9,275 - 370 671 Annual Requirements to Amortize Long -Term Debt Including Interest of $9,407,798 December 31, 1981 (in thousands of dollars) Year ending General Tax Special December 31 obligation Increment assessment Total 1992 369 X73 �— 5 1 ,0 7 1983 260 683 943 1984 145 682 827 1985 671 671 1986 806 806 1987 -91 4,559 4,559 1992 -96 5,061 5,061 1997 -01 4,295 4,295 2002 104 104 77 5 18,313 $928,749 is available in the Debt Service Funds to service the general obligation and tax increment bonds. There are a number of limitations and restrictions contained in the various bond indentures. The City is in compliance with all significant limitations and restrictions. Note 6 - 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 Minn. Stat. 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 Association was split into two divisions - paid and volunteers as of January 1, 1978• CITY OF COLUMBIA NEIGNTS, MINNESOTA 26 ANNUAL FINANCIAL KPORT CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 19 1 Note 6 - Retirement Plans (Continued) The City levies annually and applies state aid for pension contributions to the associations. In 1981 the amounts were: Levy State -Aid Total Police Relief (7) $ 82,135 $ 1+x,+40 $ 123,575 Fire Relief - Paid (5) 52,134 30,172 82,306 Fire Relief - Volunteer (18) 7 004 - 7,004 $ 11,273 71, 12 em212 5 The pension levy meets the minimum requirements o ePolice and Rremen 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, and 1978 levy payable in 1979 includes an amount for the amortization of the unfunded pension liability by the year 2005. In prior years, as allowed by State law, contributions did not provide for the amort- ization of the unfunded liability. The following schedule of accrued liabilities was obtained from the latest acturial surveys dated December 31, 1980: The City participates in a contributory pension plan under the Public Employees Retirement Association (PERA), Minn. Stat. Chapter 353, which covers substan- tially all employees except those qualifying as temporary or seasonal employees or those public safety police and fire personnel covered by the relief assoc- iations. 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 (employee share 4 %). For the basic 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 $155,781 for the year ended December 31, 1981. 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 percent of gross wages by all employers 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 1981 or total of $ 69,759. CITY OF COLUMBIA NEIGNTS, MINNESOTA �7 ANNUAL FINANCIAL REPORT Funded (Unfunded) Funded Accrued Accrued Reserves Police Relief $1, nT3UZ7 Fire Relief -Paid 591,009 Liab�ility $2,743-,918 1,695,319 Liability $ 1,735, 1 1,104,310 Fire Relief - Volunteer 430,542 276,840 153,702 The City participates in a contributory pension plan under the Public Employees Retirement Association (PERA), Minn. Stat. Chapter 353, which covers substan- tially all employees except those qualifying as temporary or seasonal employees or those public safety police and fire personnel covered by the relief assoc- iations. 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 (employee share 4 %). For the basic 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 $155,781 for the year ended December 31, 1981. 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 percent of gross wages by all employers 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 1981 or total of $ 69,759. CITY OF COLUMBIA NEIGNTS, MINNESOTA �7 ANNUAL FINANCIAL REPORT CITY OF COLUMBIA HEIGHTS NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1981 Note 7 - Interfund Receivable and Payable Balances General Fund Special revenue funds Municipal State Aid Fund Debt service funds Storm Sewer Bonds of 1965 Special assessment funds Permanent Improvement Revolving Fund Enterprise funds Water Utility Fund Receivable Payable 595,000 $ 30,454 29,700 30,454 595,000 29,700 $ 655,154 $655,154 Note 8 - Segment Information - Enterprise Funds The City maintains three enterprise funds. Segment information for the year ended December 31, 1981 is as follows: Sales, less cost of sales of $852,135 Operating revenue Depreciation Operating income Operating transfers out Gain on disposal of assets Net income Current capital transfers out Property and equipment Additions Deletions Net working capital Total assets Long term liabilities payable from operating revenues Total equity (deficit) Contributed Retained earnings CITY Of COLUMBIA BEIGNTS, MINNESOTA 15,400 15,400 1,867,534 1,891,128 3,758,662 1,283,614 '(9o,463) (130,259) 1,062,892 M ANNUAL FINANCIAL KPORT Water Sewer Liquor utility utility Total $ 353,666 $ $ $ 353,666 708,400 733,306 1,441,706 7,714 43,470 57,065 108,249 20,841 10,040 107,475 138,356 10,000 25,000 35,000 576,975 576,975 673,753 15,828 135,307 824,888 23,000 38,000 61,000 3,665 3,302 14,654 21,621 202,924 202,924 1,214,165 - 239,,096 243;797- 1,697,,058 1,330,347 1,847,250 2,175,429 5,353,026 15,400 15,400 1,867,534 1,891,128 3,758,662 1,283,614 '(9o,463) (130,259) 1,062,892 M ANNUAL FINANCIAL KPORT CITY OF COLUMBIA HEIGHTS MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1981 Note 9 - Reserved Fund Equity The following reservations of fund equity have been made as of December 31, 1981: General Fund Loan to Permanent Improvement Revolving Fund $ 595,000 Capital projects funds - Sullivan Lake .Fund Improvement costs 31,644 Debt service funds Debt service 928,749 Special assessment funds Improvements costs 44,874 Internal service funds - Central Garage Improvement costs 26,000 $ 1,626,267 Note 10 - 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, and Comprehensive Employment Training Act. These programs are ;subject to program compliance audits by the grantors or their representatives. The audits of these programs for or including the year ended December 31, 1981 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 det- ermined at this time although the City expects such amounts, if any, to be immaterial. Note 11 — Claims and Litigation The City had the usual and customary types of miscellaneous claims pending at year -end, mostly of a minor nature and usually all covered by insurance carried for that purpose. CITY OF COLUMBIA NEIGNTS, MINNESOTA �9 ANNUAL FINANCIAL REPORT HE CITX OF COLUM IA HEIGHTS] MINNESOTA NNUA TINAECIAL KEPORT EAR LNDED ECEMBER 311 190011 GENERIL 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 30 Statement of Revenues, Expenditures and Changes in Fund Balance Form B -1 31 -32 Schedule of Revenues - Budget and Actual Form B -2, 33 -34 Schedule of Expenditures - Budget and Actual Form B -3 35 -38 Form B GENERAL FUND COMPARATIVE BALANCE SHEET December 31, 1981 and 1980 LIABILITIES, AND FUND BALANCE Liabilities: Accounts payable $ 32,979 $ 29,657 Accrued salaries and witholdings 46,264 68,478 Deposits 5,083 583 Due to other governmental units - 1,814 Deferred revenue - 5,896 Total Liabilities $ 84,326 $ 106,428 Fund Balance: Reserved for loan to Permanent Improvement Revolving fund $ 595,000 $ 330,000 Unreserved Designated for subsequent year's expenditures 258,620 287,030 Undesignated 685,071 891,876 Total 1981 1980 ASSETS $1,538,691 $1,508,906 Cash: Total Liabilities, Treasurer's balance $ 921 $ 6,210 Imprest cash and change funds 1,075 1,075 Total Cash $ 1,99 7,285 Investments, at cost 349,000 11,110,955 Taxes receivable -- delinquent 29,510 35,134 Less: Allowance for uncollectible taxes (29,510) (35,134) Accounts receivable: Unbilled services 63,057 54,570 Accrued interest receivable 45,893 67,495 Other 15,104 18,547 Due from other funds 595,000 347,100 Due from other governmental units 552,967 9,382 Total Assets $1,623,017 $1,615,334 LIABILITIES, AND FUND BALANCE Liabilities: Accounts payable $ 32,979 $ 29,657 Accrued salaries and witholdings 46,264 68,478 Deposits 5,083 583 Due to other governmental units - 1,814 Deferred revenue - 5,896 Total Liabilities $ 84,326 $ 106,428 Fund Balance: Reserved for loan to Permanent Improvement Revolving fund $ 595,000 $ 330,000 Unreserved Designated for subsequent year's expenditures 258,620 287,030 Undesignated 685,071 891,876 Total Fund Balance -- Form B -1 $1,538,691 $1,508,906 Total Liabilities, and Fund Balance $1,623,017 $1,615,334 CITY OF COLUMBIA NEIGRTS, MINNESOTA L 30 ONNUAL FINANCIAL REPORT Form B -1 GENERAL FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE Year Ended December 31, 1981 With Comparative Actual Amounts for Year Ended December 31, 1980 1981 1980 Variance Favorable Budget Actual (Unfavorable) Actual Revenues: Taxes $ 898,365 $ 906,074 $ 7,709 $ 943,972 Licenses and permits 76,045 104,027 27,982 68,710 Fines and forefeitures 41,200 67,301 26,101 72,274 Intergovernmental revenues 1,942,220 1,944,501 2,281 1,828,040 Charges for current services 399,590 417,604 18,014 353,939 Miscellaneous 62,825 208,305 145,480 172,112 Total Revenues S3,420,245 $3,647,812 $ 227,567 $ 3,439,047 Other Financing Sources: Transfers from other funds 270,890 270,890 - 71,035 Total Revenues and Other Sources $3,691,135 $3,918,702 $ 227,567 $ 3,510,082 Expenditures: General government $ 557,997 $ 538,618 $ 19,379 $ 488,715 Public safety 1,391,031 1,380,692 10,339 1,277,400 Public works 591,308 576,754 14,554 555,918 Sanitation 340,446 336,997 3,449 268,793 Library 193,613 188,440 5,173 161,085 Parks 656,490 652,611 3,879 424,375 Other 152,070 120,872 31,198 42,227 Total Expenditures $3,882,955 $3,794,984 $ 87,971 $ 3,218,513 Other Financing Uses: Transfers to other funds 95,210 93,933 1,277 Total Expenditures and Other Uses $3,978,165 $3,888,917 $ 89,248 Excess of revenues and other sources over (under) expenditures and other uses Fund balance at beginning of year Fund balance at end of year $ (287,030) $ 29,785 $ 316,815 1,508,906 1,508,906 - $1,221,876 $1,538L691 $ 316,815 .CITY OF COLUMBIA NEIGNTS, MINNESOTA 31 94,689 $ 3,313,202 $ 196,880 1,312,026 $ 1,508,906 ANNUAL FINANCIAL REPORT Form B -2 GENERAL FUND SCHEDULE OF REVENUES - BUDGET AND ACTUAL (CONTINUED) Year Ended December 31, 1981 CITY OF COLUMBIA NEIGNTS MINNESOTA 32 #NNUAL FINANCIAL REPORT Variance Budget Actual Favorable Revenue Revenue (Unfavorable) Other revenue: Sale of land $ - $ 5,386 $ 5,386 Gain sale equipment 500 3,547 3,047 Miscellaneous 4,200 18,378 14,178 Total $ 4,700 $ 27,311 $ 22,611 Charges for current services: General government $ 2,700 $ 2,005 $ (695) Public safety 26,240 26,317 77 Public works 4,400 4,378 (22) Library 2,350 3,853 1,503 Parks 24,700 31,915 7,215 Refuse collection 339,200 348,054 8,854 Other - 1,082 1,082 Total $ 399,590 $ 417,604 $ 18,014 Refunds and reimbursements: Construction labor reimbursement $ 5,000 $ 15,001 $ 10,001 Equipment rental reimbursement 2,500 9,372 6,872 Other reimbursements - 35,980 35,980 Total $ 7,500 $ 60,353 $ 52,853 Total Revenue $3,420 ;245 $3;647,812 $ 227,567 Other Sources: Transfers from other funds Sullivan Lake Fund $ 270,890 $ 270,890 $ - Grand Total $3,69x,135 $3,918,702 $ 227,567 CITY OF COLUMBIA NEIGNTS MINNESOTA 32 #NNUAL FINANCIAL REPORT GENERAL FUND SCHEDULE OF REVENUES - BUDGET AND ACTUAL Year Ended December 31, 1981 Budget Actual Revenue Revenue General property taxes: Fund B -2 Variance Favorable (Unfavorable) Current ad valorem $ 895,365 $ 873,151 $ (22,214) Delinquent ad valorem Shared state taxes: - 27:838 Local government aid 27,838 Penalties and interest - 3,000. 461,243 5,085 - 2,085 Total $ 898,365 $ 906,074 $ 7,709 Licenses and permits: 6,500 5,742 (758) State grant -- shade tree aid 10,000 14,105 Business regulatory licenses $ 22,845 $ 42,333 $ 19,488 Non - business licenses and permits 53,200 6,020 61,694 (6,020) 8,494 Total $ 76,045 $ 104,027 $ 27,982 Fines and forfeitures: $1,942,220 $1,944,501 2,281 Court fines $ 40,000 $ 65,677 $ 25,677 Other 1,200 1,624 424 Total $ 41,200 $ 67,301 $ 26,101 Revenue from use of money and property: Interest earnings -- Investment Trust Fund $ 30,000 $ \-99,861 $ 69,861 Rents 20,625 20,780 155 Total $ 50,625 $ 120,641 $ 70,016 Revenue from other agencies: Shared state taxes: Local government aid $1,338,072 $1,338,072 $ - Property tax relief (Homestead) 461,243 461,243 - Insurance premium tax 68,265 71,613 3,348 Municipal state aid - maintenance 15,000 15,375 375 Attached machinery aid 6,500 5,742 (758) State grant -- shade tree aid 10,000 14,105 4,105 Other 33,120 33,094 (26) Anoka county: Street maintenance 6,020 - (6,020) Federal aid: Civil defense reimbursement 4,000 5,257 1,257 Total $1,942,220 $1,944,501 2,281 CITY OF COLUMBIA HEIGHTS, MINNESOTA V MNUAL FINANCIAL REPORT 33 - GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL Year Ended December 31, 1981 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 Supplies Total Assessing: Personal services Other services and charges Supplies Total Legal: Other Services and charges CITY OF COLUMBIA NEIGNTS, MINNESOTA Form B -3 1981 Unencumbered Budget (Overexpended) (Revised) Expenditures Balance $ 47,685 56,840 1,250 105,775 $ 73,605 14,875 500 88,986 $ 71,580 35,487 2,225 $ 109,292 $ 8,330 2,775 1,600 12,705 $ 65,820 1,975 600 68,395 $ 62,750 i J 34 $ 47,128 55,182 784 103,09 $ 72,939 13,700 93 $ $ 70,586 32,302 2,145 $ 105,0331 $ 8,225 2,452 1 2560 12,237 $ 65,475 1,571 134 $ 67 ,180 i $ 57,961 $ 557 1,658 466 2,69-1 $ 666 1,175 407 $ 2,248 $ 994 3,185 8o $ 4,259 $ 105 323 $ 4o $ 345 4o4 466 $ 1,215 $ 4,789 #NNUAL FINANCIAL KPORT GENERAL FUND SCHEDULE OF EXPENDITURES (CONTINUED) BUDGET AND ACTUAL Year Ended December 31, 1981 GENERAL GOVERNMENT (continued): Planning: Personal services Other services and charges Supplies Total General Government Buildings: Personal services Other services and charges Supplies Total Total General Government PUBLIC SAFETY: Police Protection: Personal services Other services and charges Supplies Total Fire Protection: Personal services Other services and charges Supplies Total Protective Inspection: Personal services Other services and charges Supplies Total Civil Defense: Personal services Other services and charges Supplies Total Animal Control: Other services and charges Total Public Safety CITY OF COLUMBIA NEIGNTS, MINNESOTA r- Form B-3 1981 Unencumbered Budget (Overexpended) (Revised) Expenditures Balance $ 33,180 2,005 665 35,856 $ 10,320 55,630 8,300 $ 7 ,250 $ 557,997 $ 789,725 42,425 35,541 867,691 $ 356,015 35,285 16,220 07,520 $ 63,615 18,890 1,730 $ $-235- $ 15,785 8,050 750 $ 24,585 $ 7,000 $1,391,031 I/ 35 $ 32,987 $ 193 1,986 19 630 35 35 , 03 247 $ 10,874 $ (554) 49,884 5,746 10,020 (t 720) $ 70,778 3,472 $ 538,618 $ 19,379 $ 789,628 $ 97 41,968 457 33,099 2,442 $ F41695 $ 2,996 $ 366,682 $ (10,677) 26,913 8,372 13,188 3,032 $+06,793 $ 727 $ 68,015 $ (4,400) 12,134 6,756 1,247 483 $ 1,39 $ 2, 39 $ 15,475 $ 310 6,174 1,876 523 227 22,172 2, 13 $ 5,636 $ 1,364 $1,380,692 $ 10,339 ANNUAL FINANCIAL REPORT GENERAL FUND SCHEDULE OF EXPENDITURES (CONTINUED) BUDGET AND ACTUAL Year Ended December 31, 1981 PUBLIC WORKS: Engineering Personal services Other services and charges Supplies Total Street Maintenance: Personal services Other services and charges Supplies Total Street Lighting: Personal services Other services and charges Total Traffic Signs and Signals: Personal services Other services and charges Supplies Total Tree Trimming and Removal: Personal services Other services and charges Supplies Total Total Public Works SANITATION: Refuse Collection and Disposal: Personal services Other services and charges Supplies Total .CITY OF COLUMBIA NEIGNTS, MINNESOTA Form B -3 1981 Unencumbered Budget (Overexpended) (Revised) Expenditures Balance $ 131,306 $ 133,652 $ (2,346) 13,505 7,884 5,621 5,155 4,402 753 $ 19,966 145,938 ,02 $ 160,658 $ 156,797 $ 3,861 63,130 60,605 2,525 45,900 45,310 590 269,688 262,712 $ 97� $ 500 $ 477 $ 23 57,244 56,669 575 57,744. $ 57,1 $ 598 $ 11,500 $ 16;385 $ (4,885) 10,540 10,992 (452) 10,925 5,334 _ 5,591 $ 32,965 $ 32,711 $ 254 $ 21,495 $ 19,725 $ 1,770 59,200 58,381 819 250 141 109 T-TO-, 5 $ 7� ,247 $ 2,698 $ 591,308 $ 576,754 $ 14,554 $ 10,501 $ 7,389 $ 3,112 327,315 327,458 (143) 150 55 95 337,9 $ 33 ,902 $ 3,064 V 36 ANNUAL FINANCIAL REPORT Form B -3 GENERAL FUND SCHEDULE OF EXPENDITURES (CONTINUED) BUDGET AND ACTUAL Year Ended December 31, 1981 1981 nencum ere Budget (Overexpended) (Revised) Expenditures Balance SANITATION (continued): Weed Control Personal services $ 2,400 $ 2,015 $ 385 Other services and charges 80 80 - Total $ 2, 80 $ 2,095 $ 3 5 Total Sanitation $ 340,446 $ 336,997 $ 3,449 LIBRARY: Personal services $ 119,593 $ 115,921 $ 3,672 Other services and charges 24,070 23,110 960 Supplies 49,950 49,409 541 Total $ 193,613 -T -188,44b $ 5,173 MUNICIPAL PARKS: Administration and Maintenance: Personal services $ 252,655 $ 239,917 $ 12,738 Other services and charges 91,720 109,512 (17,792) Supplies 39,175 35,880 3,295 Capital outlay 239,890 239,879 11 Total -$-6-23-,-WO- $ 62.5,188 $ 1,748) Skating Rinks: Personal services $ 18,300 $ 14,844 $ 3,456 Other services and charges 12,250 11,710 540 Supplies- 2,500 869 1,631 Total _ 33,_050 _ _ 27,423 $ 5,627 Total Municipal Parks $ 656,490 $ 652,611 $ 3,879 CITY OF COLUMBIA MEICNTS, MINNESOTA V 37- MNUAL FINANCIAL REPORT Form B -3 GENERAL FUND SCHEDULE OF EXPENDITURES (:CONTINUED) BUDGET AND ACTUAL Year Ended December 31, 1981 1981 Unencumbered Budget (Overexpended) (Revised) Expenditures Balance UNALLOCATED EXPENSE: Insurance $ 21,870 $ 10,502. $ 11,368 Taxes and licenses 1,300 932 368 Cable TV expense 11,000 10,805 195 Vandalism 1,000 - 1,000 Other miscellaneous 116,900 981-633 18,267 Total Unallocated $ 152,070 $ 120,872 $ 31,198 Total Expenditures $ 3,882,955 $ 3,794,984 $ 872971 Other Uses: TRANSFERS TO OTHER FUNDS Recreation $ 85,000 $ 87,000 $ (2,000) PARA Transit Fund 10,210 6;933 3,277 Total Transfers $ 95,210 $ 93,933 $ 1,277 Grand Total $ 3,978,165 $ 3,888,917 $ 89,248 [CITY OF COLUMBIA NEIGNTS, MINNESOTA 38 — MNUAL FINANCIAL KPORT HE CITX OF COLUM IA HEIGHTS, MINNESOTA NNUA TINA BECEMBER CIAL KEPORT . EAR MED 31, 1081 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 the Municipal State -Aid System. TABLE OF CONTENTS Page Combining Balance Sheet Form C 39 -40 Combining Statement of Revenues, Expenditures and Changes in Fund Balances Form C -1 41 -42 Statements of Revenues, Expenditures and Changes in Fund Balance: Revenue Sharing Fund Form C -2 43 Recreation and Community Services Fund Form C -3 44 Paratransit Fund Form C -4 45 Municipal State -Aid Street Fund Form C -5 46 C.E.T.A. Fund Form C -6 47 SPECIAL REVENUE FUNDS COMBINING BALANCE SHEET December 31, 1981 With Comparative Totals for December 31, 1980 Recreation Revenue Community Sharing Services ASSETS Cash: Treasurer's balance (deficit) $ 2,052 $ 4,106 Impre_st cash - 50 Total Cash $ 2,052 $ 4,156 Investments, at cost 166,000 20,000 Accounts receivable - - Due from other governmental units: Due from Federal - Revenue Sharing 37,736 - Due from State of Minnesota - - Due from Anoka County - - Total Assets $ 205,788 $ 24,156 LIABILITIES, AND FUND BALANCE Liabilities: Accounts payable $ 10 166 $ 823 Accrued salaries payable - 2,187 Accrued social security /P.E.R.A. payable - 229 Due to Other Funds - - Total Liabilities $ 10,166 $ 3,239 Fund Balance Unreserved: Designated for subsequent year's expenditures $ 19,335 - Undesignated 176,287 20,917 Total Fund Balance $ 195,622 $ 20,917 Total Liabilities, and Fund Balance $ 205,788 $ 24,156 CITY OF COLUMBIA NEIGHTS, MINNESOTA 39 #NNUAL FINANCIAL KPORT Paratransit $ (4,129) ,129) 4,176 $ 47 $ 47 47 $ 47 Form C Municipal Totals State Aid 1981 1980 $ (6,589) $ (4,560) $ (3,816) $- (6,58-9) $--(4,510) $ 3,750) - 186,000 132,000 - 543 - 37,736 41,073 50,332 54,508 428,539 - _ 3,146 $ 43,743 $ 273,734 $ 601,535 30,454 $ 30,454 13,289 $ 13,289 $ 43,743 I.CITY OF COLUMBIA NEIGNTS, MINNESOTA $ 11,036. $ 9,158 2,187 1,919 229 617 30,454 17,000 $ 43,906 $ 29,154 $ 19,335 $ 5,505 210,493 566,876 $ 229,828 $ 572,381 $ 273,734 $ 601,535 40 #NNUAL FINANCIAL REPORT SPECIAL REVENUE FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE Year Ended December 31, 1981 With Comparative Totals for Year Ended December 31, 1980 Revenues: Revenue from other agencies: Federal State of Minnesota Independent School District #13 Interest earnings Fees Other revenue Total Revenues Other Financing Sources: Transfers from other funds Total Revenues and Other Sources Expenditures: $ 181,353 87,000 $ 209,039 6,933 $ 25,847 Public safety Recreation 35,739 Revenue Community $ Sharing Services Paratransit $ 160,957 $ - $ - - - 14,052 - 87,000 - 20,223 - - - 35,039 4,862 173 - - $ 181,353 $ 122,039 $ 18,914 $ 181,353 87,000 $ 209,039 6,933 $ 25,847 Public safety $ 35,739 $ - $ - Parks - - - Street and engineering 36,730 - - .Library 40,543 - - Recreation - 199,968 - Downtown development - - - State -aid construction - - - Parking lot 22,891 - - Para transit - - 25,853 C.E.T.A. - - - Miscellaneous 3,951 - - Total Expenditures $ 139,854 $ 199,968 $ 25,853 Excess of Revenues and Other Sources over (under) Expenditures $ 41,499 $ 9,071 $ (6) Fund balance at beginning of year, before adjustment $ 154,123 $ 11,846 $ 6 Adjustment to remove receivable from state for unearned State Aid Fund balance beginning of year, restated $ 154,123 $ 11,846 $ 6 Fund balance end of year $ 195,622 $ 20,917 $ - CITY OF COLUMBIA NEIGNTS, MINNESOTA 41 ANNUAL FINANCIAL REPORT Form C -1 CITY OF COLUMBIA NEIGHTS, MINNESOTA '� 41NNUAL FINANCIAL REPORT 42 Muni clpaI State Totals Aid C.E.T.A. 1981 19 0 $ - $ 4,094 $ 165,051 $ 171,810 361,918 - 375,970 201,379 - 87,000 70,890 12,173 - 32,396 13,477 - 39,901 25,949 - 173 62 $ 374,091 $ 4,094 $ 700,491 $ 483,567 - - 93,933 77,115 $ 374,091 $ 4,094 $ 794,424 $ 560,682 $ $ $ 35,739 $ 38,426 - - 12,732 - 36,730 1,764 ' - 40,543 2,716 - 199,968 180,274 343,704 - - - 343,704 24,174 2,055 - - 22,891 55,071 - 25,853 22,725 ' 4,094 4,094 11,679 ' - 3,951 5,183 $ 343,704 $ 4,094 $ 713,473 $ 356,799 $ 30,387 $ - $ 80,951 $ 203,883 $ 406,406 $ - $ 572,381 $ 368,498 (423,504). - (423,504) - $ (17,098) $ - $ 148,877 $ 368,498 $ 13,289 $ - $ 229,828 $ 572,381 CITY OF COLUMBIA NEIGHTS, MINNESOTA '� 41NNUAL FINANCIAL REPORT 42 Form C -2 REVENUE SHARING FUND STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE Year Ended December 31, 1981 With Comparative Actual Amounts for Year Ended December 31, 1980 1981 Variance Favorable 1980 Budget Actual (Unfavorable) Actual Revenues: Revenue from other agencies: Federal Revenue Sharing $152,000 $160,957 $ 8,957 $ 160,131 Revenue from use of money and property: Interest earnings - Investment Trust Fund 5,000 20,223 15,223 12,810 Other revenue - 173 -173 62 Total Revenue $157,000 $181,353 $ 24,353 $ 173,003 Expenditures: $ 38,426 - Capital outlay: 63,025 1,764 Public safety $ 47,280 $ 35,739 Parks - - Street.and engineering 99,755 36,730 Library 23,850 40,543 Voss parking lot - 22,891 Professional services: Downtown development - - Other general government 70,300 3,951 Total.Expenditures $241,185 $139,854 Excess of Revenues over (under) Expenditures $(84,185) $ 41,499 Fund balance at beginning of year 154,123 154,123 Fund balance at end of year $ 69,938 $195,622 Form C CITY OF COLUMBIA NEIGHTS MINNESOTA 43 $ 11,541 $ 38,426 - 12,732 63,025 1,764 (16,693) 2,716 (22,891) 55,071 - 24,174 66,349 5,183 $ 101,331 $ 140,066 $ 125,684 $ 32,937 121,186 $ 1251684 $ 154,123 ANNUAL FINANCIAL REPORT Form C -3 RECREATION AND COMMUNITY SERVICES FUND STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE Year Ended December 31, 1981 With Comparative Actual Amounts for Year Ended December 31, 1980 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: P1 d aygroun - - Athletic supplies - - Beach program 6,050 5,686 Traveling teams 10,000 10,541 Total Expenditures $214,540 $199,968 Excess of Revenues and Other Sources over (under) Expenditures $ (5,505) $ 9,071 Fund balance at beginning of year Fund balance at end of year .CITY OF COLUMBIA NEI6NTS, MINNESOTA 2,192 3,313 364 5,999 .(541) 5,545 $ 14,572 $ 180,274 $ 14,576 $ (16,709) 11,846 11,846 - 28,555 $ 6,341 $ 20,917 $ 14,576 $ 11,846 Form'C 44 . MNUAL FINANCIAL REPORT 1981 Variance Favorable 1980 Budget Actual (Unfavorable) Actual $ 87,000 $ 87,000 $ - $ 70,890 35,035 35,039 4 21,785 $122,035 $122,039 $ 4 $ 92,675 87,000 87,000 - 70,890 $209,035 $209,039 $ 4 $ 163,565 $163,920 $153,394 $ 10,526 $ 146,033 22,335 19,424 2,911 12,996 10,335 9,347 988 2,649 1,900 1,576 324 1,547 aygroun - - Athletic supplies - - Beach program 6,050 5,686 Traveling teams 10,000 10,541 Total Expenditures $214,540 $199,968 Excess of Revenues and Other Sources over (under) Expenditures $ (5,505) $ 9,071 Fund balance at beginning of year Fund balance at end of year .CITY OF COLUMBIA NEI6NTS, MINNESOTA 2,192 3,313 364 5,999 .(541) 5,545 $ 14,572 $ 180,274 $ 14,576 $ (16,709) 11,846 11,846 - 28,555 $ 6,341 $ 20,917 $ 14,576 $ 11,846 Form'C 44 . MNUAL FINANCIAL REPORT Form C -4 PARATRANSIT FUND STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE Year Ended December 31, 1981 With Comparative Actual Amounts for Year Ended December 31, 1980 1981 Variance Favorable 1980 Budget Actual (Unfavorable) Actual Revenues: Revenue from other agencies State grant Paratransit fares Total Revenues Other Financing Sources: Transfer from General Fund Total Revenues and Other Sources Expenditures: $ 20,410 $ 14,052 $ (6,358) $ 12,337 5,000 4,862 (138) 4,164 $ 25,410 $ 18,914 $ (6,496) $ 16,501 10,210 6,933 (3,277) 6,225 $ 35,620 $ 25,847 $ (9,773) $ 22,726 Personal services $ 5,100 $ 4,412 $ 688 $ 1,145 Other services and charges 30,520 21,441 9,079 21,580 Total Expenditures $ 35,620 $ 25,853 $ 9,767 $ 22,725 Excess of Revenues and Other Sources over (under) Expenditures $ - $ (6) $ (6) $ 1 Fund balance at beginning of year 6 6 - 5 Fund balance at end of year $ 6 $ - $ (6) $ 6 Form C CITY or. COLUMBIA NEIGNTS, MINNESOTA j 45 . ANNUAL FINANCIAL REPORT Form C -5 MUNICIPAL STATE -AID STREET FUND STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE Year Ended December 31, 1981 With Comparative Actual Amounts for Year Ended December 31, 1980 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 1981 Variance Favorable 1980 Budget Actual (Unfavorable) Actual $ 180,000 $ 361,918 $ 181,918 $ - 12,173 12,173 667 $ 180,000 $ 374,091 $ 194,091 $ 667 $ 130 $ 1,664 $ (1,534) $ 2,055 365,530 342,040 23,490 - $ 365,660 $ 343,704 $ 211956 $ 2,055 Excess of Revenues over (under) Expenditures and Other Uses $(185,660) $ 30,387 $ 216,047 $ (1,388) Fund balance at beginning of year before adjusted Adjustment for restatement Restated beginning fund balance Fund balance at end of year 406,406 406,406 - 218,752 (423,504) (423,504) (234,462) (17,098) - (15,710) $ 220,746 $ 13,289 $(207,457 ) (17,098) 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 MEI6NTS, MINNESOTA 46 &NNUAL FINANCIAL KPORT s m Form C-6 C.E.T.A. FUND STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE Year Ended December 31, 1981 With Comparative Actual Amounts for Year Ended December 31, 1980 1981 1980 Revenues: Federal grant $ 4,094 ' $ 11,679 Expenditures: Personal services 4,094 11,595 Other services and charges - 84 Total Expenditures $ 4,094 $ 11,679 Excess of Revenues over (under) Expenditures $ - $ - Fund balance at beginning of year - - Fund balance at end of year $ - $ - t CITY OF COLUMBIA NEIGHTS MINNESOTA `U/ , 47 #NNUAL FINANCIAL REPORT HE CITX OF COLUMBIA HEIGHTS, MINNESOTA NNUAj TINABCIAL KEPORT EAR tNDED ECEMBER 31, 1981 DEBT SERVICE FUNDS 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 48 -49 Combining Statement of Revenues, Expenditures and Changes in Fund Balances Form D -1 50 -51 DEBT SERVICE FUNDS COMBINING BALANCE SHEET December 31, 1981 With Comparative Totals for December 31, 1980 ASSETS Cash: Treasurer's balance Deposited with paying agent Investments, at cost Taxes receivable'delinquent Less: Allowance for uncollectible taxes Due from other governmental units Due from other funds Total Assets LIABILITY AND FUND BALANCE Liability: Matured bonds and interest payable Fund Balance- reserved for debt service -- Form D -1 Total Liability and Fund Balance I -CITY OF COLUMBIA NEIGNTS, MINNESOTA /i 48- Storm Sewer Bonds of 1965 $ 7,093 ,103,413 133,000 152 (152) 29,700 $ 273,206 $ 103,413 169,793 $ 273,206 RNNUAL FINANCIAL REPORT City Garage Bonds of 1972 $ 2,705 52,340 63,000 41 (41) $ 1113,045 $ 52,340 65,705 $ 118j045 ...- - Capital Tax Improvement Increment Bonds of Bonds of 1976 1980 $ 491 $ 865 - 10,942 213,000 476,000 110 - (110) - - 2,895 $ 213j491 $ 490,702 $ - $ 10,942 213,491 479,760 $ 213,491 $ 490,702 CITY OF COLUMBIA NEIQHTS, MINNESOTA 49 Form D 'Tota 1 s 1981 19 0 $ 11,154 $ 8,943 166,695 117,225 885,000 1,011,000 303 1,059 (303) (1,059) 2,895 - 29,700 41,250 $ 1,095,444 $ 1,178,418 $ 166,695 $ 143,395 928,749 1,035,023 $ 1,095,444 $ 1,1781418 ANNUAL FINANCIAL REPORT DEBT SERVICE FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES Year Ended December 31, 1981 With Comparative Totals for Year Ended December 31, 1980 Storm Sewer Bonds of 1965 Revenues: General property taxes: Collected by county Current ad valorem $ 59,520 Delinquent ad valorem 1,400 Revenue from other sources: Property tax relief (Homestead) 21,225 Sale of land Interest earnings: Investment Trust Fund 16,653 Inter -fund loans 1,851 Total Revenues $ 100,649 Other Financing Sources: Bond proceeds - Transfers from: Water Utility Fund - Sewer Utility Fund 15,000 Total Revenues and Other Sources $ 115,649 Expenditures: Bonds matured $ 95,000 Interest on bonds 16,825' Fiscal agent charges 77 Total Expenditures $ 111,902 Excess of Revenues and Other Sources over (under) Expenditures and Other $ 3,747 Fund balance at beginning of year 166,046 Fund balance at end of year $ 169,793 J. CITY OF %COLUMBIA NEIGHTS, MINNESOTA 50 ANNUAL FINANCIAL KPORT Form D -1 Capital City Garage Improvement Tax Increment Bonds Bonds of Bonds of Totals 1972 1976 1980 19 1 19 0 $ 18,175 $ 122,034 $ 71,988 $ 271,717 $ 199,440 402 3,218 - 5,020 3,276 6,482 43,519 8,684 79,910 85,534 429,731 429,731 9,284 22,431 31,779 80,147 50,917 - - - 1,851 7,698 $ 34,343 $ 191,202 $ 542,182 $ 868,376 $ 346,865 - - - - 563,000 .10,000 - - 10,000 15,000 10,000 - - 25,000 30,000 $ 54;343 $ 191,202 $ 542,182 $ 903,376 $ 954,865 $ 50,000 $ 175,000 $ - $ 320,000. $ 285,000 4,680 20,602 646,780 688,8871 53,357 87 109 490 763 350 $ 54,767 $ 195,711 $ 647,270 $1,009,650 $ 338,707 $ (424) $ (4,509) $ (105,088) $ (106,274) $ 616,158 66,129 218,000 584,848 1,035,023. 418,865 $ 65,705 $ 213,491 $ 479,760 $ 928,749 $1,035,023 CITY OF COLUMBIA NEIGNTS, MINNESOTA 51 MNUAL FINANCIAL REPORT HE CIT�INABCIAL OF COLUM IA HEIGHTS, MINNESOTA NNUAj KEPORT EAR LNDED ECEMBER Sl, 1981 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 Page Combining Balance Sheet Form E 52 -53 Combining Statement of Revenues, Expenditures and Changes in Fund Balances Form E -1 54 -55 CAPITAL PROJECTS'FUNDS COMBINING BALANCE SHEET December 31, 1981 With Comparative Totals for December 31, 1980 ASSETS Cash: Treasurers 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 NEI6NTS, MINNESOTA 2 Capital Improvement Fund 308 $ 895 57,000 $ 57,895 57,895 $ 57,895 it c-7 Qor ANNUAL FINANCIAL KPORT Fo rm E Sullivan Downtown Land Lake Acquisition Totals Fund 807 Fund 312 19 1 19 0 $ 764 $ 22,065 $ 23,724 $ 157,948 4,571 1,470,506 1,532,077 6,371,844 17,488 17,488 49,848 97,585 - 97,585 - $102,920 $ 1,510,059 $ 1;670,874 $6,579,640 $ - $ $ - $ l8o 46,698 - 46,698 - $ 46,698 $ - $ 46,698 $ 180 $ 31,644 $ - $ 31,644 $ - 24,578 1,510,059 1,534,637 6,374,758 - 57,895 204,702 $ 56,222 $1,510,059 $_ 1,624,176 $ 6,579,460 $102,920 $1,510,059 $ 1,670,874 $ 6,579,640 I CITY OF COLUMBIA NEIGNTS, MINNESOTA 53 ANNUAL FINANCIAL REPORT CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES Year Ended December 31, 1981 With Comparative Totals for year ended December 31, 1980 Revenues: 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 CITY OF COLUMBIA NEIGNTS, MINNESOTA T J 54 Capital Improvement Fund 308 $ 6,168 $ 6,168 $, 6,168 $ 6,168 51,727 $ 57,895 ANNUAL FINANCIAL REPORT Sullivan Downtown Land Lake Acquisition Fund 807 Fund 312 $ 36,713 $ 633,094 150,488 - 275 - $ 187,476 $ 633,094 $ 187,476 $ 633,094 $ 284,229 $ - - 5,226,903 $ 284,229 $5,226,903 Totals 19 1 19 0 $ 675,975 $ 286,768 150,488 - 275 - $ 826,738 $ 286,768 7,497,069 - 1,209 $ 826,738 $7,785,046 $ 284,229 $ 40,140 5,226,903 1,644,982 $5,511,132 $1,685,122 270,890 - 270,890 =72,244 $ 555,119 $5,226,903 $5,782,022 $1,757,366 $ (.367,643) $(4,593,809) $(4,955,284) $6,027,680 423,865 6,103,868 6,579,460 551,780 $ 56,222 $1,510,059 $1,624,176 $6,579,460 [.CITY OF COLUMBIA NEIGNTS, MINNESOTA Forte__ '" #NNUAL FINANCIAL REPORT 55 JHI CITX OF COLUM IA HEIGHTS, MINNESOTA N NUA rINA�1 CIAL KEPQRT EAR LNDED LECEMBER Sl, SPECIAL 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 Page Combining Balance Sheet Form F 56 Combining Statement of Revenues, Expenditures and Changes in Fund Balances Form F -1 57 Form F SPECIAL ASSESSMENT FUNDS COMBINING BALANCE SHEET December 31, 1981 With Comparative Totals for December 31, 1980 Permanent Permanent Improvement Improvement Revolving Revolving Totals Fund Bond Fund 1981 199-0 ASSETS Cash: Treasurer's balance (deficit) Deposited with paying agent Investments, at cost Accounts receivable Taxes receivable deferred Special assessments receivable: Delinquent Deferred Due from other funds 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 Total Liabilities Fund Balance: Reserved for encumbrances Unreserved- Undesignated Total Fund Balance Total Liabilities and Fund Balance CITY OF COLUMBIA HEIGHTS, MINNESOTA $ 1,853 $ 5,458 $ 7,311 $(25,237) - 51,158 51,158 52,182 - - - 45,000 16,499 16,499 - - 5,500 5,500 60,500 111,314 - 111,314 87,161 509,998 - 509,998 602,047 30,454 - 30,454 - $ 670,118 $ 62,116 $732,234 $821,653 $ 967 $ - $ 967 $ - 683 - 683 - - 21.5 215 - 64,925 - 64,925 .38,901 8,511 - 8,511 8,511 - 5,000 5,000 55,000 - 51,158 51,158 52,182 595,000 - 595,000 330,000 56 - $ 670,086 $ 56,373 $726,459 $484,594 $ 44,874 $ - $ 44,874 $ 12,464 (44,842) 5,743 (39,099) 324,595 $ 32 $ 5,743 $ 5,775 $337,059 $ 670,118 $ 62,116 $732,234 $821,653 ANNUAL FINANCIAL REPORT SPECIAL ASSESSMENT FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES Year Ended December 31, 1981 With Comparative Totals for Year Ended December 31, 1980 Revenues: Increase in assessments Interest and penalties on special assessments Administration charges to projects Miscellaneous Total Revenues Form F -1 Permanent Permanent Improvement Improvement Revolving Revolving Totals Fund Bond Fund 1981 1980 $ 194,654 $ - $ 194,654 $ 418,838 55,068 - 55,068 36,959 54,716 - 54,716 16,737 16,499 5,389 21,888 (2,661) $ 320,937 $ 5,389 $/'326,3-2-6-/$ 469,873 Other Financing Sources: Transfers from: Permanent Improvement Revolving Fund Sewer Utility Fund 5,114 State Aid Fund 342,040 General Fund 65,335 Total Revenues and other Sources Expenditures: Capital project expenditures: Construction contracts Other project costs Administration costs Fiscal agent charges Total Expenditures Other Financing Uses: Transfer to Permanent Improvement Revolving Bond Fund Deferred tax levies (1981) cancelled Adjust assessments Total Expenditures and Other Uses 5,100 5,100 55,500 5,114 - 342,040 - 65,335 17,574 $ 7331426 _$ 10,489 $ 743,915 $ 542,947 $ 740,273 $ - $ 740,273 $ 99,359 198,418 - 198,418 61,009 73,792 - 73,792 33,321 - 86 86 86 $1,012,483 $ 86 $1,012,569 $ 193,775 5,100 - 5,100 55-,500 - 55,000 55,000 57,100 2,570 $1,017,583 $ 55,086 $1,072,669 "08,945 Excess of Revenues and Other Sources over (under) Expenditures and Other Uses $ (284,157) $ (44,597) $ (328,754) $ 234,002 Fund balance at beginning of year Fund balance at end of year -- Form F CITY OF COLUMBIA NEIGHTS, MINNESOTA 284,189 50,340 334,529 100,527 $ 32 $ 5,743 $ 5,775 $ 334,529 (5 � MNUAL FFRAWCIAL REPORT HE CITx OF COLUM IA HEIGHTS, MINNESOTA NN UA tINA�VCIAL KEPQRT EAR INDED DECEMBER 31, 1931 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. TABLE OF CONTENTS Paqe Combining Balance Sheet Form G 58 -59 Combining Statement of Revenues, Expenses, and 60 -61 Changes in Retained Earnings Form G -1 Combining Statement of Changes in Financial 62 -63 Position Form G -2 Municipal Liquor Fund: Form 1 74 Balance Sheet in Retained Earnings Form H 64 Statement of Revenues, Expenses and Changes Form 1 -2 76 in Retained Earnings in Financial Position Form H -1 65 -66 Statement of Changes in Financial Position Form H -2 67 Schedule of Revenues - Off Sale Form H -3 68 -69 Schedule of Operating Expenses Form H -4 70-71 Schedule of Property, Equipment and Accumulated Form J 80 Depreciation in Retained Earnings ,Form H -5 72 -73 Water Utility Fund: Balance Sheet Form 1 74 Statement of Changes in Retained Earnings Form 1 -1 75 Statement of Revenues and Expenses Form 1 -2 76 Statement of Changes in Financial Position Form 1 -3 77 Schedule of Property, Equipment and Accumulated Depreciation Form 1 -4 73 -79 Sewer Utility Fund: Balance Sheet Form J 80 Statement of Changes in Retained Earnings Form J -1 81 Statement of Changes in Customer's Contribution Form J -2 82 Statement of Revenues and Expenses Form J -3 83 Statement of Changes in Financial Position Form J -4 84 Schedule of Property, Equipment and Accumulated Depreciation Form J -5 85 -86 N Lu a � o H to m p Z u- M Lu (n L () a E � a) LLJ u Z 00 p. a) Lu m L M J O L J -4- a Q n L 1 4 J, F- a) 4-): Lu Lu -0 O Lu E I- 2 4) Ln u ai a) > uJ M, U � I Z ro Q L ina m E O C.7 U. Z L Z 4J m 3 > O O m m M %D O N M 00 ^ M 00 O M M -' L!1 m u1 1, O co N M -- N Ili ---o 1\ - 00 fl, Ln Ln %D 1� -T M co 00 m M 00 ? I 1 1 1 ? 00 Ln %D -' O %D M M M N L Ln r- N M 1\ -ID u1 N %0 •S 00 1-% %D O Lf� M /) d-j LL U1 Ln O 1" 1" 00 n O N1 00 1- O O M N M M U'% (D - M •- N - E N N •- u % N .000 ♦D m Ln 00 M ? 00 N N N Ln N 00 .- Lt1 Ln u-, u1 O M O in• E m •- m M N N N M O M 01 O M Ln m N 1-� M C 0' 4J c i a) ^ 0 vOi N m M M _::r L11 M M 4J > O_ N Lr% W •- L u .0 a) 4- C ++ s a) 4) O U C a a) N C to > U4-QON a) > 41 -o E a) (0 C U 7 C L M a) L 7 ul% N M -T NEIGNTS, MINNESOTA p a) m> 4- E t Q) O L0 +1 a) N > •- a) a L 0) (0 a Vt .a-- a) p - •7 4J N O Q m () u d-) -0 L in > u a) O ^ to •- c E CL - O L •u (0 Lu 41 c m (0 7 H (a L L. to 0 v to M 0 u ( 0 VI 4-J I- C O E 4- L- i- 4-) U O O tT O -:r m N 0000 %D -T Ln m N i�, h m 00 ♦D � a) L %D Lr% O Ol 00 N •- � M LJ1 O 1- N m N %.D N L •- t a) •- to O _:r ^ m ^ %0 %D .- u1 %0 a 4- U m Ln O 00 -T n ^ O a) -000 E 4- (o ^ ^ ^ ^ ^ 1 ^ ^ aJm ^ ^ ^ 1 .. ^ ^ J 4- E Cr) O 0100 %.o Lr% 00 O N M 00 Ln O m � m 0 M a) - -'r .- 04 N M m N 0000 O O u1 ANNUAL FINANCIAL KPORT u _:r N m N M M LA M N M p LA N M Ln N Lu a � o H to m p Z u- M Lu (n L () a E � a) LLJ u Z 00 p. a) Lu m L M J O L J -4- a Q n L 1 4 J, F- a) 4-): Lu Lu -0 O Lu E I- 2 4) Ln u ai a) > uJ M, U � I Z ro Q L ina m E O C.7 U. Z L Z 4J m 3 > O O m m 0000 %D %lD 00 m 00 ^ _:r m r� UTA M N- -- 00 O M u% O -- N Ili ---o 1\ - 00 m u -0 > O Lr% M •-- 00 00 m m ? I 1 1 1 00 1 1 1 I 1�. M M N N- 7 N Ln r- N M %0 •S 00 1-% %D O Lf� Lf1 /) d-j LL U1 %D M m N M N - 1� Lr,% 1-. 00 1- O N M N M M U'% (D - M •- N - E N N •- u % N 41 r0 •- 7 to 01 a L N N -W 0 +-+ 0 O 0 7 7 O O 00 00 VI u1 O Ln N 0p O m 11, L 4.J O O u1 u M t\ LJ1 N 1� u1 O a) •- '0 m 0 O m m m t\ u -0 > O "00 O N u1 1\ L11 a-+ •- C coo ^ N^ 00 1 1 1 N m N M, 1�. M M N :3 C Ln O L!1 O E O 0 0 c m VI I� O m m O m O 3 +W M - •• N E Q M O t!� m 4-i N •- -W L 4) 4-J •� M •- N - E N L(1 m u % 00 41 r0 •- 7 to 01 a L N N -W 0 +-+ 0 O 0 7 7 N I-- m c u u u O L 0 u •- W in• O O 00 00 VI u1 O Ln N 0p O m 11, O O m m u N --D %,O 1� m N 1� -T ? L O 4 00 u -0 > O N %J m m C c (o •- •- u VI I 1 I 1 a) 1 1 1 .a 3 .- u 4J .N N :3 C Ln O L!1 O E O 0 0 c m VI I� O m m O m O U 7 -T �.D - •• N E Q M •- LL .- N 4-i N •- -W L 4) 4-J •� M J - E N ^ 41� 1 1 1 1 1 1 1 -1 C) VI U (1) ++ u rn to U 7 In c u -0 > O C c (o •- •- u VI C a) > .a 3 .- u 4J .N N O E O 0 0 c m VI (a — L M c - •• N E Q (p n Q) L V) C V1 4-i N •- -W L 4) 4-J •� W 4- a) .O u1 C a) •- c - E N u> c E 0 a L 41 r0 •- 7 to 01 a L N -W 0 +-+ 0 O 0 7 7 I-- m c u u u O L 0 u •- W — a) 0 0 0 0 a) N ut N of m +-t O (0 Q C 0' 4J c i L 0 vOi (o E a) -0 c c � H •u L- O a Q 4J > O_ W •- L u .0 a) 4- C ++ s a) 4) O U C a a) N C to > U4-QON a) > 41 -o E a) (0 C U 7 C - L 7 U CITY OF COLUMBIA NEIGNTS, MINNESOTA u rn c C C a) .a •- 4J O E (a M c - a •� - - E N •u u •- W a) 7 C 0' 4J L 0 (u a) c a c � N 41 -o E v V) a) m> 4- E t Q) O +1 a) N > •- a) a L 0) (0 a Vt .a-- a) p - •7 O :3 O Q m () u d-) -0 L > u a) 0• to •- c E CL - O L •u (0 Lu 41 c m (0 7 (a L L. to 0 v to aCi >, 0 u ( 0 VI 4-J I- C O E 4- L- i- 4-) U C C (p � a) Z7 7 O U •- a) O 4-) L •- t to L u c L C •- a 4- U N L u 0 a) (0 7 E 4- (o a) yQU aJm -OE J 4- O ANNUAL FINANCIAL KPORT 58 Q J Q O] L7 Z Z 07 f U � O M m N 00 O Ln M - 00 O O O M 00 N ^ U •- N v ? M rp L 4-J %D N -0 C 4-) 01 LL1 O M CL N-' %D -Z' N M n 1 I 1 L D M M --0 L(1 00 00 O 00 %D O %D M W ^ U 'D E -) to q0 r0 O C1 Cl Lr% -:r %0 ^ M �0 O �D u1 - •L L 41 W .a) 00 a) - � I- M I 4-+ C Z L (0 - m W L N- 4-1Ll- N i.3 O J .D C EM J E MM _:r^ M L NC1 N 0001 ^ (u 'D O :3 .— M O O C a) - .D N ^ m .-- ? L O N M — •C Lr% 01 Ln L M +-' (0 •— O O -0 (u U 7 Ci L) M M Z ^ N O LL. LrA >. N ^ r0 r0 O () a) a) +..t L a) O m +-t W C M .� cm — +-+ 'D a) :3 O -0 a) O +-+ A a) O O W J J C a) ^ +j 0 0 H f0 L O F- - C F- i-- E O w J a) v' 4-J r0 Q L f- W C ++ w U U r0 7 7 L a) m O O O M J L Q Q 0- O G a) im in U OC L- L M N m O � 00 O 00 7 N N -T %D L U m O u1 O Lr% Li -0 %D m Ln N Lr% %.0 1 O M Lr% Lr%? m %000 u1 O w E Ol %0- .-- ? M N Lr\ 1-: 00 N M O ^ 00- .- N M •- O Ln ♦0 N L(1 ^ N N M n O 00 M O M •- Lr% 7 C Q J Q O] L7 Z Z 07 f U � O M m N 00 O Ln C - 00 O O O M 00 N ^ U •- N v ? M rp L 4-J ici-1 -0 C 4-) 01 LL1 C f M •- C CL N •- 7 -Z' N a) •- C n 1 I 1 4- D to �D Z ? LL. W ^ U 'D E -) to q0 r0 C •� Z to •- C C w - •L L 41 W Q) L r0 L 0 a) - � I- M CL 4-+ C Z L (0 - m W L N- 4-1Ll- N i.3 O J .D C J E W a) Q a) L 0) U 1 a) (u 'D O :3 .— L O O C H .D W ._ L C 0)4- L W -C — •C 2 rp L (n +-' (0 •— O O -0 (u ++ 7 Ci L) — >. -0 E -0 L L •� li Z p J Q J Q O] L7 Z Z 07 f U � O M m N 00 O Ln LPG N - 00 O O t I M 00 N ^ N •- N m -�r LA O 01 LPG N O n tT Ln M !\ N 1 1 L!1 •�r Ln ? M rp Ln ici-1 -0 C 4-) 01 M -..r C f M M u1 1�, N M -Z' N a) •- C n 1 I 1 4- M M to �D 7 ? Q9 OO 00 00 M m of G1 N Lr1 '0 N Lr1 L!1 ^ N rp O ici-1 -0 C 4-) 01 D1 C f M N N 00 ^ a) •- C ^ O O O O --T -*- 1 w w Lr\ Lr� 1 1 I ? M M �D U% O n O %0 01 n 00 — n %D %0. M M 00 0p N N to 'O N 4-1 +r LL N O Ln N co trr M O M M `a CITY Of COLUMBIA NEIGNTSt MINNESOTA 59 ONNUAL FINANCIAL REPORT rp O' -0 C 4-) W a) •- C (0 4- T to u 0 U 'D E -) r0 C •� Z to •- C C Q) L r0 L 0 -W N J ._ LL - -W 010 C M (n Lu •- N N N> C a) C L 0) (u 'D O :3 .— L D O C -0 .D Z ._ L C 0)4- L to •— 4- -C — •C C rp Q +-' (0 •— O 7 (u ++ N) — >. -0 E -0 L L U — a) L p C L LL. J >. N ^ r0 r0 O () a) +..t L a) O m +-t — +-+ 'D a) :3 O -0 a) O +-+ A a) O O W J J C a) ^ +j 0 0 H f0 L O F- - C F- i-- m +J O L (0 i J a) v' 4-J r0 Q C U U >1 a) a) 4- a) W C ++ w U U r0 7 7 L a) m O O J L Q Q 0- O G a) im in U OC L- L C 7 +J 7 U O � Li CITY Of COLUMBIA NEIGNTSt MINNESOTA 59 ONNUAL FINANCIAL REPORT COMBINING STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - ALL ENTERPRISE FUND TYPES Year Ended December 31, 1981 With Comparative Totals for Year Ended .December 31, 1980 Liquor 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 (LOSS) NON- OPERATING REVENUES (EXPENSES): Interest income Interest expense Other income (expense) - net Total Net Income Transfers to other funds RETAINED EARNINGS (DEFICIT) AT BEGINNING OF YEAR RETAINED EARNINGS (DEFICIT) AT END OF YEAR CITY OF COLUMBIA HEIGHTS, MINNESOTA $ 1,205,801 852,135 $ 353,666 233,778 83,935 7,398 325,111 28,555 7,714 20,841 72,322 580,590 652,,912 673,753 609,861 $ 1,283,614 J60 ANNUAL FINANCIAL tErORT (83,291) (227,566) $ (90,463) $(130,259) 299,004 246,601 $ 1,062,892 $ 299,004 I CITY OF COLUMBIA NEI6NTS, MINNESOTA 61 . Form G -1 ANNUAL FINANCIAL REPORT Totals Water Sewer 1981 1980 $ 708,400 $ 733,306 $ 2,647,507 $ 2,466,824 - - 852,135 868,704 $ 708,400 $ 733,306 $-1,795,372 $ 1,598,120 152,233 122,894 508,905 547,996 46,653 41,772 172,360 162,313 17,607 24,318 49,323 52,416 438,397 379,782 818,179 683,048 654,.890 568,766 1,548,767 1,445,773 53,510 164,540 246,605 152,347 43,470 57,065 108,249 109,609 10,040 107,475 138,356 42,738 7,012 14,643 93,977 59,188 (1,851) - (1,851) (7,698) 627 13,189 594,406.:% 3,175 5,788 27,832 686,532 54,665 15,828 135,307 824,888 97,403 (23,000) (38,000) (61,000) (45,000) (83,291) (227,566) $ (90,463) $(130,259) 299,004 246,601 $ 1,062,892 $ 299,004 I CITY OF COLUMBIA NEI6NTS, MINNESOTA 61 . Form G -1 ANNUAL FINANCIAL REPORT COMBINING STATEMENT OF CHANGES IN FINANCIAL POSITION ALL ENTERPRISE FUND TYPES Year Ended December 31, 1981 With Comparative Totals for Year Ended December 31, 1980 SOURCES OF WORKING CAPITAL: Operations: Net income Items not requiring (providing) working capital Depreciation Gain on disposal fixed assets Proceeds from sale of equipment Working Capital Provided by Operations Decrease in long term contract receivable Increase in deferred credit-revaluation MWCC Decrease in deferred receivable - reserve capacity 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 i CITY OF COLUMBIA NEIGHTS, MINNESOTA 62 Liquor $ 673,753 7,714 (576,975) 651,611 $ 756,103 $ 756,103 $ 3,665 $ 3,665 $ 752,438 $ (6,536) 785,000 (164) (6,869) (22,828) 3,835 $ 7521438 &NNUAL FINANCIAL REPORT Form G -2 Totals Water Sewer _U81 1980 $ 5,828 $ 110,307 $ 789,888 $ 97,403 43,470 57,065 108,249 109,609 - - (576,975) - - - 651,611 - $ 49,298 $ 167,372 $ 972,773 $ 207,012 - 10,165 10,165 9,774 - 1,502 1,502 1,323 $ 49,298 $ 179,039 $ 984,440 $ 218,109 $ 3,302 $ 14,654 $ 21,621 $ 13,168 14,300 - 14,300 11,550 - 10,165 10,165 9,774 13,000 13,000 26,000 45,000 $ 30,602 $ 37,819 $ 72,086 $ 79,492 $ 18,696 $ 141,220 $ 912,354 $ 138,617 $ (656) $ 81 $ (7,111) $ (11,303) (15,000) 229,000 999,000 82,000 29,405 10,379 39,620 64,343 1,325 - (5,544) 28,998 (33,255) (64,699) (120,782) (30,539) (2,750) - (2,750) 42,900 41,145 (33,541) 7,604 (37,782) (1,518) - 2,317 - $ 18,696 $ 141,220 $ 912,354 $ 138,617 CITY OF COLUMBIA MEIGIITS, MINMEtOTA 63 MNIIAI FINANCIAL REPORT Form H MUNICIPAL LIQUOR FUND COMPARATIVE BALANCE SHEET December 31, 1981 and 1980 CITY OF COLUMBIA HEIGHTS, MINNESOTA ANNUAL FINANCIAL REPORT 1981 1980 ASSETS Current Assets: Cash: Treasurer's balance $ 300 $ 1,836 Imprest cash and change funds 5,100 10,100 Total Cash $ 5,400 $ 11,936 Investments, at cost 1,140,000 355,000 Accounts receivable - 164 Merchandise inventory, at cost 115,498 122,367 Total Current Assets $1,260,898 $ 489,467 Property and Equipment: Land $ 7,125: $ 16,735 Buildings 70,260 169,390 Improvements other than buildings 19,665 66,056 Office furniture and equipment 872 1,375 Store equipment 31,998 75,623 Total $ 129,920 $ 329,179 Less: Accumulated depreciation 60,47,i 181,045 Net Property and Equipment -- Form H-5 $ 69,449. $ 148,134 Total Assets $1,330,347 $ 637,601 LIABILITIES AND RETAINED EARNINGS Current Liabilities: Accounts payable $ 43,459 $ 20,631 Accrued salaries payable 3,073 5,890 Accrued social security /P.E.R.A. payable 201 1,219 Total Current Liabilities $ 46,733 $ 27,740 Retained Earnings -- Unreserved Form H -1 $1,283,614 $ 409,861 Total Liabilities and Retained Earnings $1,330,347 $ 637,601 CITY OF COLUMBIA HEIGHTS, MINNESOTA ANNUAL FINANCIAL REPORT Sales MUNICIPAL LIQUOR FUND COMPARATIVE STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS COMBINED ON -SALE AND OFF -SALE Years Ended December 31, 1981 and 1980 Totals All Stores i21 190 $1,205,801 $1,301,856 Cost of Sales: Inventory, Beginning $ 122,366 $ 92,768 Purchases 1 845,267 898,302 Total Mdse.Available for Sale$ 967,633 $ 991,070 Less: Inventory, Ending 115,498 122,366 Cost of Sales "52,135 $ 868,704 Gross Profit.on Sales $ 353,666 $ 433,152 Percentage of Gross Profit to Sales 29.33% 33.27% Less: Operating Expense -- Form H -4 $ 325,111 $ 364,361 Operating Income before Depreciation Less: Depreciation - Form H -5 Operating Income Nonoperating Revenues (Expenses): Interest earnings - Trust Fund Machine commissions Other income Cash short Gain /Loss on disposal of assets Other expense Total Net Income $ 28,555 $ 68,791 7,714 8,585 $ 20,841 $ 60,206 $ 72,322 $ 36,773 6,254 7,435 - 641 (1,923) (1,441) 576,975 - (7 1 6) - $ 652,912 $ 43,408 $ 673,753 $ 103,614 Retained Earnings at beginning of year $ 609,861 $ 506,247 Retained Earnings at end of year $1,283,614 $ 609,861 [.CITY OF COLUMBIA NEIGNTS, MINNESOTA 65 . On -Sale Store 1981 i9 0 232,943 1 334,594 $ 12,128 $ 11,020 63,441 109,094 $ 75,569 $ 120,114 12,128 75,569 $ 107,986 $ 157,374 226,608 67-56% 67.73% T $ 177,104 $ 212,596 $ (19,730) $ 14,012 3,978 5,177 $ (23,708) $ 8,835 $ 67,006 $ 12,257 5,223 6,073 - 230 (541) (433) 576,975 - (710) - $ 647,953 $ 18,127 $ 624,245 $ 26,962 #NNUAL FINANCIAL REPORT Form H -1 Off -Sale Stores Totals 1 s NO. 2 N0. 3 19 1 1980 1981 __L980 1981 1980 $ 972,858 $ 967,262 $ 441,978 $ 426,658 $ 530,880 $ 540,604 $ 110,238 $ 81,748 $ 47,736 $ 35,065 $ 62,502 $ 46,683 781,826 789,208 - 362,582 (1,382) 347,858 (1,004) 419,244 (378) 441,350 $ 892,064 $ 870,956 $ 410,318 $ 382,923 $ 481,746 $ 488,033 $ 49,508 $. 115,498 $ 13,218 $ 110,238 $ 36,290 $ 53,502 47,736 61,996 62,502 $ 776,566 $ 760;718 $ 356,816 $ 335,187 $ 419,750 $ 425,531 $ 196,292 $ 206,544 $ 85,162 $ 91,471 $ 111,130 $ 115,073 20.18% 21635% 19.27% 21.44% 20.93% 21.28% $ 148,007 $ 151,765 $ 71,440 $ 73,339 $ 76,567 $ 78,426 $ 48,285 $ 54,779 3,,736 3,408 $ 44,549 $ 51,371 $ 13,722 $ 18,132 1,405 1,215 $ 12,317 $ 16,917 $ 34,563 $ 36,647 2,331 2,193 $ 32,232 $ 34,454 $ 5,316 $ 24,516 $ 1,418 $ 12,258 $ 3,898 $ 12,258 1,031 1,362 490 632 541 730 411 315 - 96 (1,382) (1,008) (1,004) (456) (378) (552) (6) (3) - (3) - $ 4,959 $ 25,281 $ 901 $ 12,749 $ 4,058 $ 12,532 $ 49,508 $. 76,652 $ 13,218 $ 292666 $ 36,290 $ 46,986 L ITY OF COLUMBIA HEIGHTS, MINNESOTA 66 ANNUAL FINANCIAL REPORT MUNICIPAL LIQUOR FUND COMPARATIVE STATEMENT OF CHANGES IN FINANCIAL POSITION Years Ended December 31, 1981 and 1980 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: Form H -2 1981 1980 $ 673,753 $ 103,614 (576;975) 8,585 651,611 - $ 756,103 $ 112,199 Acquisition of property and equipment -- Form H -5 $ 3,665 29,599 $ 4,100 3,835 Net Increase in Working Capital $ 752,438 $ 108,099 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 67 $ (6,536) $ (456) 785,000 95,000 (164) (852) (6,869) 29,599 (22,828) (15,317) 3,835 125 S 752.438 S 108.099 ANNUAL FINANCIAL KPORT MUNICIPAL LIQUOR FUND COMPARATIVE SCHEDULE OF GROSS PROFIT - OFF SALE Years Ended December 31, 1981 and 1980 TOTAL OFF SALE Sales Cost of Sales: Inventory, Beginning Purchases Total Merchandise Available for Sale Less: Inventory, Ending Cost of Sales Gross Profit (Loss) on Sales -- Form H-1 Percentage of Gross Profit to Sales NO. 2 Sales Cost of Sales: Inventory, Beginning Purchases Total Merchandise Available for Sale Less: Inventory, Ending Cost of Sales Gross Profit (Loss) on Sales Percentage of Gross Profit to Sales NO. 3 Sales Cost of Sales: Inventory, Beginning Purchases Total Merchandise Available for Sale Less: Inventory, Ending Cost of Sales Gross Ocofit (Loss) on Sales Percentage of Gross Profit to Sales CITY OF COLUMBIA NEICNTS, MINNESOTA 68 1981 I Total Liquor. $ 972,858 $ 110,238 781,826 92,0 115,498 77776, 566 196,292 20.18% $ 441,978 $ 47,736 362,582 10,31 53,502 3` 6 3,1 $ 85,162 $ 19.27% $ 530,880 $ 62,502 419,244 61,996 19,750 $ 111,130 20.93% $ 385,970 $ 87,380 301,263 ��� 3 95,342 293,301 92,669 24.01% $ 172,312 $ 37,402 138.783 $$ 176,1 55 43,833 132,352 $ 39,960 23.19% $ 213,658 $ 49,978 162.480 $ 212,458 51.509 $ 16- 9 $ 52,709 24.67% ANNUAL FINANCIAL REPORT Form H -3 1981 1980 Beer Other Total Liquor Beer Other $ 568,847_ $ 18,041 $ 967,262 $ 380,684 $ 571,495 $ 15,083 $ 19,905 $ 2,953 $ 81,748 $ 66,164 $ 13,538 $ 2,046 458687 21,876 789,208 303,590 463,430 22,188 $ 478,59? $ 24,829 $ 870,956 $ 369,754 $ 476,968 $ 24,234 18,307 $ 4 0�,285 1 849 $ 22,g 0 110,238 7 0,71 87,38o 282,374 19 905 457,063 2 953 21 ,2 1 $ 108,562 $ (4,939) $ 206,544 $ 982310 $ 114,432 $ 6 198) 19.08% - 21.35% 25.82% 20.02% - $ 262,284 $ 7,382 $ 426,658 $ 162,062 $ 259,244 $ 5,352 $ 9,121 $ 1,213 $ 35,065 $ 27,921 $ 6,627 $ 517 213,444 10,355 347,858 129,784 208,583 9,491 $ 222,565 $ 11,568 $$ 382,923 $ 157,705 $ 215,210 $ 10,008 8,751 $ 213,814 918 $ 10, 50 47,73 $$ 335,187 $ 37,402, 120,303 9,121 206,089 1,213 $ -8,795 $ 48,470 $ (3,268) $ 91,471 $ 41,759 $ 53,155 $ (32443) 18.48% - 21.44% 25.77% 20.50% - $ 306,563 $ 10,659 $ 540,604 $ 218,622 $ 312,251 $ 9,731 $ 10,784 $ 1,740 $ 46,683 $ 38,243 $ 6,911 $ 1,529 $ 245,243 256,027 $ 11,521 13,261 441,350, $ 173,806 $$ 212,0 254,847 $ 261,758 12,697 $ 14,226 9,556 $� 931 12,330 62,502 25,531 49,978 162,071 10,784 250,97T+ 1 740 $ 12, $ 60,092 $ (1,671) $ 115,073 $ 56,551 $ 61,277 $ (2,755) 19.60% - 21.28 %. 25.87% 19.62% - .CITY OF., COLUMBIA NEIQNTS, MINNESOTA 69 9 #NNUAL FINANCIAL REPORT MUNICIPAL LIQUOR FUND COMPARATIVE SCHEDULE OF OPERATING EXPENSES COMBINED ON -SALE AND OFF -SALE Years Ended December 31, 1981 and 1980 PERSONAL SERVICES: Salaries - regular employees Salaries - overtime and part time employees Interdepartmental labor services City contribution to PERA and FICA Hospitalization - Life insurance Workmen's and Unemployment compensation Total Personal Services OTHER SERVICES & CHARGES: Contractural maint. S repair Professional services Communications Travel - subscriptions Utility Insurance & bonds Other contractural services Other charges Total Other Services & Charges SUPPLIES: General supplies Bar supplies Total Supplies Total Operating Expense CITY OF 'COLUMBIA NEIGNTS, MINNESOTA U 70 Form H-4 $ 1,933 $ 342 25,830 24,149 2,658 865 702 186 13,156 5,687 27,180 20,009 4,377 1,517 8,099 3,682 3,935 $ 56,437 $ 5,246 $ 1,000 2,152 2,152 $ - 7,398 $ 3,152 $ 325,111 $ 177,104 (Form H -1) RNNUAL FINANCIAL REPORT 1981 Total On -Sale $ 113,081 $ 48,590 79,804 44,567 4,040 1,895 19,570 10,394 6,305 2,809 10,978 X2333,778 9,260 $ 117,515 $ 1,933 $ 342 25,830 24,149 2,658 865 702 186 13,156 5,687 27,180 20,009 4,377 1,517 8,099 3,682 3,935 $ 56,437 $ 5,246 $ 1,000 2,152 2,152 $ - 7,398 $ 3,152 $ 325,111 $ 177,104 (Form H -1) RNNUAL FINANCIAL REPORT Form H -4 $ 1,797 $ 2,449 $ 4,722 $ 1,609 $ 1,374 $ 1,739 3,598 3,59$ - $ 1,797 $ 2,449 $ 8,320 $ 5,207 $ 1,374 $ 1„739 $ 711440 $ 76,567 $ 364,361 $ 2122596 $ 73,339 $ 78,426 CITY OF COLUMBIA HEIGHTS, MINNESOTA 71 MNUAL FINANCIAL REPORT 1981 1980 No. 2 No. 3 Total On -Sale No. 2 No. 3 $ 32,557 $ 31,934 $ 131,496 $ 64,034 $ 33,647 $ 33,815 16,848 18,389 103,683 65,766 17,743 20,174 174 1,971 1,767 1,575 93 99 4,255 4,921, 22,691 12,890 4,720 5,081 2,014 1,482 6,061 3,181 1,583 1,297 739 56,5'9-7 979 '59,67"C 4,162 269,860 3,023 150, 9 546 58,332 593 1,059 $ 931 $ 66o $ 3,568 $ 2,188 $ 541 $ 839 830 851 32,912 31,312 800 800 890 903 2,130 983 612 535 258 258 758 209 340 209 3,412 4,057 14,961 7,879 3,148 3,934 3,478 3,693 20,822 10,083 5,262 5,477 1,059 1,801 4,090 1,714 1,015 1,361 2,198 $ 13,05 2,219 $ 1 , 2 6,94o $ fib,181 2,552 $ 56 920 1,915 $ 13,633 2,473 $ 15,628 $ 1,797 $ 2,449 $ 4,722 $ 1,609 $ 1,374 $ 1,739 3,598 3,59$ - $ 1,797 $ 2,449 $ 8,320 $ 5,207 $ 1,374 $ 1„739 $ 711440 $ 76,567 $ 364,361 $ 2122596 $ 73,339 $ 78,426 CITY OF COLUMBIA HEIGHTS, MINNESOTA 71 MNUAL FINANCIAL REPORT MUNICIPAL LIQUOR FUND SCHEDULE OF PROPERTY, EQUIPMENT AND ACCUMULATED DEPRECIATION Year Ended December 31, 1981. Proeerty and Equipment Balances Deletions Balances 1 -1 -81 Additions 12 -31 -81 On Sale /Lounge: Land $ 9,610 $ (9,610) $ - Building 99,130 (99,130) - Parking area 8,335 (8,335) - Improvements other than buildings 38,057 (38,057) - Fixtures 35,938 (35,938) - Equipment: Store 13,284 (13,284) - Office 735 (735) - Total $ 205,089 $ (205,089) $ - Off Sale No. 2 Store: Land Building Improvements other than buildings Fixtures Equipment: Store Office Total Off Sale No. 3 Store: Land Building Improvements other than buildings Fixtures Equipment: Store Office Total Grand Totals CITY OF COLUMBIA NEIGHTS, MINNESOTA $ 2,765 $ - 27,637 - 11,463 7,054 - 2,803 777 4o4 98 $ 52,126 $ 875 $ 4,360 42,623 8,202 14,791 1,752 236 $ 71,964 $ 329,179 72 _. 4,821 134 $ 4,955 $ (199,259) (Form H -2) $ 2,765 27,637 11,463 7,054 3,580 502 $ 53,001 $ 4,360 42,623 8,202 14,791 6,573 370 $ 76,919 $ 129,920 (Form H ANNUAL FINANCIAL KPORT Balances Depreciation Deletions Balances 1 -1 -81 _Taken Adustments 12 -31 -81 50,335 2,154 31,380 34,089 7,540 518 $ 126,016 8,982 4,643 6,497 1 901 $ 21,320 15,257 4,876 12,598 780 198 $ 33,709 $ 181,045 1,622 313 878 377 762 26 S 3,978 553 423 71 322 36 $_ 1,405 872 396 739 300 24 $ 2,331 $ 7,714 (Form H -1 Form -� Net Asset Value CITY OF COLUMBIA NEIGNTS, MINNESOTA 73 NNNUAL FINANCIAL KPORT (51,957) - - (2,467) - - (32,258) - - (34,466) - - (8,302) - - (544) - - $ (129,994) $ - $ - $ - $ - $ 2,765 - 9,535 18,102 - 5,066 6,397 - 6,568 486 - 1,223 2,357 (70) 263 239 $ (70) $ 22,655 - $ 30,346 $ - $ - $ 4,360 - 16,129 26,494 - 5,272 2,930 13,337 1,454 1,738 2,818 3,755 38 260 110 $ 1,776 $ 37,816 $ 39,103 $ (128,288) $ 60,471 $ 69,449 (Form H ) (Fo rm H CITY OF COLUMBIA NEIGNTS, MINNESOTA 73 NNNUAL FINANCIAL KPORT Form I WATER UTILITY FUND COMPARATIVE BALANCE SHEET December 31, 1981 and 1980 ASSETS 1981 1980 Current Assets: Cash - Treasurer's balance $ 890 $ 1,546 Investments, at cost 57,000 72,000 Accounts receivable: Unbilled services 114,291 194,523 Special assessments: Current - 8,327 Delinquent 1,794 351 Other 116,709 188 Meter inventory, at cost 3,191 1,866 Total Current Assets $ 293,875 $ 278,801 Property and Equipment: Land $ 45,223 $ 45,223 Buildings 210,987 210,987 Improvements other than buildings 2,162,205 2,160,892 Machinery and equipment Total 109,311 107 322 2,527,72 $ 2,52 2 Less: Accumulated depreciation 974,351 930,881 Net Property and Equipment -- Form 1 -4 $1,553,375 $ 1,593,543 Total Assets $1,847,250 $ 1,872,344 LIABILITIES, CONTRIBUTIONS, AND RETAINED EARNINGS Current Liabilities: Accounts payable $ 34,954 $ 1,699 Accrued salaries payable 5,008 3,420 Accrued social security /P.E.R.A. payable 517 587 Due to other governmental units - 41,145 Due to general obligation bonds of 1965 14,300 11,550 Total Current Liabilities $ 54,779 $ 58,401 Other Liabilities (less current portion above): Due to general obligation bonds of 1965 15,400 29,700 Total Liabilities $ 70,179 $ 88,101 Fund equity contributed: Contributed from customers $1,414,534 $ 1,414,534 Contributed from federal grant 453,000 453,000 Total Contributions $1,867,534 $ 1,867,534 Retained Earnings Unreserved (Deficit) -- Form 1 -1 (90,463) (83,291) Total Fund Equity $1,777,071 $ 1,784,243 Total Liabilities, and Fund Equity $1,847,250 $ 1,872,344 CITY OF " COLUMBIA NEIGNTS, MINNESOTA 74 ANNUAL FINANCIAL REPORT WATER UTILITY FUND COMPARATIVE STATEMENT OF CHANGES IN RETAINED EARNINGS Years Ended December 31, 1981 and 1980 Retained Earnings (Deficit) at beginning of year Add: Net income for the'year -- Form 1-2 Total Balance and Additions Deduct: Net loss for the year -- Form 1 -2 Transfer to Central Garage Fund Total Deductions Retained Earnings (Deficit) at end of year CITY OF COLUMBIA NEIGNTS, MINNESOTA 75 Form 1 -1 1981 1980 $ (83,291) $ (55,119) 5,828 - $ (77,463) $ (55,119) $ - $ 28,172 13,000 - $ 13,000 $ 28,172 $ (90,463) $ (83,291) #NNUAL FINANCIAL REPORT Form 1 -2 WATER UTILITY FUND COMPARATIVE STATEMENT.OF REVENUES AND EXPENSES Years Ended December 31, 1981 and 1980 1981 1980 Operating Revenues: Water sales $ 696,913 $ 590,904 Hydrant rental 500 500 Meter sales (less cost of sales) 759 649 Customer service 1,891 918 Penalties 8,337 6,543 Total Operating Revenue $ 708,400 $-599,514 Operating Expenses: Source of supply $ 438,397 $ 371,097 Distribution: Personal services 134,465 122,998 Other services and charges 32,180 34,047 Supplies .17,485 22,424 Administration & General: Personal services 17,768 15,003 Other services and charges 1+,473 8,924 Supplies 122 1,095 Total Operating Expenses $ 654,890 $ 575,588 Operating Income Before Depreciation $ 53,510 $ 23,926 Less: Depreciation -- Form 1 -4 43,470 43,586 Operating Income (Loss) $ 10,040 $ (19,660) Nonoperating Revenues (Expenses): Interest earnings - Trust Fund $ 7,012 $ 7,681 Certification delinquent utility bills - 906 Miscellaneous 627 79 Interest expense (1,851) (2,178) Total $ 5,788 $ 6,488 Net Income (Loss) before transfers $ 15,828 $ (13,172) Transfer to Debt Service Funds - City Garage 10,000 15,000 Net Income (Loss) - Form 1 -1 $ 5,828 $ (28,172) CITY OF :COLUMBIA NEIGNTS, MINNESOTA ✓ #NNUAL FINANCIAL REPORT 76 WATER UTILITY FUND COMPARATIVE STATEMENT OF CHANGES IN FINANCIAL POSITION Years Ended December 31, 1981 and 1980 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 Form 1 -3 1981 1980 $ 5,828 $ (28,172) 43,470 43,586 $ 49,298 $ 15,414 $ 13,000 $ - 3,302 2,885 14,300 11,550 $ 30,602 $ 14,435 $ 18,696 $ 979 Elements of Net Increase (Decrease) in Working Capital: Cash $ 0656) $ (2,294) .I.nvestments (1.5,000) (28,000) Accounts receivable 29,405 48,227 Inventory 1,325 (601) Accounts payable (33,255) (329) Accrued expenses (1,518) 984 Due to other governmental units 41,145 (15,908) Due to other funds (2,750) (1,100) Net Increase (Decrease) in Working Capital .CITY OF COLUMBIA NEIGHTS, MINNESOTA 77 $ 18,696 $ 979 OIINUAL FINANCIAL REPORT WATER UTILITY FUND SCHEDULE OF PROPERTY, EQUIPMENT AND ACCUMULATED DEPRECIATION Year Ended December 31, 1981 Land Buildings Improvements other than buildings Machinery and equipment Office furniture and equipment Grand Totals I CITY OF COLUMBIA NEI&NTS, MINNESOTA Property and Equipment Balances Balances 1 -1 -81 Additions Transfers 12 -31 -81 $ 45,223 $ - $ - $ 45,223 210,987 - - 210,987 2,160,892 1,313 2,162,205 104,494 1,989 - 106,483 2,828 - - 2,828 $2,524,424 $ 3,302 $ - $ 2,527,726 (Form 1 -3) (Form-IT- 78- RIINUAL FINANCIAL REPORT '' Accumulated Depreciation Balances Depreciation Balances 1 -1 -81 Taken Deductions 12 -31 -81 42,224 6,790 804,402 30,424 81,795 6,183 2,460 73 $ 930;881 $ 43,470 (Form 1 -2) - 49,014 - 834,826 - 87,978 - 2,533 S - $ 974,351 (Form I) [.CITY OF COLUMBIA HEIGHTS, MINNESOTA V/ 79 Form 1-4 Net Assets W1ue $ 45,223 161,973 1,327,379 18,505 295 $ 1,553,375 (Form I RNNUAL FINANCIAL REPORT Form J SEWER UTILITY FUND COMPARATIVE BALANCE SHEET December 31, 1981 and 1980 1981 1980 ASSETS Current Assets: Cash - Treasurer's balance $ 2,770 $ 2,689 Investments, at cost 251,450 22,450 Accounts receivable: Unbilled services 111,619 101,240 Due from Metropolitan Waste Control Commission operating cost adjustment 1980 and 1979 - 33,541 Total Current Assets $ 365,839 $ 159,920 Deferred Assets: Due from Metropolitan Waste Control Commission: Reserve capacity $ 31,128 $ 32,630 Interceptor acquisition contract 292,518 302,683 Total Deferred Assets $ 323,646 $ 335,313 Property and Equipment: Land Buildings Improvements other Machinery and equi Total Less: Accumulated $ 36,586 $ 36,586 24,308 24,308 than buildings 2',318,139 2,304,111 Pment 177,818 177,192 $2,556,851 $2,542,197 depreciation 1,070,907 1,013,842 Net Property and Equipment -- Form J -5 $1,485,944 $1,528,355 Total Assets $2,175,429 $2,023,588 LIABILITIES; CONTRIBUTIONS, AND RETAINED EARNINGS Current Liabilities: Accounts payable $ 8,180 $ 706 Accrued salaries and fringe payable 2,803 2,816 Due to other governmental units 111,059 53,821 Total Current Liabilities $ 122,042 $ 57,343 Deferred Credits: Revaluation gain: Interceptor acquisition by Metropolitan Waste Control Commission $ 292,518 $ 302,683 Contributions from Customers $1,891,128 $1,891,128 Retained Earnings Unreserved (deficit) -- Form J -1 $ (130,259) $ (.227,566) Total Liabilities, Contributions, and Retained Earnings $2,175,429 $2,023,588 CITY OF COLUMBIA NEIGNTS, MINNESOTA �� 80 RNNUAL FINANCIAL REPORT SEWER UTILITY FUND COMPARATIVE STATEMENT OF CHANGES IN RETAINED EARNINGS Years Ended December 31, 1981 and 1980 Retained Earnings (deficit) at beginning of year Add: Net income for the year -- Form J -3 Total Balance and Additions Deduct: Net loss for the year -- Form J -3 Transfer to Central Garage Fund Total Deductions Retained Earnings (deficit) at end of year .CITY OF COLUMBIA NEIGNTS, MINNESOTA 1`/ 81 _ Form 4 -1 1981 1980 $ (227,566) $ (204,527) 110,307 - $ (117,259) $ (204,527) $ - $ 23,039 13,000 - $ 13,000 $ 23,039 $ (130,259) $ (227,566) ANNUAL FINANCIAL REPORT Form J -3 SEWER UTILITY FUND COMPARATIVE STATEMENT OF REVENUES AND EXPENSES Years Ended December 31, 1981 and 1980 i CITY OF COLUMBIA NEIGNTS, MINNESOTA 82 ANNUAL FINANCIAL REPORT 1981 1980 Operating Revenues: Sewer service charges - general customers and interdepartmental $ 730,131 $ 562,398 Refunds and Reimbursements: Metropolitan Waste Control Commission: Interceptor maintenance 2,645 2,886 S.A.C. charge refund 530 170 Total Operating Revenues $ 733,306 $ 565,454 Operating Expenses: Disposal - Metro Waste Control Commission $ 443,683 $ 345,492 Deduct experience adjustment for prior years Net Disposal Charges. (63,901) 379,782 (33,541) 311,951 Collections: Personal services 103,350 123,431 Other services and charges 27,582 29,059 Supplies 24,237 19,479 Administration: Personal services 19,544 16,704 Other services and charges 14,190 6,557 Supplies 81 1, 098 Total Operating Expenses $ 568,766 $ 508,279 Operating Income Before Depreciation $ 164,540 $ 57,175 Less: Depreciation -- Form J -5 57,065 57,438 Operating Income (Loss) $ 107,475 $ (263) Nonoperating Revenues (Expenses: Interest earnings $ 14,643 $ 360 Metro Waste Control Commission Interest on deferred current value credit 12,107 12,498 Interest on reserve capacity deferred charges 889 970 Other income 193 41 Easement - (1,125) Interest expense - (5,520) Total T-2-7,'9-32 $ 7 224 Net Income before transfers 135,307 $ 6:961 Transfers to: Debt Service Funds - City Garage $ 10,000 $ 15,000 Debt Service Funds - Storm Sewer 15,000 15,000 Net Income (Loss) - Form J -1 $ 110,307 $ (23,039) i CITY OF COLUMBIA NEIGNTS, MINNESOTA 82 ANNUAL FINANCIAL REPORT Form J -4 SEWER UTILITY FUND COMPARATIVE STATEMENT OF CHANGES IN FINANCIAL POSITION Years Ended December 31, 1981 and 1980 1981 1980 Source of Working Capital: Operations: Net income (loss) - Form J -3 $ 110,307 $ (23,039) Items not requiring (providing) working capital: Depreciation - Form J -5 57,065 57,438 Working Capital Provided from Operations $ 167 372 $ 34,399 Metropolitan Waste Control Commission: Decrease in long -term contract receivable $ 10065- $ 9,774 Decrease In deferred receivable - Reserve Capacity charge 1,502_, 1,323 Total Metropolitan Waste Control Commission $ 11,667 $ 11,097 Contributions from customers $ - $ 4,813 Total Sources of Working Capital $ 179,039 $ 50,309 Uses of Working Capital: Decrease in deferred credit - revaluation gain on sale of fixed assets $ 10,165 $ 9,774 Transfer to Central Garage Fund 13,000 - Additions to property and equipment -- Form J -5 14,654 10,996 Total Uses of Working Capital $ 37,819 $ 20,770 Net Increase in Working Capital $ 141,220 $ 29,539 Elements of Net Increase (Decrease) in Working Capital: Cash Investments Accounts receivable Accounts payable Due to Bonds of 1976 Fund Due from /to Metro Waste Control Commission Net Increase in Working Capital [CITY OF COLUMBIA NEIGNTS, MINNESOTA 83 $ 81 $ (8,553) 229,000 15,000 10,379 16,968 (64,699) (94) 44,000 (33,541) (37,782) $ 141,220 $ 29,539 &NNUAL FINANCIAL REPORT SEWER UTILITY FUND SCHEDULE OF PROPERTY, EQUIPMENT AND ACCUMULATED DEPRECIATION Year Ended December 31, 1981 i .CITY OF COLUMBIA NEIGNTS, MINNESOTA 84 #NNUAL FINANCIAL KPORT Property and Equipment Balances Balances 1-1 -81 Additions Transfers 12 -31 -81 Land $ 36,586 $ - $ - $ 36,586 Buildings 24,308 - - 24,308 Improvements other than buildings 2,304,111 14,028 - 2,318,139 Machinery and equipment 175,630 626 - 176,256 Office furniture and equipment 1,562 - - 1,562 Grand Total $2,542,197 $ 14,654 $ - $2,556,851. Form J -4 Form J') i .CITY OF COLUMBIA NEIGNTS, MINNESOTA 84 #NNUAL FINANCIAL KPORT Accumulated Depreciation Balances Depreciation Balances 1 -1-81 Taken Deductions 12 -31-81 8,042 610 - 8,652 873,757 47,437 - 921,194 130,745 8,955 - 139,700 11298 63 - 1,361 $1,013,842 $ 57,065 $ - $`1,070,907 (Form J -3 Form J .CITY OF COLUMBIA NEIGNTS, MINNESOTA 85 .. Form J -5 Net Assets Value $ 36,586 15,656 1,396,945 36,556 201 $1,485,944 Form J ANNUAL FINANCIAL KPORT SEWER UTILITY FUND STATEMENT OF CHANGES IN CUSTOMER'S CONTRIBUTION Year Ended December 31, 1981 Balance at beginning of year Add: Property and equipment provided by special assessments during 1981 Balance at end of year CITY OF COLUMBIA NEI6NTS, MINNESOTA 86 Fund J -2 $ 1,891,128 $ 1,891,128 ANNUAL FINANCIAL REPORT HE CITx OF COLUM IA HEIGHTS, MINNESOTA NNUA TINABECEMBER CIAL KEPQRT EAR kNDED 51, 19$1 INTERNAL SERVICE FUND 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 Page Central Garage Fund: Balance Sheet Form K 87 Statement of Revenues, Expenses, and Changes in Retained Earnings Form K -1 88 Statement of Changes in Financial Position Form K -2 89 Schedule of Property, Equipment and Accumulated Depreciation Form K -3 9p Form K CENTRAL GARAGE FUND COMPARATIVE BALANCE SHEET December 31, 1981 and 1980 CITY OF COLUMBIA NEI6NTS, MINNESOTA 7 #NNUAL FINANCIAL REPORT 1981 1980 ASSETS Current Assets: Cash - Treasurer's balance $ 1,505 $ 1,646 Investments, at cost 39,000 6,000 Accounts receivable 150 - Inventory, at cost 53,456 48,164 Total Current Assets $ 94,111 $ 55,810 Property and Equipment: Office furniture and equipment $ 741 $ 741 Machinery and equipment Total 65 315 63,912 ,056 $ Less: Accumulated depreciation 44,660 39,768 Net Property and Equipment -- Form 3 $ 21,396 $ 24,885 Total Assets $ 115,507 $ 80,695 LIABILITIES, CONTRIBUTIONS, AND RETAINED EARNINGS Current Liabilities: Accounts payable $ 2,371 $ 4,172 Accrued salaries payable 1,548 1,834 Accrued social security /P.E.R.A. 218 412 Total Current Liabilities $ 4,137 $ 6,418 Fund Equity: Contributed - other city funds $ 94,653 $ 94,653 Retained earnings (deficit) Reserved for improvements $ 26,000 $ - Unreserved Total Retained Earnings (9,283) 16,717 (20,376) $ 20,376) Total Fund Equity $ 111,370 $ 74,277 Total Liabilities and Fund Equity $ 115,507 $ 80,695 CITY OF COLUMBIA NEI6NTS, MINNESOTA 7 #NNUAL FINANCIAL REPORT CENTRAL GARAGE FUND COMPARATIVE STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS Years Ended December 31, 1981 and 1980 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 MEIGNTS, MINNESOTA 88 — Form K -1 1981 1980 $ 127,393 $ 136,884 $ 76,512 $% 82,128 24,184 22,203 8,052 11,378 5,222 6,651 $ 113,970 $ 122,360 $ 13,423 $ 14,524 4,892 4,929 $ 8,531 $ 9,595 $ 1,004 $ 567 1558 - - (720) $ 2,562 $ (153) $ 11,093 $ 9,442 (20,376) (29,818) 26,000 - $ 16,717 $ (20,,376) ONNUAL FINANCIAL REPORT CENTRAL GARAGE FUND COMPARATIVE STATEMENT OF CHANGES IN FINANCIAL POSITION Years Ended December 31, 1981 and 1980 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 Form K -2 1981 1980 $ 11,093 $ 9,442 4,892 4,929 $ 15,985 $ 14,371 26,000 - $ 41,985 $ 14,371 $ 1,403 $ - $ 1,403 $ - $ 40,582 $ 14,371 $ (141) $ (4,947) 33,000 6,000 150 (19) 5,292 5,193 2,281 144 8,000 $ 40,582 $ 14,371 L/ CITY OF COLUMBIA NEI6NTS, MINNESOTA 89 ANNUAL. FINANCIAL REPORT i Form K -3 vOi N cl M Y ' E m N N L 4a O N LL C to Q1 O O m to N M %D - U I %D Y 4-J C .- m m M E U m N O U tb r- Lt_ L t? N D O .. ♦O N L •-- i, m 1 m 00 00 Y IO r- U -le —T —T E O O m L U L H O Z C C Lt_ !- O Q Ln M 00 - �-- to O %D \O V Q O %0 1� W U - w C 00 C1 01 d m I M M W in m 1 CO 0 LJ Q J 00 Ln .- i tT U 00 L!1 %D U I Lf1 in L) Z U w m M O Q :J 1 Lf1 t0 Li M C m N %p -.p in lV m - W Z L u Q Q •- 1= w E t' Z U LJ C w O O Q a c 0 0 LJ W C Q U Lu w U F- m O cc O L N N M W )- p_ y _:r LA 0 C 00 w m 1 M CL .o %D m 1 Li m 0 LJ J C C LJ y = E u a V) - a +-J a� c a� E c fl. m L tV 44 .0 •C C m L � � m 4- L N O C �- U - .0 4- U 4- m O : E CITY OF M COLU BIA NEIGNTSI MINNESOTA 9p ANNUAL FINANCIAL REPORT JHE CITX OF COLUMBIA HEIGHTS, MINNESOTA N NUA TINA�ICIAL KEPQRT EAR tNDED LECEMBER S1, 1931 GENERIL FIRED ASSETS GROUP OF ICCOUNTS TABLE OF CONTENTS Statement of General Fixed Assets Form L P_ age 91 STATEMENT OF GENERAL FIXED ASSETS December 31, 1981 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 LCITY OF COLUMBIA NEIGNTS, MINNESOTA J 91 Fo rm L $ 3,025,100 2,672,299 200,330 624,817 943,563 769,870 $ 8,235,979 $ 90,000 150,000 325,000 510,000 929,475 $ 2,004,475 $ 526,290 267,203 $ 793,493 $ 1,186,035 51,550 $ 1,237,585 $ 4,200,426 $8,235,979 RNNUAL FINANCIAL REPORT HE CITX OF COLUM IA HEIGHTS, MINNESOTA NNUA A�VCIAL KEPORT EAR � 11 ECEMBER 31, 1931 GENERIL LONG-TER11 DEBT CROUP OF 4CCOUNTS TABLE OF CONTENTS Page Statement of General Long-Term Debt Form M 92 Schedule of Funding Available and Funds Required Form M -1 93 Schedule of Debt Service Requirements to Maturity Form M -2 94 STATEMENT OF GENERAL LONG -TERM DEBT December 31, 1981 AMOUNT AVAILABLE AND TO BE PROVIDED FOR THE PAYMENT OF GENERAL LONG -TERM DEBT Amount available in debt service funds Amount to be provided by future tax levies Total Available and to be Provided GENERAL LONG-TERM DEBT PAYABLE Fo rm M $ 928,749 7,971,251 $ 81900,000 General obligation bonds payable $ 8,900,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 $5,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. V/ .CITY Of .COLUMBIA •EIGHTS, MINNESOTA 92 ANNUAL FINANCIAL REPORT SCHEDULE OF FUNDING AVAILABLE AND FUNDS REQUIRED December 31, 1981 Form M -1 Total Cash, Investments, and Receivables $ 928,749 Deferred Tax Levies Levy /Payable Years: 1981/82 1,024,170 1982/83 862,958 1983/84 857,218 1984/85 851,918 1985/86 892,658 1986/87 939,698 1987/88 971,198 1988/89 998,498 1989/90 1,047,843 1990/91 1,064,648 1991/92 1,077,248 1992/93 1,059,398 1.993/94 1,118,198 1994/95 1,116,098 1995/96 1,056,563 1996/97 995,925 1997/98 934,185 1998/99 871,710 1999/00 808,500 2000/01 114,188 Total $18,662,825 FUNDING AVAILABLE $19,591,574 Bonds /Future Interest Payable Bonds $ 8,900,000 Future interest 9,407,582 FUNDS REQUIRED $18307,582 BALANCE $_11283,992 CITY OF COLUMBIA NEICNTS, MINNESOTA 93 MNUAI FINANCIAL REPORT SCHEDULE OF DEBT SERVICE REQUIREMENTS TO MATURITY December 31, 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 CITY OF COLUMBIA NEIGNTS, MINNESOTA Form M -2 General Obl icaation Bonds Principal Interest $ 340,000 $ 702,107 255,000 687,560 150,000 676,790 671,350 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 $8,900,000 $9,407,582 ANNUAL FINANCIAL KPORT HE CITX OF COLUMBIA HEIGHTS, MINNESOTA NNUAINA�ICIAL EPQRT iNDrED ER LECEMBER 31, 1981 STATISTICAL SECTION TABLE OF CONTENTS Page Assessed Value and Market Value of all Taxable Property Table 1 95-96 Tax Rates Table 11 97 City Tax Levy Table 111 98 Tax Levies and Tax Collections Table IV 99 -100 Special Assessment Collections Table V 99-100 Revenues - Other than Property Taxes and Special Assessments Table VI 101 Expenditures for Selected Functions Table VII 101 Statement of Legal Debt Margin Table VIII 102 Combining Schedule of Bonds Payable Table IX 103 -106 Schedule of Investments Table X 107 -108 Schedule of Insurance in` Force Table XI 109-110 Principal City Officials and Surety Bonds Table X11 111 Miscellaneious Statistical Facts Table XIII 112-113 ASSESSED VALUE AND MARKET VALUE OF ALL TAXABLE PROPERTY LEVY YEARS 1973 THROUGH 1981 (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 NEIGHTS, MINNESOTA i NA 95 ANNUAL FI NCIAL RETORT 1973 1974 1975 (1) 1976 Population 24,079 23,503 23,316 22,324 Real Property Assessed Value $ 56,287,399 $ 57,049,639 $ 62,748,967 $ 67,746,917 Area -wide allocation: Contribution $ (850,697) $ (850,697) Distribution $ 2,619f939 $ 2,355,131 Market Value $ 162,253,840 $ 164,040,324 $ 181,360,401 $ 198,140,355 Personal Property Assessed Value $ 1,278,820 $ 1,294,472 $ 1,230,101 $ 1,220,899 Market - commercial $ 2,973,256 $ 3,010,400 $ 2,860,700 $ 2,839,300 Total Real and Per- sonal Property Assessed Value $ 57,566,219 $ 58,344,111 $ 65,748,310 $ 70,472,250 Market Value $ 165,227,096 $ 167,050,724 $ 184,22.1;101 $ 200,979,655 Ratio of Total Assess- ed Value to Total Market Value :3484 :3492 :3569 :3506 Per Capita Valuations Assessed Value $ 2,391 $ 2,482 $ 2,820 $ 3,157 Market Value $ 6,862 $ 7,108 $ 7,901 $ 9,003 (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 NEIGHTS, MINNESOTA i NA 95 ANNUAL FI NCIAL RETORT 1977 21,890 $ 68,981,490 $ (1,085,236) 2,641,684 $ 219,125,884 $ 1,213,202 $ 2,821,400 $ 71,751,140 $ 221,947,284 1978 21,300 $ 71,601,406 $ (1,491,381) 3,311,002 $ 248,901,043 $ 1,221,501 $ 2,840,700 $ 74,642,528 $ 251,741,743 1979 21,270 $ 73,741,181 $ (1,840,970) 4,062,894 $ 288,414,300 $ 1,218,792 $ 2,834,400 $ 77,181,897 $ 291,248,700 1980 .20,029 $ 85,721,087 $ (2,000,000) 4,383,409 $ 355,767,800 $ 1,295,504 $ 3,012,800 Table I 1981 19,800 $ '969391,052 $ (3,908,286) 8,183,307 $ 399,395,650 $ 1,344,094 $ 3,125,800 $ 89,400,000 $ 102,010,167 $ 358,780,600 $ 402,521,450 :3233 :2965 :2650 :2548 2534 $ 3,279 $ 3,504 $ 10,139 $ 11,819 I CITY OF COLUMBIA NEIGNTS, MINNESOTA $ 3,629 $ 13,693 i 96 $ 4,563 $ 17,913 S 5,152 $ 20,329 ANNUAL FINANCIAL KPORT Table II TAX RATES YEARS 1972 THROUGH 1981 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 .60 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 1'979 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 (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 97 ANNUAL FINANCIAL REPORT Table III CITY TAX LEVY YEARS 1972 THROUGH 1981 (A) All for Storm Sewer Construction except 1976 the $100,000 is for settlement of Sullivan Lake law suit. (B) In 1979 Civil Defense Fund became a part of the General Fund. CITY OF COLUMBIA HEIGHTS, MINNESOTA 98 ANNUAL FINANCIAL KPORT 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 896,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 (A) All for Storm Sewer Construction except 1976 the $100,000 is for settlement of Sullivan Lake law suit. (B) In 1979 Civil Defense Fund became a part of the General Fund. CITY OF COLUMBIA HEIGHTS, MINNESOTA 98 ANNUAL FINANCIAL KPORT TAX LEVIES AND TAX COLLECTIONS Years 1974 Through 1981 * 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 V1. SPECIAL ASSESSMENT COLLECTIONS Years 1975 Through 1980 Collections Percentage Collection Current Special Current Collected of Current of Levy of Prior During Fiscal Period During Fiscal Period Years Taxes Collected Year's Taxes Year Total Tax During Fiscal During Fiscal During Fiscal Total Collected Levy Period Period Period Collections 1974 $ 874,954 $ 863,795 98.7 $ 10,136 $ 873,931 1975 1,022,810 995,242 97.3 16,563 1,011,805 1976 1,139,240 1,117,070 98.0 18,377 1,135,447 1977 1,136,825 1,123,704 98.8 22,470 1,146,174 1978 1,220,013 1,186,640 97.3 16,687 1,203,327 1979 1,253,698 1,236,676 98.6 20,648 1,257,324 1980 1,150,273 1,122,161 97.6 21,268 1,143,429 1981 1,090,455 1,074,134 98.5 39,938 1,114,072 * 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 V1. SPECIAL ASSESSMENT COLLECTIONS Years 1975 Through 1980 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. CITY OF COLUMBIA HEIGHTS, MINNESOTA 99 99 ANNUAL FINANCIAL KPORT 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.0% 1980 129,773 70,627 54.4% 1981 190,708 102,985 54.0% 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. CITY OF COLUMBIA HEIGHTS, MINNESOTA 99 99 ANNUAL FINANCIAL KPORT Table IV Delinquent Specials Collected During Fiscal Period (A) $ 71,642 67,434 65,345 46,218 43,693 41,215 70,016 Total Special Assessments Delinquent At End of Fiscal Period $ 116,642 111,221 98,553 66,142 71,605 87,512 111,314 Table V Deferred Special Assessments Collected Balance Fund Ratio of Fiscal Period Accumulated Ratio 206,197 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 Delinquent Specials Collected During Fiscal Period (A) $ 71,642 67,434 65,345 46,218 43,693 41,215 70,016 Total Special Assessments Delinquent At End of Fiscal Period $ 116,642 111,221 98,553 66,142 71,605 87,512 111,314 Table V Deferred Special Assessments Collected Balance Fund Fiscal Period of Fiscal Period $ 75,305 $ 372,361 206,197 388,565 104,930 388,481 155,037 436,962 78,080 411,494 136,281 602,047 287,194 509,999 (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 NEIGHTS, MINNESOTA � 100 0 ANNUAL FINANCIAL KPORT Table VI Table VII EXPENDITURES FOR SELECTED FUNCTIONS Years 1972 through 1981 Fiscal General REVENUES- OTHER THAN PROPERTY TAXES Parks and Year AND SPECIAL ASSESSMENTS Works Sanitation Library Recreation Years 1972 Through 1981 $ 605,120 $ 357,901 $ 196,700 $ 75,500 $ 333,047 Charges for Licenses 685,606 (A) Fiacal Revenues From Use of Money Service and and Fines and Profits of Year Other Agencies and Property Other Revenue Permits Forfeitures Proprietaries 224,569 147,851 463,877 1972 $ 817,715 $ 44,535 $ 311,790 $ 33,823 $ 13,557 $ 238,732 1973 1,285,224 37,473 312,824 37,216 21,680 308,080 1974 1,070,363 112,407 329,122 41,259 20,181 361,747 1975 1,304,408 89,266 341,341 47,807 29,573 298,283 1976 1,635,915 172,632 295,683 62,079 47,096 261,837 1977 1,883,756 144,293 342,277 71,228 50,406 128,169 1978 2,059,462 135,292 313,456 76,870 38,191 106,014 1979 2,096,084 179,135 369,891 78,164 49,067 32,521 1980 2,272,119 474,873 419,930 68,710 72,274 106,845 1981 2,857,636 966,078 997,236 104,027 67,301 835,981 (A) The years 1972-77 do not include depreciation for Sewer and Water Funds. Table VII EXPENDITURES FOR SELECTED FUNCTIONS Years 1972 through 1981 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 I CITY Of COLUMBIA NEIGNTS, MINNESOTA J 101 +ANNUAL FINANCIAL KPORT STATEMENT OF LEGAL DEBT MARGIN December 31, 1981 Assessed Value Debt Limit 6.67% of Assessed Value (Note A) Amount of Debt Limit Applicable to Debt Limit: Total bonded debt Less Note B: Tax increment $ 8,175,000 Special Assessment Bonds 5,000 Total Debt Applicable to Debt Limit Legal Debt Margin $ 8,905,000 8,180,000 Table VIII $102,010,167 * 6,804,078 725,000 $ 6,079,078 Note (A): M.S.A. Section 475.53 (Limit on Net Debt) "Subdivision 1. Generally. Except as other wise 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) Obligations issued for improvements which are payable wholly or partly from the proceeds of special assessments levied upon property specially benefited thereby, including those which are general obligations of the municipal issuing them, if the municipality is entitled to reimbursement in whole or in part from the proceeds of the special assessments. (2) Warrents or orders having no definite or fixed maturity. (3) Obligations payable wholly from the income from revenue producing conveniences. (4) Obligations issued to create or maintain a permanent improvement revolving fund. (5) Obligations issued for the acquisition, and betterment of public waterworks systems, and public lighting, heating or power systems, and of any combination thereof or for any other public convenience from which a revenue 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 L�-/ 102 ANNUAL FINANCIAL REPORT COMBINING SCHEDULE OF BONDS PAYABLE December 31, 1981 Interest Final Rates and Issue Maturity Dates Date Date SPECIAL ASSESSMENT BONDS: Permanent Improvement Revolving Bonds of 1972 7 -1 -72 1 -1 -83 Non - Callable 4.30% 1/1 -7/1 Total P.I.R. Bonds of 1972 GENERAL OBLIGATION BONDS: Storm Sewer Bonds of 1965 All Callable after January 1, 1980 in 1/1 -7/1 inverse order at par and accrued 3.60% Interest plus a premium of $50 per bond 3.60% 3.60% Total Storm Sewer Bonds of 1965 City Garage Bonds of 1972 Non- Callable 4.30% 1/1 -7/1 10 -1 -65 1 -1 -85 7 -1-72 1 -1 -83 Total City Garage Bonds of 1972 Capital Improvement Bonds of 1976 4-1 -76 Non - Callable 4.45% 4/1 -10/1 4.6o% Total Capital Improvement Bonds of 1.976 10 -1 -83 CITY Of, COLOMBIA MEICNTS, MINNESOTA 103 MNUAL FINANCIAL KPORT Annual Authorized Serial and Payments Issued $ - $ 450,000 5,000 (82) 5,000 $ 456,000 $ - Matured $ 540,000`; 105,000 (82) 450,000 i 105,000 130,000 (83) - 130,000; 140,000 (84) $ 140,000, $ 5,000 $ 915,000 $ - 540,000 $ 450,000 60,000 (82) $ 60,000 - $ 510,000 $ - - $ 730,000 175,000 (82) 54o,000 175,000 115,000 (83) 450,000 115,000 - - r 60,000 $ 1,020,000 L CITY OF COLUMBIA MEIGNTS, NINNJ ESOTA 104 Table IX MNUAL FINANCIAL KPORT Matured Outstanding $ 450,000 i $ - - 5,000 $ 450,000 $ 5,000 $ 540,000 $ - $ - $ 105,000 - 130,000 - 140,000 $ 54o,000 $ 375,000 $ 450,000 $ - - 60,000 $ 450,000. $ 60,000 $ 730,000 $ - - 175,000 - 115,000 $ 730,000 $ 290,000 ��t �l MNUAL FINANCIAL KPORT COMBINED SCHEDULE OF BONDS PAYABLE (Continued) December 31, 1981 Total Tax Increment Bonds of 1980 Total General Obligation Bonds Total Bonds Payable - All Funds CITY OF COLUMBIA MEIGNTS, MINNESOTA 1J ANNUAL FINANCIAL KPORT Interest Final Rates and Issue 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 °b 3/1 -9/1 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.00 8.10 8.25 8.40 8.50 8.60 8.75 8.75 Total Tax Increment Bonds of 1980 Total General Obligation Bonds Total Bonds Payable - All Funds CITY OF COLUMBIA MEIGNTS, MINNESOTA 1J ANNUAL FINANCIAL KPORT Annual Authorized Serial and Payments Issued $ 8,175,000 CITY OF COLUMBIA NEIGNTS, MINNESOTA Table IX 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 $ 8,900,000 $ 8,905,000 106 ANNUAL FINANCIAL REPORT (82) 10,000 (83) 10,000 10,000 (84) 10,000 (85) 140,000 (86) 14o,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 CITY OF COLUMBIA NEIGNTS, MINNESOTA Table IX 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 $ 8,900,000 $ 8,905,000 106 ANNUAL FINANCIAL REPORT SCHEDULE OF INVESTMENTS December 31, 1981 CITY OF COLUMBIA MEIGNTS, MINNESOTA 107 ANNUAL FINANCIAL REPORT Date Maturity Par Yield Acquired Date Value Federal National Mortgage Association 11.97 9 -16 -80 4 -12 -82 $ 300,000 Certificate of Deposit - N.E. State Bank 10.875 11 -30 -81 1 -12 -82 400,000 Certificate of Deposit - N.E. State Bank 12.375 12 -28 -81 12 -28 -82 385,000 Repurchase Agreement 11.125 12 -30 -81 1 -04 -82 300,000 Certificate of Deposit - N.E. State Bank 12.175 12 -21 -81 1 -21 -82 165,000 Certificate of Deposit - N.E. State Bank 12.175 12 -22 -81 1 -22 -32 500,000 Ginny Mae 7.58 3 -23 -77 3 -01 -06 189,944 U.S. Treasury Note 8.32 6 -12 -80 5 -31 -82 150,000 U.S. Treasury Note 8.92 7 -03 -80 6 -30 -82 300,000 U.S. Treasury Note 9.20 6 -30 -80 6 -30 -84 100,000 U.S. Treasury Note 8.95 11 -02 -81 8 -15-85 500,000 Repurchase Agreement 13.875 11 -02 -81 1 -28 -82 700,000 Repurchase Agreement 11.875 12 -28 -81 1 -08 -82 100,000 Repurchase Agreement 11.125 12 -08 -81 1 -11 -82 328,813 City of Columbia Heights Storm Sewer Bonds 1965 4.83 10 -01 -69 1 -01 -84 10,000 $4,428,757 CITY OF COLUMBIA MEIGNTS, MINNESOTA 107 ANNUAL FINANCIAL REPORT Unamortized Unamortized Book Discount Premium Value $ - $ 1,506 $ 301,506 - - 400,000 - - 385,000 - - 300,000 - - 165,000 - - 500,000 - - 189,944 - 2,019 152,019 1,274 - 298,726 932 - 99,068 - 12,001 512,001 - - 700,000 - - 100,000 328,813 2,550 - 7,450 $ 4,756 $ 15,526 $4,439,527 I CITY OF COLUMBIA NEIGNTS, MINNESOTA 108 Table X Summary By Fund General Fund - Form B $ 349,000 Special Revenue Funds - Form C 186,000 Debt Service Funds - Form D 885,000 Capital Projects Funds - Form E 1,532,077 Enterprise Funds - Form G 1,448,450 Central Garage Funds - Form K 39.000 $ 4,439,527 #NNUAL FINANCIAL REPORT SCHEDULE OF INSURANCE IN FORCE December 31, 1981 Policy Period Building Type of Coverage from to or Structure Contents All Risk Coverage under the Public and Institutional Property Policy 1 -1 -81 12 -31 -81 (90% Coinsurance -$500 Deductible) 40th Avenue Liquor Store University Avenue Liquor Store (90% Coinsurance -$500 Deductible) City Hall Library City Garage Liquor Store -40th Avenue Liquor Store - University Avenue Community Center Parks (II) Well House - LaBelle Park Band Stand Bath House - Silver Lake Warming House-Silver Lake Lift Stations (3) Water Tower Pump Stations (2) Warehouse- Cement Warehouse -Metal Water Meter Vault Tema House ($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 CITY OF ,,COLUMBIA NEIGHTS, MINNESOTA U l09 $ 50,000 70,000 $120,000 $ 1,385,218 $266,200 516,203 222,541 1,381,228 106,480 82,873 8,943 128,058 13,541 706,578 36,608 877,874 2,398 12,575 32,245 42,683 9,680 63,422 275,275 73,939 61,171 39,566 1,463 9,968 8,745 3,993 18,150 $ 5,664,280 $723,338 $991,887 $919,839 MINUAL FINANCIAL REPORT Type of Coverage Boiler explosion Workman's Compensation Comprehensive Auto Liability Bodily Injury Property Damage Uninsured Motorists Automotive Physical Damage Comprehensive Bus Liability Bodily Injury Property Damage Uninsured Motorists Comprehensive General Liability Bodily Injury Property Damage Statutory Liquor Legal Liability Public Official Liability Policy Period f rom to 1 -1 -81 12 -31 -81 1 -1 -81 12 -31 -81 1 -1 -81 12 -31 -81 4 -13 -81 4 -13 -82 Table XI 0 $100,000 per accident Statutory $300,000 $100,000 $250 Deeizt1bl $ 50,000 $ 500 deductible $406,000 Fire $100/300,000 $100,000 $25%50,000 1 -1 -81 12 -31 -81 $500,000 $500,000 1-1-81 12 -31 -81 $500,000 1 -29 -81 1 -29 -82 $1,000,000 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. CITY OF COLUMBIA NEIQHTS, MINNESOTA ANNUAL FINANCIAL REPORT 110 ►15 -10, Mayor and Council: Bruce G. Nawrocki Kenneth E. Hentges Gayle R. Norberg Arden Hovland Rita M. Petkoff Administration: Robert S. Bocwinski Keith Masuda William Elrite Ronald Kalina Fred Salsbury George Brown Mildred Carlson Stuart Anderson _Donald Johnson Max Thomas Carl Norlander Martin Gavic Carl Norlander Donald Weinand Allen Carlson Mitch DeMars Donald Jolly Thomas Rejzer Linda Hansen PRINCIPLE CITY OFFICIALS AND SURETY BONDS Year Ended December 31, 1981 Official title Mayor Councilmember Councilmember Councilmember Councilmember Table X1 Amount of Surety Bond City Manager Administrative Assistant Acting City Clerk- Treasurer - Finance Director - Liquor Operations Manager City Attorney Public Works Director City Engineer City Assessor Chief of Police Chief of Fire Liquor Store Manager Building Inspector Plumbing Inspector Heating Inspector Electrical Inspector City Planner Street Superintendent Water and Sewer Superintendent Acting Park Superintendent Recreation and Community Services Director 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. $ 50,000 $ 50,000 ANNUAL FINANCIAL KPORT .CITY OF COLUMBIA MEIGNTS, MINNESOTA 111 _ __ MISCELLANEOUS STATISTICAL FACTS 1981 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: 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 Estimated Cost: 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 CITY OF COLUMBIA NEIGNTS, MINNESOTA 112 Table XIII March 14, 1898 July 21, 1921 Council- Manager .January 1 3.52 Square Miles 3.0 6.2 61.7 U. 32.7 59.8 65.6 613 518 529 485 608 595 658 687 663 555 644 $ 4,044,282 2,180,740 2,032,525 2,916,519 3,148,524 3,412,415 4,701,644 6,996,678 3,316,115 3,264,460 8,822,479 MINUAL FINANCIAL KPORT 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, 1981) Regular Part time Temporary Elections: Registered voters - last city general election Number of voters 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 j CITY Of COLUMBIA NEI6NTS, MINNESOTA 113 Table XIII 1 24 12 1 1 1 1 3 1 104 53 8 175 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 &NNUAL FINANCIAL REPORT