The URL can be used to link to this page

Home My WebLink About111522-08.1 ADMINISTRATIVE STAFF REPORT 8.1 TO: Mayor and Town Council November 15, 2022 SUBJECT: Resolution No. 98-2022, accepting the Fiscal Year 2021/22 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 have 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 2021/22 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 2021/22 2 November 15, 2022 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 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 decrease in fund balance of $6,858,844 (year over year 2020/21 to 2021/22). Revenues exceeded expenditures by $6,959,327 with net operating transfers to other funds of $13,842,014. Actual revenues exceeded final budgeted revenues by $1,778,206. General Fund expenditures were below budget by $3,479,539 with cost savings in all departments. These savings were largely attributable to several position vacancies that went unfilled in all departments and significant expenditure reductions in Recreation, Arts and Community Services due to the inability to offer many fee classes, programs and activities as a result of the pandemic. Note 10 of the Notes to Basic Financial Statements details the reserves and designations against the June 30, 2022 Fund Balance. The recommended designated reserves, described below, were reviewed by the Town Council Finance Committee on October 19, 2021, and by the Town Council at the November 1, 2022 Study Session. These will require approval and appropriation by the full Town Council through Resolution No. 98-2022 TOWN FUND BALANCE Total reserves and designations amount to $22,868,906 (Table 1), a decrease of $2,529,930 from prior year reserves and designations of $25,398,836. It is recommended that the Town Council approve the following adjustments to fund balance reserves which are reflected in the FY 2021/22 ACFR. Capital Improvement Projects Fund The recommended transfer of $3,250,000 to the Capital Improvement Projects Fund will Audited Annual Comprehensive Financial Report FY 2021/22 3 November 15, 2022 assist with the funding of future projects as determined by the Town Council. Asset Replacement The recommended transfer of $1,000,000 to the Asset Replacement Fund will assist with the replacement of obsolete capital assets including vehicles, equipment, furnishings, and technology. Compensated Absences/Personnel The recommended transfer of $269,893 will increase the reserves for Compensated Absences/Personnel to ensure that sufficient funds are set aside to cover currently accumulated employee general leave hours. Rental Proceeds The recommended transfer of $250,000 will assist with property maintenance and operation costs for the property at 500 La Gonda Way. 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, 2022 Total pre-audit Fund Balance at 6/30/22 $ 26,626,208 Adjusted for unrealized market value reported per GASB 31 $ 1,050,668 Adjusted for unrealized leased income/loss reported per GASB 37 $ (38,077) Fund Balance without unrealized market value $ 27,638,799 Less Reserves/Designations against Fund Balance for: Operating Reserve $ 13,809,768 Receivable from former CDA $ 3,959,401 Compensated Absences/Personnel $ 1,195,339 Reserved for Debt Service $ 809,648 Contingency $ 782,066 Encumbrances $ 1,036,271 500 La Gonda Way – proceeds from rent $ 1,266,413 Reward Fund $ 10,000 Total Reserves/Designations against Fund Balance $ 22,868,906 Audited Annual Comprehensive Financial Report FY 2021/22 4 November 15, 2022 Current Unreserved/Undesignated Fund Balance at 6/30/21 $ 4,769,893 Recommended Fund Balance Options: Capital Improvement Program – General Purpose $ (3,250,000) Asset Replacement $ (1,000,000) Compensated Absences/Personnel $ (269,893) Rental Proceeds $ (250,000) 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 2021/22 fiscal year will have been designated for specific purposes. PUBLIC CONTACT Posting of the meeting agenda for the Town Council meeting on November 15, 2025, as well as the Finance Committee meeting on October 18, 2022, and the Study Session on November 9, 2021, serves as notice to the general public. FISCAL IMPACT Approval of the recommendations made in this report will increase the Fiscal Year 2021/22 net designations in the General Fund by $4,769,893. Audited Annual Comprehensive Financial Report FY 2021/22 5 November 15, 2022 RECOMMENDATION Adopt Resolution No. 98-2022, accepting the Fiscal Year 2021/22 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. 98-2022 B - Fiscal Year 2021/22 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. 98-2022 ACCEPTING THE FISCAL YEAR 2021/22 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 2021/22 audited Annual Comprehensive Financial Report as presented; and, be it further RESOLVED, that the following amount be transferred to the Capital Improvement Projects Fund: $ 6,100,000 for CIP Capital Improvement Projects Fund RESOLVED, that the following amount be transferred to the Asset Replacement Fund: $ 1,000,000 for Asset Replacement Fund RESOLVED, that the following amount be transferred to the Compensated Absences/Personnel Fund: $ 269,893 for Compensated Absences/Personnel Fund RESOLVED, that the following amount be transferred to the General Fund, Rental Proceeds: $ 250,000 for Rental Proceeds DocuSign Envelope ID: AC9CE2AA-E9F8-450E-B185-1EBB8E98AAE1 ATTACHMENT A PAGE 2 OF RESOLUTION NO. 98-2022 APPROVED by the Danville Town Council at a regular meeting held on November 15, 2022, by the following vote: AYES: NOES: ABSTAINED: ABSENT: MAYOR APPROVED AS TO FORM: ATTEST: CITY ATTORNEY CITY CLERK DocuSign Envelope ID: AC9CE2AA-E9F8-450E-B185-1EBB8E98AAE1