The URL can be used to link to this page

Home My WebLink About4th_Qtr_Report_FY2021FY2021 BUDGET AND 5 YEAR CAPITAL IMPROVEMENT PLAN Quarterly Report FINANCIAL REPORT AND INVESTMENT REPORT For the Quarter Ended September 30, 2021 Table of Contents Executive Summary .................................................................................................................................. 1-23 General Fund Schedule .......................................................................................................................... 24-25 General Fund Schedule by Cost Center .................................................................................................. 26-30 Electric Fund Schedule ................................................................................................................................ 31 Water Services Fund Schedule .................................................................................................................... 32 Joint Services Fund Schedule ....................................................................................................................... 33 Council Discretionary Fund Schedule .......................................................................................................... 34 Convention & Visitors Bureau Fund Schedule ............................................................................................. 35 Airport Fund Schedule ................................................................................................................................. 36 Stormwater Fund Schedule ......................................................................................................................... 37 Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 38 Georgetown Economic Development Corporation Fund Schedule ............................................................. 39 Quarterly Investment Report - City ........................................................................................................ 40-64 Quarterly Investment Report - GEDCO ................................................................................................... 65-71 Quarterly Investment Report - GTEC ...................................................................................................... 72-78 Grant Applications ....................................................................................................................................... 79 Capital Improvement Projects ................................................................................................................ 80-83 Long-term Commitments and Other Unfunded Liabilities ..................................................................... 84-88 F FY2021 Quarterly Report EXECUTIVE SUMMARY FOR THE QUARTER ENDED SEP. 30, 2021 I. QUARTERLY FINANCIAL ANALYSIS Each year, the City amends the budget for multi-year capital projects, as well as operational changes that were unknown at the time the budget was adopted. The fourth Quarter Report Approved Budget includes Capital Project Roll Forward and Operational Amendments Approved by Council in January 2021, and the Mid-year Budget Amendment Approved in June 2021. The February Winter Storm Uri had a large impact on expenses for the second quarter. Council approved amendments related to the storm during a formal budget amendment in June 2021. Furthermore, this report compares actuals to budget, and compares to the performance of actuals in the same quarter in the previous year. The fourth quarter report also includes a comparison of year-to-date actuals to year-end projections. Please note this quarterly report includes unaudited figures. Currently, City staff along with our audit partners, are in the process of completing the year-end close out and the Comprehensive Annual Finance Report (CAFR). It is anticipated the CAFR process will be completed within the next few months and all numbers finalized. The numbers presented in this report are unaudited, preliminary, and subject to change. A Year-End Budget Amendment is proposed on the same Council Agenda as this report. The Year-End Amendment formalizes the projection to transfer $4.7 million of FY2020 available fund balance from the General Fund to the Council Special Revenue Fund to hold for appropriate one-time expenses approved by the Council. The amendment also formalizes other projections made after the mid-year amendment. Most notably, increased revenues and expenses in the Self-Insurance Fund due to acute claims, the American Rescue Fund Grant acceptance, the first tranche of the Mobility Bond debt and associated capital projects. 1 F FY2021 Quarterly Report GENERAL FUND REVENUES: General Fund revenues total $90,675,491, or 108.98% of budget through the end of FY2021. Revenues exceed last year’s same quarter total by $11,773,469, or 14.92%. The difference between the same period last year is primarily driven by increases in building permits, continued growth in sales tax, as well as one-time master development contributions. Municipal Court fines and Interest Income are both decreased compared to the same period last year due to the pandemic circumstances. General Fund Quarterly Comparison: Q4 FY2021 Budget FY2020 FY2021 FY2021 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2021 YTD Actuals: Q4 FY2020 YTD Actuals: Q4 FY2021 Variance % of Budget Variance % Variance Revenue 40001:Property Taxes 15,976,505 15,060,590 15,893,725 (82,780) 99.48% 833,135 5.53% 40002:Sales Taxes 18,576,250 19,108,465 23,895,422 5,319,172 128.63% 4,786,957 25.05% 40005:Franchise Taxes 6,255,270 5,757,843 6,183,295 (71,975) 98.85% 425,452 7.39% 40008:Other Taxes 400,000 399,896 481,489 81,489 120.37% 81,593 20.40% 41001:Fines 328,392 298,524 270,205 (58,187) 82.28% (28,319) -9.49% 41002:Penalties 60,000 64,989 104,967 44,967 174.95% 39,978 61.52% 42001:Interest Income 75,000 244,164 81,050 6,050 108.07% (163,114) -66.81% 43001:Fees 7,028,184 7,099,793 7,532,037 503,853 107.17% 432,244 6.09% 43002:Garbage Charges 10,151,764 10,086,812 10,867,148 715,385 107.05% 780,336 7.74% 43003:Permits 4,317,750 3,435,816 4,781,179 463,429 110.73% 1,345,363 39.16% 43004:Administrative Charges 3,396,447 2,717,730 3,392,501 (3,946) 99.88% 674,771 24.83% 43005:Rental Revenue 148,140 110,711 199,449 51,309 134.64% 88,738 80.15% 45001:Misc Revenue 871,955 122,015 717,891 (154,064) 82.33% 595,876 488.36% 45003:Misc Reimbursements - 872 13,521 13,521 0.00% 12,649 1450.59% 44001:Grant Revenue 679,884 1,322,553 914,494 234,610 134.51% (408,059) -30.85% 44501:Contribution Revenue - 150,000 - - 0.00% (150,000) -100.00% 44502:Developer Contributions 423,112 3,217 229,682 (193,430) 54.28% 226,465 7040.32% 44503:Interlocal Agreement Revenue 5,091,091 4,021,598 5,093,767 2,676 100.05% 1,072,169 26.66% 44504:Donations - 19,400 6,238 6,238 0.00% (13,162) -67.84% 70001:Transfers In 995,302 373,100 995,302 - 100.00% 622,202 166.77% 70002:Transfers In - Payment in Lieu of Taxes (PILOT) 8,431,375 8,503,933 9,022,128 590,753 107.01% 518,195 6.09% Revenue Total 83,206,421 78,902,022 90,675,491 7,469,070 108.98% 11,773,469 14.92% 2 F FY2021 Quarterly Report Sales tax revenue accounts for $18,576,250 of General Fund budgeted revenue. Through the quarters, the City has collected 128.63% of the budgeted sales tax amount, or $23,895,422. Sales tax data lags two months in arrears, but all accruals are made for FY2021. Sales tax continues to have a strong performance - the quarterly returns for sales tax were 25.05% higher compared to the same period last year. The increase in sales tax revenue is the result of continued growth in the City’s core sales tax sectors of retail, food, and information, in combination with new businesses coming online. Additionally, March of 2020 was the start of the pandemic resulting in dampened sales taxes beginning in that period. While these returns are excellent news, the City remains cautious in sales tax forecasting for FY2022. Building Materials make up a large portion of retail sales, and this sub-industry is experiencing supply chain pressures. The continuance of COVID variants impact on consumer habits and other economic indicators is also cause for caution. Property tax revenues are the second largest revenue segment in the General Fund and has a budget of $15,976,505. 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 99.48% of budget, or $15,893,725, reflecting the property tax base remains strong. Year-to-date property tax revenues are 5.53% higher 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 $6,183,295 in FY2021, or 98.85% of budget. Franchise fee revenue is 7.39% higher than the fourth quarter of FY2020. Payment in Lieu of Taxes (PILOT) revenue from City-owned utilities is budgeted at $8,431,375. Year-to-date, PILOT revenues total $9,022,128, or 107.01% of budget. PILOT revenue is $518,195, or 6.09% higher than the fourth quarter of FY2020. The Water and Wastewater Fund contributed more than their budgeted amount. This is from increase in customer base and consumption. The City capped the Electric Fund PILOT at $4,500,000 in FY2021. Planning and Development related revenue continues to be strong in FY2021. Planning and Development has a total revenue budget of $6,922,437. Through the quarter, planning and development reported revenues total $7,040,505 or 101.71% of budget. Permit fees are up 13.72%, or $274,249 compared to the same quarter in FY2020. Development related permits continue to be strong with year-to-date revenues up 38.81%, or $1,332,825 compared to year-to-date from FY2020. Staff continues to monitor the amount of residential building permits. The following graph shows the number of residential building permits issued by quarter for the past 3 years. K 2.0M 4.0M 6.0M 8.0M 10.0M Q1 Q2 Q3 Q4 GENERAL FUND: SALES TAX FY2020 FY2021 276 311 369 396370 537 469 531 682 665 589 591 - 200 400 600 Q1 Q2 Q3 Q4 Residential Building Permits FY2019 FY2020 FY20213 F FY2021 Quarterly Report Sanitation revenue budget totals $10,151,764. Through the quarter, year-to-date revenues from sanitation 10,867,148, or 105.37% of budget. Sanitation rates increased as part of the FY2021 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 $780,336, or 7.74%. Fire and EMS total budgeted revenue is $8,012,095. Through the quarter, Fire and EMS fee related revenue totals $8,196,882, or 102.31% 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 such as the SAFER grant and unanticipated grant funding from FEMA for department physicals. Parks and Recreation fee revenue budget totals $1,893,234. Through the quarter, parks and recreation related fee revenue totals $2,114,979, or 111.71% of budget. Parks and Recreation revenue is up 36.60% compared to FY2020. The Parks and Recreation department has seen an increase in revenue compared to FY2020 as programming continues to increase to pre-COVID levels. Notable increases were in Garey Park and Recreation Center Memberships .FY2021 REVENUE PROJECTIONS: FY2021 year-to-date actuals came in higher than FY2021 projections. Total revenues were projected to end FY2021 at $87,814,662. Through the quarter, actuals are 103.26% of total projections. General Fund Quarterly Comparison: Q4 FY2021 Budget FY2021 FY2021 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections FY2021 Variance Fav/(Unfav) % of Projections Revenue 40001:Property Taxes 15,976,505 15,893,725 (82,780) 99.48% 15,996,505 (102,780) 99.36% 40002:Sales Taxes 18,576,250 23,895,422 5,319,172 128.63% 22,924,375 971,047 104.24% 40005:Franchise Taxes 6,255,270 6,183,295 (71,975) 98.85% 6,182,563 731 100.01% 40008:Other Taxes 400,000 481,489 81,489 120.37% 410,000 71,489 117.44% 41001:Fines 328,392 270,205 (58,187) 82.28% 290,600 (20,395) 92.98% 41002:Penalties 60,000 104,967 44,967 174.95% 70,000 34,968 149.95% 42001:Interest Income 75,000 81,050 6,050 108.07% 87,429 (6,379) 92.70% 43001:Fees 7,028,184 7,532,037 503,853 107.17% 6,876,306 655,731 109.54% 43002:Garbage Charges 10,151,764 10,867,148 715,385 107.05% 10,300,000 567,148 105.51% 43003:Permits 4,317,750 4,781,179 463,429 110.73% 4,880,250 (99,071) 97.97% 43004:Administrative Charges 3,396,447 3,392,501 (3,946) 99.88% 3,396,447 (3,946) 99.88% 43005:Rental Revenue 148,140 199,449 51,309 134.64% 125,947 73,503 158.36% 45001:Misc Revenue 871,955 717,891 (154,064) 82.33% 804,049 (86,158) 89.28% 45003:Misc Reimbursements - 13,521 13,521 0.00% - 13,521 0.00% 44001:Grant Revenue 679,884 914,494 234,610 134.51% 500,000 414,495 182.90% 44501:Contribution Revenue - - - 0.00% - - 0.00% 44502:Developer Contributions 423,112 229,682 (193,430) 54.28% 423,332 (193,650) 54.26% 44503:Interlocal Agreement Revenue 5,091,091 5,093,767 2,676 100.05% 5,091,092 2,675 100.05% 44504:Donations - 6,238 6,238 0.00% - 6,238 0.00% 70001:Transfers In 995,302 995,302 - 100.00% 995,302 - 100.00% 70002:Transfers In - Payment in Lieu of Taxes (PILOT) 8,431,375 9,022,128 590,753 107.01% 8,460,467 561,661 106.64% Revenue Total 83,206,421 90,675,491 7,469,070 108.98% 87,814,662 2,860,829 103.26% 4 F FY2021 Quarterly Report GENERAL FUND EXPENSES: Annual expenses through the quarter total $79,743,765, or 96.09% of budget. This is an increase of 7.93% compared to the same period last year. The increase is driven by increases in operational expense such as internal service allocations, and timing of transfers. Additionally, increase in expense compared to the same period last year is due to COVID and the winter storm and the general delay those events caused in entering into various consulting services contracts. Merit and market adjustments for personnel expenses are also a factor in the increase spending compared to last year. Personnel and Operations Summary Personnel costs through the quarter total $45,808,334, or 100.20% of personnel budget. Operational costs total $32,394,577, or 91.73%. 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. General Fund Quarterly Comparison: Q4 FY2021 Budget FY2020 FY2021 FY2021 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2021 YTD Actuals: Q4 FY2020 YTD Actuals: Q4 FY2021 Variance % Of Budget Variance % Variance Expense Personnel 45,716,778 41,394,712 45,808,334 (91,556) 100.20% (4,413,622) 10.66% Operations 35,315,108 30,717,258 32,394,577 2,920,532 91.73% (1,677,319) 5.46% Operating Capital 298,603 1,144,727 183,939 114,664 61.60% 960,788 -83.93% CIP Expense - 36,962 - - 0.00% 36,962 -100.00% Transfers 1,654,691 591,860 1,356,916 297,775 82.00% (765,056) 129.26% Total Expense 82,985,180 73,885,519 79,743,765 3,241,415 96.09% (5,858,247) 7.93% Many departments in the General Fund were impacted by the February winter storm. The public safety division and public works division were impacted the most. As part of the FY2021 Mid-Year Budget Amendment, staff proposed additional appropriation to cover unforeseen overtime cost and operational costs related to the storm. A complete list of cost center, budget, actuals, and projections is attached as part of supplemental information to this report. Personnel and Operations Summary by Division: DEVELOPMENT SERVICES DIVISION: Through the quarter Planning has reported expenses totaling $1,750,470, or 88.49% of budget. Inspections incurred personnel and operational expenses amounting to $1,459,857, or 94.31% of budget. Year-to-date personnel and operational expenditures for Community Services are as follows, Community Services main cost center has a total of $350,621, or 99.08% of budget, through the quarter, Animal Services has reported $934,970, which is 84.48% of their budget, Code Compliance has shown spending of $483,750, or 85.96% of budget. Animal Services and Code Compliance had vacancies throughout the year, resulting in less than anticipated expenses. Environmental Services incurred personnel and operational expenditures amounting to $9,587,669, or 99.22% of budget. 5 F FY2021 Quarterly Report Public Works personnel and operational expenditures for the quarter totals $1,365,719, which represents 80.06% of budget. Year-to-date expenditures related to personnel and operations for Streets totals $2,872,098, 91.55% of budget. FINANCE ADMINISTRATION DIVISION: Municipal Court year-to-date expenses total $554,822, or 94.82% of budget. This spending includes $476,716 for personnel costs and $82,453 for operational costs. POLICE OPERATIONS DIVISION: Police Operations saw personnel and operational expenditures through the quarter totals $14,763,085, or 100.64% of budget. Police Administration expenditures through the quarter resulted in $2,365,080, or 92.10% of budget. FIRE AND EMS DIVISION: Year-to-date personnel and operational expenditures through the quarter total $3,766,322, or 86.61% of budget for Fire Support Services/Administration, $15,520,210, or 97.28% of budget for Fire Emergency Services, and $2,879,530, or 111.59% of budget for Fire EMS. Fire Emergency Services budget was budgeted with positions that typically are in the EMS cost center. The Fire budget is viewed at a division level which includes the roll-up of all Fire associated cost centers. The overall division is under budget in FY2021. ADMINISTRATIVE SERVICES DIVISION: Administrative Services saw operational and personnel costs totaling $1,694,473, or 89.47% of budget year-to-date. City Secretary personnel and operational expenditures for the quarter totals $981,238, which represents 97.17% of budget. Year-to-date personnel and operational expenditures for Communications totals $704,633, which represents 83.43% of budget. Non-Departmental includes a transfer out of $1,369,493, or 82.76% of anticipated transfer expense for the year. A year-end budget amendment is proposed to transfer $4,700,000 from the General Fund to the Council SRF. The transfer is to reserve one-time available savings from FY2020 for future one-time expenses as approved by the Council. This transfer is reflected in the FY2021 projections. 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. Staff will adjust and forecast the vacancy factor as part of the FY2021 projections. LIBRARY, TOURISM, AND ARTS AND CULTURE DIVISION: Arts and Culture recognized year to date expenses totaling $82,372, or 142.37% of budget. Library year-to-date expenses total $2,699,109, or 95.11% of budget. The overage is due to a shift in booking Arts & Culture personnel from the Library cost center to Arts & Culture cost center to align with organizational structure. 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 Recreation Programs, comes to a total of $8,162,487, or 91.16% of budget. Parks year-to-date through the quarter totals $2,583,064, or 94.71% of budget. Recreational Programs total expenses are $948,688, which is 75.81% of budget. Garey Park year-to-date is $857,934, or 87.36% of budget. 6 F FY2021 Quarterly Report Personnel and Operations Summary by Division: General Fund Quarterly Comparison: Q4 FY2021 Budget Actuals Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections 2021 Variance Fav/(Unfav) % of Projection Development Services Personnel 6,213,438 5,706,390 507,048 91.84% 5,824,965 118,574 97.96% Operations 13,812,057 13,081,536 730,522 94.71% 13,788,192 706,656 94.87% Operating Capital 29,789 17,227 12,562 57.83% 41,564 24,337 41.45% Development Services Total Expense 20,055,285 18,805,153 1,250,132 93.77% 19,654,721 849,568 95.68% Finance Administration Personnel 484,734 476,716 (32,203) 98.35% 473,558 (3,158) 100.67% Operations 100,389 78,106 4,347 77.80% 83,151 5,044 93.93% Finance Administration Total Expense 585,123 554,822 30,301 94.82% 556,709 1,887 99.66% Police Operations Personnel 12,961,182 13,227,102 (265,920) 102.05% 12,876,859 (350,243) 102.72% Operations 4,198,668 3,881,695 316,973 92.45% 4,120,724 239,029 94.20% Operating Capital 77,104 19,368 57,736 25.12% 77,104 57,736 25.12% Police Operations Total Expense 17,236,954 17,128,165 108,789 99.37% 17,074,687 (53,478) 100.31% Fire and EMS Personnel 18,120,403 17,672,086 448,317 97.53% 18,215,389 543,303 97.02% Operations 4,599,221 4,375,064 224,157 95.13% 4,443,242 68,178 98.47% Operating Capital 162,899 118,912 43,987 73.00% 162,470 43,558 73.19% Fire and EMS Total Expense 22,882,523 22,166,062 716,461 96.87% 22,821,101 655,039 97.13% Administrative Services Personnel 1,326,001 2,542,113 (1,216,112) 191.71% 2,315,816 (226,297) 109.77% Operations 7,382,852 6,246,565 1,136,287 84.61% 7,144,768 898,202 87.43% Transfers 1,654,691 1,356,916 297,775 82.00% 6,354,691 4,997,775 21.35% Administrative Services Total Expense 10,363,544 10,145,594 217,950 97.90% 15,815,274 5,669,680 64.15% Library, Tourism, and Arts and Culture Personnel 1,798,754 1,708,455 90,299 94.98% 1,828,761 120,306 93.42% Operations 1,068,507 1,064,474 4,033 99.62% 1,074,019 9,546 99.11% Operating Capital 28,500 8,553 19,947 30.01% 7,960 (593) 107.46% Library, Tourism, and Arts and Culture Total Expense 2,895,761 2,781,482 114,279 96.05% 2,910,740 129,258 95.56% Parks and Recreation Personnel 4,812,266 4,475,473 336,793 93.00% 4,735,425 259,952 94.51% Operations 4,153,414 3,667,136 486,278 88.29% 3,908,685 241,549 93.82% Operating Capital 311 19,879 (19,568) 6392.30% - (19,879) 0.00% CIP Expense - - - 0.00% - - 0.00% Parks and Recreation Total Expense 8,965,991 8,162,487 803,503 91.04% 8,644,110 481,623 94.43% General Fund Total 82,985,180 79,743,765 3,241,415 96.09% 87,477,342 7,733,577 91.16% 7 F FY2021 Quarterly Report FY2021 EXPENSE PROJECTIONS: Total expenses are projected to end FY2021 at $87,477,342. Through the quarter, actual expenses are 91.16% of total projections. Preliminary, unaudited projected ending available balance is $12,499,020. As previously mentioned, $4,700,000 of expense will process in the year-end budget amendment to transfer FY2020 one-time savings in fund balance to the Council Special Revenue Fund. Additionally, Since the City converted to a new financial software system in FY2020, open encumbrances are no longer held in a prior year. Instead, these commitments for operational and capital expense are rolled forward into the next year. It should be noted that several unfinished projects from FY2021 will be rolled forward into FY2022 and staff will be bringing forward a budget amendment of approximately $495,000. After accounting for the transfer to the Council Special Revenue Fund and Capital Roll Forwards requirements, ending available fund balance is estimated at $5.8 million. These figures are preliminary and unaudited. Staff is exercising caution in presenting options for the use of available fund balance until the year-end audit is complete. Overall, General Fund expenditures are within budget and the fund can cover the 90-day Contingency Reserve, Economic Stability Reserve, and the Benefit Payout Reserve. 8 F FY2021 Quarterly Report UTILITY FUNDS: Electric Fund: The City has used multiple strategies in the past two years to improve the performance of the Electric Fund in relation to past and current expenditures for purchased power contracts. These strategies include increasing the Power Cost Adjustment rate to recover revenue, reducing operating and capital expenditures in the electric utility, selling utility assets, hiring a new General Manager, and contracting professional services for energy portfolio management and risk oversight. These have resulted in improved financial performance of the fund. To improve rate competitiveness for customers, the City lowered the Power Cost Adjustment in January of 2021 by 1 cent per kWh, to 1.375 cents per kWh. This resulted in a $5 million decrease in Electric Revenue as part of the FY2021 Amended budget in January and is reflected in this report. Many departments in the utility funds were impacted by the winter storm. The Electric and Water fund incurred significant increases in overtime, operations, and equipment needs/replacement. As part of the FY2021 Mid-Year Budget Amendment City Council has approved additional appropriation to cover unforeseen costs associated with the winter storm. As part of the FY2022 budget development process, the utilities are reviewing various initiatives to improve resiliency to extreme weather, including those required by legislation. ELECTRIC REVENUE: Operating revenue in the Electric Fund totals $95,470,292 through the quarter, or 110.20% of budget. Electric sales revenue, the largest component of operating revenue, has brought in $80,933,053 through the quarter, totaling 102.47% of Electric charges budget. Electric revenue sales are typically higher in the summer months when consumption increases due to hot weather. As this summer was relatively mild, revenue projections were conservative, and Electric sales revenue ended the year at 102.34% of projection. Developer contributions were conservatively budgeted at $1,500,000. Year-to-date collection totals $7,828,988, or 521.93% of budget. Developer contributions drive the need for utility infrastructure, while there is an increase in revenue, 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. These capital expenses will be presented in a year-end budget amendment. Electric Services Quarterly Comparison: Q4 FY2021 Budget FY2020 FY2021 FY2021 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2021 YTD Actuals: Q4 FY2020 YTD Actuals: Q4 FY2021 Variance % of Budget Variance % Variance Operating Revenue 40002:Sales Taxes 5,000 7,358 5,863 863 117.25% (1,495) -20.32% 40005:Franchise Taxes 115,732 - - (115,732) 0.00% - 0.00% 41002:Penalties 553,724 529,508 848,000 294,276 153.14% 318,492 60.15% 42001:Interest Income 5,000 10,703 33,570 28,570 671.40% 22,867 213.64% 43001:Fees 685,000 614,274 1,036,657 351,657 151.34% 422,383 68.76% 43004:Administrative Charges 3,222,103 3,192,618 3,222,103 (0) 100.00% 29,485 0.92% 43601:Electric Charges 78,982,278 85,733,316 80,933,053 1,950,775 102.47% (4,800,262) -5.60% 44502:Developer Contributions 1,500,000 4,476,298 7,828,988 6,328,988 521.93% 3,352,689 74.90% 70001:Transfers In 1,562,058 500,000 1,562,058 - 100.00% 1,062,058 212.41% Operating Revenue Total 86,630,895 95,064,075 95,470,292 8,839,397 110.20% 406,216 0.43% Non-Operating Revenue 45001:Misc Revenue 35,000 195,508 523,214 488,214 1494.90% 327,706 167.62% 45004:Sale of Property 10,000 10,813,949 4,127,598 4,117,598 41275.98% (6,686,351) -61.83% 44001:Grant Revenue - 1,860 - - 0.00% (1,860) -100.00% 46001:Bond Proceeds 54,648,625 5,055,000 54,065,000 (583,625) 98.93% 49,010,000 969.54% 46002:Bond Premium - - 652,424 652,424 0.00% 652,424 0.00% Non-Operating Revenue Total 54,693,625 16,066,317 59,368,236 4,674,611 108.55% 43,301,919 269.52% Revenue Total 141,324,520 111,130,393 154,838,528 13,514,008 109.56% 43,708,136 39.33% 9 F FY2021 Quarterly Report The budget for non-operating revenue totals $54,693,625 in FY2021. The city has recognized revenues of $54,065,000 in bond proceed revenues through the quarter due to the debt financing of the energy costs of Winter Storm Uri. Year-to-date non- operating revenues are above the fourth quarter of FY2020, mainly driven by the debt issuance from the winter storm extreme energy costs. FY2021 REVENUE PROJECTIONS: FY2021 operating revenue projections came in slightly higher than anticipated at $95,470,292. Total operating revenues were projected to end the year at $91,408,444. The largest component of operating revenue is electric sales revenue, which is projected to end the year at $79,081,809. Electric charges came in at $80,933,053, or 102.34% of projections. This is largely driven by healthy customer growth, along with a slight increase in utility usage in the late summer months. Through the quarter, actuals make up 104.44% of total operating revenue projections. Total non-operating revenues are projected to end FY2021 at $57,477,051. This includes $2,526,604 of renewable energy credits (REC) accounted for in Sale of Property. The City continues to sell RECs in the market when advantageous and was able to bring revenue in $1,600,994 over projections, for a total revenue of $4,127,598. Through the quarter, actuals are 103.29% of total non-operating revenue projections. Electric Services Quarterly Comparison: Q4 FY2021 Budget FY2021 FY2021 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections FY2021 Variance Fav/(Unfav) % of Projection Operating Revenue 40002:Sales Taxes 5,000 5,863 863 117.25% 5,000 863 117.25% 40005:Franchise Taxes 115,732 - (115,732) 0.00% - - 0.00% 41002:Penalties 553,724 848,000 294,276 153.14% 547,759 300,241 154.81% 42001:Interest Income 5,000 33,570 28,570 671.40% 20,828 12,742 161.18% 43001:Fees 685,000 1,036,657 351,657 151.34% 868,887 167,770 119.31% 43004:Administrative Charges 3,222,103 3,222,103 (0) 100.00% 3,222,103 (0) 100.00% 43601:Electric Charges 78,982,278 80,933,053 1,950,775 102.47% 79,081,809 1,851,244 102.34% 44502:Developer Contributions 1,500,000 7,828,988 6,328,988 521.93% 6,100,000 1,728,988 128.34% 70001:Transfers In 1,562,058 1,562,058 - 100.00% 1,562,058 - 100.00% Operating Revenue Total 86,630,895 95,470,292 8,839,397 110.20% 91,408,444 4,061,848 104.44% Non-Operating Revenue 45001:Misc Revenue 35,000 523,214 488,214 1494.90% 233,023 290,191 224.53% 45004:Sale of Property 10,000 4,127,598 4,117,598 41275.98% 2,526,604 1,600,994 163.37% 44001:Grant Revenue - - - 0.00% - - 0.00% 46001:Bond Proceeds 54,648,625 54,065,000 (583,625) 98.93% 54,065,000 - 100.00% 46002:Bond Premium - 652,424 652,424 0.00% 652,424 0 100.00% Non-Operating Revenue Total 54,693,625 59,368,236 4,674,611 108.55% 57,477,051 1,891,185 103.29% Revenue Total 141,324,520 154,838,528 13,514,008 109.56% 148,885,495 5,953,033 104.00% K 5.0M 10.0M 15.0M 20.0M 25.0M Q1 Q2 Q3 Q4 ELECTRIC FUND: ELECTRIC SALES REVENUE FY2020 FY2021 10 F FY2021 Quarterly Report ELECTRIC EXPENSES: Operating expenses in the Electric Fund total $134,738,524 through the quarter. Year-to-date purchase power expenses total $108,693,051, while net congestion revenue rights (CRRs) credits total $989,262. This is due to congestion in the grid. Without the event of the winter storm purchase power expenses would be $60,693,051, or 9.2% than FY2020 actuals. The polar vortex winter storm Uri caused significant disruption in the Texas energy market. This disruption led to extreme price spikes in the cost of energy, and the City had a net obligation of approximately $48 million. The $48 million is beyond the City’s capacity to handle with current unrestricted reserves. For comparison, the annual cost of energy is about $60 million. Therefore, the City has secured a Public Property Finance Contractual Obligation (PPFCO). This is a tax-backed obligation with a subordinate lien on Electric Utility revenues. The PPFCO has a 9.5-year term, with a 5-year call option. This is a fixed rate bond (1.73% taxable) that was privately placed with Wells Fargo. It is structured with level annual payments. The average annual principal and interest payment of $5,298,851 will be repaid with Electric revenues and the current Power Cost Adjustment of 1.375 per kWh. Given the unusual circumstances of the winter storm’s costs, staff is working closely with the External Auditor, Bond Counsel and Financial Advisor on all related accounting procedures for the year-end financial statements. In addition to overtime from the winter storm, personnel costs in Electric Engineering and Transmission and Distribution (T&D) cost centers look inflated. This labor will be capitalized to the appropriate capital improvement project on the final year-end financial statements. Electric Services Quarterly Comparison: Q4 FY2021 Budget FY2020 FY2021 FY2021 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2021 YTD Actuals: Q4 FY2020 YTD Actuals: Q4 FY2021 Variance % of Budget Variance % Variance Operating Expense City of Georgetown (Only) - 252,201 - - 0.00% 252,201 -100.00% CC0001 Non-Departmental 5,506,375 4,868,428 6,520,044 (1,013,669) 118.41% (1,651,616) 33.93% CC0522 Electric Administration 8,738,792 10,243,728 8,868,267 (129,476) 101.48% 1,375,461 -13.43% CC0525 T&D Services 3,122,421 3,951,577 4,185,597 (1,063,176) 134.05% (234,020) 5.92% CC0526 Systems Engineering - (291,007) - - 0.00% (291,007) -100.00% CC0537 Electric Resource Management 108,334,393 65,419,453 109,900,806 (1,566,413) 101.45% (44,481,354) 67.99% CC0555 Electric Systems Operations 1,610,228 1,441,701 1,579,253 30,976 98.08% (137,552) 9.54% CC0557 Electrical Engineering 663,952 839,101 1,070,057 (406,104) 161.16% (230,955) 27.52% CC0521 Electric Technical Services 727,388 603,639 670,962 56,426 92.24% (67,322) 11.15% CC0524 Metering Services 2,022,094 1,848,935 1,939,497 82,597 95.92% (90,562) 4.90% CC0526 Systems Engineering - (291,007) - - 0.00% (291,007) -100.00% Operating Expense Total 130,725,643 89,177,755 134,738,524 (4,012,881) 103.07% (45,560,769) 51.09% Non-Operating Expense CC0001 Non-Departmental 4,375,805 3,924,104 4,298,971 76,834 98.24% (374,867) 9.55% CC0557 Electrical Engineering 8,166,143 1,850,513 3,386,145 4,779,997 41.47% (1,535,632) 82.98% CC0526 Systems Engineering - 1,030,860 - - 0.00% 1,030,860 -100.00% Non-Operating Expense Total 12,541,948 6,805,477 7,685,116 4,856,831 61.28% (879,639) 12.93% Expense Total 143,267,591 95,983,232 142,423,640 843,951 99.41% (46,440,408) 48.38% Non-operating expenditures are budgeted at $12,541,948 in FY2021. Budgeted non-operating expenditures include $8,166,143 for capital projects and $4,375,805 for debt service payments, both of which typically trend towards later quarters. As previously mentioned, a significant portion of labor expenses for capital projects will be journaled at the end of the fiscal year, bringing operations and capital expense in balance with their budgets. 11 F FY2021 Quarterly Report FY2021 EXPENSE PROJECTIONS: Total operating expenses were projected to end FY2021 at $132,217,192. The overage in FY2021 projections is due from writing off uncollectible bill revenues that are older than 120 days. The City hired a collections agency in the summer and they are making progress on reducing outstanding receivables. Through the quarter, actuals are 101.91% of total operating expense projections. Electric Services Quarterly Comparison: Q4 FY2021 Budget FY2021 FY2021 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections 2021 Variance Fav/(Unfav) % of Projections Operating Expense City of Georgetown (Only) - - - 0.00% - - 0.00% CC0001 Non-Departmental 5,506,375 6,520,044 (1,013,669) 118.41% 6,668,720 148,676 97.77% CC0522 Electric Administration 8,738,792 8,868,267 (129,476) 101.48% 8,944,477 76,210 99.15% CC0525 T&D Services 3,122,421 4,185,597 (1,063,176) 134.05% 3,089,942 (1,095,655) 135.46% CC0526 Systems Engineering - - - 0.00% 80,506 80,506 0.00% CC0537 Electric Resource Management 108,334,393 109,900,806 (1,566,413) 101.45% 108,331,349 (1,569,457) 101.45% CC0555 Electric Systems Operations 1,610,228 1,579,253 30,976 98.08% 1,639,454 60,202 96.33% CC0557 Electrical Engineering 663,952 1,070,057 (406,104) 161.16% 715,684 (354,372) 149.52% CC0521 Electric Technical Services 727,388 670,962 56,426 92.24% 717,148 46,186 93.56% CC0524 Metering Services 2,022,094 1,939,497 82,597 95.92% 2,029,912 90,414 95.55% CC0526 Systems Engineering - - - 0.00% 80,506 80,506 0.00% Operating Expense Total 130,725,643 134,738,524 (4,012,881) 103.07% 132,217,192 (2,521,332) 101.91% Non-Operating Expense CC0001 Non-Departmental 4,375,805 4,298,971 76,834 98.24% 4,373,805 74,834 98.29% CC0557 Electrical Engineering 8,166,143 3,386,145 4,779,997 41.47% 8,166,142 4,779,997 41.47% CC0526 Systems Engineering - - - 0.00% - - 0.00% Non-Operating Expense Total 12,541,948 7,685,116 4,856,831 61.28% 12,539,947 4,854,831 61.29% Expense Total 143,267,591 142,423,640 843,951 99.41% 144,757,139 2,333,499 98.39% Non-operating expenses are projected to end FY2021 at $12,539,947, which is 61.29% of year-to-date actuals through the quarter. Approximately $6 million in unfinished capital projects expenses will be presented in the FY2022 Rollforward Budget Amendment. The Electric Fund anticipates meeting all the funds below line contingency requirements by the end of FY2021. Contingency requirements include a 90-day operating contingency of $4,018,754, a reserve for bond proceeds totaling $4,448,314, non-operating reserve of $3,486,903, as well as re-establishing a rate stabilization reserve in the amount of $18,600,000 at the end of FY2021. After accounting for the Capital Roll Forward requirement, ending available fund balance is estimated at $3.9 million. This is $2.2 million over the projection of $1.7 million. These figures are preliminary and unaudited. Staff is exercising caution in presenting options for the use of available fund balance or any proposed changes to rates until the year-end audit is completed and purchased power is managed during the coming winter months. 12 F FY2021 Quarterly Report FY2021 Quarterly Report K 5.0M 10.0M 15.0M 20.0M FY2020 FY2021 FY2020 FY2021 FY2020 FY2021 FY2020 FY2021 Q1 Q2 Q3 Q4 WATER FUND: CHARGES FOR SERVICES Irrigation Charges Wastewater Charges Water Charges Water Fund: WATER REVENUE: Year-to-date Operating revenue totals $108,806,038, or 153.44% of budget. The largest revenue streams in the Water Fund are charges for services for water, wastewater, and irrigation use. Through the quarter, Water Charges total $41,143,198, which is 127.97% of budget. Year-to-date, Wastewater Charges are $15,125,001, or 106.51% of budget. Irrigation Charges total $360,002 for the quarter, or 120.00% of budget. Increases in number of meters and customers as well as rate increase effect January 1st, have proven to significantly increase year-to-date revenues for the Water Fund from 2020 to 2021. The budget for Impact Fees for the fiscal year is $18,800,000. Through the quarter, impact fee revenues total $40,034,496, or 212.95% of budget. Water utility staff included an updated estimate of these fees for fiscal year- end projections and for FY2022 planning. The increase in impact fees is attributed to growth as well as an increase in the installation of meters that are larger in diameter such as meters used for multi-family housing. FY2020’s new Living Equivalent Units was 4,470, while FY2021’s LEU’s installed were 5,822. This equates to is a 30% increase. Impact fees are used for funding capital infrastructure approved in the impact fee plan. They may be used as a cash equivalent, or to repay debt service for the projects. Staff are currently in the process of reconciling impact fees available to assist with the needed expansion of the South Lake Treatment Plant, along with other large projects. Water Quarterly Comparison: Q4 FY2021 Budget FY2020 FY2021 FY2021 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2021 YTD Actuals: Q4 FY2020 YTD Actuals: Q4 FY2021 Variance % of Budget Variance % Variance Operating Revenue 41002:Penalties 255,000 305,880 513,447 258,447 201.35% 207,567 67.86% 42001:Interest Income 237,250 1,475,880 427,758 190,508 180.30% (1,048,122) -71.02% 43001:Fees 4,290,000 6,644,405 9,598,958 5,308,958 223.75% 2,954,553 44.47% 43005:Rental Revenue 55,000 61,178 112,975 57,975 205.41% 51,797 84.67% 43602:Water Charges 32,150,000 35,208,127 41,143,198 8,993,198 127.97% 5,935,071 16.86% 43603:Wastewater Charges 14,200,000 14,282,982 15,125,001 925,001 106.51% 842,019 5.90% 43604:Irrigation Charges 300,000 513,679 360,002 60,002 120.00% (153,677) -29.92% 41602:Impact Fees 18,800,000 27,891,155 40,034,496 21,234,496 212.95% 12,143,341 43.54% 44502:Developer Contributions 625,000 661,160 1,490,202 865,202 238.43% 829,042 125.39% Operating Revenue Total 70,912,250 87,044,447 108,806,038 37,893,788 153.44% 21,761,591 25.00% Non-Operating Revenue 45001:Misc Revenue 1,112,500 559,186 1,312,616 200,116 117.99% 753,430 134.74% 45003:Misc Reimbursements - - 10,422 10,422 0.00% 10,422 0.00% 45004:Sale of Property 1,327,774 735,404 1,330,463 2,689 100.20% 595,058 80.92% 44001:Grant Revenue - 338 - - 0.00% (338) -100.00% 46001:Bond Proceeds 16,300,000 9,375,000 14,975,000 (1,325,000) 91.87% 5,600,000 59.73% 46002:Bond Premium - - 1,415,140 1,415,140 0.00% 1,415,140 0.00% Non-Operating Revenue Total 18,740,274 10,669,927 19,043,639 303,365 101.62% 8,373,712 78.48% Revenue Total 89,652,524 97,714,374 127,849,678 38,197,154 142.61% 30,135,303 30.84% 13 F FY2021 Quarterly Report FY2021 Quarterly Report K 250K 500K 750K 1.0M Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep WATER FUND: CONSUMPTION (KGALS) FY2020 FY2021 Total Water Fund operating revenue is up 116.86% compared to the same period last fiscal year due to growth in sales and collections in impact fees. Year-to- date consumption of water has increased 9% over FY2020, despite a relatively wet summer. The budget for non-operating revenue totals $18,740,274 in FY2021. This total includes bond proceeds for capital projects in the amount of $16,300,000. Year to date through the quarter the City has recognized bond proceed and premium revenues. Sale of property revenue includes the Chisolm Trail building sale to the City of Florence. Misc revenue includes the Blanchard contract revenue, billed annually in the 4th quarter. FY2021 REVENUE PROJECTIONS: Water Quarterly Comparison: Q4 FY2021 Budget FY2021 FY2021 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections FY2021 Variance Fav/(Unfav) % of Projections Operating Revenue 41002:Penalties 255,000 513,447 258,447 201.35% 355,000 158,447 144.63% 42001:Interest Income 237,250 427,758 190,508 180.30% 492,336 (64,577) 86.88% 43001:Fees 4,290,000 9,598,958 5,308,958 223.75% 7,655,000 1,943,958 125.39% 43005:Rental Revenue 55,000 112,975 57,975 205.41% 60,000 52,975 188.29% 43602:Water Charges 32,150,000 41,143,198 8,993,198 127.97% 35,100,000 6,043,198 117.22% 43603:Wastewater Charges 14,200,000 15,125,001 925,001 106.51% 14,000,000 1,125,001 108.04% 43604:Irrigation Charges 300,000 360,002 60,002 120.00% 300,000 60,002 120.00% 41602:Impact Fees 18,800,000 40,034,496 21,234,496 212.95% 32,500,000 7,534,496 123.18% 44502:Developer Contributions 625,000 1,490,202 865,202 238.43% 1,496,239 (6,037) 99.60% Operating Revenue Total 70,912,250 108,806,038 37,893,788 153.44% 91,958,575 16,847,463 118.32% Non-Operating Revenue 45001:Misc Revenue 1,112,500 1,312,616 200,116 117.99% 1,262,350 50,266 103.98% 45003:Misc Reimbursements - 10,422 10,422 0.00% - 10,422 0.00% 45004:Sale of Property 1,327,774 1,330,463 2,689 100.20% 1,327,774 2,689 100.20% 44001:Grant Revenue - - - 0.00% - - 0.00% 46001:Bond Proceeds 16,300,000 14,975,000 (1,325,000) 91.87% 14,975,000 - 100.00% 46002:Bond Premium - 1,415,140 1,415,140 0.00% 1,415,140 (0) 100.00% Non-Operating Revenue Total 18,740,274 19,043,639 303,365 101.62% 18,980,264 63,375 100.33% Revenue Total 89,652,524 127,849,678 38,197,154 142.61% 110,938,839 16,910,839 115.24% Operating revenue for the Water Fund was projected to end FY2021 at $91,958,575, but actual revenues are $16,847,463 higher. The City is averaging an additional 370 new meters a month and 3,388 new wastewater connections per year over the past two years. Overall, operating revenue year-to-date actuals make up 118.32%, and exceed projections. In addition to the analysis on water impact fee use for capital projects, the City is working with a consultant on a rate study to evaluate growth projections, rate class equity, conservation, and the financial sustainability of the utility. 14 F FY2021 Quarterly Report FY2021 Quarterly Report Total non-operating revenues are projected to end FY2021 at $18,980,264. Through the quarter, actual revenues are 100.33% of total non-operating projections. WATER EXPENSES: Operating expenditures in the Water Fund total $43,022,509 through the quarter, or 90.56% of budget. The Non- departmental Cost Center is over budget due to writing off bad debt expense and an increase in PILOT expense to the General Fund. The PILOT calculation is based off usage, thus an increase in usage increases the amount transferred to the General Fund. Water Operations is over budget due increased OT and personnel costs associated with the winter storm. The negative entry for Systems Engineering reflects a true-up of data conversion from the financial software changes to Operational costs are trending on budget. Water Services Financial Report Quarterly Comparison: Q4 FY2021 Budget FY2020 FY2021 FY2021 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2021 YTD Actuals: Q4 FY2020 YTD Actuals: Q4 FY2021 Variance % of Budget Variance % Variance Operating Expense City of Georgetown (Only) - 210,469 - - 0.00% 210,469 -100.00% CC0001 Non-Departmental 4,223,814 4,255,702 5,131,684 (907,870) 121.49% (875,982) 20.58% CC0526 Systems Engineering - 7,130,305 (1,836,056) 1,836,056 0.00% 8,966,361 -125.75% CC0532 Irrigation Operations 295,000 268,930 139,285 155,715 47.22% 129,646 -48.21% CC0530 Wastewater Operations 896,265 764,733 547,171 349,094 61.05% 217,562 -28.45% CC0531 Wastewater Plant Management 4,013,950 3,271,553 3,516,184 497,766 87.60% (244,631) 7.48% CC0527 Water Services Administration 26,369,169 23,848,381 24,491,296 1,877,873 92.88% (642,915) 2.70% CC0528 Water Distribution 3,207,552 2,626,683 3,176,051 31,501 99.02% (549,369) 20.91% CC0529 Water Plant Management 4,326,865 3,685,707 3,479,406 847,459 80.41% 206,302 -5.60% CC0553 Water Operations 4,173,316 4,325,327 4,377,488 (204,172) 104.89% (52,161) 1.21% Operating Expense Total 47,505,930 50,387,791 43,022,509 4,483,421 90.56% 7,365,282 -14.62% Non-Operating Expense CC0001 Non-Departmental 4,083,411 3,131,244 92,665 3,990,746 2.27% 3,038,578 -97.04% CC0526 Systems Engineering 99,509,468 4,264,398 13,900,168 85,609,300 13.97% (9,635,770) 225.96% CC0532 Irrigation Operations 121,879 125,075 121,994 (115) 100.09% 3,081 -2.46% CC0530 Wastewater Operations 3,026,798 10,351,145 3,160,381 (133,583) 104.41% 7,190,763 -69.47% CC0531 Wastewater Plant Management 2,050,000 - - 2,050,000 0.00% - 0.00% CC0527 Water Services Administration - - - - 0.00% - 0.00% CC0528 Water Distribution 1,159,424 77,506 781,316 378,108 67.39% (703,809) 908.07% CC0529 Water Plant Management 2,757 - - 2,757 0.00% - 0.00% CC0553 Water Operations 14,124,300 2,081,831 11,704,343 2,419,957 82.87% (9,622,512) 462.21% CC0524 Metering Services 750,000 - - 750,000 0.00% - 0.00% Non-Operating Expense Total 124,828,037 20,031,198 29,760,867 95,067,170 23.84% (9,729,669) 48.57% Expense 172,333,967 70,418,989 72,783,376 99,550,591 57.77% (2,364,387) 3.36% Non-operating expense are budgeted at $124,828,037 in FY2021. Expenses total $29,760,867 through the quarter, which includes expenses for large projects as well as payment for debt services. Principal debt payments are made in the 4th quarter. Large variances between Systems Engineering and Water Operations cost centers compared to FY2020 are due to data coding changes in the new financial reporting system that are related to new tracking mechanisms for capital projects. 15 F FY2021 Quarterly Report FY2021 Quarterly Report Unspent commitments for large multi-year capital projects will be proposed in an FY2022 Roll Forward Budget Amendment. Approximately $93.3 million in water and wastewater projects are positioned to roll forward. FY2021 EXPENSE PROJECTIONS: Total expenses are projected to end FY2021 at $171,645,358. Water Services Financial Report Quarterly Comparison: Q4 FY2021 Budget FY2021 FY2021 Year-to-date: Budget Vs. Actuals FY2021 Year-to-date Vs. Projections FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections FY2021 Variance Fav/(Unfav) % of Projection Operating Expense City of Georgetown (Only) - - - 0.00% - - 0.00% CC0001 Non-Departmental 4,223,814 5,131,684 (907,870) 121.49% 4,713,430 (418,254) 108.87% CC0526 Systems Engineering - (1,836,056) 1,836,056 0.00% (639,847) 1,196,209 286.95% CC0532 Irrigation Operations 295,000 139,285 155,715 47.22% 295,000 155,715 47.22% CC0530 Wastewater Operations 896,265 547,171 349,094 61.05% 834,706 287,535 65.55% CC0531 Wastewater Plant Management 4,013,950 3,516,184 497,766 87.60% 3,704,111 187,927 94.93% CC0527 Water Services Administration 26,369,169 24,491,296 1,877,873 92.88% 26,232,898 1,741,602 93.36% CC0528 Water Distribution 3,207,552 3,176,051 31,501 99.02% 3,911,851 735,800 81.19% CC0529 Water Plant Management 4,326,865 3,479,406 847,459 80.41% 3,910,271 430,866 88.98% CC0553 Water Operations 4,173,316 4,377,488 (204,172) 104.89% 4,463,681 86,193 98.07% Operating Expense Total 47,505,930 43,022,509 4,483,421 90.56% 47,426,102 4,403,593 90.71% Non-Operating Expense CC0001 Non-Departmental 4,083,411 92,665 3,990,746 2.27% 3,887,651 3,794,986 2.38% CC0526 Systems Engineering 99,509,468 13,900,168 85,609,300 13.97% 99,630,405 85,730,237 13.95% CC0532 Irrigation Operations 121,879 121,994 (115) 100.09% 121,929 (65) 100.05% CC0530 Wastewater Operations 3,026,798 3,160,381 (133,583) 104.41% 3,026,798 (133,583) 104.41% CC0531 Wastewater Plant Management 2,050,000 - 2,050,000 0.00% 2,050,000 2,050,000 0.00% CC0527 Water Services Administration - - - 0.00% 6,037 6,037 0.00% CC0528 Water Distribution 1,159,424 781,316 378,108 67.39% 781,316 - 100.00% CC0529 Water Plant Management 2,757 - 2,757 0.00% 2,757 2,757 0.00% CC0553 Water Operations 14,124,300 11,704,343 2,419,957 82.87% 13,962,363 2,258,021 83.83% CC0524 Metering Services 750,000 - 750,000 0.00% 750,000 750,000 0.00% Non-Operating Expense Total 124,828,037 29,760,867 95,067,170 23.84% 124,219,256 94,458,389 23.96% Expense 172,333,967 72,783,376 99,550,591 57.77% 171,645,358 98,861,982 42.40% Total operating expenses are projected to end FY2021 at $47,426,102. Operating expenses are anticipated to come in less than expected. In Water Administration, staff budgeted to buy Colorado river basin water in FY2021. However, the CIP project was not done so purchase of the water is not needed. There is significant savings in Water Distribution related to the timing of economic incentive agreements with the Parkside development. Finally, there is operational savings in Water Plant Management in utilities costs from less production over the summer months due to rain and, the Southside treatment plant being offline in the month of September. Through the quarter, actuals are 90.71% of total operating expense projections. Non-operating expenses are projected to end FY2021 at $124,219,256, which is 23.96% of year-to-date actuals through the quarter. The budget for capital projects will be rolled into FY2022 as part of the CIP RollForward 16 F FY2021 Quarterly Report FY2021 Quarterly Report Budget Amendment. The rollforward amendment will appropriate dollars multi-year projects and other projects that may have been affected by supply chain issues in FY2021. The Water Fund anticipates meeting all the funds below line contingency requirements by the end of FY2021. Contingency requirements include a 90-day operating contingency of $9,127,742, and a non-operating reserve of $10,000,000. Additionally, staff projects $40 million in water impact fees held for future capital appropriation, as well as a need to roll forward $93.3 million in open capital projects. After accounting for these, preliminary, unaudited available fund balance is projected to be $28 million. 17 F FY2021 Quarterly Report OTHER MAJOR FUNDS: Tourism Fund: The COVID-19 pandemic significantly impacted the tourism sector. Overall revenue in the fund totals $1,296,934, or 123.52% of budget. Hotel Occupancy Tax revenue in this fund year to date totals $1,247,146 through the quarter, or 138.57% of budget. Staff have continued to market Georgetown and are pleased to see occupancy rates recovering slowly but steadily. FY2021 REVENUE PROJECTIONS: Total revenues were projected to be $899,850. Through the quarter, actuals are 144.13% of total projections. The overnight stays in Georgetown are beginning to trend upward again. Estimates reflect a conservative approach due to the uncertainty of the pandemic’s impact on the remainder of the fiscal year. Tourism Fund Quarterly Comparison: Q4 FY2021 Budget FY2021 FY2021 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2021 YTD Actuals: Q4 FY2021 Variance % Variance Projections FY2021 Variance Fav/(Unfav) % of Projection Revenues 40008:Other Taxes 900,000 1,247,146 347,146 138.57% 850,000 397,146 146.72% 42001:Interest Income 5,000 5,057 57 101.15% 5,000 57 101.14% 45001:Misc Revenue 95,000 40,531 (54,469) 42.66% 39,850 682 101.71% 45003:Misc Reimbursements - - - 0.00% - - 0.00% 44001:Grant Revenue - 4,200 4,200 0.00% - 4,200 0.00% 44504:Donations - - - 0.00% - - 0.00% 44505:Sponsorship 50,000 - (50,000) 0.00% 5,000 (5,000) 0.00% Total Revenues 1,050,000 1,296,934 246,934 123.52% 899,850 397,084 144.13% FY2021 EXPENSE PROJECTIONS: Year to date expenses in the Convention & Visitors Bureau Fund total $1,071,232 or 72.47% of budget. Total expenses were projected to end FY2021 at $1,304,309. The savings are primarily due to from personnel vacancies and savings in contracted labor. The fall POPPTober festival and other modified programming were successful in promoting tourism downtown and throughout Georgetown. Overall, Tourism Fund expenditures are within budget and the fund can cover the 90-day Contingency Reserve. Total year-end fund balance is anticipated to be $508,619 in FY2021 with a contingency reserve of $305,771. Tourism Fund Quarterly Comparison: Q4 FY2021 Budget FY2021 FY2021 Year-to-date Vs. Budget Year-End: Projections Vs. Actuals FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections FY2021 Variance Fav/(Unfav) % of Projection Expenses City of Georgetown (Only) - - - 0.00% - - 0.00% CC0001 Non-Departmental 28,634 28,634 - 100.00% 28,634 - 100.00% CC0208 CVB 1,241,841 995,389 246,453 124.76% 1,093,475 98,086 91.03% CC0254 Poppy Festival 207,700 47,209 160,491 439.96% 182,200 134,991 25.91% Total Expenses 1,478,175 1,071,232 406,944 137.99% 1,304,309 233,077 82.13% 309K 368K 392K 313K K 100K 200K 300K 400K 500K Q1 Q2 Q3 Q4 HOTEL OCCUPANCY TAX FY2019 FY2020 FY2021 18 F FY2021 Quarterly Report Airport Fund: Airport operating revenue budget totals $3,951,500. Airport Charges, the largest segment of revenue totals $3,908,279 year to date. This includes revenue for fuel sales, facility lease, and hangar rentals. Total operating revenues through the quarter are $3,971,785, or 100.51% of budget. Non-operating revenue are bond proceeds for capital projects. Through the quarter the City has received $650,000 of bond proceeds as well as $64,186 in bond premiums. Total non-operating revenue through the quarter are $923,417. FY2021 REVENUE PROJECTIONS: Total operating revenues are projected to end FY2021 at $3,814,930. At the end of the quarter, operating revenue projections are 104.11% of year-to-date actuals. Non- operating revenues are projected to end the year at $872,186, and are at 105.87% of year-to-date actuals. Airport Quarterly Comparison: Q4 FY2021 Budget FY2021 FY2021 Year-to-date Vs. Budget Year-End: Projections Vs. Actuals FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections FY2021 Variance Fav/(Unfav) % of Projection Operating Revenue 40001:Property Taxes 40,000 59,423 19,423 148.56% 57,000 2,423 104.25% 42001:Interest Income 3,000 4,082 1,082 136.08% 3,129 953 130.47% 43606:Airport Charges 3,908,500 3,908,279 (221) 99.99% 3,754,800 153,479 104.09% Operating Revenue Total 3,951,500 3,971,785 20,285 100.51% 3,814,930 156,855 104.11% Non-Operating Revenue 45001:Misc Revenue 5,000 2,250 (2,750) 45.00% 1,000 1,250 225.00% 44001:Grant Revenue - 206,980 206,980 0.00% 157,000 49,980 131.83% 46001:Bond Proceeds 700,000 650,000 (50,000) 92.86% 650,000 - 100.00% 46002:Bond Premium - 64,186 64,186 0.00% 64,186 0 100.00% Non-Operating Revenue Total 705,000 923,417 218,417 130.98% 872,186 51,231 105.87% Total Revenue 4,656,500 4,895,202 238,702 105.13% 4,687,116 208,086 104.44% K 200K 400K 600K 800K 1.0M Q1 Q2 Q3 Q4 AIRPORT FUND FUEL SALES FY2020 FY2021 19 F FY2021 Quarterly Report Operating expenses in the Airport fund include a budget of $4,427,731. Year-to-date operation expenses totals $3,725,236. The budget for non-operating expenses total $908,931. This includes a CIP expense of $750,000 for the construction of a maintenance facility at the airport. The main capital project is a maintenance building. This project in incomplete and the unused funds will roll forward into the FY2022 budget amendment. Additionally, the estimated costs of the facility have increased after the design and bid. Bond proceeds will need to be increased in FY2022 as well to cover increased construction costs. The remaining amount of non-operating expense is for the airport’s debt service payment, which the fund has paid $147,341 year-to-date. FY2021 EXPENSE PROJECTIONS: FY2021 projections total $3,987,583. Through the quarter, actuals are 93.42% of total projections. Airport Fund Quarterly Comparison: Q4 FY2021 Budget FY2021 Year-End: Projections Vs. Actuals Year-End: Projections Vs. Actuals FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections FY2021 Variance Fav/(Unfav) % of Projection Operating Expense Personnel 464,472 447,529 16,943 96.35% 465,860 18,331 96.07% Operations 3,559,192 3,177,144 382,048 89.27% 3,416,469 239,325 92.99% Operating Capital 404,067 100,563 303,504 24.89% 105,255 4,692 95.54% Total Operating Expenses 4,427,731 3,725,236 702,495 84.13% 3,987,583 262,347 93.42% Non-Operating Expense CIP Expense 750,000 - 750,000 0.00% 750,000 750,000 0.00% Debt Service 158,931 147,341 11,590 92.71% 158,931 11,590 92.71% Non-Operating Expense Total 908,931 147,341 761,590 16.21% 908,931 761,590 16.21% Expense Total 5,336,662 3,872,577 1,464,085 72.57% 4,896,514 1,023,937 79.09% Overall, Airport Operation expenditures are within budget and the fund can cover the 90-day Contingency Reserve of $332,917, as well as a debt service reserve of $184,099. 20 F FY2021 Quarterly Report GRANTS SUMMARY: FY2021 had more grant activity than usual due to the COVID pandemic and Winter Storm Uri. The City has applied to the Federal Emergency Management Administration (FEMA) for reimbursement for 3 sets of expenses due to the storm. Citywide and Water Fund activities are pending FEMA review. The Electric activities were denied and the City is filing an appeal. In total, the City has applied for $1,036,837 in reimbursement and received $0. For FY2021, no grant receivables have been booked, and the costs of the storm were absorbed through fund balance or higher than expected revenues. The City continues to report on CARES Act federal grant funding for the pandemic for the Airport ($157,000), Emergency Medical Services ($76,174), and the National Endowment for the Arts $9,562). The City has closed out the CARES grant project with Williamson County, totaling $259,725 in reimbursement received in FY2020 and FY2021. In summer of FY2021, the City applied for and received the American Rescue Plan Act grant funds. Total award is $8 million. The first section of $4 million was received by the City during the summer, and the second section is anticipated in summer of FY2022. So far the City has reimbursed itself for approximately $87,000 in COVID related expenses that were previously covered under the CARES Act (personnel protective equipment, testing, cleaning services). Staff are updating Council and seeking feedback on the anticipated eligibility of $5.4 million under the Revenue Loss category, which could be used to fund infrastructure or other general municipal purposes. Additionally, Council has expressed interest in using up to $2.4 million toward resiliency projects for water and wastewater infrastructure. 21 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 fourth quarter of fiscal year 2021 includes the maturing, reinvesting, and new investments of financial institution deposits (CDs), receipt of the first tranche of the 2021 mobility bond, and payment of outstanding bonds. Interest rates continue to be low for money market accounts, Treasury bills, and CD’s. We are seeing a decline in the number of banks responding to our investment offerings. The decrease in interest from banks was exacerbated due to the US Treasury’s release of the billions of dollars for the American Rescue Plan in the 3rd quarter. The FOMC met September 21st and 22nd. Upon adjournment they announced that the Fed Funds rate would remain unchanged at a range of 0% to 0.25% and that the program to purchase $120 billion in Treasury/Agency assets each month to add liquidity would also remain in effect. However, the announcement and the subsequent Press Conference clarified that the Committee discussed “tapering” or the winding down of the amount of monthly Treasury/Agency purchases. They will gradually decrease the amount of monthly purchases. Chair Powell went so far as to discuss a timeline for tapering and the ultimate end of this stimulus tool. The FOMC discussed beginning the taper as soon as the next meeting (in early November) and anticipated that the wind-down would end around mid-2022 as long as the economy continued to recover near the current pace. The FOMC forecasts that a Fed Funds Rate increase could come in mid-2022 followed by two more increases in 2023. The current FOMC expectation is for the Fed Funds rate to reach 1.8% in 2024. The City will continue soliciting for the best rates to improve both diversity and yield, while keeping in mind safety and liquidity. 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 September 30, 2021, 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 66.5%, debt service at .5%, and bond proceeds at 33%. The City’s portfolio had a net increase from the third quarter due to the receipt of mobility bond proceeds sold in August. GTEC and GEDCO’s portfolios decreased from the third quarter due to principal and interest payments made in August. CITY Book Value GTEC GEDCO 6/30/21 9/30/21 6/30/21 9/30/21 6/30/21 9/30/21 Total cash and investments $345,161,582 $377,319,060 $42,427,551 $37,764,985 $11,734,129 $9,649,850 Quarter End Average Yield .15% .13% .04% .03% .07% .08% 22 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 City’s investment portfolio generally includes bank deposits, local government investment pool balances, money market accounts, and financial institution deposits (CD’s). All of these investments meet the safety requirements of the PFIA. Local Government Investment Pools must maintain a rating of AAA, 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 continues to work with the City’s depository bank (JPMorgan Chase) 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. 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. With new capability in the recent financial software implementation, we are providing 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 demand for transportation and water services, City staff have formed two working groups with the goal of improving work capacity and efficiencies, and ultimately customer service, related to capital projects. One 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. The second group is focused on the re- organization of development-related capital improvements from the Systems Engineering department to the Planning Department. Both groups will continue working through the first quarter of FY2022. 20% 7% 34%1% 33% 0%5% Total Portfolio Texpool MM Texstar TexasTerm CD's JPM Escrow Depository 23 General Fund Period: Sep-21 Budget Current Period FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance Fav/(Unfav)% of Projection Beginning Fund Balance 21,196,610 21,196,610 - 100.00%21,196,610 - 100.00% Revenue 40001:Property Taxes 15,976,505 (247,798) 15,893,725 (82,780) 99.48%15,996,505 (102,780) 99.36% 40002:Sales Taxes 18,576,250 6,329,769 23,895,422 5,319,172 128.63%22,924,375 971,047 104.24% 40005:Franchise Taxes 6,255,270 866,794 6,183,295 (71,975) 98.85%6,182,563 731 100.01% 40008:Other Taxes 400,000 275,633 481,489 81,489 120.37%410,000 71,489 117.44% 41001:Fines 328,392 25,560 270,205 (58,187) 82.28%290,600 (20,395) 92.98% 41002:Penalties 60,000 10,340 104,967 44,967 174.95%70,000 34,968 149.95% 42001:Interest Income 75,000 3,468 81,050 6,050 108.07%87,429 (6,379) 92.70% 43001:Fees 7,028,184 728,626 7,532,037 503,853 107.17%6,876,306 655,731 109.54% 43002:Garbage Charges 10,151,764 927,027 10,867,148 715,385 107.05%10,300,000 567,148 105.51% 43003:Permits 4,317,750 303,635 4,781,179 463,429 110.73%4,880,250 (99,071) 97.97% 43004:Administrative Charges 3,396,447 282,708 3,392,501 (3,946) 99.88%3,396,447 (3,946) 99.88% 43005:Rental Revenue 148,140 15,222 199,449 51,309 134.64%125,947 73,503 158.36% 45001:Misc Revenue 871,955 55,490 717,891 (154,064) 82.33%804,049 (86,158) 89.28% 45003:Misc Reimbursements - 844 13,521 13,521 0.00%- 13,521 0.00% 44001:Grant Revenue 679,884 278,882 914,494 234,610 134.51%500,000 414,495 182.90% 44501:Contribution Revenue - - - - 0.00%- - 0.00% 44502:Developer Contributions 423,112 (193,646) 229,682 (193,430) 54.28%423,332 (193,650) 54.26% 44503:Interlocal Agreement Revenue 5,091,091 1,183,773 5,093,767 2,676 100.05%5,091,092 2,675 100.05% 44504:Donations - - 6,238 6,238 0.00%- 6,238 0.00% 70001:Transfers In 995,302 - 995,302 - 100.00%995,302 - 100.00% 70002:Transfers In - Payment in Lieu of Taxes (PILOT)8,431,375 543,352 9,022,128 590,753 107.01%8,460,467 561,661 106.64% Revenue Total 83,206,421 11,389,678 90,675,491 7,469,070 108.98%87,814,662 2,860,829 103.26% Expense City of Georgetown (Only)- - (140) (140) 0.00%- (140) 0.00% CC0001 Non-Departmental 1,654,691 1,891 1,369,493 285,198 82.76%6,357,848 4,988,355 21.54% CC0107 Planning 1,978,054 216,912 1,750,470 227,584 88.49%1,903,216 152,746 91.97% CC0202 Parks Administration 662,887 63,769 630,335 32,552 95.09%643,407 13,072 97.97% CC0210 Library 2,837,904 288,598 2,699,109 138,795 95.11%2,852,883 153,773 94.61% CC0211 Parks 2,727,414 290,717 2,583,064 144,350 94.71%2,640,698 57,634 97.82% CC0212 Recreation 2,899,381 302,758 2,755,929 143,452 95.05%2,870,088 114,159 96.02% CC0213 Tennis Center 442,917 38,625 386,537 56,380 87.27%421,451 34,914 91.72% CC0214 Recreation Programs 1,251,370 75,566 948,688 302,682 75.81%1,093,594 144,906 86.75% CC0215 Garey Park 982,022 82,028 857,934 124,088 87.36%974,873 116,939 88.00% CC0218 Arts and Culture 57,857 16,203 82,372 (24,515) 142.37%57,857 (24,515) 142.37% CC0316 Municipal Court 585,123 65,392 554,822 30,301 94.82%556,709 1,887 99.66% CC0402 Fire Support Services/Administration 4,348,592 443,646 3,766,322 582,269 86.61%3,795,965 29,643 99.22% CC0422 Fire Emergency Services 15,953,391 2,507,752 15,520,210 433,180 97.28%15,961,522 441,312 97.24% CC0448 EMS 2,580,541 394,010 2,879,530 (298,989) 111.59%3,063,614 184,085 93.99% CC0533 Environmental Services 9,662,924 1,715,348 9,587,669 75,256 99.22%9,666,349 78,680 99.19% CC0536 Inspection Services 1,547,913 204,296 1,459,857 88,056 94.31%1,439,273 (20,584) 101.43% Year-End: Projections Vs. ActualsYear-to-Date Actuals Budget Vs. Actuals 24 General Fund Period: Sep-21 Budget Current Period FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance Fav/(Unfav)% of Projection Year-End: Projections Vs. ActualsYear-to-Date Actuals Budget Vs. Actuals CC0602 Administrative Services 1,893,936 159,190 1,694,473 199,463 89.47%1,921,512 227,039 88.18% CC0605 Community Services 353,889 19,357 350,621 3,268 99.08%359,411 8,790 97.55% CC0634 City Council Services 185,734 12,664 184,733 1,001 99.46%190,992 6,259 96.72% CC0635 City Secretary Services 1,009,772 116,091 981,238 28,533 97.17%988,578 7,340 99.26% CC0637 Economic Development - (107) - - 0.00%1,625 1,625 0.00% CC0638 General Government Contracts 4,774,808 349,683 5,211,164 (436,356) 109.14%5,529,569 318,404 94.24% CC0639 Human Resources - - - - 0.00%3,599 3,599 0.00% CC0655 Communications/Public Engagement 844,604 85,183 704,633 139,971 83.43%825,151 120,518 85.39% CC0702 Police Administration 2,567,848 221,070 2,365,080 202,768 92.10%2,565,917 200,837 92.17% CC0742 Police Operations 14,669,105 1,639,424 14,763,085 (93,979) 100.64%14,508,770 (254,315) 101.75% CC0744 Animal Services 1,106,702 117,309 934,970 171,732 84.48%1,046,689 111,719 89.33% CC0745 Code Compliance 562,740 73,639 483,750 78,990 85.96%520,890 37,140 92.87% CC0802 Public Works 1,705,914 188,192 1,365,719 340,194 80.06%1,632,799 267,080 83.64% CC0845 Stormwater - (4,684) - - 0.00%- - 0.00% CC0846 Streets 3,137,149 342,135 2,872,098 265,051 91.55%3,082,495 210,398 93.17% Expense Total 82,985,180 10,026,658 79,743,765 3,241,415 96.09%87,477,342 7,733,577 91.16% Excess (Deficiency) of Total Revenue over Total Requirements 221,240 1,363,020 10,931,725 10,710,485 4941.11%337,319 10,594,406 3240.76% Ending Fund Balance 21,417,850 32,128,335 10,710,485 150.01%21,533,929 10,594,406 149.20% Reserves AFR Adjustment - - - 0.00%- - 0.00% Benefit Payout Reserve 340,000 340,000 - 100.00%340,000 - 100.00% Contingency Reserve 12,626,752 12,626,752 - 100.00%12,626,752 - 100.00% Economic Stability Reserve 1,467,563 1,467,563 - 100.00%1,467,563 - 100.00% Reserves Total 14,434,315 14,434,315 - 100.00%14,434,315 - 100.00% Available Fund Balance 6,983,535 17,694,020 10,710,485 253.37%7,099,614 10,594,406 249.23% 25 General FundQuarterly Comparison: Q4 FY2021 Budget Actuals FY2021YTD Actuals:Q4 FY2021Variance % of Budget Projections 2021VarianceFav/(Unfav)% of ProjectionPlanningPersonnel1,383,026 1,342,756 40,270 97.09% 1,335,261 (7,495) 100.56%Operations593,976 406,662 187,314 68.46% 564,055 157,393 72.10%Operating Capital1,052 1,052 0 99.96%3,900 2,848 26.96%Planning Total Expense1,978,054 1,750,470 227,584 88.49% 1,903,216 152,746 91.97%LibraryPersonnel1,798,754 1,686,347 (90,100) 93.75% 1,828,761 142,414 92.21%Operations1,010,650 1,004,209 70,111 99.36% 1,016,162 11,953 98.82%Operating Capital28,500 8,553 (8,553) 30.01%7,960 (593) 107.46%Library Total Expense2,837,904 2,699,109 (28,543) 95.11% 2,852,883 153,773 94.61%Parks AdministrationPersonnel278,450 280,793 (2,343) 100.84% 276,737 (4,056) 101.47%Operations384,437 384,437 0.00% 366,670 366,670 0.00%Parks Administration Total Expense662,887 630,335 32,552 95.09% 643,407 13,072 97.97%ParksPersonnel1,540,835 1,453,737 87,097 94.35% 1,455,988 2,251 99.85%Operations1,186,579 1,129,327 57,252 95.17% 1,184,709 55,383 95.33%Operating Capital- - - 0.00%- - 0.00%CIP Expense- - - 0.00%- - 0.00%Parks Total Expense2,727,414 2,583,064 144,350 94.71% 2,640,698 57,634 97.82%RecreationPersonnel1,606,081 1,584,967 21,114 98.69% 1,629,136 44,169 97.29%Operations1,293,300 1,150,994 142,306 89.00% 1,240,952 89,957 92.75%Operating Capital- 19,968 (19,968) 0.00%- (19,968) #DIV/0!Recreation Total Expense2,899,381 2,755,929 143,452 95.05% 2,870,088 114,159 96.02%Tennis CenterPersonnel235,401 226,269 9,131 96.12% 230,744 4,474 98.06%Operations207,516 160,268 47,248 77.23% 190,707 30,440 84.04%Tennis Center Total Expense442,917 386,537 56,380 87.27% 421,451 34,914 91.72%Recreation ProgramsPersonnel680,377 493,066 187,311 72.47% 651,365 158,299 75.70%Budget Vs. ActualsYear‐End: Projections Vs. Actuals26 General FundQuarterly Comparison: Q4 FY2021 Budget Actuals FY2021YTD Actuals:Q4 FY2021Variance % of Budget Projections 2021VarianceFav/(Unfav)% of ProjectionBudget Vs. ActualsYear‐End: Projections Vs. ActualsOperations570,993 455,622 115,371 79.79% 442,228 (13,393) 103.03%Recreation Programs Total Expense1,251,370 948,688 302,682 75.81% 1,093,594 144,906 86.75%Garey ParkPersonnel471,122 436,640 34,483 92.68% 491,455 54,815 88.85%Operations510,589 421,384 89,205 82.53% 483,418 62,035 87.17%Operating Capital311 (89) 400 -28.69%- 89 0.00%Garey Park Total Expense982,022 857,934 124,088 87.36% 974,873 116,939 88.00%Arts and CultureOperations57,857 60,265 (2,408) 104.16%57,857 (2,407) 104.16%Personnel- 22,108 (22,108) 0.00%- (22,108) #DIV/0!Arts and Culture Total Expense57,857 82,372 (24,515) 142.37%57,857 (24,515) 142.37%Municipal CourtPersonnel484,734 476,716 8,019 98.35% 473,558 (3,158) 100.67%Operations100,389 78,106 22,283 77.80%83,151 5,044 93.93%Municipal Court Total Expense585,123 554,822 30,301 94.82% 556,709 1,887 99.66%Fire Support Services/AdministrationPersonnel2,877,376 2,370,610 506,765 82.39% 2,361,824 (8,786) 100.37%Operations1,446,067 1,380,436 65,631 95.46% 1,409,421 28,985 97.94%Operating Capital25,149 15,276 9,873 60.74%24,720 9,444 61.80%Fire Support Total Expense4,348,592 3,766,322 582,269 86.61% 3,795,965 29,643 99.22%Fire Emergency ServicesPersonnel13,493,986 13,163,820 330,166 97.55% 13,618,867 455,047 96.66%Operations2,379,405 2,280,147 99,258 95.83% 2,262,655 (17,491) 100.77%Operating Capital80,000 76,244 3,756 95.30%80,000 3,756 95.30%Fire Emergency Services Total Expense15,953,391 15,520,210 433,180 97.28% 15,961,522 441,312 97.24%EMSPersonnel1,749,042 2,137,655 (388,614) 122.22% 2,234,698 97,043 95.66%Operations773,749 714,482 59,267 92.34% 771,166 56,684 92.65%Operating Capital57,750 27,392 30,358 47.43%57,750 30,358 47.43%EMS Total Expense2,580,541 2,879,530 (298,989) 111.59% 3,063,614 184,085 93.99%27 General FundQuarterly Comparison: Q4 FY2021 Budget Actuals FY2021YTD Actuals:Q4 FY2021Variance % of Budget Projections 2021VarianceFav/(Unfav)% of ProjectionBudget Vs. ActualsYear‐End: Projections Vs. ActualsInspection ServicesPersonnel1,366,692 1,318,950 47,743 96.51% 1,280,873 (38,076) 102.97%Operations181,221 140,908 40,313 77.75% 158,400 17,492 88.96%Inspection Services Total Expense1,547,913 1,459,857 88,056 94.31% 1,439,273 (20,584) 101.43%Administrative ServicesPersonnel1,367,229 1,334,303 32,926 97.59% 1,394,528 60,225 95.68%Operations526,707 360,170 166,537 68.38% 526,984 166,814 68.35%Administration Services Total Expense1,893,936 1,694,473 199,463 89.47% 1,921,512 227,039 88.18%Community ServicesPersonnel240,597 238,741 1,856 99.23% 246,932 8,191 96.68%Operations113,291 111,880 1,411 98.75% 112,479 599 99.47%Community Services Total Expense353,889 350,621 3,268 99.08% 359,411 8,790 97.55%City SecretaryPersonnel524,370 527,909 (3,540) 100.68% 518,033 (9,876) 101.91%Operations485,402 453,329 32,073 93.39% 470,545 17,217 96.34%City Secretary Total Expense1,009,772 981,238 28,533 97.17% 988,578 7,340 99.26%Communications/ Public EngagementPersonnel533,969 531,186 2,783 99.48% 545,571 14,385 97.36%Operations310,635 173,447 137,188 55.84% 279,580 106,133 62.04%Communications Total Expense844,604 704,633 139,971 83.43% 825,151 120,518 85.39%Police AdministrationPersonnel652,285 637,301 14,984 97.70% 652,443 15,142 97.68%Operations1,915,563 1,727,779 187,784 90.20% 1,913,474 185,695 90.30%Police Administration Total Expense2,567,848 2,365,080 202,768 92.10% 2,565,917 200,837 92.17%Police OperationsPersonnel12,308,896 12,589,801 (280,904) 102.28% 12,224,416 (365,384) 102.99%Operations2,283,105 2,153,916 129,189 94.34% 2,207,250 53,334 97.58%Operating Capital77,104 19,368 57,736 25.12%77,104 57,736 25.12%Police Operations Total Expense14,669,105 14,763,085 (93,979) 100.64% 14,508,770 (254,315) 101.75%28 General FundQuarterly Comparison: Q4 FY2021 Budget Actuals FY2021YTD Actuals:Q4 FY2021Variance % of Budget Projections 2021VarianceFav/(Unfav)% of ProjectionBudget Vs. ActualsYear‐End: Projections Vs. ActualsAnimal ServicesPersonnel765,898 664,371 101,526 86.74% 707,099 42,727 93.96%Operations340,804 270,598 70,206 79.40% 339,590 68,992 79.68%Animal Services Total Expense1,106,702 934,970 171,732 84.48% 1,046,689 111,719 89.33%Code CompliancePersonnel464,093 389,597 74,496 83.95% 417,009 27,412 93.43%Operations95,650 94,153 1,497 98.43% 103,881 9,728 90.64%Operating Capital2,997 - 2,997 0.00%- - 0.00%Code Compliance Total Expense562,740 483,750 78,990 85.96% 520,890 37,140 92.87%Public WorksPersonnel608,830 489,619 119,212 80.42% 483,229 (6,389) 101.32%Operations1,097,084 871,299 225,785 79.42% 1,149,450 278,151 75.80%Operating Capital- 4,802 (4,802) 0.00%120 (4,682) 4003.54%Public Works Total Expense1,705,914 1,365,719 340,194 80.06% 1,632,799 267,080 83.64%StreetsPersonnel1,384,302 1,262,357 121,945 91.19% 1,350,963 88,606 93.44%Operations1,752,107 1,598,367 153,740 91.23% 1,718,988 120,621 92.98%Operating Capital740 11,373 (10,633) 1537.00%12,544 1,171 90.67%Streets Total Expense3,137,149 2,872,098 265,051 91.55% 3,082,495 210,398 93.17%Environmental ServicesOperations9,637,924 9,587,669 50,256 99.48% 9,641,349 53,680 99.44%Operating Capital25,000 - 25,000 0.00%25,000 25,000 0.00%Environmental Services Total Expense9,662,924 9,587,669 75,256 99.22% 9,666,349 78,680 99.19%Non‐DepartmentalOperations- 12,577 (12,577) 0.00%3,157 (9,420) 398.40%Transfers1,654,691 1,356,916 297,775 82.00% 6,354,691 4,997,775 21.35%Non-Departmental Total Expense1,654,691 1,369,493 285,198 82.76% 6,357,848 4,988,355 21.54%General Government ContractsOperations6,024,808 5,211,164 813,644 86.50% 5,829,569 618,404 89.39%Personnel(1,250,000) - (1,250,000) 0.00% (300,000) (300,000) 0.00%General Government Contracts Expense4,774,808 5,211,164 (436,356) 109.14% 5,529,569 318,404 94.24%29 General FundQuarterly Comparison: Q4 FY2021 Budget Actuals FY2021YTD Actuals:Q4 FY2021Variance % of Budget Projections 2021VarianceFav/(Unfav)% of ProjectionBudget Vs. ActualsYear‐End: Projections Vs. ActualsGeneral Fund Total Expenses82,985,180 79,743,765 3,241,415 96.09% 87,477,342 7,733,577 91.16%30 Electric Services Period: Sep-21 Budget Current Period FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance Fav/(Unfav)% of Projection Beginning Fund Balance 28,133,710 28,133,710 - 100.00%28,133,710 - 100.00% Operating Revenues 40002:Sales Taxes 5,000 611 5,863 863 117.25%5,000 863 117.25% 40005:Franchise Taxes 115,732 - - (115,732) 0.00%- - 0.00% 41002:Penalties 553,724 86,995 848,000 294,276 153.14%547,759 300,241 154.81% 42001:Interest Income 5,000 1,909 33,570 28,570 671.40%20,828 12,742 161.18% 43001:Fees 685,000 243,875 1,036,657 351,657 151.34%868,887 167,770 119.31% 43004:Administrative Charges 3,222,103 268,509 3,222,103 (0) 100.00%3,222,103 (0) 100.00% 43601:Electric Sales Charges 78,982,278 7,701,095 80,933,053 1,950,775 102.47%79,081,809 1,851,244 102.34% 44502:Developer Contributions 1,500,000 425,911 7,828,988 6,328,988 521.93%6,100,000 1,728,988 128.34% 70001:Transfers In 1,562,058 - 1,562,058 - 100.00%1,562,058 - 100.00% Total Operating Revenues 86,630,895 8,728,904 95,470,292 8,839,397 110.20%91,408,444 4,061,848 104.44% Operating Expenses City of Georgetown (Only)- - - - 0.00%- - 0.00% CC0001 Non-Departmental 5,506,375 1,263,669 6,520,044 (1,013,669) 118.41%6,668,720 148,676 97.77% CC0526 Systems Engineering - - - - 0.00%80,506 80,506 0.00% CC0522 Electric Administration 8,738,792 922,184 8,868,267 (129,476) 101.48%8,944,477 76,210 99.15% CC0525 T&D Services 3,122,421 524,750 4,185,597 (1,063,176) 134.05%3,089,942 (1,095,655) 135.46% CC0537 Electric Resource Management 108,334,393 3,572,953 109,900,806 (1,566,413) 101.45%108,331,349 (1,569,457) 101.45% CC0555 Electric Systems Operations 1,610,228 172,830 1,579,253 30,976 98.08%1,639,454 60,202 96.33% CC0557 Electrical Engineering 663,952 149,386 1,070,057 (406,104) 161.16%715,684 (354,372) 149.52% CC0521 Electric Technical Services 727,388 68,728 670,962 56,426 92.24%717,148 46,186 93.56% CC0524 Metering Services 2,022,094 157,972 1,939,497 82,597 95.92%2,029,912 90,414 95.55% Total Operating Expenses 130,725,643 6,832,471 134,738,524 (4,012,881) 103.07%132,217,192 (2,521,332) 101.91% Net Operations Total (44,094,748) (39,268,232) 12,852,277 89.05%(40,808,747) 1,540,515 96.23% Non-Operating Revenues 45001:Misc Revenue 35,000 116,172 523,214 488,214 1494.90%233,023 290,191 224.53% 45004:Sale of Property 10,000 669,987 4,127,598 4,117,598 41275.98%2,526,604 1,600,994 163.37% 44001:Grant Revenue - - - - 0.00%- - 0.00% 46001:Bond Proceeds 54,648,625 - 54,065,000 (583,625) 98.93%54,065,000 - 100.00% 46002:Bond Premium - - 652,424 652,424 0.00%652,424 0 100.00% Total Non-Operating Revenues 54,693,625 786,159 59,368,236 4,674,611 108.55%57,477,051 1,891,185 103.29% Non-Operating Expenses CC0001 Non-Departmental 4,375,805 - 4,298,971 76,834 98.24%4,373,805 74,834 98.29% CC0526 Systems Engineering - - - - 0.00%- - 0.00% CC0557 Electrical Engineering 8,166,143 728,287 3,386,145 4,779,997 41.47%8,166,142 4,779,997 41.47% Total Non-Operating Expenses 12,541,948 728,287 7,685,116 4,856,831 61.28%12,539,947 4,854,831 61.29% Excess (Deficiency) of Total Revenue over Total Requirements (1,943,071) 121,950,101 12,414,888 14,357,959 -638.93%4,128,357 8,286,532 300.72% Ending Fund Balance 26,190,639 40,548,598 14,357,959 154.82%32,262,067 8,286,532 125.69% Reserves Rate Stabalization - 18,600,000 18,600,000 0.00%18,600,000 - 100.00% Reserve for Bond Proceeds 4,448,314 4,448,314 - 100.00%4,448,314 - 100.00% Contingency Reserve 4,018,754 4,018,754 - 100.00%4,018,754 - 100.00% Non-Operating Reserve 10,594,999 3,486,903 (7,108,096) 32.91%3,486,903 - 100.00% Reserves Total 19,062,067 30,553,971 11,491,904 160.29%30,553,971 - 100.00% Available Fund Balance 7,128,572 9,994,627 2,866,055 140.21%1,708,096 8,286,532 585.13% Year-to-Date Actuals Budget Vs. Actuals Year-End: Projections Vs. Actuals 31 Water Services Fund Period: Sep-21 Budget Current Period FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance Fav/(Unfav)% of Projection Beginning Fund Balance 125,458,053 125,458,053 - 100.00%125,458,053 - 100.00% Operating Revenue 41002:Penalties 255,000 54,861 513,447 258,447 201.35%355,000 158,447 44.63% 42001:Interest Income 237,250 19,335 427,758 190,508 180.30%492,336 (64,577) 86.88% 43001:Fees 4,290,000 525,550 9,598,958 5,308,958 223.75%7,655,000 1,943,958 125.39% 43005:Rental Revenue 55,000 46,430 112,975 57,975 205.41%60,000 52,975 188.29% 43602:Water Charges 32,150,000 5,697,888 41,143,198 8,993,198 127.97%35,100,000 6,043,198 117.22% 43603:Wastewater Charges 14,200,000 1,346,460 15,125,001 925,001 106.51%14,000,000 1,125,001 108.04% 43604:Irrigation Charges 300,000 72,113 360,002 60,002 120.00%300,000 60,002 120.00% 41602:Impact Fees 18,800,000 3,668,562 40,034,496 21,234,496 212.95%32,500,000 7,534,496 123.18% 44502:Developer Contributions 625,000 - 1,490,202 865,202 238.43%1,496,239 (6,037) 99.60% Total Operating Revenue 70,912,250 11,431,199 108,806,038 37,893,788 153.44%91,958,575 16,847,463 118.32% Operating Expenses City of Georgetown (Only)- - - - 0.00%- - 0.00% CC0001 Non-Departmental 4,223,814 942,511 5,131,684 (907,870) 121.49%4,713,430 (418,254) 108.87% CC0526 Systems Engineering - - (1,836,056) (1,836,056) 0.00%(639,847) 1,196,209 286.95% CC0532 Irrigation Operations 295,000 11,987 139,285 155,715 47.22%295,000 155,715 47.22% CC0530 Wastewater Operations 896,265 45,966 547,171 349,094 61.05%834,706 287,535 65.55% CC0531 Wastewater Plant Management 4,013,950 289,802 3,516,184 497,766 87.60%3,704,111 187,927 94.93% CC0527 Water Services Administration 26,369,169 2,078,728 24,491,296 1,877,873 92.88%26,232,898 1,741,602 93.36% CC0528 Water Distribution 3,207,552 224,030 3,176,051 31,501 99.02%3,911,851 735,800 81.19% CC0529 Water Plant Management 4,326,865 379,014 3,479,406 847,459 80.41%3,910,271 430,866 88.98% CC0553 Water Operations 4,173,316 458,338 4,377,488 (204,172) 104.89%4,463,681 86,193 98.07% CC0524 Metering Services - (265) - - 0.00%- - 0.00% Operating Expense Total 47,505,930 4,430,111 43,022,509 4,483,421 90.56%47,426,102 4,403,593 90.71% Available Operating Fund Balance 23,406,320 65,783,529 33,410,367 44,532,473 21,251,056 147.72% Non-Operating Revenue 45001:Misc Revenue 1,112,500 1,073,450 1,312,616 200,116 117.99%1,262,350 50,266 103.98% 45003:Misc Reimbursements - - 10,422 10,422 0.00%- 10,422 0.00% 45004:Sale of Property 1,327,774 - 1,330,463 2,689 100.20%1,327,774 2,689 100.20% 44001:Grant Revenue - - - - 0.00%- - 0.00% 46001:Bond Proceeds 16,300,000 - 14,975,000 (1,325,000) 91.87%14,975,000 - 100.00% 46002:Bond Premium - - 1,415,140 1,415,140 0.00%1,415,140 (0) 100.00% Non-Operating Revenue Total 18,740,274 1,073,450 19,043,639 303,365 101.62%18,980,264 63,375 100.33% Non-Operating Expenses CC0001 Non-Departmental 4,083,411 - 92,665 3,990,746 2.27%3,887,651 3,794,986 2.38% CC0526 Systems Engineering 99,509,468 2,895,483 13,900,168 85,609,300 13.97%99,630,405 85,730,237 13.95% CC0532 Irrigation Operations 121,879 - 121,994 (115) 100.09%121,929 (65) 100.05% CC0530 Wastewater Operations 3,026,798 137,163 3,160,381 (133,583) 104.41%3,026,798 (133,583) 104.41% CC0531 Wastewater Plant Management 2,050,000 - - 2,050,000 0.00%2,050,000 2,050,000 0.00% CC0527 Water Services Administration - - - - 0.00%6,037 6,037 0.00% CC0528 Water Distribution 1,159,424 - 781,316 378,108 67.39%781,316 - 100.00% CC0529 Water Plant Management 2,757 - - 2,757 0.00%2,757 2,757 0.00% CC0553 Water Operations 14,124,300 126,666 11,704,343 2,419,957 82.87%13,962,363 2,258,021 83.83% CC0524 Metering Services 750,000 - - 750,000 0.00%750,000 750,000 0.00% Non-Operating Expense Total 124,828,037 3,159,313 29,760,867 95,067,170 23.84%124,219,256 94,458,389 23.96% Excess (Deficiency) of Total Revenue over Total Requirements (82,681,443) (142,162,493) 55,066,302 137,747,744 -66.60%(60,706,519) 115,772,820 -90.71% Ending Fund Balance 42,776,610 180,524,355 137,747,744 422.02%64,751,534 115,772,820 278.80% Reserves Contingency Reserve 9,127,742 9,127,742 - 100.00%9,127,742 - 100.00% Non-Operating Reserve 10,000,000 10,000,000 - 100.00%10,000,000 - 100.00% Reserves Total 19,127,742 19,127,742 - 100.00%19,127,742 - 100.00% Available Fund Balance 23,648,868 161,396,613 137,747,744 682.47%45,623,792 115,772,820 353.76% Year-to-Date Actuals Budget Vs. Actuals Year-End: Projections Vs Actuals 32 Joint Services Period: Sep-21 Budget Current Period FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance Fav/(Unfav)% of Projection Beginning Fund Balance 2,157,365 2,157,365 - 100.00%2,157,365 - 100.00% Revenue 41002:Penalties - 643 27,968 27,968 0.00%25,000 2,968 111.87% 42001:Interest Income 6,250 242 7,416 1,166 118.66%6,250 1,166 118.66% 43001:Fees 173,600 360 19,825 (153,775) 11.42%14,000 5,825 141.61% 43003:Permits - - - - 0.00%- - 0.00% 43004:Administrative Charges 17,912,066 1,483,995 17,919,566 7,500 100.04%17,912,066 7,500 100.04% 43005:Rental Revenue - - 100 100 0.00%100 - 100.00% 45001:Misc Revenue - - 431 431 0.00%431 - 100.00% 45002:Insurance Proceeds - 3,262 176,186 176,186 0.00%70,000 106,186 251.69% 45003:Misc Reimbursements 83,000 10,749 135,251 52,251 162.95%91,356 43,895 148.05% 44001:Grant Revenue - - - - 0.00%- - 0.00% 70001:Transfers In - - - - 0.00%- - 0.00% Revenue Total 18,174,916 1,499,250 18,286,743 111,827 100.62%18,119,203 167,539 100.92% Expense City of Georgetown (Only)- - - - 0.00%- - 0.00% CC0001 Non-Departmental 965,999 134,114 1,351,283 (385,284) 139.88%1,246,402 (104,881) 108.41% CC0302 Finance Administration 1,222,909 155,116 1,031,741 191,168 84.37%1,025,554 (6,188) 100.60% CC0315 Accounting 1,302,383 153,803 1,317,455 (15,072) 101.16%1,358,423 40,968 96.98% CC0317 Purchasing 996,521 109,835 932,518 64,003 93.58%937,558 5,040 99.46% CC0321 Customer Care 5,955,711 559,160 5,693,772 261,939 95.60%5,867,947 174,175 97.03% CC0503 Organizational and Operational Excellence 342,009 38,095 310,835 31,174 90.88%323,516 12,681 96.08% CC0526 Systems Engineering 2,757,957 293,657 2,586,589 171,368 93.79%2,755,159 168,570 93.88% CC0534 Conservation 779,365 89,325 553,103 226,262 70.97%565,331 12,228 97.84% CC0547 Business System Services - - - - 0.00%- - 0.00% CC0637 Economic Development 593,007 63,238 570,646 22,361 96.23%575,708 5,062 99.12% CC0639 Human Resources 1,507,953 174,281 1,484,953 23,001 98.47%1,481,634 (3,319) 100.22% CC0640 Citywide Human Resources 1,219,444 116,343 1,082,035 137,409 88.73%1,127,024 44,988 96.01% CC0654 Legal 1,055,716 163,694 1,126,034 (70,318) 106.66%1,037,349 (88,685) 108.55% Expense Total 18,698,974 2,050,661 18,040,964 658,011 96.48%18,301,604 260,640 98.58% Excess (Deficiency) of Total Revenue over Total Requirements (524,058) (551,411) 245,779 769,837 -46.90%(182,400) 428,179 -134.75% Ending Fund Balance 1,633,307 2,403,144 769,837 147.13%1,974,965 428,179 121.68% Reserves Contingency Reserve 1,633,307 1,633,307 0 100.00%1,633,307 - 100.00% Reserves Total 1,633,307 1,633,307 0 100.00%1,633,307 - 100.00% Available Fund Balance - 769,837 769,837 0.00%341,658 428,179 225.32% Year-to-Date Actuals Budget Vs. Actuals Year-End: Projections Vs. Actuals 33 Council Discretionary Period: Sep-21 Budget Current Period FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance Fav/(Unfav)% of Projection Beginning Fund Balance 110,483 110,483 - 100.00%110,966 (483) 100.44% Revenue 42001:Interest Income 500 0 122 (378) 24.31%162 (41) 74.83% 70001:Transfers In - - - - 0.00%4,700,000 (4,700,000) 0.00% Total Revenue 500 0 122 (378) 24.31%4,700,162 (4,700,041) 0.00% Expense Transfers 110,983 - 110,983 - 100.00%110,983 - 100.00% Total Expense 110,983 - 110,983 - 100.00%110,983 - 100.00% Excess (Deficiency) of Total Revenue over Total Requirements (110,483) 0 (110,861) (378) 100.34%4,589,179 (4,700,041) -2.42% Ending Fund Balance - 0 (378) (378) 0.00%4,700,145 (4,700,524) -0.01% Reserves AFR Adjustment - - - - - - 0.00% Contingency Reserve - - - - - - 0.00% Debt Service Reserve - - - - - - 0.00% Reserves Total - - - - - - 0.00% Available Fund Balance - (378) (378) - 4,700,145 (4,700,524) -0.01% Year-End: Projections Vs. ActualsYear-to-Date Actuals Budget Vs. Actuals 34 Tourism Period: Sep-21 Budget Current Period FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance Fav/(Unfav)% of Projection Beginning Fund Balance 1,282,917 1,282,917 - 100.00%1,675,963 (393,046) 130.64% Revenue 40008:Other Taxes 900,000 301,775 1,247,146 347,146 138.57%850,000 397,146 146.72% 42001:Interest Income 5,000 184 5,057 57 101.15%5,000 57 101.14% 45001:Misc Revenue 95,000 13,230 40,531 (54,469) 42.66%39,850 682 101.71% 45003:Misc Reimbursements - - - - 0.00%- - 0.00% 44001:Grant Revenue - - 4,200 4,200 0.00%- 4,200 0.00% 44504:Donations - - - - 0.00%- - 0.00% 44505:Sponsorship 50,000 - - (50,000) 0.00%5,000 (5,000) 0.00% Total Revenue 1,050,000 315,189 1,296,934 246,934 123.52%899,850 397,084 144.13% Expense Personnel 435,456 64,875 358,771 76,685 82.39%355,688 (3,083) 100.87% Operations 1,014,085 161,469 683,827 330,258 67.43%919,987 236,160 74.33% Transfers 28,634 - 28,634 - 100.00%28,634 - 100.00% Total Expense 1,478,175 226,344 1,071,232 406,944 72.47%1,304,309 233,077 82.13% Excess (Deficiency) of Total Revenue over Total Requirements (428,175) 88,845 225,702 653,878 -52.71%(404,459) 630,161 -55.80% Ending Fund Balance 854,742 88,845 1,508,619 653,878 151.05%1,271,504 237,115 118.65% Reserves AFR Adjustment - - - 0.00%- - 0.00% Contingency Reserve 305,771 305,771 - 100.00%305,771 - 100.00% Reserves Total 305,771 305,771 - 100.00%305,771 - 100.00% Available Fund Balance 548,971 1,202,848 653,878 219.11%965,733 237,115 124.55% Year-End: Projections Vs. ActualsYear-to-Date Actuals Budget Vs. Actuals 35 Airport Operations Period: Sep-21 Budget Current Period FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance Fav/(Unfav)% of Projection Beginning Fund Balance 1,463,499 1,463,499 - 100.00%1,463,499 - 100.00% Operating Revenues 40001:Property Taxes 40,000 59,423 59,423 19,423 148.56%57,000 2,423 104.25% 42001:Interest Income 3,000 179 4,082 1,082 136.08%3,129 953 130.47% 43606:Airport Charges 3,908,500 408,263 3,908,279 (221) 99.99%3,754,800 153,479 104.09% Total Operating Revenues 3,951,500 467,866 3,971,785 20,285 100.51%3,814,930 156,855 104.11% Operating Expenses Personnel 464,472 57,447 447,529 16,943 96.35%465,860 18,331 96.07% Operations 3,559,192 439,871 3,177,144 382,048 89.27%3,416,469 239,325 92.99% Operating Capital 404,067 80,724 100,563 303,504 24.89%105,255 4,692 95.54% Total Operating Expenses 4,427,731 578,041 3,725,236 702,495 84.13%3,987,583 262,347 93.42% Non-Operating Revenues 45001:Misc Revenue 5,000 - 2,250 (2,750) 45.00%1,000 1,250 225.00% 44001:Grant Revenue - 50,000 206,980 206,980 0.00%157,000 49,980 131.83% 46001:Bond Proceeds 700,000 - 650,000 (50,000) 92.86%650,000 - 100.00% 46002:Bond Premium - - 64,186 64,186 0.00%64,186 0 100.00% Total Non-Operating Revenues 705,000 50,000 923,417 218,417 130.98%872,186 51,231 105.87% Non-Operating Expenses CIP Expense 750,000 - - 750,000 0.00%750,000 750,000 0.00% Debt Service 158,931 (179) 147,341 11,590 92.71%158,931 11,590 92.71% Total Non-Operating Expenses 908,931 (179) 147,341 761,590 16.21%908,931 761,590 16.21% Excess (Deficiency) of Total Revenue over Total Requirements (680,162) (59,996) 1,022,625 1,702,786 -150.35%(209,398) 1,232,023 -488.36% Ending Fund Balance 783,337 (59,996) 2,486,124 1,702,786 317.38%1,254,101 1,232,023 198.24% Reserves AFR Adjustment - - - 0.00%- - 0.00% Contingency Reserve 332,917 332,917 - 100.00%332,917 - 100.00% Reserves for Debt Service 141,478 141,478 - 100.00%184,099 42,621 76.85% Reserves Total 474,395 474,395 - 100.00%517,016 42,621 91.76% Available Fund Balance 308,942 2,011,729 1,702,786 651.17%737,085 1,274,644 272.93% Year-End: Projections Vs. ActualsYear-to-Date Actuals Budget Vs. Actuals 36 Stormwater Services Period: Sep-21 Budget Current Period FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance % of Projection Beginning Fund Balance 3,478,178 3,478,178 - 100.00%3,478,178 - 100.00% Operating Revenues 41002:Penalties - 5,187 44,537 44,537 0.00%35,000 9,536 127.25% 42001:Interest Income 10,000 330 9,516 (484) 95.16%7,591 1,925 125.35% 43605:Stormwater Charges 3,820,000 340,579 4,164,869 344,869 109.03%3,833,100 331,769 108.66% Total Operating Revenues 3,830,000 346,096 4,218,922 388,922 110.15%3,875,692 343,230 108.86% Operating Expenses Personnel 626,032 64,260 549,478 76,554 87.77%599,666 50,187 91.63% Operations 1,960,720 212,634 1,839,411 121,309 93.81%1,874,552 35,142 98.13% Operating Capital 11,429 2 505 10,924 4.42%47,848 47,343 1.06% Transfers 301,000 24,204 315,557 (14,557) 104.84%305,767 9,790 103.20% Total Operating Expenses 2,899,181 301,100 2,704,951 194,230 93.30%2,827,833 122,882 95.65% Available Operating Funds 930,819 44,996 1,513,971 583,152 162.65%1,047,859 466,112 144.48% Non-Operating Revenues 45001:Misc Revenue 21,000 - - (21,000) 0.00%- - 0.00% 45004:Sale of Property - - - - 0.00%- - 0.00% 44001:Grant Revenue - - - - 0.00%- - 0.00% 46001:Bond Proceeds - - - - 0.00%- - 0.00% Total Non-Operating Revenues 21,000 - - (21,000) 0.00%- - 0.00% Non-Operating Expenses CIP Expense 1,722,749 137,087 381,902 1,340,847 22.17%1,722,749 1,340,847 22.17% Debt Service 501,360 - 485,441 15,919 96.82%501,360 15,920 96.82% Total Non-Operating Expenses 2,224,109 137,087 867,342 1,356,767 39.00%2,224,109 1,356,767 39.00% Excess (Deficiency) of Total Revenue over Total Requirements (1,272,290) (92,091) 646,628 1,918,918 -50.82%(1,176,251) 1,822,879 -54.97% Ending Fund Balance 2,205,888 (92,091) 4,124,806 1,918,918 186.99%2,301,927 1,822,879 179.19% Reserves AFR Adjustment - - - 0.00%- - 0.00% Contingency Reserve 389,470 389,470 - 100.00%389,470 - 100.00% Debt Service Reserve 480,662 480,662 - 100.00%480,662 - 100.00% Reserves Total 870,132 870,132 - 100.00%870,132 - 100.00% Available Fund Balance 1,335,756 3,254,674 1,918,918 243.66%1,431,795 1,822,879 227.31% Year-End: Projections Vs. ActualsYear-to-Date Actuals Budget Vs. Actuals 37 GTEC Period: Sep-21 Budget Current Period FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance Fav/(Unfav)% of Projection Beginning Fund Balance 31,029,698 31,029,698 - 100.00%31,029,698 - 100.00% Operating Revenue 40002:Sales Taxes 8,255,000 2,813,103 10,618,823 2,363,823 128.64%10,187,500 431,323 104.23% 42001:Interest Income 60,000 1,081 25,704 (34,296) 42.84%24,544 1,161 104.73% Operating Revenue Total 8,315,000 2,814,184 10,644,527 2,329,527 128.02%10,212,044 432,484 104.24% Operating Expense Operations 402,962 33,514 346,223 56,739 85.92%402,190 55,967 86.08% Operating Capital - - - - 0.00%0 0 0.00% Transfers 2,763,242 - 2,758,343 4,899 99.82%2,763,242 4,899 99.82% Operating Expense Total 3,166,204 33,514 3,104,567 61,637 98.05%3,165,433 60,866 98.08% Net Operations Total 5,148,796 2,780,671 7,539,961 2,267,890 146.44%7,046,611 371,618 107.00% Non-Operating Revenue 46001:Bond Proceeds 8,000,000 - 7,405,000 (595,000) 92.56%7,405,000 - 0.00% 46002:Bond Premium - - 731,229 731,229 0.00%731,229 (0) 0.00% Non-Operating Revenue Total 8,000,000 - 8,136,229 136,229 101.70%8,136,229 (0) 0.00% Non-Operating Expense Operations 1,984,375 - - 1,984,375 0.00%1,984,375 (1,984,375) -100.00% CIP Expense 20,476,813 (832,504) 4,027,459 16,449,354 19.67%20,476,813 (16,449,354) -80.33% Debt Service 1,053,050 (2,040) 883,535 169,515 83.90%1,053,050 (169,515) -16.10% Non-Operating Expense Total 23,514,238 (834,544) 4,910,994 18,603,244 20.89%23,514,238 (18,603,244) -79.11% Excess (Deficiency) of Total Revenue over Total Requirements (10,365,442) (7,232,752) 6,329,801 16,695,243 -61.07%(12,212,576) 18,542,377 -51.83% Ending Fund Balance 20,664,256 41,794,893 21,130,638 202.26%22,698,300 19,096,593 184.13% Reserves AFR Adjustment - - - 0.00%- - 0.00% Contingency Reserve 1,984,375 1,984,375 - 100.00%1,984,375 - 100.00% Debt Service Reserve 3,494,232 3,494,232 - 100.00%3,494,232 - 100.00% Reserves Total 5,478,607 5,478,607 - 100.00%5,478,607 - 100.00% Available Fund Balance 15,185,649 36,316,286 21,130,638 239.15%17,219,693 19,096,593 210.90% Year-End: Projections Vs. ActualsYear-to-Date Actuals Budget Vs. Actuals 38 GEDCO Period: Sep-21 Budget Current Period FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance Fav/(Unfav)% of Projection Beginning Fund Balance 8,845,777 8,845,777 - 100.00%5,740,067 3,105,710 64.89% Revenue 40002:Sales Taxes 2,063,750 703,276 2,654,706 590,956 128.64%2,546,875 107,831 104.23% 42001:Interest Income 19,000 218 24,863 5,863 130.86%25,000 (137) 99.45% Total Revenue 2,082,750 703,493 2,679,569 596,819 128.66%2,571,875 107,694 104.19% Expense Operations 8,850,174 46,960 803,071 8,047,103 9.07%6,028,476 5,225,405 13.32% Debt Service 90,572 - - 90,572 0.00%90,572 90,572 0.00% Transfers 1,200,169 - 1,200,284 (115) 100.01%1,200,169 (114) 100.01% Total Expense 10,140,915 46,960 2,003,355 8,137,560 19.76%7,319,217 5,315,862 27.37% Excess (Deficiency) of Total Revenue over Total Requirements (8,058,165) 656,533 676,214 8,734,379 -8.39%(4,747,342) 5,423,556 -14.24% Ending Fund Balance 787,612 656,533 9,521,991 (7,540,741) 1208.97%992,725 (8,529,266) 959.18% Reserves AFR Adjustment - - - 0.00%- - 0.00% Contingency Reserve 505,468 505,468 - 100.00%505,468 - 100.00% Debt Service Reserve 202,769 202,769 - 100.00%202,769 - 100.00% Reserves Total 708,237 708,237 - 100.00%708,237 - 100.00% Available Fund Balance 79,375 8,813,754 8,734,379 11103.94%284,488 8,529,266 3098.12% Year-End: Projections Vs. ActualsYear-to-Date Actuals Budget Vs. Actuals 39 CITY QUARTERLY INVESTMENT REPORT For the Quarter Ended September 30, 2021 Prepared by Valley View Consulting, L.L.C. ________________________________________________________________________ Leigh Wallace Nathan Parras Finance Director Assistant Finance Director ________________________________________________________________________ Karrie Pursley Elaine Wilson Treasurer Assistant Finance Director The investment portfolio of the City of Georgetown is in compliance with the Public Funds Investment Act and the Investment Policy and Strategies. Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total return yields and do not account for investment advisor fees. 40 FYE Results by Investment Category: Asset Type Ave. Yield Book Value Market Value Ave. Yield Book Value Market Value Demand Accounts 0.26%9,505,298$ 9,505,298$ 0.22%22,970,725$ 22,970,725$ NOW/MMA 0.87%15,087,991 15,087,991 0.24%23,043,557 23,043,557 Pools 0.14%103,065,896 103,065,896 0.02%194,658,236 194,658,236 CDs/Securities 0.89%112,639,369 112,640,201 0.25%136,646,542 136,646,542 Totals 240,298,554$ 240,299,385$ 377,319,060$ 377,319,060$ Fourth Quarter-End Yield 0.54%0.13% Average Quarter-End Yields (1): 2021 Fiscal Year 2021 Fiscal Year Georgetown-City 1.15%0.21% Rolling Three Month Treasury 0.76%0.06% Rolling Six Month Treasury 0.99%0.08% TexPool 0.75%0.04% (1) Average Quarterly Yield calculated using quarter-end report average yield and adjusted book value. September 30, 2020 Annual Comparison of Portfolio Performance September 30, 2021 City of Georgetown Valley View Consulting, L.L.C.141 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield Demand Accounts 23,547,685$ 23,547,685 22,970,725$ 22,970,725$ 0.22% NOW/MMA 23,029,382 23,029,382 23,043,557 23,043,557 0.24% Pools 174,848,692 174,848,692 194,658,236 194,658,236 0.02% CDs/Securities 123,735,822 123,735,822 136,646,542 136,646,542 0.25%Totals 345,161,582$ 345,161,582$ 377,319,060$ 377,319,060$ 0.13% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 0.13%Total Portfolio 0.21% Rolling Three Month Treasury 0.05%Rolling Three Month Treasury 0.06% Rolling Six Month Treasury 0.05%Rolling Six Month Treasury 0.08% TexPool 0.03%TexPool 0.04% Bank Fees Offset 12,388$ Interest earnings provided in separate report.42,513$ June 30, 2021 (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 September 30, 2021 City of Georgetown Valley View Consulting, L.L.C.242 Economic Overview9/30/2021The Federal Open Market Committee (FOMC) maintained the Fed Funds target range at 0.00% to 0.25% (Effective Fed Funds are trading <0.10%), and projects that reduced rates could remain into 2023. Monthly government security purchases may begin tapering as early as Nov 2021. Second Quarter GDP posted +6.7% (Final). Employment recovery/growth has moderated, but job openings remain high. August Non-Farm Payroll only added 194k net new jobs. Crude oil bounced up to +/-$77 per barrel, with fuel shortages in England and other countries. The Stock Markets reached new highs, but have retrenched slightly. Housing, Industrial Production, Durable Goods, Consumer Spending, and other indicators remain positive but constrained. The Biden administration and Congress continue to negotiate infrastructure, fiscal and debt limit packages. Inflation remained over the FOMC 2+% target and may not be as temporary as initially projected. The Yield Curve rose slightly from two years to ten years.02505007501,0001,2501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,0004,2504,5004,750S&P 5000.000.501.001.502.002.503.003.50US Treasury Historical Yields - Since Nov 2015Six Month T-BillTwo Year T-NoteTen Year T-Note0.000.200.400.600.801.001.201.401.60Treasury Yield CurvesSeptember 30, 2020June 30, 2021September 30, 20210.000.501.001.502.002.503.003.504.004.505.005.506.00US Treasury Historical Yields - Since 2006Six Month T-BillTwo Year T-NoteTen Year T-NoteValley View Consulting, L.L.C.343 City - Investment HoldingsCoupon/ Maturity Settlement Face Amount/ Book Market Market Life Description Ratings Discount Date Date Par ValueValue PriceValue (Day) YieldJPMorgan Chase Cash (3)0.22% 10/01/21 09/30/21 22,970,725$ 22,970,725$ 1.00 22,970,725$ 1 0.22%JPMorgan Chase MMA0.03% 10/01/21 09/30/21 434,113 434,113 1.00 434,113 1 0.03%Veritex Community Bank MMA0.08% 10/01/21 09/30/21 3,214,573 3,214,573 1.00 3,214,573 1 0.08%NexBank MMA0.40% 10/01/21 09/30/21 7,387,900 7,387,900 1.00 7,387,900 1 0.40%Texas Capital Bank MMA0.20% 10/01/21 09/30/21 12,006,970 12,006,970 1.00 12,006,970 1 0.20%TexPoolAAAm 0.03%10/01/21 09/30/21 66,870,729 66,870,729 1.00 66,870,729 1 0.03%TexSTARAAAm 0.01%10/01/21 09/30/21 127,787,508 127,787,508 1.00 127,787,508 1 0.01% East West Bank CD 0.21% 10/08/21 01/08/21 5,007,658 5,007,658 100.00 5,007,658 8 0.21%Prosperity Bank CD 0.30% 10/14/21 10/14/20 2,506,888 2,506,888 100.00 2,506,888 14 0.30%Independent Bank CD 0.40% 10/18/21 10/18/20 2,554,218 2,554,218 100.00 2,554,218 18 0.40%Prosperity Bank CD 0.30% 11/22/21 11/20/20 3,007,501 3,007,501 100.00 3,007,501 53 0.30%Texas Regional Bank CD 0.25% 12/07/21 03/12/21 3,003,782 3,003,782 100.00 3,003,782 68 0.25%East West Bank CD 0.21% 12/30/21 12/30/20 3,004,750 3,004,750 100.00 3,004,750 91 0.21%East West Bank CD 0.21% 01/07/22 01/08/21 5,007,658 5,007,658 100.00 5,007,658 99 0.21%Prosperity Bank CD 0.30% 01/21/22 10/21/20 4,011,021 4,011,021 100.00 4,011,021 113 0.30%East West Bank CD 0.10% 02/01/22 05/10/21 2,000,789 2,000,789 100.00 2,000,789 124 0.10%Independent Bank CD 0.40% 02/05/22 02/05/21 3,005,933 3,005,933 100.00 3,005,933 128 0.40%Independent Bank CD 0.40% 02/08/22 02/08/21 5,009,868 5,009,868 100.00 5,009,868 131 0.40%Prosperity Bank CD 0.15% 02/10/22 08/10/21 3,002,615 3,002,615 100.00 3,002,615 133 0.15%R Bank CD 0.63% 02/25/22 02/25/21 2,006,258 2,006,258 100.00 2,006,258 148 0.63%Prosperity Bank CD 0.15% 03/21/22 09/21/21 5,000,000 5,000,000 100.00 5,000,000 172 0.15%Prosperity Bank CD 0.35% 04/21/22 10/21/20 2,508,038 2,508,038 100.00 2,508,038 203 0.35%Independent Bank CD 0.30% 04/22/22 04/22/21 4,215,000 4,215,000 100.00 4,215,000 204 0.30%Independent Bank CD 0.35% 05/09/22 02/08/21 4,006,945 4,006,945 100.00 4,006,945 221 0.35%Prosperity Bank CD0.35% 05/17/22 11/17/20 2,005,835 2,005,835 100.00 2,005,835 229 0.35%Prosperity Bank CD0.20% 06/13/22 06/11/21 5,002,521 5,002,521 100.00 5,002,521 256 0.20%Prosperity Bank CD0.20% 07/01/22 07/01/21 4,025,388 4,025,388 100.00 4,025,388 274 0.20%Prosperity Bank CD0.20% 07/25/22 04/23/21 5,004,193 5,004,193 100.00 5,004,193 298 0.20%Prosperity Bank CD0.20% 08/01/22 05/25/21 5,003,371 5,003,371 100.00 5,003,371 305 0.20%Prosperity Bank CD0.35% 08/22/22 11/20/20 2,507,294 2,507,294 100.00 2,507,294 326 0.35%Prosperity Bank CD0.20% 09/12/22 06/11/21 5,002,521 5,002,521 100.00 5,002,521 347 0.20%Prosperity Bank CD0.20% 10/24/22 04/23/21 5,004,193 5,004,193 100.00 5,004,193 389 0.20%Prosperity Bank CD0.40% 11/17/22 11/17/20 2,006,670 2,006,670 100.00 2,006,670 413 0.40%Prosperity Bank CD0.15% 11/23/22 08/23/21 2,000,255 2,000,255 100.00 2,000,255 419 0.15%Prosperity Bank CD0.15% 12/21/22 09/21/21 5,000,000 5,000,000 100.00 5,000,000 447 0.15%R Bank CD0.60% 12/31/22 06/30/21 1,001,530 1,001,530 100.00 1,001,530 457 0.60%September 30, 2021City of GeorgetownValley View Consulting, L.L.C.444 City - Investment HoldingsCoupon/ Maturity Settlement Face Amount/ Book Market Market Life Description Ratings Discount Date Date Par ValueValue PriceValue (Day) YieldSeptember 30, 2021Bank OZK CD0.18% 02/23/23 08/23/21 4,200,646 4,200,646 100.00 4,200,646 511 0.18%Veritex Community Bank CD 0.18% 03/09/23 09/09/21 4,000,000 4,000,000 100.00 4,000,000 525 0.18%Prosperity Bank CD0.20% 04/24/23 04/23/21 5,004,193 5,004,193 100.00 5,004,193 571 0.20%Prosperity Bank CD0.20% 05/01/23 05/25/21 5,003,371 5,003,371 100.00 5,003,371 578 0.20%Bank OZK CD0.20% 06/12/23 06/11/21 5,013,797 5,013,797 100.00 5,013,797 620 0.20%R Bank CD0.73% 06/30/23 06/30/21 1,001,842 1,001,842 100.00 1,001,842 638 0.73%Veritex Community Bank CD 0.25% 09/25/23 09/24/21 10,000,000 10,000,000 100.00 10,000,000 725 0.25%TOTALS377,319,060$ 377,319,060$ 377,319,060$ 113 0.13%(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 GeorgetownValley View Consulting, L.L.C.545 0–6 Months82% 6–12 Months11% 12–18 Months7% Current Quarter Maturities $0 $25,000,000 $50,000,000 $75,000,000 $100,000,000 $125,000,000 $150,000,000 $175,000,000 $200,000,000 $225,000,000 $250,000,000 $275,000,000 $300,000,000 $325,000,000 $350,000,000 $375,000,000 12/31/20 03/31/21 06/30/21 09/30/21 Portfolio Balances Money Market Local Depository TexSTAR TexPool Certificate of Deposit US Treasury 166174166 102 69 90 7375 109104 123 156163 97108 87 51 67 4941 91 73 6154 99 71 124 95100 8070676358 818274 104113 0 50 100 150 200 # of DaysWeighted Average to Maturity JPMorgan Chase6% Texas Capital Bank3% Prosperity Bank19% Veritex Bank 5% Bank OZK2% NexBank2%TexPool18% TexSTAR34% IndependentBank5% Texas Regional Bank1% East West Bank4% R Bank1% Portfolio Holdings by Issuer City of Georgetown Valley View Consulting, L.L.C. 646 City - Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 06/30/21 Increases Decreases Book Value 09/30/21 Market Value 06/30/21 Change in Market Value Market Value 09/30/21 JPMorgan Chase Cash 0.22%10/01/21 23,547,685$ –$ (576,960)$ 22,970,725$ 23,547,685$ (576,960)$ 22,970,725$ JPMorgan Chase MMA 0.03%10/01/21 434,080 33 – 434,113 434,080 33 434,113 Veritex Community Bank M 0.08%10/01/21 3,213,925 648 – 3,214,573 3,213,925 648 3,214,573 NexBank MMA 0.40%10/01/21 7,380,457 7,444 – 7,387,900 7,380,457 7,444 7,387,900 Texas Capital Bank MMA 0.20%10/01/21 12,000,920 6,050 – 12,006,970 12,000,920 6,050 12,006,970 TexPool 0.03%10/01/21 57,019,665 9,851,064 – 66,870,729 57,019,665 9,851,064 66,870,729 TexSTAR 0.01%10/01/21 117,829,027 9,958,481 – 127,787,508 117,829,027 9,958,481 127,787,508 Prosperity Bank CD 0.60%07/01/21 4,018,010 – (4,018,010) – 4,018,010 (4,018,010) – Prosperity Bank CD 0.70%07/15/21 5,026,275 – (5,026,275) – 5,026,275 (5,026,275) – Prosperity Bank CD 0.15%08/10/21 3,001,480 – (3,001,480) – 3,001,480 (3,001,480) – Prosperity Bank CD 0.40%08/23/21 6,263,799 – (6,263,799) – 6,263,799 (6,263,799) – R Bank CD 0.47%08/25/21 2,002,293 – (2,002,293) – 2,002,293 (2,002,293) – East West Bank CD 0.26%09/09/21 4,075,095 – (4,075,095) – 4,075,095 (4,075,095) – East West Bank CD 0.21%10/08/21 5,005,008 2,650 – 5,007,658 5,005,008 2,650 5,007,658 Prosperity Bank CD 0.30%10/14/21 2,504,993 1,895 – 2,506,888 2,504,993 1,895 2,506,888 Independent Bank CD 0.40%10/18/21 2,551,673 2,545 – 2,554,218 2,551,673 2,545 2,554,218 Prosperity Bank CD 0.30%11/22/21 3,005,228 2,273 – 3,007,501 3,005,228 2,273 3,007,501 Texas Regional Bank CD 0.25%12/07/21 3,001,890 1,892 – 3,003,782 3,001,890 1,892 3,003,782 East West Bank CD 0.21%12/30/21 3,003,160 1,590 – 3,004,750 3,003,160 1,590 3,004,750 East West Bank CD 0.21%01/07/22 5,005,008 2,650 – 5,007,658 5,005,008 2,650 5,007,658 Prosperity Bank CD 0.30%01/21/22 4,007,990 3,031 – 4,011,021 4,007,990 3,031 4,011,021 East West Bank CD 0.10%02/01/22 2,000,285 504 – 2,000,789 2,000,285 504 2,000,789 Independent Bank CD 0.40%02/05/22 3,002,905 3,028 – 3,005,933 3,002,905 3,028 3,005,933 Independent Bank CD 0.40%02/08/22 5,004,822 5,046 – 5,009,868 5,004,822 5,046 5,009,868 Prosperity Bank CD 0.15%02/10/22 – 3,002,615 – 3,002,615 – 3,002,615 3,002,615 R Bank CD 0.63%02/25/22 2,003,075 3,183 – 2,006,258 2,003,075 3,183 2,006,258 Prosperity Bank CD 0.15%03/21/22 – 5,000,000 – 5,000,000 – 5,000,000 5,000,000 Prosperity Bank CD 0.35%04/21/22 2,505,827 2,211 – 2,508,038 2,505,827 2,211 2,508,038 Independent Bank CD 0.30%04/22/22 4,211,849 3,150 – 4,215,000 4,211,849 3,150 4,215,000 Independent Bank CD 0.35%05/09/22 4,003,414 3,532 – 4,006,945 4,003,414 3,532 4,006,945 Prosperity Bank CD 0.35%05/17/22 2,004,067 1,768 – 2,005,835 2,004,067 1,768 2,005,835 Prosperity Bank CD 0.20%06/13/22 5,000,000 2,521 – 5,002,521 5,000,000 2,521 5,002,521 Prosperity Bank CD 0.20%07/01/22 – 4,025,388 – 4,025,388 – 4,025,388 4,025,388 Prosperity Bank CD 0.20%07/25/22 5,001,671 2,522 – 5,004,193 5,001,671 2,522 5,004,193 Prosperity Bank CD 0.20%08/01/22 5,000,849 2,521 – 5,003,371 5,000,849 2,521 5,003,371 Prosperity Bank CD 0.35%08/22/22 2,505,084 2,211 – 2,507,294 2,505,084 2,211 2,507,294 Prosperity Bank CD 0.20%09/12/22 5,000,000 2,521 – 5,002,521 5,000,000 2,521 5,002,521 Prosperity Bank CD 0.20%10/24/22 5,001,671 2,522 – 5,004,193 5,001,671 2,522 5,004,193 Prosperity Bank CD 0.40%11/17/22 2,004,649 2,022 – 2,006,670 2,004,649 2,022 2,006,670 City of Georgetown Valley View Consulting, L.L.C.747 City - Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 06/30/21 Increases Decreases Book Value 09/30/21 Market Value 06/30/21 Change in Market Value Market Value 09/30/21 Prosperity Bank CD 0.15%11/23/22 – 2,000,255 – 2,000,255 – 2,000,255 2,000,255 Prosperity Bank CD 0.15%12/21/22 – 5,000,000 – 5,000,000 – 5,000,000 5,000,000 R Bank CD 0.60%12/31/22 1,000,000 1,530 – 1,001,530 1,000,000 1,530 1,001,530 Bank OZK CD 0.18%02/23/23 – 4,200,646 – 4,200,646 – 4,200,646 4,200,646 Veritex Community Bank C 0.18%03/09/23 – 4,000,000 – 4,000,000 – 4,000,000 4,000,000 Prosperity Bank CD 0.20%04/24/23 5,001,671 2,522 – 5,004,193 5,001,671 2,522 5,004,193 Prosperity Bank CD 0.20%05/01/23 5,000,849 2,521 – 5,003,371 5,000,849 2,521 5,003,371 Bank OZK CD 0.20%06/12/23 5,011,230 2,567 – 5,013,797 5,011,230 2,567 5,013,797 R Bank CD 0.73%06/30/23 1,000,000 1,842 – 1,001,842 1,000,000 1,842 1,001,842 Veritex Community Bank C 0.25%09/25/23 – 10,000,000 – 10,000,000 – 10,000,000 10,000,000 TOTAL / AVERAGE 0.13%345,161,582$ 57,121,391$ (24,963,913)$ 377,319,060$ 345,161,582$ 32,157,478$ 377,319,060$ City of Georgetown Valley View Consulting, L.L.C.848 City - Allocation Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Streets/ Vehicles 2015 CO- Stormwater 2015 GO- Roads 2015 Revenue Water WW 2016 CO- Streets/ Facilities/ Equip JPMorgan Chase Cash 22,970,725$ 22,970,725$ –$ –$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 434,113 434,113 – – – – – – – Veritex Community Bank MMA 3,214,573 3,214,573 – – – – – – – NexBank MMA 7,387,900 7,387,900 – – – – – – – Texas Capital Bank MMA 12,006,970 12,006,970 – – – – – – – TexPool 66,870,729 66,870,729 – – – – – – – TexSTAR 127,787,508 20,259,237 493,387 2,003,757 137,314 19,522 2,055,756 1,531,919 - East West Bank CD 10/08/21 5,007,658 5,007,658 – – – – – – – Prosperity Bank CD 10/14/21 2,506,888 2,506,888 – – – – – – – Independent Bank CD 10/18/21 2,554,218 2,554,218 – – – – – – – Prosperity Bank CD 11/22/21 3,007,501 3,007,501 – – – – – – – Texas Regional Bank CD 12/07/21 3,003,782 – – – – – – – – East West Bank CD 12/30/21 3,004,750 3,004,750 – – – – – – – East West Bank CD 01/07/22 5,007,658 5,007,658 – – – – – – – Prosperity Bank CD 01/21/22 4,011,021 4,011,021 – – – – – – – East West Bank CD 02/01/22 2,000,789 – – – – – – – – Independent Bank CD 02/05/22 3,005,933 3,005,933 – – – – – – – Independent Bank CD 02/08/22 5,009,868 4,007,894 – – – – – – – Prosperity Bank CD 02/10/22 3,002,615 – – – – – – – – R Bank CD 02/25/22 2,006,258 – – – – – – – – Prosperity Bank CD 03/21/22 5,000,000 5,000,000 – – – – – – – Prosperity Bank CD 04/21/22 2,508,038 2,508,038 – – – – – – – Independent Bank CD 04/22/22 4,215,000 4,215,000 – – – – – – – Independent Bank CD 05/09/22 4,006,945 4,006,945 – – – – – – – Prosperity Bank CD 05/17/22 2,005,835 2,005,835 – – – – – – – Prosperity Bank CD 06/13/22 5,002,521 5,002,521 – – – – – – – Prosperity Bank CD 07/01/22 4,025,388 4,025,388 – – – – – – – Prosperity Bank CD 07/25/22 5,004,193 5,004,193 – – – – – – – Prosperity Bank CD 08/01/22 5,003,371 5,003,371 – – – – – – – Prosperity Bank CD 08/22/22 2,507,294 2,507,294 – – – – – – – Prosperity Bank CD 09/12/22 5,002,521 5,002,521 – – – – – – – Prosperity Bank CD 10/24/22 5,004,193 5,004,193 – – – – – – – Prosperity Bank CD 11/17/22 2,006,670 2,006,670 – – – – – – – Prosperity Bank CD 11/23/22 2,000,255 2,000,255 – – – – – – – Prosperity Bank CD 12/21/22 5,000,000 5,000,000 – – – – – – – R Bank CD 12/31/22 1,001,530 1,001,530 – – – – – – – Bank OZK CD 02/23/23 4,200,646 4,200,646 – – – – – – – Veritex Community Bank CD 03/09/23 4,000,000 4,000,000 – – – – – – – Prosperity Bank CD 04/24/23 5,004,193 5,004,193 – – – – – – – Prosperity Bank CD 05/01/23 5,003,371 5,003,371 – – – – – – – Bank OZK CD 06/12/23 5,013,797 5,013,797 – – – – – – – R Bank CD 06/30/23 1,001,842 1,001,842 – – – – – – – Veritex Community Bank CD 09/25/23 10,000,000 10,000,000 Totals 377,319,060$ 258,775,372$ 493,387$ 2,003,757$ 137,314$ 19,522$ 2,055,756$ 1,531,919$ –$ Book Value September 30, 2021 City of Georgetown Valley View Consulting, L.L.C.949 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Veritex Community Bank MMA NexBank MMA Texas Capital Bank MMA TexPool TexSTAR East West Bank CD 10/08/21 Prosperity Bank CD 10/14/21 Independent Bank CD 10/18/21 Prosperity Bank CD 11/22/21 Texas Regional Bank CD 12/07/21 East West Bank CD 12/30/21 East West Bank CD 01/07/22 Prosperity Bank CD 01/21/22 East West Bank CD 02/01/22 Independent Bank CD 02/05/22 Independent Bank CD 02/08/22 Prosperity Bank CD 02/10/22 R Bank CD 02/25/22 Prosperity Bank CD 03/21/22 Prosperity Bank CD 04/21/22 Independent Bank CD 04/22/22 Independent Bank CD 05/09/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 06/13/22 Prosperity Bank CD 07/01/22 Prosperity Bank CD 07/25/22 Prosperity Bank CD 08/01/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 09/12/22 Prosperity Bank CD 10/24/22 Prosperity Bank CD 11/17/22 Prosperity Bank CD 11/23/22 Prosperity Bank CD 12/21/22 R Bank CD 12/31/22 Bank OZK CD 02/23/23 Veritex Community Bank CD 03/09/23 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Bank OZK CD 06/12/23 R Bank CD 06/30/23 Veritex Community Bank CD 09/25/23 Totals Book Value September 30, 2021 (Continued) 2016 GO- Roads 2016 Revenue Water/WW Garey Park Donation 2017 CO Facilities/ Public Safety/ Equipment 2017 Revenue Electric 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Parks –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,416,150 270,991 246,578 53,200 97,389 4,761,278 56,703 576,846 349,300 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 3,003,782 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,001,974 – – – – – – – – 3,002,615 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,416,150$ 270,991$ 246,578$ 53,200$ 97,389$ 11,769,648$ 56,703$ 576,846$ 349,300$ City of Georgetown Valley View Consulting, L.L.C.1050 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Veritex Community Bank MMA NexBank MMA Texas Capital Bank MMA TexPool TexSTAR East West Bank CD 10/08/21 Prosperity Bank CD 10/14/21 Independent Bank CD 10/18/21 Prosperity Bank CD 11/22/21 Texas Regional Bank CD 12/07/21 East West Bank CD 12/30/21 East West Bank CD 01/07/22 Prosperity Bank CD 01/21/22 East West Bank CD 02/01/22 Independent Bank CD 02/05/22 Independent Bank CD 02/08/22 Prosperity Bank CD 02/10/22 R Bank CD 02/25/22 Prosperity Bank CD 03/21/22 Prosperity Bank CD 04/21/22 Independent Bank CD 04/22/22 Independent Bank CD 05/09/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 06/13/22 Prosperity Bank CD 07/01/22 Prosperity Bank CD 07/25/22 Prosperity Bank CD 08/01/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 09/12/22 Prosperity Bank CD 10/24/22 Prosperity Bank CD 11/17/22 Prosperity Bank CD 11/23/22 Prosperity Bank CD 12/21/22 R Bank CD 12/31/22 Bank OZK CD 02/23/23 Veritex Community Bank CD 03/09/23 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Bank OZK CD 06/12/23 R Bank CD 06/30/23 Veritex Community Bank CD 09/25/23 Totals Book Value September 30, 2021 (Continued) 2018 GO- Roads 2019 CO- Streets/ Facilities/ Equip 2019 CO- Stormwater 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 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,926,217 6,518,325 – 822,100 1,600,026 488,674 5,402,091 1,646,143 4,156,465 700,025 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,000,789 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,006,258 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,926,217$ 6,518,325$ -$ 2,828,358$ 1,600,026$ 488,674$ 7,402,880$ 1,646,143$ 4,156,465$ 700,025$ City of Georgetown Valley View Consulting, L.L.C.1151 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Veritex Community Bank MMA NexBank MMA Texas Capital Bank MMA TexPool TexSTAR East West Bank CD 10/08/21 Prosperity Bank CD 10/14/21 Independent Bank CD 10/18/21 Prosperity Bank CD 11/22/21 Texas Regional Bank CD 12/07/21 East West Bank CD 12/30/21 East West Bank CD 01/07/22 Prosperity Bank CD 01/21/22 East West Bank CD 02/01/22 Independent Bank CD 02/05/22 Independent Bank CD 02/08/22 Prosperity Bank CD 02/10/22 R Bank CD 02/25/22 Prosperity Bank CD 03/21/22 Prosperity Bank CD 04/21/22 Independent Bank CD 04/22/22 Independent Bank CD 05/09/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 06/13/22 Prosperity Bank CD 07/01/22 Prosperity Bank CD 07/25/22 Prosperity Bank CD 08/01/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 09/12/22 Prosperity Bank CD 10/24/22 Prosperity Bank CD 11/17/22 Prosperity Bank CD 11/23/22 Prosperity Bank CD 12/21/22 R Bank CD 12/31/22 Bank OZK CD 02/23/23 Veritex Community Bank CD 03/09/23 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Bank OZK CD 06/12/23 R Bank CD 06/30/23 Veritex Community Bank CD 09/25/23 Totals Book Value September 30, 2021 (Continued) City - 2021 CO Fac/Equip/Par ks City - 2021 GO Parks City - 2021 GO Roads City - 2021A CO Electric City - 2021A CO Water/WW City - 2021A GO Roads City - American Rescue Plan –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 12,533,816 1,000,035 6,264,002 4,983,087 13,402,129 28,000,176 4,014,869 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 12,533,816$ 1,000,035$ 6,264,002$ 4,983,087$ 13,402,129$ 28,000,176$ 4,014,869$ City of Georgetown Valley View Consulting, L.L.C.1252 City - Allocation September 30, 2021 Market Value Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Streets/ Vehicles 2015 CO- Stormwater 2015 GO- Roads 2015 Revenue Water WW 2016 CO- Streets/ Facilities/ Equip JPMorgan Chase Cash 22,970,725$ 22,970,725$ –$ –$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 434,113 434,113 – – – – – – – Veritex Community Bank MMA 3,214,573 3,214,573 – – – – – – – NexBank MMA 7,387,900 7,387,900 – – – – – – – Texas Capital Bank MMA 12,006,970 12,006,970 – – – – – – – TexPool 66,870,729 66,870,729 – – – – – – – TexSTAR 127,787,508 20,259,237 493,387 2,003,757 137,314 19,522 2,055,756 1,531,919 - East West Bank CD 10/08/21 5,007,658 5,007,658 – – – – – – – Prosperity Bank CD 10/14/21 2,506,888 2,506,888 – – – – – – – Independent Bank CD 10/18/21 2,554,218 2,554,218 – – – – – – – Prosperity Bank CD 11/22/21 3,007,501 3,007,501 – – – – – – – Texas Regional Bank CD 12/07/21 3,003,782 – – – – – – – – East West Bank CD 12/30/21 3,004,750 3,004,750 – – – – – – – East West Bank CD 01/07/22 5,007,658 5,007,658 – – – – – – – Prosperity Bank CD 01/21/22 4,011,021 4,011,021 – – – – – – – East West Bank CD 02/01/22 2,000,789 – – – – – – – – Independent Bank CD 02/05/22 3,005,933 3,005,933 – – – – – – – Independent Bank CD 02/08/22 5,009,868 4,007,894 – – – – – – – Prosperity Bank CD 02/10/22 3,002,615 – – – – – – – – R Bank CD 02/25/22 2,006,258 – – – – – – – – Prosperity Bank CD 03/21/22 5,000,000 5,000,000 – – – – – – – Prosperity Bank CD 04/21/22 2,508,038 2,508,038 – – – – – – – Independent Bank CD 04/22/22 4,215,000 4,215,000 – – – – – – – Independent Bank CD 05/09/22 4,006,945 4,006,945 – – – – – – – Prosperity Bank CD 05/17/22 2,005,835 2,005,835 – – – – – – – Prosperity Bank CD 06/13/22 5,002,521 5,002,521 – – – – – – – Prosperity Bank CD 07/01/22 4,025,388 4,025,388 – – – – – – – Prosperity Bank CD 07/25/22 5,004,193 5,004,193 – – – – – – – Prosperity Bank CD 08/01/22 5,003,371 5,003,371 – – – – – – – Prosperity Bank CD 08/22/22 2,507,294 2,507,294 – – – – – – – Prosperity Bank CD 09/12/22 5,002,521 5,002,521 – – – – – – – Prosperity Bank CD 10/24/22 5,004,193 5,004,193 – – – – – – – Prosperity Bank CD 11/17/22 2,006,670 2,006,670 – – – – – – – Prosperity Bank CD 11/23/22 2,000,255 2,000,255 – – – – – – – Prosperity Bank CD 12/21/22 5,000,000 5,000,000 – – – – – – – R Bank CD 12/31/22 1,001,530 1,001,530 – – – – – – – Bank OZK CD 02/23/23 4,200,646 4,200,646 – – – – – – – Veritex Community Bank CD 03/09/23 4,000,000 4,000,000 – – – – – – – Prosperity Bank CD 04/24/23 5,004,193 5,004,193 – – – – – – – Prosperity Bank CD 05/01/23 5,003,371 5,003,371 – – – – – – – Bank OZK CD 06/12/23 5,013,797 5,013,797 – – – – – – – R Bank CD 06/30/23 1,001,842 1,001,842 – – – – – – – Veritex Community Bank CD 09/25/23 10,000,000 10,000,000 – – – – – – – Totals 377,319,060$ 258,775,372$ 493,387$ 2,003,757$ 137,314$ 19,522$ 2,055,756$ 1,531,919$ –$ City of Georgetown Valley View Consulting, L.L.C.1353 City - Allocation September 30, 2021 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Veritex Community Bank MMA NexBank MMA Texas Capital Bank MMA TexPool TexSTAR East West Bank CD 10/08/21 Prosperity Bank CD 10/14/21 Independent Bank CD 10/18/21 Prosperity Bank CD 11/22/21 Texas Regional Bank CD 12/07/21 East West Bank CD 12/30/21 East West Bank CD 01/07/22 Prosperity Bank CD 01/21/22 East West Bank CD 02/01/22 Independent Bank CD 02/05/22 Independent Bank CD 02/08/22 Prosperity Bank CD 02/10/22 R Bank CD 02/25/22 Prosperity Bank CD 03/21/22 Prosperity Bank CD 04/21/22 Independent Bank CD 04/22/22 Independent Bank CD 05/09/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 06/13/22 Prosperity Bank CD 07/01/22 Prosperity Bank CD 07/25/22 Prosperity Bank CD 08/01/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 09/12/22 Prosperity Bank CD 10/24/22 Prosperity Bank CD 11/17/22 Prosperity Bank CD 11/23/22 Prosperity Bank CD 12/21/22 R Bank CD 12/31/22 Bank OZK CD 02/23/23 Veritex Community Bank CD 03/09/23 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Bank OZK CD 06/12/23 R Bank CD 06/30/23 Veritex Community Bank CD 09/25/23 Totals (Continued) 2016 GO- Roads 2016 Revenue Water/WW Garey Park Donation 2017 CO Facilities/ Public Safety/ Equipment 2017 Revenue Electric 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Parks –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,416,150 270,991 246,578 53,200 97,389 4,761,278 56,703 576,846 349,300 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 3,003,782 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,001,974 – – – – – – – – 3,002,615 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,416,150$ 270,991$ 246,578$ 53,200$ 97,389$ 11,769,648$ 56,703$ 576,846$ 349,300$ City of Georgetown Valley View Consulting, L.L.C.1454 City - Allocation September 30, 2021 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Veritex Community Bank MMA NexBank MMA Texas Capital Bank MMA TexPool TexSTAR East West Bank CD 10/08/21 Prosperity Bank CD 10/14/21 Independent Bank CD 10/18/21 Prosperity Bank CD 11/22/21 Texas Regional Bank CD 12/07/21 East West Bank CD 12/30/21 East West Bank CD 01/07/22 Prosperity Bank CD 01/21/22 East West Bank CD 02/01/22 Independent Bank CD 02/05/22 Independent Bank CD 02/08/22 Prosperity Bank CD 02/10/22 R Bank CD 02/25/22 Prosperity Bank CD 03/21/22 Prosperity Bank CD 04/21/22 Independent Bank CD 04/22/22 Independent Bank CD 05/09/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 06/13/22 Prosperity Bank CD 07/01/22 Prosperity Bank CD 07/25/22 Prosperity Bank CD 08/01/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 09/12/22 Prosperity Bank CD 10/24/22 Prosperity Bank CD 11/17/22 Prosperity Bank CD 11/23/22 Prosperity Bank CD 12/21/22 R Bank CD 12/31/22 Bank OZK CD 02/23/23 Veritex Community Bank CD 03/09/23 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Bank OZK CD 06/12/23 R Bank CD 06/30/23 Veritex Community Bank CD 09/25/23 Totals (Continued) 2018 GO- Roads 2019 CO- Streets/ Facilities/ Equip 2019 CO- Stormwater 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 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,926,217 6,518,325 - 822,100 1,600,026 488,674 5,402,091 1,646,143 4,156,465 700,025 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,000,789 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,006,258 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,926,217$ 6,518,325$ –$ 2,828,358$ 1,600,026$ 488,674$ 7,402,880$ 1,646,143$ 4,156,465$ 700,025$ City of Georgetown Valley View Consulting, L.L.C.1555 City - Allocation September 30, 2021 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Veritex Community Bank MMA NexBank MMA Texas Capital Bank MMA TexPool TexSTAR East West Bank CD 10/08/21 Prosperity Bank CD 10/14/21 Independent Bank CD 10/18/21 Prosperity Bank CD 11/22/21 Texas Regional Bank CD 12/07/21 East West Bank CD 12/30/21 East West Bank CD 01/07/22 Prosperity Bank CD 01/21/22 East West Bank CD 02/01/22 Independent Bank CD 02/05/22 Independent Bank CD 02/08/22 Prosperity Bank CD 02/10/22 R Bank CD 02/25/22 Prosperity Bank CD 03/21/22 Prosperity Bank CD 04/21/22 Independent Bank CD 04/22/22 Independent Bank CD 05/09/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 06/13/22 Prosperity Bank CD 07/01/22 Prosperity Bank CD 07/25/22 Prosperity Bank CD 08/01/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 09/12/22 Prosperity Bank CD 10/24/22 Prosperity Bank CD 11/17/22 Prosperity Bank CD 11/23/22 Prosperity Bank CD 12/21/22 R Bank CD 12/31/22 Bank OZK CD 02/23/23 Veritex Community Bank CD 03/09/23 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Bank OZK CD 06/12/23 R Bank CD 06/30/23 Veritex Community Bank CD 09/25/23 Totals (Continued) City - 2021 CO Fac/Equip/Par ks City - 2021 GO Parks City - 2021 GO Roads City - 2021A CO Electric City - 2021A CO Water/WW City - 2021A GO Roads City - American Rescue Plan –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – 12,533,816 1,000,035 6,264,002 4,983,087 13,402,129 28,000,176 4,014,869 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 12,533,816$ 1,000,035$ 6,264,002$ 4,983,087$ 13,402,129$ 28,000,176$ 4,014,869$ City of Georgetown Valley View Consulting, L.L.C.1656 City - Allocation Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Streets/ Vehicles 2015 CO- Stormwater 2015 GO- Roads 2015 Revenue Water WW 2016 CO- Streets/ Facilities/ Equip JPMorgan Chase Cash 23,547,685$ 23,547,685$ –$ –$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 434,080 434,080 – – – – – – – Veritex Bank MMA 3,213,925 3,213,925 – – – – – – – NexBank MMA 7,380,457 7,380,457 – – – – – – – Texas Capital Bank MMA 12,000,920 12,000,920 – – – – – – – TexPool 57,019,665 57,019,665 – – – – – – – TexSTAR 117,829,027 12,317,440 501,925 17,705,596 137,311 41,309 2,508,904 1,531,881 67,908 Prosperity Bank CD 07/01/21 4,018,010 4,018,010 – – – – – – – Prosperity Bank CD 07/15/21 5,026,275 5,026,275 – – – – – – – Prosperity Bank CD 08/10/21 3,001,480 – – – – – – – – Prosperity Bank CD 08/23/21 6,263,799 6,263,799 – – – – – – – R Bank CD 08/25/21 2,002,293 – – – – – – – – East West Bank CD 09/09/21 4,075,095 4,075,095 – – – – – – – East West Bank CD 10/08/21 5,005,008 5,005,008 – – – – – – – Prosperity Bank CD 10/14/21 2,504,993 2,504,993 – – – – – – – Independent Bank CD 10/18/21 2,551,673 2,551,673 – – – – – – – Prosperity Bank CD 11/22/21 3,005,228 3,005,228 – – – – – – – Texas Regional Bank CD 12/07/21 3,001,890 – – – – – – – – East West Bank CD 12/30/21 3,003,160 3,003,160 – – – – – – – East West Bank CD 01/07/22 5,005,008 5,005,008 – – – – – – – Prosperity Bank CD 01/21/22 4,007,990 4,007,990 – – – – – – – East West Bank CD 02/01/22 2,000,285 – – – – – – – – Independent Bank CD 02/05/22 3,002,905 3,002,905 – – – – – – – Independent Bank CD 02/08/22 5,004,822 4,003,858 – – – – – – – R Bank CD 02/25/22 2,003,075 – – – – – – – – Prosperity Bank CD 04/21/22 2,505,827 2,505,827 – – – – – – – Independent Bank CD 04/22/22 4,211,849 4,211,849 – – – – – – – Independent Bank CD 05/09/22 4,003,414 4,003,414 – – – – – – – Prosperity Bank CD 05/17/22 2,004,067 2,004,067 – – – – – – – Prosperity Bank CD 06/13/22 5,000,000 5,000,000 – – – – – – – Prosperity Bank CD 07/25/22 5,001,671 5,001,671 – – – – – – – Prosperity Bank CD 08/01/22 5,000,849 5,000,849 – – – – – – – Prosperity Bank CD 08/22/22 2,505,084 2,505,084 – – – – – – – Prosperity Bank CD 09/12/22 5,000,000 5,000,000 – – – – – – – Prosperity Bank CD 10/24/22 5,001,671 5,001,671 – – – – – – – Prosperity Bank CD 11/17/22 2,004,649 2,004,649 – – – – – – – R Bank CD 12/31/22 1,000,000 1,000,000 – – – – – – – Prosperity Bank CD 04/24/23 5,001,671 5,001,671 – – – – – – – Prosperity Bank CD 05/01/23 5,000,849 5,000,849 – – – – – – – Bank OZK CD 06/12/23 5,011,230 5,011,230 – – – – – – – R Bank CD 06/30/23 1,000,000 1,000,000 – – – – – – – Totals 345,161,582$ 226,640,008$ 501,925$ 17,705,596$ 137,311$ 41,309$ 2,508,904$ 1,531,881$ 67,908$ June 30, 2021 Book Value City of Georgetown Valley View Consulting, L.L.C.1757 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Veritex Bank MMA NexBank MMA Texas Capital Bank MMA TexPool TexSTAR Prosperity Bank CD 07/01/21 Prosperity Bank CD 07/15/21 Prosperity Bank CD 08/10/21 Prosperity Bank CD 08/23/21 R Bank CD 08/25/21 East West Bank CD 09/09/21 East West Bank CD 10/08/21 Prosperity Bank CD 10/14/21 Independent Bank CD 10/18/21 Prosperity Bank CD 11/22/21 Texas Regional Bank CD 12/07/21 East West Bank CD 12/30/21 East West Bank CD 01/07/22 Prosperity Bank CD 01/21/22 East West Bank CD 02/01/22 Independent Bank CD 02/05/22 Independent Bank CD 02/08/22 R Bank CD 02/25/22 Prosperity Bank CD 04/21/22 Independent Bank CD 04/22/22 Independent Bank CD 05/09/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 06/13/22 Prosperity Bank CD 07/25/22 Prosperity Bank CD 08/01/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 09/12/22 Prosperity Bank CD 10/24/22 Prosperity Bank CD 11/17/22 R Bank CD 12/31/22 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Bank OZK CD 06/12/23 R Bank CD 06/30/23 Totals June 30, 2021 Book Value (Continued) 2016 GO- Roads 2016 Revenue Water/WW Garey Park Donation 2017 CO Facilities/ Public Safety/ Equipment 2017 Revenue Electric 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Parks –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,429,271 1,096,157 246,572 178,455 97,386 4,761,158 56,701 661,264 407,723 – – – – – – – – – – – – – – – – – – – – – – – 3,001,480 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 3,001,890 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,000,964 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,429,271$ 1,096,157$ 246,572$ 178,455$ 97,386$ 11,765,493$ 56,701$ 661,264$ 407,723$ City of Georgetown Valley View Consulting, L.L.C.1858 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Veritex Bank MMA NexBank MMA Texas Capital Bank MMA TexPool TexSTAR Prosperity Bank CD 07/01/21 Prosperity Bank CD 07/15/21 Prosperity Bank CD 08/10/21 Prosperity Bank CD 08/23/21 R Bank CD 08/25/21 East West Bank CD 09/09/21 East West Bank CD 10/08/21 Prosperity Bank CD 10/14/21 Independent Bank CD 10/18/21 Prosperity Bank CD 11/22/21 Texas Regional Bank CD 12/07/21 East West Bank CD 12/30/21 East West Bank CD 01/07/22 Prosperity Bank CD 01/21/22 East West Bank CD 02/01/22 Independent Bank CD 02/05/22 Independent Bank CD 02/08/22 R Bank CD 02/25/22 Prosperity Bank CD 04/21/22 Independent Bank CD 04/22/22 Independent Bank CD 05/09/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 06/13/22 Prosperity Bank CD 07/25/22 Prosperity Bank CD 08/01/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 09/12/22 Prosperity Bank CD 10/24/22 Prosperity Bank CD 11/17/22 R Bank CD 12/31/22 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Bank OZK CD 06/12/23 R Bank CD 06/30/23 Totals June 30, 2021 Book Value (Continued) 2018 GO- Roads 2019 CO- Streets/ Facilities/ Equip 2019 CO- Stormwater 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 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,373,950 4,571,252 56,100 1,216,369 1,613,640 650,644 6,362,479 4,593,882 4,396,659 700,007 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,002,293 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,000,285 – – – – – – – – – – – – – – – – – – – – – – – – – – 2,003,075 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,373,950$ 6,573,545$ 56,100$ 3,219,443$ 1,613,640$ 650,644$ 8,362,764$ 4,593,882$ 4,396,659$ 700,007$ City of Georgetown Valley View Consulting, L.L.C.1959 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Veritex Bank MMA NexBank MMA Texas Capital Bank MMA TexPool TexSTAR Prosperity Bank CD 07/01/21 Prosperity Bank CD 07/15/21 Prosperity Bank CD 08/10/21 Prosperity Bank CD 08/23/21 R Bank CD 08/25/21 East West Bank CD 09/09/21 East West Bank CD 10/08/21 Prosperity Bank CD 10/14/21 Independent Bank CD 10/18/21 Prosperity Bank CD 11/22/21 Texas Regional Bank CD 12/07/21 East West Bank CD 12/30/21 East West Bank CD 01/07/22 Prosperity Bank CD 01/21/22 East West Bank CD 02/01/22 Independent Bank CD 02/05/22 Independent Bank CD 02/08/22 R Bank CD 02/25/22 Prosperity Bank CD 04/21/22 Independent Bank CD 04/22/22 Independent Bank CD 05/09/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 06/13/22 Prosperity Bank CD 07/25/22 Prosperity Bank CD 08/01/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 09/12/22 Prosperity Bank CD 10/24/22 Prosperity Bank CD 11/17/22 R Bank CD 12/31/22 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Bank OZK CD 06/12/23 R Bank CD 06/30/23 Totals June 30, 2021 Book Value (Continued) City - 2021 CO Fac/Equip/Par ks City - 2021 GO Parks City - 2021 GO Roads City - 2021A CO Electric City - 2021A CO Water/WW City - American Rescue Plan –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 12,883,708 1,000,010 6,698,429 6,650,049 16,300,121 4,014,767 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 12,883,708$ 1,000,010$ 6,698,429$ 6,650,049$ 16,300,121$ 4,014,767$ City of Georgetown Valley View Consulting, L.L.C.2060 City - Allocation June 30, 2021 Market Value Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Streets/ Vehicles 2015 CO- Stormwater 2015 GO- Roads 2015 Revenue Water WW 2016 CO- Streets/ Facilities/ Equip JPMorgan Chase Cash 23,547,685$ 23,547,685$ –$ –$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 434,080 434,080 – – – – – – – Veritex Bank MMA 3,213,925 3,213,925 – – – – – – – NexBank MMA 7,380,457 7,380,457 – – – – – – – Texas Capital Bank MMA 12,000,920 12,000,920 – – – – – – – TexPool 57,019,665 57,019,665 – – – – – – – TexSTAR 117,829,027 12,317,440 501,925 17,705,596 137,311 41,309 2,508,904 1,531,881 67,908 Prosperity Bank CD 07/01/21 4,018,010 4,018,010 – – – – – – – Prosperity Bank CD 07/15/21 5,026,275 5,026,275 – – – – – – – Prosperity Bank CD 08/10/21 3,001,480 – – – – – – – – Prosperity Bank CD 08/23/21 6,263,799 6,263,799 – – – – – – – R Bank CD 08/25/21 2,002,293 – – – – – – – – East West Bank CD 09/09/21 4,075,095 4,075,095 – – – – – – – East West Bank CD 10/08/21 5,005,008 5,005,008 – – – – – – – Prosperity Bank CD 10/14/21 2,504,993 2,504,993 – – – – – – – Independent Bank CD 10/18/21 2,551,673 2,551,673 – – – – – – – Prosperity Bank CD 11/22/21 3,005,228 3,005,228 – – – – – – – Texas Regional Bank CD 12/07/21 3,001,890 – – – – – – – – East West Bank CD 12/30/21 3,003,160 3,003,160 – – – – – – – East West Bank CD 01/07/22 5,005,008 5,005,008 – – – – – – – Prosperity Bank CD 01/21/22 4,007,990 4,007,990 – – – – – – – East West Bank CD 02/01/22 2,000,285 – – – – – – – – Independent Bank CD 02/05/22 3,002,905 3,002,905 – – – – – – – Independent Bank CD 02/08/22 5,004,822 4,003,858 – – – – – – – R Bank CD 02/25/22 2,003,075 – – – – – – – – Prosperity Bank CD 04/21/22 2,505,827 2,505,827 – – – – – – – Independent Bank CD 04/22/22 4,211,849 4,211,849 – – – – – – – Independent Bank CD 05/09/22 4,003,414 4,003,414 – – – – – – – Prosperity Bank CD 05/17/22 2,004,067 2,004,067 – – – – – – – Prosperity Bank CD 06/13/22 5,000,000 5,000,000 – – – – – – – Prosperity Bank CD 07/25/22 5,001,671 5,001,671 – – – – – – – Prosperity Bank CD 08/01/22 5,000,849 5,000,849 – – – – – – – Prosperity Bank CD 08/22/22 2,505,084 2,505,084 – – – – – – – Prosperity Bank CD 09/12/22 5,000,000 5,000,000 – – – – – – – Prosperity Bank CD 10/24/22 5,001,671 5,001,671 – – – – – – – Prosperity Bank CD 11/17/22 2,004,649 2,004,649 – – – – – – – R Bank CD 12/31/22 1,000,000 1,000,000 – – – – – – – Prosperity Bank CD 04/24/23 5,001,671 5,001,671 – – – – – – – Prosperity Bank CD 05/01/23 5,000,849 5,000,849 – – – – – – – Bank OZK CD 06/12/23 5,011,230 5,011,230 – – – – – – – R Bank CD 06/30/23 1,000,000 1,000,000 – – – – – – – Totals 345,161,582$ 226,640,008$ 501,925$ 17,705,596$ 137,311$ 41,309$ 2,508,904$ 1,531,881$ 67,908$ City of Georgetown Valley View Consulting, L.L.C.2161 City - Allocation June 30, 2021 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Veritex Bank MMA NexBank MMA Texas Capital Bank MMA TexPool TexSTAR Prosperity Bank CD 07/01/21 Prosperity Bank CD 07/15/21 Prosperity Bank CD 08/10/21 Prosperity Bank CD 08/23/21 R Bank CD 08/25/21 East West Bank CD 09/09/21 East West Bank CD 10/08/21 Prosperity Bank CD 10/14/21 Independent Bank CD 10/18/21 Prosperity Bank CD 11/22/21 Texas Regional Bank CD 12/07/21 East West Bank CD 12/30/21 East West Bank CD 01/07/22 Prosperity Bank CD 01/21/22 East West Bank CD 02/01/22 Independent Bank CD 02/05/22 Independent Bank CD 02/08/22 R Bank CD 02/25/22 Prosperity Bank CD 04/21/22 Independent Bank CD 04/22/22 Independent Bank CD 05/09/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 06/13/22 Prosperity Bank CD 07/25/22 Prosperity Bank CD 08/01/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 09/12/22 Prosperity Bank CD 10/24/22 Prosperity Bank CD 11/17/22 R Bank CD 12/31/22 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Bank OZK CD 06/12/23 R Bank CD 06/30/23 Totals (Continued) 2016 GO- Roads 2016 Revenue Water/WW Garey Park Donation 2017 CO Facilities/ Public Safety/ Equipment 2017 Revenue Electric 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Parks –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,429,271 1,096,157 246,572 178,455 97,386 4,761,158 56,701 661,264 407,723 – – – – – – – – – – – – – – – – – – – – – – – 3,001,480 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 3,001,890 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,000,964 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,429,271$ 1,096,157$ 246,572$ 178,455$ 97,386$ 11,765,493$ 56,701$ 661,264$ 407,723$ City of Georgetown Valley View Consulting, L.L.C.2262 City - Allocation June 30, 2021 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Veritex Bank MMA NexBank MMA Texas Capital Bank MMA TexPool TexSTAR Prosperity Bank CD 07/01/21 Prosperity Bank CD 07/15/21 Prosperity Bank CD 08/10/21 Prosperity Bank CD 08/23/21 R Bank CD 08/25/21 East West Bank CD 09/09/21 East West Bank CD 10/08/21 Prosperity Bank CD 10/14/21 Independent Bank CD 10/18/21 Prosperity Bank CD 11/22/21 Texas Regional Bank CD 12/07/21 East West Bank CD 12/30/21 East West Bank CD 01/07/22 Prosperity Bank CD 01/21/22 East West Bank CD 02/01/22 Independent Bank CD 02/05/22 Independent Bank CD 02/08/22 R Bank CD 02/25/22 Prosperity Bank CD 04/21/22 Independent Bank CD 04/22/22 Independent Bank CD 05/09/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 06/13/22 Prosperity Bank CD 07/25/22 Prosperity Bank CD 08/01/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 09/12/22 Prosperity Bank CD 10/24/22 Prosperity Bank CD 11/17/22 R Bank CD 12/31/22 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Bank OZK CD 06/12/23 R Bank CD 06/30/23 Totals (Continued) 2018 GO- Roads 2019 CO- Streets/ Facilities/ Equip 2019 CO- Stormwater 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 –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,373,950 4,571,252 56,100 1,216,369 1,613,640 650,644 6,362,479 4,593,882 4,396,659 700,007 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,002,293 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,000,285 – – – – – – – – – – – – – – – – – – – – – – – – – – 2,003,075 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,373,950$ 6,573,545$ 56,100$ 3,219,443$ 1,613,640$ 650,644$ 8,362,764$ 4,593,882$ 4,396,659$ 700,007$ City of Georgetown Valley View Consulting, L.L.C.2363 City - Allocation June 30, 2021 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Veritex Bank MMA NexBank MMA Texas Capital Bank MMA TexPool TexSTAR Prosperity Bank CD 07/01/21 Prosperity Bank CD 07/15/21 Prosperity Bank CD 08/10/21 Prosperity Bank CD 08/23/21 R Bank CD 08/25/21 East West Bank CD 09/09/21 East West Bank CD 10/08/21 Prosperity Bank CD 10/14/21 Independent Bank CD 10/18/21 Prosperity Bank CD 11/22/21 Texas Regional Bank CD 12/07/21 East West Bank CD 12/30/21 East West Bank CD 01/07/22 Prosperity Bank CD 01/21/22 East West Bank CD 02/01/22 Independent Bank CD 02/05/22 Independent Bank CD 02/08/22 R Bank CD 02/25/22 Prosperity Bank CD 04/21/22 Independent Bank CD 04/22/22 Independent Bank CD 05/09/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 06/13/22 Prosperity Bank CD 07/25/22 Prosperity Bank CD 08/01/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 09/12/22 Prosperity Bank CD 10/24/22 Prosperity Bank CD 11/17/22 R Bank CD 12/31/22 Prosperity Bank CD 04/24/23 Prosperity Bank CD 05/01/23 Bank OZK CD 06/12/23 R Bank CD 06/30/23 Totals (Continued) City - 2021 CO Fac/Equip/Par ks City - 2021 GO Parks City - 2021 GO Roads City - 2021A CO Electric City - 2021A CO Water/WW City - American Rescue Plan –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – 12,883,708 1,000,010 6,698,429 6,650,049 16,300,121 4,014,767 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 12,883,708$ 1,000,010$ 6,698,429$ 6,650,049$ 16,300,121$ 4,014,767$ City of Georgetown Valley View Consulting, L.L.C.2464 Georgetown Economic Development Corporation (GEDCO) QUARTERLY INVESTMENT REPORT For the Quarter Ended September 30, 2021 Prepared by Valley View Consulting, L.L.C. ________________________________________________________________________ Leigh Wallace Nathan Parras Finance Director Assistant Finance Director ________________________________________________________________________ Karrie Pursley Elaine Wilson Treasurer Assistant Finance Director The investment portfolio of the Georgetown Economic Development Corporation (GEDCO) is in compliance with the Texas Public Funds Investment Act and the Investment Policy and Strategies. Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total return yields and do not account for investment advisor fees. 65 Annual Comparison of Portfolio Performance FYE Results by Investment Category: Asset Type Ave. Yield Book Value Market Value Ave. Yield Book Value Market Value MMA 0.20%2,129,054$ 2,129,054$ 0.08%2,131,487$ 2,131,487$ Pools 0.14%5,746,114 5,746,114 0.01%5,515,983 5,515,983 Certificates of Deposit 1.70%2,016,943 2,016,943 0.24%2,002,381 2,002,381 Totals 9,892,111$ 9,892,111$ 9,649,850$ 9,649,850$ Fourth Quarter-End Yield 0.47%0.08% Average Quarter-End Yields (1): 2020 Fiscal Year 2021 Fiscal Year GEDCO 0.98%0.16% Rolling Three Month Treasury 0.76%0.06% Rolling Six Month Treasury 0.99%0.08% TexPool 0.75%0.04% (1) Average Quarterly Yield calculated using quarter-end report average yield and adjusted book value. September 30, 2020 September 30, 2021 Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.166 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield MMA 2,131,057$ 2,131,057$ 2,131,487$ 2,131,487$ 0.08% Pools 7,601,901 7,601,901 5,515,983 5,515,983 0.01% Certificates of Deposit 2,001,170 2,001,170 2,002,381 2,002,381 0.24% 11,734,129$ 11,734,129$ 9,649,850$ 9,649,850$ 0.08% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 0.08%Total Portfolio 0.16% Rolling Three Month Treasury 0.05%Rolling Three Month Treasury 0.06% Rolling Six Month Treasury 0.05%Rolling Six Month Treasury 0.08% TexPool 0.03%TexPool 0.04% Interest income provided in separate report. June 30, 2021 (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. September 30, 2021 Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.267 Economic Overview9/30/2021The Federal Open Market Committee (FOMC) maintained the Fed Funds target range at 0.00% to 0.25% (Effective Fed Funds are trading <0.10%), and projects that reduced rates could remain into 2023. Monthly government security purchases may begin tapering as early as Nov 2021. Second Quarter GDP posted +6.7% (Final). Employment recovery/growth has moderated, but job openings remain high. August Non-Farm Payroll only added 194k net new jobs. Crude oil bounced up to +/-$77 per barrel, with fuel shortages in England and other countries. The Stock Markets reached new highs, but have retrenched slightly. Housing, Industrial Production, Durable Goods, Consumer Spending, and other indicators remain positive but constrained. The Biden administration and Congress continue to negotiate infrastructure, fiscal and debt limit packages. Inflation remained over the FOMC 2+% target and may not be as temporary as initially projected. The Yield Curve rose slightly from two years to ten years.02505007501,0001,2501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,0004,2504,5004,750S&P 5000.000.501.001.502.002.503.003.50US Treasury Historical Yields - Since Nov 2015Six Month T-BillTwo Year T-NoteTen Year T-Note0.000.200.400.600.801.001.201.401.60Treasury Yield CurvesSeptember 30, 2020June 30, 2021September 30, 20210.000.501.001.502.002.503.003.504.004.505.005.506.00US Treasury Historical Yields - Since 2006Six Month T-BillTwo Year T-NoteTen Year T-NoteValley View Consulting, L.L.C.368 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 0.08%10/01/21 09/30/21 2,131,487$ 2,131,487$ 1.00 2,131,487$ 1 0.08% TexasDAILY AAAm 0.02%10/01/21 09/30/21 2,125,934 2,125,934 1.00 2,125,934 1 0.02% TexSTAR AAAm 0.01%10/01/21 09/30/21 3,390,049 3,390,049 1.00 3,390,049 1 0.01% Veritex Bank CD 0.24%8/5/2022 02/08/21 2,002,381 2,002,381 100.00 2,002,381 309 0.24% 9,649,850$ 9,649,850$ 9,649,850$ 65 0.08% (1)(2) September 30, 2021 (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.469 MMA 22% Pools 57% Certificates of Deposit 21% GEDCO PORTFOLIO COMPOSITION $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 12/31/20 3/31/2021 6/30/2021 9/30/2021 GEDCO PORTFOLIO BALANCES CD TexasDAILY TexSTAR Money Market Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.570 Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 06/30/21 Increases Decreases Book Value 09/30/21 Market Value 06/30/21 Change in Market Value Market Value 09/30/21 Veritex Bank MMA 0.08%10/01/21 2,131,057$ 430$ –$ 2,131,487$ 2,131,057$ 430$ 2,131,487$ TexasDAILY 0.02%10/01/21 2,125,828 107 – 2,125,934 2,125,828 107 2,125,934 TexSTAR 0.01%10/01/21 5,476,074 – (2,086,025) 3,390,049 5,476,074 (2,086,025) 3,390,049 Veritex Bank CD 0.24%8/5/2022 2,001,170 1,211 – 2,002,381 2,001,170 1,211 2,002,381 TOTAL / AVERAGE 0.08%11,734,129$ 1,747$ (2,086,025)$ 9,649,850$ 11,734,129$ (2,084,278)$ 9,649,850$ Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.671 Georgetown Transportation Enhancement Corporation (GTEC) QUARTERLY INVESTMENT REPORT For the Quarter Ended September 30, 2021 Prepared byValley View Consulting, L.L.C. ________________________________________________________________________ Leigh Wallace Nathan Parras Finance Director Assistant Finance Director ________________________________________________________________________ Karrie Pursley Elaine Wilson Treasurer The investment portfolio of the Georgetown Transportation Enhancement Corporation (GTEC) is in compliance with the Texas Public Funds Investment Act and the Investment Policy and Strategies. Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total return yields and do not account for investment advisor fees. 72 FYE Results by Investment Category: Asset Type Ave. Yield Book Value Market Value Ave. Yield Book Value Market Value Pools/MMAs 0.15%26,283,802$ 26,283,802$ 0.02%34,752,525$ 34,752,525$ CDs/Securities 0.40%3,001,377 3,001,377 0.15%3,012,460 3,012,460 Totals 29,285,179$ 29,285,179$ 37,764,985$ 37,764,985$ Fourth Quarter-End Yield 0.17%0.03% Average Quarter-End Yields (1): 2021 Fiscal Year 2021 Fiscal Year GTEC 0.97%0.06% Rolling Three Month Treasury 0.76%0.06% Rolling Six Month Treasury 0.99%0.08% TexPool 0.76%0.04% (1) Average Quarterly Yield calculated using quarter-end report average yield and adjusted book value. Annual Comparison of Portfolio Performance September 30, 2020 September 30, 2021 Georgetown Transportation Enhancement Corporation (GTEC) Valley View Consulting, L.L.C. 173 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield Pools/MMAs 39,417,553$ 39,417,553$ 34,752,525$ 34,752,525$ 0.02% CDs/Securities 3,009,998 3,009,998 3,012,460 3,012,460 0.15%Totals 42,427,551$ 42,427,551$ 37,764,985$ 37,764,985$ 0.03% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 0.03%Total Portfolio 0.06% Rolling Three Month Treasury 0.05%Rolling Three Month Treasury 0.06% Rolling Six Month Treasury 0.05%Rolling Six Month Treasury 0.08% TexPool 0.03%TexPool 0.04% Interest data provided in separate report. June 30, 2021 (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. September 30, 2021 Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.274 Economic Overview9/30/2021The Federal Open Market Committee (FOMC) maintained the Fed Funds target range at 0.00% to 0.25% (Effective Fed Funds are trading <0.10%), and projects that reduced rates could remain into 2023. Monthly government security purchases may begin tapering as early as Nov 2021. Second Quarter GDP posted +6.7% (Final). Employment recovery/growth has moderated, but job openings remain high. August Non-Farm Payroll only added 194k net new jobs. Crude oil bounced up to +/-$77 per barrel, with fuel shortages in England and other countries. The Stock Markets reached new highs, but have retrenched slightly. Housing, Industrial Production, Durable Goods, Consumer Spending, and other indicators remain positive but constrained. The Biden administration and Congress continue to negotiate infrastructure, fiscal and debt limit packages. Inflation remained over the FOMC 2+% target and may not be as temporary as initially projected. The Yield Curve rose slightly from two years to ten years.02505007501,0001,2501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,0004,2504,5004,750S&P 5000.000.501.001.502.002.503.003.50US Treasury Historical Yields - Since Nov 2015Six Month T-BillTwo Year T-NoteTen Year T-Note0.000.200.400.600.801.001.201.401.60Treasury Yield CurvesSeptember 30, 2020June 30, 2021September 30, 20210.000.501.001.502.002.503.003.504.004.505.005.506.00US Treasury Historical Yields - Since 2006Six Month T-BillTwo Year T-NoteTen Year T-NoteValley View Consulting, L.L.C.375 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 0.03%10/01/21 09/30/21 16,970,004$ 16,970,004$ 1.00 16,970,004$ 1 0.03% TexSTAR AAAm 0.01%10/01/21 09/30/21 15,092,976 15,092,976 1.00 15,092,976 1 0.01% Veritex Bank MMA 0.08%10/01/21 09/30/21 2,689,545 2,689,545 1.00 2,689,545 1 0.08% Prosperity Bank CD 0.15%08/23/22 08/23/21 3,012,460 3,012,460 100.00 3,012,460 327 0.15% TOTALS 37,764,985$ 37,764,985$ 37,764,985$ 27 0.03% (1)(2) September 30, 2021 (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.476 Pools/MMAs 92% CDs/Securities 8% GTEC PORTFOLIO COMPOSITION $0 $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 $35,000,000 $40,000,000 $45,000,000 12/31/2020 3/31/2021 6/30/2021 9/30/2021 GTEC PORTFOLIO BALANCES CD TexPool TexSTAR Money Market Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.577 Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 06/30/21 Increases Decreases Book Value 09/30/21 Market Value 06/30/21 Change in Market Value Market Value 09/30/21 TexPool 0.03%10/01/21 18,186,491$ –$ (1,216,487)$ 16,970,004$ 18,186,491$ (1,216,487)$ 16,970,004$ TexSTAR 0.01%10/01/21 18,542,059 – (3,449,083) 15,092,976 18,542,059 (3,449,083) 15,092,976 Veritex Bank MMA 0.08%10/01/21 2,689,003 542 – 2,689,545 2,689,003 542 2,689,545 Prosperity Bank CD 0.40%08/23/21 3,009,998 – (3,009,998) – 3,009,998 (3,009,998) – Prosperity Bank CD 0.15%08/23/22 – 3,012,460 – 3,012,460 – 3,012,460 3,012,460 TOTAL / AVERAGE 0.03%42,427,551$ 3,013,002$ (7,675,568)$ 37,764,985$ 42,427,551$ (4,662,566)$ 37,764,985$ Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.678 Department Federal Grantor Pass-Through Agency Identifying Number COG Name/Purpose YTD Expenditures YTD Revenue Recognized Airport N/A Texas Department of Transportation-Aviation M1914GEOR RAMP Grant - Routine Airport Maintenance Program 108,353.80 50,000.00 Airport FEMA Texas Department of Transportation - Aviation Airport CARES Funding 156,980.34 156,980.34 Emergency Management FEMA Williamson County WILCO Forward - CARES Funding for COVID-19 96,260.00 96,260.00 Emergency Management US Dept. of the Treasury American Rescue Plan Act SLFRF Funding 87,771.00 87,771.00 Fire Department of Health & Human Services CMS (Centers for Medicare & Medicaid Services)EMS CARES Round 1 76,182.00 - Fire FEMA Travis County EMW-2019-FG-01607 FY2019 Assistance to Firefighters Grant 347,130.26 315,573.00 Fire US Department of Homeland Security Federal Emergency Management Agency EMW-2017-FH-00496 SAFER 1,078,589.29 467,718.59 Library National Endowment for the Arts National Endowment for the Arts COVID Relief Funding 9,534.00 3,990.11 Planning US Department of Housing & Urban Development Williamson County CDBG Home Repair 43,059.77 40,920.32 Police US. Department of Justice N/A TX2460200 Equitable Sharing Agreement 25,523.52 34,920.95 Police US. Department of Justice Texas Office of the Attorney General 2018-MC-FX-K065 Internet Crimes Against Children 23,583.00 23,583.00 Public Works Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ-0914-05-187 Highway Planning & Construction (Austin Ave Bridge) 15,763.61 - Public Works Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ-0914-05-200,201,202 Highway Planning & Construction (Williams Dr Corridor) - - Division Grantor COG Name/Purpose Status Emergency Management FEMA TDEM DR-4586 Winter Storm Uri Recovery Reviewed By: Elaine Wilson CITY OF GEORGETOWN Grant/Federal Funding Report as of September 30, 2021 Active Applications Pending Award Under FEMA Review 79 CITY OF GEORGETOWN CIP Project Budget Total Spend Remaining Budget Percent Remaining Airport Airport - Self Managed PRJ000197 Hangar Mainenance 240,000 - 240,000 100.00% PRJ000198 Pavement Maintenance 60,000 - 60,000 100.00% PRJ000199 Wildlife Management 150,000 18,000 132,000 88.00% Airport - Self Managed Total 450,000 18,000 432,000 288.00% Management Services PRJ000184 Airport Maintenance Facility 750,000 - 750,000 100.00% Management Services Total 750,000 - 750,000 100.00% Airport Total 1,200,000 18,000 1,182,000 388.00% CDBG CDBG PRJ000003 17th Street 193,000 175,137 17,863 9.26% PRJ000144 Maple Street (Inactive) 80,784 - 80,784 100.00% PRJ000248 21st W/WW offsite CDBG 97,000 - 97,000 100.00% CDBG Total 370,784 175,137 195,647 209.26% CDBG Total 370,784 175,137 195,647 209.26% Downtown TIRZ Parks PRJ000050 Grace Heritage Plaza (Inactive) 139,100 45,900 93,200 67.00% Parks Total 139,100 45,900 93,200 67.00% Downtown TIRZ Total 139,100 45,900 93,200 67.00% Electric Services Electric PRJ000022 Consultant Engineering 271,352 68,754 202,599 74.66% PRJ000026 Db Wood_Sh29 Intersection 240,000 170,413 69,587 77.63% PRJ000036 Electrical System Improvement 100,000 20,045 79,955 79.96% PRJ000040 Fiber Optic (Inactive) 19,516 19,516 - 0.00% PRJ000062 New Development Projects 9,851,744 5,777,709 4,074,035 53.18% PRJ000073 Power Quality Improvements 50,000 - 50,000 100.00% PRJ000095 Shell Road Feeders (Inactive)160,000 181,545 (21,545) 50.97% PRJ000147 Sectionalization Improvements 1,100,000 - 1,100,000 100.00% PRJ000175 I-35 Mobility Project TxDot 200,000 269,118 (69,118) -14.64% PRJ000189 Ronald Reagan - Glasscock Feeder Extension along Hwy 195 -Phase I 560,000 32,284 527,716 94.24% PRJ000192 Ronald Reagan - Glasscock Feeder extension along Hwy 195 - Phase II 591,250 249,738 341,512 57.76% PRJ000195 Downtown Overhead Rehab 2,400,000 70,907 2,329,093 97.05% PRJ000221 Titan-Aviation Dr to IH35 Infrastructure Addition 1,000,000 263,697 736,303 73.63% PRJ000222 Electric Design Software Replacement 80,000 - 80,000 100.00% PRJ000225 Chapel Hill, WS-11139 (GEO-45-C.3)437,577 57,523 380,054 86.85% PRJ000226 Wolf Ranch West - Section 1AG & 1BG 479,052 33,405 445,647 93.03% PRJ000227 Ascend Westinghouse Apartments 444,598 29,165 415,432 93.44% PRJ000229 Sun City NH 76 WS-11188 (GEO-18.2-N.51)274,030 191,672 82,359 30.05% PRJ000230 Sun City NH 78 296,400 19,601 276,799 93.39% PRJ000231 Georgetown Titan Development 1 & 2 140,428 107,537 32,891 23.42% PRJ000232 Texas Outdoor Power Building 1 91,414 62,745 28,669 31.36% PRJ000234 Summit at Westinghouse Self-Storage 49,685 5,855 43,830 88.22% PRJ000236 Medcore (Georgetown) Senior Living 226,972 202,637 24,334 10.72% PRJ000238 The Oscar at Georgetown 366,351 19,689 346,661 94.63% PRJ000239 Wolf Ranch West - Section 3 - Phase 2 418,339 24,554 393,786 94.13% PRJ000242 Allora North Georgetown 557,422 34,792 522,630 93.76% PRJ000243 Fairfield Inn - WS11346 131,340 40,979 90,362 68.80% PRJ000245 Morgan Mays Street Apartments 452,508 - 452,508 100.00% PRJ000246 Vida Apartments 198,248 - 198,248 100.00% PRJ000250 Georgetown Infiniti 135,633 - 135,633 100.00% PRJ000272 Wolf Lakes - 43,764 (43,764) 0.00% PRJ000273 The Grove II Townhomes 108,924 - 108,924 100.00% PRJ000282 ANB Systems - Interconnection Service Portal 80,000 4,991 75,009 93.76% Electric Total 21,512,783 8,002,635 13,510,147 2339.99% Electric Services Total 21,512,783 8,002,635 13,510,147 2339.99% General Capital Projects Environmental Services PRJ000116 Transfer Station 11,000,000 795,541 10,204,459 92.77% Environmental Services Total 11,000,000 795,541 10,204,459 92.77% Finance PRJ000038 ERP Project 6,231,654 5,895,528 336,126 5.39% Finance Total 6,231,654 5,895,528 336,126 5.39% Fire PRJ000134 SCBA Replacement 1,170,000 - 1,170,000 100.00% PRJ000135 Cardiac Monitors 483,517 483,517 - 0.00% Fire Total 1,653,517 483,517 1,170,000 100.00% Fleet PRJ000124 Radio Replacement 938,278 179,219 759,059 80.90% 80 CITY OF GEORGETOWN CIP Project Budget Total Spend Remaining Budget Percent Remaining Fleet Total 938,278 179,219 759,059 80.90% GTEC Department PRJ000203 FM1460 Widening 300,984 - 300,984 100.00% PRJ000206 NB Front Rd (2338 To Lakeway)216,000 221,766 (5,766) -2.67% GTEC Department Total 516,984 221,766 295,218 97.33% Management Services PRJ000028 Downtown Parking Expansion 712,776 701,947 10,830 8.86% PRJ000029 Downtown Parking Garage 291,483 118,340 173,143 59.40% PRJ000033 Dtwn Landsping & Public Art (Inactive) 5,746 5,746 - 0.00% PRJ000037 EOC Siren System 15,525 (8,564) 24,089 155.16% PRJ000042 Fire Station 6 5,500,000 5,322,599 177,401 3.23% PRJ000043 Fire Station 7 7,198,744 6,463,450 735,295 10.21% PRJ000067 Parking Improvements 68,510 - 68,510 100.00% PRJ000131 Fuel Station 1,100,000 21,381 1,078,619 98.06% PRJ000136 GMC Remodel Phase I 500,000 130,635 369,365 73.87% PRJ000178 Public Safety Operation and Training Center Phase II 4,500,000 14,690 4,485,310 99.67% PRJ000179 Recreation Center Teen/Senior Renovation 215,525 - 215,525 100.00% PRJ000180 Recreation Center Natatorium HVAC Replacement 700,000 667,546 32,454 4.64% PRJ000191 Georgetown City Center - Festival/Public Space 5,400,000 30,524 5,369,476 99.44% PRJ000223 City Center Signage 125,000 - 125,000 100.00% Management Services Total 26,333,310 13,468,293 12,865,016 912.55% Parks PRJ000048 Garey Park 15,346,730 15,100,250 246,480 1.61% PRJ000089 San Gabriel Park Improvement 13,025,000 7,384,382 5,640,618 43.31% PRJ000125 Parks Master Plan 229,998 137,883 92,115 40.05% PRJ000126 Regional Trail Development 1,275,000 88,551 1,186,449 93.05% PRJ000127 Neighborhood Park Development (Inactive) 240,541 240,541 - 0.00% PRJ000129 Ada Transition Plan 1,075,982 469,851 606,131 56.33% PRJ000130 Tennis Center Pool Demo (Inactive) 39,076 - 39,076 100.00% PRJ000190 Heritage Gardens 275,860 63,810 212,050 76.87% PRJ000205 Katy Crossing Trail (Inactive)700,000 500,181 199,819 28.55% PRJ000240 South Main Plaza 272,450 9,950 262,500 96.35% PRJ000244 Grace Heritage Plaza 90,000 90,000 - 0.00% Parks Total 32,570,638 24,085,399 8,485,238 536.11% Police PRJ000133 Body Cameras 800,000 737,412 62,588 13.49% Police Total 800,000 737,412 62,588 13.49% Public Works - Self Managed Department PRJ000204 Historic District Street Signs - - - 0.00% Public Works - Self Managed Department Total - - - 0.00% Public Works Department PRJ000013 Austin Avenue Bridge 2,855,398 1,717,047 1,138,351 74.81% PRJ000137 Intersection Improvements (Lakeway @ Williams Drive)1,400,000 222,710 1,177,290 84.09% PRJ000138 Downtown Sidewalks 2,579,978 811,788 1,768,190 68.54% PRJ000139 Westinghouse - Scenic Lake Traffic Signal 600,000 157,063 442,937 73.82% PRJ000140 Austin Ave Bridges 10,184,000 - 10,184,000 100.00% PRJ000141 Southwestern Blvd 4,200,000 722,527 3,477,473 82.80% PRJ000143 Leander Rd(Norwood-Swbypass)6,750,000 260,777 6,489,223 96.14% PRJ000171 Shell Rd Sidewalk (Inactive)229,825 203,755 26,070 11.34% PRJ000188 DB Wood (SH 29 to Oak Ridge)18,000,000 692,087 17,307,913 96.16% PRJ000201 Austin Ave. (Sh29-Fm2243)466,000 466,000 - 0.00% PRJ000202 FM 971 5,821,392 5,262,842 558,550 9.59% PRJ000207 Northwest Blvd Bridge 12,418,528 11,502,297 916,231 14.88% PRJ000208 Old Town Northeast 906,159 906,159 - 0.00% PRJ000209 Southeast Inner Loop 10,521,000 7,966,721 2,554,279 56.08% PRJ000214 Intersection Improvements (Traffic Signals)1,650,000 303,211 1,346,789 81.62% PRJ000215 2021 Intersection Safety Enhancements (RRFB)150,000 82,100 67,900 45.27% PRJ000216 FY21 Downtown Sidewalk Improvements 1,000,000 21,850 978,150 97.82% PRJ000217 SW Bypass - Wolf Ranch Extension 1,000,000 35,523 964,477 96.45% PRJ000254 Shell Road 12,503,000 - 12,503,000 100.00% PRJ000255 Rockride Lane 5,776,000 - 5,776,000 100.00% PRJ000256 Westinghouse Road 8,200,000 - 8,200,000 100.00% PRJ000257 Sam Houston Ave Ext/SE1/Wilco Corridor 4,000,000 - 4,000,000 100.00% PRJ000297 Southeast Inner Loop - MB21 32,061,000 - 32,061,000 100.00% Public Works Department Total 143,272,279 31,334,457 111,937,822 1589.40% Right of Way PRJ000200 Access Rtw To Government Srv 220,000 220,000 - 0.00% Right of Way Total 220,000 220,000 - 0.00% General Capital Projects Total 223,536,659 77,421,132 146,115,527 3427.94% General Fund Parks PRJ000055 Katy Crossing Trail (Inactive) 700,000 - 700,000 100.00% Parks Total 700,000 - 700,000 100.00% Public Works Department 81 CITY OF GEORGETOWN CIP Project Budget Total Spend Remaining Budget Percent Remaining PRJ000012 Austin Ave. (Sh29-Fm2243) (Inactive)466,000 - 466,000 100.00% Public Works Department Total 466,000 - 466,000 100.00% Right of Way PRJ000007 Access Rtw To Government Srv 220,000 - 220,000 100.00% Right of Way Total 220,000 - 220,000 100.00% General Fund Total 1,386,000 - 1,386,000 300.00% GTEC GTEC Department PRJ000046 FM 971/ Fontana (Nw Bridge) 1,209,000 1,206,390 2,610 0.22% PRJ000053 IH 35/ Hwy 29 Intersection Imp 1,800,000 120,066 1,679,934 93.33% PRJ000060 Rabbit Hill Road 4,100,000 134,261 3,965,739 96.73% PRJ000083 Rivery Tia Improvements 1,179,000 1,094,839 84,161 7.14% PRJ000092 Se Inner Loop Widening (Inactive) 8,148,000 - 8,148,000 100.00% PRJ000145 Sh29 Signal And Roadway Improvements 1,595,000 385,134 1,209,866 75.85% PRJ000146 Wolf Ranch Parkway Extension (Inactive)1,100,000 - 1,100,000 100.00% PRJ000181 Aviation Drive 10,300,000 1,519,716 8,780,284 97.59% PRJ000182 Capella 1,500,000 - 1,500,000 100.00% PRJ000183 Costco 2,000,000 - 2,000,000 100.00% GTEC Department Total 32,931,000 4,460,407 28,470,593 770.86% GTEC Total 32,931,000 4,460,407 28,470,593 770.86% Stormwater Stormwater PRJ000004 18th and Hutto Drainage 50,000 5,969 44,031 88.06% PRJ000005 2nd and Rock Pond (Inactive) 625,000 447,151 177,849 28.46% PRJ000024 2020 Curb & Gutter 1,055,000 588,673 466,327 44.20% PRJ000104 Stormwater Infrastructure 347,000 132,438 214,562 61.83% PRJ000148 Water Quality Ponds (Inactive) 98,000 - 98,000 100.00% PRJ000149 Drainage Improvement/Flood Mitigation Projects 300,000 - 300,000 100.00% PRJ000213 2021 Curb & Gutter Project 500,000 46,785 453,215 90.64% Stormwater Total 2,975,000 1,221,017 1,753,983 513.20% Stormwater Total 2,975,000 1,221,017 1,753,983 513.20% Street Tax Public Works Department PRJ000172 2020 Street Maintenance High Performance Seal: Bid Package No.1 372,200 349,542 22,658 6.09% PRJ000173 2020 Street Maintenance High Performance Seal: Bid Package No. 2 463,195 337,719 125,476 27.09% PRJ000174 2020 street maintenance HIPR 1,935,589 1,191,547 744,042 38.44% PRJ000210 2021 HIPR Street Maintenance 2,300,000 1,613,020 686,980 29.87% PRJ000211 2021 High Performance Pavement Seal Project #1 750,000 73,414 676,586 90.21% PRJ000212 2021 High Performance Pavement Seal Project #2 600,000 56,600 543,400 90.57% PRJ000237 Northeast Inner Loop (Stadium to FM971) Emergency Repairs 700,000 681,858 18,142 2.59% Public Works Department Total 7,120,983 4,303,699 2,817,284 284.86% Street Tax Total 7,120,983 4,303,699 2,817,284 284.86% Transportation GTEC Department PRJ000047 FM1460 Widening (Inactive) 794,000 - 794,000 100.00% PRJ000061 NB Front Rd (2338 To Lakeway) (Inactive)366,000 - 366,000 200.00% GTEC Department Total 1,160,000 - 1,160,000 300.00% Public Works Department PRJ000045 FM 971 - (26,684) 26,684 0.00% PRJ000063 Northwest Blvd Bridge 3,509,094 421,578 3,087,516 87.99% PRJ000065 Old Town Northeast (Inactive) 855,021 (19,064) 874,085 102.23% PRJ000100 Southeast Inner Loop - - - 0.00% Public Works Department Total 4,364,115 375,830 3,988,285 190.22% Transportation Total 5,524,115 375,830 5,148,285 490.22% Village PID Parks PRJ000249 GVPID Landscape Improvements - 21,720 (21,720) 0.00% Parks Total - 21,720 (21,720) 0.00% Village PID Total - 21,720 (21,720) 0.00% Water Services Water PRJ000014 Berry Creek Inter.49,949,000 1,301,561 48,647,439 119.39% PRJ000016 Braun Est (Inactive)1,290,458 1,290,458 - 0.00% PRJ000017 Cedar Breaks Est 3,385,000 - 3,385,000 100.00% PRJ000023 Cr 255 (Wd14-2)1,493,963 - 1,493,963 100.00% PRJ000025 Db Wood/ Pastor 24 Dedicated 440,726 440,726 - 0.00% PRJ000027 Domel PS Improvements (Inactive)5,816,000 - 5,816,000 100.00% PRJ000034 Earz 2,326,000 359,655 1,966,345 84.54% PRJ000057 Lift Station Upgrade 1,723,593 8,593 1,715,000 99.50% PRJ000059 LWTP Raw Water Intake Rehab 6,750,000 5,369,068 1,380,932 20.46% 82 CITY OF GEORGETOWN CIP Project Budget Total Spend Remaining Budget Percent Remaining PRJ000066 Park Lift Station & Force Main 3,574,341 2,109,334 1,465,007 40.99% PRJ000069 Pecan Branch Ph 2 (Inactive) 238,041 238,041 - 0.00% PRJ000075 Pumps & Storage 9,289 9,289 - 0.00% PRJ000076 Rabbit Hill Est (Inactive) 1,826,000 873,294 952,706 100.00% PRJ000085 Ronald Reagan/Daniels Mountain 140,989 140,989 - 0.00% PRJ000087 S. Lake Wtp 2018 (Inactive) 6,950,000 - 6,950,000 100.00% PRJ000088 San Gabriel Belt Press and Rehab (Inactive)2,594,238 2,591,167 3,071 0.12% PRJ000096 Shell Road Water Line 6,890,000 949,010 5,940,990 86.23% PRJ000101 Southlake Wtp 100,000,000 6,064,878 93,935,122 156.22% PRJ000103 Stonehedge Ls & Fm (Inactive)150,000 - 150,000 100.00% PRJ000108 Sun City Elevated Storage Tank (Inactive)3,224,000 - 3,224,000 100.98% PRJ000110 Sw Bypass Waterline 1,106,000 - 1,106,000 100.00% PRJ000115 Use PRJ000163 for Tank Rehab (Inactive)- - - 0.00% PRJ000119 Water Mains 1,536,750 463,125 1,073,625 69.86% PRJ000121 Westinghouse Ls & Fm (Inactive)3,299,000 - 3,299,000 100.00% PRJ000122 Westside Facility (Inactive)505,500 - 505,500 100.00% PRJ000123 WW Interceptors - - - 0.00% PRJ000150 Carriage Oaks Transmission 600,000 - 600,000 100.00% PRJ000151 FY2020 CR262 Waterline (Inactive)- - - 0.00% PRJ000152 Hoover Pump Station 6,850,000 158,986 6,691,014 97.68% PRJ000153 FY2020 Round Rock Supply Line (Inactive)300,000 - 300,000 100.00% PRJ000154 Stonewall Ranch Pump Station Improvements 3,100,000 - 3,100,000 100.00% PRJ000155 Southside Water Treatment Plant 6,426,706 542,693 5,884,013 91.56% PRJ000156 Gatlin/Teravista Improvements 450,000 - 450,000 100.00% PRJ000157 Leander Interconnect 340,245 250,745 89,500 26.30% PRJ000158 West loop (H-1A)447,385 447,385 - 191.11% PRJ000160 Round Rock Supply Pump Station And Elevated Storage Tank 10,500,000 635,286 9,864,714 100.46% PRJ000161 Miscellaneous Line Upgrades 1,372,000 568,081 803,919 78.13% PRJ000162 South West Bypass Water (H24-1)2,906,000 2,184,007 721,993 24.84% PRJ000163 Tank Rehabilitation 3,372,536 403,437 2,969,099 88.04% PRJ000164 Council Chamber Water 423,000 15,960 407,040 151.31% PRJ000165 San Gabriel WWTP Rehabilitation 3,257,307 98,000 3,159,307 96.99% PRJ000167 San Gabriel Inter SGI -2 4,500,000 - 4,500,000 123.07% PRJ000168 WWTP Upgrade 950,000 214,907 735,093 93.06% PRJ000169 FY2020 Lift Station Upgrade (Inactive)- - - 0.00% PRJ000177 Northlake WTP Phase IV Expansion 15,000,000 2,446,072 12,553,928 83.69% PRJ000185 Cimarron Hills Wastewater Treatment Plant Expansion 5,300,000 186,205 5,113,795 96.49% PRJ000186 Water Oak 24" Waterline (Inactive)- - - 0.00% PRJ000218 EARZ Wastewater Rehabilitation Area 2 - 2019 2,460,360 1,740,295 720,065 29.27% PRJ000219 Southside GST Foundation Improvements 535,678 - 535,678 100.00% PRJ000228 Southside GST Roof Rehab 567,000 - 567,000 100.00% PRJ000241 2020 - 2021 EARZ - Area 3 1,500,000 190,173 1,309,827 87.32% Water Total 276,377,104 32,291,419 244,085,686 3737.60% Water Operations PRJ000220 AMI Western District Improvements 750,000 - 750,000 100.00% Water Operations Total 750,000 - 750,000 100.00% Water Services Total 277,127,104 32,291,419 244,835,686 3837.60% Grand Total 573,823,528 128,336,896 445,486,632 12628.91% 83 Unfunded Liability & CommitmentsFinancial Impact/NotesStatus Updates ‐ 6/30/21Status Updates ‐ 9/30/21Cemetery Special Revenue Fund Perpetual ReserveCurrently cemetery operations are self‐funded through plot sales of approximately $50K per year. The cemetery is managed through Parks Administration. In 2015, Council elected to transfer $75,000 annually for future costs associated with maintaining the property. The General Fund has made this transfer in since FY 2016. While the perpetual reserve has grown slowly, it is not on pace to sustain the Cemetery Fund long‐term. The fund is estimated to need a $5 million balance to be self‐sustaining on interest earnings and cemetery revenue.The FY2021 projected ending fund balance is $650,000. The general fund transfer was restored to the $75,000 in the FY2022 budget. No Change. Council gave no direction during the Fiscal Policy update on reserves not in compliance.Unfunded Actuarial Accrued Liability (UAAL)Recognizes the outstanding liability for the City’s employee retirement plan through TMRS. The City contributes monthly to fund the UAAL, based on an annual percentage of payroll. Actual % of payroll costs is recognized within each fund. The UAAL is provided by TMRS and lags one year.As of 9/30/2020, the net pension liability is $18.7 million and is 88.97% funded. This decrease in liability is due to a change in the actuarial assumptions.No change, this report is not yet available.Other Post Employee Benefits (OPEB)While the City has no obligation to offer additional retiree benefits, retirees are eligible to participate in the City’s health insurance program. That ability represents a subsidy that impacts health insurance costs to the City. Retirees pay their monthly premiums to the self insurance fund, which then processes their health insurance claims. OPEB liability as of 9/30/2020 is $2.7 million. This is a combination of sudden death benefits as well as post‐retirement healthcare.No change, this report is not yet available.Compensated AbsenceFuture costs associated with benefits such as vacation, and sick leave for City employees. Compensated Absence is accrued annually to each proprietary fund type on a GAAP basis and accounted for on the balance sheet of each fund. For governmental funds (and for budgetary basis), the expense is recognized when due and payable. The City keeps a reserve in the General Fund to help offset large payouts for long‐term employees. The reserve is used as needed, and annually replenished or increased based on known risk.Compensated absences as of 9/30/2020 are $8.2 million. More time was earned than used during FY2020 as many plans were changed related to the pandemic. The City did not extend any vacation cap carry overs in general. As with any year, specific requests for carryover are considered and approved by the City Manager.No change, this report is not yet available.CITY OF GEORGETOWNLong-term Commitments, Reservations, and Other Unfunded Liabilities9/30/202184 Unfunded Liability & CommitmentsFinancial Impact/NotesStatus Updates ‐ 6/30/21Status Updates ‐ 9/30/21Electric Fund Rate Stabilization ReserveIntended to mitigate potential rate impacts due to increased purchased power costs or other external factors. The RSR is maintained within the Electric Fund. During the annual review of fiscal policies for the FY2022 budget, Finance and Electric staff recommended updating the Electric Rate Stabilization Reserve Policy. GGAF and Council agreed to change the reserve target from 10% of purchased power costs, to an average of 3 months of purchased power costs. The Electric Fund FY2021 projected ending fund balance is $32.3 million. Of that, $18.6 million is reserve for Rate Stabilization, which is a fully funded reserve. FY2021 preliminary year‐end fund balance is $40.5 million. The Electric Fund experienced accelerated new development capital projects and will need a year‐end budget amendment for 2021 and a revised budget for 2022. After accounting for reserves and capital project roll forwards, available ending fund balance is projected to be $3.9 million.Airport MaintenanceFund on‐going maintenance of the Airport grounds, runways and taxi ways. Terminal and Tower included in Facilities ISF. An Airport Master Plan was developed to address long term capital maintenance project prioritization. Continued maintenance on buildings and pavement surfaces. We will have to do pavement sealing on Taxiway A to prevent early deterioration. This will include a seal coat and repainting of all markings. We have prepared all documentation and supporting evidence for CRRSA (the 2nd relief grant) for reimbursement. We are waiting on TxDOT to establish the process. This will be ~$57K. The relief grant has yet to be established by the FAA. We expect to get another award for that as well. No change.Americans with Disabilities Act (ADA) Compliance NeedsAs facilities are built or repurposed, meeting ADA compliance will be included in Project Costs. Funding for program expansion will be needed (General Fund sources). The City has an adopted policy, as required by Federal Law, that it will make reasonable accommodations and modifications to ensure that people with disabilities have an equal opportunity to enjoy its programs, services, and activities. The City does not maintain a reserve for these modifications.ADA trail improvements along the South San Gabriel Trail have begun and consist of replacement of non‐compliant sections of trail from Chandler Park to just west of Interstate 35. ADA improvements to Summercrest Park, Old Town Park, Edwards Park, and Bark Park have been completed.ADA trail improvements along the San Gabriel River are nearing completion. Planning and design is underway for areas along the South San Gabriel River Trail. The final trail and park ADA improvements are scheduled to be completed in FY22. 85 Unfunded Liability & CommitmentsFinancial Impact/NotesStatus Updates ‐ 6/30/21Status Updates ‐ 9/30/21Sidewalk Maintenance & MasterplanCurrently, new sidewalks are built as development occurs. Repairs are funded as needed or if funding is available, when major roads are repaired. Useful life of a sidewalk is estimated at 40 to 50 years. The largest revenue source comes from the City’s General Fund, but there has been some debt funding as well. Rock Sidewalk/FY 20 Downtown ADA Sidewalk Improvements. Project is in construction. Contractor working along Rock Street at this time. Should be completed with the Rock Street area from 9th to 7th by the end of August and then moving east of Austin Ave on 7th. FY21 Downtown ADA Sidewalk improvements will be a continuation of Downtown ADA improvements and closing gaps. Design for this project will begin in May 2021. The mobility bond passed in the May election, providing new funding over the next 7 years for sidewalks.Rock Sidewalk/FY 20 Downtown ADA Sidewalk Improvements. Project is in construction. Contractor wrapped up most work along Rock Street. Currently working at 7th and 8th streets at Austin Ave. Will move over to 7th and Main area next. FY21 Downtown ADA Sidewalk improvements will be a continuation of Downtown ADA improvements and closing gaps. Design/survey work has begun. The mobility bond passed in the May election, providing new funding over the next 7 years for sidewalks.Park Equipment Maintenance & ReplacementOver the past 5 years, funding for Park Maintenance and Replacement has increased. $200K transfer from General Fund included in FY2018 budget. Staff has listed all assets & developed replacement schedule funded by the General Fund.Staff has begun the planning process for redevelopment of University Park to include playground replacement, landscape improvements and additional site amenities. A survey was sent to neighborhood residents and is currently being reviewed by staff. A neighborhood public meeting will be scheduled to discuss the survey results in September. The project budget totals $110,000. Park maintenance and replacement is funded for $297,000 in FY22 through a general fund transfer into the Parks Restricted SRF. Identified repair and replacement needs total $409,000. Capital repair and maintenance projects at the Recreation Center, Pinnacle Park and Raintree Park are scheduled to be completed later in FY22. Identified repair and replacement costs for FY23 and FY24 are $780,700 and $455,800 respectively. Radio Equipment ReplacementCommunication system consisting of 500 on‐body and in‐vehicle radios for Police, Fire, parks and utilities. Replacement radios are compatible with newer technology. The replacement takes place over 5 years due to cost and is funded with certificate of obligation debt. Radios for the Electric, 911 Comms, and GPD have been received and in the process of issued out to the departments. Finalizing the radio type (mobile or portable) for the remaining 35 radio replacements. These will be ordered by late August early September. Due to the unexpected retirement of Fleet staff, we were unable to spend the remaining funds and have asked for these funds to roll forward to FY22 which was approved. 86 Unfunded Liability & CommitmentsFinancial Impact/NotesStatus Updates ‐ 6/30/21Status Updates ‐ 9/30/21Street MaintenanceThe City funds street maintenance in the General Fund, supplemented by a 1/8th Street Sales Tax special revenue fund. In 2017 and 2018, the Council and GTAB reviewed various methods for enhanced street maintenance and costs. Direction from Council is to use high performance surface seals and pavement wearing courses and begin programmatically addressing the street network's deferred maintenance backlog, creating a need for approximately $2 million more per year for street maintenance.The FY2022 budget restores $500,000 General Fund contribution to street maintenance.Staff received direction from Council on potential uses of available Street Maintenance sales tax dollars and will make these updates in an FY2022 budget amendment.Fiber Asset AllocationNetwork fiber infrastructure is installed across the City. Traditionally, the Electric Fund has installed and maintained the network. In reviewing all costs for the Electric Fund, the City has begun moving the fiber asset to the IT Fund. Staff must develop a multi‐year strategy to complete the asset transfer and allocate costs for maintenance.Cost recovery for the Fiber asset transfer was continued in the FY 2022 budget, with $665,000 being transferred from the IT internal service fund to the Electric fund. No changeIT Capital Replacement ReserveThe purpose of this reserve is to fund the maintenance and replacement of computer network and other technology systems. A reserve will be established within the ISF for replacement of major systems and will be funded over time through excess revenues within the Fund. The targeted amount is the average (1/5th) of the next five years on the replacement schedule. The IT allocation model continues to be structured in a way that establishes and maintains a reserve in the ISF. This fund is $270K short of meeting the reserve requirement for FY2022.No Change. Council gave no direction during the Fiscal Policy update on reserves not in compliance.87 Unfunded Liability & CommitmentsFinancial Impact/NotesStatus Updates ‐ 6/30/21Status Updates ‐ 9/30/21Facilities Maintenance ReserveThe City has established an on‐going maintenance program, which includes major repairs, equipment, as well as contracts for maintaining City facilities. The City has anticipated a useful life of such equipment and established a means of charging those costs to the various departments in order to recognize the City’s continuing costs of maintaining its facilities. Determination for facility repairs is based on useful life of the various elements of each facility. A proportional cost for each element is expensed within the budget for capital replacement. The targeted replacement reserve amount is the average (1/5th) of the next five years on the replacement schedule. This reserve is $800K short of meeting the reserve requirement for FY2022.No Change. Council gave no direction during the Fiscal Policy update on reserves not in compliance.Public Safety Equipment Recurring Line Item BudgetsAs part of the City’s on‐going maintenance program, the City also recognizes the need to regularly maintain and replace specialized equipment in Police and Fire. Separate replacement and maintenance schedules will be maintained for these items including but not limited to for Fire: SCBA’s and other firefighting equipment and protective gear; and for Police: bullet proof vests, armaments and other tactical equipment. The City’s goal is to provide level on‐going funding to ensure proper protection for employees and residents. The current funding level is an annual appropriation in the General Fund of $80,000 for Fire and $88,000 for Police.These funding lines were restored in the FY2022 budget. No Change. Joint Services Fund 90 Day Operational Contingency ReserveA minimum ninety (90) days of operating expenses will be reserved for unexpected delays in revenue or emergency expenses. This fund is $1.1M short of meeting the reserve requirement for FY2022.FY2021 preliminary year‐end fund balance is estimated to be $2.4 million. Council gave no direction during the Fiscal Policy update on reserves not in compliance. In FY2022, several staff and services re‐organizations are shifting costs out of the Joint Services Fund and into the General Fund and Water Fund. The allocation methodology and reserve calculations will be updated. These shifts will help reduce the burden on the unmet reserve. The Cost Allocation Study results will be presented to Council in early 2022, which options on how to fully fund the reserve.88