Loading...
HomeMy WebLinkAbout2025.05 Monthly Budget ReportTo: Mayor and Council members From: Noah Crocker, Finance Director Period: May 2025 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 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 May 30, 2025, 53% of budgeted revenues were received. The table provides budget versus actual (YTD) data by source of revenue. SALES TAX REVENUES SUMMARY • Total 2025 Budget: $7,300,000 • Total 2025 YTD Actuals: $3,154,076 • Year -to -Date Actual revenue collected is 2.04% lower when compared to Prior Year -to -Date Actuals • Year -to -Date Actual revenue collected is 11.4% 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. Table 2:provides current data for sales tax revenue collected Year-to-date. ENTERPRISENTILITY FUNDS OPERATIONS: Water operation Water operations budgeted revenue in the amount of $4,305,885 for 2025. Through May, the city has received $1,651,751 or —39% of the 2025 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,390,827 through May representing —35% of the 2025 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 2O25budget includes $1,9447OOfor transfers. Atotal of$l6,53Owas Water Service Payment 700,000 3 r4,00 4CX),000 02023 300,000 82024 202 200,000 1,L)0,000 In Jan Feb Mat Apr May Jun Jul Aug Sep Oct Nov Dec Storm Drainage operations- Storm Operations budgeted revenue in the amount of $2,448,800 for 2025. Through May, the city has received $1,492,689 or-61% of its annual budgeted revenue. Storm Drainage Operations expended $652,891 through May, representing —30% of the 2025 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 2025 budget includes $723,800 for transfers. A total of $0 was transferred to fund 423 for SR166/Bay Street Reconstruction. Storm Drainage Payment 350,000 250,000 200,000 2023 yy 0 0 �., 02024 j 4 225 [yf }#'�qq(„qq{{qq C a � 2 50,000 3 � t � � p yarn Feb Mar Apr May Wn Jul Aug Sep Oct Nov Dec Sewer operation — Sewer operations budgeted revenue in the amount of $6,071,750 is budgeted for 2025. Through May, the city has received $2,908,495 or —48% of the 2025 budgeted revenues. Sewer Operations expended $1,970,875 through May representing —35% of the 2025 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 2025 budget includes $2,083,075 for transfers. A total of $307,215 was transferred to fund 433 for Marina Pump Station, and SR166/Bay Street Reconstruction, Pottery DS, Sewer Lift Stations DS, Bay St DS. Seeger Service Payments 700,000 600,000 500,000 a - 00,00 ;.R 2025 N 2024 300,000 ` 2025 200,a 0t3 a e 100,0O0 z 7 , u Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Real Estate Excise Tax (REET) Fund 109 and Impact Mitigation Fee Fund 111 The City's Real Estate Excise Tax receipts fluctuate monthly. May 2025 receipts are higher than May 2024 by 39%. Total Real estate Excise Tax revenues have a YTD growth rate of 46%. The table below shows balances through May 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. LA 2025-2026 Beginning Balance 3,916,725 370,473 211,452 6,847,926 1,903,311 4,620,216 29,984 93,800 2025-2026 Revenue Received*'. - 505,180 6,582 125,268 563,778 526,122 571,779 - 121,573 - 2025-2026Expenses Budgeted (59,000).. (1,173,500)', (300,000) (3,910,532) (3,217,200) (5,032,100) (29,994) (807,519) (93,800) 2025-20260bligatedExpenses (3,248,406)', (77,056) - (183,800) (600,000) - - 2025-2026 Ending Balance (59,000), - - 336,720 3,501,172 (971,568)j (440,104)j (0)', (685,946) - The table above shows 2025 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 May 2025 are as follows: o Parks $259,946 o Transportation $243,070 o School District Impact $66,739 REET revenues received in May: o REET 1 $119,036 o REET 2 $119,036 CAPITAL CONSTRUCTION BUDGET PROGRESS Capital Construction Fund 302: The following General capital projects are in progress: 1) Project Account #15-City Hall Remodel a. City Staff Time, Construction —Nearing completion 2) Project Account #18-South Kitsap Community Events Center including Plaza a. City Staff Time, Design Consulting Services 3) Project Account #53-Givens Park Sport Court Remodel a. City Staff Time, Design Consulting Services Street Capital Construction Fund 304: The following Street capital projects are in progress: 1) Project Account #11-TIP 1.1 Bay St Pedestrian Path ROW a. City Staff Time, Right of Way Consulting Services 2) Project Account #45-TIP 1.14 Sidney non -motorized a. City Staff Time, Design Consulting Services 3) Project Account #41-TIP 1.15 Pottery Ave Non -Motorized a. City Staff Time, Construction Mgmt. Services, Construction 4) Project Account #42-TIP 1.16 SR166/Bay Street Re -Construction a. City Staff Time, Design Consulting Services 5) Project Account #47-TIP 1.18 Tremont Phase 2 &3 a. City Staff Time, Design Consulting Services 6) Project Account #27-TIP 1.2 Bay St Pedestrian Path Construction a. City Staff Time, Design Consulting Services 7) Project Account #22-TIP 1.7 Bethel Phase 5a-Mitchel Roundabout a. City Staff Time, Construction Mgmt. Services, Construction 8) Project Account #38-TIP 1.8 & 1.9 Blueberry & Salmonberry a. City Staff Time, Design Consulting Services 9) Project Account #65-TIF 1.4 Anderson Hill RAB a. City Staff Time, 10) Project Account #66-TIP 1.19 SB 160 2A a. City Staff Time, Water Capital Construction Fund 413: The following Water capital projects are in progress: 1) Project Account #16-Water CIP #3-Well 11 Treatment and Pumping Site Improvements a. City Staff Time, Design Services, Construction 2) Project Account #364NaLerC|P#1U-Me|cherPump Station Rehab a. City Staff Time, Design Services, 3) Project Account #41-PotteryAve Non -Motorized (VVaLer) a. City Staff Time, Construction K4QmL Services, Construction 4) Project Account #42-VVaLerC|P#l9a Water Main- SR16613ayVVater Re -Construction a. City Staff Time, Design Services 5) Project Account #6U-VVe||#7 a. Nothing atthis time 6) Project Account #67-VVate/OP#Z2 Foster Mitigation a. City Staff Time, 7) Project Account #7O-VVate/C|P#U8 Old Clifton Water Main 390'580 |ntertie a. City Staff Time, Design Service Storm Drainage Capital Construction Fund 423: The following Storm Capital projects are inprogress: 1) Project Account #41-Pottery Ave Non -Motorized (Stonn) a. City Staff Time, Design Services, Construction 2) Project Account #42-T|P1.26SR166/8ayStreet Re -Construction a. City Staff Time, Design Services 3) Project Account #6O-SouthSidney Regional StormwaterFacility a. City Staff Time, Design Services 4) Project Account #72-RubyCreek Culvert Replacement a. City Staff Time,Dedgn Sewer Capital Construction Fund 433: The following Sewer capital projects are inprogress: 1) Project Account #O4-SewerOP#1'K4arina5VVPump Station a. City Staff Time, Design Services, Construction 2) Project Account #37-SewerLift Station Controls Upgrade a. City Staff Time, Design Services 3) Project Account #41-Pot1eryAve Non -Motorized (Sewer) a. City Staff Time, Construction K4QmL Services, Construction 4) Project Account #42-T|P1.26SR166/8ayStreet Re -Construction a. City Staff Time, Design Services 5) Project Account #43-SVVOP#SUSouth Sidney Lift Station (Ruby Creek) a. City Staff Time, Design Services 6) Project Account #45-2"aSidney Force Main a. City Staff Time, Design Services 7) Project Account #58'8ayStreet Sewer Lift Station Design a. City Staff Time, Design Services Budget Report For Fiscal: 2025 Period Ending: 05/31/2025 Operations Budget Group summary Departmen... Fund: 001- Current Expense Revenue 00 - Revenues Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 14,581,138.07 14,581,138.07 1,362,252.63 7,647,307.67 -6,933,830.40 47.55% Revenue Total: 14,581,138.07 14,581,138.07 1,362,252.63 7,647,307.67 -6,933,830.40 47.55% Expense 01- Finance 1,208,345.51 1,208,345.51 65,266.05 414,695.67 793,649.84 65.68% 02 - Court 663,800.00 663,800.00 36,793.44 205,078.30 458,721.70 69.11% 03 - law Enforcement 6,693,982.59 6,693,982.59 432,482.45 2,430,273.37 4,263,709.22 63.69% 04 - Community Development 3,292,767.68 3,292,767.68 228,735.08 1,160,781.63 2,131,986.05 64.75% 05 - Public Works 2,270,214.22 2,270,214.22 140,849.31 1,071,379.97 1,198,834.25 52.81% 06 - Miscellaneous 1,863,000.00 1,863,000.00 2,459.24 14,524.97 1,848,475.03 99.22% 07-Administration 2,098,917.00 2,098,917.00 115,379.86 742,456.96 1,356,460.04 64.63% Expense Total: 18,091,027.00 18,091,027.00 1,021,965.43 6,039,190.87 12,051,836.13 66.62% Fund: 001- Current Expense Surplus (Deficit): -3,509,888.93 -3,509,888.93 340,287.20 1,608,116.80 5,118,005.73 145.82% Fund: 002 - City Street Fund Revenue 00 - Revenues 4,072,866.00 4,072,866.00 231,930.55 1,426,557.57 2,646,308.43 64.97% Revenue Total: 4,072,866.00 4,072,866.00 231,930.55 1,426,557.57-2,646,308.43 64.97% Expense 05 - Public Works 4,043,805.00 4,043,805.00 150,912.76 804,447.38 3,239,357.62 80.11% 06 - Miscellaneous ............. 2,439,100.00 ., 2,439,100.00 0.00 0.00 2,439,100.00 100.00% Expense Total: 6,482,905.00 6,482,905.00 150,912.76 804,447.38 5,678,457.62 87.59% Fund: 002 - City Street Fund Surplus (Deficit): -2,410,039.00 -2,410,039.00 81,017.79 622,110.19 3,032,149.19 125.81% Fund: 003 - Stabilization Fund Revenue 00-Revenues 130,000.00 130,000.00 12,105.31 59,159.31 -70,840.69 54.49% Revenue Total: 130,000.00 130,000.00 12,105.31 59,159.31 -70,840.69 54.49% Fund: 003 - Stabilization Fund Total: 130,000.00 130,000.00 12,105.31 59,159.31 -70,840.69 54.49% Fund: 103 - Criminal Justice Revenue 00 - Revenues 438,800.00 438,800.00 38,110.98 199,818.27-238,981.73 54.46% Revenue Total: 438,800.00 438,800.00 38,110.98 199,818.27-238,981.73 54.46% Expense 03 - law Enforcement ..... 651,800.00 651,800.00 10,338.84 138,566.53 513,233.47 _....... 78.74% Expense Total: 651,800.00 651,800.00 10,338.84 138,566.53 513,233.47 78.74% Fund: 103 - Criminal Justice Surplus (Deficit): -213,000.00 -213,000.00 27,772.14 61,251.74 274,251.74 128.76% Fund: 104 - Special Investigative Unit Revenue 00 - Revenues 0.00 0.00 393.45 1,813.80 1,813.80 0.00% Revenue Total: 0.00 0.00 393.45 1,813.80 1,813.80 0.00% Expense 03 - law Enforcement 4,000.00 4,000.00 0.00 -300.00 4,300.00 107.50% Expense Total: 4,000.00 4,000.00 0.00 -300.00 4,300.00 107.50% _.. Fund: 104 - Special Investigative Unit Surplus (Deficit): -4,000.00 -4,000.00 393.45 2,113.80 6,113.80 152.85% Fund: 107 - Community Events Revenue 00 - Revenues 102,200.00 102,200.00 16,323.81 67,790.92 -34,409.08 33.67% Revenue Total: 102,200.00 102,200.00 16,323.81 67,790.92 -34,409.08 33.67% Expense 07-Administration 102,200.00 102,200.00 63.21 882.26 101,317.74 99.14% 6/1 7,/ 025 3:08:24 PM Pace 14 of 18 Budget Report For Fiscal: 2025 Period Ending: 05/31/2025 Variance Original Current Period Fiscal Favorable Percent Departmen... Total Budget Total Budget Activity Activity (Unfavorable) Remaining Expense Total: 102,200.00 102,200.00 63.21 882.26 101,317.74 99.14% Fund: 107 - Community Events Surplus (Deficit): 0.00 0.00 16,260.60 66,908.66 66,908.66 0.00% Fund: 108 - Paths & Trails Revenue 00 - Revenues 1,000.00 1,000.00 130.83 729.68 -270.32 27.03% Revenue Total: 1,000.00 1,000.00 130.83 729.68 -270.32 27.03% Fund: 108 - Paths & Trails Total: 1,000.00 1,000.00 130.83 729.68 -270.32 27.03% Fund: 109 - Real Estate Excise Tax Revenue 00 - Revenues 1,600,900.00 ........_.... 1,600,900.00 264,988.57 1,097,900.94 ..._._ -502,999.06 31.42% Revenue Total 1,600,900.00 1,600 900.00 264,988.57 1,097,900.94 -502,999.06 31.42% Expense 06 - Miscellaneous 7,003,900.00 7,003,900.00 40,306.81 76,036.29 6,927,863.71 98.91% Expense Total: 7,003,900.00 7,003,900.00 40,306.81 76,036.29 6,927,863.71 98.91% Fund: 109 - Real Estate Excise Tax Surplus (Deficit): -5,403,000.00 -5,403,000.00 224,681.76 1,021,864.65 6,424,864.65 118.91% Fund: 111- Impact Mitigation Fee Revenue 00-Revenues 2,915,138.00 2,915,138.00 613,575.47 1,322,381.79 -1,592,756.21 54.64% Revenue Total: 2,915,138.00 2,915,138.00 613,575.47 1,322,381.79 -1,592,756.21 54.64% Expense 06 - Miscellaneous 5,600,107.00 5,600,107.00 81,479.13 196,594.62 5,403,512.38 96.49% Expense Total: 5,600,107.00 5,600,107.00 81,479.13 196,594.62 5,403,512.38 96.49% Fund: 111- Impact Mitigation Fee Surplus (Deficit): -2,684,969.00 -2,684,969.00 532,096.34 1,125,787.17 3,810,756.17 141.93% Fund: 206 - Bond Redemption Fund Revenue 00-Revenues ................. 1,247,500.00 1,247,500.00 1,950.62 32,355.59 _. -1,215,144.41 97.41% Revenue Total: 1,247,500.00 1,247,500.00 1,950.62 32,355.59 -1,215,144.41 97.41% Expense 06 - Miscellaneous ..... 996,900..... .... Expense Total: 996,900.00 996,900.00 0.00 22,822.80 974,077.20 97.71% _.................... Fund: 206 - Bond Redemption Fund Surplus (Deficit): 250,600.00 250,600.00 1,950.62 _ 9,532.79 -241,067.21 _ 96.20% Fund: 411- Water Operating Revenue 00-Revenues 4,305,885.00 4,305,885.00 299,549.14 1,651,751.94-2,654,133.06 61.64% Revenue Total: 4,305,885.00 4,305,885.00 299,549.14 1,651,751.94-2,654,133.06 61.64% Expense 05 - Public Works 4,066,174.99 4,066,174.99 196,302.37 1,390,827.62 2,675,347.37 65.80% 06 - Miscellaneous 1,944,700.00 1,944,700.00 16,538.86 45,102.17 1,899,597.83 97.68% Expense Total: 6,010,874.99 6,010,874.99 212,841.23 1,435,929.79 4,574,945.20 76.11% Fund: 411- Water Operating Surplus (Deficit): -1,704,989.99 -1,704,989.99 86,707.91 215,822.15 1,920,812.14 112.66% Fund: 412 - Water Stabilization Revenue 00 - Revenues 0.00 0.00 4,417.13 21,586.81 21,586.81 0.00% Revenue Total 0.00 0.00 4,417.13 21,586.81 21 586.81 0.00% Fund: 412 - Water Stabilization Total: 0.00 0.00 4,417.13 21,586.81 21,586.81 0.00% Fund: 414 - Water Debt Service Revenue 00-Revenues 1,340,500.00 1,340,500.00 75,360.40 94,192.36-1,246,307.64 92.97% Revenue Total: 1,340,500.00 1,340,500.00 75,360.40 94,192.36-1,246,307.64 92.97% Expense 06 - Miscellaneous 1,340,400.00 1,340,400.00 70,515.61 70,515.61 1,269,884.39 94.74% 6/1 7,/ 025 3;08:24 PINT Page 15 0(18 Budget Report For Fiscal: 2025 Period Ending: 05/31/2025 Variance Original Current Period Fiscal Favorable Percent Departmen... Total Budget Total Budget Activity Activity (Unfavorable) Remaining Expense Total: 1,340,400.00 1,340,400.00 70,515.61 70,515.61 1,269,884.39 94.74% Fund: 414 - Water Debt Service Surplus (Deficit): 100.00 100.00 4,844.79 23,676.75 23,576.75 23,576.75% Fund: 421- Storm Drainage Utility Revenue 00-Revenues ............ 2,448,800.00 2,448,800.00 302,779.39 1,492,689.50 -956,110.50 39.04% Revenue Total: 2,448,800.00 2,448,800.00 302,779.39 1,492,689.50 -956,110.50 39.04% Expense 05 - Public Works 2,199,044.90 2,199,044.90 114,669.03 652,891.91 1,546,152.99 70.31% 06 - Miscellaneous 723,800.00 723,800.00 0.00 21,060.03 702,739.97 97.09% Expense Total: 2,922,844.90 2,922,844.90 114,669.03 673,951.94 2,248,892.96 76.94% _........_ Fund: 421- Storm Drainage Utility Surplus (Deficit) _. .. -474,044.90 ....__ _. .. ........ -474,044.90 188,110.36 818,737.56 ...._ 1,292,782.46 272.71% Fund: 422 - Storm Drainage Stabilization Revenue 00 - Revenues 75,000.00 75,000.00 2,269.87 11,093.00-63,907.00 85.21% Revenue Total: 75,000.00 75,000.00 2,269.87 11,093.00-63,907.00 85.21% Fund: 422 - Storm Drainage Stabilization Total: 75,000.00 75,000.00 2,269.87 11,093.00-63,907.00 85.21% Fund: 424 - Storm Drainage Debt Service Revenue 00 - Revenues 444,000.00 444,000.00 0.00 20,551.86-423,448.14 95.37% Revenue Total: 444,000.00 444,000.00 0.00 20,551.86-423,448.14 95.37% Expense 06 - Miscellaneous 221,000.00 221,000.00 0.00 20,551.86 200,448.14 90.70% Expense Total: 221,000.00 221,000.00 0.00 20,551.86 200,448.14 90.70% _.................._. _ �., Fund: 424 - Storm Drainage Debt Service Surplus (Deficit): 223,000.00 223,000.00 0.00 0.00-223,000.00 100.00% Fund: 431- Sewer Operating Revenue 00-Revenues 6,071,750.00 6,071,750.00 489,821.08 2,908,495.05-3,163,254.95 52.10% ........_._._.._..,. .......... ..... .. Revenue Total: 6,071,750.00 6,071,750.00 489,821.08 2,908,495.05-3,163,254.95 52.10% Expense 05 - Public Works 5,661,694.90 5,661,694.90 358,357.26 1,970,875.10 3,690,819.80 65.19% 06 - Miscellaneous 2,083,075.00 2,083,075.00 307,215.73 602,299.61 1,480,775.39 71.09% Expense Total: 7,744,769.90 7,744,769.90 665,572.99 2,573,174.71 5,171,595.19 66.78% Fund: 431- Sewer Operating Surplus (Deficit). -1,673,019.90 -1,673,019.90 -175,751.91 335,320.34 2,008,340.24 120.04% Fund: 432 - Sewer Stabilization Revenue 00 - Revenues 0.00 0.00 6,423.20 31,390.59 31,390.59 0.00% Revenue Total: 0.00 0.00 6,423.20 31,390.59 31,390.59 0.00% Fund: 432 - Sewer Stabilization Total: 0.00 0.00 6,423.20 31,390.59 31,390.59 0.00% Fund: 434 - Sewer Debt Service Revenue 00 - Revenues 1,081,900.00 1,081,900.00 33,060.53 55,436.49-1,026,463.51 94.88% Revenue Total: 1,081,900.00 1,081,900.00 33,060.53 55,436.49-1,026,463.51 94.88% Expense 06 - Miscellaneous 1,081,500.00 1,081,500.00 27,304.01 27,304.01 1,054,195.99 .......... 97.48% Expense Total: 1,081,500.00 1,081,500.00 27,304.01 27,304.01 1,054,195.99 97.48% Fund: 434 - Sewer Debt Service Surplus (Deficit): 400.00 400.00 5,756.52 28,132.48 27,732.48 -6,933.12% Fund: 500 - Equipment Rental and Revolving Revenue 00 - Revenues .................. 1,954,800.00 ., 1,954,800.00 148,068.64 563,741.75 -1,391,058.25 71.16% Revenue Total: 1,954,800.00 1,954,800.00 148,068.64 563,741.75 -1,391,058.25 71.16% Expense 10-ER&R 3,110,600.00 3,110,600.00 65,029.02 845,051.77 2,265,548.23 72.83% 6/1 7,/2025 3:08:24 PINT Page 16 of 18 Budget Report For Fiscal: 2025 Period Ending: 05/31/2025 Original Current Period Departmen Total Budget Total Budget Activity Expense Total: 3,110,600.00 3,110,600.00 65,029.02 Fund: 500 - Equipment Rental and Revolving Surplus (Deficit): -1,155,800.00 -1,155,800.00 83,039.62 Report Surplus (Deficit): -18,552,651.72 -18,552,651.72 1,442,513.53 Variance Fiscal Favorable Percent Activity (Unfavorable) Remaining 845,051.77 2,265,548.23 72.83% -281,310.02 874,489.98 75.66% 5,782,024.45 24,334,676.17 131.17% 6/17/2025 3M:24 PM Pago 17 of 18 Budget Report Capital Budget For Fiscal: 2025 Period Ending: 05/31/2025 Group Summary Variance Original Current Period Fiscal Favorable Percent Account Typ... Total Budget Total Budget Activity Activity (Unfavorable) Remaining Fund: 302 - Capital Construction Revenue 2,172,300.00 2,172,300.00 43,037.48 84,724.82 -2,087,575.18 96.10% Expense 4,742,100.00 4,742,100.00 190,746.13 454,837.47 4,287,262.53 90.41% Fund: 302 - Capital Construction Surplus (Deficit): -2,569,800.00 -2,569,800.00 -147,708.65 -370,112.65 2,199,687.35 85.60% Fund: 304 - Street Capital Projects Revenue 20,240,280.00 20,240,280.00 165,113.25 891,295.25 -19,348,984.75 95.60% Expense ........... 20,947,500.00 20,947,500.00 141,502.30 318,520.50 20,628,979.50 _.... 98.48% Fund: 304 - Street Capital Projects Surplus (Deficit) -707,220.00 -707,220.00 23,610.95 572,774.75 1,279,994.75 180.99% Fund: 413 - Water Capital Revenue 8,124,800.00 8,124,800.00 285,827.53 2,989,856.64 -5,134,943.36 63.20% Expense 8,432,800.00 8,432,800.00 321,897.99 356,976.32 8,075,823.68 95.77% Fund: 413 - Water Capital Surplus (Deficit): -308,000.00 -308,000.00 -36,070.46 2,632,880.32 2,940,880.32 954.83% Fund: 423 - Storm Drainage Capital Facil Revenue 1,273,500.00 1,273,500.00 127,020.06 477,727.99 -795,772.01 62.49% Expense 1,460,000.00 1,460,000.00 0.00 508.17 1,459,491.83 99.97% Fund: 423 - Storm Drainage Capital Facil Surplus (Deficit): -186,500.00 -186,500.00 127,020.06 477,219.82 663,719.82 355.88% Fund: 433 - Sewer Capital Revenue 16,135,800.00 16,135,800.00 769,203.07 4,297,698.59 -11,838,101.41 73.37% Expense 16,729,825.00 16,729,825.00 577,105.45 1,840,763.44 14,889,061.56 89.00% Fund: 433 - Sewer Capital Surplus (Deficit):-594,025.00 -594,025.00 192,097.62 2,456,935.15 3,050,960.15 513.61% Report Surplus (Deficit).-4,365,545.00 -4,365,545.00 158,949.52 5,769,697.39 10,135,242.39 232.16% 6/1 7,/ 025 3. 35:13 PM Pale 3 of 4 Detail Report Cash & Investments Date Range: 05/01/2025 - 05/31/2025 Fund Summary Fund Beginning Balance Total Activity Ending Balance 001- Current Expense 19,703,982.42 340,287.20 20,044,269.62 002 - City Street Fund 4,989,455.29 81,017.79 5,070,473.08 003 - Stabilization Fund 3,282,439.04 12,105.31 3,294,544.35 103 - Criminal Justice 610,305.96 27,772.14 638,078.10 104 - Special Investigative Unit 106,816.21 393.45 107,209.66 107 - Community Events 523,031.77 16,260.60 539,292.37 108 - Paths & Trails 18,588.23 130.83 18,719.06 109 - Real Estate Excise Tax 7,320,709.90 224,681.76 7,545,391.66 111- Impact Mitigation Fee 11,808,416.89 532,096.34 12,340,513.23 206 - Bond Redemption Fund 524,952.80 1,950.62 526,903.42 302 - Capital Construction 1,345,572.38 -147,708.65 1,197,863.73 304 - Street Capital Projects 1,501,275.79 23,610.95 1,524,886.74 401- Water -Sewer Utilities 0.00 0.00 0.00 403 - Water -Sewer Cumulative Reserve 0.00 0.00 0.00 411- Water Operating 2,883,276.71 86,707.91 2,969,984.62 412 - Water Stabilization 1,188,745.63 4,417.13 1,193,162.76 413 - Water Capital 11,105,774.04 -36,070.46 11,069,703.58 414 - Water Debt Service 1,303,836.69 4,844.79 1,308,681.48 421- Storm Drainage Utility 2,958,870.27 188,110.36 3,146,980.63 422 - Storm Drainage Stabilization 610,871.13 2,269.87 613,141.00 423 - Storm Drainage Capital Facil 1,292,591.86 127,020.06 1,419,611.92 424 - Storm Drainage Debt Service 0.00 0.00 0.00 431- Sewer Operating 9,265,454.84 -175,751.91 9,089,702.93 432 - Sewer Stabilization 1,728,622.19 6,423.20 1,735,045.39 433 - Sewer Capital 12,459,506.62 192,097.62 12,651,604.24 434 - Sewer Debt Service 1,549,204.55 5,756.52 1,554,961.07 500 - Equipment Rental and Revolving 5,124,279.39 83,039.62 5,207,319.01 631- Trust and Agency 11,948.84 4,566.33 16,515.17 632 - Wastewater Treatment Facil Fee 8,505,100.67 163,065.74 8,668,166.41 Grand Total: 111,723,630.11 1,769,095.12 113,492,725.23 6/ 1 7,/ 025 3:08:44 PM Page 5 cif 5