Loading...
HomeMy WebLinkAboutAgenda_GWUAB_06.10.2021Notice of Meeting for the Georgetown Water Utility B oard of the City of Georgetown June 10, 2021 at 2:00 P M at West Side Serv ice Center, 5501 Williams Dr., Georgetown, T X, 78633 and v irtually T he C ity of G eorgetown is committed to compliance with the Americans with Disabilities Act (ADA). If you require as s is tance in partic ipating at a public meeting due to a disability, as defined under the ADA, reas onable as s is tance, adaptations , or ac commodations will be provided upon request. P leas e c ontact the C ity S ec retary's O ffic e, at leas t three (3) days prior to the sc heduled meeting date, at (512) 930-3652 or C ity Hall at 808 Martin Luther King Jr. S treet, G eorgetown, T X 78626 for additional information; T T Y users route through R elay Texas at 711. T HI S AG E N DA H A S B E E N R E V I S E D F R O M O R I GI N A L P O S T I N G. 06.07.2021 8:38 am The Georgetown Water U (lity A dvisory Board (G W UA B ) is now mee(ng in person. A quorum of the Georgetown Water U (lity A dvisory B oard (GW UA B) will be in a6endance at the West S ide S ervice C enter (W S S C ), 5501 Williams Dr., Georgetown, T X ., 78633. I t is possible that one or more board members may a6end via video C onference using the Zoom client. To allow for as much ci(zen par(cipa(on as possible, ci(zen comments are accepted either in person or via the Zoom client. Face masks are encouraged. U se of profanity, threatening language, slanderous remarks or threats of harm are not allowed and will result in you being immediately removed from the mee(ng. I f you have ques(ons or need assistance, please contact the board liaison at (na.davis@georgetown.org or at 512-930-3556. To par(cipate virtually, please copy and paste the following weblink into your browser: https://geor getowntx.zoom.us/j/96267346005? pwd=W S t S U H V M M 2p O c E 1 RTW V F S 2 J x W Xl V Zz09 M e eting I D: 962 6734 6005 P assc ode : 535257 O r by phone, 888-475-4499 O R 833-548-0276 O R 833-548-0282 O R 877-853- 5257 Citizen comme nts are acc epted in the following for mats: Submit written comme nts to tina.davis@geor getown.or g by 12:00 p.m. on the date of the mee ting and the R ec ording S ec re tary will forward Page 1 of 115 your c omments to the board be for e the mee ting. L og onto the mee ng at the link above and “raise your hand” during the item, or aend the mee ng and sign-up to speak in-person for an item posted on the agenda. To join a Zoom mee(ng, click on the link provided and join as an a6endee. You will be asked to enter your name and email address (this is so we can iden(fy you when you are called upon). To speak on an item, click on the “Raise your Hand” op(on at the bo6om of the Zoom mee(ng webpage once that item has opened. When you are called upon by the Recording S ecretary, your device will be remotely un- muted by the A dministrator and you may speak for three minutes. P lease state your name clearly, and when your (me is over, your device will be muted again. Regular Session (T his R egular S es s ion may, at any time, be rec es s ed to c onvene an Exec utive S es s ion for any purpose authorized by the O pen Meetings Act, Texas G overnment C ode 551.) A C all to O rder. T homas G lab, Board C hair B Monthly report from Water Utility Direc tors - C hels ea S olomon, Water Utility Direc tor C Disc ussion on how this virtual c onference will be c onducted, to inc lude options for public c omments and how the public may addres s the C ommis s ion - C hels ea S olomon D P ublic Wis hing to Address the Board. -- T homas G lab, Board C hair O n a subject not pos ted on the agenda: P ers ons may add an item to a future R egular sc heduled Board agenda by filing a written reques t with the S taff Liaison no later than one week prior to the Board meeting. T he request mus t inc lude the speaker’s name and the spec ific topic to be addres s ed with sufficient information to inform the board and the public . O nly thos e persons who have submitted a timely reques t will be allowed to s peak. P lease contac t the Board Liaison to sign up to s peak at: Tina.Davis @georgetown.org. At the time of posting, no one had signed up to speak. Regular Agenda E R eview and pos s ible ac tion to approve the minutes from the May 13, 2021 Water Board Meeting.-Tina Davis , Board Liais on F C ons ideration and possible recommendation on an amendment to Tas k O rder C DM-20-009 in the amount of $2,788,660 for des ign services related to the S outh Lake Water Treatment P lant -- Wesley Wright, P E, S ys tems Engineering Director G R eview and pos s ible ac tion of the G eorgetown Water Utility Advis ory Board Bylaws - Laurie Brewer, Assistant C ity Manager Adjournment Ce rtificate of Posting Page 2 of 115 I, R obyn Densmore, C ity S ecretary for the C ity of G eorgetown, Texas, do hereby c ertify that this Notic e of Meeting was posted at C ity Hall, 808 Martin Luther King Jr. S treet, G eorgetown, T X 78626, a plac e readily acc es s ible to the general public as required by law, on the _____ day of _________________, 2021, at __________, and remained s o posted for at leas t 72 c ontinuous hours prec eding the s cheduled time of said meeting. __________________________________ R obyn Dens more, C ity S ec retary Page 3 of 115 City of Georgetown, Texas Water Utility Board June 10, 2021 S UB J E C T: C all to O rder. T homas G lab, Board C hair IT E M S UMMARY: C all to O rder F IN AN C IAL IMPAC T: . S UB MIT T E D B Y: T homas G lab, Board C hair Page 4 of 115 City of Georgetown, Texas Water Utility Board June 10, 2021 S UB J E C T: Monthly report from Water Utility Directors - C helsea S olomon, Water Utility Director IT E M S UMMARY: Monthly Updates F rom Water Utility Directors F IN AN C IAL IMPAC T: . S UB MIT T E D B Y: C helsea S olomon, Water Utility Director AT TAC H ME N T S: Description Type 2md Quarter Report Combined (part of Finance presentation)Backup Material Page 5 of 115 FY2021 BUDGET AND 5 YEAR CAPITAL IMPROVEMENT PLAN Quarterly Report Page 6 of 115 FINANCIAL REPORT AND INVESTMENT REPORT For the Quarter Ended March 31, 2021 Table of Contents Executive Summary .................................................................................................................................. 1-11 General Fund Schedule ............................................................................................................................... 12 Electric Fund Schedule ................................................................................................................................ 13 Water Services Fund Schedule .................................................................................................................... 14 Joint Services Fund Schedule ....................................................................................................................... 15 Council Discretionary Fund Schedule .......................................................................................................... 16 Convention & Visitors Bureau Fund Schedule ............................................................................................. 17 Airport Fund Schedule ................................................................................................................................. 18 Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 19 Georgetown Economic Development Corporation Fund Schedule ............................................................. 20 Quarterly Investment Report - City ........................................................................................................ 21-44 Quarterly Investment Report - GEDCO ................................................................................................... 45-50 Quarterly Investment Report - GTEC ...................................................................................................... 51-56 Grant Applications ....................................................................................................................................... 57 Capital Improvement Projects ................................................................................................................ 58-63 Long-term Commitments and Other Unfunded Liabilities ..................................................................... 64-67 Page 7 of 115   F FY2021 Quarterly Report  EXECUTIVE SUMMARY FOR THE QUARTER ENDED MAR. 31, 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 Second Quarter Report Approved Budget includes Capital Project  Roll Forward and Operational Amendments Approved by Council in January 2021. The February Winter Storm Uri had  a large impact on expenses for the second quarter. Council will consider amendments related to the storm during a  formal budget amendment in June 2021, which is in the third quarter. Furthermore, this report compares actuals to  budget, and compared to the performance of actuals in the same quarter in the previous year. Due to the timing of  the COVID‐19 pandemic starting in the second quarter of last year, the quarter‐to‐quarter comparisons may in some  cases stand out. However, many of these increases or decreases were expected during the 2021 budget planning  process and are generally not a concern.     GENERAL FUND REVENUES:  General Fund revenues total $48,858,157, or 59.02% of budget through this quarter of FY2021. Revenues exceed last  year’s same quarter total by $5,191,197, or 11.89%.    COG ‐ General Fund Financial Report  Period: YTD Actuals: Q2 FY21   Budget Quarterly Comparison   FY2021  YTD Actuals:  Q2 FY20  YTD Actuals:  Q2 FY21 YTD Variance % Varaince  Revenue       Taxes  41,208,025   24,251,223    26,730,147   2,478,924   10.22% Fines and Penalties  388,392   211,780    156,400   (55,381) ‐26.15% Investment Income  75,000   156,220    43,091   (113,128) ‐72.42% Charges for Services  25,042,285   12,267,072    12,956,253   689,181   5.62% Other Miscellaneous  871,955   96,158    398,441   302,283   314.36% Donations and Grants  5,770,975   2,524,484    3,223,877   699,393   27.70% 70001:Transfers In  995,302   303,634    995,302   691,668   227.80% 70002:Transfers In ‐ ROI  8,431,375   3,856,389    4,354,647   498,258   12.92% Revenue Total  82,783,309  43,666,959  48,858,157  5,191,197 11.89%   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.          1Page 8 of 115   F FY2021 Quarterly Report  Sales  tax revenue  accounts  for  $18,576,250  of  budgeted  revenues  in  the  General  Fund,  or  22.44%.  Year‐to‐date  sales  tax  revenue  through  the  quarter  totals $7,431,798 million, or 40.01% of budget. Sales tax  data lags two months in arrears and while the impact of  COVID  and  the  consumers’  shift  to  online  retail  was  difficult to quantify, sales tax continues to have a strong  performance.  The second quarter returns for sales tax  were 16.79% 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 that period.    Property tax revenues are the second largest revenue segment in the General Fund and accounts for $15,976,505,  or 19.30% of the total revenue budget.  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 102.82% of budget, or $16,427,813. Year‐to‐date property tax revenues are 8.65% higher than  the same period last year.  Year‐to‐date property tax revenue reflects Tax Increment Reinvestment Zone revenues  and will be journaled to the appropriate TIRZ funds in the 3rd quarter.  After this transaction, staff expects property  tax collections to be on budget.      The City collects franchise fees for electric, natural gas, cable, and non‐cellular telephone services and represents  7.56% of budgeted revenue. Through the quarter, franchise fee revenues total $2,783,150 in FY2021, or 44.49% of  budget.  Franchise fee revenue is 10.94% higher than the second quarter of FY2020.    Return on Investment (ROI)  revenue  from  City‐owned  utilities  represents  $8,431,375,  or  10.18%  of  budgeted  revenues in the fund. Year‐to‐date, ROI revenues total $4,354,647, or 51.65% of budget. ROI revenue is $498,258, or  12.92% higher than the second quarter of FY2020.     Planning and Development related revenue continues to be strong in FY2021.  Planning and Development revenue  total accounts for $6,499,325, or 7.85% of total General Fund budgeted revenue. Through the quarter, planning and  development related revenue totals $3,547,521 or 54.58% of budget.   Development fees are up 33.68%, or $893,827  compared to the same quarter in 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.  276 311370 537 682 665  ‐  200  400  600  800 Q1 Q2 Residential Building Permits FY2019 FY2020 FY2021 1.5M 3.9M 1.7M 4.7M 1.8M 5.6M K 1.5M 3.0M 4.5M 6.0M Q1 Q2 GENERAL FUND SALES TAX FY2019  FY2020  FY2021 2Page 9 of 115   F FY2021 Quarterly Report    Sanitation revenue totals $10,151,764, or 12.26% of total General Fund budgeted revenue.  Through the quarter  sanitation revenue totals $5,316,194, or 52.37% of budget. Sanitation rates increased as part of the FY2021 budget  to support growing customer base as well as to support the debt service for a new transfer station.  The variance  between the same period last year is $268,642, or 5.32%.    Fire and EMS revenue account for $8,012,095, or 9.68% of total General Fund budgeted revenue.  Through the  quarter fire and EMS fee related revenue totals $4,044,351, or 50.48% 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.     Parks and Recreation fee revenue totals $1,893,234, or 2.29% of General Fund budgeted revenue.  Through the  quarter, parks and recreation related fee revenue totals $669,866, or 35.38% of budget.  Parks and Recreation  revenue is ‐44.56% compared to FY2020.  The decrease in revenue is primarily driven by programming reductions  due to COVID 19. There are related decreases in Recreation expenses.    GENERAL FUND EXPENSES:  Annual expenses through the quarter total $38,181,440, or 46.70% of budget.  This is a 4.5% decrease compared to  the same period last year. The decrease reflects the effort of the City to be fiscally conservative when planning FY2021  budget.  Staff held on various positions, cut programming costs, and decreased travel budget because of the  anticipated impact of COVID.    COG ‐ General Fund Financial Report  Period: YTD Actuals w/Encumbrances: Q2 FY21   Budget Quarterly Comparison   FY2021  YTD Actuals  w/Encumbrances:  Q2 FY20  YTD Actuals  w/Encumbrances:  Q2 FY21 YTD Variance % Varaince  Expense       Personnel  45,566,994   22,744,841   21,031,143   1,713,698  ‐7.53% Operations  34,685,857   15,132,908   16,250,215  (1,117,307)7.38% Operating Capital  295,695   1,645,267   122,912   1,522,356  ‐92.53% CIP Expense  ‐ ‐ 17,780   (17,780)0.00% Transfers  1,353,191   457,860   759,391   (301,531)65.86% Expense Total  81,751,737  39,980,876 38,181,440 1,799,436 ‐4.50   Personnel and Operations Summary  Personnel costs through the quarter total $21,031,143, or 46.15% of personnel budget. Operational costs total  $16,250,215, or 46.85%. The table above includes all expenditures in the General Fund.  Capital costs can fluctuate  from year‐to‐year based on project, timing, and various other factors, primarily in the Streets cost center.    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 is proposing  additional appropriation to cover unforeseen overtime cost and operational costs related to the storm.      3Page 10 of 115   F FY2021 Quarterly Report    Personnel and Operations Summary by Division:  Administration Services Division (Administrative Services, City Council, and City Secretary) personnel and operational  expenditures for the quarter totals $5,338,883, which represents 53.11% of budget. General Government Contracts  includes budgeted vacancy savings estimates for all General Fund departments.  Real vacancy savings is realized in   FY2021 Budget  YTD Actuals  w/Encumbrances:  Q2 FY21 Variance % of Budget  Development and Community Services      Personnel  6,157,720   2,529,677   3,628,043  41.08% Operations  13,607,117   6,070,614   7,536,503  44.61% Development and Community Services  19,764,838   8,600,291   11,164,547  43.51%       Finance Administration      Personnel  484,734   227,360   257,374  46.90% Operations  100,389   37,511   62,878  37.37% Finance Administration  585,123   264,871   320,253  45.27%       Police      Personnel  12,922,164   6,226,795   6,695,369  48.19% Operations  3,973,436   1,944,051   2,029,385  48.93% Police Total  16,895,600   8,170,846   8,724,753  48.36%       Fire and EMS      Personnel  18,084,000   8,025,483   10,058,517  44.38% Operations  4,682,312   2,438,752   2,243,560  52.08% Fire and EMS Total  22,766,312   10,464,235   12,302,077  45.96%       Administrative Services      Personnel  1,316,326   1,215,495   100,831  92.34% Operations  8,735,940   4,123,388   4,612,552  47.20% Administrative Services Total  10,052,266   5,338,883   4,713,383  53.11%       Library, Tourism, and Culture      Personnel  1,798,754   806,651   992,103  44.84% Operations  1,097,007   592,677   504,330  54.03% Library, Tourism and Culture Total  2,895,761   1,399,328   1,496,433  48.32%       Parks and Recreation      Personnel  4,803,296   1,998,198   2,805,098  41.60% Operations  4,138,542   1,930,748   2,207,794  46.65% Parks and Recreation  8,941,838   3,946,725   4,995,112  44.14% 4Page 11 of 115   F FY2021 Quarterly Report  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.    Year‐to‐date  personnel  and  operational  expenditures  for  the Development  and  Community  Services (Planning,  Inspections, Community Services, Code Enforcement, Animal Services, Environmental Services, Public Works, and  Streets) total $8,600,291, or 43.51% of budget.    Finance Administration which consists of Municipal Court totals $264,871, or 45.27% percent of budget through the  quarter.    Year‐to‐date the Library, Tourism, and Culture Division (Library and Arts and Culture) totals $1,399,328.  This consists  of $806,651 of personnel costs and $592,677 of operational costs.  As of this quarter, the Library, Tourism, and  Culture department is at 48.32% of budget.    Year‐to‐date the Parks and Recreation Division (Parks Administrations, Parks, Garey Park, Recreation, and Recreation  Programs) totals $3,946,725.  This consists of $1,998,198 of personnel costs and $1,930,748 of operational costs.  As  of this quarter, the Parks and Rec department is at 44.14% of budget.    Year‐to‐date personnel and operational expenditures for Fire and EMS through the quarter total $10,464,235 or  45.96% of budget.  Personnel is 44.38% through the quarter.    Year‐to‐date personnel and operational expenditures for Police through the quarter totals $8,170,846 or 48.36% of  budget.     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. Additional available balances will be used to cover costs  of the winter storm during the third quarter budget amendment. The timing of FEMA reimbursement for the storm  is not known.    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, 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, staff is proposing additional appropriation to cover unforeseen costs associated with the winter  storm. This amendment will post in June, or the third quarter. Therefore, expenses are reflected in this report, but  the budget will not change until the third quarter report.              5Page 12 of 115   F FY2021 Quarterly Report        COG ‐ Electric Services Financial Report  Period: Q2 FY21   Budget Quarterly Comparison   FY2021  YTD Actuals:  Q2 FY20  YTD Actuals:  Q2 FY21 YTD Variance % Variance  Operating Revenue       Taxes  120,732   2,932   2,389   (544)‐18.54% Fines and Penalties  553,724   275,840   415,395   139,555  50.59% Investment Income  5,000   3,700   20,765   17,065  461.20% Charges for Services  82,889,381   39,703,518   39,004,137   (699,381)‐1.76% Developer Contributions  1,500,000   1,793,905   3,266,695   1,472,790  82.10% 70001:Transfers In  1,379,308   ‐ 1,379,308   1,379,308  0.00% Operating Revenue Total  86,448,145  41,779,895  44,088,688  2,308,792 5.53% Non‐Operating Revenue       Other Miscellaneous Revenue  45,000   558,436   969,245   410,809  73.56% Bond Proceeds  6,648,625   ‐ ‐ ‐0.00% Non‐Operating Revenue Total  6,693,625  558,436  969,245  410,809 73.56%     Operating revenue in the Electric Fund totals $44,088,688 through the quarter, or 51.00% of budget.  Electric sales  revenue, the largest component of operating revenue, accounts for 91.36% of the overall budgeted operating  revenue.  Charges for Services is made up of electric sales revenue, administrative charges, and fees.  The largest  component, electric sales revenue totals $36,867,522, or 46.68% of budget.  Electric revenue sales are typically  higher in the summer months when consumption increases. Developer contributions were conservatively budgeted  at $1,500,000.  Year‐to‐date collection total 3,266,695, or 217.78% of budget.    The budget for non‐operating revenue totals $6,693,625 in FY2021.  This total includes bond proceeds for capital  projects in the amount of $6,648,625.  Year‐to‐date non‐operating revenue is in line with the second quarter of  FY2020.  The City will recognize bond proceeds as part of the annual debt sale in the spring, or the third quarter.                          6Page 13 of 115   F FY2021 Quarterly Report      COG ‐ Electric Services Financial Report  Period: Q2 FY21   Budget Quarterly Comparison   FY2021  YTD Actuals  w/Encumbrances:  Q2 FY20  YTD Actuals  w/Encumbrances:  Q2 FY21 YTD Variance  %  Variance  Operating Expense       CC0001 Non‐Departmental  5,506,375   2,623,678   3,366,496   (742,817)28.31% CC0521 Electric Technical  711,765   339,783   322,812   16,971 ‐4.99% CC0522 Electric Administration  8,738,050   4,517,376   4,432,996   84,379 ‐1.87% CC0524 Metering Services  2,009,379   980,754   1,072,252   (91,498)9.33% CC0525 T&D Services  2,918,996   2,133,792   2,093,770   40,022 ‐1.88% CC0537 Electric Resource  60,334,393   26,809,590   86,341,401   (59,531,812)222.05% CC0555 Electric Systems  1,578,902   766,758   779,240   (12,482)1.63% CC0557 Electrical Engineering  636,869   427,248   507,406   (80,158)18.76% Operating Expense Total  82,434,729  39,450,849  99,083,205  (59,632,356)151.16% Non‐Operating Expense       CC0001 Non‐Departmental  4,152,805   590,971   614,762  (23,791)  4.03% CC0557 Electrical Engineering  8,166,143   46,849   2,569,283  (2,522,434)  5384.17% CC0526 Systems Engineering  ‐ 1,030,860   ‐1,030,860 ‐100.00% Non‐Operating Expense Total  12,318,948  1,668,680  3,184,045 (1,515,365)90.81%   Operating  expenses  in  the  Electric  Fund  total  $99,083,205  through  the  quarter.  Year‐to‐date  purchase  power  expenses total $86,498,858, while net congestion revenue rights (CRRs) credits total $(246,957).  Net purchase power  totals $86,251,901 through the quarter.  This is due to congestion in the grid, as well as the price spike in the cost of  energy during the winter storm.    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 from the City’s current Power Cost Adjustment of 1.375 per kWh.     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 at the end of the fiscal year, and therefore will be on budget at year‐end.    Non‐operating expenditures are budgeted at $12,318,948 in FY2021. Budgeted non‐operating expenditures include  $8,166,143 for capital projects and $4,152,805 for debt service payments, both of which typically trend towards later  7Page 14 of 115   F FY2021 Quarterly Report  quarters. As previously mentioned, a significant portion of labor expenses for capital projects will be journaled at the  end of the fiscal year.    Overall, even with the challenges of the winter storm, the Electric Fund is anticipated to end the year able to meet  the 90‐day contingency reserve requirement.      Water Fund:   Year‐to‐date Operating revenue totals $49,099,372, or 69.24% of budget.   Charges for services which includes water,  wastewater, irrigation, and fees revenue total $28,640,949 through the quarter, or 69.24%.  This revenue is up  19.50% compared to the same period last year.  Impact fees total $18,800,000 in budgeted operating revenue, or  26.51%, of total operating revenue.  Through the quarter, impact fees total $19,965,449.  Water utility staff is working  to better estimate these fees for fiscal year‐end and for FY2022 planning. Total Water Fund operating revenue is up  20.82% compared to the same period last fiscal year due to growth in sales and collections in impact fees.    The budget for non‐operating revenue totals $17,412,500 in FY2021.  This total includes bond proceeds for capital  projects in the amount of $16,300,000.  The City will recognize bond proceeds as part of the annual debt sale in the  spring, or third quarter.      COG ‐ Water Services Financial Report  Period: Q2 FY21   Budget Quarterly Comparison   FY2021  YTD Actuals:  Q2 FY20  YTD Actuals:  Q2 FY21  YTD  Variance % Variance  Operating Revenue       Fines and Penalties  255,000   231,580   242,368   10,788  4.66% Investment Income  237,250   950,050   250,606   (699,444)‐73.62% Charges for Services  50,995,000   23,966,849   28,640,949   4,674,101  19.50% Impact Fees  18,800,000   15,489,022   19,965,449   4,476,426  28.90% Donations and Grants  625,000   ‐ ‐ ‐0.00% Operating Revenue Total  70,912,250  40,637,501  49,099,372  8,461,871 20.82%        Non‐Operating Revenue       Other Miscellaneous Revenue  1,112,500   888,083   43,583   (844,500)‐95.09% Bond Proceeds  16,300,000   ‐ ‐ ‐0.00% Non‐Operating Revenue Total  17,412,500  888,083  43,583  (844,500)‐95.09%     Operating expenses in the Water Fund total $25,681,704 through the quarter, or 55.27% of budget.  Operational  costs are trending slightly higher than 50%.  This is normal as large encumbrances for contracts take place at the  beginning of the fiscal year.  Personnel costs are also higher due to the winter storm overtime. Staff will continue to  monitor operational costs through the year.    Non‐operating expenditures are budgeted at $124,787,037 in FY2021. Budgeted non‐operating expenditures include  $116,395,525 for capital projects and $7,232,088 for debt service payments. Expenditures are $37,146,959 through  8Page 15 of 115   F FY2021 Quarterly Report  the quarter, which includes encumbrances for large projects. Annual principal and interest debt payments will post  to the third quarter.    Large variances between Systems Engineering and Water Operations cost centers compared to FY2020 are due to  data coding changes in the new financial software system and are not a concern.      COG ‐ Water Services Financial Report  Period: Q2 FY21   Budget Quarterly Comparison   FY2021  YTD Actuals  w/Encumbranc es: Q2 FY20  YTD Actuals  w/Encumbrances:  Q2 FY21  YTD  Variance % Variance  Operating Expense       CC0001 Non‐Departmental  4,041,064   1,794,823   2,096,476   (301,653)16.81% CC0526 Systems Engineering  ‐ 15,453,382   409,649   15,043,733  ‐97.35% CC0527 Water Services  26,385,392   12,548,450   14,541,823   (1,993,373)15.89% CC0528 Water Distribution 2,717,500   1,450,686   1,813,594   (362,908)25.02% CC0529 Water Plant  4,261,242   2,153,207   2,083,147   70,060  ‐3.25% CC0530 Wastewater  896,100   552,811   386,775   166,035  ‐30.03% CC0531 Wastewater Plant  3,956,455   2,081,504   2,060,124   21,380  ‐1.03% CC0532 Irrigation  295,000   139,631   77,896   61,735  ‐44.21% CC0553 Water Operations  3,916,787   9,559,259   2,212,220   7,347,039  ‐76.86% Operating Expense Total  46,469,539  45,944,222  25,681,704  20,262,517 ‐44.10% Non‐Operating Expense       CC0001 Non‐Departmental  4,083,411   515,954   534,920   (18,967)3.68% CC0524 Metering Services  750,000   ‐ ‐ ‐0.00% CC0526 Systems Engineering  99,630,405   3,482,714   22,386,283   (18,903,569)542.78% CC0528 Water Distribution  1,159,424   ‐ 456,600   (456,600)0.00% CC0529 Water Plant  2,757   ‐ ‐ ‐0.00% CC0530 Wastewater  3,026,798   573,079   ‐ 573,079  ‐100.00% CC0531 Wastewater Plant  2,050,000   ‐ ‐ ‐0.00% CC0532 Irrigation  121,879   11,601   ‐ 11,601  ‐100.00% CC0553 Water Operations  13,962,363   20,040   10,953,288   (10,933,248)54557.13% Non‐Operating Expense  124,787,037  4,603,388  37,146,959  32,543,571 706.95%                 9Page 16 of 115   F FY2021 Quarterly Report  OTHER MAJOR FUNDS:   Tourism  Fund:  The  COVID‐19  pandemic  significantly  impacted the tourism sector. Overall revenue in the  fund  totals  $341,760,  or  32.55%  of  budget.  Hotel  Occupancy  Tax  revenue  totals  $331,335  through  the  quarter, or 36.81% of budget.  Staff have continued to  market Georgetown and are pleased to see occupancy  rates recovering slowly but steadily.     Year to date expenses in the Convention & Visitors  Bureau Fund total $592,029 or 40.05% of budget.  Staff  will continue to monitor this fund as travel is anticipated  to pick up in the spring and summer months. The City  has  postponed  the  annual  Red  Poppy  Festival  in  the  spring  for  a  second  year  in  a  row.  This  will  impact  revenues  and  expenditures  in  the  fund  during  the  second quarter.    Airport Fund: Airport operating revenue budget totals $3,451,500. Airport Charges, the largest segment of revenue  totals $1,712,703.  This includes revenue for fuel sales, facility lease, and hangar rentals. Revenues through the  quarter are $1,658,040, or 48.04% of budget.    Operation expenses in the Airport fund total $3,921,513.  Year‐to‐date operation expenses totals $3,991,102 which  include a $2,430,989 encumbrance for annual fuel costs.  Non‐operating revenues are bond proceeds for capital  projects. Non‐operating expenses are budgeted at $908,931 for CIP expense and the Airports debt service payments.  There is no activity in non‐operating for the quarter.       II. INVESTMENTS    The investment activity and strategies described in this report comply with the Public Funds Investment Act (PFIA),  the City’s investment policy, and generally accepted accounting principles.  Activity for the second quarter of fiscal  year 2021 includes the maturing of financial institution deposits (CDs), reinvestment of CD’s, and investing of  consolidated funds in CD’s.  Interest rates for money market accounts, Treasury bills, and CD’s decreased again during  this quarter.  We are seeing a decline in rates being submitted for our competitive investment offerings due to no  positive changes in the market. We are also seeing a decline in the number of banks responding to our investment  offerings. The Federal Open Market Committee (FOMC) expect to keep the Federal Funds rate around 0%‐.25% due  to the COVID‐19 pandemic and the impacted economy for an extended period of time.  These are the lowest rates  we have seen since December 2008.  We expect the problem to be exacerbated in the Third Quarter due to the US  Treasury’s release of the billions of dollars for the American Rescue Plan. The City will continue soliciting for the best  rates to improve both diversity and yield, while keeping in mind safety and liquidity.      The Investment Reports for the quarter ending March 31, 2021, and the supporting schedules are attached.  Valley  View Consulting, L.L.C., has prepared the attached investment reports.  A component of our investment advisory  services contract includes Valley View preparing the quarterly investment reports on behalf of the City.  A summary  of the investment balances at March 31, 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 is  consolidated at 71.83%, debt service at 6.35%, and bond proceeds at 21.82%.      309K 368K 249K 321K 141K 190K K 100K 200K 300K 400K Q1 Q2 HOTEL OCCUPANCY TAX FY2019  FY2020  FY2021 10Page 17 of 115   F FY2021 Quarterly Report          CITY              Book Value  GTEC    GEDCO   12/31/20  3/31/21    12/31/20  3/31/21    12/31/20  3/31/21    Total  cash  and  investments    $258,316,790  $276,385,252    $31,693,655  $33,083,118    $10,161,540  $11,095,498    Quarter End Average  Yield  .37%   .21%    .12%  .06%    .41%  .08%     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 AAAm, Securities (Treasury Bills) must have  direct or implied backing of the Federal Government and Financial Institution Deposits (CDs and money market  accounts) must be collateralized with FDIC insurance or obligations with an implied backing from the Federal  Government.  The collateral on all City investments are monitored monthly to ensure the financial institutions carry  minimum collateral of 100% with a letter of credit or 102% with pledged securities for all of the City’s investments.   All securities held by financial institutions as collateral on behalf of the City have been reviewed and met PFIA‐ minimum rating criteria.      The City 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 PROJECTS    The projects in the Capital Improvement Program (CIP) consist of infrastructure and related construction and do not  include small capital items such as furniture, equipment, and vehicle maintenance. Maintenance‐type projects are  not capitalized as a fixed asset and are usually cash funded.  Therefore, these projects are operational in nature and  are in the departmental operating budget.       A life‐to‐date schedule for each of the approved projects is included in the quarterly report.  This means the budget  and spending in the report are for all fiscal years of the project, not just the current fiscal year or quarter. This view  provides a more comprehensive picture of the City’s capital program. Projects are grouped based on fund, division,  and cost center.     11Page 18 of 115 COG ‐ General Fund Financial Report Period: Mar‐21 Budget Period  FY2021  Mar‐21   YTD Actuals  w/Encumbrances  Variance % of Budget Beginning Fund Balance 15,548,923                15,548,923                ‐                              100.00% Revenue 40001:Property Taxes 15,976,505                315,215                      16,427,813                451,308                      102.82% 40002:Sales Taxes 18,576,250                1,585,830                  7,431,798                  (11,144,452)               40.01% 40005:Franchise Taxes 6,255,270                   311,590                      2,783,150                  (3,472,120)                 44.49% 40008:Other Taxes 400,000                      17,858                        87,386                        (312,614)                    21.85% 41001:Fines 328,392                      29,515                        107,775                      (220,617)                    32.82% 41002:Penalties 60,000                        9,962                          48,624                        (11,376)                       81.04% 42001:Interest Income 75,000                        (273)                            43,091                        (31,909)                       57.46% 43001:Fees 7,028,184                   634,010                      3,294,925                  (3,733,259)                 46.88% 43002:Garbage Charges 10,151,764                1,031,222                  5,316,194                  (4,835,570)                 52.37% 43003:Permits 4,317,750                   377,405                      2,562,111                  (1,755,639)                 59.34% 43004:Administrative Charges 3,396,447                   282,708                      1,696,251                  (1,700,196)                 49.94% 43005:Rental Revenue 148,140                      12,067                        86,772                        (61,368)                       58.57% 44001:Grant Revenue 679,884                      241,317                      433,004                      (246,880)                    63.69% 44502:Developer Contributions ‐                               253,798                      423,328                      423,328                      0.00% 44503:Interlocal Agreement Revenue 5,091,091                   1,183,773                  2,367,546                  (2,723,546)                 46.50% 45001:Misc Revenue 871,955                      83,456                        398,441                      (473,514)                    45.70% 70001:Transfers In 995,302                      ‐                              995,302                      ‐                              100.00% 70002:Transfers In ‐ ROI 8,431,375                   782,613                      4,354,647                  (4,076,728)                 51.65% Revenue Total 82,783,309                7,152,065                  48,858,157                (33,925,152)               59.02% Expense CC0001 Non‐Departmental 1,353,191                   980                              762,585                      590,606                      56.35% CC0107 Planning 1,860,789                   68,685                        789,558                      1,071,232                  42.43% CC0202 Parks Administration 662,224                      38,834                        305,057                      357,168                      46.07% CC0210 Library 2,837,904                   139,250                      1,371,235                  1,466,669                  48.32% CC0211 Parks 2,721,425                   149,038                      1,361,495                  1,359,930                  50.03% CC0212 Recreation 2,897,351                   152,822                      1,333,703                  1,563,648                  46.03% CC0213 Tennis Center 442,917                      23,390                        180,507                      262,410                      40.75% CC0214 Recreation Programs 1,237,960                   38,229                        288,675                      949,285                      23.32% CC0215 Garey Park 979,961                      50,983                        477,289                      502,672                      48.70% CC0218 Arts and Culture 57,857                        4,832                          28,093                        29,764                        48.56% CC0316 Municipal Court 585,123                      29,002                        264,871                      320,253                      45.27% CC0402 Fire Support Services/Administration 4,254,731                   209,053                      1,815,670                  2,439,060                  42.67% CC0422 Fire Emergency Services 15,932,476                658,855                      7,230,849                  8,701,626                  45.38% CC0448 EMS 2,579,106                   130,215                      1,417,575                  1,161,530                  54.96% CC0533 Environmental Services 9,662,924                   757,899                      3,775,444                  5,887,481                  39.07% CC0536 Inspection Services 1,519,534                   62,115                        633,417                      886,118                      41.68% CC0602 Administrative Services 1,893,883                   78,346                        876,168                      1,017,715                  46.26% CC0605 Community Services 353,889                      13,420                        201,966                      151,922                      57.07% CC0634 City Council Services 185,734                      23,593                        99,423                        86,311                        53.53% CC0635 City Secretary Services 1,000,047                   83,695                        473,228                      526,818                      47.32% CC0638 General Government Contracts 4,774,808                   353,655                      2,729,217                  2,045,591                  57.16% CC0655 Communications/Public Engagement 844,604                      31,700                        398,261                      446,343                      47.15% CC0702 Police Administration 2,559,766                   193,991                      1,235,898                  1,323,869                  48.28% CC0742 Police Operations 14,335,833                645,197                      6,934,948                  7,400,885                  48.37% CC0744 Animal Services 1,106,702                   50,600                        460,114                      646,588                      41.58% CC0745 Code Compliance 562,584                      25,977                        229,168                      333,416                      40.73% CC0802 Public Works 1,462,292                   333,850                      1,032,233                  430,059                      70.59% CC0846 Streets 3,086,124                   162,828                      1,474,794                  1,611,330                  47.79% Expense Total 81,751,737                4,511,034                  38,181,440                43,570,297                46.70% Excess (Deficiency) of Total Revenue over Total Requirements 1,031,571                   2,641,031                  10,676,717                11,708,288                1035.00% Ending Fund Balance 16,580,494                26,225,640                9,645,145                  158.17% Reserves Contingency 12,626,752                12,626,752                 ‐                              100.00% Benefit Payout Reserve 340,000                      340,000                      ‐                              100.00% Economic Stability Reserve 1,467,563                   1,467,563                  ‐                              100.00% Reserves Total 14,434,315                14,434,315                ‐                              100.00% Available Fund Balance 2,146,179                  11,791,325                9,645,145                  549.41% YTD Actuals Budget vs. Actuals 12Page 19 of 115 COG ‐ Electric Services Financial Report Period: Mar‐21 Budget Period  FY2021  Mar‐21   YTD Actuals  w/Encumbrances  Variance % of Budget Beginning Fund Balance 19,702,705                ‐                              19,702,705                      ‐                            100.00% Operating Revenue 40002:Sales Taxes 5,000                          387                             2,389                                 (2,611)                      47.77% 40005:Franchise Taxes 115,732                     ‐                              ‐                                     (115,732)                  0.00% 41002:Penalties 553,724                     87,911                        415,395                            (138,329)                  75.02% 42001:Interest Income 5,000                          95                                20,765                              15,765                     415.30% 43001:Fees 685,000                     65,060                        525,563                            (159,437)                  76.72% 43004:Administrative Charges 3,222,103                  268,509                     1,611,051                         (1,611,052)               50.00% 43601:Electric Sales Revenue 78,982,278                6,277,631                  36,867,522                       (42,114,756)            46.68% 44502:Developer Contributions 1,500,000                  896,117                     3,266,695                         1,766,695                217.78% 70001:RC0225 Transfer In ‐ GEDCO 1,000,000                  ‐                              1,000,000                         ‐                            100.00% 70001:RC0241 Transfer In ‐ South TIRZ 379,308                     ‐                              379,308                            ‐                            100.00% Operating Revenue Total 86,448,145                7,595,710                  44,088,688                       (42,359,457)            51.00% Opearating Expense CC0001 Non‐Departmental 5,506,375                  616,009                     3,366,496                         2,139,879                61.14% CC0521 Electric Technical Services 711,765                     32,596                        322,812                            388,953                   45.35% CC0522 Electric Administration 8,738,050                  712,730                     4,432,996                         4,305,053                50.73% CC0524 Metering Services 2,009,379                  142,210                     1,072,252                         937,127                   53.36% CC0525 T&D Services 2,918,996                  258,852                     2,093,770                         825,226                   71.73% CC0526 Systems Engineering ‐                              ‐                              166,831                            (166,831)                  0.00% CC0537 Electric Resource Management 60,334,393                8,207,405                  86,341,401                       (26,007,008)            143.10% CC0555 Electric Systems Operations 1,578,902                  60,823                        779,240                            799,663                   49.35% CC0557 Electrical Engineering 636,869                     68,341                        507,406                            129,463                   79.67% Operating Expense Total 82,434,729                10,098,967                99,083,205                       (16,648,476)            120.20% Net Operations Total 4,013,416                  (2,503,258)                 (54,994,517)                     (59,007,933)            ‐1370.27% Non‐Operating Revenue 45001:Misc Revenue 35,000                        53,977                        76,471                              (41,471)                    218.49% 45004:Sale of Property 10,000                        736,303                     892,773                            (882,773)                  8927.73% 46001:Bond Proceeds 6,648,625                  ‐                              ‐                                     6,648,625                0.00% Non‐Operating Revenue Total 6,693,625                  790,280                     969,245                            (5,724,380)               14.48% Non‐Operating Expenses CC0001 Non‐Departmental 4,152,805                  ‐                              614,762                            3,538,043                14.80% CC0557 Electrical Engineering 8,166,143                  215,458                     2,569,283                         5,596,859                31.46% Non‐Operating Expense Total 12,318,948                215,458                     3,184,045                         9,134,903                25.85% Net Non‐Operations Total (5,625,323)                 574,822                     (2,214,800)                       3,410,522                39.37% Excess (Deficiency) of Total Revenue over Total Requirements (1,611,907)                 (1,928,436)                 (57,209,317)                     (58,821,224)            3549.17% Ending Fund Balance 18,090,798                (1,928,436)                 (37,506,612)                     (55,597,410)            ‐207.32% Reserves Contingency Reserve 4,018,754            ‐                        4,018,754                   ‐                      100.00% Non‐Operational Reserve 10,594,999          ‐                        10,594,999                 ‐                      100.00% Bond Proceeds Reserve 3,477,046            ‐                        3,477,046                   ‐                      100.00% Reserves Total 18,090,799          18,090,799                       ‐                            100.00% Available Fund Balance 0                                  (55,597,411)                     55,597,411              0.00% YTD Actuals Budget vs. Actuals 13Page 20 of 115 COG ‐ Water Services Financial Report Period: Mar‐21 Budget Period  FY2021  Mar‐21   YTD Actuals  w/Encumbrances  Variance  % of Budget  Beginning Fund Balance 115,511,818               ‐                              115,511,818                    ‐                            100.00% Operating Revenue 41002:Penalties 255,000                       46,303                        242,368                            (12,632)                    95.05% 42001:Interest Income 237,250                       1,712                          250,606                            (13,356)                    105.63% 43001:Fees 4,290,000                    915,470                      4,747,148                         (457,148)                  110.66% 43005:Rental Revenue 55,000                         3,650                          55,594                              (594)                         101.08% 43602:Water Charges 32,150,000                  3,102,651                  16,574,767                       15,575,233              51.55% 43603:Wastewater Charges 14,200,000                  1,453,604                  7,127,251                         7,072,749                50.19% 43604:Irrigation Charges 300,000                       11,121                        136,188                            163,812                   45.40% 41602:Impact Fees 18,800,000                  3,899,006                  19,965,449                       (1,165,449)              106.20% 44502:Developer Contributions 625,000                       ‐                              ‐                                     625,000                   0.00% Operating Revenue Total 70,912,250                  9,433,517                  49,099,372                       21,812,878              69.24% Operating Expense CC0001 Non‐Departmental 4,041,064                    352,305                      2,096,476                         1,944,588                51.88% CC0526 Systems Engineering ‐                                5,064                          409,649                            (409,649)                  0.00% CC0527 Water Services Administration 26,385,392                  2,058,444                  14,541,823                       11,843,569              55.11% CC0528 Water Distribution 2,717,500                    563,004                      1,813,594                         903,906                   66.74% CC0529 Water Plant Management 4,261,242                    239,904                      2,083,147                         2,178,095                48.89% CC0530 Wastewater Operations 896,100                       51,208                        386,775                            509,325                   43.16% CC0531 Wastewater Plant Management 3,956,455                    338,064                      2,060,124                         1,896,331                52.07% CC0532 Irrigation Operations 295,000                       2,590                          77,896                              217,104                   26.41% CC0553 Water Operations 3,916,787                    170,195                      2,212,220                         1,704,566                56.48% Operating Expense Total 46,469,539                  3,780,776                  25,681,704                       20,787,835              55.27% Net Operations Total 24,442,711                 5,652,740                  23,417,668                       (1,025,043)              95.81% Non‐Operating Revenue 45001:Misc Revenue 1,112,500                    8,759                          43,583                              (1,068,917)              3.92% 46001:Bond Proceeds 16,300,000                  ‐                              ‐                                     (16,300,000)            0.00% Non‐Operating Revenue Total 17,412,500                  8,759                          43,583                              (17,368,917)            0.25% Non‐Operating Expenses CC0001 Non‐Departmental 4,083,411                    ‐                              534,920                            3,548,491                13.10% CC0524 Metering Services 750,000                       ‐                              ‐                                     750,000                   0.00% CC0526 Systems Engineering 99,630,405                  2,239,837                  22,949,004                       76,681,401              23.03% CC0528 Water Distribution 1,159,424                    ‐                              781,316                            378,108                   67.39% CC0529 Water Plant Management 2,757                            ‐                              ‐                                     2,757                       0.00% CC0530 Wastewater Operations 3,026,798                    ‐                              533,080                            2,493,718                17.61% CC0531 Wastewater Plant Management 2,050,000                    ‐                              ‐                                     2,050,000                0.00% CC0532 Irrigation Operations 121,879                       ‐                              9,606                                 112,273                   7.88% CC0553 Water Operations 13,962,363                  950,148                      12,748,682                       1,213,681                91.31% Non‐Operating Expenses Total 124,787,037               3,184,921                  37,146,959                       87,640,078              29.77% Net Non‐Operations Total (107,374,537)              (3,176,162)                 (37,103,376)                     70,271,161             34.56% Excess (Deficiency) of Total Revenue over Total Requirements (82,931,826)                2,476,579                  (13,685,708)                     (96,617,534)            16.50% Ending Fund Balance 32,579,992                 2,476,579                  101,826,110                    69,246,118             312.54% Reserves Contingency Reserve 9,127,742                    ‐                              9,127,742                         ‐                            100.00% Debt Service Reserve 10,000,000                  ‐                              10,000,000                       ‐                            100.00% 19,127,742                  ‐                              19,127,742                       ‐                            100.00% Available Fund Balance 13,452,250                 82,698,368                       69,246,118             614.75% YTD Actuals Budget vs. Actuals 14Page 21 of 115 COG - Joint Services Financial Report Period: Mar-21 Budget Period FY2021 Mar-21 YTD Actuals w/Encumbrances Variance % of Budget Beginning Fund Balance 2,032,470 - 2,032,470 Revenue 41002:Penalties - 3,505 15,399 15,399 0.00% 42001:Interest Income 6,250 - 4,822 (1,428) 77.16% 43001:Fees 173,600 1,290 6,660 (166,940) 3.84% 43004:Administrative Charges 17,967,880 1,497,575 8,985,447 (8,982,433) 50.01% 43005:Rental Revenue - - 100 100 0.00% 45001:Misc Revenue - - 431 431 0.00% 45002:Insurance Proceeds - 8,642 40,906 40,906 0.00% 45003:Misc Reimbursements 83,000 516 31,498 (51,503) 37.95% Revenue Total 18,230,730 1,511,528 9,085,263 (9,145,467) 49.83% Expense CC0001 Non-Departmental 609,999 83,336 659,835 (49,836) 108.17% CC0302 Finance Administration 1,222,909 86,269 635,959 586,950 52.00% CC0315 Accounting 1,295,484 83,065 669,152 626,333 51.65% CC0317 Purchasing 1,001,969 52,626 447,378 554,592 44.65% CC0321 Customer Care 5,986,413 400,067 3,068,843 2,917,570 51.26% CC0503 Organizational and Operational Excellence 342,009 11,260 139,619 202,390 40.82% CC0526 Systems Engineering 2,752,912 132,669 1,399,602 1,353,309 50.84% CC0534 Conservation 806,212 13,996 255,552 550,660 31.70% CC0637 Economic Development 568,690 30,472 274,613 294,076 48.29% CC0639 Human Resources 1,502,553 62,284 680,192 822,361 45.27% CC0640 Citywide Human Resources 1,219,444 53,145 727,612 491,832 59.67% CC0654 Legal 1,047,947 45,509 524,347 523,600 50.04% Expense Total 18,356,541 1,053,877 9,482,704 8,873,838 51.66% Excess (Deficiency) of Total Revenue over Total Requirements (125,811) 457,651 (397,440) (523,252) 315.90% Ending Fund Balance 1,906,659 1,635,030 Reserves Contingency Reserve 1,906,658 1,906,658 - 100.00% Debt Service Reserve - - 0.00% Reserve Total 1,906,658 - 1,906,658 - 100.00% Avaiable Fund Balance 1 (271,628) (271,629) -39945363.25% Actuals Budget vs. Actuals 15Page 22 of 115 COG - Council Discretionary Financial Report Period: Mar-21 Budget Period FY2021 Mar-21 YTD Actuals w/Encumbrances Variance % of Budget Beginning Fund Balance 110,483 110,483 - 100.00% Revenue Investment Income 500 - 121 (379) 24.28% 42001:Interest Income 500 - 121 (379) 24.28% Revenue Total 500 - 121 (379) 24.28% Expense Transfers 110,983 - 110,983 - 100.00% Expense Total 110,983 - 110,983 - 100.00% Excess (Deficiency) of Total Revenue over Total Requirements (110,483) - (110,862) (221,345) 100.34% Ending Fund Balance - (379) (379) #DIV/0! Actuals Budget vs. Actuals 16Page 23 of 115 COG - Tourism Financial Report Period: Mar-21 Budget Period FY2021 Mar-21 YTD Actuals w/ Encumbrances Variance % of Budget Beginning Fund Balance 1,282,917 - 1,282,917 - 100.00% Revenue 40008:Other Taxes 900,000 78,698 331,335 (568,665) 36.81% 42001:Interest Income 5,000 - 3,070 (1,930) 61.40% 45001:Misc Revenue 95,000 1,205 7,355 (87,645) 7.74% 44505:Sponsorship 50,000 - - (50,000) 0.00% Revenue Total 1,050,000 79,903 341,760 (708,240) 32.55% Expense Personnel 435,456 12,136 161,137 274,319 37.00% Operations 1,014,085 23,255 402,258 611,827 39.67% Transfers 28,634 - 28,634 - 100.00% Expense Total 1,478,175 35,391 592,029 886,146 40.05% Excess (Deficiency) of Total Revenue over Total Requirements (428,175) 44,512 (250,269) (678,445) 58.45% Reserves Contingency Reserve 305,771 305,771 100.00% Reserves Total 305,771 305,771 100.00% Ending Fund Balance 548,971 - 726,877 177,906 132.41% Actuals Budget vs. Actuals 17Page 24 of 115 COG - Airport Financial Report Period: Mar-21 Budget Period FY2021 Mar-21 YTD Actuals w/Encumbrances Variance % of Budget Beginning Fund Balance 1,428,114 - 1,428,114 - - Operating Revenue 40001:Property Taxes 40,000 - (57,018) (97,018) -142.54% 42001:Interest Income 3,000 1 2,355 (645) 78.50% 43606:Airport Charges 3,408,500 398,177 1,712,703 (1,695,797) 50.25% Operating Revenue Total 3,451,500 398,178 1,658,040 (1,793,460) 48.04% Operarting Expense Personnel 429,433 15,832 199,340 230,093 46.42% Operations 3,138,013 297,604 3,790,502 (652,489) 120.79% Operating Capital 354,067 - 1,261 352,806 0.36% Operating Expense Total 3,921,513 313,436 3,991,102 (69,589) 101.77% Total Net Operations (470,013) 84,741 (2,333,062) (1,723,870) 496.38% Non-Operating Revenue 45001:Misc Revenue 5,000 - - (5,000) 0.00% 46001:Bond Proceeds 700,000 - - (700,000) 0.00% Non-Operating Revenue Total 705,000 - - (705,000) 0.00% Non-Operating Expense CIP Expense 750,000 - - 750,000 0.00% Debt Service 158,931 - 26,899 132,032 16.92% Non-Operating Expense Total 908,931 - 26,899 882,032 2.96% Net Non-Operations Total (203,931) (26,899) 177,032 13.19% Excess (Deficiency) of Total Revenue over Total Requirements (673,944) 84,741 (2,359,961) (3,033,904) 450.17% Ending Fund Balance 754,170 (931,847) (3,310,902) -123.56% Reserves Contingency Reserve 332,917 332,917 100% Debt Service Reserve 141,478 141,478 100% Reserves Total 474,395 474,395 100% Available Fund Balance 279,775 (1,406,242) (1,686,017) -503% YTD Actuals Budget Vs. Actuals 18Page 25 of 115 COG - GTEC Financial Report Period: Mar-21 Budget Period FY2021 Mar-21 YTD Actuals w/Encumbrances Variance % of Budget Beginning Fund Balance 26,022,482 26,022,482 - 100.00% Operating Revenue 40002:Sales Taxes 8,255,000 704,723 3,302,454 (4,952,546) 40.01% 42001:Interest Income 60,000 1,616 16,769 (43,231) 27.95% Operating Revenue Total 8,315,000 706,339 3,319,223 (4,995,777) 39.92% Operarting Expense Operations 402,962 33,514 219,771 183,191 54.54% Operating Capital - - 4,140 (4,140) 0.00% Transfers 2,763,242 - 420,122 2,343,120 15.20% Operating Expense Total 3,166,204 33,514 644,034 2,522,170 20.34% Total Net Operations 5,148,796 672,826 2,675,190 (7,517,947) 51.96% Non-Operating Revenue 46001:Bond Proceeds 10,600,000 - - (10,600,000) 0.00% Non-Operating Revenue Total 10,600,000 - - (10,600,000) 0.00% Non-Operating Expense Operations 1,984,375 - - 1,984,375 0.00% CIP Expense 23,076,813 67,410 545,157 22,531,656 2.36% Debt Service 1,053,050 - 110,525 942,525 10.50% Non-Operating Expense Total 26,114,238 67,410 655,682 25,458,556 2.51% Net Non-Operations Total (15,514,238) (67,410) (655,682) 14,858,556 4.23% Excess (Deficiency) of Total Revenue over Total Requirements (10,365,442) 605,416 2,019,508 (8,345,934) 80.52% Ending Fund Balance 15,657,040 28,041,990 12,384,950 179.10% Reserves Contingency Reserve 1,984,375 1,984,375 Debt Service Reserve 3,494,232 3,494,232 Reserves Total 5,478,607 5,478,607 Available Fund Balance 10,178,433 22,563,383 12,384,950 221.68% YTD Actuals Budget Vs. Actuals 19Page 26 of 115 COG - GEDCO Financial Report Period: Mar-21 Budget Period FY2021 Mar-21 YTD Actuals w/Encumbrances Variance % of Budget Beginning Fund Balance 8,845,777 - 8,845,777 - 100.00% Operating Revenue 40002:Sales Taxes 2,063,750 176,181 825,614 (1,238,136) 40.01% 42001:Interest Income 19,000 451 21,010 2,010 110.58% Operating Revenue Total 2,082,750 176,632 846,624 (1,236,126) 40.65% Operarting Expense Operations 593,783 36,168 227,997 365,786 38.40% Transfers 1,200,169 - 1,040,084 160,085 86.66% Operating Expense Total 1,793,952 36,168 1,268,082 525,870 70.69% Total Net Operations 288,798 140,464 (421,458) (1,761,996) -145.94% Non-Operating Revenue Non-Operating Expense Operations 8,256,391 - 400,000 7,856,391 4.84% Debt Service 90,572 - - 90,572 0.00% Non-Operating Expense Total 8,346,963 - 400,000 7,946,963 4.79% Net Non-Operations Total (8,346,963) - (400,000) 7,946,963 4.79% Excess (Deficiency) of Total Revenue over Total Requirements (8,058,165) 140,464 (821,458) (8,879,623) 110.19% Ending Fund Balance 787,612 140,464 8,024,319 7,236,707 1018.82% Reserves Contingency Reserve 505,468 505,468 Debt Service Reserve 202,769 202,769 Reserves Total 708,237 708,237 Available Fund Balance 79,375 - 7,316,082 7,236,707 9217.11% YTD Actuals Budget Vs. Actuals 20Page 27 of 115 CITY QUARTERLY INVESTMENT REPORT For the Quarter Ended March 31, 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. 21Page 28 of 115 Economic Overview 3/31/2021 The 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 projected that reduced rates could remain into 2023 or longer. Fourth Quarter GDP finalized at +4.3%. March Non Farm Payroll added 916k and Unemployment declined to 6.0%. Crude oil traded above $60 per barrel. The Stock Markets reached new highs. Housing, Industrial Production, Durable Goods, Consumer Spending, and other indicators showed solid gains. An additional $1.9 trillion stimulus package passed Congress and was signed by the President. The Yield Curve continued steepening on longer maturities. 0 250 500 750 1,000 1,250 1,500 1,750 2,000 2,250 2,500 2,750 3,000 3,250 3,500 3,750 4,000 4,250 S&P 500 0.00 0.50 1.00 1.50 2.00 2.50 3.00 3.50 US Treasury Historical Yields - Since Nov 2015 Six Month T-Bill Two Year T-Note Ten Year T-Note 0.00 0.20 0.40 0.60 0.80 1.00 1.20 1.40 1.60 1.80 2.00 Treasury Yield Curves March 31, 2020 December 31, 2020 March 31, 2021 0.00 0.50 1.00 1.50 2.00 2.50 3.00 3.50 4.00 4.50 5.00 5.50 6.00 US Treasury Historical Yields - Since 2006 Six Month T-Bill Two Year T-Note Ten Year T-Note Valley View Consulting, L.L.C.22Page 29 of 115 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield Demand Accounts 15,461,481$ 15,461,481 15,550,035$ 15,550,035$ 0.22% NOW/MMA 12,024,426 12,024,426 11,019,484 11,019,484 0.33% Pools 108,820,032 108,820,032 144,095,312 144,095,312 0.02% CDs/Securities 122,010,850 122,010,850 105,720,421 105,720,421 0.45% Totals 258,316,790$ 258,316,790$ 276,385,252$ 276,385,252$ 0.21% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 0.21%Total Portfolio 0.29% Rolling Three Month Treasury 0.06%Rolling Three Month Treasury 0.08% Rolling Six Month Treasury 0.09%Rolling Six Month Treasury 0.10% TexPool 0.02%TexPool 0.05% Bank Fees Offset 10,568$ Interest earnings provided in separate report.18,679$ December 31, 2020 (1)Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank, pool, and money market balances. (2)Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. Quarterly Bank Fees Offset Year-to-date Bank Fees Offset March 31, 2021 City of Georgetown Valley View Consulting, L.L.C.23Page 30 of 115 City - Investment Holdings Coupon/Maturity Settlement Face Amount/Book Market Market Life Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield JPMorgan Chase Cash (3)0.22%04/01/21 03/31/21 15,550,035$ 15,550,035$ 1.00 15,550,035$ 1 0.22% JPMorgan Chase MMA 0.03%04/01/21 03/31/21 434,048 434,048 1.00 434,048 1 0.03% Veritex Bank MMA 0.10%04/01/21 03/31/21 3,213,253 3,213,253 1.00 3,213,253 1 0.10% NexBank MMA 0.45%04/01/21 03/31/21 7,372,182 7,372,182 1.00 7,372,182 1 0.45% TexPool AAAm 0.02%04/01/21 03/31/21 58,862,442 58,862,442 1.00 58,862,442 1 0.02% TexSTAR AAAm 0.02%04/01/21 03/31/21 85,232,871 85,232,871 1.00 85,232,871 1 0.02% Prosperity Bank CD 0.45%04/01/21 07/01/20 4,006,098 4,006,098 100.00 4,006,098 1 0.45% Independent Bank CD 1.80%04/22/21 10/22/19 4,193,238 4,193,238 100.00 4,193,238 22 1.81% Bank OZK CD 0.70%05/10/21 05/08/20 12,070,246 12,070,246 100.00 12,070,246 40 0.70% Southside Bank CD 0.22%06/11/21 09/11/20 5,005,456 5,005,456 100.00 5,005,456 72 0.22% Bank OZK CD 0.30%06/11/21 09/11/20 5,007,443 5,007,443 100.00 5,007,443 72 0.30% Prosperity Bank CD 0.60%07/01/21 07/01/20 4,012,075 4,012,075 100.00 4,012,075 92 0.60% Prosperity Bank CD 0.70%07/15/21 07/15/20 5,017,615 5,017,615 100.00 5,017,615 106 0.70% Prosperity Bank CD 0.15%08/10/21 02/10/21 3,000,345 3,000,345 100.00 3,000,345 132 0.15% Prosperity Bank CD 0.40%08/23/21 08/21/20 6,257,488 6,257,488 100.00 6,257,488 145 0.40% R Bank CD 0.47%08/25/21 02/25/21 2,000,000 2,000,000 100.00 2,000,000 147 0.47% East West Bank CD 0.26%09/09/21 12/09/20 4,072,454 4,072,454 100.00 4,072,454 162 0.26% East West Bank CD 0.21%10/08/21 01/08/21 5,002,388 5,002,388 100.00 5,002,388 191 0.21% Prosperity Bank CD 0.30%10/14/21 10/14/20 2,503,100 2,503,100 100.00 2,503,100 197 0.30% Independent Bank CD 0.40%10/18/21 10/18/20 2,549,159 2,549,159 100.00 2,549,159 201 0.40% Prosperity Bank CD 0.30%11/22/21 11/20/20 3,002,957 3,002,957 100.00 3,002,957 236 0.30% Texas Regional Bank CD 0.25%12/07/21 03/12/21 3,000,000 3,000,000 100.00 3,000,000 251 0.25% East West Bank CD 0.21%12/30/21 12/30/20 3,001,588 3,001,588 100.00 3,001,588 274 0.21% East West Bank CD 0.21%01/07/22 01/08/21 5,002,388 5,002,388 100.00 5,002,388 282 0.21% Prosperity Bank CD 0.30%01/21/22 10/21/20 4,004,960 4,004,960 100.00 4,004,960 296 0.30% Independent Bank CD 0.40%02/05/22 02/05/21 3,000,000 3,000,000 100.00 3,000,000 311 0.40% Independent Bank CD 0.40%02/08/22 02/08/21 5,000,000 5,000,000 100.00 5,000,000 314 0.40% R Bank CD 0.63%02/25/22 02/25/21 2,000,000 2,000,000 100.00 2,000,000 331 0.63% Prosperity Bank CD 0.35%04/21/22 10/21/20 2,503,617 2,503,617 100.00 2,503,617 386 0.35% Independent Bank CD 0.35%05/09/22 02/08/21 4,000,000 4,000,000 100.00 4,000,000 404 0.35% March 31, 2021 City of Georgetown Valley View Consulting, L.L.C.24Page 31 of 115 City - Investment Holdings Coupon/Maturity Settlement Face Amount/Book Market Market Life Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield March 31, 2021 Prosperity Bank CD 0.35%05/17/22 11/17/20 2,002,300 2,002,300 100.00 2,002,300 412 0.35% Prosperity Bank CD 0.35%08/22/22 11/20/20 2,502,875 2,502,875 100.00 2,502,875 509 0.35% Prosperity Bank CD 0.40%11/17/22 11/17/20 2,002,629 2,002,629 100.00 2,002,629 596 0.40% TOTALS 276,385,252$ 276,385,252$ 276,385,252$ 74 0.21% (1)(2) (2)Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds. (1)Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity. (3)Earnings Credit - The City's depository accounts provide an earnings credit on balances which is used to offset bank fees. City of Georgetown Valley View Consulting, L.L.C.25Page 32 of 115 0–6 Months 82% 6–12 Months 14% 12–18 Months 4% 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 06/30/20 09/30/20 12/31/2020 03/31/21 Portfolio Balances Money Market Local Depository TexSTAR TexPool Certificate of Deposit US Treasury 166174166 102 69 90 73 75 109104 123 156163 97108 87 51 67 49 41 91 73 61 54 99 71 124 95100 80 70 67 63 58 81 82 74 0 50 100 150 200 # o f D a y s Weighted Average to Maturity JPMorgan Chase 6%Southside Bank 2% Prosperity Bank 15% Veritex Bank 1% Bank OZK 6% NexBank 3% TexPool 21% TexSTAR 31% Independent Bank 7% Texas Regional Bank 1% East West Bank 6% R Bank 1% Portfolio Holdings by Issuer City of Georgetown Valley View Consulting, L.L.C. 26Page 33 of 115 City - Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 12/31/20 Increases Decreases Book Value 03/31/21 Market Value 12/31/20 Change in Market Value Market Value 03/31/21 JPMorgan Chase Cash 0.22%04/01/21 15,461,481$ 88,554$ –$ 15,550,035$ 15,461,481$ 88,554$ 15,550,035$ JPMorgan Chase MMA 0.03%04/01/21 434,016 32 – 434,048 434,016 32 434,048 Veritex Bank MMA 0.10%04/01/21 3,212,254 1,000 – 3,213,253 3,212,254 1,000 3,213,253 NexBank MMA 0.45%04/01/21 7,364,008 8,174 – 7,372,182 7,364,008 8,174 7,372,182 Origin Bank MMA 0.00%04/01/21 1,014,148 – (1,014,148) - 1,014,148 (1,014,148) - TexPool 0.02%04/01/21 44,199,066 14,663,376 – 58,862,442 44,199,066 14,663,376 58,862,442 TexSTAR 0.02%04/01/21 64,620,967 20,611,904 – 85,232,871 64,620,967 20,611,904 85,232,871 East West Bank CD 1.72%01/08/21 3,050,882 – (3,050,882) – 3,050,882 (3,050,882) – Independent Bank CD 1.71%02/05/21 3,139,621 – (3,139,621) – 3,139,621 (3,139,621) – Independent Bank CD 0.60%02/08/21 11,033,296 – (11,033,296) – 11,033,296 (11,033,296) – East West Bank CD 0.32%02/18/21 9,010,737 – (9,010,737) – 9,010,737 (9,010,737) – East West Bank CD 0.32%02/18/21 2,002,386 – (2,002,386) – 2,002,386 (2,002,386) – R Bank CD 1.83%02/19/21 4,054,719 – (4,054,719) – 4,054,719 (4,054,719) – Bank OZK CD 1.73%02/26/21 6,086,273 – (6,086,273) – 6,086,273 (6,086,273) – Southside Bank CD 0.21%03/11/21 5,002,618 – (5,002,618) – 5,002,618 (5,002,618) – Bank OZK CD 0.25%03/11/21 1,500,935 – (1,500,935) – 1,500,935 (1,500,935) – East West Bank CD 0.29%03/15/21 3,503,032 – (3,503,032) – 3,503,032 (3,503,032) – Prosperity Bank CD 0.45%04/01/21 4,006,098 – –4,006,098 4,006,098 – 4,006,098 Independent Bank CD 1.81%04/22/21 4,174,339 18,899 – 4,193,238 4,174,339 18,899 4,193,238 Bank OZK CD 0.70%05/10/21 12,049,407 20,839 – 12,070,246 12,049,407 20,839 12,070,246 Southside Bank CD 0.22%06/11/21 5,002,742 2,714 – 5,005,456 5,002,742 2,714 5,005,456 Bank OZK CD 0.30%06/11/21 5,003,741 3,702 – 5,007,443 5,003,741 3,702 5,007,443 Prosperity Bank CD 0.60%07/01/21 4,006,033 6,042 – 4,012,075 4,006,033 6,042 4,012,075 Prosperity Bank CD 0.70%07/15/21 5,008,798 8,817 – 5,017,615 5,008,798 8,817 5,017,615 Prosperity Bank CD 0.15%08/10/21 – 3,000,345 – 3,000,345 – 3,000,345 3,000,345 Prosperity Bank CD 0.40%08/23/21 6,251,322 6,166 – 6,257,488 6,251,322 6,166 6,257,488 R Bank CD 0.47%08/25/21 – 2,000,000 – 2,000,000 – 2,000,000 2,000,000 East West Bank CD 0.26%09/09/21 4,069,844 2,610 – 4,072,454 4,069,844 2,610 4,072,454 East West Bank CD 0.21%10/08/21 – 5,002,388 – 5,002,388 – 5,002,388 5,002,388 Prosperity Bank CD 0.30%10/14/21 2,501,250 1,850 – 2,503,100 2,501,250 1,850 2,503,100 Independent Bank CD 0.40%10/18/21 2,546,598 2,561 – 2,549,159 2,546,598 2,561 2,549,159 Prosperity Bank CD 0.30%11/22/21 3,000,738 2,219 – 3,002,957 3,000,738 2,219 3,002,957 Texas Regional Bank CD 0.25%12/07/21 – 3,000,000 – 3,000,000 – 3,000,000 3,000,000 East West Bank CD 0.21%12/30/21 3,000,035 1,554 – 3,001,588 3,000,035 1,554 3,001,588 East West Bank CD 0.21%01/07/22 – 5,002,388 – 5,002,388 – 5,002,388 5,002,388 Prosperity Bank CD 0.30%01/21/22 4,002,000 2,960 – 4,004,960 4,002,000 2,960 4,004,960 Independent Bank CD 0.40%02/05/22 – 3,000,000 – 3,000,000 – 3,000,000 3,000,000 Independent Bank CD 0.40%02/08/22 – 5,000,000 – 5,000,000 – 5,000,000 5,000,000 R Bank CD 0.63%02/25/22 – 2,000,000 – 2,000,000 – 2,000,000 2,000,000 City of Georgetown Valley View Consulting, L.L.C.27Page 34 of 115 City - Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 12/31/20 Increases Decreases Book Value 03/31/21 Market Value 12/31/20 Change in Market Value Market Value 03/31/21 Prosperity Bank CD 0.35%04/21/22 2,501,459 2,159 – 2,503,617 2,501,459 2,159 2,503,617 Independent Bank CD 0.35%05/09/22 – 4,000,000 – 4,000,000 – 4,000,000 4,000,000 Prosperity Bank CD 0.35%05/17/22 2,000,574 1,726 – 2,002,300 2,000,574 1,726 2,002,300 Prosperity Bank CD 0.35%08/22/22 2,500,717 2,158 – 2,502,875 2,500,717 2,158 2,502,875 Prosperity Bank CD 0.40%11/17/22 2,000,656 1,973 – 2,002,629 2,000,656 1,973 2,002,629 TOTAL / AVERAGE 0.21%258,316,790$ 67,467,110$ (49,398,649)$ 276,385,252$ 258,316,790$ 18,068,462$ 276,385,252$ City of Georgetown Valley View Consulting, L.L.C.28Page 35 of 115 City - Allocation Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Streets/ Vehicles 2015 CO- Stormwater 2015 GO- Roads JPMorgan Chase Cash 15,550,035$ 15,550,035$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 434,048 434,048 – – – – – Veritex Bank MMA 3,213,253 3,213,253 – – – – – NexBank MMA 7,372,182 7,372,182 – – – – – TexPool 58,862,442 58,862,442 – – – – – TexSTAR 85,232,871 20,153,413 584,286 17,544,854 137,307 93,010 2,508,839 Prosperity Bank CD 04/01/21 4,006,098 4,006,098 – – – – – Independent Bank CD 04/22/21 4,193,238 4,193,238 – – – – – Bank OZK CD 05/10/21 12,070,246 10,058,538 – – – – – Southside Bank CD 06/11/21 5,005,456 5,005,456 – – – – – Bank OZK CD 06/11/21 5,007,443 5,007,443 – – – – – Prosperity Bank CD 07/01/21 4,012,075 4,012,075 – – – – – Prosperity Bank CD 07/15/21 5,017,615 5,017,615 – – – – – Prosperity Bank CD 08/10/21 3,000,345 – – – – – – Prosperity Bank CD 08/23/21 6,257,488 6,257,488 – – – – – R Bank CD 08/25/21 2,000,000 – – – – – – East West Bank CD 09/09/21 4,072,454 4,072,454 – – – – – East West Bank CD 10/08/21 5,002,388 5,002,388 – – – – – Prosperity Bank CD 10/14/21 2,503,100 2,503,100 – – – – – Independent Bank CD 10/18/21 2,549,159 2,549,159 – – – – – Prosperity Bank CD 11/22/21 3,002,957 3,002,957 – – – – – Texas Regional Bank CD 12/07/21 3,000,000 – – – – – – East West Bank CD 12/30/21 3,001,588 3,001,588 – – – – – East West Bank CD 01/07/22 5,002,388 5,002,388 – – – – – Prosperity Bank CD 01/21/22 4,004,960 4,004,960 – – – – – Independent Bank CD 02/05/22 3,000,000 3,000,000 – – – – – Independent Bank CD 02/08/22 5,000,000 4,000,000 – – – – – R Bank CD 02/25/22 2,000,000 – – – – – – Prosperity Bank CD 04/21/22 2,503,617 2,503,617 – – – – – Independent Bank CD 05/17/22 4,000,000 4,000,000 – – – – – Prosperity Bank CD 05/17/22 2,002,300 2,002,300 – – – – – Prosperity Bank CD 08/22/22 2,502,875 2,502,875 – – – – – Prosperity Bank CD 11/17/22 2,002,629 2,002,629 – – – – – Totals 276,385,252$ 198,293,742$ 584,286$ 17,544,854$ 137,307$ 93,010$ 2,508,839$ Book Value March 31, 2021 City of Georgetown Valley View Consulting, L.L.C.29Page 36 of 115 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Veritex Bank MMA NexBank MMA TexPool TexSTAR Prosperity Bank CD 04/01/21 Independent Bank CD 04/22/21 Bank OZK CD 05/10/21 Southside Bank CD 06/11/21 Bank OZK CD 06/11/21 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 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 05/17/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 11/17/22 Totals Book Value March 31, 2021 (Continued) 2015 Revenue Water WW 2016 CO- Streets/ Facilities/ Equip 2016 GO- Roads 2016 Revenue Water/WW Garey Park Donation 2017 CO Facilities/ Public Safety/ Equipment 2017 Revenue Electric –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,531,841 68,606 1,429,234 1,420,244 246,565 178,450 97,383 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,531,841$ 68,606$ 1,429,234$ 1,420,244$ 246,565$ 178,450$ 97,383$ City of Georgetown Valley View Consulting, L.L.C.30Page 37 of 115 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Veritex Bank MMA NexBank MMA TexPool TexSTAR Prosperity Bank CD 04/01/21 Independent Bank CD 04/22/21 Bank OZK CD 05/10/21 Southside Bank CD 06/11/21 Bank OZK CD 06/11/21 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 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 05/17/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 11/17/22 Totals Book Value March 31, 2021 (Continued) 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Parks 2018 GO- Roads 2019 CO- Streets/ Facilities/ Equip 2019 CO- Stormwater –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,746,916 56,700 672,317 445,286 6,628,059 4,686,290 87,973 – – – – – – – – – – – – – – 2,011,708 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 3,000,345 – – – – – – – – – – – – – – – – – – 2,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 3,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 11,758,969$ 56,700$ 672,317$ 445,286$ 6,628,059$ 6,686,290$ 87,973$ City of Georgetown Valley View Consulting, L.L.C.31Page 38 of 115 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Veritex Bank MMA NexBank MMA TexPool TexSTAR Prosperity Bank CD 04/01/21 Independent Bank CD 04/22/21 Bank OZK CD 05/10/21 Southside Bank CD 06/11/21 Bank OZK CD 06/11/21 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 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 05/17/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 11/17/22 Totals Book Value March 31, 2021 (Continued) 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 CO- Stormwater 2020 GO- Roads 2020 Revenue- Electric 2020 Revenue- Water/WW Electric-LCRA Transformers –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,247,736 1,910,744 650,627 8,547,474 486,572 6,675,600 4,396,545 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 3,247,736$ 1,910,744$ 650,627$ 8,547,474$ 486,572$ 6,675,600$ 4,396,545$ City of Georgetown Valley View Consulting, L.L.C.32Page 39 of 115 City - Allocation March 31, 2021 Market Value Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Streets/ Vehicles 2015 CO- Stormwater 2015 GO- Roads JPMorgan Chase Cash 15,550,035$ 15,550,035$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 434,048 434,048 – – – – – Veritex Bank MMA 3,213,253 3,213,253 – – – – – NexBank MMA 7,372,182 7,372,182 – – – – – TexPool 58,862,442 58,862,442 – – – – – TexSTAR 85,232,871 20,153,413 584,286 17,544,854 137,307 93,010 2,508,839 Prosperity Bank CD 04/01/21 4,006,098 4,006,098 – – – – – Independent Bank CD 04/22/21 4,193,238 4,193,238 – – – – – Bank OZK CD 05/10/21 12,070,246 10,058,538 – – – – – Southside Bank CD 06/11/21 5,005,456 5,005,456 – – – – – Bank OZK CD 06/11/21 5,007,443 5,007,443 – – – – – Prosperity Bank CD 07/01/21 4,012,075 4,012,075 – – – – – Prosperity Bank CD 07/15/21 5,017,615 5,017,615 – – – – – Prosperity Bank CD 08/10/21 3,000,345 – – – – – – Prosperity Bank CD 08/23/21 6,257,488 6,257,488 – – – – – R Bank CD 08/25/21 2,000,000 – – – – – – East West Bank CD 09/09/21 4,072,454 4,072,454 – – – – – East West Bank CD 10/08/21 5,002,388 5,002,388 – – – – – Prosperity Bank CD 10/14/21 2,503,100 2,503,100 – – – – – Independent Bank CD 10/18/21 2,549,159 2,549,159 – – – – – Prosperity Bank CD 11/22/21 3,002,957 3,002,957 – – – – – Texas Regional Bank CD 12/07/21 3,000,000 – – – – – – East West Bank CD 12/30/21 3,001,588 3,001,588 – – – – – East West Bank CD 01/07/22 5,002,388 5,002,388 – – – – – Prosperity Bank CD 01/21/22 4,004,960 4,004,960 – – – – – Independent Bank CD 02/05/22 3,000,000 3,000,000 – – – – – Independent Bank CD 02/08/22 5,000,000 4,000,000 – – – – – R Bank CD 02/25/22 2,000,000 – – – – – – Prosperity Bank CD 04/21/22 2,503,617 2,503,617 – – – – – Independent Bank CD 05/17/22 4,000,000 4,000,000 – – – – – Prosperity Bank CD 05/17/22 2,002,300 2,002,300 – – – – – Prosperity Bank CD 08/22/22 2,502,875 2,502,875 – – – – – Prosperity Bank CD 11/17/22 2,002,629 2,002,629 – – – – – Totals 276,385,252$ 198,293,742$ 584,286$ 17,544,854$ 137,307$ 93,010$ 2,508,839$ City of Georgetown Valley View Consulting, L.L.C.33Page 40 of 115 City - Allocation March 31, 2021 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Veritex Bank MMA NexBank MMA TexPool TexSTAR Prosperity Bank CD 04/01/21 Independent Bank CD 04/22/21 Bank OZK CD 05/10/21 Southside Bank CD 06/11/21 Bank OZK CD 06/11/21 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 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 05/17/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 11/17/22 Totals (Continued) 2015 Revenue Water WW 2016 CO- Streets/ Facilities/ Equip 2016 GO- Roads 2016 Revenue Water/WW Garey Park Donation 2017 CO Facilities/ Public Safety/ Equipment 2017 Revenue Electric –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,531,841 68,606 1,429,234 1,420,244 246,565 178,450 97,383 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,531,841$ 68,606$ 1,429,234$ 1,420,244$ 246,565$ 178,450$ 97,383$ City of Georgetown Valley View Consulting, L.L.C.34Page 41 of 115 City - Allocation March 31, 2021 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Veritex Bank MMA NexBank MMA TexPool TexSTAR Prosperity Bank CD 04/01/21 Independent Bank CD 04/22/21 Bank OZK CD 05/10/21 Southside Bank CD 06/11/21 Bank OZK CD 06/11/21 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 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 05/17/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 11/17/22 Totals (Continued) 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Parks 2018 GO- Roads 2019 CO- Streets/ Facilities/ Equip 2019 CO- Stormwater –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,746,916 56,700 672,317 445,286 6,628,059 4,686,290 87,973 – – – – – – – – – – – – – – 2,011,708 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 3,000,345 – – – – – – – – – – – – – – – – – – 2,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 3,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 11,758,969$ 56,700$ 672,317$ 445,286$ 6,628,059$ 6,686,290$ 87,973$ City of Georgetown Valley View Consulting, L.L.C.35Page 42 of 115 City - Allocation March 31, 2021 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Veritex Bank MMA NexBank MMA TexPool TexSTAR Prosperity Bank CD 04/01/21 Independent Bank CD 04/22/21 Bank OZK CD 05/10/21 Southside Bank CD 06/11/21 Bank OZK CD 06/11/21 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 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 05/17/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 11/17/22 Totals (Continued) 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 CO- Stormwater 2020 GO- Roads 2020 Revenue- Electric 2020 Revenue- Water/WW Electric-LCRA Transformers –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,247,736 1,910,744 650,627 8,547,474 486,572 6,675,600 4,396,545 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,000,000 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 3,247,736$ 1,910,744$ 650,627$ 8,547,474$ 486,572$ 6,675,600$ 4,396,545$ City of Georgetown Valley View Consulting, L.L.C.36Page 43 of 115 City - Allocation Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Streets/ Vehicles 2015 CO- Stormwater 2015 GO- Roads JPMorgan Chase Cash 15,461,481$ 15,461,481$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 434,016 434,016 – – – – – Veritex Bank MMA 3,212,254 3,212,254 – – – – – NexBank MMA 7,364,008 7,364,008 – – – – – Origin Bank MMA 1,014,148 – – – – – – TexPool 44,199,066 44,199,066 – – – – – TexSTAR 64,620,967 8,950,006 584,231 3,875,899 137,294 93,001 2,508,604 East West Bank CD 01/08/21 3,050,882 3,050,882 – – – – – Independent Bank CD 02/05/21 3,139,621 3,139,621 – – – – – Independent Bank CD 02/08/21 11,033,296 8,024,216 – – – – – East West Bank CD 02/18/21 9,010,737 3,003,579 – – – – – East West Bank CD 02/18/21 2,002,386 – – – – – – R Bank CD 02/19/21 4,054,719 4,054,719 – – – – – Bank OZK CD 02/26/21 6,086,273 6,086,273 – – – – – Southside Bank CD 03/11/21 5,002,618 5,002,618 – – – – – Bank OZK CD 03/11/21 1,500,935 1,500,935 – – – – – East West Bank CD 03/15/21 3,503,032 3,503,032 – – – – – Prosperity Bank CD 04/01/21 4,006,098 4,006,098 – – – – – Independent Bank CD 04/22/21 4,174,339 4,174,339 – – – – – Bank OZK CD 05/10/21 12,049,407 10,041,172 – – – – – Southside Bank CD 06/11/21 5,002,742 5,002,742 – – – – – Bank OZK CD 06/11/21 5,003,741 5,003,741 – – – – – Prosperity Bank CD 07/01/21 4,006,033 4,006,033 – – – – – Prosperity Bank CD 07/15/21 5,008,798 5,008,798 – – – – – Prosperity Bank CD 08/23/21 6,251,322 6,251,322 – – – – – East West Bank CD 09/09/21 4,069,844 4,069,844 – – – – – Prosperity Bank CD 10/14/21 2,501,250 2,501,250 – – – – – Independent Bank CD 10/18/21 2,546,598 2,546,598 – – – – – Prosperity Bank CD 11/22/21 3,000,738 3,000,738 – – – – – East West Bank CD 12/30/21 3,000,035 3,000,035 – – – – – Prosperity Bank CD 01/21/22 4,002,000 4,002,000 – – – – – Prosperity Bank CD 04/21/22 2,501,459 2,501,459 – – – – – Prosperity Bank CD 05/17/22 2,000,574 2,000,574 – – – – – Prosperity Bank CD 08/22/22 2,500,717 2,500,717 – – – – – Prosperity Bank CD 11/17/22 2,000,656 2,000,656 – – – – – Totals 258,316,790$ 188,604,822$ 584,231$ 3,875,899$ 137,294$ 93,001$ 2,508,604$ December 31, 2020 Book Value City of Georgetown Valley View Consulting, L.L.C.37Page 44 of 115 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Veritex Bank MMA NexBank MMA Origin Bank MMA TexPool TexSTAR East West Bank CD 01/08/21 Independent Bank CD 02/05/21 Independent Bank CD 02/08/21 East West Bank CD 02/18/21 East West Bank CD 02/18/21 R Bank CD 02/19/21 Bank OZK CD 02/26/21 Southside Bank CD 03/11/21 Bank OZK CD 03/11/21 East West Bank CD 03/15/21 Prosperity Bank CD 04/01/21 Independent Bank CD 04/22/21 Bank OZK CD 05/10/21 Southside Bank CD 06/11/21 Bank OZK CD 06/11/21 Prosperity Bank CD 07/01/21 Prosperity Bank CD 07/15/21 Prosperity Bank CD 08/23/21 East West Bank CD 09/09/21 Prosperity Bank CD 10/14/21 Independent Bank CD 10/18/21 Prosperity Bank CD 11/22/21 East West Bank CD 12/30/21 Prosperity Bank CD 01/21/22 Prosperity Bank CD 04/21/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 11/17/22 Totals December 31, 2020 Book Value (Continued) 2015 Revenue Water WW 2016 CO- Streets/ Facilities/ Equip 2016 GO- Roads 2016 Revenue Water/WW Garey Park Donation 2017 CO Facilities/ Public Safety/ Equipment 2017 Revenue Electric –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,531,698 68,600 1,429,101 1,456,708 254,936 178,433 97,374 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,531,698$ 68,600$ 1,429,101$ 1,456,708$ 254,936$ 178,433$ 97,374$ City of Georgetown Valley View Consulting, L.L.C.38Page 45 of 115 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Veritex Bank MMA NexBank MMA Origin Bank MMA TexPool TexSTAR East West Bank CD 01/08/21 Independent Bank CD 02/05/21 Independent Bank CD 02/08/21 East West Bank CD 02/18/21 East West Bank CD 02/18/21 R Bank CD 02/19/21 Bank OZK CD 02/26/21 Southside Bank CD 03/11/21 Bank OZK CD 03/11/21 East West Bank CD 03/15/21 Prosperity Bank CD 04/01/21 Independent Bank CD 04/22/21 Bank OZK CD 05/10/21 Southside Bank CD 06/11/21 Bank OZK CD 06/11/21 Prosperity Bank CD 07/01/21 Prosperity Bank CD 07/15/21 Prosperity Bank CD 08/23/21 East West Bank CD 09/09/21 Prosperity Bank CD 10/14/21 Independent Bank CD 10/18/21 Prosperity Bank CD 11/22/21 East West Bank CD 12/30/21 Prosperity Bank CD 01/21/22 Prosperity Bank CD 04/21/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 11/17/22 Totals December 31, 2020 Book Value (Continued) 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Parks 2018 GO- Roads 2019 CO- Streets/ Facilities/ Equip 2019 CO- Stormwater –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – 1,014,148 – – – – – – – – – – – – – 3,241,881 56,694 672,254 482,661 9,137,064 3,936,963 113,952 – – – – – – – – – – – – – – 3,009,081 – – – – – – 3,003,579 – – – – 3,003,579 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,008,234 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 12,276,924$ 56,694$ 672,254$ 482,661$ 9,137,064$ 6,940,543$ 113,952$ City of Georgetown Valley View Consulting, L.L.C.39Page 46 of 115 City - Allocation JPMorgan Chase Cash JPMorgan Chase MMA Veritex Bank MMA NexBank MMA Origin Bank MMA TexPool TexSTAR East West Bank CD 01/08/21 Independent Bank CD 02/05/21 Independent Bank CD 02/08/21 East West Bank CD 02/18/21 East West Bank CD 02/18/21 R Bank CD 02/19/21 Bank OZK CD 02/26/21 Southside Bank CD 03/11/21 Bank OZK CD 03/11/21 East West Bank CD 03/15/21 Prosperity Bank CD 04/01/21 Independent Bank CD 04/22/21 Bank OZK CD 05/10/21 Southside Bank CD 06/11/21 Bank OZK CD 06/11/21 Prosperity Bank CD 07/01/21 Prosperity Bank CD 07/15/21 Prosperity Bank CD 08/23/21 East West Bank CD 09/09/21 Prosperity Bank CD 10/14/21 Independent Bank CD 10/18/21 Prosperity Bank CD 11/22/21 East West Bank CD 12/30/21 Prosperity Bank CD 01/21/22 Prosperity Bank CD 04/21/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 11/17/22 Totals December 31, 2020 Book Value (Continued) 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 CO- Stormwater 2020 GO- Roads 2020 Revenue- Electric 2020 Revenue- Water/WW Electric-LCRA Transformers –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,961,455 2,602,887 650,566 8,708,689 1,241,086 7,169,062 3,479,865 – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,002,386 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 3,963,841$ 2,602,887$ 650,566$ 8,708,689$ 1,241,086$ 7,169,062$ 3,479,865$ City of Georgetown Valley View Consulting, L.L.C.40Page 47 of 115 City - Allocation December 31, 2020 Market Value Investment Total Consolidated 2014 Revenue Water WW Debt Service 2015 CO- Parks/Streets/ Vehicles 2015 CO- Stormwater 2015 GO- Roads JPMorgan Chase Cash 15,461,481$ 15,461,481$ –$ –$ –$ –$ –$ JPMorgan Chase MMA 434,016 434,016 – – – – – Veritex Bank MMA 3,212,254 3,212,254 – – – – – NexBank MMA 7,364,008 7,364,008 – – – – – Origin Bank MMA 1,014,148 – – – – – – TexPool 44,199,066 44,199,066 – – – – – TexSTAR 64,620,967 8,950,006 584,231 3,875,899 137,294 93,001 2,508,604 East West Bank CD 01/08/21 3,050,882 3,050,882 – – – – – Independent Bank CD 02/05/21 3,139,621 3,139,621 – – – – – Independent Bank CD 02/08/21 11,033,296 8,024,216 – – – – – East West Bank CD 02/18/21 9,010,737 3,003,579 – – – – – East West Bank CD 02/18/21 2,002,386 – – – – – – R Bank CD 02/19/21 4,054,719 4,054,719 – – – – – Bank OZK CD 02/26/21 6,086,273 6,086,273 – – – – – Southside Bank CD 03/11/21 5,002,618 5,002,618 – – – – – Bank OZK CD 03/11/21 1,500,935 1,500,935 – – – – – East West Bank CD 03/15/21 3,503,032 3,503,032 – – – – – Prosperity Bank CD 04/01/21 4,006,098 4,006,098 – – – – – Independent Bank CD 04/22/21 4,174,339 4,174,339 – – – – – Bank OZK CD 05/10/21 12,049,407 10,041,172 – – – – – Southside Bank CD 06/11/21 5,002,742 5,002,742 – – – – – Bank OZK CD 06/11/21 5,003,741 5,003,741 – – – – – Prosperity Bank CD 07/01/21 4,006,033 4,006,033 – – – – – Prosperity Bank CD 07/15/21 5,008,798 5,008,798 – – – – – Prosperity Bank CD 08/23/21 6,251,322 6,251,322 – – – – – East West Bank CD 09/09/21 4,069,844 4,069,844 – – – – – Prosperity Bank CD 10/14/21 2,501,250 2,501,250 – – – – – Independent Bank CD 10/18/21 2,546,598 2,546,598 – – – – – Prosperity Bank CD 11/22/21 3,000,738 3,000,738 – – – – – East West Bank CD 12/30/21 3,000,035 3,000,035 – – – – – Prosperity Bank CD 01/21/22 4,002,000 4,002,000 – – – – – Prosperity Bank CD 04/21/22 2,501,459 2,501,459 – – – – – Prosperity Bank CD 05/17/22 2,000,574 2,000,574 – – – – – Prosperity Bank CD 08/22/22 2,500,717 2,500,717 – – – – – Prosperity Bank CD 11/17/22 2,000,656 2,000,656 – – – – – Totals 258,316,790$ 188,604,822$ 584,231$ 3,875,899$ 137,294$ 93,001$ 2,508,604$ City of Georgetown Valley View Consulting, L.L.C.41Page 48 of 115 City - Allocation December 31, 2020 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Veritex Bank MMA NexBank MMA Origin Bank MMA TexPool TexSTAR East West Bank CD 01/08/21 Independent Bank CD 02/05/21 Independent Bank CD 02/08/21 East West Bank CD 02/18/21 East West Bank CD 02/18/21 R Bank CD 02/19/21 Bank OZK CD 02/26/21 Southside Bank CD 03/11/21 Bank OZK CD 03/11/21 East West Bank CD 03/15/21 Prosperity Bank CD 04/01/21 Independent Bank CD 04/22/21 Bank OZK CD 05/10/21 Southside Bank CD 06/11/21 Bank OZK CD 06/11/21 Prosperity Bank CD 07/01/21 Prosperity Bank CD 07/15/21 Prosperity Bank CD 08/23/21 East West Bank CD 09/09/21 Prosperity Bank CD 10/14/21 Independent Bank CD 10/18/21 Prosperity Bank CD 11/22/21 East West Bank CD 12/30/21 Prosperity Bank CD 01/21/22 Prosperity Bank CD 04/21/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 11/17/22 Totals (Continued) 2015 Revenue Water WW 2016 CO- Streets/ Facilities/ Equip 2016 GO- Roads 2016 Revenue Water/WW Garey Park Donation 2017 CO Facilities/ Public Safety/ Equipment 2017 Revenue Electric –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,531,698 68,600 1,429,101 1,456,708 254,936 178,433 97,374 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,531,698$ 68,600$ 1,429,101$ 1,456,708$ 254,936$ 178,433$ 97,374$ City of Georgetown Valley View Consulting, L.L.C.42Page 49 of 115 City - Allocation December 31, 2020 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Veritex Bank MMA NexBank MMA Origin Bank MMA TexPool TexSTAR East West Bank CD 01/08/21 Independent Bank CD 02/05/21 Independent Bank CD 02/08/21 East West Bank CD 02/18/21 East West Bank CD 02/18/21 R Bank CD 02/19/21 Bank OZK CD 02/26/21 Southside Bank CD 03/11/21 Bank OZK CD 03/11/21 East West Bank CD 03/15/21 Prosperity Bank CD 04/01/21 Independent Bank CD 04/22/21 Bank OZK CD 05/10/21 Southside Bank CD 06/11/21 Bank OZK CD 06/11/21 Prosperity Bank CD 07/01/21 Prosperity Bank CD 07/15/21 Prosperity Bank CD 08/23/21 East West Bank CD 09/09/21 Prosperity Bank CD 10/14/21 Independent Bank CD 10/18/21 Prosperity Bank CD 11/22/21 East West Bank CD 12/30/21 Prosperity Bank CD 01/21/22 Prosperity Bank CD 04/21/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 11/17/22 Totals (Continued) 2017 Revenue Water WW 2018 CO- Airport 2018 CO- Streets/ Facilities/ Equip 2018 GO- Parks 2018 GO- Roads 2019 CO- Streets/ Facilities/ Equip 2019 CO- Stormwater –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – 1,014,148 – – – – – – – – – – – – – 3,241,881 56,694 672,254 482,661 9,137,064 3,936,963 113,952 – – – – – – – – – – – – – – 3,009,081 – – – – – – 3,003,579 – – – – 3,003,579 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,008,234 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 12,276,924$ 56,694$ 672,254$ 482,661$ 9,137,064$ 6,940,543$ 113,952$ City of Georgetown Valley View Consulting, L.L.C.43Page 50 of 115 City - Allocation December 31, 2020 Market Value JPMorgan Chase Cash JPMorgan Chase MMA Veritex Bank MMA NexBank MMA Origin Bank MMA TexPool TexSTAR East West Bank CD 01/08/21 Independent Bank CD 02/05/21 Independent Bank CD 02/08/21 East West Bank CD 02/18/21 East West Bank CD 02/18/21 R Bank CD 02/19/21 Bank OZK CD 02/26/21 Southside Bank CD 03/11/21 Bank OZK CD 03/11/21 East West Bank CD 03/15/21 Prosperity Bank CD 04/01/21 Independent Bank CD 04/22/21 Bank OZK CD 05/10/21 Southside Bank CD 06/11/21 Bank OZK CD 06/11/21 Prosperity Bank CD 07/01/21 Prosperity Bank CD 07/15/21 Prosperity Bank CD 08/23/21 East West Bank CD 09/09/21 Prosperity Bank CD 10/14/21 Independent Bank CD 10/18/21 Prosperity Bank CD 11/22/21 East West Bank CD 12/30/21 Prosperity Bank CD 01/21/22 Prosperity Bank CD 04/21/22 Prosperity Bank CD 05/17/22 Prosperity Bank CD 08/22/22 Prosperity Bank CD 11/17/22 Totals (Continued) 2019 GO- Roads 2020 CO- Facilities/ Equip/Parks 2020 CO- Stormwater 2020 GO- Roads 2020 Revenue- Electric 2020 Revenue- Water/WW Electric-LCRA Transformers –$ –$ –$ –$ –$ –$ –$ – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 1,961,455 2,602,887 650,566 8,708,689 1,241,086 7,169,062 3,479,865 – – – – – – – – – – – – – – – – – – – – – – – – – – – – 2,002,386 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – 3,963,841$ 2,602,887$ 650,566$ 8,708,689$ 1,241,086$ 7,169,062$ 3,479,865$ City of Georgetown Valley View Consulting, L.L.C.44Page 51 of 115 ________________________________________________________________________ Leigh Wallace Nathan Parras Finance Director Assistant Finance Director ________________________________________________________________________ Karrie Pursley Elaine Wilson Treasurer Assistant Finance Director Georgetown Economic Development Corporation (GEDCO) QUARTERLY INVESTMENT REPORT For the Quarter Ended March 31, 2021 Prepared by Valley View Consulting, L.L.C. The investment portfolio of the Georgetown Economic Development Corporation (GEDCO) is in compliance with the Texas Public Funds Investment Act and the Investment Policy and Strategies. Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total return yields and do not account for investment advisor fees. 45Page 52 of 115 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield MMA 2,129,948$ 2,129,948$ 2,130,611$ 2,130,611$ 0.10% Pools 6,006,030 6,006,030 6,964,887 6,964,887 0.03% Certificates of Deposit 2,025,562 2,025,562 2,000,000 2,000,000 0.24% 10,161,540$ 10,161,540$ 11,095,498$ 11,095,498$ 0.08% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 0.08%Total Portfolio 0.25% Rolling Three Month Treasury 0.06%Rolling Three Month Treasury 0.08% Rolling Six Month Treasury 0.09%Rolling Six Month Treasury 0.10% TexPool 0.02%TexPool 0.05% Interest income provided in separate report. December 31, 2020 (1)Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank, pool, and money market balances. (2)Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. March 31, 2021 Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.46Page 53 of 115 Economic Overview 3/31/2021 The 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 projected that reduced rates could remain into 2023 or longer. Fourth Quarter GDP finalized at +4.3%. March Non Farm Payroll added 916k and Unemployment declined to 6.0%. Crude oil traded above $60 per barrel. The Stock Markets reached new highs. Housing, Industrial Production, Durable Goods, Consumer Spending, and other indicators showed solid gains. An additional $1.9 trillion stimulus package passed Congress and was signed by the President. The Yield Curve continued steepening on longer maturities. 0 250 500 750 1,000 1,250 1,500 1,750 2,000 2,250 2,500 2,750 3,000 3,250 3,500 3,750 4,000 4,250 S&P 500 0.00 0.50 1.00 1.50 2.00 2.50 3.00 3.50 US Treasury Historical Yields - Since Nov 2015 Six Month T-Bill Two Year T-Note Ten Year T-Note 0.00 0.20 0.40 0.60 0.80 1.00 1.20 1.40 1.60 1.80 2.00 Treasury Yield Curves March 31, 2020 December 31, 2020 March 31, 2021 0.00 0.50 1.00 1.50 2.00 2.50 3.00 3.50 4.00 4.50 5.00 5.50 6.00 US Treasury Historical Yields - Since 2006 Six Month T-Bill Two Year T-Note Ten Year T-Note Valley View Consulting, L.L.C.47Page 54 of 115 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.10%04/01/21 03/31/21 2,130,611$ 2,130,611$ 1.00 2,130,611$ 1 0.10% TexasDAILY AAAm 0.05%04/01/21 03/31/21 2,125,613 2,125,613 1.00 2,125,613 1 0.05% TexSTAR AAAm 0.02%04/01/21 03/31/21 4,839,274 4,839,274 1.00 4,839,274 1 0.02% Veritex Bank CD 0.24%08/05/22 02/08/21 2,000,000 2,000,000 100.00 2,000,000 492 0.24% 11,095,498$ 11,095,498$ 11,095,498$ 90 0.08% (1)(2) March 31, 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.48Page 55 of 115 MMA 19% Pools 63% Certificates of Deposit 18% GEDCO PORTFOLIO COMPOSITION $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 06/30/20 09/30/20 12/31/20 3/31/2021 GEDCO PORTFOLIO BALANCES CD TexasDAILY TexSTAR Money Market Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.49Page 56 of 115 Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 12/31/20 Increases Decreases Book Value 03/31/21 Market Value 12/31/20 Change in Market Value Market Value 03/31/21 Veritex Bank MMA 0.10%04/01/21 2,129,948$ 663$ –$ 2,130,611$ 2,129,948$ 663$ 2,130,611$ TexasDAILY 0.05%04/01/21 2,125,306 306 – 2,125,613 2,125,306 306 2,125,613 TexSTAR 0.02%04/01/21 3,880,724 958,551 – 4,839,274 3,880,724 958,551 4,839,274 Independent Bank CD 1.71%02/05/21 2,025,562 – (2,025,562) – 2,025,562 (2,025,562) – Veritex Bank CD 0.24%08/05/22 – 2,000,000 – 2,000,000 – 2,000,000 2,000,000 TOTAL / AVERAGE 0.08%10,161,540$ 2,959,520$ (2,025,562)$ 11,095,498$ 10,161,540$ 933,958$ 11,095,498$ Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.50Page 57 of 115 Georgetown Transportation Enhancement Corporation (GTEC) QUARTERLY INVESTMENT REPORT For the Quarter Ended March 31, 2021 Prepared by Valley 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. 51Page 58 of 115 Summary Quarter End Results by Investment Category: Asset Type Book Value Market Value Book Value Market Value Ave. Yield Pools/MMAs 28,689,653$ 28,689,653$ 30,076,153$ 30,076,153$ 0.03% CDs/Securities 3,004,002 3,004,002 3,006,965 3,006,965 0.40% Totals 31,693,655$ 31,693,655$ 33,083,118$ 33,083,118$ 0.06% Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2) Total Portfolio 0.06%Total Portfolio 0.09% Rolling Three Month Treasury 0.06%Rolling Three Month Treasury 0.08% Rolling Six Month Treasury 0.09%Rolling Six Month Treasury 0.10% TexPool 0.02%TexPool 0.05% Interest data provided in separate report. December 31, 2020 (1) Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank, pool, and money market balances. (2) Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. March 31, 2021 Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.52Page 59 of 115 Economic Overview 3/31/2021 The 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 projected that reduced rates could remain into 2023 or longer. Fourth Quarter GDP finalized at +4.3%. March Non Farm Payroll added 916k and Unemployment declined to 6.0%. Crude oil traded above $60 per barrel. The Stock Markets reached new highs. Housing, Industrial Production, Durable Goods, Consumer Spending, and other indicators showed solid gains. An additional $1.9 trillion stimulus package passed Congress and was signed by the President. The Yield Curve continued steepening on longer maturities. 0 250 500 750 1,000 1,250 1,500 1,750 2,000 2,250 2,500 2,750 3,000 3,250 3,500 3,750 4,000 4,250 S&P 500 0.00 0.50 1.00 1.50 2.00 2.50 3.00 3.50 US Treasury Historical Yields - Since Nov 2015 Six Month T-Bill Two Year T-Note Ten Year T-Note 0.00 0.20 0.40 0.60 0.80 1.00 1.20 1.40 1.60 1.80 2.00 Treasury Yield Curves March 31, 2020 December 31, 2020 March 31, 2021 0.00 0.50 1.00 1.50 2.00 2.50 3.00 3.50 4.00 4.50 5.00 5.50 6.00 US Treasury Historical Yields - Since 2006 Six Month T-Bill Two Year T-Note Ten Year T-Note Valley View Consulting, L.L.C.53Page 60 of 115 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.02%04/01/21 03/31/21 15,639,313$ 15,639,313$ 1.00 15,639,313$ 1 0.02% TexSTAR AAAm 0.02%04/01/21 03/31/21 11,748,398 11,748,398 1.00 11,748,398 1 0.02% Veritex Bank MMA 0.10%04/01/21 03/31/21 2,688,441 2,688,441 1.00 2,688,441 1 0.10% Prosperity Bank CD 0.40%08/23/21 08/21/20 3,006,965 3,006,965 100.00 3,006,965 145 0.40% TOTALS 33,083,118$ 33,083,118$ 33,083,118$ 14 0.06% (1)(2) March 31, 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.54Page 61 of 115 Pools/MMAs 91% CDs/Securities 9% 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 6/30/2021 9/30/2021 12/31/2021 3/31/2021 GTEC PORTFOLIO BALANCES CD TexPool TexSTAR Money Market Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.55Page 62 of 115 Book & Market Value Comparison Issuer/Description Yield Maturity Date Book Value 12/31/20 Increases Decreases Book Value 03/31/21 Market Value 12/31/20 Change in Market Value Market Value 03/31/21 TexPool 0.02%04/01/21 13,146,323$ 2,492,991$ –$ 15,639,313$ 13,146,323$ 2,492,991$ 15,639,313$ TexSTAR 0.02%04/01/21 12,855,726 – (1,107,328) 11,748,398 12,855,726 (1,107,328) 11,748,398 Veritex Bank MMA 0.10%04/01/21 2,687,605 837 – 2,688,441 2,687,605 837 2,688,441 Prosperity Bank CD 0.40%08/23/21 3,004,002 2,963 – 3,006,965 3,004,002 2,963 3,006,965 TOTAL / AVERAGE 0.06%31,693,655$ 2,496,790$ (1,107,328)$ 33,083,118$ 31,693,655$ 1,389,462$ 33,083,118$ Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.56Page 63 of 115 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 1,119.55 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 14,814.52 14,814.52 Fire Department of Health & Human Services CMS (Centers for Medicare & Medicaid Services) EMS CARES Round 1 - - Fire US Department of Homeland Security Federal Emergency Management Agency EMW-2017-FH-00496 SAFER 543,247.52 372,220.59 Library National Endowment for the Arts National Endowment for the Arts COVID Relief Funding 9,014.11 - Library Texas Commission on the Arts Touring Artist Fund Grant 4,200.00 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 5,176.77 - Police US. Department of Treasury N/A TX2460200 Equitable Sharing Agreement 20,346.75 - Public Works Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ-0914-05-187 Highway Planning & Construction (Austin Ave Bridge) 2,776.55 - Public Works Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ-0914-05-200,201,202 Highway Planning & Construction (Williams Dr Corridor) - - Reviewed By: Elaine Wilson CITY OF GEORGETOWN Grant/Federal Funding Report as of March 31, 2021 Active 57Page 64 of 115 Capital Improvement Projects Life to Tade Budget vs Spend Row Labels Total Budget Total Spend Remaining Budget Percent Remaining Airport Airport - Self Managed PRJ000197 Hangar Mainenance 240,000 - 240,000 100% PRJ000198 Pavement Maintenance 60,000 - 60,000 100% PRJ000199 Wildlife Management 150,000 - 150,000 100% Airport - Self Managed Total 450,000 - 450,000 300% Management Services PRJ000184 Airport Maintenance Facility 750,000 - 750,000 100% Management Services Total 750,000 - 750,000 100% Airport Total 1,200,000 - 1,200,000 400% CDBG CDBG PRJ000003 17th Street 193,000 175,137 17,863 9% PRJ000144 Maple Street (Inactive)80,784 - 80,784 100% CDBG Total 273,784 175,137 98,647 109% CDBG Total 273,784 175,137 98,647 109% Downtown TIRZ Parks PRJ000050 Grace Heritage Plaza 139,100 45,900 93,200 67% Parks Total 139,100 45,900 93,200 67% Downtown TIRZ Total 139,100 45,900 93,200 67% Electric Electric PRJ000022 Consultant Engineering 271,352 71,352 200,000 74% PRJ000026 Db Wood_Sh29 Intersection 240,000 172,024 67,976 28% PRJ000036 Electrical System Improvement 100,000 57 99,943 100% PRJ000040 Fiber Optic 50,000 19,516 30,484 61% PRJ000062 New Development Projects 5,019,335 5,334,015 (314,680) -6% PRJ000073 Power Quality Improvements 50,000 - 50,000 100% PRJ000095 Shell Road Feeders 160,000 181,824 (21,824) -14% PRJ000147 Sectionalization Improvements 100,000 - 100,000 100% PRJ000175 I-35 Mobility Project TxDot 200,000 183,627 16,373 8% PRJ000189 Ronald Reagan - Glasscock Feeder Extension along Hwy 195 -Phase I 560,000 39,310 520,690 93% PRJ000192 Ronald Reagan - Glasscock Feeder extension along Hwy 195 - Phase II 591,250 133,847 457,403 77% PRJ000195 Downtown Overhead Rehab 2,400,000 - 2,400,000 100% PRJ000221 Titan-Aviation Dr to IH35 Infrastructure Addition 1,000,000 67,349 932,651 93% PRJ000225 Chapel Hill, WS-11139 (GEO-45-C.3)437,577 345,842 91,735 21% PRJ000226 Wolf Ranch West - Section 1AG & 1BG 479,052 33,405 445,647 93% PRJ000227 Ascend Westinghouse Apartments 444,598 29,165 415,432 93% PRJ000229 Sun City NH 76 WS-11188 (GEO-18.2-N.51)274,030 103,520 170,510 62% PRJ000230 Sun City NH 78 296,400 111,101 185,299 63% PRJ000231 Georgetown Titan Development 1 & 2 140,428 - 140,428 100% PRJ000232 Texas Outdoor Power Building 1 91,414 - 91,414 100% PRJ000234 Summit at Westinghouse Self-Storage 49,685 - 49,685 100% 58Page 65 of 115 Row Labels Total Budget Total Spend Remaining Budget Percent Remaining PRJ000236 Medcore (Georgetown) Senior Living 226,972 20,134 206,837 91% PRJ000238 The Oscar at Georgetown 366,351 - 366,351 100% PRJ000239 Wolf Ranch West - Section 3 - Phase 2 418,339 - 418,339 100% Electric Total 13,966,782 6,846,089 7,120,693 1738% Electric Total 13,966,782 6,846,089 7,120,693 1738% GCP Environmental Services PRJ000116 Transfer Station 11,000,000 947,801 10,052,199 91% Environmental Services Total 11,000,000 947,801 10,052,199 91% Finance PRJ000038 ERP Project 6,231,654 5,898,066 333,588 5% Finance Total 6,231,654 5,898,066 333,588 5% Fire PRJ000134 SCBA Replacement 870,000 - 870,000 100% PRJ000135 Cardiac Monitors 483,517 483,517 - 0% Fire Total 1,353,517 483,517 870,000 100% Fleet PRJ000124 Radio Replacement 363,278 - 363,278 100% Fleet Total 363,278 - 363,278 100% GTEC Department PRJ000203 FM1460 Widening 948,982 48,982 900,000 95% PRJ000206 NB Front Rd (2338 To Lakeway)216,000 221,766 (5,766) -3% GTEC Department Total 1,164,982 270,748 894,234 92% Management Services PRJ000028 Downtown Parking Expansion 728,510 701,947 26,564 4% PRJ000029 Downtown Parking Garage 411,815 411,815 - 0% PRJ000033 Dtwn Landsping & Public Art 90,000 56,706 33,294 37% PRJ000037 EOC Siren System 15,525 15,525 - 0% PRJ000042 Fire Station 6 5,500,000 5,330,405 169,595 3% PRJ000043 Fire Station 7 8,550,000 6,457,667 2,092,333 24% PRJ000067 Parking Improvements 68,510 - 68,510 100% PRJ000131 Fuel Station 1,100,000 - 1,100,000 100% PRJ000136 GMC Remodel Phase I 250,000 30,614 219,386 88% PRJ000178 Public Safety Operation and Training Center Phase II 4,500,000 - 4,500,000 100% PRJ000179 Recreation Center Teen/Senior Renovation 200,000 - 200,000 100% PRJ000180 Recreation Center Natatorium HVAC Replacement 700,000 656,176 43,824 6% PRJ000191 Georgetown City Center - Festival/Public Space 5,400,000 14,099 5,385,901 100% PRJ000223 City Center Signage 125,000 - 125,000 100% Management Services Total 27,639,360 13,674,954 13,964,406 762% 59Page 66 of 115 Row Labels Total Budget Total Spend Remaining Budget Percent Remaining Parks PRJ000048 Garey Park 15,346,730 15,100,250 246,480 2% PRJ000089 San Gabriel Park Improvement 13,025,000 7,448,252 5,576,748 43% PRJ000125 Parks Master Plan 229,998 229,998 - 0% PRJ000126 Regional Trail Development 1,550,000 138,100 1,411,900 91% PRJ000127 Neighborhood Park Development 1,250,000 240,541 1,009,459 81% PRJ000129 Ada Transition Plan 1,075,982 276,682 799,300 74% PRJ000130 Tennis Center Pool Demo 40,002 39,076 926 2% PRJ000190 Heritage Gardens 274,934 81,400 193,534 70% PRJ000205 Katy Crossing Trail 700,000 500,181 199,819 29% Parks Total 33,492,646 24,054,481 9,438,165 392% Police PRJ000133 Body Cameras 800,000 737,412 62,588 8% Police Total 800,000 737,412 62,588 8% Public Works - Self Managed Department PRJ000204 Historic District Street Signs 26,000 - 26,000 100% Public Works - Self Managed Department Total 26,000 - 26,000 100% Public Works Department PRJ000013 Austin Avenue Bridge 2,855,398 1,711,629 1,143,769 40% PRJ000137 Intersection Improvements (Lakeway @ Williams Drive) 1,400,000 252,450 1,147,550 82% PRJ000138 Downtown Sidewalks 2,000,000 470,719 1,529,281 76% PRJ000139 Westinghouse - Scenic Lake Traffic Signal 600,000 87,028 512,972 85% PRJ000141 Southwestern Blvd 4,200,000 866,960 3,333,040 79% PRJ000143 Leander Rd(Norwood-Swbypass)6,750,000 994,025 5,755,975 85% PRJ000171 Shell Rd Sidewalk 229,825 203,755 26,070 11% PRJ000188 DB Wood (SH 29 to Oak Ridge)4,000,000 1,703,636 2,296,364 57% PRJ000201 Austin Ave. (Sh29-Fm2243)466,000 466,000 - 0% PRJ000202 FM 971 4,853,000 1,113,617 3,739,383 77% PRJ000207 Northwest Blvd Bridge 11,254,320 11,372,616 (118,296) -1% PRJ000208 Old Town Northeast 1,050,000 923,818 126,182 12% PRJ000209 Southeast Inner Loop 10,521,000 8,884,343 1,636,657 16% PRJ000214 Intersection Improvements (Traffic Signals)1,650,000 159,863 1,490,137 90% PRJ000215 2021 Intersection Safety Enhancements (RRFB)150,000 96,450 53,550 36% PRJ000216 FY21 Downtown Sidewalk Improvements 1,000,000 130,000 870,000 87% PRJ000217 SW Bypass - Wolf Ranch Extension 1,000,000 633,943 366,057 37% Public Works Department Total 53,979,543 30,070,852 23,908,691 871% Right of Way PRJ000200 Access Rtw To Government Srv 220,000 220,000 - 0% Right of Way Total 220,000 220,000 - 0% GCP Total 136,270,980 76,357,831 59,913,149 2521% 60Page 67 of 115 Row Labels Total Budget Total Spend Remaining Budget Percent Remaining General Fund Projects Parks PRJ000055 Katy Crossing Trail 700,000 17,780 682,220 97% Parks Total 700,000 17,780 682,220 97% Public Works Department PRJ000012 Austin Ave. (Sh29-Fm2243) (Inactive) 466,000 - 466,000 100% Public Works Department Total 466,000 - 466,000 100% Right of Way PRJ000007 Access Rtw To Government Srv 220,000 - 220,000 100% Right of Way Total 220,000 - 220,000 100% General Fund Projects Total 1,386,000 17,780 1,368,220 297% GTEC GTEC Department PRJ000046 FM 971/ Fontana (Nw Bridge) 1,209,000 1,193,000 16,000 1% PRJ000053 IH 35/ Hwy 29 Intersection Imp 1,800,000 120,066 1,679,934 93% PRJ000060 Rabbit Hill Road 4,100,000 179,757 3,920,243 96% PRJ000083 Rivery Tia Improvements 1,179,000 1,110,970 68,030 6% PRJ000092 Se Inner Loop Widening (Inactive) 8,148,000 - 8,148,000 100% PRJ000145 Sh29 Signal And Roadway Improvements 1,595,000 312,671 1,282,329 80% PRJ000146 Wolf Ranch Parkway Extension (Inactive) 1,100,000 - 1,100,000 100% PRJ000181 Aviation Drive 10,300,000 275,868 10,024,132 97% PRJ000182 Confido III 600,000 - 600,000 100% PRJ000183 Big C Project 2,000,000 - 2,000,000 100% GTEC Department Total 32,031,000 3,192,332 28,838,668 774% GTEC Total 32,031,000 3,192,332 28,838,668 774% Stormwater Stormwater PRJ000004 18th and Hutto Drainage 50,000 6,356 43,644 87% PRJ000005 2nd and Rock Pond 625,000 447,151 177,849 28% PRJ000024 2020 Curb & Gutter 1,055,000 337,047 717,953 68% PRJ000104 Stormwater Infrastructure 347,000 168,506 178,495 51% PRJ000148 Water Quality Ponds 98,000 - 98,000 100% PRJ000149 Drainage Improvement/Flood Mitigation Projects 300,000 - 300,000 100% PRJ000213 2021 Curb & Gutter Project 500,000 53,100 446,900 89% Stormwater Total 2,975,000 1,012,160 1,962,840 525% Stormwater Total 2,975,000 1,012,160 1,962,840 525% 61Page 68 of 115 Row Labels Total Budget Total Spend Remaining Budget Percent Remaining Street Tax Public Works Department PRJ000172 2020 Street Maintenance High Performance Seal: Bid Package No.1 372,200 372,200 - 0% PRJ000173 2020 Street Maintenance High Performance Seal: Bid Package No. 2 463,195 482,214 (19,020) -4% PRJ000174 2020 street maintenance HIPR 1,935,589 1,441,013 494,576 26% PRJ000210 2021 HIPR Street Maintenance 2,300,000 274,700 2,025,300 88% PRJ000211 2021 High Performance Pavement Seal Project #1 600,000 94,900 505,100 84% PRJ000212 2021 High Performance Pavement Seal Project #2 600,000 90,700 509,300 85% PRJ000237 Northeast Inner Loop (Stadium to FM971) Emergency Repairs 700,000 695,456 4,544 1% Public Works Department Total 6,970,983 3,451,183 3,519,800 279% Street Tax Total 6,970,983 3,451,183 3,519,800 279% Transportation GTEC Department PRJ000047 FM1460 Widening (Inactive)794,000 - 794,000 100% PRJ000061 NB Front Rd (2338 To Lakeway) (Inactive)366,000 - 366,000 100% GTEC Department Total 1,160,000 - 1,160,000 200% Public Works Department PRJ000045 FM 971 2,000 (26,684) 28,684 1434% PRJ000063 Northwest Blvd Bridge 21,743,000 421,578 21,321,422 98% PRJ000065 Old Town Northeast (Inactive)855,021 (19,064) 874,085 102% PRJ000100 Southeast Inner Loop 3,321,000 - 3,321,000 100% Public Works Department Total 25,921,021 375,830 25,545,190 1734% Transportation Total 27,081,021 375,830 26,705,190 1934% 62Page 69 of 115 Row Labels Total Budget Total Spend Remaining Budget Percent Remaining Water Water PRJ000014 Berry Creek Inter.49,949,000 701,486 49,247,514 99% PRJ000016 Braun Est 4,750,000 1,202,760 3,547,240 75% PRJ000017 Cedar Breaks Est 3,385,000 236,730 3,148,270 93% PRJ000023 Cr 255 (Wd14-2)1,493,963 323,841 1,170,122 78% PRJ000025 Db Wood/ Pastor 24 Dedicated 5,286,000 423,726 4,862,274 92% PRJ000027 Domel PS Improvements (Inactive) 5,816,000 - 5,816,000 100% PRJ000034 Earz 2,326,000 469,283 1,856,717 80% PRJ000057 Lift Station Upgrade 1,173,593 - 1,173,593 100% PRJ000059 LWTP Raw Water Intake Rehab 6,750,000 5,506,976 1,243,024 18% PRJ000066 Park Lift Station & Force Main 3,574,341 2,115,836 1,458,505 41% PRJ000069 Pecan Branch Ph 2 253,000 232,521 20,479 8% PRJ000075 Pumps & Storage 1,009,289 9,289 1,000,000 99% PRJ000076 Rabbit Hill Est 1,826,000 873,294 952,706 52% PRJ000085 Ronald Reagan/Daniels Mountain 4,400,000 167,638 4,232,362 96% PRJ000087 S. Lake Wtp 2018 (Inactive) 6,950,000 - 6,950,000 100% PRJ000088 San Gabriel Belt Press and Rehab 3,200,000 2,580,279 619,721 19% PRJ000096 Shell Road Water Line 6,890,000 992,205 5,897,795 86% PRJ000101 Southlake Wtp 100,000,000 8,590,093 91,409,907 91% PRJ000103 Stonehedge Ls & Fm (Inactive) 150,000 - 150,000 100% PRJ000108 Sun City Elevated Storage Tank (Inactive) 3,224,000 - 3,224,000 100% PRJ000110 Sw Bypass Waterline (Inactive) 1,106,000 - 1,106,000 100% PRJ000119 Water Mains 1,537,000 433,498 1,103,502 72% PRJ000121 Westinghouse Ls & Fm (Inactive) 3,299,000 - 3,299,000 100% PRJ000122 Westside Facility (Inactive)505,500 - 505,500 100% PRJ000123 WW Interceptors 608,431 - 608,431 100% PRJ000150 Carriage Oaks Transmission 500,000 - 500,000 100% PRJ000151 FY2020 CR262 Waterline 500,000 - 500,000 100% PRJ000152 Hoover Pump Station 6,850,000 855,221 5,994,779 88% PRJ000153 FY2020 Round Rock Supply Line (Inactive)300,000 17,345 282,655 94% PRJ000154 FY2020 Stonewall Ranch Ps Improvements 500,000 - 500,000 100% PRJ000155 Southside Water Treatment Plant 2,250,000 21,840 2,228,160 99% PRJ000156 Gatlin/Teravista Improvements 450,000 - 450,000 100% PRJ000157 Leander Interconnect 515,000 49,495 465,505 90% PRJ000158 West loop (H-1A)2,119,000 447,385 1,671,615 79% PRJ000160 Round Rock Supply Pump Station And Elevated Storage Tank 10,500,000 1,427,473 9,072,527 86% PRJ000161 Miscellaneous Line Upgrades 872,000 655,875 216,125 25% PRJ000162 South West Bypass Water (H24-1) 2,906,000 2,301,498 604,502 21% PRJ000163 Tank Rehabilitation 2,905,000 445,994 2,459,006 85% PRJ000164 Council Chamber Water 423,000 15,960 407,040 96% PRJ000165 San Gabriel Wwtp Rehab 2,500,000 98,000 2,402,000 96% PRJ000167 San Gabriel Inter SGI -2 4,500,000 912,755 3,587,245 80% PRJ000168 WWTP Upgrade 950,000 - 950,000 100% PRJ000177 Northlake WTP Phase IV Expansion 15,000,000 11,859,923 3,140,077 21% PRJ000185 Cimarron Hills Wastewater Treatment Plant Expansion 800,000 - 800,000 100% PRJ000218 EARZ Wastewater Rehabilitation Area 2 - 2019 2,460,360 2,460,360 - 0% PRJ000219 Southside GST Foundation Improvements 535,678 - 535,678 100% PRJ000228 Southside GST Roof Rehab 567,000 - 567,000 100% Water Total 278,365,155 46,428,578 231,936,576 3759% Water Operations PRJ000220 AMI Western District Improvements 750,000 - 750,000 100% Water Operations Total 750,000 - 750,000 100% Water Total 279,115,155 46,428,578 232,686,576 3859% Grand Total 501,409,805 137,902,820 363,506,985 12504% 63Page 70 of 115 Unfunded Liability &  Commitments Financial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21 Cemetery Special Revenue  Fund Currently 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 reserve $75,000 annually for future costs  associated with maintaining the property.  The General  Fund has made this transfer in since FY 2016. The general fund transfer for FY2021 was reduced to  $35,000.  No change. 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. 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. Compensated Absence Future 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. CITY OF GEORGETOWN Long-term Commitments, Reservations, and Other Unfunded Liabilities 3/31/2021 64Page 71 of 115 Unfunded Liability &  Commitments Financial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21 Electric Fund Rate  Stabilization Reserve Intended 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 FY2021 CIP Roll Forward and Other  Operating Amendments approved by Council, the PCA  revenue was lowered by $5 million. Budgeted ending  fund balance covers $4M in 90 day contingency  reserve, $10.6M in non‐operating or rate stabilization  reserve, and $3.4M in restricted proceeds from the  transformer sale. During the February Winter Storm Uri, the Electric  Fund incurred an additional $48 million in energy  market costs. The City issued a debt instrument that  will be paid from current PCA rates. There are no  expected changes to Electric reserves. Airport Maintenance Fund 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.  CARES Act purchases will be changed to airport Utility  charges FY 20 & FY21, along with other maintenance  charges from FY21.  We are still reviewing Land Lease  buildings that will be reverting back to Airport  Ownership within the next 5 years. These reversions  will  impact the budget bottom line as we will have to  do some maintenance on the buildings.  These  charges will be off‐set by the increased revenue from  the increased Facility Lease Rates.  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.   Americans with Disabilities  Act (ADA) Compliance Needs As 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. FY2021 budget and debt sale includes $150,000 for  the ADA plan.  A competitive sealed bid has been completed for  ADA repairs along the South San Gabriel River  Trail. The contract is in Legal for review.   Sidewalk Maintenance &  Masterplan Currently, 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.  In design is the Rock Sidewalk/FY20 Downtown ADA  Sidewalk Improvements. This project will construct  new and rehab/replace non‐ADA compliant sidewalks  and pedestrian ramps. Currently reviewing 95% plans.  Advertising and Bidding to start end of January 2021.  The Council is considering a mobility bond for May  2021 that would include additional debt capacity for  sidewalk projects. Rock Sidewalk/FY 20 Downtown ADA Sidewalk  Improvements. Project is awarded to Choice Builders.  Construction to begin in May 2021.  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. 65Page 72 of 115 Unfunded Liability &  Commitments Financial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21 Park Equipment Maintenance  & Replacement Over 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. University Park and Raintree Park equipment and the  outdoor pool slides at the Recreation Center were  scheduled to be completed in FY2020.  However,  these were deferred due to financial constraints  related to COVID‐19.  These deferrals total $290,000.   Additionally, the general fund transfer for FY2021 was  reduced from $200,000 to $50,000.  Scheduled  maintenance equipment and replacement projects for  FY2021 total $402,000 not including the FY2021  deferrals.  Staff has evaluated the FY2020 deferrals  and the scheduled FY2021 replacements and  prioritized to complete projects with greatest need.   These total $293,000 and will be completed with the  $50,000 transfer and existing fund balance.   No change. Radio Equipment  Replacement Communication 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.  The audit shows there are 301 radios that still need to  be replaced before September 2023. Non‐Public  Safety ‐ 39 portable radios; 72 mobile radios. Some of  those mobiles may be replaced with portables. Police ‐  71 portable radios; 82 mobile radios. 911 Comms ‐ 4  portable radios; 9 mobile radios. Fire ‐ 12 portable  radios; 12 mobile radios. The FY2021 budget and debt  sale includes $363K in funding. Ordered 22 portable radios for Electric Dept. Ordered  9 mobiles and 4 portables for 911 Communications.  Processing 8 portable radios for Police in Workday.  Still working on the other 35 non‐public safety radios.  Street Maintenance The 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. No change. After the FY2020 audit is completed and  all available General Fund balance reviewed, there  may be dollars available to allocate to street  maintenance or other priorities. The Council declined to appropriate any available  fund balance during an April workshop. The February  Winter Storm Uri caused damage to a section of Inner  Loop. The Street Sales Tax Fund will cover the  approximately $700K for repairs. The road is not  eligible for FEMA reimbursement. Fiber Asset Allocation Network 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. Fiber staff will be moved into IT at beginning of FY 21.   Also in FY 2021, Fiber costs will be allocated across  departments according to the IT allocation process.   The second installment to acquire the asset will be  paid in FY2020, and there is a plan to assume  additional installments over the next 4 years. The IT  Fund will need to increase cost recovery rates to  complete the acquisition. IT has drafted a cost recovery plan for fiber and it is  being evaluated as part of the FY2022 budget  development process.  66Page 73 of 115 Unfunded Liability &  Commitments Financial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21 IT Capital Replacement  Reserve The 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.  During the FY2021 budget adoption process, the IT  capital replacement reserve was drawn down in order  to purchase a portion of the fiber asset from the  Electric utility. In FY2022, IT Allocation revenues will  need to increase citywide to recover the fund balance  and continue with the remaining fiber asset purchase. IT has drafted a cost recovery plan for fiber and it is  being evaluated as part of the FY2022 budget  development process.  Facilities Maintenance  Reserve The 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.  During the FY2021 budget adoption process, the  Facilities cost allocation revenue was not increased.  This provided some economic relief throughout major  funds due to COVID economic uncertainty. Therefore,  no incremental progress was made to fund this  reserve. In FY2022 or future years, rates will need to  increase to fund this reserve.  Facilities has drafted a cost recovery plan for fund  balance reserves and it is being evaluated as part of  the FY2022 budget development process. Public Safety Equipment  Recurring Line Item Budgets As 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. Due to the economic impacts of the pandemic,  reductions were made to General Fund base budgets  in FY2021, including public safety equipment. There is  no anticipated impact to employee safety. The funds  will need to be restored in FY2022, or as soon as  practical. No change. Joint Services Fund 90 Day  Operational Contingency  Reserve A minimum ninety (90) days of operating expenses will be  reserved for unexpected delays in revenue or emergency  expenses.  Due to the economic impact of the pandemic, the City  is not increasing recovery rates to build this reserve. It  is estimated to take approximately 3 years to build the  reserve to 90 days. The FY2021 budget provide  funding to hire a consultant to review and  recommend updates to the City's joint services cost  allocation model. Council declined to appropriate any available fund  balance at mid‐year to achieve this goal. The Cost  Allocation Model study was put on hold due to  activities needed to recover from the Winter Storm. 67Page 74 of 115 City of Georgetown, Texas Water Utility Board June 10, 2021 S UB J E C T: R eview and possible action to approve the minutes from the May 13, 2021 Water Board Meeting.-Tina Davis, Board Liaison IT E M S UMMARY: R eview and possible action to approve the minutes from the May 13, 2021 Water Board Meeting.- F IN AN C IAL IMPAC T: . S UB MIT T E D B Y: Board Liais on AT TAC H ME N T S: Description Type GWUAB Minutes 5.13.21 Backup Material May, 2021 Directors report (las t month)Backup Material Page 75 of 115 Georgetown Water utility Advisory Board Meeting May 13, 2021 Board Members Present: Thomas Glab; Board Chair, Stuart Garner, Steve Fought, Michael Morrison, Scott Macmurdo Staff Members Present: Chelsea Solomon, Director of Water Utilities; Leticia Zavala Jones, Customer Care Director; Wesley Wright, System Engineering Director; David Thomison, Water Services Manager; Mike Welch, Treatment and Regulatory Manager; Chris Pousson, Project Manager; Mike Maldonado, Aaron St. Pierre, Administrative Assistant; Tina Davis, Board Liaison Guest: Alan Wolke Regular Session (This Regular Session may, at any time, be recessed to convene an Executive Session for any purpose authorized by the Open Meetings Act, Texas Government Code 551.) A. Consistent with Governor Greg Abbott’s suspension of various provisions of the Open Meetings Act effective August 1, 2020 and until further notice, to reduce the chance of COVID-19 transmission, all City of Georgetown Advisory Board meetings will be held virtually. Public comment will be allowed via teleconference; no one will be allowed to appear in person. B. Call to Order - Meeting was called to order by Chair at 2:00 PM C. Monthly report from Water Utility Directors – Before Directors report Chelsea gave a brief update on Councils decision to resume in person meetings beginning in June or July. More information to follow. Jones states customer accounts increased over 500, now at 47,879. 77% of usage is through advanced metering infrastructure (AMI), 23 % is from automated meter reading, (AMR) drive by system. Approximately 1300 estimation were done on bills due to a cycle 9 problem with the meter reader. Problem has since been resolved. Average residential bill last year was $40, this year is $52. The average bill for all customers last year was $50, this year is $62. Current water rates and sewer rates were changed January 1st this year. Consistently initiating disconnects has increased collections on aged receivables through April on outstanding accounts. In June will move past due accounts to a collection agency. Will also place outstanding amounts on current active account. Solomon reported for Finance – Council approved the sale of bonds at last meeting. Water ($16.3M), Electric ($6.6M) on capital projects for FY2021. Bonds are secured by property taxes but repaid by Water and Electric revenues. 7 bids received, willing bid true interest cost of City of Georgetown, Texas Georgetown Water Utility Board Meeting Minutes Thursday, May 13, 2021 at 2:00 p.m. Teleconference Page 76 of 115 Georgetown Water utility Advisory Board Meeting May 13, 2021 1.733% to SAMCO Capital Markets with 9 year call option and amortization set to the useful life of the assets. (7.10 and 20 years). Solomon reports Operating Statistics peak day production at 29 million gallons daily. Wastewater is holding steady. Performance metrics dropped in March due to the weather event and getting behind on routines that were placed aside temporarily. Wrong day watering campaign has started. To date there are about 250 total cases. Over a month, this equated to approximately ½ million gallons of water per day. 1st violations receive a letter with option to pay a $60 fine or take an irrigation class online to remove the fine from an account. 2nd violation receives a letter and $75 fine. 3rd letter with a fine closer to $100. Class managed by City Customer Care who will send out a link. If sprinkler system is broken and receipt is presented as proof of repair, the fine will be removed. Violations are detected by smart meters and usage patterns using last years meter data. ¾ of customers are on smart meters. City working with water meters group in Sun City. Will run ads in the Sun newspaper and Community Impact. Georgetown Lake level is 70% full, about 9 ½ ft. low, water comes from Edwards Aquifer Wells. Well levels have been holding steady. Wright reports brief update on active design projects. Deep in design on Cimarron Hills WWTP, City is administering the developers obligation. Will ask for construction dollars soon. Berry Creek Interceptor, upper half of line is in. Will move forward with San Gabriel Interceptor afterwards. Will ask for permission to begin expansion later in meeting. Not much progress made on San Gabriel Interceptor project. Deep in design on South Lake Water Treatment Plant, 60% done. Expect to bid Shell Road Waterline this year. Working with landowner/developer Hoover Pump Station on pumpstation site and line easements. Southside Water Treatment Plant Rehab-Board recently approved pilot study to begin in summer and foundation work that has been delayed until winter due to a concern of the integrity of the tank. Will come back after summer peak to do foundation work, move forward with roof repair that was previously approved. Work will happen in fall/winter after one more summer peak. EARZ construction ongoing, making sure Wastewater system is working. San Gabriel Park Lift Station underway, pump should be in and moving forward in next two months. San Gabriel WWTP Belt Press and Capital Maintenance is complete and in service. 24” waterline is complete. Northlake Pump Station and Treatment Plant Expansion, pumps in place and being tested. Will turn on in next two weeks and turn over to Solomon for daily operation. Cunningham working on 8.8 MGD plant expansion awarded earlier this year, they are onsite and making progress. Delivered summer peak of 2023. D. Virtual Conference instructions, to include options for public comments and how the public may address he Commission - Chelsea Solomon, Water Utility Director – Solomon explained the participation process for the public (no one signed up to speak) and the Board, everyone must state name before speaking, Chair will do roll call for votes by name) No further questions or discussion. Page 77 of 115 Georgetown Water utility Advisory Board Meeting May 13, 2021 E. Public Wishing to Address the Board. -- Thomas Glab, Board Chair – no one signed up to speak at the meeting. Regular Agenda F. Review and possible action to approve the minutes from the April 8, 2021 Water Board Meeting – Motion to approve minutes by Morrison, seconded by Glab, 5-0-0 G. Consideration and possible recommendation to renew the contract 18-0017- SC with Elk Ridge Construction, LLC (Water & Wastewater Collection and Distribution Stations) in the amount of $67,767.41 per year – David Thomison, Water Utility Manager. – Contract originated in 2017 with a provision of up to 4 annual renewals. Contract includes mowing of 37 wastewater collection system facilities, 31 water distribution systems facilities on a monthly basis. Funds are available in Water Services budget. Motion to approve staffs recommendation to renew contract No. 3 (with correction of up to 4 annual renewals in the caption to 3rd and final renewal) of the 2017 water/wastewater collection and distribution mowing contract 18-0017-SC with Elk Ridge Construction, LLC in the amount not to exceed $67,767.41 by Macmurdo, seconded by Morrison. Approved 5-0-0 H. Discussion and possible recommendation to exercise renewal option #4 of a contract with HydroPro Solutions LLC to provide Master Meter water meters and water meter registers for the Advanced Metering Infrastructure system with a not-to-exceed amount of $1,500,000 - Mike Maldonado, Metering Services Manager – HydroPro is sole authorized dealer. This is final renewal of contract. The $1,500,000 has not been adjusted in prior years. In 2020 City spend approximately $1,300,000 to support new customer growth. Requesting increase in not to exceed amount based on current customer growth. Staff only pays for what is purchased, this includes new installations. Part of connect fees collected at permitting pays for this smart meter equipment. Motion to approve renewal No. 4 by Macmurdo, seconded by Garner. Approved 5-0-0 I. Discussion and possible recommendation on the proposed FY22 Capital Improvement Plan (Water & Wastewater) -- Wesley Wright, PE, Systems Engineering Director – For Wastewater; $27,250 for maintenance, lift station/line work and treatment enhancements. Wastewater maintenance; $2MM for Edwards Aquifer recharge zone program and lift station upgrades as needed. There are 40 total. Lift station/linework; Wolf Ranch Lift Station reaching capacity, want to expand to keep up with growth. Interceptor Lift Station Decommission, removal of existing lift station, add Page 78 of 115 Georgetown Water utility Advisory Board Meeting May 13, 2021 gravity line replacement. Cimarron Hills Expansion, need to front money, developer will reimburse. Pecan Branch WWTP Expansion, would like to begin design and expand permit. San Gabriel WWTP in need of capital maintenance. Include design for Dove Springs WWTP. Water: Miscellaneous funds for SCADA Upgrades, system resiliency, Water/Wastewater Master Plan, ability to maintain flow from Stonewall Ranch Pump Station for Carriage Oaks Transmission, CR262 waterline, need boost waterline to 12’” for fire flow. Aviation Dr/I35 Connection, service road connect to 1015 pressure plane, WD line Upgrades & Pumps, Water Pumps/Tanks, Construction dollars for South Lake Water Treatment Plant, the existing 22MGD expansion will reach capacity 4 years after it is brought online. Advantage of having expansion to full $160,000,00, 44MGD plant for future growth. Staff recommends moving forward with full 44MGD plant. Motion to approve change order to CDM to include in current scope of work. Motion to approve FY22 CIP plan as presented which includes 44MG per day design and construction plan of the South Lake Water Treatment Plant by Macmurdo, seconded by Morrison. Approved 5-0-0 J. Consideration and possible recommendation to approve Pumping Equipment and Services for Well #11 at Southside WTP to be provided by Weisinger Inc. – Mike Welch, Treatment and Regulatory Manager – Weisinger Inc was given the task of removing Water Well #11 and completing a comprehensive condition assessment of the pump and casing. (The camera survey revealed no rehabilitation of the casing was needed.) The pump inspection revealed excessive wear on all components. The recommended services encompass a complete rebuild of the pump, motor, and column assemblies, including work performed to date, and complete reinstallation and testing. Pump has been removed and taken to Weisinger shop for evaluation, casing does not need rehab. Being proactive on older wells to prevent future problems this winter. After inspection, excessive wear revealed on components, rebuild recommended of pump, returning, installing and testing equipment. Staff recommends awarding Weisinger Inc. $86,549 and continuing services with them. Motion to approve services from Weisinger Inc. by Morrison, seconded by Garner. Approved 5-0-0 K. Consideration and possible recommendation to approve the First Amendment to Task Order CDM-20-009 with CDM Smith, Inc. professional services related to the South Lake Water Treatment Plant and 1178 Transmission Main in the amount of $529,232.00-- Wesley Wright, P.E., Systems Engineering Director – City met with consultants to go over 60% design plan to discuss issues with the plant during the winter storm. Page 79 of 115 Georgetown Water utility Advisory Board Meeting May 13, 2021 Currently the system can be controlled at the Georgetown Municipal Complex (GMC) location; with no remote station at this time. Want to make this plant redundant with diesel generation power on site with PEC primary power provider, bring in generator fuel storage to run plant at max capacity without PEC power and expand building for office space for an additional control center and certified laboratory on site. CDM is design engineer. Estimate completion date, summer 2025. Motion to approve amendment to Task Order CDM-20-009 on South Lake Water Treatment Plant by Macmurdo, seconded by Garner. Approved, 5-0-0 Adjournment Motion to adjourn by Morrison, seconded by Macmurdo at approximately 4:19 PM. Thomas Glab, Chair Secretary Board Liaison Page 80 of 115 Directors’ Report May 13, 2021 City of GeorgetownPage 81 of 115 Customer Service and Billing – Water Services Page 82 of 115 –Water Service Customer Account Breakdown: Mar Apr Residential 43,173 43,560 Non-Residential 4,658 4,819 Total Water Customers:47,831 48,379 –Water Billing Collection: •Advanced Metering Infrastructure (AMI): 77% –Usage data automatically transmitted to billing office •Automated Meter Reading (AMR): 23% –Usage data is collected via a drive by system –# of Customer Estimations: 1353 –Account did not get a “good” READ; or –Account did not get “ANY” READ (work order put in for metering to investigate) Customer Statistics Page 83 of 115 Average Water Bill/Mar FY2020 FY2021 Residential $ 39.89 $ 52.36 All Customers $ 50.77 $ 62.41 Residential -Water Residential –Sewer Customer Rates Rates –Effective 1-1-2021 Base Charge (3/4” meter)$24.50 / $29.45 Volumetric Charges: 0 –7 kgal $1.85 7,001 -15 kgal $2.75 15,001 –25 kgal $4.80 25,001 +$8.40 Rates –Effective 1-1-2021 Fixed Charge $34.85 / $40.10 Page 84 of 115 Aged Receivables Report –thru 4/30/21 Water AR –Aging Breakdown compared to previous month Sewer AR –Aging Breakdown compared to previous month Water Prior Month Variance 31 –60 Days $31,047.51 $53,125.75 ($22,078.24) 61 –90 Days $38,306.98 $18,101.47 $20,205.51 91 –120 Days $14,595.34 $15,857.21 ($1,261.87) 120 –365 Days $92,902.63 $100,244.37 ($7,341.74) > 365 Days $191,411.43 $188,026.57 $3,384.86 Total $368,263.89 $375,355.37 ($7,091.48) Customer Counts 2177 2235 (58) Sewer Prior Month Variance 31 –60 Days $9,216.71 $10,127.14 ($910.43) 61 –90 Days $4,485.75 $7,979.82 ($3,494.07) 91 –120 Days $6,827.26 $4,745.47 $2,081.79 120 –365 Days $20,493.96 $28,673.13 ($8,179.17) > 365 Days $48,542.34 $46,798.77 $1,743.57 Total $89,566.02 $98,324.33 ($8,758.31) Customer Counts 1521 1571 (50)Page 85 of 115 Finance Page 86 of 115 Spring Debt Update •Water ($16.3M) and Electric ($6.6M) capital projects and equipment for FY2021 were successfully awarded on 5/11/21 as self-supporting certificates of obligation •Property taxes pledged to secure best interest rate and term •100% repaid by water and electric sales revenues •7 bids received •Winning bid true interest cost of 1.733% to SAMCO Capital Markets •9 year call option •Amortization set to the useful life of the assets (7, 10 and 20 years) Page 87 of 115 Operations Report Page 88 of 115 Operating Statistics April 2021 •Water System (MGD) –Rated Capacity 44 / 40 –Average Annual Production (YTD)18.5 –Peak Day Production 29.16 (71%) –2020 Peak 42.87 (97%) –2019 Peak 41.7 (94%) •Wastewater System (MGD) –Rate Capacity 8.5 –Average Annual Production (YTD)5.4 City of GeorgetownPage 89 of 115 Performance Metrics thru’ April 2021 Page 90 of 115 Wrong Day Watering Campaign Irrigation Cases 4/25/2021 to 5/2/2021 Cases 62 Opened 1 -Email 1 -Phone 60 -MDM Review 8 Closed 1 Customer taking class 2 Repair in Progress 108 Send Letter 110 Current Open Cases 121 Total Cases between 03/20/2021 and 05/02/21 Page 91 of 115 Operational Items of Note Brazos River Authority Currently Has Lake Georgetown Drought Phase 1 City of GeorgetownPage 92 of 115 Engineering Page 93 of 115 Capital Improvement Projects (CIP) Design Wastewater –Cimarron Hills WWTP Expansion •CDM Smith Task Order approved October. Design underway. Coordination with Ops occurring. –Berry Creek Interceptor (BC LS to PB WWTP) •Easement appraisals finalizing, acquisition support ongoing. 13 parcels. –San Gabriel Interceptor (SH29/SWU to PB WWTP) •Under design, coordinating effort with master plan update, assessing proper alignment/easement needs Design Water –South Lake Water Treatment Plant •Under design, working with TCEQ and USACOE. 60% plans complete. 22 or 44mgd? –Shell Road Waterline •Finalizing easements and design, ready to bid later this year –Hoover Pump Station, EST, & Linework •Currently under design, working with primary landowner for pump site and easements –Southside WTP Rehab •Pilot study this summer, foundation repair this fall, tank roof this winter, rehab Fall 2022. Page 94 of 115 Capital Improvement Projects (CIP) Construction Wastewater –EARZ •Approximately $2.5MM, City-wide, in place repair of manholes and damaged wastewater lines –San Gabriel Park Lift Station •Lift station expansion underway. Summer delivery –San Gabriel WWTP Belt Press & Capital Maintenance •Sludge dewatering facility for the plant and large maintenance/repair items –complete. •Major Plant rehab proposed for FY22 CIP Construction Water –Southwest Bypass Waterline •24” waterline from SH29 to FM2243 -complete –Northlake Pump Station and Treatment Plant Expansion (awarded October) •980 pump station improvements –Prota Construction (startup mid-May). •8.8MGD plant expansion –Cunningham Constructors (work underway). Page 95 of 115 Questions? City of GeorgetownPage 96 of 115 City of Georgetown, Texas Water Utility Board June 10, 2021 S UB J E C T: C onsideration and pos s ible rec ommendation on an amendment to Task O rder C DM-20-009 in the amount of $2,788,660 for design s ervic es related to the S outh Lake Water Treatment P lant -- Wes ley Wright, P E, S ystems Engineering Direc tor IT E M S UMMARY: In early 2020, C ounc il authorized a des ign tas k order for a new water treatment plant to be located on previous ly purc hased property on the s outh s ide of Lake G eorgetown. T his plant has always been intended to have the ability to treat up to 44 million gallons per day (mgd) at full build out. T he original task order was s coped bas ed on a 22mgd initial phas e for the S outh Lake Water Treatment P lant (S LW T P ). However, the number of new water connec tions c ontinues to increase and the c ity is on pace to s ee over 5,000 new water c onnection in 2021. T his continue inc reas e in growth and the demand for water will res ult in the initial 22mgd plant being at c apacity as early as 2028. G iven that an expansion of a water treatment plant can take up to 3 years, the city would be required to s tart c onstruc tion of any expans ion in early 2025 - approximately the same time the initial 22mgd is put in s ervic e. Additionally, des ign on that expansion would need to s tart in early 2023. Des ign of the first phas e of the S LW T P is currently approaching 60% complete. In order to assure the city maintains water treatment capac ity c apable of keeping up with continued growth and reduce the cons truction window to expand the S LW T P to its full 44mgd capac ity, staff is recommending immediately initiating des ign on the expans ion and inc luding it as part of the initial phase. T his inclus ion will reduc e overall cons truction from an estimated 6 years to 4 years. Inclus ion will als o ens ure that a single contrac tor cons tructs the entire fac ility guaranteeing s tandardized materials and equipment ac ros s the facility, which pres ents many intangible benefits for the city's operators. T his proposed task order amendment will effectively double the S LW T P infrastruc ture that is current under design and inc orporate it into a s ingle bid package that could be ready for advertisement in late 2021 or very early 2022. T he s cope inc ludes additional filtration, treatment struc ture, dis infec tion tank, and clearwell, as well as all the internal as s ociated improvements necessary to fully cons truct the facility. Als o inc luded in this amendment is additional hours for ons ite s pecialized inspec tion services for the additional cons truction time. T his amendment will increase the total authorized task order from $7,730,232 to $10,518,892. T he ultimate cons truction cost for the 22mgd fac ility is expec ted to be approximately $100MM. T he expansion to 44mgd is expected to result in an overall cons truction cost of approximately $160MM that will be budgeted for ac ros s 4 fisc al years starting in F Y22. F IN AN C IAL IMPAC T: F unds are available in the Water F und for this additional expens e and are generated by water revenue and development paid water impact fees. S UB MIT T E D B Y: KEF for Wesley Wright Page 97 of 115 AT TAC H ME N T S: Description Type Task Order South Lake WTP 22 to 44mgd Backup Material Water Demand Projections Backup Material Page 98 of 115 Georgetown – Revised 3.11 Page 1 of 7 Attachment 1 (Modifications) to Exhibit K – Amendment to Task Order EJCDC E-505 Standard Form of Agreement Between Owner and Engineer for Professional Services—Task Order Edition Copyright ©2004 National Society of Professional Engineers for EJCDC. All rights reserved. EXHIBIT K, consisting of pages, referred to in and part of the Master Services Agreement between Owner and CDM Smith, Inc. (“Engineer”) for Professional Services – Task Order Edition dated September 30, 2016. Second Amendment to Task Order No. CDM-20-009 1. Specific Project Data: A. Title: South Lake Water Treatment Plant and 1178 Transmission Main B. Description: This amendment includes additional design and construction services to expand the South Lake Water Treatment Plant (SLWTP) design capacity from 22 million gallons per day to 44 million gallons per day by adding a second treatment structure, six dual-media filters, a second disinfection tank, a second six million gallon clearwell and associated improvements. C. City of Georgetown Project Number: ______ D. City of Georgetown Cost Center/Fund No.: ________________ E. City of Georgetown Purchase Order No.: _______________________________ F. Master Services Agreement, Contract Number: 2016-738-MSA 2. Nature of Amendment [Check those that are applicable and delete those that are inapplicable.] X Additional Services to be performed by Engineer X Modifications to Services of Engineer X Modifications to Payment to Engineer X Modifications to Time(s) for rendering Services 3. Description of Modifications A. Engineer shall perform the following Additional Services: B. The Scope of Services currently authorized to be performed by Engineer in accordance with the Task Order and previous Amendments, if any, is modified as follows: Phase 2 – Final Design 2.2 South Lake Water Treatment Plant Design Page 99 of 115 Georgetown – Revised 3.11 Page 2 of 7 Attachment 1 (Modifications) to Exhibit K – Amendment to Task Order EJCDC E-505 Standard Form of Agreement Between Owner and Engineer for Professional Services—Task Order Edition Copyright ©2004 National Society of Professional Engineers for EJCDC. All rights reserved. The design services for the South Lake WTP originally included those tasks necessary to design a new 22-mgd WTP and associated high service pump station on a greenfield site and include the following items: · Treatment structure (rapid mix, flocculation, sedimentation basins and seven dual- media filters) · Liquid Chemical Storage and Feed Facilities · Clearwell Structure · High Service Pump Station with high service and backwash pumps · Sludge Gravity Thickener · Sludge Dewatering Building · Washwater recovery basin and recycle pump station · Decant Tank (Added in Amendment 1) · Administration Building inclusive of Control Room and Water Process lab (Modified in Amendment 1) · Disinfection Tanks and Transfer Pump Station · Electrical Building and Generators (Added in Amendment 1) · Maintenance Building · Treated Water Pipeline to 1178 Pressure Plane · Filtrate Pump Station and Sanitary Improvements (Added in Amendment 1) The modifications proposed under Amendment 2 include the following to increase the SLWTP capacity from 22 to 44 MGD: · Addition of a Second Treatment Structure (rapid mix, flocculation, sedimentation basins and six dual-media filters) · Liquid Chemical Storage and Feed Facilities – Addition of tanks and pumps within the current Chemical Facility Footprint to Feed the Second Treatment Train · Addition of a second 6 million gallon Clearwell · Addition of a second Disinfection Tank and additional transfer pumps · Expansion of the High Service Pump Station · Related site civil, instrumentation, controls, architectural, HVAC/plumbing, and electrical infrastructure design to accommodate Phase 2 of the SLWTP. Additional funds are requested to add the above Amendment 2 scope into Task 2.2.2 – 90% Plans and Specifications, Task 2.2.3 – Final Plans and Specifications, and Task 2.2.4 – Cost Estimates as described in the original contract. Phase 3 – Bidding The 44 MGD WTP project will be advertised for bid as a single bid package. With the increase in construction scope, Task 3.1.5 – Conformed Documents will be expanded as shown below: Task 3.1.5 – Conformed Documents. ENGINEER will prepare conformed documents for the additional drawings added to the scope (Phase 1 = 450 drawings and Phase 2 = 600 drawings total of Phases 1 and 2). Page 100 of 115 Georgetown – Revised 3.11 Page 3 of 7 Attachment 1 (Modifications) to Exhibit K – Amendment to Task Order EJCDC E-505 Standard Form of Agreement Between Owner and Engineer for Professional Services—Task Order Edition Copyright ©2004 National Society of Professional Engineers for EJCDC. All rights reserved. Phase 4 – Construction Services With the expansion of the SLWTP and increased capacity, the construction duration will be expanded from 36 to 51 months. Phase 1 of construction will be the first 36 months during which the Contractor will complete the initial 22 MGD capacity, and Phase 2 of construction will be the final 15 months during which the Contractor complete the additional 22 MGD capacity. Extended services for the additional 15 months are included for Tasks 4.0.1 Project Management, Task 4.0.2 Monthly Construction Meetings (now inclusive of 51 meetings), and Task 4.0.3 Site Visits (now inclusive of one per month over 51 months). With the increase in construction scope, Task 4.1.2 – Shop Drawings and Task 4.1.3 - RFIs will be expanded as shown below: Task 4.1.2 – Shop Drawings. ENGINEER will perform technical and functional review of all shop drawings and other submittals. An additional 150 shop drawings are being added to the SLWTP project to account for the additional scope items as described in Amendment 2. This will revise the total shop drawing count (original and resubmittals) to 700 for the project. Task 4.1.3 – RFIs. ENGINEER will respond to all RFIs submitted by the contractor and subcontractors. The engineering fee is based on an estimated 140 RFIs being submitted for the South Lake WTP project and 20 RFIs for the treated water pipeline projects. The South Lake WTP will be started up in two phases, with Phase 1 22 MGD capacity to be online in Spring 2025 and Phase 2 at 44 MGD capacity coming on-line in Spring of 2026. To accommodate this, Task 4.2.1 – Instrumentation and Control Testing will be modified. One series of testing will be conducted with the start-up of Phase 1 and a second series of tests will be performed with the start-up of Phase 2. Phase 5 – Start-up and Operation Services To accommodate a second Phase 2 start up, Task 5.0.1 Project Management, Task 5.0.2 Plant Start-Up, and Task 5.0.3 Plant Staff Consultation will be to adjusted to start up each phase of the facility. In addition, Task 5.1.1. Record Drawings will now accommodate Record Drawing Production for Phase 1 (approximately 450 drawings) and Phase 2 (estimated total 600 drawings over Phases 1 and 2). Page 101 of 115 Georgetown – Revised 3.11 Page 4 of 7 Attachment 1 (Modifications) to Exhibit K – Amendment to Task Order EJCDC E-505 Standard Form of Agreement Between Owner and Engineer for Professional Services—Task Order Edition Copyright ©2004 National Society of Professional Engineers for EJCDC. All rights reserved. Phase 6 – Resident Project Representatives Under Phase 6 of the project, ENGINEER will provide full-time RPR services during construction of the SLWTP which originally was scheduled for 36 months and is now extended to 51 months duration. C. For the Additional Services or the modifications to Services set forth above, Owner shall pay Engineer the following additional or modified compensation: The total amendment to the contract is $2,788,660. The Schedule of Payment shall be revised as follows: Category of Services Compensation Method Lump Sum or Not to Exceed Amount of Compensation for Services (Revised for Amendment 1) Lump Sum or Not to Exceed Amount of Compensation for Services (Revised for Amendment 2) BASIC SERVICES Preliminary Engineering (Lump Sum) $865,000 $924,260 Water Treatment Plant Final Design $3,168,732 $4,613,212 Bidding $161,000 $187,860 Construction Services $1,264,500 $1,846,060 Operations and Start-up Services $129,000 $285,600 Total Basic Services (Lump Sum) $4,723,232 $6,932,732 1178 Transmission Main Final Design $354,000 $354,000 Bidding $39,000 $39,000 Construction Services $119,000 $119,000 Operations and Start-up Services $11,000 $11,000 Total Basic Services (Lump Sum) $523,000 $523,000 SPECIAL SERVICES Surveying $375,000 $375,000 Geotechnical $40,000 $40,000 Environmental and Archaeological Services $120,000 $120,000 Total Special Services (Time and Materials) $535,000 $535,000 Resident Project Representative (Billing Rate) $1,084,000 $1,603,900 TOTAL CONTRACT VALUE $7,730,232 $10,518,892 Page 102 of 115 Georgetown – Revised 3.11 Page 5 of 7 Attachment 1 (Modifications) to Exhibit K – Amendment to Task Order EJCDC E-505 Standard Form of Agreement Between Owner and Engineer for Professional Services—Task Order Edition Copyright ©2004 National Society of Professional Engineers for EJCDC. All rights reserved. D. The schedule for rendering Services is modified as follows: Phase Completion Date Final Design September 2021 Bidding October 2021 to January 2022 Construction (Phase 1) February 2022 to May 2025 Construction (Phase 2) June 2025 to April 2026 Total Construction Duration 51 months (Original Contract assumed 36 months) E. Other portions of the Task Order (including previous Amendments, if any) are modified as follows: The Billing Rate Schedule for Resident Project Representative Services shall be revised per the attached schedule: 4. Attachments: Revised “Resident Project Representative Services – Billing Rate Schedule” as presented on Page 6 of 7. Page 103 of 115 Georgetown – Revised 3.11 Page 6 of 7 Attachment 1 (Modifications) to Exhibit K – Amendment to Task Order EJCDC E-505 Standard Form of Agreement Between Owner and Engineer for Professional Services—Task Order Edition Copyright ©2004 National Society of Professional Engineers for EJCDC. All rights reserved. FIRST AMENDMENT TO TASK ORDER NO. CDM-20-009 SOUTH LAKE WATER TREATMENT PLANT RESIDENT PROJECT REPRESENTATIVE SERVICES BILLING RATE SCHEDULE Category Billing Rate Resident Project Representative (Year 4 Rate) $165/hr RPR Supervisor (Year 4 Rate) $220/hr Contract Admin (Year 4 Rate) $100/hr Other RPR Expenses At Cost Page 104 of 115 Georgetown – Revised 3.11 Page 7 of 7 Attachment 1 (Modifications) to Exhibit K – Amendment to Task Order EJCDC E-505 Standard Form of Agreement Between Owner and Engineer for Professional Services—Task Order Edition Copyright ©2004 National Society of Professional Engineers for EJCDC. All rights reserved. 4. Attachments [if any]: Terms and Conditions: Owner and Engineer hereby agree to modify the above-referenced Task Order as set forth in this Amendment. All provisions of the Agreement and the Task Order not modified by this or previous Amendments remain in effect. The Effective Date of this Task Order Amendment is . OWNER: ENGINEER: By: By: Name: Name: Title: Title: Engineer License or Firm’s Certificate No. F-3043 State of: Texas APPROVED AS TO FORM: ________________________________________ ________________________________________ City Attorney Page 105 of 115 Titled Professional Sr. Professional Eng. 8 Eng. 6-7 Eng. 4-5 / Sr. Designer ENG 2-3 / Cost Estimator ENG 1 / Sr. Admin Admin / Designer RPR Total Hours OPs ODCs Costs Hourly Rates 275 250 225 200 175 150 125 100 165 PER Update 64 40 16 32 120 16 8 296 2060 59,260 Final Design 964 800 72 628 1592 1012 604 2496 8168 50,000 32,080 1,444,480 PM/QAQC 580 280 48 128 232 152 144 48 1612 20,000 372,100 Design Civil 48 200 400 100 748 50,000 1,730 194,930 Process Mechanical 296 80 960 320 200 700 2556 1,725 414,125 Structural 40 240 460 740 1,725 105,725 Architectural 24 180 284 488 1,725 62,525 HVAC/Plumbing 180 100 260 540 1,725 76,225 Electrical 16 120 280 244 660 1,725 102,525 I&C 80 40 160 260 540 1,725 75,725 OPCC & Specifications 24 40 80 140 284 40,600 Bidding 12 16 4 52 20 4 56 164 560 26,860 Construction Services 444 816 8 120 400 240 368 536 2932 24,060 581,560 Operations and Start-up Services 104 108 120 176 168 32 40 13,000 156,600 Resident Project Representative 3060 15,000 519,900 Totals 1588 1780 80 888 2252 1560 1024 3136 3060 11,560 50,000 86,760 2,788,660 Page 106 of 115 Water Demand Projections as of May 2021 South Lake Water Treatment Plant Sizing •South Lake Water Treatment Plant •60% Design Complete –Bid Fall 2021 •1st Phase Online Summer 2025 •$100MM –22MGD •3 years -$30MM FY22, $40MM FY23, $30MM FY24 •Or $160MM –44MGD •4 years -$30MM FY22, $50MM FY23, $50MM FY24, $30MM FY25 Page 107 of 115 Water Demand Projections as of May 2021 South Lake Water Treatment Plant Sizing Page 108 of 115 City of Georgetown, Texas Water Utility Board June 10, 2021 S UB J E C T: R eview and possible action of the G eorgetown Water Utility Advisory Board Bylaws - Laurie Brewer, As s is tant C ity Manager IT E M S UMMARY: F IN AN C IAL IMPAC T: .. S UB MIT T E D B Y: KEF for Laurie Brewer AT TAC H ME N T S: Description Type Water Utility Advis ory Board Bylaws 02.25.2020 Backup Material Page 109 of 115 Page 110 of 115 Page 111 of 115 Page 112 of 115 Page 113 of 115 Page 114 of 115 Page 115 of 115