Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
FY 23 - 2nd_Qtr_Report_FY2023_Redacted
FINANCIAL REPORT AND INVESTMENT REPORT For the Quarter Ended March 31st, 2023 Table of Contents General Fund Narrative .............................................................................................................................. 1-8 General Fund Schedule ................................................................................................................................. 9 General Fund by Cost Center ................................................................................................................. 10-12 Electric Fund Narrative ........................................................................................................................... 13-15 Electric Fund Schedule ................................................................................................................................ 16 Water Services Fund Narrative ............................................................................................................... 17-19 Water Services Fund Schedule .................................................................................................................... 20 Convention & Visitors Bureau Narrative................................................................................................. 21-22 Convention & Visitors Bureau Fund Schedule ............................................................................................. 23 Airport Fund Narrative ........................................................................................................................... 24-25 Airport Fund Schedule ................................................................................................................................. 26 Georgetown Transportation Enhancement Corporation Fund Narrative ............................................... 27-28 Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 29 Georgetown Economic Development Corporation Fund Narrative ....................................................... 30-31 Georgetown Economic Development Corporation Fund Schedule ............................................................. 32 Council Discretionary Fund Schedule .......................................................................................................... 33 Joint Services Fund Schedule ....................................................................................................................... 34 Stormwater Services Narrative ............................................................................................................... 35-36 Stormwater Services Fund Schedule ........................................................................................................... 37 Village PID Services Narrative ...................................................................................................................... 38 Village PID Services Fund Schedule ............................................................................................................. 39 Investment Report.................................................................................................................................. 40-42 Quarterly Investment Report - City ........................................................................................................ 43-62 Quarterly Investment Report - GEDCO ................................................................................................... 63-68 Quarterly Investment Report - GTEC ...................................................................................................... 69-74 Grant Applications ....................................................................................................................................... 75 Capital Improvement Projects ................................................................................................................ 76-79 Quarterly Financial Report necessary in the aftermath of the winter storm. The City is covering those costs with the council Special Revenue Fund and is applying for reimbursement from FEMA. FINANCE ADMINISTRATION DIVISION: Municipal Court year-to-date expenses total $275,696, or 46.02% of budget. This spending includes $224,690 for personnel costs and $51,007 for operational costs. POLICE OPERATIONS DIVISION: Police Operations saw personnel and operational expenditures through the quarter total $9,350,616, or 48.24% of budget. Police Administration expenditures through the quarter resulted in $1,452,160, or 48.33% of budget. FIRE AND EMS DIVISION: Year-to-date personnel and operational expenditures through the quarter total $2,853,601, or 58.09% of budget for Fire Support Services/Administration, $9,873,458, or 49.40% of budget for Fire Emergency Services, and $2,176,444, or 58.68% of budget for Fire EMS. ADMINISTRATIVE SERVICES DIVISION: Administrative Services saw operational and personnel costs totaling $1,343,155, or 46.01% of budget year-to-date. The cost center includes one-time funding for consulting, continuation of a “311 like” system, and studies that were not completed in FY2022. City Secretary personnel and operational expenditures for the quarter totals $684,092, which represents 44.38% of budget. Year-to-date personnel and operational expenditures for Communications totals $681,751, which represents 45.60% of budget. Non-Departmental includes a budget of $1,590,765 for transfers out to various funds. As of the second quarter, 10.35% of anticipated transfer expenses have been made. General Government Contracts includes budgeted vacancy savings estimates for all General Fund departments. Real vacancy savings is realized in each cost center. The budgeted vacancy factor against year-to-date actuals in the administrative division cost center drives the percent of budget up. Additionally, this is where the City budgets for various approved economic development related incentives. LIBRARY, TOURISM, AND ARTS AND CULTURE DIVISION: Arts and Culture recognized year to date expenses totaling $164,198, or 36.45% of budget. Lower than anticipated expenditures are tied to pausing on two Special Events and Marketing positions because of revenue uncertainty. As of the 2nd quarter, one position has been filled. Library year-to- date expenses total $1,749,094, or 46.43% of budget. 5 Quarterly Financial Report PARKS AND RECREATION DIVISION: Year-to-date personnel and operations costs for Parks and Recreation within the following cost centers: Parks Administrations, Parks, Garey Park, Tennis Center, Recreation and, comes to a total of $5,261,916, or 46.22% of budget. Parks year-to-date through the quarter totals $1,705,398, or 48.11% of budget. Recreation total expenses are $2,371,287, which is 44.79% of budget. Garey Park year-to-date is $567,845, or 46.87% of budget. Personnel expenses in recreation are heavily seasonal, and a significant portion of part- time and temporary salaries will be reflected in the fourth quarter. 6 Quarterly Financial Report Overall, General Fund expenditures are within budget and the fund can cover the 90-day Contingency Reserve, Economic Stability Reserve, Master Development Fee Reserve (MDF) and the Benefit Payout Reserve. 8 Quarterly Financial Report II.INVESTMENTS The investment activity and strategies described in this report comply with the Public Funds Investment Act (PFIA), the City’s investment policy, and generally accepted accounting principles. Activity for the second quarter of fiscal year 2023 includes the maturing, reinvesting, new investments of financial institution deposits (CDs) & purchases of treasury/agency securities. Interest rates continued to increase during this quarter after the FOMC met. We continue to work closely with Valley View Consulting to select the best investments as the market is changing rapidly. The FOMC met in January and March where they announced increases in the Fed Funds Rate from 4.25-4.50% in December 22 to 4.75-5.00% in March 23. The FOMC will meet again May 2-3 and June 13-14 during the 3rd quarter and may increase rates again. The City will continue soliciting for the best rates to improve both diversity and yield, while keeping in mind safety and liquidity. The Investment Reports are for the quarter ending March 31, 2023. Valley View Consulting, L.L.C., has prepared the attached investment reports. A component of our investment advisory services contract includes Valley View preparing the quarterly investment reports on behalf of the City. A summary of the investment balances as of March 31, 2023, compared to the prior quarter, is shown below for the City, as well as Georgetown Transportation Enhancement Corporation (GTEC) and Georgetown Economic Development Corporation (GEDCO). Included in the City portfolio are debt service, consolidated funds, and bond proceeds. The breakdown of the City’s portfolio is consolidated at 37.95%, debt service at 3.98%, and bond proceeds/grants/reserved fund at 58.07%. The City portfolio decreased during this quarter due to making the first interest portion of our debt service payments in February. The GTEC and GEDCO portfolios increased in this quarter. The average yield increased on all portfolios due to increased rates in our pools, newly purchased cd’s, and treasury/agency securities. 40 Quarterly Financial Report Rates on securities have helped the city diversify the portfolio compared to the prior year’s holdings. CITY Market Value GTEC GEDCO 12/31/22 3/31/23 12/31/22 3/31/23 12/31/22 3/31/23 Total cash and investments $755,055,451 $745,988,174 $43,069,669 $46,188,271 $9,865,349 $10,229,468 Quarter End Average Yield 3.37% 4.35% 4.00% 4.58% 4.05% 4.67% The City’s strategy continues to be matching maturities with cash flow needs, while focusing on the investment policy’s long-range goals. The City’s investment strategy is to “ladder” or stagger maturities, thus minimizing erratic interest rate fluctuations. The City is continuing to manage the yield on bond proceeds for arbitrage purposes. HDR Engineering was hired to manage and expedite the completion of bond funded capital projects. Finance staff also assisted Economic Development staff with an updated cash flow model for GEDCO to manage incentive agreement payments and potential new projects. The City’s investment portfolio generally includes bank deposits, local government investment pool balances, money market accounts, financial institution deposits (CD’s), and securities/agencies. All of these investments meet the safety 41 Quarterly Financial Report requirements of the PFIA. Local Government Investment Pools must maintain a rating of AAAm, Securities (Treasury Bills) must have direct or implied backing of the Federal Government and Financial Institution Deposits (CDs and money market accounts) must be collateralized with FDIC insurance or obligations with an implied backing from the Federal Government. The collateral on all City investments are monitored monthly to ensure the financial institutions carry minimum collateral of 100% with a letter of credit or 102% with pledged securities for all of the City’s investments. All securities held by financial institutions as collateral on behalf of the City have been reviewed and met PFIA-minimum rating criteria. III. CAPITAL IMPROVEMENT PROJECTS A financial summary of capital improvement projects is attached to this report. This report provides a Life-to-Date picture of all active projects since many capital projects take multiple fiscal years to construct to completion. With our growing capital infrastructure implementation portfolio due to demand for transportation and water services, City staff have formed a working group with the goal of improving work capacity and efficiencies, and ultimately customer service, related to capital projects. The group is focused on incrementally improving capital project reporting internally and externally citywide – including financial information as well as scheduling, geographic location, and other information. A Communications and Public Engagement staff person has also been re-organized to focus on capital project status updates. For the FY2023 Budget, staff were added to the Water, Public Works, and Engineering departments to assist with the workload of the capital improvement plan. Additionally, Council agreed to implement a hybrid approach to capital project management, and to hire contracted staff to manage transportation and facilities projects over the next 3 or more years. 42 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield Demand Accounts 5,700,533$ 5,700,533 800,704$ 800,704$ 0.00% NOW/MMA 29,206,167 29,206,167 28,655,293 28,655,293 4.78% Pools 320,394,060 320,394,060 281,150,859 281,150,859 4.61% CDs/Securities 399,924,271 399,754,691 435,275,491 435,381,317 4.16%Totals 755,225,031$ 755,055,451$ 745,882,348$ 745,988,174$ 4.35% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 4.35%Total Portfolio 3.86% Rolling Three Month Treasury 4.78%Rolling Three Month Treasury 4.49% Rolling Six Month Treasury 4.73%Rolling Six Month Treasury 4.32% TexPool 4.61%TexPool 4.30% Bank Fees Offset 3,163$ Interest earnings provided in separate report.3,163$ December 31, 2022 (1)Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank, pool, and money market balances. (2)Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. Quarterly Bank Fees Offset Year-to-date Bank Fees Offset March 31, 2023 City of Georgetown Valley View Consulting, L.L.C.44 City - Investment Holdings Coupon/Maturity Settlement Face Amount/Book Market Market Life Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield JPMorgan Chase Cash (3)0.00%04/01/23 03/31/23 758,592$ 758,592$ 1.00 758,592$ 1 0.00% JPMorgan Chase MMA 1.40%04/01/23 03/31/23 436,688 436,688 1.00 436,688 1 1.40% Wells Fargo Bank Cash 0.00%04/01/23 03/31/23 42,112 42,112 1.00 42,112 1 0.00% Wells Fargo Bank Sweep-MMF 4.66%04/01/23 03/31/23 12,164,479 12,164,479 1.00 12,164,479 1 4.66% Veritex Community Bank MMA 4.83%04/01/23 03/31/23 3,304,419 3,304,419 1.00 3,304,419 1 4.83% NexBank MMA 5.00%04/01/23 03/31/23 12,749,708 12,749,708 1.00 12,749,708 1 5.00% TexPool AAAm 4.61%04/01/23 03/31/23 30,752,271 30,752,271 1.00 30,752,271 1 4.61% TexSTAR AAAm 4.61%04/01/23 03/31/23 250,398,587 250,398,587 1.00 250,398,587 1 4.61% East West Bank CD 4.16%4/12/2023 10/12/22 13,605,580 13,605,580 100.00 13,605,580 12 4.16% East West Bank CD 4.16%4/12/2023 10/12/22 20,385,946 20,385,946 100.00 20,385,946 12 4.16% Prosperity Bank CD 0.20%4/24/2023 04/23/21 5,019,186 5,019,186 100.00 5,019,186 24 0.20% Prosperity Bank CD 0.20%5/1/2023 05/25/21 5,018,361 5,018,361 100.00 5,018,361 31 0.20% Alliance Bank CD 2.98%5/2/2023 08/02/22 4,059,706 4,059,706 100.00 4,059,706 32 2.98% Texas Capital Bank CD 2.90%5/4/2023 08/04/22 1,271,232 1,271,232 100.00 1,271,232 34 2.90% East West Bank CD 3.27%5/10/2023 08/10/22 3,070,630 3,070,630 100.00 3,070,630 40 3.27% FHLB Aaa/AA+4.60%5/10/2023 11/10/22 24,000,000 23,880,000 99.53 23,887,843 40 4.60% East West Bank CD 5.62%5/15/2023 11/15/22 5,085,546 5,085,546 100.00 5,085,546 45 4.62% Bank OZK CD 0.20%6/12/2023 06/11/21 5,028,894 5,028,894 100.00 5,028,894 73 0.20% East West Bank CD 3.04%6/16/2023 06/16/22 15,359,336 15,359,336 100.00 15,359,336 77 3.04% Texas Capital Bank CD 3.42%6/16/2023 09/16/22 5,085,517 5,085,517 100.00 5,085,517 77 3.42% East West Bank CD 2.98%6/20/2023 06/22/22 2,560,349 2,560,349 100.00 2,560,349 81 2.98% Alliance Bank CD 5.20%6/27/2023 12/27/22 8,100,603 8,100,603 100.00 8,100,603 88 5.20% FHLB Aaa/AA+0.00%6/29/2023 09/16/22 10,000,000 9,903,875 99.83 9,887,246 90 3.97% R Bank CD 0.73%6/30/2023 06/30/21 1,012,842 1,012,842 100.00 1,012,842 91 0.73% Alliance Bank CD 3.14%7/1/2023 07/01/22 4,093,809 4,093,809 100.00 4,093,809 92 3.14% FHLB Aaa/AA+0.00%7/31/2023 10/17/22 5,000,000 4,926,885 98.46 4,922,799 122 4.47% East West Bank CD 3.10%8/1/2023 08/01/22 2,047,081 2,047,081 100.00 2,047,081 123 3.10% Alliance Bank CD 3.19%8/2/2023 08/02/22 1,015,942 1,015,942 100.00 1,015,942 124 3.19% Bank OZK CD 0.21%8/14/2023 11/12/21 5,014,037 5,014,037 100.00 5,014,037 136 0.21% East West Bank CD 5.67%8/15/2023 11/15/22 5,107,694 5,107,694 100.00 5,107,694 137 4.67% East West Bank CD 5.15%08/15/23 02/15/23 4,093,834 4,093,834 100.00 4,093,834 137 5.15% Texas Capital Bank CD 3.30%8/24/2023 08/24/22 2,548,378 2,548,378 100.00 2,548,378 146 3.30% FHLB Aaa/AA+3.63%9/13/2023 09/13/22 13,350,000 13,344,961 99.51 13,279,879 166 3.71% FFCB Aaa/AA+0.22%9/22/2023 09/13/22 925,000 909,814 99.48 905,050 175 3.74% Veritex Community Bank CD 0.25%9/25/2023 09/24/21 10,037,463 10,037,463 100.00 10,037,463 178 0.25% Bank OZK CD 5.05%09/30/23 03/30/23 25,000,000 25,000,000 100.00 25,000,000 183 5.05% March 31, 2023 City of Georgetown Valley View Consulting, L.L.C.46 City - Investment Holdings Coupon/Maturity Settlement Face Amount/Book Market Market Life Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield March 31, 2023 Bank OZK CD 0.20%10/9/2023 10/08/21 5,014,227 5,014,227 100.00 5,014,227 192 0.20% FHLB Aaa/AA+0.00%10/13/2023 10/17/22 2,500,000 2,440,656 97.54 2,438,472 196 4.56% East West Bank CD 4.76%10/18/23 01/18/23 10,095,648 10,095,648 100.00 10,095,648 201 4.87% East West Bank CD 4.63%10/19/2023 10/19/22 2,551,403 2,551,403 100.00 2,551,403 202 4.63% FHLB Aaa/AA+5.17%10/24/23 02/27/23 10,000,000 9,715,950 99.99 9,740,046 207 5.17% Bank OZK CD 0.30%11/13/2023 11/12/21 10,040,071 10,040,071 100.00 10,040,071 227 0.30% FAMCA 4.75%11/22/2023 11/22/22 2,000,000 2,000,000 99.99 1,999,879 236 4.75% East West Bank CD 5.43%12/11/23 03/09/23 9,030,049 9,030,049 100.00 9,030,049 255 5.43% FAMCA 4.95%12/13/2023 12/13/22 10,000,000 10,000,000 99.87 9,986,696 257 4.95% Alliance Bank CD 5.10%12/27/2023 12/27/22 1,012,575 1,012,575 100.00 1,012,575 271 5.20% Bank OZK CD 5.05%12/30/23 03/30/23 26,000,000 26,000,000 100.00 26,000,000 274 5.05% Alliance Bank CD 5.25%01/12/24 01/13/23 5,000,000 5,000,000 100.00 5,000,000 287 5.25% East West Bank CD 4.82%01/18/24 01/18/23 10,094,639 10,094,639 100.00 10,094,639 293 4.82% Veritex Community Bank CD 4.95%01/23/24 01/23/23 10,078,388 10,078,388 100.00 10,078,388 298 4.95% Southside Bank CD 3.32%2/2/2024 08/02/22 10,168,065 10,168,065 100.00 10,168,065 308 3.32% FHLB Aaa/AA+5.35%02/28/24 03/06/23 20,000,000 20,000,000 100.42 20,084,080 334 5.35% East West Bank CD 5.38%03/11/24 03/09/23 10,033,071 10,033,071 100.00 10,033,071 346 5.38% BOK Financial CD 5.00%03/23/24 02/22/23 8,009,630 8,009,630 100.00 8,009,630 358 5.00% Independent Financial CD 5.08%05/09/24 02/09/23 8,000,000 8,000,000 100.00 8,000,000 405 5.08% T-Note Aaa/AA+0.25%5/15/2024 11/22/22 2,000,000 1,903,741 95.38 1,907,656 411 4.72% Alliance Bank CD 5.10%6/14/2024 12/15/22 10,125,753 10,125,753 100.00 10,125,753 441 5.20% Alliance Bank CD 5.10%6/27/2024 12/27/22 13,265,333 13,265,333 100.00 13,265,333 454 5.20% Independent Financial CD 4.50%07/24/24 01/23/23 10,000,000 10,000,000 100.00 10,000,000 481 4.58% FHLB Aaa/AA+5.18%07/26/24 02/28/23 10,000,000 10,000,000 100.66 10,065,863 483 5.18% FFCB Aaa/AA+4.88%08/21/24 02/27/23 4,000,000 3,983,041 100.23 4,009,236 509 5.19% Alliance Bank CD 5.10%12/13/2024 12/15/22 10,125,753 10,125,753 100.00 10,125,753 623 5.20% TOTALS 746,648,426$ 745,882,348$ 745,988,174$ 128 4.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.47 City - Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 12/31/22 Increases Decreases Book Value 03/31/23 Market Value 12/31/22 Change in Market Value Market Value 03/31/23 JPMorgan Chase Cash 0.00%04/01/23 5,700,533$ –$ (4,941,941)$ 758,592$ 5,700,533$ (4,941,941)$ 758,592$ JPMorgan Chase MMA 1.40%04/01/23 435,297 1,392 – 436,688 435,297 1,392 436,688 Wells Fargo Bank Cash 0.00%04/01/23 1,416,799 – (1,374,687) 42,112 1,416,799 (1,374,687) 42,112 Wells Fargo Bank Sweep-MMF 4.66%04/01/23 11,481,710 682,768 – 12,164,479 11,481,710 682,768 12,164,479 Veritex Community Bank MMA 4.83%04/01/23 3,267,942 36,477 – 3,304,419 3,267,942 36,477 3,304,419 NexBank MMA 5.00%04/01/23 12,604,419 145,288 – 12,749,708 12,604,419 145,288 12,749,708 TexPool 4.61%04/01/23 66,599,765 – (35,847,493) 30,752,271 66,599,765 (35,847,493) 30,752,271 TexSTAR 4.61%04/01/23 253,794,295 – (3,395,708) 250,398,587 253,794,295 (3,395,708) 250,398,587 R Bank CD 0.60%01/05/23 1,009,065 – (1,009,065) – 1,009,065 (1,009,065) – East West Bank CD 0.42%01/09/23 5,031,223 – (5,031,223) – 5,031,223 (5,031,223) – East West Bank CD 0.51%01/20/23 10,048,462 – (10,048,462) – 10,048,462 (10,048,462) – Alliance Bank CD 2.83%02/02/23 4,028,230 – (4,028,230) – 4,028,230 (4,028,230) – Texas Capital Bank CD 2.80%02/04/23 7,822,869 – (7,822,869) – 7,822,869 (7,822,869) – East West Bank CD 3.17%02/07/23 5,937,128 – (5,937,128) – 5,937,128 (5,937,128) – East West Bank CD 0.83%02/08/23 8,059,708 – (8,059,708) – 8,059,708 (8,059,708) – East West Bank CD 0.00%02/15/23 4,052,958 – (4,052,958) – 4,052,958 (4,052,958) – Bank OZK CD 0.18%02/23/23 4,210,154 – (4,210,154) – 4,210,154 (4,210,154) – East West Bank CD 1.20%02/27/23 20,203,158 – (20,203,158) – 20,203,158 (20,203,158) – Veritex Community Bank CD 0.18%03/09/23 4,009,005 – (4,009,005) – 4,009,005 (4,009,005) – East West Bank CD 1.16%03/14/23 15,139,111 – (15,139,111) – 15,139,111 (15,139,111) – T-Bill 3.56%03/16/23 496,406 – (496,406) – 495,780 (495,780) – T-Bill 3.56%03/16/23 25,862,766 – (25,862,766) – 25,830,115 (25,830,115) – R Bank CD 3.05%03/23/23 4,537,510 – (4,537,510) – 4,537,510 (4,537,510) – East West Bank CD 1.30%03/27/23 25,250,406 – (25,250,406) – 25,250,406 (25,250,406) – East West Bank CD 4.16%4/12/2023 13,469,398 136,182 – 13,605,580 13,469,398 136,182 13,605,580 East West Bank CD 4.16%4/12/2023 20,181,897 204,049 – 20,385,946 20,181,897 204,049 20,385,946 Prosperity Bank CD 0.20%4/24/2023 5,016,711 2,474 – 5,019,186 5,016,711 2,474 5,019,186 Prosperity Bank CD 0.20%5/1/2023 5,015,887 2,474 – 5,018,361 5,015,887 2,474 5,018,361 Alliance Bank CD 2.98%5/2/2023 4,029,742 29,964 – 4,059,706 4,029,742 29,964 4,059,706 Texas Capital Bank CD 2.90%5/4/2023 1,262,175 9,057 – 1,271,232 1,262,175 9,057 1,271,232 East West Bank CD 3.27%5/10/2023 3,046,348 24,282 – 3,070,630 3,046,348 24,282 3,070,630 FHLB 4.60%5/10/2023 23,610,000 270,000 – 23,880,000 23,625,418 262,426 23,887,843 East West Bank CD 4.62%5/15/2023 5,029,184 56,361 – 5,085,546 5,029,184 56,361 5,085,546 Bank OZK CD 0.20%6/12/2023 5,026,402 2,492 – 5,028,894 5,026,402 2,492 5,028,894 East West Bank CD 3.04%6/16/2023 15,246,518 112,817 – 15,359,336 15,246,518 112,817 15,359,336 Texas Capital Bank CD 3.42%6/16/2023 5,042,813 42,703 – 5,085,517 5,042,813 42,703 5,085,517 East West Bank CD 2.98%6/20/2023 2,541,856 18,493 – 2,560,349 2,541,856 18,493 2,560,349 Alliance Bank CD 5.20%6/27/2023 8,000,000 100,603 – 8,100,603 8,000,000 100,603 8,100,603 FHLB 3.97%6/29/2023 9,807,750 96,125 – 9,903,875 9,780,388 106,858 9,887,246 R Bank CD 0.73%6/30/2023 1,011,020 1,821 – 1,012,842 1,011,020 1,821 1,012,842 Alliance Bank CD 3.14%7/1/2023 4,062,754 31,055 – 4,093,809 4,062,754 31,055 4,093,809 FHLB 4.47%7/31/2023 4,872,947 53,937 – 4,926,885 4,871,584 51,214 4,922,799 East West Bank CD 3.10%8/1/2023 2,031,744 15,337 – 2,047,081 2,031,744 15,337 2,047,081 City of Georgetown Valley View Consulting, L.L.C.49 City - Allocation Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Streets/ Vehicles 2015 GO- Roads 2015 Revenue Water WW 2016 GO- Roads Garey Park Donation 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Roads JPMorgan Chase Cash 758,592$ 758,592$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 436,688 436,688 – – – – – – – – – – – Wells Fargo Bank Cash 42,112 42,112 – – – – – – – – – – – Wells Fargo Bank Sweep-MMF 12,164,479 12,164,479 – – – – – – – – – – – Veritex Community Bank MMA 3,304,419 3,304,419 – – – – – – – – – – – NexBank MMA 12,749,708 12,749,708 – – – – – – – – – – – TexPool 30,752,271 30,752,271 – – – – – – – – – – – TexSTAR 250,398,587 37,854,861 451,459 29,705,689 140,951 1,894,898 1,572,488 431,220 1,086,587 7,762,382 44,041 315,240 1,282,110 East West Bank CD 4/12/2023 13,605,580 – – – – – – – – – – – – East West Bank CD 4/12/2023 20,385,946 – – – – – – – – – – – – Prosperity Bank CD 4/24/2023 5,019,186 5,019,186 – – – – – – – – – – – Prosperity Bank CD 5/1/2023 5,018,361 5,018,361 – – – – – – – – – – – Alliance Bank CD 5/2/2023 4,059,706 – – – – – – – – – – – – Texas Capital Bank CD 5/4/2023 1,271,232 – – – – – – – – – – – – East West Bank CD 5/10/2023 3,070,630 – – – – – – – – 3,070,630 – – – FHLB 5/10/2023 23,880,000 – – – – – – – – – – – – East West Bank CD 5/15/2023 5,085,546 – – – – – – – – – – – – Bank OZK CD 6/12/2023 5,028,894 5,028,894 – – – – – – – – – – – East West Bank CD 6/16/2023 15,359,336 15,359,336 – – – – – – – – – – – Texas Capital Bank CD 6/16/2023 5,085,517 5,085,517 – – – – – – – – – – – East West Bank CD 6/20/2023 2,560,349 – – – – – – – – – – – – Alliance Bank CD 6/27/2023 8,100,603 – – – – – – – – – – – – FHLB 6/29/2023 9,903,875 9,903,875 – – – – – – – – – – – R Bank CD 6/30/2023 1,012,842 1,012,842 – – – – – – – – – – – Alliance Bank CD 7/1/2023 4,093,809 4,093,809 – – – – – – – – – – – FHLB 7/31/2023 4,926,885 4,926,885 – – – – – – – – – – – East West Bank CD 8/1/2023 2,047,081 – – – – – – – – – – – – Alliance Bank CD 8/2/2023 1,015,942 – – – – – – – – – – – – Bank OZK CD 8/14/2023 5,014,037 5,014,037 – – – – – – – – – – – East West Bank CD 8/15/2023 5,107,694 – – – – – – – – – – – – East West Bank CD 08/15/23 4,093,834 – – – – – – – – – – – – Texas Capital Bank CD 8/24/2023 2,548,378 2,548,378 – – – – – – – – – – – FHLB 9/13/2023 13,344,961 – – – – – – – – – – – – FFCB 9/22/2023 909,814 – – – – – – – – – – – – Veritex Community Bank CD 9/25/2023 10,037,463 10,037,463 – – – – – – – – – – – Bank OZK CD 09/30/23 25,000,000 – – – – – – – – – – – – Bank OZK CD 10/9/2023 5,014,227 5,014,227 – – – – – – – – – – – FHLB 10/13/2023 2,440,656 2,440,656 – – – – – – – – – – – East West Bank CD 10/18/23 10,095,648 – – – – – – – – – – – – East West Bank CD 10/19/2023 2,551,403 2,551,403 – – – – – – – – – – – FHLB 10/24/23 9,715,950 – – – – – – – – – – – – Bank OZK CD 11/13/2023 10,040,071 10,040,071 – – – – – – – – – – – FAMCA 11/22/2023 2,000,000 2,000,000 – – – – – – – – – – – East West Bank CD 12/11/23 9,030,049 9,030,049 – – – – – – – – – – – FAMCA 12/13/2023 10,000,000 10,000,000 – – – – – – – – – – – Alliance Bank CD 12/27/2023 1,012,575 1,012,575 – – – – – – – – – – – Bank OZK CD 12/30/23 26,000,000 – – – – – – – – – – – – Alliance Bank CD 01/12/24 5,000,000 5,000,000 – – – – – – – – – – – East West Bank CD 01/18/24 10,094,639 – – – – – – – – – – – – Veritex Community Bank CD 01/23/24 10,078,388 10,078,388 – – – – – – – – – – – Southside Bank CD 2/2/2024 10,168,065 – – – – – – – – – – – – FHLB 02/28/24 20,000,000 20,000,000 – – – – – – – – – – – East West Bank CD 03/11/24 10,033,071 – – – – – – – – – – – – BOK Financial CD 03/23/24 8,009,630 8,009,630 – – – – – – – – – – – Independent Financial CD 05/09/24 8,000,000 8,000,000 – – – – – – – – – – – T-Note 5/15/2024 1,903,741 1,903,741 – – – – – – – – – – – Alliance Bank CD 6/14/2024 10,125,753 – – – – – – – – – – – – Alliance Bank CD 6/27/2024 13,265,333 13,265,333 – – – – – – – – – – – Independent Financial CD 07/24/24 10,000,000 – – – – – – – – – – – – FHLB 07/26/24 10,000,000 – – – – – – – – – – – – FFCB 08/21/24 3,983,041 3,983,041 – – – – – – – – – – – Alliance Bank CD 12/13/2024 10,125,753 – – – – – – – – – – – – Totals 745,882,348$ 283,440,824$ 451,459$ 29,705,689$ 140,951$ 1,894,898$ 1,572,488$ 431,220$ 1,086,587$ 10,833,012$ 44,041$ 315,240$ 1,282,110$ Book Value March 31, 2023 City of Georgetown Valley View Consulting, L.L.C.51 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR East West Bank CD 4/12/2023 East West Bank CD 4/12/2023 Prosperity Bank CD 4/24/2023 Prosperity Bank CD 5/1/2023 Alliance Bank CD 5/2/2023 Texas Capital Bank CD 5/4/2023 East West Bank CD 5/10/2023 FHLB 5/10/2023 East West Bank CD 5/15/2023 Bank OZK CD 6/12/2023 East West Bank CD 6/16/2023 Texas Capital Bank CD 6/16/2023 East West Bank CD 6/20/2023 Alliance Bank CD 6/27/2023 FHLB 6/29/2023 R Bank CD 6/30/2023 Alliance Bank CD 7/1/2023 FHLB 7/31/2023 East West Bank CD 8/1/2023 Alliance Bank CD 8/2/2023 Bank OZK CD 8/14/2023 East West Bank CD 8/15/2023 East West Bank CD 08/15/23 Texas Capital Bank CD 8/24/2023 FHLB 9/13/2023 FFCB 9/22/2023 Veritex Community Bank CD 9/25/2023 Bank OZK CD 09/30/23 Bank OZK CD 10/9/2023 FHLB 10/13/2023 East West Bank CD 10/18/23 East West Bank CD 10/19/2023 FHLB 10/24/23 Bank OZK CD 11/13/2023 FAMCA 11/22/2023 East West Bank CD 12/11/23 FAMCA 12/13/2023 Alliance Bank CD 12/27/2023 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 Southside Bank CD 2/2/2024 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Independent Financial CD 05/09/24 T-Note 5/15/2024 Alliance Bank CD 6/14/2024 Alliance Bank CD 6/27/2024 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/2024 Totals Book Value March 31, 2023 (Continued) 2019 CO- Streets/ Facilities/ Equip 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 CO- Stormwater 2020 GO- Roads Electric-LCRA Transformers City - 2021 CO Airport City - 2021 CO Fac/Equip/ Parks City - 2021 GO Parks City - 2021 GO Roads City - 2021A CO Electric City - 2021A CO Water/WW City - 2021A GO Roads –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,137,096 2,798,356 613,672 114 4,116,405 3,798,399 718,563 5,507,046 175,586 3,026,941 434,425 6,022,715 12,009,359 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,085,546 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,560,349 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,047,081 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,107,694 – – – – – – – 4,093,834 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,137,096$ 2,798,356$ 613,672$ 114$ 6,163,486$ 3,798,399$ 718,563$ 9,600,880$ 175,586$ 3,026,941$ 434,425$ 8,583,063$ 22,202,598$ City of Georgetown Valley View Consulting, L.L.C.52 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR East West Bank CD 4/12/2023 East West Bank CD 4/12/2023 Prosperity Bank CD 4/24/2023 Prosperity Bank CD 5/1/2023 Alliance Bank CD 5/2/2023 Texas Capital Bank CD 5/4/2023 East West Bank CD 5/10/2023 FHLB 5/10/2023 East West Bank CD 5/15/2023 Bank OZK CD 6/12/2023 East West Bank CD 6/16/2023 Texas Capital Bank CD 6/16/2023 East West Bank CD 6/20/2023 Alliance Bank CD 6/27/2023 FHLB 6/29/2023 R Bank CD 6/30/2023 Alliance Bank CD 7/1/2023 FHLB 7/31/2023 East West Bank CD 8/1/2023 Alliance Bank CD 8/2/2023 Bank OZK CD 8/14/2023 East West Bank CD 8/15/2023 East West Bank CD 08/15/23 Texas Capital Bank CD 8/24/2023 FHLB 9/13/2023 FFCB 9/22/2023 Veritex Community Bank CD 9/25/2023 Bank OZK CD 09/30/23 Bank OZK CD 10/9/2023 FHLB 10/13/2023 East West Bank CD 10/18/23 East West Bank CD 10/19/2023 FHLB 10/24/23 Bank OZK CD 11/13/2023 FAMCA 11/22/2023 East West Bank CD 12/11/23 FAMCA 12/13/2023 Alliance Bank CD 12/27/2023 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 Southside Bank CD 2/2/2024 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Independent Financial CD 05/09/24 T-Note 5/15/2024 Alliance Bank CD 6/14/2024 Alliance Bank CD 6/27/2024 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/2024 Totals Book Value March 31, 2023 (Continued) City - 2022 CO Airport City - 2022 CO Fac/Equip/Parks City - 2022 CO Stormwater City - 2022 GO Parks City - 2022 GO Roads City - 2022 CO Electric City - 2022 CO Water/WW City - American Rescue Plan City - Impact Fees - Water City - Impact Fees - WW City - Limited Tax Note, Series 2022 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 512,893 2,544,995 285,644 4,407,763 8,393,483 4,279,361 39,069,046 7,839,223 42,050,571 9,112,481 4,002,526 – – – – 13,605,580 – – – – – – – – – – – – 20,385,946 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,059,706 – – – – – – – – – – 1,271,232 – – – – – – – – – – – – – – – – – – – – – – 3,980,000 19,900,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,100,603 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,015,942 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,344,961 – – – – – – – – – – – 909,814 – – – – – – – – – – – – – – – – – – – – – – – – 25,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,095,648 – – – – – – – – – – – – – – – – – – – – – 9,715,950 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 26,000,000 – – – – – – – – – – – – – – – – – – – – – 10,094,639 – – – – – – – – – – – – – – – – – – – – – 10,168,065 – – – – – – – – – – – – – – – – – – – – – 10,033,071 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,125,753 – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – – – – – – – 10,000,000 – – – – – – – – – – – – – – – – – – – – – 10,125,753 – – – – 512,893$ 3,560,937$ 285,644$ 4,407,763$ 40,674,962$ 9,169,175$ 195,713,872$ 7,839,223$ 67,050,571$ 17,213,084$ 4,002,526$ City of Georgetown Valley View Consulting, L.L.C.53 City - Allocation March 31, 2023 Market Value Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Streets/ Vehicles 2015 GO- Roads 2015 Revenue Water WW 2016 GO- Roads Garey Park Donation 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Roads JPMorgan Chase Cash 758,592$ 758,592$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 436,688 436,688 – – – – – – – – – – – Wells Fargo Bank Cash 42,112 42,112 – – – – – – – – – – – Wells Fargo Bank Sweep-MMF 12,164,479 12,164,479 – – – – – – – – – – – Veritex Community Bank MMA 3,304,419 3,304,419 – – – – – – – – – – – NexBank MMA 12,749,708 12,749,708 – – – – – – – – – – – TexPool 30,752,271 30,752,271 – – – – – – – – – – – TexSTAR 250,398,587 37,854,861 451,459 29,705,689 140,951 1,894,898 1,572,488 431,220 1,086,587 7,762,382 44,041 315,240 1,282,110 East West Bank CD 4/12/2023 13,605,580 – – – – – – – – – – – – East West Bank CD 4/12/2023 20,385,946 – – – – – – – – – – – – Prosperity Bank CD 4/24/2023 5,019,186 5,019,186 – – – – – – – – – – – Prosperity Bank CD 5/1/2023 5,018,361 5,018,361 – – – – – – – – – – – Alliance Bank CD 5/2/2023 4,059,706 – – – – – – – – – – – – Texas Capital Bank CD 5/4/2023 1,271,232 – – – – – – – – – – – – East West Bank CD 5/10/2023 3,070,630 – – – – – – – – 3,070,630 – – – FHLB 5/10/2023 23,887,843 – – – – – – – – – – – – East West Bank CD 5/15/2023 5,085,546 – – – – – – – – – – – – Bank OZK CD 6/12/2023 5,028,894 5,028,894 – – – – – – – – – – – East West Bank CD 6/16/2023 15,359,336 15,359,336 – – – – – – – – – – – Texas Capital Bank CD 6/16/2023 5,085,517 5,085,517 – – – – – – – – – – – East West Bank CD 6/20/2023 2,560,349 – – – – – – – – – – – – Alliance Bank CD 6/27/2023 8,100,603 – – – – – – – – – – – – FHLB 6/29/2023 9,887,246 9,887,246 – – – – – – – – – – – R Bank CD 6/30/2023 1,012,842 1,012,842 – – – – – – – – – – – Alliance Bank CD 7/1/2023 4,093,809 4,093,809 – – – – – – – – – – – FHLB 7/31/2023 4,922,799 4,922,799 – – – – – – – – – – – East West Bank CD 8/1/2023 2,047,081 – – – – – – – – – – – – Alliance Bank CD 8/2/2023 1,015,942 – – – – – – – – – – – – Bank OZK CD 8/14/2023 5,014,037 5,014,037 – – – – – – – – – – – East West Bank CD 8/15/2023 5,107,694 – – – – – – – – – – – – East West Bank CD 08/15/23 4,093,834 – – – – – – – – – – – – Texas Capital Bank CD 8/24/2023 2,548,378 2,548,378 – – – – – – – – – – – FHLB 9/13/2023 13,279,879 – – – – – – – – – – – – FFCB 9/22/2023 905,050 – – – – – – – – – – – – Veritex Community Bank CD 9/25/2023 10,037,463 10,037,463 – – – – – – – – – – – Bank OZK CD 09/30/23 25,000,000 – – – – – – – – – – – – Bank OZK CD 10/9/2023 5,014,227 5,014,227 – – – – – – – – – – – FHLB 10/13/2023 2,438,472 2,438,472 – – – – – – – – – – – East West Bank CD 10/18/23 10,095,648 – – – – – – – – – – – – East West Bank CD 10/19/2023 2,551,403 2,551,403 – – – – – – – – – – – FHLB 10/24/23 9,740,046 – – – – – – – – – – – – Bank OZK CD 11/13/2023 10,040,071 10,040,071 – – – – – – – – – – – FAMCA 11/22/2023 1,999,879 1,999,879 – – – – – – – – – – – East West Bank CD 12/11/23 9,030,049 9,030,049 – – – – – – – – – – – FAMCA 12/13/2023 9,986,696 9,986,696 – – – – – – – – – – – Alliance Bank CD 12/27/2023 1,012,575 1,012,575 – – – – – – – – – – – Bank OZK CD 12/30/23 26,000,000 – – – – – – – – – – – – Alliance Bank CD 01/12/24 5,000,000 5,000,000 – – – – – – – – – – – East West Bank CD 01/18/24 10,094,639 – – – – – – – – – – – – Veritex Community Bank CD 01/23/24 10,078,388 10,078,388 – – – – – – – – – – – Southside Bank CD 2/2/2024 10,168,065 – – – – – – – – – – – – FHLB 02/28/24 20,084,080 20,084,080 – – – – – – – – – – – East West Bank CD 03/11/24 10,033,071 – – – – – – – – – – – – BOK Financial CD 03/23/24 8,009,630 8,009,630 – – – – – – – – – – – Independent Financial CD 05/09/24 8,000,000 8,000,000 – – – – – – – – – – – T-Note 5/15/2024 1,907,656 1,907,656 – – – – – – – – – – – Alliance Bank CD 6/14/2024 10,125,753 – – – – – – – – – – – – Alliance Bank CD 6/27/2024 13,265,333 13,265,333 – – – – – – – – – – – Independent Financial CD 07/24/24 10,000,000 – – – – – – – – – – – – FHLB 07/26/24 10,065,863 – – – – – – – – – – – – FFCB 08/21/24 4,009,236 4,009,236 – – – – – – – – – – – Alliance Bank CD 12/13/2024 10,125,753 – – – – – – – – – – – – Totals 745,988,174$ 283,518,692$ 451,459$ 29,705,689$ 140,951$ 1,894,898$ 1,572,488$ 431,220$ 1,086,587$ 10,833,012$ 44,041$ 315,240$ 1,282,110$ City of Georgetown Valley View Consulting, L.L.C.54 City - Allocation March 31, 2023 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR East West Bank CD 4/12/2023 East West Bank CD 4/12/2023 Prosperity Bank CD 4/24/2023 Prosperity Bank CD 5/1/2023 Alliance Bank CD 5/2/2023 Texas Capital Bank CD 5/4/2023 East West Bank CD 5/10/2023 FHLB 5/10/2023 East West Bank CD 5/15/2023 Bank OZK CD 6/12/2023 East West Bank CD 6/16/2023 Texas Capital Bank CD 6/16/2023 East West Bank CD 6/20/2023 Alliance Bank CD 6/27/2023 FHLB 6/29/2023 R Bank CD 6/30/2023 Alliance Bank CD 7/1/2023 FHLB 7/31/2023 East West Bank CD 8/1/2023 Alliance Bank CD 8/2/2023 Bank OZK CD 8/14/2023 East West Bank CD 8/15/2023 East West Bank CD 08/15/23 Texas Capital Bank CD 8/24/2023 FHLB 9/13/2023 FFCB 9/22/2023 Veritex Community Bank CD 9/25/2023 Bank OZK CD 09/30/23 Bank OZK CD 10/9/2023 FHLB 10/13/2023 East West Bank CD 10/18/23 East West Bank CD 10/19/2023 FHLB 10/24/23 Bank OZK CD 11/13/2023 FAMCA 11/22/2023 East West Bank CD 12/11/23 FAMCA 12/13/2023 Alliance Bank CD 12/27/2023 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 Southside Bank CD 2/2/2024 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Independent Financial CD 05/09/24 T-Note 5/15/2024 Alliance Bank CD 6/14/2024 Alliance Bank CD 6/27/2024 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/2024 Totals (Continued) 2019 CO- Streets/ Facilities/ Equip 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 CO- Stormwater 2020 GO- Roads Electric-LCRA Transformers City - 2021 CO Airport City - 2021 CO Fac/Equip/ Parks City - 2021 GO Parks City - 2021 GO Roads City - 2021A CO Electric City - 2021A CO Water/WW City - 2021A GO Roads –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,137,096 2,798,356 613,672 114 4,116,405 3,798,399 718,563 5,507,046 175,586 3,026,941 434,425 6,022,715 12,009,359 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,085,546 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,560,349 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,047,081 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,107,694 – – – – – – – 4,093,834 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,137,096$ 2,798,356$ 613,672$ 114$ 6,163,486$ 3,798,399$ 718,563$ 9,600,880$ 175,586$ 3,026,941$ 434,425$ 8,583,063$ 22,202,598$ City of Georgetown Valley View Consulting, L.L.C.55 City - Allocation March 31, 2023 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR East West Bank CD 4/12/2023 East West Bank CD 4/12/2023 Prosperity Bank CD 4/24/2023 Prosperity Bank CD 5/1/2023 Alliance Bank CD 5/2/2023 Texas Capital Bank CD 5/4/2023 East West Bank CD 5/10/2023 FHLB 5/10/2023 East West Bank CD 5/15/2023 Bank OZK CD 6/12/2023 East West Bank CD 6/16/2023 Texas Capital Bank CD 6/16/2023 East West Bank CD 6/20/2023 Alliance Bank CD 6/27/2023 FHLB 6/29/2023 R Bank CD 6/30/2023 Alliance Bank CD 7/1/2023 FHLB 7/31/2023 East West Bank CD 8/1/2023 Alliance Bank CD 8/2/2023 Bank OZK CD 8/14/2023 East West Bank CD 8/15/2023 East West Bank CD 08/15/23 Texas Capital Bank CD 8/24/2023 FHLB 9/13/2023 FFCB 9/22/2023 Veritex Community Bank CD 9/25/2023 Bank OZK CD 09/30/23 Bank OZK CD 10/9/2023 FHLB 10/13/2023 East West Bank CD 10/18/23 East West Bank CD 10/19/2023 FHLB 10/24/23 Bank OZK CD 11/13/2023 FAMCA 11/22/2023 East West Bank CD 12/11/23 FAMCA 12/13/2023 Alliance Bank CD 12/27/2023 Bank OZK CD 12/30/23 Alliance Bank CD 01/12/24 East West Bank CD 01/18/24 Veritex Community Bank CD 01/23/24 Southside Bank CD 2/2/2024 FHLB 02/28/24 East West Bank CD 03/11/24 BOK Financial CD 03/23/24 Independent Financial CD 05/09/24 T-Note 5/15/2024 Alliance Bank CD 6/14/2024 Alliance Bank CD 6/27/2024 Independent Financial CD 07/24/24 FHLB 07/26/24 FFCB 08/21/24 Alliance Bank CD 12/13/2024 Totals (Continued) City - 2022 CO Airport City - 2022 CO Fac/Equip/Parks City - 2022 CO Stormwater City - 2022 GO Parks City - 2022 GO Roads City - 2022 CO Electric City - 2022 CO Water/WW City - American Rescue Plan City - Impact Fees - Water City - Impact Fees - WW City - Limited Tax Note, Series 2022 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 512,893 2,544,995 285,644 4,407,763 8,393,483 4,279,361 39,069,046 7,839,223 42,050,571 9,112,481 4,002,526 – – – – 13,605,580 – – – – – – – – – – – – 20,385,946 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,059,706 – – – – – – – – – – 1,271,232 – – – – – – – – – – – – – – – – – – – – – – 3,981,307 19,906,536 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,100,603 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,015,942 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,279,879 – – – – – – – – – – – 905,050 – – – – – – – – – – – – – – – – – – – – – – – – 25,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,095,648 – – – – – – – – – – – – – – – – – – – – – 9,740,046 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 26,000,000 – – – – – – – – – – – – – – – – – – – – – 10,094,639 – – – – – – – – – – – – – – – – – – – – – 10,168,065 – – – – – – – – – – – – – – – – – – – – – 10,033,071 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,125,753 – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – – – – – – – 10,065,863 – – – – – – – – – – – – – – – – – – – – – 10,125,753 – – – – 512,893$ 3,560,937$ 285,644$ 4,407,763$ 40,609,880$ 9,165,719$ 195,810,368$ 7,839,223$ 67,050,571$ 17,213,084$ 4,002,526$ City of Georgetown Valley View Consulting, L.L.C.56 City - Allocation Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Streets/ Vehicles 2015 GO- Roads 2015 Revenue Water WW 2016 GO- Roads Garey Park Donation 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Roads JPMorgan Chase Cash 5,700,533$ 5,700,533$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 435,297 435,297 – – – – – – – – – – – Wells Fargo Bank Cash 1,416,799 1,416,799 – – – – – – – – – – – Wells Fargo Bank Sweep-MMF 11,481,710 11,481,710 – – – – – – – – – – – Veritex Community Bank MMA 3,267,942 3,267,942 – – – – – – – – – – – NexBank MMA 12,604,419 12,604,419 – – – – – – – – – – – TexPool 66,599,765 66,599,765 – – – – – – – – – – – TexSTAR 253,794,295 28,292,274 456,480 4,702,961 139,416 1,874,265 1,555,365 412,069 1,074,756 7,751,060 54,870 327,804 1,466,696 R Bank CD 01/05/23 1,009,065 1,009,065 – – – – – – – – – – – East West Bank CD 01/09/23 5,031,223 5,031,223 – – – – – – – – – – – East West Bank CD 01/20/23 10,048,462 10,048,462 – – – – – – – – – – – Alliance Bank CD 02/02/23 4,028,230 – – – – – – – – – – – – Texas Capital Bank CD 02/04/23 7,822,869 – – – – – – – – – – – – East West Bank CD 02/07/23 5,937,128 – – – – – – – – – – – – East West Bank CD 02/08/23 8,059,708 8,059,708 – – – – – – – – – – – East West Bank CD 02/15/23 4,052,958 – – – – – – – – – – – – Bank OZK CD 02/23/23 4,210,154 4,210,154 – – – – – – – – – – – East West Bank CD 02/27/23 20,203,158 20,203,158 – – – – – – – – – – – Veritex Community Bank CD 03/09/23 4,009,005 4,009,005 – – – – – – – – – – – East West Bank CD 03/14/23 15,139,111 15,139,111 – – – – – – – – – – – T-Bill 03/16/23 496,406 – – – – – – – – – – – – T-Bill 03/16/23 25,862,766 – – – – – – – – – – – – R Bank CD 03/23/23 4,537,510 – – – – – – – – – – – – East West Bank CD 03/27/23 25,250,406 – – – – – – – – – – – – East West Bank CD 04/12/23 13,469,398 – – – – – – – – – – – – East West Bank CD 04/12/23 20,181,897 – – – – – – – – – – – – Prosperity Bank CD 04/24/23 5,016,711 5,016,711 – – – – – – – – – – – Prosperity Bank CD 05/01/23 5,015,887 5,015,887 – – – – – – – – – – – Alliance Bank CD 05/02/23 4,029,742 – – – – – – – – – – – – Texas Capital Bank CD 05/04/23 1,262,175 – – – – – – – – – – – – East West Bank CD 05/10/23 3,046,348 – – – – – – – – 3,046,348 – – – FHLB 05/10/23 23,610,000 – – – – – – – – – – – – East West Bank CD 05/15/23 5,029,184 – – – – – – – – – – – – Bank OZK CD 06/12/23 5,026,402 5,026,402 – – – – – – – – – – – East West Bank CD 06/16/23 15,246,518 15,246,518 – – – – – – – – – – – Texas Capital Bank CD 06/16/23 5,042,813 5,042,813 – – – – – – – – – – – East West Bank CD 06/20/23 2,541,856 – – – – – – – – – – – – Alliance Bank CD 06/27/23 8,000,000 – – – – – – – – – – – – FHLB 06/29/23 9,807,750 9,807,750 – – – – – – – – – – – R Bank CD 06/30/23 1,011,020 1,011,020 – – – – – – – – – – – Alliance Bank CD 07/01/23 4,062,754 4,062,754 – – – – – – – – – – – FHLB 07/31/23 4,872,947 4,872,947 – – – – – – – – – – – East West Bank CD 08/01/23 2,031,744 – – – – – – – – – – – – Alliance Bank CD 08/02/23 1,007,940 – – – – – – – – – – – – Bank OZK CD 08/14/23 5,011,429 5,011,429 – – – – – – – – – – – East West Bank CD 08/15/23 5,050,589 – – – – – – – – – – – – Texas Capital Bank CD 08/24/23 2,527,727 2,527,727 – – – – – – – – – – – FHLB 09/13/23 13,342,228 – – – – – – – – – – – – FFCB 09/22/23 902,004 – – – – – – – – – – – – Veritex Community Bank CD 09/25/23 10,031,278 10,031,278 – – – – – – – – – – – Bank OZK CD 10/09/23 5,011,742 5,011,742 – – – – – – – – – – – FHLB 10/13/23 2,413,406 2,413,406 – – – – – – – – – – – East West Bank CD 10/19/23 2,523,065 2,523,065 – – – – – – – – – – – Bank OZK CD 11/13/23 10,032,623 10,032,623 – – – – – – – – – – – FAMCA 11/22/23 2,000,000 2,000,000 – – – – – – – – – – – FAMCA 12/13/23 10,000,000 10,000,000 – – – – – – – – – – – Alliance Bank CD 12/27/23 1,000,000 1,000,000 – – – – – – – – – – – Southside Bank CD 02/02/24 10,083,682 – – – – – – – – – – – – T-Note 05/15/24 1,882,662 1,882,662 – – – – – – – – – – – Alliance Bank CD 06/14/24 10,000,000 – – – – – – – – – – – – Alliance Bank CD 06/27/24 13,100,588 13,100,588 – – – – – – – – – – – Alliance Bank CD 12/13/24 10,000,000 – – – – – – – – – – – – Totals 755,225,031$ 318,145,949$ 456,480$ 4,702,961$ 139,416$ 1,874,265$ 1,555,365$ 412,069$ 1,074,756$ 10,797,408$ 54,870$ 327,804$ 1,466,696$ December 31, 2022 Book Value City of Georgetown Valley View Consulting, L.L.C.57 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR R Bank CD 01/05/23 East West Bank CD 01/09/23 East West Bank CD 01/20/23 Alliance Bank CD 02/02/23 Texas Capital Bank CD 02/04/23 East West Bank CD 02/07/23 East West Bank CD 02/08/23 East West Bank CD 02/15/23 Bank OZK CD 02/23/23 East West Bank CD 02/27/23 Veritex Community Bank CD 03/09/23 East West Bank CD 03/14/23 T-Bill 03/16/23 T-Bill 03/16/23 R Bank CD 03/23/23 East West Bank CD 03/27/23 East West Bank CD 04/12/23 East West Bank CD 04/12/23 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Alliance Bank CD 05/02/23 Texas Capital Bank CD 05/04/23 East West Bank CD 05/10/23 FHLB 05/10/23 East West Bank CD 05/15/23 Bank OZK CD 06/12/23 East West Bank CD 06/16/23 Texas Capital Bank CD 06/16/23 East West Bank CD 06/20/23 Alliance Bank CD 06/27/23 FHLB 06/29/23 R Bank CD 06/30/23 Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 10/09/23 FHLB 10/13/23 East West Bank CD 10/19/23 Bank OZK CD 11/13/23 FAMCA 11/22/23 FAMCA 12/13/23 Alliance Bank CD 12/27/23 Southside Bank CD 02/02/24 T-Note 05/15/24 Alliance Bank CD 06/14/24 Alliance Bank CD 06/27/24 Alliance Bank CD 12/13/24 Totals December 31, 2022 Book Value (Continued) 2019 CO- Streets/ Facilities/ Equip 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 CO- Stormwater 2020 GO- Roads 2020 Revenue- Water/WW Electric-LCRA Transformers City - 2021 CO Airport City - 2021 CO Fac/Equip/ Parks City - 2021 GO Parks City - 2021 GO Roads City - 2021A CO Electric City - 2021A CO Water/WW City - 2021A GO Roads –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,091,276 2,784,486 606,990 264,917 4,064,654 1,189 3,822,770 710,739 3,584,136 194,080 3,823,080 440,012 8,665,713 10,361,819 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,052,958 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,520,839 – – – – 2,016,671 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,029,184 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,541,856 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,031,744 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,050,589 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,091,276$ 2,784,486$ 606,990$ 264,917$ 6,096,398$ 1,189$ 3,822,770$ 710,739$ 10,157,933$ 194,080$ 3,823,080$ 440,012$ 11,207,569$ 22,458,263$ City of Georgetown Valley View Consulting, L.L.C.58 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep-MMF Veritex Community Bank MMA NexBank MMA TexPool TexSTAR R Bank CD 01/05/23 East West Bank CD 01/09/23 East West Bank CD 01/20/23 Alliance Bank CD 02/02/23 Texas Capital Bank CD 02/04/23 East West Bank CD 02/07/23 East West Bank CD 02/08/23 East West Bank CD 02/15/23 Bank OZK CD 02/23/23 East West Bank CD 02/27/23 Veritex Community Bank CD 03/09/23 East West Bank CD 03/14/23 T-Bill 03/16/23 T-Bill 03/16/23 R Bank CD 03/23/23 East West Bank CD 03/27/23 East West Bank CD 04/12/23 East West Bank CD 04/12/23 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Alliance Bank CD 05/02/23 Texas Capital Bank CD 05/04/23 East West Bank CD 05/10/23 FHLB 05/10/23 East West Bank CD 05/15/23 Bank OZK CD 06/12/23 East West Bank CD 06/16/23 Texas Capital Bank CD 06/16/23 East West Bank CD 06/20/23 Alliance Bank CD 06/27/23 FHLB 06/29/23 R Bank CD 06/30/23 Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 10/09/23 FHLB 10/13/23 East West Bank CD 10/19/23 Bank OZK CD 11/13/23 FAMCA 11/22/23 FAMCA 12/13/23 Alliance Bank CD 12/27/23 Southside Bank CD 02/02/24 T-Note 05/15/24 Alliance Bank CD 06/14/24 Alliance Bank CD 06/27/24 Alliance Bank CD 12/13/24 Totals December 31, 2022 Book Value (Continued) City - 2022 CO Airport City - 2022 CO Fac/Equip/Parks City - 2022 CO Stormwater City - 2022 GO Parks City - 2022 GO Roads City - 2022 CO Electric City - 2022 CO Water/WW City - American Rescue Plan City - Impact Fees - Water City - Impact Fees - WW City - Limited Tax Note, Series 2022 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 507,308 2,800,971 11,196 425,091 583,384 7,340 100,224,259 7,754,191 39,320,433 4,596,665 4,039,581 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,028,230 – – – – – – – – – – – 7,822,869 – – – – – – – – – – 5,937,128 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 496,406 – – – – – – – – – – – – – – 25,862,766 – – – – – – – – – – – – – – – – – – – – – – – 25,250,406 – – – – – – 13,469,398 – – – – – – – – – – – – 20,181,897 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,029,742 – – – – – – – – – – 1,262,175 – – – – – – – – – – – – – – – – – – – – – – 3,935,000 19,675,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,007,940 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,342,228 – – – – – – – – – – – 902,004 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,083,682 – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – 507,308$ 3,808,910$ 507,603$ 4,453,321$ 40,509,796$ 10,781,472$ 196,027,604$ 7,754,191$ 64,570,839$ 12,596,665$ 4,039,581$ City of Georgetown Valley View Consulting, L.L.C.59 City - Allocation December 31, 2022 Market Value Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Streets/ Vehicles 2015 GO- Roads 2015 Revenue Water WW 2016 GO- Roads Garey Park Donation 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Roads JPMorgan Chase Cash 5,700,533$ 5,700,533$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 435,297 435,297 – – – – – – – – – – – Wells Fargo Bank Cash 1,416,799 1,416,799 – – – – – – – – – – – Wells Fargo Bank Sweep 11,481,710 11,481,710 – – – – – – – – – – – Veritex Community Bank MMA 3,267,942 3,267,942 – – – – – – – – – – – NexBank MMA 12,604,419 12,604,419 – – – – – – – – – – – TexPool 66,599,765 66,599,765 – – – – – – – – – – – TexSTAR 253,794,295 28,292,274 456,480 4,702,961 139,416 1,874,265 1,555,365 412,069 1,074,756 7,751,060 54,870 327,804 1,466,696 R Bank CD 01/05/23 1,009,065 1,009,065 – – – – – – – – – – – East West Bank CD 01/09/23 5,031,223 5,031,223 – – – – – – – – – – – East West Bank CD 01/20/23 10,048,462 10,048,462 – – – – – – – – – – – Alliance Bank CD 02/02/23 4,028,230 – – – – – – – – – – – – Texas Capital Bank CD 02/04/23 7,822,869 – – – – – – – – – – – – East West Bank CD 02/07/23 5,937,128 – – – – – – – – – – – – East West Bank CD 02/08/23 8,059,708 8,059,708 – – – – – – – – – – – East West Bank CD 02/15/23 4,052,958 – – – – – – – – – – – – Bank OZK CD 02/23/23 4,210,154 4,210,154 – – – – – – – – – – – East West Bank CD 02/27/23 20,203,158 20,203,158 – – – – – – – – – – – Veritex Community Bank CD 03/09/23 4,009,005 4,009,005 – – – – – – – – – – – East West Bank CD 03/14/23 15,139,111 15,139,111 – – – – – – – – – – – T-Bill 03/16/23 495,780 – – – – – – – – – – – – T-Bill 03/16/23 25,830,115 – – – – – – – – – – – – R Bank CD 03/23/23 4,537,510 – – – – – – – – – – – – East West Bank CD 03/27/23 25,250,406 – – – – – – – – – – – – East West Bank CD 04/12/23 13,469,398 – – – – – – – – – – – – East West Bank CD 04/12/23 20,181,897 – – – – – – – – – – – – Prosperity Bank CD 04/24/23 5,016,711 5,016,711 – – – – – – – – – – – Prosperity Bank CD 05/01/23 5,015,887 5,015,887 – – – – – – – – – – – Alliance Bank CD 05/02/23 4,029,742 – – – – – – – – – – – – Texas Capital Bank CD 05/04/23 1,262,175 – – – – – – – – – – – – East West Bank CD 05/10/23 3,046,348 – – – – – – – – 3,046,348 – – – FHLB 05/10/23 23,625,418 – – – – – – – – – – – – East West Bank CD 05/15/23 5,029,184 – – – – – – – – – – – – Bank OZK CD 06/12/23 5,026,402 5,026,402 – – – – – – – – – – – East West Bank CD 06/16/23 15,246,518 15,246,518 – – – – – – – – – – – Texas Capital Bank CD 06/16/23 5,042,813 5,042,813 – – – – – – – – – – – East West Bank CD 06/20/23 2,541,856 – – – – – – – – – – – – Alliance Bank CD 06/27/23 8,000,000 – – – – – – – – – – – – FHLB 06/29/23 9,780,388 9,780,388 – – – – – – – – – – – R Bank CD 06/30/23 1,011,020 1,011,020 – – – – – – – – – – – Alliance Bank CD 07/01/23 4,062,754 4,062,754 – – – – – – – – – – – FHLB 07/31/23 4,871,584 4,871,584 – – – – – – – – – – – East West Bank CD 08/01/23 2,031,744 – – – – – – – – – – – – Alliance Bank CD 08/02/23 1,007,940 – – – – – – – – – – – – Bank OZK CD 08/14/23 5,011,429 5,011,429 – – – – – – – – – – – East West Bank CD 08/15/23 5,050,589 – – – – – – – – – – – – Texas Capital Bank CD 08/24/23 2,527,727 2,527,727 – – – – – – – – – – – FHLB 09/13/23 13,243,515 – – – – – – – – – – – – FFCB 09/22/23 895,065 – – – – – – – – – – – – Veritex Community Bank CD 09/25/23 10,031,278 10,031,278 – – – – – – – – – – – Bank OZK CD 10/09/23 5,011,742 5,011,742 – – – – – – – – – – – FHLB 10/13/23 2,413,950 2,413,950 – – – – – – – – – – – East West Bank CD 10/19/23 2,523,065 2,523,065 – – – – – – – – – – – Bank OZK CD 11/13/23 10,032,623 10,032,623 – – – – – – – – – – – FAMCA 11/22/23 1,999,938 1,999,938 – – – – – – – – – – – FAMCA 12/13/23 9,982,024 9,982,024 – – – – – – – – – – – Alliance Bank CD 12/27/23 1,000,000 1,000,000 – – – – – – – – – – – Southside Bank CD 02/02/24 10,083,682 – – – – – – – – – – – – T-Note 05/15/24 1,882,813 1,882,813 – – – – – – – – – – – Alliance Bank CD 06/14/24 10,000,000 – – – – – – – – – – – – Alliance Bank CD 06/27/24 13,100,588 13,100,588 – – – – – – – – – – – Alliance Bank CD 12/13/24 10,000,000 – – – – – – – – – – – – Totals 755,055,451$ 318,099,881$ 456,480$ 4,702,961$ 139,416$ 1,874,265$ 1,555,365$ 412,069$ 1,074,756$ 10,797,408$ 54,870$ 327,804$ 1,466,696$ City of Georgetown Valley View Consulting, L.L.C.60 City - Allocation December 31, 2022 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep Veritex Community Bank MMA NexBank MMA TexPool TexSTAR R Bank CD 01/05/23 East West Bank CD 01/09/23 East West Bank CD 01/20/23 Alliance Bank CD 02/02/23 Texas Capital Bank CD 02/04/23 East West Bank CD 02/07/23 East West Bank CD 02/08/23 East West Bank CD 02/15/23 Bank OZK CD 02/23/23 East West Bank CD 02/27/23 Veritex Community Bank CD 03/09/23 East West Bank CD 03/14/23 T-Bill 03/16/23 T-Bill 03/16/23 R Bank CD 03/23/23 East West Bank CD 03/27/23 East West Bank CD 04/12/23 East West Bank CD 04/12/23 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Alliance Bank CD 05/02/23 Texas Capital Bank CD 05/04/23 East West Bank CD 05/10/23 FHLB 05/10/23 East West Bank CD 05/15/23 Bank OZK CD 06/12/23 East West Bank CD 06/16/23 Texas Capital Bank CD 06/16/23 East West Bank CD 06/20/23 Alliance Bank CD 06/27/23 FHLB 06/29/23 R Bank CD 06/30/23 Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 10/09/23 FHLB 10/13/23 East West Bank CD 10/19/23 Bank OZK CD 11/13/23 FAMCA 11/22/23 FAMCA 12/13/23 Alliance Bank CD 12/27/23 Southside Bank CD 02/02/24 T-Note 05/15/24 Alliance Bank CD 06/14/24 Alliance Bank CD 06/27/24 Alliance Bank CD 12/13/24 Totals (Continued) 2019 CO- Streets/ Facilities/ Equip 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 CO- Stormwater 2020 GO- Roads 2020 Revenue- Water/WW Electric-LCRA Transformers City - 2021 CO Airport City - 2021 CO Fac/Equip/ Parks City - 2021 GO Parks City - 2021 GO Roads City - 2021A CO Electric City - 2021A CO Water/WW City - 2021A GO Roads –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,091,276 2,784,486 606,990 264,917 4,064,654 1,189 3,822,770 710,739 3,584,136 194,080 3,823,080 440,012 8,665,713 10,361,819 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,052,958 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,520,839 – – – – 2,016,671 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,029,184 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,541,856 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,031,744 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 5,050,589 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,091,276$ 2,784,486$ 606,990$ 264,917$ 6,096,398$ 1,189$ 3,822,770$ 710,739$ 10,157,933$ 194,080$ 3,823,080$ 440,012$ 11,207,569$ 22,458,263$ City of Georgetown Valley View Consulting, L.L.C.61 City - Allocation December 31, 2022 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep Veritex Community Bank MMA NexBank MMA TexPool TexSTAR R Bank CD 01/05/23 East West Bank CD 01/09/23 East West Bank CD 01/20/23 Alliance Bank CD 02/02/23 Texas Capital Bank CD 02/04/23 East West Bank CD 02/07/23 East West Bank CD 02/08/23 East West Bank CD 02/15/23 Bank OZK CD 02/23/23 East West Bank CD 02/27/23 Veritex Community Bank CD 03/09/23 East West Bank CD 03/14/23 T-Bill 03/16/23 T-Bill 03/16/23 R Bank CD 03/23/23 East West Bank CD 03/27/23 East West Bank CD 04/12/23 East West Bank CD 04/12/23 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Alliance Bank CD 05/02/23 Texas Capital Bank CD 05/04/23 East West Bank CD 05/10/23 FHLB 05/10/23 East West Bank CD 05/15/23 Bank OZK CD 06/12/23 East West Bank CD 06/16/23 Texas Capital Bank CD 06/16/23 East West Bank CD 06/20/23 Alliance Bank CD 06/27/23 FHLB 06/29/23 R Bank CD 06/30/23 Alliance Bank CD 07/01/23 FHLB 07/31/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/23 East West Bank CD 08/15/23 Texas Capital Bank CD 08/24/23 FHLB 09/13/23 FFCB 09/22/23 Veritex Community Bank CD 09/25/23 Bank OZK CD 10/09/23 FHLB 10/13/23 East West Bank CD 10/19/23 Bank OZK CD 11/13/23 FAMCA 11/22/23 FAMCA 12/13/23 Alliance Bank CD 12/27/23 Southside Bank CD 02/02/24 T-Note 05/15/24 Alliance Bank CD 06/14/24 Alliance Bank CD 06/27/24 Alliance Bank CD 12/13/24 Totals (Continued) City - 2022 CO Airport City - 2022 CO Fac/Equip/Parks City - 2022 CO Stormwater City - 2022 GO Parks City - 2022 GO Roads City - 2022 CO Electric City - 2022 CO Water/WW City - American Rescue Plan City - Impact Fees - Water City - Impact Fees - WW City - Limited Tax Note, Series 2022 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 507,308 2,800,971 11,196 425,091 583,384 7,340 100,224,259 7,754,191 39,320,433 4,596,665 4,039,581 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,028,230 – – – – – – – – – – – 7,822,869 – – – – – – – – – – – 5,937,128 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 495,780 – – – – – – – – – – – – – – 25,830,115 – – – – – – – – – – – – – – – – – – – – – – – 25,250,406 – – – – – – 13,469,398 – – – – – – – – – – – – 20,181,897 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,029,742 – – – – – – – – – – 1,262,175 – – – – – – – – – – – – – – – – – – – – – – 3,937,570 19,687,848 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 8,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,007,940 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,243,515 – – – – – – – – – – – 895,065 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,083,682 – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – 507,308$ 3,808,910$ 506,976$ 4,453,321$ 40,411,083$ 10,777,103$ 196,007,801$ 7,754,191$ 64,570,839$ 12,596,665$ 4,039,581$ City of Georgetown Valley View Consulting, L.L.C.62 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield MMA 2,166,883$ 2,166,883$ 2,191,077$ 2,191,077$ 4.83% Pools 7,698,466 7,698,466 8,038,391 8,038,391 4.63% 9,865,349$ 9,865,349$ 10,229,468$ 10,229,468$ 4.67% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 4.67%Total Portfolio 4.36% Rolling Three Month Treasury 4.78%Rolling Three Month Treasury 4.49% Rolling Six Month Treasury 4.73%Rolling Six Month Treasury 4.32% TexPool 4.61%TexPool 4.30% Interest income provided in separate report. December 31, 2022 (1) Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank, pool, and money market balances. (2) Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. March 31, 2023 Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.64 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 4.83%04/01/23 03/31/23 2,191,077$ 2,191,077$ 1.00 2,191,077$ 1 4.83% TexasDAILY AAAm 4.70%04/01/23 03/31/23 2,184,423 2,184,423 1.00 2,184,423 1 4.70% TexSTAR AAAm 4.61%04/01/23 03/31/23 5,853,968 5,853,968 1.00 5,853,968 1 4.61% 10,229,468$ 10,229,468$ 10,229,468$ 1 4.67% (1)(2) March 31, 2023 (1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity. (2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds. Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.66 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield Pools/MMAs 33,147,006$ 33,147,006$ 36,212,462$ 36,212,462$ 4.63% CDs/Securities 9,921,428 9,922,663 9,976,394 9,975,810 4.40%Totals 43,068,435$ 43,069,669$ 46,188,855$ 46,188,271$ 4.58% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 4.58%Total Portfolio 4.29% Rolling Three Month Treasury 4.78%Rolling Three Month Treasury 4.49% Rolling Six Month Treasury 4.73%Rolling Six Month Treasury 4.32% TexPool 4.61%TexPool 4.30% Interest data provided in separate report. December 31, 2022 (1) Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank, pool, and money market balances. (2) Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. March 31, 2023 Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.70 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 4.61%04/01/23 03/31/23 24,659,744$ 24,659,744$ 1.00 24,659,744$ 1 4.61% TexSTAR AAAm 4.61%04/01/23 03/31/23 8,787,994 8,787,994 1.00 8,787,994 1 4.61% Veritex Bank MMA 4.83%04/01/23 03/31/23 2,764,724 2,764,724 1.00 2,764,724 1 4.83% East West Bank CD 3.21%05/25/23 08/25/22 3,058,337 3,058,337 100.00 3,058,337 55 3.26% FAMCA 0.22%08/11/23 11/10/22 5,000,000 4,918,056 98.35 4,917,472 133 4.84% Independent Financial CD 4.95%02/09/24 02/09/23 2,000,000 2,000,000 100.00 2,000,000 315 5.04% TOTALS 46,270,799$ 46,188,855$ 46,188,271$ 32 4.58% (1)(2) March 31, 2023 (1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity. (2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds. Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.72 Department Federal Grantor Pass-Through Agency Identifying Number COG Name/Purpose YTD Expenditures YTD Revenue Recognized Airport Federal Aviation Administration Texas Department of Transportation 21TWGEORG Airport 2021 CARES - Tower 22,654 - Airport Federal Aviation Administration Texas Department of Transportation 2314GRGTN Airport Pavement Project 169,400 - Arts & Culture Texas Commission on the Arts FY22 Performance Grant - Sue Foley 2,250 2,250 Emergency Management US Dept. of the Treasury American Rescue Plan Act SLFRF Funding 25,430 25,430 Library N/A St. David's Foundation St. David's Grant - 1,302 40,000 Planning US Department of Housing & Urban Development Williamson County CDBG 21st St Infrastructure - - Planning US Department of Housing & Urban Development Williamson County CDBG Home Repair (FY21) 20,592 20,592 Police US. Department of Justice N/A TX2460200 Equitable Sharing Agreement - - Police US. Department of Treasury N/A TX2460200 Equitable Sharing Agreement - - Public Works Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ 0914-05-201 Highway Planning & Construction (Lakeway & Williams Drive) - 293,149 Electric Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ 2211-02-019 FM 1460 Road Widening (ROW Acquisition)* - 255,775 Public Works Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ 0914-05-200 Williams Drive Access Management (Study & Schematic) 14,236 14,236 *Expenses were incurred in FY2014-15, but reported here since TXDOT has now approved for reimbursement. Division Grantor COG Name/Purpose Status Public Works/Electric/City- Wide Federal Emergency Management Administration Texas Division of Emergency Management DR-4705-TX Winter Storm Mara Projects are in progress as of 3/31/23 CITY OF GEORGETOWN Grant/Federal Funding Report as of March 31, 2023 Active Applications Pending Award 75