HomeMy WebLinkAboutAgenda_GTEU_06.17.2021Notice of Meeting for the
Georgetown Electric Utility B oard
of the City of Georgetown
June 17, 2021 at 2:00 P M
at Community Room at Georgetown City Hall, 808 Martin Luther K ing Jr. St.,
Georgetown T X 78626
T he C ity of G eorgetown is committed to compliance with the Americans with Disabilities Act (ADA). If you
require as s is tance in partic ipating at a public meeting due to a disability, as defined under the ADA, reas onable
as s is tance, adaptations , or ac commodations will be provided upon request. P leas e c ontact the C ity S ec retary's
O ffic e, at leas t three (3) days prior to the sc heduled meeting date, at (512) 930-3652 or C ity Hall at 808 Martin
Luther King Jr. S treet, G eorgetown, T X 78626 for additional information; T T Y users route through R elay
Texas at 711.
The Geor getown E le ctr ic U tility A dvisory B oard is now mee ting in pe rson.
A quorum of the Ge orge town E lec tric Utility Advisor y B oar d will be in
atte ndanc e at City H all, 808 M artin L uther K ing J r. S t. Ge orge town, TX
78626 in the Community R oom. It is possible that one or mor e board
membe rs may atte nd via vide o C onfer ence using the Zoom c lient.
To allo w fo r as much citizen participatio n as po ssible, citizen co mments are accepted either in perso n
o r via the Zo o m client. Face masks are enco uraged. U se o f pro fanity, threatening language,
slandero us remarks o r threats o f harm are no t allo wed and will result in yo u being immediately
remo ved fro m the meeting.
If yo u have questio ns o r need assistance, please co ntact Kress Carso n at
kress.carso n@geo rgeto wn.o rg o r at 512-930-2010.
To participate virtually, please co py and paste the fo llo wing weblink into yo ur bro wser:
https://geo rgeto wntx.zo o m.us/j/98089397423?pwd=bnJo eG hGckNnUk55S ER ZZ3B paTM4Zz09
Meeting I D : 980 8939 7423
Passco de: 325906
833 548 0282 U S To ll-free
877 853 5257 U S To ll-free
888 475 4499 U S To ll-free
833 548 0276 U S To ll-free
Find yo ur lo cal number: https://geo rgeto wntx.zo o m.us/u/aI j9H qM i5
C itizen co mments are accepted in the fo llo wing fo rmats:
Page 1 of 140
Submit written co mments to kresscarso n@geo rgeto wn.o rg by 10:00 a.m. o n the date o f the
meeting and the R eco rding Secretary will fo rward yo ur co mments to the bo ard befo re the
meeting.
Lo g o nto the meeting at the link abo ve and “raise yo ur hand” during the item, o r attend the
meeting and sign-up to speak in-perso n fo r an item po sted o n the agenda.
To join a Zoom me eting, c lick on the link provided and join as an attende e.
You will be aske d to e nte r your name and email addre ss (this is so we can
ide ntify you when you ar e c alled upon). To spe ak on an item, clic k on the
“Raise your H and” option at the bottom of the Zoom mee ting we bpage once
that ite m has opened. Whe n you are calle d upon by the Re cor ding Se cr etar y,
your devic e will be r emotely un-muted by the A dministrator and you may
spe ak for thre e minute s. P lease state your name clear ly, and when your time
is over, your de vice will be muted again.
Regular Session
(T his R egular S es s ion may, at any time, be rec es s ed to c onvene an Exec utive S es s ion for any purpose
authorized by the O pen Meetings Act, Texas G overnment C ode 551.)
A C all to O rder; R obert C ase- Board C hairman
B R oll C all of Board Members; R obert C ase-Board C hairman
C Introduc tion of Visitors ; R obert C as e-Board C hairman
D P ublic Wis hing to Address the Board- R obert C ase- Board C hairman
E R eview and Approval of Minutes from 5/20 Meeting; Kress C ars on- Board LIaison
F G eneral Manager's Monthly R eport-Daniel Bethapudi- G eneral Manager of Electric Utility
E xecutiv e Session
In c omplianc e with the O pen Meetings Ac t, C hapter 551, G overnment C ode, Vernon's Texas C odes,
Annotated, the items listed below will be dis cus s ed in c los ed session and are s ubjec t to action in the regular
s es s ion.
G S ec tion 551.086: C ompetitive Matters - Daniel Bethapudi- G eneral Manager of Electric Utility -P urc hased
P ower Update
Adjournment
Ce rtificate of Posting
I, R obyn Densmore, C ity S ecretary for the C ity of G eorgetown, Texas, do hereby c ertify that this Notic e of
Meeting was posted at C ity Hall, 808 Martin Luther King Jr. S treet, G eorgetown, T X 78626, a plac e readily
acc es s ible to the general public as required by law, on the _____ day of _________________, 2021, at
Page 2 of 140
__________, and remained s o posted for at leas t 72 c ontinuous hours prec eding the s cheduled time of said
meeting.
__________________________________
R obyn Dens more, C ity S ec retary
Page 3 of 140
City of Georgetown, Texas
Electric Utility Board
June 17, 2021
S UB J E C T:
R eview and Approval of Minutes from 5/20 Meeting; Kres s C arson- Board LIais on
IT E M S UMMARY:
F IN AN C IAL IMPAC T:
N/A
S UB MIT T E D B Y:
Kres s C arson-Board Liais on
AT TAC H ME N T S:
Description Type
5/20 Minutes Backup Material
Page 4 of 140
Minutes of the Meeting for the
Georgetown Electric Utility Advisory Board
Thursday, May 20th, 2021 at 4:15 PM
at: Virtual Meeting (Zoom)
Board Members Present:
Via Teleconference (Zoom): Robert Case - Chairman, Sam Jones–Secretary, Mike Triggs, Rick
Woodruff, Ben Butler
Staff Present:
Via Teleconference (Zoom): Daniel Bethapudi, Letica Zavala, Laurie Brewer, Mike Weisner,
Mike Westbrook, Jennifer Flor, Cindy Pospisil, Mike Maldonado, Christi Rawls, Jose Torres,
and Kress Carson
Visitors: Schneider Engineering: Ramsey Cripe and Emily Mullins
Public Attendees: Steve Sossamon
Regular Session
(This Regular Session may, at any time, be recessed to convene an Executive Session for any
purpose authorized by the Open Meetings Act, Texas Government Code 551.)
A. Call to Order -- Robert Case, Board Chairman
• Meeting called to order at 4:15 pm by Case.
B. Roll Call of Board Members -- Robert Case, Board Chairman.
C. Introduction of Visitors -- Robert Case, Board Chairman
• Schneider Engineering- Ramsey Cripe and Emily
Mullins
D. Recent Board Membership Changes—Robert Case, Board
Chairman
• Bill Sattler vacated Board position
• Robert Case appointed by City Council as Board Chairman
on 04/27/2021
• Benjamin Butler appointed as new board member by City
Council on 04/27/2021
• Butler shares background- spent the last 30 years with US
Army in numerous engineering and leadership roles;
certified Energy Manager and Professional Engineer; 12
years in the private sector in consulting and sustainability
management
Page 5 of 140
Legislative Session
E. Election of Vice Chairman- Robert Case- Board Chairman
• Case nominates Rick Woodruff; no further
nominations; seconded by Triggs
• Vote passes 5-0 and Rick Woodruff elected as Vice
Chairman of the Board
F. Review and Approval of Minutes
• April 15th Meeting- Motion to approve by Jones,
seconded by Woodruff
• Minutes approved as read 4-1 (Butler abstained, 1st
meeting)
Regular Session (cont.)
G. Public Wishing to Address the Board. -- Robert Case, Board Chairman
• Steve Sossamon prepared the following questions and are direct
quotes:
o 1. February 1, 2021, GUS changed the process on how much
Kwh credit would be reimbursed for GUS customers with
Solar PV Interconnect installations on personal residence.
Prior to Feb 1, 2021, ALL Kwh that was received by GUS from
the residence PV array was given credit to the GUS customer
at a rate of $0.049760. After February 1, 2021, the rate went
down because the PCA also went down to $0.04692 per
kilowatt hour.
Now the amount of credit is limited to the amount of kwH
actually used by the residence customer account.
Example of this is as follows:
If a customer used from the GUS a total of 100 Kwh during a
billing cycle and the customer overproduced on their solar
array and push 300 Kwh to GUS as electricity received, the
GUS customer only gets a credit applied for 100 Kwh and
GUS GETS 200 Kwh of FREE ELECTRICITY TO PROVIDE
TO OTHER GUS CUSTOMERS.
How do I as the provider of this 200 Kwh get compensated
for the Khw produced from my solar system ?
I have had my system online for three months and two of the
three months (Jan and Mar), I have overproduced. Of course, Page 6 of 140
Feb 2021 I did not due to the winter storm.
o 2. What is being done to ensure that the city of Georgetown
(GUS) not be exposed to another $40M+ bill from ERCOT for
having to purchase capacity at market prices that were on the
verge of price gouging?
As a customer, I would be open to a slightly increase charge
per Kwh if a consistent contract rate can be obtained versus
gambling against the market conditions as happened in
February 2021 and the winter storm that caused a lot of
damage. That said, I know that the GUS is planning on
issuing bonds to pay for the $40M+ bill. The PCA that is
currently being charged was planned to be removed
sometime in 2022.
o 3. Another question is will the PCA be used to pay off the
bonds being issued to pay the $40M+ and the PCA being
extended for the 10 year duration that the bonds are being
issued for?
• Sossamon addresses the question 1- claims that there are situations
that he overproduces on his PV system in which he is typically
credited for his amount of electricity put back on the city electric
grid. However, due to recent ordinance changes, he claims he no
longer is getting the appropriate amount credited to his account that
he puts on the electric grid. He asks for clarification of the
overproduction for those in his situation.
• For his next two questions- Sossamon claims that he understands
that an increase in rates if there is a consistent contract rate that
doesn’t leave the City exposed to market fluctuations.
• Questions are addressed by Daniel Bethapudi- General Manger of
Electric Utility:
o Bethapudi addresses the first question and explains that not
every rate payer of Georgetown has the ability to install solar
panels. When the program was designed, there was a need to
ensure there is not a cost shift between those who have panels
and those who do not in which the rates between the two
were not equitable.
o For the next two questions, Bethapudi explains that there are
current risks that need to be addressed to create predictable
rates. Even though the City was impacted by the Winter
Storm, the cost did not impact current customer rates.
Page 7 of 140
Regular Session (cont.)
H. General Managers Monthly Report- Daniel Bethapudi- General Manager of Electric
Utility
• Customer Service and Billing- Leticia Zavala-Customer Care Director
o Available Service: 60 new connections; total of 573 new connections of this
fiscal year
o 30,062 available services total
o 29,311 Electric customers/accounts
o 135 estimated “not good” or “any” meter reads; work orders put in to
investigate
o Overall Average April 2021 bills roughly $20 lower than April 2020
o Electric Revenue Breakdown and Receivables presented- roughly 50% of
yearly budgeted amount collected
o Account receivables aging report given- Zavala explains the collection
agency will begin collecting outstanding bills soon. Cindy Pospisil, Customer
Care Manager, clarifies that collection efforts are expected to begin the
coming Monday.
• Finance and Budgeting Report- Daniel Bethapudi, General Manager of Electric
Utility
o Summary of Revenue and Purchase Power Expense
▪ Electric revenues collected are currently above the budgeted amount
by roughly 2.5 million
▪ Bethapudi explains that February purchase power numbers are
removed from the report in order to explain usual trending
expenditures due to expenses incurred during the Winter Storm. This
is to be updated with to include the February numbers, but exclude
the Winter Storm numbers for the next meeting.
o Debt update
▪ $6.6 million for capital projects and equipment for FY 2021 were
successfully awarded on 05/11/2021. This is to be paid through electric
sales revenues.
▪ The winning bid interest rate was 1.733%, with a 9-year call option,
and amortization set to useful life of assets (7, 10, and 20 years) to
SAMCO Capital Markets
• Electric Engineering and Operations Report- Mike Westbrook- Electric Operations
Manager
o Electric Reliability (SAIFI)- .526 (Good Metric)
o Electric Outage Duration (CAIDI)-92.732 (Good Metric)
o Training- 98% (Good metric)
o Safety, 100% attendance
o Service Order Completion, 100%
o Preventative Maintenance, 100%
o Corrective Maintenance, 100%
o Recent Outages and Maintenance- One transformer replacement due to
recent storm due to wind and tree limbs. Overall system performed well in
recent storms Page 8 of 140
o Project Update- Along Highway 195/ Ronald Reagan -currently poles wire
installed from Highway 245 to Rattlesnake Blvd due to crossover and down
195 into the Glasscock Substation. This is significant because it gives
opportunity to backfeed into Sun City area and allows easier access to isolate
outages and move load when needed. This also is for preparation for the
Summer Hills project that is to be on the north side of Ronald Reagan.
o Project Update- Aviation Drive- professional development area- in current
planning process to build feed from two ends to accommodate future loads
in association with the LCRA for transformer needs.
o Woodruff asks when the Ronald Reagan project is expected to go live.
Westbrook answers that this is expected to be live by July.
o Bethapudi adds that these projects are typically debt funded and is
considered a system improvement rather than a load extension.
Legislative Session (cont.)
I. Distributed Energy Resources- Interconnection Application and Inspection Review-
Daniel Bethapudi, General Manager of Electric Utility, and Schneider Engineering
• Background given by Bethapudi-
o Issues were identified with the Interconnection Process that was processed
by the City’s Building and Permitting Departments. The issues included:
poor compliance with size and equipment requirements, poor record
keeping, no field verification, and poor recovery of costs through the
interconnection process. These issues could also lead to extenuating safety
issues if left unchecked.
o Interconnection Improvements projects include the interconnection process
overseen by the Electric Engineering group, simplifying the requirements,
and implement adequate review and inspection of installation.
o This also includes an online service portal built to facilitate DER
interconnection process and ultimately undertake a cost-of-service study to
identify cost for the process as performed by Schneider Engineering.
o An RFP has been issued and a provider for the portal has been identified to
manage this process.
o Current DER Application and Metering Fee: $245 ($35 Application Fee and
$210 Meter Fee)
• Cost of Service Study given by Ramsey Cripe of Schneider Engineering-
o Compiled by determining list of replicable activities required to complete
services including the following: employee responsible for activity,
estimated time of completion, and employee’s cost per hour.
o 3 Services Identified with the associated costs to the Utility:
▪ Application Inspection and Approval- $221.88
▪ Installation Inspection and Meter Installation- $436.94
▪ Additional Inspection Instance for failed inspection- $137.81 Page 9 of 140
o Recommended Fees
▪ Application Inspection and Approval- $250
▪ Installation Inspection and Meter Installation- $450
▪ Additional Inspection Instance for failed inspection- $150
o The fees were set as such to ensure longevity, flexibility in cost, and ease of
understanding
o Fee comparison- Recommended fees to Georgetown are higher than others in
the area. This is difficult to compare due to differing philosophies. Some
utilize subsidization based on renewable energy goals or to how much
exposure the system has to DER customers.
• Case asks if there is a specific trigger for a new cost of service study. Bethapudi
answers that essentially if actuals do not meet projected costs this would trigger such
a study to the fee structure.
• Woodruff asks if installations were considered into the study in which it could
potentially be easier to allow standardized turn-key installations by known
companies rather than services from smaller companies offering different installation
services that would potentially result in less work for the Utility. Bethapudi answers
that this is factored in the study. He references the City’s move to limit PV systems to
10 kW to ensure that this wouldn’t interfere with the City’s electric system addresses
this standardization and prevent a full interconnection study. He also mentions the
software portal that will facilitate the interconnection process will help identify
approved installers.
• Woodruff asks for clarification if the City does not concern with what is produced at
consumed at a customer’s home but does cause concern if the site is putting energy
back into the electric grid. Bethapudi answers that there must be adequate cost
recovery mechanisms built into the rates in which a customer can build a system in
such a way that they do have a need for City electricity but will need it in instances
similar to Winter Storm. In this case, if no preparations are in place, then the
customers who do not have panels installed are responsible to carry the cost rendered
during such an event.
• Bethapudi asks Cripe to explain customers that Schneider has served in which some
of the fees are created. Cripe explains that clients have implemented a pseudo-
demand-based fee for DER customers. Essentially a fixed fee per system or kilowatt
installed to ensure that costs are not shifted entirely on to non-solar customers.
• Jones asks if there are any inspections on some of the actual hardware on the
customers installation to determine quality. Bethapudi answers that this responsibility
lies between the customer and the DER installer. Inspection from the Utility point of
view focuses on only if it is safely connected to City grid, if labeling is adequate, and if
the City infrastructure could handle the load.
• Woodruff asks if there are any houses presently in Georgetown that have the ability to
pair battery storage in combination with solar practicability. Bethapudi answers that Page 10 of 140
to his knowledge, that there are none, but is something the Utility is looking into the
future in preparation for.
• Woodruff follows if this installation is followed through by a customer, would this be
allowed by the City. Bethapudi answers this should be allowed if energy from the
customer is isolated and not put back on the grid if there is an outage in the area. The
installation guidelines for this process are currently under review.
• Woodruff asks if battery storage penetration is being considered by the Utility, or in
the future will be. Bethapudi answers that as solutions come along, the Utility is
assessing new developments as they come along.
• Woodruff asks if there is a number of those customers with DER’s. Bethapudi answers
that the data is available but will have to present it for the next meeting.
Staff’s Recommendation to accept the proposed fee structure for new DER interconnection
applications with a Tentative start date July 1st 2021
MOTION by Woodruff to vote to approve proposed fee structure- Seconded by Jones.
APPROVED 5-0
MOTION by Jones, second by Woodruff to adjourn the Regular Session and move into Executive
Session. APPROVED 5-0 at 5:34 PM
Executive Session
In compliance with the Open Meetings Act, Chapter 551, Government Code, Vernon's Texas
Codes, Annotated, the items listed below will be discussed in closed session and are subject to
action in the regular session.
J. Section 551.086: Competitive Matters
• Purchased Power Update
MOTION by Jones, second by Woodruff to adjourn Executive Session. APPROVED 5-0
Adjournment
MOTION by Jones, second by Woodruff to adjourn the Board Meeting. APPROVED 5-0
Electric Board Meeting Adjourned at 5:57 PM.
Page 11 of 140
Page 12 of 140
City of Georgetown, Texas
Electric Utility Board
June 17, 2021
S UB J E C T:
G eneral Manager's Monthly R eport-Daniel Bethapudi- G eneral Manager of Elec tric Utility
IT E M S UMMARY:
F IN AN C IAL IMPAC T:
N/A
S UB MIT T E D B Y:
Daniel Bethapudi-G eneral Manager of Electric Utility
AT TAC H ME N T S:
Description Type
Quarterly Report Backup Material
Monthly Report Cover Memo
Page 13 of 140
FY2021 BUDGET
AND 5 YEAR CAPITAL IMPROVEMENT PLAN
Quarterly Report
Page 14 of 140
FINANCIAL REPORT AND INVESTMENT REPORT
For the Quarter Ended March 31, 2021
Table of Contents
Executive Summary .................................................................................................................................. 1-11
General Fund Schedule ............................................................................................................................... 12
Electric Fund Schedule ................................................................................................................................ 13
Water Services Fund Schedule .................................................................................................................... 14
Joint Services Fund Schedule ....................................................................................................................... 15
Council Discretionary Fund Schedule .......................................................................................................... 16
Convention & Visitors Bureau Fund Schedule ............................................................................................. 17
Airport Fund Schedule ................................................................................................................................. 18
Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 19
Georgetown Economic Development Corporation Fund Schedule ............................................................. 20
Quarterly Investment Report - City ........................................................................................................ 21-44
Quarterly Investment Report - GEDCO ................................................................................................... 45-50
Quarterly Investment Report - GTEC ...................................................................................................... 51-56
Grant Applications ....................................................................................................................................... 57
Capital Improvement Projects ................................................................................................................ 58-63
Long-term Commitments and Other Unfunded Liabilities ..................................................................... 64-67
Page 15 of 140
F FY2021 Quarterly Report
EXECUTIVE SUMMARY FOR THE QUARTER ENDED MAR. 31, 2021
I. QUARTERLY FINANCIAL ANALYSIS
Each year, the City amends the budget for multi‐year capital projects, as well as operational changes that were
unknown at the time the budget was adopted. The Second Quarter Report Approved Budget includes Capital Project
Roll Forward and Operational Amendments Approved by Council in January 2021. The February Winter Storm Uri had
a large impact on expenses for the second quarter. Council will consider amendments related to the storm during a
formal budget amendment in June 2021, which is in the third quarter. Furthermore, this report compares actuals to
budget, and compared to the performance of actuals in the same quarter in the previous year. Due to the timing of
the COVID‐19 pandemic starting in the second quarter of last year, the quarter‐to‐quarter comparisons may in some
cases stand out. However, many of these increases or decreases were expected during the 2021 budget planning
process and are generally not a concern.
GENERAL FUND REVENUES:
General Fund revenues total $48,858,157, or 59.02% of budget through this quarter of FY2021. Revenues exceed last
year’s same quarter total by $5,191,197, or 11.89%.
COG ‐ General Fund Financial Report
Period: YTD Actuals: Q2 FY21
Budget Quarterly Comparison
FY2021
YTD Actuals:
Q2 FY20
YTD Actuals:
Q2 FY21 YTD Variance % Varaince
Revenue
Taxes 41,208,025 24,251,223 26,730,147 2,478,924 10.22%
Fines and Penalties 388,392 211,780 156,400 (55,381) ‐26.15%
Investment Income 75,000 156,220 43,091 (113,128) ‐72.42%
Charges for Services 25,042,285 12,267,072 12,956,253 689,181 5.62%
Other Miscellaneous 871,955 96,158 398,441 302,283 314.36%
Donations and Grants 5,770,975 2,524,484 3,223,877 699,393 27.70%
70001:Transfers In 995,302 303,634 995,302 691,668 227.80%
70002:Transfers In ‐ ROI 8,431,375 3,856,389 4,354,647 498,258 12.92%
Revenue Total 82,783,309 43,666,959 48,858,157 5,191,197 11.89%
The difference between the same period last year is primarily driven by increases in building permits, continued
growth in sales tax, as well as one‐time master development contributions. Municipal Court fines and Interest Income
are both decreased compared to the same period last year due to the pandemic circumstances.
1Page 16 of 140
F FY2021 Quarterly Report
Sales tax revenue accounts for $18,576,250 of
budgeted revenues in the General Fund, or 22.44%.
Year‐to‐date sales tax revenue through the quarter
totals $7,431,798 million, or 40.01% of budget. Sales tax
data lags two months in arrears and while the impact of
COVID and the consumers’ shift to online retail was
difficult to quantify, sales tax continues to have a strong
performance. The second quarter returns for sales tax
were 16.79% higher compared to the same period last
year. The increase in sales tax revenue is the result of
continued growth in the City’s core sales tax sectors of
retail, food, and information, in combination with new
businesses coming online. Additionally, March of 2020
was the start of the pandemic resulting in dampened
sales taxes that period.
Property tax revenues are the second largest revenue segment in the General Fund and accounts for $15,976,505,
or 19.30% of the total revenue budget. Property tax revenue is typically received during the first two quarters of the
fiscal year, with most of the taxes collected in December and January. Through the quarter, property tax year‐to‐
date collections total 102.82% of budget, or $16,427,813. Year‐to‐date property tax revenues are 8.65% higher than
the same period last year. Year‐to‐date property tax revenue reflects Tax Increment Reinvestment Zone revenues
and will be journaled to the appropriate TIRZ funds in the 3rd quarter. After this transaction, staff expects property
tax collections to be on budget.
The City collects franchise fees for electric, natural gas, cable, and non‐cellular telephone services and represents
7.56% of budgeted revenue. Through the quarter, franchise fee revenues total $2,783,150 in FY2021, or 44.49% of
budget. Franchise fee revenue is 10.94% higher than the second quarter of FY2020.
Return on Investment (ROI) revenue from City‐owned utilities represents $8,431,375, or 10.18% of budgeted
revenues in the fund. Year‐to‐date, ROI revenues total $4,354,647, or 51.65% of budget. ROI revenue is $498,258, or
12.92% higher than the second quarter of FY2020.
Planning and Development related revenue continues to be strong in FY2021. Planning and Development revenue
total accounts for $6,499,325, or 7.85% of total General Fund budgeted revenue. Through the quarter, planning and
development related revenue totals $3,547,521 or 54.58% of budget. Development fees are up 33.68%, or $893,827
compared to the same quarter in FY2020. Staff continues to monitor the amount of residential building permits. The
following graph shows the number of residential building permits issued by quarter for the past 3 years.
276 311370
537
682 665
‐
200
400
600
800
Q1 Q2
Residential Building Permits
FY2019 FY2020 FY2021
1.5M
3.9M
1.7M
4.7M
1.8M
5.6M
K
1.5M
3.0M
4.5M
6.0M
Q1 Q2
GENERAL FUND SALES TAX
FY2019 FY2020 FY2021
2Page 17 of 140
F FY2021 Quarterly Report
Sanitation revenue totals $10,151,764, or 12.26% of total General Fund budgeted revenue. Through the quarter
sanitation revenue totals $5,316,194, or 52.37% of budget. Sanitation rates increased as part of the FY2021 budget
to support growing customer base as well as to support the debt service for a new transfer station. The variance
between the same period last year is $268,642, or 5.32%.
Fire and EMS revenue account for $8,012,095, or 9.68% of total General Fund budgeted revenue. Through the
quarter fire and EMS fee related revenue totals $4,044,351, or 50.48% of budget. Additional Fire/EMS revenue is
comprised of the Interlocal Agreement Emergency Services District 8 contract for service, as well as public safety
grants such as the SAFER grant.
Parks and Recreation fee revenue totals $1,893,234, or 2.29% of General Fund budgeted revenue. Through the
quarter, parks and recreation related fee revenue totals $669,866, or 35.38% of budget. Parks and Recreation
revenue is ‐44.56% compared to FY2020. The decrease in revenue is primarily driven by programming reductions
due to COVID 19. There are related decreases in Recreation expenses.
GENERAL FUND EXPENSES:
Annual expenses through the quarter total $38,181,440, or 46.70% of budget. This is a 4.5% decrease compared to
the same period last year. The decrease reflects the effort of the City to be fiscally conservative when planning FY2021
budget. Staff held on various positions, cut programming costs, and decreased travel budget because of the
anticipated impact of COVID.
COG ‐ General Fund Financial Report
Period: YTD Actuals w/Encumbrances: Q2 FY21
Budget Quarterly Comparison
FY2021
YTD Actuals
w/Encumbrances:
Q2 FY20
YTD Actuals
w/Encumbrances:
Q2 FY21 YTD Variance % Varaince
Expense
Personnel 45,566,994 22,744,841 21,031,143 1,713,698 ‐7.53%
Operations 34,685,857 15,132,908 16,250,215 (1,117,307)7.38%
Operating Capital 295,695 1,645,267 122,912 1,522,356 ‐92.53%
CIP Expense ‐ ‐ 17,780 (17,780)0.00%
Transfers 1,353,191 457,860 759,391 (301,531)65.86%
Expense Total 81,751,737 39,980,876 38,181,440 1,799,436 ‐4.50
Personnel and Operations Summary
Personnel costs through the quarter total $21,031,143, or 46.15% of personnel budget. Operational costs total
$16,250,215, or 46.85%. The table above includes all expenditures in the General Fund. Capital costs can fluctuate
from year‐to‐year based on project, timing, and various other factors, primarily in the Streets cost center.
Many departments in the General Fund were impacted by the February winter storm. The public safety division and
public works division were impacted the most. As part of the FY2021 Mid‐Year Budget Amendment, staff is proposing
additional appropriation to cover unforeseen overtime cost and operational costs related to the storm.
3Page 18 of 140
F FY2021 Quarterly Report
Personnel and Operations Summary by Division:
Administration Services Division (Administrative Services, City Council, and City Secretary) personnel and operational
expenditures for the quarter totals $5,338,883, which represents 53.11% of budget. General Government Contracts
includes budgeted vacancy savings estimates for all General Fund departments. Real vacancy savings is realized in
FY2021 Budget
YTD Actuals
w/Encumbrances:
Q2 FY21 Variance % of Budget
Development and Community Services
Personnel 6,157,720 2,529,677 3,628,043 41.08%
Operations 13,607,117 6,070,614 7,536,503 44.61%
Development and Community Services 19,764,838 8,600,291 11,164,547 43.51%
Finance Administration
Personnel 484,734 227,360 257,374 46.90%
Operations 100,389 37,511 62,878 37.37%
Finance Administration 585,123 264,871 320,253 45.27%
Police
Personnel 12,922,164 6,226,795 6,695,369 48.19%
Operations 3,973,436 1,944,051 2,029,385 48.93%
Police Total 16,895,600 8,170,846 8,724,753 48.36%
Fire and EMS
Personnel 18,084,000 8,025,483 10,058,517 44.38%
Operations 4,682,312 2,438,752 2,243,560 52.08%
Fire and EMS Total 22,766,312 10,464,235 12,302,077 45.96%
Administrative Services
Personnel 1,316,326 1,215,495 100,831 92.34%
Operations 8,735,940 4,123,388 4,612,552 47.20%
Administrative Services Total 10,052,266 5,338,883 4,713,383 53.11%
Library, Tourism, and Culture
Personnel 1,798,754 806,651 992,103 44.84%
Operations 1,097,007 592,677 504,330 54.03%
Library, Tourism and Culture Total 2,895,761 1,399,328 1,496,433 48.32%
Parks and Recreation
Personnel 4,803,296 1,998,198 2,805,098 41.60%
Operations 4,138,542 1,930,748 2,207,794 46.65%
Parks and Recreation 8,941,838 3,946,725 4,995,112 44.14%
4Page 19 of 140
F FY2021 Quarterly Report
each cost center. The budgeted vacancy factor against year‐to‐date actuals in the administrative division cost center
drives the percent of budget up. Staff will adjust and forecast the vacancy factor as part of the FY2021 projections.
Year‐to‐date personnel and operational expenditures for the Development and Community Services (Planning,
Inspections, Community Services, Code Enforcement, Animal Services, Environmental Services, Public Works, and
Streets) total $8,600,291, or 43.51% of budget.
Finance Administration which consists of Municipal Court totals $264,871, or 45.27% percent of budget through the
quarter.
Year‐to‐date the Library, Tourism, and Culture Division (Library and Arts and Culture) totals $1,399,328. This consists
of $806,651 of personnel costs and $592,677 of operational costs. As of this quarter, the Library, Tourism, and
Culture department is at 48.32% of budget.
Year‐to‐date the Parks and Recreation Division (Parks Administrations, Parks, Garey Park, Recreation, and Recreation
Programs) totals $3,946,725. This consists of $1,998,198 of personnel costs and $1,930,748 of operational costs. As
of this quarter, the Parks and Rec department is at 44.14% of budget.
Year‐to‐date personnel and operational expenditures for Fire and EMS through the quarter total $10,464,235 or
45.96% of budget. Personnel is 44.38% through the quarter.
Year‐to‐date personnel and operational expenditures for Police through the quarter totals $8,170,846 or 48.36% of
budget.
Overall, General Fund expenditures are within budget and the fund can cover the 90‐day Contingency Reserve
Economic Stability Reserve and the Benefit Payout Reserve. Additional available balances will be used to cover costs
of the winter storm during the third quarter budget amendment. The timing of FEMA reimbursement for the storm
is not known.
UTILITY FUNDS:
Electric Fund: The City has used multiple strategies in the past two years to improve the performance of the Electric
Fund in relation to past and current expenditures for purchased power contracts. These strategies include increasing
the Power Cost Adjustment rate to recover revenue, reducing operating and capital expenditures in the electric
utility, selling utility assets, hiring a new General Manager, contracting professional services for energy portfolio
management and risk oversight. These have resulted in improved financial performance of the fund. To improve
rate competitiveness for customers, the City lowered the Power Cost Adjustment in January of 2021 by 1 cent per
kWh, to 1.375 cents per kWh. This resulted in a $5 million decrease in Electric Revenue as part of the FY2021
Amended budget in January and is reflected in this report.
Many departments in the utility funds were impacted by the winter storm. The Electric and Water fund incurred
significant increases in overtime, operations, and equipment needs/replacement. As part of the FY2021 Mid‐Year
Budget Amendment, staff is proposing additional appropriation to cover unforeseen costs associated with the winter
storm. This amendment will post in June, or the third quarter. Therefore, expenses are reflected in this report, but
the budget will not change until the third quarter report.
5Page 20 of 140
F FY2021 Quarterly Report
COG ‐ Electric Services Financial Report
Period: Q2 FY21
Budget Quarterly Comparison
FY2021
YTD Actuals:
Q2 FY20
YTD Actuals:
Q2 FY21 YTD Variance % Variance
Operating Revenue
Taxes 120,732 2,932 2,389 (544)‐18.54%
Fines and Penalties 553,724 275,840 415,395 139,555 50.59%
Investment Income 5,000 3,700 20,765 17,065 461.20%
Charges for Services 82,889,381 39,703,518 39,004,137 (699,381)‐1.76%
Developer Contributions 1,500,000 1,793,905 3,266,695 1,472,790 82.10%
70001:Transfers In 1,379,308 ‐ 1,379,308 1,379,308 0.00%
Operating Revenue Total 86,448,145 41,779,895 44,088,688 2,308,792 5.53%
Non‐Operating Revenue
Other Miscellaneous Revenue 45,000 558,436 969,245 410,809 73.56%
Bond Proceeds 6,648,625 ‐ ‐ ‐0.00%
Non‐Operating Revenue Total 6,693,625 558,436 969,245 410,809 73.56%
Operating revenue in the Electric Fund totals $44,088,688 through the quarter, or 51.00% of budget. Electric sales
revenue, the largest component of operating revenue, accounts for 91.36% of the overall budgeted operating
revenue. Charges for Services is made up of electric sales revenue, administrative charges, and fees. The largest
component, electric sales revenue totals $36,867,522, or 46.68% of budget. Electric revenue sales are typically
higher in the summer months when consumption increases. Developer contributions were conservatively budgeted
at $1,500,000. Year‐to‐date collection total 3,266,695, or 217.78% of budget.
The budget for non‐operating revenue totals $6,693,625 in FY2021. This total includes bond proceeds for capital
projects in the amount of $6,648,625. Year‐to‐date non‐operating revenue is in line with the second quarter of
FY2020. The City will recognize bond proceeds as part of the annual debt sale in the spring, or the third quarter.
6Page 21 of 140
F FY2021 Quarterly Report
COG ‐ Electric Services Financial Report
Period: Q2 FY21
Budget Quarterly Comparison
FY2021
YTD Actuals
w/Encumbrances:
Q2 FY20
YTD Actuals
w/Encumbrances:
Q2 FY21 YTD Variance
%
Variance
Operating Expense
CC0001 Non‐Departmental 5,506,375 2,623,678 3,366,496 (742,817)28.31%
CC0521 Electric Technical 711,765 339,783 322,812 16,971 ‐4.99%
CC0522 Electric Administration 8,738,050 4,517,376 4,432,996 84,379 ‐1.87%
CC0524 Metering Services 2,009,379 980,754 1,072,252 (91,498)9.33%
CC0525 T&D Services 2,918,996 2,133,792 2,093,770 40,022 ‐1.88%
CC0537 Electric Resource 60,334,393 26,809,590 86,341,401 (59,531,812)222.05%
CC0555 Electric Systems 1,578,902 766,758 779,240 (12,482)1.63%
CC0557 Electrical Engineering 636,869 427,248 507,406 (80,158)18.76%
Operating Expense Total 82,434,729 39,450,849 99,083,205 (59,632,356)151.16%
Non‐Operating Expense
CC0001 Non‐Departmental 4,152,805 590,971 614,762 (23,791) 4.03%
CC0557 Electrical Engineering 8,166,143 46,849 2,569,283 (2,522,434) 5384.17%
CC0526 Systems Engineering ‐ 1,030,860 ‐1,030,860 ‐100.00%
Non‐Operating Expense Total 12,318,948 1,668,680 3,184,045 (1,515,365)90.81%
Operating expenses in the Electric Fund total $99,083,205 through the quarter. Year‐to‐date purchase power
expenses total $86,498,858, while net congestion revenue rights (CRRs) credits total $(246,957). Net purchase power
totals $86,251,901 through the quarter. This is due to congestion in the grid, as well as the price spike in the cost of
energy during the winter storm.
The polar vortex winter storm Uri caused significant disruption in the Texas energy market. This disruption led to
extreme price spikes in the cost of energy, and the City had a net obligation of approximately $48 million. The $48
million is beyond the City’s capacity to handle with current unrestricted reserves. For comparison, the annual cost of
energy is about $60 million. Therefore, the City has secured a Public Property Finance Contractual Obligation (PPFCO).
This is a tax‐backed obligation with a subordinate lien on Electric Utility revenues. The PPFCO has a 9.5‐year term,
with a 5‐year call option. This is a fixed rate bond (1.73% taxable) that was privately placed with Wells Fargo. It is
structured with level annual payments. The average annual principal and interest payment of $5,298,851 will be
repaid with Electric revenues from the City’s current Power Cost Adjustment of 1.375 per kWh.
In addition to overtime from the winter storm, personnel costs in Electric Engineering and Transmission and
Distribution (T&D) cost centers look inflated. This labor will be capitalized to the appropriate capital improvement
project at the end of the fiscal year, and therefore will be on budget at year‐end.
Non‐operating expenditures are budgeted at $12,318,948 in FY2021. Budgeted non‐operating expenditures include
$8,166,143 for capital projects and $4,152,805 for debt service payments, both of which typically trend towards later
7Page 22 of 140
F FY2021 Quarterly Report
quarters. As previously mentioned, a significant portion of labor expenses for capital projects will be journaled at the
end of the fiscal year.
Overall, even with the challenges of the winter storm, the Electric Fund is anticipated to end the year able to meet
the 90‐day contingency reserve requirement.
Water Fund:
Year‐to‐date Operating revenue totals $49,099,372, or 69.24% of budget. Charges for services which includes water,
wastewater, irrigation, and fees revenue total $28,640,949 through the quarter, or 69.24%. This revenue is up
19.50% compared to the same period last year. Impact fees total $18,800,000 in budgeted operating revenue, or
26.51%, of total operating revenue. Through the quarter, impact fees total $19,965,449. Water utility staff is working
to better estimate these fees for fiscal year‐end and for FY2022 planning. Total Water Fund operating revenue is up
20.82% compared to the same period last fiscal year due to growth in sales and collections in impact fees.
The budget for non‐operating revenue totals $17,412,500 in FY2021. This total includes bond proceeds for capital
projects in the amount of $16,300,000. The City will recognize bond proceeds as part of the annual debt sale in the
spring, or third quarter.
COG ‐ Water Services Financial Report
Period: Q2 FY21
Budget Quarterly Comparison
FY2021
YTD Actuals:
Q2 FY20
YTD Actuals:
Q2 FY21
YTD
Variance % Variance
Operating Revenue
Fines and Penalties 255,000 231,580 242,368 10,788 4.66%
Investment Income 237,250 950,050 250,606 (699,444)‐73.62%
Charges for Services 50,995,000 23,966,849 28,640,949 4,674,101 19.50%
Impact Fees 18,800,000 15,489,022 19,965,449 4,476,426 28.90%
Donations and Grants 625,000 ‐ ‐ ‐0.00%
Operating Revenue Total 70,912,250 40,637,501 49,099,372 8,461,871 20.82%
Non‐Operating Revenue
Other Miscellaneous Revenue 1,112,500 888,083 43,583 (844,500)‐95.09%
Bond Proceeds 16,300,000 ‐ ‐ ‐0.00%
Non‐Operating Revenue Total 17,412,500 888,083 43,583 (844,500)‐95.09%
Operating expenses in the Water Fund total $25,681,704 through the quarter, or 55.27% of budget. Operational
costs are trending slightly higher than 50%. This is normal as large encumbrances for contracts take place at the
beginning of the fiscal year. Personnel costs are also higher due to the winter storm overtime. Staff will continue to
monitor operational costs through the year.
Non‐operating expenditures are budgeted at $124,787,037 in FY2021. Budgeted non‐operating expenditures include
$116,395,525 for capital projects and $7,232,088 for debt service payments. Expenditures are $37,146,959 through
8Page 23 of 140
F FY2021 Quarterly Report
the quarter, which includes encumbrances for large projects. Annual principal and interest debt payments will post
to the third quarter.
Large variances between Systems Engineering and Water Operations cost centers compared to FY2020 are due to
data coding changes in the new financial software system and are not a concern.
COG ‐ Water Services Financial Report
Period: Q2 FY21
Budget Quarterly Comparison
FY2021
YTD Actuals
w/Encumbranc
es: Q2 FY20
YTD Actuals
w/Encumbrances:
Q2 FY21
YTD
Variance % Variance
Operating Expense
CC0001 Non‐Departmental 4,041,064 1,794,823 2,096,476 (301,653)16.81%
CC0526 Systems Engineering ‐ 15,453,382 409,649 15,043,733 ‐97.35%
CC0527 Water Services 26,385,392 12,548,450 14,541,823 (1,993,373)15.89%
CC0528 Water Distribution 2,717,500 1,450,686 1,813,594 (362,908)25.02%
CC0529 Water Plant 4,261,242 2,153,207 2,083,147 70,060 ‐3.25%
CC0530 Wastewater 896,100 552,811 386,775 166,035 ‐30.03%
CC0531 Wastewater Plant 3,956,455 2,081,504 2,060,124 21,380 ‐1.03%
CC0532 Irrigation 295,000 139,631 77,896 61,735 ‐44.21%
CC0553 Water Operations 3,916,787 9,559,259 2,212,220 7,347,039 ‐76.86%
Operating Expense Total 46,469,539 45,944,222 25,681,704 20,262,517 ‐44.10%
Non‐Operating Expense
CC0001 Non‐Departmental 4,083,411 515,954 534,920 (18,967)3.68%
CC0524 Metering Services 750,000 ‐ ‐ ‐0.00%
CC0526 Systems Engineering 99,630,405 3,482,714 22,386,283 (18,903,569)542.78%
CC0528 Water Distribution 1,159,424 ‐ 456,600 (456,600)0.00%
CC0529 Water Plant 2,757 ‐ ‐ ‐0.00%
CC0530 Wastewater 3,026,798 573,079 ‐ 573,079 ‐100.00%
CC0531 Wastewater Plant 2,050,000 ‐ ‐ ‐0.00%
CC0532 Irrigation 121,879 11,601 ‐ 11,601 ‐100.00%
CC0553 Water Operations 13,962,363 20,040 10,953,288 (10,933,248)54557.13%
Non‐Operating Expense 124,787,037 4,603,388 37,146,959 32,543,571 706.95%
9Page 24 of 140
F FY2021 Quarterly Report
OTHER MAJOR FUNDS:
Tourism Fund: The COVID‐19 pandemic significantly
impacted the tourism sector. Overall revenue in the
fund totals $341,760, or 32.55% of budget. Hotel
Occupancy Tax revenue totals $331,335 through the
quarter, or 36.81% of budget. Staff have continued to
market Georgetown and are pleased to see occupancy
rates recovering slowly but steadily.
Year to date expenses in the Convention & Visitors
Bureau Fund total $592,029 or 40.05% of budget. Staff
will continue to monitor this fund as travel is anticipated
to pick up in the spring and summer months. The City
has postponed the annual Red Poppy Festival in the
spring for a second year in a row. This will impact
revenues and expenditures in the fund during the
second quarter.
Airport Fund: Airport operating revenue budget totals $3,451,500. Airport Charges, the largest segment of revenue
totals $1,712,703. This includes revenue for fuel sales, facility lease, and hangar rentals. Revenues through the
quarter are $1,658,040, or 48.04% of budget.
Operation expenses in the Airport fund total $3,921,513. Year‐to‐date operation expenses totals $3,991,102 which
include a $2,430,989 encumbrance for annual fuel costs. Non‐operating revenues are bond proceeds for capital
projects. Non‐operating expenses are budgeted at $908,931 for CIP expense and the Airports debt service payments.
There is no activity in non‐operating for the quarter.
II. INVESTMENTS
The investment activity and strategies described in this report comply with the Public Funds Investment Act (PFIA),
the City’s investment policy, and generally accepted accounting principles. Activity for the second quarter of fiscal
year 2021 includes the maturing of financial institution deposits (CDs), reinvestment of CD’s, and investing of
consolidated funds in CD’s. Interest rates for money market accounts, Treasury bills, and CD’s decreased again during
this quarter. We are seeing a decline in rates being submitted for our competitive investment offerings due to no
positive changes in the market. We are also seeing a decline in the number of banks responding to our investment
offerings. The Federal Open Market Committee (FOMC) expect to keep the Federal Funds rate around 0%‐.25% due
to the COVID‐19 pandemic and the impacted economy for an extended period of time. These are the lowest rates
we have seen since December 2008. We expect the problem to be exacerbated in the Third Quarter due to the US
Treasury’s release of the billions of dollars for the American Rescue Plan. The City will continue soliciting for the best
rates to improve both diversity and yield, while keeping in mind safety and liquidity.
The Investment Reports for the quarter ending March 31, 2021, and the supporting schedules are attached. Valley
View Consulting, L.L.C., has prepared the attached investment reports. A component of our investment advisory
services contract includes Valley View preparing the quarterly investment reports on behalf of the City. A summary
of the investment balances at March 31, 2021, compared to the prior quarter, is shown below for the City, as well as
Georgetown Transportation Enhancement Corporation (GTEC) and Georgetown Economic Development Corporation
(GEDCO). Included in the City portfolio are debt service, consolidated funds, and bond proceeds. The breakdown is
consolidated at 71.83%, debt service at 6.35%, and bond proceeds at 21.82%.
309K
368K
249K
321K
141K
190K
K
100K
200K
300K
400K
Q1 Q2
HOTEL OCCUPANCY TAX
FY2019 FY2020 FY2021
10Page 25 of 140
F FY2021 Quarterly Report
CITY Book Value GTEC GEDCO
12/31/20 3/31/21 12/31/20 3/31/21 12/31/20 3/31/21
Total cash and
investments
$258,316,790 $276,385,252 $31,693,655 $33,083,118 $10,161,540 $11,095,498
Quarter End Average
Yield
.37% .21% .12% .06% .41% .08%
The City’s strategy continues to be matching maturities with cash flow needs, while focusing on the investment
policy’s long‐range goals. The City’s investment strategy is to “ladder” or stagger maturities, thus minimizing erratic
interest rate fluctuations. The City is continuing to manage the yield on bond proceeds for arbitrage purposes.
The City’s investment portfolio generally includes bank deposits, local government investment pool balances, money
market accounts, and financial institution deposits (CD’s). All of these investments meet the safety requirements of
the PFIA. Local Government Investment Pools must maintain a rating of AAAm, Securities (Treasury Bills) must have
direct or implied backing of the Federal Government and Financial Institution Deposits (CDs and money market
accounts) must be collateralized with FDIC insurance or obligations with an implied backing from the Federal
Government. The collateral on all City investments are monitored monthly to ensure the financial institutions carry
minimum collateral of 100% with a letter of credit or 102% with pledged securities for all of the City’s investments.
All securities held by financial institutions as collateral on behalf of the City have been reviewed and met PFIA‐
minimum rating criteria.
The City continues to work with the City’s depository bank (JPMorgan Chase) to find an average daily balance that is
best to receive the highest yield on the account. These balances earn credit against the fees charged by the bank.
The City will continue to verify depository yield versus investment yield to achieve the best outcome.
III. CAPITAL PROJECTS
The projects in the Capital Improvement Program (CIP) consist of infrastructure and related construction and do not
include small capital items such as furniture, equipment, and vehicle maintenance. Maintenance‐type projects are
not capitalized as a fixed asset and are usually cash funded. Therefore, these projects are operational in nature and
are in the departmental operating budget.
A life‐to‐date schedule for each of the approved projects is included in the quarterly report. This means the budget
and spending in the report are for all fiscal years of the project, not just the current fiscal year or quarter. This view
provides a more comprehensive picture of the City’s capital program. Projects are grouped based on fund, division,
and cost center.
11Page 26 of 140
COG ‐ General Fund Financial Report
Period: Mar‐21 Budget Period
FY2021 Mar‐21
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 15,548,923 15,548,923 ‐ 100.00%
Revenue
40001:Property Taxes 15,976,505 315,215 16,427,813 451,308 102.82%
40002:Sales Taxes 18,576,250 1,585,830 7,431,798 (11,144,452) 40.01%
40005:Franchise Taxes 6,255,270 311,590 2,783,150 (3,472,120) 44.49%
40008:Other Taxes 400,000 17,858 87,386 (312,614) 21.85%
41001:Fines 328,392 29,515 107,775 (220,617) 32.82%
41002:Penalties 60,000 9,962 48,624 (11,376) 81.04%
42001:Interest Income 75,000 (273) 43,091 (31,909) 57.46%
43001:Fees 7,028,184 634,010 3,294,925 (3,733,259) 46.88%
43002:Garbage Charges 10,151,764 1,031,222 5,316,194 (4,835,570) 52.37%
43003:Permits 4,317,750 377,405 2,562,111 (1,755,639) 59.34%
43004:Administrative Charges 3,396,447 282,708 1,696,251 (1,700,196) 49.94%
43005:Rental Revenue 148,140 12,067 86,772 (61,368) 58.57%
44001:Grant Revenue 679,884 241,317 433,004 (246,880) 63.69%
44502:Developer Contributions ‐ 253,798 423,328 423,328 0.00%
44503:Interlocal Agreement Revenue 5,091,091 1,183,773 2,367,546 (2,723,546) 46.50%
45001:Misc Revenue 871,955 83,456 398,441 (473,514) 45.70%
70001:Transfers In 995,302 ‐ 995,302 ‐ 100.00%
70002:Transfers In ‐ ROI 8,431,375 782,613 4,354,647 (4,076,728) 51.65%
Revenue Total 82,783,309 7,152,065 48,858,157 (33,925,152) 59.02%
Expense
CC0001 Non‐Departmental 1,353,191 980 762,585 590,606 56.35%
CC0107 Planning 1,860,789 68,685 789,558 1,071,232 42.43%
CC0202 Parks Administration 662,224 38,834 305,057 357,168 46.07%
CC0210 Library 2,837,904 139,250 1,371,235 1,466,669 48.32%
CC0211 Parks 2,721,425 149,038 1,361,495 1,359,930 50.03%
CC0212 Recreation 2,897,351 152,822 1,333,703 1,563,648 46.03%
CC0213 Tennis Center 442,917 23,390 180,507 262,410 40.75%
CC0214 Recreation Programs 1,237,960 38,229 288,675 949,285 23.32%
CC0215 Garey Park 979,961 50,983 477,289 502,672 48.70%
CC0218 Arts and Culture 57,857 4,832 28,093 29,764 48.56%
CC0316 Municipal Court 585,123 29,002 264,871 320,253 45.27%
CC0402 Fire Support Services/Administration 4,254,731 209,053 1,815,670 2,439,060 42.67%
CC0422 Fire Emergency Services 15,932,476 658,855 7,230,849 8,701,626 45.38%
CC0448 EMS 2,579,106 130,215 1,417,575 1,161,530 54.96%
CC0533 Environmental Services 9,662,924 757,899 3,775,444 5,887,481 39.07%
CC0536 Inspection Services 1,519,534 62,115 633,417 886,118 41.68%
CC0602 Administrative Services 1,893,883 78,346 876,168 1,017,715 46.26%
CC0605 Community Services 353,889 13,420 201,966 151,922 57.07%
CC0634 City Council Services 185,734 23,593 99,423 86,311 53.53%
CC0635 City Secretary Services 1,000,047 83,695 473,228 526,818 47.32%
CC0638 General Government Contracts 4,774,808 353,655 2,729,217 2,045,591 57.16%
CC0655 Communications/Public Engagement 844,604 31,700 398,261 446,343 47.15%
CC0702 Police Administration 2,559,766 193,991 1,235,898 1,323,869 48.28%
CC0742 Police Operations 14,335,833 645,197 6,934,948 7,400,885 48.37%
CC0744 Animal Services 1,106,702 50,600 460,114 646,588 41.58%
CC0745 Code Compliance 562,584 25,977 229,168 333,416 40.73%
CC0802 Public Works 1,462,292 333,850 1,032,233 430,059 70.59%
CC0846 Streets 3,086,124 162,828 1,474,794 1,611,330 47.79%
Expense Total 81,751,737 4,511,034 38,181,440 43,570,297 46.70%
Excess (Deficiency) of Total Revenue over Total Requirements 1,031,571 2,641,031 10,676,717 11,708,288 1035.00%
Ending Fund Balance 16,580,494 26,225,640 9,645,145 158.17%
Reserves
Contingency 12,626,752 12,626,752 ‐ 100.00%
Benefit Payout Reserve 340,000 340,000 ‐ 100.00%
Economic Stability Reserve 1,467,563 1,467,563 ‐ 100.00%
Reserves Total 14,434,315 14,434,315 ‐ 100.00%
Available Fund Balance 2,146,179 11,791,325 9,645,145 549.41%
YTD Actuals Budget vs. Actuals
12Page 27 of 140
COG ‐ Electric Services Financial Report
Period: Mar‐21
Budget Period
FY2021 Mar‐21
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 19,702,705 ‐ 19,702,705 ‐ 100.00%
Operating Revenue
40002:Sales Taxes 5,000 387 2,389 (2,611) 47.77%
40005:Franchise Taxes 115,732 ‐ ‐ (115,732) 0.00%
41002:Penalties 553,724 87,911 415,395 (138,329) 75.02%
42001:Interest Income 5,000 95 20,765 15,765 415.30%
43001:Fees 685,000 65,060 525,563 (159,437) 76.72%
43004:Administrative Charges 3,222,103 268,509 1,611,051 (1,611,052) 50.00%
43601:Electric Sales Revenue 78,982,278 6,277,631 36,867,522 (42,114,756) 46.68%
44502:Developer Contributions 1,500,000 896,117 3,266,695 1,766,695 217.78%
70001:RC0225 Transfer In ‐ GEDCO 1,000,000 ‐ 1,000,000 ‐ 100.00%
70001:RC0241 Transfer In ‐ South TIRZ 379,308 ‐ 379,308 ‐ 100.00%
Operating Revenue Total 86,448,145 7,595,710 44,088,688 (42,359,457) 51.00%
Opearating Expense
CC0001 Non‐Departmental 5,506,375 616,009 3,366,496 2,139,879 61.14%
CC0521 Electric Technical Services 711,765 32,596 322,812 388,953 45.35%
CC0522 Electric Administration 8,738,050 712,730 4,432,996 4,305,053 50.73%
CC0524 Metering Services 2,009,379 142,210 1,072,252 937,127 53.36%
CC0525 T&D Services 2,918,996 258,852 2,093,770 825,226 71.73%
CC0526 Systems Engineering ‐ ‐ 166,831 (166,831) 0.00%
CC0537 Electric Resource Management 60,334,393 8,207,405 86,341,401 (26,007,008) 143.10%
CC0555 Electric Systems Operations 1,578,902 60,823 779,240 799,663 49.35%
CC0557 Electrical Engineering 636,869 68,341 507,406 129,463 79.67%
Operating Expense Total 82,434,729 10,098,967 99,083,205 (16,648,476) 120.20%
Net Operations Total 4,013,416 (2,503,258) (54,994,517) (59,007,933) ‐1370.27%
Non‐Operating Revenue
45001:Misc Revenue 35,000 53,977 76,471 (41,471) 218.49%
45004:Sale of Property 10,000 736,303 892,773 (882,773) 8927.73%
46001:Bond Proceeds 6,648,625 ‐ ‐ 6,648,625 0.00%
Non‐Operating Revenue Total 6,693,625 790,280 969,245 (5,724,380) 14.48%
Non‐Operating Expenses
CC0001 Non‐Departmental 4,152,805 ‐ 614,762 3,538,043 14.80%
CC0557 Electrical Engineering 8,166,143 215,458 2,569,283 5,596,859 31.46%
Non‐Operating Expense Total 12,318,948 215,458 3,184,045 9,134,903 25.85%
Net Non‐Operations Total (5,625,323) 574,822 (2,214,800) 3,410,522 39.37%
Excess (Deficiency) of Total Revenue over Total Requirements (1,611,907) (1,928,436) (57,209,317) (58,821,224) 3549.17%
Ending Fund Balance 18,090,798 (1,928,436) (37,506,612) (55,597,410) ‐207.32%
Reserves
Contingency Reserve 4,018,754 ‐ 4,018,754 ‐ 100.00%
Non‐Operational Reserve 10,594,999 ‐ 10,594,999 ‐ 100.00%
Bond Proceeds Reserve 3,477,046 ‐ 3,477,046 ‐ 100.00%
Reserves Total 18,090,799 18,090,799 ‐ 100.00%
Available Fund Balance 0 (55,597,411) 55,597,411 0.00%
YTD Actuals Budget vs. Actuals
13Page 28 of 140
COG ‐ Water Services Financial Report
Period: Mar‐21
Budget Period
FY2021 Mar‐21
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 115,511,818 ‐ 115,511,818 ‐ 100.00%
Operating Revenue
41002:Penalties 255,000 46,303 242,368 (12,632) 95.05%
42001:Interest Income 237,250 1,712 250,606 (13,356) 105.63%
43001:Fees 4,290,000 915,470 4,747,148 (457,148) 110.66%
43005:Rental Revenue 55,000 3,650 55,594 (594) 101.08%
43602:Water Charges 32,150,000 3,102,651 16,574,767 15,575,233 51.55%
43603:Wastewater Charges 14,200,000 1,453,604 7,127,251 7,072,749 50.19%
43604:Irrigation Charges 300,000 11,121 136,188 163,812 45.40%
41602:Impact Fees 18,800,000 3,899,006 19,965,449 (1,165,449) 106.20%
44502:Developer Contributions 625,000 ‐ ‐ 625,000 0.00%
Operating Revenue Total 70,912,250 9,433,517 49,099,372 21,812,878 69.24%
Operating Expense
CC0001 Non‐Departmental 4,041,064 352,305 2,096,476 1,944,588 51.88%
CC0526 Systems Engineering ‐ 5,064 409,649 (409,649) 0.00%
CC0527 Water Services Administration 26,385,392 2,058,444 14,541,823 11,843,569 55.11%
CC0528 Water Distribution 2,717,500 563,004 1,813,594 903,906 66.74%
CC0529 Water Plant Management 4,261,242 239,904 2,083,147 2,178,095 48.89%
CC0530 Wastewater Operations 896,100 51,208 386,775 509,325 43.16%
CC0531 Wastewater Plant Management 3,956,455 338,064 2,060,124 1,896,331 52.07%
CC0532 Irrigation Operations 295,000 2,590 77,896 217,104 26.41%
CC0553 Water Operations 3,916,787 170,195 2,212,220 1,704,566 56.48%
Operating Expense Total 46,469,539 3,780,776 25,681,704 20,787,835 55.27%
Net Operations Total 24,442,711 5,652,740 23,417,668 (1,025,043) 95.81%
Non‐Operating Revenue
45001:Misc Revenue 1,112,500 8,759 43,583 (1,068,917) 3.92%
46001:Bond Proceeds 16,300,000 ‐ ‐ (16,300,000) 0.00%
Non‐Operating Revenue Total 17,412,500 8,759 43,583 (17,368,917) 0.25%
Non‐Operating Expenses
CC0001 Non‐Departmental 4,083,411 ‐ 534,920 3,548,491 13.10%
CC0524 Metering Services 750,000 ‐ ‐ 750,000 0.00%
CC0526 Systems Engineering 99,630,405 2,239,837 22,949,004 76,681,401 23.03%
CC0528 Water Distribution 1,159,424 ‐ 781,316 378,108 67.39%
CC0529 Water Plant Management 2,757 ‐ ‐ 2,757 0.00%
CC0530 Wastewater Operations 3,026,798 ‐ 533,080 2,493,718 17.61%
CC0531 Wastewater Plant Management 2,050,000 ‐ ‐ 2,050,000 0.00%
CC0532 Irrigation Operations 121,879 ‐ 9,606 112,273 7.88%
CC0553 Water Operations 13,962,363 950,148 12,748,682 1,213,681 91.31%
Non‐Operating Expenses Total 124,787,037 3,184,921 37,146,959 87,640,078 29.77%
Net Non‐Operations Total (107,374,537) (3,176,162) (37,103,376) 70,271,161 34.56%
Excess (Deficiency) of Total Revenue over Total Requirements (82,931,826) 2,476,579 (13,685,708) (96,617,534) 16.50%
Ending Fund Balance 32,579,992 2,476,579 101,826,110 69,246,118 312.54%
Reserves
Contingency Reserve 9,127,742 ‐ 9,127,742 ‐ 100.00%
Debt Service Reserve 10,000,000 ‐ 10,000,000 ‐ 100.00%
19,127,742 ‐ 19,127,742 ‐ 100.00%
Available Fund Balance 13,452,250 82,698,368 69,246,118 614.75%
YTD Actuals Budget vs. Actuals
14Page 29 of 140
COG - Joint Services Financial Report
Period: Mar-21
Budget Period
FY2021 Mar-21
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 2,032,470 - 2,032,470
Revenue
41002:Penalties - 3,505 15,399 15,399 0.00%
42001:Interest Income 6,250 - 4,822 (1,428) 77.16%
43001:Fees 173,600 1,290 6,660 (166,940) 3.84%
43004:Administrative Charges 17,967,880 1,497,575 8,985,447 (8,982,433) 50.01%
43005:Rental Revenue - - 100 100 0.00%
45001:Misc Revenue - - 431 431 0.00%
45002:Insurance Proceeds - 8,642 40,906 40,906 0.00%
45003:Misc Reimbursements 83,000 516 31,498 (51,503) 37.95%
Revenue Total 18,230,730 1,511,528 9,085,263 (9,145,467) 49.83%
Expense
CC0001 Non-Departmental 609,999 83,336 659,835 (49,836) 108.17%
CC0302 Finance Administration 1,222,909 86,269 635,959 586,950 52.00%
CC0315 Accounting 1,295,484 83,065 669,152 626,333 51.65%
CC0317 Purchasing 1,001,969 52,626 447,378 554,592 44.65%
CC0321 Customer Care 5,986,413 400,067 3,068,843 2,917,570 51.26%
CC0503 Organizational and Operational Excellence 342,009 11,260 139,619 202,390 40.82%
CC0526 Systems Engineering 2,752,912 132,669 1,399,602 1,353,309 50.84%
CC0534 Conservation 806,212 13,996 255,552 550,660 31.70%
CC0637 Economic Development 568,690 30,472 274,613 294,076 48.29%
CC0639 Human Resources 1,502,553 62,284 680,192 822,361 45.27%
CC0640 Citywide Human Resources 1,219,444 53,145 727,612 491,832 59.67%
CC0654 Legal 1,047,947 45,509 524,347 523,600 50.04%
Expense Total 18,356,541 1,053,877 9,482,704 8,873,838 51.66%
Excess (Deficiency) of Total Revenue over Total Requirements (125,811) 457,651 (397,440) (523,252) 315.90%
Ending Fund Balance 1,906,659 1,635,030
Reserves
Contingency Reserve 1,906,658 1,906,658 - 100.00%
Debt Service Reserve - - 0.00%
Reserve Total 1,906,658 - 1,906,658 - 100.00%
Avaiable Fund Balance 1 (271,628) (271,629) -39945363.25%
Actuals Budget vs. Actuals
15Page 30 of 140
COG - Council Discretionary Financial Report
Period: Mar-21
Budget Period
FY2021 Mar-21
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 110,483 110,483 - 100.00%
Revenue
Investment Income 500 - 121 (379) 24.28%
42001:Interest Income 500 - 121 (379) 24.28%
Revenue Total 500 - 121 (379) 24.28%
Expense
Transfers 110,983 - 110,983 - 100.00%
Expense Total 110,983 - 110,983 - 100.00%
Excess (Deficiency) of Total Revenue over
Total Requirements (110,483) - (110,862) (221,345) 100.34%
Ending Fund Balance - (379) (379) #DIV/0!
Actuals Budget vs. Actuals
16Page 31 of 140
COG - Tourism Financial Report
Period: Mar-21
Budget Period
FY2021 Mar-21
YTD Actuals w/
Encumbrances Variance % of Budget
Beginning Fund Balance 1,282,917 - 1,282,917 - 100.00%
Revenue
40008:Other Taxes 900,000 78,698 331,335 (568,665) 36.81%
42001:Interest Income 5,000 - 3,070 (1,930) 61.40%
45001:Misc Revenue 95,000 1,205 7,355 (87,645) 7.74%
44505:Sponsorship 50,000 - - (50,000) 0.00%
Revenue Total 1,050,000 79,903 341,760 (708,240) 32.55%
Expense
Personnel 435,456 12,136 161,137 274,319 37.00%
Operations 1,014,085 23,255 402,258 611,827 39.67%
Transfers 28,634 - 28,634 - 100.00%
Expense Total 1,478,175 35,391 592,029 886,146 40.05%
Excess (Deficiency) of Total Revenue
over Total Requirements (428,175) 44,512 (250,269) (678,445) 58.45%
Reserves
Contingency Reserve 305,771 305,771 100.00%
Reserves Total 305,771 305,771 100.00%
Ending Fund Balance 548,971 - 726,877 177,906 132.41%
Actuals Budget vs. Actuals
17Page 32 of 140
COG - Airport Financial Report
Period: Mar-21
Budget Period
FY2021 Mar-21
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 1,428,114 - 1,428,114 - -
Operating Revenue
40001:Property Taxes 40,000 - (57,018) (97,018) -142.54%
42001:Interest Income 3,000 1 2,355 (645) 78.50%
43606:Airport Charges 3,408,500 398,177 1,712,703 (1,695,797) 50.25%
Operating Revenue Total 3,451,500 398,178 1,658,040 (1,793,460) 48.04%
Operarting Expense
Personnel 429,433 15,832 199,340 230,093 46.42%
Operations 3,138,013 297,604 3,790,502 (652,489) 120.79%
Operating Capital 354,067 - 1,261 352,806 0.36%
Operating Expense Total 3,921,513 313,436 3,991,102 (69,589) 101.77%
Total Net Operations (470,013) 84,741 (2,333,062) (1,723,870) 496.38%
Non-Operating Revenue
45001:Misc Revenue 5,000 - - (5,000) 0.00%
46001:Bond Proceeds 700,000 - - (700,000) 0.00%
Non-Operating Revenue Total 705,000 - - (705,000) 0.00%
Non-Operating Expense
CIP Expense 750,000 - - 750,000 0.00%
Debt Service 158,931 - 26,899 132,032 16.92%
Non-Operating Expense Total 908,931 - 26,899 882,032 2.96%
Net Non-Operations Total (203,931) (26,899) 177,032 13.19%
Excess (Deficiency) of Total Revenue
over Total Requirements (673,944) 84,741 (2,359,961) (3,033,904) 450.17%
Ending Fund Balance 754,170 (931,847) (3,310,902) -123.56%
Reserves
Contingency Reserve 332,917 332,917 100%
Debt Service Reserve 141,478 141,478 100%
Reserves Total 474,395 474,395 100%
Available Fund Balance 279,775 (1,406,242) (1,686,017) -503%
YTD Actuals Budget Vs. Actuals
18Page 33 of 140
COG - GTEC Financial Report
Period: Mar-21
Budget Period
FY2021 Mar-21
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 26,022,482 26,022,482 - 100.00%
Operating Revenue
40002:Sales Taxes 8,255,000 704,723 3,302,454 (4,952,546) 40.01%
42001:Interest Income 60,000 1,616 16,769 (43,231) 27.95%
Operating Revenue Total 8,315,000 706,339 3,319,223 (4,995,777) 39.92%
Operarting Expense
Operations 402,962 33,514 219,771 183,191 54.54%
Operating Capital - - 4,140 (4,140) 0.00%
Transfers 2,763,242 - 420,122 2,343,120 15.20%
Operating Expense Total 3,166,204 33,514 644,034 2,522,170 20.34%
Total Net Operations 5,148,796 672,826 2,675,190 (7,517,947) 51.96%
Non-Operating Revenue
46001:Bond Proceeds 10,600,000 - - (10,600,000) 0.00%
Non-Operating Revenue Total 10,600,000 - - (10,600,000) 0.00%
Non-Operating Expense
Operations 1,984,375 - - 1,984,375 0.00%
CIP Expense 23,076,813 67,410 545,157 22,531,656 2.36%
Debt Service 1,053,050 - 110,525 942,525 10.50%
Non-Operating Expense Total 26,114,238 67,410 655,682 25,458,556 2.51%
Net Non-Operations Total (15,514,238) (67,410) (655,682) 14,858,556 4.23%
Excess (Deficiency) of Total Revenue
over Total Requirements (10,365,442) 605,416 2,019,508 (8,345,934) 80.52%
Ending Fund Balance 15,657,040 28,041,990 12,384,950 179.10%
Reserves
Contingency Reserve 1,984,375 1,984,375
Debt Service Reserve 3,494,232 3,494,232
Reserves Total 5,478,607 5,478,607
Available Fund Balance 10,178,433 22,563,383 12,384,950 221.68%
YTD Actuals Budget Vs. Actuals
19Page 34 of 140
COG - GEDCO Financial Report
Period: Mar-21
Budget Period
FY2021 Mar-21
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 8,845,777 - 8,845,777 - 100.00%
Operating Revenue
40002:Sales Taxes 2,063,750 176,181 825,614 (1,238,136) 40.01%
42001:Interest Income 19,000 451 21,010 2,010 110.58%
Operating Revenue Total 2,082,750 176,632 846,624 (1,236,126) 40.65%
Operarting Expense
Operations 593,783 36,168 227,997 365,786 38.40%
Transfers 1,200,169 - 1,040,084 160,085 86.66%
Operating Expense Total 1,793,952 36,168 1,268,082 525,870 70.69%
Total Net Operations 288,798 140,464 (421,458) (1,761,996) -145.94%
Non-Operating Revenue
Non-Operating Expense
Operations 8,256,391 - 400,000 7,856,391 4.84%
Debt Service 90,572 - - 90,572 0.00%
Non-Operating Expense Total 8,346,963 - 400,000 7,946,963 4.79%
Net Non-Operations Total (8,346,963) - (400,000) 7,946,963 4.79%
Excess (Deficiency) of Total Revenue
over Total Requirements (8,058,165) 140,464 (821,458) (8,879,623) 110.19%
Ending Fund Balance 787,612 140,464 8,024,319 7,236,707 1018.82%
Reserves
Contingency Reserve 505,468 505,468
Debt Service Reserve 202,769 202,769
Reserves Total 708,237 708,237
Available Fund Balance 79,375 - 7,316,082 7,236,707 9217.11%
YTD Actuals Budget Vs. Actuals
20Page 35 of 140
CITY
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
March 31, 2021
Prepared by
Valley View Consulting, L.L.C.
________________________________________________________________________
Leigh Wallace Nathan Parras
Finance Director Assistant Finance Director
________________________________________________________________________
Karrie Pursley Elaine Wilson
Treasurer Assistant Finance Director
The investment portfolio of the City of Georgetown is in compliance with the Public Funds Investment Act and
the Investment Policy and Strategies.
Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or
completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from
sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective
of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total
return yields and do not account for investment advisor fees.
21Page 36 of 140
Economic Overview 3/31/2021
The Federal Open Market Committee (FOMC) maintained the Fed Funds target range at 0.00% to 0.25% (Effective Fed Funds are trading <0.10%), and projected that reduced rates could remain
into 2023 or longer. Fourth Quarter GDP finalized at +4.3%. March Non Farm Payroll added 916k and Unemployment declined to 6.0%. Crude oil traded above $60 per barrel. The Stock Markets
reached new highs. Housing, Industrial Production, Durable Goods, Consumer Spending, and other indicators showed solid gains. An additional $1.9 trillion stimulus package passed Congress and
was signed by the President. The Yield Curve continued steepening on longer maturities.
0
250
500
750
1,000
1,250
1,500
1,750
2,000
2,250
2,500
2,750
3,000
3,250
3,500
3,750
4,000
4,250
S&P 500
0.00
0.50
1.00
1.50
2.00
2.50
3.00
3.50 US Treasury Historical Yields - Since Nov 2015
Six Month T-Bill Two Year T-Note Ten Year T-Note
0.00
0.20
0.40
0.60
0.80
1.00
1.20
1.40
1.60
1.80
2.00 Treasury Yield Curves
March 31, 2020 December 31, 2020 March 31, 2021
0.00
0.50
1.00
1.50
2.00
2.50
3.00
3.50
4.00
4.50
5.00
5.50
6.00 US Treasury Historical Yields - Since 2006
Six Month T-Bill Two Year T-Note Ten Year T-Note
Valley View Consulting, L.L.C.22Page 37 of 140
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Demand Accounts 15,461,481$ 15,461,481 15,550,035$ 15,550,035$ 0.22%
NOW/MMA 12,024,426 12,024,426 11,019,484 11,019,484 0.33%
Pools 108,820,032 108,820,032 144,095,312 144,095,312 0.02%
CDs/Securities 122,010,850 122,010,850 105,720,421 105,720,421 0.45%
Totals 258,316,790$ 258,316,790$ 276,385,252$ 276,385,252$ 0.21%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.21%Total Portfolio 0.29%
Rolling Three Month Treasury 0.06%Rolling Three Month Treasury 0.08%
Rolling Six Month Treasury 0.09%Rolling Six Month Treasury 0.10%
TexPool 0.02%TexPool 0.05%
Bank Fees Offset
10,568$
Interest earnings provided in separate report.18,679$
December 31, 2020
(1)Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not
considered. The yield for the reporting month is used for bank, pool, and money market balances.
(2)Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return
analysis or account for advisory fees.
Quarterly Bank Fees Offset
Year-to-date Bank Fees Offset
March 31, 2021
City of Georgetown Valley View Consulting, L.L.C.23Page 38 of 140
City - Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
JPMorgan Chase Cash (3)0.22%04/01/21 03/31/21 15,550,035$ 15,550,035$ 1.00 15,550,035$ 1 0.22%
JPMorgan Chase MMA 0.03%04/01/21 03/31/21 434,048 434,048 1.00 434,048 1 0.03%
Veritex Bank MMA 0.10%04/01/21 03/31/21 3,213,253 3,213,253 1.00 3,213,253 1 0.10%
NexBank MMA 0.45%04/01/21 03/31/21 7,372,182 7,372,182 1.00 7,372,182 1 0.45%
TexPool AAAm 0.02%04/01/21 03/31/21 58,862,442 58,862,442 1.00 58,862,442 1 0.02%
TexSTAR AAAm 0.02%04/01/21 03/31/21 85,232,871 85,232,871 1.00 85,232,871 1 0.02%
Prosperity Bank CD 0.45%04/01/21 07/01/20 4,006,098 4,006,098 100.00 4,006,098 1 0.45%
Independent Bank CD 1.80%04/22/21 10/22/19 4,193,238 4,193,238 100.00 4,193,238 22 1.81%
Bank OZK CD 0.70%05/10/21 05/08/20 12,070,246 12,070,246 100.00 12,070,246 40 0.70%
Southside Bank CD 0.22%06/11/21 09/11/20 5,005,456 5,005,456 100.00 5,005,456 72 0.22%
Bank OZK CD 0.30%06/11/21 09/11/20 5,007,443 5,007,443 100.00 5,007,443 72 0.30%
Prosperity Bank CD 0.60%07/01/21 07/01/20 4,012,075 4,012,075 100.00 4,012,075 92 0.60%
Prosperity Bank CD 0.70%07/15/21 07/15/20 5,017,615 5,017,615 100.00 5,017,615 106 0.70%
Prosperity Bank CD 0.15%08/10/21 02/10/21 3,000,345 3,000,345 100.00 3,000,345 132 0.15%
Prosperity Bank CD 0.40%08/23/21 08/21/20 6,257,488 6,257,488 100.00 6,257,488 145 0.40%
R Bank CD 0.47%08/25/21 02/25/21 2,000,000 2,000,000 100.00 2,000,000 147 0.47%
East West Bank CD 0.26%09/09/21 12/09/20 4,072,454 4,072,454 100.00 4,072,454 162 0.26%
East West Bank CD 0.21%10/08/21 01/08/21 5,002,388 5,002,388 100.00 5,002,388 191 0.21%
Prosperity Bank CD 0.30%10/14/21 10/14/20 2,503,100 2,503,100 100.00 2,503,100 197 0.30%
Independent Bank CD 0.40%10/18/21 10/18/20 2,549,159 2,549,159 100.00 2,549,159 201 0.40%
Prosperity Bank CD 0.30%11/22/21 11/20/20 3,002,957 3,002,957 100.00 3,002,957 236 0.30%
Texas Regional Bank CD 0.25%12/07/21 03/12/21 3,000,000 3,000,000 100.00 3,000,000 251 0.25%
East West Bank CD 0.21%12/30/21 12/30/20 3,001,588 3,001,588 100.00 3,001,588 274 0.21%
East West Bank CD 0.21%01/07/22 01/08/21 5,002,388 5,002,388 100.00 5,002,388 282 0.21%
Prosperity Bank CD 0.30%01/21/22 10/21/20 4,004,960 4,004,960 100.00 4,004,960 296 0.30%
Independent Bank CD 0.40%02/05/22 02/05/21 3,000,000 3,000,000 100.00 3,000,000 311 0.40%
Independent Bank CD 0.40%02/08/22 02/08/21 5,000,000 5,000,000 100.00 5,000,000 314 0.40%
R Bank CD 0.63%02/25/22 02/25/21 2,000,000 2,000,000 100.00 2,000,000 331 0.63%
Prosperity Bank CD 0.35%04/21/22 10/21/20 2,503,617 2,503,617 100.00 2,503,617 386 0.35%
Independent Bank CD 0.35%05/09/22 02/08/21 4,000,000 4,000,000 100.00 4,000,000 404 0.35%
March 31, 2021
City of Georgetown Valley View Consulting, L.L.C.24Page 39 of 140
City - Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
March 31, 2021
Prosperity Bank CD 0.35%05/17/22 11/17/20 2,002,300 2,002,300 100.00 2,002,300 412 0.35%
Prosperity Bank CD 0.35%08/22/22 11/20/20 2,502,875 2,502,875 100.00 2,502,875 509 0.35%
Prosperity Bank CD 0.40%11/17/22 11/17/20 2,002,629 2,002,629 100.00 2,002,629 596 0.40%
TOTALS 276,385,252$ 276,385,252$ 276,385,252$ 74 0.21%
(1)(2)
(2)Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not
considered. The yield for the reporting month is used for bank accounts, pools, and money market funds.
(1)Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity.
(3)Earnings Credit - The City's depository accounts provide an earnings credit on balances which is used to offset bank fees.
City of Georgetown Valley View Consulting, L.L.C.25Page 40 of 140
0–6 Months
82%
6–12 Months
14%
12–18 Months
4%
Current Quarter Maturities
$0
$25,000,000
$50,000,000
$75,000,000
$100,000,000
$125,000,000
$150,000,000
$175,000,000
$200,000,000
$225,000,000
$250,000,000
$275,000,000
$300,000,000
06/30/20 09/30/20 12/31/2020 03/31/21
Portfolio Balances
Money Market
Local Depository
TexSTAR
TexPool
Certificate of Deposit
US Treasury
166174166
102
69
90
73 75
109104
123
156163
97108
87
51
67
49 41
91
73
61 54
99
71
124
95100
80
70 67 63 58
81 82 74
0
50
100
150
200
#
o
f
D
a
y
s
Weighted Average to Maturity
JPMorgan
Chase
6%Southside
Bank
2%
Prosperity Bank
15%
Veritex Bank
1%
Bank OZK
6%
NexBank
3%
TexPool
21%
TexSTAR
31%
Independent
Bank
7%
Texas Regional
Bank
1%
East West Bank
6%
R Bank
1%
Portfolio Holdings by Issuer
City of Georgetown Valley View Consulting, L.L.C.
26Page 41 of 140
City - Book & Market Value Comparison
Issuer/Description Yield Maturity
Date
Book Value
12/31/20 Increases Decreases Book Value
03/31/21
Market Value
12/31/20
Change in
Market Value
Market Value
03/31/21
JPMorgan Chase Cash 0.22%04/01/21 15,461,481$ 88,554$ –$ 15,550,035$ 15,461,481$ 88,554$ 15,550,035$
JPMorgan Chase MMA 0.03%04/01/21 434,016 32 – 434,048 434,016 32 434,048
Veritex Bank MMA 0.10%04/01/21 3,212,254 1,000 – 3,213,253 3,212,254 1,000 3,213,253
NexBank MMA 0.45%04/01/21 7,364,008 8,174 – 7,372,182 7,364,008 8,174 7,372,182
Origin Bank MMA 0.00%04/01/21 1,014,148 – (1,014,148) - 1,014,148 (1,014,148) -
TexPool 0.02%04/01/21 44,199,066 14,663,376 – 58,862,442 44,199,066 14,663,376 58,862,442
TexSTAR 0.02%04/01/21 64,620,967 20,611,904 – 85,232,871 64,620,967 20,611,904 85,232,871
East West Bank CD 1.72%01/08/21 3,050,882 – (3,050,882) – 3,050,882 (3,050,882) –
Independent Bank CD 1.71%02/05/21 3,139,621 – (3,139,621) – 3,139,621 (3,139,621) –
Independent Bank CD 0.60%02/08/21 11,033,296 – (11,033,296) – 11,033,296 (11,033,296) –
East West Bank CD 0.32%02/18/21 9,010,737 – (9,010,737) – 9,010,737 (9,010,737) –
East West Bank CD 0.32%02/18/21 2,002,386 – (2,002,386) – 2,002,386 (2,002,386) –
R Bank CD 1.83%02/19/21 4,054,719 – (4,054,719) – 4,054,719 (4,054,719) –
Bank OZK CD 1.73%02/26/21 6,086,273 – (6,086,273) – 6,086,273 (6,086,273) –
Southside Bank CD 0.21%03/11/21 5,002,618 – (5,002,618) – 5,002,618 (5,002,618) –
Bank OZK CD 0.25%03/11/21 1,500,935 – (1,500,935) – 1,500,935 (1,500,935) –
East West Bank CD 0.29%03/15/21 3,503,032 – (3,503,032) – 3,503,032 (3,503,032) –
Prosperity Bank CD 0.45%04/01/21 4,006,098 – –4,006,098 4,006,098 – 4,006,098
Independent Bank CD 1.81%04/22/21 4,174,339 18,899 – 4,193,238 4,174,339 18,899 4,193,238
Bank OZK CD 0.70%05/10/21 12,049,407 20,839 – 12,070,246 12,049,407 20,839 12,070,246
Southside Bank CD 0.22%06/11/21 5,002,742 2,714 – 5,005,456 5,002,742 2,714 5,005,456
Bank OZK CD 0.30%06/11/21 5,003,741 3,702 – 5,007,443 5,003,741 3,702 5,007,443
Prosperity Bank CD 0.60%07/01/21 4,006,033 6,042 – 4,012,075 4,006,033 6,042 4,012,075
Prosperity Bank CD 0.70%07/15/21 5,008,798 8,817 – 5,017,615 5,008,798 8,817 5,017,615
Prosperity Bank CD 0.15%08/10/21 – 3,000,345 – 3,000,345 – 3,000,345 3,000,345
Prosperity Bank CD 0.40%08/23/21 6,251,322 6,166 – 6,257,488 6,251,322 6,166 6,257,488
R Bank CD 0.47%08/25/21 – 2,000,000 – 2,000,000 – 2,000,000 2,000,000
East West Bank CD 0.26%09/09/21 4,069,844 2,610 – 4,072,454 4,069,844 2,610 4,072,454
East West Bank CD 0.21%10/08/21 – 5,002,388 – 5,002,388 – 5,002,388 5,002,388
Prosperity Bank CD 0.30%10/14/21 2,501,250 1,850 – 2,503,100 2,501,250 1,850 2,503,100
Independent Bank CD 0.40%10/18/21 2,546,598 2,561 – 2,549,159 2,546,598 2,561 2,549,159
Prosperity Bank CD 0.30%11/22/21 3,000,738 2,219 – 3,002,957 3,000,738 2,219 3,002,957
Texas Regional Bank CD 0.25%12/07/21 – 3,000,000 – 3,000,000 – 3,000,000 3,000,000
East West Bank CD 0.21%12/30/21 3,000,035 1,554 – 3,001,588 3,000,035 1,554 3,001,588
East West Bank CD 0.21%01/07/22 – 5,002,388 – 5,002,388 – 5,002,388 5,002,388
Prosperity Bank CD 0.30%01/21/22 4,002,000 2,960 – 4,004,960 4,002,000 2,960 4,004,960
Independent Bank CD 0.40%02/05/22 – 3,000,000 – 3,000,000 – 3,000,000 3,000,000
Independent Bank CD 0.40%02/08/22 – 5,000,000 – 5,000,000 – 5,000,000 5,000,000
R Bank CD 0.63%02/25/22 – 2,000,000 – 2,000,000 – 2,000,000 2,000,000
City of Georgetown Valley View Consulting, L.L.C.27Page 42 of 140
City - Book & Market Value Comparison
Issuer/Description Yield Maturity
Date
Book Value
12/31/20 Increases Decreases Book Value
03/31/21
Market Value
12/31/20
Change in
Market Value
Market Value
03/31/21
Prosperity Bank CD 0.35%04/21/22 2,501,459 2,159 – 2,503,617 2,501,459 2,159 2,503,617
Independent Bank CD 0.35%05/09/22 – 4,000,000 – 4,000,000 – 4,000,000 4,000,000
Prosperity Bank CD 0.35%05/17/22 2,000,574 1,726 – 2,002,300 2,000,574 1,726 2,002,300
Prosperity Bank CD 0.35%08/22/22 2,500,717 2,158 – 2,502,875 2,500,717 2,158 2,502,875
Prosperity Bank CD 0.40%11/17/22 2,000,656 1,973 – 2,002,629 2,000,656 1,973 2,002,629
TOTAL / AVERAGE 0.21%258,316,790$ 67,467,110$ (49,398,649)$ 276,385,252$ 258,316,790$ 18,068,462$ 276,385,252$
City of Georgetown Valley View Consulting, L.L.C.28Page 43 of 140
City - Allocation
Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
JPMorgan Chase Cash 15,550,035$ 15,550,035$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,048 434,048 – – – – –
Veritex Bank MMA 3,213,253 3,213,253 – – – – –
NexBank MMA 7,372,182 7,372,182 – – – – –
TexPool 58,862,442 58,862,442 – – – – –
TexSTAR 85,232,871 20,153,413 584,286 17,544,854 137,307 93,010 2,508,839
Prosperity Bank CD 04/01/21 4,006,098 4,006,098 – – – – –
Independent Bank CD 04/22/21 4,193,238 4,193,238 – – – – –
Bank OZK CD 05/10/21 12,070,246 10,058,538 – – – – –
Southside Bank CD 06/11/21 5,005,456 5,005,456 – – – – –
Bank OZK CD 06/11/21 5,007,443 5,007,443 – – – – –
Prosperity Bank CD 07/01/21 4,012,075 4,012,075 – – – – –
Prosperity Bank CD 07/15/21 5,017,615 5,017,615 – – – – –
Prosperity Bank CD 08/10/21 3,000,345 – – – – – –
Prosperity Bank CD 08/23/21 6,257,488 6,257,488 – – – – –
R Bank CD 08/25/21 2,000,000 – – – – – –
East West Bank CD 09/09/21 4,072,454 4,072,454 – – – – –
East West Bank CD 10/08/21 5,002,388 5,002,388 – – – – –
Prosperity Bank CD 10/14/21 2,503,100 2,503,100 – – – – –
Independent Bank CD 10/18/21 2,549,159 2,549,159 – – – – –
Prosperity Bank CD 11/22/21 3,002,957 3,002,957 – – – – –
Texas Regional Bank CD 12/07/21 3,000,000 – – – – – –
East West Bank CD 12/30/21 3,001,588 3,001,588 – – – – –
East West Bank CD 01/07/22 5,002,388 5,002,388 – – – – –
Prosperity Bank CD 01/21/22 4,004,960 4,004,960 – – – – –
Independent Bank CD 02/05/22 3,000,000 3,000,000 – – – – –
Independent Bank CD 02/08/22 5,000,000 4,000,000 – – – – –
R Bank CD 02/25/22 2,000,000 – – – – – –
Prosperity Bank CD 04/21/22 2,503,617 2,503,617 – – – – –
Independent Bank CD 05/17/22 4,000,000 4,000,000 – – – – –
Prosperity Bank CD 05/17/22 2,002,300 2,002,300 – – – – –
Prosperity Bank CD 08/22/22 2,502,875 2,502,875 – – – – –
Prosperity Bank CD 11/17/22 2,002,629 2,002,629 – – – – –
Totals 276,385,252$ 198,293,742$ 584,286$ 17,544,854$ 137,307$ 93,010$ 2,508,839$
Book Value
March 31, 2021
City of Georgetown Valley View Consulting, L.L.C.29Page 44 of 140
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
Book Value
March 31, 2021
(Continued)
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 Revenue
Electric
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,841 68,606 1,429,234 1,420,244 246,565 178,450 97,383
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,841$ 68,606$ 1,429,234$ 1,420,244$ 246,565$ 178,450$ 97,383$
City of Georgetown Valley View Consulting, L.L.C.30Page 45 of 140
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
Book Value
March 31, 2021
(Continued)
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,746,916 56,700 672,317 445,286 6,628,059 4,686,290 87,973
– – – – – – –
– – – – – – –
2,011,708 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,000,345 – – – – – –
– – – – – – –
– – – – – 2,000,000 –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
11,758,969$ 56,700$ 672,317$ 445,286$ 6,628,059$ 6,686,290$ 87,973$
City of Georgetown Valley View Consulting, L.L.C.31Page 46 of 140
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
Book Value
March 31, 2021
(Continued)
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,247,736 1,910,744 650,627 8,547,474 486,572 6,675,600 4,396,545
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,247,736$ 1,910,744$ 650,627$ 8,547,474$ 486,572$ 6,675,600$ 4,396,545$
City of Georgetown Valley View Consulting, L.L.C.32Page 47 of 140
City - Allocation
March 31, 2021
Market Value Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
JPMorgan Chase Cash 15,550,035$ 15,550,035$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,048 434,048 – – – – –
Veritex Bank MMA 3,213,253 3,213,253 – – – – –
NexBank MMA 7,372,182 7,372,182 – – – – –
TexPool 58,862,442 58,862,442 – – – – –
TexSTAR 85,232,871 20,153,413 584,286 17,544,854 137,307 93,010 2,508,839
Prosperity Bank CD 04/01/21 4,006,098 4,006,098 – – – – –
Independent Bank CD 04/22/21 4,193,238 4,193,238 – – – – –
Bank OZK CD 05/10/21 12,070,246 10,058,538 – – – – –
Southside Bank CD 06/11/21 5,005,456 5,005,456 – – – – –
Bank OZK CD 06/11/21 5,007,443 5,007,443 – – – – –
Prosperity Bank CD 07/01/21 4,012,075 4,012,075 – – – – –
Prosperity Bank CD 07/15/21 5,017,615 5,017,615 – – – – –
Prosperity Bank CD 08/10/21 3,000,345 – – – – – –
Prosperity Bank CD 08/23/21 6,257,488 6,257,488 – – – – –
R Bank CD 08/25/21 2,000,000 – – – – – –
East West Bank CD 09/09/21 4,072,454 4,072,454 – – – – –
East West Bank CD 10/08/21 5,002,388 5,002,388 – – – – –
Prosperity Bank CD 10/14/21 2,503,100 2,503,100 – – – – –
Independent Bank CD 10/18/21 2,549,159 2,549,159 – – – – –
Prosperity Bank CD 11/22/21 3,002,957 3,002,957 – – – – –
Texas Regional Bank CD 12/07/21 3,000,000 – – – – – –
East West Bank CD 12/30/21 3,001,588 3,001,588 – – – – –
East West Bank CD 01/07/22 5,002,388 5,002,388 – – – – –
Prosperity Bank CD 01/21/22 4,004,960 4,004,960 – – – – –
Independent Bank CD 02/05/22 3,000,000 3,000,000 – – – – –
Independent Bank CD 02/08/22 5,000,000 4,000,000 – – – – –
R Bank CD 02/25/22 2,000,000 – – – – – –
Prosperity Bank CD 04/21/22 2,503,617 2,503,617 – – – – –
Independent Bank CD 05/17/22 4,000,000 4,000,000 – – – – –
Prosperity Bank CD 05/17/22 2,002,300 2,002,300 – – – – –
Prosperity Bank CD 08/22/22 2,502,875 2,502,875 – – – – –
Prosperity Bank CD 11/17/22 2,002,629 2,002,629 – – – – –
Totals 276,385,252$ 198,293,742$ 584,286$ 17,544,854$ 137,307$ 93,010$ 2,508,839$
City of Georgetown Valley View Consulting, L.L.C.33Page 48 of 140
City - Allocation
March 31, 2021
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 Revenue
Electric
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,841 68,606 1,429,234 1,420,244 246,565 178,450 97,383
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,841$ 68,606$ 1,429,234$ 1,420,244$ 246,565$ 178,450$ 97,383$
City of Georgetown Valley View Consulting, L.L.C.34Page 49 of 140
City - Allocation
March 31, 2021
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,746,916 56,700 672,317 445,286 6,628,059 4,686,290 87,973
– – – – – – –
– – – – – – –
2,011,708 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,000,345 – – – – – –
– – – – – – –
– – – – – 2,000,000 –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
11,758,969$ 56,700$ 672,317$ 445,286$ 6,628,059$ 6,686,290$ 87,973$
City of Georgetown Valley View Consulting, L.L.C.35Page 50 of 140
City - Allocation
March 31, 2021
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,247,736 1,910,744 650,627 8,547,474 486,572 6,675,600 4,396,545
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,247,736$ 1,910,744$ 650,627$ 8,547,474$ 486,572$ 6,675,600$ 4,396,545$
City of Georgetown Valley View Consulting, L.L.C.36Page 51 of 140
City - Allocation
Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
JPMorgan Chase Cash 15,461,481$ 15,461,481$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,016 434,016 – – – – –
Veritex Bank MMA 3,212,254 3,212,254 – – – – –
NexBank MMA 7,364,008 7,364,008 – – – – –
Origin Bank MMA 1,014,148 – – – – – –
TexPool 44,199,066 44,199,066 – – – – –
TexSTAR 64,620,967 8,950,006 584,231 3,875,899 137,294 93,001 2,508,604
East West Bank CD 01/08/21 3,050,882 3,050,882 – – – – –
Independent Bank CD 02/05/21 3,139,621 3,139,621 – – – – –
Independent Bank CD 02/08/21 11,033,296 8,024,216 – – – – –
East West Bank CD 02/18/21 9,010,737 3,003,579 – – – – –
East West Bank CD 02/18/21 2,002,386 – – – – – –
R Bank CD 02/19/21 4,054,719 4,054,719 – – – – –
Bank OZK CD 02/26/21 6,086,273 6,086,273 – – – – –
Southside Bank CD 03/11/21 5,002,618 5,002,618 – – – – –
Bank OZK CD 03/11/21 1,500,935 1,500,935 – – – – –
East West Bank CD 03/15/21 3,503,032 3,503,032 – – – – –
Prosperity Bank CD 04/01/21 4,006,098 4,006,098 – – – – –
Independent Bank CD 04/22/21 4,174,339 4,174,339 – – – – –
Bank OZK CD 05/10/21 12,049,407 10,041,172 – – – – –
Southside Bank CD 06/11/21 5,002,742 5,002,742 – – – – –
Bank OZK CD 06/11/21 5,003,741 5,003,741 – – – – –
Prosperity Bank CD 07/01/21 4,006,033 4,006,033 – – – – –
Prosperity Bank CD 07/15/21 5,008,798 5,008,798 – – – – –
Prosperity Bank CD 08/23/21 6,251,322 6,251,322 – – – – –
East West Bank CD 09/09/21 4,069,844 4,069,844 – – – – –
Prosperity Bank CD 10/14/21 2,501,250 2,501,250 – – – – –
Independent Bank CD 10/18/21 2,546,598 2,546,598 – – – – –
Prosperity Bank CD 11/22/21 3,000,738 3,000,738 – – – – –
East West Bank CD 12/30/21 3,000,035 3,000,035 – – – – –
Prosperity Bank CD 01/21/22 4,002,000 4,002,000 – – – – –
Prosperity Bank CD 04/21/22 2,501,459 2,501,459 – – – – –
Prosperity Bank CD 05/17/22 2,000,574 2,000,574 – – – – –
Prosperity Bank CD 08/22/22 2,500,717 2,500,717 – – – – –
Prosperity Bank CD 11/17/22 2,000,656 2,000,656 – – – – –
Totals 258,316,790$ 188,604,822$ 584,231$ 3,875,899$ 137,294$ 93,001$ 2,508,604$
December 31, 2020
Book Value
City of Georgetown Valley View Consulting, L.L.C.37Page 52 of 140
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/23/21
East West Bank CD 09/09/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
East West Bank CD 12/30/21
Prosperity Bank CD 01/21/22
Prosperity Bank CD 04/21/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
December 31, 2020
Book Value
(Continued)
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 Revenue
Electric
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698 68,600 1,429,101 1,456,708 254,936 178,433 97,374
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698$ 68,600$ 1,429,101$ 1,456,708$ 254,936$ 178,433$ 97,374$
City of Georgetown Valley View Consulting, L.L.C.38Page 53 of 140
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/23/21
East West Bank CD 09/09/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
East West Bank CD 12/30/21
Prosperity Bank CD 01/21/22
Prosperity Bank CD 04/21/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
December 31, 2020
Book Value
(Continued)
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
1,014,148 – – – – – –
– – – – – – –
3,241,881 56,694 672,254 482,661 9,137,064 3,936,963 113,952
– – – – – – –
– – – – – – –
3,009,081 – – – – – –
3,003,579 – – – – 3,003,579 –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,008,234 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
12,276,924$ 56,694$ 672,254$ 482,661$ 9,137,064$ 6,940,543$ 113,952$
City of Georgetown Valley View Consulting, L.L.C.39Page 54 of 140
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/23/21
East West Bank CD 09/09/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
East West Bank CD 12/30/21
Prosperity Bank CD 01/21/22
Prosperity Bank CD 04/21/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
December 31, 2020
Book Value
(Continued)
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,961,455 2,602,887 650,566 8,708,689 1,241,086 7,169,062 3,479,865
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,002,386 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,963,841$ 2,602,887$ 650,566$ 8,708,689$ 1,241,086$ 7,169,062$ 3,479,865$
City of Georgetown Valley View Consulting, L.L.C.40Page 55 of 140
City - Allocation
December 31, 2020
Market Value Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
JPMorgan Chase Cash 15,461,481$ 15,461,481$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,016 434,016 – – – – –
Veritex Bank MMA 3,212,254 3,212,254 – – – – –
NexBank MMA 7,364,008 7,364,008 – – – – –
Origin Bank MMA 1,014,148 – – – – – –
TexPool 44,199,066 44,199,066 – – – – –
TexSTAR 64,620,967 8,950,006 584,231 3,875,899 137,294 93,001 2,508,604
East West Bank CD 01/08/21 3,050,882 3,050,882 – – – – –
Independent Bank CD 02/05/21 3,139,621 3,139,621 – – – – –
Independent Bank CD 02/08/21 11,033,296 8,024,216 – – – – –
East West Bank CD 02/18/21 9,010,737 3,003,579 – – – – –
East West Bank CD 02/18/21 2,002,386 – – – – – –
R Bank CD 02/19/21 4,054,719 4,054,719 – – – – –
Bank OZK CD 02/26/21 6,086,273 6,086,273 – – – – –
Southside Bank CD 03/11/21 5,002,618 5,002,618 – – – – –
Bank OZK CD 03/11/21 1,500,935 1,500,935 – – – – –
East West Bank CD 03/15/21 3,503,032 3,503,032 – – – – –
Prosperity Bank CD 04/01/21 4,006,098 4,006,098 – – – – –
Independent Bank CD 04/22/21 4,174,339 4,174,339 – – – – –
Bank OZK CD 05/10/21 12,049,407 10,041,172 – – – – –
Southside Bank CD 06/11/21 5,002,742 5,002,742 – – – – –
Bank OZK CD 06/11/21 5,003,741 5,003,741 – – – – –
Prosperity Bank CD 07/01/21 4,006,033 4,006,033 – – – – –
Prosperity Bank CD 07/15/21 5,008,798 5,008,798 – – – – –
Prosperity Bank CD 08/23/21 6,251,322 6,251,322 – – – – –
East West Bank CD 09/09/21 4,069,844 4,069,844 – – – – –
Prosperity Bank CD 10/14/21 2,501,250 2,501,250 – – – – –
Independent Bank CD 10/18/21 2,546,598 2,546,598 – – – – –
Prosperity Bank CD 11/22/21 3,000,738 3,000,738 – – – – –
East West Bank CD 12/30/21 3,000,035 3,000,035 – – – – –
Prosperity Bank CD 01/21/22 4,002,000 4,002,000 – – – – –
Prosperity Bank CD 04/21/22 2,501,459 2,501,459 – – – – –
Prosperity Bank CD 05/17/22 2,000,574 2,000,574 – – – – –
Prosperity Bank CD 08/22/22 2,500,717 2,500,717 – – – – –
Prosperity Bank CD 11/17/22 2,000,656 2,000,656 – – – – –
Totals 258,316,790$ 188,604,822$ 584,231$ 3,875,899$ 137,294$ 93,001$ 2,508,604$
City of Georgetown Valley View Consulting, L.L.C.41Page 56 of 140
City - Allocation
December 31, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/23/21
East West Bank CD 09/09/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
East West Bank CD 12/30/21
Prosperity Bank CD 01/21/22
Prosperity Bank CD 04/21/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 Revenue
Electric
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698 68,600 1,429,101 1,456,708 254,936 178,433 97,374
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698$ 68,600$ 1,429,101$ 1,456,708$ 254,936$ 178,433$ 97,374$
City of Georgetown Valley View Consulting, L.L.C.42Page 57 of 140
City - Allocation
December 31, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/23/21
East West Bank CD 09/09/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
East West Bank CD 12/30/21
Prosperity Bank CD 01/21/22
Prosperity Bank CD 04/21/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
1,014,148 – – – – – –
– – – – – – –
3,241,881 56,694 672,254 482,661 9,137,064 3,936,963 113,952
– – – – – – –
– – – – – – –
3,009,081 – – – – – –
3,003,579 – – – – 3,003,579 –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,008,234 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
12,276,924$ 56,694$ 672,254$ 482,661$ 9,137,064$ 6,940,543$ 113,952$
City of Georgetown Valley View Consulting, L.L.C.43Page 58 of 140
City - Allocation
December 31, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/23/21
East West Bank CD 09/09/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
East West Bank CD 12/30/21
Prosperity Bank CD 01/21/22
Prosperity Bank CD 04/21/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,961,455 2,602,887 650,566 8,708,689 1,241,086 7,169,062 3,479,865
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,002,386 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,963,841$ 2,602,887$ 650,566$ 8,708,689$ 1,241,086$ 7,169,062$ 3,479,865$
City of Georgetown Valley View Consulting, L.L.C.44Page 59 of 140
________________________________________________________________________
Leigh Wallace Nathan Parras
Finance Director Assistant Finance Director
________________________________________________________________________
Karrie Pursley Elaine Wilson
Treasurer Assistant Finance Director
Georgetown Economic Development Corporation (GEDCO)
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
March 31, 2021
Prepared by
Valley View Consulting, L.L.C.
The investment portfolio of the Georgetown Economic Development Corporation (GEDCO) is in compliance with
the Texas Public Funds Investment Act and the Investment Policy and Strategies.
Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or
completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from
sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective of
current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total return
yields and do not account for investment advisor fees.
45Page 60 of 140
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
MMA 2,129,948$ 2,129,948$ 2,130,611$ 2,130,611$ 0.10%
Pools 6,006,030 6,006,030 6,964,887 6,964,887 0.03%
Certificates of Deposit 2,025,562 2,025,562 2,000,000 2,000,000 0.24%
10,161,540$ 10,161,540$ 11,095,498$ 11,095,498$ 0.08%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.08%Total Portfolio 0.25%
Rolling Three Month Treasury 0.06%Rolling Three Month Treasury 0.08%
Rolling Six Month Treasury 0.09%Rolling Six Month Treasury 0.10%
TexPool 0.02%TexPool 0.05%
Interest income provided in separate report.
December 31, 2020
(1)Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not
considered. The yield for the reporting month is used for bank, pool, and money market balances.
(2)Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return
analysis or account for advisory fees.
March 31, 2021
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.46Page 61 of 140
Economic Overview 3/31/2021
The Federal Open Market Committee (FOMC) maintained the Fed Funds target range at 0.00% to 0.25% (Effective Fed Funds are trading <0.10%), and projected that reduced rates could remain
into 2023 or longer. Fourth Quarter GDP finalized at +4.3%. March Non Farm Payroll added 916k and Unemployment declined to 6.0%. Crude oil traded above $60 per barrel. The Stock Markets
reached new highs. Housing, Industrial Production, Durable Goods, Consumer Spending, and other indicators showed solid gains. An additional $1.9 trillion stimulus package passed Congress and
was signed by the President. The Yield Curve continued steepening on longer maturities.
0
250
500
750
1,000
1,250
1,500
1,750
2,000
2,250
2,500
2,750
3,000
3,250
3,500
3,750
4,000
4,250
S&P 500
0.00
0.50
1.00
1.50
2.00
2.50
3.00
3.50 US Treasury Historical Yields - Since Nov 2015
Six Month T-Bill Two Year T-Note Ten Year T-Note
0.00
0.20
0.40
0.60
0.80
1.00
1.20
1.40
1.60
1.80
2.00 Treasury Yield Curves
March 31, 2020 December 31, 2020 March 31, 2021
0.00
0.50
1.00
1.50
2.00
2.50
3.00
3.50
4.00
4.50
5.00
5.50
6.00 US Treasury Historical Yields - Since 2006
Six Month T-Bill Two Year T-Note Ten Year T-Note
Valley View Consulting, L.L.C.47Page 62 of 140
Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
Veritex Bank MMA 0.10%04/01/21 03/31/21 2,130,611$ 2,130,611$ 1.00 2,130,611$ 1 0.10%
TexasDAILY AAAm 0.05%04/01/21 03/31/21 2,125,613 2,125,613 1.00 2,125,613 1 0.05%
TexSTAR AAAm 0.02%04/01/21 03/31/21 4,839,274 4,839,274 1.00 4,839,274 1 0.02%
Veritex Bank CD 0.24%08/05/22 02/08/21 2,000,000 2,000,000 100.00 2,000,000 492 0.24%
11,095,498$ 11,095,498$ 11,095,498$ 90 0.08%
(1)(2)
March 31, 2021
(1)Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity.
(2)Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees
are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds.
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.48Page 63 of 140
MMA
19%
Pools
63%
Certificates of
Deposit
18%
GEDCO PORTFOLIO COMPOSITION
$0
$2,000,000
$4,000,000
$6,000,000
$8,000,000
$10,000,000
$12,000,000
06/30/20 09/30/20 12/31/20 3/31/2021
GEDCO PORTFOLIO BALANCES
CD
TexasDAILY
TexSTAR
Money Market
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.49Page 64 of 140
Book & Market Value Comparison
Issuer/Description Yield Maturity
Date
Book Value
12/31/20 Increases Decreases Book Value
03/31/21
Market Value
12/31/20
Change in
Market Value
Market Value
03/31/21
Veritex Bank MMA 0.10%04/01/21 2,129,948$ 663$ –$ 2,130,611$ 2,129,948$ 663$ 2,130,611$
TexasDAILY 0.05%04/01/21 2,125,306 306 – 2,125,613 2,125,306 306 2,125,613
TexSTAR 0.02%04/01/21 3,880,724 958,551 – 4,839,274 3,880,724 958,551 4,839,274
Independent Bank CD 1.71%02/05/21 2,025,562 – (2,025,562) – 2,025,562 (2,025,562) –
Veritex Bank CD 0.24%08/05/22 – 2,000,000 – 2,000,000 – 2,000,000 2,000,000
TOTAL / AVERAGE 0.08%10,161,540$ 2,959,520$ (2,025,562)$ 11,095,498$ 10,161,540$ 933,958$ 11,095,498$
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.50Page 65 of 140
Georgetown Transportation Enhancement Corporation (GTEC)
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
March 31, 2021
Prepared by
Valley View Consulting, L.L.C.
________________________________________________________________________
Leigh Wallace Nathan Parras
Finance Director Assistant Finance Director
________________________________________________________________________
Karrie Pursley Elaine Wilson
Treasurer
The investment portfolio of the Georgetown Transportation Enhancement Corporation (GTEC) is in compliance
with the Texas Public Funds Investment Act and the Investment Policy and Strategies.
Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or
completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from
sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective
of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total
return yields and do not account for investment advisor fees.
51Page 66 of 140
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Pools/MMAs 28,689,653$ 28,689,653$ 30,076,153$ 30,076,153$ 0.03%
CDs/Securities 3,004,002 3,004,002 3,006,965 3,006,965 0.40%
Totals 31,693,655$ 31,693,655$ 33,083,118$ 33,083,118$ 0.06%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.06%Total Portfolio 0.09%
Rolling Three Month Treasury 0.06%Rolling Three Month Treasury 0.08%
Rolling Six Month Treasury 0.09%Rolling Six Month Treasury 0.10%
TexPool 0.02%TexPool 0.05%
Interest data provided in separate report.
December 31, 2020
(1) Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not
considered. The yield for the reporting month is used for bank, pool, and money market balances.
(2) Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total
return analysis or account for advisory fees.
March 31, 2021
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.52Page 67 of 140
Economic Overview 3/31/2021
The Federal Open Market Committee (FOMC) maintained the Fed Funds target range at 0.00% to 0.25% (Effective Fed Funds are trading <0.10%), and projected that reduced rates could remain
into 2023 or longer. Fourth Quarter GDP finalized at +4.3%. March Non Farm Payroll added 916k and Unemployment declined to 6.0%. Crude oil traded above $60 per barrel. The Stock Markets
reached new highs. Housing, Industrial Production, Durable Goods, Consumer Spending, and other indicators showed solid gains. An additional $1.9 trillion stimulus package passed Congress and
was signed by the President. The Yield Curve continued steepening on longer maturities.
0
250
500
750
1,000
1,250
1,500
1,750
2,000
2,250
2,500
2,750
3,000
3,250
3,500
3,750
4,000
4,250
S&P 500
0.00
0.50
1.00
1.50
2.00
2.50
3.00
3.50 US Treasury Historical Yields - Since Nov 2015
Six Month T-Bill Two Year T-Note Ten Year T-Note
0.00
0.20
0.40
0.60
0.80
1.00
1.20
1.40
1.60
1.80
2.00 Treasury Yield Curves
March 31, 2020 December 31, 2020 March 31, 2021
0.00
0.50
1.00
1.50
2.00
2.50
3.00
3.50
4.00
4.50
5.00
5.50
6.00 US Treasury Historical Yields - Since 2006
Six Month T-Bill Two Year T-Note Ten Year T-Note
Valley View Consulting, L.L.C.53Page 68 of 140
Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
TexPool AAAm 0.02%04/01/21 03/31/21 15,639,313$ 15,639,313$ 1.00 15,639,313$ 1 0.02%
TexSTAR AAAm 0.02%04/01/21 03/31/21 11,748,398 11,748,398 1.00 11,748,398 1 0.02%
Veritex Bank MMA 0.10%04/01/21 03/31/21 2,688,441 2,688,441 1.00 2,688,441 1 0.10%
Prosperity Bank CD 0.40%08/23/21 08/21/20 3,006,965 3,006,965 100.00 3,006,965 145 0.40%
TOTALS 33,083,118$ 33,083,118$ 33,083,118$ 14 0.06%
(1)(2)
March 31, 2021
(1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity.
(2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not
considered. The yield for the reporting month is used for bank accounts, pools, and money market funds.
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.54Page 69 of 140
Pools/MMAs
91%
CDs/Securities
9%
GTEC PORTFOLIO COMPOSITION
$0
$5,000,000
$10,000,000
$15,000,000
$20,000,000
$25,000,000
$30,000,000
$35,000,000
6/30/2021 9/30/2021 12/31/2021 3/31/2021
GTEC PORTFOLIO BALANCES
CD
TexPool
TexSTAR
Money Market
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.55Page 70 of 140
Book & Market Value Comparison
Issuer/Description Yield Maturity
Date
Book Value
12/31/20 Increases Decreases Book Value
03/31/21
Market Value
12/31/20
Change in
Market Value
Market Value
03/31/21
TexPool 0.02%04/01/21 13,146,323$ 2,492,991$ –$ 15,639,313$ 13,146,323$ 2,492,991$ 15,639,313$
TexSTAR 0.02%04/01/21 12,855,726 – (1,107,328) 11,748,398 12,855,726 (1,107,328) 11,748,398
Veritex Bank MMA 0.10%04/01/21 2,687,605 837 – 2,688,441 2,687,605 837 2,688,441
Prosperity Bank CD 0.40%08/23/21 3,004,002 2,963 – 3,006,965 3,004,002 2,963 3,006,965
TOTAL / AVERAGE 0.06%31,693,655$ 2,496,790$ (1,107,328)$ 33,083,118$ 31,693,655$ 1,389,462$ 33,083,118$
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.56Page 71 of 140
Department Federal Grantor Pass-Through Agency Identifying Number COG Name/Purpose YTD Expenditures YTD Revenue Recognized
Airport N/A Texas Department of
Transportation-Aviation
M1914GEOR RAMP Grant - Routine Airport
Maintenance Program
1,119.55
Airport FEMA Texas Department of
Transportation - Aviation
Airport CARES Funding 156,980.34 156,980.34
Emergency Management FEMA Williamson County WILCO Forward - CARES
Funding for COVID-19
14,814.52 14,814.52
Fire Department of Health & Human Services CMS (Centers for Medicare &
Medicaid Services)
EMS CARES Round 1 - -
Fire US Department of Homeland Security Federal Emergency
Management Agency
EMW-2017-FH-00496 SAFER 543,247.52 372,220.59
Library National Endowment for the Arts National Endowment for the
Arts
COVID Relief Funding 9,014.11 -
Library Texas Commission on the Arts Touring Artist Fund Grant 4,200.00
Planning US Department of Housing & Urban Development Williamson County CDBG Home Repair 43,059.77 40,920.32
Police US. Department of Justice N/A TX2460200 Equitable Sharing Agreement 5,176.77 -
Police US. Department of Treasury N/A TX2460200 Equitable Sharing Agreement 20,346.75 -
Public Works Dept. of Transportation /Federal Highway
Administration
Texas Department of
Transportation
CSJ-0914-05-187 Highway Planning &
Construction (Austin Ave
Bridge)
2,776.55 -
Public Works Dept. of Transportation /Federal Highway
Administration
Texas Department of
Transportation
CSJ-0914-05-200,201,202 Highway Planning &
Construction (Williams Dr
Corridor)
- -
Reviewed By: Elaine Wilson
CITY OF GEORGETOWN
Grant/Federal Funding Report
as of March 31, 2021
Active
57Page 72 of 140
Capital Improvement Projects Life to Tade Budget vs Spend
Row Labels Total Budget Total Spend Remaining Budget Percent Remaining
Airport
Airport - Self Managed
PRJ000197 Hangar Mainenance 240,000 - 240,000 100%
PRJ000198 Pavement Maintenance 60,000 - 60,000 100%
PRJ000199 Wildlife Management 150,000 - 150,000 100%
Airport - Self Managed Total 450,000 - 450,000 300%
Management Services
PRJ000184 Airport Maintenance Facility 750,000 - 750,000 100%
Management Services Total 750,000 - 750,000 100%
Airport Total 1,200,000 - 1,200,000 400%
CDBG
CDBG
PRJ000003 17th Street 193,000 175,137 17,863 9%
PRJ000144 Maple Street (Inactive)80,784 - 80,784 100%
CDBG Total 273,784 175,137 98,647 109%
CDBG Total 273,784 175,137 98,647 109%
Downtown TIRZ
Parks
PRJ000050 Grace Heritage Plaza 139,100 45,900 93,200 67%
Parks Total 139,100 45,900 93,200 67%
Downtown TIRZ Total 139,100 45,900 93,200 67%
Electric
Electric
PRJ000022 Consultant Engineering 271,352 71,352 200,000 74%
PRJ000026 Db Wood_Sh29 Intersection 240,000 172,024 67,976 28%
PRJ000036 Electrical System Improvement 100,000 57 99,943 100%
PRJ000040 Fiber Optic 50,000 19,516 30,484 61%
PRJ000062 New Development Projects 5,019,335 5,334,015 (314,680) -6%
PRJ000073 Power Quality Improvements 50,000 - 50,000 100%
PRJ000095 Shell Road Feeders 160,000 181,824 (21,824) -14%
PRJ000147 Sectionalization Improvements 100,000 - 100,000 100%
PRJ000175 I-35 Mobility Project TxDot 200,000 183,627 16,373 8%
PRJ000189 Ronald Reagan - Glasscock Feeder Extension along Hwy 195 -Phase I 560,000 39,310 520,690 93%
PRJ000192 Ronald Reagan - Glasscock Feeder extension along Hwy 195 - Phase II 591,250 133,847 457,403 77%
PRJ000195 Downtown Overhead Rehab 2,400,000 - 2,400,000 100%
PRJ000221 Titan-Aviation Dr to IH35 Infrastructure Addition 1,000,000 67,349 932,651 93%
PRJ000225 Chapel Hill, WS-11139 (GEO-45-C.3)437,577 345,842 91,735 21%
PRJ000226 Wolf Ranch West - Section 1AG & 1BG 479,052 33,405 445,647 93%
PRJ000227 Ascend Westinghouse Apartments 444,598 29,165 415,432 93%
PRJ000229 Sun City NH 76 WS-11188 (GEO-18.2-N.51)274,030 103,520 170,510 62%
PRJ000230 Sun City NH 78 296,400 111,101 185,299 63%
PRJ000231 Georgetown Titan Development 1 & 2 140,428 - 140,428 100%
PRJ000232 Texas Outdoor Power Building 1 91,414 - 91,414 100%
PRJ000234 Summit at Westinghouse Self-Storage 49,685 - 49,685 100%
58Page 73 of 140
Row Labels Total Budget Total Spend Remaining Budget Percent Remaining
PRJ000236 Medcore (Georgetown) Senior Living 226,972 20,134 206,837 91%
PRJ000238 The Oscar at Georgetown 366,351 - 366,351 100%
PRJ000239 Wolf Ranch West - Section 3 - Phase 2 418,339 - 418,339 100%
Electric Total 13,966,782 6,846,089 7,120,693 1738%
Electric Total 13,966,782 6,846,089 7,120,693 1738%
GCP
Environmental Services
PRJ000116 Transfer Station 11,000,000 947,801 10,052,199 91%
Environmental Services Total 11,000,000 947,801 10,052,199 91%
Finance
PRJ000038 ERP Project 6,231,654 5,898,066 333,588 5%
Finance Total 6,231,654 5,898,066 333,588 5%
Fire
PRJ000134 SCBA Replacement 870,000 - 870,000 100%
PRJ000135 Cardiac Monitors 483,517 483,517 - 0%
Fire Total 1,353,517 483,517 870,000 100%
Fleet
PRJ000124 Radio Replacement 363,278 - 363,278 100%
Fleet Total 363,278 - 363,278 100%
GTEC Department
PRJ000203 FM1460 Widening 948,982 48,982 900,000 95%
PRJ000206 NB Front Rd (2338 To Lakeway)216,000 221,766 (5,766) -3%
GTEC Department Total 1,164,982 270,748 894,234 92%
Management Services
PRJ000028 Downtown Parking Expansion 728,510 701,947 26,564 4%
PRJ000029 Downtown Parking Garage 411,815 411,815 - 0%
PRJ000033 Dtwn Landsping & Public Art 90,000 56,706 33,294 37%
PRJ000037 EOC Siren System 15,525 15,525 - 0%
PRJ000042 Fire Station 6 5,500,000 5,330,405 169,595 3%
PRJ000043 Fire Station 7 8,550,000 6,457,667 2,092,333 24%
PRJ000067 Parking Improvements 68,510 - 68,510 100%
PRJ000131 Fuel Station 1,100,000 - 1,100,000 100%
PRJ000136 GMC Remodel Phase I 250,000 30,614 219,386 88%
PRJ000178 Public Safety Operation and Training Center Phase II 4,500,000 - 4,500,000 100%
PRJ000179 Recreation Center Teen/Senior Renovation 200,000 - 200,000 100%
PRJ000180 Recreation Center Natatorium HVAC Replacement 700,000 656,176 43,824 6%
PRJ000191 Georgetown City Center - Festival/Public Space 5,400,000 14,099 5,385,901 100%
PRJ000223 City Center Signage 125,000 - 125,000 100%
Management Services Total 27,639,360 13,674,954 13,964,406 762%
59Page 74 of 140
Row Labels Total Budget Total Spend Remaining Budget Percent Remaining
Parks
PRJ000048 Garey Park 15,346,730 15,100,250 246,480 2%
PRJ000089 San Gabriel Park Improvement 13,025,000 7,448,252 5,576,748 43%
PRJ000125 Parks Master Plan 229,998 229,998 - 0%
PRJ000126 Regional Trail Development 1,550,000 138,100 1,411,900 91%
PRJ000127 Neighborhood Park Development 1,250,000 240,541 1,009,459 81%
PRJ000129 Ada Transition Plan 1,075,982 276,682 799,300 74%
PRJ000130 Tennis Center Pool Demo 40,002 39,076 926 2%
PRJ000190 Heritage Gardens 274,934 81,400 193,534 70%
PRJ000205 Katy Crossing Trail 700,000 500,181 199,819 29%
Parks Total 33,492,646 24,054,481 9,438,165 392%
Police
PRJ000133 Body Cameras 800,000 737,412 62,588 8%
Police Total 800,000 737,412 62,588 8%
Public Works - Self Managed Department
PRJ000204 Historic District Street Signs 26,000 - 26,000 100%
Public Works - Self Managed Department Total 26,000 - 26,000 100%
Public Works Department
PRJ000013 Austin Avenue Bridge 2,855,398 1,711,629 1,143,769 40%
PRJ000137 Intersection Improvements (Lakeway @ Williams Drive) 1,400,000 252,450 1,147,550 82%
PRJ000138 Downtown Sidewalks 2,000,000 470,719 1,529,281 76%
PRJ000139 Westinghouse - Scenic Lake Traffic Signal 600,000 87,028 512,972 85%
PRJ000141 Southwestern Blvd 4,200,000 866,960 3,333,040 79%
PRJ000143 Leander Rd(Norwood-Swbypass)6,750,000 994,025 5,755,975 85%
PRJ000171 Shell Rd Sidewalk 229,825 203,755 26,070 11%
PRJ000188 DB Wood (SH 29 to Oak Ridge)4,000,000 1,703,636 2,296,364 57%
PRJ000201 Austin Ave. (Sh29-Fm2243)466,000 466,000 - 0%
PRJ000202 FM 971 4,853,000 1,113,617 3,739,383 77%
PRJ000207 Northwest Blvd Bridge 11,254,320 11,372,616 (118,296) -1%
PRJ000208 Old Town Northeast 1,050,000 923,818 126,182 12%
PRJ000209 Southeast Inner Loop 10,521,000 8,884,343 1,636,657 16%
PRJ000214 Intersection Improvements (Traffic Signals)1,650,000 159,863 1,490,137 90%
PRJ000215 2021 Intersection Safety Enhancements (RRFB)150,000 96,450 53,550 36%
PRJ000216 FY21 Downtown Sidewalk Improvements 1,000,000 130,000 870,000 87%
PRJ000217 SW Bypass - Wolf Ranch Extension 1,000,000 633,943 366,057 37%
Public Works Department Total 53,979,543 30,070,852 23,908,691 871%
Right of Way
PRJ000200 Access Rtw To Government Srv 220,000 220,000 - 0%
Right of Way Total 220,000 220,000 - 0%
GCP Total 136,270,980 76,357,831 59,913,149 2521%
60Page 75 of 140
Row Labels Total Budget Total Spend Remaining Budget Percent Remaining
General Fund Projects
Parks
PRJ000055 Katy Crossing Trail 700,000 17,780 682,220 97%
Parks Total 700,000 17,780 682,220 97%
Public Works Department
PRJ000012 Austin Ave. (Sh29-Fm2243) (Inactive) 466,000 - 466,000 100%
Public Works Department Total 466,000 - 466,000 100%
Right of Way
PRJ000007 Access Rtw To Government Srv 220,000 - 220,000 100%
Right of Way Total 220,000 - 220,000 100%
General Fund Projects Total 1,386,000 17,780 1,368,220 297%
GTEC
GTEC Department
PRJ000046 FM 971/ Fontana (Nw Bridge) 1,209,000 1,193,000 16,000 1%
PRJ000053 IH 35/ Hwy 29 Intersection Imp 1,800,000 120,066 1,679,934 93%
PRJ000060 Rabbit Hill Road 4,100,000 179,757 3,920,243 96%
PRJ000083 Rivery Tia Improvements 1,179,000 1,110,970 68,030 6%
PRJ000092 Se Inner Loop Widening (Inactive) 8,148,000 - 8,148,000 100%
PRJ000145 Sh29 Signal And Roadway Improvements 1,595,000 312,671 1,282,329 80%
PRJ000146 Wolf Ranch Parkway Extension (Inactive) 1,100,000 - 1,100,000 100%
PRJ000181 Aviation Drive 10,300,000 275,868 10,024,132 97%
PRJ000182 Confido III 600,000 - 600,000 100%
PRJ000183 Big C Project 2,000,000 - 2,000,000 100%
GTEC Department Total 32,031,000 3,192,332 28,838,668 774%
GTEC Total 32,031,000 3,192,332 28,838,668 774%
Stormwater
Stormwater
PRJ000004 18th and Hutto Drainage 50,000 6,356 43,644 87%
PRJ000005 2nd and Rock Pond 625,000 447,151 177,849 28%
PRJ000024 2020 Curb & Gutter 1,055,000 337,047 717,953 68%
PRJ000104 Stormwater Infrastructure 347,000 168,506 178,495 51%
PRJ000148 Water Quality Ponds 98,000 - 98,000 100%
PRJ000149 Drainage Improvement/Flood Mitigation Projects 300,000 - 300,000 100%
PRJ000213 2021 Curb & Gutter Project 500,000 53,100 446,900 89%
Stormwater Total 2,975,000 1,012,160 1,962,840 525%
Stormwater Total 2,975,000 1,012,160 1,962,840 525%
61Page 76 of 140
Row Labels Total Budget Total Spend Remaining Budget Percent Remaining
Street Tax
Public Works Department
PRJ000172 2020 Street Maintenance High Performance Seal: Bid Package No.1 372,200 372,200 - 0%
PRJ000173 2020 Street Maintenance High Performance Seal: Bid Package No. 2 463,195 482,214 (19,020) -4%
PRJ000174 2020 street maintenance HIPR 1,935,589 1,441,013 494,576 26%
PRJ000210 2021 HIPR Street Maintenance 2,300,000 274,700 2,025,300 88%
PRJ000211 2021 High Performance Pavement Seal Project #1 600,000 94,900 505,100 84%
PRJ000212 2021 High Performance Pavement Seal Project #2 600,000 90,700 509,300 85%
PRJ000237 Northeast Inner Loop (Stadium to FM971) Emergency Repairs 700,000 695,456 4,544 1%
Public Works Department Total 6,970,983 3,451,183 3,519,800 279%
Street Tax Total 6,970,983 3,451,183 3,519,800 279%
Transportation
GTEC Department
PRJ000047 FM1460 Widening (Inactive)794,000 - 794,000 100%
PRJ000061 NB Front Rd (2338 To Lakeway) (Inactive)366,000 - 366,000 100%
GTEC Department Total 1,160,000 - 1,160,000 200%
Public Works Department
PRJ000045 FM 971 2,000 (26,684) 28,684 1434%
PRJ000063 Northwest Blvd Bridge 21,743,000 421,578 21,321,422 98%
PRJ000065 Old Town Northeast (Inactive)855,021 (19,064) 874,085 102%
PRJ000100 Southeast Inner Loop 3,321,000 - 3,321,000 100%
Public Works Department Total 25,921,021 375,830 25,545,190 1734%
Transportation Total 27,081,021 375,830 26,705,190 1934%
62Page 77 of 140
Row Labels Total Budget Total Spend Remaining Budget Percent Remaining
Water
Water
PRJ000014 Berry Creek Inter.49,949,000 701,486 49,247,514 99%
PRJ000016 Braun Est 4,750,000 1,202,760 3,547,240 75%
PRJ000017 Cedar Breaks Est 3,385,000 236,730 3,148,270 93%
PRJ000023 Cr 255 (Wd14-2)1,493,963 323,841 1,170,122 78%
PRJ000025 Db Wood/ Pastor 24 Dedicated 5,286,000 423,726 4,862,274 92%
PRJ000027 Domel PS Improvements (Inactive) 5,816,000 - 5,816,000 100%
PRJ000034 Earz 2,326,000 469,283 1,856,717 80%
PRJ000057 Lift Station Upgrade 1,173,593 - 1,173,593 100%
PRJ000059 LWTP Raw Water Intake Rehab 6,750,000 5,506,976 1,243,024 18%
PRJ000066 Park Lift Station & Force Main 3,574,341 2,115,836 1,458,505 41%
PRJ000069 Pecan Branch Ph 2 253,000 232,521 20,479 8%
PRJ000075 Pumps & Storage 1,009,289 9,289 1,000,000 99%
PRJ000076 Rabbit Hill Est 1,826,000 873,294 952,706 52%
PRJ000085 Ronald Reagan/Daniels Mountain 4,400,000 167,638 4,232,362 96%
PRJ000087 S. Lake Wtp 2018 (Inactive) 6,950,000 - 6,950,000 100%
PRJ000088 San Gabriel Belt Press and Rehab 3,200,000 2,580,279 619,721 19%
PRJ000096 Shell Road Water Line 6,890,000 992,205 5,897,795 86%
PRJ000101 Southlake Wtp 100,000,000 8,590,093 91,409,907 91%
PRJ000103 Stonehedge Ls & Fm (Inactive) 150,000 - 150,000 100%
PRJ000108 Sun City Elevated Storage Tank (Inactive) 3,224,000 - 3,224,000 100%
PRJ000110 Sw Bypass Waterline (Inactive) 1,106,000 - 1,106,000 100%
PRJ000119 Water Mains 1,537,000 433,498 1,103,502 72%
PRJ000121 Westinghouse Ls & Fm (Inactive) 3,299,000 - 3,299,000 100%
PRJ000122 Westside Facility (Inactive)505,500 - 505,500 100%
PRJ000123 WW Interceptors 608,431 - 608,431 100%
PRJ000150 Carriage Oaks Transmission 500,000 - 500,000 100%
PRJ000151 FY2020 CR262 Waterline 500,000 - 500,000 100%
PRJ000152 Hoover Pump Station 6,850,000 855,221 5,994,779 88%
PRJ000153 FY2020 Round Rock Supply Line (Inactive)300,000 17,345 282,655 94%
PRJ000154 FY2020 Stonewall Ranch Ps Improvements 500,000 - 500,000 100%
PRJ000155 Southside Water Treatment Plant 2,250,000 21,840 2,228,160 99%
PRJ000156 Gatlin/Teravista Improvements 450,000 - 450,000 100%
PRJ000157 Leander Interconnect 515,000 49,495 465,505 90%
PRJ000158 West loop (H-1A)2,119,000 447,385 1,671,615 79%
PRJ000160 Round Rock Supply Pump Station And Elevated Storage Tank 10,500,000 1,427,473 9,072,527 86%
PRJ000161 Miscellaneous Line Upgrades 872,000 655,875 216,125 25%
PRJ000162 South West Bypass Water (H24-1) 2,906,000 2,301,498 604,502 21%
PRJ000163 Tank Rehabilitation 2,905,000 445,994 2,459,006 85%
PRJ000164 Council Chamber Water 423,000 15,960 407,040 96%
PRJ000165 San Gabriel Wwtp Rehab 2,500,000 98,000 2,402,000 96%
PRJ000167 San Gabriel Inter SGI -2 4,500,000 912,755 3,587,245 80%
PRJ000168 WWTP Upgrade 950,000 - 950,000 100%
PRJ000177 Northlake WTP Phase IV Expansion 15,000,000 11,859,923 3,140,077 21%
PRJ000185 Cimarron Hills Wastewater Treatment Plant Expansion 800,000 - 800,000 100%
PRJ000218 EARZ Wastewater Rehabilitation Area 2 - 2019 2,460,360 2,460,360 - 0%
PRJ000219 Southside GST Foundation Improvements 535,678 - 535,678 100%
PRJ000228 Southside GST Roof Rehab 567,000 - 567,000 100%
Water Total 278,365,155 46,428,578 231,936,576 3759%
Water Operations
PRJ000220 AMI Western District Improvements 750,000 - 750,000 100%
Water Operations Total 750,000 - 750,000 100%
Water Total 279,115,155 46,428,578 232,686,576 3859%
Grand Total 501,409,805 137,902,820 363,506,985 12504%
63Page 78 of 140
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21
Cemetery Special Revenue
Fund
Currently cemetery operations are self‐funded through
plot sales of approximately $50K per year. The cemetery is
managed through Parks Administration. In 2015, Council
elected to reserve $75,000 annually for future costs
associated with maintaining the property. The General
Fund has made this transfer in since FY 2016.
The general fund transfer for FY2021 was reduced to
$35,000. No change.
Unfunded Actuarial Accrued
Liability (UAAL)
Recognizes the outstanding liability for the City’s
employee retirement plan through TMRS. The City
contributes monthly to fund the UAAL, based on an annual
percentage of payroll. Actual % of payroll costs is
recognized within each fund. The UAAL is provided by
TMRS and lags one year.
As of 9/30/2020, the net pension liability is $18.7
million and is 88.97% funded. This decrease in liability
is due to a change in the actuarial assumptions.
No change.
Other Post Employee Benefits
(OPEB)
While the City has no obligation to offer additional retiree
benefits, retirees are eligible to participate in the City’s
health insurance program. That ability represents a
subsidy that impacts health insurance costs to the City.
Retirees pay their monthly premiums to the self insurance
fund, which then processes their health insurance claims.
OPEB liability as of 9/30/2020 is $2.7 million. This is a
combination of sudden death benefits as well as post‐
retirement healthcare.
No change.
Compensated Absence
Future costs associated with benefits such as vacation, and
sick leave for City employees. Compensated Absence is
accrued annually to each proprietary fund type on a GAAP
basis and accounted for on the balance sheet of each fund.
For governmental funds (and for budgetary basis), the
expense is recognized when due and payable. The City
keeps a reserve in the General Fund to help offset large
payouts for long‐term employees. The reserve is used as
needed, and annually replenished or increased based on
known risk.
Compensated absences as of 9/30/2020 are $8.2
million. More time was earned than used during
FY2020 as many plans were changed related to the
pandemic. The City did not extend any vacation cap
carry overs in general. As with any year, specific
requests for carryover are considered and approved
by the City Manager.
No change.
CITY OF GEORGETOWN
Long-term Commitments, Reservations, and Other Unfunded Liabilities
3/31/2021
64Page 79 of 140
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21
Electric Fund Rate
Stabilization Reserve
Intended to mitigate potential rate impacts due to
increased purchased power costs or other external factors.
The RSR is maintained within the Electric Fund.
During the FY2021 CIP Roll Forward and Other
Operating Amendments approved by Council, the PCA
revenue was lowered by $5 million. Budgeted ending
fund balance covers $4M in 90 day contingency
reserve, $10.6M in non‐operating or rate stabilization
reserve, and $3.4M in restricted proceeds from the
transformer sale.
During the February Winter Storm Uri, the Electric
Fund incurred an additional $48 million in energy
market costs. The City issued a debt instrument that
will be paid from current PCA rates. There are no
expected changes to Electric reserves.
Airport Maintenance
Fund on‐going maintenance of the Airport grounds,
runways and taxi ways. Terminal and Tower included in
Facilities ISF. An Airport Master Plan was developed to
address long term capital maintenance project
prioritization.
CARES Act purchases will be changed to airport Utility
charges FY 20 & FY21, along with other maintenance
charges from FY21. We are still reviewing Land Lease
buildings that will be reverting back to Airport
Ownership within the next 5 years. These reversions
will impact the budget bottom line as we will have to
do some maintenance on the buildings. These
charges will be off‐set by the increased revenue from
the increased Facility Lease Rates.
Continued maintenance on buildings and pavement
surfaces. We will have to do pavement sealing on
Taxiway A to prevent early deterioration. This will
include a seal coat and repainting of all markings. We
have prepared all documentation and supporting
evidence for CRRSA (the 2nd relief grant) for
reimbursement. We are waiting on TxDOT to
establish the process. This will be ~$57K. The relief
grant has yet to be established by the FAA. We expect
to get another award for that as well.
Americans with Disabilities
Act (ADA) Compliance Needs
As facilities are built or repurposed, meeting ADA
compliance will be included in Project Costs. Funding for
program expansion will be needed (General Fund sources).
The City has an adopted policy, as required by Federal
Law, that it will make reasonable accommodations and
modifications to ensure that people with disabilities have
an equal opportunity to enjoy its programs, services, and
activities. The City does not maintain a reserve for these
modifications.
FY2021 budget and debt sale includes $150,000 for
the ADA plan.
A competitive sealed bid has been completed for
ADA repairs along the South San Gabriel River
Trail. The contract is in Legal for review.
Sidewalk Maintenance &
Masterplan
Currently, new sidewalks are built as development occurs.
Repairs are funded as needed or if funding is available,
when major roads are repaired. Useful life of a sidewalk is
estimated at 40 to 50 years. The largest revenue source
comes from the City’s General Fund, but there has been
some debt funding as well.
In design is the Rock Sidewalk/FY20 Downtown ADA
Sidewalk Improvements. This project will construct
new and rehab/replace non‐ADA compliant sidewalks
and pedestrian ramps. Currently reviewing 95% plans.
Advertising and Bidding to start end of January 2021.
The Council is considering a mobility bond for May
2021 that would include additional debt capacity for
sidewalk projects.
Rock Sidewalk/FY 20 Downtown ADA Sidewalk
Improvements. Project is awarded to Choice Builders.
Construction to begin in May 2021. FY21 Downtown
ADA Sidewalk improvements will be a continuation of
Downtown ADA improvements and closing gaps.
Design for this project will begin in May 2021. The
mobility bond passed in the May election, providing
new funding over the next 7 years for sidewalks.
65Page 80 of 140
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21
Park Equipment Maintenance
& Replacement
Over the past 5 years, funding for Park Maintenance and
Replacement has increased. $200K transfer from General
Fund included in FY2018 budget. Staff has listed all assets
& developed replacement schedule funded by the General
Fund.
University Park and Raintree Park equipment and the
outdoor pool slides at the Recreation Center were
scheduled to be completed in FY2020. However,
these were deferred due to financial constraints
related to COVID‐19. These deferrals total $290,000.
Additionally, the general fund transfer for FY2021 was
reduced from $200,000 to $50,000. Scheduled
maintenance equipment and replacement projects for
FY2021 total $402,000 not including the FY2021
deferrals. Staff has evaluated the FY2020 deferrals
and the scheduled FY2021 replacements and
prioritized to complete projects with greatest need.
These total $293,000 and will be completed with the
$50,000 transfer and existing fund balance.
No change.
Radio Equipment
Replacement
Communication system consisting of 500 on‐body and in‐
vehicle radios for Police, Fire, parks and utilities.
Replacement radios are compatible with newer
technology. The replacement takes place over 5 years due
to cost and is funded with certificate of obligation debt.
The audit shows there are 301 radios that still need to
be replaced before September 2023. Non‐Public
Safety ‐ 39 portable radios; 72 mobile radios. Some of
those mobiles may be replaced with portables. Police ‐
71 portable radios; 82 mobile radios. 911 Comms ‐ 4
portable radios; 9 mobile radios. Fire ‐ 12 portable
radios; 12 mobile radios. The FY2021 budget and debt
sale includes $363K in funding.
Ordered 22 portable radios for Electric Dept. Ordered
9 mobiles and 4 portables for 911 Communications.
Processing 8 portable radios for Police in Workday.
Still working on the other 35 non‐public safety radios.
Street Maintenance
The City funds street maintenance in the General Fund,
supplemented by a 1/8th Street Sales Tax special revenue
fund. In 2017 and 2018, the Council and GTAB reviewed
various methods for enhanced street maintenance and
costs. Direction from Council is to use high performance
surface seals and pavement wearing courses and begin
programmatically addressing the street network's
deferred maintenance backlog, creating a need for
approximately $2 million more per year for street
maintenance.
No change. After the FY2020 audit is completed and
all available General Fund balance reviewed, there
may be dollars available to allocate to street
maintenance or other priorities.
The Council declined to appropriate any available
fund balance during an April workshop. The February
Winter Storm Uri caused damage to a section of Inner
Loop. The Street Sales Tax Fund will cover the
approximately $700K for repairs. The road is not
eligible for FEMA reimbursement.
Fiber Asset Allocation
Network fiber infrastructure is installed across the City.
Traditionally, the Electric Fund has installed and
maintained the network. In reviewing all costs for the
Electric Fund, the City has begun moving the fiber asset to
the IT Fund. Staff must develop a multi‐year strategy to
complete the asset transfer and allocate costs for
maintenance.
Fiber staff will be moved into IT at beginning of FY 21.
Also in FY 2021, Fiber costs will be allocated across
departments according to the IT allocation process.
The second installment to acquire the asset will be
paid in FY2020, and there is a plan to assume
additional installments over the next 4 years. The IT
Fund will need to increase cost recovery rates to
complete the acquisition.
IT has drafted a cost recovery plan for fiber and it is
being evaluated as part of the FY2022 budget
development process.
66Page 81 of 140
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21
IT Capital Replacement
Reserve
The purpose of this reserve is to fund the maintenance
and replacement of computer network and other
technology systems. A reserve will be established within
the ISF for replacement of major systems and will be
funded over time through excess revenues within the
Fund. The targeted amount is the average (1/5th) of the
next five years on the replacement schedule.
During the FY2021 budget adoption process, the IT
capital replacement reserve was drawn down in order
to purchase a portion of the fiber asset from the
Electric utility. In FY2022, IT Allocation revenues will
need to increase citywide to recover the fund balance
and continue with the remaining fiber asset purchase.
IT has drafted a cost recovery plan for fiber and it is
being evaluated as part of the FY2022 budget
development process.
Facilities Maintenance
Reserve
The City has established an on‐going maintenance
program, which includes major repairs, equipment, as well
as contracts for maintaining City facilities. The City has
anticipated a useful life of such equipment and established
a means of charging those costs to the various
departments in order to recognize the City’s continuing
costs of maintaining its facilities. Determination for facility
repairs is based on useful life of the various elements of
each facility. A proportional cost for each element is
expensed within the budget for capital replacement. The
targeted replacement reserve amount is the average
(1/5th) of the next five years on the replacement schedule.
During the FY2021 budget adoption process, the
Facilities cost allocation revenue was not increased.
This provided some economic relief throughout major
funds due to COVID economic uncertainty. Therefore,
no incremental progress was made to fund this
reserve. In FY2022 or future years, rates will need to
increase to fund this reserve.
Facilities has drafted a cost recovery plan for fund
balance reserves and it is being evaluated as part of
the FY2022 budget development process.
Public Safety Equipment
Recurring Line Item Budgets
As part of the City’s on‐going maintenance program, the
City also recognizes the need to regularly maintain and
replace specialized equipment in Police and Fire. Separate
replacement and maintenance schedules will be
maintained for these items including but not limited to for
Fire: SCBA’s and other firefighting equipment and
protective gear; and for Police: bullet proof vests,
armaments and other tactical equipment. The City’s goal
is to provide level on‐going funding to ensure proper
protection for employees and residents. The current
funding level is an annual appropriation in the General
Fund of $80,000 for Fire and $88,000 for Police.
Due to the economic impacts of the pandemic,
reductions were made to General Fund base budgets
in FY2021, including public safety equipment. There is
no anticipated impact to employee safety. The funds
will need to be restored in FY2022, or as soon as
practical.
No change.
Joint Services Fund 90 Day
Operational Contingency
Reserve
A minimum ninety (90) days of operating expenses will be
reserved for unexpected delays in revenue or emergency
expenses.
Due to the economic impact of the pandemic, the City
is not increasing recovery rates to build this reserve. It
is estimated to take approximately 3 years to build the
reserve to 90 days. The FY2021 budget provide
funding to hire a consultant to review and
recommend updates to the City's joint services cost
allocation model.
Council declined to appropriate any available fund
balance at mid‐year to achieve this goal. The Cost
Allocation Model study was put on hold due to
activities needed to recover from the Winter Storm.
67Page 82 of 140
Georgetown Electric Advisory
Board
06/17/21
City of GeorgetownPage 83 of 140
AGENDA
I.Regular Session:
(* -indicates legislative action)
A.Call to Order
B.Roll Call
C.Introduction of Visitors
D.Public Wishing to Address the Board
E.Review and Approval of Minutes*
F.General Manager’s Monthly Report
II.Executive Session:
G. Purchased Power Update
Page 84 of 140
Regular Session
A.Call to Order
B.Roll Call
C.Introduction of Visitors
D.Public Wishing to Address the Board
E.Review and Approval of Minutes*
F.General Manager’s Monthly Report
Page 85 of 140
Review of Minutes
•May 20th 2021 Minutes
City of GeorgetownPage 86 of 140
General Manager’s Monthly Report
City of GeorgetownPage 87 of 140
Customer Service and Billing –
Electric Services
Leticia Zavala-Customer Care Director
Page 88 of 140
•All Available Services
Apr May
Residential 26,596 26,621
Residential –Security Lights*95
Net Metering 495 505
General -Small 2,552 2,535
General -Large 330 333
General –Security Lights*127
Industrial 21 21
Industrial -Large 1 1
School Services 28 24
Municipal*249
Municipal -Pumping 39 42
Municipal –Security Lights*6
Total Services Count 30,062 30,559
*Added 477 service points to report (not previously shown on slide):
➢New Service Connections (MOM)20
➢New Service Connections (F-YTD) 593
Customer Statistics
Page 89 of 140
•Breakdown by Electric Customers (unique) :
Apr May
Residential 25,950 25,987
Builder 762 793
Commercial & Industrial 2,309 2,316
Municipal/Schools 290 290
Total Electric Customers:29,311 29,386
•Electric Billing Collection:
•Advanced Metering Infrastructure (AMI): 99.7%
–Usage data automatically transmitted to billing office
•Automated Meter Reading (AMR): .3%
–Usage data is collected via a drive by system
•# of Customer Estimations: 13
•Account did not get a “good” READ; or
•Account did not get “ANY” READ (work order put in for metering to
investigate)
Customer Statistics
Page 90 of 140
•Average Monthly Electric Bill May 2021 May 2020
•All Customers $ 86.91 $82.79
•Average YTD Electric Bill FY2021 FY2020
•All Customers $ 90.73 $ 101.97
•Residential Customer -FY2021 FY2020
•Cost per 1000 kWh $134.35 $144.35
(including PCA + Base)
•Average kWh 618 738
•Average Bill + tax $ 84.69 $ 108.66
–PCA reduced Jan1st to $0.01375 (from $0.02375)
Customer Billing Statistics
Page 91 of 140
Electric Revenue
•YTD Revenue by Service Period –Billings thru 5/31
•1st QTR Revenue Comparison –(Oct/Nov/Dec)
•2nd QTR Revenue Comparison –(Jan/Feb/Mar)
•3rd QTR Revenue Comparison –(Apr/May/Jun)
2020 Actual 2021 Actual % of Actual
$18,061,625 $17,830,945 99%
2021 Budget 2021 Year to date Actual % of Budget
$78,982,278*44,970,378 57%
*Lowered budget by $5M due to PCA reduction on 1/1/21
2020 Actual 2021 Actual % of Actual
$19,640,581 $19,447,737 99%
2020 Actual 2021 Actual % of Actual
$21,686,623 $7,691,695 35%
Page 92 of 140
Aged Receivables Report –thru 5/31/21
Electric AR –Active & Inactive Accounts
Electric AR –Combined Aging Breakdown
Electric Prior Month Variance
31 –60 Days $106,174.97 $83,581.60 $22,593.37
61 –90 Days $50,585.88 $40,821.50 $9,764.38
91 –120 Days $34,517.39 $50,270.74 ($15,753.35)
120 –365 Days $451,862.98 $500,769.01 ($48,906.03)
> 365 Days $968,816.46 $911,469.86 $57,346.60
Total $1,611,957.68 $1,586,912.71 $25,044.97
Customer Count 3992 3924 68
Electric Prior Month Variance
Active Accounts $215,489.77 $256,618.81 ($41,129.04)
Inactive Accounts $1,396,467.91 $1,330,293.90 $66,174.01
Total $1,611,957.68 $1,586,912.71 $25,044.97
Page 93 of 140
Finance and Budgeting
Leigh Wallace –Finance Director
Page 94 of 140
Second Quarter Background
•Budget in this report reflects the CIP Roll Forward and
Operational Amendments from January
•Due to COVID-19 pandemic timing, year over year
comparisons of 2020 and 2021 show large variances in
some revenues and expenses, which was expected
going into FY2021
•Report reflects operational impacts of the winter storm in
expenses
–Mid-year budget amendment will be posted to third quarter
–City will apply for FEMA reimbursement
Page 95 of 140
Electric Fund Revenue
•FY2021 Revenue
Budget
•Revenue Budget
Sources
–The FY2021 revenue
budget for the Electric Fund
is $93.1 million
–89% of budgeted revenues
is from charges for service
•Electric sales revenue
•Shared services charges
–Bond Proceeds are 7.14%
of budgeted revenues
–Transfer In –1.5%
•Titan North Park
88.99%
7.14%
1.61%1.48%
0.78%
Charges for Services
Bond Proceeds
Developer Contributions
70001:Transfers In
Other Miscellaneous Revenue
Page 96 of 140
Electric Fund Revenue –by
Quarter
Budget
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%
Quarterly Comparison
COG - Electric Services Financial Report
Period: Q2 FY21
Page 97 of 140
Electric Fund Revenue –
Budget to Actual
Budget
FY2021
YTD Actuals:
Q2 FY21 YTD Variance % of Budget
Operating Revenue
Taxes 120,732 2,389 (118,343) 1.98%
Fines and Penalties 553,724 415,395 (138,329) 75.02%
Investment Income 5,000 20,765 15,765 415.30%
Charges for Services 82,889,381 39,004,137 (43,885,244) 47.06%
Developer Contributions 1,500,000 3,266,695 1,766,695 217.78%
70001:Transfers In 1,379,308 1,379,308 - 100.00%
Operating Revenue Total 86,448,145 44,088,688 (42,359,457) 51.00%
Non-Operating Revenue
Other Miscellaneous Revenue 45,000 969,245 924,245 2153.88%
Bond Proceeds 6,648,625 - (6,648,625) 0.00%
Non-Operating Revenue Total 6,693,625 969,245 (5,724,380) 14.48%
COG - Electric Services Financial Report
Period: Q2 FY21
Quarterly Comparison
Page 98 of 140
Electric Fund Operating
Revenue
•Electric Sales Revenue
–Represents 91.4% of
budgeted Electric Fund
operating revenue
–$36.87 million, or 46.68%
of electric sales revenue
budget received through
the quarter
–Electric sales revenue is
down 2.21% compared to
the same period of
FY2020
•Rate agreements and
adjustments
-2.21% 36,867,522
ELECTRIC CHARGES
K
5.0M
10.0M
15.0M
20.0M
Q1 Q2
FY2020 FY2021
Page 99 of 140
Electric Expense –by Quarter
Budget
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 Services 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 Management 60,334,393 26,809,590 86,341,401 (59,531,812) 222.05%
CC0555 Electric Systems Operations 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%
Quarterly Comparison
COG - Electric Services Financial Report
Period: Q2 FY21
Page 100 of 140
Electric Fund Expense –Budget
to Actual
COG - Electric Services Fund Financial Report
Period Q2 FY21
Budget
FY2021
YTD Actuals
w/Encumbrances:
Q2 FY21 YTD Variance % of Budget
Expense
Personnel 4,797,866 3,445,094 1,352,772 71.80%
Operations 72,378,333 92,263,380 (19,885,047) 127.47%
Operating Capital 2,155 188,654 (186,499) 8752.27%
Transfers 5,256,375 3,166,496 2,089,879 60.24%
Expense 82,434,729 99,063,624 16,628,895 83.21%
Non-Operating Expense
CIP Expense 8,166,143 2,569,283 5,596,860 31.46%
Debt Service 4,152,805 614,762 3,538,043 14.80%
Non-Operating Expense Total 12,318,948 3,184,045 9,134,903 25.85%
Quarterly Comparison
Page 101 of 140
Electric Fund Net Purchased
Power
•Net Purchased Power
–72% of Electric Fund
operating expenses
–$86.25 million, or 145.95%
of purchase power
expense through the
quarter
–Purchase power is up
227% compared to the
same period of FY2020
•Winter storm
•Congestion and
transmission issues (Q1)
227% 86,251,901
NET PURCHASED POWER
K
20.0M
40.0M
60.0M
80.0M
Q1 Q2
FY2020 FY2021
Page 102 of 140
Electric Fund Purchased Power
•Q2: FY2020
–Net Purchase Power Budget:
$59,500,000
–Purchased Power: $26,720,632
–REC Sales: ($382,959)
–CRR Credits: ($353,165)
–Net Purchased Power: $25,984,508
–% of Net Purchase Power Budget:
43.67%
•Q2: FY2021
•Net Purchase Power Budget:
$60,270,000
•Purchased Power: $32,398,858
•$48,000,000 expense removed to
compare quarter to quarter
•REC Sales: ($886,041)
•CRR Credits: ($246,957)
•Net Purchased Power:
$31,265,860
•% of Net Purchase Power Budget:
51.88%
Page 103 of 140
June Mid-Year Budget
Amendment
•Winter Storm personnel overtime,
operations, and purchases power related
costs
•Contribution from Water Fund to Electric
Fund for Ronald Regan electric feeder
capital project that improves reliability of
water infrastructure in the area; $180K
Page 104 of 140
ELECTRIC ENGINEERING AND
OPERATIONS
MIKE WESTBROOK
ELECTRIC OPERATIONS AND
ENGINEERING MANAGER
City of GeorgetownPage 105 of 140
Performance Metrics
City of Georgetown
May 2021
Electric / April Electric / May
Good Caution Alert
Training 98%100%>90%90%-80%<80%
Safety 100%100%>90%90%-80%<80%
SO OTC 100%100%>90%90%-80%<80%
PM WO OTC 100%100%>90%90%-80%<80%
CM WO OTC 100%100%>90%90%-80%<80%
Electric Reliability (SAIFI)0.526 0.57 <1 1-2 >2
Electric Outage Duration (CAIDI)92.732 88.816 <116 116-200 >200
Page 106 of 140
Top Five Outages & Event
City of Georgetown
Date Start Time Duration (min)Customers
Affected
Customer
Minutes Cause Area
5/1/2021 12:58 AM 117 8 936
Tree/Limb/Blown
Fuse Serenada
5/1/2021 12:58 AM 147 3 441
Tree/Limb/Blown
Fuse Serenada
5/3/2021 11:14 AM 40 12 480
Hot Leg on Trans
damaged Serenada
5/18/2021 5:15pm 74 3 222
Lightning / Blown
Fuse Serenada
5/23/2021 9:05 AM 263 1 263 Bad OH Service Airport
Date Start of Event End of Event # of Outages Average
Duration Cause Area
5/28/2021 7:06pm 9:58pm 9 72
Lightning / Blown
Fuse Various
Page 107 of 140
Electric Business Plan
2021
Page 108 of 140
Electric Utility Organization
Page 109 of 140
Service Area Mission
To Provide Safe and Reliable Electric Service at
Competitive Rates by Fostering an Environment Where
Employee Safety and Development, Customer Satisfaction,
System Reliability, and Financial Performance are
Paramount.“
Page 110 of 140
Utility Strategy
Maintain
Excellent Safety
Record
Develop and
Maintain
Work Force
Achieve High
Level of
Reliability
Excellent
Financial
Performance
Page 111 of 140
Key Performance Indicators
Maintain Excellent
Safety Record
Average of meeting attendance and
supervisory field visits
Near misses and OSHA incident
tracking
Maintain RP3 and APPA Certification
Develop and Maintain
Workforce
Apprentice Lineman Training
Program
Technical and Continuous Training
Operation Technology Training and
Refreshers
Page 112 of 140
Key Performance Indicators
(cont.)
Achieve High Level
of Reliability
SAIFI
CAIDI
Meet yearly goals for system
maintenance and upgrade
programs
Robust system improvement
and upgrade programs
Excellent Financial
Performance
Rate Competitiveness
Meeting Budgets
Meeting and Maintaining
Financial Ratios
Page 113 of 140
SWOT ANALYSIS
Strengths
•Safety
•Maintenance Program
•Reliable System
•Skilled Employees
Weaknesses
•Communication
•Internal business processes
•Labor market competition
Opportunities
•In house critical engineering
functions
•Improvements and
Investments into OT
•New processes; culture
change
•Growth
Threats
•Employee Retention
•Retail Rate Pressure
•Growth
•Lack of Diversification in
Portfoliio
Page 114 of 140
Strategic Goals and Initiatives
SG1: Software Upgrades and Implementation
•ANB System
•Partner Software Implementation
SG2: Employee Training and Development
•Lineman Apprentice Program and Upgrade
•Ongoing Employee Training
•Employee Safety and Training Group
Page 115 of 140
Strategic Goals and Initiatives
(cont.)
SG3: Fleet/ Equipment Improvements and
Replacements
•Contracting with Fleet and Rental Companies
•Fleet Replacement and Policy Review
SG4: Operation Improvements
•Job Tracking and Management
•Emergency Plans Update
•Engineering Studies for Projects
•Warehouse Outsourcing
•Creation of Operation Technology
Page 116 of 140
Strategic Goals and Initiatives
(cont.)
SG 5: Energy Risk Management
Updates
•Implement Risk Management Policies
•Alternate Load Structures
•Procure Energy Portfolio Support and
Management Services
Page 117 of 140
Page 118 of 140
Capital Improvement Projects
(CIP)
Page 119 of 140
Capital Improvement Projects
System Improvements
•Capacity
•Power Quality
•Sectionalization/Coordinating
•Protection/Distribution
Automation
New Development
Customer Growth
•Single Family
•Multi Family
•Commercial
•Industrial
Page 120 of 140
New Development Projects
Customer Growth Driven Projects include:
•Single Family Residential including Detached Multi-family and Duplexes
•Residential Multi-Family Development (Apartments)
•Commercial
•Industrial
Page 121 of 140
Single Family Development Projects
•Sun City Additions
•Sun City RV Tract Amenity Center/Sun City NH 10
•Wolf Ranch (various phases)
Page 122 of 140
Multi –Family Development Projects
•WindMill Hill Multi-Family
•Mays Street Multi-Family
•Ascend Westinghouse Apartments
•Rockmoor Apartments
•Allora North Georgetown Apartments
•Vida Apartments
•Wolf Ranch Parkway Apartments
Page 123 of 140
Commercial Projects
•All Care Therapies
•Clarity Eye Center
•Republic Center Starbucks
•High Tech Retail Center
•Rbank SDP
•Georgetown Medical
•Wolf Lakes Village
•Kwik Chek
•Wolf Crossings
•Westinghouse Road Additions
Page 124 of 140
Industrial Projects
•Titan Development –NorthPark 35 Aviation Phase I
•Titan Development –GateWay35 Commerce Center
•Texas Outdoor Power
Gateway35Texas Outdoor Power
Page 125 of 140
Titan Development –NorthPark 35 Aviation Drive Master Plan (total estimated load of 20MW)
•NorthPark35 Building 1 is a
172,677 SF industrial project.
Potential uses for this building
include e-commerce, light
manufacturing, and
distribution.
•NorthPark35 Building 2 is a
157,300 SF industrial project.
Potential uses for this building
include e-commerce, light
manufacturing, and
distribution.
Page 126 of 140
System Improvements Needed To
Support Titan Development Projects
Description of System Improvements:
These improvements to the electric distribution infrastructure are needed
in order to handle the projected growth (as electric demand increases)
and maintain reliable and safe electric service to the customers. The
projects include upgrades to supplement Line Capacity, equipment
capacity, and substation capacity.
Page 127 of 140
Titan-Aviation Dr to IH35 Underground Addition, Redundant Feed Overhead -IH35 to East Substation
•Extend an express
feeder from FM 971 to
Titan North Park to
support the additional
large commercial load
estimated at 20 MW
along SH130 and
Airport Road.
•Back Up Power Source
–Georgetown East
Substation Feeder
Page 128 of 140
Titan Development Airport Road Upgrades
•Upgrading conductors from 1/0 to 336 AAC (4200 ft)
•Located from Lakeway Drive to Fire Station #4 (4200
Airport Road)
•Upgrade from single circuit to dual circuit to support
additional load
Airport
Road
Fire Station #4
Page 129 of 140
Gateway35 Commerce CenterPreliminary Design 83 Acres
•Located near the intersection of IH-35 and SH-130
•This two-phase project allows for a variety of build-to-
suit options depending on intended use (industrial
distribution and manufacturing).
•Building 1 is a cross-dock facility breaking ground in
May 2021 with delivery in December 2021.
•Estimated Load for Building #1 is 3000 Amps
•Additional Load is Currently Unknown
Page 130 of 140
Additional System Improvement
Projects
Page 131 of 140
Downtown Overhead Rehab
Scope:
A 5-year plan to rehab deteriorated
downtown overhead facilities. Convert
Downtown Overhead to Underground
facilities.
Page 132 of 140
Phase I:
•Located outside of the Glasscock Substation
•Glasscock Feeder Exit Vault Clean up
•Scope is installing one pull box per feeder (5)
Ronald Reagan –Glasscock Feeder Extension
Along Hwy 195 Phase I
Page 133 of 140
Ronald Reagan-Glasscock Feeder extension along HWY 195 Phase II
•Addition of double circuit feeder to existing Somerset Hill Feeder from Glasscock along Hwy 195
•Ronald Reagan Blvd to provide additional reliability to area.
•Circuit will also provide TCEQ required redundancy to future Northlands Wastewater Treatment Plant.
•Completion of the double circuit from Glasscock to
CR 245 (33,120 ft) and single circuit (4,640 ft) from
RR /CR 245 intersection to rocky hollow creek
drive.
•From rock hollow creek we need to pull
underground cable (4,640 ft) to the switchgear.
•Overhead estimated cost of $500,000 (33,120 Feet)
•Underground estimated cost of $250,000 (4,640
Feet)
Page 134 of 140
Shell Road -Esparada ReconductorShell Road express Feeders
•Right of way acquisition and construction of
two express feeders from Glasscock
Substation for circuit loading relief over a
period of 4 years starting in 2022
•Install Glasscock express feeder underground
in existing spare conduits
•1000 mcm from Glasscock Substation through
Sun City to San Saba Drive
•Installing new circuit from existing San Saba
Drive overhead line to Shell Road overhead
Line
Page 135 of 140
2022 Capital Improvement ProjectCategories & Budget
Page 136 of 140
Page 137 of 140
Ask Questions!!
Page 138 of 140
Questions?
Page 139 of 140
Executive Session:
In compliance with the Open Meetings Act, Chapter
551, Government Code, Vernon's Texas Codes,
Annotated, the item listed below will be discussed in
closed session and is subject to action in the regular
session. –Daniel Bethapudi, General Manager of the
Electric Utility
Sec. 551.086 Competitive Matters
•Purchased Power Review
Page 140 of 140