Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
FY 23 - 3rd_Qtr_Report_FY2023_Redacted
FINANCIAL REPORT AND INVESTMENT REPORT For the Quarter Ended June 30, 2023 Table of Contents General Fund Narrative .............................................................................................................................. 1-8 General Fund Schedule ................................................................................................................................. 9 General Fund by Cost Center ................................................................................................................. 10-13 Electric Fund Narrative ........................................................................................................................... 14-18 Electric Fund Schedule ................................................................................................................................ 19 Water Services Fund Narrative ............................................................................................................... 20-24 Water Services Fund Schedule .................................................................................................................... 25 Convention & Visitors Bureau Narrative................................................................................................. 26-27 Convention & Visitors Bureau Fund Schedule ............................................................................................. 28 Airport Fund Narrative ........................................................................................................................... 29-31 Airport Fund Schedule ................................................................................................................................. 32 Georgetown Transportation Enhancement Corporation Fund Narrative ............................................... 33-35 Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 36 Georgetown Economic Development Corporation Fund Narrative ....................................................... 37-39 Georgetown Economic Development Corporation Fund Schedule ............................................................. 40 Council Discretionary Fund Schedule .......................................................................................................... 41 Joint Services Fund Schedule ....................................................................................................................... 42 Stormwater Narrative ............................................................................................................................. 43-45 Stormwater Fund Schedule ......................................................................................................................... 46 Village PID Services Narrative ...................................................................................................................... 47 Village PID Services Fund Schedule ............................................................................................................. 48 Investment Report.................................................................................................................................. 49-51 Quarterly Investment Report - City ........................................................................................................ 52-73 Quarterly Investment Report - GEDCO ................................................................................................... 74-79 Quarterly Investment Report - GTEC ...................................................................................................... 80-85 Grant Applications ....................................................................................................................................... 86 Capital Improvement Projects ................................................................................................................ 87-91 Quarterly Financial Report POLICE OPERATIONS DIVISION: Police Operations saw personnel and operational expenditures through the quarter total $13,594,941, or 70.13% of budget. Police Administration expenditures through the quarter resulted in $2,037,145, or 67.79% of budget. FIRE AND EMS DIVISION: Year-to-date personnel and operational expenditures through the quarter total $3,990,644, or 81.23% of budget for Fire Support Services/Administration, $14,147,045, or 70.74% of budget for Fire Emergency Services, and $2,942,387, or 79.30% of budget for Fire EMS. ADMINISTRATIVE SERVICES DIVISION: Administrative Services saw operational and personnel costs totaling $1,856,689, or 60.48% of budget year-to-date. The cost center includes one-time funding for consulting, continuation of a “311 like” system, and studies that were not completed in FY2022. City Secretary personnel and operational expenditures for the quarter totals $1,057,075, which represents 68.36% of budget. Year-to-date personnel and operational expenditures for Communications totals $917,222, which represents 61.35% of budget. Non-Departmental includes a budget of $1,590,765 for transfers out to various funds. As of the third quarter, 82.82% of anticipated transfer expenses have been made. General Government Contracts includes budgeted vacancy savings estimates for all General Fund departments. Real vacancy savings is realized in each cost center. The budgeted vacancy factor against year-to-date actuals in the administrative division cost center drives the percent of budget up. Additionally, this is where the City budgets for various approved economic development related incentives. LIBRARY, TOURISM, AND ARTS AND CULTURE DIVISION: Arts and Culture recognized year to date expenses totaling $267,944, or 59.48% of budget. Lower than anticipated expenditures are tied to pausing on two Special Events and Marketing positions because of revenue uncertainty. As of the 2nd quarter, one position has been filled. Library year-to- date expenses total $2,474,252, or 66.39% of budget. PARKS AND RECREATION DIVISION: Year-to-date personnel and operations costs for Parks and Recreation within the following cost centers: Parks Administrations, Parks, Garey Park, Tennis Center, Recreation and, comes to a total of $7,415,297, or 65.12% of budget. Parks year-to-date through the quarter totals $2,143,472, or 60.43% of budget. Recreation total expenses are $3,606,851, which is 68.13% of budget. Garey Park year-to-date is $784,747, or 64.75% of budget. Personnel expenses in recreation are heavily seasonal, and a significant portion of part- time and temporary salaries will be reflected in the fourth quarter. 6 treasury/agency securities. Rates on securities have helped the city diversify the portfolio compared to the prior year’s holdings. CITY Market Value GTEC GEDCO 3/31/23 6/30/23 3/31/23 6/30/23 3/31/23 6/30/23 Total cash and investments $745,988,174 $899,378,504 $46,188,271 $45,694,863 $10,229,468 $10,880,626 Quarter End Average Yield 4.35% 4.86% 4.58% 5.06% 4.67% 5.11% The City’s strategy continues to be matching maturities with cash flow needs, while focusing on the investment policy’s long-range goals. The City’s investment strategy is to “ladder” or stagger maturities, thus minimizing erratic interest rate fluctuations. The City is continuing to manage the yield on bond proceeds for arbitrage purposes. HDR Engineering was hired to manage and expedite the completion of bond funded capital projects. Finance staff also assisted Economic Development staff with an updated cash flow model for GEDCO to manage incentive agreement payments and potential new projects. 50 The City’s investment portfolio generally includes bank deposits, local government investment pool balances, money market accounts, financial institution deposits (CD’s), and securities/agencies. All of these investments meet the safety requirements of the PFIA. Local Government Investment Pools must maintain a rating of AAAm, Securities (Treasury Bills) must have direct or implied backing of the Federal Government and Financial Institution Deposits (CDs and money market accounts) must be collateralized with FDIC insurance or obligations with an implied backing from the Federal Government. The collateral on all City investments are monitored monthly to ensure the financial institutions carry minimum collateral of 100% with a letter of credit or 102% with pledged securities for all of the City’s investments. All securities held by financial institutions as collateral on behalf of the City have been reviewed and met PFIA-minimum rating criteria. III. CAPITAL IMPROVEMENT PROJECTS A financial summary of capital improvement projects is attached to this report. This report provides a Life-to-Date picture of all active projects since many capital projects take multiple fiscal years to construct to completion. With our growing capital infrastructure implementation portfolio due to demand for transportation and water services, City staff are improving work capacity and efficiencies, and ultimately customer service, related to capital projects. The focus is on incrementally improving capital project reporting internally and externally citywide – including financial information as well as scheduling, geographic location, and other information. Staff are exploring functionality in ClearGov, the new digital budget book platform, as a tool to improve capital project reporting. A Communications and Public Engagement staff person has also been re-organized to focus on capital project status updates. For the FY2023 Budget, staff were added to the Water, Public Works, and Engineering departments to assist with the workload of the capital improvement plan. Additionally, Council agreed to implement a hybrid approach to capital project management, and to hire contracted staff to manage transportation and facilities projects over the next 3 or more years. 51 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield Demand Accounts 800,704$ 800,704 845,947$ 845,947$ 0.00% NOW/MMA 28,655,293 28,655,293 34,000,681 34,000,681 5.06% Pools 281,150,859 281,150,859 438,124,654 438,124,654 5.07% CDs/Securities 435,275,491 435,381,317 426,611,729 426,407,221 4.64% Totals 745,882,348$ 745,988,174$ 899,583,011$ 899,378,504$ 4.86% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 4.86%Total Portfolio 4.19% Rolling Three Month Treasury 5.28%Rolling Three Month Treasury 4.75% Rolling Six Month Treasury 5.08%Rolling Six Month Treasury 4.57% TexPool 5.05%TexPool 4.55% Bank Fees Offset 2,517$ Interest earnings provided in separate report.5,680$ March 31, 2023 (1)Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank, pool, and money market balances. (2)Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. Quarterly Bank Fees Offset Year-to-date Bank Fees Offset June 30, 2023 City of Georgetown Valley View Consulting, L.L.C.53 City - Investment Holdings Coupon/Maturity Settlement Face Amount/Book Market Market Life Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield JPMorgan Chase Cash (3)0.00%07/01/23 06/30/23 618,137$ 618,137$ 1.00 618,137$ 1 0.00% JPMorgan Chase MMA 1.60%07/01/23 06/30/23 438,323 438,323 1.00 438,323 1 1.60% Wells Fargo Bank Cash 0.00%07/01/23 06/30/23 227,810 227,810 1.00 227,810 1 0.00% Wells Fargo Bank Sweep-MMF 4.95%07/01/23 06/30/23 17,302,185 17,302,185 1.00 17,302,185 1 4.95% Veritex Community Bank MMA 5.20%07/01/23 06/30/23 3,345,666 3,345,666 1.00 3,345,666 1 5.20% NexBank MMA 5.30%07/01/23 06/30/23 12,914,507 12,914,507 1.00 12,914,507 1 5.30% TexPool AAAm 5.05%07/01/23 06/30/23 40,801,750 40,801,750 1.00 40,801,750 1 5.05% TexSTAR AAAm 5.08%07/01/23 06/30/23 397,322,905 397,322,905 1.00 397,322,905 1 5.08% Alliance Bank CD 3.10%07/01/23 07/01/22 4,093,809 4,093,809 100.00 4,093,809 1 3.14% FHLB Aaa/AA+0.00%07/31/23 10/17/22 5,000,000 4,981,422 99.62 4,981,247 31 4.47% East West Bank CD 3.05%08/01/23 08/01/22 2,062,706 2,062,706 100.00 2,062,706 32 3.10% Alliance Bank CD 3.15%08/02/23 08/02/22 1,023,746 1,023,746 100.00 1,023,746 33 3.19% Bank OZK CD 0.21%08/14/23 11/12/21 5,016,704 5,016,704 100.00 5,016,704 45 0.21% East West Bank CD 4.56%08/15/23 11/15/22 5,166,090 5,166,090 100.00 5,166,090 46 4.67% East West Bank CD 5.02%08/15/23 02/15/23 4,145,390 4,145,390 100.00 4,145,390 46 5.15% Texas Capital Bank CD 3.30%08/24/23 08/24/22 2,569,662 2,569,662 100.00 2,569,662 55 3.30% FHLB Aaa/AA+3.63%09/13/23 09/13/22 13,350,000 13,347,723 99.61 13,295,077 75 3.71% FFCB Aaa/AA+0.22%09/22/23 09/13/22 925,000 917,711 99.64 914,394 84 3.74% Veritex Community Bank CD 0.25%09/25/23 09/24/21 10,043,790 10,043,790 100.00 10,043,790 87 0.25% Bank OZK CD 4.93%09/30/23 03/30/23 25,312,574 25,312,574 100.00 25,312,574 92 5.05% Bank OZK CD 0.20%10/09/23 10/08/21 5,016,767 5,016,767 100.00 5,016,767 101 0.20% East West Bank CD 5.18%10/12/23 04/12/23 13,777,849 13,777,849 100.00 13,777,849 104 5.32% FHLB Aaa/AA+0.00%10/13/23 10/17/22 2,500,000 2,468,208 98.60 2,465,046 105 4.56% East West Bank CD 4.76%10/18/23 01/18/23 10,216,163 10,216,163 100.00 10,216,163 110 4.87% East West Bank CD 4.53%10/19/23 10/19/22 2,580,380 2,580,380 100.00 2,580,380 111 4.63% FHLB Aaa/AA+5.17%10/24/23 02/27/23 10,000,000 9,840,822 99.73 9,845,225 116 5.17% Bank OZK CD 0.30%11/13/23 11/12/21 10,047,690 10,047,690 100.00 10,047,690 136 0.30% East West Bank CD 5.33%11/13/23 05/10/23 3,104,697 3,104,697 100.00 3,104,697 136 5.47% East West Bank CD 5.33%11/15/23 05/15/23 5,148,542 5,148,542 100.00 5,148,542 138 5.47% FAMCA 4.75%11/22/23 11/22/22 2,000,000 2,000,000 99.73 1,994,665 145 4.75% East West Bank CD 5.29%12/11/23 03/09/23 9,149,924 9,149,924 100.00 9,149,924 164 5.43% FAMCA 4.95%12/13/23 12/13/22 10,000,000 10,000,000 99.62 9,962,084 166 4.95% East West Bank CD 5.59%12/20/23 06/22/22 2,581,244 2,581,244 100.00 2,581,244 173 2.98% Alliance Bank CD 5.10%12/27/23 12/27/22 1,025,592 1,025,592 100.00 1,025,592 180 5.20% Bank OZK CD 4.93%12/30/23 03/30/23 26,325,077 26,325,077 100.00 26,325,077 183 5.05% Alliance Bank CD 5.15%01/12/24 01/13/23 5,063,493 5,063,493 100.00 5,063,493 196 5.25% June 30, 2023 City of Georgetown Valley View Consulting, L.L.C.55 City - Investment Holdings Coupon/Maturity Settlement Face Amount/Book Market Market Life Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield June 30, 2023 East West Bank CD 4.99%01/12/24 04/12/23 10,109,963 10,109,963 100.00 10,109,963 196 5.12% East West Bank CD 4.71%01/18/24 01/18/23 10,213,869 10,213,869 100.00 10,213,869 202 4.82% Veritex Community Bank CD 4.84%01/23/24 01/23/23 10,201,840 10,201,840 100.00 10,201,840 207 4.95% East West Bank CD 5.09%01/26/24 04/26/23 4,036,983 4,036,983 100.00 4,036,983 210 5.22% Southside Bank CD 3.32%02/02/24 08/02/22 10,250,379 10,250,379 100.00 10,250,379 217 3.32% Independent Financial CD 5.15%02/15/24 05/15/23 12,050,795 12,050,795 100.00 12,050,795 230 5.27% FHLB Aaa/AA+5.35%02/28/24 03/06/23 20,000,000 20,000,000 99.92 19,983,180 243 5.35% East West Bank CD 5.24%03/11/24 03/09/23 10,164,995 10,164,995 100.00 10,164,995 255 5.38% BOK Financial CD 4.88%03/23/24 02/22/23 8,107,655 8,107,655 100.00 8,107,655 267 5.00% Third Coast Bank CD 5.65%03/28/24 06/28/23 8,000,000 8,000,000 100.00 8,000,000 272 5.77% Bank OZK CD 4.92%04/18/24 04/18/23 10,082,558 10,082,558 100.00 10,082,558 293 5.04% East West Bank CD 4.92%04/26/24 04/26/23 10,089,355 10,089,355 100.00 10,089,355 301 5.04% Independent Financial CD 4.99%05/09/24 02/09/23 8,089,683 8,089,683 100.00 8,089,683 314 5.08% T-Note Aaa/AA+0.25%05/15/24 11/22/22 2,000,000 1,925,053 95.63 1,912,656 320 4.72% BOK Financial CD 5.10%05/16/24 05/18/23 8,000,000 8,000,000 100.00 8,000,000 321 5.23% Alliance Bank CD 5.10%06/14/24 12/15/22 10,255,918 10,255,918 100.00 10,255,918 350 5.20% East West Bank CD 5.32%06/17/24 06/16/23 15,489,078 15,489,078 100.00 15,489,078 353 5.46% Alliance Bank CD 5.10%06/27/24 12/27/22 13,435,856 13,435,856 100.00 13,435,856 363 5.20% Independent Financial CD 4.50%07/24/24 01/23/23 10,109,726 10,109,726 100.00 10,109,726 390 4.58% FHLB Aaa/AA+5.18%07/26/24 02/28/23 10,000,000 10,000,000 99.63 9,962,974 392 5.18% FFCB Aaa/AA+4.88%08/21/24 02/27/23 4,000,000 3,986,073 99.23 3,969,138 418 5.19% Alliance Bank CD 5.10%12/13/24 12/15/22 10,255,918 10,255,918 100.00 10,255,918 532 5.20% T-Note Aaa/AA+1.00%12/15/24 06/14/23 5,000,000 4,728,259 94.10 4,705,078 534 4.91% Third Coast Bank CD 5.10%06/28/25 06/28/23 10,000,000 10,000,000 100.00 10,000,000 729 5.20% TOTALS 900,162,740$ 899,583,011$ 899,378,504$ 108 4.86% (1)(2) (2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds. (1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity. (3) Earnings Credit - The City's depository accounts provide an earnings credit on balances which is used to offset bank fees. City of Georgetown Valley View Consulting, L.L.C.56 City - Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 03/31/23 Increases Decreases Book Value 06/30/23 Market Value 03/31/23 Change in Market Value Market Value 06/30/23 JPMorgan Chase Cash 0.00%07/01/23 758,592$ –$ (140,455)$ 618,137$ 758,592$ (140,455)$ 618,137$ JPMorgan Chase MMA 1.60%07/01/23 436,688 1,635 – 438,323 436,688 1,635 438,323 Wells Fargo Bank Cash 0.00%07/01/23 42,112 185,698 – 227,810 42,112 185,698 227,810 Wells Fargo Bank Sweep-MMF 4.95%07/01/23 12,164,479 5,137,706 – 17,302,185 12,164,479 5,137,706 17,302,185 Veritex Community Bank MMA 5.20%07/01/23 3,304,419 41,248 – 3,345,666 3,304,419 41,248 3,345,666 NexBank MMA 5.30%07/01/23 12,749,708 164,799 – 12,914,507 12,749,708 164,799 12,914,507 TexPool 5.05%07/01/23 30,752,271 10,049,478 – 40,801,750 30,752,271 10,049,478 40,801,750 TexSTAR 5.08%07/01/23 250,398,587 146,924,318 – 397,322,905 250,398,587 146,924,318 397,322,905 East West Bank CD 4.16%04/12/23 13,605,580 – (13,605,580) – 13,605,580 (13,605,580) – East West Bank CD 4.16%4/12/2023 20,385,946 – (20,385,946) – 20,385,946 (20,385,946) – Prosperity Bank CD 0.20%4/24/2023 5,019,186 – (5,019,186) – 5,019,186 (5,019,186) – Prosperity Bank CD 0.20%5/1/2023 5,018,361 – (5,018,361) – 5,018,361 (5,018,361) – Alliance Bank CD 2.98%5/2/2023 4,059,706 – (4,059,706) – 4,059,706 (4,059,706) – Texas Capital Bank CD 2.90%5/4/2023 1,271,232 – (1,271,232) – 1,271,232 (1,271,232) – East West Bank CD 3.27%5/10/2023 3,070,630 – (3,070,630) – 3,070,630 (3,070,630) – FHLB 4.60%5/10/2023 23,880,000 – (23,880,000) – 23,887,843 (23,887,843) – East West Bank CD 4.62%5/15/2023 5,085,546 – (5,085,546) – 5,085,546 (5,085,546) – Bank OZK CD 0.20%6/12/2023 5,028,894 – (5,028,894) – 5,028,894 (5,028,894) – East West Bank CD 3.04%6/16/2023 15,359,336 – (15,359,336) – 15,359,336 (15,359,336) – Texas Capital Bank CD 3.42%6/16/2023 5,085,517 – (5,085,517) – 5,085,517 (5,085,517) – Alliance Bank CD 5.20%6/27/2023 8,100,603 – (8,100,603) – 8,100,603 (8,100,603) – FHLB 3.97%6/29/2023 9,903,875 – (9,903,875) – 9,887,246 (9,887,246) – R Bank CD 0.73%6/30/2023 1,012,842 – (1,012,842) – 1,012,842 (1,012,842) – Alliance Bank CD 3.14%07/01/23 4,093,809 – –4,093,809 4,093,809 – 4,093,809 FHLB 4.47%07/31/23 4,926,885 54,537 – 4,981,422 4,922,799 58,448 4,981,247 East West Bank CD 3.10%08/01/23 2,047,081 15,625 – 2,062,706 2,047,081 15,625 2,062,706 Alliance Bank CD 3.19%08/02/23 1,015,942 7,803 – 1,023,746 1,015,942 7,803 1,023,746 Bank OZK CD 0.21%08/14/23 5,014,037 2,667 – 5,016,704 5,014,037 2,667 5,016,704 East West Bank CD 4.67%08/15/23 5,107,694 58,396 – 5,166,090 5,107,694 58,396 5,166,090 East West Bank CD 5.15%08/15/23 4,093,834 51,555 – 4,145,390 4,093,834 51,555 4,145,390 Texas Capital Bank CD 3.30%08/24/23 2,548,378 21,284 – 2,569,662 2,548,378 21,284 2,569,662 FHLB 3.71%09/13/23 13,344,961 2,763 – 13,347,723 13,279,879 15,198 13,295,077 FFCB 3.74%09/22/23 909,814 7,897 – 917,711 905,050 9,343 914,394 Veritex Community Bank CD 0.25%09/25/23 10,037,463 6,326 – 10,043,790 10,037,463 6,326 10,043,790 Bank OZK CD 5.05%09/30/23 25,000,000 312,574 – 25,312,574 25,000,000 312,574 25,312,574 Bank OZK CD 0.20%10/09/23 5,014,227 2,541 – 5,016,767 5,014,227 2,541 5,016,767 East West Bank CD 5.32%10/12/23 – 13,777,849 – 13,777,849 – 13,777,849 13,777,849 FHLB 4.56%10/13/23 2,440,656 27,553 – 2,468,208 2,438,472 26,574 2,465,046 East West Bank CD 4.87%10/18/23 10,095,648 120,515 – 10,216,163 10,095,648 120,515 10,216,163 East West Bank CD 4.63%10/19/23 2,551,403 28,977 – 2,580,380 2,551,403 28,977 2,580,380 FHLB 5.17%10/24/23 9,715,950 124,872 – 9,840,822 9,740,046 105,178 9,845,225 City of Georgetown Valley View Consulting, L.L.C.58 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 East West Bank CD 10/12/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 East West Bank CD 11/13/23 East West Bank CD 11/15/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 East West Bank CD 12/20/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 East West Bank CD 01/26/24 Southside Bank CD 02/02/24 Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24 Independent Financial CD 05/09/24 T-Note 05/15/24 BOK Financial CD 05/16/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 Third Coast Bank CD 06/28/25 Totals Book Value June 30, 2023 (Continued) 2019 CO- Streets/ Facilities/ Equip 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 GO- Roads Electric-LCRA Transformers City - 2021 CO Airport City - 2021 CO Fac/Equip/ Parks City - 2021 GO Parks City - 2021 GO Roads City - 2021A CO Electric City - 2021A CO Water/WW City - 2021A GO Roads City - 2022 CO Airport –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,890,569 2,831,964 589,778 4,151,964 3,955,599 727,530 4,295,171 14,367 2,521,872 431,192 4,742,713 9,428,111 519,293 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,062,706 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,166,090 – – – – – – – 4,145,390 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,148,542 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,581,244 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,890,569$ 2,831,964$ 589,778$ 6,214,670$ 3,955,599$ 727,530$ 8,440,561$ 14,367$ 2,521,872$ 431,192$ 7,323,957$ 19,742,743$ 519,293$ City of Georgetown Valley View Consulting, L.L.C.61 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 East West Bank CD 10/12/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 East West Bank CD 11/13/23 East West Bank CD 11/15/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 East West Bank CD 12/20/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 East West Bank CD 01/26/24 Southside Bank CD 02/02/24 Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24 Independent Financial CD 05/09/24 T-Note 05/15/24 BOK Financial CD 05/16/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 Third Coast Bank CD 06/28/25 Totals Book Value June 30, 2023 (Continued) City - 2022 CO Fac/Equip/Parks City - 2022 CO Stormwater City - 2022 GO Parks City - 2022 GO Roads City - 2022 CO Electric City - 2022 CO Water/WW City - 2023 CO Fac/Equip/Parks City - 2023 CO Stormwater City - 2023 GO Parks City - 2023 GO Roads City - 2023 Revenue Electric City - 2023 Revenue Water/WW –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,987,910 175,646 4,292,338 9,588,061 6,817,853 37,760,378 25,624,527 661,438 7,031,869 25,956,188 13,671,429 93,918,647 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,023,746 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,347,723 – – – – – – – – – – – – 917,711 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,777,849 – – – – – – – – – – – – – – – – – – – – – – – – – 10,216,163 – – – – – – – – – – – –– – – – – – – – – – – 9,840,822 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – 26,325,077 – – – – – – – – – – – –– – – – – – – – – – – 10,109,963 – – – – – – – – – – – 10,213,869 – – – – – – – – – – – –– – – – – – – – – 4,036,983 – –– – – – – – – – – – – 10,250,379 – – – – – – – – – – – 12,050,795 – – – – – – – – – – – –– – – – – – – – – – – 10,164,995 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – 10,082,558 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – 8,000,000 – – – – – – – – – – – 10,255,918 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – 10,109,726 – – – – – – – – – – – 10,000,000 – – – – – – – – – – – –– – – – – – – – – – – 10,255,918 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – 3,011,656$ 175,646$ 4,292,338$ 40,750,615$ 7,735,564$ 195,636,559$ 25,624,527$ 661,438$ 7,031,869$ 25,956,188$ 13,671,429$ 93,918,647$ City of Georgetown Valley View Consulting, L.L.C.62 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 East West Bank CD 10/12/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 East West Bank CD 11/13/23 East West Bank CD 11/15/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 East West Bank CD 12/20/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 East West Bank CD 01/26/24 Southside Bank CD 02/02/24 Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24 Independent Financial CD 05/09/24 T-Note 05/15/24 BOK Financial CD 05/16/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 Third Coast Bank CD 06/28/25 Totals Book Value June 30, 2023 (Continued) City - American Rescue Plan City - Impact Fees - Water City - Impact Fees - WW City - Limited Tax Note, Series 2022 –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – 7,884,881 14,983,599 9,293,584 3,830,552 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 25,312,574 – – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –– – – –8,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 7,884,881$ 40,296,173$ 17,293,584$ 3,830,552$ City of Georgetown Valley View Consulting, L.L.C.63 City - Allocation June 30, 2023 Market Value Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Streets/ Vehicles 2015 GO- Roads 2015 Revenue Water WW 2016 GO- Roads Garey Park Donation 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Roads JPMorgan Chase Cash 618,137$ 618,137$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 438,323 438,323 – – – – – – – – – – – Wells Fargo Bank Cash 227,810 227,810 – – – – – – – – – – – Wells Fargo Bank Sweep-MMF 17,302,185 17,302,185 – – – – – – – – – – – Veritex Community Bank MMA 3,345,666 3,345,666 – – – – – – – – – – – NexBank MMA 12,914,507 12,914,507 – – – – – – – – – – – TexPool 40,801,750 40,801,750 – – – – – – – – – – – TexSTAR 397,322,905 49,336,669 435,925 30,325,458 118,782 1,644,861 1,592,110 1,693 1,100,146 7,754,618 30,229 273,546 1,129,847 Alliance Bank CD 07/01/23 4,093,809 4,093,809 – – – – – – – – – – – FHLB 07/31/23 4,981,247 4,981,247 – – – – – – – – – – – East West Bank CD 08/01/23 2,062,706 – – – – – – – – – – – – Alliance Bank CD 08/02/23 1,023,746 – – – – – – – – – – – – Bank OZK CD 08/14/23 5,016,704 5,016,704 – – – – – – – – – – – East West Bank CD 08/15/23 5,166,090 – – – – – – – – – – – – East West Bank CD 08/15/23 4,145,390 – – – – – – – – – – – – Texas Capital Bank CD 08/24/23 2,569,662 2,569,662 – – – – – – – – – – – FHLB 09/13/23 13,295,077 – – – – – – – – – – – – FFCB 09/22/23 914,394 – – – – – – – – – – – – Veritex Community Bank CD 09/25/23 10,043,790 10,043,790 – – – – – – – – – – – Bank OZK CD 09/30/23 25,312,574 – – – – – – – – – – – – Bank OZK CD 10/09/23 5,016,767 5,016,767 – – – – – – – – – – – East West Bank CD 10/12/23 13,777,849 – – – – – – – – – – – – FHLB 10/13/23 2,465,046 2,465,046 – – – – – – – – – – – East West Bank CD 10/18/23 10,216,163 – – – – – – – – – – – – East West Bank CD 10/19/23 2,580,380 2,580,380 – – – – – – – – – – – FHLB 10/24/23 9,845,225 – – – – – – – – – – – – Bank OZK CD 11/13/23 10,047,690 10,047,690 – – – – – – – – – – – East West Bank CD 11/13/23 3,104,697 – – – – – – – – 3,104,697 – – – East West Bank CD 11/15/23 5,148,542 – – – – – – – – – – – – FAMCA 11/22/23 1,994,665 1,994,665 – – – – – – – – – – – East West Bank CD 12/11/23 9,149,924 9,149,924 – – – – – – – – – – – FAMCA 12/13/23 9,962,084 9,962,084 – – – – – – – – – – – East West Bank CD 12/20/23 2,581,244 – – – – – – – – – – – – Alliance Bank CD 12/27/23 1,025,592 1,025,592 – – – – – – – – – – – Bank OZK CD 12/30/23 26,325,077 – – – – – – – – – – – – Alliance Bank CD 01/12/24 5,063,493 5,063,493 – – – – – – – – – – – East West Bank CD 01/12/24 10,109,963 – – – – – – – – – – – – East West Bank CD 01/18/24 10,213,869 – – – – – – – – – – – – Veritex Community Bank CD 01/23/24 10,201,840 10,201,840 – – – – – – – – – – – East West Bank CD 01/26/24 4,036,983 – – – – – – – – – – – – Southside Bank CD 02/02/24 10,250,379 – – – – – – – – – – – – Independent Financial CD 02/15/24 12,050,795 – – – – – – – – – – – – FHLB 02/28/24 19,983,180 19,983,180 – – – – – – – – – – – East West Bank CD 03/11/24 10,164,995 – – – – – – – – – – – – BOK Financial CD 03/23/24 8,107,655 8,107,655 – – – – – – – – – – – Third Coast Bank CD 03/28/24 8,000,000 – – – – – – – – – – – – Bank OZK CD 04/18/24 10,082,558 – – – – – – – – – – – – East West Bank CD 04/26/24 10,089,355 10,089,355 – – – – – – – – – – – Independent Financial CD 05/09/24 8,089,683 8,089,683 – – – – – – – – – – – T-Note 05/15/24 1,912,656 1,912,656 – – – – – – – – – – – BOK Financial CD 05/16/24 8,000,000 – – – – – – – – – – – – Alliance Bank CD 06/14/24 10,255,918 – – – – – – – – – – – – East West Bank CD 06/17/24 15,489,078 15,489,078 – – – – – – – – – – – Alliance Bank CD 06/27/24 13,435,856 13,435,856 – – – – – – – – – – – Independent Financial CD 07/24/24 10,109,726 – – – – – – – – – – – – FHLB 07/26/24 9,962,974 – – – – – – – – – – – – FFCB 08/21/24 3,969,138 3,969,138 – – – – – – – – – – – Alliance Bank CD 12/13/24 10,255,918 – – – – – – – – – – – – T-Note 12/15/24 4,705,078 4,705,078 – – – – – – – – – – – Third Coast Bank CD 06/28/25 10,000,000 10,000,000 – – – – – – – – – – – Totals 899,378,504$ 304,979,419$ 435,925$ 30,325,458$ 118,782$ 1,644,861$ 1,592,110$ 1,693$ 1,100,146$ 10,859,315$ 30,229$ 273,546$ 1,129,847$ City of Georgetown Valley View Consulting, L.L.C.64 City - Allocation June 30, 2023 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 East West Bank CD 10/12/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 East West Bank CD 11/13/23 East West Bank CD 11/15/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 East West Bank CD 12/20/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 East West Bank CD 01/26/24 Southside Bank CD 02/02/24 Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24 Independent Financial CD 05/09/24 T-Note 05/15/24 BOK Financial CD 05/16/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 Third Coast Bank CD 06/28/25 Totals (Continued) 2019 CO- Streets/ Facilities/ Equip 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 GO- Roads Electric-LCRA Transformers City - 2021 CO Airport City - 2021 CO Fac/Equip/ Parks City - 2021 GO Parks City - 2021 GO Roads City - 2021A CO Electric City - 2021A CO Water/WW City - 2021A GO Roads City - 2022 CO Airport –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,890,569 2,831,964 589,778 4,151,964 3,955,599 727,530 4,295,171 14,367 2,521,872 431,192 4,742,713 9,428,111 519,293 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,062,706 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,166,090 – – – – – – – 4,145,390 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,148,542 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,581,244 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,890,569$ 2,831,964$ 589,778$ 6,214,670$ 3,955,599$ 727,530$ 8,440,561$ 14,367$ 2,521,872$ 431,192$ 7,323,957$ 19,742,743$ 519,293$ City of Georgetown Valley View Consulting, L.L.C.65 City - Allocation June 30, 2023 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 East West Bank CD 10/12/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 East West Bank CD 11/13/23 East West Bank CD 11/15/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 East West Bank CD 12/20/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 East West Bank CD 01/26/24 Southside Bank CD 02/02/24 Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24 Independent Financial CD 05/09/24 T-Note 05/15/24 BOK Financial CD 05/16/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 Third Coast Bank CD 06/28/25 Totals (Continued) City - 2022 CO Fac/Equip/Parks City - 2022 CO Stormwater City - 2022 GO Parks City - 2022 GO Roads City - 2022 CO Electric City - 2022 CO Water/WW City - 2023 CO Fac/Equip/Parks City - 2023 CO Stormwater City - 2023 GO Parks City - 2023 GO Roads City - 2023 Revenue Electric City - 2023 Revenue Water/WW –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,987,910 175,646 4,292,338 9,588,061 6,817,853 37,760,378 25,624,527 661,438 7,031,869 25,956,188 13,671,429 93,918,647 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,023,746 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,295,077 – – – – – – – – – – – – 914,394 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,777,849 – – – – – – – – – – – – – – – – – – – – – – – – – 10,216,163 – – – – – – – – – – – –– – – – – – – – – – – 9,845,225 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – 26,325,077 – – – – – – – – – – – –– – – – – – – – – – – 10,109,963 – – – – – – – – – – – 10,213,869 – – – – – – – – – – – –– – – – – – – – – 4,036,983 – –– – – – – – – – – – – 10,250,379 – – – – – – – – – – – 12,050,795 – – – – – – – – – – – –– – – – – – – – – – – 10,164,995 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – 10,082,558 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – 8,000,000 – – – – – – – – – – – 10,255,918 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – – – – – – 10,109,726 – – – – – – – – – – – 9,962,974 – – – – – – – – – – – –– – – – – – – – – – – 10,255,918 – – – – – – – – – – – –– – – – – – – – – – – –– – – – – – 3,011,656$ 175,646$ 4,292,338$ 40,697,969$ 7,732,247$ 195,603,936$ 25,624,527$ 661,438$ 7,031,869$ 25,956,188$ 13,671,429$ 93,918,647$ City of Georgetown Valley View Consulting, L.L.C.66 City - Allocation June 30, 2023 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 East West Bank CD 10/12/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 East West Bank CD 11/13/23 East West Bank CD 11/15/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 East West Bank CD 12/20/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 East West Bank CD 01/26/24 Southside Bank CD 02/02/24 Independent Financial CD 02/15/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Third Coast Bank CD 03/28/24 Bank OZK CD 04/18/24 East West Bank CD 04/26/24 Independent Financial CD 05/09/24 T-Note 05/15/24 BOK Financial CD 05/16/24 Alliance Bank CD 06/14/24 East West Bank CD 06/17/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 T-Note 12/15/24 Third Coast Bank CD 06/28/25 Totals (Continued) City - American Rescue Plan City - Impact Fees - Water City - Impact Fees - WW City - Limited Tax Note, Series 2022 –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – 7,884,881 14,983,599 9,293,584 3,830,552 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 25,312,574 – – – –– – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 7,884,881$ 40,296,173$ 17,293,584$ 3,830,552$ City of Georgetown Valley View Consulting, L.L.C.67 City - Allocation Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Streets/ Vehicles 2015 GO- Roads 2015 Revenue Water WW 2016 GO- Roads Garey Park Donation 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Roads JPMorgan Chase Cash 758,592$ 758,592$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 436,688 436,688 – – – – – – – – – – – Wells Fargo Bank Cash 42,112 42,112 – – – – – – – – – – – Wells Fargo Bank Sweep-MMF 12,164,479 12,164,479 – – – – – – – – – – – Veritex Community Bank MMA 3,304,419 3,304,419 – – – – – – – – – – – NexBank MMA 12,749,708 12,749,708 – – – – – – – – – – – TexPool 30,752,271 30,752,271 – – – – – – – – – – – TexSTAR 250,398,587 37,854,861 451,459 29,705,689 140,951 1,894,898 1,572,488 431,220 1,086,587 7,762,382 44,041 315,240 1,282,110 East West Bank CD 04/12/23 13,605,580 – – – – – – – – – – – – East West Bank CD 04/12/23 20,385,946 – – – – – – – – – – – – Prosperity Bank CD 04/24/23 5,019,186 5,019,186 – – – – – – – – – – – Prosperity Bank CD 05/01/23 5,018,361 5,018,361 – – – – – – – – – – – Alliance Bank CD 05/02/23 4,059,706 – – – – – – – – – – – – Texas Capital Bank CD 05/04/23 1,271,232 – – – – – – – – – – – – East West Bank CD 05/10/23 3,070,630 – – – – – – – – 3,070,630 – – – FHLB 05/10/23 23,880,000 – – – – – – – – – – – – East West Bank CD 05/15/23 5,085,546 – – – – – – – – – – – – Bank OZK CD 06/12/23 5,028,894 5,028,894 – – – – – – – – – – – East West Bank CD 06/16/23 15,359,336 15,359,336 – – – – – – – – – – – Texas Capital Bank CD 06/16/23 5,085,517 5,085,517 – – – – – – – – – – – East West Bank CD 06/20/23 2,560,349 – – – – – – – – – – – – Alliance Bank CD 06/27/23 8,100,603 – – – – – – – – – – – – FHLB 06/29/23 9,903,875 9,903,875 – – – – – – – – – – – R Bank CD 06/30/23 1,012,842 1,012,842 – – – – – – – – – – – Alliance Bank CD 07/01/23 4,093,809 4,093,809 – – – – – – – – – – – FHLB 07/31/23 4,926,885 4,926,885 – – – – – – – – – – – East West Bank CD 08/01/23 2,047,081 – – – – – – – – – – – – Alliance Bank CD 08/02/23 1,015,942 – – – – – – – – – – – – Bank OZK CD 08/14/23 5,014,037 5,014,037 – – – – – – – – – – – East West Bank CD 08/15/23 5,107,694 – – – – – – – – – – – – East West Bank CD 08/15/23 4,093,834 – – – – – – – – – – – – Texas Capital Bank CD 08/24/23 2,548,378 2,548,378 – – – – – – – – – – – FHLB 09/13/23 13,344,961 – – – – – – – – – – – – FFCB 09/22/23 909,814 – – – – – – – – – – – – Veritex Community Bank CD 09/25/23 10,037,463 10,037,463 – – – – – – – – – – – Bank OZK CD 09/30/23 25,000,000 – – – – – – – – – – – – Bank OZK CD 10/09/23 5,014,227 5,014,227 – – – – – – – – – – – FHLB 10/13/23 2,440,656 2,440,656 – – – – – – – – – – – East West Bank CD 10/18/23 10,095,648 – – – – – – – – – – – – East West Bank CD 10/19/23 2,551,403 2,551,403 – – – – – – – – – – – FHLB 10/24/23 9,715,950 – – – – – – – – – – – – Bank OZK CD 11/13/23 10,040,071 10,040,071 – – – – – – – – – – – FAMCA 11/22/23 2,000,000 2,000,000 – – – – – – – – – – – East West Bank CD 12/11/23 9,030,049 9,030,049 – – – – – – – – – – – FAMCA 12/13/23 10,000,000 10,000,000 – – – – – – – – – – – Alliance Bank CD 12/27/23 1,012,575 1,012,575 – – – – – – – – – – – Bank OZK CD 12/30/23 26,000,000 – – – – – – – – – – – – Alliance Bank CD 01/12/24 5,000,000 5,000,000 – – – – – – – – – – – East West Bank CD 01/18/24 10,094,639 – – – – – – – – – – – – Veritex Community Bank CD 01/23/24 10,078,388 10,078,388 – – – – – – – – – – – Southside Bank CD 02/02/24 10,168,065 – – – – – – – – – – – – FHLB 02/28/24 20,000,000 20,000,000 – – – – – – – – – – – East West Bank CD 03/11/24 10,033,071 – – – – – – – – – – – – BOK Financial CD 03/23/24 8,009,630 8,009,630 – – – – – – – – – – – Independent Financial CD 05/09/24 8,000,000 8,000,000 – – – – – – – – – – – T-Note 05/15/24 1,903,741 1,903,741 – – – – – – – – – – – Alliance Bank CD 06/14/24 10,125,753 – – – – – – – – – – – – Alliance Bank CD 06/27/24 13,265,333 13,265,333 – – – – – – – – – – – Independent Financial CD 07/24/24 10,000,000 – – – – – – – – – – – – FHLB 07/26/24 10,000,000 – – – – – – – – – – – – FFCB 08/21/24 3,983,041 3,983,041 – – – – – – – – – – – Alliance Bank CD 12/13/24 10,125,753 – – – – – – – – – – – – Totals 745,882,348$ 283,440,824$ 451,459$ 29,705,689$ 140,951$ 1,894,898$ 1,572,488$ 431,220$ 1,086,587$ 10,833,012$ 44,041$ 315,240$ 1,282,110$ March 31, 2023 Book Value City of Georgetown Valley View Consulting, L.L.C.68 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR East West Bank CD 04/12/23 East West Bank CD 04/12/23 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Alliance Bank CD 05/02/23 Texas Capital Bank CD 05/04/23 East West Bank CD 05/10/23 FHLB 05/10/23 East West Bank CD 05/15/23 Bank OZK CD 06/12/23 East West Bank CD 06/16/23 Texas Capital Bank CD 06/16/23 East West Bank CD 06/20/23 Alliance Bank CD 06/27/23 FHLB 06/29/23 R Bank CD 06/30/23 Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 Southside Bank CD 02/02/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Independent Financial CD 05/09/24 T-Note 05/15/24 Alliance Bank CD 06/14/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 Totals March 31, 2023 Book Value (Continued) 2019 CO- Streets/ Facilities/ Equip 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 CO- Stormwater 2020 GO- Roads Electric-LCRA Transformers City - 2021 CO Airport City - 2021 CO Fac/Equip/ Parks City - 2021 GO Parks City - 2021 GO Roads City - 2021A CO Electric City - 2021A CO Water/WW City - 2021A GO Roads City - 2022 CO Airport –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,137,096 2,798,356 613,672 114 4,116,405 3,798,399 718,563 5,507,046 175,586 3,026,941 434,425 6,022,715 12,009,359 512,893 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,085,546 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,560,349 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,047,081 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,107,694 – – – – – – – – 4,093,834 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,137,096$ 2,798,356$ 613,672$ 114$ 6,163,486$ 3,798,399$ 718,563$ 9,600,880$ 175,586$ 3,026,941$ 434,425$ 8,583,063$ 22,202,598$ 512,893$ City of Georgetown Valley View Consulting, L.L.C.69 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR East West Bank CD 04/12/23 East West Bank CD 04/12/23 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Alliance Bank CD 05/02/23 Texas Capital Bank CD 05/04/23 East West Bank CD 05/10/23 FHLB 05/10/23 East West Bank CD 05/15/23 Bank OZK CD 06/12/23 East West Bank CD 06/16/23 Texas Capital Bank CD 06/16/23 East West Bank CD 06/20/23 Alliance Bank CD 06/27/23 FHLB 06/29/23 R Bank CD 06/30/23 Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 Southside Bank CD 02/02/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Independent Financial CD 05/09/24 T-Note 05/15/24 Alliance Bank CD 06/14/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 Totals March 31, 2023 Book Value (Continued) City - 2022 CO Fac/Equip/Parks City - 2022 CO Stormwater City - 2022 GO Parks City - 2022 GO Roads City - 2022 CO Electric City - 2022 CO Water/WW City - American Rescue Plan City - Impact Fees - Water City - Impact Fees - WW City - Limited Tax Note, Series 2022 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,544,995 285,644 4,407,763 8,393,483 4,279,361 39,069,046 7,839,223 42,050,571 9,112,481 4,002,526 – – – 13,605,580 – – – – – – – – – – – 20,385,946 – – – – – – – – – –– – – – – – – – – –– – – – – – – 4,059,706 – –– – – – – – – 1,271,232 – –– – – – – – – – – –– – – – – – – – 3,980,000 19,900,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,100,603 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,015,942 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,344,961 – – – – – – – – – – 909,814 – – – – – – – – – – – – – – – – – – – – – – 25,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,095,648 – – – – – – – – – –– – – – – – – – – 9,715,950 – – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – – – – – – 26,000,000 – – – – – – – – – –– – – – – – – – – 10,094,639 – – – – – – – – – – – – – – – – – – – 10,168,065 – – – – – – – – – –– – – – – – – – – 10,033,071 – – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – – – – – – 10,125,753 – – – – – – – – – –– – – – – – – – – 10,000,000 – – – – – – – – – 10,000,000 – – – – – – – – – –– – – – – – – – – 10,125,753 – – – – 3,560,937$ 285,644$ 4,407,763$ 40,674,962$ 9,169,175$ 195,713,872$ 7,839,223$ 67,050,571$ 17,213,084$ 4,002,526$ City of Georgetown Valley View Consulting, L.L.C.70 City - Allocation March 31, 2023 Market Value Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Streets/ Vehicles 2015 GO- Roads 2015 Revenue Water WW 2016 GO- Roads Garey Park Donation 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Roads JPMorgan Chase Cash 758,592$ 758,592$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 436,688 436,688 – – – – – – – – – – – Wells Fargo Bank Cash 42,112 42,112 – – – – – – – – – – – Wells Fargo Bank Sweep-MMF 12,164,479 12,164,479 – – – – – – – – – – – Veritex Community Bank MMA 3,304,419 3,304,419 – – – – – – – – – – – NexBank MMA 12,749,708 12,749,708 – – – – – – – – – – – TexPool 30,752,271 30,752,271 – – – – – – – – – – – TexSTAR 250,398,587 37,854,861 451,459 29,705,689 140,951 1,894,898 1,572,488 431,220 1,086,587 7,762,382 44,041 315,240 1,282,110 East West Bank CD 04/12/23 13,605,580 – – – – – – – – – – – – East West Bank CD 04/12/23 20,385,946 – – – – – – – – – – – – Prosperity Bank CD 04/24/23 5,019,186 5,019,186 – – – – – – – – – – – Prosperity Bank CD 05/01/23 5,018,361 5,018,361 – – – – – – – – – – – Alliance Bank CD 05/02/23 4,059,706 – – – – – – – – – – – – Texas Capital Bank CD 05/04/23 1,271,232 – – – – – – – – – – – – East West Bank CD 05/10/23 3,070,630 – – – – – – – – 3,070,630 – – – FHLB 05/10/23 23,887,843 – – – – – – – – – – – – East West Bank CD 05/15/23 5,085,546 – – – – – – – – – – – – Bank OZK CD 06/12/23 5,028,894 5,028,894 – – – – – – – – – – – East West Bank CD 06/16/23 15,359,336 15,359,336 – – – – – – – – – – – Texas Capital Bank CD 06/16/23 5,085,517 5,085,517 – – – – – – – – – – – East West Bank CD 06/20/23 2,560,349 – – – – – – – – – – – – Alliance Bank CD 06/27/23 8,100,603 – – – – – – – – – – – – FHLB 06/29/23 9,887,246 9,887,246 – – – – – – – – – – – R Bank CD 06/30/23 1,012,842 1,012,842 – – – – – – – – – – – Alliance Bank CD 07/01/23 4,093,809 4,093,809 – – – – – – – – – – – FHLB 07/31/23 4,922,799 4,922,799 – – – – – – – – – – – East West Bank CD 08/01/23 2,047,081 – – – – – – – – – – – – Alliance Bank CD 08/02/23 1,015,942 – – – – – – – – – – – – Bank OZK CD 08/14/23 5,014,037 5,014,037 – – – – – – – – – – – East West Bank CD 08/15/23 5,107,694 – – – – – – – – – – – – East West Bank CD 08/15/23 4,093,834 – – – – – – – – – – – – Texas Capital Bank CD 08/24/23 2,548,378 2,548,378 – – – – – – – – – – – FHLB 09/13/23 13,279,879 – – – – – – – – – – – – FFCB 09/22/23 905,050 – – – – – – – – – – – – Veritex Community Bank CD 09/25/23 10,037,463 10,037,463 – – – – – – – – – – – Bank OZK CD 09/30/23 25,000,000 – – – – – – – – – – – – Bank OZK CD 10/09/23 5,014,227 5,014,227 – – – – – – – – – – – FHLB 10/13/23 2,438,472 2,438,472 – – – – – – – – – – – East West Bank CD 10/18/23 10,095,648 – – – – – – – – – – – – East West Bank CD 10/19/23 2,551,403 2,551,403 – – – – – – – – – – – FHLB 10/24/23 9,740,046 – – – – – – – – – – – – Bank OZK CD 11/13/23 10,040,071 10,040,071 – – – – – – – – – – – FAMCA 11/22/23 1,999,879 1,999,879 – – – – – – – – – – – East West Bank CD 12/11/23 9,030,049 9,030,049 – – – – – – – – – – – FAMCA 12/13/23 9,986,696 9,986,696 – – – – – – – – – – – Alliance Bank CD 12/27/23 1,012,575 1,012,575 – – – – – – – – – – – Bank OZK CD 12/30/23 26,000,000 – – – – – – – – – – – – Alliance Bank CD 01/12/24 5,000,000 5,000,000 – – – – – – – – – – – East West Bank CD 01/18/24 10,094,639 – – – – – – – – – – – – Veritex Community Bank CD 01/23/24 10,078,388 10,078,388 – – – – – – – – – – – Southside Bank CD 02/02/24 10,168,065 – – – – – – – – – – – – FHLB 02/28/24 20,084,080 20,084,080 – – – – – – – – – – – East West Bank CD 03/11/24 10,033,071 – – – – – – – – – – – – BOK Financial CD 03/23/24 8,009,630 8,009,630 – – – – – – – – – – – Independent Financial CD 05/09/24 8,000,000 8,000,000 – – – – – – – – – – – T-Note 05/15/24 1,907,656 1,907,656 – – – – – – – – – – – Alliance Bank CD 06/14/24 10,125,753 – – – – – – – – – – – – Alliance Bank CD 06/27/24 13,265,333 13,265,333 – – – – – – – – – – – Independent Financial CD 07/24/24 10,000,000 – – – – – – – – – – – – FHLB 07/26/24 10,065,863 – – – – – – – – – – – – FFCB 08/21/24 4,009,236 4,009,236 – – – – – – – – – – – Alliance Bank CD 12/13/24 10,125,753 – – – – – – – – – – – – Totals 745,988,174$ 283,518,692$ 451,459$ 29,705,689$ 140,951$ 1,894,898$ 1,572,488$ 431,220$ 1,086,587$ 10,833,012$ 44,041$ 315,240$ 1,282,110$ City of Georgetown Valley View Consulting, L.L.C.71 City - Allocation March 31, 2023 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR East West Bank CD 04/12/23 East West Bank CD 04/12/23 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Alliance Bank CD 05/02/23 Texas Capital Bank CD 05/04/23 East West Bank CD 05/10/23 FHLB 05/10/23 East West Bank CD 05/15/23 Bank OZK CD 06/12/23 East West Bank CD 06/16/23 Texas Capital Bank CD 06/16/23 East West Bank CD 06/20/23 Alliance Bank CD 06/27/23 FHLB 06/29/23 R Bank CD 06/30/23 Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 Southside Bank CD 02/02/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Independent Financial CD 05/09/24 T-Note 05/15/24 Alliance Bank CD 06/14/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 Totals (Continued) 2019 CO- Streets/ Facilities/ Equip 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 CO- Stormwater 2020 GO- Roads Electric-LCRA Transformers City - 2021 CO Airport City - 2021 CO Fac/Equip/ Parks City - 2021 GO Parks City - 2021 GO Roads City - 2021A CO Electric City - 2021A CO Water/WW City - 2021A GO Roads City - 2022 CO Airport –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,137,096 2,798,356 613,672 114 4,116,405 3,798,399 718,563 5,507,046 175,586 3,026,941 434,425 6,022,715 12,009,359 512,893 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,085,546 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,560,349 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,047,081 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,107,694 – – – – – – – – 4,093,834 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,137,096$ 2,798,356$ 613,672$ 114$ 6,163,486$ 3,798,399$ 718,563$ 9,600,880$ 175,586$ 3,026,941$ 434,425$ 8,583,063$ 22,202,598$ 512,893$ City of Georgetown Valley View Consulting, L.L.C.72 City - Allocation March 31, 2023 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR East West Bank CD 04/12/23 East West Bank CD 04/12/23 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Alliance Bank CD 05/02/23 Texas Capital Bank CD 05/04/23 East West Bank CD 05/10/23 FHLB 05/10/23 East West Bank CD 05/15/23 Bank OZK CD 06/12/23 East West Bank CD 06/16/23 Texas Capital Bank CD 06/16/23 East West Bank CD 06/20/23 Alliance Bank CD 06/27/23 FHLB 06/29/23 R Bank CD 06/30/23 Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 09/30/23 Bank OZK CD 10/09/23 FHLB 10/13/23 East West Bank CD 10/18/23 East West Bank CD 10/19/23 FHLB 10/24/23 Bank OZK CD 11/13/23 FAMCA 11/22/23 East West Bank CD 12/11/23 FAMCA 12/13/23 Alliance Bank CD 12/27/23 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 Southside Bank CD 02/02/24 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Independent Financial CD 05/09/24 T-Note 05/15/24 Alliance Bank CD 06/14/24 Alliance Bank CD 06/27/24 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/24 Totals (Continued) City - 2022 CO Fac/Equip/Parks City - 2022 CO Stormwater City - 2022 GO Parks City - 2022 GO Roads City - 2022 CO Electric City - 2022 CO Water/WW City - American Rescue Plan City - Impact Fees - Water City - Impact Fees - WW City - Limited Tax Note, Series 2022 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,544,995 285,644 4,407,763 8,393,483 4,279,361 39,069,046 7,839,223 42,050,571 9,112,481 4,002,526 – – – 13,605,580 – – – – – – – – – – – 20,385,946 – – – – – – – – – –– – – – – – – – – –– – – – – – – 4,059,706 – –– – – – – – – 1,271,232 – –– – – – – – – – – –– – – – – – – – 3,981,307 19,906,536 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,100,603 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,015,942 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,279,879 – – – – – – – – – – 905,050 – – – – – – – – – – – – – – – – – – – – – – 25,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,095,648 – – – – – – – – – –– – – – – – – – – 9,740,046 – – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – – – – – – 26,000,000 – – – – – – – – – –– – – – – – – – – 10,094,639 – – – – – – – – – – – – – – – – – – – 10,168,065 – – – – – – – – – –– – – – – – – – – 10,033,071 – – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – – – – – – 10,125,753 – – – – – – – – – –– – – – – – – – – 10,000,000 – – – – – – – – – 10,065,863 – – – – – – – – – –– – – – – – – – – 10,125,753 – – – – 3,560,937$ 285,644$ 4,407,763$ 40,609,880$ 9,165,719$ 195,810,368$ 7,839,223$ 67,050,571$ 17,213,084$ 4,002,526$ City of Georgetown Valley View Consulting, L.L.C.73 Georgetown Economic Development Corporation (GEDCO) QUARTERLY INVESTMENT REPORT For the Quarter Ended June 30, 2023 Prepared by Valley View Consulting, L.L.C. The investment portfolio of the Georgetown Economic Development Corporation (GEDCO) is in compliance with the Texas Public Funds Investment Act and the Investment Policy and Strategies. Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total return yields and do not account for investment advisor fees.74 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield MMA 2,191,077$ 2,191,077$ 2,218,434$ 2,218,434$ 5.20% Pools 8,038,391 8,038,391 8,662,192 8,662,192 5.08% 10,229,468$ 10,229,468$ 10,880,626$ 10,880,626$ 5.11% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 5.11%Total Portfolio 4.61% Rolling Three Month Treasury 5.28%Rolling Three Month Treasury 4.75% Rolling Six Month Treasury 5.08%Rolling Six Month Treasury 4.57% TexPool 5.05%TexPool 4.55% Interest income provided in separate report. March 31, 2023 (1)Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank, pool, and money market balances. (2)Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. June 30, 2023 Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.75 Investment Holdings Coupon/Maturity Settlement Face Amount/Book Market Market Life Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield Veritex Bank MMA 5.20%07/01/23 06/30/23 2,218,434$ 2,218,434$ 1.00 2,218,434$ 1 5.20% TexasDAILY AAAm 5.10%07/01/23 06/30/23 2,211,780 2,211,780 1.00 2,211,780 1 5.10% TexSTAR AAAm 5.08%07/01/23 06/30/23 6,450,412 6,450,412 1.00 6,450,412 1 5.08% 10,880,626$ 10,880,626$ 10,880,626$ 1 5.11% (1)(2) June 30, 2023 (1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity. (2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds. Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.77 Georgetown Transportation Enhancement Corporation (GTEC) QUARTERLY INVESTMENT REPORT For the Quarter Ended June 30, 2023 Prepared byValley 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.80 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield Pools/MMAs 36,212,462$ 36,212,462$ 35,611,949$ 35,611,949$ 5.07% CDs/Securities 9,976,394 9,975,810 10,085,562 10,082,914 5.04%Totals 46,188,855$ 46,188,271$ 45,697,510$ 45,694,863$ 5.06% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 5.06%Total Portfolio 4.55% Rolling Three Month Treasury 5.28%Rolling Three Month Treasury 4.75% Rolling Six Month Treasury 5.08%Rolling Six Month Treasury 4.57% TexPool 5.05%TexPool 4.55% Interest data provided in separate report. March 31, 2023 (1)Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank, pool, and money market balances. (2)Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. June 30, 2023 Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.81 Investment Holdings Coupon/Maturity Settlement Face Amount/Book Market Market Life Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield TexPool AAAm 5.05%07/01/23 06/30/23 27,950,747$ 27,950,747$ 1.00 27,950,747$ 1 5.05% TexSTAR AAAm 5.08%07/01/23 06/30/23 4,861,964 4,861,964 1.00 4,861,964 1 5.08% Veritex Bank MMA 5.20%07/01/23 06/30/23 2,799,238 2,799,238 1.00 2,799,238 1 5.20% FAMCA 0.22%8/11/2023 11/10/22 5,000,000 4,974,123 99.43 4,971,475 42 4.84% Independent Financial CD 4.95%2/9/2024 02/09/23 2,022,241 2,022,241 100.00 2,022,241 224 5.04% East West Bank CD 5.22%05/28/24 05/25/23 3,089,198 3,089,198 100.00 3,089,198 333 5.36% TOTALS 45,723,387$ 45,697,510$ 45,694,863$ 38 5.06% (1)(2) June 30, 2023 (1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity. (2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds. Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.83 Department Federal Grantor Pass-Through Agency Identifying Number COG Name/Purpose YTD Expenditures YTD Revenue Recognized Airport Federal Aviation Administration Texas Department of Transportation 21TWGEORG Airport 2021 CARES - Tower 22,654 - Airport Federal Aviation Administration Texas Department of Transportation 2314GRGTN Airport Pavement Project 169,400 - Airport Federal Aviation Administration Texas Department of Transportation 22CVGEORG Airport Rescue Plan 59,000 59,000 Arts & Culture Texas Commission on the Arts FY22 Performance Grant - Sue Foley 2,250 2,250 Emergency Management US Dept. of the Treasury American Rescue Plan Act SLFRF Funding 263,428 263,428 Library N/A St. David's Foundation St. David's Grant - 1,302 40,000 Planning US Department of Housing & Urban Development Williamson County CDBG 21st St Infrastructure - - Planning US Department of Housing & Urban Development Williamson County CDBG Home Repair (FY21)25,234 20,592 Police US. Department of Justice N/A TX2460200 Equitable Sharing Agreement - - Police US. Department of Treasury N/A TX2460200 Equitable Sharing Agreement - - Public Works Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ 0914-05-201 Highway Planning & Construction (Lakeway & Williams Drive) - 293,149 Electric Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ 2211-02-019 FM 1460 Road Widening (ROW Acquisition)* - - Public Works Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ 0914-05-200 Williams Drive Access Management (Study & Schematic) 76,163 76,163 *Expenses were incurred in FY2014-15, but reported here since TXDOT has now approved for reimbursement. Division Grantor COG Name/Purpose Status Public Works/Electric/City-Wide Federal Emergency Management Administration Texas Division of Emergency Management DR-4705-TX Winter Storm Mara Projects are in progress as of 3/31/23; Damage Inventory Meeting with FEMA 7/31/23 CITY OF GEORGETOWN Grant/Federal Funding Report as of June 30, 2023 Active Applications Pending Award 86