The URL can be used to link to this page

Home My WebLink About112123-07.1 ADMINISTRATIVE STAFF REPORT 7.1 TO: Mayor and Town Council November 21, 2023 SUBJECT: Resolution No. 83-2023, accepting the Fiscal Year 2022/23 Audited Annual Comprehensive Financial Report for the Town of Danville BACKGROUND The Pun Group, LLP, has completed its examination of the financial statements for the Town of Danville and has approved the draft financial reports, including unqualified opinions, as to their accuracy. The draft audit is attached to this report and the Town Council is now being asked to accept the FY 2022/23 Annual Comprehensive Financial Report (ACFR). FORMAT OF TOWN’S FINANCIAL REPORT The ACFR is presented in compliance with Government Accounting Standards Board (GASB) Statement 31, Statement 34, Statement 40, Statement 44 and Statement 54. The ACFR is composed of three sections: Introductory, Financial and Statistical. • The Introductory Section familiarizes the reader with the Town and includes the Transmittal Letter, the Town’s organizational chart and a directory of public officials. • The Financial Section includes the Independent Auditor’s Report, Management’s Discussion and Analysis, Basic Financial Statements, Notes to the Basic Financial Statements, Required Supplementary Information (unaudited) and Supplemental Information. • The Statistical Section schedules are designed to show trends in five areas: financial, revenue capacity, debt capacity, demographic and economic information and operating information. GASB 34 presents financial information from two perspectives. The first perspective, the Government-Wide Financial Statements, located at the beginning of the Financial Section, groups the Town’s funds into major and non-major funds and presents them in this condensed format. The value of the Town’s long-term debt and the Town’s infrastructure, net of depreciation, is included in the Government-Wide Statement of Net Assets and the Statement of Activities and Changes in Net Assets. The second perspective, the Fund Financial Statements, includes the Governmental Funds Balance Sheet and the Statement of Revenues, Expenditures and Changes in Fund Balance, but omits long-term debt and the value of infrastructure. Reconciliation of the Government- Audited Annual Comprehensive Financial Report FY 2022/23 2 November 21, 2023 Wide Financial Statements and the Fund Financial Statements are presented after each of the Fund Financial Statements. Based on GASB criteria, the Town’s major funds are the General Fund and the Capital Improvement Project Fund. The Town has chosen to present the Lighting and Landscape Special Revenue Fund and Regional Traffic Impact Fees Special Revenue Fund and American Rescue Plan Act Special Revenue as major funds. Highlights of the Town’s accomplishments and fiscal activities are presented in the Transmittal Letter and Management Discussion and Analysis. ECONOMIC CONDITION OF DANVILLE’S GENERAL FUND General Fund The General Fund realized a net increase in fund balance of $1,263,782 (year over year 2021/22 to 2022/23). Revenues exceeded expenditures by $9,124,120 with net operating transfers to other funds of $8,076,594. Actual revenues exceeded final budgeted revenues by $4,377,213. General Fund expenditures were below budget by $2,147,148 with cost savings in most departments. These savings were largely attributable to several position vacancies that went unfilled and less expenditures in Recreation, Arts and Community Services as fewer classes, programs and activities were offered due to the pandemic. Note 10 of the Notes to Basic Financial Statements details the reserves and designations against the June 30, 2023 Fund Balance. The recommended designated reserves, described below, were reviewed by the Town Council Finance Committee on October 17, 2022, and by the Town Council at the November 14, 2023 Study Session. These will require approval and appropriation by the full Town Council through Resolution No. 83- 2023. TOWN FUND BALANCE Total reserves and designations amount to $22,093,906 (Table 1), a decrease of $775,382 from prior year reserves and designations of $22,868,906. It is recommended that the Town Council approve the following adjustments to fund balance reserves which are reflected in the FY 2022/23 ACFR. Audited Annual Comprehensive Financial Report FY 2022/23 3 November 21, 2023 Emergency Reserve Fund The recommended transfer of $2,948,948 to the Emergency Reserve Fund will assist with the funding of 2023 Storm related expenses. Other Reserves Against Fund Balance In addition to the above-designated reserves that require Town Council action to implement, the following reserves/designations are reflected in the ACFR. A number of these are carried over from prior fiscal years and are statutorily restricted. Table 1 General Fund Balance Analysis As of June 30, 2023 Total pre-audit Fund Balance at 6/30/23 $ 28,940,662 Unavailable-500 La Gonda Way Operating Fund (62,149) Adjusted for unrealized market value reported per GASB 31 $(3,114,469) Adjusted for unrealized leased income/loss reported per GASB 37 $ ( 721,576) Fund Balance without unrealized market value $ 25,042,468 Less Reserves/Designations against Fund Balance for: Operating Reserve $ 13,809,768 Receivable from former CDA $ 2,859,401 Compensated Absences/Personnel $ 1,465,232 Reserved for Debt Service $ 827,765 Contingency $ 782,066 Encumbrances $ 822,879 500 La Gonda Way – proceeds from rent $ 1,516,413 Reward Fund $ 10,000 Total Reserves/Designations against Fund Balance $ 22,093,524 Current Unreserved/Undesignated Fund Balance at 6/30/23 $ 2,948,948 Recommended Fund Balance Options: Emergency Reserve Fund $ (2,948,948) When the operating transfers are combined with the above reserves and the designations require Town Council action, the entire excess of revenues and other sources over expenditures and other uses in the General Fund for the 2022/23 fiscal year will have been designated for specific purposes. Audited Annual Comprehensive Financial Report FY 2022/23 4 November 21, 2023 PUBLIC CONTACT Posting of the meeting agenda for the Town Council meeting on November 21, 2023, as well as the Finance Committee meeting on October 17, 2023, and the Study Session on November 14, 2023, serves as notice to the general public. FISCAL IMPACT Approval of the recommendations made in this report will increase the Fiscal Year 2022/23 net designations in the General Fund by $2,948,948. RECOMMENDATION Adopt Resolution No. 83-2023, accepting the Fiscal Year 2022/23 Audited Annual Comprehensive Financial Report for the Town of Danville. Prepared by: Lani Ha Finance Manager/Treasurer Reviewed by: Joseph A. Calabrigo Town Manager Attachments: A - Resolution No. 83-2023 B - Fiscal Year 2022/23 Annual Comprehensive Financial Report for the Town of Danville (Copies were distributed to the Town Council, Town Manager and City Clerk. Copies are available upon request at the City Clerk’s office.) RESOLUTION NO. 83-2023 ACCEPTING THE FISCAL YEAR 2022/23 AUDITED ANNUAL COMPREHENSIVE FINANCIAL REPORT FOR THE TOWN OF DANVILLE WHEREAS, the Town of Danville’s independent auditor has completed its annual examination of the Town’s financial statements and has issued a draft report with an unqualified opinion as to their accuracy; and WHEREAS, the audited financial statements have been combined with introductory and statistical information into the Town’s Annual Comprehensive Financial Report; and WHEREAS, the Town Council has reviewed the draft Annual Comprehensive Financial Report; now, therefore, be it RESOLVED, that the Danville Town Council accepts and approves the Fiscal Year 2022/23 audited Annual Comprehensive Financial Report as presented; and, be it further RESOLVED, that the following amount be transferred to the Emergency Reserve Fund:  $ 2,948,948 for Emergency Reserve Fund APPROVED by the Danville Town Council at a regular meeting held on November 21, 2023, by the following vote: AYES: NOES: ABSTAINED: ABSENT: MAYOR APPROVED AS TO FORM: ATTEST: CITY ATTORNEY CITY CLERK DocuSign Envelope ID: 17BDC5B8-F9F2-43EF-8FB1-0B95EA5730A6