Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
FY 24 - 2nd Quarter Report _Redacted
Quarterly Financial Report FINANCIAL REPORT AND INVESTMENT REPORT For the Quarter Ended March 31st, 2024 Table of Contents General Fund Narrative .............................................................................................................................. 1-7 General Fund Schedule ................................................................................................................................. 8 General Fund by Cost Center ................................................................................................................... 9-11 Electric Fund Narrative ........................................................................................................................... 12-15 Electric Fund Schedule ................................................................................................................................ 16 Water Services Fund Narrative ............................................................................................................... 17-19 Water Services Fund Schedule .................................................................................................................... 20 Convention & Visitors Bureau Narrative................................................................................................. 21-22 Convention & Visitors Bureau Fund Schedule ............................................................................................. 23 Airport Fund Narrative ........................................................................................................................... 24-25 Airport Fund Schedule ................................................................................................................................. 26 Georgetown Transportation Enhancement Corporation Fund Narrative ............................................... 27-28 Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 29 Georgetown Economic Development Corporation Fund Narrative ....................................................... 30-31 Georgetown Economic Development Corporation Fund Schedule ............................................................. 32 Council Discretionary Fund Schedule .......................................................................................................... 33 Joint Services Fund Schedule ....................................................................................................................... 34 Stormwater Services Narrative ............................................................................................................... 35-36 Stormwater Services Fund Schedule ........................................................................................................... 37 Quarterly Financial Report Village PID Services Narrative ...................................................................................................................... 38 Village PID Services Fund Schedule ............................................................................................................. 39 Solid Waste Narrative ............................................................................................................................. 40-41 Solid Waste Fund Schedule ......................................................................................................................... 42 Investment Report ……………………………………………………………………………………………………………………………..43-46 Quarterly Investment Report – City………………………………………………………………………………………………………47-66 Quarterly Investment Report - GEDCO ................................................................................................... 67-72 Quarterly Investment Report – GTEC……………………………………………………………………………………………………..73-79 Grant Applications……………………………………………………………………………………………………………………………………….80 Capital Improvement Projects………………………………………………………………………………………………………………..81-86 Quarterly Financial Report FIRE AND EMS DIVISION: Year-to-date personnel and operational expenditures through the quarter total $3,453,835, or 56.21% of budget for Fire Support Services/Administration, $11,178,773, or 52.60% of budget for Fire Emergency Services, and $2,293,666, or 57.11% of budget for Fire EMS. ADMINISTRATIVE SERVICES DIVISION: Administrative Services saw operational and personnel costs totaling $1,252,110, or 41.13% of budget year-to-date. City Secretary personnel and operational expenditures for the quarter totals $905,313, which represents 53.86% of budget. Year-to-date personnel and operational expenditures for Communications totals $694,672, which represents 44.86% of budget. Non-Departmental includes a budget of $-90,000 for transfers out to various funds. As of the second 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 $1,879,055, or 51.18% 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 $5,339,291, or 46.96% of budget. Parks year-to-date through the quarter totals $1,545,341, or 48.23% of budget. Recreation total expenses are $2,070,705, which is 45.16% of budget. Garey Park year-to-date is $658,661, or 50.86% 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 $283,725, or 56.62% of budget, through the quarter, Animal Services has reported $632,218, which is 52.63% of their budget, Code Compliance has shown spending of $363,018, or 46.97% of budget. 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 the unknown economic impact of inflation and other economic factors. Within the Fee category, the Renewable Energy Credit (REC) revenue budget is $2,800,000. REC sales total $627,024, or 22.39% of budget through the quarter. Electric Services Quarterly Comparison: Q2 FY24 Budget FY2023 FY2024 FY2024 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2024 YTD Actuals: Q2 FY23 YTD Actuals: Q2 FY24 Variance % of Budget Variance % Variance Operating Revenue 40002:Sales Taxes 6,000 2,952 4,699 (1,301) 78.32% 1,747 59.20% 41002:Penalties 661,500 370,557 186,507 (474,993) 28.19% (184,050)-49.67% 42001:Interest Income 480,000 614,086 1,440,017 960,017 300.00% 825,931 134.50% 43001:Fees 4,690,847 1,590,919 1,233,178 (3,457,669) 26.29% (357,740)-22.49% 43003:Permits - - - - 0.00% -0.00% 43004:Administrative Charges 3,795,166 1,539,926 1,897,583 (1,897,583) 50.00% 357,657 23.23% 43601:Electric Retail Sales Revenue 101,564,995 37,776,222 41,574,080 (59,990,915) 40.93% 3,797,858 10.05% 44502:Developer Contributions 7,252,500 5,674,372 5,642,696 (1,609,804) 77.80% (31,676)-0.56% 70001:Transfers In 181,716 - - (181,716) 0.00% -0.00% Operating Revenue Total 118,632,724 47,569,033 51,978,760 (66,653,964) 43.81% 4,409,727 9.27% Non-Operating Revenue 45001:Misc Revenue 40,000 87,840 878,249 838,249 2195.62% 790,409 899.83% 45004:Sale of Property - 2,983 11,824 11,824 0.00% 8,841 296.35% 44001:Grant Revenue - 255,775 - - 0.00% (255,775)-100.00% 46001:Bond Proceeds 22,973,595 - 5,000 (22,968,595) 0.02% 5,000 0.00% Non-Operating Revenue Total 23,013,595 346,598 895,073 (22,118,522) 3.89% 548,475 158.25% Revenue Total 141,646,319 47,915,630 52,873,833 (88,772,486) 37.33% 4,958,202 10.35% The budget for non-operating revenue totals $23,013,595 in FY2024. As part of the annual debt process, the City will recognize bond proceeds in the spring to cover the costs of capital infrastructure and equipment, and will be reflected in the third quarter report. Year-to-date non-operating revenue totals $895,073, or 3.89% of budget. The majority of which is recorded as miscellaneous revenue related to settlement proceeds from Buckthorn. ELECTRIC EXPENSES: Operating expenses in the Electric Fund total $45,133,338 through the quarter. Total year-to-date purchase power expenses total $28,852,493, while Net Congestion Rights Revenue (CRRs) credits total $1,565,521. This is 42% of the budget. Total purchase power expense is $7,087,094 less, or -18.79% less than the same period last fiscal year. The City continues to use a hedging strategy for the winter and summer months to avoid price spikes in the market. Additionally, the purchased power budget assumed 13 Quarterly Financial Report several new large industrial loads would draw on the system. However, these companies have not produced this load. Year to date purchased power expenses are about 6% less than anticipated through March. Operating expenses in Electric Safety and Employee Development is trending higher than anticipated through the quarter. Year-to-date expenses include training/registration encumbered to Grid Training Corporation for training for 11 Apprentice Linemen. Electric Engineering and Transmission and Distribution (T&D) cost centers look inflated due to the capitalization of labor being budgeted in capital expense while the actuals are booked to the operating budget. The labor will be capitalized to the appropriate capital improvement project on the final year-end financial statements. Also included in the T&D service as a part of the mid-year budget amendment is the salary for a new position to aid in the city’s new streetlight management program. Electric Services Quarterly Comparison: Q2 FY24 Budget FY2023 FY2024 FY2024 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2024 YTD Actuals: Q2 FY23 YTD Actuals: Q2 FY24 Variance % of Budget Variance % Variance Operating Expense CC0001 Non-Departmental 7,693,400 2,709,957 2,685,686 5,007,714 34.91% 24,271 -0.90% CC0521 Operational Technology 2,525,774 973,451 777,031 1,748,743 30.76% 196,420 -20.18% CC0522 Electric Administration 11,044,010 4,999,532 5,149,390 5,894,620 46.63% (149,859)3.00% CC0523 Electric Safety and Employee Development 387,883 144,470 250,826 137,057 64.67% (106,356)73.62% CC0524 Metering Services - 738 - -0.00% 738 -100.00% CC0525 T&D Services 3,235,404 2,469,764 3,440,527 (205,123)106.34% (970,763)39.31% CC0537 Electric Resource Management 71,455,231 37,716,475 30,629,381 40,825,850 42.87% 7,087,094 -18.79% CC0555 Electric Systems Operations 2,381,653 1,090,026 1,146,789 1,234,864 48.15% (56,763)5.21% CC0557 Electrical Engineering 832,279 1,157,505 1,053,707 (221,428)126.61% 103,798 -8.97% Operating Expense Total 99,555,634 51,261,918 45,133,338 54,422,296 45.33% 6,128,580 -11.96% Non-Operating Expense CC0001 Non-Departmental 16,338,643 1,626,079 5,599,789 10,738,854 34.27% (3,973,709)244.37% CC0537 Electric Resource Management 237,448 - 238,948 (1,500)100.63% (238,948)0.00% CC0557 Electrical Engineering 45,414,662 12,623,581 9,854,378 35,560,284 21.70% 2,769,203 -21.94% Non-Operating Expense Total 61,990,753 14,249,660 15,693,114 46,297,639 25.32% (1,443,454)10.13% Expense Total 161,546,387 65,511,578 60,826,452 100,719,935 37.65% 4,685,126 -7.15% Non-operating expenditures are budgeted at $61,990,753 in FY2024. Budgeted non- operating expenditures include $45,414,662 for capital projects, $16,338,643 for debt service payments and $237,448 for the fees associated with Elecectric Letter of Credit. The FY2024 Capital Project Roll Forward amendment included $16,991,141 million of active projects. These encumbrances combined with increased New Development, shows an accelerated CIP spending in Electric Engineering compared to the previous year. As previously mentioned, a significant portion of labor expenses for capital 14 Quarterly Financial Report projects will be journaled at the end of the fiscal year, bringing operations and capital expense in balance with their budgets. The Electric Fund is budgeted to meet all the funds below line reserve requirements in FY2024. The contingency requirements include the 90-day operating contingency as well as the non-operating contingency reserve to align with industry standards and bond rating requirements. The 90-day operating contingency is $5,485,098, a non- operating reserve totaling $7,991,512, reserve for transformer of $45,022, as well as a rate stabilization reserve in the amount of $27,275,114. Much of the year-to-date Available Fund balance will be encumbered by Electric Engineering as capital projects progress through the year. 15 Quarterly Financial Report Fund Schedule: Electric Services Period: Mar-24 Budget Current Period FY2024 FY2024 Year-to-date: Budget Vs. Actuals FY2024 Mar-24 YTD Actuals: Q4 FY2024 Variance % of Budget Beginning Fund Balance 63,616,950 63,616,950 - 100.00% Operating Revenue 40002:Sales Taxes 6,000 589 4,699 (1,301) 78.32% 41002:Penalties 661,500 59,548 186,507 (474,993) 28.19% 42001:Interest Income 480,000 228,299 1,440,017 960,017 300.00% 43001:Fees 4,690,847 194,957 1,233,178 (3,457,669) 26.29% 43003:Permits - - - - 0.00% 43004:Administrative Charges 3,795,166 316,264 1,897,583 (1,897,583) 50.00% 43601:Electric Sales Charges 101,564,995 6,583,984 41,574,080 (59,990,915) 40.93%44502:Developer Contributions 7,252,500 (103,372) 5,642,696 (1,609,804) 77.80% 70001:Transfers In 181,716 - - (181,716) 0.00% Total Operating Revenue 118,632,724 7,280,270 51,978,760 (66,653,964) 43.81% Operating Expense CC0001 Non-Departmental 7,693,400 425,396 2,685,686 5,007,714 34.91% CC0521 Operational Technology 2,525,774 168,272 777,031 1,748,743 30.76% CC0522 Electric Administration 11,044,010 887,790 5,149,390 5,894,620 46.63% CC0523 Electric Safety and Employee Development 387,883 36,342 250,826 137,057 64.67% CC0524 Metering Services - - - - 0.00% CC0525 T&D Services 3,235,404 666,974 3,440,527 (205,123) 106.34% CC0537 Electric Resource Management 71,455,231 5,003,738 30,629,381 40,825,850 42.87% CC0555 Electric Systems Operations 2,381,653 252,323 1,146,789 1,234,864 48.15% CC0557 Electrical Engineering 832,279 237,137 1,053,707 (221,428) 126.61% Total Operating Expense 99,555,634 7,677,971 45,133,338 54,422,296 45.33% Net Operations Total 19,077,090 6,845,422 (121,076,260) 35.88% Non-Operating Revenue 45001:Misc Revenue 40,000 107 878,249 838,249 2195.62% 45004:Sale of Property - 2,304 11,824 11,824 0.00% 44001:Grant Revenue - - - - 0.00% 46001:Bond Proceeds 22,973,595 - 5,000 (22,968,595) 0.02% Total Non-Operating Revenue 23,013,595 2,411 895,073 (22,118,522) 3.89% Non-Operating Expense CC0001 Non-Departmental 16,338,643 3,822,414 5,599,789 10,738,854 34.27% CC0537 Electric Resource Management 237,448 - 238,948 (1,500) 100.63% CC0557 Electrical Engineering 45,414,662 467,693 9,854,378 35,560,284 21.70% Total Non-Operating Expense 61,990,753 4,290,107 15,693,114 46,297,639 25.32% Excess (Deficiency) of Total Revenue over Total Requirements (19,900,068) (4,685,396) (7,952,619) 11,947,448 39.96% Ending Fund Balance 43,716,882 55,664,331 11,947,448 127.33% Reserves Rate Stabilization 27,275,114 27,275,114 - 100.00% Non-Operating Reserve 7,991,512 7,991,512 - 100.00% Operating Contingency Reserve 5,485,098 5,485,098 - 100.00% Transformer Reserve 45,022 45,022 - 100.00% Reserves Total 40,796,746 40,796,746 - 100.00% Available Fund Balance 2,920,136 14,867,585 11,947,448 509.14% 16 Quarterly Financial Report The budget for non-operating expenses totals $12,131,872. This includes a CIP expense budget of $11,050,709 for the construction of a new transfer station. Debt Service has a budget of $1,081,163. Solid Waste Services Quarterly Comparison: Q2 FY24 Budget FY2023 FY2024 FY2024 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2024 YTD Actuals: Q2 FY23 YTD Actuals: Q2 FY24 Variance % of Budget Variance % Variance Operating Expense Personnel 216,563 - 107,148 109,415 49.48% (107,148)0.00% Operations 12,868,817 - 6,094,590 6,774,228 47.36% (6,094,590)0.00% Total Operating Expenses 13,085,380 - 6,201,737 6,883,643 47.39% (6,201,737)0.00% Non-Operating Expense CIP Expense 11,050,709 - 10,348,972 701,737 93.65% (10,348,972)0.00% Debt Service 1,081,163 - 319,553 761,611 29.56% (319,553)0.00% Non-Operating Expense Total 12,131,872 - 10,668,525 1,463,347 87.94% (10,668,525)0.00% Expense Total 25,217,252 - 16,870,262 8,346,990 66.90% (16,870,262)0.00% Ending fund balance is budgeted to be $259,040 in FY2024 with an operating contingency reserve of $173,745 and a debt service reserve of $85,294. 41 Quarterly Financial Report Fund Schedule: Solid Waste Services Period: Mar-24 Budget Current Period FY2024 FY2024 Year-to-date: Budget Vs. Actuals FY2024 Mar-24 YTD Actuals: Q2 FY24 Variance % of Budget Beginning Fund Balance 11,050,709 11,050,709 -100.00% Operating Revenues 40002:Sales Taxes - 412 1,657 1,657 0.00% 40005:Franchise Taxes - 176,583 176,583 176,583 0.00% 41002:Penalties 100,000 11,407 34,897 (65,103)34.90% 42001:Interest Income - 33,617 201,117 201,117 0.00% 43002:Garbage Charges 14,075,583 1,309,610 7,751,564 (6,324,019)55.07% 70001:Transfers In 250,000 - - (250,000)0.00% Total Operating Revenues 14,425,583 1,531,630 8,165,819 (6,259,764)56.61% Operating Expenses Personnel 216,563 25,293 107,148 109,415 49.48% Operations 12,868,817 1,209,137 6,094,590 6,774,228 47.36% Total Operating Expenses 13,085,380 1,234,430 6,201,737 6,883,643 47.39% Available Operating Funds 1,340,203 297,200 1,964,081 623,878 146.55% Non-Operating Revenues 45001:Misc Revenue - - (9,226) (9,226)0.00% Total Non-Operating Revenues - - (9,226) (9,226)0.00% Non-Operating Expenses CIP Expense 11,050,709 1,311,574 10,348,972 701,737 93.65% Debt Service 1,081,163 - 319,553 761,611 29.56% Total Non-Operating Expenses 12,131,872 1,311,574 10,668,525 1,463,347 87.94% Excess (Deficiency) of Total Revenue over Total Requirements (10,791,669) (1,014,374) (8,713,669) 2,078,000 80.74% Ending Fund Balance 259,040 (1,014,374) 2,337,040 2,078,000 902.19% Reserves Contingency Reserve 173,745 173,745 -100.00% Debt Service Reserve 85,294 85,294 -100.00% Reserves Total 259,039 259,039 -100.00% Available Fund Balance 1 2,078,001 2,078,000 0.00% 42 Quarterly Financial Report 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. 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 45 Quarterly Financial Report 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. 46 Quarterly Financial Report CITY QUARTERLY INVESTMENT REPORT For the Quarter Ended March 31, 2024 Prepared by Valley View Consulting, L.L.C. The investment portfolio of the City of Georgetown is in compliance with the Public Funds Investment Act and the Investment Policy and Strategies. Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or completeness of this information. The market values included in these reports were obtained by Valley View Consulting,L.L.C.from sources believed to be accurate and represent proprietary valuation. Due to market fluctuations these levels are not necessarily reflective of current liquidation values.Yield calculations are not determined using standard performance formulas, are not representative of total return yields and do not account for investment advisor fees.47 Quarterly Financial Report Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield Demand Accounts 203,202$ 203,202 20,667$ 20,667$ 0.00% NOW/MMA 32,068,622 32,068,622 30,283,936 30,283,936 5.37% Pools 298,944,519 298,944,519 287,181,711 287,181,711 5.30% CDs/Securities 527,635,295 527,629,924 532,694,210 532,617,291 5.39% Totals 858,851,639$ 858,846,267$ 850,180,524$ 850,103,605$ 5.36% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 5.36%Total Portfolio 5.36% Rolling Three Month Treasury 5.46%Rolling Three Month Treasury 5.49% Rolling Six Month Treasury 5.37%Rolling Six Month Treasury 5.43% TexPool 5.32%TexPool 5.34% Interest earnings provided in separate report. March 31, 2024December 31, 2023 (1)Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank, pool, and money market balances. (2)Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. City of Georgetown Valley View Consulting, L.L.C.148 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%04/01/24 03/31/24 20,667$ 20,667$ 1.00 20,667$ 1 0.00% Wells Fargo Bank Sweep-MMF 5.19%04/01/24 03/31/24 13,333,434 13,333,434 1.00 13,333,434 1 5.19% Veritex Community Bank MMA 5.33%04/01/24 03/31/24 3,481,788 3,481,788 1.00 3,481,788 1 5.33% NexBank MMA 5.55%04/01/24 03/31/24 13,465,784 13,465,784 1.00 13,465,784 1 5.55% Alliance Bank MMA 5.30%04/01/24 03/31/24 2,929 2,929 1.00 2,929 1 5.30% TexPool AAAm 5.32%04/01/24 03/31/24 34,509,710 34,509,710 1.00 34,509,710 1 5.32% TexSTAR AAAm 5.30%04/01/24 03/31/24 252,672,000 252,672,000 1.00 252,672,000 1 5.30% East West Bank CD 5.78%04/16/24 10/16/23 7,188,711 7,188,711 100.00 7,188,711 16 5.95% East West Bank CD 5.62%04/17/24 07/17/23 5,203,408 5,203,408 100.00 5,203,408 17 5.78% Bank OZK CD 4.92%04/18/24 04/18/23 10,461,879 10,461,879 100.00 10,461,879 18 5.04% East West Bank CD 4.92%04/26/24 04/26/23 10,470,344 10,470,344 100.00 10,470,344 26 5.04% East West Bank CD 5.63%05/02/24 08/02/23 20,763,805 20,763,805 100.00 20,763,805 32 5.79% Independent Financial CD 4.99%05/09/24 02/09/23 8,398,663 8,398,663 100.00 8,398,663 39 5.08% T-Note Aaa/AA+0.25%05/15/24 11/22/22 2,000,000 1,989,461 99.39 1,987,766 45 4.72% East West Bank CD 5.64%05/15/24 08/15/23 5,383,155 5,383,155 100.00 5,383,155 45 5.80% Bank OZK CD 5.50%05/16/24 11/16/23 5,091,993 5,091,993 100.00 5,091,993 46 5.65% BOK Financial CD 5.10%05/16/24 05/18/23 8,000,000 8,000,000 100.00 8,000,000 46 5.23% East West Bank CD 5.66%06/11/24 09/11/23 5,159,885 5,159,885 100.00 5,159,885 72 5.82% Alliance Bank CD 5.10%06/14/24 12/15/22 10,653,597 10,653,597 100.00 10,653,597 75 5.20% East West Bank CD 5.32%06/17/24 06/16/23 16,122,477 16,122,477 100.00 16,122,477 78 5.46% Alliance Bank CD 5.10%06/27/24 12/27/22 13,956,839 13,956,839 100.00 13,956,839 88 5.20% Veritex Community Bank CD 5.45%07/15/24 07/14/23 10,370,189 10,370,189 100.00 10,370,189 106 5.59% East West Bank CD 5.68%07/16/24 10/16/23 7,185,403 7,185,403 100.00 7,185,403 107 5.68% East West Bank CD 5.50%07/17/24 07/17/23 5,198,980 5,198,980 100.00 5,198,980 108 5.65% East West Bank CD 5.32%07/17/24 01/17/24 20,812,342 20,812,342 100.00 20,812,342 108 5.46% East West Bank CD 5.72%07/22/24 10/20/23 20,520,693 20,520,693 100.00 20,520,693 113 5.89% Independent Financial CD 4.50%07/24/24 01/23/23 10,456,299 10,456,299 100.00 10,456,299 115 4.58% FHLB Aaa/AA+5.18%07/26/24 02/28/23 10,000,000 10,000,000 99.96 9,996,454 117 5.18% East West Bank CD 5.29%08/01/24 02/01/24 10,087,332 10,087,332 100.00 10,087,332 123 5.43% Alliance Bank CD 5.80%08/02/24 08/01/23 5,145,648 5,145,648 100.00 5,145,648 124 5.93% Veritex Community Bank CD 5.53%08/05/24 08/23/23 5,163,603 5,163,603 100.00 5,163,603 127 5.67% East West Bank CD 5.52%08/19/24 08/17/23 5,175,399 5,175,399 100.00 5,175,399 141 5.67% FFCB Aaa/AA+4.88%08/21/24 02/27/23 4,000,000 3,995,274 99.85 3,993,856 143 5.19% Alliance Bank CD 5.70%09/06/24 09/07/23 10,279,902 10,279,902 100.00 10,279,902 159 5.82% Veritex Community Bank CD 5.56%09/11/24 09/13/23 10,280,460 10,280,460 100.00 10,280,460 164 5.70% East West Bank CD 5.42%09/11/24 03/11/24 4,128,573 4,128,573 100.00 4,128,573 164 5.57% March 31, 2024 City of Georgetown Valley View Consulting, L.L.C.350 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 March 31, 2024 East West Bank CD 5.42%09/18/24 03/18/24 7,014,566 7,014,566 100.00 7,014,566 171 5.57% Veritex Community Bank CD 5.56%09/25/24 09/25/23 10,332,057 10,332,057 100.00 10,332,057 178 5.70% Alliance Bank CD 5.40%09/27/24 01/02/24 10,128,712 10,128,712 100.00 10,128,712 180 5.51% Alliance Bank CD 5.85%10/10/24 10/10/23 7,609,387 7,609,387 100.00 7,609,387 193 5.98% Veritex Community Bank CD 5.54%10/16/24 10/16/23 2,558,211 2,558,211 100.00 2,558,211 199 5.68% East West Bank CD 5.09%10/18/24 01/18/24 10,590,960 10,590,960 100.00 10,590,960 201 5.22% East West Bank CD 5.13%10/28/24 01/26/24 4,195,097 4,195,097 100.00 4,195,097 211 5.26% Alliance Bank CD 5.75%11/01/24 08/01/23 5,144,384 5,144,384 100.00 5,144,384 215 5.88% Bank OZK CD 5.50%11/13/24 11/13/23 10,245,556 10,245,556 100.00 10,245,556 227 5.65% East West Bank CD 5.23%11/20/24 02/20/24 12,070,700 12,070,700 100.00 12,070,700 234 5.37% Veritex Community Bank CD 5.15%12/11/24 12/11/23 20,257,895 20,257,895 100.00 20,257,895 255 5.27% Alliance Bank CD 5.10%12/13/24 12/15/22 10,653,597 10,653,597 100.00 10,653,597 257 5.20% T-Note Aaa/AA+1.00%12/15/24 06/14/23 5,000,000 4,868,201 97.12 4,856,104 259 4.91% East West Bank CD 5.04%12/16/24 12/15/23 10,150,236 10,150,236 100.00 10,150,236 260 5.17% East West Bank CD 5.22%12/18/24 03/18/24 6,389,536 6,389,536 100.00 6,389,536 262 5.36% BOK Financial CD 5.07%12/19/24 12/21/23 10,142,671 10,142,671 100.00 10,142,671 263 5.20% Third Coast Bank CD 5.10%12/28/24 06/28/23 8,343,827 8,343,827 100.00 8,343,827 272 5.77% Alliance Bank CD 5.30%01/09/25 01/11/24 10,000,000 10,000,000 100.00 10,000,000 284 5.44% East West Bank CD 4.85%01/13/25 01/12/24 10,494,044 10,494,044 100.00 10,494,044 288 4.97% Veritex Community Bank CD 4.88%01/23/25 01/23/24 10,579,239 10,579,239 100.00 10,579,239 298 4.99% Veritex Community Bank CD 4.94%02/12/25 02/12/24 10,039,249 10,039,249 100.00 10,039,249 318 5.05% Alliance Bank CD 5.70%02/24/25 08/23/23 5,143,911 5,143,911 100.00 5,143,911 330 5.82% BOK Financial CDARS 5.10%03/13/25 03/14/24 10,025,172 10,025,172 100.00 10,025,172 347 5.23% East West Bank CD 5.14%03/25/25 03/25/24 8,007,889 8,007,889 100.00 8,007,889 359 5.27% Bank OZK CD 5.37%04/20/25 10/20/23 5,113,065 5,113,065 100.00 5,113,065 385 5.20% Alliance Bank CD 5.20%05/27/25 02/27/24 10,039,890 10,039,890 100.00 10,039,890 422 5.33% Third Coast Bank CD 5.10%06/28/25 06/28/23 10,387,415 10,387,415 100.00 10,387,415 454 5.20% Alliance Bank CD 4.90%07/11/25 01/12/24 5,264,752 5,264,752 100.00 5,264,752 467 4.99% FHLB Aaa/AA+4.65%08/13/25 02/13/24 10,000,000 10,000,000 99.69 9,968,550 500 4.65% FHLMC Aaa/AA+0.00%12/11/25 02/12/24 10,000,000 9,259,675 92.33 9,232,964 620 4.61% TOTALS 851,067,913$ 850,180,524$ 850,103,605$ 121 5.36% (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.451 Quarterly Financial Report City - Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 12/31/23 Increases Decreases Book Value 03/31/24 Market Value 12/31/23 Change in Market Value Market Value 03/31/24 Wells Fargo Bank Cash 0.00%04/01/24 203,202$ –$ (182,535)$ 20,667$ 203,202$ (182,535)$ 20,667$ Wells Fargo Bank Sweep-MMF 5.19%04/01/24 15,353,226 – (2,019,792) 13,333,434 15,353,226 (2,019,792) 13,333,434 Veritex Community Bank MMA 5.33%04/01/24 3,435,932 45,856 – 3,481,788 3,435,932 45,856 3,481,788 NexBank MMA 5.55%04/01/24 13,279,464 186,320 – 13,465,784 13,279,464 186,320 13,465,784 Alliance Bank MMA 5.30%04/01/24 – 2,929 – 2,929 – 2,929 2,929 TexPool 5.32%04/01/24 69,467,382 – (34,957,671) 34,509,710 69,467,382 (34,957,671) 34,509,710 TexSTAR 5.30%04/01/24 229,477,137 23,194,863 – 252,672,000 229,477,137 23,194,863 252,672,000 Bank OZK CD 5.05%01/02/24 26,983,831 – (26,983,831) – 26,983,831 (26,983,831) – Alliance Bank CD 5.25%01/12/24 5,195,079 – (5,195,079) – 5,195,079 (5,195,079) – East West Bank CD 5.12%01/12/24 10,367,487 – (10,367,487) – 10,367,487 (10,367,487) – East West Bank CD 5.90%01/17/24 20,534,449 – (20,534,449) – 20,534,449 (20,534,449) – East West Bank CD 4.82%01/18/24 10,459,268 – (10,459,268) – 10,459,268 (10,459,268) – Veritex Community Bank CD 4.95%01/23/24 10,451,917 – (10,451,917) – 10,451,917 (10,451,917) – East West Bank CD 5.22%01/26/24 4,141,901 – (4,141,901) – 4,141,901 (4,141,901) – East West Bank CD 5.91%02/01/24 2,118,414 – (2,118,414) – 2,118,414 (2,118,414) – Southside Bank CD 3.32%02/02/24 10,422,651 – (10,422,651) – 10,422,651 (10,422,651) – East West Bank CD 5.91%02/02/24 5,120,948 – (5,120,948) – 5,120,948 (5,120,948) – East West Bank CD 5.93%02/15/24 4,263,622 – (4,263,622) – 4,263,622 (4,263,622) – Independent Financial CD 5.27%02/15/24 12,360,109 – (12,360,109) – 12,360,109 (12,360,109) – FHLB 5.35%02/28/24 20,000,000 – (20,000,000) – 19,992,380 (19,992,380) – East West Bank CD 5.38%03/11/24 10,437,065 – (10,437,065) – 10,437,065 (10,437,065) – East West Bank CD 5.89%03/11/24 4,070,821 – (4,070,821) – 4,070,821 (4,070,821) – East West Bank CD 5.90%03/18/24 13,216,045 – (13,216,045) – 13,216,045 (13,216,045) – BOK Financial CD 5.00%03/23/24 8,309,541 – (8,309,541) – 8,309,541 (8,309,541) – East West Bank CD 5.95%04/16/24 7,085,870 102,841 – 7,188,711 7,085,870 102,841 7,188,711 East West Bank CD 5.78%04/17/24 5,131,014 72,394 – 5,203,408 5,131,014 72,394 5,203,408 Bank OZK CD 5.04%04/18/24 10,334,343 127,536 – 10,461,879 10,334,343 127,536 10,461,879 East West Bank CD 5.04%04/26/24 10,342,705 127,639 – 10,470,344 10,342,705 127,639 10,470,344 East West Bank CD 5.79%05/02/24 20,474,413 289,392 – 20,763,805 20,474,413 289,392 20,763,805 Independent Financial CD 5.08%05/09/24 8,294,460 104,203 – 8,398,663 8,294,460 104,203 8,398,663 T-Note 4.72%05/15/24 1,968,148 21,313 – 1,989,461 1,964,063 23,703 1,987,766 East West Bank CD 5.80%05/15/24 5,307,996 75,159 – 5,383,155 5,307,996 75,159 5,383,155 Bank OZK CD 5.65%05/16/24 5,022,652 69,341 – 5,091,993 5,022,652 69,341 5,091,993 BOK Financial CD 5.23%05/16/24 8,000,000 – – 8,000,000 8,000,000 – 8,000,000 East West Bank CD 5.82%06/11/24 5,087,590 72,295 – 5,159,885 5,087,590 72,295 5,159,885 Alliance Bank CD 5.20%06/14/24 10,519,837 133,760 – 10,653,597 10,519,837 133,760 10,653,597 East West Bank CD 5.46%06/17/24 15,910,063 212,414 – 16,122,477 15,910,063 212,414 16,122,477 Alliance Bank CD 5.20%06/27/24 13,781,605 175,234 – 13,956,839 13,781,605 175,234 13,956,839 Veritex Community Bank CD 5.59%07/15/24 10,230,549 139,640 – 10,370,189 10,230,549 139,640 10,370,189 East West Bank CD 5.68%07/16/24 7,084,375 101,028 – 7,185,403 7,084,375 101,028 7,185,403 East West Bank CD 5.65%07/17/24 5,128,181 70,798 – 5,198,980 5,128,181 70,798 5,198,980 East West Bank CD 5.46%07/17/24 – 20,812,342 – 20,812,342 – 20,812,342 20,812,342 City of Georgetown Valley View Consulting, L.L.C.653 Quarterly Financial Report City - Allocation Investment Total Consolidated Debt Service 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 City - 2021 CO Fac/Equip/ Parks Wells Fargo Bank Cash 20,667$ 20,667$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ Wells Fargo Bank Sweep-MMF 13,333,434 13,333,434 – – – – – – – – – – – – – – Veritex Community Bank MMA 3,481,788 3,481,788 – – – – – – – – – – – – – – NexBank MMA 13,465,784 13,465,784 – – – – – – – – – – – – – – Alliance Bank MMA 2,929 – – – – – – – – – – – – – – – TexPool 34,509,710 34,509,710 – – – – – – – – – – – – – – TexSTAR 252,672,000 33,523,772 37,057,284 1,155,492 1,373 1,144,798 8,692,559 214,823 316,556 447,143 1,787,218 72,383 3,691,934 25,339 728,631 259,303 East West Bank CD 04/16/24 7,188,711 – – – – – – – – – – – – – – – East West Bank CD 04/17/24 5,203,408 – – – – – – – – – – – – – – – Bank OZK CD 04/18/24 10,461,879 – – – – – – – – – – – – – – – East West Bank CD 04/26/24 10,470,344 10,470,344 – – – – – – – – – – – – – – East West Bank CD 05/02/24 20,763,805 – – – – – – – – – – – – – – – Independent Financial CD 05/09/24 8,398,663 8,398,663 – – – – – – – – – – – – – – T-Note 05/15/24 1,989,461 1,989,461 – – – – – – – – – – – – – – East West Bank CD 05/15/24 5,383,155 – – – – – – – – – – – – – – – Bank OZK CD 05/16/24 5,091,993 – – – – – – – – – – – – – – – BOK Financial CD 05/16/24 8,000,000 – – – – – – – – – – – – – – – East West Bank CD 06/11/24 5,159,885 – – – – – – – – – – – – – – – Alliance Bank CD 06/14/24 10,653,597 – – – – – – – – – – – – – – – East West Bank CD 06/17/24 16,122,477 16,122,477 – – – – – – – – – – – – – – Alliance Bank CD 06/27/24 13,956,839 13,956,839 – – – – – – – – – – – – – – Veritex Community Bank CD 07/15/24 10,370,189 10,370,189 – – – – – – – – – – – – – – East West Bank CD 07/16/24 7,185,403 – – – – – – – – – – – – – – – East West Bank CD 07/17/24 5,198,980 – – – – – – – – – – – – – – – East West Bank CD 07/17/24 20,812,342 – – – – – – – – – – – – – – – East West Bank CD 07/22/24 20,520,693 – – – – – – – – – – – – – – – Independent Financial CD 07/24/24 10,456,299 – – – – – – – – – – – – – – – FHLB 07/26/24 10,000,000 – – – – – – – – – – – – – – – East West Bank CD 08/01/24 10,087,332 – – – – – – – – – – – – – – – Alliance Bank CD 08/02/24 5,145,648 5,145,648 – – – – – – – – – – – – – – Veritex Community Bank CD 08/05/24 5,163,603 – – – – – – – – – – – – – – – East West Bank CD 08/19/24 5,175,399 5,175,399 – – – – – – – – – – – – – – FFCB 08/21/24 3,995,274 3,995,274 – – – – – – – – – – – – – – Alliance Bank CD 09/06/24 10,279,902 – – – – – – – – – – – – – – – Veritex Community Bank CD 09/11/24 10,280,460 – – – – – – – – – – – – – – – East West Bank CD 09/11/24 4,128,573 – – – – – – – – – – – – – – – East West Bank CD 09/18/24 7,014,566 – – – – – – – – – – – – – – – Veritex Community Bank CD 09/25/24 10,332,057 10,332,057 – – – – – – – – – – – – – – Alliance Bank CD 09/27/24 10,128,712 – – – – – – – – – – – – – – – Alliance Bank CD 10/10/24 7,609,387 7,609,387 – – – – – – – – – – – – – – Veritex Community Bank CD 10/16/24 2,558,211 2,558,211 – – – – – – – – – – – – – – East West Bank CD 10/18/24 10,590,960 – – – – – – – – – – – – – – – East West Bank CD 10/28/24 4,195,097 – – – – – – – – – – – – – – – Alliance Bank CD 11/01/24 5,144,384 5,144,384 – – – – – – – – – – – – – – Bank OZK CD 11/13/24 10,245,556 10,245,556 – – – – – – – – – – – – – – East West Bank CD 11/20/24 12,070,700 – – – – – – – – – – – – – – – Veritex Community Bank CD 12/11/24 20,257,895 20,257,895 – – – – – – – – – – – – – – Alliance Bank CD 12/13/24 10,653,597 – – – – – – – – – – – – – – – T-Note 12/15/24 4,868,201 4,868,201 – – – – – – – – – – – – – – East West Bank CD 12/16/24 10,150,236 10,150,236 – – – – – – – – – – – – – – East West Bank CD 12/18/24 6,389,536 – – – – – – – – – – – – – – – BOK Financial CD 12/19/24 10,142,671 10,142,671 – – – – – – – – – – – – – – Third Coast Bank CD 12/28/24 8,343,827 – – – – – – – – – – – – – – – Alliance Bank CD 01/09/25 10,000,000 – – – – – – – – – – – – – – – East West Bank CD 01/13/25 10,494,044 – – – – – – – – – – – – – – – Veritex Community Bank CD 01/23/25 10,579,239 10,579,239 – – – – – – – – – – – – – – Veritex Community Bank CD 02/12/25 10,039,249 10,039,249 – – – – – – – – – – – – – – Alliance Bank CD 02/24/25 5,143,911 5,143,911 – – – – – – – – – – – – – – BOK Financial CDARS 03/13/25 10,025,172 – – – – – – – – – – – – – – – East West Bank CD 03/25/25 8,007,889 8,007,889 – – – – – – – – – – – – – – Bank OZK CD 04/20/25 5,113,065 5,113,065 – – – – – – – – – – – – – – Alliance Bank CD 05/27/25 10,039,890 10,039,890 – – – – – – – – – – – – – – Third Coast Bank CD 06/28/25 10,387,415 10,387,415 – – – – – – – – – – – – – – Alliance Bank CD 07/11/25 5,264,752 5,264,752 – – – – – – – – – – – – – – FHLB 08/13/25 10,000,000 10,000,000 – – – – – – – – – – – – – – FHLMC 12/11/25 9,259,675 9,259,675 – – – – – – – – – – – – – – Totals 850,180,524$ 339,103,134$ 37,057,284$ 1,155,492$ 1,373$ 1,144,798$ 8,692,559$ 214,823$ 316,556$ 447,143$ 1,787,218$ 72,383$ 3,691,934$ 25,339$ 728,631$ 259,303$ Book Value March 31, 2024 City of Georgetown Valley View Consulting, L.L.C.855 Quarterly Financial Report City - Allocation Wells Fargo Bank CashWells Fargo Bank Sweep-MMFVeritex Community Bank MMANexBank MMAAlliance Bank MMATexPoolTexSTAR East West Bank CD 04/16/24East West Bank CD 04/17/24Bank OZK CD 04/18/24East West Bank CD 04/26/24East West Bank CD 05/02/24Independent Financial CD 05/09/24T-Note 05/15/24East West Bank CD 05/15/24Bank OZK CD 05/16/24BOK Financial CD 05/16/24East West Bank CD 06/11/24Alliance Bank CD 06/14/24East West Bank CD 06/17/24Alliance Bank CD 06/27/24Veritex Community Bank CD 07/15/24East West Bank CD 07/16/24East West Bank CD 07/17/24East West Bank CD 07/17/24East West Bank CD 07/22/24Independent Financial CD 07/24/24FHLB07/26/24East West Bank CD 08/01/24Alliance Bank CD 08/02/24Veritex Community Bank CD 08/05/24East West Bank CD 08/19/24FFCB08/21/24Alliance Bank CD 09/06/24Veritex Community Bank CD 09/11/24East West Bank CD 09/11/24East West Bank CD 09/18/24Veritex Community Bank CD 09/25/24Alliance Bank CD 09/27/24Alliance Bank CD 10/10/24Veritex Community Bank CD 10/16/24East West Bank CD 10/18/24East West Bank CD 10/28/24Alliance Bank CD 11/01/24Bank OZK CD 11/13/24East West Bank CD 11/20/24Veritex Community Bank CD 12/11/24Alliance Bank CD 12/13/24T-Note 12/15/24East West Bank CD 12/16/24East West Bank CD 12/18/24BOK Financial CD 12/19/24Third Coast Bank CD 12/28/24Alliance Bank CD 01/09/25East West Bank CD 01/13/25Veritex Community Bank CD 01/23/25Veritex Community Bank CD 02/12/25Alliance Bank CD 02/24/25BOK Financial CDARS 03/13/25East West Bank CD 03/25/25Bank OZK CD 04/20/25Alliance Bank CD 05/27/25Third Coast Bank CD 06/28/25Alliance Bank CD 07/11/25FHLB08/13/25FHLMC12/11/25 Totals Book Value March 31, 2024 (Continued) City - 2021 GO Parks City - 2021 GO Roads City - 2021 CO Solid Waste 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 Revenue Electric City - 2022 Revenue Water/WW City - 2023 CO Fac/Equip/Parks City - 2023 CO Solid Waste –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,929 – – – – – – – – – – – – – – – – – 5,575 2,086,978 11,450 170,295 4,561,418 5,562,171 540,370 2,450,470 105,193 140,980 8,913,926 1,635,200 16,902,560 8,757,470 4,194,665 – – – – – – – – – – 7,188,711 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,461,879 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,383,155 – – – – – – – – – – – – – – 5,091,993 – – – – – – – – – – – – – – – – – – – – – 8,000,000 – – – – – – – – – – – – – – – 5,159,885 – – – – – – – – – – – – – 10,653,597 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 7,185,403 – – – – – – – – – – – – – – – – – 5,198,980 – – – – – – – – – – – – – – – – – – – – – – – – – – – – 20,520,693 – – – – – – – – – – – – – – 10,456,299 – – – – – – – – – – – – – – 10,000,000 – – – – – – – – – – – – – – 10,087,332 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 7,014,566 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,128,712 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,590,960 – – – – – – – – – – – – 4,195,097 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 12,070,700 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,653,597 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,389,536 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – – – – – – – – – – – 10,494,044 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,025,172 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,575$ 2,086,978$ 11,450$ 170,295$ 4,561,418$ 16,037,319$ 540,370$ 2,450,470$ 105,193$ 140,980$ 40,887,240$ 1,635,200$ 171,048,474$ 19,116,335$ 4,194,665$ City of Georgetown Valley View Consulting, L.L.C.956 Quarterly Financial Report City - Allocation Wells Fargo Bank CashWells Fargo Bank Sweep-MMFVeritex Community Bank MMANexBank MMAAlliance Bank MMATexPoolTexSTAR East West Bank CD 04/16/24East West Bank CD 04/17/24Bank OZK CD 04/18/24East West Bank CD 04/26/24East West Bank CD 05/02/24Independent Financial CD 05/09/24T-Note 05/15/24East West Bank CD 05/15/24Bank OZK CD 05/16/24BOK Financial CD 05/16/24East West Bank CD 06/11/24Alliance Bank CD 06/14/24East West Bank CD 06/17/24Alliance Bank CD 06/27/24Veritex Community Bank CD 07/15/24East West Bank CD 07/16/24East West Bank CD 07/17/24East West Bank CD 07/17/24East West Bank CD 07/22/24Independent Financial CD 07/24/24FHLB07/26/24East West Bank CD 08/01/24Alliance Bank CD 08/02/24Veritex Community Bank CD 08/05/24East West Bank CD 08/19/24FFCB08/21/24Alliance Bank CD 09/06/24Veritex Community Bank CD 09/11/24East West Bank CD 09/11/24East West Bank CD 09/18/24Veritex Community Bank CD 09/25/24Alliance Bank CD 09/27/24Alliance Bank CD 10/10/24Veritex Community Bank CD 10/16/24East West Bank CD 10/18/24East West Bank CD 10/28/24Alliance Bank CD 11/01/24Bank OZK CD 11/13/24East West Bank CD 11/20/24Veritex Community Bank CD 12/11/24Alliance Bank CD 12/13/24T-Note 12/15/24East West Bank CD 12/16/24East West Bank CD 12/18/24BOK Financial CD 12/19/24Third Coast Bank CD 12/28/24Alliance Bank CD 01/09/25East West Bank CD 01/13/25Veritex Community Bank CD 01/23/25Veritex Community Bank CD 02/12/25Alliance Bank CD 02/24/25BOK Financial CDARS 03/13/25East West Bank CD 03/25/25Bank OZK CD 04/20/25Alliance Bank CD 05/27/25Third Coast Bank CD 06/28/25Alliance Bank CD 07/11/25FHLB08/13/25FHLMC12/11/25 Totals Book Value March 31, 2024 (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 –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 29,988 2,757,688 15,787,319 4,171,452 28,638,289 8,483,650 32,201,150 12,367,034 3,078,102 – – – – – – – – – – – 5,203,408 – – – – – – – – – – – – – – – – – – – – – – – – – – – – 20,763,805 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 20,812,342 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,163,603 – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,279,902 – – – – – – – – 10,280,460 – – – – – – – 4,128,573 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,343,827 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 29,988$ 2,757,688$ 26,154,330$ 8,300,026$ 90,774,798$ 8,483,650$ 32,201,150$ 20,710,860$ 3,078,102$ City of Georgetown Valley View Consulting, L.L.C.1057 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 – – – – – – – – – – – – – – 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 – – – – – – – – – – – – – – Third Coast Bank CD 12/28/24 8,228,224 – – – – – – – – – – – – – – – 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$ December 31, 2023 Book Value City of Georgetown Valley View Consulting, L.L.C.1158 Quarterly Financial Report City - Allocation Wells Fargo Bank CashWells Fargo Bank Sweep-MMFVeritex Community Bank MMANexBank MMATexPoolTexSTAR Bank OZK CD 01/02/24Alliance Bank CD 01/12/24East West Bank CD 01/12/24East West Bank CD 01/17/24East West Bank CD 01/18/24Veritex Community Bank CD 01/23/24East West Bank CD 01/26/24East West Bank CD 02/01/24Southside Bank CD 02/02/24East West Bank CD 02/02/24East West Bank CD 02/15/24Independent Financial CD 02/15/24FHLB02/28/24East West Bank CD 03/11/24East West Bank CD 03/11/24East West Bank CD 03/18/24BOK Financial CD 03/23/24East West Bank CD 04/16/24East West Bank CD 04/17/24Bank OZK CD 04/18/24East West Bank CD 04/26/24East West Bank CD 05/02/24Independent Financial CD 05/09/24T-Note 05/15/24East West Bank CD 05/15/24Bank OZK CD 05/16/24BOK Financial CD 05/16/24East West Bank CD 06/11/24Alliance Bank CD 06/14/24East West Bank CD 06/17/24Alliance Bank CD 06/27/24Veritex Community Bank CD 07/15/24East West Bank CD 07/16/24East West Bank CD 07/17/24East West Bank CD 07/22/24Independent Financial CD 07/24/24FHLB07/26/24Alliance Bank CD 08/02/24Veritex Community Bank CD 08/05/24East West Bank CD 08/19/24FFCB08/21/24Alliance Bank CD 09/06/24Veritex Community Bank CD 09/11/24Veritex Community Bank CD 09/25/24Alliance Bank CD 10/10/24Veritex Community Bank CD 10/16/24Alliance Bank CD 11/01/24Bank OZK CD 11/13/24Veritex Community Bank CD 12/11/24Alliance Bank CD 12/13/24T-Note 12/15/24East West Bank CD 12/16/24BOK Financial CD 12/19/24Third Coast Bank CD 12/28/24Alliance Bank CD 02/24/25Bank OZK CD 04/20/25Third Coast Bank CD 06/28/25 Totals December 31, 2023 Book Value (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 Revenue Electric City - 2022 Revenue 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.1259 Quarterly Financial Report City - Allocation Wells Fargo Bank CashWells Fargo Bank Sweep-MMFVeritex Community Bank MMANexBank MMATexPoolTexSTAR Bank OZK CD 01/02/24Alliance Bank CD 01/12/24East West Bank CD 01/12/24East West Bank CD 01/17/24East West Bank CD 01/18/24Veritex Community Bank CD 01/23/24East West Bank CD 01/26/24East West Bank CD 02/01/24Southside Bank CD 02/02/24East West Bank CD 02/02/24East West Bank CD 02/15/24Independent Financial CD 02/15/24FHLB02/28/24East West Bank CD 03/11/24East West Bank CD 03/11/24East West Bank CD 03/18/24BOK Financial CD 03/23/24East West Bank CD 04/16/24East West Bank CD 04/17/24Bank OZK CD 04/18/24East West Bank CD 04/26/24East West Bank CD 05/02/24Independent Financial CD 05/09/24T-Note 05/15/24East West Bank CD 05/15/24Bank OZK CD 05/16/24BOK Financial CD 05/16/24East West Bank CD 06/11/24Alliance Bank CD 06/14/24East West Bank CD 06/17/24Alliance Bank CD 06/27/24Veritex Community Bank CD 07/15/24East West Bank CD 07/16/24East West Bank CD 07/17/24East West Bank CD 07/22/24Independent Financial CD 07/24/24FHLB07/26/24Alliance Bank CD 08/02/24Veritex Community Bank CD 08/05/24East West Bank CD 08/19/24FFCB08/21/24Alliance Bank CD 09/06/24Veritex Community Bank CD 09/11/24Veritex Community Bank CD 09/25/24Alliance Bank CD 10/10/24Veritex Community Bank CD 10/16/24Alliance Bank CD 11/01/24Bank OZK CD 11/13/24Veritex Community Bank CD 12/11/24Alliance Bank CD 12/13/24T-Note 12/15/24East West Bank CD 12/16/24BOK Financial CD 12/19/24Third Coast Bank CD 12/28/24Alliance Bank CD 02/24/25Bank OZK CD 04/20/25Third Coast Bank CD 06/28/25 Totals December 31, 2023 Book Value (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 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,131,014 – – – – – – – – – – – – – – – – – – – – – – – – – 20,474,413 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,093,062 – – – – – – – –– – – – – – – –– – – – – – – –– 10,134,301 – – – – – –– 10,139,261 – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – – – – –– – – – 8,228,224 – – – – – – – – – – – – – – – – – – – – – – – – – 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.1360 Quarterly Financial Report City - Allocation Market Value Investment Total Consolidated Debt Service 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 City - 2021 CO Fac/Equip/ Parks Wells Fargo Bank Cash 20,667$ 20,667$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ Wells Fargo Bank Sweep-MMF 13,333,434 13,333,434 – – – – – – – – – – – – – – Veritex Community Bank MMA 3,481,788 3,481,788 – – – – – – – – – – – – – – NexBank MMA 13,465,784 13,465,784 – – – – – – – – – – – – – – Alliance Bank MMA 2,929 - – – – – – – – – – – – – – – TexPool 34,509,710 34,509,710 – – – – – – – – – – – – – – TexSTAR 252,672,000 33,523,772 37,057,284 1,155,492 1,373 1,144,798 8,692,559 214,823 316,556 447,143 1,787,218 72,383 3,691,934 25,339 728,631 259,303 East West Bank CD 04/16/24 7,188,711 – – – – – – – – – – – – – – – East West Bank CD 04/17/24 5,203,408 – – – – – – – – – – – – – – – Bank OZK CD 04/18/24 10,461,879 – – – – – – – – – – – – – – – East West Bank CD 04/26/24 10,470,344 10,470,344 – – – – – – – – – – – – – – East West Bank CD 05/02/24 20,763,805 – – – – – – – – – – – – – – – Independent Financial CD 05/09/24 8,398,663 8,398,663 – – – – – – – – – – – – – – T-Note 05/15/24 1,987,766 1,987,766 – – – – – – – – – – – – – – East West Bank CD 05/15/24 5,383,155 – – – – – – – – – – – – – – – Bank OZK CD 05/16/24 5,091,993 – – – – – – – – – – – – – – – BOK Financial CD 05/16/24 8,000,000 – – – – – – – – – – – – – – – East West Bank CD 06/11/24 5,159,885 – – – – – – – – – – – – – – – Alliance Bank CD 06/14/24 10,653,597 – – – – – – – – – – – – – – – East West Bank CD 06/17/24 16,122,477 16,122,477 – – – – – – – – – – – – – – Alliance Bank CD 06/27/24 13,956,839 13,956,839 – – – – – – – – – – – – – – Veritex Community Bank CD 07/15/24 10,370,189 10,370,189 – – – – – – – – – – – – – – East West Bank CD 07/16/24 7,185,403 – – – – – – – – – – – – – – – East West Bank CD 07/17/24 5,198,980 – – – – – – – – – – – – – – – East West Bank CD 07/17/24 20,812,342 – – – – – – – – – – – – – – – East West Bank CD 07/22/24 20,520,693 – – – – – – – – – – – – – – – Independent Financial CD 07/24/24 10,456,299 – – – – – – – – – – – – – – – FHLB 07/26/24 9,996,454 – – – – – – – – – – – – – – – East West Bank CD 08/01/24 10,087,332 – – – – – – – – – – – – – – Alliance Bank CD 08/02/24 5,145,648 5,145,648 – – – – – – – – – – – – – – Veritex Community Bank CD 08/05/24 5,163,603 – – – – – – – – – – – – – – – East West Bank CD 08/19/24 5,175,399 5,175,399 – – – – – – – – – – – – – – FFCB 08/21/24 3,993,856 3,993,856 – – – – – – – – – – – – – – Alliance Bank CD 09/06/24 10,279,902 – – – – – – – – – – – – – – – Veritex Community Bank CD 09/11/24 10,280,460 – – – – – – – – – – – – – – – East West Bank CD 09/11/24 4,128,573 – – – – – – – – – – – – – – East West Bank CD 09/18/24 7,014,566 – – – – – – – – – – – – – – Veritex Community Bank CD 09/25/24 10,332,057 10,332,057 – – – – – – – – – – – – – – Alliance Bank CD 09/27/24 10,128,712 – – – – – – – – – – – – – – Alliance Bank CD 10/10/24 7,609,387 7,609,387 – – – – – – – – – – – – – – Veritex Community Bank CD 10/16/24 2,558,211 2,558,211 – – – – – – – – – – – – – – East West Bank CD 10/18/24 10,590,960 – – – – – – – – – – – – – – East West Bank CD 10/28/24 4,195,097 – – – – – – – – – – – – – – Alliance Bank CD 11/01/24 5,144,384 5,144,384 – – – – – – – – – – – – – – Bank OZK CD 11/13/24 10,245,556 10,245,556 – – – – – – – – – – – – – – East West Bank CD 11/20/24 12,070,700 – – – – – – – – – – – – – – Veritex Community Bank CD 12/11/24 20,257,895 20,257,895 – – – – – – – – – – – – – – Alliance Bank CD 12/13/24 10,653,597 – – – – – – – – – – – – – – – T-Note 12/15/24 4,856,104 4,856,104 – – – – – – – – – – – – – – East West Bank CD 12/16/24 10,150,236 10,150,236 – – – – – – – – – – – – – – East West Bank CD 12/18/24 6,389,536 – – – – – – – – – – – – – – BOK Financial CD 12/19/24 10,142,671 10,142,671 – – – – – – – – – – – – – – Third Coast Bank CD 12/28/24 8,343,827 – – – – – – – – – – – – – – – Alliance Bank CD 01/09/25 10,000,000 – – – – – – – – – – – – – – East West Bank CD 01/13/25 10,494,044 – – – – – – – – – – – – – – Veritex Community Bank CD 01/23/25 10,579,239 10,579,239 – – – – – – – – – – – – – – Veritex Community Bank CD 02/12/25 10,039,249 10,039,249 – – – – – – – – – – – – – – Alliance Bank CD 02/24/25 5,143,911 5,143,911 – – – – – – – – – – – – – – BOK Financial CDARS 03/13/25 10,025,172 – – – – – – – – – – – – – – East West Bank CD 03/25/25 8,007,889 8,007,889 – – – – – – – – – – – – – – Bank OZK CD 04/20/25 5,113,065 5,113,065 – – – – – – – – – – – – – – Alliance Bank CD 05/27/25 10,039,890 10,039,890 – – – – – – – – – – – – – – Third Coast Bank CD 06/28/25 10,387,415 10,387,415 – – – – – – – – – – – – – – Alliance Bank CD 07/11/25 5,264,752 5,264,752 – – – – – – – – – – – – – – FHLB 08/13/25 9,968,550 9,968,550 – – – – – – – – – – – – – – FHLMC 12/11/25 9,232,964 9,232,964 – – – – – – – – – – – – – – Totals 850,103,605$ 339,029,761$ 37,057,284$ 1,155,492$ 1,373$ 1,144,798$ 8,692,559$ 214,823$ 316,556$ 447,143$ 1,787,218$ 72,383$ 3,691,934$ 25,339$ 728,631$ 259,303$ March 31, 2024 City of Georgetown Valley View Consulting, L.L.C.1461 Quarterly Financial Report City - Allocation Market Value Wells Fargo Bank CashWells Fargo Bank Sweep-MMFVeritex Community Bank MMANexBank MMAAlliance Bank MMATexPoolTexSTAR East West Bank CD 04/16/24East West Bank CD 04/17/24Bank OZK CD 04/18/24East West Bank CD 04/26/24East West Bank CD 05/02/24Independent Financial CD 05/09/24T-Note 05/15/24East West Bank CD 05/15/24Bank OZK CD 05/16/24BOK Financial CD 05/16/24East West Bank CD 06/11/24Alliance Bank CD 06/14/24East West Bank CD 06/17/24Alliance Bank CD 06/27/24Veritex Community Bank CD 07/15/24East West Bank CD 07/16/24East West Bank CD 07/17/24East West Bank CD 07/17/24East West Bank CD 07/22/24Independent Financial CD 07/24/24FHLB07/26/24East West Bank CD 08/01/24Alliance Bank CD 08/02/24Veritex Community Bank CD 08/05/24East West Bank CD 08/19/24FFCB08/21/24Alliance Bank CD 09/06/24Veritex Community Bank CD 09/11/24East West Bank CD 09/11/24East West Bank CD 09/18/24Veritex Community Bank CD 09/25/24Alliance Bank CD 09/27/24Alliance Bank CD 10/10/24Veritex Community Bank CD 10/16/24East West Bank CD 10/18/24East West Bank CD 10/28/24Alliance Bank CD 11/01/24Bank OZK CD 11/13/24East West Bank CD 11/20/24Veritex Community Bank CD 12/11/24Alliance Bank CD 12/13/24T-Note 12/15/24East West Bank CD 12/16/24East West Bank CD 12/18/24BOK Financial CD 12/19/24Third Coast Bank CD 12/28/24Alliance Bank CD 01/09/25East West Bank CD 01/13/25Veritex Community Bank CD 01/23/25Veritex Community Bank CD 02/12/25Alliance Bank CD 02/24/25BOK Financial CDARS 03/13/25East West Bank CD 03/25/25Bank OZK CD 04/20/25Alliance Bank CD 05/27/25Third Coast Bank CD 06/28/25Alliance Bank CD 07/11/25FHLB08/13/25FHLMC12/11/25 Totals March 31, 2024 (Continued) City - 2021 GO Parks City - 2021 GO Roads City - 2021 CO Solid Waste 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 Revenue Electric City - 2022 Revenue Water/WW City - 2023 CO Fac/Equip/Parks City - 2023 CO Solid Waste –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,929 – – – – – – – – – – – – – – 5,575 2,086,978 11,450 170,295 4,561,418 5,562,171 540,370 2,450,470 105,193 140,980 8,913,926 1,635,200 16,902,560 8,757,470 4,194,665 – – – – – – – – – 7,188,711 – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,461,879 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,383,155 – – – – – – – – – – – – 5,091,993 – – – – – – – – – – – – – – – – – – – 8,000,000 – – – – – – – – – – – – – 5,159,885 – – – – – – – – – – – 10,653,597 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 7,185,403 – – – – – – – – – – – – – – – 5,198,980 – – – – – – – – – – – – – – – – – – – – – – – 20,520,693 – – – – – – – – – – – – 10,456,299 – – – – – – – – – – – – 9,996,454 – – – – – – – – – – – – 10,087,332 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 7,014,566 – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,128,712 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,590,960 – – – – – – – – – – 4,195,097 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 12,070,700 – – – – – – – – – – – – – – – – – – – – – – – – – 10,653,597 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,389,536 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – – – – – – – – – 10,494,044 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,025,172 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,575$ 2,086,978$ 11,450$ 170,295$ 4,561,418$ 16,037,319$ 540,370$ 2,450,470$ 105,193$ 140,980$ 40,887,240$ 1,635,200$ 171,044,928$ 19,116,335$ 4,194,665$ City of Georgetown Valley View Consulting, L.L.C.1562 Quarterly Financial Report City - Allocation Market Value Wells Fargo Bank CashWells Fargo Bank Sweep-MMFVeritex Community Bank MMANexBank MMAAlliance Bank MMATexPoolTexSTAR East West Bank CD 04/16/24East West Bank CD 04/17/24Bank OZK CD 04/18/24East West Bank CD 04/26/24East West Bank CD 05/02/24Independent Financial CD 05/09/24T-Note 05/15/24East West Bank CD 05/15/24Bank OZK CD 05/16/24BOK Financial CD 05/16/24East West Bank CD 06/11/24Alliance Bank CD 06/14/24East West Bank CD 06/17/24Alliance Bank CD 06/27/24Veritex Community Bank CD 07/15/24East West Bank CD 07/16/24East West Bank CD 07/17/24East West Bank CD 07/17/24East West Bank CD 07/22/24Independent Financial CD 07/24/24FHLB07/26/24East West Bank CD 08/01/24Alliance Bank CD 08/02/24Veritex Community Bank CD 08/05/24East West Bank CD 08/19/24FFCB08/21/24Alliance Bank CD 09/06/24Veritex Community Bank CD 09/11/24East West Bank CD 09/11/24East West Bank CD 09/18/24Veritex Community Bank CD 09/25/24Alliance Bank CD 09/27/24Alliance Bank CD 10/10/24Veritex Community Bank CD 10/16/24East West Bank CD 10/18/24East West Bank CD 10/28/24Alliance Bank CD 11/01/24Bank OZK CD 11/13/24East West Bank CD 11/20/24Veritex Community Bank CD 12/11/24Alliance Bank CD 12/13/24T-Note 12/15/24East West Bank CD 12/16/24East West Bank CD 12/18/24BOK Financial CD 12/19/24Third Coast Bank CD 12/28/24Alliance Bank CD 01/09/25East West Bank CD 01/13/25Veritex Community Bank CD 01/23/25Veritex Community Bank CD 02/12/25Alliance Bank CD 02/24/25BOK Financial CDARS 03/13/25East West Bank CD 03/25/25Bank OZK CD 04/20/25Alliance Bank CD 05/27/25Third Coast Bank CD 06/28/25Alliance Bank CD 07/11/25FHLB08/13/25FHLMC12/11/25 Totals March 31, 2024 (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 –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 29,988 2,757,688 15,787,319 4,171,452 28,638,289 8,483,650 32,201,150 12,367,034 3,078,102 – – – – – – – – – – – 5,203,408 – – – – – – – – – – – – – – – – – – – – – – – – – – – – 20,763,805 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 20,812,342 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,163,603 – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,279,902 – – – – – – – – 10,280,460 – – – – – – – 4,128,573 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,343,827 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 29,988$ 2,757,688$ 26,154,330$ 8,300,026$ 90,774,798$ 8,483,650$ 32,201,150$ 20,710,860$ 3,078,102$ City of Georgetown Valley View Consulting, L.L.C.1663 Quarterly Financial Report City - Allocation Market Value 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 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 – – – – – – – – – – – – – – 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 – – – – – – – – – – – – – – Third Coast Bank CD 12/28/24 8,228,224 – – – – – – – – – – – – – – – 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.1764 Quarterly Financial Report City - Allocation Market Value Wells Fargo Bank CashWells Fargo Bank Sweep-MMFVeritex Community Bank MMANexBank MMATexPoolTexSTAR Bank OZK CD 01/02/24Alliance Bank CD 01/12/24East West Bank CD 01/12/24East West Bank CD 01/17/24East West Bank CD 01/18/24Veritex Community Bank CD 01/23/24East West Bank CD 01/26/24East West Bank CD 02/01/24Southside Bank CD 02/02/24East West Bank CD 02/02/24East West Bank CD 02/15/24Independent Financial CD 02/15/24FHLB02/28/24East West Bank CD 03/11/24East West Bank CD 03/11/24East West Bank CD 03/18/24BOK Financial CD 03/23/24East West Bank CD 04/16/24East West Bank CD 04/17/24Bank OZK CD 04/18/24East West Bank CD 04/26/24East West Bank CD 05/02/24Independent Financial CD 05/09/24T-Note 05/15/24East West Bank CD 05/15/24Bank OZK CD 05/16/24BOK Financial CD 05/16/24East West Bank CD 06/11/24Alliance Bank CD 06/14/24East West Bank CD 06/17/24Alliance Bank CD 06/27/24Veritex Community Bank CD 07/15/24East West Bank CD 07/16/24East West Bank CD 07/17/24East West Bank CD 07/22/24Independent Financial CD 07/24/24FHLB07/26/24Alliance Bank CD 08/02/24Veritex Community Bank CD 08/05/24East West Bank CD 08/19/24FFCB08/21/24Alliance Bank CD 09/06/24Veritex Community Bank CD 09/11/24Veritex Community Bank CD 09/25/24Alliance Bank CD 10/10/24Veritex Community Bank CD 10/16/24Alliance Bank CD 11/01/24Bank OZK CD 11/13/24Veritex Community Bank CD 12/11/24Alliance Bank CD 12/13/24T-Note 12/15/24East West Bank CD 12/16/24BOK Financial CD 12/19/24Third Coast Bank CD 12/28/24Alliance Bank CD 02/24/25Bank OZK CD 04/20/25Third 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 Revenue Electric City - 2022 Revenue 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.1865 Quarterly Financial Report City - Allocation Market Value Wells Fargo Bank CashWells Fargo Bank Sweep-MMFVeritex Community Bank MMANexBank MMATexPoolTexSTAR Bank OZK CD 01/02/24Alliance Bank CD 01/12/24East West Bank CD 01/12/24East West Bank CD 01/17/24East West Bank CD 01/18/24Veritex Community Bank CD 01/23/24East West Bank CD 01/26/24East West Bank CD 02/01/24Southside Bank CD 02/02/24East West Bank CD 02/02/24East West Bank CD 02/15/24Independent Financial CD 02/15/24FHLB02/28/24East West Bank CD 03/11/24East West Bank CD 03/11/24East West Bank CD 03/18/24BOK Financial CD 03/23/24East West Bank CD 04/16/24East West Bank CD 04/17/24Bank OZK CD 04/18/24East West Bank CD 04/26/24East West Bank CD 05/02/24Independent Financial CD 05/09/24T-Note 05/15/24East West Bank CD 05/15/24Bank OZK CD 05/16/24BOK Financial CD 05/16/24East West Bank CD 06/11/24Alliance Bank CD 06/14/24East West Bank CD 06/17/24Alliance Bank CD 06/27/24Veritex Community Bank CD 07/15/24East West Bank CD 07/16/24East West Bank CD 07/17/24East West Bank CD 07/22/24Independent Financial CD 07/24/24FHLB07/26/24Alliance Bank CD 08/02/24Veritex Community Bank CD 08/05/24East West Bank CD 08/19/24FFCB08/21/24Alliance Bank CD 09/06/24Veritex Community Bank CD 09/11/24Veritex Community Bank CD 09/25/24Alliance Bank CD 10/10/24Veritex Community Bank CD 10/16/24Alliance Bank CD 11/01/24Bank OZK CD 11/13/24Veritex Community Bank CD 12/11/24Alliance Bank CD 12/13/24T-Note 12/15/24East West Bank CD 12/16/24BOK Financial CD 12/19/24Third Coast Bank CD 12/28/24Alliance Bank CD 02/24/25Bank OZK CD 04/20/25Third 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 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,131,014 – – – – – – – – – – – – – – – – – – – – – – – – – 20,474,413 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,093,062 – – – – – – – – – – – – – – – – – – – – – – – – – 10,134,301 – – – – – – – 10,139,261 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,228,224 – – – – – – – – – – – – – – – – – – – – – – – – – 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.1966 Quarterly Financial Report Georgetown Economic Development Corporation (GEDCO) QUARTERLY INVESTMENT REPORT For the Quarter Ended March 31, 2024 Prepared by Valley View Consulting, L.L.C. The investment portfolio of the Georgetown Economic Development Corporation (GEDCO) is in compliance with the Texas Public Funds Investment Act and the Investment Policy and Strategies. Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total return yields and do not account for investment advisor fees.67 Quarterly Financial Report Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield MMA 2,278,303$ 2,278,303$ 2,308,717$ 2,308,717$ 5.33% Pools 6,180,552 6,180,552 6,845,707 6,845,707 5.30% CDs/Securities 2,551,995 2,551,995 2,588,140 2,588,140 5.57% 11,010,850$ 11,010,850$ 11,742,564$ 11,742,564$ 5.37% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 5.37%Total Portfolio 5.43% Rolling Three Month Treasury 5.46%Rolling Three Month Treasury 5.49% Rolling Six Month Treasury 5.37%Rolling Six Month Treasury 5.43% TexPool 5.32%TexPool 5.34% Interest income provided in separate report. December 31, 2023 (1)Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank, pool, and money market balances. (2)Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. March 31, 2024 Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.168 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%04/01/24 03/31/24 2,308,717$ 2,308,717$ 1.00 2,308,717$ 1 5.33% TexasDAILY AAAm 5.31%04/01/24 03/31/24 2,302,030 2,302,030 1.00 2,302,030 1 5.31% TexSTAR AAAm 5.30%04/01/24 03/31/24 4,543,677 4,543,677 1.00 4,543,677 1 5.30% East West Bank CD 5.42%08/06/24 02/26/24 2,588,140 2,588,140 1.00 2,588,140 128 5.57% 11,742,564$ 11,742,564$ 11,742,564$ 29 5.37% (1)(2) March 31, 2024 (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.370 Quarterly Financial Report Georgetown Transportation Enhancement Corporation (GTEC) QUARTERLY INVESTMENT REPORT For the Quarter Ended March 31, 2024 Prepared by Valley View Consulting, L.L.C. The investment portfolio of the Georgetown Transportation Enhancement Corporation (GTEC) is in compliance with the Texas Public Funds Investment Act and the Investment Policy and Strategies. Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective of current liquidation values. Yield calculations are not determined using standard performance formulas,are not representative of total return yields and do not account for investment advisor fees.73 Quarterly Financial Report Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield Pools/MMAs 18,589,898$ 18,589,898$ 14,517,289$ 14,517,289$ 5.32% CDs/Securities 18,449,935 18,449,935 23,653,409 23,653,409 5.55%Totals 37,039,833$ 37,039,833$ 38,170,698$ 38,170,698$ 5.46% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 5.46%Total Portfolio 5.47% Rolling Three Month Treasury 5.46%Rolling Three Month Treasury 5.49% Rolling Six Month Treasury 5.37%Rolling Six Month Treasury 5.43% TexPool 5.32%TexPool 5.34% Interest data provided in separate report. December 31, 2023 (1)Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank, pool, and money market balances. (2)Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. March 31, 2024 Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.174 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.32%04/01/24 03/31/24 9,361,751$ 9,361,751$ 1.00 9,361,751$ 1 5.32% TexSTAR AAAm 5.30%04/01/24 03/31/24 2,242,400 2,242,400 1.00 2,242,400 1 5.30% Veritex Bank MMA 5.33%04/01/24 03/31/24 2,913,138 2,913,138 1.00 2,913,138 1 5.33% East West Bank CD 5.22%05/28/24 05/25/23 3,213,104 3,213,104 100.00 3,213,104 58 5.36% Alliance Bank CD 5.80%08/23/24 08/23/23 8,234,327 8,234,327 100.00 8,234,327 145 5.93% East West Bank CD 5.13%11/12/24 02/12/24 7,048,371 7,048,371 100.00 7,048,371 226 5.26% Veritex Community Bank CD 5.33%02/18/25 08/17/23 5,157,608 5,157,608 100.00 5,157,608 324 5.46% TOTALS 38,170,698$ 38,170,698$ 38,170,698$ 122 5.46% (1)(2) March 31, 2024 (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.376 Quarterly Financial Report GTEC - Allocation Investment Total GTEC 2016 CO GTEC 2017 CO GTEC Veritex Community Bank MMA 2,913,138$ 2,913,138$ –$ –$ TexPool 9,361,751 9,361,751 – – TexSTAR 2,242,400 2,126,262 1,634 114,505 East West Bank CD 05/28/24 3,213,104 3,213,104 – – Alliance Bank CD 08/23/24 8,234,327 8,234,327 – – East West Bank CD 11/12/24 7,048,371 7,048,371 – – Veritex Community Bank CD 02/18/25 5,157,608 5,157,608 – – Totals 38,170,698$ 38,054,559$ 1,634$ 114,505$ December 31, 2023 Investment Total GTEC 2016 CO GTEC 2017 CO GTEC Veritex Community Bank MMA 2,874,767$ 2,874,767$ –$ –$ TexPool 13,409,760 13,409,760 – – TexSTAR 2,305,371 1,319,530 833,714 152,127 East West Bank CD 02/09/24 2,073,018 2,073,018 – – Alliance Bank CD 05/28/24 3,171,561 3,171,561 – – East West Bank CD 08/23/24 8,115,682 8,115,682 – – Veritex Community Bank CD 02/18/25 5,089,674 5,089,674 – – Totals 37,039,833$ 36,053,992$ 833,714$ 152,127$ March 31, 2024 Book & Market Value Book & Market Value City of Georgetown Valley View Consulting, L.L.C.679 Quarterly Financial Report Department Federal Grantor Pass-Through Agency Identifying Number COG Name/Purpose YTD Expenditures YTD Revenue Recognized Airport N/A Texas Department of Transportation-Aviation M2314GEOR RAMP Grant - Routine Airport Maintenance Program - - Airport Federal Aviation Administration Texas Department of Transportation 2314GRGTN Airport Pavement Project - - Arts & Culture Texas Commission on the Arts FY23 Performance Grant - Guy Forsyth 2,250 2,250 Arts & Culture Texas Commission on the Arts FY24 Arts Create Grant 5,357 7,000 Emergency Management US Dept. of the Treasury American Rescue Plan Act SLFRF Funding - - Library N/A St. David's Foundation St. David's Grant - 15,746 - Planning US Department of Housing & Urban Development Williamson County CDBG 21st St Infrastructure - 3,176 Planning US Department of Housing & Urban Development Williamson County CDBG Home Repair (FY21) 33,161 33,161 Police US. Department of Justice N/A TX2460200 Equitable Sharing Agreement - 20,067 Police US. Department of Treasury N/A TX2460200 Equitable Sharing Agreement - 2,231 Division Grantor COG Name/Purpose Status Public Works/Electric/City- Wide Federal Emergency Management Administration Texas Division of Emergency Management DR-4705-TX Winter Storm Mara Projects are in progress as of 3/31/23; Damage Inventory Report provided to FEMA as of 9/30; submissions to FEMA completed as of 2/6/24 and pending FEMA approval Systems Engineering US Dept of Housing and Urban Development FM 971 Improvements Council approved; In process of completing paperwork and sending back to HUD Library N/A Texas State Library and Archives Commission Special Projects 75 2025 - GLPXpress Service Council approved; application sent to TSLAC, awaiting notice of award Airport Federal Aviation Administration Bipartisan Infrastructure Law; Airport Terminal and Tower Project Council approved; application sent to FAA, awaiting notice of award Reviewed By: Elaine Wilson CITY OF GEORGETOWN Grant/Federal Funding Reportas of March 31, 2024 Active Applications Pending Award 80