Document Allencounty_doc_401c5f7fb6

ALLEN COUNTY GOVERNMENT Fort Wayne, Indiana ANNUAL FINANCIAL REPORT For The Year Ended December 31, 2021 B60504 FILED 12/28/2022 ---PAGE BREAK--- TABLE OF CONTENTS Description Page Schedule of Officials 3 Independent Auditor's Report 4-8 Management's Discussion and Analysis 9-19 Basic Financial Statements and Accompanying Notes: Government-Wide Financial Statements: Statement of Net Position 21 Statement of Activities 22 Fund Financial Statements: Balance Sheet – Governmental Funds 23 Reconciliation of the Balance Sheet of Governmental Funds To the Statement of Net Position 24 Statement of Revenues, Expenditures, and Changes in Fund Balances – Governmental Funds 25 Reconciliation of the Statement of Revenues, Expenditures, and Changes in Fund Balances of Governmental Funds to the Statement of Activities 26 Statement of Net Position – Proprietary Funds 27 Statement of Revenues, Expenses, and Changes in Fund Net Position – Proprietary Funds 28 Statement of Cash Flows – Proprietary Funds 29 Statement of Fiduciary Net Position – Fiduciary Funds 30 Statement of Changes in Fiduciary Net Position – Fiduciary 31 Notes to Financial Statements 32-86 Required Supplementary Information: Schedules of Changes in the County’s Net Pension Liability and Related . 87-90 Schedules of County 91-92 Schedules of Investment 93-94 Schedule of Proportionate Share of Net Pension Liability and Related Ratios – INPRS (PERF) 95 Schedule of Employer Contributions – INPRS 96 Schedule of Changes in the County’s Net Other Post Employment Benefits 97 Budgetary Comparison Schedules – General Fund and Major Special Revenue Funds 98 Budget/GAAP Reconciliation 99 Notes to Required Supplementary Information 100 Supplementary Information: Non-Major Governmental Funds: Combining Balance Sheet – Non-Major Governmental Funds Combining Statement of Revenues, Expenditures, and Changes in Fund Balances – Non-Major Governmental Funds Non-Major Proprietary Funds: Combining Statement of Net Position – Internal Service 155 Combining Statement of Revenues, Expenses, and Changes in Net Position – Internal Service Funds 156 Combining Statement of Cash Flows – Internal Service Funds 157 1 ---PAGE BREAK--- TABLE OF CONTENTS (Continued) Non-Major Fiduciary Funds: Combining Statement of Fiduciary Net Position – Custodial Funds Combining Statement of Changes in Fiduciary Net Position – Custodial Other 164 2 ---PAGE BREAK--- SCHEDULE OF OFFICIALS Office Official Term County Auditor Nicholas D. Jordan 01-19-17 to 12-31-22 County Treasurer William F. Royce 01-01-17 to 12-31-24 Clerk of the Circuit Court Christopher M. Nancarrow 01-01-19 to 12-31-22 County Sheriff David J. Gladieux 01-01-15 to 12-31-22 County Recorder Anita A. Mather 01-01-15 to 12-31-22 Circuit Court Judge Honorable Wendy W. Davis 01-01-21 to 12-31-24 Superior Court Judge Honorable Andrea Trevino 01-01-15 to 12-31-24 President of the Board of County Commissioners Richard E. Beck 01-01-21 to 12-31-21 F. Nelson Peters 01-01-22 to 12-31-22 President of the County Council Kyle A. Kerley 01-01-21 to 12-31-22 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 Audit of the Financial Statements Qualified and Unmodified Opinions We have audited the accompanying financial statements of the governmental activities, the business-type activities, the discretely presented component unit, each major fund, and the aggregate remaining fund information of Allen County (County), as of and for the year ended December 31, 2021, and the related notes to the financial statements, which collectively comprise the County's basic financial state- ments as listed in the Table of Contents. Summary of Opinions Opinion Unit Type of Opinion Governmental Activities Unmodified Business-Type Activities Unmodified Discretely Presented Component Unit Qualified General Fund Unmodified Local Income Tax - Economic Development Fund Unmodified ARP Coronavirus Local Recovery Fund Unmodified War Memorial Coliseum Fund Unmodified Aggregate Remaining Fund Information Unmodified Qualified Opinion on the Discretely Presented Component Unit In our opinion, based on our audit and the report of other auditors, except for the effects of the matter described in the Basis for Qualified and Unmodified Opinions section of our report, the accompa- nying financial statements referred to above present fairly, in all material respects, the financial position of the Discretely Presented Component Unit of the County, as of December 31, 2021, and the changes in financial position thereof for the year then ended in accordance with accounting principles generally accepted in the United States of America. Unmodified Opinions on Governmental Activities, Business-Type Activities, General Fund, Local Income Tax - Economic Development Fund, ARP Coronavirus Local Recovery Fund, War Memorial Coliseum Fund, and Aggregate Remaining Fund Information In our opinion, based on our audit and the report of other auditors, the accompanying financial statements referred to above present fairly, in all material respects, the respective financial position of the Governmental Activities, Business-Type Activities, General Fund, Local Income Tax - Economic Development Fund, ARP Coronavirus Local Recovery Fund, War Memorial Coliseum Fund, and Aggregate Remaining Fund Information of the County, as of December 31, 2021, and the changes in financial position, and, where applicable, cash flows thereof for the year then ended in accordance with accounting principles generally accepted in the United States of America. 4 ---PAGE BREAK--- INDEPENDENT AUDITOR'S REPORT (Continued) We did not audit the financial statements of the Allen County Public Library (Library), a component unit of the County, as described in Note 1, which represents 100 percent, 100 percent, and 100 percent, respectively, of the total assets, net position, and revenues of the discretely presented component unit, as of December 31, 2021, and the respective changes in financial position, and, where applicable, cash flows thereof for the year then ended. Those statements, were audited by other auditors whose report has been furnished to us, and our opinion, insofar as it relates to the amounts included for the Library, is based solely on the report of the other auditors. Basis for Qualified and Unmodified Opinions We conducted our audit in accordance with auditing standards generally accepted in the United States of America (GAAS) and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Our responsibilities under those standards are further described in the Auditor's Responsibilities for the Audit of the Financial Statements section of our report. We are required to be independent of the County, and to meet our other ethical responsibilities, in accordance with the relevant ethical requirements relating to our audit. We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our qualified and unmodified audit opinions. Matter Giving Rise to Qualified Opinion on the Discretely Presented Component Unit The County has not included the Southwest Allen County Fire District as a discretely presented component unit in the County's financial statements, as required by accounting principles generally accepted in the United States of America. The amount by which this departure would affect the assets, deferred outflows of resources, liabilities, deferred inflows of resources, net position, revenues, and expenses of the County's aggregate discretely presented component units has not been determined. Emphasis of Matter As discussed in Note III. F, to the financial statements, the County restated the fund balance of the General Fund at December 31, 2020, to include the balance of the Rainy Day Fund and 21 other special revenue funds. The County also presented a prior period adjustment to the December 31, 2020 Net Position of Governmental Activities to reflect changes made to the infrastructure capital assets balances. Our opinion is not modified with respect to these matters. Responsibilities of Management for the Financial Statements Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presen- tation of financial statements that are free from material misstatement, whether due to fraud or error. In preparing the financial statements, management is required to evaluate whether there are con- ditions or events, considered in the aggregate, that raise substantial doubt about the County's ability to continue as a going concern for 12 months beyond the financial statement date, including any currently known information that may raise substantial doubt shortly thereafter. 5 ---PAGE BREAK--- INDEPENDENT AUDITOR'S REPORT (Continued) Auditor's Responsibilities for the Audit of the Financial Statements Our objectives are to obtain reasonable assurance about whether the financial statements as a whole are free from material misstatement, whether due to fraud or error, and to issue an auditor's report that includes our opinions. Reasonable assurance is a high level of assurance but is not absolute assur- ance and therefore is not a guarantee that an audit conducted in accordance with GAAS will always detect a material misstatement when it exists. The risk of not detecting a material misstatement resulting from fraud is higher than for one resulting from error, as fraud may involve collusion, forgery, intentional omis- sions, misrepresentations, or the override of internal control. Misstatements are considered material if there is a substantial likelihood that, individually or in the aggregate, they would influence the judgment made by a reasonable user based on the financial statements. In performing an audit in accordance with GAAS, we:  Exercise professional judgment and maintain professional skepticism throughout the audit.  Identify and assess the risks of material misstatement of the financial statements, whether due to fraud or error, and design and perform audit procedures responsive to those risks. Such procedures include examining, on a test basis, evidence regarding the amounts and disclosures in the financial statements.  Obtain an understanding of internal control relevant to the audit 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, no such opinion is expressed.  Evaluate the appropriateness of accounting policies used and the reasonableness of signi- ficant accounting estimates made by management, as well as evaluate the overall presen- tation of the financial statements.  Conclude whether, in our judgment, there are conditions or events, considered in the ag- gregate, that raise substantial doubt about the County's ability to continue as a going con- cern for a reasonable period of time. We are required to communicate with those charged with governance regarding, among other mat- ters, the planned scope and timing of the audit, significant audit findings, and certain internal control-related matters that we identified during the audit. 6 ---PAGE BREAK--- INDEPENDENT AUDITOR'S REPORT (Continued) 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 Position Liability and Related Ratios, Schedules of County Contributions, Schedules of Investment Returns, Schedule of Proportionate Share of Net Pension Liability and Related Ratios - INPRS (PERF), Schedule of Employer Contributions - INPRS (PERF), Schedules of Changes in the County's Net Other Post Employment Benefits, Budgetary Comparison Schedules - 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 is the responsibility of management and, 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. Supplementary Information Our audit was conducted for the purpose of forming opinions on the financial statements that collec- tively comprise the County's basic financial statements. The accompanying 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 - Custodial Funds, and Combining Statement of Changes in Fiduciary Net Position - Custodial Funds are presented for purposes of additional analysis and are not a required part of the basic financial statements. Such information is the responsibility of management and was derived from and relates directly to the underlying accounting and other records used to prepare the basic financial statements. The infor- mation 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 - Custodial Funds, and Combining Statement of Changes in Fiduciary Net Position - Custodial Funds are fairly stated, in all material respects, in relation to the basic financial statements as a whole. 7 ---PAGE BREAK--- INDEPENDENT AUDITOR'S REPORT (Continued) Other Reporting Required by Government Auditing Standards In accordance with Government Auditing Standards, we have also issued our report dated December 19, 2022, 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. Beth Kelley, CPA, CFE Deputy State Examiner December 19, 2022 8 ---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, 2021. 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 2021 by $586.6 million (total net position), an increase of $97.6 million, 20 percent, over the restated beginning total net position of $489.1 million. Beginning total net position was decreased $41.4 million due to a restatement to reflect corrections made in the valuation of infrastructure assets that were being double counted. Of this amount, $152.5 million (unrestricted net position) may be used to meet the County’s ongoing obligations to citizens, $23.2 million is restricted for debt service and other specific purposes (restricted net position), and $410.9 million is invested in capital assets, net of related debt. ▪ The total net position of the County’s governmental activities increased by $93.3 million or 21 percent over the restated beginning 2021 net position. This is primarily the result of a net $39 million increase in cash and investments and $34.8 million in capital assets; coupled with an $18.5 million decrease in net pension liability. The total net position of the County’s business activities increased $4.2 million or 9.3 percent. With operational activity resuming somewhat after the hiatus from COVID, assets increased $2.5 million driven mainly by restricted and unrestricted cash and receivable increases that were somewhat offset by a decrease in capital assets. The decrease in Coliseum liabilities was overwhelmingly due to the $2.9 million regularly scheduled debt service payments being only partially offset by increased unearned revenue and ticket office deposits payable. ▪ At the end of 2021, the County’s governmental funds reported a combined ending fund balance of $183.1 million, an increase of $16.2 million or 9.7 percent over 2020. This increase is attributed to a combined taxes and charges for services revenue increase of $13.7 million. In accordance with GASB 54 the total Fund Balance is broken down as $1 million Nonspendable, $80.3 million as Restricted, $31.2 million Committed, $18.5 million Assigned, and $52.1 million as Unassigned. ▪ At the end of 2021, the unassigned fund balance for the General Fund was $59.8 million or 49.7 percent of the 2021 General Fund expenditures. ▪ During 2021, the County’s total debt decreased by $4.4 million or 10.5 percent. The decrease is attributed to regularly scheduled debt service payments. 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 like 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 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 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 the 9 ---PAGE BREAK--- current year’s revenues and expenses are considered 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). 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. As example: the Allen County Jail Building Corporation was established for the sole purpose of financing the jail facility. The Building Corporation is a 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 Council if certain thresholds are met under Indiana Law. The government-wide financial statements can be found on pages 21 and 22 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, Local Income Tax Economic Development Fund (LIT Economic Development) and the ARP Coronavirus Local Recovery Fund (ARPA). For year end 2021 and forward, the Rainy Day Fund along with a handful of Special Revenue Funds previously included in Other Governmental Funds are now reported in the General Fund in accordance with GASB as the majority of the inflows are not restricted or committed revenue sources. The governmental funds financial statements can be found on pages 23 through 26 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. 10 ---PAGE BREAK--- Because these services predominantly benefit governmental rather than business-type functions, they have been included within governmental activities in the government-wide financial statements. Proprietary funds provide the same type of information as the government-wide financial statements, only in more detail. The 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 27 through 29 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 Custodial 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 30 and 31 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 32 through 86 of this report. Required Supplementary Information is presented concerning the County’s General Fund Budgetary Schedule, Schedules of Changes in the County’s Net Pension and OPEB Liabilities 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 Schedules of Changes in the County’s Net Pension and OPEB Liabilities 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 87 through 100 of this report. 11 ---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 $586.6 million at the close of 2021, further improving 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 $410.9 million or 70.1 percent. The capital assets increased $34.9 million or 9.3 percent from the restated beginning balance due to new infrastructure. 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, decreased million or 3.8 percent, is funds that are subject to an external restriction and cannot be spent on general daily operations. The unrestricted portion of the total net position increased $63.5 million or 71.4 percent. As was previously touched on in the Financial Highlights section, cash, cash equivalents and investments increased $41.1 million of which $36.9 million is attributed to the ARPA monies. Receivables were a net $2.3 million gain mainly from intergovernmental local income tax. On the liability side, the net pension liability dropped $18.5 million mainly due to favorable market conditions and return on investment. Regularly scheduled debt service payments generated a more than $4 million reduction in liabilities as well. Deferred outflows and inflows increased $2.8 million and $4.7 million respectively, both related to pensions. The County’s component units showed assets exceeding liabilities by $125.5 million at the end of 2021. Of the total net position, $59.3 million or 47.3 percent 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 $23.5 million or 18.7 percent of restricted dollars that are subject to an external restriction and $42.7 million or 34 percent of unrestricted dollars that can be used to provide daily operations for the component units. 2021 2020 2021 2020 2021 2020 2021 2020 Assets 355,163 $ 313,722 $ 16,511 $ 11,223 $ 371,674 $ 324,945 $ 103,190 $ 68,777 $ Capital assets 376,443 341,650 57,737 60,506 434,180 402,156 61,715 62,609 Total assets 731,606 655,372 74,247 71,729 805,853 727,101 164,905 131,386 Deferred Outflows 18,453 15,570 229 288 18,682 15,858 1,898 1,152 Current liabilities 17,447 16,086 5,979 4,747 23,426 20,833 3,804 1,361 Noncurrent liablilities 43,631 63,914 18,679 21,691 62,310 85,605 4,475 15,750 Total liabilities 61,078 80,000 24,658 26,438 85,736 106,438 8,279 17,111 Deferred Inflows 152,183 147,458 - - 152,183 147,458 32,990 1,551 Net Position 536,798 $ 443,484 $ 49,818 $ 45,579 $ 586,616 $ 489,063 $ 125,534 $ 113,876 $ Invested(Net) in capital assets 374,455 $ 339,591 $ 36,501 $ 36,434 $ 410,956 $ 376,025 $ 59,323 $ 54,838 $ Restricted 12,654 15,694 10,523 8,400 23,177 24,094 23,460 26,389 Unrestricted 149,689 88,199 2,794 745 152,483 88,944 42,751 32,649 Total net position 536,798 $ 443,484 $ 49,818 $ 45,579 $ 586,616 $ 489,063 $ 125,534 $ 113,876 $ Component Units County's Net Position (amounts expressed in thousands) Governmental Business-type Activities Activities Total 12 ---PAGE BREAK--- Governmental activities. Governmental activities account for 91.5 percent of the County’s total net position as of December 31, 2021. 2021 2020 2021 2020 2021 2020 2021 2020 Revenues: Program revenues: Charges for services 26,916 $ 23,286 $ 2,489 $ 2,810 $ 29,405 $ 26,096 $ 307 $ 218 $ Operating grants and contributions 41,355 46,206 - - 41,355 46,206 9,480 2,581 Capital grants and contributions 2,992 1,368 - - 2,992 1,368 - - General Revenue: Property taxes 84,005 81,400 - - 84,005 81,400 24,949 28,528 LIT Econ Development 26,372 12,192 - - 26,372 12,192 - - LIT Cert Shares and Public Safety 42,148 19,540 - - 42,148 19,540 5,177 5,192 Excise/Commercial Veh taxes 9,684 6,744 - - 9,684 6,744 - - Drainage Assessments 1,171 1,302 - - 1,171 1,302 - - Other taxes 12,557 8,000 - - 12,557 8,000 2,400 2,578 Food and beverage taxes - - 4,123 1,746 4,123 1,746 - - Sports and convention taxes - - 2,618 2,455 2,618 2,455 - - Unrestricted investment earnings 720 1,567 139 16 859 1,583 87 194 Misc and refund and reimburse 2,539 3,387 - - 2,539 3,387 1,212 868 Total Revenues 250,459 204,992 9,369 7,027 259,828 212,019 43,612 40,159 Expenses: General government 50,049 51,680 - - 50,049 51,680 - - Public safety 80,277 77,236 - - 80,277 77,236 - - Highways and streets 28,931 22,352 - - 28,931 22,352 - - Sanitation 1,650 2,202 - - 1,650 2,202 - - Economic development 14,929 16,816 - - 14,929 16,816 - - Health and welfare 14,825 14,608 - - 14,825 14,608 - - Culture and recreation 6,075 3,008 - - 6,075 3,008 - - Coliseum - - 5,153 8,006 5,153 8,006 - - Allen County Public Library - - - - - - 31,963 30,440 Total expenses 196,736 187,902 5,153 8,006 201,889 195,908 31,963 30,440 Change in net position before: 53,723 17,090 4,216 (979) 57,939 16,111 11,649 9,719 Contributed capital 39,591 12,196 - - 39,591 12,196 - - Gain(Loss) on disposal of assets - - 23 9 23 9 - - Change in net position 93,314 29,286 4,239 (970) 97,553 28,316 11,649 9,719 Net position- beginning 484,929 455,643 45,579 46,549 530,508 502,192 113,884 104,165 Prior period Adj- Note III.F (41,445) - - - (41,445) - - - Net position- beginning(restate) 443,484 455,643 45,579 46,549 489,063 502,192 113,884 104,165 Net position- ending 536,798 $ 484,929 $ 49,818 $ 45,579 $ 586,616 $ 530,508 $ 125,533 $ 113,884 $ Component Units Total (Amounts expressed in thousands) Allen County Changes in Net Position Governmental Activities Business-type Activities 13 ---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 80,000 90,000 General government Public safety Highways and streets Sanitation Economic development Health and welfare Culture and recreation 50,049 80,277 28,931 1,650 14,929 14,825 6,075 11,117 26,304 21,213 1,491 - 7,930 3,208 (In Thousands) Expenses Revenues Property tax 33.5% LIT Econ Development 10.5% LIT Cert Shares and Public Safety 16.8% Excise/Commercial Vehicle Excise taxes 3.9% Charges for services 10.8% Other taxes 5.0% Drain Assessments 0.5% Unrestricted investment earnings 0.3% Operating grants and contributions 16.5% Capital Grants and Contributions 1.2% Misc and refunds and reimbursements 1% General government 25.4% Public safety 40.8% Highways and streets 14.7% Economic development 7.6% Health and welfare 7.6% Culture, Recreation, & Sanitation 3.9% 14 ---PAGE BREAK--- Business-type activities. Business-type activities account for 8.5 percent of the County’s total net position as of December 31, 2021. 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 $9.4 million and incurred $5.2 million of expenses. The total revenues include $2.5 million of program revenue and $6.9 million combined from the Food & Beverage Taxes, Sports & Convention Taxes, and unrestricted investment earnings. 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, 2021, the County’s governmental funds reported a combined ending fund balance of $183.1 million, an increase of $16.2 million or 9.7 percent in comparison over 2020. Assets increased $41.2 million, cash and investments increased $41 million alone due of which $36.9 million was the aforementioned ARPA monies. Liabilities reflected a slight million decrease from 2020. Deferred inflows of resources increased $25.5 million of which $36.8 million is the previously mentioned ARPA monies. The ARPA deferral was offset by a decrease of $12.1 million in income taxes(LIT) deferred. LIT received within 60 days of year end is recognized as revenue in the current period and was not previously. Additionally, LIT property tax relief was previously included with income taxes and should not have been as in reality it serves as property tax replacement. It is a funded property tax credit and is one in the same as property tax revenue when received. Approximately $1 million or .5 percent of the combined ending fund balance are assets held for resale and constitute the Nonspendable fund balance. The majority, $80.3 million or 43.9 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 $31.2 million or 17 percent of the combined ending fund balance. Assigned resources comprise $18.5 million or 10.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 $59.8 million and the overall Unassigned Fund balance at December 31, 2021, was $52.1 million or 28.5 percent. Unassigned fund balances represent resources that do not fall into any of the other classifications and only Charges for services 26.5% Sports and convention tax 27.9% Food and beverage tax 43.9% Unrestricted investment earnings 1.7% 15 ---PAGE BREAK--- 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, 2021, approximately $7.7 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, 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, 2021, the combined fund balance of the Assigned and Unassigned classifications in the General Fund was $77.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 2021 were $120.4 million. Thus, the amount of resources determined to be readily available for expenditure and not bound to restriction or constraint, represents 64.4 percent of the General Fund expenditures for 2021. This ratio increased from the 2020 ratio of 46.8 percent mainly because the Assigned Rainy Day Fund balance is now included with the General Fund for reporting purposes as well as revenues growing at a rate of 14.6 percent versus 11.9 percent for expenses. The General Fund balance increased $7.6 million during fiscal year ended 2021. General Fund revenues exceeded expenditures by $7.3 million with the increase in taxes of $7.8 million or 8.9 percent and intergovernmental revenues $7.6 million or 52.5 percent. The increase in intergovernmental revenues partially due to $2.9 million of Shuttered Venue Operators Grant (SVOG) from the Federal Government. The increase in taxes is a mix of the 4.3 percent annual levy growth quotient, greater delinquent property tax collections, and also receiving a supplemental LIT distribution in 2021. Expenses increased $12.8 million or 11.9 percent as the General Fund covered $2.9 million of operating expenditures for the Coliseum due to lingering effects of COVID on, $2.4 million more expenses for Allen County Community Corrections new residential treatment services program as the program moved to being fully operational, and general operating increases across the board for salaries and less COVID related disruptions. In addition to the General Fund, the County has two other funds that meet the major fund criteria, the LIT Economic Development Fund and the ARPA Fund. 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 $26.1 million at the end of 2021. This is a million or 1.4 percent increase from 2020 as revenues exceeded expenditures by million but net transfers out were million. The ARPA Fund is the result of the American Rescue Plan Act and will be used according to the future plan of the Allen County Commissioners and Council in accordance with the Treasury guidelines. During 2021, Allen County received the first tranche of approximately $36.9 million of which all but million is deferred at year end 2021. Other Governmental Funds ending balance of $72.8 million increased $8.1 million or 12.6 percent for 2021. The revenue increase was spread amongst multiple Funds. Other Governmental expenditures increased $2 million or 3.2 percent due to general operational increases (i.e. salary increases and return to post- COVID operations). 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 $2.8 million for the Allen County War Memorial Coliseum and $2.5 million for the County’s Internal Service funds. The Coliseum had a net operating loss of $1.9 million and non-operating revenue of $6.2 million resulting in ending total net position of $49.8 million or a $4.2 million increase from 2020. The Coliseum Fund was able to experience this increase because the General Fund covered $5.5 million of expenses in 2021. The County’s internal service fund is primarily a Health Self- Insurance fund. The 2021 contributions to the Health Self-Insurance fund were approximately $14.3 million, up $1.5 million from 2020; and claims paid were $16.3 million almost on par with 2020. This resulted in ending total net position for Health Self-Insurance dropping to $2.5 million. 16 ---PAGE BREAK--- GENERAL FUND BUDGETARY HIGHLIGHTS The County’s final General Fund budget for 2021 exceeded its original budget by approximately $13.9 million or 12.1 percent. The key elements of the difference between the original budget and final budget are listed below: ▪ $3.5 million for Highway truck purchases and projects ▪ $2.6 million was for funding the Memorial Coliseum operations as uncertainty still existed with regards to their operations and lingering effects of COVID ▪ $2.4 million was for funding the new Allen County Community Corrections (ACCC) residential treatment services program. The program ramped up operations in 2021 and County Council appropriated funding accordingly ▪ $1.4 million was appropriated for increased IT expenditures associated with the new contract ▪ $1.2 million for Jail expenditures such as food and nursing contract ▪ The remaining amount was due to a mixture of refunds, unspent encumbrances, workers comp claims, and economic development Actual expenditures were approximately $7.6 million less than final budgeted appropriations. The significant unspent appropriations primarily consisted of: $2.7 million in salaries and benefits which are related to turnover and unfilled positions throughout various departments $2.4 million in services mainly comprised of unspent funding for contractual items in various departments a combined $2.4 million in Supplies and Capital, majority being capital for the highway infrastructure and economic development For year-end December 31, 2021, General Fund revenues received were approximately $6.1 million greater than budgeted. Some of the significant contributions to actual revenues exceeding the budgeted figures are: • $2.9 million in SVOG revenue from the Federal Government • Collection of approximately $1.6 million more in property, income, and vehicle excise taxes; and increased intergovernmental revenues in addition to the SVOG grant • $1.3 million for licenses and permits with Building leading the way • Charges for services, fines and forfeits and other misc. revenue increased million • Fines, forfeits and other revenue decreased million combined 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, 2021 was $434.2 million (net of accumulated depreciation), an increase of $32 million or 8 percent. 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. 17 ---PAGE BREAK--- 2021 2020 2021 2020 2021 2020 Land and easements 10,983 $ 11,461 $ 381 $ 381 $ 11,364 $ 11,842 $ Construction in progess 18,184 23,936 430 551 18,614 24,487 Buildings and improvements 75,191 74,672 54,248 56,371 129,439 131,043 Machinery and equipment 11,444 10,168 2,678 3,203 14,122 13,371 Infrastructure being depreciated 257,750 218,433 - - 257,750 218,433 Intangible assets 253 290 - - 253 290 Net investment in joint venture 2,638 2,689 - - 2,638 2,689 376,443 $ 341,649 $ 57,737 $ 60,506 $ 434,180 $ 402,155 $ 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 49 through 51 of this report. Long-term debt. At December 31, 2021, the County had total debt outstanding of $37.5 million. Of this amount, $21.5 million of first mortgage bonds, $16 million of revenue bonds. 2021 2020 2021 2020 2021 2020 General Obligation Bonds - $ - $ - $ - $ - $ - $ First Mortgage Bonds - - 21,464 24,361 21,464 24,361 Revenue Bonds 16,051 17,557 - - 16,051 17,557 16,051 $ 17,557 $ 21,464 $ 24,361 $ 37,515 $ 41,918 $ 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 $4.4 million or 10.5 percent, which is due to regularly scheduled debt service payments. The County currently maintains an Aa2 Underlying rating from Moody’s Investor Services for the Memorial Coliseum first mortgage series 2016, 2014 and 2011. Moody’s provided an Aa1 Underlying rating for the 2016 Maplecrest Bridge Revenue Bonds. The 2015C General Motors Tax Increment Finance bonds have an A1 rating. At December 31, 2021 the County had a net pension liability of $14 million which is $18.5 million or 56.8 percent less than the December 31, 2020 net pension liability. This is completely indicative of the stock market performance during 2021. The OPEB liability decreased million or 1.5 percent for the same period and due mainly to the increase in the 20 yr municipal bond indices used as the discount rate. Deferred outflows of resources related to pensions and OPEB were $17.3 million compared with $30.1 million in deferred inflows of resources related to pensions and OPEB. In addition to the indebtedness noted above, the County also has long-term liabilities for compensated absences totaling $4.5 million at December 31, 2021 compared with $4.6 million at year end 2020. 18 ---PAGE BREAK--- Additional information on the County’s long-term debt can be found in Note III.D on pages 51 through 53 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 68 percent of the County’s population. The eastern half of the county is largely agricultural with several smaller cities and towns. ▪ The record setting economic climate in the County continued rolling right along in 2021. Building permits, one measure used to gauge construction activity, again set a record for value of permits pulled. The local real estate market sustained the trend of demand exceeding supply, driven by record-low borrowing rates. Directly tied to the local real estate market, Net Assessed Value (NAV) again increased 7 percent for 2021. This equates to 31.7 percent NAV growth in the last 5 years. This has driven down property tax rates while allowing for a greater collection rate of property tax levies. Property tax revenue should continue to increase in the 4-5 percent range for at least 2022 and 2023 as higher values mean less circuit breaker tax cap losses. As has been the case almost annually now, the County received another supplemental income tax distribution in early 2021 which is distributed based on our Trust Balance exceeding 15 percent of the certified distribution amount. Further demonstrating that income tax collections outpaced the estimates used by the department of revenue in calculating our certified distributions. One limitation on income tax revenue growth, as is the case with most of the nation in general, unemployment is incredibly low at 3.7 percent 2021 annual average and many employers continue to struggle finding employees. ▪ For 2022, the County is extremely well positioned fiscally. The County is still in the process of putting together its plan for the $70+ million ARPA monies to be received. As of the beginning of 2022, only $5 million has been set aside for sewer related infrastructure projects. Intent is to fund substantial investments in the community over the next few years that will have exponential effects. As was previously mentioned above, property tax collections will be up in 2022 and 2023. We are anticipating another supplemental local income tax distribution in 2022 as well. The County is currently in the process of reviewing options for handling the over-crowding at the County Jail. Financially, the most significant choice would be the construction of a new jail. Additionally, the County is currently reviewing options for re-location of ACCC, which may also result in the purchase of another building. For both the jail and the ACCC re-location, accurate estimates are not available at this time, but both are anticipated to cost tens of millions of which County reserves can be used in conjunction with new indebtedness if necessary. These factors along with others were considered when preparing the County’s budget for the 2022 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]. 19 ---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. 20 ---PAGE BREAK--- Governmental Business-Type Component Assets Activities Activities Totals Unit Cash and cash equivalents - unrestricted 208,697,345 $ 2,413,770 $ 211,111,115 $ 46,697,230 $ Investments - unrestricted 6,839,152 87,929 6,927,081 23,885,629 Receivables (net of allowances for uncollectible): Interest 69,764 760 70,524 69,797 Taxes 127,605,211 - 127,605,211 26,582,344 Accounts 844,817 446,166 1,290,983 - Special assessments 26,178 - 26,178 - Intergovernmental 7,155,075 - 7,155,075 5,126,447 Suite - 159,313 159,313 - Other - - - 380,317 Inventories 1,671,892 - 1,671,892 - Prepaid expense 1,287,056 183,180 1,470,236 448,149 Assets held for resale 966,088 - 966,088 - Restricted assets: Cash and cash equivalents - restricted - 10,131,815 10,131,815 - Cash with fiscal agent - restricted - 7,461 7,461 - Investments - restricted - 269,857 269,857 - Interest receivable - 2,470 2,470 - Taxes receivable - 2,151,996 2,151,996 - Suite receivable - 655,833 655,833 - Capital assets: Land and construction in progress 29,167,483 811,054 29,978,537 5,954,969 Other capital assets, net of depreciation 347,275,904 56,925,775 404,201,679 55,760,725 Total assets 731,605,965 74,247,379 805,853,344 164,905,607 Deferred Outflows of Resources Unamortized loss on refunding 1,148,229 228,629 1,376,858 - Other postemployment benefits related 3,206,218 - 3,206,218 - Pension related 14,098,553 - 14,098,553 1,897,535 Total deferred outflow of resources 18,453,000 228,629 18,681,629 1,897,535 Liabilities Accounts payable 5,686,704 126,327 5,813,031 736,988 Accrued payroll and withholdings payable 3,726,083 133,506 3,859,589 604,354 Taxes payable - 1,723 1,723 - Accrued interest payable - - - 11,551 Incurred but not reported claims 2,101,884 - 2,101,884 - Unearned revenue - 1,127,332 1,127,332 - Payable from restricted assets: Accounts payable - 87,002 87,002 - Ticket office customer deposits payable - 1,433,559 1,433,559 - First mortgage revenue bonds - due within one year - 2,785,000 2,785,000 - Accrued interest payable 190,455 136,674 327,129 - Noncurrent liabilities: Due within one year: First mortgage general obligation bonds payable - - - 2,316,178 Compensated absences 4,356,523 148,029 4,504,552 135,073 Revenue bonds payable 1,385,000 - 1,385,000 - Due in more than one year: First mortgage revenue bonds payable (net of premium) - 18,678,677 18,678,677 - Compensated absences - - - 675,365 Revenue bonds payable (net of premium/discounts) 14,665,876 - 14,665,876 - Unearned revenue - - - 1,332,300 Net pension liability 14,021,752 - 14,021,752 2,467,609 Net other postemployment benefits liability 14,943,939 - 14,943,939 - Total liabilities 61,078,216 24,657,829 85,736,045 8,279,418 Deferred Inflows of Resources Unavailable Revenue 122,022,884 - 122,022,884 28,926,406 Other postemployment benefits related 1,144,498 - 1,144,498 - Unamortized gain on refunding - - - 76,627 Pension related 29,015,318 - 29,015,318 3,986,864 Total deferred inflows of resources 152,182,700 - 152,182,700 32,989,897 Net position Net investment in capital assets 374,455,424 36,501,781 410,957,205 59,322,889 Restricted for: Debt service Capital projects - 7,461 7,461 3,643,391 Debt service 12,505,000 - 12,505,000 2,384,577 Perpetual endowment subject to donor stipulations - - - 10,000,713 Perpetual endowment subject to time restrictions - - - 5,480,464 Other purposes 148,769 10,515,166 10,663,935 1,951,216 Unrestricted 149,688,856 2,793,771 152,482,627 42,750,577 Total net position 536,798,049 $ 49,818,179 $ 586,616,228 $ 125,533,827 $ The notes to the financial statements are an integral part of this statement. Primary Government ALLEN COUNTY STATEMENT OF NET POSITION December 31, 2021 21 ---PAGE BREAK--- Operating Capital Charges for Grants and Grants and Governmental Business-Type Component Functions/Programs Expenses Services Contributions Contributions Activities Activities Totals Units Primary government: Governmental activities: General government 50,048,956 $ 7,090,745 $ 4,026,715 $ - $ (38,931,496) $ - $ (38,931,496) $ - $ Public safety 80,277,230 13,784,837 12,519,209 - (53,973,184) - (53,973,184) - Highways and streets 28,931,020 520,557 17,700,486 2,992,049 (7,717,928) - (7,717,928) - Sanitation 1,650,320 1,485,561 4,999 - (159,760) - (159,760) - Economic development 14,929,024 - - - (14,929,024) - (14,929,024) - Health and welfare 14,824,858 3,846,045 4,084,513 - (6,894,300) - (6,894,300) - Culture and recreation 6,075,479 188,483 3,019,121 - (2,867,875) - (2,867,875) - Total governmental activities 196,736,887 26,916,228 41,355,043 2,992,049 (125,473,567) - (125,473,567) - Business-type activities: Coliseum 5,153,520 2,488,730 - - - (2,664,790) (2,664,790) - Total primary government 201,890,407 $ 29,404,958 $ 41,355,043 $ 2,992,049 $ (125,473,567) (2,664,790) (128,138,357) - Component unit: Allen County Public Library 31,962,560 $ 306,588 $ 9,479,759 $ - $ - - - (22,176,213) General revenues: Property taxes 84,004,684 - 84,004,684 24,948,551 LIT economic development 26,372,473 - 26,372,473 - LIT distributive shares 42,148,465 - 42,148,465 5,176,720 Excise/Commercial Vehicle Excise Taxes 9,683,822 - 9,683,822 2,400,411 Drainage Assessments 1,171,180 - 1,171,180 - Other taxes 12,557,200 - 12,557,200 Food and beverage taxes - 4,123,100 4,123,100 - Sports and convention taxes - 2,618,366 2,618,366 - Unrestricted investment earnings 720,168 138,721 858,889 87,538 Miscellaneous and refunds and reimbursements 2,538,595 - 2,538,595 1,212,819 Capital contributions 39,591,323 - 39,591,323 - Gain on disposal of assets - 23,274 23,274 - Total general revenues 218,787,910 6,903,461 225,691,371 33,826,039 Change in net position 93,314,343 4,238,671 97,553,014 11,649,826 Net position - beginning 484,928,874 45,579,508 530,508,382 113,884,001 Prior period adjustment - See Note III. F. (41,445,168) - (41,445,168) - Net position - beginning (restated) 443,483,706 45,579,508 489,063,214 113,884,001 Net position - ending 536,798,049 $ 49,818,179 $ 586,616,228 $ 125,533,827 $ 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, 2021 22 ---PAGE BREAK--- Local Income ARP Other Tax - Economic Coronavirus Governmental Assets General Development Local Recovery Funds Totals Cash and cash equivalents 73,524,239 $ 18,492,111 $ 35,720,231 $ 76,239,201 $ 203,975,782 $ Investments 2,439,068 610,088 1,178,475 2,455,748 6,683,379 Receivables (net of allowances for uncollectibles): Interest 42,326 - 11,406 14,928 68,660 Taxes 95,008,646 13,317,259 19,279,306 127,605,211 Accounts 322,432 - 480,368 802,800 Special assessments - - 26,178 26,178 Intergovernmental 4,684,195 92,642 2,378,238 7,155,075 Interfund receivable: Interfund loans 1,679,883 7,868,599 106,718 9,655,200 Assets held for resale - - - 966,088 966,088 Total assets 177,700,789 $ 40,380,699 $ 36,910,112 $ 101,946,773 $ 356,938,373 $ Liabilities, Deferred Inflows of Resources, Fund Balances Liabilities: Accounts payable 1,689,958 $ 1,114,671 $ - $ 2,523,434 $ 5,328,063 $ Accrued payroll and withholdings payable 2,929,321 215,164 - 581,598 3,726,083 Interfund payable: - Interfund loans - 1,628,246 - 8,026,954 9,655,200 Total liabilities 4,619,279 2,958,081 - 11,131,986 18,709,346 Deferred inflows of resources: Unavailable revenue - property taxes 70,233,374 - - 14,346,437 84,579,811 Unavailable revenue - intergovernmental - - 36,837,192 - 36,837,192 Unavailable revenue - commercial vehicle excise taxes 209,586 - - 31,531 241,117 Unavailable revenue - financial institution taxes 317,064 - - 47,700 364,764 Unavailable revenue - income taxes 18,093,388 11,358,185 - 3,621,840 33,073,413 Total deferred inflows of resources 88,853,412 11,358,185 36,837,192 18,047,508 155,096,297 Fund balances: Nonspendable fund balance - - - 966,088 966,088 Restricted fund balance 4,780,997 148,769 72,920 75,349,032 80,351,718 Committed fund balance 1,947,324 25,915,664 - 3,312,824 31,175,812 Assigned fund balance 17,666,094 - - 810,969 18,477,063 Unassigned fund balance 59,833,683 - - (7,671,634) 52,162,049 Total fund balances 84,228,098 26,064,433 72,920 72,767,279 183,132,730 Total liabilities, deferred inflows of resources, and fund balances 177,700,789 $ 40,380,699 $ 36,910,112 $ 101,946,773 $ 356,938,373 $ ALLEN COUNTY BALANCE SHEET - GOVERNMENTAL FUNDS December 31, 2021 The notes to the financial statements are an integral part of this statement. 23 ---PAGE BREAK--- Fund Balance - governmental funds 183,132,730 $ 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: Land and construction in progress 29,167,483 $ Other capital assets, net of depreciation 347,275,904 376,443,387 Prepaids are not current financial resources and, therefore, are not reported in the funds. 1,287,056 Inventory is not a current financial resources and, therefore, is not reported in the funds. 1,671,892 Pension liability is not paid from current financial resources and, therefore, is not shown in the funds. Net pension asset 970,684 Net pension liability (14,992,436) (14,021,752) Deferred outflows of resources on the loss on refunding of debt are not recognized in the governmental funds, but are recorded in the Statement of Net Position. 1,148,229 Deferred outflows of resources on pension related items are not recognized in the governmental funds, but are recorded in the Statement of Net Position. 14,098,553 Deferred inflows of resources on pension related items are not recognized in the governmental funds, but are recorded in the Statement of Net Position. (29,015,318) Deferred inflows of resources on revenue (Local Income Tax) items are recognized in the governmental funds, but are not recorded in the Statement of Net Position. 33,073,413 Internal service funds are used by management to charge the costs of insurance to governmental funds. The assets and liabilities of the Internal Service Funds are included in governmental activites in the Statement of Net Position. 2,459,932 Total OPEB liability is not paid from current financial resources and, therefore, is not shown in the funds (14,943,939) Deferred outflows of resources on OPEB related items are not recognized in the governmental funds, but are recorded in the Statement of Net Position. 3,206,218 Deferred inflows of resources on OPEB related items are not recognized in the governmental funds, but are recorded in the Statement of Net Position. (1,144,498) Compensated absences are not due and payable in the current period and, therefore, are not reported in the funds. (4,356,523) Accrued interest on bonds payable is not due and payable in the current period and, therefore, is not reported in the funds. (190,455) Long-term liabilities, including bonds payable, are not due and payable in the current period and, therefore, are not reported in the funds: Tax increment financing bonds (1,987,963) $ Revenue bonds (14,062,913) (16,050,876) Net position of governmental activities 536,798,049 $ ALLEN COUNTY RECONCILIATION OF THE BALANCE SHEET OF GOVERNMENTAL FUNDS TO THE STATEMENT OF NET POSITION For The Year Ended December 31, 2021 The notes to the financial statements are an integral part of this statement. 24 ---PAGE BREAK--- Local Income ARP Other Total Tax - Economic Coronavirus Governmental Governmental General Development Local Recovery Funds Funds Revenues: Taxes 94,977,801 $ 15,014,287 $ - $ 20,600,521 $ 130,592,609 $ Special assessments - - - 1,171,180 1,171,180 Licenses and permits 3,634,144 - - - 3,634,144 Intergovernmental 22,069,849 1,958,692 - 28,941,396 52,969,937 Charges for services 3,832,812 - - 15,972,438 19,805,250 Fines and forfeits 801,679 - - 1,964,490 2,766,169 Other 2,407,248 15,645 72,920 3,875,610 6,371,423 Total revenues 127,723,533 16,988,624 72,920 72,525,635 217,310,712 Expenditures: Current: General government 47,181,899 - - 5,130,024 52,311,923 Public safety 57,932,470 - - 21,623,879 79,556,349 Highways and streets 2,114,046 - - 15,228,042 17,342,088 Sanitation 29,878 - - 1,597,339 1,627,217 Economic development 26,755 - - 15,026 41,781 Health and welfare 7,048,832 - - 7,738,736 14,787,568 Culture and recreation 6,098,863 - - 379,129 6,477,992 Debt service: Principal - - - 1,305,000 1,305,000 Interest - - - 660,769 660,769 Capital outlay: Economic development - 16,252,042 - 10,039,268 26,291,310 Special assessment - - - 723,842 723,842 Total expenditures 120,432,743 16,252,042 - 64,441,054 201,125,839 Excess (deficiency) of revenues over (under) expenditures 7,290,790 736,582 72,920 8,084,581 16,184,873 Other financing sources (uses): Transfers in 544,929 446,705 - 1,024,063 2,015,697 Transfers out (197,500) (833,007) - (985,190) (2,015,697) Total other financing sources and uses 347,429 (386,302) - 38,873 - Net change in fund balances 7,638,219 350,280 72,920 8,123,454 16,184,873 Fund balances - beginning 52,947,025 25,714,153 - 70,315,403 148,976,581 Prior period adjustment-See Note III. F. 23,642,854 - - (5,671,578) 17,971,276 Fund balances - beginning (restated) 76,589,879 25,714,153 - 64,643,825 166,947,857 Fund balances - ending 84,228,098 $ 26,064,433 $ 72,920 $ 72,767,279 $ 183,132,730 $ ALLEN COUNTY STATEMENT OF REVENUES, EXPENDITURES ,AND CHANGES IN FUND BALANCES - GOVERNMENTAL FUNDS For The Year Ended December 31, 2021 The notes to the financial statements are an integral part of this statement. 25 ---PAGE BREAK--- Net change in fund balances - total governmental funds (Statement of Revenues, Expenditures and Changes in Fund Balances). 16,184,873 $ 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 - Construction in progress (6,229,130) Total change in capital assets not being depreciated (6,229,130) Capital assets being depreciated: Buildings, net of $2,047,578 depreciation expense 157,606 Improvements other than buildings, net of $19,022 depreciation expense 361,530 Machinery and equipment, net of $(6,529,241) depreciation expense 1,275,676 Infrastructure, net of $4,620,255 depreciation expense 39,315,906 Net investment in joint venture, net of $153,565 depreciation expense (51,459) Intangible assets, net of $36,295 depreciation expense (36,295) Total change in capital assets being depreciated 41,022,964 Total changes in capital assets 34,793,834 Revenues in the Statement of Activities that do not provide current financial resources are not reported as revenues in the governmental funds. 33,073,413 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. 1,305,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. 53,294 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. 205,630 Net pension liabilities are considered a long-term obligation of the general government, but are not current expenditures. 10,151,349 Other postemployment benefits liability is considered a long-term obligation of the general government, but is not a current expenditure. (722,189) 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. 116,965 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,847,826) Change in net position of governmental activities (Statement of Activities) 93,314,343 $ 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, 2021 26 ---PAGE BREAK--- Business-Type Activities - Enterprise Fund War Memorial Internal Assets Coliseum Service Funds Current assets: Cash and cash equivalents 2,413,770 $ 4,721,563 $ Investments 87,929 155,773 Interest receivable 760 1,104 Accounts receivable (net of allowance) 446,166 42,017 Suite receivable 159,313 - Prepaid items 183,180 - Total current assets 3,291,118 4,920,457 Noncurrent assets: Restricted cash, cash equivalents and investments: Cash and cash equivalents 10,131,815 - Cash with fiscal agent 7,461 - Investments 269,857 - Interest receivable 2,470 - Taxes receivable 2,151,996 - Suite receivable 655,833 - Capital assets: Land, and construction in progress 811,054 - Other capital assets (net of accumulated depreciation) 56,925,775 - Total noncurrent assets 70,956,261 - Deferred Outflows of Resources Unamortized loss on refunding 228,629 - Liabilities Current liabilities: Accounts payable 126,327 358,641 Accrued wages payable 133,506 - Taxes payable 1,723 - Compensated absences 148,029 - Incurred but not reported claims - 2,101,884 Unearned revenue 1,127,332 - Current liabilities payable from restricted assets: Accounts payable 87,002 - Ticket office customer deposits 1,433,559 - First mortgage revenue bonds payable 2,785,000 - Accrued interest payable 136,674 - Total current liabilities 5,979,152 2,460,525 Noncurrent liabilities: First mortgage revenue bonds payable (net of unamortized premium) 18,678,677 - Total liabilities 24,657,829 2,460,525 Net position Net investment in capital assets 36,501,781 - Restricted for capital assets 7,461 - Restricted for other purposes 10,515,166 - Unrestricted 2,793,771 2,459,932 Total net position 49,818,179 $ 2,459,932 $ ALLEN COUNTY STATEMENT OF NET POSITION - PROPRIETARY FUNDS December 31, 2021 The notes to the financial statements are an integral part of this statement. 27 ---PAGE BREAK--- Business-Type Activities - Enterprise Fund War Memorial Internal Coliseum Service Funds Operating revenues: Miscellaneous 20,181 $ 62,785 $ Rent 635,763 - Concessions 448,828 - Parking 840,329 - Ticket office 72,921 - Advertising 186,084 - Arena maintenance fee 153,912 - Suite/club seats 124,512 - Advance forfeiture rent 6,200 - Employee/employer contributions - 14,337,960 Total operating revenues 2,488,730 14,400,745 Operating expenses: Salaries and wages 139,987 - Materials and supplies 48,541 - Purchased services 94,879 - Miscellaneous 9,822 - Maintenance and repair 121,190 - Insurance claims and expenses - 16,261,568 Depreciation 4,008,202 - Total operating expenses 4,422,621 16,261,568 Operating Income (loss) (1,933,891) (1,860,823) Nonoperating revenues (expenses): Interest and investment revenue 138,721 12,997 Food and beverage taxes 9,275,893 - Transfer to Capital Improvement Board/Food and beverage taxes (5,152,793) - Sports and convention taxes 2,618,366 - Amortization of loss on bond refunding (59,643) - Interest expense (671,256) - Gain on disposal of assets 23,274 - Total nonoperating revenue 6,172,562 12,997 Income (loss) before contributions 4,238,671 (1,847,826) Capital contributions - - Change in net position 4,238,671 (1,847,826) Total net position - beginning 45,579,508 4,307,758 Total net position - ending 49,818,179 $ 2,459,932 $ ALLEN COUNTY STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN FUND NET POSITION - PROPRIETARY FUNDS For The Year Ended December 31, 2021 The notes to the financial statements are an integral part of this statement. 28 ---PAGE BREAK--- Business-Type Activities - Enterprise Fund War Memorial Internal Coliseum Service Funds Cash flows from operating activities: Receipts from customers and users 2,379,441 $ 14,490,283 $ Payments to suppliers 180,031 (16,535,930) Payments to employees (10,901) - Other receipts - 20,944 Net cash provided (used) by operating activities 2,548,571 (2,024,703) Cash flows from capital and related financing activities: Acquisition and construction of capital assets (1,215,337) - Principal paid on capital debt (2,670,000) - Interest paid on capital debt (917,936) - Food and beverage taxes 3,753,394 - Sports and convention taxes 2,787,615 - Net cash provided (used) by capital and related financing activities 1,737,736 - Cash flows from investing activities: Proceeds from sales and maturities of investments 153,382 65,174 Purchase of investments (357,786) (155,773) Interest received 138,458 13,154 Net cash provided (used) by investing activities (65,946) (77,445) Net increase (decrease) in cash and cash equivalents 4,220,361 (2,102,148) Cash and cash equivalents, January 1 8,332,685 6,823,711 Cash and cash equivalents, December 31 12,553,046 $ 4,721,563 $ Reconciliation of operating income (loss) to net cash provided by operating activities: Operating income (loss) (1,933,891) $ (1,860,823) $ Adjustments to reconcile operating income (loss) to net cash provided by operating activities: Depreciation expense 4,008,202 - (Increase) decrease in assets: Accounts receivable (418,623) 110,482 Prepaid items 4,499 - Increase (decrease) in liabilities: Customer deposits 485,556 - Accrued wages payable 133,506 - Accounts payable (36,948) (226,793) Unavailable revenue 309,334 - Taxes payable 1,356 - Compensated absence payable (4,420) - Incurred but not reported claims - (47,569) Total adjustments 4,482,462 (163,880) Net cash provided (used) by operating activities 2,548,571 $ (2,024,703) $ ALLEN COUNTY STATEMENT OF CASH FLOWS - PROPRIETARY FUNDS For The Year Ended December 31, 2021 The notes to the financial statements are an integral part of this statement. 29 ---PAGE BREAK--- Pension Trust Custodial Assets Funds Funds Cash and cash equivalents 5,185,575 $ 24,797,750 $ Receivables: Accounts - 41,555 Taxes for other governments - 491,643,026 Interest and dividends 96 31 Employee/employer contributions 33,296 - Transfers into trust 10,241 - Total receivables 43,633 491,684,612 Investments at fair value: U.S. government securities - 224,525 Shares of unit investment trusts 70,350,694 - Total investments 70,350,694 224,525 Total assets 75,579,902 $ 516,706,887 $ Liabilities Net benefits due and unpaid/(overpaid) 16,755 $ - $ Transfers out of trust 10,241 - Accounts payable and other liabilities - 4,714 Due to other governments - 40,685,623 Total liabilities 26,996 40,690,337 Deferred Inflows of Resources Unavailable Revenue - $ 386,337,212 $ Net Position Net position held in trust for: Employees' pension benefits 75,552,906 - Individuals, organizations, and other governments - 89,679,338 Total net position restricted for fiduciary funds 75,552,906 $ 89,679,338 $ ALLEN COUNTY STATEMENT OF FIDUCIARY NET POSITION - FIDUCIARY FUNDS December 31, 2021 The notes to the financial statements are an integral part of this statement. 30 ---PAGE BREAK--- Pension Trust Custodial Additions Funds Funds Contributions: Employer 3,059,206 $ - $ Plan members 288,467 - Total contributions 3,347,673 - Investment income: Net increase in fair value of investments 6,518,769 - Interest and dividends 2,284,849 352 Net investment income 8,803,618 352 Collections: Taxes for other governments - 624,017,638 Taxes for individuals/organizations - 14,065,530 Fines/Fees/Restitution - 33,709,677 Transfer in 10,241 - Miscellaneous 330 2,782,877 Total Collections 10,571 674,575,722 Total additions 12,161,862 674,576,074 Deductions Benefits - - Administrative expense 110,082 - Transfer out 10,241 - Payments of tax to other governments - 560,898,151 Payments to individuals and organizations 4,216,286 50,087,036 Total deductions 4,336,609 610,985,187 Net increase (decrease) in fiduciary net position 7,825,253 63,590,887 Net position - beginning 67,727,653 26,088,451 Net position - ending 75,552,906 $ 89,679,338 $ 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, 2021 31 ---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), 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 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. The financial statement of the individual component unit may be obtained from their respective office as follows: Allen County War Memorial Coliseum Additions Building Corporation c/o Wells Fargo Bank Corporate Trust Department 111 E. Wayne Street Fort Wayne, IN 46801 The Allen County Redevelopment Authority (Authority) is a significant blended component unit of the primary government. The primary government appoints a voting majority of the Authority’s board and a financial benefit/burden relationship exists between the primary government and the Authority. Although it is legally separate from the primary government, the Authority 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 debt of the Authority will be repaid entirely, or almost entirely, from resources of the primary government. The financial statement of the individual component unit may be obtained from their respective office as follows: Allen County Redevelopment Authority 200 East Berry Street, Suite 150 Fort Wayne, IN 46802 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 32 ---PAGE BREAK--- 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. The financial statements of the individual component units may be obtained from their respective offices as follows: 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 Rousseau Centre’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 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 increased by $102,106 for its share of the 2021 net income. 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. 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. 33 ---PAGE BREAK--- 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. Under the accrual basis of accounting, revenues are recognized when earned and expenses are recorded when the liability is incurred, or economic asset used. Revenues, expenses, gains, losses, assets, and liabilities resulting from exchange and exchange- like transactions are recognized when the exchange takes place. 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. Government-wide financial statements report information on all of the non-fiduciary activities of the County. 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. Local Income Tax – Economic Development (capital projects) accounts for the local economic development income tax revenue and economic related expenses of the general government. ARP Coronavirus Local Recovery – Federal funding (special revenue) that can be used for local recovery from the COVID-19 pandemic. 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. 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. Custodial 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 rule, the effect of interfund activity has been eliminated from the government-wide financial statements. 34 ---PAGE BREAK--- 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. 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 35 ---PAGE BREAK--- between the governmental activities and business-type activities are reported in the government-wide financial statements as “internal balances.” The County provided certain drain and utility improvements for three drains: Clark Yoder, Clark, and JH Harber. These improvements were financed by a loan from the General Drain Improvement Fund. The loan outstanding on December 31, 2021 was $106,718. Repayment of the loan will be made by the Local Income Tax - Economic Development Fund. The County provided equipment to update its fleet of aging Tandem Axle Snowplow Trucks to properly and effectively maintain County roadways. This equipment was financed by a loan from the Rainy-Day Fund that is presented in the County’s financial statements within the General Fund. The loan outstanding on December 31, 2021 was $1,521,528. Repayment of the loan will be made by the Highway’s portion of the Local Income Tax – Economic Development Fund.. 4. Property Taxes 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 December 31. These rates were based upon the preceding year’s lien date, January 1, 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, and the ensuing year property tax levy, 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: 36 ---PAGE BREAK--- 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 $671,256. 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 withheld from actual debt proceeds received, are reported as debt service expenditures. 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 37 ---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, Other Post-Employment Benefits (OPEB) and Unavailable revenue related resources in the amount of $52,182,700 for 2021. These inflows consist of INPRS retirement system of $19,540,236, the County Police Retirement plan in the amount of $8,509,932, the County Police Supplemental Benefit plan in the amount of $965,150, OPEB in the amount of $1,144,498 and Unavailable revenue in the amount of $122,022,884. Deferred outflows of resources represent a consumption of net position that applies to future periods. The Allen County War Memorial Coliseum bonds for Business-Type Activities with a total loss of $407,043 the unamortized amount $173,370 for the 2016A Series and a total loss of $209,024 the unamortized amount of $55,259 for the 2011B Series, and the Maplecrest Road Bridge Bond 2016 with a total loss of $1,926,062 the unamortized amount of $1,148,229. The deferred outflows for governmental activities that is pension and OPEB related totals $17,304,771 and consists of INPRS retirement system of $9,421,467, the County Police Retirement plan in the amount of $4,453,487, the County Police Supplemental Benefit plan in the amount of $223,599, and OPEB $3,206,218. 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 additional appropriation or emergency executive order 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 as the assignment is done by a body other than the County Commissioners and/or County Council. 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. 38 ---PAGE BREAK--- For functionalized classification of fund balance, please refer to Note II. B. 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. Fund balances at December 31, 2021 are composed of the following: Local Income Tax ARP Other Economic Coronavirus Governmental General Development Local Recovery Funds Totals Nonspendable fund balance: Economic development - - - 966,088 966,088 Restricted fund balance: General Government 1,376,254 - 72,920 26,442,223 27,891,397 Public Safety 3,161,679 - - 8,711,639 11,873,318 Highw ays and Streets - - - 19,293,382 19,293,382 Sanitation 2,237 - - 2,356,841 2,359,078 Culture and Recreation - - - 887,265 887,265 Economic Development 122,607 148,769 - 13,883,114 14,154,490 Health and Welfare 118,220 - - 3,774,568 3,892,788 Total restricted fund balance 4,780,997 148,769 72,920 75,349,032 80,351,718 39 ---PAGE BREAK--- C. Deficit Fund Equity At December 31, 2021, 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 Committed fund balance: General Government 817,653 - - 1,381,177 2,198,830 Public Safety 216,533 - - 603,986 820,519 Highw ays and Streets 522,878 - - - 522,878 Culture and Recreation 28,840 - - 21,301 50,141 Economic Development 361,420 25,915,664 - 745,316 27,022,400 Health and Welfare - - - 561,044 561,044 Total committed fund balance 1,947,324 25,915,664 - 3,312,824 31,175,812 Assigned fund balance: General Government 17,601,972 - - 321,353 17,923,325 Public Safety 63,126 - - - 63,126 Culture and Recreation 996 - - - 996 Economic Development - - - 489,616 489,616 Total assigned fund balance 17,666,094 - - 810,969 18,477,063 Unassigned fund balance 59,833,683 - - (7,671,634) 52,162,049 Total fund balance 84,228,098 $ 26,064,433 $ 72,920 $ 72,767,279 $ 183,132,730 $ Fund 2021 Governmental Funds: Community Corrections 117,598 $ Check and Connect 73,699 COVID 19 Donation 2,667 Stellar Regional Rural Dev 80 Volunteer Advocates for Seniors 456 COVID 19 Routine Vaccine 375 OVWI Cir Crt Interpreter 3,599 ACCC Adult Probation Grant 17,030 ISDH Syringe Service Prog 1,783 DUI Task Force Enforcement 5,217 CASAD East TIF 877,135 Bandalier TIF 1,223,729 Group Delphi TIF 1,670,997 Dupont Corner TIF 789,152 Stonebridge TIF 2,888,117 40 ---PAGE BREAK--- 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 covers all public funds held in approved depositories. At December 31, 2021, the Sheriff’s Retirement and Benefit Pension Plans had deposit balances in the amount of $5,185,575. 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, 2021, 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 Primary Government: Investment Type Fair Value Government sponsored enterprises 5,492,650 $ External investment pool 2,066,476 Total 7,559,126 $ Sheriff's Retirement and Benefit Pension Plans: Investment Type Fair Value Mutual funds 18,923,560 $ Foreign mutual fund 51,427,134 Total 70,350,694 $ Amount Uninsured and uncollateralized deposits 5,185,575 $ 41 ---PAGE BREAK--- 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 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 November 3, 2016. 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: Primary Government: Not in the Investment Government's Type Name Government sponsored enterprises 5,492,650 $ 42 ---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 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 Primary Government: Investment Less More Type Than 1 1-2 Than 2 Government sponsored enterprises 1,000,210 $ 1,993,090 $ 2,499,350 $ External investment pool 2,066,476 - - Totals 3,066,686 $ 1,993,090 $ 2,499,350 $ Sheriff's Retirement and Benefit Pension Plans: Investment Less More Type Than 0-5 5-15 Than 15 Mutual funds 18,923,560 $ - - Foreign mutual funds 51,427,134 - - Totals 70,350,694 $ - $ - $ Investment Maturities (in Years) Investment Maturities (in Years) Sheriff's Retirement and Benefit Pension Plans: Not in the Investment Government's Type Name Mutual funds 18,923,560 $ Foreign mutual fund 51,427,134 Total 70,350,694 $ 43 ---PAGE BREAK--- 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 regarding 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: 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 regarding foreign currency Primary Government: Standard & Government Poor's Moody's Sponsored Investment Rating Rating Enterprise Pools AAA Aaa 5,492,650 $ 1,301,443 $ AA Aa - 254,954 A A - 510,079 Totals 5,492,650 $ 2,066,476 $ County's Investments Sheriff's Retirement and Benefit Pension Plans: Standard & Poor's Moody's Mutual Rating Rating Funds Unrated Unrated 70,350,694 $ Sheriff's Pension Plan Investments Primary Government: Issuer 2021 Federal Home Loan Banks 3,498,360 $ Federal Farm Credit Banks 1,994,290 Collateralized Commercial Paper V Company 382,494 Total 5,875,144 $ 44 ---PAGE BREAK--- 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, 2021: 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 Primary Government: Investment Type Fair Value Level 1 Level 2 Level 3 Government sponsored enterprises 5,492,650 $ - $ 5,492,650 $ - $ External investment pool 2,066,476 - 2,066,476 - Totals 7,559,126 $ - $ 7,559,126 $ - $ Sheriff's Retirement and Benefit Pension Plans: Investment Type Fair Value Level 1 Level 2 Level 3 Mutual funds 18,923,560 $ 18,923,560 $ - $ - $ Foreign mutual funds 51,427,134 51,427,134 - - Totals 70,350,694 $ 70,350,694 $ - $ - $ 45 ---PAGE BREAK--- 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, 2021, the County’s discretely presented component unit’s deposits with financial institutions of $44,865,444 were entirely insured by the federal depository insurance, with the exception of the Allen County Public Library’s deposits in the amount of $814,905. Deposits of $766,679 are in excess of the insured amount and $814,905 is in investment accounts that are uninsured. 2. Investments Authorization for investment activity is stated in Indiana Code 5-13. As of December 31, 2021, 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. The Library’s discretely presented component unit has an “Investment Policy Statement” approved by the unit’s Board of Directors in May 2004 with revisions in November 2010, November 2012, September 2017 and June 2019. This policy sets the standards for the selection of the unit’s portfolio. The policy sets the asset allocation as follows: cash and cash equivalents 0% to 5% with a target of fixed income 20% to 40% with a target of 30%; alternative investments 0% to 10% with a target of equities 40% to 90% with a target of 65%. 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’s discretely presented component unit does not have formal investment policies for custodial credit risk for investments that are uninsured and uncollateralized. At June 30, 2021, the Library’s discretely presented component unit held investments in Cozad Asset Management, Inc., Monarch Capital Management, Inc. and Wells Fargo Advisors, LLC in the amount of $23,905,631. Discretely Presented Component Unit: Investment Type Fair Value Government sponsored enterprises 3,361,724 $ Corporate bonds 294,176 Corporate stock 13,519,913 U.S. Treasuries and securities 197,064 Mutual funds 6,512,752 Total 23,885,629 $ 46 ---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 Allen County Public Library’s discretely presented component unit’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 discretely presented component unit’s investment policy for credit risk for investments of A or better. The distribution of securities with credit ratings is summarized below. Discretely Presented Component Unit: Standard & Morningstar Government Poor's Risk Sponsored Corporate Mutual Rating Profile Enterprise Bonds Funds AAA 70,596 $ - $ - $ AA+ 1,173,290 - - AA 460,921 - - AA - 269,552 - - AA1 26,056 - - AA2 101,831 - - AA3 104,513 - - A+ 189,924 - - A 317,025 25,545 - A- 73,359 90,687 - A1 239,580 - - A2 47,764 - - BBB+ - 41,318 - BBB 166,182 136,626 - Unrated 121,131 - 95,937 Low - - 1,238,358 Below Average - - 1,618,302 Average - - 1,131,958 Above Average - - 1,357,843 High - - 1,070,354 Totals 3,361,724 $ 294,176 $ 6,512,752 $ Discretely Presented Component Unit: Investment Less More Type Than 1 1-2 Than 2 Government sponsored enterprises 153,833 $ 264,500 $ 2,943,391 $ Corporate bonds 66,181 123,222 104,773 Corporate stock 13,519,913 - - U.S. Treasuries and securities - - 197,064 Mutual funds 6,512,752 - - Totals 20,252,679 $ 387,722 $ 3,245,228 $ Investment Maturities (in Years) 47 ---PAGE BREAK--- 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 has an investment policy statement (IPS) in place that provides a framework for the implementation and oversight of the Foundation’s investment strategy. These guidelines set forth what is viewed as the best strategy to successfully accomplish the Foundation’s investment objective, with the least amount of risk taken. The IPS is specific enough to be meaningful, though flexible for the Foundation to invest through different market environments. Although not specifically stated within the IPS, it is best practice that there is no more than 5% invested in one company, no more than 20% invested in any one industry/market sector, proper diversification between U.S. and international equities, and that investment in high yield and unrated bonds should be no higher than 10% of the entire portfolio. These guidelines are continually monitored by the investment committee of the Allen County Public Library Foundation. In the event were one of these to occur within the Foundation’s investment portfolio, proper action would be implemented to resolve the matter. Foreign Currency Risk Foreign currency risk relates to adverse effects on the fair value of an investment from changes in exchange rates. The Investment Policy Statement includes a formal policy regarding 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 $218,079. 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 fair valuation methodology are unadjusted quoted prices for identical assets or liabilities in active markets that the component unit can access. Level 2 – Inputs to the fair 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. 48 ---PAGE BREAK--- 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, 2021: B. Capital Assets Capital asset activity for the year ended December 31, 2021, was as follows: Beginning Ending Primary Government: Balance Increases Decreases Balance Governmental activities: Capital assets, not being depreciated: Land 11,460,817 $ 583,817 $ 1,061,558 $ 10,983,076 $ Construction in progress 23,935,796 7,723,968 13,475,357 18,184,407 Total capital assets, not being depreciated 35,396,613 8,307,785 14,536,915 29,167,483 Capital assets, being depreciated: Buildings 129,036,672 2,205,184 - 131,241,856 Improvements other than buildings 3,403,709 380,552 - 3,784,261 Machinery and equipment 48,951,089 4,747,764 10,001,320 43,697,533 Infrastructure being depreciated 325,016,947 46,982,363 1,319,313 370,679,997 Intangible assets 544,418 - - 544,418 Net investment in joint venture 6,040,525 102,106 - 6,142,631 Totals 512,993,360 54,417,969 11,320,633 556,090,696 Less accumulated depreciation for: Buildings 54,527,206 2,047,578 - 56,574,784 Improvements other than buildings 3,240,929 19,022 - 3,259,951 Machinery and equipment 38,782,583 3,276,644 9,805,885 32,253,342 Infrastructure being depreciated 106,583,563 7,185,093 837,940 112,930,716 Intangible assets 254,702 36,295 - 290,997 Net investment in joint venture 3,351,437 153,565 - 3,505,002 Totals 206,740,420 12,718,197 10,643,825 208,814,792 Total capital assets, being depreciated, net 306,252,940 41,699,772 676,808 347,275,904 Total governmental activities capital assets, net 341,649,553 $ 50,007,557 $ 15,213,723 $ 376,443,387 $ Business-type activities: Capital assets, not being depreciated: Land 380,487 $ - $ - $ 380,487 $ Construction in progress 551,079 1,058,203 1,178,714 430,568 Total capital assets, not being depreciated 931,566 1,058,203 1,178,714 811,055 Discretely Presented Component Unit: Investment Type Fair Value Level 1 Level 2 Level 3 Government sponsored enterprise 3,361,724 $ - $ 3,361,724 $ - $ Corporate bonds 294,176 - 294,176 - Corporate stock 13,519,913 13,519,913 - - U.S treasuries & securities 197,064 - 197,064 Mutual funds 6,512,752 6,512,752 - - Beneficial interest 20,002 - - 20,002 Totals 23,905,631 $ 20,032,665 $ 3,852,964 $ 20,002 $ 49 ---PAGE BREAK--- Depreciation expense was charged to functions/programs of the primary government as follows: Capital assets, being depreciated: Land improvements 1,440,208 - - 1,440,208 Buildings 106,082,794 26,675 - 106,109,469 Improvements other than buildings 9,573,749 1,178,715 - 10,752,464 Machinery and equipment 9,700,469 230,048 124,007 9,806,510 Totals 126,797,220 1,435,438 124,007 128,108,651 Less accumulated depreciation for: Land improvements 1,436,008 300 - 1,436,308 Buildings 53,456,892 2,842,209 - 56,299,101 Improvements other than buildings 5,831,626 487,094 - 6,318,720 Machinery and equipment 6,497,840 678,599 47,691 7,128,748 Totals 67,222,366 4,008,202 47,691 71,182,877 Total capital assets, being depreciated, net 59,574,854 (2,572,764) 76,316 56,925,774 Total business-type activities capital assets, net 60,506,420 $ (1,514,561) $ 1,255,030 $ 57,736,829 $ 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 989,537 - 1,624,409 Machinery and equipment 5,849,920 253,267 1,447,906 4,655,281 Library materials 7,261,344 2,631,307 2,404,066 7,488,585 Totals 104,271,520 3,874,111 3,851,972 104,293,659 Less accumulated depreciation for: Buildings and improvements 39,183,566 2,082,792 - 41,266,358 Improvements other than buildings 443,446 78,615 - 522,061 Machinery and equipment 5,536,945 185,267 1,447,906 4,274,306 Library materials 2,453,827 2,420,448 2,404,066 2,470,209 Totals 47,617,784 4,767,122 3,851,972 48,532,934 Total capital assets, being depreciated, net 56,653,736 (893,011) - 55,760,725 Total discretely presented component unit capital assets, net 62,608,705 $ (893,011) $ - $ 61,715,694 $ Governmental activities: General government 965,511 $ Public safety 3,231,497 Highways and streets 8,301,303 Health and welfare 126,196 Sanitation 21,356 Culture and recreation 72,334 Total depreciation expense - governmental activities 12,718,197 $ 50 ---PAGE BREAK--- C. Interfund Balances and Activity 1. Interfund Receivables and Payables The composition of interfund balances as of December 31, 2021, 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, 2021, were as follows: The primary government typically uses transfers to fund ongoing operating subsidies and internal financing for capital related expenditures. 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: Balance Interest December 31, Current Net Purpose Rates 2021 Portion Premium Noncurrent Business-type activities: 2011 B War Memorial Coliseum additions first mortgage refunding revenue bonds 3.6% to 5.45% 1,750,000 $ 405,000 $ 2,441 $ 1,347,441 $ 2016 A War Memorial Coliseum additions refunding first mortgage revenue bonds 2.00% to 4.00% 6,990,000 1,695,000 723,393 6,018,393 2014 War Memorial Coliseum Convention Center Expansion first mortgage bonds 2% to 5.0% 11,460,000 685,000 537,843 11,312,843 Total business-type activities 20,200,000 $ 2,785,000 $ 1,263,677 $ 18,678,677 $ Business-type activities: Coliseum 4,008,202 $ General Local Income Tax Non-major Interfund Payables Fund Economic Development Governmental Total Local Income Tax-Economic Development 1,521,528 $ - $ 106,718 $ 1,628,246 $ Non-major governmental 158,355 7,868,599 - 8,026,954 Totals 1,679,883 $ 7,868,599 $ 106,718 $ 9,655,200 $ Interfund Receivables Local Income Tax - Economic Non-major Transfer From General Development Governmental Totals County General - $ - $ 197,500 $ 197,500 $ Local Income Tax - Economic Development 47,444 - 785,563 833,007 Non-major Governmental 497,485 446,705 41,000 985,190 Totals 544,929 $ 446,705 $ 1,024,063 $ 2,015,697 $ 51 ---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: 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: Balance Unamortized Net Interest December 31, Premium Balance at Purpose Rates 2021 (Discount) December 31 2016 Allen County Public Library first mortgage refunding bonds 2% to 3% 2,330,000 $ (13,822) $ 2,316,178 $ Year Ended December 31 Principal Interest 2022 2,785,000 $ 798,656 $ 2023 2,895,000 674,149 2024 2,990,000 543,614 2025 3,030,000 411,028 2026 825,000 308,994 2027-2031 4,535,000 1,128,231 2032-2035 3,140,000 255,594 Totals 20,200,000 $ 4,120,266 $ Business-Type Activities Balance Interest December 31, Current Net Purpose Rates 2021 Portion Premium Noncurrent Allen County Tax Increment Revenue Bonds (General Motors) Series 2015 C 3.0% to 4.0% 1,980,000 $ 80,000 $ 7,963 $ 1,907,963 $ 2016 Maplecrest Road Bridge Bond 3.0% to 5.0% 12,505,000 1,305,000 1,557,913 12,757,913 Total governmental activities 14,485,000 $ 1,385,000 $ 1,565,876 $ 14,665,876 $ Year Ended December 31 Principal Interest 2021 2,330,000 $ 12,582 $ Component Unit Discretely Presented 52 ---PAGE BREAK--- Revenue bonds debt service requirements to maturity are as follows: 3. Changes in Long-Term Liabilities Long-term liability activity for the year ended December 31, 2021, 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. Beginning Ending Due Within Primary Government Balance Additions Reductions Balance One Year Governmental activities: Bonds payable: Revenues 15,790,000 $ - $ 1,305,000 $ 14,485,000 $ 1,385,000 $ Compensated absences 4,456,765 4,356,523 4,456,765 4,356,523 4,356,523 Other postemployment benefits liability 15,170,826 - 226,887 14,943,939 - Net Pension Liability 32,490,684 - 18,468,932 14,021,752 - Total governmental activities long-term liabilities 67,908,275 $ 4,356,523 $ 24,457,584 $ 47,807,214 $ 5,741,523 $ Business-type activities: First mortgage revenue bonds payable: Coliseum 22,870,000 $ - $ 2,670,000 $ 20,200,000 $ 2,785,000 $ Compensated absences 152,449 148,029 152,449 148,029 148,029 Total business-type activities long-term liabilities 23,022,449 $ 148,029 $ 2,822,449 $ 20,348,029 $ 2,933,029 $ Beginning Ending Due Within Discretely Presented Component Unit: Balance Additions Reductions Balance One Year First mortgage general obligation bonds 7,645,000 $ - $ 5,315,000 $ 2,330,000 $ 2,330,000 $ Compensated absences 891,185 847,244 927,911 810,518 135,073 Net Pension Liability 5,790,398 1,903,712 5,226,501 2,467,609 - Total discretely presented component unit 14,326,583 $ 2,750,956 $ 11,469,412 $ 5,608,127 $ 2,465,073 $ Principal Interest 2022 1,385,000 $ 608,069 $ 2023 1,455,000 551,969 2024 1,520,000 493,169 2025 1,600,000 431,569 2026 1,680,000 370,844 2027-2031 5,765,000 741,433 2032-2036 590,000 164,900 2037-2040 490,000 40,200 Totals 14,485,000 $ 3,402,153 $ Governmental Activities 53 ---PAGE BREAK--- E. Restricted Assets The balances of restricted asset accounts in the enterprise funds are as follows: F. Restatements and Reclassifications In prior years all special revenue funds were reported separately in the Combining Balance Sheet – Non-Major Governmental Funds and the Combining Statement of Revenues, Expenditures, and Changes in Fund Balances; however, they should be combined with the General fund. GASB Cod. 1300.105 states, “Governments should discontinue reporting a special revenue fund, and instead report the fund’s remaining resources in the general fund, if the government no longer expects that a substantial portion of the inflows will derive from restricted or committed revenue sources.” The following schedule presents a summary of the restated General fund balance: Coliseum ticket office fund 1,640,121 $ Coliseum advance customer deposits 312,186 Food and beverage supplemental tax fund 6,961,241 Sports and convention fund 1,488,124 Total restricted assets 10,401,672 $ Governmental Funds General Fund balance, previously reported at December 31, 2020 52,947,025 $ Prior period adjustment for combination with General fund: Rainy Day fund 17,971,276 $ Redevelopment Commission 98,890 Hazardous Waste 3,028,996 Economic Development 328,003 Drug Task Force - Stormwater Study 66,676 Internet Access 134,789 Prisoner Reimbursement 11,461 Mobile Command Unit 12,918 Sheriff Civil Action Suit 114,040 St. Joseph Foundation Lead Program 7,759 Supplemental Education 981 AC Onsite Wastewater Management 183 Truancy Reduction 8,786 Sheriff Foundation Grants 80 Allen County Courts Family Court Grant 18,427 2016 LIT Special Dist 25% 1,268,087 Courtools Court Reform Grant 3,362 54 ---PAGE BREAK--- Highway infrastructure changes require a prior period adjustment to the December 31, 2020 Net Position of Governmental Activities. The following schedule presents a summary of the restated Net Position. 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; 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 from the money or funds collected on behalf of the County arising from automobile insurance. The funding level for 2021 was $305,114. There were no incurred but not reported claims at December 31, 2021. The cash and cash equivalents at December 31, 2021, were $797,558. 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 Net Position Net Position as reported Prior Period as restated December 31, 2020 Adjustment January 1, 2021 484,928,874 $ Governmental activities: Infrastructure changes (87,693,942) Infrastructure depreciation changes 46,248,774 443,483,706 $ Court Call Fee Fund 115 Allen County Revolving Loan Fund 457,900 Prosc IV-D Incentive Prior to 10/99 98,712 Clinic Donation 11,413 General Fund balance, restated at January 1, 2021 76,589,879 $ 55 ---PAGE BREAK--- level for 2021 was $298,110. Incurred but not reported claims have not been accrued as a liability as of December 31, 2021. The cash and cash equivalents at December 31, 2021, were $55,230. 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 2021 was $11,469,541. The cash and cash equivalents at December 31, 2021, were $3,501,070. 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: 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 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 2021. 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 2021 was $1,299,500. There were no incurred but not reported claims at December 31, 2021. The cash and cash equivalents at December 31, 2021, were $111,949. 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 2020 2021 Unpaid claims, beginning of fiscal year 2,853,850 $ 2,635,340 $ Incurred claims and changes in estimates 13,429,995 13,347,951 Claim payments 13,648,505 13,641,319 Unpaid claims, end of fiscal year 2,635,340 $ 2,341,972 $ 56 ---PAGE BREAK--- 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, 2021, there were three series of Industrial Revenue Bonds outstanding with an aggregate principal amount payable of $57,470,000. D. 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. E. Tax Incremental Revenue Bonds and Loans 1. Infrastructure for General Motors Facility Allen County has pledged future tax increment finance revenues to repay revenue bonds issued in 2015. Proceeds from the bonds 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. The bonds are primarily payable from the incremental property tax revenues of the I-469 Bluffton Rd TIF allocation area with a secondary pledge from LIT economic development and are payable through 2040. Annual principal and interest payments on the bonds are expected to require 1.13% of the combined gross revenues. The total principal and interest remaining to be paid on the bonds is $1,980,000. Principal and interest paid for the current year and total gross revenues were $148,769 and $13,184,825, respectively. 2. Infrastructure for Stonebridge Business Park Allen County has pledged future tax increment finance revenues to repay an interfund loan issued in 2014. Proceeds from the loan provided certain public infrastructure improvements for the construction of the Stonebridge Business Park. The loan is primarily payable from the incremental property tax revenues of the Group Delphi TIF allocation area and are payable until debt is extinguished. Annual principal and interest payments on the loan is expected to require 60-100% of the gross revenue. The total principal and interest remaining to be paid on the loan is $4,669,462. Principal and interest paid for the current year and total gross revenues were $50,000 and $80,956, respectively. 3. Infrastructure for Diebold Road Project Allen County has pledged future tax increment finance revenues to repay an interfund loan issued in 2016. Proceeds from the loan provided certain public infrastructure improvements, along with the City of Fort Wayne, under a reimbursement agreement and inter-local agreement for the reconstruction of a portion of Diebold Road. The loan is primarily payable from the incremental property tax revenues of the Dupont Corner TIF allocation area, and are payable through 2041. Annual principal and interest payments on the loan is expected to require 30- 100% of the gross revenue. The total principal and interest remaining to be paid on the loan is $959,494. Principal and interest paid for the current year and total gross revenues were $80,000 and $245,307, respectively. 57 ---PAGE BREAK--- 4. Infrastructure for Kroemer Road Project Allen County has pledged future tax increment finance revenues to repay an interfund loan issued in 2013. Proceeds from the loan provided certain public infrastructure improvements for the reconstruction of a portion of Kroemer Road. The loan is primarily payable from the incremental property tax revenues of the Great Batch TIF allocation area and are payable until debt is extinguished. Annual principal and interest payments on the loan is expected to require 30-100% of the gross revenue. The total principal and interest remaining to be paid on the loan is $79,820. Principal and interest paid for the current year and total gross revenues were $79,820 and $205,301, respectively. 5. Infrastructure for Ryan Road Project Allen County has pledged future tax increment finance revenues to repay an interfund loan issued in 2020. Proceeds from the loan provided certain public infrastructure improvements for the reconstruction of a portion of Ryan Road. The loan is primarily payable from the incremental property tax revenues of the Bandalier and Casad East TIF allocation areas and are payable until debt is extinguished. Annual principal and interest payments on the loan is expected to require 30-100% of the gross revenue. The total principal and interest remaining to be paid on the loan is $2,159,823. Principal and interest paid for the current year and total gross revenues were $1,740,000 and respectively. 6. Infrastructure for Union Chapel Road Project Allen County has pledged future tax increment finance revenues to repay a bond issued in 2021. Proceeds from the bonds provided certain public infrastructure improvements for a roundabout on Union Chapel Road at the intersection of Parkview Plaza Dr, together with the necessary approach and exit lanes, and the acquisition of land or rights of way or other property needed to construct the same. The bonds are primarily payable from the incremental property tax revenues of the Dupont Diebold TIF allocation areas and are payable until debt is extinguished. Annual principal and interest payments on the bonds are expected to require 30-100% of the gross revenue. The total principal and interest remaining to be paid on the bonds is $2,541,000. Principal and interest paid for the current year and total gross revenues were $0 and $507,730 respectively. 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 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 2021 was $148,769; GM TIF requirements may be allocated from the Local Income Tax-Economic Development (formerly CEDIT) towards the debt service payments. F. 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, 2021, 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 58 ---PAGE BREAK--- 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 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 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 above mentioned 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, 2021: The County abated property tax revenues totaling $3,366,000 for year ended December 31, 2021 including the following tax abatements that each exceeded 10% of the total County amount abated: Approximately $2,542,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. County tax revenue reductions due to abatements granted by Cities and Towns: Amount of County Tax Tax Abatement Category Revenues Abated Redevelopment or Rehabilitation of real estate property 1,212,000 $ Business personal property equipment investment 2,154,000 Total 3,366,000 $ 59 ---PAGE BREAK--- 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 $3.4 million noted above County property tax revenues were also reduced $1,678,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, 2021, there are approximately 124 recipients in Allen County with Active IEDC contracts for which almost $61,019,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, 2021, 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 $177 million of local income tax revenue was received and allocated to Allen County taxing units during 2021 alone. If you take the $61,019,000 in credits received and divide evenly amongst the average Active Term contract length of 4.1 years, the credit is $14,883,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 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 County paid recipient’s $521,000 during 2021 for achieving goals outlined in the Ledge and TIF agreements. Amount of County City/Town Tax Revenues Abated Fort Wayne 1,350,000 $ New Haven 212,000 Woodburn 88,000 Monroeville 2,000 Huntertown 5,000 Leo-Cedarville 1,000 Grabill 20,000 Total 1,678,000 $ 60 ---PAGE BREAK--- 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 2021. The table below summarizes the taxes that have been abated. G. 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. Full-time and part-time employees who work at least 30 hours per week are eligible for retiree health care coverage until Medicare eligibility (age 65). Both civilians and sworn officers are eligible for retiree health care coverage once they attain age 50 with 15 years of service. Indiana Code 5-10-8 assigns the authority to establish and amend benefit provisions to the County. Early retirement incentive eligibility is only open to employees who were hired before July 1, 2010. Full-time sworn officers are eligible for the early retirement incentive benefit once they attain age 55 with 20 years of service. Full-time civilians are eligible for the early retirement incentive benefit at the earlier of: Age 55 and rule 85; or Age 60 with 15 years of service. Part-time civilians working at least 30 hours per week are not eligible for the early retirement incentive benefit. At December 31, 2021, Plan membership consisted of the following: Benefits Provided The longevity benefit is the minimum of 100% of salary at retirement or 1% of the base salary at retirement multiplied by years of service. The County explicitly subsidizes retiree health care coverage the early retirement incentive program. Sworn officers who do not elect retiree health care coverage through the County are paid Inactive plan members or beneficiaries currently receiving benefits 23 Inactive plan members or beneficiaries entitled to but not yet receiving benefits 25 Active plan members 1,287 Total 1,335 Real Personal Total Governmental Unit Property Tax Property Tax Abated Allen County 396,810 $ 705,514 $ 1,102,324 $ Fort Wayne 272,446 169,596 442,042 Grabill 1,922 4,574 6,496 Huntertown 936 837 1,773 Leo-Cedarville 117 - 117 Monroeville 462 183 645 New Haven 24,499 44,982 69,481 Woodburn 23,622 5,297 28,919 Total 720,814 $ 930,983 $ 1,651,797 $ No amounts have been received and no amounts are receivable from other governments in association with the forgone tax revenue. 61 ---PAGE BREAK--- 70% of longevity benefit for 10 years or to age 65, whichever occurs first. Sworn officers who elect retiree health care coverage through the County are paid 50% of longevity benefit, which is used to reduce health care premiums, for 10 years or to age 65, whichever occurs first. Any excess of the 50% of longevity benefit over premiums is paid to the retired sworn officers. Civilians who do not elect retiree health care coverage through the County are paid $350 per month for 10 years or age 65, whichever occurs first. Civilians who elect retiree health care coverage through the County are paid $150 per month, which is used to reduce health care premiums, for 10 years or to age 65, whichever occurs first. Retirees are responsible for the portion of premium rates not covered by the County’s explicit subsidy. Retiree health care coverage continues to the surviving spouse of retirees if they pay the required premium. The early retirement incentive benefit is terminated upon retiree’s death. All employees must enroll in the same retiree plan at retirement although there are three benefit options available to active employees. All health plans are self-insured. Contributions 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. There are no assets in a trust. For the year ended December 31, 2021, the County contributed $475,347 to the plan. Net OPEB liability of the plan As of December 31, 2021, the most recent actuarial valuation date, the plan was unfunded. The components of the net OPEB liability of the Plan at December 31, 2021 were as follows: OPEB Expense of the Plan OPEB expense of $1,197,536 must be recognized for the fiscal year ending December 31, 2021. Significant Actuarial Assumptions Total OPEB liability 14,943,939 $ Plan fiduciary net position - Plan's net OPEB liability 14,943,939 $ Plan fiduciary net position as a percentage of the total OPEB liability 0.00% Measurement Date December 31, 2021 Actuarial Valuation Date January 1, 2021 with results actuarially projected on a "no gain/no loss" basis to get to the December 31, 2021 measurement date. Liabilities as of January 1, 2021 are based on an actuarial date of January 1, 2021 with no adjustments. Inflation Rate 2.25% per year 62 ---PAGE BREAK--- Discount Rate Under GASB 75, the discount rate used in valuing OPEB liabilities for unfunded plans as of the Measurement Date must be based on a yield for 20-year tax-exempt general obligation municipal bonds with an average rating of AA/Aa or higher (or equivalent quality on another rating scale). For the current valuation, the discount rate was selected from the range of indices as shown in the table below, where the range is given in the spread between the lowest and highest rate shown. Healthcare cost trend rate The initial trend rate was based on a combination of employer history, national trend surveys, and professional judgement. The ultimate trend rate was selected based on historical medical CPI information. Salary Changes Payroll growth rates for Civilians including general wage inflation of 2.75% (includes 2.25% general inflation plus 0.50% real wage inflation) plus merit/productivity increases as shown below are based on the most recent Indiana Public Retirement System Public Employees' Retirement Fund actuarial valuation as of June 30, 2020. The payroll growth rate for Sworn Officers is 2.75% following general wage inflation based on the most recent Indiana Retirement System 1977 Police Officers' and Firefighters' Retirement Fund actuarial valuation as of June 30, 2020. Mortality Assumption Civilians: SOA Pub-2010 General Headcount Weighted Mortality Table fully generational using Scale MP-2020 Sworn Officers: SOA Pub-2010 Public Safety Headcount Weighted Mortality Table fully generational using Scale MP-2020 Surviving Spouses: SOA Pub-2010 Continuing Survivor Headcount Weighted Mortality Table fully generational using Scale MP-2020 Experience Study Best actuarial practices call for a periodic assumption review and Nyhart recommends the County complete an actuarial assumption review (also referred to as an experience study) before the next full valuation for the fiscal year ending December 31, 2022. The actuarial assumptions have not been updated since at least the fiscal year ending December 31, 2007 valuation. YOS General 0 6.00% 1 5.00% 3 3.00% 5 2.00% 7 1.50% 10 0.75% 13+ 0.00% FYE Medical/Rx FYE Medical/Rx 2022 7.5% 2026 5.5% 2023 7.0% 2027 5.0% 2024 6.5% 2028+ 4.5% 2025 6.0% 63 ---PAGE BREAK--- Changes in the total OPEB liability Sensitivity of the Net OPEB Liability to Changes in the Discount Rate and Healthcare Rate The following presents the net OPEB liability as of December 31, 2021, calculated using the discount rate assumed of 2.25% and what it would be using a 1% higher (3.25%) and 1% lower (1.25%) discount rate. The following resents the net OPEB liability as of December 31, 2021, using the health care trend rates assumed and what it would be using 1% higher and 1% lower health care trend rates. Deferred Outflows of Resources and Deferred Inflows of Resources Related to OPEB Deferred Outflows/(Inflows) of Resources represents the following items that have not been recognized in the OPEB expense: Differences between expected and actual experience of the OPEB plan; Changes of assumptions; Differences between projected and actual earnings in OPEB plan investments (for funded plans only). The initial amortization period for the first two items noted above is based on expected future service lives while the difference between the projected and actual earnings in OPEB plan investment is amortized over five years. All balances are amortized linearly on a principal only basis and new bases will be created annually for each of the items above. Bond Buyer GO 20-Year S&P Municipal Bond 20-Year Fidelity 20-Year GO Bond Index Actual Discount Bond Municipal Bond Index High Grade Rate Index Municipal Bond Index Range Rate Used Yield as of January 1, 2021 2.12% 1.93% 2.00% 1.93% - 2.12% 2.12% Yield as of December 31, 2021 2.05% 2.25% 1.84% 1.84% - 2.25% 2.25% Total OPEB Liability Balance at December 31, 2020 15,170,826 $ Changes for the year: Service cost 488,952 Interest 326,975 Change of benefit terms - Changes in assumptions (166,682) Differences between expected and actual experience (400,785) Benefit payments (475,347) Net Changes (226,887) Balance at December 31, 2021 14,943,939 $ Current 1% Decrease Discount Rate 1% Increase (1.25%) (2.25%) (3.25%) Net OPEB Liability 16,276,699 $ 14,943,939 $ 13,726,726 $ Current Health 1% Decrease Care Trend Rate 1% Increase Net OPEB Liability 14,044,660 $ 14,943,939 $ 16,000,523 $ 64 ---PAGE BREAK--- The balances as of December 31, 2021 of the deferred outflows/(inflows) of resources will be recognized in OPEB expense in the future fiscal years as noted below. H. Revenues Pledged Governmental Activities Revenues Pledged Allen County has pledged future County Major Bridge property tax revenues and wheel and sur tax revenues, to repay revenue bonds issued in 2009. Proceeds from the bonds provided financing for Maplecrest Road Bridge. The bonds are primarily payable from the County Major Bridge property tax levy with a secondary pledge from wheel and sur tax revenues and are payable through 2032. Annual principal and interest payments on the bonds are expected to require 29.3 percent of the combined gross revenues. The total principal and interest remaining to be paid on the bonds is $14,062,913. Principal and interest paid for the current year and total gross revenues were $1,817,000 and $6,207,878, respectively. 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 professional sports and convention development area (PSCDA) and supplemental food and beverage tax (F&B) revenues and are payable through 2034. Annual principal and interest Initial Annual December 31, 2021 Initial Balance Amortization Period Recognition Unamortized Balance Differences between expected and actual experience for FYE: Base for year ending December 31, 2018 (25,540) $ 7 (3,649) $ (10,944) $ Base for year ending December 31, 2019 (389,678) 7 (55,668) (222,674) Base for year ending December 31, 2020 1,839,933 7 262,848 1,314,237 Base for year ending December 31, 2021 (400,785) 7 (57,255) (343,530) Changes in assumptions for FYE: Base for year ending December 31, 2018 (990,452) 7 (141,493) (424,480) Base for year ending December 31, 2019 778,441 7 111,206 444,823 Base for year ending December 31, 2020 2,026,022 7 289,432 1,447,158 Base for year ending December 31, 2021 (166,682) 7 (23,812) (142,870) Net Difference between projected and actual earnings in OPEB plan investments for FYE: Base for year ending December 31, 2018 - N/A - - Base for year ending December 31, 2019 - N/A - - Base for year ending December 31, 2020 - N/A - - Base for year ending December 31, 2021 - N/A - - 381,609 $ 2,061,720 $ Fiscal Year End Amortization Dec. 31, 2022 381,609 $ Dec. 31, 2023 381,609 Dec. 31, 2024 381,611 Dec. 31, 2025 526,748 Dec. 31, 2026 471,208 Thereafter (81,065) Total 2,061,720 $ 65 ---PAGE BREAK--- payments are expected to require less than 30.7 percent of net revenues. The total principal and interest remaining to be paid on the bonds is $21,463,677. Principal and interest paid for the current year and total gross revenues were $3,590,441 and $11,693,802, respectively. I. 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. J. 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, 5-10.3, 5-10.5, 35 IAC 1.2) 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 Public Employees’ Hybrid Plan (PERF Hybrid) consists of two components: PERF Defined Benefit plan, the employer-funded defined benefit component, and the Public Employees’ Hybrid Members Defined Contribution Account, the defined contribution component. Members’ contributions are set by the state statute at 3 percent of compensation for the defined contribution component of PERF Hybrid. The employer may elect to make the contribution on behalf of the member of the defined contribution component of the PERF Hybrid. Contributions to the PERF DB are determined by INPRS Board based on actuarial valuation 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 contribution account. Pension benefits vest after 10 years of creditable service. Members are immediately vested in their contribution account. At retirement, a member may choose to receive a lump sum payment of 66 ---PAGE BREAK--- the amount credited to the member’s contribution 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. PERF members are required to contribute 3 percent of their annual covered salary. For 2021, 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, 2021 was $5,565,715 and was equal to the required contribution for 2021. For 2021, the Allen County Public Library (discretely presented component unit) has elected to make the employee required 3 percent contribution on behalf of their employee members and 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, 2021 was $1,156,785. Actuarial Assumptions There were changes in assumptions for the June 30, 2021 actuarial valuation. The actuarial assumptions used in the June 30, 2021 valuation of the Public Employee’s Retirement Fund were adopted by the INPRS Board in May 2021. The total pension liability in the June 30, 2021 actuarial valuation was determined using the following actuarial assumptions, applied to all periods included in the measurement: 67 ---PAGE BREAK--- Changes in assumptions: Price inflation was lowered from 2.25 percent per year to 2.00 percent per year. The investment return assumption was lowered from 6.75 percent to 6.25 percent. The future salary increase assumption was changed from 2.75 percent per year to 2.65 percent per year. Future salary increase rates are now in a service-based table ranging from 2.65 percent to 8.65 percent per year. Cost of Living adjustment, as a result of legislation, a 1.0 percent cost-of-living adjustment will be paid as of January 1, 2022. Thereafter, the following COLAs, compounded annually, are assumed: 0.4 percent beginning on January 1, 2024, 0.5 percent beginning on January 1, 2034, and 0.6 percent on January 1, 2039. 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. In order to determine the expected long-term nominal rate of return, the asset class geometric real returns are projected for a 30-year time horizon. These returns are combined with a projected covariance matrix and the target asset allocations to create a range of expected long-term real rates of return for the portfolio. A range of possible expected long- term rates of return is created by adding the forecasted inflation to the expected long-term real rates of return and adding an expected contribution to the return due to manager selection. This range ultimately supports the long-term expected rate of return assumption of 6.25% selected by the Board as the discount rate. The assumption is a long-term assumption and is not expected to change with small fluctuations in the underlying inputs but may change with a fundamental shift in the underlying market factors or significant asset allocation change. Discount Rate The discount rate used to measure the total pension liability was 6.25 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.25 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. Inflation 2.00% Salary Increases 2.65% to 8.65% Cost-of-living increases 1.00% Long Term Target Expected Real Allocation Rate of Return Public Equity 20.0% 3.6% Private Equity 15.0 7.3 Fixed Income - Ex Inflation Linked 20.0 1.5 Fixed Income - Inflation Linked 15.0 (0.3) Commodities 10.0 0.8 Real Estate 10.0 4.2 Absolute Return 5.0 2.5 Risk Parity 20.0 4.4 Leverage Offset (15.0) (1.4) Total 100.0 68 ---PAGE BREAK--- 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.25 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.25 percent) or 1- percentage point higher (7.25 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, 2021, the primary government recorded a pension liability of $11,987,241 for their proportionate share of the net pension liability. The net pension liability was measured as of June 30, 2021, 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, 2021, the primary government’s proportion was .91099 percent, which was a decrease of .00406 from its proportion measured as of June 30, 2020. As of December 31, 2021, the Allen County Public Library (discretely presented component unit) reported a liability of $2,467,609 for their proportionate share of the net pension liability. The net pension liability was measured as of June 30, 2021, and the total pension liability used to calculate the net pension liability was determined by an actuarial valuation as of that date. The Library’s proportionate share of the net pension liability was based on wages reported by employers relative to the collective wages of the plan. At June 20, 2021 the Library’s portion was .18753 percent, which was a decrease of .00418 percent from its proportion measured as of June 30, 2020. For the year ended June 30, 2021, the primary government recognized pension income of $2,247,302. At June 30, 2021, 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.25%) (6.25%) (7.25%) County's proportionate share of the net pension liability 31,351,891 $ 11,987,241 $ (4,165,440) $ Current 1% Decrease Discount Rate 1% Increase (5.25%) (6.25%) (7.25%) Library's proportionate share of the net pension liability 6,453,880 $ 2,467,609 $ (857,468) $ Deferred Outflows Deferred Inflows of Resources of Resources Differences between expected and actual experience 409,998 $ 239,350 $ Net difference between projected and actual investment earnings on pension plan investments - 15,564,337 Change of assumptions 6,029,661 2,692,561 Changes in proportion and differences between employer contributions and proportionate share of contributions 13,190 1,043,988 Employer contributions subsequent to the measurement date 2,968,618 - Total 9,421,467 $ 19,540,236 $ 69 ---PAGE BREAK--- The primary government reported $2,968,618 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, 2022. 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, 2021, the Allen County Public Library (discretely presented component unit) recognized pension expense of $322,986. At June 30, 2021, 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 $571,912 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, 2022. Other amounts reported as deferred outflows of resources and deferred inflows of resources related to pensions will be recognized in pension expense as follows: 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 Year Ended June 30 2022 (3,934,573) $ 2023 (3,008,781) 2024 (1,694,995) 2025 (4,449,038) 2026 - Thereafter - Total (13,087,387) $ Year Ended June 30 2022 (756,057) $ 2023 (614,922) 2024 (374,413) 2025 (915,849) 2026 - Thereafter - Total (2,661,241) $ Deferred Outflows Deferred Inflows of Resources of Resources Differences between expected and actual experience 84,399 $ 49,271 $ Net difference between projected and actual investment investment earnings on pension plan investments - 3,203,965 Change of assumptions 1,241,224 554,272 Changes in proportion and differences between employer contributions and proportionate share of contributions - 179,356 Employer contributions subsequent to the measurement date 571,912 1,897,535 $ 3,986,864 $ 70 ---PAGE BREAK--- 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 Public Equity investments are comprised of domestic and international stocks as well as commingled equity instruments. Equity securities traded on a national or international exchange are valued at the official closing price or last reported sales price of the instrument. International equities are then adjusted to reflect the exchange rate as of June 30, 2021 of the underlying currency. Commingled equities are not traded on a national security exchange and are valued at the net asset value of the units held at June 30, 2021, based on the fair value of the underlying securities. Private Market 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 manager on a quarterly or semi-annual basis. Investments in private markets are generally considered illiquid long-term investments. Due to the inherent uncertainty that exists in the valuation of alternative investments, the realized value upon sale of an asset may differ significantly from the fair value. Fixed Income securities are comprised of U.S. Government, U.S. government-sponsored agencies, publicly traded debt and commingled debt instruments. Securities traded on national and international exchanges are valued based on published market prices and quotations. Securities that are not traded on a national security exchange are valued using a matrix pricing approach. Commingled securities are valued at the net asset value of the units held as of June 30, 2021 based on the fair value of the securities. Commodities, including derivative instruments, are reported at fair value and involve, to varying degrees, elements of market risk to the extent of future market movements in excess of amounts recognized in the Financial Statements. Derivative instruments are considered investments and not hedges for accounting purposes. The fair value of all derivative financial instruments is reported in the Statement of Fiduciary Net Position. The change in the fair value is recorded in the Statement of Changes in Fiduciary Net Position as Net Investment Income (Loss). Gains and losses arising from this activity are recognized in the Statement of Changes in Fiduciary Net Position as incurred. Real Estate, Absolute Return and Risk Parity investments are valued by the manager or independent appraiser based on reported net asset values, cash flow analysis, purchases and sales of similar investments, new financings, economic conditions, other practices used within the industry, or other information provided by the underlying investment advisors. Due to the inherent uncertainty in privately held securities, the fair value may differ from the values that would have been used if a ready market for such securities existed, and the differences can be material. INPRS relies on third party resources to verify the methodology and calculation used for investment valuation and performance metric reported by the custodian. B. Single-Employer Defined Benefit Pension Plans 1. County Police Retirement Plan 71 ---PAGE BREAK--- Plan Description The Allen County Police Retirement Pension Trust 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, 2021, 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). An elected official may elect commencement of an in-service retirement benefit upon attainment of age fifty-five (55) and completion of at least thirty-two (32) years of credited service. A reduced early retirement benefit is available to members with at least twenty (20) years of credited service any time after attainment of age fifty-two (52) with a reduction factor of five- percent (5/12%) for each month by which the early retirement date precedes what would have been the normal retirement date. 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 contributions (including interest) plus the amount transferred by the member for the purchase of credited service. After completion of five years of credited 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. Inactive plan members or beneficiaries currently receiving benefits 107 Inactive plan members or beneficiaries entitled to but not yet receiving benefits 9 Active plan members 137 Total 253 72 ---PAGE BREAK--- 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 payments 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, 2021, 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 regarding 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 July 29, 2019. 73 ---PAGE BREAK--- Rate of Return For the year ended December 31, 2021, the annual money-weighted rate of return on pension plan investments, net of pension plan expense was 13.24 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 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, 2021, the balance of the amounts held by the plan pursuant to the DROP is $267,592. Net Pension Liability of the Plan The components of the net pension liability of the Plan at December 31, 2021 were as follows: Pension Expense of the Plan Pension expense of $790,900 must be recognized for the fiscal year ending December 31, 2021. Target Allocation Asset Class Percentage Domestic Large Stocks 30 Domestic Small Stocks 15 Dev. International Stocks 10 Emerging Market Stocks 5 Fixed Income-Core 35 Cash & Equivalents 5 Total 100 Total pension liability 75,210,452 $ Plan fiduciary net position (72,205,257) Plan's net pension liability 3,005,195 $ Plan fiduciary net position as a percentage of the total pension liability 96.00% 74 ---PAGE BREAK--- Significant Actuarial Assumptions Discount Rate The discount rate used to measure the total pension liability was 6.50% as of December 31, 2021 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 Measurement Date December 31, 2021 Valuation Date Assets December 31, 2021 Valuation Date Liabilities December 31, 2021 - Actual member census data as of December 31, 2021 was used in the valuation. Inflation Rate 2 3.00% per annum Future Salary Increases 3 4.00% per annum (For the purpose of GASB reporting, 3.00% increases due to inflation and 1.00% due to merit/seniority.) Expected Rate of Return on Plan Assets 3 6.50% per annum Cost of Living Increase 3 Not Applicable Mandatory Employee Contribution Credited Interest Rate 1 5.00% per annum Retirement 1 Benefits are assumed to commence at the earlier of 1) the later of age 55 and 20 years of service, or 2) attainment of age 60, but no earlier than one year from the valuation date. If later, the Sheriff is assumed to retire at the end of his four year term (but not later than attainment of eligibility for in-service retirement). DROP participants are assumed to retire at the end of their DROP Period. Termination of Employment 3 According to Sarason Table T-2 Disability 3 According to 150% of 1964 OASDI Disability Experience Table Mortality Assumption 2 Generationally with Scale MP-2021 (separate employee, retiree, contingent survivor, and disabled retiree tables and male and female tables) Line of Duty Death Assumption 1 10% of active participant deaths are assumed to occur in line of duty. Benefit Payment Form 1 100% of participants are assumed to elect a single life annuity at retirement. Marriage 3 100% of participants are assumed to be married when the participant dies Spouse Age 3 Males are assumed to be two years older than females (unless provided) Mandatory Employee Contribution 1 3.00% of compensation Administrative Expense Loading 1 Flat Loading 1 Represents an estimate of future experience 2 Represents actuary's observation of estimates inherent in market data 3 Represents both an estimate of future experience, and actuary's observation of estimates inherent in market data 75 ---PAGE BREAK--- 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 Department Pension Trust, calculated using the discount rate of 6.50%, 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.50%) or 1-percentage-point higher (7.50%) than the current rate: Deferred Outflows of Resources and Deferred Inflows of Resources Related to Pensions At December 31, 2021, the deferred outflows/(inflows) of resources based on obligations for the plan are as follows: The balances as of December 31, 2021 of the deferred outflows/(inflows) of resources will be recognized in pension expense as follows: Current 1% Decrease Discount Rate 1% Increase (5.50%) (6.50%) (7.50%) Total Pension Liability 84,127,032 $ 75,210,452 $ 67,728,418 $ Plan Fiduciary Net Position 72,205,257 72,205,257 72,205,257 Net Pension Liability 11,921,775 $ 3,005,195 $ (4,476,839) $ Initial Annual December 31, 2021 Initial Balance Amortization Period Recognition Balance Liability experience losses/(gains): Base for year ending December 31, 2021 684,732 $ 5.101 134,235 $ 550,497 $ Base for year ending December 31, 2020 (376,230) 4.916 (76,532) (223,166) Base for year ending December 31, 2019 1,585,743 5.049 314,071 643,530 Base for year ending December 31, 2018 321,820 5.216 61,699 75,024 Base for year ending December 31, 2017 1,212,624 5.157 235,141 36,919 Base for year ending December 31, 2016 227,812 5.243 10,557 - Changes in assumptions: Base for year ending December 31, 2021 2,084,006 $ 5.101 408,549 $ 1,675,457 $ Base for year ending December 31, 2020 (202,750) 4.916 (41,243) (120,264) Base for year ending December 31, 2019 786,080 5.049 155,690 319,010 Base for year ending December 31, 2018 (143,815) 5.216 (27,572) (33,527) Base for year ending December 31, 2017 819,710 5.157 158,951 24,955 Base for year ending December 31, 2016 (544,042) 5.243 (25,217) - Investment losses/(gains): Base for year ending December 31, 2021 (4,095,534) $ 5.000 (819,107) $ (3,276,427) $ Base for year ending December 31, 2020 (4,283,618) 5.000 (856,724) (2,570,170) Base for year ending December 31, 2019 (5,715,945) 5.000 (1,143,189) (2,286,378) Base for year ending December 31, 2018 5,640,467 5.000 1,128,093 1,128,095 Base for year ending December 31, 2017 (2,859,279) 5.000 (571,855) - (954,453) $ (4,056,445) $ 76 ---PAGE BREAK--- 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.101 years, the average remaining service of all members with any liability in the plan as of January 1, 2021. The change in net pension liability due to investment losses/(gains) has been amortized over 5.000 years as prescribed. Assumption changes: The changes in assumptions for base year ending December 31, 2021 reflect the change from the use of the Pub-2010 Safety Amount-Weighted Mortality Projected Generationally with Scale MP-2020 (separate employee, retiree, contingent survivor, and disabled retiree tables and male and female tables) and a discount rate of 6.75% to the Pub-2010 Safety Amount-Weighted Mortality projected Generationally with Scale MP-2021 (separate employee, retiree, contingent survivor, and disabled retiree tables and male and female tables) and a discount rate of 6.5%. The changes in assumptions for base year ending December 31, 2020 reflect the change from the use of the Pub-2010 Safety Amount-Weighted Mortality Projected Generationally with Scale MP-2019 (separate employee, retiree, contingent survivor, and disabled retiree tables and male and female tables) to the Pub-2010 Safety Amount-Weighted Mortality Projected Generationally with Scale MP-2020 (separate employee, retiree, contingent survivor, and disabled retiree tables and male and female tables). The changes in assumptions for base year ending December 31, 2019 reflect the change from the use of the RP-2014 Adjusted to 2006 Total Dataset Mortality with Two Dimensional Generational Mortality Improvement Scale MP-2018 (separate employee and annuitant tables and male and female tables) to the Pub-2010 Safety Amount Weighted Mortality Projected Generationally with Scale MP-2019 (separate employee, retiree, contingent survivor, and disabled retiree tables and male and female tables). The changes in assumptions for base year ending December 31, 2018 reflect the change from the use of 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) to the RP-2014 Adjusted to 2006 Total Dataset Mortality with Two Dimensional Generational Mortality Improvement Scale MP-2018 (separate employee and annuitant tables and male and female tables). 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). Fiscal Year End Amortization Dec. 31, 2022 (700,154) $ Dec. 31, 2023 (1,916,880) Dec. 31, 2024 (1,217,907) Dec. 31, 2025 (276,322) Dec. 31, 2026 54,818 Thereafter - 77 ---PAGE BREAK--- 2. County Police Benefit Plan Plan Description The Allen County Police Department Supplemental Benefit Trust 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, 2021, Plan membership consisted of the following: Benefits Provided If a member becomes disabled after attainment of age forty-five (45) and completion of five 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. In addition to surviving spouse’s death benefit, a benefit shall be payable on behalf of each dependent child under the age of eighteen (18) years of such deceased member in an amount equal to two hundred dollars ($200) per month. The dependent child’s benefit will cease upon the earlier of the child’s eighteenth (18th) birthday or date of death. Inactive plan members or beneficiaries currently receiving benefits 5 Inactive plan members or beneficiaries entitled to but not yet receiving benefits - Active plan members 137 Total 142 78 ---PAGE BREAK--- 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, 2021, 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 July 29, 2019. Rate of Return For the year ended December 31, 2021, the annual money-weighted rate of return on pension plan investments, net of pension plan expense was 12.70 percent. The money-weighted rate of return expresses investment performance, net of investment expense, adjusted for the changing amounts invested. Net Pension Liability of the Plan The components of the net pension liability of the Plan at December 31, 2021 were as follows: Pension Expense of the Plan Pension expense of ($71,349) must be recognized for the fiscal year ending December 31, 2021. Target Allocation Asset Class Percentage Domestic Large Stocks 30 Domestic Small Stocks 15 Dev. International Stocks 10 Emerging Market Stocks 5 Fixed Income-Core 35 Cash & Equivalents 5 Total 100 Total pension liability 2,376,964 $ Plan fiduciary net position (3,347,648) Plan's net pension liability (970,684) $ Plan fiduciary net position as a percentage of the total pension liability 140.84% 79 ---PAGE BREAK--- Significant Actuarial Assumptions Discount Rate The discount rate used to measure the total pension liability was 6.50% as of December 31, 2021 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 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. Measurement Date December 31, 2021 Valuation Date Assets December 31, 2021 Valuation Date Liabilities December 31, 2021 - Actual member census data as of December 31, 2021 was used in the valuation. Inflation Rate 2 3.00% per annum Future Salary Increases 3 4.00% per annum (For the purpose of GASB reporting, 3.00% increases due to inflation and 1.00% due to merit/seniority.) Expected Rate of Return on Plan Assets 3 6.50% per annum Cost of Living Increase 3 Not Applicable Retirement 1 Benefits are assumed to commence at the earlier of 1) the later of age 55 and 20 years of service, or 2) attainment of age 60, but no earlier than one year from the valuation date. If later, the Sheriff is assumed to retire at the end of his four year term (but not later than attainment of eligibility for in-service retirement). DROP participants are assumed to retire at the end of the DROP Period. Termination of Employment 3 According to Sarason Table T-2 Disability 3 According to 150% of 1964 OASDI Disability Experience Table Mortality Assumption 2 Pub-2010 Safety Amount-Weighted Mortality Projected Generationally with Scale MP-2021 (separate employee, retiree, contingent survivor, and disabled retiree tables and male and female tables) Line of Duty Death Assumption 1 10% of active participant deaths are assumed to occur in line of duty Benefit Payment Form 1 100% of benefits are assumed payable as a single life annuity Marriage 3 100% of participants are assumed to be married when the participant dies Spouse Age 3 Males are assumed to be two years older than females (unless provided) Dependent Children 3 Participants are assumed to have 2.5 children with an average age of 5 years Administrative Expense Loading 1 None Assumed 1 Represents an estimate of future experience 2 Represents actuary's observation of estimates inherent in market data 3 Represents both an estimate of future experience, and actuary's observation of estimates inherent in market data 80 ---PAGE BREAK--- Sensitivity of the Net Pension Liability to Changes in the Discount Rate The following presents the net pension liability of the Allen County Police Department Supplemental Benefit Trust Plan, calculated using the discount rate of 6.50%, 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.50%) or 1-percentage point higher (7.50%) than the current rate: Deferred Outflows of Resources and Deferred Inflows of Resources Related to Pensions At December 31, 2021, the deferred outflows/(inflows) of resources based on obligations for the Plan are as follows: The balances as of December 31, 2021 of the deferred outflows/(inflows) of resources will be recognized in pension expense as follows: Initial Annual December 31, 2021 Initial Balance Amortization Period Recognition Balance Liability experience losses/(gains): Base for year ending December 31, 2021 (142,767) $ 8.811 (16,203) $ (126,564) $ Base for year ending December 31, 2020 (231,511) 8.443 (27,420) (176,671) Base for year ending December 31, 2019 (198,250) 8.651 (22,916) (129,502) Base for year ending December 31, 2018 (132,531) 8.963 (14,786) (73,387) Base for year ending December 31, 2017 234,333 8.897 26,338 102,643 Base for year ending December 31, 2016 (110,212) 8.982 (12,270) (36,592) Base for year ending December 31, 2015 (142,295) 8.846 (16,086) (29,693) Base for year ending December 31, 2014 83,472 9.086 9,187 9,976 Changes in assumptions: Base for year ending December 31, 2021 49,185 $ 8.811 5,582 $ 43,603 $ Base for year ending December 31, 2020 (3,195) 8.443 (378) (2,439) Base for year ending December 31, 2019 (75,009) 8.651 (8,671) (48,996) Base for year ending December 31, 2018 5,109 8.963 570 2,829 Base for year ending December 31, 2017 (9,204) 8.897 (1,035) (4,029) Base for year ending December 31, 2016 (2,828) 8.982 (315) (938) Base for year ending December 31, 2015 63,730 8.846 7,204 13,302 Base for year ending December 31, 2014 48,929 9.086 5,385 5,849 Investment losses/(gains): Base for year ending December 31, 2021 (172,472) $ 5.000 (34,494) $ (137,978) $ Base for year ending December 31, 2020 (171,139) 5.000 (34,228) (102,683) Base for year ending December 31, 2019 (239,192) 5.000 (47,838) (95,678) Base for year ending December 31, 2018 226,981 5.000 45,396 45,397 Base for year ending December 31, 2017 (115,095) 5.000 (23,019) - (159,997) $ (741,551) $ Current 1% Decrease Discount Rate 1% Increase (5.50%) (6.50%) (7.50%) Total Pension Liability 2,690,290 $ 2,376,964 $ 2,115,164 $ Plan Fiduciary Net Position 3,347,648 3,347,648 3,347,648 Net Pension Liability (Asset) (657,358) $ (970,684) $ (1,232,484) $ 81 ---PAGE BREAK--- Assumption changes: The changes in assumptions for base year ending December 31, 2021 reflect the change from the use of the Pub-2010 Safety Amount-Weighted Mortality Projected Generationally with Scale MP-2020 (separate employee, retiree, contingent survivor, and disabled retiree tables and male and female tables) and a discount rate of 6.75% to the Pub-2010 Safety Amount-Weighted Mortality Projected Generationally with Scale MP-2021 (separate employee, retiree, contingent survivor, and disabled retiree tables and male and female tables) and a discount rate of 6.50%. The changes in assumptions for base year ending December 31, 2020 reflect the change from the use of the Pub-2010 Safety Amount-Weighted Mortality Projected Generationally with Scale MP-2019 (separate employee, retiree, contingent survivor, and disabled retiree tables and male and female tables) to the Pub-2010 Safety Amount-Weighted Mortality Projected Generationally with Scale MP-2020 (separate employee, retiree, contingent survivor, and disabled retiree tables and male and female tables). The changes in assumptions for base year ending December 31, 2019 reflect the change from the use of the RP-2014 Adjusted to 2006 Total Dataset Mortality with Two Dimensional Generational Mortality Improvement Scale MP-2018 (separate employee and annuitant tables and male and female tables) to the Pub-2010 Safety Amount-Weighted Mortality Projected Generationally with Scale MP-2019 (separate employee, retiree, contingent survivor, and disabled retiree tables and male and female tabes). The changes in assumptions for base year ending December 31, 2018 reflect the change from the use of 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) to the RP-2014 Adjusted to 2006 Total Dataset mortality with Two Dimensional Generational Mortality Improvement Scale MP-2018 (separate employee and annuitant tables and male and female tables). Fiscal Year End Amortization Dec. 31, 2022 (136,977) $ Dec. 31, 2023 (194,322) Dec. 31, 2024 (140,000) Dec. 31, 2025 (96,013) Dec. 31, 2026 (83,700) Thereafter (90,539) Amorization 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.811 years, the average remaining service of all members with any liability in the plan as of January 1, 2021. The change in net pension liability due to investment losses/(gains) has been amortized over 5.0 years as prescribed. 82 ---PAGE BREAK--- 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 changs 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%. 83 ---PAGE BREAK--- 3. Financial Statements for Defined Benefit Plans County Police County Police Retirement Plan Benefit Plan Assets Cash and cash equivalents 4,826,511 $ 359,064 $ Receivables: Employee contributions 33,296 - Transfers into trust - 10,241 Accrued interest and dividends 89 7 Total receivables 33,385 10,248 Investments: Fixed income securities 23,030,212 998,107 Domestic and foreign equities 44,342,146 1,980,229 Total investments 67,372,358 2,978,336 Total Assets 72,232,254 3,347,648 Liabilities Payables: Net benefits due and unpaid/(overpaid) 16,755 - Transfers out of trust 10,241 - Total Liabilities 26,996 - Net position restricted for Pensions 72,205,258 $ 3,347,648 $ STATEMENT OF FIDUCIARY NET POSITION 84 ---PAGE BREAK--- County Police County Police Retirement Plan Benefit Plan Additions Contributions: Employer 2,939,071 $ 120,135 $ Employee 288,467 N/A Total contributions 3,227,538 120,135 Investment Income: Interest and Dividends 2,187,317 97,757 Net increase in fair value of investments 6,245,223 273,546 Net investment income 8,432,540 371,303 Miscellaneous 10,241 - Total additions 11,670,319 491,438 Deductions Benefit payments (including refunds of employee contributions) 4,164,427 51,439 Administrative expense 105,669 1,728 Transfers out of trust 10,241 - Total deductions 4,280,337 53,167 Net increase in Net Pension 7,389,982 438,271 Net Position Restricted for Pensions Beginning of year 64,818,276 2,909,377 End of year 72,208,258 $ 3,347,648 $ 85 ---PAGE BREAK--- County Police County Police Retirement Plan Benefit Plan Service cost 1,403,901 $ 128,043 $ Interest 4,690,720 157,708 Changes in plan provisions 167,535 - Difference between expected and actual experience 684,732 (142,767) Change in assumptions 2,084,006 49,185 Benefit Payments (4,164,427) (51,439) Net change in Total Pension Liability 4,866,467 140,730 Total Pension Liability - Beginning of Year 70,343,985 2,236,234 Total Pension Liability - End of Year 75,210,452 $ 2,376,964 $ Net Pension Liability (Asset) - End of Year (Total Pension Liability-Plan Fiduciary Net Position) 3,005,195 $ (970,684) $ STATEMENT OF CHANGES IN FIDUCIARY NET POSITION LIABILITIES (ASSETS) 86 ---PAGE BREAK--- County Police Retirement Plan ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF CHANGES IN THE COUNTY'S NET PENSION LIABILITY AND RELATED RATIOS Last 10 Years* 2021 2020 2019 2018 2017 2016 Total Pension liability Service Cost 1,403,901 $ 1,346,696 $ 1,227,784 $ 1,177,687 $ 1,023,466 $ 979,124 $ Interest 4,690,720 4,588,845 4,271,323 4,095,244 3,810,038 3,704,007 Changes in plan provisions 167,535 - - - 18,385 - Difference between expected and actual experience 684,732 (376,230) 1,585,743 321,820 1,212,624 227,812 Change in assumptions 2,084,006 (202,750) 786,080 (143,815) 819,710 (544,042) Benefit payments (4,164,427) (3,597,338) (2,917,624) (2,862,731) (2,754,592) (2,941,827) Net change in Total Pension Liability 4,866,467 1,759,223 4,953,306 2,588,205 4,129,631 1,425,074 Total pension liability - beginning of year 70,343,985 68,584,762 63,631,456 61,043,251 56,913,620 55,488,546 Total pension liability - end of year 75,210,452 $ 70,343,985 $ 68,584,762 $ 63,631,456 $ 61,043,251 $ 56,913,620 $ Plan fiduciary net position County contributions 2,939,071 $ 2,637,789 $ 2,531,595 $ 2,230,101 $ 2,093,845 $ 1,940,126 $ Employee contributions 288,467 280,093 260,396 251,144 225,547 236,520 Net transfers into (out of) trust (10,241) - - - (64,719) - Net investment income 8,432,539 8,133,836 8,994,194 (2,191,813) 5,940,799 3,817,637 Benefit payments (4,164,427) (3,597,338) (2,917,624) (2,862,731) (2,754,592) (2,941,827) Administrative expenses (108,669) (96,907) (92,633) (86,476) (106,541) (95,041) Other 10,241 - - - 64,719 - Net change in Plan Fiduciary Net Position 7,386,981 7,357,473 8,775,928 (2,659,775) 5,399,058 2,957,415 Plan fiduciary net position - beginning of year 64,818,276 57,460,803 48,684,875 51,344,650 45,945,592 42,988,177 Plan fiduciary net position - end of year 72,205,257 $ 64,818,276 $ 57,460,803 $ 48,684,875 $ 51,344,650 $ 45,945,592 $ Net Pension Liability (Asset) - End of Year - 3,005,195 $ 5,525,709 $ 11,123,959 $ 14,946,581 $ 9,698,601 $ 10,968,028 $ Plan fiduciary net position as a percentage of the total pension liability 96.00% 92.14% 83.78% 76.51% 84.11% 80.73% Covered-employee payroll 9,975,470 9,881,868 9,600,480 8,777,206 8,424,630 7,311,096 Net pension liability as a percentage of covered-employee payroll 30.13% 55.92% 115.87% 170.29% 115.12% 150.02% Notes to Schedule: *Information presented for the years information is available The notes to RSI are an integral part of RSI. 87 ---PAGE BREAK--- County Police Retirement Plan (continued) ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF CHANGES IN THE COUNTY'S NET PENSION LIABILITY AND RELATED RATIOS Last 10 Years* Total Pension liability Service Cost Interest Changes in plan provisions Difference between expected and actual experience Change in assumptions Benefit payments Net change in Total Pension Liability Total pension liability - beginning of year Total pension liability - end of year Plan fiduciary net position County contributions Employee contributions Net transfers into (out of) trust Net investment income Benefit payments Administrative expenses Other Net change in Plan Fiduciary Net Position Plan fiduciary net position - beginning of year Plan fiduciary net position - end of year Net Pension Liability (Asset) - End of Year - Plan fiduciary net position as a percentage of the total pension liability Covered-employee payroll Net pension liability as a percentage of covered-employee payroll Notes to Schedule: *Information presented for the years information is available The notes to RSI are an integral part of RSI. 2015 2014 902,114 $ 901,082 $ 3,533,405 3,489,167 - - 108,503 (430,349) 732,983 1,239,380 (2,690,363) (2,708,792) 2,586,642 2,490,488 52,901,904 50,411,416 55,488,546 $ 52,901,904 $ 1,913,674 $ 1,880,580 $ 196,306 186,665 (13,964) - (623,338) 2,669,670 (2,690,363) (2,708,792) (87,552) (104,620) 13,964 - (1,291,273) 1,923,503 44,279,450 42,355,947 42,988,177 $ 44,279,450 $ 12,500,369 $ 8,622,454 $ 77.47% 83.70% 6,869,667 6,456,147 181.96% 133.55% 88 ---PAGE BREAK--- County Police Benefit Plan ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF CHANGES IN THE COUNTY'S NET PENSION LIABILITY AND RELATED RATIOS Last 10 Years* 2021 2020 2019 2018 2017 2016 Total pension liability Service Cost 128,043 $ 121,594 $ 125,970 $ 118,463 $ 87,624 $ 83,300 $ Interest 157,708 158,106 161,773 155,722 127,583 125,214 Changes in plan provisions - - - - 10,367 - Difference between expected and actual experience (142,767) (231,511) (198,250) (132,531) 234,333 (110,212) Change in assumptions 49,185 (3,195) (75,009) 5,109 (9,204) (2,828) Benefit payments (51,439) (64,301) (64,601) (64,661) (64,661) (64,781) Net change in Total Pension Liability 140,730 (19,307) (50,117) 82,102 386,042 30,693 Total pension liability - beginning of year 2,236,234 2,255,541 2,305,658 2,223,556 1,837,514 1,806,821 Total pension liability - end of year 2,376,964 $ 2,236,234 $ 2,255,541 $ 2,305,658 $ 2,223,556 $ 1,837,514 $ Plan fiduciary net position County contributions 120,135 $ 162,244 $ 155,497 $ 81,356 $ 86,292 $ 93,510 $ Employee contributions N/A N/A N/A N/A N/A N/A Net transfers into (out of) trust - - - - - - Net investment income 371,303 341,484 377,734 (86,368) 238,410 141,729 Benefit payments (51,439) (64,301) (64,601) (64,661) (64,661) (64,781) Administrative expenses (1,728) (1,353) (1,241) (1,146) (1,062) (947) Other - - - - - - Net change in Plan Fiduciary Net Position 438,271 438,074 467,389 (70,819) 258,979 169,511 Plan fiduciary net position - beginning of year 2,909,377 2,471,303 2,003,914 2,074,733 1,815,754 1,646,243 Plan fiduciary net position - end of year 3,347,648 $ 2,909,377 $ 2,471,303 $ 2,003,914 $ 2,074,733 $ 1,815,754 $ Net Pension Liability (Asset) - End of Year - (970,684) $ (673,143) $ (215,762) $ 301,744 $ 148,823 $ 21,760 $ Plan fiduciary net position as a percentage of the total pension liability 140.84% 130.10% 109.57% 86.91% 93.31% 98.82% Covered-employee payroll 9,975,470 9,881,868 9,600,480 8,777,206 8,424,630 7,311,096 Net pension liability as a percentage of covered-employee payroll (9.73%) (6.81%) (2.25%) 3.44% 1.77% 0.30% Notes to Schedule: *Information presented for the years information is available The notes to RSI are an integral part of RSI. 89 ---PAGE BREAK--- County Police Benefit Plan (continued) ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF CHANGES IN THE COUNTY'S NET PENSION LIABILITY AND RELATED RATIOS Last 10 Years* Total pension liability Service Cost Interest Changes in plan provisions Difference between expected and actual experience Change in assumptions Benefit payments Net change in Total Pension Liability Total pension liability - beginning of year Total pension liability - end of year Plan fiduciary net position County contributions Employee contributions Net transfers into (out of) trust Net investment income Benefit payments Administrative expenses Other Net change in Plan Fiduciary Net Position Plan fiduciary net position - beginning of year Plan fiduciary net position - end of year Net Pension Liability (Asset) - End of Year - Plan fiduciary net position as a percentage of the total pension liability Covered-employee payroll Net pension liability as a percentage of covered-employee payroll Notes to Schedule: *Information presented for the years information is available The notes to RSI are an integral part of RSI. 2015 2014 73,017 $ 54,354 $ 121,101 108,193 - - (142,295) 83,472 63,730 48,929 (65,021) (65,291) 50,532 229,657 1,756,289 1,526,632 1,806,821 $ 1,756,289 $ 55,854 $ 70,445 $ N/A N/A - - (38,491) 99,777 (65,021) (65,291) (843) (703) - - (48,501) 104,228 1,694,744 1,590,516 1,646,243 $ 1,694,744 $ 160,578 $ 61,545 $ 91.11% 96.50% 6,869,667 6,456,147 2.34% 0.95% 90 ---PAGE BREAK--- 2021 2020 2019 2018 2017 County Police Retirement Plan Actuarially determined contribution** 2,712,869 $ 2,332,102 $ 2,244,370 $ 1,968,441 $ 1,940,644 $ County contributions recognized 2,939,071 2,637,789 2,531,595 2,230,101 2,093,845 Contribution deficiency (excess) (226,202) $ (305,687) $ (287,225) $ (261,660) $ (153,201) $ Covered - employee payroll 9,975,470 $ 9,600,480 $ 8,777,206 $ 8,424,630 $ 7,311,096 $ Contributions recognized as a percentage of covered-employee payroll 29.46% 27.48% 28.84% 26.47% 28.64% 2016 2015 2014 2013 2012 County Police Retirement Plan Actuarially determined contribution** 1,793,068 $ 1,770,122 $ 1,744,741 $ 1,699,803 $ 1,593,248 $ County contributions recognized 1,940,126 1,913,674 1,880,580 1,832,170 1,723,869 Contribution deficiency (excess) (147,058) $ (143,552) $ (135,839) $ (132,367) $ (130,621) $ Covered - employee payroll 6,869,667 $ 6,456,147 $ 6,309,482 $ 6,183,034 $ 6,118,166 $ Contributions recognized as a percentage of covered-employee payroll 28.24% 29.64% 29.81% 29.63% 28.18% 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 Entry Age Normal Cost Amortization method Level percentage of payroll, closed Remaining amortization period 20 years Asset valuation method Inflation 3.00% 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 (age 60 if earlier) or one year from the valuation date. Mortality Pub-2010 Safety Amount-Weighted Mortality Projected Generationally with Scale MP-2019 (separate employee, retiree, contingent survivor, and disabled retiree tables and male and female tables) Other Information: None The notes to RSI are an integral part of RSI. 5-Year Asset Smooting, limited to 80% and 120% of market value ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF COUNTY CONTRIBUTIONS Last 10 Years 91 ---PAGE BREAK--- 2021 2020 2019 2018 2017 County Police Benefit Plan Actuarially determined contribution** 120,135 $ 162,244 $ 155,497 $ 81,356 $ 86,292 $ County contributions recognized 120,135 162,244 155,497 81,356 86,292 Contribution deficiency (excess) - $ - $ - $ - $ - $ Covered - employee payroll 9,975,470 $ 9,600,480 $ 8,777,206 $ 8,424,630 $ 7,311,096 $ Contributions recognized as a percentage of covered-employee payroll 1.20% 1.69% 1.77% 0.97% 1.18% 2016 2015 2014 2013 2012 County Police Benefit Plan Actuarially determined contribution** 93,510 $ 55,854 $ 70,445 $ 89,939 $ 103,962 $ County contributions recognized 93,510 55,854 70,445 89,939 103,962 Contribution deficiency (excess) - $ - $ - $ - $ - $ Covered - employee payroll 6,869,667 $ 6,456,147 $ 6,309,482 $ 6,183,034 $ 6,118,166 $ Contributions recognized as a percentage of covered-employee payroll 1.36% 0.87% 1.12% 1.45% 1.70% 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.00% Salary increases 4.00% average, including inflation Investment rate of return 6.75% Retirement age from the valuation date Mortality Pub-2010 Safety Amount-Weighted Morality Projected Generationally with Scale MP-2019 (separate employee, retiree, contingent survivor, and disabled retiree tables and male and female tables) Other Information: None The notes to RSI are an integral part of RSI. The later of age 55 and 20 years of service (age 60 if earlier) or one year ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF COUNTY CONTRIBUTIONS Last 10 Years 5-Year Asset Smoothing, limited to 80% and 120% of market value 92 ---PAGE BREAK--- 2021 2020 2019 2018 2017 County Police Retirement Plan Annual money-weighted rate of return 13.24% 14.32% 18.57% (4.30%) 13.04% 2016 2015 2014 2013 2012 Annual money-weighted rate of return 9.00% (1.43%) 6.35% 14.90% 10.30% The notes to RSI are an integral part of RSI. ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF INVESTMENT RETURNS Last 10 Fiscal Years 93 ---PAGE BREAK--- 2021 2020 2019 2018 2017 County Police Benefit Plan Annual money-weighted rate of return 12.70% 13.70% 18.61% (4.24%) 13.17% 2016 2015 2014 2013 Annual money-weighted rate of return 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* 94 ---PAGE BREAK--- 2021 2020 2019 2018 2017 Indiana Public Retirement System Proportion of the net pension liability (asset) 0.91099% 0.91505% 0.94638% 0.97896% 1.03440% Proportionate share of the net pension liability (asset) 11,987,241 $ 27,638,118 $ 31,278,462 $ 33,255,714 $ 46,150,206 $ Covered payroll 50,226,725 $ 49,400,160 $ 49,307,329 $ 49,952,345 $ 51,318,423 $ Proportionate share of the net pension liability (asset) as a percentage of its covered payroll 23.87% 55.95% 63.44% 66.57% 89.93% Plan fiduciary net position as a percentage of the total pension liability 92.50% 81.40% 80.10% 78.89% 76.60% 2016 2015 2014 Proportion of the net pension liability (asset) 1.01058% 1.12838% 1.06157% Proportionate share of the net pension liability (asset) 45,864,613 $ 45,957,812 $ 27,897,371 $ Covered payroll 48,432,812 $ 54,047,347 $ 51,829,153 $ Proportionate share of the net pension liability (asset) as a percentage of its covered payroll 94.70% 85.03% 53.83% Plan fiduciary net position as a percentage of the total pension liability 75.30% 77.30% 84.30% *Schedule presented for years information available The notes to RSI are an integral part of RSI. ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF PROPORTIONATE SHARE OF NET PENSION LIABILITY AND RELATED RATIOS Last 10 Fiscal Years* 95 ---PAGE BREAK--- 2021 2020 2019 2018 2017 Indiana Public Retirement System Statutorily required contribution 5,565,715 $ 5,725,946 $ 5,483,867 $ 5,515,477 $ 5,518,762 $ Actual county contributions 5,565,715 5,725,946 5,483,867 5,515,477 5,518,762 Contribution deficiency (excess) - $ - $ - $ - $ - $ Covered - employee payroll 50,226,725 $ 51,622,649 $ 49,274,495 $ 49,713,002 $ 49,069,627 $ Contributions recognized as a percentage of covered-employee payroll 11.08% 11.09% 11.13% 11.09% 11.25% 2016 2015 2014 Statutorily required contribution 5,488,388 $ 5,685,565 $ 5,324,298 $ Actual county contributions 5,488,388 5,685,565 5,324,298 Contribution deficiency (excess) - $ - $ - $ Covered - employee payroll 49,372,626 $ 51,114,972 $ 52,395,423 $ Contributions recognized as a percentage of covered-employee payroll 11.12% 11.12% 10.16% *Schedule presented for years information available The notes to RSI are an integral part of RSI. ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF EMPLOYER CONTRIBUTIONS - INPRS (PERF) Last 10 Years* 96 ---PAGE BREAK--- Allen County Retiree Healthcare Plan (OPEB) 2021 2020 2019 2018 Total OPEB liability Service Cost 488,952 $ 314,181 $ 271,610 $ 341,940 $ Interest 326,975 364,118 432,139 391,011 Changes in benefit terms - - - - Difference between expected and actual experience (400,785) 1,839,933 (389,678) (25,540) Change in assumptions (166,682) 2,026,022 778,441 (990,452) Benefit payments (475,347) (453,364) (505,493) (493,210) Net change in Total OPEB Liability (226,887) 4,090,890 587,019 (776,251) Total OPEB liability - beginning of year 15,170,826 11,079,936 10,492,917 11,269,168 Total OPEB liability - end of year 14,943,939 $ 15,170,826 $ 11,079,936 $ 10,492,917 $ Covered-employee payroll 82,145,358 79,843,478 73,179,394 69,936,508 Total OPEB liability as a percentage of covered-employee payroll 18.20% 19.00% 15.10% 15.00% Notes to Schedule: *Information presented for the years information is available The notes to RSI are an integral part of RSI. ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION SCHEDULE OF CHANGES IN THE COUNTY'S NET OTHER POST EMPLOYMENT BENEFITS LIABILITY AND RELATED RATIOS LAST 10 YEARS * 97 ---PAGE BREAK--- Variance Actual With Final Amounts Budget (Budgetary Positive Original Final Basis) (Negative) Revenues: Taxes: Property 87,781,044 $ 87,781,044 $ 88,295,917 $ 514,873 $ Licenses and permits 2,400,000.00 2,400,000 3,652,434 1,252,434 Intergovernmental 14,371,639.00 14,767,286 18,934,690 4,167,404 Charges for services 3,243,000.00 3,243,000 3,816,249 573,249 Fines and forfeits 1,000,000.00 1,000,000 812,616 (187,384) Other 3,139,000.00 3,144,728 2,951,879 (192,849) Total revenues 111,934,683 112,336,058 118,463,785 6,127,727 Expenditures: Current: General government 45,882,947 50,687,372 46,601,150 4,086,222 Public safety 56,842,893 60,659,278 58,133,026 2,526,252 Highway and streets - 2,617,597 2,517,597 100,000 Health and welfare 6,991,586 7,071,974 7,035,543 36,431 Culture and recreation 4,114,827 6,652,831 6,127,139 525,692 Economic development 406,200 406,200 25,525 380,675 Sanitation 30,000 30,000 29,878 122 Total expenditures 114,268,453 128,125,252 120,469,858 7,655,394 Other financing sources (uses): Transfers In 482,717 482,717 928,115 445,398 Transfers Out (197,500) (197,500) (197,500) - Total other financing sources (uses) 285,217 285,217 730,615 445,398 Net change in fund balances (2,048,553) (15,503,977) (1,275,458) 14,228,519 Fund balances - beginning 76,589,879 76,589,879 76,589,879 - Fund balances - December 31 74,541,326 $ 61,085,902 $ 75,314,421 $ 14,228,519 $ General Fund Budgeted Amounts ALLEN COUNTY REQUIRED SUPPLEMENTARY INFORMATION BUDGETARY COMPARISON SCHEDULES - GENERAL FUND AND MAJOR SPECIAL REVENUE FUNDS For The Year Ended December 31, 2021 98 ---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). General Net change in fund balances (budgetary basis) (1,275,458) $ Adjustments: To adjust revenues for accruals 1,717,098 To adjust expenditures for accruals 7,196,579 Net change in fund balances (GAAP basis) 7,638,219 $ 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, 2021 99 ---PAGE BREAK--- Allen County Notes to Required Supplementary Information Note 1. Budgets and Budgetary Accounting A. The County follows these procedures in establishing the budgetary data reflected in the budgetary comparison schedules: 1. The County Commissioners, Courts and Elected Officials submit to the County Council their proposed operating budgets for the fiscal year commencing the following January 1. The operating budget includes proposed expenditures and the means of financing them. 2. The County is required to advertise the budget and proposed tax levy on the Indiana Department of Local Government Finance (DLGF) website and the County Council holds a public hearing to obtain taxpayer comments prior to adoption, both according to Indiana Code (IC). 3. The County Council is required to adopt the budget by November 1st and has historically done such in October through passage of an ordinance. 4. The Adopted budget ordinance and supporting schedules are submitted to the DLGF. The budget becomes legally enacted after receiving the DLGF certified budget order, which is required by December 31st. The budget order serves as the maximum allowable expenditures unless the County Council approves additional appropriations throughout the year. The County’s maximum levy is restricted by IC, with certain adjustments and exceptions. In the instance the County proposes a budget that exceeds the available means of financing; an excess levy appeal can be made to the DLGF. If approved, the County will be allowed to increase their maximum levy accordingly. 5. The legal level of budgetary control (the level at which expenditures may not exceed appropriations without the County Council’s approval) is by object classification for all funds except for the General fund, which is by object classification within each department. The County management cannot transfer budgeted appropriations between object classifications of a budget without approval of the County Council. Any revisions that alter the total appropriations for any fund or any department of the General fund must be approved by the County Council and, if applicable, the DLGF. 6. Formal budgetary integration is required by IC and is employed as a management control device. An annual budget was legally adopted for the following funds: Major Funds: General Fund Approximately 90 other Funds are included within Other Governmental Funds for which an annual budget was adopted. 7. The County’s budget process is based upon cash outflows, which is a non-GAAP basis. Appropriations lapse with the expiration of the budgetary period unless encumbered by a purchased order or contract. Encumbered appropriations are carried over and added to the subsequent year’s budget. 100 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 Local Income Tax - County Local Road Service of County Assets Public Safety Highway and Street Process Health Cash and cash equivalents 1,370,710 $ 9,692,579 $ 2,105,197 $ 23,478 $ 2,749,370 $ Investments 45,222 319,776 69,454 - 90,707 Receivables (net of allowances for uncollectibles): Interest - 3,866 - - 847 Taxes 4,246,539 150,587 - - 3,156,401 Accounts - 4,535 - 26,437 11,961 Special assessments - - - - - Intergovernmental - 991,010 460,997 - 122,619 Interfund receivables: Interfund loans - - - - - Assets held for resale - - - - - Total assets 5,662,471 $ 11,162,353 $ 2,635,648 $ 49,915 $ 6,131,905 $ Liabilities, deferred inflows of resources, and fund balances Liabilities: Accounts payable - $ 1,463,012 $ 166,842 $ - $ 16,555 $ Accrued payroll and withholdings payable - - - - 141,106 Interfund payables: Interfund loans - - - - - Total liabilities - 1,463,012 166,842 - 157,661 Deferred inflows of resources: Unavailable revenue - property taxes - - - - 3,004,082 Unavailable revenue - commercial vehicle excise taxes - - - - 8,965 Unavailable revenue - financial institution taxes - 13,562 Unavailable revenue - income taxes 3,621,840 - - - - Total deferred inflows of resources 3,621,840 - - - 3,026,609 Fund balances: Nonspendable fund balance - $ - $ - $ - $ - $ Restricted fund balance 2,040,631 9,699,341 2,468,806 49,915 2,947,635 Committed fund balance - - - - - Assigned fund balance - - - - - Unassigned fund balance - - - - - Total fund balances 2,040,631 9,699,341 2,468,806 49,915 2,947,635 Total liabilities, deferred inflows of resources, and fund balances 5,662,471 $ 11,162,353 $ 2,635,648 $ 49,915 $ 6,131,905 $ 101 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Supplemental Supplemental Detention Juvenile Adult Probation Accident Alternative Grant Probation Services Services Report 18,574 $ 116,925 $ 522,650 $ 26,152 $ - 3,857 17,243 - - 36 167 - - - - - - 4,189 14,066 2,340 - - - - - - - - - - - - - - - - 18,574 $ 125,007 $ 554,126 $ 28,492 $ - $ 1,203 $ 5,238 $ - $ - - 16,795 - - - - - - 1,203 22,033 - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ 18,574 123,804 532,093 28,492 - - - - - - - - - - - - 18,574 123,804 532,093 28,492 18,574 $ 125,007 $ 554,126 $ 28,492 $ 102 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Recorders Surveyor's Corner Firearms County Records Drainage Perpetuation Training Extradition Perpetuation Maintenance 1,462,378 $ 52,791 $ 13,482 $ 2,026,533 $ 6,177,551 $ 48,246 1,742 - 66,859 203,809 - - - 660 - - - - - - 36,370 - 11,300 98,859 - - - - - 26,128 - - - - 559 - - - - - - - - - - 1,546,994 $ 54,533 $ 24,782 $ 2,192,911 $ 6,408,047 $ 3,191 $ - $ 7,450 $ 9,831 $ 30,920 $ 2,704 - - 23,680 - - - - - - 5,895 - 7,450 33,511 30,920 - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ 1,541,099 54,533 17,332 2,159,400 6,377,127 - - - - - - - - - - - - - - - 1,541,099 54,533 17,332 2,159,400 6,377,127 1,546,994 $ 54,533 $ 24,782 $ 2,192,911 $ 6,408,047 $ 103 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Law Jail Local Health County Enforcement County Commissary Maintenance User Fee Continuing Education Corrections 1,368,118 $ 54,509 $ 75,800 $ 27,425 $ 198,696 $ - 1,798 2,501 - 6,555 - - - - - - - - - - - - 2,543 573 - - - - - - - - - - - - - - - - - - - - - 1,368,118 $ 56,307 $ 80,844 $ 27,998 $ 205,251 $ - $ - $ 1,070 $ - $ 1,159 $ - 5,545 - - - - - - - - - 5,545 1,070 - 1,159 - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ 1,368,118 - 79,774 27,998 204,092 - 50,762 - - - - - - - - - - - - - 1,368,118 50,762 79,774 27,998 204,092 1,368,118 $ 56,307 $ 80,844 $ 27,998 $ 205,251 $ 104 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Park and Community Corrections - Deterrent Recreation Corrections Home Detention Program Narcotics Nonreverting 31 $ 1,462,468 $ 14,384 $ 124,394 $ 557,384 $ - 48,249 - 4,104 18,389 - - - - - - - - - - - 24,359 2,424 - - - - - - - - 420 - - - - - - - - - - - - - 31 $ 1,535,496 $ 16,808 $ 128,498 $ 575,773 $ 30,362 $ 4,072 $ - $ - $ 9,614 $ 87,267 103,600 - - - - - - - - 117,629 107,672 - - 9,614 - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - 1,427,824 16,808 128,498 566,159 - - - - - - - - - - (117,598) - - - - (117,598) 1,427,824 16,808 128,498 566,159 31 $ 1,535,496 $ 16,808 $ 128,498 $ 575,773 $ 105 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Emergency Vehicle County Planning and Title Record Drug Free Right to Know Inspection Check Plat Book Community 279,626 $ 16,040 $ 61,742 $ 456,033 $ 130,251 $ 9,225 - 2,037 15,045 4,297 - - - - - - - - - - - - 5,399 1,860 9,308 - - - - - - - - - - - - - - - - - - - - 288,851 $ 16,040 $ 69,178 $ 472,938 $ 143,856 $ - $ - $ - $ - $ - $ - - - 5,727 - - - - - - - - - 5,727 - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ 288,851 16,040 69,178 467,211 143,856 - - - - - - - - - - - - - - - 288,851 16,040 69,178 467,211 143,856 288,851 $ 16,040 $ 69,178 $ 472,938 $ 143,856 $ 106 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Court Allen Public Defender Check and Public Appointed County Services Connect Information Special Advocate Statewide 911 247,160 $ - $ 180,114 $ 411,841 $ 10,533 $ 8,154 - 5,942 13,587 - - - - - - - - - - - 2,410 - 64,536 - - - - - - - 10,115 - 69,771 - - - - - - - - - - - 267,839 $ - $ 250,592 $ 495,199 $ 10,533 $ - $ - $ 2,555 $ 2,644 $ - $ - - 3,971 12,148 - - 73,699 - - - - 73,699 6,526 14,792 - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ 267,839 - - - 10,533 - - 244,066 480,407 - - - - - - - (73,699) - - - 267,839 (73,699) 244,066 480,407 10,533 267,839 $ - $ 250,592 $ 495,199 $ 10,533 $ 107 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Indiana Law Department Law Prosecutor Tax Recreation Enforcement of Planning Enforcement PCA Sale Fee Gift Assist Grant Services 96,891 $ 9,474 $ 383,133 $ 310,850 $ - $ 577,001 $ 3,197 - 12,640 10,256 - 19,036 - - - - - - - - - - - - - - - - - - - - - - - - 8,135 - - - - - - - - - - - - - - - - - 108,223 $ 9,474 $ 395,773 $ 321,106 $ - $ 596,037 $ - $ - $ 8,690 $ - $ - $ - $ - - 3,043 - - - - - - - - - - - 11,733 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ 108,223 9,474 384,040 321,106 - - - - - - - 596,037 - - - - - - - - - - - - 108,223 9,474 384,040 321,106 - 596,037 108,223 $ 9,474 $ 395,773 $ 321,106 $ - $ 596,037 $ 108 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Court for Inmates Testing Jury Fee Deferral Fee ADR Plan ADR Plan 37,040 $ 42,016 $ 83 $ 713,867 $ 66,926 $ 37,521 $ 1,222 1,386 - 23,552 2,208 1,238 - - - - - - - - - - - - - - 2,057 54,339 1,265 1,095 - - - - - - - - - 70,578 - - - - - - - - - - - - - - 38,262 $ 43,402 $ 2,140 $ 862,336 $ 70,399 $ 39,854 $ - $ - $ - $ 6,208 $ - $ - $ - - - 20,871 - - - - - - - - - - - 27,079 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ 38,262 - 2,140 835,257 70,399 39,854 - 43,402 - - - - - - - - - - - - - - - - 38,262 43,402 2,140 835,257 70,399 39,854 38,262 $ 43,402 $ 2,140 $ 862,336 $ 70,399 $ 39,854 $ 109 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 IOCS Campaign Community Corona Virus Problem Finance Surveyor's Federal Transitions Relief Solving Grant Enforcement Petition Asset Seizure Program - $ 6,382 $ 23,441 $ 7,451 $ 68,733 $ 88,128 $ - - - - 2,268 2,907 - - - - 22 - - - - - - - - - - - 23,740 - - - - - - - - - - - - 81,325 - - - - - - - - - - - - - $ 6,382 $ 23,441 $ 7,451 $ 94,763 $ 172,360 $ - $ - $ - $ - $ - $ - $ - - - - - 4,837 - - - - - - - - - - - 4,837 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ - 6,382 23,441 7,451 94,763 167,523 - - - - - - - - - - - - - - - - - - - 6,382 23,441 7,451 94,763 167,523 - $ 6,382 $ 23,441 $ 7,451 $ 94,763 $ 172,360 $ 110 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Clerk Alcohol Allen County Prosecutor's Record and Drug Sales Levy Children's Federal Perpetuation User Fees Disclosure Excess Home Gift Asset Seizure 1,311,604 $ 124,202 $ 360,358 $ - $ 38,920 $ 13,419 $ 43,272 4,098 11,889 - 1,284 - - - 114 - - - - - - - - - 15,648 27,281 920 - 1,096 - - - - - - - - - - - - - - - - - - - - - - - - - 1,370,524 $ 155,581 $ 373,281 $ - $ 41,300 $ 13,419 $ - $ 14,746 $ 1,026 $ - $ - $ - $ 5,527 25,753 1,203 - - - - - - - - - 5,527 40,499 2,229 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ 1,364,997 115,082 371,052 - 41,300 13,419 - - - - - - - - - - - - - - - - - - 1,364,997 115,082 371,052 - 41,300 13,419 1,370,524 $ 155,581 $ 373,281 $ - $ 41,300 $ 13,419 $ 111 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Tangible Youth Juvenile Center Check Sheriff Incentive Services Per Per Diem Deception Donation Program Diem Fees Fees Program 18,877 $ 1,185 $ 587,311 $ 490,683 $ - $ - - 19,376 16,189 - 6 - - 151 - - - - - - - - - 263 - - - - - - 1,900 - 51,688 - - - - - - - - - - - - 20,783 $ 1,185 $ 606,687 $ 558,974 $ - $ - $ - $ 116,189 $ - $ - $ - - 16,158 - - - - - - - - - 132,347 - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ 20,783 1,185 - - - - - 474,340 558,974 - - - - - - - - - - - 20,783 1,185 474,340 558,974 - 20,783 $ 1,185 $ 606,687 $ 558,974 $ - $ 112 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Adult Improvement Tobacco Great Protective Unsafe Project Master Plan Lakes Services Building Allen-CIP-FY-03/04 Program Restoration - $ 330,346 $ 3,177 $ 30,883 $ - $ - 10,899 - 1,019 - - - - - - - - - - - - 500 - - - - - - - - 64,826 - 2,328 - - - - - - - - - - - - 64,826 $ 341,745 $ 5,505 $ 31,902 $ - $ - $ 9,579 $ 2,330 $ - $ - $ 14,860 - - 2,218 - 49,966 - - - - 64,826 9,579 2,330 2,218 - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - 332,166 3,175 29,684 - - - - - - - - - - - - - - - - - 332,166 3,175 29,684 - 64,826 $ 341,745 $ 5,505 $ 31,902 $ - $ 113 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Enhanced Courts Foreign Treatment Access - Electronic Map Language COVID 19 Program Recorder Generation Interpreter Donation - $ 43,630 $ 32,486 $ 5 $ - $ - 1,439 1,072 - - - - - - - - - - - - - - - - - - - - - - 10,385 - - - - - - - - - - - - - 10,385 $ 45,069 $ 33,558 $ 5 $ - $ - $ - $ - $ - $ 2,667 $ 1,731 - - - - 8,650 - - - - 10,381 - - - 2,667 - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ 4 45,069 33,558 5 - - - - - - - - - - - - - - - (2,667) 4 45,069 33,558 5 (2,667) 10,385 $ 45,069 $ 33,558 $ 5 $ - $ 114 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Sheriff NE Identification COVID 19 Jury Fee Department Indiana Security Comm Based On-site Circuit Court Training Trails Protection Testing Site Septic System 3,010 $ 1,610 $ 21,301 $ 127,751 $ 121,237 $ 103,881 $ - - - 4,215 4,000 3,427 13 - - - - - - - - - - - 11,322 - - 7,274 - - - - - - - - - - - - - - - - - - - - - - - - - - 14,345 $ 1,610 $ 21,301 $ 139,240 $ 125,237 $ 107,308 $ - $ - $ - $ - $ 10,168 $ - $ - - - - 4,854 5,091 - - - - - - - - - - 15,022 5,091 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - $ 14,345 - - 139,240 110,215 102,217 - 1,610 21,301 - - - - - - - - - - - - - - - 14,345 1,610 21,301 139,240 110,215 102,217 14,345 $ 1,610 $ 21,301 $ 139,240 $ 125,237 $ 107,308 $ 115 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Legal ISDH Stellar Volunteer PSC Education Immunization Regional Advocates Chemical Opportunity Grant Rural Dev For Seniors Testing - $ - $ 9,752 $ 5,794 $ 3,064 $ - - - - - - - - - - - - - - - - - - - - - - - - - - 11,432 - - - - - - - - - - - - - - $ 11,432 $ 9,752 $ 5,794 $ 3,064 $ - $ - $ 9,832 $ 6,250 $ - $ - 1,945 - - - - 9,487 - - - - 11,432 9,832 6,250 - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - - - - 3,064 - - - - - - - - - - - - (80) (456) - - - (80) (456) 3,064 - $ 11,432 $ 9,752 $ 5,794 $ 3,064 $ 116 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 COVID 19 COVID 19 Sex/Violent Criminal Alien Problem Phase III Routine Offender Assistance Solving OCRA Vaccine Admin Program Court - $ - $ 50,779 $ 12,900 $ 37,074 $ - - 1,675 - 1,223 - - 17 - - - - - - - - - 2,825 - - - - - - - 58,457 - - - - - - - - - - - - - - 58,457 $ - $ 55,296 $ 12,900 $ 38,297 $ 58,457 $ - $ - $ - $ - $ - - - - - - 375 - - - 58,457 375 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - - 55,296 12,900 38,297 - - - - - - - - - - - (375) - - - - (375) 55,296 12,900 38,297 58,457 $ - $ 55,296 $ 12,900 $ 38,297 $ 117 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Auditor's Sheriff IJC OVWI Ineligible Training Veterans Cir Crt GIS Deductions Center Court Interpreter Infrastructure 86,098 $ 9,370 $ - $ - $ 58,730 $ 2,840 - - - 1,937 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 88,938 $ 9,370 $ - $ - $ 60,667 $ - $ - $ - $ - $ - $ 1,939 - - - - - - - 3,599 - 1,939 - - 3,599 - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ 86,999 9,370 - - - - - - - 60,667 - - - - - - - - (3,599) - 86,999 9,370 - (3,599) 60,667 88,938 $ 9,370 $ - $ - $ 60,667 $ 118 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 ACCC Dept. Commerical Adult ISDH Solid Fines Court Law Probation Syringe Waste Collections Clerk Grant Service Prog User Fees 34,794 $ 37,435 $ - $ - $ 2,209,524 $ 1,148 1,235 - - 72,896 - - - - 700 - - - - - - - - - - - - - - - - - - 20,504 - - - - - - - - - - - 35,942 $ 38,670 $ - $ 20,504 $ 2,283,120 $ - $ 2,354 $ 2,499 $ 8,700 $ 16,823 $ - - 14,531 1,743 12,152 - - - 11,844 - - 2,354 17,030 22,287 28,975 - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ - 36,316 - - 2,254,145 35,942 - - - - - - - - - - - (17,030) (1,783) - 35,942 36,316 (17,030) (1,783) 2,254,145 35,942 $ 38,670 $ - $ 20,504 $ 2,283,120 $ 119 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 DUI Task Force MS4 Public Elected County Offender Enforcement Education Official Training Transportation - $ 479 $ 495,515 $ 31,040 $ - - 16,348 - - - 158 - - - - - - - 7,274 - - - - - - - - - - - - - - - - - - $ 479 $ 519,295 $ 31,040 $ - $ - $ - $ - $ 4,482 - - - 735 - - - 5,217 - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - 479 519,295 31,040 - - - - - - - - (5,217) - - - (5,217) 479 519,295 31,040 - $ 479 $ 519,295 $ 31,040 $ 120 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Family County Prosc IV-D Clerk IV-D Recovery IV-D Incentive Incentive Reassessment Court Incentive Post 10/99 Post 10/99 2015 11,994 $ 8,330 $ 113,782 $ 520,460 $ 1,105,476 $ - - 3,735 17,171 36,472 - - - - - - - - - 598,628 - - - - - - - - - - - - - - 22,929 - - - - - - - - - - 11,994 $ 8,330 $ 117,517 $ 537,631 $ 1,763,505 $ - $ - $ 1,598 $ 4,500 $ - $ - 6,902 - 14,222 12,660 - - - - - - 6,902 1,598 18,722 12,660 - - - - 569,740 - - - - 1,700 - - - - 2,572 - - - - - - - - - 574,012 - $ - $ - $ - $ - $ 11,994 1,428 115,919 518,909 1,176,833 - - - - - - - - - - - - - - - 11,994 1,428 115,919 518,909 1,176,833 11,994 $ 8,330 $ 117,517 $ 537,631 $ 1,763,505 $ 121 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Dupont County General Drain Great Batch Special COIT - Diebold Bond Improvement TIF Flood Control TIF - $ 1,688,061 $ 201,453 $ 311,090 $ 541,114 $ - 55,692 6,646 10,263 17,852 - 2,467 - - - - - - - 520,004 - - - - - - - - - - - - - - - - 106,718 - - - - - - - - - $ 1,852,938 $ 208,099 $ 321,353 $ 1,078,970 $ - $ - $ - $ - $ - $ - - - - - - - 79,820 - - - - 79,820 - - - - - - 520,004 - - - - - - - - - - - - - - - - - - - 520,004 - $ - $ - $ - $ - $ - 1,852,938 128,279 - 558,966 - - - - - - - - 321,353 - - - - - - - 1,852,938 128,279 321,353 558,966 - $ 1,852,938 $ 208,099 $ 321,353 $ 1,078,970 $ 122 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Cumulative Lafayette Capital CASAD Nestle TIF Center Development East TIF Major Bridge II Bond Corner TIF Argo Drain 8,787,049 $ 31,747 $ 5,261,013 $ 402,158 $ 4,538 $ 156,035 $ 289,901 1,047 173,570 13,268 - 5,148 2,757 - - - - - 3,283,383 338,915 4,063,413 91,653 41,463 - - - - - - - - - - - - - 125,760 - 175,966 - - - - - - - - - - - - - - - 12,488,850 $ 371,709 $ 9,673,962 $ 507,079 $ 46,001 $ 161,183 $ 464,048 $ - $ 12,908 $ - $ - $ - $ - - - - - - - 909,929 - - - - 464,048 909,929 12,908 - - - 3,124,936 338,915 3,867,324 91,653 41,463 - 9,325 - 11,541 - - - 14,107 - 17,459 - - - - - - - - - 3,148,368 338,915 3,896,324 91,653 41,463 - - $ - $ - $ - $ - $ - $ 8,876,434 - 5,764,730 415,426 4,538 161,183 - - - - - - - - - - - - - (877,135) - - - - 8,876,434 (877,135) 5,764,730 415,426 4,538 161,183 12,488,850 $ 371,709 $ 9,673,962 $ 507,079 $ 46,001 $ 161,183 $ 123 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Tax Woodburn Lincoln Development Mossman Diebold Abatement Industrial Industrial Corporation Drain Corner TIF Development TIF TIF 478,183 $ 20,749 $ 213,574 $ 727,450 $ 204,815 $ 206,138 $ 15,776 - 7,046 24,000 6,757 6,801 - - - - - - - - 284,004 - 234,599 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 493,959 $ 20,749 $ 504,624 $ 751,450 $ 446,171 $ 212,939 $ 2,010 $ - $ - $ 6,134 $ - $ - $ 2,333 - - - - - - - - - - - 4,343 - - 6,134 - - - - 284,004 - 234,599 - - - - - - - - - - - - - - - - - - - - - 284,004 - 234,599 - - $ - $ - $ - $ - $ - $ - 20,749 220,620 - 211,572 212,939 - - - 745,316 - - 489,616 - - - - - - - - - - - 489,616 20,749 220,620 745,316 211,572 212,939 493,959 $ 20,749 $ 504,624 $ 751,450 $ 446,171 $ 212,939 $ 124 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Uniroyal Goodrich GM 2015 GM 2015B GM 2015A GM 2015A TIF General Account Bond Bond Reserve Account 242,488 $ 590,750 $ 355 $ 583 $ 160,637 $ 8,000 19,490 - - 5,300 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 250,488 $ 610,240 $ 355 $ 583 $ 165,937 $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ 250,488 610,240 355 583 165,937 - - - - - - - - - - - - - - - 250,488 610,240 355 583 165,937 250,488 $ 610,240 $ 355 $ 583 $ 165,937 $ 125 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Nestle II Principal and GM 2015B Supplemental Vera Bradley Reserve Account Interest Account Reserve Account TIF TIF 59,361 $ 523 $ 242,749 $ 34,097 $ 209,108 $ 1,958 - 8,009 1,125 6,899 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 61,319 $ 523 $ 250,758 $ 35,222 $ 216,007 $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - $ - $ - $ - $ 61,319 523 250,758 35,222 216,007 - - - - - - - - - - - - - - - 61,319 523 250,758 35,222 216,007 61,319 $ 523 $ 250,758 $ 35,222 $ 216,007 $ 126 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Dupont Little River Bandalier Road East Group Delphi Oak Crossing Diebold Joint Drain TIF TIF TIF TIF Construction 551,479 $ 26,165 $ 534,294 $ 54,893 $ 30,077 $ 2,633,326 $ 18,194 17,627 1,811 - 86,878 - - - - - 845 - 445,461 744,433 75,926 - - - - - - - - 50 - - - - - - - - - - - - - - - - - - - - - - - 569,723 $ 471,626 $ 1,296,354 $ 132,630 $ 30,077 $ 2,721,049 $ - $ - $ - $ - $ - $ - $ - - - - - - - 1,249,894 - 1,727,701 - - - 1,249,894 - 1,727,701 - - - 445,461 744,433 75,926 - - - - - - - - - - - - - - - - - - - - - 445,461 744,433 75,926 - - - $ - $ - $ - $ - $ - $ 569,723 - 551,921 - 30,077 2,721,049 - - - - - - - - - - - - - (1,223,729) - (1,670,997) - - 569,723 (1,223,729) 551,921 (1,670,997) 30,077 2,721,049 569,723 $ 471,626 $ 1,296,354 $ 132,630 $ 30,077 $ 2,721,049 $ 127 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Airport Allen County Zubric Stonebridge III Expressway South Redevelopment Sur/Wheel Road TIF TIF Capital Tax Bridge TIF - $ - $ 6,583,337 $ 1,301,047 $ 154,883 $ - - 217,196 42,924 5,110 - - 2,102 - - 11,731 376,891 - - - - - - - - - - - - - - - - 16,534 - - - - - - - - 966,088 - - 11,731 $ 376,891 $ 7,768,723 $ 1,360,505 $ 159,993 $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - 11,731 376,891 - - - - - - - - - - - - - - - - - - 11,731 376,891 - - - - $ - $ 966,088 $ - $ - $ - - 6,802,635 1,360,505 159,993 - - - - - - - - - - - - - - - - - 7,768,723 1,360,505 159,993 11,731 $ 376,891 $ 7,768,723 $ 1,360,505 $ 159,993 $ 128 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Woodburn LOIT Dupont Road Coverdale US 24 Special Corner II TIF TIF TIF Distribution TIF 115,194 $ 114,506 $ 35,227 $ - $ 164,902 $ 3,800 3,778 1,162 - 5,440 - - - - - - 144,693 46,956 - 252,060 - - - - - - - - - - - - - - - - - - - - - - - - - 118,994 $ 262,977 $ 83,345 $ - $ 422,402 $ - $ - $ - $ - $ - $ - - - - - - - - - 959,494 - - - - 959,494 - 144,693 46,956 - 252,060 - - - - - - - - - - - - - - - - 144,693 46,956 - 252,060 - $ - $ - $ - $ - $ 118,994 118,284 36,389 - - - - - - - - - - - - - - - - (789,152) 118,994 118,284 36,389 - (789,152) 118,994 $ 262,977 $ 83,345 $ - $ 422,402 $ 129 ---PAGE BREAK--- ALLEN COUNTY COMBINING BALANCE SHEET- NON-MAJOR GOVERNMENTAL FUNDS December 31, 2021 (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 - commercial vehicle excise taxes Unavailable revenue - financial institution 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 Stonebridge TIF Totals 51,931 $ 76,239,201 $ 1,713 2,455,748 - 14,928 171,566 19,279,306 - 480,368 - 26,178 - 2,378,238 - 106,718 - 966,088 225,210 $ 101,946,773 $ - $ 2,523,434 $ - 581,598 2,941,761 8,026,954 2,941,761 11,131,986 171,566 14,346,437 - 31,531 - 47,700 - 3,621,840 171,566 18,047,508 - $ 966,088 - 75,349,032 - 3,312,824 - 810,969 (2,888,117) (7,671,634) (2,888,117) 72,767,279 225,210 $ 101,946,773 $ 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, 2021 Local Juvenile Income Tax - County Local Road Service of County Detention Public Safety Highway and Street Process Health Alternative Grant Revenues: Taxes 4,808,151 $ 2,710,410 $ - $ - $ 3,040,706 $ - $ Special assessments - - - - - - Licenses and permits - - - - - - Intergovernmental - 11,888,344 3,267,076 - 621,151 55,945 Charges for services - 520,557 - - 1,998,116 - Fines and forfeits - - - 223,815 - - Other - 206,258 18 - 23,964 9 Total revenues 4,808,151 15,325,569 3,267,094 223,815 5,683,937 55,954 Expenditures: Current: General government - - - - - - Public safety 4,214,333 - - 195,719 - 55,805 Highways and streets - 12,881,160 2,346,882 - - - Sanitation - - - - - - Economic development - - - - - - Health and welfare - - - - 4,972,236 - Culture and recreation - - - - - - Debt service: Principal - - - - - - Interest - - - - - - Capital outlay: Economic development - - - - - - Special assessment - - - - - - Total expenditures 4,214,333 12,881,160 2,346,882 195,719 4,972,236 55,805 Excess (deficiency) of revenues over (under) expenditures 593,818 2,444,409 920,212 28,096 711,701 149 Other financing sources (uses): Transfers in - - - - - - Transfers out - - - - - - Total other financing sources and (uses) - - - - - - Net change in fund balances 593,818 2,444,409 920,212 28,096 711,701 149 Fund balances - beginning 1,446,813 7,254,932 1,548,594 21,819 2,235,934 18,425 Fund balances - ending 2,040,631 $ 9,699,341 $ 2,468,806 $ 49,915 $ 2,947,635 $ 18,574 $ 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, 2021 (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 Juvenile Adult Probation Accident Surveyor's Corner Firearms County Probation Services Services Report Perpetuation Training Extradition - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - - - - 71,710 717,621 27,728 438,528 37,452 29,900 - - - - - - 595 2,033 49 - 27 30 72,305 719,654 27,777 438,528 37,479 29,930 - - - 155,116 - - 52,034 522,622 7,156 - 29,556 11,565 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 52,034 522,622 7,156 155,116 29,556 11,565 20,271 197,032 20,621 283,412 7,923 18,365 - - - - - - - - - - - - - - - - - - 20,271 197,032 20,621 283,412 7,923 18,365 103,533 335,061 7,871 1,257,687 46,610 (1,033) 123,804 $ 532,093 $ 28,492 $ 1,541,099 $ 54,533 $ 17,332 $ 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, 2021 (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 Recorders Enforcement Records Drainage Jail Local Health County Continuing County Perpetuation Maintenance Commissary Maintenance User Fee Education Corrections - $ - $ - $ - $ - $ - $ - $ - 1,147,780 - - - - - - - - - - - - - - - 72,672 - - 218,074 1,424,535 - 3,181,833 103,385 - 7,499 - - - - - 39,124 - - 6,441 816 - 191 - - - 1,430,976 1,148,596 3,181,833 176,248 39,124 7,499 218,074 921,067 907,861 - - 32,080 - - - - 2,831,964 - - 1,554 48,222 - - - - - - - - - - - - - - - - - - - - - - - - 146,520 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 921,067 907,861 2,831,964 146,520 32,080 1,554 48,222 509,909 240,735 349,869 29,728 7,044 5,945 169,852 - - - - - - - - - (37,000) - - - - - - (37,000) - - - - 509,909 240,735 312,869 29,728 7,044 5,945 169,852 1,649,491 6,136,392 1,055,249 21,034 72,730 22,053 34,240 2,159,400 $ 6,377,127 $ 1,368,118 $ 50,762 $ 79,774 $ 27,998 $ 204,092 $ 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, 2021 (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 Emergency Vehicle Community Corrections - Deterrent Recreation Planning and Title Corrections Home Detention Program Narcotics Nonreverting Right to Know Inspection - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - 3,965,972 - - - - 17,686 - - 2,512,775 133,532 105,029 188,483 - 3,396 - - - - - - - - 107,238 - - 2,198 9 - 3,965,972 2,620,013 133,532 105,029 190,681 17,695 3,396 - - - - - - - 3,974,403 2,317,898 119,525 60,000 - 1,286 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 376,298 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 3,974,403 2,317,898 119,525 60,000 376,298 1,286 - (8,431) 302,115 14,007 45,029 (185,617) 16,409 3,396 - - - - - - - - - - - - - - - - - - - - - (8,431) 302,115 14,007 45,029 (185,617) 16,409 3,396 (109,167) 1,125,709 2,801 83,469 751,776 272,442 12,644 (117,598) $ 1,427,824 $ 16,808 $ 128,498 $ 566,159 $ 288,851 $ 16,040 $ 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, 2021 (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 Supplemental Court Record Drug Free Public Defender Check and Public Appointed Check Plat Book Community Services Connect Information Special Advocate - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - - - 23,736 100,866 - 579,882 30,638 201,851 - 240 - 258,207 - - - 134,589 72,533 - - - 2,517 20 - 4 - 18,385 34 33,155 201,871 134,589 96,513 100,866 276,592 579,916 - 173,869 - - - 359,636 444,257 48,057 - 151,703 69,678 174,565 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 48,057 173,869 151,703 69,678 174,565 359,636 444,257 (14,902) 28,002 (17,114) 26,835 (73,699) (83,044) 135,659 - - - - - - - - - - - - - - - - - - - - - (14,902) 28,002 (17,114) 26,835 (73,699) (83,044) 135,659 84,080 439,209 160,970 241,004 - 327,110 344,748 69,178 $ 467,211 $ 143,856 $ 267,839 $ (73,699) $ 244,066 $ 480,407 $ 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, 2021 (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 Park and Indiana Law Department County Law Prosecutor Tax Recreation Enforcement of Planning Statewide 911 Enforcement PCA Sale Fee Gift Assist Grant Services - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - 3,000,574 74,846 11,658 - - 1,038 - - - - 93,843 - - 145,691 - - - - - - - 65 - 97 - 117,398 - 38 3,000,639 74,846 11,755 93,843 117,398 1,038 145,729 - - - 135,249 - - 69,390 3,000,573 36,970 - - - 14,128 - - - - - - - - - - - - - - - - - - - - - - - - 26,454 - - - - - - - - 2,831 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 3,000,573 36,970 26,454 135,249 2,831 14,128 69,390 66 37,876 (14,699) (41,406) 114,567 (13,090) 76,339 - - - - - - - - - - - - - - - - - - - - - 66 37,876 (14,699) (41,406) 114,567 (13,090) 76,339 10,467 70,347 24,173 425,446 206,539 13,090 519,698 10,533 $ 108,223 $ 9,474 $ 384,040 $ 321,106 $ - $ 596,037 $ 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, 2021 (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 Medical Care Chemical Infraction Court Court Corona Virus for Inmates Testing Jury Fee Deferral Fee ADR Plan ADR Plan Relief - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - - - 445,095 - - - 82,516 11 - 350 - - - - - 29,994 741,181 18,415 11,870 - - - 1,143 12,749 - - - 82,516 11 31,137 1,199,375 18,415 11,870 - - - 33,521 - 3,135 6,670 - 59,564 - - 901,253 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 59,564 - 33,521 901,253 3,135 6,670 - 22,952 11 (2,384) 298,122 15,280 5,200 - - - - - - - - - - - - - - (292,280) - - - - - - (292,280) 22,952 11 (2,384) 298,122 15,280 5,200 (292,280) 15,310 43,391 4,524 537,135 55,119 34,654 292,280 38,262 $ 43,402 $ 2,140 $ 835,257 $ 70,399 $ 39,854 $ - $ 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, 2021 (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 IOCS Campaign Community Clerk Alcohol Problem Finance Surveyor's Federal Transitions Record and Drug Solving Grant Enforcement Petition Asset Seizure Program Perpetuation User Fees - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - - - - 261,600 943 111,202 9,621 - - - - - 268,950 - 7,331 - - - 223,354 447,379 - - - 24,225 - 4 4,651 9,621 7,331 - 24,225 261,600 224,301 832,182 14,041 - - - - 213,998 - - - - 55,220 94,324 - 977,268 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 14,041 - - 55,220 94,324 213,998 977,268 (4,420) 7,331 - (30,995) 167,276 10,303 (145,086) - - - - - - - - - - - - - - - - - - - - - (4,420) 7,331 - (30,995) 167,276 10,303 (145,086) 10,802 16,110 7,451 125,758 247 1,354,694 260,168 6,382 $ 23,441 $ 7,451 $ 94,763 $ 167,523 $ 1,364,997 $ 115,082 $ 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, 2021 (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 Prosecutor's Tangible Youth Sales Levy Children's Federal Sheriff Incentive Services Per Disclosure Excess Home Gift Asset Seizure Donation Program Diem Fees - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - - - - - - - 94,035 - - - 1,900 - 675,137 - - - - - - - 1,260 - 2,861 41 1,536 6,250 1,912 95,295 - 2,861 41 3,436 6,250 677,049 15,740 - - - - - - - - - - - 14,722 - - - - - - - - - - - - - - - - - - - - - - - - 1,781 - - - 831,722 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 15,740 - 1,781 - - 14,722 831,722 79,555 - 1,080 41 3,436 (8,472) (154,673) - - - - - - - - (62,717) - - - - - - (62,717) - - - - - 79,555 (62,717) 1,080 41 3,436 (8,472) (154,673) 291,497 62,717 40,220 13,378 17,347 9,657 629,013 371,052 $ - $ 41,300 $ 13,419 $ 20,783 $ 1,185 $ 474,340 $ 139 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2021 (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 Juvenile Center Check Adult Improvement Tobacco Per Diem Deception Protective Unsafe Project Master Plan Fees Program Services Building Allen-CIP-FY-03/04 Program - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - 438,311 - 13,515 123,989 233,439 - - 478,920 - - - 236 - - - - 3,180 - - - - - 236,619 236 438,311 478,920 13,515 123,989 - - - - 11,967 - 123,218 1,797 438,302 384,881 - - - - - - - - - - - - - - - - - - - - - - - - - 109,630 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 123,218 1,797 438,302 384,881 11,967 109,630 113,401 (1,561) 9 94,039 1,548 14,359 - - - - - - - - - - - - - - - - - - 113,401 (1,561) 9 94,039 1,548 14,359 445,573 1,561 238,127 1,627 15,325 558,974 $ - $ - $ 332,166 $ 3,175 $ 29,684 $ 140 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2021 (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 Allen County Great Prevention and Enhanced Courts Foreign Lakes Treatment Access - Electronic Map Language COVID 19 Restoration Program Recorder Generation Interpreter Donation - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - 4,117 50,994 - - 254,000 - - - 45,060 30 - - - - - - - - - - 9 119 - 30,828 4,117 50,994 45,069 149 254,000 30,828 4,717 - - 300 253,314 - - - - - - - - - - - - - - - - - - - - - - - - - - 50,994 - - - 33,495 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 4,717 50,994 - 300 253,314 33,495 (600) - 45,069 (151) 686 (2,667) - - - - - - - - - - - - - - - - - - (600) - 45,069 (151) 686 (2,667) 600 4 - 33,709 (681) - - $ 4 $ 45,069 $ 33,558 $ 5 $ (2,667) $ 141 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2021 (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 Sheriff NE Identification COVID 19 Legal Jury Fee Department Indiana Security Comm Based On-site Education Circuit Court Training Trails Protection Testing Site Septic System Opportunity - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - - - - 332,454 - 7,500 - - - 87,694 - 122,400 - 11,605 - - - - - - 13 101 8,086 - - 350 - 11,618 101 8,086 87,694 332,454 122,750 7,500 - - 3,453 75,000 - - 15,119 - - - - - - - - - - - - - - - - - - - 135,207 - - - - - - - - - - - - 505,669 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 3,453 75,000 505,669 135,207 15,119 11,618 101 4,633 12,694 (173,215) (12,457) (7,619) - - - - - - - - - - - - (10,000) - - - - - - (10,000) - 11,618 101 4,633 12,694 (173,215) (22,457) (7,619) 2,727 1,509 16,668 126,546 283,430 124,674 7,619 14,345 $ 1,610 $ 21,301 $ 139,240 $ 110,215 $ 102,217 $ - $ 142 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2021 (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 ISDH Stellar Volunteer PSC COVID 19 COVID 19 Sex/Violent Immunization Regional Advocates For Chemical Phase III Routine Offender Grant Rural Dev Seniors Testing OCRA Vaccine Admin - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - 72,912 14,946 75,000 - 143,230 53,560 - - - - - - - 28,484 - - - 3,064 - - - - - 99 - - - 194 72,912 14,946 75,099 3,064 143,230 53,560 28,678 - - 77,354 - - - - - - - - - - 21,783 - - - - - - - - - - - - - - - 15,026 - - - - - 72,912 - - - 143,230 53,935 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 72,912 15,026 77,354 - 143,230 53,935 21,783 - (80) (2,255) 3,064 - (375) 6,895 - - - - - - - - - - - - - - - - - - - - - - (80) (2,255) 3,064 - (375) 6,895 - - 1,799 - - - 48,401 - $ (80) $ (456) $ 3,064 $ - $ (375) $ 55,296 $ 143 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2021 (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 Criminal Alien Problem Auditor's Sheriff IJC OVWI Assistance Solving Ineligible Training Veterans Cir Crt GIS Program Court Deductions Center Court Interpreter Infrastructure - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - 30,000 - - - 1,469 197,500 - - 875 152,762 - - - - - - - - - - - 1,020 410 337 - - 394 - 31,020 1,285 153,099 - 1,469 197,894 - - 49,040 - - 5,068 395,000 6,909 28,026 - 150,000 206 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 6,909 28,026 49,040 150,000 206 5,068 395,000 (6,909) 2,994 (47,755) 3,099 (206) (3,599) (197,106) - 10,000 - - - - 197,500 - - - - (10,000) - - - 10,000 - - (10,000) - 197,500 (6,909) 12,994 (47,755) 3,099 (10,206) (3,599) 394 19,809 25,303 134,754 6,271 10,206 - 60,273 12,900 $ 38,297 $ 86,999 $ 9,370 $ - $ (3,599) $ 60,667 $ 144 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2021 (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 Solid Waste DUI Fines Court Law Probation Syringe User Task Force MS4 Public Collections Clerk Grant Service Prog Fees Enforcement Education - $ - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - 60,691 399,740 64,908 4,999 15,642 - 3,375 - - - 1,363,161 - - - - - - - - - - 130 - - 18,017 - 4,000 3,375 60,821 399,740 64,908 1,386,177 15,642 4,000 - 56,492 - - - - - - - 403,449 - - 23,641 - - - - - - - - - - - - 1,458,611 - 3,521 - - - - - - - - - - 66,691 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 56,492 403,449 66,691 1,458,611 23,641 3,521 3,375 4,329 (3,709) (1,783) (72,434) (7,999) 479 - - - - - - - - - - - - - - - - - - - - - 3,375 4,329 (3,709) (1,783) (72,434) (7,999) 479 32,567 31,987 (13,321) - 2,326,579 2,782 - 35,942 $ 36,316 $ (17,030) $ (1,783) $ 2,254,145 $ (5,217) $ 479 $ 145 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2021 (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 Family County Prosc IV-D Clerk IV-D Elected County Offender Recovery IV-D Incentive Incentive Official Training Transportation Court Incentive Post 10/99 Post 10/99 - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - 14,573 194,705 292,929 194,705 87,694 3,475 - - - - - - - - - - 1,632 - - 146 865 1,616 89,326 3,475 14,573 194,851 293,794 196,321 9,708 - 16,115 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 238,056 417,001 68,410 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 9,708 - 16,115 238,056 417,001 68,410 79,618 3,475 (1,542) (43,205) (123,207) 127,911 - - - - - - - - - - - - - - - - - - 79,618 3,475 (1,542) (43,205) (123,207) 127,911 439,677 27,565 13,536 44,633 239,126 390,998 519,295 $ 31,040 $ 11,994 $ 1,428 $ 115,919 $ 518,909 $ 146 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2021 (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 Reassessment County General Drain Great Batch Special COIT - Dupont 2015 Bond Improvement TIF Flood Control Diebold TIF 577,080 $ - $ - $ 205,301 $ - $ 507,280 $ - - 23,350 - - - - - - - - - 72,607 - - - - - - - - - - - - - - - - - 4,168 - 27,275 321 397 1,628 653,855 - 50,625 205,622 397 508,908 671,747 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 700,000 - - 717,844 - - - 671,747 - 717,844 - - 700,000 (17,892) - (667,219) 205,622 397 (191,092) - - 735,563 - - - - (45,488) - (5,198) - - - (45,488) 735,563 (5,198) - - (17,892) (45,488) 68,344 200,424 397 (191,092) 1,194,725 45,488 1,784,594 (72,145) 320,956 750,058 1,176,833 $ - $ 1,852,938 $ 128,279 $ 321,353 $ 558,966 $ 147 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2021 (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 Cumulative Lafayette Community Capital CASAD Nestle TIF Center Development Development East TIF Major Bridge II Bond Corner TIF Argo Drain Corporation 3,097,341 $ 2 $ 3,814,450 $ 129,612 $ - $ - $ - $ - - - - - - - - - - - - - - 391,120 - 487,983 - - - - - - - - - - - - - - - - - - 37,091 1,064 191,049 1,192 2,233 570 362,184 3,525,552 1,066 4,493,482 130,804 2,233 570 362,184 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 1,235,000 - - - - - - 582,000 - - - - 5,201,696 - 2,810,749 550 - - 137,617 - - - - - - - 5,201,696 - 4,627,749 550 - - 137,617 (1,676,144) 1,066 (134,267) 130,254 2,233 570 224,567 - - - - - - - - - - (81,000) - - - - - - (81,000) - - - (1,676,144) 1,066 (134,267) 49,254 2,233 570 224,567 10,552,578 (878,201) 5,898,997 366,172 2,305 160,613 265,049 8,876,434 $ (877,135) $ 5,764,730 $ 415,426 $ 4,538 $ 161,183 $ 489,616 $ 148 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2021 (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 Tax Woodburn Lincoln Uniroyal Mossman Diebold Abatement Industrial Industrial Goodrich GM 2015 Drain Corner TIF Development TIF TIF TIF General Account - $ 208,938 $ - $ 228,386 $ - $ - $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 69 138 44,285 394 754 831 2,078 69 209,076 44,285 228,780 754 831 2,078 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 45,260 140,000 - 32,356 - - - - - - - - - - 45,260 140,000 - 32,356 - 69 209,076 (975) 88,780 754 (31,525) 2,078 - - - - - - - - - (169,622) - - - - - - (169,622) - - - - 69 209,076 (170,597) 88,780 754 (31,525) 2,078 20,680 11,544 915,913 122,792 212,185 282,013 608,162 20,749 $ 220,620 $ 745,316 $ 211,572 $ 212,939 $ 250,488 $ 610,240 $ 149 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2021 (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 2015B GM 2015A GM 2015A Nestle II Principal and GM 2015B Bond Bond Reserve Account Reserve Account Interest Account Reserve Account - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 587 217 254 887 - - 587 217 254 887 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 70,000 - - - 78,769 - - - - - - - - - - - - - - - - - 148,769 - - - 587 217 (148,515) 887 - - - - 81,000 - - - - - - - - - - - 81,000 - - - 587 217 (67,515) 887 355 583 165,350 61,102 68,038 249,871 355 $ 583 $ 165,937 $ 61,319 $ 523 $ 250,758 $ 150 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2021 (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 GM Bluffton Supplemental Vera Bradley Little River Bandalier Road East Group Delphi Oak Crossing TIF TIF Joint Drain TIF TIF TIF TIF - $ - $ 2 $ 690,315 $ 80,956 $ - $ - - 50 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 125 763 1,995 1,672 646 133 107 125 763 2,045 1,674 690,961 81,089 107 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 267,179 - - - - 5,998 - - - - - - 5,998 - 267,179 - - 125 763 (3,953) 1,674 423,782 81,089 107 - - - - - - - - - - - - (90,803) - - - - - - (90,803) - 125 763 (3,953) 1,674 423,782 (9,714) 107 35,097 215,244 573,676 (1,225,403) 128,139 (1,661,283) 29,970 35,222 $ 216,007 $ 569,723 $ (1,223,729) $ 551,921 $ (1,670,997) $ 30,077 $ 151 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2021 (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 Dupont Airport Allen County Zubric Diebold Stonebridge III Expressway South Redevelopment Sur/Wheel Road Construction TIF TIF Capital Tax Bridge TIF - $ - $ - $ - $ - $ - $ - - - - - - - - - - - - - - - - 214,937 - - - - - - - - - - - - - 2,545,066 - - 23,343 3,911 566 2,545,066 - - 23,343 218,848 566 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 295,491 - - 29,353 110,257 - - - - - - - 295,491 - - 29,353 110,257 - 2,249,575 - - (6,010) 108,591 566 - - - - - - - - - - - - - - - - - - 2,249,575 - - (6,010) 108,591 566 471,474 - - 7,774,733 1,251,914 159,427 2,721,049 $ - $ - $ 7,768,723 $ 1,360,505 $ 159,993 $ 152 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2021 (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 Woodburn LOIT Dupont Road Coverdale US 24 Special Corner Stonebridge II TIF TIF TIF Distribution TIF TIF - $ 118,284 $ 40,051 $ - $ 245,307 $ 97,949 $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 421 - 82 100 338 64 421 118,284 40,133 100 245,645 98,013 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 62,103 50,000 76,657 80,000 - - - - - - - - 62,103 50,000 76,657 80,000 - 421 56,181 (9,867) (76,557) 165,645 98,013 - - - - - - - - - - (61,084) (119,998) - - - - (61,084) (119,998) 421 56,181 (9,867) (76,557) 104,561 (21,985) 118,573 62,103 46,256 76,557 (893,713) (2,866,132) 118,994 $ 118,284 $ 36,389 $ - $ (789,152) $ (2,888,117) $ 153 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES- NON-MAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2021 (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 Totals 20,600,521 $ 1,171,180 - 28,941,396 15,972,438 1,964,490 3,875,610 72,525,635 5,130,024 21,623,879 15,228,042 1,597,339 15,026 7,738,736 379,129 1,305,000 660,769 10,039,268 723,842 64,441,054 8,084,581 1,024,063 (985,190) 38,873 8,123,454 - 64,643,825 72,767,279 $ 154 ---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 3,501,070 $ 797,558 $ 55,230 $ 111,949 $ 255,756 $ 4,721,563 $ Investments 115,507 26,313 1,822 3,693 8,438 155,773 Interest receivable 715 266 - 51 72 1,104 Accounts receivable (net of allowance) - 176 - - 41,841 42,017 Total assets 3,617,292 824,313 57,052 115,693 306,107 4,920,457 Liabilities Current liabilities: Accounts payable 240,087 - 36,904 2,474 79,176 358,641 Incurred but not reported claims 2,101,884 - - - - 2,101,884 Total liabilities 2,341,971 - 36,904 2,474 79,176 2,460,525 Net Position Unrestricted 1,275,321 824,313 20,148 113,219 226,931 2,459,932 Total net position 1,275,321 $ 824,313 $ 20,148 $ 113,219 $ 226,931 $ 2,459,932 $ ALLEN COUNTY COMBINING STATEMENT OF NET POSITION - INTERNAL SERVICE FUNDS December 31, 2021 155 ---PAGE BREAK--- County Workmans Self-Insurance Vehicle Liability Compensation Internal Health Self-Insurance Insurance Self-Insurance Reimbursement Totals Operating revenues: Miscellaneous - $ - $ 9,390 $ 4,132 $ 49,263 $ 62,785 $ Employee/employer contributions 11,469,541 305,114 298,110 1,299,500 965,695 14,337,960 Total operating revenues 11,469,541 305,114 307,500 1,303,632 1,014,958 14,400,745 Operating expenses: Insurance claims and expenses 13,085,278 414,115 404,171 1,253,733 1,104,271 16,261,568 Operating income (loss) (1,615,737) (109,001) (96,671) 49,899 (89,313) (1,860,823) Nonoperating revenues: Interest and investment revenue 8,250 3,121 - 789 837 12,997 Change in net position (1,607,487) (105,880) (96,671) 50,688 (88,476) (1,847,826) Total net position - beginning 2,882,808 930,193 116,819 62,531 315,407 4,307,758 Total net position - ending 1,275,321 $ 824,313 $ 20,148 $ 113,219 $ 226,931 $ 2,459,932 $ ALLEN COUNTY COMBINING STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN NET POSITION - INTERNAL SERVICE FUNDS For The Year Ended December 31, 2021 156 ---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,469,541 $ 314,123 $ 300,000 $ 1,299,500 $ 1,107,119 $ 14,490,283 $ Payments to suppliers (13,378,647) (423,038) (404,032) (1,256,701) (1,073,512) (16,535,930) Other receipts - - 9,390 4,132 7,422 20,944 Net cash provided (used) by operating activities (1,909,106) (108,915) (94,642) 46,931 41,029 (2,024,703) Cash flows from investing activities: Proceeds from sales and maturities of investments 40,470 20,843 - - 3,861 65,174 Purchase of investments (115,507) (26,313) (1,822) (3,693) (8,438) (155,773) Interest received 8,318 3,258 - 738 840 13,154 Net cash provided (used) by investing activities (66,719) (2,212) (1,822) (2,955) (3,737) (77,445) Net increase (decrease) in cash and cash equivalents (1,975,825) (111,127) (96,464) 43,976 37,292 (2,102,148) Cash and cash equivalents, January 1 5,476,895 908,685 151,694 67,973 218,464 6,823,711 Cash and cash equivalents, December 31 3,501,070 $ 797,558 $ 55,230 $ 111,949 $ 255,756 $ 4,721,563 $ Reconciliation of operating income (loss) to net cash provided (used) by operating activities: Operating income (loss) (1,615,737) $ (109,001) $ (96,671) $ 49,899 $ (89,313) $ (1,860,823) $ Adjustments to reconcile operating income (loss) to net cash provided (used) by operating activities: (Increase) decrease in assets: Accounts receivable - 9,009 1,890 - 99,583 110,482 Increase (decrease) in liabilities: Accounts payable (245,800) (8,923) 139 (2,968) 30,759 (226,793) Incurred but not reported claims (47,569) - - - - (47,569) Total adjustments (293,369) 86 2,029 (2,968) 130,342 (163,880) Net cash provided (used) by operating activities (1,909,106) $ (108,915) $ (94,642) $ 46,931 $ 41,029 $ (2,024,703) $ ALLEN COUNTY COMBINING STATEMENT OF CASH FLOWS - INTERNAL SERVICE FUNDS For The Year Ended December 31, 2021 157 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF FIDUCIARY NET POSITION- CUSTODIAL FUNDS December 31, 2021 Tax Sale Tax Sale Assets Redemption Surplus Court Fees Cash and cash equivalents 14,842 $ 4,880,502 $ 60,444 $ Receivables: Accounts - - 41,555 Interest - - - Taxes for other governments - - - Total receivables - - 41,555 Investments at fair value: U.S. Government securities 490 161,017 1,995 Total assets 15,332 $ 5,041,519 $ 103,994 $ Liabilities Accounts payable and other liabilities - $ - $ - $ Due to other governments - - - Total liabilities - - - Deferred Inflows of Resources Unavailable Revenue - $ - $ - $ Net Position Restricted for: Individuals, organizations, and other governments 15,332 5,041,519 103,994 Total net position 15,332 $ 5,041,519 $ 103,994 $ 158 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF FIDUCIARY NET POSITION- CUSTODIAL FUNDS December 31, 2021 (Continued) Assets Cash and cash equivalents Receivables: Accounts Interest Taxes for other governments Total receivables Investments at fair value: U.S. Government securities Total assets Liabilities Accounts payable and other liabilities Due to other governments Total liabilities Deferred Inflows of Resources Unavailable Revenue Net Position Restricted for: Individuals, organizations, and other governments Total net position County Treasurer Youth Sheriff's Bid Bond Surplus Tax Tax Funds Services Trust Inmate Trust 5,373 $ 1,744,340 $ 14,253,992 $ 99,947 $ 219,846 $ - - - - - - - - 31 - - - 491,643,026 - - - - 491,643,026 31 - 177 57,549 - 3,297 - 5,550 $ 1,801,889 $ 505,897,018 $ 103,275 $ 219,846 $ - $ - $ - $ - $ - $ - - 40,685,623 - - - - 40,685,623 - - - $ - $ 386,337,212 $ - $ - $ 5,550 1,801,889 78,874,183 103,275 219,846 5,550 $ 1,801,889 $ 78,874,183 $ 103,275 $ 219,846 $ 159 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF FIDUCIARY NET POSITION- CUSTODIAL FUNDS December 31, 2021 (Continued) Assets Cash and cash equivalents Receivables: Accounts Interest Taxes for other governments Total receivables Investments at fair value: U.S. Government securities Total assets Liabilities Accounts payable and other liabilities Due to other governments Total liabilities Deferred Inflows of Resources Unavailable Revenue Net Position Restricted for: Individuals, organizations, and other governments Total net position County Work County Adult Juvenile Recorder Release Clerk Probation Probation Totals 64,473 $ - $ 3,415,717 $ 28,024 $ 10,250 $ 24,797,750 $ - - - - - 41,555 - - - - - 31 - - - - - 491,643,026 - - - - - 491,684,612 - - - - - 224,525 64,473 $ - $ 3,415,717 $ 28,024 $ 10,250 $ 516,706,887 $ - $ - $ - $ - $ 4,714 $ 4,714 $ - - - - - 40,685,623 - - - - 4,714 40,690,337 - $ - $ - $ - $ - $ 386,337,212 $ 64,473 - 3,415,717 28,024 5,536 89,679,338 64,473 $ - $ 3,415,717 $ 28,024 $ 5,536 $ 89,679,338 $ 160 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF CHANGES IN FIDUCIARY NET POSITION- CUSTODIAL FUNDS December 31, 2021 Tax Sale Tax Sale Redemption Surplus Court Fees Bid Bond Surplus Tax Additions Investment income: Net increase (decrease) in fair value of investments - $ - $ - $ - $ - $ Interest, dividends and other - - - - - Net investment income - - - - - Collections: Taxes for other governments - - - - - Taxes for individuals/organizations 5,603,306 6,931,488 - - 1,530,736 Fines/Fees/Restitution - - 761,828 - - Miscellaneous - - - 2,500 - Total Collections 5,603,306 6,931,488 761,828 2,500 1,530,736 Total additions 5,603,306 6,931,488 761,828 2,500 1,530,736 Deductions Payments of tax to other governments - $ - $ 767,320 $ - $ - $ Payments to individuals and organizations 5,700,519 5,824,143 - 2,500 3,294,527 Total deductions 5,700,519 5,824,143 767,320 2,500 3,294,527 Net increase (decrease) in fiduciary net position (97,213) 1,107,345 (5,492) - (1,763,791) Net position - beginning 112,545 3,934,174 109,486 5,550 3,565,680 Net position - ending 15,332 $ 5,041,519 $ 103,994 $ 5,550 $ 1,801,889 $ 161 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF CHANGES IN FIDUCIARY NET POSITION- CUSTODIAL FUNDS December 31, 2021 (Continued) Additions Investment income: Net increase (decrease) in fair value of investments Interest, dividends and other Net investment income Collections: Taxes for other governments Taxes for individuals/organizations Fines/Fees/Restitution Miscellaneous Total Collections Total additions Deductions Payments of tax to other governments Payments to individuals and organizations Total deductions Net increase (decrease) in fiduciary net position Net position - beginning Net position - ending Youth County Treasurer Services Sheriff's County Work Tax Funds Trust Inmate Trust Recorder Release - $ - $ - $ - $ - $ - 352 - - - - 352 - - - 624,017,638 - - - - - - - - - - - - 2,747,336 - - - 2,780,377 - - 624,017,638 - 2,780,377 2,747,336 - 624,017,638 352 2,780,377 2,747,336 - 560,130,831 $ - $ - $ - $ - $ - - 2,692,700 2,730,346 132 560,130,831 - 2,692,700 2,730,346 132 63,886,807 352 87,677 16,990 (132) 14,987,376 102,923 132,169 47,483 132 78,874,183 $ 103,275 $ 219,846 $ 64,473 $ - $ 162 ---PAGE BREAK--- ALLEN COUNTY COMBINING STATEMENT OF CHANGES IN FIDUCIARY NET POSITION- CUSTODIAL FUNDS December 31, 2021 (Continued) Additions Investment income: Net increase (decrease) in fair value of investments Interest, dividends and other Net investment income Collections: Taxes for other governments Taxes for individuals/organizations Fines/Fees/Restitution Miscellaneous Total Collections Total additions Deductions Payments of tax to other governments Payments to individuals and organizations Total deductions Net increase (decrease) in fiduciary net position Net position - beginning Net position - ending County Adult Juvenile Clerk Probation Probation Totals - $ - $ - $ - $ - - - 352 - - - 352 - - - 624,017,638 - - - 14,065,530 29,992,453 112,090 95,970 33,709,677 - - - 2,782,877 29,992,453 112,090 95,970 674,575,722 29,992,453 112,090 95,970 674,576,074 - $ - $ - $ 560,898,151 $ 29,626,759 119,117 96,293 50,087,036 29,626,759 119,117 96,293 610,985,187 365,694 (7,027) (323) 63,590,887 3,050,023 35,051 5,859 26,088,451 3,415,717 $ 28,024 $ 5,536 $ 89,679,338 $ 163 ---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/. 164