Illustrative Comprehensive Annual Financial Report

1 AppendixIllustrative ComprehensiveAnnual Financial ReportRELATIONSHIP OF APPENDICESThe first four appendices illustrate the preparation of a Comprehensive Annual Financial Report (CAFR) pre-pared in conformity with the authoritative guidance issued by the Governmental Accounting StandardsBoard (GASB) and the requirements of the Government Finance Officers Association s Certificate ofAchievement for Excellence in Financial Reporting Program. Illustrative journal entries (Appendix A).This appendix illustrates the different types of journal entriesused to collect data in the government s fund-based accounting system. Illustrative trial balances (Appendix B).This appendix provides 1) a trial balance as of the beginning ofthe current fiscal year, 2) a preclosing trial balance, and 3) a trial balance as of the end of the current fis-cal year for each of the funds for which Illustrative journal entries are provided in Appendix A. Illustrative adjustments worksheet (Appendix C).

2 This appendix illustrates how the data reported in gov-ernmental funds and internal service funds are converted and consolidated for presentation as gov-ernmental activities in the government-wide Financial statements. Illustrative CAFR (Appendix D).This appendix (available electronically at ) offers a complete Illustrative CAFR. The numbers in this Illustrative CAFR are supportedby the journal entries, trial balances, and adjustments worksheet provided in Appendices A, B, and page is intentionally OF GOVERNMENT, STATECOMPEREHENSIVE Annual Financial REPORTFor the fiscal year endedJune 30, 2022 Prepared by:Department of Finance and AdministrationGovernmental Accounting, Auditing, and Financial Reporting APPENDIX DThis page is intentionally Accounting, Auditing, and Financial Reporting APPENDIX DName of GovernmentComprehensive Annual Financial ReportFor the Fiscal Year Ended June 30, 2022 TABLE OF CONTENTS PageINTRODUCTORY SECTIONL etter of Transmittal 3 GFOA Certificate of Achievement 8 Organizational Chart 9 List of Elected and Appointed Officials 10 Financial SECTIONI ndependent Auditor s Report 13 Management s Discussion and Analysis 15 Basic Financial Statements:Government-wide Financial Statements.

3 Statement of Net Position 30 Statement of Activities 31 Fund Financial Statements:Balance Sheet - Governmental Funds 32 Reconciliation of the Balance Sheet - Governmental Funds to theGovernment-wide Statement of Net Position 33 Statement of Revenues, Expenditures, and Changes in FundBalances - Governmental Funds 34 Reconciliation of the Statement of Revenues, Expenditures, and Changes inFund Balances - Governmental Funds to the Government-wideStatement of Activities 35 Statement of Revenues, Expenditures, and Changes inFund Balances - Budget and Actual - General Fund 36 Statement of Net Position - Proprietary Funds 37 Statement of Revenues, Expenses, and Changes in NetPosition - Proprietary Funds 38 Statement of Cash Flows - Proprietary Funds 39 Statement of Fiduciary Net Position Fiduciary Funds 40 Statement of Changes in Fiduciary Net Position - Fiduciary Funds 41 Notes to the Financial Statements 43 Required Supplementary Information:Schedule of Funding Progress- Public Safety Employees Pension Plan 77 Schedule of Funding Progress- General Employees OtherPostemployment Benefits Plan 77 Combining and Individual Fund Financial Statements and Schedules.

4 Combining Balance Sheet - Nonmajor Governmental Funds 79 Combining Statement of Revenues, Expenditures, and Changesin Fund Balances - Nonmajor Governmental Funds 80 Schedule of Revenues, Expenditures, and Changes in FundBalance - Budget and Actual - Library Fund 81 Schedule of Revenues, Expenditures, and Changes in FundBalance - Budget and Actual - Debt Service Fund 82iGovernmental Accounting, Auditing, and Financial Reporting APPENDIX DSchedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual From Inceptionand for the Year Ended June 30, 2022 Capital Projects Fund 83 Combining Statement of Net Position Internal Service Funds 85 Combining Statement of Revenues, Expenses, and Changes in Net Position Internal Service Funds 86 Combining Statement of Cash Flows Internal Service Funds 87 Statement of Changes in Assets and Liabilities - Agency Fund 89 STATISTICAL SECTIONF inancial Trends:Net Position by Component 91 Changes in NetPosition 92 Fund Balances - Governmental Funds 94 Changes in Fund Balances - Governmental Funds 95 Revenue Capacity.

