OF HOPEL CITY OF HOPEWELL Hopewell, Virginia 23860 AGENDA (804),541-2408 www.hopewellvagoy info@hopewellvagoy lyelerk@hopewelvagor FINANCE. MEETING CITY COUNCIL John B.Partin, Jr., Mayor, Ward #3 Rita. Joyner, Vicel Mayor, Ward #1 Michael B. Harris, Councilor, Ward #2 Ronnie Ellis, Councilor Ward! #4 Susan Daye, Councilor, Ward# #5 Yolanda Stokes, Councilor, Ward# #6 Dominic R.I Holloway, Sr.,Councilor, Ward#7 Dr. Concetta Manker, City Manager Anthony Bessette, InterimCity, Attorney Brittani Williams, City Clerk Sade' Allen] Deputy City Clerk Open Session 6:301 PM EALYH of February 18, 2025 Call to order, roll call, and welcome to visitors SPECIAL MEETING Special Business SB-1 - Finance Committee Report- CFO - Stacy Jordan, Finance Director SB-2 Treasurer's Report = Mya Bolling, Treasurer Department Adjournment Finance Committee Meeting CITY MANAGER: DR. CONCETTA MANKER PRESENTED BY: STACEYJORDAN, CFO GINVOFHOPEWELFNANCE COMMITTEE AGENDA "Minutes from last meeting "FY25 Budget to Actuals-January Citywide General Fund Enterprise Schools Departmental "January Collection report - Data Integrators "Accounts Payable/Debt Service "Mid-Year Budget Review Savings Allocations "Reports from COR and Treasurer "January committee items CITYOF HOPEWELL FINANCE COMMITTEE Citywide FY25 Budget to Actuals - January FY25 Citywide Revenues and Expenditures- Budget VS Actuals 250,000,000 200,000,000 150,000,000 100,000,000 50,000,000 City-wide revenues for. January are trending 1.13% or $2.5M higher ini for FY25 VS FY24. Expenses are trending .28% higher or $2.3M for FY25 VS FY24. FY24REVISED FY24.Actuals FY25REVISED FY25Actuals FY25 FY25YTD BUDGET BUDGET Revenue Expenditures Adjustments Actuals Projected CITYOF HOPEWELL FINANCE COMMITTEE 3 Citywide FY25 Budget to Actuals - January REVENUES FY24 REVISED FY24A Actuals FY24 %of FY25 REVISED FY25 Actuals FY25 FY25YTD Actuals FY25 %F Rec'd BUDGET Budget Rec'd BUDGET Adjustments Projected Projected 9,821,291 44.8% 3.659.476 38.294 1,294,424 80.0% 5,798,761 53.5% 484,148 91.3% 324,342 55.3% 299,059 63.6% 631,369 45.394 371,901 80.0% 34,825,529 56.2% 6,849,982 43.2% 1,381,672 19.994 17,522,793 51.7% Adjustments Projected Projected 16,005,973 52.6% 2,806,363 52.8% 172,431 36.2% 2,232,055 51.7% 1,331,275 53.7% 8,318,956 47.8% 288,209 56.1% 16,661,500 41.6% 3,276,313 57.1% 943,125 74.6% 1,848,844 11.4% 10,360,450 74.7% 6,405,593 33.7% Comments Consistent Consistent Consistent Consistent Decrease duet tol Interest income JanE Billing As.prolected with 20% budget increase AS projected with 65% budget increase Decrease dueto decline In fines and collections Increase dueto SW Grant recelved Schools &S Social Services Decreaseduet toA ARPAInFY24 Increase dueto $452.5k HWR Misc. Credits Jan Blling JanB Bllling Consistent REAL ESTATE TAXES PUBLICS SERVICE CORP TAX PERSONAL PROPERTY TAX TOOL MACH&1 TAX DTHER TAXES USE OFMONEY &PROPERTY PHARGES FOR SERVICES PENALTIESEI INTEREST ENESAFORFETTURES GRANTS STATE REVENUES FEDERAL REVENUES MISCELLANEOUS REVENUE ENLIEVOF TAXES DEBT SERVICE TRANSFERS IN TOTAL REVENUES EXPENDITURES FY24REVISED FY24A SALARIES& WAGES HEALTHE BENEFITS EMPLOYEE BENEFITS RETIREMENT OTHERE PERSONNEL PROFESSIONAL SERVICES WORKERS COMPENSATION SERVICESSUPPLIES DUTSIDE AGENCIES NON-DEPARTMENTAL DTHER CAPITAL PEBT SUPPORT OFS SCHOOLS TRANSFERS OUT NETI INÇOME 20,979,167 9,622,328 45.9% 21,928,970 9,821,291 4,100,000 2,237,536 54.6% 5,100,000 687,109 5,636,800 3,342,103 59.3% 7,056,000 2,613,684 8.783.500 3.261.413 37.1% 9.586.049 3.659.476 10,110,000 5,482,210 54.2% 10,840,000 5,798,761 340,000 661,519 194.6% 530,200 484,148 488,500 550,032 112.694 586,000 324,342 860,500 727,165 84.594 1,392,545 631,369 221,516 320,323 144.6% 464,964 371,901 54,730,232 28,800,206 52.696 61,969,103 34.825,529 20,820,289 12,784,260 61.494 15,840,835 6,849,982 17,200,210 520,361 3.0% 6,938,700 1,381,672 29,933,944 15,523,009 51.9% 33,876,815 17,522,793 29,226,946 15,083,314 51.6% 30,406,469 16,005,973 4,961,744 2,591,059 52.2% 5,316,869 2,806,363 384,755 141,849 36.9%4 476,259 172,431 4,179,372 2,083,604 49.9% 4,321,239 2,232,055 2,383,137 1,271,766 53.4% 2,480,970 1331,275 16,765,897 8,040,289 48.094 17417,567 8,318,956 509,172 298,600 58.6% 513,869 288,209 38,348,275 18,782,372 49.0% 40,004,110 16,661,500 5,837,549 2,979,558 51.0% 5,735,103 3,276,313 1,263,888 943,957 74.7% 1,265,074 943,125 21,448,007 3,518,057 16.4% 16,186,205 1,848,844 13,580,000 10,185,000 75.094 13,865,900 10,360,450 15,344,944 4,581,259 29.9% 19,001,915 6,405,593 687,109 13.5% Feb1 15 deadline was extended to March 7, decrease duet to collections from vendor delay In sending out bills 2,613,684 37.0%4 Feb1 15 deadline was extended to March 7 decrease duet to collections from vendor delay In sending out blls PPTRA STATE REIMBURSEMENT 1,618,030 1,294,424 80.0% 1,618,030 1,294,424 PERMITS FEES ANDUICENSES 285,600 328,217 114.9% 470,450 299,059 40,064,435 18,413,488 46.0% 48,653,969 17,375,921 2,500,000 19,875,921 40.9%6 1,591,511 1,137,965 71.5% 1,591,511 1,110,131 27,834 1,137,965 71.5% 1,120,526 653,640 58.3% 947,617 473,824 78,968 552,792 58.3% 218,884,760 105,660,198 48.27% 229,391,758 105,525,415 2,606,802 108,132,217 47.14% FY24%of FY25 REVISED FY25 Actuals FY25 FY25YTD Actuals FY25 %F Rec'd BUDGET Budget Rec'd BUDGET 2.5%A Annual Salary Increase 69,266,545 40,354,494 58.3% 72,396,569 35,821,093 6,500,000 42,321,093.31 58.5% 7,428,083 5,242,089 70.6% 7,418,450 4,902,241 507,000 5,409,241 72.9% (12,043.554) (10,437,069) -2.00% (7,414,810) (5,849,007) (4,400,198) (10,249,205) -2.85% Est:$6.5Mfor Schools unrecorded Opex HWR2 2H25 Planned spending Recurring/Automatic payment thatr requires AP( (D. Gerard) tor record entriesi in Munis TOTAL EXPENDITURES 230,928,314 116,097,267 50.27% 236,806,568 111,374,422 7,007,000 118,381,422 49.99% CITY OFHOPEWELL FINANCE COMMITTEE General Fund FY25 Budget to Actuals S-January FY25 General Fund Revenue and Expenditures 80,000,000 70,000,000 60,000,000 50,000,000 40,000,000 30,000,000 20,000,000 10,000,000 General fund for. January is trending or 6% or $1.3M lower in Revenues for FY25 VS FY24- - Decrease from PSCand PP Expenses for FY25 are trending 1.5% or $3.8M higher than FY24 The next key due date is June. FY24 REVISED FY24 Actuals FY25REVISED FY25 Actuals FY25YTDActual BUDGET BUDGET =Revenue Expenditures Projected CITY OF HOPEWELLFINANCE COMMITTEE General Fund FY25 Budget to Actuals -J January FY24%of Budget FY25REVISED FY24REVISED FY25YTDA Actualspr25%Recd REVENUES REALE ESTATETAXES PUBLICS SERVICE CORPT TAX PERSONAL PROPERTYTAX MACH& TOOL TAX OTHERT TAXES USEOFN MONEY&F PROPERTY CHARGESF FORS SERVICES PENALTIES&I INTEREST PERMITS, FEESA ANDLICENSES FINES&F FORFEITURES GRANTS STATE REVENUES FEDERAL REVENUES MISCELLANEOUS REVENUE NLEVOFTAXES TRANSFERSI IN TOTAL REVENUES EXPENDITURES SALARIES&V WAGES HEALTHBENEFITS EMPLOYEE BENEFITS RETIREMENT OTHER PERSONNEL PROFESSIONALS SERVICES WORKERS COMPENSATION SERVICE&S SUPPLIES DUTSIDE AGENCIES NON-DEPARTMENTAL OTHER CAPITAL SUPPORT OFS SCHOOLS TRANSFERS OUT TOTAL EXPENDITURES NET INCOME BUDGET FY24Actuals Rec'd BUDGET FY25Actuals Projected Projected 20,979,167 9,394,409 44.8% 21,928,970 9,717,348 9,717,348 44.394 8,783,500 3,319,906 37.8% 9,586,049 3,659,107 3,659,107 38.294 6,560,000 2,834,603 43.294 7,240,000 2,681,795 2,681,795 37.094 65,000 49,469 76.1% 90,000 58,676 58,676 65.294 677,500 581,661 85.9% 847,000 792,313 792,313 93.5%4 487,500 468,548 96.1% 581,000 294,340 294,340 50.794 285,600 281,504 98.694 470,450 250,063 250,063 53.294 860,500 633,637 73.6% 1,280,469 454,420 454,420 35.594 8,194,190 4,399,423 53.7% 9,183,676 4,936,990 4,936,990 53.894 1,251,000 1,994,329 159.4% 350,000 43,958 43,958 12.6% 749,747 306,979 40.9% 753,892 673,534 673,534 89.3% 1,257,500 628,750 50.0%4 1,257,500 628,750 628,750 50.094 1,009,000 504,500 50.094 1,009,000 504,500 504,500 50.0% 62,515,430 29,715,231 47.53% 68,352,036 28,387,053 28,387,053 41.53%4 BUDGET FY24Actuals Used BUDGET FY25Actuals Projected Projected 20,258,699 8,926,094 44.1% 20,687,625 9,513,921 9,513,921 46.094 3,554,597 1,601,282 45.09 3,755,212 1,749,679 1,749,679 46.694 252,058 91,287 36.294 305,474 115,342 115,342 37.894 2,885,871 1,212,231 42.0%4 2,940,040 1,300,339 1,300,339 44.294 1,628,553 762,339 46.894 1,681,129 787,915 787,915 46.994 3,525,447 2,814,568 79.894 4,997,481 2,939,492 2,939,492 58.8%4 429,097 224,077 52.2% 430,823 211,245 211,245 49.0%4 4,898,155 2,413,012 49.3%4 5,710,469 3,565,067 3,565,067 62.4% 5,044,889 2,439,765 48.494 4,926,032 2,765,584 2,765,584 56.194 82,123 51,749 63.0%4 427,072 164,284 164,284 38.594 249,711 199,165 79.894 215,406 128,888 128,888 59.894 13,580,000 6,790,000 50.0%4 13,710,000 6,932,950 6,932,950 50.694 6,108,345 3,054,173 50.0%4 8,540,791 4,270,396 4,270,396 50.094 62,515,435 30,580,574 48.9% 68,352,045 34,445,101 34,445,101 50.494 (5) (865,343) -1.3894 (9) (6,058,048) (6,058,048) -8.8694 COMMENTS 4,100,000 610,141 14.994 5,100,000 9,854 9,854 0.294 $750K Decrease duet to collections from Vendor delayi in: sending out! bills 5,636,800 2,410,552 42.8% 7,056,000 2,386,981 2,386,981 33.894 $650KD Decrease duet tocollections from Vendor delayi ins sending outb bills Reclassified: $3.4Mp posted inJ July FY24, bute earnedi in June FY23 Consistent with FY24Collections Consistent with FY24Collections Decrease from FY24 FY25B Budget Increase duet topast due collections FY25Budget Increase duet to past due collections Decrease duet to ARPAinFY25 PPTRASTATE REIMBURSEMENT 1,618,030 1,294,424 80.0% 1,618,030 1,294,424 1,294,424 80.094 396 2,396 605.0%4 FY23REVISED FY23% FY24REVISED FY25YTDA Actuals/FY25% Rec'd 2.5%A Annual Salary Increase Decreasei inA Audit Fees 17,890 832 4.7% 24,491 0.094 Increasei int transfer to otherf funds CITY OF HOPEWELLFIANCE COMMITTEE Enterprise Fund FY25 Budget to Actuals -J January Regional Water, Sewer, Solid Waste, and Storm Water Enterprise fund for. January is trending 2.7% or $2.3M higher in Revenues for FY25 VS FY24. Expense for FY25 are trending 12% or $2.1M less the Revenues show reflection of on-time billing VS last year and expenses decreases of 60% stems from the reduction 30,000,000 of emergency repairs compared to last year. 60,000,000 FY25 Enterprise Funds Revenue and Expenditures 50,000,000 40,000,000 expense in FY24. 20,000,000 10,000,000 FY24REVISED FY24Actuals FY25REVISED FY25 Actuals FY25YTDA Actuals BUDGET BUDGET Revenue mExpenditures Projected GIVOFHOPAWELLFINANCE COMMITTEE Enterprise Fund FY25 Budget to Actual -January FY24REVISED BUDGET 235,000 33,182,403 15,000 334,011 1,120,526 9,236,599 44,123,539 FY24REVISED 4,491,662 640,213 75,920 624,982 354,748 8,962,314 50,674 11,332,597 6,000 1,257,500 61,400 4,440,284 2,588,642 9,236,599 44,123,535 FY25YTD Actuals- 286,938 286,938 15,875,975 18,375,975 510,493 510,493 254,771 254,771 167,006 194,840 473,824 552,792 17,569,006 20,175,809 FY25YTDA Actuals 2,425,640 2,425,640 358,636 358,636 17,291 17,291 338,867 338,867 200,410 200,410 4,871,539 4,871,539 31,400 31,400 7,600,230 7,600,230 1,498 1,498 943,125 943,125 21,535 21,535 1,320,521 1,320,521 1,509,825 1,509,825 19,640,519 19,640,519 (2,071,513) 535,290 REVENUES USEC OFN MONEY&F PROPERTY CHARGES FORS SERVICES MISCEILANEQUSRVENUE GRANTS NLIEU OFT TAXES DEBTS SERVICE TRANSFERSIN TOTAL REVENUES EXPENDITURES SALARIES & WAGES HEALTHBENEFITS EMPLOYEE BENEFITS RETIREMENT OTHER PERSONNEL PROFESSIONAL SERVICES WORKERS COMPENSATION SERVICE&S SUPPLIES OUTSIDEA AGENCIES NON-DEPARTIMENTAL OTHER CAPITAL DEBT TRANSFERSOUT TOTALI EXPENDITURES NETI INCOME FY24Actuals FY24%Rec'd 25REVISEDBUDGET FY25Actuals Projected FY25%Rec'd Comments 95.694 43.494 $2.50MD Dec Billing 3795.594 $452.5kH HWRI Misc. Credits 58.394 $27.8KD DecB Billing 58.394 $78.9KDec Billing 0.094 38.33%4 51.3% 50.394 22.994 52.794 55.094 48.894 58.594 60.094 Decreasei inc emergency repairs 30.094 75.094 35.194 13.394 58.494 0.094 37.3% 1.02%4 436,775 16,295,708 7,435 254,771 194,840 653,640 17,843,168 2,221,552 316,342 24,929 289,403 186,065 4,348,492 28,877 10,420,616 4,925 943,125 17,275 1,447,905 1,512,656 21,762,161 (3,918,993) 185.9%4 300,000 49.194 42,367,151 49.694 13,450 58.3% 334,011 58.394 947,617 0.094 8,672,924 40.44%4 52,635,153 49.594 4,731,824 49.4%4 713,300 32.8%4 75,431 46.394 642,777 52.494 364,449 48.594 9,987,532 57.0%4 53,697 92.0%4 12,667,511 82.194 5,000 75.0%4 1,257,500 28.194 61,400 32.6% 9,913,822 58.4% 2,583,988 0.0% 9,576,924 49.3% 52,635,155 -8.8894 (2) BUDGET FY24Actuals FY24%Rec'd P25REVSEDBUDGET FY25Actuals Projected FY25%Rec'd 2H25F Planned spending CITY OF HOPEWELLFINANCE COMMITTEE Schools FY25 Budget to Actual -January FY25 Schools Revenue and Expenditures 80,000,000 70,000,000 60,000,000 50,000,000 40,000,000 30,000,000 20,000,000 10,000,000 Schools for. January is trending .72% or $1.2M higher in revenues for FY25 vs FY24 Expenses are trending .11% or $1.7M higher in FY25 Vs FY24 FY24REVISED! BUDGET FY24A Actuals FY25 REVISEDBUDGET FY25 Actuals FY25YTDA Actual Projected Revenue mExpenditures CITYVOFHOPEWELLF FINANCE COMMITTEE Schools FY25 Budget to Actuals -January FV25 YTD Actuals FY24REVISED FY24% FY25 REVISED REVENUES CHARGES FOR SERVICES STATE REVENUES FEDERAL REVENUES TRANSFERS IN TOTAL REVENUES EXPENDITURES SERVICE & SUPPLIES OTHER CAPITAL TOTAL EXPENDITURES NET INCOME BUDGET FY24 Actuals Rec'd BUDGET FY25 Actuals Projected FY25%Rec'd 5,023,384 1,271,280 25.3% 5,515,232 520,025 520,025 39,351,282 22,078,805 56.1% 46,085,993 24,568,182 24,568,182 53.3% 13,980,744 7,471,538 53.4% 9,643,588 6,740,496 6,740,496 13,580,000 10,185,000 75.0% 13,710,000 10,360,450 10,360,450 75.6% 71,935,410 41,006,623 57.00% 74,954,813 42,189,154 42,189,154 56.29% BUDGET FY24 Actuals Rec'd BUDGET FY25 Actuals Projected FY25% Rec'd COMMENTS 9.4% 69.9% FY25YTD Actuals FY24 REVISED 3,072,226 47,180 FY24% FY25 REVISED 0.0% 3,716,420 0.0% 47,180 0.0% 0.0% 68,816,004 40,236,346 58.5% 71,191,213 42,004,062 42,004,062 59.0% Est $6.5M for Schools unrecorded Opex 71,935,410 40,236,346 55.9% 74,954,813 42,004,062 42,004,062 56.04% 770,277 1.07% 185,092 185,092 0.25% CITYOF HOPEWELLFINANCE COMMITTEE 10 FY25 Department Budget to Actual -January DEPARTMENT ACCOUNTING ASSESSOR CIRCUIT COURT CITYA ATTORNEY CITYCLERK CITY MANAGER COMMISSION OFF REVENUE COMMONWEALTH, ATTORNEY COUNCIL COURT SERVICES CSA ECONOMIC DEVELOPMENT FIRE/EMS GENERAL COURT GOVERNMENT AFFAIRS HEALTHY FAMILIES HRW HUMAN RESOURCES INFORMATION1 TECHNOLOGY LAW! LIBRARY MARINA PLANNING POLICE PUBLIC WORKS RECREATION REFUSE SEWER SHERIFF SOCIAL SERVICES STORMWATER TREASURER MICTIM WITNESS MJCCCA VOTER REGISTRAR TOTALS FY25A ADOPTED YTDB BUDGET BUDGET 2,089,595 S 985,933 S 503,455 S 191,820 $ 419,409 $ 752,163 $ 336,139 $ 605,239 $ 413,930 s 151,821 $ 342,564 S 179,066 $ 85,456 $ 140,731 $ 1,110,931 $ 861,521 $ 628,956 $ 732,599 S 311,198 $ 594,664 $ 1,065,315 $ 521,615 $ 825,042 s 254,861 S 66,990 S 226,430 S 7,000 $ 1,351 $ 6,446 S 3,888,429 $ 1,530,932 $ 1,556,884 S 823,765 S 534,597 S 640,376 $ 6,701,199 $ 3,072,199 $ 5,803,810 $ 147,472 $ 52,791 S 126,438 S 152,746 S 52,545 $ 131,094 $ 1,000,185 $ 479,109 S 359,415 $ 29,482,650 $ 10,227,936 $ 16,020,669 $ 765,866 S 329,001 S 556,571 $ 1,916,236 $ 983,628 $ 1,228,720 S 11,550 $ 4,792 $ 9,655 $ 100,200 $ 83,699 $ 11,559 $ 1,437,546 s 737,791 $ 1,089,739 $ 10,713,977 $ 5,201,960 $ 8,131,550 $ 11,320,960 S 3,908,879 $ 9,291,710 S 2,341,650 $ 939,507 $ 1,867,166 S 3,688,654 $ 1,733,082 S 695,652 $ 7,336,553 $ 4,802,374 $ 5,074,592 $ 2,262,891 $ 997,994 S 1,779,835 $ 7,195,330 S 3,248,713 $ 5,670,504 $ 914,000 $ 357,868 $ 1,159,184 $ 725,642 $ 302,167 S 591,156 S 165,057 S 82,935 $ 139,826 $ 177,663 S 74,793 S 154,216 $ 423,466 $ 227,377 $ 297,083 IS 100,802,604 $ 43,480,512 $ 68,019,096 BUDGET %0F BUDGET YTD ON1 TREND COMMENTS AMOUNT- REMAINING 1,842,209 47% TRUE 38% TRUE 45% TRUE 37% TRUE 48% TRUE 78% FALSE 42% TRUE 49% TRUE 26% TRUE 19% TRUE 39% TRUE 65% FALSE 46% TRUE 36% TRUE 34% TRUE 48% TRUE 35% TRUE 43% TRUE 51% TRUE 41% TRUE 84% FALSE 51% TRUE 49% TRUE 35% TRUE 40% TRUE 47% TRUE 65% FALSE 44% TRUE 45% TRUE 39% TRUE 42% TRUE 50% TRUE 42% TRUE 54% TRUE 43% TRUE RBG Consultants Enterprise zone payment will balance out EOY Repairs & Utilities Repairs CITYOF HOPEWELL! FINANCE COMMITTEE 11 FY25 Data Integrators Collections -January Utility Water/Sewer Collection Rate November Billed 65,032.84 $ 268,183.56 237,880.89 $ 571,097.29 Utility Water/Sewer Collection Rate December Billed $ 62,004.33 $ 265,140.80 $ 212,605.52 $ 539,750.65 Utility Water/Sewer Collection Rate January Billed $ 62,476.42 $ 264,803.19 $ 248,319.72 $ 575,599.33 Account Designation Storm Water Solid Waste Waste Water Total YTD Account Designation Storm Water Solid Waste Waste Water Total MTD Account Designation Storm Water Solid Waste Waste Water Total YTD Collected $ 56,726.80 $ 236,457.05 $ 207,381.75 $ 500,565.60 Collected 58,899.39 $ 250,210.83 $ 198,989.14 $ 508,099.36 Collected $ 62,538.19 $ 262,758.01 $ 242,279.87 $ 567,576.07 Percentage 87% 88% 87% 88% Percentage 95% 94% 94% 94% Percentage 100% 99% 98% 99% : Percentages in excess of1 100 are due to Accounts billed in previous months but paid in current month*. CITY OF HOPEWELLFINANCE COMMITTEE 12 FY25 Accounts Payable/Debt Service -January Accounts Payable. January Invoices Received #ofi invoices received Samount processed 1269 4,198,773] $ Debt Service Payments January Vendor USB BANK-USB1824 Total Amount $215,269 $530,479 CITYOF HOPEWELLI FINANCE COMMITTEE 13 Mid-Year Savings Allocations The following highlights the mid-year salary savings review and requested allocation of savings to various expenses that require funding. General Fund: $203K Forensic Audit Sands Anderson VRSA (Colonial Corner) Attorney Fees - various in process issues to include grievances Enterprise Fund: $339K Rate Study HRW Davenport Raftelis 4th Amendment Hunton, Andrews, Kurth GINOFMOPEMELFNANCE COMMITTEE 14 February Items 1. FY21 ACFR Update CIVYOFHOPEWELFNANCE COMMITTEE 15 TREASURER REPORT HOPEH City of Hopewell Weekly Cash Flow Report Master Cash Account FY2025 Week beginning 1/6/2025 1/13/2025 Week2 29 1/20/2025 Week3 30 1/27/2025 Week3 31 Week2 28 Beginning Cash Balance State Aid Federal Aid Grants AIIC Other Datal Integrators $15,694,654.17 $12,552,719.74 $12,811,725.88 $11,651,953.04 Cashl Inflows-Credit $ $ $ $2,129,756.16 $ 124,781.51 $ 2,641,142.16 682,843.88 $ $ $ 617.13 $ 879.35 $ 9,445.44 412.73 $ 524,974.06 $ 1,531,546.32 $ 531,704.84 $ 2,355,857.93 525,591.19 $ 4,345,025.71 $ 656,658.49 $ 5,006,858.26 172.14 $ Total Cash Inflows Cash Outflows-Debit City Accounts Payable Schools Accounts Payable City Payroll Schools Payroll Debt Service Economic Development Rebates $ Datal Integrators AII Other Fees 1,603,515.26 $ 1,337,495.53 $ 578,693.97 $ 609,725.40 1,408,456.84 $ 63,496.62 $ 1,038,983.45 $ 55,178.93 644,225.44 $ 2,041,145.38 $ 1,476.49 $ 1,240,266.86 $ 639,870.03 $ 195,509.47 $ 359,501.69 $ $ $ $ $ $ $ 11,328.08 $ 4,012.01 $ 1,767.95 $ 1,289.20 3,667,525.62 $ 4,086,019.57 $ 1,816,431.33 $ 2,265,962.08 $(3,141,934.43) $ 259,006.14 $ (1,159,772.84) $ 2,740,896.18 $12,552,719.74 $12,811,725.88 $11,651,953.04 $14,392,849.22 Total Cash Outflows Net Cash Flows FY25 Weekly Cash Flow Report Prepared by! N.HART01.03.2025 10F1 City of Hopewell Real Estate Collection Report Personal Property Collection Report Bill Year 2022-2025 HOPE EALTH of 2022 Charge Year Row Labels MT-1ST MT-2ND PP PUBLICSERVICE RE RE-1ST RE-2ND GrandTotal Charge Year Rowl Labels MT-1ST MT-2ND PP PUBLICSERVICE RE RE-1ST RE-2ND GrandTotal Charge Year Row Labels MT-1ST MT-2ND PP PUBLICSERVICE RE RE-1ST RE-2ND Grand" Total PERIOD ENDING: Jan-25 99.99% 99.99% 87.94% 100.00% 53.22% 99.31% 98.97% 97.15% Jan-25 99.99% 99.99% 76.61% 100.00% 98.47% 99.80% 97.85% 95.95% Jan-25 99.98% 99.32% 14.83% 13.14% 50.98% 98.94% 95.65% 76.76% Sum of ADJE BILLED SumofNETPMI/CREDIT Sum of END RECEIVABLE Percent Collected $4,612,874.13 $4,610,576.55 $6,766,290.17 $4,147,824.23 $175,969.78 $8,043,912.75 $8,016,728.54 $36,374,176.15 $4,612,643.18 $4,610,318.69 $5,950,471.14 $4,147,824.23 $93,642.95 $7,988,565.90 $7,933,821.27 $35,337,287.36 $230.95 $257.86 $815,819.03 $0.00 $82,326.83 $55,346.85 $82,907.27 $1,036,888.79 2023 PERIOD ENDING: Sum of ADJ BILLED Sum of NETP PMT/CREDIT Sum of END RECEIVABLE Percent Collected $5,076,596.85 $5,076,536.24 $6,009,527.12 $5,249,779.17 $21,181,212.55 $101,012.32 $81,285.87 $42,775,950.12 $5,076,338.96 $5,076,278.35 $4,604,011.29 $5,249,779.17 $20,857,980.58 $100,810.64 $79,539.72 $41,044,738.71 $257.89 $257.89 $1,405,515.83 $0.00 $323,231.97 $201.68 $1,746.15 $1,731,211.41 2024 PERIOD ENDING: Sum of ADJ BILLED Sum of NETPMT/CREDIT Sum of END RECEIVABLE Percent Collected $5,184,127.60 $5,177,517.08 $5,700,642.24 $5,229,554.50 $165,935.65 $11,044,595.77 $11,015,473.78 $43,517,846.62 $5,182,846.00 $5,142,545.62 $845,331.34 $687,108.79 $84,586.35 $10,927,685.97 $10,535,879.65 $33,405,983.72 $1,281.60 $34,971.46 $4,855,310.90 $4,542,445.71 $81,349.30 $116,909.80 $479,594.13 $10,111,862.90 FY22-24 RE PP TAXS SUMMARY REPORT PERIODI ENDING: JANUARY 2025 PREPARED BY: N. HART 10F1 City of Hopewell Billy Year2 2022-2025 oF HOPEL Business License & Meal Tax Collection Report EALTH of Charge) Year Row Labels BANK FRANCHISE BUSINESS & OTHER: SVC LODGING MEAL TAX Grand Total Charge Year Row Labels BANKI FRANCHISE BUSINESS& OTHERSVC LODGING MEAL TAX Grand' Total Charge' Year Rowl Labels BANK FRANCHISE BUSINESS & OTHER: SVC LODGING MEAL TAX Grand' Total Charge) Year Rowl Labels BUSINESS & OTHER: SVC Grand Total 2022 PERIOD ENDING: Jan-25 100.00% 99.75% 100.00% 99.69% 99.77% Jan-25 100.00% 100.58% 100.00% 98.65% 99.62% Jan-25 100.00% 98.01% 95.10% 95.65% 96.49% Jan-25 80.31% 80.31% Sum of ADJ BILLED Sum of NET PMT/CREDIT SUmofENDRECEIVABLE Percent Collected $82,655.00 $2,147,333.00 $964,079.50 $2,572,497.75 $5,766,565.25 $82,655.00 $2,142,052.38 $964,079.50 $2,564,520.40 $5,753,307.28 $0.00 $5,280.62 $0.00 $7,977.35 $13,257.97 2023 PERIOD ENDING: Sum of ADJBILLED Sum OfNETP PMT/CREDIT Sum of END RECEIVABLE Percent Collected $57,815.00 $2,419,528.60 $1,030,843.60 $2,787,405.63 $6,295,592.83 $57,815.00 $2,433,488.08 $1,030,843.60 $2,749,670.01 $6,271,816.69 $0.00 ($13,959.48) $0.00 $37,735.62 $23,776.14 2024 PERIOD ENDING: Sum of ADJ BILLED Sum of NET PMT/CREDIT Sum of ENDI RECEIVABLE Percent Collected $73,568.00 $2,575,715.25 $1,245,549.80 $2,876,656.61 $6,771,489.66 $73,568.00 $2,524,396.25 $1,184,513.62 $2,751,382.61 $6,533,860.48 $0.00 $51,319.00 $61,036.18 $125,274.00 $237,629.18 2025 PERIOD ENDING: Sum of ADJ BILLED Sum OfNET PMT/CREDIT Sum of ENDI RECEIVABLE Percent Collected $194,354.54 $194,354.54 $156,090.99 $156,090.99 $38,263.55 $38,263.55 22-25 BUSINESSLICMEALT TAX PERIOD:. JANUARY: 2025 PREPARED BY: N. HART 10F1 Cityo ofH Hopewell Banka andinvestmentB FY2025 /92924 712024 1/1/2024 9/92024 1/1/20 28123:775 29,323.775 29,623.775 30,423.77 30423775 30,423-775 9304551605 11,019,47619 15,635, (0004 1940.455 1940.455 194045 1940455 191045 1940.455 19:0.45 152.39127 151.537,65 133,01383 139,01307 25.00 25.00 100.005 25.00 6100 69,616175 779,35225 1045.49257 300000 230,02200 165,07497 317.54270 394229.49 797292 155.267.72 10,000005 55718475 10773.005 642800 7A52005 6812195 1115660 3,000.005 6935505 353.00 500 450005 454.00 300.00 72387.13 62577.73 7511631 70,64269 7825433 8152399 90103.74 108,49093S 88,043185 4264318 3328018 11428015 62851855 48279835 1/2924 /34/2924 11/,9/2023 1/1/2023 787,742.705 731.36355 794994155 733.43955 80184383 805,01722 808.176.775 292.77441 234120075 285,469.525 295,75019 299,19471 580397005 2590,6093 355:50169 1365,657855 37203179 86.40 1.19444152 199,618.65 1204732835 1209.500745 709,39173 712,645.455 715.73533 718,78561 724,453875 255,725 256905185 258,8385 260,30743 261.337.705 2884325415 299,801735 301.101175 302,3 8483 303.581575 304.773.05 00 2005 2005 2005 200 200 722:209.705 724724595 185926955 272,668:76 554874945 557,238615 553,658935 562.164215 564,48365 568.902 47,10852 62,14161 77,237.765 92.333.45 16883.61 45.95092 111,416425 123,66104 135968595 143.32405 4954472 353/3226 35495803 355.555375 125875 603.47 10,428.03 1372145 17028705 20,349.005 391 5,608.6 65 0320023 5326803 144,335855 13183 YAP-ZEA atralsafetyCoundi aster ZBA dCard Treasurers- ZBA SpecialWelare 2012LLC TetalCash CaptalPrcedfundl EAtSEPAINTPESA LGPPortiolo. BAASPahAeng bSRevereknd 30,423.77 14392.849 138,42825 31847,10410 22.005,003.12 17,513,088.00 13.593.306.31 133945525 139831425 152414595 75.178.47 67,70522 81125784 32,37425387 $ 22,650,825.37 $ 18,317,48836 $ 14,751,65803 $ 10,893,33385 $ 11,351,60113 $ 16233,670.52 $ 14,722,48637 35.018.41 2545670055 255835427 2559,443.05 1337,34103 134348785 1349,651815 221445089 2224629125 2234835815 2244522385 2254.091185 2263,012055 227189397 1041943.435 104573751 1051.540.005 1.055.097.765 1,060,600.11 1064797.615 1068.976.74 5.735.787.025 5.76342708 5805.091205 5845,035305 5827,244.575 586028535 5884244025 2935,78195 294578382 2551233.78 2974720605 2.955.740.405 2997,402015 300837585 272.669.765 272,665765 272,668:765 272,668765 272.66876 272.668.76 1361815005 1351815.005 1351815.005 136181500 1,351815005 1351815.005 727,333115 723,551015 732421155 734778265 735973835 873241235 1025255955 1171628055 131978985 1A68.479.105 1.51695483 31,40080 28289.445 51,.060.065 115889.85 259.165 25,225,335:20 24,405,26265 24746,547.82 25,083,248:52 24835,363.47 25,145,459.73 $ 24963,286.02 57,599,569.07 47,056,08502 43,064,236.78 39,834,94655 35,407,29242 36,186,564.60 $ 39,685,17239 1ofi 20250207 ADJOURNMENT