HomeMy WebLinkAbout1st_Qtr_Report_FY2021FY2021 BUDGET
AND 5 YEAR CAPITAL IMPROVEMENT PLAN
Quarterly Report
FINANCIAL REPORT AND INVESTMENT REPORT
For the Quarter Ended December 31, 2020
Table of Contents
Executive Summary .................................................................................................................................... 1-9
General Fund Schedule ............................................................................................................................... 10
Electric Fund Schedule ................................................................................................................................ 11
Water Services Fund Schedule .................................................................................................................... 12
Joint Services Fund Schedule ....................................................................................................................... 13
Council Discretionary Fund Schedule .......................................................................................................... 14
Convention & Visitors Bureau Fund Schedule ............................................................................................. 15
Airport Fund Schedule ................................................................................................................................. 16
Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 17
Georgetown Economic Development Corporation Fund Schedule ............................................................. 18
Quarterly Investment Report - City ........................................................................................................ 19-44
Quarterly Investment Report - GEDCO ................................................................................................... 45-50
Quarterly Investment Report - GTEC ...................................................................................................... 51-56
Grant Applications ....................................................................................................................................... 57
Capital Improvement Projects ................................................................................................................ 58-59
Long-term Commitments and Other Unfunded Liabilities ..................................................................... 60-63
F FY2021 Quarterly Report
EXECUTIVE SUMMARY FOR THE QUARTER ENDED DEC. 31, 2020
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. While the “CIP Roll Forward” amendment second reading was
approved in January, it is reflected in the 1st quarter financial report. This aligns the capital project budget with actual
spend that has occurred in the 1st quarter of FY2021. Furthermore, this report compares actuals compared to budget,
and compared to the performance of actuals in the same quarter in the previous year. Due to the timing of COVID‐19
pandemic starting in the second quarter of last year, the quarter‐to‐quarter comparisons show decreases in some
revenues and expenses. However, these were expected during the budget planning process and are generally not a
concern.
GENERAL FUND REVENUES:
General Fund revenues total $23,340,556, or 28.19% of budget through the first quarter of FY2021. Revenues exceed
last year’s first quarter total by $2,580,304, or 12.43%.
COG ‐ General Fund Financial Report
Period: Q1 FY21
Budget Quarterly Comparison
FY2021
YTD Actuals
w/Encumbrances:
Q1 FY20
YTD Actuals
w/Encumbrances:
Q1 FY21
YTD
Variance % Variance
Revenue
Taxes 41,208,025 11,024,146 11,960,710 936,565 8.50%
Fines and Penalties 388,392 91,654 67,539 (24,115)‐26.31%
Investment Income 75,000 51,528 24,864 (26,664)‐51.75%
Charges for Services 25,042,285 6,494,899 6,595,025 100,126 1.54%
Other Miscellaneous
Revenue 871,955 75,128 62,844 (12,283)‐16.35%
Donations and Grants 5,770,975 1,073,095 1,380,452 307,358 28.64%
70001:Transfers In 995,302 ‐ 995,302 995,302 0.00%
70002:Transfers In ‐ ROI 8,431,375 1,949,803 2,253,819 304,017 15.59%
Revenue Total 82,783,309 20,760,252 23,340,556 2,580,304 12.43%
1
F FY2021 Quarterly Report
Sales tax revenue accounts for 9.83% of budgeted
revenues in the General Fund. The sales tax
revenue through 1,825,349 totals million, or
9.83% 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 first quarter returns for sales
tax were 10.22% 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.
Property tax revenues are the second largest revenue segment in the General Fund and accounts for 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 first quarter of FY2021, property tax year‐to‐date
collections total 57.84% of budget, or $9,241,457. The first quarter of property tax revenue were 7.71% higher than
the same period last year.
The City collects franchise fees for electric, natural gas, cable, and non‐cellular telephone services and represents
7.56% of budgeted revenue. Through the first quarter, franchise fee revenues total $842,126 in FY2021, or 13.46%
of budget. Franchise fee revenue is 6.91% higher than the first quarter of FY2020.
Return on Investment (ROI) revenue from City‐owned utilities represents 10.18% of budgeted revenues in the fund.
Through the quarter, ROI revenues total $2,253,819, or 26.73% of budget. Through the quarter, ROI revenue is
15.59% higher than the first quarter of FY2020.
Planning and Development related revenue continues to be strong in FY2021 and accounts for 7.85% of total General
Fund budgeted revenue. Through the quarter, planning and development related revenue totals $1,739,243 or
26.76% of budget. Development fees are up 36.86%, or $468,399 compared to the same quarter in FY2020. The
following graph shows the number of residential building permits issued by in the first quarter for the past 3 years.
Sanitation revenue through the quarter totals $2,756,982, or 27.16% of budget. Sanitation revenue accounts for
12.26% of budgeted revenues in the fund. Sanitation rates increased as part of the FY2021 budget to support growing
‐
200
400
600
800
FY2019 FY2020 FY2021
Q1
Residential Building Permits
1.5M 1.7M 1.8M
K
500K
1.0M
1.5M
2.0M
FY2019 FY2020 FY2021
Q1
GENERAL FUND SALES TAX
2
F FY2021 Quarterly Report
customer base as well as to support the debt service for a new transfer station. The variance between the same
period is $163,205, or 6.29%.
Fire and EMS transport revenue through the quarter totals $664,616, or 25.06% of budget. Additional Fire/EMS
revenue is comprised of the Emergency Services District 8 contract for service, as well as public safety grants like the
SAFER grant. This segment of revenue accounts for 9.68% of budgeted revenue in the fund. EMS transport revenues
are down ‐6.22% in comparison to this same quarter in FY2020.
Parks and Recreation revenue totals $298,440 through the quarter, or 15.76% of budget. Parks and Recreation
revenue is ‐39.62% less than this time in FY2020. This is a variance of $(195,826). 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 $20,035,395, or 24.51% of budget. Generally, year over year increase are
reflective of growth in new programs, and personnel costs for new salaries and benefits as well as merit and market
adjustments.
COG ‐ General Fund Financial Report
Period: Q1 FY21
Budget
FY2021
YTD Actuals
w/Encumbrances:
Q1 FY21 YTD Variance % Variance
Expense
Personnel 45,566,994 10,461,668 35,105,326 22.96%
Operations 34,716,978 8,675,073 26,041,905 24.99%
Operating Capital 264,574 229,695 34,879 86.82%
CIP Expense ‐ 17,780 (17,780)0.00%
Transfers 1,353,191 653,191 700,000 48.27%
Expense Total 81,751,737 20,035,395 61,716,342 24.51%
Personnel and Operations Summary
Personnel costs through the quarter total $10,461,668, or 22.96% of personnel budget. Operational costs total
$8,675,073, or 24.99%. 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.
Administration Services Division (Administrative Services, City Council, and City Secretary) personnel and
operational expenditures for the quarter totals $3,292,031, which represents 32.75% of budget. General
Government Contracts includes budgeted vacancy savings estimates for all General Fund departments. Real vacancy
savings is realized in each cost center.
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 $4,331,222, or 21.91% of budget.
3
F FY2021 Quarterly Report
Finance Administration which consists of Municipal Court totals 131,341, or 22.45% percent of budget through the
quarter.
Year‐to‐date the Library, Tourism, and Culture Division (Library and Arts and Culture) totals $713,292. This consists
of $386,192 of personnel costs and $327,100 of operational costs. As of this quarter, the Library, Tourism, and
Culture department is at 24.63% of budget.
Personnel and Operations Summary:
FY2021
Budget
YTD Actuals
w/Encumbrances:
Q1 FY21 Variance % of Budget
Development and Community Services
Personnel 6,157,720 1,182,197 4,975,524 19.20%
Operations 13,607,117 3,149,025 10,458,092 23.14%
Development and Community Services 19,764,838 4,331,222 15,433,616 21.91%
Finance Administration
Personnel 484,734 112,727 372,007 23.26%
Operations 100,389 18,614 81,775 18.54%
Finance Administration 585,123 131,341 453,782 22.45%
Police
Personnel 12,922,164 3,136,192 9,785,971 24.27%
Operations 3,973,436 963,311 3,010,125 24.24%
Police Total 16,895,600 4,099,504 12,796,096 24.26%
Fire and EMS
Personnel 18,084,000 4,058,370 14,025,629 22.44%
Operations 4,682,312 1,264,994 3,417,318 27.02%
Fire and EMS Total 22,766,312 5,323,364 17,442,948 23.38%
Administrative Services
Personnel 1,316,326 594,436 721,890 45.16%
Operations 8,735,940 2,697,595 6,038,345 30.88%
Administrative Services Total 10,052,266 3,292,031 6,760,235 32.75%
Library, Tourism, and Culture
Personnel 1,798,754 386,192 1,412,562 21.47%
Operations 1,097,007 327,100 769,907 29.82%
Library, Tourism and Culture Total 2,895,761 713,292 2,182,469 24.63%
Parks and Recreation
Personnel 4,803,296 991,694 3,811,602 20.65%
Operations 4,138,542 1,137,319 3,001,223 27.48%
Parks and Recreation 8,941,838 2,146,793 6,795,044 24.01%
4
F FY2021 Quarterly Report
Year‐to‐date the Parks and Recreation Division (Parks Administrations, Parks, Garey Park, Recreation, and Recreation
Programs) totals $2,146,793. This consists of $991,694 of personnel costs and $1,137,319 of operational costs. As
of this quarter, the Parks and Rec departments at 24.01% of budget.
Year‐to‐date personnel and operational expenditures for Fire and EMS through the quarter total $5,323,364 or
23.38% of budget. Personnel is 22.44% through the quarter.
Year‐to‐date personnel and operational expenditures for Police through the quarter totals $4,099,504 or 24.26% 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.
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. In order 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 in the FY2021
Amended budget and is reflected in this report since the amendment passed on first reading in December.
COG ‐ Electric Services Financial Report
Period: Q1 FY21
Budget Quarterly Comparison
FY2021
YTD Actuals
w/Encumbrances:
Q1 FY20
YTD Actuals
w/Encumbrances:
Q1 FY21
YTD
Variance % Variance
Operating Revenue
Taxes 120,732 1,278 872 (406)‐31.79%
Fines and Penalties 553,724 105,273 223,636 118,362 112.43%
Investment Income 5,000 2,855 14,536 11,681 409.21%
Charges for Services 82,889,381 19,927,510 20,101,150 173,640 0.87%
Developer Contributions 1,500,000 417,998 2,142,271 1,724,272 412.51%
70001:Transfers In 1,379,308 ‐ 379,308 379,308 0.00%
Operating Revenue Total 86,448,145 20,454,914 22,861,772 2,406,858 11.77%
The total annual operating revenue in the Electric Fund totals $22,861,772 through the quarter, or 26.45% of budget.
Electric revenue sales, the largest component of operating revenue, account for 91.36% of operating revenue.
Electric revenue sales are typically higher in the summer months when consumption increases. Developer
5
F FY2021 Quarterly Report
contributions were conservatively budgeted at $1,500,000. Year‐to‐date collection total 2,142,271, or 142.82% of
budget.
Operating expenses in the Electric Fund total $23,155,279 through the quarter. Purchase power expenses total
$17,160,357, while net congestion revenue rights (CRRs) credits total $(340,194). Net purchase power totals
$16,796,163 through the quarter, which is 28% of the budget. Net purchased power is 28% higher compared to the
same quarter in FY2020 due to congestion and transmission issues.
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 first quarter of FY2020.
The City will recognize bond proceeds as part of the annual debt sale in the spring. 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 quarters.
Overall, the effort to manage the power portfolio, reduce operating expenditures, sell assets, and the Power Cost
Adjustment continue to improve the financial condition of the fund. The City was impacted by the extreme winter
weather in February 2021. Currently, the City is seeking an additional $48 million in bond proceeds in FY2021 to pay
for the extreme winter weather event unbudgeted purchase power costs. This debt obligation will be financed over
10 years. The debt will be repaid from the Power Cost Adjustment (PCA) revenue. This reflects known assumptions
on March 16, 2021. We are reviewing all our options to lessen this impact. The market dynamic on the storm is
changing daily.
Water Fund: Overall water operating revenue totals $70,912,250, or 30.20% of budget. Water, Wastewater, and
Irrigation revenue through the quarter total $12,263,577. This revenue is up 11% 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 $6,500,314. Total Water Fund operating revenue is up 4.75% compared to the same
period last fiscal year.
COG ‐ Water Services Financial Report
Period: Q1 FY21
Budget Quarterly Comparison
FY2021
YTD Actuals
w/Encumbrances:
Q1 FY20
YTD Actuals
w/Encumbrances:
Q1 FY21 YTD Variance % Variance
Operating Revenue
Fines and Penalties 255,000 106,499 136,031 29,532 27.73%
Investment Income 237,250 473,221 161,120 (312,101) ‐65.95%
Charges for Services 50,995,000 12,507,293 14,617,803 2,110,509 16.87%
41602:Impact Fees 18,800,000 7,357,457 6,500,314 (857,143) ‐11.65%
Donations and Grants 625,000 ‐ ‐ ‐ 0.00%
Operating Revenue Total 70,912,250 20,444,471 21,415,267 970,797 4.75%
6
F FY2021 Quarterly Report
Operating expenses in the Water Fund total $14,006,666 through the quarter. Operational costs are trending slightly
higher than 25%. This is normal as large encumbrances for contracts take place at the beginning of the fiscal year.
Staff will continue to monitor operational costs through the year.
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. Year‐to‐date non‐operating revenue is in line with the first quarter of FY2020.
The City will recognize bond proceeds as part of the annual debt sale in the spring.
Non‐operating expenditures are budgeted at $124,787,037 in FY2021. Budgeted non‐operating expenditures include
$117,554,949 for capital projects and $7,232,088 for debt service payments. Expenditures are $33,796,171 through
the quarter, which includes encumbrances for large projects.
OTHER MAJOR FUNDS:
Convention & Visitors Bureau Fund: The COVID‐19
pandemic significantly impacted the tourism
sector. Overall revenue in the fund totals
$147,601, or 14.06% of budget. Hotel Occupancy
Tax revenue totals $141,184 through the quarter,
or 15.69% 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 $362,133 or 24.5% 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 $841,470. This includes revenue for fuel sales, facility lease, and hangar rentals. Revenues through the quarter
are $786,000, or 22% of budget.
Operation expenses in the Airport fund total $3,921,513. Year‐to‐date operation expenses totals $3,712,722 which
include a $2,929,083 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 first 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 first 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. 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. The City will continue soliciting for the best rates to improve both diversity
and yield, while keeping in mind safety and liquidity.
309K
249K
141K
K
100K
200K
300K
FY2019 FY2020 FY2021
Q1
HOTEL OCCUPANCY TAX
7
F FY2021 Quarterly Report
The Investment Reports for the quarter ending December 31, 2020, 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 December 31, 2020, 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 73.11%, debt service at 1.5%, and bond proceeds at 25.39%.
CITY Book Value GTEC GEDCO
9/30/20 12/31/20 9/30/20 12/31/20 9/30/20 12/31/20
Total cash and
investments
$240,298,554 $258,316,790 $29,285,179 $31,693,655 $9,892,111 $10,161,540
Quarter End Average
Yield
.54% .37% .17% .12% .47% .41%
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 includes bank deposits, local government investment pool balances, money market
accounts, and financial institution deposits (CD’s). Maturing Treasury Bills have been converted to CDs due to higher
yield. 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.
The City's investment program is conducted to accomplish the objectives of safety, liquidity, public trust, and yield.
Each aspect is considered when making decisions regarding investments.
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.
Staff has worked diligently to utilize the project module in the new Enterprise Resource Planning system, Workday,
for the City’s CIP reporting. 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.
8
F FY2021 Quarterly Report
Projects are grouped based on fund, division, and cost center. Highlights of this quarter include substantial
completion of the Enterprise Resource Planning software conversion project; procurement of replacement cardiac
monitor equipment for EMS; substantial completion of Fire Station 6; HVAC system replacement at the Recreation
Center Natatorium; replacement of policy body camera equipment; continued construction of the Northwest Blvd
Bridge over IH35; and continuation of large water treatment plant projects.
9
COG ‐ General Fund Financial Report
Period: Dec‐20
Budget Period
FY2021 Dec‐20
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 7,435,713 9,241,457 (6,735,048) 57.84%
40002:Sales Taxes 18,576,250 1,761,889 1,825,349 (16,750,901) 9.83%
40005:Franchise Taxes 6,255,270 252,527 842,126 (5,413,144) 13.46%
40008:Other Taxes 400,000 51,779 51,779 (348,221) 12.94%
41001:Fines 328,392 13,918 42,799 (285,593) 13.03%
41002:Penalties 60,000 8,744 24,740 (35,260) 41.23%
42001:Interest Income 75,000 5,406 24,864 (50,136) 33.15%
43001:Fees 7,028,184 593,872 1,686,945 (5,341,239) 24.00%
43002:Garbage Charges 10,151,764 959,235 2,756,982 (7,394,782) 27.16%
43003:Permits 4,317,750 378,921 1,235,458 (3,082,292) 28.61%
43004:Administrative Charges 3,396,447 282,708 848,125 (2,548,322) 24.97%
43005:Rental Revenue 148,140 2,819 67,516 (80,624) 45.58%
45001:Misc Revenue 871,955 6,941 62,844 (809,111) 7.21%
44001:Grant Revenue 679,884 64,720 191,687 (488,197) 28.19%
44502:Developer Contributions ‐ 141 216 216 0.00%
44503:Interlocal Agreement Revenue 5,091,091 1,183,773 1,183,773 (3,907,318) 23.25%
44504:Donations ‐ 1,400 4,776 4,776 0.00%
70001:Transfers In 995,302 995,302 995,302 ‐ 100.00%
70002:Transfers In ‐ ROI 8,431,375 693,380 2,253,819 (6,177,556) 26.73%
Revenue Total 82,783,309 14,693,188 23,340,556 (59,442,752) 28.19%
Expense
CC0001 Non‐Departmental 1,353,191 653,191 653,191 700,000 48.27%
CC0107 Planning 1,860,789 126,548 414,497 1,446,292 22.28%
CC0202 Parks Administration 662,224 56,783 159,379 502,845 24.07%
CC0210 Library 2,837,904 233,541 696,447 2,141,457 24.54%
CC0211 Parks 2,721,425 235,666 772,513 1,948,912 28.39%
CC0212 Recreation 2,895,675 235,756 674,609 2,221,066 23.30%
CC0213 Tennis Center 442,917 33,673 88,581 354,335 20.00%
CC0214 Recreation Programs 1,239,636 50,802 155,286 1,084,350 12.53%
CC0215 Garey Park 979,961 70,002 296,425 683,536 30.25%
CC0218 Arts and Culture 57,857 4,373 16,845 41,012 29.11%
CC0316 Municipal Court 585,123 50,720 131,341 453,782 22.45%
CC0402 Fire Support Services/Administration 4,254,731 334,350 938,144 3,316,587 22.05%
CC0422 Fire Emergency Services 15,932,476 1,373,496 3,636,467 12,296,009 22.82%
CC0448 EMS 2,579,106 202,511 748,753 1,830,352 29.03%
CC0533 Environmental Services 9,633,924 765,221 1,487,499 8,146,425 15.44%
CC0536 Inspection Services 1,519,534 115,273 312,111 1,207,423 20.54%
CC0602 Administrative Services 1,893,883 148,307 505,511 1,388,372 26.69%
CC0605 Community Services 353,889 22,955 90,358 263,531 25.53%
CC0634 City Council Services 185,734 19,349 48,501 137,233 26.11%
CC0635 City Secretary Services 1,000,047 76,278 212,883 787,163 21.29%
CC0638 General Government Contracts 4,774,808 348,814 1,676,765 3,098,043 35.12%
CC0655 Communications/Public Engagement 844,604 51,530 195,180 649,423 23.11%
CC0702 Police Administration 2,559,766 194,124 645,551 1,914,215 25.22%
CC0742 Police Operations 14,335,833 1,369,863 3,453,952 10,881,881 24.09%
CC0744 Animal Services 1,106,702 78,116 235,584 871,117 21.29%
CC0745 Code Compliance 562,584 38,110 112,709 449,874 20.03%
CC0802 Public Works 1,641,292 46,120 727,704 913,587 44.34%
CC0846 Streets 3,086,124 191,625 948,748 2,137,377 30.74%
Expense Total 81,751,737 7,127,094 20,035,395 61,716,342 24.51%
Excess (Deficiency) of Total Revenue over Total
Requirements 1,031,571 7,566,094 3,305,161 4,336,732 320.40%
Ending Fund Balance 16,580,494 18,854,084 2,273,590 113.71%
Reserves
Contingency Reserve 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%
Reserve Total 14,434,315 ‐ 14,434,315 ‐ 100.00%
Avaiable Fund Balance 2,146,179 4,419,769 2,273,590 205.94%
Actuals Budget vs. Actuals
10
COG ‐ Electric Services Financial Report
Period: Dec‐20
Budget Period
FY2021 Dec‐20
YTD Actuals
w/Encumbrances Variance % Variance
Beginning Fund Balance 19,702,705 19,702,705 19,702,705 ‐ 100.00%
Operating Revenue
40002:Sales Taxes 5,000 291 872 (4,128) 17.43%
40005:Franchise Taxes 115,732 ‐ ‐ (115,732) 0.00%
41002:Penalties 553,724 69,854 223,636 (330,088) 40.39%
42001:Interest Income 5,000 2,133 14,536 9,536 290.72%
43001:Fees 685,000 45,213 299,611 (385,389) 43.74%
43004:Administrative Charges 3,222,103 268,509 805,526 (2,416,577) 25.00%
43601:Electric Charges 78,982,278 6,410,100 18,996,014 (59,986,264) 24.05%
44502:Developer Contributions 1,500,000 115,415 2,142,271 642,271 142.82%
70001:RC0225 Transfer In ‐ GEDCO 1,000,000 ‐ ‐ (1,000,000) 0.00%
70001:RC0241 Transfer In ‐ South TIRZ 379,308 379,308 379,308 ‐ 100.00%
Operating Revenue Total 86,448,145 7,290,824 22,861,772 (63,586,373) 26.45%
Opearating Expense
CC0001 Non‐Departmental 5,506,375 1,131,209 2,009,251 3,497,124 36.49%
CC0521 Electric Technical Services 711,765 53,546 168,894 542,871 23.73%
CC0522 Electric Administration 8,738,050 680,149 2,078,471 6,659,579 23.79%
CC0524 Metering Services 2,009,379 138,619 433,163 1,576,216 21.56%
CC0525 T&D Services 3,048,996 369,631 864,733 2,184,263 28.36%
CC0537 Electric Resource Management 60,334,393 5,103,105 17,028,177 43,306,216 28.22%
CC0555 Electric Systems Operations 1,448,902 136,482 360,807 1,088,095 24.90%
CC0557 Electrical Engineering 636,869 88,589 211,783 425,087 33.25%
Operating Expense Total 82,434,729 7,701,329 23,155,279 59,279,451 28.09%
Net Operations Total 4,013,416 (410,505) (293,507) (4,306,922) ‐7.31%
Non‐Operating Revenue
45001:Misc Revenue 35,000 248 16,586 (18,414) 47.39%
45004:Sale of Property 10,000 ‐ 2,559 (7,441) 25.59%
46001:Bond Proceeds 6,648,625 ‐ ‐ (6,648,625) 0.00%
Non‐Operating Revenue Total 6,693,625 248 19,145 (6,674,480) 0.29%
Non‐Operating Expenses
CC0001 Non‐Departmental 4,152,805 ‐ ‐ 4,152,805 0.00%
CC0557 Electrical Engineering 8,166,143 178,756 869,269 7,296,874 10.64%
Non‐Operating Expense Total 12,318,948 178,756 869,269 11,449,679 7.06%
Net Non‐Operations Total (5,625,323) (178,508) (850,124) 4,775,199 15.11%
Excess (Deficiency) of Total Revenue over Total Requirements (1,611,907) (589,013) (1,143,630) (2,755,537) 70.95%
Ending Fund Balance 18,090,798 19,113,692 18,559,075 468,276 102.59%
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 468,276 (468,276) 0.00%
YTD Actuals Budget vs. Actuals
11
COG ‐ Water Services Financial Report
Period: Dec‐20
Budget Period
FY2021 Dec‐20
YTD Actuals
w/Encumbrances Variance % Variance
Beginning Fund Balance 115,511,818 ‐ 115,511,818 ‐ 100.00%
Operating Revenue
41002:Penalties 255,000 48,012 136,031 (118,969) 53.35%
42001:Interest Income 237,250 29,446 161,120 (76,130) 67.91%
43001:Fees 4,290,000 786,031 2,305,932 (1,984,068) 53.75%
43005:Rental Revenue 55,000 ‐ 48,294 (6,706) 87.81%
43602:Water Charges 32,150,000 2,579,846 8,724,206 (23,425,794) 27.14%
43603:Wastewater Charges 14,200,000 1,169,178 3,448,001 (10,751,999) 24.28%
43604:Irrigation Charges 300,000 22,868 91,370 (208,630) 30.46%
41602:Impact Fees 18,800,000 2,969,163 6,500,314 (12,299,686) 34.58%
44502:Developer Contributions 625,000 ‐ ‐ (625,000) 0.00%
Operating Revenue Total 70,912,250 7,604,543 21,415,267 (49,496,983) 30.20%
Opearating Expense
CC0001 Non‐Departmental 4,041,064 577,881 1,212,948 2,828,116 30.02%
CC0527 Water Services Administration 26,385,392 1,515,094 8,368,710 18,016,682 31.72%
CC0528 Water Distribution 2,717,500 268,730 862,351 1,855,149 31.73%
CC0529 Water Plant Management 4,261,242 158,140 1,290,823 2,970,418 30.29%
CC0530 Wastewater Operations 896,100 58,441 255,426 640,674 28.50%
CC0531 Wastewater Plant Management 3,956,455 263,528 984,422 2,972,033 24.88%
CC0532 Irrigation Operations 295,000 16,108 57,213 237,787 19.39%
CC0553 Water Operations 3,916,787 356,321 974,772 2,942,015 24.89%
Operating Expense Total 46,469,539 3,214,243 14,006,666 32,462,873 30.14%
Net Operations Total 24,442,711 4,390,300 7,408,601 (17,034,110) 30.31%
Non‐Operating Revenue
45001:Misc Revenue 1,112,500 ‐ 220 (1,112,280) 0.02%
46001:Bond Proceeds 16,300,000 ‐ ‐ (16,300,000) 0.00%
Non‐Operating Revenue Total 17,412,500 ‐ 220 (17,412,280) 0.00%
Non‐Operating Expenses
CC0001 Non‐Departmental 4,083,411 ‐ ‐ 4,083,411 0.00%
CC0524 Metering Services 750,000 ‐ ‐ 750,000 0.00%
CC0526 Systems Engineering 114,152,192 219,991 22,386,283 91,765,909 19.61%
CC0528 Water Distribution ‐ ‐ 456,600 (456,600) 0.00%
CC0529 Water Plant Management 2,757 ‐ ‐ 2,757 0.00%
CC0530 Wastewater Operations 3,026,798 ‐ ‐ 3,026,798 0.00%
CC0531 Wastewater Plant Management 2,650,000 ‐ ‐ 2,650,000 0.00%
CC0532 Irrigation Operations 121,879 ‐ ‐ 121,879 0.00%
CC0553 Water Operations ‐ 967,044 10,953,288 (10,953,288) 0.00%
Non‐Operating Expense Total 124,787,037 1,187,034 33,796,171 90,990,866 27.08%
Net Non‐Operations Total (107,374,537) (1,187,034) (33,795,951) 73,578,586 31.47%
Excess (Deficiency) of Total Revenue over Total Requirements (82,931,826) 3,203,266 (26,387,350) (109,319,175) 31.82%
Ending Fund Balance 32,579,992 3,203,266 89,124,468 56,544,476 273.56%
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 69,996,726 83,448,977 520.33%
YTD Actuals Budget vs. Actuals
12
COG ‐ Joint Services Financial Report
Period: Dec‐20
Budget Period
FY2021 Dec‐20
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 2,032,470 ‐ 2,032,470 ‐ 100.00%
Revenue
41002:Penalties ‐ 4,287 8,877 8,877 0.00%
42001:Interest Income 6,250 406 3,661 (2,589) 58.58%
43001:Fees 173,600 2,220 3,690 (169,910) 2.13%
43004:Administrative Charges 17,967,880 1,497,575 4,492,724 (13,475,156) 25.00%
43005:Rental Revenue ‐ 100 100 100 0.00%
45001:Misc Revenue ‐ ‐ 431 431 0.00%
45002:Insurance Proceeds ‐ 5,675 27,409 27,409 0.00%
45003:Misc Reimbursements 83,000 6,232 22,432 (60,569) 27.03%
Revenue Total 18,230,730 1,516,494 4,559,324 (13,671,406) 25.01%
Expense
CC0001 Non‐Departmental 609,999 148,792 353,097 256,902 57.88%
CC0302 Finance Administration 1,253,909 119,960 398,561 855,348 31.79%
CC0315 Accounting 1,264,484 109,186 373,113 891,372 29.51%
CC0317 Purchasing 1,001,969 82,209 221,865 780,105 22.14%
CC0321 Customer Care 5,986,413 507,609 1,391,485 4,594,927 23.24%
CC0503 Organizational and Operational Excellence 342,009 24,804 69,160 272,849 20.22%
CC0526 Systems Engineering 2,752,912 225,781 697,520 2,055,392 25.34%
CC0534 Conservation 806,212 43,594 190,273 615,939 23.60%
CC0547 Business System Services ‐ ‐ 904 (904) 0.00%
CC0637 Economic Development 568,690 41,320 123,773 444,917 21.76%
CC0639 Human Resources 1,502,553 125,809 340,133 1,162,420 22.64%
CC0640 Citywide Human Resources 1,219,444 (153,810) 589,742 629,702 48.36%
CC0654 Legal 1,047,947 102,336 285,819 762,129 27.27%
Expense Total 18,356,541 1,377,592 5,035,445 13,321,096 27.43%
Excess (Deficiency) of Total Revenue over Total
Requirements (125,811) 138,902 (476,121) (601,933) 378.44%
Ending Fund Balance 1,906,659 1,556,349
Reserves
Reserve Total ‐ ‐ 1,906,658 ‐ ‐
Avaiable Fund Balance 1,906,658 (350,310)
Actuals Budget vs. Actuals
13
COG ‐ Council Discretionary Financial Report
Period: Dec‐20
Budget Period
FY2021 Dec‐20
YTD Actuals
w/Encumbrances Variance % Variance
Beginning Fund Balance 111,172 111,172 ‐ 100.00%
Revenue
42001:Interest Income 500 0 121 (379) 24.27%
Revenue Total 500 0 121 (379) 24.27%
Expense
Transfers 110,983 110,983 110,983 ‐ 100.00%
Expense Total 110,983 110,983 110,983 ‐ 100.00%
Excess (Deficiency) of Total Revenue over Total
Requirements (110,483) (110,983) (110,862) (221,345) 100.34%
Ending Fund Balance 689 310
Reserves
Contingency Reserve ‐ ‐
Reserve Total ‐ ‐ ‐ ‐ ‐
Avaiable Fund Balance 689 310
Actuals Budget vs. Actuals
14
COG ‐ Tourism Financial Report
Period: Dec‐20
Budget Period
FY2021 Dec‐20
YTD Actuals
w/Encumbrances Variance % Variance
Beginning Fund Balance 1,282,917 1,282,917 ‐ 100.00%
Revenue
40008:Other Taxes 900,000 67,695 141,184 (758,816) 15.69%
42001:Interest Income 5,000 343 2,110 (2,890) 42.20%
45001:Misc Revenue 95,000 2,038 4,307 (90,693) 4.53%
44505:Sponsorship 50,000 ‐ ‐ (50,000) 0.00%
Revenue Total 1,050,000 70,076 147,601 (902,399) 14.06%
Expense
Personnel 435,456 33,670 81,125 354,331 18.63%
Operations 1,014,085 31,823 252,374 761,711 24.89%
Transfers 28,634 28,634 28,634 ‐ 100.00%
Expense Total 1,478,175 94,127 362,133 1,116,042 24.50%
Excess (Deficiency) of Total Revenue over Total
Requirements (428,175) (24,051) (214,532) (642,707) 50.10%
Ending Fund Balance 854,742 1,068,385
Reserves
Contingency Reserve 305,771 305,771
Reserve Total 305,771 ‐ 305,771 ‐ ‐
Avaiable Fund Balance 548,971 762,614
Actuals Budget vs. Actuals
15
COG ‐ Airport Operations Financial Report
Period: Dec‐20
Budget Period
FY2021 Dec‐20
YTD Actuals
w/Encumbrances Variance % Variance
Beginning Fund Balance 1,428,114 1,428,114 ‐ 100.00%
Operating Revenue
40001:Property Taxes 40,000 ‐ (57,018) (97,018) ‐142.54%
42001:Interest Income 3,000 270 1,577 (1,423) 52.58%
43606:Airport Charges 3,408,500 275,873 841,470 (2,567,030) 24.69%
Operating Revenue Total 3,451,500 276,142 786,030 (2,665,470) 22.77%
Operarting Expense
Personnel 429,433 37,492 97,868 331,565 22.79%
Operations 3,138,013 ‐ 3,402,441 (264,428) 108.43%
Operating Capital 354,067 1,006 1,006 353,061 0.28%
Operating Expense Total 3,921,513 249,906 3,712,722 208,791 94.68%
Total Net Operations (470,013) 26,236 (2,926,692) (2,874,260) 622.68%
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 ‐ ‐ 158,931 0.00%
Non‐Operating Expense Total 908,931 ‐ ‐ 908,931 0.00%
Net Non‐Operations Total (203,931) ‐ ‐ 203,931 0.00%
Excess (Deficiency) of Total Revenue over Total Requirements (673,944) 26,236 (2,926,692) (3,600,636) 534.26%
Ending Fund Balance 754,170 26,236 (1,498,578) (744,408) ‐50.33%
Reserves
Contingency Reserve 332,917 332,917 332,917 ‐ 100%
Debt Service Reserve 141,478 141,478 141,478 ‐ 100%
Reserves Total 474,395 474,395 474,395 ‐ 100%
Available Fund Balance 279,775 (1,972,973) (2,252,749) ‐14.18%
YTD Actuals Budget Vs. Actuals
16
COG ‐ GTEC Financial Report
Period: Dec‐20
Budget Period
FY2021 Dec‐20
YTD Actuals
w/Encumbrances Variance % Variance
Beginning Fund Balance 26,022,482 26,022,482 26,022,482 ‐ 100.00%
Operating Revenue
40002:Sales Taxes 8,255,000 782,980 811,070 (7,443,930) 9.83%
42001:Interest Income 60,000 3,027 10,194 (49,806) 16.99%
Operating Revenue Total 8,315,000 786,006 821,264 (7,493,736) 9.88%
Operarting Expense
Operations 402,962 33,514 240,817 162,145 59.76%
Operating Capital ‐ ‐ 4,140 (4,140) 0.00%
Transfers 2,763,242 ‐ ‐ 2,763,242 0.00%
Operating Expense Total 3,166,204 33,514 244,957 2,921,247 7.74%
1% #DIV/0!
Total Net Operations 5,148,796 752,493 576,307 (10,414,983) 11.19%
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 115,414 328,802 22,748,012 1.42%
Debt Service 1,053,050 ‐ ‐ 1,053,050 0.00%
Non‐Operating Expense Total 26,114,238 115,414 328,802 25,785,437 1.26%
Net Non‐Operations Total (15,514,238) (115,414) (328,802) 15,185,437 2.12%
Excess (Deficiency) of Total Revenue over Total Requirements (10,365,442) 637,079 247,505 (10,117,937) 97.61%
Ending Fund Balance 15,657,040 26,659,561 26,269,987 41,927,027 59.60%
Reserves
Contingency Reserve 1,984,375 1,984,375 1,984,375 ‐ 100%
Debt Service Reserve 3,494,232 3,494,232 3,494,232 ‐ 100%
Reserves Total 5,478,607 5,478,607 5,478,607 ‐ 100%
Available Fund Balance 10,178,433 20,791,380 10,612,947 48.96%
YTD Actuals Budget Vs. Actuals
17
COG ‐ GEDCO Financial Report
Period: Dec‐20
Budget Period
FY2021 Dec‐20
YTD Actuals
w/Encumbrances Variance % Variance
Beginning Fund Balance 8,845,777 8,845,777 8,845,777 ‐ 100.00%
Operating Revenue
40002:Sales Taxes 2,063,750 195,745 202,767 (1,860,983) 9.83%
42001:Interest Income 19,000 630 10,897 (8,103) 57.35%
Operating Revenue Total 2,082,750 196,375 213,664 (1,869,086) 10.26%
Operarting Expense
Operations 593,783 29,649 146,368 447,415 24.65%
Transfers 1,200,169 ‐ ‐ 1,200,169 0.00%
Operating Expense Total 1,793,952 29,649 146,368 1,647,584 8.16%
Total Net Operations 288,798 166,726 67,297 (3,516,670) 23.30%
Non‐Operating Revenue
Non‐Operating Expense
Operations 8,256,391 ‐ ‐ 8,256,391 0.00%
Debt Service 90,572 ‐ ‐ 90,572 0.00%
Non‐Operating Expense Total 8,346,963 ‐ ‐ 8,346,963 0.00%
Net Non‐Operations Total (8,346,963) ‐ ‐ 8,346,963 0.00%
Excess (Deficiency) of Total Revenue over Total Requirements (8,058,165) 166,726 67,297 (7,990,869) 99.16%
Ending Fund Balance 787,612 9,012,503 8,913,074 9,700,686 8.84%
Reserves
Contingency Reserve 505,468 505,468 505,468 ‐ 100%
Debt Service Reserve 413,087 413,087 413,087 ‐ 100%
Non‐Operational Reserve (210,318) ‐ (210,318) ‐ 100%
Reserves Total 708,237 918,555 708,237 ‐ 100%
Available Fund Balance 79,375 8,204,837 8,125,462 0.97%
YTD Actuals Budget Vs. Actuals
18
CITY
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
December 31, 2020
Prepared by
Valley View Consulting, L.L.C.
________________________________________________________________________
Elaine Wilson Leigh Wallace
Controller Finance Director
___________________________________
Karrie Pursley
Treasurer
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.
19
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Demand Accounts 9,505,298$ 9,505,298 15,461,481$ 15,461,481$ 0.27%
NOW/MMA 15,087,991 15,087,991 12,024,426 12,024,426 0.31%
Pools 103,065,896 103,065,896 108,820,032 108,820,032 0.08%
CDs/Securities 112,639,369 112,640,201 122,010,850 122,010,850 0.65%Totals 240,298,554$ 240,299,385$ 258,316,790$ 258,316,790$ 0.37%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.37%Total Portfolio 0.37%
Rolling Three Month Treasury 0.09%Rolling Three Month Treasury 0.09%
Rolling Six Month Treasury 0.12%Rolling Six Month Treasury 0.12%
TexPool 0.09%TexPool 0.09%
Bank Fees Offset
8,111$
Interest earnings provided in separate report.8,111$
September 30, 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
December 31, 2020
City of Georgetown Valley View Consulting, L.L.C.20
Economic Overview12/31/2020 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 2024. Second estimate of Third Quarter GDP was finalized at +33.4%, but still remains 3.5% below pre-pandemic levels. Crude oil traded above $50 per barrel. Employment/ Unemployment continues modest improvement. The Stock Markets reached new highs. Housing continues adding positive economic activity. Additional fiscal stimulus passed and was signed by the President. The Yield Curve steepened slightly from last quarter end.02505007501,0001,2501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,000S&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.501.001.502.002.50Treasury Yield CurvesDecember 31, 2019September 30, 2020December 31, 20200.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.21
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.27%01/01/21 12/31/20 15,461,481$ 15,461,481$ 1.00 15,461,481$ 1 0.27%
JPMorgan Chase MMA 0.03%01/01/21 12/31/20 434,016 434,016 1.00 434,016 1 0.03%
Veritex Bank MMA 0.14%01/01/21 12/31/20 3,212,254 3,212,254 1.00 3,212,254 1 0.14%
NexBank MMA 0.45%01/01/21 12/31/20 7,364,008 7,364,008 1.00 7,364,008 1 0.45%
Origin Bank MMA 0.00%01/01/21 12/31/20 1,014,148 1,014,148 1.00 1,014,148 1 0.00%
TexPool AAAm 0.09%01/01/21 12/31/20 44,199,066 44,199,066 1.00 44,199,066 1 0.09%
TexSTAR AAAm 0.07%01/01/21 12/31/20 64,620,967 64,620,967 1.00 64,620,967 1 0.07%
East West Bank CD 1.71%01/08/21 01/08/20 3,050,882 3,050,882 100.00 3,050,882 8 1.72%
Independent Bank CD 1.70%02/05/21 02/05/20 3,139,621 3,139,621 100.00 3,139,621 36 1.71%
Independent Bank CD 0.60%02/08/21 05/08/20 11,033,296 11,033,296 100.00 11,033,296 39 0.60%
East West Bank CD 0.32%02/18/21 08/18/20 9,010,737 9,010,737 100.00 9,010,737 49 0.32%
R Bank CD 1.81%02/19/21 02/19/20 4,054,719 4,054,719 100.00 4,054,719 50 1.83%
Bank OZK CD 1.72%02/26/21 02/27/20 6,086,273 6,086,273 100.00 6,086,273 57 1.73%
Southside Bank CD 0.21%03/11/21 09/11/20 5,002,618 5,002,618 100.00 5,002,618 70 0.21%
Bank OZK CD 0.25%03/11/21 09/11/20 1,500,935 1,500,935 100.00 1,500,935 70 0.25%
East West Bank CD 0.29%03/15/21 09/14/20 3,503,032 3,503,032 100.00 3,503,032 74 0.29%
Prosperity Bank CD 0.45%04/01/21 07/01/20 4,006,098 4,006,098 100.00 4,006,098 91 0.45%
Independent Bank CD 1.80%04/22/21 10/22/19 4,174,339 4,174,339 100.00 4,174,339 112 1.81%
Bank OZK CD 0.70%05/10/21 05/08/20 12,049,407 12,049,407 100.00 12,049,407 130 0.70%
Southside Bank CD 0.22%06/11/21 09/11/20 5,002,742 5,002,742 100.00 5,002,742 162 0.22%
Bank OZK CD 0.30%06/11/21 09/11/20 5,003,741 5,003,741 100.00 5,003,741 162 0.30%
Prosperity Bank CD 0.60%07/01/21 07/01/20 4,006,033 4,006,033 100.00 4,006,033 182 0.60%
Prosperity Bank CD 0.70%07/15/21 07/15/20 5,008,798 5,008,798 100.00 5,008,798 196 0.70%
East West Bank CD 0.32%08/18/21 08/18/20 2,002,386 2,002,386 100.00 2,002,386 230 0.32%
Prosperity Bank CD 0.40%08/23/21 08/21/20 6,251,322 6,251,322 100.00 6,251,322 235 0.40%
East West Bank CD 0.26%09/09/21 12/09/20 4,069,844 4,069,844 100.00 4,069,844 252 0.26%
Prosperity Bank CD 0.30%10/14/21 10/14/20 2,501,250 2,501,250 100.00 2,501,250 287 0.30%
Independent Bank CD 0.40%10/18/21 10/18/20 2,546,598 2,546,598 100.00 2,546,598 291 0.40%
Prosperity Bank CD 0.30%11/22/21 11/20/20 3,000,738 3,000,738 100.00 3,000,738 326 0.30%
East West Bank CD 0.21%12/30/21 12/30/20 3,000,035 3,000,035 100.00 3,000,035 364 0.21%
Prosperity Bank CD 0.30%01/21/22 10/21/20 4,002,000 4,002,000 100.00 4,002,000 386 0.30%
Prosperity Bank CD 0.35%04/21/22 10/21/20 2,501,459 2,501,459 100.00 2,501,459 476 0.35%
December 31, 2020
City of Georgetown Valley View Consulting, L.L.C.22
City - Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
December 31, 2020
Prosperity Bank CD 0.35%05/17/22 11/17/20 2,000,574 2,000,574 100.00 2,000,574 502 0.35%
Prosperity Bank CD 0.35%08/22/22 11/20/20 2,500,717 2,500,717 100.00 2,500,717 599 0.35%
Prosperity Bank CD 0.40%11/17/22 11/17/20 2,000,656 2,000,656 100.00 2,000,656 686 0.40%
TOTALS 258,316,790$ 258,316,790$ 258,316,790$ 82 0.37%
(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.23
0–6 Months84%6–12 Months13%12–18 Months3%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,00003/31/20 06/30/20 09/30/20 12/31/20Portfolio BalancesMoney MarketLocal DepositoryTexSTARTexPoolCertificate of DepositUS Treasury166174166102699073751091041231561639710887516749419173615499711249510080706763588182050100150200# of DaysWeighted Average to MaturityJPMorgan Chase6%Southside Bank 4%Prosperity Bank15%Veritex Bank 1%Bank OZK10%NexBank3%TexPool17%TexSTAR25%IndependentBank8%Origin Bank0%East West Bank9%R Bank2%T-Bill0%Portfolio Holdings by IssuerCity of GeorgetownValley View Consulting, L.L.C.24
City - Book & Market Value Comparison
Issuer/Description Yield Maturity
Date
Book Value
09/30/20 Increases Decreases Book Value
12/31/20
Market Value
09/30/20
Change in
Market Value
Market Value
12/31/20
JPMorgan Chase Cash 0.27%01/01/21 9,505,298$ 5,956,183$ –$ 15,461,481$ 9,505,298$ 5,956,183$ 15,461,481$
JPMorgan Chase MMA 0.03%01/01/21 433,983 33 – 434,016 433,983 33 434,016
Veritex Bank MMA 0.14%01/01/21 3,210,906 1,348 – 3,212,254 3,210,906 1,348 3,212,254
NexBank MMA 0.45%01/01/21 7,355,685 8,324 – 7,364,008 7,355,685 8,324 7,364,008
Origin Bank MMA 0.00%01/01/21 4,087,417 – (3,073,268) 1,014,148 4,087,417 (3,073,268) 1,014,148
TexPool 0.09%01/01/21 28,793,102 15,405,963 – 44,199,066 28,793,102 15,405,963 44,199,066
TexSTAR 0.07%01/01/21 74,272,794 – (9,651,827) 64,620,967 74,272,794 (9,651,827) 64,620,967
T-Bill 1.60%10/08/20 2,499,139 – (2,499,139) – 2,499,970 (2,499,970) –
Independent Bank CD 1.86%10/18/20 2,534,811 – (2,534,811) – 2,534,811 (2,534,811) –
East West Bank CD 0.55%11/09/20 3,006,607 – (3,006,607) – 3,006,607 (3,006,607) –
Independent Bank CD 2.58%11/10/20 1,032,494 – (1,032,494) – 1,032,494 (1,032,494) –
R Bank CD 1.78%11/19/20 2,521,930 – (2,521,930) – 2,521,930 (2,521,930) –
Southside Bank CD 1.73%11/19/20 3,258,686 – (3,258,686) – 3,258,686 (3,258,686) –
East West Bank CD 1.72%12/09/20 4,056,045 – (4,056,045) – 4,056,045 (4,056,045) –
East West Bank CD 1.72%01/08/21 3,037,761 13,121 – 3,050,882 3,037,761 13,121 3,050,882
Independent Bank CD 1.71%02/05/21 3,126,261 13,359 – 3,139,621 3,126,261 13,359 3,139,621
Independent Bank CD 0.60%02/08/21 11,016,636 16,661 – 11,033,296 11,016,636 16,661 11,033,296
East West Bank CD 0.32%02/18/21 9,003,472 7,265 – 9,010,737 9,003,472 7,265 9,010,737
R Bank CD 1.83%02/19/21 4,036,263 18,456 – 4,054,719 4,036,263 18,456 4,054,719
Bank OZK CD 1.73%02/26/21 6,060,233 26,040 – 6,086,273 6,060,233 26,040 6,086,273
Southside Bank CD 0.21%03/11/21 5,000,000 2,618 – 5,002,618 5,000,000 2,618 5,002,618
Bank OZK CD 0.25%03/11/21 1,500,000 935 – 1,500,935 1,500,000 935 1,500,935
East West Bank CD 0.29%03/15/21 3,500,473 2,560 – 3,503,032 3,500,473 2,560 3,503,032
Prosperity Bank CD 0.45%04/01/21 4,004,525 1,574 – 4,006,098 4,004,525 1,574 4,006,098
Independent Bank CD 1.81%04/22/21 4,155,537 18,802 – 4,174,339 4,155,537 18,802 4,174,339
Bank OZK CD 0.70%05/10/21 12,028,372 21,034 – 12,049,407 12,028,372 21,034 12,049,407
Southside Bank CD 0.22%06/11/21 5,000,000 2,742 – 5,002,742 5,000,000 2,742 5,002,742
Bank OZK CD 0.30%06/11/21 5,000,000 3,741 – 5,003,741 5,000,000 3,741 5,003,741
Prosperity Bank CD 0.60%07/01/21 4,006,033 – – 4,006,033 4,006,033 – 4,006,033
Prosperity Bank CD 0.70%07/15/21 5,007,459 1,339 – 5,008,798 5,007,459 1,339 5,008,798
East West Bank CD 0.32%08/18/21 2,000,772 1,614 – 2,002,386 2,000,772 1,614 2,002,386
Prosperity Bank CD 0.40%08/23/21 6,245,860 5,463 – 6,251,322 6,245,860 5,463 6,251,322
East West Bank CD 0.26%09/09/21 – 4,069,844 – 4,069,844 – 4,069,844 4,069,844
Prosperity Bank CD 0.30%10/14/21 – 2,501,250 – 2,501,250 – 2,501,250 2,501,250
Independent Bank CD 0.40%10/18/21 – 2,546,598 – 2,546,598 – 2,546,598 2,546,598
Prosperity Bank CD 0.30%11/22/21 – 3,000,738 – 3,000,738 – 3,000,738 3,000,738
East West Bank CD 0.21%12/30/21 – 3,000,035 – 3,000,035 – 3,000,035 3,000,035
Prosperity Bank CD 0.30%01/21/22 – 4,002,000 – 4,002,000 – 4,002,000 4,002,000
Prosperity Bank CD 0.35%04/21/22 – 2,501,459 – 2,501,459 – 2,501,459 2,501,459
City of Georgetown Valley View Consulting, L.L.C.25
City - Book & Market Value Comparison
Issuer/Description Yield Maturity
Date
Book Value
09/30/20 Increases Decreases Book Value
12/31/20
Market Value
09/30/20
Change in
Market Value
Market Value
12/31/20
Prosperity Bank CD 0.35%05/17/22 – 2,000,574 – 2,000,574 – 2,000,574 2,000,574
Prosperity Bank CD 0.35%08/22/22 – 2,500,717 – 2,500,717 – 2,500,717 2,500,717
Prosperity Bank CD 0.40%11/17/22 – 2,000,656 – 2,000,656 – 2,000,656 2,000,656
TOTAL / AVERAGE 0.37%240,298,554$ 49,653,044$ (31,634,808)$ 258,316,790$ 240,299,385$ 18,017,404$ 258,316,790$
City of Georgetown Valley View Consulting, L.L.C.26
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 – – – – –
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 – – – – –
East West Bank CD 08/18/21 2,002,386 – – – – – –
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$
Book Value
December 31, 2020
City of Georgetown Valley View Consulting, L.L.C.27
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
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
East West Bank CD 08/18/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
Book Value
December 31, 2020
(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 GO-
Sidewalks
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698 68,600 1,429,101 1,456,708 254,936 178,433 –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698$ 68,600$ 1,429,101$ 1,456,708$ 254,936$ 178,433$ –$
City of Georgetown Valley View Consulting, L.L.C.28
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
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
East West Bank CD 08/18/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
Book Value
December 31, 2020
(Continued)
2017 Revenue
Electric
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– 1,014,148 – – – – -
– – – – – – –
97,374 3,241,881 56,694 672,254 482,661 9,137,064 3,936,963
– – – – – – –
– – – – – – –
– 3,009,081 – – – – –
– 3,003,579 – – – – 3,003,579
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– 2,008,234 – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
97,374$ 12,276,924$ 56,694$ 672,254$ 482,661$ 9,137,064$ 6,940,543$
City of Georgetown Valley View Consulting, L.L.C.29
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
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
East West Bank CD 08/18/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
Book Value
December 31, 2020
(Continued)
2019 CO-
Stormwater
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
113,952 1,961,455 2,602,887 650,566 8,708,689 1,241,086 7,169,062 3,479,865
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– 2,002,386 – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
113,952$ 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.30
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 – – – – –
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 – – – – –
East West Bank CD 08/18/21 2,002,386 – – – – – –
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.31
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
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
East West Bank CD 08/18/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 GO-
Sidewalks
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698 68,600 1,429,101 1,456,708 254,936 178,433 –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698$ 68,600$ 1,429,101$ 1,456,708$ 254,936$ 178,433$ –$
City of Georgetown Valley View Consulting, L.L.C.32
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
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
East West Bank CD 08/18/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
Electric
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– 1,014,148 – – – – –
– – – – – – –
97,374 3,241,881 56,694 672,254 482,661 9,137,064 3,936,963
– – – – – – –
– – – – – – –
– 3,009,081 – – – – –
– 3,003,579 – – – – 3,003,579
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– 2,008,234 – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
97,374$ 12,276,924$ 56,694$ 672,254$ 482,661$ 9,137,064$ 6,940,543$
City of Georgetown Valley View Consulting, L.L.C.33
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
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
East West Bank CD 08/18/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 CO-
Stormwater
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
113,952 1,961,455 2,602,887 650,566 8,708,689 1,241,086 7,169,062 3,479,865
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– 2,002,386 – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
113,952$ 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.34
City - Allocation
Investment
Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
JPMorgan Chase Cash 9,505,298$ 9,505,298$ –$ –$ –$ –$
JPMorgan Chase MMA 433,983 433,983 – – – –
Veritex Bank MMA 3,210,906 3,210,906 – – – –
NexBank MMA 7,355,685 7,355,685 – – – –
Origin Bank MMA 4,087,417 1,025,806 – – – –
TexPool 28,793,102 28,793,102 – – – –
TexSTAR 74,272,794 9,714,325 584,095 2,180,032 137,262 111,001
T-Bill 10/08/20 2,499,139 2,499,139 – – – –
Independent Bank CD 10/18/20 2,534,811 2,534,811 – – – –
East West Bank CD 11/09/20 3,006,607 3,006,607 – – – –
Independent Bank CD 11/10/20 1,032,494 1,032,494 – – – –
R Bank CD 11/19/20 2,521,930 2,521,930 – – – –
Southside Bank CD 11/19/20 3,258,686 3,258,686 – – – –
East West Bank CD 12/09/20 4,056,045 4,056,045 – – – –
East West Bank CD 01/08/21 3,037,761 3,037,761 – – – –
Independent Bank CD 02/05/21 3,126,261 3,126,261 – – – –
Independent Bank CD 02/08/21 11,016,636 8,012,099 – – – –
East West Bank CD 02/18/21 9,003,472 3,001,157 – – – –
R Bank CD 02/19/21 4,036,263 4,036,263 – – – –
Bank OZK CD 02/26/21 6,060,233 6,060,233 – – – –
Southside Bank CD 03/11/21 5,000,000 5,000,000 – – – –
Bank OZK CD 03/11/21 1,500,000 1,500,000 – – – –
East West Bank CD 03/15/21 3,500,473 3,500,473 – – – –
Prosperity Bank CD 04/01/21 4,004,525 4,004,525 – – – –
Independent Bank CD 04/22/21 4,155,537 4,155,537 – – – –
Bank OZK CD 05/10/21 12,028,372 10,023,644 – – – –
Southside Bank CD 06/11/21 5,000,000 5,000,000 – – – –
Bank OZK CD 06/11/21 5,000,000 5,000,000 – – – –
Prosperity Bank CD 07/01/21 4,006,033 4,006,033 – – – –
Prosperity Bank CD 07/15/21 5,007,459 5,007,459 – – – –
East West Bank CD 08/18/21 2,000,772 – – – – –
Prosperity Bank CD 08/23/21 6,245,860 6,245,860 – – – –
Totals 240,298,554$ 159,666,122$ 584,095$ 2,180,032$ 137,262$ 111,001$
September 30, 2020
Book Value
City of Georgetown Valley View Consulting, L.L.C.35
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
T-Bill 10/08/20
Independent Bank CD 10/18/20
East West Bank CD 11/09/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
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
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
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
Totals
September 30, 2020
Book Value
(Continued)
2015 GO-
Roads
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
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,508,021 1,531,341 68,584 1,451,130 1,503,917 318,392 178,392
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,508,021$ 1,531,341$ 68,584$ 1,451,130$ 1,503,917$ 318,392$ 178,392$
City of Georgetown Valley View Consulting, L.L.C.36
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
T-Bill 10/08/20
Independent Bank CD 10/18/20
East West Bank CD 11/09/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
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
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
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
Totals
September 30, 2020
Book Value
(Continued)
2017 GO-
Sidewalks
2017 Revenue
Electric
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – 1,009,942 – – – –
– – – – – – –
– 97,352 3,839,337 56,681 672,097 497,544 11,241,692
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – 3,004,537 – – – –
– – 3,001,157 – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – 2,004,729 – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
–$ 97,352$ 12,859,703$ 56,681$ 672,097$ 497,544$ 11,241,692$
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
T-Bill 10/08/20
Independent Bank CD 10/18/20
East West Bank CD 11/09/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
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
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
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
Totals
September 30, 2020
Book Value
(Continued)
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
2,051,669 – – – – – –
– – – – – – –
2,645,268 113,926 2,003,965 2,603,558 650,415 8,955,332 3,501,541
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,001,157 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – 2,000,772 – – – –
– – – – – – –
7,698,094$ 113,926$ 4,004,737$ 2,603,558$ 650,415$ 8,955,332$ 3,501,541$
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
T-Bill 10/08/20
Independent Bank CD 10/18/20
East West Bank CD 11/09/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
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
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
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
Totals
September 30, 2020
Book Value
(Continued)
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$
– –
– –
– –
– –
– –
7,447,141 9,660,452
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
7,447,141$ 9,660,452$
City of Georgetown Valley View Consulting, L.L.C.39
City - Allocation
September 30, 2020
Market Value Investment
Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
JPMorgan Chase Cash 9,505,298$ 9,505,298$ –$ –$ –$ –$
JPMorgan Chase MMA 433,983 433,983 – – – –
Veritex Bank MMA 3,210,906 3,210,906 – – – –
NexBank MMA 7,355,685 7,355,685 – – – –
Origin Bank MMA 4,087,417 1,025,806 – – – –
TexPool 28,793,102 28,793,102 – – – –
TexSTAR 74,272,794 9,714,325 584,095 2,180,032 137,262 111,001
T-Bill 10/08/20 2,499,970 2,499,970 – – – –
Independent Bank CD 10/18/20 2,534,811 2,534,811 – – – –
East West Bank CD 11/09/20 3,006,607 3,006,607 – – – –
Independent Bank CD 11/10/20 1,032,494 1,032,494 – – – –
R Bank CD 11/19/20 2,521,930 2,521,930 – – – –
Southside Bank CD 11/19/20 3,258,686 3,258,686 – – – –
East West Bank CD 12/09/20 4,056,045 4,056,045 – – – –
East West Bank CD 01/08/21 3,037,761 3,037,761 – – – –
Independent Bank CD 02/05/21 3,126,261 3,126,261 – – – –
Independent Bank CD 02/08/21 11,016,636 8,012,099 – – – –
East West Bank CD 02/18/21 9,003,472 3,001,157 – – – –
R Bank CD 02/19/21 4,036,263 4,036,263 – – – –
Bank OZK CD 02/26/21 6,060,233 6,060,233 – – – –
Southside Bank CD 03/11/21 5,000,000 5,000,000 – – – –
Bank OZK CD 03/11/21 1,500,000 1,500,000 – – – –
East West Bank CD 03/15/21 3,500,473 3,500,473 – – – –
Prosperity Bank CD 04/01/21 4,004,525 4,004,525 – – – –
Independent Bank CD 04/22/21 4,155,537 4,155,537 – – – –
Bank OZK CD 05/10/21 12,028,372 10,023,644 – – – –
Southside Bank CD 06/11/21 5,000,000 5,000,000 – – – –
Bank OZK CD 06/11/21 5,000,000 5,000,000 – – – –
Prosperity Bank CD 07/01/21 4,006,033 4,006,033 – – – –
Prosperity Bank CD 07/15/21 5,007,459 5,007,459 – – – –
East West Bank CD 08/18/21 2,000,772 – – – – –
Prosperity Bank CD 08/23/21 6,245,860 6,245,860 – – – –
Totals 240,299,385$ 159,666,953$ 584,095$ 2,180,032$ 137,262$ 111,001$
City of Georgetown Valley View Consulting, L.L.C.40
City - Allocation
September 30, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
T-Bill 10/08/20
Independent Bank CD 10/18/20
East West Bank CD 11/09/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
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
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
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
Totals
(Continued)
2015 GO-
Roads
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
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,508,021 1,531,341 68,584 1,451,130 1,503,917 318,392 178,392
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,508,021$ 1,531,341$ 68,584$ 1,451,130$ 1,503,917$ 318,392$ 178,392$
City of Georgetown Valley View Consulting, L.L.C.41
City - Allocation
September 30, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
T-Bill 10/08/20
Independent Bank CD 10/18/20
East West Bank CD 11/09/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
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
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
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
Totals
(Continued)
2017 GO-
Sidewalks
2017 Revenue
Electric
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – 1,009,942 – – – –
– – – – – – –
– 97,352 3,839,337 56,681 672,097 497,544 11,241,692
– – – – – – –
– – – – – – –
– – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – 3,004,537 – – – –
– – 3,001,157 – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – 2,004,729 – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
–$ 97,352$ 12,859,703$ 56,681$ 672,097$ 497,544$ 11,241,692$
City of Georgetown Valley View Consulting, L.L.C.42
City - Allocation
September 30, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
T-Bill 10/08/20
Independent Bank CD 10/18/20
East West Bank CD 11/09/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
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
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
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
Totals
(Continued)
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
2,051,669 – – – – – –
– – – – – – –
2,645,268 113,926 2,003,965 2,603,558 650,415 8,955,332 3,501,541
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,001,157 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – 2,000,772 – – – –
– – – – – – –
7,698,094$ 113,926$ 4,004,737$ 2,603,558$ 650,415$ 8,955,332$ 3,501,541$
City of Georgetown Valley View Consulting, L.L.C.43
City - Allocation
September 30, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
T-Bill 10/08/20
Independent Bank CD 10/18/20
East West Bank CD 11/09/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
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
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
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
Totals
(Continued)
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$
– –
– –
– –
– –
– –
7,447,141 9,660,452
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
7,447,141$ 9,660,452$
City of Georgetown Valley View Consulting, L.L.C.44
Georgetown Economic Development Corporation (GEDCO)
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
December 31, 2020
Prepared by
Valley View Consulting, L.L.C.
________________________________________________________________________
Elaine Wilson Leigh Wallace
Controller Finance Director
___________________________________
Karrie Pursley
Treasurer
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,054$ 2,129,054$ 2,129,948$ 2,129,948$ 0.14%
Pools 5,746,114 5,746,114 6,006,030 6,006,030 0.08%
Certificates of Deposit 2,016,943 2,016,943 2,025,562 2,025,562 1.70%
9,892,111$ 9,892,111$ 10,161,540$ 10,161,540$ 0.41%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.41%Total Portfolio 0.41%
Rolling Three Month Treasury 0.09%Rolling Three Month Treasury 0.09%
Rolling Six Month Treasury 0.12%Rolling Six Month Treasury 0.12%
TexPool 0.09%TexPool 0.09%
Interest income provided in separate report.
September 30, 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.
December 31, 2020
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.46
Economic Overview12/31/2020The 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 2024. Second estimate of Third Quarter GDP was finalized at +33.4%, but still remains 3.5% below pre-pandemic levels. Crude oil traded above $50 per barrel. Employment/ Unemployment continues modest improvement. The Stock Markets reached new highs. Housing continues adding positive economic activity. Additional fiscal stimulus passed and was signed by the President. The Yield Curve steepened slightly from last quarter end.02505007501,0001,2501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,000S&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.501.001.502.002.50Treasury Yield CurvesDecember 31, 2019September 30, 2020December 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.14%01/01/21 12/31/20 2,129,948$ 2,129,948$ 1.00 2,129,948$ 1 0.14%
TexasDAILY AAAm 0.09%01/01/21 12/31/20 2,125,306 2,125,306 1.00 2,125,306 1 0.09%
TexSTAR AAAm 0.07%01/01/21 12/31/20 3,880,724 3,880,724 1.00 3,880,724 1 0.07%
Independent Bank 1.70%02/05/21 02/05/20 2,025,562 2,025,562 100.00 2,025,562 36 1.70%
10,161,540$ 10,161,540$ 10,161,540$ 8 0.41%
(1)(2)
December 31, 2020
(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
21%
Pools
59%
Certificates of
Deposit
20%
GEDCO PORTFOLIO COMPOSITION
$0
$2,000,000
$4,000,000
$6,000,000
$8,000,000
$10,000,000
$12,000,000
03/31/20 06/30/20 09/30/20 12/31/2020
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
09/30/20 Increases Decreases Book Value
12/31/20
Market Value
09/30/20
Change in
Market Value
Market Value
12/31/20
Veritex Bank MMA 0.14%01/01/21 2,129,054$ 894$ –$ 2,129,948$ 2,129,054$ 894$ 2,129,948$
TexasDAILY 0.09%01/01/21 2,124,759 548 – 2,125,306 2,124,759 548 2,125,306
TexSTAR 0.07%01/01/21 3,621,355 259,368 – 3,880,724 3,621,355 259,368 3,880,724
Independent Bank 1.70%02/05/21 2,016,943 8,619 – 2,025,562 2,016,943 8,619 2,025,562
TOTAL / AVERAGE 0.41%9,892,111$ 269,429$ –$ 10,161,540$ 9,892,111$ 269,429$ 10,161,540$
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.50
Georgetown Transportation Enhancement Corporation (GTEC)
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
December 31, 2020
Prepared byValley View Consulting, L.L.C.
________________________________________________________________________
Elaine Wilson Leigh Wallace
Controller Finance Director
___________________________________
Karrie Pursley
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 26,283,802$ 26,283,802$ 28,689,653$ 28,689,653$ 0.09%
CDs/Securities 3,001,377 3,001,377 3,004,002 3,004,002 0.40%Totals 29,285,179$ 29,285,179$ 31,693,655$ 31,693,655$ 0.12%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.12%Total Portfolio 0.12%
Rolling Three Month Treasury 0.09%Rolling Three Month Treasury 0.09%
Rolling Six Month Treasury 0.12%Rolling Six Month Treasury 0.12%
TexPool 0.09%TexPool 0.09%
Interest data provided in separate report.
September 30, 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.
December 31, 2020
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.52
Economic Overview12/31/2020The 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 2024. Second estimate of Third Quarter GDP was finalized at +33.4%, but still remains 3.5% below pre-pandemic levels. Crude oil traded above $50 per barrel. Employment/ Unemployment continues modest improvement. The Stock Markets reached new highs. Housing continues adding positive economic activity. Additional fiscal stimulus passed and was signed by the President. The Yield Curve steepened slightly from last quarter end.02505007501,0001,2501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,000S&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.501.001.502.002.50Treasury Yield CurvesDecember 31, 2019September 30, 2020December 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.09%01/01/21 12/31/20 13,146,323$ 13,146,323$ 1.00 13,146,323$ 1 0.09%
TexSTAR AAAm 0.07%01/01/21 12/31/20 12,855,726 12,855,726 1.00 12,855,726 1 0.07%
Veritex Bank MMA 0.14%01/01/21 12/31/20 2,687,605 2,687,605 1.00 2,687,605 1 0.14%
Prosperity Bank CD 0.40%08/23/21 08/21/20 3,004,002 3,004,002 100.00 3,004,002 235 0.40%
TOTALS 31,693,655$ 31,693,655$ 31,693,655$ 23 0.12%
(1)(2)
December 31, 2020
(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
3/31/2020 6/30/2020 9/30/2020 12/31/2020
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
09/30/20 Increases Decreases Book Value
12/31/20
Market Value
09/30/20
Change in
Market Value
Market Value
12/31/20
TexPool 0.09%01/01/21 10,744,412$ 2,401,911$ –$ 13,146,323$ 10,744,412$ 2,401,911$ 13,146,323$
TexSTAR 0.07%01/01/21 12,852,913 2,813 – 12,855,726 12,852,913 2,813 12,855,726
Veritex Bank MMA 0.14%01/01/21 2,686,477 1,128 – 2,687,605 2,686,477 1,128 2,687,605
Prosperity Bank CD 0.40%08/23/21 3,001,377 2,625 – 3,004,002 3,001,377 2,625 3,004,002
TOTAL / AVERAGE 0.12%29,285,179$ 2,408,476$ –$ 31,693,655$ 29,285,179$ 2,408,476$ 31,693,655$
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 - -
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 279,088.21 209,316.16
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,003.66 -
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 December 31, 2020
Active
57
Capital Improvement Projects Report Q1 2021
Projects Project Budget Encumbrances Total Spend
Remaining
Budget
% of Remaining
Budget
Active Project
Airport
PRJ000197 Hangar Mainenance 240,000 - - 240,000 100.00%
PRJ000198 Pavement Maintenance 60,000 - - 60,000 100.00%
PRJ000199 Wildlife Management 150,000 - - 150,000 100.00%
Airport Total 450,000 - - 450,000 100.00%
CDBG
PRJ000003 17th Street 193,000 - 175,137 17,863 9.26%
CDBG Total 193,000 - 175,137 17,863 9.26%
Electric
PRJ000022 Consultant Engineering 150,000 - 21,352 128,648 85.77%
PRJ000026 Db Wood_Sh29 Intersection 240,000 1,612 172,024 67,976 28.32%
PRJ000036 Electrical System Improvement 100,000 - 57 99,943 99.94%
PRJ000040 Fiber Optic 50,000 - 19,516 30,484 60.97%
PRJ000062 New Development Projects 4,984,180 94,970 4,418,411 565,769 11.35%
PRJ000073 Power Quality Improvements 50,000 - - 50,000 100.00%
PRJ000095 Shell Road Feeders 160,000 279 167,982 (7,982) -4.99%
PRJ000147 Sectionalization Improvements 100,000 - - 100,000 100.00%PRJ000175 I-35 Mobility Project TxDot 200,000 6,770 149,976 50,024 25.01%
PRJ000189 Ronald Reagan - Glasscock Feeder Extension along Hwy 195 -Phase I 560,000 - 1,383 558,617 99.75%
PRJ000192 Ronald Reagan - Glasscock Feeder extension along Hwy 195 - Phase II 591,250 9,000 10,423 580,828 98.24%
PRJ000195 Downtown Overhead Rehab 2,400,000 - - 2,400,000 100.00%
Electric Total 9,585,430 112,630 4,961,125 4,624,305 48.24%
Environmental Services
PRJ000116 Transfer Station 10,838,185 272,420 944,201 9,893,984 91.29%
Environmental Services Total 10,838,185 272,420 944,201 9,893,984 91.29%
Finance
PRJ000038 ERP Project 6,231,654 26,213 5,887,091 344,563 5.53%
Finance Total 6,231,654 26,213 5,887,091 344,563 5.53%
Fire
PRJ000134 SCBA Replacement 880,000 - - 880,000 100.00%
PRJ000135 Cardiac Monitors 483,517 - 483,517 - 0.00%
Fire Total 1,363,517 - 483,517 880,000 64.54%
Fleet
PRJ000124 Radio Replacement 363,278 - - 363,278 100.00%
Fleet Total 363,278 - - 363,278 100.00%
Management Services
PRJ000028 Downtown Parking Expansion 728,510 - 701,947 26,564 3.65%
PRJ000029 Downtown Parking Garage 411,815 297,205 411,815 - 0.00%
PRJ000033 Dtwn Landsping & Public Art 90,000 50,960 56,706 33,294 36.99%PRJ000037 EOC Siren System 15,525 15,525 15,525 - 0.00%
PRJ000042 Fire Station 6 5,861,202 33,993 5,339,145 522,056 8.91%
PRJ000043 Fire Station 7 8,510,469 57,625 6,469,602 2,040,867 23.98%
PRJ000067 Parking Improvements 68,510 - - 68,510 100.00%
PRJ000131 Fuel Station 1,100,000 - - 1,100,000 100.00%
PRJ000136 GMC Remodel Phase I 250,000 - - 250,000 100.00%
PRJ000178 Public Safety Operation and Training Center Phase II 4,500,000 - - 4,500,000 100.00%
PRJ000179 Recreation Center Teen/Senior Renovation 200,000 - - 200,000 100.00%
PRJ000180 Recreation Center Natatorium HVAC Replacement 700,000 586,721 622,163 77,837 11.12%
PRJ000184 Airport Maintenance Facility 700,000 - - 700,000 100.00%
PRJ000191 Georgetown City Center - Festival/Public Space 5,400,000 - - 5,400,000 100.00%
PRJ000223 City Center Signage 125,000 - - 125,000 100.00%
Management Services Total 28,661,031 1,042,029 13,616,903 15,044,128 52.49%
Parks
PRJ000048 Garey Park 15,344,472 - 15,100,250 244,222 1.59%
PRJ000050 Grace Heritage Plaza 139,100 - 45,900 93,200 67.00%
PRJ000089 San Gabriel Park Improvement 13,025,000 115,404 7,448,252 5,576,748 42.82%
PRJ000125 Parks Master Plan 200,000 - - 200,000 100.00%PRJ000126 Regional Trail Development 2,775,000 84,522 128,600 2,646,400 95.37%
PRJ000127 Neighborhood Park Development 1,250,000 - 237,541 1,012,459 81.00%
PRJ000129 Ada Transition Plan 900,405 - 275,982 624,423 69.35%
PRJ000130 Tennis Center Pool Demo 70,000 - 36,576 33,424 47.75%PRJ000190 Heritage Gardens 250,000 - 7,470 242,530 97.01%
PRJ000205 Katy Crossing Trail 700,000 17,780 517,961 182,039 26.01%
Parks Total 34,653,977 217,706 23,798,533 10,855,444 31.33%
Police
PRJ000133 Body Cameras 802,000 - 737,412 64,588 8.05%
Police Total 802,000 - 737,412 64,588 8.05%
Right of Way
PRJ000200 Access Rtw To Government Srv 220,000 - 220,000 - 0.00%
Right of Way Total 220,000 - 220,000 - 0.00%
Stormwater
PRJ000004 18th and Hutto Drainage 50,000 - 5,969 44,031 88.06%
PRJ000005 2nd and Rock Pond 625,000 - 447,151 177,849 28.46%
PRJ000104 Stormwater Infrastructure 347,000 109,558 168,506 178,495 51.44%
PRJ000148 Water Quality Ponds 98,000 - - 98,000 100.00%
PRJ000149 Drainage Improvement/Flood Mitigation Projects 300,000 - - 300,000 100.00%
PRJ000213 2021 Curb & Gutter Project 763,925 50,850 380,147 383,778 50.24%
58
Capital Improvement Projects Report Q1 2021
Projects Project Budget Encumbrances Total Spend
Remaining
Budget
% of Remaining
Budget
Stormwater Total 2,183,925 160,408 1,001,773 1,182,152 54.13%
Water
PRJ000014 Berry Creek Inter.49,949,000 19,031 126,902 49,822,098 99.75%
PRJ000016 Braun Est 4,750,000 - 1,202,760 3,547,240 74.68%
PRJ000017 Cedar Breaks Est 3,385,000 - - 3,385,000 100.00%
PRJ000023 Cr 255 (Wd14-2)1,493,963 - - 1,493,963 100.00%
PRJ000025 Db Wood/ Pastor 24 Dedicated 5,286,000 0 423,726 4,862,274 91.98%
PRJ000034 Earz 2,326,000 129,479 433,423 1,892,577 81.37%
PRJ000057 Lift Station Upgrade 1,100,000 - - 1,100,000 100.00%
PRJ000059 LWTP Raw Water Intake Rehab 18,750,000 1,833,498 4,250,998 14,499,002 77.33%
PRJ000066 Park Lift Station & Force Main 3,574,341 884,897 2,097,586 1,476,755 41.32%
PRJ000069 Pecan Branch Ph 2 253,000 - 232,521 20,479 8.09%
PRJ000075 Pumps & Storage 1,000,000 - 9,289 990,711 99.07%
PRJ000076 Rabbit Hill Est 1,826,000 - - 1,826,000 100.00%
PRJ000085 Ronald Reagan/Daniels Mountain 4,400,000 29,592 167,638 4,232,362 96.19%PRJ000088 San Gabriel Belt Press and Rehab 3,200,000 74,902 2,522,973 677,027 21.16%
PRJ000096 Shell Road Water Line 6,890,000 - 856,000 6,034,000 87.58%
PRJ000101 Southlake Wtp 100,000,000 5,286,539 7,201,000 92,799,000 92.80%
PRJ000119 Water Mains 1,637,000 19,872 386,765 1,250,235 76.37%PRJ000123 WW Interceptors 608,431 - - 608,431 100.00%
PRJ000150 Carriage Oaks Transmission 500,000 - - 500,000 100.00%
PRJ000151 FY2020 CR262 Waterline 500,000 - - 500,000 100.00%
PRJ000152 FY2020 Hoover Pump Station 855,221 761,343 855,221 - 0.00%
PRJ000154 FY2020 Stonewall Ranch Ps Improvements 500,000 - - 500,000 100.00%
PRJ000155 FY2020 Southside Water Treatment Plant 2,250,000 - - 2,250,000 100.00%
PRJ000156 FY2020 Gatlin/Teravista Improvements 450,000 - - 450,000 100.00%
PRJ000157 Leander Interconnect 450,000 10,564 49,495 400,505 89.00%
PRJ000158 West loop (H-1A)2,119,000 - 447,385 1,671,615 78.89%
PRJ000160 FY2020 Round Rock Supply Pump Station And Elevated Storage Tank 9,200,000 915,602 1,427,473 7,772,527 84.48%
PRJ000161 Miscellaneous Line Upgrades 872,000 247,173 636,126 235,874 27.05%
PRJ000162 South West Bypass Water (H24-1)2,906,000 23,998 1,314,809 1,591,191 54.76%
PRJ000163 Tank Rehabilitation 2,905,000 267,748 406,056 2,498,944 86.02%
PRJ000164 Council Chamber Water 423,000 - 15,960 407,040 96.23%
PRJ000165 San Gabriel Wwtp Rehab 2,500,000 12,325 98,000 2,402,000 96.08%
PRJ000167 San Gabriel Inter SGI -2 4,500,000 912,755 912,755 3,587,245 79.72%
PRJ000168 WWTP Upgrade 1,150,000 - - 1,150,000 100.00%
PRJ000177 Northlake WTP Phase IV Expansion 15,000,000 11,762,116 11,859,923 3,140,077 20.93%
PRJ000185 Cimarron Hills Wastewater Treatment Plant Expansion 600,000 - - 600,000 100.00%
PRJ000186 Water Oak 24" Waterline 3,500,000 - - 3,500,000 100.00%
PRJ000218 EARZ Wastewater Rehabilitation Area 2 - 2019 2,460,360 2,460,360 2,460,360 - 0.00%
PRJ000220 AMI Western District Improvements 750,000 - - 750,000 100.00%
Water Total 264,819,316 25,651,791 40,395,143 224,424,173 84.75%
GTEC
PRJ000046 FM 971/ Fontana (Nw Bridge)1,209,000 - 1,193,000 16,000 1.32%
PRJ000053 IH 35/ Hwy 29 Intersection Imp 1,800,000 - 120,066 1,679,934 93.33%PRJ000060 Rabbit Hill Road 4,100,000 - 88,429 4,011,571 97.84%
PRJ000083 Rivery Tia Improvements 1,179,000 16,131 1,110,970 68,030 5.77%
PRJ000145 Sh29 Signal And Roadway Improvements 1,595,000 105,366 312,671 1,282,329 80.40%
PRJ000181 Aviation Drive 10,300,000 - - 10,300,000 100.00%
PRJ000182 Confido III 600,000 - - 600,000 100.00%
PRJ000183 Big C Project 2,000,000 - - 2,000,000 100.00%
PRJ000203 FM1460 Widening 20,000 - - 20,000 100.00%
PRJ000206 NB Front Rd (2338 To Lakeway)216,000 - 221,766 (5,766) -2.67%
GTEC Total 23,019,000 121,497 3,046,902 19,972,098 86.76%
Public Works
PRJ000013 Austin Avenue Bridge 2,855,398 10,626 1,711,203 1,144,195 40.07%
PRJ000100 Southeast Inner Loop 3,321,000 - - 3,321,000 100.00%
PRJ000137 Intersection Improvements (Lakeway @ Williams Drive)1,400,000 76,200 252,450 1,147,550 81.97%
PRJ000138 Downtown Sidewalks 2,000,000 29,910 470,719 1,529,281 76.46%
PRJ000139 Westinghouse - Scenic Lake Traffic Signal 600,000 21,959 59,820 540,180 90.03%
PRJ000141 Southwestern Blvd 4,000,000 195,133 866,960 3,133,040 78.33%
PRJ000143 Leander Rd(Norwood-Swbypass)6,750,000 899,044 994,025 5,755,975 85.27%
PRJ000171 Shell Rd Sidewalk 229,825 - 203,755 26,070 11.34%
PRJ000172 2020 Street Maintenance High Performance Seal: Bid Package No.1 372,200 78,580 372,200 - 0.00%
PRJ000173 2020 Street Maintenance High Performance Seal: Bid Package No. 2 463,195 144,495 482,214 (19,020) -4.11%
PRJ000174 2020 street maintenance HIPR 1,935,589 249,466 1,441,013 494,576 25.55%
PRJ000188 DB Wood (SH 29 to Oak Ridge)4,000,000 - 120,492 3,879,508 96.99%PRJ000201 Austin Ave. (Sh29-Fm2243)466,000 - 466,000 - 0.00%
PRJ000202 FM 971 4,853,000 4,885 1,042,014 3,810,986 78.53%
PRJ000204 Historic District Street Signs 26,000 - - 26,000 100.00%
PRJ000207 Northwest Blvd Bridge 11,254,320 2,079,367 8,735,845 2,518,475 22.38%
PRJ000208 Old Town Northeast 1,050,000 18,656 924,407 125,593 11.96%
PRJ000209 Southeast Inner Loop 10,521,000 3,821,590 8,798,602 1,722,398 16.37%
PRJ000210 2021 HIPR Street Maintenance 2,300,000 72,430 274,700 2,025,300 88.06%
PRJ000211 2021 High Performance Pavement Seal Project #1 600,000 60,840 94,900 505,100 84.18%
PRJ000212 2021 High Performance Pavement Seal Project #2 600,000 57,820 90,700 509,300 84.88%
PRJ000214 Intersection Improvements (Traffic Signals)1,650,000 81,225 141,050 1,508,950 91.45%
PRJ000215 2021 Intersection Safety Enhancements (RRFB)150,000 52,300 96,450 53,550 35.70%
PRJ000216 FY21 Downtown Sidewalk Improvements 1,000,000 130,000 130,000 870,000 87.00%
PRJ000217 SW Bypass - Wolf Ranch Extension 1,000,000 734,411 756,776 243,224 24.32%
Public Works Total 63,397,527 8,818,937 28,526,297 34,871,229 55.00%
Active Project Total 446,781,839 36,423,631 123,794,034 322,987,804 72.29%
Grand Total 446,781,839 36,423,631 123,794,034 322,987,804 72.29%
59
Unfunded Liability & CommitmentsFinancial Impact/Notes Status Updates ‐ 9/30/20 Status Updates ‐ 12/31/20Cemetery 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 ChangeUnfunded 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/2019, the net pension liability is $28.8 million and is 81.41% funded. The 2020 total combined contribution rate is 12.26%. This increase is due to a change in the discount rate.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.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/2019 is $3.3 million. This is a combination of sudden death benefits as well as post‐retirement healthcare.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.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/2019 are $7.5 million. This increase is due to more time being earned than used in FY19. In FY2020, the budgeted reserve was increased to $340,000.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.Electric Fund Rate Stabilization ReserveIntended to mitigate potential rate impacts due to increased fuel costs or other external factors. The RSR is maintained within the Electric Fund. The sale of transformer and fiber assets were booked to the 4th Quarter. Net Purchased Power also ended the year on budget. FY2020 ending fund balance is projected to fully fund the 90 day contingency of $4.1 million, and begin to restore the rate stabilization reserve.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.CITY OF GEORGETOWNLong-term Commitments, Reservations, and Other Unfunded Liabilities12/31/202060
Unfunded Liability & CommitmentsFinancial Impact/Notes Status Updates ‐ 9/30/20 Status Updates ‐ 12/31/20Airport 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. Staff will be working on three (3) CARES Act purchases: 1) Emergency Generator, 2) Solar Powered Taxiway lights, and 3) Cattleguards for the North and South Gates to mitigate wildlife entering the airfield. These projects were unfunded, but will be reimbursed through TxDOT from the CARES Act grant from the FAA. We are also going to be looking at 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.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. 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. 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. Project will bid mid to late November with construction starting after the new year. 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.Park Equipment Maintenance & ReplacementOver the past 5 years, funding for Park Maintenance and Replacement has increased. $200K transfer from General Fund included in FY2018 budget. Staff has listed all assets & developed replacement schedule funded by the General Fund.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 Change61
Unfunded Liability & CommitmentsFinancial Impact/Notes Status Updates ‐ 9/30/20 Status Updates ‐ 12/31/20Radio 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. FY2021 Budget will fund the radios deferred in FY2020. Additionally, the Electric Fund plans to fund 10 radios that were deferred for several years to reduce costs. The Electric Fund has improved its financial position, and the equipment needs to be replaced for employee safety.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.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.Due to the COVID‐19 pandemic, the Street Maintenance budget in the General Fund was reduced in FY2021. The Streets Special Revenue Fund will pick up some of the expenses, but not all.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.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.No change.IT 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.No change.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. No change.62
Unfunded Liability & CommitmentsFinancial Impact/Notes Status Updates ‐ 9/30/20 Status Updates ‐ 12/31/20Public 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.No change.63