Loading...
2022.07 Monthly Budget ReportO R ORCHARD MONTHLY BUDGET FINANCIAL STATUS UPDATE To: Mayor and Council members From: Noah Crocker, Finance Director Period: July 2022 OVERVIEW: The Finance Department is committed to providing clear information to the Mayor, Council, and staff regarding the budget status of the City. We have prepared the following reports to keep you up to date on the current budget status of the City. 1) Budget Report 2) Detail Fund Summary Report BUDGET REPORT: The Budget report will first provide Operational Funds and follow up with Capital Projects Funds. This report does not include beginning fund balance. This report is designed to provide a high-level view of each fund reviewing total revenues and expenses. The report does provide expense information by department. The goal of the City is to pay all current budget year expenses with current budget year revenues. We are not quite there yet, and this will show in the Surplus (Deficit) line at the end of each fund. We expect that future budget cycles will smooth out revenues and expenditures. The Budget Report provides information on current revenues and expenditures by fund including the following: • The original budgeted amount. • Current budget which would reflect any amendments that have been made. • Period activity which details the revenue and expense activity for the period in which the report was run. • Fiscal activity will provide the year-to-date expense and revenue amounts. • Variance Shows the difference between budgeted and actual. • Percent remaining is the amount still needed to reach the budgeted amount. CASH AND INVESTMENT FUND SUMMARY The Cash and Investment Fund Summary provides information on current total cash & investment balances by Fund. POINTS OF INTEREST: Current Expense Fund 001 — The Current Expense Fund is used for the general governmental functions of the City. As of July 31st 2022, 81% of budgeted revenues were received. To date revenue is trending higher than expected. Of particular importance, the City received $1,410,539 from the American Rescue Plan Coronavirus State & Local Fiscal Recovery Funds (SLFRF) identified in Intergovernmental Revenue. The table provides budget versus actual (YTD) data by source of revenue. 2022 % of 2022 Current Revenue Source Original BudgetBudget 2022 YTD Budget Property Tax 1,995,500 2,068,300 1,117, 759 54.04% Sales Tax 5,340,000 5,340,000 4,260,242 79.78% Other Taxes 2,093,100 2,093,100 1,470,843 70.27% Total Taxes 9,428,600 9,501,400 6,848,844 72.08% Licenses & Permits 481,200 481,200 1,101,594 228.93% Intergovernmental Revenue 326,700 2,352,239 1,608,157 68.37% Charges for Goods & Services 389,500 449,500 750,232 166.90% Fines & Penalties 163,100 163,100 70,611 43.29% Misc Revenues 177,100 177,100 141,979 80.17% Non -Revenues - - (1,035) #DIV/0! Capital Contributions - - - pr #DIV/0! REVENUE TOTALS 10,966,200 13,124,539 10,520,381 80.16% SALES TAX REVENUES SUMMARY 2,997 668,890 127,956 799,844 111,567 25,965 114,653 6,790 23,518 (144) 1 1.082.194 1 • Total 2022 Budget: $5,340,000 • Total 2022 YTD Actuals: $4,260,242 • Year -to -Date Actual revenue collected is 10% higher when compared to Prior Year -to Date Actuals • Year -to -Date Actual revenue collected is 43% higher when compared to Year -to Date Budgeted The following tables provide additional sales tax information: Table 1: shows revenue received by month over a three-year period. Monthly Sales Tax -Three Year Comparison s00,000 700,000 ■ i 600,000 02020 Actual ■ 2021 YTD Actua I S00,000 14 02022 YTD Actual 400,000 300,000 200,000 100,000 0 0� bQ ae oae� eGefi Table 2: provides current data for sales tax revenue collected Year-to-date. $800,000 Sales Tax Revenues $700,000 ActuaIs 2022 $600,000 $500,000 $400,000 Budget 2022 $300,000 $200,000 $100,000 �aP 4, p� owe eye 4 p Real Estate Excise Tax (REET) Fund 109 and Impact Mitigation Fee Fund 111 The City's Real Estate Excise Tax receipts fluctuate monthly. July 2022 receipts are lower than July 2021 by 50%. The table below shows balances through July for REET 1 & 2 and Impact fees. These restricted funds are used as a local funding source for capital projects that have been documented in the City's comprehensive plans. REET funds are also used for debt payments. The table above shows 2022 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 July 2022 are as follows: o Parks $21,443 o Transportation $109,238 o School District Impact $35,994 REET revenues received in July: o REET 1 $124,961 o REET 2 $124,961 Capital Construction Fund 302 —The McCormick Woods Splash Pad Retrofit is in design with Murray Smith working on completing the engineering to be ad ready. Rice Fergus Miller is currently working on the City Hall design. Street Capital Construction Fund 304—Bay Street Pedestrian Path right of way efforts continue. The City has contracted with Skillings Inc for Design and Right of Way Services for the Bethel -Lincoln Round -About project. Design for the project is in progress. ENTERPRISE/UTILITY FUNDS: Water operation - Water operations budgeted revenue in the amount of $3,344,600 for 2022. Through July, the city has received $2,027,947 or —61% of the budgeted revenues. Revenues for the water utility, in winter and spring, are typically lower with larger monthly revenues received during the warmer summer and fall months. Water Operations expended $1,608,207 through July representing —60% of the 2022 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 2022 budget includes $594,755 for transfers. No transfers were executed this month. 500,000 450,000 400,000 350,000 300,000 250,000 200,000 150,000 100,000 50,000 Water Service Payments Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov ❑ec ■ 2020 ■ 2021 ■ 2022 Sewer operation - $5,418,900 is budgeted for Sewer Operational Revenues for 2022. Through the month of July $3,754,348 was received representing —70% of the 2022 budgeted revenues. Sewer Operations expended $2,135,968 through July representing —48% of the 2022 budget. The sewer operational expense budget includes transfers which occur throughout the year. The City manages its transfers according to policy goals, cashflow needs, and realized expenses for sewer capital projects, stabilization targets, and debt service payments. The 2022 budget includes $989,844 for transfers. A total of $62,919 was transferred to fund 433 for the Marina Pump Station project this month. 600,000 500,000 400,000 300,000 200,000 100,000 Sewer Service Payments Jan Feb Mar Apr May Jun ■ 2020 ■ 2021 ■ 2022 Jul Aug Sep Oct Nov ❑ec Storm Drainage operations- $1,667,000 is budgeted for Storm Operational Revenues for 2022. As of the end of July the Storm Drainage utility has received $1,175,841 or —71% of its annual budgeted revenue. Storm Drainage Operations expended $795,508 through July representing —50% of the 2022 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 2022 budget includes $368,000 for transfers. No transfers were executed this month Storm Drainage Payments 165,000 160,000 155,000 150,000 145,000 140,000 135,000 130,000 125,000 120,000 115,000 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■ 2020 ■ 2021 ■ 2022 Budget Report OPERATIONS BUDGET Departmen Fund: 001-Current Expense Revenue 00 - Revenues Expense 01- Finance 02 - Court 03 - Law Enforcement 04 - Community Development 05 - Public Works 06 - Miscellaneous 07 - Administration Original Current Total Budget Total Budget For Fiscal: 2022 Period Ending: 07/31/2022 Group Summary Variance Period Fiscal Favorable Percent Activity Activity (Unfavorable) Remaining 10,966,200.00 13,124,539.00 1,082,194.06 10,520,381.26-2,604,157.74 19.84 % Revenue Total: 10,966,200.00 13,124,539.00 1,082,194.06 10,520,381.26 -2,604,157.74 19.84 % 904,035.24 1,096,414.53 53,733.16 446,121.13 650,293.40 59.31 % 794,231.21 849,492.77 35,796.30 268,545.90 580,946.87 68.39 % 5,282,255.09 5,697,011.84 444,689.41 2,585,954.74 3,111,057.10 54.61 % 1,627,716.77 3,144,092.10 168,922.37 1,163,908.53 1,980,183.57 62.98 % 1,495,384.20 1,589,381.27 141,189.02 797,186.80 792,194.47 49.84 % 502,800.00 5,045,878.00 246.00 2,102,421.00 2,943,457.00 58.33 % 1,566,377.49 1,708,054.91 95,418.60 814,170.28 893,884.63 52.33 % Expense Total: 12,172,800.00 19,130,325.42 939,994.86 8,178,308.38 10,952,017.04 57.25 % Fund: 001 - Current Expense Surplus (Deficit): -1,206,600.00 -6,005,786.42 142,199.20 2,342,072.88 8,347,859.30 139.00 % Fund: 002 - City Street Fund Revenue 00 - Revenues 2,112,400.00 3,601,600.00 58,425.89 2,760,885.12 -840,714.88 23.34 % Revenue Total: 2,112,400.00 3,601,600.00 58,425.89 2,760,885.12 -840,714.88 23.34 % Expense 05 - Public Works 2,400,500.00 4,762,205.20 383,487.30 1,216,289.36 3,545,915.84 74.46 % Expense Total: 2,400,500.00 4,762,205.20 383,487.30 1,216,289.36 3,545,915.84 74.46 % Fund: 002 - City Street Fund Surplus (Deficit): -288,100.00 -1,160,605.20 -325,061.41 1,544,595.76 2,705,200.96 233.09 % Fund: 003-Stabilization Fund Revenue 00 - Revenues 0.00 360,000.00 3,673.85 369,323.27 9,323.27 2.59 % Revenue Total: 0.00 360,000.00 3,673.85 369,323.27 9,323.27 2.59% Fund: 003 - Stabilization Fund Total: 0.00 360,000.00 3,673.85 369,323.27 9,323.27 2.59 % Fund: 103 - Criminal Justice Revenue 00 - Revenues 247,100.00 247,100.00 50,215.83 259,942.62 12,842.62 5.20 % Revenue Total: 247,100.00 247,100.00 50,215.83 259,942.62 12,842.62 5.20% Expense 03 - Law Enforcement 292,000.00 419,525.00 12,502.08 74,988.07 344,536.93 82.13 % Expense Total: 292,000.00 419,525.00 12,502.08 74,988.07 344,536.93 82.13 % Fund: 103 - Criminal Justice Surplus (Deficit): -44,900.00 -172,425.00 37,713.75 184,954.55 357,379.55 207.27 % Fund: 104 - Special Investigative Unit Revenue 00 - Revenues 4,000.00 4,000.00 94.15 398.86 -3,601.14 90.03 % Revenue Total: 4,000.00 4,000.00 94.15 398.86 -3,601.14 90.03 % Expense 03 - Law Enforcement 4,000.00 4,000.00 0.00 0.00 4,000.00 100.00 % Expense Total: 4,000.00 4,000.00 0.00 0.00 4,000.00 100.00 % Fund: 104 - Special Investigative Unit Surplus (Deficit): 0.00 0.00 94.15 398.86 398.86 0.00 % Fund: 107 - Community Events Revenue 00 - Revenues 100,000.00 100,000.00 16,167.68 83,235.86 -16,764.14 16.76 % Revenue Total: 100,000.00 100,000.00 16,167.68 83,235.86 -16,764.14 16.76 % Expense 07-Administration 96,800.00 131,778.00 5,245.58 17,189.44 114,588.56 86.96% Expense Total: 96,800.00 131,778.00 5,245.58 17,189.44 114,588.56 86.96 % Fund: 107 - Community Events Surplus (Deficit): 3,200.00 -31,778.00 10,922.10 66,046.42 97,824.42 307.84 % 8/25/2022 9:30:38 AM Page 14 of 17 Budget Report Departmen... Fund: 108 - Paths & Trails Revenue 00 - Revenues For Fiscal: 2022 Period Ending: 07/31/2022 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 1,000.00 1,000.00 122.12 754.99-245.01 24.50 % Revenue Total: 1,000.00 1,000.00 122.12 754.99-245.01 24.50 % Fund: 108 - Paths & Trails Total: 1,000.00 1,000.00 122.12 754.99-245.01 24.50 % Fund: 109 - Real Estate Excise Tax Revenue 00 - Revenues Revenue Total: Expense 06 - Miscellaneous Expense Total: Fund: 109 - Real Estate Excise Tax Surplus (Deficit): Fund: 111 - Impact Mitigation Fee Revenue 00 - Revenues Revenue Total: Expense 06 - Miscellaneous Expense Total: Fund: 111 - Impact Mitigation Fee Surplus (Deficit): Fund: 206 - Bond Redemption Fund Revenue 00 - Revenues Revenue Total: Expense 06 - Miscellaneous Expense Total: Fund: 206 - Bond Redemption Fund Surplus (Deficit): Fund: 411 - Water Operating Revenue 00 - Revenues Revenue Total: Expense 05 - Public Works 06 - Miscellaneous 700,000.00 700,000.00 254,833.48 1,189,169.01 700,000.00 700,000.00 254,833.48 1,189,169.01 298,300.00 2,759,300.00 1,439,761.22 1,773,246.69 489,169.01 69.88 % 489,169.01 69.88 % 986,053.31 35.74 % 298,300.00 2,759,300.00 1,439,761.22 1,773,246.69 986,053.31 35.74 % 401,700.00 -2,059,300.00 -1,184,927.74 -584,077.68 1,475,222.32 71.64 % 140,000.00 1,140,000.00 171,961.77 1,793,971.49 653,971.49 57.37 % 140,000.00 1,140,000.00 171,961.77 1,793,971.49 653,971.49 57.37 % 250,000.00 2,145,000.00 86,545.69 225,485.36 1,919,514.64 89.49 % 250,000.00 2,145,000.00 86,545.69 225,485.36 1,919,514.64 89.49 % -110,000.00 -1,005,000.00 85,416.08 1,568,486.13 2,573,486.13 256.07 % 298,300.00 298,300.00 0.00 30,430.40 -267,869.60 89.80 % 298,300.00 298,300.00 0.00 30,430.40 -267,869.60 89.80 % 298,300.00 298,300.00 0.00 30,430.40 267,869.60 89.80 % 298,300.00 298,300.00 0.00 30,430.40 267,869.60 89.80 % 0.00 0.00 0.00 0.00 0.00 0.00 % 3,344,600.00 3,344,600.00 279,967.64 2,032,544.77 -1,312,055.23 39.23 % 3,344,600.00 3,344,600.00 279,967.64 2,032,544.77 -1,312,055.23 39.23 % 2,486,600.00 2,694,082.11 217,801.84 1,608,207.68 1,085,874.43 40.31 % 563,500.00 594,755.00 0.00 298,755.00 296,000.00 49.77 % Expense Total: 3,050,100.00 3,288,837.11 217,801.84 1,906,962.68 1,381,874.43 42.02 % Fund: 411 - Water Operating Surplus (Deficit): 294,500.00 55,762.89 62,165.80 125,582.09 69,819.20 -125.21 % Fund: 412 - Water Stabilization Revenue 00 - Revenues 263,500.00 294,755.00 1,307.58 297,794.94 3,039.94 1.03 % Revenue Total: 263,500.00 294,755.00 1,307.58 297,794.94 3,039.94 1.03 % Fund: 412 - Water Stabilization Total: 263,500.00 294,755.00 1,307.58 297,794.94 3,039.94 1.03 % Fund: 414 - Water Debt Service Revenue 00 - Revenues 355,125.00 386,225.00 0.00 42,575.00 -343,650.00 88.98 % Revenue Total: 355,125.00 386,225.00 0.00 42,575.00 -343,650.00 88.98 % Expense 06 - Miscellaneous 355,125.00 408,390.00 0.00 42,575.00 365,815.00 89.57 % Expense Total: 355,125.00 408,390.00 0.00 42,575.00 365,815.00 89.57 % Fund: 414 - Water Debt Service Surplus (Deficit): 0.00 -22,165.00 0.00 0.00 22,165.00 100.00 % 8/25/2022 9:30:38 AM Page 15 of 17 Budget Report For Fiscal: 2022 Period Ending: 07/31/2022 Variance Original Current Period Fiscal Favorable Percent Departmen... Total Budget Total Budget Activity Activity (Unfavorable) Remaining Fund: 421 - Storm Drainage Utility Revenue 00 - Revenues 1,667,000.00 1,667,000.00 163,572.66 1,178,818.92 -488,181.08 29.29 Revenue Total: 1,667,000.00 1,667,000.00 163,572.66 1,178,818.92 -488,181.08 29.29 % Expense 05 - Public Works 1,379,650.00 1,618,382.68 132,353.32 795,508.00 822,874.68 50.85 % 06 - Miscellaneous 341,250.00 368,000.00 0.00 223,710.92 144,289.08 39.21 % Expense Total: 1,720,900.00 1,986,382.68 132,353.32 1,019,218.92 967,163.76 48.69 % Fund: 421 - Storm Drainage Utility Surplus (Deficit): -53,900.00 -319,382.68 31,219.34 159,600.00 478,982.68 149.97 % Fund: 422 - Storm Drainage Stabilization Revenue 00 - Revenues 164,100.00 190,850.00 734.65 192,484.13 1,634.13 0.86 % Revenue Total: 164,100.00 190,850.00 734.65 192,484.13 1,634.13 0.86 % Fund: 422 - Storm Drainage Stabilization Total: 164,100.00 190,850.00 734.65 192,484.13 1,634.13 0.86 % Fund: 424 - Storm Drainage Debt Service Revenue 00 - Revenues 177,200.00 177,200.00 0.00 32,910.92 -144,289.08 81.43 % Revenue Total: 177,200.00 177,200.00 0.00 32,910.92 -144,289.08 81.43 % Expense 06 - Miscellaneous 177,200.00 177,200.00 0.00 32,910.92 144,289.08 81.43 % Expense Total: 177,200.00 177,200.00 0.00 32,910.92 144,289.08 81.43 % Fund: 424 - Storm Drainage Debt Service Surplus (Deficit): 0.00 0.00 0.00 0.00 0.00 0.00 % Fund: 431 - Sewer Operating Revenue 00 - Revenues 5,418,900.00 5,418,900.00 455,665.62 3,759,019.85 -1,659,880.15 30.63 % Revenue Total: 5,418,900.00 5,418,900.00 455,665.62 3,759,019.85 -1,659,880.15 30.63 % Expense 05 - Public Works 3,564,481.00 4,484,154.67 291,044.27 2,135,968.13 2,348,186.54 52.37 % 06 - Miscellaneous 928,719.00 989,844.00 62,919.53 498,194.53 491,649.47 49.67 % Expense Total: 4,493,200.00 5,473,998.67 353,963.80 2,634,162.66 2,839,836.01 51.88 % Fund: 431 - Sewer Operating Surplus (Deficit): 925,700.00 -55,098.67 101,701.82 1,124,857.19 1,179,955.86 2,141.53 % Fund: 432 - Sewer Stabilization Revenue 00 - Revenues 374,150.00 435,275.00 1,956.86 439,829.93 4,554.93 1.05 % Revenue Total: 374,150.00 435,275.00 1,956.86 439,829.93 4,554.93 1.05 % Fund: 432 - Sewer Stabilization Total: 374,150.00 435,275.00 1,956.86 439,829.93 4,554.93 1.05 % Fund: 434 - Sewer Debt Service Revenue 00 - Revenues 275,000.00 275,000.00 756.18 276,572.01 1,572.01 0.57 % Revenue Total: 275,000.00 275,000.00 756.18 276,572.01 1,572.01 0.57 % Fund: 434 - Sewer Debt Service Total: 275,000.00 275,000.00 756.18 276,572.01 1,572.01 0.57 % Fund: 500 - Equipment Rental and Revolving Revenue 00 - Revenues 685,500.00 1,106,300.00 50,568.45 348,590.02 -757,709.98 68.49 % Revenue Total: 685,500.00 1,106,300.00 50,568.45 348,590.02 -757,709.98 68.49 % Expense 10 - ER&R 484,000.00 904,800.00 196,291.20 555,611.89 349,188.11 38.59 % Expense Total: 484,000.00 904,800.00 196,291.20 555,611.89 349,188.11 38.59 % Fund: 500 - Equipment Rental and Revolving Surplus (Deficit): 201,500.00 201,500.00 -145,722.75 -207,021.87 -408,521.87 202.74 % Report Surplus (Deficit): 1,200,850.00 -9,017,398.08 -1,175,728.42 7,902,253.60 16,919,651.68 187.63 % 8/25/2022 9:30:38 AM Page 16 of 17 CAPITAL BUDGET Budget Report RV City of Port Orchard Group Summary ORCHARDFor Fiscal: 2022 Period Ending: 07/31/2022 Variance Original Current Period Fiscal Favorable Percent Account Typ... Total Budget Total Budget Activity Activity (Unfavorable) Remaining Fund: 302 - Capital Construction Revenue 0.00 898,000.00 6,609.69 108,934.69 -789,065.31 87.87 % Expense 0.00 898,000.00 6,349.80 85,436.47 812,563.53 90.49 % Fund: 302 - Capital Construction Surplus (Deficit): 0.00 0.00 259.89 23,498.22 23,498.22 0.00 % Fund: 304 - Street Capital Projects Revenue 690,000.00 7,202,587.00 1,436,092.02 3,157,998.63 -4,044,588.37 56.15 % Expense 1,006,000.00 7,774,750.00 1,434,735.40 2,505,863.01 5,268,886.99 67.77 % Fund: 304 - Street Capital Projects Surplus (Deficit): -316,000.00 -572,163.00 1,356.62 652,135.62 1,224,298.62 213.98 % Fund: 413 - Water Capital Revenue 969,100.00 2,519,100.00 76,934.86 1,023,288.15 -1,495,811.85 59.38 % Expense 55,200.00 1,236,300.00 39,945.88 171,855.98 1,064,444.02 86.10 % Fund: 413 - Water Capital Surplus (Deficit): 913,900.00 1,282,800.00 36,988.98 851,432.17 -431,367.83 33.63 % Fund: 423 - Storm Drainage Capital Facil Revenue 0.00 0.00 129.34 328.27 328.27 0.00 % Fund: 423 - Storm Drainage Capital Facil Total: 0.00 0.00 129.34 328.27 328.27 0.00 % Fund: 433 - Sewer Capital Revenue 6,300,800.00 19,321,878.00 491,399.94 2,145,030.72 -17,176,847.28 88.90 % Expense 6,300,800.00 12,350,700.00 73,263.75 647,232.16 11,703,467.84 94.76 % Fund: 433 - Sewer Capital Surplus (Deficit): 0.00 6,971,178.00 418,136.19 1,497,798.56 -5,473,379.44 78.51 % Report Surplus (Deficit): 597,900.00 7,681,815.00 456,871.02 3,025,192.84 -4,656,622.16 60.62 % 8/25/2022 9:30:59 AM Page 1 of 2 Detail Report CASH & INVESTMENTS Date Range: 07/01/2022 - 07/31/2022 Fund Summary Fund Beginning Balance Total Activity Ending Balance 001 - Current Expense 12,987,719.25 142,199.20 13,129,918.45 002 - City Street Fund 3,942,960.34 -325,061.41 3,617,898.93 003 - Stabilization Fund 2,701,766.04 3,678.21 2,705,444.25 103 - Criminal Justice 705,051.13 37,713.75 742,764.88 104 - Special Investigative Unit 97,286.23 94.15 97,380.38 107 - Community Events 323,166.13 10,922.10 334,088.23 108 - Paths & Trails 12,937.45 122.12 13,059.57 109 - Real Estate Excise Tax 5,897,870.76 -1,184,927.74 4,712,943.02 111 - Impact Mitigation Fee 4,803,469.95 85,416.08 4,888,886.03 206 - Bond Redemption Fund 0.00 0.00 0.00 302 - Capital Construction 243,392.41 259.89 243,652.30 304 - Street Capital Projects 2,371,665.09 1,356.62 2,373,021.71 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,768,961.27 62,165.80 3,831,127.07 412 -Water Stabilization 952,465.76 1,307.58 953,773.34 413 - Water Capital 7,143,618.24 36,988.98 7,180,607.22 414 - Water Debt Service 0.00 0.00 0.00 421 - Storm Drainage Utility 2,244,712.31 31,219.34 2,275,931.65 422 - Storm Drainage Stabilization 535,134.13 734.65 535,868.78 423 - Storm Drainage Capital Facil 94,213.38 129.34 94,342.72 424 - Storm Drainage Debt Service 0.00 0.00 0.00 431 - Sewer Operating 4,994,909.24 101,701.82 5,096,611.06 432 - Sewer Stabilization 1,425,407.39 1,956.86 1,427,364.25 433 - Sewer Capital 4,786,244.69 418,136.19 5,204,380.88 434 - Sewer Debt Service 550,816.53 756.18 551,572.71 500 - Equipment Rental and Revolving 3,555,625.30 -145,722.75 3,409,902.55 631 - Trust and Agency 12,605.51 -4,688.08 7,917.43 632 - Wastewater Treatment Facil Fee 5,685,326.45 -743,461.73 4,941,864.72 Grand Total: 69,837,324.98 -1,467,002.85 68,370,322.13 8/25/2022 9:54:11 AM Page 5 of 5