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 - 3rd Quarter Report_Redacted
City of Georgetown Quarterly Financial Report Quarterly Report Version Last updated 09/17/24 City of Georgetown | FY2024 Quarterly Financial Report Page 1 TABLE OF CONTENTS 3rd Quarter 3 General Fund 4 Electric Fund 18 Water Fund 26 Tourism Fund 33 Airport Fund 36 GTEC Fund 39 GEDCO Fund 42 Council Discretionary Fund 47 Joint Services Fund 48 Stormwater Fund 49 VPID Fund 53 Solid Waste Fund 55 Investment Report 60 City 62 GTEC 63 GEDCO 64 Grants 65 Capital Improvements 66 City of Georgetown | FY2024 Quarterly Financial Report Page 2 3RD QUARTER City of Georgetown | FY2024 Quarterly Financial Report Page 3 Personnel and Operations Summary by Division Development Services, Communications & Public Engagement Division: Through the quarter Planning has reported expenses totaling $1,943,843, or 60.15% of budget. The Planning Department has personnel savings due to vacancies. Inspections incurred personnel and operational expenses amounting to $1,743,919, or 72.88% of budget. Downtown, Arts & Events recognized year to date expenses totaling $492,275, or 70.73% of budget. Expenses are signi cantly higher than the same period of last year due to several positions, that are now lled, being paused in FY2023 because of revenue uncertainty and increases to allocations in FY2024. Public Works personnel and operational expenditures for the quarter totals $661,366, which represents 78.66% of budget. Year-to-date expenditures related to personnel and operations for Streets totals $3,786,699, 73.61% of budget. Transportation Planning expenditures for personnel and operations total $1,107,076, or 87.87% of budget. Finance Administration Division: Municipal Court year-to-date expenses total $432,246, or 74.68% of budget. This spending includes $361,793 for personnel costs and $70,453 for operational costs. Municipal court is using overtime to handle the increased case load, as well as using the Associate Judge to ll in for the Judge when necessary. Police Operations Division: Police Operations saw personnel and operational expenditures through the quarter total $16,552,661, or 74.26% of budget. Police Administration expenditures through the quarter resulted in $2,084,234, or 75.14% of budget. Fire and EMS Division: Year-to-date personnel and operational expenditures through the quarter total $5,236,015, or 85.22% of budget for Fire Support Services/Administration, $16,087,853, or 75.70% of budget for Fire Emergency Services, and $3,218,995, or 80.15% of budget for Fire EMS. This is primarily driven by Fire being fully staffed through utilizing over hires. Fire's budget was amended through the mid-year amendment to account for additional staf ng. Staff will continue to monitor Fire expenses and how they align with year-end actuals and projections. Administrative Services Division: Administrative Services saw operational and personnel costs totaling $1,790,338, or 58.81% of budget year-to-date. City Secretary personnel and operational expenditures for the quarter totals $1,269,054, which represents 75.50% of budget. Year-to-date personnel and operational expenditures for Communications totals $970,574, which represents 62.68% of budget. Non-Departmental includes a budget of $299,716 for transfers out to various funds. As of the third quarter, 100.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. Economic Development payments through the quarter are $3,780,433. 311 Call Center personnel and operational expenditures for the quarter totals $105,895, or 13.92% of total budget. The cost center has personnel savings from various vacancies and operational savings due to the timing of purchasing computer software. The budget for computer software is $350,000. Year to date $0 have been spent. Library Division: Library year-to-date expenses total $2,749,343, or 74.89% of budget. Parks and Recreation Division: City of Georgetown | FY2024 Quarterly Financial Report Page 11 Fund Summary The City continues to employ several strategies to maintain the improved performance of the Electric Fund in relation to past and current expenditures for purchased power contracts. These strategies include reviewing rates, recovering the costs of new development, selling Renewable Energy Credits (RECs), and contracting professional services for energy portfolio management and risk oversight. City of Georgetown | FY2024 Quarterly Financial Report Page 18 Ending fund balance for FY2024 is budgeted at $5,792,152. After accounting for the contingency reserve of $810,764, and the debt service reserve of $200,769, this fund is budgeted to have an available fund balance of $4,780,619. City of Georgetown | FY2024 Quarterly Financial Report Page 45 Staff will monitor FY2024 projections as the end of the scal year approaches. Total revenues are projected to end FY2024 at $16,772,263. Through the quarter, actual revenues are 74.19% of total projections. City of Georgetown | FY2024 Quarterly Financial Report Page 57 The City’s strategy continues to be matching maturities with cash ow 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 uctuations. 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 ow 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, nancial 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 nancial 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 nancial institutions as collateral on behalf of the City have been reviewed and met PFIA-minimum rating criteria. City of Georgetown | FY2024 Quarterly Financial Report Page 61 City Investment Report City of Georgetown | FY2024 Quarterly Financial Report Page 62 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield Demand Accounts 20,667$ 20,667 121,236$ 121,236$ 0.00% NOW/MMA/MMF 30,283,936 30,283,936 34,369,563 34,369,563 5.35% Pools 287,181,711 287,181,711 453,273,259 453,273,259 5.30% CDs/Securities 532,694,210 532,617,291 536,085,817 536,029,117 5.39% Totals 850,180,524$ 850,103,605$ 1,023,849,874$ 1,023,793,175$ 5.35% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 5.35%Total Portfolio 5.36% Rolling Three Month Treasury 5.47%Rolling Three Month Treasury 5.48% Rolling Six Month Treasury 5.34%Rolling Six Month Treasury 5.40% TexPool 5.31%TexPool 5.33% Interest earnings provided in separate report. June 30, 2024March 31, 2024 (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.1 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%07/01/24 06/30/24 121,236$ 121,236$ 1.00 121,236$ 1 0.00% Wells Fargo Bank Sweep-MMF AAAm/Aaa-mf 5.19%07/01/24 06/30/24 17,187,916 17,187,916 1.00 17,187,916 1 5.19% Veritex Community Bank MMA 5.33%07/01/24 06/30/24 3,528,257 3,528,257 1.00 3,528,257 1 5.33% NexBank MMA 5.55%07/01/24 06/30/24 13,653,390 13,653,390 1.00 13,653,390 1 5.55% TexPool AAAm 5.32%07/01/24 06/30/24 45,703,633 45,703,633 1.00 45,703,633 1 5.32% TexSTAR AAAm 5.30%07/01/24 06/30/24 407,569,625 407,569,625 1.00 407,569,625 1 5.30% Veritex Community Bank CD 5.45%07/15/24 07/14/23 10,513,297 10,513,297 100.00 10,513,297 15 5.59% East West Bank CD 5.68%07/16/24 10/16/23 7,287,872 7,287,872 100.00 7,287,872 16 5.68%East West Bank CD 5.50%07/17/24 07/17/23 5,270,755 5,270,755 100.00 5,270,755 17 5.65% East West Bank CD 5.32%07/17/24 01/17/24 21,090,207 21,090,207 100.00 21,090,207 17 5.46% East West Bank CD 5.72%07/22/24 10/20/23 20,815,408 20,815,408 100.00 20,815,408 22 5.89% Independent Financial CD 4.50%07/24/24 01/23/23 10,573,289 10,573,289 100.00 10,573,289 24 4.58%FHLB Aaa/AA+5.18%07/26/24 02/28/23 10,000,000 10,000,000 99.96 9,997,355 26 5.18% East West Bank CD 5.29%08/01/24 02/01/24 10,221,243 10,221,243 100.00 10,221,243 32 5.43% Alliance Bank CD 5.80%08/02/24 08/01/23 5,219,238 5,219,238 100.00 5,219,238 33 5.93% Veritex Community Bank CD 5.53%08/05/24 08/23/23 5,235,912 5,235,912 100.00 5,235,912 36 5.67% East West Bank CD 5.52%08/19/24 08/17/23 5,247,111 5,247,111 100.00 5,247,111 50 5.67% FFCB Aaa/AA+4.88%08/21/24 02/27/23 4,000,000 3,998,267 99.85 3,996,196 52 5.19% Alliance Bank CD 5.70%09/06/24 09/07/23 10,427,595 10,427,595 100.00 10,427,595 68 5.82% Veritex Community Bank CD 5.56%09/11/24 09/13/23 10,425,207 10,425,207 100.00 10,425,207 73 5.70% East West Bank CD 5.42%09/11/24 03/11/24 4,184,737 4,184,737 100.00 4,184,737 73 5.57% East West Bank CD 5.42%09/18/24 03/18/24 7,109,990 7,109,990 100.00 7,109,990 80 5.57% Veritex Community Bank CD 5.56%09/25/24 09/25/23 10,477,530 10,477,530 100.00 10,477,530 87 5.70% Alliance Bank CD 5.40%09/27/24 01/02/24 10,266,574 10,266,574 100.00 10,266,574 89 5.51% Alliance Bank CD 5.85%10/10/24 10/10/23 7,720,369 7,720,369 100.00 7,720,369 102 5.98% Veritex Community Bank CD 5.54%10/16/24 10/16/23 2,594,100 2,594,100 100.00 2,594,100 108 5.68% East West Bank CD 5.09%10/18/24 01/18/24 10,726,208 10,726,208 100.00 10,726,208 110 5.22% East West Bank CD 5.13%10/28/24 01/26/24 4,249,093 4,249,093 100.00 4,249,093 120 5.26% Alliance Bank CD 5.75%11/01/24 08/01/23 5,217,321 5,217,321 100.00 5,217,321 124 5.88% Bank OZK CD 5.50%11/13/24 11/13/23 10,388,568 10,388,568 100.00 10,388,568 136 5.65% East West Bank CD 5.23%11/20/24 02/20/24 12,229,111 12,229,111 100.00 12,229,111 143 5.37% Veritex Community Bank CD 5.15%12/11/24 12/11/23 20,521,998 20,521,998 100.00 20,521,998 164 5.27% East West Bank CD 5.48%12/11/24 06/11/24 5,232,692 5,232,692 100.00 5,232,692 164 5.63%Alliance Bank CD 5.10%12/13/24 12/15/22 10,790,547 10,790,547 100.00 10,790,547 166 5.20% T-Note Aaa/AA+1.00%12/15/24 06/14/23 5,000,000 4,914,509 97.12 4,903,711 168 4.91% East West Bank CD 5.04%12/16/24 12/15/23 10,278,574 10,278,574 100.00 10,278,574 169 5.17% East West Bank CD 5.22%12/18/24 03/18/24 6,473,228 6,473,228 100.00 6,473,228 171 5.36%BOK Financial CD 5.07%12/19/24 12/21/23 10,271,674 10,271,674 100.00 10,271,674 172 5.20% June 30, 2024 City of Georgetown Valley View Consulting, L.L.C.3 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, 2024 Alliance Bank CD 5.50%12/19/24 06/20/24 10,000,000 10,000,000 100.00 10,000,000 172 5.65% Alliance Bank CD 5.50%12/20/24 06/20/24 5,000,000 5,000,000 100.00 5,000,000 173 5.64% Third Coast Bank CD 5.10%12/28/24 03/28/24 8,450,996 8,450,996 100.00 8,450,996 181 5.22% Alliance Bank CD 5.30%01/09/25 01/11/24 10,000,000 10,000,000 100.00 10,000,000 193 5.44% East West Bank CD 4.85%01/13/25 01/12/24 10,621,697 10,621,697 100.00 10,621,697 197 4.97% East West Bank CD 5.35%01/16/25 04/16/24 7,286,519 7,286,519 100.00 7,286,519 200 5.50% Veritex Community Bank CD 4.88%01/23/25 01/23/24 10,709,901 10,709,901 100.00 10,709,901 207 4.99% East West Bank CD 5.35%02/03/25 05/02/24 21,047,598 21,047,598 100.00 21,047,598 218 5.50% Veritex Community Bank CD 4.94%02/12/25 02/12/24 10,164,773 10,164,773 100.00 10,164,773 227 5.05%East West Bank CD 5.37%02/18/25 05/15/24 5,457,481 5,457,481 100.00 5,457,481 233 5.52% Alliance Bank CD 5.70%02/24/25 08/23/23 5,216,208 5,216,208 100.00 5,216,208 239 5.82% BOK Financial CDARS 5.10%03/13/25 03/14/24 10,153,402 10,153,402 100.00 10,153,402 256 5.23% Alliance Bank CD 5.45%03/20/25 06/20/24 10,000,000 10,000,000 100.00 10,000,000 263 5.59%Alliance Bank CD 5.45%03/20/25 06/20/24 5,000,000 5,000,000 100.00 5,000,000 263 5.59% East West Bank CD 5.14%03/25/25 03/25/24 8,111,162 8,111,162 100.00 8,111,162 268 5.27% East West Bank CD 5.24%04/17/25 04/17/24 5,272,705 5,272,705 100.00 5,272,705 291 5.38% East West Bank CD 5.24%04/18/25 04/18/24 10,106,794 10,106,794 100.00 10,106,794 292 5.38% Bank OZK CD 5.37%04/20/25 10/20/23 5,182,737 5,182,737 100.00 5,182,737 294 5.20% Alliance Bank CD 5.20%05/27/25 02/27/24 10,166,286 10,166,286 100.00 10,166,286 331 5.33% Alliance Bank CD 5.40%06/20/25 06/20/24 10,000,000 10,000,000 100.00 10,000,000 355 5.55% Alliance Bank CD 5.40%06/20/25 06/20/24 5,000,000 5,000,000 100.00 5,000,000 355 5.54% Third Coast Bank CD 5.10%06/28/25 06/28/23 10,520,578 10,520,578 100.00 10,520,578 363 5.20% Alliance Bank CD 4.90%07/11/25 01/12/24 5,325,535 5,325,535 100.00 5,325,535 376 4.99% FHLB Aaa/AA+4.65%08/13/25 02/13/24 10,000,000 10,000,000 99.83 9,983,015 409 4.65% FAMC 5.14%10/02/25 04/30/24 10,000,000 10,000,000 100.10 10,010,499 459 5.14% T-Note Aaa/AA+4.95%11/15/25 05/07/24 8,000,000 7,952,590 99.39 7,951,250 503 4.95% FHLMC Aaa/AA+0.00%12/11/25 02/12/24 10,000,000 9,366,631 93.33 9,333,272 529 4.61% Alliance Bank CD 5.30%12/19/25 06/20/24 10,000,000 10,000,000 100.00 10,000,000 537 5.43% TOTALS 1,024,617,877$ 1,023,849,874$ 1,023,793,175$ 97 5.35% (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.4 City - Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 03/31/24 Increases Decreases Book Value 06/30/24 Market Value 03/31/24 Change in Market Value Market Value 06/30/24 Wells Fargo Bank Cash 0.00%07/01/24 20,667$ 100,569$ –$ 121,236$ 20,667$ 100,569$ 121,236$ Wells Fargo Bank Sweep-MMF 5.19%07/01/24 13,333,434 3,854,481 – 17,187,916 13,333,434 3,854,481 17,187,916 Veritex Community Bank MMA 5.33%07/01/24 3,481,788 46,469 – 3,528,257 3,481,788 46,469 3,528,257 NexBank MMA 5.55%07/01/24 13,465,784 187,606 – 13,653,390 13,465,784 187,606 13,653,390 Alliance Bank MMA 5.30%2,929 – (2,929) – 2,929 (2,929) – TexPool 5.32%07/01/24 34,509,710 11,193,923 – 45,703,633 34,509,710 11,193,923 45,703,633 TexSTAR 5.30%07/01/24 252,672,000 154,897,625 – 407,569,625 252,672,000 154,897,625 407,569,625 Third Coast Bank CD 5.77%03/28/24 8,343,827 – (8,343,827) – 8,343,827 (8,343,827) – East West Bank CD 5.95%04/16/24 7,188,711 – (7,188,711) – 7,188,711 (7,188,711) – East West Bank CD 5.78%04/17/24 5,203,408 – (5,203,408) – 5,203,408 (5,203,408) – Bank OZK CD 5.04%04/18/24 10,461,879 – (10,461,879) – 10,461,879 (10,461,879) – East West Bank CD 5.04%04/26/24 10,470,344 – (10,470,344) – 10,470,344 (10,470,344) – East West Bank CD 5.79%05/02/24 20,763,805 – (20,763,805) – 20,763,805 (20,763,805) – Independent Financial CD 5.08%05/09/24 8,398,663 – (8,398,663) – 8,398,663 (8,398,663) – T-Note 4.72%05/15/24 1,989,461 – (1,989,461) – 1,987,766 (1,987,766) – East West Bank CD 5.80%05/15/24 5,383,155 – (5,383,155) – 5,383,155 (5,383,155) – Bank OZK CD 5.65%05/16/24 5,091,993 – (5,091,993) – 5,091,993 (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,159,885 – (5,159,885) – 5,159,885 (5,159,885) – Alliance Bank CD 5.20%06/14/24 10,653,597 – (10,653,597) – 10,653,597 (10,653,597) – East West Bank CD 5.46%06/17/24 16,122,477 – (16,122,477) – 16,122,477 (16,122,477) – Alliance Bank CD 5.20%06/27/24 13,956,839 – (13,956,839) – 13,956,839 (13,956,839) – Veritex Community Bank CD 5.59%07/15/24 10,370,189 143,108 – 10,513,297 10,370,189 143,108 10,513,297 East West Bank CD 5.68%07/16/24 7,185,403 102,469 – 7,287,872 7,185,403 102,469 7,287,872 East West Bank CD 5.65%07/17/24 5,198,980 71,776 – 5,270,755 5,198,980 71,776 5,270,755 East West Bank CD 5.46%07/17/24 20,812,342 277,864 – 21,090,207 20,812,342 277,864 21,090,207 East West Bank CD 5.89%07/22/24 20,520,693 294,715 – 20,815,408 20,520,693 294,715 20,815,408 Independent Financial CD 4.58%07/24/24 10,456,299 116,991 – 10,573,289 10,456,299 116,991 10,573,289 FHLB 5.18%07/26/24 10,000,000 – – 10,000,000 9,996,454 901 9,997,355 East West Bank CD 5.43%08/01/24 10,087,332 133,911 – 10,221,243 10,087,332 133,911 10,221,243 Alliance Bank CD 5.93%08/02/24 5,145,648 73,590 – 5,219,238 5,145,648 73,590 5,219,238 Veritex Community Bank CD 5.67%08/05/24 5,163,603 72,308 – 5,235,912 5,163,603 72,308 5,235,912 East West Bank CD 5.67%08/19/24 5,175,399 71,712 – 5,247,111 5,175,399 71,712 5,247,111 FFCB 5.19%08/21/24 3,995,274 2,993 – 3,998,267 3,993,856 2,340 3,996,196 Alliance Bank CD 5.82%09/06/24 10,279,902 147,693 – 10,427,595 10,279,902 147,693 10,427,595 Veritex Community Bank CD 5.70%09/11/24 10,280,460 144,747 – 10,425,207 10,280,460 144,747 10,425,207 East West Bank CD 5.57%09/11/24 4,128,573 56,163 – 4,184,737 4,128,573 56,163 4,184,737 East West Bank CD 5.57%09/18/24 7,014,566 95,423 – 7,109,990 7,014,566 95,423 7,109,990 Veritex Community Bank CD 5.70%09/25/24 10,332,057 145,473 – 10,477,530 10,332,057 145,473 10,477,530 Alliance Bank CD 5.51%09/27/24 10,128,712 137,861 – 10,266,574 10,128,712 137,861 10,266,574 Alliance Bank CD 5.98%10/10/24 7,609,387 110,982 – 7,720,369 7,609,387 110,982 7,720,369 Veritex Community Bank CD 5.68%10/16/24 2,558,211 35,889 – 2,594,100 2,558,211 35,889 2,594,100 East West Bank CD 5.22%10/18/24 10,590,960 135,248 – 10,726,208 10,590,960 135,248 10,726,208 East West Bank CD 5.26%10/28/24 4,195,097 53,995 – 4,249,093 4,195,097 53,995 4,249,093 City of Georgetown Valley View Consulting, L.L.C.6 City - Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 03/31/24 Increases Decreases Book Value 06/30/24 Market Value 03/31/24 Change in Market Value Market Value 06/30/24 Alliance Bank CD 5.88%11/01/24 5,144,384 72,937 – 5,217,321 5,144,384 72,937 5,217,321 Bank OZK CD 5.65%11/13/24 10,245,556 143,012 – 10,388,568 10,245,556 143,012 10,388,568 East West Bank CD 5.37%11/20/24 12,070,700 158,411 – 12,229,111 12,070,700 158,411 12,229,111 Veritex Community Bank CD 5.27%12/11/24 20,257,895 264,103 – 20,521,998 20,257,895 264,103 20,521,998 East West Bank CD 5.63%12/11/24 – 5,232,692 – 5,232,692 – 5,232,692 5,232,692 Alliance Bank CD 5.20%12/13/24 10,653,597 136,950 – 10,790,547 10,653,597 136,950 10,790,547 T-Note 4.91%12/15/24 4,868,201 46,308 – 4,914,509 4,856,104 47,607 4,903,711 East West Bank CD 5.17%12/16/24 10,150,236 128,338 – 10,278,574 10,150,236 128,338 10,278,574 East West Bank CD 5.36%12/18/24 6,389,536 83,692 – 6,473,228 6,389,536 83,692 6,473,228 BOK Financial CD 5.20%12/19/24 10,142,671 129,002 – 10,271,674 10,142,671 129,002 10,271,674 Alliance Bank CD 5.65%12/19/24 – 10,000,000 – 10,000,000 – 10,000,000 10,000,000 Alliance Bank CD 5.64%12/20/24 – 5,000,000 – 5,000,000 – 5,000,000 5,000,000 Third Coast Bank CD 5.22%12/28/24 – 8,450,996 – 8,450,996 – 8,450,996 8,450,996 Alliance Bank CD 5.44%01/09/25 10,000,000 – – 10,000,000 10,000,000 – 10,000,000 East West Bank CD 4.97%01/13/25 10,494,044 127,653 – 10,621,697 10,494,044 127,653 10,621,697 East West Bank CD 5.50%01/16/25 – 7,286,519 – 7,286,519 – 7,286,519 7,286,519 Veritex Community Bank CD 4.99%01/23/25 10,579,239 130,662 – 10,709,901 10,579,239 130,662 10,709,901 East West Bank CD 5.50%02/03/25 – 21,047,598 – 21,047,598 – 21,047,598 21,047,598 Veritex Community Bank CD 5.05%02/12/25 10,039,249 125,523 – 10,164,773 10,039,249 125,523 10,164,773 East West Bank CD 5.52%02/18/25 – 5,457,481 – 5,457,481 – 5,457,481 5,457,481 Alliance Bank CD 5.82%02/24/25 5,143,911 72,297 – 5,216,208 5,143,911 72,297 5,216,208 BOK Financial CDARS 5.23%03/13/25 10,025,172 128,230 – 10,153,402 10,025,172 128,230 10,153,402 Alliance Bank CD 5.59%03/20/25 – 10,000,000 – 10,000,000 – 10,000,000 10,000,000 Alliance Bank CD 5.59%03/20/25 – 5,000,000 – 5,000,000 – 5,000,000 5,000,000 East West Bank CD 5.27%03/25/25 8,007,889 103,272 – 8,111,162 8,007,889 103,272 8,111,162 East West Bank CD 5.38%04/17/25 – 5,272,705 – 5,272,705 – 5,272,705 5,272,705 East West Bank CD 5.38%04/18/25 – 10,106,794 – 10,106,794 – 10,106,794 10,106,794 Bank OZK CD 5.20%04/20/25 5,113,065 69,672 – 5,182,737 5,113,065 69,672 5,182,737 Alliance Bank CD 5.33%05/27/25 10,039,890 126,396 – 10,166,286 10,039,890 126,396 10,166,286 Alliance Bank CD 5.55%06/20/25 – 10,000,000 – 10,000,000 – 10,000,000 10,000,000 Alliance Bank CD 5.54%06/20/25 – 5,000,000 – 5,000,000 – 5,000,000 5,000,000 Third Coast Bank CD 5.20%06/28/25 10,387,415 133,163 – 10,520,578 10,387,415 133,163 10,520,578 Alliance Bank CD 4.99%07/11/25 5,264,752 60,783 – 5,325,535 5,264,752 60,783 5,325,535 FHLB 4.65%08/13/25 10,000,000 – – 10,000,000 9,968,550 14,465 9,983,015 FAMC 5.14%10/02/25 – 10,000,000 – 10,000,000 – 10,010,499 10,010,499 T-Note 4.95%11/15/25 – 7,952,590 – 7,952,590 – 7,951,250 7,951,250 FHLMC 4.61%12/11/25 9,259,675 106,955 – 9,366,631 9,232,964 100,309 9,333,272 Alliance Bank CD 5.43%12/19/25 – 10,000,000 – 10,000,000 – 10,000,000 10,000,000 TOTAL / AVERAGE 5.35%850,180,524$ 310,860,323$ (137,190,973)$ 1,023,849,874$ 850,103,605$ 173,689,570$ 1,023,793,175$ City of Georgetown Valley View Consulting, L.L.C.7 City - Allocation Investment Total Consolidated Debt Service 2015 GO-Roads 2015 Revenue Water WW Garey Park Donation 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 121,236$ 121,236$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ Wells Fargo Bank Sweep-MMF 17,187,916 17,187,916 – – – – – – – – – – – – – Veritex Community Bank MMA 3,528,257 3,528,257 – – – – – – – – – – – – – NexBank MMA 13,653,390 13,653,390 – – – – – – – – – – – – – TexPool 45,703,633 45,703,633 – – – – – – – – – – – – – TexSTAR 407,569,625 68,300,169 37,252,074 1,014,976 1 1,160,016 66,172 204,503 348,746 1,470,225 21,277 2,663,257 25,676 734,494 206,963 Veritex Community Bank CD 07/15/24 10,513,297 10,513,297 – – – – – – – – – – – – – East West Bank CD 07/16/24 7,287,872 – – – – – – – – – – – – – – East West Bank CD 07/17/24 5,270,755 – – – – – – – – – – – – – – East West Bank CD 07/17/24 21,090,207 – – – – – – – – – – – – – – East West Bank CD 07/22/24 20,815,408 – – – – – – – – – – – – – – Independent Financial CD 07/24/24 10,573,289 – – – – – – – – – – – – – – FHLB 07/26/24 10,000,000 – – – – – – – – – – – – – – East West Bank CD 08/01/24 10,221,243 – – – – – – – – – – – – – – Alliance Bank CD 08/02/24 5,219,238 5,219,238 – – – – – – – – – – – – – Veritex Community Bank CD 08/05/24 5,235,912 – – – – – – – – – – – – – – East West Bank CD 08/19/24 5,247,111 5,247,111 – – – – – – – – – – – – – FFCB 08/21/24 3,998,267 3,998,267 – – – – – – – – – – – – – Alliance Bank CD 09/06/24 10,427,595 – – – – – – – – – – – – – – Veritex Community Bank CD 09/11/24 10,425,207 – – – – – – – – – – – – – – East West Bank CD 09/11/24 4,184,737 – – – – – – – – – – – – – – East West Bank CD 09/18/24 7,109,990 – – – – – – – – – – – – – – Veritex Community Bank CD 09/25/24 10,477,530 10,477,530 – – – – – – – – – – – – – Alliance Bank CD 09/27/24 10,266,574 – – – – – – – – – – – – – – Alliance Bank CD 10/10/24 7,720,369 7,720,369 – – – – – – – – – – – – – Veritex Community Bank CD 10/16/24 2,594,100 2,594,100 – – – – – – – – – – – – – East West Bank CD 10/18/24 10,726,208 – – – – – – – – – – – – – – East West Bank CD 10/28/24 4,249,093 – – – – – – – – – – – – – – Alliance Bank CD 11/01/24 5,217,321 5,217,321 – – – – – – – – – – – – – Bank OZK CD 11/13/24 10,388,568 10,388,568 – – – – – – – – – – – – – East West Bank CD 11/20/24 12,229,111 – – – – – – – – – – – – – – Veritex Community Bank CD 12/11/24 20,521,998 20,521,998 – – – – – – – – – – – – – East West Bank CD 12/11/24 5,232,692 – – – – – – – – – – – – – – Alliance Bank CD 12/13/24 10,790,547 – – – – – – – – – – – – – – T-Note 12/15/24 4,914,509 4,914,509 – – – – – – – – – – – – – East West Bank CD 12/16/24 10,278,574 10,278,574 – – – – – – – – – – – – – East West Bank CD 12/18/24 6,473,228 – – – – – – – – – – – – – – BOK Financial CD 12/19/24 10,271,674 10,271,674 – – – – – – – – – – – – – Alliance Bank CD 12/19/24 10,000,000 – – – – – – – – – – – – – – Alliance Bank CD 12/20/24 5,000,000 – – – – – – – – – – – – – – Third Coast Bank CD 12/28/24 8,450,996 – – – – – – – – – – – – – – Alliance Bank CD 01/09/25 10,000,000 – – – – – – – – – – – – – – East West Bank CD 01/13/25 10,621,697 – – – – – – – – – – – – – – East West Bank CD 01/16/25 7,286,519 – – – – – – – – – – – – – – Veritex Community Bank CD 01/23/25 10,709,901 10,709,901 – – – – – – – – – – – – – East West Bank CD 02/03/25 21,047,598 – – – – – – – – – – – – – – Veritex Community Bank CD 02/12/25 10,164,773 10,164,773 – – – – – – – – – – – – – East West Bank CD 02/18/25 5,457,481 – – – – – – – – – – – – – – Alliance Bank CD 02/24/25 5,216,208 5,216,208 – – – – – – – – – – – – – BOK Financial CDARS 03/13/25 10,153,402 – – – – – – – – – – – – – – Alliance Bank CD 03/20/25 10,000,000 – – – – – – – – – – – – – – Alliance Bank CD 03/20/25 5,000,000 – – – – – – – – – – – – – – East West Bank CD 03/25/25 8,111,162 8,111,162 – – – – – – – – – – – – – East West Bank CD 04/17/25 5,272,705 – – – – – – – – – – – – – – East West Bank CD 04/18/25 10,106,794 – – – – – – – – – – – – – – Bank OZK CD 04/20/25 5,182,737 5,182,737 – – – – – – – – – – – – – Alliance Bank CD 05/27/25 10,166,286 10,166,286 – – – – – – – – – – – – – Alliance Bank CD 06/20/25 10,000,000 – – – – – – – – – – – – – – Alliance Bank CD 06/20/25 5,000,000 – – – – – – – – – – – – – – Third Coast Bank CD 06/28/25 10,520,578 10,520,578 – – – – – – – – – – – – – Alliance Bank CD 07/11/25 5,325,535 5,325,535 – – – – – – – – – – – – – FHLB 08/13/25 10,000,000 10,000,000 – – – – – – – – – – – – – FAMC 10/02/25 10,000,000 10,000,000 – – – – – – – – – – – – – T-Note 11/15/25 7,952,590 7,952,590 – – – – – – – – – – – – – FHLMC 12/11/25 9,366,631 9,366,631 – – – – – – – – – – – – – Alliance Bank CD 12/19/25 10,000,000 – – – – – – – – – – – – – – Totals 1,023,849,874$ 358,573,559$ 37,252,074$ 1,014,976$ 1$ 1,160,016$ 66,172$ 204,503$ 348,746$ 1,470,225$ 21,277$ 2,663,257$ 25,676$ 734,494$ 206,963$ Book Value June 30, 2024 City of Georgetown Valley View Consulting, L.L.C.8 City - Allocation Wells Fargo Bank CashWells Fargo Bank Sweep-MMFVeritex Community Bank MMANexBank MMATexPoolTexSTAR Veritex 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/24 East 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/24 Veritex 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/24 Veritex 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/24East West 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/24Alliance Bank CD 12/19/24Alliance Bank CD 12/20/24Third Coast Bank CD 12/28/24Alliance Bank CD 01/09/25East West Bank CD 01/13/25East West Bank CD 01/16/25 Veritex Community Bank CD 01/23/25East West Bank CD 02/03/25Veritex Community Bank CD 02/12/25East West Bank CD 02/18/25Alliance Bank CD 02/24/25BOK Financial CDARS 03/13/25 Alliance Bank CD 03/20/25Alliance Bank CD 03/20/25East West Bank CD 03/25/25East West Bank CD 04/17/25East West Bank CD 04/18/25Bank OZK CD 04/20/25Alliance Bank CD 05/27/25Alliance Bank CD 06/20/25Alliance Bank CD 06/20/25Third Coast Bank CD 06/28/25Alliance Bank CD 07/11/25FHLB08/13/25FAMC10/02/25T-Note 11/15/25FHLMC12/11/25Alliance Bank CD 12/19/25 Totals Book Value June 30, 2024 (Continued) City - 2021 GO Parks City - 2021 GO Roads 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 City - 2023 CO Stormwater –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,649 400,885 1,528,102 7,284,487 547,553 2,190,466 106,592 142,854 8,839,950 1,372,564 6,581,966 7,896,446 1,758,735 10,483 – – – – – – – – – – – – – – – – – – – – – – 7,287,872 – – – – – – – – – – – – – – – – 5,270,755 – – – – – – – – – – – – – – – – – – – – – – – – – – 20,815,408 – – – – – – – – – – – – – 10,573,289 – – – – – – – – – – – – – 10,000,000 – – – – – – – – – – – – – 10,221,243 – – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – 7,109,990 – –– – – – – – – – – – – – – –– – – – – – – – – – – – – 10,266,574 – – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – 10,726,208 – – – – – – – – – – – 4,249,093 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 12,229,111 – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,232,692 – – – – – – – – – – – – 10,790,547 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,473,228 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – – – – – – – – – – 10,621,697 – – – – – – – – – – – 7,286,519 – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – 5,457,481 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,153,402 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,106,794 – – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – 5,649$ 400,885$ 1,528,102$ 12,741,967$ 547,553$ 2,190,466$ 106,592$ 142,854$ 41,246,652$ 1,372,564$ 143,086,238$ 18,399,893$ 1,758,735$ 10,483$ City of Georgetown Valley View Consulting, L.L.C.9 City - Allocation Wells Fargo Bank CashWells Fargo Bank Sweep-MMFVeritex Community Bank MMANexBank MMATexPoolTexSTAR Veritex 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/24 East 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/24 Veritex 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/24 Veritex 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/24East West 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/24Alliance Bank CD 12/19/24Alliance Bank CD 12/20/24Third Coast Bank CD 12/28/24Alliance Bank CD 01/09/25East West Bank CD 01/13/25East West Bank CD 01/16/25 Veritex Community Bank CD 01/23/25East West Bank CD 02/03/25Veritex Community Bank CD 02/12/25East West Bank CD 02/18/25Alliance Bank CD 02/24/25BOK Financial CDARS 03/13/25 Alliance Bank CD 03/20/25Alliance Bank CD 03/20/25East West Bank CD 03/25/25East West Bank CD 04/17/25East West Bank CD 04/18/25Bank OZK CD 04/20/25Alliance Bank CD 05/27/25Alliance Bank CD 06/20/25Alliance Bank CD 06/20/25Third Coast Bank CD 06/28/25Alliance Bank CD 07/11/25FHLB08/13/25FAMC10/02/25T-Note 11/15/25FHLMC12/11/25Alliance Bank CD 12/19/25 Totals Book Value June 30, 2024 (Continued) City - 2023 GO Parks City - 2023 GO Roads City - 2023 Revenue Electric City - 2023 Revenue Water/WW City - 2024 CO Airport City - 2024 CO Downtown TIRZ City - 2024 CO Fac/Equip/Parks City - 2024 GO Facilities City - 2024 GO Roads City - 2024 Revenue Electric City - 2024 Revenue Water/WW City - American Rescue Plan City - Impact Fees - Transportation City - Impact Fees - Water –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,119,080 15,968,089 1,851,370 14,337,319 342,230 1,509,840 17,488,882 7,026,508 9,083,241 21,776,433 101,180,745 8,596,418 347,997 37,072,936 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 21,090,207 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,235,912 – – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– 10,427,595 – – – – – – – – – – – –– 10,425,207 – – – – – – – – – – – –4,184,737 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – – – – – – – – – – –– 5,000,000 – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – 21,047,598 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – – – – – – – – – – – – 5,000,000 – – – – – – – – – – – – – – – – – – – – 5,272,705 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – – – – – – – – – – – – 5,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – – – – 1,119,080$ 26,476,705$ 6,036,107$ 77,327,926$ 342,230$ 1,509,840$ 57,488,882$ 7,026,508$ 24,083,241$ 21,776,433$ 101,180,745$ 8,596,418$ 347,997$ 37,072,936$ City of Georgetown Valley View Consulting, L.L.C.10 City - Allocation Wells Fargo Bank CashWells Fargo Bank Sweep-MMFVeritex Community Bank MMANexBank MMATexPoolTexSTAR Veritex 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/24 East 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/24 Veritex 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/24 Veritex 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/24East West 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/24Alliance Bank CD 12/19/24Alliance Bank CD 12/20/24Third Coast Bank CD 12/28/24Alliance Bank CD 01/09/25East West Bank CD 01/13/25East West Bank CD 01/16/25 Veritex Community Bank CD 01/23/25East West Bank CD 02/03/25Veritex Community Bank CD 02/12/25East West Bank CD 02/18/25Alliance Bank CD 02/24/25BOK Financial CDARS 03/13/25 Alliance Bank CD 03/20/25Alliance Bank CD 03/20/25East West Bank CD 03/25/25East West Bank CD 04/17/25East West Bank CD 04/18/25Bank OZK CD 04/20/25Alliance Bank CD 05/27/25Alliance Bank CD 06/20/25Alliance Bank CD 06/20/25Third Coast Bank CD 06/28/25Alliance Bank CD 07/11/25FHLB08/13/25FAMC10/02/25T-Note 11/15/25FHLMC12/11/25Alliance Bank CD 12/19/25 Totals Book Value June 30, 2024 (Continued) City - Impact Fees - WW City - Limited Tax Note, Series 2022 –$ –$ – – – – – – – – 14,964,667 2,768,589 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,450,996 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 23,415,664$ 2,768,589$ City of Georgetown Valley View Consulting, L.L.C.11 City - Allocation Market Value Investment Total Consolidated Debt Service 2015 GO-Roads 2015 Revenue Water WW Garey Park Donation 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 121,236$ 121,236$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ Wells Fargo Bank Sweep-MMF 17,187,916 17,187,916 – – – – – – – – – – – – – Veritex Community Bank MMA 3,528,257 3,528,257 – – – – – – – – – – – – – NexBank MMA 13,653,390 13,653,390 – – – – – – – – – – – – – TexPool 45,703,633 45,703,633 – – – – – – – – – – – – – TexSTAR 407,569,625 68,300,169 37,252,074 1,014,976 1 1,160,016 66,172 204,503 348,746 1,470,225 21,277 2,663,257 25,676 734,494 206,963 Veritex Community Bank CD 07/15/24 10,513,297 10,513,297 – – – – – – – – – – – – – East West Bank CD 07/16/24 7,287,872 – – – – – – – – – – – – – – East West Bank CD 07/17/24 5,270,755 – – – – – – – – – – – – – – East West Bank CD 07/17/24 21,090,207 – – – – – – – – – – – – – – East West Bank CD 07/22/24 20,815,408 – – – – – – – – – – – – – – Independent Financial CD 07/24/24 10,573,289 – – – – – – – – – – – – – – FHLB 07/26/24 9,997,355 – – – – – – – – – – – – – – East West Bank CD 08/01/24 10,221,243 – – – – – – – – – – – – – – Alliance Bank CD 08/02/24 5,219,238 5,219,238 – – – – – – – – – – – – – Veritex Community Bank CD 08/05/24 5,235,912 – – – – – – – – – – – – – – East West Bank CD 08/19/24 5,247,111 5,247,111 – – – – – – – – – – – – – FFCB 08/21/24 3,996,196 3,996,196 – – – – – – – – – – – – – Alliance Bank CD 09/06/24 10,427,595 – – – – – – – – – – – – – – Veritex Community Bank CD 09/11/24 10,425,207 – – – – – – – – – – – – – – East West Bank CD 09/11/24 4,184,737 – – – – – – – – – – – – – – East West Bank CD 09/18/24 7,109,990 – – – – – – – – – – – – – – Veritex Community Bank CD 09/25/24 10,477,530 10,477,530 – – – – – – – – – – – – – Alliance Bank CD 09/27/24 10,266,574 – – – – – – – – – – – – – – Alliance Bank CD 10/10/24 7,720,369 7,720,369 – – – – – – – – – – – – – Veritex Community Bank CD 10/16/24 2,594,100 2,594,100 – – – – – – – – – – – – – East West Bank CD 10/18/24 10,726,208 – – – – – – – – – – – – – – East West Bank CD 10/28/24 4,249,093 – – – – – – – – – – – – – – Alliance Bank CD 11/01/24 5,217,321 5,217,321 – – – – – – – – – – – – – Bank OZK CD 11/13/24 10,388,568 10,388,568 – – – – – – – – – – – – – East West Bank CD 11/20/24 12,229,111 – – – – – – – – – – – – – – Veritex Community Bank CD 12/11/24 20,521,998 20,521,998 – – – – – – – – – – – – – East West Bank CD 12/11/24 5,232,692 – – – – – – – – – – – – – – Alliance Bank CD 12/13/24 10,790,547 – – – – – – – – – – – – – – T-Note 12/15/24 4,903,711 4,903,711 – – – – – – – – – – – – – East West Bank CD 12/16/24 10,278,574 10,278,574 – – – – – – – – – – – – – East West Bank CD 12/18/24 6,473,228 – – – – – – – – – – – – – – BOK Financial CD 12/19/24 10,271,674 10,271,674 – – – – – – – – – – – – – Alliance Bank CD 12/19/24 10,000,000 – – – – – – – – – – – – – – Alliance Bank CD 12/20/24 5,000,000 – – – – – – – – – – – – – – Third Coast Bank CD 12/28/24 8,450,996 – – – – – – – – – – – – – – Alliance Bank CD 01/09/25 10,000,000 – – – – – – – – – – – – – – East West Bank CD 01/13/25 10,621,697 – – – – – – – – – – – – – – East West Bank CD 01/16/25 7,286,519 – – – – – – – – – – – – – – Veritex Community Bank CD 01/23/25 10,709,901 10,709,901 – – – – – – – – – – – – – East West Bank CD 02/03/25 21,047,598 – – – – – – – – – – – – – – Veritex Community Bank CD 02/12/25 10,164,773 10,164,773 – – – – – – – – – – – – – East West Bank CD 02/18/25 5,457,481 – – – – – – – – – – – – – – Alliance Bank CD 02/24/25 5,216,208 5,216,208 – – – – – – – – – – – – – BOK Financial CDARS 03/13/25 10,153,402 – – – – – – – – – – – – – – Alliance Bank CD 03/20/25 10,000,000 – – – – – – – – – – – – – – Alliance Bank CD 03/20/25 5,000,000 – – – – – – – – – – – – – – East West Bank CD 03/25/25 8,111,162 8,111,162 – – – – – – – – – – – – – East West Bank CD 04/17/25 5,272,705 – – – – – – – – – – – – – – East West Bank CD 04/18/25 10,106,794 – – – – – – – – – – – – – – Bank OZK CD 04/20/25 5,182,737 5,182,737 – – – – – – – – – – – – – Alliance Bank CD 05/27/25 10,166,286 10,166,286 – – – – – – – – – – – – – Alliance Bank CD 06/20/25 10,000,000 – – – – – – – – – – – – – – Alliance Bank CD 06/20/25 5,000,000 – – – – – – – – – – – – – – Third Coast Bank CD 06/28/25 10,520,578 10,520,578 – – – – – – – – – – – – – Alliance Bank CD 07/11/25 5,325,535 5,325,535 – – – – – – – – – – – – – FHLB 08/13/25 9,983,015 9,983,015 – – – – – – – – – – – – – FAMC 10/02/25 10,010,499 10,010,499 – – – – – – – – – – – – – T-Note 11/15/25 7,951,250 7,951,250 – – – – – – – – – – – – – FHLMC 12/11/25 9,333,272 9,333,272 – – – – – – – – – – – – – Alliance Bank CD 12/19/25 10,000,000 – – – – – – – – – – – – – – Totals 1,023,793,175$ 358,519,505$ 37,252,074$ 1,014,976$ 1$ 1,160,016$ 66,172$ 204,503$ 348,746$ 1,470,225$ 21,277$ 2,663,257$ 25,676$ 734,494$ 206,963$ June 30, 2024 City of Georgetown Valley View Consulting, L.L.C.12 City - Allocation Market Value Wells Fargo Bank CashWells Fargo Bank Sweep-MMFVeritex Community Bank MMANexBank MMATexPoolTexSTAR Veritex 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/24 Independent 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/24 Alliance 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/24 East West Bank CD 11/20/24Veritex Community Bank CD 12/11/24East West Bank CD 12/11/24Alliance Bank CD 12/13/24T-Note 12/15/24East West Bank CD 12/16/24 East West Bank CD 12/18/24BOK Financial CD 12/19/24Alliance Bank CD 12/19/24Alliance Bank CD 12/20/24Third Coast Bank CD 12/28/24Alliance Bank CD 01/09/25East West Bank CD 01/13/25East West Bank CD 01/16/25Veritex Community Bank CD 01/23/25East West Bank CD 02/03/25Veritex Community Bank CD 02/12/25East West Bank CD 02/18/25Alliance Bank CD 02/24/25BOK Financial CDARS 03/13/25Alliance Bank CD 03/20/25Alliance Bank CD 03/20/25East West Bank CD 03/25/25East West Bank CD 04/17/25East West Bank CD 04/18/25 Bank OZK CD 04/20/25Alliance Bank CD 05/27/25Alliance Bank CD 06/20/25Alliance Bank CD 06/20/25Third Coast Bank CD 06/28/25Alliance Bank CD 07/11/25 FHLB 08/13/25FAMC10/02/25T-Note 11/15/25FHLMC12/11/25Alliance Bank CD 12/19/25 Totals June 30, 2024 (Continued) City - 2021 GO Parks City - 2021 GO Roads 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 City - 2023 CO Stormwater –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,649 400,885 1,528,102 7,284,487 547,553 2,190,466 106,592 142,854 8,839,950 1,372,564 6,581,966 7,896,446 1,758,735 10,483 – – – – – – – – – – – – – – – – – – – – – – 7,287,872 – – – – – – – – – – – – – – – – 5,270,755 – – – – – – – – – – – – – – – – – – – – – – – – – – 20,815,408 – – – – – – – – – – – – – 10,573,289 – – – – – – – – – – – – – 9,997,355 – – – – – – – – – – – – – 10,221,243 – – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – 7,109,990 – –– – – – – – – – – – – – – –– – – – – – – – – – – – – 10,266,574 – – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – 10,726,208 – – – – – – – – – – – 4,249,093 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 12,229,111 – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,232,692 – – – – – – – – – – – – 10,790,547 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,473,228 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – – – – – – – – – – 10,621,697 – – – – – – – – – – – 7,286,519 – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – 5,457,481 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,153,402 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,106,794 – – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – 5,649$ 400,885$ 1,528,102$ 12,741,967$ 547,553$ 2,190,466$ 106,592$ 142,854$ 41,246,652$ 1,372,564$ 143,083,593$ 18,399,893$ 1,758,735$ 10,483$ City of Georgetown Valley View Consulting, L.L.C.13 City - Allocation Market Value Wells Fargo Bank CashWells Fargo Bank Sweep-MMFVeritex Community Bank MMANexBank MMATexPoolTexSTAR Veritex 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/24 Independent 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/24 Alliance 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/24 East West Bank CD 11/20/24Veritex Community Bank CD 12/11/24East West Bank CD 12/11/24Alliance Bank CD 12/13/24T-Note 12/15/24East West Bank CD 12/16/24 East West Bank CD 12/18/24BOK Financial CD 12/19/24Alliance Bank CD 12/19/24Alliance Bank CD 12/20/24Third Coast Bank CD 12/28/24Alliance Bank CD 01/09/25East West Bank CD 01/13/25East West Bank CD 01/16/25Veritex Community Bank CD 01/23/25East West Bank CD 02/03/25Veritex Community Bank CD 02/12/25East West Bank CD 02/18/25Alliance Bank CD 02/24/25BOK Financial CDARS 03/13/25Alliance Bank CD 03/20/25Alliance Bank CD 03/20/25East West Bank CD 03/25/25East West Bank CD 04/17/25East West Bank CD 04/18/25 Bank OZK CD 04/20/25Alliance Bank CD 05/27/25Alliance Bank CD 06/20/25Alliance Bank CD 06/20/25Third Coast Bank CD 06/28/25Alliance Bank CD 07/11/25 FHLB 08/13/25FAMC10/02/25T-Note 11/15/25FHLMC12/11/25Alliance Bank CD 12/19/25 Totals June 30, 2024 (Continued) City - 2023 GO Parks City - 2023 GO Roads City - 2023 Revenue Electric City - 2023 Revenue Water/WW City - 2024 CO Airport City - 2024 CO Downtown TIRZ City - 2024 CO Fac/Equip/Parks City - 2024 GO Facilities City - 2024 GO Roads City - 2024 Revenue Electric City - 2024 Revenue Water/WW City - American Rescue Plan City - Impact Fees - Transportation City - Impact Fees - Water –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,119,080 15,968,089 1,851,370 14,337,319 342,230 1,509,840 17,488,882 7,026,508 9,083,241 21,776,433 101,180,745 8,596,418 347,997 37,072,936 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 21,090,207 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,235,912 – – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– 10,427,595 – – – – – – – – – – – –– 10,425,207 – – – – – – – – – – – –4,184,737 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – – – – – – – – – – –– 5,000,000 – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – 21,047,598 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – – – – – – – – – – – – 5,000,000 – – – – – – – – – – – – – – – – – – – – 5,272,705 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – – – – – – – – – – – – 5,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – – – – 1,119,080$ 26,476,705$ 6,036,107$ 77,327,926$ 342,230$ 1,509,840$ 57,488,882$ 7,026,508$ 24,083,241$ 21,776,433$ 101,180,745$ 8,596,418$ 347,997$ 37,072,936$ City of Georgetown Valley View Consulting, L.L.C.14 City - Allocation Market Value Wells Fargo Bank CashWells Fargo Bank Sweep-MMFVeritex Community Bank MMANexBank MMATexPoolTexSTAR Veritex 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/24 Independent 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/24 Alliance 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/24 East West Bank CD 11/20/24Veritex Community Bank CD 12/11/24East West Bank CD 12/11/24Alliance Bank CD 12/13/24T-Note 12/15/24East West Bank CD 12/16/24 East West Bank CD 12/18/24BOK Financial CD 12/19/24Alliance Bank CD 12/19/24Alliance Bank CD 12/20/24Third Coast Bank CD 12/28/24Alliance Bank CD 01/09/25East West Bank CD 01/13/25East West Bank CD 01/16/25Veritex Community Bank CD 01/23/25East West Bank CD 02/03/25Veritex Community Bank CD 02/12/25East West Bank CD 02/18/25Alliance Bank CD 02/24/25BOK Financial CDARS 03/13/25Alliance Bank CD 03/20/25Alliance Bank CD 03/20/25East West Bank CD 03/25/25East West Bank CD 04/17/25East West Bank CD 04/18/25 Bank OZK CD 04/20/25Alliance Bank CD 05/27/25Alliance Bank CD 06/20/25Alliance Bank CD 06/20/25Third Coast Bank CD 06/28/25Alliance Bank CD 07/11/25 FHLB 08/13/25FAMC10/02/25T-Note 11/15/25FHLMC12/11/25Alliance Bank CD 12/19/25 Totals June 30, 2024 (Continued) City - Impact Fees - WW City - Limited Tax Note, Series 2022 –$ –$ – – – – – – – – 14,964,667 2,768,589 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,450,996 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 23,415,664$ 2,768,589$ City of Georgetown Valley View Consulting, L.L.C.15 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 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 Third Coast Bank CD 03/28/24 8,343,827 – – – – – – – – – – – – – – 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 – – – – – – – – – – – – – 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$ March 31, 2024 Book Value City of Georgetown Valley View Consulting, L.L.C.16 City - Allocation Wells Fargo Bank CashWells Fargo Bank Sweep-MMFVeritex Community Bank MMANexBank MMAAlliance Bank MMATexPoolTexSTAR Third Coast Bank CD 03/28/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/24 Independent 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/24 Alliance 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/24 East 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/24 Alliance 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/24 East West Bank CD 12/16/24East West Bank CD 12/18/24BOK Financial CD 12/19/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 Book Value (Continued) City - 2021 CO Fac/Equip/ Parks 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 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,929 – – – – – – – – – – – – – – 259,303 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 – – – – – – – – – – – – – – – – – – – – – – – – – 7,188,711 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,461,879 – – – – – – – – – – – – – – – – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – 5,383,155 – – – – – – – – – – – – – 5,091,993 – – – – – – – – – – – – – –– – – – – – 8,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,653,597 – – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – 7,185,403 – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – 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 – – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – – – – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – – 259,303$ 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$ City of Georgetown Valley View Consulting, L.L.C.17 City - Allocation Wells Fargo Bank CashWells Fargo Bank Sweep-MMFVeritex Community Bank MMANexBank MMAAlliance Bank MMATexPoolTexSTAR Third Coast Bank CD 03/28/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/24 Independent 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/24 Alliance 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/24 East 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/24 Alliance 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/24 East West Bank CD 12/16/24East West Bank CD 12/18/24BOK Financial CD 12/19/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 Book Value (Continued) City - 2023 CO Fac/Equip/Parks City - 2023 CO Solid Waste 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 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,757,470 4,194,665 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 – – – – – – – – – 8,343,827 – – – – – – – – – – – – – – – – 5,203,408 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 20,763,805 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,159,885 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,198,980 – – – – – – – – – – – – – – – – 20,812,342 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,163,603 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,279,902 – – – – – – – – – – 10,280,460 – – – – – – – – – 4,128,573 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 19,116,335$ 4,194,665$ 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.18 City - Allocation Market Value Investment Total Consolidated 2014 Revenue Water WW 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 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 Third Coast Bank CD 03/28/24 8,343,827 – – – – – – – – – – – – – – 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 – – – – – – – – – – – – – 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$ March 31, 2024 City of Georgetown Valley View Consulting, L.L.C.19 City - Allocation Market Value Wells Fargo Bank CashWells Fargo Bank Sweep-MMFVeritex Community Bank MMANexBank MMAAlliance Bank MMATexPool TexSTAR Third Coast Bank CD 03/28/24East West Bank CD 04/16/24East West Bank CD 04/17/24Bank OZK CD 04/18/24 East 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/24 East 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/24 Alliance 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/24 East 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/24Alliance Bank CD 01/09/25East West Bank CD 01/13/25 Veritex 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/25 Alliance 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 CO Airport City - 2021 CO Fac/Equip/ Parks 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 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,929 – – – – – – – – – – – – – – 728,631 259,303 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 – – – – – – – – – – – – – – – – – – – – – – – – – 7,188,711 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,461,879 – – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – 5,383,155 – – – – – – – – – – – – – 5,091,993 – – – – – – – – – – – – – –– – – – – – 8,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,653,597 – – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – – – –– – – – – – – – – – – 7,185,403 – – – – – – – – – – – – – – – –– – – – – – – – – – – – – – – – – – – – – – – – – – 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 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 728,631$ 259,303$ 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$ City of Georgetown Valley View Consulting, L.L.C.20 City - Allocation Market Value Wells Fargo Bank CashWells Fargo Bank Sweep-MMFVeritex Community Bank MMANexBank MMAAlliance Bank MMATexPool TexSTAR Third Coast Bank CD 03/28/24East West Bank CD 04/16/24East West Bank CD 04/17/24Bank OZK CD 04/18/24 East 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/24 East 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/24 Alliance 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/24 East 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/24Alliance Bank CD 01/09/25East West Bank CD 01/13/25 Veritex 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/25 Alliance 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 Fac/Equip/Parks City - 2023 CO Solid Waste 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 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,757,470 4,194,665 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 – – – – – – – – 8,343,827 – – – – – – – – – – – – – – 5,203,408 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 20,763,805 – – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – – – – – – –– – – – 5,159,885 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,198,980 – – – – – – – – – – – – – – 20,812,342 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,163,603 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,279,902 – – – – – – – – – 10,280,460 – – – – – – – – 4,128,573 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 19,116,335$ 4,194,665$ 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.21 GTEC Investment Report City of Georgetown | FY2024 Quarterly Financial Report Page 63 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield Pools/MMAs 14,517,289$ 14,517,289$ 23,994,405$ 23,994,405$ 5.31% CDs/Securities 23,653,409 23,653,409 23,738,873 23,738,873 5.58%Totals 38,170,698$ 38,170,698$ 47,733,278$ 47,733,278$ 5.44% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 5.44%Total Portfolio 5.46% Rolling Three Month Treasury 5.47%Rolling Three Month Treasury 5.48% Rolling Six Month Treasury 5.34%Rolling Six Month Treasury 5.40% TexPool 5.31%TexPool 5.33% Interest data provided in separate report. March 31, 2024 (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, 2024 Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.1 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.31%07/01/24 06/30/24 9,797,424$ 9,797,424$ 1.00 9,797,424$ 1 5.31% TexSTAR AAAm 5.31%07/01/24 06/30/24 11,244,960 11,244,960 1.00 11,244,960 1 5.31% Veritex Bank MMA 5.33%07/01/24 06/30/24 2,952,020 2,952,020 1.00 2,952,020 1 5.33% Alliance Bank CD 5.80%08/23/24 08/23/23 8,352,089 8,352,089 100.00 8,352,089 54 5.93% East West Bank CD 5.13%11/12/24 02/12/24 7,139,091 7,139,091 100.00 7,139,091 135 5.26% Veritex Community Bank CD 5.33%02/18/25 08/17/23 5,227,208 5,227,208 100.00 5,227,208 233 5.46% Alliance Bank CDARS 5.40%05/22/25 05/23/24 3,020,485 3,020,485 100.00 3,020,485 326 5.55% TOTALS 47,733,278$ 47,733,278$ 47,733,278$ 76 5.44% (1)(2) June 30, 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.3 Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 03/31/24 Increases Decreases Book Value 06/30/24 Market Value 03/31/24 Change in Market Value Market Value 06/30/24 TexPool 5.31%07/01/24 9,361,751$ 435,674$ –$ 9,797,424$ 9,361,751$ 435,674$ 9,797,424$ TexSTAR 5.31%07/01/24 2,242,400 9,002,559 – 11,244,960 2,242,400 9,002,559 11,244,960 Veritex Bank MMA 5.33%07/01/24 2,913,138 38,883 – 2,952,020 2,913,138 38,883 2,952,020 East West Bank CD 5.36%05/28/24 3,213,104 – (3,213,104) – 3,213,104 (3,213,104) – Alliance Bank CD 5.93%08/23/24 8,234,327 117,762 – 8,352,089 8,234,327 117,762 8,352,089 East West Bank CD 5.26%11/12/24 7,048,371 90,720 – 7,139,091 7,048,371 90,720 7,139,091 Veritex Community Bank CD 5.46%02/18/25 5,157,608 69,601 – 5,227,208 5,157,608 69,601 5,227,208 Alliance Bank CDARS 5.55%05/22/25 – 3,020,485 – 3,020,485 – 3,020,485 3,020,485 TOTAL / AVERAGE 5.44%38,170,698$ 12,775,684$ (3,213,104)$ 47,733,278$ 38,170,698$ 9,562,580$ 47,733,278$ Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.5 GTEC - Allocation Investment Total GTEC 2016 CO GTEC 2017 CO GTEC Veritex Community Bank MMA 2,952,020$ 2,952,020$ –$ –$ TexPool 9,797,424 9,797,424 – – TexSTAR 11,244,960 5,409,162 – 257 Alliance Bank CD 08/23/24 8,352,089 8,352,089 – – East West Bank CD 11/12/24 7,139,091 7,139,091 – – Veritex Community Bank CD 02/18/25 5,227,208 5,227,208 – – Alliance Bank CDARS 05/22/25 3,020,485 3,020,485 – – Totals 47,733,278$ 41,897,480$ –$257$ March 31, 2024 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 05/28/24 2,073,018 2,073,018 – – Alliance Bank CD 08/23/24 3,171,561 3,171,561 – – East West Bank CD 11/12/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$ June 30, 2024 Book & Market Value Book & Market Value City of Georgetown Valley View Consulting, L.L.C.6 GEDCO Investment Report City of Georgetown | FY2024 Quarterly Financial Report Page 64 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield MMA 2,308,717$ 2,308,717$ 2,339,537$ 2,339,537$ 5.33% Pools 6,845,707 6,845,707 7,526,742 7,526,742 5.31% CDs/Securities 2,588,140 2,588,140 2,623,348 2,623,348 5.57% 11,742,564$ 11,742,564$ 12,489,628$ 12,489,628$ 5.37% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 5.37%Total Portfolio 5.41% Rolling Three Month Treasury 5.47%Rolling Three Month Treasury 5.48% Rolling Six Month Treasury 5.34%Rolling Six Month Treasury 5.40% TexPool 5.31%TexPool 5.33% Interest income provided in separate report. March 31, 2024 (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, 2024 Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.1 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%07/01/24 06/30/24 2,339,537$ 2,339,537$ 1.00 2,339,537$ 1 5.33% TexasDAILY AAAm 5.30%07/01/24 06/30/24 2,332,515 2,332,515 1.00 2,332,515 1 5.30% TexSTAR AAAm 5.31%07/01/24 06/30/24 5,194,227 5,194,227 1.00 5,194,227 1 5.31% East West Bank CD 5.42%08/06/24 02/26/24 2,623,348 2,623,348 1.00 2,623,348 37 5.57% 12,489,628$ 12,489,628$ 12,489,628$ 9 5.37% (1)(2) June 30, 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.3 Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 03/31/24 Increases Decreases Book Value 06/30/24 Market Value 03/31/24 Change in Market Value Market Value 06/30/24 Veritex Bank MMA 5.33%07/01/24 2,308,717$ 30,820$ –$ 2,339,537$ 2,308,717$ 30,820$ 2,339,537$ TexasDAILY 5.30%07/01/24 2,302,030 30,485 – 2,332,515 2,302,030 30,485 2,332,515 TexSTAR 5.31%07/01/24 4,543,677 650,550 – 5,194,227 4,543,677 650,550 5,194,227 East West Bank CD 5.57%08/06/24 2,588,140 35,208 – 2,623,348 2,588,140 35,208 2,623,348 TOTAL / AVERAGE 5.37%11,742,564$ 747,064$ –$ 12,489,628$ 11,742,564$ 747,064$ 12,489,628$ Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.5 Grants Report City of Georgetown | FY2024 Quarterly Financial Report Page 65 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 - - Airport Federal Aviation Administration Texas Department of Transportation-Aviation 1814GRGTN Runway 18/36 Rehabilitation- Engineering - 40,815 Airport N/A Texas Department of Transportation M2414GEOR RAMP Grant - Routine Airport Maintenance Program - - Airport Federal Aviation Administration Texas Department of Transportation 2314GRGTN Airport Pavement Project - - Arts & Culture N/A Texas Commission on the Arts 77758427 FY23 Performance Grant - Guy Forsyth 2,250 2,250 Arts & Culture N/A Texas Commission on the Arts 77756626 FY24 Arts Create Grant 13,324 7,000 Electric American Public Power Association / Demonstration of Energy & Efficiency Developments N/A Demonstration of Energy & Efficiency Developments Scholarship for Intern 2,500 2,500 Electric US Department of Energy N/A Energy Efficiency and Conservation Block Grant- Smart Thermostat program - - Emergency Management US Dept. of the Treasury N/A American Rescue Plan Act SLFRF Funding - Parking Garage 1,417,615 1,417,615 Environmental Services Capital Area Council of Governments N/A CAPCOG Solid Waste Grant- Community Collection Event - - Fire Federal Emergency Management Agency Texas Department of Public Safety - TDEM TX-TIFMAS-TIFMAS - Smokehouse Fire - - Library N/A St. David's Foundation St. David's Grant - 16,862 - Library N/A Texas State Library and Archives Commission Special Projects 75 2025 - GLPXpress Service - - Planning US Department of Housing & Urban Development Williamson County CDBG Home Repair (FY21) 36,460 36,460 Planning US Department of Housing & Urban Development Williamson County CDBG Home Repair (FY22) 21,313 21,313 Planning US Department of Housing & Urban Development Williamson County CDBG Home Repair (FY23) - - CITY OF GEORGETOWN Grant/Federal Funding Report as of June 30, 2024 Active Department Federal Grantor Pass-Through Agency Identifying Number COG Name/Purpose YTD Expenditures YTD Revenue Recognized CITY OF GEORGETOWN Grant/Federal Funding Report as of June 30, 2024 Active Police US Department of Justice N/A TX2460200 Equitable Sharing Agreement - 25,560 Police US Department of Treasury N/A TX2460200 Equitable Sharing Agreement - 2,231 Systems Engineering US Dept of Housing and Urban Development N/A B-23-CP-TX-1389 FM 971 Improvements - - Water N/A Texas Department of Transportation U0156 CSJ 0015-08-144 Williams Drive Water Relocate - 2,180 Electric N/A Texas Department of Transportation U0156 CSJ 0015-08-150 Williams Drive Water Relocate Water N/A N/A Chandler Road Waterline Extention - Round Rock ILA 59,449.20 - Public Works Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ # 0914-05-200 Highway Planning & Construction (Williams Dr Corridor)-Williams Dr from Austin Ave to Jim Hogg Dr. - 119,426 Public Works Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ # 0914-05-202 Highway Planning & Construction (Williams Dr Corridor) - driveways & improve intersections along Williams Dr. - - Public Works Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ # 0914-05-201 Highway Planning & Construction (Williams Dr Corridor) - left turn bay on Lakeway Dr - - Public Works Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ # 0914-05-216 Safety Lighting on Williams Dr 28,707.00 - Department Federal Grantor Pass-Through Agency Identifying Number COG Name/Purpose YTD Expenditures YTD Revenue Recognized CITY OF GEORGETOWN Grant/Federal Funding Report as of June 30, 2024 Active Electric Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ # 2211-02-019 FM 1460 Road Widening (ROW Acquisition)* - - Joint Services Federal Emergency Management Administration Texas Division of Emergency Management PA-06-TX-4586-PW-00337 Winter Storm URI - 4,732 Public Works/Electric/City- Wide Federal Emergency Management Administration Texas Division of Emergency Management CFDA 97.036-Project 4705DRTX - Project 734109 Winter Storm Mara - - General Funds/Facilities/Fleet/Joint Services/IT/Electric/Stormwa ter/Water Federal Emergency Management Administration Texas Division of Emergency Management CFDA 97.036-Project 4705DRTX - Project 733448 Winter Storm Mara - 253,074 Electric/Water Federal Emergency Management Administration Texas Division of Emergency Management CFDA 97.036-Project 4705DRTX -Project 734484 Winter Storm Mara - 495,686 Division Grantor COG Name/Purpose Status Airport Federal Aviation Administration N/A Bipartisan Infrastructure Law; Airport Terminal and Tower Project Council approved; application sent to FAA, awaiting notice of award Arts & Culture Texas Commission on the Arts N/A 77760887 Texas Comission on the Arts - Cultural District Project 2024- Gateway signage and wayfinding project Council approved; awaiting notice of award Electric US Department of Energy Texas Division of Emergency Management DOE Grid Resilience Formula Grant Council to approve application in July Engineering-Transportation US Department of Transportation, FHWA 20.205 Austin Ave Pedestrian Bridges- Active Transportation Infrastructure Investment Program (ATIIP) Water Williamson County SH 138 Waterline Upgrade Progessing to 90% plans and on-boarding a firm to assist in the easements acquisitions. Applications Pending Award Department Federal Grantor Pass-Through Agency Identifying Number COG Name/Purpose YTD Expenditures YTD Revenue Recognized CITY OF GEORGETOWN Grant/Federal Funding Report as of June 30, 2024 Active Water US Environmental Protection Agency EPA Community Project - Aquifer Storage and Recovery (ASR) Earmarked and need to apply. Public Works Texas Department of Transportation CSJ # 0015-08-432 IH35-San Gabriel River to Northwest Blvd Public Works Texas Department of Transportation CSJ # 0337-01-048 SH 29 at IH-35 NBFR Public Works Texas Department of Transportation CSJ # 0337-01-053 SH 29- Wof Wolf Ranch Pkwy to IH35 Public Works Texas Department of Transportation CSJ # 0337-02-051 SH 29 - Haven Lane to Patriot Way Public Works Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ # 2103--01-036 RM 2243 Improvement Public Works Texas Department of Transportation CSJ # 2690-01-043 FM 971 - Gann Street to SH 130 Reviewed By: Elaine Wilson Capital Improvement Projects Comprehensive information about active capital projects can be explored digitally in the City’s ClearGov Transparency Center at https://georgetown-tx.cleargov.com (https://georgetown-tx.cleargov.com) and clicking on the Projects tab. City of Georgetown | FY2024 Quarterly Financial Report Page 66