HomeMy WebLinkAbout2nd_Qtr_Report_FY2021FY2021 BUDGET
AND 5 YEAR CAPITAL IMPROVEMENT PLAN
Quarterly Report
FINANCIAL REPORT AND INVESTMENT REPORT
For the Quarter Ended March 31, 2021
Table of Contents
Executive Summary .................................................................................................................................. 1-11
General Fund Schedule ............................................................................................................................... 12
Electric Fund Schedule ................................................................................................................................ 13
Water Services Fund Schedule .................................................................................................................... 14
Joint Services Fund Schedule ....................................................................................................................... 15
Council Discretionary Fund Schedule .......................................................................................................... 16
Convention & Visitors Bureau Fund Schedule ............................................................................................. 17
Airport Fund Schedule ................................................................................................................................. 18
Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 19
Georgetown Economic Development Corporation Fund Schedule ............................................................. 20
Quarterly Investment Report - City ........................................................................................................ 21-44
Quarterly Investment Report - GEDCO ................................................................................................... 45-50
Quarterly Investment Report - GTEC ...................................................................................................... 51-56
Grant Applications ....................................................................................................................................... 57
Capital Improvement Projects ................................................................................................................ 58-63
Long-term Commitments and Other Unfunded Liabilities ..................................................................... 64-67
F FY2021 Quarterly Report
EXECUTIVE SUMMARY FOR THE QUARTER ENDED MAR. 31, 2021
I. QUARTERLY FINANCIAL ANALYSIS
Each year, the City amends the budget for multi‐year capital projects, as well as operational changes that were
unknown at the time the budget was adopted. The Second Quarter Report Approved Budget includes Capital Project
Roll Forward and Operational Amendments Approved by Council in January 2021. The February Winter Storm Uri had
a large impact on expenses for the second quarter. Council will consider amendments related to the storm during a
formal budget amendment in June 2021, which is in the third quarter. Furthermore, this report compares actuals to
budget, and compared to the performance of actuals in the same quarter in the previous year. Due to the timing of
the COVID‐19 pandemic starting in the second quarter of last year, the quarter‐to‐quarter comparisons may in some
cases stand out. However, many of these increases or decreases were expected during the 2021 budget planning
process and are generally not a concern.
GENERAL FUND REVENUES:
General Fund revenues total $48,858,157, or 59.02% of budget through this quarter of FY2021. Revenues exceed last
year’s same quarter total by $5,191,197, or 11.89%.
COG ‐ General Fund Financial Report
Period: YTD Actuals: Q2 FY21
Budget Quarterly Comparison
FY2021
YTD Actuals:
Q2 FY20
YTD Actuals:
Q2 FY21 YTD Variance % Varaince
Revenue
Taxes 41,208,025 24,251,223 26,730,147 2,478,924 10.22%
Fines and Penalties 388,392 211,780 156,400 (55,381) ‐26.15%
Investment Income 75,000 156,220 43,091 (113,128) ‐72.42%
Charges for Services 25,042,285 12,267,072 12,956,253 689,181 5.62%
Other Miscellaneous 871,955 96,158 398,441 302,283 314.36%
Donations and Grants 5,770,975 2,524,484 3,223,877 699,393 27.70%
70001:Transfers In 995,302 303,634 995,302 691,668 227.80%
70002:Transfers In ‐ ROI 8,431,375 3,856,389 4,354,647 498,258 12.92%
Revenue Total 82,783,309 43,666,959 48,858,157 5,191,197 11.89%
The difference between the same period last year is primarily driven by increases in building permits, continued
growth in sales tax, as well as one‐time master development contributions. Municipal Court fines and Interest Income
are both decreased compared to the same period last year due to the pandemic circumstances.
1
F FY2021 Quarterly Report
Sales tax revenue accounts for $18,576,250 of
budgeted revenues in the General Fund, or 22.44%.
Year‐to‐date sales tax revenue through the quarter
totals $7,431,798 million, or 40.01% of budget. Sales tax
data lags two months in arrears and while the impact of
COVID and the consumers’ shift to online retail was
difficult to quantify, sales tax continues to have a strong
performance. The second quarter returns for sales tax
were 16.79% higher compared to the same period last
year. The increase in sales tax revenue is the result of
continued growth in the City’s core sales tax sectors of
retail, food, and information, in combination with new
businesses coming online. Additionally, March of 2020
was the start of the pandemic resulting in dampened
sales taxes that period.
Property tax revenues are the second largest revenue segment in the General Fund and accounts for $15,976,505,
or 19.30% of the total revenue budget. Property tax revenue is typically received during the first two quarters of the
fiscal year, with most of the taxes collected in December and January. Through the quarter, property tax year‐to‐
date collections total 102.82% of budget, or $16,427,813. Year‐to‐date property tax revenues are 8.65% higher than
the same period last year. Year‐to‐date property tax revenue reflects Tax Increment Reinvestment Zone revenues
and will be journaled to the appropriate TIRZ funds in the 3rd quarter. After this transaction, staff expects property
tax collections to be on budget.
The City collects franchise fees for electric, natural gas, cable, and non‐cellular telephone services and represents
7.56% of budgeted revenue. Through the quarter, franchise fee revenues total $2,783,150 in FY2021, or 44.49% of
budget. Franchise fee revenue is 10.94% higher than the second quarter of FY2020.
Return on Investment (ROI) revenue from City‐owned utilities represents $8,431,375, or 10.18% of budgeted
revenues in the fund. Year‐to‐date, ROI revenues total $4,354,647, or 51.65% of budget. ROI revenue is $498,258, or
12.92% higher than the second quarter of FY2020.
Planning and Development related revenue continues to be strong in FY2021. Planning and Development revenue
total accounts for $6,499,325, or 7.85% of total General Fund budgeted revenue. Through the quarter, planning and
development related revenue totals $3,547,521 or 54.58% of budget. Development fees are up 33.68%, or $893,827
compared to the same quarter in FY2020. Staff continues to monitor the amount of residential building permits. The
following graph shows the number of residential building permits issued by quarter for the past 3 years.
276 311370
537
682 665
‐
200
400
600
800
Q1 Q2
Residential Building Permits
FY2019 FY2020 FY2021
1.5M
3.9M
1.7M
4.7M
1.8M
5.6M
K
1.5M
3.0M
4.5M
6.0M
Q1 Q2
GENERAL FUND SALES TAX
FY2019 FY2020 FY2021
2
F FY2021 Quarterly Report
Sanitation revenue totals $10,151,764, or 12.26% of total General Fund budgeted revenue. Through the quarter
sanitation revenue totals $5,316,194, or 52.37% of budget. Sanitation rates increased as part of the FY2021 budget
to support growing customer base as well as to support the debt service for a new transfer station. The variance
between the same period last year is $268,642, or 5.32%.
Fire and EMS revenue account for $8,012,095, or 9.68% of total General Fund budgeted revenue. Through the
quarter fire and EMS fee related revenue totals $4,044,351, or 50.48% of budget. Additional Fire/EMS revenue is
comprised of the Interlocal Agreement Emergency Services District 8 contract for service, as well as public safety
grants such as the SAFER grant.
Parks and Recreation fee revenue totals $1,893,234, or 2.29% of General Fund budgeted revenue. Through the
quarter, parks and recreation related fee revenue totals $669,866, or 35.38% of budget. Parks and Recreation
revenue is ‐44.56% compared to FY2020. The decrease in revenue is primarily driven by programming reductions
due to COVID 19. There are related decreases in Recreation expenses.
GENERAL FUND EXPENSES:
Annual expenses through the quarter total $38,181,440, or 46.70% of budget. This is a 4.5% decrease compared to
the same period last year. The decrease reflects the effort of the City to be fiscally conservative when planning FY2021
budget. Staff held on various positions, cut programming costs, and decreased travel budget because of the
anticipated impact of COVID.
COG ‐ General Fund Financial Report
Period: YTD Actuals w/Encumbrances: Q2 FY21
Budget Quarterly Comparison
FY2021
YTD Actuals
w/Encumbrances:
Q2 FY20
YTD Actuals
w/Encumbrances:
Q2 FY21 YTD Variance % Varaince
Expense
Personnel 45,566,994 22,744,841 21,031,143 1,713,698 ‐7.53%
Operations 34,685,857 15,132,908 16,250,215 (1,117,307)7.38%
Operating Capital 295,695 1,645,267 122,912 1,522,356 ‐92.53%
CIP Expense ‐ ‐ 17,780 (17,780)0.00%
Transfers 1,353,191 457,860 759,391 (301,531)65.86%
Expense Total 81,751,737 39,980,876 38,181,440 1,799,436 ‐4.50
Personnel and Operations Summary
Personnel costs through the quarter total $21,031,143, or 46.15% of personnel budget. Operational costs total
$16,250,215, or 46.85%. The table above includes all expenditures in the General Fund. Capital costs can fluctuate
from year‐to‐year based on project, timing, and various other factors, primarily in the Streets cost center.
Many departments in the General Fund were impacted by the February winter storm. The public safety division and
public works division were impacted the most. As part of the FY2021 Mid‐Year Budget Amendment, staff is proposing
additional appropriation to cover unforeseen overtime cost and operational costs related to the storm.
3
F FY2021 Quarterly Report
Personnel and Operations Summary by Division:
Administration Services Division (Administrative Services, City Council, and City Secretary) personnel and operational
expenditures for the quarter totals $5,338,883, which represents 53.11% of budget. General Government Contracts
includes budgeted vacancy savings estimates for all General Fund departments. Real vacancy savings is realized in
FY2021 Budget
YTD Actuals
w/Encumbrances:
Q2 FY21 Variance % of Budget
Development and Community Services
Personnel 6,157,720 2,529,677 3,628,043 41.08%
Operations 13,607,117 6,070,614 7,536,503 44.61%
Development and Community Services 19,764,838 8,600,291 11,164,547 43.51%
Finance Administration
Personnel 484,734 227,360 257,374 46.90%
Operations 100,389 37,511 62,878 37.37%
Finance Administration 585,123 264,871 320,253 45.27%
Police
Personnel 12,922,164 6,226,795 6,695,369 48.19%
Operations 3,973,436 1,944,051 2,029,385 48.93%
Police Total 16,895,600 8,170,846 8,724,753 48.36%
Fire and EMS
Personnel 18,084,000 8,025,483 10,058,517 44.38%
Operations 4,682,312 2,438,752 2,243,560 52.08%
Fire and EMS Total 22,766,312 10,464,235 12,302,077 45.96%
Administrative Services
Personnel 1,316,326 1,215,495 100,831 92.34%
Operations 8,735,940 4,123,388 4,612,552 47.20%
Administrative Services Total 10,052,266 5,338,883 4,713,383 53.11%
Library, Tourism, and Culture
Personnel 1,798,754 806,651 992,103 44.84%
Operations 1,097,007 592,677 504,330 54.03%
Library, Tourism and Culture Total 2,895,761 1,399,328 1,496,433 48.32%
Parks and Recreation
Personnel 4,803,296 1,998,198 2,805,098 41.60%
Operations 4,138,542 1,930,748 2,207,794 46.65%
Parks and Recreation 8,941,838 3,946,725 4,995,112 44.14%
4
F FY2021 Quarterly Report
each cost center. The budgeted vacancy factor against year‐to‐date actuals in the administrative division cost center
drives the percent of budget up. Staff will adjust and forecast the vacancy factor as part of the FY2021 projections.
Year‐to‐date personnel and operational expenditures for the Development and Community Services (Planning,
Inspections, Community Services, Code Enforcement, Animal Services, Environmental Services, Public Works, and
Streets) total $8,600,291, or 43.51% of budget.
Finance Administration which consists of Municipal Court totals $264,871, or 45.27% percent of budget through the
quarter.
Year‐to‐date the Library, Tourism, and Culture Division (Library and Arts and Culture) totals $1,399,328. This consists
of $806,651 of personnel costs and $592,677 of operational costs. As of this quarter, the Library, Tourism, and
Culture department is at 48.32% of budget.
Year‐to‐date the Parks and Recreation Division (Parks Administrations, Parks, Garey Park, Recreation, and Recreation
Programs) totals $3,946,725. This consists of $1,998,198 of personnel costs and $1,930,748 of operational costs. As
of this quarter, the Parks and Rec department is at 44.14% of budget.
Year‐to‐date personnel and operational expenditures for Fire and EMS through the quarter total $10,464,235 or
45.96% of budget. Personnel is 44.38% through the quarter.
Year‐to‐date personnel and operational expenditures for Police through the quarter totals $8,170,846 or 48.36% of
budget.
Overall, General Fund expenditures are within budget and the fund can cover the 90‐day Contingency Reserve
Economic Stability Reserve and the Benefit Payout Reserve. Additional available balances will be used to cover costs
of the winter storm during the third quarter budget amendment. The timing of FEMA reimbursement for the storm
is not known.
UTILITY FUNDS:
Electric Fund: The City has used multiple strategies in the past two years to improve the performance of the Electric
Fund in relation to past and current expenditures for purchased power contracts. These strategies include increasing
the Power Cost Adjustment rate to recover revenue, reducing operating and capital expenditures in the electric
utility, selling utility assets, hiring a new General Manager, contracting professional services for energy portfolio
management and risk oversight. These have resulted in improved financial performance of the fund. To improve
rate competitiveness for customers, the City lowered the Power Cost Adjustment in January of 2021 by 1 cent per
kWh, to 1.375 cents per kWh. This resulted in a $5 million decrease in Electric Revenue as part of the FY2021
Amended budget in January and is reflected in this report.
Many departments in the utility funds were impacted by the winter storm. The Electric and Water fund incurred
significant increases in overtime, operations, and equipment needs/replacement. As part of the FY2021 Mid‐Year
Budget Amendment, staff is proposing additional appropriation to cover unforeseen costs associated with the winter
storm. This amendment will post in June, or the third quarter. Therefore, expenses are reflected in this report, but
the budget will not change until the third quarter report.
5
F FY2021 Quarterly Report
COG ‐ Electric Services Financial Report
Period: Q2 FY21
Budget Quarterly Comparison
FY2021
YTD Actuals:
Q2 FY20
YTD Actuals:
Q2 FY21 YTD Variance % Variance
Operating Revenue
Taxes 120,732 2,932 2,389 (544)‐18.54%
Fines and Penalties 553,724 275,840 415,395 139,555 50.59%
Investment Income 5,000 3,700 20,765 17,065 461.20%
Charges for Services 82,889,381 39,703,518 39,004,137 (699,381)‐1.76%
Developer Contributions 1,500,000 1,793,905 3,266,695 1,472,790 82.10%
70001:Transfers In 1,379,308 ‐ 1,379,308 1,379,308 0.00%
Operating Revenue Total 86,448,145 41,779,895 44,088,688 2,308,792 5.53%
Non‐Operating Revenue
Other Miscellaneous Revenue 45,000 558,436 969,245 410,809 73.56%
Bond Proceeds 6,648,625 ‐ ‐ ‐0.00%
Non‐Operating Revenue Total 6,693,625 558,436 969,245 410,809 73.56%
Operating revenue in the Electric Fund totals $44,088,688 through the quarter, or 51.00% of budget. Electric sales
revenue, the largest component of operating revenue, accounts for 91.36% of the overall budgeted operating
revenue. Charges for Services is made up of electric sales revenue, administrative charges, and fees. The largest
component, electric sales revenue totals $36,867,522, or 46.68% of budget. Electric revenue sales are typically
higher in the summer months when consumption increases. Developer contributions were conservatively budgeted
at $1,500,000. Year‐to‐date collection total 3,266,695, or 217.78% of budget.
The budget for non‐operating revenue totals $6,693,625 in FY2021. This total includes bond proceeds for capital
projects in the amount of $6,648,625. Year‐to‐date non‐operating revenue is in line with the second quarter of
FY2020. The City will recognize bond proceeds as part of the annual debt sale in the spring, or the third quarter.
6
F FY2021 Quarterly Report
COG ‐ Electric Services Financial Report
Period: Q2 FY21
Budget Quarterly Comparison
FY2021
YTD Actuals
w/Encumbrances:
Q2 FY20
YTD Actuals
w/Encumbrances:
Q2 FY21 YTD Variance
%
Variance
Operating Expense
CC0001 Non‐Departmental 5,506,375 2,623,678 3,366,496 (742,817)28.31%
CC0521 Electric Technical 711,765 339,783 322,812 16,971 ‐4.99%
CC0522 Electric Administration 8,738,050 4,517,376 4,432,996 84,379 ‐1.87%
CC0524 Metering Services 2,009,379 980,754 1,072,252 (91,498)9.33%
CC0525 T&D Services 2,918,996 2,133,792 2,093,770 40,022 ‐1.88%
CC0537 Electric Resource 60,334,393 26,809,590 86,341,401 (59,531,812)222.05%
CC0555 Electric Systems 1,578,902 766,758 779,240 (12,482)1.63%
CC0557 Electrical Engineering 636,869 427,248 507,406 (80,158)18.76%
Operating Expense Total 82,434,729 39,450,849 99,083,205 (59,632,356)151.16%
Non‐Operating Expense
CC0001 Non‐Departmental 4,152,805 590,971 614,762 (23,791) 4.03%
CC0557 Electrical Engineering 8,166,143 46,849 2,569,283 (2,522,434) 5384.17%
CC0526 Systems Engineering ‐ 1,030,860 ‐1,030,860 ‐100.00%
Non‐Operating Expense Total 12,318,948 1,668,680 3,184,045 (1,515,365)90.81%
Operating expenses in the Electric Fund total $99,083,205 through the quarter. Year‐to‐date purchase power
expenses total $86,498,858, while net congestion revenue rights (CRRs) credits total $(246,957). Net purchase power
totals $86,251,901 through the quarter. This is due to congestion in the grid, as well as the price spike in the cost of
energy during the winter storm.
The polar vortex winter storm Uri caused significant disruption in the Texas energy market. This disruption led to
extreme price spikes in the cost of energy, and the City had a net obligation of approximately $48 million. The $48
million is beyond the City’s capacity to handle with current unrestricted reserves. For comparison, the annual cost of
energy is about $60 million. Therefore, the City has secured a Public Property Finance Contractual Obligation (PPFCO).
This is a tax‐backed obligation with a subordinate lien on Electric Utility revenues. The PPFCO has a 9.5‐year term,
with a 5‐year call option. This is a fixed rate bond (1.73% taxable) that was privately placed with Wells Fargo. It is
structured with level annual payments. The average annual principal and interest payment of $5,298,851 will be
repaid with Electric revenues from the City’s current Power Cost Adjustment of 1.375 per kWh.
In addition to overtime from the winter storm, personnel costs in Electric Engineering and Transmission and
Distribution (T&D) cost centers look inflated. This labor will be capitalized to the appropriate capital improvement
project at the end of the fiscal year, and therefore will be on budget at year‐end.
Non‐operating expenditures are budgeted at $12,318,948 in FY2021. Budgeted non‐operating expenditures include
$8,166,143 for capital projects and $4,152,805 for debt service payments, both of which typically trend towards later
7
F FY2021 Quarterly Report
quarters. As previously mentioned, a significant portion of labor expenses for capital projects will be journaled at the
end of the fiscal year.
Overall, even with the challenges of the winter storm, the Electric Fund is anticipated to end the year able to meet
the 90‐day contingency reserve requirement.
Water Fund:
Year‐to‐date Operating revenue totals $49,099,372, or 69.24% of budget. Charges for services which includes water,
wastewater, irrigation, and fees revenue total $28,640,949 through the quarter, or 69.24%. This revenue is up
19.50% compared to the same period last year. Impact fees total $18,800,000 in budgeted operating revenue, or
26.51%, of total operating revenue. Through the quarter, impact fees total $19,965,449. Water utility staff is working
to better estimate these fees for fiscal year‐end and for FY2022 planning. Total Water Fund operating revenue is up
20.82% compared to the same period last fiscal year due to growth in sales and collections in impact fees.
The budget for non‐operating revenue totals $17,412,500 in FY2021. This total includes bond proceeds for capital
projects in the amount of $16,300,000. The City will recognize bond proceeds as part of the annual debt sale in the
spring, or third quarter.
COG ‐ Water Services Financial Report
Period: Q2 FY21
Budget Quarterly Comparison
FY2021
YTD Actuals:
Q2 FY20
YTD Actuals:
Q2 FY21
YTD
Variance % Variance
Operating Revenue
Fines and Penalties 255,000 231,580 242,368 10,788 4.66%
Investment Income 237,250 950,050 250,606 (699,444)‐73.62%
Charges for Services 50,995,000 23,966,849 28,640,949 4,674,101 19.50%
Impact Fees 18,800,000 15,489,022 19,965,449 4,476,426 28.90%
Donations and Grants 625,000 ‐ ‐ ‐0.00%
Operating Revenue Total 70,912,250 40,637,501 49,099,372 8,461,871 20.82%
Non‐Operating Revenue
Other Miscellaneous Revenue 1,112,500 888,083 43,583 (844,500)‐95.09%
Bond Proceeds 16,300,000 ‐ ‐ ‐0.00%
Non‐Operating Revenue Total 17,412,500 888,083 43,583 (844,500)‐95.09%
Operating expenses in the Water Fund total $25,681,704 through the quarter, or 55.27% of budget. Operational
costs are trending slightly higher than 50%. This is normal as large encumbrances for contracts take place at the
beginning of the fiscal year. Personnel costs are also higher due to the winter storm overtime. Staff will continue to
monitor operational costs through the year.
Non‐operating expenditures are budgeted at $124,787,037 in FY2021. Budgeted non‐operating expenditures include
$116,395,525 for capital projects and $7,232,088 for debt service payments. Expenditures are $37,146,959 through
8
F FY2021 Quarterly Report
the quarter, which includes encumbrances for large projects. Annual principal and interest debt payments will post
to the third quarter.
Large variances between Systems Engineering and Water Operations cost centers compared to FY2020 are due to
data coding changes in the new financial software system and are not a concern.
COG ‐ Water Services Financial Report
Period: Q2 FY21
Budget Quarterly Comparison
FY2021
YTD Actuals
w/Encumbranc
es: Q2 FY20
YTD Actuals
w/Encumbrances:
Q2 FY21
YTD
Variance % Variance
Operating Expense
CC0001 Non‐Departmental 4,041,064 1,794,823 2,096,476 (301,653)16.81%
CC0526 Systems Engineering ‐ 15,453,382 409,649 15,043,733 ‐97.35%
CC0527 Water Services 26,385,392 12,548,450 14,541,823 (1,993,373)15.89%
CC0528 Water Distribution 2,717,500 1,450,686 1,813,594 (362,908)25.02%
CC0529 Water Plant 4,261,242 2,153,207 2,083,147 70,060 ‐3.25%
CC0530 Wastewater 896,100 552,811 386,775 166,035 ‐30.03%
CC0531 Wastewater Plant 3,956,455 2,081,504 2,060,124 21,380 ‐1.03%
CC0532 Irrigation 295,000 139,631 77,896 61,735 ‐44.21%
CC0553 Water Operations 3,916,787 9,559,259 2,212,220 7,347,039 ‐76.86%
Operating Expense Total 46,469,539 45,944,222 25,681,704 20,262,517 ‐44.10%
Non‐Operating Expense
CC0001 Non‐Departmental 4,083,411 515,954 534,920 (18,967)3.68%
CC0524 Metering Services 750,000 ‐ ‐ ‐0.00%
CC0526 Systems Engineering 99,630,405 3,482,714 22,386,283 (18,903,569)542.78%
CC0528 Water Distribution 1,159,424 ‐ 456,600 (456,600)0.00%
CC0529 Water Plant 2,757 ‐ ‐ ‐0.00%
CC0530 Wastewater 3,026,798 573,079 ‐ 573,079 ‐100.00%
CC0531 Wastewater Plant 2,050,000 ‐ ‐ ‐0.00%
CC0532 Irrigation 121,879 11,601 ‐ 11,601 ‐100.00%
CC0553 Water Operations 13,962,363 20,040 10,953,288 (10,933,248)54557.13%
Non‐Operating Expense 124,787,037 4,603,388 37,146,959 32,543,571 706.95%
9
F FY2021 Quarterly Report
OTHER MAJOR FUNDS:
Tourism Fund: The COVID‐19 pandemic significantly
impacted the tourism sector. Overall revenue in the
fund totals $341,760, or 32.55% of budget. Hotel
Occupancy Tax revenue totals $331,335 through the
quarter, or 36.81% of budget. Staff have continued to
market Georgetown and are pleased to see occupancy
rates recovering slowly but steadily.
Year to date expenses in the Convention & Visitors
Bureau Fund total $592,029 or 40.05% of budget. Staff
will continue to monitor this fund as travel is anticipated
to pick up in the spring and summer months. The City
has postponed the annual Red Poppy Festival in the
spring for a second year in a row. This will impact
revenues and expenditures in the fund during the
second quarter.
Airport Fund: Airport operating revenue budget totals $3,451,500. Airport Charges, the largest segment of revenue
totals $1,712,703. This includes revenue for fuel sales, facility lease, and hangar rentals. Revenues through the
quarter are $1,658,040, or 48.04% of budget.
Operation expenses in the Airport fund total $3,921,513. Year‐to‐date operation expenses totals $3,991,102 which
include a $2,430,989 encumbrance for annual fuel costs. Non‐operating revenues are bond proceeds for capital
projects. Non‐operating expenses are budgeted at $908,931 for CIP expense and the Airports debt service payments.
There is no activity in non‐operating for the quarter.
II. INVESTMENTS
The investment activity and strategies described in this report comply with the Public Funds Investment Act (PFIA),
the City’s investment policy, and generally accepted accounting principles. Activity for the second quarter of fiscal
year 2021 includes the maturing of financial institution deposits (CDs), reinvestment of CD’s, and investing of
consolidated funds in CD’s. Interest rates for money market accounts, Treasury bills, and CD’s decreased again during
this quarter. We are seeing a decline in rates being submitted for our competitive investment offerings due to no
positive changes in the market. We are also seeing a decline in the number of banks responding to our investment
offerings. The Federal Open Market Committee (FOMC) expect to keep the Federal Funds rate around 0%‐.25% due
to the COVID‐19 pandemic and the impacted economy for an extended period of time. These are the lowest rates
we have seen since December 2008. We expect the problem to be exacerbated in the Third Quarter due to the US
Treasury’s release of the billions of dollars for the American Rescue Plan. The City will continue soliciting for the best
rates to improve both diversity and yield, while keeping in mind safety and liquidity.
The Investment Reports for the quarter ending March 31, 2021, and the supporting schedules are attached. Valley
View Consulting, L.L.C., has prepared the attached investment reports. A component of our investment advisory
services contract includes Valley View preparing the quarterly investment reports on behalf of the City. A summary
of the investment balances at March 31, 2021, compared to the prior quarter, is shown below for the City, as well as
Georgetown Transportation Enhancement Corporation (GTEC) and Georgetown Economic Development Corporation
(GEDCO). Included in the City portfolio are debt service, consolidated funds, and bond proceeds. The breakdown is
consolidated at 71.83%, debt service at 6.35%, and bond proceeds at 21.82%.
309K
368K
249K
321K
141K
190K
K
100K
200K
300K
400K
Q1 Q2
HOTEL OCCUPANCY TAX
FY2019 FY2020 FY2021
10
F FY2021 Quarterly Report
CITY Book Value GTEC GEDCO
12/31/20 3/31/21 12/31/20 3/31/21 12/31/20 3/31/21
Total cash and
investments
$258,316,790 $276,385,252 $31,693,655 $33,083,118 $10,161,540 $11,095,498
Quarter End Average
Yield
.37% .21% .12% .06% .41% .08%
The City’s strategy continues to be matching maturities with cash flow needs, while focusing on the investment
policy’s long‐range goals. The City’s investment strategy is to “ladder” or stagger maturities, thus minimizing erratic
interest rate fluctuations. The City is continuing to manage the yield on bond proceeds for arbitrage purposes.
The City’s investment portfolio generally includes bank deposits, local government investment pool balances, money
market accounts, and financial institution deposits (CD’s). All of these investments meet the safety requirements of
the PFIA. Local Government Investment Pools must maintain a rating of AAAm, Securities (Treasury Bills) must have
direct or implied backing of the Federal Government and Financial Institution Deposits (CDs and money market
accounts) must be collateralized with FDIC insurance or obligations with an implied backing from the Federal
Government. The collateral on all City investments are monitored monthly to ensure the financial institutions carry
minimum collateral of 100% with a letter of credit or 102% with pledged securities for all of the City’s investments.
All securities held by financial institutions as collateral on behalf of the City have been reviewed and met PFIA‐
minimum rating criteria.
The City continues to work with the City’s depository bank (JPMorgan Chase) to find an average daily balance that is
best to receive the highest yield on the account. These balances earn credit against the fees charged by the bank.
The City will continue to verify depository yield versus investment yield to achieve the best outcome.
III. CAPITAL PROJECTS
The projects in the Capital Improvement Program (CIP) consist of infrastructure and related construction and do not
include small capital items such as furniture, equipment, and vehicle maintenance. Maintenance‐type projects are
not capitalized as a fixed asset and are usually cash funded. Therefore, these projects are operational in nature and
are in the departmental operating budget.
A life‐to‐date schedule for each of the approved projects is included in the quarterly report. This means the budget
and spending in the report are for all fiscal years of the project, not just the current fiscal year or quarter. This view
provides a more comprehensive picture of the City’s capital program. Projects are grouped based on fund, division,
and cost center.
11
COG ‐ General Fund Financial Report
Period: Mar‐21 Budget Period
FY2021 Mar‐21
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 15,548,923 15,548,923 ‐ 100.00%
Revenue
40001:Property Taxes 15,976,505 315,215 16,427,813 451,308 102.82%
40002:Sales Taxes 18,576,250 1,585,830 7,431,798 (11,144,452) 40.01%
40005:Franchise Taxes 6,255,270 311,590 2,783,150 (3,472,120) 44.49%
40008:Other Taxes 400,000 17,858 87,386 (312,614) 21.85%
41001:Fines 328,392 29,515 107,775 (220,617) 32.82%
41002:Penalties 60,000 9,962 48,624 (11,376) 81.04%
42001:Interest Income 75,000 (273) 43,091 (31,909) 57.46%
43001:Fees 7,028,184 634,010 3,294,925 (3,733,259) 46.88%
43002:Garbage Charges 10,151,764 1,031,222 5,316,194 (4,835,570) 52.37%
43003:Permits 4,317,750 377,405 2,562,111 (1,755,639) 59.34%
43004:Administrative Charges 3,396,447 282,708 1,696,251 (1,700,196) 49.94%
43005:Rental Revenue 148,140 12,067 86,772 (61,368) 58.57%
44001:Grant Revenue 679,884 241,317 433,004 (246,880) 63.69%
44502:Developer Contributions ‐ 253,798 423,328 423,328 0.00%
44503:Interlocal Agreement Revenue 5,091,091 1,183,773 2,367,546 (2,723,546) 46.50%
45001:Misc Revenue 871,955 83,456 398,441 (473,514) 45.70%
70001:Transfers In 995,302 ‐ 995,302 ‐ 100.00%
70002:Transfers In ‐ ROI 8,431,375 782,613 4,354,647 (4,076,728) 51.65%
Revenue Total 82,783,309 7,152,065 48,858,157 (33,925,152) 59.02%
Expense
CC0001 Non‐Departmental 1,353,191 980 762,585 590,606 56.35%
CC0107 Planning 1,860,789 68,685 789,558 1,071,232 42.43%
CC0202 Parks Administration 662,224 38,834 305,057 357,168 46.07%
CC0210 Library 2,837,904 139,250 1,371,235 1,466,669 48.32%
CC0211 Parks 2,721,425 149,038 1,361,495 1,359,930 50.03%
CC0212 Recreation 2,897,351 152,822 1,333,703 1,563,648 46.03%
CC0213 Tennis Center 442,917 23,390 180,507 262,410 40.75%
CC0214 Recreation Programs 1,237,960 38,229 288,675 949,285 23.32%
CC0215 Garey Park 979,961 50,983 477,289 502,672 48.70%
CC0218 Arts and Culture 57,857 4,832 28,093 29,764 48.56%
CC0316 Municipal Court 585,123 29,002 264,871 320,253 45.27%
CC0402 Fire Support Services/Administration 4,254,731 209,053 1,815,670 2,439,060 42.67%
CC0422 Fire Emergency Services 15,932,476 658,855 7,230,849 8,701,626 45.38%
CC0448 EMS 2,579,106 130,215 1,417,575 1,161,530 54.96%
CC0533 Environmental Services 9,662,924 757,899 3,775,444 5,887,481 39.07%
CC0536 Inspection Services 1,519,534 62,115 633,417 886,118 41.68%
CC0602 Administrative Services 1,893,883 78,346 876,168 1,017,715 46.26%
CC0605 Community Services 353,889 13,420 201,966 151,922 57.07%
CC0634 City Council Services 185,734 23,593 99,423 86,311 53.53%
CC0635 City Secretary Services 1,000,047 83,695 473,228 526,818 47.32%
CC0638 General Government Contracts 4,774,808 353,655 2,729,217 2,045,591 57.16%
CC0655 Communications/Public Engagement 844,604 31,700 398,261 446,343 47.15%
CC0702 Police Administration 2,559,766 193,991 1,235,898 1,323,869 48.28%
CC0742 Police Operations 14,335,833 645,197 6,934,948 7,400,885 48.37%
CC0744 Animal Services 1,106,702 50,600 460,114 646,588 41.58%
CC0745 Code Compliance 562,584 25,977 229,168 333,416 40.73%
CC0802 Public Works 1,462,292 333,850 1,032,233 430,059 70.59%
CC0846 Streets 3,086,124 162,828 1,474,794 1,611,330 47.79%
Expense Total 81,751,737 4,511,034 38,181,440 43,570,297 46.70%
Excess (Deficiency) of Total Revenue over Total Requirements 1,031,571 2,641,031 10,676,717 11,708,288 1035.00%
Ending Fund Balance 16,580,494 26,225,640 9,645,145 158.17%
Reserves
Contingency 12,626,752 12,626,752 ‐ 100.00%
Benefit Payout Reserve 340,000 340,000 ‐ 100.00%
Economic Stability Reserve 1,467,563 1,467,563 ‐ 100.00%
Reserves Total 14,434,315 14,434,315 ‐ 100.00%
Available Fund Balance 2,146,179 11,791,325 9,645,145 549.41%
YTD Actuals Budget vs. Actuals
12
COG ‐ Electric Services Financial Report
Period: Mar‐21
Budget Period
FY2021 Mar‐21
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 19,702,705 ‐ 19,702,705 ‐ 100.00%
Operating Revenue
40002:Sales Taxes 5,000 387 2,389 (2,611) 47.77%
40005:Franchise Taxes 115,732 ‐ ‐ (115,732) 0.00%
41002:Penalties 553,724 87,911 415,395 (138,329) 75.02%
42001:Interest Income 5,000 95 20,765 15,765 415.30%
43001:Fees 685,000 65,060 525,563 (159,437) 76.72%
43004:Administrative Charges 3,222,103 268,509 1,611,051 (1,611,052) 50.00%
43601:Electric Sales Revenue 78,982,278 6,277,631 36,867,522 (42,114,756) 46.68%
44502:Developer Contributions 1,500,000 896,117 3,266,695 1,766,695 217.78%
70001:RC0225 Transfer In ‐ GEDCO 1,000,000 ‐ 1,000,000 ‐ 100.00%
70001:RC0241 Transfer In ‐ South TIRZ 379,308 ‐ 379,308 ‐ 100.00%
Operating Revenue Total 86,448,145 7,595,710 44,088,688 (42,359,457) 51.00%
Opearating Expense
CC0001 Non‐Departmental 5,506,375 616,009 3,366,496 2,139,879 61.14%
CC0521 Electric Technical Services 711,765 32,596 322,812 388,953 45.35%
CC0522 Electric Administration 8,738,050 712,730 4,432,996 4,305,053 50.73%
CC0524 Metering Services 2,009,379 142,210 1,072,252 937,127 53.36%
CC0525 T&D Services 2,918,996 258,852 2,093,770 825,226 71.73%
CC0526 Systems Engineering ‐ ‐ 166,831 (166,831) 0.00%
CC0537 Electric Resource Management 60,334,393 8,207,405 86,341,401 (26,007,008) 143.10%
CC0555 Electric Systems Operations 1,578,902 60,823 779,240 799,663 49.35%
CC0557 Electrical Engineering 636,869 68,341 507,406 129,463 79.67%
Operating Expense Total 82,434,729 10,098,967 99,083,205 (16,648,476) 120.20%
Net Operations Total 4,013,416 (2,503,258) (54,994,517) (59,007,933) ‐1370.27%
Non‐Operating Revenue
45001:Misc Revenue 35,000 53,977 76,471 (41,471) 218.49%
45004:Sale of Property 10,000 736,303 892,773 (882,773) 8927.73%
46001:Bond Proceeds 6,648,625 ‐ ‐ 6,648,625 0.00%
Non‐Operating Revenue Total 6,693,625 790,280 969,245 (5,724,380) 14.48%
Non‐Operating Expenses
CC0001 Non‐Departmental 4,152,805 ‐ 614,762 3,538,043 14.80%
CC0557 Electrical Engineering 8,166,143 215,458 2,569,283 5,596,859 31.46%
Non‐Operating Expense Total 12,318,948 215,458 3,184,045 9,134,903 25.85%
Net Non‐Operations Total (5,625,323) 574,822 (2,214,800) 3,410,522 39.37%
Excess (Deficiency) of Total Revenue over Total Requirements (1,611,907) (1,928,436) (57,209,317) (58,821,224) 3549.17%
Ending Fund Balance 18,090,798 (1,928,436) (37,506,612) (55,597,410) ‐207.32%
Reserves
Contingency Reserve 4,018,754 ‐ 4,018,754 ‐ 100.00%
Non‐Operational Reserve 10,594,999 ‐ 10,594,999 ‐ 100.00%
Bond Proceeds Reserve 3,477,046 ‐ 3,477,046 ‐ 100.00%
Reserves Total 18,090,799 18,090,799 ‐ 100.00%
Available Fund Balance 0 (55,597,411) 55,597,411 0.00%
YTD Actuals Budget vs. Actuals
13
COG ‐ Water Services Financial Report
Period: Mar‐21
Budget Period
FY2021 Mar‐21
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 115,511,818 ‐ 115,511,818 ‐ 100.00%
Operating Revenue
41002:Penalties 255,000 46,303 242,368 (12,632) 95.05%
42001:Interest Income 237,250 1,712 250,606 (13,356) 105.63%
43001:Fees 4,290,000 915,470 4,747,148 (457,148) 110.66%
43005:Rental Revenue 55,000 3,650 55,594 (594) 101.08%
43602:Water Charges 32,150,000 3,102,651 16,574,767 15,575,233 51.55%
43603:Wastewater Charges 14,200,000 1,453,604 7,127,251 7,072,749 50.19%
43604:Irrigation Charges 300,000 11,121 136,188 163,812 45.40%
41602:Impact Fees 18,800,000 3,899,006 19,965,449 (1,165,449) 106.20%
44502:Developer Contributions 625,000 ‐ ‐ 625,000 0.00%
Operating Revenue Total 70,912,250 9,433,517 49,099,372 21,812,878 69.24%
Operating Expense
CC0001 Non‐Departmental 4,041,064 352,305 2,096,476 1,944,588 51.88%
CC0526 Systems Engineering ‐ 5,064 409,649 (409,649) 0.00%
CC0527 Water Services Administration 26,385,392 2,058,444 14,541,823 11,843,569 55.11%
CC0528 Water Distribution 2,717,500 563,004 1,813,594 903,906 66.74%
CC0529 Water Plant Management 4,261,242 239,904 2,083,147 2,178,095 48.89%
CC0530 Wastewater Operations 896,100 51,208 386,775 509,325 43.16%
CC0531 Wastewater Plant Management 3,956,455 338,064 2,060,124 1,896,331 52.07%
CC0532 Irrigation Operations 295,000 2,590 77,896 217,104 26.41%
CC0553 Water Operations 3,916,787 170,195 2,212,220 1,704,566 56.48%
Operating Expense Total 46,469,539 3,780,776 25,681,704 20,787,835 55.27%
Net Operations Total 24,442,711 5,652,740 23,417,668 (1,025,043) 95.81%
Non‐Operating Revenue
45001:Misc Revenue 1,112,500 8,759 43,583 (1,068,917) 3.92%
46001:Bond Proceeds 16,300,000 ‐ ‐ (16,300,000) 0.00%
Non‐Operating Revenue Total 17,412,500 8,759 43,583 (17,368,917) 0.25%
Non‐Operating Expenses
CC0001 Non‐Departmental 4,083,411 ‐ 534,920 3,548,491 13.10%
CC0524 Metering Services 750,000 ‐ ‐ 750,000 0.00%
CC0526 Systems Engineering 99,630,405 2,239,837 22,949,004 76,681,401 23.03%
CC0528 Water Distribution 1,159,424 ‐ 781,316 378,108 67.39%
CC0529 Water Plant Management 2,757 ‐ ‐ 2,757 0.00%
CC0530 Wastewater Operations 3,026,798 ‐ 533,080 2,493,718 17.61%
CC0531 Wastewater Plant Management 2,050,000 ‐ ‐ 2,050,000 0.00%
CC0532 Irrigation Operations 121,879 ‐ 9,606 112,273 7.88%
CC0553 Water Operations 13,962,363 950,148 12,748,682 1,213,681 91.31%
Non‐Operating Expenses Total 124,787,037 3,184,921 37,146,959 87,640,078 29.77%
Net Non‐Operations Total (107,374,537) (3,176,162) (37,103,376) 70,271,161 34.56%
Excess (Deficiency) of Total Revenue over Total Requirements (82,931,826) 2,476,579 (13,685,708) (96,617,534) 16.50%
Ending Fund Balance 32,579,992 2,476,579 101,826,110 69,246,118 312.54%
Reserves
Contingency Reserve 9,127,742 ‐ 9,127,742 ‐ 100.00%
Debt Service Reserve 10,000,000 ‐ 10,000,000 ‐ 100.00%
19,127,742 ‐ 19,127,742 ‐ 100.00%
Available Fund Balance 13,452,250 82,698,368 69,246,118 614.75%
YTD Actuals Budget vs. Actuals
14
COG - Joint Services Financial Report
Period: Mar-21
Budget Period
FY2021 Mar-21
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 2,032,470 - 2,032,470
Revenue
41002:Penalties - 3,505 15,399 15,399 0.00%
42001:Interest Income 6,250 - 4,822 (1,428) 77.16%
43001:Fees 173,600 1,290 6,660 (166,940) 3.84%
43004:Administrative Charges 17,967,880 1,497,575 8,985,447 (8,982,433) 50.01%
43005:Rental Revenue - - 100 100 0.00%
45001:Misc Revenue - - 431 431 0.00%
45002:Insurance Proceeds - 8,642 40,906 40,906 0.00%
45003:Misc Reimbursements 83,000 516 31,498 (51,503) 37.95%
Revenue Total 18,230,730 1,511,528 9,085,263 (9,145,467) 49.83%
Expense
CC0001 Non-Departmental 609,999 83,336 659,835 (49,836) 108.17%
CC0302 Finance Administration 1,222,909 86,269 635,959 586,950 52.00%
CC0315 Accounting 1,295,484 83,065 669,152 626,333 51.65%
CC0317 Purchasing 1,001,969 52,626 447,378 554,592 44.65%
CC0321 Customer Care 5,986,413 400,067 3,068,843 2,917,570 51.26%
CC0503 Organizational and Operational Excellence 342,009 11,260 139,619 202,390 40.82%
CC0526 Systems Engineering 2,752,912 132,669 1,399,602 1,353,309 50.84%
CC0534 Conservation 806,212 13,996 255,552 550,660 31.70%
CC0637 Economic Development 568,690 30,472 274,613 294,076 48.29%
CC0639 Human Resources 1,502,553 62,284 680,192 822,361 45.27%
CC0640 Citywide Human Resources 1,219,444 53,145 727,612 491,832 59.67%
CC0654 Legal 1,047,947 45,509 524,347 523,600 50.04%
Expense Total 18,356,541 1,053,877 9,482,704 8,873,838 51.66%
Excess (Deficiency) of Total Revenue over Total Requirements (125,811) 457,651 (397,440) (523,252) 315.90%
Ending Fund Balance 1,906,659 1,635,030
Reserves
Contingency Reserve 1,906,658 1,906,658 - 100.00%
Debt Service Reserve - - 0.00%
Reserve Total 1,906,658 - 1,906,658 - 100.00%
Avaiable Fund Balance 1 (271,628) (271,629) -39945363.25%
Actuals Budget vs. Actuals
15
COG - Council Discretionary Financial Report
Period: Mar-21
Budget Period
FY2021 Mar-21
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 110,483 110,483 - 100.00%
Revenue
Investment Income 500 - 121 (379) 24.28%
42001:Interest Income 500 - 121 (379) 24.28%
Revenue Total 500 - 121 (379) 24.28%
Expense
Transfers 110,983 - 110,983 - 100.00%
Expense Total 110,983 - 110,983 - 100.00%
Excess (Deficiency) of Total Revenue over
Total Requirements (110,483) - (110,862) (221,345) 100.34%
Ending Fund Balance - (379) (379) #DIV/0!
Actuals Budget vs. Actuals
16
COG - Tourism Financial Report
Period: Mar-21
Budget Period
FY2021 Mar-21
YTD Actuals w/
Encumbrances Variance % of Budget
Beginning Fund Balance 1,282,917 - 1,282,917 - 100.00%
Revenue
40008:Other Taxes 900,000 78,698 331,335 (568,665) 36.81%
42001:Interest Income 5,000 - 3,070 (1,930) 61.40%
45001:Misc Revenue 95,000 1,205 7,355 (87,645) 7.74%
44505:Sponsorship 50,000 - - (50,000) 0.00%
Revenue Total 1,050,000 79,903 341,760 (708,240) 32.55%
Expense
Personnel 435,456 12,136 161,137 274,319 37.00%
Operations 1,014,085 23,255 402,258 611,827 39.67%
Transfers 28,634 - 28,634 - 100.00%
Expense Total 1,478,175 35,391 592,029 886,146 40.05%
Excess (Deficiency) of Total Revenue
over Total Requirements (428,175) 44,512 (250,269) (678,445) 58.45%
Reserves
Contingency Reserve 305,771 305,771 100.00%
Reserves Total 305,771 305,771 100.00%
Ending Fund Balance 548,971 - 726,877 177,906 132.41%
Actuals Budget vs. Actuals
17
COG - Airport Financial Report
Period: Mar-21
Budget Period
FY2021 Mar-21
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 1,428,114 - 1,428,114 - -
Operating Revenue
40001:Property Taxes 40,000 - (57,018) (97,018) -142.54%
42001:Interest Income 3,000 1 2,355 (645) 78.50%
43606:Airport Charges 3,408,500 398,177 1,712,703 (1,695,797) 50.25%
Operating Revenue Total 3,451,500 398,178 1,658,040 (1,793,460) 48.04%
Operarting Expense
Personnel 429,433 15,832 199,340 230,093 46.42%
Operations 3,138,013 297,604 3,790,502 (652,489) 120.79%
Operating Capital 354,067 - 1,261 352,806 0.36%
Operating Expense Total 3,921,513 313,436 3,991,102 (69,589) 101.77%
Total Net Operations (470,013) 84,741 (2,333,062) (1,723,870) 496.38%
Non-Operating Revenue
45001:Misc Revenue 5,000 - - (5,000) 0.00%
46001:Bond Proceeds 700,000 - - (700,000) 0.00%
Non-Operating Revenue Total 705,000 - - (705,000) 0.00%
Non-Operating Expense
CIP Expense 750,000 - - 750,000 0.00%
Debt Service 158,931 - 26,899 132,032 16.92%
Non-Operating Expense Total 908,931 - 26,899 882,032 2.96%
Net Non-Operations Total (203,931) (26,899) 177,032 13.19%
Excess (Deficiency) of Total Revenue
over Total Requirements (673,944) 84,741 (2,359,961) (3,033,904) 450.17%
Ending Fund Balance 754,170 (931,847) (3,310,902) -123.56%
Reserves
Contingency Reserve 332,917 332,917 100%
Debt Service Reserve 141,478 141,478 100%
Reserves Total 474,395 474,395 100%
Available Fund Balance 279,775 (1,406,242) (1,686,017) -503%
YTD Actuals Budget Vs. Actuals
18
COG - GTEC Financial Report
Period: Mar-21
Budget Period
FY2021 Mar-21
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 26,022,482 26,022,482 - 100.00%
Operating Revenue
40002:Sales Taxes 8,255,000 704,723 3,302,454 (4,952,546) 40.01%
42001:Interest Income 60,000 1,616 16,769 (43,231) 27.95%
Operating Revenue Total 8,315,000 706,339 3,319,223 (4,995,777) 39.92%
Operarting Expense
Operations 402,962 33,514 219,771 183,191 54.54%
Operating Capital - - 4,140 (4,140) 0.00%
Transfers 2,763,242 - 420,122 2,343,120 15.20%
Operating Expense Total 3,166,204 33,514 644,034 2,522,170 20.34%
Total Net Operations 5,148,796 672,826 2,675,190 (7,517,947) 51.96%
Non-Operating Revenue
46001:Bond Proceeds 10,600,000 - - (10,600,000) 0.00%
Non-Operating Revenue Total 10,600,000 - - (10,600,000) 0.00%
Non-Operating Expense
Operations 1,984,375 - - 1,984,375 0.00%
CIP Expense 23,076,813 67,410 545,157 22,531,656 2.36%
Debt Service 1,053,050 - 110,525 942,525 10.50%
Non-Operating Expense Total 26,114,238 67,410 655,682 25,458,556 2.51%
Net Non-Operations Total (15,514,238) (67,410) (655,682) 14,858,556 4.23%
Excess (Deficiency) of Total Revenue
over Total Requirements (10,365,442) 605,416 2,019,508 (8,345,934) 80.52%
Ending Fund Balance 15,657,040 28,041,990 12,384,950 179.10%
Reserves
Contingency Reserve 1,984,375 1,984,375
Debt Service Reserve 3,494,232 3,494,232
Reserves Total 5,478,607 5,478,607
Available Fund Balance 10,178,433 22,563,383 12,384,950 221.68%
YTD Actuals Budget Vs. Actuals
19
COG - GEDCO Financial Report
Period: Mar-21
Budget Period
FY2021 Mar-21
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 8,845,777 - 8,845,777 - 100.00%
Operating Revenue
40002:Sales Taxes 2,063,750 176,181 825,614 (1,238,136) 40.01%
42001:Interest Income 19,000 451 21,010 2,010 110.58%
Operating Revenue Total 2,082,750 176,632 846,624 (1,236,126) 40.65%
Operarting Expense
Operations 593,783 36,168 227,997 365,786 38.40%
Transfers 1,200,169 - 1,040,084 160,085 86.66%
Operating Expense Total 1,793,952 36,168 1,268,082 525,870 70.69%
Total Net Operations 288,798 140,464 (421,458) (1,761,996) -145.94%
Non-Operating Revenue
Non-Operating Expense
Operations 8,256,391 - 400,000 7,856,391 4.84%
Debt Service 90,572 - - 90,572 0.00%
Non-Operating Expense Total 8,346,963 - 400,000 7,946,963 4.79%
Net Non-Operations Total (8,346,963) - (400,000) 7,946,963 4.79%
Excess (Deficiency) of Total Revenue
over Total Requirements (8,058,165) 140,464 (821,458) (8,879,623) 110.19%
Ending Fund Balance 787,612 140,464 8,024,319 7,236,707 1018.82%
Reserves
Contingency Reserve 505,468 505,468
Debt Service Reserve 202,769 202,769
Reserves Total 708,237 708,237
Available Fund Balance 79,375 - 7,316,082 7,236,707 9217.11%
YTD Actuals Budget Vs. Actuals
20
CITY
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
March 31, 2021
Prepared by
Valley View Consulting, L.L.C.
________________________________________________________________________
Leigh Wallace Nathan Parras
Finance Director Assistant Finance Director
________________________________________________________________________
Karrie Pursley Elaine Wilson
Treasurer Assistant Finance Director
The investment portfolio of the City of Georgetown is in compliance with the Public Funds Investment Act and
the Investment Policy and Strategies.
Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or
completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from
sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective
of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total
return yields and do not account for investment advisor fees.
21
Economic Overview3/31/2021The Federal Open Market Committee (FOMC) maintained the Fed Funds target range at 0.00% to 0.25% (Effective Fed Funds are trading <0.10%), and projected that reduced rates could remain into 2023 or longer. Fourth Quarter GDP finalized at +4.3%. March Non Farm Payroll added 916k and Unemployment declined to 6.0%. Crude oil traded above $60 per barrel. The Stock Markets reached new highs. Housing, Industrial Production, Durable Goods, Consumer Spending, and other indicators showed solid gains. An additional $1.9 trillion stimulus package passed Congress and was signed by the President. The Yield Curve continued steepening on longer maturities.02505007501,0001,2501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,0004,250S&P 5000.000.501.001.502.002.503.003.50US Treasury Historical Yields - Since Nov 2015Six Month T-BillTwo Year T-NoteTen Year T-Note0.000.200.400.600.801.001.201.401.601.802.00Treasury Yield CurvesMarch 31, 2020December 31, 2020March 31, 20210.000.501.001.502.002.503.003.504.004.505.005.506.00US Treasury Historical Yields - Since 2006Six Month T-BillTwo Year T-NoteTen Year T-NoteValley View Consulting, L.L.C.22
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Demand Accounts 15,461,481$ 15,461,481 15,550,035$ 15,550,035$ 0.22%
NOW/MMA 12,024,426 12,024,426 11,019,484 11,019,484 0.33%
Pools 108,820,032 108,820,032 144,095,312 144,095,312 0.02%
CDs/Securities 122,010,850 122,010,850 105,720,421 105,720,421 0.45%Totals 258,316,790$ 258,316,790$ 276,385,252$ 276,385,252$ 0.21%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.21%Total Portfolio 0.29%
Rolling Three Month Treasury 0.06%Rolling Three Month Treasury 0.08%
Rolling Six Month Treasury 0.09%Rolling Six Month Treasury 0.10%
TexPool 0.02%TexPool 0.05%
Bank Fees Offset
10,568$
Interest earnings provided in separate report.18,679$
December 31, 2020
(1)Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not
considered. The yield for the reporting month is used for bank, pool, and money market balances.
(2)Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return
analysis or account for advisory fees.
Quarterly Bank Fees Offset
Year-to-date Bank Fees Offset
March 31, 2021
City of Georgetown Valley View Consulting, L.L.C.23
City - Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
JPMorgan Chase Cash (3)0.22%04/01/21 03/31/21 15,550,035$ 15,550,035$ 1.00 15,550,035$ 1 0.22%
JPMorgan Chase MMA 0.03%04/01/21 03/31/21 434,048 434,048 1.00 434,048 1 0.03%
Veritex Bank MMA 0.10%04/01/21 03/31/21 3,213,253 3,213,253 1.00 3,213,253 1 0.10%
NexBank MMA 0.45%04/01/21 03/31/21 7,372,182 7,372,182 1.00 7,372,182 1 0.45%
TexPool AAAm 0.02%04/01/21 03/31/21 58,862,442 58,862,442 1.00 58,862,442 1 0.02%
TexSTAR AAAm 0.02%04/01/21 03/31/21 85,232,871 85,232,871 1.00 85,232,871 1 0.02%
Prosperity Bank CD 0.45%04/01/21 07/01/20 4,006,098 4,006,098 100.00 4,006,098 1 0.45%
Independent Bank CD 1.80%04/22/21 10/22/19 4,193,238 4,193,238 100.00 4,193,238 22 1.81%
Bank OZK CD 0.70%05/10/21 05/08/20 12,070,246 12,070,246 100.00 12,070,246 40 0.70%
Southside Bank CD 0.22%06/11/21 09/11/20 5,005,456 5,005,456 100.00 5,005,456 72 0.22%
Bank OZK CD 0.30%06/11/21 09/11/20 5,007,443 5,007,443 100.00 5,007,443 72 0.30%
Prosperity Bank CD 0.60%07/01/21 07/01/20 4,012,075 4,012,075 100.00 4,012,075 92 0.60%
Prosperity Bank CD 0.70%07/15/21 07/15/20 5,017,615 5,017,615 100.00 5,017,615 106 0.70%
Prosperity Bank CD 0.15%08/10/21 02/10/21 3,000,345 3,000,345 100.00 3,000,345 132 0.15%
Prosperity Bank CD 0.40%08/23/21 08/21/20 6,257,488 6,257,488 100.00 6,257,488 145 0.40%
R Bank CD 0.47%08/25/21 02/25/21 2,000,000 2,000,000 100.00 2,000,000 147 0.47%
East West Bank CD 0.26%09/09/21 12/09/20 4,072,454 4,072,454 100.00 4,072,454 162 0.26%
East West Bank CD 0.21%10/08/21 01/08/21 5,002,388 5,002,388 100.00 5,002,388 191 0.21%
Prosperity Bank CD 0.30%10/14/21 10/14/20 2,503,100 2,503,100 100.00 2,503,100 197 0.30%
Independent Bank CD 0.40%10/18/21 10/18/20 2,549,159 2,549,159 100.00 2,549,159 201 0.40%
Prosperity Bank CD 0.30%11/22/21 11/20/20 3,002,957 3,002,957 100.00 3,002,957 236 0.30%
Texas Regional Bank CD 0.25%12/07/21 03/12/21 3,000,000 3,000,000 100.00 3,000,000 251 0.25%
East West Bank CD 0.21%12/30/21 12/30/20 3,001,588 3,001,588 100.00 3,001,588 274 0.21%
East West Bank CD 0.21%01/07/22 01/08/21 5,002,388 5,002,388 100.00 5,002,388 282 0.21%
Prosperity Bank CD 0.30%01/21/22 10/21/20 4,004,960 4,004,960 100.00 4,004,960 296 0.30%
Independent Bank CD 0.40%02/05/22 02/05/21 3,000,000 3,000,000 100.00 3,000,000 311 0.40%
Independent Bank CD 0.40%02/08/22 02/08/21 5,000,000 5,000,000 100.00 5,000,000 314 0.40%
R Bank CD 0.63%02/25/22 02/25/21 2,000,000 2,000,000 100.00 2,000,000 331 0.63%
Prosperity Bank CD 0.35%04/21/22 10/21/20 2,503,617 2,503,617 100.00 2,503,617 386 0.35%
Independent Bank CD 0.35%05/09/22 02/08/21 4,000,000 4,000,000 100.00 4,000,000 404 0.35%
March 31, 2021
City of Georgetown Valley View Consulting, L.L.C.24
City - Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
March 31, 2021
Prosperity Bank CD 0.35%05/17/22 11/17/20 2,002,300 2,002,300 100.00 2,002,300 412 0.35%
Prosperity Bank CD 0.35%08/22/22 11/20/20 2,502,875 2,502,875 100.00 2,502,875 509 0.35%
Prosperity Bank CD 0.40%11/17/22 11/17/20 2,002,629 2,002,629 100.00 2,002,629 596 0.40%
TOTALS 276,385,252$ 276,385,252$ 276,385,252$ 74 0.21%
(1)(2)
(2)Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not
considered. The yield for the reporting month is used for bank accounts, pools, and money market funds.
(1)Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity.
(3)Earnings Credit - The City's depository accounts provide an earnings credit on balances which is used to offset bank fees.
City of Georgetown Valley View Consulting, L.L.C.25
0–6 Months82%
6–12 Months14%
12–18 Months4%
Current Quarter Maturities
$0
$25,000,000
$50,000,000
$75,000,000
$100,000,000
$125,000,000
$150,000,000
$175,000,000
$200,000,000
$225,000,000
$250,000,000
$275,000,000
$300,000,000
06/30/20 09/30/20 12/31/2020 03/31/21
Portfolio Balances
Money Market
Local Depository
TexSTAR
TexPool
Certificate of Deposit
US Treasury
166174166
102
69
90
7375
109104
123
156163
97108
87
51
67
4941
91
73
6154
99
71
124
95100
8070676358
818274
0
50
100
150
200
# of DaysWeighted Average to Maturity
JPMorgan Chase6%Southside Bank 2%
Prosperity Bank15%
Veritex Bank 1%
Bank OZK6%
NexBank3%
TexPool21%
TexSTAR31%
IndependentBank7%
Texas Regional Bank1%
East West Bank6%
R Bank1%
Portfolio Holdings by Issuer
City of Georgetown Valley View Consulting, L.L.C.
26
City - Book & Market Value Comparison
Issuer/Description Yield Maturity
Date
Book Value
12/31/20 Increases Decreases Book Value
03/31/21
Market Value
12/31/20
Change in
Market Value
Market Value
03/31/21
JPMorgan Chase Cash 0.22%04/01/21 15,461,481$ 88,554$ –$ 15,550,035$ 15,461,481$ 88,554$ 15,550,035$
JPMorgan Chase MMA 0.03%04/01/21 434,016 32 – 434,048 434,016 32 434,048
Veritex Bank MMA 0.10%04/01/21 3,212,254 1,000 – 3,213,253 3,212,254 1,000 3,213,253
NexBank MMA 0.45%04/01/21 7,364,008 8,174 – 7,372,182 7,364,008 8,174 7,372,182
Origin Bank MMA 0.00%04/01/21 1,014,148 – (1,014,148) - 1,014,148 (1,014,148) -
TexPool 0.02%04/01/21 44,199,066 14,663,376 – 58,862,442 44,199,066 14,663,376 58,862,442
TexSTAR 0.02%04/01/21 64,620,967 20,611,904 – 85,232,871 64,620,967 20,611,904 85,232,871
East West Bank CD 1.72%01/08/21 3,050,882 – (3,050,882) – 3,050,882 (3,050,882) –
Independent Bank CD 1.71%02/05/21 3,139,621 – (3,139,621) – 3,139,621 (3,139,621) –
Independent Bank CD 0.60%02/08/21 11,033,296 – (11,033,296) – 11,033,296 (11,033,296) –
East West Bank CD 0.32%02/18/21 9,010,737 – (9,010,737) – 9,010,737 (9,010,737) –
East West Bank CD 0.32%02/18/21 2,002,386 – (2,002,386) – 2,002,386 (2,002,386) –
R Bank CD 1.83%02/19/21 4,054,719 – (4,054,719) – 4,054,719 (4,054,719) –
Bank OZK CD 1.73%02/26/21 6,086,273 – (6,086,273) – 6,086,273 (6,086,273) –
Southside Bank CD 0.21%03/11/21 5,002,618 – (5,002,618) – 5,002,618 (5,002,618) –
Bank OZK CD 0.25%03/11/21 1,500,935 – (1,500,935) – 1,500,935 (1,500,935) –
East West Bank CD 0.29%03/15/21 3,503,032 – (3,503,032) – 3,503,032 (3,503,032) –
Prosperity Bank CD 0.45%04/01/21 4,006,098 – –4,006,098 4,006,098 – 4,006,098
Independent Bank CD 1.81%04/22/21 4,174,339 18,899 – 4,193,238 4,174,339 18,899 4,193,238
Bank OZK CD 0.70%05/10/21 12,049,407 20,839 – 12,070,246 12,049,407 20,839 12,070,246
Southside Bank CD 0.22%06/11/21 5,002,742 2,714 – 5,005,456 5,002,742 2,714 5,005,456
Bank OZK CD 0.30%06/11/21 5,003,741 3,702 – 5,007,443 5,003,741 3,702 5,007,443
Prosperity Bank CD 0.60%07/01/21 4,006,033 6,042 – 4,012,075 4,006,033 6,042 4,012,075
Prosperity Bank CD 0.70%07/15/21 5,008,798 8,817 – 5,017,615 5,008,798 8,817 5,017,615
Prosperity Bank CD 0.15%08/10/21 – 3,000,345 – 3,000,345 – 3,000,345 3,000,345
Prosperity Bank CD 0.40%08/23/21 6,251,322 6,166 – 6,257,488 6,251,322 6,166 6,257,488
R Bank CD 0.47%08/25/21 – 2,000,000 – 2,000,000 – 2,000,000 2,000,000
East West Bank CD 0.26%09/09/21 4,069,844 2,610 – 4,072,454 4,069,844 2,610 4,072,454
East West Bank CD 0.21%10/08/21 – 5,002,388 – 5,002,388 – 5,002,388 5,002,388
Prosperity Bank CD 0.30%10/14/21 2,501,250 1,850 – 2,503,100 2,501,250 1,850 2,503,100
Independent Bank CD 0.40%10/18/21 2,546,598 2,561 – 2,549,159 2,546,598 2,561 2,549,159
Prosperity Bank CD 0.30%11/22/21 3,000,738 2,219 – 3,002,957 3,000,738 2,219 3,002,957
Texas Regional Bank CD 0.25%12/07/21 – 3,000,000 – 3,000,000 – 3,000,000 3,000,000
East West Bank CD 0.21%12/30/21 3,000,035 1,554 – 3,001,588 3,000,035 1,554 3,001,588
East West Bank CD 0.21%01/07/22 – 5,002,388 – 5,002,388 – 5,002,388 5,002,388
Prosperity Bank CD 0.30%01/21/22 4,002,000 2,960 – 4,004,960 4,002,000 2,960 4,004,960
Independent Bank CD 0.40%02/05/22 – 3,000,000 – 3,000,000 – 3,000,000 3,000,000
Independent Bank CD 0.40%02/08/22 – 5,000,000 – 5,000,000 – 5,000,000 5,000,000
R Bank CD 0.63%02/25/22 – 2,000,000 – 2,000,000 – 2,000,000 2,000,000
City of Georgetown Valley View Consulting, L.L.C.27
City - Book & Market Value Comparison
Issuer/Description Yield Maturity
Date
Book Value
12/31/20 Increases Decreases Book Value
03/31/21
Market Value
12/31/20
Change in
Market Value
Market Value
03/31/21
Prosperity Bank CD 0.35%04/21/22 2,501,459 2,159 – 2,503,617 2,501,459 2,159 2,503,617
Independent Bank CD 0.35%05/09/22 – 4,000,000 – 4,000,000 – 4,000,000 4,000,000
Prosperity Bank CD 0.35%05/17/22 2,000,574 1,726 – 2,002,300 2,000,574 1,726 2,002,300
Prosperity Bank CD 0.35%08/22/22 2,500,717 2,158 – 2,502,875 2,500,717 2,158 2,502,875
Prosperity Bank CD 0.40%11/17/22 2,000,656 1,973 – 2,002,629 2,000,656 1,973 2,002,629
TOTAL / AVERAGE 0.21%258,316,790$ 67,467,110$ (49,398,649)$ 276,385,252$ 258,316,790$ 18,068,462$ 276,385,252$
City of Georgetown Valley View Consulting, L.L.C.28
City - Allocation
Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
JPMorgan Chase Cash 15,550,035$ 15,550,035$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,048 434,048 – – – – –
Veritex Bank MMA 3,213,253 3,213,253 – – – – –
NexBank MMA 7,372,182 7,372,182 – – – – –
TexPool 58,862,442 58,862,442 – – – – –
TexSTAR 85,232,871 20,153,413 584,286 17,544,854 137,307 93,010 2,508,839
Prosperity Bank CD 04/01/21 4,006,098 4,006,098 – – – – –
Independent Bank CD 04/22/21 4,193,238 4,193,238 – – – – –
Bank OZK CD 05/10/21 12,070,246 10,058,538 – – – – –
Southside Bank CD 06/11/21 5,005,456 5,005,456 – – – – –
Bank OZK CD 06/11/21 5,007,443 5,007,443 – – – – –
Prosperity Bank CD 07/01/21 4,012,075 4,012,075 – – – – –
Prosperity Bank CD 07/15/21 5,017,615 5,017,615 – – – – – Prosperity Bank CD 08/10/21 3,000,345 – – – – – –
Prosperity Bank CD 08/23/21 6,257,488 6,257,488 – – – – –
R Bank CD 08/25/21 2,000,000 – – – – – –
East West Bank CD 09/09/21 4,072,454 4,072,454 – – – – –
East West Bank CD 10/08/21 5,002,388 5,002,388 – – – – –
Prosperity Bank CD 10/14/21 2,503,100 2,503,100 – – – – –
Independent Bank CD 10/18/21 2,549,159 2,549,159 – – – – –
Prosperity Bank CD 11/22/21 3,002,957 3,002,957 – – – – – Texas Regional Bank CD 12/07/21 3,000,000 – – – – – –
East West Bank CD 12/30/21 3,001,588 3,001,588 – – – – –
East West Bank CD 01/07/22 5,002,388 5,002,388 – – – – –
Prosperity Bank CD 01/21/22 4,004,960 4,004,960 – – – – –
Independent Bank CD 02/05/22 3,000,000 3,000,000 – – – – –
Independent Bank CD 02/08/22 5,000,000 4,000,000 – – – – –
R Bank CD 02/25/22 2,000,000 – – – – – –
Prosperity Bank CD 04/21/22 2,503,617 2,503,617 – – – – – Independent Bank CD 05/17/22 4,000,000 4,000,000 – – – – –
Prosperity Bank CD 05/17/22 2,002,300 2,002,300 – – – – –
Prosperity Bank CD 08/22/22 2,502,875 2,502,875 – – – – –
Prosperity Bank CD 11/17/22 2,002,629 2,002,629 – – – – –
Totals 276,385,252$ 198,293,742$ 584,286$ 17,544,854$ 137,307$ 93,010$ 2,508,839$
Book Value
March 31, 2021
City of Georgetown Valley View Consulting, L.L.C.29
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
Book Value
March 31, 2021
(Continued)
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 Revenue
Electric
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,841 68,606 1,429,234 1,420,244 246,565 178,450 97,383
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,841$ 68,606$ 1,429,234$ 1,420,244$ 246,565$ 178,450$ 97,383$
City of Georgetown Valley View Consulting, L.L.C.30
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
Book Value
March 31, 2021
(Continued)
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,746,916 56,700 672,317 445,286 6,628,059 4,686,290 87,973
– – – – – – –
– – – – – – –
2,011,708 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,000,345 – – – – – –
– – – – – – –
– – – – – 2,000,000 –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
11,758,969$ 56,700$ 672,317$ 445,286$ 6,628,059$ 6,686,290$ 87,973$
City of Georgetown Valley View Consulting, L.L.C.31
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
Book Value
March 31, 2021
(Continued)
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,247,736 1,910,744 650,627 8,547,474 486,572 6,675,600 4,396,545
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,247,736$ 1,910,744$ 650,627$ 8,547,474$ 486,572$ 6,675,600$ 4,396,545$
City of Georgetown Valley View Consulting, L.L.C.32
City - Allocation
March 31, 2021
Market Value Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
JPMorgan Chase Cash 15,550,035$ 15,550,035$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,048 434,048 – – – – –
Veritex Bank MMA 3,213,253 3,213,253 – – – – –
NexBank MMA 7,372,182 7,372,182 – – – – –
TexPool 58,862,442 58,862,442 – – – – –
TexSTAR 85,232,871 20,153,413 584,286 17,544,854 137,307 93,010 2,508,839
Prosperity Bank CD 04/01/21 4,006,098 4,006,098 – – – – –
Independent Bank CD 04/22/21 4,193,238 4,193,238 – – – – –
Bank OZK CD 05/10/21 12,070,246 10,058,538 – – – – –
Southside Bank CD 06/11/21 5,005,456 5,005,456 – – – – –
Bank OZK CD 06/11/21 5,007,443 5,007,443 – – – – –
Prosperity Bank CD 07/01/21 4,012,075 4,012,075 – – – – –
Prosperity Bank CD 07/15/21 5,017,615 5,017,615 – – – – –
Prosperity Bank CD 08/10/21 3,000,345 – – – – – –
Prosperity Bank CD 08/23/21 6,257,488 6,257,488 – – – – –
R Bank CD 08/25/21 2,000,000 – – – – – –
East West Bank CD 09/09/21 4,072,454 4,072,454 – – – – –
East West Bank CD 10/08/21 5,002,388 5,002,388 – – – – –
Prosperity Bank CD 10/14/21 2,503,100 2,503,100 – – – – –
Independent Bank CD 10/18/21 2,549,159 2,549,159 – – – – –
Prosperity Bank CD 11/22/21 3,002,957 3,002,957 – – – – –
Texas Regional Bank CD 12/07/21 3,000,000 – – – – – –
East West Bank CD 12/30/21 3,001,588 3,001,588 – – – – –
East West Bank CD 01/07/22 5,002,388 5,002,388 – – – – –
Prosperity Bank CD 01/21/22 4,004,960 4,004,960 – – – – –
Independent Bank CD 02/05/22 3,000,000 3,000,000 – – – – –
Independent Bank CD 02/08/22 5,000,000 4,000,000 – – – – –
R Bank CD 02/25/22 2,000,000 – – – – – –
Prosperity Bank CD 04/21/22 2,503,617 2,503,617 – – – – –
Independent Bank CD 05/17/22 4,000,000 4,000,000 – – – – –
Prosperity Bank CD 05/17/22 2,002,300 2,002,300 – – – – –
Prosperity Bank CD 08/22/22 2,502,875 2,502,875 – – – – –
Prosperity Bank CD 11/17/22 2,002,629 2,002,629 – – – – –
Totals 276,385,252$ 198,293,742$ 584,286$ 17,544,854$ 137,307$ 93,010$ 2,508,839$
City of Georgetown Valley View Consulting, L.L.C.33
City - Allocation
March 31, 2021
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 Revenue
Electric
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,841 68,606 1,429,234 1,420,244 246,565 178,450 97,383
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,841$ 68,606$ 1,429,234$ 1,420,244$ 246,565$ 178,450$ 97,383$
City of Georgetown Valley View Consulting, L.L.C.34
City - Allocation
March 31, 2021
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,746,916 56,700 672,317 445,286 6,628,059 4,686,290 87,973
– – – – – – –
– – – – – – –
2,011,708 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,000,345 – – – – – –
– – – – – – –
– – – – – 2,000,000 –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
11,758,969$ 56,700$ 672,317$ 445,286$ 6,628,059$ 6,686,290$ 87,973$
City of Georgetown Valley View Consulting, L.L.C.35
City - Allocation
March 31, 2021
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,247,736 1,910,744 650,627 8,547,474 486,572 6,675,600 4,396,545
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,247,736$ 1,910,744$ 650,627$ 8,547,474$ 486,572$ 6,675,600$ 4,396,545$
City of Georgetown Valley View Consulting, L.L.C.36
City - Allocation
Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
JPMorgan Chase Cash 15,461,481$ 15,461,481$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,016 434,016 – – – – –
Veritex Bank MMA 3,212,254 3,212,254 – – – – –
NexBank MMA 7,364,008 7,364,008 – – – – –
Origin Bank MMA 1,014,148 – – – – – –
TexPool 44,199,066 44,199,066 – – – – –
TexSTAR 64,620,967 8,950,006 584,231 3,875,899 137,294 93,001 2,508,604
East West Bank CD 01/08/21 3,050,882 3,050,882 – – – – –
Independent Bank CD 02/05/21 3,139,621 3,139,621 – – – – –
Independent Bank CD 02/08/21 11,033,296 8,024,216 – – – – –
East West Bank CD 02/18/21 9,010,737 3,003,579 – – – – –
East West Bank CD 02/18/21 2,002,386 – – – – – –
R Bank CD 02/19/21 4,054,719 4,054,719 – – – – – Bank OZK CD 02/26/21 6,086,273 6,086,273 – – – – –
Southside Bank CD 03/11/21 5,002,618 5,002,618 – – – – –
Bank OZK CD 03/11/21 1,500,935 1,500,935 – – – – –
East West Bank CD 03/15/21 3,503,032 3,503,032 – – – – –
Prosperity Bank CD 04/01/21 4,006,098 4,006,098 – – – – –
Independent Bank CD 04/22/21 4,174,339 4,174,339 – – – – –
Bank OZK CD 05/10/21 12,049,407 10,041,172 – – – – –
Southside Bank CD 06/11/21 5,002,742 5,002,742 – – – – – Bank OZK CD 06/11/21 5,003,741 5,003,741 – – – – –
Prosperity Bank CD 07/01/21 4,006,033 4,006,033 – – – – –
Prosperity Bank CD 07/15/21 5,008,798 5,008,798 – – – – –
Prosperity Bank CD 08/23/21 6,251,322 6,251,322 – – – – –
East West Bank CD 09/09/21 4,069,844 4,069,844 – – – – –
Prosperity Bank CD 10/14/21 2,501,250 2,501,250 – – – – –
Independent Bank CD 10/18/21 2,546,598 2,546,598 – – – – –
Prosperity Bank CD 11/22/21 3,000,738 3,000,738 – – – – – East West Bank CD 12/30/21 3,000,035 3,000,035 – – – – –
Prosperity Bank CD 01/21/22 4,002,000 4,002,000 – – – – –
Prosperity Bank CD 04/21/22 2,501,459 2,501,459 – – – – –
Prosperity Bank CD 05/17/22 2,000,574 2,000,574 – – – – –
Prosperity Bank CD 08/22/22 2,500,717 2,500,717 – – – – –
Prosperity Bank CD 11/17/22 2,000,656 2,000,656 – – – – –
Totals 258,316,790$ 188,604,822$ 584,231$ 3,875,899$ 137,294$ 93,001$ 2,508,604$
December 31, 2020
Book Value
City of Georgetown Valley View Consulting, L.L.C.37
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/23/21
East West Bank CD 09/09/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
East West Bank CD 12/30/21
Prosperity Bank CD 01/21/22
Prosperity Bank CD 04/21/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
December 31, 2020
Book Value
(Continued)
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 Revenue
Electric
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698 68,600 1,429,101 1,456,708 254,936 178,433 97,374
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698$ 68,600$ 1,429,101$ 1,456,708$ 254,936$ 178,433$ 97,374$
City of Georgetown Valley View Consulting, L.L.C.38
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/23/21
East West Bank CD 09/09/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
East West Bank CD 12/30/21
Prosperity Bank CD 01/21/22
Prosperity Bank CD 04/21/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
December 31, 2020
Book Value
(Continued)
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
1,014,148 – – – – – –
– – – – – – –
3,241,881 56,694 672,254 482,661 9,137,064 3,936,963 113,952
– – – – – – –
– – – – – – –
3,009,081 – – – – – –
3,003,579 – – – – 3,003,579 –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,008,234 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
12,276,924$ 56,694$ 672,254$ 482,661$ 9,137,064$ 6,940,543$ 113,952$
City of Georgetown Valley View Consulting, L.L.C.39
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/23/21
East West Bank CD 09/09/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
East West Bank CD 12/30/21
Prosperity Bank CD 01/21/22
Prosperity Bank CD 04/21/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
December 31, 2020
Book Value
(Continued)
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,961,455 2,602,887 650,566 8,708,689 1,241,086 7,169,062 3,479,865
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,002,386 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,963,841$ 2,602,887$ 650,566$ 8,708,689$ 1,241,086$ 7,169,062$ 3,479,865$
City of Georgetown Valley View Consulting, L.L.C.40
City - Allocation
December 31, 2020
Market Value Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
JPMorgan Chase Cash 15,461,481$ 15,461,481$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,016 434,016 – – – – –
Veritex Bank MMA 3,212,254 3,212,254 – – – – –
NexBank MMA 7,364,008 7,364,008 – – – – –
Origin Bank MMA 1,014,148 – – – – – –
TexPool 44,199,066 44,199,066 – – – – –
TexSTAR 64,620,967 8,950,006 584,231 3,875,899 137,294 93,001 2,508,604
East West Bank CD 01/08/21 3,050,882 3,050,882 – – – – –
Independent Bank CD 02/05/21 3,139,621 3,139,621 – – – – –
Independent Bank CD 02/08/21 11,033,296 8,024,216 – – – – –
East West Bank CD 02/18/21 9,010,737 3,003,579 – – – – –
East West Bank CD 02/18/21 2,002,386 – – – – – –
R Bank CD 02/19/21 4,054,719 4,054,719 – – – – –
Bank OZK CD 02/26/21 6,086,273 6,086,273 – – – – –
Southside Bank CD 03/11/21 5,002,618 5,002,618 – – – – –
Bank OZK CD 03/11/21 1,500,935 1,500,935 – – – – –
East West Bank CD 03/15/21 3,503,032 3,503,032 – – – – –
Prosperity Bank CD 04/01/21 4,006,098 4,006,098 – – – – –
Independent Bank CD 04/22/21 4,174,339 4,174,339 – – – – –
Bank OZK CD 05/10/21 12,049,407 10,041,172 – – – – –
Southside Bank CD 06/11/21 5,002,742 5,002,742 – – – – –
Bank OZK CD 06/11/21 5,003,741 5,003,741 – – – – –
Prosperity Bank CD 07/01/21 4,006,033 4,006,033 – – – – –
Prosperity Bank CD 07/15/21 5,008,798 5,008,798 – – – – –
Prosperity Bank CD 08/23/21 6,251,322 6,251,322 – – – – –
East West Bank CD 09/09/21 4,069,844 4,069,844 – – – – –
Prosperity Bank CD 10/14/21 2,501,250 2,501,250 – – – – –
Independent Bank CD 10/18/21 2,546,598 2,546,598 – – – – –
Prosperity Bank CD 11/22/21 3,000,738 3,000,738 – – – – –
East West Bank CD 12/30/21 3,000,035 3,000,035 – – – – –
Prosperity Bank CD 01/21/22 4,002,000 4,002,000 – – – – –
Prosperity Bank CD 04/21/22 2,501,459 2,501,459 – – – – –
Prosperity Bank CD 05/17/22 2,000,574 2,000,574 – – – – –
Prosperity Bank CD 08/22/22 2,500,717 2,500,717 – – – – –
Prosperity Bank CD 11/17/22 2,000,656 2,000,656 – – – – –
Totals 258,316,790$ 188,604,822$ 584,231$ 3,875,899$ 137,294$ 93,001$ 2,508,604$
City of Georgetown Valley View Consulting, L.L.C.41
City - Allocation
December 31, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/23/21
East West Bank CD 09/09/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
East West Bank CD 12/30/21
Prosperity Bank CD 01/21/22
Prosperity Bank CD 04/21/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 Revenue
Electric
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698 68,600 1,429,101 1,456,708 254,936 178,433 97,374
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698$ 68,600$ 1,429,101$ 1,456,708$ 254,936$ 178,433$ 97,374$
City of Georgetown Valley View Consulting, L.L.C.42
City - Allocation
December 31, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/23/21
East West Bank CD 09/09/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
East West Bank CD 12/30/21
Prosperity Bank CD 01/21/22
Prosperity Bank CD 04/21/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
1,014,148 – – – – – –
– – – – – – –
3,241,881 56,694 672,254 482,661 9,137,064 3,936,963 113,952
– – – – – – –
– – – – – – –
3,009,081 – – – – – –
3,003,579 – – – – 3,003,579 –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,008,234 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
12,276,924$ 56,694$ 672,254$ 482,661$ 9,137,064$ 6,940,543$ 113,952$
City of Georgetown Valley View Consulting, L.L.C.43
City - Allocation
December 31, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/23/21
East West Bank CD 09/09/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
East West Bank CD 12/30/21
Prosperity Bank CD 01/21/22
Prosperity Bank CD 04/21/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,961,455 2,602,887 650,566 8,708,689 1,241,086 7,169,062 3,479,865
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,002,386 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,963,841$ 2,602,887$ 650,566$ 8,708,689$ 1,241,086$ 7,169,062$ 3,479,865$
City of Georgetown Valley View Consulting, L.L.C.44
________________________________________________________________________
Leigh Wallace Nathan Parras
Finance Director Assistant Finance Director
________________________________________________________________________
Karrie Pursley Elaine Wilson
Treasurer Assistant Finance Director
Georgetown Economic Development Corporation (GEDCO)
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
March 31, 2021
Prepared by
Valley View Consulting, L.L.C.
The investment portfolio of the Georgetown Economic Development Corporation (GEDCO) is in compliance with
the Texas Public Funds Investment Act and the Investment Policy and Strategies.
Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or
completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from
sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective of
current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total return
yields and do not account for investment advisor fees.
45
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
MMA 2,129,948$ 2,129,948$ 2,130,611$ 2,130,611$ 0.10%
Pools 6,006,030 6,006,030 6,964,887 6,964,887 0.03%
Certificates of Deposit 2,025,562 2,025,562 2,000,000 2,000,000 0.24%
10,161,540$ 10,161,540$ 11,095,498$ 11,095,498$ 0.08%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.08%Total Portfolio 0.25%
Rolling Three Month Treasury 0.06%Rolling Three Month Treasury 0.08%
Rolling Six Month Treasury 0.09%Rolling Six Month Treasury 0.10%
TexPool 0.02%TexPool 0.05%
Interest income provided in separate report.
December 31, 2020
(1)Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not
considered. The yield for the reporting month is used for bank, pool, and money market balances.
(2)Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return
analysis or account for advisory fees.
March 31, 2021
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.46
Economic Overview3/31/2021The Federal Open Market Committee (FOMC) maintained the Fed Funds target range at 0.00% to 0.25% (Effective Fed Funds are trading <0.10%), and projected that reduced rates could remain into 2023 or longer. Fourth Quarter GDP finalized at +4.3%. March Non Farm Payroll added 916k and Unemployment declined to 6.0%. Crude oil traded above $60 per barrel. The Stock Markets reached new highs. Housing, Industrial Production, Durable Goods, Consumer Spending, and other indicators showed solid gains. An additional $1.9 trillion stimulus package passed Congress and was signed by the President. The Yield Curve continued steepening on longer maturities.02505007501,0001,2501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,0004,250S&P 5000.000.501.001.502.002.503.003.50US Treasury Historical Yields - Since Nov 2015Six Month T-BillTwo Year T-NoteTen Year T-Note0.000.200.400.600.801.001.201.401.601.802.00Treasury Yield CurvesMarch 31, 2020December 31, 2020March 31, 20210.000.501.001.502.002.503.003.504.004.505.005.506.00US Treasury Historical Yields - Since 2006Six Month T-BillTwo Year T-NoteTen Year T-NoteValley View Consulting, L.L.C.47
Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
Veritex Bank MMA 0.10%04/01/21 03/31/21 2,130,611$ 2,130,611$ 1.00 2,130,611$ 1 0.10%
TexasDAILY AAAm 0.05%04/01/21 03/31/21 2,125,613 2,125,613 1.00 2,125,613 1 0.05%
TexSTAR AAAm 0.02%04/01/21 03/31/21 4,839,274 4,839,274 1.00 4,839,274 1 0.02%
Veritex Bank CD 0.24%08/05/22 02/08/21 2,000,000 2,000,000 100.00 2,000,000 492 0.24%
11,095,498$ 11,095,498$ 11,095,498$ 90 0.08%
(1)(2)
March 31, 2021
(1)Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity.
(2)Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees
are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds.
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.48
MMA 19%
Pools 63%
Certificates of Deposit 18%
GEDCO PORTFOLIO COMPOSITION
$0
$2,000,000
$4,000,000
$6,000,000
$8,000,000
$10,000,000
$12,000,000
06/30/20 09/30/20 12/31/20 3/31/2021
GEDCO PORTFOLIO BALANCES
CD
TexasDAILY
TexSTAR
Money Market
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.49
Book & Market Value Comparison
Issuer/Description Yield Maturity
Date
Book Value
12/31/20 Increases Decreases Book Value
03/31/21
Market Value
12/31/20
Change in
Market Value
Market Value
03/31/21
Veritex Bank MMA 0.10%04/01/21 2,129,948$ 663$ –$ 2,130,611$ 2,129,948$ 663$ 2,130,611$
TexasDAILY 0.05%04/01/21 2,125,306 306 – 2,125,613 2,125,306 306 2,125,613
TexSTAR 0.02%04/01/21 3,880,724 958,551 – 4,839,274 3,880,724 958,551 4,839,274
Independent Bank CD 1.71%02/05/21 2,025,562 – (2,025,562) – 2,025,562 (2,025,562) –
Veritex Bank CD 0.24%08/05/22 – 2,000,000 – 2,000,000 – 2,000,000 2,000,000
TOTAL / AVERAGE 0.08%10,161,540$ 2,959,520$ (2,025,562)$ 11,095,498$ 10,161,540$ 933,958$ 11,095,498$
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.50
Georgetown Transportation Enhancement Corporation (GTEC)
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
March 31, 2021
Prepared byValley View Consulting, L.L.C.
________________________________________________________________________
Leigh Wallace Nathan Parras
Finance Director Assistant Finance Director
________________________________________________________________________
Karrie Pursley Elaine Wilson
Treasurer
The investment portfolio of the Georgetown Transportation Enhancement Corporation (GTEC) is in compliance
with the Texas Public Funds Investment Act and the Investment Policy and Strategies.
Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or
completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from
sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective
of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total
return yields and do not account for investment advisor fees.
51
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Pools/MMAs 28,689,653$ 28,689,653$ 30,076,153$ 30,076,153$ 0.03%
CDs/Securities 3,004,002 3,004,002 3,006,965 3,006,965 0.40%Totals 31,693,655$ 31,693,655$ 33,083,118$ 33,083,118$ 0.06%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.06%Total Portfolio 0.09%
Rolling Three Month Treasury 0.06%Rolling Three Month Treasury 0.08%
Rolling Six Month Treasury 0.09%Rolling Six Month Treasury 0.10%
TexPool 0.02%TexPool 0.05%
Interest data provided in separate report.
December 31, 2020
(1) Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not
considered. The yield for the reporting month is used for bank, pool, and money market balances.
(2) Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total
return analysis or account for advisory fees.
March 31, 2021
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.52
Economic Overview3/31/2021 The Federal Open Market Committee (FOMC) maintained the Fed Funds target range at 0.00% to 0.25% (Effective Fed Funds are trading <0.10%), and projected that reduced rates could remain into 2023 or longer. Fourth Quarter GDP finalized at +4.3%. March Non Farm Payroll added 916k and Unemployment declined to 6.0%. Crude oil traded above $60 per barrel. The Stock Markets reached new highs. Housing, Industrial Production, Durable Goods, Consumer Spending, and other indicators showed solid gains. An additional $1.9 trillion stimulus package passed Congress and was signed by the President. The Yield Curve continued steepening on longer maturities.02505007501,0001,2501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,0004,250S&P 5000.000.501.001.502.002.503.003.50US Treasury Historical Yields - Since Nov 2015Six Month T-BillTwo Year T-NoteTen Year T-Note0.000.200.400.600.801.001.201.401.601.802.00Treasury Yield CurvesMarch 31, 2020December 31, 2020March 31, 20210.000.501.001.502.002.503.003.504.004.505.005.506.00US Treasury Historical Yields - Since 2006Six Month T-BillTwo Year T-NoteTen Year T-NoteValley View Consulting, L.L.C.53
Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
TexPool AAAm 0.02%04/01/21 03/31/21 15,639,313$ 15,639,313$ 1.00 15,639,313$ 1 0.02%
TexSTAR AAAm 0.02%04/01/21 03/31/21 11,748,398 11,748,398 1.00 11,748,398 1 0.02%
Veritex Bank MMA 0.10%04/01/21 03/31/21 2,688,441 2,688,441 1.00 2,688,441 1 0.10%
Prosperity Bank CD 0.40%08/23/21 08/21/20 3,006,965 3,006,965 100.00 3,006,965 145 0.40%
TOTALS 33,083,118$ 33,083,118$ 33,083,118$ 14 0.06%
(1)(2)
March 31, 2021
(1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity.
(2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not
considered. The yield for the reporting month is used for bank accounts, pools, and money market funds.
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.54
Pools/MMAs 91%
CDs/Securities 9%
GTEC PORTFOLIO COMPOSITION
$0
$5,000,000
$10,000,000
$15,000,000
$20,000,000
$25,000,000
$30,000,000
$35,000,000
6/30/2021 9/30/2021 12/31/2021 3/31/2021
GTEC PORTFOLIO BALANCES
CD
TexPool
TexSTAR
Money Market
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.55
Book & Market Value Comparison
Issuer/Description Yield Maturity
Date
Book Value
12/31/20 Increases Decreases Book Value
03/31/21
Market Value
12/31/20
Change in
Market Value
Market Value
03/31/21
TexPool 0.02%04/01/21 13,146,323$ 2,492,991$ –$ 15,639,313$ 13,146,323$ 2,492,991$ 15,639,313$
TexSTAR 0.02%04/01/21 12,855,726 – (1,107,328) 11,748,398 12,855,726 (1,107,328) 11,748,398
Veritex Bank MMA 0.10%04/01/21 2,687,605 837 – 2,688,441 2,687,605 837 2,688,441
Prosperity Bank CD 0.40%08/23/21 3,004,002 2,963 – 3,006,965 3,004,002 2,963 3,006,965
TOTAL / AVERAGE 0.06%31,693,655$ 2,496,790$ (1,107,328)$ 33,083,118$ 31,693,655$ 1,389,462$ 33,083,118$
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.56
Department Federal Grantor Pass-Through Agency Identifying Number COG Name/Purpose YTD Expenditures YTD Revenue Recognized
Airport N/A Texas Department of
Transportation-Aviation
M1914GEOR RAMP Grant - Routine Airport
Maintenance Program
1,119.55
Airport FEMA Texas Department of
Transportation - Aviation
Airport CARES Funding 156,980.34 156,980.34
Emergency Management FEMA Williamson County WILCO Forward - CARES
Funding for COVID-19
14,814.52 14,814.52
Fire Department of Health & Human Services CMS (Centers for Medicare &
Medicaid Services)
EMS CARES Round 1 - -
Fire US Department of Homeland Security Federal Emergency
Management Agency
EMW-2017-FH-00496 SAFER 543,247.52 372,220.59
Library National Endowment for the Arts National Endowment for the
Arts
COVID Relief Funding 9,014.11 -
Library Texas Commission on the Arts Touring Artist Fund Grant 4,200.00
Planning US Department of Housing & Urban Development Williamson County CDBG Home Repair 43,059.77 40,920.32
Police US. Department of Justice N/A TX2460200 Equitable Sharing Agreement 5,176.77 -
Police US. Department of Treasury N/A TX2460200 Equitable Sharing Agreement 20,346.75 -
Public Works Dept. of Transportation /Federal Highway
Administration
Texas Department of
Transportation
CSJ-0914-05-187 Highway Planning &
Construction (Austin Ave
Bridge)
2,776.55 -
Public Works Dept. of Transportation /Federal Highway
Administration
Texas Department of
Transportation
CSJ-0914-05-200,201,202 Highway Planning &
Construction (Williams Dr
Corridor)
- -
Reviewed By: Elaine Wilson
CITY OF GEORGETOWN
Grant/Federal Funding Report
as of March 31, 2021
Active
57
Capital Improvement Projects Life to Tade Budget vs SpendRow LabelsTotal Budget Total Spend Remaining Budget Percent RemainingAirportAirport - Self ManagedPRJ000197 Hangar Mainenance240,000 - 240,000 100%PRJ000198 Pavement Maintenance 60,000 - 60,000 100%PRJ000199 Wildlife Management150,000 - 150,000 100%Airport - Self Managed Total450,000 - 450,000 300%Management ServicesPRJ000184 Airport Maintenance Facility750,000 - 750,000 100%Management Services Total750,000 - 750,000 100%Airport Total1,200,000 - 1,200,000 400%CDBGCDBGPRJ000003 17th Street193,000 175,137 17,863 9%PRJ000144 Maple Street (Inactive)80,784 - 80,784 100%CDBG Total273,784 175,137 98,647 109%CDBG Total273,784 175,137 98,647 109%Downtown TIRZParksPRJ000050 Grace Heritage Plaza139,100 45,900 93,200 67%Parks Total139,100 45,900 93,200 67%Downtown TIRZ Total139,100 45,900 93,200 67%ElectricElectricPRJ000022 Consultant Engineering 271,352 71,352 200,000 74%PRJ000026 Db Wood_Sh29 Intersection 240,000 172,024 67,976 28%PRJ000036 Electrical System Improvement100,000 57 99,943 100%PRJ000040 Fiber Optic50,000 19,516 30,484 61%PRJ000062 New Development Projects 5,019,335 5,334,015 (314,680) -6%PRJ000073 Power Quality Improvements 50,000 - 50,000 100%PRJ000095 Shell Road Feeders160,000 181,824 (21,824) -14%PRJ000147 Sectionalization Improvements 100,000 - 100,000 100%PRJ000175 I-35 Mobility Project TxDot200,000 183,627 16,373 8%PRJ000189 Ronald Reagan - Glasscock Feeder Extension along Hwy 195 -Phase I560,000 39,310 520,690 93%PRJ000192 Ronald Reagan - Glasscock Feeder extension along Hwy 195 - Phase II591,250 133,847 457,403 77%PRJ000195 Downtown Overhead Rehab2,400,000 - 2,400,000 100%PRJ000221 Titan-Aviation Dr to IH35 Infrastructure Addition1,000,000 67,349 932,651 93%PRJ000225 Chapel Hill, WS-11139 (GEO-45-C.3)437,577 345,842 91,735 21%PRJ000226 Wolf Ranch West - Section 1AG & 1BG479,052 33,405 445,647 93%PRJ000227 Ascend Westinghouse Apartments444,598 29,165 415,432 93%PRJ000229 Sun City NH 76 WS-11188 (GEO-18.2-N.51)274,030 103,520 170,510 62%PRJ000230 Sun City NH 78296,400 111,101 185,299 63%PRJ000231 Georgetown Titan Development 1 & 2140,428 - 140,428 100%PRJ000232 Texas Outdoor Power Building 191,414 - 91,414 100%PRJ000234 Summit at Westinghouse Self-Storage49,685 - 49,685 100%58
Row LabelsTotal Budget Total Spend Remaining Budget Percent RemainingPRJ000236 Medcore (Georgetown) Senior Living226,972 20,134 206,837 91%PRJ000238 The Oscar at Georgetown366,351 - 366,351 100%PRJ000239 Wolf Ranch West - Section 3 - Phase 2418,339 - 418,339 100%Electric Total13,966,782 6,846,089 7,120,693 1738%Electric Total13,966,782 6,846,089 7,120,693 1738%GCPEnvironmental ServicesPRJ000116 Transfer Station11,000,000 947,801 10,052,199 91%Environmental Services Total11,000,000 947,801 10,052,199 91%FinancePRJ000038 ERP Project6,231,654 5,898,066 333,588 5%Finance Total6,231,654 5,898,066 333,588 5%FirePRJ000134 SCBA Replacement870,000 - 870,000 100%PRJ000135 Cardiac Monitors483,517 483,517 - 0%Fire Total1,353,517 483,517 870,000 100%FleetPRJ000124 Radio Replacement363,278 - 363,278 100%Fleet Total363,278 - 363,278 100%GTEC DepartmentPRJ000203 FM1460 Widening948,982 48,982 900,000 95%PRJ000206 NB Front Rd (2338 To Lakeway)216,000 221,766 (5,766) -3%GTEC Department Total1,164,982 270,748 894,234 92%Management ServicesPRJ000028 Downtown Parking Expansion728,510 701,947 26,564 4%PRJ000029 Downtown Parking Garage411,815 411,815 - 0%PRJ000033 Dtwn Landsping & Public Art90,000 56,706 33,294 37%PRJ000037 EOC Siren System15,525 15,525 - 0%PRJ000042 Fire Station 65,500,000 5,330,405 169,595 3%PRJ000043 Fire Station 78,550,000 6,457,667 2,092,333 24%PRJ000067 Parking Improvements68,510 - 68,510 100%PRJ000131 Fuel Station1,100,000 - 1,100,000 100%PRJ000136 GMC Remodel Phase I250,000 30,614 219,386 88%PRJ000178 Public Safety Operation and Training Center Phase II4,500,000 - 4,500,000 100%PRJ000179 Recreation Center Teen/Senior Renovation200,000 - 200,000 100%PRJ000180 Recreation Center Natatorium HVAC Replacement700,000 656,176 43,824 6%PRJ000191 Georgetown City Center - Festival/Public Space5,400,000 14,099 5,385,901 100%PRJ000223 City Center Signage125,000 - 125,000 100%Management Services Total27,639,360 13,674,954 13,964,406 762%59
Row LabelsTotal Budget Total Spend Remaining Budget Percent RemainingParksPRJ000048 Garey Park15,346,730 15,100,250 246,480 2%PRJ000089 San Gabriel Park Improvement 13,025,000 7,448,252 5,576,748 43%PRJ000125 Parks Master Plan229,998 229,998 - 0%PRJ000126 Regional Trail Development 1,550,000 138,100 1,411,900 91%PRJ000127 Neighborhood Park Development 1,250,000 240,541 1,009,459 81%PRJ000129 Ada Transition Plan1,075,982 276,682 799,300 74%PRJ000130 Tennis Center Pool Demo 40,002 39,076 926 2%PRJ000190 Heritage Gardens274,934 81,400 193,534 70%PRJ000205 Katy Crossing Trail700,000 500,181 199,819 29%Parks Total33,492,646 24,054,481 9,438,165 392%PolicePRJ000133 Body Cameras800,000 737,412 62,588 8%Police Total800,000 737,412 62,588 8%Public Works - Self Managed DepartmentPRJ000204 Historic District Street Signs 26,000 - 26,000 100%Public Works - Self Managed Department Total 26,000 - 26,000 100%Public Works DepartmentPRJ000013 Austin Avenue Bridge 2,855,398 1,711,629 1,143,769 40%PRJ000137 Intersection Improvements (Lakeway @ Williams Drive) 1,400,000 252,450 1,147,550 82%PRJ000138 Downtown Sidewalks2,000,000 470,719 1,529,281 76%PRJ000139 Westinghouse - Scenic Lake Traffic Signal600,000 87,028 512,972 85%PRJ000141 Southwestern Blvd4,200,000 866,960 3,333,040 79%PRJ000143 Leander Rd(Norwood-Swbypass)6,750,000 994,025 5,755,975 85%PRJ000171 Shell Rd Sidewalk229,825 203,755 26,070 11%PRJ000188 DB Wood (SH 29 to Oak Ridge)4,000,000 1,703,636 2,296,364 57%PRJ000201 Austin Ave. (Sh29-Fm2243)466,000 466,000 - 0%PRJ000202 FM 9714,853,000 1,113,617 3,739,383 77%PRJ000207 Northwest Blvd Bridge11,254,320 11,372,616 (118,296) -1%PRJ000208 Old Town Northeast1,050,000 923,818 126,182 12%PRJ000209 Southeast Inner Loop10,521,000 8,884,343 1,636,657 16%PRJ000214 Intersection Improvements (Traffic Signals)1,650,000 159,863 1,490,137 90%PRJ000215 2021 Intersection Safety Enhancements (RRFB)150,000 96,450 53,550 36%PRJ000216 FY21 Downtown Sidewalk Improvements1,000,000 130,000 870,000 87%PRJ000217 SW Bypass - Wolf Ranch Extension1,000,000 633,943 366,057 37%Public Works Department Total53,979,543 30,070,852 23,908,691 871%Right of WayPRJ000200 Access Rtw To Government Srv220,000 220,000 - 0%Right of Way Total220,000 220,000 - 0%GCP Total136,270,980 76,357,831 59,913,149 2521%60
Row LabelsTotal Budget Total Spend Remaining Budget Percent RemainingGeneral Fund ProjectsParksPRJ000055 Katy Crossing Trail700,000 17,780 682,220 97%Parks Total700,000 17,780 682,220 97%Public Works DepartmentPRJ000012 Austin Ave. (Sh29-Fm2243) (Inactive) 466,000 - 466,000 100%Public Works Department Total466,000 - 466,000 100%Right of WayPRJ000007 Access Rtw To Government Srv220,000 - 220,000 100%Right of Way Total220,000 - 220,000 100%General Fund Projects Total1,386,000 17,780 1,368,220 297%GTECGTEC DepartmentPRJ000046 FM 971/ Fontana (Nw Bridge) 1,209,000 1,193,000 16,000 1%PRJ000053 IH 35/ Hwy 29 Intersection Imp 1,800,000 120,066 1,679,934 93%PRJ000060 Rabbit Hill Road4,100,000 179,757 3,920,243 96%PRJ000083 Rivery Tia Improvements 1,179,000 1,110,970 68,030 6%PRJ000092 Se Inner Loop Widening (Inactive) 8,148,000 - 8,148,000 100%PRJ000145 Sh29 Signal And Roadway Improvements 1,595,000 312,671 1,282,329 80%PRJ000146 Wolf Ranch Parkway Extension (Inactive) 1,100,000 - 1,100,000 100%PRJ000181 Aviation Drive10,300,000 275,868 10,024,132 97%PRJ000182 Confido III600,000 - 600,000 100%PRJ000183 Big C Project2,000,000 - 2,000,000 100%GTEC Department Total32,031,000 3,192,332 28,838,668 774%GTEC Total32,031,000 3,192,332 28,838,668 774%StormwaterStormwaterPRJ000004 18th and Hutto Drainage 50,000 6,356 43,644 87%PRJ000005 2nd and Rock Pond625,000 447,151 177,849 28%PRJ000024 2020 Curb & Gutter1,055,000 337,047 717,953 68%PRJ000104 Stormwater Infrastructure 347,000 168,506 178,495 51%PRJ000148 Water Quality Ponds98,000 - 98,000 100%PRJ000149 Drainage Improvement/Flood Mitigation Projects 300,000 - 300,000 100%PRJ000213 2021 Curb & Gutter Project 500,000 53,100 446,900 89%Stormwater Total2,975,000 1,012,160 1,962,840 525%Stormwater Total2,975,000 1,012,160 1,962,840 525%61
Row LabelsTotal Budget Total Spend Remaining Budget Percent RemainingStreet TaxPublic Works DepartmentPRJ000172 2020 Street Maintenance High Performance Seal: Bid Package No.1372,200 372,200 - 0%PRJ000173 2020 Street Maintenance High Performance Seal: Bid Package No. 2463,195 482,214 (19,020) -4%PRJ000174 2020 street maintenance HIPR1,935,589 1,441,013 494,576 26%PRJ000210 2021 HIPR Street Maintenance2,300,000 274,700 2,025,300 88%PRJ000211 2021 High Performance Pavement Seal Project #1600,000 94,900 505,100 84%PRJ000212 2021 High Performance Pavement Seal Project #2600,000 90,700 509,300 85%PRJ000237 Northeast Inner Loop (Stadium to FM971) Emergency Repairs700,000 695,456 4,544 1%Public Works Department Total6,970,983 3,451,183 3,519,800 279%Street Tax Total6,970,983 3,451,183 3,519,800 279%TransportationGTEC DepartmentPRJ000047 FM1460 Widening (Inactive)794,000 - 794,000 100%PRJ000061 NB Front Rd (2338 To Lakeway) (Inactive)366,000 - 366,000 100%GTEC Department Total1,160,000 - 1,160,000 200%Public Works DepartmentPRJ000045 FM 9712,000 (26,684) 28,684 1434%PRJ000063 Northwest Blvd Bridge21,743,000 421,578 21,321,422 98%PRJ000065 Old Town Northeast (Inactive)855,021 (19,064) 874,085 102%PRJ000100 Southeast Inner Loop3,321,000 - 3,321,000 100%Public Works Department Total25,921,021 375,830 25,545,190 1734%Transportation Total27,081,021 375,830 26,705,190 1934%62
Row LabelsTotal Budget Total Spend Remaining Budget Percent RemainingWaterWaterPRJ000014 Berry Creek Inter.49,949,000 701,486 49,247,514 99%PRJ000016 Braun Est4,750,000 1,202,760 3,547,240 75%PRJ000017 Cedar Breaks Est3,385,000 236,730 3,148,270 93%PRJ000023 Cr 255 (Wd14-2)1,493,963 323,841 1,170,122 78%PRJ000025 Db Wood/ Pastor 24 Dedicated 5,286,000 423,726 4,862,274 92%PRJ000027 Domel PS Improvements (Inactive) 5,816,000 - 5,816,000 100%PRJ000034 Earz2,326,000 469,283 1,856,717 80%PRJ000057 Lift Station Upgrade 1,173,593 - 1,173,593 100%PRJ000059 LWTP Raw Water Intake Rehab 6,750,000 5,506,976 1,243,024 18%PRJ000066 Park Lift Station & Force Main 3,574,341 2,115,836 1,458,505 41%PRJ000069 Pecan Branch Ph 2253,000 232,521 20,479 8%PRJ000075 Pumps & Storage1,009,289 9,289 1,000,000 99%PRJ000076 Rabbit Hill Est1,826,000 873,294 952,706 52%PRJ000085 Ronald Reagan/Daniels Mountain 4,400,000 167,638 4,232,362 96%PRJ000087 S. Lake Wtp 2018 (Inactive) 6,950,000 - 6,950,000 100%PRJ000088 San Gabriel Belt Press and Rehab 3,200,000 2,580,279 619,721 19%PRJ000096 Shell Road Water Line 6,890,000 992,205 5,897,795 86%PRJ000101 Southlake Wtp100,000,000 8,590,093 91,409,907 91%PRJ000103 Stonehedge Ls & Fm (Inactive) 150,000 - 150,000 100%PRJ000108 Sun City Elevated Storage Tank (Inactive) 3,224,000 - 3,224,000 100%PRJ000110 Sw Bypass Waterline (Inactive) 1,106,000 - 1,106,000 100%PRJ000119 Water Mains1,537,000 433,498 1,103,502 72%PRJ000121 Westinghouse Ls & Fm (Inactive) 3,299,000 - 3,299,000 100%PRJ000122 Westside Facility (Inactive)505,500 - 505,500 100%PRJ000123 WW Interceptors608,431 - 608,431 100%PRJ000150 Carriage Oaks Transmission500,000 - 500,000 100%PRJ000151 FY2020 CR262 Waterline500,000 - 500,000 100%PRJ000152 Hoover Pump Station6,850,000 855,221 5,994,779 88%PRJ000153 FY2020 Round Rock Supply Line (Inactive)300,000 17,345 282,655 94%PRJ000154 FY2020 Stonewall Ranch Ps Improvements500,000 - 500,000 100%PRJ000155 Southside Water Treatment Plant2,250,000 21,840 2,228,160 99%PRJ000156 Gatlin/Teravista Improvements450,000 - 450,000 100%PRJ000157 Leander Interconnect515,000 49,495 465,505 90%PRJ000158 West loop (H-1A)2,119,000 447,385 1,671,615 79%PRJ000160 Round Rock Supply Pump Station And Elevated Storage Tank10,500,000 1,427,473 9,072,527 86%PRJ000161 Miscellaneous Line Upgrades 872,000 655,875 216,125 25%PRJ000162 South West Bypass Water (H24-1) 2,906,000 2,301,498 604,502 21%PRJ000163 Tank Rehabilitation2,905,000 445,994 2,459,006 85%PRJ000164 Council Chamber Water 423,000 15,960 407,040 96%PRJ000165 San Gabriel Wwtp Rehab 2,500,000 98,000 2,402,000 96%PRJ000167 San Gabriel Inter SGI -2 4,500,000 912,755 3,587,245 80%PRJ000168 WWTP Upgrade950,000 - 950,000 100%PRJ000177 Northlake WTP Phase IV Expansion 15,000,000 11,859,923 3,140,077 21%PRJ000185 Cimarron Hills Wastewater Treatment Plant Expansion 800,000 - 800,000 100%PRJ000218 EARZ Wastewater Rehabilitation Area 2 - 20192,460,360 2,460,360 - 0%PRJ000219 Southside GST Foundation Improvements535,678 - 535,678 100%PRJ000228 Southside GST Roof Rehab567,000 - 567,000 100%Water Total278,365,155 46,428,578 231,936,576 3759%Water OperationsPRJ000220 AMI Western District Improvements750,000 - 750,000 100%Water Operations Total750,000 - 750,000 100%Water Total279,115,155 46,428,578 232,686,576 3859%Grand Total501,409,805 137,902,820 363,506,985 12504%63
Unfunded Liability & CommitmentsFinancial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21Cemetery Special Revenue FundCurrently cemetery operations are self‐funded through plot sales of approximately $50K per year. The cemetery is managed through Parks Administration. In 2015, Council elected to reserve $75,000 annually for future costs associated with maintaining the property. The General Fund has made this transfer in since FY 2016.The general fund transfer for FY2021 was reduced to $35,000. No change.Unfunded Actuarial Accrued Liability (UAAL)Recognizes the outstanding liability for the City’s employee retirement plan through TMRS. The City contributes monthly to fund the UAAL, based on an annual percentage of payroll. Actual % of payroll costs is recognized within each fund. The UAAL is provided by TMRS and lags one year.As of 9/30/2020, the net pension liability is $18.7 million and is 88.97% funded. This decrease in liability is due to a change in the actuarial assumptions.No change.Other Post Employee Benefits (OPEB)While the City has no obligation to offer additional retiree benefits, retirees are eligible to participate in the City’s health insurance program. That ability represents a subsidy that impacts health insurance costs to the City. Retirees pay their monthly premiums to the self insurance fund, which then processes their health insurance claims. OPEB liability as of 9/30/2020 is $2.7 million. This is a combination of sudden death benefits as well as post‐retirement healthcare.No change.Compensated AbsenceFuture costs associated with benefits such as vacation, and sick leave for City employees. Compensated Absence is accrued annually to each proprietary fund type on a GAAP basis and accounted for on the balance sheet of each fund. For governmental funds (and for budgetary basis), the expense is recognized when due and payable. The City keeps a reserve in the General Fund to help offset large payouts for long‐term employees. The reserve is used as needed, and annually replenished or increased based on known risk.Compensated absences as of 9/30/2020 are $8.2 million. More time was earned than used during FY2020 as many plans were changed related to the pandemic. The City did not extend any vacation cap carry overs in general. As with any year, specific requests for carryover are considered and approved by the City Manager.No change.CITY OF GEORGETOWNLong-term Commitments, Reservations, and Other Unfunded Liabilities3/31/202164
Unfunded Liability & CommitmentsFinancial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21Electric Fund Rate Stabilization ReserveIntended to mitigate potential rate impacts due to increased purchased power costs or other external factors. The RSR is maintained within the Electric Fund. During the FY2021 CIP Roll Forward and Other Operating Amendments approved by Council, the PCA revenue was lowered by $5 million. Budgeted ending fund balance covers $4M in 90 day contingency reserve, $10.6M in non‐operating or rate stabilization reserve, and $3.4M in restricted proceeds from the transformer sale.During the February Winter Storm Uri, the Electric Fund incurred an additional $48 million in energy market costs. The City issued a debt instrument that will be paid from current PCA rates. There are no expected changes to Electric reserves.Airport MaintenanceFund on‐going maintenance of the Airport grounds, runways and taxi ways. Terminal and Tower included in Facilities ISF. An Airport Master Plan was developed to address long term capital maintenance project prioritization. CARES Act purchases will be changed to airport Utility charges FY 20 & FY21, along with other maintenance charges from FY21. We are still reviewing Land Lease buildings that will be reverting back to Airport Ownership within the next 5 years. These reversions will impact the budget bottom line as we will have to do some maintenance on the buildings. These charges will be off‐set by the increased revenue from the increased Facility Lease Rates. Continued maintenance on buildings and pavement surfaces. We will have to do pavement sealing on Taxiway A to prevent early deterioration. This will include a seal coat and repainting of all markings. We have prepared all documentation and supporting evidence for CRRSA (the 2nd relief grant) for reimbursement. We are waiting on TxDOT to establish the process. This will be ~$57K. The relief grant has yet to be established by the FAA. We expect to get another award for that as well. Americans with Disabilities Act (ADA) Compliance NeedsAs facilities are built or repurposed, meeting ADA compliance will be included in Project Costs. Funding for program expansion will be needed (General Fund sources). The City has an adopted policy, as required by Federal Law, that it will make reasonable accommodations and modifications to ensure that people with disabilities have an equal opportunity to enjoy its programs, services, and activities. The City does not maintain a reserve for these modifications.FY2021 budget and debt sale includes $150,000 for the ADA plan. A competitive sealed bid has been completed for ADA repairs along the South San Gabriel River Trail. The contract is in Legal for review. Sidewalk Maintenance & MasterplanCurrently, new sidewalks are built as development occurs. Repairs are funded as needed or if funding is available, when major roads are repaired. Useful life of a sidewalk is estimated at 40 to 50 years. The largest revenue source comes from the City’s General Fund, but there has been some debt funding as well. In design is the Rock Sidewalk/FY20 Downtown ADA Sidewalk Improvements. This project will construct new and rehab/replace non‐ADA compliant sidewalks and pedestrian ramps. Currently reviewing 95% plans. Advertising and Bidding to start end of January 2021. The Council is considering a mobility bond for May 2021 that would include additional debt capacity for sidewalk projects.Rock Sidewalk/FY 20 Downtown ADA Sidewalk Improvements. Project is awarded to Choice Builders. Construction to begin in May 2021. FY21 Downtown ADA Sidewalk improvements will be a continuation of Downtown ADA improvements and closing gaps. Design for this project will begin in May 2021. The mobility bond passed in the May election, providing new funding over the next 7 years for sidewalks.65
Unfunded Liability & CommitmentsFinancial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21Park Equipment Maintenance & ReplacementOver the past 5 years, funding for Park Maintenance and Replacement has increased. $200K transfer from General Fund included in FY2018 budget. Staff has listed all assets & developed replacement schedule funded by the General Fund.University Park and Raintree Park equipment and the outdoor pool slides at the Recreation Center were scheduled to be completed in FY2020. However, these were deferred due to financial constraints related to COVID‐19. These deferrals total $290,000. Additionally, the general fund transfer for FY2021 was reduced from $200,000 to $50,000. Scheduled maintenance equipment and replacement projects for FY2021 total $402,000 not including the FY2021 deferrals. Staff has evaluated the FY2020 deferrals and the scheduled FY2021 replacements and prioritized to complete projects with greatest need. These total $293,000 and will be completed with the $50,000 transfer and existing fund balance. No change.Radio Equipment ReplacementCommunication system consisting of 500 on‐body and in‐vehicle radios for Police, Fire, parks and utilities. Replacement radios are compatible with newer technology. The replacement takes place over 5 years due to cost and is funded with certificate of obligation debt. The audit shows there are 301 radios that still need to be replaced before September 2023. Non‐Public Safety ‐ 39 portable radios; 72 mobile radios. Some of those mobiles may be replaced with portables. Police ‐ 71 portable radios; 82 mobile radios. 911 Comms ‐ 4 portable radios; 9 mobile radios. Fire ‐ 12 portable radios; 12 mobile radios. The FY2021 budget and debt sale includes $363K in funding.Ordered 22 portable radios for Electric Dept. Ordered 9 mobiles and 4 portables for 911 Communications. Processing 8 portable radios for Police in Workday. Still working on the other 35 non‐public safety radios. Street MaintenanceThe City funds street maintenance in the General Fund, supplemented by a 1/8th Street Sales Tax special revenue fund. In 2017 and 2018, the Council and GTAB reviewed various methods for enhanced street maintenance and costs. Direction from Council is to use high performance surface seals and pavement wearing courses and begin programmatically addressing the street network's deferred maintenance backlog, creating a need for approximately $2 million more per year for street maintenance.No change. After the FY2020 audit is completed and all available General Fund balance reviewed, there may be dollars available to allocate to street maintenance or other priorities.The Council declined to appropriate any available fund balance during an April workshop. The February Winter Storm Uri caused damage to a section of Inner Loop. The Street Sales Tax Fund will cover the approximately $700K for repairs. The road is not eligible for FEMA reimbursement.Fiber Asset AllocationNetwork fiber infrastructure is installed across the City. Traditionally, the Electric Fund has installed and maintained the network. In reviewing all costs for the Electric Fund, the City has begun moving the fiber asset to the IT Fund. Staff must develop a multi‐year strategy to complete the asset transfer and allocate costs for maintenance.Fiber staff will be moved into IT at beginning of FY 21. Also in FY 2021, Fiber costs will be allocated across departments according to the IT allocation process. The second installment to acquire the asset will be paid in FY2020, and there is a plan to assume additional installments over the next 4 years. The IT Fund will need to increase cost recovery rates to complete the acquisition.IT has drafted a cost recovery plan for fiber and it is being evaluated as part of the FY2022 budget development process. 66
Unfunded Liability & CommitmentsFinancial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21IT Capital Replacement ReserveThe purpose of this reserve is to fund the maintenance and replacement of computer network and other technology systems. A reserve will be established within the ISF for replacement of major systems and will be funded over time through excess revenues within the Fund. The targeted amount is the average (1/5th) of the next five years on the replacement schedule. During the FY2021 budget adoption process, the IT capital replacement reserve was drawn down in order to purchase a portion of the fiber asset from the Electric utility. In FY2022, IT Allocation revenues will need to increase citywide to recover the fund balance and continue with the remaining fiber asset purchase.IT has drafted a cost recovery plan for fiber and it is being evaluated as part of the FY2022 budget development process. Facilities Maintenance ReserveThe City has established an on‐going maintenance program, which includes major repairs, equipment, as well as contracts for maintaining City facilities. The City has anticipated a useful life of such equipment and established a means of charging those costs to the various departments in order to recognize the City’s continuing costs of maintaining its facilities. Determination for facility repairs is based on useful life of the various elements of each facility. A proportional cost for each element is expensed within the budget for capital replacement. The targeted replacement reserve amount is the average (1/5th) of the next five years on the replacement schedule. During the FY2021 budget adoption process, the Facilities cost allocation revenue was not increased. This provided some economic relief throughout major funds due to COVID economic uncertainty. Therefore, no incremental progress was made to fund this reserve. In FY2022 or future years, rates will need to increase to fund this reserve. Facilities has drafted a cost recovery plan for fund balance reserves and it is being evaluated as part of the FY2022 budget development process.Public Safety Equipment Recurring Line Item BudgetsAs part of the City’s on‐going maintenance program, the City also recognizes the need to regularly maintain and replace specialized equipment in Police and Fire. Separate replacement and maintenance schedules will be maintained for these items including but not limited to for Fire: SCBA’s and other firefighting equipment and protective gear; and for Police: bullet proof vests, armaments and other tactical equipment. The City’s goal is to provide level on‐going funding to ensure proper protection for employees and residents. The current funding level is an annual appropriation in the General Fund of $80,000 for Fire and $88,000 for Police.Due to the economic impacts of the pandemic, reductions were made to General Fund base budgets in FY2021, including public safety equipment. There is no anticipated impact to employee safety. The funds will need to be restored in FY2022, or as soon as practical.No change.Joint Services Fund 90 Day Operational Contingency ReserveA minimum ninety (90) days of operating expenses will be reserved for unexpected delays in revenue or emergency expenses. Due to the economic impact of the pandemic, the City is not increasing recovery rates to build this reserve. It is estimated to take approximately 3 years to build the reserve to 90 days. The FY2021 budget provide funding to hire a consultant to review and recommend updates to the City's joint services cost allocation model.Council declined to appropriate any available fund balance at mid‐year to achieve this goal. The Cost Allocation Model study was put on hold due to activities needed to recover from the Winter Storm.67