Loading...
2024.03 Monthly Budget ReportDQf!�C�WARD MONTHLY BUDGET FINANCIAL STATUS UPDATE To: Mayor and Council members From: Noah Crocker, Finance Director Period: March 2024 OVERVIEW: The Finance Department is committed to providing clear information to the Mayor, Council, and staff regarding the budget status of the city. We have prepared the following reports to keep you up to date on the current budget status of the city. 1) Budget Report 2) Detail Fund Summary Report BUDGET REPORT: The Budget report will first provide Operational Funds and follow up with Capital Projects Funds. This report does not include beginning fund balance. This report is designed to provide a high-level view of each fund reviewing total revenues and expenses. The report does provide expense information by department. The goal of the city is to pay all current budget year expenses with current budget year revenues. We are not quite there yet, and this will show in the Surplus (Deficit) line at the end of each fund. We expect that future budget cycles will smooth out revenues and expenditures. The Budget Report provides information on current revenues and expenditures by fund including the following: • The original budgeted amount. • Current budget which would reflect any amendments that have been made. • Period activity which details the revenue and expense activity for the period in which the report was run. • Fiscal activity will provide the year-to-date expense and revenue amounts. • Variance Shows the difference between budgeted and actual. • The percentage remaining is the amount still needed to reach the budgeted amount. CASH AND INVESTMENT FUND SUMMARY The Cash and Investment Fund Summary provides information on current total cash & investment balances by Fund. POINTS OF INTEREST: Current Expense Fund 001—The Current Expense Fund is used for the general governmental functions of the City. As of March 31, 2024, 30% of budgeted revenues were received. The table provides budget versus actual (YTD) data by source of revenue. 024 2024 Current % of Received Revenue Source Original Budget 2024Budget Property Tax Budget 2,245,000 2,407,886 107,607 Received 4.47% Period 50,769 Sales Tax 6,895,000 6,895,000 1,964,292 28.49% 609,403 Other Taxes 2,156,000 2,156,000 Pr 743,329 34.48% Pr 131,442 Total Taxes 11,296,000 11,458,886 2,815,228 24.57% 791,614 Licenses & Permits 601,200 601,200 482,661 80.28% 151,466 Intergovernmental Revenue 291,700 488,200 109,794 22.49% 58,386 Charges for Goods & Services 448,600 398,600 310,471 77.89% 183,050 Fines & Penalties 128,000 128,000 21,554 16.84% 7,961 Misc Revenues 121,500 46,500 255,714 549.92% 85,649 Non -Revenues - - 1,250 #DIV/0! (4,445) Other Financing #DIV/0! (Capital Contributions) - - 8,871 - REVENUE TOTALS 12,887,000 13,121,386 4,005,544 30.53% 1,273,683 SALES TAX REVENUES SUMMARY • Total 2024 Budget: $6,895,000 • Total 2024 YTD Actuals: $1,964,292 • Year -to -Date Actual revenue collected is 2.62% higher when compared to Prior Year -to Date Actuals • Year -to -Date Actual revenue collected is 21.51% higher when compared to Year -to Date Budgeted The following tables provide additional sales tax information: Table 1: shows revenue received by month over a three-year period. Monthly Sales Tax -Three Year Comparison 800,000 700,000 ■ 2022 Actual 600,000 ■ 2023 Actual ■ 2024 YTO Actual 500,000 400,000 300,000 200,000 100,000 0 a� a�, ��• Q�\ aJ JC2 ���� 3� °ec �� sec oec ,acJ �e.00J �.a P � > PJQo Q�ec° O`,�o °Jeco e`ei Table 2: provides current data for sales tax revenue collected Year-to-date. $800,000 Sales Tax Revenues $700,000 $600,000 $500,000 $400,000 Actuats2024 Budget 2024 $300,000 $200,000 $100,000 Jai Jack a�cr PQo\ �a� ,Joe ���� �°yam sec ooet ,oe� sec ,ao Qe�� � PJ Q`e� oe� oeco e`ec� 5e � O Real Estate Excise Tax (REET) Fund 109 and Impact Mitigation Fee Fund 111 The City's Real Estate Excise Tax receipts fluctuate monthly. March 2024 receipts are Lower than March 2023 by 12%. Total Real estate Excise Tax revenues have a YTD growth rate of-7.00%. The table below shows balances through March for REET 1 & 2 and Impact fees. These restricted funds are used as a local funding source for capital projects that have been documented in the City's comprehensive plans. REET funds are also used for debt payments. The table above shows 2024 beginning fund balances, biennial revenue received to date, expenses budgeted for the biennium and expenses which are obligated for future projects but have not yet been officially budgeted. The intent of this table is to snapshot and illustrate available balances and what is projected for the end of the biennium. Impact Fees received for March 2024 are as follows: o Parks $175,445 o Transportation $147,635 o School District Impact $47,352 REET revenues received in March: o REET 1 $69,648 o REET 2 $69,648 Capital Construction Fund 302 —The City Hall construction is underway with the Roof complete. The siding and windows are in the process of being replaced. The interior remodeling of the Police Department is nearly complete with an expected opening back to operations by May. The 2nd floor renovations have begun with an anticipated completion date by June. Street Capital Construction Fund 304 —Bay Street Pedestrian Path right of way efforts continue. The City has contracted with Skilling's Inc for Design and Right of Way Services for the Bethel -Lincoln Round -About project. Design for the project is in progress. ENTERPRISE/UTILITY FUNDS: Water operation - Water operations budgeted revenue in the amount of $3,949,000 for 2024. Through March, the city has received $917,028 or —24% of the 2024 budgeted revenues. Revenues for the water utility, in winter and spring, are typically lower with larger monthly revenues received during the warmer summer and fall months. Water Operations expended $1,123,347 through March representing—28.87% of the 2024 budget. In addition, the water operational budget includes transfers which occur throughout the year. The City manages its transfers according to policy goals, cashflow needs, and realized expenses for water capital projects, stabilization targets, and debt service payments. The 2024 budget includes $1,578,445 for transfers. A total of $16,361 was transferred out to fund 413 for Well 11 expenses. 600,000 500,000 400,000 300,000 200,000 100,000 Water Service Payments Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■ 2022 ■ 2023 ■ 2024 Sewer operation — Sewer operations budgeted revenue in the amount of $5,701,000 is budgeted for 2024. Through March, the city has received $1,628,165 or —29% of the 2024 budgeted revenues. Sewer Operations expended $1,249,894 through March representing —23.2% of the 2024 budget. The sewer operational expense budget includes transfers which occur throughout the year. The City manages its transfers according to policy goals, cashflow needs, and realized expenses for sewer capital projects, stabilization targets, and debt service payments. The 2024 budget includes $1,154,720 for transfers. A total of $2,301 was transferred out to fund 433 for Marina Pump Station expenses. Is so 300,000.00 200,000.00 100,000.00 Sewer Service Payments Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■ 2022 ■ 2023 ■ 2024 Storm Drainage operations- Storm Operations budgeted revenue in the amount of $1,745,000 for 2024. Through March, the city has received $529,744 or —31% over its annual budgeted revenue. Storm Drainage Operations expended $350,632 through March representing—18.95% of the 2024 operating budget. The storm drainage operational budget includes transfers which occur throughout the year. The City manages its transfers according to policy goals, cashflow needs, and realized expenses for storm capital projects, stabilization targets, and debt service payments. The 2024 budget includes $320,150 for transfers. There were no transfers out for the month. 180,000 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 Storm Drainage Payments Jan Feb Mar Apr May Jun Aug Sep Oct Nov Dec ■ 2022 ■ 2023 ■ 2024 Budget Report OPERATIONAL BUDGET For Fiscal: 2024 Period Ending: 03/31/2024 Group Summary Variance Original Current Period Fiscal Favorable Percent Department Total Budget Total Budget Activity Activity (Unfavorable) Remaining Fund: 001- Current Expense Revenue 00 - Revenues 12,887,000.00 13,121,386.00 1,273,682.84 4,005,543.57 -9,115,842.43 69.47% Revenue Total: 12,887,000.00 13,121,386.00 1,273,682.84 4,005,543.57 -9,115,842.43 69.47% Expense 01- Finance 1,107,300.00 1,409,300.00 115,108.23 316,717.19 1,092,582.81 77.53% 02 - Court 797,000.00 797,000.00 60,459.81 140,938.63 656,061.37 82.32% 03 - Law Enforcement 6,017,120.00 6,793,080.00 681,276.64 1,443,304.78 5,349,775.22 78.75% 04- Community Development 2,395,850.00 2,966,370.00 226,928.86 571,193.01 2,395,176.99 80.74% 05 - Public Works 2,216,887.00 2,593,257.00 536,075.39 675,572.07 1,917,684.93 73.95% 06 - Miscellaneous 0.00 2,000,000.00 5,880.46 13,783.91 1,986,216.09 99.31% 07 - Administration 1,888,531.00 1,961,531.00 135,268.33 427,603.98 1,533,927.02 78.20% Expense Total: 14,422,688.00 18,520,538.00 1,760,997.72 3,589,113.57 14,931,424.43 80.62% Fund: 001- Current Expense Surplus (Deficit): -1,535,688.00 -5,399,152.00 -487,314.88 416,430.00 5,815,582.00 107.71% Fund: 002 - City Street Fund Revenue 00 - Revenues 1,731,004.00 1,830,547.00 165,624.14 467,256.48 -1,363,290.52 74.47% Revenue Total: 1,731,004.00 1,830,547.00 165,624.14 467,256.48 -1,363,290.52 74.47% Expense 05 - Public Works 2,665,396.00 2,823,666.00 194,156.66 450,074.88 2,373,591.12 84.06% Expense Total: 2,665,396.00 2,823,666.00 194,156.66 450,074.88 2,373,591.12 84.06% Fund: 002 - City Street Fund Surplus (Deficit): -934,392.00 -993,119.00 -28,532.52 17,181.60 1,010,300.60 101.73% Fund: 003 - Stabilization Fund Revenue 00 - Revenues 0.00 0.00 14,126.59 41,316.72 41,316.72 0.00% Revenue Total: 0.00 0.00 14,126.59 41,316.72 41,316.72 0.00% Fund: 003 - Stabilization Fund Total: 0.00 0.00 14,126.59 41,316.72 41,316.72 0.00% Fund: 103 - Criminal Justice Revenue 00 - Revenues 384,000.00 384,000.00 32,834.32 128,150.35 -255,849.65 66.63% Revenue Total: 384,000.00 384,000.00 32,834.32 128,150.35 -255,849.65 66.63% Expense 03 - Law Enforcement 495,100.00 637,100.00 9,212.79 19,915.07 617,184.93 96.87% Expense Total: 495,100.00 637,100.00 9,212.79 19,915.07 617,184.93 96.87% Fund: 103 - Criminal Justice Surplus (Deficit): -111,100.00 -253,100.00 23,621.53 108,235.28 361,335.28 142.76% Fund: 104 - Special Investigative Unit Revenue 00 - Revenues 4,000.00 4,000.00 327.84 1,231.03 -2,768.97 69.22% Revenue Total: 4,000.00 4,000.00 327.84 1,231.03 -2,768.97 69.22% Expense 03 - Law Enforcement 4,000.00 4,000.00 0.00 0.00 4,000.00 100.00% Expense Total: 4,000.00 4,000.00 0.00 0.00 4,000.00 100.00% Fund: 104 - Special Investigative Unit Surplus (Deficit): 0.00 0.00 327.84 1,231.03 1,231.03 0.00% Fund: 107 - Community Events Revenue 00 - Revenues 102,200.00 102,200.00 12,878.65 36,611.80 -65,588.20 64.18% Revenue Total: 102,200.00 102,200.00 12,878.65 36,611.80 -65,588.20 64.18% Expense 07 - Administration 102,200.00 127,200.00 27.73 8,351.69 118,848.31 93.43% Expense Total: 102,200.00 127,200.00 27.73 8,351.69 118,848.31 93.43% Fund: 107 - Community Events Surplus (Deficit): 0.00 -25,000.00 12,850.92 28,260.11 53,260.11 213.04% 4/17/2024 8:51:52 AM Page 13 of 17 Budget Report Department Fund: 108 - Paths & Trails Revenue 00 - Revenues Revenue Total: Fund: 108 - Paths & Trails Total: Fund: 109 - Real Estate Excise Tax Revenue For Fiscal: 2024 Period Ending: 03/31/2024 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 1,000.00 1,000.00 182.24 518.31-481.69 48.17% 1,000.00 1,000.00 182.24 518.31-481.69 48.17% 1,000.00 1,000.00 182.24 518.31-481.69 48.17% 00 - Revenues 800,000.00 1,600,000.00 157,174.17 402,079.96 -1,197,920.04 74.87% Revenue Total: 800,000.00 1,600,000.00 157,174.17 402,079.96 -1,197,920.04 74.87% Expense 06 - Miscellaneous 298,000.00 1,397,000.00 779.16 30,408.06 1,366,591.94 97.82% Expense Total: 298,000.00 1,397,000.00 779.16 30,408.06 1,366,591.94 97.82% Fund: 109 - Real Estate Excise Tax Surplus (Deficit): 502,000.00 203,000.00 156,395.01 371,671.90 168,671.90 -83.09% Fund: 111- Impact Mitigation Fee Revenue 00 - Revenues 5.207.900.00 5.207.900.00 407 017.62 1,353,709.17 -3 854 190.83 74.01% Expense 06 - Miscellaneous 1,103,300.00 2,495,300.00 Expense Total: 1,103,300.00 2,495,300.00 Fund: 111- Impact Mitigation Fee Surplus (Deficit): 4,104,600.00 2,712,600.00 Fund: 206 - Bond Redemption Fund Revenue 407,017.62 1,353,709.17 -3,854,190.83 74.01% 42,444.30 226,983.09 2,268,316.91 90.90% 42,444.30 226,983.09 2,268,316.91 90.90% 364,573.32 1,126,726.08-1,585,873.92 58.46% 00 - Revenues 298,000.00 1,397,000.00 463.69 26,760.14 -1,370,239.86 98.08% Revenue Total: 298,000.00 1,397,000.00 463.69 26,760.14 -1,370,239.86 98.08% Expense 06 - Miscellaneous 298,000.00 995,410.00 0.00 25,403.95 970,006.05 97.45% Expense Total: 298,000.00 995,410.00 0.00 25,403.95 970,006.05 97.45% Fund: 206 - Bond Redemption Fund Surplus (Deficit): 0.00 401,590.00 463.69 1,356.19 -400,233.81 99.66% Fund: 411- Water Operating Revenue 00 - Revenues 3,949,000.00 3,949,000.00 284,734.35 917,028.34 -3,031,971.66 76.78% Revenue Total: 3,949,000.00 3,949,000.00 284,734.35 917,028.34 -3,031,971.66 76.78% Expense 05 - Public Works 3,138,532.00 3,891,412.00 779,459.00 1,123,347.91 2,768,064.09 71.13% 06 - Miscellaneous 555,800.00 1,578,445.00 16,361.97 21,658.19 1,556,786.81 98.63% Expense Total: 3,694,332.00 5,469,857.00 795,820.97 1,145,006.10 4,324,850.90 79.07% Fund: 411- Water Operating Surplus (Deficit): 254,668.00 -1,520,857.00 -511,086.62 -227,977.76 1,292,879.24 85.01% Fund: 412 - Water Stabilization Revenue 00 - Revenues 0.00 100,000.00 4,714.90 13,789.87 -86,210.13 86.21% Revenue Total: 0.00 100,000.00 4,714.90 13,789.87 -86,210.13 86.21% Fund: 412 - Water Stabilization Total: 0.00 100,000.00 4,714.90 13,789.87 -86,210.13 86.21% Fund: 414 - Water Debt Service Revenue 00 - Revenues 939,200.00 2,400,670.00 12,365.15 12,365.15 -2,388,304.85 99.48% Revenue Total: 939,200.00 2,400,670.00 12,365.15 12,365.15 -2,388,304.85 99.48% Expense 06 - Miscellaneous 939,200.00 1,144,970.00 12,365.15 12,365.15 1,132,604.85 98.92% Expense Total: 939,200.00 1,144,970.00 12,365.15 12,365.15 1,132,604.85 98.92% Fund: 414 - Water Debt Service Surplus (Deficit): 0.00 1,255,700.00 0.00 0.00-1,255,700.00 100.00% 4/17/2024 8:51:52 AM Page 14 of 17 Budget Report For Fiscal: 2024 Period Ending: 03/31/2024 Variance Original Current Period Fiscal Favorable Percent Department Total Budget Total Budget Activity Activity (Unfavorable) Remaining Fund: 421- Storm Drainage Utility Revenue 00 - Revenues 1,745,000.00 1,745,000.00 172,954.76 529,744.02 -1,215,255.98 69.64% Revenue Total: 1,745,000.00 1,745,000.00 172,954.76 529,744.02 -1,215,255.98 69.64% Expense 05 - Public Works 1,819,352.00 1,850,002.00 195,080.79 350,632.81 1,499,369.19 81.05% 06 - Miscellaneous 277,100.00 320,150.00 0.00 21,941.71 298,208.29 93.15% Expense Total: 2,096,452.00 2,170,152.00 195,080.79 372,574.52 1,797,577.48 82.83% Fund: 421- Storm Drainage Utility Surplus (Deficit): -351,452.00 -425,152.00 -22,126.03 157,169.50 582,321.50 136.97% Fund: 422 - Storm Drainage Stabilization Revenue 00 - Revenues 0.00 0.00 2,649.02 7,747.71 7,747.71 0.00% Revenue Total: 0.00 0.00 2,649.02 7,747.71 7,747.71 0.00% Fund: 422 - Storm Drainage Stabilization Total: 0.00 0.00 2,649.02 7,747.71 7,747.71 0.00% Fund: 424 - Storm Drainage Debt Service Revenue 00 - Revenues 177,100.00 220,150.00 0.00 21,941.71 -198,208.29 90.03% Revenue Total: 177,100.00 220,150.00 0.00 21,941.71 -198,208.29 90.03% Expense 06 - Miscellaneous 177,100.00 220,150.00 0.00 21,941.71 198,208.29 90.03% Expense Total: 177,100.00 220,150.00 0.00 21,941.71 198,208.29 90.03% Fund: 424 - Storm Drainage Debt Service Surplus (Deficit): 0.00 0.00 0.00 0.00 0.00 0.00% Fund: 431- Sewer Operating Revenue 00 - Revenues 5,701,000.00 5,701,000.00 466,468.49 1,628,165.82 -4,072,834.18 71.44% Revenue Total: 5,701,000.00 5,701,000.00 466,468.49 1,628,165.82 -4,072,834.18 71.44% Expense 05 - Public Works 4,889,732.00 5,389,012.00 625,198.65 1,249,893.65 4,139,118.35 76.81% 06 - Miscellaneous 709,900.00 1,154,720.00 2,301.59 6,291.56 1,148,428.44 99.46% Expense Total: 5,599,632.00 6,543,732.00 627,500.24 1,256,185.21 5,287,546.79 80.80% Fund: 431- Sewer Operating Surplus (Deficit): 101,368.00 -842,732.00 -161,031.75 371,980.61 1,214,712.61 144.14% Fund: 432 - Sewer Stabilization Revenue 00 - Revenues 0.00 100,000.00 7,056.06 20,637.16 -79,362.84 79.36% Revenue Total: 0.00 100,000.00 7,056.06 20,637.16 -79,362.84 79.36% Fund: 432 - Sewer Stabilization Total: 0.00 100,000.00 7,056.06 20,637.16 -79,362.84 79.36% Fund: 434 - Sewer Debt Service Revenue 00 - Revenues 678,900.00 1,067,720.00 4,001.83 11,704.32 -1,056,015.68 98.90% Revenue Total: 678,900.00 1,067,720.00 4,001.83 11,704.32 -1,056,015.68 98.90% Expense 06 - Miscellaneous 403,900.00 465,970.00 0.00 0.00 465,970.00 100.00% Expense Total: 403,900.00 465,970.00 0.00 0.00 465,970.00 100.00% Fund: 434 - Sewer Debt Service Surplus (Deficit): 275,000.00 601,750.00 4,001.83 11,704.32 -590,045.68 98.05% Fund: 500 - Equipment Rental and Revolving Revenue 00 - Revenues 1,309,800.00 3,378,200.00 133,105.95 261,459.21 -3,116,740.79 92.26% Revenue Total: 1,309,800.00 3,378,200.00 133,105.95 261,459.21 -3,116,740.79 92.26% Expense 10 - ER&R 801,600.00 1,165,100.00 741,059.67 1,069,519.77 95,580.23 8.20% 4/17/2024 8:51:52 AM Page 15 of 17 Budget Report For Fiscal: 2024 Period Ending: 03/31/2024 Variance Original Current Period Fiscal Favorable Percent Department Total Budget Total Budget Activity Activity (Unfavorable) Remaining Expense Total: 801,600.00 1,165,100.00 741,059.67 1,069,519.77 95,580.23 8.20% Fund: 500 - Equipment Rental and Revolving Surplus (Deficit): 508,200.00 2,213,100.00 -607,953.72 -808,060.56 -3,021,160.56 136.51% Report Surplus (Deficit): 2,814,204.00 -1,870,372.00 -1,227,082.57 1,659,918.07 3,530,290.07 188.75% 4/17/2024 8:51:52 AM Page 16 of 17 (,�V City of Port Orchard ORCHARD CAPITAL BUDGET Account Typ... Fund: 302 - Capital Construction Revenue Expense Fund: 302 - Capital Construction Surplus (Deficit) Fund: 304 - Street Capital Projects Original Current Total Budget Total Budget Budget Report Group Summary For Fiscal: 2024 Period Ending: 03/31/2024 Variance Period Fiscal Favorable Percent Activity Activity (Unfavorable) Remaining 370,000.00 2,650,000.00 39,970.40 138,437.43-2,511,562.57 94.78% 370,000.00 2,650,000.00 25,960.02 574,485.36 2,075,514.64 78.32% 0.00 0.00 14,010.38-436,047.93-436,047.93 0.00% Revenue 220,000.00 2,867,000.00 17,358.97 310,949.97 -2,556,050.03 89.15% Expense 290,000.00 2,592,500.00 7,813.27 102,877.20 2,489,622.80 96.03% Fund: 304 - Street Capital Projects Surplus (Deficit): -70,000.00 274,500.00 9,545.70 208,072.77 -66,427.23 24.20% Fund: 413 - Water Capital Revenue 2,232,700.00 2,195,700.00 181,725.57 1,643,976.33 -551,723.67 25.13% Expense 883,400.00 2,122,225.00 422,049.65 430,440.51 1,691,784.49 79.72% Fund: 413 - Water Capital Surplus (Deficit): 1,349,300.00 73,475.00 -240,324.08 1,213,535.82 1,140,060.82-1,551.63% Fund: 423 - Storm Drainage Capital Facil Revenue 100,000.00 100,000.00 935.92 2,737.32 -97,262.68 97.26% Expense 100,000.00 100,000.00 0.00 0.00 100,000.00 100.00% Fund: 423 - Storm Drainage Capital Facil Surplus (Deficit): 0.00 0.00 935.92 2,737.32 2,737.32 0.00% Fund: 433 - Sewer Capital Revenue 3,491,500.00 4,491,500.00 277,159.73 1,999,885.02-2,491,614.98 55.47% Expense 369,000.00 2,265,000.00 43,423.10 971,435.79 1,293,564.21 57.11% Fund: 433 - Sewer Capital Surplus (Deficit): 3,122,500.00 2,226,500.00 233,736.63 1,028,449.23-1,198,050.77 53.81% Report Surplus (Deficit): 4,401,800.00 2,574,475.00 17,904.55 2,016,747.21-557,727.79 21.66% 4/17/2024 8:55:36 AM Page 1 of 2 Detail Report Fund CASH & INVESTMENTS 001- Current Expense 002 - City Street Fund 003 - Stabilization Fund 103 - Criminal Justice 104 - Special Investigative Unit 107 - Community Events 108 - Paths & Trails 109 - Real Estate Excise Tax 111- Impact Mitigation Fee 206 - Bond Redemption Fund 302 - Capital Construction 304 - Street Capital Projects 401- Water -Sewer Utilities 403 - Water -Sewer Cumulative Reserve 411- Water Operating 412 - Water Stabilization 413 - Water Capital 414 - Water Debt Service 421- Storm Drainage Utility 422 - Storm Drainage Stabilization 423 - Storm Drainage Capital Facil 424 - Storm Drainage Debt Service 431- Sewer Operating 432 - Sewer Stabilization 433 - Sewer Capital 434 - Sewer Debt Service 500 - Equipment Rental and Revolving 631- Trust and Agency 632 - Wastewater Treatment Facil Fee Grand Total: 4/16/2024 3:29:33 PM Beginning Balance 18,243,330.75 4,018,947.18 3,098,939.97 836,944.32 101,808.73 409,288.52 16,147.00 6,280,366.99 8,886,839.97 100,907.35 7,500,627.23 2,353,446.31 0.00 0.00 4,728,106.76 1,026,023.68 9,712,087.17 0.00 1,963,446.61 576,461.97 203,667.42 0.00 8,299,178.59 1,535,490.09 8,241,408.54 870,850.77 3,584,080.64 6,325.21 6,667,721.56 99,262,443.33 Total Activity Ending Balance -487,314.88 17,756,015.87 -28,532.52 3,990,414.66 14,122.22 3,113,062.19 23,621.53 860,565.85 327.84 102,136.57 12,850.92 422,139.44 182.24 16,329.24 156,395.01 6,436,762.00 364,573.32 9,251,413.29 463.69 101,371.04 14,010.38 7,514,637.61 9,545.70 2,362,992.01 0.00 0.00 0.00 0.00 -511,086.62 4,217,020.14 4,714.90 1,030,738.58 -240,324.08 9,471,763.09 0.00 0.00 -22,126.03 1,941,320.58 2,649.02 579,110.99 935.92 204,603.34 0.00 0.00 -161,031.75 8,138,146.84 7,056.06 1,542,546.15 233,736.63 8,475,145.17 4,001.83 874,852.60 -607,953.72 2,976,126.92 2,136.71 8,461.92 131,708.96 6,799,430.52 -1,075,336.72 98,187,106.61 Date Range: 03/01/2024 - 03/31/2024 Fund Summary Page 5 of 5