Loading...
HomeMy WebLinkAbout3rd_Qtr_Report_FY2023 FY2023 Quarterly Report 3rd Quarter FINANCIAL REPORT AND INVESTMENT REPORT For the Quarter Ended June 30, 2023 Table of Contents General Fund Narrative .............................................................................................................................. 1-8 General Fund Schedule ................................................................................................................................. 9 General Fund by Cost Center ................................................................................................................. 10-13 Electric Fund Narrative ........................................................................................................................... 14-18 Electric Fund Schedule ................................................................................................................................ 19 Water Services Fund Narrative ............................................................................................................... 20-24 Water Services Fund Schedule .................................................................................................................... 25 Convention & Visitors Bureau Narrative................................................................................................. 26-27 Convention & Visitors Bureau Fund Schedule ............................................................................................. 28 Airport Fund Narrative ........................................................................................................................... 29-31 Airport Fund Schedule ................................................................................................................................. 32 Georgetown Transportation Enhancement Corporation Fund Narrative ............................................... 33-35 Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 36 Georgetown Economic Development Corporation Fund Narrative ....................................................... 37-39 Georgetown Economic Development Corporation Fund Schedule ............................................................. 40 Council Discretionary Fund Schedule .......................................................................................................... 41 Joint Services Fund Schedule ....................................................................................................................... 42 Stormwater Narrative ............................................................................................................................. 43-45 Stormwater Fund Schedule ......................................................................................................................... 46 Village PID Services Narrative ...................................................................................................................... 47 Village PID Services Fund Schedule ............................................................................................................. 48 Investment Report.................................................................................................................................. 49-51 Quarterly Investment Report - City ........................................................................................................ 52-73 Quarterly Investment Report - GEDCO ................................................................................................... 74-79 Quarterly Investment Report - GTEC ...................................................................................................... 80-85 Grant Applications ....................................................................................................................................... 86 Capital Improvement Projects ................................................................................................................ 87-91 Quarterly Financial Report EXECUTIVE SUMMARY FOR THE QUARTER ENDED JUNE. 30, 2023 I.QUARTERLY FINANCIAL ANALYSIS The Third Quarter Report Approved Budget includes the Capital Project Roll Forward and the Mid- Year Budget Amendment. This report contains expenses incurred from winter storm Mara and the City amended the budget for related expenses as part of the mid-year budget amendment in May. This report compares actuals to budget and the performance of current actuals to actuals of the same quarter in the previous year. Furthermore, this report compares actuals to year-end projections. GENERAL FUND REVENUES: General Fund revenues total $80,083,335, or 74.44% of budget through the end of the quarter. Revenues are higher than last year’s same quarter total by $4,227,027, or 5.57%. $1,551,656 million of this is attributed to an increase in property tax revenue and $1,130,577 million is due to a drastic increase in interest income which is consistent with what is being seen across the organization. The City continues to monitor the performance in revenue, particularly in planning and development related fees, as well as sales tax. General Fund Quarterly Comparison: Q3 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2023 YTD Actuals: Q3 FY22 YTD Actuals: Q3 FY23 Variance % of Budget Variance % Variance Revenue 40001:Property Taxes 18,700,000 15,858,125 17,409,781 (1,290,219) 93.10% 1,551,656 9.78% 40002:Sales Taxes 30,749,397 16,131,808 16,352,182 (14,397,215) 53.18% 220,374 1.37% 40005:Franchise Taxes 6,820,940 4,904,633 5,308,852 (1,512,088) 77.83% 404,219 8.24% 40008:Other Taxes 576,473 500,649 577,228 755 100.13% 76,579 15.30% 41001:Fines 270,800 200,065 323,044 52,244 119.29% 122,979 61.47% 41002:Penalties 111,348 89,166 96,218 (15,130) 86.41% 7,052 7.91% 42001:Interest Income 100,000 117,157 1,247,734 1,147,734 1247.73% 1,130,577 965.01% 43001:Fees 9,927,405 7,068,448 6,607,164 (3,320,241) 66.55% (461,284) -6.53% 43002:Garbage Charges 12,095,135 9,101,883 9,759,575 (2,335,560) 80.69% 657,692 7.23% 43003:Permits 6,548,500 4,405,092 3,620,351 (2,928,149) 55.29% (784,741) -17.81% 43004:Administrative Charges 2,000,000 2,042,573 1,333,339 (666,661) 66.67% (709,235) -34.72% 43005:Rental Revenue 127,692 89,364 79,605 (48,087) 62.34% (9,760) -10.92% 45001:Misc Revenue 883,850 307,224 821,854 (61,996) 92.99% 514,630 167.51% 45002:Insurance Proceeds - 50,338 8,947 8,947 0.00% (41,391) -82.23% 45003:Misc Reimbursements - 2,714 609 609 0.00% (2,105) -77.57% 45004:Sale of Property - 3,321 150,843 150,843 0.00% 147,522 4441.82% 44001:Grant Revenue 40,000 370,988 2,250 (37,750) 5.63% (368,738) -99.39% 44501:Contribution Revenue 145 296 - (145) 0.00% (296) -100.00% 44502:Developer Contributions 264,018 1,929,130 1,769,169 1,505,151 670.09% (159,962) -8.29% 44503:Interlocal Agreement Revenue 5,991,960 4,335,934 4,582,346 (1,409,614) 76.47% 246,412 5.68% 44504:Donations - 36 11,151 11,151 0.00% 11,115 30620.11% 70001:Transfers In 1,765,500 410,407 1,765,500 - 100.00% 1,355,093 330.18% 70002:Transfers In - Payment in Lieu of Taxes (PILOT) 10,615,004 7,936,956 8,255,595 (2,359,409) 77.77% 318,640 4.01% Revenue Total 107,588,167 75,856,308 80,083,335 (27,504,832) 74.44% 4,227,027 5.57% 1 Quarterly Financial Report Sales tax revenue accounts for $30,749,397 of General Fund budgeted revenue. Through the quarter, the City has collected $16,352,182, of the budgeted sales tax amount. Sales tax data lags two months in arrears. Sales tax revenue began a downward trend in comparison to prior fiscal years. While the overall sales tax amount is slightly up compared to FY2022, the City is no longer seeing large increases from month-to-month. The quarterly return for sales tax is 1.37% greater than the same period last year. During the development of the FY2024 budget staff forecasted an 4% increase of prior fiscal year sales tax. The month-to-month comparison of FY2022 and FY2023 sales tax returns indicates a slowing down of rapid growth recently experienced in multiple sectors. The decline in sales tax is attributed to the manufacturing sector, specifically related to building materials. Building materials, which over the past three years has on average accounted for 17.5% of total sales tax, has seen a decrease in year- to-date actuals when compared to the same period during the previous year. Because sales tax is the largest source of revenue in the general fund and also subject to volatility, staff is closely monitoring the City’s core sectors of retail (specifically building materials), food, and information. The City continues to reserve a fully funded (8%) Economic Stability Reserve to protect against any volatility in sales tax revenue. In addition, several, new vacant positions are also on hold while the city monitors sales tax revenue. Property tax revenues are the second largest revenue segment in the General Fund and has a budget of $18,700,000. Property tax revenue is typically received during the first two quarters of the fiscal year, with most of the taxes collected in December and January. Through the quarter, property tax year-to-date collections total 93.10% of budget, or $17,409,781. Year-to-date property tax revenues are 9.78% greater than the same period last year. The City collects franchise fees for electric, water, garbage, natural gas, cable, and non-cellular telephone services. Through the quarter, franchise fee revenues total $5,308,852 in FY2023, or 77.83% of budget. Franchise fee revenue is 8.24% higher than the same quarter of FY2022. While most franchise fees saw increases from the same quarter of FY2022, the major increases are from electric, water, garbage and gas franchise fees. Payment in Lieu of Taxes (PILOT) revenue from City-owned utilities is budgeted at $10,615,004. Year-to-date, PILOT revenues total $8,255,595, or 77.77% of budget. PILOT revenue is $318,640, or 4.01%, higher than the same quarter of FY2022. While all utility funds PILOT is trending slightly higher than budget, the majority of the increase for the quarter is from Water and Wastewater. Electric PILOT was capped at $5.5 million, per Council direction. Planning and Development related revenue has slowed down in FY2023 due to a significant decrease in the number of residential building permits issued. Planning and Development has a total revenue budget of $9,344,155. Through the quarter, planning and development related revenues total $5,184,032 or 55.48% of budget. Permit fees are down -16.00%, or $(354,661) compared K 2.0M 4.0M 6.0M 8.0M Q1 Q2 Q3 GENERAL FUND: SALES TAX FY2021 FY2022 FY2023 2 Quarterly Financial Report to the same quarter in FY2022. Development related permits year-to-date revenues are down- 24.42%, or $(1,073,634) compared to the same period in FY2022. Staff continues to monitor the amount of residential and commercial building permits. FY2023 development revenue and expenses are also being closely monitored for economic impacts. The following graph shows the number of residential building permits issued during through the third quarter for the past three years. Sanitation revenue budget totals $12,095,135. Through the quarter, year-to-date revenues from sanitation is $9,759,575, or 80.69% of budget. Sanitation rates increased as part of the FY2023 budget to support demand for service as well as to support the debt service for a new transfer station. The variance between the same period last year is $657,692, or 7.23%. Initial results of the environmental services cost of service study was presented to Council in February 2023. Staff will incorporate recommendations to rates to Council as part of the development of the FY2024 budget. Fire and EMS total budgeted revenue is $8,771,250. Through the quarter, Fire and EMS fee related revenue totals $6,154,367, or 70% of budget. Additional Fire/EMS revenue is comprised of the Interlocal Agreement Emergency Services District 8 contract for service, as well as public safety grants revenue. Parks and Recreation fee revenue budget totals $3,263,000. Through the quarter, parks and recreation related fee revenue totals $2,400,251, or 73.56% of budget. Parks and Recreation revenue is up 14.04% compared to FY2022. The Parks and Recreation department has seen an increase in revenue compared to FY2022 coupled with fee adjustments to align with the cost recovery model approved by Council, and programming returning to pre-pandemic levels. - 200 400 600 800 1,000 Q1 Q2 Q3 Residential Building Permits FY2021 FY2022 FY2023 3 Quarterly Financial Report FY2023 Revenue Projections: General Fund Quarterly Comparison: Q3 FY23 Budget FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2023 YTD Actuals: Q3 FY23 Variance % of Budget Projections FY2023 Variance Fav/(Unfav) % of Projection Revenue 40001:Property Taxes 18,700,000 17,409,781 (1,290,219) 93.10% 18,720,000 (1,310,219) 93.00% 40002:Sales Taxes 30,749,397 16,352,182 (14,397,215) 53.18% 28,619,207 (12,267,025) 57.14% 40005:Franchise Taxes 6,820,940 5,308,852 (1,512,088) 77.83% 7,777,503 (2,468,651) 68.26% 40008:Other Taxes 576,473 577,228 755 100.13% 670,000 (92,772) 86.15% 41001:Fines 270,800 323,044 52,244 119.29% 411,150 (88,106) 78.57% 41002:Penalties 111,348 96,218 (15,130) 86.41% 145,000 (48,782) 66.36% 42001:Interest Income 100,000 1,247,734 1,147,734 1247.73% 1,400,000 (152,266) 89.12% 43001:Fees 9,927,405 6,607,164 (3,320,241) 66.55% 9,581,113 (2,973,949) 68.96% 43002:Garbage Charges 12,095,135 9,759,575 (2,335,560) 80.69% 12,600,000 (2,840,425) 77.46% 43003:Permits 6,548,500 3,620,351 (2,928,149) 55.29% 5,038,000 (1,417,649) 71.86% 43004:Administrative Charges 2,000,000 1,333,339 (666,661) 66.67% 2,000,000 (666,661) 66.67% 43005:Rental Revenue 127,692 79,605 (48,087) 62.34% 91,192 (11,587) 87.29% 45001:Misc Revenue 883,850 821,854 (61,996) 92.99% 1,082,914 (261,060) 75.89% 45002:Insurance Proceeds - 8,947 8,947 0.00% 8,582 365 104.26% 45003:Misc Reimbursements - 609 609 0.00% 700 (91) 86.94% 45004:Sale of Property - 150,843 150,843 0.00% 150,802 41 100.03% 44001:Grant Revenue 40,000 2,250 (37,750) 5.63% 42,250 (40,000) 5.33% 44501:Contribution Revenue 145 - (145) 0.00% - - 0.00% 44502:Developer Contributions 264,018 1,769,169 1,505,151 670.09% 1,769,168 1 100.00% 44503:Interlocal Agreement Revenue 5,991,960 4,582,346 (1,409,614) 76.47% 5,991,960 (1,409,614) 76.47% 44504:Donations - 11,151 11,151 0.00% 11,152 (1) 99.99% 70001:Transfers In 1,765,500 1,765,500 - 100.00% 1,765,500 - 100.00% 70002:Transfers In - Payment in Lieu of Taxes (PILOT) 10,615,004 8,255,595 (2,359,409) 77.77% 11,550,000 (3,294,405) 71.48% Revenue Total 107,588,167 80,083,335 (27,504,832) 74.44% 109,426,193 (29,342,858) 73.18% Staff will continue to closely monitor FY2023 projections as the end of the fiscal year approaches. Total revenues are projected to end FY2023 at $109,426,193. Through the quarter, actuals are 73.18% of total projections which is in line with expectations. GENERAL FUND EXPENSES: Annual expenses through the quarter total $84,519,931, or 71.61% of budget. This is an increase of 27.37% compared to the same period last year. The increase is driven by increases in operational expense such as internal service allocations, timing of transfers, consulting fees and sanitation services. Additionally, general increases in expenses compared to the same period last year are due to inflation, staff compensation, and new or enhanced programs. Personnel and Operations Summary: Personnel costs through the quarter total $41,943,183, or 70.16% of personnel budget. Operational costs total $39,557,902, or 72.86%. The table below includes all expenditures in the General Fund. Capital costs can fluctuate from year-to-year based on projects, timing, and various other factors, primarily in the Streets cost center. 4 Quarterly Financial Report General Fund Quarterly Comparison: Q3 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2023 YTD Actuals: Q3 FY22 YTD Actuals: Q3 FY23 Variance % Of Budget Variance % Variance Expense Personnel 59,786,072 36,196,970 41,943,183 17,842,889 70.16% (5,746,212) 15.87% Operations 54,289,887 28,412,587 39,557,902 14,731,985 72.86% (11,145,315) 39.23% Operating Capital 747,309 743,154 368,790 378,519 49.35% 374,365 -50.38% Transfers 3,199,606 1,004,160 2,650,056 549,550 82.82% (1,645,896) 163.91% Total Expense 118,022,874 66,356,872 84,519,931 33,502,943 71.61% (18,163,058) 27.37% A complete list of cost center, and budget compared to actuals is attached as part of supplemental information to this report. Personnel and Operations Summary by Division: DEVELOPMENT SERVICES DIVISION: Through the quarter Planning has reported expenses totaling $2,009,019, or 54.75% of budget. The Planning Department has personnel savings due to vacancies. Year-to-date Planning operations expense is 74.24% over the same period in FY2022. This increase is due to the timing of updating the Unified Development Code that was approved by Council on October 25, 2022. Inspections incurred personnel and operational expenses amounting to $1,509,913, or 56.75% of budget. With a slowdown in development, Inspections can hold on outsourcing 3rd party apartment inspections as the City monitors overall General Fund revenue. The City budgeted $300,000 for 3rd party inspection in FY2023. Year-to-date personnel and operational expenditures for Community Services are as follows, Emergency Management cost center has a total of $246,218, or 60.85% of budget, through the quarter, Animal Services has reported $732,748, which is 56.98% of their budget, Code Compliance has shown spending of $447,599, or 64.49% of budget. Animal Services continues to have salary savings related to vacancies in their cost center. Environmental Services incurred personnel and operational expenditures amounting to $8,132,913, or 73.61% of budget. Public Works personnel and operational expenditures for the quarter totals $1,382,495, which represents 82.63% of budget. The higher than expected year-to-date includes one-time funding encumbered to update the City’s Overall Transportation Plan. Year-to-date expenditures related to personnel and operations for Streets totals $6,134,480, 76.91% of budget. The higher than expected year-to-date actuals in the Streets cost center is primarily due to tree and shrub removal services necessary in the aftermath of the winter storm. The City is covering those costs with the council Special Revenue Fund and is applying for reimbursement from FEMA. FINANCE ADMINISTRATION DIVISION: Municipal Court year-to-date expenses total $404,571, or 67.54% of budget. This spending includes $332,812 for personnel costs and $71,760 for operational costs. 5 Quarterly Financial Report POLICE OPERATIONS DIVISION: Police Operations saw personnel and operational expenditures through the quarter total $13,594,941, or 70.13% of budget. Police Administration expenditures through the quarter resulted in $2,037,145, or 67.79% of budget. FIRE AND EMS DIVISION: Year-to-date personnel and operational expenditures through the quarter total $3,990,644, or 81.23% of budget for Fire Support Services/Administration, $14,147,045, or 70.74% of budget for Fire Emergency Services, and $2,942,387, or 79.30% of budget for Fire EMS. ADMINISTRATIVE SERVICES DIVISION: Administrative Services saw operational and personnel costs totaling $1,856,689, or 60.48% of budget year-to-date. The cost center includes one-time funding for consulting, continuation of a “311 like” system, and studies that were not completed in FY2022. City Secretary personnel and operational expenditures for the quarter totals $1,057,075, which represents 68.36% of budget. Year-to-date personnel and operational expenditures for Communications totals $917,222, which represents 61.35% of budget. Non-Departmental includes a budget of $1,590,765 for transfers out to various funds. As of the third quarter, 82.82% of anticipated transfer expenses have been made. General Government Contracts includes budgeted vacancy savings estimates for all General Fund departments. Real vacancy savings is realized in each cost center. The budgeted vacancy factor against year-to-date actuals in the administrative division cost center drives the percent of budget up. Additionally, this is where the City budgets for various approved economic development related incentives. LIBRARY, TOURISM, AND ARTS AND CULTURE DIVISION: Arts and Culture recognized year to date expenses totaling $267,944, or 59.48% of budget. Lower than anticipated expenditures are tied to pausing on two Special Events and Marketing positions because of revenue uncertainty. As of the 2nd quarter, one position has been filled. Library year-to- date expenses total $2,474,252, or 66.39% of budget. PARKS AND RECREATION DIVISION: Year-to-date personnel and operations costs for Parks and Recreation within the following cost centers: Parks Administrations, Parks, Garey Park, Tennis Center, Recreation and, comes to a total of $7,415,297, or 65.12% of budget. Parks year-to-date through the quarter totals $2,143,472, or 60.43% of budget. Recreation total expenses are $3,606,851, which is 68.13% of budget. Garey Park year-to-date is $784,747, or 64.75% of budget. Personnel expenses in recreation are heavily seasonal, and a significant portion of part- time and temporary salaries will be reflected in the fourth quarter. 6 Quarterly Financial Report Personnel and Operations Summary by Division: General Fund Quarterly Comparison: Q3 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals FY2023 YTD Actuals: Q3 FY22 YTD Actuals: Q3 FY23 Variance % of Budget Development Services Personnel 8,476,062 4,213,889 5,164,029 3,312,033 60.92% Operations 21,347,568 9,970,385 15,812,627 5,534,941 74.07% Operating Capital 7,000 43,207 4,022 2,978 57.46% Development Services Total Expense 29,830,630 14,227,480 20,980,679 8,849,951 70.33% Finance Administration Personnel 489,044 335,150 332,812 156,232 68.05% Operations 109,973 76,183 71,760 38,213 65.25% Finance Administration Total Expense 599,017 411,334 404,571 194,446 67.54% Police Operations Personnel 16,264,597 10,204,954 11,587,161 4,677,436 71.24% Operations 5,812,678 3,583,552 3,926,391 1,886,288 67.55% Operating Capital 311,983 466,558 118,535 193,448 37.99% Police Operations Total Expense 22,389,258 14,255,064 15,632,086 6,757,172 69.82% Fire and EMS Personnel 22,215,323 14,138,587 16,435,359 5,779,964 73.98% Operations 6,163,946 3,996,841 4,533,728 1,630,218 73.55% Operating Capital 242,185 211,316 110,989 131,196 45.83% Fire and EMS Total Expense 28,621,454 18,346,744 21,080,076 7,541,378 73.65% Administrative Services, Arts and Culture Personnel 2,446,693 1,723,369 2,338,810 107,883 95.59% Operations 13,385,888 6,058,154 10,111,438 3,274,450 75.54% Operating Capital 51,641 8,163 6,101 45,540 11.81% Transfers 3,199,606 1,004,160 2,650,056 549,550 82.82% Administrative Services Total Expense 19,083,828 8,793,846 15,106,405 3,977,423 79.16% Library Personnel 2,275,834 1,311,278 1,450,241 825,593 63.72% Operations 1,449,962 1,006,886 1,013,708 436,254 69.91% Operating Capital 1,000 2,768 10,304 (9,304) 1030.36% Library Total Expense 3,726,796 2,320,932 2,474,252 1,252,544 66.39% Parks and Recreation Personnel 5,991,468 3,289,049 3,706,911 2,284,557 61.87% Operations 5,390,742 3,292,855 3,703,030 1,687,712 68.69% Operating Capital 5,000 8,068 5,356 (356) 107.13% Parks and Recreation Total Expense 11,387,210 6,589,972 7,415,297 3,971,913 65.12% Community Services Division Personnel 1,627,051 980,694 927,862 699,189 57.03% Operations 629,130 427,731 385,220 243,910 61.23% Operating Capital 128,500 3,076 113,483 15,017 88.31% Community Services Total Expense 2,384,681 1,411,500 1,426,564 958,117 59.82% General Fund Total 118,022,874 66,356,872 84,519,931 33,502,943 71.61% Overall, General Fund expenditures are within budget and the fund can cover the 90-day Contingency Reserve, Economic Stability Reserve, Master Development Fee Reserve (MDF) and the Benefit Payout Reserve. 7 Quarterly Financial Report FY2023 Expense Projections: General Fund Quarterly Comparison: Q3 FY23 Budget FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2023 YTD Actuals: Q3 FY23 Variance % Of Budget Projections FY2023 Variance Fav/(Unfav) % of Projection Expense Personnel 59,786,072 41,943,183 17,842,889 70.16% 58,966,063 17,022,881 71.13% Operations 54,289,887 39,557,902 14,731,985 72.86% 52,397,956 12,840,054 75.50% Operating Capital 747,309 368,790 378,519 49.35% 538,833 170,043 68.44% Transfers 3,199,606 2,650,056 549,550 82.82% 3,199,606 549,550 82.82% Total Expense 118,022,874 84,519,931 33,502,943 71.61% 115,102,458 30,582,528 73.43% Staff will continue to monitor FY2023 projections as the end of the fiscal year approaches. Total expenses are projected to end FY2023 at $115,102,458. Through the quarter, actual expenses are 73.43% of total projections. 8 Quarterly Financial Report Fund Schedule: General Fund Period: Jun-23 Budget Current Period FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2023 Jun-23 YTD Actuals: Q3 FY23 Variance % of Budget Projections FY2023 Variance Fav/(Unfav) % of Projection Beginning Fund Balance 37,517,635 37,517,635 - 100.00% 37,517,635 - 100.00% Revenue 40001:Property Taxes 18,700,000 73,298 17,409,781 (1,290,219) 93.10% 18,720,000 (1,310,219) 93.00% 40002:Sales Taxes 30,749,397 2,170,727 16,352,182 (14,397,215) 53.18% 28,619,207 (12,267,025) 57.14% 40005:Franchise Taxes 6,820,940 447,750 5,308,852 (1,512,088) 77.83% 7,777,503 (2,468,651) 68.26% 40008:Other Taxes 576,473 32,790 577,228 755 100.13% 670,000 (92,772) 86.15% 41001:Fines 270,800 40,782 323,044 52,244 119.29% 411,150 (88,106) 78.57% 41002:Penalties 111,348 10,525 96,218 (15,130) 86.41% 145,000 (48,782) 66.36% 42001:Interest Income 100,000 215,522 1,247,734 1,147,734 1247.73% 1,400,000 (152,266) 89.12% 43001:Fees 9,927,405 705,974 6,607,164 (3,320,241) 66.55% 9,581,113 (2,973,949) 68.96% 43002:Garbage Charges 12,095,135 967,210 9,759,575 (2,335,560) 80.69% 12,600,000 (2,840,425) 77.46% 43003:Permits 6,548,500 433,745 3,620,351 (2,928,149) 55.29% 5,038,000 (1,417,649) 71.86% 43004:Administrative Charges 2,000,000 166,667 1,333,339 (666,661) 66.67% 2,000,000 (666,661) 66.67% 43005:Rental Revenue 127,692 5,667 79,605 (48,087) 62.34% 91,192 (11,587) 87.29% 45001:Misc Revenue 883,850 190,197 821,854 (61,996) 92.99% 1,082,914 (261,060) 75.89% 45002:Insurance Proceeds - - 8,947 8,947 0.00% 8,582 365 104.26% 45003:Misc Reimbursements - - 609 609 0.00% 700 (91)86.94%45004:Sale of Property - 41 150,843 150,843 0.00% 150,802 41 100.03% 44001:Grant Revenue 40,000 - 2,250 (37,750) 5.63% 42,250 (40,000) 5.33% 44501:Contribution Revenue 145 - - (145) 0.00% - - 0.00% 44502:Developer Contributions 264,018 - 1,769,169 1,505,151 670.09% 1,769,168 1 100.00% 44503:Interlocal Agreement Revenue 5,991,960 1,392,500 4,582,346 (1,409,614) 76.47% 5,991,960 (1,409,614) 76.47% 44504:Donations - - 11,151 11,151 0.00% 11,152 (1)99.99%70001:Transfers In 1,765,500 1,765,500 1,765,500 - 100.00% 1,765,500 - 100.00%70002:Transfers In - Payment in Lieu of Taxes (PILOT) 10,615,004 1,110,770 8,255,595 (2,359,409) 77.77% 11,550,000 (3,294,405) 71.48%Revenue Total 107,588,167 9,729,666 80,083,335 (27,504,832) 74.44% 109,426,193 (29,342,858) 73.18% Expense CC0001 Non-Departmental 3,199,606 2,485,156 2,650,056 549,550 82.82% 3,199,606 (549,550) 82.82% CC0107 Planning 3,669,109 154,607 2,009,019 1,660,090 54.75% 2,814,753 (805,734) 71.37% CC0202 Parks Administration 757,322 61,290 518,270 239,052 68.43% 737,237 (218,967) 70.30% CC0210 Library 3,726,796 271,146 2,474,252 1,252,544 66.39% 3,484,182 (1,009,930) 71.01% CC0211 Parks 3,546,857 202,284 2,143,472 1,403,385 60.43% 3,138,455 (994,983) 68.30% CC0212 Recreation 5,293,737 519,323 3,606,851 1,686,886 68.13% 5,128,957 (1,522,106) 70.32% CC0213 Tennis Center 577,279 45,179 361,957 215,322 62.70% 540,371 (178,414) 66.98% CC0215 Garey Park 1,212,015 91,417 784,747 427,268 64.75% 1,148,627 (363,880) 68.32% CC0218 Arts and Culture 450,446 39,217 267,944 182,502 59.48% 432,392 (164,448) 61.97% CC0316 Municipal Court 599,017 48,536 404,571 194,446 67.54% 572,235 (167,664) 70.70% CC0402 Fire Support Services/Administration 4,912,473 421,224 3,990,644 921,829 81.23% 5,375,278 (1,384,633) 74.24% CC0422 Fire Emergency Services 19,998,506 1,445,539 14,147,045 5,851,461 70.74% 19,536,969 (5,389,924) 72.41% CC0448 EMS 3,710,475 271,062 2,942,387 768,088 79.30% 3,943,535 (1,001,148) 74.61% CC0533 Environmental Services 11,048,735 925,542 8,132,913 2,915,822 73.61% 10,703,395 (2,570,483) 75.98% CC0536 Inspection Services 2,660,618 159,306 1,509,913 1,150,705 56.75% 2,191,021 (681,109) 68.91% CC0602 Administrative Services 3,069,855 186,994 1,856,689 1,213,166 60.48% 3,066,024 (1,209,335) 60.56% CC0605 Emergency Management 404,656 20,665 246,218 158,438 60.85% 377,935 (131,717) 65.15% CC0634 City Council Services 249,313 20,007 142,994 106,319 57.36% 244,257 (101,264) 58.54% CC0635 City Secretary Services 1,546,421 144,699 1,057,075 489,346 68.36% 1,490,609 (433,535) 70.92% CC0638 General Government Contracts 11,018,633 673,171 9,399,591 1,619,042 85.31% 12,206,302 (2,806,710) 77.01% CC0654 Legal - - - - 0.00% 14,684 (14,684) 0.00% CC0655 Communications/Public Engagement 1,495,101 77,193 917,222 577,879 61.35% 1,401,791 (484,569) 65.43% CC0702 Police Administration 3,004,869 225,448 2,037,145 967,724 67.79% 2,926,634 (889,489) 69.61% CC0742 Police Operations 19,384,389 1,381,456 13,594,941 5,789,448 70.13% 18,906,407 (5,311,466) 71.91% CC0744 Animal Services 1,285,939 90,709 732,748 553,191 56.98% 1,056,754 (324,006) 69.34% CC0745 Code Compliance 694,086 51,307 447,599 246,487 64.49% 670,448 (222,850) 66.76% CC0802 Public Works 1,673,071 66,356 1,382,495 290,576 82.63% 1,608,086 (225,591) 85.97% CC0846 Streets 7,975,763 392,058 6,134,480 1,841,283 76.91% 7,249,643 (1,115,163) 84.62% CC0847 Transportation Planning 857,787 53,241 626,693 231,094 73.06% 935,870 Expense Total 118,022,874 10,524,131 84,519,931 33,502,943 71.61% 115,102,458 30,582,528 73.43% Excess (Deficiency) of Total Revenue over Total Requirements (10,434,707) (794,466) (4,436,596) 5,998,111 42.52% (5,676,265) 1,239,670 78.16% Ending Fund Balance 27,082,928 33,081,039 5,998,111 122.15% 31,841,370 1,239,670 103.89% Reserves MDF Reserve 1,700,000 - 1,700,000 - 100.00% 3,200,000 1,500,000 53.13% AFR Adjustment - - - - 0.00% (229,148) (229,148) 0.00% Benefit Payout Reserve 340,000 - 340,000 - 100.00% 340,000 - 100.00%Contingency Reserve 18,166,659 - 18,166,659 - 100.00% 18,166,659 - 100.00% Economic Stability Reserve 5,881,366 - 5,881,366 - 100.00% 5,881,366 - 100.00%Reserves Total 26,088,025 - 26,088,025 - 100.00% 27,358,877 1,270,852 95.35% Available Fund Balance 994,903 - 6,993,014 5,998,111 702.88% 4,482,493 2,510,522 156.01% 9 Quarterly Financial Report Expense by Cost Center: General Fund Quarterly Comparison: Q3 FY23 Budget FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2023 YTD Actuals: Q3 FY23 Variance % of Budget Projections FY2023 Variance Fav/(Unfav) % of Projection Planning Personnel 2,056,100 1,129,796 926,304 54.95% 1,713,131 583,335 65.95% Operations 1,613,009 879,223 733,786 54.51% 1,101,622 222,399 79.81% Operating Capital - - -0.00% - - 0.00% Planning Total Expense 3,669,109 2,009,019 1,660,090 54.75% 2,814,753 805,734 71.37% Library Personnel 2,275,834 1,450,241 (138,962) 63.72% 2,070,180 619,939 70.05% Operations 1,449,962 1,013,708 (6,822) 69.91% 1,414,002 400,294 71.69% Operating Capital 1,000 10,304 (7,536) 1030.36% -(10,304) 0.00% Library Total Expense 3,726,796 2,474,252 (153,320) 66.39% 3,484,182 1,009,930 71.01% Parks Administration Personnel 344,404 250,343 94,061 72.69% 330,085 79,742 75.84% Operations 412,918 412,918 0.00% 407,152 407,152 0.00% Parks Administration Total Expense 757,322 518,270 239,052 68.43% 737,237 218,967 70.30% Parks Personnel 1,970,163 1,103,443 866,720 56.01% 1,644,909 541,466 67.08% Operations 1,571,694 1,034,673 537,021 65.83% 1,493,546 458,873 69.28% Operating Capital 5,000 5,356 (356) 107.13% -(5,356)0.00% Parks Total Expense 3,546,857 2,143,472 1,403,385 60.43% 3,138,455 994,983 68.30% Recreation Personnel 2,785,216 1,774,449 1,010,767 63.71% 2,576,357 801,908 68.87% Operations 2,508,521 1,832,402 676,119 73.05% 2,552,600 720,198 71.79% Recreation Total Expense 5,293,737 3,606,851 1,686,886 68.13% 5,128,957 1,522,106 70.32% Tennis Center Personnel 287,685 174,279 113,406 60.58% 269,439 95,160 64.68% Operations 289,594 187,678 101,916 64.81% 270,932 83,254 69.27% Tennis Center Total Expense 577,279 361,957 215,322 62.70% 540,371 178,414 66.98% Garey Park Personnel 604,000 404,397 199,603 66.95% 584,330 179,933 69.21% Operations 608,015 380,350 227,665 62.56% 564,297 183,947 67.40% Operating Capital - - -0.00% - - 0.00% Garey Park Total Expense 1,212,015 784,747 427,268 64.75% 1,148,627 363,880 68.32% Arts and Culture Personnel 322,766 184,756 138,010 57.24% 310,766 126,010 59.45% Operations 127,680 83,187 44,493 65.15% 121,626 38,439 68.40% Arts and Culture Total Expense 450,446 267,944 182,502 59.48% 432,392 164,448 61.97% Municipal Court Personnel 489,044 332,812 156,232 68.05% 462,192 129,380 72.01% Operations 109,973 71,760 38,213 65.25% 110,043 38,283 65.21% Municipal Court Total Expense 599,017 404,571 194,446 67.54% 572,235 167,664 70.70% 10 Quarterly Financial Report Fire Support Services/Administration Personnel 2,811,182 2,445,988 365,194 87.01% 3,260,082 814,094 75.03% Operations 2,101,291 1,544,657 556,634 73.51% 2,115,196 570,539 73.03% Operating Capital - - -0.00% - - 0.00% Fire Administration Total Expense 4,912,473 3,990,644 921,829 81.23% 5,375,278 1,384,633 74.24% Fire Emergency Services Personnel 16,625,913 11,781,831 4,844,082 70.86% 16,293,394 4,511,563 72.31% Operations 3,177,993 2,283,998 893,995 71.87% 3,037,975 753,977 75.18% Operating Capital 194,600 81,215 113,385 41.73% 205,600 124,385 39.50% Fire Emergency Services Total Expense 19,998,506 14,147,045 5,851,461 70.74% 19,536,969 5,389,924 72.41% EMS Personnel 2,778,228 2,207,540 570,688 79.46% 3,034,750 827,210 72.74% Operations 884,662 705,073 179,589 79.70% 861,200 156,127 81.87% Operating Capital 47,585 29,774 17,811 62.57% 47,585 17,811 62.57% EMS Total Expense 3,710,475 2,942,387 768,088 79.30% 3,943,535 1,001,148 74.61% Inspection Services Personnel 2,031,074 1,308,010 723,064 64.40% 1,874,886 566,876 69.76% Operations 629,544 201,902 427,642 32.07% 316,135 114,233 63.87% Inspection Services Total Expense 2,660,618 1,509,913 1,150,705 56.75% 2,191,021 681,109 68.91% Administrative Services Personnel 2,172,309 1,517,293 655,016 69.85% 2,133,022 615,729 71.13% Operations 890,905 333,295 557,610 37.41% 926,361 593,066 35.98% Operating Capital 6,641 6,101 540 91.87% 6,641 540 91.87% Administrative Services Total Expense 3,069,855 1,856,689 1,213,166 60.48% 3,066,024 1,209,335 60.56% Emergency Management Personnel 159,329 89,308 70,021 56.05% 148,619 59,310 60.09% Operations 116,827 43,427 73,400 37.17% 117,764 74,337 36.88% Operating Capital 128,500 113,483 15,017 88.31% 111,552 (1,931) 101.73% Community Services Total Expense 404,656 246,218 158,438 60.85% 377,935 131,717 65.15% City Secretary Personnel 800,688 557,356 243,332 69.61% 763,066 205,710 73.04% Operations 745,733 499,719 246,014 67.01% 727,543 227,824 68.69% City Secretary Total Expense 1,546,421 1,057,075 489,346 68.36% 1,490,609 433,535 70.92% Communications/ Public Engagement Personnel 795,902 515,804 280,098 64.81% 759,787 243,983 67.89% Operations 699,199 401,418 297,781 57.41% 642,004 240,586 62.53% Communications Total Expense 1,495,101 917,222 577,879 61.35% 1,401,791 484,569 65.43% Police Administration Personnel 674,234 481,800 192,434 71.46% 660,377 178,577 72.96% Operations 2,330,635 1,555,345 775,290 66.73% 2,266,257 710,912 68.63% Police Administration Total Expense 3,004,869 2,037,145 967,724 67.79% 2,926,634 889,489 69.61% 11 Quarterly Financial Report Police Operations Personnel 15,590,363 11,105,361 4,485,002 71.23% 15,567,776 4,462,416 71.34% Operations 3,482,043 2,371,045 1,110,998 68.09% 3,171,176 800,131 74.77% Operating Capital 311,983 118,535 193,448 37.99% 167,455 48,920 70.79% Police Operations Total Expense 19,384,389 13,594,941 5,789,448 70.13% 18,906,407 5,311,466 71.91% Animal Services Personnel 899,814 489,402 410,412 54.39% 714,114 224,712 68.53% Operations 386,125 243,346 142,779 63.02% 342,640 99,294 71.02% Animal Services Total Expense 1,285,939 732,748 553,191 56.98% 1,056,754 324,006 69.34% Code Compliance Personnel 567,908 349,151 218,757 61.48% 529,880 180,729 65.89% Operations 126,178 98,447 27,731 78.02% 140,568 42,121 70.04% Operating Capital - - -0.00% - - 0.00% Code Compliance Total Expense 694,086 447,599 246,487 64.49% 670,448 222,850 66.76% Public Works Personnel 597,658 422,709 174,949 70.73% 585,149 162,440 72.24% Operations 1,075,413 959,786 115,627 89.25% 1,022,937 63,151 93.83% Operating Capital - - -0.00% - - 0.00% Public Works Total Expense 1,673,071 1,382,495 290,576 82.63% 1,608,086 225,591 85.97% Streets Personnel 2,157,640 1,201,518 956,122 55.69% 1,753,585 552,066 68.52% Operations 5,814,623 4,928,939 885,684 84.77% 5,496,058 567,119 89.68% Operating Capital 3,500 4,022 (522) 114.93% -(4,022) 0.00% Streets Total Expense 7,975,763 6,134,480 1,841,283 76.91% 7,249,643 1,115,163 84.62% Environmental Services Personnel 188,660 117,262 71,398 62.16% 181,506 64,244 64.60% Operations 10,856,575 8,015,651 2,840,924 73.83% 10,521,889 2,506,238 76.18% Operating Capital 3,500 - 3,500 0.00% - - 0.00% Environmental Services Total Expense 11,048,735 8,132,913 2,915,822 73.61% 10,703,395 2,570,483 75.98% Non-Departmental Operations - - -0.00% - - 0.00% Transfers 3,199,606 2,650,056 549,550 82.82% 3,199,606 549,550 82.82% Non-Departmental Total Expense 3,199,606 2,650,056 549,550 82.82% 3,199,606 549,550 -17.18% General Government Contracts Personnel (700,000) 151,660 (851,660) -21.67% 160,311 8,651 94.60% Operations 11,673,633 9,247,932 2,425,701 79.22% 12,045,991 2,798,059 76.77% Operating Capital 45,000 - 45,000 0.00% - - 0.00% General Government Contracts Total Expense 11,018,633 9,399,591 1,619,042 85.31% 12,206,302 2,806,710 77.01% City Council Services Personnel 173,696 112,501 61,195 64.77% 165,340 52,839 68.04% Operations 75,617 30,493 45,124 40.33% 78,917 48,424 38.64% City Council Services Total Expense 249,313 142,994 106,319 57.36% 244,257 101,264 58.54% 12 Quarterly Financial Report Transportation Planning Personnel 326,262 284,173 42,089 87.10% 404,345 120,172 70.28% Operations 531,525 342,520 189,005 64.44% 531,525 189,005 64.44% Transportation Planning Total Expense 857,787 626,693 231,094 73.06% 935,870 309,177 66.96% Legal Personnel - - - - 14,684 14,684 0.00% Legal Total Expense - - - - 14,684 14,684 0.00% General Fund Total Expense 118,022,874 84,519,931 33,502,943 71.61% 115,102,458 30,582,528 73.43% 13 Quarterly Financial Report UTILITY FUNDS: As part of the FY2023 budget development process, the utilities reviewed various initiatives to improve resiliency to extreme weather, including those required by legislation. Both utilities continue to refine cost of service studies to ensure that rates cover these resiliency efforts, the growth pressure and infrastructure demand on the system, and financial targets for liquidity and fixed cost coverage. Based on the updated water master plan and water cost of service study, Council adopted the FY2023 budget, which includes water and wastewater rate increases. Additional rate increases are necessary to fund capital projects, water resources, and inflationary cost impacts. Staff will bring forward proposed rate increases for FY2024 of 13% across the board for water and sewer. Miscellaneous utility fees were also increased in the adopted budget to recover current costs of service for tasks like a trip charge. The Electric cost of service study is ongoing. Electric Fund: The City continues to employ several strategies to maintain the improved performance of the Electric Fund in relation to past and current expenditures for purchased power contracts. These strategies include reviewing rates, recovering the costs of new development, selling Renewable Energy Credits (RECs), and contracting professional services for energy portfolio management and risk oversight. ELECTRIC REVENUE: Operating revenue in the Electric Fund totals $74,235,121 through the quarter, or 67.03% of budget. Electric sales revenue, the largest component of operating revenue, has brought in $60,956,041 through the quarter, totaling 67.35% of Electric charges budget. Adjusted meter load (AML) is up approximately 2% compared to Q3 of last fiscal year. Renewable Energy Credit Sales, located in the fees category, has not seen prices as favorable as last fiscal year. Developer contributions were budgeted at $11,600,000. Year-to-date collection totals $7,009,554, or 60.43% of budget. Developer contributions drive the need for utility infrastructure. There is aa decrease in developer contributions revenue compared to the same period of the prior year. For the current fiscal year, developer contributions were conservatively budgeted because of the unknown economic impact of inflation and other economic factors. Year- to-date actuals for developer contributions are aligning with the budgeted amount. Within the Fee category, the Renewable Energy Credit (REC) revenue budget is $3,082,821. REC sales total $1,797,349, or 58.30% of budget through the quarter. K 5.0M 10.0M 15.0M 20.0M 25.0M 30.0M Q1 Q2 Q3 Electric Fund: Electric Sales Charges FY2021 FY2022 FY2023 14 Quarterly Financial Report Electric Services Quarterly Comparison: Q3 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2023 YTD Actuals: Q3 FY22 YTD Actuals: Q3 FY23 Variance % of Budget Variance % Variance Operating Revenue 40002:Sales Taxes 5,500 4,841 5,030 (470) 91.46% 189 3.90% 41002:Penalties 630,000 564,204 530,069 (99,931) 84.14% (34,135) -6.05% 42001:Interest Income 45,000 92,929 983,313 938,313 2185.14% 890,384 958.13% 43001:Fees 4,878,866 2,872,175 2,441,225 (2,437,641) 50.04% (430,951) -15.00% 43003:Permits - - - - 0.00% -0.00% 43004:Administrative Charges 3,079,852 2,654,784 2,309,889 (769,963) 75.00% (344,895) -12.99% 43601:Electric Sales Charges 90,511,753 58,854,753 60,956,041 (29,555,712) 67.35% 2,101,289 3.57% 44502:Developer Contributions 11,600,000 9,887,553 7,009,554 (4,590,446) 60.43% (2,877,999) -29.11% Operating Revenue Total 110,750,971 74,931,240 74,235,121 (36,515,850) 67.03% (696,118) -0.93% Non-Operating Revenue 45001:Misc Revenue 37,748 163,401 88,193 50,445 233.64% (75,208) -46.03% 45003:Misc Reimbursements - 5,475 - - 0.00% (5,475) -100.00% 45004:Sale of Property - 52,331 11,869 11,869 0.00% (40,462) -77.32% 44001:Grant Revenue - 339,612 255,775 255,775 0.00% (83,837) -24.69% 46001:Bond Proceeds 15,750,000 17,995,000 14,350,000 (1,400,000) 91.11% (3,645,000) -20.26% 46002:Bond Premium - 1,644,584 1,242,342 1,242,342 0.00% (402,242) -24.46% Non-Operating Revenue Total 15,787,748 20,200,402 15,948,178 160,430 101.02% (4,252,224) -21.05% Revenue Total 126,538,719 95,131,642 90,183,300 (36,355,419) 71.27% (4,948,342) -5.20% The budget for non-operating revenue totals $15,787,748 in FY2023. Year-to-date grant revenue recognizes $255,775 in reimbursed costs from TXDOT for FM 1460 Road Widening. As part of annual debt process, the City recognized bond proceeds in the spring to cover the costs of capital infrastructure and equipment and are reflected in the third quarter report. 15 Quarterly Financial Report FY2023 REVENUE PROJECTIONS: Electric Services Quarterly Comparison: Q3 FY23 Budget FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2023 YTD Actuals: Q3 FY23 Variance % of Budget Projections FY2023 Variance Fav/(Unfav) % of Projection Operating Revenue 40002:Sales Taxes 5,500 5,030 (470)91.46% 6,870 (1,840) 73.22% 41002:Penalties 630,000 530,069 (99,931) 84.14% 630,000 (99,931) 84.14% 42001:Interest Income 45,000 983,313 938,313 2185.14% 903,000 80,313 108.89% 43001:Fees 4,878,866 2,441,225 (2,437,641) 50.04% 4,499,876 (2,058,651) 54.25% 43003:Permits - - - 0.00% 91,330 (91,330) 0.00% 43004:Administrative Charges 3,079,852 2,309,889 (769,963) 75.00% 3,079,852 (769,963) 75.00% 43601:Electric Sales Charges 90,511,753 60,956,041 (29,555,712) 67.35% 89,854,772 (28,898,731) 67.84% 44502:Developer Contributions 11,600,000 7,009,554 (4,590,446) 60.43% 11,600,000 (4,590,446) 60.43% Operating Revenue Total 110,750,971 74,235,121 (36,515,850) 67.03% 110,665,700 (36,430,579) 67.08% Non-Operating Revenue 45001:Misc Revenue 37,748 88,193 50,445 233.64% 95,450 (7,257) 92.40% 45003:Misc Reimbursements - - - 0.00% - - 0.00% 45004:Sale of Property - 11,869 11,869 0.00% 12,000 (131)98.91% 44001:Grant Revenue - 255,775 255,775 0.00% 255,775 (0)100.00% 46001:Bond Proceeds 15,750,000 14,350,000 (1,400,000) 91.11% 14,350,000 - 100.00% 46002:Bond Premium - 1,242,342 1,242,342 0.00% 1,242,341 1 100.00% Non-Operating Revenue Total 15,787,748 15,948,178 160,430 101.02% 15,955,566 (7,388) 99.95% Revenue Total 126,538,719 90,183,300 (36,355,419) 71.27% 126,621,266 (36,437,966) 71.22% Staff will continue to monitor FY2023 projections as the end of the fiscal year approaches. It is anticipated that there will be an impact to power sales and purchases from the hot and dry months during the summer. Total revenues are projected to end FY2023 at $126,621,266. Through the quarter, actuals are $90,183,300, or 71.22% of total year-end projections. ELECTRIC EXPENSES: Operating expenses in the Electric Fund total $74,186,969 through the quarter. Year-to-date purchase power expenses total $57,342,584 while Net congestion revenue rights (CRRs) credits total $1,829,567. The City continues to use a hedging strategy for the winter and summer months to avoid price spikes in the market. The City was adequately hedged (compliant with the hedging policy) for the extreme cold temperatures for December 22 – 24, 2022. Actual peak demand exceeded forecast which required additional purchases. The total power costs for this event was $1M over budget. Year-to-date, purchased power expense net of REC revenue was $7.5M over budget. The City adjusted the Purchase Power budget as part of the mid-year amendment in May 16 Quarterly Financial Report to account for the increase in costs. The summer months of June, July, and August were extremely hot and dry. Additional power was purchased to meet demand. Total power costs are still projected to be near the amended budget amount. Electric Engineering and Transmission and Distribution (T&D) cost centers look inflated due to the capitalization of labor being budgeted in capital expense while the actuals are booked to the operating budget. The labor will be capitalized to the appropriate capital improvement project on the final year-end financial statements. Electric Services Quarterly Comparison: Q3 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2023 YTD Actuals: Q3 FY22 YTD Actuals: Q3 FY23 Variance % of Budget Variance % Variance Operating Expense CC0001 Non- Departmental 6,635,000 5,401,388 4,686,555 1,948,445 70.63% 714,833 -13.23% CC0521 Operational Technology 2,302,363 721,902 1,381,634 920,729 60.01% (659,732) 91.39% CC0522 Electric Administration 10,802,539 7,034,863 7,772,614 3,029,925 71.95% (737,750) 10.49% CC0523 Electric Safety and Employee Development 550,038 218,479 257,218 292,820 46.76% (38,739) 17.73% CC0524 Metering Services - 1,214,576 - - 0.00% 1,214,576 -100.00% CC0525 T&D Services 2,252,885 3,143,964 3,414,970 (1,162,085) 151.58% (271,006) 8.62% CC0534 Conservation - - (7) 7 0.00% 7 0.00% CC0537 Electric Resource Management 69,969,249 43,913,914 53,255,705 16,713,544 76.11% (9,341,791) 21.27% CC0555 Electric Systems Operations 2,227,004 1,234,314 1,538,413 688,591 69.08% (304,099) 24.64% CC0557 Electrical Engineering 1,807,245 1,368,008 1,879,866 (72,622) 104.02% (511,858) 37.42% Operating Expense Total 96,546,323 64,251,408 74,186,969 22,359,354 76.84% (9,935,560) 15.46% Non-Operating Expense CC0001 Non- Departmental 11,327,692 1,566,100 1,777,894 9,549,798 15.70% (211,793) 13.52% CC0557 Electrical Engineering 32,606,732 10,863,036 15,006,961 17,599,771 46.02% (4,143,925) 38.15% Non-Operating Expense Total 43,934,424 12,429,136 16,784,855 27,149,569 38.20% (4,355,718) 35.04% Expense Total 140,480,747 76,680,545 90,971,823 49,508,923 64.76% (14,291,279) 18.64% The Electric department reorganized several personnel and operating expenses between cost centers and created new cost centers as part of the development of the FY2023 budget. These changes as well as employee reorganizations result in some variances compared to the same quarter the prior year. 17 Quarterly Financial Report Non-operating expenditures are budgeted at $43,934,424 in FY2023. Budgeted non-operating expenditures include $32,606,732 for capital projects and $11,327,692 for debt service payments. The FY2023 Capital Project Roll Forward amendment included $13,643,888 million of active projects. These encumbrances combined with increased New Development, shows an accelerated CIP spending in Electric Engineering compared to the previous year. In order to keep up with new development CIP related projects, staff amended the Electric CIP budget as part of the roll forward budget amendment. As previously mentioned, a significant portion of labor expenses for capital projects will be journaled at the end of the fiscal year, bringing operations and capital expense in balance with their budgets. The Electric Fund anticipates meeting all the fund’s below line reserve requirements in FY2023. The contingency requirements include the 90-day operating contingency as well as the non- operating contingency reserve to align with industry standards and bond rating requirements, The 90-day operating contingency is $3,882,758, a non-operating reserve totaling $7,199,718, reserve for transformer of $4,069,154, as well as a rate stabilization reserve in the amount of $25,600,000. In FY2023, the City will continue to review Electric cost of service in light of increased capital costs, potential changes in net metering, potential changes in the ERCOT market design, and updated timelines to new industrial loads. FY2023 EXPENSE PROJECTIONS: Staff will monitor FY2023 projections as the end of the fiscal year approaches. Total expenses are projected to end FY2023 at $139,125,851. Through the quarter, actual expenses are 65.39% of total projections. Electric Services Quarterly Comparison: Q3 FY23 Budget FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2023 YTD Actuals: Q3 FY23 Variance % of Budget Projections 2022 Variance Fav/(Unfav) % of Projections Operating Expense CC0001 Non-Departmental 6,635,000 4,686,555 1,948,445 70.63% 6,560,000 1,873,445 71.44% CC0521 Operational Technology 2,302,363 1,381,634 920,729 60.01% 2,013,619 631,985 68.61% CC0522 Electric Administration 10,802,539 7,772,614 3,029,925 71.95% 11,070,020 3,297,407 70.21% CC0523 Electric Safety and Employee Development 550,038 257,218 292,820 46.76% 341,564 84,346 75.31% CC0524 Metering Services - - - 0.00% - - 0.00% CC0525 T&D Services 2,252,885 3,414,970 (1,162,085) 151.58% 2,209,348 (1,205,622) 154.57% CC0534 Conservation - (7) 7 0.00% - 7 0.00% CC0537 Electric Resource Management 69,969,249 53,255,705 16,713,544 76.11% 69,969,249 16,713,544 76.11% CC0555 Electric Systems Operations 2,227,004 1,538,413 688,591 69.08% 2,129,791 591,378 72.23% CC0557 Electrical Engineering 1,807,245 1,879,866 (72,622) 104.02% 897,836 (982,031) 209.38% Operating Expense Total 96,546,323 74,186,969 22,359,354 76.84% 95,191,427 21,004,458 77.93% Non-Operating Expense CC0001 Non-Departmental 11,327,692 1,777,894 9,549,798 15.70% 11,327,692 9,549,798 15.70% CC0557 Electrical Engineering 32,606,732 15,006,961 17,599,771 46.02% 32,606,732 17,599,771 46.02% Non-Operating Expense Total 43,934,424 16,784,855 27,149,569 38.20% 43,934,424 27,149,569 38.20% Expense Total 140,480,747 90,971,823 49,508,923 64.76% 139,125,851 48,154,027 65.39% 18 Quarterly Financial Report Fund Schedule: Electric Services Period: Jun-23 Budget Current Period FY2023 FY2023 Year-to-date: Budget Vs. Actuals FY2023 Year-End: Projections Vs. Actuals FY2023 Jun-23 YTD Actuals Variance % of Budget Projections Variance Fav/(Unfav) % of Projection Beginning Fund Balance 56,529,870 56,529,870 -100.00% 56,529,870 -100.00% Operating Revenue 40002:Sales Taxes 5,500 797 5,030 (470)91.46% 6,870 (1,840) 73.22% 41002:Penalties 630,000 57,584 530,069 (99,931) 84.14% 630,000 (99,931) 84.14% 42001:Interest Income 45,000 156,872 983,313 938,313 2185.14% 903,000 80,313 108.89% 43001:Fees 4,878,866 184,316 2,441,225 (2,437,641) 50.04% 4,499,876 (2,058,651) 54.25% 43003:Permits - - - - 0.00% 91,330 (91,330) 0.00% 43004:Administrative Charges 3,079,852 769,963 2,309,889 (769,963) 75.00% 3,079,852 (769,963) 75.00% 43601:Electric Sales Charges 90,511,753 9,228,262 60,956,041 (29,555,712) 67.35% 89,854,772 (28,898,731) 67.84% 44502:Developer Contributions 11,600,000 584,470 7,009,554 (4,590,446) 60.43% 11,600,000 (4,590,446) 60.43% Total Operating Revenue 110,750,971 10,982,266 74,235,121 (36,515,850) 67.03% 110,665,700 (36,430,579) 67.08% Operating Expense CC0001 Non-Departmental 6,635,000 1,029,399 4,686,555 1,948,445 70.63% 6,560,000 1,873,445 71.44% CC0521 Operational Technology 2,302,363 123,322 1,381,634 920,729 60.01% 2,013,619 631,985 68.61% CC0522 Electric Administration 10,802,539 827,741 7,772,614 3,029,925 71.95% 11,070,020 3,297,407 70.21% CC0523 Electric Safety and Employee Development 550,038 23,880 257,218 292,820 46.76% 341,564 84,346 75.31% CC0524 Metering Services - - - - 0.00% - - 0.00% CC0525 T&D Services 2,252,885 341,074 3,414,970 (1,162,085) 151.58% 2,209,348 (1,205,622) 154.57% CC0534 Conservation - (6) (7) 7 0.00% - 7 0.00% CC0537 Electric Resource Management 69,969,249 5,339,938 53,255,705 16,713,544 76.11% 69,969,249 16,713,544 76.11% CC0555 Electric Systems Operations 2,227,004 156,869 1,538,413 688,591 69.08% 2,129,791 591,378 72.23% CC0557 Electrical Engineering 1,807,245 148,639 1,879,866 (72,622) 104.02% 897,836 (982,031) 209.38% Total Operating Expense 96,546,323 7,990,857 74,186,969 22,359,354 76.84% 95,191,427 21,004,458 77.93% Net Operations Total 14,204,648 48,153 (58,875,204) 0.34% 15,474,273 (15,426,120) 0.31% Non-Operating Revenue 45001:Misc Revenue 37,748 103 88,193 50,445 233.64% 95,450 (7,257) 92.40% 45003:Misc Reimbursements - - - - 0.00% - - 0.00% 45004:Sale of Property - 3,011 11,869 11,869 0.00% 12,000 (131)98.91%44001:Grant Revenue - - 255,775 255,775 0.00% 255,775 (0)100.00% 46001:Bond Proceeds 15,750,000 14,350,000 14,350,000 (1,400,000) 91.11% 14,350,000 -100.00%46002:Bond Premium - 1,242,342 1,242,342 1,242,342 0.00% 1,242,341 1 100.00% Total Non-Operating Revenue 15,787,748 15,595,456 15,948,178 160,430 101.02% 15,955,566 (7,388) 99.95% Non-Operating Expense CC0001 Non-Departmental 11,327,692 151,592 1,777,894 9,549,798 15.70% 11,327,692 9,549,798 15.70% CC0557 Electrical Engineering 32,606,732 625,554 15,006,961 17,599,771 46.02% 32,606,732 17,599,771 46.02% Total Non-Operating Expense 43,934,424 777,146 16,784,855 27,149,569 38.20% 43,934,424 27,149,569 38.20% Excess (Deficiency) of Total Revenue over Total Requirements (13,942,028) 17,809,719 (788,524) 13,153,504 5.66% (12,504,585) 11,716,061 6.31% Ending Fund Balance 42,587,842 55,741,346 13,153,504 130.89% 44,025,285 11,716,061 126.61% Reserves Rate Stabilization 25,600,000 25,600,000 -100.00% 25,600,000 -100.00%Non-Operating Reserve 7,199,718 7,199,718 -100.00% 7,199,718 -100.00%Operating Contingency Reserve 3,882,758 3,882,758 -100.00% 3,882,758 -100.00%Transformer Reserve 4,069,154 4,069,154 -100.00% 4,069,154 -100.00%Reserves Total 40,751,630 40,751,630 -100.00% 40,751,630 -100.00% Available Fund Balance 1,836,212 14,989,716 13,153,504 816.34% 3,273,655 11,716,061 457.89% 19 Quarterly Financial Report Water Fund: WATER REVENUE: Year-to-date Operating revenue totals $145,200,697, or 113.77% of budget. The largest revenue streams in the Water Fund are charges for services for water, wastewater, and irrigation use and impact fees. Through the quarter, Water Charges total $36,315,380, which is 71.87% of budget. Year-to-date, Wastewater Charges are $15,524,912, or 74.70% of budget. Irrigation Charges total $310,439 for the quarter, or 67.15% of budget. Increases in number of meters and customers as well as rate increase effective October 1, 2022, have proven to significantly increase year-to-date revenues for the Water Fund to support operation and future infrastructure needs. Transfer in for the quarter totals $45,985,888. Transfers represent an offsetting interfund transfer from the development impact fee “child” fund to the water capital project “child” fund for impact fee eligible projects. To be conservative, staff make these transfers mid-year, after the prior years actuals impact fee revenue has be reconciled. The budget for Impact Fees for the fiscal year is $44,800,000. Through the quarter, impact fee revenues total $28,614,392, or 63.87% of budget. The decrease in impact fees is attributed to a slowdown related to the macro-economy. Impact fees are used for funding capital infrastructure approved in the impact fee plan. They may be used as a cash equivalent, or to repay debt service for impact fee eligible projects. Staff continues to monitor impact fee revenue as it is heavily driven by development. Water Quarterly Comparison: Q3 FY23 Budget FY2022 FY2023 Quarterly Comparison Quarterly Comparison FY2023 YTD Actuals: Q3 FY22 YTD Actuals: Q3 FY23 Variance % of Budget Variance % Variance Operating Revenue 41002:Penalties 440,000 463,102 553,287 113,287 125.75% 90,184 19.47% 42001:Interest Income 470,519 720,747 12,040,371 11,569,852 2558.96% 11,319,624 1570.54% 43001:Fees 9,625,640 10,935,427 4,257,229 (5,368,411) 44.23% (6,678,198) -61.07% 43003:Permits - - (1,000) (1,000) 0.00% (1,000) 0.00% 43005:Rental Revenue 60,000 61,030 16,425 (43,575) 27.38% (44,605) -73.09% 43602:Water Charges 50,530,586 31,697,105 36,315,380 (14,215,206) 71.87% 4,618,276 14.57% 43603:Wastewater Charges 20,784,153 12,506,564 15,524,912 (5,259,241) 74.70% 3,018,348 24.13% 43604:Irrigation Charges 462,329 286,000 310,439 (151,890) 67.15% 24,439 8.54% 41602:Impact Fees 44,800,000 33,947,690 28,614,392 (16,185,608) 63.87% (5,333,298) -15.71% 44502:Developer Contributions 450,000 549,480 1,583,374 1,133,374 351.86% 1,033,894 188.16% 70001:Transfers In - 115,000 45,985,888 45,985,888 0.00% 45,870,888 39987.73% Operating Revenue Total 127,623,227 91,282,146 145,200,697 17,577,470 113.77% 53,918,551 59.07% K 5.0M 10.0M 15.0M 20.0M 25.0M FY2021 FY2022 FY2023 FY2021 FY2022 FY2023 FY2021 FY2022 FY2023 Q1 Q2 Q3 Water Charges Water Wastewater Irrigation 20 Quarterly Financial Report Non-Operating Revenue 45001:Misc Revenue 1,380,998 272,126 204,923 (1,176,075) 14.84% (67,202) -24.70% 45002:Insurance Proceeds - - 151,300 151,300 0.00% 151,300 0.00% 45003:Misc Reimbursements -113 1,454 1,454 0.00% 1,342 1192.77% 44001:Grant Revenue 7,000,000 304,745 - (7,000,000) 0.00% (304,745) -100.00% 44504:Donations - - 1,740 1,740 0.00% 1,740 0.00% 46001:Bond Proceeds 97,385,000 202,385,000 90,845,000 (6,540,000) 93.28% (111,540,000) -55.11% 46002:Bond Premium - 12,759,165 7,528,998 7,528,998 0.00% (5,230,167) -40.99% Non-Operating Revenue Total 105,765,998 215,721,148 98,733,416 (7,032,582) 93.35% (116,987,732) -54.23% Revenue Total 233,389,225 307,003,293 243,934,113 10,544,888 104.52% (63,069,181) -20.54% Total Water Fund operating revenue is up 59.07% compared to the same period last fiscal year due to growth in sales and interest earnings, as well as due to timing of the impact fee transfers. Through the quarter water consumption is down 6% compared to the same period of FY2022. June, July, and Ausgust were very hot and dry resulting in increased demand for irrigation. In August, the City issued Stage 3 water restrictions to customers in the south western service area to protect system pressure and provide clean drikning water. The City is actively working to bring in addiitional water from Leander and complete the Southside treatment plant rehabilitation project. All other customers remain in Stage 2 water restrictions. The budget for non-operating revenue totals $105,765,998 in FY2023. This total includes bond proceeds for capital projects in the amount of $97,385,000. The majority of this is for the Southlake Treatment Plant, System Resiliency, Pecan Branch Wastewater Treatment Plant, and the San Gabriel Wastewater Treatment Plant. In addition to bond proceeds, $48,740,000 of impact fees will be used on eligible projects in FY2023. The cost-of-service study continues to be evaluated for current and future needs of the water fund. The FY2023 budget includes an 11.5% increase in rates across all customer classes. The increase was necessary to increase equity between consumer classes and to pay for the debt service and operating costs of new infrastructure as well as to rehabilitate existing wastewater infrastructure. Additional rate increases are expected over the next 3 – 5 years to meet demand for capital infrastructure. The Council recently adopted increases to water and wastewater impact fees to offset capital costs. The FY2024 budget proposes a 13% across the board rate increase to continue the investment in system resiliency and rehab the more than 30 year-old wastewater treatment plants. K 200K 400K 600K 800K 1.0M 1.2M WATER FUND: CONSUMPTION (KGALS) FY2020 FY2021 FY2022 FY2023 21 Quarterly Financial Report FY2023 REVENUE PROJECTIONS: Water Quarterly Comparison: Q3 FY23 Budget FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2023 YTD Actuals: Q3 FY23 Variance % of Budget Projections FY2023 Variance Fav/(Unfav) % of Projections Operating Revenue 41002:Penalties 440,000 553,287 113,287 125.75% 723,000 (169,713) 76.53% 42001:Interest Income 470,519 12,040,371 11,569,852 2558.96% 12,510,000 (469,629) 96.25% 43001:Fees 9,625,640 4,257,229 (5,368,411) 44.23% 6,188,820 (1,931,591) 68.79% 43003:Permits - (1,000) (1,000) 0.00% - (1,000)0.00% 43005:Rental Revenue 60,000 16,425 (43,575) 27.38% 30,000 (13,575) 54.75% 43602:Water Charges 50,530,586 36,315,380 (14,215,206) 71.87% 53,847,000 (17,531,620) 67.44% 43603:Wastewater Charges 20,784,153 15,524,912 (5,259,241) 74.70% 19,000,000 (3,475,088) 81.71% 43604:Irrigation Charges 462,329 310,439 (151,890) 67.15% 500,000 (189,561) 62.09% 41602:Impact Fees 44,800,000 28,614,392 (16,185,608) 63.87% 44,800,000 (16,185,608) 63.87% 44502:Developer Contributions 450,000 1,583,374 1,133,374 351.86% 1,700,000 (116,626) 93.14% 70001:Transfers In - 45,985,888 45,985,888 0.00% 73,625,708 (27,639,820) 62.46% Operating Revenue Total 127,623,227 145,200,697 17,577,470 113.77% 212,924,528 (67,723,831) 68.19% Non-Operating Revenue 45001:Misc Revenue 1,380,998 204,923 (1,176,075) 14.84% 1,402,218 (1,197,295) 14.61% 45002:Insurance Proceeds - 151,300 151,300 0.00% - 151,300 0.00% 45003:Misc Reimbursements - 1,454 1,454 0.00% - 1,454 0.00% 44001:Grant Revenue 7,000,000 - (7,000,000) 0.00% - - 0.00% 44504:Donations - 1,740 1,740 0.00% - 1,740 0.00% 46001:Bond Proceeds 97,385,000 90,845,000 (6,540,000) 93.28% 90,845,000 - 100.00%46002:Bond Premium - 7,528,998 7,528,998 0.00% 7,528,998 (0)100.00% Non-Operating Revenue Total 105,765,998 98,733,416 (7,032,582) 93.35% 99,776,216 (1,042,800) 98.95% Revenue Total 233,389,225 243,934,113 10,544,888 104.52% 312,700,744 (68,766,631) 78.01% Staff will continue to monitor FY2023 projections as the end of the fiscal year approaches. With a prolonged hot and dry summer, both sales revenues and operating expenses are projected to exceed the budget. Total revenues are projected to end FY2023 at $312,700,744. Through the quarter, actuals are 78.01% of total projections. 22 Quarterly Financial Report WATER EXPENSES: Operating expenditures in the Water Fund total $103,045,048 through the quarter, or 122.43% of budget. Operating expenditures in FY2023 are 113.19% greater than the same period in FY2022. This is primarily due to the rising costs of raw water, chemicals, and the unbudgeted transfer of impact fees from the impact fee fund to the water project fund. As mentioned previously, the transfer is offset with a transfer in. Water Services Financial Report Quarterly Comparison: Q3 FY23 Budget FY2022 FY2023 Quarterly Comparison Quarterly Comparison FY2023 YTD Actuals: Q3 FY22 YTD Actuals: Q3 FY23 Variance % of Budget Variance % Variance Operating Expense CC0001 Non-Departmental 7,065,896 4,492,189 5,435,386 1,630,510 76.92% (943,198) 21.00% CC0524 Metering Services 2,887,914 23 1,735,323 1,152,591 60.09% (1,735,300) 7512119.70% CC0526 Systems Engineering 409,970 - - 409,970 0.00% - 0.00% CC0527 Water Services Administration 39,602,900 28,197,641 31,235,378 8,367,522 78.87% (3,037,737) 10.77% CC0528 Water Distribution 10,533,253 2,321,883 48,099,639 (37,566,386) 456.65% (45,777,756) 1971.58% CC0529 Water Plant Management 6,481,091 4,659,551 4,372,439 2,108,652 67.46% 287,112 -6.16%CC0530 Wastewater Operations 2,631,957 706,202 1,545,927 1,086,030 58.74% (839,725) 118.91% CC0531 Wastewater Plant Management 6,748,576 4,054,150 5,616,298 1,132,278 83.22% (1,562,149) 38.53% CC0532 Irrigation Operations 478,150 137,807 229,801 248,349 48.06% (91,995) 66.76% CC0535 Water Conservation 1,539,423 332,130 907,200 632,223 58.93% (575,070) 173.15% CC0553 Water Operations 5,785,557 3,434,012 3,867,656 1,917,901 66.85% (433,645) 12.63% Operating Expense Total 84,164,687 48,335,587 103,045,048 (18,880,361) 122.43% (54,709,462) 113.19% Non-Operating Expense CC0001 Non-Departmental 1,323,000 2,053,548 1,215,171 107,829 91.85% 838,378 -40.83% CC0526 Systems Engineering 449,092,830 215,870,075 218,280,637 230,812,192 48.60% (2,410,562) 1.12% CC0532 Irrigation Operations 79,743 7,507 5,319 74,424 6.67% 2,188 -29.15% CC0530 Wastewater Operations 3,353,674 492,440 679,744 2,673,930 20.27% (187,304) 38.04% CC0553 Water Operations 25,269,678 1,915,109 7,966,375 17,303,303 31.53% (6,051,266) 315.97% CC0524 Metering Services 7,750,000 - 8,168,419 (418,419) 105.40% (8,168,419) 0.00% Non-Operating Expense Total 486,868,925 220,338,680 236,315,665 250,553,260 48.54% (15,976,985) 7.25% Expense 571,033,612 268,674,267 339,360,714 231,672,898 146.48% (70,686,447) 26.31% Non-operating expense are budgeted at $486,868,925 in FY2023. Expenses total $236,315,665 or 48.54% of budget through the quarter. The majority of the non-operating expense funds were dedicated to construction of capital improvement projects which were not completed in FY2022. These funds were re-appropriated in FY2023 as the treatment plant, distribution, metering and weather resiliency projects will take multiple years to complete. 23 Quarterly Financial Report FY2023 EXPENSE PROJECTIONS: Water Services Financial Report Quarterly Comparison: Q3 FY23 Budget FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year End: Projections Vs. Actuals FY2023 YTD Actuals: Q3 FY23 Variance % of Budget Projections FY2023 Variance Fav/(Unfav) % of Projection Operating Expense CC0001 Non-Departmental 7,065,896 5,435,386 1,630,510 76.92% 8,019,074 2,583,688 67.78% CC0524 Metering Services 2,887,914 1,735,323 1,152,591 60.09% 3,245,050 1,509,727 53.48% CC0526 Systems Engineering 409,970 - 409,970 0.00% 409,970 409,970 0.00% CC0527 Water Services Administration 39,602,900 31,235,378 8,367,522 78.87% 36,728,395 5,493,017 85.04% CC0528 Water Distribution 10,533,253 48,099,639 (37,566,386) 456.65% 78,528,705 30,429,066 61.25% CC0529 Water Plant Management 6,481,091 4,372,439 2,108,652 67.46% 6,051,033 1,678,595 72.26% CC0530 Wastewater Operations 2,631,957 1,545,927 1,086,030 58.74% 2,937,148 1,391,221 52.63% CC0531 Wastewater Plant Management 6,748,576 5,616,298 1,132,278 83.22% 6,709,942 1,093,644 83.70% CC0532 Irrigation Operations 478,150 229,801 248,349 48.06% 482,668 252,867 47.61% CC0535 Water Conservation 1,539,423 907,200 632,223 58.93% 1,490,030 582,830 60.88% CC0553 Water Operations 5,785,557 3,867,656 1,917,901 66.85% 5,402,100 1,534,444 71.60% Operating Expense Total 84,164,687 103,045,048 (18,880,361) 122.43% 150,004,116 46,959,068 68.69% Non-Operating Expense CC0001 Non-Departmental 1,323,000 1,215,171 107,829 91.85% 1,323,000 107,829 91.85% CC0526 Systems Engineering 449,092,830 218,280,637 230,812,192 48.60% 449,092,830 230,812,193 48.60% CC0532 Irrigation Operations 79,743 5,319 74,424 6.67% 79,743 74,424 6.67% CC0530 Wastewater Operations 3,353,674 679,744 2,673,930 20.27% 3,353,674 2,673,930 20.27% CC0553 Water Operations 25,269,678 7,966,375 17,303,303 31.53% 25,269,678 17,303,303 31.53% CC0524 Metering Services 7,750,000 8,168,419 (418,419) 105.40% 7,750,000 (418,419) 105.40% Non-Operating Expense Total 486,868,925 236,315,665 250,553,260 48.54% 486,868,925 250,553,260 48.54% Expense 571,033,612 339,360,714 231,672,898 146.48% 636,873,041 297,512,328 53.29% Staff will continue to monitor FY2023 projections as the end of the fiscal year approaches. Total expenses are projected to end FY2023 at $636,873,041. Through the quarter, actual expenses are 113.19% of total projections. Many large multi-year capital project encumbrances will roll forward into FY2023. The Water Fund anticipates meeting all the fund’s below line reserve requirements in FY2023. Contingency requirements include a 90-day operating contingency of $11,697,446, a non- operating reserve of $10,579,391, and an Impact Fee reserve of $33,518,865. In August, the City entered into a Groundwater Reservation Agreement with EPCOR. The annual fee is approximately $6 million. The City will use available water fund balance to cover the fee expense while exploring regional partnerships. Additional rate increases related to the agreement may be proposed during FY2024. 24 Quarterly Financial Report Fund Schedule: Water Services Period: Jun-23 Budget Current Period FY2023 Budget Vs. Actuals Year-End: Projections Vs Actuals FY2023 Jun-23 YTD Actuals: Q3 FY23 Variance % of Budget Projections FY2023 Variance Fav/(Unfav) % of Projection Beginning Fund Balance 423,824,302 423,824,302 - 100.00% 423,824,302 - 100.00% Operating Revenue 41002:Penalties 440,000 55,076 553,287 113,287 125.75% 723,000 (169,713) -23.47% 42001:Interest Income 470,519 1,946,929 12,040,371 11,569,852 2558.96% 12,510,000 (469,629) 96.25% 43001:Fees 9,625,640 486,690 4,257,229 (5,368,411) 44.23% 6,188,820 (1,931,591) 68.79% 43003:Permits - - (1,000) (1,000) 0.00% - (1,000) 0.00% 43005:Rental Revenue 60,000 - 16,425 (43,575) 27.38% 30,000 (13,575) 54.75% 43602:Water Charges 50,530,586 5,624,422 36,315,380 (14,215,206) 71.87% 53,847,000 (17,531,620) 67.44% 43603:Wastewater Charges 20,784,153 1,766,792 15,524,912 (5,259,241) 74.70% 19,000,000 (3,475,088) 81.71% 43604:Irrigation Charges 462,329 50,149 310,439 (151,890) 67.15% 500,000 (189,561) 62.09% 41602:Impact Fees 44,800,000 2,463,482 28,614,392 (16,185,608) 63.87% 44,800,000 (16,185,608) 63.87% 44502:Developer Contributions 450,000 1,013,385 1,583,374 1,133,374 351.86% 1,700,000 (116,626) 93.14% 70001:Transfers In - 45,985,888 45,985,888 45,985,888 0.00% 73,625,708 (27,639,820) 62.46% Total Operating Revenue 127,623,227 59,392,813 145,200,697 17,577,470 113.77% 212,924,528 (67,723,831) 68.19% Operating Expenses CC0001 Non-Departmental 7,065,896 2,173,569 5,435,386 1,630,510 76.92% 8,019,074 2,583,688 67.78% CC0524 Metering Services 2,887,914 141,080 1,735,323 1,152,591 60.09% 3,245,050 1,509,727 53.48% CC0526 Systems Engineering 409,970 - - 409,970 0.00% 409,970 409,970 0.00% CC0527 Water Services Administration 39,602,900 6,065,542 31,235,378 8,367,522 78.87% 36,728,395 5,493,017 85.04% CC0528 Water Distribution 10,533,253 45,884,687 48,099,639 (37,566,386) 456.65% 78,528,705 30,429,066 61.25% CC0529 Water Plant Management 6,481,091 475,028 4,372,439 2,108,652 67.46% 6,051,033 1,678,595 72.26% CC0530 Wastewater Operations 2,631,957 256,765 1,545,927 1,086,030 58.74% 2,937,148 1,391,221 52.63% CC0531 Wastewater Plant Management 6,748,576 408,628 5,616,298 1,132,278 83.22% 6,709,942 1,093,644 83.70% CC0532 Irrigation Operations 478,150 37,182 229,801 248,349 48.06% 482,668 252,867 47.61% CC0535 Water Conservation 1,539,423 36,274 907,200 632,223 58.93% 1,490,030 582,830 60.88% CC0553 Water Operations 5,785,557 434,432 3,867,656 1,917,901 66.85% 5,402,100 1,534,444 71.60% Operating Expense Total 84,164,687 55,913,186 103,045,048 (18,880,361) 122.43% 150,004,116 46,959,068 68.69% Available Operating Fund Balance 43,458,540 - 42,155,648 36,457,831 - 62,920,412 (20,764,763) 67.00% Non-Operating Revenue 45001:Misc Revenue 1,380,998 (72,045) 204,923 (1,176,075) 14.84% 1,402,218 (1,197,295) 14.61% 45002:Insurance Proceeds - 151,300 151,300 151,300 0.00% - 151,300 0.00% 45003:Misc Reimbursements - 1,454 1,454 1,454 0.00% - 1,454 0.00% 44001:Grant Revenue 7,000,000 - - (7,000,000) 0.00% - - 0.00% 44504:Donations - - 1,740 1,740 0.00% - 1,740 0.00% 46001:Bond Proceeds 97,385,000 90,845,000 90,845,000 (6,540,000) 93.28% 90,845,000 - 100.00% 46002:Bond Premium - 7,528,998 7,528,998 7,528,998 0.00% 7,528,998 (0) 100.00% Non-Operating Revenue Total 105,765,998 98,454,707 98,733,416 (7,032,582) 93.35% 99,776,216 (1,042,800) 98.95% Non-Operating Expenses CC0001 Non-Departmental 1,323,000 986,746 1,215,171 107,829 91.85% 1,323,000 (107,829) 91.85% CC0524 Metering Services 7,750,000 - 8,168,419 (418,419) 105.40% 7,750,000 418,419 105.40% CC0526 Systems Engineering 449,092,830 7,622,148 218,280,637 230,812,192 48.60% 449,092,830 (230,812,193) 48.60% CC0530 Wastewater Operations 3,353,674 505 679,744 2,673,930 20.27% 3,353,674 (2,673,930) 20.27% CC0532 Irrigation Operations 79,743 25 5,319 74,424 6.67% 79,743 (74,424) 6.67% CC0553 Water Operations 25,269,678 38,562 7,966,375 17,303,303 31.53% 25,269,678 (17,303,303) 31.53% Non-Operating Expense Total 486,868,925 8,647,986 236,315,665 250,553,260 48.54% 486,868,925 250,553,260 48.54% Excess (Deficiency) of Total Revenue over Total Requirements (337,644,387) (405,874,801) (95,426,601) 242,217,786 28.26% (324,172,297) 228,745,696 29.44% Ending Fund Balance 86,179,915 - 328,397,701 242,217,786 381.06% 99,652,005 228,745,696 329.54% Reserves Contingency Reserve 11,697,446 - 11,697,446 - 100.00% 11,697,446 - 100.00% Non-Operating Reserve 10,579,391 - 10,579,391 - 100.00% 10,579,391 - 100.00% Impact Fee Reserve 33,518,865 - 33,518,865 - 100.00% 33,518,865 - 100.00% Reserves Total 55,795,702 55,795,702 - 100.00% 55,795,702 - 100.00% Available Fund Balance 30,384,213 - 272,601,999 242,217,786 897.18% 43,856,303 228,745,696 621.58% 25 Quarterly Financial Report TOURISM FUND REVENUES: The COVID-19 pandemic significantly impacted the tourism sector, the City continues to see improvement in revenues in the fund. Year-to- date revenue in the fund totals $1,471,133, or 87.83% of budget. Hotel Occupancy Tax revenue in this fund year-to-date totals $1,232,465 through the quarter, or 82.16% of budget. Through this quarter, Hotel Occupancy Tax revenue is $92,083 higher than, or, 8.07% of year-to-date actuals of the previous fiscal year. Georgetown hosted several large-scale community events in April 2023, including the inaugural Two-Step Inn Music Festival and the 24th Annual Red Poppy Festival. The Two-Step Inn was held in San Gabriel Park and generated 100% occupancy for hotels, B&Bs, and short-term rentals. The event contributed a significant amount of tourism-related spending with local businesses. The Red Poppy Festival continues to be an important revenue-generating event for businesses that benefit from the weekend-long activities in downtown. It also creates a nearly 100% hotel occupancy rate for the hoteliers in the community. The HOT revenues for 2023 set a new record for April, with monthly revenues totaling $186,438. This revenue is the highest recorded amount for any month of any year, thus far. Tourism Fund Quarterly Comparison: Q3 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2023 YTD Actuals: Q3 FY22 YTD Actuals: Q3 FY23 Variance % of Budget Variance % Variance Revenues 40008:Other Taxes 1,500,000 1,140,382 1,232,465 (267,535) 82.16% 92,083 8.07% 42001:Interest Income 5,000 4,759 61,350 56,350 1227.00% 56,591 1189.23% 45001:Misc Revenue 120,000 135,642 100,318 (19,682) 83.60% (35,323) -26.04% 44001:Grant Revenue - 538 - - 0.00% (538) -100.00% 44505:Sponsorship 50,000 59,000 77,000 27,000 154.00% 18,000 30.51% Revenue Total 1,675,000 1,340,319 1,471,133 (203,867) 87.83% 130,813 9.76% K 100K 200K 300K 400K 500K 600K Q1 Q2 Q3 HOTEL OCCUPANCY TAX FY2021 FY2022 FY2023 26 Quarterly Financial Report FY2023 Revenue Projections: Tourism Fund Quarterly Comparison: Q3 FY23 Budget FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projection Vs. Actuals FY2023 YTD Actuals: Q3 FY23 Variance % of Budget Projections FY2023 Variance Fav/(Unfav) % of Projection Revenues 40008:Other Taxes 1,500,000 1,232,465 (267,535) 82.16% 1,900,000 (667,535) 64.87% 42001:Interest Income 5,000 61,350 56,350 1227.00% 60,000 1,350 102.25% 45001:Misc Revenue 120,000 100,318 (19,682) 83.60% 106,268 (5,950) 94.40% 44001:Grant Revenue - - - 0.00% - - 0.00% 44505:Sponsorship 50,000 77,000 27,000 154.00% 86,000 (9,000) 89.53% Revenue Total 1,675,000 1,471,133 (203,867) 87.83% 2,152,268 (681,135) 68.35% Staff will monitor FY2023 projections as the end of the fiscal year approaches. Total revenues are projected to end FY2023 at $2,152,268. Through the quarter, actuals are 68.35% of total projections. TOURISM FUND EXPENSES: The Operating expense budget for the Tourism Fund totals $1,977,317, which includes a $60,500 transfer out to the General Fund to support Arts and Culture programming. Year-to-date operating expenses total $1,385,805, or 70.09% of budget. The city has returned to the regular spring timing of the annual Red Poppy Festival. Expenses are increased over the prior year due to the new allocation model requiring the Tourism fund to transfer funds to the General and Joint Services Fund for support provided and increased spending in tv and radio advertising for a Hogaboom Road Brand Ambassador Agreement. Tourism Fund Quarterly Comparison: Q3 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2023 YTD Actuals: Q3 FY22 YTD Actuals: Q3 FY23 Variance % of Budget Variance % Variance Expenses CC0001 Non-Departmental 60,500 52,407 60,500 - 100.00% (8,093) 115.44% CC0208 CVB 1,650,865 900,931 1,067,003 583,862 64.63% (166,072) 18.43% CC0254 Poppy Festival 265,952 241,106 258,302 7,650 97.12% (17,196) 7.13% Expense Total 1,977,317 1,194,444 1,385,805 591,512 70.09% (191,361) 16.02% FY2023 Expense Projections: Tourism Fund Quarterly Comparison: Q3 FY23 Budget FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2023 YTD Actuals: Q3 FY23 Variance % of Budget Projections FY2023 Variance Fav/(Unfav) % of Projection Expenses CC0001 Non-Departmental 60,500 60,500 - 100.00% 60,500 - 100.00% CC0208 CVB 1,650,865 1,067,003 583,862 64.63% 1,542,728 475,725 69.16% CC0254 Poppy Festival 265,952 258,302 7,650 97.12% 263,531 5,229 98.02% Expense Total 1,977,317 1,385,805 591,512 70.09% 1,866,759 480,954 74.24% 27 Quarterly Financial Report Staff will continue to monitor FY2023 projections as the end of the fiscal year approaches. Total expenses are projected to end FY2023 at $1,866,759. Through the quarter, actual expenses are 74.24% of total projections. Overall, Tourism Fund expenditures are within budget and the fund can cover the 90-day Contingency Reserve. Ending fund balance is budgeted to be $2,023,130 in FY2023 with an operating contingency reserve of $379,320, and a capital reserve of $1,643,810. Fund Schedule: Tourism Period: Jun-23 Budget Current Period FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2023 Jun-23 YTD Actuals w/Encumbrances Variance % ofBudget Projections Variance Fav/(Unfav) % of Projection Beginning Fund Balance 2,325,447 2,325,447 -100.00% 2,325,447 -100.00% Revenue 40008:Other Taxes 1,500,000 150,944 1,232,465 (267,535) 82.16% 1,900,000 (667,535) 64.87% 42001:Interest Income 5,000 11,023 61,350 56,350 1227.00% 60,000 1,350 102.25% 45001:Misc Revenue 120,000 2,941 100,318 (19,682) 83.60% 106,268 (5,950) 94.40% 44001:Grant Revenue - - - - 0.00% - - 0.00% 44505:Sponsorship 50,000 - 77,000 27,000 154.00% 86,000 (9,000) 89.53% Total Revenue 1,675,000 164,909 1,471,133 (203,867) 87.83% 2,152,268 (681,135) 68.35% Expense Personnel 523,512 35,822 352,201 171,311 67.28% 504,674 152,474 69.79% Operations 1,393,305 61,329 973,105 420,200 69.84% 1,301,585 328,480 74.76% Transfers 60,500 60,500 60,500 - 100.00% 60,500 - 100.00% Total Expense 1,977,317 157,651 1,385,805 591,512 70.09% 1,866,759 480,954 74.24% Excess (Deficiency) of Total Revenue over Total Requirements (302,317) 7,258 85,327 387,644 -28.22% 285,509 (200,181) 29.89% Ending Fund Balance 2,023,130 7,258 2,410,774 387,644 117.74% 2,610,956 (200,181) 92.33% Reserves Capital Reserve 1,643,810 - 1,643,810 - 100.00% 1,643,810 - 100.00% Contingency Reserve 379,320 - 379,320 - 100.00% 379,320 - 100.00% Reserves Total 2,023,130 2,023,130 - 100.00% 2,023,130 - 100.00% Available Fund Balance - - 387,644 387,644 0.00% 587,826 (200,181) 65.95% 28 Quarterly Financial Report AIRPORT FUND REVENUES: Airport operating revenue budget totals $4,728,499. Airport Charges, the largest segment of revenue, totals $4,150,430 year- to-date. This includes revenue for fuel sales, facility lease, and hangar rentals. Total operating revenues through the quarter are $4,498,332, or 95.13% of budget. Revenues are trending higher than anticipated due to increases in the price fuel and fuel sales, which has a related fuel expense, and an increase to land lease revenue. Non-operating revenue consists of grant revenue for capital projects and miscellaneous revenue. The grant revenue budget was rolled forward from FY2022 and is intended for the Taxiway Lightning Project. Total non-operating revenue through the quarter is $62,300. Airport Fund Quarterly Comparison: Q3 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2022 YTD Actuals: Q3 FY22 YTD Actuals: Q3 FY23 Variance % of Budget Variance % Variance Operating Revenue 40001:Property Taxes 61,800 - - (61,800) 0.00% - 0.00%42001:Interest Income 4,249 130,832 90,668 86,419 2133.87% (40,164) -30.70% 43005:Rental Revenue 267,250 125,178 257,234 (10,016) 96.25% 132,057 105.50% 43606:Airport Charges 4,395,200 3,816,899 4,150,430 (244,770) 94.43% 333,531 8.74% Operating Revenue Total 4,728,499 4,072,909 4,498,332 (230,167) 95.13% 425,423 10.45% Non-Operating Revenue 45001:Misc Revenue 2,340 7,962 3,300 960 141.03% (4,662) -58.55% 44001:Grant Revenue 22,654 36,901 59,000 36,346 260.44% 22,099 59.89% 46001:Bond Proceeds - 495,000 - - 0.00% (495,000) -100.00% 46002:Bond Premium - 21,289 - - 0.00% (21,289) -100.00% Non-Operating Revenue Total 24,994 561,152 62,300 37,306 249.26% (498,852) -88.90% Total Revenue 4,753,493 4,634,061 4,560,632 (192,861) 95.94% (73,429) -1.58% K 500K 1.0M 1.5M Q1 Q2 Q3 AIRPORT FUND - FUEL SALES FY2021 FY2022 FY2023 29 Quarterly Financial Report FY2023 Revenue Projections: Airport Fund Quarterly Comparison: Q3 FY23 Budget FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2022 YTD Actuals: Q3 FY23 Variance % of Budget Projections FY2023 Variance Fav/(Unfav) % of Projection Operating Revenue 40001:Property Taxes 61,800 - (61,800) 0.00% 60,000 (60,000) 0.00% 42001:Interest Income 4,249 90,668 86,419 2133.87% 95,000 (4,332) 95.44% 43005:Rental Revenue 267,250 257,234 (10,016) 96.25% - 257,234 0.00% 43606:Airport Charges 4,395,200 4,150,430 (244,770) 94.43% 5,713,075 (1,562,645) 72.65% Operating Revenue Total 4,728,499 4,498,332 (230,167) 95.13% 5,868,075 (1,369,743) 76.66% Non-Operating Revenue 45001:Misc Revenue 2,340 3,300 960 141.03% 3,500 (200) 94.29% 44001:Grant Revenue 22,654 59,000 36,346 260.44% 22,654 36,346 260.44% 46001:Bond Proceeds - - - 0.00% - - 0.00% 46002:Bond Premium - - - 0.00% - - 0.00% Non-Operating Revenue Total 24,994 62,300 37,306 249.26% 26,154 36,146 238.20% Total Revenue 4,753,493 4,560,632 (192,861) 95.94% 5,894,229 (1,333,597) 77.37% Staff will monitor FY2023 projections as the end of the fiscal year approaches. Total revenues are projected to end FY2023 at $5,894,229. Through the quarter, actuals are 77.37% of total projections. AIRPORT FUND EXPENSES: Operating expenses in the Airport fund include a budget of $5,287,895. Year-to-date operation expenses totals $5,810,012. Most of the operations budget is fuel for sales, which is encumbered early in the fiscal year. Staff may need to bring the Airport Fund for a year-end amendment to increase fuel revenue and expenses. Year-to-date operating capital is $225,566, or 378.12% of budget. This total includes a one-time purchase for a 50 foot trailer mounted boom lift. The budget for non-operating expenses total $1,645,023. This includes a CIP expense of $1,424,000 for the construction of a maintenance facility at the airport. Staff included additional funding as part of the rollforward budget amendment as the costs of the facility increased after the design and bid. The remaining amount of non-operating expense is for the airport’s debt service payment. The debt payment will be made in the summer to align with the City’s annual debt schedule. Airport Fund Quarterly Comparison: Q3 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2023 YTD Actuals: Q3 FY22 YTD Actuals: Q3 FY23 Variance % of Budget Variance % Variance Operating Expense Personnel 578,699 292,989 404,035 174,664 69.82% (111,046) 37.90% Operations 4,527,542 3,442,563 5,058,410 (530,868) 111.73% (1,615,848) 46.94% Operating Capital 59,654 110,938 225,566 (165,912) 378.12% (114,628) 103.33% Transfers 122,000 - 122,000 - 100.00% (122,000) 0.00% Total Operating Expenses 5,287,895 3,846,490 5,810,012 (522,117) 109.87% (1,963,522) 51.05% Non-Operating Expense CIP Expense 1,424,000 - 116,000 1,308,000 8.15% (116,000) 0.00% Debt Service 221,023 49,886 47,137 173,886 21.33% 2,749 -5.51% Non-Operating Expense Total 1,645,023 49,886 163,137 1,481,886 9.92% 113,251 227.02% 30 Quarterly Financial Report Expense Total 6,932,918 3,896,376 5,973,148 959,770 86.16% 2,076,773 53.30% FY2023 Expense Projections: Airport Fund Quarterly Comparison: Q3 FY23 Budget FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2023 YTD Actuals: Q3 FY23 Variance % of Budget Projections FY2023 Variance Fav/(Unfav) % of Projection Operating Expense Personnel 578,699 404,035 174,664 69.82% 583,545 179,510 69.24% Operations 4,527,542 5,058,410 (530,868) 111.73% 5,441,206 382,796 92.96% Operating Capital 59,654 225,566 (165,912) 378.12% 221,076 (4,490) 102.03% Transfers 122,000 122,000 - 100.00% 122,000 - 100.00% Total Operating Expenses 5,287,895 5,810,012 (522,117) 109.87% 6,367,827 557,815 91.24% Non-Operating Expense CIP Expense 1,424,000 116,000 1,308,000 8.15% 1,424,000 1,308,000 8.15% Debt Service 221,023 47,137 173,886 21.33% 221,023 173,886 21.33% Non-Operating Expense Total 1,645,023 163,137 1,481,886 9.92% 1,645,023 1,481,886 9.92% Expense Total 6,932,918 5,973,148 959,770 86.16% 8,012,850 2,039,702 74.54% Staff will continue to monitor FY2023 projections as the end of the fiscal year approaches. Total expenses are projected to end FY2023 at $8,012,850. Through the quarter, actual expenses are 74.54% of total projections. 31 Quarterly Financial Report Fund Schedule: Airport Operations Period: Jun-23 Budget Current Period FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2023 Jun-23 YTD Actuals w/Encumbrances Variance % of Budget Projections Variance Fav/(Unfav) % of Projection Beginning Fund Balance 3,274,625 3,274,625 -100.00% 3,274,625 -100.00% Operating Revenues 40001:Property Taxes 61,800 - - (61,800) 0.00% 60,000 (60,000) 0.00% 42001:Interest Income 4,249 14,428 90,668 86,419 2133.87% 95,000 (4,332) 95.44% 43005:Rental Revenue 267,250 30,266 257,234 (10,016) 96.25% - 257,234 0.00% 43606:Airport Charges 4,395,200 464,855 4,150,430 (244,770) 94.43% 5,713,075 (1,562,645) 72.65% Total Operating Revenues 4,728,499 509,549 4,498,332 (230,167) 95.13% 5,868,075 (1,369,743) 76.66% Operating Expenses Personnel 578,699 46,906 404,035 174,664 69.82% 583,545 179,510 69.24% Operations 4,527,542 438,347 5,058,410 (530,868) 111.73% 5,441,206 382,796 92.96% Operating Capital 59,654 - 225,566 (165,912) 378.12% 221,076 (4,490) 102.03% Transfers 122,000 122,000 122,000 -100.00% 122,000 -100.00% Total Operating Expenses 5,287,895 607,253 5,810,012 (522,117) 109.87% 6,367,827 557,815 91.24% Non-Operating Revenues 45001:Misc Revenue 2,340 1,500 3,300 960 141.03% 3,500 (200) 94.29% 44001:Grant Revenue 22,654 59,000 59,000 36,346 260.44% 22,654 36,346 260.44% 46001:Bond Proceeds - - - - 0.00% - - 0.00% 46002:Bond Premium - - - - 0.00% - - 0.00% Total Non-Operating Revenues 24,994 60,500 62,300 37,306 249.26% 26,154 36,146 238.20% Non-Operating Expenses CIP Expense 1,424,000 12,230 116,000 1,308,000 8.15% 1,424,000 1,308,000 8.15% Debt Service 221,023 - 47,137 173,886 21.33% 221,023 173,886 21.33% Total Non-Operating Expenses 1,645,023 12,230 163,137 1,481,886 9.92% 1,645,023 1,481,886 9.92% Excess (Deficiency) of Total Revenue over Total Requirements (2,179,425) (49,434) (1,412,516) 766,909 64.81% (2,118,621) 706,105 66.67% Ending Fund Balance 1,095,200 (49,434) 1,862,109 766,909 170.02% 1,156,004 706,105 161.08% Reserves AFR Adjustment - - - - 0.00% - - 0.00% Contingency Reserve 374,485 - 374,485 -100.00% 374,485 -100.00% Reserves for Debt Service 211,959 - 211,959 -100.00% 211,959 -100.00% Reserves Total 586,444 - 586,444 -100.00% 586,444 -100.00% Available Fund Balance 508,756 - 1,275,665 766,909 250.74% 569,560 706,105 223.97% 32 Quarterly Financial Report GTEC REVENUE: Operating revenue is comprised of sales tax and allocated interest. The budget for sales tax collections for GTEC is $13,666,398. Year-to-date sales tax revenue totals $7,266,341, or 53.17% of budget. Through this period, sales tax collections are up $97,855, or 1.37% over year-to-date collections from the prior fiscal year. Staff will continue to monitor performance of sales tax as well as economic shifts and sales tax volatility as FY2023 progresses. Non-Operating revenue has a budget of $0. There are no new debt funded projects as part of the FY2023 budget. GTEC Quarterly Comparison: Q3 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2023 YTD Actuals: Q3 FY22 YTD Actuals: Q3 FY23 Variance % of Budget Variance % Variance Operating Revenue 40002:Sales Taxes 13,666,398 7,168,486 7,266,341 (6,400,057) 53.17% 97,855 1.37% 42001:Interest Income 31,500 69,314 1,391,311 1,359,811 4416.86% 1,321,997 1907.25% Operating Revenue Total 13,697,898 7,237,801 8,657,652 (5,040,246) 63.20% 1,419,851 19.62% Non-Operating Revenue 45001:Misc Revenue - - 59,400 59,400 0.00% 59,400 0.00% 46001:Bond Proceeds - 3,775,000 - - 0.00% (3,775,000) -100.00% 46002:Bond Premium - 162,358 - - 0.00% (162,358) -100.00% Non-Operating Revenue Total -3,937,358 59,400 59,400 0.00% (3,877,958) -98.49% Revenue Total 13,697,898 11,175,159 8,717,052 (4,980,846) 63.64% (2,458,107) -22.00% K 500K 1.0M 1.5M 2.0M 2.5M 3.0M 3.5M Q1 Q2 Q3 SALES TAX REVENUE FY2021 FY2022 FY2023 33 Quarterly Financial Report FY2023 Revenue Projections: GTEC Quarterly Comparison: Q3 FY23 Budget FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2023 YTD Actuals: Q3 FY23 Variance % of Budget Projections FY2023 Variance Fav/(Unfav) % of Projection Operating Revenue 40002:Sales Taxes 13,666,398 7,266,341 (6,400,057) 53.17% 12,717,870 (5,451,529) 57.13% 42001:Interest Income 31,500 1,391,311 1,359,811 4416.86% 1,715,000 (323,689) 81.13% Operating Revenue Total 13,697,898 8,657,652 (5,040,246) 63.20% 14,432,870 (5,775,218) 59.99% Non-Operating Revenue 45001:Misc Revenue - 59,400 59,400 0.00% 59,400 - 100.00% 46001:Bond Proceeds - - - 0.00% - - 0.00%46002:Bond Premium - - - 0.00% - - 0.00% Non-Operating Revenue Total -59,400 59,400 0.00% 59,400 -100.00% Revenue Total 13,697,898 8,717,052 (4,980,846) 63.64% 14,492,270 (5,775,218) 60.15% Staff will monitor FY2023 projections as the end of the fiscal year approaches. Total revenues are projected to end FY2023 at $14,492,270. Through the quarter, actuals are 60.15% of total projections. GTEC EXPENSES: Operating expenses year-to-date total $872,184, or 23.46% of budget through the period. Operating expenses are predominately made up of administrative expenses and transfers to other City funds. Administrative expenses include the allocation for City staff to support the GTEC fund. Year-to-date administrative expenses total $331,186, or 75.00% of budget. Non-Operating expense budget totals $20,309,989. Year-to-date non-operating expenses total $4,781,203, or 23.54% of budget. Non-Operating expenses include funding for strategic partnerships, capital improvement projects, and debt service payment. The debt service payment is made in the summer and aligns with all other debt service payments for the City. CIP expense budget totals $18,168,744 in the current year. This amount includes the CIP Roll Forward amendment approved by Council in January. This budget will also decrease in the mid-year amendment due to project timing. GTEC Quarterly Comparison: Q3 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2022 YTD Actuals: Q3 FY22 YTD Actuals: Q3 FY23 Variance % Of Budget Variance % Variance Operating Expense Operations 441,581 185,562 331,186 110,395 75.00% (145,624) 78.48% Transfers 3,276,732 522,825 540,998 2,735,734 16.51% (18,173) 3.48% Total Operating Expenses 3,718,313 708,387 872,184 2,846,129 23.46% (163,797) 23.12% Non-Operating Expense Operations 1,300,000 - 651,513 648,487 50.12% (651,513) 0.00% CIP Expense 18,168,744 11,073,759 4,044,466 14,124,278 22.26% 7,029,293 36.52% Debt Service 841,245 181,009 85,225 756,020 10.13% 95,784 47.08% Total Non-Operating Expenses 20,309,989 11,254,768 4,781,203 15,528,786 23.54% 6,473,565 42.48% Expense Total 24,028,302 11,963,155 5,653,387 18,374,915 23.53% 6,309,768 -52.74% 34 Quarterly Financial Report FY2023 Expense Projections: GTEC Quarterly Comparison: Q3 FY23 Budget FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2022 YTD Actuals: Q3 FY23 Variance % Of Budget Projections FY2023 Variance Fav/(Unfav) % of Projection Operating Expense Operations 441,581 331,186 110,395 75.00% 441,581 110,395 75.00% Transfers 3,276,732 540,998 2,735,734 16.51% 3,276,732 2,735,734 16.51% Total Operating Expenses 3,718,313 872,184 2,846,129 23.46% 3,718,313 2,846,129 23.46% Non-Operating Expense Operations 1,300,000 651,513 648,487 50.12% 651,513 0 100.00% CIP Expense 18,168,744 4,044,466 14,124,278 22.26% 24,549,795 20,505,329 16.47% Debt Service 841,245 85,225 756,020 10.13% 841,245 756,020 10.13% Total Non-Operating Expenses 20,309,989 4,781,203 15,528,786 23.54% 26,042,553 21,261,350 18.36% Expense Total 24,028,302 5,653,387 18,374,915 23.53% 29,760,866 24,107,479 19.00% Staff will continue to monitor FY2023 projections as the end of the fiscal year approaches. Total expenses are projected to end FY2023 at $29,760,866. Through the quarter, actual expenses are 19.00% of total projections. Ending fund balance for FY2023 is budgeted to be $37,257,133. After accounting for the contingency reserve of $3,512,176, and the debt service reserve of $3,994,673, this fund has a budgeted available fund balance of $29,750,284. 35 Quarterly Financial Report Fund Schedule: GTEC Period: Jun-23 Budget Current Period FY2023 FY2023 Year-to-date: Budget Vs. Actuals FY2023 Year-End: Projections Vs. Actuals FY2023 Jun-23 YTD Actuals Variance % of Budget Projections Variance Fav/(Unfav) % of Projection Beginning Fund Balance 47,587,537 47,587,537 -100.00% 47,587,537 -100.00% Operating Revenue 40002:Sales Taxes 13,666,398 964,600 7,266,341 (6,400,057) 53.17% 12,717,870 (5,451,529) 57.13% 42001:Interest Income 31,500 181,757 1,391,311 1,359,811 4416.86% 1,715,000 (323,689) 81.13% Operating Revenue Total 13,697,898 1,146,357 8,657,652 (5,040,246) 63.20% 14,432,870 (5,775,218) 59.99% Operating Expense Operations 441,581 36,798 331,186 110,395 75.00% 441,581 110,395 75.00% Transfers 3,276,732 - 540,998 2,735,734 16.51% 3,276,732 2,735,734 16.51% Operating Expense Total 3,718,313 36,798 872,184 2,846,129 23.46% 3,718,313 2,846,129 23.46% Net Operations Total 9,979,585 1,109,558 7,785,468 (7,886,375) 78.01% 10,714,557 (8,621,347) 72.66% Non-Operating Revenue 45001:Misc Revenue - - 59,400.00 59,400.00 0.00% 59,400.00 0 0.00% 46001:Bond Proceeds - - - - 0.00% - - 0.00% 46002:Bond Premium - - - - 0.00% - - 0.00% Non-Operating Revenue Total - - 59,400 59,400 0.00% 59,400 - 0.00% Non-Operating Expense Operations 1,300,000 - 651,513 648,487 50.12% 651,513 0 100.00% CIP Expense 18,168,744 500 4,044,466 14,124,278 22.26% 24,549,795 20,505,329 16.47% Debt Service 841,245 - 85,225 756,020 10.13% 841,245 756,020 10.13% Non-Operating Expense Total 20,309,989 500 4,781,203 15,528,786 23.54% 26,042,553 21,261,350 18.36% Excess (Deficiency) of Total Revenue over Total Requirements (10,330,404) (6,648,890) (3,849,620) 6,480,784 37.26% (22,264,840) 18,415,220 17.29% Ending Fund Balance 37,257,133 50,651,202 13,394,069 135.95% 32,318,941 18,332,261 156.72% Reserves AFR Adjustment - - - 0.00% - - 0.00% Contingency Reserve 3,512,176 3,512,176 - 100.00% 3,512,176 - 100.00% Debt Service Reserve 3,994,673 3,994,673 - 100.00% 3,994,673 - 100.00% Reserves Total 7,506,849 7,506,849 -100.00% 7,506,849 -100.00% Estimated Operational Roll Forward 13,168,744 Available Fund Balance 29,750,284 29,975,609 225,325 100.76% 24,812,092 5,163,517 120.81% 36 Quarterly Financial Report GEDCO REVENUE: Operating revenue has a total budget of $3,446,599 in FY2023 and is comprised of sales tax and allocated interest. The budget for sales tax collections for GEDCO is $3,416,599. Year-to-date sales tax revenue totals $1,816,585, or 53.17% of budget. Through this period, sales tax collections are up $24,464, or 1.37% over year- to-date collections from the prior fiscal year. There is a two-month lag in sales tax collections/reporting. The City continues to closely monitor performance of sales tax. Staff are also monitoring economic shifts and sales tax volatility as FY2023 progresses. Non-Operating revenue, which typically includes bond proceeds, is not part of the FY2023 budget. GEDCO Quarterly Comparison: Q3 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2023 YTD Actuals: Q3 FY22 YTD Actuals: Q3 FY23 Variance % Variance Variance % Variance Operating Revenue 40002:Sales Taxes 3,416,599 1,792,122 1,816,585 (1,600,014) 53.17% 24,464 1.37% 42001:Interest Income 30,000 16,881 329,980 299,980 1099.93% 313,099 1854.71% Operating Revenue Total 3,446,599 1,809,003 2,146,565 (1,300,034) 62.28% 337,562 18.66% Non-Operating Revenue 45001:Misc Revenue - 2,609 - - 0.00% (2,609) -100.00% Non-Operating Revenue Total -2,609 - - 0.00% (2,609) -100.00% Revenue Total 3,446,599 1,811,612 2,146,565 (1,300,034) 62.28% 334,953 18.49% FY2023 Revenue Projections: GEDCO Quarterly Comparison: Q3 FY23 Budget FY2023 FY2023 Year-to-date: Budget Vs. Actuals FY2023 Year End: Projections Vs. Actuals FY2023 YTD Actuals: Q3 FY23 Variance % Variance Projections Variance Fav/(Unfav) % of Projection Operating Revenue 40002:Sales Taxes 3,416,599 1,816,585 (1,600,014) 53.17% 3,179,467 (1,362,882) 57.13% 42001:Interest Income 30,000 329,980 299,980 1099.93% 350,000 (20,020) 94.28% Operating Revenue Total 3,446,599 2,146,565 (1,300,034) 62.28% 3,529,467 (1,382,902) 60.82% Non-Operating Revenue 45001:Misc Revenue - - - 0.00% - - 0.00% Non-Operating Revenue Total - - - 0.00% - - 0.00% Revenue Total 3,446,599 2,146,565 (1,300,034) 62.28% 3,529,467 (1,382,902) 60.82% Staff will monitor FY2023 projections as the end of the fiscal year approaches. Total revenues are projected to end FY2023 at $3,529,467. Through the quarter, actuals are 60.82% of total projections. K 200K 400K 600K 800K 1.0M Q1 Q2 Q3 SALES TAX REVENUE FY2021 FY2022 FY2023 37 Quarterly Financial Report GEDCO EXPENSES: Operating expenses have a total budget of $1,008,329 for FY2023. Year-to-date operational expenses incurred total $610,143, or 60.51% of budget. Operating expenses include administrative expenses, marketing costs, contractual services, subscriptions, and operating transfers to other City funds. Administrative expenses include the allocation for City staff to support the GEDCO fund. Year-to-date administrative expense total $438,233, or 75.00% of budget. The GEDCO fund has dedicated funding to market the City for potential economic development. Year-to-date marketing efforts total $58,637, or 58.35% of budget. Contractual services include $100,000 budgeted for consulting in FY2023. GEDCO will transfer out $204,019 to General Debt Service in FY2023. Non-Operating expense budget totals $6,641,626. Through the quarter there has been $672,285 of non-operating expenses. This is due to the timing of approved economic development agreement expenses. Non-Operating expenses include funding for strategic partnerships and GEDCO’s debt service payment. GEDCO has a budget of $6,350,000 for economic development agreements in FY2023. The debt service payment includes principal reduction of $76,559, and an interest expense of $14,947. The debt service payment will be reflected in the Q4 report as it aligns with the City’s annual debt payment. GEDCO Quarterly Comparison: Q3 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2023 YTD Actuals: Q3 FY22 YTD Actuals: Q3 FY23 Variance % Variance Variance % Variance Operating Expense Operations 804,310 369,320 573,133 231,177 71.26% (203,813) 55.19% Transfers 204,019 38,884 37,009 167,010 18.14% 1,875 -4.82% Operating Expense Total 1,008,329 408,205 610,143 398,186 60.51% (201,938) 49.47% Non-Operating Expense Operations 6,550,000 3,090,000 672,285 5,877,715 10.26% 2,417,715 -78.24% Debt Service 91,626 - - 91,626 0.00% - 0.00% Operating Expense Total 6,641,626 3,090,000 672,285 5,969,341 10.12% 2,417,715 -78.24% Expense Total 7,649,955 3,498,205 1,282,428 6,367,527 16.76% 2,215,777 -63% K 100K 200K 300K 400K 500K 600K 51001:Administrative Expense 51003:Marketing & Promotional 51004:Contractual Services 80001:Transfers Out OPERATING EXPENSE BY LEDGER FY2023 Actuals FY2023 Budget 38 Quarterly Financial Report FY2023 Expense Projections: GEDCO Quarterly Comparison: Q3 FY23 Budget FY2023 FY2023 Year-to-date: Budget Vs. Actuals FY2023 Year End: Projections Vs. Actuals FY2023 YTD Actuals: Q3 FY23 Variance % Variance Projections Variance Fav/(Unfav) % of Projection Operating Expense Operations 804,310 573,133 231,177 71.26% 697,102 123,969 82.22% Transfers 204,019 37,009 167,010 18.14% 204,019 167,010 18.14% Operating Expense Total 1,008,329 610,143 398,186 60.51% 901,121 290,978 67.71% Non-Operating Expense Operations 6,550,000 672,285 5,877,715 10.26% 4,920,000 4,247,715 13.66% Debt Service 91,626 - 91,626 0.00% 91,626 91,626 0.00% Operating Expense Total 6,641,626 672,285 5,969,341 10.12% 5,011,626 4,339,341 13.41% Expense Total 7,649,955 1,282,428 6,367,527 16.76% 5,912,747 4,630,319 21.69% Staff will continue to monitor FY2023 projections as the end of the fiscal year approaches. Total expenses are projected to end FY2023 at $5,912,747. Through the quarter, actual expenses are 21.69% of total projections. Ending fund balance for FY2023 is budgeted at $2,106,696. After accounting for the contingency reserve of $878,044, and the debt service reserve of $205,519, this fund is budgeted to have an available fund balance of $1,023,133. 39 Quarterly Financial Report Fund Schedule: GEDCO Period: Jun-23 Budget Current Period FY2023 FY2023 Year-to-date: Budget Vs. Actuals FY2023 Year End: Projections Vs. Actuals FY2023 Jun-23 YTD Actuals: Q3 FY23 Variance % of Budget Projections Variance Fav/(Unfav) % of Projection Beginning Fund Balance 6,310,052 6,310,052 -100.00% 6,310,052 -100.00% Operating Revenue 40002:Sales Taxes 3,416,599 241,150 1,816,585 (1,600,014) 53.17% 3,179,467 (1,362,882) 57.13% 42001:Interest Income 30,000 45,118 329,980 299,980 1099.93% 350,000 (20,020) 94.28% Operating Revenue Total 3,446,599 286,268 2,146,565 (1,300,034) 62.28% 3,529,467 (1,382,902) 60.82% Operating Expense Operations 804,310 52,154 573,133 231,177 71.26% 697,102 123,969 82.22% Transfers 204,019 - 37,009 167,010 18.14% 204,019 167,010 18.14% Operating Expense Total 1,008,329 52,154 610,143 398,186 60.51% 901,121 290,978 67.71% Net Operations Total 2,438,270 234,114 1,536,423 901,847 63.01% 2,628,346 (1,091,923) 58.46% Non-Operating Revenue 45001:Misc Revenue - - - - 0.00% - - 0.00% Non-Operating Revenue Total - - - - 0.00% - - 0.00% Non-Operating Expense Operations 6,550,000 102,000 672,285 (5,877,715) 10.26% 4,920,000 4,247,715 13.66% Debt Service 91,626 - - (91,626) 0.00% 91,626 91,626 0.00% Non-Operating Expense Total 6,641,626 102,000 672,285 (5,969,341) 10.12% 5,011,626 4,339,341 13.41% Excess (Deficiency) of Total Revenue over Total Requirements (4,203,356) 132,114 (3,428,993) 774,363 81.58% (2,383,280) (1,045,713) 143.88% Ending Fund Balance 2,106,696 7,174,190 5,067,494 340.54% 3,926,772 3,247,418 182.70% Reserves AFR Adjustment - - - - 0.00% - - 0.00% Contingency Reserve 878,044 - 878,044 - 100.00% 878,044 - 100.00% Debt Service Reserve 205,519 - 205,519 - 100.00% 205,519 - 100.00% Reserves Total 1,083,563 -1,083,563 -100.00% 1,083,563 -100.00% Available Fund Balance 1,023,133 - 6,090,627 5,067,494 595.29% 2,843,209 3,247,418 214.22% 40 Quarterly Financial Report Fund Schedule: Council Discretionary Period: Jun-23 Budget Current Period Year-End: Projections Vs. Actuals FY2023 Jun-23 YTD Actuals Variance % of Budget Projections Variance Fav/(Unfav) % of Projection Beginning Fund Balance 4,973,592 4,973,592 -100.00% 2,317,098 2,656,494 46.59% Revenue 42001:Interest Income 150 21,043 124,917 124,767 83278.16% 150,000 (25,083) 83.28% 70001:Transfers In 1,568,841 1,568,841 1,568,841 - 100.00% 1,568,841 - 100.00% Total Revenue 1,568,991 1,589,884 1,693,758 124,767 107.95% 1,718,841 (25,083) 98.54% Expense Transfers 2,377,000 2,377,000 2,377,000 - 100.00% 2,377,000 - 100.00% Total Expense 2,377,000 2,377,000 2,377,000 -100.00% 2,377,000 -100.00% Excess (Deficiency) of Total Revenue over Total Requirements (808,009) (787,116) (683,242) 124,767 84.56% (658,159) (25,083) 103.81% Ending Fund Balance 4,165,583 (787,116) 4,290,350 124,767 103.00% 1,658,939 2,631,411 258.62% Reserves AFR Adjustment - - - - - - - 0.00% Contingency Reserve - - - - - - - 0.00% Debt Service Reserve - - - - - - - 0.00% Reserves Total - - - - - - - 0.00% Available Fund Balance 4,165,583 - 4,290,350 124,767 103.00% 1,658,939 2,631,411 258.62% 41 Quarterly Financial Report Fund Schedule: Joint Services Period: Jun-23 Budget Current Period FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2023 Jun-23 YTD Actuals: Q3 FY23 Variance % of Budget Projections Variance Fav/(Unfav) % of Projection Beginning Fund Balance 4,977,655 4,977,655 -100.00% 4,977,655 -100.00% Revenue 41002:Penalties 25,000 7,669 45,051 20,051 180.21% 50,000 (4,949) 90.10% 42001:Interest Income 7,000 12,058 108,152 101,152 1545.03% 110,000 (1,848) 98.32% 43001:Fees 13,000 16,178 242,208 229,208 1863.13% 341,140 (98,933) 71.00% 43004:Administrative Charges 27,486,561 2,283,862 20,554,757 (6,931,804) 74.78% 27,486,561 (6,931,804) 74.78% 43005:Rental Revenue - - - - 0.00% - - 0.00% 45001:Misc Revenue 30 (1,087) (8,003) (8,033) -26676.67% 600 (8,603) -1333.83% 45002:Insurance Proceeds 110,000 26,344 101,650 (8,350) 92.41% 110,000 (8,350) 92.41% 45003:Misc Reimbursements 235,200 - 40,845 (194,355) 17.37% 56,760 (15,915) 71.96% 45004:Sale of Property - - 14,228 14,228 0.00% 14,228 -100.00% 44001:Grant Revenue - - - - 0.00% - - 0.00% 44502:Developer Contributions - - - - 0.00% - - 0.00% Revenue Total 27,876,791 2,345,022 21,098,888 (6,777,903) 75.69% 28,169,289 (7,070,401) 74.90% Expense CC0001 Non-Departmental 1,251,000 756,423 1,847,792 (596,792) 147.71% 2,257,648 409,856 81.85% CC0302 Finance Administration 1,463,107 79,578 1,103,428 359,679 75.42% 1,392,190 288,762 79.26% CC0315 Accounting 1,828,532 123,588 1,271,892 556,640 69.56% 1,697,124 425,232 74.94% CC0317 Purchasing 912,728 59,472 623,654 289,074 68.33% 857,124 233,471 72.76% CC0318 Warehouse Services 338,992 21,427 127,510 211,482 37.61% 244,008 116,498 52.26% CC0321 Utility Customer Service 1,386,831 75,538 1,046,318 340,512 75.45% 1,205,401 159,083 86.80% CC0322 Utility Customer Billing 1,797,097 152,634 1,500,540 296,556 83.50% 1,958,112 457,571 76.63% CC0324 Customer Admin & Data Analytics 6,192,198 368,997 4,986,328 1,205,871 80.53% 6,094,727 1,108,400 81.81% CC0503 Organizational and Operational Excellence 867,502 37,093 441,219 426,283 50.86% 798,191 356,972 55.28% CC0524 Metering Services - - (0) 0 0.00% - 0 0.00% CC0526 Systems Engineering 4,849,339 339,665 3,325,783 1,523,556 68.58% 4,281,478 955,695 77.68% CC0534 Conservation - - 0 (0) 0.00% - (0) 0.00% CC0637 Economic Development 755,571 35,833 403,502 352,069 53.40% 564,121 160,619 71.53% CC0639 Human Resources 1,819,385 127,906 1,313,129 506,256 72.17% 1,777,815 464,686 73.86% CC0640 Citywide Human Resources 1,581,750 41,074 1,253,727 328,023 79.26% 1,501,867 248,140 83.48% CC0654 Legal 1,584,543 127,544 1,017,796 566,747 64.23% 1,385,029 367,233 73.49% CC0658 Real Estate Services 399,366 29,634 167,294 232,072 41.89% 328,758 161,463 50.89% Expense Total 27,027,941 2,376,405 20,429,911 6,598,030 75.59% 26,343,593 5,913,682 77.55% Excess (Deficiency) of Total Revenue over Total Requirements 848,850 (31,383) 668,978 (179,872) 78.81% 1,825,696 (1,156,718) 36.64% Ending Fund Balance 5,826,505 5,646,633 (179,872) 96.91% 6,803,351 (1,156,718) 83.00% Reserves Contingency Reserve 4,818,205 4,818,205 -100.00% 4,818,205 -100.00% Reserves Total 4,818,205 4,818,205 -100.00% 4,818,205 -100.00% Available Fund Balance 1,008,301 828,428 (179,874) 82.16% 1,985,146 (1,156,718) 41.73% 42 Quarterly Financial Report STORMWATER REVENUE: Stormwater operating revenue budget totals $4,648,250. Stormwater charges, the largest section of revenue, totals $3,595,949 year-to-date. This primarily includes revenue for Non-Residential and Residential Operations. Also included in Stormwater charges is Pond Maintenance. Total operating revenues through the quarter are $3,739,597, or 80.45% of budget. Non-operating revenue are bond proceeds for capital projects. The Stormwater Fund has $657,500 budgeted for funding to conduct curb and gutter repair. Bond proceeds were be received as part of the City’s annual debt sale in the spring. Stormwater Services Quarterly Comparison: Q3 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2023 YTD Actuals: Q3 FY22 YTD Actuals: Q3 FY23 Variance % of Budget Variance % Variance Operating Revenue 41002:Penalties 57,500 34,553 38,402 (19,098) 66.79% 3,849 11.14% 42001:Interest Income 15,300 10,669 105,246 89,946 687.88% 94,577 886.49% 43605:Stormwater Charges 4,575,450 3,258,457 3,595,949 (979,501) 78.59% 337,492 10.36% Operating Revenue Total 4,648,250 3,303,679 3,739,597 (908,653) 80.45% 435,917 13.19% Non-Operating Revenue 46001:Bond Proceeds 657,500 495,000 585,000 (72,500) 88.97% 90,000 18.18% 46002:Bond Premium - 21,289 75,783 75,783 0.00% 54,494 255.97% Non-Operating Revenue Total 657,500 516,289 660,783 3,283 100.50% 144,494 27.99% Total Revenue 5,305,750 3,819,969 4,400,380 (905,370) 82.94% 580,411 15.19% FY2023 Revenue Projections: Stormwater Services Quarterly Comparison: Q3 FY23 Budget FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2023 YTD Actuals: Q3 FY23 Variance % of Budget Projections FY2023 Variance Fav/(Unfav) % of Projection Operating Revenue 41002:Penalties 57,500 38,402 (19,098) 66.79% 57,500 (19,098) 66.79% 42001:Interest Income 15,300 105,246 89,946 687.88% 100,082 5,164 105.16% 43605:Stormwater Charges 4,575,450 3,595,949 (979,501) 78.59% 4,568,218 (972,269) 78.72% Operating Revenue Total 4,648,250 3,739,597 (908,653) 80.45% 4,725,800 (986,203) 79.13% Non-Operating Revenue 46001:Bond Proceeds 657,500 585,000 (72,500) 88.97% 585,000 - 100.00% 46002:Bond Premium - 75,783 75,783 0.00% 75,783 0 100.00% Non-Operating Revenue Total 657,500 660,783 3,283 100.50% 660,783 0 100.00% Total Revenue 5,305,750 4,400,380 (905,370) 82.94% 5,386,583 (986,203) 81.69% K 200K 400K 600K 800K 1.0M 1.2M 1.4M Q1 Q2 Q3 STORMWATER CHARGES FY2021 FY2022 FY2023 43 Quarterly Financial Report Staff will monitor FY2023 projections as the end of the fiscal year approaches. Total revenues are projected to end FY2023 at $5,386,583. Through the quarter, actuals are 81.69% of total projections. STORMWATER EXPENSES: Operating expenses in the Stormwater Fund include a budget of $6,155,861. Year-to-date operating expenses total $4,650,857. Operating Capital has a budget of $500,000 for infrastructure improvements, various drainage and flood mitigation maintenance, and equipment. Year-to-date operating capital is $20,693, or 4.14% of budget. Year-to-date Operational expenses are 96.23% over the prior year primarily due to an increase in the allocation to the Joint Services fund for customer care and billing services and an increase in the cost of mowing contracts due to inflation. The budget for non-operating expenses totals $1,931,435. This includes a CIP expense of $1,381,411 for the construction of curb and gutters as well as drainage improvements and Stormwater Infrastructure. Debt Service has a budget of $550,024. Stormwater Services Quarterly Comparison: Q3 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2023 YTD Actuals: Q3 FY22 YTD Actuals: Q3 FY23 Variance % of Budget Variance % Variance Operating Expense Personnel 878,076 472,220 577,626 300,450 65.78% (105,406) 22.32% Operations 4,099,103 1,751,854 3,437,634 661,469 83.86% (1,685,780) 96.23% Operating Capital 500,000 32,893 20,693 479,307 4.14% 12,200 -37.09% Transfers 678,682 268,436 614,905 63,777 90.60% (346,469) 129.07% Total Operating Expenses 6,155,861 2,525,403 4,650,857 1,505,004 75.55% (2,125,454) 84.16% Non-Operating Expense CIP Expense 1,381,411 302,561 1,176,551 204,860 85.17% (873,989) 288.86% Debt Service 550,024 87,355 91,624 458,400 16.66% (4,269) 4.89% Non-Operating Expense Total 1,931,435 389,916 1,268,175 663,260 65.66% (878,258) 225.24% Expense Total 8,087,296 2,915,320 5,919,032 2,168,264 73.19% (3,003,712) 103.03% 44 Quarterly Financial Report FY2023 Expense Projections: Stormwater Services Quarterly Comparison: Q3 FY23 Budget FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2023 YTD Actuals: Q3 FY23 Variance % of Budget Projections FY2023 Variance Fav/(Unfav) % of Projection Operating Expense Personnel 878,076 577,626 300,450 65.78% 797,703 220,077 72.41% Operations 4,099,103 3,437,634 661,469 83.86% 4,380,606 942,972 78.47% Operating Capital 500,000 20,693 479,307 4.14% 250,000 229,307 8.28% Transfers 678,682 614,905 63,777 90.60% 722,500 107,595 85.11% Total Operating Expenses 6,155,861 4,650,857 1,505,004 75.55% 6,150,809 1,499,951 75.61% Non-Operating Expense CIP Expense 1,381,411 1,176,551 204,860 85.17% 1,381,411 204,860 85.17% Debt Service 550,024 91,624 458,400 16.66% 551,111 459,487 16.63% Non-Operating Expense Total 1,931,435 1,268,175 663,260 65.66% 1,932,522 664,347 65.62% Expense Total 8,087,296 5,919,032 2,168,264 73.19% 8,083,331 2,164,299 73.23% Staff will continue to monitor FY2023 projections as the end of the fiscal year approaches. Total expenses are projected to end FY2023 at $8,083,331. Through the quarter, actual expenses are 73.23% of total projections. Ending fund balance is budgeted to be $1,693,728 in FY2023 with an operating contingency reserve of $354,160 and a debt service reserve of $505,926. 45 Quarterly Financial Report Fund Schedule: Stormwater Services Period: Jun-23 Budget Current Period FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2023 Jun-23 YTD Actuals: Q3 FY23 Variance % of Budget Projections Variance % of Projection Beginning Fund Balance 4,475,274 4,475,274 -100.00% 4,475,274 -100.00% Operating Revenues 41002:Penalties 57,500 3,852 38,402 (19,098) 66.79% 57,500 (19,098) 66.79% 42001:Interest Income 15,300 16,737 105,246 89,946 687.88% 100,082 5,164 105.16% 43605:Stormwater Charges 4,575,450 404,048 3,595,949 (979,501) 78.59% 4,568,218 (972,269) 78.72% Total Operating Revenues 4,648,250 424,638 3,739,597 (908,653) 80.45% 4,725,800 (986,203) 79.13% Operating Expenses Personnel 878,076 61,403 577,626 300,450 65.78% 797,703 220,077 72.41% Operations 4,099,103 348,795 3,437,634 661,469 83.86% 4,380,606 942,972 78.47% Operating Capital 500,000 - 20,693 479,307 4.14% 250,000 229,307 8.28% Transfers 678,682 389,053 614,905 63,777 90.60% 722,500 107,595 85.11% Total Operating Expenses 6,155,861 799,252 4,650,857 1,505,004 75.55% 6,150,809 1,499,951 75.61% Available Operating Funds (1,507,611) (374,614) (911,261) 596,350 60.44% (1,425,009) 513,748 63.95% Non-Operating Revenues 46001:Bond Proceeds 657,500 - 585,000 (72,500) 88.97% 585,000 - 0.00% 46002:Bond Premium - - 75,783 75,783 0.00% 75,783 0 0.00% Total Non-Operating Revenues 657,500 -660,783 3,283 100.50% 660,783 0 0.00% Non-Operating Expenses CIP Expense 1,381,411 - 1,176,551 204,860 85.17% 1,381,411 204,860 85.17% Debt Service 550,024 20 91,624 458,400 16.66% 551,111 459,487 16.63% Total Non-Operating Expenses 1,931,435 20 1,268,175 663,260 65.66% 1,932,522 664,347 65.62% Excess (Deficiency) of Total Revenue over Total Requirements (2,781,546) (374,634) (1,518,652) 1,262,894 54.60% (2,696,748) 1,178,096 56.31% Ending Fund Balance 1,693,728 (374,634) 2,956,622 1,262,894 174.56% 1,778,526 1,178,096 166.24% Reserves Contingency Reserve 354,160 354,160 - 100.00% 354,160 - 100.00% Debt Service Reserve 505,926 505,926 - 100.00% 505,926 - 100.00% Reserves Total 860,086 860,086 -100.00% 860,086 -100.00% Available Fund Balance 833,642 1,015,125 1,262,894 121.77% 918,440 96,685 110.53% 46 Quarterly Financial Report VILLAGE PID MONTHLY REPORT AS OF JUNE 30, 2023 VILLAGE PID REVENUES: Village PID budgeted revenues total $530,845 and are comprised of property tax and allocated interest. The City receives the bulk of property tax revenues in December and January. Budgeted revenues for the City this year are $529,845 in property tax revenue, as well as $1,000 in allocated interest. Through the end of the third quarter of FY2023, property tax revenue totals $520,099, or 98.16% of budget. FY2023 Property tax revenue is up 3.60%, or $18,053 compared to FY2022. Collection rates and protested values can affect property tax revenue. Staff will monitor FY2023 projections as the end of the fiscal year approaches. Total revenues are projected to end FY2023 at $520,208. Through the quarter, actuals are 99.98% of total projections. Village PID Expenses: Village PID expenses include administrative charges, capital, contractual services, insurance, maintenance, and marketing. Year-to-date operational and capital expenses total $365,678 or 50.73% of budget. The Parks Department has contracted for Parks Capital Improvements which total $64,100 year to date, leaving a remaining budget of $195,420. Staff will continue to monitor FY2023 projections as the end of the fiscal year approaches. Total expenses are projected to end FY2023 at $592,044. Through the quarter, actual expenses are 61.77% of total projections. Ending Fund Balance in FY2023 for Village PID is budgeted at $707,571. After accounting for the contingency reserve of $111,453 and a capital reserve of $40,222, this fund will have a budgeted available fund balance of $555,896. K 150K 300K 450K Q1 Q2 PROPERTY TAX REVENUES FY2021 FY2022 FY2023 47 Quarterly Financial Report Fund Schedule: Village PID Period: Jun-23 Budget Current Period FY2023 FY2023 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2023 Jun-23 YTD Actuals: Q3 FY23 Variance % of Budget Projection Variance Fav/(Unfav) % of Projection Beginning Fund Balance 897,526 897,526 -100.00% 897,526 -100.00% Revenue 40001:Property Taxes 529,845 473 520,099 (9,746) 98.16% 520,208 (109)99.98% 42001:Interest Income 1,000 - - (1,000) 0.00% - - 0.00% Revenue Total 530,845 473 520,099 (10,746) 97.98% 520,208 (109)99.98% Expense 53002:Postage & Freight 427 - 427 -100.00% 430 3 99.36% 53004:Insurance Expense 1,061 - - 1,061 0.00% - - 0.00% 51001:Administrative Expense 46,388 3,866 34,791 11,597 75.00% 46,388 11,597 75.00% 51002:Publishing & Printing 1,801 - - 1,801 0.00% - - 0.00% 51003:Marketing & Promotional 5,000 - 5,875 (875)117.50% 7,000 1,125 83.93% 51004:Contractual Services 21,218 1,250 22,500 (1,282) 106.04% 22,500 - 100.00%51005:Professional Services - - 365 (365)0.00% 365 0 99.95%51007:Contracts & Leases 264,053 11,647 153,466 110,587 58.12% 188,345 34,879 81.48% 51008:Utilities 67,538 6,459 46,096 21,442 68.25% 67,436 21,340 68.36%52501:Office Supplies 300 - 58 242 19.33% 60 2 96.63% 52509:Maintenance Expense 53,494 - - 53,494 0.00% - - 0.00% 60009:Capital Outlay - Improvements 259,520 - 64,100 195,420 24.70% 259,520 195,420 24.70% 62001:CIP Expense - 2,900 38,000 (38,000) 0.00% -0.00% Expense Total 720,800 26,122 365,678 355,122 50.73% 592,044 226,366 61.77% Excess (Deficiency) of Total Revenue over Total Requirements (189,955) (25,649) 154,421 (344,376) -81.29% (71,836) 226,257 -214.96% Ending Fund Balance 707,571 (25,649) 1,051,947 344,376 148.67% 825,690 226,257 127.40% Reserves Contingency Reserve 111,453 - 111,453 - 100.00% 111,453 - 100.00% Capital Reserve 40,222 - 40,222 - 100.00% 40,222 - 100.00% Reserves Total 151,675 151,675 -100.00% 151,675 - 100.00% Available Fund Balance 555,896 - 900,272 344,376 161.95% 674,015 226,257 133.57% 48 II.INVESTMENTS The investment activity and strategies described in this report comply with the Public Funds Investment Act (PFIA), the City’s investment policy, and generally accepted accounting principles. Activity for the third quarter of fiscal year 2023 includes the maturing, reinvesting, new investments of financial institution deposits (CDs) & purchases of treasury/agency securities. Interest rates continued to increase during this quarter after the FOMC met. We continue to work closely with Valley View Consulting to select the best investments as the market is changing. The FOMC met in January and March where they announced increases in the Fed Funds Rate from 4.75-5% in March to 5-5.25% in May 23. The FOMC will meet again July 26th and September 20th during the 4th quarter and may increase rates again. The City will continue soliciting for the best rates to improve both diversity and yield, while keeping in mind safety and liquidity. FOMC Meeting Date Rate Change (bps) Federal Funds Rate May 3, 2023 25 5.00% to 5.25% March 22, 2023 25 4.75% to 5.00% February 1, 2023 25 4.50% to 4.75% December 14, 2022 50 4.25% to 4.50% November 2, 2022 75 3.75% to 4.00% September 21, 2022 75 3.00% to 3.25% July 27, 2022 75 2.25% to 2.50% June 16, 2022 75 1.50% to 1.75% May 5, 2022 50 0.75% to 1.00% March 17, 2022 25 0.25% to 0.50% The Investment Reports are for the quarter ending June 30, 2023. Valley View Consulting, L.L.C., has prepared the attached investment reports. A component of our investment advisory services contract includes Valley View preparing the quarterly investment reports on behalf of the City. A summary of the investment balances as of June 30, 2023, compared to the prior quarter, is shown below for the City, as well as Georgetown Transportation Enhancement Corporation (GTEC) and Georgetown Economic Development Corporation (GEDCO). Included in the City portfolio are debt service, consolidated funds, and bond proceeds. The breakdown of the City’s portfolio is consolidated at 33.86%, debt service at 3.37%, and bond proceeds/grants/reserved fund at 62.77%. The City portfolio increased during this quarter due to receiving bond proceeds in May and June. The GEDCO portfolio increased in this quarter, however, the GTEC portfolio decreased due to a large CIP payment. The average yield increased on all portfolios due to increased rates in our pools, newly purchased cd’s, and 49 treasury/agency securities. Rates on securities have helped the city diversify the portfolio compared to the prior year’s holdings. CITY Market Value GTEC GEDCO 3/31/23 6/30/23 3/31/23 6/30/23 3/31/23 6/30/23 Total cash and investments $745,988,174 $899,378,504 $46,188,271 $45,694,863 $10,229,468 $10,880,626 Quarter End Average Yield 4.35% 4.86% 4.58% 5.06% 4.67% 5.11% The City’s strategy continues to be matching maturities with cash flow needs, while focusing on the investment policy’s long-range goals. The City’s investment strategy is to “ladder” or stagger maturities, thus minimizing erratic interest rate fluctuations. The City is continuing to manage the yield on bond proceeds for arbitrage purposes. HDR Engineering was hired to manage and expedite the completion of bond funded capital projects. Finance staff also assisted Economic Development staff with an updated cash flow model for GEDCO to manage incentive agreement payments and potential new projects. 50 The City’s investment portfolio generally includes bank deposits, local government investment pool balances, money market accounts, financial institution deposits (CD’s), and securities/agencies. All of these investments meet the safety requirements of the PFIA. Local Government Investment Pools must maintain a rating of AAAm, Securities (Treasury Bills) must have direct or implied backing of the Federal Government and Financial Institution Deposits (CDs and money market accounts) must be collateralized with FDIC insurance or obligations with an implied backing from the Federal Government. The collateral on all City investments are monitored monthly to ensure the financial institutions carry minimum collateral of 100% with a letter of credit or 102% with pledged securities for all of the City’s investments. All securities held by financial institutions as collateral on behalf of the City have been reviewed and met PFIA-minimum rating criteria. III. CAPITAL IMPROVEMENT PROJECTS A financial summary of capital improvement projects is attached to this report. This report provides a Life-to-Date picture of all active projects since many capital projects take multiple fiscal years to construct to completion. With our growing capital infrastructure implementation portfolio due to demand for transportation and water services, City staff are improving work capacity and efficiencies, and ultimately customer service, related to capital projects. The focus is on incrementally improving capital project reporting internally and externally citywide – including financial information as well as scheduling, geographic location, and other information. Staff are exploring functionality in ClearGov, the new digital budget book platform, as a tool to improve capital project reporting. A Communications and Public Engagement staff person has also been re-organized to focus on capital project status updates. For the FY2023 Budget, staff were added to the Water, Public Works, and Engineering departments to assist with the workload of the capital improvement plan. Additionally, Council agreed to implement a hybrid approach to capital project management, and to hire contracted staff to manage transportation and facilities projects over the next 3 or more years. 51 CITY QUARTERLY INVESTMENT REPORT For the Quarter Ended June 30, 2023 Prepared by Valley View Consulting, L.L.C. ________________________________________________________________________ Leigh Wallace Nathan Parras Finance Director Assistant Finance Director ________________________________________________________________________ Karrie Pursley Elaine Wilson Treasurer Assistant Finance Director The investment portfolio of the City of Georgetown is in compliance with the Public Funds Investment Act and the Investment Policy and Strategies. Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total return yields and do not account for investment advisor fees. 52 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield Demand Accounts 800,704$ 800,704 845,947$ 845,947$ 0.00% NOW/MMA 28,655,293 28,655,293 34,000,681 34,000,681 5.06% Pools 281,150,859 281,150,859 438,124,654 438,124,654 5.07% CDs/Securities 435,275,491 435,381,317 426,611,729 426,407,221 4.64% Totals 745,882,348$ 745,988,174$ 899,583,011$ 899,378,504$ 4.86% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 4.86%Total Portfolio 4.19% Rolling Three Month Treasury 5.28%Rolling Three Month Treasury 4.75% Rolling Six Month Treasury 5.08%Rolling Six Month Treasury 4.57% TexPool 5.05%TexPool 4.55% Bank Fees Offset 2,517$ Interest earnings provided in separate report.5,680$ March 31, 2023 (1)Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank, pool, and money market balances. (2)Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. Quarterly Bank Fees Offset Year-to-date Bank Fees Offset June 30, 2023 City of Georgetown Valley View Consulting, L.L.C.53 Economic Overview 6/30/2023 The Federal Open Market Committee (FOMC) paused and kept the Fed Funds target range 5.00% - 5.25% June 14th (Effective Fed Funds are trading +/-5.08%). Another increase is projected after the July 25-26 meeting. First quarter 2023 GDP (Final) recorded 2.0%. June Non-Farm Payroll added 209k new jobs, below the 230k projection. The three month average declined to 244k. The S&P Stock Index continues moderate increases, trading +/-4,400. The yield curve rose from last month but remains steeply inverted with the expectation of future FOMC rate decreases. Crude Oil trades over +/-$70 per barrel. Inflation declined slightly but is still over the FOMC 2% target (Core PCE +/-4.6% and CPI +/-5.3%). The Ukrainian/Russian war and Middle East conflicts increase market anxiety. 02505007501,0001,2501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,0004,2504,5004,7505,0005,250 S&P 500 0.00 0.50 1.00 1.50 2.00 2.50 3.00 3.50 4.00 4.50 5.00 5.50 6.00 US Treasury Historical Yields - Since Nov 2015 Six Month T-Bill Two Year T-Note Ten Year T-Note 0.00 1.00 2.00 3.00 4.00 5.00 6.00 Treasury Yield Curves June 30, 2022 March 31, 2023 June 30, 2023 0.00 0.50 1.00 1.50 2.00 2.50 3.00 3.50 4.00 4.50 5.00 5.50 6.00 US Treasury Historical Yields - Since 2006 Six Month T-Bill Two Year T-Note Ten Year T-Note Valley View Consulting, L.L.C.54 City - Investment Holdings Coupon/Maturity Settlement Face Amount/Book Market Market Life Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield JPMorgan Chase Cash (3)0.00%07/01/23 06/30/23 618,137$ 618,137$ 1.00 618,137$ 1 0.00% JPMorgan Chase MMA 1.60%07/01/23 06/30/23 438,323 438,323 1.00 438,323 1 1.60% Wells Fargo Bank Cash 0.00%07/01/23 06/30/23 227,810 227,810 1.00 227,810 1 0.00% Wells Fargo Bank Sweep-MMF 4.95%07/01/23 06/30/23 17,302,185 17,302,185 1.00 17,302,185 1 4.95% Veritex Community Bank MMA 5.20%07/01/23 06/30/23 3,345,666 3,345,666 1.00 3,345,666 1 5.20% NexBank MMA 5.30%07/01/23 06/30/23 12,914,507 12,914,507 1.00 12,914,507 1 5.30% TexPool AAAm 5.05%07/01/23 06/30/23 40,801,750 40,801,750 1.00 40,801,750 1 5.05% TexSTAR AAAm 5.08%07/01/23 06/30/23 397,322,905 397,322,905 1.00 397,322,905 1 5.08% Alliance Bank CD 3.10%07/01/23 07/01/22 4,093,809 4,093,809 100.00 4,093,809 1 3.14% FHLB Aaa/AA+0.00%07/31/23 10/17/22 5,000,000 4,981,422 99.62 4,981,247 31 4.47% East West Bank CD 3.05%08/01/23 08/01/22 2,062,706 2,062,706 100.00 2,062,706 32 3.10% Alliance Bank CD 3.15%08/02/23 08/02/22 1,023,746 1,023,746 100.00 1,023,746 33 3.19% Bank OZK CD 0.21%08/14/23 11/12/21 5,016,704 5,016,704 100.00 5,016,704 45 0.21% East West Bank CD 4.56%08/15/23 11/15/22 5,166,090 5,166,090 100.00 5,166,090 46 4.67% East West Bank CD 5.02%08/15/23 02/15/23 4,145,390 4,145,390 100.00 4,145,390 46 5.15% Texas Capital Bank CD 3.30%08/24/23 08/24/22 2,569,662 2,569,662 100.00 2,569,662 55 3.30% FHLB Aaa/AA+3.63%09/13/23 09/13/22 13,350,000 13,347,723 99.61 13,295,077 75 3.71% FFCB Aaa/AA+0.22%09/22/23 09/13/22 925,000 917,711 99.64 914,394 84 3.74% Veritex Community Bank CD 0.25%09/25/23 09/24/21 10,043,790 10,043,790 100.00 10,043,790 87 0.25% Bank OZK CD 4.93%09/30/23 03/30/23 25,312,574 25,312,574 100.00 25,312,574 92 5.05% Bank OZK CD 0.20%10/09/23 10/08/21 5,016,767 5,016,767 100.00 5,016,767 101 0.20% East West Bank CD 5.18%10/12/23 04/12/23 13,777,849 13,777,849 100.00 13,777,849 104 5.32% FHLB Aaa/AA+0.00%10/13/23 10/17/22 2,500,000 2,468,208 98.60 2,465,046 105 4.56% East West Bank CD 4.76%10/18/23 01/18/23 10,216,163 10,216,163 100.00 10,216,163 110 4.87% East West Bank CD 4.53%10/19/23 10/19/22 2,580,380 2,580,380 100.00 2,580,380 111 4.63% FHLB Aaa/AA+5.17%10/24/23 02/27/23 10,000,000 9,840,822 99.73 9,845,225 116 5.17% Bank OZK CD 0.30%11/13/23 11/12/21 10,047,690 10,047,690 100.00 10,047,690 136 0.30% East West Bank CD 5.33%11/13/23 05/10/23 3,104,697 3,104,697 100.00 3,104,697 136 5.47% East West Bank CD 5.33%11/15/23 05/15/23 5,148,542 5,148,542 100.00 5,148,542 138 5.47% FAMCA 4.75%11/22/23 11/22/22 2,000,000 2,000,000 99.73 1,994,665 145 4.75% East West Bank CD 5.29%12/11/23 03/09/23 9,149,924 9,149,924 100.00 9,149,924 164 5.43% FAMCA 4.95%12/13/23 12/13/22 10,000,000 10,000,000 99.62 9,962,084 166 4.95% East West Bank CD 5.59%12/20/23 06/22/22 2,581,244 2,581,244 100.00 2,581,244 173 2.98% Alliance Bank CD 5.10%12/27/23 12/27/22 1,025,592 1,025,592 100.00 1,025,592 180 5.20% Bank OZK CD 4.93%12/30/23 03/30/23 26,325,077 26,325,077 100.00 26,325,077 183 5.05% Alliance Bank CD 5.15%01/12/24 01/13/23 5,063,493 5,063,493 100.00 5,063,493 196 5.25% June 30, 2023 City of Georgetown Valley View Consulting, L.L.C.55 City - Investment Holdings Coupon/Maturity Settlement Face Amount/Book Market Market Life Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield June 30, 2023 East West Bank CD 4.99%01/12/24 04/12/23 10,109,963 10,109,963 100.00 10,109,963 196 5.12% East West Bank CD 4.71%01/18/24 01/18/23 10,213,869 10,213,869 100.00 10,213,869 202 4.82% Veritex Community Bank CD 4.84%01/23/24 01/23/23 10,201,840 10,201,840 100.00 10,201,840 207 4.95% East West Bank CD 5.09%01/26/24 04/26/23 4,036,983 4,036,983 100.00 4,036,983 210 5.22% Southside Bank CD 3.32%02/02/24 08/02/22 10,250,379 10,250,379 100.00 10,250,379 217 3.32% Independent Financial CD 5.15%02/15/24 05/15/23 12,050,795 12,050,795 100.00 12,050,795 230 5.27% FHLB Aaa/AA+5.35%02/28/24 03/06/23 20,000,000 20,000,000 99.92 19,983,180 243 5.35% East West Bank CD 5.24%03/11/24 03/09/23 10,164,995 10,164,995 100.00 10,164,995 255 5.38% BOK Financial CD 4.88%03/23/24 02/22/23 8,107,655 8,107,655 100.00 8,107,655 267 5.00% Third Coast Bank CD 5.65%03/28/24 06/28/23 8,000,000 8,000,000 100.00 8,000,000 272 5.77% Bank OZK CD 4.92%04/18/24 04/18/23 10,082,558 10,082,558 100.00 10,082,558 293 5.04% East West Bank CD 4.92%04/26/24 04/26/23 10,089,355 10,089,355 100.00 10,089,355 301 5.04% Independent Financial CD 4.99%05/09/24 02/09/23 8,089,683 8,089,683 100.00 8,089,683 314 5.08% T-Note Aaa/AA+0.25%05/15/24 11/22/22 2,000,000 1,925,053 95.63 1,912,656 320 4.72% BOK Financial CD 5.10%05/16/24 05/18/23 8,000,000 8,000,000 100.00 8,000,000 321 5.23% Alliance Bank CD 5.10%06/14/24 12/15/22 10,255,918 10,255,918 100.00 10,255,918 350 5.20% East West Bank CD 5.32%06/17/24 06/16/23 15,489,078 15,489,078 100.00 15,489,078 353 5.46% Alliance Bank CD 5.10%06/27/24 12/27/22 13,435,856 13,435,856 100.00 13,435,856 363 5.20% Independent Financial CD 4.50%07/24/24 01/23/23 10,109,726 10,109,726 100.00 10,109,726 390 4.58% FHLB Aaa/AA+5.18%07/26/24 02/28/23 10,000,000 10,000,000 99.63 9,962,974 392 5.18% FFCB Aaa/AA+4.88%08/21/24 02/27/23 4,000,000 3,986,073 99.23 3,969,138 418 5.19% Alliance Bank CD 5.10%12/13/24 12/15/22 10,255,918 10,255,918 100.00 10,255,918 532 5.20% T-Note Aaa/AA+1.00%12/15/24 06/14/23 5,000,000 4,728,259 94.10 4,705,078 534 4.91% Third Coast Bank CD 5.10%06/28/25 06/28/23 10,000,000 10,000,000 100.00 10,000,000 729 5.20% TOTALS 900,162,740$ 899,583,011$ 899,378,504$ 108 4.86% (1)(2) (2)Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds. (1)Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity. (3)Earnings Credit - The City's depository accounts provide an earnings credit on balances which is used to offset bank fees. City of Georgetown Valley View Consulting, L.L.C.56 0–6 Months71% 6–12 Months23% 12–18 Months4% 18+ Months2% Current Quarter Maturities $0 $100,000,000 $200,000,000 $300,000,000 $400,000,000 $500,000,000 $600,000,000 $700,000,000 $800,000,000 $900,000,000 $1,000,000,000 09/30/22 12/31/22 03/31/23 06/30/23 Portfolio Balances Money Market Local Depository TexSTAR TexPool Certificate of Deposit Securities 166174166 102 69 90 7375 109104 123 156163 97108 87 51 67 4941 91 73 6154 99 71 124 95100 8070676358 818274 104113123 156 78 97 128 108 0 50 100 150 200 # o f D a y s Weighted Average to Maturity JPMorgan Chase0%Wells Fargo Bank2% Texas Capital Bank0%Southside Bank 1% Veritex Community Bank 3% Bank OZK10% NexBank2% TexPool5% TexSTAR47% Alliance Bank5% East West Bank14% T-Note1% FHLB7% BOK Financial2% FFCB1% Portfolio Holdings by Issuer City of Georgetown Valley View Consulting, L.L.C. 57 City - Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 03/31/23 Increases Decreases Book Value 06/30/23 Market Value 03/31/23 Change in Market Value Market Value 06/30/23 JPMorgan Chase Cash 0.00%07/01/23 758,592$ –$ (140,455)$ 618,137$ 758,592$ (140,455)$ 618,137$ JPMorgan Chase MMA 1.60%07/01/23 436,688 1,635 – 438,323 436,688 1,635 438,323 Wells Fargo Bank Cash 0.00%07/01/23 42,112 185,698 – 227,810 42,112 185,698 227,810 Wells Fargo Bank Sweep-MMF 4.95%07/01/23 12,164,479 5,137,706 – 17,302,185 12,164,479 5,137,706 17,302,185 Veritex Community Bank MMA 5.20%07/01/23 3,304,419 41,248 – 3,345,666 3,304,419 41,248 3,345,666 NexBank MMA 5.30%07/01/23 12,749,708 164,799 – 12,914,507 12,749,708 164,799 12,914,507 TexPool 5.05%07/01/23 30,752,271 10,049,478 – 40,801,750 30,752,271 10,049,478 40,801,750 TexSTAR 5.08%07/01/23 250,398,587 146,924,318 – 397,322,905 250,398,587 146,924,318 397,322,905 East West Bank CD 4.16%04/12/23 13,605,580 – (13,605,580) – 13,605,580 (13,605,580) – East West Bank CD 4.16%4/12/2023 20,385,946 – (20,385,946) – 20,385,946 (20,385,946) – Prosperity Bank CD 0.20%4/24/2023 5,019,186 – (5,019,186) – 5,019,186 (5,019,186) – Prosperity Bank CD 0.20%5/1/2023 5,018,361 – (5,018,361) – 5,018,361 (5,018,361) – Alliance Bank CD 2.98%5/2/2023 4,059,706 – (4,059,706) – 4,059,706 (4,059,706) – Texas Capital Bank CD 2.90%5/4/2023 1,271,232 – (1,271,232) – 1,271,232 (1,271,232) – East West Bank CD 3.27%5/10/2023 3,070,630 – (3,070,630) – 3,070,630 (3,070,630) – FHLB 4.60%5/10/2023 23,880,000 – (23,880,000) – 23,887,843 (23,887,843) – East West Bank CD 4.62%5/15/2023 5,085,546 – (5,085,546) – 5,085,546 (5,085,546) – Bank OZK CD 0.20%6/12/2023 5,028,894 – (5,028,894) – 5,028,894 (5,028,894) – East West Bank CD 3.04%6/16/2023 15,359,336 – (15,359,336) – 15,359,336 (15,359,336) – Texas Capital Bank CD 3.42%6/16/2023 5,085,517 – (5,085,517) – 5,085,517 (5,085,517) – Alliance Bank CD 5.20%6/27/2023 8,100,603 – (8,100,603) – 8,100,603 (8,100,603) – FHLB 3.97%6/29/2023 9,903,875 – (9,903,875) – 9,887,246 (9,887,246) – R Bank CD 0.73%6/30/2023 1,012,842 – (1,012,842) – 1,012,842 (1,012,842) – Alliance Bank CD 3.14%07/01/23 4,093,809 – –4,093,809 4,093,809 – 4,093,809 FHLB 4.47%07/31/23 4,926,885 54,537 – 4,981,422 4,922,799 58,448 4,981,247 East West Bank CD 3.10%08/01/23 2,047,081 15,625 – 2,062,706 2,047,081 15,625 2,062,706 Alliance Bank CD 3.19%08/02/23 1,015,942 7,803 – 1,023,746 1,015,942 7,803 1,023,746 Bank OZK CD 0.21%08/14/23 5,014,037 2,667 – 5,016,704 5,014,037 2,667 5,016,704 East West Bank CD 4.67%08/15/23 5,107,694 58,396 – 5,166,090 5,107,694 58,396 5,166,090 East West Bank CD 5.15%08/15/23 4,093,834 51,555 – 4,145,390 4,093,834 51,555 4,145,390 Texas Capital Bank CD 3.30%08/24/23 2,548,378 21,284 – 2,569,662 2,548,378 21,284 2,569,662 FHLB 3.71%09/13/23 13,344,961 2,763 – 13,347,723 13,279,879 15,198 13,295,077 FFCB 3.74%09/22/23 909,814 7,897 – 917,711 905,050 9,343 914,394 Veritex Community Bank CD 0.25%09/25/23 10,037,463 6,326 – 10,043,790 10,037,463 6,326 10,043,790 Bank OZK CD 5.05%09/30/23 25,000,000 312,574 – 25,312,574 25,000,000 312,574 25,312,574 Bank OZK CD 0.20%10/09/23 5,014,227 2,541 – 5,016,767 5,014,227 2,541 5,016,767 East West Bank CD 5.32%10/12/23 – 13,777,849 – 13,777,849 – 13,777,849 13,777,849 FHLB 4.56%10/13/23 2,440,656 27,553 – 2,468,208 2,438,472 26,574 2,465,046 East West Bank CD 4.87%10/18/23 10,095,648 120,515 – 10,216,163 10,095,648 120,515 10,216,163 East West Bank CD 4.63%10/19/23 2,551,403 28,977 – 2,580,380 2,551,403 28,977 2,580,380 FHLB 5.17%10/24/23 9,715,950 124,872 – 9,840,822 9,740,046 105,178 9,845,225 City of Georgetown Valley View Consulting, L.L.C.58 City - Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 03/31/23 Increases Decreases Book Value 06/30/23 Market Value 03/31/23 Change in Market Value Market Value 06/30/23 Bank OZK CD 0.30%11/13/23 10,040,071 7,619 – 10,047,690 10,040,071 7,619 10,047,690 East West Bank CD 5.47%11/13/23 – 3,104,697 – 3,104,697 – 3,104,697 3,104,697 East West Bank CD 5.47%11/15/23 – 5,148,542 – 5,148,542 – 5,148,542 5,148,542 FAMCA 4.75%11/22/23 2,000,000 – – 2,000,000 1,999,879 (5,214) 1,994,665 East West Bank CD 5.43%12/11/23 9,030,049 119,875 – 9,149,924 9,030,049 119,875 9,149,924 FAMCA 4.95%12/13/23 10,000,000 – – 10,000,000 9,986,696 (24,612) 9,962,084 Alliance Bank CD 5.20%12/27/23 1,012,575 13,016 – 1,025,592 1,012,575 13,016 1,025,592 East West Bank CD 2.98%12/20/23 2,560,349 20,896 – 2,581,244 2,560,349 20,896 2,581,244 Bank OZK CD 5.05%12/30/23 26,000,000 325,077 – 26,325,077 26,000,000 325,077 26,325,077 Alliance Bank CD 5.25%01/12/24 5,000,000 63,493 – 5,063,493 5,000,000 63,493 5,063,493 East West Bank CD 5.12%01/12/24 – 10,109,963 – 10,109,963 – 10,109,963 10,109,963 East West Bank CD 4.82%01/18/24 10,094,639 119,230 – 10,213,869 10,094,639 119,230 10,213,869 Veritex Community Bank CD 4.95%01/23/24 10,078,388 123,451 – 10,201,840 10,078,388 123,451 10,201,840 East West Bank CD 5.22%01/26/24 – 4,036,983 – 4,036,983 – 4,036,983 4,036,983 Southside Bank CD 3.32%02/02/24 10,168,065 82,314 – 10,250,379 10,168,065 82,314 10,250,379 Independent Financial CD 5.27%02/15/24 – 12,050,795 – 12,050,795 – 12,050,795 12,050,795 FHLB 5.35%02/28/24 20,000,000 – – 20,000,000 20,084,080 (100,900) 19,983,180 East West Bank CD 5.38%03/11/24 10,033,071 131,923 – 10,164,995 10,033,071 131,923 10,164,995 BOK Financial CD 5.00%03/23/24 8,009,630 98,025 – 8,107,655 8,009,630 98,025 8,107,655 Third Coast Bank CD 5.77%03/28/24 – 8,000,000 – 8,000,000 – 8,000,000 8,000,000 Bank OZK CD 5.04%04/18/24 – 10,082,558 – 10,082,558 – 10,082,558 10,082,558 East West Bank CD 5.04%04/26/24 – 10,089,355 – 10,089,355 – 10,089,355 10,089,355 Independent Financial CD 5.08%05/09/24 8,000,000 89,683 – 8,089,683 8,000,000 89,683 8,089,683 T-Note 4.72%05/15/24 1,903,741 21,313 – 1,925,053 1,907,656 5,000 1,912,656 BOK Financial CD 5.23%05/16/24 – 8,000,000 – 8,000,000 – 8,000,000 8,000,000 Alliance Bank CD 5.20%06/14/24 10,125,753 130,164 – 10,255,918 10,125,753 130,164 10,255,918 East West Bank CD 5.46%06/17/24 – 15,489,078 – 15,489,078 – 15,489,078 15,489,078 Alliance Bank CD 5.20%06/27/24 13,265,333 170,523 – 13,435,856 13,265,333 170,523 13,435,856 Independent Financial CD 4.58%07/24/24 10,000,000 109,726 – 10,109,726 10,000,000 109,726 10,109,726 FHLB 5.18%07/26/24 10,000,000 – – 10,000,000 10,065,863 (102,889) 9,962,974 FFCB 5.19%08/21/24 3,983,041 3,032 – 3,986,073 4,009,236 (40,098) 3,969,138 Alliance Bank CD 5.20%12/13/24 10,125,753 130,164 – 10,255,918 10,125,753 130,164 10,255,918 T-Note 4.91%12/15/24 – 4,728,259 – 4,728,259 – 4,705,078 4,705,078 Third Coast Bank CD 5.20%06/28/25 – 10,000,000 – 10,000,000 – 10,000,000 10,000,000 TOTAL / AVERAGE 4.86%745,882,348$ 279,728,371$ (126,027,707)$ 899,583,011$ 745,988,174$ 153,390,330$ 899,378,504$ City of Georgetown Valley View Consulting, L.L.C.59 City - Allocation Investment Total Consolidated 2014 Revenue Water WW Debt Service 2 2015 CO- Parks/Streets/ Vehicles 2015 GO- Roads 2015 Revenue Water WW 2016 GO- Roads Garey Park Donation 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Roads JPMorgan Chase Cash 618,137$ 618,137$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 438,323 438,323 – – – – – – – – – – – Wells Fargo Bank Cash 227,810 227,810 – – – – – – – – – – – Wells Fargo Bank Sweep-MMF 17,302,185 17,302,185 – – – – – – – – – – – Veritex Community Bank MMA 3,345,666 3,345,666 – – – – – – – – – – – NexBank MMA 12,914,507 12,914,507 – – – – – – – – – – – TexPool 40,801,750 40,801,750 – – – – – – – – – – – TexSTAR 397,322,905 49,336,669 435,925 30,325,458 118,782 1,644,861 1,592,110 1,693 1,100,146 7,754,618 30,229 273,546 1,129,847 Alliance Bank CD 07/01/23 4,093,809 4,093,809 – – – – – – – – – – – FHLB 07/31/23 4,981,422 4,981,422 – – – – – – – – – – – East West Bank CD 08/01/23 2,062,706 – – – – – – – – – – – – Alliance Bank CD 08/02/23 1,023,746 – – – – – – – – – – – – Bank OZK CD 08/14/23 5,016,704 5,016,704 – – – – – – – – – – – East West Bank CD 08/15/23 5,166,090 – – – – – – – – – – – – East West Bank CD 08/15/23 4,145,390 – – – – – – – – – – – – Texas Capital Bank CD 08/24/23 2,569,662 2,569,662 – – – – – – – – – – – FHLB 09/13/23 13,347,723 – – – – – – – – – – – – FFCB 09/22/23 917,711 – – – – – – – – – – – – Veritex Community Bank CD 09/25/23 10,043,790 10,043,790 – – – – – – – – – – – Bank OZK CD 09/30/23 25,312,574 – – – – – – – – – – – – Bank OZK CD 10/09/23 5,016,767 5,016,767 – – – – – – – – – – – East West Bank CD 10/12/23 13,777,849 – – – – – – – – – – – – FHLB 10/13/23 2,468,208 2,468,208 – – – – – – – – – – – East West Bank CD 10/18/23 10,216,163 – – – – – – – – – – – – East West Bank CD 10/19/23 2,580,380 2,580,380 – – – – – – – – – – – FHLB 10/24/23 9,840,822 – – – – – – – – – – – – Bank OZK CD 11/13/23 10,047,690 10,047,690 – – – – – – – – – – – East West Bank CD 11/13/23 3,104,697 – – – – – – – – 3,104,697 – – – East West Bank CD 11/15/23 5,148,542 – – – – – – – – – – – – FAMCA 11/22/23 2,000,000 2,000,000 – – – – – – – – – – – East West Bank CD 12/11/23 9,149,924 9,149,924 – – – – – – – – – – – FAMCA 12/13/23 10,000,000 10,000,000 – – – – – – – – – – – East West Bank CD 12/20/23 2,581,244 – – – – – – – – – – – – Alliance Bank CD 12/27/23 1,025,592 1,025,592 – – – – – – – – – – – Bank OZK CD 12/30/23 26,325,077 – – – – – – – – – – – – Alliance Bank CD 01/12/24 5,063,493 5,063,493 – – – – – – – – – – – East West Bank CD 01/12/24 10,109,963 – – – – – – – – – – – – East West Bank CD 01/18/24 10,213,869 – – – – – – – – – – – – Veritex Community Bank CD 01/23/24 10,201,840 10,201,840 – – – – – – – – – – – East West Bank CD 01/26/24 4,036,983 – – – – – – – – – – – – Southside Bank CD 02/02/24 10,250,379 – – – – – – – – – – – – Independent Financial CD 02/15/24 12,050,795 – – – – – – – – – – – – FHLB 02/28/24 20,000,000 20,000,000 – – – – – – – – – – – East West Bank CD 03/11/24 10,164,995 – – – – – – – – – – – – BOK Financial CD 03/23/24 8,107,655 8,107,655 – – – – – – – – – – – Third Coast Bank CD 03/28/24 8,000,000 – – – – – – – – – – – – Bank OZK CD 04/18/24 10,082,558 – – – – – – – – – – – – East West Bank CD 04/26/24 10,089,355 10,089,355 – – – – – – – – – – – Independent Financial CD 05/09/24 8,089,683 8,089,683 – – – – – – – – – – – T-Note 05/15/24 1,925,053 1,925,053 – – – – – – – – – – – BOK Financial CD 05/16/24 8,000,000 – – – – – – – – – – – – Alliance Bank CD 06/14/24 10,255,918 – – – – – – – – – – – – East West Bank CD 06/17/24 15,489,078 15,489,078 – – – – – – – – – – – Alliance Bank CD 06/27/24 13,435,856 13,435,856 – – – – – – – – – – – Independent Financial CD 07/24/24 10,109,726 – – – – – – – – – – – – FHLB 07/26/24 10,000,000 – – – – – – – – – – – – FFCB 08/21/24 3,986,073 3,986,073 – – – – – – – – – – – Alliance Bank CD 12/13/24 10,255,918 – – – – – – – – – – – – T-Note 12/15/24 4,728,259 4,728,259 – – – – – – – – – – – Third Coast Bank CD 06/28/25 10,000,000 10,000,000 – – – – – – – – – – – Totals 899,583,011$ 305,095,340$ 435,925$ 30,325,458$ 118,782$ 1,644,861$ 1,592,110$ 1,693$ 1,100,146$ 10,859,315$ 30,229$ 273,546$ 1,129,847$ Book Value June 30, 2023 City of Georgetown Valley View Consulting, L.L.C.60 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 East West Bank CD 10/12/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 East West Bank CD 11/13/23 East West Bank CD 11/15/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 East West Bank CD 12/20/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 East West Bank CD 01/26/24 Southside Bank CD 02/02/24 Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24 Independent Financial CD 05/09/24 T-Note 05/15/24 BOK Financial CD 05/16/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 Third Coast Bank CD 06/28/25 Totals Book Value June 30, 2023 (Continued) 2019 CO- Streets/ Facilities/ Equip 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 GO- Roads Electric-LCRA Transformers City - 2021 CO Airport City - 2021 CO Fac/Equip/ Parks City - 2021 GO Parks City - 2021 GO Roads City - 2021A CO Electric City - 2021A CO Water/WW City - 2021A GO Roads City - 2022 CO Airport –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,890,569 2,831,964 589,778 4,151,964 3,955,599 727,530 4,295,171 14,367 2,521,872 431,192 4,742,713 9,428,111 519,293 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,062,706 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,166,090 – – – – – – – 4,145,390 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,148,542 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,581,244 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,890,569$ 2,831,964$ 589,778$ 6,214,670$ 3,955,599$ 727,530$ 8,440,561$ 14,367$ 2,521,872$ 431,192$ 7,323,957$ 19,742,743$ 519,293$ City of Georgetown Valley View Consulting, L.L.C.61 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 East West Bank CD 10/12/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 East West Bank CD 11/13/23 East West Bank CD 11/15/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 East West Bank CD 12/20/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 East West Bank CD 01/26/24 Southside Bank CD 02/02/24 Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24 Independent Financial CD 05/09/24 T-Note 05/15/24 BOK Financial CD 05/16/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 Third Coast Bank CD 06/28/25 Totals Book Value June 30, 2023 (Continued) City - 2022 CO Fac/Equip/Parks City - 2022 CO Stormwater City - 2022 GO Parks City - 2022 GO Roads City - 2022 CO Electric City - 2022 CO Water/WW City - 2023 CO Fac/Equip/Parks City - 2023 CO Stormwater City - 2023 GO Parks City - 2023 GO Roads City - 2023 Revenue Electric City - 2023 Revenue Water/WW –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,987,910 175,646 4,292,338 9,588,061 6,817,853 37,760,378 25,624,527 661,438 7,031,869 25,956,188 13,671,429 93,918,647 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,023,746 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,347,723 – – – – – – – – – – – – 917,711 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,777,849 – – – – – – – – – – – – – – – – – – – – – – – – – 10,216,163 – – – – – – – – – – – –– – – – – – – – – – – 9,840,822 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – 26,325,077 – – – – – – – – – – – –– – – – – – – – – – – 10,109,963 – – – – – – – – – – – 10,213,869 – – – – – – – – – – – –– – – – – – – – – 4,036,983 – –– – – – – – – – – – – 10,250,379 – – – – – – – – – – – 12,050,795 – – – – – – – – – – – –– – – – – – – – – – – 10,164,995 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – 10,082,558 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – 8,000,000 – – – – – – – – – – – 10,255,918 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – 10,109,726 – – – – – – – – – – – 10,000,000 – – – – – – – – – – – –– – – – – – – – – – – 10,255,918 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – 3,011,656$ 175,646$ 4,292,338$ 40,750,615$ 7,735,564$ 195,636,559$ 25,624,527$ 661,438$ 7,031,869$ 25,956,188$ 13,671,429$ 93,918,647$ City of Georgetown Valley View Consulting, L.L.C.62 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 East West Bank CD 10/12/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 East West Bank CD 11/13/23 East West Bank CD 11/15/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 East West Bank CD 12/20/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 East West Bank CD 01/26/24 Southside Bank CD 02/02/24 Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24 Independent Financial CD 05/09/24 T-Note 05/15/24 BOK Financial CD 05/16/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 Third Coast Bank CD 06/28/25 Totals Book Value June 30, 2023 (Continued) City - American Rescue Plan City - Impact Fees - Water City - Impact Fees - WW City - Limited Tax Note, Series 2022 –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – 7,884,881 14,983,599 9,293,584 3,830,552 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 25,312,574 – – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –8,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 7,884,881$ 40,296,173$ 17,293,584$ 3,830,552$ City of Georgetown Valley View Consulting, L.L.C.63 City - Allocation June 30, 2023 Market Value Investment Total Consolidated 2014 Revenue Water WW Debt Service 2 2015 CO- Parks/Streets/ Vehicles 2015 GO- Roads 2015 Revenue Water WW 2016 GO- Roads Garey Park Donation 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Roads JPMorgan Chase Cash 618,137$ 618,137$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 438,323 438,323 – – – – – – – – – – – Wells Fargo Bank Cash 227,810 227,810 – – – – – – – – – – – Wells Fargo Bank Sweep-MMF 17,302,185 17,302,185 – – – – – – – – – – – Veritex Community Bank MMA 3,345,666 3,345,666 – – – – – – – – – – – NexBank MMA 12,914,507 12,914,507 – – – – – – – – – – – TexPool 40,801,750 40,801,750 – – – – – – – – – – – TexSTAR 397,322,905 49,336,669 435,925 30,325,458 118,782 1,644,861 1,592,110 1,693 1,100,146 7,754,618 30,229 273,546 1,129,847 Alliance Bank CD 07/01/23 4,093,809 4,093,809 – – – – – – – – – – – FHLB 07/31/23 4,981,247 4,981,247 – – – – – – – – – – – East West Bank CD 08/01/23 2,062,706 – – – – – – – – – – – – Alliance Bank CD 08/02/23 1,023,746 – – – – – – – – – – – – Bank OZK CD 08/14/23 5,016,704 5,016,704 – – – – – – – – – – – East West Bank CD 08/15/23 5,166,090 – – – – – – – – – – – – East West Bank CD 08/15/23 4,145,390 – – – – – – – – – – – – Texas Capital Bank CD 08/24/23 2,569,662 2,569,662 – – – – – – – – – – – FHLB 09/13/23 13,295,077 – – – – – – – – – – – – FFCB 09/22/23 914,394 – – – – – – – – – – – – Veritex Community Bank CD 09/25/23 10,043,790 10,043,790 – – – – – – – – – – – Bank OZK CD 09/30/23 25,312,574 – – – – – – – – – – – – Bank OZK CD 10/09/23 5,016,767 5,016,767 – – – – – – – – – – – East West Bank CD 10/12/23 13,777,849 – – – – – – – – – – – – FHLB 10/13/23 2,465,046 2,465,046 – – – – – – – – – – – East West Bank CD 10/18/23 10,216,163 – – – – – – – – – – – – East West Bank CD 10/19/23 2,580,380 2,580,380 – – – – – – – – – – – FHLB 10/24/23 9,845,225 – – – – – – – – – – – – Bank OZK CD 11/13/23 10,047,690 10,047,690 – – – – – – – – – – – East West Bank CD 11/13/23 3,104,697 – – – – – – – – 3,104,697 – – – East West Bank CD 11/15/23 5,148,542 – – – – – – – – – – – – FAMCA 11/22/23 1,994,665 1,994,665 – – – – – – – – – – – East West Bank CD 12/11/23 9,149,924 9,149,924 – – – – – – – – – – – FAMCA 12/13/23 9,962,084 9,962,084 – – – – – – – – – – – East West Bank CD 12/20/23 2,581,244 – – – – – – – – – – – – Alliance Bank CD 12/27/23 1,025,592 1,025,592 – – – – – – – – – – – Bank OZK CD 12/30/23 26,325,077 – – – – – – – – – – – – Alliance Bank CD 01/12/24 5,063,493 5,063,493 – – – – – – – – – – – East West Bank CD 01/12/24 10,109,963 – – – – – – – – – – – – East West Bank CD 01/18/24 10,213,869 – – – – – – – – – – – – Veritex Community Bank CD 01/23/24 10,201,840 10,201,840 – – – – – – – – – – – East West Bank CD 01/26/24 4,036,983 – – – – – – – – – – – – Southside Bank CD 02/02/24 10,250,379 – – – – – – – – – – – – Independent Financial CD 02/15/24 12,050,795 – – – – – – – – – – – – FHLB 02/28/24 19,983,180 19,983,180 – – – – – – – – – – – East West Bank CD 03/11/24 10,164,995 – – – – – – – – – – – – BOK Financial CD 03/23/24 8,107,655 8,107,655 – – – – – – – – – – – Third Coast Bank CD 03/28/24 8,000,000 – – – – – – – – – – – – Bank OZK CD 04/18/24 10,082,558 – – – – – – – – – – – – East West Bank CD 04/26/24 10,089,355 10,089,355 – – – – – – – – – – – Independent Financial CD 05/09/24 8,089,683 8,089,683 – – – – – – – – – – – T-Note 05/15/24 1,912,656 1,912,656 – – – – – – – – – – – BOK Financial CD 05/16/24 8,000,000 – – – – – – – – – – – – Alliance Bank CD 06/14/24 10,255,918 – – – – – – – – – – – – East West Bank CD 06/17/24 15,489,078 15,489,078 – – – – – – – – – – – Alliance Bank CD 06/27/24 13,435,856 13,435,856 – – – – – – – – – – – Independent Financial CD 07/24/24 10,109,726 – – – – – – – – – – – – FHLB 07/26/24 9,962,974 – – – – – – – – – – – – FFCB 08/21/24 3,969,138 3,969,138 – – – – – – – – – – – Alliance Bank CD 12/13/24 10,255,918 – – – – – – – – – – – – T-Note 12/15/24 4,705,078 4,705,078 – – – – – – – – – – – Third Coast Bank CD 06/28/25 10,000,000 10,000,000 – – – – – – – – – – – Totals 899,378,504$ 304,979,419$ 435,925$ 30,325,458$ 118,782$ 1,644,861$ 1,592,110$ 1,693$ 1,100,146$ 10,859,315$ 30,229$ 273,546$ 1,129,847$ City of Georgetown Valley View Consulting, L.L.C.64 City - Allocation June 30, 2023 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 East West Bank CD 10/12/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 East West Bank CD 11/13/23 East West Bank CD 11/15/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 East West Bank CD 12/20/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 East West Bank CD 01/26/24 Southside Bank CD 02/02/24 Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24 Independent Financial CD 05/09/24 T-Note 05/15/24 BOK Financial CD 05/16/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 Third Coast Bank CD 06/28/25 Totals (Continued) 2019 CO- Streets/ Facilities/ Equip 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 GO- Roads Electric-LCRA Transformers City - 2021 CO Airport City - 2021 CO Fac/Equip/ Parks City - 2021 GO Parks City - 2021 GO Roads City - 2021A CO Electric City - 2021A CO Water/WW City - 2021A GO Roads City - 2022 CO Airport –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,890,569 2,831,964 589,778 4,151,964 3,955,599 727,530 4,295,171 14,367 2,521,872 431,192 4,742,713 9,428,111 519,293 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,062,706 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,166,090 – – – – – – – 4,145,390 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,148,542 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,581,244 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,890,569$ 2,831,964$ 589,778$ 6,214,670$ 3,955,599$ 727,530$ 8,440,561$ 14,367$ 2,521,872$ 431,192$ 7,323,957$ 19,742,743$ 519,293$ City of Georgetown Valley View Consulting, L.L.C.65 City - Allocation June 30, 2023 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 East West Bank CD 10/12/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 East West Bank CD 11/13/23 East West Bank CD 11/15/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 East West Bank CD 12/20/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 East West Bank CD 01/26/24 Southside Bank CD 02/02/24 Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24 Independent Financial CD 05/09/24 T-Note 05/15/24 BOK Financial CD 05/16/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 Third Coast Bank CD 06/28/25 Totals (Continued) City - 2022 CO Fac/Equip/Parks City - 2022 CO Stormwater City - 2022 GO Parks City - 2022 GO Roads City - 2022 CO Electric City - 2022 CO Water/WW City - 2023 CO Fac/Equip/Parks City - 2023 CO Stormwater City - 2023 GO Parks City - 2023 GO Roads City - 2023 Revenue Electric City - 2023 Revenue Water/WW –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,987,910 175,646 4,292,338 9,588,061 6,817,853 37,760,378 25,624,527 661,438 7,031,869 25,956,188 13,671,429 93,918,647 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,023,746 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,295,077 – – – – – – – – – – – – 914,394 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,777,849 – – – – – – – – – – – – – – – – – – – – – – – – – 10,216,163 – – – – – – – – – – – –– – – – – – – – – – – 9,845,225 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – 26,325,077 – – – – – – – – – – – –– – – – – – – – – – – 10,109,963 – – – – – – – – – – – 10,213,869 – – – – – – – – – – – –– – – – – – – – – 4,036,983 – –– – – – – – – – – – – 10,250,379 – – – – – – – – – – – 12,050,795 – – – – – – – – – – – –– – – – – – – – – – – 10,164,995 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – 10,082,558 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – 8,000,000 – – – – – – – – – – – 10,255,918 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – 10,109,726 – – – – – – – – – – – 9,962,974 – – – – – – – – – – – –– – – – – – – – – – – 10,255,918 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – 3,011,656$ 175,646$ 4,292,338$ 40,697,969$ 7,732,247$ 195,603,936$ 25,624,527$ 661,438$ 7,031,869$ 25,956,188$ 13,671,429$ 93,918,647$ City of Georgetown Valley View Consulting, L.L.C.66 City - Allocation June 30, 2023 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 East West Bank CD 10/12/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 East West Bank CD 11/13/23 East West Bank CD 11/15/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 East West Bank CD 12/20/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 East West Bank CD 01/26/24 Southside Bank CD 02/02/24 Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24 Independent Financial CD 05/09/24 T-Note 05/15/24 BOK Financial CD 05/16/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 Third Coast Bank CD 06/28/25 Totals (Continued) City - American Rescue Plan City - Impact Fees - Water City - Impact Fees - WW City - Limited Tax Note, Series 2022 –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – 7,884,881 14,983,599 9,293,584 3,830,552 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 25,312,574 – – – –– – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 7,884,881$ 40,296,173$ 17,293,584$ 3,830,552$ City of Georgetown Valley View Consulting, L.L.C.67 City - Allocation Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Streets/ Vehicles 2015 GO- Roads 2015 Revenue Water WW 2016 GO- Roads Garey Park Donation 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Roads JPMorgan Chase Cash 758,592$ 758,592$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 436,688 436,688 – – – – – – – – – – – Wells Fargo Bank Cash 42,112 42,112 – – – – – – – – – – – Wells Fargo Bank Sweep-MMF 12,164,479 12,164,479 – – – – – – – – – – – Veritex Community Bank MMA 3,304,419 3,304,419 – – – – – – – – – – – NexBank MMA 12,749,708 12,749,708 – – – – – – – – – – – TexPool 30,752,271 30,752,271 – – – – – – – – – – – TexSTAR 250,398,587 37,854,861 451,459 29,705,689 140,951 1,894,898 1,572,488 431,220 1,086,587 7,762,382 44,041 315,240 1,282,110 East West Bank CD 04/12/23 13,605,580 – – – – – – – – – – – – East West Bank CD 04/12/23 20,385,946 – – – – – – – – – – – – Prosperity Bank CD 04/24/23 5,019,186 5,019,186 – – – – – – – – – – – Prosperity Bank CD 05/01/23 5,018,361 5,018,361 – – – – – – – – – – – Alliance Bank CD 05/02/23 4,059,706 – – – – – – – – – – – – Texas Capital Bank CD 05/04/23 1,271,232 – – – – – – – – – – – – East West Bank CD 05/10/23 3,070,630 – – – – – – – – 3,070,630 – – – FHLB 05/10/23 23,880,000 – – – – – – – – – – – – East West Bank CD 05/15/23 5,085,546 – – – – – – – – – – – – Bank OZK CD 06/12/23 5,028,894 5,028,894 – – – – – – – – – – – East West Bank CD 06/16/23 15,359,336 15,359,336 – – – – – – – – – – – Texas Capital Bank CD 06/16/23 5,085,517 5,085,517 – – – – – – – – – – – East West Bank CD 06/20/23 2,560,349 – – – – – – – – – – – – Alliance Bank CD 06/27/23 8,100,603 – – – – – – – – – – – – FHLB 06/29/23 9,903,875 9,903,875 – – – – – – – – – – – R Bank CD 06/30/23 1,012,842 1,012,842 – – – – – – – – – – – Alliance Bank CD 07/01/23 4,093,809 4,093,809 – – – – – – – – – – – FHLB 07/31/23 4,926,885 4,926,885 – – – – – – – – – – – East West Bank CD 08/01/23 2,047,081 – – – – – – – – – – – – Alliance Bank CD 08/02/23 1,015,942 – – – – – – – – – – – – Bank OZK CD 08/14/23 5,014,037 5,014,037 – – – – – – – – – – – East West Bank CD 08/15/23 5,107,694 – – – – – – – – – – – – East West Bank CD 08/15/23 4,093,834 – – – – – – – – – – – – Texas Capital Bank CD 08/24/23 2,548,378 2,548,378 – – – – – – – – – – – FHLB 09/13/23 13,344,961 – – – – – – – – – – – – FFCB 09/22/23 909,814 – – – – – – – – – – – – Veritex Community Bank CD 09/25/23 10,037,463 10,037,463 – – – – – – – – – – – Bank OZK CD 09/30/23 25,000,000 – – – – – – – – – – – – Bank OZK CD 10/09/23 5,014,227 5,014,227 – – – – – – – – – – – FHLB 10/13/23 2,440,656 2,440,656 – – – – – – – – – – – East West Bank CD 10/18/23 10,095,648 – – – – – – – – – – – – East West Bank CD 10/19/23 2,551,403 2,551,403 – – – – – – – – – – – FHLB 10/24/23 9,715,950 – – – – – – – – – – – – Bank OZK CD 11/13/23 10,040,071 10,040,071 – – – – – – – – – – – FAMCA 11/22/23 2,000,000 2,000,000 – – – – – – – – – – – East West Bank CD 12/11/23 9,030,049 9,030,049 – – – – – – – – – – – FAMCA 12/13/23 10,000,000 10,000,000 – – – – – – – – – – – Alliance Bank CD 12/27/23 1,012,575 1,012,575 – – – – – – – – – – – Bank OZK CD 12/30/23 26,000,000 – – – – – – – – – – – – Alliance Bank CD 01/12/24 5,000,000 5,000,000 – – – – – – – – – – – East West Bank CD 01/18/24 10,094,639 – – – – – – – – – – – – Veritex Community Bank CD 01/23/24 10,078,388 10,078,388 – – – – – – – – – – – Southside Bank CD 02/02/24 10,168,065 – – – – – – – – – – – – FHLB 02/28/24 20,000,000 20,000,000 – – – – – – – – – – – East West Bank CD 03/11/24 10,033,071 – – – – – – – – – – – – BOK Financial CD 03/23/24 8,009,630 8,009,630 – – – – – – – – – – – Independent Financial CD 05/09/24 8,000,000 8,000,000 – – – – – – – – – – – T-Note 05/15/24 1,903,741 1,903,741 – – – – – – – – – – – Alliance Bank CD 06/14/24 10,125,753 – – – – – – – – – – – – Alliance Bank CD 06/27/24 13,265,333 13,265,333 – – – – – – – – – – – Independent Financial CD 07/24/24 10,000,000 – – – – – – – – – – – – FHLB 07/26/24 10,000,000 – – – – – – – – – – – – FFCB 08/21/24 3,983,041 3,983,041 – – – – – – – – – – – Alliance Bank CD 12/13/24 10,125,753 – – – – – – – – – – – – Totals 745,882,348$ 283,440,824$ 451,459$ 29,705,689$ 140,951$ 1,894,898$ 1,572,488$ 431,220$ 1,086,587$ 10,833,012$ 44,041$ 315,240$ 1,282,110$ March 31, 2023 Book Value City of Georgetown Valley View Consulting, L.L.C.68 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR East West Bank CD 04/12/23 East West Bank CD 04/12/23 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Alliance Bank CD 05/02/23 Texas Capital Bank CD 05/04/23 East West Bank CD 05/10/23 FHLB 05/10/23 East West Bank CD 05/15/23 Bank OZK CD 06/12/23 East West Bank CD 06/16/23 Texas Capital Bank CD 06/16/23 East West Bank CD 06/20/23 Alliance Bank CD 06/27/23 FHLB 06/29/23 R Bank CD 06/30/23 Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 Southside Bank CD 02/02/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Independent Financial CD 05/09/24 T-Note 05/15/24 Alliance Bank CD 06/14/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 Totals March 31, 2023 Book Value (Continued) 2019 CO- Streets/ Facilities/ Equip 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 CO- Stormwater 2020 GO- Roads Electric-LCRA Transformers City - 2021 CO Airport City - 2021 CO Fac/Equip/ Parks City - 2021 GO Parks City - 2021 GO Roads City - 2021A CO Electric City - 2021A CO Water/WW City - 2021A GO Roads City - 2022 CO Airport –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,137,096 2,798,356 613,672 114 4,116,405 3,798,399 718,563 5,507,046 175,586 3,026,941 434,425 6,022,715 12,009,359 512,893 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,085,546 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,560,349 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,047,081 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,107,694 – – – – – – – – 4,093,834 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,137,096$ 2,798,356$ 613,672$ 114$ 6,163,486$ 3,798,399$ 718,563$ 9,600,880$ 175,586$ 3,026,941$ 434,425$ 8,583,063$ 22,202,598$ 512,893$ City of Georgetown Valley View Consulting, L.L.C.69 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR East West Bank CD 04/12/23 East West Bank CD 04/12/23 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Alliance Bank CD 05/02/23 Texas Capital Bank CD 05/04/23 East West Bank CD 05/10/23 FHLB 05/10/23 East West Bank CD 05/15/23 Bank OZK CD 06/12/23 East West Bank CD 06/16/23 Texas Capital Bank CD 06/16/23 East West Bank CD 06/20/23 Alliance Bank CD 06/27/23 FHLB 06/29/23 R Bank CD 06/30/23 Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 Southside Bank CD 02/02/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Independent Financial CD 05/09/24 T-Note 05/15/24 Alliance Bank CD 06/14/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 Totals March 31, 2023 Book Value (Continued) City - 2022 CO Fac/Equip/Parks City - 2022 CO Stormwater City - 2022 GO Parks City - 2022 GO Roads City - 2022 CO Electric City - 2022 CO Water/WW City - American Rescue Plan City - Impact Fees - Water City - Impact Fees - WW City - Limited Tax Note, Series 2022 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,544,995 285,644 4,407,763 8,393,483 4,279,361 39,069,046 7,839,223 42,050,571 9,112,481 4,002,526 – – – 13,605,580 – – – – – – – – – – – 20,385,946 – – – – – – – – – –– – – – – – – – – –– – – – – – – 4,059,706 – –– – – – – – – 1,271,232 – –– – – – – – – – – –– – – – – – – – 3,980,000 19,900,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,100,603 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,015,942 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,344,961 – – – – – – – – – – 909,814 – – – – – – – – – – – – – – – – – – – – – – 25,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,095,648 – – – – – – – – – –– – – – – – – – – 9,715,950 – – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – – – – – – 26,000,000 – – – – – – – – – –– – – – – – – – – 10,094,639 – – – – – – – – – – – – – – – – – – – 10,168,065 – – – – – – – – – –– – – – – – – – – 10,033,071 – – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – – – – – – 10,125,753 – – – – – – – – – –– – – – – – – – – 10,000,000 – – – – – – – – – 10,000,000 – – – – – – – – – –– – – – – – – – – 10,125,753 – – – – 3,560,937$ 285,644$ 4,407,763$ 40,674,962$ 9,169,175$ 195,713,872$ 7,839,223$ 67,050,571$ 17,213,084$ 4,002,526$ City of Georgetown Valley View Consulting, L.L.C.70 City - Allocation March 31, 2023 Market Value Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Streets/ Vehicles 2015 GO- Roads 2015 Revenue Water WW 2016 GO- Roads Garey Park Donation 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Roads JPMorgan Chase Cash 758,592$ 758,592$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 436,688 436,688 – – – – – – – – – – – Wells Fargo Bank Cash 42,112 42,112 – – – – – – – – – – – Wells Fargo Bank Sweep-MMF 12,164,479 12,164,479 – – – – – – – – – – – Veritex Community Bank MMA 3,304,419 3,304,419 – – – – – – – – – – – NexBank MMA 12,749,708 12,749,708 – – – – – – – – – – – TexPool 30,752,271 30,752,271 – – – – – – – – – – – TexSTAR 250,398,587 37,854,861 451,459 29,705,689 140,951 1,894,898 1,572,488 431,220 1,086,587 7,762,382 44,041 315,240 1,282,110 East West Bank CD 04/12/23 13,605,580 – – – – – – – – – – – – East West Bank CD 04/12/23 20,385,946 – – – – – – – – – – – – Prosperity Bank CD 04/24/23 5,019,186 5,019,186 – – – – – – – – – – – Prosperity Bank CD 05/01/23 5,018,361 5,018,361 – – – – – – – – – – – Alliance Bank CD 05/02/23 4,059,706 – – – – – – – – – – – – Texas Capital Bank CD 05/04/23 1,271,232 – – – – – – – – – – – – East West Bank CD 05/10/23 3,070,630 – – – – – – – – 3,070,630 – – – FHLB 05/10/23 23,887,843 – – – – – – – – – – – – East West Bank CD 05/15/23 5,085,546 – – – – – – – – – – – – Bank OZK CD 06/12/23 5,028,894 5,028,894 – – – – – – – – – – – East West Bank CD 06/16/23 15,359,336 15,359,336 – – – – – – – – – – – Texas Capital Bank CD 06/16/23 5,085,517 5,085,517 – – – – – – – – – – – East West Bank CD 06/20/23 2,560,349 – – – – – – – – – – – – Alliance Bank CD 06/27/23 8,100,603 – – – – – – – – – – – – FHLB 06/29/23 9,887,246 9,887,246 – – – – – – – – – – – R Bank CD 06/30/23 1,012,842 1,012,842 – – – – – – – – – – – Alliance Bank CD 07/01/23 4,093,809 4,093,809 – – – – – – – – – – – FHLB 07/31/23 4,922,799 4,922,799 – – – – – – – – – – – East West Bank CD 08/01/23 2,047,081 – – – – – – – – – – – – Alliance Bank CD 08/02/23 1,015,942 – – – – – – – – – – – – Bank OZK CD 08/14/23 5,014,037 5,014,037 – – – – – – – – – – – East West Bank CD 08/15/23 5,107,694 – – – – – – – – – – – – East West Bank CD 08/15/23 4,093,834 – – – – – – – – – – – – Texas Capital Bank CD 08/24/23 2,548,378 2,548,378 – – – – – – – – – – – FHLB 09/13/23 13,279,879 – – – – – – – – – – – – FFCB 09/22/23 905,050 – – – – – – – – – – – – Veritex Community Bank CD 09/25/23 10,037,463 10,037,463 – – – – – – – – – – – Bank OZK CD 09/30/23 25,000,000 – – – – – – – – – – – – Bank OZK CD 10/09/23 5,014,227 5,014,227 – – – – – – – – – – – FHLB 10/13/23 2,438,472 2,438,472 – – – – – – – – – – – East West Bank CD 10/18/23 10,095,648 – – – – – – – – – – – – East West Bank CD 10/19/23 2,551,403 2,551,403 – – – – – – – – – – – FHLB 10/24/23 9,740,046 – – – – – – – – – – – – Bank OZK CD 11/13/23 10,040,071 10,040,071 – – – – – – – – – – – FAMCA 11/22/23 1,999,879 1,999,879 – – – – – – – – – – – East West Bank CD 12/11/23 9,030,049 9,030,049 – – – – – – – – – – – FAMCA 12/13/23 9,986,696 9,986,696 – – – – – – – – – – – Alliance Bank CD 12/27/23 1,012,575 1,012,575 – – – – – – – – – – – Bank OZK CD 12/30/23 26,000,000 – – – – – – – – – – – – Alliance Bank CD 01/12/24 5,000,000 5,000,000 – – – – – – – – – – – East West Bank CD 01/18/24 10,094,639 – – – – – – – – – – – – Veritex Community Bank CD 01/23/24 10,078,388 10,078,388 – – – – – – – – – – – Southside Bank CD 02/02/24 10,168,065 – – – – – – – – – – – – FHLB 02/28/24 20,084,080 20,084,080 – – – – – – – – – – – East West Bank CD 03/11/24 10,033,071 – – – – – – – – – – – – BOK Financial CD 03/23/24 8,009,630 8,009,630 – – – – – – – – – – – Independent Financial CD 05/09/24 8,000,000 8,000,000 – – – – – – – – – – – T-Note 05/15/24 1,907,656 1,907,656 – – – – – – – – – – – Alliance Bank CD 06/14/24 10,125,753 – – – – – – – – – – – – Alliance Bank CD 06/27/24 13,265,333 13,265,333 – – – – – – – – – – – Independent Financial CD 07/24/24 10,000,000 – – – – – – – – – – – – FHLB 07/26/24 10,065,863 – – – – – – – – – – – – FFCB 08/21/24 4,009,236 4,009,236 – – – – – – – – – – – Alliance Bank CD 12/13/24 10,125,753 – – – – – – – – – – – – Totals 745,988,174$ 283,518,692$ 451,459$ 29,705,689$ 140,951$ 1,894,898$ 1,572,488$ 431,220$ 1,086,587$ 10,833,012$ 44,041$ 315,240$ 1,282,110$ City of Georgetown Valley View Consulting, L.L.C.71 City - Allocation March 31, 2023 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR East West Bank CD 04/12/23 East West Bank CD 04/12/23 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Alliance Bank CD 05/02/23 Texas Capital Bank CD 05/04/23 East West Bank CD 05/10/23 FHLB 05/10/23 East West Bank CD 05/15/23 Bank OZK CD 06/12/23 East West Bank CD 06/16/23 Texas Capital Bank CD 06/16/23 East West Bank CD 06/20/23 Alliance Bank CD 06/27/23 FHLB 06/29/23 R Bank CD 06/30/23 Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 Southside Bank CD 02/02/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Independent Financial CD 05/09/24 T-Note 05/15/24 Alliance Bank CD 06/14/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 Totals (Continued) 2019 CO- Streets/ Facilities/ Equip 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 CO- Stormwater 2020 GO- Roads Electric-LCRA Transformers City - 2021 CO Airport City - 2021 CO Fac/Equip/ Parks City - 2021 GO Parks City - 2021 GO Roads City - 2021A CO Electric City - 2021A CO Water/WW City - 2021A GO Roads City - 2022 CO Airport –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,137,096 2,798,356 613,672 114 4,116,405 3,798,399 718,563 5,507,046 175,586 3,026,941 434,425 6,022,715 12,009,359 512,893 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,085,546 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,560,349 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,047,081 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,107,694 – – – – – – – – 4,093,834 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,137,096$ 2,798,356$ 613,672$ 114$ 6,163,486$ 3,798,399$ 718,563$ 9,600,880$ 175,586$ 3,026,941$ 434,425$ 8,583,063$ 22,202,598$ 512,893$ City of Georgetown Valley View Consulting, L.L.C.72 City - Allocation March 31, 2023 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR East West Bank CD 04/12/23 East West Bank CD 04/12/23 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Alliance Bank CD 05/02/23 Texas Capital Bank CD 05/04/23 East West Bank CD 05/10/23 FHLB 05/10/23 East West Bank CD 05/15/23 Bank OZK CD 06/12/23 East West Bank CD 06/16/23 Texas Capital Bank CD 06/16/23 East West Bank CD 06/20/23 Alliance Bank CD 06/27/23 FHLB 06/29/23 R Bank CD 06/30/23 Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 Southside Bank CD 02/02/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Independent Financial CD 05/09/24 T-Note 05/15/24 Alliance Bank CD 06/14/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 Totals (Continued) City - 2022 CO Fac/Equip/Parks City - 2022 CO Stormwater City - 2022 GO Parks City - 2022 GO Roads City - 2022 CO Electric City - 2022 CO Water/WW City - American Rescue Plan City - Impact Fees - Water City - Impact Fees - WW City - Limited Tax Note, Series 2022 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,544,995 285,644 4,407,763 8,393,483 4,279,361 39,069,046 7,839,223 42,050,571 9,112,481 4,002,526 – – – 13,605,580 – – – – – – – – – – – 20,385,946 – – – – – – – – – –– – – – – – – – – –– – – – – – – 4,059,706 – –– – – – – – – 1,271,232 – –– – – – – – – – – –– – – – – – – – 3,981,307 19,906,536 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,100,603 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,015,942 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,279,879 – – – – – – – – – – 905,050 – – – – – – – – – – – – – – – – – – – – – – 25,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,095,648 – – – – – – – – – –– – – – – – – – – 9,740,046 – – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – – – – – – 26,000,000 – – – – – – – – – –– – – – – – – – – 10,094,639 – – – – – – – – – – – – – – – – – – – 10,168,065 – – – – – – – – – –– – – – – – – – – 10,033,071 – – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – – – – – – 10,125,753 – – – – – – – – – –– – – – – – – – – 10,000,000 – – – – – – – – – 10,065,863 – – – – – – – – – –– – – – – – – – – 10,125,753 – – – – 3,560,937$ 285,644$ 4,407,763$ 40,609,880$ 9,165,719$ 195,810,368$ 7,839,223$ 67,050,571$ 17,213,084$ 4,002,526$ City of Georgetown Valley View Consulting, L.L.C.73 Georgetown Economic Development Corporation (GEDCO) QUARTERLY INVESTMENT REPORT For the Quarter Ended June 30, 2023 Prepared by Valley View Consulting, L.L.C. ________________________________________________________________________ Leigh Wallace Nathan Parras Finance Director Assistant Finance Director ________________________________________________________________________ Karrie Pursley Elaine Wilson Treasurer Assistant Finance Director The investment portfolio of the Georgetown Economic Development Corporation (GEDCO) is in compliance with the Texas Public Funds Investment Act and the Investment Policy and Strategies. Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total return yields and do not account for investment advisor fees. 74 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield MMA 2,191,077$ 2,191,077$ 2,218,434$ 2,218,434$ 5.20% Pools 8,038,391 8,038,391 8,662,192 8,662,192 5.08% 10,229,468$ 10,229,468$ 10,880,626$ 10,880,626$ 5.11% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 5.11%Total Portfolio 4.61% Rolling Three Month Treasury 5.28%Rolling Three Month Treasury 4.75% Rolling Six Month Treasury 5.08%Rolling Six Month Treasury 4.57% TexPool 5.05%TexPool 4.55% Interest income provided in separate report. March 31, 2023 (1)Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank, pool, and money market balances. (2)Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. June 30, 2023 Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.75 Economic Overview 6/30/2023 The Federal Open Market Committee (FOMC) paused and kept the Fed Funds target range 5.00% - 5.25% June 14th (Effective Fed Funds are trading +/-5.08%). Another increase is projected after the July 25-26 meeting. First quarter 2023 GDP (Final) recorded 2.0%. June Non-Farm Payroll added 209k new jobs, below the 230k projection. The three month average declined to 244k. The S&P Stock Index continues moderate increases, trading +/-4,400. The yield curve rose from last month but remains steeply inverted with the expectation of future FOMC rate decreases. Crude Oil trades over +/-$70 per barrel. Inflation declined slightly but is still over the FOMC 2% target (Core PCE +/-4.6% and CPI +/-5.3%). The Ukrainian/Russian war and Middle East conflicts increase market anxiety. 02505007501,0001,2501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,0004,2504,5004,7505,0005,250 S&P 500 0.00 0.50 1.00 1.50 2.00 2.50 3.00 3.50 4.00 4.50 5.00 5.50 6.00 US Treasury Historical Yields - Since Nov 2015 Six Month T-Bill Two Year T-Note Ten Year T-Note 0.00 1.00 2.00 3.00 4.00 5.00 6.00 Treasury Yield Curves June 30, 2022 March 31, 2023 June 30, 2023 0.00 0.50 1.00 1.50 2.00 2.50 3.00 3.50 4.00 4.50 5.00 5.50 6.00 US Treasury Historical Yields - Since 2006 Six Month T-Bill Two Year T-Note Ten Year T-Note Valley View Consulting, L.L.C.76 Investment Holdings Coupon/Maturity Settlement Face Amount/Book Market Market Life Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield Veritex Bank MMA 5.20%07/01/23 06/30/23 2,218,434$ 2,218,434$ 1.00 2,218,434$ 1 5.20% TexasDAILY AAAm 5.10%07/01/23 06/30/23 2,211,780 2,211,780 1.00 2,211,780 1 5.10% TexSTAR AAAm 5.08%07/01/23 06/30/23 6,450,412 6,450,412 1.00 6,450,412 1 5.08% 10,880,626$ 10,880,626$ 10,880,626$ 1 5.11% (1)(2) June 30, 2023 (1)Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity. (2)Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds. Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.77 MMA 20% Pools 80% Certificates of Deposit 0% GEDCO PORTFOLIO COMPOSITION $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 9/30/2022 12/31/2022 3/31/2023 6/30/2023 GEDCO PORTFOLIO BALANCES CD TexasDAILY TexSTAR Money Market Georgetown Economic Development Corporation (GEDCO) Valley View Consulting, L.L.C.78 Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 03/31/23 Increases Decreases Book Value 06/30/23 Market Value 03/31/23 Change in Market Value Market Value 06/30/23 Veritex Bank MMA 5.20%07/01/23 2,191,077$ 27,358$ –$ 2,218,434$ 2,191,077$ 27,358$ 2,218,434$ TexasDAILY 5.10%07/01/23 2,184,423 27,357 – 2,211,780 2,184,423 27,357 2,211,780 TexSTAR 5.08%07/01/23 5,853,968 596,443 – 6,450,412 5,853,968 596,443 6,450,412 TOTAL / AVERAGE 5.11%10,229,468$ 651,158$ –$ 10,880,626$ 10,229,468$ 651,158$ 10,880,626$ Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.79 Georgetown Transportation Enhancement Corporation (GTEC) QUARTERLY INVESTMENT REPORT For the Quarter Ended June 30, 2023 Prepared byValley View Consulting, L.L.C. ___________________________________ Leigh Wallace Finance Director ___________________________________ Karrie Pursley _____________________________________ Nathan Parras Assistant Finance Director ____________________________________ Elaine Wilson Assistant Finance DirectorTreasurer The investment portfolio of the Georgetown Transportation Enhancement Corporation (GTEC) is in compliance with the Texas Public Funds Investment Act and the Investment Policy and Strategies. Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total return yields and do not account for investment advisor fees.80 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield Pools/MMAs 36,212,462$ 36,212,462$ 35,611,949$ 35,611,949$ 5.07% CDs/Securities 9,976,394 9,975,810 10,085,562 10,082,914 5.04%Totals 46,188,855$ 46,188,271$ 45,697,510$ 45,694,863$ 5.06% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 5.06%Total Portfolio 4.55% Rolling Three Month Treasury 5.28%Rolling Three Month Treasury 4.75% Rolling Six Month Treasury 5.08%Rolling Six Month Treasury 4.57% TexPool 5.05%TexPool 4.55% Interest data provided in separate report. March 31, 2023 (1)Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank, pool, and money market balances. (2)Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. June 30, 2023 Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.81 Economic Overview 6/30/2023 The Federal Open Market Committee (FOMC) paused and kept the Fed Funds target range 5.00% - 5.25% June 14th (Effective Fed Funds are trading +/-5.08%). Another increase is projected after the July 25-26 meeting. First quarter 2023 GDP (Final) recorded 2.0%. June Non-Farm Payroll added 209k new jobs, below the 230k projection. The three month average declined to 244k. The S&P Stock Index continues moderate increases, trading +/-4,400. The yield curve rose from last month but remains steeply inverted with the expectation of future FOMC rate decreases. Crude Oil trades over +/-$70 per barrel. Inflation declined slightly but is still over the FOMC 2% target (Core PCE +/-4.6% and CPI +/-5.3%). The Ukrainian/Russian war and Middle East conflicts increase market anxiety. 02505007501,0001,2501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,0004,2504,5004,7505,0005,250 S&P 500 0.00 0.50 1.00 1.50 2.00 2.50 3.00 3.50 4.00 4.50 5.00 5.50 6.00 US Treasury Historical Yields - Since Nov 2015 Six Month T-Bill Two Year T-Note Ten Year T-Note 0.00 1.00 2.00 3.00 4.00 5.00 6.00 Treasury Yield Curves June 30, 2022 March 31, 2023 June 30, 2023 0.00 0.50 1.00 1.50 2.00 2.50 3.00 3.50 4.00 4.50 5.00 5.50 6.00 US Treasury Historical Yields - Since 2006 Six Month T-Bill Two Year T-Note Ten Year T-Note Valley View Consulting, L.L.C.82 Investment Holdings Coupon/Maturity Settlement Face Amount/Book Market Market Life Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield TexPool AAAm 5.05%07/01/23 06/30/23 27,950,747$ 27,950,747$ 1.00 27,950,747$ 1 5.05% TexSTAR AAAm 5.08%07/01/23 06/30/23 4,861,964 4,861,964 1.00 4,861,964 1 5.08% Veritex Bank MMA 5.20%07/01/23 06/30/23 2,799,238 2,799,238 1.00 2,799,238 1 5.20% FAMCA 0.22%8/11/2023 11/10/22 5,000,000 4,974,123 99.43 4,971,475 42 4.84% Independent Financial CD 4.95%2/9/2024 02/09/23 2,022,241 2,022,241 100.00 2,022,241 224 5.04% East West Bank CD 5.22%05/28/24 05/25/23 3,089,198 3,089,198 100.00 3,089,198 333 5.36% TOTALS 45,723,387$ 45,697,510$ 45,694,863$ 38 5.06% (1)(2) June 30, 2023 (1)Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity. (2)Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds. Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.83 Pools/MMAs 78% CDs/Securities 22% GTEC PORTFOLIO COMPOSITION $0 $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 $35,000,000 $40,000,000 $45,000,000 $50,000,000 9/30/2022 12/31/2022 3/31/2023 6/30/2023 GTEC PORTFOLIO BALANCES CD TexPool TexSTAR Money Mark Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.84 Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 03/31/23 Increases Decreases Book Value 06/30/23 Market Value 03/31/23 Change in Market Value Market Value 06/30/23 TexPool 5.05%07/01/23 24,659,744$ 3,291,003$ –$ 27,950,747$ 24,659,744$ 3,291,003$ 27,950,747$ TexSTAR 5.08%07/01/23 8,787,994 – (3,926,030) 4,861,964 8,787,994 (3,926,030) 4,861,964 Veritex Bank MMA 5.20%07/01/23 2,764,724 34,514 – 2,799,238 2,764,724 34,514 2,799,238 East West Bank CD 3.26%05/25/23 3,058,337 – (3,058,337) – 3,058,337 (3,058,337) – FAMCA 4.84%8/11/2023 4,918,056 56,067 – 4,974,123 4,917,472 54,003 4,971,475 Independent Financial CD 5.04%2/9/2024 2,000,000 22,241 – 2,022,241 2,000,000 22,241 2,022,241 East West Bank CD 5.36%05/28/24 – 3,089,198 – 3,089,198 – 3,089,198 3,089,198 TOTAL / AVERAGE 5.06%46,188,855$ 6,493,023$ (6,984,367)$ 45,697,510$ 46,188,271$ (493,409)$ 45,694,863$ Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.85 Department Federal Grantor Pass-Through Agency Identifying Number COG Name/Purpose YTD Expenditures YTD Revenue Recognized Airport Federal Aviation Administration Texas Department of Transportation 21TWGEORG Airport 2021 CARES - Tower 22,654 - Airport Federal Aviation Administration Texas Department of Transportation 2314GRGTN Airport Pavement Project 169,400 - Airport Federal Aviation Administration Texas Department of Transportation 22CVGEORG Airport Rescue Plan 59,000 59,000 Arts & Culture Texas Commission on the Arts FY22 Performance Grant - Sue Foley 2,250 2,250 Emergency Management US Dept. of the Treasury American Rescue Plan Act SLFRF Funding 263,428 263,428 Library N/A St. David's Foundation St. David's Grant - 1,302 40,000 Planning US Department of Housing & Urban Development Williamson County CDBG 21st St Infrastructure - - Planning US Department of Housing & Urban Development Williamson County CDBG Home Repair (FY21)25,234 20,592 Police US. Department of Justice N/A TX2460200 Equitable Sharing Agreement - - Police US. Department of Treasury N/A TX2460200 Equitable Sharing Agreement - - Public Works Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ 0914-05-201 Highway Planning & Construction (Lakeway & Williams Drive) - 293,149 Electric Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ 2211-02-019 FM 1460 Road Widening (ROW Acquisition)* - - Public Works Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ 0914-05-200 Williams Drive Access Management (Study & Schematic) 76,163 76,163 *Expenses were incurred in FY2014-15, but reported here since TXDOT has now approved for reimbursement. Division Grantor COG Name/Purpose Status Public Works/Electric/City-Wide Federal Emergency Management Administration Texas Division of Emergency Management DR-4705-TX Winter Storm Mara Projects are in progress as of 3/31/23; Damage Inventory Meeting with FEMA 7/31/23 Reviewed By: Elaine Wilson CITY OF GEORGETOWN Grant/Federal Funding Report as of June 30, 2023 Active Applications Pending Award 86 City of Georgetown Capital Projects Life to Date Project Budget Total Spend Remaining Budget Percentage Remaining CDBG PRJ000003 17th Street 193,000 175,137 17,863 9% PRJ000248 21st W/WW offsite CDBG 97,000 44,882 52,118 54% CDBG Total 290,000 220,019 69,981 24% Electric PRJ000022 Consultant Engineering 271,352 100,825 170,527 63% PRJ000026 Db Wood_Sh29 Intersection 240,000 170,413 69,587 29% PRJ000036 Electrical System Improvement 100,000 20,045 79,955 80% PRJ000062 New Development Projects 20,138,379 7,671,768 12,466,611 62% PRJ000073 Power Quality Improvements 50,000 - 50,000 100% PRJ000147 Sectionalization Improvements 2,537,531 706,891 1,830,640 72% PRJ000175 I-35 Mobility Project TxDot 291,544 280,864 10,680 4% PRJ000189 Ronald Reagan - Glasscock Feeder Extension along Hwy 195 -Phase I 560,000 403,341 156,659 28% PRJ000192 Ronald Reagan - Glasscock Feeder extension along Hwy 195 - Phase II 591,250 287,020 304,230 51% PRJ000195 Downtown Overhead Rehab 39,749 39,610 139 0% PRJ000221 Titan-Aviation Dr to IH35 Infrastructure Addition 1,834,634 1,358,129 476,504 26% PRJ000225 Chapel Hill, WS-11139 (GEO-45-C.3)558,411 460,205 98,206 18% PRJ000226 Wolf Ranch West - Section 1AG & 1BG 635,363 487,238 148,125 23% PRJ000227 Ascend Westinghouse Apartments 444,598 409,226 35,372 8% PRJ000229 Sun City NH 76 WS-11188 (GEO-18.2-N.51)288,163 205,450 82,713 29% PRJ000230 Sun City NH 78 296,400 118,796 177,604 60% PRJ000231 Georgetown Titan Development 1 & 2 140,428 118,222 22,206 16% PRJ000232 Texas Outdoor Power Building 1 91,414 64,415 26,999 30% PRJ000234 Summit at Westinghouse Self-Storage 223,812 225,735 (1,924) -1% PRJ000236 Medcore (Georgetown) Senior Living 330,770 228,423 102,347 31% PRJ000238 The Oscar at Georgetown 225,463 225,463 - 0% PRJ000239 Wolf Ranch West - Section 3 - Phase 2 865,561 478,836 386,725 45% PRJ000242 Allora North Georgetown 557,422 370,442 186,979 34% PRJ000243 Fairfield Inn - WS11346 131,340 43,084 88,256 67% PRJ000245 Morgan Mays Street Apartments 452,508 375,074 77,434 17% PRJ000246 Vida Apartments 198,248 182,952 15,297 8% PRJ000247 Georgetown (Longhorn) Travel Center Rev 193,845 129,463 64,381 33% PRJ000250 Georgetown Infiniti 135,633 56,891 78,742 58% PRJ000269 Substation Feeder Exits and Extensions 1,750,000 - 1,750,000 100% PRJ000270 System Improvements - Power Quality 1,061,650 61,650 1,000,000 94% PRJ000271 System Improvements - Capacity Upgrades 10,368,593 355,563 10,013,030 97% PRJ000272 Wolf Lakes 566,109 556,874 9,236 2% PRJ000273 The Grove II Townhomes 108,924 73,593 35,331 32% PRJ000282 ANB Systems - Interconnection Service Portal 80,000 32,963 47,037 59% PRJ000283 Partners Software and Implementation 120,864 120,864 - 0% PRJ000284 Woodgate Development 195,933 136,194 59,739 30% PRJ000285 Titan NorthPark 35 - Building 3 121,842 81,364 40,477 33% PRJ000286 Wolf Ranch West - Section 2G 489,900 591,922 (102,022) -21% PRJ000287 Gateway 35 - Building 1 266,676 217,899 48,777 18% PRJ000288 Round Rock 2 Apartments 509,917 614,445 (104,528) -20% PRJ000289 Wolf Lakes Offsite Utility 307,445 176,288 131,157 43% PRJ000290 Windmill Hill Blue Ridge Drive Extension 292,696 166,472 126,224 43% PRJ000291 Chick-Fil-A Expansion at WR SC 72,396 61,944 10,452 14% PRJ000292 Aviation Drive Extension - Lift Station 116,456 60,383 56,073 48% PRJ000296 Sun City NH10 - Phase B 122,543 224,010 (101,466) -83% PRJ000299 Wolf Lakes Apartments - Hines Tract 446,777 215,914 230,863 52% PRJ000300 Wolf Lakes Bella Lago Underground Extension 328,654 347,031 (18,377) -6% PRJ000301 Titan NorthPark 35 - Building 5 166,073 123,551 42,522 26% PRJ000302 Somerset Hills - Phase A-B 58,367 58,367 - 0% PRJ000303 Westinghouse Retail Center at Windmill Hill 69,152 42,798 26,354 38% PRJ000305 Medical Towers at Georgetown 96,487 68,872 27,614 29% PRJ000306 Toolman Business Park 168,802 241,552 (72,750) -43% PRJ000307 Sonrisa MOB, WS-11306, MPN-21-19 200,110 79,207 120,903 60% PRJ000308 Sun City Neighborhood 77 306,196 246,166 60,030 20% PRJ000309 Sun City NH 80 166,562 143,623 22,940 14% PRJ000312 Dutch Bros. Coffee at 1309 W. University 38,354 23,682 14,672 38% PRJ000313 Rivery Crossing (WS# 11264)156,254 79,967 76,287 49% PRJ000314 Hewlett Volkswagen 2022 Remodel (MPN# 21-106)43,767 9,395 34,372 79% PRJ000315 Hope Ranch (MPN# 21-104)118,282 67,139 51,143 43% PRJ000316 Wolf Lakes HEB (MPN# 21-95)219,543 149,768 69,775 32% PRJ000317 Blue Springs Business Park (MPN# 21-108)474,203 346,358 127,846 27% PRJ000318 Costco 270,223 261,684 8,539 3% PRJ000319 Georgetown Logistics (MPN# 21-87)453,870 402,606 51,264 11% PRJ000320 Amazon Sortation Facility 16,223 16,223 - 0% PRJ000321 Wolf Lakes - Bella June Extension 201,850 170,160 31,691 16% PRJ000329 Sun City NH 79 (MPN# 22-14)149,174 149,484 (310) 0% PRJ000330 2021 Airport Road Upgrade 484,281 223,255 261,026 54% PRJ000331 Quail Valley (Phase 1) URD Voltage Conversion 240,344 138,185 102,159 43% PRJ000334 Sun City Northpoint Amenity Center (MPN# 22-36)43,096 3,028 40,068 93% PRJ000335 Stonemont Windmill Hill Industrial (MPN# 22-32)115,968 74,860 41,108 35% PRJ000336 Wolf Lakes Ascension Seton Georgetown MOB (MPN# 22-9)114,712 51,798 62,914 55% PRJ000339 Mays Street Retail Center (MPN# 22-30)82,062 55,063 26,999 33% PRJ000340 Cellink (Gateway35 - Building 1) (MPN# 22-37)1,234,057 704,846 529,212 43% PRJ000341 Gateway35 Building 3 (MPN# 22-27)276,306 147,319 128,987 47% 87 City of Georgetown Capital Projects Life to Date Project Budget Total Spend Remaining Budget Percentage Remaining PRJ000342 Gateway35 Building 2 (MPN# 22-28)152,469 96,342 56,127 37% PRJ000343 Gantt Serenada Subdivision (MPN# 22-44)25,414 21,724 3,689 15% PRJ000345 Baylor Scott & White Expansion 147,236 84,536 62,700 43% PRJ000346 Novak Chandra Multifamily - Wolf Lakes Village 536,146 523,765 12,381 2% PRJ000347 Titan NorthPark 35 – Building 6 (MPN# 22-47)377,275 369,777 7,498 2% PRJ000348 The Summit at Westinghouse (MPN# 22-26)358,809 20,177 338,631 94% PRJ000349 System Improvements - Operation Technology (SCADA/AMI/Network/Utility Software)1,850,000 88,965 1,761,035 95% PRJ000350 System Improvements - Ordinary Replacements 2,640,000 572,116 2,067,884 78% PRJ000351 Sun City Neighborhood 66 & 92 - Phase 1 (MPN#22-39)717,139 296,618 420,521 59% PRJ000360 Windmill Hill – Commerce Blvd Expansion 81,250 63,153 18,097 22% PRJ000365 Wellhouse Business Park 22-61 243,092 153,766 89,326 37% PRJ000368 WILCO Children’s Advocacy Center 2022 Addition (MPN# 22-52)47,927 21,001 26,926 56% PRJ000381 Sun City NH 66 & 92 (MPN#22-39)239,213 237,353 1,860 1% PRJ000386 Rock Springs Hospital Expansion 2022 (MPN# 22-81)197,284 178,012 19,272 10% PRJ000390 Georgetown ISD - Future Ready Learning Complex (MPN# 22-50)424,557 322,643 101,915 24% PRJ000391 Longhorn Junction Logistics Center - ATS Option (MPN# 22-40)815,968 751,380 64,587 8% PRJ000392 Chapel Hill Phase II 514,996 220,186 294,811 57% PRJ000393 Georgetown Patio Homes - West Phase (MPN# 22 - 80)681,843 - 681,843 100% PRJ000394 Home2Suites 94,384 52,374 42,011 45% PRJ000395 Chance Leigh Custom Homes 4,923 3,363 1,559 32% PRJ000397 Joseph Stephens Smooth Current Electric 4,312 3,629 683 16% PRJ000398 Loram Technologies, Inc (MPN#22-60)354,037 185,587 168,450 48% PRJ000399 Austin Traffic Signal (1311 W University Ave - Blue Bonnet Plaza)20,542 - 20,542 100% PRJ000400 95 DB Wood Rd Traffic Signal 4,050 - 4,050 100% PRJ000401 1402, 1406, 1410 Country Club Road 31,663 31,663 - 0% PRJ000402 KL Electric - 3707 Brangus Road 3,283 2,800 483 15% PRJ000404 Georgetown Headend Power Expansion 39,064 - 39,064 100% PRJ000405 San Gabriel WW Treatment Expansion 111,508 55,993 55,515 50% PRJ000407 Woodfield Preserve - Phase 1 (MPN# 22-83)542,498 377,076 165,422 30% PRJ000408 Fiber Support Hut in Sun City 3,396 - 3,396 100% PRJ000410 Sun City NH 75 162,243 82,881 79,362 49% PRJ000411 University Storage (MPN# 22-96)122,981 14,482 108,499 88% PRJ000412 Villas of Georgetown 618,135 296,936 321,199 52% PRJ000413 Dish Wireless 4,276 - 4,276 100% PRJ000414 Dish Wireless - Deer Haven 8,230 443 7,788 95% PRJ000415 Titan Building 8 1,044,482 738,564 305,918 29% PRJ000416 The Human Bean 32,356 18,981 13,375 41% PRJ000418 Sun City NH65 288,395 28,000 260,395 90% PRJ000419 Sun City Ridge Top Well House-Partners 129,784 10,157 119,628 92% PRJ000420 Rivery Business Park 101,834 - 101,834 100% PRJ000421 Grace Episcopal West Campus 67,612 39,223 28,390 42% PRJ000422 Solid Waste Transfer Facility 179,406 - 179,406 100% PRJ000423 TXDOT Williams at Lakeway 1,619 - 1,619 100% PRJ000424 TXDOT Traffic Signal DB Wood @ SH29 4,050 - 4,050 100% PRJ000425 D&L Printing - 552 Stadium Dr 9,003 4,980 4,024 45% PRJ000426 Harmony Public School 175,217 - 175,217 100% PRJ000427 Woodfield Preserve - Phase 7 (MPN# 22-84)539,131 42,083 497,048 92% PRJ000428 2100 Coffee St 4,930 4,402 527 11% PRJ000429 SuddenLink - First United Methodist Church 10,874 10,874 - 0% PRJ000430 SuddenLink - Momentum Telecom 10,874 10,874 - 0% PRJ000431 KL Turner Electric 5,645 - 5,645 100% PRJ000432 Deer Haven Retail 48,443 - 48,443 100% PRJ000433 Westinghouse Business Park (MPN# 22-90)340,073 139,269 200,805 59% PRJ000434 Coregon Building Co 4,760 - 4,760 100% PRJ000435 Optimum Cable/ Cable TV Cabinet 5,206 - 5,206 100% PRJ000436 Vault Rabbit Hill, LP 77,666 54,033 23,633 30% PRJ000437 505 West University Ave. – Service Upgrade (MPN# 22-70)68,602 17,575 51,028 74% PRJ000438 Sun City Texas - Ridgetop Well (MPN# 22-98)129,784 104,868 24,916 19% PRJ000439 Tesla Charging Station - WR TC 66,433 25,033 41,399 62% PRJ000440 System Improvements - Voltage Conversion 3,400,000 5,384 3,394,616 100% PRJ000442 The Austin Dance Conservatory 4,276 - 4,276 100% PRJ000443 Verizon Tower Expansion 4,982 - 4,982 100% PRJ000445 Wolf Crossing Hotel Development 128,934 20,089 108,845 84% PRJ000448 Westlake Dermatology 172,172 - 172,172 100% PRJ000449 Healthy Smiles Dentistry 83,728 - 83,728 100% PRJ000450 TABB Improvement/Alvarado Property 9,914 8,139 1,775 18% PRJ000451 Dollar General 44,067 23,361 20,706 47% PRJ000452 Reynolds Electric 2,368 1,198 1,171 49% PRJ000454 GEORGETOWN AIRPORT SITE 3 HANGARS 62,940 18,412 44,528 71% PRJ000456 The League Kitchen & Tavern 31,161 21,229 9,932 32% PRJ000459 Winter Storm 2023 Tree Trimming 100,000 88,315 11,685 12% PRJ000460 2023 Winter Storm Pedro SS Services 100,000 35,627 64,373 64% PRJ000464 Southwestern University CHW Upgrades 175,779 - 175,779 100% PRJ000467 2023 Winter Storm Tree Trimming Services 100,000 - 100,000 100% PRJ000468 Lovesac - Wolf Ranch Town Center 4,520 - 4,520 100% PRJ000469 Chadwell Supply 6,991 1,571 5,420 78% PRJ000470 Inner Peace, LLC 325,285 - 325,285 100% PRJ000473 84 Lumber Yard Expansion 48,836 - 48,836 100% PRJ000474 Rega of Paris 34,303 12,148 22,155 65% PRJ000475 Titan NorthPark 35 Building 4 116,310 17,584 98,726 85% 88 City of Georgetown Capital Projects Life to Date Project Budget Total Spend Remaining Budget Percentage Remaining PRJ000476 Lone Star Circle of Care 218,676 - 218,676 100% PRJ000477 Georgetown Lake WTP EPSS - ATS 50,871 - 50,871 100% PRJ000478 SW Bypass Lighting - TXDOT 11,884 3,974 7,910 67% PRJ000481 Wesleyan at Estrella 31,278 16,679 14,599 47% PRJ000482 Inner Loop Storage 24,379 9,725 14,653 60% PRJ000483 Outback Steakhouse 44,156 - 44,156 100% PRJ000484 OnTrac - Windmill Hill 5,492 544 4,948 90% PRJ000485 Georgetown ISD - Georgetown HS Ag Barn 54,694 - 54,694 100% PRJ000489 Verizon Antenna - 293 Bass Pro Dr 7,572 3,463 4,109 54% PRJ000490 Verizon Antenna - 4307 N Mays St 7,056 2,057 4,999 71% PRJ000491 Verizon Antenna - 4561 N Mays st 5,123 2,057 3,066 60% PRJ000492 Verizon Antenna - 246 University Blvd 20,893 12,360 8,533 41% PRJ000493 Club Car Wash Parking Lot Addition 42,980 22,948 20,032 47% PRJ000498 Third Coast Bank 4,325 - 4,325 100% PRJ000499 Messer Residence - 1004 Falcon Flight Cove 2,718 9,745 (7,026) -258% PRJ000500 Stump Properties - 907 S Myrtle St 6,076 380 5,696 94% PRJ000502 The Retreat Lot 7 23,138 - 23,138 100% PRJ000503 Gabriel Substation Exit Feeders 250,000 - 250,000 100% PRJ000508 Waters Edge Apartments Maintenance Building 18,581 - 18,581 100% PRJ000510 4103 Val Verde Dr 5,987 - 5,987 100% PRJ000512 Optimum Cable Power Supply 5,376 73 5,304 99% PRJ000514 Clints Liquor 4,675 - 4,675 100% Electric Total 77,044,327 30,107,863 46,936,464 61% Environmental Services PRJ000116 Transfer Station 16,000,000 14,717,133 1,282,867 8% Environmental Services Total 16,000,000 14,717,133 1,282,867 8% Finance PRJ000038 ERP Project 6,231,654 6,060,063 171,591 3% Finance Total 6,231,654 6,060,063 171,591 3% Fire PRJ000134 SCBA Replacement 1,170,000 840,934 329,066 28% PRJ000135 Cardiac Monitors 633,517 628,258 5,258 1% PRJ000354 EMS Stryker Stretchers 193,534 193,534 - 0% Fire Total 1,997,051 1,662,727 334,324 17% Fleet PRJ000124 Radio Replacement 1,565,278 934,439 630,839 40% PRJ000279 Electric Bond Funded Vehicles - FY22 1,065,000 966,016 98,984 9% PRJ000280 Fire Bond Funded Vehicles - FY22 2,008,000 1,896,440 111,560 6% PRJ000281 Police Bond Funded Vehicles - FY22 1,277,000 1,218,785 58,215 5% PRJ000355 Bond Funded Fire Vehicles - FY23 2,158,750 3,478,988 (1,320,238) -61% PRJ000356 Bond Funded Police Vehicles - FY23 1,467,017 2,917,580 (1,450,564) -99% PRJ000357 Bond Funded Public Safety Boat 249,940 486,440 (236,500) -95% PRJ000361 Bond Funded Stormwater Street Sweeper 357,500 705,605 (348,105) -97% PRJ000366 Electric Bond Funded Vehicles - FY23 450,000 1,241,940 (791,940) -176% PRJ000388 Stormwater Vehicles/Equipment - FY 22 280,000 211,147 68,853 25% Fleet Total 10,878,485 14,057,380 (3,178,895) -29% GTEC Department PRJ000046 FM 971/ Fontana (Nw Bridge)1,209,000 1,206,390 2,610 0% PRJ000060 Rabbit Hill Road 4,474,639 646,215 3,828,423 86% PRJ000145 Sh29 Signal, Right Turn Lane, & Hard Median 1,540,824 480,679 1,060,146 69% PRJ000181 Aviation Drive 10,300,000 10,166,425 133,575 1% PRJ000183 Costco 2,000,000 - 2,000,000 100% PRJ000203 FM1460 Widening (300,984) - (300,984) 100% PRJ000265 Project Diana (Witteria Way - Gateway 35)1,700,000 1,700,000 - 0% PRJ000362 SH29 West (Wolf Ranch Pkwy to IH35)2,000,000 - 2,000,000 100% PRJ000528 IH35 and Inner Loop 8,321,760 - 8,321,760 100% PRJ000529 Lakeway/Airport Access 3,000,000 - 3,000,000 100% GTEC Department Total 34,245,239 14,199,709 20,045,530 59% Management Services PRJ000029 Downtown Parking Garage 1,356,040 166,546 1,189,494 88% PRJ000033 Dtwn Landsping & Public Art 5,746 5,746 - 0% PRJ000131 Fuel Station 1,100,000 2,200,158 (1,100,158) -100% PRJ000136 GMC Remodel Phase I 560,000 625,611 (65,611) -12% PRJ000178 Public Safety Operation and Training Center Phase II 6,000,000 5,390,167 609,833 10% PRJ000179 Recreation Center Teen/Senior Renovation 247,979 120,271 127,709 51% PRJ000184 Airport Maintenance Facility 1,450,000 116,000 1,334,000 92% PRJ000191 Georgetown City Center - Festival/Public Space 5,333,036 271,741 5,061,295 95% PRJ000223 Wayfinding Signage 275,000 90,615 184,385 67% PRJ000252 Fire Logistics Building 2,550,000 257,100 2,292,900 90% PRJ000337 Downtown Austin Ave Parking Garage - ARPA 7,800,000 1,026,874 6,773,126 87% PRJ000338 Downtown Austin Ave Parking Garage - Bond Funded 9,337,500 - 9,337,500 100% PRJ000352 Signature Gateway - Downtown 538,500 - 538,500 100% PRJ000353 Fire Station 1 7,829,498 524,000 7,305,498 93% PRJ000369 Bollards 60,000 59,361 639 1% 89 City of Georgetown Capital Projects Life to Date Project Budget Total Spend Remaining Budget Percentage Remaining PRJ000389 Tax Note Project Management, Series 2022 4,192,801 4,192,801 - 0% PRJ000488 Animal Shelter Kennel 111,000 - 111,000 100% Management Services Total 48,747,100 15,046,990 33,700,110 69% Parks PRJ000048 Garey Park 15,346,730 15,283,342 63,388 0% PRJ000125 Parks Master Plan 229,998 229,798 200 0% PRJ000126 Regional Trail Development 1,372,684 1,366,429 6,255 0% PRJ000129 Ada Transition Plan 1,308,689 889,335 419,354 32% PRJ000190 Heritage Gardens 275,860 248,153 27,707 10% PRJ000240 South Main Plaza 339,414 435,942 (96,528) -28% PRJ000249 GVPID Landscape Improvements 61,500 61,500 - 0% PRJ000253 Southeast Community Park 16,557,711 80,000 16,477,711 100% PRJ000278 Regional Trail Improvements 669,000 74,900 594,100 89% PRJ000293 San Gabriel Park - Phase 3 8,038,870 7,346,566 692,304 9% PRJ000322 Crystal Knoll Park 442,001 162,091 279,910 63% PRJ000323 Madison Oaks Park 50,000 14,500 35,500 71% PRJ000324 Vista Vera Park 250,000 40,700 209,300 84% PRJ000326 Westhaven Park I and II 250,000 79,637 170,363 68% PRJ000327 La Conterra Park 250,000 51,228 198,772 80% PRJ000328 Waypoint Park 200,000 14,500 185,500 93% PRJ000358 Parks Replacement (Previously SRF)1,573,600 431,652 1,141,948 73% PRJ000359 Parks Safety Improvements 1,057,300 10,165 1,047,135 99% PRJ000364 Bark Park Pet Memorial 25,000 24,833 167 1% PRJ000385 Garey Park - Phase II 1,000,000 - 1,000,000 100% PRJ000441 Garey Park Estate 20,000,000 437,500 19,562,500 98% PRJ000516 Summers Green Park Improvements 38,000 38,000 - 0% Parks Total 69,336,357 27,320,771 42,015,586 61% Public Works Department PRJ000063 Northwest Blvd Bridge 421,578 421,578 - 0% PRJ000137 Intersection Improvements (Lakeway @ Williams Drive)1,759,578 1,759,578 - 0% PRJ000138 Downtown Sidewalks 3,679,978 1,655,771 2,024,207 55% PRJ000139 Westinghouse - Scenic Lake Traffic Signal 353,446 343,447 10,000 3% PRJ000140 Austin Ave Bridges 10,184,000 2,251,645 7,932,355 78% PRJ000141 Southwestern Blvd 4,200,000 876,460 3,323,540 79% PRJ000143 Leander Rd(Norwood-Swbypass)3,530,000 1,656,169 1,873,831 53% PRJ000172 2020 Street Maintenance High Performance Seal: Bid Package No.1 372,200 349,542 22,658 6% PRJ000173 2020 Street Maintenance High Performance Seal: Bid Package No. 2 463,195 337,719 125,476 27% PRJ000174 2020 street maintenance HIPR 1,191,547 1,191,547 - 0% PRJ000188 DB Wood (SH 29 to Oak Ridge)28,579,000 2,559,323 26,019,677 91% PRJ000202 FM 971 5,720,199 5,491,011 229,188 4% PRJ000207 Northwest Blvd Bridge 5,527,427 11,582,260 (6,054,833) -110% PRJ000209 Southeast Inner Loop 8,637,989 8,646,507 (8,518) 0% PRJ000210 2021 HIPR Street Maintenance 2,300,000 2,294,871 5,129 0% PRJ000214 Intersection Improvements (Traffic Signals)1,650,000 1,287,778 362,222 22% PRJ000215 2021 Intersection Safety Enhancements (RRFB)475,166 502,166 (27,000) -6% PRJ000216 FY21 Downtown Sidewalk Improvements 1,000,000 130,000 870,000 87% PRJ000254 Shell Road 12,503,000 1,186,435 11,316,565 91% PRJ000255 Rockride Lane 13,776,000 1,347,017 12,428,983 90% PRJ000256 Westinghouse Road 8,200,000 8,200,000 - 0% PRJ000257 Sam Houston Ave Ext/SE1/Wilco Corridor 4,000,000 3,923,605 76,395 2% PRJ000258 DB Wood (Oak Ridge to Williams Dr)31,451,600 2,427,907 29,023,693 92% PRJ000267 Allocations - Intersections/Bike Lanes/Sidewalks - MB21 10,800,000 412,428 10,387,572 96% PRJ000276 2023 HIPR Street Maintenance 4,000,000 578,000 3,422,000 86% PRJ000277 Intersection Improvements - FY22 2,409,550 391,700 2,017,850 84% PRJ000294 2022 HIPR 2,999,466 2,096,274 903,192 30% PRJ000295 2022 High Performance Pavement Seal 1,264,328 1,171,892 92,436 7% PRJ000297 Southeast Inner Loop - MB21 32,777,940 3,050,500 29,727,440 91% PRJ000304 Memorial Drive 3,100,000 721,389 2,378,611 77% PRJ000310 Southwest Bypass (Wolf Ranch Parkway to SH29)2,000,000 2,000,000 - 0% PRJ000332 Williams Drive (MB21)11,361,371 2,370,616 8,990,755 79% PRJ000367 Wolf Ranch Parkway 1,000,000 615,149 384,851 38% PRJ000382 2023 High Performance Pavement Seal 2,508,216 357,100 2,151,116 86% PRJ000383 2023 Unscheduled Pavement Repair 1,000,000 - 1,000,000 100% PRJ000471 SH 29 East 1,305,870 955,223 350,647 27% PRJ000472 FM 971 Widening (Gantt-SH130)980,381 932,374 48,007 5% PRJ000487 Old Town Southeast Sidewalk Improvements 1,000,000 - 1,000,000 100% PRJ000504 SH 29 (SH130 To Patriot Way)305,870 - 305,870 100% Public Works Department Total 228,788,895 76,074,978 152,713,916 67% Stormwater PRJ000004 18th and Hutto Drainage 8,160 8,133 27 0% PRJ000024 2020 Curb & Gutter 720,059 720,059 - 0% PRJ000104 Stormwater Infrastructure 151,602 145,295 6,307 4% PRJ000149 Drainage Improvement/Flood Mitigation Projects 409,418 295,000 114,418 28% PRJ000213 2021 Curb & Gutter Project 817,105 872,905 (55,800) -7% PRJ000274 2022 Curb & Gutter 65,250 65,250 - 0% Stormwater Total 2,171,594 2,106,642 64,952 3% 90 City of Georgetown Capital Projects Life to Date Project Budget Total Spend Remaining Budget Percentage Remaining Water PRJ000014 Berry Creek Inter.72,981,378 3,182,892 69,798,486 96% PRJ000023 Cr 255 (Wd14-2)7,017,359 319,081 6,698,278 95% PRJ000057 Lift Station Upgrade 1,823,593 561,336 1,262,256 69% PRJ000059 LWTP Raw Water Intake Rehab 6,750,000 5,592,819 1,157,181 17% PRJ000096 Shell Road Water Line 6,890,000 1,129,285 5,760,715 84% PRJ000101 Southlake Wtp 278,000,000 198,063,025 79,936,975 29% PRJ000119 Water Mains 643,855 463,473 180,382 28% PRJ000150 Carriage Oaks Transmission 5,450,000 430,800 5,019,200 92% PRJ000152 Hoover Pump Station 18,985,810 6,389,009 12,596,801 66% PRJ000154 Stonewall Ranch Pump Station Improvements 3,350,000 300,825 3,049,175 91% PRJ000155 Southside Water Treatment Plant 6,426,706 6,368,722 57,983 1% PRJ000156 Gatlin/Teravista Improvements 438,854 438,854 - 0% PRJ000157 Leander Interconnect 340,245 316,601 23,644 7% PRJ000160 Round Rock Supply Pump Station And Elevated Storage Tank 21,000,000 8,137,044 12,862,956 61% PRJ000161 Miscellaneous Line Upgrades 1,758,164 710,359 1,047,805 60% PRJ000163 Tank Rehabilitation 4,165,036 431,916 3,733,120 90% PRJ000165 San Gabriel WWTP Rehabilitation 21,157,307 1,674,500 19,482,807 92% PRJ000167 San Gabriel Inter SGI -2 4,375,055 912,755 3,462,300 79% PRJ000168 WWTP Upgrade 680,916 208,142 472,774 69% PRJ000177 Northlake WTP Phase IV Expansion 16,152,534 15,033,372 1,119,162 7% PRJ000185 Cimarron Hills Wastewater Treatment Plant Expansion 12,473,000 799,325 11,673,675 94% PRJ000218 EARZ Wastewater Rehabilitation Area 2 - 2019 2,460,360 2,310,949 149,411 6% PRJ000220 AMI Equipment Upgrades 10,500,000 8,168,419 2,331,581 22% PRJ000228 Southside GST Roof Rehab 791,500 599,500 192,000 24% PRJ000241 2020 - 2021 EARZ - Area 3 462,176 465,180 (3,004) -1% PRJ000259 III Forks WWTP 35,457,141 178,171 35,278,971 99% PRJ000260 CR 262 Waterline 3,000,000 187,200 2,812,800 94% PRJ000261 Dove Springs WWTP Rehabilitation 39,415,563 834,260 38,581,303 98% PRJ000262 Wolf Ranch Expansion and Force Main - - - 0% PRJ000263 Water - Wastewater Master Plan 1,225,000 1,170,384 54,616 4% PRJ000264 Interceptor Lift Station Removal & Gravity Main 8,500,000 - 8,500,000 100% PRJ000266 SCADA Upgrades 1,500,000 - 1,500,000 100% PRJ000268 System Resiliency 30,461,929 2,912,993 27,548,937 90% PRJ000275 FY2022 EARZ -Area 4 - - - 0% PRJ000333 Smith Branch Lift Station Improvements 1,300,000 209,070 1,090,930 84% PRJ000363 EARZ Combined 7,647,528 2,808,790 4,838,738 63% PRJ000370 Northlands Wastewater Treatment Plant 56,000,000 - 56,000,000 100% PRJ000371 Sunny Trail (Teravista/1460) WW Lift Station 2,211,146 - 2,211,146 100% PRJ000372 ASR Well Development 10,000,000 - 10,000,000 100% PRJ000373 Downtown Waterline Upgrades 2,700,000 181,200 2,518,800 93% PRJ000374 Phase III Pump Design Costs and Line Assessments 2,500,000 - 2,500,000 100% PRJ000375 Blue Ridge Waterline 3,400,000 84,700 3,315,300 98% PRJ000376 SH 138 Waterline Upgrade 9,500,000 1,402,746 8,097,254 85% PRJ000377 Southwestern & Southeast Inner Loop Waterline 1,850,000 - 1,850,000 100% PRJ000378 Westside Service Center Building Update 150,000 - 150,000 100% PRJ000379 Woods Pump Station Remodel 480,000 11,579 468,421 98% PRJ000387 IH35 Waterline Connection 2,500,000 160,115 2,339,885 94% PRJ000494 Daniels to Hoover Water Line Improvements 19,064,190 1,564,190 17,500,000 92% PRJ000495 Rabbit Hill GST Rehabilitation 1,000,000 172,920 827,080 83% PRJ000496 Park Lift Station to San Gabriel WWTP Force Main Rehabilitation 2,600,000 353,400 2,246,600 86% PRJ000511 Park WTP Improvements 1,185,000 184,964 1,000,036 84% PRJ000521 Chandler Road Water Line Extension with Round Rock 750,000 - 750,000 100% Water Total 749,471,345 275,424,865 474,046,481 63% Grand Total 1,245,202,047 476,999,139 768,202,908 62% 91