Document Allencounty_doc_0625aa8b9a

ALLEN COUNTY GOVERNMENT Fort Wayne, Indiana ANNUAL FINANCIAL REPORT For The Year Ended December 31, 2017 B50901 FILED 09/27/2018 ---PAGE BREAK--- TABLE OF CONTENTS Description Page Schedule of Officials 3 Independent Auditor's Report 4-6 Management's Discussion and Analysis 7-17 Basic Financial Statements and Accompanying Notes: Government-Wide Financial Statements: Statement of Net Position 19 Statement of Activities 20 Fund Financial Statements: Balance Sheet – Governmental Funds 21 Statement of Revenues, Expenditures, and Changes in Fund Balances – Governmental Funds 22 Reconciliation of the Statement of Revenues, Expenditures, and Changes in Fund Balances of Governmental Funds to the Statement of Activities 23 Statement of Net Position – Proprietary Funds 24 Statement of Revenues, Expenses, and Changes in Fund Net Position – Proprietary Funds 25 Statement of Cash Flows – Proprietary Funds 26 Statement of Fiduciary Net Position – Fiduciary Funds 27 Statement of Changes in Fiduciary Net Position – Fiduciary Funds 28 Notes to Financial Statements 29-76 Required Supplementary Information: Schedules of Changes in the County’s Net Position Liability and Related . 77-78 Schedules of County 79-80 Schedules of Investment 81-82 Schedule of Proportionate Share of Net Pension Liability and Related Ratios – INPRS (PERF) 83 Schedule of Employer Contributions – INPRS 84 Schedule of Funding 85 Budgetary Comparison Schedules – General Fund and Major Special Revenue Funds 86 Budget/GAAP Reconciliation 87 Supplementary Information: Non-Major Governmental Funds: Combining Balance Sheet – Non-Major Governmental Funds 88-114 Combining Statement of Revenues, Expenditures, and Changes in Fund Balances – Non-Major Governmental Funds 115-139 Non-Major Proprietary Funds: Combining Statement of Net Position – Internal Service Funds 140 Combining Statement of Revenues, Expenses, and Changes in Net Position – Internal Service Funds 141 Combining Statement of Cash Flows – Internal Service Funds 142 1 ---PAGE BREAK--- TABLE OF CONTENTS (Continued) Non-Major Fiduciary Funds: Combining Statement of Fiduciary Net Position – Agency Funds 143-145 Combining Statement of Changes in Assets and Liabilities – Agency Funds 146-148 Other 149 2 ---PAGE BREAK--- SCHEDULE OF OFFICIALS Office Official Term County Auditor Tera K. Klutz 01-01-15 to 01-18-17 Nicholas D. Jordan 01-19-17 to 12-31-18 County Treasurer William F. Royce 01-01-17 to 12-31-20 Clerk of the Circuit Court Lisbeth A. Borgmann 01-01-15 to 12-31-18 County Sheriff David J. Gladieux 01-01-15 to 12-31-18 County Recorder Anita A. Mather 01-01-15 to 12-31-18 Circuit Court Judge Honorable Thomas J. Felts 01-01-15 to 12-31-20 Superior Court Judge Honorable Daniel G. Heath 01-01-15 to 01-31-20 President of the Board of County Commissioners Therese M. Brown 01-01-17 to 12-31-18 President of the County Council Larry L. Brown 01-01-17 to 12-31-17 Joel M. Benz 01-01-18 to 12-31-18 3 ---PAGE BREAK--- STATE OF INDIANA AN EQUAL OPPORTUNITY EMPLOYER STATE BOARD OF ACCOUNTS 302 WEST WASHINGTON STREET ROOM E418 INDIANAPOLIS, INDIANA 46204-2769 Telephone: (317) 232-2513 Fax: (317) 232-4711 Web Site: www.in.gov/sboa INDEPENDENT AUDITOR'S REPORT TO: THE OFFICIALS OF ALLEN COUNTY, INDIANA Report on the Financial Statements We have audited the accompanying financial statements of the governmental activities, the business-type activities, the aggregate discretely presented component units, each major fund, and the aggregate remaining fund information of Allen County (County), as of and for the year ended December 31, 2017, and the related notes to the financial statements, which collectively comprise the County's basic financial statements as listed in the Table of Contents. Management's Responsibility for the Financial Statements Management is responsible for the preparation and fair presentation of these financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Auditor's Responsibility Our responsibility is to express opinions on these financial statements based on our audit. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free from material misstatement. An audit involves performing procedures to obtain audit evidence about the amounts and dis- closures in the financial statements. The procedures selected depend on the auditor's judgment, including the assessment of the risks of material misstatement of the financial statements, whether due to fraud or error. In making those risk assessments, the auditor considers internal control relevant to the County'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 County'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. 4 ---PAGE BREAK--- INDEPENDENT AUDITOR'S REPORT (Continued) Basis for Qualified Opinion on the Aggregate Discretely Presented Component Units The County has not included the Allen County Solid Waste District and Southwest Allen County Fire District as discretely presented component units in the County's financial statements as required by accounting standards generally accepted in the United States of America. The Allen County Solid Waste District and Southwest Allen County Fire District represent 8.9 percent, 11.9 percent, and 14 percent of the assets, net position, and revenues, respectively, of the County's aggregate discretely presented component unit. Qualified Opinion on the Aggregate Discretely Presented Component Units In our opinion, except for the effects of the matter discussed in the Basis for Qualified Opinion on the Aggregate Discretely Presented Component Units paragraph, the financial statements referred to above present fairly, in all material respects, the respective financial position of the aggregate discretely presented component units, in accordance with accounting principles generally accepted in the United States of America, as of and for the year ended December 31, 2017. Unmodified Opinions In our opinion, based on our audit, 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 County, as of December 31, 2017, and the respective changes in financial position and, where applicable, cash flows thereof and 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, Schedules of Changes in the County's Net Pension Liability and Related Ratios, Schedules of County Contributions, Schedules of Investment Returns, Schedule of Proportionate Share Net Pension Liability and Related Ratios - INPRS (PERF), Schedule of Employer Contributions - INPRS (PERF), Schedules of Funding Progress, Budgetary Comparison Schedule - General Fund and Major Special Revenue Funds, and Budget/GAAP Reconciliation, 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 County's basic financial statements. The accompanying Combining Balance Sheet - Non-Major Governmental Funds, Combining Statement of Revenues, Expenditures, and Changes 5 ---PAGE BREAK--- INDEPENDENT AUDITOR'S REPORT (Continued) in Fund Balances - Non-Major Governmental Funds, Combining Statement of Net Position - Internal Service Funds, Combining Statement of Revenues, Expenses, and Changes in Net Position - Internal Service Funds, Combining Statement of Cash Flows - Internal Service Funds, Combining Statement of Fiduciary Net Position - Agency Funds, and Combining Statement of Changes in Assets and Liabilities - Agency Funds are presented for purposes of additional analysis and are not a required part of the basic financial statements. The Combining Balance Sheet - Non-Major Governmental Funds, Combining Statement of Revenues, Expenditures, and Changes in Fund Balances - Non-Major Governmental Funds, Combining Statement of Net Position - Internal Service Funds, Combining Statement of Revenues, Expenses, and Changes in Net Position - Internal Service Funds, Combining Statement of Cash Flows - Internal Service Funds, Combining Statement of Fiduciary Net Position - Agency Funds, and Combining Statement of Changes in Assets and Liabilities - Agency Funds 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 Balance Sheet - Non-Major Governmental Funds, Combining Statement of Revenues, Expenditures, and Changes in Fund Balances - Non-Major Governmental Funds, Combining Statement of Net Position - Internal Service Funds, Combining Statement of Revenues, Expenses, and Changes in Net Position - Internal Service Funds, Combining Statement of Cash Flows - Internal Service Funds, Combining Statement of Fiduciary Net Position - Agency Funds, and Combining Statement of Changes in Assets and Liabilities - Agency Funds are fairly stated, in all material respects, in relation to the basic financial statements as a whole. Other Reporting Required by Government Auditing Standards In accordance with Government Auditing Standards, we have also issued our report dated August 28, 2018, on our consideration of the County'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 solely to describe the scope of our testing of internal control over financial reporting and compliance and the results of that testing, and not to provide an opinion on the effectiveness of the County's 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 County's internal control over financial reporting and compliance. Paul D. Joyce, CPA State Examiner August 28, 2018 6 ---PAGE BREAK--- MANAGEMENT’S DISCUSSION AND ANALYSIS The management of Allen County (the County) provides the following discussion and analysis as insight into the financial performance of the County during the year ended December 31, 2017. Please read it in conjunction with the County’s basic financial statements and notes to the basic financial statements following this section. FINANCIAL HIGHLIGHTS  The assets and deferred outflows of resources of the County exceeded its liabilities and deferred inflows of resources at the close of 2017 by $500.2 million (total net position), an increase of $4.3 million, .9 percent, over the beginning 2017 total net position of $495.9 million. Of this amount, $93.8 million (unrestricted net position) may be used to meet the County’s ongoing obligations to citizens, $12.7 million is restricted for debt service and other specific purposes (restricted net position), and $393.7 million is invested in capital assets, net of related debt.  The total net position of the County’s governmental activities increased by $3.5 million or .8 percent and is primarily the result of the $5.5 mil decrease in liabilities which is almost completely related to decreases in debt service obligations. Assets and deferred outflows decreased $2 million primarily due to the $13.7 mil decrease in capital assets. The total net position of the County’s business activities increased by million or 1.7 percent, and is mainly due to the $2.7 million reduction in the first mortgage revenue bonds payable.  At the end of 2017, the County’s governmental funds reported a combined ending fund balance of $131.5 million, an increase of $11.2 million or 9.3 percent from 2016. In accordance with GASB 54 the total Fund Balance is broken down as $1 million Nonspendable, $70 million as Restricted, $22.2 million Committed, $14.6 million Assigned, and $23.7 million as Unassigned.  At the end of 2017, the unassigned fund balance for the General Fund was $24.7 million or 27.3 percent of the 2017 General Fund expenditures.  During 2017, the County’s total debt decreased by $8.9 million or 12.2 percent. The decrease is attributed to regularly scheduled debt service payments as well as the bond refunding that took place in 2016. OVERVIEW OF THE FINANCIAL STATEMENTS This discussion and analysis are intended to serve as an introduction to the County’s basic financial statements. The County’s basic financial statements comprise three components 1) Government-wide financial statements; 2) Fund financial statements and 3) Notes to the basic financial statements. Government-wide Financial Statements present the financial picture of the County from the economic resources measurement focus using the accrual basis of accounting, in a manner similar to a private- sector business. The government-wide financial statements are composed of two statements: the statement of net position and the statement of activities. The statement of net position presents information on all of the County’s assets and liabilities, and deferred outflows and deferred inflows of resources, with the difference between them reported as total net position. Total net position is then broken down between governmental and business-type activities. Over time, increases or decreases in net position will show the fluctuation in the County’s financial position. The statement of activities presents information on all of the County’s revenues and expenses, showing how the County’s general expenses less the program revenues equal net expenses for the most recent fiscal year. General revenues are then subtracted from net expenses to get the change in net position. All of the current year’s revenues and expenses are taken into account regardless of when the cash is received or paid. Thus, revenues and expenses are reported in this statement for some items that will result in cash flows in future fiscal periods uncollected taxes and earned but unused vacation leave). 7 ---PAGE BREAK--- Both of these government-wide financial statements distinguish functions of the County that are principally supported by taxes and intergovernmental revenues (governmental activities) from other functions that are intended to recover all or in part a portion of their costs through user fees and charges (business-type activities). The governmental activities include general government, public safety, public highways and facilities, health and sanitation, economic development, and recreation. The business-type activities of the County include the Allen County War Memorial Coliseum. Component units are included in our basic financial statements according to GASB 61 and consist of legally separate entities for which the County is financially accountable and that have substantially the same board as the County or provide services entirely to the County. Examples are: the Allen County Juvenile Justice Center Building Corporation and the Allen County Jail Building Corporation which were established for the sole purpose of financing the new juvenile and jail facilities. The Building Corporations are part of the primary government because the nature of the relationship to the County is significant. The Allen County Public Library is reported as discretely presented component unit because they have some financial accountability to the County’s Council. The government-wide financial statements can be found on pages 19 and 20 of this report. Fund Financial Statements are groupings of related accounts that are used to maintain control over resources that have been segregated for specific activities or objectives. Certain funds are required to be established by State Statute and by bond covenants, while others are adopted to help administer monies set aside for a limited purpose. The County, 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 County can be divided into three categories: governmental funds, proprietary funds and fiduciary 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 use modified accrual method of accounting which focuses on near-term inflows and outflows of spendable resources, as well as on balances of spendable resources available at the end of the fiscal year. This information may be useful in evaluating the County’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. This comparison will make it easier to understand the long-term impact of the county’s near-term financing decisions. Both the governmental funds balance sheet and the governmental funds statement of revenues, expenditures, and changes in fund balances provide a reconciliation to facilitate this comparison between governmental funds and governmental activities. The County maintains approximately 250 individual governmental funds. Information is presented separately in the governmental funds balance sheet and in the governmental funds statement of revenues, expenditures, and changes in fund balances for the General Fund, Rainy Day Fund, and the Local Income Tax Economic Development Fund (CEDIT), and The County Option Income Tax Distributive Shares Fund (COIT) was combined with the General Fund as allowed by Indiana State Board of Accounts.. The governmental funds financial statements can be found on pages 21 through 23 of this report. Proprietary funds are maintained two ways. Enterprise funds are used to report the same functions presented as business-type activities in the government-wide financial statements. The County uses enterprise funds to account for the Allen County War Memorial Coliseum. Internal Service funds are an accounting device used to accumulate and allocate cost internally among the County’s various functions. The County uses internal service funds to account for its costs associated with group health insurance, workers compensation, liability/vehicle expenses, telephones/internet, printing, and other office supplies. Because these services predominantly benefit governmental rather than business-type functions, they have been included within governmental activities in the government-wide financial statements. 8 ---PAGE BREAK--- Proprietary funds provide the same type of information as the government-wide financial statements, only in more detail. The Allen County War Memorial Coliseum is considered to be a major fund of the County and is shown separately. The County’s internal service funds are combined into a single, aggregated presentation in the proprietary fund financial statements. The proprietary funds financial statements can be found on pages 24 through 26 of this report. Fiduciary funds are used to account for resources held for the benefit of parties outside the government. Fiduciary funds are not reflected in the government-wide financial statements because the resources of those funds are not available to support the County’s own programs. The accounting used for fiduciary funds is much like that used for proprietary funds. The County has two types of fiduciary funds: Pension Trust and Agency funds (which are clearing accounts for assets held by the County in its role as custodian until the funds are allocated to the private parties, organizations, or government agencies to which they belong). The fiduciary funds financial statements can be found on pages 27 and 28 of this report. Notes to the Basic Financial Statements provide additional information that is essential to a full understanding of the data provided in the government-wide financial statements and the fund financial statements. The notes can be found on pages 29 through 76 of this report. Required Supplementary Information is presented concerning the County’s General Fund Budgetary Schedule, Schedule of Funding Progress, Schedules of Changes in the County’s Net Pension Liability and Related Ratios, Schedules of County Contributions, and Schedules of Investment Returns. The County adopts an annual appropriated budget for its General Fund. A Budgetary Comparison Schedule has been provided for the General Fund and Major Special Revenue Funds to demonstrate compliance with their budgets. The Schedule of Funding Progress, Schedules of Changes in the County’s Net Pension Liability and Related Ratios, Schedules of County Contributions and Schedules of Investment Returns, Schedule of Proportionate Share Net Pension Liability and Related Ratios and Schedule of Employer Contributions have been provided to present Allen County’s progress in funding its obligation to provide post-employment benefits to County employees. Required supplementary information can be found on pages 77 through 87 of this report. 9 ---PAGE BREAK--- GOVERNMENT-WIDE FINANCIAL ANALYSIS The County’s (primary government) assets and deferred outflows of resources exceeded liabilities and deferred inflows of resources by $500.2 million at the close of 2017, increasing the solid financial position of the County. The largest portion of the County’s total net position (total assets less total liabilities) is its investment in capital assets of $393.7 million or 78.7 percent. The capital assets decreased $6.3 million or 1.6 percent from 2016 due to the County removing bridges with a net value of $27.3 million as they are located within the City of Fort Wayne and now being maintained by the City. Capital assets include land, construction in progress, buildings and improvements, machinery and equipment, infrastructure, intangible assets and net investment in joint venture, less any outstanding debt used to acquire these assets. These assets are designated as invested in capital assets because they are used to provide the everyday services citizens of the County expect; they are not liquid and are not available for future spending. The debt associated with these capital assets must be paid from sources other than the capital assets themselves. The remainder of the County’s total net position is designated as either restricted or unrestricted. The restricted portion, which totals $12.7 million or 2.5 percent, is funds that is subject to an external restriction and cannot be spent on general daily operations. The unrestricted portion of the total net position increased $10.3 million. The main factor in this increase is a $19.3 million increase in cash and cash equivalents of governmental activities. This is somewhat offset by decreases in other assets and deferred outflows. Total liabilities also decreased by $8.5 million due to pay down of debt obligations outstanding. The County’s component units showed assets exceeding liabilities by $87.7 million at the end of 2017. Of the total net position, $44.3 million or 50.5% is invested in capital assets less any outstanding debt used to acquire these assets. These assets are designated as invested in capital assets because they are used to provide the everyday services to the users of the component units, these assets are not liquid and are not available for future spending. Similar to the County debt, it must be paid from other funding sources as the capital assets themselves are not liquid, nor can they be. The component units remaining assets were made up of $26.6 million or 30.4% of restricted dollars that are subject to an external restriction and $16.8 million or 19.1% of unrestricted dollars that can be used to provide daily operations for the component units. 2017 2016 2017 2016 2017 2016 2017 2016 Assets 162,226 $ 146,779 $ 12,980 $ 13,646 $ 175,206 $ 160,425 $ 53,770 $ 47,710 $ Capital assets 388,403 402,075 68,565 70,048 456,968 472,123 69,955 72,497 Total assets 550,629 548,854 81,545 83,694 632,174 632,548 123,725 120,207 Deferred Outflows 18,604 22,462 467 527 19,071 22,989 2,387 3,681 Current liabilities 19,048 18,519 5,181 5,453 24,229 23,972 7,393 7,380 Noncurrent liablilities 88,682 94,693 30,138 32,865 118,820 127,558 29,859 36,365 Total liabilities 107,730 113,212 35,319 38,318 143,049 151,530 37,252 43,745 Deferred Inflows 8,032 8,094 - - 8,032 8,094 1,170 1,164 Net Position 453,471 $ 450,010 $ 46,693 $ 45,903 $ 500,164 $ 495,913 $ 87,690 $ 78,979 $ Invested(Net) in capital assets 357,271 $ 364,386 $ 36,395 $ 35,620 $ 393,666 $ 400,006 $ 44,262 $ 40,635 $ Restricted 3,696 3,617 8,979 8,772 12,675 12,389 26,655 22,396 Unrestricted 92,504 82,007 1,319 1,511 93,823 83,518 16,773 15,948 Total net position 453,471 $ 450,010 $ 46,693 $ 45,903 $ 500,164 $ 495,913 $ 87,690 $ 78,979 $ Component Units County's Net Position (amounts expressed in thousands) Governmental Business-type Activities Activities Total 10 ---PAGE BREAK--- Governmental activities. Governmental activities account for 90.7% of the County’s total net position as of December 31, 2017. 2017 2016 2017 2016 2017 2016 2017 2016 Revenues: Program revenues: Charges for services 21,555 $ 23,616 $ 6,186 $ 5,676 $ 27,741 $ 29,292 $ 520 $ 595 $ Operating grants and contributions 29,151 36,137 - - 29,151 36,137 4,551 4,308 Capital grants and contributions 6,519 2,998 - - 6,519 2,998 - - General Revenue: Property taxes 73,254 69,618 - - 73,254 69,618 26,173 25,103 LIT Econ Development 8,243 6,971 - - 8,243 6,971 - - LIT Cert Shares and Public Safety 20,175 17,807 - - 20,175 17,807 4,307 - Excise/Commercial Veh taxes 5,900 4,760 - - 5,900 4,760 - - Franchise taxes 402 372 - - 402 372 - - Other taxes 5,761 4,181 - - 5,761 4,181 2,337 7,093 Food and beverage taxes - - 2,498 2,862 2,498 2,862 - - Sports and convention taxes - - 2,722 2,646 2,722 2,646 - - Unrestricted investment earnings 1,438 969 55 73 1,493 1,042 152 65 Misc and refund and reimbursement 3,266 3,999 - - 3,266 3,999 1,115 752 Total Revenues 175,664 171,428 11,461 11,257 187,125 182,685 39,155 37,916 Expenses: General government 53,150 48,423 - - 53,150 48,423 - - Public safety 65,980 63,795 - - 65,980 63,795 - - Highways and streets 11,166 14,848 - - 11,166 14,848 - - Sanitation 111 91 - - 111 91 - - Economic development 7,678 12,309 - - 7,678 12,309 - - Health and welfare 12,426 11,663 - - 12,426 11,663 - - Culture and recreation 705 703 - - 705 703 - - Coliseum - - 10,678 10,592 10,678 10,592 - - Southwest AC Fire District - - - - - - - - AC - Solid Waste District - - - - - - - - Allen County Public Library - - - - - - 30,444 33,685 Total expenses 151,216 151,832 10,678 10,592 161,894 162,424 30,444 33,685 Change in net position before special items 24,448 19,596 783 665 25,231 20,261 8,711 4,231 Change in net pension - - - - - - Change in OPEB liability (345) (238) - - (345) (238) - - Contributed capital 6,656 9,320 - - 6,656 9,320 - - Gain(Loss) on disposal of assets - - 7 - 7 - - - Loss on transfer of assets to City of Fort Wayne (27,298) - - - (27,298) - - - Change in net position 3,461 28,678 790 665 4,251 29,343 8,711 4,231 Net position- beginning 450,010 421,332 45,903 45,238 495,913 466,570 78,979 74,748 Net position- ending 453,471 $ 450,010 $ 46,693 $ 45,903 $ 500,164 $ 495,913 $ 87,690 $ 78,979 $ Component Units Total (Amounts expressed in thousands) Allen County Changes in Net Position Governmental Activities Business-type Activities 11 ---PAGE BREAK--- Expenses and Program Revenues – Governmental Activities Revenues by Source – Governmental Activities Expenses by Function/Program – Governmental Activities - 10,000 20,000 30,000 40,000 50,000 60,000 70,000 General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation 53,150 65,980 11,166 111 7,678 12,426 706 9,969 23,213 18,337 98 - 5,426 181 (In Thousands) Expenses Revenues Property tax 41.7% LIT Econ Development 4.7% LIT Cert Shares and Public Safety 11.5% Excise/Commercial Vehicle Excise taxes 3.4% Charges for services 12.3% Other taxes 3.3% Franchise taxes 0.2% Unrestricted investment earnings 0.8% Operating grants and contributions 16.6% Capital Grants and Contributions 3.7% Misc and refunds and reimbursements 1.8% General government 35.2% Public safety 43.6% Highways and streets 7.4% Economic development 5.1% Health and welfare 8.2% Culture, Recreation, & Sanitation 0.5% 12 ---PAGE BREAK--- Business-type activities. Business-type activities account for 9.3% of the County’s total net position as of December 31, 2017. The Allen County War Memorial Coliseum is the only branch of County government included in business-type activities. The Allen County War Memorial Coliseum had revenues totaling $11.5 million and incurred $10.7 million of expenses. During 2017, the total revenues included $6.2 million of program revenue and $5.3 million from the Food & Beverage Taxes, Sports & Convention Taxes, and unrestricted investment earnings. The Food & Beverage Tax revenue of $2.5 million shown in the financial statements is net of $4.9 million of revenues that were transferred to the Allen County-Fort Wayne Capital Improvement Board as they were not needed by the Coliseum for debt or lease obligations. Revenues by Source – Business-type Activities Governmental funds. The general government functions are contained in the General, Special revenue, Debt service, and Capital project funds. The focus of the County’s governmental funds is to provide information on near-term inflows, outflows, and balances of spendable resources (modified accrual). Such information is useful in assessing the County’s financing requirements. In accordance with GASB 54 fund balances are classified as such: Nonspendable, Restricted, Committed, Assigned, and Unassigned. The classifications are primarily based on the degree to which the County is bound by constraints on resources reported in the funds. Further detailed information regarding how the County’s resources are allocated into the above-mentioned classifications can be found in Note I, Section D, Subsection 10 of the notes to the financial statements. As of December 31, 2017, the County’s governmental funds reported a combined ending fund balance of $131.5 million, an increase of $11.2 million or 9.3 percent in comparison to December 31, 2016. Assets increased $12.5 million, overwhelmingly due to the $17.8 million increase in Cash and cash equivalents. Investments, receivables and assets held for resale all experienced decreases with a cumulative total of $5.3 million. Liabilities decreased by million due to less interfund loans outstanding while deferred inflows of resources increased $1.6 million as a result of unavailable income tax revenue. Approximately $1 million or .7 percent of the combined ending fund balance are assets held for resale and constitute the Nonspendable fund balance. The majority, $70 million or 53.3 percent, of County resources in the combined ending fund balance are Restricted for a specific purpose designated by enabling legislation, constitutional provision or external parties. Resources that are constrained by the highest level of decision making authority, which is the County Council and County Commissioners, are classified as Committed and account for $22.2 million or 16.9 percent of the combined ending fund balance. Assigned resources comprise $14.6 million or 11.1 percent of the combined ending fund balance are intended to be used for specific resources of the primary government but do not meet the criteria to be classified as Nonspendable, Restricted, or Committed. The General Fund had an Unassigned Fund balance of $24.7 million and the overall Unassigned Fund balance at December 31, 2017, was $23.7 million or 18%. Unassigned fund balances represent resources that do not fall into any Charges for services 54.0% Sports and convention tax 23.7% Food and beverage tax 21.8% Unrestricted investment earnings 0.5% 13 ---PAGE BREAK--- of the other classifications and only the General fund may report positive Unassigned balances. Other Governmental funds may report negative Unassigned fund balances in instances where expenditures exceed the Restricted, Committed, or Assigned resources of the fund. At December 31, 2017, approximately $1 million of negative Unassigned fund balance was reported in the Other Governmental Funds. With the exception of a very minor amount due to grant reimbursement and adult probation funds, this negative Unassigned fund balance is related to Tax Increment Finance (TIF) district infrastructure improvement expenditures that are financed through interfund loans and are being repaid as TIF property tax revenues are collected. The General Fund is the chief operating fund of the County. At December 31, 2017, the combined fund balance of the Assigned and Unassigned classifications in the General Fund was $25.5 million. As a measure of the General Fund liquidity, you can compare the combined fund balance of these classifications to the total expenditures. The General Fund expenditures for fiscal year ended 2017 were $90.7 million. Thus, the amount of resources determined to be readily available for expenditure and not bound to restriction or constraint, represents 28.08 percent of the General Fund expenditures for 2017. This ratio increased by approximately 44 percent from 2016. The fund balance of the County General Fund increased by $9.7 million during fiscal year ended 2017. This is largely due to General Fund revenues exceeding expenditures by $7.6 million and a net transfer in of $2.1 million. The General Fund cash and cash equivalents increased $10.4 million and can be attributed to a $3.8 million increase in tax collections, a $2.1 million net transfer in from the previous COIT Fund and the Auditors Ineligible Deduction Fund, and the remainder the result of unspent appropriations. In comparison to 2016, General Fund revenues increased $4.6 million or 4.9% while expenses increased at about half the pace going up $2.4 million or 2.7% from 2016. In addition to the General Fund, the County has two other funds that meet the major fund criteria, which are: the County’s Rainy Day Fund and the Local Income Tax Economic Development Fund. The County’s Rainy Day Fund provides stability to government services and programs during an economic downturn and has also been used as a source of internal financing for certain capital purchases in order to avoid external financing related borrowing costs. The County’s Rainy Day Fund was first established in 2004 and has an assigned fund balance of $13.3 million at the end of 2017. During 2017 the Rainy Day Fund’s only activity was the generation of million interest revenue. The LIT Economic Development Fund is primarily used to fund economic development initiatives and the related infrastructure, as well as other general infrastructure improvements throughout the County. The LIT Economic Development Fund had a fund balance of $19.7 million at the end of 2017. This is a $.04 million or .2 percent increase over 2016 as a result of the net transfer out of $2 million to the Allen County Redevelopment Capital Fund almost completely offsetting the excess of revenues over expenditures. Total Other Governmental Fund revenue decreased $6.3 million for 2017 mainly due to the almost $5 million 2016 SEA 67 supplemental income tax distribution we received. Other Governmental expenditures increased $2.6 mil driven by debt service and economic development expenditures. Overall the Other Governmental Funds 2017 ending fund balance of $72.4 million is a $1.3 million increase from 2016 that reflects the amount revenues exceeded expenditures. Proprietary funds. The County’s proprietary funds provide the same type of information found in the government-wide financial statements, but in more detail. Unrestricted net position amounted to $1.3 million for the Allen County War Memorial Coliseum and $8.8 million for the County’s Internal Service funds. Factors concerning the finances of the Allen County War Memorial Coliseum were previously addressed in the discussion of the County’s business-type activities. To summarize, the Coliseum had a net operating loss of $3.4 million that was offset by non-operating revenue of $4.1 million increasing total net position by million to $46.7 million. The County’s internal service fund is primarily a Health Self-Insurance fund. The 2017 contributions to the Health Self- Insurance fund were approximately $1.1 million more than expenses and is the result of the total net position increase. The County continued the trend of minimal increases in health insurance claims which dropped by million from 2016. 14 ---PAGE BREAK--- GENERAL FUND BUDGETARY HIGHLIGHTS The County’s final General Fund budget for 2017 exceeded its original budget by approximately $1.3 million or 1.4%. The key elements of the difference between the original budget and final budget are listed below:  million was related to a pass-through property tax payment to Easter Seals Arc from December 2016 that was not paid until January of 2017 and property tax refunds.  million was due to increasing the Election Board budget for the purchase of Voting Machines and security system Actual expenditures were approximately $5 million less than final budgeted appropriations. The significant unspent appropriations primarily consisted of $1.9 million in salaries and benefits which are related to turnover and unfilled positions throughout various departments with the highest being the Allen County Juvenile Center at million; $2.9 million in services including $2 million of unspent County Council contractual monies budgeted for the Public Defender lawsuit that were not needed, and lastly a combined million in Supplies and Capital. For year-end December 31, 2017, General Fund revenues received were approximately $6.5 million greater than budgeted. Some of the significant contributions to actual revenues exceeding the budgeted figures are:  collection of approximately $2 million more in property taxes  $1.3 million more in vehicle excise tax dollars  million more than estimated for public defender reimbursement  an additional $1.3 million reimbursement for care of prisoner’s  million more interest revenue  million greater reimbursement for the Northeast Regional Coordinating Council  million in additional building permit revenue. CAPITAL ASSETS AND DEBT ADMINISTRATION Capital assets. The County’s investment in capital assets for its governmental and business-type activities as of December 31, 2017 was $457 million (net of accumulated depreciation), a decrease of $15.2 million or (3.2) percent. The decrease is for the most part due to the previously mentioned $27.3 million transfer of bridge assets from the County to the City of Fort Wayne as they were located within the incorporated area and now being maintained by the City of Fort Wayne. This investment in capital assets includes land and easements, infrastructure, construction in progress, buildings and improvements, equipment, intangible assets and net investment in joint venture. 15 ---PAGE BREAK--- 2017 2016 2017 2016 2017 2016 Land and easements 10,583 $ 10,501 $ 381 $ 381 $ 10,964 $ 10,882 $ Construction in progess 61,019 56,276 54 17,796 61,073 74,072 Buildings and improvements 73,657 77,805 65,109 48,472 138,766 126,277 Machinery and equipment 11,291 12,050 3,021 3,399 14,312 15,449 Infrastructure being depreciated 228,632 242,097 - - 228,632 242,097 Intangible assets 405 363 - - 405 363 Net investment in joint venture 2,816 2,983 - - 2,816 2,983 388,403 $ 402,075 $ 68,565 $ 70,048 $ 456,968 $ 472,123 $ Total Governmental Activities Business-type Activities Primary Government Capital Assets (net of depreciation) (amounts expressed in thousands) The County’s infrastructure assets are recorded at historical costs in the government-wide financials as required by GASB Statement No. 34. The County has elected to use the straight-line depreciation method to report these assets as opposed to the modified approach. Additional information on the County’s capital assets can be found in Note III.B on pages 46 and 48 of this report. Long-term debt. At December 31, 2017, the County had total debt outstanding of $63.8 million. Of this amount, $38.7 million of first mortgage bonds, $25.1 million of revenue bonds. 2017 2016 2017 2016 2017 2016 General Obligation Bonds - $ - $ - $ - $ - $ - $ First Mortgage Bonds 6,076 10,202 32,638 34,955 38,714 45,157 Revenue Bonds 25,057 27,488 - - 25,057 27,488 31,133 $ 37,690 $ 32,638 $ 34,955 $ 63,771 $ 72,645 $ Total Governmental Activities Business-type Activities Primary Government Outstanding Debt General Obligation Bonds, First Mortgage Bonds, and Revenue Bonds (including bond discounts, premiums or losses) (amounts expressed in thousands) Outstanding debt decreased $8.9 million or 12.2 percent, which is due to regularly scheduled debt service payments and bond refunding. Bond refunding was done for outstanding issuances related to the Coliseum, Maplecrest Rd Bridge Bonds, and the Jail Building Corp bonds. The County currently maintains an Aa3 Underlying rating from Moody’s Investor Services for the 2016 Jail Building first mortgage bonds, and the Memorial Coliseum first mortgage series 2016, 2014 and 2011. Moody’s provided an Aa2 Underlying rating for the 2016 Maplecrest Bridge Revenue Bonds. Approximately $1.6 million of the 2011 Juvenile Justice Center bonds remaining from the 2004 series refunding and all three Series of the 2015 General Motors Tax Increment Revenue bonds have an A2 rating. At December 31, 2017 the County had a net pension liability of $56 million which is million or (1.5) percent less than the December 31, 2016 net pension liability. Deferred outflows of resources related to pensions were $16.8 million compared with $8 million in deferred inflows of resources related to pensions. 16 ---PAGE BREAK--- In addition to the indebtedness noted above, the County also has long-term liabilities for compensated absences and other post-employment benefits totaling $10.2 million at December 31, 2017 compared with $9.8 million at year end 2016. The million or 5.2 percent increase is broken down as million increase in other post-employment benefits and million in compensated absences. Additional information on the County’s long-term debt can be found in Note III.D on pages 48 through 51 of this report. ECONOMIC FACTORS AND NEXT YEAR’S BUDGET AND RATES  The County is located in northeastern Indiana, approximately 125 miles northeast of Indianapolis. The County is the largest county in the State of Indiana in terms of square miles. The City of Fort Wayne is the second largest city in the state and serves as the economic hub for the area. The west central part of the County is dominated by the City of Fort Wayne with approximately 71% of the County’s population. The eastern half of the county is largely agricultural with several small cities and towns.  Going into 2018, the County does not expect any slowdown in the current economic environment. The local real estate market continues to be a “seller’s market” and that correlates with the 3.64% increase in net assessed value from 2017 to 2018. This is the largest year over year increase in over 10 years. This is a driving factor in property tax revenues. Our second largest source of revenue, income tax, increased 1.3% from 2017. Unemployment rates continue to remain at historical lows because of greater employment. Our labor force has remained relatively constant from 2016 to 2017 all the while the average unemployment rate dropped from 4.6% to below 4% heading into 2018. This is indicative of more people actively working. We foresee this trend continuing through 2019. Economic development efforts are still moving very aggressively to attract not only new businesses but the expansion of existing businesses.  The County continues to operate as efficiently as possible within our available funding sources. As evident in our growing net position, but more importantly the growth in our Unrestricted Net position, the County continues to operate with a balanced budget. As previously mentioned and can be seen in the notes to the financial statements, the County indebtedness for the Juvenile Justice Center and the Jail will both be paid off come 2020 and therefore removed from the property tax levy. The overall County budget increased approximately 7% into 2018, but the overall majority of this is related to one-time economic development efforts that may go unspent. The actual General Fund budget increase into 2018 was roughly The County continues to revisit its operations and strategic plan to ensure we are optimizing the tax dollar and positioning ourselves to maintain fiscal stability. These factors along with others were considered when preparing the County’s budget for the 2018 fiscal year. REQUEST FOR INFORMATION This financial report is designed to provide a general overview of the County’s finances for all of those with an interest in the County’s finances (including the County’s taxpayers, citizens, investors, creditors, and customers). Questions concerning any of the information provided in this report or requests for additional financial information should be addressed to the Allen County Auditor, 1 East Main Street, Suite 102, Fort Wayne, Indiana 46802-1887 or [EMAIL REDACTED]. 17 ---PAGE BREAK--- BASIC FINANCIAL STATEMENTS AND ACCOMPANYING NOTES The financial statements and accompanying notes were prepared by management of the County. The financial statements and notes are presented as intended by the County. 18 ---PAGE BREAK--- Governmental Business-Type Component Assets Activities Activities Totals Units Cash and cash equivalents - unrestricted 133,659,011 $ 871,711 $ 134,530,722 $ 32,843,433 $ Investments - unrestricted 12,940,382 78,596 13,018,978 18,002,949 Receivables (net of allowances for uncollectibles): Interest 165,545 1,021 166,566 84,764 Taxes 9,824,839 - 9,824,839 1,221,687 Accounts 1,025,877 214,699 1,240,576 70,000 Special assessments 114,113 - 114,113 - Intergovernmental 1,537,160 - 1,537,160 1,136,985 Suite - 580,250 580,250 - Other - - - 279,575 Inventories 1,371,263 - 1,371,263 - Prepaid expense 621,176 131,742 752,918 130,639 Assets held for resale 966,088 - 966,088 - Restricted assets: Cash and cash equivalents - restricted - 8,063,335 8,063,335 - Cash with fiscal agent - restricted - 63,991 63,991 - Investments - restricted - 633,910 633,910 - Interest receivable - 8,231 8,231 - Taxes receivable - 2,010,054 2,010,054 - Suite receivable - 322,000 322,000 - Capital assets: Land and construction in progress 71,602,039 434,531 72,036,570 5,954,969 Other capital assets, net of depreciation 316,801,373 68,130,569 384,931,942 64,000,071 Total assets 550,628,866 81,544,640 632,173,506 123,725,072 Deferred Outflows of Resources Unamortized loss on refunding 1,828,460 467,199 2,295,659 - Pension related 16,775,492 - 16,775,492 2,387,014 Total deferred outflow of resources 18,603,952 467,199 19,071,151 2,387,014 Liabilities Accounts payable 4,545,340 131,797 4,677,137 904,709 Accrued payroll and withholdings payable 4,146,166 162,771 4,308,937 412,399 Taxes payable - 5,175 5,175 - Accrued interest payable - - - 125,471 Incurred but not reported claims 1,344,358 - 1,344,358 - Unearned revenue - 1,325,338 1,325,338 - Payable from restricted assets: Accounts payable - 112,520 112,520 - Ticket office customer deposits payable - 570,975 570,975 - First mortgage revenue bonds - due within one year - 2,500,000 2,500,000 - Accrued interest payable 335,993 227,274 563,267 - Noncurrent liabilities: Due within one year: First mortgage general obligation bonds payable 2,991,536 - 2,991,536 5,825,000 Compensated absences 3,474,570 145,618 3,620,188 125,283 Revenue bonds payable 2,210,000 - 2,210,000 - Due in more than one year: First mortgage general obligation bonds payable (net of premium) 3,084,078 - 3,084,078 19,415,891 First mortgage revenue bonds payable (net of premium) - 30,137,649 30,137,649 - Compensated absences - - - 626,416 Revenue bonds payable (net of premium/discounts) 22,846,689 - 22,846,689 - Unearned revenue - - - 1,006,539 Net pension liability 55,997,630 - 55,997,630 8,810,210 Other postemployment benefits liability 6,753,669 - 6,753,669 - Total liabilities 107,730,029 35,319,117 143,049,146 37,251,918 Deferred Inflows of Resources Unamortized gain on refunding 59,923 - 59,923 383,133 Pension related 7,971,636 - 7,971,636 786,631 Total deferred inflows of resources 8,031,559 - 8,031,559 1,169,764 Net position Net investment in capital assets 357,271,109 36,394,650 393,665,759 44,261,907 Restricted for: Capital projects - 63,991 63,991 3,643,391 Debt service 2,388,106 - 2,388,106 7,110,328 Perpetual endowment subject to donor stipulations - - - 9,000,000 Perpetual endowment subject to time restrictions - - - 2,542,385 Other purposes 1,307,513 8,914,964 10,222,477 4,359,412 Unrestricted 92,504,502 1,319,117 93,823,619 16,772,981 Total net position 453,471,230 $ 46,692,722 $ 500,163,952 $ 87,690,404 $ The notes to the financial statements are an integral part of this statement. Primary Government ALLEN COUNTY STATEMENT OF NET POSITION December 31, 2017 19 ---PAGE BREAK--- Operating Capital Charges for Grants and Grants and Governmental Business-Type Component Functions/Programs Expenses Services Contributions Contributions Activities Activities Totals Unit Primary government: Governmental activities: General government 53,149,582 $ 6,878,005 $ 3,091,412 $ - $ (43,180,165) $ - $ (43,180,165) $ - $ Public safety 65,980,252 11,271,983 11,941,216 - (42,767,053) - (42,767,053) - Highways and streets 11,166,141 574,136 11,244,235 6,518,597 7,170,827 - 7,170,827 - Sanitation 110,791 98,100 - - (12,691) - (12,691) - Economic development 7,677,912 - - - (7,677,912) - (7,677,912) - Health and welfare 12,426,110 2,570,145 2,855,785 - (7,000,180) - (7,000,180) - Culture and recreation 705,526 162,409 18,453 - (524,664) - (524,664) - Total governmental activities 151,216,314 21,554,778 29,151,101 6,518,597 (93,991,838) - (93,991,838) - Business-type activities: Coliseum 10,678,397 6,185,866 - - - (4,492,531) (4,492,531) - Total primary government 161,894,711 $ 27,740,644 $ 29,151,101 $ 6,518,597 $ (93,991,838) (4,492,531) (98,484,369) - Component unit: Allen County Public Library 30,443,998 520,472 4,551,316 - - - - (25,372,210) General revenues: Property taxes 73,254,140 - 73,254,140 26,173,265 LIT economic development 8,243,097 - 8,243,097 - LIT distributive shares 20,175,186 20,175,186 4,306,770 Excise/Commercial Vehicle Excise Taxes 5,899,886 - 5,899,886 - Franchise taxes 401,780 401,780 Other taxes 5,761,135 - 5,761,135 2,337,436 Food and beverage taxes - 2,497,810 2,497,810 - Sports and convention taxes - 2,722,021 2,722,021 - Unrestricted investment earnings 1,438,054 55,548 1,493,602 151,581 Miscellaneous and refunds and reimbursements 3,266,155 - 3,266,155 1,114,702 Change in postemployment benefits liability (345,089) - (345,089) - Capital contributions 6,656,000 6,656,000 - Gain on disposal of assets - 7,372 7,372 - Loss on transfer of assets to City of Fort Wayne (27,297,602) - (27,297,602) - Total general revenues 97,452,742 5,282,751 102,735,493 34,083,754 Change in net position 3,460,904 790,220 4,251,124 8,711,544 Net position - beginning 450,010,326 45,902,502 495,912,828 78,978,860 Net position - ending 453,471,230 $ 46,692,722 $ 500,163,952 $ 87,690,404 $ The notes to the financial statements are an integral part of this statement. Program Revenues Net (Expense) Revenue and Changes in Net Position Primary Government ALLEN COUNTY STATEMENT OF ACTIVITIES For The Year Ended December 31, 2017 20 ---PAGE BREAK--- Local Income Other Tax - Economic Governmental Assets General Rainy Day Development Funds Totals Cash and cash equivalents 25,114,622 $ 11,663,828 $ 17,816,461 $ 69,004,065 $ 123,598,976 $ Investments 4,064,141 1,124,039 1,899,723 5,560,630 12,648,533 Receivables (net of allowances for uncollectibles): Interest 84,055 14,596 - 63,104 161,755 Taxes 6,702,762 - 1,848,466 1,273,611 9,824,839 Accounts 340,362 - - 528,085 868,447 Special assessments - - - 114,113 114,113 Intergovernmental 635,641 - 342,003 559,516 1,537,160 Interfund receivable: Interfund loans 107,287 473,850 537,433 825,381 1,943,951 Assets held for resale - - - 966,088 966,088 Total assets 37,048,870 $ 13,276,313 $ 22,444,086 $ 78,894,593 $ 151,663,862 $ Liabilities, Deferred Inflows of Resources, Fund Balances Liabilities: Accounts payable 1,007,651 $ - $ 859,731 $ 2,336,830 $ 4,204,212 $ Accrued payroll and withholdings payable 3,183,814 - 13,368 948,984 4,146,166 Interfund payable: Interfund loans - - - 1,943,951 1,943,951 Total liabilities 4,191,465 - 873,099 5,229,765 10,294,329 Deferred inflows of resources: Unavailable revenue - property taxes 2,212,786 - - 395,537 2,608,323 Unavailable revenue - license excise taxes 582,642 - - 104,146 686,788 Unavailable revenue - income taxes 3,907,334 - 1,848,466 773,928 6,529,728 Total deferred inflows of resources 6,702,762 - 1,848,466 1,273,611 9,824,839 Fund balances: Nonspendable fund balance - - - 966,088 966,088 Restricted fund balance - - 1,307,513 68,745,034 70,052,547 Committed fund balance 675,198 - 18,415,008 3,081,122 22,171,328 Assigned fund balance 743,863 13,276,313 - 636,622 14,656,798 Unassigned fund balance 24,735,582 - - (1,037,649) 23,697,933 Total fund balances 26,154,643 13,276,313 19,722,521 72,391,217 131,544,694 Total liabilities, deferred inflows of resources, and fund balances 37,048,870 $ 13,276,313 $ 22,444,086 $ 78,894,593 $ Amounts reported for governmental activities in the Statement of Net Position are different because: Capital assets used in governmental activities are not financial resources and, therefore, are not reported in the funds. 388,403,412 Other long-term assets are not available to pay for current-period expenditures and, therefore, are deferred in the funds. 28,592,770 Internal service funds are used by management to charge the costs of certain services to individual funds. The assets and liabilities of the internal service funds are included in governmental activities in the Statement of Net Position. 8,827,618 Long-term liabilities, including bonds payable, are not due and payable in the current period and, therefore, are not reported in the funds. (41,145,965) Net pension liabilities are not due and payable in the current period and, therefore, are not reported in the funds. (55,997,630) Net other postemployment benefits liability is not due and payable in the current period and, therefore, is not reported in the funds. (6,753,669) Net position of governmental activities 453,471,230 $ ALLEN COUNTY BALANCE SHEET - GOVERNMENTAL FUNDS December 31, 2017 The notes to the financial statements are an integral part of this statement. 21 ---PAGE BREAK--- Local Income Other Total Tax - Economic Governmental Governmental General Rainy Day Development Funds Funds Revenues: Taxes 74,738,260 $ - $ 7,614,101 $ 20,235,081 $ 102,587,442 $ Special assessments - - - 778,920 778,920 Licenses and permits 2,692,642 - - 35,440 2,728,082 Intergovernmental 12,867,543 - 5,544,869 25,984,893 44,397,305 Charges for services 3,677,877 - - 11,097,175 14,775,052 Fines and forfeits 1,158,323 - - 2,489,164 3,647,487 Other 3,249,107 132,452 - 1,631,189 5,012,748 Total revenues 98,383,752 132,452 13,158,970 62,251,862 173,927,036 Expenditures: Current: General government 41,221,815 - - 3,937,135 45,158,950 Public safety 42,877,669 - - 20,401,158 63,278,827 Highways and streets - - - 13,789,574 13,789,574 Sanitation - - - 110,791 110,791 Economic development 36,394 - - 20,669 57,063 Health and welfare 6,016,595 - - 6,351,618 12,368,213 Culture and recreation 573,762 - - 153,247 727,009 Debt service: Principal - - - 6,260,000 6,260,000 Interest - - - 1,084,448 1,084,448 Capital outlay: Economic development - - 11,085,239 8,319,045 19,404,284 Special assessment - - - 453,727 453,727 Total expenditures 90,726,235 - 11,085,239 60,881,412 162,692,886 Excess of revenues over expenditures 7,657,517 132,452 2,073,731 1,370,450 11,234,150 Other financing sources (uses): Transfers in 2,217,721 - 313,737 8,828,178 11,359,636 Transfers out (145,000) - (2,350,000) (8,864,636) (11,359,636) Total other financing sources and uses 2,072,721 - (2,036,263) (36,458) - Net change in fund balances 9,730,238 132,452 37,468 1,333,992 11,234,150 Fund balances - beginning 16,424,405 13,143,861 19,685,053 71,057,225 120,310,544 Fund balances - ending 26,154,643 $ 13,276,313 $ 19,722,521 $ 72,391,217 $ 131,544,694 $ ALLEN COUNTY STATEMENT OF REVENUES, EXPENDITURES ,AND CHANGES IN FUND BALANCES - GOVERNMENTAL FUNDS For The Year Ended December 31, 2017 The notes to the financial statements are an integral part of this statement. 22 ---PAGE BREAK--- Net change in fund balances - total governmental funds (Statement of Revenues, Expenditures and Changes in Fund Balances). 11,234,150 $ 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, which meet capitalization requirements, is capitalized. The cost of depreciable assets is allocated over the estimated useful lives and reported as depreciation expense (functionalized). Capital assets not being depreciated: Land 81,806 Construction in progress 4,743,298 Total change in capital assets not being depreciated 4,825,104 Capital assets being depreciated: Buildings, net of $713,199 depreciation expense (4,134,521) Improvements other than buildings, net of $13,884 depreciation expense (13,884) Machinery and equipment, net of $1,627,889 depreciation expense (758,069) Infrastructure, net of $7,746,038 depreciation expense 13,832,810 Net investment in joint venture, net of $143,045 depreciation expense (167,609) Intangible assets, net of $37,033 depreciation expense 41,417 Total change in capital assets being depreciated 8,800,144 Net effect of of transfer of infrastructure capital assets to the City of Fort Wayne (27,297,601) Total changes in capital assets (13,672,353) Revenues in the Statement of Activities that do not provide current financial resources are not reported as revenues in the governmental funds. 1,597,493 The issuance of long-term debt provides current financial resources to governmental funds, but increases the long-term liabilities on the Statement of Net Position. Repayment of principal for long-term debt consumes the current financial resources of governmental funds, but reduces long-term liabilities in the Statement of Net Position. This is the amount by which issuance repayments exceeds issuance proceeds. 6,260,000 Governmental funds report the effect of deferred loss on refunding, discounts and premiums when debt is first issued, whereas these amounts are deferred and amortized in the Statement of Activities. 123,267 Some expenses were deferred as assets in the Statement of Net Position and, therefore, were not reported in the Statement of Activities, but were reported as expenditures in the governmental funds. 97,742 Net pension liabilities are considered a long-term obligation of the general government, but are not current expenditures. (2,763,950) Other postemployment benefits liability is considered a long-term obligation of the general government, but is not a current expenditure. (345,089) Some expenses reported in the Statement of Activities do not require the use of current financial resources and, therefore, are not reported as expenditures in governmental funds. (247,472) Internal service funds are used by management to charge the costs of certain activities to individual funds. The net revenue (expense) of the internal service funds is reported with governmental activities. 1,177,116 Change in net position of governmental activities (Statement of Activities) 3,460,904 $ The notes to the financial statements are an integral part of this statement. ALLEN COUNTY 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, 2017 23 ---PAGE BREAK--- Business-Type Activities - Enterprise Fund War Memorial Internal Assets Coliseum Service Funds Current assets: Cash and cash equivalents 871,711 $ 10,060,035 $ Investments 78,596 291,849 Interest receivable 1,021 3,790 Accounts receivable (net of allowance) 214,699 157,430 Suite receivable 580,250 - Prepaid items 131,742 - Total current assets 1,878,019 10,513,104 Noncurrent assets: Restricted cash, cash equivalents and investments: Cash and cash equivalents 8,063,335 - Cash with fiscal agent 63,991 - Investments 633,910 - Interest receivable 8,231 - Taxes receivable 2,010,054 - Suite receivable 322,000 - Capital assets: Land, and construction in progress 434,531 - Other capital assets (net of accumulated depreciation) 68,130,569 - Total noncurrent assets 79,666,621 - Deferred Outflows of Resources Unamortized loss on refunding 467,199 - Liabilities Current liabilities: Accounts payable 131,797 341,128 Accrued wages payable 162,771 - Taxes payable 5,175 - Compensated absences 145,618 - Incurred but not reported claims - 1,344,358 Unearned revenue 1,325,338 - Current liabilities payable from restricted assets: Accounts payable 112,520 - Ticket office customer deposits 570,975 - First mortgage revenue bonds payable 2,500,000 - Accrued interest payable 227,274 - Total current liabilities 5,181,468 1,685,486 Noncurrent liabilities: First mortgage revenue bonds payable (net of unamortized premium) 30,137,649 - Total liabilities 35,319,117 1,685,486 Net position Net investment in capital assets 36,394,650 - Restricted for capital assets 63,991 - Restricted for other purposes 8,914,964 - Unrestricted 1,319,117 8,827,618 Total net position 46,692,722 $ 8,827,618 $ ALLEN COUNTY STATEMENT OF NET POSITION - PROPRIETARY FUNDS December 31, 2017 The notes to the financial statements are an integral part of this statement. 24 ---PAGE BREAK--- Business-Type Activities - Enterprise Fund War Memorial Internal Coliseum Service Funds Operating revenues: Miscellaneous 427,587 $ 100,969 $ Rent 1,163,966 - Concessions 1,350,334 - Parking 1,597,007 - Ticket office 279,737 - Advertising 315,821 - Arena maintenance fee 346,348 - Suite/club seats 693,691 - Advance forfeiture rent 11,375 - Employee/employer contributions - 14,219,136 Total operating revenues 6,185,866 14,320,105 Operating expenses: Salaries and wages 2,531,270 - Fringe benefits 691,358 - Materials and supplies 1,564,741 - Purchased services 50,505 - Utilities 742,545 - Miscellaneous 178,506 - Maintenance and repair 542,493 - Insurance claims and expenses - 13,181,400 Depreciation 3,236,339 - Total operating expenses 9,537,757 13,181,400 Operating Income (loss) (3,351,891) 1,138,705 Nonoperating revenues (expenses): Interest and investment revenue 55,548 38,411 Food and beverage taxes 2,497,810 - Sports and convention taxes 2,722,021 - Amortization of loss on bond refunding (59,642) - Interest expense (1,080,998) - Gain on disposal of assets 7,372 - Total nonoperating revenue 4,142,111 38,411 Change in net position 790,220 1,177,116 Total net position - beginning 45,902,502 7,650,502 Total net position - ending 46,692,722 $ 8,827,618 $ ALLEN COUNTY STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN FUND NET POSITION - PROPRIETARY FUNDS For The Year Ended December 31, 2017 The notes to the financial statements are an integral part of this statement. 25 ---PAGE BREAK--- Business-Type Activities - Enterprise Fund War Memorial Internal Coliseum Service Funds Cash flows from operating activities: Receipts from customers and users 6,185,544 $ 14,213,520 $ Payments to suppliers (4,412,076) (12,977,147) Payments to employees (2,473,010) - Other receipts - 21,483 Net cash provided (used) by operating activities (699,542) 1,257,856 Cash flows from capital and related financing activities: Acquisition and construction of capital assets (1,746,383) - Principal paid on capital debt (2,090,000) - Interest paid on capital debt (1,297,474) - Food and beverage taxes 2,747,240 - Sports and convention taxes 2,685,900 - Net cash provided by capital and related financing activities 299,283 - Cash flows from investing activities: Proceeds from sales and maturities of investments 980,195 428,838 Purchase of investments (712,506) (291,849) Interest received 51,676 37,139 Net cash provided by investing activities 319,365 174,128 Net increase (decrease) in cash and cash equivalents (80,894) 1,431,984 Cash and cash equivalents, January 1 9,079,931 8,628,051 Cash and cash equivalents, December 31 8,999,037 $ 10,060,035 $ Reconciliation of operating income (loss) to net cash provided by operating activities: Operating income (loss) (3,351,891) $ 1,138,705 $ Adjustments to reconcile operating income (loss) to net cash provided by operating activities: Depreciation expense 3,236,339 - (Increase) in assets: Accounts receivable (31,706) (85,102) Prepaid items (2,009) - Increase (decrease) in liabilities: Customer deposits (704,154) - Accrued wages payable (17,479) - Accounts payable 62,446 (116,381) Unavailable revenue 31,384 - Taxes payable 1,789 - Compensated absence payable 75,739 - Incurred but not reported claims - 320,634 Total adjustments 2,652,349 119,151 Net cash provided (used) by operating activities (699,542) $ 1,257,856 $ ALLEN COUNTY STATEMENT OF CASH FLOWS - PROPRIETARY FUNDS For The Year Ended December 31, 2017 The notes to the financial statements are an integral part of this statement. 26 ---PAGE BREAK--- Pension Trust Agency Assets Funds Funds Cash and cash equivalents 3,585,255 $ 17,895,245 $ Receivables: Taxes - 43,404,339 Accounts - 97,417 Interest and dividends 31,412 - Intergovernmental - 3,402,986 Contributions 17,771 - Total receivables 49,183 46,904,742 Investments at fair value: U.S. government securities - 8,553 Shares of unit investment trusts 49,788,390 - Total investments 49,788,390 8,553 Total assets 53,422,828 $ 64,808,540 $ Liabilities Payroll withholdings payable - $ 46,706 $ Intergovernmental payable - 105,867 Trust payable - 64,655,967 Total liabilities - 64,808,540 $ Net Position Net position held in trust for: Employees' pension benefits 53,422,828 Total net position restricted for pensions 53,422,828 $ ALLEN COUNTY STATEMENT OF FIDUCIARY NET POSITION - FIDUCIARY FUNDS December 31, 2017 The notes to the financial statements are an integral part of this statement. 27 ---PAGE BREAK--- Pension Trust Additions Funds Contributions: Employer 2,180,137 $ Plan members 224,832 Total contributions 2,404,969 Investment income: Net increase in fair value of investments 4,931,270 Interest 1,247,941 Net investment income 6,179,211 Total additions 8,584,180 Deductions Benefits 2,815,096 Administrative expense 107,603 Total deductions 2,922,699 Changes in net position 5,661,481 Net position - beginning 47,761,347 Net position - ending 53,422,828 $ The notes to the financial statements are an integral part of this statement. ALLEN COUNTY STATEMENT OF CHANGES IN FIDUCIARY NET POSITION - FIDUCIARY FUNDS For The Year Ended December 31, 2017 28 ---PAGE BREAK--- ALLEN COUNTY NOTES TO FINANCIAL STATEMENTS I. Summary of Significant Accounting Policies A. Reporting Entity Allen County (primary government) was established under the laws of the State of Indiana. The primary government operates under a council-commissioner form of government and provides the following services: public safety (police and fire), highways and streets, health, welfare and social services, culture and recreation, public improvements, planning and zoning, and general administrative services. The accompanying financial statements present the activities of the primary government and its significant component units. The component units discussed below are included in the primary government's reporting entity because of the significance of their operational or financial relationships with the primary government. Blended component units, although legally separate entities are in substance part of the government's operations and exist solely to provide services for the government; data from these units is combined with data of the primary government. Discretely presented component units are involved in activities of an operational nature independent from the government; their transactions are reported in a separate column in the government-wide financial statements to emphasize that it is legally separate from the government. Blended Component Units The Allen County Jail Building Corporation is a significant blended component unit of the primary government. The primary government appoints a voting majority of the Jail Building Corporation's board and a financial benefit/burden relationship exists between the primary government and the Jail Building Corporation. Although it is legally separate from the primary government, the Allen County Jail Building Corporation is reported as if it were a part of the primary government because it provides services entirely or almost entirely to the primary government. The Allen County Juvenile Justice Center Building Corporation is a significant blended component unit of the primary government. The primary government appoints a voting majority of the Juvenile Justice Center Building Corporation’s board and a financial benefit/burden relationship exists between the primary government and the Juvenile Justice Center Building Corporation. Although it is legally separate from the primary government, the Allen County Juvenile Justice Center Building Corporation is reported as if it were a part of the primary government because it provides services entirely or almost entirely to the primary government. The Allen County War Memorial Coliseum Additions Building Corporation is a significant blended component unit of the primary government. The primary government appoints a voting majority of the Allen County War Memorial Coliseum Additions Building Corporation’s board and a financial benefit/burden relationship exists between the primary government and the Allen County War Memorial Coliseum Additions Building Corporation. Although it is legally separate from the primary government, the Allen County War Memorial Coliseum Additions Building Corporation is reported as if it were a part of the primary government because it provides services entirely or almost entirely to the primary government. Discretely Presented Component Unit The Allen County Public Library is a significant discretely presented component unit of the primary government. The primary government appoints a voting majority of the Allen County Public Library’s Board and is able to impose its will. It would be misleading to exclude the Allen County Public Library from the primary government’s financial statements because of its relationship with the primary government. 29 ---PAGE BREAK--- The financial statements of the individual component units may be obtained from their respective offices as follows: Allen County Jail Building Corporation c/o U.S. National Bank Association 10 W. Market Street, Suite 1150 Indianapolis, IN 46204 Allen County Juvenile Justice Center Building Corporation c/o Wells Fargo Bank Corporate Trust Department 111 E. Wayne Street Fort Wayne, IN 46801 Allen County War Memorial Coliseum Additions Building Corporation c/o Wells Fargo Bank Corporate Trust Department 111 E. Wayne Street Fort Wayne, IN 46801 Allen County Public Library 900 Library Plaza Fort Wayne, IN 46802 Joint Venture The primary government is a participant in a joint venture agreement with the City of Fort Wayne (City) for the operation of the City-County Building’s Plaza Parking Garage (Garage). The County and City each appoint three members of the Garage’s Condominium Association (Association). The County and City jointly appoint the seventh member. The Association is a not-for-profit corporation and is responsible for the operation of the garage. The County and City each have a 50 percent equity interest in the venture, with each entity having invested approximately $4.7 million in the project. The County’s share of construction cost was financed primarily from the proceeds of a 1995 Parking Garage Capital Lease and a $1.7 million 2001 Parking Garage Revenue Bond issue. The County’s equity interest was recorded in the County’s Capital Assets. The Net Investment in Joint Venture will be increased (decreased) by 50 percent of the Association’s net income (loss) each year. The County’s equity interest decreased by $24,564 for its share of the 2017 net loss. Complete financial statements for the Association can be obtained from the Controller, City of Fort Wayne, Suite 470, 200 East Berry Street, Fort Wayne, Indiana 46802. Related Organizations The primary government's officials are also responsible for appointing the members of the boards of other organizations, but the primary government's accountability for these organizations does not extend beyond making the appointments. The primary government appoints the board members of numerous organizations. B. Government-Wide and Fund Financial Statements Government-wide financial statements the Statement of Net Position and the Statement of Activities) report information on all of the nonfiduciary activities of the primary government and its component units. For the most part, the effect of interfund activity has been removed from these statements. Governmental activities, which normally are supported by taxes and intergovernmental revenues, are reported separately from business-type activities, which rely to a significant extent on fees and charges for support. Likewise, the primary government is reported separately from certain legally separate component units for which the primary government is financially accountable. 30 ---PAGE BREAK--- The Statement of Activities demonstrates the degree to which direct expenses of a given function or segments are offset by program revenues. Direct expenses are clearly identifiable with a specific function or segment. Program revenues include charges to customers or applicants who purchase, use or directly benefit from goods, services or privileges provided by a given function or segment and 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, proprietary funds, and fiduciary funds, even though the latter are excluded from the government-wide financial statements. Major individual governmental funds and major individual enterprise funds are reported as separate columns in the fund financial statements. C. Measurement Focus, Basis of Accounting and Financial Statement Presentation The government-wide financial statements are reported using the economic resources measurement focus and the accrual basis of accounting as are the proprietary fund and fiduciary fund financial statements. Agency funds, however, report only assets and liabilities. Since, they do not report equity (or changes in equity), they have no measurement focus. Revenues are recorded when earned and expenses are recorded when a liability is incurred, regardless of the timing of the related cash flows. Property taxes are recognized in the year for which they are levied. Grants and similar items are recognized as revenue as soon as all eligibility requirements imposed by the provider have been met. Governmental fund financial statements are reported using the current financial resources measurement focus and the modified accrual basis of accounting. Revenues are recognized as soon as they are both measurable and available. Revenues are considered to be available when they are collectible within the current period or soon enough thereafter to pay liabilities of the current period. For this purpose, the primary government considers revenues to be available if they are collected within sixty days of the end of the current fiscal period. Expenditures generally are recorded when a liability is incurred, as under accrual accounting. However, debt service expenditures, as well as expenditures related to compensated absences, claims and judgments, are recorded only when payment is due. Property taxes, franchise taxes, licenses and permits, and interest associated with the current fiscal period are all considered to be susceptible to accrual and have been recognized as revenues of the current fiscal period. Only the portion of special assessments receivable due within the current fiscal period is considered to be susceptible to accrual as revenue of the current period. All other revenue items are considered to be measurable and available only when the primary government receives cash. The primary government reports the following major governmental funds: The General fund is the primary operating fund. It accounts for all financial resources of the general government, except those required to be accounted for in another fund. The Rainy Day fund (special revenue) accounts for transfers of unused and unencumbered funds under IC 36-1-8-5. Local Income Tax – Economic Development (capital projects) accounts for the local economic development income tax revenue and economic related expenses of the general government. The primary government reports the following major proprietary fund: The War Memorial Coliseum fund accounts for the operation of an arena and exposition center, which house major sporting events, music concerts, conventions, meetings and other events. 31 ---PAGE BREAK--- Additionally, the primary government reports the following fund types: The internal service funds account for automobile collision and comprehensive, civil rights, errors and omissions, health and worker’s compensation insurance, and material and supply bulk purchasing, provided to other departments on a cost-reimbursement basis. The pension trust funds account for the activities of the sheriff’s pension trust and the sheriff’s benefit pension funds which accumulate resources for pension benefit payments. Agency funds account for assets held by the primary government as an agent for individuals, private organizations, and other governments and/or other funds. As a general rule, the effect of interfund activity has been eliminated from the government-wide financial statements. Amounts reported as program revenues include charges to customers or applicants for goods, services or privileges provided, operating grants and contributions, and 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 from nonoperating items. Operating revenues and expenses generally result from providing services and producing and delivering goods in connection with a proprietary fund’s principal ongoing operations. The principal operating revenues of the enterprise funds and of the government’s internal service funds are charges to customers for sales and services. Operating expenses for enterprise funds and internal service funds include the cost of sales and services, administrative expenses, and depreciation on capital assets. All revenues and expenses not meeting this definition are reported as nonoperating revenues and expenses. When both restricted and unrestricted resources are available for use, it is the primary government’s policy to use restricted resources first, then unrestricted resources as they are needed. D. Assets, Liabilities, and Net Position or Equity 1. Restricted Assets/Net Position All restricted assets/net position, as presented in the accompanying financial statements, are restricted due to enabling legislation. 2. Deposits and Investments The primary government’s cash and cash equivalents are considered to be cash on hand, demand deposits and short-term investments with original maturities of three months or less from the date of acquisition. State statute (IC 5-13-9) authorizes the primary government to invest in securities, including but not limited to, federal government securities, repurchase agreements, and certain money market mutual funds. Certain other statutory restrictions apply to all investments made by local governmental units. Nonparticipating certificates of deposit, demand deposits and similar nonparticipating negotiable instruments that are not reported as cash and cash equivalents are reported as investments at cost. Debt securities are reported at fair value. Debt securities are defined as securities backed by the full faith and credit of the United States Treasury or fully insured or guaranteed by the United States or any United States government agency. 32 ---PAGE BREAK--- Open-end mutual funds are reported at fair value. Money market investments that mature within one year or less at the date of their acquisition are reported at amortized cost. Other money market investments are reported at fair value. Investment income, including changes in the fair value of investments, is reported as revenue in the operating statement. 3. Interfund Transactions and Balances Activities between funds that are representative of lending/borrowing arrangements outstanding at the end of the fiscal year are referred to as “interfund receivables/payables” the current and noncurrent portion of interfund loans). All other outstanding balances between funds are reported as “interfund services provided/used.” Any residual balances outstanding between the governmental activities and business-type activities are reported in the government-wide financial statements as “internal balances.” 4. Property Taxes Normally, property taxes levied are collected by the County Treasurer and are distributed to the primary government in June and in December. State statute (IC 6-1.1-17-16) requires the Indiana Department of Local Government Finance to establish property tax rates and levies by February 15. These rates were based upon the preceding year’s lien date (March 1 in a year ending before January 1, 2016 and January 1 in a year beginning after December 31, 2015) assessed valuations adjusted for various tax credits. Taxable property is assessed at 100 percent of the true tax value (determined in accordance with rules and regulations adopted by the Indiana Department of Local Government Finance). Taxes may be paid in two equal installments that become delinquent if not paid by May 10 and November 10, respectively. All property taxes collected by the County Treasurer and available for distribution were distributed to the primary government prior to December 31 of the year collected. Delinquent property taxes outstanding at year end for governmental and/or proprietary funds, net of allowances for uncollectible accounts, are recorded as a receivable with an offset to deferred inflows of resources since amounts are not considered available. 5. Inventories and Prepaid Items All inventories are valued at cost using the first in/first out (FIFO) method. Inventories of governmental funds are recorded as expenditures when consumed rather than when purchased. Certain payments to vendors reflect costs applicable to future accounting periods and are recorded as prepaid items in government-wide but as expenditures in fund financial statements. 6. Capital Assets Capital assets, which include property, plant, equipment, and infrastructure assets roads, bridges, sidewalks, and similar items) are reported in the applicable governmental or business-type activities column in the government-wide financial statements. Capital assets are reported at actual or estimated historical cost based on appraisals or deflated current replacement cost. Contributed or donated assets are reported at estimated fair value at the time received. Capitalization thresholds (the dollar values above which asset acquisitions are added to the capital asset accounts), depreciation methods and estimated useful lives of capital assets reported in the government-wide statements and proprietary funds are as follows: 33 ---PAGE BREAK--- Capitalization Depreciation Estimated Threshold Method Useful Life Land All Capitalized N/A N/A Buildings $5,000 Straight-line 40-60 Years Improvements other than buildings 5,000 Straight-line 10-45 Years Machinery and equipment 5,000 Straight-line 5-25 Years Infrastructure 5,000 Straight-line 10-40 Years Intangible assets 5,000 Straight-line 15 Years Net investment in joint venture 5,000 Straight-line 40 Years N/A = Not applicable For depreciated assets, the cost of normal maintenance and repairs that do not add to the value of the asset or materially extend asset lives are not capitalized. Major outlays for capital assets and improvements are capitalized as projects are constructed. Interest incurred during the construction phase of capital assets of business- type activities is included as part of the capitalized value of the assets constructed. The total interest expense incurred by the primary government in its business-type activities during the current year was $1,080,998. Of the amount, $0 was included as part of the cost of capital assets under construction. 7. Compensated Absences a. Sick Leave – primary government employees earn sick leave at the rate of 5 days per year. Unused sick leave may be accumulated to a maximum of 10 days. Accumulated sick leave is paid to employees through cash payments upon termination. b. Vacation Leave – primary government employees earn vacation leave on their anniversary date at rates from 10 days to 25 days per year based upon the number of years of service. Vacation leave does not accumulate from year to year. c. Personal Leave – primary government employees earn personal leave at the rate of 2 days per year. Personal leave does not accumulate from year to year. Vacation, sick and personal leave is accrued when incurred. 8. Long-Term Obligations In the government-wide financial statements and proprietary fund types in the fund financial statements, long-term debt and other long-term obligations are reported as liabilities in the applicable governmental activities, business-type activities or proprietary fund type Statement of Net Position. Bond premiums, discounts, and loss on refunding are deferred and amortized over the life of the bonds using the straight-line method. Bonds payable are reported net of the applicable bond premium or discount. In the fund financial statements, governmental fund types recognize bond premiums and discounts during the current period. The face amount of debt issued is reported as other financing sources. Premiums received on debt issuance are reported as other financing sources while discounts on debt issuances are reported as other financing uses. Issuance costs, whether or not withheld from actual debt proceeds received, are reported as debt service expenditures. 34 ---PAGE BREAK--- 9. Deferred Inflows/Outflows of Resources Deferred inflows of resources represent an acquisition of net position that applies to future periods. Deferred inflows of resources consist of pension related resources in the amount of $7,971,636 for 2017. These inflows consist of INPRS retirement system of $4,372,459, the County Police Retirement plan in the amount of $3,299,269, and the County Police Supplemental Benefit plan in the amount of $299,908. The unamortized gain on refunding for the Allen County Jail with a total gain of $111,286 the unamortized amount of $59,923. Deferred outflows of resources represent a consumption of net position that applies to future periods. The Redevelopment GM TIF Bonds with a total loss of $154,581 the unamortized amount of $87,596 for Governmental Activities and the Allen County War Memorial Coliseum bonds for Business-Type Activities with a total loss of $407,043 the unamortized amount $354,278 for the 2016A Series and a total loss of $209,024 the unamortized amount of $112,921 for the 2011B Series, and the Maplecrest Road Bridge Bond 2016 with a total loss of $1,926,062 the unamortized amount of $1,740,864. The deferred outflows for governmental activities that is pension related totals $16,775,492 and consists of INPRS retirement system of $12,460,432, the County Police Retirement plan in the amount of $3,927,482, and the County Police Supplemental Benefit plan in the amount of $387,578. 10. Fund Balance Fund balance is divided into five classifications based on GASB Statement No. 54, Fund Balance Reporting and Governmental Fund Type Definitions. The primary government’s fund balances are reported under classifications of nonspendable, restricted, committed, assigned, and unassigned fund balances. The Classifications are as follows: Nonspendable – represents amounts that are not in spendable form; for example, inventories, prepaid amounts, the pledge of revenue for TIF bonds, or assets held for resale. Restricted – represents amounts that are constrained for a specific purpose by external parties such as grantors or imposed by law through constitutional provisions or enabling legislation. Committed – represents amounts that can only be used for a specific purpose imposed by formal action of the government’s highest level of decision making authority. The primary government’s highest level of decision making authority is the County Council and the County Commissioners. Assigned – represents amounts that are intended to be used by the primary government for specific purposes but do not meet the criteria to be classified as restricted or committed. Unassigned – represents fund balance that has not been assigned to other funds and that has not been restricted, committed, or assigned to specific purposes within the General Fund. Only the General Fund may report a positive unassigned fund balance; whereas, other governmental funds may need to report a negative unassigned fund balance if expenditures incurred for specific purposes exceeded the amounts restricted, committed, or assigned to those purposes. The County considers restricted amounts to have been spent when an expenditure is incurred for purposes for which both restricted and unrestricted fund balance is available. The County does not have a formal policy for its use of unrestricted fund balance amounts; therefore, it considers committed amounts used first, followed by assigned amounts, and then unassigned amounts when expenditures are incurred for purposes for which amounts in any of those unrestricted fund balance classifications could be used. For functionalized classification of fund balance, please refer to Note II. B. 35 ---PAGE BREAK--- II. Stewardship, Compliance and Accountability A. Budgetary Information Annual budgets are adopted on the cash basis which is not consistent with accounting principles generally accepted in the United States. All annual appropriations lapse at fiscal year-end. On or before August 31, the County Auditor submits to the County Council a proposed operating budget for the year commencing the following January 1. Prior to adoption, the budget is advertised and public hearings are conducted by the County Council to obtain taxpayer comments. In October of each year, the County Council through the passage of an ordinance approves the budget for the next year. Copies of the budget ordinance and the advertisement for funds for which property taxes are levied or highway use taxes are received are sent to the Indiana Department of Local Government Finance. The budget becomes legally enacted after the County Auditor receives approval of the Indiana Department of Local Government Finance. The primary government’s management cannot transfer budgeted appropriations between object classifications of a budget without approval of the County Council. The Indiana Department of Local Government Finance must approve any revisions to the appropriations for any fund or any department of the General Fund. The legal level of budgetary control is by object and department within the fund for the General Fund and by object within the fund for all other budgeted funds. Expenditures did not exceed appropriations for any funds or any departments within the General Fund, which required legally, approved budgets. B. Fund Balances The fund balances have been classified to reflect the limitations and restrictions placed on the respective funds. The Governmental Accounting Standards Board (GASB) has issued Statement No. 54, Fund Balance Reporting and Governmental Fund Type Definitions. This Statement significantly changed the fund balance presentation of the County’s governmental funds by requiring fund balances to be classified into different categories according to the level of their restricted use. Fund balances at December 31, 2017 are composed of the following: Local Income Tax Other Economic Governmental General Rainy Day Development Funds Totals Nonspendable fund balance: Economic development - - - 966,088 966,088 Restricted fund balance: General Government - - - 24,815,322 24,815,322 Public Safety - - - 9,814,626 9,814,626 Highw ays and Streets - - - 17,093,417 17,093,417 Sanitation - - - 158,718 158,718 Culture and Recreation - - - 854,661 854,661 Economic Development - - 1,307,513 11,930,382 13,237,895 Health and Welfare - - - 4,077,908 4,077,908 Total restricted fund balance - - 1,307,513 68,745,034 70,052,547 36 ---PAGE BREAK--- C. Deficit Fund Equity At December 31, 2017, the following funds reported deficits in fund equity, which are violations of State statue: Fund equity deficits arose primarily from expenditures or expenses exceeding revenues due to the timing differences of grants or costs reimbursements; these deficits will be repaid from future revenues. III. Detailed Notes on All Funds A. Deposits and Investments Primary Government 1. Deposits Custodial credit risk is the risk that in the event of a bank failure, the government's deposits may not be returned to it. Indiana Code 5-13-8-1 allows a political subdivision of the State of Indiana to deposit public funds in a financial institution only if the financial institution is a depository eligible to receive state funds and has a principal office or branch that qualifies to receive public funds of the political subdivision. The County’s deposit policy for custodial credit risk requires compliance with Indiana Code 5-13-8-1. The bank balances were insured by the Federal Deposit Insurance Corporation or the Public Deposit Insurance Fund, which Committed fund balance: General Government 67,536 - - 1,471,493 1,539,029 Public Safety 575,409 - - 273,569 848,978 Culture and Recreation - - - 7,956 7,956 Economic Development 32,253 - 18,415,008 1,085,649 19,532,910 Health and Welfare - - - 242,455 242,455 Total committed fund balance 675,198 - 18,415,008 3,081,122 22,171,328 Assigned fund balance: General Government 566,932 13,276,313 - 214,430 14,057,675 Public Safety 123,788 - - - 123,788 Health and Welfare - - - - - Economic Development 53,143 - - 422,192 475,335 Total assigned fund balance 743,863 13,276,313 - 636,622 14,656,798 Unassigned fund balance 24,735,582 - - (1,037,649) 23,697,933 Total fund balance 26,154,643 $ 13,276,313 $ 19,722,521 $ 72,391,217 $ 131,544,694 $ Fund 2017 Governmental Funds: Supplemental Adult Probation Services 5,791 $ Allen County Courts Foreign Language Interpreter 1,660 Vera Bradley TIF 218,238 Bluffton Road East TIF 811,960 37 ---PAGE BREAK--- covers all public funds held in approved depositories. At December 31, 2017, the Sheriff’s Retirement and Benefit Pension Plans had deposit balances in the amount of $3,585,255. The Sheriff’s Merit Board does not have a policy for custodial credit risk. Of this amount, the following was exposed to custodial credit risk: 2. Investments Authorization for investment activity is stated in Indiana Code 5-13. The Sheriff’s Merit Board has established an investment policy for the Sheriff’s Retirement and Benefit Pension Plans. This investment policy outlines parameters for investment activity for the Pension Plans. As of December 31, 2017, the County and the Sheriff's Retirement and Benefit Plan had the following investments: Investment Policies Indiana Code 5-13-9 authorizes the County to invest in securities backed by the full faith and credit of the United States Treasury or fully guaranteed by the United States of America and issued by the United States Treasury, a federal agency, a federal instrumentality, or a federal government sponsored enterprise. Indiana Code also authorizes the unit to invest in securities fully guaranteed and issued by a federal agency, a federal instrumentality, or a federal government sponsored enterprise. These investments are required by statute to have a stated final maturity of not more than two years. Indiana Code also provides for investment in money market mutual funds that are in the form of securities of, or interest in, an open-end, no-load, management-type investment company or investment trust registered under the provision of the federal Investment Company Act of Amount Uninsured and uncollateralized deposits 3,585,255 $ Primary Government: Investment Type Fair Value Government sponsored enterprises 12,373,121 $ External investment pool 1,288,320 Total 13,661,441 $ Sheriff's Retirement and Benefit Pension Plans: Investment Type Fair Value Mutual funds 13,661,017 $ Foreign mutual fund 36,127,371 Total 49,788,388 $ 38 ---PAGE BREAK--- Primary Government: Not in the Investment Government's Type Name Government sponsored enterprises 12,373,121 $ 1940, as amended. Investments in money market mutual funds may not exceed 50 percent of the funds held by the County and available for investment. The portfolio of an investment company or investment trust used must be limited to direct obligations of the United States of America, obligations issued by a federal agency, a federal instrumentality, or a federal government sponsored enterprise or repurchase agreements fully collateralized by direct obligations of the United States of America or obligations issued by a federal agency, a federal instrumentality, or a federal government sponsored enterprise. The form of securities of, or interest in, an investment company or investment trust must be rated as AAA, or its equivalent by Standard and Poor's Corporation or its successor or Aaa, or its equivalent, by Moody's Investors Service, Inc., or its successor. The form of securities in an investment company or investment trust should have a stated final maturity of one day. Additionally, the County may enter into repurchase agreements with depositories designated by the State Board of Finance as depositories for state deposits involving the unit's purchase and guaranteed resale of any interest-bearing obligations issued or fully insured or guaranteed by the United States of America, a United States of America government agency, an instrumentality of the United States of America, or a federal government sponsored enterprise. The repurchase agreement is considered to have a stated final maturity of one day. This agreement must be fully collateralized by interest-bearing obligations as determined by their current market value. The Sheriff's Pension Plan is not subject to the same investment laws as the County. The investment policy for the Sheriff's Retirement and Benefit Pension Plans was adopted by the Sheriff's Merit Board on March 10, 2005. Authorized investments include time or savings accounts, obligations issued or fully insured or guaranteed by the United States of America, bonds, stocks, guaranteed investment contracts, bank investment contracts, mutual funds, high quality money market funds, and foreign securities whose shares are not denominated in foreign currency. Investment Custodial Credit Risk The custodial credit risk for investments is the risk that, in the event of the failure of the counterparty to a transaction, a government will not be able to recover the value of investment or collateral securities that are in the possession of an outside party. Neither the County nor the Sheriff’s Pension Plan has a formal investment policy for custodial credit risk for investments. The following investments held by the County and the Sheriff's Retirement and Benefit Pension Plans were exposed to custodial credit risks because they are uninsured and unregistered with securities held by the counterparty, or the counterparty's trust department or agent, either in the government's name or not in the government's name: 39 ---PAGE BREAK--- Interest Rate Risk Interest rate risk is the risk that changes in interest rates will adversely affect the fair value of an investment. The County’s investment policy to minimize interest rate risk is to abide by the Indiana Code, which limits the stated final maturities of the investments to no more than five years. The Sheriff's Merit Board for the Sheriff's Retirement and Benefit Pension Plans manages interest rate risk by authorizing a maximum average maturity of no more than 15 years be maintained in fixed income securities. Credit Risk Credit risk is the risk that an issuer or other counterparty to an investment will not fulfill its obligations. To minimize credit risks associated with investments, the County’s policy is to follow Indiana Code 5-13-9-2.5, which limits investments to AAA rated money market funds, repurchase agreements fully collateralized by U.S. Government Securities, and U.S. Treasury obligations (or other U.S. Agency obligations). To minimize credit risks associated with investments, the Sheriff’s Merit Board has adopted a policy which limit investments to Sheriff's Retirement and Benefit Pension Plans: Not in the Investment Government's Type Name Mutal funds 13,661,017 $ Foreign mutual fund 36,127,371 Total 49,788,388 $ Primary Government: Investment Less More Type Than 1 1-2 Than 2 Government sponsored enterprises 1,996,770 $ 10,376,351 $ - $ External investment pool 1,288,320 - - Totals 3,285,090 $ 10,376,351 $ - $ Investment Maturities (in Years) Sheriff's Retirement and Benefit Pension Plans: Investment Less More Type Than 0-5 5-15 Than 15 Mutual funds 13,661,017 $ - - Foreign mutual funds 36,127,371 - - Totals 49,788,388 $ - $ - $ Investment Maturities (in Years) 40 ---PAGE BREAK--- Primary Government: Standard & Government Poor's Moody's Sponsored Investment Rating Rating Enterprise Pools AAA Aaa - $ 128,353 $ AA Aa 12,373,121 171,722 A A - 988,245 Unrated Unrated - - Totals 12,373,121 $ 1,288,320 $ County's Investments Sheriff's Retirement and Benefit Pension Plans: Standard & Poor's Moody's Mutual Rating Rating Funds Unrated Unrated 49,788,388 $ Sheriff's Pension Plan Investments obligations of or obligations guaranteed by the United States government; bonds, stocks, or other evidences of indebtedness issued or guaranteed by a corporation organized under the laws of the United States, provided the corporation is listed on one or more of the recognized national stock exchanges or on the National Market System of the NASDAQ Stock Market and, in the case of bonds only, holds a rating in one of the highest major classification by a recognized rating service; Guaranteed Investment Contracts and Bank Investment Contracts rated A+ by A. M. Best Company, Inc.; Mutual Plans that apply with the above restrictions; and High quality money market funds. The distribution of securities with credit ratings is summarized below. Concentration of Credit Risk Concentration of credit risk is the risk of loss attributed to the magnitude of a government's investment in a single issuer. The County does not have a policy in regards to concentration of credit risk. United States of America government and United States of America governmental agency securities are exempt from this policy requirement. The Sheriff's Merit Board has adopted the following policy for the concentration of credit risk. The Sheriff’s Merit Board for the Sheriff’s Pension Plan manages concentration of credit risk by limiting the investment in debt securities of any one corporation to a maximum of 5 percent of the fixed income investments of the plan. The County held the following investments that were exposed to concentration of credit risk: 41 ---PAGE BREAK--- Primary Government: Investment Type Fair Value Level 1 Level 2 Level 3 Government sponsored enterprises 12,373,121 $ - $ 12,373,121 $ - $ External investment pool 1,288,320 - 1,288,320 - Totals 13,661,441 $ - $ 13,661,441 $ - $ Primary Government: Issuer 2017 Federal Home Loan Mortgage Corporation 4,964,810 $ Federal National Mortgage Association Deb 3,685,578 Federal Home Loan Banks 2,732,793 Total 11,383,181 $ Foreign Currency Risk Foreign currency risk relates to adverse effects on the fair value of an investment from changes in exchange rates. The Sheriff’s Merit Board has a formal policy in regards to foreign currency risk that states foreign securities must have shares denominated in United States of America dollars. The primary government units’ investments are denominated in U.S. currency. 3. Fair Value Measurement The primary government categorizes investments measured at fair value within the fair value hierarchy established by generally accepted accounting principles. The hierarchy gives the highest priority to unadjusted quoted prices in active markets for identical assets or liabilities (Level 1) and the lowest priority to unobservable inputs (Level The three levels of fair value hierarchy are defined as follows: Level 1: Inputs using unadjusted quoted prices in active markets or exchanges for identical assets or liabilities. Level 2: Significant other observable inputs, which may include, quoted prices for similar assets or liabilities in active markets, quoted prices for identical or similar assets or liabilities in non-active markets; and inputs other than quoted prices that are observable for the assets or liabilities, either directly or indirectly. Level 3: Valuations for which one or more significant inputs are unobservable and may include situations where there is minimal, if any, market activity for the asset or liability. The asset or liability’s fair value measurement level within the fair value hierarchy is based on the lowest level of any input that is significant to the fair value measurement. Valuation techniques need to maximize the use of relevant observable inputs and minimize the use of unobservable inputs. Investment value is determined by reference to quoted market prices and other relevant information generated by market transactions. The following table summarizes the valuation of investments by the fair value hierarchy levels as of December 31, 2017: 42 ---PAGE BREAK--- Discretely Presented Component Unit 1. Deposits Custodial credit risk is the risk that in the event of a bank failure, the government's deposits may not be returned to it. Indiana Code 5-13-8-1 allows a political subdivision of the State of Indiana to deposit public funds in a financial institution only if the financial institution is a depository eligible to receive state funds and has a principal office or branch that qualifies to receive public funds of the political subdivision. The Allen County Public Library does not have deposit policies for custodial credit risk. At December 31, 2017, the County’s discretely presented component unit’s deposits with financial institutions of $31,631,486 were entirely insured by the federal depository insurance, with the exception of the Allen County Public Library’s deposits in the amount of $772,996. Deposits of $772,996 are in excess of the insured amount and $241,516 is in investment accounts that are uninsured. 2. Investments Authorization for investment activity is stated in Indiana Code 5-13. As of December 31, 2017, the County’s discretely presented component unit had the following investments: Investment Policies Indiana Code 5-13-9 authorizes the discretely presented component unit to invest in securities backed by the full faith and credit of the United States Treasury or fully guaranteed by the United States of America and issued by the United States Treasury, a federal agency, a federal instrumentality, or a federal government sponsored enterprise. Indiana Code also authorizes the unit to invest in securities fully guaranteed and issued by a federal agency, a federal instrumentality, or a federal government sponsored enterprise. These investments are required by statute to have a stated final maturity of not more than five years. Sheriff's Retirement and Benefit Pension Plans: Investment Type Fair Value Level 1 Level 2 Level 3 Mutual funds 13,661,017 $ 13,661,017 $ - $ - $ Foreign mutual funds 36,127,371 36,127,371 - - Totals 49,788,388 $ 49,788,388 $ - $ - $ Discretely Presented Component Unit: Investment Type Fair Value Government sponsored enterprises 3,764,008 $ Corporate bonds 492,542 Corporate stock 10,449,366 Mutual funds 3,297,033 Total 18,002,949 $ 43 ---PAGE BREAK--- Indiana Code also provides for investment in money market mutual funds that are in the form of securities of, or interest in, an open-end, no-load, management-type investment company or investment trust registered under the provision of the federal Investment Company Act of 1940, as amended. Investments in money market mutual funds may not exceed 50 percent of the funds held by the discretely presented component unit and available for investment. The portfolio of an investment company or investment trust used must be limited to direct obligations of the United States of America, obligations issued by a federal agency, a federal instrumentality, or a federal government sponsored enterprise or repurchase agreements fully collateralized by direct obligations of the United States of America or obligations issued by a federal agency, a federal instrumentality, or a federal government sponsored enterprise. The form of securities of, or interest in, an investment company or investment trust must be rated as AAA, or its equivalent by Standard and Poor's Corporation or its successor or Aaa, or its equivalent, by Moody's Investors Service, Inc., or its successor. The form of securities in an investment company or investment trust should have a stated final maturity of one day. Additionally, the discretely presented component unit may enter into repurchase agreements with depositories designated by the State Board of Finance as depositories for state deposits involving the unit's purchase and guaranteed resale of any interest-bearing obligations issued or fully insured or guaranteed by the United States of America, a United States of America government agency, an instrumentality of the United States of America, or a federal government sponsored enterprise. The repurchase agreement is considered to have a stated final maturity of one day. This agreement must be fully collateralized by interest- bearing obligations as determined by their current market value. Investment Custodial Credit Risk The custodial credit risk for investments is the risk that, in the event of the failure of the counterparty to a transaction, a government will not be able to recover the value of investment or collateral securities that are in the possession of an outside party. The Allen County Public Library does not have formal investment policies for custodial credit risk for investments. Interest Rate Risk Interest rate risk is the risk that changes in interest rates will adversely affect the fair value of an investment. The Allen County Public Library’s investment policy does not limit investment maturities as a means of managing its exposure to fair value losses arising from changes in interest rates. Credit Risk Credit risk is the risk that an issuer or other counterparty to an investment will not fulfill its obligations. The Allen County Public Library’s investment policy for credit risk requires Discretely Presented Component Unit: Investment Less More Type Than 1 1-2 Than 2 Government sponsored enterprises 236,558 $ 137,521 $ 3,389,929 $ Corporate bonds 81,171 47,576 363,795 Corporate stock 10,449,366 - - Mutual funds 3,297,033 - - Totals 14,064,128 $ 185,097 $ 3,753,724 $ Investment Maturities (in Years) 44 ---PAGE BREAK--- Discretely Presented Component Unit: Standard & Morningstar Government Poor's Risk Sponsored Corporate Mutual Rating Profile Enterprise Bonds Funds AAA 328,933 $ - $ - $ AA+ 1,711,905 - - AA 325,204 30,795 - AA - 152,750 46,398 - AA1 25,650 - - AA3 210,768 - - A+ 97,800 - - A 444,570 10,860 - A- 21,484 123,342 - A1 123,932 - - A2 36,773 - - BBB+ - 173,747 - BBB - 73,812 - BB- - 33,588 - Unrated 284,239 - 138,884 Low - - 330,533 Below Average - - 695,968 Average - - 1,544,853 Above Average - - 421,550 High - - 165,245 Totals 3,764,008 $ 492,542 $ 3,297,033 $ investments to have a rating of A or better. The distribution of securities with credit ratings is summarized below. Concentration of Credit Risk Concentration of credit risk is the risk of loss attributed to the magnitude of an organization's investment in a single issuer. The Allen County Public Library’s policy states no more than 5 percent invested in one company; no more than 20 percent invested in any one industry/market sector; international investment concentration is governed by the policy that investments in U.S. Stocks will be at least as great as the percentage of U.S. equities comprising the MSCI All Country World Index as of the end of the preceding year. Investment in high yield and unrated bonds may be no higher than 10 percent of the entire portfolio. United States of America government and United States of America governmental agency securities are exempt from this policy requirement. Foreign Currency Risk Foreign currency risk relates to adverse effects on the fair value of an investment from changes in exchange rates. The Allen County Public Library’s discretely presented component unit does not have a formal investment policy for foreign currency risk for investments. The Investment Policy Statement includes a formal policy in regards to foreign currency risk. The foreign currency related to this investment is in international mutual funds and fixed income instruments and has a fair market value of $528,216. Fair Value of Financial Instruments Assets and liabilities recorded at fair value in the Statement of Net Position of the Allen County Public Library component unit are categorized based upon a hierarchy of the level of judgement associated with the inputs used to measure their fair value. The three levels of fair value hierarchy are described below: Level 1 – Inputs to the valuation methodology are unadjusted quoted prices for identical assets or liabilities in active markets that the component unit has the ability to access. 45 ---PAGE BREAK--- Discretely Presented Component Unit: Investment Type Fair Value Level 1 Level 2 Level 3 Corporate Stock 10,449,366 $ 10,449,366 $ - $ - $ Mutual Funds 3,297,033 3,297,033 - - Government sponsored enterprise 3,764,008 - 3,764,008 - Bonds 492,542 - 492,542 - Beneficial interest 13,317 - - 13,317 Totals 18,016,266 $ 13,746,399 $ 4,256,550 $ 13,317 $ Beginning Ending Primary Government: Balance Increases Decreases Balance Governmental activities: Capital assets, not being depreciated: Land 10,501,174 $ 276,585 $ 194,779 $ 10,582,980 $ Construction in progress 56,275,761 10,691,406 5,948,108 61,019,059 Total capital assets, not being depreciated 66,776,935 10,967,991 6,142,887 71,602,039 Capital assets, being depreciated: Buildings 125,463,425 679,294 4,100,616 122,042,103 Improvements other than buildings 3,384,834 - - 3,384,834 Machinery and equipment 42,627,655 2,354,839 1,485,019 43,497,475 Infrastructure being depreciated 384,251,759 21,718,863 40,974,113 364,996,509 Intangible assets 477,043 78,450 - 555,493 Net investment in joint venture 5,746,348 - 24,564 5,721,784 Totals 561,951,064 24,831,446 46,584,312 540,198,198 Level 2 – Inputs to the valuation methodology include quoted prices for similar assets or liabilities in active markets; quoted prices for identical or similar assets or liabilities in inactive markets; inputs other than quoted prices that are observable for the asset or liability; inputs that are derived principally from or corroborated by observable market data by correlation or other means. If the asset or liability has a specified (contractual) term, the level 2 input must be observable for substantially the full term of the asset or liability. Level 3 – Inputs to the valuation methodology are unobservable and significant to the fair value measurement. The asset or liability fair value measurement level within the fair value hierarchy is based on the lowest level of any input that is significant to the fair value measurement. Valuation techniques used need to maximize the use of observable inputs and minimize the use of unobservable inputs. Following is a description of the valuation methodologies used for assets and liabilities measured at fair value. Investments – Value determined by reference to quoted market prices and other relevant information generated by market transactions. Beneficial Interest in assets held by others – Value are based upon the component unit’s proportionate share of the Community Foundation of Greater Fort Wayne’s pooled investment portfolio. The following table shows the fair value, within the hierarchy, of assets and liabilities of the Allen County Public Library’s component unit measured on a recurring basis as of June 30, 2017: B. Capital Assets Capital asset activity for the year ended December 31, 2017, was as follows: 46 ---PAGE BREAK--- Less accumulated depreciation for: Buildings 47,857,591 1,927,798 1,214,599 48,570,790 Improvements other than buildings 3,185,251 13,884 - 3,199,135 Machinery and equipment 30,578,167 3,025,954 1,398,065 32,206,056 Infrastructure being depreciated 142,154,565 7,885,473 13,675,932 136,364,106 Intangible assets 113,707 37,033 - 150,740 Net investment in joint venture 2,762,953 143,045 - 2,905,998 Totals 226,652,234 13,033,187 16,288,596 223,396,825 Total capital assets, being depreciated, net 335,298,830 11,798,259 30,295,716 316,801,373 Total governmental activities capital assets, net 402,075,765 $ 22,766,250 $ 36,438,603 $ 388,403,412 $ Business-type activities: Capital assets, not being depreciated: Land 380,487 $ - $ - $ 380,487 $ Construction in progress 17,796,262 1,343,405 19,085,623 54,044 Total capital assets, not being depreciated 18,176,749 1,343,405 19,085,623 434,531 Capital assets, being depreciated: Land improvements 1,440,208 - - 1,440,208 Buildings 88,507,178 17,575,616 - 106,082,794 Improvements other than buildings 6,861,105 1,510,007 11,206 8,359,906 Machinery and equipment 9,163,344 486,771 88,407 9,561,708 Totals 105,971,835 19,572,394 99,613 125,444,616 Less accumulated depreciation for: Land improvements 1,434,808 300 - 1,435,108 Buildings 42,562,179 2,205,815 - 44,767,994 Improvements other than buildings 4,340,016 236,189 5,603 4,570,602 Machinery and equipment 5,763,897 794,035 17,589 6,540,343 Totals 54,100,900 3,236,339 23,192 57,314,047 Total capital assets, being depreciated, net 51,870,935 16,336,055 76,421 68,130,569 Total business-type activities capital assets, net 70,047,684 $ 17,679,460 $ 19,162,044 $ 68,565,100 $ Discretely Presented Component Unit Capital assets, not being depreciated: Land and intangibles 4,960,142 $ - $ - $ 4,960,142 $ Rare book collection 994,827 - - 994,827 Total capital assets, not being depreciated 5,954,969 - - 5,954,969 Capital assets, being depreciated: Buildings and improvements 90,525,384 - - 90,525,384 Improvements other than buildings 634,872 - - 634,872 Machinery and equipment 5,652,458 129,792 52,254 5,729,996 Library materials 9,063,886 2,675,111 2,957,738 8,781,259 Totals 105,876,600 2,804,903 3,009,992 105,671,511 Less accumulated depreciation for: Buildings and improvements 30,635,642 2,155,041 - 32,790,683 Improvements other than buildings 326,897 29,138 - 356,035 Machinery and equipment 5,380,694 141,221 52,254 5,469,661 Library materials 2,991,504 3,021,295 2,957,738 3,055,061 Totals 39,334,737 5,346,695 3,009,992 41,671,440 Total capital assets, being depreciated, net 66,541,863 (2,541,792) - 64,000,071 Total discretely presented component unit capital assets, net 72,496,832 $ (2,541,792) $ - $ 69,955,040 $ 47 ---PAGE BREAK--- Depreciation expense was charged to functions/programs of the primary government as follows: C. Interfund Balances and Activity 1. Interfund Receivables and Payables The composition of interfund balances as of December 31, 2017, is as follows: Interfund balances resulted from the time lag between the dates that Interfund loans are repaid, Interfund goods and services are provided or reimbursable expenditures occur, transactions are recorded in the accounting system and payments between funds are made. 2. Interfund Transfers Interfund transfers at December 31, 2017, were as follows: The primary government typically uses transfers to fund ongoing operating subsidies. D. Long-Term Liabilities 1. First Mortgage Bonds Primary Government The primary government issues bonds to provide funds for the acquisition and construction of major capital facilities. First Mortgage bonds outstanding at year end are as follows: Governmental activities: General government 875,878 $ Public safety 3,184,339 Highways and streets 8,846,961 Health and welfare 67,851 Culture and recreation 58,158 Total depreciation expense - governmental activities 13,033,187 $ Business-type activities: Coliseum 3,236,339 $ General Local Income Tax Non-major Interfund Payables Fund Rainy Day Economic Development Governmental Total Non-major governmental 107,287 $ 473,850 $ 537,433 $ 825,381 $ 1,943,951 $ Interfund Receivables Local Income Tax Economic Non-major Transfer From General Development Governmental Totals County General - $ - $ 145,000 $ 145,000 $ Local Income Tax - Economic Development - - 2,350,000 2,350,000 $ Non-major Governmental 2,217,721 313,737 6,333,178 8,864,636 Totals 2,217,721 $ 313,737 $ 8,828,178 $ 11,359,636 $ 48 ---PAGE BREAK--- First Mortgage bonds debt service requirements to maturity are as follows: Discretely Presented Component Unit The discretely presented component unit issues bonds to provide funds for the acquisition and construction of major capital facilities. First Mortgage bonds outstanding at year end are as follows: First Mortgage bonds debt service requirements to maturity are as follows: Balance Interest December 31, Current Net Purpose Rates 2017 Portion Premium Noncurrent Governmental activities: 2011 Juvenile Justice Center first mortgage refunded bonds 2% to 5% 1,602,388 $ 1,301,536 $ - $ 300,852 $ 2016 Jail Building First Mortgage refunding bonds 2.00% to 4.00% 4,275,000 1,690,000 198,226 2,783,226 Total governmental activities 5,877,388 $ 2,991,536 $ 198,226 $ 3,084,078 $ Business-type activities: 2011 B War Memorial Coliseum additions first mortgage refunding revenue bonds 3.6% to 5.45% 3,185,000 $ 335,000 $ 4,989 $ 2,854,989 $ 2016 A War Memorial Coliseum additions refunding first mortgage revenue bonds 2.00% to 4.00% 13,380,000 1,590,000 1,462,177 13,252,177 2014 War Memorial Coliseum Convention Center Expansion first mortgage bonds 2% to 5.0% 13,900,000 575,000 705,483 14,030,483 Total business-type activities 30,465,000 $ 2,500,000 $ 2,172,649 $ 30,137,649 $ Year Ended December 31 Principal Interest Principal Interest 2018 2,991,536 $ 1,384,889 $ 2,500,000 $ 1,227,244 $ 2019 2,035,852 400,148 2,525,000 1,137,906 2020 850,000 17,000 2,570,000 1,032,451 2021 - - 2,670,000 917,936 2022 - - 2,785,000 798,656 2023-2027 - - 10,590,000 2,221,615 2028-2032 - - 4,695,000 970,775 2033-2035 - - 2,130,000 129,219 Totals 5,877,388 $ 1,802,037 $ 30,465,000 $ 8,435,803 $ Governmental Activities Business-Type Activities Balance Interest December 31, Current Unamortized Net Purpose Rates 2017 Portion (Discount) Noncurrent 2016 Allen County Public Library first mortgage refunding bonds 2% to 3% 25,310,000 $ 5,825,000 $ (69,109) $ 19,415,891 $ 49 ---PAGE BREAK--- Principal Interest 2018 2,210,000 $ 870,813 $ 2019 2,305,000 806,194 2020 2,380,000 732,934 2021 1,305,000 660,769 2022 1,385,000 608,069 2023-2027 8,010,000 2,151,344 2028-2032 4,120,000 479,741 2033-2037 970,000 163,000 Totals 22,685,000 $ 6,472,862 $ Governmental Activities 2. Revenue Bonds Primary Government The primary government issues bonds to be paid by income derived from the acquired or constructed assets. Revenue bonds outstanding at year end are as follows: Revenue bonds debt service requirements to maturity are as follows: 3. Advance Refunding In prior years, the primary government defeased the Maplcrest Bridge Bonds of 2009 by placing the proceeds of new bonds in an irrevocable trust to provide for all future debt service payments on the old bonds. Accordingly, the trust accounts and the liability for the defeased bonds are not included in the primary government’s financial statements. At December 31, 2017, $18,889,498 of bonds outstanding are considered defeased. Year Ended December 31 Principal Interest 2018 5,825,000 $ 257,661 $ 2019 5,885,000 194,589 2020 5,955,000 130,842 2021 5,315,000 66,366 2022 2,330,000 12,582 Totals 25,310,000 $ 662,040 $ Component Unit Discretely Presented Balance Interest December 31, Current Net Purpose Rates 2017 Portion Premium Noncurrent Allen County Tax Increment Revenue Bonds (General Motors) Series 2015 A 1.35% to 2.60% 2,605,000 $ 845,000 $ - $ 1,760,000 $ Allen County Tax Increment Revenue Bonds (General Motors) Series 2015 B 1.35% to 2.60% 935,000 310,000 - 625,000 Allen County Tax Increment Revenue Bonds (General Motors) Series 2015 C 3.0% to 4.0% 2,050,000 - 9,692 2,059,692 2016 Maplecrest Road Bridge Bond 3.0% to 5.0% 17,095,000 1,055,000 2,361,997 18,401,997 Total governmental activities 22,685,000 $ 2,210,000 $ 2,371,689 $ 22,846,689 $ 50 ---PAGE BREAK--- Coliseum ticket office fund 590,682 $ Coliseum advance customer deposits 423,088 Food and beverage supplemental tax fund 6,301,839 Sports and convention fund 1,381,636 Total restricted assets 8,697,245 $ 4. Changes in Long-Term Liabilities Long-term liability activity for the year ended December 31, 2017, was as follows: Compensated absences for governmental activities typically have been liquidated from the General Fund and five special revenue funds. Claims and judgments typically have been liquidated from the General Fund. E. Restricted Assets The balances of restricted asset accounts in the enterprise funds are as follows: IV. Other Information A. Risk Management The primary government is exposed to various risks of loss related to torts; theft of, damage to, and destruction of assets; errors and omissions; job related illnesses or injuries to employees; Beginning Ending Due Within Primary Government Balance Additions Reductions Balance One Year Governmental activities: Bonds payable: First mortgage 9,907,388 $ - $ 4,030,000 $ 5,877,388 $ 2,991,536 $ Revenues 24,915,000 - 2,230,000 22,685,000 2,210,000 Total bonds payable 34,822,388 - 6,260,000 28,562,388 5,201,536 Compensated absences 3,311,029 3,474,570 3,311,029 3,474,570 3,474,570 Other postemployment benefits liability 6,408,580 345,089 - 6,753,669 - Net Pension Liability 56,854,401 412,656 1,269,427 55,997,630 - Total governmental activities long-term liabilities 101,396,398 $ 4,232,315 $ 10,840,456 $ 94,788,257 $ 8,676,106 $ Business-type activities: First mortgage revenue bonds payable: Coliseum 32,555,000 $ - $ 2,090,000 $ 30,465,000 $ 2,500,000 $ Compensated absences 69,879 145,618 69,879 145,618 145,618 Total business-type activities long-term liabilities 32,624,879 $ 145,618 $ 2,159,879 $ 30,610,618 $ 2,645,618 $ Beginning Ending Due Within Discretely Presented Component Unit: Balance Additions Reductions Balance One Year First mortgage general obligation bonds 31,360,000 $ - $ 6,050,000 $ 25,310,000 $ 5,825,000 $ Compensated absences 718,998 819,003 786,302 751,699 125,283 Net Pension Liability 9,451,765 1,727,101 2,368,656 8,810,210 - Total discretely presented component unit 41,530,763 $ 2,546,104 $ 9,204,958 $ 34,871,909 $ 5,950,283 $ 51 ---PAGE BREAK--- 2016 2017 Unpaid claims, beginning of fiscal year 1,628,964 $ 1,359,257 $ Incurred claims and changes in estimates 11,554,624 10,456,170 Claim payments 11,824,061 10,237,651 Unpaid claims, end of fiscal year 1,359,527 $ 1,577,776 $ medical benefits to employees, retirees, and dependents (excluding postemployment benefits); and natural disasters. The risks of torts; theft of, damage to, and destruction of assets; and natural disasters are covered by commercial insurance from independent third parties. Settled claims from these risks have not exceeded commercial insurance coverage for the past three years. There were no significant reductions in insurance by major category of risk. Automobile Insurance The Vehicle Self-Insurance fund, an internal service fund, services the risk of loss in the following areas: automobile collision and comprehensive. The primary government is continuing to buy premium insurance for a number of other risks/i.e., liability. The primary government is assuming 100 percent of the risk in these areas described above. Each department is responsible for the first $5,000 deductible per each vehicle loss. Funding levels are determined based on the Insurance Director’s analysis of prior years’ claims history. The source of revenue is money appropriated from the County General Fund for automobile insurance, and also from the money or funds collected on behalf of the County arising from automobile insurance. The funding level for 2017 was $405,166. There were no incurred but not reported claims at December 31, 2017. The cash and cash equivalents at December 31, 2017, were $712,967. County Liability Insurance The primary government established the County Liability fund to cover risks involving civil rights claims and errors and omission claims. The source of revenue is money appropriated from the County General Fund under the Sheriff’s Liability and Liability Insurance line item. The funding level for 2017 was $400,000. Incurred but not reported claims have not been accrued as a liability as of December 31, 2017. The cash and cash equivalents at December 31, 2017, were $77,681. Group Health Insurance The primary government has chosen to establish a risk financing fund for risks associated with employee health claims. The risk financing fund is accounted for in the Self-Insurance Health fund, an internal service fund, where assets are set aside for claim settlements. An excess policy through commercial insurance covers individual claims in excess of $300,000 per year. Settled claims resulting from this risk did not exceed commercial insurance coverage in the past three years. Amounts are paid into the fund by all insured funds and are available to pay claims, claim reserves, and administrative costs of the program. Interfund premiums are based primarily upon the insurance premium of each employee paid from a particular fund. The employee pays 13 percent and the fund pays 87 percent. These premiums are reported as quasi-external interfund transactions. Provisions are also made for unexpected and unusual claims. The funding level for 2017 was $11,575,234. The cash and cash equivalents at December 31, 2017, were $8,832,994. Claim expenditures and liabilities of the fund are reported when it is probable that a loss has occurred and the amount of the loss can be reasonably estimated. These losses include an estimate of claims that have been incurred but not reported (IBNRs). Claim liabilities are calculated considering the effects of inflation, recent claim settlement trends including frequency and amounts of pay outs and other economic and social factors. Changes in the balance of claim liabilities during the past two years are as follows: 52 ---PAGE BREAK--- Worker’s Compensation The primary government has chosen to establish a risk financing fund for risks associated with worker’s compensation claims. The risk financing fund is accounted for in the Workman’s Compensation Self-Insurance fund, an internal service fund, where assets are set aside for claim settlements. An excess policy through commercial insurance covers individual claims in excess of $300,000 per year. Settled claims resulting from this risk did not exceed commercial insurance coverage in 2017. Amounts are paid into the fund by all insured funds and are available to pay for worker compensation claims. Interfund premiums are based primarily upon the number of employees paid from a particular fund. The funding level for 2017 was $1,008,260. There were no incurred but not reported claims at December 31, 2017. The cash and cash equivalents at December 31, 2017, were $287,905. B. Contingent Liabilities The primary government is a defendant in various lawsuits. Although the outcome of these lawsuits is not presently determinable, in the opinion of the County Attorney the resolution of these matters will not have a material effect on the condition of the primary government. C. Conduit Debt Obligation The primary government has issued Industrial Revenue Bonds 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 bonds are secured by the property financed and are payable solely from payments received on the underlying mortgage loans. Upon repayment of the bonds, ownership of the acquired facilities transfers to the private-sector entity served by the bond issuance. Neither the primary government, the State, nor any political subdivision thereof is obligated in any manner for the repayment of the bonds. Accordingly, the bonds are not reported as liabilities in the accompanying financial statements. As of December 31, 2017, there were four series of Industrial Revenue Bonds outstanding with an aggregate principal amount payable of $52,186,954. D. Operating Lease to Recovery Health Services, Inc. The Allen County Commissioners leased to Recovery Health Systems, Inc. (Recovery), the personal property, nursing home and real estate used by Byron Health Center. Allen County is retaining the 55 bed residential program and paying Recovery for operations and a management fee. The significant provisions of this lease are as follows: 1. Term of Lease January 1, 2014 through December 31, 2033, is the time period for the twenty year lease that may be extended by mutual written agreement for two successive periods of five years each. Either party may terminate the lease without cause following at least twelve months written notice. 2. Rent Base rent of $450,000, to be paid at an amount of $37,500 per month. An additional amount of $450,000 to fund a capital reserve account to be deposited annually. Payments totaling $787,500 were made during 2017. 3. Improvements Recovery shall pay for all maintenance and improvement expenditures it deems necessary. All other capital expenditures for major repairs or replacements to premises greater than $5,000, shall be mutually agreed to in writing, prior to incurring such expense by the County 53 ---PAGE BREAK--- and Recovery, to be paid from the capital reserve account. The County shall pay 18 percent of specified capital expenditures in excess of those agreed upon to be paid from capital reserve account and Recovery shall pay 82 percent. 4. Insurance Recovery will carry liability, fire and casualty insurance for the mutual benefit of Allen County and Recovery. E. Commitment Allen County and the City of Fort Wayne jointly have an agreement with Atos for information resource management. Atos staffs and manages the operation of the City/County data center and provides technical support for networks, servers, help desk, desktops and application enhancement. The County provides office space, computer operating supplies, utilities, office equipment and items necessary for day to day operations. In addition, the County provides computer hardware as it deems necessary for Atos. The current agreement began on January 1, 2017 and continues through December 31, 2021 with an option for a three year extension. F. Tax Incremental Revenue Bonds and Loans 1. Infrastructure for General Motors Facility Allen County provided certain public infrastructure improvements (water and sewer main extensions, and right-of-way acquisition of Dalman Road) that were necessary to meet a previous commitment to General Motors. These improvements were financed by a $5,233,322, 1997 Tax Increment Revenue Bond (TIF) issued by the Allen County Redevelopment Commission. In July 2005, these bonds were refunded with the Allen County Redevelopment District Tax Increment Revenue Bonds of 2005. The $9,275,000, 2005 Allen County Redevelopment District Tax Increment Revenue Bonds are in two series: Series 2005A (Tax Exempt) and Series B (Taxable). Series 2005A in the amount of $6,985,000 was issued for purposes to cause the 1997 GM TIF bonds to be advance refunded and defeased. Series 2005B in the amount of $2,290,000 was used to provide money to finance the purchase of lease of certain equipment by the Commission to be leased or leased back to General Motors Corporation and pay all costs incidental thereto including the issuance costs of the Series 2005B Bonds. In June 2015, the 2005 bonds were refunded with the Allen County Redevelopment District Tax Increment Revenue Bonds of 2015. The $8,295,000, 2015 Allen County Redevelopment District Tax Increment Revenue Bonds are in three series. Series 2015A in the amount of $4,615,000 and series 2015B in the amount of $1,630,000 were issued for purposes to cause the 2005A and 2005B bonds to be advance refunded and defeased. Series 2015C in the amount of $2,050,000 was used to provide money to finance infrastructure improvements along Pleasant Center Road. Total debt outstanding at December 31, 2017 was $2,605,000 Series 2015A, $935,000 Series 2015B, and $2,050,000 Series 2015C. 2. Infrastructure for Vera Bradley Facility Allen County provided certain public infrastructure improvements (water and sewer main extensions and roadways) that were necessary for Vera Bradley to construct a new manufacturing facility. These improvements were financed by a loan from the Allen County Economic Development Income Tax Fund. The loan outstanding at December 31, 2017, was $315,243. Repayment of this loan will be made by using tax increment financing revenues 54 ---PAGE BREAK--- from the Vera Bradley Economic Development Area established pursuant to Indiana Code 36-7-14-41. 3. Infrastructure for Oak Crossing Economic Development Area (EDA) Allen County provided certain public infrastructure improvements at the intersection of North Clinton Street (formerly Leo Road) and Mayhew Road. These improvements were financed by a loan from various Allen County Highway Funds. The loan outstanding at December 31, 2017, was $193,263. Repayment of the loan will be made by using tax increment financing revenues from the Oak Crossing Economic Development Area (EDA). 4. Infrastructure for General Mills Allen County provided certain public infrastructure improvements for road and drainage and wrote down part of the cost of the property. These improvements were financed by a loan from Allen County Highway and Local Income Tax-Economic Development (formerly CEDIT) Funds. The loan outstanding at December 31, 2017, was $854,308. Repayment of the loan will be made by using tax increment financing revenues from the Bluffton Road East Economic Development Area. 5. Infrastructure for Greatbatch Allen County provided certain public infrastructure improvements for road, drainage, and a water line extension. These improvements were financed by a loan from Allen County Economic Development and Local Income Tax-Economic Development (formerly CEDIT) Funds. The loan outstanding at December 31, 2017, was paid in full. 6. Infrastructure for SDI LaFarga Allen County provided certain public infrastructure improvements for extensive drainage. These improvements were financed by a loan from Allen County Tax Abatement Development Fund. The loan outstanding at December 31, 2017, was paid in full. Economic Development areas were established to repay the above bonds and loans. Property taxes generated from increased property valuations in the economic development areas are used to repay the bonds. Since Allen County as a whole is not obligated to make the debt payments, these bonds are not considered debt of the County. If the increased property taxes do not generate sufficient revenues to pay the debt service payments, up to the highest bond payment, which in 2017 was $1,307,513; 2018 GM TIF requirements may be allocated from the Local Income Tax-Economic Development (formerly CEDIT) towards the debt service payments. G. Tax Abatements Primary Government Allen County provides property tax abatements in accordance with Indiana Code (IC) 6-1.1-12.1. The fiscal body of the County (County Council) has the authority to approve these property tax abatements for both Real and Personal property. In order for property to be eligible for tax abatement, it must be located in an area designated by the fiscal body as an Economic Revitalization Area; for which the County designated all unincorporated real estate as an Economic Revitalization Area in 2004 except for certain areas zoned such as residential or agricultural. As of December 31, 2017, the County property tax abatements can be broken down into two specific categories, Redevelopment or rehabilitation of real estate and Business personal property equipment investment: Redevelopment or rehabilitation of real estate property tax abatements provide for a reduction in taxable assessed value related to the redevelopment of unimproved real estate and rehabilitation of existing real property for the betterment of the area. In order to obtain abatement, the property owner or authorized representative must submit an application 55 ---PAGE BREAK--- Amount of County Tax Tax Abatement Category Revenues Abated Redevelopment or Rehabilitation of real estate property 545,000 $ Business personal property equipment investment 623,000 Total 1,168,000 $ before commencing construction, including the Department of Local Government Finance (DLGF) prescribed Statement of Benefits (SB-1) form, to the County Council. The application and SB-1 includes various information such as but not limited to; the proposed project, estimated project cost, estimated jobs and salaries retained/created. This information is applied to the County’s Tax Abatement Point System which is used to determine the duration of the abatement based on total points. Under IC 6-1.1-12.1-17, County Council has established abatement schedules of 3, 5, 7 and 10 years with variable abatement rates from 5% to 100% throughout the term of the abatement. All abatements must be approved in a public meeting with the passage of a resolution by County Council that includes the terms and schedule of the abatement. The abatement is calculated based on the actual real property assessed value determined by the County Assessor after improvements are made as noted in the original SB-1. The amount of the abatement is then deducted from the gross assessed value of the property to arrive at the net assessed value used in the calculation of the tax bill. Business personal property equipment investment abatements follow the same guidelines mentioned above except that the abatement is for the investment of qualifying new manufacturing, research and development, logistical distribution, or information technology equipment. The abatement is based on the adjusted cost of the new qualifying equipment originally included on the SB-1 and reported by the taxpayer in their personal property tax return. Accordingly, if the equipment is not claimed on the personal property tax return then no abatement is given. One notable exception exists for personal property, in addition to the abatement schedules previously mentioned, IC 6-1.1-12.1-18 allows up to a 20 year abatement schedule and the County has adopted such schedule pending certain criteria is met. For the abovementioned abatements, annual compliance is required involving the submission of the DLGF prescribed compliance forms (CF-1). After reviewing the CF-1 forms, should County Council determine that the applicant is not in compliance with the originally provided SB-1, County Council may determine non-compliance and revoke or deny the abatement for that specific year. Furthermore, IC 6-1.1-12.1-12 provides a mechanism that should a property owner falsely claim the abatement they are liable for the taxes that would have been payable including a 10 percent penalty. County Council Approved Property Tax Abatements December 31, 2017: The County abated property tax revenues totaling $1,168,000 for year ended December 31, 2017 including the following tax abatements that each exceeded 10% of the total County amount abated: Approximately $549,000 in property tax revenues were abated for a global automotive manufacturer for various real and personal property investments as well as job retention and creation. Over $273,000 in property taxes were abated for a global automotive tire producer primarily as a result of significant business personal property investments. A small portion is attributed to real property improvements. 56 ---PAGE BREAK--- Amount of County City/Town Tax Revenues Abated Fort Wayne 909,000 $ New Haven 204,000 Woodburn 52,000 Monroeville 9,000 Huntertown 2,000 Grabill 1,000 Total 1,177,000 $ County tax revenue reductions due to abatements granted by Cities and Towns: Similar to the County, the designating fiscal bodies of Cities and Towns may approve property tax abatements within their incorporated boundaries. In addition to the approximate $1.2 million noted above County property tax revenues were also reduced $1,177,000 due to abatements granted by the Cities and Towns located within the County. These abatements, at minimum, follow the same guidelines under IC that the County abatements do, but each designating body does have the ability to set different investment and job creation criteria, as well as abatement schedules. City and Town approved property tax abatement effect on County revenues: Indiana Economic Development Corporation (IEDC) Tax Abatements: County income tax revenues may also be reduced by certain income tax abatements granted by the IEDC. The IEDC offers various abatement or credit programs but the three most applicable to Allen County are the Community Revitalization Enhancement District (CReED), the Economic Development for a Growing Economy (EDGE) and the Hoosier Business Investment (HBI) tax credits. These programs offer income tax credits for pre-approved eligible capital investment and job creation. As of December 31, 2017, there are approximately 70 recipients in Allen County with Active IEDC contracts for which almost $18,440,000 in credits has been received over the life of these contracts. Credits can be taken against state and/or local tax liability; such as adjusted gross income tax, local income tax, insurance premiums tax, and financial institutions tax. The County is a recipient of the local income and financial institution taxes. For purposes of GASB 77 the abatement of financial institutions tax is not considered an abatement of local tax revenues, but rather a reduction of shared revenue. For year-end December 31, 2017, the amount County income tax revenues are reduced by these credits could not be calculated based on the State information available, but is not estimated to be materially significant. The County estimates any credits applied to local income tax revenues would be immaterial given over $121 million of local income tax revenue was received and allocated to Allen County taxing units during 2017 alone. If you take the $18,440,000 in credits received and divide evenly amongst the average Active Term contract length of 3.7 years, the credit is $4,984,000 per year. Taking into context these credits would be applied to the four taxes previously noted; the applicability to the local tax would be minimal if at all. County Commitments: The County has Ledge and Tax Increment Finance (TIF) commitments to certain parties which may be in conjunction with or completely separate from property tax abatements. These commitments arise from agreements between the recipient and the County Redevelopment Commission, Commissioners and Council for job creation in return for certain incentives. Terms of these agreements may vary between each agreement. Contrary to the previously mentioned tax abatements for which revenue is forgone, the property tax revenue to fund these commitments and the associated expense are reflected in the fund financial statements. The 57 ---PAGE BREAK--- Real Personal Total Governmental Unit Property Tax Property Tax Abated Allen County 205,379 $ 234,921 $ 440,300 $ Fort Wayne 205,196 137,460 342,656 Grabill 414 - 414 Huntertown 775 97 872 Monroeville 2,008 1,497 3,505 New Haven 32,635 44,157 76,792 Woodburn 13,126 6,340 19,466 Total 459,533 $ 424,472 $ 884,005 $ No amounts have been received and no amounts are receivable from other governments in association with the forgone tax revenue. County paid recipient’s $373,000 during 2017 for achieving goals outlined in the Ledge and TIF agreements. Discretely Presented Component Unit The Allen County Public Library has not entered into any tax abatement agreements. However, other local governmental units have entered into tax abatement agreements that have reduced the Library’s revenues during 2017. The table below summarizes the taxes that have been abated. H. Other Postemployment Benefits Single-Employer Defined Benefit Healthcare Plan Plan Description The Allen County Retiree Healthcare Plan is a single-employer defined benefit healthcare plan administered by Allen County in an internal service fund. The plan provides health care benefits to eligible retirees and their spouses. Indiana Code 5-10-8 assigns the authority to establish and amend benefit provisions to the County. Funding Policy The contribution requirements of plan members for the Allen County Retiree Healthcare Plan are established by the County Commissioners. The required contribution is based on projected pay- as-you-go financing requirements. For the year ended December 31, 2017, the County contributed $452,486 to the plan. Annual OPEB Cost and Net OPEB Obligation The County's annual other postemployment benefit (OPEB) cost (expense) is calculated based on the annual required contribution of the employer (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 unfunded actuarial liabilities (or funding excess) over a period not to exceed 30 years. The following table shows the components of the County's annual OPEB cost for the year, the amount actually contributed to the plan, and changes in the County's net OPEB obligation to the plan: 58 ---PAGE BREAK--- The County's annual OPEB cost, the percentage of the annual OPEB cost contributed to the plan, and the net OPEB obligation for 2017 and the two preceding years were as follows: Funded Status and Funding Progress As of December 31, 2017, the most recent actuarial valuation date, the plan was unfunded. The actuarial accrued liability for benefits was $8,173,498, and the actuarial value of assets was resulting in an unfunded actuarial accrued liability (UAAL) of $8,173,498, and the ratio of the UAAL to covered payroll was 12.7 percent. 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 the healthcare cost trend. 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. Actuarial Methods and Assumption Projections of benefits for financial reporting purposes are based on the substantive plan (the plan as understood by the employer and the 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 December 31, 2017, actuarial valuation, the projected unit credit cost method was used. The actuarial assumptions included an annual healthcare cost trend rate of 8.5 percent initially, reduced by decrements to an ultimate rate of 5 percent after 7 years. The UAAL is being amortized as a level dollar amount over 30 years based on an open group. The remaining amortization period at December 31, 2017, was 20 years. Annual required contribution 902,622 $ Interest on net OPEB obligation 288,386 Adjustment to annual required contribution (393,433) Annual OPEB cost 797,575 Contributions made (452,486) Increase in net OPEB obligation 345,089 Net OPEB obligation, beginning of year 6,408,580 Net OPEB obligation, end of year 6,753,669 $ Percentage Annual of Annual Net Year OPEB OPEB Cost OPEB Ending Cost Contributed Obligation 12/31/2015 794,988 59% 6,170,950 12/31/2016 750,062 68% 6,408,580 12/31/2017 797,575 57% 6,753,669 59 ---PAGE BREAK--- I. Revenues Pledged Governmental Activities Revenues Pledged Allen County has pledged future wheel and sur tax revenues, net of specified expenditures in the Sur/Wheel Tax Bridge Fund, to repay revenue bonds issued in 2009. Proceeds from the bonds provided financing for Maplecrest Road Bridge. The bonds may be payable from wheel and sur tax net revenues and are payable through 2032. The 2017 debt payments were made from the Major Bridge fund. Business-type Activities Revenues Pledged Allen County has pledged future revenues, net of specified operating expenditures in the War Memorial Coliseum fund (an enterprise fund), to repay revenue bonds issued in 2011, 2014 and 2016. Proceeds from the bonds provided financing for renovation and expansion of the War Memorial Coliseum (a sports arena and convention center). The bonds are payable solely from the War Memorial Coliseum fund net revenues and are payable through 2034. Annual principal and interest payments are expected to require less than 25 percent of net revenues. J. Subsequent Events In February 2018, the Internal Revenue Service (IRS) conducted an audit of Allen County Government for tax years 2015, 2016, and 2017. It was found through the course of this audit that Allen County had incorrectly reported employee earnings and tax withholding. This resulted in payment of back taxes in the amount of $955,466 for the audited tax years. There were no penalties or interest assessed by the IRS. K. Retirement Plan 401(a) Effective after December 31, 2014, Allen County enacted a “soft” freeze in participation in the Indiana Public Retirement System (INPRS). Any newly hired employees after December 31, 2014, will be eligible for participation in a deferred compensation matching contribution retirement program. The County may, at the Board of Commissioners discretion, match employee contributions up to five percent of that employee’s wages with a six year graded vesting schedule in the employer contributions. Any newly hired employee that was a previous member of INPRS with any governmental unit will be reenrolled in that pension plan and not be eligible for the deferred compensation plan. L. Pension Plans A. Cost Sharing Multiple-Employer Defined Benefit Pension Plans Public Employees’ Retirement System Plan Description The primary government contributes to the Indiana Public Employees' Retirement Fund (PERF), a cost-sharing multiple-employer defined benefit pension plan. PERF provides retirement, disability, and survivor benefits to plan members and beneficiaries. All full-time employees hired before December 31, 2014 or hired after December 31, 2014 and are previous PERF members are eligible to participate in the defined benefit plan. State statutes (IC 5-10.2 and 5-10.3) govern, through the Indiana Public Retirement System (INPRS) Board, most requirements of the system and give the primary government authority to contribute to the plan. The PERF retirement benefit consists of the pension provided by employer contributions plus an annuity provided by the member's annuity savings account (ASA). The annuity savings account consists of member's contributions, set by state statute at three percent of compensation, plus the interest credited to the member's account. The employer may elect to make the contributions on behalf of the member. 60 ---PAGE BREAK--- The Allen County Public Library (discretely presented component unit) contributes to the Indiana Public Employees’ Retirement Fund (PERF), a defined benefit pension plan. All full- time Library employees are eligible to participate in the defined benefit plan. INPRS administers the plan and issues a publicly available financial report that includes financial statements and required supplementary information for the plan as a whole and for its participants. The report is available online at http://www.inprs.in.gov/ or may be obtained by contacting: Indiana Public Retirement System 1 North Capitol Street, Suite 001 Indianapolis, IN 46204 Ph. (888) 526-1687 Benefits Provided The PERF retirement benefit consists of the sum of a defined pension benefit provided by the County contributions plus the amount credited to the member’s annuity savings account. Pension benefits vest after 10 years of creditable service. Members are immediately vested in their annuity savings account. At retirement, a member may choose to receive a lump sum payment of the amount credited to the member’s annuity savings account, receive the amount as an annuity, or leave the contributions invested with INPRS. A member who has reached age 65 and has at least 10 years of creditable service is eligible for normal retirement and is entitled to 100 percent of the pension benefit component. This annual pension benefit is equal to 1.1 percent times the average annual compensation times the number of years of creditable service. The average annual compensation in this calculation uses the highest 20 calendar quarters of salary in a covered position. A member who has reached age 60 and has at least 15 years of creditable service is eligible for normal retirement and is entitled to 100 percent of the pension benefit. A member who is at least 55 years old and whose age plus number of years of creditable service is at least 85 is entitled to 100 percent of the pension benefit. A member who has reached age 50 and has at least 15 years of creditable service is eligible for early retirement with a reduced pension. A member retiring early receives a percentage of the normal pension benefit, which remains the same for the member’s lifetime. The PERF plan also provides disability benefits to members. A member who has at least 5 years of creditable service and becomes disabled while in active service, on FMLA leave, receiving worker’s compensation benefits, or receiving employer provided disability insurance benefits may retire for the duration of the disability if they have qualified for social security disability benefits and furnish proof of the qualification. The disability benefit is calculated the same as that for a normal retirement without reduction for early retirement. Also, under certain circumstances, upon the death in service of a member, a survivor benefit may be paid to a surviving spouse or surviving dependent children under the age of 18. The pension benefits for members in pay status may be increased periodically as cost of living adjustments (COLA), however, such increases are not guaranteed by statute and have historically been provided on an “ad hoc” basis. These increases can only be granted by the Indiana General Assembly. Contributions The contribution requirements of plan members are established and may be amended by the INPRS Board of Trustees. The required contributions are based on actuarial investigation and valuation in accordance with IC 5-10.2. The funding policy provides for periodic employer contributions at actuarially determined rates that, expressed as percentages of annual covered payroll, are sufficient to fund the pension benefits when they become due. 61 ---PAGE BREAK--- Long Term Target Expected Real Allocation Rate of Return Public Equity 22.0 4.9% Private Equity 14.0 5.7 Fixed Income - Ex Inflation Linked 20.0 2.3 Fixed Income - Inflation Linked 7.0 0.6 Commodities 8.0 2.2 Real Estate 7.0 3.7 Absolute Return 10.0 3.9 Risk Parity 12.0 5.1 Total 100.0 PERF members are required to contribute three percent of their annual covered salary. For 2017, the primary government is required to contribute at an actuarially determined rate of 11.2 percent of annual covered payroll. The primary government’s contribution to the plan for the year ending December 31, 2017 was $5,497,878 and was equal to the required contribution for 2017. For 2017, the Allen County Public Library (discretely presented component unit) was required to contribute an actuarially determined rate of 11.2 percent of annual covered payroll. The Library’s contribution to the plan for the year ending December 31, 2017 was $1,069,059. Actuarial Assumptions There were no changes in assumptions for the June 30, 2017 actuarial valuation. The actuarial assumptions used in the June 30, 2017 valuation of the Public Employee’s Retirement Fund were adopted by the INPRS Board in April, 2015. The total pension liability in the June 30, 2017 actuarial valuation was determined using the following actuarial assumptions, applied to all periods included in the measurement: The actuarial assumptions for the June 30, 2017 valuation were generally unchanged from the prior year, except that for active and inactive vested members, a salary load of $400 was added to approximate the impact on average earnings of unused sick leave accumulated at termination of employment. For disable members, the mortality assumption is updated from the RP-2014 (with MP-2014 improvement removed) Total Data Set Mortality tables to the RP-2014 (with MP-2014 improvement removed) Disability Mortality Tables. Mortality rates for healthy members were based on the RP-2014 Total Dataset mortality table with the Social Security Administration’s generational improvement scale from 2006. Mortality rates for disabled members were based on RP-2014 Disability Mortality Table with the Social Security Administration’s generational improvement scale from 2006. The actuarial assumptions used are based on plan experience from July 1, 2010 through June 30, 2014 and were first used in the June 30, 2015 valuation. The actuarial cost method used for computing the total pension liability is the Entry Age Normal – Level Percent of Payroll method. The long term return expectation for the INPRS defined benefit retirement plans has been determined by using a building block approach and assumes a time horizon, as defined in the INPRS Investment Policy Statement. A forecasted rate of inflation serves as the baseline for the return expectation. Various real return premiums over the baseline inflation rate have been established for each asset class. The long term expected nominal rate of return has been determined by calculating a weighted average of the expected real return premiums for each asset class, adding the projected inflation rate, and adding the expected return from rebalancing uncorrelated asset classes. The target allocation and best estimates of geometric real rates of return for each major asset class are summarized below: Inflation 2.25% Salary Increases 2.5% to 4.25% Cost-of-living increases 1.00% 62 ---PAGE BREAK--- Discount Rate The discount rate used to measure the total pension liability was 6.75 percent. The projection of cash flows used to determine the discount rate assumed the contributions from employers would be, at a minimum, made at the actuarially determined required rates computed in accordance with the current funding policy adopted by the INPRS Board. Projected inflows from investment earnings were calculated using the long term assumed investment rate of 6.75 percent. Based on those assumptions, each defined benefit pension plan’s fiduciary net position 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 benefits to determine the total pension liability for each plan. Sensitivity of the County’s Proportionate Share of the Net Pension Liability to Changes in the Discount Rate The following represents the net pension liability of the County (primary government) and the Allen County Public Library (discretely presented component unit), calculated using the discount rate of 6.75 percent, as well as what their respective net pension liability would be if it were calculated using a discount rate that is 1-percentage point lower (5.75 percent) or 1-percentage point higher (7.75 percent) than the current rate: Pension Liabilities, Pension Expense, and Deferred Outflows of Resources and Deferred Inflows of Resources Related to Pensions As of December 31, 2017, the primary government recorded a pension liability of $46,150,206 for their proportionate share of the net pension liability. The net pension liability was measured as of June 30, 2017, and the total pension liability used to calculate the net pension liability was determined by an actuarial valuation as of that date. The primary government’s proportion of the net pension liability was based on wages reported by employers relative to the collective wages of the plan. At June 30, 2017, the primary government’s proportion was .0103440 percent, which was a increase of .0002382 from its proportion measured as of June 30, 2016. As of December 31, 2017, the Allen County Public Library (discretely presented component unit) reported a liability of $8,810,210 for their proportionate share of the net pension liability. At June 30, 2017, the Library’s portion was .0019747 percent, which was an decrease of .0001079 percent from its proportion measured as of June 30, 2016. For the year ended June 30, 2017, the primary government recognized pension expense of $8,044,490. At June 30, 2017, the primary government reported deferred outflows of resources and deferred inflows of resources related to pensions from the following sources: Current 1% Decrease Discount Rate 1% Increase (5.75%) (6.75%) (7.75%) County's proportionate share of the net pension liability 67,308,214 $ 46,150,206 $ 28,562,012 $ Current 1% Decrease Discount Rate 1% Increase (5.75%) (6.75%) (7.75%) Library's proportionate share of the net pension liability 12,849,336 $ 8,810,210 $ 5,452,572 $ 63 ---PAGE BREAK--- Year Ended June 30 2018 1,447,113 $ 2019 3,098,771 2020 1,054,749 2021 (248,272) 2022 - Thereafter - The primary government reported $2,735,612 as deferred outflows of resources related to pensions resulting from the primary government’s contributions subsequent to the measurement date that will be recognized as a reduction of net pension liability in the year ended December 31, 2018. Other amounts reported as deferred outflows of resources and deferred inflows of resources related to pensions will be recognized in pension expense as follows: For the year ended June 30, 2017, the Allen County Public Library (discretely presented component unit) recognized pension expense of $1,727,101. At June 30, 2017, the Library reported deferred outflows of resources and deferred inflows of resources related to pensions from the following sources: The Allen County Public Library (discretely presented component unit) reported $535,821 as deferred outflows of resources related to pensions resulting from Library contributions subsequent to the measurement date that will be recognized as a reduction of their net pension liability in the year ended December 31, 2018. Other amounts reported as deferred outflows of resources and deferred inflows of resources related to pensions will be recognized in pension expense as follows: Deferred Outflows Deferred Inflows of Resources of Resources Differences between expected and actual experience 876,443 $ 35,817 $ Net difference between projected and actual investment earnings on pension plan investments 7,300,153 2,313,812 Change of assumptions 740,980 - Changes in proportion and differences between employer contributions and proportionate share of contributions 807,244 2,022,830 Employer contributions subsequent to the measurement date 2,735,612 - Total 12,460,432 $ 4,372,459 $ Deferred Outflows Deferred Inflows of Resources of Resources Differences between expected and actual experience 167,315 $ 6,837 $ Net difference between projected and actual investment earnings on pension plan investments 1,393,621 441,713 Change of assumptions 141,455 - Changes in proportion and differences between employer contributions and proportionate share of contributions 148,802 338,081 Employer contributions subsequent to the measurement date 535,821 - Total 2,387,014 $ 786,631 $ 64 ---PAGE BREAK--- Year Ended June 30 2018 446,608 $ 2019 479,735 2020 185,615 2021 (47,396) 2022 - Thereafter - Pension Plan Fiduciary Net Position The pension plan’s fiduciary net position has been determined on the same basis of accounting used by the pension plan. Detailed information about the pension plan’s fiduciary net position is available in the separately issued INPRS financial report, which is available online at http://www.inprs.in.gov or may be obtained by contacting: Indiana Public Retirement System One North Capitol Avenue, Suite 001 Indianapolis, IN 46204 Ph. (888) 526-1687 Benefit Payment Policies Pension, disability, special death benefits, and distributions of contributions and interest are recognized when due and payable to members or beneficiaries. Benefits are paid once the retirement or survivor applications have been processed and approved. Distributions of contributions and interest are refunds from non-vested inactive members’ annuity savings accounts. These distributions may be requested by members or automatically distributed by the fund when certain criteria are met. Valuation of Pension Plan Investments Investments are generally reported at fair value. Fair value is the price that would be received to sell an asset in an orderly transaction between market participants at the measurement date. Short-term investments consist primarily of cash, money market funds, certificates of deposits and fixed income instruments with maturities of less than one year. Short-term investments are generally reported using cost-based measures, which approximates fair value. Fixed income securities consist primarily of the U.S. government, U.S. government-sponsored agencies, publicly traded debt and commingled investment debt instruments. Equity securities consist primarily of domestic and international stocks in addition to commingled equity instruments. Fixed income and equity securities are generally valued based on published market prices and quotations from national security exchanges and security pricing services. Securities that are not traded on a national security exchange are valued using modeling techniques that include market observable inputs. Commingled funds are valued using the net asset value (NAV) of the entity. Alternative investments include limited partnership interests in private market, absolute return, real estate and risk parity investment strategies. Publicly traded alternative investments are valued based on quoted market prices. In the absence of readily determinable public fair values, alternative investments are valued using current estimates of fair value obtained from the general partner or investment manager. Holdings are generally valued by a general partner or investment 65 ---PAGE BREAK--- Inactive plan members or beneficiaries currently receiving benefits 94 Inactive plan members or beneficiaries entitled to but not yet receiving benefits 9 Active plan members 129 Total 232 manager on a quarterly or semi-annual basis. Valuation assumptions are gbased upon the nature of the investment and the underlying business. Additionally, valuation techniques will vary by investment type and involve a certain degree of expert judgement. Alternative investments, such as investments in private market or real estate, are generally considered to be illiquid long-term investments. Due to the inherent uncertainty that exists in the valuation of alternative investments, the realized value upon the sale of an asset may differ significantly from the fair value. Derivative instruments are marked to market daily with changes in fair value recognized as part of investments and investment income. Fully benefit-responsive guaranteed investment contracts are reported at contract value. B. Single-Employer Defined Benefit Pension Plans 1. County Police Retirement Plan Plan Description The Allen County Police Retirement Plan (Plan) is a single-employer defined benefit pension plan established to provide retirement, termination/severance, disability, and survivor benefits for a person employed by the Allen County Police Department (Employer) as a County Policeman, Sheriff, or Deputy Sheriff with full police power (Employee), as such terms are used in Indiana Code. Indiana Code 36-8-10-12 grants the authority to the Employer and a trustee to establish and amend the benefit terms to the Plan with approval of the county fiscal body. The Plan was established on January 1, 1965 and is administered by the Committee. The composition of the Committee, according to the Plan legal document, shall be the Sheriff and the Merit Board (the Merit Board, per IC 36-8-10-3, consists of five members, three members appointed by the Sheriff, and two members elected by a majority vote of the members of the county police force). At December 31, 2017, Plan membership consisted of the following: Benefits Provided The Plan provides that the retirement benefit shall be a pension payable for the longer of 120 months or the member’s lifetime equal to two and one-half percent of the member’s average wage received during the highest paid sixty (60) calendar months before retirement (such calendar months must be consecutive) plus one dollar this sum multiplied by the member’s years of credited service up to twenty (20) years; plus an additional two percent of the member’s average wage, as outlined above, multiplied by the member’s years of credited service in excess of twenty (20) years up to an additional twelve (12) years. Members are eligible to retire as of normal retirement for an unreduced benefit upon attainment of age fifty-five (55) and completion of at least twenty (20) years of credited service, or age sixty (60). A member who continues employment beyond his normal retirement age shall be eligible for a late retirement benefit upon actual retirement equal to the member’s benefit earned in accordance to the normal retirement formula with credit given for subsequent service (provided that the thirty-two (32) year credited service maximum shall not be exceeded in computing the benefit). The severance benefit payable to a member prior to completion of five years of credited service or attainment of age forty-five (45) is a lump sum payment of the net amount of 66 ---PAGE BREAK--- contributions (including interest) plus the amount transferred by the member for the purchase of credited service. After completion of five years of credit service or attainment of age forty-five (45), a member may elect to receive a lump sum, as outlined above, or may leave the contributions in the plan and receive one hundred percent (100%) of the member portion of the accrued benefit deferred until his normal retirement date. Additionally, a benefit shall be payable equal to the amount earned under the normal retirement benefit formula, using credited service as of his date of severance, reduced by the member portion of the accrued benefit, multiplied by the vesting factor outlined in the plan document with respect to years of vesting service or age commencing on the member’s normal retirement date. If a member separates employment due to disability, he may elect to receive a lump sum payment of the net amount of contributions (including interest) plus the amount transferred by the member for the purchase of credited service, reducing the benefit that shall be payable from the Supplemental Benefit Plan. In the event a married or unmarried member who does not have a 100% vested interest dies as a result of non-line of duty activity prior to reaching his normal retirement date, the designated beneficiary shall be entitled to receive a death benefit which shall be a lump sum equal to his net amount of contributions (including interest) plus the amount transferred by the member for the purchase of credited service. In the event a married or unmarried member who has a 100% vested interest dies as a result of non-line of duty or line of duty activity prior to reaching his normal retirement date, the designated beneficiary shall be entitled to receive a death benefit which shall be a lump sum equal to his net amount of contributions (including interest), reducing the benefit payable that shall be payable from the Supplemental Benefit Trust. In the event an unmarried member, or a married member who has designated a beneficiary other than his spouse, dies after attaining his normal retirement date but prior to the commencement of any benefit from the Plan, the designated beneficiary shall receive 120 payment equal to the amount of the pension the participant would have received if payments had commenced on the date of his death. In the event a married member, who has designated his spouse as his beneficiary, dies after attaining his normal retirement date but prior to the commencement of any benefit from the Plan, the surviving spouse shall receive 100% of the participant’s accrued benefit as a annuity payable for their remaining lifetime. Contributions The Employer intends to contribute to the Plan each year such amounts as may be required to operate the Plan on a sound actuarial basis. The minimum annual contribution by the department must be sufficient, as determined by the pension engineers, to prevent deterioration in the actuarial status of the trust fund during the year. According to IC 36-8-10- 12(e), if the department fails to make minimum contributions for three successive years, the pension trust terminates and the trust fund shall be liquidated. For the year ending December 31, 2017, the mandatory member contribution rate (per the Plan’s legal document) was 3.00% of annual pay and the actuarially determined Employer’s contribution rate was 28.2% of annual payroll. Investment Policy The pension plan’s policy in regard to the allocation of invested assets is established and may be amended by the Board (per Plan legal document) by a majority vote of its members. To maintain compliance with the Investment Policy Statement, the board retains the ability to implement changes in asset allocation. This will be accomplished by the direction of Fund cash flows to various asset classes and/or the reallocation of funds among asset categories. At its option, the Board may initiate a formal asset allocation study every three to five years to 67 ---PAGE BREAK--- Target Allocation Asset Class Percentage Domestic Large Stocks 28 Domestic Small Stocks 15 Domestic Bonds 24 High Yield Bonds 8 Dev. International Stocks 15 Emerging Market Stocks 5 Real Estate 0 Cash & Equivalents 5 Total 100 aid it in its asset allocation discussions and decisions. The Board desires the portfolios to be fully invested. Cash (or its equivalents) are not deemed a strategic asset of the overall Fund. The Board has revised the asset allocation policy on June 4, 2015. Rate of Return For the year ended December 31, 2017, the annual money-weighted rate of return on pension plan investments, net of pension plan expense was 6.75 percent. The money-weighted rate of return expresses the investment performance, net of investment expense, adjusted for the changing amounts actually invested. Deferred Retirement Option Program The Deferred Retirement Option Program (DROP) for the Plan was established on July 1, 2011 pursuant to the Plan’s legal document and is governed by the Employer and a trustee. Members of the Plan that are eligible to retire with an unreduced benefit may elect to accumulate a DROP benefit while continuing to work. At the time of their election, the member executes an irrevocable election to retire on a DROP retirement date and remain in active service, but the member does not contribute to the fund during the DROP period. A member who has attained age fifty-five (55) and completed at least twenty (20) years of service or attained age sixty (60) may irrevocably elect to enter the DROP for a period not longer than three years and shall not extend beyond the date the member is credited with thirty-two (32) years of service. From the date the member enters the DROP, he will not be credited with any additional years of service. The member’s DROP frozen benefit will be equal to the pension benefit calculated under the standard benefit formula based upon the member’s salary and years of credited service as of the DROP entry date. Upon actual severance of employment by retirement at any time after the DROP entry date, the member will receive their DROP benefit accumulation in the available form/option elected by the member in addition to the DROP frozen benefit to be paid as a annuity. As of December 31, 2017, the balance of the amounts held by the plan pursuant to the DROP is $55,619. Net Pension Liability of the Plan The components of the net pension liability of the Plan at December 31, 2017 were as follows: Total pension liability 61,043,251 $ Plan fiduciary net position (51,344,650) Plan's net pension liability 9,698,601 $ Plan fiduciary net position as a percentage of the total pension liability 84.11% 68 ---PAGE BREAK--- Pension Expense of the Plan Pension expense of $2,309,946 must be recognized for the fiscal year ending December 31, 2017. Significant Actuarial Assumptions Discount Rate The discount rate used to measure the total pension liability was 6.75% as of December 31, 2017, and is equal to the long-term expected return on plan investments. The projection cash flows used to determine the discount rate assumed that employer contributions would be made at the actuarially calculated rate computed in accordance with IC 36-8-10-12(e) to prevent the deterioration in the actuarial status of the trust. The future contribution assumption was based upon the review of recent Employer contribution history compared to the corresponding actuarially determined contributions. Based on this assumption, the Plan’s fiduciary net position was projected to be available to make all projected future benefit payments of current plan members. Sensitivity of the Net Pension Liability to Changes in the Discount Rate The following presents the net pension liability of the Allen County Police Retirement Plan, calculated using the discount rate of 6.75%, as well as what the Allen County Police Retirement Plan’s net pension liability would be if it were calculated using a discount rate that is 1- percentage-point lower (5.75%) or 1-percentage-point higher (7.75%) than the current rate: Measurement Date December 31, 2017 Valuation Date Assets December 31, 2017 Liabilities December 31, 2017 - Actual member census data as of December 31, 2017 was used in the valuation. Inflation Rate 3.00% per annum Future Salary Increases 4.00% per annum (3.00% increases due to inflation and 1.00% due to merit/seniority.) Investment Rate of Return 6.75% per annum, net of pension plan investment expenses, including inflation Cost of Living Increase Not Applicable Mortality Assumption RP-2014 Adjusted to 2006 Total Dataset Mortality with Two Dimensional Generational Mortality Improvement Projection Scale MP-2017 (separate employee and annuitant tables and male and female tables) Current 1% Decrease Discount Rate 1% Increase (5.75%) (6.75%) (7.75%) Total Pension Liability 68,248,968 $ 61,043,251 $ 54,990,712 $ Plan Fiduciary Net Position 51,344,650 51,344,650 51,344,650 Net Pension Liability 16,904,318 $ 9,698,601 $ 3,646,062 $ 69 ---PAGE BREAK--- Fiscal Year End Amortization Dec. 31, 2018 658,582 $ Dec. 31, 2019 502,121 Dec. 31, 2020 (401,941) Dec. 31, 2021 (192,423) Dec. 31, 2022 61,874 Thereafter - Deferred Outflows of Resources and Deferred Inflows of Resources Related to Pensions At December 31, 2017, the deferred outflows/(inflows) of resources based on obligations for the plan are as follows: The balances as of December 31, 2017 of the deferred outflows/(inflows) of resources will be recognized in pension expense as follows: Initial Annual December 31, 2017 Initial Balance Amortization Period Recognition Balance Liability experience losses/(gains): Base for year ending December 31, 2017 1,212,624 $ 5.157 235,141 $ 977,483 $ Base for year ending December 31, 2016 227,812 5.243 43,451 140,910 Base for year ending December 31, 2015 108,503 5.157 21,040 45,383 Base for year ending December 31, 2014 (430,349) 5.322 (80,862) (106,901) Base for year ending December 31, 2013 - N/A - - Changes in assumptions: Base for year ending December 31, 2017 819,710 $ 5.157 158,951 $ 660,759 $ Base for year ending December 31, 2016 (544,042) 5.243 (103,765) (336,512) Base for year ending December 31, 2015 732,983 5.157 142,134 306,581 Base for year ending December 31, 2014 1,239,380 5.322 232,879 307,864 Base for year ending December 31, 2013 - N/A - - Investment losses/(gains): Base for year ending December 31, 2017 (2,859,279) $ 5.000 (571,856) $ (2,287,423) $ Base for year ending December 31, 2016 (947,387) 5.000 (189,477) (568,433) Base for year ending December 31, 2015 3,587,780 5.000 717,556 1,435,112 Base for year ending December 31, 2014 266,954 5.000 53,391 53,390 Base for year ending December 31, 2013 - N/A - - 658,583 $ 628,213 $ Amortization periods: The changes in total pension liability due to liability experience losses/(gains) and changes in assumptions for the most current year have been amortized over 5.157 years, the average remaining service of all members with any liability in the plan as of January 1, 2017. The change in net pension liability due to investment losses/(gains) has been amortized over 5.0 years as prescribed. Assumption changes: The changes in assumptions for base year ending December 31, 2017 reflect the change from the use of the RP-2014 Adjusted to 2006 Blue Collar Mortality with Two Dimensional Generational Mortality Improvement Scale MP-2016 (separate employee and annuitant tables and male and female tables) to the RP-2014 Adjusted to 2006 Total Dataset mortality with Two Dimensional Generational Mortality Improvement Scale MP-2017 (separate employee and annuitant tables and male and female tables). The changes in assumptions for base year ending December 31, 2016 reflect the change from the use of the RP-2014 Adjusted to 2006 Blue Collar Mortality with Two Dimensional Generational Mortality Improvement Scale MP-2015 (separate employee and annuitant tables and male and female tables) to the RP-2014 Adjusted to 2006 Blue Collar Mortality with Two Dimensional Generational Mortality Improvement Scale MP-2016 (separate employee and annuitant tables and male and female tables). The changes in assumptions for base year ending December 31, 2015 reflect the change from the use of the 2015 IRS Combined Morality Tables for Small Plans (separate male and female tables) as prescribed for use in corporate valuations to the RP-2014 Adjusted to 2006 Blue Collar Mortality with Two Dimensional Generational Mortality Improvement Scale MP-2015 (separate employee and annuitant tables and male and female tables). The changes in assumptions for base year ending December 31, 2014 reflect the change from a discount rate and salary scale of 7.00% and 4.50% to a discount rate and salary scale of 6.75% and 4.00%. 70 ---PAGE BREAK--- 2. County Police Benefit Plan Plan Description The Allen County Police Benefit Plan (Plan) is a single-employer defined benefit pension plan established to provide disability, death, and survivor/dependent benefits for a person employed by the Allen County Police Department (Employer) as a County Policeman, Sheriff, or Deputy Sheriff with full police power (Employee), as such terms are used in Indiana Code. Indiana Code 36-8-10 Sections 14, 15, 16 and 17 grant the authority to the Employer and a trustee to establish and amend the benefit terms to the Plan with approval of the county fiscal body. The Plan was established on January 1, 1965 and is administered by the Committee. The composition of the Committee, according to the Plan’s legal document, shall be the Sheriff and the Merit Board (the Merit Board, per IC 36-8-10-3, consists of five members, three members appointed by the Sheriff, and two members elected by a majority vote of the members of the county police force). At December 31, 2017, Plan membership consisted of the following: Benefits Provided If a member becomes disabled after attainment of age forty (45) and completion of 5 years of credited service, the Plan shall provide a benefit payable for life or until recovery from the disability. The amount of the benefit shall be equal to the accrued retirement benefit or the employer portion of the accrued benefit if employee contributions plus interest are withdrawn, payable at normal retirement date. The participant may elect to begin receiving the actuarial equivalent of this benefit on his disability date. In the event a married member who does not have a 100% vested interest dies as a result of non-line of duty activity prior to reaching his normal retirement date, there shall be payable a benefit of one thousand dollars ($1,000) to such member’s surviving spouse for the spouse’s remaining lifetime. In the event a married member who has a 100% vested interest dies as a result of non-line of duty or line of duty activity prior to reaching his normal retirement date, there shall be payable a benefit equal to the greater of one thousand dollars ($1,000) or seventy-five percent (75%) of the member’s accrued benefit earned as of the date of the member’s death, adjusted to reflect any withdrawal of mandatory contributions plus interest, if applicable, to such member’s surviving spouse for the spouse’s remaining lifetime. In the event an unmarried member who has a 100% vested interest dies as a result of non- line of duty or line of duty activity prior to reaching his normal retirement date, there shall be payable a benefit equal to seventy-five percent (75%) of the member’s accrued benefit earned as of the date of the member’s death, adjusted to reflect any withdrawal of mandatory contributions plus interest, if applicable, to such member’s designated beneficiary as a ten (10) year period certain only benefit. Contributions The Employer intends to contribute to the Plan each year such amounts as may be required to operate the Plan on a sound actuarial basis. The minimum annual contribution by the department must be sufficient, as determined by the pension engineers, to prevent Inactive plan members or beneficiaries currently receiving benefits 6 Inactive plan members or beneficiaries entitled to but not yet receiving benefits - Active plan members 129 Total 135 71 ---PAGE BREAK--- Total pension liability 2,223,556 $ Plan fiduciary net position (2,074,733) Plan's net pension liability 148,823 $ Plan fiduciary net position as a percentage of the total pension liability 93.31% deterioration in the actuarial status of the trust fund during the year. According to IC 36-8-10- 12(e), if the department fails to make minimum contributions for three successive years, the pension trust terminates and the trust fund shall be liquidated. For the year ending December 31, 2017, the actuarially determined Employer’s contribution rate was 1.3% of annual payroll. Investment Policy The pension plan’s policy in regard to the allocation of invested assets is established and may be amended by the Board (per Plan legal document) by a majority vote of its members. To maintain compliance with the Investment Policy Statement, the Board retains the ability to implement changes in asset allocation. This will be accomplished by the direction of Fund cash flows to various asset classes and/or the reallocation of funds among asset categories. At its option, the Board may initiate a formal asset allocation study every three to five years to aid it in its asset allocation discussions and decisions. The Board desires the portfolios to be fully invested. Cash (or its equivalents) are not deemed a strategic asset of the overall Fund. The Board has revised the asset allocation policy on June 4, 2015. Rate of Return For the year ended December 31, 2017, the annual money-weighted rate of return on pension plan investments, net of pension plan expense was 6.75 percent. The money- weighted rate of return expresses investment performance, net of investment expense, adjusted for the changing amounts actually invested. Net Pension Liability of the Plan The components of the net pension liability of the Plan at December 31, 2017 were as follows: Pension Expense of the Plan Pension expense of $125,642 must be recognized for the fiscal year ending December 31, 2017. Target Allocation Asset Class Percentage Domestic Large Stocks 28 Domestic Small Stocks 15 Domestic Bonds 24 High Yield Bonds 8 Dev. International Stocks 15 Emerging Market Stocks 5 Real Estate 0 Cash & Equivalents 5 Total 100 72 ---PAGE BREAK--- Significant Actuarial Assumptions Discount Rate The discount rate used to measure the total pension liability was 6.75% as of December 31, 2017, and is equal to the long-term expected return on plan investments. The projection cash flows used to determine the discount rate assumed that employer contributions would be made at the actuarially calculated rate computed in accordance with IC 36-8-10-12(e) to prevent the deterioration in the actuarial status of the trust. The future contribution assumption was based upon the review of recent Employer contribution history compared to the corresponding actuarially determined contributions. Based on this assumption, the Plan’s fiduciary net position was projected to be available to make all projected future benefit payments of current plan members. Sensitivity of the Net Pension Liability to Changes in the Discount Rate The following presents the net pension liability of the Allen County Police Benefit Plan, calculated using the discount rate of 6.75%, as well as what the Allen County Police Benefit Plan’s net pension liability would be if it were calculated using a discount rate that is 1-percentage-point lower (5.75%) or 1-percentage point higher (7.75%) than the current rate: Deferred Outflows of Resources and Deferred Inflows of Resources Related to Pensions At December 31, 2017, the deferred outflows/(inflows) of resources based on obligations for the Plan are as follows: Measurement Date December 31, 2017 Valuation Date Assets December 31, 2017 Liabilities December 31, 2017 - Actual member census data as of December 31, 2017 was used in the valuation. Inflation Rate 3.00% per annum Future Salary Increases 4.00% per annum (3.00% increases due to inflation and 1.00% due to merit/seniority.) Investment Rate of Return 6.75% per annum, net of pension plan investment expenses, including inflation Cost of Living Increase Not Applicable Mortality Assumption j y Dimensional Generational Mortality Improvement Projection Scale MP- 2017 (separate employee and annuitant tables and male and female tables) Line of Duty Death Assumption 10% of active participant deaths are assumed to occur in line of duty Current 1% Decrease Discount Rate 1% Increase (5.75%) (6.75%) (7.75%) Total Pension Liability 2,509,447 $ 2,223,556 $ 1,984,669 $ Plan Fiduciary Net Position 2,074,733 2,074,733 2,074,733 Net Pension Liability (Asset) 434,714 $ 148,823 $ (90,064) $ 73 ---PAGE BREAK--- Fiscal Year End Amortization Dec. 31, 2018 22,319 $ Dec. 31, 2019 19,975 Dec. 31, 2020 (10,531) Dec. 31, 2021 (4,611) Dec. 31, 2022 18,408 Thereafter 42,110 The balances as of December 31, 2017 of the deferred outflows/(inflows) of resources will be recognized in pension expense as follows: Initial Annual December 31, 2017 Initial Balance Amortization Period Recognition Balance Liability experience losses/(gains): Base for year ending December 31, 2017 234,333 $ 8.897 26,338 $ 207,995 $ Base for year ending December 31, 2016 (110,212) 8.982 (12,270) (85,672) Base for year ending December 31, 2015 (142,295) 8.846 (16,086) (94,037) Base for year ending December 31, 2014 83,472 9.086 9,187 46,724 Base for year ending December 31, 2013 - N/A - - Changes in assumptions: Base for year ending December 31, 2017 (9,204) $ 8.897 (1,035) $ (8,169) $ Base for year ending December 31, 2016 (2,828) 8.982 (315) (2,198) Base for year ending December 31, 2015 63,730 8.846 7,204 42,118 Base for year ending December 31, 2014 48,929 9.086 5,385 27,389 Base for year ending December 31, 2013 - N/A - - Investment losses/(gains): Base for year ending December 31, 2017 (115,095) $ 5.000 (23,019) $ (92,076) $ Base for year ending December 31, 2016 (29,592) 5.000 (5,918) (17,756) Base for year ending December 31, 2015 152,520 5.000 30,504 61,008 Base for year ending December 31, 2014 11,728 5.000 2,346 2,344 Base for year ending December 31, 2013 - N/A - - 22,321 $ 87,670 $ Amortization periods: The changes in total pension liability due to liability experience losses/(gains) and changes in assumptions for the most current year have been amortized over 8.897 years, the average remaining service of all members with any liability in the plan as of January 1, 2017. The change in net pension liability due to investment losses/(gains) has been amortized over 5.0 years as prescribed. Assumption changes: The changes in assumptions for base year ending December 31, 2017 reflect the change from the use of the RP-2014 Adjusted to 2006 Blue Collar Mortality with Two Dimensional Generational Mortality Improvement Scale MP-2016 (separate employee and annuitant tables and male and female tables) to the RP-2014 Adjusted to 2006 Total Dataset Mortality with Two Dimensional Generational Mortality Improvement Scale MP-2017 (separate employee and annuitant tables and male and female tables). The changes in assumptions for base year ending December 31, 2016 reflect the change from the use of the RP-2014 Adjusted to 2006 Blue Collar Mortality with Two Dimensional Generational Mortality Improvement Scale MP-2015 (separate employee and annuitant tables and male and female tables) to the RP-2014 Adjusted to 2006 Blue collar Mortality with Two Dimensional Generational Mortality Improvement Scale MP-2016 (separate employee and annuitant tables and male and female tables). The changes in assumptions for base year ending December 31, 2015 reflect the change from the use of the 2015 IRS Combined Mortality Tables for Small Plans (separate male and female tables) as prescribed for use in corporate valuations to the RP-2014 Adjusted to 2006 Blue Collar Mortality with Two Dimensional Generational Mortality Improvement Scale MP-2015 (separate employee and annuitant tables and male and female tables). The changes in assumptions for base year ending December 31, 2014 reflect the change from a discount rate and salary scale of 7.00% and 4.50% to a discount rate and salary scale of 6.75% and 4.00%. 74 ---PAGE BREAK--- 3. Financial Statements for Defined Benefit Plans County Police County Police Retirement Plan Benefit Plan Assets Cash and cash equivalents 3,495,328 $ 89,927 $ Receivables: County contributions 64,719 Employee contributions 17,771 - Accrued interest and dividends 30,652 760 Total receivables 48,423 65,479 Investments: Fixed income securities 19,448,163 761,091 Domestic and foreign equities 28,420,900 1,158,236 Total investments 47,869,063 1,919,327 Total Assets 51,412,814 2,074,733 Liabilities Payables: Transfers out of trust 64,719 - Other - - Total Liabilities 64,719 - Net position restricted for Pensions 51,348,095 2,074,733 STATEMENT OF FIDUCIARY NET POSITION 75 ---PAGE BREAK--- County Police County Police Retirement Plan Benefit Plan Additions Contributions: Employer 2,093,845 86,292 Employee 224,832 N/A Total contributions 2,318,677 86,292 Investment Income: Interest and Dividends 1,202,994 44,947 Net increase in fair value of investments 4,737,807 193,463 Less investment expense - - Net investment income 5,940,801 238,410 Total additions 8,259,478 324,702 Deductions Benefit payments (including refunds of employee contributions) 2,750,435 64,661 Administrative expense 106,541 1,062 Total deductions 2,856,976 65,723 Net increase in Net Pension 5,402,502 258,979 Net Position Restricted for Pensions Beginning of year 45,945,593 1,815,754 End of year 51,348,095 2,074,733 STATEMENT OF CHANGES IN FIDUCIARY NET POSITION 76 ---PAGE BREAK--- County Police Retirement Plan 2017 2016 2015 2014 Total Pension liability Service Cost 1,023,466 $ 979,124 $ 902,114 $ 901,082 $ Interest 3,810,038 3,704,007 3,533,405 3,489,167 Changes in plan provisions 18,385 - - - Difference between expected and actual experience 1,212,624 227,812 108,503 (430,349) Change in assumptions 819,710 (544,042) 732,983 1,239,380 Benefit payments (2,754,592) (2,941,827) (2,690,363) (2,708,792) Net change in Total Pension Liability 4,129,631 1,425,074 2,586,642 2,490,488 Total pension liability - beginning of year 56,913,620 55,488,546 52,901,904 50,411,416 Total pension liability - end of year 61,043,251 $ 56,913,620 $ 55,488,546 $ 52,901,904 $ Plan fiduciary net position County contributions 2,093,845 $ 1,940,126 $ 1,913,674 $ 1,880,580 $ Employee contributions 225,547 236,520 196,306 186,665 Net transfers into (out of) trust (64,719) - (13,964) - Net investment income 5,940,799 3,817,637 (623,338) 2,669,670 Benefit payments (2,754,592) (2,941,827) (2,690,363) (2,708,792) Administrative expenses (106,541) (95,041) (87,552) (104,620) Other 64,719 - 13,964 - Net change in Plan Fiduciary Net Position 5,399,058 2,957,415 (1,291,273) 1,923,503 Plan fiduciary net position - beginning of year 45,945,592 42,988,177 44,279,450 42,355,947 Plan fiduciary net position - end of year 51,344,650 $ 45,945,592 $ 42,988,177 $ 44,279,450 $ Net Pension Liability (Asset) - End of Year - 9,698,601 $ 10,968,028 $ 12,500,369 $ 8,622,454 $ Plan fiduciary net position as a percentage of the total pension liability 84.11% 80.73% 77.47% 83.70% Covered-employee payroll 8,424,630 7,311,096 6,869,667 6,456,147 Net pension liability as a percentage of covered-employee payroll 115.12% 150.02% 181.96% 133.55% Notes to Schedule: *Information presented for the years information is available ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION Last 10 Years* SCHEDULE OF CHANGES IN THE COUNTY'S NET PENSION LIABILITY AND RELATED RATIOS 77 ---PAGE BREAK--- County Police Benefit Plan 2017 2016 2015 2014 Total pension liability Service Cost 87,624 $ 83,300 $ 73,017 $ 54,354 $ Interest 127,583 125,214 121,101 108,193 Changes in plan provisions 10,367 - - - Difference between expected and actual experience 234,333 (110,212) (142,295) 83,472 Change in assumptions (9,204) (2,828) 63,730 48,929 Benefit payments (64,661) (64,781) (65,021) (65,291) Net change in Total Pension Liability 386,042 30,693 50,532 229,657 Total pension liability - beginning of year 1,837,514 1,806,821 1,756,289 1,526,632 Total pension liability - end of year 2,223,556 $ 1,837,514 $ 1,806,821 $ 1,756,289 $ Plan fiduciary net position County contributions 86,292 $ 93,510 $ 55,854 $ 70,445 $ Employee contributions N/A N/A N/A N/A Net transfers into (out of) trust - - - - Net investment income 238,410 141,729 (38,491) 99,777 Benefit payments (64,661) (64,781) (65,021) (65,291) Administrative expenses (1,062) (947) (843) (703) Other - - - - Net change in Plan Fiduciary Net Position 258,979 169,511 (48,501) 104,228 Plan fiduciary net position - beginning of year 1,815,754 1,646,243 1,694,744 1,590,516 Plan fiduciary net position - end of year 2,074,733 $ 1,815,754 $ 1,646,243 $ 1,694,744 $ Net Pension Liability (Asset) - End of Year - 148,823 $ 21,760 $ 160,578 $ 61,545 $ Plan fiduciary net position as a percentage of the total pension liability 93.31% 98.82% 91.11% 96.50% Covered-employee payroll 8,424,630 7,311,096 6,869,667 6,456,147 Net pension liability as a percentage of covered-employee payroll 1.77% 0.30% 2.34% 0.95% Notes to Schedule: *Information presented for the years information is available ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF CHANGES IN THE COUNTY'S NET PENSION LIABILITY AND RELATED RATIOS Last 10 Years* 78 ---PAGE BREAK--- 2017 2016 2015 2014 2013 2012 2011 2010 County Police Retirement Plan Actuarially determined contribution** 1,940,644 $ 1,793,068 $ 1,770,122 $ 1,744,741 $ 1,699,803 $ 1,593,248 $ 1,719,383 $ 1,712,696 $ County contributions recognized 2,093,845 1,940,126 1,913,674 1,880,580 1,832,170 1,723,869 1,865,658 1,881,767 Contribution deficiency (excess) (153,201) $ (147,058) $ (143,552) $ (135,839) $ (132,367) $ (130,621) $ (146,275) $ (169,071) $ Covered - employee payroll 7,311,096 $ 6,869,667 $ 6,456,147 $ 6,309,482 $ 6,183,034 $ 6,118,166 $ 5,983,558 $ 6,250,714 $ Contributions recognized as a percentage of covered-employee payroll 28.64% 28.24% 29.64% 29.81% 29.63% 28.18% 31.18% 30.10% Notes to schedule Valuation date: Actuarially determined contribution rates are calculated as of January 1, two years prior to the end of the fiscal year in which contributions are reported. Methods and assumptions used to determine most current contribution rate above: Actuarial cost method Frozen initial liability Amortization method Level percentage of payroll, open Remaining amortization period 29 years Asset valuation method Inflation 3.0% Salary increases 4.00% average, including inflation Investment rate of return 6.75% Retirement age The later of age 55 and 20 years of service or one year from the valuation date Mortality RP-2014 Adjusted to 2006 Blue Collar Mortality with Two Dimensional Generational Mortality Improvement Projection Scale MP-2015 (separate employee and annuitant tables and male and female tables) Other Information: None *Schedule presented for years information available ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF COUNTY CONTRIBUTIONS Last 10 Years* 5-Year Asset Smooting, limited to 80% and 120% of market value 79 ---PAGE BREAK--- 2017 2016 2015 2014 2013 2012 2011 2010 County Police Benefit Plan Actuarially determined contribution** 86,292 $ 93,510 $ 55,854 $ 70,445 $ 89,939 $ 103,962 $ 85,351 $ 88,233 $ County contributions recognized 86,292 93,510 55,854 70,445 89,939 103,962 85,351 88,233 Contribution deficiency (excess) - $ - $ - $ - $ - $ - $ - $ - $ Covered - employee payroll 7,311,096 $ 6,869,667 $ 6,456,147 $ 6,309,482 $ 6,183,034 $ 6,118,166 $ 5,983,558 $ 6,250,714 $ Contributions recognized as a percentage of covered-employee payroll 1.18% 1.36% 0.87% 1.12% 1.45% 1.70% 1.43% 1.41% Notes to schedule Valuation date: Actuarially determined contribution rates are calculated as of January 1, two years prior to the end of the fiscal year in which contributions are reported. Methods and assumptions used to determine most current contribution rate above: Actuarial cost method Aggregate Amortization method Not Applicable Remaining amortization period Not Applicable Asset valuation method Inflation 3.0% Salary increases 4.00% average, including inflation Investment rate of return 6.75% Retirement age Mortality RP-2014 Adjusted to 2006 Blue Collar Mortality with Two Dimensional Generational Mortality Improvement Projection Scale MP-2015 (separate employee and annuitant tables and male and female tables) Other Information: None *Schedule presented for years information available The later of age 55 and 20 years of service or one year from the valuation date ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF COUNTY CONTRIBUTIONS Last 10 Years* 5-Year Asset Smoothing, limited to 80% and 120% of market value 80 ---PAGE BREAK--- 2017 2016 2015 2014 2013 County Police Retirement Plan Annual money-weighted rate of return 13.04% 9.00% (1.43%) 6.35% 14.90% 2012 2011 2010 2009 2008 Annual money-weighted rate of return 10.30% (1.40%) 12.40% 24.90% (22.90%) ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF INVESTMENT RETURNS Last 10 Fiscal Years 81 ---PAGE BREAK--- 2017 2016 2015 2014 2013 County Police Benefit Plan Annual money-weighted rate of return 13.17% 8.59% (2.35%) 6.29% 14.80% *Schedule presented for the years information available. ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF INVESTMENT RETURNS Last 10 Fiscal Years* 82 ---PAGE BREAK--- Proportion of the Proportionate Share Net Pension Liability Net Pension of the Net Pension Actual Covered (Asset) as a Percentage Year Ended Liability (Asset) Liability (Asset) Member Payroll of Covered Payroll June 30, 2017 1.03440% 46,150,206 $ 51,318,423 $ 89.93% June 30, 2016 1.01058% 45,864,613 48,432,812 94.70% June 30, 2015 1.12838% 45,957,812 54,047,347 85.03% June 30, 2014 1.06157% 27,897,371 51,829,153 53.83% Notes to Schedule: * Information presented for the years information is available. The data provided in the schedule is based as of the measurement date of INPRS (PERF) net pension liability. ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF PROPORTIONATE SHARE NET PENSION LIABILITY AND REALTED RATIOS Last 10 Years* INPRS (PERF) 83 ---PAGE BREAK--- Statutorily Actual Required Actual Covered Contributions as a Contribution Employer Member Percentage of Year Ended Percentage Contributions Payroll Covered Payroll June 30, 2017 11.20% 5,497,878 51,318,423 10.71% June 30, 2016 11.20% 5,599,448 48,432,812 11.56% June 30, 2015 11.20% 5,535,190 54,047,347 10.24% June 30, 2014 11.20% 4,890,857 51,829,153 9.44% Notes to Schedule: * Information presented for the years information is available. The data provided in the schedule is based as of the measurement date of INPRS (PERF) net pension liability. ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF EMPLOYER CONTRIBUTIONS Last 10 Years* INPRS (PERF) 84 ---PAGE BREAK--- Retiree Health Care and Early Retiree Incentive Plan Unfunded Actuarial AAL as a Actuarial Accrued Percentage Actuarial Value of Liability Unfunded Funded Covered of Covered Valuation Assets (AAL) AAL Ratio Payroll Payroll Date (a-b) (a/b) 1-1-2013 - 7,509,487 (7,509,487) 0% 54,307,794 (14%) 1-1-2014 - 7,766,894 (7,766,894) 0% 55,937,028 (14%) 1-1-2015 - 8,212,772 (8,212,772) 0% 57,629,696 (14%) 1-1-2016 - 7,862,010 (7,862,010) 0% 59,358,587 (13%) 1-1-2017 - 8,173,498 (8,173,498) 0% 64,413,609 (13%) ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION SCHEDULES OF FUNDING PROGRESS 85 ---PAGE BREAK--- Variance Variance Actual With Final Actual With Final Amounts Budget Amounts Budget (Budgetary Positive (Budgetary Positive Original Final Basis) (Negative) Original Final Basis) (Negative) Revenues: Taxes: Property 73,900,313 $ 73,900,313 $ 74,738,260 $ 837,947 $ - $ - $ - $ - $ Licenses and permits 2,130,000 2,130,000 2,689,296 559,296 - - - - Intergovernmental 10,639,154 10,639,154 13,847,730 3,208,576 - - - - Charges for services 3,262,624 3,262,624 3,690,688 428,064 - - - - Fines and forfeits 1,325,000 1,325,000 1,176,437 (148,563) - - - - Other 1,611,500 1,611,500 3,230,334 1,618,834 58,000 58,000 122,844 64,844 Total revenues 92,868,591 92,868,591 99,372,745 6,504,154 58,000 58,000 122,844 64,844 Expenditures: Current: General government 45,492,211 45,204,728 41,240,236 3,964,492 - - - - Public safety 42,795,215 43,851,301 42,837,931 1,013,370 - - - - Highway and streets - - - - - - Health and welfare 5,790,019 6,279,625 6,259,726 19,899 - - - - Culture and recreation 564,508 590,689 575,313 15,376 - - - - Economic development - 2,451 2,451 - - - - - Total expenditures 94,641,953 95,928,794 90,915,657 5,013,137 - - - - Other financing sources (uses): Transfers In 693,600 693,600 2,217,721 1,524,121 - - - Transfers Out (145,000) (145,000) (145,000) - - - - - Temporary loan proceeds - - - - 340,000 340,000 340,000 - Repayment of temporary loan - - - - - - - - Total other financing sources (uses) 548,600 548,600 2,072,721 1,524,121 340,000 340,000 340,000 - Net change in fund balances (1,224,762) (2,511,603) 10,529,809 13,041,412 398,000 398,000 462,844 64,844 Fund balances - beginning 16,424,405 16,424,405 16,424,405 - 13,143,861 13,143,861 13,143,861 - Fund balances - December 31 15,199,643 $ 13,912,802 $ 26,954,214 $ 13,041,412 $ 13,541,861 $ 13,541,861 $ 13,606,705 $ 64,844 $ General Fund Budgeted Amounts Rainy Day Fund Budgeted Amounts ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION BUDGETARY COMPARISON SCHEDULES - GENERAL FUND AND MAJOR SPECIAL REVENUE FUNDS For The Year Ended December 31, 2017 86 ---PAGE BREAK--- The major differences between Budgetary (Non-GAAP) basis and GAAP basis are: a. Revenues are recorded when received in cash (budgetary) as opposed to susceptible to accrual (GAAP). b. Expenditures are recorded when paid in cash (budgetary) as opposed to when the liability is incurred (GAAP). Rainy General Day Net change in fund balances (budgetary basis) 10,529,809 $ 462,844 $ Adjustments: To adjust revenues for accruals 3,062,076 (330,392) To adjust expenditures for accruals (3,861,647) - Net change in fund balances (GAAP basis) 9,730,238 $ 132,452 $ Adjustments necessary to convert the results of operations at the end of the year on a budgetary basis to a GAAP basis are as follows: ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION BUDGET/GAAP RECONCILIATION GENERAL FUND AND MAJOR SPECIAL REVENUE FUNDS For The Year Ended December 31, 2017 87 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 Local Local Juvenile Income Tax - Income Tax - County Local Road Service of County Detention Assets Public Safety Dist Shares Highway and Street Process Health Alternative Grant Cash and cash equivalents 628,555 $ - $ 4,910,121 $ 1,500,311 $ 27,408 $ 2,680,267 $ 20,666 $ Investments - - 507,730 194,868 - 234,988 - Receivables (net of allowances for uncollectibles): Interest - - 9,123 - - 3,051 - Taxes 773,928 - - - - 111,379 - Accounts - - 11,203 - - 10,088 - Special assessments - - - - - - - Intergovernmental - - 11,387 22,841 - 2,147 - Interfund receivables: Interfund loans - - 632,118 193,263 - - - Assets held for resale - - - - - - - Total assets 1,402,483 $ - $ 6,081,682 $ 1,911,283 $ 27,408 $ 3,041,920 $ 20,666 $ Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable 52,464 $ - $ 504,956 $ 190,692 $ - $ 27,983 $ - $ Accrued payroll and withholdings payable - - 263,220 - - 163,237 1,046 Interfund payables: Interfund loans - - 473,850 - - - - Total liabilities 52,464 - 1,242,026 190,692 - 191,220 1,046 Deferred inflows of resources: Unavailable revenue - property taxes - - - - - 88,165 - Unavailable revenue - license excise taxes - - - - - 23,214 - Unavailable revenue - income taxes 773,928 - - - - - - Total deferred inflows of resources 773,928 - - - - 111,379 - Fund balances: Nonspendable fund balance - $ - $ - $ - $ - $ - $ - $ Restricted fund balance 576,091 - 4,839,656 1,720,591 27,408 2,739,321 19,620 Committed fund balance - - - - - - - Assigned fund balance - - - - - - - Unassigned fund balance - - - - - - - Total fund balances 576,091 - 4,839,656 1,720,591 27,408 2,739,321 19,620 Total liabilities, deferred inflows of resources, and fund balances 1,402,483 $ - $ 6,081,682 $ 1,911,283 $ 27,408 $ 3,041,920 $ 20,666 $ 88 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Supplemental Supplemental County Juvenile Adult Probation Accident Surveyor's Corner Firearms County Probation Services Services Report Perpetuation Training Extradition 100,989 $ 9,426 $ 16,042 $ 700,285 $ 18,788 $ 24,841 $ 10,112 2,085 - - - - 131 27 - - - - - - - - - - 13,473 14,969 3,226 27,295 - - - - - - - - 5,575 - - - - - - - - - - - - - - - - - 130,280 $ 26,507 $ 19,268 $ 727,580 $ 18,788 $ 24,841 $ 2,372 $ 6,719 $ - $ - $ - $ - $ 3,878 25,579 - 2,928 - - - - - - - - 6,250 32,298 - 2,928 - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ 124,030 - 19,268 724,652 18,788 24,841 - - - - - - - - - - - - - (5,791) - - - - 124,030 (5,791) 19,268 724,652 18,788 24,841 130,280 $ 26,507 $ 19,268 $ 727,580 $ 18,788 $ 24,841 $ 89 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Recorders County Law Records Drainage Jail Local Health County Enforcement Perpetuation Maintenance Commissary Maintenance User Fee Continuing Education 461,554 $ 5,655,540 $ 501,857 $ 103,924 $ 67,268 $ 2,207 $ 51,723 537,472 - 10,740 - - 672 - - - - - - - - - - - 86,401 50 - - 3,248 - - 18,784 - - - - - 1,947 - - - 1,042 - - - - - - - - - - - - 600,350 $ 6,213,793 $ 501,857 $ 114,664 $ 70,516 $ 3,249 $ 3,261 $ 18,795 $ - $ - $ 2,961 $ - $ 23,124 - - 10,342 - - - - - - - - 26,385 18,795 - 10,342 2,961 - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ 573,965 6,194,998 501,857 - 67,555 3,249 - - - 104,322 - - - - - - - - - - - - - - 573,965 6,194,998 501,857 104,322 67,555 3,249 600,350 $ 6,213,793 $ 501,857 $ 114,664 $ 70,516 $ 3,249 $ 90 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Community Alcohol Abuse County Community Corrections - Redevelopment Hazardous Deterrent Corrections Corrections Home Detention Commission Waste Program 15,117 $ 629,597 $ 983,240 $ 31,926 $ 2,679,088 $ 11,076 $ - - - 3,168 258,499 - - - - - 3,357 - - - - - - - - - 4,082 - - 7,009 - - - - - - - - - - - - - - - - - - - - - - - - 15,117 $ 629,597 $ 987,322 $ 35,094 $ 2,940,944 $ 18,085 $ - $ 66,930 $ - $ 4,230 $ - $ 11,955 $ - 135,014 80,105 - - - - - - - - - - 201,944 80,105 4,230 - 11,955 - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ 15,117 427,653 907,217 30,864 2,940,944 6,130 - - - - - - - - - - - - - - - - - - 15,117 427,653 907,217 30,864 2,940,944 6,130 15,117 $ 629,597 $ 987,322 $ 35,094 $ 2,940,944 $ 18,085 $ 91 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Park and Emergency Vehicle Recreation Economic Planning and Title Record Narcotics Nonreverting Development Right to Know Inspection Check Plat Book 63,562 $ 613,861 $ 379,654 $ 248,071 $ 7,831 $ 112,041 $ 460,439 $ - 59,511 36,587 - - - - - 773 - - - - - - - - - - - - - - - - - 1,503 840 - - - - - - - - - - - - - - - - - - - - - - - - - - - - 63,562 $ 674,145 $ 416,241 $ 248,071 $ 7,831 $ 113,544 $ 461,279 $ - $ 9,338 $ 106,454 $ - $ - $ - $ 4,376 $ - - - - - - 3,966 - - - - - - - - 9,338 106,454 - - - 8,342 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ - $ 63,562 664,807 - 248,071 7,831 113,544 452,937 - - 309,787 - - - - - - - - - - - - - - - - - - 63,562 664,807 309,787 248,071 7,831 113,544 452,937 63,562 $ 674,145 $ 416,241 $ 248,071 $ 7,831 $ 113,544 $ 461,279 $ 92 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances County Supplemental ICJI Court Drug Free Public Defender Community Public Drug Appointed Community Services Supervision Information Task Force Special Advocate 187,889 $ 178,453 $ 4,247 $ 473,697 $ 27,610 $ 259,300 $ - - - - - - - - - - - - - - - - - - 13,825 3,509 - 66,497 - - - - - - - - - - - - - - - - - - - - - - - - - - 201,714 $ 181,962 $ 4,247 $ 540,194 $ 27,610 $ 259,300 $ - $ 1,750 $ - $ 6,344 $ - $ - $ - - - 7,871 - 6,700 - - - - - - - 1,750 - 14,215 - 6,700 - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ 201,714 180,212 4,247 - 27,610 - - - - 525,979 - 252,600 - - - - - - - - - - - - 201,714 180,212 4,247 525,979 27,610 252,600 201,714 $ 181,962 $ 4,247 $ 540,194 $ 27,610 $ 259,300 $ 93 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Allen Park and Indiana Law Department County Law Prosecutor Tax Recreation Enforcement of Planning Statewide 911 Enforcement PCA Sale Fee Gift Assist Grant Services 1,022,432 $ 30,201 $ 28,304 $ 280,501 $ 173,162 $ - $ 334,158 $ 102,266 - 2,726 - 16,692 - - 1,328 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 50,676 - 17,861 - - - - - - - - - - - - - - - 1,126,026 $ 30,201 $ 31,030 $ 331,177 $ 189,854 $ 17,861 $ 334,158 $ - $ - $ - $ 2,610 $ - $ - $ - $ - - - 3,850 - - - - - - - - 2,748 - - - - 6,460 - 2,748 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ - $ 1,126,026 30,201 31,030 324,717 189,854 15,113 - - - - - - - 334,158 - - - - - - - - - - - - - - 1,126,026 30,201 31,030 324,717 189,854 15,113 334,158 1,126,026 $ 30,201 $ 31,030 $ 331,177 $ 189,854 $ 17,861 $ 334,158 $ 94 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Circuit Superior Medical Care Chemical Infraction Court Pre-Trial Court for Inmates Testing Jury Fee Deferral Fee ADR Plan Diversion ADR Plan 9,304 $ 78,160 $ 489 $ 272,590 $ 45,960 $ 158,028 $ 4,547 $ - - - - - - - - - - - - - - - - - - - - - - 1,331 2,590 44,914 1,320 15,236 1,185 - - - - - - - - - - 83,189 - 56,548 - - - - - - - - - - - - - - - 9,304 $ 79,491 $ 3,079 $ 400,693 $ 47,280 $ 229,812 $ 5,732 $ 5,579 $ 6,432 $ - $ 9,644 $ 1,046 $ - $ - $ - - - 36,116 - 33,756 - - - - - - - - 5,579 6,432 - 45,760 1,046 33,756 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ - $ 3,725 - 3,079 354,933 46,234 196,056 5,732 - 73,059 - - - - - - - - - - - - - - - - - - - 3,725 73,059 3,079 354,933 46,234 196,056 5,732 9,304 $ 79,491 $ 3,079 $ 400,693 $ 47,280 $ 229,812 $ 5,732 $ 95 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Campaign Community Allen County Algor Mortis Finance Surveyor's Federal Transitions Stormwater Morgue Study Enforcement Petition Asset Seizure Program Study 463 $ 186 $ 9,513 $ 6,726 $ 896,291 $ 33,435 $ 57,520 $ - - - - 93,490 - 5,543 - - - - 1,214 - - - - - - - - - - - - - - - - - - - - - - - - - - - - 17,725 - - - - - - - - - - - - - - - 463 $ 186 $ 9,513 $ 6,726 $ 990,995 $ 51,160 $ 63,063 $ - $ - $ - $ - $ 40,943 $ - $ - $ - - - - - 17,825 - - - - - - - - - - - - 40,943 17,825 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ - $ 463 186 9,513 6,726 950,052 33,335 63,063 - - - - - - - - - - - - - - - - - - - - - 463 186 9,513 6,726 950,052 33,335 63,063 463 $ 186 $ 9,513 $ 6,726 $ 990,995 $ 51,160 $ 63,063 $ 96 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Juvenile Mobile Clerk Alcohol Internet Prisoner Public Defender Command Record and Drug Sales Access Reimbursement User Fees Unit Perpetuation User Fees Disclosure 147,341 $ 9,971 $ 29,444 $ 11,159 $ 639,356 $ 187,206 $ 129,190 $ - - 2,711 1,075 - - 12,271 - - - - - - 159 - - - - - - - - - 722 - 22,395 44,898 525 - - - - - - - 1,712 - - - - - - - - - - - - - - - - - - - - 149,053 $ 9,971 $ 32,877 $ 12,234 $ 661,751 $ 232,104 $ 142,145 $ - $ - $ - $ - $ - $ 11,488 $ - $ - - 1,110 - - 34,435 - - - - - - - - - - 1,110 - - 45,923 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ - $ - - 31,767 12,234 661,751 186,181 142,145 149,053 9,971 - - - - - - - - - - - - - - - - - - - 149,053 9,971 31,767 12,234 661,751 186,181 142,145 149,053 $ 9,971 $ 32,877 $ 12,234 $ 661,751 $ 232,104 $ 142,145 $ 97 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Allen County Prosecutor's Tangible Youth Juvenile Center Levy Children's Federal Sheriff Incentive Services Per Per Diem Excess Home Gift Asset Seizure Donation Program Diem Fees Fees 111 $ 47,975 $ 15,951 $ 37,016 $ 2,024 $ 135,320 $ 179,188 $ - - 1,612 3,434 - 13,549 16,930 - - - - - 176 220 - - - - - - - - 1,074 - - - 51 1,050 - - - - - - - - - - - - 3,045 17,675 - - - - - - - - - - - - - - 111 $ 49,049 $ 17,563 $ 40,450 $ 2,024 $ 152,141 $ 215,063 $ - $ 2,384 $ - $ - $ - $ 14,832 $ 25,412 $ - - - - - 23,474 - - - - - - - - - 2,384 - - - 38,306 25,412 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ - $ 111 46,665 17,563 40,450 2,024 - - - - - - - 113,835 189,651 - - - - - - - - - - - - - - 111 46,665 17,563 40,450 2,024 113,835 189,651 111 $ 49,049 $ 17,563 $ 40,450 $ 2,024 $ 152,141 $ 215,063 $ 98 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Court Check Adult Improvement TB Tobacco St. Joseph Deception Protective Unsafe Project Emergency Master Plan Foundation Program Services Building Allen-CIP-FY-03/04 Program Program Lead Program 2,406 $ - $ 36,736 $ 15,254 $ - $ 16,589 $ 7,759 $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 73,802 - 3,600 - - - - - - - - - - - - - - - - - 2,406 $ 73,802 $ 36,736 $ 18,854 $ - $ 16,589 $ 7,759 $ - $ - $ - $ - $ - $ - $ - $ - 18,422 - - - 4,247 - - - 55,380 - - - - - - 73,802 - - - 4,247 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ - $ 2,406 - 36,736 18,854 - 12,342 7,759 - - - - - - - - - - - - - - - - - - - - - 2,406 - 36,736 18,854 - 12,342 7,759 2,406 $ 73,802 $ 36,736 $ 18,854 $ - $ 16,589 $ 7,759 $ 99 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Substance Abuse Allen County Prevention and Great KIDS Courts Foreign HIV/AIDS Treatment Supplemental Make Great Electronic Map Language Program Program Education COMMUNITIES Generation Interpreter - $ - $ 1,043 $ 234,403 $ 34,227 $ - $ - - - - 3,298 - - - - - - - - - - - - - - - - - - - - - - - - - 4,980 12,740 - - - - - - - - - - - - - - - - 4,980 $ 12,740 $ 1,043 $ 234,403 $ 37,525 $ - $ - $ - $ - $ 4,004 $ - $ 1,382 $ - 2,354 - - - - 4,980 10,383 - - - 278 4,980 12,737 - 4,004 - 1,660 - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ - 3 1,043 230,399 37,525 - - - - - - - - - - - - - - - - - - (1,660) - 3 1,043 230,399 37,525 (1,660) 4,980 $ 12,740 $ 1,043 $ 234,403 $ 37,525 $ - $ 100 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Allen County Onsite Sheriff NE Sheriff Wastewater Traffic Jury Fee Truancy Department Indiana Foundation Management Enforcement Circuit Court Reduction Training Trails Grants 5,153 $ 7,013 $ 1,912 $ 1,601 $ 888 $ 7,956 $ 13,090 $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 5,153 $ 7,013 $ 1,912 $ 1,601 $ 888 $ 7,956 $ 13,090 $ - $ - $ - $ - $ - $ - $ 13,090 $ - 7,013 - - - - - - - - - - - - - 7,013 - - - - 13,090 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ - $ 5,153 - 1,912 1,601 - - - - - - - 888 7,956 - - - - - - - - - - - - - - - 5,153 - 1,912 1,601 888 7,956 - 5,153 $ 7,013 $ 1,912 $ 1,601 $ 888 $ 7,956 $ 13,090 $ 101 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Identification Legal ISDH Allen County Volunteer Security Enhanced On-site Education Immunization Courts Family Advocates Protection Access Septic System Opportunity Grant Court Grant For Seniors 48,367 $ 31 $ 145,401 $ 564 $ - $ 32,560 $ 16,770 $ - - 14,153 - - - 2,093 - - - - - - - - - - - - - - 5,480 - - - - - - - - - - - - - - - - - 27,209 - - - - - - - - - - - - - - - - 53,847 $ 31 $ 159,554 $ 564 $ 27,209 $ 32,560 $ 18,863 $ - $ - $ - $ - $ - $ 1,700 $ - $ - - 5,989 - 3,321 - - - - - - 23,888 - - - - 5,989 - 27,209 1,700 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ - $ 53,847 31 153,565 564 - 30,860 18,863 - - - - - - - - - - - - - - - - - - - - - 53,847 31 153,565 564 - 30,860 18,863 53,847 $ 31 $ 159,554 $ 564 $ 27,209 $ 32,560 $ 18,863 $ 102 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances State Allen County State Allen County Homeland Smoking Sex/Violent Criminal Alien Problem Auditor's Sheriff Security Ordinance Offender Assistance Solving Ineligible Training Program Coordination Admin Program Court Deductions Center - $ 89 $ 57,716 $ 12,913 $ 6,351 $ 313,866 $ 374 $ - - 5,419 - - 24,122 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ 89 $ 63,135 $ 12,913 $ 6,351 $ 337,988 $ 374 $ - $ - $ - $ - $ - $ 3,311 $ - $ - - 1,188 - - 5,253 - - - - - - - - - - 1,188 - - 8,564 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ - $ - 89 61,947 12,913 6,351 329,424 374 - - - - - - - - - - - - - - - - - - - - - - 89 61,947 12,913 6,351 329,424 374 - $ 89 $ 63,135 $ 12,913 $ 6,351 $ 337,988 $ 374 $ 103 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Health IJC 2016 LIT Refugee Courtools Dept. Veterans Special Interpreter/ Court Reform GIS Influenza Fines Court Dist 25% Translator Grant Infrastructure Vaccination Collections 165 $ 1,261,569 $ 22,720 $ 15,509 $ 199,724 $ 479 $ 24,298 $ - 121,577 - - 25,156 - - - 1,579 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 165 $ 1,384,725 $ 22,720 $ 15,509 $ 224,880 $ 479 $ 24,298 $ - $ - $ - $ - $ 15,177 $ - $ - $ - - - - - - - - - - - - - - - - - - 15,177 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ - $ 165 1,384,725 22,720 15,509 - 479 - - - - - 209,703 - 24,298 - - - - - - - - - - - - - - 165 1,384,725 22,720 15,509 209,703 479 24,298 165 $ 1,384,725 $ 22,720 $ 15,509 $ 224,880 $ 479 $ 24,298 $ 104 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances ACCC Commerical Adult ISDH Radon and Court Law Probation Syringe Healthy Elected County Offender Clerk Grant Service Prog Homes Official Training Transportation 49,150 $ 261,382 $ - $ - $ 201,908 $ 19,973 $ 5,084 25,497 - - 19,379 - - - - - 252 - - - - - - - - - - - 5,480 - - - - - - - - - 9,630 - - - - - - - - - - - - - - - 54,234 $ 286,879 $ 9,630 $ - $ 227,019 $ 19,973 $ - $ 69,153 $ - $ - $ - $ - $ - 10,348 - - - - - - 9,630 - - - - 79,501 9,630 - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ 54,234 207,378 - - 227,019 19,973 - - - - - - - - - - - - - - - - - - 54,234 207,378 - - 227,019 19,973 54,234 $ 286,879 $ 9,630 $ - $ 227,019 $ 19,973 $ 105 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances ARRA County Prosc IV-D Prosc IV-D Clerk IV-D Clerk IV-D IV-D Incentive Incentive Incentive Reassessment Clinic Incentive Incentive Prior to 10/99 Post 10/99 Post 10/99 2015 Donation 5 $ 91,321 $ 85,158 $ 70,374 $ 518,999 $ 830,844 $ 11,130 $ - 9,076 8,205 7,372 50,529 77,271 - - 118 - 96 656 1,003 - - - - - - 23,736 - - - - 116 - - - - - - - - - - - 36,031 - 54,209 36,031 - - - - - - - - - - - - - - - - 5 $ 136,546 $ 93,363 $ 132,167 $ 606,215 $ 932,854 $ 11,130 $ - $ - $ - $ 2,471 $ 1,320 $ 3,132 $ - $ - 3,218 - 1,864 2,226 5,965 - - - - - - - - - 3,218 - 4,335 3,546 9,097 - - - - - - 18,789 - - - - - - 4,947 - - - - - - - - - - - - - 23,736 - - $ - $ - $ - $ - $ - $ - $ 5 133,328 93,363 127,832 602,669 900,021 11,130 - - - - - - - - - - - - - - - - - - - - - 5 133,328 93,363 127,832 602,669 900,021 11,130 5 $ 136,546 $ 93,363 $ 132,167 $ 606,215 $ 932,854 $ 11,130 $ 106 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Maplecrest Cumulative County General Drain Great Batch Special COIT - Bridge Capital CASAD Bond Improvement TIF Flood Control Bond Development East TIF 2,010,312 $ 1,175,606 $ 109,222 $ 195,602 $ - $ 7,767,646 $ 551,685 $ 208,325 115,095 4,349 18,811 - 720,340 42,284 2,705 8,474 - - - 9,354 549 166,764 - - - - 119,291 - - - - - - 112,500 - - 93,590 - - - - - - - - - - - - - - - - - - - - - - - - - - 2,388,106 $ 1,392,765 $ 113,571 $ 214,413 $ - $ 8,729,131 $ 594,518 $ - $ - $ - $ - $ - $ 474,828 $ 31,335 $ - - - - - - - - - - - - - - - - - - - 474,828 31,335 132,006 - - - - 94,428 - 34,758 - - - - 24,863 - - - - - - - - 166,764 - - - - 119,291 - - $ - $ - $ - $ - $ - $ - $ 2,221,342 1,392,765 113,571 - - 8,135,012 563,183 - - - - - - - - - - 214,413 - - - - - - - - - - 2,221,342 1,392,765 113,571 214,413 - 8,135,012 563,183 2,388,106 $ 1,392,765 $ 113,571 $ 214,413 $ - $ 8,729,131 $ 594,518 $ 107 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Pleasant Community Parking Nestle TIF Center Road Development Mossman Garage Major Bridge II Bond Construction Argo Drain Corporation Drain Bond of 2001 3,416,251 $ 438,392 $ 55,490 $ 138,557 $ 434,309 $ 17,841 $ 17 $ 307,928 30,963 5,348 13,353 42,004 1,719 - - - - - 545 - - 78,513 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 3,802,692 $ 469,355 $ 60,838 $ 151,910 $ 476,858 $ 19,560 $ 17 $ 119,477 $ - $ - $ - $ 54,666 $ - $ - $ - - - - - - - - - - - - - - 119,477 - - - 54,666 - - 62,149 - - - - - - 16,364 - - - - - - - - - - - - - 78,513 - - - - - - - $ - $ - $ - $ - $ - $ - $ 3,604,702 469,355 60,838 151,910 - 19,560 - - - - - - - - - - - - 422,192 - 17 - - - - - - - 3,604,702 469,355 60,838 151,910 422,192 19,560 17 3,802,692 $ 469,355 $ 60,838 $ 151,910 $ 476,858 $ 19,560 $ 17 $ 108 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Tax Woodburn Lincoln Uniroyal Abatement Industrial Industrial Goodrich GM 2015 GM 2015B GM 2015A Development TIF TIF TIF General Account Bond Bond 706,857 $ 22,217 $ 287,808 $ 126,729 $ 553,226 $ 152,270 $ 97,188 $ 68,120 - 22,765 1,831 8,743 14,670 9,355 885 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 775,862 $ 22,217 $ 310,573 $ 128,560 $ 561,969 $ 166,940 $ 106,543 $ - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ - $ - 22,217 310,573 128,560 561,969 166,940 106,543 775,862 - - - - - - - - - - - - - - - - - - - - 775,862 22,217 310,573 128,560 561,969 166,940 106,543 775,862 $ 22,217 $ 310,573 $ 128,560 $ 561,969 $ 166,940 $ 106,543 $ 109 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Nestle II Bond GM GM 2015A Nestle II Principal and GM 2015B Supplemental Vera Bradley Reserve Account Reserve Account Interest Account Reserve Account TIF TIF 142,644 $ 89 $ 37,167 $ 215,558 $ 33,168 $ 95,535 $ 13,746 - 3,581 20,773 - 1,470 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 156,390 $ 89 $ 40,748 $ 236,331 $ 33,168 $ 97,005 $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - 315,243 - - - - - 315,243 - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ 156,390 89 40,748 236,331 33,168 - - - - - - - - - - - - - - - - - - (218,238) 156,390 89 40,748 236,331 33,168 (218,238) 156,390 $ 89 $ 40,748 $ 236,331 $ 33,168 $ 97,005 $ 110 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Little River Bandalier Joint Drain TIF 511,378 $ 144,677 $ 48,715 2,960 633 - - - - - 1,739 - 310 - - - - - 562,775 $ 147,637 $ - $ - $ - - - - - - - - - - - - - - - $ - $ 562,775 147,637 - - - - - - 562,775 147,637 562,775 $ 147,637 $ 111 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Bluffton Allen County Road East Oak Crossing Redevelopment Sur/Wheel TIF TIF Capital Tax Bridge 39,109 $ 194,297 $ 7,962,824 $ 3,169,492 $ 3,239 3,142 593,308 308,504 - - 7,704 4,006 - - - - - - - - - - - - - - - 7,604 - - - - - - 966,088 - 42,348 $ 197,439 $ 9,529,924 $ 3,489,606 $ - $ - $ - $ - $ - - - - 854,308 193,263 - - 854,308 193,263 - - - - - - - - - - - - - - - - - - - $ - $ 966,088 $ - $ - 4,176 8,563,836 3,489,606 - - - - - - - - (811,960) - - - (811,960) 4,176 9,529,924 3,489,606 42,348 $ 197,439 $ 9,529,924 $ 3,489,606 $ 112 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Zubric Zubric Woodburn LOIT Dupont Stonebridge Road Road Coverdale US 24 Special Corner Business Park TIF II TIF TIF TIF Distribution TIF Project 26,285 $ 37,421 $ 68,326 $ 74,295 $ 3,447,742 $ 26,899 $ 24,224 $ - - - 7,067 332,218 1,525 1,774 - - - - 4,314 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 26,285 $ 37,421 $ 68,326 $ 81,362 $ 3,784,274 $ 28,424 $ 25,998 $ - $ - $ - $ - $ 399,834 $ - $ - $ - - - - - - - - - - - - - - - - - - 399,834 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ - $ 26,285 37,421 68,326 81,362 3,384,440 28,424 25,998 - - - - - - - - - - - - - - - - - - - - - 26,285 37,421 68,326 81,362 3,384,440 28,424 25,998 26,285 $ 37,421 $ 68,326 $ 81,362 $ 3,784,274 $ 28,424 $ 25,998 $ 113 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Special assessments Intergovernmental Interfund receivables: Interfund loans Assets held for resale Total assets Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable Accrued payroll and withholdings payable Interfund payables: Interfund loans Total liabilities Deferred inflows of resources: Unavailable revenue - property taxes Unavailable revenue - license excise taxes Unavailable revenue - income taxes Total deferred inflows of resources Fund balances: Nonspendable fund balance Restricted fund balance Committed fund balance Assigned fund balance Unassigned fund balance Total fund balances Total liabilities, deferred inflows of resources, and fund balances Juvenile Jail Justice Center Building Building Corporation Corporation Totals - $ - $ 69,004,065 $ 4,239 353 5,560,630 - - 63,104 - - 1,273,611 - - 528,085 - - 114,113 - - 559,516 - - 825,381 - - 966,088 4,239 $ 353 $ 78,894,593 $ - $ - $ 2,336,830 $ - - 948,984 - - 1,943,951 - - 5,229,765 - - 395,537 - - 104,146 - - 773,928 - - 1,273,611 - $ - $ 966,088 4,239 353 68,745,034 - - 3,081,122 - - 636,622 - - (1,037,649) 4,239 353 72,391,217 4,239 $ 353 $ 78,894,593 $ 114 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 Local Local Juvenile Income Tax - Income Tax - County Local Road Service of County Detention Public Safety Dist Shares Highway and Street Process Health Alternative Grant Revenues: Taxes 3,187,920 $ - $ 2,395,502 $ - $ - $ 2,335,931 $ - $ Special assessments - - - - - - - Licenses and permits - - - - - - - Intergovernmental - 511 9,234,299 2,009,936 - 326,774 68,386 Charges for services - - 574,136 - - 1,435,801 - Fines and forfeits - - - - 447,636 - - Other 384 2,635 83,068 53,671 - 117,874 - Total revenues 3,188,304 3,146 12,287,005 2,063,607 447,636 4,216,380 68,386 Expenditures: Current: General government - 8,580 - - - - - Public safety 2,898,046 - - - 491,806 - 106,413 Highways and streets - - 10,955,094 2,834,480 - - - Sanitation - - - - - - - Economic development - - - - - - - Health and welfare - - - - - 4,311,789 - Culture and recreation - - - - - - - Debt service: Principal - - - - - - - Interest - - - - - - - Capital outlay: Economic development - - - - - - - Special assessment - - - - - - - Total expenditures 2,898,046 8,580 10,955,094 2,834,480 491,806 4,311,789 106,413 Excess (deficiency) of revenues over (under) expenditures 290,258 (5,434) 1,331,911 (770,873) (44,170) (95,409) (38,027) Other financing sources (uses): Transfers in - - - - - - - Transfers out - (1,169,094) - - - - - Total other financing sources and uses - (1,169,094) - - - - - Net change in fund balances 290,258 (1,174,528) 1,331,911 (770,873) (44,170) (95,409) (38,027) Fund balances - beginning 285,833 1,174,528 3,507,745 2,491,464 71,578 2,834,730 57,647 Fund balances - ending 576,091 $ - $ 4,839,656 $ 1,720,591 $ 27,408 $ 2,739,321 $ 19,620 $ 115 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Supplemental Supplemental County Recorders Juvenile Adult Probation Accident Surveyor's Corner Firearms County Records Probation Services Services Report Perpetuation Training Extradition Perpetuation - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - 26,195 - - - - - - 139,726 527,320 34,597 202,550 42,135 8,823 769,022 - - - - - - - 5,958 336 1,337 - 312 1,354 4,859 171,879 527,656 35,934 202,550 42,447 10,177 773,881 - - - 85,649 - - 616,679 191,766 533,476 56,053 - 37,159 16,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 191,766 533,476 56,053 85,649 37,159 16,000 616,679 (19,887) (5,820) (20,119) 116,901 5,288 (5,823) 157,202 - - - - - - - - - - - - - - - - - - - - - (19,887) (5,820) (20,119) 116,901 5,288 (5,823) 157,202 143,917 29 39,387 607,751 13,500 30,664 416,763 124,030 $ (5,791) $ 19,268 $ 724,652 $ 18,788 $ 24,841 $ 573,965 $ 116 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending County Law Enforcement Drainage Jail Local Health County Continuing County Community Maintenance Commissary Maintenance User Fee Education Corrections Corrections - $ - $ - $ - $ - $ - $ - $ 622,577 - - - - - - - - 35,440 - - - - - - - - 10,384 218,074 3,833,825 - 1,726,773 28,997 - 1,042 - - - - - 46,612 - - - 30,024 - 1,972 - 203 106 - 652,601 1,726,773 66,409 46,612 11,629 218,180 3,833,825 538,580 - - 41,360 - - - - 1,702,332 - - 10,418 215,880 3,931,593 - - - - - - - - - - - - - - - - - - - - - - - 288,568 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 538,580 1,702,332 288,568 41,360 10,418 215,880 3,931,593 114,021 24,441 (222,159) 5,252 1,211 2,300 (97,768) - - - - - - - - (337,000) - - - - - - (337,000) - - - - - 114,021 (312,559) (222,159) 5,252 1,211 2,300 (97,768) 6,080,977 814,416 326,481 62,303 2,038 12,817 525,421 6,194,998 $ 501,857 $ 104,322 $ 67,555 $ 3,249 $ 15,117 $ 427,653 $ 117 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Community Alcohol Abuse Park and Corrections - Redevelopment Hazardous Deterrent Recreation Economic Home Detention Commission Waste Program Narcotics Nonreverting Development - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - 5,601 - - - - - - 1,885,565 - - 150,469 - 162,409 - - - - - - - - 68,274 2,051 30,607 - 38,062 6,917 3,474 1,959,440 2,051 30,607 150,469 38,062 169,326 3,474 - - - - - - - 1,712,701 - 24,619 150,470 16,670 - - - - - - - - - - - - - - - - - 20,669 - - - - - - - - - - - - - - - - - 131,489 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 1,712,701 20,669 24,619 150,470 16,670 131,489 - 246,739 (18,618) 5,988 21,392 37,837 3,474 - 50,000 - - - - 119,363 - - - - - - (106,454) - 50,000 - - - - 12,909 246,739 31,382 5,988 21,392 37,837 16,383 660,478 (518) 2,934,956 6,131 42,170 626,970 293,404 907,217 $ 30,864 $ 2,940,944 $ 6,130 $ 63,562 $ 664,807 $ 309,787 $ 118 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Emergency Vehicle County Supplemental ICJI Planning and Title Record Drug Free Public Defender Community Right to Know Inspection Check Plat Book Community Services Supervision - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - 17,423 - - - - 42,831 - - 3,585 44,786 87,592 - 678 - - - - - 177,605 66,157 - 97 3 6 - - 62 - 17,520 3,588 44,792 87,592 177,605 109,728 - - - - 9,689 - - - 7,939 2,379 39,829 - 140,915 94,678 11,926 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 7,939 2,379 39,829 9,689 140,915 94,678 11,926 9,581 1,209 4,963 77,903 36,690 15,050 (11,926) - - - - - - - - - - - - - - - - - - - - - 9,581 1,209 4,963 77,903 36,690 15,050 (11,926) 238,490 6,622 108,581 375,034 165,024 165,162 16,173 248,071 $ 7,831 $ 113,544 $ 452,937 $ 201,714 $ 180,212 $ 4,247 $ 119 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Court Allen Public Drug Appointed County Law Prosecutor Tax Information Task Force Special Advocate Statewide 911 Enforcement PCA Sale Fee - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - - 167,384 2,897,408 - - - 264,423 - - - 34,868 - 209,528 - - - - - - - 16,305 - - 12,226 - 318 - 280,728 - 167,384 2,909,634 34,868 318 209,528 333,401 - 164,880 - - - 161,996 - 5,338 - 3,500,348 23,243 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 333,401 5,338 164,880 3,500,348 23,243 - 161,996 (52,673) (5,338) 2,504 (590,714) 11,625 318 47,532 - - - - - - - - - - - - - - - - - - - - - (52,673) (5,338) 2,504 (590,714) 11,625 318 47,532 578,652 32,948 250,096 1,716,740 18,576 30,712 277,185 525,979 $ 27,610 $ 252,600 $ 1,126,026 $ 30,201 $ 31,030 $ 324,717 $ 120 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Park and Indiana Law Department Recreation Enforcement of Planning Medical Care Chemical Infraction Gift Assist Grant Services for Inmates Testing Jury Fee Deferral Fee - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - 18,453 80,074 - - - - 446,436 - - 99,369 32,804 18,112 - - - - - - - 36,425 582,345 1,735 68 52 195 - 284 24,783 20,188 80,142 99,421 32,999 18,112 36,709 1,053,564 - - 10,886 - - 37,135 - - 69,833 - 46,259 25,952 - 985,875 - - - - - - - - - - - - - - - - - - - - - - - - - - - - 21,758 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 21,758 69,833 10,886 46,259 25,952 37,135 985,875 (1,570) 10,309 88,535 (13,260) (7,840) (426) 67,689 - - - - - - - - - - - - - - - - - - - - - (1,570) 10,309 88,535 (13,260) (7,840) (426) 67,689 191,424 4,804 245,623 16,985 80,899 3,505 287,244 189,854 $ 15,113 $ 334,158 $ 3,725 $ 73,059 $ 3,079 $ 354,933 $ 121 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Circuit Superior Campaign Court Pre-Trial Court Allen County Algor Mortis Finance Surveyor's ADR Plan Diversion ADR Plan Morgue Study Enforcement Petition - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - 170,605 - - - - - - - - - - - - 21,160 230,223 8,490 - - - - - 3,500 - - - 2,010 250 21,160 404,328 8,490 - - 2,010 250 9,674 - 15,695 - - - 52 - 495,165 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 9,674 495,165 15,695 - - - 52 11,486 (90,837) (7,205) - - 2,010 198 - - - - - - - - - - - - - - - - - - - - - 11,486 (90,837) (7,205) - - 2,010 198 34,748 286,893 12,937 463 186 7,503 6,528 46,234 $ 196,056 $ 5,732 $ 463 $ 186 $ 9,513 $ 6,726 $ 122 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Community Juvenile Mobile Federal Transitions Stormwater Internet Prisoner Public Defender Command Asset Seizure Program Study Access Reimbursement User Fees Unit - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - 62,390 268,031 - - - 9,448 - - - - 20,544 - - - - - - 7 900 9,653 - 15,193 - 632 - 93 326 121 77,583 268,031 632 20,551 993 19,427 121 - - 1,974 18,360 - - - 549,106 266,206 - - - 23,487 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 549,106 266,206 1,974 18,360 - 23,487 - (471,523) 1,825 (1,342) 2,191 993 (4,060) 121 - - - - - - - - - - - - - - - - - - - - - (471,523) 1,825 (1,342) 2,191 993 (4,060) 121 1,421,575 31,510 64,405 146,862 8,978 35,827 12,113 950,052 $ 33,335 $ 63,063 $ 149,053 $ 9,971 $ 31,767 $ 12,234 $ 123 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Clerk Alcohol Allen County Prosecutor's Record and Drug Sales Levy Children's Federal Sheriff Perpetuation User Fees Disclosure Excess Home Gift Asset Seizure Donation - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - 86,485 - - - 12,044 - - 301,955 53,370 - - - - 298,482 556,241 - - - - - 35 146 1,408 - 3,077 205 6,280 298,517 944,827 54,778 - 3,077 12,249 6,280 21,596 - 16,880 - - - - - 937,132 - - - 8,317 21,617 - - - - - - - - - - - - - - - - - - - - - - - - - 4,943 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 21,596 937,132 16,880 - 4,943 8,317 21,617 276,921 7,695 37,898 - (1,866) 3,932 (15,337) - - - - - - - - - - - - - - - - - - - - - 276,921 7,695 37,898 - (1,866) 3,932 (15,337) 384,830 178,486 104,247 111 48,531 13,631 55,787 661,751 $ 186,181 $ 142,145 $ 111 $ 46,665 $ 17,563 $ 40,450 $ 124 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Court Tangible Youth Juvenile Center Check Adult Improvement Incentive Services Per Per Diem Deception Protective Unsafe Project Program Diem Fees Fees Program Services Building Allen-CIP-FY-03/04 - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - - - - 368,397 - 15,820 - 531,044 95,603 2,330 - - - - - - - - - - 5,000 2,424 1,965 2,388 - 115,105 1,200 5,000 533,468 97,568 4,718 368,397 115,105 17,020 - - - - - - 24,119 2,976 - 74,176 1,015 368,397 132,497 - - - - - - - - - - - - - - - - - - - - - - - 609,776 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 2,976 609,776 74,176 1,015 368,397 132,497 24,119 2,024 (76,308) 23,392 3,703 - (17,392) (7,099) - - - - - - - - - - - - - - - - - - - - - 2,024 (76,308) 23,392 3,703 - (17,392) (7,099) - 190,143 166,259 (1,297) - 54,128 25,953 2,024 $ 113,835 $ 189,651 $ 2,406 $ - $ 36,736 $ 18,854 $ 125 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Substance Abuse TB Tobacco St. Joseph Prevention and Great KIDS Emergency Master Plan Foundation HIV/AIDS Treatment Supplemental Make Great Program Program Lead Program Program Program Education COMMUNITIES - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - 1,816 123,989 - 31,800 44,974 - 175,000 - - - - - - - - - - - - - - - - - - - 49 63,679 1,816 123,989 - 31,800 44,974 49 238,679 - - - - - - - - - - - - 326 - - - - - - - - - - - - - - - - - - - - - - 1,817 130,061 - 31,800 44,976 - 190,792 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 1,817 130,061 - 31,800 44,976 326 190,792 (6,072) - - (277) 47,887 - - - - - - - - - - - - - - - - - - - - - (6,072) - - (277) 47,887 1 18,414 7,759 - 5 1,320 182,512 - $ 12,342 $ 7,759 $ - $ 3 $ 1,043 $ 230,399 $ 126 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Allen County Allen County Courts Foreign Onsite Sheriff Electronic Map Language Wastewater Traffic Jury Fee Truancy Department Generation Interpreter Management Enforcement Circuit Court Reduction Training - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - 71,002 - 21,916 - - - 234 - - - - - 680 - - - - 340 - - 385 - 17 - - - 14 619 71,002 17 21,916 340 - 694 3,132 95,025 - - - - - - - - 29,495 - - 888 - - - - - - - - - - - - - - - - - - - - - - - 10,518 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 3,132 95,025 10,518 29,495 - - 888 (2,513) (24,023) (10,501) (7,579) 340 - (194) - - 10,000 - - - - - - - - - - - - - 10,000 - - - - (2,513) (24,023) (501) (7,579) 340 - (194) 40,038 22,363 5,654 7,579 1,572 1,601 1,082 37,525 $ (1,660) $ 5,153 $ - $ 1,912 $ 1,601 $ 888 $ 127 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending NE Sheriff Identification Legal ISDH Indiana Foundation Security Enhanced On-site Education Immunization Trails Grants Protection Access Septic System Opportunity Grant - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - 13,090 - - - 6,000 118,787 - - 50,751 - 98,100 - - - - - - - - - 6,394 - - - 1,661 7 - 6,394 13,090 50,751 - 99,761 6,007 118,787 2,171 - 35,000 - - 6,000 - - 28,975 - - - - - - - - - - - - - - - - 110,791 - - - - - - - - - - - - - - - 118,787 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 2,171 28,975 35,000 - 110,791 6,000 118,787 4,223 (15,885) 15,751 - (11,030) 7 - - - - - - - - - - - - (10,000) - - - - - - (10,000) - - 4,223 (15,885) 15,751 - (21,030) 7 - 3,733 15,885 38,096 31 174,595 557 - 7,956 $ - $ 53,847 $ 31 $ 153,565 $ 564 $ - $ 128 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending State Allen County State Allen County Volunteer Homeland Smoking Sex/Violent Criminal Alien Problem Courts Family Advocates For Security Ordinance Offender Assistance Solving Court Grant Seniors Program Coordination Admin Program Court - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - 24,200 65,000 10,000 - - 3,300 28,500 - - - - 23,040 - - - - - - - - - - 175 - - 613 - 156 24,200 65,175 10,000 - 23,653 3,300 28,656 15,127 47,515 - - - - - - - 10,000 - 11,502 8,147 39,335 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 15,127 47,515 10,000 - 11,502 8,147 39,335 9,073 17,660 - - 12,151 (4,847) (10,679) - - - - - - - - - - - - - - - - - - - - - 9,073 17,660 - - 12,151 (4,847) (10,679) 21,787 1,203 - 89 49,796 17,760 17,030 30,860 $ 18,863 $ - $ 89 $ 61,947 $ 12,913 $ 6,351 $ 129 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Allen County Auditor's Sheriff IJC 2016 LIT Refugee Courtools Ineligible Training Veterans Special Interpreter/ Court Reform GIS Deductions Center Court Dist 25% Translator Grant Infrastructure - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - 175,667 - - - 40,000 19,996 145,000 71,175 1,100 - - - - - - - - - - - - 5,164 193 74 14,347 - - 2,766 252,006 1,293 74 14,347 40,000 19,996 147,766 688,167 - - - - 33,708 378,298 - 22,219 16,753 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 35,365 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 688,167 22,219 16,753 - 35,365 33,708 378,298 (436,161) (20,926) (16,679) 14,347 4,635 (13,712) (230,532) - - - - - - 145,000 (711,627) - - - - - - (711,627) - - - - - 145,000 (1,147,788) (20,926) (16,679) 14,347 4,635 (13,712) (85,532) 1,477,212 21,300 16,844 1,370,378 18,085 29,221 295,235 329,424 $ 374 $ 165 $ 1,384,725 $ 22,720 $ 15,509 $ 209,703 $ 130 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Health ACCC Dept. Commerical Adult ISDH Radon and Influenza Fines Court Law Probation Syringe Healthy Elected Vaccination Collections Clerk Grant Service Prog Homes Official Training - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - - 56,525 331,300 17,461 3,000 - - - - - - - 50,665 - 6,888 - - - - - - - 493 - - - 2,214 - 6,888 57,018 331,300 17,461 3,000 52,879 - - 63,991 - - - 4,867 - - - 303,511 - - - - - - - - - - - - - - - - - - - - - - - - - - - - 17,461 3,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 63,991 303,511 17,461 3,000 4,867 - 6,888 (6,973) 27,789 - - 48,012 - - - - - - - - - - - - - - - - - - - - - - 6,888 (6,973) 27,789 - - 48,012 479 17,410 61,207 179,589 - - 179,007 479 $ 24,298 $ 54,234 $ 207,378 $ - $ - $ 227,019 $ 131 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending ARRA County Prosc IV-D Prosc IV-D Clerk IV-D County Offender Clerk IV-D IV-D Incentive Incentive Incentive Reassessment Transportation Incentive Incentive Prior to 10/99 Post 10/99 Post 10/99 2015 - $ - $ - $ - $ - $ - $ 500,230 $ - - - - - - - - - - - - - - - - 187,126 - 281,534 187,126 45,150 3,663 - - - - - - - - - - - - - - - 638 926 1,347 6,252 8,083 3,663 - 187,764 926 282,881 193,378 553,463 - - - - - - 445,670 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 100,883 - 317,410 133,672 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 100,883 - 317,410 133,672 445,670 3,663 - 86,881 926 (34,529) 59,706 107,793 - - - - - - - - - - - - - - - - - - - 3,663 - 86,881 926 (34,529) 59,706 107,793 16,310 5 46,447 92,437 162,361 542,963 792,228 19,973 $ 5 $ 133,328 $ 93,363 $ 127,832 $ 602,669 $ 900,021 $ 132 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Maplecrest Cumulative Clinic County General Drain Great Batch Special COIT - Bridge Capital Donation Bond Improvement TIF Flood Control Bond Development - $ 3,855,596 $ - $ 205,535 $ - $ - $ 2,502,472 $ - - 42,866 - - - - - - - - - - - 317,209 - - - - 226,908 - - 385,498 - 13,044 - 909,269 - - - - - - - 25 20,930 75,720 310 2,042 - 85,991 25 4,193,735 504,084 205,845 15,086 - 3,724,640 - 1,279 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 3,156 - - - - - - - 3,327,587 - - 452,427 - - - - - 1,279 452,427 - - 3,156 3,327,587 25 4,192,456 51,657 205,845 15,086 (3,156) 397,053 - - - - - - - - (4,304,561) - (19,363) - - - - (4,304,561) - (19,363) - - - 25 (112,105) 51,657 186,482 15,086 (3,156) 397,053 11,105 2,333,447 1,341,108 (72,911) 199,327 3,156 7,737,959 11,130 $ 2,221,342 $ 1,392,765 $ 113,571 $ 214,413 $ - $ 8,135,012 $ 133 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Pleasant Community CASAD Nestle TIF Center Road Development Mossman East TIF Major Bridge II Bond Construction Argo Drain Corporation Drain 286,938 $ 1,646,723 $ 293,679 $ - $ - $ - $ - $ - - - - - - - - - - - - - - - 216,489 - - - - - - - - - - - - - - - - - - - 5,357 - 3,925 1,826 1,507 218,163 194 292,295 1,863,212 297,604 1,826 1,507 218,163 194 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 1,115,000 - - - - - - 637,653 - - - - - 427,567 717,660 - 170,436 - 348,936 - - - - - - - - 427,567 2,470,313 - 170,436 - 348,936 - (135,272) (607,101) 297,604 (168,610) 1,507 (130,773) 194 300,000 - - - - - - (63,317) - (280,000) - - - - 236,683 - (280,000) - - - - 101,411 (607,101) 17,604 (168,610) 1,507 (130,773) 194 461,772 4,211,803 451,751 229,448 150,403 552,965 19,366 563,183 $ 3,604,702 $ 469,355 $ 60,838 $ 151,910 $ 422,192 $ 19,560 $ 134 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Parking Tax Woodburn Lincoln Uniroyal Garage Abatement Industrial Industrial Goodrich GM 2015 GM 2015B Bond of 2001 Development TIF TIF TIF General Account Bond - $ - $ 36,491 $ 139,098 $ 257,033 $ 1,103,507 $ - $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 55,405 10 2,684 134 703 1,750 - 55,405 36,501 141,782 257,167 1,104,210 1,750 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 300,000 - - - - - - 23,661 - - 14,931 130,000 202,596 - - - - - - - - - - - 14,931 130,000 202,596 - 323,661 - 55,405 21,570 11,782 54,571 1,104,210 (321,911) - 16,279 - - - - 339,900 - - - - - (949,000) - - 16,279 - - - (949,000) 339,900 - 71,684 21,570 11,782 54,571 155,210 17,989 17 704,178 647 298,791 73,989 406,759 148,951 17 $ 775,862 $ 22,217 $ 310,573 $ 128,560 $ 561,969 $ 166,940 $ 135 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Nestle II Bond GM GM 2015A GM 2015A Nestle II Principal and GM 2015B Supplemental Bond Reserve Account Reserve Account Interest Account Reserve Account TIF - $ - $ - $ - $ - $ 64,867 $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 3,030 1,551 - 435 2,344 400 3,030 1,551 - 435 2,344 65,267 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 815,000 - - - - - 65,788 - - 79,468 - - - - - 500 - - - - - - - - 880,788 - - 79,968 - - (877,758) 1,551 - (79,533) 2,344 65,267 909,100 - - 80,000 - - - - - - - (100,000) 909,100 - - 80,000 - (100,000) 31,342 1,551 - 467 2,344 (34,733) 75,201 154,839 89 40,281 233,987 67,901 106,543 $ 156,390 $ 89 $ 40,748 $ 236,331 $ 33,168 $ 136 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Bluffton Allen County Vera Bradley Little River Bandalier Road East Oak Crossing Redevelopment Sur/Wheel TIF Joint Drain TIF TIF TIF Capital Tax Bridge 191,566 $ - $ 271,889 $ 266,496 $ 385,814 $ - $ - $ - 113,477 - - - - - - - - - - - - - 310 - 50,000 - - 1,573,776 - - - - - - - - - - - - - - 120 6,540 218 988 263 265,292 32,908 191,686 120,327 272,107 317,484 386,077 265,292 1,606,684 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 100,000 - 22,174 490,523 - 1,300 - - - - - - 1,300 - 100,000 - 22,174 490,523 191,686 119,027 272,107 217,484 386,077 243,118 1,116,161 - - - - - 2,553,975 - (148,966) - (16,279) - - - - (148,966) - (16,279) - - 2,553,975 - 42,720 119,027 255,828 217,484 386,077 2,797,093 1,116,161 (260,958) 443,748 (108,191) (1,029,444) (381,901) 6,732,831 2,373,445 (218,238) $ 562,775 $ 147,637 $ (811,960) $ 4,176 $ 9,529,924 $ 3,489,606 $ 137 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Zubric Zubric Woodburn LOIT Dupont Stonebridge Road Road Coverdale US 24 Special Corner Business Park TIF II TIF TIF TIF Distribution TIF Project 43,028 $ 49,418 $ 136,696 $ 44,934 $ - $ 26,429 $ 7,289 $ - - - - - - - - - - - - - - - - - - 973,728 - - - - - - - - - - - - - - - - 183 247 - 562 47,802 70 4,093 43,211 49,665 136,696 45,496 1,021,530 26,499 11,382 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 137,805 105 1,748,225 - 480,000 - - - - - - - - - 137,805 105 1,748,225 - 480,000 43,211 49,665 (1,109) 45,391 (726,695) 26,499 (468,618) - - - - - - - (45,000) (50,000) - - - - (553,975) (45,000) (50,000) - - - - (553,975) (1,789) (335) (1,109) 45,391 (726,695) 26,499 (1,022,593) 28,074 37,756 69,435 35,971 4,111,135 1,925 1,048,591 26,285 $ 37,421 $ 68,326 $ 81,362 $ 3,384,440 $ 28,424 $ 25,998 $ 138 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2017 (Continued) Revenues: Taxes Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Other Total revenues Expenditures: Current: General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation Debt service: Principal Interest Capital outlay: Economic development Special assessment Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources and uses Net change in fund balances Fund balances - beginning Fund balances - ending Juvenile Jail Justice Center Building Building Corporation Corporation Totals - $ - $ 20,235,081 $ - - 778,920 - - 35,440 - - 25,984,893 - - 11,097,175 - - 2,489,164 336 514 1,631,189 336 514 62,251,862 - - 3,937,135 - - 20,401,158 - - 13,789,574 - - 110,791 - - 20,669 - - 6,351,618 - - 153,247 1,645,000 2,385,000 6,260,000 191,225 83,497 1,084,448 - - 8,319,045 - - 453,727 1,836,225 2,468,497 60,881,412 (1,835,889) (2,467,983) 1,370,450 1,836,225 2,468,336 8,828,178 - - (8,864,636) 1,836,225 2,468,336 (36,458) 336 353 1,333,992 3,903 - 71,057,225 4,239 $ 353 $ 72,391,217 $ 139 ---PAGE BREAK--- County Workmans Self-Insurance Vehicle Liability Compensation Internal Assets Health Self-Insurance Insurance Self-Insurance Reimbursement Totals Current assets: Cash and cash equivalents 8,832,994 $ 712,967 $ 77,681 $ 287,905 $ 148,488 $ 10,060,035 $ Investments 176,332 69,196 - 24,285 22,036 291,849 Interest receivable 2,290 899 - 315 286 3,790 Accounts receivable (net of allowance) - 12,810 - - 144,620 157,430 Total assets 9,011,616 795,872 77,681 312,505 315,430 10,513,104 Liabilities Current liabilities: Accounts payable 233,418 20,251 30,844 15,978 40,637 341,128 Incurred but not reported claims 1,344,358 - - - - 1,344,358 Total liabilities 1,577,776 20,251 30,844 15,978 40,637 1,685,486 Net Position Unrestricted 7,433,840 775,621 46,837 296,527 274,793 8,827,618 Total net position 7,433,840 $ 775,621 $ 46,837 $ 296,527 $ 274,793 $ 8,827,618 $ ALLEN COUNTY COMBINING STATEMENT OF NET POSITION - INTERNAL SERVICE FUNDS December 31, 2017 140 ---PAGE BREAK--- County Workmans Self-Insurance Vehicle Liability Compensation Internal Health Self-Insurance Insurance Self-Insurance Reimbursement Totals Operating revenues: Miscellaneous 138 $ - $ 15,435 $ 3,900 $ 81,496 $ 100,969 $ Employee/employer contributions 11,575,234 410,782 400,000 1,008,260 824,860 14,219,136 Total operating revenues 11,575,372 410,782 415,435 1,012,160 906,356 14,320,105 Operating expenses: Insurance claims and expenses 10,477,084 178,730 385,870 1,062,033 1,077,683 13,181,400 Operating income (loss) 1,098,288 232,052 29,565 (49,873) (171,327) 1,138,705 Nonoperating revenues: Interest and investment revenue 24,645 7,018 - 2,542 4,206 38,411 Change in net position 1,122,933 239,070 29,565 (47,331) (167,121) 1,177,116 Total net position - beginning 6,310,907 536,551 17,272 343,858 441,914 7,650,502 Total net position - ending 7,433,840 $ 775,621 $ 46,837 $ 296,527 $ 274,793 $ 8,827,618 $ ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN NET POSITION - INTERNAL SERVICE FUNDS For The Year Ended December 31, 2017 141 ---PAGE BREAK--- County Workmans Self-Insurance Vehicle Liability Compensation Internal Health Self-Insurance Insurance Self-Insurance Reimbursement Totals Cash flows from operating activities: Receipts from customers and users 11,575,234 $ 405,166 $ 400,000 $ 1,008,260 $ 824,860 $ 14,213,520 $ Payments to suppliers (10,258,835) (166,372) (388,688) (1,049,005) (1,114,247) (12,977,147) Other receipts 138 - 15,435 3,900 2,010 21,483 Net cash provided (used) by operating activities 1,316,537 238,794 26,747 (36,845) (287,377) 1,257,856 Cash flows from investing activities: Proceeds from sales and maturities of investments 275,050 73,709 - 34,156 45,923 428,838 Purchase of investments (176,332) (69,196) - (24,285) (22,036) (291,849) Interest received 24,029 6,524 - 2,414 4,172 37,139 Net cash provided (used) by investing activities 122,747 11,037 - 12,285 28,059 174,128 Net increase (decrease) in cash and cash equivalents 1,439,284 249,831 26,747 (24,560) (259,318) 1,431,984 Cash and cash equivalents, January 1 7,393,710 463,136 50,934 312,465 407,806 8,628,051 Cash and cash equivalents, December 31 8,832,994 $ 712,967 $ 77,681 $ 287,905 $ 148,488 $ 10,060,035 $ Reconciliation of operating income (loss) to net cash provided (used) by operating activities: Operating income (loss) 1,098,288 $ 232,052 $ 29,565 $ (49,873) $ (171,327) $ 1,138,705 $ Adjustments to reconcile operating income (loss) to net cash provided (used) by operating activities: (Increase) in assets: Accounts receivable - (5,616) - - (79,486) (85,102) Increase (decrease) in liabilities: Accounts payable (102,385) 12,358 (2,818) 13,028 (36,564) (116,381) Incurred but not reported claims 320,634 - - - - 320,634 Total adjustments 218,249 6,742 (2,818) 13,028 (116,050) 119,151 Net cash provided (used) by operating activities 1,316,537 $ 238,794 $ 26,747 $ (36,845) $ (287,377) $ 1,257,856 $ ALLEN COUNTY COMBINING STATEMENT OF CASH FLOWS - INTERNAL SERVICE FUNDS For The Year Ended December 31, 2017 142 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF FIDUCIARY NET POSITION- AGENCY FUNDS December 31, 2017 Tax Sale Tax Sale Assets Redemption Surplus Court Fees Inheritance Tax Cash and cash equivalents 55 $ 3,333,242 $ 57,928 $ 368 $ Receivables: Accounts - - 47,571 - Taxes - - - - Intergovernmental - - - - Total receivables - - 47,571 - Investments at fair value: U.S. Government securities - - - - Total assets 55 $ 3,333,242 $ 105,499 $ 368 $ Liabilities Payroll withholdings payable - $ - $ - $ - $ Intergovernmental payable - - 105,499 368 Trust payable 55 3,333,242 - - Total liabilities 55 $ 3,333,242 $ 105,499 $ 368 $ 143 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF FIDUCIARY NET POSITION- AGENCY FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Receivables: Accounts Taxes Intergovernmental Total receivables Investments at fair value: U.S. Government securities Total assets Liabilities Payroll withholdings payable Intergovernmental payable Trust payable Total liabilities Youth Sheriff's County Work Bid Bond Surplus Tax Tax Distribution Payroll Services Trust Inmate Trust Recorder Release 5,050 $ 1,585,559 $ - $ (3,140) $ 84,051 $ 204,538 $ 54,935 $ 22,193 $ - - - 49,846 - - - - - - 31,410,300 - - - - - - - 3,402,986 - - - - - - - 34,813,286 49,846 - - - - - - - - 8,553 - - - 5,050 $ 1,585,559 $ 34,813,286 $ 46,706 $ 92,604 $ 204,538 $ 54,935 $ 22,193 $ - $ - $ - $ 46,706 $ - $ - $ - $ - $ - - - - - - - - 5,050 1,585,559 34,813,286 - 92,604 204,538 54,935 22,193 5,050 $ 1,585,559 $ 34,813,286 $ 46,706 $ 92,604 $ 204,538 $ 54,935 $ 22,193 $ 144 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF FIDUCIARY NET POSITION- AGENCY FUNDS December 31, 2017 (Continued) Assets Cash and cash equivalents Receivables: Accounts Taxes Intergovernmental Total receivables Investments at fair value: U.S. Government securities Total assets Liabilities Payroll withholdings payable Intergovernmental payable Trust payable Total liabilities Personal County Adult Property Juvenile County Clerk Probation Asst Audit Probation Treasurer Totals 2,957,899 $ 57,499 $ 198,767 $ 4,427 $ 9,331,874 $ 17,895,245 $ - - - - - 97,417 - - - - 11,994,039 43,404,339 - - - - - 3,402,986 - - - - 11,994,039 46,904,742 - - - - - 8,553 2,957,899 $ 57,499 $ 198,767 $ 4,427 $ 21,325,913 $ 64,808,540 $ - $ - $ - $ - $ - $ 46,706 $ - - - - - 105,867 2,957,899 57,499 198,767 4,427 21,325,913 64,655,967 2,957,899 $ 57,499 $ 198,767 $ 4,427 $ 21,325,913 $ 64,808,540 $ 145 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES- AGENCY FUNDS December 31, 2017 Tax Sale Tax Sale Inheritance Tax Redemption Surplus Court Fees Tax Bid Bond Surplus Tax Distribution Assets: Cash and Cash Equivalents, January 1 86,476 $ 3,040,379 $ 54,469 $ 368 $ 3,050 $ 1,490,519 $ - $ Additions 3,141,042 3,584,663 792,049 - 2,000 1,610,090 353,966,907 Deductions (3,227,463) (3,291,800) (788,590) - - (1,515,050) (353,966,907) Cash and Cash Equivalents, December 31 55 3,333,242 57,928 368 5,050 1,585,559 - Investments, January 1 - - - - - - - Additions - - - - - - - Deductions - - - - - - - Investments, December 31 - - - - - - - Taxes Receivable, January 1 - - - - - - 21,205,243 Additions - - - - - - 165,808,249 Deductions - - - - - - (155,603,192) Taxes Receivable, December 31 - - - - - - 31,410,300 Accounts Receivable, January 1 - - 53,701 - - - - Additions - - 839,620 - - - - Deductions - - (845,750) - - - - Accounts Receivable, December 31 - - 47,571 - - - - Intergovernmental Receivable, January 1 - - - - - - 2,878,710 Additions - - - - - - 3,406,736 Deductions - - - - - - (2,882,460) Intergovernmental Receivable, December 31 - - - - - - 3,402,986 Total Assets, December 31 55 $ 3,333,242 $ 105,499 $ 368 $ 5,050 $ 1,585,559 $ 34,813,286 $ Liabilities: Payroll Withholdings, January 1 - $ - $ - $ - $ - $ - $ - $ Additions - - - - - - - Deductions - - - - - - - Payroll Withholdings, December 31 - - - - - - - Intergovernmental Payable, January 1 - - 108,170 368 - - - Additions - - 839,620 - - - - Deductions - - (842,291) - - - - Intergovernmental Payable, December 31 - - 105,499 368 - - - Trust Payable, January 1 86,476 3,040,379 - - 3,050 1,490,519 24,083,953 Additions 3,141,042 3,584,663 - - 2,000 1,610,090 169,214,985 Deductions (3,227,463) (3,291,800) - - - (1,515,050) (158,485,652) Trust Payable, December 31 55 3,333,242 - - 5,050 1,585,559 34,813,286 Total Liabilities, December 31 55 $ 3,333,242 $ 105,499 $ 368 $ 5,050 $ 1,585,559 $ 34,813,286 $ 146 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES- AGENCY FUNDS December 31, 2017 (Continued) Assets: Cash and Cash Equivalents, January 1 Additions Deductions Cash and Cash Equivalents, December 31 Investments, January 1 Additions Deductions Investments, December 31 Taxes Receivable, January 1 Additions Deductions Taxes Receivable, December 31 Accounts Receivable, January 1 Additions Deductions Accounts Receivable, December 31 Intergovernmental Receivable, January 1 Additions Deductions Intergovernmental Receivable, December 31 Total Assets, December 31 Liabilities: Payroll Withholdings, January 1 Additions Deductions Payroll Withholdings, December 31 Intergovernmental Payable, January 1 Additions Deductions Intergovernmental Payable, December 31 Trust Payable, January 1 Additions Deductions Trust Payable, December 31 Total Liabilities, December 31 Youth Personal Services Sheriff's County Work County Adult Property Payroll Trust Inmate Trust Recorder Release Clerk Probation Asst Audit 256,186 $ 84,134 $ 117,216 $ 36,778 $ 21,093 $ 3,372,853 $ 47,163 $ 28,438 $ 45,904,637 13,170 1,469,431 1,479,825 22,193 38,174,198 387,279 375,639 (46,163,963) (13,253) (1,382,109) (1,461,668) (21,093) (38,589,152) (376,943) (205,310) (3,140) 84,051 204,538 54,935 22,193 2,957,899 57,499 198,767 - 12,205 - - - - - - - 8,553 - - - - - - - (12,205) - - - - - - - 8,553 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 41,024 - - - - - - - 49,846 - - - - - - - (41,024) - - - - - - - 49,846 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 46,706 $ 92,604 $ 204,538 $ 54,935 $ 22,193 $ 2,957,899 $ 57,499 $ 198,767 $ 297,210 $ - $ - $ - $ - $ - $ - $ - $ 45,954,483 - - - - - - - (46,204,987) - - - - - - - 46,706 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 96,339 117,216 36,778 21,093 3,372,853 47,163 28,438 - 21,723 1,469,431 1,479,825 22,193 38,174,198 387,279 375,639 - (25,458) (1,382,109) (1,461,668) (21,093) (38,589,152) (376,943) (205,310) - 92,604 204,538 54,935 22,193 2,957,899 57,499 198,767 46,706 $ 92,604 $ 204,538 $ 54,935 $ 22,193 $ 2,957,899 $ 57,499 $ 198,767 $ 147 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES- AGENCY FUNDS December 31, 2017 (Continued) Assets: Cash and Cash Equivalents, January 1 Additions Deductions Cash and Cash Equivalents, December 31 Investments, January 1 Additions Deductions Investments, December 31 Taxes Receivable, January 1 Additions Deductions Taxes Receivable, December 31 Accounts Receivable, January 1 Additions Deductions Accounts Receivable, December 31 Intergovernmental Receivable, January 1 Additions Deductions Intergovernmental Receivable, December 31 Total Assets, December 31 Liabilities: Payroll Withholdings, January 1 Additions Deductions Payroll Withholdings, December 31 Intergovernmental Payable, January 1 Additions Deductions Intergovernmental Payable, December 31 Trust Payable, January 1 Additions Deductions Trust Payable, December 31 Total Liabilities, December 31 Juvenile County Probation Treasurer Totals 2,044 $ 6,568,952 $ 15,210,118 $ 214,277 439,889,529 891,026,929 (211,894) (437,126,607) (888,341,802) 4,427 9,331,874 17,895,245 - - 12,205 - - 8,553 - - (12,205) - - 8,553 - 12,073,242 33,278,485 - 386,998,596 552,806,845 - (387,077,799) (542,680,991) - 11,994,039 43,404,339 - - 94,725 - - 889,466 - - (886,774) - - 97,417 - - 2,878,710 - - 3,406,736 - - (2,882,460) - - 3,402,986 4,427 $ 21,325,913 $ 64,808,540 $ - $ - $ 297,210 $ - - 45,954,483 - - (46,204,987) - - 46,706 - - 108,538 - - 839,620 - - (842,291) - - 105,867 2,044 18,642,194 51,068,495 214,277 826,888,125 1,046,585,470 (211,894) (824,204,406) (1,032,997,998) 4,427 21,325,913 64,655,967 4,427 $ 21,325,913 $ 64,808,540 $ 148 ---PAGE BREAK--- OTHER REPORTS In addition to this report, other reports may have been issued for the County. All reports can be found on the Indiana State Board of Accounts’ website: http://www.in.gov/sboa/. 149