Loading...
FISCAL YEAR 2023-24, QUARTER 1 ENDING SEPTEMBER 30, 2023CITY OF E A S T V A L E CALIFORNIA INTERIM FINANCIAL REPORT QUARTER ONE | 3 MONTHS F I S C A L Y E A R 2 0 2 3 - 2 0 2 4 Executive Summary City of Eastvale UNAUDITED Fiscal Year 2022-23 Interim Financial Report | QUARTER ONE ending September 30, 2023 | 3 months, 25% Reported City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 2 REPORT OVERVIEW On June 28, 2023, the City Council adopted the Fiscal Year 2023-24 budget. The interim financial report is prepared by the Finance Department and contains informa�on related to the fiscal year 2023-24 budget and actual ac�vity for revenues and expenditures for the 3-month period ending September 30, 2023. The figures contained in this report are unaudited for fiscal year 2022-23 and 2023-24. QUARTER 1 HIGHLIGHTS: Key changes impacting the city during the first quarter of fiscal year 2023-24 Prior Fiscal Year Notes: The city ended the prior fiscal year with a budget surplus of $31.3 million. The surplus is due to several factors. The overwhelming majority of the surplus is due to an increase in the city’s sales tax receipts. Addi�onally, the City experienced savings in its largest departments in the General Fund, General Government, Community Development, and Public Works. These departments had budget surpluses due to vacancies and capital improvement plan savings. First Quarter Notes: The first quarter of the fiscal year provides the least amount of data on budget performance, as less than 3 months of expenditure data is contained in the report. The city pays invoices within a 45-60 day window, meaning many payments for August and September have not been processed by September 30th. Addi�onally, most revenues are received a�er the start of the calendar year. As a result, the first quarter report includes limited data on both revenue and expenditure budget performance. Fund Balance: The city is projected to complete the year with $147.7 million in fund balance in the General Fund. A litle over $15.3 million is set aside as an assigned emergency reserve for opera�ons. Addi�onal assigned reserves include $29.5 to cover capital improvement project grants and $219,066 to cover special revenue fund nega�ve fund balances. A total of $9.5 million has been commited by the City Council for the Civic Center project and other capital reserves. The remaining $7.7 million of unassigned fund balance is available for emergency projects and situa�ons or can be assigned by City Council to new projects or the Civic Center project. The Fire Fund is projected to finish the fiscal year with $16.7 million in fund balance. An assigned emergency reserve of $5.9 million is set aside for opera�ons, and an addi�onal $2.0 million is assigned for the future third fire sta�on. An addi�onal $8.0 million was commited by the City Council for the future third fire sta�on, and $400,000 is commited as an equipment replacement reserve. This leaves $366,164 of unassigned fund balance. Sales Tax Monitoring: The Finance department con�nues to monitor revenues closely, par�cularly sales tax. A true- up payment applicable to quarter two ending December 31, 2020, has not yet been received. HdL originally believed the true up would be received in the 2021-22 fiscal year, however the State has s�ll not reallocated the payment. The true-up is es�mated at $8.0 million. More detail regarding sales tax is available in the atachments “General Fund Opera�ng Summary” and “Sales Tax Quarterly Summary.” Appropria�ons Limit: A summary report, “Appropria�ons Limit Summary,” is included in this report. The city exceeded the state mandated Appropria�ons Limit for fiscal year 2020-21, 2021-22, 2022-23, and 2023-24. The summary report details the city’s limit and revenues subject to appropria�ons and provides trend data for the last seven fiscal years. The city will con�nue to address the appropria�ons limit implica�ons during the budget and mid- year processes. The City Council commited funds that exceeded the limit towards capital outlay. This report does not include projections and only focuses on the City’s performance in comparison to budgeted estimates. Attached Detail Reports General Fund Summary by Category General Fund Summary by Department General Fund Opera�ng Summary Other Funds Revenue and Expenditure Summary City-Wide Fund Balances Assigned Reserve, Con�ngency Calcula�on Appropria�ons Limit Summary Sales Tax Quarterly Summary Executive Summary City of Eastvale UNAUDITED Fiscal Year 2022-23 Interim Financial Report | QUARTER ONE ending September 30, 2023 | 3 months, 25% Reported City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 3 Accounting Methods The figures presented in this execu�ve summary and the atached reports reflect general ledger balances as of September 30, 2023. Approximately 25% of the year has been reported. The city u�lizes an accrual basis of accoun�ng for all governmental funds, as required by the Generally Accepted Accoun�ng Standards (GAAP). To comply with GAAP, staff accrues revenues received and expenditures occurring in the months of July and August back to the month of June. This matches the transac�on to the period in which revenue was earned or the expenditure occurred. The figures in this report represent the audited figures for June 30, 2023, and the Finance Department’s best es�mate of revenues and expenditures for September 30, 2023, as of the published date of this report. GENERAL FUND OBSERVATIONS The city’s General Fund is the largest and most flexible of the city’s funds as it contains all unrestricted revenues and provides the most discre�on for expenditures. Major General Fund revenue sources include sales tax, property tax, franchise fees, permit fees, and intergovernmental. The General Fund holds the majority of services provided to the community including police services, community development, and general government. The General Fund Overview table provides budgeted revenues and expenditures in addi�on to actual revenues and expenditures. The percentage reflects the percentage of budget u�lized. Balanced Budge�ng – Per the city’s adopted Budget Policy, the total expenditure appropria�ons shall not exceed the total of es�mated revenues. In the adopted fiscal year 2023-24 budget, total General Fund expenditure appropria�ons did not exceed revenues and the total budget surplus totaled $20.3 million. Details regarding the city’s opera�ng statement can be found on page seven and in the Atachment General Fund Opera�ng Summary. Net Revenue/Change in Fund Balance - The General Fund will likely complete the fiscal year with $20.3 million in net revenue, also called a budget surplus (revenue minus expenditures), for the fiscal year 2023-24. These funds have been allocated towards capital infrastructure reserves; commited reserves were iden�fied during the 2023-24 budget process and adopted by council via resolu�on. It should be noted that the Fire Fund also consists of General Fund revenues, however due to agreements with Riverside County the fund is separated as an other-purpose general fund for budgeting purposes. The Fire Fund is collapsed into the General Fund on the city’s financial statements. Fire Fund information is in the section following the General Fund in this report. GENERAL FUND REVENUES As a general note, not all revenues are received monthly including sales tax, property tax, and franchise fees. The State of California provides monthly es�mated sales tax advance installments and issues the city a quarterly true-up a�er the State receives quarterly tax returns from businesses. A majority of property tax is typically received solely in the second half of General Fund Overview 3-Months Ended September 30, 2023 General Fund Overview Adjusted Budget Actual Ac�vity % Revenues 64,717,296 7,934,056 12% Expenditures 44,448,679 13,946,702 31% Surplus (Deficit) 20,268,618 (6,012,646) 0 10 20 30 40 50 60 70 80 2021-22 Actuals 2022-23 Actuals 2023-24 Budget 2023-24 ActualsTo-DateMillionsYear-by-Year Revenue and Expenditures Revenue Expenditure Executive Summary City of Eastvale UNAUDITED Fiscal Year 2022-23 Interim Financial Report | QUARTER ONE ending September 30, 2023 | 3 months, 25% Reported City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 4 the fiscal year and as a result, a large por�on of property tax revenues have not yet been received for the fiscal year. Franchise fees are received quarterly, a�er the quarter ends. Overall, actual revenues stand at 12% of budget due solely to the issue listed above. Overall, General Fund revenues are at $7,934,056. Detail of Specific Revenue Categories Sales Tax – Sales tax revenues are highly indica�ve of economic circumstances. The city u�lizes HdL Companies for sales tax analysis. Budget currently stands at $46.3 million. For the first quarter repor�ng period, only July sales tax revenues have been received, totaling $3.6 million. Sales tax is the city’s largest revenue source and for monitoring purposes staff created an Atachment to this report �tled Sales Tax Summary. Although taxes were not received in the repor�ng period, first quarter taxes have been received as of the publish date of this quarterly report. First quarter sales taxes came in at $11.7 million, which is on target with budget projec�ons. It should be noted that because these revenues were not received during the first quarter, all other reports omit these sales tax revenues. Property Tax – Property tax revenues are based solely on the valua�on of property, both secured and unsecured, within the city. Secured property is property including land and buildings; unsecured property includes equipment and machinery. Property tax revenues are typically received in the second half of the fiscal year. Actual revenues are at $33,435 or 1% of budget. Franchise Fees – This category is typically comprised of regular recurring revenues from solid waste collec�on, cable u�li�es, electric u�li�es, and natural gas u�li�es. Franchise fees stand at $185,539 or 8% of budget. Only one first quarter payment for electric fees was received before the end of the quarter. The majority of regular and recurring franchise fee payments have not yet been received for the first quarter. Licenses, Fees, and Permits – Unlike tax revenues, this category of revenue is received on a daily basis at the city’s front counter and is comprised of construc�on, planning, building permits and fees, and business registra�on. Overall, this category is at $656,911 or 27% of budget. Contracted services and employee wages drive the fees charged to private developers for planning and building fees. Within the category, specific divisions and types of fees performed differently during the first quarter. As departments, Community Development, Engineering, and Community Services appear on trend; budget is at 28%, 27%, and 29% respec�vely. More specifically, building fixed fees are at 22% of budget, which is a litle low compared to the prior year and may be indica�ve of a drop in building permits. Encroachment development fees are exceeding budget es�mates at 34%. Legal fees are on target at 28%. Passport service revenues are below budget projec�ons at 15%; although passport service demand remains heightened, the department’s passport service posi�on was vacant for the month of July. Business registra�on fees on target at 27% of budget. Sales & Use Tax71% Intergovernmental 10% Property Taxes 6% License, Permits & Fees 4% Franchise Fees 4% Use of Money & Property3% Fines, Penalties & Forfeitures1% Transfers In 1%Miscellaneous 0.25% Revenue Budget Breakdown Executive Summary City of Eastvale UNAUDITED Fiscal Year 2022-23 Interim Financial Report | QUARTER ONE ending September 30, 2023 | 3 months, 25% Reported City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 5 Intergovernmental – This category is populated by Vehicle License in Lieu fees (VLF). VLF revenues are typically received in the last six months of the fiscal year, 50% within quarter three and the final 50% in quarter four. As a result, actuals stand at zero. Use of Money and Property – This category is populated investment income. Budget was es�mated at $2,100,000 and actuals are at $2,830,966, or 135% of budget. Net of an unrealized gain reversal from the prior year required by the Government Accoun�ng Standards Board, interest stands at $686,819, or 33% of budget, which is on target with budget es�mates. Transfers In – This category stands at 100%. The category consists of transfers-in to the General Fund from other funds. Transfers include the $531,786 for the city’s cost alloca�on plan (CAP). The CAP is an administra�ve charge to other funds to help fund the cost of General Fund internal services such as informa�on technology, finance, and human resources. Overall, General Fund revenues are at $7,934,056 or 12% of budget. ADDITIONAL INFORMATION ABOUT MAJOR REVENUE SOURCES Detail Information on General Fund Sales and Property Tax Revenue Categories Sales Tax: Sales tax is the number one revenue source for the General Fund. For every dollar of sales tax paid, only $0.13 is received by the City of Eastvale. The other $0.87 goes to the State General Fund ($0.51), the State Local Revenue Fund ($0.14), Riverside County Transporta�on Commission ($0.06), a State Local Revenue Fund specific to local health and social services programs ($0.06), State Local Public Safety Fund ($0.06), and the Riverside County Transporta�on Fund ($0.03). For more informa�on on what agencies receive sales tax revenue go to: www.cd�a.ca.gov/taxes-and-fees/sut-rates-descrip�on.htm Property Tax: Property tax is the number four largest revenue source for the city’s General Fund and is the number one revenue source for the city’s Fire Fund. However, like sales tax every dollar of base property tax that a property owner pays only $0.02 is received by the city’s General Fund; another $0.06 is received by the city’s Fire Fund. Over $0.51 goes towards educa�on to the Corona Norco Unified School district, Riverside Community College, and Riverside County Office of Educa�on. Riverside County receives $0.29. The remaining $0.04 goes to several special districts and flood control administra�on. The property tax revenues received by the Fire Fund are restricted to Fire Services expenditures. This breakdown of costs is only for the base property tax rate. Many Eastvale residents also pay levies for special assessments, including special financing districts, such as landscape ligh�ng maintenance districts and community facility districts. For more informa�on about special financing districts in Eastvale go to: www.eastvaleca.gov/government/ finance- department/special-financing-districts $0.51 State General Fund $0.14 State Local Revenue Fund $0.13 EASTVALE $0.06 RIVCO RCTC $0.06 State Local Rev $0.06 State Local Safety $0.03 RIVCO Transporta�on For every $1 of paid sales tax, the city only receives 13 cents. The remainder is spread among State and County agencies. Executive Summary City of Eastvale UNAUDITED Fiscal Year 2022-23 Interim Financial Report | QUARTER ONE ending September 30, 2023 | 3 months, 25% Reported City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 6 GENERAL FUND EXPENDITURES A comparison of the adjusted budget to actual expenditures provides an overview of how actual expenditures compare to the city’s budget. Overall, actual expenditures are at $13,946,702 or 31% of budget. Detail of Specific Expenditure Categories Contract Services – This category is the largest category and includes contract services for law enforcement, building and safety, planning, and public works. Currently, actual expenditures for the total contract category are $226,584 or 1% of budget; total budget for this category is $17.9 million. The largest expenditure within this category is the Law Enforcement contract with Riverside County Sheriff; budget for law enforcement totals $14.1 million. Other major contracts in this category are animal control, crossing guards, legal services, and support services for all major departments. Many invoices for first quarter services have not been processed as of September 30th; as a result, this category appears unusually low. Personnel – The personnel category contains the salary and benefit costs for city employees. This category generated actual expenditures at $1,590,693 or 17% of budget. Staff expects to see savings in this category due to new posi�ons remaining vacant during recruitment during the first quarter, including six Public Works posi�ons, three Community Safety posi�ons, two Community Development posi�ons, and two City Clerk posi�ons. Much of the savings in Community Safety and Public Works will be u�lized to offset contract services in those departments due to the need to contract for services while the posi�ons remained vacant. Opera�ons – Opera�ons is a broad category including supplies, adver�sing, u�li�es, postage, and janitorial. Actual expenditures in this category are at $755,173 or 17% of budget. Capital Outlay – Capital outlay consists of office equipment, computer hardware and so�ware, furniture, and fixtures with a cost greater than $5,000. This category is at $288,584 or 42% of budget. Most of the city’s so�ware contracts are paid in advance in July for the en�re fiscal year, causing a front loading of expenditures. This category also houses capital expenditures for a new truck and equipment for the city’s first Commercial Enforcement Officer posi�on in Law Enforcement. Debt Service – Debt service in the General Fund accounts for the revenue neutrality agreement with Riverside County. The agreement was based on es�mated tax revenue losses experienced by Riverside County as a result of the city’s incorpora�on; the obliga�on is paid to Riverside County through both the General Fund and the Fire Fund. The County invoices the city towards the end of the fiscal year, as a result, actuals stands at zero. Budget for revenue neutrality is $320,000. Transfers-Out – The transfers-out category in the General Fund accounts for the movement of cash from the General Fund to another fund. Budget includes $9,967,662 million in transfers out to the General Capital Improvement Fund, $1,020,000 for capital maintenance reserves, and $19,640 for General Fund benefit contribu�ons for several Landscape and Ligh�ng Maintenance Districts and one Benefit Assessment District. This benefit contribu�on and the capital maintenance reserve contribu�ons are the only opera�ng transfers within the category. Contract Services 55% Personnel 28% Operations 13% Capital Outlay 2% Maintenance 1% Debt Service 1% Expenditure Budget Breakdown Executive Summary City of Eastvale UNAUDITED Fiscal Year 2022-23 Interim Financial Report | QUARTER ONE ending September 30, 2023 | 3 months, 25% Reported City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 7 Overall, the General Fund is at $13,946,702 or 31% of expenditure budget. GENERAL FUND OPERATING STATEMENT General Fund Operating Statement - The General Fund is currently expected to generate $31,102,296 in operating revenues and $33,461,017 in operating expenditures. Operating expenditures exceed revenues and as a result, the General Fund has an operating deficit of $2,358,721. On the non-operating side, the General Fund is expected to bring in $33,615,000 in non-operating revenues and $10,987,662 in non-operating expenditures. Non-operating revenues exceed expenditures and as a result, the General Fund has a non- operating surplus of $22,627,338 and the city is utilizing these non-operating revenues to support operating costs. Non- operating revenues are comprised of two sources of revenue, sales tax and interest. The sales tax revenue represents a local business in the business and industry category that changed business structure and as a result county pool sales tax was redistributed to host cities. At this time, staff considers this new sales tax source as one-time and non-operating in nature as the stability of the revenue is unknown. As a result, the revenue will be set aside for future capital improvement projects, such as the city’s civic center development at the Leal Property. The interest represents investment earnings on reserves for the civic center project; these reserves will be depleted within the next two to three fiscal years. As a result, staff views the investment earnings as non-operating. Non-operating expenditures consist of transfers out for the city’s capital replacement reserves and capital improvement plan. As of September 30th, total net revenue is ($6,012,646). FIRE FUND OBSERVATIONS The city’s Fire Fund contains all revenues and expenditures related to the provision of fire services in the city. The Fire Fund is considered General Fund monies; however, it has been restricted by Riverside County through the city’s revenue neutrality agreement and therefore is separated from the city’s unrestricted General Fund. Revenues – Major Fire Fund revenue sources include property tax, licenses, permits, and fees, and use of money and property. Property tax, like the General Fund is primarily received in the second half of the fiscal year. Property tax is currently at 0% of budget. Property tax is the largest single source of revenue for the Fire Fund. Licenses, permits, and fees are at 9% of budget, primarily due to a significant decrease in fire plan check permits. Investment income populates the category of use of money and property. Budget was es�mated at $200,000 and actuals are at $104,498 or 52% of budget. Staff will likely request a budget appropria�on at mid-year to recognize the increase in investment earnings. Overall, Fire Fund revenues are at $112,838 or 1% of budget. Expenditures – The prior year fourth quarter invoice for Riverside County Fire contract services was accrued to the prior year in the first quarter, but was not recognized as an expenditure un�l the second quarter. As a result, there is a nega�ve $1.6 million accoun�ng entry in the first period causing the contract service category to appear upside down. The first General Fund Operating Statement as of 09/30/2023 Operating Revenue Actuals 7,781,770 Operating Expenditure Actuals 2,959,040 Operating Surplus 4,822,729 Non-Operating Revenue Actuals 152,286 Non-Operating Expenditure Actuals 10,987,662 Non-Operating Surplus (10,835,376) Net Revenue (6,012,646) Fire Fund Overview 3-Months Ended September 30, 2023 General Fund Overview Adjusted Budget Actual Ac�vity % Revenues 8,692,500 112,838 1% Expenditures 8,886,850 (1,572,762) (18%) Surplus (Deficit) (194,350) (1,459,925) Executive Summary City of Eastvale UNAUDITED Fiscal Year 2022-23 Interim Financial Report | QUARTER ONE ending September 30, 2023 | 3 months, 25% Reported City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 8 quarter invoice for the new fiscal year has not been received as of the publish date of this report. As a result, net of the prior year entry, contract services are at $10,407 or 0.14% of budget. Opera�ons is a broad category including supplies, adver�sing, u�li�es, postage, and janitorial. Maintenance and opera�ons actuals are at 14% and 5% respec�vely. Maintenance and opera�ons include building maintenance, vehicle maintenance and fuel, and u�li�es. Actual expenditures in the opera�ons category are at $11,782 or 5% of budget. Maintenance stands at $9,310 or 14% of budget. Capital outlay is budgeted at $1,015,000 and is solely for the design of the city’s third fire sta�on. This budget is considered one-�me, non—opera�onal and will not con�nue into the future. Overall, the Fire Fund is at ($1,572,762) or (18%) of expenditure budget, mostly due to the first quarter CalFIRE invoice remaining outstanding and the required accrual entry for the prior year invoice. Net Revenue – The Fire Fund is currently projected to complete the fiscal year with a nega�ve net revenue balance of ($194,350), for the fiscal year 2023-24. The budget shor�all is due to the capital outlay budget of $1.0 million for the city’s third fire sta�on. OTHER FUND OBSERVATIONS The city’s other funds consist of governmental special revenue funds and six funds solely consis�ng of General Fund contribu�ons, the Capital Projects Fund, the Debt Service Fund, and four capital replacement reserve funds. These funds were created in order to track capital projects funded by the General Fund and debt. MAJOR SPECIAL REVENUE FUNDS Capital Projects Fund – This fund was considered a major fund for the 2022-23 financial audit. Revenues are solely from the General Fund and the purpose of the fund is to track specific one-�me general-fund capital improvement projects. The fund holds adequate fund balance to cover budgeted expenditures and does not build fund balance over �me. Major projects for the fiscal year include the Limonite Gap Bridge, I-15 Corridor Landscaping Improvement, Prado Dam Inunda�on U�lity Mi�ga�on, Hamner Place Beau�fica�on, Civic Center Design, and Citrus Property Modular Offices. NEGATIVE FUND BALANCE IN SPECIAL REVENUE FUNDS Several special revenue funds currently have and are projected to complete the year with nega�ve fund balance. According to GASB requirements the General Fund will be required to cover those nega�ve fund balances at the end of the fiscal year. Gas Tax is projected to complete the fiscal year with a nega�ve fund balance, this was a Capital Improvement Plan over-budge�ng error that will be corrected during the mid-year process. The TDA fund is also projected to finish the fiscal year with a nega�ve fund balance. During the audit process, Finance staff discovered that TDA projects and funding were incorrectly budgeted in the Miscellaneous Grants Fund. A correc�on will be processed during the Mid- Year process. The Miscellaneous Grants Fund is projected to have a significant nega�ve fund balance of $11.4 million. This fund is reimbursed in two ways, progress payments at certain milestone points during projects or a�er projects are -4 -2 0 2 4 6 8 10 2021-22 Actuals 2022-23 Actuals 2023-24 Budget 2023-24 ActualsMillionsYear-by-Year Revenue and Expenditures Revenue Expenditure Executive Summary City of Eastvale UNAUDITED Fiscal Year 2022-23 Interim Financial Report | QUARTER ONE ending September 30, 2023 | 3 months, 25% Reported City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 9 completed. Currently, the fund has outstanding milestone and completed project reimbursements. Public Works is working on submi�ng reimbursement requests. The TUMF Reimbursement Fund has a comparable situa�on as the Miscellaneous Grants Fund and the city is wai�ng to receive reimbursements. The city transferred over 88 ligh�ng maintenance districts and illumina�on districts from Jurupa Community Services District in the current fiscal year and several of those districts arrived with nega�ve fund balance. The General Fund will contribute to those funds to cover the nega�ve fund balance. A Note Regarding Government Accounting and Budgeting Most agencies manage governmental funds and budgets using a method called “modified accrual” accoun�ng. Modified accrual means that governmental funds are managed on a cash basis throughout the year. At year-end accruals are processed to ensure revenues and expenditures are recorded in the appropriate fiscal year in which the transac�ons actually occurred. This method applies to all the city’s funds (General Fund and Special Revenue funds). As an illustra�on, revenue is recorded as it is received throughout the fiscal year (cash basis). The majority of General Fund revenues are received sporadically throughout the year, and most is received or accrued in the final nine months of the fiscal year. Meanwhile, expenditures con�nue each month, regardless of whether revenues have been received. This circumstance highlights the importance of maintaining an adequate opera�ng reserve that allows for cash flow needs throughout the fiscal year, especially during months in which some revenues categories are not received. CITY OF EASTVALE Fiscal Year 2023-24Interim Financial Report | QUARTER ONE ending June 30, 2023 | 3 months General Fund Summary by Category Audited Actuals Unaudited Actuals Amended Budget Actuals Amount Over(Under) Budget Description 2021-22 2022-23 2023-24 9/30/2023 2023-24 GENERAL FUND RevenuesProperty Taxes 3,662,139$ 4,004,362$ 3,817,700$ 33,435 1%(3,784,265)$ Sales & Use Tax 44,710,286 47,356,371 46,250,000 3,637,325 8%(42,612,675) Franchise Fees 1,971,912 6,556,660 2,390,000 185,539 8%(2,204,461) License, Permits & Fees 2,333,526 2,347,535 2,436,750 656,911 27%(1,779,839) Fines, Penalties & Forfeitures 567,641 724,866 784,000 58,079 7%(725,921) Intergovernmental 6,367,511 6,077,206 6,245,000 - 0%(6,245,000) Use of Money & Property 151,235 1,511,747 2,100,000 2,830,966 135%730,966 Miscellaneous 772,062 299,556 162,060 15 0%(162,045) Transfers In 7,417,458 298,240 531,786 531,786 100%- Total General Fund Revenues 67,953,770 69,176,543 64,717,296 7,934,056 12%(56,783,240) Expenditures Salaries 3,824,393$ 4,612,233$ 6,606,056$ 1,183,733 18%(5,422,323)$ Benefits 1,356,725 1,515,650 2,628,414 406,960 15%(2,221,454) Contract Services 13,945,325 15,778,352 17,882,051 226,584 1%(17,655,467) Maintenance 205,290 345,138 408,500 78,366 19%(330,134) Operations 4,497,708 1,561,606 4,381,335 755,173 17%(3,626,162) Capital Outlay 187,826 758,553 691,270 288,584 42%(402,686) Debt Service 3,109,421 533,242 320,000 - 0%(320,000) Transfers Out 6,597,427 12,761,462 11,531,052 11,007,302 95%(523,750) Total General Fund Expenditures 33,724,114 37,866,236 44,448,679 13,946,702 31%(30,501,976) NET REVENUE 34,229,656 31,310,307 20,268,618 (6,012,646) OTHER PURPOSE GENERAL FUNDS RESTRICTED STRUCTURAL FIRE FUND RevenuesProperty Taxes (Restricted for Fire Services)7,601,854$ 8,379,338$ 8,400,000$ - 0%(8,400,000)$ Sales & Use Tax - - - - 0%- Franchise Fees - - - - 0%- Other Taxes - - - - 0%- License, Permits & Fees 94,451 77,971 90,000 8,339 9%(81,661) Fines, Penalties & Forfeitures - 92,793 2,500 - 0%(2,500) Intergovernmental - -- - 0%- Use of Money & Property (1,616) 432,432 200,000 104,498 52%(95,502) Miscellaneous - - - - 0%- Transfers - - - - 0%- Total Fire Fund Revenues 7,694,689 8,982,534 8,692,500 112,838 1%(8,579,662) Expenditures Salaries 808$ -$ -$ - 0%-$ Benefits - - - - 0%- Contract Services 5,654,282 6,298,267 7,234,950 (1,593,855) -22%(8,828,805) Maintenance 56,463 70,167 65,000 9,310 14%(55,690) Operations 447,634 (87,248) 251,900 11,782 5%(240,118) Capital Outlay 38,200 26,094 1,015,000 - 0%(1,015,000) Debt Service 262,228 272,717 320,000 - 0%(320,000) Transfers Out - - - - 0%- Total General Fund Expenditures 6,459,615 6,579,997 8,886,850 (1,572,762) -18%(10,459,612) NET REVENUE 1,235,074 2,402,537 (194,350) (1,459,925) % Budget Used City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 10 CITY OF EASTVALE Fiscal Year 2023-24Interim Financial Report | QUARTER ONE ending June 30, 2023 | 3 months General Fund Summary by Departments Audited Actuals Unaudited Actuals Amended Budget Actuals % Budget Amount Over(Under) Budget Description 2021-22 2022-23 2023-24 9/30/2023 Used 2023-24 GENERAL FUND Revenues General Services Non Departmental 65,076,959$ 66,138,827$ 61,551,546$ 7,227,680 12%(54,323,866)$ City Clerk 54,411 74,273 70,150 10,684 15%(59,466) City Manager 10,258 - - - 0%- Finance 126,297 145,228 100,100 27,094 27%(73,006) General Government - - - - 0%- City Attorney 80,205 22,944 44,000 12,386 28%(31,614) Subtotal General Services 65,348,130 66,381,272 61,765,796 7,277,844 12%(54,487,952) Community Development Community Development 209,777$ 117,231$ 220,000$ 61,789 28%(158,211)$ Subtotal Community Development 209,777 117,231 220,000 61,789 28%(158,211) Public Works Public Works 854,409$ 778,728$ 730,000$ 199,068 27%(530,932)$ Subtotal Community Development 854,409 778,728 730,000 199,068 27%(530,932) Community Safety Community Safety 905,318$ 1,240,799$ 1,183,000$ 340,186 29%(842,814)$ Subtotal Community Safety 905,318 1,240,799 1,183,000 340,186 29%(842,814) Public Safety Public Safety 636,137$ 658,514$ 818,500$ 55,169 7%(763,331)$ Subtotal Public Safety 636,137 658,514 818,500 55,169 7%(763,331) Total General Fund Revenues 67,953,770 69,176,543 64,717,296 7,934,056 12%(56,252,307) Expenditures General Services 100 City Council 224,419$ 162,650$ 240,168$ 34,351 14%(205,818)$ 110 City Attorney 317,860 295,852 370,000 - 0%(370,000) 290 General Government 11,394,573 12,680,685 12,836,652 11,065,141 86%(1,771,512) Subtotal General Services 11,936,851 13,139,186 13,446,820 11,099,491 83%(2,347,329)$ City Manager 200 City Manager 609,470$ 521,256$ 696,806$ 124,355 18%(572,451)$ Subtotal City Manager 609,470 521,256 696,806 124,355 18%(572,451)$ Human Resources & Risk 220 Human Resources 651,178$ 601,869$ 845,629$ 188,233 22%(657,396)$ 230 Risk Management 386,678 388,154 820,320 537,178 65%(283,142) Subtotal Human Resources & Risk 1,037,856 990,024 1,665,949 725,411 44%(940,538)$ City Clerk/Communications 120 City Clerk 444,667$ 579,863$ 613,451$ 92,514 15%(520,937)$ 240 Information Technology 304,454 289,575 429,564 53,976 13%(375,587) 260 Communications 244,365 320,256 504,916 66,672 13%(438,244) 720 Events 682,857 1,003,507 1,059,568 105,380 10%(954,188) Subtotal City Clerk/Communication 1,676,343 2,193,201 2,607,499 318,543 (2,288,956)$ Finance 210 Finance 910,324$ 1,139,254$ 1,362,560$ 221,287 16%(1,141,273)$ Subtotal Finance 910,324 1,139,254 1,362,560 221,287 16%(1,141,273)$ Community Development City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 11 CITY OF EASTVALE Fiscal Year 2023-24Interim Financial Report | QUARTER ONE ending June 30, 2023 | 3 months General Fund Summary by Departments Audited Actuals Unaudited Actuals Amended Budget Actuals % Budget Amount Over(Under) Budget Description 2021-22 2022-23 2023-24 9/30/2023 Used 2023-24 301 Administration 1,108,869$ 1,356,552$ 858,644$ 163,313 19%(695,332)$ 300 Planning 610,794 686,329 989,413 81,216 8%(908,197) 302 Economic Development - - 619,485 67,248 11%(552,237) Subtotal Community Development 1,719,663 2,042,881 2,467,543 311,777 13%(2,155,765)$ Public Works 320 Engineering 1,447,314$ 1,419,521$ 2,983,329$ 308,171 10%(2,675,157)$ 500 Public Works 368,711 275,437 823,876 97,849 12%(726,027) 295 Facility Maintenance 467,728 557,645 353,147 154,779 44%(198,368) 296 Facility Landscaping - 181,504 176,087 46,272 26%(129,815) 600 Landscaping (public right-of-way)1,074 - - - 0%- Subtotal Community Development 2,284,828 2,434,108 4,336,439 607,071 14%(3,729,367)$ Community Safety 311 Administration 19,679$ 315,828$ 786,126$ 84,985 11%(701,141)$ 310 Building Safety 1,337,997 1,273,580 1,541,986 (7,276) 0%(1,549,262) 330 Community Enhancement & Safety 764,036 811,417 985,684 184,816 19%(800,868) Subtotal Community Safety 2,121,711 2,400,825 3,313,796 262,525 8%(3,051,271)$ Public Safety 400 Law Enforcement 11,097,700$ 12,621,198$ 14,061,266$ 252,438 2%(13,808,829)$ 430 Animal Control 233,268 276,155 350,000 23,804 7%(326,196) 440 Crossing Guards 96,099 108,149 140,000 - 0%(140,000) Subtotal Public Safety 11,427,066 13,005,502 14,551,266 276,242 2%(14,275,025)$ Total General Fund Expenditures 33,724,114 37,866,236 44,448,679 13,946,702 31%(30,501,976) TOTAL GENERAL FUND NET REVEN 34,229,656 31,310,307 20,268,618 (6,012,646) OTHER PURPOSE GENERAL FUNDS RESTRICTED STRUCTURAL FIRE FUND Revenues Property Taxes (Restricted for Fire Serv 7,601,854$ 8,379,338$ 8,400,000$ - 0%(8,400,000)$ Sales & Use Tax - - - - 0%- Franchise Fees - - - - 0%- Other Taxes - - - - 0%- License, Permits & Fees 94,451 77,971 90,000 8,339 9%(81,661) Fines, Penalties & Forfeitures - 92,793 2,500 - 0%(2,500) Intergovernmental - - - - 0%- Use of Money & Property (1,616) 432,432 200,000 104,498 52%(95,502) Miscellaneous - - - - 0%- Transfers - - - - 0%- Total Fire Fund Revenues 7,694,689 8,982,534 8,692,500 112,838 1%(8,579,662) Expenditures Public Safety 290 General Government 504,045$ 30,899$ 320,000$ - 0%(320,000)$ 295 Building Maintenance 184,581 145,792 133,900 20,364 15%(113,536) 296 Facility Landscaping - 22,065 66,000 6,596 10%(59,404) 320 Engineering 808 - - - 0%- 420 Fire Services 5,770,182 6,381,240 8,366,950 (1,599,723) -19%(9,966,673) Total Fire Fund Expenditures 6,459,615 6,579,997 8,886,850 (1,572,762)-18%(10,459,612)$ TOTAL FIRE FUND NET REVENUE 1,235,074 2,402,537 (194,350) 1,685,600 City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 12 CITY OF EASTVALE Fiscal Year 2023-24Interim Financial Report | QUARTER ONE ending June 30, 2023 | 3 months General Fund Operating Summary Audited Actuals Unaudited Actuals Amended Budget Actuals % Budget Amount Over(Under) Budget Description 2021-22 2022-23 2023-24 9/30/2023 Used 2023-24 GENERAL FUND Operating Revenues Property Taxes 3,662,139$ 4,004,362$ 3,817,700$ 33,435 1%(3,784,265)$ Sales & Use Tax 11,910,286 16,956,371 14,000,000 1,787,325 13%(12,212,675) Franchise Fees 1,971,912 2,556,660 2,390,000 185,539 8%(2,204,461) License, Permits & Fees 2,333,526 2,347,535 2,436,750 656,911 27%(1,779,839) Fines, Penalties & Forfeitures 567,641 724,866 784,000 58,079 7%(725,921) Intergovernmental 6,367,511 6,077,206 6,245,000 - 0%(6,245,000) Use of Money & Property 172,785 536,747 735,000 4,528,679 616%3,793,679 Miscellaneous 772,062 299,556 162,060 15 0%(162,045) Transfers In 57,239 298,240 531,786 531,786 100%- Total General Fund Operating R 27,815,101 33,801,543 31,102,296 7,781,770 25%(23,320,526) Operating Expenditures Salaries 3,824,393$ 4,612,233$ 6,606,056$ 1,183,733 18%(5,422,323)$ Benefits 1,356,725 1,515,650 2,628,414 406,960 15%(2,221,454) Contract Services 13,945,325 15,778,352 17,882,051 226,584 1%(17,655,467) Maintenance 205,290 345,138 408,500 78,366 19%(330,134) Operations 3,192,633 1,561,606 4,381,335 755,173 17%(3,626,162) Capital Outlay 187,826 758,553 691,270 288,584 42%(402,686) Debt Service 1,250,371 533,242 320,000 - 0%(320,000) Transfers Out 735,475 2,442,453 543,390 19,640 4%(523,750) Total General Fund Operating E 24,698,037 27,547,227 33,461,017 2,959,040 9%(30,501,976) NET OPERATING REVENUE 3,117,064 6,254,316 (2,358,721) 4,822,729 Non-Operating Revenues Sales Tax 32,800,000$ 30,400,000$ 32,250,000$ 1,850,000$ 6%(30,400,000)$ Franchise Fees (Retention Fees)- 4,000,000 - 0%- Use of Money and Property (Interes 384,586 975,000 1,365,000 446,433 33%(918,567) Use of Money and Property (Unrea (406,136) - - (2,144,146) 0%(2,144,146) Miscellaneous GASB 87 - - - - 0%- Transfers In (ARPA SLFRF)7,360,219 - - - 0%- Total General Fund Non-Operat 40,138,669 35,375,000 33,615,000 152,286 -5%(33,462,714) Non-Operating Expenditures Operations (Unrealized Loss)1,305,075$ -$ - -$ 0%-$ Capital Outlay (GASB 87)- - - 0%- Debt Service (Tarpon Properties Pay 1,859,050 - - - 0%- Transfers Out (Streetlight Payoff)3,808,933 - - - 0%- Transfers Out (Capital Replacement Reserves)1,303,652 1,020,000 1,020,000 100%- Transfers Out (CIP)2,053,019 9,015,357 9,967,662$ 9,967,662 100%- Total General Fund Non-Operat 9,026,077 10,319,009 10,987,662 10,987,662 100%- NET NON-OPERATING REVENUE 31,112,592 25,055,991 22,627,338 (10,835,376) City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 13 CITY OF EASTVALE Fiscal Year 2023-24Interim Financial Report | QUARTER ONE ending June 30, 2023 | 3 months General Fund Operating Summary Audited Actuals Unaudited Actuals Amended Budget Actuals % Budget Amount Over(Under) Budget Description 2021-22 2022-23 2023-24 9/30/2023 Used 2023-24 OTHER PURPOSE GENERAL FUNDS RESTRICTED STRUCTURAL FIRE FUND - Operating Revenues Property Taxes (Restricted for Fire S 7,601,854$ 8,379,338$ 8,400,000$ - 0%(8,400,000)$ Sales & Use Tax - - - - 0%- Franchise Fees - - - - 0%- Other Taxes - - - - 0%- License, Permits & Fees 94,451 77,971 90,000 8,339 9%(81,661) Fines, Penalties & Forfeitures - 92,793 2,500 - 0%(2,500) Intergovernmental - - - - 0%- Use of Money & Property (1,616) 432,432 200,000 104,498 52%(95,502) Miscellaneous - - - - 0%- Transfers - - - - 0%- Total Fire Fund Revenues 7,694,689 8,982,534 8,692,500 112,838 1%(8,579,662) Operating Expenditures Salaries 808$ -$ -$ - 0%-$ Benefits - - - - 0%- Staff Development - - - - 0%- Contract Services 5,654,282 6,298,267 7,234,950 (1,593,855) -22%(8,828,805) Maintenance 56,463 70,167 65,000 9,310 14%(55,690) Operations 447,634 (87,248) 251,900 11,782 5%(240,118) Capital Outlay 38,200 26,094 15,000 - 0%(15,000) Debt Service 262,228 272,717 320,000 - 0%(320,000) Transfers Out - - - - 0%- Subtotal Fire Fund Expenditures 6,459,615 6,579,997 7,886,850 (1,572,762) -20%(9,459,612) NET OPERATING REVENUE 1,235,074 2,402,537 805,650 (1,459,925) Non-Operating Revenues Use of Money and Property (Unrealized Gain/Loss)- - -$ 0%-$ Transfers In - - - 0%- Total Fire Fund Non-Operating R - - - - 0%-$ Non-Operating Expenditures CIP (Fire Station)-$ - 1,000,000 0%(1,000,000)$ CIP (Vehicle Purchase)-- - - 0%- Total Fire Fund Non-Operating E - - 1,000,000 - 0%(1,000,000)$ NET NON-OPERATING REVENUE - - (1,000,000) City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 14 CITY OF EASTVALE Fiscal Year 2023-24Interim Financial Report | QUARTER ONE ending June 30, 2023 | 3 months Other Funds Summary *Data includes transfers Audited Actuals Unaudited Actuals Amended Budget Actuals Amount Over(Under) Budget Description 2021-22 2022-23 2023-24 9/30/2023 2023-24 OTHER FUNDS Revenues 200 Gas Tax 1,604,905$ 1,910,031$ 2,038,500$ 369,455$ 18%(1,669,045)$ 205 SB1 1,378,406 1,630,373 1,737,300 161,212 9%(1,576,088) 206 Area Drainage Plan (ADP)(493) 22,224 8,800 5,264 60%(3,536) 210 Measure A 2,189,098 3,561,411 2,075,500 286,407 14%(1,789,093) 211 TDA Fund - 146,666 334,820 - 0%(334,820) 220 AQMD 143,575 105,726 142,100 3,511 2%(138,589) 230 Grants: Law Enforcement Grants - - - - 0%- 240 Grants: Miscellaneous Grants Fund 668,027 520,685 2,281,129 - 0%(2,281,129) 241 Grants: Coronavirus Relief Fund - - - - 0%- 242 Grants: American Rescue Plan Act Fund 7,360,219 - - - 0%- 243 Public, Educational, or Governmental Access Fund 2,188 1,444 - - 0%- 250 Grants: Community Development Block Grant - - - - 0%- 260 Local Law Enforcement Services 165,428 - - - 0%- 270 TUMF Reimbursement Fund - 13,818 - - 0%- 290 Transportation DIF 119,761 520,618 258,500 9,192 4%(249,308) 291 Fire DIF 46,690 70,837 45,500 3,928 9%(41,572) 292 Public Facilities DIF 102,648 69,972 163,000 1,534 1%(161,466) 293 Road and Bridge Benefit District 454,300 218,470 125,000 50,396 40%(74,604) 300 LLMD 89-1 Zone 10 3,820 4,743 - 3 0%3 301 LLMD 89-1 Zone 33 1,171 707 150 45 30%(105) 302 LLMD 89-1 Zone 41 171,435 76,992 56,496 10,682 19%(45,814) 303 LLMD 89-1 Zone 79 2,593 1,667 2,676 95 4%(2,581) 304 LLMD 89-1 Zone 85 3,008 985 435 182 42%(253) 305 LLMD 89-1 Zone 111 23,997 24,893 17,800 1,018 6%(16,782) 306 LLMD 89-1 Zone 115 3,726 4,094 4,283 - 0%(4,283) 307 LLMD 89-1 Zone 116 8,031 7,897 6,005 353 6%(5,652) 308 LLMD 89-1 Zone 147 1,552 1,717 1,789 - 0%(1,789) 309 LLMD 89-1 Zone 151 7,659 9,512 9,702 - 0%(9,702) 310 LLMD 89-1 Zone 156 5,750 7,139 7,282 - 0%(7,282) 311 Benefit Assessment District 2014-2 12,563 11,259 9,665 3,962 41%(5,703) 312 LLMD 2014-1 19,499 18,215 16,726 10,296 62%(6,430) 313 LLMD 2014-3 8,489 7,114 8,442 3,895 46%(4,547) 314 LLMD 2014-4 6,850 6,071 4,120 2,023 49%(2,097) 315 Community Facilities District 2019-1 10,162 11,030 11,914 35 0%(11,879) 400 Community Facilities District 2017-1 74,687 41,746 93,435 1,645 2%(91,790) 401 Community Facilities District 2017-2 43,192 49,212 50,611 384 1%(50,227) 402 Community Facilities District 2020-1 73,498 95,925 99,652 (35) 0%(99,687) 403 LMD 98-2 ORIGINAL 16,635 11,024 4,793 106 2%(4,687) 404 LMD 98-2 ANNEX 01/Zone A 2,006 8,149 4,700 2 0%(4,698) 405 LMD 98-2 ANNEX 02/Zone B 41,892 91,834 61,569 318 1%(61,251) 406 LMD 98-2 ANNEX 03/Zone C 4,299 16,645 10,043 32 0%(10,011) 407 LMD 98-2 ANNEX 04/Zone D 6,233 22,287 15,012 29 0%(14,983) 408 LMD 98-2 ANNEX 06/Zone F 29,516 22,359 10,355 211 2%(10,144) 409 LMD 2001-1 Zone G 1,862 1,092 1,216 13 1%(1,203) 410 LMD 2001-1 Zone S 2,420 1,320 1,612 12 1%(1,600) 411 LMD 2001-1 Zone W 20,337 14,940 130 52 40%(78) 412 LMD 2001-2 Zone A 49,149 18,360 13,848 284 2%(13,564) 413 LMD 2001-2 Zone B 26,356 17,360 11,286 164 1%(11,122) 414 LMD 2001-2 Zone C 1,423 1,094 647 8 1%(639) 415 LMD 2001-2 Zone D 17,303 11,887 7,505 109 1%(7,396) % Budget Used City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 15 CITY OF EASTVALE Fiscal Year 2023-24Interim Financial Report | QUARTER ONE ending June 30, 2023 | 3 months Other Funds Summary *Data includes transfers Audited Actuals Unaudited Actuals Amended Budget Actuals Amount Over(Under) Budget Description 2021-22 2022-23 2023-24 9/30/2023 2023-24 % Budget Used 416 LMD 2001-2 Zone F 3,128 3,067 2,550 19 1%(2,531) 417 LMD 2001-2 Zone G 26,486 10,287 8,477 156 2%(8,321) 418 LMD 2001-2 Zone H 39,891 28,855 18,752 250 1%(18,502) 419 LMD 2001-2 Zone J 27,374 18,512 12,670 164 1%(12,506) 420 LMD 2001-2 Zone K 1,954 1,716 1,898 - 0%(1,898) 421 LMD 2001-2 Zone M 2,315 2,771 1,611 16 1%(1,595) 422 LMD 2001-3 Zone A 3,901 12,739 13,363 - 0%(13,363) 423 LMD 2001-3 Zone B 3,372 9,909 8,051 14 0%(8,037) 424 LMD 2001-3 Zone C 22,478 8,419 3,979 150 4%(3,829) 425 LMD 2001-3 Zone D 45,713 17,458 7,911 302 4%(7,609) 426 LMD 2001-3 Zone E 100,204 38,591 19,736 663 3%(19,073) 427 LMD 2001-3 Zone F 38,201 14,954 3,458 292 8%(3,166) 428 LMD 2001-3 Zone G 3,433 7,967 6,717 19 0%(6,698) 429 LMD 2001-3 Zone H 15,451 6,331 3,374 94 3%(3,280) 430 LMD 2001-3 Zone I 61,716 40,910 23,283 406 2%(22,877) 431 LMD 2001-3 Zone J 17,644 11,936 6,683 118 2%(6,565) 432 LMD 2001-3 Zone K 18,021 14,651 7,736 108 1%(7,628) 433 LMD 2001-3 Zone L 19,057 14,175 7,957 130 2%(7,827) 434 LMD 2001-3 Zone M 55,807 25,718 13,898 375 3%(13,523) 435 LMD 2001-3 Zone N 40,800 43,034 19,394 222 1%(19,172) 436 LMD 2001-3 Zone O 6,576 2,746 1,354 45 3%(1,309) 437 LMD 2001-3 Zone P 38,497 14,526 7,223 256 4%(6,967) 438 LMD 2001-3 Zone Q 15,405 5,997 3,247 97 3%(3,150) 439 LMD 2001-3 Zone R 1,849 1,699 1,020 13 1%(1,008) 440 LMD 2001-3 Zone S 7,430 3,061 1,495 50 3%(1,445) 441 LMD 2001-3 Zone T 57,013 21,130 10,374 379 4%(9,995) 442 LMD 2001-3 Zone U 37,570 14,313 7,639 204 3%(7,435) 443 LMD 2001-3 Zone V 63,337 23,359 11,767 409 3%(11,358) 444 LMD 2001-3 Zone W 19,463 7,854 8,300 127 2%(8,173) 445 LMD 2001-3 Zone X 5,519 2,365 1,176 37 3%(1,139) 446 LMD 2001-3 Zone Y 9,212 3,689 1,845 62 3%(1,783) 447 LMD 2001-3 Zone Z 10,185 4,093 2,024 68 3%(1,956) 448 LMD 2001-3 Zone AA 6,467 2,843 1,399 44 3%(1,355) 449 LMD 2001-3 Zone BB 6,006 2,464 1,147 41 4%(1,106) 450 LMD 2001-3 Zone CC 23,574 17,523 9,820 144 1%(9,676) 451 LMD 2001-3 Zone DD 50,873 23,649 13,161 345 3%(12,816) 452 LMD 2001-3 Zone EE 24,752 9,563 15,074 158 1%(14,916) 453 LMD 2001-3 Zone FF 30,391 21,436 11,643 204 2%(11,439) 454 LMD 2001-3 Zone GG 15,382 6,056 2,996 103 3%(2,893) 455 LMD 2001-3 Zone HH 12,334 4,877 2,443 82 3%(2,361) 456 LMD 2001-3 Zone II 27,648 10,433 5,089 184 4%(4,905) 457 LMD 2001-3 Zone JJ 4,943 2,102 1,032 34 3%(998) 458 LMD 2001-3 Zone KK 2,842 1,655 1,685 (0) 0%(1,685) 459 LMD 2001-3 Zone LL 10,721 4,358 2,119 42 2%(2,077) 460 LMD 2001-3 Zone MM 8,137 5,042 2,867 54 2%(2,813) 461 LMD 2001-3 Zone NN 19,085 7,293 3,641 127 3%(3,514) 462 LMD 2001-3 Zone OO 18,826 7,230 3,774 123 3%(3,651) 463 LMD 2001-3 Zone PP 22,147 8,413 4,200 140 3%(4,060) 464 LMD 2001-3 Zone QQ 8,658 3,648 1,884 58 3%(1,826) 465 LMD 2001-3 Zone RR 57,429 21,582 11,395 380 3%(11,015) 466 LMD 2001-3 Zone SS 21,381 8,167 4,148 141 3%(4,007) 467 LMD 2001-3 Zone TT 9,128 3,602 1,834 58 3%(1,776) 468 LMD 2001-3 Zone UU 7,023 2,844 1,314 48 4%(1,266) City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 16 CITY OF EASTVALE Fiscal Year 2023-24Interim Financial Report | QUARTER ONE ending June 30, 2023 | 3 months Other Funds Summary *Data includes transfers Audited Actuals Unaudited Actuals Amended Budget Actuals Amount Over(Under) Budget Description 2021-22 2022-23 2023-24 9/30/2023 2023-24 % Budget Used 469 LMD 2001-3 Zone VV 5,921 2,434 2,306 38 2%(2,268) 470 LMD 2001-3 Zone WW 24,592 9,570 4,851 163 3%(4,688) 471 LMD 2001-3 Zone XX 3,489 2,242 2,760 20 1%(2,740) 472 LMD 2001-3 Zone YY 27,233 19,033 10,864 179 2%(10,685) 473 LMD 2001-3 Zone ZZ 11,014 4,300 2,176 73 3%(2,103) 474 LMD 2001-3 Zone AAA 47,941 17,999 9,207 318 3%(8,889) 475 LMD 2001-3 Zone BBB 30,674 11,626 5,930 200 3%(5,730) 476 LMD 2001-3 Zone CCC 65,738 28,879 15,310 428 3%(14,882) 477 LMD 2001-3 Zone DDD 56,233 21,166 11,020 368 3%(10,652) 478 LMD 2001-3 Zone EEE 6,186 2,900 3,074 48 2%(3,026) 479 LMD 2001-3 Zone FFF 54,497 20,119 10,186 359 4%(9,827) 480 LMD 2001-3 Zone GGG 19,694 7,672 4,178 125 3%(4,053) 481 LMD 2001-3 Zone HHH 828 2,137 3,927 - 0%(3,927) 482 LMD 2001-3 Zone III 26,815 13,216 14,834 11 0%(14,823) 483 LMD 2001-3 Zone JJJ 31,081 11,775 6,066 204 3%(5,862) 484 LMD 2001-3 Zone LLL 6,082 11,151 4,812 37 1%(4,775) 485 LMD 2001-3 Zone MMM 20,050 8,225 4,229 133 3%(4,096) 486 Illumination District No 2 Subarea 35 8,749 3,795 5,193 36 1%(5,157) 487 Illumination District No 2 Subarea 42 2,513 1,496 1,737 10 1%(1,727) 488 Illumination District No 2 Subarea 46 9,336 3,263 4,566 8 0%(4,558) 489 Illumination District No 2 Subarea 49 11,841 4,113 4,677 45 1%(4,632) 490 Illumination District No 2 Subarea 55 2,344 679 669 9 1%(660) 500 Debt Service 4,509,981 - - - 0%- 600 Capital Projects 2,143,140 11,417,107 10,491,412 9,967,662 95%(523,750) 601 General Information Technology Capital Replacem - 433,652 50,000 50,000 100%- 602 General Fleet Capital Replacement Fund - 120,000 120,000 120,000 100%- 603 General Street Maintenance Capital Fund - 500,000 500,000 500,000 100%- 604 General Facility Maintenance Capital Fund - 250,000 250,000 250,000 100%- 700 Information Technology - - - - 0%- Total Other Fund Revenues 23,268,586 22,951,703 21,649,659 11,825,056 55%(9,824,603) Expenditures 200 Gas Tax 1,994,824$ 1,280,427$ 3,393,600$ 183,906$ 5%(3,209,694)$ 205 SB1 1,721,552 (7,078) 4,032,000 - 0%(4,032,000) 206 Area Drainage Plan (ADP)17,322 (13,822) - - 0%- 210 Measure A 1,891,015 1,572,979 6,597,662 209,113 3%(6,388,549) 211 TDA Fund 102,318 44,348 - - 0%- 220 AQMD 123,899 1,844 67,440 - 0%(67,440) 230 Law Enforcement Grants - - - - 0%- 240 Grants: Miscellaneous Grants Fund 520,016 479,696 25,229,250 731,747 3%(24,497,504) 241 Grants: Coronavirus Relief Fund - - - - 0%- 242 Grants: American Rescue Plan Act Fund 7,360,219 - - - 0%- 243 Public, Educational, or Governmental Access Fund - - - - 0%- 250 Grants: Community Development Block Grant - - - - 0%- 260 Local Law Enforcement Services 165,428 - - - 0%- 270 TUMF Reimbursement Fund 344,067 157,993 4,842,010 - 0%(4,842,010) 290 Transportation DIF 6,587 (3,547) 5,170 5,170 100%- 291 Fire DIF 8,376 (7,086) 910 910 100%- 292 Public Facilities DIF 9,146 485,117 3,260 3,260 100%- 293 Road and Bridge Benefit District 229,679 (98,390) - - 0%- 300 LLMD 89-1 Zone 10 508 159 800 8 1%(792) 301 LLMD 89-1 Zone 33 425 8 500 2 0%(498) 302 LLMD 89-1 Zone 41 84,713 (14,775) 38,335 10,562 28%(27,773) City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 17 CITY OF EASTVALE Fiscal Year 2023-24Interim Financial Report | QUARTER ONE ending June 30, 2023 | 3 months Other Funds Summary *Data includes transfers Audited Actuals Unaudited Actuals Amended Budget Actuals Amount Over(Under) Budget Description 2021-22 2022-23 2023-24 9/30/2023 2023-24 % Budget Used 303 LLMD 89-1 Zone 79 2,966 884 1,544 546 35%(998) 304 LLMD 89-1 Zone 85 1,174 (374) 265 56 21%(209) 305 LLMD 89-1 Zone 111 19,734 8,522 20,623 4,801 23%(15,822) 306 LLMD 89-1 Zone 115 12,838 11,544 14,601 3,476 24%(11,125) 307 LLMD 89-1 Zone 116 6,734 4,950 7,986 2,153 27%(5,833) 308 LLMD 89-1 Zone 147 4,315 5,179 6,479 1,713 26%(4,766) 309 LLMD 89-1 Zone 151 15,413 19,258 32,336 7,489 23%(24,847) 310 LLMD 89-1 Zone 156 10,803 13,403 17,766 4,332 24%(13,434) 311 Benefit Assessment District 2014-2 7,887 4,860 9,586 2,834 30%(6,752) 312 LLMD 2014-1 8,527 5,096 16,562 4,198 25%(12,364) 313 LLMD 2014-3 5,346 3,603 8,413 2,325 28%(6,088) 314 LLMD 2014-4 2,399 726 3,994 997 25%(2,997) 315 Community Facilities District 2019-1 3,840 3,198 4,163 1,673 40%(2,491) 400 Community Facilities District 2017-1 7,697 1,612 36,359 8,189 23%(28,171) 401 Community Facilities District 2017-2 20,518 25,840 34,870 12,853 37%(22,017) 402 Community Facilities District 2020-1 83,623 123,806 155,656 38,534 25%(117,122) 403 LMD 98-2 ORIGINAL 1,698 5,417 7,798 1,841 24%(5,957) 404 LMD 98-2 ANNEX 01/Zone A 4,197 4,141 5,818 1,365 23%(4,453) 405 LMD 98-2 ANNEX 02/Zone B 28,806 40,253 30,644 10,054 33%(20,590) 406 LMD 98-2 ANNEX 03/Zone C 4,028 8,395 11,535 2,714 24%(8,821) 407 LMD 98-2 ANNEX 04/Zone D 8,607 10,981 14,857 3,523 24%(11,334) 408 LMD 98-2 ANNEX 06/Zone F 2,892 8,944 12,500 2,958 24%(9,542) 409 LMD 2001-1 Zone G 145 477 533 153 29%(380) 410 LMD 2001-1 Zone S 336 995 1,229 364 30%(865) 411 LMD 2001-1 Zone W 6,258 18,434 7,853 3,910 50%(3,943) 412 LMD 2001-2 Zone A 3,342 10,987 12,350 3,786 31%(8,564) 413 LMD 2001-2 Zone B 2,788 8,921 12,613 3,132 25%(9,481) 414 LMD 2001-2 Zone C 130 691 840 218 26%(622) 415 LMD 2001-2 Zone D 1,870 6,090 8,463 2,094 25%(6,369) 416 LMD 2001-2 Zone F 528 1,785 2,508 613 24%(1,895) 417 LMD 2001-2 Zone G 1,616 4,767 9,368 3,010 32%(6,358) 418 LMD 2001-2 Zone H 4,696 14,741 21,816 5,298 24%(16,518) 419 LMD 2001-2 Zone J 3,096 10,315 14,512 3,639 25%(10,873) 420 LMD 2001-2 Zone K 841 2,832 3,523 1,288 37%(2,235) 421 LMD 2001-2 Zone M 373 1,360 2,081 473 23%(1,608) 422 LMD 2001-3 Zone A 18,822 4,986 5,705 1,506 26%(4,199) 423 LMD 2001-3 Zone B 6,507 3,327 4,275 1,005 24%(3,270) 424 LMD 2001-3 Zone C 1,011 2,794 2,834 810 29%(2,024) 425 LMD 2001-3 Zone D 2,297 6,211 6,394 1,825 29%(4,569) 426 LMD 2001-3 Zone E 5,080 13,735 14,136 3,999 28%(10,137) 427 LMD 2001-3 Zone F 447 1,430 1,078 306 28%(772) 428 LMD 2001-3 Zone G 2,379 4,446 4,163 1,174 28%(2,989) 429 LMD 2001-3 Zone H 1,149 3,227 3,561 987 28%(2,574) 430 LMD 2001-3 Zone I 5,857 18,922 27,395 6,259 23%(21,136) 431 LMD 2001-3 Zone J 1,659 5,419 7,748 1,766 23%(5,982) 432 LMD 2001-3 Zone K 2,579 8,217 11,873 2,727 23%(9,146) 433 LMD 2001-3 Zone L 2,020 6,185 9,048 2,036 23%(7,012) 434 LMD 2001-3 Zone M 3,567 9,448 11,021 2,862 26%(8,159) 435 LMD 2001-3 Zone N 7,409 29,601 35,908 8,124 23%(27,784) 436 LMD 2001-3 Zone O 319 935 959 266 28%(693) 437 LMD 2001-3 Zone P 1,835 5,015 5,015 1,450 29%(3,565) 438 LMD 2001-3 Zone Q 900 2,753 2,620 740 28%(1,880) 439 LMD 2001-3 Zone R 221 815 1,354 304 22%(1,050) City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 18 CITY OF EASTVALE Fiscal Year 2023-24Interim Financial Report | QUARTER ONE ending June 30, 2023 | 3 months Other Funds Summary *Data includes transfers Audited Actuals Unaudited Actuals Amended Budget Actuals Amount Over(Under) Budget Description 2021-22 2022-23 2023-24 9/30/2023 2023-24 % Budget Used 440 LMD 2001-3 Zone S 359 1,063 1,085 304 28%(781) 441 LMD 2001-3 Zone T 2,633 7,191 7,165 2,043 29%(5,122) 442 LMD 2001-3 Zone U 1,964 12,620 5,517 1,599 29%(3,918) 443 LMD 2001-3 Zone V 3,075 9,454 8,689 2,482 29%(6,207) 444 LMD 2001-3 Zone W 1,058 3,136 3,448 949 28%(2,499) 445 LMD 2001-3 Zone X 274 831 871 240 28%(631) 446 LMD 2001-3 Zone Y 446 1,311 1,348 379 28%(969) 447 LMD 2001-3 Zone Z 491 1,424 1,454 408 28%(1,046) 448 LMD 2001-3 Zone AA 331 1,015 1,116 296 26%(820) 449 LMD 2001-3 Zone BB 262 801 834 229 27%(605) 450 LMD 2001-3 Zone CC 2,502 10,381 11,359 2,543 22%(8,816) 451 LMD 2001-3 Zone DD 2,821 8,547 10,475 2,604 25%(7,872) 452 LMD 2001-3 Zone EE 1,437 3,986 4,094 1,167 28%(2,927) 453 LMD 2001-3 Zone FF 3,107 10,264 11,121 2,632 24%(8,489) 454 LMD 2001-3 Zone GG 747 2,120 2,131 604 28%(1,527) 455 LMD 2001-3 Zone HH 601 1,718 1,812 506 28%(1,306) 456 LMD 2001-3 Zone II 1,279 3,571 3,605 1,026 28%(2,579) 457 LMD 2001-3 Zone JJ 235 734 759 210 28%(549) 458 LMD 2001-3 Zone KK 1,222 3,317 3,887 1,064 27%(2,823) 459 LMD 2001-3 Zone LL 513 6,370 1,592 438 28%(1,154) 460 LMD 2001-3 Zone MM 709 2,273 3,109 735 24%(2,374) 461 LMD 2001-3 Zone NN 904 2,567 2,633 747 28%(1,886) 462 LMD 2001-3 Zone OO 951 2,726 2,928 819 28%(2,109) 463 LMD 2001-3 Zone PP 1,174 3,807 3,460 986 29%(2,474) 464 LMD 2001-3 Zone QQ 461 1,317 1,454 397 27%(1,057) 465 LMD 2001-3 Zone RR 2,837 7,600 7,623 2,179 29%(5,444) 466 LMD 2001-3 Zone SS 1,027 2,920 3,097 875 28%(2,222) 467 LMD 2001-3 Zone TT 521 1,526 1,592 451 28%(1,141) 468 LMD 2001-3 Zone UU 305 909 953 261 27%(692) 469 LMD 2001-3 Zone VV 366 1,082 1,166 323 28%(843) 470 LMD 2001-3 Zone WW 1,231 3,440 3,423 979 29%(2,444) 471 LMD 2001-3 Zone XX 342 1,452 1,755 552 31%(1,203) 472 LMD 2001-3 Zone YY 2,722 8,934 12,951 2,939 23%(10,012) 473 LMD 2001-3 Zone ZZ 536 1,516 1,517 430 28%(1,087) 474 LMD 2001-3 Zone AAA 2,252 6,256 6,344 1,800 28%(4,544) 475 LMD 2001-3 Zone BBB 1,610 4,427 4,564 1,291 28%(3,273) 476 LMD 2001-3 Zone CCC 4,129 11,916 13,403 3,526 26%(9,877) 477 LMD 2001-3 Zone DDD 2,857 7,810 7,886 2,251 29%(5,635) 478 LMD 2001-3 Zone EEE 73 470 439 115 26%(324) 479 LMD 2001-3 Zone FFF 2,621 7,194 6,821 1,963 29%(4,858) 480 LMD 2001-3 Zone GGG 1,204 3,308 3,473 957 28%(2,516) 481 LMD 2001-3 Zone HHH 2,030 2,459 2,119 636 30%(1,483) 482 LMD 2001-3 Zone III 3,679 30,926 8,664 2,534 29%(6,130) 483 LMD 2001-3 Zone JJJ 1,547 4,301 4,438 1,260 28%(3,178) 484 LMD 2001-3 Zone LLL 7,900 2,128 2,558 678 27%(1,880) 485 LMD 2001-3 Zone MMM 1,078 2,959 3,047 870 29%(2,177) 486 Illumination District No 2 Subarea 35 1,250 3,618 4,250 1,442 34%(2,808) 487 Illumination District No 2 Subarea 42 407 1,341 1,693 541 32%(1,152) 488 Illumination District No 2 Subarea 46 1,212 8,226 3,749 1,181 32%(2,568) 489 Illumination District No 2 Subarea 49 1,498 5,027 4,789 1,566 33%(3,223) 490 Illumination District No 2 Subarea 55 268 821 953 291 31%(662) 500 Debt Service 4,510,719 - - - 0%- 600 Capital Projects 1,021,164 3,273,187 15,336,320 77,471 1%(15,258,849) City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 19 CITY OF EASTVALE Fiscal Year 2023-24Interim Financial Report | QUARTER ONE ending June 30, 2023 | 3 months Other Funds Summary *Data includes transfers Audited Actuals Unaudited Actuals Amended Budget Actuals Amount Over(Under) Budget Description 2021-22 2022-23 2023-24 9/30/2023 2023-24 % Budget Used 601 General Information Technology Capital Replacem - - - - 0%- 602 General Fleet Capital Replacement Fund - - - - 0%- 603 General Street Maintenance Capital Fund - - - - 0%- 604 General Facility Maintenance Capital Fund - - - - 0%- 700 Information Technology - - - - 0%- Total Other Fund Expenditures 20,541,150 7,906,268 60,463,600 1,464,195 2%(58,999,406) City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 20 CITY OF EASTVALE Fiscal Year 2023-24Interim Financial Report | QUARTER ONE ending June 30, 2023 | 3 months Available Resources Summary Audited Fund Balance Audited Fund Balance Amended Revenue Budget Amended Expenditure Budget Estimated Available Fund Balance Fund Name & Type 2021-22 2022-23 2023-24 2023-24 6/30/2024 GENERAL FUNDS 100 General Fund 96,083,818$ 127,394,125$ 64,717,296$ 44,448,679$ 147,662,742$ TOTAL General Funds 96,083,818 127,394,125 64,717,296 44,448,679 147,662,742 OTHER PURPOSE GENERAL FUNDS 110 Restricted Structural Fire Fund 14,473,114$ 16,875,651$ 8,692,500$ 8,886,850$ 16,681,301$ TOTAL Other Purpose General Funds 14,473,114 16,875,651 8,692,500 8,886,850 16,681,301 SPECIAL REVENUE FUNDS 200 Gas Tax Fund 3,154,024$ 3,783,628$ 2,038,500$ 3,393,600$ 2,428,528$ 205 Road Maintenance and Rehabilitation Fund 800,050 2,437,501 1,737,300 4,032,000 142,801 206 Area Drainage Plan (ADP)885,689 921,734 8,800 - 930,534 210 Measure A Fund 4,648,626 6,637,058 2,075,500 6,597,662 2,114,896 211 TDA Fund (102,318) - 334,820 - 334,820 220 Air Quality Management District 513,467 617,349 142,100 67,440 692,009 230 Law Enforcement Grants - - - - - 240 Grants: Miscellaneous Grants Fund (14,784) 26,204 2,281,129 25,229,250 (22,921,917) 241 Grants: Coronavirus Relief Fund - - - - - 242 Grants: American Rescue Plan Act Fund - - - - - 243 Public, Educational, or Governmental Access Fund 2,703 4,147 - - 4,147 250 Grants: Community Development Block Grant (7) (7) - - (7) 260 Local Law Enforcement Services - - - - - 270 TUMF Reimbursement Find (625,167) (769,342) - 4,842,010 (5,611,352) 290 DIF Transportation Facilities Fund 423,775 947,941 258,500 5,170 1,201,271 291 DIF Fire Facilities Fund 538,832 616,755 45,500 910 661,345 292 DIF Public Facilities Fund 590,338 175,194 163,000 3,260 334,934 293 Road and Bridge Benefit District 6,670,033 6,986,893 125,000 - 7,111,893 300 LLMD 89-1 Zone 10 (4,069) 515 - 800 (285) 301 LLMD 89-1 Zone 33 7,210 7,910 150 500 7,560 302 LLMD 89-1 Zone 41 1,788,103 1,879,870 56,496 38,335 1,898,031 303 LLMD 89-1 Zone 79 16,207 16,990 2,676 1,544 18,122 304 LLMD 89-1 Zone 85 30,600 31,958 435 265 32,128 305 LLMD 89-1 Zone 111 166,660 183,032 17,800 20,623 180,209 306 LLMD 89-1 Zone 115 (28,207) (35,657) 4,283 14,601 (45,975) 307 LLMD 89-1 Zone 116 61,041 63,988 6,005 7,986 62,007 308 LLMD 89-1 Zone 147 (6,212) (9,674) 1,789 6,479 (14,364) 309 LLMD 89-1 Zone 151 (50,753) (60,500) 9,702 32,336 (83,134) 310 LLMD 89-1 Zone 156 (22,520) (28,784) 7,282 17,766 (39,268) 311 Benefit Assessment District 2014-2 13,403 19,802 9,665 9,586 19,881 312 LLMD 2014-1 18,548 31,667 16,726 16,562 31,831 313 LLMD 2014-3 7,890 11,402 8,442 8,413 11,431 314 LLMD 2014-4 10,180 15,525 4,120 3,994 15,651 315 Community Facilities District 2019-1 (654) 7,179 11,914 4,163 14,930 400 Community Facilities District 2017-1 255,799 295,932 93,435 36,359 353,008 401 Community Facilities District 2017-2 53,197 76,569 50,611 34,870 92,310 402 Community Facilities District 2020-1 52,480 24,598 99,652 155,656 (31,406) 403 LMD 98-2 ORIGINAL 14,937 20,544 4,793 7,798 17,539 404 LMD 98-2 ANNEX 01/Zone A (2,191) 1,817 4,700 5,818 699 405 LMD 98-2 ANNEX 02/Zone B 13,087 64,667 61,569 30,644 95,592 406 LMD 98-2 ANNEX 03/Zone C 272 8,521 10,043 11,535 7,029 407 LMD 98-2 ANNEX 04/Zone D (2,374) 8,932 15,012 14,857 9,087 408 LMD 98-2 ANNEX 06/Zone F 26,624 40,039 10,355 12,500 37,894 409 LMD 2001-1 Zone G 1,717 2,332 1,216 533 3,015 410 LMD 2001-1 Zone S 2,089 2,414 1,612 1,229 2,797 411 LMD 2001-1 Zone W 14,079 10,585 130 7,853 2,863 412 LMD 2001-2 Zone A 45,807 53,181 13,848 12,350 54,679 413 LMD 2001-2 Zone B 23,568 32,007 11,286 12,613 30,680 414 LMD 2001-2 Zone C 1,293 1,695 647 840 1,502 City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 21 CITY OF EASTVALE Fiscal Year 2023-24Interim Financial Report | QUARTER ONE ending June 30, 2023 | 3 months Available Resources Summary Audited Fund Balance Audited Fund Balance Amended Revenue Budget Amended Expenditure Budget Estimated Available Fund Balance Fund Name & Type 2021-22 2022-23 2023-24 2023-24 6/30/2024 415 LMD 2001-2 Zone D 15,432 21,229 7,505 8,463 20,271 416 LMD 2001-2 Zone F 2,600 3,881 2,550 2,508 3,923 417 LMD 2001-2 Zone G 24,870 30,389 8,477 9,368 29,499 418 LMD 2001-2 Zone H 35,195 49,308 18,752 21,816 46,244 419 LMD 2001-2 Zone J 24,278 32,474 12,670 14,512 30,632 420 LMD 2001-2 Zone K 1,117 1 1,898 3,523 (1,624) 421 LMD 2001-2 Zone M 1,942 3,352 1,611 2,081 2,882 422 LMD 2001-3 Zone A (14,920) (7,167) 13,363 5,705 491 423 LMD 2001-3 Zone B (3,135) 3,447 8,051 4,275 7,223 424 LMD 2001-3 Zone C 21,467 27,092 3,979 2,834 28,237 425 LMD 2001-3 Zone D 43,417 54,664 7,911 6,394 56,181 426 LMD 2001-3 Zone E 95,124 119,981 19,736 14,136 125,581 427 LMD 2001-3 Zone F 37,754 51,278 3,458 1,078 53,658 428 LMD 2001-3 Zone G 1,054 4,574 6,717 4,163 7,128 429 LMD 2001-3 Zone H 14,303 17,407 3,374 3,561 17,220 430 LMD 2001-3 Zone I 55,862 77,850 23,283 27,395 73,738 431 LMD 2001-3 Zone J 15,985 22,502 6,683 7,748 21,437 432 LMD 2001-3 Zone K 15,442 21,876 7,736 11,873 17,739 433 LMD 2001-3 Zone L 17,038 25,028 7,957 9,048 23,937 434 LMD 2001-3 Zone M 52,240 68,510 13,898 11,021 71,387 435 LMD 2001-3 Zone N 33,391 46,824 19,394 35,908 30,310 436 LMD 2001-3 Zone O 6,257 8,069 1,354 959 8,464 437 LMD 2001-3 Zone P 36,662 46,173 7,223 5,015 48,381 438 LMD 2001-3 Zone Q 14,505 17,749 3,247 2,620 18,376 439 LMD 2001-3 Zone R 1,628 2,512 1,020 1,354 2,178 440 LMD 2001-3 Zone S 7,075 9,072 1,495 1,085 9,482 441 LMD 2001-3 Zone T 54,380 68,318 10,374 7,165 71,527 442 LMD 2001-3 Zone U 35,606 37,299 7,639 5,517 39,421 443 LMD 2001-3 Zone V 60,262 74,167 11,767 8,689 77,245 444 LMD 2001-3 Zone W 18,405 23,122 8,300 3,448 27,974 445 LMD 2001-3 Zone X 5,245 6,779 1,176 871 7,084 446 LMD 2001-3 Zone Y 8,765 11,143 1,845 1,348 11,640 447 LMD 2001-3 Zone Z 9,695 12,364 2,024 1,454 12,934 448 LMD 2001-3 Zone AA 6,136 7,965 1,399 1,116 8,248 449 LMD 2001-3 Zone BB 5,743 7,406 1,147 834 7,719 450 LMD 2001-3 Zone CC 21,073 28,214 9,820 11,359 26,675 451 LMD 2001-3 Zone DD 48,052 63,155 13,161 10,475 65,841 452 LMD 2001-3 Zone EE 23,315 28,893 15,074 4,094 39,873 453 LMD 2001-3 Zone FF 27,284 38,456 11,643 11,121 38,978 454 LMD 2001-3 Zone GG 14,635 18,572 2,996 2,131 19,437 455 LMD 2001-3 Zone HH 11,733 14,892 2,443 1,812 15,523 456 LMD 2001-3 Zone II 26,369 33,230 5,089 3,605 34,714 457 LMD 2001-3 Zone JJ 4,707 6,076 1,032 759 6,349 458 LMD 2001-3 Zone KK 1,620 (42) 1,685 3,887 (2,244) 459 LMD 2001-3 Zone LL 10,208 8,196 2,119 1,592 8,723 460 LMD 2001-3 Zone MM 7,428 10,197 2,867 3,109 9,955 461 LMD 2001-3 Zone NN 18,180 22,906 3,641 2,633 23,914 462 LMD 2001-3 Zone OO 17,875 22,379 3,774 2,928 23,225 463 LMD 2001-3 Zone PP 20,973 25,579 4,200 3,460 26,319 464 LMD 2001-3 Zone QQ 8,196 10,527 1,884 1,454 10,957 465 LMD 2001-3 Zone RR 54,592 68,574 11,395 7,623 72,346 466 LMD 2001-3 Zone SS 20,354 25,601 4,148 3,097 26,652 467 LMD 2001-3 Zone TT 8,607 10,682 1,834 1,592 10,924 468 LMD 2001-3 Zone UU 6,717 8,652 1,314 953 9,013 469 LMD 2001-3 Zone VV 5,555 6,907 2,306 1,166 8,047 470 LMD 2001-3 Zone WW 23,361 29,491 4,851 3,423 30,919 471 LMD 2001-3 Zone XX 3,147 3,937 2,760 1,755 4,942 472 LMD 2001-3 Zone YY 24,511 34,611 10,864 12,951 32,524 473 LMD 2001-3 Zone ZZ 10,479 13,262 2,176 1,517 13,921 City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 22 CITY OF EASTVALE Fiscal Year 2023-24Interim Financial Report | QUARTER ONE ending June 30, 2023 | 3 months Available Resources Summary Audited Fund Balance Audited Fund Balance Amended Revenue Budget Amended Expenditure Budget Estimated Available Fund Balance Fund Name & Type 2021-22 2022-23 2023-24 2023-24 6/30/2024 474 LMD 2001-3 Zone AAA 45,690 57,433 9,207 6,344 60,296 475 LMD 2001-3 Zone BBB 29,064 36,264 5,930 4,564 37,630 476 LMD 2001-3 Zone CCC 61,609 78,573 15,310 13,403 80,480 477 LMD 2001-3 Zone DDD 53,376 66,732 11,020 7,886 69,866 478 LMD 2001-3 Zone EEE 6,113 8,542 3,074 439 11,177 479 LMD 2001-3 Zone FFF 51,876 64,801 10,186 6,821 68,166 480 LMD 2001-3 Zone GGG 18,489 22,854 4,178 3,473 23,559 481 LMD 2001-3 Zone HHH (1,202) (1,524) 3,927 2,119 284 482 LMD 2001-3 Zone III 23,136 5,426 14,834 8,664 11,596 483 LMD 2001-3 Zone JJJ 29,534 37,008 6,066 4,438 38,636 484 LMD 2001-3 Zone LLL (1,818) 7,205 4,812 2,558 9,459 485 LMD 2001-3 Zone MMM 18,972 24,238 4,229 3,047 25,420 486 Illumination District No 2 Subarea 35 7,499 7,677 5,193 4,250 8,620 487 Illumination District No 2 Subarea 42 2,106 2,262 1,737 1,693 2,306 488 Illumination District No 2 Subarea 46 8,124 3,161 4,566 3,749 3,978 489 Illumination District No 2 Subarea 49 10,343 9,429 4,677 4,789 9,317 490 Illumination District No 2 Subarea 55 2,076 1,934 669 953 1,650 491 JCSD Special District Temporary Fund - (759) - - (759) TOTAL Special Revenue Funds 21,537,849 27,135,712 10,238,247 45,127,280 (7,753,322) DEBT SERVICE FUND 500 General Debt Service Fund -$ -$ -$ -$ -$ TOTAL Debt Service Fund - - - - - CAPITAL PROJECTS FUNDS 600 General Capital Projects Fund 2,908,958$ 11,052,878$ 10,491,412$ 15,336,320$ 6,207,970$ 601 General Information Technology Capital Replaceme - 553,652 50,000 - 603,652 602 General Fleet Capital Replacement Fund - 240,000 120,000 - 360,000 603 General Street Maintenance Capital Fund - 500,000 500,000 - 1,000,000 604 General Facility Maintenance Capital Fund - 250,000 250,000 - 500,000 605 General Catch Basin & Storm Drain Maintenance Ca - 100,000 100,000 - 200,000 TOTAL Capital Projects Fund 2,908,958 12,696,530 11,511,412 15,336,320 8,871,622 INTERNAL SERVICE FUNDS 700 Information Technology Internal Service Fund -$ -$ -$ -$ -$ TOTAL Internal Service Funds - - - - - TOTAL 135,003,739$ 184,102,017$ 95,159,455$ 113,799,129$ 165,462,343$ City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 23 CITY OF EASTVALE Fiscal Year 2023-24Interim Financial Report | QUARTER ONE ending June 30, 2023 | 3 months Available Resources Summary Audited Fund Balance Audited Fund Balance Amended Revenue Budget Amended Expenditure Budget Estimated Available Fund Balance Fund Name & Type 2021-22 2022-23 2023-24 2023-24 6/30/2024 GENERAL FUND - FUND BALANCE RESERVES AND COMMITMENTS Total General Fund Estimated Fund Balance at 06/30/2024 147,662,742$ Nonspendable (Per 06/30/2023 ACFR):Prepaid Items - Total Nonspendable Fund Balance - Restricted:Restricted Fund Balance - Total Restricted Fund Balance - Assigned: Emergency Contingency (50% of Adopted Operating Appropriations)16,730,508 Cash flow for CIP Grants 29,500,000 Cover Special Revenue Fund Negative Fund Balance 219,066 Business Incentive Loan Program 300,000 Total Assigned Reserves 46,749,574 Committed: Facility Construction: City Hall 33,000,000 Facility Construction: Library 10,000,000 Facility Construction: Police Substation 8,000,000 Pension Liability (CalPERS Reserve)2,000,000 Equipment Purchase, Fire Truck 1,500,000 Public Safety Rate Increase Stabilization 1,000,000 Total Committed Reserves 55,500,000 Committed Appropriations Limit Qualified Capital Outlay Reserve: General Fund: Facility Construction: City Hall - Appropriations Limit 20,420,029 General Fund: Facility Construction: Library - Appropriations Limit 17,595,000 Total Appropriations Limit Committed Reserves 38,015,029 Total General Funds Estimated Unassigned Fund Balance at 06/30/2024 7,398,139$ RESTRICTED STRUCTURAL FIRE FUND - FUND BALANCE RESERVES AND COMMITMENTS Total Fire Funds Estimated Fund Balance at 06/30/2024 16,681,301$ Assigned:Emergency Contingency (75% of Adopted Operating Appropriations)5,915,138 Facility Construction: Third Fire Station 2,000,000 Total Assigned Reserves 7,915,138 Committed: Facility Construction: Third Fire Station 8,000,000 Equipment Purchase: Apparatus Replacement Reserve 400,000 Total Committed Reserves 8,400,000 Total Fire Funds Estimated Unassigned Fund Balance at 06/30/2024 366,164$ Restricted by the County of Riverside (Per 06/30/2023 ACFR):Restricted Fund Balance 16,875,651 Total Restricted Fund Balance 16,875,651 **For the purpose of this schedule, budgetary fund balance is estimated. Estimated fund balance in the far right column is defined as revenues minus expenditures. For the city's two major funds, fund balance is further broken down by the five categories of fund balance, nonspendable, restricted, assigned, committed, and unassigned located in the bottom portion of the schedule. Adequate fund balance is available in the General Fund to cover any negative fund balances in the city's reimbursable grant funds and special financing district funds. City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 24 CITY OF EASTVALE Fiscal Year 2023-24Annual Operating Budget Appropriations Limit Summary Pre Voter Approved Override Voter Approved Override Post Voter Approved Override Post Voter Approved Override Post Voter Approved Override 2017-18 2018-19 2019-20 2020-21 2020-21 2021-22 2022-23 2023-24 ADOPTED APPROPRIATIONS LIMIT Adopted Appropriations Limit 21,455,814$ 23,077,364$ 24,418,797$ 25,794,921$ 33,000,000$ 35,473,578$ 39,253,023$ 40,991,901$ Subject Revenue Appropriations General Fund 10,045,447 15,809,535 17,472,985 17,952,129 41,516,698 54,973,760 53,493,923 58,427,813 Fire Fund 5,055,030 5,346,150 6,285,042 6,406,287 6,406,287 7,298,931 7,785,000 8,400,000 Total Subject Revenue Appropriation 15,100,477 21,155,685 23,758,027 24,358,416 47,922,985 62,272,691 61,278,923 66,827,813 Over(Under) Limit (6,355,337)(1,921,679)(660,770)(1,436,505)14,922,985 26,799,113 22,025,900 25,835,912 AB137 Provision Calculation 25,152,570 Annual Available for Capital Outlay 14,922,985 26,799,113 22,025,900 683,342 Cumulative Available for Capital Outlay 41,722,098 22,025,900 683,342 Cumulative Available for Capital Outlay Expenditures and Reserves 41,722,098 22,025,900 683,342 FY2021-22 Adopted Capital Outlay Reserve Commitments General Fund: Facility Construction City Hall - Appropriations Limit 18,399,529 General Fund: Facility Construction Library - Appropriations Limit 10,595,000 General Fund: Limonite Gap Bridge - Appropriations Limit 2,500,000 General Fund: Equipment, Fire Truck Purchase - Appropriations Limit 1,500,000 General Fund: Facility, Fire Station 27 Storage Facility - Appropriations Limit 2,000,000 Subtotal Capital Outlay Reserve Commitments 34,994,529 0 0 0 FY2021-22 Adopted Capital Outlay Expenditures Streetlight Debt Pay-Off - Appropriations Limit 4,168,519 Goodman Commerce Infrastructure Developer Agreement Pay-Off - Appropriation 2,559,050 Subtotal Capital Outlay Expenditure Budget 6,727,569 0 0 0 FY2022-23 Proposed Reserve Commitments General Fund: Facility Construction City Hall - Appropriations Limit 5,545,900 General Fund: Facility Construction Library - Appropriations Limit 7,000,000 Subtotal Capital Outlay Reserve Commitments 12,545,900 FY2022-23 Proposed Capital Outlay Expenditures 93026: Appropriation from Reserve: Limonite Gap Bridge 2,500,000 93026: Limonite Gap Bridge 4,525,000 95001: Hamner Place 700,000 94012: Prado Dam Inundation Utlity Mitigation 155,000 95011: Facility Construction City Hall 3,100,000 95018: Modular Offices 800,000 93035: I-15 Corridor Landscaping 200,000 Subtotal Capital Outlay Expenditure Budget 2,500,000 9,480,000 FY2023-24 Proposed Reserve Commitments General Fund: Facility Construction City Hall - Appropriations Limit (3,525,400) General Fund: Limonite Gap Bridge - Appropriations Limit (2,500,000) General Fund: Equipment, Fire Truck Purchase - Appropriations Limit Release (1,500,000) General Fund: Facility, Fire Station 27 Storage Facility - Appropriations Limit Release (2,000,000) Subtotal Capital Outlay Reserve Commitments (2,500,000)(7,025,400) FY2021-22 Commitments and Expenditures FY2022-23 Appropriations From Reserve FY2022-23 Commitments and Expenditures FY2023-24 Commitments and Expenditures City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 25 CITY OF EASTVALE Fiscal Year 2023-24Annual Operating Budget Appropriations Limit Summary FY2023-24 Proposed Capital Outlay Expenditures 95011: Facility Construction City Hall 7,025,400 93026: Limonite Gap Bridge MSHCP Fees 473,750 95018: Modular Offices 209,592 Subtotal Capital Outlay Expenditure Budget 7,708,742 Remaining Appropriations Limit Surplus 0 0 0 0 City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 26 CITY OF EASTVALE Fiscal Year 2023-24Annual Operating Budget Sales Tax Summary Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2023-24 Quarter 2018-19 2019-20**2020-21 2021-22 2022-23 2023-24 Budget Quarter 1 2,454,597 2,986,937 2,873,677 10,585,289 11,716,157 12,553,129 46,250,000 Quarter 2 #2,693,017 2,807,803 3,144,645 12,241,575 13,047,245 3,846,928 Quarter 3 2,129,355 2,272,291 10,892,874 10,836,091 10,173,170 Quarterly Quarter 4 2,332,606 2,281,948 11,208,862 11,047,330 12,419,799 - Budget: TOTAL Sale 9,609,575 10,348,979 28,120,058 44,710,286 47,356,371 16,400,058 11,562,500 **Sales tax for quarter 1 2019-20 included a late payment from the state applicable to prior quarters, this timing issue is the result of a state software system conversion. As a result, the amounts for quarter 1 2019-20 appear higher than normal. NOTE: Sales tax figures represent sales tax receipts applicable to the quarters indicated. Amounts may not have been actually received in the quarter indicated, these totals may not be represented in other summary reports included in this report. Figures for recent quarters may not be complete. # The true up for Quarter 2 ending December 31, 2020 has not been received as of the publish date of this report. It was included in the FY2021-22 budget. Per HdL there is no estimated delivery date for the true up payment, as a result, the true up is not budgeted in the current year. City of Eastvale │ 12363 Limonite Avenue, Suite 910, Eastvale, CA 91752 │ (951) 361-0900 │ eastvaleca.gov 27