The URL can be used to link to this page

Home My WebLink AboutFY 2022 Jan Financial SummaryCity of Euless Michael Pe7�a "' Phpto Teacher (11C T wMy r Financial Summary As of January 31, 2022 201 N. Ector Drive, Euless, TX7GO39 www.eulesstx.gov TABLE OF CONTENTS FinancialNarrative.......................................................................................................... 1-2 Fund Balance Summary.................................................................................................. 3-4 Statements of Revenues and Expenditures.................................................................. 5-9 Summary of 1¢ General Fund Sales Tax....................................................................... 10 Summary of %0 Euless Development Corporation (EDC) Sales Tax ........................... 11 Summary of/4¢ Additional Sales Tax............................................................................ 12 Summary of %0 Crime Control and Prevention District (CCPD) Sales Tax ................. 13 CarRental Tax Revenues............................................................................................... 14 PropertyTax Revenues................................................................................................... 15 Gross Receipts Revenues.............................................................................................. 16 Municipal Court Revenues............................................................................................. 17 CaseVolume Analysis.................................................................................................... 18 Ambulance Revenues..................................................................................................... 19 Development Revenues.................................................................................................. 20 Health Insurance Financial Report................................................................................. 21 Workers Compensation/Risk Management Financial Report ....................................... 22 Monthly Investment Summary and Economic Outlook ................................................ 23 T H E C I T Y O F EULBS To: City Manager, City Council, & Directors From: Finance Department Date: February 17, 2022 Re: Fiscal Summary for January, Fiscal Year 2021-22 The report that follows includes a fund balance summary and various other financial analyses for your review. Fund summaries and variances for four months of operations for the fiscal year ending 2022 are reported. After four months of activity, those programs that operate on a "normal" cycle should be approximately 33% complete. The following information is available for comparison of budget to year-to-date (YTD) actual as well as prior year comparatives. General Fund Total revenues collected in the General Fund for fiscal year 2022 are up $1,967,078 when compared to fiscal year 2021. Property tax collections are up from prior year by $759,950. Sales tax collections increased $753,393 over the prior year receipts and are at 36.7% of budget year-to-date. Gross receipt taxes increased $43,466 over prior year and are at 38.2% of budget. Fines and fees increased $91,332 over prior year and case volume is up 71.8% from the previous year-to-date. Development revenues decreased from the prior year by $102,160. Total General Fund revenues are at 51% of budget. General Fund expenditures are at 31.5% of budget. Water and Wastewater Water and wastewater revenues are at 33.2% of budget, which is $214,540 more than prior year. The expenses for this fund are at 34.7% of budget, which is $2,136,120 more than prior year. Other Funds Car Rental Tax: On the detailed car rental tax analysis, February receipts showed an 88% increase from the same month last year and a 112% increase fiscal year-to-date (FYTD). The February increase reflects December rentals which were significantly impacted by the COVID- 19 pandemic in the prior year. Total revenues for fiscal year 2022 are up $3,919,096 over prior year and are at 42.8% of budget. Total expenses for this fund are $1,716,716 more than prior year primarily due to increased revenues and therefore revenue sharing and transfers. Drainage Utility System: Revenues are at 32.7% of budget. Total expenses decreased $7,997 from prior year and are at 33.2% of budget. Hotel/Motel: Revenues are up $178,642 compared to prior year and are at 58.7% of budget. Total expenses are at 25.7% of budget. Service Center: This enterprise fund collected 33.7% of budgeted revenues with 31.8% of the budget expended. Health Insurance: This internal service fund shows revenues increased $11,906 over the prior year. Revenues are at 32.5% of budget and expenses are at 31.7% of budget. Risk/Workers Compensation: Revenue for this fund is at 32.8% of budget. Expenses are at 59.3% of budget. '/2 Cent EDC Sales Tax: Revenues increased $310,207 over prior year and are at 37.1 % of budget year-to-date. Expenditures increased $730,376 over prior year and are at 31.1 % of budget. The increase is due to a variety of reasons including the return of three positions to the fund, radio purchases, and transfers to equipment replacement. 1/4 Cent CCPD Sales Tax: This special revenue fund and special purpose district's revenues are $154,450 more than prior year-to-date. Total operating revenues are at 37.2% of budget. Expenditures increased $359,952 over prior year and expenses are at 28.7% of budget. Golf Course at Texas Star: The Golf Course collected 45.7% of budgeted revenues and spent 31 % of budget. Revenues increased $1,202,591 over prior year and expenses increased $153,294 over last year. The increase in revenues is primarily due to the one-time inflow from lost revenues during 2021 for COVID. Parks at Texas Star: This fund collected 31 % of the budgeted revenues and spent 33.3% of the operating budget. Recreation Classes: This activity collected 15.4% of budgeted revenues and spent 12.7% of budget. Fund Balance Summary As of January31, 2022 Budgetary Basis (Presented in Thousands) T H E C] T Y O F EULESS Estimated Beginning Ending Fund FYTD FYTD Fund Balance Revenues Expenses Balance Governmental Operating/Debt Funds General 20,086 23,149 15,686 27,549 General Emergency/Contingency Reserves 1,500 - - 1,500 Hotel/Motel 1,206 342 168 1,380 Juvenile Case Fund 196 16 17 196 1/2 Cent EDC Operating 5,550 2,183 2,086 5,647 1/4 Cent CCPD 1,989 1,074 951 2,113 Police Seized Assets Fund 233 - 3 230 Police Drug Funds 603 31 3 631 Grant Funds 5,198 90 5,160 127 Car Rental Tax Operating 4,889 5,521 3,855 6,554 Glade Parks Funds 3,405 372 381 3,395 Cable PEG Fund 589 - 16 574 Midtown Funds 2,203 1,622 1,360 2,466 General Obligation Debt Service 2,326 2,474 1,142 3,657 EDC Debt Reserve 401 - - 401 EDC Debt Service 11 134 1 144 Stars Center Debt Service 135 254 - 388 Proprietary Operating/Debt Funds Water & Wastewater 10,631 9,199 10,267 9,563 Service Center 538 410 390 558 Drainage Utility System 255 302 309 248 Recreation Classes 186 121 91 216 Arbor Daze Fund 54 - - 54 Parks at Texas Star 580 330 410 500 Parks at Texas Star Debt Reserve 303 12 - 315 Golf Course 364 2,498 1,408 1,454 Golf Course Reserve 716 51 93 674 Golf Course Debt Service 57 197 - 254 Water & Wastewater Debt Resv/Emerg 1,327 - 77 1,251 Rate Stabilization Reserve 4,284 5 87 4,202 Water & Wastewater Debt Service 599 404 132 871 Internal Service Funds Equipment Replacement 13,378 1,683 1,222 13,838 Health Insurance 5,772 2,470 2,417 5,824 Risk/Workers Compensation 2,123 371 670 1,823 Fiduciary Funds Stars Center Escrow 1,421 - - 1,421 Total Operating 93,109 55,314 48,404 100,020 3 Fund Balance Summary T H E C] T Y O F As of January31, 2022 EULESS Budgetary Basis (Presented in Thousands) Estimated Beginning Ending Fund FYTD FYTD Fund Balance Revenues Expenses Balance Capital Funds Developers Escrow 2,220 - - 2,220 Street CIP 13,554 1,025 1,571 13,009 EDC CIP 822 690 (4) 1,515 General CIP 6,750 414 1,359 5,805 Redevelopment CIP 49 2,500 1,214 1,335 Midtown Development CIP 69 1,000 - 1,069 Car Rental Tax CIP 1,880 - 35 1,845 Water/Wastewater CIP 4,308 4,603 109 8,801 Water Impact Fee CIP 2,457 69 39 2,487 Wastewater Impact Fee CIP 791 23 - 814 Drainage CIP 1,190 50 - 1,240 Parks at Texas Star CIP 144 - - 144 Golf Course CIP 154 60 - 214 Total Capital Funds 34,388 10,435 4,324 40,499 Grand Total All Funds 127,497 65,750 52,728 140,519 4 City of Euless Statements of Revenues and Expenditures As of January 31, 2022 CY Annual Budget CYTD Actual Act. % of Budget CYTD Actual to PYTD Actual PY Annual Budget PYTD Actual Act. % of Budget $ Diff % Diff GENERALFUND Est. FY 22 Beg. Fund Bal. $20,086,186 Revenues Property Taxes $19,177,531 $13,351,826 69.6 $759,950 6.0 $17,727,859 $12,591,876 71.0 Sales Taxes/Selective Sales Tax 14,545,718 5,336,990 36.7 753,393 16.4 12,057,045 4,583,597 38.0 Gross Receipts Tax 3,984,200 1,523,746 38.2 43,466 2.9 4,251,726 1,480,280 34.8 Penalties 71,400 12,243 17.1 1,527 -11.1 60,000 13,770 23.0 Charges for Services 1,909,825 768,977 40.3 368,601 92.1 1,632,155 400,376 24.5 Fines & Fees 1,344,100 596,429 44.4 91,332 18.1 1,541,600 505,097 32.8 Licenses & Permits 569,800 326,087 57.2 48,866 -13.0 580,300 374,953 64.6 Inter overnmental Revenue 426,350 85,323 20.0 1 0.0 426,350 85,324 20.0 Miscellaneous / Interest 710,754 268,989 37.8 141,644 -34.5 877,910 410,633 2,641,531 878,220 33.2 142,374 19.3 2,213,826 735,846 M46Transfers Total Revenues 45,381,209 23,148,830 51.0 1,967,078 9.3 41,368,771 21,181,752 Expenditures City Council 26,805 4,579 17.1 2,641 136.3 26,805 1,938 7.2 Administration 650,370 176,483 27.1 40,969 30.2 508,211 135,514 26.7 City Se retary 448,231 116,649 26.0 7,000 -5.7 434,977 123,649 28.4 Comm/Marketing 13,600 725 5.3 717 -49.7 13,600 1,442 10.6 Total City Admin 1,139,006 298,436 26.2 35,893 13.7 983,593 262,543 26.7 Finance 188,517 52,227 27.7 8,465 19.3 185,128 43,762 23.6 Municipal Court 871,801 209,176 24.0 1 5,711 2.8 812,933 203,465 25.0 Accounting 389,451 104,714 26.9 3,356 -3.1 381,667 108,070 28.3 Purchasing 106,730 31,163 29.2 1,729 5.9 100,376 29,434 29.3 Total Finance 1,556,499 3979280 25.5 129549 3.3 1,480,104 3849731 26.0 Emergency Management 69,498 35,756 51.4 2,366 7.1 57,508 33,390 58.1 Police Code Compliance 1,988,215 604,042 30.4 7,764 1.3 2,005,969 596,278 29.7 Police Administration 1,218,744 386,357 31.7 12,709 3.4 1,183,840 373,648 31.6 Police Patrol 6,780,628 1,962,530 28.9 46,460 2.4 6,475,255 1,916,070 29.6 Police C.I.D. 2,021,748 506,394 25.0 80,261 -13.7 1,910,109 586,655 30.7 Police Service 2,488,152 812,114 32.6 75,775 10.3 2,240,338 736,339 32.9 Police Detention 1,575,856 485,721 30.8 9,520 2.0 1,546,179 476,201 30.8 Total Police Dept. 16,142,841 437929914 29.7 74,333 1.6 15,419,198 4,7189581 30.6 Fire Marshall 657,949 168,391 25.6 21,142 14.4 672,220 147,249 21.9 Fire Administration 594,852 121,727 20.5 61,053 -33.4 583,496 182,780 31.3 Fire E.M.S./Suppression 10,594,964 3,240,516 30.6 118,892 3.8 9,544,521 3,121,624 32.7 Total Fire Dept. 1138479765 3,530,634 29.8 78,981 2.3 10,800,237 33451,653 32.0 Information Services 865,439 388,039 44.8 6,048 1.6 766,703 381,991 49.8 Human Resources 476,438 109,368 23.0 5,829 5.6 486,356 103,539 21.3 Facility Maintenance 1,102,522 351,498 31.9 113,882 47.9 1,073,391 237,616 22.1 Library 924,473 283,998 30.7 1 22,820 8.7 832,665 261,178 31.4 Total Admin Sery 3,368,872 1,132,903 33.6 1 148,579 15.1 3,159,115 984,324 31.2 Plannin & Development 358,075 97,095 27.1 4,419 -4.4 339,507 101,514 29.9 Inspection Service 417,283 87,053 20.9 3,544 4.2 388,075 83,509 21.5 Total Development 7759358 184,148 23.8 875 -0.5 727,582 1859023 25.4 Recreation 718,119 201,122 28.0 28,305 16.4 632,079 172,817 27.3 Parks 1,565,462 408,509 26.1 39,476 10.7 1,401,776 369,033 26.3 Swimming Pools 156,025 17,603 11.3 2,194 -11.1 156,025 19,797 12.7 Senior Center 262,206 62,327 23.8 33,532 116.5 252,346 28,795 11.4 Recreation Administration 82,189 23,533 28.6 6,207 35.8 76,609 17,326 22.6 Total Parks & Comm Sery 2,7849001 7139094 25.6 1059326 17.3 2,5189835 607,768 24.1 Street Maintenance 2,842,776 1,530,082 53.8 1,137,774 290.0 1,428,698 392,308 27.5 Animal Control 339,997 100,767 29.6 8,115 8.8 325,942 92,652 28.4 Citv En ineer 89,529 21,281 23.8 232 -1.1 82,357 21,513 26.1 Total Public Works 332729302 136529130 50.5 131459657 226.2 1,8369997 5069473 27.6 Legal Services 175,000 31,197 17.8 10,875 -25.8 1 175,000 42,072 24.0 Non -Dept. Oeratin 4,288,341 881,499 20.6 114,801 -11.5 4,305,864 996,300 23.1 Capital Expenses 4,423,783 2,071,720 46.8 53,240 2.6 5,465,678 2,018,480 36.9 Total Betterment 4,600 0 0.0 0 0.0 4,600 0 0.0 Total Non -Dept 8,891,724 1 2,984,416 33.6 (72,436) -2.4 9,951,142 31056,852 30.7 Total Expenditures 493778,368 1 15,685955 31.5 13528,007 10.8 463876,803 1431579948 30.2 Net (4,397,159) 7,4621875 (5,508,032) 7,023,804 Projected Ending Fund Bal. 15,689,027 1 27,549,061 Statements of Revenues and Expenditures As of January 31, 2022 General Fund Revenues % of Total by Source Licenses/Permits 1% General Fund Expenditures % of Total by Department Develonment rmance 2% 3% 6 Statements of Revenues and Expenditures As of January 31, 2022 CY Annual Budget CYTD Actual Act. % of Budget CYTD Actual to PYTD Actual PY Annual Budget PYTD Actual Act. % of Bud et $ Diff % Diff WATER & WASTEWATER FUND Est. FY 22 Beg. Work. Capt. 10,631,445 Revenues Sanitation 250,000 90,669 36.3 5,507 6.5 250,000 85,162 34.1 Water Service 16,052,941 5,347,339 33.3 108,369 2.1 15,391,274 5,238,970 34.0 Wastewater Service 10,176,428 3,374,774 33.2 16,745 -0.5 10,217,525 3,391,519 33.2 Other Charges for Services 345,000 103,669 30.0 1,988 -1.9 345,000 105,657 30.6 Miscellaneous/Interest 96,039 66,037 68.8 10,679 -13.9 51,258 76,716 149.7 Penalties 230,000 102,915 44.7 102,915 230,000 0 0.0 Rec cling Fees 479,429 159,421 33.3 8,4961 5.6 434,232 150,925 34.8 Transfers 287,523 1 86,512 1 30.1 2,693 -3.0 1 262,742 89,205 34.0 Total Revenues 2737259282 1 93199,262 1 33.2 214,540 1 2.4 1 27,079,515 8,9849722 33.2 Expenditures Geographic Info Systems 703,036 265,117 37.7 2,827 1.1 676,464 262,290 38.8 Water Office 497,745 147,992 29.7 1,865 1.3 491,112 146,127 29.8 Meter Reading 72,695 21,706 29.9 667 -3.0 72,053 22,373 31.1 Recycling 40,100 5,829 14.5 971 -14.3 40,100 6,800 17.0 City Engineer 367,117 98,585 26.9 10,798 -9.9 384,473 109,383 28.5 Water Production 9,444,589 2,133,724 22.6 732,526 52.3 9,127,526 1,401,198 15.4 Water Distribution 1,552,298 413,935 26.7 37,311 9.9 1,243,627 376,624 30.3 Wastewater Treatment 5,239,127 2,300,861 43.9 76,706 3.4 5,358,080 2,224,155 41.5 Legal Services 85,000 14,697 17.3 9,458 -39.2 85,000 24,155 28.4 Non -Dept. Oeratin 9,714,209 3,668,144 37.8 118,847 3.3 9,509,223 3,549,297 37.3 One -Time Capital 1,906,343 1,196,832 62.8 1,187,932 13347.6 198,944 8,900 4.5 Total Expenditures 29,622,259 1 103267,422 34.7 231369120 1 26.3 1 273186,602 1 8,1319302 29.9 Net (1,896,977) (1,068,160) 1 (107,087)1 853,420 Projected End Working Capt. 83734,468 1 935639285 Water & WW Fund Revenues % of Total by Source Water & WW Fund Expenditures % of Total by Department Water Distribution 4% Non -Dept. Operating 1 :nalties 1% ing Fees 2% ransfers 1% tion 1% 7 Statements of Revenues and Expenditures As of January 31, 2022 CY Annual Budget CYTD Actual Act. % of Bud et CYTD Actual to PYTD Actual PY Annual Bud et PYTD Actual Act. % of Budget $ Diff %Diff Car Rental Tax Est. FY 22 Beg. Fund Bal. 4,888,610 Revenues 12,903,494 5,520,971 42.8 3,919,096 244.7 7,395,408 1,601,875 21.7 Expenditures 10,312,624 3,855,311 37.4 1,716,716 80.3 7,079,395 2,138,595 30.2 Net 2,590,870 1,665,660 316,013 (536,720) Projected End Fund Bal. 7,479,480 63554,270 Drainage Utility System Est. FY 22 Beg. Work. Capt. 254,602 Revenues 923,966 302,024 32.7 1 23013 8.2 837,200 279,011 33.3 Expenditures 930,677 309,080 33.2 7%7 -2.5 934,563 317,077 33.9 Net (6,711) (7,056) (97,363) (38,066) Projected End Working Capt. 247,891 247,546 Hotel/Motel Est. FY 22 Beg. Fund Bal. 1,206,419 Revenues 583,140 1 342,041 1 58.7 178,642 109.3 532,338 163,399 30.7 Expenditures 654,211 1 168,381 1 25.7 35,988 27.2 524,174 132,393 25.3 Net (71,071)1 173,660 1 8,164 1 31,006 Projected End Fund Balance 1,1359348 1 1,3809079 Service Center Est. FY 22 Beg. Work. Capt. 538,327 Revenues 1,215,711 409,525 33.7 1 5,302 1.3 1,212,265 404,223 33.3 Expenditures 1,226,948 389,783 31.8 32,133 1 9.0 1,239,765 357,650 28.8 Net (11,237) 19,742 (27,500) 46,573 Projected End Working Capt. 527,090 558,069 Health Insurance Est. FY 22 Beg. Work. Capt. 5,772,173 Revenues 7,587,950 2,469,631 32.5 11,906 0.5 7,282,014 2,457,725 33.8 Expenditures 7,615,875 2,417,417 31.7 359,472 17.5 7,253,937 1 2,057,945 1 28.4 Net (27,925)1 52,214 28,077 1 399,780 Projected End Working Capt. 5,744,248 1 5,824,387 Risk/Workers Compensation Est. FY 22 Beg. Work. Capt. 2,122,597 Revenues 1,128,989 370,677 32.8 1 32,901 9.7 1,045,308 337,776 32.3 Expenditures 1,130,925 670,134 59.3 1 98,248 1 17.2 1,198,467 571,886 47.7 Net (1,936) (299,457) (153,159) (234,110) Projected End Working Capt. 2,120,661 1,823,140 1/2 Cent EDC Sales Tax Est. FY 22 Beg. Fund Bal. 5,550,310 Revenues 5,877,968 2,183,083 37.1 310,207 16.6 4,985,335 1,872,876 1 37.6 Expenditures 6,717,387 2,086,415 31.1 1 730,376 53.9 5,595,519 1,356,039 1 24.2 Net (839,419) 96,668 (610,184)1 516,837 Projected End Fund Bal. 4,710,891 53646,978 1/4 Cent CCPD Sales Tax Est. FY 22 Beg. Fund Bal. 1,989,147 Revenues 2,887,027 1,074,447 37.2 1 154,450 16.8 2,161,768 919,997 42.6 Expenditures 3,311,691 950,857 28.7 1 359,952 1 60.9 2,205,685 590,905 26.8 Net (424,664) 123,590 (43,917) 329,092 Projected End Fund Balance 1,564,483 2,112,737 Golf Course/Texas Star Est. FY 22 Beg. Work. Capt. 364,166 Revenues 5,463,868 2,498,192 45.7 1,202,591 92.8 4,629,475 1 1,295,601 1 28.0 Expenditures 4,541,343 1,408,058 31.0 153,294 12.2 4,606,455 1 1,254,764 1 27.2 Net 922,525 1,090,134 23,020 1 40,837 Projected End Working Capt. 1,2869691 1,4549300 Parks at Texas Star Est. FY 22 Beg. Work. Capt. 580,422 Revenues 1,062,030 1 329,532 31.0 1 190866 137.6 885,000 138,666 15.7 Expenditures 1,231,799 1 409,973 33.3 1 285%4 1 230.5 725,564 124,039 17.1 Net (169,769) (80,441) 159,436 14,627 Projected End Working Capt. 410,653 1 499,981 Statements of Revenues and Expenditures As of January 31, 2022 CY Annual Budget CYTD Actual Act. % of Budget[ CYTD Actual to PYTD Actual PY Annual Budget PYTD Actual Act. % of Bud et $ Diff % Diff Recreation Classes Est. FY 22 Beg. Work. Capt. 186,025 Revenues 783,027 120,873 15.4 1 85,744 244.1 787,027 35,129 4.5 Expenditures 715,036 90,501 12.7 32,354 55.6 697,935 58,147 8.3 Net 67,991 30,372 89,092 (23,018) Projected End Working Capt. 254,016 216,397 Arbor Daze Est. FY 22 Beg. Work. Capt. 54,314 Revenues 25,689 5 0.0 10 -66.7 25,583 15 0.1 Expenditures 80,000 0 0.0 1 01 0.0 80,000 0 0.0 Net (54,311) 5 (54,417) 15 Projected End Working Capt. 3 1 54,319 70 60 50 0 a 40 3 m 30 w 0 Y m 20 P L d IL Expenditures By Fund l % of Budaet Expended C;s astir G QGeo ale 100 �e Q_`y ^\rye EGG ��a c'0 ■ Current Year ■ Prior Year Q 9 City of Euless Summary of 10 General Sales Tax Monthly Mo %of Projected FY 2018-19 % of FY 2019-20 % of FY 2020-21 % of FY 2021-22 Inc/(Dec) % of Change FY 2021-22 Over/(Under) Monthly YTD Total Monthly YTD Total Monthly YTD Total Monthly YTD from PY Projected from PY Projected Budget $ 11,920,662 Oct $ 923,523 $ 923,523 9% $ 824,507 $ 824,507 8% $ 894,595 $ 894,595 8% $ 1,056,734 $ 1,056,734 $ 162,139 8% 18.12% $ 13,999,267 $ 2,078,605 Nov $ 922,890 $ 1,846,413 17% $ 1,015,190 $ 1,839,696 17% $ 1,048,345 $ 1,942,940 16% $ 1,257,207 $ 2,313,941 $ 208,862 17% 19.92% $ 13,924,253 $ 2,003,591 Dec $ 825,377 $ 2,671,790 25% $ 888,895 $ 2,728,591 25% $ 883,839 $ 2,826,780 24% $ 923,736 $ 3,237,677 $ 39,897 24% 4.51% $ 13,260,892 $ 1,340,230 Jan $ 812,452 $ 3,484,243 33% $ 869,715 $ 3,598,306 33% $ 874,911 $ 3,701,691 31% $ 1,054,632 $ 4,292,309 $ 179,721 32% 20.54% $ 13,377,083 $ 1,456,421 Feb $ 1,078,864 $ 4,563,107 43% $ 1,240,382 $ 4,838,689 44% $ 1,171,167 $ 4,872,858 41% $ 1,975,374 $ 6,267,683 $ 804,207 43% 68.67% $ 14,676,843 $ 2,756,181 Mar $ 716,252 $ 5,279,359 49% $ 816,213 $ 5,654,902 52% $ 835,114 $ 5,707,971 48% Apr $ 719,672 $ 5,999,031 56% $ 777,030 $ 6,431,931 59% $ 741,392 $ 6,449,364 55% May $ 1,012,262 $ 7,011,293 65% $ 914,424 $ 7,346,355 67% $ 1,222,521 $ 7,671,885 65% Jun $ 861,240 $ 7,872,533 74% $ 786,945 $ 8,133,300 74% $ 978,232 $ 8,650,117 73% Jul $ 871,588 $ 8,744,120 82% $ 878,778 $ 9,012,078 82% $ 961,924 $ 9,612,041 81% Aug $ 1,052,813 $ 9,796,933 91% $ 1,054,073 $ 10,066,151 92% $ 1,170,523 $ 10,782,565 91% Se $ 912,203 $ 10,709,136 100% $ 878,932 $ 10,945,083 100% $ 1,044,657 $ 11,827,222 100% Y I u $ 6,Yb/,653 AVG: $ 892,428 AVG: $ 912,090 AVG: $ 985,602 AVG: $ 1,253,537 HI: $ 1,078,864 HI: $ 1,240,382 HI: $ 1,222,521 HI: $ 1,975,374 LO: $ 716,252 LO: $ 777,030 LO: $ 741,392 LO: $ 923,736 $ 1,J94,62b 26.621/. $2,100,000 lGeneral Sales Tax Revenue $1,800,000 $1,500,000 $1,200,000 $900,000 $600,000 $300,000 Oct Nov Dec Jan Feb Mar Apr May Jun ■ FY 2018-19 ■ FY 2019-20 ■ FY 2020-21 ■ FY 2021-22 Includes General and TIRZ Funds Jul Aug Sep 10 City of Euless Summary of 1/20 EDC Sales Tax Monthly Mo % of Projected FY 2018-19 % of FY 2019-20 % of FY 2020-21 % of FY 2021-22 Inc/(Dec) % of Change FY 2021-22 Over/(Under) Monthly YTD Total Monthly YTD Total Monthly YTD Total Monthly YTD from PY Projected from PY Projected Budget $ 5,765,088 Oct $ 461,761 $ 461,761 9% $ 412,253 $ 412,253 8% $ 447,298 $ 447,298 8% $ 528,367 $ 528,367 $ 81,069 8% 18.12% $ 6,999,633 $ 1,234,545 Nov $ 461,445 $ 923,207 17% $ 507,595 $ 919,848 17% $ 524,173 $ 971,470 16% $ 628,604 $ 1,156,971 $ 104,431 17% 19.92% $ 6,962,126 $ 1,197,038 Dec $ 412,689 $ 1,335,895 25% $ 444,447 $ 1,364,296 25% $ 441,920 $ 1,413,390 24% $ 461,868 $ 1,618,839 $ 19,948 24% 4.51% $ 6,630,446 $ 865,358 Jan $ 406,226 $ 1,742,121 33% $ 434,858 $ 1,799,153 33% $ 437,456 $ 1,850,845 31% $ 527,316 $ 2,146,154 $ 89,860 32% 20.54% $ 6,688,542 $ 923,454 Feb $ 539,432 $ 2,281,554 43% $ 620,191 $ 2,419,344 44% $ 585,584 $ 2,436,429 41% $ 987,687 $ 3,133,842 $ 402,104 43% 68.67% $ 7,338,422 $ 1,573,334 Mar $ 358,126 $ 2,639,680 49% $ 408,107 $ 2,827,451 52% $ 417,557 $ 2,853,986 48% Apr $ 359,836 $ 2,999,516 1 56% $ 388,515 $ 3,215,966 1 59% $ 370,696 $ 3,224,682 55% May $ 506,131 $ 3,505,646 65% $ 457,212 $ 3,673,178 67% $ 611,261 $ 3,835,942 65% Jun $ 430,620 $ 3,936,266 74% $ 393,473 $ 4,066,650 74% $ 489,116 $ 4,325,059 73% Jul $ 435,794 $ 4,372,060 82% $ 439,389 $ 4,506,039 82% $ 480,962 $ 4,806,021 81% Aug $ 526,406 $ 4,898,466 91% $ 527,036 $ 5,033,076 92% $ 585,262 $ 5,391,282 91% Se $ 456,102 $ 5,354,568 100% $ 439,466 $ 5,472,542 100% $ 522,329 $ 5,913,611 100% AVG: $ 446,214 AVG: $ 456,045 HI: $ 539,432 HI: $ 620,191 LO: $ 358,126 LO: $ 388,515 AVG: $ 492,801 HI: $ 611,261 LO: $ 370,696 YTD $ 3,133,842 $ 697,413 28.62% AVG: $ 626,768 HI: $ 987,687 LO: $ 461,868 $1,000,000 1/20 EDC Sales Tax Revenue $800,000 $600,000 OR $400,000 $200,000 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep I3 FY 2018-19 ■ FY 2019-20 o FY 2020-21 ■ FY 2021-22 City of Euless Summary of 1/4¢ Additional Sales Tax Monthly Mo % of Projected FY 2018-19 % of FY 2019-20 % of FY 2020-21 % of FY 2021-22 Inc/(Dec) % of Change FY 2021-22 Over/(Under) Monthly YTD Total Monthly YTD Total Monthly YTD Total Monthly YTD from PY Projected from PY Projected Budget $ 2,882,543 Oct $ 230,881 $ 230,881 9% $ 206,127 $ 206,127 8% $ 223,649 $ 223,649 8% $ 264,183 $ 264,183 $ 40,535 8% 18.12% $ 3,499,817 $ 617,274 Nov $ 230,723 $ 461,603 17% $ 253,797 $ 459,924 17% $ 262,086 $ 485,735 16% $ 314,302 $ 578,485 $ 52,215 17% 19.92% $ 3,481,063 $ 598,520 Dec $ 206,344 $ 667,948 25% $ 222,224 $ 682,148 25% $ 220,960 $ 706,695 24% $ 230,934 $ 809,419 $ 9,974 24% 4.51% $ 3,315,223 $ 432,680 Jan $ 203,113 $ 871,061 33% $ 217,429 $ 899,577 33% $ 218,728 $ 925,423 31% $ 263,658 $ 1,073,077 $ 44,930 32% 20.54% $ 3,344,271 $ 461,728 Feb $ 269,716 $ 1,140,777 43% $ 310,096 $ 1,209,672 44% $ 292,792 $ 1,218,214 41% $ 493,844 $ 1,566,921 $ 201,052 43% 68.67% $ 3,669,211 $ 786,668 Mar $ 179,063 $ 1,319,840 49% $ 204,053 $ 1,413,725 52% $ 208,778 $ 1,426,993 48% Apr $ 179,918 $ 1,499,758 1 56% $ 194,257 $ 1,607,983 59% 1 $ 185,348 $ 1,612,341 55% May $ 253,065 $ 1,752,823 65% $ 228,606 $ 1,836,589 67% 1 $ 305,630 $ 1,917,971 65% Jun $ 215,310 $ 1,968,133 74% $ 196,736 $ 2,033,325 74% $ 244,558 $ 2,162,529 73% Jul $ 217,897 $ 2,186,030 82% $ 219,694 $ 2,253,020 82% $ 240,481 $ 2,403,010 81% Aug $ 263,203 $ 2,449,233 91% $ 263,518 $ 2,516,538 92% $ 292,631 $ 2,695,641 91% Se $ 228,051 $ 2,677,284 100% $ 219,733 $ 2,736,271 100% $ 261,164 $ 2,956,806 100% AVG: $ 223,107 HI: $ 269,716 LO: $ 179,063 AVG: $ 228,023 HI: $ 310,096 LO: $ 194,257 AVG: $ 246,400 HI: $ 305,630 LO: $ 185,348 YTD $ 1,566,921 AVG: $ 313,384 HI: $ 493,844 LO: $ 230,934 348,706 28.62% $500,000 1/40 Additional Sales Tax Revenue $400,000 $300,000 $200,000 - $100,000 $ - Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep ❑ FY 2018-19 o FY 2019-20 o FY 2020-21 ■ FY 2021-22 12 City of Euless EL I Summary of 1/4¢ CCPD Sales Tax Monthly Mo % of Projected FY 2018-19 % of FY 2019-20 % of FY 2020-21 % of FY 2021-22 Inc/(Dec) % of Change FY 2021-22 Over/(Under) Monthly YTD Total Monthly YTD Total Monthly YTD Total Monthly YTD from PY Projected from PY Projected Budget $ 2,886,565 Oct $ 230,074 $ 230,074 9% $ 205,563 $ 205,563 7% $ 222,284 $ 222,284 8% $ 263,029 $ 263,029 $ 40,745 8% 18.33% $ 3,498,391 $ 611,826 Nov $ 229,176 $ 459,250 17% $ 259,588 $ 465,151 17% $ 260,420 $ 482,704 16% $ 313,474 $ 576,503 $ 53,054 17% 20.37% $ 3,458,628 $ 572,063 Dec $ 206,183 $ 665,433 25% $ 221,924 $ 687,075 25% $ 219,903 $ 702,607 24% $ 229,950 $ 806,453 $ 10,047 24% 4.57% $ 3,299,113 $ 412,548 Jan $ 203,076 $ 868,510 33% $ 216,849 $ 903,925 33% $ 217,141 $ 919,749 31% $ 262,389 $ 1,068,842 $ 45,247 32% 20.84% $ 3,331,673 $ 445,108 Feb $ 270,119 $ 1,138,629 43% $ 323,340 $ 1,227,264 45% $ 291,101 $ 1,210,850 41% $ 492,228 $ 1,561,070 $ 201,128 43% 69.09% $ 3,637,746 $ 751,181 Mar $ 178,577 $ 1,317,206 49% $ 203,668 $ 1,430,932 52% $ 207,501 $ 1,418,351 48% Apr $ 179,081 $ 1,496,287 1 56% $ 194,224 $ 1,625,156 59% $ 184,434 $ 1,602,784 54% May $ 251,970 $ 1,748,257 66% $ 220,133 $ 1,845,290 67% $ 304,109 $ 1,906,894 65% Jun $ 214,368 $ 1,962,624 74% $ 195,773 $ 2,041,063 74% $ 243,263 $ 2,150,156 73% Jul $ 214,844 $ 2,177,468 82% $ 225,746 $ 2,266,809 83% $ 238,744 $ 2,388,900 81% Aug $ 262,060 $ 2,439,528 92% $ 261,707 $ 2,528,516 92% $ 294,720 $ 2,683,620 91% Sep $ 225,961 $ 2,665,489 100% $ 217,696 $ 2,746,212 100% $ 259,846 $ 2,943,466 100% AVG: $ 222,124 HI: $ 270,119 LO: $ 178,577 AVG: $ 228,851 HI: $ 323,340 LO: $ 194,224 AVG: $ 245,289 HI: $ 304,109 LO: $ 184,434 YTD $ 1,561,070 AVG: $ 312,214 HI: $ 492,228 LO: $ 229,950 350,220 28.92% $500,000 1/4¢ CCPD Sales Tax Revenue $400,000 $300,000 $200,000 $100,000 $- Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep ❑i FY 2018-19 ❑ FY 2019-20 1 FY 2020-21 ■i FY 202E-22 13 Car City of Euless Rental Tax Revenues FY 2018-19 Monthly YTD FY 2019-20 Monthly YTD FY 2020-21 Monthly YTD FY 2021-22 Monthly YTD Monthly Increase/ (Decrease) from PY Monthly % of Change from PY FY 2021-22 Projected Projected Over/(Under) Budget $ 10,915,975 Oct $ 1,317,912 $ 1,317,912 $ 1,368,634 $ 1,368,634 $ 602,354 $ 602,354 $ 1,308,158 $ 1,308,158 $ 705,805 117% $ 14,795,540 $ 3,879,565 Nov $ 1,181,698 $ 2,499,611 $ 1,022,436 $ 2,391,070 $ 607,752 $ 1,210,106 $ 1,267,382 $ 2,575,541 $ 659,630 109% $ 15,358,650 $ 4,442,675 Dec $ 1,352,827 $ 3,852,438 $ 1,678,822 $ 4,069,892 $ 800,242 $ 2,010,348 $ 1,894,975 $ 4,470,516 $ 1,094,734 137% $ 17,297,330 $ 6,381,355 Jan $ 1,277,148 $ 5,129,585 $ 1,295,727 $ 5,365,619 $ 798,660 $ 2,809,008 $ 1,661,830 $ 6,132,346 $ 863,170 108% $ 17,819,742 $ 6,903,767 Feb $ 1,112,358 $ 6,241,944 $ 1,219,517 $ 6,585,136 $ 685,416 $ 3,494,424 $ 1,288,428 $ 7,420,774 $ 603,012 88% $ 17,720,926 $ 6,804,951 Mar $ 1,028,275 $ 7,270,219 $ 1,143,957 $ 7,729,093 $ 639,946 $ 4,134,370 Apr $ 1,031,919 $ 8,302,138 $ 1,261,435 $ 8,990,528 $ 628,544 $ 4,762,913 May $ 1,264,516 $ 9,566,654 $ 916,818 $ 9,907,346 $ 1,109,168 $ 5,872,082 Jun $ 1,288,920 $ 10,855,574 $ 169,927 $ 10,077,272 $ 1,303,535 $ 7,175,617 Jul $ 1,359,568 $ 12,215,142 $ 195,681 $ 10,272,953 $ 1,499,183 $ 8,674,800 Aug$ 1,367,397 $ 13,582,539 $ 397,037 $ 10,669,991 $ 1,517,688 $ 10,192,488 Se $ 1,323,322 $ 14,905,860 $ 553,632 $ 11,223,623 $ 1,504,668 $ 11,697,156 AVG: $ 1,242,155 HI: $ 1,367,397 LO: $ 1,028,275 $2,000,000 $1,800,000 $1,600,000 $1,400,000 $1,200,000 $1,000,000 $800,000 $600,000 $400,000 $200,000 $0 YID $ 1,420,774 $ 3,926,350 112% AVG: $ 935,302 AVG: $ 974,763 AVG: $ 1,484,155 HI: $ 1,678,822 HI: $ 1,517,688 HI: $ 1,894,975 LO: $ 169,927 LO: $ 602,354 LO: $ 1,267,382 Car Rental Tax Revenues DI FY 2018-19 o FY 2019-20 of FY 2020-21 ■ FY 2021-22 This 5% tax is imposed only on the short-term rental of self-propelled motor vehicles including passenger cars, vans, sports utility vehicles, and light trucks. The tax is not imposed on trailers or trucks having a manufacturer's rating of more than one-half ton. The tax was effective February 1, 2000. Of the amount collected from DFW airport locations, two-thirds is due to Dallas and Ft. Worth. 14 Property Tax Revenues YTD Collection Review As of January 31, 2022 Revenue Type FY 2021-22 FY 2020-21 CY Increase/ (Decrease) from PY % of Change from PY Current Year $ 15,751,394 $ 15,226,185 $ 525,209 3.4% Prior Year $ (10,028) $ 21,909 $ (31,937) (145.8%) Penalty & Int. $ 14,433 $ 16,674 $ (2,241) (13.4%) Total $ 15,755,799 $ 15,264,768 $ 491,031 3.2% Note: Collections include General & Debt Service, and City portion of TIRZ property tax. Property Tax Monthly Revenues Current Year Collections Month FY 2021-22 FY 2020-21 CY Increase/ (Decrease) from PY % of Change from PY October $ 207,834 $ 395,847 $ (188,013) (47.5%) November $ 1,229,683 $ 886,294 $ 343,389 38.7% December $ 4,202,264 $ 4,098,898 $ 103,366 2.5% January $ 10,111,613 $ 9,845,146 $ 266,467 2.7% February March April May June July August September FYTD Total $ 15,751,394 $ 15,226,185 $ 525,209 3.4% Note: Collections do not include Penalties or Interest. O $8 75 $6 $4 $2 Property Tax Revenues by Month Current Year Collections Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep ■ FY 2021-22 ❑ FY 2020-21 15 Gross Receipts Revenues As of January 31, 2022 CY Annual Budget CYTD % of Budget Actual Collected PY Annual Budget PYTD Actual % of Change CY to PY Electric $ 1,584,507 $ 858,395 54.2% $ 1,720,000 $ 858,654 0.0% Gas $ 363,180 $ 81,106 22.3% $ 400,000 $ 56,634 43.2% Telephone $ 108,521 $ 131 0.1 % $ 50,000 $ 2,673 -95.1 % Sanitation $ 316,312 $ 112,639 35.6% $ 280,000 $ 106,011 6.3% Recycling $ 25,416 $ 8,390 33.0% $ 22,750 $ 7,943 5.6% Cable $ 200,000 $ 4,257 2.1 % $ 425,000 $ 871 588.7% Water/WW Utility $ 1,386,264 $ 458,828 33.1 % $ 1,353,976 $ 449,236 2.1 % Total Gross Receipt Taxes $ 3,984,200 $ 1,523,746 38.2% $ 4,251,726 $ 1,480,280 2.91% Gross receipts taxes are collected from public utilities for the privilege of providing services within the City's limits. Fees are levied by local governments and passed through to consumers of the utilities in the form of service prices. Gross receipts taxes are 2.9% greater than prior year. * Oncor makes quarterly payments for Electric fees, which are based on kilowatt hours provided to customers within the City of Euless. This source represents 3.49% of the General Fund budgeted revenues. * Gas payments are equal to 5% of the gross receipts on a quarterly basis. These receipts represent 0.8% of the General Fund budgeted revenues. * Telephone companies make payments based on a fee per number of access lines. This source represents 0.24% of General Fund budgeted revenues. * Republic Services makes monthly payments which are equal to 5% of sanitation gross receipts. These receipts represent 0.7% of the General Fund budgeted revenues. * Recycling billing fees are levied by the City. Currently, the contract with Community Waste Disposal allows for 5% of gross receipts to be paid on a monthly basis. This source represents 0.06% of the General Fund budgeted revenues. * Revenue from the cable company is 5% of gross receipts on a quarterly basis. This source represents .44% of the General Fund budgeted revenues. * The Water and Wastewater Fund pays a 5% gross receipt fee of total Water and Wastewater Fund revenues to the General Fund. This source represents a steady income from month to month and is 3.05% of the General Fund budgeted revenues. 16 City of Euless Municipal Court Revenues FY 2019-20 FY 2020-21 FY 2021-22 Month MONTHLY CUMULATIVE % of Total MONTHLY % CHANGE PY % of MONTHLY CUMULATIVE Total MONTHLY % CHANGE PY MONTHLY CUMULATIVE MONTHLY % CHANGE PY FYE PROJECTED PROJECTED VARIANCE $ 1,385,422 October $ 211,579 $ 211,579 11% -9.7% $ 169,036 $ 169,036 10% -20.1% $ 176,610 $ 176,610 4.5% $ 1,655,097 $ 269,675 November $ 151,035 $ 362,614 20% -11.3% $ 124,402 $ 293,438 17% -17.6% $ 161,064 $ 337,674 29.5% 1,835,497 450,075 December $ 147,092 $ 509,706 28% -10.4% $ 110,964 $ 404,402 24% -24.6% $ 126,433 $ 464,107 13.9% $ 1,811,209 $ 425,787 January $ 186,130 $ 695,836 38% -11.8% $ 114,567 $ 518,969 30% -38.4% $ 146,773 $ 610,880 28.1% 1,795,876 410,454 February $ 177,386 $ 873,222 47% -9.5% $ 102,232 $ 621,201 36% -42.4% March $ 205,032 $ 1,078,254 59% -17.0% $ 210,633 $ 831,834 49% 2.7% April $ 92,172 $ 1,170,426 64% -59.0% $ 177,612 $ 1,009,446 59% 92 7% May $ 90,745 $ 1,261,171 68% -47.0% $ 115,155 $ 1,124,601 66% 26.9% June $ 140,464 $ 1,401,635 76% 9.1% $ 131,871 $ 1,256,472 73% -6.1% Jul $ 159,169 $ 1,560,804 85% -25.4% $ 126,324 $ 1,382,796 81% -20.6% August $ 132,579 $ 1,693,383 92% -23.7% $ 175,078 $ 1,557,874 91% 32.1% September $ 149,446 $ 1,842,829 100% 5.2% $ 156,462 $ 1,714,336 100% 4.7% Total $ 11842,829 $ 1,714,336 $ 610,880 17.71% Municipal Court Monthly Revenues $250 E -9 $200 0 0 $150 c s $100 c $50 0 October November December January February March April May June July August September o FY 2019-20 ■ FY 2020-21 ■ FY 2021-22 Juvenile Case Fund Revenues are included. 17 City of Euless Case Volume Analysis Month FY 2019-20 FY 2020-21 FY 2021-22 City DFW Monthly Total Cumulative Total City DFW Monthly Total Cumulative Total City DFW Monthly Total Cumulative Total MO % Change from PY YTD % Change from PY Oct 1,627 127 1,754 1,754 1,055 113 1,168 1,168 1,619 86 1,705 1,705 45.98% 45.98% Nov 1,238 100 1,338 3,092 757 114 871 2,039 1,188 89 1,277 2,982 46.61% 46.25% Dec 1,347 131 1,478 4,570 534 84 618 2,657 907 122 1,029 4,011 66.50% 50.96% Jan 1,624 90 1,714 6,284 372 45 417 3,074 1,090 180 1,270 5,281 204.56% 71.80% Feb 1,698 78 1,776 8,060 457 1 42 499 3,573 Mar 1,072 56 1,128 9,188 1,000 74 1,074 4,647 Apr 88 13 101 9,289 960 72 1,032 5,679 May 288 75 363 9,652 888 75 963 6,642 Jun 1,505 140 1,645 11,297 1,162 96 1,258 7,900 Jul 691 135 826 12,123 1,243 152 1,395 9,295 Aug 1,241 248 1,489 13,612 1,337 203 1,540 10,835 Sep 1,620 168 1,788 15,400 1,727 189 1,916 12,751 YTD Total 14,039 1,361 15,400 11,492 1,259 12,751 4,804 477 5,281 % of Total 1 91.2%1 8.8%1 100.0%1 1 90.1%1 9.9%1 100.0°/- 1 91.0%1 9.0%1 100.0 2,500 2,000 1,500 1,000 500 0 Oct Nov Dec Jan Municipal Court Cases Filed by Month Feb Mar Apr May Comparison of FY 2020-21 to FY 2021-22 oFY 2021-22 DFW Airport �FY 2021-22 City of Euless +FY 2020-21 Totals Jun Jul Aug Sep 18 City of Euless Ambulance Revenues FY 2020-21 Month Medicare Medicaid Insurance Private Pay Total October $ 31,196 $ 7,326 $ 24,620 $ 2,509 $ 65,652 November $ 27,779 $ 2,413 $ 28,723 $ 6,565 $ 65,481 December $ 26,650 $ 2,528 $ 24,699 $ 3,899 $ 57,776 January $ 26,956 $ 1,708 $ 18,829 $ 9,741 $ 57,234 February $ 23,004 $ 1,914 $ 11,063 $ 5,169 $ 41,150 March $ 35,954 $ 4,061 $ 35,074 $ 16,990 $ 92,080 April $ 31,805 $ 4,244 $ 23,158 $ 13,852 $ 73,059 May $ 20,896 $ 3,087 $ 26,419 $ 5,677 $ 56,079 June $ 26,128 $ 6,386 $ 27,052 $ 3,559 $ 63,125 Jul $ 37,401 $ 6,182 $ 67,338 $ 13,067 $ 123,988 August $ 38,996 $ 9,412 $ 37,445 $ 13,168 $ 99,022 September $ 39,670 $ 5,728 $ 58,991 $ 5,528 $ 109,917 Totals $ 366,438 $ 54,990 $ 383,411 $ 99,724 $ 904,563 FY 2021-22 Month Medicare Medicaid Insurance Private Pay Total October $ 24,521 $ 5,149 $ 51,221 $ 5,586 $ 86,477 November $ 32,211 $ 5,529 $ 24,117 $ 4,539 $ 66,396 December $ 35,490 $ 9,832 $ 49,187 $ 5,748 $ 100,257 January $ 32,850 $ 6,630 $ 63,000 $ 930 $ 103,410 February March April May June Jul August September Totals $ 125,071 $ 27,141 $ 187,525 $ 16,803 $ 356,539 6%I 46% FY 2020-21 Year -to -Date �39% 9% ■ Medicare Y Medicaid i3 Insurance ❑ Private Pay FY 2021-22 Year -to -Date 8%� �52% ■1 Medicare ■1 Medicaid ■ Insurance i Private Pay 35% L 5% 19 City of Euless Development Revenues FY 2019-20 FY 2020-21 FY 2021-22 Month MONTHLY YTD % of Total MONTHLY YTD % of Total MONTHLY YTD MONTHLY % CHANGE PY FYE PROJECTED PROJECTED VARIANCE $662,800 October $ 229,431 $ 229,431 13% $ 160,523 $ 160,523 10% $ 86,994 $ 86,994 (45.81 %) $ 737,798 $ 74,998 November $ 111,668 $ 341,099 20% $ 66,145 $ 226,668 14% $ 89,655 $ 176,649 35.54% $ 1,029,894 $ 367,094 December $ 242,868 $ 583,967 34% $ 132,770 $ 359,438 23% $ 107,599 $ 284,248 (18.96%) $ 998,672 $ 335,872 January $ 65,397 $ 649,364 38% $ 96,773 $ 456,211 29% $ 69,803 $ 354,051 (27.87%) $ 1,059,029 $ 396,229 February $ 104,205 $ 753,569 44% $ 84,527 $ 540,738 34% March $ 267,773 $ 1,021,342 60% $ 80,286 $ 621,024 39% April $ 60,711 $ 1,082,053 63% $ 221,264 $ 842,288 53% May $ 74,378 $ 1,156,431 68% $ 104,341 $ 946,629 60% June $ 145,501 $ 1,301,932 76% $ 178,586 $ 1,125,215 71% July $ 79,236 $ 1,381,168 81% $ 254,695 $ 1,379,910 87% August $ 204,766 $ 1,585,934 93% $ 109,516 $ 1,489,426 94% September $ 118,313 $ 1,704,247 100% $ 96,810 $ 1,586,236 100% Total $ 1,704,247 $ 1,586,236 $ 354,051 (22.39%) $300,000 Development Revenues by �on $250,000 $200,000 $150,000 $100,000 $50,000 k-A iii I I-111.1 October November December January o FY 2019-20 February March April ❑ FY 2020-21 May June July ■ FY 2021-22 August September 20 Health Insurance Financial Report Report City Employee Total Transfer/ Total Paid Insurance Reinsurance RX Operating Total Monthly Ending Fund Month Contribution Contribution Contribution Misc. Revenues Claims Services Fee Cost Expense Expenses Cash Flow Balance BEGINNING BALANCE FISCAL YEAR 2020-21 $5,680,312 Oct-20 $394,952 $148,071 $543,023 $52,943 $595,966 $37,670 $18,327 $63,476 $91,771 $10,795 $222,039 $373,927 $6,054,239 Nov-20 $397,668 $144,262 $541,930 $54,189 $596,119 $293,098 $21,114 $63,672 $87,265 $19,717 $484,866 $111,253 $6,165,492 Dec-20 $396,170 $143,244 $539,414 $127,218 $666,632 $299,705 $20,690 $63,884 $98,289 $186,244 $668,812 $2,180 $6,163,312 Jan-21 $400,228 $144,675 $544,903 $54,105 $599,008 $478,726 $21,664 $64,434 $101,454 $15,950 $682,228 $83,220 $6,080,092 Feb-21 $399,571 $144,343 $543,914 $114,787 $658,701 ($10,975)1 $21,240 $64,221 $51,020 $23,550 $149,056 $509,645 $6,589,737 Mar-21 $395,151 $138,804 $533,955 $120,413 $654,368 $466,539 $20,404 $63,089 $95,707 $197,430 $843,169 $188,801 $6,400,936 Apr-21 $393,544 $146,013 $539,557 $54,587 $594,144 $267,290 $28,309 $63,700 $81,652 $16,821 $457,772 $136,372 $6,537,308 Ma -21 $396,211 $146,683 $542,894 $54,512 $597,406 $191,057 $20,819 $63,792 $91,756 $19,335 $386,759 $210,647 $6,747,955 Jun-21 $397,045 $142,771 $539,816 $148,553 $688,369 $360,886 $22,858 $63,824 $115,404 $182,105 $745,077 $56,708 $6,691,247 Ju1-21 $396,235 $142,687 $538,922 $55,104 $594,026 $395,755 $19,943 $63,976 $62,425 $19,763 $561,862 $32,164 $6,723,411 Aug-21 $389,471 $142,614 $532,085 $56,980 $589,065 $402,215 $17,687 $62,970 $79,509 $20,686 $583,067 $5,998 $6,729,409 Sep-21 $396,306 $138,357 $534,663 $194,847 $729,510 $1,320,467 $28,329 $64,314 $82,241 $191,395 $1,686,746 $957,236 $5,772,173 Totals $4,752,552 $1,722,524 $6,475,076 $1,088,238 $7,563,314 $4,502,433 $261,384 $765,352 $1,038,493 $903,791 $7,471,453 $91,861 BEGINNING BALANCE FISCAL YEAR 2021-22 $5,772,173 Oct-21 $400,313 $142,502 $542,815 $53,979 $596,794 $615,861 $19,937 $71,719 $72,416 $14,950 $794,883 ($198,089) $5,574,084 Nov-21 $397,024 $140,233 $537,257 $55,498 $592,755 $371,860 $21,458 $72,259 $81,621 $13,738 $560,936 $31,819 $5,605,903 Dec-21 $391,876 $137,765 $529,641 $169,398 $699,039 $108,259 $22,963 $71,552 $111,673 $187,730 $502,177 $196,862 $5,802,765 Jan-22 $388,982 $137,361 $526,343 $54,700 $581,043 $364,150 $20,937 $70,586 $86,649 $17,099 $559,421 $21,622 $5,824,387 Feb-22 Mar-22 Apr-22 Ma -22 Jun-22 J u I-22 Aug-22 Sep-22 Totals $1,578,195 $557,861 $2,136,056 $333,575 $2,469,631 $1,460,130 $85,295 $286,116 1 $352,359 $233,517 $2,417,417 $52,214 21 Workers' Compensation/Risk Management Financial Report Report City Other I Total TML Insurance Admin. WC Claims Risk Claims WC/Risk Total Monthly Ending Fund Month Contribution Revenue I Revenues Services Expense Paid Paid Prevention Exp. Expenses Cash Flow Balance BEGINNING BALANCE FISCAL YEAR 2020-21 $2,161,658 Oct-20 $84,143 $228 $84,371 $258,157 $4,560 ($1,021) ($6,513) $28 $255,211 ($170,840) $1,990,818 Nov-20 $84,311 $171 $84,482 $337,805 $6,174 ($814) ($49,532) $2,587 $296,220 ($211,738) $1,779,080 Dec-20 $84,367 $132 $84,499 $1,320 $6,317 ($6,790) $7,678 $6,083 $14,608 $69,891 $1,848,971 Jan-21 $84,311 $113 $84,424 $1,571 $6,095 ($7,786) $4,314 $1,653 $5,847 $78,577 $1,927,548 Feb-21 $84,143 $60 $84,203 $6,316 $6,095 ($1,547) $5,860 $2,143 $18,867 $65,336 $1,992,884 Mar-21 $84,479 $43 $84,522 $5,773 $38,445 ($1,177) ($647) $1,926 $44,320 $40,202 $2,033,086 Apr-21 $84,760 $23 $84,783 $203 $0 ($5,335) $70,445 $2,900 $68,213 $16,570 $2,049,656 May-21 $84,704 $18 $84,722 $2,406 $2,009 ($2,435) $48,427 $10,684 $61,091 $23,631 $2,073,287 Jun-21 $84,871 $23 $84,894 $4,549 $4 ($2,997) $5,961 $11,199 $18,716 $66,178 $2,139,465 Ju1-21 1 $85,152 $27 $85,179 $7,374 $0 ($477) $8,899 $18,754 $34,550 $50,629 $2,190,094 Aug-21 $84,872 $26 $84,898 $0 $160,825 $312 $33,154 $3,711 $198,002 ($113,104) $2,076,990 Sep-21 $84,880 $65 $84,945 $2,125 $2,326 $4,808 $26,318 $3,761 $39,338 $45,607 $2,122,597 Totals $1,014,993 $929 $1,015,922 $627,599 $232,850 ($25,259) $154,364 $65,429 $1,054,983 ($39,061) BEGINNING BALANCE FISCAL YEAR 2021-22 $2,122,597 Oct-21 $92,467 ($16) $92,451 $658,561 $4,061 ($2,576) $2,024 ($80) $661,990 ($569,539) $1,553,058 Nov-21 $92,804 $116 $92,920 $14,376 $6,205 ($6,026) $16,291 $3,754 $34,600 $58,320 $1,611,378 Dec-21 $92,636 $116 $92,752 $6,433 $6,875 $0 ($254) $5,650 $18,704 $74,048 $1,685,426 Jan-22 $92,467 $87 $92,554 $798 $6,854 ($4,562) ($54,823) $6,573 ($45,160) $137,714 $1,823,140 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Totals $370,374 $303 $370,677 $680,168 1 $23,995 i ($13,164) ($36,762) i $15,897 i $670,134 i ($299,457) 22 Monthly Investment Summary and Economic Outlook Prepared by: Cash & Debt Department Diana L Ayala January 31, 2022 January FY 2021 FY 2022 Percent of funds invested 100% 99% Consolidated Cash, Operating Account $591,781 $769,022 $86,542,244 or approximately 59% of the City's invested funds are available immediately. $86,791,244 or 59% of the City's invested funds are available within 30 days. One CD with a par value of $249,000 matured in the month of January, overnight investment redemptions for January totaled $1,200,132 for Texpool, $550,012 for TexSTAR, $1,750,115 for TexasCLASS. There were no redemptions in the Escrow Accounts for January. The average yields for the month of January for Texpool was 0.0376%, for TexSTAR was 0.0100%, and for TexasCLASS was 0.0332%. Four agency securities were purchased in January for a cost of $3,991,953. Purchases in the overnight market totaled $11,891,376 for the month combined and dividends reinvested for January totaled $2,087. Agencies/Treasuries/CD Texpool TexasCLASS TexSTAR Bank of Texas/US Bank Total PORTFOLIO SUMMARY BY INSTRUMENT (at cost) 12/31 /21 % 01 /31 /22 % $ 57,630,474 42% $ 30,264,381 22% $ 29,199,857 22% $ 18,182,455 13% $ 502,346 1 % $ 135,779,513 100% $ 61,373,426 41 % $ 32,206,529 22% $ 31,150,730 21% $ 22,682,632 15% $ 502,353 1 % $ 147,915,670 100% The City's weighted average yield on investments for January 2022 was 0.14% and the 90-day T-Bill yield was 0.24. The City's average yield rose three basis point from the prior month and the 90-day T-Bill rose eighteen basis points. The 90-day T-Bill yield has now surpassed the City's weighted average yield by 10 basis point. The City has chosen to have a relatively short weighted average maturity due to instability in market rates. As securities with higher yields are called or mature, if the funds are not needed for cash flow purposes, they can be re- invested at then -current market rates. Interest earnings for the month of January were $5,942. The economic momentum and Fed policy accommodation of the last year -and -a -half are fading. We continue to believe that underlying economic growth will be strong this year, although Omicron clearly disrupted economic activity at the start of 2022, with both airline traffic and restaurant bookings dipping. We expect improvement in February as the economy moves past the latest pandemic wave; it will still be experiencing a chronic excess demand for labor. This will contribute to continued inflation pressure and likely keep the Fed in a more hawkish stance. It is looking increasing likely that 2022 will see not just the end of Fed bond purchases and increases in short-term interest rates but also the first steps by the Fed to reduce its swollen balance sheet. On fiscal policy, negotiations between the White House and Senator Manchin appear to have stalled. The enhancements to the child tax credit, earning income tax credit and dependent care tax credit have all expired and, even if they are renewed, it is likely to be in a very watered-down form. The Administration would very much like to pass some version of the Build Back Better bill and there continues to be a possibility of higher taxes on corporations and very wealthy individuals. However, major fiscal stimulus has ended. With the Omicron drag and sudden cutoff of fiscal stimulus, we expect real economic growth to slow from 6.9% in the fourth quarter to just 2% in the first quarter of 2022 before rebounding to average about 3% over the rest of the year. Growth should be helped by a similar post-Covid recovery in the rest of the world, as well as pent-up demand for consumer goods and strong capital spending. Shelter and wage inflation are showing enough signs of persistence that even after transitory factors fade, it is becoming increasingly clear that inflation will remain far above the Fed's mandate for longer than previously expected, and when it does moderate, it will likely be at levels that remain above 2% on Core Personal Consumption Expenditures. Given the robust inflation and labor market backdrop, we believe the Fed will hike rates five times in 2022 starting in March and should continue hiking rates in 2024. We also expect the fed to develop a balance sheet normalization plan by mid -year and begin the rundown by quarter three at a pace that could shrink the balance sheet through reinvestment caps at a pace of approximately $1 trillion per year. Overall, investors should be prepared for an active Fed over the next couple of years. While January's Federal Open Market Committee (FOMC) meeting could be viewed as somewhat hawkish, risks to the outlook remain: a more pronounced slowdown in China, escalating geopolitical tensions, and heightened market volatility are likely to keep the Fed flexible in its path towards tighter policy. This information is an excerpt from an economic report dated January 2022 provided to TexSTAR by JP Morgan Asset Management, Inc., the investment manager of the TexSTAR pool. Source: TexSTAR Monthly Newsletter, January, 2022 23