Loading...
HomeMy WebLinkAbout2nd_Qtr_Report_FY2021FY2021 BUDGET AND 5 YEAR CAPITAL IMPROVEMENT PLAN Quarterly Report 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   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.          1   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 2   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.      3   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% 4   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.              5   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.                          6   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  7   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  8   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%                 9   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 10   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.     11 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 12 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 13 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 14 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 15 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 16 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 17 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 18 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 19 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 20 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. 21 Economic Overview3/31/2021The Federal Open Market Committee (FOMC) maintained the Fed Funds target range at 0.00% to 0.25% (Effective Fed Funds are trading <0.10%), and 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.02505007501,0001,2501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,0004,250S&P 5000.000.501.001.502.002.503.003.50US Treasury Historical Yields - Since Nov 2015Six Month T-BillTwo Year T-NoteTen Year T-Note0.000.200.400.600.801.001.201.401.601.802.00Treasury Yield CurvesMarch 31, 2020December 31, 2020March 31, 20210.000.501.001.502.002.503.003.504.004.505.005.506.00US Treasury Historical Yields - Since 2006Six Month T-BillTwo Year T-NoteTen Year T-NoteValley View Consulting, L.L.C.22 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.23 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.24 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.25 0–6 Months82% 6–12 Months14% 12–18 Months4% 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 7375 109104 123 156163 97108 87 51 67 4941 91 73 6154 99 71 124 95100 8070676358 818274 0 50 100 150 200 # of DaysWeighted Average to Maturity JPMorgan Chase6%Southside Bank 2% Prosperity Bank15% Veritex Bank 1% Bank OZK6% NexBank3% TexPool21% TexSTAR31% IndependentBank7% Texas Regional Bank1% East West Bank6% R Bank1% Portfolio Holdings by Issuer City of Georgetown Valley View Consulting, L.L.C. 26 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.27 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.28 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.29 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.30 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.31 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.32 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.33 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.34 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.35 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.36 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.37 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.38 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.39 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.40 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.41 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.42 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.43 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.44 ________________________________________________________________________ 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. 45 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.46 Economic Overview3/31/2021The Federal Open Market Committee (FOMC) maintained the Fed Funds target range at 0.00% to 0.25% (Effective Fed Funds are trading <0.10%), and 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.02505007501,0001,2501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,0004,250S&P 5000.000.501.001.502.002.503.003.50US Treasury Historical Yields - Since Nov 2015Six Month T-BillTwo Year T-NoteTen Year T-Note0.000.200.400.600.801.001.201.401.601.802.00Treasury Yield CurvesMarch 31, 2020December 31, 2020March 31, 20210.000.501.001.502.002.503.003.504.004.505.005.506.00US Treasury Historical Yields - Since 2006Six Month T-BillTwo Year T-NoteTen Year T-NoteValley View Consulting, L.L.C.47 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.48 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.49 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.50 Georgetown Transportation Enhancement Corporation (GTEC) QUARTERLY INVESTMENT REPORT For the Quarter Ended March 31, 2021 Prepared byValley View Consulting, L.L.C. ________________________________________________________________________ Leigh Wallace Nathan Parras Finance Director Assistant Finance Director ________________________________________________________________________ Karrie Pursley Elaine Wilson Treasurer The investment portfolio of the Georgetown Transportation Enhancement Corporation (GTEC) is in compliance with the Texas Public Funds Investment Act and the Investment Policy and Strategies. Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total return yields and do not account for investment advisor fees. 51 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.52 Economic Overview3/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.02505007501,0001,2501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,0004,250S&P 5000.000.501.001.502.002.503.003.50US Treasury Historical Yields - Since Nov 2015Six Month T-BillTwo Year T-NoteTen Year T-Note0.000.200.400.600.801.001.201.401.601.802.00Treasury Yield CurvesMarch 31, 2020December 31, 2020March 31, 20210.000.501.001.502.002.503.003.504.004.505.005.506.00US Treasury Historical Yields - Since 2006Six Month T-BillTwo Year T-NoteTen Year T-NoteValley View Consulting, L.L.C.53 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.54 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.55 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.56 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 57 Capital Improvement Projects Life to Tade Budget vs SpendRow LabelsTotal Budget Total Spend Remaining Budget Percent RemainingAirportAirport - Self ManagedPRJ000197 Hangar Mainenance240,000 - 240,000 100%PRJ000198 Pavement Maintenance 60,000 - 60,000 100%PRJ000199 Wildlife Management150,000 - 150,000 100%Airport - Self Managed Total450,000 - 450,000 300%Management ServicesPRJ000184 Airport Maintenance Facility750,000 - 750,000 100%Management Services Total750,000 - 750,000 100%Airport Total1,200,000 - 1,200,000 400%CDBGCDBGPRJ000003 17th Street193,000 175,137 17,863 9%PRJ000144 Maple Street (Inactive)80,784 - 80,784 100%CDBG Total273,784 175,137 98,647 109%CDBG Total273,784 175,137 98,647 109%Downtown TIRZParksPRJ000050 Grace Heritage Plaza139,100 45,900 93,200 67%Parks Total139,100 45,900 93,200 67%Downtown TIRZ Total139,100 45,900 93,200 67%ElectricElectricPRJ000022 Consultant Engineering 271,352 71,352 200,000 74%PRJ000026 Db Wood_Sh29 Intersection 240,000 172,024 67,976 28%PRJ000036 Electrical System Improvement100,000 57 99,943 100%PRJ000040 Fiber Optic50,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 Feeders160,000 181,824 (21,824) -14%PRJ000147 Sectionalization Improvements 100,000 - 100,000 100%PRJ000175 I-35 Mobility Project TxDot200,000 183,627 16,373 8%PRJ000189 Ronald Reagan - Glasscock Feeder Extension along Hwy 195 -Phase I560,000 39,310 520,690 93%PRJ000192 Ronald Reagan - Glasscock Feeder extension along Hwy 195 - Phase II591,250 133,847 457,403 77%PRJ000195 Downtown Overhead Rehab2,400,000 - 2,400,000 100%PRJ000221 Titan-Aviation Dr to IH35 Infrastructure Addition1,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 & 1BG479,052 33,405 445,647 93%PRJ000227 Ascend Westinghouse Apartments444,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 78296,400 111,101 185,299 63%PRJ000231 Georgetown Titan Development 1 & 2140,428 - 140,428 100%PRJ000232 Texas Outdoor Power Building 191,414 - 91,414 100%PRJ000234 Summit at Westinghouse Self-Storage49,685 - 49,685 100%58 Row LabelsTotal Budget Total Spend Remaining Budget Percent RemainingPRJ000236 Medcore (Georgetown) Senior Living226,972 20,134 206,837 91%PRJ000238 The Oscar at Georgetown366,351 - 366,351 100%PRJ000239 Wolf Ranch West - Section 3 - Phase 2418,339 - 418,339 100%Electric Total13,966,782 6,846,089 7,120,693 1738%Electric Total13,966,782 6,846,089 7,120,693 1738%GCPEnvironmental ServicesPRJ000116 Transfer Station11,000,000 947,801 10,052,199 91%Environmental Services Total11,000,000 947,801 10,052,199 91%FinancePRJ000038 ERP Project6,231,654 5,898,066 333,588 5%Finance Total6,231,654 5,898,066 333,588 5%FirePRJ000134 SCBA Replacement870,000 - 870,000 100%PRJ000135 Cardiac Monitors483,517 483,517 - 0%Fire Total1,353,517 483,517 870,000 100%FleetPRJ000124 Radio Replacement363,278 - 363,278 100%Fleet Total363,278 - 363,278 100%GTEC DepartmentPRJ000203 FM1460 Widening948,982 48,982 900,000 95%PRJ000206 NB Front Rd (2338 To Lakeway)216,000 221,766 (5,766) -3%GTEC Department Total1,164,982 270,748 894,234 92%Management ServicesPRJ000028 Downtown Parking Expansion728,510 701,947 26,564 4%PRJ000029 Downtown Parking Garage411,815 411,815 - 0%PRJ000033 Dtwn Landsping & Public Art90,000 56,706 33,294 37%PRJ000037 EOC Siren System15,525 15,525 - 0%PRJ000042 Fire Station 65,500,000 5,330,405 169,595 3%PRJ000043 Fire Station 78,550,000 6,457,667 2,092,333 24%PRJ000067 Parking Improvements68,510 - 68,510 100%PRJ000131 Fuel Station1,100,000 - 1,100,000 100%PRJ000136 GMC Remodel Phase I250,000 30,614 219,386 88%PRJ000178 Public Safety Operation and Training Center Phase II4,500,000 - 4,500,000 100%PRJ000179 Recreation Center Teen/Senior Renovation200,000 - 200,000 100%PRJ000180 Recreation Center Natatorium HVAC Replacement700,000 656,176 43,824 6%PRJ000191 Georgetown City Center - Festival/Public Space5,400,000 14,099 5,385,901 100%PRJ000223 City Center Signage125,000 - 125,000 100%Management Services Total27,639,360 13,674,954 13,964,406 762%59 Row LabelsTotal Budget Total Spend Remaining Budget Percent RemainingParksPRJ000048 Garey Park15,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 Plan229,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 Plan1,075,982 276,682 799,300 74%PRJ000130 Tennis Center Pool Demo 40,002 39,076 926 2%PRJ000190 Heritage Gardens274,934 81,400 193,534 70%PRJ000205 Katy Crossing Trail700,000 500,181 199,819 29%Parks Total33,492,646 24,054,481 9,438,165 392%PolicePRJ000133 Body Cameras800,000 737,412 62,588 8%Police Total800,000 737,412 62,588 8%Public Works - Self Managed DepartmentPRJ000204 Historic District Street Signs 26,000 - 26,000 100%Public Works - Self Managed Department Total 26,000 - 26,000 100%Public Works DepartmentPRJ000013 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 Sidewalks2,000,000 470,719 1,529,281 76%PRJ000139 Westinghouse - Scenic Lake Traffic Signal600,000 87,028 512,972 85%PRJ000141 Southwestern Blvd4,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 Sidewalk229,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 9714,853,000 1,113,617 3,739,383 77%PRJ000207 Northwest Blvd Bridge11,254,320 11,372,616 (118,296) -1%PRJ000208 Old Town Northeast1,050,000 923,818 126,182 12%PRJ000209 Southeast Inner Loop10,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 Improvements1,000,000 130,000 870,000 87%PRJ000217 SW Bypass - Wolf Ranch Extension1,000,000 633,943 366,057 37%Public Works Department Total53,979,543 30,070,852 23,908,691 871%Right of WayPRJ000200 Access Rtw To Government Srv220,000 220,000 - 0%Right of Way Total220,000 220,000 - 0%GCP Total136,270,980 76,357,831 59,913,149 2521%60 Row LabelsTotal Budget Total Spend Remaining Budget Percent RemainingGeneral Fund ProjectsParksPRJ000055 Katy Crossing Trail700,000 17,780 682,220 97%Parks Total700,000 17,780 682,220 97%Public Works DepartmentPRJ000012 Austin Ave. (Sh29-Fm2243) (Inactive) 466,000 - 466,000 100%Public Works Department Total466,000 - 466,000 100%Right of WayPRJ000007 Access Rtw To Government Srv220,000 - 220,000 100%Right of Way Total220,000 - 220,000 100%General Fund Projects Total1,386,000 17,780 1,368,220 297%GTECGTEC DepartmentPRJ000046 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 Road4,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 Drive10,300,000 275,868 10,024,132 97%PRJ000182 Confido III600,000 - 600,000 100%PRJ000183 Big C Project2,000,000 - 2,000,000 100%GTEC Department Total32,031,000 3,192,332 28,838,668 774%GTEC Total32,031,000 3,192,332 28,838,668 774%StormwaterStormwaterPRJ000004 18th and Hutto Drainage 50,000 6,356 43,644 87%PRJ000005 2nd and Rock Pond625,000 447,151 177,849 28%PRJ000024 2020 Curb & Gutter1,055,000 337,047 717,953 68%PRJ000104 Stormwater Infrastructure 347,000 168,506 178,495 51%PRJ000148 Water Quality Ponds98,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 Total2,975,000 1,012,160 1,962,840 525%Stormwater Total2,975,000 1,012,160 1,962,840 525%61 Row LabelsTotal Budget Total Spend Remaining Budget Percent RemainingStreet TaxPublic Works DepartmentPRJ000172 2020 Street Maintenance High Performance Seal: Bid Package No.1372,200 372,200 - 0%PRJ000173 2020 Street Maintenance High Performance Seal: Bid Package No. 2463,195 482,214 (19,020) -4%PRJ000174 2020 street maintenance HIPR1,935,589 1,441,013 494,576 26%PRJ000210 2021 HIPR Street Maintenance2,300,000 274,700 2,025,300 88%PRJ000211 2021 High Performance Pavement Seal Project #1600,000 94,900 505,100 84%PRJ000212 2021 High Performance Pavement Seal Project #2600,000 90,700 509,300 85%PRJ000237 Northeast Inner Loop (Stadium to FM971) Emergency Repairs700,000 695,456 4,544 1%Public Works Department Total6,970,983 3,451,183 3,519,800 279%Street Tax Total6,970,983 3,451,183 3,519,800 279%TransportationGTEC DepartmentPRJ000047 FM1460 Widening (Inactive)794,000 - 794,000 100%PRJ000061 NB Front Rd (2338 To Lakeway) (Inactive)366,000 - 366,000 100%GTEC Department Total1,160,000 - 1,160,000 200%Public Works DepartmentPRJ000045 FM 9712,000 (26,684) 28,684 1434%PRJ000063 Northwest Blvd Bridge21,743,000 421,578 21,321,422 98%PRJ000065 Old Town Northeast (Inactive)855,021 (19,064) 874,085 102%PRJ000100 Southeast Inner Loop3,321,000 - 3,321,000 100%Public Works Department Total25,921,021 375,830 25,545,190 1734%Transportation Total27,081,021 375,830 26,705,190 1934%62 Row LabelsTotal Budget Total Spend Remaining Budget Percent RemainingWaterWaterPRJ000014 Berry Creek Inter.49,949,000 701,486 49,247,514 99%PRJ000016 Braun Est4,750,000 1,202,760 3,547,240 75%PRJ000017 Cedar Breaks Est3,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 Earz2,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 2253,000 232,521 20,479 8%PRJ000075 Pumps & Storage1,009,289 9,289 1,000,000 99%PRJ000076 Rabbit Hill Est1,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 Wtp100,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 Mains1,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 Interceptors608,431 - 608,431 100%PRJ000150 Carriage Oaks Transmission500,000 - 500,000 100%PRJ000151 FY2020 CR262 Waterline500,000 - 500,000 100%PRJ000152 Hoover Pump Station6,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 Improvements500,000 - 500,000 100%PRJ000155 Southside Water Treatment Plant2,250,000 21,840 2,228,160 99%PRJ000156 Gatlin/Teravista Improvements450,000 - 450,000 100%PRJ000157 Leander Interconnect515,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 Tank10,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 Rehabilitation2,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 Upgrade950,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 - 20192,460,360 2,460,360 - 0%PRJ000219 Southside GST Foundation Improvements535,678 - 535,678 100%PRJ000228 Southside GST Roof Rehab567,000 - 567,000 100%Water Total278,365,155 46,428,578 231,936,576 3759%Water OperationsPRJ000220 AMI Western District Improvements750,000 - 750,000 100%Water Operations Total750,000 - 750,000 100%Water Total279,115,155 46,428,578 232,686,576 3859%Grand Total501,409,805 137,902,820 363,506,985 12504%63 Unfunded Liability & CommitmentsFinancial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21Cemetery Special Revenue FundCurrently 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 AbsenceFuture costs associated with benefits such as vacation, and sick leave for City employees. Compensated Absence is accrued annually to each proprietary fund type on a GAAP basis and accounted for on the balance sheet of each fund. For governmental funds (and for budgetary basis), the expense is recognized when due and payable.  The City keeps a reserve in the General Fund to help offset large payouts for long‐term employees. The reserve is used as needed, and annually replenished or increased based on known risk.Compensated absences as of 9/30/2020 are $8.2 million. More time was earned than used during FY2020 as many plans were changed related to the pandemic. The City did not extend any vacation cap carry overs in general. As with any year, specific requests for carryover are considered and approved by the City Manager.No change.CITY OF GEORGETOWNLong-term Commitments, Reservations, and Other Unfunded Liabilities3/31/202164 Unfunded Liability & CommitmentsFinancial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21Electric Fund Rate Stabilization ReserveIntended to mitigate potential rate impacts due to increased purchased power costs or other external factors. The RSR is maintained within the Electric Fund. During the 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 MaintenanceFund on‐going maintenance of the Airport grounds, runways and taxi ways.  Terminal and Tower included in Facilities ISF. An Airport Master Plan was developed to address long term capital maintenance project prioritization. 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 NeedsAs facilities are built or repurposed, meeting ADA compliance will be included in Project Costs.  Funding for program expansion will be needed (General Fund sources). The City has an adopted policy, as required by Federal Law, that it will make reasonable accommodations and modifications to ensure that people with disabilities have an equal opportunity to enjoy its programs, services, and activities. The City does not maintain a reserve for these modifications.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 & MasterplanCurrently, new sidewalks are built as development occurs.  Repairs are funded as needed or if funding is available, when major roads are repaired.  Useful life of a sidewalk is estimated at 40 to 50 years. The largest revenue source comes from the City’s General Fund, but there has been some debt funding as well. 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.65 Unfunded Liability & CommitmentsFinancial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21Park Equipment Maintenance & ReplacementOver the past 5 years, funding for Park Maintenance and Replacement has increased.  $200K transfer from General Fund included in FY2018 budget.  Staff has listed all assets & developed replacement schedule funded by the General Fund.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 ReplacementCommunication system consisting of 500 on‐body and in‐vehicle radios for Police, Fire, parks and utilities. Replacement radios are compatible with newer technology.  The replacement takes place over 5 years due to cost and is funded with certificate of obligation debt. 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 MaintenanceThe City funds street maintenance in the General Fund, supplemented by a 1/8th Street Sales Tax special revenue fund. In 2017 and 2018, the Council and GTAB reviewed various methods for enhanced street maintenance and costs. Direction from Council is to use high performance surface seals and pavement wearing courses and begin programmatically addressing the street network's deferred maintenance backlog, creating a need for approximately $2 million more per year for street maintenance.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 AllocationNetwork fiber infrastructure is installed across the City. Traditionally, the Electric Fund has installed and maintained the network. In reviewing all costs for the Electric Fund, the City has begun moving the fiber asset to the IT Fund. Staff must develop a multi‐year strategy to complete the asset transfer and allocate costs for maintenance.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. 66 Unfunded Liability & CommitmentsFinancial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21IT Capital Replacement ReserveThe purpose of this reserve is to fund the maintenance and replacement of computer network and other technology systems. A reserve will be established within the ISF for replacement of major systems and will be funded over time through excess revenues within the Fund.  The targeted amount is the average (1/5th) of the next five years on the replacement schedule. 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 ReserveThe City has established an on‐going maintenance program, which includes major repairs, equipment, as well as contracts for maintaining City facilities. The City has anticipated a useful life of such equipment and established a means of charging those costs to the various departments in order to recognize the City’s continuing costs of maintaining its facilities.  Determination for facility repairs is based on useful life of the various elements of each facility.  A proportional cost for each element is expensed within the budget for capital replacement.  The targeted replacement reserve amount is the average (1/5th) of the next five years on the replacement schedule. 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 BudgetsAs part of the City’s on‐going maintenance program, the City also recognizes the need to regularly maintain and replace specialized equipment in Police and Fire.  Separate replacement and maintenance schedules will be maintained for these items including but not limited to for Fire:   SCBA’s and other firefighting equipment and protective gear; and for Police: bullet proof vests, armaments and other tactical equipment.  The City’s goal is to provide level on‐going funding to ensure proper protection for employees and residents. The current funding level is an annual appropriation in the General Fund of $80,000 for Fire and $88,000 for Police.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 ReserveA 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.67