Loading...
2024.12 Monthly Budget ReportTo: Mayor and Council members From: Noah Crocker, Finance Director Period: December 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 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 OFINTEREST: Current Expense Fund 001 —The Current Expense Fund is used for the general governmental functions of the City. As of December]1, 2024, 1]496ofbudgeted revenues were received. You'll note the driving factor in our positive revenue isLicenses & Permits (one'time)revenues. Sales Tax has now exceeded our fiscal year budget and property taxes are on track to match its budget. The table provides budget versus actual (YTD) data by source of revenue. ~ Total ZO24Budget: $6,895,000 • Total 2O24YTDActua|s: $8,031,757 • Yeor-to'DateActual revenue collected is 4.05% higher when compared toPrior Year -to Date Actua|s • Year -to -Date Actual revenue collected is 16.49% higher when compared to Year -to Date Budgeted The following tables provide additional sales tax information: Tablez: shows revenue received by month over athree-year period. Table 2:provides current data for sales tax revenue collected Year-to-date. Water operation Water operations budgeted revenue in the amount of $3,949,000 for 2024. Through December, the city has received $4,586,528 or —112% 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 $4,586,528 through December representing —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 $2,146,695 for transfers. A total of $100,000 was transferred to fund 412-Stabilization. A total of $101,633 was transferred to fund 413 for Well 11, Sourfe Water Main, Melcher Pump Station, TIP 1.15 Pottery Ave Non -Motorize, TIP 1.16 SR166/Bay Street. A total $144,751 was transferred to fund 414 for debt service payments for the LTGO 2023 City Hall Bond and to pre - fund debt service payments for Well #7. Water Service Payments Storm Drainage operations- Storm Operations budgeted revenue in the amount of $1,875,000 for 2024. Through December, the city has received $2,385,922 or —127% of its annual budgeted revenue. Storm Drainage Operations expended $1,483,594 through December, representing —75% 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 $147,242 for transfers. A total of $85,000 was transferred to fund 423 for future capital preservation work. A total of $28,393 was transferred to fund 424 for debt service payments for the LTGO 2023 City Hall Bond. Storm Drainage Payments Sewer operation — Sewer operations budgeted revenue in the amount of $5,701,000 is budgeted for 2024. Through December, the city has received $7,O97,791or~124%ofthe 2O24budgeted revenues. Sewer Operations expended $5,114,136 through December representing —92% 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, cashflovv needs, and realized expenses for sewer capital projects, stabilization targets, and debt service payments. The 2024budget includes $1,154,72Ofor transfers. Atotal of$l0UOUUwas transferred tofund 43Zfor stabilization. Atotal of$2l2,874was transferred tofund 433for Marina Pump Station, Sewer Lift Controls and TIP 1.16 SR166/@ayStreet. AtVta| of$39,751 was transferred to fund 434for debt service payments for the LTGO20Z3City Hall Bond. � Sewer Service Payments Real Estate Excise Tax (REET) Fund 109 and Impact Mitigation Fee Fund 111 The City's Real Estate Excise Tax receipts fluctuate monthly. December 2024 receipts are Lower than December 2023 by 2%. Total Real estate Excise Tax revenues have a YTD growth rate of-11.56%. The table below shows balances through December 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. 2023-2024 Beginning Balance 691,644 808,518 331,962'. - 3,472,431 516,085 3,666,622 65,507 - 238,162 2023-2024 Revenue Received*'. 46,667 4,282,627 31,929 86,184 4,612,461 2,523,451 2,268,113 2,792 1,123,527 - 2023-2024 Expenses Budgeted (696,000) (2,398,200) - - (2,713,040) (2,216,085) (2,997,400) (95,507) (1,861,900) (234,300) 2023-2024Obligated Expenses (42,311) (2,692,945) (363,891) (86,194) (5,371,852) (823,451) (2,937,335) - (3,862) 2023-2024 Ending Balance - - - - - - 0 (27,209) (738,373) 0 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 December 2024 are as follows: o Parks $88,062 o Transportation $94,840 o School District Impact $24,674 REET revenues received in December: o REET 1 $86,316 o REET 2 $86,316 CAPITAL CONSTRUCTION BUDGET PROGRESS Capital Construction Fund 302: The following General capital projects are in progress: 1) City Hall Remodel a. City Staff Time, Construction i. The 3rd floor work is nearing completion. Siding is nearing completing and work has begun for the Solar Canopy. 2) 730 Prospect Property Acquisition a. City Staff Time, Purchase i. Completed b. Painting i. Completed c. HVAC Improvements i. Pending 3) Public Works Shop EV Fleet Upgrades a. City Staff Time i. Completed 4) South Kitsap Community Events Center including Plaza a. City Staff Time, Design Consulting Services 5) 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) TIP 1.1 Bay St Pedestrian Path ROW a. City Staff Time, Right of Way Consulting Services 2) TIP 1.14 Sidney non -motorized a. City Staff Time, Design Consulting Services 3) TIP 1.15 Pottery Ave Non -Motorized a. City Staff Time, Construction Mgmt. Services, Construction 4) TIP 1.16 SR166/Bay Street Re -Construction a. City Staff Time, Design Consulting Services 5) TIP 1.18 Tremont Phase 2 &3 a. City Staff Time 6) TIP 1.2 Bay St Pedestrian Path Construction a. City Staff Time, Design Consulting Services 7) TIP 1.3 Bay St West Pathway Study a. City Staff Time, Design Consulting Services 8) TIP 1.7 Bethel Phase 5a-Mitchel Roundabout a. City Staff Time, Construction Mgmt. Services, Construction 9) TIP 1.8 & 1.9 Blueberry & Salmonberry a. City Staff Time, Design Consulting Services Water Capital Construction Fund 413: The following Water capital projects are in progress: 1) Water CIP #3-Well 11 Treatment and Pumping Site Improvements a. City Staff Time, Design Services, Construction 2) Water CIP #10-Melcher Pump Station Rehab a. City Staff Time 3) Pottery Ave Non -Motorized (Water) a. City Staff Time, Construction Mgmt. Services, Construction Sewer Capital Construction Fund 433: The following Sewer capital projects are in progress: 1) Sewer CIP #1-Marina SW Pump Station a. City Staff Time, Design Services, Construction 2) Sewer Lift Station Controls Upgrade a. Nothing at this time 3) Bay Street Lift Station Controls a. Nothing atthis time 4) 5VVOP#S8South Sidney Lift Station (Ruby Creek) a. City Staff Time, Design Services 5) Pottery Ave Non -Motorized (Sevver) City Staff Time, Construction Mgmt. Services, Construction Budget Report For Fiscal: 2024 Period Ending: 12/31/2024 OPERATIONS BUDGET Group Summary Variance Original Current Period Fiscal Favorable Percent Departmen... Total Budget Total Budget Activity Activity (Unfavorable) Remaining Fund: 001- Current Expense Revenue 00-Revenues 12,887,000.00 13,121,386.00 1,047,805.93 17,695,243.36 4,573,857.36 34.86% Revenue Total: 12,887,000.00 13,121,386.00 1,047,805.93 17,695,243.36 4,573,857.36 34.86% Expense 01- Finance 1,107,300.00 1,424,300.00 80,165.99 981,751.99 442,548.01 31.07% 02 - Court 797,000.00 797,000.00 38,239.55 497,960.72 299,039.28 37.52% 03 - law Enforcement 6,017,120.00 6,823,080.00 530,685.52 5,830,014.87 993,065.13 14.55% 04 - Community Development 2,395,850.00 2,966,370.00 321,839.57 2,893,555.26 72,814.74 2.45% 05 - Public Works 2,216,887.00 2,639,257.00 175,825.35 2,257,594.26 381,662.74 14.46% 06 - Miscellaneous 0.00 2,411,000.00 407,768.09 2,357,719.55 53,280.45 2.21% 07-Administration 1,888,531.00 1,961,531.00 331,432.04 1,780,079.78 181,451.22 .............__.-..._... 9.25% Expense Total: 14,422,688.00 19,022,538.00 1,885,956.11 16,598,676.43 2,423,861.57 12.74% Fund: 001 - Current Expense Surplus (Deficit)-1,535,688.00 ....._ . -5,901,152.00 -838,150.18 .....__ 1,096,566.93 6,997,718.93 118.58% Fund: 002 - City Street Fund Revenue 00 - Revenues 1,731,004.00 2,130,547.00 280,699.63 3,127,201.38 996,654.38 46.78% Revenue Total: 1,731,004.00 2,130,547.00 280,699.63 3,127,201.38 996,654.38 46.78% Expense 05 - Public Works 2,665,396.00 3,646,666.00 308,652.12 2,707,677.65 938,988.35 25.75% 06 - Miscellaneous 0.00 607,000.00 0.00 0.00 607,000.00 100.00% Expense Total: 2,665,396.00 4,253,666.00 308,652.12 2,707,677.65 1,545,988.35 36.34% Fund: 002 - City Street Fund Surplus (Deficit): -934,392.00 -2,123,119.00 -27,952.49 419,523.73 2,542,642.73 119.76% Fund: 003 - Stabilization Fund Revenue 00 - Revenues 0.00 0.00 12,503.35 163,635.20 163,635.20 0.00% Revenue Total: 0.00 0.00 12,503.35 163,635.20 163,635.20 0.00% Fund: 003 - Stabilization Fund Total: 0.00 0.00 12,503.35 163,635.20 163,635.20 0.00% Fund: 103 - Criminal Justice Revenue 00 - Revenues 384,000.00 384,000.00 35,915.70 491,901.88 107,901.88 28.10% Revenue Total: 384,000.00 384,000.00 35,915.70 491,901.88 107,901.88 28.10% Expense 03 - law Enforcement 495,100.00 771,100.00 8,809.48 667,406.09 103,693.91 13.45% Expense Total: 495,100.00 771,100.00 8,809.48 667,406.09 103,693.91 13.45% Fund: 103 - Criminal Justice Surplus (Deficit): -111,100.00 -387,100.00 27,106.22 -175,504.21 211,595.79 54.66% Fund: 104 - Special Investigative Unit Revenue 00 - Revenues 4,000.00 4,000.00 378.90 4,518.22 518.22 12.96% Revenue Total: 4,000.00 4,000.00 378.90 4,518.22 518.22 12.96% Expense 03 - law Enforcement 4,000.00 4,000.00 27.90 327.90 3,672.10 91.80% Expense Total: 4,000.00 4,000.00 27.90 327.90 3,672.10 91.80% Fund: 104 - Special Investigative Unit Surplus (Deficit) ................_ 0.00 0.00 ..... 351.00 4,190.32 ...._. 4,190.32 ., 0.00% Fund: 107 - Community Events Revenue 00 - Revenues 102,200.00 ......... -_ _.._ 102,200.00 _.._ 15,323.97 201,547.36 99,347.36 97.21% Revenue Total 102,200.00 102,200.00 15,323.97 201,547.36 99,347.36 97.21% Expense 07-Administration 102,200.00 127,200.00 75,675.54 123,042.98 4,157.02 3.27% 2/2 /2025 3A2:21 PM Page 14 o(18 Budget Report For Fiscal: 2024 Period Ending: 12/31/2024 Departmen... Expense Total: Fund: 107 - Community Events Surplus (Deficit): Fund: 108 - Paths & Trails Revenue 00-Revenues 1,000.00 1,000.00 189.09 2,178.45 1,178.45 117.85% Revenue Total: 1,000.00 1,000.00 189.09 2,178.45 1,178.45 117.85% Fund: 108 - Paths & Trails Total: 1,000.00 1,000.00 189.09 2,178.45 1,178.45 117.85% Original Current Total Budget Total Budget 102,200.00 127,200.00 0.00-25,000.00 Variance Period Fiscal Favorable Percent Activity Activity (Unfavorable) Remaining 75,675.54 123,042.98 4,157.02 3.27% -60,351.57 78,504.38 103,504.38 414.02% Fund: 109 - Real Estate Excise Tax Revenue 00-Revenues 800,000.00 1,600,000.00 194,930.73 2,109,983.17 509,983.17 31.87% ................. ...... _..-...-. Revenue Total: 800,000.00 1,600,000.00 194,930.73 2,109,983.17 509,983.17 31.87% Expense 06 - Miscellaneous 298,000.00 1,397,000.00 525,091.74 1,653,546.26 -256,546.26 -18.36% Expense Total: 298,000.00 1,397,000.00 525,091.74 1,653,546.26 -256,546.26 -18.36% Fund: 109 - Real Estate Excise Tax Surplus (Deficit): 502,000.00 203,000.00 -330,161.01 456,436.91 253,436.91 -124.85% Fund: 111- Impact Mitigation Fee Revenue 00-Revenues 5,207,900.00 5,207,900.00 279,158.77 5,123,975.26 -83,924.74 1.61% Revenue Total: 5,207,900.00 5,207,900.00 279,158.77 5,123,975.26 -83,924.74 1.61% Expense 06 - Miscellaneous 1,103,300.00 2,934,250.00 899,234.50 2,033,936.41 900,313.59 30.68% Expense Total: 1,103,300.00 2,934,250.00 899,234.50 2,033,936.41 900,313.59 30.68% Fund: 111- Impact Mitigation Fee Surplus (Deficit): 4,104,600.00 2,273,650.00 -620,075.73 3,090,038.85 816,388.85 -35.91% Fund: 206 - Bond Redemption Fund Revenue 00 - Revenues 298,000.00 1,397,000.00 461,993.53 1,411,408.18 14,408.18 1.03% Revenue Total: 298,000.00 1,397,000.00 461,993.53 1,411,408.18 14,408.18 1.03% Expense 06 - Miscellaneous 298,000.00 995,410.00 459,978.75 994,052.40 1,357.60 0.14% Expense Total: 298,000.00 995,410.00 459,978.75 994,052.40 1,357.60 0.14% Fund: 206 - Bond Redemption Fund Surplus (Deficit): 0.00 401,590.00 2,014.78 417,355.78 15,765.78 -3.93% Fund: 411- Water Operating Revenue 00-Revenues 3,949,000.00 4,134,000.00 371,725.51 4,498,487.62 364,487.62 8.82% Revenue Total: 3,949,000.00 4,134,000.00 371,725.51 4,498,487.62 364,487.62 8.82% Expense 05 - Public Works 3,138,532.00 5,221,312.00 445,989.13 4,586,528.44 634,783.56 12.16% 06 - Miscellaneous 555,800.00 2,146,695.00 346,384.32 1,602,794.50 543,900.50 25.34% Expense Total: 3,694,332.00 7,368,007.00 792,373.45 6,189,322.94 1,178,684.06 16.00% Fund: 411- Water Operating Surplus (Deficit): 254,668.00 -3,234,007.00 -420,647.94 -1,690,835.32 1,543,171.68 47.72% Fund: 412 - Water Stabilization Revenue 00-Revenues 0.00 ........ ....... 100,000.00 104,185.57 154,627.24 _ 54,627.24 _ 54.63% ...........� Revenue Total 0.00 100,000.00 104,185.57 154,627.24 54,627.24 54.63% Fund: 412 - Water Stabilization Total: 0.00 100,000.00 104,185.57 154,627.24 54,627.24 54.63% Fund: 414 - Water Debt Service Revenue 00 - Revenues 939,200.00 2,400,670.00 170,359.68 2,079,016.16-321,653.84 13.40% Revenue Total: 939,200.00 2,400,670.00 170,359.68 2,079,016.16-321,653.84 13.40% Expense 06 - Miscellaneous 939,200.00 1,144,970.00 60,751.25 794,011.43 350,958.57 30.65% 2/2 /2025 3 42:21 PINI Page 15 cif 18 Budget Report For Fiscal: 2024 Period Ending: 12/31/2024 Departmen... Expense Total: Fund: 414 - Water Debt Service Surplus (Deficit): Fund: 421- Storm Drainage Utility Revenue 00 - Revenues 1,745,000.00 1,875,000.00 230,781.73 2,385,922.98 510,922.98 27.25% ................... _._. _... ..__... Revenue Total: 1,745,000.00 1,875,000.00 230,781.73 2,385,922.98 510,922.98 27.25% Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 939,200.00 1,144,970.00 60,751.25 794,011.43 350,958.57 30.65% 0.00 1,255,700.00 109,608.43 1,285,004.73 29,304.73 -2.33% Expense 05 - Public Works 1,819,352.00 1,980,002.00 141,789.86 1,483,594.30 496,407.70 25.07% 06 - Miscellaneous 277,100.00 320,150.00 113,393.75 306,319.19 13,830.81 4.32% Expense Total: 2,096,452.00 2,300,152.00 255,183.61 1,789,913.49 510,238.51 22.18% Fund: 421- Storm Drainage Utility Surplus (Deficit): -351,452.00 -425,152.00 -24,401.88 596,009.49 1,021,161.49 240.19% Fund: 422 - Storm Drainage Stabilization Revenue 00 - Revenues 0.00 0.00 2,344.54 30,684.72 30,684.72 0.00% Revenue Total Fund: 422 - Storm Drainage Stabilization Total Fund: 424 - Storm Drainage Debt Service Revenue 00-Revenues 177,100.00 220,150.00 28,393.75 219,861.48-288.52 0.13% Revenue Total: 177,100.00 220,150.00 28,393.75 219,861.48-288.52 0.13% Expense 06 - Miscellaneous Expense Total: Fund: 424 - Storm Drainage Debt Service Surplus (Deficit): Fund: 431- Sewer Operating Revenue 00-Revenues 5,701,000.00 5,701,000.00 680,108.91 7,097,791.92 1,396,791.92 24.50% Revenue Total: 5,701,000.00 5,701,000.00 680,108.91 7,097,791.92 1,396,791.92 24.50% _._...... ,.............. ..... ........ 0.00 0.00 2,344.54 30,684.72 30,684.72 0.00% 0.00 0.00 2,344.54 30,684.72 30,684.72 0.00% 177,100.00 220,150.00 28,393.75 219,861.48 288.52 0.13% 177,100.00 220,150.00 28,393.75 219,861.48 288.52 0.13% 0.00 0.00 0.00 0.00 0.00 0.00% Expense 05 - Public Works 4,889,732.00 5,597,612.00 430,561.98 5,114,136.70 483,475.30 8.64% 06 - Miscellaneous ..... 709,900.00 1,154,720.00 352,626.23 1,005,738.36 148,981.64 .. 12.90% _ Expense Total 5,599,632.00 6,752,332.00 783,188.21 6,119,875.06 632,456.94 9.37% Fund: 431- Sewer Operating Surplus (Deficit): 101,368.00 -1,051,332.00 -103,079.30 977,916.86 2,029,248.86 193.02% Fund: 432 - Sewer Stabilization Revenue 00 - Revenues .................................. 0.00 100,000.00 106,257.62 181,745.81 81,745.81 81.75% Revenue Total 0.00 100,000.00 106,257.62 181,745.81 81,745.81 81.75% Fund: 432 - Sewer Stabilization Total: 0.00 100,000.00 106,257.62 181,745.81 81,745.81 81.75% Fund: 434 - Sewer Debt Service Revenue 00-Revenues 678,900.00 1,067,720.00 45,697.13 747,165.15-320,554.85 30.02% Revenue Total: 678,900.00 1,067,720.00 45,697.13 747,165.15-320,554.85 30.02% Expense 06 - Miscellaneous 403,900.00 465,970.00 39,751.25 83,484.84 382,485.16 82.08% Expense Total: 403,900.00 465,970.00 39,751.25 83,484.84 382,485.16 82.08% Fund: 434 - Sewer Debt Service Surplus (Deficit): 275,000.00 601,750.00 5,945.88 663,680.31 61,930.31 -10.29% Fund: 500 - Equipment Rental and Revolving Revenue 00-Revenues ................. 1,309,800.00 4,172,200.00 105,321.00 4,143,480.59 -28,719.41 0.69% Revenue Total: 1,309,800.00 4,172,200.00 105,321.00 4,143,480.59 -28,719.41 0.69% Expense 10-ER&R 801,600.00 3,837,400.00 243,172.00 2,490,956.69 1,346,443.31 35.09% 2/2 /2025 3:4 2:21 PINI Page 16 of 18 Budget Report For Fiscal: 2024 Period Ending: 12/31/2024 Variance Original Current Period Fiscal Favorable Percent Departmen... Total Budget Total Budget Activity Activity (Unfavorable) Remaining Expense Total: 801,600.00 3,837,400.00 243,172.00 2,490,956.69 1,346,443.31 35.09% Fund: 500 - Equipment Rental and Revolving Surplus (Deficit): 508,200.00 334,800.00 -137,851.00 1,652,523.90 1,317,723.90-393.59% Report Surplus (Deficit). 2,814,204.00 -7,875,372.00 -2,192,164.62 9,404,284.08 17,279,656.08 219.41% 2/2 /2025 3A2:21 PM Pago 17 of 1.8 Budget Report CAPITAL BUDGET For Fiscal: 2024 Period Ending: 12/31/2024 Group Summary Variance Original Current Period Fiscal Favorable Percent Account Typ... Total Budget Total Budget Activity Activity (Unfavorable) Remaining Fund: 302 - Capital Construction Revenue 370,000.00 2,780,000.00 125,612.40 2,504,607.53 -275,392.47 9.91% Expense 370,000.00 11,925,700.00 1,114,478.12 8,831,710.53 3,093,989.47 25.94% Fund: 302 - Capital Construction Surplus (Deficit): 0.00 -9,145,700.00 -988,865.72 -6,327,103.00 2,818,597.00 30.82% Fund: 304 - Street Capital Projects Revenue 220,000.00 4,143,950.00 1,650,192.94 3,004,826.28 -1,139,123.72 27.49% Expense 290,000.00 14,149,095.00 1,532,243.78 4,205,633.53 9,943,461.47 70.28% Fund: 304 - Street Capital Projects Surplus (Deficit): -70,000.00 -10,005,145.00 117,949.16 -1,200,807.25 8,804,337.75 88.00% Fund: 413 - Water Capital Revenue 2,232,700.00 2,763,950.00 168,978.92 5,974,185.07 3,210,235.07 116.15% Expense 883,400.00 10,635,295.00 517,553.33 _... 5,795,589.08 4,839,705.92 .......... 45.51% ......... Fund: 413 - Water Capital Surplus (Deficit): 1,349,300.00 -7,871,345.00 -348,574.41 178,595.99 8,049,940.99 102.27% Fund: 423 - Storm Drainage Capital Facil Revenue 100,000.00 150,000.00 147,451.84 784,887.29 634,887.29 423.26% Expense 100,000.00 150,000.00 6,057.50 44,361.21 105,638.79 70.43% Fund: 423 - Storm Drainage Capital Facil Surplus (Deficit): 0.00 0.00 141,394.34 740,526.08 740,526.08 0.00% Fund: 433 - Sewer Capital Revenue 3,491,500.00 5,241,500.00 3,367,356.87 14,579,457.34 9,337,957.34 178.15% Expense 369,000.00 15,374,600.00 2,291,471.89 11,821,184.69 3,553,415.31 23.11% . Fund: 433 - Sewer Capital Surplus (Deficit): 3,122,500.00 -10,133,100.00 1,075,884.98 2,758,272.65 12,891 372.65127.22% Report Surplus (Deficit). 4,401,800.00 37,155,290.00 2,211.65 -3,850,515.53 33,304,774.47 89.64% 2/2 /2025 3:33.59 AM Pale 3 of 4 Detail Report CASH & INVESTMENT Date Range: 12/01/2024- 12/31/2024 Fund Summary Fund Beginning Balance Total Activity Ending Balance 001- Current Expense 19,274,303.00 -838,150.18 18,436,152.82 002 - City Street Fund 4,476,315.38 -27,952.49 4,448,362.89 003 - Stabilization Fund 3,222,881.69 12,503.35 3,235,385.04 103 - Criminal Justice 549,720.14 27,106.22 576,826.36 104 - Special Investigative Unit 104,744.86 351.00 105,095.86 107 - Community Events 532,735.28 -60,351.57 472,383.71 108 - Paths & Trails 17,800.29 189.09 17,989.38 109 - Real Estate Excise Tax 6,853,688.02 -330,161.01 6,523,527.01 111- Impact Mitigation Fee 11,834,801.79 -620,075.73 11,214,726.06 206 - Bond Redemption Fund 515,355.85 2,014.78 517,370.63 302 - Capital Construction 2,556,842.10 -988,865.72 1,567,976.38 304 - Street Capital Projects 834,162.83 117,949.16 952,111.99 401- Water -Sewer Utilities 0.00 0.00 0.00 403 - Water -Sewer Cumulative Reserve 0.00 0.00 0.00 411- Water Operating 3,174,810.41 -420,647.94 2,754,162.47 412 - Water Stabilization 1,067,390.38 104,185.57 1,171,575.95 413 - Water Capital 8,785,397.67 -348,574.41 8,436,823.26 414 - Water Debt Service 1,175,396.30 109,608.43 1,285,004.73 421- Storm Drainage Utility 2,404,562.45 -24,401.88 2,380,160.57 422 - Storm Drainage Stabilization 599,703.46 2,344.54 602,048.00 423 - Storm Drainage Capital Facil 800,997.76 141,394.34 942,392.10 424 - Storm Drainage Debt Service 0.00 0.00 0.00 431- Sewer Operating 8,857,461.89 -103,079.30 8,754,382.59 432 - Sewer Stabilization 1,597,397.18 106,257.62 1,703,654.80 433 - Sewer Capital 9,118,784.11 1,075,884.98 10,194,669.09 434 - Sewer Debt Service 1,520,882.71 5,945.88 1,526,828.59 500 - Equipment Rental and Revolving 5,574,562.53 -137,851.00 5,436,711.53 631- Trust and Agency 6,803.20 -6,615.20 188.00 632 - Wastewater Treatment Facil Fee 7,872,320.03 56,310.99 7,928,631.02 Grand Total: 103,329,821.31 -2,144,680.48 101,185,140.83 2/2 /2025 3 A 2: 54 PM Page 5 cif 5