Finance Committee

CllY OF VERONA 111 Lin coin Street Verona, WI 53593 (608) 845-6495 llfilQnawi,.gQY FINANCE COMMITTEE DATE: MONDAY, AUGUST 11, 2025 TIME: 6:00 PM LOCATION: CONFERENCE ROOM D110 CITY HALL 111 LINCOLN STREET VERONA, WI 53593 1. Call to Order 2. Roll Call 3. Public Comment 4. Discussion and Possible Action re: Recommended Approval of the July 28, 2025, Finance Committee Minutes 5. Discussion and Possible Action re: Purchasing Security Cameras and Fobs for Buildings Located at the Public Works Department and Parks and Urban Forestry Department 6. Discussion and Possible Action re: Leasing and Purchasing Leaf Vac Truck 7. Discussion and Possible Action re: Revenue and Expenditure Summary Report-July 2025 8. Discussion and Possible Action re: City Investment Report-July 2025 9. Discussion and Possible Action re: 2026 Budget Updates 1 0. Discussion and Possible Action re: Payment of Bills 11. Adjournment. Mara Helmke - Chairperson POSTED: August 8, 2025 Verona City Hall Verona Public Library Miller's Market All agendas are posted on the City website at: \lero_o.awtsov Notice: If you need an interpreter, materials in alternative formats, or other accommodation to access the meeting, please contact the City Clerk at (608) 845-6495 at least 48 hours preceding the meeting. Every reasonable effort will be made to accommodate your request. Notice is hereby given that a quorum of the members of the City Council or other standing committees of the City Council may be present at the meeting of the Finance Committee to gather information about a subject over which they have decision-making responsibility. The City Council and any other standing committees will not take formal action at this meeting. Page 1 of 20  City of Verona Finance Committee City Hall - 111 Lincoln Street Verona, WI 53593-1520 MINUTES FINANCE COMMITTEE JULY 28, 2025 The meeting was called to order by Alder Patrick Lytle at 6: 15 p.m. Roll Call: Alder Patrick Lytle and Alder Spencer Harrison were present. Chairperson Mara Helmke was excused. Also present: Mayor Luke Diaz, City Administrator Jamie Aulik and Finance Director Brian Lamers Public Comment: None Discussion and Possible Action regarding approval of July 14, 2025 Finance Committee minutes: Motion was made by Harrison, seconded by Lytle to approve the July 14, 2025 Finance Committee minutes with no changes noted. Motion carried 2-0. Discussion and Possible Action regarding 2026 Budget Updates: Lamers stated that there has been Capital budget discussion with some updates. Departments deadline for the Operating budgets are 7/30/25,just starting to get some back. Discussion and Possible Action regarding the payment of bills: Motion was made by Harrison, seconded by Lytle to approve the payment of bills totaling $767,773.10. Motion carried 2-0. Adjournment: Motion was made by Harrison, seconded by Lytle to adjourn the Finance Committee Meeting at 6:28 p.m. Motion carried 2-0. Respectfully submitted, Brian Lamers CPA Finance Director Page 2 of 20 www.ci.verona.wi.us Cameras and FOBs - PWK and Parks Cost I2025 Budget Cameras for Public Works Building $ 9,468.00 $ 7,517.51 Cameras for Parks Building $ 4,388.00 Entry Fobs for Public Works Building $15,863.00 Entry Fobs for Parks Building $ 7,048.00 Entry Fob for Cold Storage Building $ 7,085.00 Subtotal $43,852.00 Subtractions (budget) $ 7,517.51 Total $36,334.49 Page 3 of 20  ASI Security, Inc. 608-848-6880 www.ASlsecurityNOW.com City of Verona Revised: May 8, 2025 410 Investment Ct. Verona, WI 53593 Attn: Simon Hesch Verona Public Works Bu.i lding - CCTV System Install CCTV System: AS[ will install 3 new Digital Watchdog Bullet Cameras on the outside of the building, Digital Watchdog Blackbox DX Server. This system is NOAA and TAA Compliant. List of Equipment 1- Digital Watchdog DX Sener, DW-BJDX3120T • Intel 13 Protessor ----- • 20TB bard drive • Windows 11 Operating System l)W • Record and manage single and multi-sensor IP cameras of any resolution up to 80Mbps Throughput • One time Spectrum Software License included 2- Trendnet 8-Port PoE Switches • Front & back of shop 1- PoE Switch Enclosure • Back wall 5- Digital Watchdog IP Bullet Cameras • SMPx Resolution, 2.8mm fixed lens with Wide Dynamic Range • • IR Range up to 164 feet Field ofview: horizontal: 98,5° • • Auto or scheduled, Day (color), Night (8/W) • Line crossing & video analytics • One time Software License included • Lm:ations: front parkiog Jot, front overhead door, side parking lot, back lot entrance, employee parking 3- Digital Watchdog Bullet Camera Back Boxes Lot- Wire & Equipment Installation Lot- Installation coonecton & system setup Lot- Networking and Customer Training Estimated cost to install CCTV System: $ 9,468.00 + tax (if applicable) *This price estimate is valid for 60 days L) J S°C)~ r, lr"•-"V Ifaw ~ CCTV System Notes: ~ I.f\v I 1. You will be able to view live footage at any time as well as view past motion recordings on your ~ Digillll Watchdog app 2. This CCTV system will be set up to r~ord 24n to your Digital Watchdog Server. 3. This CCTV System will not be set up lo give you motion ootilications. 4. ASI will plan to use an open port on your internet router. 5. High speed internet is requin:d for oflsite viewing. 6. There is NO monthly monitoring ree with this CCTV System. 7. Thue will bell service fee to re-network your Digital Watchdog Server should your internet service or router change ufter installation. 8. 110\'AC and Conduit by others Thank you for the opportunity to bid your business CCTV System Install. We look forward to working with the City of Verona and the Public Works Building. Sincerely, The ASI Security, Inc. Team 608-848-6880 245 Horizon Drive #104 www.ASisecuritynow.com Verona, WI 53593 Page 4 of 20  ASI Security, Inc. • • 608-848-6880 www.ASlsecurityNOW.com City of Verona May2,2025 410 Investment CL Verona, WI 53593 Attn: Simon Hesch Verona Public Works Building - Access Control System Install Access System: ASJ will instaU 7 new Paxton 10 Slimline Proximity Readers with Bluetooth wireless technology. This building's access control system wlJI be incorporated into tbe main Paxton 10 Server at an administration building or Verona Fire Department. This system is NDAA Compliant. List of Access Equipment: 7- Paxton 10 PoE & Network Door Controllers with lnd.Mdual Door Lock Power • SbopDoors 7- Paxton 10 Proximity Slimline Bluetooth Card Readers • Shop Doors • Built in Bluetooth Wireless Ttthnology 50- Proximity Key Fobs 1- Paxton Desktop Enrollment Reader • Read and enroll HID access cards Lot Controller, Reader & Door Strike Wire Lot Cable & Equipment Installation Lot Prognmming. system testing and customer training Estimated cost to install Access Control System & ee I • SySlthl il!tpg. • de: i 10,9BS..OO Door Hardware Allowance: $ 8.875.00 Total Estimated Cost to install Access Control System&: G S ~ ; ; 111 rile· $19,863.00 tu (if applicable) *This price estimate is valid for 60 dayii ~ -100- .. ·:,J?;s(g3.oo Access System Notes: 1. JU)VAC and conduit will be required by others. The price for tbis is not included in this estimate. 2. There i!I NO monthly monitoring fee with this acces!I control system. 3. Tbls building's acces1 control system will be incorporated into the main Paxton 10 Server at an administration building or Verona Fire DepartmenL 4. If door hardware installation exceeds the allowance, it will be billed accordingly. Thank you for the opportunity to bid your business Access Control System Install. We look forward to working with the City ofVerona and the Public Works Building. Sincerely, The ASI Security, Inc. Team 608-848-6880 245 Horizon Drive #104 www.AS1securitynow.eom Ven>Illll, WI 53593 Page 5 of 20  ASI Security, Inc. • 608-848-6880 www.ASlsecurityNOW.com City of Verona May 20, 2025 410 Investment Ct. Verona, WI 53593 Attn: Simon Hesch Verona Cold Storage Building -Access Control System Install Access System: ASI will install 2 new Paxton 10 Proximity Keypad Readers with Bluetooth wireless technology. This building's access control system will be incorporated into the existing Paxton 10 Server. An internet bridge will be installed from the Public Works Building to the Cold Storage Building to provide the internet connect connection for this Access System. This system is NDAA Compliant. List of Access Equipment: 2- Paxton lO PoE & Network Door Controllers with Individual Door Lock Power • Entry doors 2- Paxton 10 Proximity Keypad Bluetooth Card Readers • Entry Doors • Built in Bluetooth Wireless Technology 1- 9 Port 8 PoE Switch • Read aod enroll HID access cards 1- Trendnet Bridge KU Lot Controller, Reader & Door Strike Wire Lot . Cable & Equipment Installation Lot Programming, system testing and customer training Estimated cost to install Access Control System & CCTV System Upgrade: $6,248.00 Door Hardware Allowance: $ 800.00 Total Estimated Cost to install Access Control System: $ 7,048.00 + lat (If applicable) *This price estimate is valid for 60 days Access System Notes: 1. llOVAC and conduit will be required by others. The price for this is not included in this estimate. 2. There is NO monthly monitoring fee with this access control system. 3. This building's access control system will be incorporated into the existing main Paxton 10 Server. 4. If door hardware installation exceeds the allowance, it will be billed accordingly. Thank you for the opportunity to bid your business Access Control System Install. We look forward to working with the City of Verona and the Cold Storage Building. Sincerely, The ASI Security, Inc. Team 608-848-6880 245 Horizon Drive #104 www.ASlsccuritynow.com Venma, WI 53593 Page 6 of 20  ASI Security, Inc. • 608-848-6880 www.ASiseeurityNOW.eom City of Verona May 20, 202S 410 Investment Ct. Verona, WI 53593 Attn: Simon Hesch P arks Building- CCTV System CCTV System: ASI will install 4 new Digital Watchdog Bullet Cameras on the outside of the building. These CCTV cameras will connect to the existing Digital Watchdog Black Jack DX Server in the Verona Public Works Building. We will use the existing wireless internet bridge to provide internet for these CCTV Cameras. This system is NOAA and T AA Compliant List of Equipment 1- Trendnet 9-Port 8 PoE Switch 4- Digital Watchdog IP Bullet Cameras • 5MPx Resolution, 2.8mm fixed lens with Wide Dynamic Range • IR Range up to 164 feet • Field of view: horizontal: 98.S° • Auto or scheduled, Day (color), Night (B/W) • Line crossing & video analytics 4- Digital Watchdog Bullet Camera Back Boxes 4- One time Software License included Lot- Wire & Equipment Installation Lot- Installation connectors & system setup Lot- Networking and Customer Training Estimated cost to install CCTV System: $ 4,388.00 + tax (if applicable) *This price estimate is valid for 60 days CCTV System .Notes: l, You will be able to view live footage at any time as well as view pasl motion recordings on your Digital Watchdog app. 2. Th.is CCTV system will be set up to rewrd 24n to your Digit11I Walchdog Server. J, This CCTV System will nol be set up lo give you motion notifu:ations. 4. ASI will plan to use an open port on your intunet router. 5. High speed internet is required for ofTsite viewing. 6. There i! NO monlbly monitoring fee with this CCTV System. 7. There will be a service fee to n:--network your Digilal Watchdog Server should your internet service or muter change after iostallation. 8. 11 OV AC and Conduit by olhers Thank you for the opportunity to bid your business Access Control System and CCTV System Upgrades. We look forward to working with the City of Verona and the Parks Building Sincerely, The ASI Security, Inc. Team 608-848•6880 ~45 Hor izon Drive #104 ~-..-..·.ASISe£nritynow.com Verona, WI 53593 Page 7 of 20  ASI Security, Inc. • 608-848-6880 www.ASisecurityNOW.com City of Verona May20,2025 410 Investment Ct. Verona, WI 53593 Attn: Simon Hesch !Parks Building-Access System Access System: ASI will install 3 new Paxton 10 Proximity Keypad Readers with Bluetootb wireless technology. This building's access control system will be incorporated into the existing Paxton 10 Server. We will use the existing wireless internet bridge to provide internet for this Access Control System. This system is NDAA Compliant. List of Access Equipment: 3- Paxton 10 PoE & Network Door Controllers with Individual Door Lock Power • Entry doors 3- Putou 10 Proximity Keypad Bluetootb Card Readers • Entry Doors • Built in Bluetooth Wireless Technology 1- 5 Port 4 PoE Switch • Re.ad and enroll HID access cards Lot Controller, Reader & Door Strike Wire Lot Cable & Equipment Installation Lot Programming, system testing and customer training Estimated cost to install Access Control System & CCTV System Upgrade: $5,885.00 . Door Hardware Allowance: $1,200.00 Total Estimated Cost to install Access Control System: $ 7,085.00 + tax (if applicable) *This price estimate is valid for 60 days Access System Notes: 1. 110VAC and conduit will be required by others. The price for this is not included in this estimate. 2. There is NO monthly monitoring fee with this access control system. 3. This building's access control system will be incorporated into the main Paxton 10 Server. 4. If door hardware installation exceeds the allowance, it will be billed accordingly. 608-84~880 245 Horizon Drive #104 www.ASlsecurityno"'-COm Veruna, W153593 Page 8 of 20 Jamie Aulik From: Bryan Manning Sent: Monday, July 28, 2025 4:35 PM To: Jamie Aulik Subject: Second leaf truck Attachments: 20250728160035.pdf I've attached some additional information regarding the possible purchase of a second leaf truck, which would be available for us to use this Fall. If we wait to order the second truck until after the 2026 budget is approved in November, it would not be ready for delivery until 2027 and would have the new emission requirements. Looking for creative options to take advantage of this opportunity to get the truck this year and save at least $50k. We are scheduled to take delivery of the first leaf truck next month. 1 Page 9 of 20 7128'25, 12:28 PM RE: Leaf Truck Available· Chad Hoflfelder - Outlook ~ Outlook RE: Leaf Truck Available From Ben Schroeder <Ben.Schroeder@macqueengroup.com> Date Mon 7/28/2025 10:15 AM To Chad Hollfelder <chollfelder@veronawi.gov> Hi Chad, Please let me know if you have any questions regarding the available truck from Titan. As of this morning, it is still available. 1 know this is a rare opportunity that doesn't come around often and I was curious as to how pricing and timelines may be affected by waiting until later this year (or next year) to purchase another truck-mounted unit: 1. Titan has already taken two price increases this year and there are likely more to come. For budget purposes, they are telling us to plan on another 8-12% for 2026. 2. Current build times are into the fall of 2026. Orders placed this month will likely miss leaf season 2026. 3. As you are aware, new engine emission requirements will be in place at the end of 2026 and Cummins is making some big changes. Hopefully, the launch of these new engines will be successful-but they won't come without additional cost. We are forecasting an increase of $30k-40k across the Cummins lineup. Based off a purchase price of $322k, it is possible that your truck/spec could cost $365k-375k next year. I would want to plan for this, at least, to make sure we are covered in a worst-case scenario. Thanks, Ben Ben Schroeder Sales Manager I Menomonee Falls, WI ben.schroeder@macgueengr.gyp.com Mobile: 520-990-4206 ~ MACQUEEN-. From: Ben Schroeder Sent: Thursday, July 24, 2025 7:39 AM To: Chad Hollfelder <chad.hollfelder@ci.verona.wi.us> Subject: RE: leaf Truck Available Hi Chad, Truck quote, initial lease options and chassis spec are attached. I will send some pies in another email due to file size-the pies are of a different unit built with the same options just to give you an idea of what it looks like. Finance terms are for 1,3,and 5 years with first payment not due until January 2026. I had them use a sale price of $325k to estimate payments while I was waiting for final pricing from Titan. I should have updated lease quotes with actual sale price yet today. It is a Municipal Lease so the usual advantages and pre-payment terms apply. I about blank Page 10 of 20 1/2 08/07/2025 10:15 AM REVENUE AND EXPENDITURE REPORT FOR CITY OF VERONA Page: 1/9 User: brian.larners DB: Verona PERIOD ENDING 07/31/2025 END BALANCE YTD BALANCE ACTIVITY FOR AVAILABLE 12/31/2024 07/31/2025 2025 MONTH 07/31/25 BALANCE 'I; BDGT GL NUMBER DESCRIPTION NORM (ABNORM) NORM (ABNORM) AMENDED BUDGET INCR (DECR) NORM (ABNORM ) USED Fund 100 - GENERAL 00000 12, 599 ,090.69 4,662,323.31 13,710,395 .00 795,399.41 9,048,071.69 34.01 TOTAL REVENUES 12,599,090.69 4,662,323.31 13,710,395.00 795,399.41 9,048,071.69 34.01 00000 1,348,752.83 2,953,907.28 3,072,262.00 0.00 118 ,354.72 96.15 51100 - COUNCIL 283,497.75 207, 156 .18 253,005.00 24,805.94 45,848.82 81. 88 5 1200 - MUNICIPAL COURT 77, 177 .·63 48,270.28 87,105.00 5,82 1.80 38,834. 72 55.42 51400 - ADMI NISTRATI ON 943,471.25 610,863.97 1,195,691.00 94,814.16 584,827.03 51.09 51600 - BUILDINGS AND GROUNDS 108, 567 .67 57,251.94 121,400.00 12,779. 82 64,148.06 47.16 52101 - POLICE ADMINISTRATION 1,047,430.81 645,080.15 1,304,895.00 86,248.00 659,814.85 49.44 52102 - POLICE FIELD OPERATIONS 2,072,912.21 1,089,304.25 2,542,060.00 171,131.44 1,452,755.75 42.85 52103 - POLICE CRIMINAL INVESTIGATION 497, 244 .96 255,051.98 512, 457. 00 37,682.14 257,405.02 49. 77 52104 - POLI CE BUSINESS OFFICE 168, 119 .51 85,996.28 222,499.00 15,039.59 136,502.72 38.65 52105 - POLICE SUPPORT SERVI CES 456,298.20 271,673.24 505,561.00 27,559.58 2 33 ,887.76 53.74 52400 - BUILDING INSPECTOR 335,236.50 174,724.75 398,722.00 20,563.59 223,997.25 43.82 52900 - EMERGENCY PREPAREDNESS 4,160. 19 3,474.70 11,950. 00 519.19 8,475.30 29.08 53100 - PUBLIC WORKS 1,764,143.33 862,847.05 1,812,078 . 00 295,357.83 949,230.95 47.62 53300 0.00 0.00 0.00 0.00 0.00 0.00 55200 - PARKS 797,205.53 419, 799 .07 974,386.00 73,021.61 554,586.93 43 .08 55300 - RECREATION 387 I 717 • 72 216,000. 12 400,235.00 80,957. 14 184, 234.88 53.97 56400 0.00 0.00 0.00 0.00 0.00 0.00 56900 - PLANNING 232,287.67 126,572.93 296,089.00 17,852.45 169,51 6.07 42.75 TOTAL EXPENDITURES 10,524,223.76 8,027,974 .17 13,710 ,395.00 964, 1 54.28 5,682,420.83 58.55 Fund 100 - GENERAL: TOTAL REVENUES 1 2,599,090.69 4,662,323.3 1 13,710 ,395.00 795,399.41 9,048,071.69 34.01 TOTAL EXPENDITURES 10,524,223.76 8, 027, 97 4 . l 7 13,710,395.00 964,154.28 5,682,420.83 58.55 NET OF REVENUES & EXPENDITURES 2,07 4,866 .93 (3,365,650.86) 0.00 (168,754.87) 3,365,650.86 100.00 Fund 200 - LIBRARY 00000 3,036,179.63 3,307,710.18 3,325,102.00 3,299.95 17,391.82 99.48 TOTAL REVENUES 3,036,179.63 3,307,7 10 .18 3,325,102.00 3,299.95 17,391.82 99.48 00000 3,156,608 .83 2,060,925.57 3,325,102.00 221,719.18 1, 264,17 6.43 61.98 TOTAL EXPENDITURES 3,156,608.83 2,060,925.57 3,325,102.00 221,719.18 1,264,176.43 61. 98 Fund 200 - LIBRARY: TOTAL REVENUES 3,036,179.63 3,307,710.18 3,325,102.00 3,299 .95 17,391.82 99. 48 TOTAL EXPENDITURES 3,156,608.83 2,060,925.57 3,325 ,102. 00 221,719.18 1,264,176. 43 61.98 NET OF REVENUES & EXPENDITURES (120,429.20) 1,246,784.61 0 .00 (218,419.23) (1,246,784.61) 100. 00 Fund 201 - SENIOR CENTER 00000 732,534.62 845,795.17 899,816.00 17,573.66 54,020.83 94.00 Page 11 of 20 TOTAL REVENUES 732,534.62 845 ,795. 17 899,816.00 17,573.66 54,020.83 94.00 08/07/ 202 5 10:15 AM REVENUE AND EXPENDITURE REPORT FOR CITY OF VERONA Page: 2/9 User: brian .lamers DB: Verona PERIOD ENDING 07/31/2025 END BALANCE YTD BALANCE ACTIVITY FOR AVAILABLE 12/31/2024 07/31/2025 2025 MONTH 07/31/25 BALANCE % BDGT GL NUMBER DESCRIPTION NORM (ABNORM) NORM (ABNORM) AMENDED BUDGET INCR (DECR) NORM (ABNORM} USED Fund 201 - SENIOR CENTER 00000 545,60 9.42 398,933.47 899,816.00 78,529.23 500,88 2.53 44.34 TOTAL EXPENDITURES 545,609.42 398,933.47 899,816.00 78,529.23 500,882.53 44.34 Fund 201 - SENIOR CENTER: TOTAL REVENUES 732,534.62 845,795.17 899,816.00 17 ,573.66 54, 020 .83 94.00 TOTAL EXPENDITURES 545,609.42 398,933.47 899,816.00 78,529.23 500,882.53 44.34 NET OF REVENUES & EXPENDITURES 186,925.20 446,861.70 0.00 (60,95 5 . 57 ) ( 446,861.70) 100.00 Fund 202 - FIRE DEPARTMENT 00000 2,201 , 129.41 2,301,961.94 2,259, 974. 00 314,273.62 (41,987.94) 101.86 TOTAL REVENUES 2,201,129.41 2,301,961.94 2,259,974.00 314,273.62 ( 41,987.94 ) 101.86 00000 l, 942,871.34 1,212,691.88 2,259, 9 74.00 174,953.76 1,047, 282.12 53.66 TOTAL EXPENDITURES 1,942,871.34 1,212,691.88 2 ,259,97 4.00 174,953. 76 1,047,282.12 53.66 Fund 202 - FIRE DEPARTMENT : TOTAL REVENUES 2,201,129.41 2,301,961.94 2,259,97 4 .00 3 14 ,273.62 (41,987.94) 101.86 TOTAL EXPENDITURES 1,942,871. 34 1,212,691.88 2,259,974 .00 174,953.76 1,047,282.12 53.66 NET OF REVENUES & EXPENDI TURES 258,258.07 1,089,2 70 . 06 0.00 139,319.86 11,089,270.06) 100.00 Fund 203 - REFUSE AND RECYCLING 00000 880,355.05 921,946.46 925,640.00 904.68 3,693.54 99.60 TOTAL REVENUES 880,355.05 921,946.46 925,640.00 904.68 3,693.54 99.60 00000 789,177.55 413,281.71 927,176.00 68,696.74 513,894.29 44.57 TOTAL EXPENDITURES 789,177.55 413,281. 71 927,176.00 68,696.74 513,894.29 44.57 Fund 203 - REFUSE AND RECYCLING: TOTAL REVENUES 880,355.05 921,946.46 925,640.00 904.68 3,693.54 99.60 TOTAL EXPENDITURES 789,177.55 413,281. 71 927, 176 .00 68,696.74 513,894.29 44.57 NET OF REVENUES & EXPENDITURES 91, 177.50 508,664.75 (1,536.00) (67,792.06) (510,2 00 .75) 33,116.1 Fund 204 - CABLE FRANCHISE 00000 136,652.99 66,555.69 140,000. 00 41,458.98 73,444.31 47 .54 TOTAL REVENUES 136,652.99 66,555.69 1 40,000.00 41,458.98 73,44 4.31 47 .54 00000 235,909.97 182,257.81 139,097 .00 7,792.48 (43,160.81) 131 .03 Page 12 of 20 08/07/2025 10:1 5 AM REVENUE AND EXPENDITURE REPORT FOR CITY OF VERONA Page: 3/9 User: brian.lamers DB: Verona PERIOD ENDING 07/31/2025 END BALANCE YTD BALANCE ACTIVITY FOR AVAILABLE 12/31/2 024 07/31/2025 2025 MONTH 07/31/25 BALANCE % BDGT GL NUMBER DESCRIPTION NORM (ABNORM) NORM (ABNORM) AMENDED BUDGET INCR (DECR) NORM (ABNORM) USED Fund 204 - CABLE FRANCHISE TOTAL EXPENDITURES 235,909. 97 182, 257. 81 139,097.00 7,792.48 (43, 1 60.81) 131.03 Fund 204 - CABLE FRANCHISE: TOTAL REVENUES 136,652.99 66,555.69 1 40,000.00 41,458.98 73,44 4.31 47.54 TOTAL EXPENDITURES 235,909.97 182,257 .81 139 , 097.00 7,792.48 (43 , 1 60.81) 131.03 NET OF REVENUES & EXPENDITURES (99,256.98) (115 ,702.12) 903.00 33,666 .50 116,605.12 12,813.0 Fund 205 - FORESTRY 00000 89, 790.40 73,917 . 50 119, 700. 00 2,925.00 45 ,782. 50 61.75 TOTAL REVENUES 89,790.40 73,917.50 119,700.00 2,925.00 45,782.50 61.75 00000 65,993.62 23,066.89 116,700.00 134.54 93,633.11 19.77 TOTAL EXPENDITURES 65,993.62 23,066.89 116,700.00 134. 54 93,633 .11 19. 77 Fund 205 - FORESTRY: TOTAL REVENUES 89,7 90.40 73,917 .50 119,700.00 2,925.00 45,782 . 50 61.75 TOTAL EXPENDITURES 65,993.62 23,066.89 11 6, 700.00 134.54 93 ,633. 11 19. 77 NET OF REVENUES & EXPENDITURES 23,796.78 50,850 .61 3,000.00 2,790 .46 (47,850.61 ) 1 ,695.02 Fund 206 - CEMETERY 00000 33,172.25 18,385 . 30 25,000.00 1,276.98 6,614.70 73.54 TOTAL REVENUES 33,172.25 18,385.30 25,000.00 1,276.98 6,614. 70 73.54 00000 37,936.90 6,614.11 35,550.00 30 . 2 1 28,935.89 18.61 TOTAL EXPENDITURES 37,936.90 6,614.11 35 , 550.00 30. 2 1 28,935.89 18.61 Fund 206 - CEMETERY: TOTAL REVENUES 33,172.25 18,385.30 25,000.00 1,27 6.98 6,61 4.70 73.54 TOTAL EXPENDITURES 37,936.90 6,614.11 35,550.00 30.21 28,935.89 18.61 NET OF REVENUES & EXPENDITURES (4, 764.65) 11,771.19 (10 ,550. 00) 1,246.77 (22,3 21.19) 111.58 Fund 207 - SPECIAL ACCOUNTS 00000 3,609,571. 09 1,516,624.76 914,215.00 90, 147.88 (602,409.76) 165.89 TOTAL REVENUES 3,609,571.09 1,51 6,624. 7 6 914,215.00 90, 147.8 8 (602 ,409. 76) 165 . 8 9 00000 1,691 ,757.49 833,076.45 0.00 341,701.00 (833,076.45) 100.00 51100 - COUNCI L 0.00 0.00 0.00 0.00 0.00 0.00 51400 - ADMINISTRATION 0.00 0.00 0.00 0.00 0.00 0.00 52101 - POLICE ADMINISTRATION 0.00 0.00 0 . 00 0.00 0 . 00 0 . 00 Page 13 of 20 52102 - POLICE FIELD OPERAT IONS 2,914.87 2,206.98 0.00 145.23 (2,206.98) 1 00.00 52103 - POLICE CRIMINAL INVESTIGATION 13,652.62 11,215 .52 0.00 9,848.48 (11,2 15 .52) 1 00 . 00 08/07/2025 10: 15 AM REVENUE AND EXPENDITURE REPORT FOR CITY OF VERONA Page: 4/9 User: brian.lamers DB: Verona PERIOD ENDING 07/31/2025 END BALANCE YTD BALANCE ACTIVITY FOR AVAILABLE 12/31/2024 07/31/2025 2025 MONTH 07/31/25 BALANCE % BDGT GL NUMBER DESCRIPTION NORM (ABNORM) NORM (ABNORM) AMENDED BUDGET INCR (DECR) NORM (ABNORM) USED FUnd 207 - SPECIAL ACCOUNTS 52105 - POLICE SUPPORT SERVICES 0.00 1,691.96 0.00 0.00 (1,691.96) 100.00 52200 - FIRE DEPARTMENT o.oo 8,294.94 0.00 0.00 (8,294.94) 100 .00 52300 - AMBULANCE 807,610 .00 842,337.00 914,215.00 0.00 71,878.00 92.14 54600 - SENIOR CENTER 2,598.90 254.95 0.0 0 0.00 (25 4.95) 100.00 55110 - LIBRARY 16,571.20 5, 660.79 0.00 141 .50 (5,660.79) 100.00 56900 - PLANNING 0.00 52,537.46 o.oo 8,386.70 (52,537.46) 100.00 TOTAL EXPENDITURES 2,535,105.08 1,757 ,27 6.05 914,215.00 360,222.91 (843,061.05) 1 92 .22 Fund 207 - SPECIAL ACCOUNTS: TOTAL REVENUES 3,609,571.09 1,516,624.76 914,215.00 90,147.88 {602,409.76) 165. 89 TOTAL EXPENDITURES 2,535,105.08 1,757,276.05 914,215.00 360,222.91 (843,061.05) 192.22 NET OF REVENUES & EXPENDITURES 1 ,074,466.01 (240,651.29) 0 . 00 (270,075.03) 240,651.29 100 .00 Fund 208 - ECONOMIC DEVELOPMENT 00000 2, 204.85 926.10 1,575.00 97.09 648.90 58.80 TOTAL REVENUES 2,204.85 926.10 1,575 . 00 97.09 648.90 58.80 00000 0 .00 0.00 0.00 0.00 0.00 0.00 TOTAL EXPENDITURES 0.00 0.00 0.00 0.00 0 .00 0.00 Fund 208 - ECONOMIC DEVELOPMENT: TOTAL REVENUES 2,204.85 926 . 1 0 1,575 .00 97.09 648 .90 58.80 TOTAL EXPENDITURES 0.00 0.00 0.00 0.00 0.00 0 .00 NET OF REVENUES & EXPENDITURES 2,204.85 926. 10 1,575.00 97.09 -------- 648 .90 58.80 Fund 209 - IMPACT FEES 00000 716 ,793.78 404,042 . 10 0 . 00 1 5,319 .00 {404 ,04 2 .10) 100.00 TOTAL REVENUES 716,793.78 404,042.10 0.00 15,319.00 (404,042.10) 100.00 00000 615,550 .00 72 1 ,975.00 0.00 0.00 (721,975.00) 100.00 TOTAL EXPENDITURES 615,550.00 721,975.00 0 .00 0 . 00 ( 721,975 .00) 100.00 Fund 209 - IMPACT FEES; TOTAL REVENUES 716,793.78 404,042.10 0.00 15,319.00 (404,042 . 10) 100.00 TOTAL EXPENDITURES 615,550 . 00 721,975.00 0.00 0.00 (721,975.00) 100.00 NET OF REVENUES & EXPENDITURES 101,243.78 (317,932.90) 0 .00 15,319.00 317,932.90 100.00 Fund 300 - DEBT SERVICE 00000 4,733,390.40 4,559,474.00 4,559,474 . 00 0.0 0 0 . 00 100.00 Page 14 of 20 D8/07/2025 10: 15 AM REVENUE AND EXPENDITURE REPORT FOR CITY OF VERONA · Page: 5/9 User: brian.lamers DB: Verona PERIOD ENDING D7/31/2025 END BALANCE YTD BALANCE ACTIVITY FOR AVAILABLE 12/31/2024 07/31/2025 2025 MONTH 07/31/25 BALANCE % BDGT GL NUMBER DESCRIPTION NORM (ABNORM) NORM (ABNORM) AMENDED BUDGET INCR (DECR) NORM (ABNORM) USED Fund 300 - DEBT SERVICE TOTAL REVENUES 4,733,390.40 4,559,474.00 4,559,474.00 0.00 o.oo 100.00 DODOO 4,654,707.09 4,116,289.45 4,724,654.00 0.00 608,364.55 87.12 TOTAL EXPENDITURES 4,654,707.09 4,116,289.45 4,724,654.00 0.00 608,364.55 87.12 Fund 300 - DEBT SERVICE : TOTAL REVENUES 4,733 ,390.40 4,559,474.00 4,559,474.00 0.00 0.00 100.00 TOTAL EXPENDITURES 4,654,707.09 4, 116,28 9.45 4,724 ,654. 00 0.00 608,364.55 87.12 NET OF REVENUES & EXPENDITURES 78,683.31 443,184.55 (165, 180 .00) 0.00 (608,364.55) 2 68. 30 Fund 400 - CAPITAL I MPROVEMENT 000 00 4,605,636.86 2,637,204.36 3,461,691.00 71,000.89 824,486.64 76.18 TOTAL REVENUES 4,605,636.86 2,637,204.36 3,461,691.00 71,000.89 824,486.64 76.18 00000 55,940.63 60,337.50 0.00 0.00 (60,337.50) 100.00 51400 - ADMINISTRATION 30,620.00 34,196.00 250,000.00 1,954.50 215,804. 00 13.68 51600 - BUILDINGS AND GROUNDS 0.00 o.oo 0 .oo 0.00 0.00 0.00 52101 - POLICE ADMINISTRATION 6,198.00 22 ,267.27 23,669.00 115. 00 1, 40 1.73 94.08 52200 - FIRE DEPARTMENT 14,911.00 908, 121.14 865,184.00 2,880.00 (42 ,937.14) 104.96 52300 - AMBULANCE 0.00 0.00 0.00 0.00 0.0 0 0.00 524 00 - BUILDING INSPECTOR 0 .00 36,447.00 39,000.00 0.00 2,553.00 93.45 53100 - PUBLIC WORI<S 1,796,635.76 399,543.45 2,651,000.00 12,648.57 2,251,456. 55 15.07 54600 - SENIOR CENTER 0.00 0.00 0.00 0.00 0.00 0.00 55110 - LIBRARY 0. 00 0.00 0.00 0.00 0.00 0.00 55111 - LIBRARY (OLD) 15 ,763.50 20,265.79 0.00 6,472.46 (20,265.79) 100.00 55200 - PARKS 410,863.41 400,597.80 473,838.00 170,687.76 73,240.20 84. 54 56900 - PLANNING 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL EXPENDITURES 2,330,932.30 1,881,775.95 4,3 02,691.00 194 ,758.29 2,420,915.05 43.73 Fund 400 - CAPITAL IMPROVEMENT: TOTAL REVENUES 4,605,636.86 2,637,204.36 3,461,691.00 71,000.89 824,486.64 76. 18 TOTAL EXPENDITURES 2,330,932.30 1,881 ,775.95 4,302,691.00 194,758.29 2,420,915.05 43.73 NET OF REVENUES & EXPENDITURES 2,274,704.56 755,428.41 (841,000.00) (123,757.40) (1,596,428.41) 89.83 Fund 401 - CAPITAL REVOLVING FUNDS 00000 1,028, 968.25 1,075,515.32 605,000.0 0 51,593.00 (470,515. 32) 177.77 TOTAL REVENUES 1,028,968.25 1,075,515.32 605,000.00 51,593.00 (470 ,515 .32) 177.77 51400 - ADMINISTRATION 106,637.26 9,562.50 12,500 .00 5, 302.00 2,937.50 76. 50 52101 - POLICE ADMINISTRATION 249,967.96 173,715.43 239,745.00 122,508.42 66,029.57 72.46 52200 - FI RE DEPARTMENT 0.00 0.00 0.00 0.00 0.00 0.00 52300 - AMBULANCE 20,073.55 245,863.72 180,400.00 0.00 (65,463.72) 136.29 53100 - PUBLIC WORKS 692,639.25 374,233.27 192,500.00 14,050 .00 (181,733.27) 194.41 54600 - SENIOR CENTER 0.00 0.00 o.oo 0.00 Page 15 of 20 0.00 0.00 55110 - LIBRARY 85,391.94 0.00 0.00 0.00 0.00 0 .00 08/07/2025 10:15 AM REVENUE AND EXPENDITURE REPORT FOR CITY OF VERONA Page : 6/9 User: brian.lamers DB: Verona PERIOD ENDING 07/31/2025 END BALANCE YTD BALANCE ACTIVITY FOR AVAILABLE 12/31/2024 07/31 /2 025 2025 MONTH 07/3 1/25 BALANCE % BDGT GL NOMBER DESCRIPTION NORM (ABNORM) NORM (ABNORM) AMENDED BUDGET INCR (DECR) NORM (ABNORM) USED Fund 401 - CAPITAL REVOLVING FUNDS 55200 - PARKS 193, 177.83 31,560.00 32,000.00 0.00 440.00 98.63 TOTAL EXPENDITURES 1,347,887.79 834,934.92 657,145 .00 141,860.42 (177,789.92) 12 7 .05 Fund 401 - CAPITAL REVOLVING FUNDS: TOTAL REVENUES 1,028,968.25 1,075,515.32 605, 000 .00 51,593.00 (470,515.32) 177. 77 TOTAL EXPENDITURES 1,347, 887 .79 834,934.92 657, 1 45. 00 141,860.42 (177, 789 .92) 127.05 NET OF REVENUES & EXPENDITURES (31 8,919.54) 240 ,580.40 (52 ,145.00) (90,267 .42) (292,725.40) 4 61. 37 Fund 404 - TI F 4 000 00 94 4 , 976 .52 23.05 0.00 23.05 (23 .05) 100 .00 TOTAL REVENUES 944,976.52 23.05 0.00 23.05 (23.05 ) 100.00 00000 1,659 ,504.13 0.00 0.00 0.00 0.00 0.00 TOTAL EXPENDITURES 1 ,659,504. 13 0.00 0.00 0.00 0.00 0.00 Fund 404 - TIF 4; TOTAL REVENUES 944,976 .52 23.05 0.00 23.05 (23. 05) 100.00 TOTAL EXPENDITURES 1,659,504 .13 0.00 0 .00 0.00 0.00 0.00 NET OF REVENUES & EXPENDITURES (714,527.61) 23.05 0.00 23. 05 (23. 05) 1 00 .00 Fund 406 - TIF 6 00000 0 .00 0.00 0 .00 D.00 0.00 0.00 TOTAL REVENUES 0.00 0.0 0 0.00 0 .00 0.00 0.0D 0000 0 0.00 0.0 0 0 .00 0.00 0.00 0.0D TOTAL EXPENDITURES 0 . 00 O.DD 0.00 0.00 0.00 0.00 Fund 406 - TIF 6: TOTAL REVENUES 0.00 0.00 0. 00 0.00 0.00 0.00 TOTAL EXPENDITURES 0.00 0.00 0.00 0.00 0.00 0.0 0 NET OF REVENUES & EXPENDITURES 0.00 0.00 0.00 0.00 0.00 0.00 Fund 408 - TIF 8 00000 778,361.96 2,216,342.67 2,197,380.00 3,264.00 (18,962.67) 100. 86 TOTAL REVENUES 778,361.96 2,216,342.67 2,197,380.00 3,264.00 (18,962.67) 1 00 .86 00000 745,628.80 1,397,963.86 1,933,100.00 2,985.34 535,136. 14 72.32 Page 16 of 20 08/07/2025 10:15 AM REVENUE AND EXPENDITURE REPORT FOR CITY OF VERONA Page: 7/9 User: brian.lamers DB : Verona PERIOD ENDING 07/31/2025 END BALANCE YTD BALANCE ACTIVITY FOR AVAILABLE 12/31/2024 07/31/2025 2025 MONTH 07/31/25 BALANCE % BDGT GL NUMBER DESCRIPTION NORM (ABNORM) NORM (ABNORM) AMENDED BUDGET INCR (DECR) NORM (ABNORM) USED Fund 408 - TIF 8 TOTAL EXPENDITURES 745,628.80 1,397,963.86 1,933,100.00 2,985.34 535,136.14 72.32 Fund 408 - TIF 8: TOTAL REVENUES 778,361.96 2,216,342.67 2, 197,380.00 3,264.00 (18 ,962.67) 100.86 TOTAL EXPENDITURES 745,628.80 1,397,963.86 1, 933,100.00 2,985.34 535,136.14 72.32 NET OF REVENUES & EXPENDITURES 32, 733 .16 818,378.81 264,280.00 278.66 {554,098.81) 309.66 Fund 409 - TIF 9 00000 2,394,560.33 7 8,142.04 1,82 6,658.00 0.00 1,748 ,515.96 4.28 TOTAL REVENUES 2,394,560.33 78,142.04 1,826,658.00 0.00 1,748, 515.96 4.28 00000 2,715,102.58 691,258.01 1 ,069,563.00 44,040.62 378,304.99 64.63 TOTAL EXPENDITURES 2,715, 1 02.58 691,258.01 1,069,563.00 44,040.62 378,304.99 64.63 Fund 409 - TIF 9: TOTAL REVENUES 2,394,560.33 78,142.0 4 1,826,658.00 0.00 1, 7 48,515.96 4.28 TOTAL EXPENDITURES 2,715,102.58 691,258.01 1,069,563.00 44,040.62 378,304.99 64.63 NET OF REVENUES & EXPENDITURES (320,542.25) (613,115.97) 757,095.00 (44,040.62) 1,370,210.97 80.98 Fund 410 - TIF 10 00000 154,589.38 140,713.60 140,006.00 621. 00 (707.60) 100. 51 TOTAL REVENUES 154, 589 .38 140 ,713.60 140,006.00 621. 00 (707.60) 100. 51 00000 1 42,574.79 7,503.18 1 41,040.00 1,833.33 133,536.82 5.32 TOTAL EXPENDITURES 142,574.79 7,503.18 141,040.00 1,833.33 133,536.82 5.32 Fund 410 - TIF 10: TOTAL REVENUES 154,589.38 140,713.60 140,006.00 621. 00 (707.60) 100.51 TOTAL EXPENDITURES 142,574.79 7,503. 18 141,040.00 1,833.33 133,536.82 5.32 NET OF REVENUES & EXPENDITURES 12,014.59 133,210.42 (1,034.00) (1,212.33) (134,244.42) 12,883.0 Fund 411 - TIF 11 00000 0.00 0.00 1,878,125.00 0.00 1,878, 125 .00 0.00 TOTAL REVENUES 0.00 0.00 1,878,125.00 0.00 1,878,125.00 0.00 00000 25,285.00 1,8 1 9.95 1,927,025.00 0.00 1,925,205.05 0.09 TOTAL EXPENDITURES 25,285.00 1,819.95 1 ,927,025.00 0.00 1,925,205.05 0.09 Page 17 of 20 08/07/2025 10:15 AM REVENUE AND EXPENDITURE REPORT FOR CITY OF VERONA Page: 8 /9 User : brian . l amers DB: Verona PERIOD ENDING 07/31/2025 END BALANCE YTD BALANCE ACTIVITY FOR AVAILABLE 12/31/2024 07/31/20 25 2025 MONTH 07/31 /25 BALANCE % BDGT GL NUMBER DESCRI P'l'ION NORM (ABNORM) NORM {ABNORM) AMENDED BUDGET lNCR ( DECR) NORM (AENORM) USED Fund 411 - TIF 11 Fund 411 - TI F 11: TOTAL REVENUES 0.00 0.00 1,878,125.00 0.00 1,878,125.00 0.00 TOTAL EXPENDI TURES 25,285.00 1,819 .95 1 ,927 ,025.00 0.00 1,925,205. 05 0.0 9 NET OF REVENUES & EXPENDITURES (25,285.00) (1,81 9 . 95) (48, 900.00) 0 . 00 {47, 080.05) 3.72 Fund 450 - LT ACCOUNT GROUP 00000 0.00 0.00 0.00 o.oo 0.00 0.00 TOTAL EXPENDITURES 0.00 0.00 0. 00 0.00 0.00 0.00 Fund 45 0 - LT ACCOUNT GROUP: TOTAL REVENUES o.oo 0.00 0.00 0.00 0.00 0 .00 TOTAL EXPENDITURES 0.00 0.00 0.00 0.00 0.00 0.00 NET OF REVENUES & EXPENDITURES 0.00 0.00 0. 00 0.00 -------- 0.00 0.00 Fund 500 - INSURANCE FUND 00000 287,833.10 317,702 .67 0 .00 0.00 (317 , 7 02.67) 100 . 00 TOTAL REVENUES 287 ,833.10 317,702.67 0.00 0.00 (317,702.67) 100.00 000 00 276,420. 1 0 293,204.15 0 . 00 29,519.52 {293,204.15) 100.00 TOTAL EXPENDITURES 276,420.10 293,204 .15 0.00 29,519.52 (293, 204.15) 1 00 . 00 Fund 500 - I NSURANCE FUND: TOTAL REVENUES 287,833.10 317,702.67 0 .00 0 .00 (317,702.67 ) 100. 00 TOTAL EXPENDITURES 276,420.10 293,204 .15 0.00 29,519.52 (293,204 .15 ) 100.00 NET OF REVENUES & EXPENDITURES 11,413.00 24 ,498.52 0.00 (29,519.52) (24 ,498.52) 100.0 0 Fund 600 - WATER UTILITY 00000 11,475,668.39 2,027,747.08 2,891,526.00 51,117. 43 863 , 77 8. 92 70 .13 TOTAL REVENUES 11,475,668.39 2,027 ,747 . 08 2, 891,526 .00 51,117.43 863,778 .92 7 0 .13 0000 0 799,757.43 753,674.85 790,516.00 0.00 36,841.15 95.34 56400 0.00 0.00 0.00 0.00 0.0 0 0.00 57400 - WATER OTHER OPERTING 0.00 881,894.45 0.00 131,848.32 (881,894.45) 100. 00 57620 - PUMPING 317,0 58. 90 1 59 ,248.95 206,499.00 35, 010.45 4 7, 250 . 0 5 77. 12 57640 - WATER TREATMENT 77,625 .50 48,353.22 61 , 349.00 8,647.57 12, 995 . 78 7 8 . 82 57660 - T & D-SUPERVISION & ENG 0 .00 9 42 .24 189,369 .00 942.24 1 88 , 426 . 76 0.50 57662 - T & D-LI NES EXPENSE 2,451.84 967 . 75 0.00 2 66. 4 9 (967. 75) 100.00 57672 - T & D- MAINT OF RESERVOIRS & STANDPIPES 119,882.77 103 ,761.4 5 103,500.00 101 ,711.53 (261. 45) 1 00.25 57673 - T & D- MAINT OF MAINS 57 ,775.06 72,984.86 135 ,000 .00 23,0 67.09 62 , 015. 14 54.06 57675 - T & D-MAINT OF SERVICES 42,590.52 1 9,644.0 2 23,70 0.00 6 ,510 . 54 4 ,055 . 98 82.89 57676 - T & D-MAINT OF METERS 108,07 0.67 59,289.50 69,000 . 00 10, 311.53 9,710.50 85.93 5767 7 - T & D-MAINT OF HYDRANTS 30,323.42 2 ,510.60 16,000.00 316. 19 13,489.4 0 15.69 57901 - CUSTOMER ACCTS EXP-METER READING 4,041.18 2,062 .91 27 , 550 .00 309.08 Page 18 of 20 25,487.09 7. 49 57903 - CUSTOMER ACCTS EXP-RECORDS & COLLECTIONS 52,404 . 50 33,201. 26 24 ,883.00 3,747.00 (8,318. 26) 133 . 43 08/07/2025 10;15 AM REVENUE AND EXPENDITURE REPORT FOR CITY OF VERONA Page: 9/9 User: brian. l amers DB: Verona PERIOD ENDING 07/31/2025 END BALANCE YTD BALANCE ACTIVITY FOR AVAILABLE 12/31/2024 07/31/2025 2025 MONTH 07/31/25 BALANCE % BDGT GL NUMBER DESCRIPTION NORM (ABNORM) NORM (ABNORM) AMENDED BUDGET INCR (DECR) NORM (ABNORM) USED Fund 600 - WATER UTILITY 57920 - ADMINISTRATION/GENERAL EXP 1,556,790.22 329,786.68 1,619,196.00 35,191.17 1,289,409.32 20.37 TOTAL EXPENDITURES 3,168,772.01 2,468,322.74 3,266,562.00 357,879.20 798,239.26 75. 56 Fund 600 - WATER UTI LITY: TOTAL REVENUES 11, 475 ,668.39 2,027,747.08 2,891,526.00 51,117.43 863,778.92 70 .13 TOTAL EXPENDITURES 3,168,772.01 2,468,322.74 3 ,266,562.00 357,879.20 798,239.26 75 . 56 NET OF REVENUES & EXPENDITURES 8,306,896.38 (440,575.66) (375,036.00) (306,761.77 ) 65,539.66 117.48 Fund 601 - SEWER UTILITY 00000 8,326,318.03 1,825,700.23 2,623,300.00 45,542.53 797,599.77 69.60 TOTAL REVENUES 8,326,318.03 1,825,700.23 2,623,300.00 45,542.53 797,599.77 69.60 00000 3,118,663.90 894,794.17 3,568,528.00 33,931. 10 2,673,733.83 25.07 TOTAL EXPENDITURES 3, 118,663.90 894, 79 4.17 3,568,528.00 33,931.10 2,673,733.83 25.07 Fund 601 - SEWER UTILITY: TOTAL REVENUES 8,326,3 18 .03 1,825,700.23 2,623,300.00 45,542.53 797,599.77 69.60 TOTAL EXPENDITURES 3,118,663.90 894,794.17 3,568,528.00 33,931.10 2,673,733.83 25.07 NET OF REVENUES & EXPENDITURES 5,207,654.13 930,906.06 (945,228.00) 11,611.43 (1,876 ,134.06) 98.48 Fund 602 - STORM WATER 00000 3,893,995.29 570,778.91 1,083,700.00 6,427.31 512,92 1.09 52.67 TOTAL REVENUES 3,893,995.29 570,778 .91 1,083,700 .00 6,427.31 5 12,921.09 52.67 00000 1,071,763.32 316,875.91 1 ,306,335.00 31,863.28 989,459.09 24. 26 TOTAL EXPENDITURES 1 ,071,763.32 316,875.91 1,306,335.00 31,863.28 989,459.09 24 . 26 Fund 602 - STORM WATER: TOTl\.L REVENUES 3,893,995.29 570,778.91 1,083,700.00 6,427.31 512,921.09 52.67 TOTAL EXPENDITURES 1,071,763.32 316,875.91 1,306,335.00 31,863.28 989,459.09 24 . 26 NET OF REVENUES & EXPENDITURES 2,822,231.97 253,903.00 (222,635.00) (25,43 5 .97 ) (476, 538.00) 114. 04 TOTAL REVENUES - ALL FUNDS 62,661,773.27 29,569,532.44 43,588, 2 77.00 1 ,512,265.46 1 4,01 8,744.56 67.84 TOTAL EXPENDITURES - ALL FUNDS 41,706,228.28 27,709,738.95 45,224,668.00 2,714,904.43 1 7,514,929.05 61.27 NET OF REVENUES & EXPENDITURES 20,955,544.99 1,859,793. 49 (1,636,391.00) (1,202,638.97) (3,496,184. 49) 113. 65 Page 19 of 20  City of Verona lnvs.slments July 31, 2025 BANK/ BROKER ACCOUNT NAME CUEOATE RATE BALANCE JUNE 30, 20.2S BALANCE JULY 3t , 2015 DANA Inv/Schwab Federal Fairm Credit Bank 712912017 5.000% 1,000,502.00 DANA Inv/Schwab federal Home Ln 7130/2025 1,125% 997,375.00 DANA Inv/Schwab Fede roc1I Home Ln 8/12/2025 1 250"/. 996,308.00 999,008.00 DANA lnv/Schwsb FHLMG 840718-Mortgage 71112042 6 869% 50,340.42 48,205.36 DANA lnv/Schwob FMLMC ~0244-Mortg•ge 5nrza4J 6670% 28,218.18 28,225.44 DANA 1nv/Schwab FMlMC 64091 G-MDrtgage 71112043 6.561% 94,125.58 9 0,384,08 DANA Inv/Schwab F'MLMC 840240-Mottgage 10(111843 6fi0!1% 182,820.69 157,048.56 DANA Inv/Schwab FMLMC 840594•Morl911gc \11112043 7.021% 28,922.73 ZB,849.56 DANA Inv/Schwab FMLMC ll40798-Morlgage 10/112044 6.51A% 35,411.55 3',609.71 DANA lnv/Schw~b FMLMC 849504-Morlgagc • 1011120 4 6B97% 31,981.43 31,825.47 DANA lnvJSchwab fHLMC 640!551~Mortgage 31112045 6.780¼ 21,366.81 2 1,265.58 DANA Inv/Schwab FHl.MC 640899-Mortgege- \11112045 15 704% 105,038.27 104,052.19 DANA Inv/Schwab FHLMC 840752-MOr!ll"ll• 12/1/2045 6 517% 38,553.56 35,414.92 DANA ltivJSchwab FHLMC 2873.ee~Mortgas,e 111/2046 6991% 91,845.09 89,844.01 OANA Inv/Schwab FHLMC 841375-Mortga-ge 1/112046 6621% 366,478.10 362,382.41 DANA Inv/Schwab FHLMC S40912•Mortgage 3/112&46 6.7'7% 53,652.19 52,446.07 DANA Inv/Schwab FHlMC 6409314\lortoogo l 111/2046 6.,560% 97,105.05 9 5,535.94 DANA lnvfSchwab FHLMC 841024-Mortga,ge 2/112047 6,593% 9D,60DA1 90,266..45 DANA Inv/Schwab FHlMC 841053-Mortg~e 2/112047 6.788% 138,162,13 120,262.66 DANA Inv/Schwab FHLMC 841 OH-Mortgage B/111947 6.695% 141,630.39 139,022.94 DANA Inv/Schwab FHl MC 84 lfi38-Mortgege 0/1/1047 6ti64¾ 579,542.17 572,921.38 DANA lnv/Sr;,hwab FHLMC 841802-Mortgagc 11/1n5i47 4824% 773,7 34.A7 75 9,899.32 DANA lnvJSchwab FHLMC 841806-Mortgage 11/IM947 5.044% 821,256.08 800,70D.11 DANA lnv/Sc/iwab FHLMC 841228-Mortgage 11111948 6.651% 287,773.89 282,348.38 DANA lnv/Schwsb FHlMC 840S7B•Mortgage 511/2048 6.712% 77,5-49,02 76,805.44 DANA Inv/Schwab FHLMC S41042-Mortgege 511/20-Ut 6609% 112,5!9.48 112,065.60 DANA lnv/Scliwab FHLMC 84-1076-M ortgagc 11/11204!1 3.005% 977,335.47 96-,263.05 DANA lnv/Scliw•l> FHLMC 841281-M ort,ioge 5/112049 6673% 286,472.37 2 80,594.7& DANA Inv/Schwab FHLMC 841876-Mortg11ge 121112049 4.592% 635,618.89 616J681.06 DANA lnv/Sc/iwab FHLMC 841775-Mortgage 1}1'2051 5.4'20o/o 813,958.23 801,030.35 DANA lnv/Scl!wab FHlMC '41077-Mortgogo 111/2051 S355% 716,815.91 896,409.58 DANA Inv/Schwab FHLMC 841631-1.lorta•oe 81112052 3.065% 812,161.61 806,455.19 DANA Inv/Schwab FNMA PL BM155,4-P.lortgage 6/112.042 6643% 43,815.91 4 1,267.69 DANA lnv/Sc/iwab FNMA PLAT2.070-Mortgage 4/112043 6,557% 155,961.57 151,431 .90 DANA lnv/Sc/iwab FNMA PL. BM7029-Mortgage 71112043 6744% 486,548.40 48 1,961.28 DANA lnv/Scl!wab 1-NMA PL BM01087-Mortgage 12)1/20,$3 s.sm, 21,238.W 21,119.27 DANA lnv/Scl1wab FHLMC BM40'4.1•Mortg1gc 5/1/2.044 6,73e~"' 561354.79 54,322 17 DANA Inv/Schwab FNMA Pl BM143'3-Mor1gage 71111.044 6.4B7% 18,381.35 17,937.52 DANA Inv/Schwab FNMA Pl BM6204-•Mor1gago 9/112044 6432% 116,800.11 115,791.62 DANA lnv/Sc/iwab FNMA PL BM6372•Mortgou, 10/1/20« 6.602o/. 203,641.!1 201,185 .54 DANA Inv/Schwab FNMA. PL aMso,1-MortgE1ge 311/20<6 6.518% 151,9-19.06 151,380.08 DANA lnv~llwab ~NMA. Pl B.M6760-Mortgage 81112046 6,617% 21B,182.59 213,194.63 DANA Inv/Schwab FNMA Pl BM545Hlortg>ge 41112047 6.• 81% 42,058.80 41,794,28 DANA Inv/Schwab FNMA PL BM'5214-Mortgage 4/112047 6.$38% 1i9,4JU 2 1601760.73 DANA Inv/Scliwab FNMA PL BM6J73-Mcirtgagc 411/2047 s.s1,•"' 176,823.61 164,693.39 DANA lnv/Sehwal> FNMA PL BM6374•Mortgoge 5/1/2041 S.592"/4 60,580.72 60,242.02 DANA Inv/Schwab f'NIM.P\..8M&t01-Moc1g11ga &11/2047 6519% 51,961.35 51,437.75 DANA lnv/Sc/iwab FNMA Pl BM6056-),tortgage 9/1'2048 6535¾, 391576.07 39,462.68 DANA lnv/Sc/iwab FNMA PL BMC42G-Mort!}flg~ 911/2048 6.641 % 112,663.78 110,242.54 DANA Inv/Schwab FNMA PL-BM6490-Mortgage 211/20'0 6.337% 159,785.'i9 156,593.49 DANA lnv/Schwal> FNMA PL-8M7370-Mortg~t 3/1/2050 6,520% 569,3Bl..84l 519,824.75 DANA Inv/Schwab FNMA PL -aM7306-Mortgage 4/112050 6.553% 532,232.11 526,141.29 DANA Inv/Schwab FNMA Pl -BM7514--Mortgage 411/2050 ~ .587% 884,772.80 667,044.90 DANA Inv/Schwab FNMA PL-8M7464-Mort9,ge 511/2050 5_4gJ% 617,670.32 600,250.58 DANA Inv/Schwab ff'IIMA PL -BMn72-Mortgage 11/1/2050 4.488% 785,61U4 776,506.05 DANA Inv/Schwab FNMA. Pl -BM7710-Mortga.g• 11/112050 5Ji32% 726,029.46 684,257.45 DANA Inv/Schwab FNMA PL -BM76•1-Mortgage 111/2051 4,21'\.% 9'6,042.49 971,707.74 DANA Inv/Schwab GNMA MA5037-Mortgage 8/1.0/Z04JI 5.500% 76,62.4 .08 75,647.32 DANA Inv/Schwab GNMA 784807-ldortgage: 8/20J2049 4.709% 12,1a1.2a 11,773.90 DANA Inv/Schwab Gt-JMA. 5037~1ortgage 212<l/21l48 4912"/4 718,846.63 707,629.38 DANA Inv/Schwab Small Business loan I125120U, 5900% 28,840.72 25,985.76 DANA Inv/Schwab Smalt Buslnes:s loiitl 2125t203t 6 825% 133,347.07 131,504.55 DANA rnvfSchwab srnan Business Loan 3/2512031 7.375% 258,226.40 254,871.61 DANA Inv~hweb small Busine155 Leia" 5125/2040 6,0D0% 406,78U6 404,508.34 DANA Inv/Schwab Sm~II BuMC-5S LoaJ'I 11125/2042 6.000% 82,229.09 81,818.66 DANA lnv/Schw•b Smell Bu•lne.s.s Loan 112"'20<3 5,500% 79,645.54 62,063.22 DANA Inv/Schwab Small &le;inosa loan 312511846 6.075% 301,UB.99 276,:526.20 DANA Inv/Schwab FHtMCMoflslll• "712712026 J.840"/4 198,374.20 199,301,60 DANA Inv/Schwab FHLMC Mortgage 10/4/2020 3 700-/2 142,820.22 142,6'9.70 DANA Inv/Schwab FHLMC Mortg;1gc 10/4/2023 S 000"/4 135J042.80 DANA Inv/Schwab FHLMC Mortgage aI2a.1:202s 4,05D% 174,902.18 17',972,70 DANA Inv/Schwab FHLMC Mortgage 7}1812028 4.580% 199,809.20 200,033.00 DANA lav/Scllwab VISAINC 411512027 1,!300% 163,986.70 163,825.60 DANA Inv/Schwab CME. Groop loe 61I5120.2B 3,750% 188,586.40 118,010.70 DANA Inv/Schwab Blaekroek .,c 4/3012029 3250% 223,132.20 222,814.80 DANA Inv/Schwab Apple Inc S/1112027 3,.200% 226,805.30 226,559.20 DANA Inv/Schwab Johni!ion & Johrl!Uln 311/2026 2450% 91,798.00 98,856.00 DANA Inv/Schwab AccenhJre Capital Inc 10/412029 4,050% 138,832.40 138,390.84 DANA Inv/Schwab Mit:rt1SOft Corp 6/1512027 3 400",{, 178,437.60 178,149.60 DANA Inv/Schwab Procter & G.1!1mble 1129/2029 4 350% 182,248.20 18 1,584.20 DANA Inv/Schwab Nvidia Ccirp 411/2030 2 850% 145.A02.1S DANA Inv/Schwab ~ II BK Recon & Develop-Green Bond 7/2.SJ2030 4,0000.4 166,111.44 165,023.43 DANA InvfSchwab Intl BK Recon & Develop..SU$bm Bond 1'1011931 4.000% 165,714.62 16','64.25 DANA Inv/Schweb Money Markel NA 0.000% 372,592.19 2 ,919,872.48 LGIP 01 GENERAL NA 4,36D% 13,706,248.40 12,564,2B3.9S LGIP 02 Cemetery Food NA 4,360% 296,010.79 297,107.77 l a ke Ridge Benk IC$ Shadow Aecoont NA 4.410% 3,825,438.23 4,800,859.40 Capitol Bank PUBLIC FUNDS ACCOUNT NA 4.500% 1,951,203.14 1 ,958,51 1.33 Total Investments Is 43,484,109.10 I s 43,44a.114.51 I • Thess lnve.ttments. a~ Mortgages, I.hey will go down each month as Principal is paid and will be reinvested again. Page 20 of 20