5 Assessed Value and Estimated Actual Value of Taxable Property 97 Property Tax Rates Direct and Overlapping Governments 98 Principal Property Taxpayers 99 Property Tax Levies and Collections 100 Debt Capacity:Ratios of Outstanding Debt by Type 101 Ratios of General Bonded Debt Outstanding 102 Direct and Overlapping Governmental Activities Debt 103 Legal Debt Margin Information 104 Pledged-Revenue Coverage 105 Demographic and Economic Information:Demographic and Economic Statistics 106 Principal Employers 107 Operating Information:Full-Time Equivalent Employees by Function 108 Operating Indicators by Function 109 Capital Asset Statistics by Function 110iiGovernmental Accounting, Auditing, and Financial Reporting APPENDIX DINTRODUCTORY SECTION1 Governmental Accounting, Auditing, and Financial Reporting APPENDIX DThis page is intentionally Accounting, Auditing, and Financial Reporting APPENDIX DLETTERHEAD OF GOVERNMENTN ovember 15, 2022To the Honorable Mayor, Members of the Governing Council and Citizens of the NAME OF GOV-ERNMENT.

6 State law requires that every general purpose local government publish, within six months of theclose of each fiscal year, a complete set of audited Financial statements. This Report is published tofulfill that requirement for the fiscal year ended June 30, assumes full responsibility for the completeness and reliability of the informationcontained in this Report , based upon a Comprehensive framework of internal control that it has es-tablished for this purpose. Because the cost of internal control should not exceed anticipated bene-fits, the objective is to provide reasonable, rather than absolute, assurance that the financialstatements are free of any material , Lee, Roberts & Co., Certified Public Accountants, have issued an unqualified ( clean )opinion on the NAME OF GOVERNMENT S Financial statements for the year ended June 30,2022. The independent auditor s Report is located at the front of the Financial section of this s discussion and analysis (MD&A) immediately follows the independent auditor sreport and provides a narrative introduction, overview, and analysis of the basic Financial state-ments.

7 MD&A complements this letter of transmittal and should be read in conjunction with of the governmentThe NAME OF GOVERNMENT, incorporated in 1866, is located in the eastern part of the state,which is considered to be one of the top growth areas in both the state and the country. It currentlyoccupies 10 square miles and serves a population of 57,468. The NAME OF GOVERNMENT isempowered to levy a property tax on real property located within its boundaries. It also is em-powered by state statute to extend its corporate limits by annexation, which it has done from timeto NAME OF GOVERNMENT has operated under the mayor-council form of government since1916, having been the first in the state to adopt this form of government. Policy-making and legis-lative authority are vested in the governing council (Council) consisting of the mayor and six othermembers, all of whom are elected at large. Council members serve four-year terms, with threemembers elected every two years.

8 The Mayor is elected for a four-year term. The Mayor, withCouncil approval, appoints the NAME OF GOVERNMENT s manager, who in turn appoints itsdepartment NAME OF GOVERNMENT provides a full range of services, including police and fire protec-tion; refuse collection; snow and leaf removal; traffic control; on- and off-street parking; building3 Governmental Accounting, Auditing, and Financial Reporting APPENDIX Dinspections; licenses and permits; vital statistics; the construction and maintenance of highways,streets, and other infrastructure; recreational and cultural activities; library services; low-incomehousing; and transit services. Water distribution services are provided through a legally separateWater Authority, which functions, in essence, as a department of the NAME OF GOVERNMENTand therefore has been included as an integral part of the NAME OF GOVERNMENT S financialstatements. The NAME OF GOVERNMENT also is financially accountable for a legally separateurban renewal agency and a legally separate cable television operation, both of which are re-ported separately within the NAME OF GOVERNMENT S Financial statements.

9 Additional infor-mation on all three of these legally separate entities can be found in the notes to the financialstatements (see note ).The Council is required to adopt an initial budget for the fiscal year no later than May 31 preced-ing the beginning of the fiscal year on July 1. This Annual budget serves as the foundation for theNAME OF GOVERNMENT S Financial planning and control. The budget is prepared by fund,function ( , public safety), and department ( , police). Department heads may transfer re-sources within a department as they see fit. Transfers between departments, however, need spe-cial approval from the governing economyThe NAME OF GOVERNMENT is a suburb in an affluent metropolitan area and functions as amajor commuter hub and suburban regional center. The NAME OF GOVERNMENT is headquar-ters for many corporations, and functions as a major regional shopping center for the metropoli-tan area. Major industries located within the government s boundaries or in close proximityinclude hospitals, manufacturers of computer hardware and software, retail stores, and several fi-nancial institutions and insurance companies.

10 The school district and NAME OF GOVERNMENT also have a significant economic presence, employing in total more than 2,300 teachers, profes-sionals, and support of its location in a region with a varied economic base, unemployment had been relativelystable until the effect of the current recession was felt during the current year. During the past tenyears, the unemployment rate rose from an initial low of percent (2013) to a decade high of for the current year (2022). Although unemployment rates have risen nationwide over thelast year, the NAME OF GOVERNMENT continues to experience unemployment rates consis-tently lower than national averages. The NAME OF GOVERNMENT s unemployment rate as ofJune 2022 was percent compared to percent nationally. The increases in unemploymentrates during the current year reflect the current recession. Additional increases may occur in thenear future. However, based on economic forecasts, a leveling off and subsequent decline in un-employment rates are anticipated in calendar year household incomes within the NAME OF GOVERNMENT are significantly higher thanfor the state as a whole.