Loading...
HomeMy WebLinkAbout1993 CAFRr COMPREHENSIVE ANNUAL FINANCIAL REPORT rOF THE CITY OF COLUMBIA HEIGHTS ' STATE OF MINNESOTA FOR THE YEAR ENDED DECEMBER 31, 1993 Prepared By: Finance Department CITY OF COLUMBIA HEIGHTS, MINNESOTA TABLE OF CONTENTS LL INTRODUCTORY SECTION Principal City Officials Organizational Chart Letter of Transmittal ' Certificate of Achievement for Excellence in Financial Reporting H. FINANCIAL SECTION Independent Auditor's Report General Purpose Financial Statements Combined Balance Sheet - All Fund Types and Account Groups Combined Statement of Revenues, Expenditures and Changes in Fund Balance - All Governmental Fund Types and Expendable Trust Funds Combined Statement of Revenues, Expenditures and Changes in ' Fund Balance - Budget and Actual - General and Special Revenue Fund Types Combined Statement of Revenues, Expenses and Changes in ' Retained Earnings - Proprietary Fund Types Combined Statement of Cash Flows - all Proprietary Fund Types Notes to Financial Statements Combining. Individual Fund and Account Group Financial Statements General Fund: Balance Sheet Statement of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual ' Schedule of Revenues - Budget and Actual Schedule of Expenditures - Budget and Actual Reference Page Number 3 5 7 15 19 Statement 1 22 Statement 2 26 Statement 3 28 Statement 4 30 Statement 5 31 33 Statement 6 71 Statement 7 72 Statement 8 74 Statement 9 75 CITY OF COLUMBIA HEIGHTS, MINNESOTA TABLE OF CONTENTS Reference Special Revenue Funds: Combining Balance Sheet Statement 10 Combining Statement of Revenues, Expenditures and Changes in Fund Balance Statement 11 Statement of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual: Statement 27 Municipal State Aid Street Fund Statement 12 Cable Television Fund Statement 13 Paratransit Fund Statement 14 D.A.R.E. Program Statement 15 Library Fund Statement 16 Comparative Statement of Revenues, Expenditures and Changes in Fund Balance: Statement 31 Housing Mortgage Statement 17 Recreation Contributed Projects Statement 18 Contributed Projects Statement 19 Community Police Statement 20 Project Pride Statement 21 Parking Ramp Statement 22 Debt Service Funds: Combining Balance Sheet Statement 23 Combining Statement of Revenues, Expenditures and Changes in Fund Balance Statement 24 Capital Project Funds: Combining Balance Sheet Statement 25 Combining Statement of Revenues, Expenditures and Changes in Fund Balance Statement 26 Enterprise Funds: Combining Balance Sheet Statement 27 Combining Statement of Revenues, Expenses and Changes in Retained Earnings Statement 28 Combining Statement of Cash Flows Statement 29 Water Utility Fund: Balance Sheet Statement 30 Statement of Revenues, Expenses and Changes in Retained Earnings Statement 31 Statement of Cash Flows Statement 32 Page Number 78 80 82 ' 83 84 ,85 86 87 88 89 90 91 '92 95 ' 96 ' 100 102 ' 106 107 108 110 ' 111 ,112 CITY OF COLUMBIA HEIGHTS, MINNESOTA TABLE OF CONTENTS Reference Page Number Sewer Utility Fund: Balance Sheet Statement 33 113 Statement of Revenues, Expenses and Changes in 1 Retained Earnings Statement 34 114 Statement of Cash Flows Statement 35 115 Refuse Utility Fund: Balance Sheet Statement 36 116 ' Statement of Revenues, Expenses and Changes in Retained Earnings Statement 37 117 Statement of Cash Flows Statement 38 118 Liquor Fund: Balance Sheet Statement 39 119 Statement of Revenues, Expenses and Changes in ' Retained Earnings Statement 40 120 Statement of Cash Flows Statement 41 121 1 Internal Service Funds: Combining Balance Sheet Statement 42 124 Combining Statement of Revenues, Expenses and Changes in Retained Earnings Statement 43 125 Combining Statement of Cash Flows Statement 44 126 Central Garage Fund: Balance Sheet Statement 45 127 Statement of Revenues, Expenses and Changes in Retained Earnings Statement 46 128 Statement of Cash Flows Statement 47 129 Energy Management Fund: Balance Sheet Statement 48 130 Statement of Revenues, Expenses and Changes in Retained Earnings Statement 49 131 Statement of Cash Flows Statement 50 132 ' Insurance Fund: Balance Sheet Statement 51 133 Statement of Revenues, Expenses and Changes in Retained Earnings Statement 52 134 Statement of Cash Flows Statement 53 135 CITY OF COLUMBIA HEIGHTS, MINNESOTA TABLE OF CONTENTS Supplementary Financial Information Combining Schedule of Bonds Payable Exhibit 1 154 Schedule of Sources and Uses of Public Funds For Housing and Redevelopment Authority Tax Increment Financing Districts Exhibit 2 158 Note - Sources of Funds For Housing and Redevelopment Authority Tax Increment Financing Districts Exhibit 3 159 III. STATISTICAL SECTION Reference Page Number Trust and Agency Funds: Fiduciary Funds: Table 1 162 Combining Balance Sheet Statement 54 138 Expendable Trust Funds: Table 3 164 Combining Statement of Changes in Assets and Liabilities Statement 55 139 Fiduciary Funds: Table 5 166 Combining Statement of Changes in Assets and Liabilities - All Agency Funds Statement 56 140 Housing and Redevelopment Authority Funds: Combining Balance Sheet Statement 57 142 Combining Statement of Revenues, Expenses and Changes in Fund Balance - All Governmental Fund Types Statement 58 144 General Fixed Assets Account Group: Comparative Schedule of General Fixed Assets - By Source Statement 59 146 Schedule of Changes in General Fixed Assets - By Function and Activity Statement 60 147 Schedule of General Fixed Assets - By Function and Activity Statement 61 148 General Long -Term Debt Account Group: Schedule of General Long -Term Debt Statement 62 150 Schedule of Debt Service Requirements to Maturity Statement 63 151 Supplementary Financial Information Combining Schedule of Bonds Payable Exhibit 1 154 Schedule of Sources and Uses of Public Funds For Housing and Redevelopment Authority Tax Increment Financing Districts Exhibit 2 158 Note - Sources of Funds For Housing and Redevelopment Authority Tax Increment Financing Districts Exhibit 3 159 III. STATISTICAL SECTION Assessed Value, Tax Capacity, and Estimated Actual Value of all Taxable Property (A) - 1984 Through 1993 Table 1 162 Tax Rates - Years 1984 Through 1993 Table 2 163 City Tax Levy - Years 1984 Through 1993 Table 3 164 Tax Levies and Tax Collections - Years 1984 Through 1993 Table 4 165 Special Assessment Levies and Collections - Years 1984 Through 1993 Table 5 166 I CITY OF COLUMBIA HEIGHTS, MINNESOTA TABLE OF CONTENTS ' Reference Page Number General Governmental Revenues By Source - Years 1984 Through 1993 Table 6 167 ' General Governmental Expenditures By Function - Years 1984 Through 1993 Table 7 168 Principal City Officials Table 8 169 Miscellaneous Statistics Table 9 170 Principal Taxpayers Table 10 172 Computation of Legal Debt Margin Table 11 173 Computation of Direct and Overlapping Debt Table 12 174 Property Value, Construction and Bank Deposits - Years 1984 Through 1993 Table 13 175 IV. SINGLE AUDIT AND OTHER REQUIRED REPORTS SECTION Independent Auditor's Report on Supplementary Information - ' Schedule of Federal Financial Assistance 179 Schedule of Federal Financial Assistance 181 Independent Auditor's Report on Compliance With General Requirements Applicable to Federal ' Financial Assistance Program 183 Independent Auditor's Report on the Compliance with Nonmajor Federal Financial Programs 185 'Assistance Independent Auditor's Report on the Internal Control Structure in Accordance With Government Auditing Standards 187 Independent Auditor's Report on the Internal Control Structure Used in Administering Federal Financial Assistance Programs 191 Independent Auditor's Compliance Report based on an Audit of the General Purpose Financial Statements Performed in Accordance with Government Auditing Standards 197 I. INTRODUCTORY SECTION 1 CH Fa CITY OF COLUMBIA HEIGHTS, MINNESOTA 1 CITY OF COLUMBIA HEIGHTS, MINNESOTA PRINCIPAL CITY OFFICIALS 1 December 31, 1993 CITY COUNCIL Donald J. Murzyn, Jr., Mayor Joseph Sturdevant, Mayor - Elect ' Gary L. Peterson Councilmember Bruce G. Nawrocki Councilmember Sean T. Clerkin Councilmember tRobert W. Ruettimann Councilmember CITY MANAGER Patrick Hentges FINANCE DEPARTMENT William J. Elrite, Finance Director June V. Johnston, Assistant Finance Director Gary Braaten, Accounting Coordinator ' 3 (H CITY OF COLUMBIA HEIGHTS, MINNESOTA City of Columbia Heights Mayor: t7flllAt Council Secretary*: Jo-Anne Student City Pay POLICE (ADMINISTERED BY MAYOR) Police Chief: David Mawhorter Secretary II Clerk- Typist II 1 Police Captain Patrol Sargeants (4) Patrol Officers (15) Comm. Service Officers (2 FT & 2 PT) Sr. Records Technician Secretary II-A (2) Clerk- Tvnist II (PT) FIRE Fire Chief: Charles Kewat, Secretary H (PT) Deputy Fire Chief Firefighters (6) Volunteer Firefighters 25 LIBRARY Library Director: M. Rebecca Loader Clerk- Typist II (2) Library Supervisor (5 PT) Page (8 PT) Choreperson (PT) Adult Service Specialist Children's Librarian Organizational Chart Councilmembers: Gary L. Peterson Bruce G. Nawiocld Sean T. Clercin ' RECREATION Recreation Director: Marc Casey ' Clerk - Typist II (2) Senior Citizen Coordinator Head Custodian Custodian II (2 PT) Custodian I 2 *Also serves in the capacity of Deputy City Clerk under the Finance Director /City Clerk/Treasurer. Asst to City Manager Special Projects Coord. Special Assessments Accounting Clerk II Clerk- Tvnist H (PT) Commissions & Boards: Charter HRA Police, Fire & Civil Svc. Downtown Development Insurance Traffic Cable Communications Planning & Zoning Human Services Patio Merit Library BUILDING INSPECTIONS Building Inspector Asst Building Inspector Secretary II FINANCE Finance Director /City Clerk/Treasurer: William Elrite Secretary II (PT) Assistant Finance Director Accounting Coordinator Payroll/Accounting Cleric Utilities Accounting Clerk II Utilities Accounting Cleric I Switchboard Operator/Receptionist Meter Readers (2 PT) Liquor Operations Manager Asst. Operations Managers (2) Retail Clerks (17 PT) Liquor Store Supervisor Elections PUBLIC WORKS Public Works Director /City Engineer: Marc Winson Secretary II -A Clerk- Typist II Assistant City Engineer Engineering Technician IV Engineering Technician III Engineering Technician II Public Works Superintendent Foreman (3) Maintenance III (1) Maintenance R (6) Maintenance I (9) Foreman- Vehicle Maintenance Maintenance III - Mechanic Maintenance III - Bodyman/Painter Admin. Assistant- Public Works Clerical/Purchasing Clerk 5 CH CITY OF COLUMBIA HEIGHTS, MINNESOTA CITY OF COLUMBIA HEIGHTS 590 40th Avenue N. E. Columbia Heights, MN 55421 -3878 (612) 782 -2800 April 30, 1994 Mayor Joseph Sturdevant Councilmembers Donald G. Jolly Bruce G. Nawrocki Gary L. Peterson Robert W. Ruettimann City Manager Patrick Hentges To the Citizens of the City of Columbia Heights, Mayor, Councilmembers, and City Manager The Comprehensive Annual Financial Report of the City of Columbia Heights for the fiscal year ended December 31, 1993 is hereby submitted. The responsibility for both the accuracy of the presented data and the completeness and fairness of the presentation, including all disclosures, rests with the City. To the best of our knowledge and belief, the enclosed data is accurate in all material respects and is reported in a manner designed to present fairly the financial position and results of operations of the various funds and account groups of the City. All disclosures necessary to enable the reader to gain an understanding of the City's financial activities have been included. The Comprehensive Annual Financial Report is presented in four sections: Introductory, Financial, Statistical, and Other Required Reports. The Introductory Section includes this transmittal letter, the City's organizational chart, and a list of principal officials, and a reproduction of the Certificate of Achievement for the prior year. The Financial Section includes the general purpose financial statements, the combining and individual fund and account group statements and schedules, as well as the auditor's report on the financial statements and schedules. The Statistical Section includes selected financial and demographic information, generally presented on a multi- year basis. The City is required to undergo an annual single audit in conformity with the provisions of the Single Audit Act of 1984 and the United States Office of Management and Budget Circular A -128, Audits of State and Local Governments and a Minnesota Legal Compliance Audit. Information related to this single audit and compliance audit, including the Schedule of Federal Financial Assistance, is included in the Single Audit and Other Required Reports Section. This report includes all funds and account groups of the City. The City provides a full range of services to its citizens. These services include, but are not limited to, police and fire protection; sanitation services; the construction and maintenance of highways, streets, and infrastructure; library; recreational facilities; cultural events; and general administrative services. The Housing and Redevelopment Authority (HRA) is included in the reporting entity as a component unit due to the fact that the mayor appoints the governing board of the Authority and the City is in a relationship of financial benefit or burden with the Authority. �_ "SERVICE IS OUR BUSINESS" EQUAL OPPORTUNITY EMPLOYER � CH CITY OF COLUMBIA HEIGHTS, MINNESOTA ECONOMIC CONDITION AND OUTLOOK The City of Columbia Heights, which is a suburb located north of the City of Minneapolis in Anoka County in east - central Minnesota, was originally incorporated as a village in 1898. In 1921, pursuant to the adoption of a home rule City Charter by the qualified voters of the City, a Council- Manager form of government was instituted. The City covers an area of 3.52 square miles and its population is 18,910 according to 1990 census figures. During 1993, City Council and City Staff undertook a proactive approach to correct housing deficiencies within the City. The housing maintenance code and licensing program was significantly improved in terms of administration. An area of the City known as the Sheffield neighborhood was targeted for improvement in housing and crime conditions. Ultimately, the City purchased 13 duplex buildings (26 dwelling units) that were the center of controversy in the neighborhood These purchases, together with a significant law enforcement effort, served to stabilize the area. During 1994, the City and the Housing and Redevelopment Authority will finalize a comprehensive redevelopment plan for the neighborhood and move into the implementation stage. Employment in the City has remained stable, and the City is promoting the expansion and creation of new businesses in the community. In April, the City expanded its liquor operation by opening a third liquor store. This expansion resulted in the generation of 11 full- and part-time positions in Columbia Heights. Economic conditions have continued to remain stable in the City. As a result of effective financial management, the City continues to maintain a strong financial position and that trend is expected to continue. ■ MAJOR INTTIATTVES For the Year Stuart Anderson retired as City Manager, and Patrick Hentges was appointed and assumed the responsibility effective March 15, 1993. Although the change resulted in a level of transitional learning for the City Manager and the employees, many significant projects were started and changes implemented The Finance Department completed a contract with the Housing and Redevelopment Authority for the Finance Department to undertake all of the HRA's accounting services. Early in the year, all of the HRA's records were converted to the City's accounting system. This conversion was very lengthy and time- consuming, but provided the HRA with a much more complete and detailed set of accounting records. It is anticipated that more improvements will be made to the HRA records in 1994. During the year, Library operations circulated 151,000 items including books, compact disks, videos, audio cassettes, and a camcorder purchased by the Cable Commission for library use and checkout to patrons. The children's program received generous donations from local area clubs which enabled the Library to provide live performers every Tuesday during the summer months. Adult programs included delivery of materials to homebound, "Elect to Read" election promotion, and an adult reading club. The Library also participated as a Toys for Joy depot and a dropbox site for Project Bookshelf. Columbia Heights Public Library staff are dedicated to providing top quality library service to all patrons. E For the Future The Paid Fire Relief Association was consolidated into PERA Police & Fire Fund effective January 1, 1994. This consolidation will likely result in substantial savings of pension costs for the City in future years. Similar discussion is underway for the Police Relief Association Pension Fund. The Volunteer program will continue development in the future. This program should enable the City to undertake projects with volunteers that would otherwise not be done. Volunteers should also enhance the performance of City staff. The City Council and staff will finalize a comprehensive redevelopment plan for the Sheffield neighborhood and move into implementation of the plan. General Government Functions Revenues for City general government functions (General, Special Revenue, Debt Service and Capital Project Funds) during 1993 totaled $9,579,145, which is an decrease of 2.1% from 1992. Property taxes received for the City produced 38% of general revenues compared to 36% last year The amount of revenues from various sources and their changes from last year are shown below: Percent Revenue Source Amount of Total Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeitures Interest Other revenue Total revenues $3,593,244 352,481 135,545 3,782,752 464,887 89,464 1,015,755 145,017 38% 4% 1% 39% 5% 1% 11% 2% Amount of Increase (Decreasc) from 1992 $96,524 37,467 10,270 277,779 22,251 (15,209) 212,362 (849,341) $9,579,145 100% ($207,897) There was no increase in the tax levy for 1993. Tax revenue increased due to an increase in the area wide tax. The increase in intergovernmental revenue was due to monies received from the State for street maintenance and construction. 10 The expenditures for City general government functions for 1993 totaled $10,909,026, an increase of 15.0% from 1992. The total expenditures for major City functions and their changes from last year are shown below: Expenditure Function General government Public safety Public works Sanitation Parks and recreation Library Other & contingencies Capital outlay Debt service Total expenditures Percent Amount of Total Amount of Increase (use) from 1992 $1,441,603 13% $84,808 2,679,272 25% 115,484 806,990 7% (12,310) 149,054 1% (27,162) 1,040,459 10% (3,562) 374,625 3% (9,308) 313,538 3% 56,625 1,139,792 logo 526,330 2,963,693 27% 690,891 $10,909,026 100% $1,421,796 The increase in capital outlay was due to the purchase of 13 duplex buildings in the Sheffield neighborhood. The increase in debt service was due to the early payment of the 1987 Public Improvement Bond. General Fund Balance The fund balance of the General Fund increased by $256,073 or 8.8 %. The total fund balance of $3,181,939 indicates a strong financial position. It should be pointed out, however, that this represents working capital for general operations, which is used extensively during the first seven months of the year until current taxes and state aids are received. Enterprise Operations The City's enterprise operations are comprised of water, sewer and refuse utilities and municipal liquor operations. Total sales from the City's off -sale liquor locations amounted to $5,204,404 in 1993. This resulted in a total net operating income of $189,018. Liquor operations were expanded to three stores in 1993 and growth and profitability are expected to continue. Water and Refuse Utilities experienced operating income increases during 1993. The Sewer Utility Fund experienced a slight loss due to a change in accounting procedures during the year. The Water Utility Fund experienced an operating income of $47,346 during the year, and the Refuse Utility experienced an operating income of $240,223 during 1993, an increase of $79,358 over 1992. During the year, the City Council designated funds from the Sewer and Water Utilities for capital equipment replacement and construction. 11 The City maintains three Internal Service Funds - the Central Garage Fund, the Energy Management Fund and the Insurance 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. In 1993, the Central Garage Fund had a net income of $21,286. The Energy Management Fund was established to account for energy maintenance and improvement in City buildings under a seven -year energy savings contract with Honeywell, Inc. The Insurance Fund was established at a time when the City did not carry commercial liability insurance to pay for any claims arising during that time period The fund is currently maintained to fund deductible amounts and to pay any claims that may arise in the future that exceed the current coverage. Trust and Agency Funds unds Agency Funds are used to account for assets held by the City in an agency capacity for individuals, private organizations, other governments, or other funds. The City has Agency Funds for deferred compensation, permit surcharge, and escrow. Trust Funds are used to account for assets held by the City in a trustee capacity. The City has expendable trust funds for compensated absences and flex benefits. Cash Mana eg ment Cash temporarily idle during the year was invested in demand deposits, certificates of deposit, obligations of the U.S. Treasury, repurchase agreements, and commercial paper. The average yield on investments for the year was 6.85 %. The City's investment policy is to minimize credit and market risks while maintaining a competitive yield on its portfolio. Accordingly, deposits were either insured by federal depository insurance or collateralized Debt Administration At December 31, 1993, the City has a number of debt issues outstanding. These issues included $17,209,721 of General Obligation Tax Increment Bonds. The City issued $6,670,000 in General Obligation Tax Increment Refunding Bonds in 1991 to refund the Tax Increment Refunding Bonds of 1987. Bond proceeds were placed in an escrow account until the call date, March 1, 1994. The City issued $735,000 of General Obligation Tax Increment Taxable Refunding Bonds in 1993 to refund $710,000 General Obligation Tax Increment Taxable Bonds of 1987. This refunding resulted in a net savings to the City. Risk Mana eg ment The City maintains commercial insurance coverage for liability, property, liquor liability, and workers' compensation. As previously stated, the City maintains an Internal Service Fund for insurance. The Insurance Fund maintains a reserved balance to provide funds if needed for excess claims or deductibles. This fund charges individual departments for allocation of premiums and for claims incurred. There were no significant claims pending at year end for the City. 12 OTHER INFORMATION S 1: 4 • State Statutes require an annual audit by independent certified public accountants. The accounting firm of Tautges, Redpath & Co., Ltd. was selected by the City. In addition to meeting the requirements set forth in State Statutes, the audit was also designed to meet the requirements of the Federal Single Audit Act of 1984 and related OMB Circular A -128. The auditor's report on the general purpose financial statements and combining and individual fund and account group statements and schedules is included in the Financial Section of this report. Awards The Government Finance Officers' Association (GFOA) awarded a Certificate of Achievement for Excellence in Financial Reporting to the City for its Comprehensive Annual Financial Report for the year ended December 31, 1992. In order to be awarded a Certificate of Achievement, the City published an easily readable report that satisfied both generally accepted accounting principles and applicable legal requirements. A Certificate of Achievement is valid for one year only. We believe that our current Comprehensive Annual Financial Report continues to meet the Certificate of Achievement Program's requirements and we are submitting it to the GFOA to determine its eligibility for another certificate. Acknowledgments The preparation of the Comprehensive Annual Financial Report on a timely basis was made possible by the dedicated service of the entire staff of the Finance Department. Each member of the department has our sincere appreciation for the contributions made in the preparation of this report. We would like to express special appreciation to Gary Braaten, Accounting Coordinator, for all of his hard work and assistance. In closing, without the leadership and support of the City Manager and City Council, preparation of this report would not have been possible. Sincerely, W William J. Ehite Finance Director 2 June V. Johnston Assistant Finance Director 13 CH 14 CITY OF COLUMBIA HEIGHTS, MINNESOTA Certificate of � Achievement � for Excellence in Financial Reporting Presented to City of Columbia Heights, Minnesota For its Comprehensive Annual Financial Report for the Fiscal Year Ended December 31, 1992 rA Certificate of Achievement for Excellence in Financial Reporting is presented by the Government Finance Officers Association of the United States and Canada to government units and public employee retirement systems whose comprehensive annual financial reports (CAFRs) achieve the highest standards in government accounting and financial reporting. ' 1 President C� Executive Director 15 CH 16 CITY OF COLUMBIA HEIGHTS, MINNESOTA II. FINANCIAL SECTION 17 CH 18 CITY OF COLUMBIA HEIGHTS, MINNESOTA Y 7' TA UTGES, RED PA TH & CO., LTD. CERTIFIED PUBLIC ACCOUNTANTS IINDEPENDENT AUDITOR'S REPORT To the Honorable Mayor and Members of the City Council City of Columbia Heights, Minnesota We have audited the general purpose financial statements of the City of Columbia Heights, Minnesota, as of and for the year ended December 31, 1993 as listed in the table of contents. These financial statements are the responsibility of the City's management. Our responsibility is to express an opinion on these financial statements based on our audit. We conducted our audit in accordance with generally accepted auditing standards and Government Auditing Standards, issued by the Comptroller General of the United States. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements. An audit also includes assessing the accounting principles used and significant.estimates made by management, as well as evaluating the overall financial statement presentation. We believe that our audit provides a reasonable basis for our opinion. In our opinion, the general purpose financial statements referred to above present fairly, in all material respects, the financial position of the City of Columbia Heights, Minnesota, as of December 31, 1993, and the results of its operations and its cash flows of its proprietary fund types for the year then ended in conformity with generally accepted accounting principles. Our audit was made for the purpose of forming an opinion on the general purpose financial statements taken as a whole. The combining, individual fund, account group financial statements, supporting schedules and statistical information in the table of contents is presented for purposes of additional analysis and is not a required part of the financial statements of the City of Columbia Heights, Minnesota Such information, except for that portion marked "unaudited," on which we express no opinion, has been subjected to the auditing procedures applied in the audit of the general purpose financial statements and, in our opinion, is fairly stated in all material respects in relation to the general purpose financial statements taken as a whole. March 15, 1994 TAUTGES, REDPATH & CO., LTD. Certified Public Accountants 19 4810 White Bear Parkway o White Bear Lake, Minnesota 55110 o 612/426 -7000 o FAX /426 -5004 o Member of HLB International CH Kil CITY OF COLUMBIA HEIGHTS, MINNESOTA ' GENERAL PURPOSE FINANCIAL STATEMENTS ' These general purpose financial statements are part of the Comprehensive Annual Financial Report, presenting only aggregate data by fund type and account group, together with notes to the financial statements, and constitutes "fair presentation in conformity ' with generally accepted accounting principles." It is felt that these general purpose financial statements will be a benefit to users requiring less detailed information about our City's finances. 21 CITY OF COLUMBIA HEIGHTS, MINNESOTA COMBINED BALANCE SHEET- ' ALL FUND TYPES AND ACCOUNT GROUPS December 31, 1993 With Primary Government Comparative Totals For December 31, 1992 ' Assets Cash and investments Cash and investments held in escrow Receivables: Accounts Special assessments Taxes Interest Loans Due from other governmental units Due from other funds Due from primary government Due from component unit Due from developer Prepaid expense Assets held by deferred compensation trustees Inventory, at cost Real estate held for resale Fixed assets, net of accumulated depreciation Other debits: Amount available in Debt Service Funds Amount to be provided for retire- ment of general long -term debt Amount to be provided for compensated absences Amount to be provided for notes payable Total assets 22 The accompanying notes are an integral part of these financial statements. I Proprietary Governmental Fund Types Fund Types ' Special Debt Capital Internal General Revenue Service Project Enterprise Service ' $3,139,309 $812,779 $1,391,060 $4,400,390 $3,269,901 $937,484 - 446,352 6,518,487 - - - 11,001 28,942 - - 811,471 2,752 - 528,045 - 426,026 - - 172,544 - 754,843 - - - 10,515 3,084 4,142 20,593 17,920 3,091 ' 56,896 80,495 - 4,622 292,150 149,376 - - - 707,000 - 7,648 9,496 655 - - 185 18,173 - - - - 579,495 80,196 ' - - - 220,000 - - - - - - 4,014,276 931,249 ' $3,556,785 $1,900,352 $8,668,532 $5,071,631 $9,692,398 $1,972,945 22 The accompanying notes are an integral part of these financial statements. I Statement 1 Page 1 of 2 Totals Component (Memorandum Fiduciary Totals Unit Only) ' Fund Type Account Groups (Memorandum Only) Housing and Reporting Trust and General General Long- Primary Government Redevelopment Entity Agency Fixed Assets Term Debt 1993 1992 Authority 1993 $217,757 $ - $ - $14,168,680 $14,880,244 $553,045 $14,721,725 - - - 6,964,839 6,960,115 - 6,964,839 - - - 854,166 837,180 796 854,962 - - - 954,071 1,054,110 - 954,071 ' - - - 927,387 721,961 1,790 929,177 516 59,861 109,744 574 60,435 - - - - - 376,195 376,195 434,163 291,461 34,568 468,731 856,376 105,026 167,704 1,024,080 - - - - - 3,510 3,510 7,648 30,074 - 7,648 - - - - 65,000 65,000 - - - 28,509 122,229 7,544 36,053 1,523,237 - 1,523,237 1,195,530 201,896 1,725,133 = 659,691 492,651 659,691 - - - 220,000 - 168,528 388,528 - 12,604,118 - 17,549,643 16,117,332 5,122,237 22,671,880 ' - - 7,922,087 7,922,087 8,905,141 - 7,922,087 - - 9,844,318 9,844,318 10,514,070 - 9,844,318 362,043 362,043 343,397 10,711 372,754 ' = = 15,228 15,228 15,982 15,228 $1,741,510 $12,604,118 $18,143,676 $63,351,947 $62,696,247 $6,714,098 $70,066,045 1 ' The accompanying notes are an integral part of these financial statements. 23 CITY OF COLUMBIA HEIGHTS, MINNESOTA COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS December 31, 1993 With Primary Government Comparative Totals For December 31, 1992 , Liabilities, equity and other credits Liabilities: Accounts payable Accrued salaries and withholdings payable Contracts payable, retained percentage Notes payable Capital lease payable Deferred compensation payable Due to other governmental units Due to other funds Due to primary government Due to component unit Deferred revenue Bonds payable Accrued interest payable Accreted interest payable Deposits Insurance and taxes in escrow Compensated absences payable Other liabilities Total liabilities Equity and other credits: Contributed capital Investment in general fixed assets Retained earnings: Reserved Unreserved Fund balance (deficit): Reserved Unreserved: Designated Undesignated Total equity and other credits Proprietary Governmental Fund Types Fund Types Special Debt Capital Internal General Revenue Service Project Enterprise Service $98,670 $36,992 $ - $2,168 $268,162 $11,208 120,105 2,678 - 105 61,779 15,535 - - - 1,580 81,141 - - - - - - 671,568 4,526 418 - - 66,116 - - 11,564 - 844,812 - - 3,510 - - - - - 148,035 554,712 746,445 423,241 - 2,752 - - - - - 6,527 - 180 - - - - 374,846 606,544 746,445 1,271,906 477,198 707,590 1,498,650 188,849 2,656,650 800,555 5,059,900 275,951 9,496 447,007 - - - 3,172,443 369 7,922,087 4,550 - - - 846,432 - 3,795,175 - - 3,181,939 1,293,808 7,922,087 3,799,725 9,215,200 1,265,355 Total liabilities, equity and other credits $3,556,785 $1,900,352 $8,668,532 $5,071,631 $9,692,398 $1,972,945 24 The accompanying notes are an integral part of these financial statements. ' Statement 1 Page 2 of 2 The accompanying notes are an integral part of these financial statements. 25 Totals Component (Memorandum Fiduciary Totals Unit Only) Fund Type Account Groups (Memorandum Only) Housing and Reporting Trust and General General Long- Primary Government Redevelopment Entity Agency Fixed Assets Term Debt 1993 1992 Authority 1993 ' $2,278 $- $- $419,478 $362,938 $31,780 $451,258 200,202 187,310 6,107 206,309 - - - 82,721 5,566 - 82,721 ' = 15,228 15,228 15,982 15,228 671,568 = 671,568 1,523,237 - - 1,523,237 1,195,530 201,896 1,725,133 ' = = - 71,060 121,420 31,202 102,262 856,376 105,026 167,704 1,024,080 - - - - - 7,648 7,648 3,510 4,466 - 3,510 = 1,875,185 1,787,698 443,097 2,318,282 - - 17,209,721 17,209,721 19,059,721 - 17,209,721 _ = - 6,527 - 6,527 ' 556,684 556,684 364,692 = 556,684 5,742 - - 5,922 10,475 10,618 16,540 - - - 4,191 4,191 362,043 362,043 343,397 10,711 372,754 754 - - 754 2,632 87,068 87,822 1,532,011 0 18,143,676 23,860,216 23,566,853 1,002,022 24,862,238 - - - 1,687,499 1,752,728 - 1,687,499 12,604,118 12,604,118 11,923,785 5,122,237 17,726,355 3,457,205 3,217,224 - 3,457,205 5,335,851 4,863,865 5,335,851 - - - 456,503 434,286 178,041 634,544 ' 208,794 - - 11,308243 11,931,437 228,388 11,536,631 705 - - 4,642,312 5,006,069 183,410 4,825,722 ' 209,499 12,604,118 0 39,491,731 39,129,394 5,712,076 45,203,807 $1,741,510 $12,604,118 $18,143,676 $63,351,947 $62,696,247 $6,714,098 $70,066,045 The accompanying notes are an integral part of these financial statements. 25 CITY OF COLUMBIA HEIGHTS, MINNESOTA COMBINED STATEMENT OF REVENUES, EXPENDITURES AND ' CHANGES IN FUND BALANCE - ALL GOVERNMENTAL FUND TYPES AND EXPENDABLE TRUST FUNDS For The Year Ended December 31, 1993 With Primary Government Comparative Totals For The Year Ended December 31, 1992 ' Governmental Fund Types Special ' Revenues: General Revenue Taxes $2,060,355 $378,979 Special assessments - 95,366 ' Licenses and permits 135,545 - Intergovernmental 3,181,600 601,152 Charges for services 347,513 117,374 , Fines and forfeits 89,464 - Interest 179,000 64,905 Other revenues 20,640 111,088 ' Total revenues 6,014,117 1,368,864 Expenditures: Current: ' General government 1,441,603 - Public safety 2,679,272 - Public works 806,990 - , Sanitation 149,054 - Parks and recreation 977,911 62,548 Library - 374,625 ' Other - 313,270 Contingencies 268 - Capital outlay - 1861164 ' Debt service - - Total expenditures 6,055,098 936,607 Revenues over (under) expenditures (40,981) 432,257 Other financing sources (uses): Bond proceeds - - Payment of refunded bonds - - Operating transfers in 406,961 31,757 ' Operating transfers out (196,505) (113,624) Total other financing sources (uses) 210,456 (81,867) ' Net increase (decrease) in fund balance 169,475 350,390 Fund balance - January 1 2,925,866 943,418 , Residual equity transfers 86,598 - Fund balance December 31 $3,181,939 $1,293,808 ' - 26 The accompanying notes are an integral part of these financial statements. , Statement 2 - - - 1,441,603 1,356,795 - Totals ' - - 2,679,272 2,563,788 Component (Memorandum - - Fiduciary 806,990 819,300 Unit Only) - - Fund Type Totals (Memorandum Only) Housing and Reporting Debt Capital Expendable Primary Government Redevelopment Entity Service Project Trust 1993 1992 Authority 1993 $1,153,910 $ - $ - $3493,244 $3,496,720 $8,607 $3,601,851 35,088 222,027 - 352,481 315,014 - 352,481 268 - 953,628 135,545 125,275 613,462 135,545 - - - 3,782,752 3,504,973 240,927 4,023,679 2,963,693 2,963,693 27,710 492,597 442,636 387,306 879,903 = = 89,464 104,673 89,464 421,285 350,565 8,800 1,024,555 803,393 17,005 1,041,560 5,248 8,041 5,717 150,734 994,358 194,541 345,275 1,615,531 580,633 42,227 9,621,372 9,787,042 848,386 10,469,758 - - - 1,441,603 1,356,795 - 1,441,603 - - - 2,679,272 2,563,788 - 2,679,272 - - - 806,990 819,300 - 806,990 - - - 149,054 176,216 - 149,054 - - - 1,040,459 1,044,021 - 1,040,459 - - - 374,625 383,933 - 374,625 - - 30,358 343,628 241,079 808,848 1,152,476 - - - 268 18,204 - 268 - 953,628 - 1,139,792 613,462 155,327 1,295,119 2,963,693 - - 2,963,693 2,272,802 - 2,963,693 2,963,693 953,628 30,358 10,939,384 9,489,600 964,175 11,903,559 (1,348,162) (372,995) 11,869 (1,318,012) 297,442 (115,789) (1,433,801) 730,073 - - 730,073 - - 730,073 (710,000) - - (710,000) - - (710,000) 2,297,610 174,146 100,000 3,010,474 2,741,381 - 3,010,474 (2,297,610) (69,530) - (2,677,269) (2,354,210) - (2,677,269) 20,073 104,616 100,000 353,278 387,171 0 353,278 (1,328,089) (268,379) 111,869 (964,734) 684,613 (115,789) (1,080,523) 8,905,141 4,499,737 97,630 17,371,792 16,687,179 705,628 18,077,420 345,035 (431,633) - $7,922,087 $3,799,725 $209,499 $16,407,058 $17,371,792 $589,839 $16,996,897 The accompanying notes are an integral part of these financial statements. 27 Other financing sources (uses): Operating transfers in 374,838 406,961 32,123 ' CITY OF COLUMBIA HEIGHTS MINNESOTA (196,505) 252 Total other financing sources (uses) 178,081 COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL 32,375 Net increase (decrease) in fund balance ($394,659) ' GENERAL AND SPECIAL REVENUE FUND TYPES Fund balance - January 1 2,925,866 For The Year Ended December 31, 1993 ' General Over (under) ' Budget Actual Budget Revenues: Taxes $2,082,715 $2,060,355 ($22,360) ' Licenses and permits 152,450 135,545 (16,905) Intergovernmental 3,157,394 3,181,600 24,206 Charges for services 341,153 347,513 6,360 Fines and forfeits 112,150 89,464 (22,686) Interest 120,000 179,000 59,000 Other revenues 30,250 20,640 (9,610) Total revenues 5,996,112 6,014,117 18,005 Expenditures: Current: General government 1,591,085 1,441,603 (149,482) Public safety 2,755,297 2,679,272 (76,025) Public works 973,800 806,990 (166,810) ' Sanitation 150,651 149,054 (1,597) Parks and recreation 1,096,652 977,911 (118,741) Library _ - _ , Other _ - _ Contingencies 1,367 268 (1,099) Total current expenditures 6,568,852 6,055,098 (513,754) i Capital outlay - _ _ Total expenditures 6,568,852 6,055,098 (513,754) ' Revenues over (under) expenditures (572,740) (40,981) 531,759 Other financing sources (uses): Operating transfers in 374,838 406,961 32,123 Operating transfers out (196,757) (196,505) 252 Total other financing sources (uses) 178,081 210,456 32,375 Net increase (decrease) in fund balance ($394,659) 169,475 $564,134 Fund balance - January 1 2,925,866 Residual equity transfers 86,598 Fund balance - December 31 $3,181,939 28 The accompanying notes are an integral part of these financial statements. Statement 3 $485,616 86,598 $3,580,957 $3,195,460 The accompanying notes are an integral part of these financial statements. 29 Totals (Memorandum Only) Special Revenues 1993 Over Over ' (under) (under) 1992 Budget Actual Budget Budget Actual Budget Actual $378,979 $378,979 $ - $2,461,694 $2,439,334 ($22,360) $2,388,718 - - - 152,450 135,545 (16,905) 125,275 357,879 561,152 203,273 3,515,273 3,742,752 227,479 3,491,640 106,920 110,708 3,788 448,073 458,221 10,148 440,791 - 112,150 89,464 (22,686) 104,673 8,500 28,084 19,584 128,500 207,084 78,584 153,180 ' 6,600 8,915 2,315 36,850 29,555 (7,295) 91,519 858,878 1,087,838 228,960 6,854,990 7,101,955 246,965 6,795,796 - - - 1,591,085 1,441,603 (149,482) 1,356,795 - - - 2,755,297 2,679,272 (76,025) 2,563,788 - - - 973,800 806,990 (166,810) 819,300 - - - 150,651 149,054 (1,597) 176,216 - - - 1,096,652 977,911 (118,741) 998,970 374,835 374,625 (210) 374,835 374,625 (210) 383,933 189,276 236,210 46,934 189,276 236,210 46,934 215,632 - - - 1,367 268 (1,099) 18,204 ' 564,111 610,835 46,724 7,132,963 6,665,933 (467,030) 6,532,838 89,310 178,947 89,637 89,310 178,947 89,637 132,646 ' 653,421 789,782 136,361 7,222,273 6,844,880 (377,393) 6,665,484 205,457 298,056 92,599 (367,283) 257,075 624,358 130,312 25,090 25,090 - 399,928 432,051 32,123 508,742 (102,572) (107,124) (4,552) (299,329) (303,629) (4,300) (703,668) ' (77,482) (82,034) (4,552) 100,599 128,422 27,823 (194,926) $127,975 216,022 $88,047 ($266,684) 385,497 $652,181 (64,614) 269,594 3,195,460 3,260,074 $485,616 86,598 $3,580,957 $3,195,460 The accompanying notes are an integral part of these financial statements. 29 CITY OF COLUMBIA HEIGHTS, MINNESOTA COMBINED STATEMENT OF REVENUES, EXPENSES AND Statement 4 CHANGES IN RETAINED EARNINGS PROPRIETARY FUND TYPES For The Year Ended December 31, 1993 With Comparative Totals For The Year Ended December 31, 1992 Enterprise Internal Service Totals (Memorandum Only) Funds Funds 1993 1992 Operating revenues: Charges for services $2,593,301 $478,051 $3,071,352 $2,815,892 ' Charges for sales 6,275,122 50,822 6,325,944 6,048,084 Intergovernmental 40,992 - 40,992 29,856 Total operating revenues 8,909,415 528,873 99438,288 8,893,832 ' Operating expenses: Costs of sales, services, and goods sold 6,665,198 427,915 7,093,113 5,490,296 Operating expense 1,517,580 18,760 1,536,340 2,371,640 Depreciation 259,667 130,666 390,333 257,694 Total operating expenses 8,442,445 577,341 9,019,786 8,119,630 ' Net income (loss) from operations 466,970 (48,468) 418,502 774,202 Other revenues (expenses): ' Interest income 311,094 52,635 363,729 278,360 Miscellaneous revenues 15,175 95,443 110,618 161,835 Interest expense - (35,967) (35,967) - ' Miscellaneous expenses (15,201) - (15,201) (5,067) Net other revenues (expenses) 311,068 112,111 423,179 435,128 ' Net income before operating transfers 778,038 63,643 841,681 1,209,330 Operating transfers: , Operating transfers in 90,662 172,748 263,410 758,394 Operating transfers out Total operating transfers (582,028) (491,366) (14,587) 158,161 (596,615) (1,145,565) (333,205) (387,171) Net income 286,672 221,804 508,476 822,159 , Credit for depreciation on contributed assets 65,229 - 65,229 65,229 Net increase in retained earnings 351,901 221,804 573,705 887,388 ' Retained earnings - January 1 7,226,387 854,702 8,081,089 7,193,701 Prior period adjustment 138,262 - 138,262 - Retained earnings - December 31 $7,716,550 $1,076,506 $8,793,056 $8,081,089 30 The accompanying notes are an integral part of these financial statements. ' r CITY OF COLUMBIA HEIGHTS, MINNESOTA COMBINED STAMIENT OF CASH FLOWS Statement 5 PROPRIETARY FUND TYPES For The Year Ended December 31, 1993 With Comparative Totals For The Year Ended December 31, 1992 rInternal Totals Enterprise Service (Memorandum Only) Funds 1993 1992 rFunds Cash flows from operating activities: Cash received from customers $8,061,361 $527,105 $8,588,466 $8,798,505 Cash paid to suppliers for goods and services (7,421,975) 394,923 (7,027,052) (7,081,338) Cash payments to employees for services (724,580) (108,438) (833,018) (716,855) Miscellaneous revenues 15,175 95,443 110,618 161,835 Miscellaneous expenses (15,201) - (15,201) (5,067) cash flows from operating activities (85,220) 909,033 823,813 1,157,080 'Net Cash flows from noncapital financing activities: Operating transfers in from other funds - 172,748 172,748 4,000 Operating transfers (out) to other funds (491,366) (14,587) (505,953) (391,171) Net cash from noncapital financing activities (491,366) 158,161 (333,205) (387,171) Cash flows from capital and related financing activities: Acquisition of fixed assets (428,473) (714,165) (1,142,638) (492,916) Disposition of fixed assets 1,505 Interest expense - (35,967) (35,967) - cash flows from capital and related financing activities (428,473) (750,132) (1,178,605) (491,411) 'Net Cash flows from investing activities: Purchase of investments - - - (731,977) Proceeds from sale and maturity of investments 3,080,024 - 3,080,024 1,167,160 ' Interest earned on investments 311,094 52,635 363,729 270,526 Net cash from investing activities 3,391,118 52,635 3,443,753 705,709 Net increase in cash and cash equivalents 2,386,059 369,697 2,755,756 984,207 ' Cash and cash equivalents - January 1 883,842 567,787 1,451,629 467,422 Cash and cash equivalents - December 31 $3,269,901 $937,484 $4,207,385 $1,451,629 Reconciliation of operating income to net cash provided (used) by operating activities: Operating income $466,970 ($48,468) $418,502 $774,202 Adjustments to reconcile operating income (loss) to net cash provided (used) by operating activities: Miscellaneous revenues 15,175 95,443 110,618 161,835 Miscellaneous expenses (15,201) - (15,201) 24,004 ' Depreciation expense 259,667 130,666 390,333 228,623 Changes in assets and liabilities: Accounts receivable (17,901) (1,768) (19,669) (94,535) Due from other governmental units (123,153) - (123,153) 53,315 Due from other funds (707,000) (707,000) Inventory, at cost (172,730) 5,690 (167,040) (4,455) Prepaid expenses 55,725 47,826 103,551 80,141 Accounts payable 145,520 (1,547) 143,973 (72,447) ' Accrued salaries and withholdings payable (3,817) 344 (3,473) 1,382 Due to other governmental units 11,525 - 11,525 5,015 ' Capital lease payable 671,568 671,568 Accrued interest payable 6,527 6,527 - Deferred revenue - 2,752 2,752 - Total adjustments (552,190) 957,501 405,311 382,878 ' Net cash flows from operating activities ($85,220) $909,033 $823,813 $1,157,080 rThe accompanying notes are an integral part of these financial statements. 31 CH 32 CITY OF COLUMBIA HEIGHTS, MINNESOTA CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 The City of Columbia Heights was incorporated in 1898. The City is governed by a Council composed of an elected mayor and four councilmembers. The Council exercises legislative authority and determines all matters of policy. The Manager, who is appointed by the Council, is responsible for the proper administration of all affairs relating to the City. The financial reporting policies of the City conform to generally accepted accounting principles. The following is a summary of the significant policies. A. FINANCIAL REPORTING ENTITY As required by generally accepted accounting principles, the financial statements of the reporting entity include those of the City of Columbia Heights, Minnesota (the primary government) and its component units. The component unit discussed below is included in the City's reporting entity because of the significance of their operational or financial relationships with the City. The Housing and Redevelopment Authority (HRA) is considered a component unit of the City because the mayor appoints the members of governing authority and because the City is in a relationship of financial benefit or burden with the HRA. The financial position and results of operations of the HRA component unit are presented using the discrete method of including a separate column in the general purpose financial statements. The HRA is reported as a separate column to emphasize that it is legally separate from the City. This component unit includes Governmental and Agency Funds and Account Groups using the modified accrual basis of accounting. Separate financial statements for the Housing and Redevelopment Authority may be obtained by contacting the City of Columbia Heights, Minnesota. The City has various citizen commissions and boards which act on a voluntary basis as advisors to the City Council on specific matters. The costs of these commissions and boards are limited to the administrative support which is funded by the City and included in this financial report. B. BASIS OF PRESENTATION - FUND ACCOUNTING The accounts of the City of Columbia Heights 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. Government resources are allocated to and accounted for in individual funds based upon the purpose for which they are to be spent and the means by which spending activities are controlled. The various funds and account groups are grouped in this report into seven generic fund types, three broad fund categories, and two account groups. A description of the fund types and account groups used by the City follows. GOVERNMENTAL FUNDS TYPES General Fund - The General Fund is the general operating fund of the City. It is used to account for all financial resources except those required to be accounted for in another fund. Special Revenue Funds - Special Revenue Funds are used to account for the proceeds of specific revenue sources (other than expendable trusts or major capital projects) that are legally restricted to expenditures for specified purposes. 33 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 Debt Service Funds - Debt Service Funds are used to account for the accumulation of resources for, and the payment of all general long -tern debt principal, interest, and related costs. Coital Project Funds - Capital Project Funds are used to account for financial resources to be used for the acquisition or construction of major facilities, other than those financed by Proprietary Funds. Enterprise Funds - Enterprise Funds are used to account for operations that are financed and operated in a manner similar to private business enterprises - where the intent of the governing body is that the costs of providing goods or services to the general public on a continuing basis be financed or recovered primarily through user charges. Internal Service Funds - Internal Service Funds are used to account for the costs of providing goods or services to other departments or agencies of the City. Charges to other City departments are made to support these activities. FIDUCIARY FUNDS Agency Funds - Agency Funds are used to account for assets held by the City as an agent for individuals, private organizations, other governmental units, or other funds. Agency Funds are custodial in nature (assets equal liabilities) and do not involve measurement of results of operations. Trust Funds - Trust Funds are used to account for assets held by the City in a trustee capacity. ACCOUNT GROUPS General Fixed Assets Account Group - This account group is used to account for all of the fixed assets of the Governmental Fund Types. General Long -Term Debt Account Group - This account group is used to account for all of the City's long -term obligations, other than those liabilities of Proprietary Fund Types. C. BASIS OF ACCOUNTING Basis of accounting refers to the time at which revenues and expenditures are recognized in the accounts and reported in the financial statements, regardless of the measurement focus applied. All Governmental, Agency and Expendable Trust Funds are reported on the modified accrual basis of accounting. Generally, only current assets and current liabilities are included in these funds. Governmental Funds use the "financial flow" measurement focus. Consequently, their revenues are recognized when they become measurable and available as net current assets. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Revenue sources susceptible to accrual include property taxes, intergovernmental revenue, and interest earned on investments. Expenditures are recognized under the modified accrual basis of accounting when a liability is incurred, except for principal and interest on general long -term obligations which are recognized when due. Compensated absences are considered expenditures when paid to employees. Proprietary Funds are accounted for using the "capital maintenance" measurement focus and are reported on the accrual basis of accounting. Revenues are recognized when they are earned and expenses are recorded at the time liabilities are incurred. 34 CITY OF COLUMBIA HEIGHTS MINNESOTA NOTES TO FINANCIAL STATEMENTS ' December 31, 1993 ' D. BUDGETARY DATA The City Manager submits to the City Council a proposed operating budget for the fiscal year commencing on January 1 of the following year. At least one special Council meeting is conducted to obtain public comments as required by the State Truth in Taxation Law. The City Council annually adopts budgets prior to January 1 for the General and certain Special Revenue Funds. The budgets are prepared by fund, function, and activity. The budgets are adopted on a basis consistent with generally accepted accounting principles and all appropriations lapse at the end of the budget year to the extent that they have not been expended. Total expenditures appropriated in the budget resolution may not legally exceed the estimated revenues available from various sources. Formal budgetary integration is employed as a management control device during the year. Budget 1 revisions between functions or activities may be made by the City Manager. Budget revisions at the fund level are authorized by the City Council in accordance with the City Charter at the request of the City Manager. The legal level of budgetary control is therefore at the fund level. The City does not use encumbrance accounting. Amounts shown in the financial statements represent the original budgeted amounts and the following increases (decreases) in appropriations: General Fund $114,045 ' Special Revenue Funds: Municipal State Aid: State Aid Maintenance 28,440 ' Library 375 Totals $142,860 35 CITY OF COLUMBIA HEIGHTS MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 ' The City did not budget for all Special Revenue Funds and, accordingly, the applicable columns of the Combined Statement of Revenue, Expenditures, and Changes in Fund Balance - Budget and Actual excludes amounts relating to the unbudgeted funds. A reconciliation of actual results for budgeted and unbudgeted Special Revenue Funds follows: Total Other Fund Balance Financing Fund Balance December 31, Total Total Sources December 31, Fund 1992 Revenues Expenditures (Uses) 1993 Special Revenue Funds: Budgeted funds $269,594 $1,087,838 $789,782 ($82,034) $485,616 Unbudgeted funds: Confiscated property - 2,340 - - 2,340 Community Police (4,706) 46,666 55,090 6,667 (6,463) Project Pride 4,089 333 994 - 3,428 Parking Ramp 193,820 118,841 - - 312,661 Recreation Contributed Projects 20,051 60,790 61,554 - 19,287 Contributed Projects 14,781 38,710 29,187 (6,500) 17,804 Housing Mortgage 445,789 13,346 - - 459,135 Total Special Revenue Funds $943,418 $1,368,864 $936,607 ($81,867) $1,293,808 E. ASSETS, LIABILITIES, AND FUND EQUITY ACCOUNTS ASSETS Cash and Investments - Cash balances from all funds are combined and invested to the extent available in allowable investments. Investments are stated at cost which approximates market value. Earnings on investments are allocated to the individual funds on the basis of applicable cash balance participation by each fund using an average of monthly beginning cash and investment balances. Assets of the deferred compensation plans are held by trustees and are reported at market value in an Agency Fund. S=ial Assessments Receivable - Special assessments represent the financing for public improvements paid for by benefiting property owners. These assessments are recorded as receivables upon certification of each project. The corresponding revenue from the delinquent (unremiued) and deferred (certified but not yet levied) special assessments receivable is deferred until the year it becomes available (collected within 60 days of year -end). Inventories - Inventories are valued at cost, which approximates market, using the first -in, first -out basis. Real Estate Held for Resale - Real estate is valued at the lower of cost or market. Fixed Assets: General Fixed Assets Account Groull - All purchased fixed assets are valued at historical cost or estimated historical cost. The costs of property, plant, and equipment are accounted for as current expenditures of the Governmental Fund Types in the year purchased. The City has elected not to record infrastructure fixed assets in its account records. 36 No depreciation has been provided on general fixed assets. CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 Proprietary Fund Tvnes - Fixed assets of the Proprietary Funds are stated at historical cost, estimated historical cost, or in the case of contributions, at fair market value at the time received. Depreciation has been provided using the straight-line method over the estimated useful lives of assets as follows: Buildings 40-50 years Machinery and equipment 3 -20 years Improvements 5 -20 years Distribution system 50 -100 years Depreciation on contributed assets charged to operations is closed to the contributed equity account. 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 liability for the vested portion of accumulated vacation and sick leave is recorded in the General Long -Term Debt Account Group. No expenditure is reported for these amounts. Amounts taken as terminal leave each year are not material and therefore the total is carried as long -term debt. Vested or accumulated vacation leave of Proprietary Funds is recorded as an expense and liability of those funds as the benefits accrue to employees. No liability is recorded for nonvesting accumulating rights to receive sick pay benefits. However, a liability is recognized for that portion of accumulating sick leave benefits that it is estimated will be taken as "terminal leave" prior to retirement. FUND EQUITY Contributed capital is recorded in Proprietary Funds that have received capital grants or contributions from developers, customers, or other funds. Fund balance accounts are subdivided: Reserved fund balance accounts indicate that portion of fund equity which has been legally segregated for specific purposes or is not appropriable for expenditures. Unreserved designated fund balance accounts indicate that portion of fund equity that the City has set aside for planned future projects. Unreserved undesignated fund balance accounts indicate that portion of fund equity which is available for budgeting and expending in future periods. PromM Taxes - Property tax levies are set by the City Council and certified to Anoka County in December (levy /assessment date) for collection the following year. In Minnesota, counties act as collection agents for all property taxes. The County spreads the levies over all taxable property in the City. Such taxes become receivables of the City and attach an enforceable lien on taxable property within the City as of January 1. 37 CITY BIA O F L HEIGHTS MINNESOTA COLUMBIA , NOTES TO FINANCIAL STATEMENTS December 31, 1993 ' Property taxes are payable in equal installments by property owners to the County as follows: Personal Property - February 28 and June 30 Real Property - May 15 and October 15 The County remits the collections to the City and other taxing districts four times a year, on or before January 25, April 19, July 5, and December 4. Unpaid taxes at December 31 become delinquent and are classified in the financial statements as delinquent taxes receivable. Property taxes are recognized as revenue to the extent collected in the current period. Portions paid by the State in the form of State paid tax credits are included in intergovernmental revenues. That portion of property taxes receivable but not available (not collected within 60 days of year -end) is recorded as deferred revenue and will be recognized as revenue in the fiscal year that it becomes available. The City's property tax levies are subject to certain maximum levels set by the State of Minnesota under statutory formulas. The City has not exceeded such levy limits. Intergovemmental Revenues - Intergovernmental revenues are reported using the guidelines of legal and contractual requirements of the individual programs. Other Revenues - Other revenues, such as licenses and permits, fees for services, fines and forfeits, and miscellaneous revenue, are recognized when received in cash because they generally are not measurable until received. Investment income is recognized as earned since it is measurable and available. EXPENDITURES Expenditure recognition for Governmental Fund Types includes only amounts represented by current liabilities. 1 ! ►�► 1► Iu ► u Total columns on the combined statements are captioned "Totals (Memorandum Only)" to indicate that they are presented only to facilitate financial analysis. Data in these columns does not present cash flow or results of operations in conformity with generally accepted accounting principles nor is such data comparable to a consolidation. Interfund eliminations have not been made in the aggregation of these data. Iu'• M Comparative total data for the prior year has been presented in the accompanying financial statements to provide an understanding of changes in the City's financial position and operations. Comparative data for each fund type has not been presented in the combined statements since their inclusion could make the statements unduly complex and difficult to read. 11NIN76VU93TraNK11 wKiyam 1 1 For purposes of the Statement of Cash Flows, the City considers all highly liquid debt instruments with an original maturity of three months or less to be cash equivalents. All of the Proprietary Funds' equity in the City -wide cash and investment management pool is considered to be cash equivalents. 9M CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 Note 2 DEPOSITS AND INVESTMENTS The City maintains a cash and investment pool that is available for use by all funds. Each fund type's portion of this pool is displayed on the combined balance sheet as "Total Cash and Investments." An indication of the level of risk assumed by the City at year -end is categorized as follows for the City's cash and investments. DEPOSITS In accordance with Minnesota Statutes, the City maintains deposits at depository banks authorized by the City Council. Minnesota Statutes require that all deposits be protected by insurance, surety bond, or collateral. The market value of collateral pledged must equal 110% of the deposits not covered by insurance or bonds (140910 in the case of mortgage - backed collateral). Authorized collateral includes the legal investments described below, as well as certain first mortgage notes, and certain other state or local government obligations. Minnesota Statutes require that securities pledged as collateral be held in safekeeping by the City or in a financial institution other than that furnishing the collateral. Deposits at December 31, 1993, including checking accounts, savings accounts, and certificates of deposit are as follows: City HRA Total Bank balance $1,133,563 $565,312 $1,698,875 Carrying amount $395,769 $552,970 $948,739 At December 31, 1993, all City deposits were insured or collateralized by securities held by the City's agent in the City's name, and all HRA deposits were insured or collateralized by securities held by the HRA's agent in the HRA's name. The City may also invest idle funds as authorized by Minnesota Statutes as follows: direct obligations or obligations guaranteed by the United States or its agencies; shares of investment companies registered under the Federal Investment Company Act of 1940 and whose only investments are in securities described above; general obligations of the State of Minnesota or any of its municipalities; bankers' acceptances of United States' banks eligible for purchase by the Federal Reserve System; commercial paper issued by United States' corporations or their Canadian subsidiaries, of the highest quality, and maturing in 270 days or less; repurchase or reverse purchase agreements with banks that are members of the Federal Reserve System with capitalization exceeding $10,000,000, a primary reporting dealer in U.S. government securities to the Federal Reserve Bank of New York, or certain Minnesota securities broker - dealers; and futures contracts sold under authority of Minnesota Statutes Section 471.56, Subdivision 5. The City's investments are categorized to give an indication of the level of risk assumed at year -end. Category l includes investments that are insured or registered or for which the securities are held by the City or its agent in the City's name. Category 2 includes uninsured and unregistered investments for which the securities are held by the counterparty's trust department or agent in the City's name. Category 3 includes uninsured and unregistered investments for which the securities are held by the counterparty or by its trust department or agent but not in the City's name. 39 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 Investment balances at December 31, 1993 are as follows: Credit Risk Category Carrying Market 1 2 3 Value Value U.S. Government Securities (including securities insured by the U.S. Government) $7,7 $6,5� 18 �$ - $14,312,888 $14,356,302 Government money market mutual funds 6,418,757 6,416,594 Total investments $20,731,645 $20,772,896 SUMMARY OF CASH AND INVESTMENTS Cash and investments at December 31, 1993 are summarized as follows: Deposits Cash on hand Investments Total cash and investments Cash and investments held in escrow Total Assets held by deferred compensation trustees (recognized at market value) City HRA Total $395,769 $552,970 $948,739 6,105 75 6,180 13,766,806 - 13,766,806 14,168,680 553,045 14,721,725 6,964,839 - 6,964,839 $21,133,519 $553,045 $21,686,564 $1,523,237 $201,896 $1,725,133 Note 3 LEGAL COMPL.IANCF, /BTJDGETS Total actual expenditures exceeded budgeted expenditures (appropriations) in the following funds for 1993: Budgeted Actual Over Expenditures "Expenditures Budget Special Revenue Funds: Municipal State Aid Street $33,348 $233,661 $200,313 M CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 Note 4 INTERGOVERNMENTAL RECEIVABLES 1 Intergovernmental receivables at December 31, 1993 presented as due from other governmental units are composed of the following: City of Hilltop City: State of Minnesota General Fund: Municipal State Aid - State of Minnesota State of Minnesota $12,051 Independent School District #13 11,522 City of St. Anthony 489 Anoka County 27,322 City of Hilltop 5,023 City of Minneapolis 489 Total General Fund 56,896 Special Revenue Funds: Community Police: City of Hilltop 1,668 State of Minnesota 30,100 Municipal State Aid - State of Minnesota 30,945 Cable Television - City of Hilltop 3,909 Paratransit - City of Fridley 334 Anoka County 13,539 Total Special Revenue Funds 80,495 Capital Project Funds: City of Hilltop 4,622 Enterprise Funds: Sewer - M.W.C.C. 270,010 Refuse - Anoka County 20,272 Liquor - State of Minnesota 1,868 Total Enterprise Funds 292,150 Total City 434,163 HRA: MN Housing Finance Agency 9,319 Metropolitan Council 7,034 Anoka County CDBG 18,215 Total HRA 34,568 Total Intergovernmental Receivables $468,731 41 CITY OF COLUMBIA HEIGHTS, MINNESOTA L NOTES TO FINANCIAL STATEMENTS December 31, 1993 W-47001 i INTERCEPTOR ACQUISITION CONTRACT PAYABLE As of January 1, 1971, the Metropolitan Waste Control Commission (MWCC) assumed ownership of all existing inceptors and treatment works. Under the terms of the agreement with 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 billings from MWCC over a 30 -year period with interest at 4%. As of December 31, 1993, a balance of $133,676 remained to be collected over the next seven years. This receivable is presented as Due From Other Governmental Units in the Sewer Utility Fund. 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 MWCC at December 31, 1993 was $3,157 and is collectible over the next five years. Loans receivable for the Housing and Redevelopment Authority consists of the following: These loans relate primarily to personal residences of lower income individuals under a Community Development Program. 42 HRA General Fund Business Revolving loans $59,615 Home Improvement Loans 4,293 Mortgage Loans 134,022 Anoka County Community Action Program (ACCAP) Loans 178,265 $376,195 These loans relate primarily to personal residences of lower income individuals under a Community Development Program. 42 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 Note 6 INTERFUND RECEIVABLES AND PAYABLES Individual fund interfund receivables and payables at December 31, 1993 consist of the following: HRA: General Fund 167,704 - Special Revenue Funds - 86,319 Capital Project Funds - 81,385 Total HRA 167.704 167.704 Total $1,024,080 $1,024,080 43 Interfund Inteif ind Receivables Payables City: General Fund $149,376 $ - Special Revenue Funds: Community Police - 11,564 Capital Improvements 401 - 137,812 Sheffield Redevelopment - 707,000 Enterprise Fund- Sewer 707,000 - Total City 856,376 856,376 HRA: General Fund 167,704 - Special Revenue Funds - 86,319 Capital Project Funds - 81,385 Total HRA 167.704 167.704 Total $1,024,080 $1,024,080 43 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 From To Amount Purpose Operating Tax Increment Bonds Tax Increment Bonds of 1987 General DARE Project $2,500 Fund DARE Program General Paratransit 10,000 Fund City portion expense General Energy Management 64,748 Energy improvements General Library 12,590 Fund City portion Contributions Capital Replacement 6,500 Replace equipment Central Garage Central Garage Equipment Replacement Account Tax Increment Bonds Tax Increment Bonds of 1984 Tax Increment Bonds Tax Increment Bonds of 1997A Tax Increment Bonds Tax Increment Bonds of 1987 Tax Increment Bonds Capital Appreciation Bonds of 1990 Capital Improvement Projects Capital Improvement Refuse Liquor Water Utility Water Capital Equipment Replacement Account Water Capital Construction Account Sewer Utility Sewer Capital Equipment Replacement Capital Improvement Projects Cable Television Paratransit Liquor Utility Water Utility Refuse Utility Liquor Utility Sewer Utility Library 4,000 Garage building improvements 167,070 Debt service 1,209,565 Debt service 920,615 Debt service 360 Debt service 17,059 Close projects 4,231 Fund recycling equipment Water Capital Equipment Replacement Account 15,000 Fixed assets replacement Water Utility 8,437 Fixed asset replacement Energy Management 104,000 Fund projects Sewer Capital Equipment Replacement Account 25,000 Replacement fixed assets Capital Equipment Replacement Account Sewer Utility General General General General General General Capital Equipment Replacement General General General Compensated Absences General Community Police State Aid Maintenance General Total operating transfers Residual Equity Huset Park General PIR Bonds General Senior Housing Tax Increment Bonds Total residual equity transfers .. 10,587 Equipment replacement 37,994 Equipment replacement 52,471 Administrative labor 45,928 Administrative labor 6,217 Administrative labor 53,853 Administrative labor 57,262 Administrative labor 78,990 Administrative labor 140,000 Replacement fixed assets 57,261 Administrative labor 6,289 Administrative labor 100,000 Reserve for compensated absences 6,667 City portion of grant 48,690 State aid street maintenance $3,273,884 $35,715 50,883 395,918 $482,516 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 The following is a summary of changes in the General Fixed Assets Account Group during the fiscal year. The following is a summary of Proprietary Fund Type fixed assets at December 31, 1993: Balance Sewer Refuse Balance Total January 1, Total December 31, City 1993 Additions Retirements 1993 Proprietary I-attd $3,132,099 $ - $ - $3,132,099 Buildings 3,032,275 35,747 - 3,068,022 Improvements other than buildings 1,440,485 3,141 - 1,443,626 Machinery and equipment 4,070,059 333,429 46,450 4,357,038 Construction in process 248,867 354,466 - 603,333 Total City general fixed assets $11,923,785 $726,783 $46,450 $12,604,118 6,443,558 Machinery and equipment 269,867 Balance 5,447 348,968 Balance 100,298 January 1, Construction in process 21,733 December 31, HRA 1993 Additions Retirements 1993 Total Izo $69,688 $ - $ - $69,688 Buildings and structures 4,651,896 54,691 - 4,706,587 Furniture and fixtures 345,105 2,057 1,200 345,962 Total HRA general fixed assets $5,066,689 $56,748 $1,200 $5,122,237 The following is a summary of Proprietary Fund Type fixed assets at December 31, 1993: ELI Water Sewer Refuse Total Internal Total Utility Utility Utility Liquor Enterprise Service Proprietary Land $45,223 $36,586 $ - $13,051 $94,860 $ - $94,860 Buildings 233,836 46,290 - 241,066 521,192 708,009 1,229,201 Improvements other than buildings 2,839,427 3,060,243 2,890 104,538 6,007,098 436,460 6,443,558 Machinery and equipment 269,867 478,479 5,447 348,968 1,102,761 100,298 1,203,059 Construction in process 21,733 213,729 - - 235,462 - 235,462 Total 3,410,086 3,835,327 8,337 707,623 7,961,373 1,244,767 9,206,140 Less accumulated depreciation 1,645,589 1,981,075 3,297 317,136 3,947,097 313,518 4,260,615 Net fixed assets $1,764,497 $1,854,252 $5,040 $390,487 $4,014,276 $931,249 $4,945,525 ELI CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 ' The City has leased premises for a liquor store (Top Valu) under a five -year lease agreement that originally expired in 1989. This lease has been renewed through December 31, 1999. This lease is considered for accounting purposes to be an operating lease. Lease expenditures for the year ended December 31, 1993 amounted to $102,212. The City also has leased premises for its Top Valu II liquor store under a five -year lease expiring February 28, 1998, with a five -year renewal option in 1997 and 2002. The lease calls for fixed minimum payments of $3,051 per month. The City is also required to pay all utilities and a pro -rata share of real estate taxes. This lease is considered for accounting purposes to be an operating lease. Lease expenditures for the year ended December 31, 1993 amounted to $42,317. Future minimum rental payments are as follows: Top Valu Top Valu 11 1994 $88,185 $36,610 1995 88,785 36,610 1996 88,785 36,610 1997 88,785 36,610 1998 88,785 6,102 1999 88,785 - Total $532,110 $152,542 Note 10 CAPITAL LEASE The City leases equipment under a lease - purchase option agreement dated November 1, 1992 with an interest rate of 4.54 %. During the term of this lease, legal title to the equipment remains with the lessor. Full and legal title to the equipment will pass to the City upon completion of all rental payments as detailed below or the exercise by the City of its option to purchase the equipment per the terms of the lease. Future rental payments are as follows: Principal Interest Total 1994 $90,991 $29,499 $120,490 1995 95,173 25,317 120,490 1996 99,548 20,942 120,490 1997 104,124 16,366 120,490 1998 108,910 11,580 120,490 1999 -2000 172,822 7,913 180,735 Total $671,568 $111,617 $783,185 " CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 For accounting purposes, this lease is considered a capital lease. Assets recorded in the financial statements are as follows: Equipment $700,000 Accumulated depreciation (100,000) Net $600,000 Note 11 LONG -TERM DEBT General Obligation Bonds - The City issues General Obligation Bonds to provide funds for the acquisition and construction of major capital facility additions, General Obligation Bonds have been issued to refund General Obligation Tax Increment and General Obligation Special Assessment Bonds. General Obligation Bonds are direct obligations and are backed by the full faith and credit of the City. General Obligation Bonds currently outstanding are as follows: 47 Final Original Interest Issue Maturity Balance Issue Rate Date Date End of Year Tax Increment Bonds: General Obligation Tax Increment Bonds of 1984 $1,070,000 7.00 -9.40% 6/1/84 3/1/94 $160,000 General Obligation Tax Increment Refunding Bonds of 1987, Series A 9,090,000 7.00- 7.50% 6/1/87 3/1/02 7,245,000 General Obligation Tax Increment Capital Appreciation Bonds of 1990 Principal 2,399,721 6.90 -7.15% 8/23/90 9/1/09 2,399,721 General Obligation Tax Increment Refunding Bonds of 1991 6,670,000 4.75 - 5.80% 12/1/91 3/1/02 6,670,000 General Obligation Tax Increment Refunding Bonds of 1993 735,000 3.80 - 5.15% 7/1/93 2/1/97 735,000 $17,209,721 47 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 Annual debt service requirements to maturity for general obligation bonds including interest of $6,305,482 are as follows: Fiscal Year Ending December 31 Total 1994 1995 1996 1997 1998 Thereafter $8,037,659 1,412,961 1,459,268 1,401,128 1,180,390 10,023,797 Totals $23,515,203 These figures include a refunding payment of $6,515,000 in 1994 for Tax Increment Bonds of 1987 to be paid in full from an escrow account managed by Norwest Bank Trust Services. Until the crossover refunding date, interest payments for Tax Increment Refunding Bonds of 1991 will be fully paid from interest income generated by the escrow account. At December 31, 1993, a total of $7,922,087 is available in Debt Service Funds to service the General Obligation Tax Increment Bonds. There are a number of limitations and instructions contained in the various bond indentures. The City is in compliance with all significant limitations and restrictions. The Tax Increment Bonds are payable from the amount of increase in the property taxes on the property in the Tax Increment District. Any deficiencies in revenue from these sources will be provided by general property taxes. Liability for Compensated Absences - Upon leaving City employment in good standing, employees shall receive payment based on their most recent level for all vacation leave earned but not taken and for one -third of earned but unused sick leave. The liability represents vested benefits earned by governmental fund employees through the end of the year which will be paid or used in future periods. Long -Term Debt - Other - The City is the administering authority for the following Tax Increment Finance Districts: A. 1977 Downtown CBD Revitalization Plan A3 Type of District Authorizing Law Duration of District Original Tax Capacity Current Tax Capacity (for taxes collectible in 1993) Captured Tax Capacity Retained Bonds Issued Principal Payments Bonds Outstanding at December 31, 1993 48 Redevelopment HRA (Minnesota Statutes Sections 462.545 and 462.585) August 1, 2009 $174,733 $1,084,071 $843,586 $28,434,721 $12,120,000 $16,314,721 CITY OF COLUMBIA HEIGHTS MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 B. 1984 Modification to the Downtown CBD Revitalization Plan C7 Type of District Authorizing Law Duration of District Original Tax Capacity Current Tax Capacity (for taxes collectible in 1993) Captured Tax Capacity Retained Bonds Issued Principal Payments Bonds Outstanding at December 31, 1993 C. 1984 University Avenue Redevelopment C8 Type of District Authorizing Law Duration of District Original Tax Capacity Current Tax Capacity (for taxes collectible in 1993) Captured Tax Capacity Retained Bonds Issued Principal Payments Bonds Outstanding at December 31, 1993 D. 1987 Sullivan Lake Development H2 Type of District Authorizing Law Duration of District ' Original Tax Capacity Current Tax Capacity (for taxes collectible in 1993) Captured Tax Capacity Retained Bonds Issued Principal Payments Bonds Outstanding at December 31, 1993 E . 1989 Multi -Use Redevelopment Plan K2 Type of District Authorizing Law Duration of District 1 Original Tax Capacity Current Tax Capacity (for taxes collectible in 1993) Captured Tax Capacity Retained Bonds Issued Principal Payments Bonds Outstanding at December 31, 1993 Redevelopment HRA (Minnesota Statutes Sections 462.545 and 462.585) August 1, 2009 $37,598 $71,654 $34,207 Redevelopment HRA (Minnesota Statutes Sections 462.545 and 462.585) August 1, 2009 $25,176 $112,724 $87,548 $1,070,000 $910,000 $160,000 Redevelopment HRA (Minnesota Statutes Sections 462.545 and 462.585) August 1, 2009 $41,323 $99,752 $58,429 $1,835,000 $1,100,000 $735,000 Redevelopment HRA (Minnesota Statutes Sections 462.545 and 462.585) October 4, 2014 $220,082 $172,109 49 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 Changes in Long -Term Liabilities - During the year ended December 31, 1993, the following changes occurred in liabilities reported in the General Long -Tern Debt Account Group: Balance Balance City January 1 Additions Reductions December 31 Note payable to HRA General Obligation Tax Increment Bonds: Principal Accreted interest General Obligation Special Assessment Bonds Liability for . compensated absences Total City $15,982 $ - $754 $15,228 18,149,721 735,000 1,675,000 17,209,721 359,490 197,194 - 556,684 910,000 - 910,000 - 343,397 18,646 362,043 $19,778,590 $950,840 $2,585,754 $18,143,676 Balance Balance HRA January 1 Additions Reductions December 31 Liability for compensated absences $9,590 $1,121 $ - $10,711 Total HRA $9,590 $1,121 $0 $10,711 In December 1991, the City issued $6,670,000 of General Obligation Tax Increment Refunding Bonds to advance refund $6,515,000 of the City's Tax Increment Bonds of 1987. Pending the call of the bonds to be refunded in 1994, the proceeds were deposited in an escrow account. Principal and interest on the 1987 bonds will be paid by the City until the call date. Interest payments on the 1991 issue will be paid from proceeds of the escrow account until the call date, after which time interest and principal will be paid by the City. In July, 1993, the City issued $735,000 of General Obligation Tax Increment Refunding Bonds to call the Tax Increment Taxable Bonds of 1987. This refunding resulted in a net savings of $58,692 over the life of the issue. With the exception of the 1990 Tax Increment Bonds, all General Obligation Bonds are serial bonds which require semiannual payments of principal and/or interest from the date the bonds are issued The 1990 Tax Increment Bonds are Capital Appreciation Bonds which require no payments of principal or interest until September 2002. During the year ended December 31, 1993, accreted interest of $556,684 was included in general long -term debt for the 1990 Tax Increment Capital Appreciation Bonds. 50 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 The following funds had a fund deficit as of December 31, 1993: Fund Deficit Special Revenue Fund: Community Police $6,463 Capital Project Funds: Capital Improvement Fund 401 139,042 Sheffield Redevelopment 385,401 The City will finance these deficits through external or internal sources in future years. For various reasons, certain funds have a portion of their fund equity reserved or designated for speck purposes. A discussion of each such item as it appears on the Combined Balance Sheet follows: A. RESERVATION OF RETAINED EARNINGS Reserve for Insurance - This reserve in the Insurance Internal Service Fund represents funds set aside to pay any claims from the period during which the City had no commercial insurance, and funds set aside to pay any amounts that may arise from a claim that exceeded the limits of current commercial Ipolicies. Reserve for Capital Replacement/Construction - This reserve in the Water and Sewer Enterprise Funds and the Central Garage Internal Service Fund represents funds set aside to pay for appropriate future capital replacementkonstruction projects. Reservations of retained earnings are summarized as follows at December 31, 1993: Internal Enterprise Service Total Reserve for capital replacement/construction: Water Utility Fund $491,767 $ - $491,767 Sewer Utility Fund 2,164,883 - 2,164,883 Central Garage Fund - 38,906 38,906 Reserve for insurance - 761,649 761,649 r Total $2,656,650 1800,555 $3,457,205 51 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 B. RESERVATION OF FUND BALANCES Reserve for Community Development - This reserve in the Housing and Redevelopment Authority's General Fund represents available resources dedicated to community development activities by prior community development grants. Reserved for Prepayments - This reserve represents financial resources used for prepayment of subsequent years expenditures. Reserved for Program Expenditures - This amount represents financial resources used for the Housing Mortgage Program. Reservations of fund balances at December 31, 1993 are summarized as follows: Reserve for prepayments $17,695 Reserve for program expenditures 446,352 Reserve for community development 170,497 Totals $634,544 C. DESIGNATED UNRESERVED FUND BALANCES Designated for Compensated Absences - This amount represents funds set aside by the City to provide for compensated absences in future years. Designated for Debt Service - These amounts represent fund balances which are presently committed to provide financial resources to pay principal and interest on the City's General Obligation Bonds. Designated for Subsequent Years' Expenditures - Unspent appropriations lapse at year -end. Amounts which are reappropriated in the next year's budget are reported as fund equity designations. Designated for Working Capital - This amount represents funds set aside by the City to provide positive cash flow for the next fiscal year. Designated for Business Revolving Loan Fund - This amount represents funds set aside by the HRA to provide certain low interest loans. Designated for PVVS Maintenance - This amount represents funds set aside by the HRA to provide for maintenance costs in future years at Parkview Villa South senior housing. 52 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 Designations for unreserved fund balances at December 31, 1993 are summarized as follows: The City maintains four Enterprise Funds which are intended to be self- supporting. Financial segment information as of and for the year ended December 31, 1993 is as follows: Water City of Columbia Heights Liquor Component Operating revenue $1,126,533 $1,021,710 Special Debt Capital Expendable Unit 113,245 1,022 General Revenue Service Proiect Trust HRA Total Designated for compensated absences $ - $ - $ - $ - $208,794 $ - $208,794 Designated for debt service - - 7,922,087 - - - 7,922,087 Designated for subsequent years' expenditures 17,771 369 - 4,550 - - 22,690 Designated for working capital 3,154,672 - - - - - 3,154,672 Designated for PWS maintenance - - - - - 193,004 193,004 Designated for Business Revolving Loan Fund - - - - 1,870,384 35,384 35,384 Total designated unreserved fiord balance $3,172,443 $369 $7,922,087 $4,550 $208,794 $228,388 $11,536,631 The City maintains four Enterprise Funds which are intended to be self- supporting. Financial segment information as of and for the year ended December 31, 1993 is as follows: This balance represents the cost of property contributed to the Enterprise Funds and Internal Service Funds by the City, less depreciation thereof charged to operations. Changes occurring in the account during the year were as follows: Water Sewer Central Utility Utility Garage Total Balance - beginning of year $856,807 $707,072 $188,849 $1,752,728 Less: Depreciation on contributed assets (26,294) (38,935) - (65,229) Balance - end of year $8 $668,137 $188,849 $1,687,499 53 Water Sewer Refuse Liquor Total Operating revenue $1,126,533 $1,021,710 $1,556,768 $5204,404 $8,909,415 Depreciation expense 87,522 113,245 1,022 57,878 259,667 Operating income 47,346 (9,617) 240,223 189,018 466,970 Net income (47,167) 87,859 186,689 59,291 286,672 Total operating transfers (161,262) (57,261) (83,221) (189,622) (491,366) Property, plant and equipment additions 246,842 200,490 - 203,301 650,633 Net working capital 936,400 2,430,997 748,169 965,450 5,081,016 Net cash provided by operating activities 150,916 (596,425) 204,010 156,279 (85,220) Total assets 2,784,149 4,497,791 753,275 1,657,183 9,692,398 Total equity - contributed 830,513 668,137 - - 1,498,650 Total equity - retained earnings 1,870,384 3,737,020 753,209 1,355,937 7,716,550 This balance represents the cost of property contributed to the Enterprise Funds and Internal Service Funds by the City, less depreciation thereof charged to operations. Changes occurring in the account during the year were as follows: Water Sewer Central Utility Utility Garage Total Balance - beginning of year $856,807 $707,072 $188,849 $1,752,728 Less: Depreciation on contributed assets (26,294) (38,935) - (65,229) Balance - end of year $8 $668,137 $188,849 $1,687,499 53 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 A. PLAN DESCRIPTION All full-time and certain part -time employees of the City of Columbia Heights are covered by defined benefit pension plans administered by the Public Employee's Retirement Association of Minnesota (PERA). PERA administers the Public Employee's Retirement Fund (PERF) and the Public Employees' Police and Fire Fund ( PEPFF) which are cost- sharing, multiple -employer retirement plans. PERF members belong to either the Coordinated Plan or the Basic Plan. Coordinated members are covered by Social Security and Basic members are not. All new members must participate in the Coordinated Plan. All police officers, firefighters, and peace officers who qualify for membership by Statute are covered by the PEPFF. The payroll for employees covered by PERF and PEPFF for the year ended December 31, 1993 was $2,601,202 and $1,144,340, respectively; the City's total payroll was $4,170,741. PERA provides retirement benefits as well as disability benefits to members, and benefits to survivors upon the death of eligible members. Benefits are established by State Statute, and vest after three years of credited service. The defined retirement benefits are based on a member's average salary for any five successive years of allowable service, age, and years of credit at termination of service. Two methods are used to compute benefits for Coordinated and Basic members. The retiring member receives the higher of step -rate benefit accrual formula (Method 1) or a level accrual formula (Method 2). Under Method 1, the annuity accrual rate for a Basic member is 2.0% of the average salary for each of the first ten years of service and 2.5% for each remaining year. For a Coordinated member, the annuity accrual rate is 1.0% of the average salary for each of the first ten years and 1.5% for each remaining year. Using Method 2, the annuity accrual rate is 2.5% of the average salary for Basic members. and 1.5% for Coordinated members. For PEPFF members, the annuity accrual rate is 2.5% for each year of service through June 30, 1993. (Effective July 1, 1993, the annual accrual rate for PEPFF is 2.65 percent.) For PERF members whose annuity is calculated using Method 1, and for all PEPFF members, a full annuity is available when age plus years of service equal 90. There are different types of annuities available to members upon retirement. A normal annuity is a lifetime annuity that ceases upon the death of the retiree. No survivor annuity is payable. There are also various types of joint and survivor annuity options available which will reduce the monthly normal annuity amount, because the annuity is payable over joint lives. Members may also leave their contributions in the fund upon termination of public service, in order to qualify for a deferred annuity at retirement age. Refunds of contributions are available at any time to members who leave public service, but before retirement benefits begin. 54 CITY OF COLUMBIA HEIGHTS MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 B. CONTRIBUTIONS REQUIRED AND CONTRIBUTIONS MADE Minnesota Statutes Chapter 353 sets the rates for employer and employee contributions. The City makes annual contributions to the pension plans equal to the amount required by State Statutes. According to Minnesota Statutes Chapter 356.215, Subdivision 4(g), the date of full funding required for the PERF and the PEPFF is the year 2020. As part of the annual actuarial valuation, PERA's actuary determines the sufficiency of the statutory contribution rates towards meeting the required full funding deadline. The actuary compares the actual contribution rate to a "required" contribution rate. Current combined statutory contribution rates and actuarially required contribution rates for the plans ,a are as follows: Statutory Rates: Required Employees Employer Rates* PERF (Basic and Coordinated Plans) 4.39% 4.67% 9.95% PEPFF 8.00% 12.00% 18.60% *The recommended rates scheduled above represent the required rates for fiscal year 1993 contributions as reported in the July 1, 1992, actuarial valuation reports. Total contributions made by the City during the fiscal year ended December 31, 1993 were: Percentage of Amount Covered Payroll Employees Employer Employees Employer PERF $120,742 $133,218 4.64% 5.12% PEPFF 91,547 137,321 8.00% 12.00% Totals $212,289 $270,539 The City's contribution for the year ended December 31, 1993 to the PERF represented .1177 percent of total contributions required of all participating entities. For the PEPFF, contributions for the year ended December 31, 1993, represented .4512 percent of total contributions required of all participating entities. C. FUNDING STATUS AND PROGRESS Pension Benefit Obligation The "pension benefit obligation" is a standardized disclosure measure of the present value of pension benefits, adjusted for the effects of projected salary increases and step -rate benefits, estimated to be payable in the future as a result of employee service to date. The measure, which is the actuarial present value of credited projected benefits, is intended to help users assess PERA's funding status on a going - concern basis, assess progress made in accumulating sufficient assets to pay benefits when due, and make comparisons among Public Employees' Retirement Systems and among employers. PERA does not make separate measurements of assets and pension benefit obligation for individual employers. 55 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 The pension benefit obligations as of June 30, 1993 are shown below: (In thousands) Total pension benefit obligation Net assets available for benefits, at cost (Market Values for PERF = $4,515,052; PEPFF = $1,173,312) Unfunded (assets in excess of) pension benefit obligation PERF PEPFF $5,163,766 $932,333 4,304,163 1,090,857 $859,603 ($158,524) The measurement of the pension benefit obligation is based on an actuarial valuation as of June 30, 1993. Net assets available to pay pension benefits were valued as of June 30, 1993. Changes in Benefit Provisions Three bills enacted during the 1993 legislative session improved benefits for many members without a material effect on the pension benefit obligation in the PERF or the PEPFF. The early retirement incentive bill permitted a public employer to offer PERA's Basic and Coordinated members an increase of one - fourth percent (.25%) in the formula multiplier for each year of service, up to the first 30 years, or health insurance coverage to age 65. Also, the survivor protection bill provided benefits to either a surviving spouse or children of PERF Coordinated Plan members who die before age 50. Lastly, the Police and Fire benefit increase bill, which became effective July 1, 1993, permanently increased the PEPFF formula multiplier from 2.5 percent to 2.65 percent of an individual's average salary over the five highest consecutive years of earnings. D. TEN -YEAR HISTORICAL TREND INFORMATION Ten -year historical trend information is presented in PERA's Component Unit Financial Report for the year ended June 30, 1993. This information is useful in assessing the pension plan's accumulation of sufficient assets to pay pension benefits as they become due. E. RELATED PARTY INVESTMENTS As of June 30, 1993, and for the fiscal year then ended, PERA held no securities issued by the City or other related parties. 56 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 Certain full -time and volunteer firefighters and policemen of the City participate in one of three single employer defined benefit pension plans. A detailed presentation of pension benefits, contributions, and funding status for each of the three plans is included in the notes that immediately follow this note to the financial statements. A summary of the pension benefit obligation and net assets available for benefits at December 31, 1993 is summarized as follows: * 1992 amounts were used for the Police Relief because 1993 amounts were not available A. PLAN DESCRIPTION Volunteer firefighters of the City of Columbia Heights are members of the Columbia Heights Fire Department Relief Association, Volunteer Division. The Division maintains a single- employer defined benefit pension plan. It is governed by a Board of Trustees composed of the members of the Columbia Heights City Council. The City Manager, Clerk- Treasurer, Chief of the Fire Department, and the Public Safety Director of the City are ex- officio members of the Board of Trustees. B. PENSION BENEFITS The bylaws, as amended in August 1989, provide for monthly pensions of $16 per year of service, for up to 30 years of service, for all Division members. Alternatively, members may elect a lump sum payment of $2,300 per year of service. Both monthly and lump sum pensions begin vesting after 10 years of service and are fully vested after 20 years. Benefits are payable after retiree is at least 50 years old. The Plan also provides for disability and survivor benefits. The City of Columbia Heights levies property taxes at the direction of and for the benefits of the Fire Relief Association, Volunteer Division and passes through State aids allocated to the Plan, all in accordance with enabling State Statutes. C. CONTRIBUTIONS REQUIRED AND CONTRIBUTIONS MADE The Association's funding policy provides for periodic City contributions in accordance with State Statutes. The minimum actuarially determined contribution required by Statutes is the annual normal cost plus amortization of any unfunded actuarial liability using the entry age actuarial cost method. Significant actuarial assumptions used to calculate contribution requirements were the same as these used to compute the required reserves. 57 Fire Relief Fire Relief Total Association - Association - Police Single Volunteer Paid Relief Employer Division Division Asssociation* Plans Pension benefit obligation $549,936 $2,148,174 $4,685,115 $7,383,225 Net assets available for pension benefits, at cost 909,384 1,694,983 3,225,552 5,829,919 Unfunded (assets in excess of) pension benefit obligation ($359,448) $453,191 $1,459,563 $1,553,306 * 1992 amounts were used for the Police Relief because 1993 amounts were not available A. PLAN DESCRIPTION Volunteer firefighters of the City of Columbia Heights are members of the Columbia Heights Fire Department Relief Association, Volunteer Division. The Division maintains a single- employer defined benefit pension plan. It is governed by a Board of Trustees composed of the members of the Columbia Heights City Council. The City Manager, Clerk- Treasurer, Chief of the Fire Department, and the Public Safety Director of the City are ex- officio members of the Board of Trustees. B. PENSION BENEFITS The bylaws, as amended in August 1989, provide for monthly pensions of $16 per year of service, for up to 30 years of service, for all Division members. Alternatively, members may elect a lump sum payment of $2,300 per year of service. Both monthly and lump sum pensions begin vesting after 10 years of service and are fully vested after 20 years. Benefits are payable after retiree is at least 50 years old. The Plan also provides for disability and survivor benefits. The City of Columbia Heights levies property taxes at the direction of and for the benefits of the Fire Relief Association, Volunteer Division and passes through State aids allocated to the Plan, all in accordance with enabling State Statutes. C. CONTRIBUTIONS REQUIRED AND CONTRIBUTIONS MADE The Association's funding policy provides for periodic City contributions in accordance with State Statutes. The minimum actuarially determined contribution required by Statutes is the annual normal cost plus amortization of any unfunded actuarial liability using the entry age actuarial cost method. Significant actuarial assumptions used to calculate contribution requirements were the same as these used to compute the required reserves. 57 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 During the year ended December 31, 1993, contributions totaling $43,617 (all employer) were made in accordance with contribution requirements determined by an actuarial valuation of the Plan as of December 31, 1992. The contributions represent normal cost only since there was no unfunded actuarial liability. Benefits and contributions are not based on payroll; accordingly, there is no covered payroll. D. FUNDING STATUS The amount shown on the following page as the "pension benefit obligation" is a standardized disclosure measure of the present value of pension benefits, adjusted for the effects of projected salary increases, estimated to be payable in the future as a result of employee service to date. The measure is the actuarial present value of credited projected benefits and is intended to (1) help users assess the Plan's funding status on a going - concern basis, (2) assess progress being made in accumulating sufficient assets to pay benefits when due, and (3) allow for comparisons among public employee retirement plans. The measure is independent of the actuarial funding method used to determine contributions to the Plan. The pension benefit obligation was determined as part of an actuarial valuation of the plan as of December 31, 1992. Significant actuarial assumptions used in determining the pension benefit obligation include (a) a rate of return on the investment of present and future assets of 5.0% per year compounded annually and (b) the assumption that benefits will not increase after retirement. At December 31, 1993, the assets in excess of the pension benefit obligation were $359,448, determined as follows: Pension benefit obligation Retirees and beneficiaries currently receiving benefits and terminated employees not yet receiving benefits $352,387 Current employees: Accumulated employee contributions including allocated investment income - Employer financed 197,549 Total pension benefit obligation 549,936 Net assets available for benefits, at cost (market value was $934,089) 909,384 (Assets in excess of) pension benefit obligation ($359,448) CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 IE. HISTORICAL TREND INFORMATION Three -Year Historical Trend Information December 31, 1991 1992 1993 Net assets available for benefits, as a percentage of pension benefit obligation 139% 156% 165% Unfunded (assets in excess of) pension benefit obligation, as a percentage of annual covered payroll N/A N/A N/A Employer contributions, as a percentage of annual covered payroll N/A N/A N/A Financial requirements of the Relief Association are determined in accordance with State Statutes rather than actuarially. Ten -Year Historical Trend Information Ten -year historical trend information is presented in the Relief Association's Annual Financial Report This information is useful in assessing the pension plan's accumulation of sufficient assets to pay pension benefits as they become due. F. RELATED PARTY INVESTMENTS During 1993, the Association held no securities issued by the City or other related parties. A. PLAN DESCRIPTION Paid full -time regular firefighters of the City of Columbia Heights first employed by the City on or prior to December 31, 1974 are members of the Columbia Heights Fire Relief Association, Paid Division. The Division maintains a single - employer defined benefit pension plan. First Trust acts as trustee for the beneficiaries. The City's covered payroll for members of the Paid Relief Association for the year ended December 31, 1992 was $37,232 compared to a total City payroll of $4,170,741. B. PENSION BENEFITS A firefighter who completes at least 20 years of service as an active member of the Columbia Heights Fire Department and has been a member of the Relief Association for at least 20 years, after age 50, is entitled to a full service pension upon retirement. For the first 20 years of service, the individual is entitled to 35/80 of base pay (base pay is defined as the salary of a first grade fireman). For each year in excess of 20, an additional 1/80 is added up to a maximum of 45/80 of base pay for 30 or more years of service. In addition and not subject to the above maximum, for each year over 25, a benefit of 1/2% of base pay is added to the benefit. (The additional benefit is not subject to the post- retirement adjustment provisions.) 59 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 A member is entitled to disability benefits as follows: a) Less than 10 years service - 30/80 of base pay b) 10 to 15 years service - 35/80 of base pay c) 15 or more years service - 40/80 of base pay to age 50 at which time the benefit is recomputed based on service assuming a minimum of 20 years of service. Post - retirement adjustments ("Escalator "): Each time base pay is changed, payments to all benefit recipients are simultaneously changed by the same percent that base pay is changed. C. CONTRIBUTIONS REQUIRED AND CONTRIBUTIONS MADE The Association's funding policy provides for periodic employer contributions at actuarially determined rates that, expressed as percentages of annual covered payroll, are designed to accumulate sufficient assets to pay benefits when due. The normal cost and actuarial accrued liability are determined using an entry age actuarial funding method. Unfunded actuarial accrued liabilities are being amortized as a level dollar amount over a period of 19 years. During the year ended December 31, 1993, contributions totaling $99,445 (all employer) were made in accordance with contribution requirements determined by an actuarial valuation of the Plan as of December 31, 1992. Employer contributions represented 267%n of covered payroll. The employer contributions consisted of $32,383 for normal cost and $67,062 for amortization of unfunded actuarial accrued liability. Significant actuarial assumptions used to compute contribution requirements were the same as those used to compute the required reserves. D. FUNDING STATUS The amount shown on the following page as the "pension benefit obligation" is a standardized disclosure measure of the present value of pension benefits, adjusted for the effects of projected salary increases, estimated to be payable in the future as a result of employee service to date. The measure is the actuarial present value of credited projected benefits and is intended to (1) help users assess the Plan's funding status on a going -concern basis, (2) assess progress being made in accumulating sufficient assets to pay benefits when due, and (3) allow for comparisons among public employee retirement plans. The measure is independent of the actuarial funding method used to determine contributions to the Plan. The pension benefit obligation was determined as part of an actuarial valuation of the Plan as of December 31, 1992. Significant actuarial assumptions used in determining the pension benefit obligation include (a) a rate of return on the investment of present and future assets of 5.0% per year compounded annually, (b) projected salary increases of 3.5% per year compounded annually, attributable to inflation, and (c) the assumption that benefits will increase 3.5% per year after retirement. M1 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 At December 31, 1993, the unfunded pension benefit obligation was $453,191, determined as follows: Pension benefit obligation Retirees and beneficiaries currently receiving benefits and terminated employees not yet receiving benefits $1,798,020 Current employees: Accumulated employee contributions including allocated investment income 36,081 Employer financed 314,073 Total pension benefit obligation 2,148,174 Net assets available for benefits, at cost (market value was $1,726,126) 1,694,983 Unfunded pension benefit obligation $453,191 E. HISTORICAL TREND INFORMATION Three -Year Historical Trend Information December 31, 1991 1992 1993 Net assets available for benefits, as a percentage of pension benefit obligation 67% 77% 79% Unfunded (assets in excess of) pension benefit obligation, as a percentage of annual covered payroll 2165% 1342% 1217% Employer contributions, as a percentage of annual covered payroll 322% 323% 267% Contributions made were in accordance with actuarially determined requirements. Ten -Year Historical Trend Information Ten -year historical trend information related to the pension plan is presented in the Relief Association's Annual Financial Report. This information is useful in assessing the pension plan's accumulation of sufficient assets to pay pension benefits as they become due. F. RELATED PARTY INVESTMENTS During 1993, the Association held no securities issued by the City or other related parties. 61 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 Amounts reported for this note are for 1992 because 1993 information was not available. A. PLAN DESCRIPTION All policemen fast employed by the City of Columbia Heights on or before June 15, 1972 are members of the Columbia Heights Police Relief Association. The Association is a single employer pension plan. It is governed by a Board of Directors consisting of members of the Association regardless of whether such members are active or retired members of the Columbia Heights Police Department. The City's payroll for members of the Relief Association for the year ended December 31, 1992 was $157,344 compared to a total City payroll of $4,027,556. B. PENSION BENEFITS A policeman who completes at least 20 years as an active member of the Columbia Heights Police Department and has been member of the Relief Association for least 20 years, after age 50, is entitled to a full service pension upon retirement. The service pension prescribed by the Relief Association's by -laws is 35/80 of base pay (base pay is defined as the salary of a top patrolman). For each year in excess of 20, an additional 1/80 is added up to a maximum of 40/80 of base pay for 25 or more years of service. In addition, and not subject to the above maximum for each year over 25, a benefit of 1/2% of base pay is added to the benefit. (The additional benefit is not subject to the post - retirement adjustment provisions.) A member is entitled to disability benefits of 35/80 of salary at the time of the disability. C. CONTRIBUTIONS REQUIRED AND CONTRIBUTIONS MADE The Association's funding policy provides for periodic employer contributions at actuarially determined rates that, expressed as percentages of annual covered payroll, are designed to accumulate sufficient assets to pay benefits when due. The normal cost and actuarial accrued liability are determined using an entry age actuarial funding method. Unfunded actuarial accrued liabilities are being amortized as a level dollar amount over a period of 18 years. During the year ended December 31, 1992, contributions totaling $213,216 ($204,719 employer and $8,497 employees) were made in accordance with contribution requirements determined by an actuarial valuation of the Plan as of December 31, 1990. The employer contribution consisted of $43,932 for normal cost and $160,787 for amortization of the unfunded actuarial accrued liability. The employee contributions were entirely for normal cost. Employer and employee contributions represented 137% and 5.7 %, respectively, of covered payroll. D. FUNDING STATUS The Governmental Accounting Standards Board (GASB) requires disclosure of the total pension benefit obligation as determined by a standardized measurement of the actuarial present value of estimated pension benefits that will be paid in future years as a result of employee services performed to date. A standardized measure of the pension benefit obligation was adopted by GASB to enable readers of the financial statements to (1) assess the Association's funding status on a going - concern basis, (2) assess progress made in accumulating sufficient assets to pay benefits when due, and (3) make comparisons among relief associations. This measurement is independent of the funding method used to determine required contributions. The pension benefit obligation was determined as part of an actuarial valuation of the plan as of December 31, 1992. 62 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 A variety of significant actuarial assumptions are used to determine the standardized measure of the pension benefit obligation and these assumptions are as follows: 1) A rate of return on the investment of present and future assets of 5.0% per year compounded annually. 2) Projected salary increases of 3.5% per year compounded annually, attributable to inflation. 3) The assumption that benefits will increase 3.5% per year after retirement. At December 31, 1992, the unfunded pension benefit obligation was as follows: Pension benefit obligation Retirees and beneficiaries currently receiving benefits and retired policemen entitled to benefits, but not yet receiving them $3,130,752 Current employees Accumulated employee contributions including allocated investment income 153,476 Employer financed 1,400,887 Total pension benefit obligation 4,685,115 Net assets available for benefits, at cost (market value was $3,367,799) 3,225,552 Unfunded pension benefit obligation $1,459,563 The total pension benefit obligation as of January 1, 1992 was $4,634,966. During the year, the Plan experienced a net change of $50,149 in the pension benefit obligation. E. HISTORICAL TREND INFORMATION Three -Year Historical Trend Information December 31, 1990 1991 1992 Net assets available for benefits, as a percentage of pension benefit obligation 61% 64% 69% Unfunded (assets in excess of) pension benefit obligation, as a percentage of annual covered payroll 1238% 1110% 975% Employer contributions, as a percentage of annual covered payroll 131% 136% 137% Financial requirements of the Relief Association are determined in accordance with State Statutes rather than actuarially. Ten -Year Historical Trend Information Ten -year historical trend information related to the pension plan is presented in the Relief Association's Annual Financial Report. The information is presented to enable the reader to assess the progress made by the Plan in accumulating sufficient assets to pay pension benefits as they become due. 63 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 F. RELATED PARTY INVESTMENTS During 1992, the Association held no securities issued by the City or other related parties. Note 20 DEFERRED COMPENSATION PLAN The government offers its employees a deferred compensation plan created in accordance with Internal Revenue Code Section 457. The Plan, available to all government employees, permits them to defer a portion of their salary until future years. Participation in the Plan is optional. The deferred compensation is not available to employees until termination, retirement, oath, or unforeseeable emergency. All amounts of compensation deferred under the Plan, all property and rights purchased with those amounts, and all income attributable to those amounts, property, or rights are (until paid or made available to the employee or other beneficiary) solely the property and rights of the government subject only to the claims of the government's general creditors. Participants' rights under the Plan are equal to those of general creditors of the government in an amount equal to the fair market value of the deferred account for each participant. It is the opinion of management that the government has no liability for losses under the Plan but does have the duty of due care that would be required of an ordinary prudent investor. The government believes that it is unlikely that it will use the assets to satisfy the claims of general creditors in the future. Investments are managed by the Plan's trustee under one of four investment options, or a combination thereof. The choice of the investment option(s) is made by the participants. Assets of the Plan are reflected in these statements in an Agency Fund at market value. Note 21 COMMITMENTS AND CONTINGENCIES A. RISK MANAGEMENT Although the City carries insurance for current risks, there is no coverage maintained for possible losses arising from occurrences in certain previous years. The City is not aware of any unreported or pending claims which could have a material effect on the City. Existing litigation is discussed below. During 1989, the HRA was added to the City of Columbia Heights Workers' Compensation Policy. The policy is a premium refund option plan which has an established minimum premium that both the City and the HRA pay. The policy also has a maximum premium based on the number of claims and the cost of the claims during the year. Under the terms of this policy, the potential cost to the HRA could be significantly higher than the minimum premiums paid. The HRA is aware of no claims that would result in additional premium payments at this time. In February 1991, the HRA purchased its own workers' compensation policy which is not subject to the minimum /maximum premium provisions. _ B. LITIGATION The City had the usual and customary type of miscellaneous claims pending at year -end, mostly of a minor nature. The HRA has been a named defendant in litigation alleging failure to perform under the terms and conditions of an amendment to an assessment agreement. The HRA won summary judgment on all claims on December 11, 1993, however, the plaintiff has appealed this judgment. If the judgment is reversed, the potential range of loss is from zero to $1.2 million where the most reasonable estimate is $230,000 plus interest from 1990. The HRA's attorney estimates the probability of an unfavorable outcome to be approximately 15 %. The HRA's insurance carrier has denied coverage. I 64 1 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 1993 C . FEDERAL AND STATE FUNDS Amounts received or receivable from federal and state agencies are subject to agency audit and adjustment. Any disallowed claims, including amounts already collected, may constitute a liability of the applicable funds. The amount, if any, of funds which may be disallowed by the agencies cannot be determined at this time although the HRA expects such amounts, if any, to be immaterial. D. COMMITTED CONTRACTS At December 31, 1993 the City was committed to the following contracts: Completed Contract Through Committed Authorized 12/31/93 Contract Library Project $66,105 $ - $66,105 Note 22 PRIOR PERIOD ADJUSTMENT Beginning in 1993, the City changed the expense recognition policy for MWCC final cost allocations from the cash basis to the accrual basis. This change was made because these allocations were typically not available at the time the financial statements were prepared. This information is now available earlier in the year. A prior period adjustment was made to the Enterprise Sewer Fund of $138,262 to account for this change. Note 23 SUBSEOUENT EVENTS The paid division of the Columbia Heights Fire Relief Association was merged into the Public Employers Retirement Association (PERA) effective January 1, 1994. The Columbia Heights Police Relief Association was scheduled to merge into PERA effective 5/1/94. It is expected that these mergers will result in future savings in pension costs to the City. Note 24 CHANGES IN COMPARATIVE STATEMENTS Prior to 1993, the financial activity of the library was accounted for in the City's General Fund. The library's financial activity is now accounted for in a separate Special Revenue Fund. Prior year comparative amounts have not been restated for this change. 65 CH me CITY OF COLUMBIA HEIGHTS, M NNESOTA COMBINING, INDIVIDUAL FUND AND ACCOUNT GROUP FINANCIAL STATEMENTS 67 CH CITY OF COLUMBIA HEIGHTS, MINNESOTA F, 68 1 GENERAL FUND The Home Rule Charter of the City of Columbia Heights provides in Section 69, Subdivision (c): "A General Fund for the support of such other funds and for the payment of such expenses of the City as the Council may deem proper. Into this fund shall be paid all monies not herein provided to paid (sic) into any other fund." .' CH 70 CITY OF COLUMBIA HEIGHTS, MINNESOTA ' CITY OF COLUMBIA HEIGHTS, MINNESOTA GENERAL FUND Statement 6 'BALANCE SHEET December 31, 1993 With Comparative Amounts For December 31, 1992 Assets 1993 1992 ' Cash and cash equivalents $3,139,309 $3,072,563 Receivables: ' Accounts 11,001 12,451 Taxes: Unremitted 49,259 31,796 Delinquent 123,285 109,305 Interest 10,515 18,145 Due from other governmental units 56,896 49,224 from other funds 149,376 - 'Due Due from component unit 7,648 3,827 Prepaid expense 9,496 320 ' Total assets $3,556,785 $3,297,631 ' Liabilities and Fund Balance Liabilities: ' Accounts payable $98,670 $63,536 Accrued salaries and withholdings payable 120,105 104,520 Due to other governmental units 4,526 66,829 ' Due to component unit 3,510 4,075 Deferred revenue 148,035 132,805 Total liabilities 374,846 371,765 Fund Balance: Reserved for prepayments 9,496 320 ' Unreserved: Designated for subsequent years' expenditures 17,771 39,836 Designated for working capital 3,154,672 2,885,710 ' Total fund balance 3,181,939 2,925,866 Total liabilities and fund balance $3,556,785 $3,297,631 71 CITY OF COLUMBIA HEIGHTS, MINNESOTA GENERAL FUND Statement 7 STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - Page 1 of 2 BUDGET AND ACTUAL For The Year Ended December 31, 1993 With Comparative Actual Amounts For The Year Faded December 31, 1992 Revenues: Taxes Licenses and permits Intergovernmental Charges for services Fines and forfeitures Interest Other revenues: Miscellaneous Proceeds from sale of land Total revenues Expenditures: General government: Council Manager Legal Finance and elections Assessing Planning General government buildings Total general government Public safety: Policelanimal/civil defense Fire Inspections Total public safety Public works: Engineering Maintenance Total public works Other departments: Sanitation Parks and recreation Library Contingencies Total other departments 1993 Over (under) 1992 Budget Actual Budget Actual 0 t $2,082,715 $2,060,355 ($22,360) $2,388,718 152,450 135,545 (16,905) 125,275 3,157,394 3,181,600 24,206 3,238,950 ' 341,153 347,513 6,360 349,875 112,150 89,464 (22,686) 104,673 120,000 179,000 59,000 136,814 ' 29,750 20,640 (9,110) 19,099 500 - (500) 500 , 5,996,112 6,014,117 18,005 6,363,904 247,166 186,245 (60,921) 178,063 ' 295,544 294,803 (741) 241,420 176,874 176,788 (86) 174,654 529,382 503,354 (26,028) 503,318 , 105,469 105,248 (221) 108,272 28,680 22,571 (6,109) 16,352 207,970 152,594 (55,376) 134,716 ' 1,591,085 1,441,603 (149,482) 1,356,795 1,889,120 1,877,463 (11,657) 1,745,072 733,987 680,944 (53,043) 680,973 132,190 120,865 (11,325) 137,743 2,755,297 2,679,272 (76,025) 2,563,788 ' 258,234 228,920 (29,314) 246,767 ' 715,566 578,070 (137,496) 572,533 973,800 806,990 (166,810) 819,300 , 150,651 149,054 (1,597) 176,216 1,096,652 977,911 (118,741) 998,970 - - - 383,933 1,367 268 (1,099) 18,204 1,248,670 1,127,233 (121,437) 1,577,323 , 72 Total expenditures 6,568,852 6,055,098 (513,754) 6,317,206 CITY OF COLUMBIA HEIGHTS, MINNESOTA GENERAL FUND Statement 7 STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - Page 2 of 2 BUDGET AND ACTUAL For The Year Ended December 31, 1993 With Comparative Actual Amounts For The Year Ended December 31, 1992 Revenues over (under) expenditures Other financing sources (uses): Operating transfers in Operating transfers (out) Total other financing sources (uses) Net increase (decrease) in fund balance Fund balance - January 1 Residual equity transfers Fund balance - December 31 2,925,866 86,598 $3,181,939 3,033,095 $2,925,866 73 1993 Over (under) 1992 Budget Actual Budget Actual ($572,740) ($40,981) $531,759 $46,698 374,838 406,961 32,123 493,439 (196,757) (196,505) 252 (647,366) 178,081 210,456 32,375 (153,927) ($394,659) 169,475 $564,134 (107,229) 2,925,866 86,598 $3,181,939 3,033,095 $2,925,866 73 CITY OF COLUMBIA HEIGHTS, MINNESOTA GENERAL FUND Statement 8 SCHEDULE OF REVENUES - BUDGET AND ACTUAL For The Year Ended December 31, 1993 With Comparative Actual Amounts For The Year Faded December 31, 1992 Revenues: Property taxes: Ad valorem Penalties and interest Total taxes Licenses and permits: Licenses Permits Total licenses and permits Intergovernmental: Federal grants: Civil defense State grants: State grant Local government aid Property tax relief Law officer training Shade tree Police Relief Association Fire Relief Association County aid: Street maintenance County grant School district Total intergovernmental Charges for services: General government Library Public safety Public works Parks and recreation Total charges for services Fines and forfeitures Library Public safety Total fines and forfeitures Other revenues: Interest earned on investments Miscellaneous Proceeds from sale of land Other refunds Total other revenues Total revenues 74 1993 Over (under) Budget Actual Budget $2,075,715 $2,047,566 ($28,149) 7,000 12,789 5,789 2,082,715 2,060,355 (22,360) 88,450 77,276 (11,174) 64,000 58,269 (5,731) 152,450 135,545 (16,905) 1992 A -.-1 $2,379,700 9,018 2,388,718 80,081 45,194 125,275 4,185 4,910 725 3,802 , - 370 370 12,081 1,919,393 1,919,439 46 2,022,119 1,008,951 1,009,673 722 961,888 8,000 7,050 (950) 6,263 - 5,000 5,000 5,000 111,545 128,607 17,062 126,246 61,376 52,621 (8,755) 55,999 18,060 18,060 - 18,060 - 4,325 4,325 9,830 25,884 31,545 5,661 17,662 3,157,394 3,181,600 24,206 3,238,950 32,853 43,844 10,991 33,178 - - - 7,349 114,100 126,130 12,030 113,974 29,800 28,526 (1,274) 43,338 164,400 149,013 (15,387) 152,036 341,153 347,513 6,360 349,875 - - - 9,422 112,150 89,464 (22,686) 95,251 112,150 89,464 (22,686) 104,673 120,000 179,000 59,000 136,814 27,250 19,203 (8,047) 17,083 500 - (500) 500 2,500 1,437 (1,063) 2,016 150,250 199,640 49,390 156,413 $5,996,112 $6,014,117 $18,005 $6,363,904 CITY OF COLUMBIA HEIGHTS, MINNESOTA GENERAL FUND 1 SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL For The Year Ended December 31, 1993 With Comparative Actual Amounts For The Year Ended December 31, 1992 Statement 9 ' 1993 Actual Supplies Over ' Personal and Capital (under) 1992 Budget Services Services Outlay Total Budget Actual Expenditures: General government: Council and manager: Council $247,166 $103,965 $82,280 $- $186,245 ($60,921) $178,063 Manager 295,544 265,193 29,610 294,803 (741) 241,420 Legal 176,874 176,788 = 176,788 (86) 174,654 Total council and manager 719,584 369,158 288,678 0 657,836 61,748 594,137 Administrative services: ' Finance 504,740 373,464 64,583 46,020 484,067 (20,673) 464,250 Elections 24,642 14,405 4,882 - 19,287 (5,355) 39,068 Assessing 105,469 36,972 67,924 352 105,248 (221) 108,272 ' Planning 28,680 8,194 14,377 - 22,571 (6,109) 16,352 General government buildings 207,970 5,492 123,433 23,669 152,594 55,376 134,716 Total administrative services 871,501 438,527 275,199 70,041 783,767 817,734) 762,658 Total general government 1,591,085 807,685 563,877 70,041 1,441,603 149,482 1,356,795 ' Public safety: Police 1,848,706 1,691,008 140,879 12,356 1,844,243 (4,463) 1,714,605 Fire 733,987 625,921 50,572 4,451 680,944 (53,043) 680,973 ' Inspections 132,190 108,134 12,731 - 120,865 (11,325) 137,743 Civil defense 27,702 11,849 7,970 956 20,775 (6,927) 20,475 Animal control 12,712 - 12,445 - 12,445 (267) 9,992 ' Total public safety 2,755,297 2,436,912 224,597 17,763 2,679,272 6,025 2,563,788 Public works, highways and streets: Engineering 258,234 194,779 31,929 2,212 228,920 (29,314) 246,767 Streets 561,119 231,012 192,327 593 423,932 (137,187) 444,593 Street lighting 109,800 1,174 108,544 - 109,718 (82) 91,148 Traffic signs /signals 44,647 30,766 13,654 - 44,420 (227) 36,792 Total public works, highways and streets 973,800 457,731 346,454 2,805 806,990 166,810 819,300 Other departments: Sanitation 150,651 36,483 110,321 2,250 149,054 (1,597) 176,216 Parks and recreation 1,096,652 648,994 295,652 33,265 977,911 (118,741) 998,970 ' Library - - - - - 383,933 Contingencies 1,367 268 _ 268 1,099 18,204 Total other departments 1,248,670 685,477 406,241 35,515 1,127,233 121,437 1,577,323 ' Total expenditures $6,568,852 $4,387,805 $1,541,169 $126,124 $6,055,098 ($513,754) $6,317,206 75 CH 76 CITY OF COLUMBIA HEIGHTS, MINNESOTA 1 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. ' Municipal State Aid Fund - maintained according to State Statute for maintenance and construction of streets or municipal state aid systems. ' Cable Television Fund - established to account for revenues and expenditures associated with cable �a television franchise. Paratransit Fund - established by agreement with the �' 3p Minnesota Department of Transportation to account for the receipt of State grants and rider fees and expenditures for service. D.A.R.E. Program Fund - established to account for a�0 revenues and expenditures of D.A.R.E. (Drug Awareness) Program. ' `yU revenues and expenditures off the library. to account for racy ' Housing Mortgage Fund - established to account for 3,n) refinancing proceeds which are n to restricted for debt ' service. Recreation Contributed Projects Fund - established to monitor contributions for recreational activities and ' elated expenditures. Contributed Projects Fund - established to monitor ' 3 contributions and elated expenditures. Community Police Fund - established in 1992 to account -77 for revenues and expenditures associated with grant ' received for Community Police Program for Hilltop. Project Pride - established in 1992 to ensure that every ' resident of the City has access to recreation programs. Parking Ramp Fund - established to account for ' dqv revenues from parking ramp assessment that are to be used for redevelopment. ' Confiscated Property - established to account for funds 5 from property confiscated by the police department. 77 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUNDS COMBINING BALANCE SHEET j December 31, 1993 With Comparative Totals For December 31, 1992 Assets Cash and investments Cash and investments held in escrow Receivables: Accounts Special assessments Interest Due from other governmental units Due from other funds Prepaid expense Total assets Liabilities and fund balance Liabilities: Accounts payable Accrued salaries and withholdings payable Contracts payable - retained percentage Due to other governmental units Due to other funds Deferred revenue Deposits Total liabilities Fund balance (deficit): Reserved for prepayments Reserved for program expenditures Unreserved: Designated for subsequent years' expenditures Undesignated Total fund balance (deficit) Total liabilities and fund balance W. Municipal n�J �� y4 State Cable D.A.R.E. Aid Television Paratransit Program Library $49,458 $301,852 $56,680 $2,727 $30,370 - 19,063 9,879 - - - 1,343 306 - - 30,945 3,909 13,873 - - 180 225 - - 250 $80,583 $326,392 $80,738 $2,727 $30,620 $ - $1,248 $28,219 $ - $2,881 1,226 - - - 1,452 418 1,226 1,248 28,219 0 4,751 180 225 - - 250 - 178 - - 191 79,177 324,741 52,519 2,727 25,428 79,357 325,144 52,519 2,727 25,869 $80,583 $326,392 $80,738 $2,727 $30,620 Statement 10 79 Recreation Housing Contributed Contributed Community Project Parking Confiscated Totals ' Mortgage Projects Projects Police Pride Ramp Property 1993 1992 $12,727 $24,111 $17,804 $= $3,428 $311,282 $2,340 $812,779 $451,823 446,352 446,352 433,966 - 28,942 32,806 - - - - - 528,045 528,045 561,631 56 - - - - 1,379 - 3,084 2,531 - - - 31,768 - - - 80,495 73,240 ' - - - - - - - - 105,026 - - - - - - - 655 - $459,135 $24,111 $17,804 $31,768 $3,428 $840,706 $2,340 $1,900,352 $1,661,023 $ $4,644 $ $ $ $ $ $36,992 $12,473 ' = = = = = 2,678 640 - - - - - - - - 4,477 418 - 1 - - - 11,564 - - - 11,564 105,026 - - - 26,667 - 528,045 - 554,712 594,989 - 180 - - - - - 180 - 0 4,824 0 38,231 0 528,045 0 606,544 717,605 ' - 655 - 446,352 - - - - - - 446,352 433,966 - - - - - - - 369 750 12,783 19,287 17,804 6,463 3,428 312,661 2,340 846,432 508,702 459,135 19,287 171804 (6,463) 3,428 312,661 2,340 1,293,808 943,418 $459,135 $24,111 $17,804 $31,768 $3,428 $840,706 $2,340 $1,900,352 $1,661,023 79 CITY OF COLUMBIA HEIGHTS, MINNESOTA �. SPECIAL REVENUE FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND 1 CHANGES IN FUND BALANCE For The Year Ended December 31, 1993 With Comparative Totals For The Year Ended December 31, 1992 Revenues: Taxes Special assessments Intergovernmental Fees/program revenue Interest Other revenues: Miscellaneous Contributions Total revenues Expenditures: Parks and recreation: Personal services Supplies Other services and charges Capital outlay Other. Personal services Supplies Other services and charges Capital outlay Total expenditures Revenues over (under) expenditures Other financing sources (uses): Operating transfers in Operating transfers (out) Total other financing sources (uses) Net increase (decrease) in fund balance Fund balance (deficit) - January 1 Fund balance (deficit) - December 31 :1 1 Municipal State Cable D.A.R.E. Aid Television Paratransit Program Library , $= $_ $= $= $378,979 , 424,610 - 136,542 - - - 73,154 20,537 - 17,017 - 22,867 5,217 - - - 3,909 3,250 30 63 - - - 1,663 ' 424,610 99,930 165,546 1,693 396,059 35,499 908 - - 260,323 842 1,335 589 3,771 63,771 22,054 15,471 155,005 736 50,531 175,266 1,815 - - 1,866 233,661 19,529 155,594 4,507 376,491 190,949 80,401 9,952 (2,814) 19,568 L 10,000 2,500 12,590 ' (48,690) (45,928) (6,217) - (6,289) (48,690) (45,928) 3,783 2,500 6,301 142,259 34,473 13,735 (314) 25,869 (62,902) 290,671 38,784 3,041 - ' $79,357 $325,144 $52,519 $2,727 $25,869 Statement 11 13,346 (764) 9,523 (8,424) (661) 118,841 2,340 432,257 616,068 - c/ - 6,667 - - - 31,757 110,669 - - Recreation - v - - (113,624) v 0 0 Housing Contributed Contributed Community Project Parking Confiscated Totals ' Mortgage Projects Projects Police Pride Ramp Property 1993 1992 (4,706) 4,089 193,820 - 943,418 272,983 $459,135 $- $- $- $- $- $- $- $378,979 $ - - - - - - 95,366 - 95,366 95,366 - - - 40,000 - - - 601,152 266,023 - 6,666 - 117,374 92,761 ' 13,346 = = 23,475 64,905 19,970 - - - - - - 2,340 9,592 521,568 ' - 60,790 38,710 - 333 - - 101,496 45,106 13,346 60,790 38,710 46,666 333 118,841 2,340 1,368,864 1,040,794 - - - - 532 - - 532 545 ' = 43,172 290 43,462 31,051 18,382 172 = = 18,554 13,455 - - - - - - - - 3,519 ' - - - 55,090 - - - 351,820 51,327 - - 12,513 - - - - 82,821 4,001 9,457 253,254 183,381 = = 7,217 = = = = 186,164 137,447 0 61,554 29,187 55,090 994 0 0 936,607 424,726 13,346 (764) 9,523 (8,424) (661) 118,841 2,340 432,257 616,068 - - - 6,667 - - - 31,757 110,669 - - (6,500) - - - - (113,624) 56,302 0 0 (6,500) 6,667 0 0 0 (81,867) 54,367 ' 13,346 (764) 3,023 (1,757) (661) 118,841 2,340 350,390 670,435 445,789 20,051 14,781 (4,706) 4,089 193,820 - 943,418 272,983 $459,135 $19,287 $17,804 ($6,463) $3,428 $312,661 $2,340 $1,293,808 $943,418 RE CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - MUNICIPAL STATE AID STREET FUND Statement 12 STATEMENT OF REVENUES, EXPENDITURES AND , CHANGES IN FUND BALANCE - BUDGET AND ACTUAL For The Year Ended December 31, 1993 With Comparative Actual Amounts For The Year Ended December 31, 1992 1993 , Over (under) 1992 Budget Actual Budget Actual Revenues: Intergovernmental: State of Minnesota: Maintenance $114,278 $143,466 $29,188 $114,278 , Construction 114,000 281,144 167,144 22,747 Total revenues 228,278 424,610 196,332 137,025 , Expenditures: Maintenance: Personal services 10,800 9,600 (11200) 9,254 , Supplies 1,150 834 (316) 120 Other services and charges Capital outlay 21,398 - 21,385 350 (13) 350 25,115 23,336 Construction: Personal services - 25,899 25,899 21,229 Supplies - 8 8 - , Other services and charges - 669 669 1,029 Capital outlay - 174,916 174,916 109,010 Total expenditures 33,348 233,661 200,313 189,093 Revenues over (under) expenditures 194,930 190,949 (3,981) (52,068) Other financing sources (uses): Operating transfers in - - - 3,303 Operating transfers (out): Maintenance (48,690) (48,690) - (3,303) Total other financing sources (uses) (48,690) (48,690) 0 0 Net increase (decrease) in fund balance $146,240 142,259 ($3,981) (52,068) Fund balance (deficit) - January 1 (62,902) (10,834) Fund balance (deficit) - December 31 $79,357 ($62,902) t 82 , CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - CABLE TELEVISION FUND Statement 13 STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL For The Year Ended December 31, 1993 1 With Comparative Actual Amounts For The Year Faded December 31, 1992 ' 1993 Over (under) 1992 'Budget Actual Budget Actual Revenues: Franchise fees $68,000 $73,154 $5,154 $72,861 Interest 8,500 22,867 14,367 14,354 Other revenues: Miscellaneous 4,100 3,909 (191) 54,683 Total revenues 80,600 99,930 19,330 141,898 Expenditures: Personal services 974 908 (66) 1,138 Supplies 1,945 1,335 (610) 821 Other services and charges 40,590 15,471 (25,119) 28,246 Capital outlay 30,900 1,815 (29,085) 300 Total expenditures 1 74,409 19,529 (54,880) 30,505 ' Revenues over expenditures 6,191 80,401 74,210 111,393 Other financing sources (uses): Operating transfers (out) (46,520) (45,928) 592 (45,989) ' Net increase (decrease) in fund balance ($40,329) 34,473 $74,802 65,404 Fund balance - January 1 290,671 225,267 Fund balance - December 31 $325,144 $290,671 1 83 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - PARATRANSIT FUND Statement 14 STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL For The Year Ended December 31, 1993 With Comparative Actual Amounts For The Year Ended December 31, 1992 Revenues: Intergovernmental Paratransit fees Interest Other revenues: Miscellaneous Total revenues Expenditures: Supplies Other services and charges Total expenditures Revenues over (under) expenditures Other financing sources (uses): Operating transfers in Operating transfers (out) Total other financing sources (uses) Net increase (decrease) in fund balance Fund balance - January 1 Fund balance - December 31 J 84 38,784 $52,519 10,823 $38,784 1993 Over (under) 1992 Budget Actual Budget Actual $129,601 $136,542 $6,941 $115,665 22,020 20,537 (1,483) 18,055 - 5,217 5,217 1,885 - 3,250 3,250 16,060 151,621 165,546 13,925 151,665 610 589 (21) 480 155,644 155,005 (639) 126,214 156,254 155,594 (660) 126,694 (4,633) 9,952 14,585 24,971 10,000 10,000 - 10,000 (7,362) (6,217) 1,145 (7,010) 2,638 3,783 1,145 2,990 ($1,995) 13,735 $15,730 27,961 38,784 $52,519 10,823 $38,784 C'/ 85 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - D.AILE. PROGRAM Statement 15 STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL For The Year Ended December 31, 1993 ' . With Comparative Actual Amounts For The Year Ended December 31, 1992 ' 1993. Over (under) 1992 Budget Actual Budget Actual Revenues: Interest $ - $ - $ - $127 Other revenues: Miscellaneous - 30 30 - Contributions 2,500 1,663 (837) 1,177 Total revenues 2,500 1,693 (807) 1,304 Expenditures: Supplies 3,800 3,771 (29) 1,619 Other services and charges 11055 736 (319) 367 ITotal expenditures 4,855 4,507 (348) 1,986 Revenues over (under) expenditures (2,355) (2,814) (459) (682) Other financing sources: Operating transfers in 2,500 2,500 - 2,000 Total other financing sources 2,500 2,500 0 2,000 1 Net increase (decrease) in fund balance $145 (314) ($459) 1,318 Fund balance - January 1 3,041 1,723 Fund balance - December 31 $2,727 $3,041 C'/ 85 CITY OF COLUMBIA HEIGHTS, MINNESOTA j SPECIAL REVENUE FUND - LIBRARY FUND Statement 16 STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL For The Year Ended December 31, 1993 With Comparative Actual Amounts For The Year Faded December 31, 1992 Revenues: Taxes Charges for services Other revenues: Miscellaneous Total revenues Expenditures: Personal services Supplies Other services and charges Capital outlay Total expenditures Revenues over expenditures Other financing sources (uses): Operating transfers in Operating transfers out Total other financing sources (uses) Net increase in fund balance Fund balance - January 1 Fund balance - December 31 86 l/ 1993 Over (under) 1992 Budget Actual Budget Actual $378,979 $378,979 $ - $ - 16,900 17,017 117 - - 63 63 - 260,332 63,896 50,607 9,720 384,555 11,324 260,323 63,771 50,531 1,866 376,491 19,568 12,590 12,590 - (6,289) 12,590 6,301 $23,914 25,869 $25,869 (9) - (125) - (76) - (7,854) - (8,064) 0 8,244 0 (6,289) - (6,289) 0 $1,955 - $0 CITY OF COLUMBIA HEIGHTS, MINNESOTA REVENUE FUND - HOUSING MORTGAGE Statement 17 'SPECIAL COMPARATIVE STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE For The Year Ended December 31, 1993 With Comparative Actual Amounts For The Year Ended December 31, 1992 1993 1992 Revenues: Interest $13,346 $264 Other revenues: Miscellaneous - 445,525 Total revenues 13,346 445,789 Expenditures - - Revenues over expenditures 13,346 445,789 Fund balance - January 1 445,789 - ! Fund balance - December 31 r r 1 $459,135 $445,789 r '87 r CITY OF COLUMBIA HEIGHTS, MINNESOTA -� SPECIAL REVENUE FUND - RECREATION CONTRIBUTED PROJECTS S Statement 18 COMPARATIVE STATEMENT OF REVENUES, EXPENDITURES AND ' CHANGES IN FUND BALANCE For The Year Ended December 31, 1993 With Comparative Actual Amounts For The Year Ended December 31,1992 . 1993 1992 ' Revenues: Contributions $60,790 $24,889 Expenditures: Supplies 43,172 30,367 Other services and charges 18,382 13,043 , Capital outlay - 3,519 Total expenditures 61,554 46,929 Revenues over (under) expenditures (764) (22,040) Fund balance - January 1 20,051 42,091 , Fund balance - December 31 $19,287 $20,051 1 r 1 1 1 1 i 1 88 " 1 s CITY OF COLUMBIA HEIGHTS, MINNESOTA n SPECIAL REVENUE FUND - CONTRIBUTED PROJECTS Statement 19 COMPARATIVE STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE 1 For The Year Ended December 31, 1993 With Comparative Actual Amounts For The Year Faded December 31, 1992 � L--a9 1993 1992 Revenues: Contributions $38,710 $19,040 Expenditures: Supplies 12,513 961 Other services and charges 9,457 2,410 Capital outlay 7,217 4,801 Total expenditures 29,187 8,172 Revenues over expenditures 9,523 10,868 Other financing sources (uses): Operating transfers (out) (6,500) - Net increase in fund balance 3,023 10,868 Fund balance - January 1 14,781 3,913 Fund balance - December 31 $17,804 $14,781 � L--a9 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - COMMUNITY POLICE Statement 20 COMPARATIVE STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE For The Year Ended December 31, 1993 With Comparative Actual Amounts For The Year Ended December 31, 1992 Revenues: Intergovernmental Fees/program revenues Total revenues Expenditures: Personal services Revenues over (under) expenditures Other financing sources: Operating transfers in Net increase (decrease) in fund balance Fund balance (deficit) - January 1 Fund balance (deficit) - December 31 90 V 1993 1992 $40,000 $13,333 6,666 1,667 46,666 15,000 55,090 19,706 (8,424) (4,706) 6,667 - (1,757) (4,706) (4,706) - ($6,463) ($4,706) sT � CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - PROJECT PRIDE Statement 21 COMPARATIVE STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE For The Year Ended December 31, 1993 With Comparative Actual Amounts For The Year Ended December 31, 1992 1 1993 1992 Revenues: Fees/program revenues $ - $178 Interest - 252 Other revenues: Miscellaneous - 5,300 Contributions 333 - Total revenues 333 5,730 Expenditures: Personal services 532 545 Supplies 290 684 Other services and charges 172 412 Total expenditures 994 1,641 Revenues over (under) expenditures (661) 4,089 Fund balance - January 1 4,089 - Fund balance - December 31 $3,428 $4,089 X91 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - PARKING RAMP Statement 22 COMPARATIVE STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE For The Year Ended December 31, 1993 With Comparative Actual Amounts For The Year Ended December 31, 1992 Revenues: Special assessments Interest Total revenues Expenditures Revenues over expenditures Other financing sources: Operating transfers in Net increase in fund balance Fund balance - January 1 Fund balance - December 31 V 92 $95,366 23,475 118,841 118,841 118,841 193,820 $312,661 1992 ' $95,366 3,088 98,454 98,454 95,366 193,820 ' $193,820 DEBT SERVICE FUNDS The Debt Service Funds are used to account for the collection of tax levies and other revenues and to record the payment and interest on outstanding General Obligation Bonds. Special Assessment Refunding Bonds of 1987 Fund - used to account for revenue and expenditures associated with Special Assessment Bonds of 1987. Tax Increment Bonds Funds - a separate fund is used to account for each separate Tax Increment Bond Issue revenue and expenditures. 93 CH •, CITY OF COLUMBIA HEIGHTS, MINNESOTA CITY OF COLUMBIA HEIGHTS, MINNESOTA DEBT SERVICE FUNDS Statement 23 COMBINING BALANCE SHEET r/ December 31, 1993 S With Comparative Totals For December 31, 1992 IAssets Cash and investments Cash and investments - deposited with fiscal agents Cash and investments held in escrow Receivables: Special assessments: Deferred Taxes: Unremitted Delinquent Interest Due from component unit Total assets Liabilities and Fund Balance Liabilities: Due to component unit Deferred revenue: Property taxes - delinquent Special assessments Accrued interest payable Total liabilities Fund Balance: Designated for debt service Total liabilities and fund balance $391 746,445 - - 746,445 569,713 - - - - 58,287 - - - - 5,202 746,445 0 0 746,445 633,593 1,401,396 - Tax Tax 7,922,087 8,905,141 Tax Increment Increment $8,668,532 $9,538,734 Increment Refunding Refunding Totals Bonds Bonds of 1991 Bonds of 1993 1993 1992 $1,388,856 $ - $2,204 $1,391,060 $2,350,477 - - - - 5,202 - 6,518,487 - 6,518,487 6,520,947 - - - - 58,287 8,398 - - 8,398 11,147 746,445 - - 746,445 569,713 4,142 - - 4,142 21,322 - - - - 1,639 $2,147,841 $6,518,487 $2,204 $8,668,532 $9,538,734 $391 746,445 - - 746,445 569,713 - - - - 58,287 - - - - 5,202 746,445 0 0 746,445 633,593 1,401,396 6,518,487 2,204 7,922,087 8,905,141 $2,147,841 $6,518,487 $2,204 $8,668,532 $9,538,734 95 Expenditures: Debt service: Principal retirement Interest and fiscal charges Miscellaneous Total expenditures Revenues over (under) expenditures Other financing sources (uses): Bond proceeds Payment of refunded bonds Operating transfers in Operating transfers (out) Total other financing sources (uses) Net increase (decrease) in fund balance Fund balance - January 1 Residual equity transfers Fund balance - December 31 •11! 910,000 - 145,000 50,020 - 22,070 CITY OF COLUMBIA HEIGHTS, MINNESOTA 44,885 - 960,086 44,885 167,070 DEBT SERVICE FUNDS 1,184,775 (167,070) COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE For The Year Ended December 31, 1993 With Comparative Totals For The Year Ended December 31, 1992 A/ Special Assessment Tax Tax Refunding Increment Increment Bonds of 1987 Bonds Bonds of 1984 Revenues: Tax increments $ - $1,153,910 $ - Special assessments 35,088 - - Interest - 70,502 Other revenues - 5,248 - Total revenues 35,088 1,229,660 0 Expenditures: Debt service: Principal retirement Interest and fiscal charges Miscellaneous Total expenditures Revenues over (under) expenditures Other financing sources (uses): Bond proceeds Payment of refunded bonds Operating transfers in Operating transfers (out) Total other financing sources (uses) Net increase (decrease) in fund balance Fund balance - January 1 Residual equity transfers Fund balance - December 31 •11! 910,000 - 145,000 50,020 - 22,070 66 44,885 - 960,086 44,885 167,070 (924,998) 1,184,775 (167,070) 167,070 (1,587,610) - 0 _ (1,587,610) 167,070 (924,998) (402,835) 0 975,881 1,408,313 - (50,883) 395,918 - $0 $1,401,396 $0 Statement 24 Tax Tax Capital Tax Tax Increment Increment Appreciation Increment Increment Refunding Taxable Bonds Refunding Refunding Totals Bonds of 1987 Bonds of 1987 of 1990 Bonds of 1991 Bonds of 1993 1993 1992 $ - $ - $ - $ - $ - $1,153,910 $1,108,002 - - - - - 35,088 51,814 = = = 350,783 - 421,285 405,691 - - 5,248 8,742 0 0 0 350,783 0 1,615,531 1,574249 680,000 140,000 - - - 1,875,000 1,180,000 529,565 70,615 360 353,243 17,845 1,043,718 1,020,136 - - - - 24 44,975 72,666 1,209,565 210,615 360 353,243 17,869 2,963,693 2,272,802 (1,209,565) (210,615) (360) (2,460) (17,869) (1,348,162) (698,553) - - - - 730,073 730,073 - - (710,000) - (710,000) - 1,209,565 920,615 360 2,297,610 1,593,410 - - - - (710,000) (2,297,610) (1,593,410) ' 1,209,565 210,615 360 0 20,073 20,073 0 0 0 0 (2,460) 2,204 (1,328,089) (698,553) - - - 6,520,947 - 8,905,141 9,603,694 - - - - - 345,035 - ' $0 $0 $0 $6,518,487 $2,204 $7,922,087 $8,905,141 ' 97. 01 W CITY OF COLUMBIA HEIGHTS, MINNESOTA CAPITAL PROJECT FUNDS . Capital Project Funds are maintained to account for the construction of major capital facilities. Project funding consists of 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. �p Capital Improvement Fund 401- used to account for Capital Project Ca� Funds whereby funding is provided by a number of internal and external sources. Water Surface Management Fund 403 - used to account for revenue and expenditures associated with storm sewers and other surface water management. Senior Housing Fund 404 - used to build Parkview Villa South addition for senior housing. tDowntown Parking Maintenance Fund 405 - used for maintenance of the West Side Parking. Capital Improvement Fund 408 - used for projects involving State Aid streets. Sheffield Redevelopment Fund 410 - used to fund redevelopment of the area of the City identified as Sheffield Neighborhood. Ca itp al Improvement General Government Buildings Fund 411 - used to account for improvements to municipal buildings - library, municipal garage, and City Hall. Capital Improvement Parks Fund 412 - used to account for capital improvements in City parks. Huset Park Hazardous Cleanup Fund 413 - used to account for expenditures associated with reporting of possible hazardous waste dumping. at j Capital Improvement Projects Fund 415 - used to account for projects that will be fully assessed to affected properties. Infrastructure Replacement Fund 430 - used to fund replacement of City infrastructure. Capital Equipment Replacement Fund 431 - used to fund replacement of fixed assets as needed. .. Accrued salaries and withholdings payable Contracts payable - retained percentage Due to other funds Deferred revenue Total liabilities Fund balance: Unreserved: Designated for subsequent years' expenditures Undesignated Total fund balance (deficit) Total liabilities and fund balance 11 61 - 1,230 - 137,812 - 139,042 (139,042) 20,130 67,604 19,876 (139,042) 20,130 CITY OF COLUMBIA HEIGHTS, MINNESOTA CAPITAL PROJECT FUNDS 19,876 1 J $0 $20,130 $67,665 COMBINING BALANCE SHEET ' December 31, 1992 With Comparative Totals For December 31, 1991 Water Downtown Capital Surface Parking Capital Improvement Management Maintenance Improvement Fund 401 Fund 403 Fund 405 Fund 408 Assets Cash and investments $ - $20,031 $67,350 $19,876 Receivables: Accounts - - - - Special assessments: Unremitted - - - - Delinquent - - - - Deferred - - - - Interest - 99 315 - Due from other governmental units - - - - Due from component unit - - - - Real estate held for resale - - - - Total assets $0 $20,130 $67,665 $19,876 Liabilities and Fund Balance Liabilities: Accounts payable $ - ' Accrued salaries and withholdings payable Contracts payable - retained percentage Due to other funds Deferred revenue Total liabilities Fund balance: Unreserved: Designated for subsequent years' expenditures Undesignated Total fund balance (deficit) Total liabilities and fund balance 11 61 - 1,230 - 137,812 - 139,042 (139,042) 20,130 67,604 19,876 (139,042) 20,130 67,604 19,876 $0 $20,130 $67,665 $19,876 1 I 1 1 1 1 1 Statement 25 Capital - - 2,786 2,288 - - - 59,185 - - 59,185 73,962 - - - 364,055 Improvement 357,942 - 1,354 1,714 2,262 1,438 13,411 20,593 General Capital Capital Capital Sheffield Government Improvement Improvement Infrastructure Equipment ' Redevelopment Buildings Parks Projects Replacement Replacement Totals Fund 410 Fund 411 Fund 412 Fund 415 Fund 430 Fund 431 1993 1992 1 $101,599 $305,690 $385,888 $157,698 $324,666 $3,017,592 $4,400,390 $4,499,528 5,041 - - - 2,786 - - 2,786 2,288 - - - 59,185 - - 59,185 73,962 - - - 364,055 - - 364,055 357,942 - 1,354 1,714 2,262 1,438 13,411 20,593 31,576 = = = 4,622 - 4,622 - 31,777 220,000 - - - - - 220,000 - $321,599 $307,044 $387,602 $590,608 $326,104 $3,031,003 $5,071,631 $5,002,114 $ - $ - $2,168 $ - $ - $ - $2,168 $68,616 - - 44 - - - 105 1,363 ' - = - = = - 350 1,580 494 707,000 844,812 - - - - 423,241 - - 423,241 431,904 707,000 0 2,212 423,241 0 350 1,271,906 502,377 I- - - - - 4,550 4,550 - (385,401) 307,044 385,390 167,367 326,104 3,026,103 3,795,175 4,499,737 (385,401) 307,044 385,390 167,367 326,104 3,030,653 3,799,725 4,499,737 ' $321,599 $307,044 $387,602 $590,608 $326,104 $3,031,003 $5,071,631 $5,002,114 101 CITY OF COLUMBIA HEIGHTS, MINNESOTA S 1 CAPITAL PROJECT FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE For The Year Ended December 31, 1993 With Comparative Totals For The Year Ended December 31, 1992 ,/Revenues: Special assessments Interest Other revenues: Miscellaneous Total revenues (/Expenditures: Other project expenditures Revenue over (under) expenditures Other financing sources (uses): Operating transfers in Operating transfers (out) Total other financing sources (uses) Net increase (decrease) in fund balance Fund balance - January 1 Residual equity transfers Fund balance (deficit) - December 31 102 2,145 - - - - 2,145 1,682 0 5,362 0 173,422 5,545 7,169 7,700 - (171,277) (3,863) (7,169) 2,338 0 1 17,059 - - - - 17,059 0 0 0 0 (154,218) (3,863) (7,169) (2,338) 0 15,176 23,993 403,087 69,942 19,876 395,918 - - ($139,042) $20,130 $0 $67,604 $19,876 ,X tX X Water Downtown Capital Surface Senior Land Capital Improvement Management Housing Acquisition Improvement Fund 401 Fund 403 Fund 404 Fund 405 Fund 408 - 1,682 - 5,362 - 2,145 - - - - 2,145 1,682 0 5,362 0 173,422 5,545 7,169 7,700 - (171,277) (3,863) (7,169) 2,338 0 1 17,059 - - - - 17,059 0 0 0 0 (154,218) (3,863) (7,169) (2,338) 0 15,176 23,993 403,087 69,942 19,876 395,918 - - ($139,042) $20,130 $0 $67,604 $19,876 Statement 26 ' - - - - 5,881 - 15 8,041 399,343 0 23,054 29,175 0 266,413 24,485 228,317 580,633 808,095 385,401 - 3,411 - 127,975 - 243,005 ' Capital Improvement Capital Huset Park Capital i Capital Sheffield Government Improvement Hazardous Improvement Infrastructure Improvement Redevelopment Buildings Parks Cleanup Projects Replacement Replacement Totals ' Fund 410 Fund 411 Fund 412 Fund 413 Fund 415 Fund 430 Fund 431 1993 1992 $ $ - $ - $ $222,027 $ - $ - $222,027 $167,834 - 23,054 29,175 = 38,505 24,485 228,302 350,565 240,918 ' - - - - 5,881 - 15 8,041 399,343 0 23,054 29,175 0 266,413 24,485 228,317 580,633 808,095 385,401 - 3,411 - 127,975 - 243,005 953,628 472,496 (385,401) 23,054 25,764 0 138,438 24,485 (14,688) (372,995) 335,599 - - - - - - 157,087 174,146 443,863 - - - - (69,530) - - (69,530) 57,132 0 0 0 0 (69,530) 0 157,087 104,616 386,731 (385,401) 23,054 25,764 0 68,908 24,485 142,399 (268,379) 722,330 - 283,990 359,626 35,715 98,459 301,619 2,888,254 4,499,737 3,777,407 - - - 35,715 - - - (431,633) - ($385,401) $307,044 $385,390 $0 $167,367 $326,104 $3,030,653 $3,799,725 $4,499,737 ffix] CH 104 CITY OF COLUMBIA HEIGHTS, MINNESOTA 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. The Enterprise Funds are a member of the Proprietary Fund Type ' category, and as such are accounted for on the accrual basis of accounting. Revenue in the Enterprise Funds is recognized when it is earned and expenses are recognized when they are incurred. The Enterprise Funds are used to account for operations that are either financed and operated in a manner similar to private business enterprises or where the governing body has decided that periodic determination of revenue earned, expenses incurred, and /or net income is appropriate for capital maintenance, public policy, management control, accountability, or other purposes. Water Utility Fund - used to account for revenues and expenses associated with services to area residents. Sewer Utility Fund - used to account for revenues and expenses associated with sewer disposal within the City. Refuse Utility Fund - used to account for revenues and expenses associated with organized collection or refuse and recycling in the City. Liquor Fund - used to account for revenues and expenses associated with the operation of two off -sale liquor stores. 105 CITY OF COLUMBIA HEIGHTS, MINNESOTA ENTERPRISE FUNDS COMBINING BALANCE SHEET December 31, 1993 With Comparative Totals For December 31, 1992 Statement 27 ' Totals Assets Water Sewer Refuse Liquor 1993 1992 Current assets: Cash and cash equivalents Temporary investments Receivables: Accounts Interest Due from other governmental units, current portion Due from other funds Prepaid expense Inventory, at cost Total current assets $773,494 $1,418,396 $393,569 239,742 238,991 332,610 3,918 9,142 1,744 $684,442 $3,269,901 $883,842 - - 2,941,435 128 811,471 779,343 3,116 17,920 32,147 - 150,102 20,272 1,868 172,242 14,481 - 707,000 - - 707,000 - 20 - 40 125 185 55,910 2,478 - - 577,017 579,495 406,765 1,019,652 2,523,631 748,235 1,266,696 5,558,214 5,113,923 Long -term assets: Due from other governmental units, ' net of current portion - 119,908 - - 119,908 154,516 Total long -term assets 0 119,908 0 0 119,908 154,516 Fixed assets: ' Land 45,223 36,586 - 13,051 94,860 94,860 Buildings 233,836 46,290 - 241,066 521,192 468,448 Improvements other than buildings 2,839,427 3,060,243 2,890 104,538 6,007,098 5,995,581 ' Machinery and equipment 269,867 478,479 5,447 348,968 1,102,761 907,278 Construction in process 21,733 213,729 - - 235,462 74,297 Total 3,410,086 3,835,327 8,337 707,623 7,961,373 7,540,464 Less: Accumulated depreciation 1,645,589 1,981,075 3,297 317,136 3,947,097 3,694,667 Net fixed assets 1,764,497 1,854,252 5,040 390,487 4,014,276 3,845,797 Total assets $2,784,149 $4,497,791 $753,275 $1,657,183 $9,692,398 $9,114,236 ' Liabilities and Fund Equity Current liabilities: ' Accounts payable $63,674 $408 $7 $204,073 $268,162 $203,188 Accrued salaries and withholdings payable 12,867 11,085 59 37,768 61,779 65,596 ' Contracts payable - retained percentage - 81,141 - - 81,141 595 Due to other governmental units 6,711 - - 59,405 66,116 54,591 Total current liabilities 83,252 92,634 66 301,246 477,198 323,970 Fund equity: ' Contributed capital: Property owners/customers 377,513 668,137 - - 1,045,650 1,110,879 Federal funds 453,000 - - - 453,000 453,000 , Total contributed capital 830,513 668,137 0 0 1,498,650 1,563,879 Retained earnings: Reserved for capital ' replacement/construction 491,767 2,164,883 - - 2,656,650 2,577,320 Unreserved 1,378,617 1,572,137 753,209 1,355,937 5,059,900 4,649,067 Total retained earnings 1,870,384 3,737,020 753,209 1,355,937 7,716,550 7,226,387 ' Total fund equity 2,700,897 4,405,157 753,209 1,355,937 9,215,200 8,790,266 106 Total liabilities and fund equity $2,784,149 $4,497,791 $753,275 $1,657,183 $9,692,398 $9,114236 1 CITY OF COLUMBIA HEIGHTS, MINNESOTA ENTERPRISE FUNDS Statement 28 COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS For The Year Ended December 31, 1993 With Comparative Totals For The Year Ended December 31, 1992 Operating expenses: 66,687 161,674 29,681 53,052 Totals 246,848 Water Sewer Refuse Liquor 1993 1992 Operating revenues: Distribution 342,336 211,539 - - 553,875 Charges for services: Administration 8,638 8,266 8,258 - 25,162 Customer service $19,481 $ - $ - $ - $19,481 $6,091 Penalties 36,334 - - - 36,334 46,773 Sewer service charges - 1,0219710 - - 1,021,710 1,040,730 Refuse service charges - - 1,515,776 - 1,515,776 1,449,586 Charges for sales: Operating expense - - - 684,368 684,368 Water 1,0679666 - - - 1,067,666 1,169,888 Meter 3,052 - - - 3,052 3,662 Liquor - - - 1,496,510 19496,510 1,376,591 Beer - - - 2,537,881 2,537,881 2,394,101 Wine - - - 472,576 472,576 420,246 Other - - - 697,437 697,437 631,485 Intergovernmental - - 40,992 - 40,992 29,856 Total operating revenues 1,1269533 1,021,710 1,5569768 5,204,404 89909,415 8,5699009 Operating expenses: 66,687 161,674 29,681 53,052 311,094 246,848 Cost of sales and services 640,691 698,277 - - 1,338,968 1,322,628 Distribution 342,336 211,539 - - 553,875 468,671 Administration 8,638 8,266 8,258 - 25,162 22,473 Collection and disposal - - 1,053,090 - 1,053,090 1,043,886 Recycling - - 252,598 - 252,598 267,335 Hazardous waste - - 1,577 - 1,577 - Cost of goods sold - - - 4,273,140 4,273,140 3,924,647 Operating expense - - - 684,368 684,368 516,822 Depreciation 87,522 113,245 1,022 57,878 259,667 228,623 Total operating expenses 1,079,187 1,031,327 1,316,545 5,015,386 8,442,445 7,795,085 Net income (loss) from operations 47,346 (9,617) 240,223 189,018 466,970 773,924 Nonoperating revenues (expenses): Interest income 66,687 161,674 29,681 53,052 311,094 246,848 Miscellaneous revenues 62 6,700 6 8,407 15,175 44,633 Miscellaneous expenses - 13,637 - (1,564) 15,201 (5,067) Total nonoperating revenues (expenses) 66,749 154,737 29,687 59,895 311,068 286,414 Net income before operating transfers 114,095 145,120 269,910 248,913 778,038 1,060,338 Operating transfers: Operating transfers in 23,437 62,994 - 4,231 90,662 754,394 Operating transfers (out) 184,699 120,255 (83,221) (193,853) (582,028) 1,1( 41,565) Total operating transfers (161,262) (57,261) (83,221) (189,622) (491,366) (387,171) Net income (47,167) 87,859 186,689 59,291 286,672 673,167 Credit for depreciation on contributed assets 26,294 38,935 - - 65,229 65,229 Retained earnings - January 1 as previously reported 1,891,257 3,471,964 566,520 1,296,646 7,226,387 6,487,991 Prior period adjustment - 138,262 - - 138,262 - Retained earnings - January 1 as restated 1,891,257 3,610,226 566,520 1,296,646 7,364,649 6,487,991 Retained earnings - December 31 $1,870,384 $3,737,020 $753,209 $1,355,937 $7,716,550 $7,226,387 107 CITY OF COLUMBIA HEIGHTS, MINNESOTA ENTERPRISE FUNDS Statement 29 COMBINING STATEMENT OF CASH FLOWS Page 1 of 2 For The Year Ended December 31, 1993 With Comparative Totals For the Year Ended December 31, 1992 Cash flows from operating activities: Cash received from customers Cash paid to suppliers for goods and services Cash payments to employees for services Miscellaneous revenues Miscellaneous expenses Net cash flows from operating activities Cash flows from noncapital financing activities: Operating transfers (out) to other funds Cash flows from capital and related financing activities: Acquisition of fixed assets Disposition of fixed assets Net cash flows from capital and related financing activities Cash flows from investing activities: Purchase of investments Proceeds from sale and maturity of investments Interest received on investments Net cash flows from investing activities Net increase in cash and cash equivalents Cash and cash equivalents - January 1 Cash and cash equivalents - December 31 Totals Water Sewer Refuse Liquor . 1993 1992 708,166 1,348,937 230,235 792,686 3,080,024 $1,136,063 $198,802 $1,519,568 $5,206,928 $890619361 $8,470,231 (775,460) (6759248) (1,314,292) (4,656,975) (7,421,975) (6,892,212) (209,749) (113,042) (1,272) (400,517) (724,580) (592,752) 62 6,700 6 89407 15,175 449633 - (13,637) - (1,564) (15,201) (5,067) 1509916 (596,425) 2049010 156,279 (85,220) 1,024,833 (161,262) (57,261) (83,221) (189,622) (491,366) (387,171) (24,682) (200,490) - (203,301) (428,473) (466,243) 1,505 24,682 200,490 0 203,301 (428,473) 464,738 - - - - - (731,977) 708,166 1,348,937 230,235 792,686 3,080,024 835,969 66,687 161,674 29,681 53,052 311,094 239,771 , 774,853 1,510,611 259,916 845,738 3,391,118 343,763 739,825 656,435 380,705 609,094 2,386,059 516,687 33,669 761,961 12,864 75,348 883,842 367,155 $773,494 $1,418,396 $393,569 $684,442 $3,269,901 $883,842 ' 108 ' CITY OF COLUMBIA HEIGHTS, MINNESOTA ENTERPRISE FUNDS COMBINING STATEMENT OF CASH FLOWS For The Year Ended December 31, 1993 With Comparative Totals For the Year Ended December 31, 1992 Reconciliation of operating income (loss) to Net cash flows from operating activities Operating income (loss) Adjustments to reconcile operating income to net cash flows from operating activities: Miscellaneous revenues Miscellaneous expenses Depreciation expense Changes in assets and liabilities: (Increase) decrease in accounts receivable (Increase) decrease in due from other governmental units (Increase) decrease in due from other funds (Increase) decrease in prepaid expenses (Increase) decrease in inventory, at cost Increase (decrease) in accounts payable Increase (decrease) in accrued salaries and withholdings payable Increase (decrease) in due to other governmental units Total adjustments Net cash flows from operating activities Statement 29 Page 2 of 2 Totals Water Sewer Refuse Liquor 1993 1992 $47,346 $9,61 $240,223 $189,018 $466,970 $773,924 62 6,700 6 8,407 15,175 44,633 - (13,637) - (1,564) (15,201) (5,067) 87,522 113,245 1,022 57,878 259,667 228,623 9,530 (414) (29,844) 2,827 (17,901) (97,986) - (115,494) (7,356) (303) (123,153) 53,315 - (707,000) - - (707,000) - (20) 55,910 (40) (125) 55,725 911 18 - - (172,748) (172,730) 81,215 11,314 77,990 (46) 56,262 145,520 (67,970) (4,485) (4,108) 45 4,731 (3,817) 8,220 (371) - - 11,896 11,525 5,015 103,570 586,808 (36,213) 32,739 552,190 250,909 $150,916 ($596,425) $204,010 $156,279 ($85,220) $1,024,833 1' CITY OF COLUMBIA HEIGHTS, MINNESOTA WATER UTILITY FUND BALANCE SHEET December 31, 1993 With Comparative Totals For December 31, 1992 Assets Current assets: Cash and cash equivalents Temporary investments Receivables: Accounts Interest Prepaid expense Inventory, at cost Total current assets Fixed assets: Land Buildings Improvements other than buildings Machinery and equipment Construction in process Total fixed assets Less accumulated depreciation Net fixed assets Total assets Liabilities and Fund Equity Liabilities: Capital Equipment Operating Replacement Account Account Statement 30 Capital ' Construction Totals Account 1993 1992 $305,988 $141,685 $325,821 $773,494 $33,669 - - - - 708,167 239,742 - - 239,742 247,587 1,390 596 1,932 3,918 5,603 20 - - 20 - 2,478 - - 2,478 2,496 549,618 142,281 327,753 1,019,652 997,522 142,281 349,486 45,223 - - 45,223 45,223 233,836 - - 233,836 233,236 2,839,427 - - 2,839,427 2,835,891 269,867 - - 269,867 263,943 - - 21,733 21,733 14,587 3,388,353 0 21,733 3,410,086 3,392,880 1,645,589 - - 1,645,589 1,565,544 1,742,764 0 21,733 1,764,497 1,827,336 $2,292,382 $142,281 $349,486 $2,784,149 $2,824,858 Accounts payable $63,674 $ - $ - $63,674 $52,360 Accrued salaries and withholdings payable 12,867 - - 12,867 17,352 Due to other governmental units 6,711 - - 6,711 7,082 Total liabilities 83,252 0 0 83,252 76,794 Fund Equity: Contributed capital: Property owners Federal funds Total contributed capital Retained earnings: Reserved for capital replacement/construction Unreserved Total retained earnings Total fund equity Total liabilities and fund equity $2,292,382 $142,281 $349,486 $2,784,149 $2,824,858 110 1 377,513 - - 377,513 403,807 453,000 - - 453,000 453,000 , 830,513 0 0 830,513 856,807 - 142,281 349,486 491,767 546,177 ' 1,378,617 - - 1,378,617 1,345,080 1,378,617 2,209,130 142,281 142,281 349,486 349,486 1,870,384 2,700,897 1,891257 2,748,064 ' Total liabilities and fund equity $2,292,382 $142,281 $349,486 $2,784,149 $2,824,858 110 1 CITY OF COLUMBIA HEIGHTS, MINNESOTA WATER UTH= FUND Statement 31 STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS For The Year Ended December 31, 1993 With Comparative Totals For The Year Ended December 31, 1992 Operating revenues: Charges for services: Customer services Penalties Charges for sales: Water sales Meter sales Total operating revenues Operating expenses: Cost of sales and services Distribution Administration Depreciation Total operating expenses Net income from operations Nonoperating revenues (expenses): Capital Equipment Operating Replacement Account Account Capital Construction Replacement Totals Account 1993 1992 $19,481 $ - $ - $19,481 $6,091 36,334 - - 36,334 46,773 1,067,666 - - 1,067,666 1,169,888 3,052 - - 3,052 3,662 1,126,533 0 0 1,126,533 1,226,414 (63,825) 640,691 - - 640,691 618,504 342,336 - - 342,336 273,290 8,638 - - 8,638 7,975 87,522 - - 87,522 82,010 1,079,187 0 0 1,079,187 981,779 47,346 0 0 47,346 244,635 Interest income 23,660 10,141 32,886 66,687 43,889 Miscellaneous revenues 62 - - 62 24 Miscellaneous expenses - - - - (40) Total nonoperating revenues (expenses) 23,722 10,141 32,886 66,749 43,873 Net income before operating transfers Operating transfers: Operating transfers in Operating transfers (out) Total operating transfers Net income (loss) Credit for depreciation on contributed assets Retained earnings - January 1 Retained earnings - December 31 71,068 10,141 32,886 114,095 288,508 8,437 15,000 - 23,437 206,075 (72,262) (8,437) (104,000) (184,699) (257,910) (63,825) 6,563 (104,000) (161,262) (51,835) 7,243 16,704 (71,114) 26,294 - - (47,167) 236,673 26,294 26,294 1,345,080 125,577 420,600 1,891,257 1,628,290 $1,378,617 $142,281 $349,486 $1,870,384 $1,891,257 111 CITY OF COLUMBIA HEIGHTS, MINNESOTA WATER UTILITY FUND STATEMENT OF CASH FLOWS For The Year Ended December 31, 1993 With Comparative Amounts For the Year Ended December 31, 1992 Cash flows from operating activities: Cash received from customers Cash paid to suppliers for goods and services Cash payments to employees for services Miscellaneous revenues Miscellaneous expenses Net cash flows from operating activities Cash flows from noncapital financing activities: Operating transfers in Operating transfers (out) Net cash flows from noncapital financing activities Cash flows from capital and related financing activities: Acquisition of fixed assets Cash flows from investing activities: Purchase of investments Proceeds from sale and maturity of investments Interest received on investments Net cash flows from investing activities Net increase in cash and cash equivalents Cash and cash equivalents - January 1 Cash and cash equivalents - December 31 Reconciliation of operating income to Net cash flows from operating activities Operating income Adjustments to reconcile operating income to net cash flows from operating activities: Miscellaneous revenues Miscellaneous expenses Depreciation expense Changes in assets and liabilities: (Increase) decrease in accounts receivable (Increase) decrease in prepaid expense (Increase) decrease in inventories Increase (decrease) in accounts payable Increase (decrease) in accrued salaries and withholdings payable Increase (decrease) in due to other governmental units Total adjustments Net cash flows from operating activities Statement 32 1993 1992 $1,136,063 $1,145,412 , (775,460) (728,849) (209,749) (169,777) 62 ' 24 - (40) 150,916 246,770 ' 23,437 206,075 (184,699) (257,910) , (161,262) (51,835) (24,682) (215,503) ' - (14,815) ' 708,166 - 66,687 43,660 774,853 28,845 ' 739,825 8,277 33,669 25,392 ' $773,494 $33,669 $47,346 $244,635 ' 62 87,522 9,530 (20) 18 11,314 (4,485) (371) 103,570 $150,916 24 (40) ' 82,010 (81,002) 39 (1,486) 2,344 246 2,135 $246,770 112 1 CITY OF COLUMBIA HEIGHTS, MINNESOTA SEWER UTILITY FUND Statement 33 ' BALANCE SHEET December 31, 1993 With Comparative Totals For December 31, 1992 Capital Equipment Capital ' Operating Replacement Construction Totals Account Account Account 1993 1992 Assets ' Current assets: Cash and cash equivalents $101,721 $172,192 $1,144,483 $1,418,396 $761,961 Temporary investments - - - - 1,210,675 ' Receivables: Accounts 238,991 - - 238,991 229,285 Interest 522 712 7,908 9,142 18,434 ' Due from other governmental units, current portion 150,102 - - 150,102 16,274 Due from other funds - - 707,000 707,000 - Prepaid expense - - - - 55,910 Total current assets 491,336 172,904 1,859,391 2,523,631 2,292,539 Long -term assets: ' Due from other governmental units, net of current portion 119,908 - - 119,908 138,242 Fixed assets: ' Land 36,586 - - 36,586 36,586 Buildings 46,290 46,290 45,690 Improvements other than buildings 3,060,243 - - 3,060,243 3,056,707 ' Machinery and equipment 478,479 - - 478,479 437,468 Construction in process 213,729 213,729 59,710 Total fixed assets 3,621,598 0 213,729 3,835,327 3,636,161 Less accumulated depreciation 1,981,075 - - 1,981,075 1,869,154 ' Net fixed assets 1,640,523 0 213,729 1,854,252 1,767,007 Total assets $2,251,767 $172,904 $2,073,120 $4,497,791 $4,197,788 ' Liabilities and Fund Equity Current liabilities: Accounts payable $408 $ - $= $408 $3,559 Accrued salaries and withholdings payable 11,085 11,085 15,193 Contracts payable - - 81,141 81,141 - Total liabilities 11,493 0 81,141 92,634 18,752 Fund equity: Contributed capital: ' Customers 668,137 - - 668,137 707,072 Retained earnings: Reserved for capital replacement /construction - 172,904 1,991,979 2,164,883 2,031,143 Unreserved 1,572,137 - - 1,572,137 1,440,821 ' Total retained earnings 1,572,137 172,904 1,991,979 3,737,020 3,471,964 Total fund equity 2,240,274 172,904 1,991,979 4,405,157 4,179,036 ' Total liabilities and fund equity $2,251,767 $172,904 $2,073,120 $4,497,791 $4,197,788 ' 113 CITY OF COLUMBIA HEIGHTS, MINNESOTA SEWER UTILITY FUND Statement 34 STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS For The Year Ended December 31, 1993 With Comparative Totals For The Year Ended December 31, 1992 Capital Equipment Capital Operating Replacement Construction Totals Account Account Account 1993 1992 Operating revenues: Charges for sales and services: Sewer service charges Operating expenses: Cost of sales and services Distribution Administration Depreciation Total operating expenses Net income (loss) from operations Nonoperating revenues (expenses) Interest income Miscellaneous revenues Miscellaneous expenses Total nonoperating revenues (expenses) Net income (loss) before operating transfer Operating transfers: Operating transfers in Operating transfers (out) Total operating transfers Net income (loss) Credit for depreciation on contributed assets Retained earnings - January 1 as previously reported Prior period adjustment Retained earnings - January 1 Retained earnings - December 31 $1,021,710 $ - $ - $1,021,710 $1,040,730 r 698,277 - - 698,277 704,124 211,539 - - 211,539 195,381 8,266 - - 8,266 7,958 ' 113,245 - - 113,245 112,489 1,031,327 0 0 1,031,327 1,019,952 ' 9,617 0 0 (9,617) 20,778 14,940 12,122 134,612 161,674 139,434 6,700 (13,637) - - - - 6,700 (13,637) 38,682 3,030 , 8,003 12,122 134,612 154,737 175,086 1,614 12,122 134,612 145,120 195,864 ' 37,994 25,000 - 62,994 548,319 ' (82,261) 37,994 - (120,255) 600,154 (44,267) 12,994 0 (57,261) 51,835 ' (45,881) (872) 134,612 87,859 144,029 38,935 - - 38,935 38,935 1,440,821 173,776 1,857,367 3,471,964 3,289,000 138,262 - - 138,262 - 1,579,083 173,776 1,857,367 3,610,226 3,289,000 ' $1,572,137 $172,904 $1,991,979 $3,737,020 $3,471,964 ' 114 1 CITY OF COLUMBIA HEIGHTS, MRgNESOTA SEWER UTILITY FUND Statement 35 STATEMENT OF CASH FLOWS For The Year Ended December 31, 1993 With Comparative Amounts For the Year Ended December 31, 1992 115 1992 '1993 Cash flows from operating activities: Cash received from customers $198,802 $987,437 Cash paid to suppliers for goods and services (675,248) (782,145) Cash payments to employees for services (113,042) (115,729) Miscellaneous revenues 6,700 38,682 Miscellaneous expenses (13,637) (3,030) 1 Net cash flows from operating activities (596,425) 125,215 Cash flows from noncapital financing activities: Operating transfers in 62,994 548,319 ' Operating transfers (out) (120,255) (600,154) Net cash flows from noncapital financing activities (57,261) (51,835) ' Cash flows from capital and related financing activities: Acquisition of fixed assets (200,490) (239,908) Cash flows from investing activities: Proceeds from sale and maturity of investments 1,348,937 835,969 Interest received on investments 161,674 136,194 Net cash flows from investing activities 1,510,611 972,163 Net increase in cash and cash equivalents 656,435 805,635 ' Cash and cash equivalents - January 1 761,961 (43,674) Cash and cash equivalents - December 31 $1,418,396 $761,961 ' Reconciliation of operating income (loss) to Net cash flows from operating activities ' Operating income (loss) ($9,617) $20,778 Adjustments to reconcile operating income (loss) to net cash flows from operating activities: Miscellaneous revenues 6,700 38,682 Miscellaneous expenses (13,637) (3,030) ' Depreciation expense 113,245 112,489 Changes in assets and liabilities: (Increase) decrease in accounts receivable (414) (53,293) ' (Increase) decrease in due from other governmental units (115,494) 17,566 (Increase) decrease in due from other funds (707,000) - (Increase) decrease in prepaid expense 55,910 911 Increase (decrease) in accounts payable 77,990 (9,876) ' Increase (decrease) in accrued salaries and withholdings payable (4,108) 988 Total adjustments (586,808) 104,437 tNet cash flows from operating activities ($596,425) $125,215 115 CITY OF COLUMBIA HEIGHTS, MINNESOTA REFUSE UTII.PTY FUND Statement 36 BALANCE SHEET December 31, 1993 ' With Comparative Amounts For December 31, 1992 ' 1993 1992 Assets Current assets: , Cash and cash equivalents $393,569 $12,864 Temporary investments - 230,235 Receivables: , Accounts 332,610 302,368 Interest 1,744 2,142 Due from other governmental units 20,272 12,916 ' Prepaid expenses 40 - Total current assets 748,235 560,525 Fixed assets: Improvements other than buildings 2,890 2,890 Machinery and equipment 5,447 5,447 ' Total fixed assets 8,337 8,337 Less accumulated depreciation 3,297 2,275 Net fixed assets 5,040 6,062 ' Total assets $753,275 $566,587 Liabilities Fund Equity ' and Current liabilities: Accounts payable $7 $53 ' Accrued salaries and withholdings payable 59 14 Total liabilities 66 67 ' Fund equity: Retained earnings: Unreserved 753,209 566,520 Total liabilities and fund equity $753,275 $566,587 116 , ICITY OF COLUMBIA HEIGHTS MINNESOTA UTILITY FUND Statement 37 'REFUSE STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS For The Year Ended December 31, 1992 With Comparative Amounts For The Year Ended December 31, 1991 1993 1992 Operating revenues: Refuse service charges $1,515,776 $1,449,586 Intergovernmental 40,992 29,856 Total operating revenues 1,556,768 1,479,442 ' Operating expenses: Administration 8,258 6,540 ' Collections and disposals 1,053,090 1,043,886 Recycling 252,598 267,335 Hazardous waste 1,577 - ' Depreciation 1,022 816 Total operating expenses 1,316,545 1,318,577 Net income from operations 240,223 160,865 Nonoperating revenues: Interest income 29,681 16,780 ' Miscellaneous revenues 6 18 Total nonoperating revenues 29,687 16,798 Net income before operating transfers 269,910 177,663 Operating transfers: ' Operating transfers (out) (83,221) (81,371) Total operating transfers (83,221) (81,371) Net income 186,689 96,292 Retained earnings - January 1 566,520 470,228 Retained earnings - December 31 $753,209 $566,520 117 CITY OF COLUMBIA HEIGHTS, MINNESOTA REFUSE UTILITY FUND Statement 38 STATEMENT OF CASH FLOWS For The Year Ended December 31, 1993 With Comparative Amounts For the Year Ended December 31, 1992 Cash flows from operating activities: Cash received from customers Cash paid to suppliers for goods and services Cash payments to employees for services Miscellaneous revenues Net cash flows from operating activities Cash flows from noncapital financing activities: Operating transfers (out) Cash flows from capital and related financing activities: Acquisition of fixed assets Cash flows from investing activities: Purchase of investments Proceeds from sale and maturity of investments Interest received on investments Net cash flows from investing activities Net increase (decrease) in cash and cash equivalents Cash and cash equivalents - January 1 Cash and cash equivalents - December 31 Reconciliation of operating income to Net cash flows from operating activities Operating income Adjustments to reconcile operating income to net cash flows from operating activities: Miscellaneous revenues Depreciation expense Changes in assets and liabilities: (Increase) decrease in accounts receivable (Increase) decrease in due from other governmental units (Increase) decrease in prepaid expenses Increase (decrease) in accounts payable Increase (decrease) in accrued salaries and withholdings payable Total adjustments Net cash flows from operating activities 118 [VIC, $1,519,568 (1,314,292) (1,272) 6 204,010 1992 $1,515,854 (1,307,957) (1,867) 18 206,048 (83,221) (81,371) 230,235 29,681 259,916 380,705 12,864 $393,569 J J 1 $240,223 $160,865 6 1,022 (29,844) (7,356) (40) (46) 45 (36,213) $204,010 18 816 36,412 36,541 (28,473) (131) 45,183 $206,048 , (4,832) (229,123) , 15,470 (213,653) , (93,808) , 106,672 $12,864 , $240,223 $160,865 6 1,022 (29,844) (7,356) (40) (46) 45 (36,213) $204,010 18 816 36,412 36,541 (28,473) (131) 45,183 $206,048 CITY OF COLUMBIA HEIGHTS, MINNESOTA 'LIQUOR FUND BALANCE SHEET December 31, 1993 With Comparative Amounts For December 31, 1992 Assets Current assets: Cash and cash equivalents Temporary investments Receivables: Accounts ' Interest Due from other governmental units Prepaid expense Inventory, at cost Total current assets Fixed assets: Land Buildings ' Improvements other than buildings Machinery and equipment Total fixed assets ' Less accumulated depreciation Net fixed assets Total assets 1 Liabilities and Fund Equity Current liabilities: Accounts payable Accrued salaries and withholdings payable Contracts payable - retained percentage Due to other governmental units Total liabilities Fund equity: Retained earnings: ' Unreserved Total liabilities and fund equity 1993 $684,442 128 3,116 1,868 125 577,017 1,266,696 13,051 241,066 104,538 348,968 707,623 317,136 390,487 $1,657,183 $204,073 37,768 59,405 301,246 1,355,937 $1,657,183 Statement 39 r 1992 $75,348 792,358 103 5,968 1,565 404,269 1,279,611 13,051 189,522 100,093 200,420 503,086 257,694 245,392 $1,525,003 $147,216 33,037 595 47,509 228,357 1,296,646 $1,525,003 119 120 1 ' CITY OF COLUMBIA HEIGHTS MINNESOTA Heights LIQUOR FUND STATEMENT OF REVENUES, EXPENSES AND Statement 40 CHANGES IN RETAINED EARNINGS Top Valu For The Year Ended December 31, 1993 Liquor With Comparative Totals For The Year Ended December 31, 1992 1992 Operating revenues: 120 1 Top Heights Totals ' Top Valu Valu II Liquor 1993 1992 Operating revenues: Charges for sales: Liquor $1,003,241 $237,837 $255,432 $1,496,510 $1,376,591 Beer 1,515,764 415,344 606,773 2,537,881 2,394,101 Wine 326,445 90,559 55,572 472,576 420,246 , Other 523,141 70,806 103,490 697,437 631,485 Total operating revenues 3,368,591 814,546 1,021,267 5,204,404 4,822,423 , Operating expenses: Cost of goods sold 2,803,905 674,754 794,481 4,273,140 3,924,647 Operating expense 386,289 187,055 111,024 684,368 516,822 Depreciation 30,247 15,345 12,286 57,878 33,308 ' Total operating expenses 3,220,441 877,154 917,791 5,015,386 4,474,777 Net income (loss) from operations $148,150 ($62,608) $103,476 189,018 347,646 ' Nonoperating revenues (expenses) Interest income 53,052 46,745 , Miscellaneous revenues 8,407 5,909 Miscellaneous expenses (1,564) (1,997) Total nonoperating revenues (expenses) 59,895 50,657 ' Net income before operating transfers 248,913 398,303 Operating transfers: Operating transfers in Operating transfers (out) 4,231 (193,853) - 202,130 Total operating transfers 189,622 202,130 Net income 59,291 196,173 Retained earnings - January 1 1,296,646 1,100,473 Retained earnings - December 31 $1,355,937 $1,296,646 j 120 1 r CITY OF COLUMBIA HEIGHTS, MINNESOTA LIQUOR FUND STATEMENT OF CASH FLOWS For The Year Ended December 31, 1993 With Comparative Amounts For the Year Ended December 31, 1992 Statement 41 1993 1992 Cash flows from operating activities: ' Cash received from customers $5,206,928 $4,821,528 Cash paid to suppliers for goods and services (4,656,975) (4,073,261) Cash payments to employees for services (400,517) (305,379) Miscellaneous revenues 8,407 5,909 Miscellaneous expenses (1,564) (1,997) Net cash flows from operating activities 156,279 446,800 Cash flows from noncapital financing activities: Operating transfers in 4,231 - Operating transfers (out) (193,853) (202,130) ' Net cash flows from noncapital financing activities (189,622) (202,130) Cash flows from capital and related financing activities: Acquisition of fixed assets (203,301) (6,000) Disposition of fixed assets 1,505 Net cash flows from capital and related financing activities (203,301) (4,495) Cash flows from investing activities: Purchase of investments - (488,039) Proceeds from sale and maturity of investments 792,686 - ' Interest received on investments 53,052 44,447 Net cash flows from investing activities 845,738 (443,592) Net increase (decrease) in cash and cash equivalents 609,094 (203,417) ' Cash and cash equivalents - January 1 75,348 278,765 Cash and cash equivalents - December 31 $684,442 $75,348 ' Reconciliation of operating income to Net cash flows from operating activities ' Operating income $189,018 $347,646 Adjustments to reconcile operating income to net cash flows from operating activities: Miscellaneous revenues 8,407 5,909 Miscellaneous expenses (1,564) (1,997) Depreciation expense 57,878 33,308 ' Changes in assets and liabilities: (Increase) decrease in accounts receivable 2,827 (103) (Increase) decrease in due from other governmental units (303) (792) ' (Increase) decrease in prepaid expense (125) - (Increase) decrease in inventory, at cost (172,748) 81,176 Increase (decrease) in accounts payable 56,262 (28,135) ' Increase (decrease) in accrued salaries and withholdings payable 4,731 5,019 Increase (decrease) in due to other governmental units 11,896 4,769 Total adjustments (32,739) 99,154 ' Net cash flows from operating activities $156,279 $446,800 1 121 CH 122 CITY OF COLUMBIA HEIGHTS, MINNESOTA INTERNAL SERVICE Internal Service Funds are used to account for the financing on a cost reimbursement basis of goods or services provided by one department or agency to other departments or agencies within the City. Central Garage Fund - used to account for the costs of operating a maintenance facility for automotive equipment used by other City departments. Such costs are billed to other departments at actual cost plus a fixed overhead factor. The automotive equipment itself is acquired by the various user departments which are responsible for financing replacement vehicles as necessary. Energy Management Fund - used to account for the costs associated with energy management and maintenance within the City. All costs are recorded in the fund and allocated to user departments. Insurance Fund - used to account for the costs of risk management services for the City. All costs for premiums and claims are recorded in the fund. Conventional insurance costs are allocated to various departments based on coverage plus a percentage risk factor. 123 CITY OF COLUMBIA HEIGHTS, MINNESOTA INTERNAL SERVICE FUNDS COMBINING BALANCE SHEET December 31, 1993 With Comparative Totals For December 31, 1992 Statement 42 1 Central Energy Totals Garage Management Insurance 1993 1992 ' Assets Current assets: Cash and cash equivalents $78,439 $106,160 $752,885 $937,484 $5,618 Temporary investments - - - - 562,169 Receivables: 121,550 Machinery and equipment 100,298 - Accounts 2,752 - - 2,752 52 Interest 257 - 2,834 3,091 4,023 Prepaid expense - 9,207 8,966 18,173 65,999 Inventory, at cost 80,196 - - 80,196 85,886 Total current assets 161,644 115,367 764,685 1,041,696 723,747 Fixed assets: Buildings 312,138 395,871 - 708,009 309,668 Improvements other than buildings 121,550 314,910 - 436,460 121,550 Machinery and equipment 100,298 - - 100,298 99,384 Total fixed assets 533,986 710,781 0 1,244,767 530,602 Less accumulated depreciation 211,978 101,540 - 313,518 182,852 Net fixed assets 322,008 609,241 0 931,249 347,750 Total assets $483,652 $724,608 $764,685 $1,972,945 $1,071,497 Liabilities and Fund Equity Current liabilities: Accounts payable $8,172 $ - $3,036 $11,208 $12,755 Accrued salaries and withholdings payable 15,535 - - 15,535 15,191 Capital lease payable current - 90,991 - 90,991 - Deferred revenue 2,752 - - 2,752 - Accrued interest payable - 6,527 - 6,527 - Total current liabilities 26,459 97,518 3,036 127,013 27,946 Long -term liabilities: Capital lease payable net of current - 580,577 - 580,577 - Total liabilities 26,459 678,095 3,036 707,590 27,946 Fund equity: Contributed capital: Municipal funds 124,196 - - 124,196 124,196 Property owners 64,653 - - 64,653 64,653 Total contributed capital 188,849 0 0 188,849 188,849 Retained eamings: Reserved for insurance - - 761,649 761,649 607,644 Reserved for capital improvements 38,906 - - 38,906 32,260 Unreserved 229,438 46,513 - 275,951 214,798 Total retained earnings 268,344 46,513 761,649 1,076,506 854,702 Total fund equity 457,193 46,513 761,649 1,265,355 1,043,551 Total liabilities and fund equity $483,652 $724,608 $764,685 $1,972,945 $1,071,497 124 CITY OF COLUMBIA HEIGHTS MINNESOTA INTERNAL SERVICE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS For The Year Faded December 31, 1993 With Comparative Totals For The Year Ended December 31, 1992 4,388 - 48,247 Statement 43 ' Central Energy 10,162 Totals 95,443 Garage Management Insurance 1993 1992 Operating revenues: - Total nonoperating revenues (expenses) 8,026 25,805 129,890 Charges for services: 148,714 Net income (loss) before operating transfers 21,286 122,235 Services to departments $106,094 $202,656 $ - $308,750 $99,386 Use of space 115,839 - - 115,839 110,049 1 Insurance allocation - - 52,749 52,749 63,277 Recovery of damages 10,587 (14,587) 713 713 0 Charges for sales: 10,587 158,161 0 Net income 21,286 Sales of gasoline 50,822 - - 50,822 52,111 Total operating revenues 272,755 202,656 53,462 528,873 324,823 Operating expenses: $761,649 $1,076,506 Cost of services and space 230,369 197,546 - 427,915 243,021 Claims administration - - 10,952 10,952 17,997 and services - - 3,299 3,299 2,971 'Supplies Claims 4,509 4,509 27,783 Insurance deductible - - - - 3,702 Depreciation 29,126 101,540 - 130,666 29,071 ' Total operating expenses 259,495 299,086 18,760 577,341 324,545 Net income (loss) from operations Nonoperating revenues (expenses): 13,260 (96,430) 34,702 (48,468) 278 Interest income 4,388 - 48,247 52,635 31,512 Miscellaneous revenues 3,638 10,162 81,643 95,443 117,202 Interest expense - 35,967 - 35,967 - Total nonoperating revenues (expenses) 8,026 25,805 129,890 112,111 148,714 Net income (loss) before operating transfers 21,286 122,235 164,592 63,643 148,992 Operating transfers: Operating transfers in 4,000 168,748 - 172,748 4,000 Operating transfers (out) (4,000) - 10,587 (14,587) (4,000) Total operating transfers 0 168,748 10,587 158,161 0 Net income 21,286 46,513 154,005 221,804 148,992 Retained earnings - January 1 247,058 - 607,644 854,702 705,710 Retained earnings - December 31 $268,344 $46,513 $761,649 $1,076,506 $854,702 125 CITY OF COLUMBIA HEIGHTS, MINNESOTA INTERNAL SERVICE FUNDS COMBINING STATEMENT OF CASH FLOWS For The Year Ended December 31, 1993 With Comparative Totals For the Year Ended December 31, 1992 Cash flows from operating activities: Cash received from customers Cash paid to suppliers for goods and services Cash payments to employees for services Miscellaneous revenues Net cash flows from operating activities Cash flows from noncapital financing activities: Operating transfers in Operating transfers (out) Net cash flows from noncapital financing activities Central Energy Garage Management Insurance Statement 44 t Totals ' 1993 1992 $270,259 $202,656 $54,190 $527,105 $328,274 29,126 (116,918) 471,342 40,499 394,923 (189,126) , (108,438) - - (108,438) (124,103) - 3,638 10,162 81,643 95,443 117,202 47,826 48,541 684,160 176,332 909,033 132,247 (4,477) 4,000 168,748 - 172,748 4,000 - (4,000) - (10,587) (14,587) (4,000) 6,527 0 168,748 (10,587) 158,161 0 ' Cash flows from capital and related financing activities: 10,162 81,643 95,443 117,202 29,126 Acquisition of fixed assets (3,384) (710,781) - (714,165) (26,673) - Interest expense - (35,967) - (35,967) - - Net cash flows from capital and related financing activities (3,384) (746,748) 0 (750,132) (26,673) 47,826 Cash flows from investing activities: (3,773) - 2,226 (1,547) (4,477) Proceeds from sale and maturity of investments - - - - 331,191 - Interest earned on investments 4,388 - 48,247 52,635 30,755 6,527 Net cash flows from investing activities 4,388 0 48,247 52,635 361,946 ' Net increase in cash and cash equivalents Cash and cash equivalents - January 1 Cash and cash equivalents - December 31 Reconciliation of operating income (loss) to Net cash flows from operating activities Operating income (loss) Adjustments to reconcile operating income (loss) to net cash flows from operating activities: Miscellaneous revenues Depreciation expense Changes in assets and liabilities: (Increase) decrease in accounts receivable (Increase) decrease in inventory (Increase) decrease in prepaid expense Increase (decrease) in accounts payable Increase (decrease) in accrued salaries and withholdings payable Increase (decrease) in capital lease payable Increase (decrease) in accrued interest payable Increase (decrease) in deferred revenue Total adjustments Net cash flows from operating activities 126 49,545 106,160 213,992 369,697 467,520 28,894 - 538,893 567,787 100,267 $78,439 $106,160 $752,885 $937,484 $567,787 $13,260 ($96,430) $34,702 ($48,468) $278 3,638 10,162 81,643 95,443 117,202 29,126 101,540 - 130,666 29,071 (2,496) - 728 (1,768) 3,451 5,690 - - 5,690 (5,366) - (9,207) 57,033 47,826 (1,074) (3,773) - 2,226 (1,547) (4,477) 344 - - 344 (6,838) - 671,568 - 671,568 - - 6,527 - 6,527 - 2,752 - - 2,752 - 35,281 780,590 141,630 957,501 131,969 $48,541 $684,160 $176,332 $909,033 $132,247 MCITY OF COLUMBIA HEIGHTS, MINNESOTA CENTRAL GARAGE FUND BALANCE SHEET December 31, 1993 With Comparative Totals For December 31, 1992 ' Capital Operating Improvement Account Account Assets Current assets: Cash and cash equivalents Receivables: Accounts Interest Inventory, at cost Total current assets Fixed assets: Buildings Improvements other than buildings 1 Machinery and equipment Total fixed assets Less accumulated depreciation Net fixed assets Total assets Liabilities and Fund Equity Current liabilities: 1 Accounts payable Accrued salaries and withholdings payable Deferred revenue Total liabilities Fund equity: 1 Contributed capital: Municipal funds Property owners Total contributed capital Retained earnings: Reserved for capital improvement Unreserved Total retained earnings Total fund equity Total liabilities and fund equity Statement 45 Totals 1993 1992 $39,688 $38,751 $78,439 $28,894 2,752 - 2,752 52 102 155 257 461 80,196 - 80,196 85,886 122,738 38,906 161,644 115,293 229,438 312,138 - 312,138 309,668 121,550 - 121,550 121,550 100,298 - 100,298 99,384 533,986 0 533,986 530,602 211,978 - 211,978 182,852 322,008 0 322,008 347,750 $444,746 $38,906 $483,652 $463,043 $8,172 $ - $8,172 $11,945 15,535 - 15,535 15,191 2,752 - 2,752 - 26,459 0 26,459 27,136 124,196 - 124,196 124,196 64,653 - 64,653 64,653 188,849 0 188,849 188,849 - 38,906 38,906 32,260 229,438 - 229,438 214,798 229,438 38,906 268,344 247,058 418,287 38,906 457,193 435,907 $444,746 $38,906 $483,652 $463,043 127 CITY OF COLUMBIA HEIGHTS, MINNESOTA CENTRAL GARAGE FUND Statement 46 STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS For The Year Ended December 31, 1993 With Comparative Totals For The Year Ended December 31, 1992 Capital Equipment Operating Replacement Totals Account Account 1993 1992 Operating revenues: Charges for services: Services to departments Use of space Charges for sales: Sales of gasoline Total operating revenues Operating expenses: Cost of services and space Depreciation Total operating expenses Net income (loss) from operations Nonoperating revenues Interest income Miscellaneous revenues Total nonoperating revenues Net income (loss) before operating transfers Operating transfers: Operating transfers in Operating transfers (out) Total operating transfers Net income (loss) Retained earnings - January 1 Retained earnings - December 31 128 $106,094 $ - $106,094 $99,386 115,839 - 115,839 110,049 50,822 - 50,822 52,111 272,755 0 272,755 261,546 230,369 - 230,369 243,021 29,126 - 29,126 29,071 259,495 0 259,495 272,092 13,260 0 13,260 (10,546) 1,742 2,646 4,388 3,609 3,638 - 3,638 1,476 5,380 2,646 8,026 5,085 18,640 2,646 21,286 (5,461) - 4,000 4,000 4,000 (4,000) - (4,000) (4,000) (41000) 4,000 0 0 14,640 6,646 21,286 (5,461) 214,798 32,260 247,058 252,519 $229,438 $38,906 $268,344 $247,058 ICITY OF COLUMBIA HEIGHTS, MINNESOTA 'CENTRAL GARAGE FUND Statement 47 STATEMENT OF CASH FLOWS For The Year Ended December 31, 1993 With Comparative Amounts For the Year Ended December 31, 1992 ' Cash flows from operating activities: Cash received from customers Cash paid to suppliers for goods and services Cash payments to employees for services Miscellaneous revenues Net cash flows from operating activities Cash flows from noncapital financing activities: Operating transfers in Operating transfers (out) Net cash flows from noncapital financing activities Cash flows from capital and related financing activities: . Acquisition of fixed assets Cash flows from investing activities: Proceeds from sale and maturity of investments Interest earned on investments Net cash flows from investing activities Net increase in cash and cash equivalents Cash and cash equivalents - January 1 Cash and cash equivalents - December 31 Reconciliation of operating (loss) to Net cash flows from operating activities Operating income (loss) 1993 1992 $270,259 (116,918) (108,438) 3,638 48,541 4,000 (4,000) 0 $264,752 (122,752) (124,103) 1,476 19,373 4,000 (4,000) 0 (3,384) (26,673) 24,718 4,388 3,430 4,388 28,148 49,545 20,848 28,894 8,046 $78,439 $28,894 $13,260 ($10,546) Adjustments to reconcile operating (loss) to net cash flows from operating activities: Miscellaneous revenues 3,638 Depreciation expense 29,126 Changes in assets and liabilities: (Increase) decrease in accounts receivable (2,496) (Increase) decrease in inventory, at cost 5,690 Increase (decrease) in accounts payable (3,773) Increase (decrease) in accrued salaries and withholdings payable 344 Increase (decrease) in deferred revenue 2,752 Total adjustments 35,281 Net cash flows from operating activities $48,541 1,476 29,071 3,206 (5,366) 8,370 (6,838) 29,919 $19,373 129 CITY OF COLUMBIA HEIGHTS, MINNESOTA ENERGY MANAGEMENT FUND Statement 48 BALANCE SHEET December 31, 1993 With Comparative Amounts For December 31, 1992 Assets Current assets: Cash and cash equivalents Prepaid expense Total current assets Fixed assets: Buildings Improvements other than buildings Total fixed assets Less: Accumulated depreciation Total assets Liabilities and Fund Equity Current liabilities: Capital lease payable current Accrued interest payable Total current liabilities Long -term liabilities: Capital lease payable net of current Total liabilities Retained earnings: Unreserved Total liabilities and fund equity 130 1992 $106,160 $ - 9,207 - 115,367 0 395,871 - 314,910 - 710,781 0 101,540 - $724,608 $0 $90,991 $ - 6,527 - 97,518 0 580,577 - 678,095 0 46,513 - $724,608 $0 CITY OF COLUMBIA HEIGHTS, MINNESOTA ENERGY MANAGEMENT FUND Statement 49 STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS For The Year Ended December 31, 1993 With Comparative Amounts For The Year Ended December 31, 1992 Retained earnings - January 1 _ _ Retained earnings - December 31 $46,513 $0 1 131 1993 1992 Operating revenues: Charges for services: Services to departments $202,656 $ - Total operating revenues 202,656 0 Operating expenses: Cost of services and space 197,546 - Depreciation 101,540 - Total operating expenses 299,086 0 Net income (loss) from operations (96,430) 0 Nonoperating revenues (expenses) Miscellaneous revenues 10,162 Interest expense (35,967) Total nonoperating revenues (25,805) 0 Net income (loss) before operating transfers (122,235) 0 Operating transfers Operating transfers in 168,748 - Total operating transfers 168,748 0 Net income 46,513 0 Retained earnings - January 1 _ _ Retained earnings - December 31 $46,513 $0 1 131 CITY OF COLUMBIA HEIGHTS MINNESOTA ENERGY MANAGEMENT FUND STATEMENT OF CASH FLOWS Statement 50 For The Year Ended December 31, 1993 With Comparative Amounts For the Year Ended December 31, 1992 1993 1992 Cash flows from operating activities: Cash received from customers $202,656 $ - Cash paid to suppliers for goods and services 471,342 - Miscellaneous revenues 10,162 - Net cash flows from operating activities 684,160 0 Cash flows from noncapital financing activities: Operating transfers in 168,748 - Cash flows from capital and related financing activities: Acquisition of fixed assets (710,781) - Interest expense (35,967) Net cash flows from capital and related financing activities (746,748) 0 Net increase in cash and cash equivalents 106,160 0 Cash and cash equivalents - January 1 - Cash and cash equivalents - December 31 $106,160 $0 Reconciliation of operating income (loss) to Net cash flows from operating activities Operating income (loss) ($96,430) $ - Adjustments to reconcile operating income (loss) to net cash flows from operating activities: Miscellaneous revenues Depreciation expense 10,162 101,540 - - Changes in assets and liabilities: (Increase) decrease in prepaid expense (9,207) - Increase (decrease) in capital lease payable 671,568 - Increase (decrease) in accrued interest payable 6,527 - Total adjustments 780,590 0 Net flows from cash operating activities $684,160 $0 132 CITY OF COLUMBIA HEIGHTS MINNESOTA INSURANCE FUND Statement 51 BALANCE SHEET December 31, 1993 With Comparative Amounts For December 31, 1992 1993 1992 Assets Current assets: Cash and cash equivalents $752,885 $538,893 Receivables: Interest 2,834 3,562 Prepaid expense 8,966 65,999 Total assets $764,685 $608,454 Liabilities and Fund Equity Current liabilities: Accounts payable $3,036 $810 Fund equity: Retained earnings: Reserved for insurance 761,649 607,644 Total liabilities and fund equity i $764,685 $608,454 1 1 1 r 133 CITY OF COLUMBIA HEIGHTS MINNESOTA INSURANCE FUND STATEMENT OF REVENUES, EXPENSES AND Statement 52 CHANGES IN RETAINED EARNINGS For The Year Ended December 31, 1993 With Comparative Amounts For The Year Ended December 31, 1992 1993 1992 Operating revenues: Insurance allocation $52,749 $63,277 Recovery of damages 713 - Total operating revenues 53,462 63,277 Operating expenses: Claims administration 10,952 17,997 Supplies and services 3,299 2,971 Claims 4,509 27,783 Insurance deductible - 3,702 Total operating expenses 18,760 52,453 Net income from operations 34,702 10,824 Nonoperating revenues Interest income 48,247 27,903 Miscellaneous revenues 81,643 115,726 Total nonoperating revenues 129,890 143,629 Net income before operating transfers 164,592 154,453 Operating transfers Operating transfers (out) (10,587) - Total operating transfers (10,587) 0 Net income 154,005 154,453 Retained earnings - January 1 607,644 453,191 Retained earnings - December 31 $761,649 $607,644 134 CITY OF COLUMBIA HEIGHTS, MINNESOTA INSURANCE FUND Statement 53 STATEMENT OF CASH FLOWS For The Year Faded December 31, 1993 With Comparative Amounts For the Year Ended December 31, 1992 Cash flows from operating activities: Cash received from damages Cash paid to suppliers for goods and services Miscellaneous revenues Net cash flows from operating activities Cash flows from noncapital financing activities: Operating transfers in (out) Cash flows from investing activities: Proceeds from sale and maturity of investments Interest earned on investments Net cash flows from investing activities Net increase in cash and cash equivalents Cash and cash equivalents - January 1 Cash and cash equivalents - December 31 Reconciliation of operating income to Net cash flows from operating activities Operating income Adjustments to reconcile operating income to net cash flows from operating activities: Miscellaneous revenues Changes in assets and liabilities: (Increase) decrease in accounts receivable (Increase) decrease in prepaid expense Increase (decrease) in accounts payable Total adjustments Net cash flows from operating activities 1993 $54,190 40,499 81,643 176,332 (10,587) 48,247 48,247 213,992 538,893 $752,885 $34,702 81,643 728 57,033 2,226 141,630 $176,332 1992 $63,522 (66,374) 115,726 112,874 306,473 27,325 333,798 446,672 92,221 $538,893 $10,824 115,726 245 (1,074) (12,847) 102,050 $112,874 135 CH 149101 CITY OF COLUMBIA HEIGHTS, MINNESOTA I t I t 1 1 TRUST AND AGENCY FUNDS Trust and Agency Funds are used to account for assets held by a government in a trustee or agent capacity for individuals, private organizations, other governments and/or other funds. Agency Funds: Deferred Compensation Fund - used to account for assets held by deferred compensation trustee. Permit Surchar eg Fund - used to account for SAC and SUR charges collected for and remitted to the State of Minnesota. Escrow Agency Fund - used to account for payroll - related assets and liabilities. Trust Funds: Flex Benefit - used to account for contributions by employees and related expenditures for flexible benefits. Compensated Absences - used to account for funds that have been set aside by the City Council for compensated absences. 137 CITY OF COLUMBIA HEIGHTS, MINNESOTA FIDUCIARY FUNDS COMBINING BALANCE SKEET December 31, 1993 Assets Cash and investments Receivables: Interest Assets held by deferred compensation trustee Total assets Liabilities and Fund Balance Liabilities: Accounts payable Deferred compensation payable to employees Deposits Other liabilities Total liabilities Fund balance: Unreserved: Designated for compensated absences Undesignated Total fund balance Total liabilities and fund balance 138 Statement 54 Expendable Trust Flex Compensated Agency Benefit Absences Funds Total $2,316 $208,278 $7, 163 $217,757 - 516 - 516 - - 1,523237 1,523,237 $2,316 $208,794 $1,530,400 $1,741,510 $1,611 $ - $667 $2,278 - - 1,523,237 1,523,237 5,742 5,742 754 754 1,611 0 1,530,400 1,532,011 - 208,794 - 208,794 705 - - 705 705 208,794 0 209,499 $2,316 $208,794 $1,530,400 $1,741,510 139 CITY OF COLUMBIA HEIGHTS, MINNESOTA EXPENDABLE TRUST FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES Statement 55 AND CHANGES IN FUND BALANCE For The Year Ended December 31, 1993 jFlex - Compensated Benefit Absences Total Revenues: Flex withholding $27,697 $ - $27,697 Forfeiture 13 - 13 j Interest 6 8,794 8,800 Other 5,717 - 5,717 Total revenues 33,433 8,794 42,227 Expenditures: Other services and charges 30,358 - 30,358 Revenues over expenditures 3,075 8,794 11,869 Other financing sources: 1 Operating transfers in - 100,000 100,000 Net increase in fund balance 3,075 108,794 111,869 Fund balance (deficit) - January 1 (2,370) 100,000 97,630 Fund balance - December 31 $705 $208,794 $209,499 139 CITY OF COLUMBIA HEIGHTS, MINNESOTA FIDUCIARY FUNDS Statement 56 COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES - ALL AGENCY FUNDS For The Year Faded December 31, 1993 Balance Balance 1/1/93 Additions Deletions 12/31/93 Total All Agency Funds Assets Cash and investments: General account Payroll account Total cash and cash equivalents Accounts receivable Assets held by deferred compensation trustees Total assets Liabilities Accounts payable Deferred compensation payable to employees Deposits Other liabilities Total liabilities Deferred Compensation Agency Fund Assets Assets held by deferred compensation trustee Liabilities Deferred compensation payable to employees Permit Surcharge Agency Fund Assets Cash and investments - general account Liabilities SAC /SUR charges payable Escrow Agency Fund Assets Cash and investments: General account Payroll account Accounts receivable Total assets Liabilities Deposits Other liabilities: Withholdings payable Payroll deductions payable Employee activity Total liabilities 140 $11,789 $500 $6,126 $6,163 1,000 - - 1,000 12,789 500 6,126 7,163 318 - 318 - 1,195,530 327,707 - 1,523,237 $1,208,637 $328,207 $6,444 $1,530,400 $667 $ - $ - $667 1,195,530 327,707 - 1,523,237 10,475 - 4,733 5,742 1,965 418 1,629 754 $1,208,637 $328,125 $6,362 $1,530,400 $1,195,530 $327,707 $ - $1,523,237 $1,195,530 $327,707 $ - $1,523,237 $778 $- $466 $312 $778 $234 $700 $312 $11,011 $500 $5,660 1,000 - - 318 - 318 $12,329 $500 $5,978 $10,475 $ - $5,851 1,000 1pv,u-1 l $4,733 $5,742 60 - 60 - 346 184 310 220 1,448 - 559 889 $12,329 $184 $5,662 $6,851 HOUSING AND REDEVELOPMENT AUTHORITY COMPONENT UNIT 141 CITY OF COLUMBIA HEIGHTS, MINNESOTA HOUSING AND REDEVELOPMENT AUTHORITY FUNDS COMBINING BALANCE SHEET December 31, 1993 With Comparative Totals For December 31, 1992 r Governmental Fund Types Special Capital Assets General Revenue Project Cash and investments $154,383 $398,662 $ - Receivables: Accounts Taxes 200 1,790 596 - - - Interest 242 332 - Loans 376,195 - - Due from other governmental units 16,353 18,215 - Due from other funds 167,704 - - Due from primary government 3,510 - - Due from developer - - 65,000 Prepaid expense 526 7,018 - Assets held by deferred compensation trustee - - - Real estate held for resale 81,460 87,068 - Fixed assets - - - Amount to be provided for compensated absences - - - Total assets $802,363 $511,891 $65,000 Liabilities, Equity and Other Credits Liabilities: Accounts payable $889 $30,333 $558 Accrued salaries and withholdings payable 3,770 2,337 - Deferred compensation payable - - - Due to other governmental units 828 30,374 - Due to other funds - 86,319 81,385 Due to primary government Deferred revenue 6,178 377,962 1,470 135 - 65,000 Deposits - 10,618 - Insurance and taxes in escrow 4,191 - - Compensated absences payable - - - Other liabilities: Accrued liability for future program income - 87,068 - Total liabilities 393,818 248,654 146,943 Equity and other credits: Investment in general fixed assets - - - Fund balance: Reserved for prepayments 526 7,018 - Reserved for community development Unreserved: 170,497 - - Designated 35,384 193,004 - Undesignated 202,138 63,215 (81,943) Total equity and other credits 408,545 263,237 (81,943) Total liabilities, equity and other credits $802,363 $511,891 $65,000 142 , Statement 57 Fiduciary Fund Type Account Groups General General Long -Term Totals Agency Fixed Assets Debt 1993 1992 $ - $ - $ - $553,045 $747,484 - - - 796 5,066 - - - 1,790 3,362 - - - 574 264 - - - 376,195 410,106 - - - 34,568 61,032 - - - 167,704 68,663 - - - 3,510 4,466 - - 65,000 - = - - 7,544 7,849 201,896 - - 201,896 172,111 - - 168,528 89,966 5,122,237 5,122,237 5,066,689 - - 10,711 10,711 9,590 $201,896 $5,122,237 $10,711 $6,714,098 $6,646,648 $ - $ - $ - $31,780 $41,269 - - - 6,107 7,252 201,896 - - 201,896 172,111 - - - 31,202 34,034 - - - 167,704 68,663 - - - 7,648 30,074 - - - 443,097 425,586 - - - 10,618 10,265 - 4,191 6,634 _ 10,711 10,711 9,590 - - - 87,068 68,853 201,896 0 10,711 1,002,022 874,331 - 5,122,237 - 5,122,237 5,066,689 - - - 7,544 7,849 - - - 170,497 165,139 - - - 228,388 190,501 - - - 183,410 342,139 0 5,122,237 0 5,712,076 5,772,317 $201,896 $5,122,237 $10,711 $6,714,098 $6,646,648 143 CITY OF COLUMBIA HEIGHTS, MINNESOTA HOUSING AND REDEVELOPMENT AUTHORITY FUNDS Statement 58 COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - ALL GOVERNMENTAL FUND TYPES For The Year Ended December 31, 1993 With Comparative Totals For The Year Ended December 31, 1992 Revenues: Taxes Intergovernmental Rents Interest Other Total revenues Expenditures: Personal services Supplies Other services and charges Loans and grants Capital outlay Total expenditures Revenues over (under) expenditures Fund balance - January 1 Fund balance (deficit) - December 31 r 144 1 Special Capital Totals General Revenue Project 1993 1992 $8,607 $ - $ - $8,607 $58,723 40,157 200,770 - 240,927 253,295 - 387,306 - 387,306 391,275 6,931 10,074 - 17,005 26,317 163,745 12,535 18,261 194,541 167,706 219,440 610,685 18,261 848,386 897,316 132,410 79,894 - 212,304 294,884 3,732 22,732 99 26,563 23,007 81,938 286,146 39,103 407,187 448,811 53,572 109,222 - 162,794 101,930 - 94,325 61,002 155,327 69,596 271,652 592,319 100,204 964,175 938,228 (52212) 18,366 (81,943) (115,789) (400912) 460,757 244,871 - 705,628 746,540 $408,545 $263,237 ($81,943) $589,839 $705,628 r 144 1 GENERAL FIXED ASSETS ACCOUNT GROUP The City maintains a separate account group which contains the fixed assets used in the governmental fund type operations. They are assets of the City as a whole and not of individual funds. 145 CITY OF COLUMBIA HEIGHTS, MINNESOTA COMPARATIVE SCHEDULE OF GENERAL FIXED ASSETS BY SOURCE For The Year Ended December 31, 1993 Land Buildings Improvements other than buildings Machinery and equipment Construction in process Total 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 revenue and contributions Total investments in general fixed assets 146 s Statement 59 1 Balance Balance 1/1/93 Additions Deletions 12/31/'93 $3,132,099 $ - $ - $3,132,099 3,032,275 35,747 - 3,068,022 1,440,485 3,141 - 1,443,626 4,070,059 333,429 46,450 4,357,038 248,867 354,466 - 603,333 $11,923,785 $726,783 $46,450 $12,604,118 $90,000 $ - $ - $90,000 150,000 - - 150,000 325,000 - - 325,000 510,000 - - 510,000 929,475 - - 929,475 2,004,475 0 0 2,004,475 526,290 - - 526,290 267,203 - - 267,203 793,493 0 0 793,493 1,752,317 - - 1,752,317 51,550 - - 51,550 1,803,867 0 0 1,803,867 7,321,950 726,783 46,450 8,002,283 $11,923,785 $726,783 $46,450 $12,604,118 t CITY OF COLUMBIA HEIGHTS MINNESOTA iSCHEDULE OF CHANGES IN GENERAL FIXED ASSETS BY FUNCTION AND ACTIVITY For The Year Ended December 31, 1993 Statement 60 ' 147 Balance Balance 1/1/'93 Additions Deletions 12/31/93 General Government: Council $22,565 $ - $ - $22,565 Manager 23,723 - - 23,723 Finance and elections 228,433 46,020 5,500 268,953 Assessing 14,745 352 - 15,097 Planning 679 - - 679 General government buildings 1,101,684 21,453 - 1,123,137 Total General Government 1,391,829 67,825 5,500 1,454,154 Public Safety: Police/animal/civil defense 353,025 65,792 2,000 416,817 Fire 405,359 4,451 - 409,810 Inspections 20,380 - - 20,380 Total Public Safety 778,764 70,243 2,000 847,007 Public Works: Engineering 204,315 12,066 3,200 213,181 Maintenance 1,642,486 128,159 29,050 1,741,595 Total Public Works 1,846,801 140,225 32,250 1,954,776 Other Departments: Sanitation 652 - - 652 Parks and Recreation 7,289,783 90,343 6,700 7,373,426 Library 348,285 1,866 - 350,151 Cable television 18,804 1,815 - 20,619 Construction in process 248,867 354,466 - 603,333 \� Total Other Departments 7,906,391 448,490 6,700 8,348,181 Total general fixed assets $11,923,785 $726,783 $46,450 $12,604,118 ' 147 CITY OF COLUMBIA HEIGHTS, MINNESOTA SCHEDULE OF GENERAL FIXED ASSETS BY FUNCTION AND ACTIVITY December 31, 1993 Statement 61 1 Totals Mr.] $3,132,099 $3,068,022 $1,443,626 $4,357,038 $603,333 $12,604,118 Improvements Machinery Other Than and Construction Land Buildings Buildings Equipment In Process Total General Government: Council $ - $ - $ - $22,565 $ - $22,565 Manager - - - 23,723 - 23,723 Finance and elections - - - 268,953 - 268,953 Assessing - - - 15,097 - 15,097 Planning - - - 679 - 679 General government buildings 110,920 931,341 19,396 61,480 - 1,123,137 Total General Government 110,920 931,341 19,396 392,497 0 1,454,154 Public Safety: PoliWanimal/civil defense - - 1,710 415,107 - 416,817 Fire - 2,798 2,199 404,813 - 409,810 Inspections - - - 20,380 - 20,380 Total Public Safety 0 2,798 3,909 840,300 0 847,007 Public Works: Engineering Maintenance - - 4,487 18,750 2,801 562,244 205,893 1,160,601 - - 213,181 1,741,595 Total Public Works 0 23,237 565,045 1,366,494 0 1,954,776 Other Departments: Sanitation - - - 652 - 652 Parks and recreation 3,000,179 1,912,382 855,276 1,605,589 - 7,373,426 Library 21,000 198,264 - 130,887 - 350,151 Cable television - - - 20,619 - 20,619 Construction in process - - - - 603,333 603,333 Total Other Departments 3,021,179 2,110,646 855,276 1,757,747 603,333 8,348,181 Totals Mr.] $3,132,099 $3,068,022 $1,443,626 $4,357,038 $603,333 $12,604,118 GENERAL LONG -TERM DEBT ACCOUNT GROUP The General Long -Term Debt Account Group is used to account for the long -term debt of the City other than debt recorded in the Enterprise Fund. 149 CITY OF COLUMBIA HEIGHTS, MINNESOTA STATEMENT OF GENERAL LONG -TERM DEBT Statement 62 December 31, 1993 Amount Available And To Be Provided For The Payment Of General Long -Term Debt Amount available in Debt Service Funds $7,922,087 Amount to be provided for retirement of: Long -term debt 9,844,318 Note payable to HRA 15,228 Liability for compensated absences 362,043 Total available and to be provided for $18,143,676 General Long -Term Debt Payable General Obligation Bonds payable $17,209,721 Accreted interest on Capital Appreciation Bonds 556,684 Note payable to HRA 15,228 Liability for compensated absences payable 362,043 �. Total general long -term debt payable $18,143,676 r 150 CITY OF COLUMBIA HEIGHTS, MINNESOTA SCHEDULE OF DEBT SERVICE REQUIREMENTS TO MATURITY Statement 63 December 31, 1993 1 151 General Obligation Bonds Year Principal Interest 1994 $7,565,000 $472,659 1995 1,020,000 392,961 1996 1,155,000 304,268 1997 1,155,000 246,128 1998 990,000 190,390 1999 945,000 138,167 2000 900,000 86,980 2001 860,000 37,270 2002 611,515 499,865 2003 377,918 542,082 2004 350,584 569,416 2005 327,272 592,728 2006 300,822 619,178 2007 280,545 639,455 2008 259,375 660,625 2009 111,690 313,310 Total $17,209,721 $6,305,482 1 151 CH 152 CITY OF COLUMBIA HEIGHTS, NIINNESOTA SUPPLEMENTARY FINANCIAL INFORMATION 153 CITY OF COLUMBIA HEIGHTS MINNESOTA , COMBINING SCHEDULE OF BONDS PAYABLE ' December 31, 1993 Interest Issue Maturity Rate Date Date Special Assessment Bonds General Obligation Refunding All bonds maturing on or after March 1, 1992 shall be subject to 3/01 -9/01 redemption and prior payment in whole or in part in inverse order of 6.00% maturity at the option of the issue on March 1, 1991 and interest 6.40% payment date thereafter at a price of the principal amount thereof 6.60% plus accrued interest. Total Special Assessment Bonds Tax Increment Bonds G.O. Tax Increment Bonds Series 1984 Bonds maturing on or after March 1, 1992 will be subject to 3/01-9/01 redemption and prepayment at the option of the City in inverse 9.20% order on March 1, 1991 and any interest payment date thereafter at 9.40% 100% of their principal plus accrued interest. G.O. Tax Increment Refunding Bonds of 1987 Series A (A) Bonds maturing on or after March 1, 1995 will be subject to 3/01-9/01 redemption and prepayment in whole or in part in inverse order of 6.20% maturity at the option of the issuer on March 1, 1994 and any 6.40% interest payment date thereafter at a price of the principal amount 6.60% thereof plus accrued interest. 6.80% 7.00% 7.10% 7.20% 7.30% 7.40% 7.50% 6/1/87 3/1/95 6/1/84 3/1/94 6/1/87 3/1/02 (A) For the G.O. TI Refunding Bonds of 1987 Series A, the remaining serial payments for the years 1996 - 2002, a total of $6,550,000, is in an escrow account as a result of the 1991 refunding issue. This escrow account will be used to pay all bonds maturing on or after March 1, 1995. 154 Exhibit 1 Page 1 of 2 Interest Original Balance Balance Paid in Issue 1/1/93 Sold Retired 12/31/'93 Current Year ' $2,230,000 $910,000 $ - $910,000 $ - $49,660 2,230,000 910,000 0 910,000 0 49,660 1,070,000 305,000 - 145,000 160,000 21,710 9,090,000 7,925,000 - 680,000 7,245,000 529,205 155 CITY OF COLUMBIA HEIGHTS, MINNESOTA COMBINING SCHEDULE OF BONDS PAYABLE December 31, 1993 Tax Increment Bonds (continued) Taxable Tax Increment Bonds of All bonds maturing on or after February 1, 1994 shall be subject to redemption and prior payment in whole or in part in inverse order of maturity at the option of the issuer on February 1, 1993 and any interest payment date thereafter at a price of par plus accrued interest. G.O. Tax Increment Capital Appreciation Bonds of 1990 Tax Increment Refunding Bonds of 1 All bonds maturing on or after March 1, 2000 shall be subject to redemption and prior payment in whole or in part at the option of the issuer on March 1, 1999 and on any day thereafter at a price of par and accrued interest. Tax Increment Refunding Bonds of 1 The City may discharge all bonds which are due on any date by depositing with the Registrar on or before that date a sum sufficient for the payment thereof in full. If any bond should not be paid when due, it may nevertheless be discharged by depositing with the Registrar a sum sufficient for the payment thereof in full with interest accrued to the date of such deposit Total General Obligation Tax Increment Bonds Total Bond Principal Payable - All Funds 156 Interest Issue Maturity Rate Date Date 6/1/87 211/97 2101-8/01 8.60% 8.75% 8.90% 9.00% 9.10% 9.10% 9/01 6.90% 6.95% 7.00% 7.00% 7.10% 7.10% 7.15% 7.15% 3/01-9/01 4.75% 5.00% 5.10% 5.30% 5.50% 5.60% 5.70% 5.80% 3.80% 4.40% 4.75% 5.15% 8/23/90 911109 11/21/91 3/1102 7/1/93 2/1/97 ' Exhibit 1 Page 2 of 2 157 Interest Original Balance Balance Paid in . Issue 1/1/93 Sold Retired 12/31/93 Current Year ' $1,100,000 $850,000 $ - $850,000 $ - $81,970 ' 2,399,721 2,399,721 - - 2,399,721 - 6,670,000 6,670,000 - - 6,670,000 353,243 735,000 - 735,000 - 735,000 - 21,064,721 18,149,721 735,000 1,675,000 17,209,721 986,128 $23,294,721 $19,059,721 $735,000 $2,585,000 $17,209,721 $1,035,788 157 Sources of Funds: Bond proceeds Tax increment received Interest on invested funds Real estate sales EDA grant Revenue sharing Land sale Other Total sources of funds Uses of Funds: Land acquisition Site improvements or preparation costs Installation of public utilities and improvements Other public improvements Bond payments: Principal Interest Administrative costs Other Total uses of funds Funds remaining (or deficient) 158 $8,175,000 $21,964,721 CITY OF COLUMBIA HEIGHTS, MINNESOTA $730,073 SCHEDULE OF SOURCES AND USES OF PUBLIC FUNDS FOR HOUSING AND REDEVELOPMENT AUTHORITY TAX Exhibit 2 ' INCREMENT FINANCING DISTRICTS 9,947,805 December 31, 1993 (11,101,715) - - 2,455,946 421,285 Accounted Original Amended For in Current Amount , Budget Budget Prior Years Year Remaining Sources of Funds: Bond proceeds Tax increment received Interest on invested funds Real estate sales EDA grant Revenue sharing Land sale Other Total sources of funds Uses of Funds: Land acquisition Site improvements or preparation costs Installation of public utilities and improvements Other public improvements Bond payments: Principal Interest Administrative costs Other Total uses of funds Funds remaining (or deficient) 158 $8,175,000 $21,964,721 $21,928,724 $730,073 ($694,076) - - 9,947,805 1,153,910 (11,101,715) - - 2,455,946 421,285 (2,877,231) 702,630 753,630 1,303,929 5,248 (555,547) 1,415,000 1,415,000 1,482,000 - (67,000) - 60,000 - - 60,000 - 7,000 55,000 - (48,000) - 340,000 2,420,197 - (2,080,197) 27,796,325 10,292,630 24,540,351 39,593,601 2,310,516 (17,363,766) 4,800,000 7,034,000 7,357,742 60,691 (384,433) 100,000 475,000 164,891 - 310,109 325,000 478,800 447,296 - 31,504 2,500,000 4,250,000 3,486,364 - 763,636 8,175,000 15,294,721 12,984,289 1,675,000 635,432 10,031,325 19,248,682 11,201,703 993,698 7,053,281 566,000 1,008,500 1,321,949 39,513 (352,962) 1,299,000 3,789,399 3,268,701 44,975 475,723 27,796,325 51,579,102 40,232,935 2,813,877 8,532290 ($17503,695) ($27,038,751) ($639,334) ($503,361) ($25,896,056) CITY OF COLUMBIA HEIGHTS, MINNESOTA 'NOTE - SOURCES OF FUNDS Exhibit 3 FOR HOUSING AND REDEVELOPMENT AUTHORITY TAX INCREMENT FINANCING DISTRICTS ' December 31, 1993 Note (1) Sources of Funds ' Real Estate Land Sales Land Sale Amount Date Total Cost* Propertl Columbia Heights Office Plaza Evenson Properties $133,500 10/81 ' LaBelle Park Condo No. 1 The Gaughan Companies 137,464 10/81 Columbia Heights Mall Evenson Properties e 138,167 2/82 LaBelle Park Condo No. 2 'The Gaughan Companies 168,498 3/82 LaBelle Park Condo No. 3 The Gaughan Companies 126,000 9/82 University Heights Housing 1 9/84 Columbia Park Medical Clinic Columbia Park Properties 20,000 11/85 Sullivan Lake Housing 420,000 11/87 Columbia Square Northeast Partners 149,459 8/88 Parkview Villa South Housing 8/90 ' Totals $1,293,089 $6,116,914 Note (2) Sources of Funds Tax Exempt Obligation Issued on Behalf of Private Entities Development Amount Issue Type Columbia Heights Office Plaza Commercial Redevelopment ' Evenson Properties $6,000,000 Revenue Bonds Series 1981 Columbia Heights Mall Commercial Redevelopment Evenson Properties 4,000,000 Revenue Bonds Series 1981 4111 Building South Commercial Redevelopment Ruvelson and Associates 775,000 Revenue Bonds Series 1981 1 LaBelle Park Condominiums Commercial Redevelopment The Gaughan Companies 9,000,000 Revenue Bonds Series 1980 Columbia Park Medical Clinic Commercial Redevelopment ' Columbia Park Properties 5,000,000 Revenue Bonds Series 1985 Columbia Park Medical Clinic Commercial Development Refunding M Columbia Park Properties 4,785,000 Revenue Bonds Series 1992 Note (3) Sources of Funds * Individual project costs were not available to be used in Note (1) Sources of Funds. A total of all projects has been provided. 159 CH •1 CITY OF COLUMBIA HEIGHTS, MINNESOTA III. STATISTICAL SECTION 161 CITY OF COLUMBIA HEIGHTS, MINNESOTA ASSESSED VALUE, TAX CAPACITY, AND ESTIMATED ACTUAL VALUE OF ALL TAXABLE PROPERTY (A) Years 1984 Through 1993 (Unaudited) Table 1 ' (A) For tax collection years 1988 and prior, taxable valuation was calculated based on a specific formula applied to estimated actual value, which resulted in an assessed valuation, which was then used as a base upon which to spread the annual tax levies. Beginning in 1989, the State of Minnesota legislated a change in this formula. This change is intended to reflect the burden or "tax capacity" that property is able to bear. The new formula results in a considerably smaller taxable valuation for the City. In this table, for the purpose of comparison only, 1988 and prior years are reported under the old system of assessed valuation, while 1989 and subsequent years are reported in terms of tax capacity. (B) The Metropolitan Fiscal Disparities Act was first implemented for taxes payable in 1975 for the seven Metropolitan counties of Anoka, Carver, Dakota, Hennepin, Ramsey, Scott, and Washington. Forty percent of the increase in commercial - industrial (including public utility) valuation in each assessment district since 1971 is contributed to an area -wide tax base. Using the factors of population and real property market value, a per capita distribution index is calculated. This index is employed in determining what proportion of the valuation shall be distributed back to each assessment district. (162) j Real Property Personal Property Area Wide Allocation (B) Total Ratio of Total Assessed/ Tax Capacity Value Assessed/ Estimated Assessed/ Estimated Assessed/ Estimated to Total Fiscal Tax Capacity Actual Tax Capacity Actual Tax Capacity Actual Estimated Year Value Value Value Value Contribution Distribution Value Value Actual Value 1984 $105,913,390 $445,177,400 $1,426,869 $3,318,300 ($5,178,793) $12,001,080 $114,162,546 $448,495,700 25.45% 1985 108,671,288 461,786,700 1,426,869 3,414,600 (4,695,234) 13,636,552 119,039,475 465,201,300 25.594, 1986 113,721,411 476,771,500 1,500,988 3,511,600 (4,407,361) 14,264,696 125,079,734 480,283,100 26.04% 1987 114,767,361 484,669,200 1,547,299 3,619,300 (5,778,163) 15,650,911 126,187,408 488,288,500 25.84911. 1988 116,314,660 507,684,800 1,679,868 3,927,600 (5,180,460) 17,871,259 130,685,327 511,612,400 25.54% 1989 14,532,465 522,002,900 208,985 4,017,800 (725,395) 2,478,750 16,494,805 526,020,700 3.14% 1990 10,022,891 533,586,700 212,505 4,234,500 (712,924) 2,841,497 12,363,969 537,821200 2.30% 1991 9,901,542 536,614,500 210,051 4,258,500 (510,571) 3,290,306 12,891,328 540,873,000 2.38% 1992 9,503,314 538,522,400 207,255 4,398,000 (609,791) 3,067,799 12,168,577 542,920,400 2.24% 1993 9,226,574 537,840,800 207,309 4,447,000 (594,265) 2,852,940 11,692,558 542,287,800 2.16% (A) For tax collection years 1988 and prior, taxable valuation was calculated based on a specific formula applied to estimated actual value, which resulted in an assessed valuation, which was then used as a base upon which to spread the annual tax levies. Beginning in 1989, the State of Minnesota legislated a change in this formula. This change is intended to reflect the burden or "tax capacity" that property is able to bear. The new formula results in a considerably smaller taxable valuation for the City. In this table, for the purpose of comparison only, 1988 and prior years are reported under the old system of assessed valuation, while 1989 and subsequent years are reported in terms of tax capacity. (B) The Metropolitan Fiscal Disparities Act was first implemented for taxes payable in 1975 for the seven Metropolitan counties of Anoka, Carver, Dakota, Hennepin, Ramsey, Scott, and Washington. Forty percent of the increase in commercial - industrial (including public utility) valuation in each assessment district since 1971 is contributed to an area -wide tax base. Using the factors of population and real property market value, a per capita distribution index is calculated. This index is employed in determining what proportion of the valuation shall be distributed back to each assessment district. (162) j CITY OF COLUMBIA HEIGHTS, MINNESOTA 'TAX RATES - PER $100 OF TAX CAPACITY Table 2 Years 1984 Through 1993 (Unaudited) Year (A) City School County Metro Other (B) Total 1984 16.610 56.227 26.088 4.197 0.944 104.066 1985 16.300 50.487 23.868 4.250 1.048 95.953 1986 16.420 53.797 25.537 3.574 1.330 100.658 1987 19.472 63.234 29.414 4.223 1.136 117.479 1988 20.083 60.733 30.766 4.314 0.992 116.888 ' 1989 0.15722 0.51364 0.25184 0.03360 0.00954 0.96584 1990 0.20275 0.41329 0.26440 0.03470 0.00988 0.92502 1991 0.19040 0.53249 0.28808 0.03395 0.01102 1.05594 1992 0.22956 0.61847 0.30308 0.03928 0.00937 1.19976 1993 0.23021 0.68142 0.30033 0.04225 0.01018 1.26420 1 (A) For tax collection years 1988 and prior, taxable valuation was calculated based on a specific formula applied to estimated actual value, which resulted in an assessed valuation, which was then used as a base upon which to spread the annual tax levies. Beginning in 1989, the State of Minnesota legislated a change in this formula. This change is intended to reflect the burden or "tax capacity" that property is able to bear. The new formula results in a considerably smaller taxable valuation for the City. In this table, for the purpose of comparison only, 1988 and prior years are reported under the old system of assessed valuation, while 1989 and subsequent years are reported in terms of tax capacity. (B) Rice Creek Watershed, Mosquito Control, and Housing and Redevelopment Authority. ���3 ' CITY OF COLUMBIA HEIGHTS, MINNESOTA CITY TAX LEVY Years 1984 Through 1993 Table 3 , (Unaudited) Fiscal City Levy General Police Fire Year Total Fund Relief Relief Library ' 1984 $1,757,486 $1,617,500 $77,313 $62,673 $- 1985 1,825,192 1,662,532 79,700 82,960 - 1986 1,888,616 1,725,956 79,700 82,960 - , 1987 2,181,115 2,008,455 89,700 82,960 - 1988 2,391,689 2,258,872 65,242 67,575 - , 1989 2,391,689 2,298,989 54,266 38,434 - , 1990 2,882,056 2,760,455 64,549 57,052 - 1991 3,144,069 2,963,869 98,606 81,594 - ' 1992 3,368,595 3,368,595 - - - 1993 3,463,645 3,084,666 - - 378,979 164 ' ' CITY OF COLUMBIA HEIGHTS, MMESOTA TAX LEVIES AND TAX COLLECTIONS Table 4 'Years 1984 Through 1993 (Unaudited) Ratio of Accumulated Collections Percentage Collections Delinquent of Current of Levy of Prior Ratio Taxes to Years Taxes Collected Years Taxes of Total Accumulated Current Year Total During Fiscal During Fiscal During Fiscal Total Collections Delinquent Year Collected Tax Levy* Period Period Period Collections to Tax Levy Taxes Tax Levy 1984 $1,285,324 $1,253,908 97.6% $20,640 $1,274,548 0.9916:1 $36,290 0.02823:1 1985 1,286,626 1,256,387 97.6% 25,184 1,281,571 0.9961:1 51,764 0.04023:1 1986 1,395,303 1,365,014 97.8% 15,494 1,380,508 0.9894:1 53,140 0.03808:1 ' 1987 1,624,073 1,605,851 98.9% 41,633 1,647,484 1.0144:1 55,101 0.03393:1 1988 1,800,335 1,762,573 97.9% 18,395 1,780,968 0.9892:1 53,374 0.02965:1 1989 1,811,862 1,785,190 98.5% 13,601 1,798,791 0.9928:1 79,005 0.04360:1 1990 2,079,001 2,057,446 99.0% 3,249 2,060,695 0.9912:1 81,891 0.03939:1 1991 2,226,208 2,183,800 98.1% 31,274 2,215,074 0.9950:1 88,809 0.03989:1 1992 2,406,707 2,360,410 98.1% 19,290 2,379,700 0.9888:1 109,305 0.04542:1 1993 2,453,972 2,400,802 97.8% 25,753 2,426,555 0.9888:1 123,285 0.05024:1 ' * The tax levy has been adjusted by the Homestead and Agricultural Aid (property tax replacement) which is a revenue from other agencies and has been incorporated into Table 6. 165 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL ASSESSMENT LEVIES AND COLLECTIONS Years 1984 Through 1993 (Unaudited) Table 5 * The parking ramp at 4025 Van Buren Street NE was assessed; however, it was not included in this figure. (A) The City bills the property owner directly when a special assessment installment becomes dues. If the installment becomes delinquent, it is certified to the County for inclusion on the following year's property tax statement and is shown as a delinquent collection. 166 X Deferred Special Assessments Current Current Collections Special Collected Balance Fiscal Assessments % of Delinquent Assessments During at End of Year Due Amount Levy Collections A) Delinquent Fiscal Period Fiscal Period 1984 $299,680 $186,803 62.3% $119,372 $154,154 $236,474 $857,906 1985 236,686 126,780 53.6% 140,515 132,031 92,257 640,691 1986 179,812 99,460 55.3% 118,938 110,886 223,656 697,945 1987 201,700 121,911 60.4% 86,741 108,729 236,510 616,994 1988 * 197,641 110,447 55.9% 50,534 149,795 143,565 1,149,826 1989 * 218,860 142,076 64.9% 95,361 97,030 219,588 637,341 1990 * 250,682 180,388 72.0% 74,581 109,928 309,544 591,415 1991 * 252,190 134,588 53.4% 39,016 77,005 210,029 565,432 1992 * 224,922 171,708 76.3% 55,385 73,962 54,141 416,229 1993 * 104,941 71,722 68.3% 59,468 59,185 139,047 364,055 * The parking ramp at 4025 Van Buren Street NE was assessed; however, it was not included in this figure. (A) The City bills the property owner directly when a special assessment installment becomes dues. If the installment becomes delinquent, it is certified to the County for inclusion on the following year's property tax statement and is shown as a delinquent collection. 166 X CITY OF COLUMBIA HEIGHTS, MINNESOTA GENERAL GOVERNMENTAL REVENUES BY SOURCE (A) Table 6 1 Years 1984 Through 1993 (Unaudited) Special Fiscal Assessments Licenses Inter- Charges for Fines and Miscellaneous Year Taxes (C) and Permits governmental Services (B) Forfeitures Interest (D) Total i1984 $1,807,252 $ - $215,942 $2,470,131 $706,135 $51,009 $222,454 $93,363 $5,566,286 1985 2,352,593 - 139,470 2,625,357 289,116 104,741 265,318 81,461 5,858,056 1986 2,275,432 - 187,809 2,978,923 351,897 108,158 369,277 80,057 6,351,553 1987 2,733,934 - 131,351 2,972,407 408,062 123,813 533,564 560,378 7,463,509 1988 2,924,601 - 163,384 3,738,312 516,018 112,254 596,581 1,179,042 9,230,192 1989 2,839,936 736,662 142,365 4,014,920 611,516 128,188 1,229,806 453,820 10,157,213 t1990 3,215,975 463,410 147,587 4,096,113 661,116 123,505 1,039,625 385,013 10,132,344 1991 3,474,483 277,171 164,945 3,249,669 424,546 116,386 395,986 238,615 8,341,801 1992 3,496,720 147,180 125,275 3,504,973 442,636 104,673 562,475 595,015 8,978,947 1993 3,593,244 130,454 135,545 3,782,752 464,887 89,464 665,190 136,976 8,998,512 Notes: (A) Includes General, Special Revenue, and Debt Service Fund Types. (B) The year 1984 includes Refuse Collection and Disposal. (C) Beginning in 1987, the Special Assessment Fund Type was eliminated and special assessment collections were recorded in the Debt Service Fund Type. (D) From 1988 to 1990, the Housing and Redevelopment Authority is blended as a component unit of the City. Beginning in t1991, the Housing and Redevelopment Authority is discretely presented as a separate column. t 167 CITY OF COLUMBIA HEIGHTS, MINNESOTA GENERAL GOVERNMENTAL EXPENDITURES BY FUNCTION (A) Years 1984 Through 1993 (Unaudited) Table 7 Notes: (A) Includes General, Special Revenue, and Debt Service Fund Types. (B) The year 1984 includes Refuse Collection and Disposal. (C) From 1988 to 1990, the Housing and Redevelopment Authority is blended as a component unit of the City. Beginning in 1991, the Housing and Redevelopment Authority is discretely presented as a separate column. W Highways Parks Fiscal General Public and Sanitation and Debt Year Government Safety Streets (B) Recreation Library Service Other Total 1984 $563,717 $1,654,871 $564,101 $531,174 $753,430 $212,379 $1,307,737 $90,463 $5,677,872 1985 850,356 1,799,231 627,733 81,415 788,111 221,821 786,312 291,916 5,446,895 1986 885,343 1,885,654 560,003 75,854 865,369 263,650 1,205,856 208,951 5,950,680 1987 919,991 1,915,895 632,746 80,285 1,001,069 261,583 1,807,407 405,451 7,024,427 1988 1,034,970 2,218,196 563,432 90,760 1,206281 353,241 1,754,031 1,999,737 9,220,648 1989 1,114,211 2,303,702 785,818 122,304 1,400,850 333,188 2,399,342 1,108,743 9,568,158 1990 1,429,627 2,551,543 762,642 184,627 1,514,853 368,363 2,469,400 1,298,528 10,579,583 1991 1,285,382 2,538,215 891,133 108,108 954,236 390,251 3,950,683 352,510 10,470,518 1992 1,356,795 2,563,788 819,300 176,216 1,044,021 383,933 2,272,802 397,879 9,014,734 1993 1,441,603 2,679,272 806,990 149,054 1,040,459 374,625 2,963,693 499,702 9,955,398 Notes: (A) Includes General, Special Revenue, and Debt Service Fund Types. (B) The year 1984 includes Refuse Collection and Disposal. (C) From 1988 to 1990, the Housing and Redevelopment Authority is blended as a component unit of the City. Beginning in 1991, the Housing and Redevelopment Authority is discretely presented as a separate column. W CITY OF COLUMBIA HEIGHTS, MINNESOTA 1 PRINCIPAL CITY OFFICIALS Year Ended December 31, 1993 Name I Mayor and Council Donald J. Murzyn, Jr. Joseph Sturdevant Gary L. Peterson Bruce G. Nawrocki Sean T. Clerkin Robert W. Ruettimann 1 Donald Jolly Administration Patrick Hentges Linda Magee William Elrite June Johnston Phil Suckerman Gregg Woods Mark Winson Dave Mawhorter Charles Kewatt Evelyn Nygaard Lauren McClanahan Mark Casey M. Rebecca Loader Table 8 Official Title Mayor Mayor - Elect Councilmember Councilmember Councilmember Councilmember Councilmember - elect City Manager Assistant to City Manager City Clerk- Treasurer, Finance Director Assistant Finance Director Liquor Operations Manager City Attorney Public Works Director, City Engineer Chief of Police Chief of Fire Building Inspector Superintendent of Public Works Recreation Services Director Librarian 169 CITY OF COLUMBIA HEIGHTS, MINNESOTA MISCELLANEOUS STATISTICS December 31, 1993 (Unaudited) Table 9 Page 1 of 2 Date of Incorporation March 14,1898 Date of Adoption of City Charter July 21, 1921 Form of Government Council- Manager Fiscal Year Begins January 1 Area of City 3.52 Square Miles Miles of Streets and Alleys 8,916,756 Trunk Highways 3.0 County 6.2 City Streets 61.8 Alleys 18.9 Miles of Sewers 3,292,353 Storm Sewers 33.6 Sanitary Sewers 59.0 Watermain Miles 66.1 Building Permits Issued 1984 525 1985 508 1986 513 1987 556 1988 535 1989 473 1990 486 1991 484 1992 515 1993 505 Estimated Construction Cost for Issued Permits 1984 $12,059,779 1985 4,938,226 1986 13,269,300 1987 4,215,085 1988 8,916,756 1989 5,180,247 1990 5,198200 1991 4,894,021 1992 2,373,433 1993 3,292,353 170 1 CITY OF COLUMBIA HEIGHTS, MINNESOTA MISCELLANEOUS STATISTICS Table 9 December 31, 1993 Page 2 of 2 (Unaudited) Fire Protection Number of Stations 1 ' Number of Employees: Full-time 8 Volunteer 23 Police Protection Number of Stations 1 Number of Employees 25 Parks City Parks 13 Playgrounds 11 County Park 1 Schools Senior High 1 Junior High 1 Elementary 3 Parochial Elementary 1 Employees (as of December 31, 1993) Regular t 111 Part -time and Temporary 318 429 Elections Registered voters - Last City General Election 11,698 Number of Votes Cast - Last City General Election 4,115 Percentage of Registered Voters Voting 35.18% Population 1900 123 1920 2,968 1930 5,613 1940 6,053 1950 8,175 1960 17,533 1970 23,997 1975 (Mid- Decade Census) 23,316 1980 20,029 1985 19,540 1990 (Census) 18,910 171 CITY OF COLUMBIA HEIGHTS, MINNESOTA PRINCIPAL TAXPAYERS December 31, 1993 (Unaudited) Taxpayer Type of Business Kraus - Anderson, Inc. Construction Zaidan Holdings, Inc. Office Building State Bank of Aurora Office Building Columbia Park Properties Medical Building Maylan Construction Company Retail (K -Mart) Medtronics, Inc. Medical Manufacturing Consolidated Realty of Minneapolis Apartments Northern States Power Utility Minnegasco Utility Lynde Investment Apartments Total Principal Taxpayers 172 Tax Capacity Value $230,062 223,900 186,300 158,479 156,610 154,951 112,751 110,060 97,117 78,398 $1,508,628 Source of Data: Anoka County Auditor's Office for collectible 1992 tax levies. (1993 information was not available) % of Total City Tax Capacity Value 2.40% 2.30% 1.90% 1.60% 1.60% 1.60% 1.20% 1.10% 1.00% 0.80% 15.50% Table 10 CITY OF COLUMBIA HEIGHTS, MINNESOTA COMPUTATION OF LEGAL DEBT MARGIN December 31, 1993 (Unaudited) Market Value Debt Limit Percentage (Note A) Debt limit Amount of Debt applicable to debt limit Total bonded debt fLess: Tax increment bonds (Note B) Special assessment bonds Total amount of debt applicable to debt limit Legal debt margin I Note A Table 11 1993/1994 1992/1993 $542,287,800 $542,920,400 2% 2% 10,845,756 10,858,408 17,209,721 19,059,721 17,209,721 18,149,721 0 910,000 0 0 $10,845,756 $10,858,408 M.S.A. Section 475.53 (Limit on Debt) Subdivision 1. Generally, except as otherwise provided in Sections 475.51 to 475.75, "no municipality, except a school district or a city of the fast class, shall incur or be subject to a net debt in excess of 2% of the taxable market 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 municipality issuing them, if the municipality is entitled to reimbursement in whole or in part from the proceeds of the special assessments. 2. Warrants or orders having no definite or fixed maturity. 3. Obligations payable wholly from the income from revenue producing conveniences. 4. Obligations issued to create or maintain a Permanent Improvement Revolving Fund. 5. Obligations issued for the acquisition and betterment of public water works 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. Not applicable. 7. Amount of all money and face value of all securities held as a Debt Service Fund for the extinguishment of obligations other than those deductible under this subdivision. 8. All other obligations which under the provisions of law authorizing their issuance are not to be included in computing the net debt of the municipality. i CITY OF COLUMBIA HEIGHTS, MINNESOTA COMPUTATION OF DIRECT AND OVERLAPPING DEBT (1) Table 12 December 31, 1993 (Unaudited) l Amount Applicable to Net Percentage City of General Applicable Columbia Heights Obligation Debt to City Share of Debt Direct debt: City of Columbia Heights $17,209,721 100.090 $17,209,721 ' Overlapping debt: (1) Anoka County 47,645,712 7.190 3,382,846 Metropolitan Council 40,840,000 0.690 245,040 Regional Transit District 44,400,000 0.6% 266,400 Totals $150,095,433 $21,104,007 (1) Using 1992 figures, 1993 figures were not available. S t � t 774 CITY OF COLUMBIA HEIGHTS, MINNESOTA . PROPERTY VALUE, CONSTRUCTION AND BANK DEPOSITS Years 1984 Through 1993 (Unaudited) Table 13 Property Value (1) Construction Fiscal Number Bank I Year Real Personal Total of Units Value Deposits (2) 1984 $105,913,390 $1,426,869 $107,340,259 525 $12,059,779 $- 1985 108,671,288 1,426,869 110,098,157 508 4,938,226 - 1986 113,721,411 1,500,988 115,222,399 513 13,269,300 - 1987 114,767,361 1,547,299 116,314,660 556 4,215,085 1988 116,314,660 1,679,868 117,994,528 535 8,916,756 1989 14,532,465 208,985 14,741,450 473 5,180,247 7,018,831 (3) 1990 10,022,891 212,505 10,235,396 486 5,198,200 10,311,528 1991 9,901,542 210,051 10,111,593 484 4,894,021 9,923,902 1992 9,503,314 207,255 9,710,569 515 2,373,433 10,155,837 1993 9,226,574 207,309 9,433,883 505 3,292,353 16,636,883 (4) * Amount expressed in thousands. (1) Estimated assessed (1984 -1987) and tax capacity (1988 -1993) values from Table 1. (2) Source: Federal Banking Directory ' Note: Deposits listed are for Northeast State Bank, Marquette Bank Minneapolis, First Banks, Norwest Bank, and First Community Credit Union (3) Figures for First Community Credit Union are not included for 1989. (4) 1992 amounts were used for First Banks and Norwest because 1993 amounts were not available. CH 176 CITY OF COLUMBIA HEIGHTS, MINNESOTA SINGLE AUDIT AND OTHER REQUIRED REPORTS 177 CH 178 CITY OF COLUMBIA HEIGHTS, MINNESOTA CERTIFIED PUBLIC ACCOUNTANTS Independent Auditor's Report on Supplementary Information - Schedule of Federal Financial Assistance To the Honorable Mayor and Members of the City Council Columbia Heights, Minnesota We have audited the general purpose financial statements of the City of Columbia Heights, Minnesota, for the year ended December 31, 1993, and have issued our report thereon dated March 15, 1994. These general purpose financial statements are the responsibility of the City of Columbia Heights, Minnesota's, management. Our responsibility is to express an opinion on these general purpose financial statements based on our audit. We conducted our audit in accordance with generally accepted auditing standards and Government Auditing Standards, issued by the Comptroller General of the United States. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the general purpose financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall financial statement presentation. We believe that our audit provides a reasonable basis for our opinion. Our audit was made for the purpose of forming an opinion on the general purpose financial statements taken as a whole.. The accompanying schedule of federal financial assistance is presented for purposes of additional analysis and is not a required part of the general purpose financial statements. The information in that schedule has been subjected to the auditing procedures applied in the audit of the general purpose financial statements and, in our opinion, is fairly presented in all material respects in relation to the general purpose financial statements taken as a whole. TAUTGES, REDPATH & CO., LTD. Certified Public Accountants a March 15, 1994 ' 179 4810 White Bear Parkway o White Bear Lake, Minnesota 55110 o 612/426 -7000 o FAX /426 -5004 o Member of HLB International CH 180 CITY OF COLUMBIA HEIGHTS, MINNESOTA CITY OF COLUMBIA HEIGHTS, MINNESOTA SCHEDULE OF FEDERAL FINANCIAL ASSISTANCE For The Year Ended December 31, 1993 Federal Funding Source/ Federal 1993 Activity Pass Through Agency / CFDA Revenue Program Title Number Recognized Expenditures City of Columbia Heights: U.S. Department of Justice: Passed- through State of Minnesota: Police Grant 16.579 $40,000 $40,000 Federal Emergency Management Agency: Passed - through Anoka County: Emergency Management Assistance Grant 83.503 4,909 4,909 U.S. Department of Transportation: Passed - through Anoka County: State and Community Highway Safety (ATAC) Grant 20.600 4,325 4,325 U.S. Small Business Administration: Passed - through State of Minnesota: Tree Planting Grant 59.009 5,000 5,000 Housing and Redevelopment Authority of Columbia Heights: U.S. Department of Housing and Urban Development: Passed - through Anoka County: Community Development Block Grant - Entitlement Grant 14.218 184,447 184,447 Home Investors Partnerships Program 14.239 16,323 16,323 Passed - through Metropolitan Council: Section 8 Housing Assistance Payments Program for Administrative Services 14.156 40,157 40,157 Total Federal Assistance $295,161 $295,161 181 eFl IW I. CITY OF COLUMBIA HEIGHTS, MINNESOTA TA UTGES, REDPA PH & CO., LTD. CERTIFIED PUBLIC ACCOUNTANTS Independent Auditor's Report on Compliance With General Requirements Applicable to Federal Financial Assistance Programs To the Honorable Mayor and Members of the City Council Columbia Heights, Minnesota We have audited the general purpose financial statements of the City of Columbia Heights, Minnesota as of and for the year ended December 31, 1993, and have issued our report thereon dated March 15, 1994. We have applied procedures to test the City of Columbia Heights, Minnesota's compliance with the following requirements applicable to its federal financial assistance programs, which are identified in the schedule of Federal Financial Assistance, for the year ended December 31, 1993: Political Activity Federal Financial Reports Davis -Bacon Act Allowable Costs/Cost Principles Civil Rights Drug -free Work Place Cash Management Administrative Requirements Relocation Assistance and Real Property Acquisitions Our procedures were limited to the applicable procedures described in the Office of Management and Budget's Compliance Supplement for Single Audits of State and Local Governments. Our procedures were substantially less in scope than an audit, the objective of which is the expression of an opinion on the City of Columbia Heights, Minnesota's compliance with the requirements listed in the preceding paragraph. Accordingly, we do not express such an opinion. With respect to the items tested, the results of those procedures disclosed no material instances of noncompliance with the requirements listed in the second paragraph of this report. With respect to items not tested, nothing came to our attention that caused us to believe that the City of Columbia Heights, Minnesota had not complied, in all material respects, with those requirements. This report is intended for the information of the City of Columbia Heights, Minnesota's management, the federal cognizant audit agency and other federal agencies. However, this report is a matter of public record and its distribution is not limited. TAUTGES, REDPATH & CO., LTD. ,. Certified Public Accountants March 15, 1994 1 183 4810 White Bear Parkway o White Bear Lake, Minnesota 55110 o 612/426 -7000 o FAX /426 -5004 o Member of HLB International CH ., CITY OF COLUMBIA HEIGHTS, MINNESOTA TA UTGES, REDPA TH & CO. L T®. CERTIFIED PUBLIC ACCOUNTANTS Independent Auditor's Report on Compliance With Nonmajor Federal Financial Assistance Progl in To the Honorable Mayor and Members of the City Council Columbia Heights, Minnesota We have audited the general purpose financial statements of the City of Columbia Heights, Minnesota as of and for the year ended December 31, 1993, and have issued our report thereon dated March 15, 1994. tIn connection with our audit of the general purpose financial statements of the City of Columbia Heights, Minnesota, and with our consideration of the City of Columbia Heights, Minnesota's control structure used to administer federal financial assistance programs, as required by Office of Management and Budget Circular A -128, Audits of State and Local Governments, we selected -- certain transactions applicable to certain nonmajor federal financial assistance programs for the year ended December 31, 1993. As required by OMB Circular A -128, we have performed auditing procedures to test compliance with the requirements governing the types of services allowed or unallowed, eligibility, special reporting requirements, and special tests and provisions that are applicable to those transactions. Our procedures were substantially less in scope than an audit, the objective of which is the expression of an opinion on the City of Columbia Heights, Minnesota's compliance with these requirements. Accordingly, we do not express such an opinion. With respect to the items tested, the results of those procedures disclosed no material instances of noncompliance with the requirements listed in the preceding paragraph. With respect to items not tested, nothing came to our attention that caused us to believe that the City of Columbia Heights, Minnesota had not complied, in all material respects, with those requirements. This report is intended for the information of the City of Columbia Heights, Minnesota's management, the federal cognizant audit agency and other federal agencies. However, this report is a matter of public record and its distribution is not limited TAUTGES, REDPATH & CO., LTD. Certified Public Accountants March 15, 1994 1 185 4810 White Bear Parkway o White Bear Lake, Minnesota 55110 o 612/426 -7000 o FAX /426 -5004 o Member of HLB International CH 186 CITY OF COLUMBIA HEIGHTS, MDRIMOTA t TA DTGES, REDPA TH & CO., L TD. CERTIFIED PUBLIC ACCOUNTANTS III IRMIMME03 To the Honorable Mayor and Members of the City Council Columbia Heights, Minnesota We have audited the general purpose financial statements of the City of Columbia Heights, Minnesota, as of and for the year ended December 31, 1993, and have issued our report thereon dated March 15, 1994. We conducted our audit in accordance with generally accepted auditing standards and Government Auditing Standards, issued by the Comptroller General of the United States. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. In planning and performing our audit of the general purpose financial statements of the City of Columbia Heights, Minnesota, for the year ended December 31, 1993, we considered its internal control structure in order to determine our auditing procedures for the purpose of expressing our opinion on the general purpose financial statements and not to provide assurance on the internal control structure. The management of the City of Columbia Heights, Minnesota, is responsible for establishing and maintaining an internal control structure. In fulfilling this responsibility, estimates and judgments by management are required to assess the expected benefits and related costs of internal control structure policies and procedures. The objectives of an internal control structure are to provide management with reasonable, but not absolute, assurance that assets are safeguarded against loss from unauthorized use or disposition, and that transactions are executed in accordance with management's authorization and recorded properly to permit the preparation of general purpose financial statements in accordance with generally accepted accounting principles. Because of inherent limitations in any internal control structure, errors or irregularities may nevertheless occur and not be detected Also, projections of any evaluation of the structure to future periods is subject to the risk that procedures may become inadequate because of changes in conditions or that the effectiveness of the design and operation of policies and procedures may deteriorate. For the purpose of this report, we have classified the significant internal control structure policies and procedures in the following categories; receivables, cash receipts, billings, accounts payable, cash disbursements and payroll. For all of the internal control structure categories listed above, we obtained an understanding of the design of relevant policies and procedures and whether they have been placed in operation, and we assessed control risk. 187 4810 White Bear Parkway o White Bear Lake, Minnesota 55110 0 612/426 -7000 o FAX /426 -5004 o Member of HLB International (D CITY OF COLUMBIA HEIGHTS, MINNESOTA .. We noted certain matters involving the internal control structure and its operation that we consider to be reportable conditions under standards established by the American Institute of Certified Public Accountants. Reportable conditions involve matters coming to our attention relating to significant deficiencies in the design or operation of the internal control that, in our judgment, could adversely affect the entity's ability to record, process, summarize, and report financial data consistent with the assertions of management in the general purpose financial statements. Certain general ledger accounts of the Housing and Redevelopment Authority were not reconciled on a timely basis. These accounts included: loans receivable, loan payments, escrow deposits, tenant receivable and fixed assets. A material weakness is a reportable condition in which the design or operation of the specific internal control structure elements does not reduce to a relatively low level the risk that errors or irregularities in amounts that would be material in relation to the general purpose financial statements being audited may occur and not be detected within a timely period by employees in the normal course of performing their assigned functions. Our consideration of the internal control structure would not necessarily disclose all matters in the internal control structure that might be reportable conditions and, accordingly, would not necessarily disclose all reportable conditions that are also considered to be material weaknesses as defined above. However, we believe that the reportable condition described above is a material weakness. Recommendations regarding the above comments as well as other matters we noted involving the internal control structure and its operation, have been reported to the management of the City of Columbia Heights, Minnesota in a separate report dated May 2, 1994. This report is intended for the information of the City of Columbia Heights, Minnesota's management, the federal cognizant audit agency and other federal agencies. This restriction is not intended to limit the distribution of this report, which is a matter of public record. TAUTGES, REDPATH & CO., LTD. Certified Public Accountants March 15, 1994 Im CITY OF COLUMBIA HEIGHTS, MINNESOTA 190 TAU TGES, REDP J TH & CO., LTD. CERTIFIED PUBLIC ACCOUNTANTS To the Honorable Mayor and Members of the City Council Columbia Heights, Minnesota We have audited the general purpose financial statements of the City of Columbia Heights, Minnesota, as of and for the year ended December 31, 1993, and have issued our report thereon dated March 15, 1994. 19 We conducted our audit in accordance with generally accepted auditing standards; Govern nwnt Auditing Standards, issued by the Comptroller General of the United States; .and Office of Management and Budget (OMB) Circular A -128, Audits of State and Local Governments. Those standards and OMB Circular A -128 require that we plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. In planning and performing our audit for the year ended December 31, 1993, we considered the City's internal control structure in order to determine our auditing procedures for the purpose of expressing our opinions on the City's general purpose financial statements and to report on the internal control structure with OMB Circular A -128. This report addresses our consideration of internal control structure policies and procedures relevant to compliance with requirements applicable to federal financial assistance programs. We have addressed policies and procedures relevant to our audit of the general purpose financial statements in a separate report dated March 15, 1994. The management of the City of Columbia Heights, Minnesota is responsible for establishing and maintaining an internal control structure. In fulfilling this responsibility, estimates and judgments by management are required to assess the expected benefits and related costs of internal control structure policies and procedures. The objectives of an internal control structure are to provide management with reasonable, but not absolute, assurance that assets are safeguarded against loss from unauthorized use or disposition, that transactions are executed in accordance with management's authorization and recorded properly to permit the preparation of general purpose financial statements in accordance with generally accepted accounting principles, and that federal financial assistance programs are managed in compliance with applicable laws and regulations. Because of inherent limitations in any internal control structure, errors, irregularities, or instances of noncompliance may nevertheless occur and not be detected Also, projection of any evaluation of the structure to future periods is subject to the risk that procedures may become inadequate because of changes in conditions or that the effectiveness of the design and operation of policies and procedures may deteriorate. 191 4810 White Bear Parkway o White Bear Lake, Minnesota 55110 o 612/426 -7000 o FAX /426 -5004 o Member of HLB International CH 192 CITY OF COLUMBIA HEIGHTS, MINNESOTA i For the se of this report, we have classified the significant internal control structure policies purpose Po 1� Po and procedures used in administering federal financial assistance programs in the following categories: General Requirements: Political Activity Davis -Bacon Act Civil Rights Cash Management Relocation Assistance and Real Property Acquisition Federal Financial Reports Allowable Costs/Cost Principles Drug -free Work Place Administrative Requirements Specific Requirements: Allowability of Service Eligibility Special Reporting Requirements Special Tests and Provisions Wr For all of the internal control structure categories listed above, we obtained an understanding of the design of relevant policies and procedures and determined whether they have been placed in operation, and we assessed control risk. During the year ended December 31, 1993, the City of Columbia Heights, Minnesota had no major federal financial assistance programs and expended 62% of its total federal financial assistance under the following nonmajor federal financial assistance program; Community Development Block Grant. We performed tests of controls, as required by OMB Circular A -128, to evaluate the effectiveness of the design and operation of internal control structure policies and procedures that we have considered relevant to preventing or detecting material noncompliance with specific requirements and general requirements applicable to the aforementioned nonmajor programs. Our procedures were less in scope than would be necessary to render an opinion on these internal control structure policies and procedures. Accordingly, we do not express such an opinion. We noted certain matters involving the internal control structure and its operation that we consider to be reportable conditions under standards established by the American Institute of Certified Public Accountants. Reportable conditions involve matters coming to our attention relating to significant deficiencies in the design or operation of the internal control structure that, in our judgment, could adversely affect the City of Columbia Heights, Minnesota's, ability to administer federal financial assistance programs in accordance with applicable laws and regulations. Certain general ledger accounts of the Housing and Redevelopment Authority were not reconciled on a timely basis. These accounts included: loans receivable, loan payments, escrow deposits, tenant receivable and fixed assets. A material weakness is a reportable condition in which the design or operation of one or more of the internal control structure elements does not reduce to a relatively low level the risk that noncompliance with laws and regulations that would be material to a federal financial assistance program may occur and not be detected within a timely period by employees in the normal course of performing their assigned functions. 193 CH 194 CITY OF COLUMBIA HEIGHTS, MINNESOTA Our consideration of the internal control structure policies and procedures used in administering federal financial assistance would not necessarily disclose all matters in the internal control structure that might be reportable conditions and, accordingly would not necessarily disclose all reportable conditions that are considered to be material weaknesses as defined above. However, we believe that the reportable condition described above is a material weakness. Recommendations regarding the above comments as well as other matters we noted involving the internal control structure and its operation, have been reported to the management of the City of Columbia Heights, Minnesota in a separate report dated May 2, 1994. This report is intended for the information of the City of Columbia Heights, Minnesota's management, the federal cognizant audit agency and other federal agencies. This restriction is not intended to limit the distribution of this report, which is a matter of public record. TAUTGES, REDPATH & CO., LTD. Certified Public Accountants March 15, 1994 195 r I (D 4k CITY OF COLUMBIA HEIGHTS, MINNESOTA I r 196 1 TAIUTGLSSy W!S®PSI 11111 CO., LTD. CERTIFIED PUBLIC ACCOUNTANTS l e_l WPM III 6WMTjTR;Wv • �• 1 To the Honorable Mayor ■ and Members of the City Council Columbia Heights, Minnesota ,+ We have audited the general purpose financial statements of the City of Columbia Heights, Minnesota, for the year ended December 31, 1993, and have issued our report thereon dated March 15, 1994. We conducted our audit in accordance with generally accepted auditing standards and Government Auditing Standards, issued by the Comptroller General of the United States. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. Compliance with laws, regulations, contracts and grants applicable to the City of Columbia Heights, Minnesota is the responsibility of the City's management. As part of obtaining reasonable assurance about whether the general purpose financial statements are free of material misstatement, we performed tests of the City's compliance with certain provisions of laws, regulations, contracts and grants. However, our objective was not to provide an opinion on overall compliance with such provisions. Accordingly, we do not express such an opinion. The results of our tests indicate that, with respect to the items tested, the City of Columbia Heights, Minnesota complied, in all material respects, with the provisions referred to in the preceding paragraph. With respect to the items not tested, nothing came to our attention that caused us to believe that the City had not complied, in all material respects, with those provisions. This report is intended solely for the use of the City of Columbia Heights, Minnesota's management, the federal cognizant audit agency, and other federal agencies and should not be used for any other purpose. This restriction is not intended to limit the distribution of this report which is a matter of public record. Respectfully submitted, TAUTGES, REDPATH & CO., LTD. Certified Public Accountants March 15, 1994 1 197 4810 White Bear Parkway o White Bear Lake, Minnesota 55110 o 612/426 -7000 o FAX /426 -5004 o Member of HLB International CITY OF COLUMBIA HEIGHTS, MINNESOTA 198 t [I 'I