Loading...
HomeMy WebLinkAbout2023 Financial Statements FINANCIAL STATEMENTS June 30, 2023 Heather Moreno, MAYOR Susan Funk, MAYOR PRO TEMPORE Charles Bourbeau, COUNCIL MEMBER Mark Dariz, COUNCIL MEMBER Heather Newsom, COUNCIL MEMBER Gere W. Sibbach, CITY TREASURER James R. Lewis, CITY MANAGER Prepared by the Department of Administrative Services CITY OF ATASCADERO TABLE OF CONTENTS June 30, 2023 Independent Auditors' Report……………………...…………………………………………………………………………………………………………………………………………1 Management's Discussion and Analysis…………………………………………………………………………………………………………………………………………………………………………………3 Basic Financial Statements: Government-wide Financial Statements: Statement of Net Position……………………………………………………………………….……………………………………………………………………………………………………………………14 Statement of Activities………………………………………………………………………………………………………………………………………………………….16 Fund Financial Statements: Governmental Funds: Balance Sheet……………………………………………………………………………………………………………………………………………………………………17 Reconciliation of the Governmental Funds - Balance Sheet to the Statement of Net Position…………………………………………………………………19 Statement of Revenues, Expenditures, and Changes in Fund Balances……………………………………………………………………………………..21 Reconciliation of the Statement of Revenues, Expenditures, and Changes in Fund Balances of Governmental Funds to the Statement of Activities……………………………...……..……………………...……………………………………..23 Proprietary Funds: Statement of Net Position……………………………….…………………………………………………………………………………………………………………………25 Combining Statement of Revenues, Expenses, and Changes in Net Position……………………………………………………………………………………………………….27 Combining Statement of Cash Flows………………………………………………………………………………………...……………………………………………………………29 Private Purpose Trust Funds: Statement of Fiduciary Net Position……………………………….…………………………………………………………………………………………………………………………31 Statement of Changes in Fiduciary Net Position………………………………………………………………………………………………………………………………….32 Notes to the Basic Financial Statements……………………………………………………………………………………………………………………………………………33 Required Supplementary Information: Schedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual - General Fund Summary ………………………………………………77 Schedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual - General Fund Detail………………………………………………79 Schedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual - In Lieu Low/Moderate Income Housing Fund………………………………………………97 Schedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual - Local Transportation Fund……………………...............................98 Schedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual - Circulation System Fees Fund………………………………………………100 Schedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual - Fire Aerial Vehicle Impact Fees Fund………………………………………………101 Schedule of Changes in the Total OPEB Liability and Related Ratios…………………………………………………………………………………………………102 i CITY OF ATASCADERO TABLE OF CONTENTS June 30, 2023 Required Supplementary Information (continued): Schedule of OPEB Contributions……………………………………………….…………………………………………………………………………………………………103 Schedule of the Local Government's Proportionate Share of the Net Pension Liability ……………………………………………………………………………………………………104 Schedule of Pension Contributions…………………………………………………………………………………………………………………………………………………………….105 Other Supplementary Information: Major Debt Service Fund: Schedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual - 2010 Bond Debt Service Fund………………………………………………106 Nonmajor Governmental Funds Overview………………………………………………………………………………………………………………………………………….107 Combining and Individual Fund Statements and Schedules: Combining Balance Sheet - Nonmajor Governmental Funds………………………………………………………………………………………………………………111 Combining Statement of Revenues, Expenditures, and Changes in Fund Balances - Nonmajor Governmental Funds…………………………………..………………116 Schedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual: Supplemental Law Enforcement Services Fund…………………………………………………………………………………………………………………………….121 Downtown Business Improvement Area Fund……………………………………………………………………………………………………………………………………….122 Atascadero Tourism Business Improvement District Fund……………………………………………………………………………………………………………………………………….123 Community Development Block Grant Fund………………………………………………………………………………………………………………………………..124 Tree Plant Fund………………………………………………………………………………………………………………………………………………………………125 Gas Tax Fund…………………………………………………………………………………………………………………………………………………………………..126 Street Assessment Fund……………………………………………………………………………………………………………………………………………………..128 General Government Facilities Fees Fund……………………………………………………………………………………………………………………………………..129 Storm Drainage Facilities Fees Fund…………………………………………………………………………………………………………………………………………….130 Law Enforcement Facilities Fees Fund…………………………………………………………………………………………………………………………………….131 Fire Facilities Fees Fund…………………………………………………………………………………………………………………………………………………………..132 Open Space Acquisition Fees Fund……………………………………………………………………………………………………………………………………………….133 Parkland Facilities Fees Fund………………………………………………………………………………………………………………………………………………………134 Public Facilities Fees Fund………………………………………………………………………………………………………………………………………………………135 Library Expansion Facilities Fees Fund………………………………………………………………………………………………………………………………………………136 Community Facilities District Fund…………………………...………………..…………………………………………………………………………………………..137 ii CITY OF ATASCADERO TABLE OF CONTENTS June 30, 2023 Other Supplementary Information (continued): Combining and Individual Fund Statements and Schedules (continued): Schedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual (continued): Apple Valley Street & Storm Drain Assessment District Fund………….……………………………………………………………………………………………138 Apple Valley Landscape & Lighting Assessment District Fund…………………..…………………………………………………………………………………………139 Las Lomas Street & Storm Drain Assessment District Fund……………………...………………………………………………………………………………………140 Las Lomas Landscape & Lighting Assessment District Fund…………………………...……………………………………………………………………………………141 De Anza Street & Storm Drain Assessment District Fund…………………………..…………………………………………………………………………………142 De Anza Landscape & Lighting Assessment District Fund…………………………...…………………………………………………………………………………143 Capital Projects Fund……………………………………………………………………………………………………………………………………………………………144 2010 Bond Proceeds Master Agreement Fund……………………………………………………………………………………………………………………………………………………………145 Combining Statement of Net Position - Internal Service Funds……………………………………………………………………………………………………………………146 Combining Statement of Revenues, Expenses, and Changes in Net Position - Internal Service Funds…………………………………………………………………..148 Combining Statement of Cash Flows - Internal Service Funds……………………………………………………………………………………………………………..150 iii Moss, Levy & Hartzheim LLP Certified Public Accountants 2400 Professional Parkway, Suite 205 Santa Maria, CA 93455 Tel 805.925.2579 Fax 805.925.2147 mlhcpas.com BEVERLY HILLS ∙ CULVER CITY ∙ SANTA MARIA INDEPENDENT AUDITORS’ REPORT City Council of the City of Atascadero Atascadero, California Report on the Audit of the Financial Statements Opinions We have audited the accompanying financial statements of the governmental activities, the business-type activities, the major funds, and the aggregate remaining fund information of the City of Atascadero, as of and for the fiscal year ended June 30, 2023, and the related notes to the financial statements, which collectively comprise the City of Atascadero’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 major funds, and the aggregate remaining fund information of the City of Atascadero, as of June 30, 2023, and the respective changes in financial position and, where applicable, cash flows thereof, for the fiscal 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 of Atascadero 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 the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair 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 of Atascadero’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. Auditors’ Responsibilities for the Audit of the Financial Statements Our objectives are to obtain reasonable assurance about whether the financial statements as a whole are free from material misstatement, whether due to fraud or error, and to issue an auditors’ 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 of internal control. Misstatements are considered material if there is a substantial likelihood that, individually or in the aggregate, they would influence the judgment made by a reasonable user based on the financial statements. In performing an audit in accordance with 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 of Atascadero’s internal control. Accordingly, no such opinion is expressed. 1  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 of Atascadero’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 management’s discussion and analysis, the budgetary comparison information the General Fund and major special revenue funds, the schedule of changes in the OPEB liability and related ratios, the schedule of OPEB contributions, the schedule of the local government’s proportionate share of net pension liability, and the schedule of pension contributions, be presented to supplement the basic financial statements. Such information, although not a part of the basic financial statements, is required by the Governmental Accounting Standards Board, who considers it to be an essential part of financial reporting for placing the basic financial statements in an appropriate operational, economic, or historical context. We have applied certain limited procedures to the required supplementary information in accordance with auditing standards generally accepted in the United States of America, which consisted of inquires of management about the methods of preparing the information and comparing the information for consistency with management’s responses to our inquiries, the basic financial statements, and other knowledge we obtained during our audit of the basic financial statements. We do not express an opinion or provide any assurance on the information because the limited procedures do not provide us with sufficient evidence to express an opinion or provide any assurance. Other Information Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the City of Atascadero’s basic financial statements. The major debt service fund budgetary schedule, combining and individual nonmajor fund financial statements and schedules, and combining internal service funds financial statements, are presented for purposes of additional analysis and are not a required part of the basic financial statements. The major debt service fund budgetary schedule, combining and individual nonmajor fund financial statements and schedules, and combining internal service funds financial statements, are the responsibility of management and were derived from and relate directly to the underlying accounting and other records used to prepare the basic financial statements. Such 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 major debt service fund budgetary schedule, combining and individual non-major fund financial statements and schedules, and combining internal service funds financial statements, are 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 15, 2023, on our consideration of the City of Atascadero’s internal control over financial reporting and on our tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements and other matters. The purpose of that report is 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 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. Santa Maria, California December 15, 2023 2 3 Working together to serve, build community and enhance quality of life. Management’s Discussion and Analysis December 15, 2023 To the Honorable Mayor, Members of the City Council, and Residents of the City of Atascadero It is our pleasure to present to you the annual financial statements of the City of Atascadero, California for the fiscal year ending on June 30,2023. The City prepares a complete set of financial statements in conformity with U.S. generally accepted accounting principles (GAAP) after the end of each fiscal year. This discussion and analysis of the City of Atascadero’s financial performance provides an overview of the City’s financial activities for the fiscal year ended June 30, 2023. For the most complete picture of the City, please read this document in conjunction with the City’s basic financial statements and the accompanying notes to the basic financial statements. The City’s financial statements are available at City Hall offices. Financial Highlights City total assets and deferred outflows of resources exceeded its liabilities and deferred inflows of resources at the close of June 30, 2023, by about $219.2 million. Of this amount, $152.3 million is net investment in capital assets, $41.8 million is restricted for various purposes, and $25.1 million is unrestricted. • Capital projects expenditures were about $720,000 less than the amount spent in the prior fiscal year due primarily to timing and status of many different road rehabilitation projects that were ongoing through both the current and prior fiscal years. • As of the close of the current fiscal year, the City’s governmental funds reported combined ending fund balances of $62.4 million, an increase of about $2.4 million from the prior fiscal year. Approximately $42.1 million of the total is not available for more general spending because it represents amounts that are already obligated or restricted. About $20.3 million of the ending fund balance is available for future obligations. • The City’s compensated absences due to employees increased by about $41,000, and the City’s total long-term liabilities increased by about $16.3 million. This increase was primarily due to the City’s change in CalPERS Net Pension Liability. For additional information, see Note 8 in the Notes to the Financial Statements. City of Atascadero Management’s Discussion and Analysis Fiscal Year Ended June 30, 2023 4 Financial Highlights (continued) • At the end of the current fiscal year, unassigned fund balance for the general fund was $20,956,096 or 51% of total general fund expenditures, $4,010,327 of which is related to the Sales Tax Measure F-14 funding. • The American Rescue Plan Act (ARPA) funds were allocated to the City in two tranches of $3,597,290 each for economic recovery from the effects of COVID-19. The first tranche was received in July 2021 and the second in July 2022. Overview of the Financial Statements The financial statements presented herein include the activities of the City of Atascadero using the integrated approach as prescribed by Governmental Accounting Standards Board (GASB) Statement No. 34. Government-Wide Financial Statements The Government-Wide Financial Statements present a broad overview of the financial picture of the City from the economic resources measurement focus using the accrual basis of accounting. They present governmental activities and business-type activities separately. These statements include all assets of the City (including infrastructure) as well as all liabilities (including long-term liabilities). Additionally, certain eliminations have occurred as prescribed by GASB Statement No. 34 in regard to interfund activity, payables, and receivables. The Statement of Net Position presents information on all of the City’s assets, deferred outflows, liabilities, and deferred inflows, with the difference reported as net position. Over time, increases or decreases in net position may serve as an indicator of whether the financial position of the City of Atascadero is improving or declining. The Statement of Activities presents information showing how the government’s net position changed during the most recent fiscal year. All changes in net position are reported as soon as the underlying event giving rise to the change occurs, regardless of the timing of the related cash flows. Thus, revenues and expenses are reported in this statement for some items that will only result in cash flows in future fiscal periods. Both of the Government-wide Financial Statements distinguish functions of the City that are principally supported by taxes and intergovernmental revenues (governmental activities) from other functions that are intended to recover all or a significant portion of their costs through user fees or are required by grantor agencies to be accounted for in this fashion (business-type activities). The governmental activities include police, fire, parks, recreation, community development, public works, and general government activities. Property and sales taxes, user fees, interest income, franchise fees, and state and federal grants finance these activities. The business-type activities include wastewater and transit. As required by accounting principles generally accepted in the United States of America, these financial statements present the City (the primary government). The City previously had a component unit (the Community Redevelopment Agency of Atascadero) through January 31, 2012, for which the government was considered to be financially accountable. Effective February 1, 2012, Assembly Bill AB 1x26, as modified by the California Supreme Court, dissolved redevelopment agencies in California. All assets and liabilities were required to be transferred to the corresponding Successor Agency identified in each City of Atascadero Management’s Discussion and Analysis Fiscal Year Ended June 30, 2023 5 Government-Wide Financial Statements (continued) community. In Atascadero, the City became the Successor Agency and holds these assets and liabilities in Private Purpose Trust. See Note 15 in the Notes to the Financial Statements for further details on the Successor Agency. The City has no component units that require discrete presentation in accordance with GASB Statement No. 14, as amended by GASB Statements No. 39, No. 61, No. 80, and No. 90. Fund Financial Statements A fund is a group of related accounts that is used to maintain control over resources that have been segregated for specific activities or objectives. The City of Atascadero, like other state and local governments, uses fund accounting to ensure and demonstrate compliance with finance-related legal requirements. The funds of the City are divided into three categories of activities – governmental, proprietary, and private purpose trust funds. Governmental Funds Governmental funds are used to account for essentially the same functions reported as governmental activities in the Government-wide Financial Statements. However, unlike the Government-wide Financial Statements, Governmental Fund Financial Statements focus on near-term inflows and outflows of spendable resources, as well as on balances of spendable resources available at the end of the fiscal year. Such information may be useful in evaluating a government’s near-term financing requirements. Because the focus of Governmental Fund Financial Statements is narrower than that of the Government-wide Financial Statements, it is useful to compare the information presented for governmental funds with similar information presented for governmental activities in the Government-wide Financial Statements. By doing so, readers may better understand the long-term impact of the government’s near-term financing decisions. Both the governmental funds balance sheet and the governmental funds statement of revenues, expenditures, and changes in fund balances provide a reconciliation to facilitate this comparison between governmental funds and governmental activities. The City maintains multiple individual governmental funds. Information for the General Fund is presented separately in the governmental funds balance sheet and in the governmental funds statement of revenues, expenditures, and changes in fund balances. The General Fund, the In Lieu Low/Moderate Income Housing Fund, the Local Transportation Fund, the Circulation System Fees Fund, the Fire Aerial Vehicle Impact Fees Fund, and the 2010 Bond Debt Service Fund are considered to be the major governmental funds. Data from the other nonmajor governmental funds are combined into a single, aggregated presentation. Individual fund data, including budgetary information, for each of these nonmajor governmental funds are provided in the combining financial statements under the supplementary information section. A budget comparison statement has been provided to demonstrate compliance with the budget. Budgetary information for the major governmental funds has been provided under the required supplementary information section. Proprietary Funds Proprietary Funds provide the same type of information as the business-type activities in the government-wide financial statements, except that the Proprietary Funds provide greater detail. The City maintains two types of Proprietary Funds: Enterprise Funds and Internal Service Funds. The City’s Enterprise Funds are the same as the business-type activities reported in the Government-wide Financial Statements: Transit and Wastewater. The City uses Internal Service Funds to report activities that provide supplies and services for the City’s other programs and activities. The City’s Internal Services Funds include the Technology Fund, the Building Maintenance and Replacement Fund, and the Vehicle and Equipment Replacement Fund. The Internal Service Funds are combined into one column within the Proprietary Funds statements and then are combined with governmental activities in the Government-wide Financial Statements. City of Atascadero Management’s Discussion and Analysis Fiscal Year Ended June 30, 2023 6 Private Purpose Trust Funds Private Purpose Trust Funds are used to account for monies held on behalf of others in a fiduciary capacity. The City uses private purpose trust funds to account for the Successor Agency of the Former Redevelopment Agency which was dissolved on January 31, 2012, pursuant to state law. All resources of the funds are used to support specified activities. Notes to the Basic Financial Statements – The notes provide additional information that is essential to a full understanding of the data provided in the government-wide and fund financial statements. Government-Wide Financial Analysis As noted earlier, net position may serve over time as a useful indicator of a government’s financial position. In the case of the City of Atascadero, assets and deferred outflows of resources exceeded liabilities and deferred inflows of resources by about $219.2 million at the close of the most recent fiscal year. 2022-2023 Governmental Activities 2022-2023 Business-Type Activities 2022-2023 Total 2021-2022 Governmental Activities 2021-2022 Business-Type Activities 2021-2022 Total 89,961,338$ 10,381,040$ 100,342,378$ 79,367,406$ 9,432,772$ 88,800,178$ 147,498,128 18,644,980 166,143,108 141,953,052 18,498,423 160,451,475 Total assets 237,459,466 29,026,020 266,485,486 221,320,458 27,931,195 249,251,653 15,049,612 339,962 15,389,574 7,114,260 148,427 7,262,687 Total deferred outflows 15,049,612 339,962 15,389,574 7,114,260 148,427 7,262,687 9,022,500 535,109 9,557,609 4,845,345 1,082,305 5,927,650 50,452,558 887,230 51,339,788 34,539,006 501,972 35,040,978 Total liabilities 59,475,058 1,422,339 60,897,397 39,384,351 1,584,277 40,968,628 1,645,545 167,487 1,813,032 17,273,069 458,936 17,732,005 Total deferred inflows 1,645,545 167,487 1,813,032 17,273,069 458,936 17,732,005 133,673,128 18,644,980 152,318,108 127,853,052 18,498,423 146,351,475 41,777,068 - 41,777,068 35,948,188 - 35,948,188 15,938,279 9,131,176 25,069,455 7,976,058 7,537,986 15,514,044 Total net position 191,388,475$ 27,776,156$ 219,164,631$ 171,777,298$ 26,036,409$ 197,813,707$ Current and other assets Capital assets Current liabilities Noncurrent liabilities Deferred outflows Net position: Net investment in capital assets Restricted Unrestricted Deferred inflows City of Atascadero Management’s Discussion and Analysis Fiscal Year Ended June 30, 2023 7 Government-Wide Financial Analysis (continued) The largest portion of the City’s net position (70%) reflects its investment in capital assets, less any related debt used to acquire those assets that is still outstanding. The City uses these capital assets to provide services to citizens; consequently, these assets are not available for future spending. Although the City’s investment in its capital assets is reported net of related debt, it should be noted that the resources needed to repay this debt must be provided from other sources, since the capital assets themselves usually are not used to liquidate these liabilities. An additional 19% of the City’s net position represents resources subject to external restrictions on how they may be used. The remaining 11% ($25,069,455) is considered unrestricted and may be used to meet the City’s ongoing obligations to citizens and creditors. There was an increase of $9,555,411 in unrestricted net position from fiscal year 2021-2022 to 2022-2023. Consistent with the prior fiscal year, as of the end of the current fiscal year, the City is able to report positive balances in both categories of net position, for both the government as a whole, as well as for its separate governmental and business-type activities. During the current fiscal year, the City’s net position increased by about $21.4 million. Information about changes in net position is summarized below: 2022-2023 Governmental Activities 2022-2023 Business-Type Activities 2022-2023 Total 2021-2022 Governmental Activities 2021-2022 Business-Type Activities 2021-2022 Total Revenues: Program Revenues Charges for services 4,175,691$ 4,388,182$ 8,563,873$ 3,788,440$ 3,683,596$ 7,472,036$ Operating grants and contributions 5,310,449 451,758 5,762,207 5,143,736 487,295 5,631,031 Capital grants and contributions 6,186,809 - 6,186,809 4,467,886 - 4,467,886 General Revenues: Secured and unsecured property taxes 13,118,922 - 13,118,922 12,221,064 - 12,221,064 Sales and use taxes 14,497,346 - 14,497,346 14,621,612 - 14,621,612 Other taxes 4,407,877 - 4,407,877 4,258,578 - 4,258,578 Motor vehicle in lieu 31,551 - 31,551 34,222 - 34,222 Investment Income 434,388 93,234 527,622 (1,446,897) (302,298) (1,749,195) Gain on disposal of capital assets - - - 2,178 - 2,178 Interest from Successor Agency 741,223 - 741,223 706,695 - 706,695 Total Revenues 48,904,256 4,933,174 53,837,430 43,797,514 3,868,593 47,666,107 SUMMARY OF CHANGES IN NET POSITION For the Fiscal Years Ended June 30, 2023 and 2022 City of Atascadero Management’s Discussion and Analysis Fiscal Year Ended June 30, 2023 8 Government-Wide Financial Analysis (continued) 2022-2023 Governmental Activities 2022-2023 Business-Type Activities 2022-2023 Total 2021-2022 Governmental Activities 2021-2022 Business-Type Activities 2021-2022 Total Program Expenses General Government 2,972,712$ -$ 2,972,712$ 3,831,315$ -$ 3,831,315$ Public Safety 14,222,407 - 14,222,407 16,170,995 - 16,170,995 Community Development 3,462,951 - 3,462,951 3,287,824 - 3,287,824 Community, Recreation & Zoo Services 2,798,280 - 2,798,280 2,978,346 - 2,978,346 Parks & Open Space 1,207,467 - 1,207,467 1,266,469 - 1,266,469 Public Works 3,945,896 - 3,945,896 4,007,045 - 4,007,045 Sewer - 2,627,818 2,627,818 - 2,738,529 2,738,529 Transit - 565,609 565,609 - 638,546 638,546 Interest on long-term debt 683,366 - 683,366 696,368 - 696,368 Total Expenses 29,293,079 3,193,427 32,486,506 32,238,362 3,377,075 35,615,437 Change in net position 19,611,177 1,739,747 21,350,924 11,559,152 491,518 12,050,670 Net position- beginning 171,777,298 26,036,409 197,813,707 160,218,146 25,544,891 185,763,037 Net position- ending 191,388,475$ 27,776,156$ 219,164,631$ 171,777,298$ 26,036,409$ 197,813,707$ SUMMARY OF CHANGES IN NET POSITION (continued) For the Fiscal Years Ended June 30, 2023 and 2022 Governmental activities during the fiscal year increased the City’s net position by $19,611,177. Business-type activities increased the City’s net position by $1,739,747. American Rescue Plan Act (ARPA) The Federal American Rescue Plan Act (ARPA) was signed into law on March 11, 2021, to provide additional financial relief in the wake of the COVID-19 pandemic. ARPA includes a significant amount of “Coronavirus State and Local Fiscal Recovery Funds” (SLFRF) for state and local governments. The funds were distributed in two equal installments. Atascadero received the first distribution in July 2021 and the second in July 2022. Funds may be used for specific purposes as designated in the U.S. Department of Treasury’s Final Rule. The Final Rule offers a standard allowance for revenue loss of up to $10 million. Recipients that select the standard allowance may use the funds for government services. The City is eligible to use the standard deduction for revenue use and, in fact, used all funding for general government purposes across fiscal years 2021-2022 and 2022-2023. The City’s total ARPA allocation was $7,194,580. City of Atascadero Management’s Discussion and Analysis Fiscal Year Ended June 30, 2023 9 Financial Analysis of the City’s Funds As noted earlier, the City of Atascadero uses fund accounting to ensure and demonstrate compliance with finance-related legal requirements. Governmental Funds The focus of the City’s governmental funds is to provide information on near-term inflows, outflows, and balances of spendable resources. Such information is useful in assessing the City’s financing requirements. As of June 30, 2023, the City’s governmental funds reported combined ending fund balances of $62,371,186. Of this total, $113,582 cannot be spent because it is in a non-spendable form and/or a non-cash form such as prepaid items, deposits, and inventory. The City’s governmental funds Unassigned Fund Balance is $20,253,761. The General Fund portion of this, $20,956,096, is available for any purpose. The remaining Unassigned Fund Balance is the amount of the Fire Aerial Vehicle Impact Fees Fund where expenditures were made prior to receipt of restricted revenues. The Restricted Fund Balance of $41,776,338 includes amounts constrained to specific purposes by their providers (such as grantors, bondholders, and higher levels of government), through constitutional provisions, or by enabling legislation. The Assigned fund balance, $227,505, is the amount the City intends to use for road projects. General Fund – The General Fund is the chief operating fund of the City. At June 30, 2023, the total fund balance was $21,186,635 and the spendable unassigned fund balance was 99% of the total. As a measure of the General Fund’s liquidity, it may be useful to compare total fund balance to total fund expenditures. The total General Fund balance represents 52% of fund expenditures. The General Fund balance decreased $4,145,835 during the fiscal year. In Lieu Low/Moderate Income Housing Fund – This fund accounts for fees that are paid by developers in lieu of building inclusionary (affordable) housing. These fees are expended on programs that provide and/or promote affordable housing within the City. At June 30, 2023, the fund balance was $5,840,542. Local Transportation Fund – This fund accounts for Local Transportation funds that can be used for streets projects. Local Transportation Funds (LTF) must first be spent to meet any reasonable community transit need. The City uses LTF monies to run the City's bus system and to contribute to San Luis Obispo Regional Transit Authority. Any remaining funds are accounted for in this fund and must be used for bikepath projects and streets projects. The fund balance at June 30, 2023, was $8,554,348, up $5,537,132 from the prior fiscal year. The increased fund balance is primarily due to $3,000,000 in funding from a State Legislative Grant to be used for the Downtown Infrastructure Enhancement Plan. Circulation System Fees Fund – This fund accounts for fees that are paid by developers to fund the creation of more lane miles or more efficient lane miles with which to accommodate the additional trips created by new development. These fees are expended for the construction of new/increased/improved roadway and bridge facilities. The fund balance at June 30, 2023, was $2,771,566, down $45,447 from the prior fiscal year. Fire Aerial Vehicle Impact Fees Fund – This fund accounts for impact fees imposed on commercial and multi-family residential developments for the purpose of contributing toward the purchase of the Aerial Fire Truck (Ladder Truck). The City purchased this truck in fiscal year 2007-2008 using future revenues, and therefore, the fund had a negative balance of ($700,406) at June 30, 2023. As projects continue to develop over time, Impact Fee revenues should move this negative balance toward zero. City of Atascadero Management’s Discussion and Analysis Fiscal Year Ended June 30, 2023 10 Financial Analysis of the City’s Funds (continued) 2010 Bond Debt Service Fund – The 2010 Bond Debt Service Fund accounts for all of the advances receivable from the Successor Agency and the debt service payments for the Lease Revenue Bonds that were issued on September 1, 2010. At June 30, 2023, the total fund balance was $15,280,625, which reflects $13.8 million in advances receivable from the Successor Agency. See Notes 8 and 15 to the financial statements for additional information on the Successor Agency and the bond issue. Other Governmental Funds – These are nonmajor funds of the City and are presented in the basic financial statements in the aggregate and in detail in the supplementary section of this report. At June 30, 2023, these funds had an aggregate fund balance of $9,437,876. Of this total, $730 is non-spendable, $227,505 is assigned for specific uses, and ($1,929) is unassigned. The Restricted Fund Balance is $9,211,570. More information about these nonmajor funds can be found in the combining and individual fund financial statements and schedules. Proprietary Funds The City’s two enterprise funds provide the same type of information found in the Government-wide Financial Statements, but in more detail. Highlights of the annual activity for these funds have already been presented in the discussion of the business-type activities. Debt Administration Debt, considered a liability of governmental and business-type activities, increased in FY 2022-2023 by $16,298,810, primarily due to the large increase in the CalPERS Net Pension Liability, as required to be reported by GASB Statement No. 68. The CalPERS Net Pension Liability increased almost $16 million from the prior fiscal year mainly due to the poor CalPERS investment return for the fiscal year ending June 30, 2022. In addition to the asset return of -7.5%, the discount rate was lowered 25 basis points, increasing the liability even further. See Note 9 for additional information on CalPERS. Debt was further increased by the new GASB Statement No. 96 pronouncement for Subscription Liability of $415.756 and decreased by a reduction in bonds payable, but was offset by an increase in compensated absences. The Net Pension Liability for Governmental Activities at the end of the fiscal year was $34,126,111 and $879,396 for Business-type Activities. Compensated absences increased by $41,319 during the fiscal year. Cash Management To obtain flexibility in cash management, the City employs a pooled cash system. Under the pooled cash concept, the City invests the cash of all funds with maturities planned to coincide with cash needs. Idle cash is invested in certain eligible securities as constrained by law and further limited by the City’s Investment Policy. The goals of the City’s Investment Policy are safety, liquidity, and yield. Capital Assets The capital assets of the City are those assets that are used in the performance of the City’s functions, including infrastructure assets. At June 30, 2023, net capital assets of the governmental activities totaled $147,498,128 and the net capital assets of the business-type activities totaled $18,644,980. Depreciation and amortization on capital assets is recognized in the Government-wide Financial Statements. The City has elected to depreciate its infrastructure assets. In order to depreciate the infrastructure assets, an estimated useful life for each type of asset was determined using engineering standards, industry standards, as well as discussions with City staff regarding the City’s maintenance program for each asset type. This allowed the estimated useful life of each asset type to be tailored to include the unique attributes of the City of Atascadero. City of Atascadero Management’s Discussion and Analysis Fiscal Year Ended June 30, 2023 11 Financial Analysis of the City’s Funds (continued) The following table presents summary information on the City’s capital assets: 2022-2023 Governmental Activities 2022-2023 Business-Type Activities 2022-2023 Total 2021-2022 Governmental Activities 2021-2022 Business-Type Activities 2021-2022 Total Non-Depreciable: Land 41,659,554$ 547,738$ 42,207,292$ 41,659,554$ 547,738$ 42,207,292$ Construction in progress 8,417,299 2,633,336 11,050,635 5,163,296 5,717,647 10,880,943 Depreciable: Vehicles and equipment 15,302,806 1,375,712 16,678,518 14,048,430 1,232,249 15,280,679 Structures and improvements 56,869,387 34,154,782 91,024,169 56,796,873 30,307,997 87,104,870 Subscription asset 949,033 - 949,033 - - - Infrastructure 82,656,247 - 82,656,247 79,161,466 - 79,161,466 Accumulated amortization (115,483) - (115,483) - - - Accumulated depreciation (58,240,715) (20,066,588) (78,307,303) (54,876,567) (19,307,208) (74,183,775) Net capital assets 147,498,128$ 18,644,980$ 166,143,108$ 141,953,052$ 18,498,423$ 160,451,475$ General Fund Budgetary Highlights A detailed budgetary comparison schedule for the fiscal year ended June 30, 2023, is presented in the required supplementary information to the basic financial statements. The final budget amounts (which are the focus of this discussion) are different from those presented in the 2022-2023 budget document. This is due to changes that occurred between the time that the budget was prepared and fiscal year-end final budget approvals. The following summarizes the original and final budget compared with actual results for 2022-2023: General Fund Original Budget Final Budget Actual Variance Positive (Negative) Revenues 32,027,350$ 36,406,260$ 41,001,355$ 4,595,095$ Expenditures 39,227,830 46,882,780 40,914,694 5,968,086 Other Sources (Uses)289,150 (4,407,250) (4,232,496) 174,754 Fund Balance, beginning 25,332,470 25,332,470 25,332,470 - Fund Balance, ending 18,421,140$ 10,448,700$ 21,186,635$ 10,737,935$ City of Atascadero Management’s Discussion and Analysis Fiscal Year Ended June 30, 2023 12 Financial Analysis of the City’s Funds (continued) The City’s Seven-Year Projection, adopted with the 2023-2025 budget, assumed increased revenues over and above the 2022-2023 budget, and subsequently, adjustments were made to the 2023-2025 budget to incorporate the use of these revenues to meet the City’s goals. Almost $5.2 million in expenditures of special and capital project budgets that were not spent during 2022-2023 will carry over to be used in fiscal year 2023-2024. Economic Factors and Next Fiscal Year’s Budget The City continues to recover from the recent Coronavirus slow-down and is ever-focused on economic development. About one-third of the City’s General Fund revenues comes from property tax revenues, which tend to be more stable in times of economic flux than other sources. In 2020, the voters passed Sales Tax Measure D-20, providing additional revenue for the General Fund. These funds have been critical to funding the City’s services to the community. Economic factors and key issues and trends that affect the budget include: Sales Tax Measure D-20 This is a general purpose one-cent transaction tax that was effective April 1, 2021. It will continue to be used primarily for essential City services. Revenue in fiscal year 2022-23 from this relatively new revenue source was about $6.4 million. Public Safety The City and the community strongly support investments in Police and Fire services. Measure D-20 has provided much needed funding for additional investments in increased staffing levels, vehicle and equipment replacement, the funding for the replacement of Fire Station #1, and upgrades to the Police Station and Fire Station #2. Staffing Retention and Attraction Efforts to retain and attract quality staff were key in the development of the budget, with the intention to increase staff efficiencies, provide improved services to the public, and reduce long-term hiring costs. Investments in Infrastructure, Internal Replacement Reserves, and Broadband Enhancement The budget includes substantial investments in infrastructure, vehicles and equipment replacement and reserves, and funding for Broadband enhancement. CalPERS Retirement Costs CalPERS currently estimates that the City’s combined unfunded accrued liability (UAL) payment be approximately $2.7 million in each fiscal year of this budget cycle. This estimated UAL represents approximately 12% of total general fund costs of labor each year. At this time and based on current assumptions, CalPERS is projecting the UAL will peak in fiscal year 2024-2025 and gradually decrease in the years after that. The normal costs rates are expected to continue to grow. The 2022-2023 budget is lean, smart, and will make the best of the City’s limited resources. In preparing the budget, the objective was to provide an effective plan to maintain the Council goals and the City’s core services. The Council’s top priorities are: • Economic and Community Vibrancy • Fiscal and Infrastructure Efficiency and Sustainability • Ensuring Public Safety and Providing Exceptional City Services To accomplish these goals, the 2023-2024 budget includes the planned use of $4 million in reserves, in accordance with the Council’s financial strategy. BASIC FINANCIAL STATEMENTS CITY OF ATASCADERO STATEMENT OF NET POSITION June 30, 2023 Governmental Activities Business-Type Activities Total ASSETS Cash and investments 63,463,667$ 9,990,402$ 73,454,069$ Restricted cash and investments: Cash with fiscal agents 1,455,625 - 1,455,625 Certificates of deposit 85,473 - 85,473 Receivables: Federal distributions due 2,773,840 234,019 3,007,859 Due from State of California 2,207,891 - 2,207,891 Due from County of San Luis Obispo 347,243 56,865 404,108 Accrued interest 348,719 54,567 403,286 Accrued interest receivable- 2010 bonds 168,377 - 168,377 Other receivables 1,200,374 34,434 1,234,808 Deposits, prepaid items, and inventory 34,230 10,753 44,983 Notes receivable 4,050,899 - 4,050,899 Advance receivable- Successor Agency 13,825,000 - 13,825,000 Capital assets: Non-depreciable: Land 41,659,554 547,738 42,207,292 Construction in progress 8,417,299 2,633,336 11,050,635 Depreciable or amortizable: Vehicles and equipment 15,302,806 1,375,712 16,678,518 Structures and improvements 56,869,387 34,154,782 91,024,169 Subscription asset 949,033 - 949,033 Infrastructure 82,656,247 - 82,656,247 Accumulated amortization (115,483) - (115,483) Accumulated depreciation (58,240,715) (20,066,588) (78,307,303) Total assets 237,459,466 29,026,020 266,485,486 DEFERRED OUTFLOWS Deferred outflows related to pensions 15,049,612 339,962 15,389,574 Total deferred outflows 15,049,612 339,962 15,389,574 The notes to the basic financial statements are an integral part of this statement. 14 CITY OF ATASCADERO STATEMENT OF NET POSITION (continued) June 30, 2023 Governmental Activities Business-Type Activities Total LIABILITIES Accounts payable 2,965,357$ 151,558$ 3,116,915$ Accrued salaries and benefits 1,003,567 13,284 1,016,851 Accrued interest payable 168,377 - 168,377 Other payables 131,873 1,926 133,799 Deposits payable 75,915 - 75,915 Unearned revenue 4,677,411 368,341 5,045,752 Noncurrent liabilities: Due within one year 391,965 - 391,965 Due in more than one year 50,060,593 887,230 50,947,823 Total liabilities 59,475,058 1,422,339 60,897,397 DEFERRED INFLOWS Deferred inflows related to pensions 1,645,545 167,487 1,813,032 Total deferred inflows 1,645,545 167,487 1,813,032 NET POSITION Net investment in capital assets 133,673,128 18,644,980 152,318,108 Restricted for: Restricted for parks and recreation 2,949,107 - 2,949,107 Restricted for streets, roads, and drainage 14,735,013 - 14,735,013 Restricted for public safety 1,873,270 - 1,873,270 Restricted for economic development 1,098,511 - 1,098,511 Restricted for redevelopment and housing 5,840,542 - 5,840,542 Restricted for debt service 15,280,625 - 15,280,625 Unrestricted 15,938,279 9,131,176 25,069,455 Total net position 191,388,475$ 27,776,156$ 219,164,631$ The notes to the basic financial statements are an integral part of this statement. 15 CITY OF ATASCADERO STATEMENT OF ACTIVITIES For the Fiscal Year Ended June 30, 2023 Program Revenues Expenses Charges for Services Operating Contributions and Grants Capital Contributions and Grants Net Governmental Activities Net Business-Type Activities Total Governmental activities: General government 2,972,712$ 120,349$ 73,620$ -$ (2,778,743)$ -$ (2,778,743)$ Public safety 14,222,407 687,181 3,929,899 163,451 (9,441,876) - (9,441,876) Community development 3,462,951 1,782,388 356,425 43,511 (1,280,627) - (1,280,627) 2,798,280 1,203,010 61,855 106,260 (1,427,155) - (1,427,155) Parks & open space 1,207,467 53,225 60,968 438,284 (654,990) - (654,990) Public works 3,945,896 329,538 827,682 5,435,303 2,646,627 - 2,646,627 Interest on long-term debt 683,366 - - - (683,366) - (683,366) Total governmental activities 29,293,079 4,175,691 5,310,449 6,186,809 (13,620,130) - (13,620,130) Business-type activities: Sewer 2,627,818 4,366,595 - - - 1,738,777 1,738,777 Transit 565,609 21,587 451,758 - - (92,264) (92,264) Total business-type activities 3,193,427 4,388,182 451,758 - - 1,646,513 1,646,513 Total government 32,486,506$ 8,563,873$ 5,762,207$ 6,186,809$ (13,620,130) 1,646,513 (11,973,617) General revenues Taxes: Secured and unsecured property taxes 13,118,922 - 13,118,922 Sales tax 14,497,346 - 14,497,346 Transient lodging tax 2,156,988 - 2,156,988 Franchise taxes 1,381,290 - 1,381,290 Business license tax 179,253 - 179,253 Property transfer tax 167,590 - 167,590 Other taxes 522,756 - 522,756 Motor vehicle in lieu 31,551 - 31,551 Investment income 434,388 93,234 527,622 Interest from Successor Agency 741,223 - 741,223 Total general revenues 33,231,307 93,234 33,324,541 Change in net position 19,611,177 1,739,747 21,350,924 Net position at beginning of fiscal year 171,777,298 26,036,409 197,813,707 Net position at end of fiscal year 191,388,475$ 27,776,156$ 219,164,631$ Net (Expense) Revenue and Changes in Net Position Community, recreation & zoo services The notes to the basic financial statements are an integral part of this statement. 16 CITY OF ATASCADERO GOVERNMENTAL FUNDS BALANCE SHEET June 30, 2023 General Fund In Lieu Low / Moderate Income Housing Fund Local Transportation Fund Circulation System Fees Fund Fire Aerial Vehicle Impact Fees Fund 2010 Bond Debt Service Fund Totals ASSETS Cash and investments 19,317,760$ 1,779,615$ 10,780,563$ 4,041,400$ -$ -$ 8,844,421$ 44,763,759$ Restricted cash and investments: - - - - - 1,455,625 - 1,455,625 Certificates of deposit 85,473 - - - - - - 85,473 Receivables: Federal distributions due 536,991 - 2,179,453 - - - 57,396 2,773,840 Due from State of California 2,017,309 - - - - - 190,582 2,207,891 58,806 - 272,582 - - - 15,855 347,243 Accrued interest 142,353 10,028 43,296 22,678 - - 49,882 268,237 Other receivables 1,076,396 - - - - - 123,978 1,200,374 Due from other funds 70,873 - - - - - 700,406 771,279 Deposits, prepaid items, and inventory 27,379 - - - - - 730 28,109 Notes receivable - 4,050,899 - - - - - 4,050,899 Advances receivable- Successor Agency - - - - - 13,825,000 - 13,825,000 Total assets 23,333,340$ 5,840,542$ 13,275,894$ 4,064,078$ -$ 15,280,625$ 9,983,250$ 71,777,729$ Other Nonmajor Governmental Funds Cash and investments with fiscal agent Due from County of San Luis Obispo The notes to the basic financial statements are an integral part of this statement.17 CITY OF ATASCADERO GOVERNMENTAL FUNDS BALANCE SHEET (continued) June 30, 2023 General Fund In Lieu Low / Moderate Income Housing Fund Local Transportation Fund Circulation System Fees Fund Fire Aerial Vehicle Impact Fees Fund 2010 Bond Debt Service Fund Totals LIABILITIES AND FUND BALANCES Liabilities: Accounts payable 788,560$ -$ 1,721,546$ 79,490$ -$ -$ 221,859$ 2,811,455$ Accrued salaries and benefits 955,877 - - - - - 17,980 973,857 Due to other funds - - - - 700,406 - 70,873 771,279 Unearned revenue 228,827 - 3,000,000 1,213,022 - - 234,662 4,676,511 Deposits 75,915 - - - - - - 75,915 Other payables 97,526 - - - - - - 97,526 Total liabilities 2,146,705 - 4,721,546 1,292,512 700,406 - 545,374 9,406,543 Fund Balances: Nonspendable 112,852 - - - - - 730 113,582 Restricted 117,687 5,840,542 8,554,348 2,771,566 - 15,280,625 9,211,570 41,776,338 Assigned for road projects - - - - - - 227,505 227,505 Unassigned 20,956,096 - - - (700,406) - (1,929) 20,253,761 Total fund balances (deficits)21,186,635 5,840,542 8,554,348 2,771,566 (700,406) 15,280,625 9,437,876 62,371,186 23,333,340$ 5,840,542$ 13,275,894$ 4,064,078$ -$ 15,280,625$ 9,983,250$ 71,777,729$ Other Nonmajor Governmental Funds Total liabilities and fund balances The notes to the basic financial statements are an integral part of this statement.18 CITY OF ATASCADERO RECONCILIATION OF THE GOVERNMENTAL FUNDS - BALANCE SHEET TO THE STATEMENT OF NET POSITION Total fund balances - governmental funds 62,371,186$ In governmental funds, only current assets are reported. In the statement of net position, all assets are reported, including capital assets and accumulated depreciation and amortization. Capital assets at historical cost 136,425,124$ Accumulated depreciation and amortization (34,213,640) Net 102,211,484 In governmental funds, interest on long-term debt is not recognized until the period in which it matures and is paid. In the government-wide statement of activities, it is recognized in the period that it is incurred.(168,377) In governmental funds, the receivable from the Successor Agency related to interest on the 2010 long-term debt is 168,377 Long-term liabilities: In governmental funds, only current liabilities are reported. In the statement of net position, all liabilities, including long-term liabilities, are reported. Long-term liabilities relating to governmental activities consist of: Bonds payable 13,825,000 Workers' Compensation deposits in excess of estimated claims liability (161,641) Compensated absences payable 1,873,706 CalPERS pension liability 32,814,556 Other Post Employment Benefits 250,936 (48,602,557) The deferred outflows below are not current assets or financial resources; and the deferred inflows are not due and payable in the current period and therefore are not reported in the Governmental Funds. Deferred outflows 14,454,534 Deferred inflows (1,551,536) In governmental funds, premiums are recognized when the bonds are issued. In the government-wide statement of activities, these are recorded as a liability and amortized over the life of the bond.(51,494) June 30, 2023 not recognized until the period in which it is paid. In the government-wide statement of activities, it is recognized in the period that it is incurred. The notes to the basic financial statements are an integral part of this statement. 19 CITY OF ATASCADERO RECONCILIATION OF THE GOVERNMENTAL FUNDS - BALANCE SHEET TO THE STATEMENT OF NET POSITION (continued) Internal service funds are used by management to charge the costs of various City activities to individual governmental and enterprise funds. The net position of the internal service funds are included in the Governmental Activities in the Statement of Net Position.62,556,858$ Total net position, governmental activities 191,388,475$ June 30, 2023 The notes to the basic financial statements are an integral part of this statement. 20 CITY OF ATASCADERO GOVERNMENTAL FUNDS STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES For the Fiscal Year Ended June 30, 2023 General Fund In Lieu Low / Moderate Income Housing Fund Local Transportation Fund Circulation System Fees Fund Fire Aerial Vehicle Impact Fees Fund 2010 Bond Debt Service Fund Other Nonmajor Governmental Funds Totals Revenues: Secured and unsecured property taxes 12,066,128$ -$ -$ -$ -$ -$ 1,484,195$ 13,550,323$ Taxes based on sales and use 14,497,346 - - - - - - 14,497,346 Franchise tax 1,381,290 - - - - - - 1,381,290 Other taxes 2,551,264 - - - - - - 2,551,264 Licenses and permits 1,088,633 - - 500,996 17,739 - 750,797 2,358,165 Intergovernmental revenues: 31,551 - - - - - - 31,551 3,597,290 - - - - - - 3,597,290 Grants 485,149 - 2,158,337 - - - 133,218 2,776,704 Other governmental revenues 219,073 - 1,987,273 - - - 1,491,552 3,697,898 Charges for services: Public safety 640,911 - - - - - - 640,911 Development 935,291 - - - - - - 935,291 Recreation, parks, pavilion, and zoo 1,236,078 - - - - - - 1,236,078 Other services 131,371 - - - - - - 131,371 Fines and forfeitures 78,628 - - - - - 3,904 82,532 Use of money and property 513,543 69,419 (177,263) 72,792 - 744,613 82,395 1,305,499 Other revenues 1,547,809 - - - - - 655 1,548,464 Total revenues 41,001,355 69,419 3,968,347 573,788 17,739 744,613 3,946,716 50,321,977 Motor vehicle in lieu American Rescue Plan Act Funds- COVID-19 The notes to the basic financial statements are an integral part of this statement. 21 CITY OF ATASCADERO GOVERNMENTAL FUNDS STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES (continued) For the Fiscal Year Ended June 30, 2023 General Fund In Lieu Low / Moderate Income Housing Fund Local Transportation Fund Circulation System Fees Fund Fire Aerial Vehicle Impact Fees Fund 2010 Bond Debt Service Fund Other Nonmajor Governmental Funds Totals Expenditures: Current: General government 4,056,053$ -$ -$ -$ -$ -$ 9,763$ 4,065,816$ Public safety 23,001,555 - - - - - 124,463 23,126,018 Community development 3,586,285 78,300 - - - 5,560 307,656 3,977,801 3,020,056 - - - - - 10,752 3,030,808 Parks and open space 1,179,986 - - - - - 77,536 1,257,522 Public works 1,936,413 - 137,857 - - - 1,254,876 3,329,146 Capital outlay 4,134,346 - 3,249,194 619,235 - - 199,708 8,202,483 Debt service: Principal - - - - - 275,000 - 275,000 Interest - - - - - 689,738 - 689,738 Total expenditures 40,914,694 78,300 3,387,051 619,235 - 970,298 1,984,754 47,954,332 Excess of revenues over (under) expenditures 86,661 (8,881) 581,296 (45,447) 17,739 (225,685) 1,961,962 2,367,645 Other Financing Sources (Uses): Transfers in 743,353 - 4,955,836 - - - 281,849 5,981,038 Transfers out (4,975,849) - - - - - (1,005,189) (5,981,038) Total other financing sources and uses (4,232,496) - 4,955,836 - - - (723,340) - Net change in fund balances (4,145,835) (8,881) 5,537,132 (45,447) 17,739 (225,685) 1,238,622 2,367,645 Fund balances (deficits) - June 30, 2022 25,332,470 5,849,423 3,017,216 2,817,013 (718,145) 15,506,310 8,199,254 60,003,541 Fund balances (deficits) - June 30, 2023 21,186,635$ 5,840,542$ 8,554,348$ 2,771,566$ (700,406)$ 15,280,625$ 9,437,876$ 62,371,186$ Community, recreation and zoo services The notes to the basic financial statements are an integral part of this statement. 22 CITY OF ATASCADERO RECONCILIATION OF THE STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES OF GOVERNMENTAL FUNDS TO THE STATEMENT OF ACTIVITIES For the Fiscal Year Ended June 30, 2023 Total net change in fund balance - governmental funds 2,367,645$ Capital outlays are reported in governmental funds as expenditures. However, in the statement of activities, the cost of capital assets is allocated over their estimated useful lives as depreciation expense. This is the amount by which additions to capital assets of $8,202,483 is greater than depreciation expense $(1,847,004) in the period.6,355,479 The sale or deletion of capital assets is not recorded in the governmental financial statements. In the statement of activities, however, the gain or loss from the sale or deletion is recorded as an appropriate program expense.(97,800) In governmental funds, repayments of long-term debt are reported as expenditures. In the government-wide statements, repayments of long-term debt are reported as reductions of liabilities.275,000 In governmental funds, the issuance premiums associated with long-term debt are reported as revenue in the fiscal year debt is issued. In the government-wide statements, the issuance premiums are recorded as liabilities and are amortized over the life of the related debt.2,982 In governmental funds, interest on long-term debt is recognized in the period that it becomes due. In the government-wide statement of activities, it is recognized in the period that it is incurred. Unmatured interest owing at the end of the period, less matured interest paid during the period but owing from the prior period was:(3,390) In governmental funds, reimbursement from the Successor Agency related to interest on the 2010 long-term debt is recognized in the period that it becomes due. In the government-wide statement of activities, it is recognized in the period that it is earned. 3,390 In the statement of activities, compensated absences are measured by the amounts earned during the fiscal year. In governmental funds, however, expenditures for these items are measured by the amount of financial resources used (essentially the amounts paid). This fiscal year, leave amounts earned exceeded the amounts used by:(32,622) In governmental funds, pension costs are recognized when employer contributions are made. In the Statement of Activities, pension costs are recognized on the accrual basis. This fiscal year, the difference between accrual-basis pension costs and actual employer contributions was:3,913,410 In the statement of activities, changes to some claims and judgment liabilities do not require the use of current financial resources and therefore are not reported as expenditures in governmental funds. 143,907 The notes to the basic financial statements are an integral part of this statement. 23 CITY OF ATASCADERO RECONCILIATION OF THE STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES OF GOVERNMENTAL FUNDS TO THE STATEMENT OF ACTIVITIES (continued) For the Fiscal Year Ended June 30, 2023 In the statement of activities, the long-term liability for Other Post Employment Benefits is recognized. The increase in the long-term liability does not require the use of current financial resources and is not reported in governmental funds.(17,316)$ Internal service funds are used by management to charge the costs of various City activities to individual governmental and enterprise funds. The change in the unrestricted net position of the internal service funds is included in the Governmental Activities in the Statement of Activities. This amount is the net of the change in net position $7,558,916 less the capital contributions from other governmental funds ($858,424).6,700,492 Changes in net position - governmental activities 19,611,177$ The notes to the basic financial statements are an integral part of this statement. 24 CITY OF ATASCADERO PROPRIETARY FUNDS STATEMENT OF NET POSITION June 30, 2023 Wastewater Fund Transit Fund Totals ASSETS Current Assets: Cash and investments 9,945,674$ 44,728$ 9,990,402$ 18,699,908$ Receivables: Federal distributions due - 234,019 234,019 - Due from County of San Luis Obispo 56,820 45 56,865 - Accrued interest 54,492 75 54,567 80,482 Other receivables 33,062 1,372 34,434 - Prepaid expenses 8,141 2,612 10,753 6,121 Total current assets 10,098,189 282,851 10,381,040 18,786,511 Capital Assets: Non-depreciable: Land 547,738 - 547,738 - Construction in progress 2,633,336 - 2,633,336 319,457 Depreciable: Vehicles and equipment 1,021,992 353,720 1,375,712 15,212,090 Structures and improvements 32,682,346 1,472,436 34,154,782 53,064,105 Accumulated depreciation (19,004,763) (1,061,825) (20,066,588) (24,142,558) Subscription assets, net - - - 833,550 Net capital assets 17,880,649 764,331 18,644,980 45,286,644 Total assets 27,978,838 1,047,182 29,026,020 64,073,155 DEFERRED OUTFLOWS Deferred outflows related to pensions 319,373 20,589 339,962 595,078 Total deferred outflows 319,373 20,589 339,962 595,078 Internal Service Funds Enterprise Funds The notes to the basic financial statements are an integral part of this statement. 25 CITY OF ATASCADERO PROPRIETARY FUNDS STATEMENT OF NET POSITION (continued) June 30, 2023 Wastewater Fund Transit Fund Totals LIABILITIES Current Liabilities: Accounts payable 141,070$ 10,488$ 151,558$ 153,902$ Accrued salaries and benefits 11,521 1,763 13,284 29,710 Unearned revenue - 368,341 368,341 900 Other payables - 1,926 1,926 34,347 Noncurrent Liabilities: Noncurrent liabilities 822,943 64,287 887,230 1,798,507 Total liabilities 975,534 446,805 1,422,339 2,017,366 DEFERRED INFLOWS Deferred inflows related to pensions 165,247 2,240 167,487 94,009 Total deferred inflows 165,247 2,240 167,487 94,009 NET POSITION Net investment in capital assets 17,880,649 764,331 18,644,980 45,286,644 Net subscription liability - - - 415,756 Unrestricted 9,276,781 (145,605) 9,131,176 16,854,458 Total net position 27,157,430$ 618,726$ 27,776,156$ 62,556,858$ Enterprise Funds Internal Service Funds The notes to the basic financial statements are an integral part of this statement. 26 CITY OF ATASCADERO PROPRIETARY FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN NET POSITION For the Fiscal Year Ended June 30, 2023 Wastewater Fund Transit Fund Totals Operating Revenues: Service fees 4,056,858$ 21,587$ 4,078,445$ 2,918,185$ Installation, extension, and connection fees 309,737 - 309,737 - Total operating revenues 4,366,595 21,587 4,388,182 2,918,185 Operating Expenses: Salaries and benefits 453,115 38,225 491,340 788,166 Office expense 2,019 799 2,818 1,389 Advertising 942 - 942 - Computer maintenance and replacement 45,135 26,814 71,949 3,890 Insurance 52,613 10,747 63,360 83,804 Occupancy and rental costs 21,164 3,410 24,574 57,040 Utilities 425,380 - 425,380 106,680 Communications 9,469 1,510 10,979 78,100 Operating supplies 90,821 746 91,567 47,581 Vehicle and equipment operating costs 80,755 51,595 132,350 20,131 Contract services 160,886 148,014 308,900 147,618 Professional development 17,282 - 17,282 6,781 Recruitment 2,705 74 2,779 988 Interest expense - - - 5,472 Franchise fees 80,321 - 80,321 - Administrative charges 432,390 189,910 622,300 77,680 Special projects: Manhole rehabilitation projects 60,210 - 60,210 - Collection System Expansion Feasibility 7,625 - 7,625 - Proposition 218 majority protest-rate increase 4,410 - 4,410 - 2023 Storms- Supplies 809 - 809 - 2023 Storms- Emergency Response 1,182 - 1,182 - Other Minor Equipment - - - 2,864 HVAC Repairs 12,970 - 12,970 17,243 Internal Service Funds Enterprise Funds The notes to the basic financial statements are an integral part of this statement. 27 CITY OF ATASCADERO PROPRIETARY FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN NET POSITION (continued) For the Fiscal Year Ended June 30, 2023 Wastewater Fund Transit Fund Totals Operating Expenses (continued): Amortization expense -$ -$ -$ 115,483$ Depreciation expense 665,615 93,765 759,380 2,008,983 Total operating expenses 2,627,818 565,609 3,193,427 3,569,893 Operating income (loss)1,738,777 (544,022) 1,194,755 (651,708) Non-Operating Revenues (Expenses): Transportation Development Act Funds - Operations - 225,129 225,129 - Section 5307 Revenues - Operations - 225,129 225,129 - Investment income (loss)95,613 (2,379) 93,234 (82,988) Bus advertising sales - 1,500 1,500 - Gain / (loss) on sale of capital assets - - - (222) Total non-operating revenues 95,613 449,379 544,992 (83,210) Change in net position prior to capital contributions 1,834,390 (94,643) 1,739,747 (734,918) Capital Contributions: Cash contributions from other funds - - - 7,435,410 Capital contributions from other funds - - - 858,424 Total capital contributions - - - 8,293,834 Change in net position 1,834,390 (94,643) 1,739,747 7,558,916 Total net position, June 30, 2022 25,323,040 713,369 26,036,409 54,997,942 Total net position, June 30, 2023 27,157,430$ 618,726$ 27,776,156$ 62,556,858$ Enterprise Funds Internal Service Funds The notes to the basic financial statements are an integral part of this statement. 28 CITY OF ATASCADERO PROPRIETARY FUNDS COMBINING STATEMENT OF CASH FLOWS For the Fiscal Year Ended June 30, 2023 Wastewater Fund Transit Fund Totals Cash Flows From Operating Activities: Receipts from customers 4,375,763$ 20,980$ 4,396,743$ -$ Internal activity - payments from other funds - - - 2,918,185 Payments to suppliers of goods and services (2,084,753) (441,404) (2,526,157) (102,768) Payments for employee services (554,517) (43,522) (598,039) (970,560) Net cash provided (used) by operating activities 1,736,493 (463,946) 1,272,547 1,844,857 - 706,246 706,246 - - 1,500 1,500 - - (196,010) (196,010) - Net cash provided by non-capital related financing activities - 511,736 511,736 - Acquisition of capital assets (924,765) - (924,765) (1,412,085) Cash contributions for capital purchases - - - 7,435,410 Net cash used by capital and related financing activities (924,765) - (924,765) 6,023,325 Cash Flows From Non-Capital Financing Activities: Cash Flows From Capital and Related Financing Activities: Loans / repayments to other funds Receipts from intergovernmental agencies Receipts from bus advertising sales Internal Service Funds Enterprise Funds The notes to the basic financial statements are an integral part of this statement. 29 CITY OF ATASCADERO PROPRIETARY FUNDS COMBINING STATEMENT OF CASH FLOWS (continued) For the Fiscal Year Ended June 30, 2023 Wastewater Fund Transit Fund Totals Cash Flows From Investing Activities: Interest income 73,454$ (3,062)$ 70,392$ (125,800)$ Net cash provided (used) by investing activities 73,454 (3,062) 70,392 (125,800) Net increase in cash and cash equivalents 885,182 44,728 929,910 7,742,382 Cash and cash equivalents - June 30, 2022 9,060,492 - 9,060,492 10,957,526 Cash and cash equivalents - June 30, 2023 9,945,674$ 44,728$ 9,990,402$ 18,699,908$ Reconciliation to Statement of Net Position Operating income (loss)1,738,777$ (544,022)$ 1,194,755$ (651,708)$ Amortization expense - - - 115,483 Depreciation expense 665,615 93,765 759,380 2,008,983 Receivables, net 9,168 (607) 8,561 - Prepaid expenses (4,446) (237) (4,683) 27,779 Accounts payable (590,047) (7,548) (597,595) 76,511 Accrued salaries and benefits (9,304) 331 (8,973) 35 Unearned revenue - - - 100 Other payables 18,828 - 18,828 34,347 Deferred outflows (179,847) (11,688) (191,535) (408,318) Deferred inflows (273,665) (17,784) (291,449) (621,327) Long-term subscriptions payable - - - 415,756 Net pension liability 366,911 23,844 390,755 833,022 Compensated absences (5,497) - (5,497) 14,194 Net cash provided (used) by operating activities 1,736,493$ (463,946)$ 1,272,547$ 1,844,857$ Change in assets, deferred outflows, liabilities, and deferred inflows: Internal Service Funds Adjustments to reconcile operating income (loss) to net cash provided (used) by operating activities: Reconciliation of operating income (loss) to net cash provided (used) by operating activities: Enterprise Funds The notes to the basic financial statements are an integral part of this statement. 30 CITY OF ATASCADERO PRIVATE PURPOSE TRUST FUNDS STATEMENT OF FIDUCIARY NET POSITION June 30, 2023 Successor Agency to the Community Redevelopment Agency of Atascadero Housing Successor Agency to the Community Redevelopment Agency of Atascadero Totals ASSETS Cash and investments $ 1,577,121 $ - 1,577,121$ GASB 31 Adjustment to market (54,799) - (54,799) Restricted cash and investments: 880,602 - 880,602 Receivables: Accrued interest 7,391 - 7,391 Other receivables 350 - 350 Notes receivable - 200,000 200,000 Due from Successor Agency - 1,335,322 1,335,322 Total assets 2,410,665 1,535,322 3,945,987 LIABILITIES Accounts payable 2,538 - 2,538 Unearned revenue 642,523 - 642,523 Interest payable 292,100 - 292,100 Due to Successor Agency Housing Fund 1,335,322 - 1,335,322 Premium on bonds payable 18,995 - 18,995 2004 Bonds payable 7,545,000 - 7,545,000 13,825,000 - 13,825,000 Total liabilities 23,661,478 - 23,661,478 NET POSITION Held in trust for taxing agencies (21,250,813)$ 1,535,322$ (19,715,491)$ Successor Agency to the Atascadero Community Redevelopment Agency Cash with fiscal agent 2010 Bond Reimbursement Agreement payable to City of Atascadero The notes to the basic financial statements are an integral part of this statement. 31 CITY OF ATASCADERO PRIVATE PURPOSE TRUST FUNDS STATEMENT OF CHANGES IN FIDUCIARY NET POSITION For the Fiscal Year Ended June 30, 2023 Successor Agency to the Community Redevelopment Agency of Atascadero Housing Successor Agency to the Community Redevelopment Agency of Atascadero Totals ADDITIONS Contributions: RPTTF distributions 1,800,524$ -$ 1,800,524$ Investment earnings: Interest 42,593 - 42,593 Total additions 1,843,117 - 1,843,117 DEDUCTIONS Payment on outstanding services contracts 2,420 - 2,420 Administrative costs 51,570 - 51,570 2004 Bond interest expense 375,051 - 375,051 2010 Bond reimbursement interest expense 691,908 - 691,908 Total deductions 1,120,949 - 1,120,949 Change in net position 722,168 - 722,168 Net position - June 30, 2022 (21,972,981) 1,535,322 (20,437,659) Net position - June 30, 2023 (21,250,813)$ 1,535,322$ (19,715,491)$ The notes to the basic financial statements are an integral part of this statement. 32 NOTES TO THE BASIC FINANCIAL STATEMENTS CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 33 NOTE 1 – SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES A. Reporting Entity The accompanying basic financial statements present the financial activity of the City, which is the primary government. The reporting entity is the City of Atascadero. There are no component units included in this report which meet the reporting entity definition criteria of GASB Statement No. 14, The Financial Reporting Entity, as amended by GASB Statement No. 39, GASB Statement No. 61, GASB Statement No. 80, and GASB Statement No. 90. B. Basis of Presentation The City’s basic financial statements are prepared in conformity with accounting principles generally accepted in the United States of America. The Governmental Accounting Standards Board is the acknowledged standard-setting body for establishing accounting and financial reporting standards followed by governmental entities in the United States of America. The accompanying financial statements are presented on the basis set forth in Governmental Accounting Standards Board Statements No. 34, Basic Financial Statements—Management’s Discussion and Analysis—for State and Local Governments; No. 36, Recipient Reporting for Certain Non-Exchange Revenues, an Amendment of GASB Statement No. 33; No. 37, Basic Financial Statements—and Management’s Discussion and Analysis—for State and Local Government – Omnibus; and No. 38, Certain Financial Statement Note Disclosures. These statements require that the financial statements described below be presented. Government-Wide and Fund Financial Statements The government-wide financial statements (i.e., the statement of net position and the statement of activities) report information on the primary government and its component unit. For the most part, the effect of interfund activity has been removed from these statements. Governmental activities, which normally are supported by taxes and intergovernmental revenues, are reported separately from business-type activities, which rely to a significant extent on fees and charges for support. The statement of activities demonstrates the degree to which the direct expenses of a given function or segment are offset by program revenues. Direct expenses are those that are clearly identifiable with a specific function or segment. Program revenues include 1) charges to customers or applicants who purchase, use or directly benefit from goods, services, or privileges provided by a given function or segment and 2) grants and contributions that are restricted to meeting the operational or capital requirements of a particular function or segment. Taxes and other items not properly included among program revenues are reported instead as general revenues. Separate financial statements are provided for governmental funds, proprietary funds, and private purpose trust funds. Major individual governmental funds and major individual enterprise funds are reported as separate columns in the fund financial statements. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 34 NOTE 1 – SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (continued) C. Major Funds GASB Statement No. 34 defines major funds and requires that the City’s major governmental funds are identified and presented separately in the fund financial statements. All other funds, called nonmajor funds, are combined and reported in a single column, regardless of their fund-type. Major funds are defined as funds that have either assets, liabilities, revenues, or expenditures/expenses equal to ten percent of their fund-type total. The General Fund is always a major fund. The City may also select other funds it believes should be presented as major funds. The City reported the following major governmental funds in the accompanying financial statements: General Fund This fund accounts for all financial resources except those to be accounted for in another fund. It is the general operating fund of the City. In Lieu Low/Moderate Income Housing Fund This fund accounts for fees that are paid by developers in lieu of building inclusionary (affordable) housing. These fees are expended on programs that provide and/or promote affordable housing within the City. Local Transportation Fund This fund accounts for Local Transportation Funds that can be used for streets projects. Local Transportation Funds (LTF) must first be spent to meet any reasonable community transit need. The City uses the majority of LTF monies to run the City’s bus system and to contribute to San Luis Obispo Regional Transit Authority. Any remaining funds are accounted for in this fund and must be used for bikepath projects and street projects. Circulation System Fees Fund This fund accounts for fees that are paid by developers to fund the creation of more lane miles or more efficient lane miles with which to accommodate the additional trips created by new development. These fees are expended for the construction of new/increased/improved roadway and bridge facilities. Fire Aerial Vehicle Impact Fees Fund This fund accounts for impact fees imposed on commercial and multi-family residential developments for the purpose of contributing toward the purchase of the Aerial Fire Truck (Ladder Truck). The City purchased this truck in fiscal year 2007-2008 using future revenues. 2010 Bond Debt Service Fund This fund accounts for the debt service payments for the Lease Revenue Bonds that were issued on September 1, 2010. The City reported the following major proprietary funds: Wastewater Fund This fund accounts for the activities associated with the City’s sewer plant operation and maintenance. Transit Fund This fund accounts for the activities associated with the operation and maintenance of transportation services, such as and including the Dial-a-Ride Transit System. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 35 NOTE 1 – SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (continued) D. Internal Service Funds The Internal Service Funds are used to account for services rendered on a cost-reimbursement basis within the City. The City maintains three internal service funds: the Technology Fund, the Vehicle and Equipment Replacement Fund, and the Building Maintenance and Replacement Fund. The Internal Service Funds are presented in total on the Proprietary Funds financial statements. They are included in the governmental activities in the government-wide financial statements since they represent internal governmental activities. E. Private Purpose Trust Funds Private Purpose Trust Funds are used to account for monies held on behalf of others in a fiduciary capacity. The City uses private purpose trust funds to account for the Successor Agency of the Former Redevelopment Agency which was dissolved on January 31, 2012, pursuant to state law. All resources of the funds are used to support specified activities. F. Basis of Accounting The government-wide, proprietary fund financial statements, and the private purpose trust fund financial statements are reported using the economic resources measurement focus and the full accrual basis of accounting. Revenues are recorded when earned and expenses are recorded at the time liabilities are incurred, regardless of when the related cash flows take place. Governmental funds are reported using the current financial resources measurement focus and the modified accrual basis of accounting. Under this method, revenues are recognized when measurable and available. The City considers all revenues reported in the governmental funds to be available if the revenues are collected within sixty days after fiscal year end. Expenditures are recorded when the related fund liability is incurred, except for principal and interest on long-term debt, claims and judgments, and compensated absences, which are recognized as expenditures to the extent that they have matured. Capital asset acquisitions are reported as expenditures in governmental funds. Proceeds of long-term debt and acquisitions under leases and SBITAs are reported as other financing sources. Proprietary funds distinguish operating revenues from nonoperating revenues. Operating revenues generally result from providing services in connection with a proprietary fund’s principal ongoing operations. The principal operating revenues of the Wastewater Fund and the Transit Fund are charges to customers for services. The Wastewater Fund also recognizes as operating revenue the installation, extension and connections fees intended to recover the cost of connecting new customers to the system. All revenues not meeting these definitions are reported as non-operating revenues, including non- exchange transactions such as local transportation funds and federal Section 5307 revenues. Non-exchange transactions, in which the City gives or receives value without directly receiving or giving equal value in exchange, include property taxes, grants, entitlements, and donations. On an accrual basis, revenues from property taxes are recognized in the fiscal year for which the taxes are levied. Revenue from grants, entitlements, and donations is recognized in the fiscal year in which all eligibility requirements have been satisfied. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 36 NOTE 1 – SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (continued) F. Basis of Accounting (continued) Other revenues susceptible to accrual include other taxes, intergovernmental revenues, interest, and charges for services. Grant revenues are recognized in the fiscal year in which all eligibility requirements are met. Under the terms of grant agreements, the City may fund certain programs with a combination of cost-reimbursement grants, categorical block grants, and general revenues. Thus, both restricted and unrestricted net position may be available to finance program expenditures/expenses. The City’s policy is to first apply restricted grant resources to such programs, followed by general revenues if necessary. G. Compensated Absences In compliance with Governmental Accounting Standards Board Statement No. 16, the City has established a liability for accrued vacation, other leave and certain sick leave in relevant funds. For governmental funds, the current liability appears in the respective funds. All vacation, sick, and other leave paid is accrued when incurred in the government-wide and proprietary funds financial statements. This liability is set up for the current employees at the current rates of pay. If vacation and certain other leave are not used by the employee during the term of employment, compensation is payable to the employee at the time of retirement or termination. Such compensation is calculated at the employee’s prevailing rate at the time of retirement or termination. Each fiscal year, an adjustment to the liability is made based on pay rate changes and adjustments for the current portion. The General Fund is primarily responsible for the repayment of the governmental portion of compensated absences. H. Property Taxes California Constitution Article XIII A limits the combined property tax rate to one percent of a property’s assessed valuation. Additional taxes may be imposed with voter approval. Assessed value is calculated at one hundred percent of a property’s fair value, as defined by Article XIII A, and may be increased no more than two percent per year unless a change in ownership or new construction occurs. The state legislature has determined the method of distributing the one percent tax levy among the various taxing jurisdictions. Property tax revenues are recognized in the fiscal year for which taxes have been levied and collected within sixty days of fiscal year end. Property taxes are billed and collected as follows: Secured Unsecured Valuation/Lien Date(s) January 1 January 1 Levy Date(s) July 1 July 1 Due Date(s) November 1 (50%) August 1 February 1 (50%) Delinquency Date(s) December 10 (Nov.) August 31 April 10 (Feb.) The City adopted an alternative method of property tax distribution (the “Teeter Plan”). Under this method, the City receives 100% of its secured property tax levied in exchange for foregoing any interest and penalties collected on delinquent taxes. The City receives payments as a series of advances made by the County throughout the fiscal year. The secured property tax levy is recognized as revenue upon receipt, including the final payment, which generally is received within 60 days after the fiscal year end. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 37 NOTE 1 – SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (continued) I. Capital Assets Additions and Retirements Capital assets are valued at historical cost or estimated historical cost if actual historical cost is not available. Contributed capital assets are valued at their estimated fair value on the date contributed. The City’s policy is to capitalize all capital assets with costs exceeding a minimum of $2,500, and with useful lives exceeding one year. In the Technology Fund, the City uses a lower cost threshold to capitalize assets due to the nature of the assets. With the implementation of GASB Statement No. 34, the City has recorded all its public domain (infrastructure) capital assets, which include roads, bridges, curbs and gutters, streets and sidewalks, drainage systems, and lighting systems. The City’s collection of zoo animals is not capitalized. The collection of animals is held for public education purposes, is well cared for, and there is a City commitment to continue the collection. The purpose of depreciation is to spread the cost of capital assets equitably among all users over the life of these assets. The amount charged to depreciation expense each fiscal year represents that fiscal year’s pro rata share of the cost of capital assets. GASB Statement No. 34 requires that all capital assets with limited useful lives be depreciated over their estimated useful lives. Depreciation is provided using the straight-line method which means the cost of the asset is divided by its expected useful life in years and the result is charged to expense each fiscal year until the asset is fully depreciated. The City has assigned the useful lives listed below to capital assets. Structures and Improvements 3-100 years Equipment 3-25 years Infrastructure 15-100 years J. Estimates The preparation of financial statements in conformity with accounting principles generally accepted in the United States of America, as prescribed by the GASB and the American Institute of Certified Public Accountants, requires management to make estimates and assumptions that affect the reported amounts of assets and liabilities and disclosure of contingent assets and liabilities at the date of the financial statements and the reported amounts of revenues and expenditures/expenses during the reporting period. Actual results could differ from those estimates. K. Cash and Cash Equivalents For purposes of the statement of cash flows, the City considers all highly liquid investments with a maturity of three months or less when purchased to be cash equivalents. The Proprietary Funds’ “deposits” in the Citywide cash management pool are, in substance, demand deposits and are, therefore, considered cash equivalents for purposes of the statement of cash flows. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 38 NOTE 1 – SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (continued) L. Performance Bonds The City receives performance bonds from developers to ensure compliance and completion of projects that affect the City’s infrastructure. These commitments may be in the form of cash, certificates of deposit in the City’s name, letters of credit, or surety bonds. Upon receipt, these deposits are recorded both as an asset and a liability. For purposes of simplifying the balance sheet, the performance bonds asset account in the amount of $18,076,993 was netted against the liability account of $18,136,327 in fiscal year 2023. The net balance in the performance bond deposits liability account at June 30, 2023, was $59,334 and is included with other amounts in the “Deposits” liability reported in the basic financial statements. M. Short-Term Debt The City has no short-term debt. N. Long-Term Contracts The City uses the percentage-of-completion method of accounting for long-term contracts, recognizing the pro rata portion of the contract in the accounting period covered by the contract. O. Fund Balance Categories of Fund Balance In accordance with Government Accounting Standards Board Statement No. 54, the City classifies fund balances as follows: Non-spendable- includes fund balance amounts that cannot be spent either because it is not in spendable form or because of legal or contractual constraints. Restricted- includes fund balance amounts that are constrained for specific purposes which are externally imposed by providers, such as creditors or amounts constrained due to constitutional provisions or enabling legislation. Committed- includes amounts that can only be used for specific purposes pursuant to constraints imposed by the City Council. Assigned- includes fund balance amounts that are constrained for specific purposes by the City through formal action of the City Council and does not lapse at fiscal year end. Unassigned- includes positive fund balance within the General Fund which has not been classified within the above-mentioned categories and negative fund balances in other governmental funds. Non-Spendable Fund Balance The non-spendable fund balance of $113,582 is comprised of amounts reported in non-spendable form and/or not in cash form such as prepaid items and deposits. Restricted Fund Balance The restricted fund balance of $41,776,338 is comprised of $117,687 for economic development to offset the impact of the impending closure of Pacific Gas and Electric’s Diablo Canyon Power Plant, $5,840,542 for affordable housing, $15,280,625 restricted for debt service, and $20,537,484 restricted for other Capital Project Funds and Special Revenue Funds. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 39 NOTE 1 – SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (continued) O. Fund Balance (continued) Assigned Fund Balance The fund balance assigned for road projects of $227,505 is held in the Capital Projects Fund for road rehabilitation projects. These funds remain from the City Council’s action to move funds annually in fiscal years 2001/2002 through 2007/2008 for these projects, and associated interest earnings. Use of Fund Balance Order The City budgets and expends funds for each project or expense based on specific identified funding sources that are available now and in the future. This means that, at times, the City may use unrestricted funds first for a particular project, leaving the eligible restricted funds available for a specific future project; however, it is the City’s general policy to use restricted amounts first when both restricted and unrestricted amounts are available. Similarly, the City would typically first use committed, then assigned, and lastly unassigned amounts of unrestricted fund balance when expenditures are made. Minimum Fund Balance Policy The City adopted a formal fund balance policy stating that as part of the biennial budget process, fund balance shall be evaluated to determine the prudent level of reserves based on eleven key measurements. The policy further states that except in the case of natural or fiscal emergencies, the City’s general fund balance shall not fall below 20% of General Fund expenditures. The General Fund reserve met this criterion for fiscal year 2022-2023. Major Special Revenue and Capital Projects Funds The purpose for each major fund may be found in Note 1(C); however, each major special revenue and capital projects fund and its revenue source is listed below: Major Special Revenue and Debt Service Funds Revenue Source In Lieu Low/Moderate Income Housing Fund New Developments Local Transportation Fund Local Transportation Funds Circulation System Fees Fund Development Impact Fees Fire Aerial Vehicle Impact Fees Fund Development Impact Fees 2010 Bond Debt Service Fund Successor Agency Tax Increment CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 40 NOTE 1 – SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (continued) O. Fund Balance (continued) Detailed Schedule of Fund Balances A detailed schedule of fund balances is provided below: General Fund In Lieu Low/Moderate Income Housing Fund Local Transportation Fund Circulation System Fees Fund Fire Aerial Vehicle Impact Fees Fund 2010 Bond Debt Service Fund Totals FUND BALANCES: Nonspendable 112,852$ -$ -$ -$ -$ -$ 730$ 113,582$ Restricted Public Safety - - - - - - 1,960,179 1,960,179 Streets, Roads, and Drainage - - 8,554,348 2,771,566 - - 3,793,374 15,119,288 Parks, Open Space, and Recreation - - - - - - 2,419,078 2,419,078 117,687 - - - - - 1,038,939 1,156,626 Affordable Housing - 5,840,542 - - - - - 5,840,542 Debt Service - - - - - 15,280,625 - 15,280,625 Assigned Roads Projects - - - - - - 227,505 227,505 Unassigned 20,956,096 - - - (700,406) - (1,929) 20,253,761 Total Fund Balances (Deficits)21,186,635$ 5,840,542$ 8,554,348$ 2,771,566$ (700,406)$ 15,280,625$ 9,437,876$ 62,371,186$ Other Nonmajor Governmental Funds Disclosure of Fund Balances Reported on Balance Sheet June 30, 2023 Community Development and Blight Elimination Deposits, prepaid items, and inventory CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 41 NOTE 1 – SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (continued) P. New GASB Pronouncements GASB Statements listed below will be implemented in future financial statements: Statement No. 99 "Omnibus 2022" The provisions of this statement are effective in April 2022 except for the provisions related to leases, PPPs, SBITAs, financial guarantees and derivative instruments. The provisions related to leases, PPPs, and SBITAs are effective for fiscal years beginning after June 15, 2022. The provisions related to financial guarantees and derivative instruments are effective for fiscal years beginning after June 15, 2023. Statement No. 100 "Accounting Changes and Error Corrections - an amendment of GASB Statement No. 62" The provisions of this statement are effective for fiscal years beginning after June 15, 2023. Statement No. 101 "Compensated Absences" The provisions of this statement are effective for fiscal years beginning after December 15, 2023. Q. Deferred Outflows and Inflows of Resources Pursuant to GASB Statement No. 63, Financial Reporting of Deferred Outflows of Resources, Deferred Inflows of Resources, and Net Position, and GASB Statement No. 65, Items Previously Reported as Assets and Liabilities, the City recognizes deferred outflows and inflows of resources. In addition to assets, the Statement of Net Position will sometimes report a separate section for deferred outflows of resources. A deferred outflow of resources is defined as a consumption of net position by the government that is applicable to a future reporting period. The City has one item which qualifies for reporting in this category; refer to Note 9 for a detailed listing of the deferred outflows of resources the City has recognized. In addition to liabilities, the Statement of Net Position will sometimes report a separate section for deferred inflows of resources. A deferred inflow of resources is defined as an acquisition of net position by the City that is applicable to a future reporting period. The City has one item which qualifies for reporting in this category; refer to Note 9 for a detailed listing of the deferred inflows of revenues the City recognized. R. Pensions For purposes of measuring the net pension liability and deferred outflows/inflows of resources related to pensions and pension expense, information about the fiduciary net position of the City of Atascadero’s California Employees’ Retirement System (CalPERS) Plan (Plan) and additions to/deductions from the Plan’s fiduciary net position have been determined on the same basis as they are reported by CalPERS. 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. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 42 NOTE 2 – STEWARDSHIP, COMPLIANCE, AND ACCOUNTABILITY A. Budgetary Information Biennial budgets are adopted on a basis consistent with accounting principles generally accepted in the United States of America for all governmental funds. After adoption of the final budget, transfers of appropriations within a general fund department, or within other funds, can be made by the City Manager or his appointee. Budget modifications between funds, and increases or decreases to a fund’s overall budget, must be approved by the City Council. Numerous properly authorized amendments were made during the fiscal year. Budgetary control is enhanced by integrating the budget into the general ledger accounts. Encumbrance accounting is employed (e.g., purchase orders) to avoid expenditures over budget. Encumbrances outstanding at fiscal year-end are automatically re-budgeted in the following fiscal year. B. Deficit Fund Balance A deficit fund balance exists in the Fire Aerial Vehicle Impact Fees Fund due to large purchases incurred prior to the receipt of the long-term reimbursing revenues. A deficit fund balance exists in the Supplemental Law Enforcement Services Fund due to a negative adjustment of market valuation per the requirements of GASB Statement No. 31. Deficit Fund Balance Major Governmental Fund Fire Aerial Vehicle Impact Fees Fund (700,406)$ Nonmajor Governmental Fund Supplemental Law Enforcement Services Fund (1,929) CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 43 NOTE 2 – STEWARDSHIP, COMPLIANCE, AND ACCOUNTABILITY (continued) C. Excess of Expenditures over Appropriations Excess Expenditures Nonmajor Governmental Funds Supplemental Law Enforcement Services Fund (3,087)$ Community Facilities District Fund (34) Expenditures exceeded projections in the Supplemental Law Enforcement Services fund due to the expenditure of unexpected interest income. Expenditures exceeded projections in the Community Facilities District Fund due to higher than expected contract engineering service costs. NOTE 3 – CASH AND INVESTMENTS Cash balances from all funds are combined and invested to the extent possible, pursuant to the Investment Policy and Guidelines approved by the City Council, as well as State Government Code. The earnings from these investments are allocated monthly to each fund, based on an average of monthly opening and closing balances of cash and investments. Investments are stated at fair value. Cash and investments at June 30, 2023, consisted of the following: Pooled Cash and Investments: Cash in bank and on hand 6,268,287$ Investments 42,221,298 Local Agency Investment Fund (LAIF)26,572,279 Total Pooled Cash and Investments 75,061,864 Funds with Fiscal Agents: United States Treasury Money Fund 2,336,227 Total Funds with Fiscal Agents 2,336,227 Total Cash and Investments 77,398,091$ CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 44 NOTE 3 – CASH AND INVESTMENTS (continued) Cash and investments are reflected in the accompanying financial statements as follows: Governmental Activities Business- Type Activities Private-Purpose Trust Funds Total Cash and investments 63,463,667$ 9,990,402$ 1,522,322$ 74,976,391$ Cash and investments held by fiscal agents 1,455,625 - 880,602 2,336,227 Restricted certificates of deposit 85,473 - - 85,473 Total Cash and Investments 65,004,765$ 9,990,402$ 2,402,924$ 77,398,091$ A. Deposits with Financial Institutions For custodial credit risk associated with deposits, the City follows the California Government Code, which requires California financial institutions to secure the City’s deposits by pledging government securities as collateral. The fair value of the pledged securities must equal 110% of the City’s deposits. California law also allows financial institutions to secure City deposits by pledging first trust deed mortgage notes equal to 150% of the City’s deposits. At fiscal year end, the City’s bank account balance was $6,409,009. The first $250,000 was insured by federal depository insurance and the remainder was 110% collateralized. Certificates of Deposit totaling $14,677,323 are fully insured. B. State Investment Pool The fair value of the City’s position in the State LAIF pool is the same as the value of the pool shares. The State LAIF pool credit quality is unrated. LAIF is overseen by the Local Agency Investment Advisory Board, which consists of five members, in accordance with State statute. The State Treasurer’s Office audits the fund annually. Separate financial statements for LAIF can be obtained by writing Local Agency Investment Fund, Post Office Box 942809, Sacramento, CA 94209-0001. C. Authorized Investments The City’s Investment Policy lists the following as authorized investments: Local Agency Investment Fund (LAIF) U.S. Government Obligations California and California Local Agency Municipal Obligations Other State Municipal Obligations Supranational Securities Bankers’ Acceptances Commercial Paper Certificates of Deposit and Passbook Savings Accounts Money Market Funds CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 45 NOTE 3 – CASH AND INVESTMENTS (continued) D. Marking Investments to Fair Value (GASB Statement No. 31) In fiscal year 1997/98, the City adopted Governmental Accounting Standards Board Statement No. 31, which requires that the City’s investments be carried at fair value instead of cost. Under GASB Statement No. 31, the City must adjust the carrying value of its investments to reflect their fair value at each fiscal year end, and it must include the effects of these adjustments in income for that fiscal year. GASB Statement No. 31 applies to all City investments, even if held to maturity and redeemed at full face value. Since the City’s policy is to hold all investments to maturity, the fair value adjustments required by GASB Statement No. 31 result in accounting gains or losses (called “recognized” gains or losses) which do not reflect actual sales of the investments (called “realized” gains or losses). Thus, recognized gains or losses on an investment purchased at par will now reflect changes in its value at each succeeding fiscal year end, but these recognized gains or losses will net to zero if the investment is held to maturity. By following the requirements of GASB Statement No. 31, the City is reporting the amount of resources which would actually have been available if it had been required to liquidate all of its investments at any fiscal year end. E. Governmental Accounting Standards Board (GASB) Statement No. 72, Fair Value Measurements and Application, provides the framework for measuring fair value. The framework provides a fair value hierarchy that prioritizes the inputs to valuation techniques used to measure fair value with Level 1 given the highest priority and Level 3 the lowest priority. The three levels of the fair value hierarchy are as follows: Level 1 inputs are quoted prices (unadjusted) in active markets for identical assets or liabilities that the organization has the ability to access at the measurement date. Level 2 inputs are inputs other than quoted prices included within Level 1 that are observable for the asset or liability, either directly or indirectly. Level 2 inputs include the following: 1. Quoted prices for similar assets or liabilities in active markets. 2. Quoted prices for identical or similar assets or liabilities in markets that are not active. 3. Inputs other than quoted prices that are observable for the asset or liability (for example, interest rates and yield curves observable at commonly quoted intervals, volatilities, prepayment speeds, loss severities, credit risks, and default rates). 4. Inputs that are derived principally from or corroborated by observable market data by correlation or other means (market-corroborated inputs). Level 3 inputs are unobservable inputs for the asset or liability. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 46 NOTE 3 – CASH AND INVESTMENTS (continued) Fair value of assets measured on a recurring basis at June 30, 2023, are as follows: June 30, 2023 Fair Value Quoted Prices in Active Markets for Identical Assets (Level1) Significant Other Observable Inputs (Level 2) Uncategorized (Level 3) U. S. Government Obligations 17,402,001$ -$ 17,402,001$ -$ Supranational Securities 2,936,575 - 2,936,575 - Municipal Securities 7,205,399 - 7,205,399 - Certificates of Deposit 14,677,323 - 14,677,323 - 42,221,298 -$ 42,221,298$ -$ Investments measured at amortized cost United States Treasury Money Fund 2,336,227 Local Agency Investment Fund (LAIF)26,572,279 Total investments 71,129,804$ Fair values for investments are determined by using a matrix pricing technique. Matrix pricing is used to value securities based on the security’s relationship to benchmark quoted prices. Uncategorized investments do not fall under the fair value hierarchy as there is no active market for the investments. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 47 NOTE 3 – CASH AND INVESTMENTS (continued) F. Investments Investments for the City are summarized below: Investments Fair Value Percent of Portfolio U.S. Government Obligations 17,402,001$ 25% Supranational Securities 2,936,575 4% Municipal Securities 7,205,399 10% Certificates of Deposit 14,677,323 22% Local Agency Investment Fund (LAIF)26,572,279 39% Total Investments Managed by City 68,793,577$ 100% Investments Held by Fiscal Agents United States Treasury Money Fund 2,336,227$ 100% Total Investments Held by Fiscal Agents 2,336,227$ 100% Fair Value On Demand Within One Month One Month to One Year One to Five Years Investments U.S. Government Obligations 17,402,001$ -$ -$ 2,349,883$ 15,052,118$ Supranational Securities 2,936,575 - - 996,295 1,940,280 Municipal Securities 7,205,399 - - - 7,205,399 Certificates of Deposit 14,677,323 - - 3,139,769 11,537,554 * Local Agency Investment Fund (LAIF)26,572,279 26,572,279 - - - Investments Held by Fiscal Agents 2,336,227 2,336,227 **- - - Total Investments Managed by City 71,129,804$ 28,908,506$ -$ 6,485,947$ 35,735,351$ Percentage of Portfolio 100%41%0%9%50% * Included here is $85,473 in certificates of deposit with a local bank, serving as collateral for the Local Road Improvement Loan Program, approved by Council on June 14, 2005. ** Held by fiscal agents for the 2010 Lease Revenue Bonds and the 2004 Tax Allocation Bonds CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 48 NOTE 3 – CASH AND INVESTMENTS (continued) F. Investments (continued) Interest Rate Risk. This is the risk that the market value of securities in the portfolio will fall, due to changes in general interest rates. In accordance with its Investment Policy, the City mitigates interest rate risk by: • Structuring the investment portfolio so that securities mature to meet cash requirements for ongoing operations, thereby avoiding the need to sell securities on the open market prior to maturity. • Investing operating funds primarily in shorter-term securities, money market mutual funds, or similar investment pool. Credit Risk. This is the risk of loss due to the failure of the security issuer or backer. The City mitigates credit risk by: • Limiting investments to the safest types of securities. • Pre-qualifying the financial institutions, broker/dealers, intermediaries, and advisers with which the City will do business. • Diversifying the investment portfolio so that potential losses on individual securities will be minimized. State law limits investments in commercial paper and corporate bonds to the top two ratings issued by Nationally Recognized Statistical Rating Organizations (NRSROs). It is the City’s policy to limit its investments in these investment types to the top rating issued by NRSROs. The City does not hold any commercial paper or corporate bonds. U. S. Government Obligations held by the City are rated AAA, the top rating issued by NRSROs. The City’s investment in the State LAIF pool is unrated, as are the investments in Certificates of Deposit. Fair Value AAA - A Not Rated Investments U. S. Government Obligations 17,402,001$ 17,402,001$ -$ Supranational Securities 2,936,575 2,936,575 - Municipal Securities 7,205,399 7,205,399 - Certificates of Deposit 14,677,323 - 14,677,323 Local Agency Investment Fund (LAIF)26,572,279 - 26,572,279 Investments Held by Fiscal Agents 2,336,227 - 2,336,227 Total Investments Managed by City 71,129,804$ 27,543,975$ 43,585,829$ Rating as of June 30, 2023 Custodial Credit Risk. Custodial credit risk is the risk that in the event of failure of the counterparty, the government will not be able to recover the value of its investments or collateral securities that are in the possession of an outside party. The City’s investments in government securities are held in trust by US Bank and are exposed to custodial credit risk because these investments are uninsured and collateralized with securities held by the US Bank’s trust department or agency, but not in the City’s name. The amounts held under this custodial arrangement are not limited by the City’s Investment Policy. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 49 NOTE 3 – CASH AND INVESTMENTS (continued) F. Investments (continued) Concentration Credit Risk. The City’s Investment Policy provides guidelines (by type of investment vehicle that limits either the dollar amount, the percent of the portfolio or the maturity term) for diversifying the investment portfolio so that potential losses on individual securities will be minimized. The City’s Investment Policy outlines the following criteria related to portfolio diversification: • No more than thirty percent (30%) of the City’s portfolio shall be invested in California and California local agency municipal obligations, and other state municipal obligations. • Up to forty percent (40%) of the City’s portfolio may be invested in bankers’ acceptances that are defined as bills of exchange or time drafts, drawn on and accepted by a commercial bank, which are eligible for purchase by the Federal Reserve System, although no more than thirty percent (30%) of the portfolio may be invested in bankers’ acceptances with any one commercial bank. Additionally, the maturity periods cannot exceed 180 days. • A maximum of twenty-five percent (25%) of the City’s portfolio may be invested in highest tier (e.g., A-1, P-1, F-1 or D-1 or higher) commercial paper as rated by Moody’s or Standard and Poor’s rating service. Issuing corporations must be organized and operating in the United States, have $500 million total assets, and have at least an “A” rating (by Moody’s or Standard and Poor’s) on debt other than commercial paper. The maturity period cannot exceed 270 days. Purchases of eligible commercial paper may not exceed 10% of the outstanding paper of an issuing corporation. • A maximum of thirty percent (30%) of the City’s portfolio may be deposited in certificates of deposit or passbook savings accounts. The minimum requirements for certificate of deposit investments shall be: o Investments and accrued interest shall never exceed the FDIC insurance limit in any one institution. o Qualified institutions must have a minimum equity ratio of 6% and a minimum capitalization of $10,000,000. • Shares of beneficial interest issued by diversified management companies that are money market funds registered with the Securities and Exchange Commission under the Investment Company Act of 1940 (15 U.S.C. Sec 80a-l et seq.) shall not exceed twenty percent (20%) of the agency's surplus money that may be invested pursuant to the City’s Investment Policy. • Up to thirty percent (30%) of the City’s portfolio may be invested in United States dollar denominated senior unsecured unsubordinated obligations issued or unconditionally guaranteed by the International Bank for Reconstruction and Development, International Finance Corporation, or Inter-American Development Bank, with a maximum remaining maturity of five years or less, and eligible for purchase and sale within the United States. Investments under this paragraph shall be rated in a rating category of “AA” or its equivalent or better by a nationally recognized statistical rating organization. No more than 10% of the City’s portfolio shall be invested in obligations of any one bank. G. Funds with Fiscal Agents The City had $1,455,625 in cash and investments as of June 30, 2023, held by fiscal agents pledged for the payment or security of the 2010 Lease Revenue Bonds. There was an additional $880,602 held by fiscal agents for the 2004 Redevelopment Agency Tax Allocation Bonds in the Successor Agency to the Community Redevelopment Agency of Atascadero Private Purpose Trust Fund. The California Government Code provides that these monies, in the absence of specific statutory provisions governing the issuance of bonds, certificates, or leases, may be invested in accordance with the ordinance, resolutions, or indentures specifying the types of investments its fiscal agents may make. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 50 NOTE 4 – ADVANCES RECEIVABLE – SUCCESSOR AGENCY Receivable Fund Payable Fund Amount 2010 Bond Debt Service Fund Successor Agency General Fund 13,825,000$ Total 13,825,000$ Advances receivable of $13,825,000 consists of a reimbursement agreement with the City for bond debt service. In September of 2010, the City issued bonds on behalf of the former Redevelopment Agency and entered into a reimbursement agreement at that time whereby the City advanced the former Agency the proceeds of the bond and the former Agency was required to make annual payments to the City in the amount of the debt service on the bonds. With the dissolution of redevelopment, this is now a debt of the Successor Agency and the Successor Agency will continue to make the required payments. See Note 15D – Successor Agency Trust for Assets of Former Redevelopment Agency, Bond Reimbursement Agreement Payable, for additional information. This arrangement meets the criteria of ABX1 26, Section 34171(d)(G)(2): • Written agreement entered into: o At the time of issuance, but no later than December 31, 2010, of indebtedness obligations o Solely for the purpose of securing or repaying those indebtedness obligations. • Section 34171(e) defines “indebtedness obligation”: bonds, notes, certificates of participation, or other evidence of indebtedness, issued or delivered by the redevelopment agency, or by a joint exercise of powers authority created by the redevelopment agency, to third-party investors or bondholders to finance or refinance redevelopment projects undertaken by the redevelopment agency in compliance with the Community Redevelopment Law. NOTE 5 – NOTES RECEIVABLE Notes Receivable in the amount of $4,050,899 is outstanding in the In Lieu Low/Moderate Income Housing Fund. Developments meeting certain criteria must either pay an In-Lieu fee into the fund or provide “affordably” priced homes for sale to income qualified buyers. These homes are sold by developers at prices below fair market value and the City records notes receivable against the titles in the amounts equal to the difference between the reduced sales prices and the fair market values. The loans are either paid back on a pro-rata share of equity at the time the homes sell or are forgiven after a period of 30 years of ownership by the same homeowner. The Notes Receivable amount includes loans for 22 homes in the Very Low-Income category and 8 homes in the Low/Moderate Income category. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 51 NOTE 6 – CAPITAL ASSETS A. Capital Assets Additions and Retirements Capital assets activity in the Governmental Activities for the fiscal year ended June 30, 2023, was as follows: Balance June 30, 2022 Additions Deletions Transfers Between Assets Balance June 30, 2023 Governmental Activities Non-Depreciable capital assets Land 41,659,554$ -$ -$ -$ 41,659,554$ Construction in progress 5,163,296 7,488,288 - (4,234,285) 8,417,299 Total non-depreciable capital assets 46,822,850 7,488,288 - (4,234,285) 50,076,853 Depreciable or amoritizable capital assets Vehicles and equipment 14,048,430 915,892 (10,341) 348,825 15,302,806 Structures and improvements 56,796,873 37,277 - 35,237 56,869,387 Subscription assets - 949,033 - - 949,033 Infrastructure 79,161,466 224,078 (579,520) 3,850,223 82,656,247 150,006,769 2,126,280 (589,861) 4,234,285 155,777,473 (54,876,567) (3,971,470) 491,839 - (58,356,198) Net depreciable capital assets 95,130,202 (1,845,190) (98,022) 4,234,285 97,421,275 Net governmental capital assets 141,953,052$ 5,643,098$ (98,022)$ -$ 147,498,128$ Less accumulated depreciation or amortization Total depreciable or amortizable capital assets CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 52 NOTE 6 – CAPITAL ASSETS (continued) A. Capital Assets Additions and Retirements (continued) Capital assets activity in the Business-Type Activities for the fiscal year ended June 30, 2023, was as follows: Balance June 30, 2022 Additions Deletions Transfers Between Assets Balance June 30, 2023 Business-Type Activities Non-depreciable capital assets Land 547,738$ -$ -$ -$ 547,738$ Construction in progress 5,717,647 539,978 (18,828) (3,605,461) 2,633,336 Total non-depreciable capital assets 6,265,385 539,978 (18,828) (3,605,461) 3,181,074 Depreciable capital assets Vehicles and equipment 1,232,249 143,463 - - 1,375,712 Structures and improvements 30,307,997 241,324 - 3,605,461 34,154,782 Total depreciable or amortizable capital assets 31,540,246 384,787 - 3,605,461 35,530,494 (19,307,208) (759,380) - - (20,066,588) Net depreciable capital assets 12,233,038 (374,593) - 3,605,461 15,463,906 Net business-type capital assets 18,498,423$ 165,385$ (18,828)$ -$ 18,644,980$ Less accumulated depreciation CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 53 NOTE 6 – CAPITAL ASSETS (continued) B. Depreciation Allocations Depreciation expense was charged to functions and programs based on their usage of the related assets. The amounts allocated to each function or program were as follows: Governmental Activities: General government 368,324$ Public safety 758,866 Community development 235,929 Community, recreation & zoo services 388,731 Parks & open space 311,078 Public works 1,908,542 Total Depreciation and Amortization Expense- Governmental Activities 3,971,470$ Sewer 665,615$ Transit 93,765 Total Depreciation Expense- Business-Type Activities 759,380$ Business-Type Activities: CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 54 NOTE 7 – INTERFUND RECEIVABLES, PAYABLES, AND TRANSFERS A. Interfund Receivables and Payables Due to/due from other funds consist of short-term interfund loans made for the purposes of cash flows. They are expected to be repaid by the borrowing fund within one year. The composition of due to/due from balances at June 30, 2023, is as follows: Receivable Fund Payable Fund Amount General Fund Nonmajor Community Development Block Grant Fund 57,049$ General Fund Nonmajor Community Facilities District Fund 13,824 Nonmajor Fire Facilities Fees Fund Fire Aerial Vehicle Impact Fees Fund 700,406 Total 771,279$ B. Interfund Transfers Interfund transfers were made as follows: Actual Amount Description 743,353$ Transfer from the Community Facilities District Fund to the General Fund for fire, police, and park services 275,456 Transfer from the General Fund to the Gas Tax Fund for the cost of Streets Department operations 4,694,000 Transfer from the General Fund to the Local Transportation Fund for the Downtown Infrastructure Enhancement Plan 6,512 Transfer from the Gas Tax Fund to the Local Transportation Fund for the El Camino Real South Rehabilitation Project 234 Transfer from the Gas Tax Fund to the Local Transportation Fund for the Traffic Way North Project 2,600 Transfer from the General Fund to the Las Lomas Landscape & Lighting Fund for open space maintenance 1,400 Transfer from the General Fund to the De Anza Landscape & Lighting Fund for open space maintenance 2,393 Transfer from the General Fund to the General Government Facilities Fees Fund for vehicle purchase 255,090 Transfer from the 2010 Bond Proceed Master Agreement Fund to the Local Transportation Fund for the Downtown Infrastructure Enhancement Plan 5,981,038$ CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 55 NOTE 8 – LONG-TERM LIABILITIES A. Compensated Absences City employees accumulate earned but unused vacation and certain other leave pay benefits which can be converted to cash at termination of employment. In the statement of activities, the expenditure is allocated to each function based on usage. The vested benefits payable in accordance with various collective bargaining agreements at June 30, 2023, total $1,944,902 for governmental activities and $7,834 for business-type activities. B. 2010 Lease Revenue Bonds On September 1, 2010, the City of Atascadero issued $16,010,000 in Lease Revenue Bonds for the former Community Redevelopment Agency of Atascadero. The bonds were issued by the City in order to achieve an overall lower interest rate on the bonds. The bond proceeds were transferred to the former Redevelopment Agency for use on the Historic City Hall Project and other redevelopment blight elimination projects. These bonds mature between fiscal years 2015 and 2041, at interest rates ranging from 3.0% to 5.0%. The Successor Agency makes payments, from tax increment revenues, to the City in amounts equal to the annual debt service payments on the bonds. The bonds will then be repaid by the City using these revenues. The following is a summary of principal and interest payments to be made in future fiscal years: Fiscal Year Ending June 30,Principal Interest 2024 $ 295,000 $ 676,963 2025 305,000 664,581 2026 315,000 651,800 2027 330,000 637,250 2028 350,000 620,250 2029-2033 2,010,000 2,815,750 2034-2038 5,250,000 2,049,250 2039-2041 4,970,000 381,000 $ 13,825,000 $ 8,496,844 2010 Lease Revenue Bonds CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 56 NOTE 8 – LONG-TERM LIABILITIES (continued) C. Changes in Long-Term Liabilities Long-term liability activity for the fiscal year ended June 30, 2023, was as follows: Balance June 30, 2022 Additions Payments Balance June 30, 2023 Due Within One Year Governmental Activities: Bonds Payable: 14,100,000$ -$ (275,000)$ 13,825,000$ 295,000$ Compensated Absences 1,898,086 1,264,788 (1,217,972) 1,944,902 - Premium on 2010 Lease Revenue Bonds 54,476 - (2,982) 51,494 2,990 Subscription Liability - 530,028 (114,272) 415,756 93,975 (17,734) (211,167) 67,260 (161,641) - Net Pension Liability 18,270,558 19,998,397 (4,142,844) 34,126,111 - Other Post Employment Benefits Liability 233,620 21,662 (4,346) 250,936 - Total Governmental Activities 34,539,006$ 21,603,708$ (5,690,156)$ $ 50,452,558 391,965$ Business-type Activities: Compensated Absences 13,331$ 24,150$ (29,647)$ 7,834$ -$ Net Pension Liability 488,641 484,493 (93,738) 879,396 - Total Business-type Activities $ 501,972 508,643$ $ (123,385) $ 887,230 -$ 2010 Lease Revenue Bonds Workers' Compensation estimated claims liability in excess of deposits D. Subscription Based Information Technology Arrangements On January 12, 2022, the City entered into an initial contract term for Computer-Aided Dispatch/Records Management System (CAD/RMS) software arrangement with Mark43, Inc.. The CAD/RMS system was implemented February 1, 2023, and has a term of six years. Accumulated depreciation for the current year was $34,773 and the outflows of resources in the current year were $119,744. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 57 NOTE 8 – LONG-TERM LIABILITIES (continued) D. Subscription Based Information Technology Arrangements (continued) The following is a summary of principal and interest payments to be made in future fiscal years: Fiscal Year Ending June 30,Principal Interest 2024 $ 93,975 $ 12,245 2025 100,475 8,947 2026 107,202 5,577 2027 114,104 2,105 $ 415,756 $ 28,874 Mark43, Inc - CAD/RMS The City entered into a prepaid software arrangement with CIO Solutions for Firewall Software. The initial contract term is September 25, 2021 – September 24, 2024. The total subscription asset is valued at $35,396, and $10,029 has accumulated in amortization as of the end of the fiscal year. The City entered into a prepaid software arrangement with SHI International Corp. for Malwarebytes Software. The initial contract term is July 31, 2022 – July 31, 2025. The total subscription asset is valued at $25,174, and $7,708 has accumulated in amortization as of the end of the fiscal year. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 58 NOTE 9 – EMPLOYEE RETIREMENT BENEFITS A. Public Employees’ Retirement System Summary of Significant Accounting Policies-Pensions For purposes of measuring the net pension liability and deferred outflows/inflows of resources related to pensions and pension expense, information about the fiduciary net position of the City of Atascadero’s California Public Employees’ Retirement System (CalPERS) Plan (Plan) and additions to/deductions from the Plan’s fiduciary net position have been determined on the same basis as they are reported by CalPERS. 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. Plan Descriptions All qualified permanent and probationary employees are eligible to participate in the Public Agency Cost-Sharing Multiple-Employer Defined Benefit Pension Plan (Plan) administered by the California Public Employees’ Retirement System (CalPERS.) The Plan consists of individual rate plans (benefit tiers) within a safety risk pool (police and fire) and a miscellaneous risk pool (all others). Plan assets may be used to pay benefits for any employer rate plan of the safety and miscellaneous pools. Accordingly, rate plans within the safety or miscellaneous pools are not separate plans under GASB Statement No. 68. Individual employers may sponsor more than one rate plan in the miscellaneous or safety risk pools. The City of Atascadero sponsors six rate plans (three miscellaneous and three safety). Benefit provisions under the Plan are established by State statute and City of Atascadero resolution. CalPERS issues publicly available reports that include a full description of the pension plan regarding benefit provisions, assumptions, and membership information that can be found on the CalPERS’ website at www.calpers.ca.gov. Benefits Provided CalPERS provides service retirement and disability benefits, annual cost of living adjustments and death benefits to plan members, who must be public employees and beneficiaries. Benefits are based on years of credited services, equal to a fixed percentage of their highest annual salary formula as determined by the benefit program they participate in. Members with five years of total service are eligible to retire at age 50 with statutorily reduced benefits. All members are eligible for non-duty disability benefits after 10 years of service. The death benefit is one of the following: the Basic Death Benefit, the 1957 Survivor Benefit, or the Optional Settlement 2W Death Benefit. The cost-of-living adjustments for each plan are applied as specified by the Public Employees’ Retirement Law. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 59 NOTE 9 – EMPLOYEE RETIREMENT BENEFITS (continued) A. Public Employees’ Retirement System (continued) Benefits Provided (continued) The rate plan provisions and benefits in effect at June 30, 2023, are summarized as follows: Tier 1 Tier 2 Tier 3 Hire date Prior to July 1, 2012 On or after July 1, 2012 On or after January 1, 2013 Benefit formula 2.5% @ 55 2.0% @ 55 2.0% @ 62 Benefit vesting schedule 5 years service 5 years service 5 years service Benefit payments monthly for life monthly for life monthly for life Retirement age 50-55 50-63 52-67 Monthly benefits, as a % of eligible compensation 2.0% to 2.5%1.426% to 2.418%1.0% to 2.5% Required employee contribution rates 8.00%7.00%7.25% Required employer contribution rates 13.02%11.06%7.76% Miscellaneous Plan Tier 1 Tier 2 Tier 3 Hire date Prior to July 1, 2012 On or after July 1, 2012 On or after January 1, 2013 Benefit formula 3.0% @ 50 3.0% @ 55 2.7% @ 57 Benefit vesting schedule 5 years service 5 years service 5 years service Benefit payments monthly for life monthly for life monthly for life Retirement age 50 50-55 50-57 Monthly benefits, as a % of eligible compensation 3.0%2.4% to 3.0%2.0% to 2.7% Required employee contribution rates 9.00%9.00%13.00% Required employer contribution rates 23.75%20.64%12.78% Safety Plan CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 60 NOTE 9 – EMPLOYEE RETIREMENT BENEFITS (continued) A. Public Employees’ Retirement System (continued) Contributions- Section 20814(c) of the California Public Employees’ Retirement Law requires that the employer contribution rates for all public employers be determined on an annual basis by the actuary and shall be effective on the July 1 following notice of a change in the rate. Funding contributions for the Plan is determined annually on an actuarial basis as of June 30 by CalPERS. The actuarially determined rate is the estimated amount necessary to finance the costs of benefits earned by employees during the year, with an additional amount to finance any unfunded accrued liability. The City is required to contribute the difference between the actuarially determined rate and the contribution rate of the employees. The City’s contributions to the Plan for the fiscal year ended June 30, 2023, were $4,688,082. Beginning in fiscal year 2016, CalPERS collects employer contributions for the Plan as a percentage of payroll for the normal cost portion as noted in the rates above and as a dollar amount for contributions toward the unfunded liability and side fund. The dollar amount was paid at the beginning of the fiscal year. The City of Atascadero’s required contribution for the unfunded liability and side fund was $2,940,204 in fiscal year ended June 30, 2023. B. Pension Liabilities, Pension Expenses, and Deferred Outflows/Inflows of Resources Related to Pensions As of June 30, 2023, the City reported a net pension liability for its proportionate share of the net pension liability of the Plan of $35,005,507. The City’s net pension liability for the Plan is measured as the proportionate share of the net pension liability. The net pension liability of the Plan is measured as of June 30, 2022, and the total pension liability for the Plan used to calculate the net pension liability was determined by an actuarial valuation as of June 30, 2021, rolled forward to June 30, 2022, using standard update procedures. The City’s proportion of the net pension liability was based on a projection of the City’s long-term share of contributions to the pension plan relative to other projected contributions of all participating employers, actuarially determined. The City’s proportionate share of the net pension liability for the Plan as of measurement dates June 30, 2022, and 2021, was as follows: June 30, 2023 June 30, 2022 Measurement Date 6/30/2022 6/30/2021 Percentage of Plan (PERF C) Net Pension Liability 0.30306%0.34686%-0.04380% Change: Increase/ (Decrease) Percentage share of Plan Proportionate Percentage Share of Net Pension Liability CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 61 NOTE 9 – EMPLOYEE RETIREMENT BENEFITS (continued) B. Pension Liabilities, Pension Expenses, and Deferred Outflows/Inflows of Resources Related to Pensions (continued) For the fiscal year ended June 30, 2023, the City recognized pension expense of $485,820. At June 30, 2023, the City reported deferred outflows of resources and deferred inflows of resources related to pensions from the following sources: Deferred Outflows of Resources Deferred Inflows of Resources Differences between expected and actual experience 1,129,914$ (418,905)$ Changes of assumptions 3,554,168 - Net differences between projected and actual earnings on plan investments 5,905,885 - Change in employer's proportion 111,525 (147,995) Differences between the employer's contributions and the employer's proportionate share of contributions - (1,246,132) Pension contributions subsequent to measurement date 4,688,082 - Total 15,389,574$ (1,813,032)$ All Plans $4,688,082 reported as deferred outflows of resources related to contributions subsequent to the measurement date will be recognized as a reduction of the net pension liability in the fiscal year ended June 30, 2024. Other amounts reported as deferred outflows of resources and deferred inflows of resources related to pensions will be recognized as pension expense as follows: Fiscal Year Ended June 30, Deferred Outflows / (Inflows) of Resources 2024 2,354,144$ 2025 1,893,749 2026 1,033,456 2027 3,607,111 CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 62 NOTE 9 – EMPLOYEE RETIREMENT BENEFITS (continued) B. Pension Liabilities, Pension Expenses, and Deferred Outflows/Inflows of Resources Related to Pensions (continued) Actuarial Assumptions – For the measurement period ended June 30, 2022, the total pension liabilities were determined by rolling forward the June 30, 2021, valuation of total pension liability. The June 30, 2022, total pension liability was based on the following actuarial methods and assumptions: Valuation Date Measurement Date Actuarial Assumptions: Discount Rate Inflation Salary Increases Post Retirement Benefit Increase Mortality Plan June 30, 2021 June 30, 2022 6.90% 2.30% Varies by Entry Age and Service Contract COLA up to 2.3% until Purchasing Power Protection Allowance Floor on Purchasing Power Applies Derived using CalPERS' Membership Data for all Funds. The mortality rates incoporate Generational Mortality tp capture ongoing mortality improvements using 80% of Scale MP 2020 published by the Society of Actuaries. The mortality table used was developed based on CalPERS’ specific data. The rates incorporate Generational Mortality to capture ongoing mortality improvement using 80% of Scale MP 2020 published by the Society of Actuaries. For more details, please refer to the 2021 experience study report that can be found on the CalPERS’ website. Discount Rate The discount rate used to measure the total pension liability for PERF C was 6.90%. The projection of cash flows used to determine the discount rate assumed that contributions from plan members will be made at the current member contribution rates and that contributions from employers will be made at statutorily required rates, actuarially determined. Based on those assumptions, the Plan’s fiduciary net position was projected to be available to make all projected future benefit payments of current plan members. Therefore, the long-term expected rate of return on plan investments was applied to all periods of projected benefit payments to determine the total pension liability. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 63 NOTE 9 – EMPLOYEE RETIREMENT BENEFITS (continued) B. Pension Liabilities, Pension Expenses, and Deferred Outflows/Inflows of Resources Related to Pensions (continued) Actuarial Assumptions (continued) Long-Term Expected Rate of Return In determining the long-term expected rate of return, CalPERS took into account long-term market return expectations as well as the expected pension fund cash flows. Projected returns for all asset classes are estimated and combined with risk estimates, are used to project compound (geometric) returns over the long term. The discount rate used to discount liabilities was informed by the long-term projected portfolio return. The following table reflects long-term expected real rate of return by asset class. The rates of return were calculated using the capital market assumptions applied to determine the discount rate and asset allocation. Asset Class Assumed Asset Allocation 1 Real Return Years 1-10 1,2 Global equity - cap-weighted 30.0%4.45% Global equity non-cap-weighted 12.0%3.84% Private equity 13.0%7.28% Treasury 5.0%0.27% Mortgage-backed Securities 5.0%0.50% Investment Grade Corporates 10.0%1.56% High Yield 5.0%2.27% Emerging Market Debt 5.0%2.48% Private Debt 5.0%3.57% Real assets 15.0%3.21% Leverage -5.0%-0.59% Total 100.0% (1) An expected inflation of 2.30% used for this period. (2) Figures are based on the 2021-22 Asset Liability Management Study. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 64 NOTE 9 – EMPLOYEE RETIREMENT BENEFITS (continued) B. Pension Liabilities, Pension Expenses, and Deferred Outflows/Inflows of Resources Related to Pensions (continued) Sensitivity of Proportionate Share of Net Pension Liability to Changes in the Discount Rate The following presents the City’s proportionate share of the net pension liability for the Plan, calculated using the discount rate for the Plan, 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: 5.90% (1% Decrease) 6.90% (Current Rate) 7.90% (1% Increase) Measurement Date Fiscal Year End Net Pension Liability 51,961,017$ 35,005,507$ 21,108,238$ Discount Rate 6/30/2022 6/30/2023 Pension Plan Fiduciary Net Position Detailed information about the Plan’s fiduciary net positions is available in separately issued CalPERS’ financial reports. C. Payable to the Pension Plan The City paid 100% of the required actuarially determined contributions for the fiscal year ending June 30, 2023, and therefore recorded no payables to the pension plan for the same period. D. Defined Contribution Plan The City offers a defined contribution plan, Nationwide Retirement Solutions, for those employees that are excluded from CalPERS membership due to part- time or elected status. The plan is approved as a FICA substitute. Members contribute 5% and the City contributes 2.5%. Total employee contributions for the fiscal year were $14,957, and total contributions from the City were $7,479. Nationwide Retirement Solutions is the public employee plan subsidiary of Nationwide Financial Services, Inc. (NYSE: NFS). CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 65 NOTE 10 – OTHER POST EMPLOYMENT BENEFITS Plan Description In addition to the CalPERS pension benefits described above, the City provides post-retirement health benefits for Executive Management (City Council, City Manager, Deputy City Managers, and Department Heads). The City agreed to reimburse the retiree for retiree and/or retiree’s dependent health (medical/dental/vision) insurance premiums, disability insurance, long-term health care or life insurance premiums up to a maximum of $200 per month. The benefit is available upon retirement from CalPERS or other similar retirement program after age 50, and the employee must have served for eight years with the City. The benefit extends between the date of retirement and age 65. Currently, there are four people that received benefits in fiscal year 2022/2023, and fourteen other people that may become eligible for benefits under this program. No assets are accumulated in a trust that meets the criteria in paragraph 4 of GASB Statement No. 75. Contributions The City accounts for this benefit on a pay-as-you-go basis. Post employment expenditures are made from the General Fund, which is maintained on the modified accrual basis of accounting. No funds are set aside to pay for benefits and administrative costs. These expenditures are paid as they come due. For fiscal year ended June 30, 2023, the City’s total contributions were $4,346. Employees Covered As of June 30, 2023, the following current and former employees were covered by the benefit under the plan. Active members 11 Inactive members 3 Beneficiaries 4 Total 18 Total OPEB Liability The City has elected to calculate the OPEB liability and related information using the alternative measurement method permitted by GASB Statement No. 75 for employers in plans with fewer than one hundred total plan members. The City’s OPEB liability was measured as of June 30, 2023, and the total OPEB used to calculate the OPEB liability was from the City’s valuation as of June 30, 2023. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 66 NOTE 10 – OTHER POST EMPLOYMENT BENEFITS (continued) Changes in the OPEB Liability Total OPEB Liability Balance at June 30, 2022 (valuation date June 30, 2022)233,620$ Changes recognized for the measurement period: Service cost 14,653 Interest 7,009 Benefit payments (4,346) Net changes 17,316 Balance at June 30, 2023 (valuation date June 30, 2023)250,936$ Sensitivity of the OPEB Liability to Changes in the Discount Rate The following presents the OPEB liability, as well as what the OPEB liability would be if it were calculated using a discount rate that is 1 percentage point lower (2.00%) or 1 percentage point higher (4.00%) than the current discount rate. 1% Decrease Current 1% Increase 2.00%3.00%4.00% OPEB Liability 251,559$ 250,936$ 250,417$ Discount Rate Sensitivity of the OPEB Liability to Changes in the Healthcare Cost Trend Rate The following presents the OPEB liability, as well as what the OPEB liability would be if it were calculated using a healthcare cost trend rate that is 1 percentage point lower (2.00%) or 1 percentage point higher (4.00%) than the current Healthcare Trend Rate of 3.0%. 1% Decrease Current 1% Increase 2.00%3.00%4.00% OPEB Liability 250,417$ 250,936$ 251,559$ Healthcare Trend Rate 3% CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 67 NOTE 10 – OTHER POST EMPLOYMENT BENEFITS (continued) Actuarial Methods and Assumptions Projections of benefits for financial reporting purposes are based on the substantive plan (the plan as understood by the employer and the plan members) and include the types of benefits provided at the time of each valuation and the historical pattern of sharing of benefit costs between the employer and plan members at that point. The actuarial methods and assumptions used include techniques that are designed to reduce the effects of short-term volatility in actuarial accrued liabilities and the actuarial value assets, consistent with the long-term perspective of the calculations. The following simplifying assumptions were made: Retirement age for active employees – Based on the historical average retirement age for the covered group, public safety active plan members were assumed to retire at age 50, or at the first subsequent year in which the member would qualify for benefits and other active plan members were assumed to retire at age 55, or at the first subsequent year in which the member would qualify for benefits. Mortality – All active and inactive plan members were expected to live through age 65 (the age that benefits terminate). Turnover – All active members were expected to remain employed until the assumed retirement/age. Discount Rate – Based on the historical and expected returns of the City’s short-term investment portfolio, a discount rate of 3.0 percent was used. In addition, a simplified version of the projected unit credit and level cost method was used. The remaining amortization period at June 30, 2023, was twenty-one years. NOTE 11 – REVENUE LIMITATIONS IMPOSED BY CALIFORNIA PROPOSITION 218 Proposition 218, which was approved by voters in November 1996, regulates the City’s ability to impose, increase and extend taxes, assessments, and fees. Any new, increase, or extended taxes, assessments, and fees subject to the provisions of Proposition 218, require voter approval before they can be implemented. Additionally, Proposition 218 provides that these taxes, assessments, and fees are subject to the voter initiative process and may be rescinded in the future years by the voters. NOTE 12 – RISK MANAGEMENT A. Description of Self-Insurance Pool Pursuant to Joint Powers Agreement The City of Atascadero is a member of the California Joint Powers Insurance Authority (Authority). The Authority is composed of 124 California public entities and is organized under a joint powers’ agreement pursuant to California Government Code §6500 et seq. The purpose of the Authority is to arrange and administer programs for the pooling of self-insured losses, to purchase excess insurance or reinsurance, and to arrange for group purchased insurance for property and other lines of coverage. The California JPIA began covering claims of its members in 1978. Each member government has an elected official as its representative on the Board of Directors. The Board operates through a nine-member Executive Committee. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 68 NOTE 12 – RISK MANAGEMENT (continued) B. Primary Self-Insurance Programs of the Authority Each member pays an annual contribution at the beginning of the coverage period. A retrospective adjustment is then conducted annually thereafter, for coverage years 2012-13 and prior. Coverage years 2013-14 and forward are not subject to routine annual retrospective adjustment. The total funding requirement for primary self-insurance programs is based on an actuarial analysis. Costs are allocated to individual agencies based on payroll and claims history, relative to other members of the risk-sharing pool. Primary Liability Program Claims are pooled separately between police and general government exposures. (1) The payroll of each member is evaluated relative to the payroll of other members. A variable credibility factor is determined for each member, which establishes the weight applied to payroll and the weight applied to losses within the formula. (2) The first layer of losses includes incurred costs up to $100,000 for each occurrence and is evaluated as a percentage of the pool’s total incurred costs within the first layer. (3) The second layer of losses includes incurred costs from $100,000 to $500,000 for each occurrence and is evaluated as a percentage of the pool’s total incurred costs within the second layer. (4) Incurred costs from $500,000 to $50 million, are distributed based on the outcome of cost allocation within the first and second loss layers. The overall coverage limit for each member, including all layers of coverage, is $50 million per occurrence. Subsidence losses also have a $50 million per occurrence limit. The coverage structure is composed of a combination of pooled self-insurance, reinsurance, and excess insurance. Additional information concerning the coverage structure is available on the Authority’s website: https://cjpia.org/coverage/risk-sharing-pools/. Primary Workers’ Compensation Program Claims are pooled separately between public safety (police and fire) and general government exposures. (1) The payroll of each member is evaluated relative to the payroll of other members. A variable credibility factor is determined for each member, which establishes the weight applied to payroll and the weight applied to losses within the formula. (2) The first layer of losses includes incurred costs up to $75,000 for each occurrence and is evaluated as a percentage of the pool’s total incurred costs within the first layer. (3) The second layer of losses includes incurred costs from $75,000 to $200,000 for each occurrence and is evaluated as a percentage of the pool’s total incurred costs within the second layer. (4) Incurred costs from $200,000 to statutory limits are distributed based on the outcome of cost allocation within the first and second loss layers. For 2022-23 the Authority’s pooled retention is $1 million per occurrence, with reinsurance to statutory limits under California Workers’ Compensation Law. Employer’s Liability losses are pooled among members to $1 million. Coverage from $1 million to $5 million is purchased through reinsurance policies, and Employer’s Liability losses from $5 million to $10 million are pooled among members. C. Purchased Insurance Pollution Legal Liability Insurance The City of Atascadero participates in the pollution legal liability insurance program which is available through the Authority. The policy covers sudden and gradual pollution of scheduled property, streets, and storm drains owned by the City of Atascadero. Coverage is on a claims-made basis. There is a $250,000 deductible. The Authority has an aggregate limit of $20 million. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 69 NOTE 12 – RISK MANAGEMENT (continued) C. Purchased Insurance (continued) Property Insurance The City of Atascadero participates in the all-risk property protection program of the Authority. This insurance protection is underwritten by several insurance companies. City of Atascadero property is currently insured according to a schedule of covered property submitted by the City of Atascadero to the Authority. City of Atascadero property currently has all-risk property insurance protection in the amount of $95,101,426. There is a $10,000 deductible per occurrence except for non-emergency vehicle insurance which has a $2,500 deductible. Crime Insurance The City of Atascadero purchases crime insurance coverage in the amount of $1,000,000 with a $2,500 deductible. The fidelity coverage is provided through the Authority. Special Event Tenant User Liability Insurance The City of Atascadero further protects against liability damages by requiring tenant users of certain property to purchase low-cost tenant user liability insurance for certain activities on agency property. The insurance premium is paid by the tenant user and is paid to the City of Atascadero according to a schedule. The City of Atascadero then pays for the insurance. The insurance is facilitated by the Authority. D. Adequacy of Protection During the past three fiscal years, none of the above programs of protection experienced settlements or judgments that exceeded pooled or insured coverage. There were also no significant reductions in pooled or insured liability coverage in 2022-23. E. Unemployment The City is fully self-insured for unemployment claims. F. Self Insurance The City retains the risk for losses incurred prior to joining the Authority. Several member agencies of the now dissolved Central Coast Cities Self-Insurance Fund continue to participate in a non-risk sharing arrangement for claims management and the purchase of excess insurance for claims prior to joining the Authority. Losses are debited and investment income is credited to specific member accounts. The City has not incurred any losses in excess of insurance coverage. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 70 NOTE 12 – RISK MANAGEMENT (continued) F. Self Insurance (continued) Workers' Compensation Assets on deposit 194,393$ Estimated liability for reported claims and settlement expenses (32,752) Assets in excess of (less than) liabilities 161,641$ Workers' Compensation Deposits June 30, 2021 47,908$ Claim payments and related expenditures (35,254) Decrease in estimated claims liability June 30, 2022 4,684 Deposits and interest earnings 396 Deposits (unpaid claims liability) June 30, 2022 17,734 Claim payments and related expenditures 67,260 Decrease in estimated claims liability June 30, 2023 73,814 Deposits and interest earnings 2,833 Deposits (unpaid claims liability) June 30, 2023 161,641$ Self-insurance activity as of and for the fiscal year ended June 30, 2023, is summarized as follows: Changes in the balances of claim liabilities during the past two fiscal years are as follows: CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 71 NOTE 13 – CONTINGENCIES AND COMMITMENTS The City has received state and federal funds for specific purposes that are subject to review and audit by the grantor agencies. Although such audits could generate expenditure disallowances under terms of the grants, it is believed that any required reimbursements will not be material. According to the City Attorney, there are two potentially significant issues pending. Estate of Douglas Breeze and City of Atascadero (filed January 18, 2022) SSC Case No. 34-2022-80003799 The City contracted with Regional Government Services (“RGS”) for the services of Mr. Doug Breeze for a few months in 2014. CalPERS determined that Mr. Breeze was a City employee. As a result, Mr. Breeze and the City were directed to make PERS contributions. RSG is providing the City's defense and indemnity in this matter; the City is one of several other public entities involved with CalPERS's determination. A determination by the trial court upholding CalPERS's determination is currently on appeal. Veronica Ulloa-Nevarez v. City of Atascadero (not yet filed). This is a matter regarding the California Voting Rights Act ("CVRA"). An individual alleged that the City's at-large elections violates the CVRA. No litigation is yet filed; the matter is currently suspended in accordance with the terms of a tolling agreement between the City and claimant. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 72 NOTE 13 – CONTINGENCIES AND COMMITMENTS (continued) Construction and other significant commitments as of June 30, 2023, including encumbrances outstanding at fiscal year-end, are as follows: 100 General Fund 2,379,782$ 201 Community Facilities District Fund 2,734 202 Apple Valley Street & Storm Drain Assessment District Fund 1,841 203 Apple Valley Landscape & Lighting Assessment District Fund 2,366 204 Las Lomas Street & Storm Drain Assessment District Fund 1,841 205 Las Lomas Landscape & Lighting Assessment District Fund 2,366 206 De Anza Street & Storm Drain Assessment District Fund 1,841 207 De Anza Landscape & Lighting Assessment District Fund 2,366 240 Community Development Block Grant Fund 3,355 265 Local Transportation Fund 6,550,017 281 Circulation System Fees Fund 8,189 284 Law Enforcement Facilities Fees Fund 110,837 287 Parkland Facilities Fees Fund 24,662 527 Wastewater Fund 102,780 680 Vehicle and Equipment Replacement Fund 503,174 690 Technology Fund 54,950 Total 9,753,101$ Capital Commitments Fiscal Year 2022/2023 CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 73 NOTE 14 – NET POSITION GASB Statement No. 63 requires that the difference between assets added to the deferred outflows of resources and liabilities added to the deferred inflows of resources be reported as net position. Net position is classified as either net investment in capital assets, restricted, or unrestricted. Net position that is net investment in capital assets consists of capital assets, net of accumulated depreciation, and reduced by the outstanding principal of related debt. Restricted net position is the portion of net position that has external constraints placed on it by creditors, grantors, contributors, laws, or regulations of other governments, or through constitutional provisions or enabling legislation. Unrestricted net position consists of net position that does not meet the definition of net investment in capital assets or restricted net position. Net Position Net Position is the excess of all the City’s assets and deferred outflows of resources over all its liabilities and deferred inflows of resources, regardless of fund. Net Position is divided into three captions under GASB Statement No. 34. These captions apply only to Net Position, which is determined only at the government-wide level, and are described below: Net Investment in Capital Assets describes the portion of Net Position which is represented by the current net book value of the City’s capital assets, less the outstanding balance of any debt issued to finance these assets. Restricted describes the portion of Net Position which is restricted as to use by the terms and conditions of agreements with outside parties, governmental regulations, laws, or other restrictions which the City cannot unilaterally alter. These principally include fees received for use on economic development, capital projects, debt service requirements, and redevelopment funds restricted to low- and moderate-income purposes. Restricted Net Position includes $41,657,452 restricted by enabling legislation. Unrestricted describes the portion of Net Position which is not restricted as to use. NOTE 15 – SUCCESSOR AGENCY TRUST FOR ASSETS OF FORMER REDEVELOPMENT AGENCY On December 29, 2011, the California Supreme Court upheld Assembly Bill 1x 26 (“the Bill”) that provides for the dissolution of all redevelopment agencies in the State of California. This action impacted the reporting entity of the City of Atascadero, which had previously reported a redevelopment agency within the reporting entity of the City as a blended component unit. The Bill provides that, upon dissolution of a redevelopment agency, either the city or another unit of local government will agree to serve as the “successor agency” to hold the assets until they are distributed to other units of state and local government. On January 10, 2012, the City Council elected to become the Successor Agency for the former redevelopment agency in accordance with the Bill as part of City Resolution Number 2012-002. After enactment of the law, which occurred on June 28, 2011, redevelopment agencies in the State of California cannot enter into new projects, obligations or commitments. Subject to the control of the oversight board, remaining assets can only be used to pay enforceable obligations in existence at the date of dissolution (including the completion of any unfinished projects that were subject to legally enforceable contractual commitments). CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 74 NOTE 15 – SUCCESSOR AGENCY TRUST FOR ASSETS OF FORMER REDEVELOPMENT AGENCY (continued) Successor agencies are only allocated revenue in the amount that is necessary to pay the estimated annual installment payments on enforceable obligations of the former redevelopment agency until all enforceable obligations of the prior redevelopment agency have been paid in full and all assets have been liquidated. The Bill directs the State Controller of the State of California to review the propriety of any transfers of assets between redevelopment agencies and other public bodies that occurred after January 1, 2011. If the public body that received such transfers is not contractually committed to a third party for the expenditure or encumbrance of those assets, the State Controller is required to order the available assets to be transferred to the public body designated as the successor agency by the Bill. Management believes, in consultation with legal counsel, that the obligations of the former redevelopment agency due to the City are valid enforceable obligations payable by the successor agency trust under the requirements of the Bill. In accordance with the timeline set forth in the Bill (as modified by the California Supreme Court on December 29, 2011), all redevelopment agencies in the State of California were dissolved and ceased to operate as a legal entity as of February 1, 2012. The assets and activities of the dissolved redevelopment agency are reported in a fiduciary fund (private purpose trust fund) in the financial statements of the City. The transfer of the assets and liabilities of the former redevelopment agency as of February 1, 2012 (effectively the same date as January 31, 2012), from governmental funds of the City to fiduciary funds, was reported in the governmental funds as an extraordinary loss in the governmental fund financial statements in fiscal year 2011-2012. The receipt of these assets and liabilities as of January 31, 2012, was reported in the private purpose trust fund as an extraordinary gain in the fiscal year 2011-2012. The Successor Agency received a Finding of Completion (FOC) from the State Department of Finance on March 8, 2013. In order to be eligible for the FOC, the Successor Agency had to meet the following requirements: • pay the housing fund balance as determined by Due Diligence Review; • pay the non-housing fund balance as determined by Due Diligence Review; and • pay the balance of any outstanding pass-through obligations and residual payments. A. Notes Receivable The Housing Successor Agency is holding $200,000 in Notes Receivable as part of the Downtown Stimulus Program. The former Redevelopment Agency used the Downtown Stimulus Program as a tool to encourage investors to provide affordable housing in the downtown area. Neither the principal nor interest shall be payable under the Note for the term of 55 years; or until such time as the Program Participant sells or otherwise transfers the site. The Notes will be forgiven in full after the period of 55 years. B. Capital Assets The remainder of the capital assets of the Successor Agency were disposed of during fiscal year 2017-2018. No capital asset activity was recorded in the Private Purpose Trust Funds for the fiscal year ended June 30, 2023. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 75 NOTE 15 – SUCCESSOR AGENCY TRUST FOR ASSETS OF FORMER REDEVELOPMENT AGENCY (continued) C. Loans Payable Written-Off The City General Fund loaned three separate advances to the former Redevelopment Agency. The total of these three loans, $1,375,175, was a liability of the Successor Agency through fiscal year 2019-2020. AB 1484 sets forth the criteria for repayment of these loans: • California Department of Finance must issue the Successor Agency a Finding of Completion • Oversight Board must find that the loans were for legitimate redevelopment purposes • Repayment is subject to certain restrictions, including a reduction of the interest rate to the LAIF rate, restrictions on the timing and amount of annual repayments, and a requirement that 20% of the repayment amount must be deposited into a restricted housing set-aside fund • Loan repayments shall not be made prior to the 2013-14 fiscal year. On September 22, 2015, Governor Brown signed Senate Bill 107, a budget bill including, among other things, a modification to Health and Safety Code Section 34191.4(b), concerning the manner in which interest on the loans is to be calculated and limitations on annual loan payment amounts: • All outstanding interest as of the date of dissolution is to be recalculated from the date of origination of the loan as approved by the Redevelopment Agency on a quarterly basis, at a simple interest rate of 3 percent. • The amount of property tax available to fund loan repayments is one-half of the difference between the Redevelopment Property Tax Trust Fund (RPTTF) funds available in the current fiscal year and the RPTTF payments to the affected taxing entities in fiscal year 2012-13. Loan repayment was requested on the Required Obligation Payment Schedule 2019-20. The State Department of Finance denied the request to begin repayment of the loans. These loans were written-off as uncollectable during the 2020-2021 fiscal year. D. Bond Reimbursement Agreement Payable In September of 2010, the City issued $16,010,000 in bonds on behalf of the Redevelopment Agency in order for the Agency to achieve an overall lower debt service cost. At the time of the bond issuance, a reimbursement agreement was entered into whereby the City advanced the Agency the proceeds of the bond and the Agency is required to make annual payments to the City in the amount of the debt service on the bonds. Annual principal payments on the advance are required between fiscal years 2015 and 2041, at interest rates ranging from 3.0% to 5.0%. See Note 8B – Long Term Liabilities, 2010 Lease Revenue Bonds, for additional information. E. 2004 Redevelopment Agency Tax Allocation Bonds The former Atascadero Community Redevelopment Agency (Agency) issued $12,490,000 in Tax Allocation bonds for improvements to the downtown core. These bonds mature between fiscal years 2011 and 2035, at interest rates ranging from 3.00% to 5.00%. Since the Agency was dissolved effective February 1, 2012, the bonds are now a liability of the Successor Agency. The liability is now reflected on the private purpose trust financial statements of the Successor Agency and is no longer found on the financial statements of the City and its component unit. The bonds will be repaid with the Successor Agency’s Tax Allocation Revenues. CITY OF ATASCADERO NOTES TO THE BASIC FINANCIAL STATEMENTS June 30, 2023 76 NOTE 15 – SUCCESSOR AGENCY TRUST FOR ASSETS OF FORMER REDEVELOPMENT AGENCY (continued) E. 2004 Redevelopment Agency Tax Allocation Bonds (continued) The following is a summary of principal and interest payments to be made in future fiscal years: Fiscal Year Ending June 30,Principal Interest 2024 $ 475,000 $ 361,634 2025 500,000 337,869 2026 525,000 312,884 2027 550,000 286,681 2028 575,000 259,259 2029-2033 3,340,000 828,374 2034-2035 1,580,000 80,000 $ 7,545,000 $ 2,466,701 2004 Redevelopment Agency Tax Allocation Bonds NOTE 16 – American Rescue Plan Act The Federal American Rescue Plan Act (ARPA) was signed into law on March 11, 2021, to provide additional financial relief in the wake of the COVID-19 pandemic. ARPA includes a significant amount of “Coronavirus State and Local Fiscal Recovery Funds” (SLFRF) for state and local governments to use over a period of several years. The funds were distributed in two equal installments, or “tranches”. Atascadero received the first distribution in July 2021 and the second in July 2022. Smaller cities like Atascadero that are not considered “metropolitan”, are referred to as non-entitlement units of local government, or “NEUs”. Funds may be used for specific purposes as designated in the U.S. Department of Treasury’s Final Rule. The Final Rule offers a standard allowance for revenue loss of up to $10 million. Recipients that select the standard allowance may use the funds for government services. The City used the standard deduction for revenue loss, and those funds were used for general government purposes. The City’s total ARPA allocation is $7,194,580, half of which was received and used last fiscal year and the other half was received and used in fiscal year 2022-2023. REQUIRED SUPPLEMENTARY INFORMATION CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - SUMMARY BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Secured and unsecured property taxes 11,590,490$ 11,590,490$ 12,066,128$ 475,638$ Taxes based on sales and use 12,799,950 12,799,950 14,497,346 1,697,396 Franchise tax 1,255,480 1,255,480 1,381,290 125,810 Other taxes 1,859,450 1,859,450 2,551,264 691,814 Licenses and permits 700,550 700,550 1,088,633 388,083 Intergovernmental revenues: Motor vehicle in-lieu and related payments 22,710 22,710 31,551 8,841 American Rescue Plan Act Funds- COVID-19 - 3,597,290 3,597,290 - Grants 19,240 504,950 485,149 (19,801) Other governmental revenues 188,830 188,830 219,073 30,243 Charges for services: Public safety 469,340 609,960 640,911 30,951 Development 614,670 679,850 935,291 255,441 Recreation, parks, pavilion, and zoo 924,000 961,340 1,236,078 274,738 Other services 60,200 60,200 131,371 71,171 Fines and forfeitures 61,600 61,600 78,628 17,028 Use of money and property 83,740 83,740 513,543 429,803 Other revenues 1,377,100 1,429,870 1,547,809 117,939 Total revenues 32,027,350 36,406,260 41,001,355 4,595,095 Expenditures: Employee services 20,631,090 20,574,310 20,148,481 425,829 Operating supplies and services 7,749,150 8,065,710 7,720,263 345,447 Special purchases, projects, and community funding 2,495,120 11,174,130 8,911,604 2,262,526 Capital outlay 8,352,470 7,068,630 4,134,346 2,934,284 Total expenditures 39,227,830 46,882,780 40,914,694 5,968,086 Excess of revenues over (under) expenditures (7,200,480) (10,476,520) 86,661 10,563,181 Budget Variance with Final Budget Positive (Negative) 77 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - SUMMARY (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Other Financing Sources (Uses): Transfers in 746,460$ 746,460$ 743,353$ (3,107)$ Transfers out (457,310) (5,153,710) (4,975,849) 177,861 Total other financing sources and uses 289,150 (4,407,250) (4,232,496) 174,754 (6,911,330)$ (14,883,770)$ (4,145,835) 10,737,935$ Fund balance - June 30, 2022 25,332,470 Fund balance - June 30, 2023 21,186,635$ Excess of revenue and other sources over (under) expenditures and other uses Budget Variance with Final Budget Positive (Negative) 78 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - DETAIL BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Taxes: Property taxes: Secured property tax 7,201,490$ 7,201,490$ 7,495,637$ 294,147$ Property tax in lieu of VLF 3,417,530 3,417,530 3,504,056 86,526 Unsecured property taxes 273,970 273,970 282,171 8,201 Supplemental property taxes 170,000 170,000 270,840 100,840 527,500 527,500 529,714 2,214 Prior year secured and unsecured - - (15,996) (15,996) Property tax penalties and interest - - (294) (294) Taxes based on sales: Sales and use taxes 4,654,950 4,654,950 4,964,533 309,583 Measure D-20 sales tax 5,430,000 5,430,000 6,354,899 924,899 Measure F-14 sales tax 2,715,000 2,715,000 3,177,914 462,914 Transient occupancy tax 1,490,830 1,490,830 2,156,988 666,158 Franchise taxes: Cable television franchise fees 260,510 260,510 249,622 (10,888) Electricity franchise fees 303,000 303,000 338,733 35,733 Garbage disposal franchise fees 525,300 525,300 570,178 44,878 Landfill franchise fees 15,160 15,160 19,813 4,653 Gas franchise fees 83,950 83,950 122,623 38,673 Wastewater franchise fees 67,560 67,560 80,321 12,761 Business licenses 177,140 177,140 179,253 2,113 Property transfer tax 160,000 160,000 167,590 7,590 Cannabis business tax 31,480 31,480 47,433 15,953 Total Taxes 27,505,370 27,505,370 30,496,028 2,990,658 Licenses and Permits: Construction permits 598,710 598,710 903,378 304,668 Grading and drainage permits 44,240 44,240 36,176 (8,064) Encroachment permits 47,190 47,190 138,465 91,275 Tree application fees 8,410 8,410 4,872 (3,538) Planning inspections 2,000 2,000 1,242 (758) Developer Reimbursements- Assessment Districts - - 4,500 4,500 Total Licenses and Permits 700,550 700,550 1,088,633 388,083 Budget Variance with Final Budget Positive (Negative) Redevelopment Agency Dissolution- residual distribution 79 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - DETAIL (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues (continued): Intergovernmental Revenues: Motor vehicle in-lieu 22,710$ 22,710$ 31,551$ 8,841$ American Rescue Plan Act Funds- COVID-19 - 3,597,290 3,597,290 - Homeowners' tax relief 46,330 46,330 43,922 (2,408) State mandated costs 5,000 5,000 32,576 27,576 P.O.S.T. reimbursement 12,000 12,000 16,755 4,755 School Resources Officer 80,000 80,000 80,000 - County COVID-19 Vaccine Assistance - - 324 324 45,500 45,500 45,496 (4) Grants: Assistance to Fire Fighters Grant - 1,900 1,894 (6) Office of Traffic Safety-2022 STEP Grant-Traffic - 46,310 46,310 - Office of Traffic Safety-2022 DUI Police Grant - 2,470 2,462 (8) Fire Safe Council - 2023 Fuel Management - 28,180 28,180 - Fire Safe Council - 2024 Fuel Management - 1,890 1,888 (2) Fire Safe Council - 2023 Wildfire Consultations - 5,450 5,750 300 - 5,140 5,133 (7) SB 1383 Cal Recycle Local Assistance Grant - 22,430 22,430 - HCD- Housing Element & Inclusionary Policy 19,240 19,240 4,989 (14,251) HCD- LEAP Mixed Use Develop Standards - 20,350 20,343 (7) HCD- REAP Jurisdictional Zoning Grant - 67,610 67,607 (3) HCD- REAP Regional ADU's - 30,740 35,577 4,837 2018 Parks Bond Act Grant-Lake Park Pier - 53,240 42,586 (10,654) Broadband Strategic Plan Grant - 200,000 200,000 - Total Intergovernmental Revenues 230,780 4,313,780 4,333,063 19,283 Budget Variance with Final Budget Positive (Negative) Settlement agreement- SB 1090 Essential Services Mitigation Funds (PG&E DCPP) Board of State and Community Corrections- Police Grant 2016/17 80 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - DETAIL (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues (continued): Charges for Services: Public safety: First response charges 130,480$ 130,480$ 134,615$ 4,135$ Weed abatement services 37,780 69,240 79,615 10,375 Mutual Aid-Fire 250,000 359,160 387,253 28,093 Police/Fire false alarms 6,320 6,320 1,428 (4,892) Castlerock Communication Site Lease 16,430 16,430 15,291 (1,139) Fingerprints 5,560 5,560 1,190 (4,370) Vehicle release fees 16,160 16,160 16,016 (144) Other public safety services 6,610 6,610 5,503 (1,107) Development: Zoning fees 44,960 44,960 55,068 10,108 Subdivision fees- Planning 33,500 33,500 46,350 12,850 Subdivision fees- Public Works 2,030 2,030 34,944 32,914 Appeals 1,270 1,270 4,427 3,157 Assessment district formations/annexations - - 1,360 1,360 Planning review 47,190 47,190 73,032 25,842 Building plan check fees 294,930 360,110 431,663 71,553 Public Works plan check fees and inspections 129,770 129,770 116,352 (13,418) Stormwater permit compliance inspection 5,000 5,000 3,130 (1,870) Fire plan check and inspection fees 52,770 52,770 140,233 87,463 Other development fees 3,250 3,250 28,732 25,482 Recreation: Advertising 3,980 3,980 3,450 (530) Adult sports 39,000 39,000 22,844 (16,156) Youth sports 65,000 65,000 62,899 (2,101) Classes 118,000 118,000 123,770 5,770 Special events -promotions 32,000 48,410 48,418 8 Special events 30,000 39,010 53,164 14,154 Teen Center membership 1,200 1,200 5,822 4,622 Budget Variance with Final Budget Positive (Negative) 81 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - DETAIL (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues (continued): Charges for Services (continued): Rentals and concessions: Pavilion facility rentals 121,870$ 121,870$ 140,902$ 19,032$ Other Pavilion rents and concessions 6,740 6,740 1 (6,739) Colony Park Community Center rentals 16,600 16,600 29,551 12,951 Zoo Event Center rental - - 549 549 Outdoor court rentals - - 1,095 1,095 Park charges 26,160 26,160 48,353 22,193 Zoo: Zoo admissions 314,260 314,260 412,480 98,220 Zoo educational programs 2,050 2,050 59,489 57,439 Zoo gift shop 112,140 124,060 175,780 51,720 Special events- Zoo 35,000 35,000 47,511 12,511 Administrative: Copy and mailing fees 7,510 7,510 6,928 (582) Document imaging fee 16,810 16,810 7,705 (9,105) Technology surcharge - - 71,869 71,869 Business license application fees 35,880 35,880 44,869 8,989 Total Charges for Services 2,068,210 2,311,350 2,943,651 632,301 Fines and Forfeitures: Motor vehicle fines 42,000 42,000 20,230 (21,770) Misdemeanor and other minor fines 3,440 3,440 343 (3,097) Parking fines 3,000 3,000 1,920 (1,080) Code enforcement and fire fines 4,800 4,800 570 (4,230) Business license penalties 7,960 7,960 16,212 8,252 Other penalties 400 400 39,353 38,953 Total Fines and Forfeitures 61,600 61,600 78,628 17,028 Use of Money and Property: Interest 56,000 56,000 491,163 435,163 Adjustment to fair value-GASB 31 - - (16,941) (16,941) Lease Revenue- 2010 Bonds 5,000 5,000 - (5,000) Variance with Final Budget Positive (Negative) Budget 82 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - DETAIL (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues (continued): Use of Money and Property (continued): Interest on Measure F-14 Funds 22,740$ 22,740$ 59,127$ 36,387$ Measure F-14 Funds adjustment to fair value - - (19,806) (19,806) Total Use of Money and Property 83,740 83,740 513,543 429,803 Other Revenues: Interfund administrative charges General overhead charges 474,680 474,680 474,680 - Staffing charges for other funds 661,710 661,710 663,620 1,910 Staffing charges for capital projects 137,790 137,790 183,735 45,945 Staffing charges for CDBG administration - - 9,309 9,309 Administrative charges- Third Parties 3,080 3,080 9,310 6,230 Administrative charges- Successor Agency 50,480 50,480 51,570 1,090 Workers' compensation reimbursement 6,520 6,520 9,618 3,098 Miscellaneous revenue 18,340 17,670 42,314 24,644 Donations: Police - 9,640 9,652 12 Fire - 6,730 6,726 (4) Recreation - 440 937 497 Parks - 3,500 3,500 - Other donations - 29,360 27,906 (1,454) Friends of Zoo Donations: Memberships 23,000 23,000 49,610 26,610 Other Zoo donations 1,500 5,270 5,322 52 Total Other Revenues 1,377,100 1,429,870 1,547,809 117,939 Total Revenues 32,027,350 36,406,260 41,001,355 4,595,095 Variance with Final Budget Positive (Negative) Budget 83 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - DETAIL (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Expenditures: City Council: Salaries and benefits 77,730$ 76,460$ 76,253$ 207$ Office expense 200 200 89 111 Advertising 820 820 - 820 Computer maintenance and replacement 14,050 14,050 14,050 - Occupancy 83,190 83,190 83,190 - Communications 430 430 198 232 Operating supplies 3,890 3,890 1,754 2,136 Vehicle and equipment operating costs 620 620 288 332 Contract services 37,970 37,970 36,000 1,970 Professional development 24,920 24,920 19,597 5,323 Community outreach 53,590 53,590 32,748 20,842 LAFCO contribution 19,770 19,770 17,920 1,850 Special projects and community funding: Essentialism Evaluation 60,000 60,000 - 60,000 Total City Council 377,180 375,910 282,087 93,823 City Clerk: Office expense 660 660 23 637 Advertising 5,520 1,430 1,427 3 Contract services 6,220 6,220 3,226 2,994 Professional development 6,510 1,220 904 316 Municipal election 40,810 50,190 50,182 8 Total City Clerk 59,720 59,720 55,762 3,958 City Treasurer: Salaries and benefits 5,740 6,090 6,079 11 Contract services 11,570 12,830 12,830 - Total City Treasurer 17,310 18,920 18,909 11 Budget Variance with Final Budget Positive (Negative) 84 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - DETAIL (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Expenditures (continued): City Attorney: Office expense 80$ 80$ -$ 80$ Occupancy 6,030 6,030 6,030 - Communications 80 80 36 44 Contract services 296,520 304,100 136,280 167,820 Special projects and community funding: Special litigation costs - 127,420 127,408 12 Total City Attorney 302,710 437,710 269,754 167,956 City Manager: Salaries and benefits 1,305,950 1,295,010 1,294,973 37 Office expense 7,830 6,320 6,312 8 Computer maintenance and replacement 80,180 80,080 80,076 4 Insurance 26,630 28,220 28,217 3 Occupancy 57,040 57,040 57,040 - Communications 2,270 2,640 2,640 - Operating supplies 10,420 3,270 3,259 11 Vehicle and equipment operating costs 6,600 3,970 3,963 7 Contract services 41,670 7,190 7,184 6 Professional development 23,510 17,910 17,899 11 Citywide training 7,280 1,500 1,499 1 Recruitment 520 2,600 2,595 5 Employee development 1,710 2,030 2,028 2 Contingency 100,000 38,500 - 38,500 Special projects and community funding: Grant assessement and writing 35,000 35,000 - 35,000 Staff and Brand Development - 35,000 - 35,000 Senate Bill 1383 consulting services - 22,430 22,430 - Opportunities Fund 70,000 70,000 - 70,000 Budget Variance with Final Budget Positive (Negative) 85 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - DETAIL (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Expenditures (continued): City Manager (continued): Capital Outlay: Computer- new -$ 1,570$ 1,565$ 5$ Total City Manager 1,776,610 1,710,280 1,531,680 178,600 Promotions, Marketing and Outreach Salaries and benefits - 210 201 9 Office expense 5,100 8,410 8,402 8 Advertising 82,100 71,390 71,379 11 Communications 500 - - - Operating supplies 54,300 55,020 55,010 10 Vehicle and equipment operating costs 550 640 635 5 Contract services 79,200 109,650 109,693 (43) Professional development 930 840 834 6 Total Promotions, Marketing and Outreach 222,680 246,160 246,154 6 Administrative Services: Salaries and benefits 977,730 971,440 917,919 53,521 Office expense 14,740 16,820 16,818 2 Advertising 500 500 475 25 Computer maintenance and replacement 96,840 97,100 97,093 7 Insurance 27,660 29,370 29,364 6 Occupancy 78,050 78,050 77,950 100 Communications 1,020 1,020 619 401 Operating supplies 300 300 111 189 Vehicle and equipment operating costs 3,600 3,610 3,605 5 Contract services 175,600 194,170 194,170 - Professional development 6,650 1,900 1,020 880 Recruitment - 1,140 1,138 2 Contingency 5,000 5,000 - 5,000 Special purchases, projects, and studies: Office tables and furniture - 4,000 - 4,000 Budget Variance with Final Budget Positive (Negative) 86 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - DETAIL (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Expenditures (continued): Administrative Services (continued): Capital Outlay: Credit card acceptance program 20,000$ 20,000$ 6,350$ 13,650$ Total Administrative Services 1,407,690 1,424,420 1,346,632 77,788 Police: Salaries and benefits 8,187,170 8,036,210 7,838,987 197,223 Office expense 13,700 20,960 20,954 6 Computer maintenance and replacement 491,680 506,750 506,753 (3) Insurance 260,910 277,120 277,117 3 Occupancy 58,370 77,460 77,459 1 Utilities 47,140 61,300 61,296 4 Communications 36,850 37,630 37,630 - Operating supplies 24,960 190,350 190,345 5 Vehicle and equipment operating costs 477,760 505,460 505,452 8 Contract services 776,850 561,790 512,421 49,369 Professional development 18,780 26,480 26,474 6 Recruitment 11,200 54,540 54,539 1 Contingency 10,000 10,000 - 10,000 Special purchases, projects, and studies: Desks - 2,100 2,096 4 Small printers - 7,800 7,800 - Radar equipment - 6,710 6,704 6 Scanner - 360 359 1 Contracted dispatch services - 153,740 153,738 2 159,940 159,940 159,940 - - 2,800 2,800 - Capital Outlay: - 119,750 119,744 6 CAD/RMS software 466,990 347,240 137,778 209,462 Video camera - 14,870 14,861 9 11,042,300 11,181,360 10,715,247 466,113 Budget Variance with Final Budget Positive (Negative) Cash transfer to Vehicle and Equipment Replacement fund for Equipment Replacement reserve deficit Capital transfer to Technology Fund for Mark43 annual maintenance Cash transfer to Vehicle and Equipment Replacement fund for Generator at Pine Mountain Repeater site 87 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - DETAIL (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Expenditures (continued): Police Grants: Salaries and benefits -$ 2,870$ 2,859$ 11$ Operating supplies 1,800 4,730 4,729 1 Contract services 2,320 5,450 5,448 2 Professional development 34,380 44,180 40,062 4,118 Capital Outlay: Traffic Records Module Software - 46,310 46,310 - 38,500 103,540 99,408 4,132 Total Police 11,080,800 11,284,900 10,814,655 470,245 Fire: Salaries and benefits 4,706,130 4,796,480 4,793,999 2,481 Office expense 3,750 2,520 2,510 10 Computer maintenance and replacement 247,500 239,360 239,359 1 Insurance 127,920 132,810 132,811 (1) Occupancy 84,570 81,990 81,983 7 Utilities 24,500 24,780 39,272 (14,492) Communications 16,650 9,620 9,615 5 Operating supplies 62,950 62,950 63,572 (622) 504,250 504,250 544,813 (40,563) Contract services 21,550 21,000 20,992 8 Professional development 23,450 23,450 26,377 (2,927) Recruitment 3,500 660 652 8 Contingency 10,000 10,000 - 10,000 Special purchases, projects, and studies: Bed/mattresses - - 1,189 (1,189) Washing machine/dryer - - 1,631 (1,631) Wildland portective gear - 18,900 - 18,900 - 10,600 11,084 (484) Comprehensive evacuation plan 13,220 13,220 - 13,220 Contracted dispatch services - - 31,541 (31,541) 159,940 583,580 583,580 - EKG/heart monitors equipment repairs Budget Variance with Final Budget Positive (Negative) Vehicle and equipment operating costs Cash contribution to Vehicle and Equipment Replacement Fund for replacement vehicle 88 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - DETAIL (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Expenditures (continued): Fire (continued): Special purchases, projects, and studies (continued): -$ 3,500,000$ 3,500,000$ -$ Capital outlay: 180,000 180,000 180,215 (215) - 69,150 - 69,150 1,500,000 - - - 7,689,880 10,285,320 10,265,195 20,125 Mutual Aid Program: Salaries and benefits 142,240 254,590 254,587 3 Operating supplies 15,000 17,450 17,444 6 Vehicle and equipment operating costs 5,200 - - - 162,440 272,040 272,031 9 Weed Abatement and Other Fire Programs: Salaries and benefits - 3,100 3,108 (8) Office expense 900 6,080 6,075 5 Advertising 400 - - - Operating supplies - 6,770 6,763 7 Contract services 72,880 131,940 131,924 16 Special purchases, projects, and studies: COVID-19 emergency protective measures - 1,900 2,105 (205) 74,180 149,790 149,975 (185) Total Fire 7,926,500 10,707,150 10,687,201 19,949 Community Development: Salaries and benefits 1,634,980 1,584,900 1,584,870 30 Office expense 11,680 21,770 21,763 7 Advertising 5,000 5,140 5,137 3 Computer maintenance and replacement 166,580 166,570 166,564 6 Insurance 41,680 44,170 44,168 2 Occupancy 87,000 87,000 87,000 - Communications 2,800 5,120 5,110 10 Operating supplies 3,730 1,470 1,461 9 Vehicle and equipment operating costs 15,190 16,420 16,414 6 Radio repeater project Budget Variance with Final Budget Positive (Negative) Automated external defibrillators Cash contribution to Building Maintenance Fund for Fire Station #1 Replacement Fire station #1 rebuild 89 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - DETAIL (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Expenditures (continued): Community Development (continued): Contract services 97,000$ 189,070$ 189,062$ 8$ Professional development 14,830 41,100 41,094 6 Recruitment 600 1,320 1,310 10 Contingency 5,000 5,000 - 5,000 Special purchases, projects, and studies: General Plan update 1,173,090 1,173,090 302,449 870,641 Housing Element and Inclusionary Policy 19,240 19,240 4,989 14,251 LEAP Mixed Use Development Standards - 20,350 20,342 8 - 67,610 67,607 3 - 30,740 30,738 2 Total Community Development 3,278,400 3,480,080 2,590,078 890,002 Central Reception: Salaries and benefits 82,580 77,150 64,471 12,679 Office expense 1,050 890 826 64 Computer maintenance and replacement 20,540 20,540 20,540 - Insurance 2,520 2,670 2,663 7 Occupancy 66,550 66,550 66,550 - Communications 380 380 289 91 Operating supplies 50 60 56 4 Vehicle and equipment operating costs 50 50 - 50 Professional development 250 250 - 250 Recruitment 150 720 1,180 (460) Capital outlay: Scanner/Printer- new 2,000 2,000 - 2,000 Total Central Reception 176,120 171,260 156,575 14,685 Economic and Business Development: Salaries and benefits 161,270 194,580 169,169 25,411 Computer maintenance and replacement 3,460 3,460 3,460 - Occupancy 4,210 4,210 4,210 - Chamber of Commerce 122,400 129,600 129,600 - Business development 21,720 14,520 2,500 12,020 Special purchases, projects, and studies: Economic Development-Downtown - 126,500 126,203 297 Broadband enhancement project 388,110 388,110 200,000 188,110 REAP Jurisdictional Zoning/Subdivision Ordinance Update REAP Regional ADU Accessibility and development Budget Variance with Final Budget Positive (Negative) 90 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - DETAIL (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Expenditures (continued): Economic and Business Development (continued): Special purchases, projects, and studies (continued): Restaurant Development Loan Program -$ 1,000,000$ -$ 1,000,000$ Total Economic and Business Development 701,170 1,860,980 635,142 1,225,838 Recreation: Salaries and benefits 392,730 362,100 338,384 23,716 Office expense 4,550 8,060 7,810 250 Advertising 23,830 21,300 21,218 82 Computer maintenance and replacement 28,530 28,080 28,075 5 Insurance 21,560 26,930 26,922 8 Occupancy 50,400 48,800 48,398 402 Utilities 3,740 4,660 4,651 9 Communications 1,240 760 755 5 Operating supplies 31,760 29,360 22,942 6,418 Vehicle and equipment operating costs 4,310 12,310 3,816 8,494 Contract services 133,100 131,940 125,702 6,238 Professional development 5,000 4,640 4,635 5 Recruitment 700 1,670 1,670 - Contingency 2,500 2,500 - 2,500 Special purchases, projects and studies: Inflatable Movie Screen - 2,200 1,838 362 Event Booth Tents - 5,330 5,330 - Youth scholarships - 440 437 3 Total Recreation 703,950 691,080 642,583 48,497 Community Center: Salaries and benefits 55,320 56,810 56,801 9 Office expense 1,450 880 873 7 Advertising 280 - - - Computer maintenance and replacement 10,620 10,620 10,620 - Insurance 23,400 21,550 21,543 7 Occupancy 145,340 145,340 145,340 - Utilities 48,900 65,830 65,825 5 Communications 2,500 2,700 2,690 10 Operating supplies 13,830 11,360 11,349 11 Vehicle and equipment operating costs 1,400 680 677 3 Variance with Final Budget Positive (Negative) Budget 91 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - DETAIL (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Expenditures (continued): Community Center (continued): Contract services 15,860$ 17,320$ 17,312$ 8$ Professional development 1,050 - - - Recruitment 250 340 332 8 Special purchases, projects and studies: Shade sail replacement 8,650 8,650 - 8,650 Total Community Center 328,850 342,080 333,362 8,718 Pavilion: Salaries and benefits 176,150 171,480 167,060 4,420 Office expense 1,180 340 333 7 Advertising 4,740 4,300 4,296 4 Computer maintenance and replacement 12,230 12,230 12,230 - Insurance 10,020 9,790 9,786 4 Occupancy 57,190 57,190 57,190 - Utilities 27,000 27,810 27,802 8 Communications 3,800 3,290 3,286 4 Operating supplies 7,580 8,990 8,981 9 Vehicle and equipment operating costs 2,740 350 343 7 Contract services 22,390 25,290 25,284 6 Professional development 100 - - - Recruitment 310 520 518 2 Special purchases, projects, and studies: Tables - 9,400 3,980 5,420 Stage - 5,600 - 5,600 Window repairs - 25,000 23,615 1,385 Total Pavilion 325,430 361,580 344,704 16,876 Zoo: Salaries and benefits 888,790 851,500 841,928 9,572 Office expense 1,790 2,110 2,101 9 Advertising 200 - - - Computer maintenance and replacement 52,300 52,120 52,115 5 Insurance 30,860 31,950 31,941 9 Occupancy 47,610 47,480 47,479 1 Utilities 67,400 79,500 79,480 20 Communications 1,320 2,570 2,569 1 Operating supplies 127,680 145,260 145,242 18 Budget Variance with Final Budget Positive (Negative) 92 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - DETAIL (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Expenditures (continued): Zoo (continued): Vehicle and equipment operating costs 5,940$ 10,840$ 10,839$ 1$ Contract services 82,150 90,270 90,260 10 Professional development 14,580 13,150 13,150 - Recruitment 100 480 478 2 Gift shop retail 37,000 57,710 57,705 5 Special purchases, projects, and studies: Animal acquisition - 6,900 6,885 15 HVAC units - 3,180 3,175 5 Water heater - 4,400 4,400 - Capital outlay: Freezer 40,000 40,000 - 40,000 Zoo exhibit improvements - 21,410 21,407 3 Zoo electrical upgrade 30,000 30,000 3,095 26,905 Total Zoo 1,427,720 1,490,830 1,414,249 76,581 Public Works Administration: Salaries and benefits 1,105,660 1,096,010 1,054,463 41,547 Office expense 5,600 5,960 5,952 8 Advertising 250 250 - 250 Computer maintenance and replacement 110,250 100,370 81,756 18,614 Insurance 22,950 24,320 24,320 - Occupancy charges 37,370 37,370 37,370 - Communications 3,400 3,400 2,098 1,302 Operating supplies 16,500 19,060 19,055 5 Vehicle and equipment operating costs 10,340 15,930 15,925 5 Contract services 26,000 26,000 24,261 1,739 Professional development 13,080 13,080 11,249 1,831 Recruitment 500 500 50 450 Contingency 7,000 7,000 - 7,000 Special purchases, projects, and studies: Lake dam inundation mapping study 4,040 4,040 - 4,040 City engineering standards 25,000 25,000 - 25,000 Total Public Works Administration 1,387,940 1,378,290 1,276,499 101,791 Public Works Operations: Salaries and benefits 253,400 262,550 262,532 18 Office expense 2,180 1,350 1,348 2 Computer maintenance and replacement 17,250 17,250 17,250 - Variance with Final Budget Positive (Negative) Budget 93 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - DETAIL (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Expenditures (continued): Public Works Operations (continued): Insurance 7,600$ 7,580$ 7,577$ 3$ Occupancy charges 27,130 29,630 29,630 - Utilities 9,160 11,420 11,411 9 Communications 1,150 1,270 1,265 5 Operating supplies 6,500 2,410 2,406 4 Vehicle and equipment operating costs 8,260 8,610 8,606 4 Contract services 500 280 274 6 Professional development 1,330 380 376 4 Recruitment - 350 343 7 Special purchases, projects, and studies: Corp yard building minor remodel 9,550 9,550 - 9,550 Downtown street tree renewal program 18,650 18,650 9,273 9,377 20,850 20,850 20,850 - Capital Outlay: Radio repeater project 90,000 90,000 79,823 10,177 Total Public Works Operations 473,510 482,130 452,964 29,166 Parks: Salaries and benefits 477,520 474,770 419,838 54,932 Computer maintenance and replacement 10,620 10,620 10,620 - Insurance 19,890 20,510 20,510 - Occupancy 35,270 35,270 35,270 - Utilities 159,000 159,050 159,049 1 Communications 2,150 1,480 1,296 184 Operating supplies 63,540 57,940 55,773 2,167 Vehicle and equipment operating costs 48,080 56,740 56,740 - Contract services 79,750 68,690 64,236 4,454 Professional development 3,500 3,820 3,813 7 Recruitment 900 280 273 7 Special purchases, projects, and studies: Parks repair and replacement 150,000 150,000 - 150,000 Tree trimming and replacement 1,080 1,080 - 1,080 Creek maintenance projects 60,520 60,520 37,062 23,458 Cash contribution to Vehicle and Equipment Replacement Fund for reserve fund deficit Budget Variance with Final Budget Positive (Negative) 94 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - DETAIL (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Expenditures (continued): Parks (continued): Special purchases, projects, and studies (continued): Memorial benches -$ 3,960$ 3,953$ 7$ 118,240 118,240 118,240 - Capital outlay: - 5,440 5,436 4 200,000 200,000 - 200,000 - 53,240 53,233 7 Total Parks 1,430,060 1,481,650 1,045,342 436,308 Measure F-14 Sales Tax: Capital outlay: 2021 Pavement Resurfacing (East/South)103,240 103,240 918 102,322 2021 Pavement Rehabilitation (South)435,400 435,400 3,539 431,861 2022 Pavement Rehabilitation (West)3,359,090 3,359,090 3,158,083 201,007 2023 Pavement Rehabilitation (North)1,845,750 1,845,750 250,656 1,595,094 2024 Pavement Resurfacing (North/Central)20,000 20,000 - 20,000 2024 Pavement Rehabilitation (East/Central)60,000 60,000 1,110 58,890 Total Measure F-14 Sales Tax 5,823,480 5,823,480 3,414,306 2,409,174 Non-Departmental: Special purchases, projects, and studies: COVID-19 emergency protective measures - - 977 (977) 2023 Storms- Emergency Response - - 102,525 (102,525) 2023 Storms- Supplies - - 32,384 (32,384) 2023 Storms- Parks - - 72,093 (72,093) - - 5,894 (5,894) 2023 Storms- Debris Removal - - 41,960 (41,960) - 2,050,000 2,050,000 - - 1,000,000 1,000,000 - Variance with Final Budget Positive (Negative) Budget Cash contribution to Vehicle and Equipment Replacement Fund for reserve fund deficit Cash contribution to Building Maintenance and Replacement Fund for fund balance Cash contribution to Vehicle and Equipment Replacement Fund for reserve fund deficit Turf mower Slurry seal and stripe parking lots Lake Park pier and ADA improvements 2023 Storms- Replace Supplies and Damaged Equipment 95 CITY OF ATASCADERO GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - DETAIL (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Non-Departmental (continued): Capital outlay: 2023 Storms- Paloma Park Snack Bar -$ -$ 4,176$ (4,176)$ 2023 Storms- Atascadero Creek Capacity - - 41,157 (41,157) 2023 Storms- Atascadero High School Creek - - 729 (729) Postage Machine - 4,170 4,161 9 Total Non-Departmental - 3,054,170 3,356,056 (301,886) Total expenditures 39,227,830 46,882,780 40,914,694 5,968,086 Excess of revenues over (under) expenditures (7,200,480) (10,476,520) 86,661 10,563,181 Other Financing Sources (Uses): 746,460 746,460 743,353 (3,107) (453,310) (453,310) (275,456) 177,854 - (2,400) (2,393) 7 - (4,694,000) (4,694,000) - (2,600) (2,600) (2,600) - (1,400) (1,400) (1,400) - Total other financing sources and uses 289,150 (4,407,250) (4,232,496) 174,754 (6,911,330)$ (14,883,770)$ (4,145,835) 10,737,935$ Fund balance - June 30, 2022 25,332,470 Fund balance - June 30, 2023 21,186,635$ Budget Variance with Final Budget Positive (Negative) Transfer to Gas Tax Fund for streets maintenance Transfer from Community Facilities District Fund Net change in fund balance Transfer to Las Lomas Landscape and Lighting District for open space maintenance Transfer to De Anza Landscape and Lighting District for open space maintenance Transfer to Local Tranportation Fund for the Downtown Infrastructure Enhancement Plan Transfer to General Government Facilities Fee Fund for contribution toward purchase of a new vehicle 96 CITY OF ATASCADERO IN LIEU LOW/MODERATE INCOME HOUSING FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL Original Final Actual Amounts Revenues: Interest income 14,740$ 14,740$ 25,908$ 11,168$ Gain / (Loss) on inclusionary housing program loans - - 43,511 43,511 Total revenues 14,740 14,740 69,419 54,679 Expenditures: Contract services 5,000 1,500 - 1,500 Administrative charges 74,800 74,800 74,800 - Special projects: Closing cost program expense - 3,500 3,500 - PSHHC Del Rio Ridge affordable housing project 400,000 400,000 - 400,000 Total expenditures 479,800 479,800 78,300 401,500 Net change in fund balance (465,060)$ (465,060)$ (8,881) 456,179$ Fund balance, June 30, 2022 5,849,423 Fund balance, June 30, 2023 5,840,542$ Budget Variance with Final Budget Positive (Negative) For the Fiscal Year Ended June 30, 2023 97 CITY OF ATASCADERO LOCAL TRANSPORTATION FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Local Transportation Tax- Article 3 Bike Paths 31,910$ 31,910$ 41,619$ 9,709$ Local Transportation Tax- Article 8 Streets 669,030 669,030 1,360,686 691,656 HBRR Grant - Via Avenue Bridge 4,029,280 4,029,280 726,107 (3,303,173) HBRR Grant - Santa Lucia Bridge 4,852,520 4,852,520 1,432,230 (3,420,290) FHWA- Del Rio Bridge Abutment Repairs - 249,660 249,654 (6) FHWA- San Marcos Road Landslide Repair - 62,740 62,733 (7) USHA- Traffic Way/Ardilla Ave Rehab 95,960 95,960 64,681 (31,279) USHA- Downtown Infrastructure Enhancement Plan - 55,860 55,860 - RSHA- Downtown Infrastructure Enhancement Plan - 750,000 152,040 (597,960) - 3,000,000 - (3,000,000) Investment income (loss)9,140 9,140 (177,263) (186,403) Total revenues 9,687,840 13,806,100 3,968,347 (9,837,753) Expenditures: Special projects: Pavement Crack Sealing Preservation Program 60,000 60,000 - 60,000 Citywide Pavement Condition Evaluation Update 56,650 56,650 - 56,650 25,000 25,000 - 25,000 Storms- Debris Removal - - 137,857 (137,857) Local Roadway Safety Plan 1,600 1,600 - 1,600 Capital outlay: Downtown Infrastructure Enhancement Plan 3,659,430 3,719,680 207,900 3,511,780 San Anselmo Road Rehabilitation-West - - 468 (468) El Camino Real Rehabilitation Project- South 333,810 333,810 6,512 327,298 Traffic Way/Ardilla Avenue Rehabilitation 95,960 95,960 64,681 31,279 San Marcos Road Embankment Subsidence Repair 123,330 123,330 - 123,330 San Gabriel Road Rehabilitation 133,300 133,300 - 133,300 San Marcos Road Rehabilitation 131,440 131,440 701 130,739 Traffic Way Rehabilitation - North 150,000 150,000 234 149,766 Traffic Way/US 101 Alleyway Rehabilitation 110,020 110,020 10,287 99,733 San Marcos Road Landslide Repair - 62,740 62,733 7 Storm Drainage Improvement Projects 125,480 125,480 40,947 84,533 Via Avenue Bridge Replacement 4,546,540 4,733,500 823,827 3,909,673 Santa Lucia Road Bridge Replacement 4,795,150 4,795,150 1,400,760 3,394,390 Del Rio Road Bridge Abutment Repairs - 249,660 249,654 6 Downtown District Pavement Rehabilitation 1,525,000 1,672,660 208,848 1,463,812 Budget Variance with Final Budget Positive (Negative) Bridge Evaluations and Studies State Legislative Grant- Downtown Infrastructure Enhancement Plan 98 CITY OF ATASCADERO LOCAL TRANSPORTATION FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Capital outlay (continued): Storms- Culvert Replacement Emergency Response -$ -$ 171,460$ (171,460)$ Storms- Old Morro Road Repairs - - 182 (182) Total expenditures 15,872,710 16,579,980 3,387,051 13,192,929 Excess of revenues over (under) expenditures (6,184,870) (2,773,880) 581,296 3,355,176 Other Financing Sources (Uses): 333,810 333,810 6,512 (327,298) 150,000 150,000 234 (149,766) - 4,694,000 4,694,000 - - 255,090 255,090 - Total other financing sources (uses)483,810 5,432,900 4,955,836 (477,064) Net change in fund balance (5,701,060)$ 2,659,020$ 5,537,132 2,878,112$ Fund balance, June 30, 2022 3,017,216 Fund balance, June 30, 2023 8,554,348$ Transfer from 2010 Bond Proceeds Master Agreement Fund for Downtown Infrastructure Enhancement Plan Transfer from Gas Tax Fund for El Camino Real Rehabilitation Project South (SB1) Transfer from Gas Tax Fund for Traffic Way Rehabilitation Project North (SB1) Transfer from General Fund for Downtown Infrastructure Enhancement Plan Budget Variance with Final Budget Positive (Negative) 99 CITY OF ATASCADERO CIRCULATION SYSTEM FEES FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Impact fees 220,000$ 220,000$ 500,996$ 280,996$ Interest income 19,520 19,520 72,792 53,272 Total revenues 239,520 239,520 573,788 334,268 Expenditures: Capital outlay: 101 @ Del Rio Interchange Project 2,469,300 2,469,300 619,235 1,850,065 Total expenditures 2,469,300 2,469,300 619,235 1,850,065 Net change in fund balance (2,229,780)$ (2,229,780)$ (45,447) 2,184,333$ Fund balance, June 30, 2022 2,817,013 Fund balance, June 30, 2023 2,771,566$ Budget Variance with Final Budget Positive (Negative) 100 CITY OF ATASCADERO FIRE AERIAL VEHICLE IMPACT FEES FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Impact fees 8,000$ 8,000$ 17,739$ 9,739$ Total revenues 8,000 8,000 17,739 9,739 Net change in fund balance 8,000$ 8,000$ 17,739 9,739$ Fund balance, June 30, 2022 (718,145) Fund balance, June 30, 2023 (700,406)$ Budget Variance with Final Budget Positive (Negative) 101 CITY OF ATASCADERO SCHEDULE OF CHANGES IN THE OPEB LIABILITY AND RELATED RATIOS Last 10 Years* For the Fiscal Year Ended June 30, 2023 The following table provides required supplementary information regarding the City's postemployment healthcare benefits. 2023 2022 2021 2020 2019 2018 Total OPEB Liability Service cost 14,653$ 10,981$ 8,079$ 9,582$ 13,252$ 7,820$ Interest on total OPEB liability 7,009 6,699 6,464 6,190 5,763 5,583 Benefit payments (4,346) (7,357) (6,726) (6,610) (4,800) (7,400) Net change in total OPEB liability 17,316 10,323 7,817 9,162 14,215 6,003 OPEB liability, beginning of year 233,620 223,297 215,480 206,318 192,103 186,100 OPEB liability, end of year 250,936$ 233,620$ 223,297$ 215,480$ 206,318$ 192,103$ Covered payroll 1,354,325$ 1,173,780$ 1,200,858$ 1,200,858$ 1,200,858$ 1,126,865$ Total OPEB liability as a percentage of covered payroll 18.53%19.90%18.59%17.94%17.18%17.05% Notes to Schedule: There were no changes in assumptions reflected above. * Fiscal year 2018 was the first year of implementation, therefore, only six years are shown. Measurement Period 102 CITY OF ATASCADERO SCHEDULE OF OPEB CONTRIBUTIONS Last 10 Years As of June 30, 2023 As of June 30,2023,the plan is not administered through a qualified trust.Therefore,there is no Actuarially Determined contribution (ADC).Benefit payments of $4,346 were made on a pay-as-you-go basis for the fiscal year ended June 30,2023.Benefit payments of $7,357 were made on a pay-as-you-go basis for the fiscal year ended June 30, 2022.Benefit payments of $6,726 were made on a pay-as-you-go basis for the fiscal year ended June 30,2021.Benefits payments of $6,610 were made on a pay-as-you-go basis for the fiscal year ended June 30,2020.Benefit payments of $4,800 were made on a pay-as-you-go basis for the fiscal year ended June 30,2019.Benefit payments of $7,400 were made on a pay-as-you-go basis for the fiscal year ended June 30, 2018. 103 CITY OF ATASCADERO SCHEDULE OF THE LOCAL GOVERNMENT'S PROPORTIONATE SHARE OF THE NET PENSION LIABILITY Cost-Sharing Multiple-Employer Defined Pension Plan - Last 10 Years* As of June 30, 2023 6/30/2023 6/30/2022 6/30/2021 6/30/2020 6/30/2019 6/30/2018 6/30/2017 6/30/2016 6/30/2015 Measurement Date 6/30/2022 6/30/2021 6/30/2020 6/30/2019 6/30/2018 6/30/2017 6/30/2016 6/30/2015 6/30/2014 City's proportion of the net pension liability 0.303060%0.346860%0.281480%0.277520%0.275210%0.270324%0.272255%0.278260%0.260250% City's proportionate share of the net pension liability 35,005,507$ 18,759,199$ 30,626,061$ 28,437,309$ 26,519,899$ 26,808,749$ 23,558,492$ 19,099,492$ 16,193,941$ City's covered payroll **11,164,515$ 9,943,967$ 10,024,682$ 9,541,259$ 9,337,993$ 10,102,742$ 8,658,607$ 8,348,164$ 8,181,272$ 313.54%188.65%305.51%298.05%284.00%265.36%272.08%228.79%197.94% 49,525,975,138$ 46,174,942,264$ 43,702,930,887$ 41,426,453,489$ 38,944,855,364$ 37,161,348,332$ 33,358,627,624$ 31,771,217,402$ 30,829,966,631$ 37,975,170,163$ 40,766,653,876$ 32,822,501,335$ 31,179,414,067$ 29,308,589,559$ 27,244,095,376$ 24,705,532,291$ 24,907,305,871$ 24,607,502,515$ 76.68%88.29%75.10%75.26%75.26%73.31%74.06%78.40%79.82% * Fiscal year 2015 was the first year of implementation, therefore, only nine years are shown. ** For the year ending on the measurement date. Fiscal Year End City's proportionate share of the net pension liability as percentage of covered payroll Plan's total pension liability Plan's fiduciary net position Plan's fiduciary net position as a percentage of the plan's total pension liability 104 CITY OF ATASCADERO SCHEDULE OF PENSION CONTRIBUTIONS Cost-Sharing Multiple-Employer Defined Pension Plan - Last 10 Years* As of June 30, 2023 Contributions for the fiscal year ending:6/30/2023 6/30/2022 6/30/2021 6/30/2020 6/30/2019 6/30/2018 6/30/2017 6/30/2016 6/30/2015 4,688,082$ 4,236,582$ 3,742,162$ 3,366,536$ 2,982,660$ 2,685,953$ 2,489,485$ 2,255,947$ 2,227,093$ (4,688,082) (4,236,582) (3,742,162) (3,366,536) (2,982,660) (2,685,953) (2,489,485) (2,255,947) (2,227,093) Contribution deficiency (excess)-$ -$ -$ -$ -$ -$ -$ -$ -$ Covered payroll **12,476,406$ 11,164,515$ 9,943,967$ 10,024,682$ 9,541,259$ 9,337,993$ 10,102,742$ 8,658,607$ 8,348,164$ Contributions as a percentage of covered payroll 37.58%37.95%37.63%33.58%31.26%28.76%24.64%26.05%26.68% Notes to Schedule Valuation Date 06/30/20 06/30/19 06/30/18 06/30/17 06/30/16 06/30/15 06/30/14 06/30/13 06/30/12 Methods and assumptions used to determine contribution rates: Actuarial cost method Asset valuation method Amortization method Discount rate 6.900%7.150%7.150%7.150%7.375%7.650%7.650%7.500%7.500% Price inflation 2.30%2.50%2.50%2.50%2.50%2.75%2.75%2.75%2.75% Salary increases Mortality Post retirement benefit Contract COLA up to 2.30% until Purchasing Power Protection Allowance Floor on Purchasing Power applies * Fiscal year 2015 was the first year of implementation, therefore, only nine years are shown. ** For the fiscal year ending on the date shown. Contractually required contribution (actuarially determined) Contributions in relation to the actuarially determined contributions Contract COLA up to 2.50% until Purchasing Power Protection Allowance Floor on Purchasing Power applies Entry age 5-year smoothed market Level percentage of payroll, closed Varies by entry age and service Derived using CalPERS' Membership data for all funds 105 OTHER SUPPLEMENTARY INFORMATION CITY OF ATASCADERO 2010 BOND DEBT SERVICE FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Interest income- cash and investments 5,000$ 5,000$ 49,315$ 44,315$ 691,500 691,500 695,298 3,798 Total revenues 696,500 696,500 744,613 48,113 Expenditures: Insurance 4,150 4,150 3,635 515 Contract services 2,600 2,600 1,925 675 Principal 275,000 275,000 275,000 - Interest 689,750 689,750 689,738 12 Total expenditures 971,500 971,500 970,298 1,202 Net change in fund balance (275,000)$ (275,000)$ (225,685) 49,315$ Fund balance, June 30, 2022 15,506,310 Fund balance, June 30, 2023 15,280,625$ Budget Variance with Final Budget Positive (Negative) Interest income- 2010 reimbursement agreement with the Successor Agency to the RDA 106 CITY OF ATASCADERO NONMAJOR GOVERNMENTAL FUNDS OVERVIEW SPECIAL REVENUE FUNDS The City has established the following special revenue funds in order to account for the proceeds from revenue sources that are restricted to expenditures for specified purposes: Supplemental Law Enforcement Services Fund This fund is used for Supplemental Law Enforcement Services grant monies received and to account for the allowed expenditures of these funds. Downtown Business Improvement Area Fund The City established a Downtown Business Improvement Area (BIA)in 1986 for the purpose of acquisition,construction,and/or maintenance of parking facilities, decoration of public places,promotion of public events,and the general promotion of business activities in the downtown area.An annual assessment is placed on all businesses in the downtown area,and this fund accounts for the revenues and expenses associated with these BIA monies.The assessment was reduced to $0.00 in 2010 at the behest of downtown landlords as part of a program to encourage downtown business.In January 2018,the Atascadero Colony District Committee requested that the assessment be reinstituted. The assessment was reinstituted effective January 2019. Atascadero Tourism Business Improvement District Fund The City established the Atascadero Tourism Business Improvement District (ATBID)effective June 1,2013,for the purpose of funding tourism promotion and increasing stays at the lodging businesses in Atascadero.A two percent (2%)assessment is placed on the nightly rent of all occupied rooms or spaces for all transient occupancies in Atascadero. Community Development Block Grant Fund This fund is used for Community Development Block Grant monies received from the federal government.These funds must be used for low or moderate income projects,or to eliminate blight in the community.The City receives an annual allocation from the federal government,based on the number of qualified persons in the City. The City holds an annual hearing to determine how this money is to be spent. Tree Plant Fund This fund accounts for Tree Mitigation Fees and the expenditure thereof.A fee may be paid by a developer in lieu of planting a tree on improved property.These funds are then used for the preservation and planting of the City's native trees. Gas Tax Fund This fund accounts for gas tax monies received from the State, which are expended to maintain various streets within the City. Street Assessment Fund This fund accounts for assessments collected to maintain various streets within the City. 107 CITY OF ATASCADERO NONMAJOR GOVERNMENTAL FUNDS OVERVIEW (continued) SPECIAL REVENUE FUNDS (continued) General Government Facilities Fees Fund General Facilities are those limited to office or work buildings and equipment used by City staff to undertake their daily duties.As the City increases in both population and new businesses,City Hall and the City maintenance yard will increasingly become overcrowded with growing staff.New facilities and equipment are necessary to extend the current level of service to these new residents and businesses.Because the need for these new facilities and additional equipment is directly related to new construction,a General Government Facilities Fee is charged on all new development.These fees are deposited into this fund and then used for expanded/new facilities and equipment as listed in the Atascadero Master Facilities Plan, updated February 2006. Storm Drainage Facilities Fees Fund As vacant land is developed and bare dirt or turf is replaced with impervious rooftop,parking lots,driveways,pools and sidewalks,water runoff increases;the cumulative effects of this additional runoff is managed by constructing the appropriate capital facilities.Because the need for these capital facilities is directly related to new construction,a Storm Drainage Facilities Fee is charged on all new development.These fees are deposited into this fund and then used for the construction of the new/increased/improved capital facilities as listed in the Atascadero Master Facilities Plan, updated February 2006. Law Enforcement Facilities Fees Fund Residents and businesses benefit from both direct (response to a call for service)and indirect (crime prevention programs,patrol,etc.)law enforcement services. The addition of new residential units and new businesses necessarily increase the demand upon the law enforcement service level by creating more direct calls for service,more area requiring preventive patrol,and in general,more opportunities for crimes to be committed.If law enforcement capabilities are not expanded, then the increasing number of calls for service will reduce the amount of time available for preventive patrol.Because the need for additional police officers,as well as the need for these officers to be equipped and housed,is directly related to new construction,a Law Enforcement Facilities Fee is charged on all new development.These fees are deposited into this fund and then used for the purchase/construction of equipment/stations for these additional officers as listed in the Atascadero Master Facilities Plan, updated February 2006. Fire Facilities Fees Fund In addition to providing fire prevention programs,the Fire Department responds to calls for fire and medical services from two existing fire stations.Each new residential and business development creates more calls for service,increasing the likelihood of simultaneous (and thus competing)calls for service.Additionally, as development spreads further from the existing stations,response times will necessarily increase,taking the existing engine companies out of service for greater periods of time.These developments create the need for additional facilities and equipment.Because the need for these new facilities and additional equipment is directly related to new construction,a Fire Facilities Fee is charged on all new development.These fees are deposited into this fund and then used for the relocation/construction of fire stations, as well as the purchase of additional equipment, as listed in the Atascadero Master Facilities Plan, updated February 2006. Open Space Acquisition Fees Fund Future residential development,by increasing the City's population,will by definition impact the City's available land and decrease open space.Without open space acquisition,the City's remaining available land will be developed and the City will lose much of its historic charm that is so valuable to residents.Because the need for land acquisition is directly related to new construction,an Open Space Acquisition Fee is charged on all new development.These fees are deposited into this fund and then used for land acquisitions as listed in the Atascadero Master Facilities Plan, updated February 2006. 108 CITY OF ATASCADERO NONMAJOR GOVERNMENTAL FUNDS OVERVIEW (continued) SPECIAL REVENUE FUNDS (continued) Parkland Facilities Fees Fund Residential development,by increasing the City's population,necessarily impacts the City's park system.Without future parkland and continued development of currently owned,but underutilized parkland,the City's parks become overcrowded and overused with the ultimate result becoming a negative experience for park users.Because the need for new facilities and land acquisitions is directly related to new construction,a Parkland Facilities Fee is charged on all new development.These fees are deposited into this fund and then used for expanded/new facilities and land acquisitions as listed in the Atascadero Master Facilities Plan, updated February 2006. Public Facilities Fees Fund The City currently has existing community use facilities,such as the Pavilion on the Lake and the Colony Park Community Center.Future additional residential units will increase the City's population,placing ever greater demands on existing community use facilities,and new or expanded community center space will be necessary to extend the current level of service to new residents.Because the need for these new facilities is directly related to new construction,a Public Facilities Fee is charged on all new residential development.These fees are deposited into this fund and then used for expanded/new community use facilities as listed in the Atascadero Master Facilities Plan, updated February 2006. Library Expansion Facilities Fees Fund The County Public Library System currently owns and maintains a library facility within the City limits.While the City is not the library service provider,the City's residents and businesses have an interest in maintaining the library service levels.Additional development within the City will increase the demand for a larger sized library and for more volumes within the library.Because the need for expanded library services is directly related to new construction,a Library Facilities Fee is charged on all new development.These fees are deposited into this fund and then are used for the expansion of the amount of library facility space and the expansion of the library collection as listed in the Atascadero Master Facilities Plan,updated February 2006.In December 2010,the County purchased a new library facility at 6555 Capistrano Avenue.The City contributed a total of $315,180 toward the library expansion during the period spanning December 2010 through June 2014. This amount was a combination of impact fees and other funds that had been set aside for library expansion. Community Facilities District Fund This fund is used to account for fees assessed in the Community Facilities District.This district was established in 2005 in order to provide funding for expansion of police,fire,and parks services as the City's population increases.Developments that must obtain Planning Commission approval are subject to annexation into the city-wide district. Apple Valley Street & Storm Drain Assessment District Fund This fund is used to account for fees assessed in a development known as The Colony at Apple Valley.This assessment district was established in 2005 in order to maintain the street and storm drain related improvements in the development. Apple Valley Landscape & Lighting Assessment District Fund This fund is used to account for fees assessed in a development known as The Colony at Apple Valley.This assessment district was established in 2005 in order to maintain the landscape and lighting related improvements in the development. 109 CITY OF ATASCADERO NONMAJOR GOVERNMENTAL FUNDS OVERVIEW (continued) SPECIAL REVENUE FUNDS (continued) AND CAPITAL PROJECTS FUNDS Las Lomas Street & Storm Drain Assessment District Fund This fund is used to account for fees assessed in a development known as Las Lomas.This assessment district was established in 2005 in order to maintain the street and storm drain related improvements in the development. Las Lomas Landscape & Lighting Assessment District Fund This fund is used to account for fees assessed in a development known as Las Lomas.This assessment district was established in 2005 in order to maintain the landscape and lighting related improvements in the development. De Anza Street & Storm Drain Assessment District Fund This fund is used to account for fees assessed in a development known as De Anza Estates.This assessment district was established in 2005 in order to maintain the street and storm drain related improvements in the development. De Anza Landscape & Lighting Assessment District Fund This fund is used to account for fees assessed in a development known as De Anza Estates.This assessment district was established in 2005 in order to maintain the landscape and lighting related improvements in the development. The City has established the following capital projects funds in order to account for expenditures for specific capital project purposes: Capital Projects Fund This fund is typically used to account for the financial resources used in the construction or acquisition of major capital facilities or equipment obtained by special funding such as grants or dedicated reimbursements. It is also used as a type of clearinghouse for projects with many different sources of funding. 2010 Bond Proceeds Master Agreement Fund On September 1,2010,the City issued $16,010,000 in lease revenue bonds to be used for various redevelopment public improvement projects within the downtown area.As part of June 2011 state legislation,all redevelopment agencies throughout the State were dissolved.At that time,the Redevelopment Agency was in the process of expending the 2010 bond proceeds in accordance with the bond covenants which require the funds to be spent on the Historic City Hall Rehabilitation Project with the remaining funds to be spent on other eligible redevelopment projects.The Historic City Hall Rehabilitation Project has been completed,leaving remaining 2010 bond proceeds.In accordance with redevelopment dissolution law,in August of 2014,the City and the Successor Agency entered into a Master Agreement,transferring all remaining bond proceeds to the City to be spent on projects for which the bonds were originally sold.This fund accounts for the expenditure of those 2010 bond funds transferred to the City under the Master Agreement. 110 CITY OF ATASCADERO NONMAJOR GOVERNMENTAL FUNDS COMBINING BALANCE SHEET June 30, 2023 Supplemental Law Enforcement Services Fund Downtown Business Improvement Area Fund Atascadero Tourism Business Improvement District Fund Community Development Block Grant Fund Tree Plant Fund Gas Tax Fund ASSETS Cash and investments 205,533$ 14,029$ 584,043$ -$ 198,880$ 759,833$ Receivables: Federal distributions due - - - 57,396 - - Due from State of California - - - - - 190,582 Due from County of San Luis Obispo - - - - - - Accrued interest 1,206 78 3,215 - 1,118 3,978 Other receivables - - 123,615 363 - - Due from other funds - - - - - - Prepaid items - - - - - 730 Total assets 206,739$ 14,107$ 710,873$ 57,759$ 199,998$ 955,123$ LIABILITIES AND FUND BALANCES Accounts payable -$ -$ 42,451$ 710$ 350$ 57,237$ Accrued salaries and benefits 2,776 - - - - 15,204 Due to other funds - - - 57,049 - - Unearned revenue 205,892 - - - - - Total liabilities 208,668 - 42,451 57,759 350 72,441 Fund Balances: Nonspendable - - - - - 730 Restricted - 14,107 668,422 - 199,648 881,952 Assigned for road projects - - - - - - Unassigned (1,929) - - - - - Total fund balances (deficits)(1,929) 14,107 668,422 - 199,648 882,682 Total liabilities and fund balances 206,739$ 14,107$ 710,873$ 57,759$ 199,998$ 955,123$ Special Revenue Funds 111 CITY OF ATASCADERO NONMAJOR GOVERNMENTAL FUNDS COMBINING BALANCE SHEET (continued) June 30, 2023 Special Revenue Funds Street Assessment Fund General Government Facilities Fees Fund Storm Drainage Facilities Fees Fund Law Enforcement Facilities Fees Fund Fire Facilities Fees Fund Open Space Acquisition Fees Fund ASSETS Cash and investments 87,467$ 292,524$ 567,740$ 350,281$ 816,086$ 1,012,091$ Receivables: Federal distributions due - - - - - - Due from State of California - - - - - - Due from County of San Luis Obispo - - - - - - Accrued interest 490 1,612 3,160 1,970 4,558 5,641 Other receivables - - - - - - Due from other funds - - - - 700,406 - Prepaid items - - - - - - Total assets 87,957$ 294,136$ 570,900$ 352,251$ 1,521,050$ 1,017,732$ LIABILITIES AND FUND BALANCES Accounts payable -$ -$ -$ -$ 31$ -$ Accrued salaries and benefits - - - - - - Due to other funds - - - - - - Unearned revenue - - - - - - Total liabilities - - - - 31 - Fund Balances: Nonspendable - - - - - - Restricted 87,957 294,136 570,900 352,251 1,521,019 1,017,732 Assigned for road projects - - - - - - Unassigned - - - - - - Total fund balances (deficits)87,957 294,136 570,900 352,251 1,521,019 1,017,732 Total liabilities and fund balances 87,957$ 294,136$ 570,900$ 352,251$ 1,521,050$ 1,017,732$ 112 CITY OF ATASCADERO NONMAJOR GOVERNMENTAL FUNDS COMBINING BALANCE SHEET (continued) June 30, 2023 Parkland Facilities Fees Fund Public Facilities Fees Fund Library Expansion Facilities Fees Fund Community Facilities District Fund Apple Valley Street & Storm Drain Assessment District Fund Apple Valley Landscape & Lighting Assessment District Fund ASSETS Cash and investments 869,266$ 151,663$ 311,861$ -$ 545,289$ 211,546$ Receivables: Federal distributions due - - - - - - Due from State of California - - - - - - Due from County of San Luis Obispo - - - 13,824 - - Accrued interest 4,761 824 1,738 - 3,036 1,180 Other receivables - - - - - - Due from other funds - - - - - - Prepaid items - - - - - - Total assets 874,027$ 152,487$ 313,599$ 13,824$ 548,325$ 212,726$ LIABILITIES AND FUND BALANCES Accounts payable 111,746$ -$ -$ -$ 127$ 3,790$ Accrued salaries and benefits - - - - - - Due to other funds - - - 13,824 - - Unearned revenue - - - - - 28,770 Total liabilities 111,746 - - 13,824 127 32,560 Fund Balances: Nonspendable - - - - - - Restricted 762,281 152,487 313,599 - 548,198 180,166 Assigned for road projects - - - - - - Unassigned - - - - - - Total fund balances (deficits)762,281 152,487 313,599 - 548,198 180,166 Total liabilities and fund balances 874,027$ 152,487$ 313,599$ 13,824$ 548,325$ 212,726$ Special Revenue Funds 113 CITY OF ATASCADERO NONMAJOR GOVERNMENTAL FUNDS COMBINING BALANCE SHEET (continued) June 30, 2023 Las Lomas Street & Storm Drain Assessment District Fund Las Lomas Landscape & Lighting Assessment District Fund De Anza Street & Storm Drain Assessment District Fund De Anza Landscape & Lighting Assessment District Fund ASSETS Cash and investments 659,145$ 198,274$ 520,413$ 127,434$ Receivables: Federal distributions due - - - - Due from State of California - - - - Due from County of San Luis Obispo 968 689 216 158 Accrued interest 3,637 1,092 2,904 710 Other receivables - - - - Due from other funds - - - - Prepaid items - - - - Total assets 663,750$ 200,055$ 523,533$ 128,302$ LIABILITIES AND FUND BALANCES Accounts payable 127$ 4,288$ 127$ 875$ Accrued salaries and benefits - - - - Due to other funds - - - - Unearned revenue - - - - Total liabilities 127 4,288 127 875 Fund Balances: Nonspendable - - - - Restricted 663,623 195,767 523,406 127,427 Assigned for road projects - - - - Unassigned - - - - Total fund balances (deficits)663,623 195,767 523,406 127,427 Total liabilities and fund balances 663,750$ 200,055$ 523,533$ 128,302$ Special Revenue Funds 114 CITY OF ATASCADERO NONMAJOR GOVERNMENTAL FUNDS COMBINING BALANCE SHEET (continued) June 30, 2023 Capital Projects Fund 2010 Bond Proceeds Master Agreement Fund TOTALS ASSETS Cash and investments 357,829$ 3,194$ 8,844,421$ Receivables: Federal distributions due - - 57,396 Due from State of California - - 190,582 Due from County of San Luis Obispo - - 15,855 Accrued interest 2,009 965 49,882 Other receivables - - 123,978 Due from other funds - - 700,406 Prepaid items - - 730 Total assets 359,838$ 4,159$ 9,983,250$ LIABILITIES AND FUND BALANCES Accounts payable -$ -$ 221,859$ Accrued salaries and benefits - - 17,980 Due to other funds - - 70,873 Unearned revenue - - 234,662 Total liabilities - - 545,374 Fund Balances: Nonspendable - - 730 Restricted 132,333 4,159 9,211,570 Assigned for road projects 227,505 - 227,505 Unassigned - - (1,929) Total fund balances (deficits)359,838 4,159 9,437,876 Total liabilities and fund balances 359,838$ 4,159$ 9,983,250$ Capital Projects Funds 115 CITY OF ATASCADERO NONMAJOR GOVERNMENTAL FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES For Fiscal Year Ended June 30, 2023 Supplemental Law Enforcement Services Fund Downtown Business Improvement Area Fund Atascadero Tourism Business Improvement District Fund Community Development Block Grant Fund Tree Plant Fund Gas Tax Fund Revenues: Taxes and assessments -$ 13,936$ 431,401$ -$ -$ -$ Licenses and permits - - - - 14,708 - Intergovernmental revenues 112,079 - - 21,139 - 1,491,552 Fines and forfeitures - - 3,904 - - - Use of money and property 1,179 74 2,966 - 3,180 (13,140) Other revenues - - - - - 655 Total revenues 113,258 14,010 438,271 21,139 17,888 1,479,067 Expenditures: Salaries and benefits 65,599 - - - - 426,905 Supplies and services 23,520 13,696 293,960 9,763 22,926 654,325 Special projects and studies 26,068 - - 10,752 - - Capital outlay - - - 624 - - Total expenditures 115,187 13,696 293,960 21,139 22,926 1,081,230 Excess of revenues over (under) expenditures (1,929) 314 144,311 - (5,038) 397,837 Other Financing Sources (Uses): Transfers in - - - - - 275,456 Transfers out - - - - - (6,746) Total other financing sources (uses)- - - - - 268,710 Net change in fund balances (1,929) 314 144,311 - (5,038) 666,547 Fund balances, June 30, 2022 - 13,793 524,111 - 204,686 216,135 Fund balances (deficits), June 30, 2023 (1,929)$ 14,107$ 668,422$ -$ 199,648$ 882,682$ Special Revenue Funds 116 CITY OF ATASCADERO NONMAJOR GOVERNMENTAL FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES (continued) For Fiscal Year Ended June 30, 2023 Street Assessment Fund General Government Facilities Fees Fund Storm Drainage Facilities Fees Fund Law Enforcement Facilities Fees Fund Fire Facilities Fees Fund Open Space Acquisition Fees Fund Revenues: Taxes and assessments 2,160$ -$ -$ -$ -$ -$ Licenses and permits - 80,686 62,051 40,355 59,048 102,878 Intergovernmental revenues - - - - - - Fines and forfeitures - - - - - - Use of money and property 1,217 3,383 5,963 6,614 9,126 11,048 Other revenues - - - - - - Total revenues 3,377 84,069 68,014 46,969 68,174 113,926 Expenditures: Salaries and benefits - - - - - - Supplies and services - - - - - - Special projects and studies 1,547 - - 3,942 - - Capital outlay - 51,290 - 70,901 - - Total expenditures 1,547 51,290 - 74,843 - - Excess of revenues over (under) expenditures 1,830 32,779 68,014 (27,874) 68,174 113,926 Other Financing Sources (Uses): Transfers in - 2,393 - - - - Transfers out - - - - - - Total other financing sources (uses)- 2,393 - - - - Net change in fund balances 1,830 35,172 68,014 (27,874) 68,174 113,926 Fund balances, June 30, 2022 86,127 258,964 502,886 380,125 1,452,845 903,806 Fund balances (deficits), June 30, 2023 87,957$ 294,136$ 570,900$ 352,251$ 1,521,019$ 1,017,732$ Special Revenue Funds 117 CITY OF ATASCADERO NONMAJOR GOVERNMENTAL FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES (continued) For Fiscal Year Ended June 30, 2023 Parkland Facilities Fees Fund Public Facilities Fees Fund Library Expansion Facilities Fees Fund Community Facilities District Fund Apple Valley Street & Storm Drain Assessment District Fund Apple Valley Landscape & Lighting Assessment District Fund Revenues: Taxes and assessments -$ -$ -$ 719,121$ 38,500$ 63,000$ Licenses and permits 279,079 64,153 36,839 - - 11,000 Intergovernmental revenues - - - - - - Fines and forfeitures - - - - - - Use of money and property 3,186 44 3,238 638 6,443 3,175 Other revenues - - - - - - Total revenues 282,265 64,197 40,077 719,759 44,943 77,175 Expenditures: Salaries and benefits - - - - - - Supplies and services - - - 5,334 5,534 51,578 Special projects and studies 54,610 - - - - 24,970 Capital outlay 57,455 - - - - - Total expenditures 112,065 - - 5,334 5,534 76,548 Excess of revenues over (under) expenditures 170,200 64,197 40,077 714,425 39,409 627 Other Financing Sources (Uses): Transfers in - - - - - - Transfers out - - - (743,353) - - Total other financing sources (uses)- - - (743,353) - - Net change in fund balances 170,200 64,197 40,077 (28,928) 39,409 627 Fund balances, June 30, 2022 592,081 88,290 273,522 28,928 508,789 179,539 Fund balances (deficits), June 30, 2023 762,281$ 152,487$ 313,599$ -$ 548,198$ 180,166$ Special Revenue Funds 118 CITY OF ATASCADERO NONMAJOR GOVERNMENTAL FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES (continued) For Fiscal Year Ended June 30, 2023 Las Lomas Street & Storm Drain Assessment District Fund Las Lomas Landscape & Lighting Assessment District Fund De Anza Street & Storm Drain Assessment District Fund De Anza Landscape & Lighting Assessment District Fund Revenues: Taxes and assessments 99,189$ 70,453$ 30,561$ 15,874$ Licenses and permits - - - - Intergovernmental revenues - - - - Fines and forfeitures - - - - Use of money and property 5,907 2,260 6,413 1,719 Other revenues - - - - Total revenues 105,096 72,713 36,974 17,593 Expenditures: Salaries and benefits - - - - Supplies and services 5,887 58,328 5,477 14,281 Special projects and studies - 6,044 - - Capital outlay - - - - Total expenditures 5,887 64,372 5,477 14,281 Excess of revenues over (under) expenditures 99,209 8,341 31,497 3,312 Other Financing Sources (Uses): Transfers in - 2,600 - 1,400 Transfers out - - - - Total other financing sources (uses)- 2,600 - 1,400 Net change in fund balances 99,209 10,941 31,497 4,712 Fund balances, June 30, 2022 564,414 184,826 491,909 122,715 Fund balances (deficits), June 30, 2023 663,623$ 195,767$ 523,406$ 127,427$ Special Revenue Funds 119 CITY OF ATASCADERO NONMAJOR GOVERNMENTAL FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES (continued) For Fiscal Year Ended June 30, 2023 Capital Projects Fund 2010 Bond Proceeds Master Agreement Fund TOTALS Revenues: Taxes and assessments -$ -$ 1,484,195$ Licenses and permits - - 750,797 Intergovernmental revenues - - 1,624,770 Fines and forfeitures - - 3,904 Use of money and property 5,106 12,656 82,395 Other revenues - - 655 Total revenues 5,106 12,656 3,946,716 Expenditures: Salaries and benefits - - 492,504 Supplies and services - - 1,164,609 Special projects and studies - - 127,933 Capital outlay - 19,438 199,708 Total expenditures - 19,438 1,984,754 Excess of revenues over (under) expenditures 5,106 (6,782) 1,961,962 Other Financing Sources (Uses): Transfers in - - 281,849 Transfers out - (255,090) (1,005,189) Total other financing sources (uses)- (255,090) (723,340) Net change in fund balances 5,106 (261,872) 1,238,622 Fund balances, June 30, 2022 354,732 266,031 8,199,254 Fund balances (deficits), June 30, 2023 359,838$ 4,159$ 9,437,876$ Capital Projects Funds 120 CITY OF ATASCADERO SUPPLEMENTAL LAW ENFORCEMENT SERVICES FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: S.L.E.S.F. Grant -$ 112,100$ 112,079$ (21)$ Interest income - - 1,179 1,179 Total revenues - 112,100 113,258 1,158 Expenditures: Employee services - 62,480 65,599 (3,119) Computer maintenance & replacement - 7,800 7,800 - Occupancy - 1,930 1,927 3 Communications - 2,750 2,748 2 Operating supplies - 1,920 1,913 7 Contract services - 9,130 9,132 (2) Special projects and purchases: Monitors - 3,680 3,673 7 Personal protective vests - 14,520 14,510 10 Radio Replacement - 7,890 7,885 5 Total expenditures - 112,100 115,187 (3,087) Net change in fund balance -$ -$ (1,929) (1,929)$ Fund balance, June 30, 2022 - Fund balance (deficit), June 30, 2023 (1,929)$ Budget Variance with Final Budget Positive (Negative) 121 CITY OF ATASCADERO DOWNTOWN BUSINESS IMPROVEMENT AREA FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Tourism assessments 12,800$ 12,800$ 13,936$ 1,136$ Interest income 70 70 74 4 Total revenues 12,870 12,870 14,010 1,140 Expenditures: Main Street Administration 13,760 13,760 13,696 64 Total expenditures 13,760 13,760 13,696 64 Net change in fund balance (890)$ (890)$ 314 1,204$ Fund balance, June 30, 2022 13,793 Fund balance, June 30, 2023 14,107$ Budget Variance with Final Budget Positive (Negative) 122 CITY OF ATASCADERO ATASCADERO TOURISM BUSINESS IMPROVEMENT DISTRICT FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Tourism assessments 298,170$ 298,170$ 431,401$ 133,231$ Tourism assessment penalties - - 3,904 3,904 Interest income 6,640 6,640 2,966 (3,674) Total revenues 304,810 304,810 438,271 133,461 Expenditures: Office expense 250 250 - 250 Advertising 165,000 145,500 126,556 18,944 Contract services 145,000 163,060 163,051 9 Professional development 450 450 - 450 Administration 2,920 4,360 4,353 7 Total expenditures 313,620 313,620 293,960 19,660 Net change in fund balance (8,810)$ (8,810)$ 144,311 153,121$ Fund balance, June 30, 2022 524,111 Fund balance, June 30, 2023 668,422$ Budget Variance with Final Budget Positive (Negative) 123 CITY OF ATASCADERO COMMUNITY DEVELOPMENT BLOCK GRANT FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Community Development Block Grant -$ 263,590$ 21,139$ (242,451)$ Total revenues - 263,590 21,139 (242,451) Expenditures: Advertising - 460 454 6 Administration: CDBG general administration - 9,310 9,309 1 Special projects and studies: Youth scholarships - 12,640 10,752 1,888 Capital outlay: Santa Rosa barrier removal - 172,560 546 172,014 Viejo Camino barrier removal - 68,620 78 68,542 Total expenditures - 263,590 21,139 242,451 Net change in fund balance -$ -$ - -$ Fund balance, June 30, 2022 - Fund balance, June 30, 2023 -$ Budget Variance with Final Budget Positive (Negative) 124 CITY OF ATASCADERO TREE PLANT FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Permits and fees 12,000$ 12,000$ 14,708$ 2,708$ Interest income 790 790 3,180 2,390 Total revenues 12,790 12,790 17,888 5,098 Expenditures: Office expense 80 70 - 70 Operating supplies 200 210 206 4 Contract services 10,000 10,000 4,200 5,800 Professional development 300 300 - 300 Administrative charges 18,520 18,520 18,520 - Special projects and studies: Native tree replanting 8,080 8,080 - 8,080 Total expenditures 37,180 37,180 22,926 14,254 Net change in fund balance (24,390)$ (24,390)$ (5,038) 19,352$ Fund balance, June 30, 2022 204,686 Fund balance, June 30, 2023 199,648$ Budget Variance with Final Budget Positive (Negative) 125 CITY OF ATASCADERO GAS TAX FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Section 2103 highway users tax 235,560$ 235,560$ 250,869$ 15,309$ Section 2105 highway users tax 173,040 173,040 175,218 2,178 Section 2106 highway users tax 128,430 128,430 133,717 5,287 Section 2107 highway users tax 220,080 220,080 238,793 18,713 Section 2107.5 highway users tax 6,000 6,000 6,000 - SB1- Section 2031 Road Maintenance & Rehabilitation 594,140 594,140 686,955 92,815 Other revenues - - 655 655 Investment income (loss)3,110 3,110 (13,140) (16,250) Total revenues 1,360,360 1,360,360 1,479,067 118,707 Expenditures: Salaries and benefits 522,410 522,410 426,905 95,505 Office expense - 120 111 9 Computer maintenance & replacement 4,240 4,240 4,240 - Insurance 25,390 26,500 26,500 - Utilities 119,650 132,950 132,941 9 Communications 1,500 2,030 2,022 8 Operating supplies and equipment 45,120 36,790 36,056 734 Vehicle and equipment operations 72,340 78,910 78,910 - Contract services 134,800 121,370 79,347 42,023 Professional development 2,000 2,000 1,988 12 Recruitment 300 430 430 - Department service allocation 173,290 173,290 173,290 - Administrative charges 118,490 118,490 118,490 - Total expenditures 1,219,530 1,219,530 1,081,230 138,300 Excess of revenues over (under) expenditures 140,830 140,830 397,837 257,007 Budget Variance with Final Budget Positive (Negative) 126 CITY OF ATASCADERO GAS TAX FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE (continued) BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Other Financing Sources (Uses): 453,310$ 453,310$ 275,456$ (177,854)$ (333,810) (333,810) (6,512) 327,298 (150,000) (150,000) (234) 149,766 Total other financing sources (uses)(30,500) (30,500) 268,710 299,210 Net change in fund balance 110,330$ 110,330$ 666,547 556,217$ Fund balance, June 30, 2022 216,135 Fund balance, June 30, 2023 882,682$ Transfer out to Local Transportation Fund for Traffic Way Rehabilitation North (SB1) Budget Variance with Final Budget Positive (Negative) Transfer out to Local Transportation Fund for El Camino Real Rehabilitation South (SB1) Transfer from General Fund for street maintenance 127 CITY OF ATASCADERO STREET ASSESSMENT FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Taxes and special assessments- Lobos Lane 280$ 280$ 280$ -$ Taxes and special assessments- Sonora / Pinal 380 380 380 - Taxes and special assessments- Maleza 180 180 180 - Taxes and special assessments- San Fernando 580 580 580 - Taxes and special assessments- Aguila 100 100 100 - Taxes and special assessments- Pinal / Escarpa 180 180 180 - Taxes and special assessments- Cayucos 220 220 220 - Taxes and special assessments- Falda 240 240 240 - Interest income 780 780 1,217 437 Total revenues 2,940 2,940 3,377 437 Expenditures: Special projects and studies: Street maintenance projects 94,280 94,280 1,547 92,733 Total expenditures 94,280 94,280 1,547 92,733 Net change in fund balance (91,340)$ (91,340)$ 1,830 93,170$ Fund balance, June 30, 2022 86,127 Fund balance, June 30, 2023 87,957$ Variance with Final Budget Positive (Negative) Budget 128 CITY OF ATASCADERO GENERAL GOVERNMENT FACILITIES FEES FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Impact fees 40,000$ 40,000$ 80,686$ 40,686$ Interest income (5,220) (5,220) 3,383 8,603 Total revenues 34,780 34,780 84,069 49,289 Expenditures: Capital projects: Asset management software 420,000 420,000 - 420,000 New Fire department vehicle 4,870 4,870 3,897 973 New Parks department vehicle 45,000 47,400 47,393 7 Total expenditures 469,870 472,270 51,290 420,980 Excess of revenues over (under) expenditures (435,090) (437,490) 32,779 470,269 Other Financing Sources (Uses): - 2,400 2,393 (7) Total other financing sources (uses)- 2,400 2,393 (7) Net change in fund balance (435,090)$ (435,090)$ 35,172 470,262$ Fund balance, June 30, 2022 258,964 Fund balance, June 30, 2023 294,136$ Cash Contribution from General Fund for Vehicle Purchase Variance with Final Budget Positive (Negative) Budget 129 CITY OF ATASCADERO STORM DRAINAGE FACILITIES FEES FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Impact fees 36,000$ 36,000$ 62,051$ 26,051$ Interest income 10,180 10,180 5,963 (4,217) Total revenues 46,180 46,180 68,014 21,834 Net change in fund balance 46,180$ 46,180$ 68,014 21,834$ Fund balance, June 30, 2022 502,886 Fund balance, June 30, 2023 570,900$ Variance with Final Budget Positive (Negative) Budget 130 CITY OF ATASCADERO LAW ENFORCEMENT FACILITIES FEES FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Impact fees 40,000$ 40,000$ 40,355$ 355$ Interest income 4,650 4,650 6,614 1,964 Total revenues 44,650 44,650 46,969 2,319 Expenditures: Special projects and studies: Equipment for new police officers 32,580 32,580 3,942 28,638 Capital Projects: New police department vehicles 184,000 184,000 70,901 113,099 Total expenditures 216,580 216,580 74,843 141,737 Net change in fund balance (171,930)$ (171,930)$ (27,874) 144,056$ Fund balance, June 30, 2022 380,125 Fund balance, June 30, 2023 352,251$ Budget Variance with Final Budget Positive (Negative) 131 CITY OF ATASCADERO FIRE FACILITIES FEES FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Impact fees 40,000$ 40,000$ 59,048$ 19,048$ Rental income 10,800 10,800 - (10,800) Interest income 14,670 14,670 9,126 (5,544) Total revenues 65,470 65,470 68,174 2,704 Net change in fund balance 65,470$ 65,470$ 68,174 2,704$ Fund balance, June 30, 2022 1,452,845 Fund balance, June 30, 2023 1,521,019$ Budget Variance with Final Budget Positive (Negative) 132 CITY OF ATASCADERO OPEN SPACE ACQUISITION FEES FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Impact fees 55,000$ 55,000$ 102,878$ 47,878$ Interest income 18,070 18,070 11,048 (7,022) Total revenues 73,070 73,070 113,926 40,856 Net change in fund balance 73,070$ 73,070$ 113,926 40,856$ Fund balance, June 30, 2022 903,806 Fund balance, June 30, 2023 1,017,732$ Budget Variance with Final Budget Positive (Negative) 133 CITY OF ATASCADERO PARKLAND FACILITIES FEES FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Impact fees 150,000$ 150,000$ 279,079$ 129,079$ Interest income 5,350 5,350 3,186 (2,164) Donations- Pickleball Club 14,240 14,240 - (14,240) Total revenues 169,590 169,590 282,265 112,675 Expenditures: Special projects and studies: Atascadero Lake pipeline repairs - 19,630 19,624 6 2023 Storms- Atascadero Lake pipeline repairs - - 34,986 (34,986) Capital Projects: Atascadero Lake pipeline project 137,890 193,260 57,455 135,805 Atascadero Mall Plaza project 67,570 67,570 - 67,570 Pickleball courts at Colony Park 41,520 41,520 - 41,520 Total expenditures 246,980 321,980 112,065 209,915 Net change in fund balance (77,390)$ (152,390)$ 170,200 322,590$ Fund balance, June 30, 2022 592,081 Fund balance, June 30, 2023 762,281$ Budget Variance with Final Budget Positive (Negative) 134 CITY OF ATASCADERO PUBLIC FACILITIES FEES FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Impact fees 34,000$ 34,000$ 64,153$ 30,153$ Interest income 1,220 1,220 44 (1,176) Total revenues 35,220 35,220 64,197 28,977 Net change in fund balance 35,220$ 35,220$ 64,197 28,977$ Fund balance, June 30, 2022 88,290 Fund balance, June 30, 2023 152,487$ Budget Variance with Final Budget Positive (Negative) 135 CITY OF ATASCADERO LIBRARY EXPANSION FACILITIES FEES FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Impact fees 16,000$ 16,000$ 36,839$ 20,839$ Interest income 5,280 5,280 3,238 (2,042) Total revenues 21,280 21,280 40,077 18,797 Net change in fund balance 21,280$ 21,280$ 40,077 18,797$ Fund balance, June 30, 2022 273,522 Fund balance, June 30, 2023 313,599$ Budget Variance with Final Budget Positive (Negative) 136 CITY OF ATASCADERO COMMUNITY FACILITIES DISTRICT FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL Original Final Actual Amounts Revenues: Taxes and assessments 714,230$ 714,230$ 719,121$ 4,891$ Interest income 370 370 638 268 Total revenues 714,600 714,600 719,759 5,159 Expenditures: Contract services 5,300 5,300 5,334 (34) Total expenditures 5,300 5,300 5,334 (34) Excess of revenues over (under) expenditures 709,300 709,300 714,425 5,125 Other Financing Sources (Uses): (746,460) (746,460) (743,353) 3,107 Total other financing sources (uses)(746,460) (746,460) (743,353) 3,107 Net change in fund balance (37,160)$ (37,160)$ (28,928) 8,232$ Fund balance, June 30, 2022 28,928 Fund balance, June 30, 2023 -$ Transfer to the General Fund for police, fire and parks services For the Fiscal Year Ended June 30, 2023 Budget Variance with Final Budget Positive (Negative) 137 CITY OF ATASCADERO APPLE VALLEY STREET & STORM DRAIN ASSESSMENT DISTRICT FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL Original Final Actual Amounts Revenues: Taxes and assessments 38,500$ 38,500$ 38,500$ -$ Interest income 10,630 10,630 6,443 (4,187) Total revenues 49,130 49,130 44,943 (4,187) Expenditures: Office expense - 30 20 10 Advertising 200 170 127 43 Contract services 19,250 19,250 3,756 15,494 Administration 1,860 1,860 1,631 229 Total expenditures 21,310 21,310 5,534 15,776 Net change in fund balance 27,820$ 27,820$ 39,409 11,589$ Fund balance, June 30, 2022 508,789 Fund balance, June 30, 2023 548,198$ Budget For the Fiscal Year Ended June 30, 2023 Variance with Final Budget Positive (Negative) 138 CITY OF ATASCADERO APPLE VALLEY LANDSCAPE & LIGHTING ASSESSMENT DISTRICT FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL Original Final Actual Amounts Revenues: Taxes and assessments 63,000$ 63,000$ 63,000$ -$ Contributions from developer 11,000 11,000 11,000 - Interest income 3,070 3,070 3,175 105 Total revenues 77,070 77,070 77,175 105 Expenditures: Office expense - 30 20 10 Advertising 600 570 316 254 Utilities 14,440 14,440 6,043 8,397 Operating supplies 2,550 2,550 - 2,550 Contract services 62,080 62,080 43,630 18,450 Administration 2,160 2,160 1,569 591 Special projects and studies: Infrastructure improvements 32,000 32,000 24,970 7,030 Total expenditures 113,830 113,830 76,548 37,282 Net change in fund balance (36,760)$ (36,760)$ 627 37,387$ Fund balance, June 30, 2022 179,539 Fund balance, June 30, 2023 180,166$ For the Fiscal Year Ended June 30, 2023 Budget Variance with Final Budget Positive (Negative) 139 CITY OF ATASCADERO LAS LOMAS STREET & STORM DRAIN ASSESSMENT DISTRICT FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL Original Final Actual Amounts Revenues: Taxes and assessments 96,180$ 96,180$ 99,189$ 3,009$ Interest income 11,090 11,090 5,907 (5,183) Total revenues 107,270 107,270 105,096 (2,174) Expenditures: Office expense - 60 52 8 Advertising 300 240 127 113 Contract services 19,440 19,440 4,058 15,382 Administration 1,800 1,800 1,650 150 Special projects and studies: Slurry seal 374,000 - - - Total expenditures 395,540 21,540 5,887 15,653 Net change in fund balance (288,270)$ 85,730$ 99,209 13,479$ Fund balance, June 30, 2022 564,414 Fund balance, June 30, 2023 663,623$ Budget Variance with Final Budget Positive (Negative) For the Fiscal Year Ended June 30, 2023 140 CITY OF ATASCADERO LAS LOMAS LANDSCAPE & LIGHTING ASSESSMENT DISTRICT FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL Original Final Actual Amounts Revenues: Taxes and assessments 68,370$ 68,370$ 70,453$ 2,083$ Interest income 2,590 2,590 2,260 (330) Total revenues 70,960 70,960 72,713 1,753 Expenditures: Office expense - 60 51 9 Advertising 520 460 316 144 Utilities 6,120 6,770 6,764 6 Operating supplies 2,000 1,350 - 1,350 Contract services 88,390 88,220 49,629 38,591 Administration 1,400 1,570 1,568 2 Special projects and studies: Planting and landscape project 14,000 14,000 6,044 7,956 Total expenditures 112,430 112,430 64,372 48,058 Excess of revenues over (under) expenditures (41,470) (41,470) 8,341 49,811 Other Financing Sources (Uses): 2,600 2,600 2,600 - Total other financing sources (uses)2,600 2,600 2,600 - Net change in fund balance (38,870)$ (38,870)$ 10,941 49,811$ Fund balance, June 30, 2022 184,826 Fund balance, June 30, 2023 195,767$ Budget Variance with Final Budget Positive (Negative) For the Fiscal Year Ended June 30, 2023 Transfer from the General Fund for open space maintenance 141 CITY OF ATASCADERO DE ANZA STREET & STORM DRAIN ASSESSMENT DISTRICT FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL Original Final Actual Amounts Revenues: Taxes and assessments 30,560$ 30,560$ 30,561$ 1$ Interest income 10,170 10,170 6,413 (3,757) Total revenues 40,730 40,730 36,974 (3,756) Expenditures: Office expense - 30 25 5 Advertising 320 290 127 163 Contract services 20,300 20,300 3,756 16,544 Administration 1,600 1,600 1,569 31 Total expenditures 22,220 22,220 5,477 16,743 Net change in fund balance 18,510$ 18,510$ 31,497 12,987$ Fund balance, June 30, 2022 491,909 Fund balance, June 30, 2023 523,406$ For the Fiscal Year Ended June 30, 2023 Budget Variance with Final Budget Positive (Negative) 142 CITY OF ATASCADERO DE ANZA LANDSCAPE & LIGHTING ASSESSMENT DISTRICT FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL Original Final Actual Amounts Revenues: Taxes and assessments 17,460$ 17,460$ 15,874$ (1,586)$ Interest income 2,320 2,320 1,719 (601) Total revenues 19,780 19,780 17,593 (2,187) Expenditures: Office expense - 30 25 5 Advertising 500 470 316 154 Utilities 1,000 1,410 1,402 8 Operating supplies 500 90 - 90 Contract services 17,900 17,900 10,970 6,930 Administration 2,270 2,270 1,568 702 Special projects and studies: Landscape improvements 7,860 7,860 - 7,860 Total expenditures 30,030 30,030 14,281 15,749 Excess of revenues over (under) expenditures (10,250) (10,250) 3,312 13,562 Other Financing Sources (Uses): 1,400 1,400 1,400 - Total other financing sources (uses)1,400 1,400 1,400 - Net change in fund balance (8,850)$ (8,850)$ 4,712 13,562$ Fund balance, June 30, 2022 122,715 Fund balance, June 30, 2023 127,427$ Transfer from the General Fund for open space maintenance For the Fiscal Year Ended June 30, 2023 Budget Variance with Final Budget Positive (Negative) 143 CITY OF ATASCADERO CAPITAL PROJECTS FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Interest income 7,670$ 7,670$ 5,106$ (2,564)$ Total revenues 7,670 7,670 5,106 (2,564) Net change in fund balance 7,670$ 7,670$ 5,106 (2,564)$ Fund balance, June 30, 2022 354,732 Fund balance, June 30, 2023 359,838$ Variance with Final Budget Positive (Negative) Budget 144 CITY OF ATASCADERO 2010 BOND PROCEEDS MASTER AGREEMENT FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL For the Fiscal Year Ended June 30, 2023 Original Final Actual Amounts Revenues: Interest income -$ -$ 12,656$ 12,656$ Total revenues - - 12,656 12,656 Expenditures: Capital outlay: Centennial Bridge and Plaza project 252,160 5,570 - 5,570 Maiden statue placement 14,140 21,140 19,438 1,702 Downtown parking wayfinding signage 15,500 - - - Total expenditures 281,800 26,710 19,438 7,272 Excess of revenues over (under) expenditures (281,800) (26,710) (6,782) 19,928 Other Financing Sources: - (255,090) (255,090) - Total other financing sources (uses)- (255,090) (255,090) - Net change in fund balance (281,800)$ (281,800)$ (261,872) 19,928$ Fund balance, June 30, 2022 266,031 Fund balance, June 30, 2023 4,159$ Transfer to the Local Transportation Fund for the Downtown Infrastructure Enhancement Plan Budget Variance with Final Budget Positive (Negative) 145 CITY OF ATASCADERO INTERNAL SERVICE FUNDS COMBINING STATEMENT OF NET POSITION June 30, 2023 Technology Fund Vehicle and Equipment Replacement Fund Building Maintenance and Replacement Fund Totals ASSETS Current Assets: Cash and investments 2,173,800$ 7,694,668$ 8,831,440$ 18,699,908$ Receivables: Accrued interest 12,217 34,971 33,294 80,482 Prepaid expenses 6,121 - - 6,121 Total current assets 2,192,138 7,729,639 8,864,734 18,786,511 Capital Assets: Non-depreciable: Construction in progress 16,793 93,460 209,204 319,457 Depreciable: Vehicles & equipment 3,991,614 11,199,452 21,024 15,212,090 Structures and improvements - - 53,064,105 53,064,105 Accumulated depreciation (3,312,654) (7,499,912) (13,329,992) (24,142,558) Subscription assets, net 833,550 - - 833,550 Net capital assets 1,529,303 3,793,000 39,964,341 45,286,644 Total assets 3,721,441 11,522,639 48,829,075 64,073,155 DEFERRED OUTFLOWS Deferred outflows related to pensions 356,442 - 238,636 595,078 Total deferred outflows 356,442 - 238,636 595,078 LIABILITIES Current Liabilities: Accounts payable 112,648 25,649 15,605 153,902 Accrued salaries and benefits 20,578 - 9,132 29,710 Unearned revenue - - 900 900 Other payables 34,347 - - 34,347 Noncurrent Liabilities: Noncurrent liabilities 1,184,893 - 613,614 1,798,507 Total liabilities 1,352,466 25,649 639,251 2,017,366 146 CITY OF ATASCADERO INTERNAL SERVICE FUNDS COMBINING STATEMENT OF NET POSITION (continued) June 30, 2023 Technology Fund Vehicle and Equipment Replacement Fund Building Maintenance and Replacement Fund Totals DEFERRED INFLOWS Deferred inflows related to pensions 66,857$ -$ 27,152$ 94,009$ Total deferred inflows 66,857 - 27,152 94,009 NET POSITION Net investment in capital assets 1,529,303 3,793,000 39,964,341 45,286,644 Net subscription liability 415,756 - - 415,756 Unrestricted 713,501 7,703,990 8,436,967 16,854,458 Total net position 2,658,560$ 11,496,990$ 48,401,308$ 62,556,858$ 147 CITY OF ATASCADERO INTERNAL SERVICE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN NET POSITION For the Fiscal Year Ended June 30, 2023 Technology Fund Vehicle and Equipment Replacement Fund Building Maintenance and Replacement Fund Totals Operating Revenues: Charges for services 1,196,510$ 769,285$ 952,390$ 2,918,185$ Total operating revenues 1,196,510 769,285 952,390 2,918,185 Operating Expenses: Salaries and benefits 545,292 - 242,874 788,166 Office expense 1,389 - - 1,389 Computer maintenance, software and replacement - - 3,890 3,890 Insurance - - 83,804 83,804 Occupancy and rental costs 57,040 - - 57,040 Utilities - - 106,680 106,680 Communications 75,862 - 2,238 78,100 Operating supplies and services 23,418 - 24,163 47,581 Vehicle and equipment operating costs 2,911 - 17,220 20,131 Contract services 75,267 - 72,351 147,618 Professional development 6,797 - (16) 6,781 Recruitment 988 - - 988 Interest Expense 5,472 - - 5,472 Administrative charges 6,690 - 70,990 77,680 Special projects: Other Minor Equipment - - 2,864 2,864 HVAC Repairs - - 17,243 17,243 Amortization expense 115,483 - - 115,483 Depreciation expense 227,674 590,310 1,190,999 2,008,983 Total operating expenses 1,144,283 590,310 1,835,300 3,569,893 Operating income (loss)52,227 178,975 (882,910) (651,708) 148 CITY OF ATASCADERO INTERNAL SERVICE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN NET POSITION (continued) For the Fiscal Year Ended June 30, 2023 Technology Fund Vehicle and Equipment Replacement Fund Building Maintenance and Replacement Fund Totals Non-Operating Revenues (Expenses): Interest income 24,891$ (17,205)$ (90,674)$ (82,988)$ Gain (loss) on sale of capital assets - (222) - (222) Total non-operating revenues (expenses)24,891 (17,427) (90,674) (83,210) Change in net position prior to capital contributions 77,118 161,548 (973,584) (734,918) Capital Contributions: Cash contributions from other funds - 2,935,410 4,500,000 7,435,410 Capital contributions from other funds 311,747 406,687 139,990 858,424 Total capital contributions 311,747 3,342,097 4,639,990 8,293,834 Change in net position 388,865 3,503,645 3,666,406 7,558,916 Total net position, June 30, 2022 2,269,695 7,993,345 44,734,902 54,997,942 Total net position, June 30, 2023 2,658,560$ 11,496,990$ 48,401,308$ 62,556,858$ 149 CITY OF ATASCADERO INTERNAL SERVICE FUNDS COMBINING STATEMENT OF CASH FLOWS For the Fiscal Year Ended June 30, 2023 Technology Fund Vehicle and Equipment Replacement Fund Building Maintenance and Replacement Fund Totals Cash Flows From Operating Activities: Internal activity - payments from other funds 1,196,510$ 769,285$ 952,390$ 2,918,185$ Payments to suppliers of goods and services 286,072 17,628 (406,468) (102,768) Payments for employee services (660,309) - (310,251) (970,560) Net cash provided by operating activities 822,273 786,913 235,671 1,844,857 Acquisition of capital assets (675,064) (709,012) (28,009) (1,412,085) Cash contributions received for capital purchases - 2,935,410 4,500,000 7,435,410 Net cash provided (used) by capital and related financing activities (675,064) 2,226,398 4,471,991 6,023,325 Cash Flows From Investing Activities: Investment income (loss)19,537 (35,968) (109,369) (125,800) Net cash provided (used) by investing activities 19,537 (35,968) (109,369) (125,800) Net increase in cash and cash equivalents 166,746 2,977,343 4,598,293 7,742,382 Cash and cash equivalents - June 30, 2022 2,007,054 4,717,325 4,233,147 10,957,526 Cash and cash equivalents - June 30, 2023 2,173,800$ 7,694,668$ 8,831,440$ 18,699,908$ Cash Flows From Capital and Related Financing Activities: 150 CITY OF ATASCADERO INTERNAL SERVICE FUNDS COMBINING STATEMENT OF CASH FLOWS (continued) For the Fiscal Year Ended June 30, 2023 Technology Fund Vehicle and Equipment Replacement Fund Building Maintenance and Replacement Fund Totals Operating income (loss)52,227$ 178,975$ (882,910)$ (651,708)$ Amortization expense 115,483 - - 115,483 Depreciation expense 227,674 590,310 1,190,999 2,008,983 Prepaid expenses 27,779 - - 27,779 Accounts payable 64,024 17,628 (5,141) 76,511 Accrued salaries and benefits (900) - 935 35 Other payables 34,347 - - 34,347 Unearned revenue - - 100 100 Deferred outflows (258,544) - (149,774) (408,318) Deferred inflows (393,419) - (227,908) (621,327) Long-term subscriptions payable 415,756 - - 415,756 Net pension liability 527,463 - 305,559 833,022 Compensated absences 10,383 - 3,811 14,194 Net cash provided by operating activities 822,273$ 786,913$ 235,671$ 1,844,857$ Reconciliation of operating income (loss) to net cash provided by operating activities: Adjustments to reconcile operating income (loss) to net cash provided by operating activities: Change in assets, deferred outflows, liabilities, and deferred inflows: 151