Loading...
HomeMy WebLinkAboutFY 24 - 1st Quarter Report redactedFINANCIAL REPORT AND INVESTMENT REPORT For the Quarter Ended December 31st, 2023 Table of Contents General Fund Narrative .............................................................................................................................. 1-7 General Fund Schedule ................................................................................................................................. 8 General Fund by Cost Center ................................................................................................................... 9-11 Electric Fund Narrative ........................................................................................................................... 12-14 Electric Fund Schedule ................................................................................................................................ 15 Water Services Fund Narrative ............................................................................................................... 16-18 Water Services Fund Schedule .................................................................................................................... 19 Convention & Visitors Bureau Narrative................................................................................................. 20-21 Convention & Visitors Bureau Fund Schedule ............................................................................................. 22 Airport Fund Narrative ........................................................................................................................... 23-24 Airport Fund Schedule ................................................................................................................................. 25 Georgetown Transportation Enhancement Corporation Fund Narrative ............................................... 26-27 Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 28 Georgetown Economic Development Corporation Fund Narrative ....................................................... 29-30 Georgetown Economic Development Corporation Fund Schedule ............................................................. 31 Council Discretionary Fund Schedule .......................................................................................................... 32 Joint Services Fund Schedule ....................................................................................................................... 33 Stormwater Services Narrative ............................................................................................................... 34-35 Stormwater Services Fund Schedule ........................................................................................................... 36 Village PID Services Narrative ...................................................................................................................... 37 Village PID Services Fund Schedule ............................................................................................................. 38 Solid Waste Narrative ............................................................................................................................. 39-40 Solid Waste Fund Schedule ......................................................................................................................... 41 Investment Report ……………………………………………………………………………………………………………………………..42-44 Quarterly Investment Report – City………………………………………………………………………………………………………45-64 Quarterly Investment Report - GEDCO ................................................................................................... 65-70 Quarterly Investment Report – GTEC……………………………………………………………………………………………………..71-76 Grant Applications……………………………………………………………………………………………………………………………………….77 Capital Improvement Projects………………………………………………………………………………………………………………..78-82 Quarterly Financial Report Sales tax revenue accounts for $29,191,511 of General Fund budgeted revenue. Through the quarter, the City collected $2,409,956 of the budgeted sales tax amount. Sales tax revenue began a flat trend in comparison to prior fiscal years. While the overall sales tax amount is slightly over the same quarter of FY2023, the City is no longer seeing large increases from month-to- month. The quarterly return for sales tax 1.78% greater than the same period last year. During the development of the FY2024 budget staff forecasted an 2% increase of prior fiscal year sales tax actuals. The month-to-month comparison of FY2023 and FY2024 sales tax returns indicates a normalization of rapid growth recently experienced in multiple sectors. The change 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 8% of General Fund expenses for the Economic Stability Reserve to protect against any volatility in sales tax revenue. Property tax revenues are the second largest revenue segment in the General Fund and has a budget of $21,820,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 48.82% of budget, or $10,651,606. Year-to-date property tax revenues are 11.08% 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 $1,229,449 in FY2024, or 15.10% of budget. Franchise fee revenue is 15.26% higher than the same quarter of FY2023. While most franchise fees saw increases from the same quarter of FY2023, the major increases are from electric, water, garbage and irrigation franchise fees. Payment in Lieu of Taxes (PILOT) revenue from City-owned utilities is budgeted at $12,250,000. Year-to-date, PILOT revenues total $2,924,429, or 23.87% of budget. PILOT revenue is $243,166, or 9.07%, higher than the same quarter of FY2023. 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 is capped at $6 million, per Council direction. Planning and Development related revenue has continued to slow down in FY2024. While there was a minor increase in the number of residential building permits issued compared to the same period last year, revenue from commercial building permits saw a significant decrease. Planning and Development has a total revenue budget of $7,119,661. Through the quarter, planning and development related revenues total $1,719,132 or 24.15% of budget. Permit fees are down -3.63%, or K 500K 1.0M 1.5M 2.0M 2.5M 3.0M Q1 GENERAL FUND: SALES TAX FY2022 FY2023 FY2024 2 Quarterly Financial Report $(23,022) compared to the same quarter in FY2023. Development related permits year-to-date revenues are down -6.07%, or $(71,673) compared to the same period in FY2023. Staff continues to monitor the amount of residential and commercial building permits. FY2024 development revenue and expenses are also being closely monitored for economic impacts. The following graph shows the number of residential building permits issued during the first quarter for the past three years. Sanitation revenue budget totals $0. A Solid Waste Fund was created as part of the FY2024 Budget. Excess revenues over expenditures were transferred to this fund as part of the CIP Roll Forward amendment in January. The transfer of $271,983 went towards meeting the reserve requirements in the Solid Waste Fund. Fire and EMS total budgeted revenue is $9,202,800. Through the quarter, Fire and EMS fee related revenue totals $1,919,446, or 21% 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,340,005. Through the quarter, parks and recreation related fee revenue totals $749,719, or 22.45% of budget. Parks and Recreation revenue is up 4.15% compared to FY2023. The Parks and Recreation department has seen an increase in revenue compared to FY2023 coupled with fee adjustments to align with the cost recovery model approved by Council, and customer growth. GENERAL FUND EXPENSES: Annual expenses through the quarter total $27,804,877, or 26.73% of budget. This is a decrease of - 1.60% compared to the same period last year. While there were both personnel and operational expense increases, this was offset by environmental expenses now being in the Solid Waste fund. General increases in expenses include staff compensation, and new or enhanced programs. Personnel and Operations Summary: Personnel costs through the quarter total $15,300,817, or 24.71% of personnel budget. Operational costs total $12,366,179, or 30.00%. 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. - 200 400 600 800 1,000 Q1 Residential Building Permits FY2022 FY2023 FY2024 3 Quarterly Financial Report ADMINISTRATIVE SERVICES DIVISION: Administrative Services saw operational and personnel costs totaling $679,768, or 22.33% of budget year-to-date. City Secretary personnel and operational expenditures for the quarter totals $419,341, which represents 25.06% of budget. Year-to-date personnel and operational expenditures for Communications totals $375,323, which represents 24.24% of budget. Non-Departmental includes a budget of $90,000 for transfers out to various funds. As of the first quarter, 0.00% 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 DIVISION: Library year-to-date expenses total $950,302, or 25.88% 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 $2,738,434, or 24.08% of budget. Parks year-to-date through the quarter totals $856,437, or 26.73% of budget. Recreation total expenses are $1,030,828, which is 22.48% of budget. Garey Park year-to-date is $362,661, or 28.01% of budget. Personnel expenses in recreation are heavily seasonal, and a significant portion of part- time and temporary salaries is accounted for in the fourth quarter. COMMUNITY SERVICES DIVISION: Year-to-date personnel and operational expenditures for Community Services are as follows, Emergency Management cost center has a total of $184,705, or 36.86% of budget, through the quarter, Animal Services has reported $306,014, which is 25.48% of their budget, Code Compliance has shown spending of $171,181, or 22.15% of budget. Animal Services continues to have salary savings related to vacancies in their cost center, however this is offset by rising expenses related to Temp/Seasonal/On-Call pay. 5 Quarterly Financial Report 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 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,993,668 in FY2024 with an operating contingency reserve of $379,216, and a capital reserve of $2,614,452. 21 Quarterly Financial Report VILLAGE PID MONTHLY REPORT AS OF DECEMBER 31, 2023 VILLAGE PID REVENUES: Village PID budgeted revenues total $537,947 and are comprised of solely property tax. The City receives the bulk of property tax revenues in December and January. Through the end of the first quarter of FY2024, property tax revenue totals $438,685, or 81.55% of budget. FY2024 Property tax revenue is up 2.14%, or $9,175 compared to FY2023. Collection rates and protested values can affect property tax revenue. Village PID Expenses: Village PID expenses include administrative charges, capital, contractual services, insurance, maintenance, and marketing. Year-to-date operational and capital expenses total $223,963 or 45.60% of budget. The Parks Department has contracted for Parks Capital Improvements which total $6,100 year to date, leaving a remaining budget of $222,920. Ending Fund Balance in FY2024 for Village PID is budgeted at $1,140,169. 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 $988,494. K 150K 300K 450K Q1 PROPERTY TAX REVENUES FY2022 FY2023 FY2024 37 Quarterly Financial Report portfolio decreased during this quarter due to a land purchase at IH35 and Inner Loop. The average yield increased on all portfolios due to increased rates in our pools, newly purchased cd’s, and treasury/agency securities. CITY Market Value GTEC GEDCO 9/30/23 12/31/23 9/30/23 12/31/23 9/30/23 12/31/23 Total cash and investments $832,668,929 $858,846,267 $43,108,356 $37,039,833 $11,189,420 $11,010,850 Quarter End Average Yield 5.22% 5.37% 5.44% 5.48% 5.46% 5.49% 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. 43 Quarterly Financial Report 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. Comprehensive information about active capital projects can be explored digitally in the City’s ClearGov Transparency Center at https://georgetown-tx.cleargov.com and clicking on the Projects tab. 44 Quarterly Financial Report Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield Demand Accounts 82,661$ 82,661 203,202$ 203,202$ 0.00% NOW/MMA 25,959,402 25,959,402 32,068,622 32,068,622 5.39% Pools 275,293,441 275,293,441 298,944,519 298,944,519 5.35% CDs/Securities 531,432,584 531,333,424 527,635,295 527,629,924 5.39% Totals 832,768,089$ 832,668,929$ 858,851,639$ 858,846,267$ 5.37% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 5.37%Total Portfolio 5.37% Rolling Three Month Treasury 5.53%Rolling Three Month Treasury 5.53% Rolling Six Month Treasury 5.49%Rolling Six Month Treasury 5.49% TexPool 5.37%TexPool 5.37% Interest earnings provided in separate report. December 31, 2023September 30, 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. City of Georgetown Valley View Consulting, L.L.C.46 Quarterly Financial Report City - Investment Holdings Coupon/Maturity Settlement Face Amount/Book Market Market Life Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield Wells Fargo Bank Cash 0.00%01/01/24 12/31/23 203,202$ 203,202$ 1.00 203,202$ 1 0.00% Wells Fargo Bank Sweep-MMF 5.22%01/01/24 12/31/23 15,353,226 15,353,226 1.00 15,353,226 1 5.22% Veritex Community Bank MMA 5.33%01/01/24 12/31/23 3,435,932 3,435,932 1.00 3,435,932 1 5.33% NexBank MMA 5.60%01/01/24 12/31/23 13,279,464 13,279,464 1.00 13,279,464 1 5.60% TexPool AAAm 5.37%01/01/24 12/31/23 69,467,382 69,467,382 1.00 69,467,382 1 5.37% TexSTAR AAAm 5.34%01/01/24 12/31/23 229,477,137 229,477,137 1.00 229,477,137 1 5.34% Bank OZK CD 4.93%01/02/24 03/30/23 26,983,831 26,983,831 100.00 26,983,831 2 5.05% Alliance Bank CD 5.15%01/12/24 01/13/23 5,195,079 5,195,079 100.00 5,195,079 12 5.25% East West Bank CD 4.99%01/12/24 04/12/23 10,367,487 10,367,487 100.00 10,367,487 12 5.12% East West Bank CD 5.73%01/17/24 07/17/23 20,534,449 20,534,449 100.00 20,534,449 17 5.90% East West Bank CD 4.71%01/18/24 01/18/23 10,459,268 10,459,268 100.00 10,459,268 18 4.82% Veritex Community Bank CD 4.84%01/23/24 01/23/23 10,451,917 10,451,917 100.00 10,451,917 23 4.95% East West Bank CD 5.09%01/26/24 04/26/23 4,141,901 4,141,901 100.00 4,141,901 26 5.22% East West Bank CD 5.74%02/01/24 08/01/23 2,118,414 2,118,414 100.00 2,118,414 32 5.91% Southside Bank CD 3.32%02/02/24 08/02/22 10,422,651 10,422,651 100.00 10,422,651 33 3.32% East West Bank CD 5.74%02/02/24 08/02/23 5,120,948 5,120,948 100.00 5,120,948 33 5.91% East West Bank CD 5.76%02/15/24 08/15/23 4,263,622 4,263,622 100.00 4,263,622 46 5.93% Independent Financial CD 5.15%02/15/24 05/15/23 12,360,109 12,360,109 100.00 12,360,109 46 5.27% FHLB Aaa/AA+5.35%02/28/24 03/06/23 20,000,000 20,000,000 99.96 19,992,380 59 5.35% East West Bank CD 5.24%03/11/24 03/09/23 10,437,065 10,437,065 100.00 10,437,065 71 5.38% East West Bank CD 5.72%03/11/24 09/11/23 4,070,821 4,070,821 100.00 4,070,821 71 5.89% East West Bank CD 5.73%03/18/24 09/18/23 13,216,045 13,216,045 100.00 13,216,045 78 5.90% BOK Financial CD 4.88%03/23/24 02/22/23 8,309,541 8,309,541 100.00 8,309,541 83 5.00% Third Coast Bank CD 5.65%03/28/24 06/28/23 8,228,224 8,228,224 100.00 8,228,224 88 5.77% East West Bank CD 5.78%04/16/24 10/16/23 7,085,870 7,085,870 100.00 7,085,870 107 5.95% East West Bank CD 5.62%04/17/24 07/17/23 5,131,014 5,131,014 100.00 5,131,014 108 5.78% Bank OZK CD 4.92%04/18/24 04/18/23 10,334,343 10,334,343 100.00 10,334,343 109 5.04% East West Bank CD 4.92%04/26/24 04/26/23 10,342,705 10,342,705 100.00 10,342,705 117 5.04% East West Bank CD 5.63%05/02/24 08/02/23 20,474,413 20,474,413 100.00 20,474,413 123 5.79% Independent Financial CD 4.99%05/09/24 02/09/23 8,294,460 8,294,460 100.00 8,294,460 130 5.08% T-Note Aaa/AA+0.25%05/15/24 11/22/22 2,000,000 1,968,148 98.20 1,964,063 136 4.72% East West Bank CD 5.64%05/15/24 08/15/23 5,307,996 5,307,996 100.00 5,307,996 136 5.80% Bank OZK CD 5.50%05/16/24 11/16/23 5,022,652 5,022,652 100.00 5,022,652 137 5.65% BOK Financial CD 5.10%05/16/24 05/18/23 8,000,000 8,000,000 100.00 8,000,000 137 5.23% East West Bank CD 5.66%06/11/24 09/11/23 5,087,590 5,087,590 100.00 5,087,590 163 5.82% Alliance Bank CD 5.10%06/14/24 12/15/22 10,519,837 10,519,837 100.00 10,519,837 166 5.20% December 31, 2023 City of Georgetown Valley View Consulting, L.L.C.48 Quarterly Financial Report City - Investment Holdings Coupon/Maturity Settlement Face Amount/Book Market Market Life Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield December 31, 2023 East West Bank CD 5.32%06/17/24 06/16/23 15,910,063 15,910,063 100.00 15,910,063 169 5.46% Alliance Bank CD 5.10%06/27/24 12/27/22 13,781,605 13,781,605 100.00 13,781,605 179 5.20% Veritex Community Bank CD 5.45%07/15/24 07/14/23 10,230,549 10,230,549 100.00 10,230,549 197 5.59% East West Bank CD 5.68%07/16/24 10/16/23 7,084,375 7,084,375 100.00 7,084,375 198 5.68% East West Bank CD 5.50%07/17/24 07/17/23 5,128,181 5,128,181 100.00 5,128,181 199 5.65% East West Bank CD 5.72%07/22/24 10/20/23 20,230,150 20,230,150 100.00 20,230,150 204 5.89% Independent Financial CD 4.50%07/24/24 01/23/23 10,339,105 10,339,105 100.00 10,339,105 206 4.58% FHLB Aaa/AA+5.18%07/26/24 02/28/23 10,000,000 10,000,000 100.04 10,003,728 208 5.18% Alliance Bank CD 5.80%08/02/24 08/01/23 5,072,301 5,072,301 100.00 5,072,301 215 5.93% Veritex Community Bank CD 5.53%08/05/24 08/23/23 5,093,062 5,093,062 100.00 5,093,062 218 5.67% East West Bank CD 5.52%08/19/24 08/17/23 5,104,667 5,104,667 100.00 5,104,667 232 5.67% FFCB Aaa/AA+4.88%08/21/24 02/27/23 4,000,000 3,992,236 99.88 3,995,055 234 5.19% Alliance Bank CD 5.70%09/06/24 09/07/23 10,134,301 10,134,301 100.00 10,134,301 250 5.82% Veritex Community Bank CD 5.56%09/11/24 09/13/23 10,139,261 10,139,261 100.00 10,139,261 255 5.70% Veritex Community Bank CD 5.56%09/25/24 09/25/23 10,190,148 10,190,148 100.00 10,190,148 269 5.70% Alliance Bank CD 5.85%10/10/24 10/10/23 7,500,000 7,500,000 100.00 7,500,000 284 5.98% Veritex Community Bank CD 5.54%10/16/24 10/16/23 2,523,200 2,523,200 100.00 2,523,200 290 5.68% Alliance Bank CD 5.75%11/01/24 08/01/23 5,071,678 5,071,678 100.00 5,071,678 306 5.88% Bank OZK CD 5.50%11/13/24 11/13/23 10,106,035 10,106,035 100.00 10,106,035 318 5.65% Veritex Community Bank CD 5.15%12/11/24 12/11/23 20,000,000 20,000,000 100.00 20,000,000 346 5.27% Alliance Bank CD 5.10%12/13/24 12/15/22 10,519,837 10,519,837 100.00 10,519,837 348 5.20% T-Note Aaa/AA+1.00%12/15/24 06/14/23 5,000,000 4,821,893 96.43 4,821,680 350 4.91% East West Bank CD 5.04%12/16/24 12/15/23 10,023,500 10,023,500 100.00 10,023,500 351 5.17% BOK Financial CD 5.07%12/19/24 12/21/23 10,015,289 10,015,289 100.00 10,015,289 354 5.20% Alliance Bank CD 5.70%02/24/25 08/23/23 5,071,055 5,071,055 100.00 5,071,055 421 5.82% Bank OZK CD 5.37%04/20/25 10/20/23 5,045,071 5,045,071 100.00 5,045,071 476 5.20% Third Coast Bank CD 5.10%06/28/25 06/28/23 10,257,333 10,257,333 100.00 10,257,333 545 5.20% TOTALS 859,069,362$ 858,851,639$ 858,846,267$ 102 5.37% (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.49 Quarterly Financial Report City - Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 09/30/23 Increases Decreases Book Value 12/31/23 Market Value 09/30/23 Change in Market Value Market Value 12/31/23 JPMorgan Chase Cash 0.00%01/01/24 -$ –$ –$ –$ -$ –$ –$ JPMorgan Chase MMA 0.00%01/01/24 440,091 – (440,091) – 440,091 (440,091) - Wells Fargo Bank Cash 0.00%01/01/24 82,661 120,541 – 203,202 82,661 120,541 203,202 Wells Fargo Bank Sweep-MMF 5.22%01/01/24 9,035,571 6,317,655 – 15,353,226 9,035,571 6,317,655 15,353,226 Veritex Community Bank MMA 5.33%01/01/24 3,390,187 45,745 – 3,435,932 3,390,187 45,745 3,435,932 NexBank MMA 5.60%01/01/24 13,093,553 185,911 – 13,279,464 13,093,553 185,911 13,279,464 TexPool 5.37%01/01/24 31,175,398 38,291,983 – 69,467,382 31,175,398 38,291,983 69,467,382 TexSTAR 5.34%01/01/24 244,118,043 – (14,640,906) 229,477,137 244,118,043 (14,640,906) 229,477,137 Bank OZK CD 5.05%09/30/23 25,629,056 – (25,629,056) – 25,629,056 (25,629,056) – Bank OZK CD 0.20%10/09/23 5,019,310 – (5,019,310) – 5,019,310 (5,019,310) – East West Bank CD 5.32%10/12/23 13,958,905 – (13,958,905) – 13,958,905 (13,958,905) – FHLB 4.56%10/13/23 2,496,064 – (2,496,064) – 2,496,087 (2,496,087) – East West Bank CD 4.87%10/18/23 10,339,465 – (10,339,465) – 10,339,465 (10,339,465) – East West Bank CD 4.63%10/19/23 2,610,010 – (2,610,010) – 2,610,010 (2,610,010) – FHLB 5.17%10/24/23 9,967,067 – (9,967,067) – 9,968,722 (9,968,722) – Bank OZK CD 0.30%11/13/23 10,055,315 – (10,055,315) – 10,055,315 (10,055,315) – East West Bank CD 5.47%11/13/23 3,146,685 – (3,146,685) – 3,146,685 (3,146,685) – East West Bank CD 5.47%11/15/23 5,218,172 – (5,218,172) – 5,218,172 (5,218,172) – FAMCA 4.75%11/22/23 2,000,000 – (2,000,000) – 1,997,296 (1,997,296) – East West Bank CD 5.43%12/11/23 9,272,734 – (9,272,734) – 9,272,734 (9,272,734) – FAMCA 4.95%12/13/23 10,000,000 – (10,000,000) – 9,985,183 (9,985,183) – East West Bank CD 5.75%12/20/23 2,617,868 – (2,617,868) – 2,617,868 (2,617,868) – Alliance Bank CD 5.20%12/27/23 1,038,776 – (1,038,776) – 1,038,776 (1,038,776) – Bank OZK CD 5.05%01/02/24 26,654,219 329,612 – 26,983,831 26,654,219 329,612 26,983,831 Alliance Bank CD 5.25%01/12/24 5,128,507 66,572 – 5,195,079 5,128,507 66,572 5,195,079 East West Bank CD 5.12%01/12/24 10,237,915 129,572 – 10,367,487 10,237,915 129,572 10,367,487 East West Bank CD 5.90%01/17/24 20,240,029 294,419 – 20,534,449 20,240,029 294,419 20,534,449 East West Bank CD 4.82%01/18/24 10,335,840 123,428 – 10,459,268 10,335,840 123,428 10,459,268 Veritex Community Bank CD 4.95%01/23/24 10,326,803 125,114 – 10,451,917 10,326,803 125,114 10,451,917 East West Bank CD 5.22%01/26/24 4,089,106 52,796 – 4,141,901 4,089,106 52,796 4,141,901 East West Bank CD 5.91%02/01/24 2,087,988 30,426 – 2,118,414 2,087,988 30,426 2,118,414 Southside Bank CD 3.32%02/02/24 10,336,156 86,495 – 10,422,651 10,336,156 86,495 10,422,651 East West Bank CD 5.91%02/02/24 5,047,398 73,550 – 5,120,948 5,047,398 73,550 5,120,948 East West Bank CD 5.93%02/15/24 4,202,173 61,449 – 4,263,622 4,202,173 61,449 4,263,622 Independent Financial CD 5.27%02/15/24 12,204,472 155,637 – 12,360,109 12,204,472 155,637 12,360,109 FHLB 5.35%02/28/24 20,000,000 – – 20,000,000 19,997,680 (5,300) 19,992,380 East West Bank CD 5.38%03/11/24 10,300,131 136,933 – 10,437,065 10,300,131 136,933 10,437,065 East West Bank CD 5.89%03/11/24 4,012,556 58,266 – 4,070,821 4,012,556 58,266 4,070,821 East West Bank CD 5.90%03/18/24 13,026,556 189,489 – 13,216,045 13,026,556 189,489 13,216,045 BOK Financial CD 5.00%03/23/24 8,207,978 101,563 – 8,309,541 8,207,978 101,563 8,309,541 Third Coast Bank CD 5.77%03/28/24 8,113,929 114,295 – 8,228,224 8,113,929 114,295 8,228,224 City of Georgetown Valley View Consulting, L.L.C.51 Quarterly Financial Report City - Allocation Investment Total Consolidated Debt Service 2015 CO- Parks/Streets / Vehicles 2015 GO- Roads 2015 Revenue Water WW Garey Park Donation 2017 Revenue Water WW 2018 CO- Streets/ Facilities/ Equip 2018 GO- Roads 2019 CO- Streets/ Facilities/ Equip 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 GO- Roads Electric-LCRA Transformers City - 2021 CO Airport Wells Fargo Bank Cash 203,202$ 203,202$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ Wells Fargo Bank Sweep-MMF 15,353,226 15,353,226 – – – – – – – – – – – – – – Veritex Community Bank MMA 3,435,932 3,435,932 – – – – – – – – – – – – – – NexBank MMA 13,279,464 13,279,464 – – – – – – – – – – – – – – TexPool 69,467,382 69,467,382 – – – – – – – – – – – – – – TexSTAR 229,477,137 25,133,154 8,362,073 1,366 1,162,369 181,319 1,129,784 11,120,523 225,069 484,019 598,211 1,855,012 531,824 2,913,021 3,804,420 740,610 Bank OZK CD 01/02/24 26,983,831 – – – – – – – – – – – – – – – Alliance Bank CD 01/12/24 5,195,079 5,195,079 – – – – – – – – – – – – – – East West Bank CD 01/12/24 10,367,487 – – – – – – – – – – – – – – – East West Bank CD 01/17/24 20,534,449 – – – – – – – – – – – – – – – East West Bank CD 01/18/24 10,459,268 – – – – – – – – – – – – – – – Veritex Community Bank CD 01/23/24 10,451,917 10,451,917 – – – – – – – – – – – – – – East West Bank CD 01/26/24 4,141,901 – – – – – – – – – – – – – – – East West Bank CD 02/01/24 2,118,414 – – – – – – – – – – – – 2,118,414 – – Southside Bank CD 02/02/24 10,422,651 – – – – – – – – – – – – – – – East West Bank CD 02/02/24 5,120,948 – – – – – – – – – – – – – – – East West Bank CD 02/15/24 4,263,622 – – – – – – – – – – – – – – – Independent Financial CD 02/15/24 12,360,109 – – – – – – – – – – – – – – – FHLB 02/28/24 20,000,000 20,000,000 – – – – – – – – – – – – – – East West Bank CD 03/11/24 10,437,065 – – – – – – – – – – – – – – – East West Bank CD 03/11/24 4,070,821 – – – – – – – – – – – – – – – East West Bank CD 03/18/24 13,216,045 – – – – – – – – – – – – – – – BOK Financial CD 03/23/24 8,309,541 8,309,541 – – – – – – – – – – – – – – Third Coast Bank CD 03/28/24 8,228,224 – – – – – – – – – – – – – – – East West Bank CD 04/16/24 7,085,870 – – – – – – – – – – – – – – – East West Bank CD 04/17/24 5,131,014 – – – – – – – – – – – – – – – Bank OZK CD 04/18/24 10,334,343 – – – – – – – – – – – – – – – East West Bank CD 04/26/24 10,342,705 10,342,705 – – – – – – – – – – – – – – East West Bank CD 05/02/24 20,474,413 – – – – – – – – – – – – – – – Independent Financial CD 05/09/24 8,294,460 8,294,460 – – – – – – – – – – – – – – T-Note 05/15/24 1,968,148 1,968,148 – – – – – – – – – – – – – – East West Bank CD 05/15/24 5,307,996 – – – – – – – – – – – – – – – Bank OZK CD 05/16/24 5,022,652 – – – – – – – – – – – – – – – BOK Financial CD 05/16/24 8,000,000 – – – – – – – – – – – – – – – East West Bank CD 06/11/24 5,087,590 – – – – – – – – – – – – – – – Alliance Bank CD 06/14/24 10,519,837 – – – – – – – – – – – – – – – East West Bank CD 06/17/24 15,910,063 15,910,063 – – – – – – – – – – – – – – Alliance Bank CD 06/27/24 13,781,605 13,781,605 – – – – – – – – – – – – – – Veritex Community Bank CD 07/15/24 10,230,549 10,230,549 – – – – – – – – – – – – – – East West Bank CD 07/16/24 7,084,375 – – – – – – – – – – – – – – – East West Bank CD 07/17/24 5,128,181 – – – – – – – – – – – – – – – East West Bank CD 07/22/24 20,230,150 – – – – – – – – – – – – – – – Independent Financial CD 07/24/24 10,339,105 – – – – – – – – – – – – – – – FHLB 07/26/24 10,000,000 – – – – – – – – – – – – – – – Alliance Bank CD 08/02/24 5,072,301 5,072,301 – – – – – – – – – – – – – – Veritex Community Bank CD 08/05/24 5,093,062 – – – – – – – – – – – – – – – East West Bank CD 08/19/24 5,104,667 5,104,667 – – – – – – – – – – – – – – FFCB 08/21/24 3,992,236 3,992,236 – – – – – – – – – – – – – – Alliance Bank CD 09/06/24 10,134,301 – – – – – – – – – – – – – – – Veritex Community Bank CD 09/11/24 10,139,261 – – – – – – – – – – – – – – – Veritex Community Bank CD 09/25/24 10,190,148 10,190,148 – – – – – – – – – – – – – – Alliance Bank CD 10/10/24 7,500,000 7,500,000 – – – – – – – – – – – – – – Veritex Community Bank CD 10/16/24 2,523,200 2,523,200 – – – – – – – – – – – – – – Alliance Bank CD 11/01/24 5,071,678 5,071,678 – – – – – – – – – – – – – – Bank OZK CD 11/13/24 10,106,035 10,106,035 – – – – – – – – – – – – – – Veritex Community Bank CD 12/11/24 20,000,000 20,000,000 – – – – – – – – – – – – – – Alliance Bank CD 12/13/24 10,519,837 – – – – – – – – – – – – – – – T-Note 12/15/24 4,821,893 4,821,893 – – – – – – – – – – – – – – East West Bank CD 12/16/24 10,023,500 10,023,500 – – – – – – – – – – – – – – BOK Financial CD 12/19/24 10,015,289 10,015,289 – – – – – – – – – – – – – – Alliance Bank CD 02/24/25 5,071,055 5,071,055 – – – – – – – – – – – – – – Bank OZK CD 04/20/25 5,045,071 5,045,071 – – – – – – – – – – – – – – Third Coast Bank CD 06/28/25 10,257,333 10,257,333 – – – – – – – – – – – – – – Totals 858,851,639$ 346,150,833$ 8,362,073$ 1,366$ 1,162,369$ 181,319$ 1,129,784$ 11,120,523$ 225,069$ 484,019$ 598,211$ 1,855,012$ 531,824$ 5,031,436$ 3,804,420$ 740,610$ Book Value December 31, 2023 City of Georgetown Valley View Consulting, L.L.C. 53 Quarterly Financial Report City - Allocation Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR Bank OZK CD 01/02/24 Alliance Bank CD 01/12/24 East West Bank CD 01/12/24 East West Bank CD 01/17/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 East West Bank CD 01/26/24 East West Bank CD 02/01/24 Southside Bank CD 02/02/24 East West Bank CD 02/02/24 East West Bank CD 02/15/24 Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 East West Bank CD 03/11/24 East West Bank CD 03/18/24 BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 East West Bank CD 04/16/24 East West Bank CD 04/17/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24 East West Bank CD 05/02/24 Independent Financial CD 05/09/24 T-Note 05/15/24 East West Bank CD 05/15/24 Bank OZK CD 05/16/24 BOK Financial CD 05/16/24 East West Bank CD 06/11/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Veritex Community Bank CD 07/15/24 East West Bank CD 07/16/24 East West Bank CD 07/17/24 East West Bank CD 07/22/24 Independent Financial CD 07/24/24 FHLB 07/26/24 Alliance Bank CD 08/02/24 Veritex Community Bank CD 08/05/24 East West Bank CD 08/19/24 FFCB 08/21/24 Alliance Bank CD 09/06/24 Veritex Community Bank CD 09/11/24 Veritex Community Bank CD 09/25/24 Alliance Bank CD 10/10/24 Veritex Community Bank CD 10/16/24 Alliance Bank CD 11/01/24 Bank OZK CD 11/13/24 Veritex Community Bank CD 12/11/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 East West Bank CD 12/16/24 BOK Financial CD 12/19/24 Alliance Bank CD 02/24/25 Bank OZK CD 04/20/25 Third Coast Bank CD 06/28/25 Totals Book Value December 31, 2023 (Continued) 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 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 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 9,357 5,502 2,875,091 205,165 6,200,475 6,741,716 533,283 2,630,879 179,700 139,131 9,182,667 1,742,725 31,114,003 9,199,697 33,450 – – – – – – – – – – – – 26,983,831 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,367,487 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,459,268 – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,141,901 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,422,651 – – – – – – – – – – – – – – – 5,120,948 – 4,263,622 – – – – – – – – – – – – – – – – – – – – – – – – – – 12,360,109 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,437,065 – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,216,045 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 7,085,870 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,334,343 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,307,996 – – – – – – – – – – – – – – 5,022,652 – – – – – – – – – – – – – – – – – – – – – 8,000,000 – – – – – – – – – – – – – – – 5,087,590 – – – – – – – – – – – – – 10,519,837 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 7,084,375 – – – – – – – – – – – – – – – – – 5,128,181 – – – – – – – – – – – – – 20,230,150 – – – – – – – – – – – – – – 10,339,105 – – – – – – – – – – – – – – 10,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,519,837 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,272,979$ 5,502$ 2,875,091$ 205,165$ 6,200,475$ 17,072,364$ 533,283$ 2,630,879$ 179,700$ 139,131$ 40,710,859$ 1,742,725$ 192,087,686$ 24,536,416$ 33,450$ City of Georgetown Valley View Consulting, L.L.C. 54 Quarterly Financial Report City - Allocation Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR Bank OZK CD 01/02/24 Alliance Bank CD 01/12/24 East West Bank CD 01/12/24 East West Bank CD 01/17/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 East West Bank CD 01/26/24 East West Bank CD 02/01/24 Southside Bank CD 02/02/24 East West Bank CD 02/02/24 East West Bank CD 02/15/24 Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 East West Bank CD 03/11/24 East West Bank CD 03/18/24 BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 East West Bank CD 04/16/24 East West Bank CD 04/17/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24 East West Bank CD 05/02/24 Independent Financial CD 05/09/24 T-Note 05/15/24 East West Bank CD 05/15/24 Bank OZK CD 05/16/24 BOK Financial CD 05/16/24 East West Bank CD 06/11/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Veritex Community Bank CD 07/15/24 East West Bank CD 07/16/24 East West Bank CD 07/17/24 East West Bank CD 07/22/24 Independent Financial CD 07/24/24 FHLB 07/26/24 Alliance Bank CD 08/02/24 Veritex Community Bank CD 08/05/24 East West Bank CD 08/19/24 FFCB 08/21/24 Alliance Bank CD 09/06/24 Veritex Community Bank CD 09/11/24 Veritex Community Bank CD 09/25/24 Alliance Bank CD 10/10/24 Veritex Community Bank CD 10/16/24 Alliance Bank CD 11/01/24 Bank OZK CD 11/13/24 Veritex Community Bank CD 12/11/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 East West Bank CD 12/16/24 BOK Financial CD 12/19/24 Alliance Bank CD 02/24/25 Bank OZK CD 04/20/25 Third Coast Bank CD 06/28/25 Totals Book Value December 31, 2023 (Continued) City - 2023 GO Parks City - 2023 GO Roads City - 2023 Revenue Electric City - 2023 Revenue Water/WW City - American Rescue Plan City - Impact Fees - Water City - Impact Fees - WW City - Limited Tax Note, Series 2022 –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,888,966 15,689,940 6,974,810 29,160,783 8,372,380 22,930,337 9,082,044 3,342,261 – – – – – – – – – – – – – – – – – – – – – – – – – – – 20,534,449 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,070,821 – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,228,224 – – – – – – – –– – 5,131,014 – – – – – – – – – – – – – – – – – – – – – – – – – 20,474,413 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,093,062 – – – – – – – –– – – – – – – –– – – – – – – –– 10,134,301 – – – – – –– 10,139,261 – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – 4,888,966$ 25,914,016$ 11,045,632$ 90,443,206$ 8,372,380$ 22,930,337$ 17,310,268$ 3,342,261$ City of Georgetown Valley View Consulting, L.L.C. 55 Quarterly Financial Report City - Allocation Market Value Investment Total Consolidated Debt Service 2015 CO- Parks/Street s/ Vehicles 2015 GO- Roads 2015 Revenue Water WW Garey Park Donation 2017 Revenue Water WW 2018 CO- Streets/ Facilities/ Equip 2018 GO- Roads 2019 CO- Streets/ Facilities/ Equip 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 GO- Roads Electric-LCRA Transformers City - 2021 CO Airport Wells Fargo Bank Cash 203,202$ 203,202$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ Wells Fargo Bank Sweep-MMF 15,353,226 15,353,226 – – – – – – – – – – – – – – Veritex Community Bank MMA 3,435,932 3,435,932 – – – – – – – – – – – – – – NexBank MMA 13,279,464 13,279,464 – – – – – – – – – – – – – – TexPool 69,467,382 69,467,382 – – – – – – – – – – – – – – TexSTAR 229,477,137 25,133,154 8,362,073 1,366 1,162,369 181,319 1,129,784 11,120,523 225,069 484,019 598,211 1,855,012 531,824 2,913,021 3,804,420 740,610 Bank OZK CD 01/02/24 26,983,831 – – – – – – – – – – – – – – – Alliance Bank CD 01/12/24 5,195,079 5,195,079 – – – – – – – – – – – – – – East West Bank CD 01/12/24 10,367,487 – – – – – – – – – – – – – – – East West Bank CD 01/17/24 20,534,449 – – – – – – – – – – – – – – – East West Bank CD 01/18/24 10,459,268 – – – – – – – – – – – – – – – Veritex Community Bank CD 01/23/24 10,451,917 10,451,917 – – – – – – – – – – – – – – East West Bank CD 01/26/24 4,141,901 – – – – – – – – – – – – – – – East West Bank CD 02/01/24 2,118,414 – – – – – – – – – – – – 2,118,414 – – Southside Bank CD 02/02/24 10,422,651 – – – – – – – – – – – – – – – East West Bank CD 02/02/24 5,120,948 – – – – – – – – – – – – – – – East West Bank CD 02/15/24 4,263,622 – – – – – – – – – – – – – – – Independent Financial CD 02/15/24 12,360,109 – – – – – – – – – – – – – – – FHLB 02/28/24 19,992,380 19,992,380 – – – – – – – – – – – – – – East West Bank CD 03/11/24 10,437,065 – – – – – – – – – – – – – – – East West Bank CD 03/11/24 4,070,821 – – – – – – – – – – – – – – – East West Bank CD 03/18/24 13,216,045 – – – – – – – – – – – – – – – BOK Financial CD 03/23/24 8,309,541 8,309,541 – – – – – – – – – – – – – – Third Coast Bank CD 03/28/24 8,228,224 – – – – – – – – – – – – – – – East West Bank CD 04/16/24 7,085,870 – – – – – – – – – – – – – – – East West Bank CD 04/17/24 5,131,014 – – – – – – – – – – – – – – – Bank OZK CD 04/18/24 10,334,343 – – – – – – – – – – – – – – – East West Bank CD 04/26/24 10,342,705 10,342,705 – – – – – – – – – – – – – – East West Bank CD 05/02/24 20,474,413 – – – – – – – – – – – – – – – Independent Financial CD 05/09/24 8,294,460 8,294,460 – – – – – – – – – – – – – – T-Note 05/15/24 1,964,063 1,964,063 – – – – – – – – – – – – – – East West Bank CD 05/15/24 5,307,996 – – – – – – – – – – – – – – – Bank OZK CD 05/16/24 5,022,652 – – – – – – – – – – – – – – – BOK Financial CD 05/16/24 8,000,000 – – – – – – – – – – – – – – – East West Bank CD 06/11/24 5,087,590 – – – – – – – – – – – – – – – Alliance Bank CD 06/14/24 10,519,837 – – – – – – – – – – – – – – – East West Bank CD 06/17/24 15,910,063 15,910,063 – – – – – – – – – – – – – – Alliance Bank CD 06/27/24 13,781,605 13,781,605 – – – – – – – – – – – – – – Veritex Community Bank CD 07/15/24 10,230,549 10,230,549 – – – – – – – – – – – – – – East West Bank CD 07/16/24 7,084,375 – – – – – – – – – – – – – – – East West Bank CD 07/17/24 5,128,181 – – – – – – – – – – – – – – – East West Bank CD 07/22/24 20,230,150 – – – – – – – – – – – – – – – Independent Financial CD 07/24/24 10,339,105 – – – – – – – – – – – – – – – FHLB 07/26/24 10,003,728 – – – – – – – – – – – – – – – Alliance Bank CD 08/02/24 5,072,301 5,072,301 – – – – – – – – – – – – – – Veritex Community Bank CD 08/05/24 5,093,062 – – – – – – – – – – – – – – – East West Bank CD 08/19/24 5,104,667 5,104,667 – – – – – – – – – – – – – – FFCB 08/21/24 3,995,055 3,995,055 – – – – – – – – – – – – – – Alliance Bank CD 09/06/24 10,134,301 – – – – – – – – – – – – – – – Veritex Community Bank CD 09/11/24 10,139,261 – – – – – – – – – – – – – – – Veritex Community Bank CD 09/25/24 10,190,148 10,190,148 – – – – – – – – – – – – – – Alliance Bank CD 10/10/24 7,500,000 7,500,000 – – – – – – – – – – – – – – Veritex Community Bank CD 10/16/24 2,523,200 2,523,200 – – – – – – – – – – – – – – Alliance Bank CD 11/01/24 5,071,678 5,071,678 – – – – – – – – – – – – – – Bank OZK CD 11/13/24 10,106,035 10,106,035 – – – – – – – – – – – – – – Veritex Community Bank CD 12/11/24 20,000,000 20,000,000 – – – – – – – – – – – – – – Alliance Bank CD 12/13/24 10,519,837 – – – – – – – – – – – – – – – T-Note 12/15/24 4,821,680 4,821,680 – – – – – – – – – – – – – – East West Bank CD 12/16/24 10,023,500 10,023,500 – – – – – – – – – – – – – – BOK Financial CD 12/19/24 10,015,289 10,015,289 – – – – – – – – – – – – – – Alliance Bank CD 02/24/25 5,071,055 5,071,055 – – – – – – – – – – – – – – Bank OZK CD 04/20/25 5,045,071 5,045,071 – – – – – – – – – – – – – – Third Coast Bank CD 06/28/25 10,257,333 10,257,333 – – – – – – – – – – – – – – Totals 858,846,267$ 346,141,734$ 8,362,073$ 1,366$ 1,162,369$ 181,319$ 1,129,784$ 11,120,523$ 225,069$ 484,019$ 598,211$ 1,855,012$ 531,824$ 5,031,436$ 3,804,420$ 740,610$ December 31, 2023 City of Georgetown Valley View Consulting, L.L.C. 56 Quarterly Financial Report City - Allocation Market Value Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR Bank OZK CD 01/02/24 Alliance Bank CD 01/12/24 East West Bank CD 01/12/24 East West Bank CD 01/17/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 East West Bank CD 01/26/24 East West Bank CD 02/01/24 Southside Bank CD 02/02/24 East West Bank CD 02/02/24 East West Bank CD 02/15/24 Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 East West Bank CD 03/11/24 East West Bank CD 03/18/24 BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 East West Bank CD 04/16/24 East West Bank CD 04/17/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24 East West Bank CD 05/02/24 Independent Financial CD 05/09/24 T-Note 05/15/24 East West Bank CD 05/15/24 Bank OZK CD 05/16/24 BOK Financial CD 05/16/24 East West Bank CD 06/11/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Veritex Community Bank CD 07/15/24 East West Bank CD 07/16/24 East West Bank CD 07/17/24 East West Bank CD 07/22/24 Independent Financial CD 07/24/24 FHLB 07/26/24 Alliance Bank CD 08/02/24 Veritex Community Bank CD 08/05/24 East West Bank CD 08/19/24 FFCB 08/21/24 Alliance Bank CD 09/06/24 Veritex Community Bank CD 09/11/24 Veritex Community Bank CD 09/25/24 Alliance Bank CD 10/10/24 Veritex Community Bank CD 10/16/24 Alliance Bank CD 11/01/24 Bank OZK CD 11/13/24 Veritex Community Bank CD 12/11/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 East West Bank CD 12/16/24 BOK Financial CD 12/19/24 Alliance Bank CD 02/24/25 Bank OZK CD 04/20/25 Third Coast Bank CD 06/28/25 Totals December 31, 2023 (Continued) 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 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 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 9,357 5,502 2,875,091 205,165 6,200,475 6,741,716 533,283 2,630,879 179,700 139,131 9,182,667 1,742,725 31,114,003 9,199,697 33,450 – – – – – – – – – – – – 26,983,831 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,367,487 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,459,268 – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,141,901 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,422,651 – – – – – – – – – – – – – – – 5,120,948 – 4,263,622 – – – – – – – – – – – – – – – – – – – – – – – – – – 12,360,109 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,437,065 – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,216,045 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 7,085,870 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,334,343 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,307,996 – – – – – – – – – – – – – – 5,022,652 – – – – – – – – – – – – – – – – – – – – – 8,000,000 – – – – – – – – – – – – – – – 5,087,590 – – – – – – – – – – – – – 10,519,837 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 7,084,375 – – – – – – – – – – – – – – – – – 5,128,181 – – – – – – – – – – – – – 20,230,150 – – – – – – – – – – – – – – 10,339,105 – – – – – – – – – – – – – – 10,003,728 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,519,837 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,272,979$ 5,502$ 2,875,091$ 205,165$ 6,200,475$ 17,072,364$ 533,283$ 2,630,879$ 179,700$ 139,131$ 40,710,859$ 1,742,725$ 192,091,414$ 24,536,416$ 33,450$ City of Georgetown Valley View Consulting, L.L.C. 57 Quarterly Financial Report City - Allocation Market Value Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR Bank OZK CD 01/02/24 Alliance Bank CD 01/12/24 East West Bank CD 01/12/24 East West Bank CD 01/17/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 East West Bank CD 01/26/24 East West Bank CD 02/01/24 Southside Bank CD 02/02/24 East West Bank CD 02/02/24 East West Bank CD 02/15/24 Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 East West Bank CD 03/11/24 East West Bank CD 03/18/24 BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 East West Bank CD 04/16/24 East West Bank CD 04/17/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24 East West Bank CD 05/02/24 Independent Financial CD 05/09/24 T-Note 05/15/24 East West Bank CD 05/15/24 Bank OZK CD 05/16/24 BOK Financial CD 05/16/24 East West Bank CD 06/11/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Veritex Community Bank CD 07/15/24 East West Bank CD 07/16/24 East West Bank CD 07/17/24 East West Bank CD 07/22/24 Independent Financial CD 07/24/24 FHLB 07/26/24 Alliance Bank CD 08/02/24 Veritex Community Bank CD 08/05/24 East West Bank CD 08/19/24 FFCB 08/21/24 Alliance Bank CD 09/06/24 Veritex Community Bank CD 09/11/24 Veritex Community Bank CD 09/25/24 Alliance Bank CD 10/10/24 Veritex Community Bank CD 10/16/24 Alliance Bank CD 11/01/24 Bank OZK CD 11/13/24 Veritex Community Bank CD 12/11/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 East West Bank CD 12/16/24 BOK Financial CD 12/19/24 Alliance Bank CD 02/24/25 Bank OZK CD 04/20/25 Third Coast Bank CD 06/28/25 Totals December 31, 2023 (Continued) City - 2023 GO Parks City - 2023 GO Roads City - 2023 Revenue Electric City - 2023 Revenue Water/WW City - American Rescue Plan City - Impact Fees - Water City - Impact Fees - WW City - Limited Tax Note, Series 2022 –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,888,966 15,689,940 6,974,810 29,160,783 8,372,380 22,930,337 9,082,044 3,342,261 – – – – – – – – – – – – – – – – – – – – – – – – – – – 20,534,449 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,070,821 – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,228,224 – – – – – – – –– – 5,131,014 – – – – – – – – – – – – – – – – – – – – – – – – – 20,474,413 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,093,062 – – – – – – – –– – – – – – – –– – – – – – – –– 10,134,301 – – – – – –– 10,139,261 – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – 4,888,966$ 25,914,016$ 11,045,632$ 90,443,206$ 8,372,380$ 22,930,337$ 17,310,268$ 3,342,261$ City of Georgetown Valley View Consulting, L.L.C. 58 Quarterly Financial Report City - Allocation Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Street s/ Vehicles 2015 GO- Roads 2015 Revenue Water WW Garey Park Donation 2017 Revenue Water WW 2018 CO- Streets/ Facilities/ Equip 2018 GO- Roads 2019 CO- Streets/ Facilities/ Equip 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 GO- Roads Electric-LCRA Transformers JPMorgan Chase MMA 440,091$ 440,091$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ Wells Fargo Bank Cash 82,661 82,661 – – – – – – – – – – – – – – Wells Fargo Bank Sweep-MMF 9,035,571 9,035,571 – – – – – – – – – – – – – – Veritex Community Bank MMA 3,390,187 3,390,187 – – – – – – – – – – – – – – NexBank MMA 13,093,553 13,093,553 – – – – – – – – – – – – – – TexPool 31,175,398 31,175,398 – – – – – – – – – – – – – – TexSTAR 244,118,043 42,047,320 313,244 5,760,745 58,535 1,253,590 1,613,230 1,114,740 7,841,139 277,174 1,052,820 4,489,673 2,606,844 566,627 4,155,129 3,753,761 Bank OZK CD 09/30/23 25,629,056 – – – – – – – – – – – – – – – Bank OZK CD 10/09/23 5,019,310 5,019,310 – – – – – – – – – – – – – – East West Bank CD 10/12/23 13,958,905 – – – – – – – – – – – – – – – FHLB 10/13/23 2,496,064 2,496,064 – – – – – – – – – – – – – – East West Bank CD 10/18/23 10,339,465 – – – – – – – – – – – – – – – East West Bank CD 10/19/23 2,610,010 2,610,010 – – – – – – – – – – – – – – FHLB 10/24/23 9,967,067 – – – – – – – – – – – – – – – Bank OZK CD 11/13/23 10,055,315 10,055,315 – – – – – – – – – – – – – – East West Bank CD 11/13/23 3,146,685 – – – – – – – 3,146,685 – – – – – – – East West Bank CD 11/15/23 5,218,172 – – – – – – – – – – – – – – – FAMCA 11/22/23 2,000,000 2,000,000 – – – – – – – – – – – – – – East West Bank CD 12/11/23 9,272,734 9,272,734 – – – – – – – – – – – – – – FAMCA 12/13/23 10,000,000 10,000,000 – – – – – – – – – – – – – – East West Bank CD 12/20/23 2,617,868 – – – – – – – – – – – – – – – Alliance Bank CD 12/27/23 1,038,776 1,038,776 – – – – – – – – – – – – – – Bank OZK CD 12/30/23 26,654,219 – – – – – – – – – – – – – – – Alliance Bank CD 01/12/24 5,128,507 5,128,507 – – – – – – – – – – – – – – East West Bank CD 01/12/24 10,237,915 – – – – – – – – – – – – – – – East West Bank CD 01/17/24 20,240,029 – – – – – – – – – – – – – – – East West Bank CD 01/18/24 10,335,840 – – – – – – – – – – – – – – – Veritex Community Bank CD 01/23/24 10,326,803 10,326,803 – – – – – – – – – – – – – – East West Bank CD 01/26/24 4,089,106 – – – – – – – – – – – – – – – East West Bank CD 02/01/24 2,087,988 – – – – – – – – – – – – – 2,087,988 – Southside Bank CD 02/02/24 10,336,156 – – – – – – – – – – – – – –– East West Bank CD 02/02/24 5,047,398 – – – – – – – – – – – – – –– East West Bank CD 02/15/24 4,202,173 – – – – – – – – – – – – – –– Independent Financial CD 02/15/24 12,204,472 – – – – – – – – – – – – – –– FHLB 02/28/24 20,000,000 20,000,000 – – – – – – – – – – – – – – East West Bank CD 03/11/24 10,300,131 – – – – – – – – – – – – – – – East West Bank CD 03/11/24 4,012,556 – – – – – – – – – – – – – – – East West Bank CD 03/18/24 13,026,556 – – – – – – – – – – – – – – – BOK Financial CD 03/23/24 8,207,978 8,207,978 – – – – – – – – – – – – – – Third Coast Bank CD 03/28/24 8,113,929 – – – – – – – – – – – – – – – East West Bank CD 04/17/24 5,058,849 – – – – – – – – – – – – – – – Bank OZK CD 04/18/24 10,208,362 – – – – – – – – – – – – – – – East West Bank CD 04/26/24 10,215,245 10,215,245 – – – – – – – – – – – – – – East West Bank CD 05/02/24 20,185,941 – – – – – – – – – – – – – – – Independent Financial CD 05/09/24 8,191,432 8,191,432 – – – – – – – – – – – – – – T-Note 05/15/24 1,946,601 1,946,601 – – – – – – – – – – – – – – East West Bank CD 05/15/24 5,233,078 – – – – – – – – – – – – – – – BOK Financial CD 05/16/24 8,000,000 – – – – – – – – – – – – – – – East West Bank CD 06/11/24 5,015,530 – – – – – – – – – – – – – – – Alliance Bank CD 06/14/24 10,387,756 – – – – – – – – – – – – – – – East West Bank CD 06/17/24 15,698,159 15,698,159 – – – – – – – – – – – – – – Alliance Bank CD 06/27/24 13,608,571 13,608,571 – – – – – – – – – – – – – – Veritex Community Bank CD 07/15/24 10,092,790 10,092,790 – – – – – – – – – – – – – – East West Bank CD 07/17/24 5,057,585 – – – – – – – – – – – – – – – Independent Financial CD 07/24/24 10,223,149 – – – – – – – – – – – – – – – FHLB 07/26/24 10,000,000 – – – – – – – – – – – – – – – Alliance Bank CD 08/02/24 5,000,000 5,000,000 – – – – – – – – – – – – – – Veritex Community Bank CD 08/05/24 5,023,484 – – – – – – – – – – – – – – – East West Bank CD 08/19/24 5,034,141 5,034,141 – – – – – – – – – – – – – – FFCB 08/21/24 3,989,165 3,989,165 – – – – – – – – – – – – – – Alliance Bank CD 09/06/24 10,000,000 – – – – – – – – – – – – – – – Veritex Community Bank CD 09/11/24 10,000,000 – – – – – – – – – – – – – – – Veritex Community Bank CD 09/25/24 10,050,189 10,050,189 – – – – – – – – – – – – – – Alliance Bank CD 11/01/24 5,000,000 5,000,000 – – – – – – – – – – – – – – Alliance Bank CD 12/13/24 10,387,756 – – – – – – – – – – – – – – – T-Note 12/15/24 4,775,076 4,775,076 – – – – – – – – – – – – – – Alliance Bank CD 02/24/25 5,000,000 5,000,000 – – – – – – – – – – – – – – Third Coast Bank CD 06/28/25 10,128,548 10,128,548 – – – – – – – – – – – – – – Totals 832,768,089$ 294,150,193$ 313,244$ 5,760,745$ 58,535$ 1,253,590$ 1,613,230$ 1,114,740$ 10,987,824$ 277,174$ 1,052,820$ 4,489,673$ 2,606,844$ 566,627$ 6,243,118$ 3,753,761$ September 30, 2023 Book Value City of Georgetown Valley View Consulting, L.L.C. 59 Quarterly Financial Report City - Allocation JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR 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/17/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 East West Bank CD 01/26/24 East West Bank CD 02/01/24 Southside Bank CD 02/02/24 East West Bank CD 02/02/24 East West Bank CD 02/15/24 Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 East West Bank CD 03/11/24 East West Bank CD 03/18/24 BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 East West Bank CD 04/17/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24 East West Bank CD 05/02/24 Independent Financial CD 05/09/24 T-Note 05/15/24 East West Bank CD 05/15/24 BOK Financial CD 05/16/24 East West Bank CD 06/11/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Veritex Community Bank CD 07/15/24 East West Bank CD 07/17/24 Independent Financial CD 07/24/24 FHLB 07/26/24 Alliance Bank CD 08/02/24 Veritex Community Bank CD 08/05/24 East West Bank CD 08/19/24 FFCB 08/21/24 Alliance Bank CD 09/06/24 Veritex Community Bank CD 09/11/24 Veritex Community Bank CD 09/25/24 Alliance Bank CD 11/01/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 Alliance Bank CD 02/24/25 Third Coast Bank CD 06/28/25 Totals September 30, 2023 Book Value (Continued) 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 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 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 730,748 2,459,763 11,680 2,906,428 230,162 3,920,496 8,248,760 526,182 2,600,823 177,976 317,907 9,974,169 2,608,795 36,443,844 9,995,001 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,958,905 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,339,465 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 9,967,067 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,218,172 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,617,868 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 26,654,219 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,237,915 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,335,840 – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,089,106 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,336,156 – – – – – – – – – – – – – – – 5,047,398 – 4,202,173 – – – – – – – – – – – – – – – – – – – – – – – – – – 12,204,472 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,300,131 – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,026,556 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,208,362 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,233,078 – – – – – – – – – – – – – – – – – – – – – 8,000,000 – – – – – – – – – – – – – – – 5,015,530 – – – – – – – – – – – – – 10,387,756 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,057,585 – – – – – – – – – – – – – 10,223,149 – – – – – – – – – – – – – – 10,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,387,756 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 730,748$ 6,661,936$ 11,680$ 2,906,428$ 230,162$ 6,538,365$ 18,700,009$ 526,182$ 2,600,823$ 177,976$ 317,907$ 41,048,736$ 2,608,795$ 196,026,131$ 25,115,513$ City of Georgetown Valley View Consulting, L.L.C. 60 Quarterly Financial Report City - Allocation JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR 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/17/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 East West Bank CD 01/26/24 East West Bank CD 02/01/24 Southside Bank CD 02/02/24 East West Bank CD 02/02/24 East West Bank CD 02/15/24 Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 East West Bank CD 03/11/24 East West Bank CD 03/18/24 BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 East West Bank CD 04/17/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24 East West Bank CD 05/02/24 Independent Financial CD 05/09/24 T-Note 05/15/24 East West Bank CD 05/15/24 BOK Financial CD 05/16/24 East West Bank CD 06/11/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Veritex Community Bank CD 07/15/24 East West Bank CD 07/17/24 Independent Financial CD 07/24/24 FHLB 07/26/24 Alliance Bank CD 08/02/24 Veritex Community Bank CD 08/05/24 East West Bank CD 08/19/24 FFCB 08/21/24 Alliance Bank CD 09/06/24 Veritex Community Bank CD 09/11/24 Veritex Community Bank CD 09/25/24 Alliance Bank CD 11/01/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 Alliance Bank CD 02/24/25 Third Coast Bank CD 06/28/25 Totals September 30, 2023 Book Value (Continued) City - 2023 CO Stormwater City - 2023 GO Parks City - 2023 GO Roads City - 2023 Revenue Electric City - 2023 Revenue Water/WW City - American Rescue Plan City - Impact Fees - Water City - Impact Fees - WW City - Limited Tax Note, Series 2022 –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 256,435 6,007,382 15,660,450 8,639,974 30,129,645 7,628,708 5,138,871 8,983,355 3,615,918 – – – – – – 25,629,056 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 20,240,029 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,012,556 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,113,929 – – – 5,058,849 – – – – – – – – – – – – – – – – – – – – – – – – – – – – 20,185,941 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,023,484 – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – – – – – 10,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 256,435$ 6,007,382$ 25,742,783$ 12,652,530$ 90,555,615$ 7,628,708$ 30,767,928$ 17,097,283$ 3,615,918$ City of Georgetown Valley View Consulting, L.L.C. 61 Quarterly Financial Report City - Allocation Market Value Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Street s/ Vehicles 2015 GO- Roads 2015 Revenue Water WW Garey Park Donation 2017 Revenue Water WW 2018 CO- Streets/ Facilities/ Equip 2018 GO- Roads 2019 CO- Streets/ Facilities/ Equip 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 GO- Roads Electric-LCRA Transformers JPMorgan Chase MMA 440,091$ 440,091$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ Wells Fargo Bank Cash 82,661 82,661 – – – – – – – – – – – – – – Wells Fargo Bank Sweep-MMF 9,035,571 9,035,571 – – – – – – – – – – – – – – Veritex Community Bank MMA 3,390,187 3,390,187 – – – – – – – – – – – – – – NexBank MMA 13,093,553 13,093,553 – – – – – – – – – – – – – – TexPool 31,175,398 31,175,398 – – – – – – – – – – – – – – TexSTAR 244,118,043 42,047,320 313,244 5,760,745 58,535 1,253,590 1,613,230 1,114,740 7,841,139 277,174 1,052,820 4,489,673 2,606,844 566,627 4,155,129 3,753,761 Bank OZK CD 09/30/23 25,629,056 – – – – – – – – – – – – – – – Bank OZK CD 10/09/23 5,019,310 5,019,310 – – – – – – – – – – – – – – East West Bank CD 10/12/23 13,958,905 – – – – – – – – – – – – – – – FHLB 10/13/23 2,496,087 2,496,087 – – – – – – – – – – – – – – East West Bank CD 10/18/23 10,339,465 – – – – – – – – – – – – – – – East West Bank CD 10/19/23 2,610,010 2,610,010 – – – – – – – – – – – – – – FHLB 10/24/23 9,968,722 – – – – – – – – – – – – – – – Bank OZK CD 11/13/23 10,055,315 10,055,315 – – – – – – – – – – – – – – East West Bank CD 11/13/23 3,146,685 – – – – – – – 3,146,685 – – – – – – – East West Bank CD 11/15/23 5,218,172 – – – – – – – – – – – – – – – FAMCA 11/22/23 1,997,296 1,997,296 – – – – – – – – – – – – – – East West Bank CD 12/11/23 9,272,734 9,272,734 – – – – – – – – – – – – – – FAMCA 12/13/23 9,985,183 9,985,183 – – – – – – – – – – – – – – East West Bank CD 12/20/23 2,617,868 – – – – – – – – – – – – – – – Alliance Bank CD 12/27/23 1,038,776 1,038,776 – – – – – – – – – – – – – – Bank OZK CD 12/30/23 26,654,219 – – – – – – – – – – – – – – – Alliance Bank CD 01/12/24 5,128,507 5,128,507 – – – – – – – – – – – – – – East West Bank CD 01/12/24 10,237,915 – – – – – – – – – – – – – – – East West Bank CD 01/17/24 20,240,029 – – – – – – – – – – – – – – – East West Bank CD 01/18/24 10,335,840 – – – – – – – – – – – – – – – Veritex Community Bank CD 01/23/24 10,326,803 10,326,803 – – – – – – – – – – – – – – East West Bank CD 01/26/24 4,089,106 – – – – – – – – – – – – – – – East West Bank CD 02/01/24 2,087,988 – – – – – – – – – – – – – 2,087,988 – Southside Bank CD 02/02/24 10,336,156 – – – – – – – – – – – – – –– East West Bank CD 02/02/24 5,047,398 – – – – – – – – – – – – – –– East West Bank CD 02/15/24 4,202,173 – – – – – – – – – – – – – –– Independent Financial CD 02/15/24 12,204,472 – – – – – – – – – – – – – –– FHLB 02/28/24 19,997,680 19,997,680 – – – – – – – – – – – – – – East West Bank CD 03/11/24 10,300,131 – – – – – – – – – – – – – – – East West Bank CD 03/11/24 4,012,556 – – – – – – – – – – – – – – – East West Bank CD 03/18/24 13,026,556 – – – – – – – – – – – – – – – BOK Financial CD 03/23/24 8,207,978 8,207,978 – – – – – – – – – – – – – – Third Coast Bank CD 03/28/24 8,113,929 – – – – – – – – – – – – – – – East West Bank CD 04/17/24 5,058,849 – – – – – – – – – – – – – – – Bank OZK CD 04/18/24 10,208,362 – – – – – – – – – – – – – – – East West Bank CD 04/26/24 10,215,245 10,215,245 – – – – – – – – – – – – – – East West Bank CD 05/02/24 20,185,941 – – – – – – – – – – – – – – – Independent Financial CD 05/09/24 8,191,432 8,191,432 – – – – – – – – – – – – – – T-Note 05/15/24 1,936,484 1,936,484 – – – – – – – – – – – – – – East West Bank CD 05/15/24 5,233,078 – – – – – – – – – – – – – – – BOK Financial CD 05/16/24 8,000,000 – – – – – – – – – – – – – – – East West Bank CD 06/11/24 5,015,530 – – – – – – – – – – – – – – – Alliance Bank CD 06/14/24 10,387,756 – – – – – – – – – – – – – – – East West Bank CD 06/17/24 15,698,159 15,698,159 – – – – – – – – – – – – – – Alliance Bank CD 06/27/24 13,608,571 13,608,571 – – – – – – – – – – – – – – Veritex Community Bank CD 07/15/24 10,092,790 10,092,790 – – – – – – – – – – – – – – East West Bank CD 07/17/24 5,057,585 – – – – – – – – – – – – – – – Independent Financial CD 07/24/24 10,223,149 – – – – – – – – – – – – – – – FHLB 07/26/24 9,964,841 – – – – – – – – – – – – – – – Alliance Bank CD 08/02/24 5,000,000 5,000,000 – – – – – – – – – – – – – – Veritex Community Bank CD 08/05/24 5,023,484 – – – – – – – – – – – – – – – East West Bank CD 08/19/24 5,034,141 5,034,141 – – – – – – – – – – – – – – FFCB 08/21/24 3,980,276 3,980,276 – – – – – – – – – – – – – – Alliance Bank CD 09/06/24 10,000,000 – – – – – – – – – – – – – – – Veritex Community Bank CD 09/11/24 10,000,000 – – – – – – – – – – – – – – – Veritex Community Bank CD 09/25/24 10,050,189 10,050,189 – – – – – – – – – – – – – – Alliance Bank CD 11/01/24 5,000,000 5,000,000 – – – – – – – – – – – – – – Alliance Bank CD 12/13/24 10,387,756 – – – – – – – – – – – – – – – T-Note 12/15/24 4,748,242 4,748,242 – – – – – – – – – – – – – – Alliance Bank CD 02/24/25 5,000,000 5,000,000 – – – – – – – – – – – – – – Third Coast Bank CD 06/28/25 10,128,548 10,128,548 – – – – – – – – – – – – – – Totals 531,333,424$ 194,819,755$ -$ -$ -$ -$ -$ -$ 3,146,685$ -$ -$ -$ -$ -$ 2,087,988$ -$ September 30, 2023 City of Georgetown Valley View Consulting, L.L.C.62 Quarterly Financial Report City - Allocation Market Value JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMANexBank MMA TexPool TexSTAR Bank OZK CD 09/30/23Bank 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/23FHLB10/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/23East 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/23Alliance Bank CD 01/12/24 East West Bank CD 01/12/24 East West Bank CD 01/17/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24East West Bank CD 01/26/24 East West Bank CD 02/01/24 Southside Bank CD 02/02/24 East West Bank CD 02/02/24 East West Bank CD 02/15/24Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 East West Bank CD 03/11/24 East West Bank CD 03/18/24BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 East West Bank CD 04/17/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24East West Bank CD 05/02/24 Independent Financial CD 05/09/24 T-Note 05/15/24 East West Bank CD 05/15/24 BOK Financial CD 05/16/24East West Bank CD 06/11/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Veritex Community Bank CD 07/15/24East West Bank CD 07/17/24 Independent Financial CD 07/24/24 FHLB 07/26/24 Alliance Bank CD 08/02/24 Veritex Community Bank CD 08/05/24East West Bank CD 08/19/24 FFCB 08/21/24 Alliance Bank CD 09/06/24 Veritex Community Bank CD 09/11/24 Veritex Community Bank CD 09/25/24Alliance Bank CD 11/01/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 Alliance Bank CD 02/24/25 Third Coast Bank CD 06/28/25 Totals September 30, 2023 (Continued) City - 2023 CO Stormwater City - 2023 GO Parks City - 2023 GO Roads City - 2023 Revenue Electric City - 2023 Revenue Water/WW City - American Rescue Plan City - Impact Fees - Water City - Impact Fees - WW City - Limited Tax Note, Series 2022 –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 256,435 6,007,382 15,660,450 8,639,974 30,129,645 7,628,708 5,138,871 8,983,355 3,615,918 – – – – – – 25,629,056 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 20,240,029 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,012,556 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,113,929 – – – 5,058,849 – – – – – – – – – – – – – – – – – – – – – – – – – – – – 20,185,941 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,023,484 – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – – – – – 10,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – -$ -$ 10,082,332$ 4,012,556$ 60,425,970$ -$ 25,629,056$ 8,113,929$ -$ City of Georgetown Valley View Consulting, L.L.C.64 Quarterly Financial Report Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield MMA 2,247,962$ 2,247,962$ 2,278,303$ 2,278,303$ 5.33% Pools 6,426,370 6,426,370 6,180,552 6,180,552 5.35% CDs/Securities 2,515,088 2,515,088 2,551,995 2,551,995 5.95% 11,189,420$ 11,189,420$ 11,010,850$ 11,010,850$ 5.49% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 5.49%Total Portfolio 5.49% Rolling Three Month Treasury 5.53%Rolling Three Month Treasury 5.53% Rolling Six Month Treasury 5.49%Rolling Six Month Treasury 5.49% TexPool 5.37%TexPool 5.37% Interest income provided in separate report. September 30, 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. December 31, 2023 Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.66 Quarterly Financial Report 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.33%01/01/24 12/31/23 2,278,303$ 2,278,303$ 1.00 2,278,303$ 1 5.33% TexasDAILY AAAm 5.38%01/01/24 12/31/23 2,271,773 2,271,773 1.00 2,271,773 1 5.38% TexSTAR AAAm 5.34%01/01/24 12/31/23 3,908,778 3,908,778 1.00 3,908,778 1 5.34% East West Bank CD 5.78%2/26/2024 08/24/23 2,551,995 2,551,995 1.00 2,551,995 57 5.95% 11,010,850$ 11,010,850$ 11,010,850$ 14 5.49% (1)(2) December 31, 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.68 Quarterly Financial Report Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield Pools/MMAs 24,908,141$ 24,908,141$ 18,589,898$ 18,589,898$ 5.36% CDs/Securities 18,200,215 18,200,215 18,449,935 18,449,935 5.60%Totals 43,108,356$ 43,108,356$ 37,039,833$ 37,039,833$ 5.48% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 5.48%Total Portfolio 5.48% Rolling Three Month Treasury 5.53%Rolling Three Month Treasury 5.53% Rolling Six Month Treasury 5.49%Rolling Six Month Treasury 5.49% TexPool 5.37%TexPool 5.37% Interest data provided in separate report. September 30, 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. December 31, 2023 Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.72 Quarterly Financial Report 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.37%01/01/24 12/31/23 13,409,760$ 13,409,760$ 1.00 13,409,760$ 1 5.37% TexSTAR AAAm 5.34%01/01/24 12/31/23 2,305,371 2,305,371 1.00 2,305,371 1 5.34% Veritex Bank MMA 5.33%01/01/24 12/31/23 2,874,767 2,874,767 1.00 2,874,767 1 5.33% Independent Financial CD 4.95%02/09/24 09/05/23 2,073,018 2,073,018 100.00 2,073,018 40 5.04% East West Bank CD 5.22%05/28/24 05/25/23 3,171,561 3,171,561 100.00 3,171,561 149 5.36% Alliance Bank CD 5.80%08/23/24 08/23/23 8,115,682 8,115,682 100.00 8,115,682 236 5.93% Veritex Community Bank CD 5.33%02/18/25 08/17/23 5,089,674 5,089,674 100.00 5,089,674 415 5.46% TOTALS 37,039,833$ 37,039,833$ 37,039,833$ 124 5.48% (1)(2) December 31, 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.74 City of Georgetown Capital Projects Life to Date Project Budget Total Spend Remaining Budget Percent Remaining CDBGPRJ000003 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% ElectricPRJ000022 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 9,267,103 7,209,710 2,057,393 22% PRJ000073 Power Quality Improvements 50,000 - 50,000 100%PRJ000147 Sectionalization Improvements 1,787,531 706,891 1,080,640 60%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 303,833 256,167 46%PRJ000192 Ronald Reagan - Glasscock Feeder extension along Hwy 195 - Phase II 591,250 287,020 304,230 51%PRJ000195 Downtown Overhead Rehab 2,400,000 39,610 2,360,390 98% PRJ000221 Titan-Aviation Dr to IH35 Infrastructure Addition 1,834,634 1,269,528 565,106 31%PRJ000225 Chapel Hill, WS-11139 (GEO-45-C.3)558,411 453,110 105,302 19%PRJ000226 Wolf Ranch West - Section 1AG & 1BG 635,363 500,769 134,594 21%PRJ000227 Ascend Westinghouse Apartments 444,598 408,915 35,683 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 366,351 225,463 140,888 38%PRJ000239 Wolf Ranch West - Section 3 - Phase 2 865,561 384,889 480,672 56% PRJ000242 Allora North Georgetown 557,422 335,058 222,364 40% PRJ000243 Fairfield Inn - WS11346 131,340 43,084 88,256 67%PRJ000245 Morgan Mays Street Apartments 452,508 321,670 130,838 29%PRJ000246 Vida Apartments 198,248 181,785 16,464 8%PRJ000247 Georgetown (Longhorn) Travel Center Rev 193,845 129,463 64,381 33%PRJ000250 Georgetown Infiniti 135,633 58,275 77,357 57% PRJ000269 Substation Feeder Exits and Extensions 250,000 - 250,000 100% PRJ000270 System Improvements - Power Quality 661,650 61,650 600,000 91%PRJ000271 System Improvements - Capacity Upgrades 8,063,593 104,950 7,958,643 99%PRJ000272 Wolf Lakes 566,109 556,287 9,823 2%PRJ000273 The Grove II Townhomes 108,924 43,683 65,241 60%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 522,413 (32,513) -7%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 158,999 148,446 48% 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,448 10,949 15%PRJ000292 Aviation Drive Extension - Lift Station 116,456 60,383 56,073 48%PRJ000296 Sun City NH10 - Phase B 122,543 121,331 1,212 1%PRJ000299 Wolf Lakes Apartments - Hines Tract 446,777 271,202 175,575 39%PRJ000300 Wolf Lakes Bella Lago Underground Extension 328,654 346,675 (18,021) -5% PRJ000301 Titan NorthPark 35 - Building 5 166,073 120,321 45,752 28% 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 228,625 (59,823) -35%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 110,947 55,615 33%PRJ000312 Dutch Bros. Coffee at 1309 W. University 38,354 23,682 14,672 38%PRJ000313 Rivery Crossing (WS# 11264)156,254 72,490 83,764 54%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 246,466 (26,923) -12% PRJ000317 Blue Springs Business Park (MPN# 21-108)474,203 346,358 127,846 27%PRJ000318 Costco 270,223 215,302 54,921 20%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,065 31,785 16%PRJ000329 Sun City NH 79 (MPN# 22-14)149,174 127,516 21,658 15% PRJ000330 2021 Airport Road Upgrade 484,281 - 484,281 100% 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 65,855 50,114 43%PRJ000336 Wolf Lakes Ascension Seton Georgetown MOB (MPN# 22-9)114,712 72,620 42,092 37%PRJ000340 Cellink (Gateway35 - Building 1) (MPN# 22-37)1,234,057 730,123 503,934 41% PRJ000341 Gateway35 Building 3 (MPN# 22-27)276,306 199,841 76,465 28% PRJ000342 Gateway35 Building 2 (MPN# 22-28)152,469 107,597 44,873 29% 78 City of Georgetown Capital Projects Life to Date Project Budget Total Spend Remaining Budget Percent Remaining PRJ000343 Gantt Serenada Subdivision (MPN# 22-44)25,414 18,521 6,892 27%PRJ000345 Baylor Scott & White Expansion 147,236 84,536 62,700 43%PRJ000346 Novak Chandra Multifamily - Wolf Lakes Village 536,146 40,395 495,751 92%PRJ000347 Titan NorthPark 35 – Building 6 (MPN# 22-47)377,275 302,233 75,041 20%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,000,000 63,965 936,035 94% PRJ000350 System Improvements - Ordinary Replacements 1,000,000 110,957 889,043 89%PRJ000351 Sun City Neighborhood 66 & 92 - Phase 1 (MPN#22-39)717,139 271,877 445,262 62%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 80,236 158,977 66% PRJ000386 Rock Springs Hospital Expansion 2022 (MPN# 22-81)197,284 145,899 51,385 26%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 645,146 170,822 21%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 - 94,384 100% PRJ000395 Chance Leigh Custom Homes 4,923 3,369 1,554 32%PRJ000397 Joseph Stephens Smooth Current Electric 4,312 3,629 683 16%PRJ000398 Loram Technologies, Inc (MPN#22-60)354,037 185,329 168,708 48%PRJ000400 95 DB Wood Rd Traffic Signal 4,050 - 4,050 100%PRJ000401 1402, 1406, 1410 Country Club Road 31,663 - 31,663 100%PRJ000402 KL Electric - 3707 Brangus Road 3,283 3,921 (639) -19% PRJ000407 Woodfield Preserve - Phase 1 (MPN# 22-83)542,498 27,009 515,489 95% PRJ000408 Fiber Support Hut in Sun City 3,396 - 3,396 100%PRJ000415 Titan Building 8 1,044,482 - 1,044,482 100%PRJ000418 Sun City NH65 288,395 - 288,395 100%PRJ000419 Sun City Ridge Top Well House-Partners 129,784 - 129,784 100%PRJ000421 Grace Episcopal West Campus 67,612 - 67,612 100% 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 - 9,003 100%PRJ000427 Woodfield Preserve - Phase 7 (MPN# 22-84)539,131 - 539,131 100%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 - 340,073 100%PRJ000437 505 West University Ave. – Service Upgrade (MPN# 22-70)68,602 - 68,602 100%PRJ000439 Tesla Charging Station - WR TC 66,433 - 66,433 100%PRJ000440 System Improvements - Voltage Conversion 1,000,000 - 1,000,000 100%Electric Total 54,704,152 24,829,224 29,874,929 55% Environmental ServicesPRJ000116 Transfer Station 11,000,000 1,095,424 9,904,576 90%Environmental Services Total 11,000,000 1,095,424 9,904,576 90% FinancePRJ000038 ERP Project 6,231,654 6,071,083 160,571 3%Finance Total 6,231,654 6,071,083 160,571 3% FirePRJ000134 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,415 193,415 - 0%Fire Total 1,996,931 1,662,607 334,324 17% FleetPRJ000124 Radio Replacement 1,565,278 931,675 633,603 40%PRJ000279 Electric Bond Funded Vehicles - FY22 1,065,000 958,977 106,023 10%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,204,710 72,290 6% PRJ000355 Bond Funded Fire Vehicles - FY23 2,158,750 1,320,238 838,512 39%PRJ000356 Bond Funded Police Vehicles - FY23 1,466,680 1,446,502 20,178 1%PRJ000357 PRJ000357 Bond Funded Public Safety Boat 236,500 - 236,500 100%PRJ000361 Bond Funded Stormwater Street Sweeper 357,500 348,105 9,395 3%PRJ000366 Electric Bond Funded Vehicles - FY23 1,241,940 - 1,241,940 100%PRJ000388 Stormwater Vehicles/Equipment - FY 22 280,000 211,147 68,853 25% Fleet Total 11,656,648 8,317,794 3,338,854 29% GTEC DepartmentPRJ000046 FM 971/ Fontana (Nw Bridge)1,209,000 1,206,390 2,610 0%PRJ000060 Rabbit Hill Road 4,100,000 682,802 3,417,198 83%PRJ000145 Sh29 Signal, Right Turn Lane, & Hard Median 1,595,000 410,979 1,184,021 74% PRJ000181 Aviation Drive 10,300,000 10,167,938 132,062 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 IH35/SH29 Intersection Improvements 20,000,000 - 20,000,000 100%GTEC Department Total 41,204,984 14,168,109 27,036,875 66% Management Services 79 City of Georgetown Capital Projects Life to Date Project Budget Total Spend Remaining Budget Percent Remaining PRJ000029 Downtown Parking Garage 291,483 142,130 149,354 51%PRJ000033 Dtwn Landsping & Public Art 5,746 5,746 - 0%PRJ000131 Fuel Station 1,100,000 108,388 991,613 90%PRJ000136 GMC Remodel Phase I 560,000 625,060 (65,060) -12%PRJ000178 Public Safety Operation and Training Center Phase II 6,000,000 5,200,421 799,579 13% PRJ000179 Recreation Center Teen/Senior Renovation 247,979 2,540 245,439 99% PRJ000184 Airport Maintenance Facility 1,250,000 115,900 1,134,100 91%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,000 2,293,000 90%PRJ000337 Downtown Austin Ave Parking Garage - ARPA 7,800,000 973,150 6,826,850 88% PRJ000338 Downtown Austin Ave Parking Garage - Bond Funded 7,507,500 100 7,507,400 100% PRJ000352 Signature Gateway - Downtown 538,500 - 538,500 100%PRJ000353 Fire Station 1 546,000 - 546,000 100%PRJ000369 Bollards 60,000 - 60,000 100%PRJ000389 Tax Note Project Management, Series 2022 4,192,801 - 4,192,801 100%Management Services Total 38,258,046 7,792,790 30,465,256 80% ParksPRJ000048 Garey Park 15,346,730 15,284,927 61,804 0%PRJ000125 Parks Master Plan 229,998 226,871 3,127 1%PRJ000126 Regional Trail Development 1,372,684 1,347,362 25,322 2%PRJ000129 Ada Transition Plan 1,075,982 835,341 240,641 22%PRJ000190 Heritage Gardens 275,860 248,153 27,707 10% PRJ000240 South Main Plaza 339,414 435,227 (95,813) -28% PRJ000249 GVPID Landscape Improvements 61,500 59,250 2,250 4%PRJ000253 Southeast Community Park 14,500,000 - 14,500,000 100%PRJ000278 Regional Trail Improvements 669,000 74,900 594,100 89%PRJ000293 San Gabriel Park - Phase 3 7,813,870 889,476 6,924,394 89%PRJ000322 Crystal Knoll Park 250,000 138,087 111,913 45% 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 47,700 202,300 81%PRJ000327 La Conterra Park 250,000 48,400 201,600 81%PRJ000328 Waypoint Park 200,000 14,500 185,500 93%PRJ000358 Parks Replacement (Previously SRF)- 42,651 (42,651) 0% PRJ000359 Parks Safety Improvements 1,057,300 - 1,057,300 100% PRJ000364 Bark Park Pet Memorial 25,000 6,156 18,844 75%PRJ000385 Garey Park - Phase II 1,000,000 - 1,000,000 100%PRJ000441 Garey Park Estate 3,500,000 - 3,500,000 100%Parks Total 48,517,337 19,754,199 28,763,138 59% 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 600,000 343,447 256,553 43%PRJ000140 Austin Ave Bridges 10,184,000 1,055,062 9,128,939 90%PRJ000141 Southwestern Blvd 4,200,000 876,460 3,323,540 79% PRJ000143 Leander Rd(Norwood-Swbypass)6,750,000 1,656,169 5,093,831 75% 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,935,589 1,191,547 744,042 38%PRJ000188 DB Wood (SH 29 to Oak Ridge)18,000,000 2,537,551 15,462,449 86%PRJ000202 FM 971 5,821,392 5,491,011 330,381 6% PRJ000207 Northwest Blvd Bridge 5,527,427 11,661,236 (6,133,809) -111% PRJ000209 Southeast Inner Loop 10,521,000 8,673,393 1,847,607 18%PRJ000210 2021 HIPR Street Maintenance 2,300,000 2,294,978 5,022 0%PRJ000211 2021 High Performance Pavement Seal Project #1 785,719 712,642 73,077 9%PRJ000212 2021 High Performance Pavement Seal Project #2 515,698 491,261 24,437 5%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 5,776,000 1,347,017 4,428,983 77%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)21,163,600 2,427,907 18,735,693 89% PRJ000267 Allocations - Intersections/Bike Lanes/Sidewalks - MB21 10,800,000 - 10,800,000 100%PRJ000276 2023 HIPR Street Maintenance 4,000,000 578,000 3,422,000 86%PRJ000277 Intersection Improvements - FY22 1,162,150 - 1,162,150 100%PRJ000294 2022 HIPR 2,999,466 2,811,059 188,408 6%PRJ000295 2022 High Performance Pavement Seal 1,245,021 1,228,609 16,412 1%PRJ000297 Southeast Inner Loop - MB21 32,777,940 3,050,500 29,727,440 91% PRJ000304 Memorial Drive 3,100,000 - 3,100,000 100% PRJ000310 Southwest Bypass (Wolf Ranch Parkway to SH29)2,000,000 2,000,000 - 0%PRJ000332 Williams Drive (MB21)10,391,760 - 10,391,760 100%PRJ000367 Wolf Ranch Parkway 1,000,000 - 1,000,000 100%PRJ000382 2023 High Performance Pavement Seal 2,500,000 357,100 2,142,900 86%PRJ000383 2023 Unscheduled Pavement Repair 1,000,000 - 1,000,000 100%Public Works Department Total 201,581,455 70,539,119 131,042,336 65% 80 City of Georgetown Capital Projects Life to Date Project Budget Total Spend Remaining Budget Percent Remaining StormwaterPRJ000004 18th and Hutto Drainage 164,793 8,133 156,660 95%PRJ000024 2020 Curb & Gutter 1,055,000 720,059 334,941 32%PRJ000104 Stormwater Infrastructure 347,000 168,506 178,495 51%PRJ000149 Drainage Improvement/Flood Mitigation Projects 320,000 - 320,000 100% PRJ000213 2021 Curb & Gutter Project 500,000 872,905 (372,905) -75% PRJ000274 2022 Curb & Gutter 500,000 65,250 434,750 87%Stormwater Total 2,886,793 1,834,852 1,051,941 36% WaterPRJ000014 Berry Creek Inter.49,949,000 3,170,673 46,778,327 94% PRJ000023 Cr 255 (Wd14-2)1,817,359 319,081 1,498,278 82% PRJ000057 Lift Station Upgrade 1,073,593 326,103 747,490 70%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,111,260 5,778,740 84%PRJ000101 Southlake Wtp 278,000,000 195,405,759 82,594,241 30%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 13,550,000 6,382,422 7,167,578 53%PRJ000154 Stonewall Ranch Pump Station Improvements 3,100,000 300,825 2,799,175 90%PRJ000155 Southside Water Treatment Plant 6,426,706 6,361,550 65,156 1%PRJ000157 Leander Interconnect 340,245 316,601 23,644 7%PRJ000160 Round Rock Supply Pump Station And Elevated Storage Tank 10,500,000 6,413,874 4,086,126 39%PRJ000161 Miscellaneous Line Upgrades 1,374,180 702,109 672,071 49% PRJ000163 Tank Rehabilitation 4,165,036 431,916 3,733,120 90% PRJ000165 San Gabriel WWTP Rehabilitation 18,757,307 1,634,500 17,122,807 91%PRJ000167 San Gabriel Inter SGI -2 4,500,000 912,755 3,587,245 80%PRJ000168 WWTP Upgrade 681,774 209,000 472,774 69%PRJ000177 Northlake WTP Phase IV Expansion 15,094,867 14,899,372 195,495 1%PRJ000185 Cimarron Hills Wastewater Treatment Plant Expansion 6,050,000 799,325 5,250,675 87% PRJ000218 EARZ Wastewater Rehabilitation Area 2 - 2019 2,559,897 2,310,949 248,948 10% PRJ000220 AMI Equipment Upgrades 7,750,000 - 7,750,000 100%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 37,856,283 52,200 37,804,083 100%PRJ000260 CR 262 Waterline 2,500,000 187,200 2,312,800 93% PRJ000261 Dove Springs WWTP Rehabilitation 12,098,663 516,900 11,581,764 96% PRJ000262 Wolf Ranch Expansion and Force Main 5,900,000 - 5,900,000 100%PRJ000263 Water - Wastewater Master Plan 1,225,000 747,017 477,983 39%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 18,525,000 1,023,320 17,501,680 94%PRJ000275 FY2022 EARZ -Area 4 2,000,000 - 2,000,000 100% PRJ000333 Smith Branch Lift Station Improvements 1,300,000 209,070 1,090,930 84%PRJ000363 EARZ Combined 3,746,396 2,808,790 937,606 25%PRJ000370 Northlands Wastewater Treatment Plant 56,000,000 - 56,000,000 100%PRJ000371 Sunny Trail (Teravista/1460) WW Lift Station 2,200,000 - 2,200,000 100%PRJ000372 ASR Well Development 10,000,000 - 10,000,000 100%PRJ000373 Downtown Waterline Upgrades 2,700,000 - 2,700,000 100% PRJ000374 Phase III Pump Design Costs and Line Assessments 2,500,000 - 2,500,000 100% PRJ000375 Blue Ridge Waterline 3,400,000 - 3,400,000 100%PRJ000376 SH 138 Waterline Upgrade 9,500,000 - 9,500,000 100%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 200,000 - 200,000 100% PRJ000387 IH35 Waterline Connection 2,500,000 160,115 2,339,885 94% Water Total 632,828,837 255,264,458 377,564,379 60% Grand Total 1,051,156,838 411,549,678 639,607,160 61% 81