Loading...
HomeMy WebLinkAbout2012 CAFRCITY OF COLUMBIA HEIGHTS STATE OF MINNESOTA PREPARED BY: FINANCE DEPARTMENT COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE YEAR ENDED DECEMBER 31, 2012 - This page intentionally left blank - CITY OF COLUMBIA HEIGHTS, MINNESOTA TABLE OF CONTENTS Page ReferenceNo. I. INTRODUCTORY SECTION Principal City Officials 3 Organizational Chart 4 Letter of Transmittal 5 Certificate of Achievement for Excellence in Financial Reporting9 II. FINANCIAL SECTION Independent Auditor's Report 13 Management's Discussion and Analysis 17 Basic Financial Statements: Government-Wide Financial Statements: Statement of Net PositionStatement 132 Statement of ActivitiesStatement 234 Fund Financial Statements: Balance Sheet - Governmental FundsStatement 336 Statement of Revenues, Expenditures and Changes in Fund Balance - Governmental FundsStatement 438 Reconciliation of the Statement of Revenues, Expenditures and Changes in Fund Balances of Governmental Funds to the Statement of ActivitiesStatement 541 Statement of Net Position - Proprietary FundsStatement 642 Statement of Revenues, Expenses and Changes in Fund Net Position - Proprietary FundsStatement 744 Statement of Cash Flows - Proprietary FundsStatement 846 Statement of Fiduciary Net Position - Fiduciary FundsStatement 950 Notes to Financial Statements 51 Required Supplementary Information: Budgetary Comparison Schedule - General FundStatement 1082 Schedule of Funding Progress for the Retiree Health PlanStatement 1184 Budgetary Comparison Schedule - Note to RSI85 CITY OF COLUMBIA HEIGHTS, MINNESOTA TABLE OF CONTENTS Page ReferenceNo. Combining and Individual Fund Statements and Schedules: Combining Balance Sheet - Nonmajor Governmental FundsStatement 1290 Combining Statement of Revenues, Expenditures and Changes in Fund Balance - Nonmajor Governmental FundsStatement 1391 Subcombining Balance Sheet - Nonmajor Special Revenue FundsStatement 1496 Subcombining Statement of Revenues, Expenditures and Changes in Fund Balance - Nonmajor Special Revenue FundsStatement 1598 Special Revenue Funds: Schedules of Revenues, Expenditures and Changes in Fund Balance: Budget and Actual - Cable Television FundStatement 16100 Actual - Police Forfeiture FundStatement 17101 Actual - Police Grants FundStatement 18102 Budget and Actual - Library FundStatement 19103 Actual - After School Programs FundStatement 20104 Actual - Recreation Contributed Projects FundStatement 21105 Actual - Contributed Projects - Other FundStatement 22106 Actual - Special Projects FundStatement 23107 Budget and Actual - Community Development FundStatement 24108 Actual - Anoka County Comm Dev Programs FundStatement 25109 Economic Development Authority (Component Unit): Budgetary Comparison Schedule - Administration FundStatement 26110 Housing and Redevelopment Authority (Component Unit): Combining Balance SheetStatement 27111 Combining Statement of Revenues, Expenditures and Changes in Fund BalanceStatement 28112 Schedules of Revenues, Expenditures and Changes in Fund Balance: Budget and Actual - Parkview Villa North FundStatement 29113 Budget and Actual - Parkview Villa South FundStatement 30114 CITY OF COLUMBIA HEIGHTS, MINNESOTA TABLE OF CONTENTS Page ReferenceNo. Subcombining Balance Sheet - Nonmajor Debt Service Funds Statement 31116 Subcombining Statement of Revenues, Expenditures and Changes in Fund Balance - Nonmajor Debt Service Funds Statement 32118 Subcombining Balance Sheet - Nonmajor Capital Project Funds Statement 33123 Subcombining Statement of Revenues, Expenditures and Changes in Fund Balance - Nonmajor Capital Project Funds Statement 34124 Enterprise Funds: Water Utility Fund: Subcombining Schedule of Net Position Statement 35126 Subcombining Schedule of Revenues, Expenses and Changes in Fund Net Position Statement 36127 Subcombining Schedule of Cash Flows Statement 37128 Sewer Utility Fund: Subcombining Schedule of Net Position Statement 38129 Subcombining Schedule of Revenues, Expenses and Changes in Fund Net Position Statement 39130 Subcombining Schedule of Cash Flows Statement 40131 Refuse Utility Fund: Subcombining Schedule of Net Position Statement 41132 Subcombining Schedule of Revenues, Expenses and Changes in Fund Net Position Statement 42133 Subcombining Schedule of Cash Flows Statement 43134 Storm Sewer Utility Fund: Subcombining Schedule of Net Position Statement 44135 Subcombining Schedule of Revenues, Expenses and Changes in Fund Net Position Statement 45136 Subcombining Schedule of Cash Flows Statement 46137 Liquor Fund: Subcombining Schedule of Net Position Statement 47139 Subcombining Schedule of Revenues, Expenses and Changes in Fund Net Position Statement 48140 Subcombining Schedule of Cash Flows Statement 49142 Internal Service Funds: Combining Statement of Net Position Statement 50146 Combining Statement of Revenues, Expenses and Changes in Fund Net Position Statement 51147 Combining Statement of Cash Flows Statement 52148 CITY OF COLUMBIA HEIGHTS, MINNESOTA TABLE OF CONTENTS Page ReferenceNo. Central Garage Fund: Subcombining Schedule of Net Position Statement 53149 Subcombining Schedule of Revenues, Expenses and Changes in Fund Net PositionStatement 54150 Subcombining Schedule of Cash FlowsStatement 55151 Information Systems Fund: Subcombining Schedule of Net Position Statement 56152 Subcombining Schedule of Revenues, Expenses and Changes in Fund Net PositionStatement 57153 Subcombining Schedule of Cash FlowsStatement 58154 Insurance Fund: Subcombining Schedule of Net Position Statement 59155 Subcombining Schedule of Revenues, Expenses and Changes in Fund Net PositionStatement 60156 Subcombining Schedule of Cash FlowsStatement 61157 Compensated Absences Fund: Subcombining Schedule of Net Position Statement 62158 Subcombining Schedule of Revenues, Expenses and Changes in Fund Net PositionStatement 63159 Subcombining Schedule of Cash FlowsStatement 64160 Combining Statement of Changes in Assets and Liabilities - Agency FundsStatement 65162 III. STATISTICAL SECTION (UNAUDITED) Financial Trends: Net Position by Component Table 1 166 Changes in Net Position Table 2 168 Fund Balances - Governmental Funds Table 3 172 Changes in Fund Balances - Governmental Funds Table 4 174 Revenue Capacity: Tax Capacity Value and Estimated Market Value of All Taxable Property Table 5 178 Direct and Overlapping Property Tax Rates Table 6 179 Principal Property Taxpayers Table 7 181 Property Tax Levies and Collections Table 8 182 CITY OF COLUMBIA HEIGHTS, MINNESOTA TABLE OF CONTENTS Page ReferenceNo. Debt Capacity: Ratios of Outstanding Debt by TypeTable 9184 Ratios of Outstanding Net General Bonded Debt by TypeTable 10186 Direct and Overlapping Governmental Activities DebtTable 11188 Legal Debt Margin InformationTable 12189 Pledged Revenue Coverage Non-Obligation DebtTable 13190 Demographic and Economic: Demographic and Economic StatisticsTable 14191 Principal EmployersTable 15193 Operating Information: City Government Employees by Function/ProgramTable 16194 Operating Indicators by Function/ProgramTable 17196 Capital Asset Statistics by Function/ProgramTable 18198 IV. OTHER REQUIRED REPORTS SECTION Minnesota Legal Compliance Report 203 Independent Auditor's Report on Internal Control over Financial Reporting and on Compliance and Other Matters Based on an Audit of Financial Statements Performed in Accordance with Government Auditing Standards 205 Report on Supplementary Information - Financial Data Schedule207 U.S. Department of Housing and Urban Development: Financial Data Schedule 209 Financial Data Schedule - Statement and Certification of Actual Modernization Costs211 - This page intentionally left blank - I. INTRODUCTORY SECTION 1 - This page intentionally left blank - 2 CITY OF COLUMBIA HEIGHTS, MINNESOTA PRINCIPAL CITY OFFICIALS December 31, 2012 Name Official Title Mayor and Council: Gary L. PetersonMayor Tammera Ericson DiehmCouncilmember Donna SchmittCouncilmember Bruce NawrockiCouncilmember Robert A. WilliamsCouncilmember Administration: Walter Fehst City Manager Linda Magee Assistant to City Manager Joseph Kloiber Treasurer, Finance Director Jim Hoeft City Attorney Kevin Hansen Public Works Director, City Engineer Scott Nadeau Chief of Police Gary Gorman Chief of Fire Renee Dougherty Librarian Scott Clark Community Development Director Keith Windschitl Recreation Services Director Larry Scott Liquor Operations Manager Lauren McClanahan Superintendent of Public Works 3 &LW\RI&ROXPELD+HLJKWV 2UJDQL]DWLRQDO&KDUW  0D\RU *DU\/3HWHUVRQ &RXQFLOPHPEHUV 7DPPHUD'LHKP %UXFH1DZURFNL 'RQQD6FKPLWW 5REHUW:LOOLDPV &LW\0DQDJHU :DOWHU)HKVW &RPPLVVLRQV %RDUGV &KDUWHU ('$ +5$ 7UDIILF 7HOHFRPPXQLFDWLRQV 3ODQQLQJ =RQLQJ 3DUN 5HFUHDWLRQ /LEUDU\$'0,1,675$7,21 $VVLVWDQWWRWKH&LW\0DQDJHU +XPDQ5HVRXUFHV'LUHFWRU/LQGD0DJHH &LW\&OHUN $GPLQLVWUDWLYH$VVLVWDQW±+XPDQ5HVRXUFHV ,PDJLQJ7HFKQLFLDQ 37 )DFLOLW\0DLQWHQDQFH6XSHUYLVRU &XVWRGLDQ, 37 &XVWRGLDQ,, 37 32/,&( $GPLQLVWHUHGE\0D\RU 3ROLFH&KLHI6FRWW1DGHDX 2IILFH6XSHUYLVRU 3ROLFH&DSWDLQ 6HUJHDQWV  &RUSRUDOV  3DWURO2IILFHUV  &RPPXQLW\6HUYLFH2IILFHUV )7  37 5HVHUYHV 3ROLFH,66SHFLDOLVW 6HFUHWDU\,,$  &OHUN7\SLVW ),5((0(5*(1&<0$1$*(0(17 )LUH&KLHI*DU\*RUPDQ $VVLVWDQW)LUH&KLHI )LUH&DSWDLQV  6HFUHWDU\,, 37 &OHUN7\SLVW,, 37 -RXUQH\PHQ  2Q&DOO)LUHILJKWHUV  38%/,&:25.6 3XEOLF:RUNV'LUHFWRU&LW\(QJLQHHU.HYLQ+DQVHQ 6HFUHWDU\,,$ $VVLVWDQW&LW\(QJLQHHU $GPLQLVWUDWLYH$VVLVWDQW $VVHVVLQJ&OHUN 37 (QJLQHHULQJ7HFKQLFLDQ,9  (QJLQHHULQJ7HFKQLFLDQ,,, 3XEOLF:RUNV6XSHULQWHQGHQW )RUHPDQ 3DUNV6HZHU :DWHU6WUHHWV   0DLQWHQDQFH:RUNHU  6KRS6XSHUYLVRU 0DLQWHQDQFH,,,0HFKDQLF 0DLQWHQDQFH,,,%RG\PDQ3DLQWHU ),1$1&( )LQDQFH'LUHFWRU7UHDVXUHU-RVHSK.ORLEHU 6HFUHWDU\,, $VVLVWDQW)LQDQFH'LUHFWRU $FFRXQWLQJ&RRUGLQDWRU 3D\UROO$FFRXQWDQW %XGJHW&RRUGLQDWRU $FFRXQWLQJ&OHUN,,8WLOLW\ $FFRXQWLQJ&OHUN,8WLOLW\ $FFRXQWLQJ&OHUN, 5HFHSWLRQLVW&DVKLHU 37 /LTXRU2SHUDWLRQV0DQDJHU $VVLVWDQW/LTXRU6WRUH0DQDJHU  376WRUH6XSHUYLVRU  5HWDLO&OHUN 37 ,6'LUHFWRU $VVLVWDQW,6'LUHFWRU ,67HFKQLFLDQ &20081,7<'(9(/230(17 &RPPXQLW\'HYHORSPHQW'LUHFWRU6FRWW&ODUN $VVLVWDQW&RPPXQLW\'HYHORSPHQW'LUHFWRU %XLOGLQJ2IILFLDO 6HFUHWDU\,,3HUPLWV /,%5$5< /LEUDU\'LUHFWRU,QWHULP5HQHH'RXJKHUW\ &OHUN7\SLVW,,  /LEUDU\&OHUN 37 /LEUDU\6XSHUYLVRU 37 3DJH 37 /LEUDU\$LGH 37 $GXOW6HUYLFHV/LEUDULDQ &KLOGUHQ V/LEUDULDQ 5(&5($7,21 5HFUHDWLRQ'LUHFWRU.HLWK:LQGVFKLWO &OHUN7\SLVW,, 6HQLRU&LWL]HQ&RRUGLQDWRU 3URJUDP&RRUGLQDWRU 5HFUHDWLRQ&OHUN 37 &XVWRGLDQ,, 37 &XVWRGLDQ, 37 4 Service Is Our Business THE CITY OF COLUMBIA HEIGHTS DOES NOT DISCRIMINATE ON THE BASIS OF DISABILITY IN EMPLOYMENT OR THE PROVISION OF SERVICES EQUAL OPPORTUNITY EMPLOYER City of Columbia Heights Finance Department 590 40th Avenue N.E. Columbia Heights, MN 55421-3878 Office (763) 706-3600 TDD (763) 706-3692 Fax (763) 706-3637 June 28, 2013 To the Citizens of the City of Columbia Heights, Mayor, Council Members, and City Manager The Comprehensive Annual Financial Report of the City of Columbia Heights for the fiscal year ended December 31, 2012, is hereby submitted. The City’s management assumes responsibility for both the completeness and reliability of the information contained in this report, based on a comprehensive framework of internal control that it has established for this purpose. Because the cost of internal control should not exceed its anticipated benefits, the objective is to provide reasonable, rather than absolute, assurance that the financial statements are free of any material misstatements. HLB Tautges Redpath, Ltd., Certified Public Accountants, have issued an unmodified (“clean”) opinion on the City of Columbia Heights financial statements for the year ended December 31, 2012. Their independent auditors’ report is located at the front of the financial section of this report. State law requires Minnesota cities to issue by June 30th of each year a complete set of audited financial statements for the preceding fiscal year ended December 31st. In addition, state law requires that Minnesota cities undergo an annual Minnesota Legal Compliance Audit. Generally accepted accounting principles require that management provide a narrative introduction, overview, and analysis to accompany the basic financial statements in the form of Management’s Discussion and Analysis (MD&A). This letter of transmittal is designed to complement the MD&A and should be read in conjunction with it. The City of Columbia Heights’ MD&A can be found immediately following the report of the independent auditors. PROFILE OF THE GOVERNMENT The City of Columbia Heights, 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 Council consists of a Mayor and four Council Members. All are elected at-large, on a non-partisan basis. The Mayor serves a two-year term and the Council Members serve four-year terms. The City Manager is appointed by the City Council. The City covers an area of 3.52 square miles and currently has a population of 19,619. The City is empowered to levy a tax on both real and personal property within its boundaries. Information Systems Financial Reporting Accounts Payable Utility Billing Payroll 5 All City funds, departments, commissions and other organizations for which the City of Columbia Heights is financially accountable, including all component units, are presented within the Comprehensive Annual Financial Report. The Columbia Heights Housing and Redevelopment Authority (HRA) and the Columbia Heights Economic Development Authority (EDA) are included in the reporting entity as blended component units of the City of Columbia Heights due to the fact that the governing boards are substantively the same and the City is in a relationship of financial benefit/burden with the authorities. The City provides a full range of services to its citizens. These services include, but are not limited to, police and fire protection; water and sanitation services; the construction and maintenance of highways, streets, and infrastructure; library; recreational facilities; and general administrative services. LOCAL ECONOMY The City is located within the varied and stable economic base of the Minneapolis-Saint Paul greater metropolitan area, which is a major center for both the state and the Upper-Midwest. As such, there has been a relatively stable level of employment for City residents and this is expected to continue. In 2012, the largest employers located within the boundaries of the City included Independent School District 13 and one division of Medtronic Inc., a medical device manufacturer. With its close proximity to the Minneapolis downtown area (4 miles), the City of Columbia Heights offers opportunities for many people to live close to where they work, and this has helped maintain demand for housing in the City. However, as an older, fully developed, inner- ring suburb of the City of Minneapolis, the management and residents of the City of Columbia Heights are faced with the problems of an aging infrastructure, crime, and dependency on state aid to supplement local revenues. The recent sharp rise nation-wide in home mortgage foreclosures has also been reflected locally. The City Council and the City’s management are taking a proactive approach to dealing with these concerns, and they currently have a number of initiatives in progress to address them. Some of these are described below. LONG-TERM FINANCIAL PLANNING The City has a planned Street Rehabilitation Program including, as needed, water mains, sanitary sewer and storm sewer improvements. The program divides the City into seven street rehabilitation zones and calls for approximately one zone to be rehabilitated every one to two years. A portion of cost of street rehabilitation is charged to the benefiting properties in the form of special assessments. In some cases, the City issues bonds to initially finance the project, repaying the bonds with special assessments collected over a number of years. Historically, state aid revenue has been a key component of the City’s operating budget. In recent years, the amount provided by the state has been unpredictable, significantly reduced, and sometimes reduced retroactively. To provide for more stable operations, the City’s management has developed a multi-year financial plan significantly reduces the role of state aid in the City’s operating budget by 2013. Under the plan after 2012, state aid, when available, would primarily 6 be used to reduce the City’s bond levies and/or for capital outlay. The current City Council has reached consensus of opinion in support of the plan. Implementation of this plan is of course dependent on the annual property tax levy and operating budget actually adopted by the City Council each year. RELEVANT FINANCIAL POLICIES By Council resolution, a formal policy has been adopted regarding the minimum unassigned fund balance for the general fund. The goal of the policy is to begin each year with sufficient working capital to fund operations. The policy establishes a year-end targeted unassigned fund balance of 45% of the general fund budgeted expenditures for the subsequent year. At December 31, 2012, the unassigned fund balance in the general fund was sufficient to meet this goal. The City’s policy is to budget and recognize license and permit revenues of the community development function, such as building permit revenue, in the Community Development Fund, a non-major special revenue fund. License and permit revenues of other functions are budgeted and recognized in the general fund. For this reason, license and permit revenues in the general fund are often lower than other comparable Minnesota Cities, which more commonly budget for and recognize all license and permit revenues in the general fund. CURRENT MAJOR INITIATIVES As in much of the nation, home prices in the City have dropped sharply over the last few years. Given this, plus the age of the City’s housing stock, the Economic Development Authority has implemented a program of purchasing and demolishing substandard residential property to create an inventory of redevelopment property available for resale when the housing market recovers. In December, the City purchased a large commercial property in the City’s central business district, adjacent to other real estate held for resale by the City. This creates a 3.46 acre parcel available for redevelopment. In 2012, a citizen task force began studying the need and options for replacement or significant expansion of the City library. AWARD AND AKNOWLEDGEMENTS The Government Finance Officers' Association (GFOA) awarded a Certificate of Achievement for Excellence in Financial Reporting to the City of Columbia Heights, Minnesota for its Comprehensive Annual Financial Report for the year ended December 31, 2011. The Certificate of Achievement is a prestigious national award that recognizes conformity with the highest standards for preparation of state and local government financial reports. In order to be awarded a Certificate of Achievement, a government unit must publish an easily readable and efficiently organized Comprehensive Annual Financial Report whose contents conform to program standards. The CAFR must satisfy both generally accepted accounting principles and applicable legal requirements. 7 A Certificate of Achievement is valid for a period of one year only. We believe our current report continues to conform to the Certificate of Achievement program requirements, and we are submitting it to the GFOA. 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. In closing, without the leadership and support of the City Manager and City Council, preparation of this report would not have been possible. Sincerely, Joseph P. Kloiber Finance Director 8 9 - This page intentionally left blank - 10 II. FINANCIAL SECTION 11 - This page intentionally left blank - 12 4810 White Bear Parkway White Bear Lake, MN 55110 651.426.7000 651.426.5004 fax www.hlbtr.com Equal Opportunity Employer 100-Percent Employee-Owned HLB Tautges Redpath is a member of HLB International, a world-wide network of independent accounting firms and business advisors. INDEPENDENT AUDITOR'S REPORT To the Honorable Mayor and Members of the City Council City of Columbia Heights, Minnesota Report on the Financial Statements We have audited the accompanying financial statements of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information of the City of Columbia Heights, Minnesota, as of and for the year ended December 31, 2012, and the related notes to the financial statements, which collectively comprise the City’s basic financial statements as listed in the table of contents. Management’s Responsibility for the Financial Statements Management is responsible for the preparation and fair presentation of these financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Auditor’s Responsibility Our responsibility is to express opinions on these financial statements based on our audit. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free from material misstatement. An audit involves performing procedures to obtain audit evidence about the amounts and disclosures in the financial statements. The procedures selected depend on the auditor’s judgment, including the assessment of the risks of material misstatement of the financial statements, whether due to fraud or error. In making those risk assessments, the auditor considers internal control relevant to the entity’s preparation and fair presentation of the financial statements in order to design audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of the entity’s internal control. Accordingly, we express no such opinion. An audit also includes evaluating the appropriateness of accounting policies used and the reasonableness of significant accounting  estimates made by management, as well as evaluating the overall presentation of the financial statements. We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our audit opinions. Opinions In our opinion, the financial statements referred to above present fairly, in all material respects, the respective financial position of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information of the City of Columbia Heights, Minnesota, as of December 31, 2012, and the respective changes in financial position, and, where applicable, cash flows thereof for the year then ended in accordance with accounting principles generally accepted in the United States of America. Report on Summarized Comparative Information We have previously audited the City of Columbia Heights, Minnesota’s 2011 financial statements, and we expressed an unmodified audit opinion on the respective financial statements of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information in our report dated June 28, 2013. In our opinion, the summarized comparative information presented herein as of and for the year ended December 31, 2011 is consistent, in all material respects, with the audited financial statements from which they were derived. Other Matters Required Supplementary Information Accounting principles generally accepted in the United States of America require that the management’s discussion and analysis, budgetary comparison information and the schedule of funding progress as listed in the table of contents be presented to supplement the basic financial statements. Such information, although not a part of the basic financial statements, is required by the Governmental Accounting Standards Board, who considers it to be an essential part of financial reporting for placing the basic financial statements in an appropriate operational, economic, or historical context. We have applied certain limited procedures to the required supplementary information in accordance with auditing standards generally accepted in the United States of America, which consisted of inquiries of management about the methods of preparing the information and comparing the information for consistency with management’s responses to our inquiries, the basic financial statements, and other knowledge we obtained during our audit of the basic financial statements. We do not express an opinion or provide any assurance on the information because the limited procedures do not provide us with sufficient evidence to express an opinion or provide any assurance. 14 Other Information Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the City of Columbia Heights, Minnesota’s basic financial statements. The introductory section, combining and individual fund financial statements, supplementary financial information, statistical section, and other information section are presented for purposes of additional analysis and are not a required part of the basic financial statements. The combining and individual fund financial statements and the supplementary financial information are the responsibility of management and were derived from and relate directly to the underlying accounting and other records used to prepare the basic financial statements. Such information has been subjected to the auditing procedures applied in the audit of the basic financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the basic financial statements or to the basic financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America. In our opinion, the combining and individual fund financial statements and the supplementary financial information are fairly stated in all material respects in relation to the basic financial statements as a whole. The introductory, statistical, and other information sections have not been subjected to the auditing procedures applied in the audit of the basic financial statements and, accordingly, we do not express an opinion or provide any assurance on them. Other Reporting Required by Government Auditing Standards In accordance with Government Auditing Standards, we have also issued our report dated June 28, 2013, on our consideration of the City of Columbia Heights, Minnesota’s internal control over financial reporting and on our tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements and other matters. The purpose of that report is to describe the scope of our testing of internal control over financial reporting and compliance and the results of that testing, and not to provide an opinion on internal control over financial reporting or on compliance. That report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the City of Columbia Heights, Minnesota’s internal control over financial reporting and compliance. HLB TAUTGES REDPATH, LTD. June 28, 2013  - This page intentionally left blank - 16 MANAGEMENT’S DISCUSSION AND ANALYSIS As management of the City of Columbia Heights, Minnesota (the City), we offer readers of the City of Columbia Heights’ financial statements this narrative overview and analysis of the financial activities of the City for the fiscal year ended December 31, 2012. We encourage readers to consider the information presented here in conjunction with additional information that we have furnished in our letter of transmittal, which can be found in the introductory section of this report. Financial Highlights The assets of the City exceeded its liabilities at December 31, 2012, by $68,266,860 (net position). Of this amount, $27,922,204 or 41% may be used to meet the City’s ongoing obligations to citizens and creditors. During 2012, the City’s total net position increased by $208,186 or less than 1% from the prior year. Governmental activities decreased net position by $895,373 and the City’s business-type activities increased net position by $1,103,559. As of December 31, 2012, the combined fund balances of the City’s governmental funds were $24,012,428. This is a decrease of $423,840 or 2% from the prior year. Approximately 90 percent of this amount, $21,161,235 is available for use within the City’s constraints and policies. As of December 31, 2012, unassigned fund balance for the General fund was $5,914,974; which equals 63% of the total subsequent year General fund budgeted expenditures. During 2012, the City’s total bonded debt decreased by $1,308,000 to an end of year total of $24,337,000. This decrease was from the payment of principal due in the current year. Overview of the Financial Statements This discussion and analysis is intended to serve as an introduction to the City’s basic financial statements. The City’s basic financial statements are comprised of three components: 1) government- wide financial statements, 2) fund financial statements, and 3) notes to the financial statements. This report also contains other supplementary information in addition to the basic financial statements themselves. Government-wide financial statements. The government-wide financial statements are designed to provide readers with a broad overview of the City’s finances, in a manner similar to a private-sector business. The statement of net position presents information on all of the City’s assets and liabilities, with the difference between the two reported as net position. Over time, increases or decreases in net position may serve as a useful indicator of whether the financial position of the City is improving or deteriorating. 17 Management’s Discussion and Analysis The statement of activities presents information showing how the City’s net position changed during the most recent fiscal year. All changes in net position are reported as soon as the underlying event giving rise to the change occurs, regardless of the timing of related cash flows. Thus, revenues and expenses are reported in this statement for some items that will only result in cash flows in future fiscal periods (e.g. uncollected taxes and earned but unused vacation leave). Both of the government-wide financial statements distinguish functions of the City that are principally supported by taxes and intergovernmental revenues (governmental activities) from other functions that are intended to recover all or a significant portion of their costs through user fees and charges (business-type activities). The governmental activities of the City include general government, public safety, public works, culture and recreation and community development. The business-type activities of the City include water, sanitary sewer, refuse, storm sewer and liquor operations. The government-wide financial statements are presented as Statements 1 and 2 of this report. Fund financial statements. A fund is a grouping of related accounts that is used to maintain control over resources that have been segregated for specific activities or objectives. The City, like other state and local governments, uses fund accounting to ensure and demonstrate compliance with finance-related legal requirements. All of the funds of the City can be divided into three categories: governmental funds, proprietary funds, and fiduciary funds. Governmental funds. Governmental funds are used to account for essentially the same functions reported as governmental activities in the government-wide financial statements. However, unlike the government-wide financial statements, governmental fund financial statements focus on near-term inflows and outflows of spendable resources, as well as on balances of spendable resources available at the end of the fiscal year. Such information may be useful in evaluating a government’s near-term financial requirements. Because the focus of governmental funds is narrower than that of the government-wide financial statements, it is useful to compare the information presented for governmental funds with similar information presented for governmental activities in the government-wide financial statements. By doing so, readers may better understand the long-term impact of the City’s near term financial decisions. Both the governmental fund balance sheet and governmental fund statement of revenues, expenditures, and change in fund balances provide a reconciliation to facilitate this comparison between governmental funds and governmental activities. Information is presented separately in the governmental fund balance sheet and in the governmental fund statement of revenues, expenditures, and changes in fund balances for each major governmental fund. The major governmental funds in 2012 are as follows:  General fund  2008A taxable G.O. housing improvement area bonds fund  Municipal state aid street fund  Capital improvements general government buildings fund  Capital equipment replacement general government fund 18 Management’s Discussion and Analysis  Capital improvements-PIR fund  Capital improvements development fund Data from the other governmental funds are combined into a single, aggregated presentation. Individual fund data for each of these non-major governmental funds is provided in the form of combining statements elsewhere in this report. The City adopts an annual appropriated budget for its general and certain special revenue funds listed in the notes to the financial statements. A budgetary comparison statement has been provided for each these funds to demonstrate compliance with this budget. The basic governmental fund financial statements are presented as Statements 3 through 5 of this report. Proprietary funds. The City maintains two different types of proprietary funds. Enterprise funds are used to report the same functions presented as business-type activities in the government-wide financial statements. The City uses enterprise funds to account for its water, sewer, refuse, storm sewer, and liquor operations. Internal service funds are an accounting device used to accumulate and allocate costs internally among the City’s various functions. The City uses internal service funds to account for its central garage, information systems, insurance, and compensated absences services. Because the central garage, insurance and compensated absences services predominately benefit governmental rather than business-type functions, they have been included within governmental activities in the government-wide financial statements. And also, because the information systems services predominately benefit the business-type functions, it has been included within the business- type activities in the government-wide financial statements. Proprietary funds provide the same type of information as the government-wide financial statements, only in more detail. The proprietary fund financial statements provide separate information for the water, sewer, refuse, storm sewer and liquor operations, all of which are considered to be major funds of the City. Conversely, the internal service funds are combined into a single, aggregated presentation in the proprietary fund financial statements. Individual fund data for the internal service funds is provided in the form of combining statements elsewhere in this report. The basic proprietary fund financial statements are presented as Statements 6 through 8 of this report. Fiduciary funds. Fiduciary funds are used to account for resources held for the benefit of parties outside the government. Fiduciary funds are not reflected in the government-wide financial statements because the resources of those funds are not available to support the City’s own programs. The accounting used for fiduciary funds is much like that used for proprietary funds. The basic fiduciary fund financial statement is presented as Statement 9 of this report. Notes to the financial statements. The notes provide additional information that is essential to a full understanding of the data provided in the government-wide and fund financial statements. 19 Management’s Discussion and Analysis Other information. Required supplementary information on funding progress for retiree health benefits is presented as Statement 11 of this report. The combining statements referred to earlier in connection with non-major governmental funds and internal service funds are presented immediately following the schedule of funding progress for the retiree health plan. Combining and individual fund statements and schedules are presented as Statements 12 through 65 of this report. Government-wide Financial Analysis As noted above, net position may serve over time as a useful indicator of a government’s financial position. At December 31, 2012, the City’s assets exceeded its liabilities by $68,266,860. $37,486,127 or 55% of the City’s net position reflects its investment in capital assets (e.g. land, buildings, equipment and infrastructure) less any related debt used to acquire those assets that is still outstanding. The City uses these capital assets to provide services to citizens; consequently, these assets are not available for future spending. It should be noted that, although net position invested in capital assets are reported net of related debt, the resources needed to repay this debt must be provided from other sources, since the capital assets themselves cannot be used to liquidate these liabilities. In addition, a portion of the City’s net position represents resources that are subject to external restrictions on how they may be used. The remaining balance of unrestricted net position, $27,922,204 or 41% may be used to meet the City’s ongoing obligations to citizens and creditors. At December 31, 2012, the City is able to report positive balances in all three categories of net position, both for the City as a whole, as well as for its separate governmental and business-type activities. 2012 2011 2012 2011 2012 2011 Assets: Current and other assets $30,482,123$31,471,777$8,621,371$8,270,979$39,103,494$39,742,756 Capital assets 42,128,19243,322,05615,126,72414,906,22457,254,91658,228,280 Total assets $72,610,315 $74,793,833 $23,748,095 $23,177,203 $96,358,410 $97,971,036 Liabilities: Current liabilities $2,400,190$2,853,908$1,491,206$1,685,835$3,891,396$4,539,743 Noncurrent liabilities 18,677,60319,512,0305,522,5515,860,59024,200,15425,372,620 Total liabilities $21,077,793$22,365,938$7,013,757$7,546,425$28,091,550$29,912,363 Net position: Net invested in capital assets $27,666,461$28,095,261$9,819,666$9,331,167$37,486,127$37,426,428 Restricted 2,624,4663,213,455234,063381,4652,858,5293,594,920 Unrestricted 21,241,59521,119,1796,680,6095,918,14727,922,20427,037,326 Total net position $51,532,522$52,427,895$16,734,338$15,630,779$68,266,860$68,058,674 CITY OF COLUMBIA HEIGHTS' NET POSITION TotalsGovernmental Activities Business-Type Activities 20 Management’s Discussion and Analysis 2012 2011 2012 2011 2012 2011 Revenues: Program revenues: Charges for services $2,180,021 $2,057,705 $15,278,335 $14,582,413$17,458,356$16,640,118 Operating grants and contributions 825,773 930,251 62,471 66,163 888,244 996,414 Capital grants and contributions 1,002,270 1,539,716 50,000 - 1,052,270 1,539,716 General revenues: Property taxes 9,363,598 9,069,092 - - 9,363,598 9,069,092 Tax increment collections 553,050 558,861 - - 553,050 558,861 Grants and contributions not restricted to specific programs 1,003,552 1,278,195 - - 1,003,552 1,278,195 Unrestricted investment earnings295,950 598,880 63,321 135,932 359,271 734,812 Gain on sale of capital assets used in governmental activities 7,338 34,485 - - 7,338 34,485 Total revenues 15,231,552 16,067,185 15,454,127 14,784,508 30,685,679 30,851,693 Expenses: General government 1,977,5942,039,680 - - 1,977,5942,039,680 Public safety 5,708,0095,549,678 - - 5,708,0095,549,678 Public works 3,200,5722,654,047 - - 3,200,5722,654,047 Culture and recreation 2,500,7192,576,409 - - 2,500,7192,576,409 Community development 2,157,9661,630,350 - - 2,157,9661,630,350 Interest on long-term debt 845,879909,858 - - 845,879909,858 Water - - 2,311,8582,370,0762,311,858 2,370,076 Sewer - - 1,464,2691,710,3811,464,269 1,710,381 Refuse - - 1,601,6481,561,6591,601,648 1,561,659 Storm sewer - - 329,998298,577 329,998 298,577 Liquor - - 8,378,9818,155,8888,378,981 8,155,888 Total expenses 16,390,739 15,360,022 14,086,754 14,096,581 30,477,493 29,456,603 Increase (decrease) in net position before transfers (1,159,187) 707,163 1,367,373 687,927 208,186 1,395,090 Transfers 263,814 264,990 (263,814) (264,990) - - Increase (decrease) in net position (895,373) 972,153 1,103,559 422,937 208,186 1,395,090 Net position - January 1 52,427,895 51,455,742 15,630,779 15,207,842 68,058,674 66,663,584 Net position - December 31 $51,532,522$52,427,895$16,734,338$15,630,779$68,266,860$68,058,674 Business-Type Activities Totals CITY OF COLUMBIA HEIGHTS' CHANGES IN NET POSITION Governmental Activities Changes in net position - governmental activities. During the current year, governmental activities decreased the City’s total net position by $895,373. During the prior year, governmental activities increased the City’s net position by $972,153. Key differences between the current and prior year change in net position of governmental activities include:  In 2012, investment income of the governmental activities decreased approximately $300,000 compared to the prior year. This was primarily the result of a significant 2011 increase in market value which did not recur in 2012.  In early 2012, the City completed a multi-year pedestrian bridge project funded by state and federal grants. Consequently, capital grants decreased approximately $537,000 compared to 2011.  All other changes in revenues of the governmental activities were approximately offsetting. For example, a continuing decline in state aid revenue was offset by an increase in general property taxes under the City’s multi-year plan to phase out reliance on state aid for general operations. 21 Management’s Discussion and Analysis  2012 expenses of the community development function increased by approximately $500,000 compared to 2011 due to reductions in the carrying value of property held for resale.  2012 expenses of the public works function increased by approximately $300,000 compared to 2011, for the local share of installation of state-owned traffic signals on state highway 65.  The 2012 phase of the City’s ongoing street rehabilitation program consisted of several small projects which did not meet the City’s threshold for capitalization of infrastructure. Whereas, the 2011 phase of the program consisted of a single large project that met the threshold. This circumstance increased 2012 public works expenses by approximately an additional $246,000. 22 Management’s Discussion and Analysis Business-type activities. In 2012, business-type activities increased the City’s total net position by $1,103,559 or 2%. In the prior year, business-type activities increased the City’s net position by $422,937 or less than 1%. The key differences between the current and prior year change, in business-type activities net position were the following:  Substantially all of the greater increase in net position for 2012 was attributable to water, sewer and refuse. This was partially driven by a 4% rate increase effective for 2012. In addition, water consumption (volume sold) increased 9% in 2012 compared to 2011. Sewer volume also increased comparably. Some of this increase in volume is attributable to more accurate metering, as a result of a battery replacement program for residential water meters.  The sewer expenses decreased by approximately $246,000 in total. $158,000 of this amount reflects the differences between 2012 infrastructure projects, which met the capitalization threshold and will be depreciated over many years, versus 2011 infrastructure projects, which did not met the threshold and were therefore recognized as 2011 expenses. Of the remaining $88,000 decrease in sewer expenses, approximately $40,000 was for a decline in annual depreciation.  The liquor functions increased net position in 2012 by $86,178 more than 2011. This primarily reflects an increase in income from operations. Sales by the liquor operation increased in 2012 by 4% over 2011. 23 Management’s Discussion and Analysis 24 Management’s Discussion and Analysis Financial Analysis of the City’s Funds As noted earlier, the City uses fund accounting to ensure and demonstrate compliance with finance- related legal requirements. Governmental funds. The focus of the City’s governmental funds is to provide information on near- term inflows, outflows, and balances of spendable resources. Such information is useful in assessing the City’s financing requirements. In particular, unreserved fund balance may serve as a useful measure of a government’s net resources available for spending at the end of the fiscal year. At December 31, 2012, the City’s governmental funds reported combined fund balances of $24,012,428. Committed, assigned and unassigned fund balance, which is available for spending at the City’s discretion, has a balance of $16,975,154. The remainder of fund balance is nonspendable or restricted to indicate that it is not available for new spending because it has already been obligated for debt service ($1,559,985), land held for resale ($2,355,806), prepaid items ($90,387), interfund loans ($405,000), tax increment ($1,364,932), and other restricted purposes. The general fund is the chief operating fund of the City. In 2012, fund balance in the general fund increased by $207,854 or 3.5%. In the prior year, fund balance in the general fund increased by $526,816 or 10%. Key differences between the current and prior year change in the fund balance of the general fund include the following:  Total general fund revenue increased approximately $127,500 in 2012. This primarily reflects a property tax increase of approximately $362,000; offset by reductions in state aid and investment income of $170,000 and $73,000; respectively.  Total general fund expenditures increased $280,876 or 3% in 2012, as compared to the prior year. The key factors of this were: o Public safety personnel costs increased $95,000. $10,000 of this amount was an increase in health insurance expense. $68,000 is from a combination of regular contractual step increases, and from one position for which the incumbent was on military leave in 2011 but reinstated in 2012. The remaining 2012 increase is other fringe benefits associated with the increased salary expense. o Public works expenses increased $138,709. 2012 street department expenses included $122,500 for a portion of the 2012 Zone 7 street rehabilitation project. There was no equivalent charge to the general fund street department in 2011. The changes in fund balance of the other major governmental funds in 2012, and key elements of those changes, were as follows:  The Municipal State Aid Street Fund increased by $78,212. This reflects revenue first available in the current year that correspond to expenses incurred in prior years.  The Capital Improvements General Government Buildings Fund decreased by $176,042. 25 Management’s Discussion and Analysis This is the amount by which 2012 building improvements exceeded 2012 investment income and transfers-in for such improvements. For 2012, the major project financed through this fund was replacement of the City Hall boiler for $168,000.  The Capital Equipment Replacement General Government Fund decreased by $109,654. This is the amount by which 2012 equipment purchases exceeded 2012 investment income and transfers-in for equipment purchases. Also, less surplus equipment was sold in 2012 compared to 2011, reducing annual auction proceeds in this fund by approximately $30,000.  The Capital Improvements PIR Fund increased by $84,325. This primarily reflects current year special assessment revenue, from prior year improvement projects, in excess of current year expenses on current year improvement projects. PIR is the acronym for public improvement revolving fund.  The Capital Improvements Development Fund decreased by $83,581. This primarily reflects the reduction in carrying value for real estate held for resale. The combined total fund balances of the nonmajor governmental funds decreased by $432,201 or slightly greater than 4% in 2012. Whereas in the prior year, combined total fund balances of the nonmajor governmental funds decreased by $223,986 or 2%. This difference involved numerous changes, but the most significant elements included:  The G.O. Improvement/Revenue Bonds 2006A fund decreased by $262,601. This reflects the structured decline in annual debt service for this bond issue for years after 2012.  The Tax Increment Bond fund decreased $186,000. This primarily reflects the reduction in carrying value for real estate held for resale.  The Capital Equipment Fire fund decreased by $98,326. Two new rescue/response vehicles were purchased using prior fund balance in 2012. Proprietary funds. The City’s proprietary funds provide the same type of information that is found in the government-wide financial statements for business-type activities, but in more detail. At December 31, 2012, net position of the major proprietary funds included the following amounts of unrestricted net position:  Water Fund $588,005  Sewer Fund $1,770,422  Refuse Fund $1,146,404  Storm Sewer Fund $37,760  Liquor Fund $2,274,380 The 2012 increases in net position of the major proprietary funds included the following:  Water Fund $377,941  Sewer Fund $36,992 26 Management’s Discussion and Analysis  Refuse Fund $210,577  Storm Sewer Fund $23,632  Liquor Fund $358,272 The increase in the utility funds reflects both an increase in the utility rates and an increase in water and sewer consumption discussed above in the analysis of the City’s business-type activities. Other factors concerning the finances of the proprietary funds are addressed above in the analysis of the City’s business-type activities. Budgetary Highlights General fund. The changes between the original and final 2012 general fund budget consist of:  An increase of $54,465 to budgeted public safety expenditures consisted of an equal increase to the combined amount budgeted for intergovernmental revenue and charges for services. This reflects additional police and fire services and training funded by external entities after the adoption of the original budget.  An increase in the street department budget of $50,000 to appropriate, for 2012 use, certain funds committed for downtown parking facility maintenance.  An increase of $160,793 in transfers-out to the nonmajor funds, to allow for the cancellation of a portion of the 2012 tax levy for debt service purposes. Actual general fund revenues in 2012 were more than budgeted by $103,111 or 1%. This variance was primarily the result of the following:  A certain federal grant for police staffing was budgeted to expire in mid-2012. An extension of agreement into 2013 was subsequently obtained, resulting in revenue from this grant exceeding the budget by approximately $50,000.  Reimbursements of excess tax increments were received for $22,000. This is an item which is not budgeted.  The 2012 increase in the number of rental units within the City exceeded budgeted forecasts. In 2012, 92 new rental licenses were issued. The increase in rental license revenue was $18,800. Actual general fund expenditures in 2012 were less than budgeted by $439,861 or 4%. The largest elements of this variance were as follows:  Police department personnel costs were $120,000 under budget. This is a result of employee turnover and temporarily-unfilled positions from injury-on-duty. This was somewhat offset by nonpersonnel police costs exceeding budget, yielding a net total of $84,788 of police department expenditures under budget. 27 Management’s Discussion and Analysis  Actual expenses of the parks and recreation department were $191,894 under budget. The majority of this consisted of personnel expenses variances: o Custodial services at the City’s banquet hall/rental facility were under budget by $50,000. This was partially a result of reduced rental activity in 2012 as compared to 2011. o The parks department personnel services was also under budget by $48,000. In 2012, a parks maintenance employee transferred to another department, leaving one position vacant for half of the year. o Certain 2012 youth recreation activities were able to use grant revenue in the nonmajor funds to hire seasonal summer staff, in lieu of the general fund recreation department budget. o For 2012 certain part-time positions were budgeted to staff the City’s gymnasium facility, but much of the actual staffing was achieved by adding these duties to an existing full- time position. In addition, 2012 actual contracted maintenance costs for the city gymnasium facility were under budget, as this facility was built within the last few years, and a reliable trend has not yet been established from which to accurately forecast maintenance. These two factors combined to leave the gymnasium activity a total of $57,807 under budget. The remaining balance of the general fund expenditure budget variance was spread across all other departments of the general fund. To a large extent, this reflects a continuation of cost reduction measures implemented in 2009 in response to state aid reductions and weak economic conditions in general. Capital Asset and Debt Administration Capital assets. The City’s capital assets for its governmental and business-type activities as of December 31, 2012, amount to $57,254,916 net of accumulated depreciation. This investment in capital assets includes land, buildings, equipment, infrastructure, and construction in progress. Note that real estate that is only held for resale is not included here in the analysis of capital assets used in governmental and business-type activities. At December 31, 2012, the City had $45,600 of noncancellable contractual commitments for construction in 2012. Significant capital asset activity during 2012 included the following: Year Project StartedCost to DateStatus Street Rehabilitation - Zone 20111,144,013 in-progess Argonne Lift Station2011252,956 in-progess Street Rehabilitation - Zone 2012640,664 in-progess As of December 31,2012 28 Management’s Discussion and Analysis City of Columbia Heights’ Capital Assets Beginning Ending BalanceAdditionsDeletionsBalance Governmental activities: Capital assets - not depreciated: Land $4,891,781$433,842$ - $5,325,623 Construction in progress 4,626,255 689,722 (4,427,963) 888,014 Total capital assets not being depreciated 9,518,036 1,123,564 (4,427,963) 6,213,637 Capital assets - being depreciated: Buildings 27,958,872 167,533 - 28,126,405 Equipment 7,975,687 411,103 (79,296) 8,307,494 Infrastructure 25,914,602 3,718,017 - 29,632,619 Total capital assets being depreciated 61,849,161 4,296,653 (79,296) 66,066,518 Less accumulated depreciation for: Buildings 10,654,566 712,411 - 11,366,977 Equipment 5,143,092 531,042 (75,319) 5,598,815 Infrastructure 12,247,483 938,688 - 13,186,171 Total accumulated depreciation 28,045,141 2,182,141 (75,319) 30,151,963 Capital assets being depreciated - net 33,804,020 2,114,512 (3,977) 35,914,555 Governmental activities capital assets - net 43,322,056 3,238,076 (4,431,940) 42,128,192 Business-type activities: Capital assets - not depreciated: Land 2,343,247 5,966 - 2,349,213 Construction in progress 1,069,779 792,534 (1,602,383) 259,930 Total capital assets not being depreciated 3,413,026 798,500 (1,602,383) 2,609,143 Capital assets - being depreciated: Buildings 4,581,314 50,000 - 4,631,314 Equipment 2,171,819 43,688 - 2,215,507 Infrastructure 14,484,426 1,535,270 - 16,019,696 Total capital assets being depreciated 21,237,559 1,628,958 - 22,866,517 Less accumulated depreciation for: Buildings 1,101,886 132,099 - 1,233,985 Equipment 1,491,708 123,343 - 1,615,051 Infrastructure 7,150,735 349,165 - 7,499,900 Total accumulated depreciation 9,744,329 604,607 - 10,348,936 Capital assets being depreciated - net 11,493,230 1,024,351 - 12,517,581 Business-type activities capital assets - net 14,906,256 1,822,851 (1,602,383) 15,126,724 Total capital assets - net $58,228,312$5,060,927($6,034,323)$57,254,916 Additional information on the City’s capital assets can be found in Note 4 to the financial statements. Long-term debt. During 2012, the City’s total bonded debt decreased by $1,308,000 to an end of year total of $24,337,000. This decrease was from the payment of principal due in the current year. Bonded debt outstanding at year end included general obligation bonds, all of which are backed by the full faith and credit of the City, and revenue bonds, for which only revenues from the related projects financed are pledged for repayment. Some of the general obligation bonds have specific revenue sources pledged other than property taxes, but in the event those other sources were insufficient, the City would be required to fund the shortfall through property taxes. 29 Management’s Discussion and Analysis State statute limits the amount of certain general obligation debt that a Minnesota city may issue to 3% of the taxable market value of property within a city’s taxing jurisdiction. At December 31, 2012, the City’s debt limit under this statute was $29,067,313 and $10,275,000 of the City’s outstanding debt was of the type to which this limit applies. City of Columbia Heights’ Long-Term Debt 2012 2011 2012 2011 2012 2011 General obligation bonds: Repaid only with general taxes$12,308,431$12,698,431$ - $ - $12,308,431$12,698,431 With other pledged revenues 3,573,2994,102,2991,123,2701,304,2704,696,5695,406,569 Revenue bonds 2,737,0002,790,0004,595,0004,750,0007,332,0007,540,000 Compensated absences 950,937944,689172,107161,1091,123,0441,105,798 Postemployment benefits other than pensions 105,492 58,761 - - 105,492 58,761 $19,675,159$20,594,180$5,890,377$6,215,379$25,565,536$26,809,559 Governmental Activities Business-Type Activities Totals At December 31, 2012, the City’s general obligation bonds have an AA rating from Standard and Poor’s and Aa2 rating from Moody’s. The outstanding revenue bonds of the business activities at December 31, 2012, are repaid only with lease revenue and have an A1 rating from Moody’s. The outstanding revenue bonds of the governmental activities at December 31, 2012, are repaid only with tax increment and are unrated. In addition to bonded debt, at year end there was long-term debt in the amount of $1,123,044 and $105,492 respectively, for compensated absences and post-employment health insurance. Additional information on the City’s long-term debt can be found in Note 6 to the financial statements. Economic Factors and Next Year’s Budget In 2012, the average annual unemployment rate for Anoka County, which includes the City, was 5.5%. This is a decrease from a rate of 6.7% from the prior year. This compares to the average 2012 state and national rates of 5.4% and 5.7% respectively. Inflationary trends in the region compare favorably to national trends. These factors were considered in preparing the City of Columbia Heights’ 2012 budget. Requests For Information. This financial report is designed to provide a general overview of the City of Columbia Heights’ finances for all those with an interest in the government’s finances. Questions concerning any of the information provided in this report or requests for additional financial information should be addressed to the City of Columbia Heights, Finance Department, 590 40th Avenue NE, Columbia Heights, Minnesota 55421-3878. 30 BASIC FINANCIAL STATEMENTS 31 CITY OF COLUMBIA HEIGHTS, MINNESOTA STATEMENT OF NET POSITION Statement 1 December 31, 2012 Page 1 of 2 With Comparative Totals For December 31, 2011 GovernmentalBusiness-Type ActivitiesActivities20122011 Current assets: Cash and investments$23,761,245$4,005,773$27,767,018$28,833,007 Cash and investments with fiscal agent - 399,254399,254399,254 Receivables: Accounts (net of allowance for uncollectibles)139,0651,550,2871,689,3521,550,449 Special assessments - current474,088 - 474,088511,412 Taxes 417,408 - 417,408436,551 Interest61,11014,00275,11275,843 Due from other governmental units - current696,5005,509702,009713,232 Internal balances49,539(49,539) - - Prepayments138,469149,528287,997361,543 Inventory - at cost68,6782,546,5572,615,2352,358,294 Real estate held for resale2,355,806 - 2,355,8061,945,117 Total current assets28,161,9088,621,37136,783,27937,184,702 Noncurrent assets: Special assessments receivable - noncurrent2,320,215 - 2,320,2152,558,054 Loans receivable - noncurrent - - - - Capital assets (net of accumulated depreciation): Land5,325,6242,349,2137,674,8377,235,028 Buildings16,759,4283,397,32920,156,75720,783,733 Equipment2,708,679600,4553,309,1343,512,707 Infrastructure16,446,4478,519,79724,966,24421,000,810 Construction in process888,014259,9301,147,9445,696,003 Total noncurrent assets44,448,40715,126,72459,575,13160,786,335 Total assets72,610,31523,748,09596,358,41097,971,037 Totals Primary Government Assets The accompanying notes are an integral part of these financial statements. 32 CITY OF COLUMBIA HEIGHTS, MINNESOTA STATEMENT OF NET POSITION Statement 1 December 31, 2012 Page 2 of 2 With Comparative Totals For December 31, 2011 GovernmentalBusiness-Type ActivitiesActivities20122011 Current liabilities: Accounts payable$412,053$536,948$949,001$1,256,569 Accrued salaries and withholdings payable190,48646,009236,495304,657 Contracts payable - retained percentage61,19542,915104,110175,808 Due to other governmental units168,801376,519545,320640,303 Unearned revenue203,160 - 203,160218,857 Accrued interest payable333,411117,989451,400472,520 Deposits33,5283,00036,52834,090 Compensated absences payable - current57,05610,32667,382128,939 Bonds payable - current940,500357,5001,298,0001,308,000 Total current liabilities2,400,1901,491,2063,891,3964,539,743 Noncurrent liabilities: Compensated absences payable - noncurrent893,881161,7811,055,662976,859 Other postemployment benefits payable - noncurrent105,492 - 105,49258,761 Bonds payable - noncurrent17,678,2305,360,77023,039,00024,337,000 Total noncurrent liabilities18,677,6035,522,55124,200,15425,372,620 Total liabilities21,077,7937,013,75728,091,55029,912,363 Net investments in capital assets27,666,4619,819,66637,486,12737,426,428 Restricted for: Debt service1,127,829234,0631,361,8921,858,361 Tax increment purposes1,097,907 - 1,097,9071,361,471 Other purposes398,730 - 398,730375,088 Unrestricted21,241,5956,680,60927,922,20427,037,326 Total net position$51,532,522$16,734,338$68,266,860$68,058,674 Liabilities Net position Primary Government Totals The accompanying notes are an integral part of these financial statements. 33 CITY OF COLUMBIA HEIGHTS, MINNESOTA STATEMENT OF ACTIVITIES For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 Charges For ExpensesServices Functions/Programs Primary government: Governmental activities: General government$1,977,594$204,391 Public safety5,708,009736,927 Public works3,200,572139,305 Culture and recreation2,500,719137,978 Community development2,157,966961,420 Interest on long-term debt845,879 - Total governmental activities16,390,7392,180,021 Business-type activities: Water 2,311,8582,777,383 Sewer 1,464,2691,581,516 Refuse 1,601,6481,761,860 Storm sewer 329,998353,343 Liquor 8,378,9818,804,233 Total business-type activities14,086,75415,278,335 Total primary government$30,477,493$17,458,356 The accompanying notes are an integral part of these financial statements. 34 Statement 2 OperatingCapital Grants andGrants andGovernmentalBusiness-Type ContributionsContributionsActivitiesActivities20122011 $ - $ - ($1,773,203)$ - ($1,773,203)($1,811,640) 556,387 - (4,414,695) - (4,414,695)(4,276,805) 189,039797,921(2,074,307) - (2,074,307)(1,114,619) 57,337 - (2,305,404) - (2,305,404)(2,339,716) 23,010204,349(969,187) - (969,187)(379,712) - - (845,879) - (845,879)(909,858) 825,7731,002,270(12,382,675)0(12,382,675)(10,832,350) - - - 465,525465,525160,727 - - - 117,247117,247(186,529) 62,47150,000 - 272,683272,683186,682 - - - 23,34523,34552,041 - - - 425,252425,252339,074 62,47150,00001,304,0521,304,052551,995 $888,244$1,052,270(12,382,675)1,304,052(11,078,623)(10,280,355) General revenues: Property taxes9,363,598 - 9,363,5989,069,092 Tax increment collections553,050 - 553,050558,861 Grants and contributions not restricted to specific programs1,003,552 - 1,003,5521,278,195 Unrestricted investment earnings295,95063,321359,271734,812 Gain on sale of capital assets used in governmental activities7,338 - 7,33834,485 Transfers263,814(263,814) - - Total general revenues and transfers11,487,302(200,493)11,286,80911,675,445 Change in net position(895,373)1,103,559208,1861,395,090 Net position - January 152,427,89515,630,77968,058,67466,663,584 Net position - December 31$51,532,522$16,734,338$68,266,860$68,058,674 Totals Net (Expense) Revenue and Changes in Net PositionProgram Revenues Primary Government The accompanying notes are an integral part of these financial statements. 35 CITY OF COLUMBIA HEIGHTS, MINNESOTA BALANCE SHEET GOVERNMENTAL FUNDS December 31, 2012 General Fund 2008A Taxable GO Housing Improvement Area Bonds Fund Municipal State Aid Street Fund Assets Cash and investments $5,855,522 $182,002 $155,918 Receivables: Accounts 65,155 - - Special assessments - 820,151 - Taxes 377,308 - - Interest 17,110 400 - Due from other governmental units 186,787 - 406,996 Interfund receivable 326,456 - - Prepayments 87,341 - - Real estate held for resale - - - Total assets $6,915,679$1,002,553 $562,914 Liabilities and Fund Balances Liabilities: Accounts payable $83,622$ - $67,770 Accrued salaries and withholdings payable 164,051 - 2,356 Contracts payable - retained percentage - - 3,750 Due to other governmental units 129,491 - - Interfund payable - - 307,446 Deferred revenue 461,506 820,151 15,000 Deposits 100 - - Total liabilities 838,770 820,151 396,322 Fund balance: Nonspendable 87,341 - - Restricted - 182,402 - Committed 74,594 - 166,592 Unassigned 5,914,974 - - Total fund balances 6,076,909 182,402 166,592 Total liabilities and fund balances $6,915,679$1,002,553 $562,914 Fund balance reported above Amounts reported for governmental activities in the statement of net position are different because: Capital assets used in governmental activities are not financial resources, and therefore, are not reported in the funds. Other long-term assets are not available to pay for current-period expenditures and, therefore, are deferred in the funds. Internal service funds are used by management to charge the costs of garage, information systems, insurance and compensated absences to individual funds. With the exception of the information systems fund which is a business-type fund, the assets and liabilities of the internal service funds are included in the governmental activities in the statement of net position. Long-term liabilities, including bonds payable, are not due and payable in the current period and therefore are not reported in the funds. Net position of governmental activities The accompanying notes are an integral part of these financial statements. 36 Statement 3 Capital Improvements General Gov't Buildings Capital Equipment Replacement General Gov't Capital Improvements PIR Fund Capital Improvement Development Other Governmental Funds Interfund Eliminations Total Governmental Funds 2012 $1,116,552$3,953,642$877,530$1,017,892$8,062,764$ - $21,221,822 - - 4,428 - 66,663 - 136,246 - - 1,974,152 - - - 2,794,303 - - - - 40,100 - 417,408 3,600 11,600 1,700 5,50016,600 - 56,510 - - - - 102,717 - 696,500 - 405,000 - - 14,377(340,833)405,000 - - - - 3,046 - 90,387 - - 48,0001,034,1351,273,671 - 2,355,806 $1,120,152$4,370,242$2,905,810$2,057,527$9,579,938($340,833)$28,173,982 $13,941$ - $25,235 $8,846$167,404$ - $366,818 - - 60 - 19,660 - 186,127 7,691 - 39,027 - 10,727 - 61,195 - - - - 39,310 - 168,801 - - - - 37,250(340,833)3,863 - - 1,968,486 - 76,079 - 3,341,222 - - 6,331 - 27,097 - 33,528 21,632 02,039,139 8,846377,527(340,833)4,161,554 - 405,000 48,0001,034,1351,276,717 - 2,851,193 - - - - 4,003,679 - 4,186,081 1,098,5203,965,242818,6711,014,5463,924,797 - 11,062,962 - - - - (2,782) - 5,912,192 1,098,5204,370,242866,6712,048,6819,202,411 024,012,428 $1,120,152$4,370,242$2,905,810$2,057,527$9,579,938($340,833)$28,173,982 $24,012,428 40,820,389 3,145,512 2,611,826 (19,057,633) $51,532,522 The accompanying notes are an integral part of these financial statements. 37 CITY OF COLUMBIA HEIGHTS, MINNESOTA STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE GOVERNMENTAL FUNDS For The Year Ended December 31, 2012 General Fund 2008A Taxable GO Housing Improvement Area Bonds Fund Municipal State Aid Street Fund Revenues: Taxes $7,626,258$ - $ - Tax increment collections - - - Special assessments - 105,567 - Licenses and permits 200,954 - - Intergovernmental 1,495,889 - 528,546 Charges for services 574,708 - - Fines and forfeitures 128,543 - - Investment income: Interest and dividends 71,927 1,500 - Change in fair value 4,761 100 - Other revenues 6,485 - 61 Total revenues 10,109,525 107,167 528,607 Expenditures: Current: General government 1,776,011 - - Public safety 5,065,165 - - Public works 1,418,124 - 379,827 Culture and recreation 1,402,856 - - Community development - - - Capital outlay: General government - - - Public safety - - - Public works 195,687 - 68,168 Culture and recreation 15,934 - - Community development - - - Debt service: Principal retirement - 50,000 - Interest and fiscal charges - 49,920 - Developer incentives - - - Total expenditures 9,873,777 99,920 447,995 Revenues over (under) expenditures 235,748 7,247 80,612 Other financing sources (uses): Transfers in 358,076 - - Transfers out (385,970) - (2,400) Sale of capital assets - - - Total other financing sources (uses)(27,894)0 (2,400) Net change in fund balance 207,854 7,247 78,212 Fund balance - January 1 5,869,055 175,155 88,380 Fund balance - December 31 $6,076,909 $182,402 $166,592 The accompanying notes are an integral part of these financial statements. 38 Statement 4 Capital Improvements General Gov't Buildings Capital Equipment Replacement General Gov't Capital Improvements PIR Fund Capital Improvement Development Other Governmental Funds Interfund Eliminations Total Governmental Funds 2012 $ - $ - $ - $ - $1,754,711$ - $9,380,969 - - - - 567,259 - 567,259 - - 670,147 - - - 775,714 - - - - 195,272 - 396,226 - - - - 289,760 - 2,314,195 - - 130,781 - 958,293 - 1,663,782 - - - - 33,339 - 161,882 15,000 67,620 7,300 23,300 73,542 - 260,189 1,000 3,200 500 1,500 4,500 - 15,561 7,644 1,974 6,456 26740,787 - 63,674 23,644 72,794 815,184 25,067 3,917,463 0 15,599,451 346 - 8,752 - 28,324 - 1,813,433 - 8,089164,524 - 13,103 - 5,250,881 - - 170,386 - 43,170 - 2,011,507 12,700 - - - 768,658 - 2,184,214 - - - 97,3061,337,023 - 1,434,329 209,176 - - - - - 209,176 - 70,497 - - 87,951 - 158,448 - 163,004100,768 - 30,193 - 557,820 - 2,173 - - - - 18,107 - - 5,300 24,508606,486 - 636,294 - - - - 922,000 - 972,000 - - - - 811,219 - 861,139 - - - - 116,072 - 116,072 222,222 243,763 449,730 121,814 4,764,199 0 16,223,420 (198,578)(170,969)365,454 (96,747)(846,736)0 (623,969) 22,536 50,000 - 13,166553,163(698,127)298,814 - - (281,129) - (138,628)698,127(110,000) - 11,315 - - - - 11,315 22,536 61,315 (281,129)13,166 414,535 0 200,129 (176,042)(109,654)84,325 (83,581)(432,201)0 (423,840) 1,274,5624,479,896782,3462,132,2629,634,612 - 24,436,268 $1,098,520$4,370,242$866,671$2,048,681$9,202,411 $0$24,012,428 The accompanying notes are an integral part of these financial statements. 39 - This page intentionally left blank - 40 CITY OF COLUMBIA HEIGHTS, MINNESOTA RECONCILIATION OF THE STATEMENT OF REVENUES,Statement 5 EXPENDITURES AND CHANGES IN FUND BALANCES OF GOVERNMENTAL FUNDS TO THE STATEMENT OF ACTIVITIES For The Year Ended December 31, 2012 Amounts reported for governmental activities in the statement of activities (Statement 2) are different because: Net changes in fund balances - total governmental funds (Statement 4)($423,840) Governmental funds report capital outlays as expenditures. However, in the statement of activities the cost of those assets is allocated over their estimated useful lives and reported as depreciation expense. The difference is the amount by which outlays for capital assets exceeded depreciation in the current year.(1,175,879) The net effect of various miscellaneous transactions involving capital assets, such as sales, trade-ins and abandonments was a decrease in net position.(3,977) The issuance of long-term debt provides current financial resources to the governmental funds, while repayment of the principal of long-term debt consumes the current financial resources of the governmental funds. Neither transaction has any effect on net position however. This amount is the net effect of these differences in the treatment of long-term debt.972,000 Interest that accrues in the prior year on long-term debt, that is paid in the current year, consumes current financial resources, and is therefore reported in the governmental funds. It does not reduce net position however, and is not reported as an expense in the statement of activities.15,260 Other postemployment employee benefits that accrue in the current year, but are not paid in the current year, do not consume current financial resources, and are therefore not reported in the governmental funds. They do reduce net position however, and are reported as an expense in the statement of activities.(46,730) Revenue earned in prior years, that first becomes available in the current year, is reported in the governmental funds. Whereas, this amount was reported in the statement of activities in the prior year(s) in which it was earned.(374,423) The net expenses of certain activities of internal service funds are reported within governmental activities in the statement of activities.142,216 Change in net position of governmental activities (Statement 2)($895,373) The accompanying notes are an integral part of these financial statements. 41 CITY OF COLUMBIA HEIGHTS, MINNESOTA STATEMENT OF NET POSITION PROPRIETARY FUNDS December 31, 2012 Assets:Water Utility FundSewer Utility Fund Current assets: Cash and cash equivalents $542,181$1,347,004 Cash and cash equivalents with fiscal agent - - Receivables: Accounts (net of allowance for uncollectibles)571,623419,781 Interest 4,6004,400 Due from other governmental units - current - - Interfund receivable 62,36222,858 Prepayments - 76,968 Inventory - at cost 4,185 - Total current assets1,184,951 1,871,011 Noncurrent assets: Capital assets: Land 45,22336,586 Construction in progress 7,006252,924 Buildings 559,826100,426 Equipment 462,515840,942 Infrastructure 8,346,9656,154,219 Total capital assets 9,421,535 7,385,097 Less: accumulated depreciation(4,263,186)(4,277,960) Net capital assets5,158,3493,107,137 Total noncurrent assets5,158,3493,107,137 Total assets 6,343,3004,978,148 Liabilities: Current liabilities: Accounts payable 6,22415,614 Accrued salaries and withholdings payable9,2224,733 Due to other governmental units283,486 - Interfund payable 399,497 - Contracts payable - 42,915 Accrued interest payable 14,588 - Deposits 3,000 - Deferred revenue - - Compensated absences payable - current1,5332,240 Bonds payable - current 161,862 - Total current liabilities879,412 65,502 Noncurrent liabilities: Compensated absences payable - noncurrent24,02235,087 Bonds payable - noncurrent 789,628 - Total noncurrent liabilities813,650 35,087 Total liabilities1,693,062100,589 Net position: Net investments in capital assets3,883,8593,107,137 Restricted for debt service 178,374 - Unrestricted 588,0051,770,422 Total net position$4,650,238$4,877,559 Adjustments to reflect the consolidation of internal service fund activities related to enterprise funds Net assets of business-type activities Business-Type Activities - Enterprise Funds The accompanying notes are an integral part of these financial statements. 42 Statement 6 Business-Type Activities - Enterprise Funds Refuse Utility Fund Storm Sewer Utility FundLiquor Fund Interfund Eliminations Total Enterprise FundsInternal Service Funds 20122012 $792,091$37,976$607,698$ - $3,326,950$3,218,246 - - 399,254 - 399,254 - 466,36592,357161 - 1,550,2872,819 2,300502200 - 12,0026,600 5,034 - 475 - 5,509 - - - - (22,858)62,362 - - - 72,560 - 149,52848,082 - - 2,542,372 - 2,546,55768,678 1,265,790 130,835 3,622,720 (22,858)8,052,449 3,344,425 - 260,6902,006,714 - 2,349,21315,779 - - - - 259,93068,770 56,000 - 3,915,062 - 4,631,3141,812,838 112,893190,653413,202 - 2,020,205403,437 - 1,518,512 - - 16,019,696 - 168,893 1,969,855 6,334,978 0 25,280,358 2,300,824 (114,975)(716,540)(823,602) - (10,196,263)(950,392) 53,9181,253,3155,511,376 - 15,084,0951,350,432 53,9181,253,3155,511,376015,084,0951,350,432 1,319,7081,384,1509,134,096(22,858)23,136,5444,694,857 112,89840400,342 - 535,11847,065 1,4671,93423,364 - 40,7209,648 - - 93,033 - 376,519 - - 86,862 - (22,858)463,501 - - - - - 42,915 - - 2,838100,563 - 117,989 - - - - - 3,000 - - - - - - 7,450 301845,222 - 9,38058,002 - 30,638165,000 - 357,500 - 114,666 122,396 787,524 (22,858)1,946,642 122,165 4,7201,31781,816 - 146,962908,700 - 141,1424,430,000 - 5,360,770 - 4,720 142,459 4,511,816 0 5,507,732 908,700 119,386264,8555,299,340(22,858)7,454,3741,030,865 53,9181,081,535916,376 - 9,042,8251,350,432 - - 644,000 - 822,374 - 1,146,40437,7602,274,380 - 5,816,9712,313,560 $1,200,322$1,119,295$3,834,756$015,682,170$3,663,992 1,052,168 $16,734,338 The accompanying notes are an integral part of these financial statements. 43 CITY OF COLUMBIA HEIGHTS, MINNESOTA STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND NET POSITION PROPRIETARY FUNDS For The Year Ended December 31, 2012 Water Utility FundSewer Utility FundRefuse Utility Fund Operating revenues: Charges for services$182,730$1,579,864$1,761,860 Charges for sales, net of discounts (Note 1C)2,589,033 - - Total operating revenues2,771,763 1,579,864 1,761,860 Operating expenses: Cost of sales, services and goods sold1,232,031899,0081,415,885 Operating expense783,918400,840141,423 Depreciation218,456131,7551,485 Total operating expenses2,234,405 1,431,603 1,558,793 Net income (loss) from operations537,358 148,261 203,067 Nonoperating revenues (expenses): Investment income: Interest and dividends20,40020,42110,500 Intergovernmental - - 112,471 Miscellaneous revenues5,6201,652 - Interest and fiscal charges(52,093) - - Total nonoperating revenues (expenses)(26,073)22,073 122,971 Net income (loss) before transfers511,285 170,334 326,038 Transfers in - - - Transfers out(133,344)(133,342)(115,461) Total transfers and capital contributions(133,344)(133,342)(115,461) Change in net position377,941 36,992 210,577 Total net position - January 14,272,2974,840,567989,745 Total net position - December 31$4,650,238 $4,877,559 $1,200,322 Change in net position as reported above Adjustment to reflect the consolidation of internal service fund activities related to enterprise funds Change in net position of business-type activities Reconciliation of capital contributions and interfund transfers: Amount reported above Amounts reported for business-type activities in the statement of activities are different because: Adjustment to reflect consolidation of internal service fund activities Amounts reported on the statement of activities Business-Type Activities - Enterprise Funds The accompanying notes are an integral part of these financial statements. 44 Statement 7 Storm Sewer Utility FundLiquor Fund Interfund Eliminations Total Enterprise Funds Internal Service Funds 20122012 $349,457$ - $ - $3,873,911$1,007,655 - 8,804,233 - 11,393,266156,113 349,457 8,804,233 0 15,267,177 1,163,768 - 6,654,657 - 10,201,5811,142,105 237,1171,315,396 - 2,878,694 - 83,993150,287 - 585,97681,285 321,110 8,120,340 0 13,666,251 1,223,390 28,347 683,893 0 1,600,926 (59,622) 2,2001,000 - 54,52129,000 - - - 112,471 - 3,886 - - 11,158(21,019) (10,801)(229,954) - (292,848) - (4,715)(228,954)0 (114,698)7,981 23,632 454,939 0 1,486,228 (51,641) - - - - 294,000 - (96,667) - (478,814)(4,000) 0 (96,667)0 (478,814)290,000 23,632 358,272 0 1,007,414 238,359 1,095,6633,476,484 - 14,674,7563,425,633 $1,119,295 $3,834,756 $0 $15,682,170 $3,663,992 $1,007,414 96,145 $1,103,559 Transfers - Net ($478,814) 215,000 ($263,814) Business-Type Activities - Enterprise Funds The accompanying notes are an integral part of these financial statements. 45 CITY OF COLUMBIA HEIGHTS, MINNESOTA STATEMENT OF CASH FLOWS PROPRIETARY FUNDS For The Year Ended December 31, 2012 WaterSewer Cash flows from operating activities: Cash received from customers$2,749,287$1,532,212 Cash received from interfund goods and services provided - - Cash paid to suppliers for goods and services(1,706,743)(1,285,953) Cash payments to employees for services(339,588)(225,252) Net cash flows from operating activities702,956 21,007 Cash flows from noncapital financing activities: Transfers in - - Transfers out (133,344)(133,342) Intergovernmental - - Interfund receivable repaid by (advanced to) other funds8,17952,371 Interfund payable (repaid to) advanced by other funds(57,003) - Net cash flows from noncapital financing activities(182,168)(80,971) Cash flows from capital and related financing activities: Acquisition of capital assets(350,137)(373,690) Principal payments - bonds(152,880) - Interest and fiscal charges - including capitalized interest(54,300) - Net cash flows from capital and related financing activities(557,317)(373,690) Cash flows from investing activities: Investment income: Interest and dividends18,00020,221 Change in fair value1,3001,300 Net cash flows from investing activities19,300 21,521 Net increase (decrease) in cash and cash equivalents(17,229)(412,133) Total cash and cash equivalents - January 1559,4101,759,137 Total cash and cash equivalents - December 31542,181 1,347,004 (Less) cash and cash equivalents with fiscal agent - December 31 - - Cash and cash equivalents - December 31$542,181$1,347,004 Business-Type Activities - Enterprise Funds 46 Statement 8 Page 1 of 2 RefuseStormLiquorEnterprise FundsInternal Service Funds 20122012 $1,728,024$346,576$8,805,094$15,161,193$ - - - - - 1,602,554 (1,597,081)(116,644)(7,028,496)(11,734,917)(835,322) (76,772)(123,513)(960,860)(1,725,985)(863,200) 54,171 106,419 815,738 1,700,291 (95,968) - - - - 325,000 (115,461) - (96,667)(478,814)(35,000) 112,471 - - 112,471 - (5,034) - - 55,516 - - (59,768) - (116,771) - (8,024)(59,768)(96,667)(427,598)290,000 (54,203)(7,594)(26,887)(812,511)(61,242) - (28,120)(155,000)(336,000) - - (11,270)(208,267)(273,837) - (54,203)(46,984)(390,154)(1,422,348)(61,242) 9,7002,09890050,91926,600 7001001003,5001,400 10,400 2,198 1,000 54,419 28,000 2,344 1,865 329,917 (95,236)160,790 789,74736,111677,0353,821,4403,057,456 792,091 37,976 1,006,952 3,726,204 3,218,246 - - (399,254)(399,254) - $792,091$37,976$607,698$3,326,950$3,218,246 Business-Type Activities - Enterprise Funds 47 CITY OF COLUMBIA HEIGHTS, MINNESOTA STATEMENT OF CASH FLOWS PROPRIETARY FUNDS For The Year Ended December 31, 2012 Water Utility FundSewer Utility Fund Reconciliation of operating income (loss) to net cash flows from operating activities Operating income (loss)$537,358$148,261 Adjustments to reconcile operating income (loss) to net cash flows from operating activities: Depreciation expense218,456131,755 Miscellaneous revenues5,6201,652 Changes in assets and liabilities: (Increase) decrease in accounts receivable(28,096)(49,304) (Increase) decrease in due from other governmental units - - (Increase) decrease in prepayments - (2,051) Adjustment for nonoperating portion - - (Increase) decrease in inventory, at cost(2,473) - Increase (decrease) in accounts payable(12,045)(212,565) Adjustment for nonoperating portion - - Increase (decrease) in accrued salaries and withholdings payable3,345(2,232) Adjustment for nonoperating portion - - Increase (decrease) in contracts payable - retained percentage - 155 Adjustment for nonoperating portion - - Increase (decrease) in due to other governmental units(19,212) - Adjustment for nonoperating portion3,000 - Increase (decrease) in compensated absences payable(2,997)5,336 Increase (decrease) in deferred revenue - - Total adjustments165,598(127,254) Net cash flows from operating activities$702,956$21,007 Business-Type Activities - Enterprise Funds 48 Statement 8 Page 2 of 2 Refuse Utility Fund Storm Sewer Utility FundLiquor FundEnterprise FundsInternal Service Funds 20122012 $203,067$28,347$683,893$1,600,926($59,622) 1,48583,993150,287585,97681,285 - 3,886 - 11,158(21,019) (33,836)(6,767)108(117,895)174 - - 753753 - - - 24,87122,820(1,273) - - (24,871)(24,871) - - (185,790)(188,263)(10,105) (114,987)(3,340)161,438(181,499)(94,285) - - - - - (1,540)(317)3,2372,493(1,770) - - - - - - - - 155 - - - - - - - - (2,065)(21,277) - - - - 3,000 - (18)6173,8776,81510,430 - - - - 217 (148,896)78,072131,84599,365(36,346) $54,171$106,419$815,738$1,700,291($95,968) Business-Type Activities - Enterprise Funds 49 CITY OF COLUMBIA HEIGHTS, MINNESOTA STATEMENT OF FIDUCIARY NET POSITION Statement 9 FIDUCIARY FUNDS December 31, 2012 Assets: Cash and investments $9,748 Due from other governmental units 13 Total assets $9,761 Liabilities: Accounts payable $5,851 Due to other governmental units 3,910 Total liabilities $9,761 The accompanying notes are an integral part of these financial statements. 50 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 Note 1 SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES The City of Columbia Heights, Minnesota (the City) was incorporated in 1898. A Council composed of an elected mayor and four council members governs the City. The Council exercises legislative authority and determines all matters of policy. The Manager, appointed by the Council, is responsible for the proper administration of all affairs relating to the City. The financial statements of the City have been prepared in conformity with generally accepted accounting principles as applied to governmental units by the Governmental Accounting Standards Board (GASB). The following is a summary of the significant policies. A. FINANCIAL REPORTING ENTITY The component units discussed below are included in the City’s reporting entity because of the significance of their operational or financial relationships with the City. The City has two component units - the Housing and Redevelopment Authority (HRA) and the Economic Development Authority (EDA). The HRA and the EDA are considered component units because the governing boards are substantively the same as that of the City and because the City is in a relationship of financial benefit or burden with each of the entities. The financial position and results of operations of the HRA and the EDA component units are presented using the blended method. These blended component units, although legally separate entities, are, in substance, part of the City’s operations. The component units include Governmental Funds using the modified accrual basis of accounting, and as such are reported as Special Revenue Funds. Separate financial statements for the HRA and EDA are not prepared. B. GOVERNMENT-WIDE AND FUND FINANCIAL STATEMENTS The government-wide financial statements (i.e., the statement of net position and the statement of changes in net position) report information on all of the nonfiduciary activities of the primary government and its component units. For the most part, the effect of interfund activity has been removed from these statements. Governmental activities, which normally are supported by taxes and intergovernmental revenues, are reported separately from business-type activities, which rely to a significant extent on fees and charges for support. The statement of activities demonstrates the degree to which the direct expenses of a given function or segment is offset by program revenues. Direct expenses are those that are clearly identifiable with a specific function or segment. Program revenues include 1) charges to customers or applicants who purchase, use or directly benefit from goods, services or privileges provided by a given function or segment and 2) grants and contributions that are restricted to meeting the operational or capital requirements of a particular function or segment. Taxes and other items not included among program revenues are reported instead as general revenues. 51 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 Separate financial statements are provided for governmental funds, proprietary funds, and fiduciary funds, even though the latter are excluded from the government-wide financial statements. Major individual governmental funds and major individual enterprise funds are reported as separate columns in the fund financial statements. C. MEASUREMENT FOCUS, BASIS OF ACCOUNTING AND FINANCIAL STATEMENT PRESENTATION The government-wide financial statements are reported using the economic resources measurement focus and the accrual basis of accounting, as are the proprietary fund financial statements. Revenues are recorded when earned and expenses are recorded when a liability is incurred, regardless of the timing of related cash flows. Property taxes are recognized as revenues in the year for which they are levied. Grants and similar items are recognized as revenue as soon as all eligibility requirements imposed by the provider have been met. The City’s only fiduciary funds are agency funds. Agency funds are custodial in nature and do not involve measurement of results of operations. Agency fund financial statements use the accrual basis of accounting. Governmental fund financial statements are reported using the current financial resources measurement focus and the modified accrual basis of accounting. Revenues are recognized as soon as they are both measurable and available. Revenues are considered to be available when they are collectible within the current period or soon enough thereafter to pay liabilities of the current period. For this purpose, the City considers all revenues, except reimbursement grants, to be available if they are collected within 60 days of the end of the current fiscal period. Reimbursement grants are considered available if they are collected within one year of the end of the current fiscal period. Expenditures generally are recorded when a liability is incurred, as under accrual accounting. However, debt service expenditures, as well as expenditures related to compensated absences and claims and judgments, are recorded only when payment is due. Property taxes, special assessments, intergovernmental revenues, charges for services and interest associated with the current fiscal period are all considered to be susceptible to accrual and so have been recognized as revenues of the current fiscal period. Only the portion of special assessments receivable due within the current fiscal period is considered to be susceptible to accrual as revenue of the current period. All other revenue items are considered to be measurable and available only when cash is received by the City. The City reports the following major governmental funds: The general fund is the City’s primary operating fund. It accounts for all financial resources of the general government, except those required to be accounted for in another fund. The 2008A taxable GO housing improvement area bonds fund was established to account for revenues and expenditures associated with the 2008A series general obligation taxable bonds issued to finance rehabilitation of the Sullivan Shores town homes development. These bonds will be repaid with special assessments to the rehabilitated properties. 52 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 The municipal state aid street fund is maintained according to state statute to account for maintenance and construction of municipal state aid street systems. The capital improvements general government buildings fund is used to account for construction and improvements to municipal buildings not accounted for in a separate fund. The capital equipment replacement – general government fund was established to account for the replacement of capital assets as needed. The capital improvement – PIR fund was established to account for projects that will be assessed to the affected properties. The capital improvement – development fund was established to account for redevelopment. The City reports the following major proprietary funds: The water fund accounts for revenue and expenses associated with water services to area residents. The sewer fund accounts for revenues and expenses associated with sewer disposal within the City. The refuse fund accounts for revenues and expenses associated with organized collection of refuse and recycling within the City. The storm sewer fund accounts for revenues and expenses associated with storm water disposal. The liquor fund accounts for revenues and expenses associated with the operation of three off-sale liquor stores. Additionally, the City reports the following fund types: Internal service funds account for central garage, information systems, insurance and compensated absences services provided to other departments of the City on a cost reimbursement basis. Agency - The permit surcharge agency fund is used to account for SAC charges and surcharges collected for and remitted to the State of Minnesota. The Tri-City GIS fund is used to account for the joint purchase of certain services for which the City is fiscal agent on behalf of the City of Columbia Heights, the City of Fridley and the City of Andover. As a general rule the effect of interfund activity has been eliminated from the government-wide financial statements. Exceptions to this general rule are transactions that would be treated as revenues, expenditures or expenses if they involved external organizations, such as buying goods and services or payments in lieu of taxes, are similarly treated when they involve other funds of the City. Elimination of these charges would distort the direct costs and program revenues reported for the various functions concerned. Amounts reported as program revenues include 1) charges to customers or applicants for goods, services or privileges provided, 2) operating grants and contributions, and 3) capital grants and contributions, including special assessments. Internally dedicated resources are reported as general revenues rather than as program revenues. Likewise, general revenues include all taxes. 53 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 Proprietary funds distinguish operating revenues and expenses from nonoperating items. Operating revenues and expenses generally result from providing services and producing and delivering goods in connection with a proprietary fund’s principal ongoing operations. The principal operating revenues of the water, sewer, refuse, storm sewer and liquor enterprise funds and of the internal service funds are charges to customers for sales and services. Liquor fund sales are reported net of discounts. No other fund provides discounts. For 2012, liquor sales discounts were $173,487. Operating expenses for enterprise funds and internal service funds include the cost of sales and services, administrative expenses, and depreciation on capital assets. All revenues and expenses not meeting this definition are reported as nonoperating revenues and expenses. 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 Fund and the following special revenue funds: Nonmajor special revenue funds: Cable television fund Library fund Community development fund Economic Development Authority (component unit): Economic Development Authority administration fund Housing and Redevelopment Authority (component unit): Parkview villa north fund Parkview villa south fund 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 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. 54 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 E. CASH AND INVESTMENTS Cash balances from all funds of the City are pooled and invested to the extent available in authorized investments. Investments are stated at fair value, based upon quoted market prices. Investment income is 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. The City provides temporary advances to funds that have insufficient cash balances by means of an advance from another fund shown as interfund receivables in the advancing fund, and an interfund payable in the fund with the deficit, until adequate resources are received. The interfund balances are eliminated on the government-wide financial statements. Investments are stated at fair value, based upon quoted market prices, except for investments in 2a7-like external investment pools, which are stated at amortized cost. At December 31, 2012, the City had no investments in 2a7-like external investment pools. Investment income is accrued at the balance sheet date. F. RECEIVABLES AND PAYABLES During the course of operations, numerous transactions occur between individual funds for goods provided or services rendered. Short-term interfund loans are classified as “interfund receivables/payables.” All short-term interfund receivables and payables at December 31 are planned to be eliminated in the subsequent year. Long-term interfund loans are classified as “interfund loan receivable/payable.” Any residual balances outstanding between the governmental activities and business-type activities are reported in the government-wide financial statements as “internal balances.” Because utility bills are considered liens on property, no estimated uncollectible amounts are established. Uncollectible amounts are not material for property taxes, special assessments and other receivables, and have not been reported. G. PROPERTY TAX REVENUE RECOGNITION The City Council annually adopts a tax levy and certifies it to the County in December (levy/assessment date) of each year for collection in the following year. The County is responsible for billing and collecting all property taxes for itself, the City, the local School District and other taxing authorities. Such taxes become a lien on January 1 and are recorded as receivables by the City at that date. Real property taxes are payable (by property owners) on May 15 and October 15 of each calendar year. Personal property taxes are payable by taxpayers on February 28 and June 30 of each year. These taxes are collected by the County and remitted to the City on or before July 7 and December 2 of the same year. Delinquent collections for November and December are received the following January. The City has no ability to enforce payment of property taxes by property owners. The County possesses this authority. GOVERNMENT-WIDE FINANCIAL STATEMENTS The City recognizes property tax revenue in the period for which the taxes were levied. Uncollectible property taxes are not material and have not been reported. 55 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 GOVERNMENTAL FUND FINANCIAL STATEMENTS The City recognizes property tax revenue when it becomes both measurable and available to finance expenditures of the current period. In practice, current and delinquent taxes received by the City are recognized as revenue for the current year. Delinquent taxes that are collected by the County by December 31 (remitted to the City the following January) are also recognized as revenue for the current year. All remaining delinquent taxes receivable in governmental funds are offset by deferred revenue. H. SPECIAL ASSESSMENT REVENUE RECOGNITION Special assessments are levied against benefited properties for the cost or a portion of the cost of special assessment improvement projects in accordance with state statutes. These assessments are collectible by the City over a term of years usually consistent with the term of the related bond issue. Property owners are allowed to (and often do) prepay future installments without interest or prepayment penalties. Once a special assessment roll is adopted, the amount attributed to each parcel is a lien upon that property until full payment is made or the amount is determined to be excessive by the City Council or court action. If special assessments are allowed to go delinquent, the property is subject to tax forfeit sale. Proceeds of sales from tax forfeit properties are allocated first to the County’s costs of administering all tax forfeit properties. Pursuant to state statutes, a property shall be subject to a tax forfeit sale after three years unless it is homesteaded, agricultural or seasonal recreational land, in which event the property is subject to such sale after five years. GOVERNMENT-WIDE FINANCIAL STATEMENTS The City recognizes special assessment revenue in the period that the assessment roll was adopted by the City Council. Uncollectible special assessments are not material and have not been reported. GOVERNMENTAL FUND FINANCIAL STATEMENTS Revenue from special assessments is recognized by the City when it becomes measurable and available to finance expenditures of the current fiscal period. In practice, current and delinquent special assessments received by the City are recognized as revenue for the current year. Special assessments that are collected by the County by December 31 (remitted to the City the following January) are also recognized as revenue for the current year. All remaining delinquent and deferred special assessments receivable in governmental funds are offset by deferred revenue. I. INVENTORIES GOVERNMENTAL FUNDS The original cost of materials and supplies has been recorded as expenditures at the time of purchase. These funds do not maintain material amounts of inventories. Real estate held for resale is valued at the lower of cost or estimated net realizable value. PROPRIETARY FUNDS Inventories of the Proprietary Funds are stated at cost, which approximates market, using the first-in, first- out (FIFO) method. 56 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 J. PREPAID ITEMS Certain payments to vendors reflect costs applicable to future accounting periods and are recorded as prepaid items in both government-wide and fund financial statements. K. CAPITAL ASSETS Capital assets, which include land, buildings, equipment, and infrastructure assets (e.g., roads, sidewalks, water systems, sewer systems and similar items), are reported in the applicable governmental or business- type activities columns in the government-wide financial statements. The City defines capital assets as assets with an estimated useful life in excess of one year and an initial individual cost of more than the following: Land $1 Buildings 25,000 Equipment 5,000 Infrastructure 250,000 Capitalization Threshold Such assets are recorded at historical cost or estimated historical cost if purchased or constructed. Infrastructure assets acquired prior to June 30, 1980 are not recorded. Donated capital assets are recorded at estimated fair market value at the date of donation. The costs of normal maintenance and repairs that do not add to the value of the asset or materially extend assets lives are not capitalized. Major outlays for capital assets and improvements are capitalized as projects are constructed. Interest incurred during the construction phase of capital assets of business-type activities is included as part of the capitalized value of the assets constructed. Property, plant and equipment of the primary government, as well as the component units, is depreciated using the straight line method over the following estimated useful lives: Buildings (and building components)10 - 50 years Equipment3 - 15 years Infrastructure20 - 60 years Capital Assets L. COMPENSATED ABSENCES It is the City's policy to permit employees to accumulate earned but unused vacation and sick pay benefits. All vacation pay and the vested portion of sick pay is accrued when incurred in the government-wide and proprietary fund financial statements. A liability for these amounts is reported in governmental funds only if they have matured, for example, as a result of employee resignations and retirements. In accordance with the provisions of Statement of Government Accounting Standards No. 16, Accounting for Compensated Absences, no liability is recorded for nonvesting accumulating rights to receive sick pay benefits. 57 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 Typically, resources from the compensated absences fund are used to liquidate the liability for compensated absences. M. LONG-TERM OBLIGATIONS In the government-wide financial statements and proprietary fund types in the fund financial statements, long-term debt and other long-term obligations are reported as liabilities in the applicable governmental activities, business-type activities or proprietary fund type statement of net position. Bond premiums and discounts, as well as issuance costs, are immaterial and are expensed in the year of bond issuance. In the fund financial statements, governmental fund types recognize bond premiums and discounts, as well as bond issuance costs, during the current period. The face amount of debt issued is reported as other financing sources. Premiums received on debt issuances are reported as other financing sources while discounts on debt issuances are reported as other financing uses. Issuance costs, whether or not withheld from the actual debt proceeds received, are reported as debt service expenditures. N. FUND BALANCE CLASSIFICATIONS In the fund financial statements, governmental funds report fund balance in classifications that disclose constraints for which amounts in those funds can be spent. These classifications are as follows: Nonspendable – consists of amounts that are not in spendable forms, such as prepaid items and assets for resale. Restricted – consists of amounts related to externally imposed constraints established by creditors, grantors or contributors; or constraints imposed by state statutory provisions. Committed – consist of internally imposed constraints. These constraints are established by Resolution of the City Council. Assigned – consists of internally imposed constraints. These constraints reflect the specific purpose for which it is the City’s intended use. These constraints are established by the City Council and/or management. Pursuant to City Council resolution, the City Manager or Finance Director is authorized to establish assignment of fund balance. Unassigned – is the residual classification for the general fund and also reflects negative residual amounts in other funds. When both restricted and unrestricted resources are available for use, it is the City’s policy to first use restricted resources, and then use unrestricted as they are needed. When committed, assigned or unassigned resources are available for use, it is the City’s policy to use resources in the following order; 1) committed, 2) assigned and 3) unassigned. 58 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 O. INTERFUND TRANSACTIONS Interfund services provided and used are accounted for as revenues, expenditures or expenses. Transactions that constitute reimbursements to a fund for expenditures/expenses initially made from it that are properly applicable to another fund, are recorded as expenditures/expenses in the reimbursing fund and as reductions of expenditures/expenses in the fund that is reimbursed. Interfund loans are reported as an interfund loan receivable or payable which offsets the movement of cash between funds. All other interfund transactions are reported as transfers. P. USE OF ESTIMATES The preparation of financial statements in accordance with generally accepted accounting principles (GAAP) requires management to make estimates that affect amounts reported in the financial statements during the reporting period. Actual results could differ from such estimates. Q. COMPARATIVE DATA/RECLASSIFICATIONS Certain comparative total data for the prior year has been presented in the government-wide financial statements in order to provide an understanding of the changes in the City’s financial position and operations. Certain amounts presented in the prior year data have been reclassified in order to be consistent with the current year’s presentation. R. RECONCILIATION OF GOVERNMENT-WIDE AND FUND FINANCIAL STATEMENTS 1. EXPLANATION OF CERTAIN DIFFERENCES BETWEEN THE GOVERNMENTAL FUND BALANCE SHEET AND THE GOVERNMENT-WIDE STATEMENT OF NET POSITION The governmental fund balance sheet includes a reconciliation between fund balance – total governmental funds and net position – governmental activities as reported in the government-wide statement of net position. One element of that reconciliation states, “long-term liabilities, including bonds payable, are not due and payable in the current period and therefore are not reported in the funds.” The details of this ($19,057,633) difference are as follows: Accrued interest payable ($333,411) Other postemployment benefits payable (105,492) Bonds payable (18,618,730) Adjustment to fund balance - total governmental funds - to arrive at net position of governmental activities($19,057,633) 59 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 2. EXPLANATION OF CERTAIN DIFFERENCES BETWEEN THE GOVERNMENTAL FUND STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE AND THE GOVERNMENT-WIDE STATEMENT OF ACTIVITIES The governmental fund statement of revenues, expenditures and changes in fund balance includes a reconciliation between net changes in fund balance – total governmental funds and changes in net position of governmental activities as reported in the government-wide statement of activities. One element of that reconciliation states, “Governmental funds report capital outlays as expenditures. However, in the statement of activities the cost of those assets is allocated over their estimated useful lives and reported as depreciation expense. The difference is the amount by which outlays for capital assets exceeded depreciation in the current year.” The details of this ($1,175,879) difference are as follows: Total capital outlay in government fund financial statements$1,579,849 Adjustments for non-capital items(128,141) Adjustments to the carrying value of real estate held for resale(508,102) Depreciation expense(2,119,485) Adjustment to net changes in fund balances - total governmental funds - to arrive at changes in net position of governmental activities.($1,175,879) Another element of that reconciliation states, “The issuance of long-term debt provides current financial resources to the governmental funds, while repayment of the principal of long-term debt consumes the current financial resources of governmental funds. Neither transaction has any effect on net position however. This amount is the net effect of these differences in the treatment of long-term debt.” The details of this $972,000 difference are as follows: Principal repayments: General obligation bonds 919,000 Revenue bonds53,000 Adjustment to net changes in fund balances - total governmental funds - to arrive at changes in net position of governmental activities.$972,000 60 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 Another element of that reconciliation states, “Revenue earned in prior years, that first becomes available in the current year is reported in the governmental funds. Whereas, this amount was reported in the statement of activities in the prior year(s) in which it was earned” The details of this ($374,423) difference are as follows: General property taxes deferred revenue: At December 31, 2011($348,216) At December 31, 2012 330,845 Tax increment taxes deferred revenue: At December 31, 2011(25,238) At December 31, 201211,029 Special assessments deferred revenue: At December 31, 2011(3,063,482) At December 31, 20122,788,639 State Aid deferred revenue: At December 31, 2011(83,000) At December 31, 201215,000 Adjustment to net changes in fund balances - total governmental funds - to arrive at changes in net position of governmental activities.($374,423) S. STATEMENT OF CASH FLOWS 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. 61 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 Note 2 DEPOSITS AND INVESTMENTS The City maintains a cash and investment pool that is available for use by all funds of the City. Also at December 31, 2012, a portion of the total cash and investments was held in trust by a fiscal agent for debt service under the terms of the EDA 2007B series bonds. The City's total cash and investment balances as of December 31, 2012 are as follows: Carrying Amount At Fair Value Investments$17,415,908 Deposits10,751,252 Cash on hand8,860 (Less) fidcuiary fund cash(9,748) $28,166,272 Cash and investments$27,767,018 Cash and investments with fiscal agent399,254 $28,166,272 A. DEPOSITS In accordance with Minnesota Statutes, the City maintains deposits at those depository banks authorized by the City Council, all of which are members of the Federal Reserve System. Minnesota Statutes require that all City deposits be protected by insurance, surety bond or collateral. The market value of collateral pledged must equal 110% of the deposits not covered by insurance or bonds. Minnesota Statutes require that securities pledged as collateral be held in safekeeping by the City Clerk/Treasurer or in a financial institution other than that furnishing the collateral. Authorized collateral includes the following: (1) United States government treasury bills, treasury notes and treasury bonds; (2) Issues of United States government agencies and instrumentalities as quoted by a recognized industry quotation service available to the government entity; (3) General obligation securities of any state or local government with taxing powers which is rated “A” or better by a national bond rating service, or revenue obligation securities of any state or local government with taxing powers which is rated “AA” or better by a national bond rating service; (4) Unrated general obligation securities of a local government with taxing powers may be pledged as collateral against funds deposited by that same local government entity; (5) Irrevocable standby letters of credit issued by Federal Home Loan Banks to a municipality accompanied by written evidence that the bank’s public debt is rated “AA” or better by Moody’s Investors Service, Inc., or Standard & Poor’s Corporation; and (6) Time deposits that are fully insured by the Federal Deposit Insurance Corporation. 62 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 Deposits as of December 31, 2012 are as follows: Carrying Bank Amount At BalancesFair Value Demand deposits$1,356,983$1,133,420 Time deposits9,573,9809,617,832 Total$10,930,963$10,751,252 B. INVESTMENTS Minnesota Statutes Section 118A authorizes the City to invest in the following: a) Direct obligations or obligations guaranteed by the United States or its agencies, its instrumentalities, or organizations created by an act of congress, excluding mortgage-backed securities defined as high risk. b) Shares of investment companies described in Section 118A.05. This includes primarily money market funds rated in the top two rating categories by a national rating service, and companies whose only investments are described in items a) through h) of this note. c) Obligations of the State of Minnesota or any of its municipalities as follows: (1) any security which is a general obligation of any state or local government with taxing powers which is rated “A” or better by a national bond rating service; (2) any security which is a revenue obligation of any state or local government with taxing powers which is rated “AA” or better by a national bond rating service; and (3) a general obligation of the Minnesota Housing Finance Agency which is a moral obligation of the State of Minnesota and is rated “A” or better by a national bond rating agency. d) Bankers acceptance of United States banks eligible for purchase by the Federal Reserve System. e) Commercial paper issued by United States corporations or their Canadian subsidiaries, of the highest quality, and maturing in 270 days or less. f) Repurchase or reverse repurchase agreements with banks that are members of the Federal Reserve System with capitalization exceeding $10,000,000; a primary reporting dealer in U.S. government securities to the Federal Reserve Bank of New York; certain Minnesota securities broker-dealers; or, a bank qualified as a depositor. g) General obligation temporary bonds of the same governmental entity issued under section 429.091, subdivision 7, 469.178, subdivision 5 or 475.61, subdivision 6. h) Guaranteed investment contracts with certain U.S. financial institutions carrying only high quality unsecured debt, if the City has withdrawal rights upon a decline in debt quality. 63 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 Investments as of December 31, 2012 are as follows: Weighted Average CarryingPercentage MaturitiesAmount Atof Fair Value In YearsFair ValuePer Issuer Notes issued by U.S. government agencies: Federal Home Loan Bank10.3$10,220,80458.6% Federal Home Loan Mortgage Corporation8.91,810,78610.4% Federal National Mortgage Association14.84,759,20827.3% Money market mutual funds: Evergreen U.S. Government FundN/A12,3580.1% Western Asset Government FundN/A168,6441.0% Other issuersN/A444,1082.6% Total investments17,415,908$ 100.0% C. INVESTMENT RISKS The City's investment policy follows Minnesota State Statutes described above, which reduce the City's exposure to credit, custodial credit and interest rate risks. Additional risk information for the City is as follows: a) Interest rate risk - Interest rate risk is the risk that changes in interest rates of debt investments could adversely affect the fair value of an investment. The City's investment policy requires the City to diversify its investment portfolio to eliminate the risk of loss resulting from over concentration of assets in a specific maturity. The policy also states the City's investment portfolio will remain sufficiently liquid to enable the City to meet all operating requirements which might be reasonably anticipated. b) Credit risk - investments - Credit risk is the risk that an issuer or other counterparty to an investment will be unable to fulfill its obligation to the holder of the investment. As of December 31, 2012, the City's investments in the Notes issued by U.S. government agencies were all rated AA+ by Standard & Poor's, and Aaa by Moody's Investors Service. The money market funds in which the City held shares at December 31, 2012, were not rated, but are invested in U.S. Government Obligations and/or securities guaranteed by the U.S. government, and those underlying securities are rated AA+ by Standard and Poors and Aaa by Moody’s Investor Service. c) Concentration of credit risk - Concentration of credit risk is the risk of loss that may be attributed to the magnitude of a government’s investment in a single issuer. The City places no limit on the amount the City may invest in any one issuer. The table above details the percentage of the City's investments with each issuer at December 31, 2012. d) Custodial credit risk – Custodial credit risk is the risk that in the event of a failure of the counterparty, the City will not be able to recover the value of its investment securities that are in the possession of an outside party. As of December 31, 2012, investments in securities are held by the City’s three broker- dealers in the City’s name, with $500,000 of those securities at each broker-dealer insured by SIPC. Each broker-dealer has provided additional protection by providing additional insurance. This additional insurance is subject to aggregate limits applied to all of the broker-dealer’s accounts. Investments in money markets are not evidenced by securities that exist in physical or book entry form, and therefore are not subject to custodial credit risk disclosures. 64 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 Note 3 RECEIVABLES Significant receivables balances not expected to be collected within one year of December 31, 2012 are as follows: Total 2008A TaxableCapital GO Housing ImpImprovement Area Bonds FundPIR Fund Special assessments receivable$766,380$1,553,836$2,320,216 Total$766,380$1,553,836$2,320,216 Major Funds Governmental funds report deferred revenue in connection with receivables for revenues that are not considered to be available to liquidate liabilities of the current period. Governmental funds also defer revenue recognition in connection with resources that have been received, but not yet earned. At the end of the current fiscal year, the various components of deferred revenue-unavailable and deferred revenue-unearned reported in the governmental funds were as follows: UnavailableUnearned Delinquent property taxes receivable (General Fund)$319,454$ - Delinquent property taxes receivable (Nonmajor Funds)11,391 - Delinquent tax increment (Nonmajor Funds)11,029 - Delinquent special assessments (2008A GO Txbl. Hsg. Imp. Area Bonds Fund)2,286 - Delinquent special assessments (Capital Improvements - PIR Fund)44,074 - Special assessments not yet due (2008A GO Txbl. Hsg. Imp. Area Bonds Fund)817,865 - Special assessments not yet due (Capital Improvements - PIR Fund)1,924,412 - Intergovernmental revenue (State Aid Construction)15,000 - Contract service fees received but unearned (General Fund) - 142,052 Rental fees received in advance (Nonmajor Funds) - 32,134 Forfeitures with adjudication pending (Nonmajor Funds) - 21,525 Total deferred revenue for governmental funds$3,145,511$195,711 65 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 Note 4 CAPITAL ASSETS Capital asset activity for the year ended December 31, 2012 is as follows: Beginning Ending BalanceAdditionsDeletionsBalance Governmental activities: Capital assets - not depreciated: Land $4,891,781$433,842$ - $5,325,623 Construction in progress 4,626,255 689,722 (4,427,963) 888,014 Total capital assets not being depreciated9,518,036 1,123,564 (4,427,963) 6,213,637 Capital assets - being depreciated: Buildings 27,958,872 167,533 - 28,126,405 Equipment 7,975,687 411,103 (79,296) 8,307,494 Infrastructure 25,914,602 3,718,017 - 29,632,619 Total capital assets being depreciated61,849,161 4,296,653 (79,296) 66,066,518 Less accumulated depreciation for: Buildings 10,654,566 712,411 - 11,366,977 Equipment 5,143,092 531,042 (75,319) 5,598,815 Infrastructure 12,247,483 938,688 - 13,186,171 Total accumulated depreciation 28,045,141 2,182,141 (75,319) 30,151,963 Capital assets being depreciated - net 33,804,020 2,114,512 (3,977) 35,914,555 Governmental activities capital assets - net43,322,056 3,238,076 (4,431,940) 42,128,192 Business-type activities: Capital assets - not depreciated: Land 2,343,247 5,966 - 2,349,213 Construction in progress 1,069,779 792,534 (1,602,383) 259,930 Total capital assets not being depreciated3,413,026 798,500 (1,602,383) 2,609,143 Capital assets - being depreciated: Buildings 4,581,314 50,000 - 4,631,314 Equipment 2,171,819 43,688 - 2,215,507 Infrastructure 14,484,426 1,535,270 - 16,019,696 Total capital assets being depreciated21,237,559 1,628,958 - 22,866,517 Less accumulated depreciation for: Buildings 1,101,886 132,099 - 1,233,985 Equipment 1,491,708 123,343 - 1,615,051 Infrastructure 7,150,735 349,165 - 7,499,900 Total accumulated depreciation 9,744,329 604,607 - 10,348,936 Capital assets being depreciated - net 11,493,230 1,024,351 - 12,517,581 Business-type activities capital assets - net14,906,256 1,822,851 (1,602,383) 15,126,724 Total capital assets - net $58,228,312$5,060,927($6,034,323)$57,254,916 66 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 Depreciation expense was charged to functions/programs of the primary government – governmental activities as follows: Governmental activities: General government$94,793 Public safety511,033 Public works1,124,278 Culture and recreation279,469 Community development109,912 Depreciation on capital assets held by governmental internal service activities is charged to each function based on use: Central garage62,656 Total depreciation expense - capital assets held by governmental activities$2,182,141 Depreciation expense was charged to functions/programs of the primary government - business-type activities as follows: Business-type activities: Water $218,457 Sewer 131,754 Refuse 1,485 Storm sewer83,994 Liquor 150,288 Depreciation on capital assets held by business-type internal service activities is charged to each function based on use: Information systems18,629 Total depreciation expense - capital assets held by business-type activities$604,607 67 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 Note 5 INTERFUND RECEIVABLES, PAYABLES , CAPITAL LEASES AND TRANSFERS INTERFUND RECEIVABLES, PAYABLES Individual fund interfund receivable and payable balances at December 31, 2012 are as follows: Fund ReceivablePayable Major Funds: General Fund $326,456$ - Municipal State Aid Street - 307,446 Capital Equipment Replacement General Gov't 405,000 - Water 62,362399,497 Sewer 22,858 - Storm Sewer - 86,862 Nonmajor funds 14,37937,250 Total $831,055$831,055 $9,290 of these interfund balances are for services provided in 2012 and reimbursed in 2013. Also included in these balances is an interfund loan from the Capital Equipment Replacement – General Government Fund to the Water Fund for $323,000, and to the Storm Sewer Fund for $82,000; to finance utility infrastructure improvements. All other interfund balances at December 31, 2012, reflect lending arrangements to cover deficit cash balances at yearend, including some to finance the acquisition of certain real estate held for resale. Substantially all such other amounts are expected to be repaid within one year. INTERFUND TRANSFERS Interfund transfers during the year ended December 31, 2012 are as follows: CapitalCapital EqpCapitalOther Imprvmts GenReplacementImprvmtsGovtlInternal GeneralGovt BldgGen GovtDevelopmentFundsServiceTotal Transfers out: Major funds: Governmental: General$ - $22,536$50,000$ - $268,434$45,000$385,970 Municipal State Aid Street - - - - 2,400 - 2,400 Capital Imprvmts PIR - - - - 281,129 - 281,129 Enterprise: Water88,344 - - - - 45,000133,344 Sewer88,342 - - - - 45,000133,342 Refuse70,461 - - - - 45,000115,461 Liquor51,667 - - - - 45,00096,667 Nonmajor funds: Other governmental funds59,262 - - 13,1661,20065,000138,628 Internal service funds - - - - - 4,0004,000 Total$358,076$22,536$50,000$13,166$553,163$294,000$1,290,941 Transfers In Nonmajor Funds Governmental Major Funds 68 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 Note 6 LONG-TERM DEBT GENERAL OBLIGATION BONDS The City issues General Obligation Bonds to provide funds for the acquisition and construction of major capital improvements. General Obligation Bonds are direct obligations and are backed by the full faith and credit of the City. Any deficiencies in pledged revenues will be offset by general property taxes. All of the bonds are serial bonds, which require semiannual payments of principal and/or interest from the date the bonds are issued. There are a number of limitations and restrictions contained in the various bond indentures. The City is in compliance with all significant limitations and restrictions. General obligation bonds outstanding at December 31, 2012, are as follows: Pledged revenue, if any, in addition toOriginal InterestIssueFinal Balance general property taxesIssueRateDateMaturityEnd of Year Governmental activities: GO Street rehabilitation series 2007ANone$1,000,0004.00-4.375%9/19/20072/1/2018$665,000 GO Public safety center series 2008BNone10,000,0004.30-4.55%8/6/20082/1/20389,610,000 GO Public facilities series 2009ANone3,005,0002.00-4.75%7/1/20092/1/20382,815,000 Taxable GO tax increment bonds series 2009BTax increment580,0003.40-5.10%7/1/20092/1/2021580,000 GO Improvement series 2006ASpecial assessments2,759,5504.00%12/7/20062/1/2020926,730 Taxable GO housing imprvmt area series 2008ASpecial assessments975,0005.00-6.05%7/16/20082/1/2024840,000 GO Public Facilities series 2009ASpecial assessments605,0002.00-4.75%7/1/20092/1/2019445,000 Business-type activities: GO Improvement series 2006AUtility revenues645,4504.00%12/7/20062/1/2017488,270 GO Utility revenue series 2006AUtility revenues670,0004.00%12/7/20062/1/2017375,000 GO Public Facilities series 2009AUtility revenues325,0002.00-4.75%7/1/20092/1/2019260,000 Total general obligation bonds outstanding $17,005,000 69 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 As of December 31, 2012, the annual debt service requirements to maturity for general obligation bonds are as follows: Fiscal Year Ending December 31PrincipalInterestPrincipalInterest 2013$882,560$676,963$192,440$39,612 2014896,500642,527223,50031,773 2015692,000610,974198,00023,693 2016729,730582,256200,27016,034 2017756,000551,436229,0007,680 2018725,000519,60640,0002,400 2019585,000490,62940,000800 2020575,000464,474 - - 2021-20252,615,0001,946,618 - - 2026-20302,320,0001,424,506 - - 2031-20352,955,000840,506 - - 2036-20382,150,000151,274 - - Total$15,881,790$8,901,769$1,123,210$121,992 Governmental ActivitiesBusiness-Type Activities REVENUE BONDS The City issues revenue bonds for which the City pledges only the income derived from the acquired or constructed assets or redevelopment to pay the debt service. All of the bonds are serial bonds, which require semiannual payments of principal and/or interest from the date the bonds are issued. There are a number of limitations and restrictions contained in the bond indentures. The City is in compliance with all significant limitations and restrictions. Revenue bonds outstanding at December 31, 2012 are as follows: Original InterestIssueFinal Balance Pledged revenueIssueRateDateMaturityEnd of Year Governmental activities: Tax increment revenue series 2007Tax increment$2,890,0005.00-5.375%8/3/20072/15/2032$2,737,000 Business-type activities: Public facility lease revenue series 2007BLiquor revenues5,040,0004.50-5.00%9/19/20072/1/20304,595,000 Total revenue bonds outstanding $7,332,000 70 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 As of December 31, 2012, the annual debt service requirements to maturity for revenue bonds are as follows: Fiscal Year Ending December 31PrincipalInterestPrincipalInterest 2013$58,000$143,488$165,000$216,568 201462,000140,488170,000209,030 201568,000137,238180,000201,155 201674,000133,688185,000192,942 201780,000129,838195,000184,393 201887,000125,576205,000175,239 201994,000120,870215,000165,474 2020102,000115,774230,000155,128 2021-2025636,000486,6751,330,000595,453 2026-2030900,000282,2941,720,000223,105 2031-2032576,00034,722 - - Total$2,737,000$1,850,651$4,595,000$2,318,487 Governmental ActivitiesBusiness-Type Activities PLEDGED REVENUES Refer to the schedules above for the terms of bonds with pledged revenues. Additional information on pledged revenues by type, as of December 31, 2012, and for the the year then ended, is as follows: Related BondAs PercentageRelated Bond PledgedActivityPrincipalof RevenuePrincipalPledged RevenueFinancedand InterestPledgedand InterestRevenue Project-specificStreet special assessmentsimprovements$1,509,65095%$419,312$287,129 Project-specificPrivate special assessmentsredevelopment1,170,65395%99,495107,167 Project-specificPublic/Private tax incrementredevelopment5,300,96183%225,248274,899 Water and storm-Utility system sewer net revenuesimprovements1,245,26330%227,426760,950 Annual appropriationMunicipal store of liquor net revenuesconstruction6,913,488100%378,768377,629 Total RemainingCurrent Year 71 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 CHANGES IN LONG-TERM LIABILITIES Long-term liability activity for the year ended December 31, 2012 is as follows: Beginning EndingDue Within BalanceAdditionsReductionsBalanceOne Year Governmental activities: Bonds payable: General obligation bonds repaid only with general taxes $12,698,431$ - ($390,000)$12,308,431$410,000 General obligation bonds with other pledged revenues4,102,299 - (529,000)3,573,299472,500 Revenue bonds 2,790,000 - (53,000)2,737,00058,000 Total bonds payable 19,590,730 - (972,000)18,618,730940,500 Compensated absences 944,689440,012(433,764)950,93757,056 Postemployment benefits other than pensions 58,76181,016(34,285)105,492 - Total governmental activity long-term liab ilities$20,594,180$521,028($1,440,049)$19,675,159$997,556 Business-type activities: Bonds payable: General obligation bonds with other pledged revenues$1,304,270$ - ($181,000)$1,123,270$192,500 Revenue bonds 4,750,000 - (155,000)4,595,000165,000 Total bonds payable 6,054,270 - (336,000)5,718,270357,500 Compensated absences 137,148120,079(85,120)172,10710,326 Total business-type activity long-term lia bilities$6,191,418$120,079($421,120)$5,890,377$367,826 For governmental activities, compensated absences are generally liquidated by the compensated absences fund, an internal service fund. Note 7 CONDUIT DEBT From time to time, the City has issued Revenue Bonds to provide financial assistance to private-sector entities for the acquisition and construction of facilities deemed to be in the public interest. The bonds are secured by the property financed and are payable solely from private-sector entity revenues. Upon repayment of the bonds, ownership of the acquired facilities transfers to the private-sector entity served by the bond issuance. The City, the EDA, and the HRA, are not obligated in any manner for repayment of the bonds. Accordingly, the bonds are not reported as liabilities in the accompanying financial statements. As of December 31, 2012, there were Revenue Bonds of this type outstanding with an estimated aggregate principal amount payable of approximately $20,065,000. 72 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 Note 8 FUND BALANCE A. CLASSIFICATIONS At December 31, 2012, the City has various fund equities through legal restrictions and City Council authorizations. A summary of such classifications are as follows: 2008A TaxMunicipalCapital ImpCap Eqp Capital GeneralGO Housing State AidGeneral Replacement ImprovementNonmajor FundImp BondStreetGovt BldgGen GovtPIRDevelopmentGov'tTotal 2012 Fund Balance Nonspendable Prepaid items $87,341$ - $ - $ - $ - $ - $ - $3,046$90,387 Interfund loans - - - - 405,000 - - - 405,000 Land Held for Resale - - - - - 48,000 1,034,135 1,273,671 2,355,806 Total nonspendable $87,341$ - $ - $ - $405,000$48,000$1,034,135$1,276,717$2,851,193 Restricted for: Tax Increment $ - $ - $ - $ - $ - $ - $ - $1,364,932$1,364,932 Debt service - 182,402 - - - - - 1,377,583 1,559,985 Police & Fire purposes - - - - - - - 85,709 85,709 Culture and Recreation purposes - - - - - - - 294,265 294,265 Housing and Redevelopment - - - - - - - 881,190 881,190 Total restricted $ - $182,402$ - $ - $ - $ - $ - $4,003,679$4,186,081 Committed: Cable TV $ - $ - $ - $ - $ - $ - $ - $497,180$497,180 Culture and Recreation purposes - - - - - - - 398,601 398,601 Housing and Redevelopment - - - - - - 1,014,546 1,626,602 2,641,148 Capital Improvement - - 166,592 1,098,520 - 818,671 - 1,402,414 3,486,197 Capital Equipment - - - - 3,965,242 - - - 3,965,242 Police & Fire purposes 2,276 - - - - - - - 2,276 Downtown Parking Maintenance 72,318 - - - - - - - 72,318 Total committed $74,594$ - $166,592$1,098,520$3,965,242$818,671$1,014,546$3,924,797$11,062,962 Unassigned $5,914,974$ - $ - $ - $ - $ - $ - ($2,782)$5,912,192 Total fund balance $6,076,909$182,402$166,592$1,098,520$4,370,242$866,671$2,048,681$9,202,411$24,012,428 B. DEFICIT FUND BALANCE The following fund had a fund deficit as of December 31, 2012. The City will finance this deficit through internal sources in future years: Nonmajor Funds: Special Revenue Funds: Police Grants($2,782) Internal Service Funds: Compensated Absences(1,413) ($4,195) 73 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 C. MINIMUM FUND BALANCE POLICY The City Council has formally adopted a fund balance policy for the General Fund and the combined Library Fund, Capital Building Library Fund (non-major funds). The most significant revenue sources for these funds are property taxes. This revenue source is received in two installments during the year – June and December. As such, it is the City’s goal to begin each fiscal year with sufficient working capital to fund operations between each semi-annual receipt of property taxes. The policy establishes a year end target of unassigned fund balance for the General Fund and spendable fund balance for the combined Library and Capital Building Library funds equal to at least 45% of the next year’s budgeted expenditures. At December 31, 2012, both funds have met this goal. Note 9 DEFINED BENEFIT PENSION PLANS - STATEWIDE A. PLAN DESCRIPTION All full-time and certain part-time employees of the City are covered by defined benefit plans administered by the Public Employees Retirement Association of Minnesota (PERA). PERA administers the General Employees Retirement Fund (GERF) and the Public Employees Police and Fire Fund (PEPFF). These are cost-sharing, multiple-employer retirement plans. These plans are established and administered in accordance with Minnesota Statute, Chapters 353 and 356. GERF members belong to either the Coordinated Plan or the Basic Plan. Coordinated Plan members are covered by Social Security and Basic Plan members are not. The City has no current employees that are Basic Plan members. All new members must participate in the Coordinated Plan. All police officers and firefighters who qualify for membership by statute are covered by the PEPFF. PERA provides retirement benefits as well as disability benefits to members and benefits to survivors upon death of eligible members. Benefits are established by state statute and vest after three years of credited service. The defined retirement benefits are based on a member’s highest average salary for any five successive years of allowable service, age and years of credit at termination of service. For all PEPFF and PERF members that began service prior to July 1, 1989, a full annuity is available when age plus years of service equal 90. For these members, benefits are calculated using the greater of the step rate or level rate formulas. Only the level rate formula applies to members that began service after June 30, 1989. A reduced retirement annuity is available to eligible members seeking early retirement. 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 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. Vested, terminated employees who are entitled to benefits but are not receiving them yet are bound by the provisions in effect at the time they last terminated their public service. 74 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 PERA issues a publicly available financial report that includes financial statements and required supplementary information for GERF and PEPFF. That report may be obtained by writing to PERA, 60 Empire Drive #200, St. Paul, Minnesota, 55103-1855 or by calling (651) 296-7460 or 1-800-652-9026. B. FUNDING POLICY Minnesota Statutes Chapter 353 sets the rates for employer and employee contributions. These statutes are established and amended by the state legislature. The City makes annual contributions to the pension plans equal to the amount required by state statutes. GERF Coordinated Plan members are required to contribute 6.25% of their annual covered salary in 2012. The PEPFF members are required to contribute 9.6% of their annual covered salary in 2012. The City is required to contribute the following percentages of annual covered payroll: 7.25% for Coordinated Plan GERF members, and 14.4% for PEPFF members. Employer and employee contribution rates for PEPFF will increase in 2014; 10.2% for employees and 15.3% for employer. The City’s contributions for the last three years, which were equal to the contractually required contributions for each year as set by state statute, are as follows: Year Ended December 31,GERFPEPFF 2010$343,485$387,431 2011364,288391,573 2012355,330406,131 Note 10 DEFINED CONTRIBUTION PLAN A. FIRE RELIEF ASSOCIATION, PAID ON-CALL DIVISION The Columbia Heights Fire Department Relief Association is the administrator of a single-employer pension plan for the paid on-call members of the City of Columbia Heights Fire Department. Through October 26, 1997, the association operated as a defined benefit plan. Effective October 27, 1997, the Association amended its by-laws and converted to a defined contribution plan. The pension plan was fully funded at the time of conversion. Benefits and contribution requirements are established by the Association’s by-laws and can be amended by the Association’s Board of Directors with approval from the City. All provisions are within limitations established by Minnesota statutes. Type of Benefit. The exclusive pension provided by the Association is a "Defined Contribution Lump Sum Service Pension" as defined in Minnesota Statutes §424A.02, Subdivision 4. Contributions Required and Contributions Made. No contributions are required from the plan members or the City. The plan is funded through state aid, investment income and discretionary contributions from the City. For 2012, state aid was contributed to the plan. This state aid revenue and the related contribution expense/expenditure of $64,464 are recognized in the accompanying financial statements for the year ended December 31, 2012. 75 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 B. COUNCIL MEMBERS Certain council members of the City are covered by the Public Employees Defined Contribution Plan (PEDCP), a multiple-employer deferred compensation plan administered by the Public Employees Retirement Association of Minnesota (PERA). The PEDCP is a tax qualified plan under section 401(a) of the Internal Revenue Code and all contributions by or on behalf of the employees are tax deferred until time of withdrawal. Plan benefits depend solely on amounts contributed to the plan plus investment earnings, less administrative expenses. Minnesota Statutes, Chapter 353D.03, specifies plan provisions, including the employee and employer contribution rates for those qualified personnel who elect to participate. An eligible elected official who decides to participate contributes 5% of salary, which is matched by the elected official’s employer. In 2012, plan members contributed $1,860 and the City contributed $1,860. Note 11 POST EMPLOYMENT BENEFITS OTHER THAN PENSIONS (OPEB) A. PLAN DESCRIPTION The City administers a single-employer defined benefit health care plan (the plan.) By state statute, the plan provides an implicit rate subsidy for retired participants by allowing retirees under age 65 to purchase health insurance at the premium rate available to active employees. In addition, by state statute, the plan provides payment of insurance premiums, up to age 65, for public safety employees that retire with a qualifying disability, equal to the current employer-paid portion of premiums for an active employee. The employer-paid portion of premiums for an active employee is determined periodically by negotiation between the City and collective bargaining units of city employees. The plan does not issue a publicly available financial report. B. FUNDING POLICY Participants under the implicit rate subsidy provision are required to contribute 100% of the stated premium billed by the insurer. For 2012, participants under disabled public safety retiree provision were required to contribute $0 for single coverage or a portion of the stated premium billed by the insurer for family coverage. Under both provisions of the plan, the City is only required to contribute on a pay-as-go basis. This amount is listed below for the current year. The State of Minnesota, solely at its option, reimburses the City annually for a portion of the City’s costs under the disabled public safety retiree provision. Historically, these reimbursements have approximated 60% of the pay-as-go cost of this plan provision, but has dropped with the lastest acctuarial study to 20%. These reimbursements are reported as revenue in the year received, separate from OPEB expenses/expenditures. 76 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 C. ANNUAL OPEB COST AND NET OPEB OBLIGATION The City’s annual OPEB cost is calculated based on the annual required contribution (ARC) determined by periodic actuarial studies. The ARC represents a level of funding that, if paid on an ongoing basis, is projected to cover the normal cost each year and to amortize the unfunded actuarial liability over a period not to exceed thirty years. The components of the City’s OPEB cost for the current year and the changes in the City’s net OPEB obligation to the plan are as follows: Year Ended December 31, 2012 Annual required contribution$78,606 Interest on net OPEB obligation1,873 Adjustment to annual required contribution(3,139) Annual OPEB cost77,340 Contributions made by City(30,609) Increase in net OPEB obligation46,731 Net OPEB obligation-beginning of year58,761 Net OPEB obligation-end of year$105,492 Comparative OPEB information for the curent and three prior years includes the following: Percentage of Year EndedAnnual OPEBAnnual OPEBNet OPEB December 31CostCost ContributedObligation 2009$25,89166%$21,141 201026,15260%30,661 201178,01659%58,761 201277,34040%105,492 D. FUNDED STATUS AND FUNDING PROGRESS As of January 1, 2011, the most recent actuarial valuation date, the City’s unfunded actuarial accrued liability (UAAL) was $775,238. Under the actuarial cost method used, this actuarial accrued liability is not a function of the annual payroll of active employees covered by the plan (the covered payroll). Actuarial valuations involve estimates of the value of reported amounts and assumptions about the probability of events far into the future. Actuarially determined amounts are subject to continual revision as actual results are compared to past expectations and new estimates are made about the future. The schedule of funding progress, presented as required supplementary information following the notes to the financial statements, presents multi-year trend information, beginning in 2008, about the whether the actuarial value of plan assets is increasing or decreasing over time, relative to the actuarial accrued liability for benefits. 77 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 E. METHODS AND ASSUMPTIONS The projection of benefits for financial reporting purposes is based on the type of benefits provided by the substantive plan at each valuation date and the historical pattern of sharing benefit costs between the City and the participants to that point. The methods used include techniques designed to reduce the effects of short-term volatility in actuarial accrued liabilities and the actuarial value of assets, consistent with the long-term perspective of the calculations. The following methods and simplifying assumptions were used: Actuarial cost method – Projected unit credit Actuarial asset valuation method – Not applicable Amortization of UAAL – Level dollar method over a thirty year closed period Healthcare cost trend rate – 9% initially, declining to 5% after five years Inflation rate assumed – less than 5% annual Investment return assumed – 3% annual Retirement age assumed - Public safety employees age 52, all others age 62 Turnover rate – based on actual experience for City for the years 2004-2008 Mortality – Life expectancies were based on the 2000 Retired Pensioners Mortality Rates for Male and Female Note 12 COMMITMENTS AND CONTINGENCIES A. RISK MANAGEMENT The City is exposed to various risks of loss related to torts; theft of, damage to, and destruction of assets; errors and omissions; injuries to employees; and natural disasters. Workers compensation coverage is provided through a pooled self-insurance program through the League of Minnesota Cities Insurance Trust (LMCIT). The City pays an annual premium to LMCIT. The City is subject to supplemental assessments if deemed necessary by the LMCIT. The LMCIT reinsures through Workers Compensation Reinsurance Association (WCRA) as required by law. For workers compensation, the City is not subject to a deductible. Property, casualty and automobile insurance coverage are provided through a pooled self-insurance program through the LMCIT. The City pays an annual premium to the LMCIT. The City is subject to supplemental assessments if deemed necessary by the LMCIT. The LMCIT reinsures through commercial companies for claims in excess of various amounts. The City retains risk for the deductible portions. These deductibles are considered immaterial to the financial statements. The City continues to carry commercial insurance for all other risks of loss, including employee health and disability insurance. There were no significant reductions in insurance from the previous year or settlements in excess of insurance coverage for any of the past three fiscal years. 78 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 B. LITIGATION The City attorney has indicated that any existing and pending lawsuits, claims and other actions in which the City is a defendant are either covered by insurance or development agreements; of an immaterial amount; or, in the judgment of the City attorney, remotely recoverable by plaintiffs. 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 City expects such amounts, if any, to be immaterial. D. TAX INCREMENT DISTRICTS The City’s tax increment districts are subject to review by the State of Minnesota Office of the State Auditor (OSA). Any disallowed claims or misuse of tax increments could become a liability of the applicable fund. Management has indicated that they are not aware of any instances of noncompliance which would have a material effect on the financial statements. E. CONTRACTUAL COMMITMENTS PENDING SALE In 2012, the Housing and Redevelopment Authority entered into an agreement to sell its 150 unit senior apartment facility (Parkview Villa North and South), to Aeon, a regional non-profit housing entity. The sale is contingent on the U.S. Department of Housing and Urban Development (HUD) allowing both the dissolution of the Parkview Villa North portion of the facility as a Public Housing Agency project, and its conversion to a project-based Section 8 facility. The post-2012 time frame for this decision by HUD is uncertain. CONSTRUCTION The City has entered into several contractual commitments for construction projects that are in process at yearend. At December 31, 2012, the City’s obligation for such projects was approximately $45,600. TAX INCREMENT FINANCING AGREEMENTS Additionally, under the terms of various tax increment financing agreements, the City has commitments to reimburse developers for certain qualifying redevelopment costs plus interest. These future reimbursements are limited, however, to the future tax increment received from certain tax increment districts. The amount to be paid under these agreements is not determinable at this time. 79 CITY OF COLUMBIA HEIGHTS, MINNESOTA NOTES TO FINANCIAL STATEMENTS December 31, 2012 The following table summarizes the current year activity and contingent portions of these commitments: TIFDistrict ExpendituresInterestExpendituresInterest District EndsDeveloperReimbursedPaidAvailableAvailable R82027Crestview ONDC1$ - $16,210$732,801$329,482 R82027Col Hts Tran Block - 11,286175,089 42,605 K22019Barnick 1,266 - 41,232 - K22019Miske 16,4344,780 40,689 - T62031BNC Bank - 84,449 6,650,000 1,865,438 Current YearContingent on Future Tax Increment Note 13 RECENTLY ISSUED ACCOUNTING STANDARDS For the year ended December 31, 2012, the City implemented the following statements issued by the Governmental Accounting Standards Board (GASB), which did not have a material effect on the accompanying financial statements: Statement No. 60 Accounting and Financial Reporting for Service Concession Arrangements. The provisions of this Statement are effective for financial statements for periods beginning after December 15, 2011. Statement No. 62 Codification of Accounting and Financial Reporting Guidance Contained in Pre- November 30, 1989 FASB and AICPA Pronouncements. The provisions of this Statement are effective for financial statements for periods beginning after June 15, 2011. Statement No. 63 Financial Reporting of Deferred Outflows of Resources, Deferred Inflows of Resources and Net Position. The provisions of this Statement are effective for financial statements for periods beginning after December 15, 2011. The Governmental Accounting Standards Boards (GASB) recently approved the following statements which were not implemented for these financial statements, but may affect the City in future years: Statement No. 61 The Financial Reporting Entity Omnibus – An Amendment of GASB No. 14 and No. 34. The provisions of this Statement are effective for financial statements for periods beginning after June 15, 2012. Statement No. 65 Items Previously Reported as Assets and Liabilities. The provisions of this Statement are effective for financial statements for periods beginning after December 15, 2012. Statement No. 66 Technical Corrections – 2012. The provisions of this Statement are effective for financial statements for periods beginning after December 15, 2012. Statement No. 68 Accounting and Financial Reporting for Pension – an amendment of GASB statement No. 27. The provisions of this Statement are effective for financial statements for periods beginning after June 15, 2014. The effect these standards may have on future financial statements is not determinable at this time. 80 REQUIRED SUPPLEMENTARY INFORMATION 81 CITY OF COLUMBIA HEIGHTS, MINNESOTA REQUIRED SUPPLEMENTARY INFORMATION Statement 10 BUDGETARY COMPARISON SCHEDULE - GENERAL FUND Page 1 of 2 For The Year Ended December 31, 2012 With Comparative Actual Amounts For The Year Ended December 31, 2011 Variance with Budgeted AmountsFinal Budget2011 ActualPositive Actual OriginalFinalAmounts(Negative)Amounts Revenues: Taxes$7,590,129$7,590,129$7,626,258$36,129$7,263,658 Licenses and permits179,500179,500200,95421,454158,385 Intergovernmental: Market value homestead credit - - 3,0333,033172,810 All other1,407,0691,442,0391,492,85650,8171,498,355 Charges for services539,100558,596574,70816,112589,915 Fines and forfeitures144,000144,000128,543(15,457)146,140 Investment income: Interest and dividends85,00085,00071,927(13,073)94,441 Change in fair value - - 4,7614,76152,150 Other revenues7,1507,1506,485(665)6,156 Total revenues9,951,948 10,006,414 10,109,525 103,111 9,982,010 Expenditures: General government: Council145,751145,751140,7505,001140,828 Manager416,705416,705412,4274,278398,346 Clerk123,728123,728100,80022,92865,643 Legal186,716186,716177,0699,647167,540 Finance706,700706,700694,56912,131710,048 Assessing129,643129,643118,11711,526120,237 General government buildings145,612145,612132,27913,333154,467 Capital outlay52,00050,000 - 50,00028,475 Total general government1,906,855 1,904,855 1,776,011 128,844 1,785,584 Public safety: Police and animal control3,776,7973,815,4393,711,051104,3883,590,327 Fire and emergency management1,342,8471,358,6701,354,1144,5561,334,982 Capital outlay - - - - 14,791 Total public safety5,119,644 5,174,109 5,065,165 108,944 4,940,100 Public works: Engineering344,155344,155279,98164,174279,062 Maintenance1,053,2881,103,2881,009,76593,523955,257 Sanitation129,481129,481128,3781,103101,644 Capital outlay7,0007,000195,687(188,687)56,978 Total public works1,533,924 1,583,924 1,613,811 (29,887)1,392,941 Other Departments: Parks and recreation1,594,7501,594,7501,402,856191,8941,442,978 Contingencies50,00050,000 - 50,00022,214 Capital outlay6,0006,00015,934(9,934)9,084 Total recreation1,650,750 1,650,750 1,418,790 231,960 1,474,276 Total expenditures10,211,173 10,313,638 9,873,777 439,861 9,592,901 Revenues over (under) expenditures(259,225)(307,224)235,748542,972389,109 2012 82 CITY OF COLUMBIA HEIGHTS, MINNESOTA REQUIRED SUPPLEMENTARY INFORMATION Statement 10 BUDGETARY COMPARISON SCHEDULE - GENERAL FUND Page 2 of 2 For The Year Ended December 31, 2012 With Comparative Actual Amounts For The Year Ended December 31, 2011 Variance with Budgeted AmountsFinal Budget2011 ActualPositive Actual OriginalFinalAmounts(Negative)Amounts Other financing sources (uses): Sale of capital assets$ - $ - $ - $ - $ - Transfers in358,076358,076358,076 - 371,397 Transfers out(217,536)(378,329)(385,970)(7,641)(233,690) Total other financing sources (uses)140,540 (20,253)(27,894)(7,641)137,707 Net change in fund balance($118,685)($327,477)207,854$535,331 526,816 Fund balance - January 15,869,0555,342,239 Fund balance - December 31$6,076,909 $5,869,055 2012 83 CITY OF COLUMBIA HEIGHTS, MINNESOTA REQUIRED SUPPLEMENTARY INFORMATION Statement 11 SCHEDULE OF FUNDING PROGRESS FOR THE RETIREE HEALTH PLAN For The Year Ended December 31, 2012 Actuarial Accrued UAAL as a ActuarialActuarialLiability (AAL)Unfunded Percentage ValuationValue of - ProjectedAAL Funded Coveredof Covered Date AssetsUnit Credit(UAAL)Ratio Payroll Payroll 1/1/2008$ - $257,138 $257,1380%N/A N/A 1/1/2011 - 775,238 775,2380%N/A N/A 84 CITY OF COLUMBIA HEIGHTS, MINNESOTA REQUIRED SUPPLEMENTARY INFORMATION BUDGETARY COMPARISON SCHEDULE NOTE TO RSI December 31, 2012 Note A BUDGETS The legal level of budgetary control is at the fund level. The General Fund and the following Special Revenue Fund budgets are legally adopted on a basis consistent with accounting principles generally accepted in the United States of America:  Nonmajor special revenue funds: Cable television fund Library fund Community development fund Economic Development Authority (component unit): Economic Development Authority administration fund Housing and Redevelopment Authority (component unit): Parkview villa north fund Parkview villa south fund 85 - This page intentionally left blank - 86 COMBINING AND INDIVIDUAL FUND STATEMENTS AND SCHEDULES 87 NONMAJOR GOVERNMENTAL FUNDS 88 SPECIAL REVENUE FUNDS A Special Revenue Fund is used to account for the proceeds of special revenue sources that are legally restricted to expenditures for specified purposes. DEBT SERVICE FUNDS The Debt Service Funds are used to account for the accumulation of resources for, and payment of, interest, principal, and related costs on general long-term debt (other than debt of the proprietary funds.) CAPITAL PROJECT FUNDS The Capital Projects Funds account for financial resources to be used for the acquisition or construction of major capital facilities (other than those financed by proprietary funds.) 89 CITY OF COLUMBIA HEIGHTS, MINNESOTA COMBINING BALANCE SHEET Statement 12 NONMAJOR GOVERNMENTAL FUNDS December 31, 2012 Total Nonmajor Special DebtCapital Governmental Assets RevenueServiceProjectFunds Cash and investments $3,907,456$2,749,135$1,406,173$8,062,764 Receivables: Accounts 66,663 - - 66,663 Taxes 13,40126,699 - 40,100 Interest 7,800 5,400 3,40016,600 Due from other governmental units 97,753 - 4,964102,717 Interfund receivable 14,377 - - 14,377 Prepayments 3,046 - - 3,046 Real estate held for resale 119,764778,816375,0911,273,671 Total assets $4,230,260$3,560,050$1,789,628$9,579,938 Liabilities and Fund Balance Liabilities: Accounts payable $152,696$13,312$1,396$167,404 Accrued salaries and withholdings payable 19,660 - - 19,660 Contracts payable - retained percentage - - 10,72710,727 Due to other governmental units 39,310 - - 39,310 Interfund payable 22,87314,377 - 37,250 Deferred revenue 65,04911,030 - 76,079 Deposits 27,097 - - 27,097 Total liabilities 326,68538,71912,123377,527 Fund balance: Nonspendable 122,810778,816375,0911,276,717 Restricted 1,261,1642,742,515 - 4,003,679 Committed 2,522,383 - 1,402,4143,924,797 Unassigned (2,782) - - (2,782) Total fund balance 3,903,5753,521,3311,777,5059,202,411 Total liabilities and fund balance $4,230,260$3,560,050$1,789,628$9,579,938 90 CITY OF COLUMBIA HEIGHTS, MINNESOTA COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE Statement 13 NONMAJOR GOVERNMENTAL FUNDS For The Year Ended December 31, 2012 Total Nonmajor Special Debt CapitalGovernmental Revenue Service Project Funds Revenues: Taxes $1,065,892 $688,819$ - $1,754,711 Tax increment collections - 567,259 - 567,259 Licenses and permits 195,272 - - 195,272 Intergovernmental 284,696 - 5,064289,760 Charges for services 958,293 - - 958,293 Fines and forfeitures 33,339 - - 33,339 Investment income: Interest and dividends 36,742 22,600 14,200 73,542 Change in fair value 2,100 1,400 1,000 4,500 Other revenues 40,787 - - 40,787 Total revenues 2,617,121 1,280,078 20,264 3,917,463 Expenditures: Current: General government 28,324 - - 28,324 Public safety 1,228 - 11,875 13,103 Public works - - 43,170 43,170 Culture and recreation 767,153 - 1,505768,658 Community development 1,316,592 20,431 - 1,337,023 Capital outlay: Public safety - - 87,951 87,951 Public works - - 30,193 30,193 Community development 158,523 429,581 18,382606,486 Debt service: Principal retirement - 922,000 - 922,000 Interest and fiscal charges - 811,219 - 811,219 Developer incentives - 116,072 - 116,072 Total expenditures 2,271,820 2,299,303 193,076 4,764,199 Revenues over (under) expenditures 345,301 (1,019,225)(172,812)(846,736) Other financing sources (uses): Transfers in - 444,322108,841553,163 Transfers out (138,628) - - (138,628) Total other financing sources (uses)(138,628)444,322 108,841 414,535 Net change in fund balance 206,673 (574,903)(63,971)(432,201) Fund balance - January 1 3,696,9024,096,2341,841,4769,634,612 Fund balance - December 31 $3,903,575$3,521,331$1,777,505$9,202,411 91 - This page intentionally left blank - 92 NONMAJOR SPECIAL REVENUE FUNDS The City of Columbia Heights had the following Nonmajor Special Revenue Funds during the year: Cable Television Fund 225 – established to account for revenues and expenditures associated with the cable television franchise. Police Forfeiture Fund 265 – established to account for forfeited cash and property received by the police department. Police Grants Fund 272 – established to account for revenues and expenditures of various grants for police activities. Library Fund 240 – established in 1993 to account for revenues and expenditures of the library. After School Programs Fund 261 – established to account for revenues and expenditures associated with various youth enrichment activities conducted by the recreation department and the library, under agreements with Independent School District 13. Contributed Projects – Recreation Fund 881 – established to monitor contributions for recreational activities and related expenditures. Contributed Projects – Other Fund 883 – established to monitor contributions and related expenditures for activities other than recreation. Special Projects Fund 226 – established to monitor revenues from special projects and related expenditures. Community Development Fund 201 – established to account for revenues and expenditures associated with planning, building inspections, and community development projects within the City. Anoka County Comm Dev Programs Fund 202 – established to account for revenues and expenditures of community development programs funded by or passed through Anoka County to the City. 93 - This page intentionally left blank - 94 Economic Development Authority – a separate legal entity from the City. The mayor and City Council comprise the majority membership of this component unit. Its purpose is to foster economic development in the City. Economic Development Authority Administration Fund 204 – established to account for revenues and expenditures of all EDA activity not accounted for in other EDA funds. Housing and Redevelopment Authority – a separate legal entity from the City. The mayor and City Council comprise the majority membership of this component unit. Its purpose is to operate a senior housing complex. Parkview Villa North Fund 203 – established to account for the revenues and expenditures of the low-income, federally subsidized portion of a senior housing complex. Parkview Villa South Fund 213 – established to account for the revenues and expenditures of the market-rate, non-federal portion of a senior housing complex. 95 CITY OF COLUMBIA HEIGHTS, MINNESOTA SUBCOMBINING BALANCE SHEET NONMAJOR SPECIAL REVENUE FUNDS December 31, 2012 Cable Television Fund 225 Police Forfeiture Fund 265 Police Grants Fund 272 Library Fund 240 After-School Programs Fund 261 Assets Cash and investments $449,564$53,304$ - $237,921$175,859 Receivables: Accounts 46,448 - - - - Taxes - - - - - Interest 1,200 - - 800 500 Due from other governmental units - - 10,800 - 5,393 Interfund receivable - - - - - Prepayments - - - 3,046 - Real estate held for resale - - - - - Total assets $497,212 $53,304 $10,800 $241,767 $181,752 Liabilities and Fund Balance Liabilities: Accounts payable $ - $ - $ - $5,350$2,653 Accrued salaries and withholdings payable 32 - - 10,745 484 Due to other governmental units - - - 2,640 - Interfund payable - - 13,582 - - Deferred revenue - 21,525 - - - Deposits - - - - - Total liabilities 3221,52513,58218,7353,137 Fund balance: Nonspendable - - - 3,046 - Restricted - 31,779 - - - Committed 497,180 - - 219,986178,615 Unassigned - - (2,782) - - Total fund balance 497,18031,779(2,782)223,032178,615 Total liabilities and fund balance $497,212 $53,304 $10,800 $241,767 $181,752 96 Statement 14 Contributed Projects - Recreation - Fund 881 Contributed Projects - Other - Fund 883 Special Projects Fund 226 Community Development Fund 201 Anoka County Comm Dev Programs Fund 202 EDA Admin Fund 204 (Component Unit) HRA Funds (Component Unit) Total Nonmajor Special Revenue Funds $127,994$219,261$474,142$196,393$18,656$212,414$1,741,948$3,907,456 - - - 143 - 17,2002,87266,663 - - - - - 13,401 - 13,401 400 6001,300 500 1003002,1007,800 - - - - - - 81,56097,753 - - - - - 14,377 - 14,377 - - - - - - - 3,046 - - - - 119,764 - - 119,764 $128,394 $219,861 $475,442 $197,036 $138,520 $257,692 $1,828,480 $4,230,260 $ - $60$ - $883$ - $43$143,707$152,696 - - - 3,263 - 5,136 - 19,660 - - - - - - 36,67039,310 - - - - - - 9,29122,873 - - 31,965 - - 11,391 16865,049 - - - - - - 27,09727,097 0 6031,9654,146 016,570216,933326,685 - - - - 119,764 - - 122,810 128,394219,801 - - 18,756 - 862,4341,261,164 - - 443,477192,890 - 241,122749,1132,522,383 - - - - - - - (2,782) 128,394219,801443,477192,890138,520241,1221,611,5473,903,575 $128,394 $219,861 $475,442 $197,036 $138,520 $257,692 $1,828,480 $4,230,260 97 CITY OF COLUMBIA HEIGHTS, MINNESOTA SUBCOMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE NONMAJOR SPECIAL REVENUE FUNDS For The Year Ended December 31, 2012 3 Cable Television Fund 225 Police Forfeiture Fund 265 Police Grants Fund 272 Library Fund 240 After-School Programs Fund 261 Revenues: Taxes$ - $ - $ - $765,195$ - Licenses and permits - - - - - Intergovernmental - - - - 57,337 Fees/program revenues181,597 - - 8,86819,468 Rents - - - - - Fines and forfeitures - 18,399 - 14,940 - Investment income: Interest and dividends 5,100 - - 3,3002,000 Change in fair value 300 - - 200 100 Other revenues: Contributions - - - - - Miscellaneous 115 - - - - Total revenues 187,11218,399 0792,50378,905 Expenditures: Personal services 2,152 - - 529,81931,027 Supplies 1871,228 - 90,38711,176 Other services and charges 15,317 - - 65,09318,139 Capital outlay - - - - - Total expenditures 17,6561,228 0685,29960,342 Revenues over (under) expenditures 169,45617,171 0107,20418,563 Other financing sources (uses): Transfers out (66,881) - - (31,718) - Total other financing sources (uses)(66,881)0 0(31,718)0 Net change in fund balance 102,57517,171 075,48618,563 Fund balance - January 1 394,60514,608(2,782)147,546160,052 Fund balance - December 31 $497,180 $31,779 ($2,782)$223,032 $178,615 98 Statement 15 Contributed Projects - Recreation - Fund 881 Contributed Projects - Other - Fund 883 Special Projects Fund 226 Community Development Fund 201 Anoka County Comm Dev Programs Fund 202 EDA Admin Fund 204 (Component Unit) HRA Funds (Component Unit) Total Nonmajor Special Revenue Funds $ - $ - $ - $ - $ - $300,697$ - $1,065,892 - - - 195,272 - - - 195,272 - - - - 42,939 71184,349284,696 - - 19,625 - - 90 - 229,648 - - 75,074 - - - 653,571728,645 - - - - - - - 33,339 1,6002,7005,3002,300 2001,40012,84236,742 100 200 300 200 - 100 6002,100 19,4883,317 - - - - - 22,805 - - - 137 - - 17,73017,982 21,1886,217100,299197,90943,139302,358869,0922,617,121 - - - 187,165 - 245,73137,0001,032,894 17,3378,680 - 3,481 - 72456,859190,059 4,1751,988 26216,08430,58511,408727,293890,344 - - - - 30,332 - 128,191158,523 21,51210,668 262206,73060,917257,863949,3432,271,820 (324)(4,451)100,037(8,821)(17,778)44,495(80,251)345,301 - (1,200) - (12,832) - (25,997) - (138,628) 0(1,200)0(12,832)0(25,997)0(138,628) (324)(5,651)100,037(21,653)(17,778)18,498(80,251)206,673 128,718225,452343,440214,543156,298222,6241,691,7983,696,902 $128,394 $219,801 $443,477 $192,890 $138,520 $241,122 $1,611,547 $3,903,575 99 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - CABLE TELEVISION FUND 225 Statement 16 SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL For The Year Ended December 31, 2012 With Comparative Actual Amounts For The Year Ended December 31, 2011 Variance with Budgeted AmountsFinal Budget-2011 ActualPositiveActual OriginalFinalAmounts(Negative)Amounts Revenues: Franchise fees$170,000$170,000$181,597$11,597$174,668 Investment income: Interest and dividends - - 5,1005,1006,100 Change in fair value - - 3003003,400 Other revenues: Miscellaneous - - 115115 - Total revenues170,000170,000187,11217,112184,168 Expenditures: Personal services6,3206,3202,1524,1682,273 Supplies70070018751314,547 Other services and charges29,91429,91415,31714,59739,969 Capital outlay - - - - - Total expenditures36,93436,93417,65619,27856,789 Revenues over expenditures133,066133,066169,45636,390127,379 Other financing sources (uses): Transfers out(66,881)(66,881)(66,881) - (66,668) Net change in fund balance$66,185 $66,185 102,575$36,390 60,711 Fund balance - January 1394,605333,894 Fund balance - December 31$497,180 $394,605 2012 100 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - POLICE FORFEITURE FUND 265 Statement 17 SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - ACTUAL For The Year Ended December 31, 2012 With Comparative Amounts For The Year Ended December 31, 2011 20122011 Revenues: Forfeitures $18,399 $8,428 Expenditures: Supplies 1,228 6,500 Other services and charges - 545 Capital outlay - 979 Total expenditures 1,228 8,024 Revenues over expenditures 17,171 404 Fund balance - January 1 14,608 14,204 Fund balance - December 31 $31,779 $14,608 101 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - POLICE GRANTS FUND 272 Statement 18 SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - ACTUAL For The Year Ended December 31, 2012 With Comparative Amounts For The Year Ended December 31, 2011 20122011 Revenues: Intergovernmental $ - $11,303 Expenditures: Supplies - 13,443 Other services and charges - 642 Total expenditures 0 14,085 Revenues over (under) expenditures 0 (2,782) Fund balance (deficit) - January 1 (2,782) - Fund balance (deficit) - December 31 ($2,782)($2,782) 102 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - LIBRARY FUND 240 Statement 19 SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL For The Year Ended December 31, 2012 With Comparative Actual Amounts For The Year Ended December 31, 2011 Variance with Budgeted Amounts Final Budget-2011 ActualPositiveActual OriginalFinalAmounts(Negative)Amounts Revenues: Taxes $765,195$765,195$765,195$ - $757,620 Charges for services 10,78010,780 8,868(1,912)8,983 Fines 17,00017,00014,940(2,060)15,521 Investment income: Interest and dividends 4,400 4,400 3,300(1,100)4,600 Change in fair value - - 200 2002,500 Other revenues: Miscellaneous 200 200 - (200)60 Contributions 800 800 - (800) - Total revenues 798,375 798,375 792,503 (5,872)789,284 Expenditures: Personal services 594,361594,361529,81964,542548,490 Supplies 100,843100,84390,38710,456119,382 Other services and charges 71,45371,45365,093 6,36080,930 Total expenditures 766,657 766,657 685,299 81,358 748,802 Revenues over expenditures 31,718 31,718 107,204 75,486 40,482 Other financing sources (uses): Transfers out (31,718)(31,718)(31,718) - (32,469) Net change in fund balance $0 $0 75,486 $75,486 8,013 Fund balance - January 1 147,546 139,533 Fund balance - December 31 $223,032 $147,546 2012 103 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - AFTER SCHOOL PROGRAMS FUND 261 Statement 20 SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - ACTUAL For The Year Ended December 31, 2012 With Comparative Amounts For The Year Ended December 31, 2011 20122011 Revenues: Intergovernmental $57,337 $46,046 Program revenue 19,468 21,525 Investment income: Interest and dividends 2,000 2,400 Change in fair value 100 1,300 Total revenues 78,905 71,271 Expenditures: Personal services 31,027 29,482 Supplies 11,176 7,466 Other services and charges 18,139 17,233 Total expenditures 60,342 54,181 Revenues over expenditures 18,563 17,090 Fund balance - January 1 160,052 142,962 Fund balance - December 31 $178,615 $160,052 104 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - RECREATION CONTRIBUTED PROJECTS FUND 881 Statement 21 SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - ACTUAL For The Year Ended December 31, 2012 With Comparative Amounts For The Year Ended December 31, 2011 20122011 Revenues: Investment income: Program revenue $ - $1,094 Interest and dividends 1,600 2,200 Change in fair value 100 1,200 Other revenue: Contributions 19,488 26,040 Total revenues 21,188 30,534 Expenditures: Supplies 17,337 15,957 Other services and charges 4,175 2,466 Total expenditures 21,512 18,423 Revenues over (under) expenditures (324)12,111 Fund balance - January 1 128,718 116,607 Fund balance - December 31 $128,394 $128,718 105 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - CONTRIBUTED PROJECTS - OTHER FUND 883 Statement 22 SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - ACTUAL For The Year Ended December 31, 2012 With Comparative Amounts For The Year Ended December 31, 2011 20122011 Revenues: Investment income: Interest and dividends $2,700 $4,000 Change in fair value 200 2,200 Contributions 3,317 11,035 Total revenues 6,217 17,235 Expenditures: Supplies 8,680 27,433 Other services and charges 1,988 565 Total expenditures 10,668 27,998 Revenues over (under) expenditures (4,451)(10,763) Other financing sources (uses): Transfers in - 5,200 Transfers out (1,200) - Total other financing sources (uses)(1,200)5,200 Net change in fund balance (5,651)(5,563) Fund balance - January 1 225,452 231,015 Fund balance - December 31 $219,801 $225,452 106 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - SPECIAL PROJECTS FUND 226 Statement 23 SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - ACTUAL For The Year Ended December 31, 2012 With Comparative Amounts For The Year Ended December 31, 2011 20122011 Revenues: Fees/program revenue $19,625$19,860 Rents 75,074 82,352 Investment income: Interest and dividends 5,300 5,700 Change in fair value 300 3,100 Total revenues 100,299111,012 Expenditures: Other services and charges 262 - Revenues over expenditures 100,037111,012 Fund balance - January 1 343,440232,428 Fund balance - December 31 $443,477$343,440 107 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - COMMUNITY DEVELOPMENT FUND 201 Statement 24 SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL For The Year Ended December 31, 2012 With Comparative Actual Amounts For The Year Ended December 31, 2011 Variance with Budgeted Amounts Final Budget-2011 ActualPositiveActual OriginalFinalAmounts(Negative)Amounts Revenues: Licenses and permits $158,200$158,200$195,272$37,072$219,972 Investment income: Interest and dividends - - 2,3002,3003,700 Change in fair value - - 200 2002,100 Miscellaneous - - 137 137 20 Total revenues 158,200 158,200 197,909 39,709 225,792 Expenditures: Personal services 197,460197,460187,16510,295227,347 Supplies 5,8755,8753,4812,3943,119 Other services and charges 13,57413,57416,084(2,510)13,324 Total expenditures 216,909 216,909 206,730 10,179 243,790 Revenues over (under) expenditures (58,709)(58,709)(8,821)49,888 (17,998) Other financing sources (uses): Transfers out (12,832)(12,832)(12,832) - (13,110) Net change in fund balance ($71,541)($71,541)(21,653)$49,888 (31,108) Fund balance - January 1 214,543 245,651 Fund balance - December 31 $192,890 $214,543 2012 108 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - ANOKA COUNTY COMM DEV PROGRAMS FUND 202 Statement 25 SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - ACTUAL For The Year Ended December 31, 2012 With Comparative Amounts For The Year Ended December 31, 2011 20122011 Revenues: Intergovernmental $42,939 $6,000 Investment income: Interest and dividends 200 - Total revenues 43,139 6,000 Expenditures: Other services and charges 30,585 6,000 Capital outlay 30,332 2,439 Total expenditures 60,917 8,439 Revenues over (under) expenditures (17,778)(2,439) Fund balance - January 1 156,298 158,737 Fund balance - December 31 $138,520 $156,298 109 CITY OF COLUMBIA HEIGHTS, MINNESOTA REQUIRED SUPPLEMENTARY INFORMATION Statement 26 BUDGETARY COMPARISON SCHEDULE - ECONOMIC DEVELOPMENT AUTHORITY ADMINISTRATION FUND 204 (COMPONENT UNIT) For The Year Ended December 31, 2012 With Comparative Actual Amounts For The Year Ended December 31, 2011 Variance with Budgeted AmountsFinal Budget-2011 ActualPositiveActual OriginalFinalAmounts(Negative)Amounts Revenues: Taxes$303,154$303,154$300,697($2,457)$305,381 Fees/program revenues - - 909043,740 Intergovernmental: Market value homestead credit - - 717115,259 Investment income: Interest and dividends - - 1,4001,4001,500 Change in fair value - - 100100800 Total revenues303,154303,154302,358(796)366,680 Expenditures: Personal services288,883288,883245,73143,152215,094 Other services and charges20,97420,97411,4089,56613,585 Supplies4,3004,3007243,5763,333 Total expenditures314,157314,157257,86356,294232,012 Revenues over (under) expenditures(11,003)(11,003)44,49555,498134,668 Other financing sources (uses): Transfers out(25,997)(25,997)(25,997) - (103,110) Net change in fund balance($37,000)($37,000)18,498$55,49831,558 Fund balance - January 1222,624191,066 Fund balance - December 31$241,122 $222,624 2012 110 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUNDS - HOUSING AND REDEVELOPMENT AUTHORITY (COMPONENT UNIT)Statement 27 COMBINING BALANCE SHEET December 31, 2012 ParkviewParkviewTotal VillaVillaHousing and NorthSouthRedevelopment Fund 203Fund 213Authority Assets Cash and investments$946,063$795,885$1,741,948 Receivables: Accounts1,8769962,872 Interest - 2,1002,100 Due from other governmental units81,560 - 81,560 Total assets$1,029,499 $798,981 $1,828,480 Liabilities and Fund Balance Liabilities: Accounts payable$122,531$21,176$143,707 Due to other governmental units24,32612,34436,670 Interfund payable1,5437,7489,291 Deferred revenue40128168 Deposits18,6258,47227,097 Total liabilities167,06549,868216,933 Fund balance: Restricted862,434 - 862,434 Committed - 749,113749,113 Total fund balance 862,434749,1131,611,547 Total liabilities and fund balance$1,029,499 $798,981 $1,828,480 111 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUNDS - HOUSING AND REDEVELOPMENT AUTHORITY (COMPONENT UNIT)Statement 28 COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE For The Year Ended December 31, 2012 Parkview Parkview Total Villa Villa Housing and North SouthRedevelopment Fund 203 Fund 213 Authority Revenues: Intergovernmental $184,349 $ - $184,349 Rents 358,920 294,651 653,571 Investment income: Interest and dividends 4,042 8,800 12,842 Change in fair value - 600 600 Other revenues: Miscellaneous 11,476 6,254 17,730 Total revenues 558,787 310,305 869,092 Expenditures: Personal services 25,500 11,500 37,000 Supplies 30,095 26,764 56,859 Other services and charges 510,917 216,376 727,293 Capital outlay 128,191 - 128,191 Total expenditures 694,703 254,640 949,343 Revenues over (under) expenditures (135,916)55,665 (80,251) Fund balance - January 1 998,350 693,448 1,691,798 Fund balance - December 31 $862,434 $749,113 $1,611,547 112 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - HOUSING & REDEVELOPMENT AUTHORITY- Statement 29 PARKVIEW VILLA NORTH FUND 203 SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL For The Year Ended December 31, 2012 With Comparative Actual Amounts For The Year Ended December 31, 2011 Variance with Budgeted Amounts Final Budget-2011 ActualPositiveActual OriginalFinalAmounts(Negative)Amounts Revenues: Intergovernmental revenue $282,200$282,200$184,349($97,851)$176,750 Rents 347,462347,462358,92011,458351,037 Investment income: Interest and dividends 7,6957,6954,042(3,653)2,789 Other revenues 1,1041,10411,47610,3729,907 Total revenues 638,461638,461558,787(79,674)540,483 Expenditures: Personal services 25,50025,50025,500 - 25,500 Supplies 25,19025,19030,095(4,905)21,187 Other services and charges 459,160459,160510,917(51,757)446,002 Capital outlay 92,20092,200128,191(35,991)9,855 Total expenditures 602,050602,050694,703(92,653)502,544 Revenues over (under) expenditures $36,411$36,411(135,916)($172,327)37,939 Fund balance - January 1 998,350 960,411 Fund balance - December 31 $862,434 $998,350 2012 113 CITY OF COLUMBIA HEIGHTS, MINNESOTA SPECIAL REVENUE FUND - HOUSING & REDEVELOPMENT AUTHORITY - Statement 30 PARKVIEW VILLA SOUTH FUND 213 SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL For The Year Ended December 31, 2012 With Comparative Actual Amounts For The Year Ended December 31, 2011 Variance with Budgeted Amounts Final Budget-2011 ActualPositiveActual OriginalFinalAmounts(Negative)Amounts Revenues: Rents $314,990$314,990$294,651($20,339)$313,549 Investment income: Interest and dividends - - 8,800 8,80010,300 Change in fair value - - 600 600 5,700 Other 2,325 2,325 6,254 3,929 6,156 Total revenues 317,315317,315310,305(7,010)335,705 Expenditures: Personal services 11,50011,50011,500 - 11,500 Supplies 11,02511,02526,764(15,739)10,536 Other services and charges 221,576221,576216,376 5,200199,804 Capital outlay 35,00035,000 - 35,000 - Total expenditures 279,101279,101254,64024,461221,840 Revenues over expenditures $38,214$38,21455,665$17,451113,865 Fund balance - January 1 693,448 579,583 Fund balance - December 31 $749,113 $693,448 2012 114 NONMAJOR DEBT SERVICE FUNDS The City of Columbia Heights had the following kinds of Nonmajor Debt Service Funds during the year: Bond Debt Service Funds – are separate funds used to account for the revenues and expenditures of each separate bond issue. Tax Increment Financing Funds – are separate funds used to account for the revenues and expenditures of each separate Tax Increment Financing District. 115 CITY OF COLUMBIA HEIGHTS, MINNESOTA SUBCOMBINING BALANCE SHEET NONMAJOR DEBT SERVICE FUNDS December 31, 2012 G.O. Improvement/ Revenue Bonds 2006A Fund 340 G.O. Street Rehabilitation Bonds 2007 Fund 341 G.O. Public Safety Center Bonds 2008B Fund 343 G.O. Public Facilities Bonds 2009A Fund 344 Assets Cash and investments$458,893$120,998$458,464$332,639 Receivables: Taxes - 9042,847838 Interest800100500600 Land held for resale - - - - Total assets$459,693$122,002$461,811$334,077 Liabilities and Fund Balance Liabilities: Accounts payable$ - $ - $ - $ - Deferred revenue: Interfund payable - - - - Property taxes - delinquent - - - - Total liabilities0000 Fund balance: Nonspendable - - - - Restricted459,693122,002461,811334,077 Total fund balance459,693122,002461,811334,077 Total liabilities and fund balance$459,693$122,002$461,811$334,077 116 Statement 31 Tax Increment Bonds Fund 376 Sheffield TIF Redevelopment Fund 377 TIF Multi-Use Redevelopment Plan Fund 385 TIF Transition Block Fund 389 TIF 47th and Central Avenue Fund 371 TIF Huset Park Area Fund 372 EDA TIF Revenue Bonds 2007 Fund 373 Total Nonmajor Debt Service Funds $276,651$83,073$77,686$68,247$406,713$213,827$251,944$2,749,135 - 2,44854 - 7,38512,223 - 26,699 8002002002001,0005005005,400 450,667 - - - 328,149 - - 778,816 $728,118$85,721$77,940$68,447$743,247$226,550$252,444$3,560,050 $1,163$195$195$195$195$11,369$ - $13,312 - - 14,377 - - - - 14,377 - 2,448 - - 1,0427,540 - 11,030 1,1632,64314,5721951,23718,909038,719 450,667 - - - 328,149 - - 778,816 276,28883,07863,36868,252413,861207,641252,4442,742,515 726,95583,07863,36868,252742,010207,641252,4443,521,331 $728,118$85,721$77,940$68,447$743,247$226,550$252,444$3,560,050 EDA Component Unit 117 CITY OF COLUMBIA HEIGHTS, MINNESOTA SUBCOMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE NONMAJOR DEBT SERVICE FUNDS For The Year Ended December 31, 2012 G.O. Improvement/ Revenue Bonds 2006A Fund 340 G.O. Street Rehabilitation Bonds 2007 Fund 341 G.O. Public Safety Center Bonds 2008B Fund 343 G.O. Public Facilities Bonds 2009A Fund 344 Revenues: Taxes$ - $134,465$429,168$125,186 Tax increment collections - - - - Intergovernmental - - - - Investment income: Interest and dividends3,5004002,0002,500 Change in fair value200 - 100200 Total revenues3,700134,865431,268127,886 Expenditures: Current: Other services and charges - - - - Capital outlay: Community development - - - - Debt service: Principal retirement419,00095,000200,000155,000 Interest and fiscal charges45,68030,900428,583131,911 Developer incentives - - - - Total expenditures464,680125,900628,583286,911 Revenues over (under) expenditures(460,980)8,965(197,315)(159,025) Other financing sources (uses): Transfers in198,379 - 160,79385,150 Transfers out - - - - Total other financing sources (uses)198,3790160,79385,150 Net change in fund balance(262,601)8,965(36,522)(73,875) Fund balance - January 1722,294113,037498,333407,952 Fund balance - December 31$459,693$122,002$461,811$334,077 118 Statement 32 Tax Increment Bonds Fund 376 Sheffield TIF Redevelopment Fund 377 TIF Multi-Use Redevelopment Plan Fund 385 TIF Transition Block Fund 389 TIF 47th and Central Avenue Fund 371 TIF Huset Park Area Fund 372 EDA TIF Revenue Bonds 2007 Fund 373 Intrafund Eliminations Total Nonmajor Debt Service Funds $ - $ - $ - $ - $ - $ - $ - $ - $688,819 - 71,84130,13945,37694,367325,536 - - 567,259 - - - - - - - - - 3,400 800 8006004,4002,2002,000 - 22,600 200 100 100 - 300 100100 - 1,400 3,60072,74131,03945,97699,067327,8362,100 01,280,078 2,907 2,085 1,6551,7153,4388,631 - - 20,431 185,895 - - - 243,686 - - - 429,581 - - - - - - 53,000 - 922,000 - 721 - - 26,410 - 147,014 - 811,219 - - 11,24020,383 - 84,449 - - 116,072 188,802 2,80612,89522,098273,53493,080200,014 02,299,303 (185,202)69,93518,14423,878(174,467)234,756(197,914)0(1,019,225) - - - - - - 205,000(205,000)444,322 - - - - - (205,000) - 205,000 - 0 0 0 0 0(205,000)205,000 0444,322 (185,202)69,93518,14423,878(174,467)29,7567,086 0(574,903) 912,15713,14345,22444,374916,477177,885245,358 - 4,096,234 $726,955$83,078$63,368$68,252$742,010$207,641$252,444 $0$3,521,331 EDA Component Unit 119 - This page intentionally left blank - 120 NONMAJOR CAPITAL PROJECT FUNDS The City of Columbia Heights had the following Nonmajor Capital Project Funds during the year: Economic Development Authority – a separate legal entity from the City. The mayor and City Council comprise the majority membership of this component unit. Its purpose is to foster economic development in the City. Housing Maintenance Fund 408 – established to account for activities to maintain the quality and quantity of housing in the City. Capital Improvement Parks Fund 412 – used to account for improvements in City parks. This includes park dedication fees when available, the use of which is limited by state statute to park improvements. Infrastructure Replacement Fund 430 – used to fund replacement of City infrastructure. Capital Equipment Fire Fund 439 – used to fund replacement of fire department capital assets. This fund is limited by state statute to fire department expenditures. The original source of the assets in this fund was excess funding in a fire pension plan. Capital Equipment Cable TV Fund 440 – used to fund replacement of cable television capital assets. Capital Building Library Fund 450 – used to fund replacement of the library building. 121 - This page intentionally left blank - 122 CITY OF COLUMBIA HEIGHTS, MINNESOTA SUBCOMBINING BALANCE SHEET Statement 33 NONMAJOR CAPITAL PROJECT FUNDS December 31, 2012 EDA (Component Unit) Housing Maintenance Fund 408 Capital Improvement Parks Fund 412 Infrastructure Replacement Fund 430 Capital Equipment Fire Fund 439 Capital Equipment Cable TV Fund 440 Capital Building Library Fund 450 Total Nonmajor Capital Project Funds Assets Cash and investments$ - $40,515$963,678$77,776$68,700$255,504$1,406,173 Due from other governments - 4,964 - - - - 4,964 Receivables: Interest - - 2,900300200 - 3,400 Real estate held for resale375,091 - - - - - 375,091 Total assets$375,091$45,479$966,578$78,076$68,900$255,504$1,789,628 Liabilities and Fund Balance Liabilities: Accounts payable$ - $ - $940$456$ - $ - $1,396 Contracts payable - retained percentage - 10,727 - - - - 10,727 Total liabilities010,7279404560012,123 Fund balance: Nonspendable 375,091 - - - - - 375,091 Restricted - - - - - - - Committed - 34,752965,63877,62068,900255,5041,402,414 Total fund balance375,09134,752965,63877,62068,900255,5041,777,505 Total liabilities and fund balance$375,091$45,479$966,578$78,076$68,900$255,504$1,789,628 123 CITY OF COLUMBIA HEIGHTS, MINNESOTA SUBCOMBINING STATEMENT OF REVENUES, EXPENDITURES AND Statement 34 CHANGES IN FUND BALANCE NONMAJOR CAPITAL PROJECT FUNDS For The Year Ended December 31, 2012 EDA (Component Unit) Housing Maintenance Fund 408 Capital Improvement Parks Fund 412 Infrastructure Replacement Fund 430 Capital Equipment Fire Fund 439 Capital Equipment Cable TV Fund 440 Capital Building Library Fund 450 Total Nonmajor Capital Project Funds Revenues: Intergovernmental$ - $5,064$ - $ - $ - $ - $5,064 Investment income: Interest and dividends - - 12,0001,400800 - 14,200 Change in fair value - - 800100100 - 1,000 Contributions - - - - - - - Total revenues05,06412,8001,500900020,264 Expenditures: Current: Other services and charges - 1,50543,17011,875 - - 56,550 Capital outlay18,38230,193 - 87,951 - - 136,526 Total expenditures18,38231,69843,17099,82600193,076 Revenue over (under) expenditures(18,382)(26,634)(30,370)(98,326)9000(172,812) Other financing sources (uses): Transfers in - 58,84150,000 - - - 108,841 Total other financing sources (uses)058,84150,000000108,841 Net change in fund balance(18,382)32,20719,630(98,326)9000(63,971) Fund balance - January 1393,4732,545946,008175,94668,000255,5041,841,476 Fund balance - December 31$375,091$34,752$965,638$77,620$68,900$255,504$1,777,505 124 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 members of the Proprietary Fund Type category, and, as such, are accounted for on the accrual basis of accounting. Revenues in the Enterprise Funds are recognized when they are earned and expenses are recognized when they are incurred. The Enterprise Funds are used to account for operations that are financed and/or operated in a manner similar to private business enterprises or where the governing body has decided that periodic determination of revenues earned, expenses incurred, and/or net income is appropriate for capital maintenance, public policy, management control, accountability, or other purposes. 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 of refuse and recycling in the City. Storm Sewer Utility Fund – used to account for revenues and expenses associated with storm water disposal. Liquor Fund – used to account for revenues and expenses associated with the operation of three off-sale municipal liquor stores. 125 CITY OF COLUMBIA HEIGHTS, MINNESOTA WATER UTILITY FUND Statement 35 SUBCOMBINING SCHEDULE OF NET POSITION December 31, 2012 With Comparative Totals for December 31, 2011 Operating Account Capital Equipment Replacement Account Capital Construction Account Debt Service Account Intrafund Eliminations Assets:20122011 Current assets: Cash and cash equivalents $7,949$337,806$3,764$192,662$ - $542,181$559,410 Receivables: Accounts (net of allowance for uncollectables)571,623 - - - - 571,623543,527 Interest 2,8001,500 - 300 - 4,6003,500 Interfund receivable 279,716251,162130,097 - (598,613)62,36212,041 Inventory - at cost 4,185 - - - - 4,1851,712 Total current assets 866,273590,468133,861192,962(598,613)1,184,9511,120,190 Noncurrent assets: Capital assets: Land 45,223 - - - - 45,22345,223 Buildings 559,826 - - - - 559,826559,826 Equipment 462,515 - - - - 462,515462,515 Infrastructure 8,346,965 - - - - 8,346,9657,524,209 Construction in process - - 7,006 - - 7,006479,626 Total capital assets 9,414,529 07,006 0 09,421,5359,071,399 Less: accumulated depreciation (4,263,186) - - - - (4,263,186)(4,044,729) Total capital assets (net of accumulated depreciation)5,151,343 07,006 0 05,158,3495,026,670 Total noncurrent assets 5,151,343 07,006 0 05,158,3495,026,670 Total assets 6,017,616590,468140,867192,962(598,613)6,343,3006,146,860 Liabilities : Current liabilities: Accounts payable 6,224 - - - - 6,22418,271 Accrued salaries and withholdings payable9,205 - 17 - - 9,2225,877 Due to other governmental units 79,401 - 204,085 - - 283,486302,698 Interfund payable 130,097 - 545,013323,000(598,613)399,497398,000 Accrued interest payable - - - 14,588 - 14,58816,795 Deposits 3,000 - - - - 3,000 - Compensated absences payable - current 1,533 - - - - 1,5333,330 Bonds payable - current - - - 161,862 - 161,862152,880 Total current liabilities 229,460 0749,115499,450(598,613)879,412897,851 Noncurrent liabilities: Compensated absences payable - noncurrent24,022 - - - - 24,02225,222 Bonds payable - noncurrent - - - 789,628 - 789,628951,490 Total noncurrent liabilities 24,022 0 0789,628 0813,650976,712 Total liabilities 253,482 0749,1151,289,078(598,613)1,693,0621,874,563 Net position: Net investments in capital assets 5,151,343 - 7,006(1,274,490) - 3,883,8593,524,300 Restricted for debt service - - - 178,374 - 178,374184,716 Unrestricted 612,791590,468(615,254) - - 588,005563,281 Total net position $5,764,134 $590,468 ($608,248)($1,096,116)$0 $4,650,238 $4,272,297 Totals 126 CITY OF COLUMBIA HEIGHTS, MINNESOTA WATER UTILITY FUND Statement 36 SUBCOMBINING SCHEDULE OF REVENUES, EXPENSES AND CHANGES IN FUND NET POSITION For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 Operating Account Capital Equipment Replacement Account Capital Construction Account Debt Service Account Intrafund Eliminations Operating revenues:20122011 Charges for services: Customer services$114,635$ - $ - $ - $ - $114,635$101,111 Penalties68,095 - - - - 68,09555,819 Charges for sales: Water 2,508,525 - - - - 2,508,5252,290,210 Meter8,11758,50013,891 - - 80,50882,853 Total operating revenues2,699,37258,50013,891002,771,7632,529,993 Operating expenses: Cost of sales1,232,031 - - - - 1,232,0311,192,653 Distribution634,060 - 128,369 - - 762,429852,475 Administration21,489 - - - - 21,48918,426 Depreciation218,456 - - - - 218,456204,716 Total operating expenses2,106,036 0 128,369 0 0 2,234,405 2,268,270 Net income (loss) from operations593,336 58,500 (114,478)0 0 537,358 261,723 Nonoperating revenues (expenses): Investment income12,4006,800 - 1,200 - 20,40034,000 Miscellaneous revenues5,620 - - - - 5,620505 Interest and fiscal charges - - - (52,093) - (52,093)(58,425) Total nonoperating revenues (expenses)18,020 6,800 0 (50,893)0 (26,073)(23,920) Net income (loss) before transfers611,356 65,300 (114,478)(50,893)0 511,285 237,803 Transfers in - 25,00066,909291,000(382,909) - 2,943 Transfers out(516,253) - - - 382,909(133,344)(135,963) Total transfers(516,253)25,000 66,909 291,000 0 (133,344)(133,020) Change in net position95,103 90,300 (47,569)240,107 0 377,941 104,783 Total net position - January 15,669,031500,168(560,679)(1,336,223) - 4,272,297 4,167,514 Total net position - December 31$5,764,134$590,468($608,248)($1,096,116)$0$4,650,238$4,272,297 Totals 127 CITY OF COLUMBIA HEIGHTS, MINNESOTA WATER UTILITY FUND Statement 37 SUBCOMBINING SCHEDULE OF CASH FLOWS For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 20122011 Cash flows from operating activities: Cash received from customers$2,749,287$2,519,587 Cash paid to suppliers for goods and services(1,706,743)(1,475,703) Cash payments to employees for services(339,588)(366,427) Net cash flows from operating activities702,956677,457 Cash flows from noncapital financing activities: Transfers in - 474,600 Transfers out (133,344)(607,620) Interfund receivable repaid by (advanced to) other funds8,179(817,339) Interfund payable (repaid to) advanced by other funds(57,003)1,222,245 Net cash flows from noncapital financing activities(182,168)271,886 Cash flows from capital and related financing activities: Acquisition of capital assets(350,137)(427,862) Principal payments - bonds(152,880)(666,203) Interest and fiscal charges(54,300)(68,680) Net cash flows from capital and related financing activities(557,317)(1,162,745) Cash flows from investing activities: Investment income: Interest and dividends18,00022,200 Change in fair value1,30012,100 Net cash flows from investing activities19,30034,300 Net increase (decrease) in cash and cash equivalents(17,229)(179,102) Cash and cash equivalents - January 1559,410738,512 Cash and cash equivalents - December 31$542,181$559,410 Reconciliation of operating income to net cash flows from operating activities: Operating income $537,358$261,723 Adjustments to reconcile operating income to net cash flows from operating activities: Depreciation expense218,456204,716 Miscellaneous revenues5,620505 Changes in assets and liabilities: (Increase) decrease in accounts receivable(28,096)(10,911) (Increase) decrease in inventory, at cost(2,473)431 Increase (decrease) in accounts payable(12,045)10,412 Increase (decrease) in accrued salaries and withholdings payable3,345(3,857) Increase (decrease) in due to other governmental units(19,212)4,684 Adjustment for nonoperating portion - 205,722 Increase (decrease) in deposits payable3,000 - Increase (decrease) in compensated absences payable(2,997)4,032 Total adjustments165,598415,734 Net cash flows from operating activities$702,956$677,457 128 CITY OF COLUMBIA HEIGHTS, MINNESOTA SEWER UTILITY FUND Statement 38 SUBCOMBINING SCHEDULE OF NET POSITION December 31, 2012 With Comparative Totals for December 31, 2011 Operating Account Capital Equipment Replacement Account Capital Construction Account Assets:20122011 Current assets: Cash and cash equivalents$158,049$478,888$710,067$1,347,004$1,759,137 Receivables: Accounts (net of allowance for uncollectibles)419,781 - - 419,781370,478 Interest 2,0001,4001,0004,4005,500 Interfund receivables22,858 - - 22,85875,229 Prepayments76,968 - - 76,96874,917 Total current assets679,656480,288711,0671,871,0112,285,261 Noncurrent assets: Capital assets: Land 36,586 - - 36,58636,586 Buildings100,426 - - 100,426100,426 Equipment840,942 - - 840,942840,942 Construction in progress - - 252,924252,924550,773 Infrastructure6,154,219 - - 6,154,2195,482,680 Total capital assets7,132,1730252,9247,385,0977,011,407 Less: accumulated depreciation(4,277,960) - - (4,277,960)(4,146,206) Net capital assets 2,854,213 0252,9243,107,1372,865,201 Total noncurrent assets 2,854,213 0 252,924 3,107,137 2,865,201 Total assets 3,533,869480,288963,9914,978,1485,150,462 Liabilities: Current liabilities: Accounts payable 815 - 14,79915,614228,179 Accrued salaries and withholdings payable 4,733 - - 4,7336,965 Contracts payable - retained percentage 31,100 - 11,81542,91542,760 Compensated absences payable - current 2,240 - - 2,2403,731 Total current liabilities 38,888 026,61465,502281,635 Noncurrent liabilities: Compensated absences payable - noncurrent35,087 - - 35,08728,260 Total noncurrent liabilities35,0870035,08728,260 Total liabilities73,975026,614100,589309,895 Net position: Net investments in capital assets 2,854,213 - 252,9243,107,1372,865,201 Unrestricted 605,681480,288684,4531,770,4221,975,366 Total net position $3,459,894$480,288$937,377$4,877,559$4,840,567 Totals 129 CITY OF COLUMBIA HEIGHTS, MINNESOTA SEWER UTILITY FUND Statement 39 SUBCOMBINING SCHEDULE OF REVENUES, EXPENSES AND CHANGES IN FUND NET POSITION For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 Operating Account Capital Equipment Replacement Account Capital Construction Account Interfund Eliminations Operating revenues:20122011 Charges for services: Sewer service charges$1,579,864$ - $ - $ - $1,579,864$1,521,142 Operating expenses: Disposal899,008 - - - 899,008901,096 Collection350,512 - 28,950 - 379,462571,540 Administration21,378 - - - 21,37819,335 Depreciation131,755 - - - 131,755170,740 Total operating expenses1,402,653028,95001,431,6031,662,711 Net income (loss) from operations177,2110(28,950)0148,261(141,569) Nonoperating revenues: Investment income9,0006,2005,221 - 20,42157,332 Miscellaneous revenues1,652 - - - 1,6522,710 Total nonoperating revenues10,652 6,200 5,221 0 22,073 60,042 Net income (loss) before transfers187,863 6,200 (23,729)0 170,334 (81,527) Transfers in - 25,00028,960(53,960) - - Transfers out(187,302) - - 53,960(133,342)(138,905) Total transfers(187,302)25,000 28,960 0 (133,342)(138,905) Change in net position561 31,200 5,231 0 36,992 (220,432) Net position - January 13,459,333449,088932,146 - 4,840,5675,060,999 Net position - December 31$3,459,894$480,288$937,377$0$4,877,559$4,840,567 Totals 130 CITY OF COLUMBIA HEIGHTS, MINNESOTA SEWER UTILITY FUND Statement 40 SUBCOMBINING SCHEDULE OF CASH FLOWS For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 20122011 Cash flows from operating activities: Cash received from customers$1,532,212 $1,499,250 Cash paid to suppliers for goods and services(1,285,953)(1,026,583) Cash payments to employees for services(225,252)(221,327) Net cash flows from operating activities21,007251,340 Cash flows from noncapital financing activities: Transfers in - 131,172 Transfers out (133,342)(270,077) Interfund receivable repaid by other funds52,37136,060 Net cash flows from noncapital financing activities(80,971)(102,845) Cash flows from capital and related financing activities: Acquisition of capital assets(373,690)(448,083) Cash flows from investing activities: Investment income: Interest and dividends20,22141,432 Change in fair value 1,30018,900 Net cash flows from investing activities21,521 60,332 Net increase (decrease) in cash and cash equivalents(412,133)(239,256) Cash and cash equivalents - January 11,759,137 1,998,393 Cash and cash equivalents - December 31$1,347,004 $1,759,137 Reconciliation of operating income (loss) to net cash flows from operating activities: Operating income (loss)$148,261 ($141,569) Adjustments to reconcile operating income (loss) to net cash flows from operating activities: Depreciation expense131,755170,740 Miscellaneous revenues1,6522,710 Changes in assets and liabilities: (Increase) decrease in accounts receivable(49,304)(24,602) (Increase) decrease in prepayments(2,051)174 Increase (decrease) in accounts payable(212,565)223,791 Increase (decrease) in accrued salaries and withholdings payable(2,232)3,119 Increase (decrease) in contracts payable -retained percentage15511,660 Increase (decrease) compensated absences payable5,3365,317 Total adjustments(127,254)392,909 Net cash flows from operating activities$21,007$251,340 131 CITY OF COLUMBIA HEIGHTS, MINNESOTA REFUSE UTILITY FUND Statement 41 SUBCOMBINING SCHEDULE OF NET POSITION December 31, 2012 With Comparative Totals for December 31, 2011 20122011 Assets: Current assets: Cash and cash equivalents $792,091 $789,747 Receivables: Accounts (net of allowance for uncollectibles)466,365 432,529 Interest 2,300 2,200 Due from other governmental units 5,034 - Total current assets 1,265,790 1,224,476 Noncurrent assets: Capital assets: Buildings 56,000 6,000 Equipment 112,893 108,690 Total capital assets 168,893 114,690 Less: accumulated depreciation (114,975)(113,490) Total capital assets (net of accumulated depreciation)53,918 1,200 Total noncurrent assets 53,918 1,200 Total assets 1,319,708 1,225,676 Liabilities: Current liabilities: Accounts payable 112,898 227,885 Accrued salaries and withholdings payable 1,467 3,007 Compensated absences payable - current 301 588 Total current liabilities 114,666 231,480 Noncurrent liabilities: Compensated absences payable - noncurrent 4,720 4,451 Total liabilities 119,386 235,931 Net position: Net investments in capital assets 53,918 1,200 Unrestricted 1,146,404 988,545 Total net position $1,200,322 $989,745 132 CITY OF COLUMBIA HEIGHTS, MINNESOTA REFUSE UTILITY FUND Statement 42 SUBCOMBINING SCHEDULE OF REVENUES, EXPENSES AND CHANGES IN FUND NET POSITION For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 20122011 Operating revenues: Refuse service charges1,761,860$1,682,178 Operating expenses: Collection and disposal1,415,8851,381,227 Administration 53,31959,251 Recycling 84,85561,127 Hazardous waste 3,2492,626 Depreciation 1,485300 Total operating expenses1,558,793 1,504,531 Net income from operations203,067 177,647 Nonoperating revenues: Investment income10,50021,000 Intergovernmental112,47166,163 Total nonoperating revenues122,971 87,163 Net income before transfers326,038 264,810 Transfers out (115,461)(117,859) Change in net position210,577 146,951 Total net position - January 1989,745842,794 Total net position - December 31$1,200,322$989,745 133 CITY OF COLUMBIA HEIGHTS, MINNESOTA REFUSE UTILITY FUND Statement 43 SUBCOMBINING SCHEDULE OF CASH FLOWS For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 20122011 Cash flows from operating activities: Cash received from customers$1,728,024$1,629,104 Cash paid to suppliers for goods and services(1,597,081)(1,305,582) Cash payments to employees for services(76,772)(75,568) Net cash flows from operating activities54,171 247,954 Cash flows from noncapital financing activities: Transfers out (115,461)(117,859) Intergovernmental 112,47166,163 Interfund receivable repaid by (advanced to) other funds(5,034) - Net cash flows from noncapital financing activities(8,024)(51,696) Cash flows from capital and related financing activities: Acquisition of capital assets(54,203) - Cash flows from investing activities: Investment income: Interest and dividends9,70013,800 Change in fair value 7007,500 Net cash flows from investing activities10,400 21,300 Net increase in cash and cash equivalents2,344 217,558 Cash and cash equivalents - January 1789,747572,189 Cash and cash equivalents - December 31$792,091 $789,747 Reconciliation of operating income to net cash flows from operating activities: Operating income $203,067$177,647 Adjustments to reconcile operating income to net cash flows from operating activities: Depreciation expense1,485300 Changes in assets and liabilities: (Increase) decrease in accounts receivable(33,836)(53,074) Increase (decrease) in accounts payable(114,987)121,464 Increase (decrease) in accrued salaries and withholdings payable(1,540)1,858 Increase (decrease) compensated absences payable(18)(241) Total adjustments(148,896)70,307 Net cash flows from operating activities$54,171$247,954 134 CITY OF COLUMBIA HEIGHTS, MINNESOTA STORM SEWER UTILITY FUND Statement 44 SUBCOMBINING SCHEDULE OF NET POSITION December 31, 2012 With Comparative Totals for December 31, 2011 Operating Account Capital Equipment Replacement Account Capital Construction Account Debt Service Account Intrafund Eliminations Assets:20122011 Current assets: Cash and cash equivalents$756$ - $ - $37,220$ - $37,976$36,111 Receivables: Accounts (net of allowance for uncollectibles)92,357 - - - - 92,35785,589 Interest - - 401101 - 502500 Interfund receivable - - 193,075 - (193,075) - - Total current assets93,1130193,47637,321(193,075)130,835122,200 Noncurrent assets: Capital assets: Land260,690 - - - - 260,690254,724 Equipment190,653 - - - - 190,653190,653 Infrastructure1,518,512 - - - - 1,518,5121,477,536 Construction in process - - - - - - 39,348 Total capital assets1,969,85500001,969,8551,962,261 Less: accumulated depreciation(716,540) - - - - (716,540)(632,546) Net capital assets1,253,31500001,253,3151,329,715 Total noncurrent assets1,253,31500001,253,3151,329,715 Total assets1,346,4280193,47637,321(193,075)1,384,1501,451,915 Liabilities: Current liabilities: Accounts payable40 - - - - 403,380 Accrued salaries and withholdings payable1,934 - - - - 1,9342,251 Interfund payable103,02994,908 - 82,000(193,075)86,862146,630 Accrued interest payable - - - 2,838 - 2,8383,307 Compensated absences payable - current 84 - - - - 84 91 Bonds payable - current - - - 30,638 - 30,63828,120 Total current liabilities 105,08794,908 0115,476(193,075)122,396183,779 Noncurrent liabilities: Compensated absences payable - noncurrent 1,317 - - - - 1,317693 Bonds payable - noncurrent - - - 141,142 - 141,142171,780 Total noncurrent liabilities1,31700141,1420142,459172,473 Total liabilities106,40494,9080256,618(193,075)264,855356,252 Net position: Net investment in capital assets1,253,315 - - (171,780) - 1,081,5351,028,815 Restricted for debt service - - - - - 33,979 Unrestricted (13,291)(94,908)193,476(47,517) - 37,76032,869 Total net position $1,240,024($94,908)$193,476($219,297)$0$1,119,295$1,095,663 Totals 135 CITY OF COLUMBIA HEIGHTS, MINNESOTA STORM SEWER UTILITY FUND Statement 45 SUBCOMBINING SCHEDULE OF REVENUES, EXPENSES AND CHANGES IN FUND NET POSITION For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 Operating Account Capital Equipment Replacement Account Capital Construction Account Debt Service Account Intrafund Eliminations 20122011 Operating revenues: Storm sewer service charges$349,457$ - $ - $ - $ - $349,457$349,964 Operating expenses: Collection218,772 - 16,699 - - 235,471205,003 Administration1,646 - - - - 1,6461,601 Depreciation83,993 - - - - 83,99381,450 Total operating expenses304,411016,69900321,110288,054 Net income (loss) from operations45,0460(16,699)0028,34761,910 Nonoperating revenues (expenses): Investment income - - 2,000200 - 2,2004,700 Miscellaneous revenues3,886 - - - - 3,886654 Interest and fiscal charges - - - (10,801) - (10,801)(12,245) Total nonoperating revenues (expenses)3,886 0 2,000 (10,601)0 (4,715)(6,891) Net income (loss) before transfers48,932 0 (14,699)(10,601)0 23,632 55,019 Transfers in - 5,00016,69963,000(84,699) - 8,750 Transfers out(84,699) - - - 84,699 - - Total transfers and contributions(84,699)5,000 16,699 63,000 0 0 8,750 Change in net position(35,767)5,000 2,000 52,399 0 23,632 63,769 Net position - January 11,275,791(99,908)191,476(271,696) - 1,095,6631,031,894 Net position - December 31$1,240,024($94,908)$193,476($219,297)$0$1,119,295$1,095,663 Totals 136 CITY OF COLUMBIA HEIGHTS, MINNESOTA STORM SEWER UTILITY FUND Statement 46 SUBCOMBINING SCHEDULE OF CASH FLOWS For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 20122011 Cash flows from operating activities: Cash received from customers$346,576 $343,664 Cash paid to suppliers for goods and services(116,644)(87,642) Cash payments to employees for services(123,513)(119,070) Net cash flows from operating activities106,419136,952 Cash flows from noncapital financing activities: Interfund receivable repaid by (advanced to) other funds - (148,028) Interfund payable (repaid to) advanced by other funds(59,768)294,658 Net cash flows from noncapital financing activities:(59,768)146,630 Cash flows from capital and related financing activities: Acquisition of capital assets(7,594)(86,184) Principal payments - bonds(28,120)(157,775) Interest and fiscal charges(11,270)(14,669) Net cash flows from capital and related financing activities(46,984)(258,628) Cash flows from investing activities: Investment income: Interest and dividends2,0983,400 Change in fair value 1001,700 Net cash flows from investing activities2,198 5,100 Net increase in cash and cash equivalents1,865 30,054 Cash and cash equivalents - January 136,1116,057 Cash and cash equivalents - December 31$37,976 $36,111 Reconciliation of operating income to net cash flows from operating activities: Operating income $28,347 $61,910 Adjustments to reconcile operating income to net cash flows from operating activities: Depreciation expense83,99381,450 Miscellaneous revenue3,886654 Changes in assets and liabilities: (Increase) decrease in accounts receivable(6,767)(6,954) Increase (decrease) in accounts payable(3,340)148 Increase (decrease) in accrued salaries and withholdings payable(317)255 Increase (decrease) compensated absences payable617(511) Total adjustments78,072 75,042 Net cash flows from operating activities$106,419$136,952 Noncash capital and related financing activities: Contribution of capital asset from government$ - $8,750 137 - This page intentionally left blank - 138 CITY OF COLUMBIA HEIGHTS, MINNESOTA LIQUOR FUND Statement 47 SUBCOMBINING SCHEDULE OF NET POSITION December 31, 2012 With Comparative Totals for December 31, 2011 OperatingDebt ServiceIntrafund Totals AccountAccountEliminations20122011 Assets: Current assets: Cash and cash equivalents $335,149$272,549$ - $607,698$277,781 Cash and cash equivalents with fiscal agent - 399,254 - 399,254399,254 Receivables: Accounts (net of allowance for uncollectables 161 - - 161 269 Interest - 200 - 200 200 Due from other governmental units 475 - - 4751,228 Prepayments - 72,560 - 72,56097,431 Inventory - at cost 2,542,372 - - 2,542,3722,356,582 Total current assets 2,878,157744,563 - 3,622,7203,132,745 Noncurrent assets: Capital assets: Land 2,006,714 - - 2,006,7142,006,714 Buildings 3,915,062 - - 3,915,0623,915,062 Equipment 413,202 - - 413,202386,314 Total capital assets 6,334,978 0 06,334,9786,308,090 Less: accumulated depreciation (823,602) - - (823,602)(673,314) Net capital assets 5,511,376 0 05,511,3765,634,776 Total noncurrent assets 5,511,376 0 05,511,3765,634,776 Total assets 8,389,533744,563 09,134,0968,767,521 Liabilities: Current liabilities: Accounts payable 400,342 - - 400,342238,904 Accrued salaries and withholdings payable 23,364 - - 23,36420,127 Due to other governmental units 93,033 - - 93,03395,098 Accrued interest payable - 100,563 - 100,563103,747 Compensated absences payable - current 5,222 - - 5,2229,698 Bonds payable - current - 165,000 - 165,000155,000 Total current liabilities 521,961265,563 - 787,524622,574 Noncurrent liabilities: Compensated absences payable - noncurrent81,816 - - 81,81673,463 Bonds payable - noncurrent - 4,430,000 - 4,430,0004,595,000 Total noncurrent liabilities 81,8164,430,000 04,511,8164,668,463 Total liabilities 603,7774,695,563 05,299,3405,291,037 Net position: Net investments in capital assets 5,511,376(4,595,000) - 916,3761,363,961 Restricted for debt service - 644,000 - 644,000162,769 Unrestricted 2,274,380 - - 2,274,3801,949,754 Total net position $7,785,756($3,951,000)$0$3,834,756$3,476,484 139 CITY OF COLUMBIA HEIGHTS, MINNESOTA LIQUOR FUND SUBCOMBINING SCHEDULE OF REVENUES, EXPENSES AND CHANGES IN FUND NET POSITION For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 Operating Accounts TopHeights Top ValuValu IILiquor Operating revenues: Charges for sales: Liquor$1,512,508$1,278,804$491,373 Beer1,569,2391,547,657563,869 Wine629,048637,03170,524 Other176,817186,985140,378 Total operating revenues3,887,612 3,650,477 1,266,144 Operating expenses: Cost of goods sold2,913,6632,739,4641,001,530 Operating expense615,600514,332185,464 Depreciation83,58762,2644,436 Total operating expenses3,612,850 3,316,060 1,191,430 Net income from operations$274,762$334,417$74,714 Nonoperating revenues (expenses): Investment income: Interest and dividends Interest and fiscal charges Total nonoperating revenues (expenses) Net income (loss) before transfers Transfers in Transfers out Total transfers Change in net position Net position - January 1 Net position - December 31 140 Statement 48 TotalDebt OperatingServiceIntrafundTotals AccountsAccountEliminations20122011 $3,282,685$ - $ - $3,282,685$3,187,590 3,680,765 - - 3,680,7653,562,603 1,336,603 - - 1,336,6031,244,315 504,180 - - 504,180500,454 8,804,233 0 0 8,804,233 8,494,962 6,654,657 - - 6,654,6576,413,886 1,315,396 - - 1,315,3961,310,983 150,287 - - 150,287148,673 8,120,340 0 0 8,120,340 7,873,542 683,8930 0 683,893 621,420 - 1,000 - 1,0001,500 - (229,954) - (229,954)(237,147) 0 (228,954)0 (228,954)(235,647) 683,893(228,954)0 454,939 385,773 - 386,000(386,000) - - (482,667) - 386,000(96,667)(98,955) (482,667)386,0000(96,667)(98,955) 201,226157,0460358,272286,818 7,584,530(4,108,046) - 3,476,4843,189,666 $7,785,756($3,951,000)$0$3,834,756$3,476,484 141 CITY OF COLUMBIA HEIGHTS, MINNESOTA LIQUOR FUND Statement 49 SUBCOMBINING SCHEDULE OF CASH FLOWS Page 1 of 2 For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 20122011 Cash flows from operating activities: Cash received from customers$8,805,094$8,495,572 Cash paid to suppliers for goods and services(7,028,496)(6,684,150) Cash payments to employees for services(960,860)(929,242) Net cash flows from operating activities815,738882,180 Cash flows from noncapital financing activities Transfers in - 390,000 Transfers out (96,667)(488,955) Interfund payable (repaid to) advanced by other funds - (102,815) Net cash flows from noncapital financing activities(96,667)(201,770) Cash flows from capital and related financing activities: Acquisition of capital assets(26,887)(11,099) Principal payments - bonds(155,000)(150,000) Interest and fiscal charges - including capitalized interest(208,267)(250,130) Net cash flows from capital and related financing activities(390,154)(411,229) Cash flows from investing activities: Investment income: Interest and dividends 9001,100 Change in fair value 100500 Net cash flows from investing activities1,000 1,600 Net increase in cash and cash equivalents329,917 270,781 Total cash and cash equivalents - January 1677,035406,254 Total cash and cash equivalents - December 311,006,952 677,035 (Less) cash and cash equivalents with fiscal agent - December 31(399,254)(399,254) Cash and cash equivalents - December 31$607,698$277,781 142 CITY OF COLUMBIA HEIGHTS, MINNESOTA LIQUOR FUND Statement 49 SUBCOMBINING SCHEDULE OF CASH FLOWS Page 2 of 2 For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 20122011 Reconciliation of operating income to net cash flows from operating activities: Operating income $683,893$621,420 Adjustments to reconcile operating income to net cash flows from operating activities: Depreciation expense150,287148,673 Changes in assets and liabilities: (Increase) decrease in accounts receivable108147 (Increase) decrease in due from other governmental units753463 (Increase) decrease in prepayments24,871(9,902) AAdjustment for nonoperating portion (24,871)9,902 (Increase) decrease in inventory, at cost (185,790)(35,966) Increase (decrease) in accounts payable AAdjustment for nonoperating portion 161,438 121,198 Increase (decrease) in accrued salaries and withholdings payable Adjustment for nonoperating portion 3,237 1,637 Increase (decrease) in due to other governmental units (2,065)7,490 Increase (decrease) in compensated absences payable 3,877 17,118 Total adjustments 131,845 260,760 Net cash flows from operating activities $815,738 $882,180 Noncash capital and related financing activities: Capital assets purchased/constructed on account $ - $2,290 143 - This page intentionally left blank - 144 INTERNAL SERVICE FUNDS 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. Information Systems Fund – used to account for the costs associated with information systems within the City. All costs are recorded in the fund and are financed by transfers from user departments. Insurance Fund – used to account for certain costs of the City’s risk management services and to build a reserve for catastrophic losses. All costs for premiums, claims and claims administration are recorded in the fund and allocated to user funds based on a percentage risk factor. Compensated Absences Fund – used to account for funds that have been set aside by the City Council for compensated absences earned by employees’ services to the City’s governmental funds. Funds set aside for the compensated absences earned by employees’ services to the City’s proprietary funds are recorded directly in each particular proprietary fund. 145 CITY OF COLUMBIA HEIGHTS, MINNESOTA INTERNAL SERVICE FUNDS Statement 50 COMBINING STATEMENT OF NET POSITION December 31, 2012 Central Garage Information SystemsInsurance Compensated Absences Total Internal Service Funds Assets: Current assets: Cash and cash equivalents $588,846$678,823$1,038,439$912,138$3,218,246 Interest receivable 1,7002,0002,900 - 6,600 Prepayments - - 48,082 - 48,082 Accounts receivable - - 2,819 - 2,819 Inventory - at cost 68,678 - - - 68,678 Total current assets 659,224680,8231,092,240912,1383,344,425 Noncurrent assets: Capital assets: Land 15,779 - - - 15,779 Buildings 1,812,838 - - - 1,812,838 Equipment 208,137195,300 - - 403,437 Construction in progress 68,770 - - - 68,770 Total capital assets 2,105,524195,300 0 02,300,824 Less: accumulated depreciation (797,721)(152,671) - - (950,392) Net capital assets 1,307,80342,629 0 01,350,432 Total noncurrent assets 1,307,80342,629 0 01,350,432 Total assets 1,967,027 723,452 1,092,240 912,138 4,694,857 Liabilities: Current liabilities: Accounts payable 45,2351,830 - - 47,065 Contracts payable - - - - - Accrued salaries and withholdings payable 4,3595,289 - - 9,648 Deferred revenue 7,450 - - - 7,450 Compensated absences payable - current 2,243 946 - 54,81358,002 Total current liabilities 59,287 8,065 0 54,813 122,165 Noncurrent liabilities: Compensated absences payable - noncurrent35,14314,819 - 858,738908,700 Total liabilities 94,430 22,884 0 913,551 1,030,865 Net position: Net investments in capital assets 1,307,80342,629 - - 1,350,432 Unrestricted 564,794657,9391,092,240(1,413)2,313,560 Total net position $1,872,597$700,568$1,092,240($1,413)$3,663,992 146 CITY OF COLUMBIA HEIGHTS, MINNESOTA INTERNAL SERVICE FUNDS Statement 51 COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND NET POSITION For The Year Ended December 31, 2012 Central Garage Information SystemsInsurance Compensated Absences Interfund Eliminations Total Internal Service Funds Operating revenues: Charges for services: Services to departments$179,376$ - $508,546$ - $ - $687,922 Use of space300,478 - - - - 300,478 Recovery of damages - - 19,255 - - 19,255 Charges for sales: Sales of motor fuel156,113 - - - - 156,113 Total operating revenues635,967 0 527,801 0 0 1,163,768 Operating expenses: Cost of services and space505,056262,230374,819 - - 1,142,105 Depreciation62,65618,629 - - - 81,285 Total operating expenses567,712 280,859 374,819 0 0 1,223,390 Net income (loss) from operations68,255(280,859)152,98200(59,622) Nonoperating revenues (expenses): Investment income7,4008,80012,800 - - 29,000 Miscellaneous expense - - (21,019) - - (21,019) Total nonoperating revenues (expenses)7,400 8,800 (8,219)0 0 7,981 Net income (loss) before transfers75,655 (272,059)144,763 0 0(51,641) Transfers in4,000325,000 - - (35,000)294,000 Transfers out(39,000) - - - 35,000(4,000) Total transfers and capital contributions(35,000)325,000 0 0 0 290,000 Change in net position40,655 52,941 144,763 0 0238,359 Net position - January 11,831,942647,627947,477(1,413) - 3,425,633 Net position - December 31$1,872,597 $700,568 $1,092,240 ($1,413)$0 $3,663,992 147 CITY OF COLUMBIA HEIGHTS, MINNESOTA INTERNAL SERVICE FUNDS Statement 52 COMBINING STATEMENT OF CASH FLOWS For The Year Ended December 31, 2012 Central GarageInfo SysInsuranceComp Abs Total Internal Service Funds Cash flows from operating activities: Cash received from interfund goods and services provided$635,967$ - $508,546$438,786$1,583,299 Cash received for damages - - 19,255 - 19,255 Cash paid to suppliers for goods and services(388,293)(47,896)(399,133) - (835,322) Cash payments to employees for services(214,609)(214,827) - (433,764)(863,200) Net cash flows from operating activities33,065(262,723)128,6685,022(95,968) Cash flows from noncapital financing activities: Transfers in - 325,000 - - 325,000 Transfers out(35,000) - - - (35,000) Net cash flows from noncapital financing activities(35,000)325,000 0 0 290,000 Cash flows from capital and related financing activities: Acquisition of capital assets(48,646)(12,596) - - (61,242) Cash flows from investing activities: Investment income: Interest and dividends6,8008,40011,400 - 26,600 Change in fair value400200800 - 1,400 Net cash flows from investing activities7,2008,60012,200028,000 Net increase (decrease) in cash and cash equivalents(43,381)58,281 140,868 5,022 160,790 Cash and cash equivalents - January 1632,227620,542897,571907,1163,057,456 Cash and cash equivalents - December 31$588,846 $678,823 $1,038,439 $912,138 $3,218,246 Reconciliation of operating income (loss) to net cash flows from operating activities: Operating income (loss)$68,255($280,859)$152,982$ - ($59,622) Adjustments to reconcile operating income (loss) to net cash flows from operating activities: Depreciation expense62,65618,629 - - 81,285 Miscellaneous expense - - (21,019) - (21,019) Changes in assets and liabilities: (Increase) decrease in accounts receivable196 - (22) - 174 (Increase) decrease in prepayments - - (1,273) - (1,273) (Increase) decrease in inventory, at cost(10,105) - - - (10,105) Increase (decrease) in accounts payable(90,082)(2,203)(2,000) - (94,285) Increase (decrease) in accrued - - - - - salaries and withholdings payable703(2,473) - - (1,770) Increase (decrease) in compensated absences payable1,2254,183 - 5,02210,430 Increase (decrease) in deferred revenue217 - - - 217 Total adjustments(35,190)18,136 (24,314)5,022 (36,346) Net cash flows from operating activities$33,065($262,723)$128,668$5,022($95,968) 148 CITY OF COLUMBIA HEIGHTS, MINNESOTA CENTRAL GARAGE FUND Statement 53 SUBCOMBINING SCHEDULE OF NET POSITION December 31, 2012 With Comparative Totals For December 31, 2011 Capital Equipment OperatingReplacement Totals AccountAccount2012 2011 Assets: Current assets: Cash and cash equivalents $552,810$36,036$588,846$632,227 Interest receivable 1,600 100 1,700 1,500 Accounts receivable - - - 196 Inventory - at cost 68,678 - 68,67858,573 Total current assets 623,08836,136659,224692,496 Noncurrent assets: Capital assets: Land 15,779 - 15,77915,779 Buildings 1,812,838 - 1,812,8381,780,253 Equipment 208,137 - 208,137198,911 Construction in progress 68,770 - 68,77061,935 Total capital assets 2,105,524 02,105,5242,056,878 Less: Accumulated depreciation (797,721) - (797,721)(735,065) Net capital assets 1,307,803 01,307,8031,321,813 Total noncurrent assets 1,307,803 01,307,8031,321,813 Total assets 1,930,89136,1361,967,0272,014,309 Liabilities: Current liabilities: Accounts payable 45,235 - 45,235120,886 Contracts payable - - - 14,431 Accrued salaries and withholdings payable 4,359 - 4,359 3,656 Deferred revenue 7,450 - 7,450 7,233 Compensated absences payable - current 2,243 - 2,243 4,217 Total current liabilities 59,287 0 59,287 150,423 Noncurrent liabilities: Compensated absences payable - noncurrent 35,143 - 35,14331,944 Total liabilities 94,430 0 94,430 182,367 Net position: Net investments in capital assets 1,307,803 - 1,307,8031,321,813 Unrestricted 528,65836,136564,794510,129 Total net position $1,836,461$36,136$1,872,597$1,831,942 149 CITY OF COLUMBIA HEIGHTS, MINNESOTA CENTRAL GARAGE FUND Statement 54 SUBCOMBINING SCHEDULE OF REVENUES, EXPENSES AND CHANGES IN FUND NET POSITION For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 Capital Equipment OperatingReplacementIntrafundTotals AccountAccountEliminations20122011 Operating revenues: Charges for services: Services to departments$179,376$ - $ - $179,376$174,719 Use of space300,478 - - 300,478283,188 Charges for sales: Sales of motor fuel156,113 - - 156,113174,493 Total operating revenues635,967 0 0 635,967632,400 Operating expenses: Cost of services and space505,056 - - 505,056511,753 Depreciation62,656 - - 62,65651,607 Total operating expenses567,712 0 0 567,712563,360 Net income from operations68,2550 0 68,25569,040 Nonoperating revenues: Investment income: Interest and dividends6,600400 - 7,0009,100 Change in fair value400 - - 4005,100 Total nonoperating revenues7,00040007,40014,200 Net income before transfers75,255400075,655 83,240 Transfers in - 4,000 - 4,000188,272 Transfers out(39,000) - - (39,000)(36,500) Total transfers(39,000)4,000 0 (35,000)151,772 Change in net position36,255 4,400 0 40,655 235,012 Total net position - January 11,800,20631,736 - 1,831,9421,596,930 Total net position - December 31$1,836,461 $36,136 $0 $1,872,597 $1,831,942 150 CITY OF COLUMBIA HEIGHTS, MINNESOTA CENTRAL GARAGE FUND Statement 55 SUBCOMBINING SCHEDULE OF CASH FLOWS For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 20122011 Cash flows from operating activities: Cash received from interfund goods & services provided$635,967$632,204 Cash paid to suppliers for goods and services(388,293)(211,688) Cash payments to employees for services(214,609)(196,356) Net cash flows from operating activities33,065 224,160 Cash flows from noncapital financing activities: Transfers in - 192,272 Transfers out (35,000)(40,500) Net cash flows from noncapital financing activities:(35,000)151,772 Cash flows from capital and related financing activities: Acquisition of capital assets(48,646)(256,195) Cash flows from investing activities: Investment income: Interest and dividends6,8009,200 Change in fair value 4005,100 Net cash flows from investing activities7,20014,300 Net increase (decrease) in cash and cash equivalents(43,381)134,037 Cash and cash equivalents - January 1632,227498,190 Cash and cash equivalents - December 31$588,846 $632,227 Reconciliation of operating income to net cash flows from operating activities: Operating income $68,255$69,040 Adjustments to reconcile operating income to net cash flows from operating activities: Depreciation expense62,65651,607 Changes in assets and liabilities: (Increase) decrease in accounts receivable196(196) (Increase) decrease in inventory, at cost(10,105)(19,551) Increase (decrease) in accounts and contracts payable(90,082)106,965 Increase (decrease) in accrued salaries and withholdings payable703(151) Increase (decrease) in compensated absences payable1,2259,213 Increase (decrease) in deferred revenue2177,233 Total adjustments(35,190)155,120 Net cash flows from operating activities$33,065$224,160 151 CITY OF COLUMBIA HEIGHTS, MINNESOTA INFORMATION SYSTEMS FUND Statement 56 SUBCOMBINING SCHEDULE OF NET POSITION December 31, 2012 With Comparative Totals For December 31, 2011 Capital Equipment Operating Replacement Totals AccountAccount 2012 2011 Assets: Current assets: Cash and cash equivalents $197,169$481,654$678,823$620,542 Interest receivable 600 1,400 2,000 1,800 Total current assets 197,769483,054680,823622,342 Noncurrent assets: Capital assets: Equipment 195,300 - 195,300182,705 Less: accumulated depreciation (152,671) - (152,671)(134,043) Net capital assets 42,629 - 42,629 48,662 Total noncurrent assets 42,629 0 42,629 48,662 Total assets 240,398483,054723,452671,004 Liabilities: Current liabilities: Accounts payable 1,830 - 1,830 4,033 Accrued salaries and withholdings payable 5,289 - 5,289 7,762 Compensated absences payable - current 946 - 946 1,351 Total current liabilities 8,065 0 8,065 13,146 Noncurrent liabilities: Compensated absences payable - noncurrent 14,819 - 14,819 10,231 Total liabilities 22,884 0 22,884 23,377 Net position: Net investments in capital assets 42,629 - 42,629 48,662 Unrestricted 174,885483,054657,939598,965 Total net position $217,514 $483,054 $700,568 $647,627 152 CITY OF COLUMBIA HEIGHTS, MINNESOTA INFORMATION SYSTEMS FUND Statement 57 SUBCOMBINING SCHEDULE OF REVENUES, EXPENSES AND CHANGES IN FUND NET POSITION For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 Capital Equipment OperatingReplacementIntrafund Totals AccountAccountEliminations2012 2011 Operating revenues $ - $ - $ - $ - $ - Operating expenses: Cost of services 262,230 - - 262,230344,347 Depreciation 18,629 - - 18,62920,545 Total operating expenses 280,859 0 0280,859364,892 Net income (loss) from operations (280,859)0 0(280,859)(364,892) Nonoperating revenues: Investment income 2,500 6,300 - 8,80017,400 Net income (loss) before transfers (278,359)6,300 0 (272,059)(347,492) Transfers in 325,000 - - 325,000320,000 Change in net position 46,641 6,300 0 52,941 (27,492) Net position - January 1 170,873476,754 - 647,627675,119 Net position - December 31 $217,514 $483,054 $0 $700,568 $647,627 153 CITY OF COLUMBIA HEIGHTS, MINNESOTA INFORMATION SYSTEMS FUND Statement 58 SUBCOMBINING SCHEDULE OF CASH FLOWS For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 20122011 Cash flows from operating activities: Cash paid to suppliers for goods and services($47,896)($100,894) Cash payments to employees for services(214,827)(238,266) Net cash flows from operating activities(262,723)(339,160) Cash flows from noncapital financing activities: Transfers in 325,000348,108 Transfers out - (28,108) Net cash flows from noncapital financing activities:325,000320,000 Cash flows from capital and related financing activities: Acquisition of capital assets(12,596)(28,108) Cash flows from investing activities: Investment income: Interest and dividends8,40012,100 Change in fair value 2006,200 Net cash flows from investing activities8,60018,300 Net increase (decrease) in cash and cash equivalents58,281(28,968) Cash and cash equivalents - January 1620,542649,510 Cash and cash equivalents - December 31$678,823$620,542 Reconciliation of operating income (loss) to net cash flows from operating activities: Operating income (loss)($280,859)($364,892) Adjustments to reconcile operating income (loss) to net cash flows from operating activities: Depreciation expense18,62920,545 Changes in assets and liabilities: Increase (decrease) in accounts payable(2,203)3,384 Increase (decrease) in accrued salaries and withholdings payable(2,473)3,557 Increase (decrease) in compensated absences payable4,183(1,754) Total adjustments18,13625,732 Net cash flows from operating activities($262,723)($339,160) 154 CITY OF COLUMBIA HEIGHTS, MINNESOTA INSURANCE FUND Statement 59 SUBCOMBINING SCHEDULE OF NET POSITION December 31, 2012 With Comparative Totals For December 31, 2011 20122011 Assets: Current assets: Cash and cash equivalents $1,038,439 $897,571 Interest receivable 2,900 2,300 Accounts receivable 2,819 2,797 Prepayments 48,082 46,809 Total assets 1,092,240 949,477 Liabilities: Current liabilities: Accounts payable - 2,000 Total liabilities 0 2,000 Net position: Unrestricted 1,092,240 947,477 Total net position $1,092,240 $947,477 155 CITY OF COLUMBIA HEIGHTS, MINNESOTA INSURANCE FUND Statement 60 SUBCOMBINING SCHEDULE OF REVENUES, EXPENSES AND CHANGES IN FUND NET POSITION For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 20122011 Operating revenues: Insurance allocation$508,546$483,758 Recovery of damages19,25534,928 Total operating revenues527,801 518,686 Operating expenses: Cost of services: Premiums 366,495373,047 Claims 8,32417,848 Total operating expenses374,819 390,895 Net income from operations152,982127,791 Nonoperating revenues: Investment income12,80022,500 Miscellaneous expense(21,019)(1,300) Total nonoperating revenues(8,219)21,200 Net income before transfers144,763 148,991 Transfers out - (16,343) Change in net position144,763 132,648 Net position - January 1947,477814,829 Net position - December 31$1,092,240 $947,477 156 CITY OF COLUMBIA HEIGHTS, MINNESOTA INSURANCE FUND Statement 61 SUBCOMBINING SCHEDULE OF CASH FLOWS For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 20122011 Cash flows from operating activities: Cash received from interfund services provided$508,546$483,758 Cash received for damages19,25534,928 Cash paid to suppliers for goods and services(399,133)(388,831) Net cash flows from operating activities128,668 129,855 Cash flows from noncapital financing activities: Transfers out - (16,343) Cash flows from investing activities: Investment income: Interest and dividends11,40014,500 Change in fair value 8008,000 Net cash flows from investing activities12,20022,500 Net increase in cash and cash equivalents140,868 136,012 Cash and cash equivalents - January 1897,571761,559 Cash and cash equivalents - December 31$1,038,439 $897,571 Reconciliation of operating income to net cash flows from operating activities: Operating income $152,982$127,791 Adjustments to reconcile operating income to net cash flows from operating activities: Miscellaneous expense(21,019)(1,300) Changes in assets and liabilities: (Increase) decrease in accounts receivable(22)(2,297) (Increase) decrease in prepayments(1,273)3,661 Increase (decrease) in accounts payable(2,000)2,000 Total adjustments(24,314)2,064 Net cash flows from operating activities$128,668$129,855 157 CITY OF COLUMBIA HEIGHTS, MINNESOTA COMPENSATED ABSENCES FUND Statement 62 SUBCOMBINING SCHEDULE OF NET POSITION December 31, 2012 With Comparative Totals For December 31, 2011 20122011 Assets: Current assets: Cash and cash equivalents $912,138 $907,116 Total assets 912,138 907,116 Liabilities: Current liabilities: Compensated absences payable - current 54,813 107,713 Noncurrent liabilities: Compensated absences payable - noncurrent 858,738 800,816 Total liabilities 913,551 908,529 Net position: Unrestricted (1,413)(1,413) Total net position ($1,413)($1,413) 158 CITY OF COLUMBIA HEIGHTS, MINNESOTA COMPENSATED ABSENCES FUND Statement 63 SUBCOMBINING SCHEDULE OF REVENUES, EXPENSES AND CHANGES IN FUND NET POSITION For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 20122011 Operating revenues$ - $ - Operating expenses: Personal services - 89,146 Net income (loss) from operations 0 (89,146) Nonoperating revenues: Investment income - - Change in net position 0 (89,146) Net position - January 1 (1,413)87,733 Net position - December 31 ($1,413)($1,413) 159 CITY OF COLUMBIA HEIGHTS, MINNESOTA COMPENSATED ABSENCES FUND Statement 64 SUBCOMBINING SCHEDULE OF CASH FLOWS For The Year Ended December 31, 2012 With Comparative Totals For The Year Ended December 31, 2011 20122011 Cash flows from operating activities: Cash received from interfund services provided $438,786 $526,979 Cash payments to employees for services (433,764)(547,371) Net cash flows from operating activities 5,022 (20,392) Net increase (decrease) in cash and cash equivalents 5,022 (20,392) Cash and cash equivalents - January 1 907,116 927,508 Cash and cash equivalents - December 31 $912,138 $907,116 Reconciliation of operating income (loss) to net cash flows from operating activities: Operating income (loss)$ - ($89,146) Adjustments to reconcile operating income (loss) to net cash flows from operating activities: Changes in assets and liabilities: Increase (decrease) in compensated absences payable 5,022 68,754 Total adjustments 5,022 68,754 Net cash flows from operating activities $5,022 ($20,392) 160 AGENCY FUNDS 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 the like. The City of Columbia Heights had the following Agency Funds during the year: Permit Surcharge Fund – used to account for building permit surcharges collected for and remitted to the State of Minnesota, and sewer availability charges (SAC) collected for and remitted to the Metropolitan Council. Tri-City GIS Fund – used to account for joint purchases of geographic information services by the Cities of Columbia Heights, Fridley and Andover. 161 CITY OF COLUMBIA HEIGHTS, MINNESOTA COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES Statement 65 AGENCY FUNDS For The Year Ended December 31, 2012 Balance Balance January 1,December 31, 2012 AdditionsDeletions 2012 Permit Surcharge Fund Assets: Cash and investments$1,818$65,274($65,292)$1,800 Total assets$1,818$65,274($65,292)$1,800 Liabilities: Due to other governmental units$1,818$65,274($65,292)$1,800 Total liabilities$1,818$65,274($65,292)$1,800 Tri-City GIS Fund Assets: Cash and investments$1,356$86,916($80,325)$7,947 Due from other governmental units6,74863,233(69,967)14 Total assets$8,104$86,916($80,325)$7,961 Liabilities: Accounts payable$8,104$78,072($80,325)$5,851 Due to other governmental units - 72,077(69,967)2,110 Total liabilities$8,104$150,149($150,292)$7,961 Total Assets: Cash and investments$3,174$152,190($145,617)$9,747 Due from other governmental units6,74863,233(69,967)14 Total assets$9,922$215,423($215,584)$9,761 Liabilities: Accounts payable$8,104$78,072($80,325)$5,851 Due to other governmental units1,818137,351(135,259)3,910 Total liabilities$9,922$215,423($215,584)$9,761 162 III. STATISTICAL SECTION (UNAUDITED) 163 - This page intentionally left blank - 164 STATISTICAL SECTION The following detailed statistical tables are presented to provide a context for understanding and evaluating the information presented in the other parts of this report. Unless otherwise noted, the information in these statistical tables is derived from the City of Columbia Heights’ Comprehensive Annual Financial Reports for the relevant years. Certain information in prior years’ presentations have been reclassified and/or adjusted in these tables to conform to the current year presentation. These tables address the five categories of information listed below. Financial Trends - Tables 1 through 4 These tables contain trend information to help the reader understand how the City’s financial performance has changed over time. Revenue Capacity - Tables 5 through 8 These tables contain information to help the reader assess the factors affecting the City’s ability to generate property taxes. Debt Capacity - Tables 9 through 13 These tables contain present information to help the reader assess the affordability of the City’s current levels of outstanding debt and the City’s ability to issue additional debt in the future. Demographic and Economic Information - Tables 14 and 15 These tables offer demographic and economic indicators to help the reader understand the environment within which the City’s financial activities take place and to help make comparisons over time and with other governments. Operating Information - Tables 16 through 18 These tables contain information about the City’s operations and resources to help the reader understand the relationship between the City’s financial activities and the services the City provides. 165 CITY OF COLUMBIA HEIGHTS, MINNESOTA NET POSITIONS BY COMPONENT Last Ten Fiscal Years (Accrual Basis of Accounting) 200320042005 Governmental activities: Net investment in capital assets$14,535,589$14,328,916$16,727,724 Restricted1,114,8702,285,3052,302,056 Unrestricted18,169,13320,455,98118,650,981 Total governmental activities net position$33,819,592$37,070,202$37,680,761 Business-type activities: Net investment in capital assets$5,432,788$6,175,547$6,732,499 Restricted290,175337,389375,652 Unrestricted7,325,2286,918,7456,506,201 Total business-type activities net position$13,048,191$13,431,681$13,614,352 Primary government: Net investment in capital assets$19,968,377$20,504,463$23,460,223 Restricted1,405,0452,622,6942,677,708 Unrestricted25,494,36127,374,72625,157,182 Total primary government net position$46,867,783$50,501,883$51,295,113 Fiscal Year 166 Table 1 2006200720082009201020112012 $18,043,277$18,859,030$23,497,922$24,163,911$26,279,178$28,095,261$27,666,461 2,224,3842,228,4542,316,9592,458,7432,034,0303,213,4552,624,466 23,028,97422,985,52321,011,46522,423,35123,142,53421,119,17921,241,595 $43,296,635$44,073,007$46,826,346$49,046,005$51,455,742$52,427,895$51,532,522 $5,759,805$6,039,739$7,142,278$7,459,474$8,044,184$9,331,167$9,819,666 455,227775,036745,601648,435438,275381,465234,063 7,299,5746,478,3835,855,4956,014,1406,725,3835,918,1476,680,609 $13,514,606$13,293,158$13,743,374$14,122,049$15,207,842$15,630,779$16,734,338 $23,803,082$24,898,769$30,640,200$31,623,385$34,323,362$37,426,428$37,486,127 2,679,6113,003,4903,062,5603,107,1782,472,3053,594,9202,858,529 30,328,54829,463,90626,866,96028,437,49129,867,91727,037,32627,922,204 $56,811,241$57,366,165$60,569,720$63,168,054$66,663,584$68,058,674$68,266,860 Fiscal Year 167 CITY OF COLUMBIA HEIGHTS, MINNESOTA CHANGES IN NET POSITION Last Ten Fiscal Years (Accrual Basis of Accounting) 200320042005 Expenses Governmental activities: General government$1,756,434$1,669,721$1,681,229 Public safety3,630,5353,640,9704,052,905 Public works2,646,8592,109,0602,391,726 Culture and recreation1,909,8311,904,8482,017,816 Community development1,239,0302,171,4075,360,442 Interest on long-term debt414,297387,544288,532 Total governmental activities expenses11,596,98611,883,55015,792,650 Business-type activities: Water1,903,3311,637,3161,717,445 Sewer1,231,5941,219,2001,333,420 Refuse 1,330,2721,321,7301,147,313 Storm sewer204,895158,374162,915 Liquor6,619,9426,593,5786,544,175 Total business-type activities expenses11,290,03410,930,19810,905,268 Total primary government expenses$22,887,020$22,813,748$26,697,918 Program revenues Governmental activities: Charges for services: General government$724,331$203,344$228,740 Public safety330,768488,216423,450 Public works306,19348,25381,607 Culture and recreation107,318239,352250,380 Community development510,6201,313,9122,748,542 Operating grants and contributions: General government - - 79 Public safety405,098436,460557,983 Public works194,987213,801178,311 Culture and recreation41,49272,26976,405 Community development304,669955,213144,121 Capital grants and contributions: General government - - - Public safety225,000225,000599,917 Public works613,3041,315,00746,052 Culture and recreation - 50,2501,702,543 Community development56,805177,737 - Total governmental activities program revenues3,820,5855,738,8147,038,130 Fiscal Year 168 Table 2 Page 1 of 2 2006200720082009201020112012 $1,689,675$1,732,111$1,835,453$1,761,334$2,013,750$2,039,680$1,977,594 3,992,9304,380,3634,599,6694,591,9775,473,2245,549,6785,708,009 2,353,0322,506,9132,906,9502,794,1892,777,9662,654,0473,200,572 2,135,6332,313,7502,283,8812,182,8562,479,5192,576,4092,500,719 2,579,0845,918,2574,476,4752,385,4052,295,5741,630,3502,157,966 118,760496,688721,006961,392959,320909,858845,879 12,869,11417,348,08216,823,43414,677,15315,999,35315,360,02216,390,739 2,026,6032,113,1212,149,9761,927,8112,000,1012,370,0762,311,858 1,393,6791,675,7381,571,4871,737,1341,478,5181,710,3811,464,269 1,147,8791,170,7071,185,2981,290,5281,426,4861,561,6591,601,648 184,764204,221216,362376,884272,355298,577329,998 6,377,8056,539,3577,470,3237,701,9617,910,9518,155,8888,378,981 11,130,73011,703,14412,593,44613,034,31813,088,41114,096,58114,086,754 $23,999,844$29,051,226$29,416,880$27,711,471$29,087,764$29,456,603$30,477,493 $171,146$177,378$173,485$169,850$192,005$189,641$204,391 528,752670,017616,107637,653715,205697,656736,927 267,960130,35167,22634,14944,21148,303139,305 263,565297,341262,562256,969269,825159,829137,978 1,461,4971,504,6791,562,3451,019,1911,114,848962,276961,420 2,769 - 2,5601,505 - - - 355,356389,325433,732434,402559,482563,914556,387 161,176154,309154,049161,401166,468176,578189,039 79,37147,784239,865102,51793,47476,86457,337 160,017159,624185,506211,400241,919112,89523,010 - - - - 194,84238,399 - 52,463103,97457,70019,52016,02611,303 - 3,896,8621,448,1801,596,3481,683,0242,848,1791,314,547797,921 141,73871,51642,5881,50015,724 - - 682,8721,311,5252,974,449199,505541,826175,467204,349 8,225,5446,466,0038,368,5224,932,5867,014,0344,527,6724,008,064 Fiscal Year 169 CITY OF COLUMBIA HEIGHTS, MINNESOTA CHANGES IN NET POSITION Last Ten Fiscal Years (Accrual Basis of Accounting) 200320042005 Business-type activities: Charges for services: Water$1,548,505$1,771,153$1,887,990 Sewer1,240,8821,019,5321,145,810 Refuse1,248,3461,255,0111,256,180 Storm sewer184,712284,223274,907 Liquor6,960,9166,975,7566,714,575 Operating grants and contributions: - Sewer1,865 - - Refuse53,41146,63546,170 Storm sewer52,499 - - Capital grants and contributions: Water - - - Sewer - - - Refuse - - - Storm sewer - 113,407 - Total business-type activities program revenues11,291,13611,465,71711,325,632 Total primary government program revenues$15,111,721$17,204,531$18,363,762 Net (expense) revenue: Governmental activities($7,776,401)($6,144,736)($8,754,520) Business-type activities1,102535,519420,364 Total primary government net (expense) revenue(7,775,299)(5,609,217)(8,334,156) General revenues and other changes in net position Governmental activities: Taxes: Property taxes4,306,0364,989,2055,662,368 Tax increment collections781,439972,2081,088,267 Unrestricted grants and contributions2,712,4082,337,3861,768,216 Investment earnings408,208729,456471,142 Miscellaneous103,524 - 18,980 Transfers487,613467,091445,249 Total governmental activities8,799,2289,495,3469,454,222 Business-type activities: Investment earnings126,671215,062118,413 Transfers(487,613)(467,091)(445,249) Total business-type activities(360,942)(252,029)(326,836) Total primary government$8,438,286$9,243,317$9,127,386 Change in net position: Governmental activities$1,022,827$3,350,610$699,702 Business-type activities(359,840)283,49093,528 Total primary government$662,987$3,634,100$793,230 Fiscal Year 170 Table 2 Page 2 of 2 2006200720082009201020112012 $2,141,648$2,273,980$2,414,316$2,471,257$2,503,506$2,530,803$2,777,383 1,374,2171,419,2521,440,1651,465,4961,594,3221,523,8521,581,516 1,263,2671,303,4721,341,0141,383,9791,542,3121,682,1781,761,860 270,467290,419314,238370,590345,086350,618353,343 6,546,9796,722,6227,490,9427,962,8848,158,2598,494,9628,804,233 - - 1,718 - - - - 47,75536,06050,57250,10536,65366,16362,471 - - - - - - - 22,822 - - - - - - - - 54,774 - - - - - - - - - - 50,000 - - - - - - - 11,667,15512,045,80513,107,73913,704,31114,180,13814,648,57615,390,806 $19,892,699$18,511,808$21,476,261$18,636,897$21,194,172$19,176,248$19,398,870 ($4,643,570)($10,882,079)($8,454,912)($9,744,567)($8,985,319)($10,832,350)($12,382,675) 536,425342,661514,293669,9931,091,727551,9951,304,052 (4,107,145)(10,539,418)(7,940,619)(9,074,574)(7,893,592)(10,280,355)(11,078,623) 5,953,7226,321,4676,762,1298,046,3188,825,5029,069,0929,363,598 1,086,2981,183,0621,557,8911,244,684812,965558,861553,050 1,679,3841,844,5161,516,4121,731,1851,176,9341,278,1951,003,552 706,2311,379,7261,050,827475,345487,612598,880295,950 15,93044,00040,87782,704 - 34,4857,338 957,879456,537280,115383,99092,044264,990263,814 10,399,44411,229,30811,208,25111,964,22611,395,05711,804,50311,487,302 181,708321,571216,03892,67286,110135,93263,321 (957,879)(456,537)(280,115)(383,990)(92,044)(264,990)(263,814) (776,171)(134,966)(64,077)(291,318)(5,934)(129,058)(200,493) $9,623,273$11,094,342$11,144,174$11,672,908$11,389,123$11,675,445$11,286,809 $5,755,874$347,229$2,753,339$2,219,659$2,409,738$972,153($895,373) (239,746)207,695450,216378,6751,085,793422,9371,103,559 $5,516,128$554,924$3,203,555$2,598,334$3,495,531$1,395,090$208,186 Fiscal Year 171 CITY OF COLUMBIA HEIGHTS, MINNESOTA FUND BALANCES - GOVERNMENTAL FUNDS Last Ten Fiscal Years (Modified Accrual Basis of Accounting) 2003 2004 2005 General fund: Reserved $14,727 $23,302 $10,484 Unreserved 3,408,505 4,116,808 3,339,644 Nonspendable - - - Restricted - - - Committed - - - Assigned - - - Unassigned - - - Total general fund $3,423,232 $4,140,110 $3,350,128 All other governmental funds: Reserved $976,139 $5,273,705 $2,187,884 Unreserved, reported in: Special revenue funds 610,804 (652,449)(612,434) Debt service funds 841,666 1,044,647 621,250 Capital projects funds 13,633,284 12,367,589 12,784,744 Nonspendable - - - Restricted - - - Committed - - - Assigned - - - Unassigned - - - Total all other governmental funds $16,061,893 $18,033,492 $14,981,444 Fiscal Year 172 Table 3 2006200720082009201020112012 $35,323$35,710$12,159$71,898$77,204$ - $ - 3,560,5253,943,4363,743,7984,724,2535,265,035 - - - - - - - 80,76787,341 - - - - - - - - - - - - 132,59574,594 - - - - - - - - - - - - 5,655,6935,914,974 $3,595,848$3,979,146$3,755,957$4,796,151$5,342,239$5,869,055$6,076,909 $2,668,322$2,382,354$968,602$1,643,915$1,550,071$ - $ - (506,084)411,0901,868,3402,332,6103,190,618 - - 809,0621,745,4473,242,4713,177,5863,713,774 - - 15,034,96815,918,04820,233,69013,173,07411,642,407 - - - - - - - 2,353,1642,763,852 - - - - - 3,440,6494,186,081 - - - - - 12,774,44010,988,368 - - - - - - - - - - - - (1,041)(2,782) $18,006,268$20,456,939$26,313,103$20,327,185$20,096,870$18,567,212$17,935,519 Fiscal Year 173 CITY OF COLUMBIA HEIGHTS, MINNESOTA CHANGES IN FUND BALANCES - GOVERNMENTAL FUNDS Last Ten Fiscal Years 200320042005 Revenues: Taxes$5,076,498$5,937,431$6,702,610 Special assessments564,351671,357520,031 Licenses and permits281,480586,957382,339 Intergovernmental 3,844,9884,687,8664,878,487 Charges for services1,125,4311,442,4383,197,360 Fines and forfeitures140,378140,282127,555 Investment earnings392,995695,275432,959 Other revenues435,829176,57590,956 Total revenues11,861,950 14,338,181 16,332,297 Expenditures: Current: General government1,663,8011,576,2331,575,863 Public safety3,590,5253,615,2003,954,019 Public works1,208,0551,311,3901,558,987 Culture and recreation1,862,7771,872,1781,977,798 Community development1,622,4681,576,1614,511,338 Capital outlay: General government16,037 - 11,022 Public safety348,221476,51195,125 Public works1,273,7471,637,5591,912,738 Culture and recreation71,70083,95562,700 Community development55,824682,9391,436,724 Debt service: Principal retirement477,918514,7891,449,035 Interest and fiscal charges602,592652,5182,478,205 Issuance costs10,33029,918 - Developer incentives85,21167,866252,176 Total expenditures12,889,206 14,097,217 21,275,730 Revenues over (under) expenditures(1,027,256)240,964 (4,943,433) Fiscal Year 174 Table 4 Page 1 of 2 2006200720082009201020112012 $6,977,604$7,444,199$8,263,763$9,218,038$9,631,635$9,683,433$9,948,228 1,011,5531,137,5762,505,523879,0921,020,334729,327775,714 597,557444,833423,465435,618479,148378,357396,226 4,228,3084,229,4143,734,8263,777,3554,936,4432,820,4192,314,195 1,887,3141,995,8591,665,6041,513,6671,650,7721,568,3611,663,782 129,400160,383142,283139,955188,693170,089161,882 648,7441,271,216984,846456,145469,312562,180275,750 251,414170,344296,815102,901273,44670,17363,674 15,731,894 16,853,824 18,017,125 16,522,771 18,649,783 15,982,339 15,599,451 1,577,4841,616,3741,706,2441,646,9741,926,9822,005,9101,813,433 3,887,8844,122,4114,345,7164,418,4364,968,4335,786,9135,250,881 1,523,1701,640,7131,955,2501,736,9991,731,7002,621,9272,011,507 2,074,8352,238,7932,202,6802,003,6352,194,8531,635,6012,184,214 2,256,1223,077,3104,077,5762,115,6281,351,3681,353,1501,434,329 4,512 - 5,45345,708 - 115,554209,176 82,986254,7283,499,7138,997,400237,27295,697158,448 4,202,6651,303,2971,084,959951,2402,925,174642,102557,820 117,909274,8963,269,9862,256,958194,38032,54218,107 266,144306,332287,620139,1181,202,99869,573636,294 782,273792,2731,029,836783,974765,7361,659,022972,000 119,544219,065384,293835,167981,281935,405861,139 25,114148,972155,39756,189 - 181,638116,072 142,4512,584,85471,341125,857141,005 - - 17,063,093 18,580,018 24,076,064 26,113,283 18,621,182 17,135,034 16,223,420 (1,331,199)(1,726,194)(6,058,939)(9,590,512)28,601 (1,152,695)(623,969) Fiscal Year 175 CITY OF COLUMBIA HEIGHTS, MINNESOTA CHANGES IN FUND BALANCES - GOVERNMENTAL FUNDS Last Ten Fiscal Years 200320042005 Other financing sources (uses): Bonds issued$1,332,828$1,985,000$ - Bond premium (discount)(5,998)(5,935) - Transfers in3,849,932838,937553,070 Transfers out(2,880,382)(370,489)(80,321) Sale of capital assets267,699 - 628,654 Total other financing sources (uses)2,564,079 2,447,513 1,101,403 Net change in fund balance$1,536,823$2,688,477($3,842,030) Expenditures capitalized for governmental activities reporting purposes1,273,9382,355,4203,518,309 Debt service as a percentage of noncapital expenditures (A) (B)9.3%9.9%22.1% Debt service as a percentage of total expenditures (A) (B)8.4%8.3%18.5% (A) For the purpose of the debt service ratios presented in this table, only the principal and interest components of the debt service expenditures reported in this table are used, and noncapital expenditures are determined by subtracting expenditures capitalized for governmental activities reporting purposes from the total governmental funds expenditures reported in the table. (B) Certain information from prior years' presentations have been restated in this table to conform to the current presentation. Fiscal Year 176 Table 4 Page 2 of 2 2006200720082009201020112012 $2,759,550$3,890,000$10,975,000$4,190,000$ - $ - $ - 26,303(22,108) - - - - - 1,807,877570,374377,615458,231407,272411,736298,814 (70,000)(70,000)(88,941)(99,224)(120,100)(302,881)(110,000) 78,013191,897428,24095,781 - 40,99911,315 4,601,743 4,560,163 11,691,914 4,644,788 287,172 149,854 200,129 $3,270,544$2,833,969$5,632,975($4,945,724)$315,773($1,002,841)($423,840) 4,592,7871,896,3637,909,56112,364,5113,637,559955,4681,579,845 7.2%6.1%8.7%11.8%11.7%16.0%12.5% 5.3%5.4%5.9%6.2%9.4%15.1%11.3% Fiscal Year 177 CITY OF COLUMBIA HEIGHTS, MINNESOTA TAX CAPACITY VALUE AND ESTIMATED MARKET VALUE OF ALL TAXABLE PROPERTY Table 5 Last Ten Fiscal Years (Unaudited) Adjusted Adjusted Tax Tax Capacity Value (A)Taxable Net TotalEstimated Capacity Value FiscalOther Captured Tax Area Wide Allocation (C)Tax Capacity Direct TaxMarket as a Percent Year ResidentialProperty (B)Increment ValueSubtotalContributionDistributionValue RateValueof EMV 2003$7,852,288$1,731,844($823,154)$8,760,978($409,330)$2,111,495$10,463,14345.272%$982,517,6001.065% 20048,808,1431,813,247(1,010,335)9,611,055(379,508)2,267,40111,498,94847.888%1,077,714,4001.067% 200510,170,0411,874,629(1,152,643)10,892,027(417,605)2,275,59112,750,01347.859%1,203,032,8001.060% 200611,487,4241,861,133(1,193,227)12,155,330(453,305)2,324,91714,026,94244.736%1,271,030,5001.104% 200712,860,3731,967,884(1,389,436)13,438,821(443,665)2,473,14015,468,29641.511%1,387,050,1001.115% 200813,596,2902,219,619(1,747,297)14,068,612(485,657)2,877,43216,460,38743.076%1,454,932,2001.131% 200913,229,8032,426,270(1,748,791)13,907,282(551,683)3,175,71216,531,31147.430%1,424,291,3001.161% 201011,997,2972,401,197(803,298)13,595,196(624,231)3,579,41616,550,38156.881%1,303,072,9001.270% 201110,890,6312,218,809(568,719)12,540,721(796,058)3,811,85615,556,51961.804%1,180,235,3001.318% 20129,087,6662,141,140(521,306)10,707,500(710,709)4,059,43214,056,22366.300%968,810,4411.451% (A) 2012 taxable market values used to calculate tax capacity values in this table are reduced by the market value homestead exclusion, which is new for 2012. (B)The category "Other Property" is substantially all commercial/industrial property, plus nomimal amounts of railroad and personal property. ( C)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. Source: Anoka County Auditor's Tax Certificate 178 CITY OF COLUMBIA HEIGHTS, MINNESOTA DIRECT AND OVERLAPPING PROPERTY TAX RATES (A) Table 6 Last Ten Fiscal Years City Fiscal Direct School Special Year Rate (A)District 13 CountyDistricts ( C)Total 2003 45.272%20.303%34.761%8.203%108.539% 2004 47.888%22.833%37.617%7.689%116.027% 2005 47.859%19.918%32.722%8.048%108.547% 2006 44.736%19.505%29.875%7.679%101.795% 2007 41.511%17.338%28.626%7.901%95.376% 2008 43.076%16.088%28.927%9.693%97.784% 2009 47.430%23.554%29.861%8.699%109.544% 2010 56.881%24.547%32.696%9.185%123.309% 2011 61.804%18.842%37.235%9.605%127.486% 2012 66.300%24.200%38.415%9.932%138.847% (A)These property tax rates are stated as a percentage of tax capacity value. Refer to Table 5 for tax capacity value. Rates stated in terms of 2012 tax capacity values are impacted by the market value homestead exclusion, new for 2012. By excluding a portion of tax base from taxation, 2012 rates are stated higher for any given levy amount, relative to prior years. Rates are determined by tax district. Within the Anoka County property tax system, the City is an individual tax district. Thus the City direct rate is an individual rate, and is not comprised of component direct rates. (B)Overlapping rates are those of local and county governments that apply to property owners within the City. Most, but not all, overlapping rates apply to all City property owners. For example, although the school and county property tax rates apply to all City property owners, special district rates apply only to the City property owners whose property is located within each special district's geographic boundaries. (C)Special districts include Metropolitan Council, Metropolitan Transit District, Metropolitan Mosquito Control District, N.E. Metro School District 916, Rice Creek Watershed District, Anoka County Housing and Redevelopment Authority, Anoka County Regional Rail Authority, County/City Radio, and the Columbia Heights Housing and Redevelopment Authority. Overlapping Rates (B) 179 - This page intentionally left blank - 180 CITY OF COLUMBIA HEIGHTS, MINNESOTA PRINCIPAL PROPERTY TAXPAYERS Table 7 Current Year and Nine Years Ago Percentage Percentage Taxof Total CityTaxableof Total City CapacityTax CapacityCapacityTax Capacity TaxpayerValue (A) & (B)RankValueValue (A)RankValue Medtronic Inc$207,98811.48%$174,50211.67% Centro Bradley SPE 5 LLC133,69220.95%N/AN/AN/A Stadium Village Properties LLC109,28630.78%N/AN/AN/A Consolidated Realty of Mpls90,62540.64%98,92330.95% Columbia Park Properties95,23450.68%76,55260.73% Crestview Corporation96,95260.69%65,18780.62% Columbia Heights Center LLC76,12670.54%80,93050.77% Lynde Investment Co MN Partnership67,69080.48%57,46690.55% Jeff's Bobby & Steve's Auto World67,39290.48%49,366100.47% Northern States Power58,712100.42%49,072110.47% New Heights Development LLC54,664110.39%N/AN/AN/A Maylan Construction CompanyN/AN/AN/A86,84840.83% Lake State PropertiesN/AN/AN/A76,27870.73% Bradley Operating LPN/AN/AN/A141,72821.35% Total$1,058,3617.53%$956,8529.14% Total All Property $14,056,223$10,463,143 (A) Tax Capacity values in this table are before adjustments for captured tax increment value and area-wide allocations. See Table 5. (B) 2012 taxable market values used to calculate tax capacity values in this table are reduced by the market value homestead exclusion, new for 2012. Source: Anoka County Auditor's Tax Certificate. 20032012 181 CITY OFCOLUMBIA HEIGHTS, MINNESOTA PROPERTY TAX LEVIES AND COLLECTIONS Last Ten Years CountyState Market FiscalGrossAdjustmentsValue HomesteadAdjusted YearTax Levy (A)to Levy (B)Credit (A) Tax Levy 2003$4,817,984$1,805($607,323)$4,212,466 20045,447,2602,628(588,271)4,861,617 2005 6,102,537 152 (568,479)5,534,210 2006 6,347,537 (160)(517,322)5,830,055 2007 6,500,613 (189)(471,660)6,028,764 2008 7,045,370 (74)(451,019)6,594,277 2009 7,702,363 (161)(447,755)7,254,447 2010 9,075,425 (302)(535,625)8,539,498 2011 9,426,760 (141)(608,241)8,818,378 2012 9,136,706 (54) - 9,136,652 (B) Anoka County adjusts the property tax levy adopted by the City Council for certain items. These are primarily excess tax increment reimbursements and rounding. Abatements or increases of tax to individual taxpayers are not included in these adjustments. Source: Anoka County Auditor's Tax Certificate. Also Anoka County Tax Settlement Statements for the City of Columbia Heights. (A) Under state law for years prior to 2012, the stated amount of the annual property tax levy adopted by the City Council included both the actual property tax plus an amount termed the "state market value homestead credit." The state market value homestead credit was determined by a formula in state law. To the extent this market value homestead credit was paid by the State of Minnesota and received by the City in any given year, it was reported as intergovernmental revenue in the City's financial statements. Only the portion of the gross levy that was actually levied upon property is reported as property tax revenue in the City's financial statements. This table only includes tax levies for the City of Columbia Heights, the primary government. It does not include tax levies for the special taxing district of the Columbia Heights HRA, a component unit of the City. 182 Table 8 Collections inTotal Collections to Date Collection% of AdjustedSubsequent% of Adjusted AmountTax LevyYearsAmountTax Levy $4,115,96797.71%$64,941$4,180,90899.25% 4,760,78897.93%53,6434,814,43199.03% 5,412,178 97.79%85,072 5,497,250 99.33% 5,672,909 97.30%128,106 5,801,015 99.50% 5,842,540 96.91%156,411 5,998,951 99.51% 6,400,604 97.06%157,453 6,558,057 99.45% 7,021,605 96.79%171,267 7,192,872 99.15% 8,279,065 96.95%125,232 8,404,297 98.42% 8,578,784 97.28%85,737 8,664,521 98.26% 8,932,564 97.77%N/A 8,932,564 97.77% Collected Within The Fiscal Year For Which Levied 183 CITY OF COLUMBIA HEIGHTS, MINNESOTA RATIOS OF OUTSTANDING DEBT BY TYPE Last Ten Fiscal Years Governmental Activities GeneralGeneralGeneral ObligationObligationObligation Bonds RepaidBondsBonds WithTax IncrementTotal FiscalOnly WithWith PledgedPledged SpecialRevenueGovernmental YearGeneral TaxesTax IncrementAssessmentsBondsActivities 2003$ - $1,630,288$1,937,828$ - $3,568,116 2004 - 3,264,7041,773,623 - 5,038,327 2005 - 1,985,0001,604,292 - 3,589,292 2006 - 1,385,0004,181,569 - 5,566,569 20071,000,000775,0003,999,2962,890,0008,664,296 200811,000,000150,0004,569,4602,890,00018,609,460 200913,940,000580,0004,614,4862,881,00022,015,486 201013,855,000580,0003,976,7502,838,00021,249,750 201112,698,431580,0003,522,2992,790,00019,590,730 201213,090,000580,0002,211,7902,737,00018,618,790 (A) Based on population and income data in Table 14. Certain information from prior years' presentations have been restated in this table to conform to the current presentation. 184 Table 9 Business-Type ActivitiesAll Activities GeneralLiquor ObligationFacility Bonds WithLeaseTotalPercentage Pledged UtilityRevenueBusiness-TypeTotalof PersonalPer RevenuesBondsActivitiesAll DebtIncome (A)Capita (A) $2,737,172$ - $2,737,172$6,305,2881.6%337 2,486,377 - 2,486,3777,524,7041.9%405 2,220,708 - 2,220,7085,810,0001.3%318 3,248,431 - 3,248,4318,815,0002.0%482 2,950,7045,040,0007,990,70416,655,0003.8%919 2,590,5405,040,0007,630,54026,240,0006.0%1,447 2,540,5125,040,0007,580,51229,595,9986.7%1,612 2,128,2484,900,0007,028,24828,277,9986.0%1,450 1,304,2704,750,0006,054,27025,645,0005.3%1,315 1,123,2104,595,0005,718,21024,337,0004.8%1,240 185 CITY OF COLUMBIA HEIGHTS, MINNESOTA RATIOS OF OUTSTANDING NET GENERAL BONDED DEBT BY TYPE Last Ten Fiscal Years Less:Subtotal of GovernmentalGovernmentalGovernmentalPercentage General Funds Net Generalof Estimated FiscalObligationRestricted forObligationProperty YearBondsRepaymentBonded DebtValue (B) 2003$3,568,116$841,666$2,726,4500.28% 20045,038,3271,044,6473,993,6800.37% 20053,589,292621,2502,968,0420.25% 20065,566,569809,0624,757,5070.37% 20075,774,2961,745,4474,028,8490.29% 200815,719,4603,242,47112,476,9890.86% 200919,134,4862,952,52016,181,9661.14% 201018,411,7503,713,77414,697,9761.13% 201116,800,7302,162,11914,638,6111.24% 201213,066,7901,559,98511,506,8051.19% (A) Based on population and income data in Table 14. Certain information from prior years' presentations have been restated in this table to conform to the current presentation. (B) Based on the estimated market value of property in Table 5. The estimated market value of property bears a stong relationship to the debt capacity of the City. It should be noted however, that in the State of Minnesota, property tax revenue is dependent on the tax capacity value of property. Tax capacity value is derived from estimated market value by a set of class rates and other adjustments as determined by the State legislature. The historical relationship between estimated market value and tax capacity value for property in the City is shown in Table 5. 186 Table 10 Business-typeLess:Subtotal of GeneralBusiness-typeBusiness-type Obligation BondsFunds Net GeneralPercentageTotal With PledgedRestricted forObligationof UtilityNet GeneralPer Utility RevenuesRepaymentBonded DebtRevenueBonded DebtCapita (A) $2,737,172$290,175$2,446,99758.5%$5,173,447277 2,486,377337,3892,148,98849.8%$6,142,668330 2,220,708375,6521,845,05640.6%$4,813,098264 3,248,431457,7942,790,63755.3%$7,548,144413 2,950,704443,2972,507,40747.4%$6,536,256361 2,590,540449,9312,140,60938.9%$14,617,598806 2,540,512485,8832,054,62936.1%$18,236,595993 2,128,248287,4531,840,79530.8%$16,538,771848 1,304,270273,9661,030,30416.9%$15,668,915804 1,123,210226,292896,91813.9%$12,403,723632 187 CITY OF COLUMBIA HEIGHTS, MINNESOTA DIRECT AND OVERLAPPING GOVERNMENTAL ACTIVITIES DEBT Table 11 December 31, 2012 Estimated EstimatedShare of DebtPercentageOverlapping Governmental Unit (A)OutstandingApplicable (B)Debt Debt repaid with property taxes: Anoka County$150,438,5064.8286%$7,264,051 Anoka County Railroad Authority29,285,0004.8392%1,417,164 Independent School District 1322,435,000 70.1291%15,733,463 Metropolitan Council 1,349,552,846 0.4551%6,142,061 Subtotal - overlapping debt 30,556,739 City direct debt - governmental activities14,585,000 Total direct and overlapping debt $45,141,739 (A)Overlapping governments are those that coincide, at least in part, with the geographic boundaries of the City. This schedule estimates the portion of the outstanding debt of those overlapping governments that is borne by the taxpayers of the City. This process recognizes that, when considering the City's ability to issue and repay long-term debt, the entire debt burden borne by the taxpayers should be taken into account. (B)The percentage of overlapping debt applicable is estimated using adjusted taxable net tax capacity values of property, which is the tax capacity value after adjustments for captured tax increment value and area-wide allocations (see Table 5) Applicable percentages were estimated by determining the portion of each governmental unit's tax. capacity value that is within the City's boundaries and dividing it by each unit's total tax capacity value. Source: Anoka County Auditor's Tax Certificate 188 CITY OF COLUMBIA HEIGHTS, MINNESOTA LEGAL DEBT MARGIN INFORMATION Table 12 Last Ten Fiscal Years Legal Debt Margin Calculation for Fiscal Year 2012 Taxable market value of property ( C)$968,910,441 Debt limitation percentage (A)3% Debt limit 29,067,313 Net debt applicable to limit (B)10,275,000 Legal debt margin $18,792,313 Legal debt margin as a percentage of limit 64.65% Legal Debt Margin Calculation for Fiscal Years 2003 Through 2011 Net Debt LegalLegal Debt Margin Fiscal Debt Applicable to Debt as a Percentage Year Limit Limit Margin of Debt Limit 2003 $17,102,916 $ - $17,102,916 100.00% 2004 19,133,440 - 19,133,440 100.00% 2005 21,831,836 - 21,831,836 100.00% 2006 24,490,232 - 24,490,232 100.00% 2007 27,255,660 1,000,000 26,255,660 96.33% 2008 43,388,271 11,000,000 32,388,271 74.65% 2009 42,618,129 13,940,000 28,678,129 67.29% 2010 38,979,705 13,855,000 25,124,705 64.46% 2011 35,278,494 12,698,431 22,580,063 64.01% (A)M.S.A. Section 475.53 (Limit on Debt) Subdivision 1. Generally, except as otherwise provided in Sections 475.51 to 475.74, "no municipality, except a school district or a city of the first class, shall incur or be subject to a net debt in excess of 3% of the market value of taxable property in the municipality." (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. ( C)Beginning in the year 2012, state statute excludes a portion of the market value of eligible homestead property from taxation. This is termed the Market Value Homestead Exclusion. For purposes of the state statutes referenced in notes (A) and (B) above that set the legal debt limit/margin, the Minnesota Department of Revenue interprets "the market value of the taxable property in the City" as net of any market value homestead exclusion. 189 CITY OF COLUMBIA HEIGHTS, MINNESOTA PLEDGED REVENUE COVERAGE NON-OBLIGATION DEBT Table 13 Last Ten Fiscal Years 2003 - 200720082009201020112012 Economic Development Authority Tax Increment Revenue Bonds Series 2007: Tax increment revenue from applicable parcels$ - $243,159$267,142$241,854$211,533$175,832 Intergovernmental: Market Value TIF credit - 14,00219,55428,11834,351 - Net available revenue$0$257,161$286,696$269,972$245,884$175,832 Debt service: Principal - - 9,00043,00048,00053,000 Interest - 158,325152,363151,063148,788146,263 Total debt service$0$158,325$161,363$194,063$196,788$199,263 CoverageN/A162%178%139%125%88% Economic Development Authority Lease Revenue Bonds Series 2007B: Annual appropriation of liquor net revenues$ - $210,264$497,200$364,000$390,000$386,000 Investment income - 8,638711,1051,5001,000 Issuance costs and administration (expense) - (10,062)(6,866)(10,393)(9,598)(9,371) Net available revenue$0$208,840$490,405$354,712$381,902$377,629 Debt service: Principal$ - $ - $ - $140,000$150,000$155,000 Interest - 208,264240,305237,155230,630223,768 Total debt service$0$208,264$240,305$377,155$380,630$378,768 CoverageN/A100%204%94%100%100% Note: Details regarding the City's outstanding debt can be found in Note 6 of the financial statements. Fiscal Year 190 CITY OF COLUMBIA HEIGHTS, MINNESOTA DEMOGRAPHIC AND ECONOMIC STATISTICS Table 14 Last Ten Fiscal Years Per Capita Fiscal Personal Personal Unemployment Year Population Income Income Rate 2003 18,698 $399,538,864 $21,368 4.70% 2004 18,600 397,444,800 21,368 4.40% 2005 18,261 442,135,332 24,212 3.80% 2006 18,288 442,789,056 24,212 3.90% 2007 18,124 438,818,288 24,212 4.60% 2008 18,137 439,133,044 24,212 5.50% 2009 18,361 444,556,532 24,212 8.50% 2010 19,496 472,037,152 24,212 7.50% 2011 19,496 485,450,400 24,900 6.70% 2012 19,619 506,170,200 25,800 5.50% Sources are as follows: Population: Data for the years 2004-2009 provided by the Metropolitan Council. Data for the year 2003 & 2011 were estimated as equal to next available prior year. Data for 2010 is from the 2010 US Census. Data for 2012 is estimated by the US Census. Per Capita Income: Data for 2003-2004 estimated as equal to per capita income reported in the 2000 U.S. Census. Data for 2005-2011 provided by the US Census Bureau, 2005-2009 American Community Survey. Certain information from prior years' presentations have been restated in this table to conform to the current presentation. Unemployment Rate: Provided by MN Department of Employment and Economic Development for Anoka County. Rates are not compiled for inidividual communities within counties. 191 - This page intentionally left blank - 192 CITY OF COLUMBIA HEIGHTS, MINNESOTA PRINCIPAL EMPLOYERS Table 15 Current Year and Nine Years Ago Percentage ofPercentage of Total AnokaTotal Anoka County (A)County (A) Principal Employers Within CityEmployeesRankEmploymentEmployeesRankEmployment Medtronic Inc60010.34%53210.30% Independent School District 1348420.27%41520.23% Crestview Lutheran Home24530.14%22630.13% City of Columbia Heights20540.11%17540.10% Columbia Park Clinic12050.07%7070.04% Rainbow Foods10060.06%12050.07% Unique Thrift Store7570.04%N/AN/AN/A Invest Cast Inc6080.03%5490.03% La Casita Mexican Restaurant6090.03%N/AN/AN/A Bobby & Steve's Auto World53100.03%N/AN/AN/A US Post OfficeN/AN/AN/A45100.03% NEI College of TechnologyN/AN/AN/A7660.04% SIS EnterprisesN/AN/AN/A6080.03% Total 2,0021.12%1,7731.00% (A) Employment data is not compiled for individual cities within Minnesota counties. Sources: The employee count for the City of Columbia Heights is from Table 16. 2012 data for other employers was compiled from Salesgenie business database at May 2012. 20032012 193 CITY OF COLUMBIA HEIGHTS, MINNESOTA CITY GOVERNMENT EMPLOYEES BY FUNCTION/PROGRAM Last Ten Fiscal Years Function/Program2003200420052006 General government Mayor/council 5 5 5 5 Administration 5 5 5 4 Finance 13 12 12 12 Public safety: Police 31 30 30 31 Fire 40 39 35 36 Public works 17 18 16 17 Culture and recreation: Library 19 19 21 22 Parks 5 5 5 5 Recreation 13 13 15 16 Community development 7 6 7 7 Water 4 4 4 4 Sewer 4 4 4 4 Refuse - - - - Storm sewer - - - - Liquor 35 37 37 37 Total 198 197 196 200 Source: Organizational Chart in the City of Columbia Heights CAFR. Note: The above table shows the distribution of all employees by head count (including full-time, part-time and paid on-call), by function. This bears a strong relationship to the distribution of employee costs across functions. However, many employees provide services to more than one function, and employee costs are charged to each function based on the services received by each function. Employees as of December 31, 194 Table 16 200720082009201020112012 555555 4 4 5 10 11 11 13 13 14 13 14 13 31 34 35 36 35 35 33 29 31 30 32 32 16 17 18 17 16 16 22 25 21 19 21 21 555555 16 17 14 13 16 16 766554 544444 433333 - - - - - - - 1 1 1 1 1 42 38 40 41 39 39 203 201 202 202 207 205 Employees as of December 31, 195 CITY OF COLUMBIA HEIGHTS, MINNESOTA OPERATING INDICATORS BY FUNCTION/PROGRAM Last Ten Fiscal Years 2003200420052006 General government: Resolutions approved by City Council (A)578792234 Ordinances adopted by City Council1972014 Public safety: Police: Part I crimes (B)1,0561,2291,2801,167 Part II crimes (B)3,2253,4353,4963,184 Fire: Emergency medical calls (B)1,7021,6531,8731,806 Fire calls (B)380483581387 Inspections & Related Actions (B)4,6162,0772,3793,709 Public works: Street paving and patching (tons of asphalt)1,2201,271409710 Street sweeping (tons of debris)6401,064658637 Trees removed143261296188 Culture and recreation: Library: Items in collection71,40973,10568,22670,354 Circulation116,917116,533115,598119,593 Reference inquiries18,42714,67017,22515,106 Parks and recreation: Athletics participants (C)2,5582,1391,9881,654 Other programs, estimated attendance (D)9,0009,0009,0009,000 Number of paid room rentals132134164191 Community development: Number of business licenses issued295307327342 Number of building permits issued (E)1,1761,1591,3041,701 Construction value of permits issued$11,056,530(F)$50,322,414(F)$13,041,878$26,798,827 Water: Consumption (thousands of gallons)579,322538,358527,621529,581 Sewer (sanitary): Wastewater (thousands of gallons, 12 months ended June 30)556,900526,010514,810536,920 Miles of line cleaned/rodded/root-sawed17282839 Refuse: Refuse (tons)7,6708,3488,8638,397 Recycling (tons)1,8731,7831,8631,721 Yardwaste (tons)809862892645 Storm sewer: No operating indicators availablenot availnot availnot availnot avail Liquor: Number of units soldnot availnot avail798,900758,000 (A)In 2006, the City significantly increased enforcement of ordinances concerning nuisance/hazardous conditions of properties within the City. Resolutions per year sharply increased, given one resolution per significant enforcement action. (B)Public safety operating indicators include services provided to the City of Hilltop under contractual agreements. The City of Hilltop is completely encircled by the City of Columbia Heights and has a population of 744. (C)This operating indicator includes duplicate counts for participation in more than one team/league by some persons. (D)This operating indicator includes duplicate counts for attendance at more than one program by some persons. It is rounded to the nearest thousand attendees based on review of attendance data. (E)This operating indicator includes inspection permits issued for new construction, building alteration/addition, plumbing, heating, street excavation and sign installation. (F)The construction value of building permits issued in 2004 includes $30,573,000 for a water filtration plant owned and operated by the City of Minneapolis within the City of Columbia Heights. Certain information from prior years' presentations have been restated in this table to conform to the current presentation. Sources: Various City departments. Function/Program Fiscal Year 196 Table 17 200720082009201020112012 198247170115159159 12261212155 1,2461,098882768756743 3,1442,9661,2751,6831,5761,408 1,8882,0931,6941,6641,7221,839 445385660846764752 4,6036,9553,7245,7206,0735,413 1,9101,4151,0331,0548691,029 648420581638712350 357175121180180157 71,59472,42069,70272,05571,30372,985 125,222126,271120,705131,885125,051129,624 13,71513,79317,77114,35216,60114,547 1,5371,5101,6021,5004,2994,232 8,0008,0008,0008,0008,0009,000 185190210160177135 306363379393334323 1,3131,1131,1871,3511,2901,058 $22,230,118$21,917,792$13,376,732$14,481,712$7,986,467$7,203,199 538,844518,791518,299516,068454,223495,870 495,580511,090437,520444,820485,000455,210 272939262526 6,5877,3237,2396,7706,7896,563 1,5221,3181,0361,6991,6051,610 6547277731,1001,2701,270 not availnot availnot availnot availnot availnot avail 768,000920,1211,029,1391,028,1601,060,1501,103,790 Fiscal Year 197 CITY OF COLUMBIA HEIGHTS, MINNESOTA CAPITAL ASSET STATISTICS BY FUNCTION/PROGRAM Last Ten Fiscal Years Function/Program2003200420052006 General government: City hall square footage 28,53028,53028,53028,530 Public safety: Police Stations1111 Fire Stations 1111 Public Safety Bldg square footageNote ANote ANote ANote A Public works: Office and shop square footage31,07531,07531,07531,075 Trunk highway miles3333 County road miles6666 City street miles62626262 Alley miles19191919 Culture and recreation: Libraries1111 Library square footage7,8967,8967,8967,896 Parks13131313 Playgrounds11111111 Gymnasiums square footage - - - - Mtg & banquet rooms square footage22,00022,00022,00022,000 Community development: Senior high-rise apartments145145145145 Water: Watermain miles66666666 Sewer: Sanitary sewer miles59595959 Refuse: Recycling centers1111 Storm sewer: Storm sewer miles34343434 Liquor: Retail stores owned1111 Retail stores leased2222 (A)For years prior to 2010, the police and fire stations are included in the City Hall square footage reported above. Beginning in 2010, the police and fire stations were in a separate public safety facility. Sources: Various City departments. Fiscal Year 198 Table 18 200720082009201020112012 28,53028,53028,53028,53028,53028,530 111111 111111 Note ANote ANote A47,08847,08847,088 31,07531,07531,07531,07531,07531,075 333333 666666 626262626262 191919191919 111111 7,8967,8967,8967,8967,8967,896 131313131313 111111111111 - - 12,72612,72612,72612,726 22,00022,00022,00022,00022,00022,000 145145145145145145 666666666666 595959595959 111111 343434343434 133333 2 - - - - - Fiscal Year 199 - This page intentionally left blank - 200 IV. OTHER REQUIRED REPORTS SECTION 201 - This page intentionally left blank - 202 4810 White Bear Parkway White Bear Lake, MN 55110 651.426.7000 651.426.5004 fax www.hlbtr.com Equal Opportunity Employer 100-Percent Employee-Owned HLB Tautges Redpath is a member of HLB International, a world-wide network of independent accounting firms and business advisors. MINNESOTA LEGAL COMPLIANCE REPORT To the Honorable Mayor and Members of the City Council City of Columbia Heights, Minnesota We have audited, in accordance with auditing standards generally accepted in the United States of America, the financial statements of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information of the City of Columbia Heights, Minnesota, as of and for the year ended December 31, 2012, and the related notes to the financial statements , and have issued our report thereon dated June 28, 2013. The Minnesota Legal Compliance Audit Guide for Political Subdivisions, promulgated by the State Auditor pursuant to Minn. Stat. § 6.65, contains seven categories of compliance to be tested: contracting and bidding, deposits and investments, conflicts of interest, public indebtedness, claims and disbursements, miscellaneous provisions, and tax increment financing. Our audit considered all of the listed categories. In connection with our audit, nothing came to our attention that caused us to believe that the City of Columbia Heights, Minnesota failed to comply with the provisions of the Minnesota Legal Compliance Audit Guide for Political Subdivisions. However, our audit was not directed primarily toward obtaining knowledge of such noncompliance. Accordingly, had we performed additional procedures, other matters may have come to our attention regarding the City of Columbia Heights, Minnesota’s noncompliance with the above referenced provisions. This report is intended solely for the information and use those charged with governance and management of the City of Columbia Heights, Minnesota and the State Auditor and is not intended to be and should not be used by anyone other than these specified parties. HLB TAUTGES REDPATH, LTD. June 28, 2013  - This page intentionally left blank - 204 4810 White Bear Parkway White Bear Lake, MN 55110 651.426.7000 651.426.5004 fax www.hlbtr.com Equal Opportunity Employer 100-Percent Employee-Owned HLB Tautges Redpath is a member of HLB International, a world-wide network of independent accounting firms and business advisors. INDEPENDENT AUDITOR’S REPORT ON INTERNAL CONTROL OVER FINANCIAL REPORTING AND ON COMPLIANCE AND OTHER MATTERS BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS To the Honorable Mayor and Members of the City Council and Management City of Columbia Heights, Minnesota We have audited, in accordance with the auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards issued by the Comptroller General of the United States, the financial statements of the governmental activities, the business-type activities, the aggregate discretely presented component units, each major fund, and the aggregate remaining fund information of the City of Columbia Heights, Minnesota, as of and for the year ended December 31, 2012, and the related notes to the financial statements, which collectively comprise the City of Columbia Heights, Minnesota’s basic financial statements, and have issued our report thereon dated June 28, 2013. Internal Control Over Financial Reporting In planning and performing our audit of the financial statements, we considered the City of Columbia Heights, Minnesota’s internal control over financial reporting (internal control) to determine the audit procedures that are appropriate in the circumstances for the purpose of expressing our opinions on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of the City of Columbia Heights, Minnesota’s internal control. Accordingly, we do not express an opinion on the effectiveness of the City of Columbia Heights, Minnesota’s internal control. A deficiency in internal control exists when the design or operation of a control does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, misstatements on a timely basis. A material weakness is a deficiency, or a combination of deficiencies, in internal control such that there is a reasonable possibility that a material misstatement of the entity’s financial statements will not be prevented, or detected and corrected on a timely basis. A significant deficiency is a deficiency, or a combination of deficiencies, in internal control that is less severe than a material weakness, yet important enough to merit attention by those charged with governance. Our consideration of internal control was for the limited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in internal control that might be material weaknesses or significant deficiencies. Given these limitations, during our audit we did not identify  City of Columbia Heights, Minnesota Report on Internal Control over Financial Reporting and on Compliance and Other Matters Page 2 any deficiencies in internal control that we consider to be material weaknesses. However, material weaknesses may exist that have not been identified. Compliance and Other Matters As part of obtaining reasonable assurance about whether the City of Columbia Heights, Minnesota’s financial statements are free from material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements, noncompliance with which could have a direct and material effect on the determination of financial statement amounts. However, providing an opinion on compliance with those provisions was not an objective of our audit, and accordingly, we do not express such an opinion. The results of our tests disclosed no instances of noncompliance or other matters that are required to be reported under Government Auditing Standards. Purpose of this Report The purpose of this report is solely to describe the scope of our testing of internal control and compliance and the results of that testing, and not to provide an opinion on the effectiveness of the entity’s internal control or on compliance. This report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the entity’s internal control and compliance. Accordingly, this communication is not suitable for any other purpose. HLB TAUTGES REDPATH, LTD. June 28, 2013  4810 White Bear Parkway White Bear Lake, MN 55110 651.426.7000 651.426.5004 fax www.hlbtr.com Equal Opportunity Employer 100-Percent Employee-Owned HLB Tautges Redpath is a member of HLB International, a world-wide network of independent accounting firms and business advisors. REPORT ON SUPPLEMENTARY INFORMATION – FINANCIAL DATA SCHEDULE To the Honorable Mayor and Members of the City Council City of Columbia Heights, Minnesota We have audited the financial statements of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information of the City of Columbia Heights, Minnesota as of and for the year ended December 31, 2012, and have issued our report thereon dated June 28, 2013. Our audit was performed for the purpose of forming opinions on the financial statements that collectively comprise the City of Columbia Heights, Minnesota’s basic financial statements. The accompanying Financial Data Schedule is presented for purposes of additional analysis as required by the U.S. Department of Housing and Urban Development and is not a required part of the basic financial statements. Such information has been subjected to the auditing procedures applied in the audit of the basic financial statements and, in our opinion, is fairly stated, in all material respects, in relation to the basic financial statements taken as a whole. This report is intended solely for the information and use of the City of Columbia Heights, Minnesota and federal awarding agencies and pass-through entities and is not intended to be, and should not be, used by anyone other than those specified parties. HLB TAUTGES REDPATH, LTD. June 28, 2013  - This page intentionally left blank - 208 CITY OF COLUMBIA HEIGHTS, MINNESOTA U.S. DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT FINANCIAL DATA SCHEDULE As of And For The Year Ended December 31, 2012 Line ItemAccount DescriptionTotal Projects Assets: Current assets: 111 Cash - unrestricted $32,232 114 Cash - tenant security deposits18,625 100 Total cash 50,857 Accounts and notes receivable: 122 Accounts receivable - HUD other projects81,560 126 Accounts receivable - tenants1,876 120 Total receivables, net of allowance83,436 Investments: 132 Investments - Restricted 895,206 150 Total current assets 1,029,499 Noncurrent assets: Capital assets: 161 Land 177,375 162 Buildings 3,208,785 163 Furniture, equipment and machinery - dwellings297,466 164 Furniture, equipment and machinery - administration8,842 166 Less: accumulated depreciation(2,594,107) 167 Construction in progress136,020 160 Total capital assets, net of accumulated depreciation1,234,381 180 Total noncurrent assets1,234,381 190 Total assets 2,263,879 Liabilities: Current liabilities: 312 Accounts payable <= 90 days$122,531 333 Accounts payable - other governments24,326 341 Tenant security deposits 18,625 342 Deferred revenue 40 345 Other current liabilities 1,543 310 Total current liabilities167,065 350 Total noncurrent liabilities0 300 Total liabilities 167,065 Net Position: 508.1 Net investment in capital assets1,234,381 509 Fund balance reserved for operating activities862,434 513 Total net position$2,096,815 209 CITY OF COLUMBIA HEIGHTS, MINNESOTA U.S. DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT FINANCIAL DATA SCHEDULE As of And For The Year Ended December 31, 2012 Page 2 of 2 Public HousingPublic Housing OperatingCapital Fund Line SubsidyProgram ItemAccount Description14.85014.872Total Projects Revenue: 703 Net tenant rental revenue$354,216$ - $354,216 704 Tenant revenue - other13,834 - 13,834 706 HUD PHA grants - 184,349184,349 715 Other revenue2,346 - 2,346 720 Investment income - restricted4,042 - 4,042 700 Total revenue374,438 184,349 558,787 Expenses: 911 Administrative salaries25,500 - 25,500 912 Auditing fees3,010 - 3,010 913 Outside management fees161,666 - 161,666 914 Advertising and marketing150 - 150 916 Other operating - administrative3,312 - 3,312 917 Legal expense3,616 - 3,616 919 Other expense2,802 - 2,802 931 Water 14,571 - 14,571 932 Electricity48,122 - 48,122 933 Gas 28,055 - 28,055 936 Sewer 11,549 - 11,549 938 Other utilities expense14,135 - 14,135 942 Ordinary maintenance and operations - materials and other26,947 - 26,947 943 Ordinary maint. and operations contracts - HVAC6,579 - 6,579 943 Ordinary maint. and operations contracts - snow removal1,878 - 1,878 943 Ordinary maint. and operations contracts - elevator9,379 - 9,379 943 Ordinary maint. and operations contracts - grounds4,918 - 4,918 943 Ordinary maint. and operations contracts - unit turnaround16,650 - 16,650 943 Ordinary maint. and operations contracts - electrical456 - 456 943 Ordinary maint. and operations contracts - plumbing88,880 - 88,880 943 Ordinary maint. and operations contracts - extermination1,513 - 1,513 943 Ordinary maint. and operations contracts - janitorial3,508 - 3,508 943 Ordinary maint. and operations contracts - routine maintenance28,478 - 28,478 943 Ordinary maint. and operations contracts - miscellaneous1,191 - 1,191 952 Protective services11,566 - 11,566 961 Insurance premiums20,966 - 20,966 962 Other general expenses2,415 - 2,415 963 Payments in lieu of taxes24,702 - 24,702 969 Total operating expenses566,514 0 566,514 974 Depreciation103,793103,793 900 Total expenses670,307 0 670,307 1001Operating transfers in184,349 - 184,349 1002Operating transfers out - (184,349)(184,349) 1010 Total other financing sources (uses)184,349 (184,349)0 1000Excess (deficiency) of revenue over expenses and and other financing uses (sources)($111,520)$0($111,520) Memo account information: 1103 Beginning equity$2,204,634$ - $2,204,634 1120 Unit months available1,212 - 1,212 1121 Number of unit months leased1,188 - 1,188 210 CITY OF COLUMBIA HEIGHTS, MINNESOTA U.S DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT FINANCIAL DATA SCHEDULE - STATEMENT AND CERTIFICATION OF ACTUAL MODERNIZATION COSTS As of and For The Year Ended December 31, 2012 FY 2009FY 2009FY 2010FY 2011FY 2012 MN 46P10550109MN 46S10550109MN 46P105501-10MN 46P105501-11MN 46P105501-12 A.The actual modernization costs are as follows: Funds approved$112,026$131,959$110,976$92,207$92,200 Funds (expended)(112,026)(131,959)(110,976)(75,706)(23,847) Excess of funds approved (expended)$ - $ - $ - $16,501$68,353 Funds advanced - HUD CFP Grants$112,026$131,959$110,976$17,993$ - Funds (expended): In prior years(112,026)(131,959)(25,352)(829) In current year - - (85,624)(74,877)(23,847) Excess of funds advanced (expended)$ - $ - $ - ($57,713)($23,847) 211 - This page intentionally left blank - 212