Loading...
HomeMy WebLinkAboutFY 23 - 1st_Qtr_Report_FY2023_RedactedFINANCIAL REPORT AND INVESTMENT REPORT For the Quarter Ended December 31, 2022 Table of Contents General Fund Narrative .............................................................................................................................. 1-7 General Fund Schedule ................................................................................................................................. 8 General Fund by Cost Center ................................................................................................................... 9-11 Electric Fund Narrative ........................................................................................................................... 12-14 Electric Fund Schedule ................................................................................................................................ 15 Water Services Fund Narrative ............................................................................................................... 16-18 Water Services Fund Schedule .................................................................................................................... 19 Convention & Visitors Bureau Narrative................................................................................................. 20-21 Convention & Visitors Bureau Fund Schedule ............................................................................................. 22 Airport Fund Narrative ........................................................................................................................... 23-24 Airport Fund Schedule ................................................................................................................................. 25 Stormwater Services Narrative ............................................................................................................... 26-27 Stormwater Services Fund Schedule ........................................................................................................... 28 Georgetown Transportation Enhancement Corporation Fund Narrative ............................................... 29-30 Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 31 Georgetown Economic Development Corporation Fund Narrative ....................................................... 32-33 Georgetown Economic Development Corporation Fund Schedule ............................................................. 34 Village PID Services Narrative ...................................................................................................................... 35 Village PID Services Fund Schedule ............................................................................................................. 36 Council Discretionary Fund Schedule .......................................................................................................... 37 Joint Services Fund Schedule ....................................................................................................................... 38 Investment Report.................................................................................................................................. 39-41 Quarterly Investment Report - City ........................................................................................................ 42-61 Quarterly Investment Report - GEDCO ................................................................................................... 62-67 Quarterly Investment Report - GTEC ...................................................................................................... 68-73 Grant Applications ....................................................................................................................................... 74 Capital Improvement Projects ................................................................................................................ 75-81 Quarterly Financial Report Sales tax revenue accounts for $30,749,397 of General Fund budgeted revenue. Through the quarter, the City has collected 7.70% of the budgeted sales tax amount, or 2,367,808 year-to- date. Sales tax data lags two months in arrears. Although sales tax continues to perform strongly, with quarterly returns being 8.12% greater than the same period last year, the month-to-month comparison of FY2022 and FY2023 sales tax returns indicates a slowing down of rapid growth recently experienced. The majority of the increase in sales tax can be attributed to growth in the Retail and Other sectors; however, within the retail sector, building materials, which over the past three years has on average accounted for 17.5% of total sales tax, has seen a decrease in year-to-date actuals when compared to the same period during the previous year. Because sales tax is the largest source of revenue in the general fund and also subject to volatility, staff is closely monitoring the City’s core sectors of retail (specifically building materials), food, and information. The City continues to reserve a fully funded (8%) Economic Stability Reserve to protect against any volatility in sales tax revenue. Several, new vacant positions are also on hold while the city monitors sales tax and development revenue. Property tax revenues are the second largest revenue segment in the General Fund and has a budget of $18,700,000. Property tax revenue is typically received during the first two quarters of the fiscal year, with most of the taxes collected in December and January. Through the quarter, property tax year-to-date collections total 51.34% of budget, or $9,600,081. Year-to-date property tax revenues are 4.90% greater than the same period last year. The City collects franchise fees for electric, natural gas, cable, and non-cellular telephone services. Through the quarter, franchise fee revenues total $1,066,666 in FY2023, or 15.64% of budget. Franchise fee revenue is 8.49% higher than the same quarter of FY2022. While most franchise fees saw increases from the same quarter of FY2022, the major increases are from electric, water, garbage and gas franchise fees. Payment in Lieu of Taxes (PILOT) revenue from City-owned utilities is budgeted at $10,615,004. Year-to-date, PILOT revenues total $2,681,263, or 25.26% of budget. PILOT revenue is $78,608, or 3.02%, higher than the same quarter of FY2022. While all utility funds PILOT is trending slightly higher than budget, the majority of the increase for the quarter is from Water and Electric. Electric PILOT was capped at $5.5 million, per Council direction. Planning and Development related revenue has slowed down in FY2023 due to a significant decrease in the number of residential building permits issued. Planning and Development has a total revenue budget of $9,344,155. Through the quarter, planning and development related revenues total $1,813,827 or 19.41% of budget. Permit fees are down 15.54%, or $116,597 compared to the same quarter in FY2022. Development related permits year-to-date revenues are down 20.08%, or $296,425 compared to the same period in FY2022. Staff continues to monitor the amount of residential and commercial building permits. FY2023 development revenue and expenses are also K 500K 1.0M 1.5M 2.0M 2.5M Q1 GENERAL FUND: SALES TAX FY2021 FY2022 FY2023 2 Quarterly Financial Report being closely monitored for economic impacts. The following graph shows the number of residential building permits issued during the first quarter for the past 3 years. Sanitation revenue budget totals $12,095,135. Through the quarter, year-to-date revenues from sanitation is $3,252,628, or 26.89% of budget. Sanitation rates increased as part of the FY2023 budget to support demand for service as well as to support the debt service for a new transfer station. The variance between the same period last year is $243,467, or 8.09%. An environmental services cost of service study wrapping up in the winter of FY2023, with initial results presented to Council in February 2023. Fire and EMS total budgeted revenue is $8,771,250. Through the quarter, Fire and EMS fee related revenue totals $2,198,063, or 25% of budget. Additional Fire/EMS revenue is comprised of the Interlocal Agreement Emergency Services District 8 contract for service, as well as public safety grants revenue. Parks and Recreation fee revenue budget totals $3,263,000. Through the quarter, parks and recreation related fee revenue totals $719,850, or 22.06% of budget. Parks and Recreation revenue is up 21.26% compared to FY2022. The Parks and Recreation department has seen an increase in revenue compared to FY2022 coupled with fee adjustments to align with the cost recovery model approved by Council, and programming returning to pre-pandemic levels. GENERAL FUND EXPENSES: Annual expenses through the quarter total $28,249,711, or 24.79% of budget. This is an increase of 18.71% compared to the same period last year. The increase is driven by increases in operational expense such as internal service allocations, timing of transfers, consulting fees and sanitation services. Additionally, general increases in expenses compared to the same period last year are due to inflation, staff compensation, and new or enhanced programs. Personnel and Operations Summary: Personnel costs through the quarter total $12,987,725, or 21.75% of personnel budget. Operational costs total $15,087,817, or 29.11%. The table below includes all expenditures in the General Fund. Capital costs can fluctuate from year-to-year based on projects, timing, and various other factors, primarily in the Streets cost center. - 200 400 600 800 1,000 Q1 Residential Building Permits FY2021 FY2022 FY2023 3 Quarterly Financial Report FIRE AND EMS DIVISION: Year-to-date personnel and operational expenditures through the quarter total $1,361,964, or 27.84% of budget for Fire Support Services/Administration, $4,985,010, or 24.92% of budget for Fire Emergency Services, and $1,112,342, or 29.95% of budget for Fire EMS. ADMINISTRATIVE SERVICES DIVISION: Administrative Services saw operational and personnel costs totaling $712,693, or 24.42% 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 $316,602, which represents 20.54% of budget. Year-to-date personnel and operational expenditures for Communications totals $404,718, which represents 27.07% of budget. Non-Departmental includes a budget of $1,590,765 for transfers out to various funds. As of the first quarter, 0.00% of anticipated transfer expenses have been made. General Government Contracts includes budgeted vacancy savings estimates for all General Fund departments. Real vacancy savings is realized in each cost center. The budgeted vacancy factor against year-to-date actuals in the administrative division cost center drives the percent of budget up. Additionally, this is where the City budgets for various approved economic development related incentives. LIBRARY, TOURISM, AND ARTS AND CULTURE DIVISION: Arts and Culture recognized year to date expenses totaling $70,098, or 15.56% of budget. Library year-to-date expenses total $893,648, or 23.72% of budget. PARKS AND RECREATION DIVISION: Year-to-date personnel and operations costs for Parks and Recreation within the following cost centers: Parks Administrations, Parks, Garey Park, Tennis Center, Recreation and, comes to a total of $2,761,117, or 24.25% of budget. Parks year-to-date through the quarter totals $980,315, or 27.65% of budget. Recreation total expenses are $1,156,759, which is 21.85% of budget. Garey Park year-to-date is $317,809, or 26.23% 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. 5 Quarterly Financial Report Overall, General Fund expenditures are within budget and the fund can cover the 90-day Contingency Reserve, Economic Stability Reserve, Master Development Fee Reserve (MDF) and the Benefit Payout Reserve. 7 Quarterly Financial Report UTILITY FUNDS: As part of the FY2022 budget development process, the utilities reviewed various initiatives to improve resiliency to extreme weather, including those required by legislation. Both utilities continue to refine cost of service studies to ensure that rates cover these resiliency efforts, the growth pressure and infrastructure demand on the system, and financial targets for liquidity and debt coverage. Based on the updated water master plan and water cost of service study, Council adopted the FY2023 budget, which includes water and wastewater rate increases. Miscellaneous utility fees were also increased in the adopted budget to recover current costs of service for tasks like a trip charge. The Electric cost of service study is ongoing. Electric Fund: 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. ELECTRIC REVENUE: Operating revenue in the Electric Fund totals $23,674,618 through the quarter, or 21.38% of budget. Electric sales revenue, the largest component of operating revenue, has brought in $19,274,298 through the quarter, totaling 21.29% of Electric charges budget. Adjusted meter load (AML) is up approximately 10% compared to Q1 of last fiscal year. Several days in late December were very cold. Developer contributions were budgeted at $11,600,000. Year-to-date collection totals $2,784,894, or 24.01% of budget. Developer contributions drive the need for utility infrastructure. While there is an increase in revenue compared to prior years, there are more new development project expenses than anticipated. Due to global supply chain issues, the cost of material for electric infrastructure projects increased significantly. These cost increases also resulted in increased capital expenses. Developer Contributions and capital expenses amendments were brought to Council in January as part of the CIP-Roll Forward budget amendment. As noted at the beginning of the report, the budget amendment is reflected in this report as of December so that the budget and actuals align. Within the Fee category, the Renewable Energy Credit (REC) revenue budget is $3,082,821. REC sales total $238,250, or 7.73% of budget through the quarter. Pricing of RECs continued to be favorable for the City, and a conservative amount of RECs are sold in the forward market, benefiting the City in later months or in FY2024. K 5.0M 10.0M 15.0M 20.0M 25.0M 30.0M Q1 Electric Fund: Electric Sales Charges FY2021 FY2022 FY2023 12 Quarterly Financial Report Overall, Tourism Fund expenditures are within budget and the fund can cover the 90-day Contingency Reserve. Ending fund balance is budgeted to be $2,023,130 in FY2022 with an operating contingency reserve of $379,320, and a capital reserve of $1,643,810. 21 Quarterly Financial Report VILLAGE PID MONTHLY REPORT AS OF DECEMBER 31, 2023 Village PID Revenues: Village PID budgeted revenues total $530,845 and are comprised of property tax and allocated interest. The City receives the bulk of property tax revenues in January and February. The City anticipates receiving $529,845 in property tax revenue this year, as well as $1,000 in allocated interest. Through the end of the first quarter of FY2023, property tax revenue totals $429,875, or 81.13% of budget. FY2022 Property tax revenue is up 2.77%, or $11,594 compared to FY2021. Collection rates and protested values can affect property tax revenue. Village PID Expenses: Village PID expenses include administrative charges, capital, contractual services, insurance, maintenance, and marketing. Year-to-date operational and capital expenses total $230,328 or 31.95% of budget. The Parks Department has contracted for Parks Capital Improvements which total $6,100 year to date, leaving a remaining budget of $233,420. Ending Fund Balance in FY2023 for Village PID is budgeted at $707,571. After accounting for the contingency reserve of $111,453 and a capital reserve of $40,222, this fund will have a budgeted available fund balance of $555,896. K 200K 400K Q1 PROPERTY TAX REVENUES FY2021 FY2022 FY2023 35 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 first 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 November and December and announced multiple increases in the Fed Funds Rate from 3-3.25% in September 22 to 4.25-4.50% in December 22. The FOMC will meet again Jan 31-Feb 1 and March 21-22 and are expected to increase rates again, but in smaller increments. 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 December 31, 2022. 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 December 31, 2022, 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 42.1%, debt service at .6%, and bond proceeds/grants/reserved fund at 57.3%. The City portfolio increased during this quarter due to receiving the first round of property taxes. The GTEC and GEDCO portfolios increased in this quarter as well. The average yield increased on all portfolios due to increased rates in our pools, newly purchased cd’s, and treasury/agency securities. Rates on securities have helped the city diversify the portfolio compared to the prior year’s holdings. 39 Quarterly Financial Report CITY Market Value GTEC GEDCO 9/30/22 12/31/22 9/30/22 12/31/22 9/30/22 12/31/22 Total cash and investments $731,043,243 $755,055,451 $38,131,640 $43,069,669 $8,733,297 $9,865,349 Quarter End Average Yield 2.08% 3.37% 2.54% 4.00% 2.52% 4.05% 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. The Engineering department is hiring a firm to assist with quicker execution of capital projects. Finance staff are also assisting Economic Development staff with an updated cash flow model for GEDCO to manage incentive agreement payments and potential new projects. The City’s investment portfolio generally includes bank deposits, local government investment pool balances, money market accounts, financial institution deposits (CD’s), and securities/agencies. All of these investments meet the safety requirements of the PFIA. Local Government Investment Pools must maintain a 40 Quarterly Financial Report 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. The City has transitioned the depository bank contract from Chase to Wells Fargo. Staff will work with Wells Fargo to find an average daily balance that is best to receive the highest yield on the account. These balances earn credit against the fees charged by the bank, however, according to the contract, there will not be any fees assessed in the first year. The City will continue to verify depository yield versus investment yield to achieve the best outcome. 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. 41 CITY QUARTERLY INVESTMENT REPORT For the Quarter Ended December 31, 2022 Prepared by Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total return yields and do not account for investment advisor fees.42 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield Demand Accounts 12,506,553$ 12,506,553 5,700,533$ 5,700,533$ 0.30% NOW/MMA 32,888,931 32,888,931 29,206,167 29,206,167 3.97% Pools 373,311,718 373,311,718 320,394,060 320,394,060 3.97% CDs/Securities 312,336,041 312,250,541 399,924,271 399,754,691 2.89% Totals 731,043,243$ 730,957,743$ 755,225,031$ 755,055,451$ 3.37% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 3.37%Total Portfolio 3.37% Rolling Three Month Treasury 4.19%Rolling Three Month Treasury 4.19% Rolling Six Month Treasury 3.90%Rolling Six Month Treasury 3.90% TexPool 3.98%TexPool 3.98% Bank Fees Offset 7,095$ Interest earnings provided in separate report.7,095$ September 30, 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 December 31, 2022 City of Georgetown Valley View Consulting, L.L.C.143 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.30%01/01/23 12/31/22 5,700,533$ 5,700,533$ 1.00 5,700,533$ 1 0.30% JPMorgan Chase MMA 1.15%01/01/23 12/31/22 435,297 435,297 1.00 435,297 1 1.15% Veritex Community Bank MMA 4.17%01/01/23 12/31/22 3,267,942 3,267,942 1.00 3,267,942 1 4.17% Wells Fargo Bank Cash 0.00%01/01/23 12/31/22 1,416,799 1,416,799 1.00 1,416,799 1 0.00% Wells Fargo Bank Sweep 4.04%01/01/23 12/31/22 11,481,710 11,481,710 1.00 11,481,710 1 4.04% NexBank MMA 4.40%01/01/23 12/31/22 12,604,419 12,604,419 1.00 12,604,419 1 4.40% TexPool AAAm 3.98%01/01/23 12/31/22 66,599,765 66,599,765 1.00 66,599,765 1 3.98% TexSTAR AAAm 3.97%01/01/23 12/31/22 253,794,295 253,794,295 1.00 253,794,295 1 3.97% R Bank CD 0.60%01/05/23 06/30/21 1,009,065 1,009,065 100.00 1,009,065 5 0.60% East West Bank CD 0.42%01/09/23 01/07/22 5,031,223 5,031,223 100.00 5,031,223 9 0.42% East West Bank CD 0.51%01/20/23 01/20/22 10,048,462 10,048,462 100.00 10,048,462 20 0.51% Alliance Bank CD 2.80%02/02/23 08/02/22 4,028,230 4,028,230 100.00 4,028,230 33 2.83% Texas Capital Bank CD 2.80%02/04/23 08/04/22 7,822,869 7,822,869 100.00 7,822,869 35 2.80% East West Bank CD 3.12%02/07/23 08/11/22 5,937,128 5,937,128 100.00 5,937,128 38 3.17% East West Bank CD 0.83%02/08/23 02/08/22 8,059,708 8,059,708 100.00 8,059,708 39 0.83% East West Bank CD 3.12%02/15/23 08/15/22 4,052,958 4,052,958 100.00 4,052,958 46 3.12% Bank OZK CD 0.18%02/23/23 08/23/21 4,210,154 4,210,154 100.00 4,210,154 54 0.18% East West Bank CD 1.19%02/27/23 02/25/22 20,203,158 20,203,158 100.00 20,203,158 58 1.20% Veritex Community Bank CD 0.18%03/09/23 09/09/21 4,009,005 4,009,005 100.00 4,009,005 68 0.18% East West Bank CD 1.15%03/14/23 03/14/22 15,139,111 15,139,111 100.00 15,139,111 73 1.16% T-Bill Aaa/AA+0.00%03/16/23 09/15/22 500,000 496,406 99.87 495,780 75 3.56% T-Bill Aaa/AA+0.00%03/16/23 09/15/22 26,050,000 25,862,766 99.87 25,830,115 75 3.56% R Bank CD 3.00%03/23/23 09/22/22 4,537,510 4,537,510 100.00 4,537,510 82 3.05% East West Bank CD 1.29%03/27/23 03/25/22 25,250,406 25,250,406 100.00 25,250,406 86 1.30% East West Bank CD 4.08%04/12/23 10/12/22 13,469,398 13,469,398 100.00 13,469,398 102 4.16% East West Bank CD 4.08%04/12/23 10/12/22 20,181,897 20,181,897 100.00 20,181,897 102 4.16% Prosperity Bank CD 0.20%04/24/23 04/23/21 5,016,711 5,016,711 100.00 5,016,711 114 0.20% Prosperity Bank CD 0.20%05/01/23 05/25/21 5,015,887 5,015,887 100.00 5,015,887 121 0.20% Alliance Bank CD 2.95%05/02/23 08/02/22 4,029,742 4,029,742 100.00 4,029,742 122 2.98% Texas Capital Bank CD 2.90%05/04/23 08/04/22 1,262,175 1,262,175 100.00 1,262,175 124 2.90% East West Bank CD 3.22%05/10/23 08/10/22 3,046,348 3,046,348 100.00 3,046,348 130 3.27% FHLB Aaa/AA+4.60%05/10/23 11/10/22 24,000,000 23,610,000 98.44 23,625,418 130 4.60% East West Bank CD 4.52%05/15/23 11/15/22 5,029,184 5,029,184 100.00 5,029,184 135 4.62% Bank OZK CD 0.20%06/12/23 06/11/21 5,026,402 5,026,402 100.00 5,026,402 163 0.20% East West Bank CD 2.99%06/16/23 06/16/22 15,246,518 15,246,518 100.00 15,246,518 167 3.04% Texas Capital Bank CD 3.42%06/16/23 09/16/22 5,042,813 5,042,813 100.00 5,042,813 167 3.42% December 31, 2022 City of Georgetown Valley View Consulting, L.L.C.345 City - Investment Holdings Coupon/Maturity Settlement Face Amount/Book Market Market Life Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield December 31, 2022 East West Bank CD 2.94%06/20/23 06/22/22 2,541,856 2,541,856 100.00 2,541,856 171 2.98% Alliance Bank CD 5.10%06/27/23 12/27/22 8,000,000 8,000,000 100.00 8,000,000 178 5.20% FHLB Aaa/AA+0.00%06/29/23 09/16/22 10,000,000 9,807,750 99.72 9,780,388 180 3.97% R Bank CD 0.73%06/30/23 06/30/21 1,011,020 1,011,020 100.00 1,011,020 181 0.73% Alliance Bank CD 3.10%07/01/23 07/01/22 4,062,754 4,062,754 100.00 4,062,754 182 3.14% FHLB Aaa/AA+0.00%07/31/23 10/17/22 5,000,000 4,872,947 97.43 4,871,584 212 4.47% East West Bank CD 3.05%08/01/23 08/01/22 2,031,744 2,031,744 100.00 2,031,744 213 3.10% Alliance Bank CD 3.15%08/02/23 08/02/22 1,007,940 1,007,940 100.00 1,007,940 214 3.19% Bank OZK CD 0.21%08/14/23 11/12/21 5,011,429 5,011,429 100.00 5,011,429 226 0.21% East West Bank CD 4.56%08/15/23 11/15/22 5,050,589 5,050,589 100.00 5,050,589 227 4.67% Texas Capital Bank CD 3.30%08/24/23 08/24/22 2,527,727 2,527,727 100.00 2,527,727 236 3.30% FHLB Aaa/AA+3.63%09/13/23 09/13/22 13,350,000 13,342,228 99.26 13,243,515 256 3.71% FFCB Aaa/AA+0.22%09/22/23 09/13/22 925,000 902,004 99.23 895,065 265 3.74% Veritex Community Bank CD 0.25%09/25/23 09/24/21 10,031,278 10,031,278 100.00 10,031,278 268 0.25% Bank OZK CD 0.20%10/09/23 10/08/21 5,011,742 5,011,742 100.00 5,011,742 282 0.20% FHLB Aaa/AA+0.00%10/13/23 10/17/22 2,500,000 2,413,406 96.56 2,413,950 286 4.56% East West Bank CD 4.53%10/19/23 10/19/22 2,523,065 2,523,065 100.00 2,523,065 292 4.63% Bank OZK CD 0.30%11/13/23 11/12/21 10,032,623 10,032,623 100.00 10,032,623 317 0.30% FAMCA Aaa/AA+4.75%11/22/23 11/22/22 2,000,000 2,000,000 100.00 1,999,938 326 4.75% FAMCA Aaa/AA+4.95%12/13/23 12/13/22 10,000,000 10,000,000 99.82 9,982,024 347 4.95% Alliance Bank CD 5.10%12/27/23 12/27/22 1,000,000 1,000,000 100.00 1,000,000 361 5.20% Southside Bank CD 3.32%02/02/24 08/02/22 10,083,682 10,083,682 100.00 10,083,682 398 3.32% T-Note Aaa/AA+0.25%05/15/24 11/22/22 2,000,000 1,882,662 94.14 1,882,813 501 4.72% Alliance Bank CD 5.10%06/14/24 12/15/22 10,000,000 10,000,000 100.00 10,000,000 531 5.20% Alliance Bank CD 5.10%06/27/24 12/27/22 13,100,588 13,100,588 100.00 13,100,588 544 5.20% Alliance Bank CD 5.10%12/13/24 12/15/22 10,000,000 10,000,000 100.00 10,000,000 713 5.20% TOTALS 756,359,862$ 755,225,031$ 755,055,451$ 97 3.37% (1)(2) (2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds. (1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity. (3) Earnings Credit - The City's depository accounts provide an earnings credit on balances which is used to offset bank fees. City of Georgetown Valley View Consulting, L.L.C.446 City - Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 09/30/22 Increases Decreases Book Value 12/31/22 Market Value 09/30/22 Change in Market Value Market Value 12/31/22 JPMorgan Chase Cash 0.30%01/01/23 12,506,553$ –$ (6,806,020)$ 5,700,533$ 12,506,553$ (6,806,020)$ 5,700,533$ JPMorgan Chase MMA 1.15%01/01/23 434,470 826 – 435,297 434,470 826 435,297 Veritex Community Bank MMA 4.17%01/01/23 3,238,147 29,795 – 3,267,942 3,238,147 29,795 3,267,942 Wells Fargo Bank Cash 0.00%01/01/23 16,727,590 – (15,310,791) 1,416,799 16,727,590 (15,310,791) 1,416,799 Wells Fargo Bank Sweep 4.04%01/01/23 – 11,481,710 – 11,481,710 – 11,481,710 11,481,710 NexBank MMA 4.40%01/01/23 12,488,723 115,696 – 12,604,419 12,488,723 115,696 12,604,419 TexPool 3.98%01/01/23 31,811,436 34,788,329 – 66,599,765 31,811,436 34,788,329 66,599,765 TexSTAR 3.97%01/01/23 341,500,283 – (87,705,987) 253,794,295 341,500,283 (87,705,987) 253,794,295 Independent Bank CD 0.30%10/18/22 2,562,534 – (2,562,534) – 2,562,534 (2,562,534) – Prosperity Bank CD 0.20%10/24/22 5,014,211 – (5,014,211) – 5,014,211 (5,014,211) – East West Bank CD 0.21%11/15/22 10,018,428 – (10,018,428) – 10,018,428 (10,018,428) – Prosperity Bank CD 0.40%11/17/22 2,014,712 – (2,014,712) – 2,014,712 (2,014,712) – Prosperity Bank CD 0.15%11/23/22 2,003,257 – (2,003,257) – 2,003,257 (2,003,257) – Prosperity Bank CD 0.15%12/21/22 5,007,505 – (5,007,505) – 5,007,505 (5,007,505) – Alliance Bank CD 2.52%12/24/22 8,050,411 – (8,050,411) – 8,050,411 (8,050,411) – East West Bank CD 1.07%12/26/22 12,066,396 – (12,066,396) – 12,066,396 (12,066,396) – R Bank CD 0.60%01/05/23 1,007,557 1,508 – 1,009,065 1,007,557 1,508 1,009,065 East West Bank CD 0.42%01/09/23 5,025,900 5,323 – 5,031,223 5,025,900 5,323 5,031,223 East West Bank CD 0.51%01/20/23 10,035,553 12,909 – 10,048,462 10,035,553 12,909 10,048,462 Alliance Bank CD 2.83%02/02/23 4,000,000 28,230 – 4,028,230 4,000,000 28,230 4,028,230 Texas Capital Bank CD 2.80%02/04/23 7,768,451 54,417 – 7,822,869 7,768,451 54,417 7,822,869 East West Bank CD 3.17%02/07/23 5,890,623 46,505 – 5,937,128 5,890,623 46,505 5,937,128 East West Bank CD 0.83%02/08/23 8,042,865 16,844 – 8,059,708 8,042,865 16,844 8,059,708 East West Bank CD 3.12%02/15/23 4,021,211 31,747 – 4,052,958 4,021,211 31,747 4,052,958 Bank OZK CD 0.18%02/23/23 4,208,255 1,899 – 4,210,154 4,208,255 1,899 4,210,154 East West Bank CD 1.20%02/27/23 20,142,652 60,507 – 20,203,158 20,142,652 60,507 20,203,158 Veritex Community Bank CD 0.18%03/09/23 4,007,206 1,799 – 4,009,005 4,007,206 1,799 4,009,005 East West Bank CD 1.16%03/14/23 15,095,293 43,818 – 15,139,111 15,095,293 43,818 15,139,111 T-Bill 3.56%03/16/23 491,998 4,408 – 496,406 491,638 4,141 495,780 T-Bill 3.56%03/16/23 25,633,091 229,674 – 25,862,766 25,614,354 215,760 25,830,115 R Bank CD 3.05%03/23/23 4,503,330 34,180 – 4,537,510 4,503,330 34,180 4,537,510 East West Bank CD 1.30%03/27/23 25,168,439 81,967 – 25,250,406 25,168,439 81,967 25,250,406 East West Bank CD 4.16%04/12/23 – 13,469,398 – 13,469,398 – 13,469,398 13,469,398 East West Bank CD 4.16%04/12/23 – 20,181,897 – 20,181,897 – 20,181,897 20,181,897 Prosperity Bank CD 0.20%04/24/23 5,014,211 2,501 – 5,016,711 5,014,211 2,501 5,016,711 Prosperity Bank CD 0.20%05/01/23 5,013,387 2,500 – 5,015,887 5,013,387 2,500 5,015,887 Alliance Bank CD 2.98%05/02/23 4,000,000 29,742 – 4,029,742 4,000,000 29,742 4,029,742 Texas Capital Bank CD 2.90%05/04/23 1,253,082 9,092 – 1,262,175 1,253,082 9,092 1,262,175 East West Bank CD 3.27%05/10/23 3,021,724 24,624 – 3,046,348 3,021,724 24,624 3,046,348 FHLB 4.60%05/10/23 – 23,610,000 – 23,610,000 – 23,625,418 23,625,418 East West Bank CD 4.62%05/15/23 – 5,029,184 – 5,029,184 – 5,029,184 5,029,184 City of Georgetown Valley View Consulting, L.L.C.648 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 – – – – – – – – – – – Veritex Community Bank MMA 3,267,942 3,267,942 – – – – – – – – – – – Wells Fargo Bank Cash 1,416,799 1,416,799 – – – – – – – – – – – Wells Fargo Bank Sweep 11,481,710 11,481,710 – – – – – – – – – – – 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$ Book Value December 31, 2022 City of Georgetown Valley View Consulting, L.L.C.850 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Veritex Community Bank MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep 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 Book Value December 31, 2022 (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.951 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Veritex Community Bank MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep 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 Book Value December 31, 2022 (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.1052 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 – – – – – – – – – – – Veritex Community Bank MMA 3,267,942 3,267,942 – – – – – – – – – – – Wells Fargo Bank Cash 1,416,799 1,416,799 – – – – – – – – – – – Wells Fargo Bank Sweep 11,481,710 11,481,710 – – – – – – – – – – – 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 1153 City - Allocation December 31, 2022 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Veritex Community Bank MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep 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 1254 City - Allocation December 31, 2022 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Veritex Community Bank MMA Wells Fargo Bank Cash Wells Fargo Bank Sweep 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 1355 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 12,506,553$ 12,506,553$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 434,470 434,470 – – – – – – – – – – – Veritex Community Bank MMA 3,238,147 3,238,147 – – – – – – – – – – – Wells Fargo Bank Cash 16,727,590 16,727,590 – – – – – – – – – – – NexBank MMA 12,488,723 12,488,723 – – – – – – – – – – – TexPool 31,811,436 31,811,436 – – – – – – – – – – – TexSTAR 341,500,283 28,675,146 452,616 2,934,215 138,208 1,528,939 1,541,884 922,302 1,067,755 7,841,897 57,072 368,747 1,728,899 Independent Bank CD 10/18/22 2,562,534 2,562,534 – – – – – – – – – – – Prosperity Bank CD 10/24/22 5,014,211 5,014,211 – – – – – – – – – – – East West Bank CD 11/15/22 10,018,428 – – – – – – – – – – – – Prosperity Bank CD 11/17/22 2,014,712 2,014,712 – – – – – – – – – – – Prosperity Bank CD 11/23/22 2,003,257 2,003,257 – – – – – – – – – – – Prosperity Bank CD 12/21/22 5,007,505 5,007,505 – – – – – – – – – – – Alliance Bank CD 12/24/22 8,050,411 8,050,411 – – – – – – – – – – – East West Bank CD 12/26/22 12,066,396 – – – – – – – – – – – – R Bank CD 12/31/22 1,007,557 1,007,557 – – – – – – – – – – – East West Bank CD 01/09/23 5,025,900 5,025,900 – – – – – – – – – – – East West Bank CD 01/20/23 10,035,553 10,035,553 – – – – – – – – – – – Alliance Bank CD 02/02/23 4,000,000 – – – – – – – – – – – – Texas Capital Bank CD 02/04/23 7,768,451 – – – – – – – – – – – – East West Bank CD 02/07/23 5,890,623 – – – – – – – – – – – – East West Bank CD 02/08/23 8,042,865 8,042,865 – – – – – – – – – – – East West Bank CD 02/15/23 4,021,211 – – – – – – – – – – – – Bank OZK CD 02/23/23 4,208,255 4,208,255 – – – – – – – – – – – East West Bank CD 02/27/23 20,142,652 20,142,652 – – – – – – – – – – – Veritex Community Bank CD 03/09/23 4,007,206 4,007,206 – – – – – – – – – – – East West Bank CD 03/14/23 15,095,293 15,095,293 – – – – – – – – – – – T-Bill 03/16/23 491,998 – – – – – – – – – – – – T-Bill 03/16/23 25,633,091 – – – – – – – – – – – – R Bank CD 03/23/23 4,503,330 – – – – – – – – – – – – East West Bank CD 03/27/23 25,168,439 – – – – – – – – – – – – Prosperity Bank CD 04/24/23 5,014,211 5,014,211 – – – – – – – – – – – Prosperity Bank CD 05/01/23 5,013,387 5,013,387 – – – – – – – – – – – Alliance Bank CD 05/02/23 4,000,000 – – – – – – – – – – – – Texas Capital Bank CD 05/04/23 1,253,082 – – – – – – – – – – – – East West Bank CD 05/10/23 3,021,724 – – – – – – – – 3,021,724 – – – Bank OZK CD 06/12/23 5,023,884 5,023,884 – – – – – – – – – – – East West Bank CD 06/16/23 15,132,051 15,132,051 – – – – – – – – – – – Texas Capital Bank CD 06/16/23 5,000,000 5,000,000 – – – – – – – – – – – East West Bank CD 06/20/23 2,523,090 – – – – – – – – – – – – FHLB 06/29/23 9,709,489 9,709,489 – – – – – – – – – – – R Bank CD 06/30/23 1,009,182 1,009,182 – – – – – – – – – – – Alliance Bank CD 07/01/23 4,031,255 4,031,255 – – – – – – – – – – – East West Bank CD 08/01/23 2,016,185 – – – – – – – – – – – – Alliance Bank CD 08/02/23 1,000,000 – – – – – – – – – – – – Bank OZK CD 08/14/23 5,008,794 5,008,794 – – – – – – – – – – – Texas Capital Bank CD 08/24/23 2,507,016 2,507,016 – – – – – – – – – – – FHLB 09/13/23 13,339,436 – – – – – – – – – – – – FFCB 09/22/23 894,020 – – – – – – – – – – – – Veritex Community Bank CD 09/25/23 10,025,029 10,025,029 – – – – – – – – – – – Bank OZK CD 10/09/23 5,009,232 5,009,232 – – – – – – – – – – – Bank OZK CD 11/13/23 10,025,098 10,025,098 – – – – – – – – – – – Southside Bank CD 02/02/24 10,000,000 – – – – – – – – – – – – Totals 731,043,243$ 280,608,602$ 452,616$ 2,934,215$ 138,208$ 1,528,939$ 1,541,884$ 922,302$ 1,067,755$ 10,863,622$ 57,072$ 368,747$ 1,728,899$ September 30, 2022 Book Value City of Georgetown Valley View Consulting, L.L.C.1456 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Veritex Community Bank MMA Wells Fargo Bank Cash NexBank MMA TexPool TexSTAR Independent Bank CD 10/18/22 Prosperity Bank CD 10/24/22 East West Bank CD 11/15/22 Prosperity Bank CD 11/17/22 Prosperity Bank CD 11/23/22 Prosperity Bank CD 12/21/22 Alliance Bank CD 12/24/22 East West Bank CD 12/26/22 R Bank CD 12/31/22 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 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 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 FHLB 06/29/23 R Bank CD 06/30/23 Alliance Bank CD 07/01/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/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 Bank OZK CD 11/13/23 Southside Bank CD 02/02/24 Totals September 30, 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,190,928 2,760,351 601,729 299,230 4,441,871 508,869 3,789,637 704,578 3,718,059 892,487 4,776,393 746,628 9,815,423 10,970,022 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,018,428 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,021,211 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,501,850 – – – – 2,001,480 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,523,090 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,016,185 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,190,928$ 2,760,351$ 601,729$ 299,230$ 6,458,056$ 508,869$ 3,789,637$ 704,578$ 10,241,120$ 892,487$ 4,776,393$ 746,628$ 12,338,513$ 22,989,929$ City of Georgetown Valley View Consulting, L.L.C.1557 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Veritex Community Bank MMA Wells Fargo Bank Cash NexBank MMA TexPool TexSTAR Independent Bank CD 10/18/22 Prosperity Bank CD 10/24/22 East West Bank CD 11/15/22 Prosperity Bank CD 11/17/22 Prosperity Bank CD 11/23/22 Prosperity Bank CD 12/21/22 Alliance Bank CD 12/24/22 East West Bank CD 12/26/22 R Bank CD 12/31/22 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 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 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 FHLB 06/29/23 R Bank CD 06/30/23 Alliance Bank CD 07/01/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/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 Bank OZK CD 11/13/23 Southside Bank CD 02/02/24 Totals September 30, 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 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 502,911 2,820,758 11,099 630,834 14,035,128 9,707,212 169,195,999 7,915,225 35,202,665 – 4,004,568 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 12,066,396 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,000,000 – – – – – – – – – – – 7,768,451 – – – – – – – – – – 5,890,623 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 491,998 – – – – – – – – – – – – – 25,633,091 – – – – – – – – – – – – – – – – – – – – – – – 25,168,439 – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,000,000 – – – – – – – – – – 1,253,082 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,339,436 – – – – – – – – – – – 894,020 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – 502,911$ 3,820,758$ 503,097$ 4,630,834$ 40,396,097$ 16,491,855$ 204,829,090$ 7,915,225$ 60,371,104$ 12,066,396$ 4,004,568$ City of Georgetown Valley View Consulting, L.L.C.1658 City - Allocation September 30, 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 12,506,553$ 12,506,553$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 434,470 434,470 – – – – – – – – – – – Veritex Community Bank MMA 3,238,147 3,238,147 – – – – – – – – – – – Wells Fargo Bank Cash 16,727,590 16,727,590 – – – – – – – – – – – NexBank MMA 12,488,723 12,488,723 – – – – – – – – – – – TexPool 31,811,436 31,811,436 – – – – – – – – – – – TexSTAR 341,500,283 28,675,146 452,616 2,934,215 138,208 1,528,939 1,541,884 922,302 1,067,755 7,841,897 57,072 368,747 1,728,899 Independent Bank CD 10/18/22 2,562,534 2,562,534 – – – – – – – – – – – Prosperity Bank CD 10/24/22 5,014,211 5,014,211 – – – – – – – – – – – East West Bank CD 11/15/22 10,018,428 – – – – – – – – – – – – Prosperity Bank CD 11/17/22 2,014,712 2,014,712 – – – – – – – – – – – Prosperity Bank CD 11/23/22 2,003,257 2,003,257 – – – – – – – – – – – Prosperity Bank CD 12/21/22 5,007,505 5,007,505 – – – – – – – – – – – Alliance Bank CD 12/24/22 8,050,411 8,050,411 – – – – – – – – – – – East West Bank CD 12/26/22 12,066,396 – – – – – – – – – – – – R Bank CD 12/31/22 1,007,557 1,007,557 – – – – – – – – – – – East West Bank CD 01/09/23 5,025,900 5,025,900 – – – – – – – – – – – East West Bank CD 01/20/23 10,035,553 10,035,553 – – – – – – – – – – – Alliance Bank CD 02/02/23 4,000,000 – – – – – – – – – – – – Texas Capital Bank CD 02/04/23 7,768,451 – – – – – – – – – – – – East West Bank CD 02/07/23 5,890,623 – – – – – – – – – – – – East West Bank CD 02/08/23 8,042,865 8,042,865 – – – – – – – – – – – East West Bank CD 02/15/23 4,021,211 – – – – – – – – – – – – Bank OZK CD 02/23/23 4,208,255 4,208,255 – – – – – – – – – – – East West Bank CD 02/27/23 20,142,652 20,142,652 – – – – – – – – – – – Veritex Community Bank CD 03/09/23 4,007,206 4,007,206 – – – – – – – – – – – East West Bank CD 03/14/23 15,095,293 15,095,293 – – – – – – – – – – – T-Bill 03/16/23 491,638 – – – – – – – – – – – – T-Bill 03/16/23 25,614,354 – – – – – – – – – – – – R Bank CD 03/23/23 4,503,330 – – – – – – – – – – – – East West Bank CD 03/27/23 25,168,439 – – – – – – – – – – – – Prosperity Bank CD 04/24/23 5,014,211 5,014,211 – – – – – – – – – – – Prosperity Bank CD 05/01/23 5,013,387 5,013,387 – – – – – – – – – – – Alliance Bank CD 05/02/23 4,000,000 – – – – – – – – – – – – Texas Capital Bank CD 05/04/23 1,253,082 – – – – – – – – – – – – East West Bank CD 05/10/23 3,021,724 – – – – – – – – 3,021,724 – – – Bank OZK CD 06/12/23 5,023,884 5,023,884 – – – – – – – – – – – East West Bank CD 06/16/23 2,523,090 – – – – – – – – – – – – Texas Capital Bank CD 06/16/23 5,000,000 5,000,000 – – – – – – – – – – – East West Bank CD 06/20/23 15,132,051 15,132,051 – – – – – – – – – – – FHLB 06/29/23 9,716,191 9,716,191 – – – – – – – – – – – R Bank CD 06/30/23 1,009,182 1,009,182 – – – – – – – – – – – Alliance Bank CD 07/01/23 4,031,255 4,031,255 – – – – – – – – – – – East West Bank CD 08/01/23 2,016,185 – – – – – – – – – – – – Alliance Bank CD 08/02/23 1,000,000 – – – – – – – – – – – – Bank OZK CD 08/14/23 5,008,794 5,008,794 – – – – – – – – – – – Texas Capital Bank CD 08/24/23 2,507,016 2,507,016 – – – – – – – – – – – FHLB 09/13/23 13,271,236 – – – – – – – – – – – – FFCB 09/22/23 889,114 – – – – – – – – – – – – Veritex Community Bank CD 09/25/23 10,025,029 10,025,029 – – – – – – – – – – – Bank OZK CD 10/09/23 5,009,232 5,009,232 – – – – – – – – – – – Bank OZK CD 11/13/23 10,025,098 10,025,098 – – – – – – – – – – – Southside Bank CD 02/02/24 10,000,000 – – – – – – – – – – – – Totals 730,957,743$ 280,615,304$ 452,616$ 2,934,215$ 138,208$ 1,528,939$ 1,541,884$ 922,302$ 1,067,755$ 10,863,622$ 57,072$ 368,747$ 1,728,899$ City of Georgetown Valley View Consulting, L.L.C.1759 City - Allocation September 30, 2022 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Veritex Community Bank MMA Wells Fargo Bank Cash NexBank MMA TexPool TexSTAR Independent Bank CD 10/18/22 Prosperity Bank CD 10/24/22 East West Bank CD 11/15/22 Prosperity Bank CD 11/17/22 Prosperity Bank CD 11/23/22 Prosperity Bank CD 12/21/22 Alliance Bank CD 12/24/22 East West Bank CD 12/26/22 R Bank CD 12/31/22 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 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 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 FHLB 06/29/23 R Bank CD 06/30/23 Alliance Bank CD 07/01/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/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 Bank OZK CD 11/13/23 Southside Bank CD 02/02/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,190,928 2,760,351 601,729 299,230 4,441,871 508,869 3,789,637 704,578 3,718,059 892,487 4,776,393 746,628 9,815,423 10,970,022 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,018,428 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,021,211 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,501,850 – – – – 2,001,480 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,523,090 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,016,185 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 6,190,928$ 2,760,351$ 601,729$ 299,230$ 6,458,056$ 508,869$ 3,789,637$ 704,578$ 10,241,120$ 892,487$ 4,776,393$ 746,628$ 12,338,513$ 22,989,929$ City of Georgetown Valley View Consulting, L.L.C.1860 City - Allocation September 30, 2022 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Veritex Community Bank MMA Wells Fargo Bank Cash NexBank MMA TexPool TexSTAR Independent Bank CD 10/18/22 Prosperity Bank CD 10/24/22 East West Bank CD 11/15/22 Prosperity Bank CD 11/17/22 Prosperity Bank CD 11/23/22 Prosperity Bank CD 12/21/22 Alliance Bank CD 12/24/22 East West Bank CD 12/26/22 R Bank CD 12/31/22 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 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 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 FHLB 06/29/23 R Bank CD 06/30/23 Alliance Bank CD 07/01/23 East West Bank CD 08/01/23 Alliance Bank CD 08/02/23 Bank OZK CD 08/14/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 Bank OZK CD 11/13/23 Southside Bank CD 02/02/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 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 502,911 2,820,758 11,099 630,834 14,035,128 9,707,212 169,195,999 7,915,225 35,202,665 – 4,004,568 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 12,066,396 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,000,000 – – – – – – – – – – – 7,768,451 – – – – – – – – – – – 5,890,623 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 491,638 – – – – – – – – – – – – – – 25,614,354 – – – – – – – – – – – – – – – – – – – – – – – 25,168,439 – – – – – – – – – – – – – – – – – – – – – – – – – – – – 4,000,000 – – – – – – – – – – 1,253,082 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 13,271,236 – – – – – – – – – – – 889,114 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 10,000,000 – – – – 502,911$ 3,820,758$ 502,738$ 4,630,834$ 40,327,897$ 16,486,949$ 204,810,353$ 7,915,225$ 60,371,104$ 12,066,396$ 4,004,568$ City of Georgetown Valley View Consulting, L.L.C.1961 Georgetown Economic Development Corporation (GEDCO) QUARTERLY INVESTMENT REPORT For the Quarter Ended December 31, 2022 Prepared by Valley View Consulting, L.L.C. The investment portfolio of the Georgetown Economic Development Corporation (GEDCO) is in compliance with Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total return yields and do not account for investment advisor fees.62 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield MMA 2,147,122$ 2,147,122$ 2,166,883$ 2,166,883$ 4.17% Pools 6,586,175 6,586,175 7,698,466 7,698,466 4.01% Certificates of Deposit – – – – 0.00% 8,733,297$ 8,733,297$ 9,865,349$ 9,865,349$ 4.05% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 4.05%Total Portfolio 4.05% Rolling Three Month Treasury 4.19%Rolling Three Month Treasury 4.19% Rolling Six Month Treasury 3.90%Rolling Six Month Treasury 3.90% TexPool 3.98%TexPool 3.98% Interest income provided in separate report. September 30, 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. December 31, 2022 Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.163 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.17%01/01/23 12/31/22 2,166,883$ 2,166,883$ 1.00 2,166,883$ 1 4.17% TexasDAILY AAAm 4.13%01/01/23 12/31/22 2,160,146 2,160,146 1.00 2,160,146 1 4.13% TexSTAR AAAm 3.97%01/01/23 12/31/22 5,538,320 5,538,320 1.00 5,538,320 1 3.97% 9,865,349$ 9,865,349$ 9,865,349$ 1 4.05% (1)(2) December 31, 2022 (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.365 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield Pools/MMAs 33,113,125$ 33,113,125$ 33,147,006$ 33,147,006$ 3.99% CDs/Securities 5,018,515 5,018,515 9,921,428 9,922,663 4.02%Totals 38,131,640$ 38,131,640$ 43,068,435$ 43,069,669$ 4.00% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 4.00%Total Portfolio 4.00% Rolling Three Month Treasury 4.19%Rolling Three Month Treasury 4.19% Rolling Six Month Treasury 3.90%Rolling Six Month Treasury 3.90% TexPool 3.98%TexPool 3.98% Interest data provided in separate report. September 30, 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. December 31, 2022 Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.169 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 3.98%01/01/23 12/31/22 21,129,290$ 21,129,290$ 1.00 21,129,290$ 1 3.98% TexSTAR AAAm 3.97%01/01/23 12/31/22 9,283,515 9,283,515 1.00 9,283,515 1 3.97% Veritex Bank MMA 4.17%01/01/23 12/31/22 2,734,202 2,734,202 1.00 2,734,202 1 4.17% East West Bank CD 3.12%2/7/2023 08/11/22 2,024,596 2,024,596 100.00 2,024,596 38 3.17% East West Bank CD 3.21%05/25/23 08/25/22 3,034,227 3,034,227 100.00 3,034,227 145 3.26% FAMC 0.22%08/11/23 11/10/22 5,000,000 4,862,605 97.28 4,863,840 223 4.84% TOTALS 43,205,830$ 43,068,435$ 43,069,669$ 38 4.00% (1)(2) December 31, 2022 (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.371 Department Federal Grantor Pass-Through Agency Identifying Number COG Name/Purpose YTD Expenditures YTD Revenue Recognized 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,100 25,100 Library N/A St. David's Foundation St. David's Grant - 650 20,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) 4,301 4,301 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 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 *Expenses were incurred in FY2014-15, but reported here since TXDOT has now approved for reimbursement. Division Grantor COG Name/Purpose Status Reviewed By: Elaine Wilson CITY OF GEORGETOWN Grant/Federal Funding Report as of December 31, 2022 Active Applications Pending Award 74