Loading...
2016 City of Hopkins, MN Annual ReportCity of Hopkins, Minnesota Comprehensive Annual Financial Report for year ended December 31, 2016 16 COMPREHENSIVE ANNUAL FINANCIAL REPORT of the CITY OF HOPKINS, MN For The Year Ended December 31, 2016 Prepared by the Department of Finance 7+(&,7<2)+23.,160,11(627$ &2035(+(16,9($118$/),1$1&,$/5(3257 <($5(1'(''(&(0%(5 7$%/(2)&217(176 ,,1752'8&725<6(&7,21 3DJH /HWWHURI7UDQVPLWWDOIURPWKH&LW\0DQDJHUDQG)LQDQFH'LUHFWRU  &HUWLILFDWHRI$FKLHYHPHQWIRU([FHOOHQFHLQ)LQDQFLDO5HSRUWLQJ  $GPLQLVWUDWLYH2UJDQL]DWLRQ&KDUW  &LW\2IILFLDOV  ,,),1$1&,$/6(&7,21 ,QGHSHQGHQW$XGLWRUV 5HSRUW  0DQDJHPHQW V'LVFXVVLRQDQG$QDO\VLV  $%DVLF)LQDQFLDO6WDWHPHQWV *RYHUQPHQWZLGH)LQDQFLDO6WDWHPHQWV 6WDWHPHQWRI1HW3RVLWLRQ  6WDWHPHQWRI$FWLYLWLHV  )XQG)LQDQFLDO6WDWHPHQWV %DODQFH6KHHW*RYHUQPHQWDO)XQGV  5HFRQFLOLDWLRQRIWKH%DODQFH6KHHWRI*RYHUQPHQWDO)XQGV WRWKH6WDWHPHQWRI1HW3RVLWLRQ  6WDWHPHQWRI5HYHQXHV([SHQGLWXUHVDQG&KDQJHVLQ )XQG%DODQFHV*RYHUQPHQWDO)XQGV  5HFRQFLOLDWLRQRIWKH6WDWHPHQWRI5HYHQXHV([SHQGLWXUHV DQG&KDQJHVLQ)XQG%DODQFHVRI*RYHUQPHQWDO)XQGV WRWKH6WDWHPHQWRI$FWLYLWLHV  6WDWHPHQWRI5HYHQXHV([SHQGLWXUHVDQG&KDQJHVLQ)XQG%DODQFHV %XGJHWDQG$FWXDO*HQHUDO)XQG  6WDWHPHQWRI5HYHQXHV([SHQGLWXUHVDQG&KDQJHVLQ)XQG%DODQFHV %XGJHWDQG$FWXDO(FRQRPLF'HYHORSPHQW6SHFLDO5HYHQXH)XQG  6WDWHPHQWRI5HYHQXHV([SHQGLWXUHVDQG&KDQJHVLQ)XQG%DODQFHV %XGJHWDQG$FWXDO$UWV&HQWHU6SHFLDO5HYHQXH)XQG  6WDWHPHQWRI5HYHQXHV([SHQGLWXUHVDQG&KDQJHVLQ)XQG%DODQFHV %XGJHWDQG$FWXDO7D[,QFUHPHQW'LVWULFW6XSHU9DOX 6SHFLDO5HYHQXH)XQG  6WDWHPHQWRI1HW3RVLWLRQ3URSULHWDU\)XQGV  6WDWHPHQWRI5HYHQXHV([SHQVHVDQG&KDQJHVLQ 1HW3RVLWLRQ3URSULHWDU\)XQGV  6WDWHPHQWRI&DVK)ORZV3URSULHWDU\)XQGV  1RWHVWR)LQDQFLDO6WDWHPHQWV  i 7+(&,7<2)+23.,160,11(627$ &2035(+(16,9($118$/),1$1&,$/5(3257 <($5(1'(''(&(0%(5 3DJH %5HTXLUHG6XSSOHPHQWDU\,QIRUPDWLRQ 6FKHGXOHRI)XQGLQJ3URJUHVV2WKHU3RVWHPSOR\PHQW%HQHILW3ODQ  6FKHGXOHRI3URSRUWLRQDWH6KDUHRI1HW3HQVLRQ/LDELOLW\3XEOLF(PSOR\HHV *HQHUDO(PSOR\HHV5HWLUHPHQW)XQG  6FKHGXOHRIWKH&LW\ V&RQWULEXWLRQ  6FKHGXOHRIWKH&LW\ V&RQWULEXWLRQWRWKH+RSNLQV)LUH5HOLHI)XQG  6FKHGXOHRIWKH3URSRUWLRQDWH6KDUHRI1HW3HQVLRQ/LDELOLW\+RSNLQV)LUH5HOLHI  &&RPELQLQJDQG,QGLYLGXDO1RQPDMRU)XQG6WDWHPHQWVDQG6FKHGXOHV &RPELQLQJ%DODQFH6KHHW1RQPDMRU*RYHUQPHQWDO)XQGV  &RPELQLQJ6WDWHPHQWRI5HYHQXHV([SHQGLWXUHVDQG&KDQJHV LQ)XQG%DODQFHV1RQPDMRU*RYHUQPHQWDO)XQGV  6FKHGXOHVRI5HYHQXHV([SHQGLWXUHVDQG&KDQJHVLQ)XQG %DODQFHV%XGJHWDQG$FWXDO 6SHFLDO5HYHQXH)XQGV 6WDWH&KHPLFDO$VVHVVPHQW 3DUNLQJ  &RPPXQLFDWLRQV  'HSRW&RIIHH+RXVH  7D[,QFUHPHQW'LVWULFW(QWHUWDLQPHQW&HQWHU  7D[,QFUHPHQW'LVWULFW6RQRPD3URMHFW  7D[,QFUHPHQW'LVWULFW2DNVRI0DLQVWUHHW  WK$YHQXH)ODWV  7D[,QFUHPHQW'LVWULFW0DUNHWSODFH 0DLQ  &RPELQLQJ6WDWHPHQWRI1HW3RVLWLRQ1RQPDMRU(QWHUSULVH)XQGV  &RPELQLQJ6WDWHPHQWRI5HYHQXHV([SHQVHVDQG&KDQJHVLQ 1HW3RVLWLRQ1RQPDMRU(QWHUSULVH)XQGV  &RPELQLQJ6WDWHPHQWRI&DVK)ORZV1RQPDMRU(QWHUSULVH)XQGV  &RPELQLQJ6WDWHPHQWRI1HW3RVLWLRQ,QWHUQDO6HUYLFH)XQGV  &RPELQLQJ6WDWHPHQWRI5HYHQXHV([SHQVHVDQG&KDQJHVLQ 1HW3RVLWLRQ,QWHUQDO6HUYLFH)XQGV  &RPELQLQJ6WDWHPHQWRI&DVK)ORZV,QWHUQDO6HUYLFH)XQGV  ii 7+(&,7<2)+23.,160,11(627$ &2035(+(16,9($118$/),1$1&,$/5(3257 <($5(1'(''(&(0%(5 ,,,67$7,67,&$/6(&7,21 3DJH $)LQDQFLDO7UHQGV 1HW3RVLWLRQE\&RPSRQHQW  &KDQJHVLQ1HW3RVLWLRQ  )XQG%DODQFHV*RYHUQPHQWDO)XQGV  &KDQJHVLQ)XQG%DODQFHV*RYHUQPHQWDO)XQGV  %5HYHQXH&DSDFLW\ $VVHVVHGDQG$FWXDO9DOXHRI7D[DEOH3URSHUW\  'LUHFWDQG2YHUODSSLQJ3URSHUW\7D[5DWHV  3ULQFLSDO3URSHUW\7D[SD\HUV  3URSHUW\7D[/HYLHVDQG&ROOHFWLRQV  &'HEW&DSDFLW\ 5DWLRVRI2XWVWDQGLQJ'HEWE\7\SH  5DWLRVRI1HW*HQHUDO%RQGHG'HEW2XWVWDQGLQJ  'LUHFWDQG2YHUODSSLQJ*RYHUQPHQWDO$FWLYLWLHV'HEW  /HJDO'HEW0DUJLQ,QIRUPDWLRQ  3OHGJHG5HYHQXH&RYHUDJH  ''HPRJUDSKLFDQG(FRQRPLF,QIRUPDWLRQ 'HPRJUDSKLFDQG(FRQRPLF6WDWLVWLFV  3ULQFLSDO(PSOR\HUV  (2SHUDWLQJ,QIRUPDWLRQ )XOOWLPH(TXLYDOHQW&LW\(PSOR\HHVE\7\SH  2SHUDWLQJ,QGLFDWRUVE\)XQFWLRQ3URJUDP  &DSLWDO$VVHW6WDWLVWLFVE\)XQFWLRQ3URJUDP  iii CITY OF HOPKINS, MINNESOTA COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE YEAR ENDED DECEMBER 31, 2016 SECTION I INTRODUCTORY SECTION 1 2 June 9, 2017 To the Honorable Mayor, Members of the Hopkins City Council and the Citizens of the City of Hopkins, Minnesota: The Comprehensive Annual Financial Report (CAFR) of the City of Hopkins, Minnesota (the City) for the fiscal year ended December 31, 2016 is hereby submitted. This report was prepared in accordance with U.S. generally accepted accounting principles (GAAP) as established by the Governmental Accounting Standards Board (GASB) and meets the requirements of the Minnesota State Auditor’s Office. This report consists of management’s representations concerning the finances of the City of Hopkins. Consequently, management assumes full responsibility for both the completeness and reliability of all of the information presented in this report. To provide a reasonable basis for making these representations, management of the City of Hopkins has established a comprehensive internal control framework that is designed both to protect the government’s assets from loss, theft, or misuse and to compile sufficient reliable information for the preparation of the City of Hopkins financial statements in conformity with GAAP. Because the cost of internal controls should not outweigh their benefits, the City of Hopkins comprehensive framework of internal controls has been designed to provide reasonable rather than absolute assurance that the financial statements will be free from material misstatement. As management, we assert that, to the best of our knowledge and belief, this financial report is complete and reliable in all material respects. The City of Hopkins financial statements have been audited by CliftonLarsonAllen LLP, a firm of licensed certified public accountants. The goal of the independent audit was to provide reasonable assurance that the financial statements of the City of Hopkins for the fiscal year ended December 31, 2016, are free of material misstatement. The independent audit involved examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements; assessing the accounting principles used and significant estimates made by management; and evaluating the overall financial statement presentation. The independent auditor concluded based upon the audit, that there was a reasonable basis for rendering unmodified opinions that the City of Hopkins financial statements for the fiscal year ended December 31, 2016, are fairly presented in conformity with GAAP. The independent auditors’ report is presented as the first component of the financial section of this report. GAAP requires 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’s MD&A can be found in the financial section of this report immediately following the report of the independent auditors. 3 Profile of the Government Hopkins was first settled in 1853 and was incorporated as the Village of West Minneapolis in 1893. The name was changed in 1928 to Hopkins after one of the early residents. The original territory of incorporation was three square miles, but successive annexation since 1946 has enlarged this area by one-third. In 1947, the residents of the area adopted a City Charter with a Council/Manager form of government. The governing council is responsible, among other things, for passing ordinances, adopting the budget, appointing committees and hiring the government’s manager and the government’s attorney. The government’s manager is responsible for carrying out the policies and ordinances of the government, for overseeing day-to-day operations of the government and for appointing the heads of the government’s departments. The report includes all funds of the City, including the City’s Housing and Redevelopment Authority (HRA). The City provides a full range of services including general government, public safety, highways and streets, urban redevelopment and housing, culture and recreation, and health and welfare. In addition to general municipal activities, the City provides water, sewer, storm sewer and refuse services and operates an ice arena. Low-income rental housing is a function of the HRA. The Hopkins Fire Relief Association has not met the established criteria for inclusion in the reporting entity, and accordingly is excluded from this report. The annual budget serves as the foundation for the City of Hopkins financial planning and control. All departments of the City of Hopkins are required to submit requests for appropriation to the Finance Director by July of each year. The Finance Director uses these requests as the starting point for developing a proposed budget. The Finance Director then presents this proposed budget to the Council for review prior to September 30th. The Council is required to hold public hearings on the proposed budget and to adopt a final budget no later than December 31, the close of the City of Hopkins fiscal year. The appropriated budget is prepared by fund and department. Department heads may make transfers of appropriations within a department. Transfers of appropriations between funds require approval of the City Council. Budget to actual comparisons are provided in this report for each individual governmental fund for which an annual budget has been adopted. For the General Fund and the major Special Revenue Funds this comparison is presented on pages 37-40 as part of the basic financial statements for the governmental funds. For governmental funds, other than the General fund and major Special Revenue Funds, with annual budgets, this comparison is presented in the combining and individual fund statements and schedules subsection of this report on pages 106-114. Factors Affecting Financial Condition The City of Hopkins, consisting of 2,504 acres, is located in Hennepin County on the westerly fringe of the Minneapolis urban area. The City, as part of the Minneapolis-St. Paul metropolitan complex, is readily accessible by the many highways and railways leading into the area. This easy access prompted steady growth for the City of Hopkins during its formative years. In response to this growth the City developed goals of working towards a planned community, with its policies directed toward sound ratios of residential, commercial and industrial components, with the current tax base approximately 76% single family residential and apartments, and 24% commercial-industrial. The city’s population has stabilized due to the fact that the City is largely developed and the national trend toward the lowering of persons per household. 4 The City Council and staff along with an organized group of concerned partners determined what the Vision and the Mission of the City of Hopkins should be. Participation in this project was very high and the resulting Vision and Mission are as follows: Community Vision Creating a Spirit of Unity – Hopkins will be a community where  People are treated with respect  People participate in building culture, character and common bonds  Business growth throughout the City is supported while maintaining a vibrant City center  People feel safe, support outstanding schools and celebrate cultural heritages  People enjoy quality public services, parks and housing City of Hopkins Mission  Inspire, Educate, Involve, Communicate Economic Condition and Outlook Hopkins continues to show strong economic and redevelopment activities within the city. The valuation of new non-residential construction in 2016 was $64.8 million dollars. This development activity has been the result of a good development market in the Hopkins area along with successful planning on the part of the city council and city staff. Significant projects completed or begun in 2016 include the following: Activity Valuation Commercial Additions/Alterations: Oxford Green Apartments $ 7,000,000 Metropolitan Council Lift Station $ 5,000,000 Hopkins Village Apartments remodel $ 4,400,000 The Moline Apartments $53,000,000 Efforts are being made for continued development and growth for 2017 and beyond. It is anticipated that over $150,000,000 of construction will also take place in the City of Hopkins during the next several years. Some anticipated projects for 2017-2019 include the following: Project Valuation Hopkins Cold Storage Site Redevelopment $62,000,000 EBCO Site redevelopment $10,000,000 Long-term financial planning The City of Hopkins has a strategic plan for economic development and has completed extensive planning work in anticipation of the Southwest Light Rail Transit (SWLRT) line and the three Hopkins LRT stations. As a part of the plans, the City of Hopkins intends to pursue various development and redevelopment efforts throughout the City. Several projects are anticipated. In 2016, several commercial projects were completed among which was the Hopkins Village Apartments remodel. In addition the Johnson Building redevelopment was started. This development by Doran Companies known as "The Moline" will be a 241-unit market rate apartment building with state-of-the-art amenities along with retail on the first level. The project is projected 5 to be completed in the fall of 2017. Also started was the Oxford Green Apartments, an affordable housing project next to the newly enhanced Cottageville Park. These developments will have major impacts on the community. Specialized planning is taking place to ensure that these developments occur so as to benefit the community and residential neighborhoods. Significant improvements for Shady Oak Road (County Road 61) began in 2013 and were completed in 2016. This project is a joint effort between Hennepin County and the Cities of Minnetonka and Hopkins. A number of neighborhood and town meetings were held to gather input on this project that will re-align the road and facilitate re-development of the area. The project began in earnest in 2013 with the acquisition of right of way property with major road construction starting in 2014 and finishing in 2016. Another project in the planning stages is the 14-mile Southwest Corridor Light Rail Transit (SWLRT) line that will go from Eden Prairie to downtown Minneapolis passing through Hopkins and providing development potential at three transit stations that are planned for Hopkins. In downtown Minneapolis the Southwest LRT will connect with the Hiawatha and Central LRT lines. Construction of the light rail line is expected to begin in 2017 and is expected to be funded with the Counties Transit Improvement Board’s transit sales tax in the metro area (30%), and with Hennepin County Regional Railroad Authority (10%), Federal (50%), and State (10%) dollars. Relevant Financial Policies The City of Hopkins has adopted a comprehensive set of financial policies. While no new policies were developed in 2016 staff continues to review current policies to ensure the remain relevant. In addition the City of Hopkins’ Fund Balance policy requires that the General Fund’s Unassigned portion of fund balance be equivalent to a minimum of five months expenditures or 42% of the prior fiscal year General Fund operating expenses. At December 31, 2016 the General Fund unassigned fund balance is at 44.2% or $5,437,773 which represents slightly more than five months expenditures of the 2016 budget. Due to sound fiscal policy and close monitoring of budgets we remain at the targeted General Fund balance goal. Major Initiatives For 2016, the staff, following specific directives of the council and the city manager, has been involved in a variety of projects throughout the year. These projects reflect the government’s commitment to ensuring that its citizens are able to live and work in a safe environment and that the needs for services are met. In 2016, we accomplished our annual street repair and improvements, at a cost of approximately $4,180,750. This included the city's share of the Shady Oak Road project, along with improvements to Mainstreet reconstruction. Along with the street improvements, improvements to the parking ramp totaled $400,470. In addition preliminary work was begun on the 2017 street improvement project. We continue to improve Cottageville Park and invested $521,350 in that park in 2016 adding a pavilion. Additional park project improvements for 2016 totaled $1,083,870 and included improvements to Oakes, Valley, Hilltop and Burnes Parks and Maetzold Field. The water, sewer and storm sewer departments also completed in conjunction with the street improvements, infrastructure reconstruction projects totaling $2,543,200. In addition rehabilitation 6 work was done on the Blake and Moline water towers totaling $1,087,960. Other projects included work on Lift Station No. 7 that will continue into 2017. Other improvement projects in 2016 included Public Works garage upgrade totaling $821,875 with the project continuing into 2017, and smaller improvements to the Activity Center gymnasium and city hall office remodeling as a result of staff reorganization. Future projects A systematic citywide sidewalk rehab program was initiated in 1992. Each year one quadrant is inspected and necessary repairs made. A sidewalk/trail plan was developed and implemented in 2003, which guides future improvements and connections to regional trails. The City has established a street reconstruction and storm sewer program based on a street condition survey and storm water management program. The streets found in poor condition and future problem streets will be systematically included for repairs in the five-year Capital Improvement Plan. Certificate of Achievement For Excellence in Financial Reporting The Government Finance Officers Association of the United States and Canada (GFOA) awarded a Certificate of Achievement for Excellence in Financial reporting to the City of Hopkins for its comprehensive annual finance report for the fiscal year ended December 31, 2015. In order to be awarded a Certificate of Achievement for Excellence in Financial Reporting, a governmental unit must publish an easily readable and efficiently organized comprehensive annual financial report. This report must satisfy both U.S. generally accepted accounting principles and applicable legal requirements. A Certificate of Achievement is valid for a period of one year only. We believe our current comprehensive annual financial report continues to meet the Certificate of Achievement Program’s requirements and we are submitting it to the GFOA to determine its eligibility for another certificate. Acknowledgments We wish to express our appreciation to the Mayor and City Council for their continued interest and support in planning and conducting the financial operations of the City in a responsible and progressive manner. We also want to express our appreciation to the Finance Department staff for their work in preparing this report. Respectfully submitted, Michael J. Mornson Christine M. Harkess, CPA, CGFM City Manager Finance Director 7 8 Organizational Chart CITIZENS City Manager CITY COUNCIL Community Services Finance Fire Police Planning & Economic Development Recreation Public Works City of Minnetonka Assessing City Clerk Communications Information Services Inspections Reception Activity Center Accounting Payroll Utility Billing Economic Development Housing Planning & Zoning Public Housing Fire & Medical Response Prevention Emergency Preparedness Patrol Investigation Communication Crime Prevention Building Maint. & Equipment Services Engineering Parks & Forestry Street/Traffic/Refuse Water & Sewer Pavilion/Ice Arena Boards & Commissions City Attorney Administrative Services Center for the Arts Depot Coffee House 9 THE CITY OF HOPKINS, MINNESOTA COMPREHENSIVE ANNUAL FINANCIAL REPORT Term Expires Molly Cummings Mayor 12-31-17 Katy Campbell Councilmember 12-31-17 Jason Gadd Councilmember 12-31-19 Kristi Halverson Councilmember 12-31-17 Aaron Kuznia Councilmember 12-31-19 Michael J. Mornson Appointed Christine M. Harkess Appointed DIRECTOR OF FINANCE CITY COUNCIL CITY OFFICIALS CITY MANAGER December 31, 2016 10 CITY OF HOPKINS, MINNESOTA COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE YEAR ENDED DECEMBER 31, 2016 SECTION II FINANCIAL SECTION 11 CliftonLarsonAllen LLP CLAconnect.com INDEPENDENT AUDITORS’ REPORT Honorable Mayor and Members of the City Council City of Hopkins, 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 Hopkins, Minnesota (the City), as of and for the year ended December 31, 2016, 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. Auditors’ 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 auditors’ 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. 12 Honorable Mayor and Members of the City Council City of Hopkins, Minnesota 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 as of December 31, 2016, and the respective changes in financial position and, where applicable, cash flows thereof and the respective budgetary comparison for the General Fund and major special revenue funds for the year then ended in accordance with accounting principles generally accepted in the United States of America. Other Matters Required Supplementary Information Accounting principles generally accepted in the United States of America require that the management’s discussion and analysis, schedule of funding progress – other postemployment benefits plan, schedules of the City’s proportionate share of net pension liabilities and schedules of pension contributions 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. Other Information Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the City’s basic financial statements. The introductory section, combining and individual nonmajor fund statements and schedules and statistical section are presented for purposes of additional analysis and are not a required part of the basic financial statements. The combining and individual nonmajor fund statements and schedules 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 statements and schedules are fairly stated, in all material respects, in relation to the basic financial statements as a whole. The introductory and statistical 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. 13 Honorable Mayor and Members of the City Council City of Hopkins, Minnesota Other Reporting Required by Government Auditing Standards In accordance with Government Auditing Standards, we have also issued our report dated June 9, 2017 on our consideration of the City’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 result 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’s internal control over financial reporting and compliance. CliftonLarsonAllen LLP Minneapolis, Minnesota June 9, 2017 14 CITY OF HOPKINS, MINNESOTA MANAGEMENT’S DISCUSSION AND ANALYSIS (Unaudited) This section of the City’s comprehensive annual financial report presents a discussion and analysis of the City’s financial activities during the fiscal year ended December 31, 2016. This discussion and analysis should be read in conjunction with the letter of transmittal in the introductory section of this report. Financial Highlights  The assets and deferred outflows of the City exceeded liabilities and deferred inflows at the close of the 2016 fiscal year by approximately $56.3 million (net position). Of this amount, approximately $18.3 million (unrestricted net position) is unavailable to meet the City’s ongoing obligations to citizens and creditors due in part to the recognition of the City's share of the unfunded pension obligation.  The City’s total net position decreased by approximately $6.2 million. A key factor in this decrease included changes in pension assumptions. Actuarial assumptions were changed, including the lowering of the assumed investment return and discount rate. These changes contributed to the increase in the net pension liability and the decrease in net position.  As of the close of the current fiscal year, the City's governmental funds reported combined ending fund balances of approximately $23.3 million, an decrease of approximately $(3.6) million in comparison with the prior year. The decrease was primarily due to the payment of refunding bonds February 2016. Approximately $3.0 million of fund balance is available for spending at the City’s discretion (assigned or unassigned fund balance).  As of December 31, 2016, unassigned fund balance for the General Fund was approximately $5.5 million, or 45% of total general fund expenditures. This compares to $5.4 million from the prior year, an increase of approximately $93,000. The General Fund working capital goal policy stated that the City will strive to maintain a fund balance in the General Fund for working capital of 42% of the previous year's General Fund expenditures. At December 31st working capital is at 45%.  The City of Hopkins total debt increased by approximately $8.855 million during the current fiscal year due to the sale of improvement, tax abatement and refunding bonds for four bond issues. Total new debt totaled $12.3 million and bond maturities totaled $3.455 million. Overview of the Financial Statements This discussion and analysis is intended to serve as an introduction to the City of Hopkins basic financial statements. The City of Hopkins basic financial statements comprise 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 of Hopkins finances, in a manner similar to a private- sector business. 15 The statement of net position presents information on all of the City of Hopkins assets, deferred outflows of resources, liabilities, and deferred inflows of resources with the difference between them 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 of Hopkins is improving or deteriorating. The statement of activities presents information showing how the City 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 of Hopkins 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 of Hopkins include general, public safety, highways, streets, culture, recreation, urban redevelopment, housing, health and welfare. The business-type activities of the City of Hopkins include water, sewer, refuse, storm sewer utilities, an ice arena, and a housing and redevelopment authority. The government-wide financial statements include the City of Hopkins itself, but also a legally separate Hopkins Housing and Redevelopment Authority. Although the Hopkins Housing and Redevelopment Authority is legally separate, it functions for all practical purposes as a department of the City of Hopkins, and therefore has been included as an integral part of the primary government. The government-wide financial statements can be found on pages 29-30 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 of Hopkins, 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 of Hopkins can be divided into two categories: governmental funds and proprietary 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 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 City’s near-term financing 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 financing decisions. Both the governmental fund balance sheet and the governmental fund statement of revenues, expenditures, and changes in fund balance provide a reconciliation to facilitate this comparison between governmental funds and governmental activities. The City of Hopkins maintains thirty-nine individual governmental funds. 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 the General Fund, Economic Development, Arts Center, 16 Tax Increment District Super Valu, 2015D GO TI Revenue Bonds, 2016D GO TI Revenue Bonds, and Permanent Improvement Revolving fund all of which are considered to be major funds. Data from the other thirty-two 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 of Hopkins adopts an annual appropriated budget for its general fund and all of its special revenue funds except for the Community Development Block Grant fund. A budgetary comparison statement has been provided for the General fund and major special revenue funds and schedules are provided for other funds to demonstrate compliance with the budget. The basic governmental fund financial statements can be found on pages 31-40 of this report. Proprietary funds. The City of Hopkins maintains two 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 of Hopkins uses enterprise funds to account for its water, sewer, refuse, storm sewer utilities, the pavilion ice arena, and the housing and redevelopment authority. Internal service funds are an accounting device used to accumulate and allocate costs internally among the City of Hopkins various functions. The City of Hopkins uses internal service funds to account for replacement of equipment, insurance deductibles and compensated absences. Because all of these services predominantly benefit governmental rather than business-type functions, they have been included within governmental 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, storm sewer utility funds, all of which are considered to be major funds of the City of Hopkins. Data from the other three enterprise funds are combined into a single, aggregated presentation. Individual fund data for each of these non-major proprietary funds is provided in the form of combining statements elsewhere in this report. 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 also provided in the form of combining statements elsewhere in this report. The basic proprietary fund financial statements can be found on pages 41-44 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. The notes to the financial statements can be found on pages 47-80 of this report. Other Information In addition to the basic financial statements and accompanying notes, this report also presents certain required supplementary information. Required supplementary information can be found on pages 82- 85 of this report. The combining statements referred to earlier in connection with non-major governmental funds, non- major proprietary funds and internal service funds are presented immediately following the required supplementary information. Combining and individual fund statements and schedules can be found on pages 88-122 of this report. 17 Government-Wide Financial Analysis As noted earlier, net position may serve over time as a useful indicator of a government’s financial position. In the case of the City of Hopkins, assets and deferred outflows exceeded liabilities and deferred inflows by $56,261,981 at the close of the most recent fiscal year. Due to the recognition of pension liability almost all (99%) of the City of Hopkins net position is reflected in its investment in capital assets (e.g., land, buildings, machinery and equipment); less any related debt used to acquire those assets that are still outstanding. The City of Hopkins uses these capital assets to provide services to citizens. The net capital assets are not available for future spending. Although the City of Hopkins investment in its capital assets is reported net of related debt, it should be noted that the resources needed to repay this debt must be provided from other sources. City of Hopkins Net Position December 31 Governmental Activities Business-Type Activities Total 2016 2015 2016 2015 2016 2015 Assets Current and other assets $ 32,309,895 $ 35,661,380 $ 2,492,028 $ 2,611,965 $ 34,801,923 $ 38,273,345 Capital assets 62,806,224 57,145,566 26,220,444 22,701,488 89,026,668 79,847,054 Total assets 95,116,119 92,806,946 28,712,472 25,313,453 123,828,591 118,120,399 Deferred Outflows of Resources Deferred charges on refunding 268,705 309,483 - - 268,705 309,483 Pensions 10,987,857 1,355,974 585,768 113,826 11,573,625 1,469,800 Total deferred outflows of resources 11,256,562 1,665,457 585,768 113,826 11,842,330 1,779,283 Liabilities Other liabilities 3,239,754 2,916,998 1,048,924 262,178 4,288,678 3,179,176 Long-term liabilities outstanding 67,188,279 47,533,793 5,880,393 5,769,591 73,068,672 53,303,384 Total liabilities 70,428,033 50,450,791 6,929,317 6,031,769 77,357,350 56,482,560 Deferred Inflows of Resources Pensions 1,846,644 843,495 135,305 82,636 1,981,949 926,131 Net Position Net investment in capital assets 33,833,387 32,609,356 21,798,183 17,893,856 55,631,570 50,503,212 Restricted 13,892,866 20,016,574 - - 13,892,866 20,016,574 Unrestricted (13,628,249) (9,447,813) 435,435 1,419,018 (13,192,814) (8,028,795) Total net position $ 34,098,004 $ 43,178,117 $ 22,233,618 $ 19,312,874 $ 56,331,622 $ 62,490,991 A portion of the City of Hopkins net position represent resources that are subject to external restrictions on how they may be used. At the end of the current fiscal year, the City of Hopkins is able to report positive balances in three categories of net position, for its governmental activities and in all categories for the business-type activities. The City’s net position decreased by $6,159,369 during the current fiscal year. The net pension liability and the pension-related deferred outflows and inflows of resources (which are reported in accordance with GASB Statement No. 68), do not change the City's future funding requirements or obligations under the plans, which are determined by state statutes. Additionally, the City has recorded the net pension asset of the Hopkins Fire Department Relief Association in the government-wide statements. 18 Net position was impacted by $7,957,695 at December 31, 2016 due to the implementation of this standard. Pension-related amounts included in the above schedule related to the standard are as follows: Net pension asset $ 451,063 Deferred outflows of resources 11,573,625 Net pension liability (18,000,434) Deferred inflows of resources (1,981,949) Total $ (7,957,695) (remainder of this page left blank intentionally) 19 Governmental and business-type activities. Governmental activities decreased the City of Hopkins net position by $9,080,113 and business-type activities increased net position by $2,851,103. Key elements of the increases are as follows: City of Hopkins Changes in Net Position For the Year Ended December 31 Governmental Activities Business-Type Activities Total 2016 2015 2016 2015 2016 2015 Revenues: Program revenues: Charges for services $ 1,492,055 $ 1,367,196 $ 5,815,341 $ 5,705,338 $ 7,307,396 $ 7,072,534 Operating grants and contributions 4,087,923 4,970,313 721,677 622,332 4,809,600 5,592,645 Capital grants and contributions 1,109,278 501,029 702,555 - 1,811,833 501,029 General revenues: Property taxes 11,994,436 11,038,746 63,519 64,161 12,057,955 11,102,907 Tax increments 2,959,459 2,920,681 - - 2,959,459 2,920,681 Grants and contributions not restricted 20,510 20,510 - - 20,510 20,510 Investment earnings 124,406 279,418 13,231 23,477 137,637 302,895 Gain on sale of capital assets 62,013 27,535 9,776 - 71,789 27,535 Total revenues 21,850,080 21,125,428 7,326,099 6,415,308 29,176,179 27,540,736 Expenses: General government 10,341,183 6,656,991 - - 10,341,183 6,656,991 Public safety 8,561,759 6,665,974 - - 8,561,759 6,665,974 Health and welfare 185,301 185,248 - - 185,301 185,248 Highways and streets 5,168,939 4,542,014 - - 5,168,939 4,542,014 Urban redevelopment and housing 1,398,736 1,249,457 - - 1,398,736 1,249,457 Culture and recreation 2,231,605 2,068,887 - - 2,231,605 2,068,887 Interest on long-term debt 952,756 688,155 - - 952,756 688,155 Water - - 1,878,807 1,699,540 1,878,807 1,699,540 Sewer - - 2,251,291 2,061,180 2,251,291 2,061,180 Storm sewer - - 397,660 394,707 397,660 394,707 Refuse - - 867,823 848,685 867,823 848,685 Pavilion/ice arena - - 483,035 462,771 483,035 462,771 Housing and redevelopment authority - - 616,653 610,318 616,653 610,318 Total expenses 28,840,279 22,056,726 6,495,269 6,077,201 35,335,548 28,133,927 Increase in net position before transfers (6,990,199) (931,298) 830,830 338,107 (6,159,369) (593,191) Transfers (2,089,914) (864,187) 2,089,914 864,187 - - Increase in net position (9,080,113) (1,795,485) 2,920,744 1,202,294 (6,159,369) (593,191) Net position - January 1, 43,178,117 44,973,602 19,312,874 18,110,580 62,490,991 63,084,182 Net position - December 31 34,098,004 43,178,117 22,233,618 19,312,874 56,331,622 62,490,991 20 Governmental activities: Property taxes increased in 2016 due to tax growth and a reduction in tax appeals. The City also received a number of program grants for specific programs in addition to state municipal aid for a major street improvement project. Net position decreased primarily due to payment of refunding debt that was sold the previous year and called in February 2016. 21 Business-type activities. Business-type activities had a increase in net position due to transfers and greater than expected revenues. A utility master plan was developed in 2007 with scheduled rate increases that are designed to cover operations, debt and capital needs over the next 15 years. In 2016 as a result of increased capital need for the utility funds a rate study was undertaken and implemented in 2017 that will further improve the financial health of the utility funds. 22 Financial Analysis of the City’s Funds As noted earlier, the City of Hopkins uses fund accounting to ensure and demonstrate compliance with finance-related legal requirements. Governmental funds. The focus of the City of Hopkins governmental funds is to provide information on near-term inflows, outflows, and balances of spendable resources. Such information is useful in assessing the City of Hopkins financing requirements. In particular, unassigned fund balance may serve as a useful measure of a City’s net resources available for spending at the end of the fiscal year. As of the end of the current fiscal year, the City of Hopkins governmental funds reported combined ending fund balances of $23,317,818, decrease of $(3,580,892) in comparison with the prior year. The key factor of the decrease was the refunding payment for the 2007 HRA Revenue Bonds in February 2016. Approximately 13% of fund balance or $2,988,724, constitutes assigned and unassigned fund balance, which is available for spending at the City’s discretion. The remainder of fund balance is non- spendable, restricted or committed to indicate that it is not available for new spending because it is either in a non-spendable form (inventory, prepaid expenses, rehabilitative loans, or property held for resale); restricted (debt service, tax increment projects) or has already been committed (for economic development, property purchases, parking, and communication activities). The general fund is the chief operating fund of the City of Hopkins. At the end of the current fiscal year, unassigned fund balance of the general fund was $5,533,137. This represents 94.3% of the general fund’s total fund balance. As a measure of the general fund’s liquidity, it may be useful to compare both unassigned fund balance and total fund balance to total fund expenditures. Unassigned fund balance represents approximately 45.0% of total general fund expenditures while total fund balance represents approximately 47.7% of that same amount. The fund balance of the City of Hopkins general fund decreased by $(141,206) during the current fiscal year. Revenues exceeded expenditures by $9,794 before transfers. This decrease was primarily the result of the general funds contribution of $125,000 towards the public works garage upgrade. The Economic Development fund has a total fund balance of $4,356,160 of which $4,356,160 is committed for economic development. The fund balance decreased by $(29,822) primarily as a result of the city's participation in the facade grant program to improve business store fronts on Mainstreet in Hopkins and the write-off of the loan from the Arts Center. The Arts Center fund has a deficit fund balance of $(997,040) all of which is unassigned. The fund balance deficit decreased by $185,916 as a result of a $300,000 loan write-off from the Economic Development fund. While the Arts Center received a programming grant from the Minnesota State Arts Board to offset programming costs those costs still exceeded budgeted revenues due to higher performing artist fees and expenses . Staff and the Friends of the Hopkins Center for the Arts, a non- profit associated with the Arts Center, continue working to identify significant donors and corporate sponsors to underwrite arts programming and decrease the deficit. The Tax Increment District Super Valu fund has a total fund balance of $5,017,489 of which all is restricted for tax increment. The fund balance increased by $1,505,759 due to revenues exceeding amounts owed to developers for project costs and related financing. 23 The 2015D GO TI Refunding bond fund has a total fund balance of $148,753 all of which is restricted for the payment of debt service. The fund balance decreased by $(7,305,803) as the 2007 HRA Revenue bonds were called in February 2016. The 2016D GO TI Refunding bond fund has a total fund balance of $3,678,531 all of which is restricted for the payment of debt service. The fund balance increased by $3,678,531 as refunding bonds were sold in November 2016 to call the 2009 HRA Revenue bonds in February 2017. The Permanent Improvement Revolving fund has a total fund balance of $(639,073) which is unassigned. The fund balance decreased by $(1,081,486) as a result of project costs expended from prior year revenues and project expenses for the 2017 street project. Revenues in this fund are derived from special assessments and taxes. Bonds are being sold in June of 2017 for the 2017 street project. Proprietary funds. The City of Hopkins proprietary funds provide the same type of information found in the government-wide financial statements, but in more detail. Unrestricted net position of the Water fund at the end of the year amounted to $(1,401,511). The increase in net position amounted to $1,235,271 and is due to project costs that are being funded by the 2016 bond issue. The City completed a utility rate study which evaluated the entire rate structure of the water fund. The City is implemented a tiered rate structure in February 2017 that will meet state requirements for conservation pricing and meet the City's needs for operations and capital expenditures. The new rates went into effect February 2017. Unrestricted net position of the Sewer fund at the end of the year amounted to $(92,584). The unrestricted net position will be used to pay for infrastructure improvements. The increase in net position amounted to $494,824 and is due to operating revenues exceeding operating expenses along with transfers in from the permanent improvement fund for reimbursement of project costs.. Along with the water fund a utility rate study is was done for the sewer fund. A rate structure was put in place in February 2017 to ensure adequate funds are maintained for operations and capital needs in the long- term. Unrestricted net position of the Storm Sewer Utility fund at the end of the year amounted to $935,103. The unrestricted net position will be used to pay for infrastructure improvements. The increase in net position amounted to $684,473 and is due to transfers in from the permanent improvement fund for reimbursement of project costs. General Fund Budgetary Highlights The difference between the general fund original budget and the final amended budget resulted in departmental budget changes but did not increase the total expenditure budget when transfers out are included. The reason for the inter-departmental amendments was a transfer between expenditure categories to match actual expenditures and a transfer from the contingency fund for technology expenditures. The budget changes can be summarized as follows:  Several departments had small budget modifications, however when departments were combined for reporting purposes the budget changes balanced out and no change was noted. During the year revenues were over budgetary estimates by $433,833 due to increases in license and permit revenue, fines, federal grants, recreation fees and donations. This was offset by a decrease in tax 24 revenues as a result of rebates due taxpayers who challenged their valuations in tax court and less than expected miscellaneous revenues. Expenditures were over budget by $(450,039) and was due to increased costs in the administration, public safety and public works departments primarily due to increased personnel costs. In addition a decision was made to use $125,000 of fund balance for the public works garage expansion project. The net effect of these budget impacts was an decrease in fund balance of $(141,206) after transfers. Capital Asset and Debt Administration Capital assets. The City of Hopkins investment in capital assets for its governmental and business type activities as of December 31, 2016, amounts to $89,026,668 (net of accumulated depreciation). This investment in capital assets includes land, buildings, improvements, vehicles, machinery and equipment, park facilities, roads, highways, bridges, distribution systems and construction in progress. Major capital asset events during the current fiscal year included the following:  Construction in progress additions totaled $8,335,377 for infrastructure projects and enhancements to a undeveloped city park.  A total of $3,074,049 of assets was transferred from construction in progress to other improvements as infrastructure projects were completed and put into service.  Vehicle and equipment purchases totaled $964,480. Major purchases included public works equipment, public safety vehicles and equipment.  Vehicle and equipment deletions totaled $514,543. Deletions were a result of scheduled replacements of public works, public safety vehicles and equipment. City of Hopkins Capital Assets (net of depreciation) December 31 Governmental Activities Business-Type Activities Total 2016 2015 2016 2015 2016 2015 Land $ 6,157,677 $ 6,157,677 $ 254,299 $ 254,299 $ 6,411,976 $ 6,411,976 Buildings 13,495,109 13,588,144 3,156,013 3,284,952 16,651,122 16,873,096 Infrastructure - - 7,620,776 6,930,852 7,620,776 6,930,852 Improvements 28,211,850 24,710,194 9,741,259 10,005,964 37,953,109 34,716,158 Vehicles 2,016,256 1,840,710 524,333 467,459 2,540,589 2,308,169 Equipment 2,407,407 2,430,725 312,862 308,583 2,720,269 2,739,308 Construction in progress 10,517,925 8,418,116 4,610,902 1,449,379 15,128,827 9,867,495 $ 62,806,224 $ 57,145,566 $ 26,220,444 $ 22,701,488 $ 89,026,668 $ 79,847,054 Additional information on the City of Hopkins capital assets can be found in note 5 on pages 57-58 of this report. Long-term debt. At the end of the current fiscal year, the City of Hopkins had total bonded debt outstanding of $52,865000. Of this amount $15,950,000 comprises tax increment redevelopment debt, and $31,125,000 comprises general obligation and special assessment debt, all of which is backed by the full faith and credit of the government. Another $1,425,000 is special fees debt for which the government is liable in the event of default by the property owners subject to the fees. The remainder of the City of Hopkins debt, $4,365,000, represents bonds secured solely by specified revenue sources (i.e., revenue bonds). 25 City of Hopkins Outstanding Debt General Obligation and Revenue Bonds December 31 Governmental Activities Business-Type Activities Total 2016 2015 2016 2014 2016 2015 G.O. Tax increment bonds $ 15,950,000 $ 13,105,000 $ - $ - $ 15,950,000 $ 13,105,000 G.O. Housing fee bonds 1,425,000 2,100,000 - - 1,425,000 2,100,000 G.O. Equipment certificates 505,000 585,000 - - 505,000 585,000 G.O. Capital improvement bonds 18,220,000 14,815,000 - - 18,220,000 14,815,000 G.O. Special assessment bonds 12,400,000 8,660,000 - - 12,400,000 8,660,000 Revenue bonds - - 4,365,000 4,745,000 4,365,000 4,745,000 $ 48,500,000 $ 39,265,000 $ 4,365,000 $ 4,745,000 $ 52,865,000 $ 44,010,000 The City of Hopkins total bonded debt increased by $8,855,000 during the current fiscal year. The increase is a result of the issuance of $4,335,000 in GO. Improvement Bonds that financed street improvements, the issuance of $1,630,000 on GO Tax Abatement Bonds for various park and parking ramp improvements, the issuance of $2,805,000 in GO Bonds for equipment purchases and utility projects and the issuance of $3,540,000 in GO TI refunding bonds to refund the 2009 HRA Revenue Bonds that will be called February 1, 2017. General Obligation Bonds are backed by the full faith, credit and taxing power of the City, and are serviced by General and Tax Increment levies and also by fees assessed against benefited properties. Revenue Bonds are backed by the full faith, credit and taxing power of the City, and are serviced by the Water, Sewer, and Storm Sewer Utility Funds and the Pavilion Fund current revenues. City Special Assessment Bonds are backed by the full faith, credit and taxing power of the City, and repayment monies are generated by the collection of special assessments and general levies. The City is subject to a statutory limit of bonded indebtedness equaling 3.0 percent of taxable market value. At December 31, 2016, the debt limit for the City is $51,633,159. Of the total debt, $23,522,000 of general obligation and revenue bonds is applicable to the limit. After taking into consideration funds on hand available to liquidate debt, the legal debt margin is $29,871,758. The City of Hopkins was upgraded to a “AA+” rating from Standard & Poor’s in January 2014 which was reaffirmed in November 2015 and again in June and October 2016 and maintains an “A1” rating from Moody’s. Additional information on the City of Hopkins long-term debt can be found in note 9 on pages 60-63 of this report. Economic Factors and Next Year’s Budgets and Rates A number of factors were taken into consideration when preparing the City of Hopkins 2017 budget. A utility rate study was completed for the water and sewer funds to better position those funds for the future. New rates for these funds were implemented in February 2017. The tax capacity rate increased as a result of economic conditions. Property values are starting to increase and this was taken into consideration when determining estimated tax revenues. Also taken into consideration is that the City’s population would remain constant. As a result of these factors the City prepared a budget for 2017 that included an overall increase of 8.08% in expenditures. The 2017 budget includes provisions for two 26 new police officers, two new public works employees, a comp & class rate study and an update to the City's comprehensive plan. During the current fiscal year, unassigned fund balance in the general fund was $5,533,137 or 45% of general fund expenditures. The Office of the State Auditor recommends unassigned fund balances no less than five months of operating expenditures. The City is meeting the recommendation for the general fund. The unassigned fund balance is used to pay for the City’s general fund obligations until it receives its property tax levy revenues in June. Requests for Information This financial report is designed to provide a general overview of the City of Hopkins 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 Director of Finance, City of Hopkins, 1010 First Street South, Hopkins, MN 55343. 27 BASIC FINANCIAL STATEMENTS 28 City of Hopkins Statement of Net Position December 31, 2016 Primary Government Governmental Activities Business-Type Activities Total Assets Cash and cash equivalents $ 26,110,305 $ 2,817,910 $ 28,928,215 Taxes receivable 178,436 832 179,268 Special assessments receivable 3,013,945 -3,013,945 Accounts receivable 360,189 373,613 733,802 Intergovernmental receivable 193,903 89,119 283,022 Interest receivable 47,073 3,612 50,685 Internal balances 848,361 (848,361)- Inventories 87,263 55,303 142,566 Net pension asset 451,603 -451,603 Land held for resale 1,018,817 -1,018,817 Capital assets, non depreciable 16,675,602 4,865,197 21,540,799 Capital assets, net of depreciation 46,130,622 21,355,247 67,485,869 Total Assets 95,116,119 28,712,472 123,828,591 Deferred Outflows of Resources Deferred charge on refunding 268,705 -268,705 Pensions 10,987,857 585,768 11,573,625 Total Deferred Outflows of Resources 11,256,562 585,768 11,842,330 Liabilities Accounts payable 2,406,143 954,249 3,360,392 Salaries payable 192,693 20,912 213,605 Due to other governments 57,881 25,989 83,870 Accrued interest payable 367,309 47,228 414,537 Unearned revenue 215,728 546 216,274 Non current liabilities: Compensated absences due within one year 778,155 82,487 860,642 Compensated absences due in more than one year -15,610 15,610 Net OPEB liability 95,269 25,354 120,623 Net pension liability 16,665,753 1,334,681 18,000,434 Capital lease due within one year 24,616 -24,616 Capital lease due in more than one year 77,512 -77,512 Bonds due within one year 3,080,000 385,000 3,465,000 Bonds due in more than one year 46,466,974 4,037,261 50,504,235 Total Liabilities 70,428,033 6,929,317 77,357,350 Deferred Inflows of Resources Pensions 1,846,644 135,305 1,981,949 Total Deferred Inflows of Resources 1,846,644 135,305 1,981,949 Net Position Net investment in capital assets 33,833,387 21,798,183 55,631,570 Restricted for: Economic development 5,640,502 -5,640,502 Park improvements 760,900 -760,900 Debt service 11,342,561 - 11,342,561 Net pension asset 829,210 -829,210 Unrestricted (18,308,556)435,435 (17,873,121) Total Net Position $34,098,004 $22,233,618 $56,331,622 The notes to the financial statements are an integral part of this statement. 29 City of Hopkins Statement of Activities For the Year Ended December 31, 2016 Program Revenues Net Revenues (Expenses) and Changes in Net Position Functions/Programs Expenses Charges for Services Operating Grants and Contributions Capital Grants and Contributions Governmental Activities Business-type Activities Total Governmental Activities: General government $ 10,341,183 $72,716 $485,469 $387,544 $ (9,395,454) $- $ (9,395,454) Public safety 8,561,759 274,661 1,195,018 - (7,092,080)- (7,092,080) Health and welfare 185,301 58,264 111,283 -(15,754)-(15,754) Highways and streets 5,168,939 125,749 1,558,725 721,734 (2,762,731)- (2,762,731) Urban redevelopment and housing 1,398,736 190,199 163,675 - (1,044,862)- (1,044,862) Culture and recreation 2,231,605 770,466 573,753 -(887,386)-(887,386) Interest on long-term debt 952,756 ---(952,756)-(952,756) Total Governmental Activities 28,840,279 1,492,055 4,087,923 1,109,278 (22,151,023)-(22,151,023) Business-Type Activities: Water 1,878,807 1,526,290 150 --(352,367)(352,367) Sewer 2,251,291 2,215,251 92,340 --56,300 56,300 Storm sewer 397,660 810,142 66,842 --479,324 479,324 Refuse 867,823 959,258 44,303 --135,738 135,738 Pavilion/Ice arena 483,035 22,275 333,165 --(127,595)(127,595) Housing and redevelopment authority 616,653 282,125 184,877 702,555 -552,904 552,904 Total Business-type Activities 6,495,269 5,815,341 721,677 702,555 -744,304 744,304 Total Government $35,335,548 $7,307,396 $4,809,600 $1,811,833 (22,151,023)744,304 (21,406,719) General revenues: Property taxes 11,994,436 63,519 12,057,955 Tax increments 2,959,459 -2,959,459 Grants & contributions not restricted 20,510 -20,510 Unrestricted investment earnings 124,406 13,231 137,637 Gain on disposal of capital assets 62,013 9,776 71,789 Transfers (2,089,914)2,089,914 - Total General Revenues 13,070,910 2,176,440 15,247,350 Change in net position (9,080,113)2,920,744 (6,159,369) Net position - January 1 43,178,117 19,312,874 62,490,991 Net position - December 31 $ 34,098,004 $ 22,233,618 $ 56,331,622 The notes to the financial statements are an integral part of this statement. 30 City of Hopkins Balance Sheet Governmental Funds December 31, 2016 General Fund Economic Development Arts Center Tax Increment District Super Valu GO TI Revenue Bonds of 2015D Assets Cash and cash equivalents $ 3,508,636 $ 3,151,669 $- $ 4,687,862 $ 148,504 Taxes receivable 142,495 4,243 1,679 -- Special assessments receivable ----- Accounts receivable 119,802 -44,756 -- Rehabilitation loans receivable ----- Due from other governments 35,389 ---- Interest receivable 9,950 5,233 -7,908 249 Due from other funds 2,569,757 510,526 --- Inventories 87,263 ---- Property held for resale -697,098 -321,719 - Total Assets $6,473,292 $4,368,769 $46,435 $5,017,489 $148,753 Liabilities, Deferred Inflows of Resources and Fund Balances Liabilities: Accounts payable $ 170,413 $ 6,221 $ 24,344 $- $- Salaries payable 176,276 3,182 5,900 -- Due to other funds --1,011,663 -- Due to other governments 1,459 -127 -- Unearned revenue 147,707 -378 -- Total Liabilities 495,855 9,403 1,042,412 -- Deferred inflows of resources: Taxes and special assessments 111,543 3,206 1,063 -- Total Deferred Inflows of Resources 111,543 3,206 1,063 -- Fund balances: Non-spendable 87,263 ---- Restricted ---5,017,489 148,753 Committed -4,356,160 --- Assigned 340,857 ---- Unassigned 5,437,774 -(997,040)-- Total Fund Balances (Deficits)5,865,894 4,356,160 (997,040)5,017,489 148,753 Total Liabilities, Deferred Inflows of Resources and Fund Balances $6,473,292 $4,368,769 $46,435 $5,017,489 $148,753 The notes to the financial statments are an integral part of this statement. 31 City of Hopkins Balance Sheet Governmental Funds December 31, 2016 GO TI Revenue Bonds of 2016D Permanent Improvement Revolving Nonmajor Governmental Funds Total Governmental Funds Assets Cash and cash equivalents $ 3,672,371 $ 999,442 $ 7,509,743 $ 23,678,227 Taxes receivable -43 29,976 178,436 Special assessments receivable -120,246 2,893,699 3,013,945 Accounts receivable -9,280 150,268 324,106 Rehabilitation loans receivable --36,083 36,083 Due from other governments -119,974 38,540 193,903 Interest receivable 6,160 1,406 12,176 43,082 Due from other funds ---3,080,283 Inventories ---87,263 Property held for resale ---1,018,817 Total Assets $3,678,531 $1,250,391 $10,670,485 $31,654,145 Liabilities, Deferred Inflows of Resources and Fund Balances Liabilities: Accounts payable $- $ 1,664,358 $ 526,740 $ 2,392,076 Salaries payable --7,335 192,693 Due to other funds --1,220,259 2,231,922 Due to other governments --56,295 57,881 Unearned revenue --67,643 215,728 Total Liabilities -1,664,358 1,878,272 5,090,300 Deferred inflows of resources: Taxes and special assessments -225,106 2,905,109 3,246,027 Total Deferred Inflows of Resources -225,106 2,905,109 3,246,027 Fund balances: Non-spendable ---87,263 Restricted 3,678,531 -6,362,963 15,207,736 Committed --677,935 5,034,095 Assigned ---340,857 Unassigned -(639,073) (1,153,794) 2,647,867 Total Fund Balances (Deficits)3,678,531 (639,073)5,887,104 23,317,818 Total Liabilities, Deferred Inflows of Resources and Fund Balances $3,678,531 $1,250,391 $10,670,485 $31,654,145 The notes to the financial statments are an integral part of this statement. 32 City of Hopkins Reconciliation of the Balance Sheet of Governmental Funds To the Statement of Net Position December 31, 2016 Fund balances of governmental funds $ 23,317,818 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, not reported in the governmental funds. Capital assets 86,034,287 Less accumulated depreciation (27,005,160) Other long-term assets not available to pay current period expenditures and, therefore, are deferred in the governmental funds. 3,246,027 Internal service funds are used by the City to charge the costs of certain activities, such as replacement of City vehicles and equipment. The assets and liabilities of the internal service funds are included in the governmental activities in the statement of net position. 5,317,882 Long-term liabilities, including bonds payable and accrued interest payable, are not due and payable in the current period and, therefore, are not reported in the governmental funds. Long-term liabilities (50,008,618) Less deferred charges 268,705 Net pension liability and related deferred inflows of resources (18,512,397) Long-term receivables are not due and payable in the current period and therefore, are not reported in the governmental funds Net pension asset and related deferred outflows of resources 11,439,460 Net position of governmental activities $ 34,098,004 33 City of Hopkins Statement of Revenues, Expenditures and Changes in Fund Balances Governmental Funds For the Year Ended December 31, 2016 General Fund Economic Development Arts Center Tax Increment District Super Valu GO TI Revenue Bonds of 2015D Revenues Property taxes $ 9,559,348 $ 482,379 $ 137,501 $- $- Tax increments --- 2,751,506 - Special assessments ----- Intergovernmental 1,076,205 50,000 34,968 -- Fees, licenses and permits 686,785 ---- Charges for services 419,671 -379,546 -- Fines 201,255 ---- Investment earnings 25,436 36,630 -23,295 427 Other miscellaneous revenues 340,863 109,432 490,511 -- Total Revenues 12,309,563 678,441 1,042,526 2,774,801 427 Expenditures Current: General government 2,227,096 ---- Public safety 6,534,667 ---- Health and welfare 181,666 ---- Highways and streets 2,655,487 ---- Urban redevelopment and housing 89,999 708,263 -450,934 - Culture and recreation 610,854 -943,530 -- Debt service: Principal retirement ----270,000 Interest and fiscal fees ----101,570 Capital Outlay ----- Total Expenditures 12,299,769 708,263 943,530 450,934 371,570 Excess (deficiency) of revenues over expenditures 9,794 (29,822)98,996 2,323,867 (371,143) Other Financing Sources (Uses) Improvement bonds issued ----- Premium on improvement bonds ----- Payment to bond escrow agent ---- (7,305,660) Transfer in --86,920 -371,000 Transfer out (151,000)--(818,108)- Total Other Financing Sources (Uses)(151,000)-86,920 (818,108)(6,934,660) Net change in fund balances (141,206)(29,822)185,916 1,505,759 (7,305,803) Fund balance (deficit) - January 1 6,007,100 4,385,982 (1,182,956) 3,511,730 7,454,556 Fund balance (deficit) - December 31 $5,865,894 $4,356,160 $(997,040)$5,017,489 $148,753 The notes to the financial statements are an integral part of this statement. 34 City of Hopkins Statement of Revenues, Expenditures and Changes in Fund Balances Governmental Funds For the Year Ended December 31, 2016 GO TI Revenue Bonds of 2016D Permanent Improvement Revolving Non-major Governmental Funds Total Governmental Funds Revenues Property taxes $- $ 2,124 $ 2,000,343 $ 12,181,695 Tax increments --207,953 2,959,459 Special assessments -277,807 1,126,451 1,404,258 Intergovernmental -443,927 1,093,272 2,698,372 Fees, licenses and permits ---686,785 Charges for services --201,630 1,000,847 Fines --21,876 223,131 Investment earnings (18)6,623 23,532 115,925 Other miscellaneous revenues --930,068 1,870,874 Total Revenues (18)730,481 5,605,125 23,141,346 Expenditures Current: General government 63,129 -596,612 2,886,837 Public safety --183,379 6,718,046 Health and welfare ---181,666 Highways and streets -26,245 1,116,016 3,797,748 Urban redevelopment and housing --88,191 1,337,387 Culture and recreation --461,845 2,016,229 Debt service: Principal retirement -- 2,805,000 3,075,000 Interest and fiscal fees --753,544 855,114 Capital Outlay - 4,180,751 3,144,286 7,325,037 Total Expenditures 63,129 4,206,996 9,148,873 28,193,064 Excess (deficiency) of revenues over expenditures (63,147)(3,476,515)(3,543,748)(5,051,718) Other Financing Sources (Uses) Improvement bonds issued 3,540,000 - 8,770,000 12,310,000 Premium on improvement bonds 201,678 -251,293 452,971 Payment to bond escrow agent --- (7,305,660) Transfer in - 4,341,871 3,312,342 8,112,133 Transfer out - (1,946,842) (9,182,668) (12,098,618) Total Other Financing Sources (Uses)3,741,678 2,395,029 3,150,967 1,470,826 Net change in fund balances 3,678,531 (1,081,486)(392,781) (3,580,892) Fund balance (deficit) - January 1 -442,413 6,279,885 26,898,710 Fund balance (deficit) - December 31 $3,678,531 $(639,073)$5,887,104 $23,317,818 The notes to the financial statements are an integral part of this statement. 35 City of Hopkins Reconciliation of the Statement of Revenues, Expenditures and Changes in Fund Balances of Governmental Funds to the Statement of Activities For the Year Ended December 31, 2016 Net change in fund balances total governmental funds $ (3,580,892) Amounts reported for governmental activities in the statement of activities are different because: 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. This is the amount by which capital outlays exceeded depreciation in the current period. 5,661,988 The net effect of various miscelleneous transactions involving capital assets (i.e. sales, trade-ins, and donations) is a decrease to net assets (816) Revenues in the statement of activities that do not provide current financial resources are not reported as revenues in the funds (1,360,171) The issuance of long-term debt provides current financial resources to governmental funds, while the repayment of the principal of long-term debt uses the current financial resources of governmental funds. Neither transaction, however, has any effect on net position. Also, governmental funds report the effect of premiums, discounts, and similar items when debt is first issued, whereas these amounts are recorded in the statement of net position and amortized in the statement of activities. This amount is the net effect of these differences in the treatment of long-term debt related items. (9,664,389) Some pension expenses reported in the Statement of Activities do not require the use of current financial resources and, therefore are not reported as expenditures Change in net pension asset/liability and related deferred outflows/inflows of resources (1,754,729) External revenues and expenditures of the internal service funds reported in the statement of activities are not reported as revenues and expenditures in governmental funds. 1,618,896 Change in net position of governmental activities $ (9,080,113) 36 City of Hopkins Statement of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual General Fund For the Year Ended December 31, 2016 Original Budget Final Approved Budget Actual Variance with Final Budget Over/Under Revenues Property taxes $ 9,797,151 $ 9,797,151 $ 9,559,348 $ (237,803) Intergovernmental 891,954 891,954 1,076,205 184,251 Fees, licenses and permits 390,975 390,975 686,785 295,810 Charges for services 188,900 188,900 419,671 230,771 Fines 184,600 184,600 201,255 16,655 Investment earnings 20,000 20,000 25,436 5,436 Other miscellaneous revenues 402,150 402,150 340,863 (61,287) Total Revenues 11,875,730 11,875,730 12,309,563 433,833 Expenditures General government 1,988,626 1,977,626 2,227,096 (249,470) Public safety 6,350,991 6,350,991 6,534,667 (183,676) Health and welfare 185,723 185,723 181,666 4,057 Highways and streets 2,543,321 2,543,321 2,655,487 (112,166) Urban redevelopment and housing 121,875 121,875 89,999 31,876 Culture and recreation 632,894 632,894 610,854 22,040 Capital Outlay 37,300 37,300 -37,300 Total Expenditures 11,860,730 11,849,730 12,299,769 (450,039) Excess (deficiency) of revenues over expenditures 15,000 26,000 9,794 (16,206) Other Financing Sources (Uses): Transfer out (15,000)(26,000) (151,000) (125,000) Net change in fund blance $-$-(141,206)$(141,206) Fund balance - January 1 6,007,100 Fund balance - December 31 $ 5,865,894 The notes to the financial statements are an integral part of this statement. 37 City of Hopkins Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual Major Special Revenue Funds Economic Development Year Ended December 31, 2016 Original Budget Final Approved Budget Actual Variance with Final Budget Over/Under Revenues Property taxes $ 296,813 $ 296,813 $ 482,379 $ 185,566 Intergovernmental --50,000 50,000 Investment earnings 15,000 15,000 36,630 21,630 Other miscellaneous revenues 40,300 40,300 109,432 69,132 Total Revenues 352,113 352,113 678,441 326,328 Expenditures Current: Urban redevelopment and housing 176,600 176,600 708,263 (531,663) Total Expenditures 176,600 176,600 708,263 (531,663) Net change in fund balance $175,513 $175,513 (29,822)$(205,335) Fund balance - January 1, reported 4,385,982 Fund balance - December 31 $ 4,356,160 The notes to the financial statements are an integral part of this statement. 38 City of Hopkins Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual Major Special Revenue Funds Arts Center Year Ended December 31, 2016 Original Budget Final Approved Budget Actual Variance with Final Budget Over/Under Revenues Property taxes $ 140,000 $ 140,000 $ 137,501 $ (2,499) Intergovernmental 35,967 35,967 34,968 (999) Charges for services 393,721 393,721 379,546 (14,175) Other miscellaneous revenues 130,500 130,500 490,511 360,011 Total Revenues 700,188 700,188 1,042,526 342,338 Expenditures Current: Culture and recreation 796,867 839,914 943,530 (103,616) Capital Outlay 106,800 106,800 -106,800 Total Expenditures 903,667 946,714 943,530 3,184 Other Financing Sources (Uses) Transfer in 86,920 86,920 86,920 - Net change in fund balance $(116,559)$(159,606)185,916 $345,522 Fund balance - January 1, reported (1,182,956) Fund balance - December 31 $ (997,040) The notes to the financial statements are an integral part of this statement. 39 City of Hopkins Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual Major Special Revenue Funds Tax Increment District Super Valu Year Ended December 31, 2016 Original Budget Final Approved Budget Actual Variance with Final Budget Over/Under Revenues Tax increments $ 2,400,000 $ 2,400,000 $ 2,751,506 $ 351,506 Investment earnings --23,295 23,295 Total Revenues 2,400,000 2,400,000 2,774,801 374,801 Expenditures Urban redevelopment and housing 1,393,940 1,393,940 450,934 943,006 Total Expenditures 1,393,940 1,393,940 450,934 943,006 Other Financing Sources (Uses) Transfer out (211,318) (211,318) (818,108) (606,790) Net change in fund balance $794,742 $794,742 1,505,759 $711,017 Fund balance - January 1, reported 3,511,730 Fund balance - December 31 $ 5,017,489 The notes to the financial statements are an integral part of this statement. 40 City of Hopkins Statement of Net Position Proprietary Funds December 31, 2016 Business-Type Activities-Enterprise Funds Water Utility Sewer Utility Storm Sewer Utility Nonmajor Proprietary Funds Totals Governmental Activities Internal Service Funds Assets Current assets: Cash and cash equivalents $- $2,719 $ 966,652 $ 1,848,539 $ 2,817,910 $ 2,432,078 Taxes receivable ---832 832 - Accounts receivable 98,826 207,777 10,773 56,237 373,613 - Accrued interest receivable -157 1,809 1,646 3,612 3,991 Due from other governments ---89,119 89,119 - Inventory 31,567 23,693 43 -55,303 - Total current assets 130,393 234,346 979,277 1,996,373 3,340,389 2,436,069 Noncurrent assets: Capital Assets, non depreciable: Land 14,097 5,150 26,800 208,252 254,299 - Construction in progress 1,625,115 963,696 1,397,685 624,402 4,610,898 - Capital Assets, depreciable Building and structures 33,089 --8,209,480 8,242,569 - Distribution system 12,821,007 8,362,098 10,983,348 125,614 32,292,067 - Machinery and equipment 363,312 435,428 9,000 1,214,388 2,022,128 8,519,906 Less accumulated depreciation (6,553,603)(4,576,011)(4,241,161)(5,830,742)(21,201,517)(4,742,809) Total noncurrent assets 8,303,017 5,190,361 8,175,672 4,551,394 26,220,444 3,777,097 Total Assets 8,433,410 5,424,707 9,154,949 6,547,767 29,560,833 6,213,166 Deferred outflows of resources: Pensions 214,215 104,993 20,475 246,085 585,768 - Total Deferred Outflows 214,215 104,993 20,475 246,085 585,768 - Liabilities Current liabilities: Accounts payable 756,021 123,982 2,091 72,155 954,249 14,067 Salaries payable 7,826 3,245 651 9,190 20,912 - Due to other funds 399,423 --448,938 848,361 - Due to other governments 1,489 9,644 -14,856 25,989 - Compensated absences 18,045 10,545 -53,897 82,487 778,155 Unearned revenue ---546 546 - Accrued interest payable 20,210 15,494 10,526 998 47,228 934 Capital lease - current -----24,616 Revenue bonds - current 145,000 105,000 115,000 20,000 385,000 - Total current liabities 1,348,014 267,910 128,268 620,580 2,364,772 817,772 41 City of Hopkins Statement of Net Position Proprietary Funds December 31, 2016 Business-Type Activities-Enterprise Funds Water Utility Sewer Utility Storm Sewer Utility Nonmajor Proprietary Funds Totals Governmental Activities Internal Service Funds Noncurrent liabilities: Compensated absences $- $- $- $15,610 $15,610 $- Net OPEB liability 5,532 5,532 -14,290 25,354 - Net pension liability 488,092 239,229 46,652 560,708 1,334,681 - Capital lease payable -----77,512 Revenue bonds payable (net of unamortized discounts and premium)1,778,986 1,136,047 1,020,700 101,528 4,037,261 - Toal noncurrent liabilities 2,272,610 1,380,808 1,067,352 692,136 5,412,906 77,512 Total Liabilities 3,620,624 1,648,718 1,195,620 1,312,716 7,777,678 895,284 Deferred inflows of resources: Pensions 49,481 24,252 4,729 56,843 135,305 - Total Deferred Inflows of Resources 49,481 24,252 4,729 56,843 135,305 - Net Position Net investment in capital assets 6,379,031 3,949,314 7,039,972 4,429,866 21,798,183 3,674,969 Unrestricted (1,401,511)(92,584)935,103 994,427 435,435 1,642,913 Total Net Position $4,977,520 $3,856,730 $7,975,075 $5,424,293 $22,233,618 $5,317,882 The notes to the financial statements are an integral part of this statement. 42 City of Hopkins Statement of Revenues, Expenses and Changes in Net Position Proprietary Funds For the Year Ended December 31, 2016 Business-Type Activities-Enterprise Funds Water Utility Sewer Utility Storm Sewer Utility Nonmajor Proprietary Funds Total Governmental Activities Internal Service Funds Operating revenues Charges for services $ 1,517,508 $ 2,200,230 $ 870,620 $ 1,578,586 $ 6,166,944 $ 512,541 Other 8,932 15,171 6,364 35,470 65,937 - Total operating revenues 1,526,440 2,215,401 876,984 1,614,056 6,232,881 512,541 Operating expenses Cost of sales and services 1,381,716 1,868,834 77,617 1,163,246 4,491,413 282,576 Administration 190,804 154,792 52,575 467,634 865,805 7,983 Depreciation 258,864 191,446 241,731 334,474 1,026,515 560,870 Total operating expenses 1,831,384 2,215,072 371,923 1,965,354 6,383,733 851,429 Operating income (loss)(304,944)329 505,061 (351,298)(150,852)(338,888) Nonoperating revenues (expenses) Property taxes ---63,519 63,519 - Investment earnings -788 5,833 6,610 13,231 8,483 Interest/fiscal agent expense (47,423)(36,219)(25,737)(2,157)(111,536)(7,694) Intergovernmental grants -92,190 -211,947 304,137 - Gain on sale of assets -9,776 --9,776 60,424 Total nonoperating revenues (expenses)(47,423)66,535 (19,904)279,919 279,127 61,213 Income (loss) before contributions and transfers (352,367)66,864 485,157 (71,379)128,275 (277,675) Transfers and contributions Capital contributions ---702,555 702,555 - Transfers in 1,777,264 609,556 420,190 -2,807,010 1,896,571 Transfers out (189,626)(181,596)(220,874)(125,000)(717,096)- Change in net position 1,235,271 494,824 684,473 506,176 2,920,744 1,618,896 Net position - January 1 3,742,249 3,361,906 7,290,602 4,918,117 19,312,874 3,698,986 Net position - December 31 $4,977,520 $3,856,730 $7,975,075 $5,424,293 $22,233,618 $5,317,882 The notes to the financial statements are an integral part of this statement. 43 City of Hopkins Statement of Cash Flows Proprietary Funds For the Year Ended December 31, 2016 Business-type Activities-Enterprise Funds Governmental Nonmajor Activities Water Sewer Storm Sewer Proprietary Internal Utility Utility Utility Funds Totals Service Funds Cash Flows from Operating Activities Receipts from customers and users $ 1,539,674 2,199,115 $ 876,235 $ 1,565,453 $ 6,180,477 $ 104,082 Receipts from interfund services provided - - - 409,530 409,530 408,459 Internal activity-payments to other funds 226,458 - - - 226,458 - Payments to suppliers (206,735) (1,539,576) (39,771) (841,657) (2,627,739) (788,606) Payments to employees (454,207) (230,357) (44,272) (603,384) (1,332,220) - Payments for interfund services used (190,804) (154,792) (52,575) (113,770) (511,941) (36,327) Net cash provided by (used in) by operating activities 914,386 274,390 739,617 416,172 2,344,565 (312,392) Cash Flows from Noncapital Financing Activities Intergovernmental grants - 92,190 - 914,502 1,006,692 - Taxes - - - 63,519 63,519 - Transfers in (out) 1,587,638 427,960 199,316 (125,000) 2,089,914 1,896,571 Net cash provided by (used in) noncapital financing activities 1,587,638 520,150 199,316 853,021 3,160,125 1,896,571 Cash Flows from Capital and Related Financing Activities: Purchases of capital assets - - - - - (560,354) Construction of capital assets (2,306,805) (917,838) (1,072,042) (719,560) (5,016,245) - Proceeds from sales of capital assets - - - - - 60,424 Interest and other payments (52,172) (38,955) (26,649) (2,624) (120,400) (8,129) Capital lease payments - - - - - (47,488) Bond payments (145,000) (105,000) (110,000) (20,000) (380,000) - Net cash provided by (used in) capital and related financing activities (2,503,977) (1,061,793) (1,208,691) (742,184) (5,516,645) (555,547) Cash Flows From Investing Activities Interest received 4,508 2,669 7,542 9,424 24,143 12,339 Net increase (decrease) in cash and cash equivalents 2,555 (264,584) (262,216) 536,433 12,188 1,040,971 Cash and cash equivalents - January 1 (2,555) 264,592 265,316 315,745 843,098 (1,033,170) Cash and cash equivalents - December 31 $ - $ 8 $ 3,100 $ 852,178 $ 855,286 $ 7,801 44 City of Hopkins Statement of Cash Flows Proprietary Funds For the Year Ended December 31, 2016 Business-type Activities-Enterprise Funds Governmental Nonmajor Activities Water Sewer Storm Sewer Proprietary Internal Utility Utility Utility Funds Totals Service Funds Reconciliation of Cash and Cash Equivalents at End of Year to Cash and Investments per Statement of Net Position Ending cash and cash equivalents per cash flow statement $ - $ 8 $ 3,100 $ 852,178 $ 855,286 $ 7,801 Investments - 2,711 963,552 996,361 1,962,624 2,424,277 Cash and Investments per Statement of Net Position $ - $ 2,719 $ 966,652 $ 1,848,539 $ 2,817,910 $ 2,432,078 Reconciliation of operating income (loss) to net cash provided (used) by operating activities: Operating income (loss)$ (304,944) $ 329 $ 505,061 $ (351,298) $ (150,852) $ (338,888) Adjustments to reconcile operating income (loss) to net cash provided by (used in) operating activities: Depreciation expense 258,864 191,446 241,731 334,474 1,026,515 560,870 (Increase) decrease in: Accounts receivable 13,234 (16,286) (749) (41,957) (45,758) - Due from other funds - - - - - - Inventory (2,234) (1,780) 413 - (3,601) - Prepaid expense - - 43 15,606 15,649 - Pensions (deferred outflows) (173,136) (82,370) (15,589) (200,847) (471,942) Increase (decrease) in: Accounts, compensated absences and accrued interest payable 696,971 115,642 (2,617) 5,252 815,248 (534,374) Due to other funds 226,458 - - 409,530 635,988 - Due to other governments (3,841) (11,829) (265) 3,937 (11,998) - Unearned revenue - - - (6,646) (6,646) Net Pension 183,356 71,410 10,407 224,120 489,293 Pensions (deferred inflows) 19,658 7,828 1,182 24,001 52,669 - Net cash provided (used) by operating activities $ 914,386 $ 274,390 $ 739,617 $ 416,172 $ 2,344,565 $ (312,392) The notes to the financial statements are an integral part of this statement. 45 NOTES TO THE FINANCIAL STATEMENTS 46 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS December 31, 2016  1. SUMMARY OF SIGNIFICANT ACCOUNT POLICIES The City of Hopkins, Minnesota (the City) is a charter City, which was approved December 2, 1947. The City operates pursuant to applicable Minnesota laws and statutes. The governing body of the City is a Council – Manager form of government. The financial statements of the City have been prepared in conformity with U.S. generally accepted accounting principles as applied to governmental units by the Government Accounting Standards Board (GASB). The more significant accounting policies of the City are described below. A. REPORTING ENTITY In accordance with GASB pronouncements, the City’s financial statements include all funds and departments of the City and its component units, for which the City is considered to be financially accountable. A blended component unit, although legally separate entity is, in substance, part of the City’s operations and so data from this unit is combined with data of the primary government. The City’s blended component unit has a March 31 year- end, however when blended with the City it is shown with a December 31 year-end. Blended Component Unit Housing and Redevelopment Authority in and for the City of Hopkins (HRA) The HRA was created by the City to carry out certain redevelopment projects and low-income rental housing. The HRA's governing body is the same as the governing body of the primary government in that all members of the Hopkins City Council are also the Hopkins Housing and Redevelopment Authority Commissioners. The City of Hopkins in its capacity as the HRA Board of Directors, has operational responsibility for the HRA. Therefore there is a burden relationship between the primary government and the component unit. The housing activity is supported in part by federal subsidies. There is an extensive trust agreement between the HRA and HUD regarding the facility. The HRA is included in the City’s enterprise funds. Separate financials are not prepared. B. GOVERNMENT-WIDE AND FUND FINANCIAL STATEMENTS The government-wide financial statements (i.e., statement of net position and the statement of changes in net position) report information on all activities of the primary government and its component units. The interfund services provided and used are not eliminated in the process of consolidation. 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 properly included among program revenues are reported instead as general revenues. Separate financial statements are provided for governmental funds and proprietary funds. 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 47 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 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 have been met. Unbilled utility service receivables are recorded at year-end. Governmental funds are accounted for using the current financial resources measurement focus and the modified accrual basis of accounting. Their revenues are recognized when susceptible to accrual (i.e., when they become measurable and available). “Measurable” means the amount of the transaction can be determined and “available” means collectible within the current period or within sixty days thereafter to be used to pay liabilities of the current period. Major revenues that are susceptible to accrual include property taxes, special assessments, intergovernmental revenues, charges for services, and investment earnings. Major revenues that are not susceptible to accrual include fees and miscellaneous revenues; such revenues are recorded only as received because they are not measurable until collected. Expenditures are generally recognized under the modified accrual basis of accounting when the related fund liability is incurred, except for principal and interest on general long-term debt and compensated absences that are recognized when due and payable. The City reports the following major governmental funds: The general fund is the primary operating fund of the City. It is used to account for all financial resources except those required to be accounted for in another fund. The economic development special revenue fund accounts for development opportunities of the city. Sources of funds are derived from the administration of loans and an annual tax levy. The arts center special revenue fund accounts for the activities of the Hopkins Center for the Arts. Sources of funds are derived from leases, ticket sales, admission fees, grants and donations. The tax increment district super valu special revenue fund accounts for the activities of the Super Valu tax increment development district. Sources of funds are a tax increment levy. The 2015D general obligation tax increment revenue bonds debt service fund accounts for resources accumulated and payments made for principal and interest on long-term debt issued for the Cargill development project. The 2016D general obligation tax increment revenue bonds debt service fund accounts for resources accumulated and payments made for principal and interest on long-term debt issued for the Cargill development project. The permanent improvement revolving capital projects fund accounts for resources and accumulated payments for street improvements funded with bonds and special assessments levied on benefited property. The City reports the following major proprietary funds: The water utility fund accounts for the operations of the City-owned water distribution system. The water bonds of 2009A, 2012B and 2013A are included as part of this fund since revenues of the water fund are pledged to pay principal and interest on this bond. The sewer utility fund accounts for the operations of the City-owned sewer lift stations and disposal system. The sewer bonds of 2009A, 2012B and 2013A are included as part of this fund since revenues of the sewer fund are pledged to pay principal and interest on this bond. 48 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 The storm sewer utility fund accounts for the operations and improvements of the storm water drainage system. The storm water bond issues of 2009A, 2010B, 2012B and 2013A are included as part of this fund since revenues of the storm sewer fund are pledged to pay principal and interest on these bonds. Additionally, the City reports the following fund types: Governmental Funds Special Revenue Funds - Special revenue funds are used to account for the proceeds of specific revenue sources that are legally restricted or committed by Council to expenditures for specified purposes. Debt Service Funds - Debt service funds are used to account for the accumulation of resources for, and the payment of, general long-term debt principal, interest, and related costs. Capital Project Funds - Capital project funds are used to account for financial resources to be used for the acquisition or construction of major capital facilities and infrastructure, other than those financed by proprietary funds or special revenue funds. Proprietary Funds Enterprise Funds - Enterprise funds are used to account for operations that are financed and operated in a manner similar to private business enterprises, where the intent of the governing body is that the costs (expenses, including depreciation) of providing goods or services to the general public on a continuing basis, be financed or recovered primarily through user charges. Internal Service Funds – Internal service funds are used to account for the financing of goods and services provided by one department to other departments of the City on a cost-reimbursement basis. Internal service funds are used for equipment replacement, insurance deductions and employee benefits. As a general rule the effect of interfund activity has been eliminated from the government-wide financial statements, however interfund services provided and used are not eliminated in the process of consolidation. 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. Proprietary funds distinguish operating revenues and expenses from non-operating 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 City enterprise funds and internal service funds are charges to customers for sales and service. 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 non-operating revenues and expenses. When both restricted and unrestricted resources are available for use, it is the City’s policy to use restricted resources first, and then use unrestricted resources as they are needed. D. CASH AND INVESTMENTS Cash balances from all funds are combined and invested to the extent available in authorized investments pursuant to Minnesota Statutes (see note 4). Earnings from such investments are allocated to the respective funds on the basis of applicable cash balance participation by each fund. Investments in certificates of deposit with a maturity date of less than one year at the date of purchase are reported at cost or amortized cost, which approximates fair value. Investments held longer than one year are reported at fair value, based on quoted market prices. The City accounts for its cash, cash equivalents and investments in an entity-wide cash management pool, which is used essentially as a demand deposit account. For purposes of the statement of cash flows, the proprietary funds 49 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 consider all investments to be cash equivalents. Restricted cash and investments are reported separately on the financial statement. E. INTERFUND RECEIVABLES/PAYABLES Activity between funds that is representative of lending/borrowing arrangements and transactions between funds that are outstanding at the end of the fiscal year are referred to “due to/from other funds” Any residual balances outstanding between the governmental activities and business-type activities are reported in the government-wide financial statements as “internal balances.” The non-current portion of due from other funds is offset by nonspendable fund balance in the general fund to indicate that this portion of fund balance is not available for appropriation and is not expendable available financial resources. F. INVENTORIES AND PREPAID ITEMS All inventories are accounted for using the consumption method and are valued at cost using the first-in/first-out (FIFO) method. 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. Prepaid items are reported using the consumption method and recorded as expenditures/expenses at the time of consumption. G. CAPITAL ASSETS Capital assets, which include land, buildings, equipment and infrastructure assets (e.g., roads, bridges, curbs and gutters, streets and sidewalks, drainage systems, lighting systems, and similar items), are reported in the applicable governmental or business-type activities columns in the government-wide financial statements and the proprietary fund financial statements. The City defines capital assets as assets with an initial, individual cost of more than $5,000 and an estimated useful life in excess of three years. Such assets are recorded at historical cost. Donated capital assets are recorded at estimated fair market value at the date of donation. The cost of normal maintenance and repairs that do not add to the value of the asset or materially extend assets lives are not capitalized. Assets not being depreciated include land and construction in progress. Buildings, equipment, and infrastructure of the City and the HRA are depreciated using the straight-line method over the estimated useful lives as follows: Buildings 30 - 40 years Mains and Lines 40 - 50 years Streets 20 - 25 years Improvements 10 - 20 years Vehicles 3 - 30 years Equipment 3 - 20 years H. DEFERRED OUTFLOWS/INFLOWS OF RESOURCES In addition to assets, the statement of financial position will sometimes report a separate section for deferred outflows of resources. This separate financial statement element, deferred outflows of resources, represents a consumption of net position that applies to a future period(s) and will not be recognized as an outflow of resources (expense/expenditure) until then. The City has two items that qualify for reporting in this category. It is the deferred charge on refunding reported in the government-wide statement of net position and the deferred charge for pensions (see Pension section below for explanation). A deferred charge on refunding results from the difference in the carrying value of refunded debt and its reacquisition price. This amount is deferred and amortized over the shorter of the life of the refunded or refunding debt. In addition to liabilities, the statement of 50 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 financial position will sometimes report a separate section for deferred inflows of resources. This separate financial statement element, deferred inflows of resources, represents an acquisition of net position that applies to a future period(s) and will not be recognized as an inflow of resources (revenue) until that time. The City has one item that qualifies for reporting in this category. It is the deferred charge for pensions (see Pension section below for explanation). The City also has one type of item, which arises under a modified accrual basis of accounting that qualifies for reporting in this category. Accordingly, the item, unavailable revenue, is reported only in the governmental funds balance sheet. The governmental funds report unavailable revenues from four sources: property taxes, special assessments, loans and grants. These amounts are deferred and recognized as an inflow of resources in the period that the amounts become available. I. COMPENSATED ABSENCES The City compensates all employees upon termination for unused vacation or flex leave. Employees hired prior to August 1, 1998 may opt to have sick leave, at the rate of 8 hours for each calendar month of full-time service, instead of flex leave. Employees hired prior to August 1, 1998, that have not opted for flex leave, shall be entitled to severance pay, after completion of five years of continuous City employment. Severance pay is calculated by multiplying the total number of continuous years in the City employ and/or accumulated sick leave by the daily wage rate prevailing at date of severance, at one day per year of such employment, to a maximum of 20 days. Such severance money shall be paid in case of separation caused by death, eligible retirements, or medically attested disability preventing an employee from performing the major duties of the position or separation for non-disciplinary reasons. Accumulated vacation, flex and vested severance pay is reported as an expense and an accrued liability as the benefits accrue to employees in the government-wide and proprietary fund financial statements. A liability for these amounts is reported in the governmental funds only if benefits have matured as a result of employee resignations and retirements. The employee benefits internal service fund reports the governmental funds’ liability for compensated absences on the accrual basis. J. PENSIONS For purposes of measuring the net pension liability, deferred outflows/inflows of resources, and pension expense, information about the fiduciary net position of the Public Employees Retirement Association (PERA) and additions to/deductions from PERA's fiduciary net position have been determined on the same basis as they are reported by PERA except that PERA's fiscal year end is June 30. For this purpose, plan contributions are recognized as of employer payroll paid dates and benefit payments and refunds are recognized when due and payable in accordance with the benefit terms. Investments are reported at fair value. For purposes of measuring the liability, deferred outflows of resources and deferred inflows of resources, and expense associated with the City's requirement to contribute to the Hopkins Fire Relief Association, information about the Plan's fiduciary net position and additions to/deductions from the Hopkins Fire Relief Association Plan's fiduciary net position have been determined on the same basis as they are reported by the Plan. For this purpose, benefit payments (including refunds of contributions) are recognized when due and payable in accordance with the benefit terms. Investments are reported at fair value. K. LONG-TERM OBLIGATIONS In the government-wide financial statements, and proprietary 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, amortized over the life of the bonds. Bonds payable are reported net of the applicable bond premium or discount. 51 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 In the governmental fund financial statements bond premiums and discounts, as well as bond issuance costs are recognized 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. L. NET POSITION/FUND EQUITY Net position represents the difference between assets and liabilities in the government-wide financial statements. Net position invested in capital assets consists of capital assets net of accumulated depreciation, reduced by the outstanding balance of any long-term debt used to build or acquire the capital assets. Net position is reported as restricted in the government-wide financial statements when there are limitations imposed on their use through external restrictions imposed by creditors, grantors, laws or regulations of other governments. In the fund financial statements, governmental funds report fund balances in classifications that disclose constraints for which amounts in those funds can be spent. These classifications are as follows: Nonspendable – portions of fund balance related to prepaids, inventories, long-term receivables, and land held for resale. Restricted – funds are constrained by external parties (statute, grantors, bond agreements, etc.). Committed – fund constraints are established and modified by a resolution approved by the City Council. Assigned – consists of internally imposed constraints. These constraints are established by the City Council and/or management. The City Council also delegates the authority to assign fund balance to the Finance Director per City Legislative Policy 6-G, Fund Balance. Unassigned – is the residual classification for the General Fund and also reflects negative residual amounts in other funds. When an expenditure is incurred for purposes for which both restricted and unrestricted fund balance is available, it is the City’s policy to use restricted first, then unrestricted fund balance. When an expenditure is incurred for purposes for which committed, assigned, and unassigned amounts are available, it is the City’s policy to use committed first, then assigned, and finally unassigned amounts. The City formally adopted a fund balance policy for the General Fund. The policy establishes an unassigned fund of a minimum of 5 months or 42% of the previous year’s budgeted expenditures. M. INTERFUND TRANSACTIONS Inter-fund services provided and used are accounted for as revenues and expenditures. Transactions that constitute reimbursements to a fund for expenditures initially made from it that are properly applicable to another fund are recorded as expenditures in the reimbursing fund and as reductions of expenditures in the fund that is reimbursed. All other interfund transactions are reported as transfers. N. PROPERTY TAXES Property tax levies are set by the City Council in December of each year, and are certified to Hennepin County (the County) for collection in the following year. In the State of Minnesota, counties act as collection agents for all property taxes. The County spreads all levies over assessable property. Such taxes become a lien on January 1 and are recorded as receivables by the City at that date. 52 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 Real property taxes are payable by taxpayers in two equal installments, on May 15 and October 15. Personal property taxes are also payable by taxpayers in two equal installments, on February 28 and June 30. The County provides tax settlements to cities and other local governments three times a year, on or before January 25, July 5 and December 5. In the governmental fund financial statements property taxes are accrued and recognized as revenue for collections within 60 days of year-end. Taxes that remain unpaid at the County on December 31 are classified as delinquent taxes receivable, and are fully offset by deferred inflows of resources because they are not available to finance current expenditures. No allowance for uncollectible taxes has been provided because such amounts are not expected to be material. O. CONDUIT DEBT OBLIGATIONS From time to time, the City has issued Commercial Development Revenue Notes/Bonds in accordance with the Minnesota Municipal Industrial Development Act. These obligations are issued to provide financial assistance to private-sector entities for the acquisition and construction of industrial and commercial facilities deemed to be in the public interest. The obligations are secured by the property financed and are payable solely from payments received on the underlying mortgage loans. Upon repayment of the obligations, ownership of the acquired facilities transfers from the bond holder to the private-sector entity served by the debt issuance. Neither the City, the State, nor any political subdivision thereof is obligated in any manner for repayment of the obligations. Accordingly, the bonds are not reported as liabilities in the accompanying financial statements. As of December 31, 2016, there were 7 notes/bond issues outstanding, with an aggregate principal amount payable of approximately $31 million. P. USE OF ESTIMATES The preparation of financial statements in conformity with U.S. generally accepted accounting principles requires management to make estimates and assumptions that affect the reported amounts of assets and liabilities and disclosure of contingent assets and liabilities at the date of the financial statements and the reported amounts of revenues and expenses during the reporting period. Actual results could differ from those estimates. 2. RECONCILIATION OF GOVERNMENT-WIDE AND FUND FINANCIAL STATEMENTS A. 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 explains that long-term liabilities, including bonds payable, are not due and payable in the current period and therefore are not reported in the funds. Details of this difference are as follows: Bonds payable $ 49,546,974 Accrued interest payable 366,375 Net OPEB obligation 95,269 Net adjustment to reduce fund balance - total governmental funds to arrive at net position - governmental activities $ 50,008,618 53 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 B. 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 balances includes a reconciliation between net changes in fund balances – total governmental funds and change in net position of governmental activities as reported in the government-wide statement of activities. One element of that reconciliation explains, “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 details of this difference are as follows: Capital outlay $ 7,325,035 Depreciation expense (1,663,047) Net adjustment to increase net changes in fund balances - total governmental funds to arrive at changes in net position of governmental activities $ 5,661,988 Another element of that reconciliation explains that, “the issuance of long-term debt provides current financial resources to governmental funds, while the repayment of the principal of long-term debt uses financial resources of the governmental funds. Neither of these transactions has any effect on the net position. Also, governmental funds report the effect of premiums, discounts and similar items when debt is first issued, whereas these amounts are deferred and amortized in the statement of activities.” The details of these differences are as follows: Principal repayments $ (3,075,000) Issuance of general obligation bonds 12,310,000 Add premium 452,971 Less deferred loss on refunding debt - OPEB expense (49,635) Amortization of deferred losses on refunding 40,778 Amortization of bond premium and discount (55,852) Prior year interest expense (325,248) Accrue interest expense for current year 366,375 Net adjustment to decrease net changes in fund balances - total governmental funds to arrive at changes in net position of governmental activities 9,664,389 3. STEWARDSHIP, COMPLIANCE AND ACCOUNTABILITY A. BUDGETS AND BUDGETARY ACCOUNTING Annual budgets are adopted on a basis consistent with U.S. generally accepted accounting principles for all governmental funds except the Section 8 and Hennepin County CDBG special revenue funds, the debt service funds and the capital projects funds, which are not budgeted. A capital improvement plan is reviewed annually by the City Council for the capital projects funds and utility funds. However, appropriations for major projects are not adopted until the actual bid award of the improvement. The appropriations are not reflected in the financial statements. All annual appropriations lapse at fiscal year-end. The City follows these procedures in establishing the budgetary data reflected in the financial statements and set forth in Section 7.04 of the City Charter. 1. The City Manager shall, at the first regular council meeting in September, submit to the Council a proposed budget and an explanatory budget message in a form and manner as prescribed by the City Charter. 54 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 2. The Council shall determine the plan and time of the public hearings on the budget to obtain taxpayer comments. 3. The Council shall adopt the tax levy by resolution no later than a December date, which is annually established by law for the county auditor to levy taxes. The budget shall set forth the total for each budgeted fund with such segregation as to objects and purposes of expenditures as the Council deems necessary for purposes of budget control. 4. The City Manager is authorized to transfer budgeted amounts between departments within any fund; however, any revisions that alter the total expenditures of any fund must be approved by the City Council and are limited to the amount revenues exceed the budgets or authorize the transfer of sums from unexpended balances to other purposes. Budgeted expenditure appropriations lapse at year-end. The level of legal control is at the fund level. 5. The Council made no supplemental budgetary appropriation throughout the year. B. EXCESS OF EXPENDITURES OVER APPROPRIATIONS For the year ended December 31, 2016, actual expenditures exceeded the budgeted amounts in the following funds: General Fund $ 450,039 Economic Development 531,663 State Chemical Assessment Team 36,300 Parking 134,179 Communications 70,388 Depot Coffee House 45,514 Tax Increment District Entertainment District 462 Tax Increment District Sonoma 850 Tax Increment District Oakes of Mainstreet 615 5th Avenue Flats 884 These over expenditures were funded by greater than anticipated revenues of the General, Economic Development, State Chemical Assessment Team, Communications, Depot Coffee House, and Tax Increment District Entertainment District funds, from fund balance in the General, Economic Development, Parking, Communications, and Tax Increment District Oakes of Mainstreet funds, and by future revenues in the Tax Increment District Sonoma, and 5th Avenue Flats funds. Budgets are adopted for some special revenue fund types but not all. Excluded from the budget adoption process are funds that are completely reimbursable from the federal and state governments. The Community Development Block Grant Funds is a non-budgeted fund. 55 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 C. FUND BALANCE DEFICITS At December 31, 2016, the following funds had deficit fund balances or net position. These deficits will be funded through future tax levies, contributions, grants, charges for services or developer payments: Art Center $ 997,040 Permanent Improvement Revolving 639,073 Depot Coffee House 8,296 Tax Increment District Sonoma 103,148 5th Avenue Flats 389,831 Tax Increment District Marketplace & Main 152,716 Capital Improvement 245,928 Municipal State Aid Construction 253,875 D. NET POSITION RESTRICTED BY ENABLING LEGISLATION The government-wide statement of net position reports $5,640,502 in restricted net position for economic development, of which $5,604,519 is restricted by enabling legislation. The remaining $36,083 is CDBG funds restricted by outside parties. 4. DEPOSITS AND INVESTMENTS As of December 31, 2016 the City had the following deposits and investments: Investment Type Fair Value Government sponsored entities $ 3,398,411 Municipal obligations 5,085,636 Negotiable certificates of deposit 9,308,699 Money market mutual fund 10,196,445 Deposits 939,024 Total fair value cash and investments $ 28,928,215 Interest rate risk – Interest rate risk is the risk that the fair value of investments will be adversely affected by a change in interest rates. In accordance with City of Hopkins Legislative Policy 6-B, Standards of Investments, the city manages its exposure to declines in fair values by structuring the investment portfolio so that securities mature to meet cash requirements for ongoing operations, thereby avoiding the need to sell securities on the open market prior to maturity. At December 31, 2016 the City had the following investment maturities: Investment Maturities (in Years) Less No Total than One 1-5 6-10 Maturity Investment Type: Government sponsored entities FHLM $ 994,565 $ - $ 994,565 $ - $ - FHLB 1,746,741 - 1,746,741 - - FFCB 657,105 - 657,105 - - Municipal obligations 5,085,636 535,754 4,451,509 98,373 - Negotiable certificates of deposit 9,308,699 1,458,778 7,849,921 - - Money market mutual fund 10,196,445 - - - 10,196,445 $ 27,989,191 $ 1,994,532 $ 15,699,841 $ 98,373 $ 10,196,445 56 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 Credit risk – Credit risk is the risk that an issuer or other counter party to an investment will not fulfill its obligations. Credit risk is measured using credit quality ratings of investments in debt securities as described by nationally recognized rating agencies such as Standard & Poor’s and Moody’s. According to the City’s investment policy commercial paper shall be restricted to issues, which mature in 270 days or less with a rating of A-1 (Moody’s), P-1 (Standard & Poor’s) or F-1 (Fitch) among at least two of the three rating agencies. The City is authorized by Minnesota Statutes to invest in the following: (a) Direct obligations or obligations guaranteed by the United States or its agencies (b) Shares of investment companies registered under the Federal Investment Company Act of 1940 and whose only investments are in securities described in (a) above (c) General obligations in the State of Minnesota or any of its municipalities (d) Bankers’ acceptances 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 maturity in 270 days or less; and (f) Guaranteed investment contracts issued or guaranteed by United States commercial banks or domestic branches of foreign banks or United States insurance companies or their subsidiaries (g) 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, or certain Minnesota securities broker-dealers. The following table lists the credit quality ratings per Moody’s and/or Standard and Poor’s and/or Fitch of the City’s investments at December 31, 2016. Credit Ratings Not Total AAA AA Rated Investment Type: Government securities FHLM $ 994,565 $ - $ 994,565 $ - FHLB 1,746,741 - 1,746,741 FFCB 657,105 - 657,105 Municipal obligations 5,085,636 1,192,599 3,893,037 - Negotiable certificates of deposit 9,308,699 - - 9,308,699 Money market mutual fund 10,196,445 - - 10,196,445 $ 27,989,191 $ 1,192,599 $ 7,291,448 $ 19,505,144 Custodial credit risk Deposits – For deposits, this is the risk that in the event of a bank failure, the City’s deposits may not be returned to it. 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. Authorized collateral includes the legal investments described above, as well as certain first mortgage notes, and certain other state or local government obligations. Minnesota Statutes require that securities pledged as collateral be held in safekeeping by the City treasurer or in a financial institution other than that furnishing the collateral. At December 31, 2016 the City had no deposits that were uninsured or uncollateralized. The deposits were insured or collateralized by securities held by the City’s agent in the City’s name. Investments – For an investment, this is the risk that, in the event of the failure of the counterparty, the City will not be able to recover the value of its investments or collateral securities that are in the possession of an outside party. All investments held by the City are insured or registered or are held by the City or its agent in the City’s name. The City has no investments that are uninsured or unregistered nor are any investments held by a counterparty or a counterparty's trust department or agent that is not in the city's name. Concentration of credit risk – This is the risk associated with investing a significant portion of the City’s investments (considered 5% or more) in the securities of a single issuer, excluding U.S. explicitly guaranteed investments 57 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 (Treasuries), investment pools, and mutual funds. As of December 31, 2016, the city had no investments exceeding 5% or more for a single issuer. Fair Value Measurement – The City used fair value measurements to record fair value adjustments to certain assets and liabilities and to determine fair value disclosures. The City follows an accounting standard that defines fair value, establishes a framework for measuring fair value, establishes a fair value hierarchy based on the quality of inputs used to measure fair value, and requires expanded disclosures about fair value measurements. In accordance with this standard, the City has categorized its investments, based on the priority of the inputs to the valuation technique, into a three-level fair value hierarchy. The fair value hierarchy gives the highest priority to quoted prices in active markets for identical assets or liabilities (Level 1) and the lowest priority to unobservable inputs (Level 3). If the inputs used to measure the financial instruments fall within different levels of the hierarchy, the categorization is based on the lowest level input that is significant to the fair value measurement of the instrument. Financial assets and liabilities recorded on the combined statements of financial position are categorized based on the inputs to the valuation techniques as follows:  Level 1 - Financial assets and liabilities are valued using inputs that are unadjusted quoted prices in active markets accessible at the measurement date of identical financial assets and liabilities.  Level 2 - Financial assets and liabilities are values based on quoted prices for similar assets, or inputs that are observable, either directly or indirectly for substantially the full term through corroboration with observable market data.  Level 3 - Financial assets and liabilities are valued using pricing inputs which are unobservable for the asset, inputs that reflect the reporting entity's own assumptions about the assumptions market participants and would use in pricing the assets. Assets measured a fair value on a recurring basis: Level 1 Level 2 Level 3 Total U.S. Government Securities - 3,398,411 $ - 3,398,411 Municipal Obligations - 5,085,636 - 5,085,636 Negotiable Certificates of Deposit - 9,308,699 - 9,308,699 - 17,792,746 $ - 17,792,746 Investments measured at amortized cost 10,196,445 27,989,191 58 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 5. CAPITAL ASSETS Capital asset activities for the year ended December 31, 2016 were as follows: Beginning Ending Balance Increase Decreases Transfers Balance Governmental activities: Capital assets, not being depreciated Land $ 6,157,677 $ - $ - $ - $ 6,157,677 Construction in progress 8,418,116 5,159,340 - (3,059,531) 10,517,925 Total not being depreciated 14,575,793 5,159,340 - (3,059,531) 16,675,602 Capital assets, being depreciated Buildings 20,247,778 433,742 - - 20,681,520 Other Improvements 41,859,557 1,509,425 - 3,059,531 46,428,513 Vehicles 4,033,248 428,628 (305,719) - 4,156,157 Machinery & equipment 6,411,180 356,376 (155,157) - 6,612,399 Total being depreciated 72,551,763 2,728,171 (460,876) 3,059,531 77,878,589 Less accumulated depreciation Buildings (6,659,634) (526,777) - - (7,186,411) Other Improvements (17,149,363) (1,067,300) - - (18,216,663) Vehicles (2,192,538) (253,082) 305,719 - (2,139,901) Machinery & equipment (3,980,455) (376,083) 151,546 - (4,204,992) Total accumulated depreciation (29,981,990) (2,223,242) 457,265 - (31,747,967) Total capital assets, being depreciated, net 42,569,773 504,929 (3,611) 3,059,531 46,130,622 Governmental activities capital assets, net $ 57,145,566 $ 5,664,269 $ (3,611) $ - $ 62,806,224 Beginning Ending Balance Increases Decreases Transfers Balance Business-type Activities: Capital assets, not being depreciated Land $ 254,299 $ - $ - $ $ 254,299 Construction in progress 1,449,379 3,176,037 - (14,518) 4,610,898 Total not being depreciated 1,703,678 3,176,037 - (14,518) 4,865,197 Capital assets, being depreciated Buildings 8,129,615 98,436 - 14,518 8,242,569 Infrastructure 19,141,910 1,087,965 - - 20,229,875 Other Improvements 12,058,535 3,657 - - 12,062,192 Vehicles 1,023,361 140,463 (57,278) - 1,106,546 Machinery & equipment 876,669 38,913 - - 915,582 Total being depreciated 41,230,090 1,369,434 (57,278) 14,518 42,556,764 Less accumulated depreciation Buildings (4,844,663) (241,892) - - (5,086,555) Infrastructure (12,211,058) (268,362) - - (12,479,420) Other Improvements (2,052,571) (398,043) - - (2,450,614) Vehicles (555,902) (83,590) 57,278 - (582,214) Machinery & equipment (568,086) (34,628) - - (602,714) Total accumulated depreciation (20,232,280) (1,026,515) 57,278 - (21,201,517) Total capital assets, being depreciated, net 20,997,810 342,919 - 14,518 21,355,247 Business-type activities capital assets, net $ 22,701,488 $ 3,518,956 $ - $ - $ 26,220,444 59 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 Depreciation expense was charged to City functions as follows: Governmental activities: General government $ 84,849 Public safety 216,774 Highways and streets 1,223,360 Urban redevelopment and housing - Culture and recreation 137,389 Capital assets held by the government's internal service funds are 560,870 charged to the various functions based on their usage of the assets Total depreciation expense - governmental activities $ 2,223,242 Business-type activities: Water $ 258,864 Sewer 191,446 Storm Sewer 241,731 Refuse 74,572 Pavilion/Ice arena 81,291 Housing and Redevelopment Authority 178,611 Total depreciation expense - business-type activities $ 1,026,515 Construction commitments The City has active construction projects as of December 31, 2016. The projects include street improvements. The City’s commitment with contractors related to these projects is $1,576,559. On October 15, 2013 the City Council entered into a 14 year maintenance agreement with SEH Design/Build, Inc. for inspection, maintenance, cleaning and painting of the city's two water towers. The contract commitment totals $1,529,400 and will be paid in annual installments beginning in 2014. 6. INTERFUND RECEIVABLES AND PAYABLES The following funds had amounts receivable from other funds, and the respective funds had equal amounts payable to other funds at December 31, 2016: Due from Other Funds Economic General Development Total Due to other funds: Non-major governmental $ 709,733 $ 510,526 $ 1,220,259 Arts Center 1,011,663 - 1,011,663 Water 399,423 - 399,423 Non-major proprietary 448,938 - 448,938 Total due to other funds $ 2,569,757 $ 510,526 $ 3,080,283 The interfund receivables and payables are to eliminate negative cash between funds and to allow for development loans or to facilitate a project or operations of another fund. 60 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 7. INTERFUND TRANSFERS The following is a summary of transfers between funds as of December 31, 2016: Transfers in GO TI Revenue Permanent Art Bonds Improvement Non-major Storm Internal Center of 2015D Revolving Governmental Water Sewer Sewer Service Total Transfers out: General $ - $ - $ - $ 151,000 $ - $ - $ - $ - $ 151,000 Tax Increment District Super Valu - - - 818,108 - - - - 818,108 Permanent Improvement Revolving - - - 70,180 846,916 609,556 420,190 - 1,946,842 Water - - - 189,626 - - - - 189,626 Sewer - - - 181,596 - - - - 181,596 Storm Sewer - - - 220,874 - - - - 220,874 Non-major governmental 86,920 371,000 4,341,871 1,555,958 930,348 - - 1,896,571 9,182,668 Non-major business- type - - - 125,000 - - - 125,000 Total transfers in $ 86,920 $ 371,000 $ 4,341,871 $ 3,312,342 $ 1,777,264 $ 609,556 $ 420,190 $ 1,896,571 $ 12,815,714 Interfund transfers allow the City to allocate financial resources to debt service funds that are paying the general obligation debt. Non-routine transfers include the following: 1) Annual transfers from water, sewer, storm sewer and refuse funds for lease payments on new public works facility. 2) An annual transfer, from the non-major governmental Communication funds to the Art Center Fund totaling $86,920 to pay the original debt for building the facility. 3) Annual transfers from Tax Increment Special Revenue funds to Debt Service funds for debt payments. 4) Transfers from non-major governmental funds to Permanent Improvement Revolving for bond proceeds. 5) Transfer from the water, sewer, storm sewer and refuse funds to a non-major governmental Capital Project fund of $400,000 for the public works garage upgrade. 6) Transfer from the general fund to the non-major governmental Capital Project fund of $125,000 for the public works garage upgrade. 7) Transfers from water, sewer and storm sewer to non-major governmental debt funds for bond payment contributions. 8. LEASES The city has entered into a lease agreement as a lessee for financing the acquisition of an aerial lift fire truck with a down payment of $445,427. The lease agreement qualifies as a capital lease for accounting purposes and, therefore, has been recorded at the present value of their future minimum lease payments as of the inception date. The asset acquired through the capital lease is as follows: Governmental Activities Asset: Machinery and equipment $ 870,427 Less: Accumulated depreciation (369,882) Total $ 500,545 61 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 The future minimum lease obligations and the net present value of these minimum lease payments as of December 31, 2016 are as follows: Governmental Year Ending December 31, Activities 2017 $ 54,217 2018 54,217 Total minimum lease payments 108,434 Less: amount representing interest (6,306) Present value of minimum lease payments $ 102,128 9. LONG-TERM DEBT The City issues general obligation bonds to provide funds for the acquisition and construction of major capital facilities. General obligation bonds have been issued for governmental activities. General Obligation Bonds are backed by the full faith, credit and taxing power of the City, and are serviced by General and Tax Increment levies and also by fees assessed against benefited properties. These bonds generally are issued as 20-year serial bonds. Refunding On November 24, 2015 the City issued $4,340,000 General Obligation Tax Increment Revenue Refunding Bonds, Series 2015C to refinance the 2008 HRA Tax Increment Bonds. Future debt service payments will be reduced by $1,512,822 with a present value savings of $1,653,200. The refunded bonds were paid on February 1, 2016. On December 22, 2015 the City issued $7,355,000 General Obligation Tax Increment Revenue Refunding Bonds, Series 2015D to refinance the 2007 HRA Tax Increment Bonds. Future debt service payments will be reduced by $2,286,264 with a present value savings of $2,684,264. The refunded bonds were paid on February 1, 2016. On October 18, 2016 the City issued $3,540,000 General Obligation Tax Increment Revenue Refunding Bonds, Series 2016D to refinance the 2009 HRA Tax Increment Bonds. Future debt service payments will be reduced by $1,377,981 with a present value savings of $1,794,785. The refunded bonds were paid on February 1, 2017. General Obligation Bonds On July 20, 2016 the City issued $1,630,000 General Obligation Tax Abatement Bonds, Series 2016B for park projects and parking lot improvements. On October 18, 2016 the City issued $2,805,000 General Obligation Bonds series 2016C for the acquisition of equipment and various utility system improvements. General obligation bonds currently outstanding are as follows: Purpose Interest Rates Original Amount Current Amount Governmental activities 0.35 – 3.20% 18,510,000 $ 17,570,000 Governmental activities – refunding 0.50 – 4.80% 26,030,000 22,865,000 62 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 Annual debt service requirements to maturity for general obligation bonds are as follows: Year Ending Governmental Activities December 31 Principal Interest 2017 $ 2,480,000 $ 865,231 2018 3,325,000 839,813 2019 3,245,000 766,899 2020 3,335,000 692,233 2021 3,435,000 614,020 2022-2026 13,510,000 2,085,039 2027-2031 9,755,000 719,920 2032-2036 1,350,000 77,683 $ 40,435,000 $ 6,660,838 The City also has special assessment bonds, which are backed by the full faith, credit and taxing power of the City, and repayment monies are generated by the collection of special assessments and general levies. On July 20, 2016 the City issued $4,335,000 General Obligation Improvement Bonds series 2016A for the 2016 street reconstruction project. General obligation bonds currently outstanding are as follows: Purpose Interest Rates Original Amount Current Amount Street Improvements 0.50 – 3.125% 9,810,000 $ 8,065,000 Annual debt service requirements to maturity for special assessment bonds are as follows: Year Ending Governmental Activities December 31 Principal Interest 2017 $ 600,000 $ 183,409 2018 620,000 171,428 2019 635,000 158,646 2020 645,000 145,188 2021 660,000 130,460 2022-2026 3,410,000 409,155 2027-2030 1,495,000 62,900 $ 8,065,000 $ 1,261,186 63 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 Revenue Bonds The City also issues bonds where the government pledges income derived from the acquired or constructed assets to pay debt service. Revenue bonds outstanding at year-end are as follows: Purpose Interest Rates Original Amount Current Amount Water construction & replacement 2.0 – 4.0% 820,000 585,000 Water construction & replacement 2.0 – 2.2% 760,000 640,000 Water construction & replacement 2.0 - 2.5% 860,000 810,000 Sanitary sewer construction & replacement 2.0 – 4.0% 1,020,000 730,000 Sanitary sewer construction & replacement 2.0 – 2.2% 170,000 140,000 Sanitary sewer construction & replacement 2.0 - 2.5% 490,000 460,000 Storm sewer – refunding 0.5 – 2.9% 875,000 610,000 Storm sewer construction & replacement 2.0 – 2.2% 320,000 270,000 Storm sewer construction & replacement 2.0 - 2.5% 380,000 360,000 Pavilion equipment certificates 2.0 – 2.0% 175,000 140,000 Revenue bond debt service requirements to maturity are as follows: Year Ending December 31 Principal Interest 2017 $ 385,000 $ 108,969 2018 395,000 99,494 2019 405,000 89,563 2020 410,000 78,951 2021 425,000 67,561 2022-2026 1,760,000 170,448 2027-2029 585,000 18,839 $ 4,365,000 $ 633,825 The City is subject to a statutory limit of bonded indebtedness equaling 3.0 percent of taxable market value. At December 31, 2016, the debt limit for the City is $51,633,159. Of the total debt, $18,725,000 of general obligation and revenue bonds is applicable to the limit. The legal debt margin is $32,908,159. 64 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 Changes in Long-Term Liabilities Long-term liability activity for the year ended December 31, 2016, was as follows: Beginning Ending Due Within Balance Additions Deductions Balance One Year Governmental Activities: Bonds payable: G.O. tax increment bonds $ 15,205,000 $ 3,540,000 $ 1,370,000 $ 17,375,000 $ 980,000 General obligation bonds 15,400,000 8,770,000 1,110,000 23,060,000 1,500,000 Total general obligation bonds 30,605,000 12,310,000 2,480,000 40,435,000 2,480,000 Special assessment bonds 8,660,000 - 595,000 8,065,000 600,000 Less deferred amounts For issuance discounts (48,428) - 6,687 (41,741) - For issuance premiums 698,283 452,970 62,538 1,088,715 - Total bonds payable 39,914,855 12,762,970 3,144,225 49,546,974 3,080,000 Compensated absences 805,664 805,286 832,796 778,154 778,154 Capital lease payable 149,616 - 47,488 102,128 24,616 Governmental activity long-term liabilities $ 40,870,135 $ 13,568,256 $ 4,024,509 $ 50,427,256 $ 3,882,770 Business-type activities: Bonds payable: Revenue bonds $ 4,745,000 $ - $ 380,000 $ 4,365,000 $ 385,000 Less deferred amounts For issuance discounts (5,076) - 717 (4,359) - For issuance premiums 67,708 - (6,088) 61,620 - Total bonds payable 4,807,632 - 374,629 4,422,261 385,000 Compensated absences 83,937 79,676 65,516 98,097 82,488 Business-type activity long-term liabilities $ 4,891,569 $ 79,676 $ 440,145 $4,520,358 $ 467,488 For the governmental activities, compensated absences liability is generally liquidated by the general and by the parking, communications, Depot Coffee House and arts center special revenue funds. For the governmental activities, the OPEB and pension liabilities are generally liquidated by the general and by the parking, communications, Depot Coffee House and arts center special revenue funds. (remainder of page left blank intentionally) 65 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 10. FUND BALANCES At December 31, 2016, the City had various fund balances through legal restriction and City Council authorization. Major fund balance appropriations at December 31, 2016 are shown on the various balance sheets as segregations of the fund balance. The fund balances are as follows: Total Nonspendable Restricted Committed Assigned Unassigned General Fund $ 5,437,774 $ - $ - $ - $ - $ 5,437,774 Inventories 87,263 87,263 - - - - Community development 340,857 - - - 340,857 - Total General Fund 5,865,894 87,263 - - 340,857 5,437,774 Economic Development Economic Development 4,356,160 - - 4,356,160 - - Total Economic Development Fund 4,356,160 -- 4,356,160 - - Arts Center Deficit Fund Balance (997,040) - - - - (997,040) Total Arts Center Fund (997,040) - - - - (997,040) Tax Increment District Super Valu Property held for resale 321,719 321,719 Tax Increment 4,695,770 4,695,770 Total Tax Increment District Super Valu 5,017,489 - 5,017,489 - - - 2015D G.O. TI Revenue Bonds Debt service 148,753 - 148,753 - - - 2016D G.O. TI Revenue Bonds Debt service 3,678,531 - 3,678,531 - - - Permanent Improvement Revolving Capital asset replacement (639,073) - - - - (639,073) Nonmajor Governmental Funds Public Safety 243 243 - - - Rehab loans 36,083 - 36,083 - - - Debt service 4,978,807 - 4,978,807 - - - Tax increment 586,930 - 586,930 - - - Park improvements 760,900 - 760,900 - - - Parking improvements 149,861 - - 149,861 - - Communications 528,074 - - 528,074 - - Deficit fund balance (1,153,794) - - - - (1,153,794) Total Nonmajor Funds 5,887,104 - 6,362,963 677,935 - (1,153,794) Total Fund Balances $ 23,317,818 $ 87,263 $ 15,207,736 $ 5,034,095 $ 340,8574 $ 2,647,867 66 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 11. PENSION PLAN OBLIGATIONS 1. Defined Benefit Pension Plans - Statewide A. Plan Description The City participates in the following cost-sharing multiple-employer defined benefit pension plans administered by the Public Employees Retirement Association of Minnesota (PERA). PERA’s defined benefit pension plans are established and administered in accordance with Minnesota Statutes, Chapters 353 and 356. PERA’s defined benefit pension plans are tax qualified plans under Section 401 (a) of the Internal Revenue Code. 1. General Employees Retirement Fund (GERF) All full-time and certain part-time employees of the City are covered by the General Employees Retirement Fund (GERF). 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 Basic Plan was closed to new members in 1967. All new members must participate in the Coordinated Plan. 2. Public Employees Police and Fire Fund (PEPFF) The PEPFF, originally established for police officers and firefighters not covered by a local relief association, now covers all police officers and firefighters hired since 1980. Effective July 1, 1999, the PEPFF also covers police officers and firefighters belonging to a local relief association that elected to merge with and transfer assets and administration to PERA. Benefits Provided PERA provides retirement, disability, and death benefits. Benefit provisions are established by state statute and can only be modified by the state legislature. Benefit increases are provided to benefit recipients each January. Increases are related to the funding ratio of the plan. Members in plans that are at least 90 percent funded for two consecutive years are given 2.5% increases. Members in plans that have not exceeded 90% funded, or have fallen below 80%, are given 1% increases. The benefit provisions stated in the following paragraphs of this section are current provisions and apply to active plan participants. 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. 1. GERF Benefits 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. Two methods are used to compute benefits for PERA's Coordinated and Basic Plan members. The retiring member receives the higher of a step-rate benefit accrual formula (Method 1) or a level accrual formula (Method 2). Under Method 1, the annuity accrual rate for a Basic Plan member is 2.2% of average salary for each of the first ten years of service and 2.7% for each remaining year. The annuity accrual rate for a Coordinated Plan member is 1.2 percent of average salary for each of the first ten years and 1.7% for each remaining year. Under Method 2, the annuity accrual rate is 2.7% of average salary for Basic Plan members and 1.7% for Coordinated Plan members for each year of service. For members hired prior to July 1, 1989, a full annuity is available when age plus years of service equal 90 and normal retirement age is 65. For members hired on or after July 1, 1989, normal retirement age is the age for unreduced Social Security benefits capped at 66. Disability benefits are available for vested members and are based upon years of service and average high-five salary. 67 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 2. PEPFF Benefits Benefits for the PEPFF members first hired after June 30, 2010, but before July 1, 2014, vest on a prorated basis from 50% after five years up to 100% after ten years of credited service. Benefits for PEPFF members first hired after June 30, 2014, vest on a prorated basis from 50% after ten years up to 100% after twenty years of credited service. The annuity accrual rate is 3% of average salary for each year of service. For PEPFF who were first hired prior to July 1, 1989, a full annuity is available when age plus years of service equal at least 90. B. Contributions Minnesota Statutes Chapter 353 sets the rates for employer and employee contributions. Contribution rates can only be modified by the state legislature. 1. GERF Contributions Basic Plan members and Coordinated Plan members were required to contribute 9.1% and 6.50%, respectively, of their annual covered salary in calendar year 2016. The City was required to contribute 11.78% of pay for Basic Plan members and 7.50% for Coordinated Plan members in calendar year 2016. The City’s contributions to the GERF for the year ended December 31, 2016, were $376,176. The City’s contributions were equal to the required contributions as set by state statute. 2. PEPFF Contributions Plan members were required to contribute 10.8% of their annual covered salary in calendar year 2016. The City was required to contribute 16.20% of pay for PEPFF members in calendar year 2016. The City’s contributions to the PEPFF for the year ended December 31, 2016, were $444.662. The City’s contributions were equal to the required contributions as set by state statute. C. Pension Costs 1. GERF Pension Costs At December 31, 2016, the City reported a liability of $6,763,547 for its proportionate share of the GERF’s net pension liability. The City’s net pension liability reflected a reduction due to the State of Minnesota’s contribution of $6 million to the fund in 2016. The State of Minnesota is considered a non-employer contributing entity and the state’s contribution meets the definition of a special funding situation. The State of Minnesota’s proportionate share of the net pension liability associated with the City totaled $88,334. The net pension liability was measured as of June 30, 2016, and the total pension liability used to calculate the net pension liability was determined by an actuarial valuation as of that date. The City’s proportion of the net pension liability was based on the City’s contributions received by PERA during the measurement period for employer payroll paid dates from July 1, 2015, through June 30, 2016, relative to the total employer contributions received from all of PERA’s participating employers. At June 30, 2016, the City’s proportion was .0833%, which was a decrease of .0002% from its proportion measured as of June 30, 2015. For the year ended December 31, 2016, the City recognized pension expense of $901,432 for its proportionate share of the GERF’s pension expense. 68 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 At December 31, 2016, the City reported its proportionate share of the GERF’s deferred outflows of resources and deferred inflows of resources related to pensions from the following sources: Description Deferred Outflows of Resources Deferred Inflows of Resources Differences between expected and actual economic experience $ - $ 549,438 Changes of assumptions 1,324,308 - Net difference between projected and actual earnings on pension plan investments 1,283,750 - Changes in proportion and differences between city contributions and proportionate share of contributions 7,430 136,227 City contributions subsequent to the measurement date 352,912 - Total $ 2,968,400 $ 685,665 A total of $352,912 reported as deferred outflows of resources related to pensions resulting from City contributions subsequent to the measurement date will be recognized as a reduction of the net pension liability in the year ended December 31, 2016. Other amounts reported as deferred outflows and inflows of resources related to pensions will be recognized in pension expense as follows: Year Ended June 30 2017 547,949 2018 514,949 2019 655,614 2020 244,311 2121 - Thereafter - 2. PEPFF Pension Costs At December 31, 2016, the City reported a liability of $11,236,887 for its proportionate share of the PEPFF’s net pension liability. The net pension liability was measured as of June 30, 2016, and the total pension liability used to calculate the net pension liability was determined by an actuarial valuation as of that date. The City’s proportion of the net pension liability was based on the City’s contributions received by PERA during the measurement period for employer payroll paid dates from July 1, 2015, through June 30, 2016, relative to the total employer contributions received from all of PERA’s participating employers. At June 30, 2016, the City’s proportion was .280%, which was a decrease of .011% from its proportion measured as of June 30, 2015. For the year ended December 31, 2016, the City recognized pension expense of $1,964,886 for its proportionate share of the PEPFF’s pension expense. The City also recognized $25,200 for the year ended December 31, 2016, as pension expense (and grant revenue) for its proportionate share of the State of Minnesota’s on-behalf contributions to the PEPFF. Legislation passed in 2013 required the State of Minnesota to begin contributing $9 million to the PEPFF each year, starting in fiscal year 2014. 69 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 At December 31, 2016, the City reported its proportionate share of the PEPFF’s deferred outflows of resources and deferred inflows of resources related to pensions from the following sources: Description Deferred Outflows of Resources Deferred Inflows of Resources Differences between expected and actual economic experience $ - $ 1,289,084 Changes of assumptions 6,184,150 - Net difference between projected and actual earnings on pension plan investments 1,714,826 - Changes in proportion and differences between city contributions and proportionate share of contributions 102,899 7,200 City contributions subsequent to the measurement date 225,742 - Total $ 8,227,617 $ 1,296,284 A total of $225,743 reported as deferred outflows of resources related to pensions resulting from City contributions subsequent to the measurement date will be recognized as a reduction of the net pension liability in the year ended December 31, 2016. Other amounts reported as deferred outflows and inflows of resources related to pensions will be recognized in pension expense as follows: Year Ended June 30 2017 1,440,508 2018 1,440,507 2019 1,440,507 2020 1,301,928 2021 1,082,141 Thereafter - D. Actuarial Assumptions The total pension liability in the June 30, 2015, actuarial valuation was determined using the following actuarial assumptions: Inflation 2.50% per year Active Member Payroll Growth 3.25% per year Investment Rate of Return 7.50% Salary increases were based on a service-related table. Mortality rates for active members, retirees, survivors and disabilitants were based on RP-2014 tables for males or females, as appropriate, with slight adjustments. Cost of living benefit increases for retirees are assumed to be: on percent per year for all future years for the General Employees Plan and Police and Fire Plan. Actuarial assumptions used in the June 30, 2016, valuation were based on the results of actuarial experience studies. The most recent four-year experience study in the General Employees Plan was completed in 2015. The experience study for Police and Fire Plan was for the period July 1, 2004 through June 30, 2009. 70 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 The following changes in actuarial assumptions occurred in 2016:  The assumed post-retirement benefit increase rate was changed from 1.0% per year through 2035 and 2.5% per year thereafter to 1.0% per year for all future years.  The assumed investment return rate was changed from 7.9% to 7.5%. The single discount rate was changed from 7.9% to 7.5%.  Other assumptions were changed pursuant to the experience study dated June 30, 2015. The assumed future salary increases, payroll growth, and inflation were decreased by 0.25% to 3.25% for payroll growth and 2.50% for inflation. Police and Fire Fund  The assumed post-retirement benefit increase rate was changed from 1.0% per year through 2037 and 2.5% thereafter to 1.0% per year for all future years.  The assumed investment return was changed from 7.9% to 7.5%. The single discount rate changed from 7.9% to 5.6%.  The assumed future salary increases, payroll growth, and inflation were decreased by 0.25% to 3.25% for payroll growth and 2.50% for inflation. The State Board of Investment, which manages the investments of PERA, prepares an analysis of the reasonableness on a regular basis of the long-term expected rate of return on a regular basis using a building-block method in which best-estimate ranges of expected future rates of return are developed for each major asset class. These ranges are combined to produce an expected long-term rate of return by weighting the expected future rates of return by the target asset allocation percentages. The target allocation and best estimates of geometric real rates of return for each major asset class are summarized in the following table: Asset Class Target Allocation Long-Term Expected Real Rate of Return Domestic Stocks 45% 5.50% International Stocks 15% 6.00% Bonds 18% 1.45% Alternative Assets 20% 6.40% Cash 2% 0.50% Total 100% E. Discount Rate The discount rate used to measure the total pension liability in 2016 was 7.5%, a reduction from the 7.9% used in 2015. The projection of cash flows used to determine the discount rate assumed that contributions from plan members and employers will be made at rates set in Minnesota Statutes. Based on these assumptions, the fiduciary net position of the General Employees Fund was projected to be available to make all projected future benefit payments of current plan members. Therefore, the long-term expected rate of return on pension plan investments was applied to all periods of projected benefit payments to determine the total pension liability. 71 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 In the Police and Fire Fund, the fiduciary net position was projected to be available to make all projected future benefit payments of current plan members through June 30, 2056 and June 30, 2058 respectively. Beginning in fiscal years ended June 30, 2057 for the Police and Fire Fund, when projected benefit payments exceed the funds’ projected fiduciary net position, benefit payments were discounted at the municipal bond rate of 2.85% based on an index of 20- year general obligation bonds with an average AA credit rating at the measurement date. An equivalent single discount rate of 5.60% for the Police and Fire Fund was determined that produced approximately the same present value of projected benefits when applied to all years of projected benefits as the present value of projected benefits using 7.50% applied to all years of projected benefits through the point of asset depletion and 2.85% after. F. Pension Liability Sensitivity The following presents the City’s proportionate share of the net pension liability for all plans it participates in, calculated using the discount rate disclosed in the preceding paragraph, as well as what the City’s proportionate share of the net pension liability would be if it were calculated using a discount rate one percentage point lower or one percentage point higher than the current discount rate: G. Pension Plan Fiduciary Net Position Detailed information about each pension plan’s fiduciary net position is available in a separately-issued PERA financial report that includes financial statements and required supplementary information. That report may be obtained on the Internet at www.mnpera.org. 2. Hopkins Fire Relief Association (HFRA) A. Plan Description Firefighters of the City of Hopkins are members of the Hopkins Fire Department Relief Association. The Association is the administrator of the single-employer defined benefit pension plan available to firefighters. The plan was established in 1909 and is administered pursuant to Minnesota Statutes Chapter 69, Chapter 424A, and the Association’s by-laws. It is governed by a Board of Trustees made up of six members elected by the members of the Association for three year terms, and the Mayor, City Clerk and Fire Chief, who serve as ex-officio voting members of the Board of Trustees. As of December 31, 2014, membership includes 40 active participants and 18 vested terminated employees entitled to benefit but not yet receiving them The Association issues a publically available financial report that includes financial statements and required supplementary information of the Hopkins Fire Relief Association. That report may be obtained by writing to the Hopkins Fire Relief Association, 1010 First St S, Hopkins, MN 55343. For financial reporting purposes, the Association’s financial statements are not included with the City financial statements because the Association is not a component unit of the City. The Association does not have any component units.   1% Lower 6.5% 9,606,241$      4.6% 15,730,151$   Current discount rate 7.5% 6,763,547$      5.6% 11,236,887$   1% Higher 8.5% 4,306,673$      6.6% 3,056,469$      General  Employees  Fund Police and Fire  Fund Sensitivity of Net Pension Liability at Current Single Discount  Rate 72 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 B. Benefits Provided The Association operates under a defined benefit plan. The pension liability is calculated by the number of active service years multiplied by a set benefit level. The Association’s current level is at $6,100 per active year. According to the bylaws of the Association and pursuant to Minnesota statute 424A.02, subdivisions 2 and 4, members who retire with less than 20 years of service and have reached the age of 50 years and have completed at least ten years of active membership are entitled to a reduced service pension not to exceed the amount calculated by multiplying the member’s service pension for the completed years of service times the applicable non-forfeitable percentage of pension. The defined retirement benefits are based on members’ years of service. Vesting begins after the 10th year of service with a 60% benefit increasing by 4% per year to 100% after the 20th year of service. If a member of the Association shall become totally and permanently disabled, with a service related disability (injured in the line of duty) to the extent that a physician or surgeon acceptable to the Board shall certify that such disability will permanently prevent said member from performing said member’s duties in the Department, the Association shall pay to such member the sum of the current pension amount for each year and fractions of a year that the member has served as an active member of the Department, without regard to minimum or partial vesting requirements. If a member who has received such a disability pension should subsequently recover and return to active duty in the Department, any amount paid to said member as a disability pension shall be deducted from said member’s service pension. Upon the death of any member of the Association who is in good standing at the time of said member’s death, the Association shall pay to the surviving spouse, if any, and if there is no surviving spouse, to child or children, if any, and if no child or children survive, to the estate of such deceased member, the credited sum of said member’s pension. C. Contributions Minnesota Statues Chapter 424A.093 specifies minimum support rates required on an annual basis. The significant actuarial assumptions used to compute the municipal support are the same as those used to compute the accrued pension liability. The association is comprised of volunteers; therefore, there are no payroll expenditures (i.e. there are no covered payroll percentage calculations). The minimum contribution from the City of Hopkins and state aid is determined as follows: Normal Cost for the Next Year + Amortization of Unfunded Actuarial Liability as Reported in the Latest Actuarial Valuation + Administrative Expenses for the Prior Year Multiplied by a Factor of 1.035 - Anticipated State Aid (Not to Exceed the Fire Aid Received in the Prior Year Multiplied by a Factor of 1.035) - Anticipated Contributions Required by the Association Bylaws from Active Members of the Association = Minimum Municipal Obligation The Plan is funded in part by fire state aid and, if necessary, City contributions. The State of Minnesota distributed to the City $99,843 in fire state aid and $4,000 in supplemental benefit reimbursements paid by the City to the Relief Association for the year ended December 31, 2015. Required employer contributions are calculated annually based on statutory provisions. The City’s statutorily-required contribution to the plan for the year ended December 31, 2015 was $32,166. 73 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 The City used December 31, 2015 amounts since December 31, 2016 were not available yet. D. Pension Costs At December 31, 2016, the City reported an asset of $451,603 for the Association’s net pension asset. The net pension asset was measured as of December 31, 2015, and the total pension liability used to calculate the net pension liability was determined by an actuarial valuation as of that date. As a result of its requirement to contribute to the Relief Association, the City reduced expense by $43,568 for the year ended December 31, 2016. At December 31, 2016, the City reported deferred outflows of resources and deferred inflows of resources from the following sources: Description Deferred Outflows of Resources Deferred Inflows of Resources Differences between expected and actual economic experience $ - $ - Changes of assumptions Net difference between projected and actual earnings on pension plan investments 345,441 - City contributions subsequent to the measurement date 32,166 - Total $ 377,607 $ - The City contributions to the Association subsequent to the measurement date of $32,166, reported as deferred outflows of resources, will be recognized as a reduction of the net pension liability in the year ended December 31, 2017. Other amounts reported as deferred outflows and inflows of resources related to the Association’s pension will be recognized in pension expense as follows: Year Ended December 31 Pension Expense Amount 2017 92,753 2018 92,753 2019 92,753 2020 67,182 2021 - Thereafter - 74 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 E. Actuarial Assumptions The actuarial total pension liability was determined as of December 31, 2015, using the following actuarial assumptions, applied to all periods included in the measurement: The long-term expected rate of return on pension plan investments was determined using a building-block method in which best-estimates of expected future real rates of return (expected returns, net of pension plan investment expense and inflation) are developed for each major asset class. These asset class estimates are combined to produce the portfolio long-term expected rate of return by weighting the expected future real rates of return by weighting the expected future real rates of return by the current asset allocation percentage (or target allocation, if available) and by adding expected inflation. The best-estimate of expected future real rates of return were developed by aggregating data from several published capital market assumption surveys and deriving a single best-estimate based on the average survey values. These capital market assumptions reflect both historical market experience as well as diverse views regarding anticipated future returns. The expected inflation assumption was developed based on an analysis of historical experience blended with forward-looking expectations available in market data. ASSUMPTIONS FROM ACTUARIAL REPORT Valuation Date 12/31/2015 Actuarial Cost Method Entry Age Normal Amortization Method Level Dollar Closed Actuarial Assumptions: Discount Rate 7.50% Investment Rate of Return 7.50% 20-Year Municipal Bond Yield 4.00% Age of Service Requirement Age 450 Mortality N/A Disabiliy None Withdrawal None Percent of Married None Age Difference N/A Form of Payment Lump Sum 75 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 Best estimates of geometric real and nominal rates of return for each major asset class included in the pension plan's asset allocation as of December 31, 2016 are summarized in the following table: Allocation at Long-Term December 31, Expected Expected Nominal Asset Class 2015 Portfolio Weight Rate of Return Cash 6.03% 6.00% 3.00% Fixed Income 5.70%23.00%5.25% Domestic Equity 88.27%54.00%8.50% International Equity 0.00%17.00%8.75% Total Portfolio 100.00%100.00%7.50% F. Discount Rate The discount rate used to measure the total pension liability was 7.50%. Assets were projected using expected benefit payments and expected asset returns. Expected benefit payments were discounted by year using expected assets return assumption for years in which the assets were sufficient to pay all benefit payments. Any remaining benefit payments after the trust fund is exhausted are discounted at the municipal bond rate of return. The equivalent single rate is the discount rate. Based on those assumptions, the pension plan's fiduciary net position was projected to be available to make all projected future benefit payments of current plan members. G. Pension Liability Sensitivity The following presents the City of Hopkins proportionate share of the net pension liability of the Association, calculated using the discount rate of 7.50%, as well as what the Association’s net pension liability would be if it were calculated using a discount rate that is one percentage point lower (6.50%) or one percentage point higher (8.50%) than the current rate: Selected Net Pension Liability (Asset) 1% Decrease Discount Rate 1% Increase Discount Rate $ -360,909 $ (451,603) $ (531,390) 6.5% 7.5% 8.5% H. Plan’s Fiduciary Net Position Detailed information about the Plan’s fiduciary’s net position is available in a separately-issued report. That report may be obtained by writing to the Hopkins Fire Relief Association, 1010 First St S, Hopkins, MN 55343. Information about the changes in the Plan's net pension liability (asset) is as follows: 76 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 12. OTHER POST EMPLOYMENT BENEFIT PLAN At December 31, 2008, the City adopted Governmental Accounting Standards Board (GASB) Statement No. 45, Accounting and Financial Reporting by Employers for Postemployment Benefits Other than Pensions. The City engaged an actuary to determine the City’s liability for postemployment healthcare benefits other than pensions as of January 1, 2016, for this single employer defined benefit OPEB plan. 1. Plan Description The City, a single-employer postemployment benefit plan, provides benefits for retirees as required by Minnesota Statute §471.61 subdivision 2b. Active employees, who were hired prior to July 1, 1993 and have been with the City for at least ten years and are either (1) age 60 years or older or (2) eligible for full PERA retirement benefits. Employees retiring by June 30, 2007 will receive full single health and life insurance coverage until age 65; employees retiring between July 1, 2007 and December 31, 2009 will receive $500 per month towards the cost of single health and life insurance until age 65; and employees retiring after December 31, 2009 will receive $15 per month times years of service (maximum of $500 per month) towards the cost of single health and life insurance until age 65. Currently 16 employees meet those eligibility requirements. As of December 31, 2016 there were approximately 91 active participants and 17 retired participants receiving benefits from the City’s health plans. 2015 2014 Total Pension Asset Service Cost 85,760$ 77,831$ Interest 157,795 139,957 Benefit Payments (134,745) (13,923) Net Change in Total Pension Liability 108,810 203,865 Total Pension Liability - Beginning 2,171,296 1,967,431 Total Pensaion Liability - Ending (a)2,280,106 2,171,296 Plan Fiduciary Net Position Municipal Contributions 32,166 32,166 State Contributions 103,843 94,308 Net Investment Inc ome (117,135) 77,066 Benefit Payments (134,745) (13,923) Administrative Expenses (11,783) (12,295) Net Change in Ficudicary Net Positon (127,654) 177,322 Fiduciary Net Position - Beginning 2,859,363 2,682,041 Ficudiary Net Position - Ending (b)2,731,709 2,859,363 Association's Net Pension Liability/(Asset) - Ending (a) - (b)(451,603)$ (688,067)$ Fiduciary Net Position as a Percentage of the Total Pension Liability 119.81% 131.69% Covered Employee Payroll N/A N/A Net Pension Liability/(Asset) as a Percentage of Covered Employee Payroll N/A N/A 77 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 2. Funding Policy The City funds its OPEB obligation on a pay as you go basis. For fiscal year 2016, the City contributed $216,7610 to the plan. The City's OPEB pension obligation is funded by the General and Enterprise Funds. 3. Annual OPEB Cost and Net OPEB Obligation The City’s annual other postemployment benefit (OPEB) cost (expense) is calculated based on the annual required contribution (ARC), an amount actuarially determined in accordance with the parameters of GASB Statement 45. The ARC represents a level of funding that, if paid on an ongoing basis, is projected to cover normal cost each year and amortize any un-funded actuarial liabilities over a period not to exceed thirty years. The following table shows the components of the City’s annual OPEB cost for the year, the amount actually paid from the plan, and changes in the City’s net OPEB obligation. Annual Required Contribution $ 162,039 Interest on Net OPEB Obligation 6,252 Adjustment to Annual Required Contribution (9,547) Annual OPEB Cost (Expense) 158,744 Contributions Made (216,761) Increase in Net OPEB Obligation (58,017) Net OPEB Obligation - Beginning of Year 178,639 Net OPEB Obligation - End of Year $ 120,622 The City’s annual OPEB cost, the percentage of the annual OPEB cost contributed to the plan, and the net OPEB obligation for 2016: Percentage Fiscal Annual of Annual Net Year OPEB OPEB Cost OPEB Ended Cost Contributed Obligation 12/31/2014 $ 200,416 103.2 % $ 222,653 12/31/2015 201,164 121.9 % 178,639 12/31/2016 158,744 136.5 % 120,622 4. Funded Status and Funding Progress As of January 1, 2016, the most recent actuarial valuation date, the City’s unfunded actuarial accrued liability (UAAL) was $1,534,346. The annual payroll for active employees covered by the plan in the actuarial valuation was $8,171,262 for a ratio of UAAL to covered payroll of 18.78%. Actuarial valuations of an ongoing plan involve estimates of the value of reported amounts and assumptions about the probability of occurrence of events far into the future. Examples include assumptions about future employment, mortality, and healthcare cost trends. Amounts determined regarding the funded status of the plan and the annual required contributions of the employer are subject to continual revision as actual results are compared with 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 multiyear trend information about whether the actuarial value of plan assets is increasing or decreasing over time relative to the actuarial accrued liabilities for benefits. 78 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 5. Actuarial Methods and Assumptions Projections of benefits for financial reporting purposes are based on the substantive plan (the plan as understood by the employer and plan members) and include the types of benefits provided at the time of each valuation and the historical pattern of sharing of benefit costs between the employer and plan members to that point. The actuarial methods and assumptions used include techniques that are 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. In the January 1, 2016 actuarial valuation, the projected unit credit actuarial cost method was used. The actuarial assumptions included a 3.5% investment rate of return (net of administrative expenses), which is a blended rate of the expected long-term investment returns on plan assets and on the employer’s own investments calculated based on the funded level of the plan at the valuation date. The initial healthcare trend rate was 6.75%, reduced by decrements to an ultimate rate of 5% after six years. Both rates include a 2.5% inflation assumption. The UAAL is being amortized over 30 years (2016 - 2047) as a level percentage of projected payrolls on an closed basis. 13. REHABILITATION LOANS RECEIVABLE The City makes rehabilitation loans to residential and commercial entities within the City. Residential loans are made for 20 year periods at 3% interest. A mortgage against the property improved is required and City staff is responsible to follow-up any delinquent accounts. Loan repayments are made to Matrix Financial Services, a loan service bureau, which charges a fee of $5.95 per month per loan. Principal and interest are forwarded to the City monthly with loan collection and loan status reports. Rehabilitation loan activity is a function of the Economic Development Fund, and the Hennepin County CDBG Funds. Loans become due in full upon sale of property. Rehabilitation loans receivable amounted to $ 36,083 at December 31, 2016 and are recorded in the Hennepin County CDBG non-major special revenue funds. 14. CLAIMS AND LITIGATION The City had the usual and customary types of miscellaneous claims pending at year-end, which are of a minor nature and usually all covered by insurance carried for that purpose. The City carries a $1,000,000 Public Official Liability Insurance policy with public entity and employee endorsement. 15. 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. The City participates in a public entity risk pool to mitigate its exposure to these risks. Workers compensation and property and liability coverage are provided through a pooled self-insurance plan with other cities. Settled claims have not exceeded insurance coverage in any of the past three fiscal years and no significant reductions in coverage from the prior year. The City pays an annual premium based on prior claims history for its workers compensation coverage. The public entity risk pool is responsible for the payment of all associated claims. The City has a $20,000 deductible per occurrence with a maximum per year out of pocket of $40,000, for its property and liability coverage. The public entity risk pool is responsible for all losses in excess of $20,000 per occurrence and all losses occurring after the $40,000 maximum City out of pocket costs. 79 City of Hopkins, Minnesota NOTES TO FINANCIAL STATEMENTS, (CONT.) December 31, 2016 16. TAX ABATEMENTS The City enters into property tax abatement agreements through the use of tax increment financing districts with local businesses under various Minnesota Statutes. Under these statutes the City annually abates taxes collected above the districts' base tax capacity which is established during adoption of the tax increment district. These agreements are established to foster economic development and redevelopment through creating jobs, removing blight and providing affordable housing. The City uses Minnesota Statutes 469.001 to 469.047 and 469.174 to 469.179 (The Tax Increment Act) to create these districts. For the year ended December 31, 2016, the City has five agreements established under Minnesota Statute 469.174 to 469.179 (The Tax Increment Act) which resulted in property taxes totaling $2,959,460 being abated. The following agreement exceeded 10 percent of the total amount abated.  A pay as you go note to convert substandard property into an office complex. The abatement amounted to $2,751,506. 17. SUBSEQUENT EVENT At the April 18, 2017 meeting, the City Council approved issuance and sale of $11,795,000 General Obligation Street Reconstruction Bonds, Series 2017A and $3,490,000 General Obligation Bonds, Series 2017B. Proceeds from the 2017A bonds will be used for the City’s 2017 road construction and 8th Avenue reconstruction projects and proceeds from the 2017B bonds will be used for Burnes Park improvements and various improvements utility needs. Both issuances were offered for sale on June 20, 2017. 80 REQUIRED SUPPLEMENTARY INFORMATION 81 City of Hopkins, Minnesota REQUIRED SUPPLEMENTARY INFORMATION December 31, 2016 1. OTHER POSTEMPLOYMENT BENEFITS PLAN Schedule of Funding Progress: Actuarial UAAL as a Actuarial Accrued Percentage Actuarial Value of Liability Unfunded Funded Covered of Covered Valuation Assets (AAL) AAL Ratio Payroll Payroll Date (a) (b) (b-a) (a/b) (c) ((b-a)/c) 01/01/07 $ - $ 2,297,909 $ 2,297,909 - $ 5,621,587 41 % 01/01/10 - 2,145,617 2,145,617 - 6,244,081 34 % 01/01/13 - 2,029,907 2,029,907 - 6,583,173 31 % 01/01/16 - 1,534,346 1,534,346 - 8,171,262 19 % 2. SCHEDULE OF PROPORTIONATE SHARE OF NET PENSION LIABILITY PUBLIC EMPLOYEES GENERAL EMPLOYEES RETIREMENT FUND Last Ten Years* PERA - General Employees Retirement Fund Fiscal Year Ending Employer's Proportionate (Percentage) of the Net Pension Employer's Proportionat e Share (Amount) of the Net Pension Liability (Asset) (a) State's Proportionate Share (Amount) of the Net Pension Liability Associated with the City of Hopkins (b) Employer's Proportionate Share of the Net Pension Liabiltiy and the State's Proportionate Share of the Net Pension Liability Associated with the City of Hopkins (a+b) Employer's Covered Payroll** (c) Employer's Proportionate Share of the Net Pension Liability (Asset) as a Percentage of its Covered Payroll Plan Fiduciary Net Position as a Percentage of the Total Pension Coverage June 30, 2015 0.0831% $ 4,306,673 $ - $ 4,306,673 $ 4,802,000 89.68% 78.20% June 30, 2016 0.0833% 6,763,547 88,334 6,851,881 5,015,680 134.85% 68.90% 82 City of Hopkins, Minnesota REQUIRED SUPPLEMENTARY INFORMATION December 31, 2016 PERA - Public Employees Police and Fire Fund Fiscal Year Ending Employer's Proportionate (Percentage) of the Net Pension Employer's Proportionate Share (Amount) of the Net Pension Liability (Asset) (a) Employer's Covered Payroll** (b) Employer's Proportionate Share of the Net Pension Liability (Asset) as a Percentage of its Covered Payroll Plan Fiduciary Net Position as a Percentage of the Total Pension Coverage June 30, 2015 0.2690% $ 3,056,469 $ 2,540,691 120.30% 86.60% June 30, 2016 0.2800% 11,236,887 2,744,827 409.38% 63.90% Notes to schedules * This schedule is provided prospectively beginning with the fiscal year ended December 31, 2015. ** For purposes of this schedule, covered payroll is defined as "pensionalbe wages". 3. SCHEDULES OF THE CITY'S CONTRIBUTIONS Last Ten Years* PERA - General Employees Retirement Fund Fiscal Year Ending Statutorily Required Contributions (a) Contributions in Relation to the Statutorily Required Contributions (b) Contribution Deficiency (Excess) (a-b) Covered Payroll ** (d) Contributions as a Percentage of Covered Payroll (b/d) December 31, 2015 $ 360,150 $(360,150) - $ 4,802,000 7.50% December 31, 2016 376,176 (376,176) - 5,015,680 7.50% PERA - Public Employees Police and Fire Fund Fiscal Year Ending Statutorily Required Contributions (a) Contributions in Relation to the Statutorily Required Contributions (b) Contribution Deficiency (Excess) (a-b) Covered Payroll ** (d) Contributions as a Percentage of Covered Payroll (b/d) December 31, 2015 $ 411,592 $(411,592) - $ 2,540,691 16.20% December 31, 2016 444,662 (444,662) - 2,744,827 16.20% Notes to schedules * This schedule is provided prospectively beginning with the fiscal year ended December 31, 2015. ** For purposes of this schedule, covered payroll is defined as "pensionalbe wages". 83 City of Hopkins, Minnesota REQUIRED SUPPLEMENTARY INFORMATION December 31, 2016 4. SCHEDULE OF THE CITY'S CONTRIBUTION TO THE HOPKINS FIRE RELIEF FUND Last Ten Years Fiscal Year Ending December 31 Statutorily Required Contributions (a) Contributions in Relation to the Statutorily Required Contributions (b) Contribution Deficiency (Excess) (a-b) 2016 $ 32,166 $ (32,166) $ - 2015 36,889 (36,889) - 2014 32,166 (32,166) - 2013 32,166 (32,166) - 2012 32,166 (32,166) - 2011 32,166 (32,166) - 2010 189,825 (189,825) - 2009 32,166 (32,166) - 2008 32,166 (32,166) - 2007 32,166 (32,166) - 84 City of Hopkins, Minnesota REQUIRED SUPPLEMENTARY INFORMATION December 31, 2016 5. SCHEDULE OF PROPORTIONATE SHARE OF NET PENSION LIABILITY – HOPKINS FIRE RELIEF  2015 2014 Total Pension Asset Service Cost 85,760$ 77,831$ Interest 157,795 139,957 Benefit Payments (134,745) (13,923) Net Change in Total Pension Liability 108,810 203,865 Total Pension Liability - Beginning 2,171,296 1,967,431 Total Pension Liability - Ending (a)2,280,106 2,171,296 Plan Fiduciary Net Position Municipal Contributions 32,166 32,166 State Contributions 103,843 94,308 Net Investment Income (117,135) 77,066 Benefit Payments (134,745) (13,923) Administrative Expenses (11,783) (12,295) Net Change in Fiduciary Net Position (127,654) 177,322 Fiduciary Net Position - Beginning 2,859,363 2,682,041 Fiduciary Net Position - Ending (b)2,731,709 2,859,363 Association's Net Pension Liability/(Asset) - Ending (a) - (b)(451,603)$ (688,067)$ Fiduciary Net Position as a Percentage of the Total Pension Liability 119.81%131.69% Covered-Employee Payroll N/A N/A Net Pension Liability/(Asset) as a Percentage of Covered-Employee Payroll N/A N/A 85 CITY OF HOPKINS, MINNESOTA NONMAJOR GOVERNMENTAL FUNDS STATEMENTS SPECIAL REVENUE FUNDS Special Revenue Funds are used to account for revenues derived from specific taxes or other earmarked revenue sources. Expenditures are restricted by law or administrative regulation for specified purposes. State Chemical Assessment Fund – This fund is entirely supported by state aid for the purpose of chemical assessment training and activity for the State of Minnesota. Hennepin County CDBG - This fund accounts for receipt for Community Development Block Grant funds and the issuance of loans and grants for housing rehabilitation. Parking Fund - This fund acquired land, improves and maintains parking lots and a parking ramp and collects monthly maintenance fees from users. Communications Fund - This fund records the City's share of a five-city joint venture cable TV franchise administered under the Southwest Suburban Cable Commission. Depot Coffee House Fund – This fund accounts for the operations of the coffee house business and the teen center operations that are supported through grant funds. Tax Increment Funds - These funds were established to record the use of tax increment receipts and bond proceeds as applied in various Tax Increment Districts. 5th Avenue Flats Fund - This fund was established to account for the project costs of the 5th Avenue Flats project. Originally shown as a tax increment fund the project changed scope and is no longer in a tax increment district. 86 DEBT SERVICE FUNDS Debt Service Funds are established to finance and account for the payment of interest and principal on all general obligation debt other than debt issued for and serviced by a governmental enterprise. Provisions are made in the City's general property tax levy for money sufficient to meet the general obligation debt. CAPITAL PROJECTS FUNDS Capital Projects Funds are established to account for the resources expended to acquire assets of a relatively permanent nature. (Special revenue and enterprise fund resources are not included in this category.) These funds evolve from the needs for special accounting for bond proceeds, grants and contributions for the acquisition of capital assets. Park Improvements Fund - This fund was established to record construction and improvement costs for park facilities. Capital Improvement Fund - This fund accounts for funds set aside for the construction and improvement of City facility and infrastructure. Municipal State Aid Fund - This fund is used to account for the City's allocation of the state collected highway user tax. This allocation is based on population and need for construction of designated state aid streets in the City. Street Improvement Franchise Fees Fund - This fund accounts for funds set aside for street improvements from the 2012 increase in gas and electric franchise fees. Funds will be used to decrease the annual debt levy for street improvement bonds. 87 City of Hopkins Combining Balance Sheet Nonmajor Governmental Funds December 31, 2016 Special Revenue Funds State Chemical Assessment Hennepin County CDBG Parking Communications Depot Coffee House Assets Cash and cash equivalents $- $- $ 310,544 $ 468,577 $917 Taxes receivable ----- Accounts receivable ---70,723 958 Rehabilitation loans receivable -36,083 --- Due from other governments 36,705 -1,835 -- Interest receivable --516 805 - Total Assets $36,705 $36,083 $312,895 $540,105 $1,875 Liabilities and Fund Balances Liabilities: Accounts payable $ 5,228 $- $ 94,423 $ 10,212 $ 5,191 Salaries payable 837 -888 1,819 3,791 Due to other funds 30,397 ---- Due to other governments --80 -1,189 Unearned revenue --67,643 -- Total Liabilities 36,462 -163,034 12,031 10,171 Fund balances: Restricted 243 36,083 --- Committed --149,861 528,074 - Unassigned ----(8,296) Total Fund Balances 243 36,083 149,861 528,074 (8,296) Total Liabilities and Fund Balances $36,705 $36,083 $312,895 $540,105 $1,875 88 City of Hopkins Combining Balance Sheet Nonmajor Governmental Funds December 31, 2016 Special Revenue Funds Tax Increment District Entertainment District Tax Increment District Sonoma Tax Increment District Oaks of Mainstreet 5th Ave Flats Tax Increment District Markeplace & Main Assets Cash and cash equivalents $ 220,810 $- $ 694,122 $- $ 57,188 Taxes receivable --2,152 -- Accounts receivable -4,521 --- Rehabilitation loans receivable ----- Due from other governments ----- Interest receivable 370 19 1,166 -96 Total Assets $221,180 $4,540 $697,440 $-$57,284 Liabilities and Fund Balances Liabilities: Accounts payable $- $- $ 134,323 $- $- Salaries payable ----- Due to other funds 197,367 107,688 -389,831 210,000 Due to other governments ----- Unearned revenue ----- Total Liabilities 197,367 107,688 134,323 389,831 210,000 Fund balances: Restricted 23,813 -563,117 -- Committed ----- Unassigned -(103,148)-(389,831) (152,716) Total Fund Balances 23,813 (103,148)563,117 (389,831)(152,716) Total Liabilities and Fund Balances $221,180 $4,540 $697,440 $-$57,284 89 City of Hopkins Combining Balance Sheet Nonmajor Governmental Funds December 31, 2016 Total Assets Cash and cash equivalents $ 1,752,158 Taxes receivable 2,152 Accounts receivable 76,202 Rehabilitation loans receivable 36,083 Due from other governments 38,540 Interest receivable 2,972 Total Assets $1,908,107 Liabilities and Fund Balances Liabilities: Accounts payable $ 249,377 Salaries payable 7,335 Due to other funds 935,283 Due to other governments 1,269 Unearned revenue 67,643 Total Liabilities 1,260,907 Fund balances: Restricted 623,256 Committed 677,935 Unassigned (653,991) Total Fund Balances 647,200 Total Liabilities and Fund Balances $1,908,107 90 City of Hopkins Combining Balance Sheet Nonmajor Governmental Funds December 31, 2016 Debt Service Funds Tax Increment Bonds of 1996C Refunding Bonds of 2005A Taxable Tax Increment Bonds of 1997 Refunding Bonds of 2005B Housing Improvement Bonds of 1999A Refunding Bonds of 2009B Housing Improvement Bonds of 1999B Refunding Bonds of 2009B Improvement Revolving Bonds of 2010A Assets Cash and cash equivalents $- $ 85,447 $ 385,601 $ 735,439 $ 230,020 Taxes receivable ----722 Special assessments receivable -189,694 443,349 788,099 387,260 Interest receivable -143 647 1,234 380 Total Assets $-$275,284 $829,597 $1,524,772 $618,382 Liabilities, Deferred Inflows of Resources and Fund Balances Liabilities: Total Liabilities $-$-$-$-$- Deferred inflows of resources: Taxes and special assessments -187,260 440,139 784,651 387,470 Total Deferred Inflows of Resources -187,260 440,139 784,651 387,470 Fund balances: Restricted -88,024 389,458 740,121 230,912 Total Fund Balances -88,024 389,458 740,121 230,912 Total Liabilities, Deferred Inflows of Resources and Fund Balances $-$275,284 $829,597 $1,524,772 $618,382 91 City of Hopkins Combining Balance Sheet Nonmajor Governmental Funds December 31, 2016 Debt Service Funds Tax Increment Bonds of 2002 Refunding Bonds of 2010B Capital Improvement Bonds of 2012A Equipment Certificates of 2012B Improvement Bonds of 2012B Improvement Bonds of 2013A Assets Cash and cash equivalents $ 254,493 $ 218,639 $ 57,738 $ 480,266 $ 345,089 Taxes receivable -1,996 1,048 763 180 Special assessments receivable ---564,376 361,503 Interest receivable 427 367 97 780 556 Total Assets $254,920 $221,002 $58,883 $1,046,185 $707,328 Liabilities, Deferred Inflows of Resources and Fund Balances Liabilities: Total Liabilities $-$-$-$-$- Deferred inflows of resources: Taxes and special assessments -1,415 470 564,693 361,386 Total Deferred Inflows of Resources -1,415 470 564,693 361,386 Fund balances: Restricted 254,920 219,587 58,413 481,492 345,942 Total Fund Balances 254,920 219,587 58,413 481,492 345,942 Total Liabilities, Deferred Inflows of Resources and Fund Balances $254,920 $221,002 $58,883 $1,046,185 $707,328 92 City of Hopkins Combining Balance Sheet Nonmajor Governmental Funds December 31, 2016 Debt Service Funds Improvement Bonds of 2014A Refunding Bonds of 2014B SROP Bonds of 2015A Tax Abatement Bonds of 2015B Tax Increment Revenue Bonds of 2015C Assets Cash and cash equivalents $ 200,950 $ 694,920 $ 318,613 $ 142,961 $ 484,872 Taxes receivable 649 8,159 1,396 11,031 - Special assessments receivable 80,656 12,928 65,834 -- Interest receivable 313 1,164 528 241 813 Total Assets $282,568 $717,171 $386,371 $154,233 $485,685 Liabilities, Deferred Inflows of Resources and Fund Balances Liabilities: Total Liabilities $-$-$-$-$- Deferred inflows of resources: Taxes and special assessments 80,914 18,819 66,056 10,506 - Total Deferred Inflows of Resources 80,914 18,819 66,056 10,506 - Fund balances: Restricted 201,654 698,352 320,315 143,727 485,685 Total Fund Balances 201,654 698,352 320,315 143,727 485,685 Total Liabilities, Deferred Inflows of Resources and Fund Balances $282,568 $717,171 $386,371 $154,233 $485,685 93 City of Hopkins Combining Balance Sheet Nonmajor Governmental Funds December 31, 2016 Debt Service Funds Improvement Bonds of 2016A Tax Abatement Bonds of 2016B G O Bonds of 2016C Total Assets Cash and cash equivalents $ 302,721 $ 17,361 $- $ 4,955,130 Taxes receivable ---25,944 Special assessments receivable --- 2,893,699 Interest receivable 94 29 -7,813 Total Assets $302,815 $17,390 $-$7,882,586 Liabilities, Deferred Inflows of Resources and Fund Balances Liabilities: Total Liabilities $-$-$-$- Deferred inflows of resources: Taxes and special assessments --- 2,903,779 Total Deferred Inflows of Resources ---2,903,779 Fund balances: Restricted 302,815 17,390 - 4,978,807 Total Fund Balances 302,815 17,390 -4,978,807 Total Liabilities, Deferred Inflows of Resources and Fund Balances $302,815 $17,390 $-$7,882,586 94 City of Hopkins Combining Balance Sheet Nonmajor Governmental Funds December 31, 2016 Capital Project Funds Park Improvements Capital Improvement Municipal State Aid Construction Fund Street Improvement Franchise Fees Total Assets Cash and cash equivalents $ 802,455 $- $- $- $ 802,455 Taxes receivable -1,880 --1,880 Accounts receivable 74,066 ---74,066 Interest receivable 1,391 ---1,391 Total Assets $877,912 $1,880 $-$-$879,792 Liabilities, Deferred Inflows of Resources and Fund Balances Liabilities: Accounts payable $ 117,012 $ 87,462 $ 72,889 $- $ 277,363 Total Liabilities 117,012 87,462 72,889 -277,363 Deferred inflows of resources: Due to other funds -159,016 125,960 -284,976 Due to other governments --55,026 -55,026 Taxes and special assessments -1,330 --1,330 Total Deferred Inflows of Resources -160,346 180,986 -341,332 Fund balances: Restricted 760,900 ---760,900 Unassigned - (245,928) (253,875)- (499,803) Total Fund Balances 760,900 (245,928)(253,875)-261,097 Total Liabilities, Deferred Inflows of Resources and Fund Balances $877,912 $1,880 $-$-$879,792 95 City of Hopkins Combining Balance Sheet Nonmajor Governmental Funds December 31, 2016 Special Revenue Debt Service Capital Projects Total Non-major Governmental Funds Assets Cash and cash equivalents $ 1,752,158 $ 4,955,130 $ 802,455 $ 7,509,743 Taxes receivable 2,152 25,944 1,880 29,976 Special assessments receivable - 2,893,699 - 2,893,699 Accounts receivable 76,202 -74,066 150,268 Rehabilitation loans receivable 36,083 --36,083 Due from other governments 38,540 --38,540 Interest receivable 2,972 7,813 1,391 12,176 Total Assets $1,908,107 $7,882,586 $879,792 $10,670,485 Liabilities, Deferred Inflows of Resources and Fund Balances Liabilities: Accounts payable $ 249,377 $- $ 277,363 $ 526,740 Salaries payable 7,335 --7,335 Due to other funds 935,283 - 284,976 1,220,259 Due to other governments 1,269 -55,026 56,295 Unearned revenue 67,643 --67,643 Total Liabilities 1,260,907 -617,365 1,878,272 Deferred inflows of resources: Taxes and special assessments - 2,903,779 1,330 2,905,109 Total Deferred Inflows of Resources -2,903,779 1,330 2,905,109 Fund balances: Restricted 623,256 4,978,807 760,900 6,362,963 Committed 677,935 -- 677,935 Unassigned (653,991)- (499,803) (1,153,794) Total Fund Balances 647,200 4,978,807 261,097 5,887,104 Total Liabilities, Deferred Inflows of Resources and Fund Balances $1,908,107 $7,882,586 $879,792 $10,670,485 96 City of Hopkins Combining Statement of Revenues, Expenditures and Changes in Fund Balances Nonmajor Governmental Funds For the Year Ended December 31, 2016 Special Revenue Funds State Chemical Assessment Hennepin County CDBG Parking Communications Depot Coffee House Revenues Tax increments $- $- $- $- $- Intergovernmental 90,780 ---15,000 Charges for services --113,546 12,494 75,590 Fines --21,876 -- Investment earnings --1,474 3,685 - Other miscellaneous revenues 7,681 --273,105 269,482 Total Revenues 98,461 -136,896 289,284 360,072 Expenditures Current: General government ---207,241 - Public safety 96,300 -69,144 -- Highways and streets --24,158 -- Urban redevelopment and housing -7,810 --- Culture and recreation ----383,656 Debt service: Interest and fiscal fees ----- Capital Outlay --400,477 -- Total Expenditures 96,300 7,810 493,779 207,241 383,656 Excess (deficiency) of revenues over expenditures 2,161 (7,810)(356,883)82,043 (23,584) Other Financing Sources (Uses) Transfer in --443,000 -26,000 Transfer out ---(86,920)- Total Other Financing Sources (Uses)--443,000 (86,920)26,000 Net change in fund balances 2,161 (7,810)86,117 (4,877)2,416 Fund balance (deficit) - January 1 (1,918)43,893 63,744 532,951 (10,712) Fund balance (deficit) - December 31 $243 $36,083 $149,861 $528,074 $(8,296) 97 City of Hopkins Combining Statement of Revenues, Expenditures and Changes in Fund Balances Nonmajor Governmental Funds For the Year Ended December 31, 2016 Special Revenue Funds Tax Increment District Entertainment District Tax Increment District Sonoma Tax Increment District Oaks of Mainstreet 5th Ave Flats Tax Increment District Marketplace & Main Revenues Tax increments $ 58,172 $ 14,504 $ 2,152 $- $ 133,125 Intergovernmental ----- Charges for services ----- Fines ----- Investment earnings 1,341 -3,652 -- Other miscellaneous revenues -4,520 --- Total Revenues 59,513 19,024 5,804 -133,125 Expenditures Current: General government ----- Public safety ----- Highways and streets ----- Urban redevelopment and housing 3,462 2,884 3,815 2,884 67,336 Culture and recreation ----- Debt service: Interest and fiscal fees 10,236 5,534 --120 Capital Outlay ----- Total Expenditures 13,698 8,418 3,815 2,884 67,456 Excess (deficiency) of revenues over expenditures 45,815 10,606 1,989 (2,884)65,669 Other Financing Sources (Uses) Transfer in -24,108 --- Transfer out --(743)-- Total Other Financing Sources (Uses)-24,108 (743)-- Net change in fund balances 45,815 34,714 1,246 (2,884)65,669 Fund balance (deficit) - January 1 (22,002) (137,862)561,871 (386,947) (218,385) Fund balance (deficit) - December 31 $23,813 $(103,148)$563,117 $(389,831)$(152,716) 98 City of Hopkins Combining Statement of Revenues, Expenditures and Changes in Fund Balances Nonmajor Governmental Funds For the Year Ended December 31, 2016 Total Revenues Tax increments $ 207,953 Intergovernmental 105,780 Charges for services 201,630 Fines 21,876 Investment earnings 10,152 Other miscellaneous revenues 554,788 Total Revenues 1,102,179 Expenditures Current: General government 207,241 Public safety 165,444 Highways and streets 24,158 Urban redevelopment and housing 88,191 Culture and recreation 383,656 Debt service: Interest and fiscal fees 15,890 Capital Outlay 400,477 Total Expenditures 1,285,057 Excess (deficiency) of revenues over expenditures (182,878) Other Financing Sources (Uses) Transfer in 493,108 Transfer out (87,663) Total Other Financing Sources (Uses)405,445 Net change in fund balances 222,567 Fund balance (deficit) - January 1 424,633 Fund balance (deficit) - December 31 $647,200 99 City of Hopkins Combining Statement of Revenues, Expenditures and Changes in Fund Balances Nonmajor Governmental Funds For the Year Ended December 31, 2016 Debt Service Funds Tax Increment Bonds of 1996C Refunding Bonds of 2005A Taxable Tax Increment Bonds of 1997 Refunding Bonds of 2005B Housing Improvement Bonds of 1999A Refunding Bonds of 2009B Housing Improvement Bonds of 1999B Refunding Bonds of 2009B Improvement Revolving Bonds of 2010A Revenues Property taxes $- $- $- $- $ 78,643 Special assessments - 171,915 139,831 251,514 66,218 Investment earnings 232 -1,747 3,442 67 Total Revenues 232 171,915 141,578 254,956 144,928 Expenditures Current: General government 657 156,089 935 1,065 657 Debt Service: Principal retirement 110,000 415,000 95,000 165,000 175,000 Interest and fiscal fees 2,063 9,598 24,292 43,492 51,708 Total Expenditures 112,720 580,687 120,227 209,557 227,365 Excess (deficiency) of revenues over expenditures (112,488)(408,772)21,351 45,399 (82,437) Other Financing Sources (Uses) Improvement bonds issued ----- Premium on improvement bonds ----- Transfer in 743 ---64,180 Transfer out ----- Total Other Financing Sources (Uses)743 ---64,180 Net change in fund balances (111,745)(408,772)21,351 45,399 (18,257) Fund balance (deficit) - January 1 111,745 496,796 368,107 694,722 249,169 Fund balance (deficit) - December 31 $-$88,024 $389,458 $740,121 $230,912 100 City of Hopkins Combining Statement of Revenues, Expenditures and Changes in Fund Balances Nonmajor Governmental Funds For the Year Ended December 31, 2016 Debt Service Funds Tax Increment Bonds of 2002 Refunding Bonds of 2010B Capital Improvement Bonds of 2012A Equipment Certificates of 2012B Improvement Bonds of 2012B Improvement Bonds of 2013A Revenues Property taxes $- $ 217,982 $ 141,474 $ 95,882 $ (353) Special assessments --- 102,096 63,167 Investment earnings 367 --1,871 1,906 Total Revenues 367 217,982 141,474 199,849 64,720 Expenditures Current: General government 2,630 657 946 1,850 657 Debt Service: Principal retirement 150,000 175,000 80,000 195,000 115,000 Interest and fiscal fees 29,424 17,624 11,031 57,044 37,050 Total Expenditures 182,054 193,281 91,977 253,894 152,707 Excess (deficiency) of revenues over expenditures (181,687)24,701 49,497 (54,045)(87,987) Other Financing Sources (Uses) Improvement bonds issued ----- Premium on improvement bonds ----- Transfer in 188,000 ---- Transfer out ----- Total Other Financing Sources (Uses)188,000 ---- Net change in fund balances 6,313 24,701 49,497 (54,045)(87,987) Fund balance (deficit) - January 1 248,607 194,886 8,916 535,537 433,929 Fund balance (deficit) - December 31 $254,920 $219,587 $58,413 $481,492 $345,942 101 City of Hopkins Combining Statement of Revenues, Expenditures and Changes in Fund Balances Nonmajor Governmental Funds For the Year Ended December 31, 2016 Debt Service Funds Improvement Bonds of 2014A Refunding Bonds of 2014B SROP Bonds of 2015A Tax Abatement Bonds of 2015B Tax Increment Revenue Bonds of 2015C Revenues Property taxes $ 87,419 $ 874,005 $ 263,901 $ 118,981 $- Special assessments 26,935 32,104 17,356 -- Investment earnings 563 -440 105 1,832 Total Revenues 114,917 906,109 281,697 119,086 1,832 Expenditures Current: General government 657 3,657 657 657 - Debt Service: Principal retirement 110,000 855,000 -- 165,000 Interest and fiscal fees 50,618 135,618 110,653 89,047 67,905 Total Expenditures 161,275 994,275 111,310 89,704 232,905 Excess (deficiency) of revenues over expenditures (46,358)(88,166)170,387 29,382 (231,073) Other Financing Sources (Uses) Improvement bonds issued ----- Premium on improvement bonds ----- Transfer in 55,934 145,000 68,412 63,750 235,000 Transfer out ----- Total Other Financing Sources (Uses)55,934 145,000 68,412 63,750 235,000 Net change in fund balances 9,576 56,834 238,799 93,132 3,927 Fund balance (deficit) - January 1 192,078 641,518 81,516 50,595 481,758 Fund balance (deficit) - December 31 $201,654 $698,352 $320,315 $143,727 $485,685 102 City of Hopkins Combining Statement of Revenues, Expenditures and Changes in Fund Balances Nonmajor Governmental Funds For the Year Ended December 31, 2016 Debt Service Funds Improvement Bonds of 2016A Tax Abatement Bonds of 2016B G O Bonds of 2016C Total Revenues Property taxes $- $- $- $ 1,877,934 Special assessments 255,315 -- 1,126,451 Investment earnings 105 36 -12,713 Total Revenues 255,420 36 -3,017,098 Expenditures Current: General government 79,237 51,500 59,457 361,965 Debt Service: Principal retirement --- 2,805,000 Interest and fiscal fees 354 133 - 737,654 Total Expenditures 79,591 51,633 59,457 3,904,619 Excess (deficiency) of revenues over expenditures 175,829 (51,597)(59,457)(887,521) Other Financing Sources (Uses) Improvement bonds issued 4,335,000 1,630,000 2,805,000 8,770,000 Premium on improvement bonds 133,857 36,060 81,376 251,293 Transfer in --- 821,019 Transfer out (4,341,871) (1,597,073) (2,826,919) (8,765,863) Total Other Financing Sources (Uses)126,986 68,987 59,457 1,076,449 Net change in fund balances 302,815 17,390 -188,928 Fund balance (deficit) - January 1 --- 4,789,879 Fund balance (deficit) - December 31 $302,815 $17,390 $-$4,978,807 103 City of Hopkins Combining Statement of Revenues, Expenditures and Changes in Fund Balances Nonmajor Governmental Funds For the Year Ended December 31, 2016 Capital Projects Funds Park Improvements Capital Improvement Municipal State Aid Construction Fund Street Improvement Franchise Fees Total Revenues Property taxes $- $ 122,409 $- $- $ 122,409 Intergovernmental 280,000 -707,492 -987,492 Investment earnings 4,886 187 (6,578)2,172 667 Other miscellaneous revenues 371,909 3,371 --375,280 Total Revenues 656,795 125,967 700,914 2,172 1,485,848 Expenditures Current: General government -27,406 --27,406 Public safety -17,935 --17,935 Highways and streets 12,423 - 1,079,435 - 1,091,858 Culture and recreation -78,189 --78,189 Capital outlay 1,605,234 840,986 297,589 - 2,743,809 Total Expenditures 1,617,657 964,516 1,377,024 -3,959,197 Excess (deficiency) of revenues over expenditures (960,862)(838,549)(676,110)2,172 (2,473,349) Other Financing Sources (Uses) Transfer in 1,473,215 525,000 -- 1,998,215 Transfer out (10,000)-- (319,142) (329,142) Total Other Financing Sources (Uses)1,463,215 525,000 -(319,142)1,669,073 Net change in fund balances 502,353 (313,549)(676,110)(316,970)(804,276) Fund balance (deficit) - January 1 258,547 67,621 422,235 316,970 1,065,373 Fund balance (deficit) - December 31 $760,900 $(245,928)$(253,875)$-$261,097 104 City of Hopkins Statement of Revenues, Expenditures and Changes in Fund Balances Nonmajor Governmental Funds For the Year Ended December 31, 2016 Special Revenue Debt Service Capital Projects Total Nonmajor Governmental Funds Revenues Property taxes $- $ 1,877,934 $ 122,409 $ 2,000,343 Tax increments 207,953 --207,953 Special assessments - 1,126,451 - 1,126,451 Intergovernmental 105,780 -987,492 1,093,272 Charges for services 201,630 --201,630 Fines 21,876 --21,876 Investment earnings 10,152 12,713 667 23,532 Other miscellaneous revenues 554,788 -375,280 930,068 Total Revenues 1,102,179 3,017,098 1,485,848 5,605,125 Expenditures Current: General government 207,241 361,965 27,406 596,612 Public safety 165,444 -17,935 183,379 Highways and streets 24,158 - 1,091,858 1,116,016 Urban redevelopment and housing 88,191 --88,191 Culture and recreation 383,656 -78,189 461,845 Debt service: Principal retirement - 2,805,000 - 2,805,000 Interest and fiscal fees 15,890 737,654 -753,544 Capital outlay 400,477 - 2,743,809 3,144,286 Total Expenditures 1,285,057 3,904,619 3,959,197 9,148,873 Excess (deficiency) of revenues over expenditures (182,878)(887,521)(2,473,349)(3,543,748) Other Financing Sources (Uses) Improvement bonds issued - 8,770,000 - 8,770,000 Premium on improvement bonds -251,293 -251,293 Transfer in 493,108 821,019 1,998,215 3,312,342 Transfer out (87,663) (8,765,863)(329,142) (9,182,668) Total Other Financing Sources (Uses)405,445 1,076,449 1,669,073 3,150,967 Net change in fund balances 222,567 188,928 (804,276)(392,781) Fund balance (deficit) - January 31 424,633 4,789,879 1,065,373 6,279,885 Fund balance (deficit) - December 31 $647,200 $4,978,807 $261,097 $5,887,104 105 City of Hopkins Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual Nonmajor Special Revenue Funds State Chemical Assessment For the Year Ended December 31, 2016 Original Budget Final Approved Budget Actual Variance with Final Budget Over/Under Revenues Intergovernmental $ 60,000 $ 60,000 $ 90,780 $ 30,780 Other miscellaneous revenues --7,681 7,681 Total Revenues 60,000 60,000 98,461 38,461 Expenditures Current: Public safety 60,000 60,000 96,300 (36,300) Total Expenditures 60,000 60,000 96,300 (36,300) Net change in fund balance $-$-2,161 $2,161 Fund balance (deficit) - January 1 (1,918) Fund balance (deficit) - December 31 $243 106 City of Hopkins Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual Nonmajor Special Revenue Funds Parking For the Year Ended December 31, 2016 Original Budget Final Approved Budget Actual Variance with Final Budget Over/Under Revenues Charges for services $ 115,000 $ 115,000 $ 113,546 $ (1,454) Fines 22,000 22,000 21,876 (124) Investment earnings --1,474 1,474 Total Revenues 137,000 137,000 136,896 (104) Expenditures Current: Public safety 75,193 75,193 69,144 6,049 Highways and streets 34,407 34,407 24,158 10,249 Capital Outlay 250,000 250,000 400,477 (150,477) Total Expenditures 359,600 359,600 493,779 (134,179) Excess (deficiency) of revenues over expenditures (222,600)(222,600)(356,883)(134,283) Other Financing Sources (Uses) Transfer in --443,000 443,000 Total Other Financing Sources (Uses)--443,000 443,000 Net change in fund balance $(222,600)$(222,600)86,117 $308,717 Fund balance (deficit) - January 1 63,744 Fund balance (deficit) - December 31 $ 149,861 107 City of Hopkins Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual Nonmajor Special Revenue Funds Communications For the Year Ended December 31, 2016 Original Budget Final Approved Budget Actual Variance with Final Budget Over/Under Revenues Charges for services $- $- $ 12,494 $ 12,494 Investment earnings --3,685 3,685 Other miscellaneous revenues 255,000 255,000 273,105 18,105 Total Revenues 255,000 255,000 289,284 34,284 Expenditures Current: General government 124,353 124,353 207,241 (82,888) Capital Outlay 12,500 12,500 -12,500 Total Expenditures 136,853 136,853 207,241 (70,388) Excess (deficiency) of revenues over expenditures 118,147 118,147 82,043 (36,104) Other Financing Sources (Uses) Transfer out (86,920)(86,920)(86,920)- Total Other Financing Sources (Uses)(86,920)(86,920)(86,920)- Net change in fund balance $31,227 $31,227 (4,877)$(36,104) Fund balance (deficit) - January 1 532,951 Fund balance (deficit) - December 31 $ 528,074 108 City of Hopkins Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual Nonmajor Special Revenue Funds Depot Coffee House For the Year Ended December 31, 2016 Original Budget Final Approved Budget Actual Variance with Final Budget Over/Under Revenues Intergovernmental $ 15,000 $ 15,000 $ 15,000 $- Charges for services 68,000 68,000 75,590 7,590 Other miscellaneous revenues 251,100 251,100 269,482 18,382 Total Revenues 334,100 334,100 360,072 25,972 Expenditures Current: Culture and recreation 338,142 338,142 383,656 (45,514) Total Expenditures 338,142 338,142 383,656 (45,514) Excess (deficiency) of revenues over expenditures (4,042)(4,042)(23,584)(19,542) Other Financing Sources (Uses) Transfer in 15,000 15,000 26,000 11,000 Total Other Financing Sources (Uses)15,000 15,000 26,000 11,000 Net change in fund balance $10,958 $10,958 2,416 $(8,542) Fund balance (deficit) - January 1 (10,712) Fund balance (deficit) - December 31 $ (8,296) 109 City of Hopkins Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual Nonmajor Special Revenue Funds Tax Increment District Entertainment District For the Year Ended December 31, 2016 Original Budget Final Approved Budget Actual Variance with Final Budget Over/Under Revenues Tax increments $ 58,000 $ 58,000 $ 58,172 $172 Investment earnings --1,341 1,341 Total Revenues 58,000 58,000 59,513 1,513 Expenditures Current: Urban redevelopment and housing 3,000 3,000 3,462 (462) Debt Service: Interest and fiscal fees 10,236 10,236 10,236 - Total Expenditures 13,236 13,236 13,698 (462) Net change in fund balance $44,764 $44,764 45,815 $1,051 Fund balance (deficit) - January 1 (22,002) Fund balance (deficit) - December 31 $ 23,813 110 City of Hopkins Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual Nonmajor Special Revenue Funds Tax Increment District Sonoma For the Year Ended December 31, 2016 Original Budget Final Approved Budget Actual Variance with Final Budget Over/Under Revenues Tax increments $ 12,000 $ 12,000 $ 14,504 $ 2,504 Other miscellaneous revenues 7,024 7,024 4,520 (2,504) Total Revenues 19,024 19,024 19,024 - Expenditures Urban redevelopment and housing 2,050 2,050 2,884 (834) Debt service: Interest and fiscal fees 5,518 5,518 5,534 (16) Total Expenditures 7,568 7,568 8,418 (850) Excess (deficiency) of revenues over expenditures 11,456 11,456 10,606 (850) Other Financing Sources (Uses) Transfer in 23,318 23,318 24,108 790 Total Other Financing Sources (Uses)23,318 23,318 24,108 790 Net change in fund balance $34,774 $34,774 34,714 $(60) Fund balance (deficit) - January 1 (137,862) Fund balance (deficit) - December 31 $ (103,148) 111 City of Hopkins Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual Nonmajor Special Revenue Funds Tax Increment District Oaks of Mainstreet For the Year Ended December 31, 2016 Original Budget Final Approved Budget Actual Variance with Final Budget Over/Under Revenues Tax increments $ 120,000 $ 120,000 $ 2,152 $ (117,848) Investment earnings --3,652 3,652 Total Revenues 120,000 120,000 5,804 (114,196) Expenditures Current: Urban redevelopment and housing 3,200 3,200 3,815 (615) Total Expenditures 3,200 3,200 3,815 (615) Excess (deficiency) of revenues over expenditures 116,800 116,800 1,989 (114,811) Other Financing Sources (Uses) Transfer out --(743)(743) Total Other Financing Sources (Uses)--(743)(743) Net change in fund balance $116,800 $116,800 1,246 $(115,554) Fund balance (deficit) - January 1 561,871 Fund balance (deficit) - December 31 $ 563,117 112 City of Hopkins Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual Nonmajor Special Revenue Funds 5th Ave Flats For the Year Ended December 31, 2016 Original Budget Final Approved Budget Actual Variance with Final Budget Over/Under Expenditures Urban redevelopment and housing $ 2,000 $ 2,000 $ 2,884 $(884) Debt service: Total Expenditures 2,000 2,000 2,884 (884) Net change in fund balance $(2,000)$(2,000)(2,884)$(884) Fund balance (deficit) - January 1 (386,947) Fund balance (deficit) - December 31 $ (389,831) 113 City of Hopkins Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual Nonmajor Special Revenue Funds Tax Increment District Marketplace & Main For the Year Ended December 31, 2016 Original Budget Final Approved Budget Actual Variance with Final Budget Over/Under Revenues Tax increments $ 122,000 $ 122,000 $ 133,125 $ 11,125 Total Revenues 122,000 122,000 133,125 11,125 Expenditures Current: Urban redevelopment and housing 120,950 120,950 67,336 53,614 Debt service: Interest and fiscal fees --120 (120) Total Expenditures 120,950 120,950 67,456 53,494 Net change in fund balance $1,050 $1,050 65,669 $64,619 Fund balance (deficit) - January 1 (218,385) Fund balance (deficit) - December 31 $ (152,716) 114 CITY OF HOPKINS, MINNESOTA NONMAJOR PROPRIETARY FUNDS Enterprise Funds are established to account for the financing of self-supporting activities of governmental units, which render services to the general public on a user charge basis. Records are maintained on the accrual basis of accounting. The Authority for these types of funds is derived from Section 11.01 of the City Charter, which allows for utility or other public service enterprise funds. The City has six Enterprise Funds, three of which are considered to be nonmajor, they are: Refuse Utility Fund – This fund accounts for the operations of the city owned refuse service. Pavilion/Ice Arena – This fund accounts for the operations of the city owned ice arena. Housing Authority Fund – This fund accounts for the operations of the city owned federally subsidized apartment building. 115 City of Hopkins Combining Statement of Net Position Nonmajor Enterprise Funds December 31, 2016 Nonmajor Business-type Activities-Enterprise Funds Refuse Utility Pavilion Housing Authority Total Assets Current assets: Cash and cash equivalents $ 955,625 $ 43,942 $ 848,972 $ 1,848,539 Taxes receivable -832 -832 Accounts receivable 55,890 -347 56,237 Accrued interest receivable 1,587 59 -1,646 Due from other governments --89,119 89,119 Total current assets 1,013,102 44,833 938,438 1,996,373 Noncurrent assets: Capital assets, nondepreciable: Land -- 208,252 208,252 Construction in progress -- 624,402 624,402 Capital assets, depreciable: Building and structures 302,727 3,272,851 4,633,902 8,209,480 Distribution system - 125,614 - 125,614 Machinery and equipment 870,398 291,271 52,719 1,214,388 Less accumulated depreciation (666,545) (1,552,144) (3,612,053) (5,830,742) Total noncurrent assets 506,580 2,137,592 1,907,222 4,551,394 Total Assets 1,519,682 2,182,425 2,845,660 6,547,767 Deferred outflows of resources: Pensions 124,188 121,897 - 246,085 Total Deferred Outflows of Resources 124,188 121,897 -246,085 Liabilities Current liablilities: Accounts payable 15,911 8,496 47,748 72,155 Salaries payable 4,498 4,692 -9,190 Due to other funds -- 448,938 448,938 Due to other governments 14,292 564 -14,856 Compensated absences 5,809 23,208 24,880 53,897 Unearned revenue -546 -546 Accrued interest payable -998 -998 Revenue bonds - current -20,000 -20,000 Total current liabilities 40,510 58,504 521,566 620,580 Noncurrent liabilities: Compensated absences 15,610 --15,610 Net OPEB liability --14,290 14,290 Net pension liability 282,964 277,744 - 560,708 Revenue bonds payable (net of unamortized discounts)- 101,528 - 101,528 Total noncurrent liabilities 298,574 379,272 14,290 692,136 Total Liabilities 339,084 437,776 535,856 1,312,716 Deferred inflows of resources: Pensions 28,686 28,157 -56,843 Total Deferred Inflows of Resources 28,686 28,157 -56,843 Net Position Net investment in capital assets 506,580 2,016,064 1,907,222 4,429,866 Unrestricted 769,520 (177,675) 402,582 994,427 Total Net Position $1,276,100 $1,838,389 $2,309,804 $5,424,293 116 City of Hopkins Combining Statement of Revenues, Expenses and Changes in Net Position Nonmajor Enterprise Activities For the Year Ended December 31, 2016 Nonmajor Business-type Activities-Enterprise Funds Refuse Utility Pavilion Housing Authority Nonmajor Enterprise Funds Total Operating revenues Charges for services $ 962,572 $ 349,840 $ 266,174 $ 1,578,586 Other 13,919 5,600 15,951 35,470 Total operating revenues 976,491 355,440 282,125 1,614,056 Operating expenses Cost of sales and services 687,357 391,711 84,178 1,163,246 Administration 105,894 7,876 353,864 467,634 Depreciation 74,572 81,291 178,611 334,474 Total operating expenses 867,823 480,878 616,653 1,965,354 Operating income (loss)108,668 (125,438)(334,528)(351,298) Nonoperating revenues (expenses) Property taxes -63,519 -63,519 Investment earnings 6,055 555 -6,610 Interest/fiscal agent expense -(2,157)-(2,157) Intergovernmental grants 27,070 -184,877 211,947 Total nonoperating revenues (expenses)33,125 61,917 184,877 279,919 Income (loss) before contributions and transfers 141,793 (63,521)(149,651)(71,379) Capital contributions Building improvements --702,555 702,555 Transfers (125,000)--(125,000) Change in net position 16,793 (63,521)552,904 506,176 Net position - January 1 1,259,307 1,901,910 1,756,900 4,918,117 Net position - December 31 $1,276,100 $1,838,389 $2,309,804 $5,424,293 117 City of Hopkins Combining Statement of Cash Flows Nonmajor Enterprise Funds For the Year Ended December 31, 2016 Nonmajor Business-type Activities-Enterprise Funds Nonmajor Refuse Pavilion/Housing Enterprise Funds Utility Ice Arena Authority Total Cash Flows from Operating Activities Receipts from customers and users $ 955,743 $ 397,354 $ 212,356 $ 1,565,453 Receipts from interfund services provided - - 409,530 409,530 Payments to suppliers (391,788) (125,849) (324,020) (841,657) Payments to employees (275,996) (243,646) (83,742) (603,384) Payments for interfund services used (105,894) (7,876) - (113,770) Net cash used by operating activities 182,065 19,983 214,124 416,172 Cash Flows from Noncapital Financing Activities Intergovernmental grants 27,070 - 887,432 914,502 Taxes - 63,519 - 63,519 Transfers (to) from other funds (125,000) - - (125,000) Net cash provided (used) by noncapital and related financing activities (97,930) 63,519 887,432 853,021 Cash Flows from Capital and Related Financing Activities: Construction of capital assets - (37,875) (681,685) (719,560) Interest and other payments - (2,624) - (2,624) Bond payments - (20,000) - (20,000) Net cash provided (used) by capital and related financing activities - (60,499) (681,685) (742,184) Cash Flows From Investing Activities Interest received 8,928 496 - 9,424 Net increase (decrease) in cash and cash equivalents 93,063 23,499 419,871 536,433 Cash and cash equivalents - January 1 (89,998) (23,358) 429,101 315,745 Cash and cash equivalents - December 31 $ 3,065 $ 141 $ 848,972 $ 852,178 Reconciliation of Cash and Cash Equivalents at End of Year to Cash and Investments per Statement of Net Position Ending cash and cash equivalents per cash flow statement $ 3,065 $ 141 $ 848,972 $ 852,178 Investments 952,560 43,801 - 996,361 Cash and Investments per Statement of Net Position $ 955,625 $ 43,942 $ 848,972 $ 1,848,539 Reconciliation of operating loss to net cash used by operating activities: Operating income (loss) 108,668 (125,438) (334,528) (351,298) Adjustments to reconcile operating loss to net cash used by operating activities: Depreciation expense 74,572 81,291 178,611 334,474 (Increase) decrease in: Accounts receivable (20,748) 48,560 (69,769) (41,957) Prepaid expense - 68 15,538 15,606 Pensions (deferred outflows) (101,066) (99,781) - (200,847) Increase (decrease) in: Accounts, compensated absences and accrued interest payable (8,020) (1,470) 14,742 5,252 Due to other funds - - 409,530 409,530 Due to other governments 6,322 (2,385) - 3,937 Unearned revenue - (6,646) - (6,646) Net pension 110,437 113,683 - 224,120 Pension (deferred inflows) 11,900 12,101 - 24,001 Net cash used by operating activities $ 182,065 $ 19,983 $ 214,124 - 416,172 118 CITY OF HOPKINS, MINNESOTA INTERNAL SERVICE FUNDS Internal Service Funds are used to account for the financing of goods or services provided by one department to other departments of the government, on a cost reimbursement basis. Revenues and expenses are recognized on the accrual basis. Revenues are recognized in the accounting period in which they are earned and become objectively measurable; expenses are recognized in the period incurred, if objectively measurable. Equipment Replacement Fund – This fund accounts for the acquisition of machinery and equipment. User charges are billed to the various City departments. Insurance Risk Fund – This fund accounts for the dividends and deductibles relating to property and casualty insurance coverage. Deductibles are paid from past dividends. Users are charged only if the fund has a shortfall. Employee Benefits Fund – This fund accounts for accrued employee benefits within the governmental funds. User charges are billed to the various departments. 119 City of Hopkins Combining Statement of Net Position Internal Service Funds December 31, 2016 Equipment Replacement Employee Benefits Insurance Risk Total Assets Current assets: Cash and cash equivalents 1,185,943 947,219 298,916 2,432,078 Accrued interest receivable 1,919 1,634 438 3,991 Total current assets 1,187,862 948,853 299,354 2,436,069 Property and equipment: Machinery and equipment 8,519,906 -- 8,519,906 Less accumulated depreciation (4,742,809)-- (4,742,809) Net property and equipment 3,777,097 --3,777,097 Total Assets 4,964,959 948,853 299,354 6,213,166 Liabilities Current liabilities: Accounts payable 14,067 --14,067 Compensated absences -778,155 -778,155 Accrued interest payable 934 --934 Capital lease - current 24,616 --24,616 Total current liabilities 39,617 778,155 -817,772 Noncurrent liabilities: Capital lease payable 77,512 --77,512 Total noncurrent liabilities 77,512 --77,512 Total Liabilities 117,129 778,155 -895,284 Net Position Net investment in capital assets 3,674,969 -- 3,674,969 Unrestricted 1,172,861 170,698 299,354 1,642,913 Total Net Position $4,847,830 $170,698 $299,354 $5,317,882 120 City of Hopkins Combining Statement of Revenues, Expenses and Changes in Net Position Internal Service Funds Year Ended December 31, 2016 Equipment Replacement Employee Benefits Insurance Risk Total Operating revenues Charges for services $ 408,459 $- $ 104,082 $ 512,541 Operating expenses Materials, supplies and services 196,203 -86,373 282,576 Administration 7,350 -633 7,983 Depreciation expense 560,870 --560,870 Total operating expenses 764,423 -87,006 851,429 Operating income (loss)(355,964)-17,076 (338,888) Nonoperating revenues (expenses) Investment earnings -6,794 1,689 8,483 Interest/fiscal agent expense (7,694)--(7,694) Gain on sale of assets 60,424 --60,424 Total nonoperating revenues (expenses)52,730 6,794 1,689 61,213 Income (loss) before contributions and transfers (303,234)6,794 18,765 (277,675) Transfers and contributions Transfers in 1,896,571 -- 1,896,571 Total transfers and contributions 1,896,571 --1,896,571 Change in net position 1,593,337 6,794 18,765 1,618,896 Total net position - January 1 3,254,493 163,904 280,589 3,698,986 Net position - December 31 $4,847,830 $170,698 $299,354 $5,317,882 121 City of Hopkins Combining Statement of Cash Flows Internal Service Funds For the Year Ended December 31, 2016 Equipment Employee Insurance Replacement Benefits Risk Totals Cash Flows from Operating Activities Receipts from customers and users $ - $ - $ 104,082 $ 104,082 Receipts from interfund services provided 408,459 - - 408,459 Payments to suppliers (702,052) - (86,554) (788,606) Payments for interfund services used (7,350) (28,344) (633) (36,327) Net cash provided (used) by operating activities (300,943) (28,344) 16,895 (312,392) Cash Flows from Noncapital Financing Activities Transfers in 1,896,571 - - 1,896,571 Net cash provided by noncapital financing activities 1,896,571 - - 1,896,571 Cash Flows from Capital and Related Financing Activities: Purchases of capital assets (560,354) - - (560,354) Proceeds from sales of capital assets 60,424 - - 60,424 Interest and other payments (8,129) - - (8,129) Capital lease payments (47,488) - - (47,488) Net cash used by capital and related financing activities (555,547) - - (555,547) Cash Flows From Investing Activities (188) 10,084 2,443 12,339 Net increase (decrease) in cash and cash equivalents 1,039,893 (18,260) 19,338 1,040,971 Cash and Cash Equivalents - January 1 (1,036,089) 21,298 (18,379) (1,033,170) Cash and Cash Equivalents - December 31 $ 3,804 $ 3,038 $ 959 $ 7,801 Reconciliation of Cash and Cash Equivalents at End of Year to Cash and Investments per Statement of Net Position Ending cash and cash equivalents per cash flow statement $ 3,804 $ 3,038 $ 959 $ 7,801 Investments 1,182,139 944,181 297,957 2,424,277 Cash and Investments per Statement of Net Position $ 1,185,943 $ 947,219 $ 298,916 $ 2,432,078 Reconciliation of operating income (loss) to net cash provided (used) by operating activities: Operating income (loss)$ (355,964) $ - $ 17,076 $ (338,888) Adjustments to reconcile operating income (loss) to net cash provided (used) by operating activities: Depreciation expense 560,870 - - 560,870 Increase (decrease) in: Accounts, compensated absences and accrued intereset payable (505,849) (28,344) (181) (534,374) Net Cash Provided (Used) by Operating Activities $ (300,943)$ (28,344)$ 16,895 $ (312,392) 122 CITY OF HOPKINS, MINNESOTA COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE YEAR ENDED DECEMBER 31, 2016 SECTION III STATISTICAL SECTION 123 124 CITY OF HOPKINS, MINNESOTA STATISTICAL SECTION This part of the City of Hopkins’ comprehensive annual financial report presents detailed information as a context for understanding what the information in the financial statements, note disclosures, and the required supplementary information says about the city’s overall financial health. Contents Page Financial Trends 126 These schedules contain trend information to help the reader understand how the city’s financial performance and well-being have changed over time. Revenue Capacity 134 These schedules contain information to help the reader assess the factors affecting the city’s ability to generate its property and sales taxes. Debt Capacity 138 These schedules 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 143 These schedules 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 145 These schedules contain information about the city’s operations and resources to help the reader understand how the city’s financial information relates to the services the city provides and the activities it performs. Sources: Unless otherwise noted, the information in these schedules is derived from the comprehensive annual financial reports for the relevant year. 125 City of Hopkins Net Position by Component, Last Ten Fiscal Years (accrual basis of accounting) Fiscal Year 2007 2008 2009 2010 Governmental activities Net investment in capital assets $ 28,941,120 $ 30,769,922 $ 32,759,480 $ 32,823,582 Restricted 13,879,837 10,074,674 11,952,783 8,613,114 Unrestricted 2,006,418 3,663,772 10,022 3,590,101 Total governmental activities net position $ 44,827,375 $ 44,508,368 $ 44,722,285 $ 45,026,797 Business-type activities Net investment in capital assets $ $ 15,688,414 $ $ 16,081,209 $ $ 14,994,311 $ $ 16,279,028 Restricted - - - - Unrestricted 733,298 280,214 1,655,927 1,073,329 Total business-type activities net position $ 16,421,712 $ 16,361,423 $ 16,650,238 $ 17,352,357 Primary Government Net investment in capital assets $ 44,629,534 $ 46,851,131 $ 47,753,791 $ 49,102,610 Restricted 13,879,837 10,074,674 11,952,783 8,613,114 Unrestricted 2,739,716 3,943,986 1,665,949 4,663,430 Total primary government net position $ 61,249,087 $ 60,869,791 $ 61,372,523 $ 62,379,154 126 Schedule 1 Fiscal Year 2011 2012 2013 2014 2015 2016 $ 31,666,432 $ 31,891,229 $ 30,666,268 $ 31,272,253 $ 32,609,356 $ 33,833,387 8,250,360 8,684,347 10,014,203 16,967,889 20,016,574 14,722,076 6,348,703 7,854,941 9,575,287 1,902,270 (9,447,813) (14,457,459) $ 46,265,495 $ 48,430,517 $ 50,255,758 $ 50,142,412 $ 43,178,117 $ 34,098,004 $ 17,075,284 $ 16,405,495 $ 16,621,198 $ 16,937,928 $ 17,893,856 $ 21,798,183 - - - - - - 731,674 2,262,236 2,469,397 1,954,212 1,419,018 435,435 $ 17,806,958 $ 18,667,731 $ 19,090,595 $ 18,892,140 $ 19,312,874 $ 22,233,618 $ 48,741,716 $ 48,296,724 $ 47,287,466 $ 48,210,181 $ 50,503,212 $ 55,631,570 8,250,360 8,684,347 10,014,203 16,967,889 20,016,574 14,722,076 7,080,377 10,117,177 12,044,684 3,856,482 (8,028,795) (14,022,024) $ 64,072,453 $ 67,098,248 $ 69,346,353 $ 69,034,552 $ 62,490,991 $ 56,331,622 127 City of Hopkins Changes in Net Position, Last Ten Fiscal Years (accrual basis of accounting) Fiscal Year 2007 2008 2009 2010 2011 2012 Expenses Governmental activities: General Government $ 1,679,630 $ 1,721,624 $ 1,679,040 $ 1,693,275 $ 1,719,970 $ 1,719,970 Public Safety 5,665,419 6,171,249 6,249,519 6,243,813 6,213,995 6,213,995 Health and Welfare 188,483 236,858 278,002 180,895 170,018 170,018 Highways and Streets 2,870,426 3,154,762 3,069,078 3,062,507 3,332,067 3,332,067 Urban Development and Housing 1,903,295 1,037,927 1,690,861 1,914,779 2,859,900 2,859,900 Culture and Recreation 1,277,539 1,565,184 1,482,349 1,505,513 1,644,834 1,644,834 Interest on long-term debt 1,069,863 1,090,341 1,025,771 895,873 871,902 871,902 Total governmental activities expenses 14,654,655 14,977,945 15,474,620 15,496,655 16,812,686 16,812,686 Business-type activities: Water 1,240,760 1,356,448 1,209,508 1,196,947 1,263,835 1,263,835 Sewer 1,784,001 1,756,489 1,741,115 1,844,309 1,800,126 1,800,126 Storm Sewer 416,479 417,595 403,231 420,619 407,057 407,057 Refuse 732,239 771,107 786,522 738,398 778,044 778,044 Pavilion/Ice Arena 385,062 411,134 401,598 398,354 416,166 416,166 Housing and Redevelopment Authority 483,944 573,070 528,542 542,324 607,090 607,090 Total business-type activities 5,042,485 5,285,843 5,070,516 5,140,951 5,272,318 5,272,318 Total primary government expenses $ 19,697,140 $ 20,263,788 $ 20,545,136 $ 20,637,606 $ 22,085,004 $ 22,085,004 Program Revenues Governmental activities: Charges for services: General Government $ 38,595 $ 19,239 $ 30,797 $ 17,169 $ 42,112 $ 42,112 Public Safety 219,121 262,194 284,160 124,338 186,611 186,611 Health and Welfare 13,866 16,560 9,265 32,135 41,815 41,815 Highways and Streets 59,791 59,803 42,150 56,902 73,519 73,519 Urban Development and Housing 30,363 - - - 206,916 206,916 Culture and Recreation 397,992 514,592 509,098 560,702 623,147 623,147 Operating grants and contributions 2,123,438 1,949,375 2,441,622 1,894,777 2,325,158 2,325,158 Capital grants and contributions 1,677,841 170,393 745,505 567,370 1,751,464 1,751,464 Total governmental activities program revenues 4,561,007 2,992,156 4,062,597 3,253,393 5,250,742 5,250,742 Business-type activities: Charges for services: Water 1,133,248 1,188,610 1,339,390 1,343,153 1,395,306 1,395,306 Sewer 1,427,675 1,474,474 1,598,717 1,812,585 1,838,949 1,838,949 Storm Sewer 724,778 725,029 800,843 803,889 803,417 803,417 Refuse 692,222 713,270 821,628 852,215 939,421 939,421 Pavilion/Ice Arena 459,003 358,645 368,228 363,591 385,748 385,748 Housing and Redevelopment Authority 256,104 348,938 279,860 258,388 255,188 255,188 Operating grants and contributions 299,126 251,885 150,814 216,596 190,442 190,442 Capital grants and contributions - 394,913 142,691 328,515 28,250 28,250 Total business-type activities program revenues 4,992,156 5,455,764 5,502,171 5,978,932 5,836,721 5,836,721 Total primary government program revenues $ 9,553,163 $ 8,447,920 $ 9,564,768 $ 9,232,325 $ 11,087,463 $ 11,087,463 Net (Expense)/Revenue Governmental activities $ (10,093,648) $ (11,985,789) $ (11,412,023) $ (12,243,262) $ (11,561,944) $ (11,561,944) Business-type activities (50,329) 169,921 431,655 837,981 564,403 564,403 Total primary government net expense $ (10,143,977)$ (11,815,868)$ (10,980,368)$ (11,405,281)$ (10,997,541)$ (10,997,541) General Revenues and Other Changes in Net Position Governmental activities: Property taxes $ 8,732,711 $ 9,497,650 $ 9,353,966 $ 9,827,813 $ 9,952,156 $ 9,952,156 Tax Increments 1,050,601 1,186,395 1,636,609 2,147,517 2,239,668 2,239,668 Unrestricted grants and contributions 564,396 434,163 309,609 306,215 312,519 312,519 Unrestricted investment earnings 754,338 387,424 170,960 121,229 108,956 108,956 Gain on sale of capital assets 9,456 16,150 9,796 - 42,343 42,343 Transfers 145,000 145,000 145,000 145,000 145,000 145,000 Total governmental activities 11,256,502 11,666,782 11,625,940 12,547,774 12,800,642 12,800,642 Business-type activities: Property taxes - - - - - - Unrestricted investment earnings 84,670 21,714 12,841 9,138 8,319 8,319 Gain on sale of capital assets 3,300 - 367 - 26,879 26,879 Loss on disposal of capital assets - (106,924) (12,048) - - - Transfers (145,000) (145,000) (145,000) (145,000) (145,000) (145,000) Total business-type activities (57,030) (230,210) (143,840) (135,862) (109,802) (109,802) Total primary government $ 11,199,472 $ 11,436,572 $ 11,482,100 $ 12,411,912 $ 12,690,840 $ 12,690,840 Change in Net Position Governmental activities 1,162,854 (319,007) 213,917 304,512 1,238,698 1,238,698 Business-type activities (107,359) (60,289) 287,815 702,119 454,601 454,601 Total primary government $ 1,055,495 $ (379,296)$ 501,732 $ 1,006,631 $ 1,693,299 $ 1,693,299 128 Schedule 2 Fiscal Year 2013 2014 2015 2016 $ 2,108,141 $ 2,276,155 $ 6,656,991 $ 10,341,183 6,357,722 6,526,230 6,665,974 8,561,759 165,649 171,187 185,248 185,301 5,845,437 5,709,009 4,542,014 5,168,939 2,000,868 2,247,553 1,249,457 1,398,736 1,857,743 1,941,912 2,068,887 2,231,605 908,264 711,697 688,155 952,756 19,243,824 19,583,743 22,056,726 28,840,279 1,387,807 1,540,940 1,699,540 1,878,807 1,995,886 2,042,106 2,061,180 2,251,291 448,170 508,686 394,707 397,660 825,329 834,113 848,685 867,823 426,634 460,246 462,771 483,035 615,043 625,667 610,318 616,653 5,698,869 6,011,758 6,077,201 6,495,269 $ 24,942,693 $ 25,595,501 $ 28,133,927 $ $ 76,477 $ 56,635 $ 82,686 $ 72,716 180,548 118,248 79,415 274,661 57,032 57,235 47,085 58,264 75,840 96,573 127,221 125,749 228 242 220,027 190,199 756,011 740,147 810,762 770,466 5,273,474 2,943,889 4,970,313 4,087,923 1,775,717 2,728,416 501,029 1,109,278 8,195,327 6,741,385 6,838,538 6,689,256 1,483,133 1,497,699 1,514,086 1,526,290 1,999,333 2,025,763 2,172,277 2,215,251 799,603 802,898 805,542 810,142 901,670 906,387 910,672 959,258 65,055 31,914 24,876 22,275 272,109 256,884 277,885 282,125 561,111 795,199 622,332 721,677 144,076 - - 702,555 6,226,090 6,316,744 6,327,670 7,239,573 $ 14,421,417 $ 13,058,129 $ 13,166,208 $ 13,928,829 $ (11,048,497) $ (12,842,358) $ (15,218,188) $ (22,151,023) 527,221 304,986 250,469 744,304 $ (10,521,276)$ (12,537,372)$ (14,967,719)$ (21,406,719) $ 10,565,115 $ 11,207,914 $ 11,038,746 $ 11,994,436 2,002,607 2,700,110 2,920,681 2,959,459 21,152 20,510 20,510 20,510 105,213 193,546 279,418 124,406 34,651 27,235 27,535 62,013 145,000 493,093 (864,187) (2,089,914) 12,873,738 14,642,408 13,422,703 13,070,910 - - 64,161 63,519 18,788 24,503 23,477 13,231 21,855 - - 9,776 - - - - (145,000) (493,093) 864,187 2,089,914 (104,357) (468,590) 951,825 2,176,440 $ 12,769,381 $ 14,173,818 $ 14,374,528 $ 15,247,350 1,825,241 1,800,050 (1,795,485) (9,080,113) 422,864 (163,604) 1,202,294 2,920,744 $ 2,248,105 $ 1,636,446 $ (593,191)$ (6,159,369) 129 City of Hopkins Fund Balances, Governmental Funds, Last Ten Fiscal Years (modified accrual basis of accounting) Fiscal Year 2007 2008 2009 2010 General Fund Reserved $ 1,157,142 $ 111,806 $ 196,790 $ 182,211 Unreserved 3,304,729 3,884,309 3,930,996 4,071,049 Nonspendable - - - - Assigned - - - - Unassigned - - - - Total general fund $ 4,461,871 $ 3,996,115 $ 4,127,786 $ 4,253,260 All other Governmental Funds Reserved reported in: Special Revenue Funds $ 3,137,313 $ 3,189,829 $ 3,528,529 $ 2,844,901 Capital Projects Funds - - - - Debt Service Funds 12,982,623 3,250,202 6,021,748 4,850,159 Unreserved reported in: Special Revenue Funds 1,070,230 955,772 (24,957) 590,281 Capital Projects Funds 1,808,708 1,381,657 1,264,405 3,572,002 Nonspendable - - - - Restricted - - - - Committed - - - - Assigned - - - - Unassigned - - - - Total all other governmental funds $ 18,998,874 $ 8,777,460 $ 10,789,725 $ 11,857,343 Total all funds $ 23,460,745 $ 12,773,575 $ 14,917,511 $ 16,110,603 Note: The City began to use new categories of fund balance when it implemented GASB 54 in 2011. Prior years were not retroactively reclassified. 130 Schedule 3 Fiscal Year 2011 2012 2013 2014 2015 2016 $ - $ - $ - $ - $ - $ - - - - - - - 174,487 196,500 231,608 213,499 227,113 87,263 591,676 508,767 426,768 339,055 340,189 245,494 4,266,048 4,488,876 4,823,141 5,184,081 5,439,798 5,533,137 $ 5,032,211 $ 5,194,143 $ 5,481,517 $ 5,736,635 $ 6,007,100 $ 5,865,894 $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - - - - - - - - - - - 2,674,342 1,718,341 1,495 201 204 - 5,823,862 6,312,043 5,199,415 12,683,242 16,720,476 15,207,736 926,349 2,679,389 4,509,026 4,574,733 4,882,609 5,034,095 2,502,336 4,785,717 3,313,086 4,162,299 1,249,239 - (1,916,865) (2,090,788) (2,011,214) (2,029,619) (1,960,918) (2,789,907) $ 10,010,024 $ 13,404,702 $ 11,011,808 $ 19,390,856 $ 20,891,610 $ 17,451,924 $ 15,042,235 $ 18,598,845 $ 16,493,325 $ 25,127,491 $ 26,898,710 $ 23,317,818 131 City of Hopkins Changes in Fund Balances, Governmental Funds Last Ten Fiscal Years (modified accrual basis of accounting) Fiscal Year 2007 2008 2009 2010 Revenues Property Taxes $ 8,473,516 $ 8,844,113 $ 9,377,127 $ 9,795,318 Tax Increments 1,050,601 1,186,395 1,636,535 2,147,517 Special Assessments 1,172,977 1,120,741 1,071,406 1,128,467 Intergovernmental 2,115,670 1,053,405 1,220,766 1,215,163 Licenses and Permits 880,443 744,502 820,031 623,492 Charges for Services 729,365 872,388 875,470 800,115 Fines and Forfeits 215,051 188,003 148,172 138,894 Investment Earnings 638,796 318,074 135,569 106,128 Miscellaneous 851,203 709,915 1,024,879 589,604 Total revenues 16,127,622 15,037,536 16,309,955 16,544,698 Expenditures Current: General Government 1,597,503 1,590,347 1,552,712 1,576,676 Public Safety 5,290,802 5,779,047 5,888,481 5,881,633 Health and Welfare 184,541 232,163 273,760 177,732 Highways and Streets 2,091,043 2,224,338 2,139,351 2,082,853 Urban Redevelopment and Housing 1,787,131 935,402 1,586,083 1,881,610 Culture and Recreation 1,122,891 1,289,323 1,278,108 1,339,695 Capital outlay 5,830,516 1,228,755 1,556,121 1,358,792 Debt Service Principal 1,610,000 1,705,000 1,805,000 4,665,000 Interest and fiscal charges 1,131,514 1,100,211 1,037,372 953,232 Bond Issuance Costs 81,109 - 34,972 49,233 Total expenditures 20,727,050 16,084,586 17,151,960 19,966,456 Excess (deficiency) of revenues over expenditures (4,599,428) (1,047,050) (842,005) (3,421,758) Other Financing Sources (Uses) Sale of Property - - 341 - Proceeds from Issuance of Debt 11,875,000 - 2,865,000 4,515,000 Discount on Debt (72,905) - (24,400) (45,150) Premium on Debt 7,520 - - - Refunded bond payment - - - - Transfer In 14,940,055 1,043,155 1,088,875 7,808,068 Transfer Out (14,745,055) (898,155) (943,875) (7,663,068) Total other financing sources (uses) 12,004,615 145,000 2,985,941 4,614,850 Net change in fund balances $ 7,405,187 $ (902,050)$ 2,143,936 $ 1,193,092 Debt service as a percentage of noncapital expenditures 18.4 % 18.9 % 18.2 % 30.2 % Note: Capital outlay has been adjusted for items not shown as capital expenditures on the entity wide statements and reclassified to their respective expenditure category. 132 Schedule 4 Fiscal Year 2011 2012 2013 2014 2015 2016 $ 10,038,514 $ 10,403,945 $ 10,600,854 $ 11,212,334 $ 11,190,091 $ 12,181,695 2,239,668 2,332,863 2,002,607 2,700,110 2,920,681 2,959,459 1,446,922 1,307,949 1,634,903 1,202,401 1,003,444 1,404,258 1,931,333 1,549,464 3,775,172 3,272,977 2,234,195 2,698,372 691,962 476,296 649,672 569,585 489,373 686,785 908,106 787,724 884,354 835,960 848,775 1,000,847 174,303 253,530 251,170 229,807 258,924 223,131 94,409 94,235 94,024 172,012 257,543 115,925 701,683 1,881,347 1,343,592 1,148,505 1,474,048 1,870,874 18,226,900 19,087,353 21,236,348 21,343,691 20,677,074 23,141,346 1,598,885 4,038,893 2,019,932 2,126,004 2,586,582 2,886,837 5,895,640 6,144,206 6,089,431 6,154,320 6,253,424 6,718,046 168,202 136,169 164,237 167,088 176,248 181,666 2,337,018 2,193,209 4,709,377 4,495,659 3,180,023 3,797,748 2,826,172 2,348,694 1,979,001 2,192,453 1,219,526 1,337,387 1,510,024 1,581,886 1,688,876 1,747,614 1,851,741 2,016,229 1,972,143 2,470,049 4,272,737 2,144,714 8,789,979 7,325,037 2,065,000 1,635,000 3,265,000 1,970,000 8,570,000 3,075,000 852,184 819,238 853,433 709,367 646,387 855,114 - - - - - - 19,225,268 21,367,344 25,042,024 21,707,219 33,273,910 28,193,064 (998,368) (2,279,991) (3,805,676) (363,528) (12,596,836) (5,051,718) - - - - - - - 5,985,000 1,920,000 8,240,000 18,735,000 12,310,000 - (12,830) - - - - - 65,705 42,010 214,606 425,129 452,971 (215,000) - - - (3,927,887) (7,305,660) 1,504,822 4,788,179 2,948,556 9,351,659 8,513,635 8,112,133 (1,359,822) (4,989,453) (3,210,410) (8,858,566) (9,377,822) (12,098,618) (70,000) 5,836,601 1,700,156 8,947,699 14,368,055 1,470,826 $ (1,068,368)$ 3,556,610 $ (2,105,520)$ 8,584,171 $ 1,771,219 $ (3,580,892) 16.90 % 13.00 % 19.80 % 13.70 % 37.60 % 18.80 % 133 Schedule 5 City of Hopkins Assessed and Actual Value of Taxable Property Last Ten Fiscal Years (in thousands of dollars) Less: Total Taxable Payable Residential Apartment Commercial Industrial Other Tax-Exempt Market Total Direct Year Property Property Property Property Property Property Value Tax Rate 2007 $ 1,080,591 257,658 329,601 188,941 306 182,899 1,674,198 45.862 2008 1,061,645 257,275 352,028 198,808 306 182,899 1,687,163 45.570 2009 1,017,790 266,458 395,842 192,138 1,815 182,899 1,691,144 47.574 2010 922,267 251,418 404,674 168,803 1,503 177,975 1,570,690 49.377 2011 883,348 251,141 397,506 173,349 1,272 179,699 1,526,917 56.463 2012 816,431 252,968 422,769 174,254 1,492 179,699 1,488,215 59.718 2013 867,012 269,812 405,840 174,255 1,492 179,699 1,538,712 63.819 2014 838,714 277,435 419,190 177,413 1,492 179,699 1,534,545 64.290 2015 917,367 313,183 430,897 181,538 1,506 179,699 1,664,792 62.503 2016 925,844 352,761 306,977 191,345 1,604 179,699 1,598,832 65.581 Notes: (1) The direct tax rate is applied to the tax capacity of the property which is calculate by applying a statutory formula to the estimated market value of the property. The tax capacity is then multiplied by the direct tax rate to determine the city taxes payable on a specific parcel. (2) Tax exempt property is revalued on a six-year cycle. All other property is revalued on a three year cycle. 134 Schedule 6 City of Hopkins Direct and Overlapping Property Tax Rates Last Ten Fiscal Years (rate per $1,000 of assessed value) City Direct Rate Overlapping Rates Fiscal Year Basic Rate General Obligation Debt Service Total Direct School District Hennepin County Metro Council Other Total Overlapping Total Direct and Overlapping Tax Rate 2007 39.574 6.288 45.862 19.019 39.110 2.671 5.746 66.546 112.408 2008 39.237 6.333 45.570 19.218 38.571 2.562 5.984 66.335 111.905 2009 41.346 6.228 47.574 20.080 40.413 2.579 5.834 68.906 116.480 2010 43.121 6.256 49.377 22.944 42.561 2.612 6.825 74.942 124.319 2011 49.638 6.825 56.463 26.456 45.840 2.949 7.540 82.785 139.248 2012 52.238 7.480 59.718 29.270 48.231 3.084 7.827 88.412 148.130 2013 55.902 7.917 63.819 29.730 49.461 3.242 8.241 90.674 154.493 2014 55.743 8.547 64.290 32.358 49.959 3.335 8.716 94.368 158.658 2015 53.884 8.619 62.503 30.340 46.398 3.006 8.094 87.838 150.341 2016 55.365 10.216 65.581 28.514 45.356 2.899 7.864 84.633 150.214 Source: Hennepin County, Minnesota Taxpayer Services Department Notes: The City's basic rate is determined by the city's annual budget requirements as set by the City Council. Rates for debt service are based on each year's requirements. 135 Schedule 7 City of Hopkins Principal Property Taxpayers, Current Year and Ten Years Ago 2015 2006 Percentage Percentage of Total of Total City City Tax Tax Tax Tax Capacity Capacity Capacity Capacity Taxpayer Value Rank Value Value Rank Value Colfin MIdwest NNN Investment LLC $ 1,754,120 1 8.18 % $ - - - % Super Valu 1,047,910 2 4.89 1,254,050 1 7.33 Heines Global REIT 9320 EXCEL 891,430 3 4.16 139,350 10 0.81 Ramsgate Apartments LLC 292,813 4 1.37 225,000 5 1.32 Southwest Real Estate, Inc. 264,848 5 1.24 243,750 3 1.43 The Luther Co Ltd Partnership 256,120 6 1.19 - Duke Realty Ltd Partnership 243,990 7 1.14 203,250 7 1.19 Greenfield Apartments, LLP 227,700 8 1.06 274,375 2 1.60 Westside Property Owner LLC 227,250 9 1.06 - - - City Center Ventures, LLC 226,580 10 1.06 Hopkins Real Estate, LLC - - - 229,250 4 1.34 Oak Ridge Country Club - - - 155,670 9 0.91 Auburn Limited Partnership - - - 156,663 8 0.92 Opus Northwest, LLC - - - 213,250 6 1.25 - - - - - - Total $ 5,432,761 25.35 %$ 3,094,608 18.10 % Total City 2015/2006 tax capacity $ 21,443,177 17,100,534 Source: Hennepin County, Minnesota Assessor's Office Notes: Tax capacity is a percentage of total market value. For taxes payable in 2011 and forward these class rates are 1% for residential, 1.25% for apartments and 1.5% of first $150,000 with balance at 2.0% for commercial/industrial properties. 136 Schedule 8 City of Hopkins Property Tax Levies and Collections, Last Ten Fiscal Years Collected within the Taxes Levied for the Fiscal Year Fiscal Year of Levy Total Collections to Date Percentage Collections in Percentage Outstanding Percentage Fiscal Operating Debt Total Tax of Subsequent of Delinquent of Levy Year Tax Levy Tax Levy Levy Amount Levy Years (5)Amount Levy Taxes Outstanding 2007 7,598,758 1,207,000 8,805,758 8,620,427 97.9 % 141,204 8,761,631 99.5 % 44,127 0.5 % 2008 7,942,380 1,282,000 9,224,380 8,831,737 95.7 % 133,369 8,965,106 97.2 % 259,274 2.9 % (1) 2009 8,346,114 1,257,000 9,603,114 9,101,458 94.8 % 188,029 9,289,487 96.7 % 313,627 3.4 % (2) 2010 8,733,685 1,267,000 10,000,685 9,533,671 95.3 % 101,357 9,635,028 96.3 % 365,657 3.8 % (3) 2011 9,022,414 1,241,000 10,263,414 9,828,089 95.8 % 185,324 10,013,413 97.6 % 250,001 2.5 % (4) 2012 9,119,591 1,306,400 10,425,991 10,181,764 97.7 % 92,833 10,274,597 98.5 % 151,394 1.5 % 2013 9,219,774 1,306,400 10,526,174 10,319,805 98.0 % 25,165 10,344,970 98.3 % 181,204 1.8 % 2014 9,268,754 1,421,461 10,690,215 10,506,537 98.3 % (23,533) 10,483,004 98.1 % 207,211 2.0 % 2015 9,735,801 1,514,844 11,250,645 11,009,239 97.9 % 21,617 11,030,856 98.0 % 219,789 2.0 % 2016 10,338,764 1,907,878 12,246,642 12,120,075 99.0 % - 12,120,075 99.0 % 126,567 1.0 % Notes: (1) In December 2008 the State of MN unalloted $126,391 in Market Value Homestead Credit that is included in the total levy. Had the City received those funds, outstanding delinquent taxes would be reduced to $132,883 and the percentage of levy outstanding would be 1.4%. (2) For the year 2009 State of MN unalloted $246,865 in Market Value Homestead Credit that is included in the total levy. Had the City received those funds, outstanding delinquent taxes would be reduced to $91,797 and the percentage of levy outstanding would be 0.9%. (3) For the year 2010 State of MN unalloted $241,193 in Market Value Homestead Credit that is included in the total levy. Had the City received those funds, outstanding delinquent taxes would be reduced to $182,339 and the percentage of levy outstanding would be 1.8%. (4) For the year 2011 State of MN unalloted $257,696 in Market Value Homestead Credit that is included in the total levy. Had the City received those funds, outstanding delinquent taxes would be reduced to $153,757 and the percentage of levy outstanding would be 1.5%. (5) During the years 2010-2015 there were a significant number of tax court challenges that resulted in taxes being rebated to taxpayers resulting in higher delinquent taxes for the years 2008-2015. 137 Schedule 9 City of Hopkins Ratios of Outstanding Debt by Type Last Ten Fiscal Years Business-Type Governmental Activities Activities General HRA Tax Special Total Percentage Fiscal Obligation Lease Revenue Increment Assessments Capital Revenue Primary of Personal Per Year Bonds Bonds Bonds Bonds Lease Bonds Government Income Capita 2007 10,450,000 12,235,000 8,805,000 3,010,000 - 3,905,000 38,405,000 22.99 % 2,211 2008 9,855,000 2,565,000 8,135,000 2,690,000 425,000 3,410,000 27,080,000 15.32 % 1,545 2009 9,182,508 2,404,246 10,263,615 2,335,972 391,115 6,262,966 30,840,422 16.79 % 1,764 2010 8,566,973 2,281,799 8,290,713 4,861,298 355,556 5,133,954 29,490,293 16.84 % 1,676 2011 7,951,437 2,154,353 7,265,336 4,362,694 318,241 3,843,183 25,895,244 14.21 % 1,472 2012 10,130,650 - 6,733,274 7,262,674 279,083 4,832,960 29,238,641 15.02 % 1,652 2013 9,388,707 - 4,691,998 8,745,591 237,990 6,054,706 29,118,992 14.23 % 1,623 2014 15,092,501 - 4,095,716 10,123,177 194,868 5,488,002 34,994,264 16.94 % 1,901 2015 15,637,818 - 15,519,181 8,757,855 149,616 4,807,632 44,872,102 20.75 % 2,334 2016 23,522,410 - 17,869,376 8,155,188 102,128 4,422,261 54,071,363 23.94 % 2,812 Notes: Details regarding the District's outstanding debt can be found in note 9 of the notes to the financial statements. See the Demographic and Economic Statistics schedule on schedule 14 for personal income and population data. 138 Schedule 10 City of Hopkins Ratios of Net General Bonded Debt Outstanding Last Ten Fiscal Years General Obligation Bonds Less Percentage of General Tax Debt Service Actual Taxable Fiscal Obligation Improvement Revenue Increment Fund Net Value of Per Year Bonds Bonds Bonds Bonds Total Balance Bonded Debt Property Capita 2007 13,135,000 3,010,000 16,140,000 8,805,000 41,090,000 12,982,623 28,107,377 1.679 % 1,618 2008 12,420,000 2,690,000 5,975,000 8,135,000 29,220,000 3,250,202 25,969,798 1.539 % 1,482 2009 11,586,754 2,335,972 8,667,212 10,263,615 32,853,553 6,021,748 26,831,805 1.587 % 1,535 2010 10,848,772 4,861,298 7,415,753 8,290,713 31,416,536 4,850,159 26,566,377 1.691 % 1,510 2011 10,105,790 4,362,694 5,997,536 7,265,336 27,731,356 4,275,717 23,455,639 1.536 % 1,333 2012 10,130,650 7,262,674 4,832,960 6,733,274 28,959,558 4,618,138 24,341,420 1.636 % 1,375 2013 9,388,707 8,745,591 6,054,706 4,691,998 28,881,002 3,470,747 25,410,255 1.651 % 1,416 2014 15,092,501 10,123,177 5,488,002 4,095,716 34,799,396 10,427,856 24,371,540 1.584 % 1,324 2015 15,637,818 8,757,855 4,807,632 15,519,181 44,722,486 12,244,435 32,478,051 1.951 % 1,689 2016 23,522,410 8,155,188 4,422,261 17,869,376 53,969,235 8,806,091 45,163,144 2.825 % 2,349 Notes: Details regarding the city's outstanding debt can be found in note 9 of the notes to the financial statements See the Assessed and Actual Value of Taxable Property schedule 5 for taxable market value of property data See the Demographic and Economic Statistics schedule 14 for population data G.O Improvement bonds are included as they are backed by a general tax levy and specuial assessements levied against benefitted properties G.O. Revenue bonds are included as they are backed by the full taxing authority of the City should revenues fall short of debt requirements G.O. Tax Increment bonds are included as they are backed by property taxes levied against the properties benefitting from specific development for which the bonds were issued. 139 Schedule 11 City of Hopkins Direct and Overlapping Governmental Activities Debt As of December 31, 2016 Estimated Estimated Share of Net Debt Percentage Overlapping Outstanding Applicable (a)Debt Debt repaid with property taxes: School Districts: Hopkins ISD 270 $ 138,185,000 16.15 % $ 22,316,878 St. Louis Park ISD 283 43,030,000 0.48 % 206,544 Other Debt: Hennepin County 1,151,785,000 1.12 % 12,899,992 Hennepin Suburban Park District 70,475,000 1.56 % 1,099,410 Hennepin Regional RR Authority 33,145,000 1.56 % 517,062 Metropolitan Council 1,445,126,482 0.57 % 8,237,221 Subtotal - overlapping debt 45,277,106 City of Hopkins Direct Debt (b,c) 48,602,128 100 % 48,602,128 Total Direct and Overlapping Debt:$ 93,879,234 Source: Hennepin County, Minnesota Taxpayer Services Note: Overlapping governments are those that coincide, at least in part, with the geographic boundaries of the City. This schedule shows the portion of the outstanding debt of those overlapping governments that is borne by the residents and businesses 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 residents and businesses should be taken into account. However, this does not imply that every taxpayer is a resident, and therefore responsible for repaying the debt, of each overlapping government. (a) The percentage of overlapping debt applicable is estimated using the taxable market values. Applicable percentages were estimated by determining the portion of the county's and school district's taxable market value that is within the City's boundaries. (b) City of Hopkins direct debt includes long-term debt instruments of the City which are bonds and capital leases of the government. (c) Net Debt Outstanding excludes revenue bonds. 140 Schedule 12 City of Hopkins Legal Debt Margin Information Last Ten Fiscal Years (dollars in thousands) Legal Debt Margin Calculation for Fiscal Year 2016 Market value $ 1,721,105 Debt limit (3% of market value) 51,633 Debt applicable to limit: General Obligation Bonds 23,522 Less: Amount set aside for repayment of general obligation debt (1,761) Total net debt applicable to limit 21,761 Legal debt margin $ 29,872 Fiscal Year 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Debt limit $ 33,252 $ 50,615 $ 50,734 $ 47,121 $ 43,806 $ 42,189 $ 46,161 $ 46,036 $ 48,168 $ 51,633 Total net debt applicable to limit 9,768 9,263 8,772 10,144 9,549 9,402 8,903 8,736 14,661 21,761 Legal debt margin $ 23,484 $ 41,352 $ 41,962 $ 36,977 $ 34,257 $ 32,787 $ 37,258 $ 37,300 $ 33,507 $ 29,872 Total net debt applicable to the limit as a percentage of debt limit 29.38% 18.30%17.29% 21.53% 21.80% 22.29%19.29% 18.98% 30.44% 42.15% 141 Schedule 13 City of Hopkins Pledged Revenue Coverage Last Ten Fiscal Years Water Revenue Bonds Sewer Revenue Bonds Storm Sewer Revenue Bonds Fiscal Debt Service Debt Service Debt Service Year Revenue Principal Interest Coverage Revenue Principal Interest Coverage Revenue Principal Interest Coverage 2007 1,133,248 125,000 69,699 5.82 - - - - 724,778 350,000 111,605 1.57 2008 1,188,610 130,000 69,699 5.95 - - - - 725,029 365,000 98,846 1.56 2009 1,339,390 140,000 53,440 6.92 - - - - 800,843 365,000 79,437 1.80 2010 1,342,073 1,000,000 56,211 1.27 1,812,585 - 21,501 84.30 803,889 280,000 46,791 2.46 2011 1,395,306 200,000 45,225 5.69 1,838,949 50,000 33,750 21.96 803,417 1,025,000 41,050 0.75 2012 1,534,221 210,000 41,125 6.11 2,150,594 60,000 32,650 23.21 799,938 180,000 26,823 3.87 2013 1,483,283 260,000 50,010 4.78 1,999,483 70,000 34,396 19.15 799,603 205,000 29,585 3.41 2014 1,497,699 265,000 68,704 4.49 2,025,763 70,000 46,193 17.43 802,898 205,000 36,745 3.32 2015 1,514,086 320,000 56,360 4.02 2,172,277 100,000 41,318 15.37 805,542 235,000 29,879 3.04 2016 1,526,290 145,000 47,423 7.93 2,215,251 105,000 36,219 15.69 810,142 110,000 25,737 5.97 Notes: Details regarding the City's outstanding debt can be found in Note 9 of the notes to the financial statements. 142 Schedule 14 City of Hopkins Demographic and Economic Statistics Last Ten Calendar Years Personal Per Income (2)Capita Fiscal (thousands Personal School Unemployment Year Population (1)of dollars)Income (2)Enrollment (3)Rate (4) 2007 17,367 166,143 42,299 9,318 4.5 2008 17,526 176,035 44,364 9,308 6.4 2009 17,481 182,075 45,459 9,333 6.7 2010 17,591 174,808 43,265 9,241 6.5 2011 17,591 180,988 44,489 9,107 5.5 2012 17,701 193,488 47,136 8,556 5.1 2013 17,939 203,498 49,147 8,555 4.3 2014 18,413 206,789 49,460 8,489 3.8 2015 19,227 216,218 51,244 8,495 3.1 2016 19,227 225,882 53,121 8,327 3.8 Sources: (1) Metropolitan Council, except for 2010 and 2011 which is per the U.S. Census. (2) U.S. Department of Commerce Bureau of Economic Analysis data for Minnesota Metropolitan Area (3) Minnesota Department of Education and is for public and non-public schools in Hopkins School District #270 (4) Minnesota Department of Employment and Economic Development, based on December rates 143 Schedule 15 City of Hopkins Principal Employers, Current Year and Ten Years Ago 2016 2007 Percentage Percentage of Total of Total Taxpayer Employees Rank Employment Employees Rank Employment Cargil 4,000 1 26.274 % - - - % ISD 270 Hopkins (1) 1,041 2 6.838 1,800 1 15.244 SuperValu 707 3 4.644 1,500 2 12.703 Thermotech 400 4 2.627 235 5 1.990 U.S. Post Office 314 5 2.063 - - - Oak Ridge Country Club 185 6 1.215 200 6 1.694 Augustana Chapel View Homes 185 7 1.215 250 4 2.117 US Bank 185 8 1.215 - - - City of Hopkins 144 9 0.946 135 8 1.143 Walser Chrysler Jeep 100 10 0.657 - - - GE Water & Process Technologies - - - 550 3 4.658 Rudy Luther's Hopkins Honda - - - 200 7 1.694 Hopkins Care Center - - - 125 9 1.059 EDCO Products - - - - - Sungard Financial Systems - - - 115 10 0.974 Total 7,261 47.694 % 4,995 43.276 % Source: Minnesota Department of Employment and Economic Development, Metropolitan Council and Minnesota State Business Directory Notes: (1) Includes total number of employees located in facilities throughout Independent School District 270, Hopkins. 144 Schedule 16 City of Hopkins Full-Time Equivalent City Employees by Type Last Ten Fiscal Years Full-time-Equivalent Employees as of December 31, 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 General Government Administrative Services 5.15 5.05 4.95 4.80 4.80 4.95 5.00 5.00 5.00 5.05 Finance 4.60 4.60 4.60 4.60 4.60 4.60 4.60 4.60 4.60 4.00 Municipal Building 1.45 1.45 1.45 1.45 1.45 1.45 1.45 1.45 1.45 1.45 Community Services 9.48 9.85 9.95 9.95 9.95 9.80 9.80 9.70 9.70 8.65 Public Safety Police 39.40 39.45 40.00 39.00 40.00 39.50 36.45 34.50 36.50 36.78 Fire 1.20 1.20 1.20 1.20 1.20 1.20 1.25 1.25 1.25 3.25 Public Works 18.59 18.60 18.70 17.77 17.25 17.69 17.69 17.09 18.09 17.58 Recreation Activity Center 4.00 3.30 3.30 3.30 3.30 3.20 3.20 3.20 3.20 3.25 Skate Park 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 Planning & Zoning 1.20 1.15 1.15 1.35 1.35 1.35 1.35 1.35 1.35 1.35 Community Development - - - - - 0.85 0.85 0.85 0.85 1.50 Total General Government 85.12 84.70 85.35 83.47 83.95 84.64 81.69 79.04 82.04 82.91 Special Revenue Funds Economic Development 1.60 1.78 1.75 1.75 1.60 1.60 1.15 1.60 1.60 1.25 Paratransit 0.20 0.20 0.20 - - - - - - - Housing Rehabilitation 0.70 0.85 0.85 0.85 0.85 - - - - - Parking 1.00 1.00 1.00 1.00 1.00 0.72 0.72 0.72 1.00 0.72 Section 8 1.35 - - - - - - - - - Communication 0.10 0.10 0.10 0.40 0.25 0.25 0.25 0.25 0.25 0.75 Depot Coffee House 0.05 1.00 1.00 1.00 1.50 1.50 2.50 2.50 2.50 5.25 Art Center 4.05 4.05 4.05 4.05 4.55 4.30 3.80 3.80 4.30 4.30 Total Special Revenue Funds 9.05 8.98 8.95 9.05 9.75 8.37 8.42 8.87 9.65 12.27 Enterprise Funds Water 3.25 3.76 3.67 3.11 3.11 3.13 3.13 3.13 3.43 2.60 Sanitary Sewer 3.56 4.07 4.08 3.44 3.44 3.46 3.46 3.46 3.76 3.40 Refuse 4.08 4.09 4.12 3.40 3.58 3.89 3.89 3.89 3.89 4.09 Storm Sewer 0.46 0.46 0.46 0.42 0.42 0.63 0.63 0.63 0.63 0.43 Pavilion/Ice Arena 2.72 3.80 3.80 3.05 2.45 2.40 2.40 2.40 2.90 2.90 Housing and Redevelopment 2.45 2.05 2.05 2.05 2.20 2.20 2.20 2.20 2.20 2.40 Total General Government 16.52 18.23 18.18 15.47 15.20 15.71 15.71 15.71 16.81 15.82 Total 110.69 111.91 112.48 107.99 108.90 108.72 105.82 103.62 108.50 111.00 Source: City Finance Office 145 City of Hopkins Operating Indicators by Function/Program Last Ten Years Fiscal Year Function/Program 2007 2008 2009 2010 2011 General Government Elections 1 2 1 2 1 Registered voters 8,330 11,233 9,548 9,393 9,691 Number of votes cast 1,146 8,835 861 5,761 961 Voter participation (registered)3.80%78.70%9%61.30%9.90% Public Safety Police Total Calls for Service 19,137 19,440 19,238 19,141 21,257 Sworn Officers 26 26 26 26 26 Traffic Stops 4,287 3,042 2,698 2,597 5,231 Parking Citations 747 647 925 914 864 Fire Fires 70 45 38 58 40 False Alarm 70 101 107 98 95 Fire Runs 350 291 220 370 331 Medical Runs 59 67 56 66 77 Average Response Time (minutes) 4.3 4.0 4.2 4.0 4.0 Inspections Building Permits 377 897 381 4 631 Value of Building Permits $ 50,544,210 $ 45,074,024 $ 54,688,290 $ 10,968,955 $ 19,211,258 Public Works Miles of seal coating 3.2 2.60 0.55 0.95 0.85 Miles of crack sealing 2.88 4.97 3.71 1.99 7.26 Sidewalk repairs in square feet 4,279 4,930 6,228 5,252 5,831 Alley repairs in square yards 253 238 142 170 200 Culture and Recreation Art Center Bookings 6,054 5,593 5,392 4,913 4,307 Reserved Hours 39,060 34,760 33,780 30,414 26,406 Customer Visits for Events/Activities 203,000 212,000 203,100 205,319 219,975 Water Gallons of water pumped (in millions) 794.7 774 813 794 744 Number of well house inspections 2,488 2,488 2,484 2,501 2,446 Number of hydrants flushed 100+100+ 130 144 151 Water Rate $ 1.40 $ 1.65 $ 1.86 $ 1.90 $ 1.90 Sanitary Sewer Sanitary sewage flow (in millions of gallons) 641.3 626.2 580.2 567.8 606.5 Miles of sewer lines jetted 17.3 14.6 14.2 15.4 14.6 Number of manholes checked/cleaned 441 344 1,290 1,301 1,421 Lift Station Maintenance checks 4,374 3,855 4,312 4,310 4,321 Sewer Rate $ 2.50 $ 2.70 $ 3.10 $ 3.40 $ 3.60 Refuse Number of refuse accounts 2,670 2,678 2,689 2,695 2,687 Tons of refuse collected 2,448 2,393 2,335 2,298 2,265 Tons of recycled material (residential) 1,138 1,080 1,194 1,148 1,222 Refuse rate $ 12.50-15.90 $ 13.20 - 17.25 $ $15.85-21.85 $ 15.85-21.85 $ 15.85-21.85 Recycling rate $ 2.75 $ 3.25 $ 3.50 $ 3.75 $ 3.75 Pavilion/Ice Arena Ice time rental hours 1,458 1,469 1,456 1,455 1,407 Turf use hours 442 479 624 624 758 Mezzanine rental use 345 400 495 776 1,150 Source: Various City Departments Notes: (1) Information not available is labeled N/A.. (2) In 2009 the Sewer Department began checking manholes on a monthly basis. 146 Schedule 17 Fiscal Year 2012 2013 2014 2015 2016 2 1 2 1 2 10,912 9,917 109,123 9,647 10,418 9,130 1,674 9,130 1,058 9,198 83.70%16.90%83.70%11.0%88.3% 25,379 25,286 26,140 23,535 24,549 26 26 26 28 27 7,602 6,333 5,741 6,055 6,910 958 979 820 725 640 36 38 51 18 81 91 101 100 103 130 382 382 428 467 566 141 178 195 177 1,277 4.0 4.2 4.2 4.4 4.2 501 509 455 501 451 $ 9,804,196 $ 44,183,445 $ 16,453,935 $ 12,631,596 $ 76,838,870 . 5.36 5.49 5.26 1.81 1.05 4.13 3.75 5.85 5.26 1.54 5,770 5,172 4,482 6,800 6,286.00 201 190 41 182 180 4,307 4,440 4,747 5,013 4,981 26,406 27,442 29,440 31,759 31,320 219,975 213,487 215,371 216,450 211,969 781 817 812 751 787 2,480 2,465 2,510 2,190 2,450 142 138 150 120 139 $ 1.96 $ 2.02 $ 2.10 $ 2.18 $ 2.18 601.9 579.0 628.6 615 605 14.7 16.2 14.6 12 15 1,337 1,413 1,400 274 1,025 4,314 4,307 4,401 4,350 4,283 $ 3.75 $ 3.90 $ 4.10 $ 4.30 $ 4.30 2,681 2,706 2,709 2,735 2,692 2,470 2,136 2,393 2,368 2,095 1,182 757 1,114 1,106 166 $ 16.85 - 24.30 $ 16.85 - 24.30 $ 16.85 - 24.30 $ 16.85 - 24.30 $ 16.85 - 24.30 $ 4.00 $ 4.25 $ 4.25 $ 4.50 $ 5.00 1,429 1,401 1,370 1,365 1,284 869 865 810 818 749 1,260 1,386 2,147 2,822 2,847 147 Schedule 18 City of Hopkins Capital Asset Statistics by Function/Program Last Ten Years Fiscal Year Function/Program 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Public Safety Police Stations 1 1 1 1 1 1 1 1 1 1 Patrol Units 10 10 10 11 11 11 11 11 11 11 Fire Stations 1 1 1 1 1 1 1 1 1 1 Public Works Highways (miles) 3.57 3.57 3.57 3.57 3.57 3.57 3.57 3.57 3.57 3.57 County Highways 5.32 5.32 5.32 5.32 5.32 5.32 5.32 5.32 5.32 5.32 City Streets (miles) 47.50 47.50 47.50 47.50 47.50 47.50 47.50 47.50 47.50 47.50 Alleys (miles) 9.52 9.52 9.52 9.52 9.52 9.52 9.52 9.52 9.52 9.52 Streetlights 360 360 398 398 398 398 398 398 398 398 Traffic Signals 44 44 44 44 44 44 44 44 44 44 Refuse collection trucks 3 3 3 3 3 3 3 3 3 3 Culture & Recreation Parks Parks 16 16 16 16 16 16 16 16 16 16 Park Trails 3 4 4 4 4 4 4 4 4 4 Park Acres 102 104 104 104 104 104 104 104 104 104 Park Shelters 10 10 10 10 11 11 11 11 11 11 Playgrounds 11 11 11 11 11 11 11 11 11 11 Skateboard Park/Inline Skating 1 1 1 1 1 1 1 1 1 1 Skating Rinks 7 7 7 7 7 7 7 7 7 7 Hockey Rinks 6 6 6 5 5 5 5 5 5 5 Basketball Courts 6 6 6 6 6 6 6 6 6 6 Softball Fields 4 4 4 4 4 4 4 4 4 4 Swimming Beach 1 1 1 1 1 1 1 1 1 1 Tennis Courts 12 8 8 8 8 8 8 8 8 8 Volleyball Courts 2 2 2 2 2 2 2 2 2 2 Watermains Distribution System (miles) 52.60 52.60 52.60 52.60 52.60 52.60 52.60 52.60 52.60 52.60 Fire Hydrants 560 560 560 560 560 560 560 560 560 560 Storage Capacity (gallons in thous) 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3200 Water Connections 3,157 3,163 3,163 3,168 3,168 3,168 3,168 3,168 3,168 3168 Sanitary Sewer Collection System (miles) 45.46 45.46 45.46 45.46 45.46 45.46 45.46 45.46 45.46 45.46 Sewer Connections 3,077 3,081 3,081 3,086 3,086 3,086 3,086 3,086 3,086 3,086 Storm Sewer Pipe (miles) 21.40 21.40 21.40 21.40 21.40 21.40 21.40 21.40 21.40 21.40 Parking Parking Lots 7 7 7 7 7 7 7 7 7 7 Parking Ramp 1 1 1 1 1 1 1 1 1 1 Source: Various City Departments 148