Loading...
Finance - Annual Audit - 09/30/2022 City of Eagle, Idaho Year Ended September 30, 2022 CITY OF EAGLE, IDAHO Table of Contents i Financial Section Independent Auditor's Report .......................................................................................................... 1 Basic Financial Statements Government-Wide Financial Statements Statement of Net Position ................................................................................................................ 4 Statement of Activities .................................................................................................................... 5 Fund Financial Statements Balance Sheet – Governmental Funds ............................................................................................. 6 Statement of Revenues, Expenditures, and Changes in Fund Balances – Governmental Funds ..... 9 Statement of Net Position – Proprietary Funds ............................................................................... 12 Statement of Revenues, Expenses, and Changes in Net Position – Proprietary Funds ................... 13 Statement of Cash Flows – Proprietary Funds ................................................................................ 14 Notes to Financial Statements ......................................................................................................... 15 Required Supplementary Information Budgetary Comparison Schedule – General and Major Special Revenue Funds ............................ 28 Schedule of Employer’s Share of Net Pension Asset and Liability and Schedule of Employer Contributions ................................................................................................................................... 30 Supplementary Information Schedule of Expenditures of Federal Awards.................................................................................. 31 Other Reports and Schedules Independent Auditor’s Report on Internal Control Over Financial Reporting and on Compliance and Other Matters Based on an Audit of the Financial Statements Performed in Accordance with Government Auditing Standards...................................................................................................... 32 Independent Auditor’s Report on Compliance for Each Major Program and on Internal Control Over Compliance Required by the Uniform Guidance ................................................................... 34 Schedule of Findings and Questioned Costs ................................................................................... 37 1 11501 Highway 95, Payette, Idaho 83661 | www.qcpas.com | info@qcpas.com | 208-642-1417 Independent Auditor’s Report Honorable Mayor and City Council City of Eagle, Idaho Report on the Financial Statements Opinions We have audited the 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 the City of Eagle, Idaho (the City) as of and for the year ended September 30, 2022, and the related notes to the financial statements, which collectively comprise the City’s basic financial statements as listed in the table of contents. In our opinion, the financial statements referred to above present fairly, in all material respects, the respective financial position of the governmental activities, the business-type activities, the discretely presented component unit, each major fund, and the aggregate remaining fund information of the City as of September 30, 2022, and the respective 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. Basis for Opinions We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. 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 City 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 audit opinions. Responsibilities of Management for the Financial Statements Management is responsible for the preparation and fair presentation of these financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. In preparing the financial statements, management is required to evaluate whether there are conditions or events, considered in the aggregate, that raise substantial doubt about the City’s ability to continue as a going concern for twelve months beyond the financial statement date, including any currently known information that may raise substantial doubt shortly thereafter. 2 Auditor’s Responsibility 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 assurance and therefore is not a guarantee that an audit conducted in accordance with generally accepted auditing standards and Government Auditing Standards 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 omissions, misrepresentations, or the override if 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 generally accepted auditing standards and Government Auditing Standards, 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 City’s internal control. Accordingly, no such opinion is expressed. • Evaluate the appropriateness of accounting policies used and the reasonableness of significant accounting estimates made by management, as well as evaluate the overall presentation of the financial statements. • Conclude whether, in our judgment, there are conditions or events, considered in the aggregate, that raise substantial doubt about the City’s ability to continue as a going concern for a reasonable period of time. We are required to communicate with those charged with governance regarding, among other matters, the planned scope and timing of the audit, significant audit findings, and certain internal control-related matters that we identified during the audit. Required Supplementary Information Accounting principles generally accepted in the United States of America require that the budgetary comparison schedules and schedule of employer’s share of net pension asset and liability and schedule of employer contributions listed in the table of contents be presented to supplement the basic financial statements. Such information, although not 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, and 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 3 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. Management has not included the management’s discussion and analysis information that accounting principles generally accepted in the United States of America require to be presented to supplement the basic financial statements. Such information, although not 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, and historical context. Our opinion on the basic financial statements is not affected by not including this information. Supplementary Information Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the City’s basic financial statements. The accompanying schedule of expenditures of federal awards, as required by Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is 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 information has been subjected to the auditing procedures applied in the audit of the basic financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the basic financial statements or 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 schedule of expenditures of federal awards is fairly stated in all material respects in relation to the basic financial statements as a whole. Other Reporting Required by Government Auditing Standards In accordance with Government Auditing Standards, we have also issued our report dated December 26, 2022, on our consideration of the City's internal control over financial reporting and on our tests of its compliance with certain provisions of laws, regulations, contracts, 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 City’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 City’s internal control over financial reporting and compliance. Quest CPAs PLLC Payette, Idaho December 26, 2022 CITY OF EAGLE, IDAHO Statement of Net Position September 30, 2022 Governmental Business-Type Total Primary Component Unit Activities Activities Government SVCID Assets Current Assets Cash & Investments $17,148,874 $5,952,033 $23,100,907 $104,079,831 Receivables: Taxes 18,871 18,871 124 Intergovernmental 1,056,424 1,056,424 Accounts 206,808 153,455 360,263 37,975 Total Current Assets 18,430,977 6,105,488 24,536,465 104,117,930 Noncurrent Assets Restricted Cash & Investments 2,063,838 2,426,846 4,490,684 Special Assessment Receivables 0 120,990,000 Nondepreciable Capital Assets 7,395,344 93,250 7,488,594 Depreciable Net Capital Assets 18,712,245 14,151,501 32,863,746 Total Noncurrent Assets 28,171,427 16,671,597 44,843,024 120,990,000 Total Assets 46,602,404 22,777,085 69,379,489 225,107,930 Deferred Outflows of Resources Pension Items 1,725,987 158,311 1,884,298 Total Deferred Outflows of Resources 1,725,987 158,311 1,884,298 0 Total Assets and Deferred Outflows of Resources $48,328,391 $22,935,396 $71,263,787 $225,107,930 Liabilities Current Liabilities Accounts Payable & Accrued Expenses $832,965 $129,518 $962,483 $13,498 Deposits Payable 2,063,838 102,950 2,166,788 30,050 Unearned Grant Revenue 1,976,589 1,976,589 Accrued Interest 11,158 11,158 378,887 Long-Term Liabilities, Current 224,106 167,000 391,106 7,000 Total Current Liabilities 5,097,498 410,626 5,508,124 429,435 Noncurrent Liabilities Long-Term Liabilities, Noncurrent 3,535,756 886,502 4,422,258 121,300,000 Total Noncurrent Liabilities 3,535,756 886,502 4,422,258 121,300,000 Total Liabilities 8,633,254 1,297,128 9,930,382 121,729,435 Deferred Inflows of Resources Pension Items 14,350 1,389 15,739 Total Deferred Inflows of Resources 14,350 1,389 15,739 0 Total Liabilities and Deferred Inflows of Resources 8,647,604 1,298,517 9,946,121 121,729,435 Net Position Net Investment in Capital Assets 25,706,711 13,484,534 39,191,245 Restricted - Special Programs 1,098,167 1,098,167 Restricted - Debt Service 181,836 181,836 16,199,574 Restricted - Capital Projects 7,609,880 2,142,060 9,751,940 87,875,251 Unrestricted 5,266,029 5,828,449 11,094,478 (696,330) Total Net Position 39,680,787 21,636,879 61,317,666 103,378,495 Total Liabilities and Deferred Inflows of Resources and Net Position $48,328,391 $22,935,396 $71,263,787 $225,107,930 See Accompanying Notes 4 CITY OF EAGLE, IDAHO Statement of Activities Year Ended September 30, 2022 Operating Capital Charges For Grants And Grants And Net (Expense) Functions/Programs Expenses Services Contributions Contributions Revenue Governmental Activities Current Expenditures General Government $4,940,113 $1,656,071 ($3,284,042) Public Safety 3,345,874 1,121,635 (2,224,239) Parks, Pathways, & Streets 1,567,090 525,335 $291,913 (749,842) Culture & Recreation 2,050,308 687,324 1,734 (1,361,250) Debt Service - Interest 12,658 (12,658) Capital Assets 927,744 2,243,035 1,315,291 Total Governmental Activities 12,843,787 3,990,365 $0 2,536,682 (6,316,740) Business-Type Activities Water Services 1,399,326 3,611,376 2,254,875 4,466,925 Fiber Services 0 Total Business-Type Activities 1,399,326 3,611,376 0 2,254,875 4,466,925 Total Primary Government $14,243,113 $7,601,741 $0 $4,791,557 ($1,849,815) Component Unit Spring Valley CID No. 1 $17,897,590 $125,245 ($17,772,345) Total Component Unit 17,897,590 $0 125,245 $0 (17,772,345) Governmental Business-Type Total Primary Component Unit Changes in Net Position Activities Activities Government SVCID Net (Expense) Revenue ($6,316,740) $4,466,925 ($1,849,815) ($17,772,345) General Revenues Taxes 4,269,530 4,269,530 16,096 Special Assessments 0 120,990,000 Franchise Fees 1,057,287 1,057,287 Intergovernmental 4,269,598 4,269,598 Interest 35,385 10,597 45,982 467,744 Other Revenue (Expense) 4,693,298 4,693,298 Pension Revenue (Expense) (876,271) (80,357) (956,628) Transfers (4,083,265) 4,083,265 0 Total 9,365,562 4,013,505 13,379,067 121,473,840 Change in Net Position 3,048,822 8,480,430 11,529,252 103,701,495 Net Position - Beginning 36,631,965 13,156,449 49,788,414 (323,000) Net Position - Ending $39,680,787 $21,636,879 $61,317,666 $103,378,495 Program Revenues See Accompanying Notes 5 CITY OF EAGLE, IDAHO Balance Sheet - Governmental Funds September 30, 2022 Page 1 of 3 Debt General Library Service Park Fund Fund Fund Fund Assets Cash $6,377,847 $1,020,297 $1,968,520 Receivables: Taxes 12,084 6,787 Intergovernmental 1,056,424 Accounts 46,487 1,872 Due From Other Funds Restricted Cash 2,063,838 Total Assets $9,556,680 $1,028,956 $0 $1,968,520 Liabilities Accounts Payable & Accrued Expenses $528,729 $60,686 $15,774 Due To Other Funds Deposits Payable 2,063,838 Unearned Grant Revenue Total Liabilities 2,592,567 60,686 $0 15,774 Deferred Inflows of Resources Unavailable Tax Revenues 11,060 6,220 Total Deferred Inflows of Resources 11,060 6,220 0 0 Fund Balances Restricted - Special Programs 56,957 962,050 Restricted - Debt Service Restricted - Capital Projects 1,952,746 Unassigned 6,896,096 Total Fund Balances 6,953,053 962,050 0 1,952,746 Total Liabilities and Deferred Inflows of Resources and Fund Balances $9,556,680 $1,028,956 $0 $1,968,520 See Accompanying Notes 6 CITY OF EAGLE, IDAHO Balance Sheet - Governmental Funds September 30, 2022 Page 2 of 3 Capital Nonmajor Fund Total Projects Pathway Police Impact Governmental Fund Fund Fees Fund Funds Assets Cash $6,848,024 $855,026 $79,160 $17,148,874 Receivables: Taxes 18,871 Intergovernmental 1,056,424 Accounts 158,449 206,808 Due From Other Funds 0 Restricted Cash 2,063,838 Total Assets $7,006,473 $855,026 $79,160 $20,494,815 Liabilities Accounts Payable & Accrued Expenses $227,776 $832,965 Due To Other Funds 0 Deposits Payable 2,063,838 Unearned Grant Revenue 1,976,589 1,976,589 Total Liabilities 2,204,365 0 0 4,873,392 Deferred Inflows of Resources Unavailable Tax Revenues 17,280 Total Deferred Inflows of Resources 0 0 0 17,280 Fund Balances Restricted - Special Programs 79,160 1,098,167 Restricted - Debt Service 0 Restricted - Capital Projects 4,802,108 855,026 7,609,880 Unassigned 6,896,096 Total Fund Balances 4,802,108 855,026 79,160 15,604,143 Total Liabilities and Deferred Inflows of Resources and Fund Balances $7,006,473 $855,026 $79,160 $20,494,815 See Accompanying Notes 7 CITY OF EAGLE, IDAHO Balance Sheet - Governmental Funds September 30, 2022 Page 3 of 3 Reconciliation of Total Governmental Fund Balances to Net Position of Governmental Activities Total Governmental Fund Balances $15,604,143 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. 26,107,589 Certain receivables are not available to pay for current period expenditures and therefore are deferred in the funds. 17,280 Long-term liabilities, including accrued interest, are not due and payable in the current period and therefore are not reported in the funds. (3,759,862) Deferred outflows/inflows related to pensions are not due and payable in the current period and therefore are not reported in the funds.1,711,637 Net Position of Governmental Activities $39,680,787 See Accompanying Notes 8 CITY OF EAGLE, IDAHO Statement of Revenues, Expenditures, and Changes in Fund Balances - Governmental Funds Year Ended September 30, 2022 Page 1 of 3 Debt General Library Service Park Fund Fund Fund Fund Revenues Taxes $2,775,360 $1,497,313 Franchise Fees 1,057,287 Intergovernmental 4,269,598 Licenses, Permits, & Fees 3,553,147 7,255 $303,476 Interest 17,897 2,200 7,085 Miscellaneous & Grants 2,260,217 7,632 Total Revenues 13,933,506 1,514,400 $0 310,561 Expenditures Current Expenditures General Government 5,274,974 Public Safety 3,572,671 Parks, Pathways, & Streets 1,672,831 Culture & Recreation 920,854 1,268,433 Capital Outlay 116,184 2,058,558 Debt Service - Principal 80,000 Debt Service - Interest 22,949 Total Expenditures 11,441,330 1,384,617 102,949 2,058,558 Excess (Deficiency) of Revenues Over Expenditures 2,492,176 129,783 (102,949) (1,747,997) Other Financing Sources (Uses) Transfers In 99,544 Transfers Out (142,073) Total Other Financing Sources (Uses)(142,073) 0 99,544 0 Net Change in Fund Balances 2,350,103 129,783 (3,405) (1,747,997) Fund Balances - Beginning 4,602,950 832,267 3,405 3,700,743 Fund Balances - Ending $6,953,053 $962,050 $0 $1,952,746 See Accompanying Notes 9 CITY OF EAGLE, IDAHO Statement of Revenues, Expenditures, and Changes in Fund Balances - Governmental Funds Year Ended September 30, 2022 Page 2 of 3 Capital Nonmajor Fund Total Projects Pathway Police Impact Governmental Fund Fund Fees Fund Funds Revenues Taxes $4,272,673 Franchise Fees 1,057,287 Intergovernmental 4,269,598 Licenses, Permits, & Fees $89,896 $36,591 3,990,365 Interest $6,477 1,686 40 35,385 Miscellaneous & Grants 4,962,131 7,229,980 Total Revenues 4,968,608 91,582 36,631 20,855,288 Expenditures Current Expenditures General Government 5,274,974 Public Safety 3,572,671 Parks, Pathways, & Streets 483 1,673,314 Culture & Recreation 2,189,287 Capital Outlay 6,084,703 8,259,445 Debt Service - Principal 80,000 Debt Service - Interest 22,949 Total Expenditures 6,084,703 483 0 21,072,640 Excess (Deficiency) of Revenues Over Expenditures (1,116,095) 91,099 36,631 (217,352) Other Financing Sources (Uses) Transfers In 42,529 142,073 Transfers Out (4,083,265) (4,225,338) Total Other Financing Sources (Uses)(4,083,265) 0 42,529 (4,083,265) Net Change in Fund Balances (5,199,360) 91,099 79,160 (4,300,617) Fund Balances - Beginning 10,001,468 763,927 0 19,904,760 Fund Balances - Ending $4,802,108 $855,026 $79,160 $15,604,143 See Accompanying Notes 10 CITY OF EAGLE, IDAHO Statement of Revenues, Expenditures, and Changes in Fund Balances - Governmental Funds Year Ended September 30, 2022 Page 3 of 3 Reconciliation of the Statement of Revenues, Expenditures, and Changes in Fund Balances - Governmental Funds to the Statement of Activities Net Change in Fund Balances - Total Governmental Funds ($4,300,617) Amounts reported for governmental activities in the statement of activities are different because: Government funds report capital outlays as expenditures. However, in the statement of activities the cost of those assets is allocated over their estimated useful lives as depreciation expense. This is the excess of capital outlays over (under) depreciation expense in the current period. 7,331,701 Revenues in the statement of activities that do not provide current financial resources are deferred in the funds. (3,143) Repayment of debt principal is an expenditure in the governmental funds, but the repayment reduces long-term debt in the statement of net position.80,000 Bond premiums are amortized against interest expense over the term of the bond.10,291 In the statement of activities, compensated absences are accrued when earned, but the expenditure is reported when due in the governmental funds.93,278 Changes in net pension asset/liability and related pension deferred outflows and deferred inflows do not provide or require current financial resources and therefore are not reflected in the funds. (162,688) Change in Net Position of Governmental Activities $3,048,822 See Accompanying Notes 11 CITY OF EAGLE, IDAHO Statement of Net Position - Proprietary Fund September 30, 2022 Total Water Fiber Enterprise Fund Fund Funds Assets Current Assets Cash $3,561,384 $2,390,649 $5,952,033 Receivables: Accounts 153,455 153,455 Total Current Assets 3,714,839 2,390,649 6,105,488 Noncurrent Assets Restricted Cash 2,426,846 2,426,846 Nondepreciable Capital Assets 93,250 93,250 Depreciable Net Capital Assets 12,458,216 1,693,285 14,151,501 Total Noncurrent Assets 14,978,312 1,693,285 16,671,597 Total Assets 18,693,151 4,083,934 22,777,085 Deferred Outflows of Resources Pension Items 158,311 158,311 Total Deferred Outflows of Resources 158,311 0 158,311 Total Assets and Deferred Outflows of Resources $18,851,462 $4,083,934 $22,935,396 Liabilities Current Liabilities Accounts Payable & Accrued Expenses $129,518 $129,518 Deposits Payable 102,950 102,950 Accrued Interest 11,158 11,158 Long-Term Liabilities, Current 167,000 167,000 Total Current Liabilities 410,626 0 410,626 Noncurrent Liabilities Long-Term Liabilities, Noncurrent 886,502 886,502 Total Noncurrent Liabilities 886,502 0 886,502 Total Liabilities 1,297,128 0 1,297,128 Deferred Inflows of Resources Pension Items 1,389 1,389 Total Deferred Inflows of Resources 1,389 0 1,389 Total Liabilities and Deferred Inflows of Resources 1,298,517 0 1,298,517 Net Position Net Investment in Capital Assets 11,791,249 1,693,285 13,484,534 Restricted - Debt Service 181,836 181,836 Restricted - Capital Projects 2,142,060 2,142,060 Unrestricted 3,437,800 2,390,649 5,828,449 Total Net Position 17,552,945 4,083,934 21,636,879 Total Liabilities and Deferred Inflows of Resources and Net Position $18,851,462 $4,083,934 $22,935,396 See Accompanying Notes 12 CITY OF EAGLE, IDAHO Statement of Revenues, Expenses, and Changes in Net Position - Proprietary Fund Year Ended September 30, 2022 Total Water Fiber Enterprise Fund Fund Funds Operating Revenues Service Fees $1,725,564 $1,725,564 STL & WCE Fees 1,722,668 1,722,668 Hook-Up Fees 154,070 154,070 Miscellaneous 9,074 9,074 Total Operating Revenues 3,611,376 $0 3,611,376 Operating Expenses Personnel 397,347 397,347 Operations & Maintenance 342,657 342,657 Total Operating Expenses 740,004 0 740,004 Operating Income (Loss) Before Depreciation 2,871,372 0 2,871,372 Depreciation Expense 629,227 0 629,227 Operating Income (Loss)2,242,145 0 2,242,145 Nonoperating Revenues (Expenses) Interest Income 9,928 669 10,597 Interest (Expense) (30,095) (30,095) Pension Revenue (Expense) (80,357) (80,357) Total Nonoperating Revenue (Expenses)(100,524) 669 (99,855) Income (Loss) Before Contributions & Transfers 2,141,621 669 2,142,290 Capital Contributions 2,254,875 2,254,875 Transfers In 4,083,265 4,083,265 Transfers Out 0 Change in Net Position 4,396,496 4,083,934 8,480,430 Net Position - Beginning 13,156,449 0 13,156,449 Net Position - Ending $17,552,945 $4,083,934 $21,636,879 See Accompanying Notes 13 CITY OF EAGLE, IDAHO Statement of Cash Flows - Proprietary Fund Year Ended September 30, 2022 Total Water Fiber Enterprise Fund Fund Funds Cash Flows From Operations Receipts from Customers $3,606,441 $3,606,441 Payments for Personnel (433,165) (433,165) Payments for Goods & Services (334,430) (334,430) Cash Provided (Used) By Operations 2,838,846 $0 2,838,846 Cash Flows From Noncapital Financing Transfers (to) From Other Funds 4,083,265 4,083,265 Cash Provided (Used) By Noncapital Financing 0 4,083,265 4,083,265 Cash Flows From Capital & Related Financing Acquisition of Capital Assets (892,048) (1,693,285) (2,585,333) Interest Paid on Debt (34,036) (34,036) Principal Paid on Debt (365,964) (365,964) Changes in Other Long-Term Liabilities (4,855) (4,855) Cash Provided (Used) By Capital & Related Financing (1,296,903) (1,693,285) (2,990,188) Cash Flows From Investments Interest Income 9,928 669 10,597 Cash Provided (Used) By Investments 9,928 669 10,597 Change in Cash 1,551,871 2,390,649 3,942,520 Cash - Beginning 4,436,359 0 4,436,359 Cash - Ending $5,988,230 $2,390,649 $8,378,879 Cash Reconciliation Cash $3,561,384 $2,390,649 $5,952,033 Restricted Cash 2,426,846 0 2,426,846 Total Cash $5,988,230 $2,390,649 $8,378,879 Reconciliation of Operating Income (Loss) to Cash Provided (Used) By Operations Operating Income (Loss) $2,242,145 $0 $2,242,145 Adjustments to Reconcile Operating Income (Loss) to Cash Provided (Used) by Operations: Depreciation 629,227 0 629,227 PERSI Contributions (35,818) (35,818) Changes in Assets & Liabilities: Receivables (15,485) (15,485) Accounts Payable & Accrued Expenses 8,227 8,227 Deposits Payable 10,550 10,550 Cash Provided (Used) By Operations $2,838,846 $0 $2,838,846 Noncash Capital & Related Financing Activities: Capital Contributions from Developers $2,254,875 $0 $2,254,875 See Accompanying Notes 14 CITY OF EAGLE, IDAHO Notes to Financial Statements 15 A. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES Reporting Entity – The City of Eagle, Idaho (the City) provides basic municipal services and operates under a mayor-council form of government. These financial statements are prepared in accordance with generally accepted accounting principles (GAAP) as applied to cities. The governmental accounting standards board (GASB) is responsible for establishing GAAP for state and local governments through its pronouncements (statements and interpretations). The more significant accounting policies established in GAAP and used by the City are discussed below. As required by GAAP, these financial statements present the City and its component unit, the Spring Valley Community Infrastructure District No. 1 (SVCID). The SVCID board of directors are appointed by and comprised of City council members. In addition, SVCID operational responsibilities are performed by a management team that is separate from the City’s management. As such, the SVCID qualifies as a discretely presented component unit. Separate financial statements for the SVCID are issued and available from the City. Basic Financial Statements - Government-Wide Statements – The City’s basic financial statements include both government-wide (reporting the City as a whole) and fund financial statements (reporting the City’s major funds). Both government-wide and fund financial statements categorize primary activities as either governmental or business-type. In the government-wide statement of net position, both the governmental and business-type activities columns (a) are presented on a consolidated basis by column, (b) and are reported on a full accrual, economic resource basis, which recognizes all long-term assets and receivables as well as long-term debt and obligations. The government-wide statement of activities reports both the gross and net cost of each of the City’s functions and business-type activities. The functions are also supported by general government revenues as reported in the statement of activities. The statement of activities reduces gross expenses (including depreciation when recorded) by related program revenues and operating and capital grants. Program revenues must be directly associated with the function. Internal activity between funds is eliminated in the government-wide statement of activities. Operating grants include operating-specific and discretionary (either operating or capital) grants while the capital grants column reports capital-specific grants. The net costs (by function or business-type activity) are normally covered by general revenues. The City’s sole activity is providing basic municipal services, and substantially all expenses are directly related to this activity. Accordingly, there is no allocation of indirect costs. The government-wide focus is more on the sustainability of the City as an entity and the change in the City’s net position resulting from the current year’s activities. Fiduciary funds, when present, are not included in the government-wide statements. Basic Financial Statements - Fund Financial Statements – The financial transactions of the City are reported in individual funds in the fund financial statements. Each fund is accounted for by providing a separate set of self-balancing accounts that comprises its assets, deferred outflows of resources, liabilities, deferred inflows of resources, fund equity, revenues and expenditures/expenses. CITY OF EAGLE, IDAHO Notes to Financial Statements 16 The emphasis in fund financial statements is on the major funds. Nonmajor funds by category are summarized into a single column. Generally accepted accounting principles set forth minimum criteria (percentage of assets and deferred outflows of resources, liabilities and deferred inflows of resources, revenues or expenditures/expenses of the funds) for the determination of major funds. The focus of the governmental funds' measurement (in the fund statements) is upon determination of financial position and changes in financial position (sources, uses, and balances of financial resources) rather than upon net income. Major governmental funds of the City include: General Fund – The general fund is the City’s primary operating fund. It is used to account for all financial resources except those required to be accounted for in another fund. Special Revenue Funds – Special revenue funds are used to account for the proceeds of specific revenue sources that are legally restricted to expenditures for specified purposes. Major special revenue funds include the library fund, which accounts for the revenues earned and expenses incurred in providing library services. Debt Service Fund – The debt service fund is used to account for the accumulation of funds for the periodic payment of principal and interest on long-term debt. Capital Projects Fund – Capital projects funds are used to account for the acquisition and betterment of capital assets. Major capital project funds include the park fund, used to account for the maintenance and betterment of parks and related facilities, the capital projects fund, used to account for the maintenance and betterment of capital assets, and the pathway fund, used to account for the maintenance and betterment of pathways and related facilities. The focus of proprietary fund measurement is upon determination of operating income, changes in net position, financial position, and cash flows. The generally accepted accounting principles applicable are those similar to businesses in the private sector. Enterprise funds are required to be used to account for operations for which a fee is charged to external users for goods or services and the activity is financed with debt that is solely secured by a pledge of the net revenues. The activities reported in enterprise funds are reported as business-type activities in the government-wide financial statements. Major enterprise funds of the City include: Water Fund – The water fund accounts for the revenues earned and expenses incurred in providing water services. Fiber Fund – The fiber fund accounts for the revenues earned and expenses incurred in providing fiber services. Basis of Accounting – Basis of accounting refers to the point at which revenues or expenditures/expenses are recognized in the accounts and reported in the financial statements. It relates to the timing of the measurements made regardless of the measurement focus applied. Both governmental and business-type activities in the government-wide financial statements and proprietary and fiduciary fund financial statements are reported on the full accrual basis of accounting. Revenues are recognized when earned and expenses are recognized when incurred. CITY OF EAGLE, IDAHO Notes to Financial Statements 17 The governmental funds financial statements are presented on the modified accrual basis of accounting. Under the modified accrual basis of accounting, revenues are recorded when susceptible to accrual (when they become both measurable and available). "Measurable" means the amount of the transaction can be determined and "available" means collectible within the current period or within thirty days after year end. Expenditures are recorded when the related fund liability is incurred. Exceptions to this general rule include principal and interest on long-term debt which, if any, are recognized when due and payable. Cash – The cash balances of the City’s funds are pooled for investment purposes. The individual funds’ portions of the pooled cash are reported in each fund as cash. Interest earned on pooled cash is allocated to the various funds in proportion to each fund’s respective investment balance. For purposes of the statement of cash flows, the City considers all investments (including restricted cash) available for immediate withdrawal or with maturities of three months or less to be cash and cash equivalents (referred to as cash). Receivables – Receivables are reported net of any estimated uncollectible amounts. Inventories – Material supplies on hand at year end are stated at the lower of cost or net realizable value using the first-in, first-out method. Capital Assets and Depreciation – Capital assets purchased or acquired with an original cost of $5,000 or more are reported at historical cost or estimated historical cost. Contributed assets are reported at acquisition value as of the date received. Additions, improvements and other capital outlays that significantly extend the useful life of an asset are capitalized. Other costs incurred for repairs and maintenance are expensed as incurred. Depreciation over the estimated useful lives of all depreciable assets is recorded using the straight line method. Compensated Absences – The City provides certain compensated absences to its employees. The estimated amount of compensation for future amounts is recorded as a liability in the accompanying financial statements. Compensated absences will be paid by the fund in which the employee works. Pensions – For purposes of measuring the net pension asset/liability and pension revenue/expense, information about the fiduciary net position of the Public Employee Retirement System of Idaho Base Plan (the Base Plan) and additions to/deductions from the Base Plan’s fiduciary net position have been determined on the same basis as they are reported by the Base Plan. For this purpose, benefit payments (including refunds of employee contributions) are recognized when due and payable in accordance with the benefit terms. Investments are reported at fair value. Pension obligations will be paid by the fund in which the employee works. Deferred Outflows/Inflows of Resources – The City’s financial statements may report deferred outflows/inflows of resources. Deferred outflows of resources represent a consumption of net assets that apply to a future period. Deferred inflows of resources represent an acquisition of net assets that apply to a future period. Deferred outflows/inflows of resources generally represent amounts that are not available in the current period. Net Position – Net position is assets plus deferred outflows of resources less liabilities less deferred inflows of resources. The net investment in capital assets component of net position consists of the historical cost of capital assets less accumulated depreciation less any outstanding debt that was used to finance those assets plus deferred outflows of resources less deferred inflows of resources related to those assets. CITY OF EAGLE, IDAHO Notes to Financial Statements 18 Restricted net position consists of assets that are restricted by creditors, grantors, contributors, legislation, and other parties. All other net position not reported as restricted or net investment in capital assets is reported as unrestricted. Fund Balance Classifications – Restrictions of the fund balance indicate portions that are legally or contractually segregated for a specific future use. Nonspendable portions of the fund balance are those amounts that cannot be spent because they are in a nonspendable form or because they are legally or contractually required to be maintained intact. Committed portions represent amounts that can only be used for specific purposes pursuant to formal action (i.e. board approval) of the reporting entity’s governing body. Assigned portions represent amounts that are constrained by the government’s intent to be used for a specific purpose. Remaining fund balances are reported as unassigned. When expenditures are incurred that qualify for either restricted or unrestricted resources, the City first utilizes restricted resources. When expenditures are incurred that qualify for either committed or assigned or unassigned resources, the City first utilizes committed resources then assigned resources before using unassigned resources. Property Taxes – The City is responsible for levying property taxes, but the taxes are collected by the respective county. Taxes are levied by the second Monday in September for each calendar year. Taxes are due in two installments – December 20th and June 20th. A lien is filed on real property three years from the date of delinquency. Contingent Liabilities – Amounts received or receivable from grantor agencies are subject to audit and adjustment by grantor agencies. Any disallowed claims, including amounts already collected, may constitute a liability of the applicable funds. The amount, if any, of expenditures which may be disallowed by the grantor cannot be determined at this time although the City expects such amounts, if any, to be immaterial. Interfund Activity – Interfund activity is reported either as loans, services provided, reimbursements, or transfers. Loans are reported as interfund receivables and payables as appropriate and are subject to elimination upon consolidation. Services provided, deemed to be at market or near market rates, are treated as revenues and expenditures/expenses. Reimbursements are when one fund incurs a cost, charges the appropriate benefiting fund, and reduces its related cost as a reimbursement. All other interfund transactions are treated as transfers. Use of Estimates – The preparation of financial statements in conformity with accounting principles generally accepted in the United States of America requires management to make estimates and assumptions that affect certain reported amounts and disclosures. Accordingly, actual results could differ from those estimates. Custodial Credit Risk – The City maintains its cash at insured financial institutions. Periodically, balances may exceed federally insured limits. Balances not covered by FDIC are collateralized whenever possible. Risk Management – The City is exposed to various risks related to its operations. Insurance is utilized to the extent practical to minimize these risks. Subsequent Events – Subsequent events were evaluated through the date of the auditor’s report, which is the date the financial statements were available to be issued. CITY OF EAGLE, IDAHO Notes to Financial Statements 19 B. CASH Cash consists of the following at year end: Governmental Proprietary Funds Funds Total Cash - Deposits $19,212,712 $8,378,879 $27,591,591 Total $19,212,712 $8,378,879 $27,591,591 Deposits – At year end, the carrying amounts of the City's deposits were $27,591,591 and the bank balances were $27,779,369. Of the bank balances, $250,000 was insured and $27,478,359 was collateralized. Investments – State statutes authorize government entities to invest in certain bonds, notes, accounts, investment pools, and other obligations of the state, U.S. Treasury, and U.S. corporations pursuant to Idaho Code 67-1210 and 67-1210A. These statutes are designed to help minimize the custodial risk that deposits may not be returned in the event of the failure of the issuer or other counterparty, interest rate risk resulting from fair value losses arising from rising interest rates, or credit risks that an issuer or other counterparty will not fulfill its obligations. The City's investment policy complies with state statutes. Restricted Cash – Restricted cash at year end is cash set aside because its use is limited by City ordinance, accounting policies, and loan covenants. In the general fund, cash received for surety bond deposits is reported as restricted. In the water fund, the customer deposit account is used to report resources received from users of the water system, to be returned to the customer when leaving the system provided that all utility bills are paid current. Supply trunk line fees and water construction equivalency fees received in the water fund are also reported as restricted. Per loan covenant, the City is required to restrict cash within its water fund to equal one annual loan payment. Management is not aware of any violations of this covenant. CITY OF EAGLE, IDAHO Notes to Financial Statements 20 C. CAPITAL ASSETS A summary of capital assets for the year is as follows: Beginning Ending Governmental Activities Balance Increases Decreases Balance Nondepreciable Capital Assets Land $5,067,029 $1,876,808 $6,943,837 Artwork/Collectibles 132,917 132,917 Construction in Progress 318,590 318,590 Total 5,518,536 1,876,808 $0 7,395,344 Depreciable Capital Assets Buildings 6,196,047 4,014,232 10,210,279 Improvements 13,902,540 1,841,388 15,743,928 Equipment 5,501,593 527,017 6,028,610 Subtotal 25,600,180 6,382,637 0 31,982,817 Accumulated Depreciation Buildings 1,933,213 204,039 2,137,252 Improvements 5,796,702 494,796 6,291,498 Equipment 4,612,913 228,909 4,841,822 Subtotal 12,342,828 927,744 0 13,270,572 Total 13,257,352 5,454,893 0 18,712,245 Net Capital Assets $18,775,888 $7,331,701 $0 $26,107,589 Depreciation expense of $927,744 was charged to the capital assets program. CITY OF EAGLE, IDAHO Notes to Financial Statements 21 Beginning Ending Business-Type Activities Balance Increases Decreases Balance Nondepreciable Capital Assets Land $93,250 $93,250 Total 93,250 $0 $0 93,250 Depreciable Capital Assets Buildings 559,285 559,285 Improvements 12,593,065 3,040,308 15,633,373 Equipment 1,394,602 1,799,900 3,194,502 Subtotal 14,546,952 4,840,208 0 19,387,160 Accumulated Depreciation Buildings 172,451 11,186 183,637 Improvements 3,518,225 514,957 4,033,182 Equipment 915,756 103,084 1,018,840 Subtotal 4,606,432 629,227 0 5,235,659 Total 9,940,520 4,210,981 0 14,151,501 Net Capital Assets $10,033,770 $4,210,981 $0 $14,244,751 Depreciation expense of $629,227 was charged to the water services program. D. LONG-TERM LIABILITIES Bonded Debt – At year end, the City’s bonded debt was as follows: Governmental Activities: Outstanding 2013 -$985,000 -general obligation bonds for capital assets due in annual principal installments and semiannual interest payments with interest at 2.00%- 5.00%through 2025/26,secured by future taxes,paid through the debt service fund $370,000 Total $370,000 Maturities on the bonds – governmental activities – are estimated as follows: Year Ended Principal Interest 9/30/23 $85,000 $18,500 9/30/24 90,000 14,250 9/30/25 95,000 9,750 9/30/26 100,000 5,000 Total $370,000 $47,500 CITY OF EAGLE, IDAHO Notes to Financial Statements 22 Business-Type Activities: Water Revenue Loan - At year end, the City’s water revenue loan was as follows: Water revenue loan -DEQ,due in semiannual payments of $90,918 with interest at 3.25%through 2026/27,secured by future user fees,paid through the water fund $749,059 Total $749,059 Maturities on the water revenue loan – business-type activities – are estimated as follows: Year Ended Principal Interest 9/30/23 $158,771 $23,065 9/30/24 163,973 17,863 9/30/25 169,346 12,490 9/30/26 174,894 6,942 9/30/27 82,075 1,334 Total $749,059 $61,694 Changes in long-term liabilities are as follows: Beginning Ending Due Within Description Balance*Increases Decreases Balance One Year Governmental Act. 2013 GO Bonds $450,000 $80,000 $370,000 $85,000 Bond Premium 41,169 10,291 30,878 10,291 Comp. Absences 222,093 93,278 128,815 128,815 Net Pension Liability 0 $3,230,169 3,230,169 - Subtotal 713,262 3,230,169 183,569 3,759,862 224,106 Business-Type Act. Water Revenue Loan 1,115,023 365,964 749,059 158,771 Comp. Absences 13,084 4,855 8,229 8,229 Net Pension Liability 0 296,214 296,214 - Subtotal 1,128,107 296,214 370,819 1,053,502 167,000 Total $1,841,369 $3,526,383 $554,388 $4,813,364 $391,106 Interest and related costs during the year amounted to $12,658 and $30,095 and were charged to the debt service – interest and water services programs, respectively. *The beginning balance was restated to remove the “2021 GO Bonds-SVCID” as the SVCID is now required to be reflected as a discretely presented component unit – see note H. CITY OF EAGLE, IDAHO Notes to Financial Statements 23 E. PENSION PLAN Plan description The City contributes to the Base Plan which is a cost-sharing multiple-employer defined benefit pension plan administered by Public Employee Retirement System of Idaho (PERSI or System) that covers substantially all employees of the State of Idaho, its agencies and various participating political subdivisions. The cost to administer the plan is financed through the contributions and investment earnings of the plan. PERSI issues a publicly available financial report that includes financial statements and the required supplementary information for PERSI. That report may be obtained on the PERSI website at www.persi.idaho.gov. Responsibility for administration of the Base Plan is assigned to the Board comprised of five members appointed by the Governor and confirmed by the Idaho Senate. State law requires that two members of the Board be active Base Plan members with at least ten years of service and three members who are Idaho citizens not members of the Base Plan except by reason of having served on the Board. Pension benefits The Base Plan provides retirement, disability, death and survivor benefits of eligible members or beneficiaries. Benefits are based on members’ years of service, age, and highest average salary. Members become fully vested in their retirement benefits with five years of credited service (5 months for elected or appointed officials). Members are eligible for retirement benefits upon attainment of the ages specified for their employment classification. The annual service retirement allowance for each month of credited service is 2.0% (2.3% for police/firefighters) of the average monthly salary for the highest consecutive 42 months. The benefit payments for the Base Plan are calculated using a benefit formula adopted by the Idaho Legislature. The Base Plan is required to provide a 1% minimum cost of living increase per year provided the Consumer Price Index increases 1% or more. The PERSI Board has the authority to provide higher cost of living increases to a maximum of the Consumer Price Index movement or 6%, whichever is less; however, any amount above the 1% minimum is subject to review by the Idaho Legislature. Member and employer contributions Member and employer contributions paid to the Base Plan are set by statute and are established as a percent of covered compensation. Contribution rates are determined by the PERSI Board within limitations, as defined by state law. The Board may make periodic changes to employer and employee contribution rates (expressed as percentages of annual covered payroll) that are adequate to accumulate sufficient assets to pay benefits when due. The contribution rates for employees are set by statute at 60% of the employer rate for general employees and 74% for police and firefighters. As of June 30, 2022 it was 7.16% for general employees and 9.13% for police and firefighters. The employer contribution rate as a percent of covered payroll is set by the Retirement Board and was 11.94% for general employees and 12.28% for police and firefighters. The City’s contributions were $440,960 for the year ended September 30, 2022. CITY OF EAGLE, IDAHO Notes to Financial Statements 24 Pension asset/liabilities, pension revenue (expense), and deferred outflows of resources and deferred inflows of resources related to pensions At September 30, 2022, the City reported a liability for its proportionate share of the net pension liability. The net pension liability was measured as of June 30, 2022, and the total pension liability used to calculate the net pension liability was determined by an actuarial valuation as of that date. The City’s proportion of the net pension liability was based on the City’s share of contributions in the Base Plan pension plan relative to the total contributions of all participating PERSI Base Plan employers. At June 30, 2022, the City’s proportion was 0.0895303 percent. For the year ended September 30, 2022, the City recognized pension revenue (expense) of ($956,628). At September 30, 2022, the City reported deferred outflows of resources and deferred inflows of resources related to pensions from the following sources: Deferred Deferred Outflows of Inflows of Resources Resources Differences between expected and actual experience $387,773 $15,739 Changes in assumptions or other inputs 574,906 Net difference between projected and actual earnings on pension plan investments 811,379 Employer contributions subsequent to the measurement date 110,240 Total $1,884,298 $15,739 $110,240 reported as deferred outflows of resources related to pensions resulting from City contributions made subsequent to the measurement date will be recognized as an adjustment to the pension expense in the year ending September 30, 2023. The average of the expected remaining service lives of all employees that are provided with pensions through the System (active and inactive employees) determined at July 1, 2022 the beginning of the measurement period ended June 30, 2021 is 4.6 and 4.6 for the measurement period June 30, 2022. Other amounts reported as deferred outflows of resources and deferred inflows of resources related to pensions will be recognized in pension revenue (expense) as follows: Year Ended 9/30/23 ($420,478) 9/30/24 (456,469) 9/30/25 (211,117) 9/30/26 (670,255) Total ($1,758,319) Actuarial assumptions Valuations are based on actuarial assumptions, the benefit formulas, and employee groups. Level percentages of payroll normal costs are determined using the Entry Age Normal Cost Method. Under the Entry Age Normal Cost Method, the actuarial present value of the projected benefits of each individual included in the actuarial valuation is allocated as a level percentage of each year’s earnings of the individual CITY OF EAGLE, IDAHO Notes to Financial Statements 25 between entry age and assumed exit age. The Base Plan amortizes any unfunded actuarial accrued liability based on a level percentage of payroll. The maximum amortization period for the Base Plan permitted under Section 59-1322, Idaho Code, is 25 years. The total pension liability in the June 30, 2022 actuarial valuation was determined using the following actuarial assumptions, applied to all periods included in the measurement: Inflation 2.30% Salary increases including inflation 3.05% Investment rate of return, net of investment expenses 6.35% Cost-of-living adjustments 1.00% Contributing members, service retirement members, and beneficiaries General Employees and All Beneficiaries ‐ Males Pub‐2010 General Tables, increased 11% General Employees and All Beneficiaries ‐ Females Pub‐2010 General Tables, increased 21% Teachers ‐ Males Pub‐2010 Teacher Tables, increased 12% Teachers ‐ Females Pub‐2010 Teacher Tables, increased 21% Fire & Police ‐ Males Pub‐2010 Safety Tables, increased 21% Fire & Police ‐ Females Pub‐2010 Safety Tables, increased 26% 5% of Fire & Police active member deaths are assumed to be duty related. This assumption was adopted July 1, 2021. Disabled Members ‐ Males Pub‐2010 Disabled Tables, increased 38% Disabled Members ‐ Females Pub‐2010 Disabled Tables, increased 36% An experience study was performed for the period July 1, 2015 through June 30, 2020 which reviewed all economic and demographic assumptions other than mortality. The total pension liability as of June 30, 2022 is based on the results of an actuarial valuation date of July 1, 2022. The long-term expected rate of return on pension plan investments was determined using the building block approach and a forward-looking model in which best estimate ranges of expected future real rates of return (expected returns, net of pension plan investment expense and inflation) are developed for each major asset class. These ranges are combined to produce the long-term expected rate of return by weighing the expected future real rates of return by the target asset allocation percentage and by adding expected inflation. Even though history provides a valuable perspective for setting the investment return assumption, the System relies primarily on an approach which builds upon the latest capital market assumptions. Specifically, the System uses consultants, investment managers and trustees to develop capital market assumptions in analyzing the System’s asset allocation. The assumptions and the System’s formal policy for asset allocation are shown below. The formal asset allocation policy is somewhat more conservative than the current allocation of System’s assets. The best-estimate range for the long-term expected rate of return is determined by adding expected inflation to expected long-term real returns and reflecting expected volatility and correlation. The capital market assumptions are as of 2022. CITY OF EAGLE, IDAHO Notes to Financial Statements 26 Target Long-Term Expected Asset Class Allocation Real Rate of Return Cash 0%0.00% Large Cap 18%4.50% Small/Mid Cap 11%4.70% International Equity 15%4.50% Emerging Markets Equity 10%4.90% Domestic Fixed 20%-0.25% TIPS 10%-0.30% Real Estate 8%3.75% Private Equity 8%6.00% Discount rate The discount rate used to measure the total pension liability was 6.35%. The projection of cash flows used to determine the discount rate assumed that contributions from plan members will be made at the current contribution rate. Based on these assumptions, the pension plans’ 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 benefit payments to determine the total pension asset. The long-term expected rate of return was determined net of pension plan investment expense but without reduction for administrative expense. Sensitivity of the City's proportionate share of the net pension liability to changes in the discount rate. The following presents the City's proportionate share of the net pension liability calculated using the discount rate of 6.35 percent, as well as what the City's proportionate share of the net pension liability would be if it were calculated using a discount rate that is 1-percentage-point lower or 1-percentage-point higher than the current rate: Current 1% Decrease Discount Rate 1% Increase (5.35%)(6.35%)(7.35%) City's proportionate share of the net pension liability $6,223,720 $3,526,383 $1,318,682 Pension plan fiduciary net position Detailed information about the pension plan's fiduciary net position is available in the separately issued PERSI financial report. PERSI issues a publicly available financial report that includes financial statements and the required supplementary information for PERSI. That report may be obtained on the PERSI website at www.persi.idaho.gov. Impact on the City’s net position Depending on the annual performance of the Base Plan and the various non-financial factors that affect the collective Base Plan net pension liability (as described above), the City may periodically experience a deficit in its net position. This can occur as a result of recording the City’s allocable portion of the net CITY OF EAGLE, IDAHO Notes to Financial Statements 27 pension liability which is an estimated liability that changes substantially from year to year depending on the factors described above but does not currently require cash outflows. As the net pension liability of the Base Plan is closely monitored by PERSI’s board (who makes changes to the contribution rates and other terms of the Base Plan when deemed necessary), such deficits are not deemed to be of substantial concern. F. INTERFUND TRANSFERS Interfund transfers during the year consist of the following: Fund Transfer In Transfer Out Purpose General $142,073 Debt Service, Balance Transfer Debt Service $99,544 Debt Service Capital Projects 4,083,265 Projects & Equipment Fiber 4,083,265 Projects & Equipment Nonmajor Governmental 42,529 Balance Transfer Total $4,225,338 $4,225,338 G. TAX ABATEMENTS Idaho counties are authorized by state statute to transact certain property tax activity with property owners in their respective taxing districts. The counties collect the property taxes, then allocate and remit those collections among the taxing districts within the counties. The counties are authorized to cancel or reduce property taxes due to various reasons, including the circuit breaker program, agricultural and other exemptions, and section 63-602NN exemptions under Idaho code for real property improvements. H. COMPONENT UNIT REPORTING CLASSIFICATION Due to changes affecting the reporting classification of the City’s component unit (the SVCID), the City has updated the reporting classification for the SVCID from the blending method to discrete presentation. CITY OF EAGLE, IDAHO Budgetary Comparison Schedule - General and Major Special Revenue Funds Year Ended September 30, 2022 Page 1 of 2 Final Budget Variance Actual Positive General Fund Original Final Amounts (Negative) Revenues Taxes $2,719,505 $2,719,505 $2,775,360 $55,855 Franchise Fees 889,000 889,000 1,057,287 168,287 Intergovernmental 3,728,077 3,728,077 4,269,598 541,521 Licenses, Permits, & Fees 3,602,200 3,602,200 3,553,147 (49,053) Interest 7,000 7,000 17,897 10,897 Miscellaneous & Grants 9,031,950 9,031,950 2,260,217 (6,771,733) Total Revenues 19,977,732 19,977,732 13,933,506 (6,044,226) Expenditures Current Expenditures General Government 18,155,387 18,155,387 5,274,974 12,880,413 Public Safety 3,572,672 3,572,672 3,572,671 1 Parks, Pathways, & Streets 2,388,256 2,388,256 1,672,831 715,425 Culture & Recreation 1,319,225 1,319,225 920,854 398,371 Capital Outlay 0000 Debt Service - Principal 0000 Debt Service - Interest 0000 Total Expenditures 25,435,540 25,435,540 11,441,330 13,994,210 * Excess (Deficiency) of Revenues Over Expenditures (5,457,808) (5,457,808) 2,492,176 7,949,984 Other Financing Sources (Uses) Transfers In 0000 Transfers Out (102,950) (102,950) (142,073) (39,123) * Total Other Financing Sources (Uses)(102,950) (102,950) (142,073) (39,123) Net Change in Fund Balances (5,560,758) (5,560,758) 2,350,103 7,910,861 Fund Balances - Beginning 5,560,758 5,560,758 4,602,950 (957,808) Fund Balances - Ending $0 $0 $6,953,053 $6,953,053 *Total expenditures (over) under appropriations are:$13,955,087 Budgeted Amounts (GAAP Basis) See Auditor's Report 28 CITY OF EAGLE, IDAHO Budgetary Comparison Schedule - General and Major Special Revenue Funds Year Ended September 30, 2022 Page 2 of 2 Final Budget Variance Actual Positive Library Fund Original Final Amounts (Negative) Revenues Taxes $1,493,845 $1,493,845 $1,497,313 $3,468 Franchise Fees 0000 Intergovernmental 0000 Licenses, Permits, & Fees 6,500 6,500 7,255 755 Interest 700 700 2,200 1,500 Miscellaneous & Grants 750 750 7,632 6,882 Total Revenues 1,501,795 1,501,795 1,514,400 12,605 Expenditures Current Expenditures General Government 0000 Public Safety 0000 Parks, Pathways, & Streets 0000 Culture & Recreation 1,935,534 1,935,534 1,268,433 667,101 Capital Outlay 136,301 136,301 116,184 20,117 Debt Service - Principal 0000 Debt Service - Interest 0000 Total Expenditures 2,071,835 2,071,835 1,384,617 687,218 * Excess (Deficiency) of Revenues Over Expenditures (570,040) (570,040) 129,783 699,823 Other Financing Sources (Uses) Transfers In 0000 Transfers Out 0000* Total Other Financing Sources (Uses)0000 Net Change in Fund Balances (570,040) (570,040) 129,783 699,823 Fund Balances - Beginning 570,040 570,040 832,267 262,227 Fund Balances - Ending $0 $0 $962,050 $962,050 *Total expenditures (over) under appropriations are:$687,218 Budgeted Amounts (GAAP Basis) See Auditor's Report 29 CITY OF EAGLE, IDAHO Schedule of Employer's Share of Net Pension Asset and Liability and Schedule of Employer Contributions PERSI - Base Plan Employer's Proportional Share of the Plan Fiduciary Employer's Net Pension Net Position Employer's Proportionate (Asset) Liability as a Percentage Fiscal Year Portion of the Share of the as a Percentage of the Total Ended Net Pension Net Pension Covered of Covered Pension June 30 (Asset) Liability (Asset) Liability Payroll Payroll (Asset) Liability 2015 0.0600540% $790,813 $1,674,832 47.22% 91.38% 2016 0.0611008% $1,238,607 $1,756,405 70.52% 87.26% 2017 0.0640585% $1,006,890 $1,989,611 50.61% 90.68% 2018 0.0727685% $1,073,348 $2,341,228 45.85% 91.69% 2019 0.0754206% $860,905 $2,561,590 33.61% 93.79% 2020 0.0806411% $1,872,593 $2,871,533 65.21% 88.22% 2021 0.0861453% ($68,036) $3,214,824 -2.12% 100.36% 2022 0.0895303% $3,526,383 $3,530,578 99.88% 83.09% *As of the measurement date of the net pension (asset) liability. Contributions in Relation to Contributions Fiscal Year Actuarially Actuarially Contribution as a Percentage Ended Determined Determined Deficiency Covered of Covered September 30 Contribution Contribution (Excess) Payroll Payroll 2015 $189,591 $189,591 $0 $1,674,832 11.32% 2016 $198,825 $198,825 $0 $1,756,405 11.32% 2017 $228,241 $228,241 $0 $2,016,263 11.32% 2018 $269,919 $269,919 $0 $2,384,443 11.32% 2019 $309,754 $309,754 $0 $2,700,821 11.47% 2020 $352,614 $352,614 $0 $2,953,216 11.94% 2021 $398,638 $398,638 $0 $3,338,677 11.94% 2022 $440,960 $440,960 $0 $3,693,132 11.94% Schedule of Employer's Share of Net Pension Asset and Liability* Schedule of Employer Contributions Schedules above intended to show information for 10 years. Information for additional years will be presented as it becomes available. See Auditor's Report 30 CITY OF EAGLE, IDAHO Schedule of Expenditures of Federal Awards Year Ended September 30, 2022 Federal Pass-Through Federal Grantor/ Pass-Through AL Entity Identifying Federal Grantor/Program or Cluster Title Number Number Expenditures US Dept of Interior Passed Through Idaho State Historical Society Historic Preservation Fund Grants 15.904 None $1,734 Total US Dept of Interior 1,734 US Dept of Transportation Passed Through Idaho Transportation Dept Highway Planning & Construction Cluster: COVID-19 - Highway Planning & Construction 20.205 None 291,913 Total Highway Planning & Construction Cluster 291,913 Total US Dept of Transportation 291,913 US Dept of Treasury Passed Through Idaho State Controller's Office COVID-19 - Coronavirus State and Local Fiscal Recovery Funds 21.027 None 2,042,434 Total US Dept of Treasury 2,042,434 US Dept of Homeland Security Passed Through Idaho Office of Emergency Management COVID-19 - Disaster Grants Public Assistance 97.036 FEMA-4342 DR-ID 23,396 BRIC: Building Resilient Infrastructure and Communities 97.047 EMS-2020-PC-0003 177,205 Total US Dept of Homeland Security 200,601 Total Expenditures of Federal Awards $2,536,682 NOTES: A. Basis of Presentation - The accompanying schedule of expenditures of federal awards (the schedule) includes the federal award activity of the City under programs of the federal governmentfor the year ended September30, 2022. The information in this schedule is presented in accordance with the requirements of Title 2 U.S.Code of Federal Regulations Part 200,Uniform Administrative Requirements.Because the schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position, or cash flows of the City. B. Summary of Significant Accounting Policies - Expenditures reported on the schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. The City has not elected to use the 10 percent de minimis indirect cost rate as allowed under the Uniform Guidance. See Auditor's Report 31 32 11501 Highway 95, Payette, Idaho 83661 | www.qcpas.com | info@qcpas.com | 208-642-1417 Independent Auditor’s Report on Internal Control Over Financial Reporting and on Compliance and Other Matters Based on an Audit of Financial Statements Performed in Accordance With Government Auditing Standards Honorable Mayor and City Council City of Eagle, Idaho We have audited, in accordance with the auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards issued by the Comptroller General of the United States, the 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 the City of Eagle, Idaho (the City), as of and for the year ended September 30, 2022, and the related notes to the financial statements, which collectively comprise the City’s basic financial statements, and have issued our report thereon dated December 26, 2022. Report on Internal Control Over Financial Reporting In planning and performing our audit of the financial statements, we considered the City’s internal control over financial reporting (internal control) as a basis for designing audit procedures that are appropriate in the circumstances for the purpose of expressing our opinions on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of the City’s internal control. Accordingly, we do not express an opinion on the effectiveness of the City’s internal control. A deficiency in internal control exists when the design or operation of a control does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, misstatements on a timely basis. A material weakness is a deficiency, or combination of deficiencies, in internal control, such that there is a reasonable possibility that a material misstatement of the entity’s financial statements will not be prevented, or detected and corrected on a timely basis. A significant deficiency is a deficiency, or a combination of deficiencies, in internal control that is less severe than a material weakness, yet important enough to merit attention by those charged with governance. Our consideration of internal control over financial reporting was for the limited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in internal control that might be material weaknesses or significant deficiencies. Given these limitations, during our audit we did not identify any deficiencies in internal control that we consider to be material weaknesses. However, material weaknesses or significant deficiencies may exist that have not been identified. Report on Compliance and Other Matters As part of obtaining reasonable assurance about whether the City’s financial statements are free of material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements, noncompliance with which could have a direct and material effect on the determination of financial statement amounts. However, providing an opinion on compliance with those provisions was not an objective of our audit, and accordingly, we do not express such an opinion. The 33 results of our tests disclosed no instances of noncompliance or other matters that are required to be reported under Government Auditing Standards. Purpose of this Report The purpose of this report is solely to describe the scope of our testing of internal control and compliance and the results of that testing, and not to provide an opinion on the effectiveness of the City’s internal control or compliance. This report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the City’s internal control over financial reporting and compliance. Accordingly, this communication is not suitable for any other purpose. Quest CPAs PLLC Payette, Idaho December 26, 2022 34 11501 Highway 95, Payette, Idaho 83661 | www.qcpas.com | info@qcpas.com | 208-642-1417 Independent Auditor’s Report on Compliance for Each Major Program and on Internal Control Over Compliance Required by the Uniform Guidance Honorable Mayor and City Council City of Eagle, Idaho Report on Compliance for Each Major Federal Program Opinion on Each Major Federal Program We have audited the City of Eagle, Idaho’s (the City’s) compliance with the types of compliance requirements identified as subject to audit in the OMB Compliance Supplement that could have a direct and material effect on each of the City’s major federal programs for the year ended September 30, 2022. The City’s major federal programs are identified in the summary of auditor's results section of the accompanying schedule of findings and questioned costs. In our opinion, the City complied, in all material respects, with the types of compliance requirements referred to above that could have a direct and material effect on each of its major federal programs for the year ended September 30, 2022. Basis for Opinion on Each Major Federal Program We conducted our audit of compliance in accordance with auditing standards generally accepted in the United States of America; the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States; and the audit requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Our responsibilities under those standards and the Uniform Guidance are further described in the Auditor’s Responsibilities for the Audit of Compliance section of our report. We are required to be independent of the City and to meet our other ethical responsibilities, in accordance with 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 opinion on compliance for each major federal program. Our audit does not provide a legal determination of the City’s compliance with the compliance requirements referred to above. Responsibilities of Management for Compliance Management is responsible for compliance with the requirements referred to above and for the design, implementation, and maintenance of effective internal control over compliance with the requirements of laws, statutes, regulations, rules, and provisions of contracts or grant agreements applicable to the City’s federal programs. 35 Auditor’s Responsibilities for the Audit of Compliance Our objectives are to obtain reasonable assurance about whether material noncompliance with the compliance requirements referred to above occurred, whether due to fraud or error, and express an opinion on the City’s compliance based on our audit. Reasonable assurance is a high level of assurance but is not absolute assurance and therefore is not a guarantee that an audit conducted in accordance with generally accepted auditing standards, Government Auditing Standards, and the Uniform Guidance will always detect material noncompliance when it exists. The risk of not detecting material noncompliance resulting from fraud is higher than for that resulting from error, as fraud may involve collusion, forgery, intentional omissions, misrepresentations, or the override of internal control. Noncompliance with the compliance requirements referred to above is considered material if there is a substantial likelihood that, individually or in the aggregate, it would influence the judgment made by a reasonable user of the report on compliance about the City’s compliance with the requirements of each major federal program as a whole. In performing an audit in accordance with generally accepted auditing standards, Government Auditing Standards, and the Uniform Guidance, we: • Exercise professional judgment and maintain professional skepticism throughout the audit. • Identify and assess the risks of material noncompliance, 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 City’s compliance with the compliance requirements referred to above and performing such other procedures as we considered necessary in the circumstances. • Obtain an understanding of the City’s internal control over compliance relevant to the audit in order to design audit procedures that are appropriate in the circumstances and to test and report on internal control over compliance in accordance with the Uniform Guidance, but not for the purpose of expressing an opinion on the effectiveness of the City’s internal control over compliance. Accordingly, no such opinion is expressed. We are required to communicate with those charged with governance regarding, among other matters, the planned scope and timing of the audit and any significant deficiencies and material weaknesses in internal control over compliance that we identified during the audit. Report on Internal Control Over Compliance A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, noncompliance with a type of compliance requirement of a federal program on a timely basis. A material weakness in internal control over compliance is a deficiency, or combination of deficiencies, in internal control over compliance, such that there is a reasonable possibility that material noncompliance with a type of compliance requirement of a federal program will not be prevented, or detected and corrected, on a timely basis. A significant deficiency in internal control over compliance is a deficiency, or a combination of deficiencies, in internal control over compliance with a type of compliance requirement of a federal program that is less severe than a material weakness in internal control over compliance, yet important enough to merit attention by those charged with governance. Our consideration of internal control over compliance was for the limited purpose described in the Auditor’s Responsibilities for the Audit of Compliance section above and was not designed to identify all deficiencies in internal control over compliance that might be material weaknesses or significant deficiencies in internal control over compliance. Given these limitations, during our audit we did not identify any deficiencies in 36 internal control over compliance that we consider to be material weaknesses, as defined above. However, material weaknesses or significant deficiencies may exist that were not identified. Our audit was not designed for the purpose of expressing an opinion on the effectiveness of internal control over compliance. Accordingly, no such opinion is expressed. The purpose of this report in internal control over compliance is solely to describe the scope of our testing of internal control over compliance and the results of that testing based on the requirements of the Uniform Guidance. Accordingly, this report is not suitable for any other purpose. Quest CPAs PLLC Payette, Idaho December 26, 2022 CITY OF EAGLE, IDAHO Schedule of Findings and Questioned Costs Year Ended September 30, 2022 37 SUMMARY OF AUDITOR’S RESULTS FINANCIAL STATEMENTS Type of auditor’s report being issued: Unmodified Internal control over financial reporting: Material weakness(es) identified? No Significant deficiency(ies) identified? None reported Noncompliance material to the financial statements noted? No FEDERAL AWARDS Internal control over major programs: Material weakness(es) identified? No Significant deficiency(ies) identified? None reported Type of auditor’s report issued on compliance for major programs: Unmodified Any audit findings that are required to be reported in accordance with 2 CFR section 200.516(a)? No Major program identification: a. Highway Planning & Construction Cluster – AL #20.205 b. COVID-19 - Coronavirus State and Local Fiscal Recovery Funds – AL #21.027 Dollar threshold used to distinguish between type A and B programs: $750,000 Auditee qualified as a low-risk auditee? No