Loading...
2021.02 Monthly Budget Report MONTHLY BUDGET FINANCIAL STATUS UPDATE To: Mayor and Council members From: Noah Crocker, Finance Director Period: February 2021 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. Page 1 of 12 POINTS OF INTEREST: Current Expense Fund 001 – The Current Expense Fund is used for the general governmental functions of the City. The 19.33% of budgeted revenues were received through February 2021. This is slightly higher than expected. The table provides budget versus actual (YTD) data by source of revenue. SALES TAX REVENUES SUMMARY $5,235,000 •Total 2021 Budget: •Total 2021 YTD Actuals: $1,127,506 •Year-to-Date Actual revenue collected is 16.07% higher when compared to Prior Year-to Date Actuals •Year-to-Date Actual revenue collected is 24.93% higher when compared to Year-to Date Budgeted The following tables provide additional sales tax information: Revenue Source 2021 Original Budget 2021 Current Budget 2021 YTD % of Budget Received Received February 2021 Property Tax 1,976,000 1,976,000 42,995 2.18%39,327 Sales Tax 5,235,000 5,235,000 1,127,506 21.54%625,058 Other Taxes 2,080,000 2,080,000 423,033 20.34%77,107 Total Taxes 9,291,000 9,291,000 1,593,534 17.15% 741,492 Licenses & Permits 480,300 480,300 104,965 21.85%81,123 Intergovernmental Revenue 626,600 626,600 191,821 30.61%139,166 Charges for Goods & Services 389,300 389,300 241,599 62.06%69,845 Fines & Penalties 163,300 163,300 27,485 16.83%13,604 Misc Revenues 177,000 177,000 37,216 21.03%20,389 Non-Revenues - - (520) 0.00%(114) Capital Contributions - - - 0.00%- REVENUE TOTALS 11,127,500 11,127,500 2,196,098 19.74%1,065,505 Current Expense Fund Revenues Table 1: shows revenue received by month over a three-year period. Page 2 of 12 Real Estate Excise Tax (REET) Fund 109 and Impact Mitigation Fee Fund 111 We have included a brief discussion on Real Estate Excise Tax. Please refer to MRSC.org for the complete version of REET funding. Real Estate Excise Tax (REET) is levied upon most the sales of real property. The tax is calculated based on the full selling price, including the amount of any liens, mortgages, and other debts given to secure the purchase. (WAC 458-61A-301). Port Orchard imposes a 0.25% real estate excise tax – known as REET 1 or the “first quarter percent” (RCW 82.46.010). REET 1 revenues are restricted and may only be used for certain purposes. Cities that are fully planning under GMA and have a population of more than 5,000 must spend their REET 1 revenues on “capital projects” that are listed in the capital facilities plan (CFP) element of their comprehensive plan. RCW 82.46.010(6)(b) defines “capital projects” as: Those public works projects of a local government for planning, acquisition, construction, reconstruction, repair, replacement, rehabilitation, or improvement of streets; roads; highways; sidewalks; street and road lighting systems; traffic signals; bridges; domestic water systems; storm and sanitary sewer systems; parks; recreational facilities; law enforcement facilities; fire protection facilities; trails; libraries; administrative facilities, judicial facilities, river flood control projects […] and technology infrastructure that is integral to the capital project. Note that REET 1 funds may not be used for developing or updating a capital facilities plan (CFP) or capital improvement plan (CIP), but they can be used for design, engineering, surveys, etc. associated with a specific qualifying project listed in a CFP or CIP. In addition to REET 1, the City receives an additional 0.25% real estate excise tax – known as “REET 2” or the “second quarter percent” (RCW 82.46.035). REET 2 revenues are also restricted and may only be used for financing “capital projects” specified in the capital facilities plan element of the city’s comprehensive land use plan. REET 2 funds are more specifically directed to infrastructure and parks capital projects. (However, note that park lands “acquisition” is not an allowed use for REET 2.) REET 2 omits public facilities such as law enforcement, fire protection, libraries, administration, and courts that were listed within the REET 1 statute. RCW 82.46.035(5) defines “capital project” as: Table 2: provides current data for sales tax revenue collected Year-to-date. Page 3 of 12 (a) Planning, acquisition, construction, reconstruction, repair, replacement, rehabilitation, or improvement of streets, roads, highways, sidewalks, street and road lighting systems, traffic signals, bridges, domestic water systems, storm, and sanitary sewer systems; and (b) Planning, construction, reconstruction, repair, rehabilitation, or improvement of parks Note that the definition of “capital project” for REET 2 is more restrictive than it is in the REET 1 statute. REET 2 funds are more specifically directed to infrastructure and parks capital projects. However, REET 2 funds may be used for REET 1 projects, as well as REET 2 maintenance, subject to certain limitations. REET 2 funds may not be used for developing or updating a capital facilities plan (CFP) or capital improvement plan (CIP), but they can be used for design, engineering, surveys, etc. associated with a specific qualifying project listed in a CFP or CIP. The City’s Real Estate Excise Tax receipts fluctuate monthly. In February 2021 revenue is higher than February 2020 by 127.59%. There were two significant real estate transactions which closed in February 2021 with a sales price of approximately $19 million and $13.290 million which resulted in approximately $160,00 of REET revenue. The combined $32.29 million in real estate sale price was from the Stetson Heights development being sold to a new developer. As these transactions reflect one-time real estate sales, we do not anticipate similar revenue results in future months. The table below shows balances through February 2021 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 shows 2021 beginning fund balances, biennial revenue received, 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 February 2021 are as follows: o McCormick Woods Transportation $23,306 o Parks $17,031 o Transportation $36,226 REET revenues received in February: o REET 1 $110,432 o REET 2 $110,432 Capital Construction Fund 302 – The design of the McCormick Woods Splash Pad was completed by Land Expressions, LLC. (C-056-20). Construction is expected in 2021. The City has contracted with Rice,Fergus,Miller for the City Hall design. Impact Fees REET Recreation Reserve MW Transport Impact Parks Impact Bayside Plat SEPA Transportatio n REET 1 REET 2 Recreation Reserve (001) Admissions Tax Blue Berry Bethel (Fund 304) 2021-2022 Beginning Balance 785,820 255,009 326,495 944,142 1,625,464 1,641,128 118,202 - 2021-2022 Revenue Received*30,477 19,601 175 38,411 148,286 148,297 - 234,233 2021-2022 Expenses Budgeted (550,000) (115,000) - (500,000) (393,000) (1,198,200) (90,000) - 2021-2022 Obligated Expenses (210,000) (152,174) (326,495) (800,000) (875,000) - - - 2021-2022 Ending Balance 56,297 7,436 175 (317,447) 505,749 591,225 28,202 234,233 *Revenue received includes Page 4 of 12 Street Capital Construction Fund 304 – The project closeout of Tremont is almost complete. TIB has accepted the project and the acceptance from WSDOT is in progress. Bay Street Pedestrian Path Right of Way efforts are ongoing. – No Change. The Bethel-Lincoln Round about project has selected a design firm with work to commence immediately. ENTERPRISE/UTILITY FUNDS: Water operation - Water operations budgeted revenues in the amount of $3,344,700 for 2021. Through February, the City has received $535,296.61 or 16% 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. Operations expended $429,905.00 through February, 10.50% of the annual amount budgeted for 2021. The water operational expense budget includes transfers which have not yet been executed. The City manages its transfers according to when the anticipated expenses are to occur in the Water Capital Project or Debt Services. The 2021 budget includes $1,206,500 for transfers. There were no transfers recorded in February. Sewer operation - $5,418,800 is budgeted for Sewer Operational Revenues for 2021. Through the month of February $939,780.63 was received. This is 17.34% of the 2021 budgeted revenues. Operational expenses for the Sewer Utility as of February 28, 2021 cost $607,435.76. The sewer operational expense budget also includes transfers which have not yet been executed. The City manages its transfers according to when the anticipated expenses are to occur in the Sewer Capital Project or Debt Services. There $374,150 budgeted for transfers in 2021. There were no transfers recorded in February. Page 5 of 12 Storm Drainage operations -As of the end of February the Storm Drainage utility has received $304,819.15 or 18.45% of its annual budgeted revenue. Through February 28,2021, the Storm Drainage Operations Fund expended $182,061.08 (8.6%) of its 2021 total budget authority. The storm drainage operational expense budget also includes transfers. The City manages its transfers according to when the anticipated expenses are to occur in the Storm Drainage Capital Project or Debt Services. There is currently $342,150 budgeted for transfers in 2021. $25,964.96 was transferred through February 28th to Debt Service. Page 6 of 12 3/15/2021 8:03:42 AM Budget Report City of Port Orchard Group Summary For Fiscal: 2021 Period Ending: 02/28/2021 Fiscal AcƟvity Variance Favorable (Unfavorable) Period AcƟvityDepartment Current Total Budget Original Total Budget Percent Remaining Fund: 001 - Current Expense Revenue 00 - Revenues 2,196,097.971,065,505.2211,127,500.00 11,127,500.00 -8,931,402.03 80.26 % 2,196,097.971,065,505.2211,127,500.00 11,127,500.00 -8,931,402.03Revenue Total:80.26 % Expense 01 - Finance 125,847.1452,239.20845,484.17 845,484.17 719,637.03 85.12 % 02 - Court 75,090.0237,429.32745,605.24 745,605.24 670,515.22 89.93 % 03 - Law Enforcement 610,317.50270,555.235,087,610.55 5,087,610.55 4,477,293.05 88.00 % 04 - Community Development 215,591.73111,476.651,955,200.27 1,955,200.27 1,739,608.54 88.97 % 05 - Public Works 326,327.4074,088.311,503,800.42 1,503,800.42 1,177,473.02 78.30 % 06 - Miscellaneous 200,000.00200,000.00475,000.00 475,000.00 275,000.00 57.89 % 07 - Administration 274,004.15130,896.181,541,199.35 1,541,199.35 1,267,195.20 82.22 % 1,827,177.94876,684.8912,153,900.00 12,153,900.00 10,326,722.06Expense Total:84.97 % 368,920.03188,820.33-1,026,400.00 -1,026,400.00 1,395,320.03Fund: 001 - Current Expense Surplus (Deficit):135.94 % Fund: 002 - City Street Fund Revenue 00 - Revenues 136,329.2893,989.722,080,700.00 2,080,700.00 -1,944,370.72 93.45 % 136,329.2893,989.722,080,700.00 2,080,700.00 -1,944,370.72Revenue Total:93.45 % Expense 05 - Public Works 176,723.1797,542.382,393,500.00 2,393,500.00 2,216,776.83 92.62 % 176,723.1797,542.382,393,500.00 2,393,500.00 2,216,776.83Expense Total:92.62 % -40,393.89-3,552.66-312,800.00 -312,800.00 272,406.11Fund: 002 - City Street Fund Surplus (Deficit):87.09 % Fund: 003 - Stabilization Fund Revenue 00 - Revenues 200,477.07200,222.50200,000.00 200,000.00 477.07 0.24 % 200,477.07200,222.50200,000.00 200,000.00 477.07Revenue Total:0.24 % 200,477.07200,222.50200,000.00 200,000.00 477.07Fund: 003 - Stabilization Fund Total:0.24 % Fund: 103 - Criminal Justice Revenue 00 - Revenues 68,427.1428,446.71244,800.00 244,800.00 -176,372.86 72.05 % 68,427.1428,446.71244,800.00 244,800.00 -176,372.86Revenue Total:72.05 % Expense 03 - Law Enforcement 20,519.6610,243.32284,800.00 284,800.00 264,280.34 92.80 % 20,519.6610,243.32284,800.00 284,800.00 264,280.34Expense Total:92.80 % 47,907.4818,203.39-40,000.00 -40,000.00 87,907.48Fund: 103 - Criminal Justice Surplus (Deficit):219.77 % Fund: 104 - Special Investigative Unit Revenue 00 - Revenues 198.7564.044,000.00 4,000.00 -3,801.25 95.03 % 198.7564.044,000.00 4,000.00 -3,801.25Revenue Total:95.03 % Expense 03 - Law Enforcement 23.9912.004,000.00 4,000.00 3,976.01 99.40 % 23.9912.004,000.00 4,000.00 3,976.01Expense Total:99.40 % 174.7652.040.00 0.00 174.76Fund: 104 - Special Investigative Unit Surplus (Deficit):0.00 % Fund: 107 - Community Events Revenue 00 - Revenues 12,492.556,316.56100,000.00 100,000.00 -87,507.45 87.51 % 12,492.556,316.56100,000.00 100,000.00 -87,507.45Revenue Total:87.51 % _________________________________________________________________________________________________OPERATIONS Page 7 of 12 Budget Report For Fiscal: 2021 Period Ending: 02/28/2021 3/15/2021 8:03:42 AM Fiscal AcƟvity Variance Favorable (Unfavorable) Period AcƟvityDepartment Current Total Budget Original Total Budget Percent Remaining Expense 07 - Administration 1,827.511,730.93109,700.00 109,700.00 107,872.49 98.33 % 1,827.511,730.93109,700.00 109,700.00 107,872.49Expense Total:98.33 % 10,665.044,585.63-9,700.00 -9,700.00 20,365.04Fund: 107 - Community Events Surplus (Deficit):209.95 % Fund: 108 - Paths & Trails Revenue 00 - Revenues 169.7492.521,000.00 1,000.00 -830.26 83.03 % 169.7492.521,000.00 1,000.00 -830.26Revenue Total:83.03 % 169.7492.521,000.00 1,000.00 -830.26Fund: 108 - Paths & Trails Total:83.03 % Fund: 109 - Real Estate Excise Tax Revenue 00 - Revenues 296,582.77222,002.781,377,400.00 1,377,400.00 -1,080,817.23 78.47 % 296,582.77222,002.781,377,400.00 1,377,400.00 -1,080,817.23Revenue Total:78.47 % Expense 06 - Miscellaneous 32,875.7032,875.701,292,900.00 1,292,900.00 1,260,024.30 97.46 % 32,875.7032,875.701,292,900.00 1,292,900.00 1,260,024.30Expense Total:97.46 % 263,707.07189,127.0884,500.00 84,500.00 179,207.07Fund: 109 - Real Estate Excise Tax Surplus (Deficit):-212.08 % Fund: 111 - Impact Mitigation Fee Revenue 00 - Revenues 88,663.0077,156.19140,000.00 140,000.00 -51,337.00 36.67 % 88,663.0077,156.19140,000.00 140,000.00 -51,337.00Revenue Total:36.67 % Expense 05 - Public Works 0.000.0050,000.00 50,000.00 50,000.00 100.00 % 06 - Miscellaneous 0.000.00865,000.00 865,000.00 865,000.00 100.00 % 0.000.00915,000.00 915,000.00 915,000.00Expense Total:100.00 % 88,663.0077,156.19-775,000.00 -775,000.00 863,663.00Fund: 111 - Impact Mitigation Fee Surplus (Deficit):111.44 % Fund: 206 - Bond Redemption Fund Revenue 00 - Revenues 32,875.7032,875.70299,900.00 299,900.00 -267,024.30 89.04 % 32,875.7032,875.70299,900.00 299,900.00 -267,024.30Revenue Total:89.04 % Expense 06 - Miscellaneous 32,875.7032,875.70299,900.00 299,900.00 267,024.30 89.04 % 32,875.7032,875.70299,900.00 299,900.00 267,024.30Expense Total:89.04 % 0.000.000.00 0.00 0.00Fund: 206 - Bond Redemption Fund Surplus (Deficit):0.00 % Fund: 411 - Water Operating Revenue 00 - Revenues 535,296.61263,049.663,344,700.00 3,344,700.00 -2,809,403.39 84.00 % 535,296.61263,049.663,344,700.00 3,344,700.00 -2,809,403.39Revenue Total:84.00 % Expense 05 - Public Works 429,905.00170,817.572,889,600.00 2,889,600.00 2,459,695.00 85.12 % 06 - Miscellaneous 0.000.001,206,500.00 1,206,500.00 1,206,500.00 100.00 % 429,905.00170,817.574,096,100.00 4,096,100.00 3,666,195.00Expense Total:89.50 % 105,391.6192,232.09-751,400.00 -751,400.00 856,791.61Fund: 411 - Water Operating Surplus (Deficit):114.03 % Fund: 412 - Water Stabilization Revenue 00 - Revenues 87.0240.50263,500.00 263,500.00 -263,412.98 99.97 % 87.0240.50263,500.00 263,500.00 -263,412.98Revenue Total:99.97 % 87.0240.50263,500.00 263,500.00 -263,412.98Fund: 412 - Water Stabilization Total:99.97 % Fund: 414 - Water Debt Service Revenue 00 - Revenues 0.000.00485,125.00 485,125.00 -485,125.00 100.00 % 0.000.00485,125.00 485,125.00 -485,125.00Revenue Total:100.00 % Page 8 of 12 Budget Report For Fiscal: 2021 Period Ending: 02/28/2021 3/15/2021 8:03:42 AM Fiscal AcƟvity Variance Favorable (Unfavorable) Period AcƟvityDepartment Current Total Budget Original Total Budget Percent Remaining Expense 06 - Miscellaneous 0.000.00485,125.00 485,125.00 485,125.00 100.00 % 0.000.00485,125.00 485,125.00 485,125.00Expense Total:100.00 % 0.000.000.00 0.00 0.00Fund: 414 - Water Debt Service Surplus (Deficit):0.00 % Fund: 421 - Storm Drainage Utility Revenue 00 - Revenues 304,819.15155,805.471,652,100.00 1,652,100.00 -1,347,280.85 81.55 % 304,819.15155,805.471,652,100.00 1,652,100.00 -1,347,280.85Revenue Total:81.55 % Expense 05 - Public Works 156,096.1270,290.081,773,850.00 1,773,850.00 1,617,753.88 91.20 % 06 - Miscellaneous 25,964.9617,702.30342,150.00 342,150.00 316,185.04 92.41 % 182,061.0887,992.382,116,000.00 2,116,000.00 1,933,938.92Expense Total:91.40 % 122,758.0767,813.09-463,900.00 -463,900.00 586,658.07Fund: 421 - Storm Drainage Utility Surplus (Deficit):126.46 % Fund: 422 - Storm Drainage Stabilization Revenue 00 - Revenues 39.7618.50164,000.00 164,000.00 -163,960.24 99.98 % 39.7618.50164,000.00 164,000.00 -163,960.24Revenue Total:99.98 % 39.7618.50164,000.00 164,000.00 -163,960.24Fund: 422 - Storm Drainage Stabilization Total:99.98 % Fund: 424 - Storm Drainage Debt Service Revenue 00 - Revenues 25,964.9617,702.30178,100.00 178,100.00 -152,135.04 85.42 % 25,964.9617,702.30178,100.00 178,100.00 -152,135.04Revenue Total:85.42 % Expense 06 - Miscellaneous 25,964.9617,702.30178,100.00 178,100.00 152,135.04 85.42 % 25,964.9617,702.30178,100.00 178,100.00 152,135.04Expense Total:85.42 % 0.000.000.00 0.00 0.00Fund: 424 - Storm Drainage Debt Service Surplus (Deficit):0.00 % Fund: 431 - Sewer Operating Revenue 00 - Revenues 939,780.63490,113.285,418,800.00 5,418,800.00 -4,479,019.37 82.66 % 939,780.63490,113.285,418,800.00 5,418,800.00 -4,479,019.37Revenue Total:82.66 % Expense 05 - Public Works 607,435.76262,464.093,901,150.00 3,901,150.00 3,293,714.24 84.43 % 06 - Miscellaneous 0.000.00374,150.00 374,150.00 374,150.00 100.00 % 607,435.76262,464.094,275,300.00 4,275,300.00 3,667,864.24Expense Total:85.79 % 332,344.87227,649.191,143,500.00 1,143,500.00 -811,155.13Fund: 431 - Sewer Operating Surplus (Deficit):70.94 % Fund: 432 - Sewer Stabilization Revenue 00 - Revenues 135.9863.28374,150.00 374,150.00 -374,014.02 99.96 % 135.9863.28374,150.00 374,150.00 -374,014.02Revenue Total:99.96 % 135.9863.28374,150.00 374,150.00 -374,014.02Fund: 432 - Sewer Stabilization Total:99.96 % Fund: 434 - Sewer Debt Service Revenue 00 - Revenues 0.000.00275,000.00 275,000.00 -275,000.00 100.00 % 0.000.00275,000.00 275,000.00 -275,000.00Revenue Total:100.00 % 0.000.00275,000.00 275,000.00 -275,000.00Fund: 434 - Sewer Debt Service Total:100.00 % Fund: 500 - Equipment Rental and Revolving Revenue 00 - Revenues 63,052.5316,589.32671,500.00 671,500.00 -608,447.47 90.61 % 63,052.5316,589.32671,500.00 671,500.00 -608,447.47Revenue Total:90.61 % Expense 10 - ER&R 62,010.9716,098.44977,000.00 977,000.00 914,989.03 93.65 % Page 9 of 12 Budget Report For Fiscal: 2021 Period Ending: 02/28/2021 3/15/2021 8:03:42 AM Fiscal AcƟvity Variance Favorable (Unfavorable) Period AcƟvityDepartment Current Total Budget Original Total Budget Percent Remaining 62,010.9716,098.44977,000.00 977,000.00 914,989.03Expense Total:93.65 % 1,041.56490.88-305,500.00 -305,500.00 306,541.56Fund: 500 - Equipment Rental and Revolving Surplus (Deficit):100.34 % Report Surplus (Deficit):1,063,014.55 1,502,089.17-1,179,050.00 -1,179,050.00 2,681,139.17 227.40 % Page 10 of 12 3/15/2021 8:08:32 AM Budget Report City of Port Orchard Group Summary For Fiscal: 2021 Period Ending: 02/28/2021 Fiscal AcƟvity Variance Favorable (Unfavorable) Period AcƟvityAccount Type Current Total Budget Original Total Budget Percent Remaining Fund: 302 - Capital Construction Revenue 48.4922.57620,000.00 620,000.00 -619,951.51 99.99 % Expense 20,848.2520,848.25405,000.00 405,000.00 384,151.75 94.85 % -20,799.76-20,825.68215,000.00 215,000.00 -235,799.76Fund: 302 - Capital Construction Surplus (Deficit):109.67 % Fund: 304 - Street Capital Projects Revenue 264,424.84240,866.433,638,100.00 3,638,100.00 -3,373,675.16 92.73 % Expense 2,926.242,926.242,956,100.00 2,956,100.00 2,953,173.76 99.90 % 261,498.60237,940.19682,000.00 682,000.00 -420,501.40Fund: 304 - Street Capital Projects Surplus (Deficit):61.66 % Fund: 413 - Water Capital Revenue 1,499,823.431,487,769.355,995,100.00 5,995,100.00 -4,495,276.57 74.98 % Expense 94,021.4892,674.033,012,200.00 3,012,200.00 2,918,178.52 96.88 % 1,405,801.951,395,095.322,982,900.00 2,982,900.00 -1,577,098.05Fund: 413 - Water Capital Surplus (Deficit):52.87 % Fund: 423 - Storm Drainage Capital Facil Revenue 20.809.6830,100.00 30,100.00 -30,079.20 99.93 % 20.809.6830,100.00 30,100.00 -30,079.20Fund: 423 - Storm Drainage Capital Facil Total:99.93 % Fund: 433 - Sewer Capital Revenue 205,768.43188,108.573,311,300.00 3,311,300.00 -3,105,531.57 93.79 % Expense 21,546.1721,229.131,999,300.00 1,999,300.00 1,977,753.83 98.92 % 184,222.26166,879.441,312,000.00 1,312,000.00 -1,127,777.74Fund: 433 - Sewer Capital Surplus (Deficit):85.96 % Report Surplus (Deficit):1,779,098.95 1,830,743.855,222,000.00 5,222,000.00 -3,391,256.15 64.94 % _________________________________________________________________________________________________CAPITAL PROJECTS Page 11 of 12 Detail Report Date Range: 02/01/2021 - 02/28/2021 3/15/2021 8:11:36 AM Fund Summary Ending BalanceBeginning BalanceFund Total Activity 001 - Current Expense 7,124,510.90 7,313,331.23188,820.33 002 - City Street Fund 1,438,755.29 1,435,202.63-3,552.66 003 - Stabilization Fund 2,133,941.62 2,334,164.12200,222.50 103 - Criminal Justice 407,311.96 425,515.3518,203.39 104 - Special Investigative Unit 96,919.61 96,971.6552.04 107 - Community Events 218,081.42 222,667.054,585.63 108 - Paths & Trails 11,173.67 11,266.1992.52 109 - Real Estate Excise Tax 3,341,171.86 3,530,298.94189,127.08 111 - Impact Mitigation Fee 2,322,973.31 2,400,129.5077,156.19 206 - Bond Redemption Fund 0.00 0.000.00 302 - Capital Construction 238,733.19 217,907.51-20,825.68 304 - Street Capital Projects 1,756,073.50 1,994,013.69237,940.19 401 - Water-Sewer Utilities 0.00 0.000.00 403 - Water-Sewer Cumulative Reserve 0.00 0.000.00 411 - Water Operating 3,015,063.88 3,107,295.9792,232.09 412 - Water Stabilization 392,007.40 392,047.9040.50 413 - Water Capital 1,393,060.60 2,788,155.921,395,095.32 414 - Water Debt Service 0.00 0.000.00 421 - Storm Drainage Utility 2,077,164.56 2,144,977.6567,813.09 422 - Storm Drainage Stabilization 179,101.88 179,120.3818.50 423 - Storm Drainage Capital Facil 99,124.07 99,133.759.68 424 - Storm Drainage Debt Service 0.00 0.000.00 431 - Sewer Operating 2,989,471.78 3,217,120.97227,649.19 432 - Sewer Stabilization 612,663.37 612,726.6563.28 433 - Sewer Capital 2,386,392.65 2,553,272.09166,879.44 434 - Sewer Debt Service 0.00 0.000.00 500 - Equipment Rental and Revolving 3,495,059.20 3,495,550.08490.88 631 - Trust and Agency 10,204.16 11,759.541,555.38 632 - Wastewater Treatment Facil Fee 2,869,239.85 2,948,961.1479,721.29 Grand Total:38,608,199.73 41,531,589.902,923,390.17 _______________________________________________________________________________________________________________________________ CASH & INVESTMENT Page 12 of 12