HomeMy WebLinkAboutFY 22 - 3rd_Qtr_Report_FY2022_RedactedFINANCIAL REPORT AND INVESTMENT REPORT
For the Quarter Ended June 30, 2022
Table of Contents
General Fund Narrative ................................................................................................................................. 1-8
General Fund Schedule .................................................................................................................................... 9
General Fund by Cost Center .................................................................................................................... 10-13
Electric Fund Narrative .............................................................................................................................. 14-18
Electric Fund Schedule ................................................................................................................................... 19
Water Services Fund Narrative ................................................................................................................. 20-24
Water Services Fund Schedule ....................................................................................................................... 25
Convention & Visitors Bureau Narrative ................................................................................................... 26-27
Convention & Visitors Bureau Fund Schedule ............................................................................................... 28
Airport Fund Narrative .............................................................................................................................. 29-31
Airport Fund Schedule .................................................................................................................................... 32
Georgetown Transportation Enhancement Corporation Fund Narrative ................................................ 33-35
Georgetown Transportation Enhancement Corporation Fund Schedule ..................................................... 36
Georgetown Economic Development Corporation Fund Narrative ......................................................... 36-39
Georgetown Economic Development Corporation Fund Schedule .............................................................. 40
Council Discretionary Fund Schedule ............................................................................................................. 41
Joint Services Fund Schedule ......................................................................................................................... 42
Stormwater Services Narrative ................................................................................................................. 43-45
Stormwater Services Fund Schedule .............................................................................................................. 46
Village PID Services Narrative ......................................................................................................................... 47
Village PID Services Fund Schedule ................................................................................................................ 48
Investment Report ..................................................................................................................................... 49-51
Quarterly Investment Report - City ........................................................................................................... 52-67
Quarterly Investment Report - GEDCO ..................................................................................................... 68-73
Quarterly Investment Report - GTEC ........................................................................................................ 74-79
Grant Applications .......................................................................................................................................... 80
Capital Improvement Projects ................................................................................................................... 81-86
Long-term Commitments and Other Unfunded Liabilities ....................................................................... 87-90
POLICE OPERATIONS DIVISION:
Police Operations saw personnel and operational expenditures through the quarter totals
$12,293,770, or 71.29% of budget. Police Administration expenditures through the quarter resulted
in $1,957,695, or 66.67% of budget. Staff will continue to monitor Police Department overtime
through the development of the FY2023 budget.
FIRE AND EMS DIVISION:
Year-to-date personnel and operational expenditures through the quarter total $3,342,496, or
71.32% of budget for Fire Support Services/Administration, $12,434,494, or 71.66% of budget for
Fire Emergency Services, and $2,557,543, or 70.86% of budget for Fire EMS. Fire Emergency
Services budget was budgeted with positions that typically are in the EMS cost center. The Fire
budget is viewed at a division level which includes the roll-up of all Fire associated cost centers. The
overall division is under budget in FY2022.
ADMINISTRATIVE SERVICES DIVISION:
Administrative Services saw operational and personnel costs totaling $1,656,587, or 68.71% of
budget year-to-date.
City Secretary personnel and operational expenditures for the quarter totals $755,655, which
represents 61.07% of budget. Year-to-date personnel and operational expenditures for
Communications totals $626,663, which represents 56.98% of budget. The CAPE department
experienced vacancy savings, as well as low year-to-date spending on a one-time project.
Non-Departmental includes a transfer out of $1,004,225, or 14.49% of anticipated transfer expense
for the year.
General Government Contracts includes budgeted vacancy savings estimates for all General
Fund departments. Real vacancy savings is realized in each cost center. The budgeted vacancy
factor against year-to-date actuals in the administrative division cost center drives the percent of
budget up. FY2022 projections in the third quarter report include adjustments and vacancy factor.
LIBRARY, TOURISM, AND ARTS AND CULTURE DIVISION:
Arts and Culture recognized year to date expenses totaling $149,891, or 70.13% of budget. Library
year-to-date expenses total $2,321,032, or 69.73% of budget.
PARKS AND RECREATION DIVISION:
Year-to-date personnel and operations costs for Parks and Recreation within the following cost
centers: Parks Administrations, Parks, Garey Park, Tennis Center, Recreation, and Recreation
Programs, comes to a total of $6,576,691, or 65.67% of budget.
Parks year-to-date through the quarter totals $2,087,733, or 69.45% of budget. Recreation total
expenses are $2,893,356, which is 61.87% of budget. Garey Park year-to-date is $751,590, or 69.98%
of budget. Personnel expenses in recreation are heavily seasonal, and a significant portion of part-
time and temporary salaries are used in the fourth quarter.
6
Staff will continue to monitor FY2022 projections as the end of the fiscal year approaches. Total
expenses are projected to end FY2022 at $5,957,066. Through the quarter, actual expenses are
48.94% of total projections
Overall, Stormwater expenditures are within budget and the fund can cover the 90-day
Contingency Reserve. Ending fund balance is budgeted to be $2,372,539 in FY2022 with an
operating contingency reserve of $413,189 and a debt service reserve of $486,959.
45
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 third quarter of
fiscal year 2022 includes the maturing, reinvesting, new investments of
financial institution deposits (CDs), and receipt of bond proceeds. Interest
rates continued to increase during this quarter after the FOMC met. The City
has established a safekeeping account with Wells Fargo, so that we can
begin investing in securities again. We continue to experience a low number
of banks responding to our investment offerings, but the ones that are
responding are providing favorable rates compared to the market.
The FOMC met in March, May, and June and announced multiple increases in
the Fed Funds Rate from .25-.50 in March to 1.50-1.75 in June. The City will
continue soliciting for the best rates to improve both diversity and yield, while
keeping in mind safety and liquidity.
The Investment Reports are for the quarter ending June 30, 2022. 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 as of June 30, 2022, 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 of the City’s portfolio
is consolidated at 46%, debt service at 3%, and bond proceeds/grants at 51%.
The City portfolio increased during this quarter due to bond proceeds. Some
of these proceeds will be invested in cd’s and securities once a cash funding
needs plan is set with the project managers. The GTEC and GEDCO portfolios
increased in this quarter as well. The average yield increased on all portfolios
due to increased rates in our pools and newly purchased cd’s.
49
CITY Book Value GTEC GEDCO
3/31/22 6/30/22 3/31/22 6/30/22 3/31/22 6/30/22
Total cash
and
investments
$445,453,842 $745,141,630 $35,315,924 $39,670,916 $8,740,959 $9,114,870
Quarter
End
Average
Yield
.37% .95% .15% .95% .19% .88%
The City’s strategy continues to be matching maturities with cash flow needs, while
focusing on the investment policy’s long-range goals. The City’s investment strategy
is to “ladder” or stagger maturities, thus minimizing erratic interest rate fluctuations.
The City is continuing to manage the yield on bond proceeds for arbitrage purposes.
The City’s investment portfolio generally includes bank deposits, local government
investment pool balances, money market accounts, and financial institution deposits
(CD’s), and when advantageous, securities. 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
50
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 is currently transitioning the depository bank contract from Chase to Wells
Fargo. Staff will work with Wells Fargo 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, however, according to the contract, there will not be any fees
assessed in the first year. The City will continue to verify depository yield versus
investment yield to achieve the best outcome.
III. CAPITAL IMPROVEMENT PROJECTS
A financial summary of capital improvement projects is attached to this report. This
report provides a Life-to-Date picture of all active projects since many capital
projects take multiple fiscal years to construct to completion. With our growing
capital infrastructure implementation portfolio due to demand for transportation
and water services, City staff have formed two working groups with the goal of
improving work capacity and efficiencies, and ultimately customer service, related to
capital projects. One group is focused on incrementally improving capital project
reporting internally and externally citywide – including financial information as well
as scheduling, geographic location, and other information. The second group is
focused on the re-organization of development-related capital improvements
delivered by Systems Engineering. Both groups will continue working through
FY2022. For the FY2023 Budget, staff were added to the Water, Public Works, and
Engineering departments to assist with the workload of the capital improvement
plan. Additionally, Council agreed to implement a hybrid approach to capital project
management, and to hire contracted staff to manage transportation and facilities
projects over the next 3 or more years.
51
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Demand Accounts 22,627,370$ 22,627,370 25,104,108$ 25,104,108$ 0.28%
NOW/MMA 11,053,426 11,053,426 16,076,373 16,076,373 1.48%
Pools 176,478,474 176,478,474 453,078,405 453,078,405 0.99%
CDs/Securities 235,294,573 235,294,573 250,882,744 250,882,744 0.92%Totals 445,453,842$ 445,453,842$ 745,141,630$ 745,141,630$ 0.95%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.95%Total Portfolio 0.49%
Rolling Three Month Treasury 1.13%Rolling Three Month Treasury 0.50%
Rolling Six Month Treasury 1.15%Rolling Six Month Treasury 0.53%
TexPool 1.00%TexPool 0.40%
Bank Fees Offset
16,550$
Interest earnings provided in separate report.41,167$
March 31, 2022
(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
June 30, 2022
City of Georgetown Valley View Consulting, L.L.C.53
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.28%07/01/22 06/30/22 25,104,108$ 25,104,108$ 1.00 25,104,108$ 1 0.28%
JPMorgan Chase MMA 0.05%07/01/22 06/30/22 434,217 434,217 1.00 434,217 1 0.05%
Veritex Community Bank MMA 1.21%07/01/22 06/30/22 3,221,390 3,221,390 1.00 3,221,390 1 1.21%
NexBank MMA 1.60%07/01/22 06/30/22 12,420,766 12,420,766 1.00 12,420,766 1 1.60%
TexPool AAAm 1.00%07/01/22 06/30/22 55,821,493 55,821,493 1.00 55,821,493 1 1.00%
TexSTAR AAAm 0.99%07/01/22 06/30/22 397,256,912 397,256,912 1.00 397,256,912 1 0.99%
Prosperity Bank CD 0.20%07/01/22 07/01/21 4,031,414 4,031,414 100.00 4,031,414 1 0.20%
Prosperity Bank CD 0.20%07/25/22 04/23/21 5,011,684 5,011,684 100.00 5,011,684 25 0.20%
Prosperity Bank CD 0.20%08/01/22 05/25/21 5,010,860 5,010,860 100.00 5,010,860 32 0.20%
East West Bank CD 0.45%08/01/22 02/01/22 2,005,168 2,005,168 100.00 2,005,168 32 0.45%
East West Bank CD 0.53%08/10/22 02/10/22 3,006,148 3,006,148 100.00 3,006,148 41 0.53%
East West Bank CD 0.17%08/15/22 11/15/21 4,004,250 4,004,250 100.00 4,004,250 46 0.17%
Prosperity Bank CD 0.35%08/22/22 11/20/20 2,513,866 2,513,866 100.00 2,513,866 53 0.35%
Prosperity Bank CD 0.20%09/12/22 06/11/21 5,010,009 5,010,009 100.00 5,010,009 74 0.20%
East West Bank CD 1.83%09/16/22 06/16/22 10,007,523 10,007,523 100.00 10,007,523 78 1.85%
East West Bank CD 0.26%09/20/22 12/20/21 2,002,751 2,002,751 100.00 2,002,751 82 0.26%
East West Bank CD 1.71%09/20/22 06/22/22 3,004,242 3,004,242 100.00 3,004,242 82 1.72%
East West Bank CD 1.71%09/20/22 06/22/22 2,503,535 2,503,535 100.00 2,503,535 82 1.72%
Independent Bank CD 0.30%10/18/22 10/18/21 2,560,619 2,560,619 100.00 2,560,619 110 0.30%
Prosperity Bank CD 0.20%10/24/22 04/23/21 5,011,684 5,011,684 100.00 5,011,684 116 0.20%
East West Bank CD 0.21%11/15/22 11/15/21 10,013,126 10,013,126 100.00 10,013,126 138 0.21%
Prosperity Bank CD 0.40%11/17/22 11/17/20 2,012,682 2,012,682 100.00 2,012,682 140 0.40%
Prosperity Bank CD 0.15%11/23/22 08/23/21 2,002,500 2,002,500 100.00 2,002,500 146 0.15%
Prosperity Bank CD 0.15%12/21/22 09/21/21 5,005,612 5,005,612 100.00 5,005,612 174 0.15%
Alliance Bank CD 2.50%12/24/22 06/24/22 8,000,000 8,000,000 100.00 8,000,000 177 2.52%
East West Bank CD 1.06%12/26/22 03/25/22 12,034,200 12,034,200 100.00 12,034,200 179 1.07%
R Bank CD 0.60%12/31/22 06/30/21 1,006,035 1,006,035 100.00 1,006,035 184 0.60%
East West Bank CD 0.42%01/09/23 01/07/22 5,020,582 5,020,582 100.00 5,020,582 193 0.42%
East West Bank CD 0.51%01/20/23 01/20/22 10,022,661 10,022,661 100.00 10,022,661 204 0.51%
East West Bank CD 0.83%02/08/23 02/08/22 8,026,056 8,026,056 100.00 8,026,056 223 0.83%
Bank OZK CD 0.18%02/23/23 08/23/21 4,206,336 4,206,336 100.00 4,206,336 238 0.18%
East West Bank CD 1.19%02/27/23 02/25/22 20,082,326 20,082,326 100.00 20,082,326 242 1.20%
Veritex Community Bank CD 0.18%03/09/23 09/09/21 4,005,388 4,005,388 100.00 4,005,388 252 0.18%
East West Bank CD 1.15%03/14/23 03/14/22 15,051,601 15,051,601 100.00 15,051,601 257 1.16%
East West Bank CD 1.29%03/27/23 03/25/22 25,086,738 25,086,738 100.00 25,086,738 270 1.30%
Prosperity Bank CD 0.20%04/24/23 04/23/21 5,011,684 5,011,684 100.00 5,011,684 298 0.20%
June 30, 2022
City of Georgetown Valley View Consulting, L.L.C.55
City - Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
June 30, 2022
Prosperity Bank CD 0.20%05/01/23 05/25/21 5,010,860 5,010,860 100.00 5,010,860 305 0.20%
Bank OZK CD 0.20%06/12/23 06/11/21 5,021,340 5,021,340 100.00 5,021,340 347 0.20%
East West Bank CD 2.99%06/16/23 06/16/22 15,018,442 15,018,442 100.00 15,018,442 351 3.04%
East West Bank CD 2.94%06/20/23 06/22/22 2,504,463 2,504,463 100.00 2,504,463 355 2.98%
R Bank CD 0.73%06/30/23 06/30/21 1,007,327 1,007,327 100.00 1,007,327 365 0.73%
Bank OZK CD 0.21%08/14/23 11/12/21 5,006,131 5,006,131 100.00 5,006,131 410 0.21%
Veritex Community Bank CD 0.25%09/25/23 09/24/21 10,018,714 10,018,714 100.00 10,018,714 452 0.25%
Bank OZK CD 0.20%10/09/23 10/08/21 5,006,690 5,006,690 100.00 5,006,690 466 0.20%
Bank OZK CD 0.30%11/13/23 11/12/21 10,017,496 10,017,496 100.00 10,017,496 501 0.30%
TOTALS 745,141,630$ 745,141,630$ 745,141,630$ 78 0.95%
(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.56
City - Book & Market Value Comparison
Issuer/Description Yield Maturity
Date
Book Value
03/31/22 Increases Decreases Book Value
06/30/22
Market Value
03/31/22
Change in
Market Value
Market Value
06/30/22
JPMorgan Chase Cash 0.28%07/01/22 22,627,370$ 2,476,738$ –$ 25,104,108$ 22,627,370$ 2,476,738$ 25,104,108$
JPMorgan Chase MMA 0.05%07/01/22 434,178 39 – 434,217 434,178 39 434,217
Veritex Community Bank MMA 1.21%07/01/22 3,216,296 5,094 – 3,221,390 3,216,296 5,094 3,221,390
NexBank MMA 1.60%07/01/22 7,402,952 5,017,814 – 12,420,766 7,402,952 5,017,814 12,420,766
TexPool 1.00%07/01/22 60,684,122 – (4,862,629) 55,821,493 60,684,122 (4,862,629) 55,821,493
TexSTAR 0.99%07/01/22 115,794,352 281,462,560 – 397,256,912 115,794,352 281,462,560 397,256,912
Prosperity Bank CD 0.35%04/21/22 2,512,394 – (2,512,394) – 2,512,394 (2,512,394) –
Independent Bank CD 0.30%04/22/22 4,221,377 – (4,221,377) – 4,221,377 (4,221,377) –
Independent Bank CD 0.35%05/09/22 4,014,018 – (4,014,018) – 4,014,018 (4,014,018) – Prosperity Bank CD 0.35%05/17/22 2,009,319 – (2,009,319) – 2,009,319 (2,009,319) –
Prosperity Bank CD 0.20%06/13/22 5,007,484 – (5,007,484) – 5,007,484 (5,007,484) –
East West Bank CD 0.18%06/20/22 2,501,258 – (2,501,258) – 2,501,258 (2,501,258) –
East West Bank CD 0.18%06/20/22 3,001,509 – (3,001,509) – 3,001,509 (3,001,509) –
East West Bank CD 0.18%06/20/22 2,501,258 – (2,501,258) – 2,501,258 (2,501,258) –
Prosperity Bank CD 0.20%07/01/22 4,029,448 1,965 – 4,031,414 4,029,448 1,965 4,031,414
Prosperity Bank CD 0.20%07/25/22 5,009,158 2,526 – 5,011,684 5,009,158 2,526 5,011,684
Prosperity Bank CD 0.20%08/01/22 5,008,335 2,525 – 5,010,860 5,008,335 2,525 5,010,860
East West Bank CD 0.45%08/01/22 2,002,920 2,248 – 2,005,168 2,002,920 2,248 2,005,168
East West Bank CD 0.53%08/10/22 3,002,179 3,970 – 3,006,148 3,002,179 3,970 3,006,148
East West Bank CD 0.17%08/15/22 4,002,553 1,697 – 4,004,250 4,002,553 1,697 4,004,250 Prosperity Bank CD 0.35%08/22/22 2,511,649 2,216 – 2,513,866 2,511,649 2,216 2,513,866
Prosperity Bank CD 0.20%09/12/22 5,007,484 2,525 – 5,010,009 5,007,484 2,525 5,010,009
East West Bank CD 1.85%09/16/22 – 10,007,523 – 10,007,523 – 10,007,523 10,007,523
East West Bank CD 0.26%09/20/22 2,001,454 1,298 – 2,002,751 2,001,454 1,298 2,002,751 East West Bank CD 1.72%09/20/22 – 3,004,242 – 3,004,242 – 3,004,242 3,004,242
East West Bank CD 1.72%09/20/22 – 2,503,535 – 2,503,535 – 2,503,535 2,503,535
Independent Bank CD 0.30%10/18/22 2,558,726 1,893 – 2,560,619 2,558,726 1,893 2,560,619
Prosperity Bank CD 0.20%10/24/22 5,009,158 2,526 – 5,011,684 5,009,158 2,526 5,011,684
East West Bank CD 0.21%11/15/22 10,007,885 5,241 – 10,013,126 10,007,885 5,241 10,013,126
Prosperity Bank CD 0.40%11/17/22 2,010,654 2,028 – 2,012,682 2,010,654 2,028 2,012,682
Prosperity Bank CD 0.15%11/23/22 2,001,743 757 – 2,002,500 2,001,743 757 2,002,500
Prosperity Bank CD 0.15%12/21/22 5,003,720 1,892 – 5,005,612 5,003,720 1,892 5,005,612
Alliance Bank CD 2.52%12/24/22 – 8,000,000 – 8,000,000 – 8,000,000 8,000,000
East West Bank CD 1.07%12/26/22 12,002,440 31,761 – 12,034,200 12,002,440 31,761 12,034,200
R Bank CD 0.60%12/31/22 1,004,514 1,520 – 1,006,035 1,004,514 1,520 1,006,035 East West Bank CD 0.42%01/09/23 5,015,327 5,254 – 5,020,582 5,015,327 5,254 5,020,582
East West Bank CD 0.51%01/20/23 10,009,925 12,736 – 10,022,661 10,009,925 12,736 10,022,661
East West Bank CD 0.83%02/08/23 8,009,465 16,591 – 8,026,056 8,009,465 16,591 8,026,056
Bank OZK CD 0.18%02/23/23 4,204,417 1,918 – 4,206,336 4,204,417 1,918 4,206,336 East West Bank CD 1.20%02/27/23 20,022,835 59,492 – 20,082,326 20,022,835 59,492 20,082,326
Veritex Community Bank CD 0.18%03/09/23 4,003,572 1,817 – 4,005,388 4,003,572 1,817 4,005,388
City of Georgetown Valley View Consulting, L.L.C.58
City - Allocation
Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
2015 Revenue
Water WW
2016 GO-
Roads
Garey Park
Donation
JPMorgan Chase Cash 25,104,108$ 25,104,108$ –$ –$ –$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,217 434,217 – – – – – – – –
Veritex Community Bank MMA 3,221,390 3,221,390 – – – – – – – –
NexBank MMA 12,420,766 12,420,766 – – – – – – – –
TexPool 55,821,493 55,821,493 – – – – – – – –
TexSTAR 397,256,912 23,593,921 457,455 22,500,006 137,556 6,678 1,528,482 1,534,616 917,954 73,824
Prosperity Bank CD 07/01/22 4,031,414 4,031,414 – – – – – – – –
Prosperity Bank CD 07/25/22 5,011,684 5,011,684 – – – – – – – –
Prosperity Bank CD 08/01/22 5,010,860 5,010,860 – – – – – – – –
East West Bank CD 08/01/22 2,005,168 – – – – – – – – –
East West Bank CD 08/10/22 3,006,148 – – – – – – – – –
East West Bank CD 08/15/22 4,004,250 – – – – – – – – – Prosperity Bank CD 08/22/22 2,513,866 2,513,866 – – – – – – – –
Prosperity Bank CD 09/12/22 5,010,009 5,010,009 – – – – – – – –
East West Bank CD 09/16/22 10,007,523 10,007,523 – – – – – – – –
East West Bank CD 09/20/22 2,002,751 – – – – – – – – –
East West Bank CD 09/20/22 2,503,535 – – – – – – – – –
Independent Bank CD 10/18/22 2,560,619 2,560,619 – – – – – – – –
Prosperity Bank CD 10/24/22 5,011,684 5,011,684 – – – – – – – –
East West Bank CD 11/15/22 10,013,126 – – – – – – – – –
East West Bank CD 09/20/22 3,004,242 – – – – – – – – –
Prosperity Bank CD 11/17/22 2,012,682 2,012,682 – – – – – – – –
Prosperity Bank CD 11/23/22 2,002,500 2,002,500 – – – – – – – –
Prosperity Bank CD 12/21/22 5,005,612 5,005,612 – – – – – – – –
Alliance Bank CD 12/24/22 8,000,000 8,000,000 – – – – – – – –
East West Bank CD 12/26/22 12,034,200 12,034,200 – – – – – – – –
R Bank CD 12/31/22 1,006,035 1,006,035 – – – – – – – –
East West Bank CD 01/09/23 5,020,582 5,020,582 – – – – – – – –
East West Bank CD 01/20/23 10,022,661 10,022,661 – – – – – – – –
East West Bank CD 02/08/23 8,026,056 8,026,056 – – – – – – – –
Bank OZK CD 02/23/23 4,206,336 4,206,336 – – – – – – – –
East West Bank CD 02/27/23 20,082,326 20,082,326 – – – – – – – –
Veritex Community Bank CD 03/09/23 4,005,388 4,005,388 – – – – – – – –
East West Bank CD 03/14/23 15,051,601 15,051,601 – – – – – – – –
East West Bank CD 03/27/23 25,086,738 25,086,738 – – – – – – – –
Prosperity Bank CD 04/24/23 5,011,684 5,011,684 – – – – – – – –
Prosperity Bank CD 05/01/23 5,010,860 5,010,860 – – – – – – – – Bank OZK CD 06/12/23 5,021,340 5,021,340 – – – – – – – –
East West Bank CD 06/16/23 15,018,442 15,018,442 – – – – – – – –
East West Bank CD 06/20/23 2,504,463 – – – – – – – – –
R Bank CD 06/30/23 1,007,327 1,007,327 – – – – – – – –
Bank OZK CD 08/14/23 5,006,131 5,006,131 – – – – – – – –
Veritex Community Bank CD 09/25/23 10,018,714 10,018,714 – – – – – – – –
Bank OZK CD 10/09/23 5,006,690 5,006,690 – – – – – – – –
Bank OZK CD 11/13/23 10,017,496 10,017,496 – – – – – – – –
Totals 745,141,630$ 342,434,956$ 457,455$ 22,500,006$ 137,556$ 6,678$ 1,528,482$ 1,534,616$ 917,954$ 73,824$
Book & Market Value
June 30, 2022
City of Georgetown Valley View Consulting, L.L.C.60
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 07/01/22
Prosperity Bank CD 07/25/22
Prosperity Bank CD 08/01/22
East West Bank CD 08/01/22
East West Bank CD 08/10/22
East West Bank CD 08/15/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 09/12/22
East West Bank CD 09/16/22
East West Bank CD 09/20/22
East West Bank CD 09/20/22
Independent Bank CD 10/18/22
Prosperity Bank CD 10/24/22
East West Bank CD 11/15/22
East West Bank CD 09/20/22
Prosperity Bank CD 11/17/22
Prosperity Bank CD 11/23/22
Prosperity Bank CD 12/21/22
Alliance Bank CD 12/24/22
East West Bank CD 12/26/22
R Bank CD 12/31/22
East West Bank CD 01/09/23
East West Bank CD 01/20/23
East West Bank CD 02/08/23
Bank OZK CD 02/23/23
East West Bank CD 02/27/23
Veritex Community Bank CD 03/09/23
East West Bank CD 03/14/23
East West Bank CD 03/27/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Bank OZK CD 06/12/23
East West Bank CD 06/16/23
East West Bank CD 06/20/23
R Bank CD 06/30/23
Bank OZK CD 08/14/23
Veritex Community Bank CD 09/25/23
Bank OZK CD 10/09/23
Bank OZK CD 11/13/23
Totals
Book & Market Value
June 30, 2022
(Continued)
2017 CO
Facilities/ Public
Safety/
Equipment
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
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
–$ –$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
4,352 97,560 8,140,317 56,803 390,299 244,693 1,810,657 3,682,519 2,757,188 602,671
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – 3,006,148 – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – 2,503,535 – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
4,352$ 97,560$ 11,146,466$ 56,803$ 390,299$ 244,693$ 1,810,657$ 6,186,054$ 2,757,188$ 602,671$
City of Georgetown Valley View Consulting, L.L.C.61
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 07/01/22
Prosperity Bank CD 07/25/22
Prosperity Bank CD 08/01/22
East West Bank CD 08/01/22
East West Bank CD 08/10/22
East West Bank CD 08/15/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 09/12/22
East West Bank CD 09/16/22
East West Bank CD 09/20/22
East West Bank CD 09/20/22
Independent Bank CD 10/18/22
Prosperity Bank CD 10/24/22
East West Bank CD 11/15/22
East West Bank CD 09/20/22
Prosperity Bank CD 11/17/22
Prosperity Bank CD 11/23/22
Prosperity Bank CD 12/21/22
Alliance Bank CD 12/24/22
East West Bank CD 12/26/22
R Bank CD 12/31/22
East West Bank CD 01/09/23
East West Bank CD 01/20/23
East West Bank CD 02/08/23
Bank OZK CD 02/23/23
East West Bank CD 02/27/23
Veritex Community Bank CD 03/09/23
East West Bank CD 03/14/23
East West Bank CD 03/27/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Bank OZK CD 06/12/23
East West Bank CD 06/16/23
East West Bank CD 06/20/23
R Bank CD 06/30/23
Bank OZK CD 08/14/23
Veritex Community Bank CD 09/25/23
Bank OZK CD 10/09/23
Bank OZK CD 11/13/23
Totals
Book & Market Value
June 30, 2022
(Continued)
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
City - 2021 CO
Airport
City - 2021 CO
Fac/Equip/Par
ks
City - 2021
GO Parks
City - 2021
GO Roads
City - 2021A
CO Electric
City - 2021A
CO
Water/WW
City - 2021A
GO Roads
–$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
353,184 4,980,437 565,520 4,094,819 701,257 3,206,013 1,001,795 5,438,763 895,989 10,029,762 10,915,481
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– 2,005,168 – – – – – – – – –
– – – – – – – – – – –
– – – – – 4,004,250 – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – 2,002,751
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – 10,013,126
– – – – – 3,004,242 – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – 2,504,463 –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
353,184$ 6,985,605$ 565,520$ 4,094,819$ 701,257$ 10,214,504$ 1,001,795$ 5,438,763$ 895,989$ 12,534,225$ 22,931,359$
City of Georgetown Valley View Consulting, L.L.C.62
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 07/01/22
Prosperity Bank CD 07/25/22
Prosperity Bank CD 08/01/22
East West Bank CD 08/01/22
East West Bank CD 08/10/22
East West Bank CD 08/15/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 09/12/22
East West Bank CD 09/16/22
East West Bank CD 09/20/22
East West Bank CD 09/20/22
Independent Bank CD 10/18/22
Prosperity Bank CD 10/24/22
East West Bank CD 11/15/22
East West Bank CD 09/20/22
Prosperity Bank CD 11/17/22
Prosperity Bank CD 11/23/22
Prosperity Bank CD 12/21/22
Alliance Bank CD 12/24/22
East West Bank CD 12/26/22
R Bank CD 12/31/22
East West Bank CD 01/09/23
East West Bank CD 01/20/23
East West Bank CD 02/08/23
Bank OZK CD 02/23/23
East West Bank CD 02/27/23
Veritex Community Bank CD 03/09/23
East West Bank CD 03/14/23
East West Bank CD 03/27/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Bank OZK CD 06/12/23
East West Bank CD 06/16/23
East West Bank CD 06/20/23
R Bank CD 06/30/23
Bank OZK CD 08/14/23
Veritex Community Bank CD 09/25/23
Bank OZK CD 10/09/23
Bank OZK CD 11/13/23
Totals
Book & Market Value
June 30, 2022
(Continued)
City - 2022 CO
Airport
City - 2022 CO
Fac/Equip/Parks
City - 2022 CO
Stormwater
City - 2022
GO Parks
City - 2022
GO Roads
City - 2022 CO
Electric
City - 2022 CO
Water/WW
City -
American
Rescue Plan
–$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
500,540 3,585,906 500,540 40,243,441 4,793,330 18,179,872 210,854,798 7,877,912
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
500,540$ 3,585,906$ 500,540$ 40,243,441$ 4,793,330$ 18,179,872$ ###########7,877,912$
City of Georgetown Valley View Consulting, L.L.C.63
City - Allocation
Investment
Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
2015 Revenue
Water WW
2016 GO-
Roads
Garey Park
Donation
JPMorgan Chase Cash 22,627,370$ 22,627,370$ –$ –$ –$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,178 434,178 – – – – – – – –
Veritex Community Bank MMA 3,216,296 3,216,296 – – – – – – – –
NexBank MMA 7,402,952 7,402,952 – – – – – – – –
TexPool 60,684,122 60,684,122 – – – – – – – –
TexSTAR 115,794,352 20,117,827 464,960 22,257,135 137,333 6,667 1,530,963 1,532,128 1,416,343 86,755
Prosperity Bank CD 04/21/22 2,512,394 2,512,394 – – – – – – – –
Independent Bank CD 04/22/22 4,221,377 4,221,377 – – – – – – – –
Independent Bank CD 05/09/22 4,014,018 4,014,018 – – – – – – – –
Prosperity Bank CD 05/17/22 2,009,319 2,009,319 – – – – – – – –
Prosperity Bank CD 06/13/22 5,007,484 5,007,484 – – – – – – – –
East West Bank CD 06/20/22 2,501,258 – – – – – – – – –
East West Bank CD 06/20/22 3,001,509 – – – – – – – – –
East West Bank CD 06/20/22 2,501,258 – – – – – – – – –
Prosperity Bank CD 07/01/22 4,029,448 4,029,448 – – – – – – – –
Prosperity Bank CD 07/25/22 5,009,158 5,009,158 – – – – – – – –
Prosperity Bank CD 08/01/22 5,008,335 5,008,335 – – – – – – – –
East West Bank CD 08/01/22 2,002,920 – – – – – – – – –
East West Bank CD 08/10/22 3,002,179 – – – – – – – – –
East West Bank CD 08/15/22 4,002,553 – – – – – – – – –
Prosperity Bank CD 08/22/22 2,511,649 2,511,649 – – – – – – – –
Prosperity Bank CD 09/12/22 5,007,484 5,007,484 – – – – – – – –
East West Bank CD 09/20/22 2,001,454 – – – – – – – – –
Independent Bank CD 10/18/22 2,558,726 2,558,726 – – – – – – – –
Prosperity Bank CD 10/24/22 5,009,158 5,009,158 – – – – – – – –
East West Bank CD 11/15/22 10,007,885 – – – – – – – – –
Prosperity Bank CD 11/17/22 2,010,654 2,010,654 – – – – – – – –
Prosperity Bank CD 11/23/22 2,001,743 2,001,743 – – – – – – – –
Prosperity Bank CD 12/21/22 5,003,720 5,003,720 – – – – – – – –
East West Bank CD 12/26/22 12,002,440 12,002,440 – – – – – – – –
R Bank CD 12/31/22 1,004,514 1,004,514 – – – – – – – –
East West Bank CD 01/09/23 5,015,327 5,015,327 – – – – – – – –
East West Bank CD 01/20/23 10,009,925 10,009,925 – – – – – – – –
East West Bank CD 02/08/23 8,009,465 8,009,465 – – – – – – – –
Bank OZK CD 02/23/23 4,204,417 4,204,417 – – – – – – – –
East West Bank CD 02/27/23 20,022,835 20,022,835 – – – – – – – –
Veritex Community Bank CD 03/09/23 4,003,572 4,003,572 – – – – – – – –
East West Bank CD 03/14/23 15,008,509 15,008,509 – – – – – – – –
East West Bank CD 03/27/23 25,006,186 25,006,186 – – – – – – – –
Prosperity Bank CD 04/24/23 5,009,158 5,009,158 – – – – – – – –
Prosperity Bank CD 05/01/23 5,008,335 5,008,335 – – – – – – – –
Bank OZK CD 06/12/23 5,018,797 5,018,797 – – – – – – – –
R Bank CD 06/30/23 1,005,475 1,005,475 – – – – – – – –
Bank OZK CD 08/14/23 5,003,469 5,003,469 – – – – – – – –
Veritex Community Bank CD 09/25/23 10,012,404 10,012,404 – – – – – – – –
Bank OZK CD 10/09/23 5,004,159 5,004,159 – – – – – – – –
Bank OZK CD 11/13/23 10,009,900 10,009,900 – – – – – – – –
Totals 445,453,842$ 320,756,302$ 464,960$ 22,257,135$ 137,333$ 6,667$ 1,530,963$ 1,532,128$ 1,416,343$ 86,755$
March 31, 2022
Book & Market Value
City of Georgetown Valley View Consulting, L.L.C.64
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/21/22
Independent Bank CD 04/22/22
Independent Bank CD 05/09/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 06/13/22
East West Bank CD 06/20/22
East West Bank CD 06/20/22
East West Bank CD 06/20/22
Prosperity Bank CD 07/01/22
Prosperity Bank CD 07/25/22
Prosperity Bank CD 08/01/22
East West Bank CD 08/01/22
East West Bank CD 08/10/22
East West Bank CD 08/15/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 09/12/22
East West Bank CD 09/20/22
Independent Bank CD 10/18/22
Prosperity Bank CD 10/24/22
East West Bank CD 11/15/22
Prosperity Bank CD 11/17/22
Prosperity Bank CD 11/23/22
Prosperity Bank CD 12/21/22
East West Bank CD 12/26/22
R Bank CD 12/31/22
East West Bank CD 01/09/23
East West Bank CD 01/20/23
East West Bank CD 02/08/23
Bank OZK CD 02/23/23
East West Bank CD 02/27/23
Veritex Community Bank CD 03/09/23
East West Bank CD 03/14/23
East West Bank CD 03/27/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Bank OZK CD 06/12/23
R Bank CD 06/30/23
Bank OZK CD 08/14/23
Veritex Community Bank CD 09/25/23
Bank OZK CD 10/09/23
Bank OZK CD 11/13/23
Totals
March 31, 2022
Book & Market Value
(Continued)
2017 CO
Facilities/ Public
Safety/
Equipment
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
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
–$ –$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
4,345 97,402 8,172,513 56,711 389,666 284,585 1,826,844 3,682,705 2,752,717 844,405
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – 2,501,258 – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – 3,002,179 – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
4,345$ 97,402$ 11,174,692$ 56,711$ 389,666$ 284,585$ 1,826,844$ 6,183,963$ 2,752,717$ 844,405$
City of Georgetown Valley View Consulting, L.L.C.65
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/21/22
Independent Bank CD 04/22/22
Independent Bank CD 05/09/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 06/13/22
East West Bank CD 06/20/22
East West Bank CD 06/20/22
East West Bank CD 06/20/22
Prosperity Bank CD 07/01/22
Prosperity Bank CD 07/25/22
Prosperity Bank CD 08/01/22
East West Bank CD 08/01/22
East West Bank CD 08/10/22
East West Bank CD 08/15/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 09/12/22
East West Bank CD 09/20/22
Independent Bank CD 10/18/22
Prosperity Bank CD 10/24/22
East West Bank CD 11/15/22
Prosperity Bank CD 11/17/22
Prosperity Bank CD 11/23/22
Prosperity Bank CD 12/21/22
East West Bank CD 12/26/22
R Bank CD 12/31/22
East West Bank CD 01/09/23
East West Bank CD 01/20/23
East West Bank CD 02/08/23
Bank OZK CD 02/23/23
East West Bank CD 02/27/23
Veritex Community Bank CD 03/09/23
East West Bank CD 03/14/23
East West Bank CD 03/27/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Bank OZK CD 06/12/23
R Bank CD 06/30/23
Bank OZK CD 08/14/23
Veritex Community Bank CD 09/25/23
Bank OZK CD 10/09/23
Bank OZK CD 11/13/23
Totals
March 31, 2022
Book & Market Value
(Continued)
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
City - 2021 CO
Airport
City - 2021 CO
Fac/Equip/Par
ks
City - 2021
GO Parks
City - 2021
GO Roads
City - 2021A
CO Electric
City - 2021A
CO Water/WW
City - 2021A
GO Roads
–$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
359,409 5,241,238 595,592 4,088,401 700,120 3,220,386 1,000,171 5,500,304 1,475,837 10,172,370 13,922,893
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – 3,001,509 – – – – –
– – – – – – – – – 2,501,258 –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– 2,002,920 – – – – – – – – –
– – – – – – – – – – –
– – – – – 4,002,553 – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – 2,001,454
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – 10,007,885
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
359,409$ 7,244,157$ 595,592$ 4,088,401$ 700,120$ 10,224,449$ 1,000,171$ 5,500,304$ 1,475,837$ 12,673,628$ 25,932,232$
City of Georgetown Valley View Consulting, L.L.C.66
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/21/22
Independent Bank CD 04/22/22
Independent Bank CD 05/09/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 06/13/22
East West Bank CD 06/20/22
East West Bank CD 06/20/22
East West Bank CD 06/20/22
Prosperity Bank CD 07/01/22
Prosperity Bank CD 07/25/22
Prosperity Bank CD 08/01/22
East West Bank CD 08/01/22
East West Bank CD 08/10/22
East West Bank CD 08/15/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 09/12/22
East West Bank CD 09/20/22
Independent Bank CD 10/18/22
Prosperity Bank CD 10/24/22
East West Bank CD 11/15/22
Prosperity Bank CD 11/17/22
Prosperity Bank CD 11/23/22
Prosperity Bank CD 12/21/22
East West Bank CD 12/26/22
R Bank CD 12/31/22
East West Bank CD 01/09/23
East West Bank CD 01/20/23
East West Bank CD 02/08/23
Bank OZK CD 02/23/23
East West Bank CD 02/27/23
Veritex Community Bank CD 03/09/23
East West Bank CD 03/14/23
East West Bank CD 03/27/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Bank OZK CD 06/12/23
R Bank CD 06/30/23
Bank OZK CD 08/14/23
Veritex Community Bank CD 09/25/23
Bank OZK CD 10/09/23
Bank OZK CD 11/13/23
Totals
March 31, 2022
Book & Market Value
(Continued)
City -
American
Rescue Plan
–$
–
–
–
–
3,855,626
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
3,855,626$
City of Georgetown Valley View Consulting, L.L.C.67
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
MMA 2,132,629$ 2,132,629$ 2,136,008$ 2,136,008$ 1.21%
Pools 4,603,525 4,603,525 4,972,885 4,972,885 0.99%
Certificates of Deposit 2,004,804 2,004,804 2,005,978 2,005,978 0.24%
8,740,959$ 8,740,959$ 9,114,870$ 9,114,870$ 0.88%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.88%Total Portfolio 0.38%
Rolling Three Month Treasury 1.13%Rolling Three Month Treasury 0.50%
Rolling Six Month Treasury 1.15%Rolling Six Month Treasury 0.53%
TexPool 1.00%TexPool 0.40%
Interest income provided in separate report.
March 31, 2022
(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.
June 30, 2022
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.69
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 1.21%07/01/22 06/30/22 2,136,008$ 2,136,008$ 1.00 2,136,008$ 1 1.21%
TexasDAILY AAAm 1.00%07/01/22 06/30/22 2,129,836 2,129,836 1.00 2,129,836 1 1.00%
TexSTAR AAAm 0.99%07/01/22 06/30/22 2,843,049 2,843,049 1.00 2,843,049 1 0.99%
Veritex Bank CD 0.24%8/5/2022 02/08/21 2,005,978 2,005,978 100.00 2,005,978 36 0.24%
9,114,870$ 9,114,870$ 9,114,870$ 9 0.88%
(1)(2)
June 30, 2022
(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.71
Georgetown Transportation Enhancement Corporation (GTEC)
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
June 30, 2022
Prepared byValley View Consulting, L.L.C.
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.
74
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Pools/MMAs 32,301,223$ 32,301,223$ 36,655,075$ 36,655,075$ 1.01%
CDs/Securities 3,014,701 3,014,701 3,015,841 3,015,841 0.15%Totals 35,315,924$ 35,315,924$ 39,670,916$ 39,670,916$ 0.95%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.95%Total Portfolio 0.38%
Rolling Three Month Treasury 1.13%Rolling Three Month Treasury 0.50%
Rolling Six Month Treasury 1.15%Rolling Six Month Treasury 0.53%
TexPool 1.00%TexPool 0.40%
Interest data provided in separate report.
March 31, 2022
(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.
June 30, 2022
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.75
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 1.00%07/01/22 06/30/22 22,564,815$ 22,564,815$ 1.00 22,564,815$ 1 1.00%
TexSTAR AAAm 0.99%07/01/22 06/30/22 11,395,010 11,395,010 1.00 11,395,010 1 0.99%
Veritex Bank MMA 1.21%07/01/22 06/30/22 2,695,250 2,695,250 1.00 2,695,250 1 1.21%
Prosperity Bank CD 0.15%08/23/22 08/23/21 3,015,841 3,015,841 100.00 3,015,841 54 0.15%
TOTALS 39,670,916$ 39,670,916$ 39,670,916$ 5 0.95%
(1)(2)
June 30, 2022
(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.77
Department Federal Grantor Pass-Through Agency Identifying Number COG Name/Purpose YTD Expenditures YTD Revenue Recognized
Airport N/A Texas Department of
Transportation-Aviation
M2214GEOR RAMP Grant - Routine Airport
Maintenance Program
- -
Emergency Management US Dept. of the Treasury American Rescue Plan Act
SLFRF Funding
104,783 104,783
Fire US Department of Homeland Security Federal Emergency
Management Agency
EMW-2017-FH-00496 SAFER 487,552 104,864
Planning US Department of Housing & Urban Development Williamson County B-17-UC-48-0502 CDBG Sidewalks and Ramps
along 17th St
26,302 26,302
Planning US Department of Housing & Urban Development Williamson County CDBG 21st St Infrastructure 15,006 14,522
Planning US Department of Housing & Urban Development Williamson County CDBG Home Repair (FY19) 2,139 2,139
Planning US Department of Housing & Urban Development Williamson County CDBG Home Repair (FY20) 75,000 75,000
Police US. Department of Justice N/A TX2460200 Equitable Sharing Agreement - -
Public Works Dept. of Transportation /Federal Highway
Administration
Texas Department of
Transportation
CSJ 0914-05-200, 201, 202 Highway Planning &
Construction (Lakeway &
Williams Drive)
197,192 197,192
Electric Dept. of Transportation /Federal Highway
Administration
Texas Department of
Transportation
CSJ 0015-08-150 Standard Utility Agreement
(I35 Mobility)
374,365 374,365
Emergency Management FEMA*TDEM DR-4586PATXP00001 Winter Storm Uri Relief PRJ-
240164 Water
20,124 20,124
Emergency Management FEMA*TDEM DR-4586PATXP00001 Winter Storm Uri Relief PRJ-
187834 Citywide
387,252 387,252
Emergency Management FEMA*TDEM DR-4586PATXP00001 Winter Storm Uri Relief PRJ-
Donated Resources
5,246 5,246
*Expenses were incurred in FY2021, but reported here since FEMA has now approved for reimbursement.
Division Grantor COG Name/Purpose Status
CITY OF GEORGETOWN
Grant/Federal Funding Report
as of June 30, 2022
Active
Applications Pending Award
80
CITY OF GEORGETOWN CAPITAL PROJECTS Project Budget Total Spend Remaining Budget Percent Remaining
Airport - Self Managed
PRJ000197 Hangar Maintenance 240,000 - 240,000 100%
PRJ000198 Pavement Maintenance 60,000 - 60,000 100%
PRJ000199 Wildlife Management 150,000 18,000 132,000 88%
Airport - Self Managed Total 450,000 18,000 432,000 96%
CDBG
PRJ000003 17th Street 193,000 175,137 17,863 9%
PRJ000248 21st W/WW offsite CDBG 97,000 48,405 48,595 50%
CDBG Total 290,000 223,542 66,458 23%
Electric
PRJ000022 Consultant Engineering 271,352 101,964 169,389 62%
PRJ000026 Db Wood_Sh29 Intersection 240,000 170,413 69,587 29%
PRJ000036 Electrical System Improvement 100,000 20,045 79,955 80%
PRJ000062 New Development Projects 13,489,471 7,558,370 5,931,101 44%
PRJ000073 Power Quality Improvements 50,000 - 50,000 100%
PRJ000147 Sectionalization Improvements 2,100,000 - 2,100,000 100%
PRJ000175 I-35 Mobility Project TxDot 239,848 280,160 (40,312) -17%
PRJ000189 Ronald Reagan - Glasscock Feeder Extension along Hwy 195 -Phase I 560,000 269,870 290,130 52%
PRJ000192 Ronald Reagan - Glasscock Feeder extension along Hwy 195 - Phase II 591,250 288,906 302,344 51%
PRJ000195 Downtown Overhead Rehab 2,400,000 39,610 2,360,390 98%
PRJ000221 Titan-Aviation Dr to IH35 Infrastructure Addition 1,500,000 1,116,820 383,180 26%
PRJ000225 Chapel Hill, WS-11139 (GEO-45-C.3)454,634 454,634 - 0%
PRJ000226 Wolf Ranch West - Section 1AG & 1BG 500,283 500,283 - 0%
PRJ000227 Ascend Westinghouse Apartments 444,598 315,708 128,890 29%
PRJ000229 Sun City NH 76 WS-11188 (GEO-18.2-N.51)274,030 205,450 68,580 25%
PRJ000230 Sun City NH 78 296,400 118,796 177,604 60%
PRJ000231 Georgetown Titan Development 1 & 2 140,428 119,322 21,106 15%
PRJ000232 Texas Outdoor Power Building 1 91,414 64,415 26,999 30%
PRJ000234 Summit at Westinghouse Self-Storage 49,685 37,046 12,639 25%
PRJ000236 Medcore (Georgetown) Senior Living 226,972 226,236 736 0%
PRJ000238 The Oscar at Georgetown 366,351 222,886 143,465 39%
PRJ000239 Wolf Ranch West - Section 3 - Phase 2 418,339 294,421 123,918 30%
PRJ000242 Allora North Georgetown 557,422 188,268 369,153 66%
PRJ000243 Fairfield Inn - WS11346 131,340 43,084 88,256 67%
PRJ000245 Morgan Mays Street Apartments 452,508 215,330 237,178 52%
PRJ000246 Vida Apartments 198,248 112,643 85,606 43%
PRJ000247 Georgetown (Longhorn) Travel Center Rev 193,845 129,463 64,381 33%
PRJ000250 Georgetown Infiniti 135,633 56,141 79,492 59%
PRJ000270 System Improvements - Power Quality 750,000 61,650 688,350 92%
PRJ000271 System Improvements - Capacity Upgrades 9,275,375 42,759 9,232,616 100%
PRJ000272 Wolf Lakes 566,109 492,161 73,948 13%
PRJ000273 The Grove II Townhomes 108,924 35,897 73,027 67%
81
CITY OF GEORGETOWN CAPITAL PROJECTS Project Budget Total Spend Remaining Budget Percent Remaining
PRJ000282 ANB Systems - Interconnection Service Portal 80,000 23,046 56,954 71%
PRJ000283 Partners Software and Implementation 120,000 79,500 40,500 34%
PRJ000284 Woodgate Development 195,933 136,194 59,739 30%
PRJ000285 Titan NorthPark 35 - Building 3 121,752 72,353 49,399 41%
PRJ000286 Wolf Ranch West - Section 2G 489,900 309,405 180,495 37%
PRJ000287 Gateway 35 - Building 1 266,676 201,486 65,190 24%
PRJ000288 Round Rock 2 Apartments 472,173 398,806 73,367 16%
PRJ000289 Wolf Lakes Offsite Utility 307,445 144,054 163,392 53%
PRJ000290 Windmill Hill Blue Ridge Drive Extension 257,827 180,290 77,536 30%
PRJ000291 Chick-Fil-A Expansion at WR SC 72,396 61,448 10,949 15%
PRJ000292 Aviation Drive Extension - Lift Station 48,390 34,997 13,392 28%
PRJ000296 Sun City NH10 - Phase B 121,331 121,331 - 0%
PRJ000299 Wolf Lakes Apartments - Hines Tract 446,777 30,978 415,799 93%
PRJ000300 Wolf Lakes Bella Lago Underground Extension 314,510 302,994 11,516 4%
PRJ000301 Titan NorthPark 35 - Building 5 166,073 18,738 147,334 89%
PRJ000302 Somerset Hills - Phase A-B 575,715 783,213 (207,499) -36%
PRJ000303 Westinghouse Retail Center at Windmill Hill 69,152 39,262 29,890 43%
PRJ000305 Medical Towers at Georgetown 96,487 67,653 28,833 30%
PRJ000306 Toolman Business Park 168,802 94,183 74,619 44%
PRJ000307 Sonrisa MOB, WS-11306, MPN-21-19 79,207 79,157 51 0%
PRJ000308 Sun City Neighborhood 77 306,196 19,849 286,347 94%
PRJ000309 Sun City NH 80 166,562 73,937 92,625 56%
PRJ000312 Dutch Bros. Coffee at 1309 W. University 38,354 21,964 16,390 43%
PRJ000313 Rivery Crossing (WS# 11264)156,254 72,490 83,764 54%
PRJ000314 Hewlett Volkswagen 2022 Remodel (MPN# 21-106)43,767 3,912 39,855 91%
PRJ000315 Hope Ranch (MPN# 21-104)118,282 6,445 111,837 95%
PRJ000316 Wolf Lakes HEB (MPN# 21-95)120,668 44,635 76,034 63%
PRJ000317 Blue Springs Business Park (MPN# 21-108)474,203 333,908 140,296 30%
PRJ000318 Costco 270,223 214,341 55,882 21%
PRJ000319 Georgetown Logistics (MPN# 21-87)453,870 39,781 414,090 91%
PRJ000320 Amazon Sortation Facility - 17,830 (17,830) 0%
PRJ000321 Wolf Lakes - Bella June Extension 201,850 19,659 182,192 90%
PRJ000329 Sun City NH 79 (MPN# 22-14)149,174 104,178 44,996 30%
PRJ000330 2021 Airport Road Upgrade 484,281 - 484,281 100%
PRJ000331 Quail Valley (Phase 1) URD Voltage Conversion 240,344 24,034 216,310 90%
PRJ000334 Sun City Northpoint Amenity Center (MPN# 22-36)43,096 3,028 40,068 93%
PRJ000335 Stonemont Windmill Hill Industrial (MPN# 22-32)115,968 65,855 50,114 43%
PRJ000336 Wolf Lakes Ascension Seton Georgetown MOB (MPN# 22-9)114,712 69,135 45,577 40%
PRJ000340 Cellink (Gateway35 - Building 1) (MPN# 22-37)1,234,057 111,056 1,123,001 91%
PRJ000341 Gateway35 Building 3 (MPN# 22-27)276,306 - 276,306 100%
PRJ000342 Gateway35 Building 2 (MPN# 22-28)152,469 - 152,469 100%
PRJ000343 Gantt Serenada Subdivision (MPN# 22-44)25,414 - 25,414 100%
PRJ000345 Baylor Scott & White Expansion 147,236 - 147,236 100%
PRJ000346 Novak Chandra Multifamily - Wolf Lakes Village 536,146 22,831 513,316 96%
82
CITY OF GEORGETOWN CAPITAL PROJECTS Project Budget Total Spend Remaining Budget Percent Remaining
PRJ000347 Titan NorthPark 35 – Building 6 (MPN# 22-47)377,275 - 377,275 100%
PRJ000348 The Summit at Westinghouse (MPN# 22-26)358,809 - 358,809 100%
Electric Total 48,250,521 18,230,704 30,019,817 62%
Environmental Services
PRJ000116 Transfer Station 11,000,000 976,656 10,023,344 91%
Environmental Services Total 11,000,000 976,656 10,023,344 91%
Finance
PRJ000038 ERP Project 6,231,654 6,055,684 175,970 3%
Finance Total 6,231,654 6,055,684 175,970 3%
Fire
PRJ000134 SCBA Replacement 1,170,000 840,934 329,066 28%
PRJ000135 Cardiac Monitors 633,517 483,517 150,000 24%
Fire Total 1,803,517 1,324,451 479,066 27%
Fleet
PRJ000124 Radio Replacement 1,565,278 210,525 1,354,753 87%
PRJ000279 Electric Bond Funded Vehicles - FY22 1,065,000 958,977 106,023 10%
PRJ000280 Fire Bond Funded Vehicles - FY22 2,008,000 1,896,440 111,560 6%
PRJ000281 Police Bond Funded Vehicles - FY22 1,277,000 1,204,710 72,290 6%
Fleet Total 5,915,278 4,270,652 1,644,626 28%
GTEC Department
PRJ000046 FM 971/ Fontana (Nw Bridge)1,209,000 1,206,390 2,610 0%
PRJ000060 Rabbit Hill Road 4,100,000 564,090 3,535,910 86%
PRJ000145 Sh29 Signal And Roadway Improvements 1,595,000 410,979 1,184,021 74%
PRJ000181 Aviation Drive 10,300,000 10,088,053 211,947 2%
PRJ000183 Costco 2,000,000 - 2,000,000 100%
PRJ000203 FM1460 Widening 300,984 - 300,984 100%
PRJ000265 Project Diana (Witteria Way - Gateway 35)1,700,000 1,700,000 - 0%
GTEC Department Total 21,204,984 13,969,512 7,235,472 34%
Management Services
PRJ000029 Downtown Parking Garage 291,483 142,030 149,454 51%
PRJ000033 Dtwn Landsping & Public Art 5,746 5,746 - 0%
PRJ000042 Fire Station 6 5,500,000 5,322,599 177,401 3%
PRJ000043 Fire Station 7 7,198,744 6,470,715 728,030 10%
PRJ000131 Fuel Station 1,100,000 92,388 1,007,613 92%
PRJ000136 GMC Remodel Phase I 560,000 609,550 (49,550) -9%
PRJ000178 Public Safety Operation and Training Center Phase II 6,000,000 96,439 5,903,561 98%
PRJ000179 Recreation Center Teen/Senior Renovation 247,979 - 247,979 100%
PRJ000184 Airport Maintenance Facility 1,250,000 - 1,250,000 100%
83
CITY OF GEORGETOWN CAPITAL PROJECTS Project Budget Total Spend Remaining Budget Percent Remaining
PRJ000191 Georgetown City Center - Festival/Public Space 5,366,035 78,488 5,287,547 99%
PRJ000223 Wayfinding Signage 275,000 - 275,000 100%
PRJ000252 Fire Logistics Building 2,550,000 5,000 2,545,000 100%
PRJ000337 Downtown Austin Ave Parking Garage - ARPA 7,800,000 856,200 6,943,800 89%
Management Services Total 38,144,987 13,679,154 24,465,833 64%
Parks
PRJ000048 Garey Park 15,346,730 15,282,581 64,149 0%
PRJ000125 Parks Master Plan 229,998 225,408 4,590 2%
PRJ000126 Regional Trail Development 1,302,684 1,280,118 22,566 2%
PRJ000129 Ada Transition Plan 1,075,982 816,652 259,330 24%
PRJ000190 Heritage Gardens 275,860 267,353 8,507 3%
PRJ000240 South Main Plaza 306,415 62,750 243,665 80%
PRJ000244 Grace Heritage Plaza 90,000 90,000 - 0%
PRJ000249 GVPID Landscape Improvements 61,500 59,250 2,250 4%
PRJ000253 Southeast Community Park 14,500,000 - 14,500,000 100%
PRJ000278 Regional Trail Improvements 739,000 74,900 664,100 90%
PRJ000293 San Gabriel Park - Phase 3 7,813,870 700,919 7,112,951 91%
PRJ000322 Crystal Knoll Park 250,000 40,700 209,300 84%
PRJ000323 Madison Oaks Park 50,000 14,500 35,500 71%
PRJ000324 Vista Vera Park 250,000 40,700 209,300 84%
PRJ000326 Westhaven Park I and II 250,000 47,700 202,300 81%
PRJ000327 La Conterra Park 250,000 40,700 209,300 84%
PRJ000328 Waypoint Park 200,000 14,500 185,500 93%
Parks Total 42,992,038 19,058,730 23,933,308 56%
Public Works Department
PRJ000013 Austin Avenue Bridge 2,855,398 1,773,738 1,081,660 38%
PRJ000063 Northwest Blvd Bridge 421,578 421,578 - 0%
PRJ000137 Intersection Improvements (Lakeway @ Williams Drive)1,759,578 1,759,578 - 0%
PRJ000138 Downtown Sidewalks 3,679,978 1,616,723 2,063,255 56%
PRJ000139 Westinghouse - Scenic Lake Traffic Signal 600,000 343,447 256,553 43%
PRJ000140 Austin Ave Bridges 10,184,000 - 10,184,000 100%
PRJ000141 Southwestern Blvd 4,200,000 876,460 3,323,540 79%
PRJ000143 Leander Rd(Norwood-Swbypass)6,750,000 1,656,169 5,093,831 75%
PRJ000172 2020 Street Maintenance High Performance Seal: Bid Package No.1 372,200 349,542 22,658 6%
PRJ000173 2020 Street Maintenance High Performance Seal: Bid Package No. 2 463,195 337,719 125,476 27%
PRJ000174 2020 street maintenance HIPR 1,935,589 1,191,547 744,042 38%
PRJ000188 DB Wood (SH 29 to Oak Ridge)18,000,000 1,703,636 16,296,364 91%
PRJ000202 FM 971 5,821,392 5,821,392 0 0%
PRJ000207 Northwest Blvd Bridge 12,418,528 11,319,255 1,099,273 9%
PRJ000209 Southeast Inner Loop 10,521,000 8,673,393 1,847,607 18%
PRJ000210 2021 HIPR Street Maintenance 2,300,000 2,294,978 5,022 0%
PRJ000211 2021 High Performance Pavement Seal Project #1 785,719 712,642 73,077 9%
84
CITY OF GEORGETOWN CAPITAL PROJECTS Project Budget Total Spend Remaining Budget Percent Remaining
PRJ000212 2021 High Performance Pavement Seal Project #2 515,698 492,265 23,433 5%
PRJ000214 Intersection Improvements (Traffic Signals) 1,650,000 1,287,478 362,522 22%
PRJ000215 2021 Intersection Safety Enhancements (RRFB) 475,166 502,166 (27,000) -6%
PRJ000216 FY21 Downtown Sidewalk Improvements 1,000,000 130,000 870,000 87%
PRJ000254 Shell Road 12,503,000 - 12,503,000 100%
PRJ000255 Rockride Lane 5,776,000 - 5,776,000 100%
PRJ000256 Westinghouse Road 8,200,000 8,200,000 - 0%
PRJ000257 Sam Houston Ave Ext/SE1/Wilco Corridor 4,000,000 3,923,605 76,395 2%
PRJ000258 DB Wood (Oak Ridge to Williams Dr) 21,163,600 - 21,163,600 100%
PRJ000267 Allocations - Intersections/Bike Lanes/Sidewalks - MB21 10,800,000 - 10,800,000 100%
PRJ000277 Intersection Improvements - FY22 1,162,150 - 1,162,150 100%
PRJ000294 2022 HIPR 2,750,000 2,808,959 (58,959) -2%
PRJ000295 2022 High Performance Pavement Seal 1,245,021 209,300 1,035,721 83%
PRJ000297 Southeast Inner Loop - MB21 32,777,940 - 32,777,940 100%
PRJ000304 Memorial Drive 3,100,000 - 3,100,000 100%
PRJ000310 Southwest Bypass (Wolf Ranch Parkway to SH29) 2,000,000 2,000,000 - 0%
Public Works Department Total 192,186,728 60,405,568 131,781,159 69%
Stormwater
PRJ000004 18th and Hutto Drainage 164,793 11,469 153,324 93%
PRJ000024 2020 Curb & Gutter 1,055,000 766,902 288,098 27%
PRJ000104 Stormwater Infrastructure 347,000 168,506 178,495 51%
PRJ000149 Drainage Improvement/Flood Mitigation Projects 300,000 - 300,000 100%
PRJ000213 2021 Curb & Gutter Project 500,000 64,300 435,700 87%
PRJ000274 2022 Curb & Gutter 500,000 65,250 434,750 87%
Stormwater Total 2,866,793 1,076,427 1,790,367 62%
Water
PRJ000014 Berry Creek Inter.49,949,000 3,153,588 46,795,412 94%
PRJ000017 Cedar Breaks Est 3,385,000 - 3,385,000 100%
PRJ000023 Cr 255 (Wd14-2)1,817,359 319,081 1,498,278 82%
PRJ000034 Earz 2,326,000 364,015 1,961,985 84%
PRJ000057 Lift Station Upgrade 1,073,593 326,103 747,490 70%
PRJ000059 LWTP Raw Water Intake Rehab 6,750,000 5,666,956 1,083,044 16%
PRJ000066 Park Lift Station & Force Main 2,025,678 2,115,383 (89,705) -4%
PRJ000096 Shell Road Water Line 6,890,000 1,111,260 5,778,740 84%
PRJ000101 Southlake Wtp 278,000,000 190,373,635 87,626,365 32%
PRJ000119 Water Mains 1,536,750 501,352 1,035,398 67%
PRJ000150 Carriage Oaks Transmission 5,450,000 430,800 5,019,200 92%
PRJ000152 Hoover Pump Station 13,550,000 855,221 12,694,779 94%
PRJ000154 Stonewall Ranch Pump Station Improvements 3,100,000 300,825 2,799,175 90%
PRJ000155 Southside Water Treatment Plant 6,426,706 6,361,550 65,156 1%
PRJ000156 Gatlin/Teravista Improvements 450,000 - 450,000 100%
PRJ000157 Leander Interconnect 340,245 315,245 25,000 7%
85
CITY OF GEORGETOWN CAPITAL PROJECTS Project Budget Total Spend Remaining Budget Percent Remaining
PRJ000160 Round Rock Supply Pump Station And Elevated Storage Tank 10,500,000 1,427,473 9,072,527 86%
PRJ000161 Miscellaneous Line Upgrades 1,922,000 638,430 1,283,570 67%
PRJ000162 South West Bypass Water (H24-1) 2,906,000 2,384,594 521,406 18%
PRJ000163 Tank Rehabilitation 4,099,536 432,666 3,666,870 89%
PRJ000165 San Gabriel WWTP Rehabilitation 18,757,307 1,622,000 17,135,307 91%
PRJ000167 San Gabriel Inter SGI -2 4,500,000 912,755 3,587,245 80%
PRJ000168 WWTP Upgrade 950,000 209,000 741,000 78%
PRJ000177 Northlake WTP Phase IV Expansion 15,000,000 14,843,304 156,696 1%
PRJ000185 Cimarron Hills Wastewater Treatment Plant Expansion 5,300,000 799,325 4,500,675 85%
PRJ000218 EARZ Wastewater Rehabilitation Area 2 - 2019 2,768,469 2,460,360 308,109 11%
PRJ000219 Southside GST Foundation Improvements 535,678 485,678 50,000 9%
PRJ000220 AMI Equipment Upgrades 7,750,000 - 7,750,000 100%
PRJ000228 Southside GST Roof Rehab 791,500 599,500 192,000 24%
PRJ000241 2020 - 2021 EARZ - Area 3 1,500,000 516,820 983,180 66%
PRJ000259 Pecan Branch WWTP Expansion 37,000,000 52,200 36,947,800 100%
PRJ000260 CR 262 Waterline 2,500,000 187,200 2,312,800 93%
PRJ000261 Dove Springs WWTP Rehabilitation 12,098,663 516,900 11,581,764 96%
PRJ000262 Wolf Ranch Expansion and Force Main 5,900,000 - 5,900,000 100%
PRJ000263 Water - Wastewater Master Plan 1,225,000 710,835 514,165 42%
PRJ000264 Interceptor Lift Station Removal & Gravity Main 8,500,000 - 8,500,000 100%
PRJ000266 SCADA Upgrades 1,500,000 - 1,500,000 100%
PRJ000268 System Resiliency 18,525,000 1,023,320 17,501,680 94%
PRJ000275 FY2022 EARZ -Area 4 2,000,000 - 2,000,000 100%
PRJ000333 Smith Branch Lift Station Improvements 1,300,000 - 1,300,000 100%
Water Total 550,899,484 242,017,372 308,882,112 56%
Grand Total 922,235,983 381,306,452 540,929,531 59%
86
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 03/31/22 Status Updates ‐ 06/30/22
Cemetery Special Revenue
Fund Perpetual Reserve
Currently cemetery operations are self‐funded through plot
sales of approximately $50K per year. The cemetery is
managed through Parks Administration. In 2015, Council
elected to transfer $75,000 annually for future costs
associated with maintaining the property. The General
Fund has made this transfer in since FY 2016. While the
perpetual reserve has grown slowly, it is not on pace to
sustain the Cemetery Fund long‐term. The fund is estimated
to need a $5 million balance to be self‐sustaining on interest
earnings and cemetery revenue.
No change. Council gave no direction on cemetery fund
during March 8 workshop.
During the July General Government and Finance
Advisory Board meeting, Leigh Wallace presented an
update to the Fiscal and Budgetary Policies. One update
included the recommendation to discontinue to the
Cemetery Perpetual Reserve. The General Fund has not
been able to support transfers large enough to establish
a reserve, nor have interest rates been high enough,
that will earn enough interest to maintain the
cemeteries. Council heard the recommendation in
Workshop on August 9. Council will adopt the policies in
September with the FY2023 budget. The budget will
continue to include an annual $75,000 transfer from the
General Fund to the Cemetery fund to supplement
maintenance costs above cemetery sales revenue. Staff
will monitor any need to adjust the transfer or adjust
cemetery fees in the future. Recommend removing
item from list next quarter.
Unfunded Actuarial Accrued
Liability (UAAL)
Recognizes the outstanding liability for the City’s employee
retirement plan through TMRS. The City contributes
monthly to fund the UAAL, based on an annual percentage
of payroll. Actual % of payroll costs is recognized within each
fund. The UAAL is provided by TMRS and lags one year.
The City's FY2021 year‐end unfunded liability was
estimated at $21.5M. This increase in liability is due to a
change in the actuarial assumptions. The plan is 89.2%
funded, which is an excellent funding ratio. The funded
ratio has steadily increased from the low 80's over the
past 5 years.
The City's FY2021 year‐end unfunded liability was
estimated at $21.5M. This increase in liability is due to a
change in the actuarial assumptions. The plan is 89.2%
funded, which is an excellent funding ratio. The funded
ratio has steadily increased from the low 80's over the
past 5 years. No change. This figure is calculated once
annually.
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/21 is $4.9 million. No change.
This report is conducted bi‐annually.
OPEB liability as of 9/30/21 is $4.9 million. No change.
This report is conducted bi‐annually.
CITY OF GEORGETOWN
Long-term Commitments, Reservations, and Other Unfunded Liabilities
06/30/2022
87
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 03/31/22 Status Updates ‐ 06/30/22
CITY OF GEORGETOWN
Long-term Commitments, Reservations, and Other Unfunded Liabilities
06/30/2022
Compensated Absence
Future costs associated with benefits such as vacation, and
sick leave for City employees. Compensated Absence is
accrued annually to each proprietary fund type on a GAAP
basis and accounted for on the balance sheet of each fund.
For governmental funds (and for budgetary basis), the
expense is recognized when due and payable. The City
keeps a reserve in the General Fund to help offset large
payouts for long‐term employees. The reserve is used as
needed, and annually replenished or increased based on
known risk.
Compensated absences as of 9/30/21 are $8.4 million. No
change. This calculation is performed once annually.
Compensated absences as of 9/30/21 are $8.4 million. No
change. This calculation is performed once annually.
Airport Maintenance
Fund on‐going maintenance of the Airport grounds,
runways and taxi ways. Terminal and Tower included in
Facilities ISF. An Airport Master Plan was developed to
address long term capital maintenance project
prioritization.
No Change Need to review with new Airport Manager and Public
Works Director.
Americans with Disabilities Act
(ADA) Compliance Needs
As facilities are built or repurposed, meeting ADA
compliance will be included in Project Costs. Funding for
program expansion will be needed (General Fund sources).
The City has an adopted policy, as required by Federal Law,
that it will make reasonable accommodations and
modifications to ensure that people with disabilities have an
equal opportunity to enjoy its programs, services, and
activities. The City does not maintain a reserve for these
modifications.
ADA trail improvements along the South San Gabriel
River trail are under design. The final trail and park
ADA improvements are scheduled to be completed
in FY23.
88
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 03/31/22 Status Updates ‐ 06/30/22
CITY OF GEORGETOWN
Long-term Commitments, Reservations, and Other Unfunded Liabilities
06/30/2022
Sidewalk Maintenance &
Masterplan
Currently, new sidewalks are built as development occurs.
Repairs are funded as needed or if funding is available,
when major roads are repaired. Useful life of a sidewalk is
estimated at 40 to 50 years. The largest revenue source
comes from the City’s General Fund, but there has been
some debt funding as well.
Old Town NE Sidewalk ‐ Contractor has completed 95%
of the project. All sidewalk and pedestrian ramps are in
place. TDLR inspection and walk‐through to be completed
in Mid‐May. Contractor to address any punch list items.
Rock Sidewalk and FY 20 Downtown sidewalk project is
wrapping up and substantially completed. FY21 and FY
22 Downtown Priority 1 sidewalk projects are in design.
Coordination between stakeholders is ongoing and we
plan to be able to advertise and bid the project in the fall
of 2022.
Park Equipment Maintenance
& Replacement
Over the past 5 years, funding for Park Maintenance and
Replacement has increased. $200K transfer from General
Fund included in FY2018 budget. Staff has listed all assets &
developed replacement schedule funded by the General
Fund.
No change For several years, the General Fund has been making an
increasingly large transfer to the Parks Maintenance Fund
to cash fund maintenance like painting parking lots and
equipment replacement such as slides at the Recreation
Center Pool. The FY2022 funding level is $300,000. Due
to the costs of materials and equipment, as well as the
increase in developed park land, Parks requested an
increase in support for the fund for the 5‐year forecasted
schedule. Since the General Fund is under considerable
pressure from property tax revenue caps, and increasing
expenses due to service demand and inflation, staff are
recommending transitioning the equipment replacement
from cash funding to short‐term debt‐funding. The tax‐
supported CIP schedule has been updated to include
$500,000 per year for parks equipment replacement. The
General Fund will continue to fund $50,000 for the
maintenance activities that cannot be debt‐funded.
Recommend removing item from list next quarter.
Radio Equipment Replacement
Communication system consisting of 500 on‐body and in‐
vehicle radios for Police, Fire, parks and utilities.
Replacement radios are compatible with newer technology.
The replacement takes place over 5 years due to cost and is
funded with certificate of obligation debt.
Approximately $570,000 is needed to finish this project in
FY2023. This will be included in the proposed budget.
$627,000 was included in the FY2023 budget to finish this
program.
89
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 03/31/22 Status Updates ‐ 06/30/22
CITY OF GEORGETOWN
Long-term Commitments, Reservations, and Other Unfunded Liabilities
06/30/2022
Street Maintenance
The City funds street maintenance in the General Fund,
supplemented by a 1/8th Street Sales Tax special revenue
fund. In 2017 and 2018, the Council and GTAB reviewed
various methods for enhanced street maintenance and
costs. Direction from Council is to use high performance
surface seals and pavement wearing courses and begin
programmatically addressing the street network's deferred
maintenance backlog, creating a need for approximately $2
million more per year for street maintenance.
2022 HIPR (Cutler), 2022 High Performance Pavement
Seal #1 (PMM) and 2022 High Performance Pavement
Seal #2 (HA5). These projects are out to bid. Scheduled to
be considered by GTAB for award at the May meeting,
followed by Council the 2nd meeting in May.
2022 HIPR (Cutler), 2022 High Performance Pavement
Seal #1 (PMM) and 2022 High Performance Pavement
Seal #2 (HA5). These projects have been awarded by City
Council. Contractors to start on these project in
September. Pre‐construction meetings are being
scheduled and neighborhood schedules will be going out
to notify residents. The election is schedule for November
2022.
90