HomeMy WebLinkAbout1st_Qtr_Report_FY2023A CARING COMMUNITY HONORING OUR PAST AND INNOVATING FOR THE FUTURE
FY2023 Quarterly Report
1st Quarter
FINANCIAL REPORT AND INVESTMENT REPORT
For the Quarter Ended December 31, 2022
Table of Contents
General Fund Narrative .............................................................................................................................. 1-7
General Fund Schedule ................................................................................................................................. 8
General Fund by Cost Center ................................................................................................................... 9-11
Electric Fund Narrative ........................................................................................................................... 12-14
Electric Fund Schedule ................................................................................................................................ 15
Water Services Fund Narrative ............................................................................................................... 16-18
Water Services Fund Schedule .................................................................................................................... 19
Convention & Visitors Bureau Narrative................................................................................................. 20-21
Convention & Visitors Bureau Fund Schedule ............................................................................................. 22
Airport Fund Narrative ........................................................................................................................... 23-24
Airport Fund Schedule ................................................................................................................................. 25
Stormwater Services Narrative ............................................................................................................... 26-27
Stormwater Services Fund Schedule ........................................................................................................... 28
Georgetown Transportation Enhancement Corporation Fund Narrative ............................................... 29-30
Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 31
Georgetown Economic Development Corporation Fund Narrative ....................................................... 32-33
Georgetown Economic Development Corporation Fund Schedule ............................................................. 34
Village PID Services Narrative ...................................................................................................................... 35
Village PID Services Fund Schedule ............................................................................................................. 36
Council Discretionary Fund Schedule .......................................................................................................... 37
Joint Services Fund Schedule ....................................................................................................................... 38
Investment Report.................................................................................................................................. 39-41
Quarterly Investment Report - City ........................................................................................................ 42-61
Quarterly Investment Report - GEDCO ................................................................................................... 62-67
Quarterly Investment Report - GTEC ...................................................................................................... 68-73
Grant Applications ....................................................................................................................................... 74
Capital Improvement Projects ................................................................................................................ 75-81
Quarterly Financial Report
F FY2021 Quarterly Report EXECUTIVE SUMMARY FOR THE QUARTER ENDED DEC. 31, 2022
I.QUARTERLY FINANCIAL ANALYSIS
Each year, the City amends the budget for multi-year capital projects, as well as operational
changes that were unknown at the time the budget was adopted. The First Quarter Report
Approved Budget includes the Capital Project Roll Forward. Furthermore, this report compares
actuals to budget and the performance of current actuals to actuals of the same quarter in the
previous year.
GENERAL FUND REVENUES:
General Fund revenues total $25,311,132, or 23.58% of budget through the end of the quarter. Revenues are
higher than last year’s same quarter total by $815,941, or 3.33%. The City continues to see a strong
performance in revenue, particularly in planning fees, sales tax, interest earnings.
General Fund
Quarterly Comparison: : Q1 FY23 Budget FY2022 FY2023
FY2023 Year-to-date:
Budget Vs. Actuals Quarterly Comparison
FY2023 YTD Actuals: Q1 FY22 YTD Actuals: Q1 FY23 Variance % of Budget Variance % Variance
Revenue 40001:Property Taxes 18,700,000 9,151,312 9,600,081 (9,099,919) 51.34% 448,769 4.90% 40002:Sales Taxes 30,749,397 2,189,990 2,367,808 (28,381,589) 7.70% 177,818 8.12%
40005:Franchise Taxes 6,820,940 983,198 1,066,666 (5,754,274) 15.64% 83,468 8.49%
40008:Other Taxes 576,473 53,355 55,569 (520,904) 9.64% 2,214 4.15% 41001:Fines 270,800 58,347 80,812 (189,988) 29.84% 22,465 38.50% 41002:Penalties 111,348 28,885 33,406 (77,942) 30.00% 4,520 15.65%
42001:Interest Income 100,000 13,024 222,903 122,903 222.90% 209,879 1611.47%
43001:Fees 9,927,405 2,135,213 2,251,497 (7,675,908) 22.68% 116,284 5.45% 43002:Garbage Charges 12,095,135 3,009,161 3,252,628 (8,842,507) 26.89% 243,467 8.09% 43003:Permits 6,548,500 1,484,687 1,189,272 (5,359,228) 18.16% (295,415) -19.90%
43004:Administrative Charges 2,000,000 679,073 500,002 (1,499,998) 25.00% (179,071) -26.37%
43005:Rental Revenue 127,692 39,331 10,163 (117,529) 7.96% (29,168) -74.16% 45001:Misc Revenue 883,850 58,248 113,465 (770,385) 12.84% 55,217 94.80% 45003:Misc Reimbursements - 965 609 609 0.00% (356) -36.92%
45004:Sale of Property - - 150,416 150,416 0.00% 150,416 0.00%
44001:Grant Revenue 40,000 105,641 101,531 61,531 253.83% (4,110) -3.89% 44501:Contribution Revenue 145 296 - (145) 0.00% (296) -100.00% 44502:Developer Contributions - 168,109 239,753 239,753 0.00% 71,644 42.62%
44503:Interlocal Agreement
Revenue 5,991,960 1,323,293 1,392,500 (4,599,460) 23.24% 69,208 5.23% 44504:Donations - - 789 789 0.00% 789 0.00% 70001:Transfers In 1,765,500 410,407 - (1,765,500) 0.00% (410,407) -100.00%
70002:Transfers In - Payment
in Lieu of Taxes (PILOT) 10,615,004 2,602,655 2,681,263 (7,933,741) 25.26% 78,608 3.02%
Revenue Total 107,324,149 24,495,191 25,311,132 (82,013,017) 23.58% 815,941 3.33%
1
Quarterly Financial Report
F FY2021 Quarterly Report
Sales tax revenue accounts for $30,749,397 of
General Fund budgeted revenue. Through the
quarter, the City has collected 7.70% of the
budgeted sales tax amount, or 2,367,808 year-to-
date. Sales tax data lags two months in arrears.
Although sales tax continues to perform strongly,
with quarterly returns being 8.12% greater than
the same period last year, the month-to-month
comparison of FY2022 and FY2023 sales tax
returns indicates a slowing down of rapid growth
recently experienced. The majority of the increase
in sales tax can be attributed to growth in the
Retail and Other sectors; however, within the
retail sector, building materials, which over the
past three years has on average accounted for
17.5% of total sales tax, has seen a decrease in year-to-date actuals when compared to the same
period during the previous year. Because sales tax is the largest source of revenue in the general
fund and also subject to volatility, staff is closely monitoring the City’s core sectors of retail
(specifically building materials), food, and information. The City continues to reserve a fully
funded (8%) Economic Stability Reserve to protect against any volatility in sales tax revenue.
Several, new vacant positions are also on hold while the city monitors sales tax and development
revenue.
Property tax revenues are the second largest revenue segment in the General Fund and has a
budget of $18,700,000. Property tax revenue is typically received during the first two quarters of the
fiscal year, with most of the taxes collected in December and January. Through the quarter,
property tax year-to-date collections total 51.34% of budget, or $9,600,081. Year-to-date property tax
revenues are 4.90% greater than the same period last year.
The City collects franchise fees for electric, natural gas, cable, and non-cellular telephone services.
Through the quarter, franchise fee revenues total $1,066,666 in FY2023, or 15.64% of budget.
Franchise fee revenue is 8.49% higher than the same quarter of FY2022. While most franchise fees
saw increases from the same quarter of FY2022, the major increases are from electric, water,
garbage and gas franchise fees.
Payment in Lieu of Taxes (PILOT) revenue from City-owned utilities is budgeted at $10,615,004.
Year-to-date, PILOT revenues total $2,681,263, or 25.26% of budget. PILOT revenue is $78,608, or
3.02%, higher than the same quarter of FY2022. While all utility funds PILOT is trending slightly
higher than budget, the majority of the increase for the quarter is from Water and Electric. Electric
PILOT was capped at $5.5 million, per Council direction.
Planning and Development related revenue has slowed down in FY2023 due to a significant
decrease in the number of residential building permits issued. Planning and Development has a
total revenue budget of $9,344,155. Through the quarter, planning and development related
revenues total $1,813,827 or 19.41% of budget. Permit fees are down 15.54%, or $116,597 compared to
the same quarter in FY2022. Development related permits year-to-date revenues are down 20.08%,
or $296,425 compared to the same period in FY2022. Staff continues to monitor the amount of
residential and commercial building permits. FY2023 development revenue and expenses are also
K
500K
1.0M
1.5M
2.0M
2.5M
Q1
GENERAL FUND: SALES
TAX
FY2021 FY2022 FY2023
2
Quarterly Financial Report
F FY2021 Quarterly Report
being closely monitored for economic impacts. The following graph shows the number of
residential building permits issued during the first quarter for the past 3 years.
Sanitation revenue budget totals $12,095,135. Through the quarter, year-to-date revenues from
sanitation is $3,252,628, or 26.89% of budget. Sanitation rates increased as part of the FY2023 budget
to support demand for service as well as to support the debt service for a new transfer station. The
variance between the same period last year is $243,467, or 8.09%. An environmental services cost
of service study wrapping up in the winter of FY2023, with initial results presented to Council in
February 2023.
Fire and EMS total budgeted revenue is $8,771,250. Through the quarter, Fire and EMS fee related
revenue totals $2,198,063, or 25% of budget. Additional Fire/EMS revenue is comprised of the
Interlocal Agreement Emergency Services District 8 contract for service, as well as public safety
grants revenue.
Parks and Recreation fee revenue budget totals $3,263,000. Through the quarter, parks and
recreation related fee revenue totals $719,850, or 22.06% of budget. Parks and Recreation revenue
is up 21.26% compared to FY2022. The Parks and Recreation department has seen an increase in
revenue compared to FY2022 coupled with fee adjustments to align with the cost recovery model
approved by Council, and programming returning to pre-pandemic levels.
GENERAL FUND EXPENSES:
Annual expenses through the quarter total $28,249,711, or 24.79% of budget. This is an increase of
18.71% compared to the same period last year. The increase is driven by increases in operational
expense such as internal service allocations, timing of transfers, consulting fees and sanitation
services. Additionally, general increases in expenses compared to the same period last year are due
to inflation, staff compensation, and new or enhanced programs.
Personnel and Operations Summary:
Personnel costs through the quarter total $12,987,725, or 21.75% of personnel budget. Operational
costs total $15,087,817, or 29.11%. The table below includes all expenditures in the General Fund.
Capital costs can fluctuate from year-to-year based on projects, timing, and various other factors,
primarily in the Streets cost center.
-
200
400
600
800
1,000
Q1
Residential Building Permits
FY2021 FY2022 FY2023
3
Quarterly Financial Report
F FY2021 Quarterly Report
General Fund
Quarterly Comparison:
Q1 FY23 Budget FY2022 FY2023
FY2023 Year-to-date:
Budget Vs. Actuals Quarterly Comparison
FY2023 YTD Actuals: Q1 FY22 YTD Actuals: Q1 FY23 Variance % Of Budget Variance % Variance
Expense Personnel 59,724,027 11,470,657 12,987,725 46,736,302 21.75% (1,517,068) 13.23% Operations 51,835,653 10,349,862 15,087,817 36,747,837 29.11% (4,737,955) 45.78%
Operating Capital 787,309 466,289 174,170 613,139 22.12% 292,119 -62.65%
Transfers 1,590,765 1,510,635 - 1,590,765 0.00% 1,510,635 -100.00%
Total Expense 113,937,754 23,797,443 28,249,711 85,688,042 24.79% (4,452,268) 18.71%
A complete list of cost center, and budget compared to actuals is attached as part of supplemental
information to this report.
Personnel and Operations Summary by Division:
DEVELOPMENT SERVICES DIVISION:
Through the quarter Planning has reported expenses totaling $1,080,006, or 29.44% of budget. The
Planning Department has personnel savings due to vacancies. Year-to-date Planning operations
expense is 87.02% over the same period in FY2022. This increase is due to the timing of updating
the Unified Development Code that was approved by Council on October 25, 2022.
Inspections incurred personnel and operational expenses amounting to $496,460, or 18.71% of
budget.
Year-to-date personnel and operational expenditures for Community Services are as follows,
Emergency Management cost center has a total of $47,487, or 11.74% of budget, through the
quarter, Animal Services has reported $241,428, which is 18.77% of their budget, Code Compliance
has shown spending of $142,080, or 20.48% of budget.
Environmental Services incurred personnel and operational expenditures amounting to
$2,383,665, or 21.58% of budget.
Public Works personnel and operational expenditures for the quarter totals $958,737, which
represents 57.47% of budget. The higher than expected year-to-date includes one-time funding
encumbered to update the future land use plan and the sidewalk master plan. Year-to-date
expenditures related to personnel and operations for Streets totals $1,432,295, 26.61% of budget.
FINANCE ADMINISTRATION DIVISION:
Municipal Court year-to-date expenses total $135,471, or 22.62% of budget. This spending includes
$108,069 for personnel costs and $27,402 for operational costs.
POLICE OPERATIONS DIVISION:
Police Operations saw personnel and operational expenditures through the quarter total
$4,542,420, or 23.43% of budget. Police Administration expenditures through the quarter resulted
in $758,924, or 25.26% of budget.
4
Quarterly Financial Report
F FY2021 Quarterly Report
FIRE AND EMS DIVISION:
Year-to-date personnel and operational expenditures through the quarter total $1,361,964, or
27.84% of budget for Fire Support Services/Administration, $4,985,010, or 24.92% of budget for
Fire Emergency Services, and $1,112,342, or 29.95% of budget for Fire EMS.
ADMINISTRATIVE SERVICES DIVISION:
Administrative Services saw operational and personnel costs totaling $712,693, or 24.42% of
budget year-to-date. The cost center includes one-time funding for consulting, continuation of a
“311 like” system, and studies that were not completed in FY2022.
City Secretary personnel and operational expenditures for the quarter totals $316,602, which
represents 20.54% of budget.
Year-to-date personnel and operational expenditures for Communications totals $404,718, which
represents 27.07% of budget.
Non-Departmental includes a budget of $1,590,765 for transfers out to various funds. As of the first
quarter, 0.00% of anticipated transfer expenses have been made.
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. Additionally, this is where the City budgets for various approved economic
development related incentives.
LIBRARY, TOURISM, AND ARTS AND CULTURE DIVISION:
Arts and Culture recognized year to date expenses totaling $70,098, or 15.56% of budget. Library
year-to-date expenses total $893,648, or 23.72% 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, comes to a total
of $2,761,117, or 24.25% of budget.
Parks year-to-date through the quarter totals $980,315, or 27.65% of budget. Recreation total
expenses are $1,156,759, which is 21.85% of budget. Garey Park year-to-date is $317,809, or 26.23% of
budget. Personnel expenses in recreation are heavily seasonal, and a significant portion of part-
time and temporary salaries will be reflected in the fourth quarter.
5
Quarterly Financial Report
F FY2021 Quarterly Report
Personnel and Operations Summary by Division:
General Fund
Quarterly Comparison: Q1 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals
FY2023 YTD Actuals:
Q1 FY22
YTD Actuals:
Q1 FY23 Variance % of Budget
Development Services
Personnel 8,429,573 1,316,386 1,583,377 6,846,196 18.78% Operations 18,784,404 3,189,308 5,670,497 13,113,907 30.19%
Operating Capital 7,000 - 1,939 5,061 27.70%
Transfers - - - - 0.00%
Development Services Total Expense 27,220,977 4,505,694 7,255,812 19,965,165 26.66%
Finance Administration
Personnel 489,044 106,865 108,069 380,975 22.10%
Operations 109,973 24,937 27,402 82,571 24.92%
Finance Administration Total Expense 599,017 131,802 135,471 463,546 22.62% Police Operations
Personnel 16,264,597 3,312,078 3,574,664 12,689,933 21.98% Operations 5,812,678 1,429,239 1,613,115 4,199,563 27.75% Operating Capital 311,983 427,487 113,566 198,417 36.40% Police Operations Total Expense 22,389,258 5,168,804 5,301,345 17,087,913 23.68%
Fire and EMS
Personnel 22,201,451 4,524,925 5,124,733 17,076,718 23.08% Operations 6,166,495 1,439,944 2,292,562 3,873,933 37.18%
Operating Capital 242,185 30,129 42,021 200,164 17.35%
Fire and EMS Total Expense 28,610,131 5,994,998 7,459,315 21,150,816 26.07%
Administrative Services, Arts and Culture Personnel 2,446,077 452,833 714,828 1,731,249 29.22%
Operations 13,493,727 2,464,719 3,290,826 10,202,901 24.39%
Operating Capital 51,641 - 6,341 45,300 12.28% Transfers 1,590,765 1,510,635 - 1,590,765 0.00% Administrative Services Total Expense 17,582,210 4,428,187 4,011,994 13,570,216 22.82%
Library Personnel 2,275,834 414,071 465,042 1,810,792 20.43% Operations 1,449,962 418,700 418,302 1,031,660 28.85%
Operating Capital 41,000 2,768 10,304 30,696 25.13%
Library Total Expense 3,766,796 835,539 893,648 2,873,148 23.72%
Parks and Recreation
Personnel 5,990,831 1,026,817 1,154,962 4,835,869 19.28%
Operations 5,389,284 1,212,865 1,606,155 3,783,129 29.80%
Operating Capital 5,000 3,003 - 5,000 0.00%
Parks and Recreation Total Expense 11,385,115 2,242,685 2,761,117 8,623,998 24.25% Community Services Division
Personnel 1,626,620 316,684 262,050 1,364,570 16.11%
Operations 629,130 170,149 168,945 460,185 26.85% Operating Capital 128,500 2,902 - 128,500 0.00% Community Services Total Expense 2,384,250 489,735 430,995 1,953,255 18.08%
General Fund Total 113,937,754 23,797,443 28,249,711 85,688,042 24.79%
6
Quarterly Financial Report
F FY2021 Quarterly Report
Overall, General Fund expenditures are within budget and the fund can cover the 90-day
Contingency Reserve, Economic Stability Reserve, Master Development Fee Reserve (MDF) and the
Benefit Payout Reserve.
7
Quarterly Financial Report
F FY2021 Quarterly Report
Fund Schedule:
General Fund
Period: Dec-22 Budget Current Period FY2023 FY2023 Year-to-date: Budget Vs. Actuals FY2023 Dec-22 YTD Actuals: Q1 FY23 Variance % of Budget
Beginning Fund Balance 37,517,635 37,517,635 - 100.00%
Revenue 40001:Property Taxes 18,700,000 8,306,278 9,600,081 (9,099,919) 51.34% 40002:Sales Taxes 30,749,397 2,291,830 2,367,808 (28,381,589) 7.70% 40005:Franchise Taxes 6,820,940 312,726 1,066,666 (5,754,274) 15.64% 40008:Other Taxes 576,473 29,218 55,569 (520,904) 9.64%
41001:Fines 270,800 26,742 80,812 (189,988) 29.84% 41002:Penalties 111,348 10,875 33,406 (77,942) 30.00% 42001:Interest Income 100,000 106,620 222,903 122,903 222.90%
43001:Fees 9,927,405 876,717 2,251,497 (7,675,908) 22.68% 43002:Garbage Charges 12,095,135 1,104,708 3,252,628 (8,842,507) 26.89% 43003:Permits 6,548,500 406,138 1,189,272 (5,359,228) 18.16% 43004:Administrative Charges 2,000,000 166,667 500,002 (1,499,998) 25.00% 43005:Rental Revenue 127,692 2,079 10,163 (117,529) 7.96% 45001:Misc Revenue 883,850 16,719 113,465 (770,385) 12.84% 45003:Misc Reimbursements - - 609 609 0.00% 45004:Sale of Property - 150,416 150,416 150,416 0.00% 44001:Grant Revenue 40,000 - 101,531 61,531 253.83% 44501:Contribution Revenue 145 - - (145) 0.00% 44502:Developer Contributions - - 239,753 239,753 0.00% 44503:Interlocal Agreement Revenue 5,991,960 1,392,500 1,392,500 (4,599,460) 23.24% 44504:Donations - 130 789 789 0.00%
70001:Transfers In 1,765,500 - - (1,765,500) 0.00% 70002:Transfers In - Payment in Lieu of Taxes (PILOT) 10,615,004 795,574 2,681,263 (7,933,741) 25.26%
Revenue Total 107,324,149 15,995,938 25,311,132 (82,013,017) 23.58% Expense CC0001 Non-Departmental 1,591,765 - - 1,591,765 0.00% CC0107 Planning 3,669,109 172,122 1,080,006 2,589,103 29.44% CC0202 Parks Administration 757,322 64,977 178,477 578,845 23.57% CC0210 Library 3,766,796 285,600 893,648 2,873,148 23.72%
CC0211 Parks 3,545,136 293,432 980,315 2,564,821 27.65% CC0212 Recreation 5,293,737 391,239 1,156,759 4,136,978 21.85% CC0213 Tennis Center 577,279 48,129 127,756 449,523 22.13%
CC0214 Recreation Programs - - - - 0.00% CC0215 Garey Park 1,211,641 86,376 317,809 893,832 26.23% CC0218 Arts and Culture 450,446 24,262 70,098 380,348 15.56%
CC0316 Municipal Court 599,017 47,640 135,471 463,546 22.62% CC0402 Fire Support Services/Administration 4,892,473 433,179 1,361,964 3,530,509 27.84% CC0422 Fire Emergency Services 20,003,521 1,603,538 4,985,010 15,018,511 24.92%
CC0448 EMS 3,714,137 292,943 1,112,342 2,601,795 29.95% CC0533 Environmental Services 11,044,363 925,893 2,383,665 8,660,698 21.58% CC0536 Inspection Services 2,653,223 171,556 496,460 2,156,763 18.71%
CC0602 Administrative Services 2,918,239 190,706 712,693 2,205,546 24.42% CC0605 Emergency Management 404,656 13,538 47,487 357,169 11.74% CC0634 City Council Services 254,313 15,635 56,965 197,348 22.40% CC0635 City Secretary Services 1,541,421 107,888 316,602 1,224,819 20.54%
CC0638 General Government Contracts 11,276,472 674,244 2,925,733 8,350,739 25.95% CC0639 Human Resources - 15 15 (15) 0.00% CC0655 Communications/Public Engagement 1,495,101 76,444 404,718 1,090,383 27.07%
CC0702 Police Administration 3,004,869 239,013 758,924 2,245,945 25.26% CC0742 Police Operations 19,384,389 1,536,546 4,542,420 14,841,969 23.43% CC0744 Animal Services 1,285,939 79,948 241,428 1,044,511 18.77%
CC0745 Code Compliance 693,655 45,603 142,080 551,575 20.48% CC0802 Public Works 1,668,120 154,986 958,737 709,383 57.47% CC0846 Streets 5,382,828 359,722 1,432,295 3,950,533 26.61%
Expense Total 113,937,754 8,458,985 28,249,711 85,688,042 24.79%
Excess (Deficiency) of Total Revenue over Total Requirements (6,613,605) 7,536,954 (2,938,580) 3,675,025 44.43%
Ending Fund Balance 30,904,030 34,579,055 3,675,025 111.89%
Reserves
MDF Reserve 1,700,000 - 1,700,000 - 100.00% Benefit Payout Reserve 340,000 - 340,000 - 100.00% Contingency Reserve 18,166,659 - 18,166,659 - 100.00% Economic Stability Reserve 5,881,366 - 5,881,366 - 100.00% Reserves Total 26,088,025 - 26,088,025 - 100.00%
Available Fund Balance 4,816,005 - 8,491,030 3,675,025 176.31%
8
Quarterly Financial Report
F FY2021 Quarterly Report
Expense by Cost Center:
General Fund
Quarterly Comparison: Q1 FY23 Budget FY2022 FY2023
FY2023 Year-to-date: Budget Vs.
Actuals
FY2023 YTD Actuals: Q1
FY22
YTD Actuals: Q1
FY23 Variance % of Budget
Planning
Personnel 2,056,100 309,896 359,728 1,696,372 17.50% Operations 1,613,009 267,588 720,277 892,732 44.65%
Transfers - - - - 0.00%
Planning Total Expense 3,669,109 577,485 1,080,006 2,589,103 29.44%
Library
Personnel 2,275,834 414,071 465,042 (50,972) 20.43% Operations 1,449,962 418,700 418,302 398 28.85%
Operating Capital 41,000 2,768 10,304 (7,536) 25.13%
Library Total Expense 3,766,796 835,539 893,648 (58,109) 23.72%
Parks Administration Personnel 344,404 72,482 77,734 266,670 22.57% Operations 412,918 105,556 412,918 0.00% Parks Administration Total Expense 757,322 178,038 178,477 578,845 23.57%
Parks
Personnel 1,969,526 355,363 367,769 1,601,757 18.67%
Operations 1,570,610 379,117 612,546 958,064 39.00% Operating Capital 5,000 3,003 - 5,000 0.00%
Parks Total Expense 3,545,136 737,483 980,315 2,564,821 27.65%
Recreation
Personnel 2,785,216 434,731 523,666 2,261,550 18.80%
Operations 2,508,521 514,830 633,093 1,875,428 25.24%
Recreation Total Expense 5,293,737 949,561 1,156,759 4,136,978 21.85% Tennis Center
Personnel 287,685 53,605 55,330 232,355 19.23%
Operations 289,594 50,766 72,426 217,168 25.01%
Tennis Center Total Expense 577,279 104,371 127,756 449,523 22.13%
Recreation Programs
Operations - 1,582 - - 0.00%
Recreation Programs Total Expense - 1,582 - - 0.00%
Garey Park
Personnel 604,000 110,635 130,463 473,537 21.60% Operations 607,641 161,014 187,346 420,295 30.83% Garey Park Total Expense 1,211,641 271,649 317,809 893,832 26.23%
Arts and Culture
Personnel 322,766 17,449 34,256 288,510 10.61%
Operations 127,680 37,920 35,842 91,838 28.07%
Arts and Culture Total Expense 450,446 55,369 70,098 380,348 15.56% Municipal Court
Personnel 489,044 106,865 108,069 380,975 22.10%
Operations 109,973 24,937 27,402 82,571 24.92%
Municipal Court Total Expense 599,017 131,802 135,471 463,546 22.62%
Fire Support Services/Administration Personnel 2,811,182 591,879 730,568 2,080,614 25.99% Operations 2,081,291 497,061 631,395 1,449,896 30.34%
Operating Capital - 16,486 - - 0.00%
Fire Administration Total Expense 4,892,473 1,105,426 1,361,964 3,530,509 27.84%
9
Quarterly Financial Report
F FY2021 Quarterly Report
Fire Emergency Services
Personnel 16,613,379 3,380,375 3,669,402 12,943,977 22.09%
Operations 3,195,542 591,647 1,273,587 1,921,955 39.86% Operating Capital 194,600 13,644 42,021 152,579 21.59% Fire Emergency Services Total Expense 20,003,521 3,985,665 4,985,010 15,018,511 24.92%
EMS
Personnel 2,776,890 552,671 724,763 2,052,127 26.10%
Operations 889,662 351,236 387,579 502,083 43.56% Operating Capital 47,585 - - 47,585 0.00% EMS Total Expense 3,714,137 903,907 1,112,342 2,601,795 29.95%
Inspection Services
Personnel 2,031,074 343,331 418,079 1,612,995 20.58%
Operations 622,149 39,507 78,381 543,768 12.60%
Inspection Services Total Expense 2,653,223 382,838 496,460 2,156,763 18.71% Administrative Services
Personnel 2,171,693 287,442 484,443 1,687,250 22.31%
Operations 739,905 338,400 221,909 517,996 29.99%
Operating Capital 6,641 - 6,341 300 95.48%
Administrative Services Total Expense 2,918,239 625,842 712,693 2,205,546 24.42% Emergency Management
Personnel 159,329 54,529 29,451 129,878 18.48%
Operations 116,827 20,969 18,036 98,791 15.44%
Operating Capital 128,500 - - 128,500 0.00%
Community Services Total Expense 404,656 75,498 47,487 357,169 11.74% City Secretary
Personnel 800,688 129,969 176,269 624,419 22.01%
Operations 740,733 109,291 140,333 600,400 18.95%
City Secretary Total Expense 1,541,421 239,260 316,602 1,224,819 20.54%
Communications/ Public Engagement Personnel 795,902 133,435 159,585 636,317 20.05% Operations 699,199 111,018 245,133 454,066 35.06%
Communications Total Expense 1,495,101 244,453 404,718 1,090,383 27.07%
Police Administration
Personnel 674,234 147,469 153,368 520,866 22.75% Operations 2,330,635 554,939 605,556 1,725,079 25.98% Police Administration Total Expense 3,004,869 702,408 758,924 2,245,945 25.26%
Police Operations
Personnel 15,590,363 3,164,609 3,421,296 12,169,067 21.94%
Operations 3,482,043 874,300 1,007,558 2,474,485 28.94% Operating Capital 311,983 427,487 113,566 198,417 36.40% Police Operations Total Expense 19,384,389 4,466,396 4,542,420 14,841,969 23.43%
Animal Services
Personnel 899,814 156,474 133,905 765,909 14.88%
Operations 386,125 114,585 107,522 278,603 27.85%
Animal Services Total Expense 1,285,939 271,060 241,428 1,044,511 18.77% Code Compliance
Personnel 567,477 105,681 98,693 468,784 17.39%
Operations 126,178 34,595 43,387 82,791 34.39%
Operating Capital - 2,902 - - 0.00%
Code Compliance Total Expense 693,655 143,177 142,080 551,575 20.48%
Public Works
Personnel 593,168 147,438 129,762 463,406 21.88%
Operations 1,074,952 484,225 828,975 245,977 77.12%
10
Quarterly Financial Report
F FY2021 Quarterly Report
Public Works Total Expense 1,668,120 631,663 958,737 709,383 57.47%
Streets
Personnel 2,115,641 364,837 373,567 1,742,074 17.66%
Operations 3,263,687 564,724 1,056,789 2,206,898 32.38% Operating Capital 3,500 - 1,939 1,561 55.40% Streets Total Expense 5,382,828 929,561 1,432,295 3,950,533 26.61%
Environmental Services
Personnel 188,660 - 26,710 161,951 14.16%
Operations 10,852,203 1,684,325 2,356,955 8,495,248 21.72% Operating Capital 3,500 - - 3,500 0.00% Environmental Services Total Expense 11,044,363 1,684,325 2,383,665 8,660,698 21.58%
Non-Departmental
Operations 1,000 - - 1,000 0.00% Transfers 1,590,765 1,510,635 - 1,590,765 0.00% Non-Departmental Total Expense 1,591,765 1,510,635 - 1,591,765 0.00%
General Government Contracts
Personnel (700,000) - 16,635 (716,635) -2.38%
Operations 11,931,472 1,997,680 2,909,098 9,022,374 24.38% Operating Capital 45,000 - - 45,000 0.00% General Government Contracts Total Expense 11,276,472 1,997,680 2,925,733 8,350,739 25.95%
Human Resources Operations - 15 (15) 0.00% Human Resources Total Expense - 15 (15) 0.00%
City Council Services
Personnel 173,696 35,421 37,480 136,216 21.58%
Operations 80,617 19,348 19,485 61,132 24.17%
City Council Services Total Expense 254,313 54,769 56,965 197,348 22.40% Transportation Planning
Personnel 326,262 - 81,690 244,572 25.04%
Operations 531,525 348,144 183,381 65.50%
Transportation Planning Total Expense 857,787 - 429,834 427,953 50.11% General Fund Total Expense 113,937,754 23,797,443 28,249,711 85,688,042 24.79%
11
Quarterly Financial Report
UTILITY FUNDS:
As part of the FY2022 budget development process, the utilities reviewed various initiatives to
improve resiliency to extreme weather, including those required by legislation. Both utilities
continue to refine cost of service studies to ensure that rates cover these resiliency efforts, the
growth pressure and infrastructure demand on the system, and financial targets for liquidity and
debt coverage. Based on the updated water master plan and water cost of service study, Council
adopted the FY2023 budget, which includes water and wastewater rate increases. Miscellaneous
utility fees were also increased in the adopted budget to recover current costs of service for tasks
like a trip charge. The Electric cost of service study is ongoing.
Electric Fund:
The City continues to employ several strategies to maintain the improved performance of the
Electric Fund in relation to past and current expenditures for purchased power contracts. These
strategies include reviewing rates, recovering the costs of new development, selling Renewable
Energy Credits (RECs), and contracting professional services for energy portfolio management and
risk oversight.
ELECTRIC REVENUE:
Operating revenue in the Electric Fund totals
$23,674,618 through the quarter, or 21.38% of
budget. Electric sales revenue, the largest
component of operating revenue, has brought in
$19,274,298 through the quarter, totaling 21.29% of
Electric charges budget. Adjusted meter load
(AML) is up approximately 10% compared to Q1 of
last fiscal year. Several days in late December were
very cold.
Developer contributions were budgeted at
$11,600,000. Year-to-date collection totals
$2,784,894, or 24.01% of budget. Developer
contributions drive the need for utility
infrastructure. While there is an increase in
revenue compared to prior years, there are more new development project expenses than
anticipated. Due to global supply chain issues, the cost of material for electric infrastructure
projects increased significantly. These cost increases also resulted in increased capital expenses.
Developer Contributions and capital expenses amendments were brought to Council in January as
part of the CIP-Roll Forward budget amendment. As noted at the beginning of the report, the
budget amendment is reflected in this report as of December so that the budget and actuals align.
Within the Fee category, the Renewable Energy Credit (REC) revenue budget is $3,082,821. REC
sales total $238,250, or 7.73% of budget through the quarter. Pricing of RECs continued to be
favorable for the City, and a conservative amount of RECs are sold in the forward market, benefiting
the City in later months or in FY2024.
K
5.0M
10.0M
15.0M
20.0M
25.0M
30.0M
Q1
Electric Fund: Electric
Sales Charges
FY2021 FY2022 FY2023
12
Quarterly Financial Report
Electric Services
Quarterly Comparison: Q1
FY23 Budget FY2022 FY2023
FY2022 Year-to-date:
Budget Vs. Actuals Quarterly Comparison
FY2022
YTD
Actuals: Q1
FY22
YTD
Actuals: Q1
FY23
Variance % of Budget Variance % Variance
Operating Revenue
40002:Sales Taxes 5,500 1,723 1,789 (3,711) 32.53% 66 3.82% 41002:Penalties 630,000 203,165 206,441 (423,559) 32.77% 3,275 1.61%
42001:Interest Income 45,000 8,753 290,272 245,272 645.05% 281,520 3216.36%
43001:Fees 4,878,866 1,241,634 346,960 (4,531,906) 7.11% (894,674) -72.06%
43004:Administrative
Charges 3,079,852 884,928 769,963 (2,309,889) 25.00% (114,965) -12.99%
43601:Electric Sales
Charges 90,511,753 18,067,440 19,274,298 (71,237,455) 21.29% 1,206,858 6.68%
44502:Developer
Contributions 11,600,000 2,466,728 2,784,894 (8,815,106) 24.01% 318,167 12.90%
Operating Revenue Total 110,750,971 22,874,371 23,674,618 (87,076,353) 21.38% 800,247 3.50%
Non-Operating Revenue
45001:Misc Revenue 37,748 57,119 52,266 14,518 138.46% (4,853) -8.50% 45004:Sale of Property - 3,562 2,774 2,774 0.00% (787) -22.11% 44001:Grant Revenue - - 255,775 255,775 0.00% 255,775 0.00% 46001:Bond Proceeds 16,231,455 - - (16,231,455) 0.00% - 0.00%
Non-Operating Revenue
Total 16,269,203 60,681 310,815 (15,958,388) 1.91% 250,134 412.21%
Revenue Total 127,020,174
22,935,052
23,985,433 (103,034,741) 18.88% 1,050,381 4.58%
The budget for non-operating revenue totals $16,269,203 in FY2023. The City intends to recognized
bond proceeds as part of the annual debt sale in the spring to cover the costs of capital
infrastructure and equipment.
ELECTRIC EXPENSES:
Operating expenses in the Electric Fund total $26,093,218 through the quarter. Year-to-date
purchase power expenses total $19,309,618, while Net congestion revenue rights (CRRs) credits total
$37,084. The City continues to use a hedging strategy for the winter and summer months to avoid
price spikes in the market. The City was adequately hedged (compliant with the hedging policy)
for the extreme cold temperatures for December 22 – 24, 2022. Actual peak demand exceeded
forecast which required additional purchases. The total power costs for this event was $1M over
budget. For the quarter, purchased power expense net of REC revenue was $1.6M over budget.
Electric Engineering and Transmission and Distribution (T&D) cost centers look inflated due to the
capitalization of labor being budgeted in capital expense while the actuals are booked to the
operating budget. The labor will be capitalized to the appropriate capital improvement project on
the final year-end financial statements.
13
Quarterly Financial Report
Electric Services
Quarterly Comparison: Q1 FY23 Budget FY2022 FY2023 FY2022 Year-to-date: Budget Vs. Actuals Quarterly Comparison
FY2023 YTD Actuals:
Q1 FY22
YTD Actuals:
Q1 FY23 Variance % of Budget Variance % Variance
Operating Expense
CC0001 Non-Departmental 8,125,440 2,385,532 1,357,199 6,768,241 16.70% 1,028,333 -43.11% CC0521 Operational Technology 2,298,845 148,999 490,316 1,808,529 21.33% (341,317) 229.07%
CC0522 Electric Administration 10,750,088 2,473,716 2,499,712 8,250,376 23.25% (25,996) 1.05% CC0523 Electric Safety and Employee Development 550,038 26,510 81,369 468,669 14.79% (54,860) 206.94% CC0524 Metering Services - 450,307 30,563 (30,563) 0.00% 419,744 -93.21% CC0525 T&D Services 2,204,460 1,296,750 1,271,066 933,394 57.66% 25,684 -1.98%
CC0526 Systems Engineering - 15,698 - - 0.00% 15,698 -100.00% CC0537 Electric Resource
Management 62,645,000 14,270,084 19,309,618 43,335,382 30.82% (5,039,534) 35.32% CC0555 Electric Systems
Operations 2,201,573 388,942 509,193 1,692,380 23.13% (120,251) 30.92% CC0557 Electrical Engineering 1,385,003 325,731 544,183 840,820 39.29% (218,452) 67.07%
Operating Expense Total 90,160,447 21,782,266 26,093,218 64,067,229 28.94% (4,310,952) 19.79%
Non-Operating Expense
CC0001 Non-Departmental 11,327,692 - - 11,327,692 0.00% - 0.00% CC0557 Electrical Engineering 33,005,573 5,833,128 9,427,444 23,578,129 28.56% (3,594,316) 61.62%
Non-Operating Expense Total 44,333,265 5,833,128 9,427,444 34,905,821 21.26% (3,594,316) 61.62% Expense Total 134,493,712 27,615,394 35,520,662 98,973,049 26.41% (7,905,269) 28.63%
The Electric department reorganized several personnel and operating expenses between cost
centers and created new cost centers as part of the development of the FY2023 budget. These
changes result in some variances compared to the same quarter the prior year.
Non-operating expenditures are budgeted at $44,333,265 in FY2023. Budgeted non-operating
expenditures include $33,005,573 for capital projects and $11,327,692 for debt service payments,
both of which typically trend towards later quarters. The FY2023 Capital Project Roll Forward
amendment included $13,643,888 million of active projects. These encumbrances combined with
increased New Development, shows an accelerated CIP spending in Electric Engineering
compared to the previous year. In order to keep up with new development CIP related projects,
staff proposed to amend the Electric CIP budget as part of the roll forward budget amendment.
This amendment includes an 80% offset in developer contribution revenue as well as bond
proceeds to fund the new development projects. As previously mentioned, a significant portion of
labor expenses for capital projects will be journaled at the end of the fiscal year, bringing operations
and capital expense in balance with their budgets.
The Electric Fund anticipates meeting all the fund’s below line reserve requirements in FY2023.
Contingency requirements include a 90-day operating contingency of $7,444,704, a non-
operating reserve totaling $9,997,741, reserve for transformer of $4,069,154, as well as a rate
stabilization reserve in the amount of $25,600,000. In FY2023, the City will continue to review
Electric cost of service in light of increased capital costs, potential changes in net metering,
potential changes in the ERCOT market design, and updated timelines to new industrial loads.
14
Quarterly Financial Report
Fund Schedule:
Electric Services
Period: Dec-22 Budget Current Period FY2023 Year-to-date: Budget Vs. Actuals
FY2023 Dec-22 YTD Actuals Variance % of Budget
Beginning Fund Balance 56,529,870 56,529,870 - 100.00%
Operating Revenue
40002:Sales Taxes 5,500 545 1,789 (3,711) 32.53%
41002:Penalties 630,000 55,980 206,441 (423,559) 32.77% 42001:Interest Income 45,000 110,925 290,272 245,272 645.05% 43001:Fees 4,878,866 273,135 346,960 (4,531,906) 7.11%
43004:Administrative Charges 3,079,852 769,963 769,963 (2,309,889) 25.00%
43601:Electric Sales Charges 90,511,753 6,258,447 19,274,298 (71,237,455) 21.29% 44502:Developer Contributions 11,600,000 891,761 2,784,894 (8,815,106) 24.01% Total Operating Revenue 110,750,971 8,360,755 23,674,618 (87,076,353) 21.38%
Operating Expense
CC0001 Non-Departmental 8,125,440 415,389 1,357,199 6,768,241 16.70%
CC0521 Operational Technology 2,298,845 144,635 490,316 1,808,529 21.33% CC0522 Electric Administration 10,750,088 784,597 2,499,712 8,250,376 23.25% CC0523 Electric Safety and Employee
Development 550,038 18,456 81,369 468,669 14.79%
CC0524 Metering Services - (12,407) 30,563 (30,563) 0.00% CC0525 T&D Services 2,204,460 300,705 1,271,066 933,394 57.66% CC0526 Systems Engineering - - - - 0.00%
CC0537 Electric Resource Management 62,645,000 9,690,017 19,309,618 43,335,382 30.82%
CC0555 Electric Systems Operations 2,201,573 167,405 509,193 1,692,380 23.13% CC0557 Electrical Engineering 1,385,003 188,077 544,183 840,820 39.29% Total Operating Expense 90,160,447 11,696,875 26,093,218 64,067,229 28.94%
Net Operations Total 20,590,524 (2,418,601) (151,143,582) -11.75%
Non-Operating Revenue
45001:Misc Revenue 37,748 879 52,266 14,518 138.46%
45004:Sale of Property - - 2,774 2,774 0.00% 44001:Grant Revenue - 255,775 255,775 255,775 0.00% 46001:Bond Proceeds 16,231,455 - - (16,231,455) 0.00%
Total Non-Operating Revenue 16,269,203 256,653 310,815 (15,958,388) 1.91%
Non-Operating Expense
CC0001 Non-Departmental 11,327,692 - - 11,327,692 0.00% CC0557 Electrical Engineering 33,005,573 514,232 9,427,444 23,578,129 28.56% Total Non-Operating Expense 44,333,265 514,232 9,427,444 34,905,821 21.26%
Excess (Deficiency) of Total Revenue over
Total Requirements (7,473,538) (3,593,699) (11,535,229) (4,061,692) 154.35%
Ending Fund Balance 49,056,332 44,994,641 (4,061,692) 91.72%
Reserves
Rate Stabilization 25,600,000 25,600,000 - 100.00% Non-Operating Reserve 9,997,741 9,997,741 - 100.00% Operating Contingency Reserve 7,444,704 7,444,704 - 100.00%
Transformer Reserve 4,069,154 4,069,154 - 100.00%
Reserves Total 47,111,599 47,111,599 - 100.00%
Available Fund Balance 1,944,733 (2,116,958) (4,061,692) -108.86%
15
Quarterly Financial Report
F
FY2021 Quarterly Report
FY2021 Quarterly Report
Water Fund:
WATER REVENUE:
Year-to-date Operating revenue totals $33,452,762, or 26.21% of budget. The largest revenue
streams in the Water Fund are charges for services for water, wastewater, and irrigation use and
impact fees. Through the quarter, Water Charges total $11,977,614, which is 23.70% of budget.
Year-to-date, Wastewater Charges are $4,967,273, or 23.90% of budget. Irrigation Charges total
$109,844 for the quarter, or 23.76% of budget. Increases in number of meters and customers as
well as rate increase effective October 1, 2022, have proven to significantly increase year-to-date
revenues for the Water Fund to support operation and future infrastructure needs.
The budget for Impact Fees for the fiscal year is $44,800,000. Through the quarter, impact fee
revenues total $11,574,855, or 25.84% of budget. The increase in impact fees is attributed to growth
as well as an increase in the installation of meters that are larger in diameter such as meters used
for multi-family housing. Impact fees are also going to show cyclical increases. The City has
approved many out of City MUDS. These MUDS are required to pay impact fees at plat
recordation in lieu of building permit. This means that when a MUD records a plat, we will see an
instantaneous increase in impact fees, however it will take time for the builders to begin
consuming the meters associated with those prepaid fees. Impact fees are used for funding
capital infrastructure approved in the impact fee plan. They may be used as a cash equivalent, or
to repay debt service for impact fee eligible projects. Staff continues to monitor impact fee
revenue as it is heavily driven by development.
Water
Quarterly Comparison: Q1 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals Quarterly Comparison
FY2023 YTD Actuals: Q1
FY22
YTD Actuals: Q1
FY23 Variance % of Budget Variance % Variance
Operating Revenue 41002:Penalties 440,000 163,851 217,809 (222,191) 49.50% 53,958 32.93% 42001:Interest Income 470,519 64,400 3,199,231 2,728,712 679.94% 3,134,830 4867.72% 43001:Fees 9,625,640 5,704,218 1,338,419 (8,287,221) 13.90% (4,365,799) -76.54%
43003:Permits - - (1,000) (1,000) 0.00% (1,000) 0.00% 43005:Rental Revenue 60,000 51,905 7,300 (52,700) 12.17% (44,605) -85.94%
43602:Water Charges 50,530,586 8,732,868 11,977,614 (38,552,972) 23.70% 3,244,746 37.16% 43603:Wastewater Charges 20,784,153 4,120,227 4,967,273 (15,816,880) 23.90% 847,046 20.56%
43604:Irrigation Charges 462,329 109,863 109,844 (352,485) 23.76% (19) -0.02% 41602:Impact Fees 44,800,000 10,600,055 11,574,855 (33,225,145) 25.84% 974,800 9.20%
44502:Developer Contributions 450,000 27,677 61,417 (388,583) 13.65% 33,740 121.91% 70001:Transfers In - 115,000 - - 0.00% (115,000) 0.00%
Operating Revenue Total 127,623,227 29,690,064 33,452,762 (94,170,465) 26.21% 3,762,698 12.67%
K
5.0M
10.0M
15.0M
20.0M
FY2021 FY2022 FY2023
Q1
Water Charges
Water Wastewater Irrigation
16
Quarterly Financial Report
F
FY2021 Quarterly Report
FY2021 Quarterly Report
Non-Operating Revenue 45001:Misc Revenue 1,380,998 117,776 100,459 (1,280,539) 7.27% (17,317) -14.70%
44001:Grant Revenue 7,000,000 - - (7,000,000) 0.00% - 0.00% 44504:Donations - - 1,740 1,740 0.00% 1,740 0.00%
46001:Bond Proceeds 120,035,000 - - (120,035,000) 0.00% - 0.00%
Non-Operating Revenue Total 128,415,998 117,776 102,199 (128,313,799) 0.08% (15,577) -13.23%
Revenue Total 256,039,225 29,807,840 33,554,962 (222,484,263) 13.11% 3,747,121 12.57%
Total Water Fund operating revenue is up
12.67% compared to the same period last fiscal
year due to growth in sales and collections in
impact fees. Through the quarter water
consumption is up 39% compared to the same
period of FY2022.
The budget for non-operating revenue totals
$128,415,998 in FY2023. This total includes bond
proceeds for capital projects in the amount of
$120,035,000 The majority of this is for the
Southlake Treatment Plant, System Resiliency,
Pecan Branch Wastewater Treatment Plant,
and the San Gabriel Wastewater Treatment
Plant. In addition to bond proceeds,
$48,740,000 of impact fees will be used on
eligible projects in FY2023.
The cost-of-service study continues to be evaluated for current and future needs of the water
fund. The FY2023 budget includes an 11.5% increase in rates across all customer classes. The
increase was necessary to increase equity between consumer classes and to pay for the debt
service and operating costs of new infrastructure. Additional rate increases are expected over the
next 3 – 5 years to meet demand for capital infrastructure. The Council recently adopted increases
to water and wastewater impact fees to offset capital costs.
WATER EXPENSES:
Operating expenditures in the Water Fund total $27,162,360 through the quarter, or 32.95% of
budget. Operating expenditures in FY2023 are 43.61% greater than the same period in FY2022.
This is primarily due to the rising costs of raw water and chemicals.
K
200K
400K
600K
800K
1.0M
1.2M
WATER FUND:
CONSUMPTION (KGALS)
FY2020 FY2021 FY2022 FY2023
17
Quarterly Financial Report
F
FY2021 Quarterly Report
FY2021 Quarterly Report
Water Services Financial Report
Quarterly Comparison: Q1 FY23 Budget FY2022 FY2023
FY2023 Year-to-date:
Budget Vs. Actuals Quarterly Comparison
FY2023 YTD Actuals:
Q1 FY22
YTD Actuals:
Q1 FY23 Variance % of
Budget Variance % Variance
Operating Expense CC0001 Non-Departmental 6,981,573 2,132,692 1,243,037 5,738,536 17.80% 889,655 -41.72% CC0524 Metering Services 867,917 - 337,426 530,491 38.88% (337,426) 0.00%
CC0527 Water Services
Administration 39,417,124 11,505,610 18,133,383 21,283,741 46.00% (6,627,773) 57.60% CC0528 Water Distribution 11,900,920 825,898 1,030,383 10,870,537 8.66% (204,485) 24.76% CC0529 Water Plant
Management 6,458,237 1,370,939 2,549,006 3,909,231 39.47% (1,178,067) 85.93%
CC0530 Wastewater Operations 2,628,848 407,881 305,107 2,323,741 11.61% 102,774 -25.20% CC0531 Wastewater Plant
Management 6,704,400 1,526,759 1,791,200 4,913,200 26.72% (264,442) 17.32%
CC0532 Irrigation Operations 478,150 72,337 130,794 347,356 27.35% (58,457) 80.81% CC0535 Water Conservation 1,339,423 - 484,454 854,969 36.17% (484,454) 0.00% CC0553 Water Operations 5,662,306 1,071,427 1,157,569 4,504,737 20.44% (86,143) 8.04%
Operating Expense Total 82,438,898 18,913,542 27,162,360 55,276,538 32.95% (8,248,818) 43.61%
Non-Operating Expense CC0001 Non-Departmental 1,727,000 - - 1,727,000 0.00% - 0.00% CC0526 Systems Engineering 477,242,830 28,693,865 206,709,397 270,533,433 43.31% (178,015,532) 620.40%
CC0532 Irrigation Operations 79,743 - - 79,743 0.00% - 0.00%
CC0530 Wastewater Operations 3,353,674 - - 3,353,674 0.00% - 0.00% CC0527 Water Services
Administration 17,473,617 - - 17,473,617 0.00% - 0.00%
CC0553 Water Operations 7,796,061 1,145,453 439,692 7,356,369 5.64% 705,762 -61.61% CC0524 Metering Services 2,250,000 - - 2,250,000 0.00% - 0.00% Non-Operating Expense Total 509,922,925 29,839,319 207,149,089 302,773,836 40.62% (177,309,770) 594.22%
Expense 592,361,823 48,752,861 234,311,448 358,050,374 65.44% (185,558,588) 380.61%
Non-operating expense are budgeted at $509,922,925 in FY2023. Expenses total $207,149,089 or
40.62% of budget through the quarter. The majority of the non-operating expense funds were
dedicated to construction of capital improvement projects which were not completed in FY2022.
These funds were re-appropriated in FY2023 as the treatment plant, distribution, metering and
weather resiliency projects will take multiple years to complete.
The Water Fund anticipates meeting all the fund’s below line reserve requirements in FY2023.
Contingency requirements include a 90-day operating contingency of $15,143,941, a non-
operating reserve of $10,579,391, and an Impact Fee reserve of $33,518,865.
18
Quarterly Financial Report
F
FY2021 Quarterly Report
FY2021 Quarterly Report
Fund Schedule:
Water Services
Period: Dec-22 Budget Current Period Budget Vs. Actuals
FY2023 Dec-22 YTD Actuals: Q1 FY23 Variance % of Budget
Beginning Fund Balance 423,824,302 423,824,302 -100.00%
Operating Revenue
41002:Penalties 440,000 65,561 213,837 (226,163) 48.60%
42001:Interest Income 470,519 1,163,276 3,198,943 2,728,424 679.88% 43001:Fees 9,625,640 312,146 1,338,419 (8,287,221) 13.90%
43003:Permits - - (1,000) (1,000) 0.00% 43005:Rental Revenue 60,000 3,650 7,300 (52,700) 12.17%
43602:Water Charges 50,530,586 3,227,448 11,977,614 (38,552,972) 23.70% 43603:Wastewater Charges 20,784,153 1,637,507 4,967,273 (15,816,880) 23.90%
43604:Irrigation Charges 462,329 13,103 109,844 (352,485) 23.76% 41602:Impact Fees 44,800,000 4,908,890 11,574,855 (33,225,145) 25.84%
44502:Developer Contributions 450,000 13,733 61,417 (388,583) 13.65% 70001:Transfers In - - - - 0.00%
Total Operating Revenue 127,623,227 11,345,313 33,448,502 (94,174,725) 26.21%
Operating Expenses
CC0001 Non-Departmental 6,981,573 352,852 1,243,037 5,738,536 17.80% CC0524 Metering Services 867,917 134,358 337,426 530,491 38.88% CC0527 Water Services Administration 39,417,124 2,511,156 18,133,383 21,283,741 46.00% CC0528 Water Distribution 11,900,920 90,499 1,030,383 10,870,537 8.66% CC0529 Water Plant Management 6,458,237 442,815 2,550,266 3,907,971 39.49%
CC0530 Wastewater Operations 2,628,848 54,393 305,107 2,323,741 11.61% CC0531 Wastewater Plant Management 6,704,400 350,054 1,791,200 4,913,200 26.72%
CC0532 Irrigation Operations 478,150 18,632 130,794 347,356 27.35% CC0535 Water Conservation 1,339,423 60,497 484,454 854,969 36.17%
CC0553 Water Operations 5,662,306 407,685 1,157,569 4,504,737 20.44% Operating Expense Total 82,438,898 4,422,940 27,163,620 55,275,278 32.95%
Available Operating Fund Balance 45,184,329 - 6,284,882 (149,450,003) -
Non-Operating Revenue
45001:Misc Revenue 1,380,998 36,319 100,459 (1,280,539) 7.27% 44001:Grant Revenue 7,000,000 - - (7,000,000) 0.00% 44504:Donations - 150 1,740 1,740 0.00% 46001:Bond Proceeds 120,035,000 - - (120,035,000) 0.00% Non-Operating Revenue Total 128,415,998 36,469 102,199 (128,313,799) 0.08%
Non-Operating Expenses
CC0001 Non-Departmental 1,727,000 - - 1,727,000 0.00%
CC0524 Metering Services 2,250,000 - - 2,250,000 0.00% CC0526 Systems Engineering 477,242,830 5,685,476 206,709,397 270,533,433 43.31%
CC0527 Water Services Administration 17,473,617 - - 17,473,617 0.00% CC0530 Wastewater Operations 3,353,674 - - 3,353,674 0.00%
CC0532 Irrigation Operations 79,743 - - 79,743 0.00% CC0553 Water Operations 7,796,061 - 439,692 7,356,369 5.64%
Non-Operating Expense Total 509,922,925 5,685,476 207,149,089 302,773,836 40.62%
Excess (Deficiency) of Total Revenue over Total Requirements (336,322,598) (452,600,512) (200,762,007) 135,560,591 59.69%
Ending Fund Balance 87,501,704 - 223,062,295 135,560,591 254.92%
Reserves
Contingency Reserve 15,143,941 - 15,143,941 - 100.00%Non-Operating Reserve 10,579,391 - 10,579,391 - 100.00%
Impact Fee Reserve 33,518,865 - 33,518,865 - 100.00%
Reserves Total 59,242,197 59,242,197 -100.00%
Available Fund Balance 28,259,507 - 163,820,098 135,560,591 579.70%
19
Quarterly Financial Report
F FY2021 Quarterly Report
TOURISM FUND REVENUES:
The COVID-19 pandemic significantly impacted
the tourism sector, the City continues to see
improvement in revenues in the fund. Year-to-
date revenue in the fund totals $380,085, or
22.69% of budget. Hotel Occupancy Tax revenue in
this fund year-to-date totals $339,591 through the
quarter, or 22.64% of budget. Through this
quarter, Hotel Occupancy Tax revenue is $52,001
higher than, or, 118.08% of year-to-date actuals of
the previous fiscal year. Staff will continue to
market Georgetown and are pleased to see
occupancy rates recovering and exceeding pre-
pandemic levels.
Tourism Fund
Quarterly Comparison: Q1
FY23 Budget FY2022 FY2023
FY2022 Year-to-date:
Budget Vs. Actuals Quarterly Comparison
FY2023 YTD Actuals: Q1 FY22 YTD Actuals: Q1 FY23 Variance % of Budget Variance % Variance
Revenues
40008:Other Taxes 1,500,000 287,590 339,591 (1,160,409) 22.64% 52,001 118.08%
42001:Interest Income 5,000 665 11,548 6,548 230.97% 10,883 1736.06%
45001:Misc Revenue 120,000 27,627 9,446 (110,554) 7.87% (18,181) 34.19%
44505:Sponsorship 50,000 -19,500 (30,500) 39.00% 19,500 0.00%
Revenue Total 1,675,000 315,882 380,085 (1,294,915) 22.69% 64,203 120.32%
TOURISM FUND EXPENSES:
The Operating expense budget for the Tourism Fund totals $1,977,317, which includes a $60,500
transfer out to the General Fund to support Arts and Culture programming. Year-to-date operating
expenses total $544,057, or 27.51% of budget. The city has returned to the regular spring timing of
the annual Red Poppy Festival. This causes a variance from FY2022 when the one-time
Popptoberfest expenses were incurred. Expenses are increased over the prior year due to the new
allocation model requiring the Tourism fund to transfer funds to the General and Joint Services
Fund for support provided and increased spending in tv and radio advertising for a Hogaboom
Road Brand Ambassador Agreement.
Tourism Fund
Quarterly Comparison: Q1 FY23 Budget FY2022 FY2023 FY2022 Year-to-date: Budget Vs. Actuals Quarterly Comparison
FY2023 YTD Actuals: Q1 FY22 YTD Actuals: Q1 FY23 Variance % of Budget Variance % Variance
Expenses
CC0001 Non-Departmental 60,500 52,407 - 60,500 0.00% 52,407 0.00%
CC0208 CVB 1,665,865 389,402 544,057 1,121,808 32.66% (154,655) 139.72% CC0254 Poppy Festival 250,952 90,429 - 250,952 0.00% 90,429 0.00% Expense Total 1,977,317 532,239 544,057 1,433,260 27.51% (11,819) 102.22%
K
100K
200K
300K
400K
500K
600K
Q1
HOTEL OCCUPANCY TAX
FY2021 FY2022 FY2023
20
Quarterly Financial Report
F FY2021 Quarterly Report
Overall, Tourism Fund expenditures are within budget and the fund can cover the 90-day
Contingency Reserve. Ending fund balance is budgeted to be $2,023,130 in FY2022 with an
operating contingency reserve of $379,320, and a capital reserve of $1,643,810.
21
Quarterly Financial Report
F FY2021 Quarterly Report
Fund Schedule:
Tourism
Period: Dec-22 Budget
Current
Period FY2023
FY2022 Year-to-date:
Budget Vs. Actuals
FY2023 Dec-22 YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 2,325,447 2,325,447 - 100.00%
Revenue
40008:Other Taxes 1,500,000 160,791 339,591 (1,160,409) 22.64% 42001:Interest Income 5,000 5,111 11,548 6,548 230.97% 45001:Misc Revenue 120,000 4,293 9,446 (110,554) 7.87% 44505:Sponsorship 50,000 22,500 19,500 (30,500) 39.00%
Total Revenue 1,675,000 192,695 380,085 (1,294,915) 22.69%
Expense
Personnel 523,512 43,580 109,217 414,295 20.86%
Operations 1,393,305 45,181 434,840 958,465 31.21%
Transfers 60,500 - - 60,500 0.00%
Total Expense 1,977,317 88,761 544,057 1,433,260 27.51%
Excess (Deficiency) of Total Revenue
over Total Requirements (302,317) 103,934 (163,973) 138,344 54.24%
Ending Fund Balance 2,023,130 103,934 2,161,474 138,344 95.18%
Reserves
Capital Reserve 1,643,810 - 1,643,810 - 100.00%
Contingency Reserve 379,320 - 379,320 - 100.00%
Reserves Total 2,023,130 2,023,130 - 100.00%
Available Fund Balance - - 138,344 138,344 0.00%
22
Quarterly Financial Report
F
AIRPORT FUND REVENUES:
Airport operating revenue budget totals
$4,728,499. Airport Charges, the largest
segment of revenue totals $1,542,315 year-to-
date. This includes revenue for fuel sales,
facility lease, and hangar rentals. Total
operating revenues through the quarter are
$1,632,534, or 34.53% of budget. Revenues are
trending higher than anticipated due to
increases in the price fuel, which has a
related fuel expense, and increases to land
lease revenue.
Non-operating revenue consists of grant
revenue for capital projects and
miscellaneous revenue. The grant revenue
budget was rolled forward from FY2022 and is intended for the Taxiway Lightning Project.
Total non-operating revenue through the quarter is $300.
Airport Fund
Quarterly Comparison:
Q1 FY23 Budget FY2022 FY2023
FY2023 Year-to-date:
Budget Vs. Actuals Quarterly Comparison
FY2022
YTD
Actuals: Q1
FY22
YTD
Actuals: Q1
FY23
Variance % of
Budget Variance % Variance
Operating Revenue
40001:Property Taxes 61,800 - - (61,800) 0.00% -0.00%
42001:Interest Income 271,499 729 21,458 (250,041) 7.90% 20,729 2842.35%
43005:Rental Revenue - - 68,761 68,761 0.00% 68,761 0.00%
43606:Airport Charges 4,395,200 1,175,306 1,542,315 (2,852,885) 35.09% 367,009 31.23%
Operating Revenue
Total 4,728,499 1,176,035 1,632,534 (3,095,965) 34.53% 456,498 38.82%
Non-Operating Revenue
45001:Misc Revenue 2,340 3,000 300 (2,040) 12.82% (2,700) -90.00%
44001:Grant Revenue 22,654 36,731 - (22,654) 0.00% (36,731) -100.00%
Non-Operating Revenue Total 24,994 39,731 300 (24,694) 1.20% (39,431) -99.24%
Total Revenue 4,753,493 1,215,767 1,632,834 (3,120,659) 34.35% 417,067 34.30%
K
500K
1.0M
1.5M
Q1
AIRPORT FUND -FUEL
SALES
FY2021 FY2022 FY2023
23
Quarterly Financial Report
F
AIRPORT FUND EXPENSES:
Operating expenses in the Airport fund include a budget of $5,237,745. Year-to-date
operation expenses totals $3,733,399. Most of the operations budget is fuel for sales, which is
encumbered early in the fiscal year. Year-to-date operating capital is $45,500, or 76.27% of
budget. This total includes a one-time purchase for a 50 foot trailer mounted boom lift.
The budget for non-operating expenses total $1,645,023. This includes a CIP expense of
$1,424,000 for the construction of a maintenance facility at the airport. Staff included
additional funding as part of the rollforward budget amendment as the costs of the facility
increased after the design and bid. The remaining amount of non-operating expense is for the
airport’s debt service payment. The debt payment will be made in the summer to align with
the City’s annual debt schedule.
Airport Fund
Quarterly Comparison:
Q1 FY23 Budget FY2022 FY2023
FY2023 Year-to-date:
Budget Vs. Actuals Quarterly Comparison
FY2023
YTD
Actuals: Q1
FY22
YTD
Actuals: Q1
FY23
Variance % of
Budget Variance % Variance
Operating Expense
Personnel 578,699 96,542 129,397 449,302 22.36% (32,855) 34.03%
Operations 4,477,392 1,041,525 3,558,502 918,890 79.48% (2,516,977) 241.66%
Operating Capital 59,654 106,491 45,500 14,154 76.27% 60,991 -57.27%
Transfers 122,000 - - 122,000 0.00% - 0.00%
Total Operating
Expenses 5,237,745 1,244,558 3,733,399 1,504,346 71.28% (2,488,841) 199.98%
Non-Operating Expense
CIP Expense 1,424,000 - 115,900 1,308,100 8.14% (115,900) 0.00%
Debt Service 221,023 - - 221,023 0.00% - 0.00%
Non-Operating Expense Total 1,645,023 - 115,900 1,529,123 7.05% 115,900 0.00%
Expense Total 6,882,768 1,244,558 3,849,299 3,033,469 55.93% 2,604,741 209.29%
24
Quarterly Financial Report
F
Fund Schedule:
Airport Operations
Period: Dec-22 Budget
Current
Period FY2023
FY2023 Year-to-date:
Budget Vs. Actuals
FY2023 Dec-22 YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 3,274,625 3,274,625 - 100.00%
Operating Revenues 40001:Property Taxes 61,800 - - (61,800) 0.00%
42001:Interest Income 271,499 8,800 21,458 (250,041) 7.90%
43005:Rental Revenue - 22,772 68,761 68,761 0.00%
43606:Airport Charges 4,395,200 374,866 1,542,315 (2,852,885) 35.09%
Total Operating Revenues 4,728,499 406,437 1,632,534 (3,095,965) 34.53% Operating Expenses
Personnel 578,699 50,140 129,397 449,302 22.36%
Operations 4,477,392 327,936 3,558,502 918,890 79.48%
Operating Capital 59,654 6,000 45,500 14,154 76.27% Transfers 122,000 - - 122,000 0.00%
Total Operating Expenses 5,237,745 384,076 3,733,399 1,504,346 71.28%
Non-Operating Revenues
45001:Misc Revenue 2,340 300 300 (2,040) 12.82%
44001:Grant Revenue 22,654 - - (22,654) 0.00%
Total Non-Operating Revenues 24,994 300 300 (24,694) 1.20%
Non-Operating Expenses
CIP Expense 1,424,000 - 115,900 1,308,100 8.14%
Debt Service 221,023 - - 221,023 0.00%
Total Non-Operating Expenses 1,645,023 - 115,900 1,529,123 7.05%
Excess (Deficiency) of Total Revenue
over Total Requirements (2,129,275) 22,661 (2,216,465) (87,190) 104.09%
Ending Fund Balance 1,145,350 22,661 1,058,160 (87,190) 92.39%
Reserves
AFR Adjustment - - - - 0.00% Contingency Reserve 374,485 - 374,485 - 100.00% Reserves for Debt Service 211,959 - 211,959 - 100.00%
Reserves Total 586,444 - 586,444 - 100.00%
Available Fund Balance 558,906 - 471,716 (87,190) 84.40%
25
Quarterly Financial Report
STORMWATER REVENUE:
Stormwater operating revenue budget totals
$4,648,250. Stormwater charges, the largest section of
revenue, totals $1,143,012 year-to-date. This primarily
includes revenue for Non-Residential and Residential
Operations. Also included in Stormwater charges is
Pond Maintenance. Total operating revenues through
the quarter are $1,184,253, or 25.48% of budget.
Non-operating revenue are bond proceeds for capital
projects. The Stormwater Fund has $657,500
budgeted for funding to conduct curb and gutter
repair. Bond proceeds will be received as part of the
City’s annual debt sale in the spring.
Stormwater Services
Quarterly Comparison: Q1
FY23 Budget FY2022 FY2023
FY2023 Year-to-date:
Budget Vs. Actuals Quarterly Comparison
FY2023 YTD Actuals:
Q1 FY22
YTD Actuals:
Q1 FY23 Variance % of Budget Variance % Variance
Operating Revenue
41002:Penalties 57,500 11,449 14,503 (42,997) 25.22% 3,055 26.68%
42001:Interest Income 15,300 1,275 26,737 11,437 174.75% 25,462 1996.78%
43605:Stormwater Charges 4,575,450 1,088,624 1,143,012 (3,432,438) 24.98% 54,388 5.00%
Operating Revenue Total 4,648,250 1,101,348 1,184,253 (3,463,997) 25.48% 82,905 7.53%
Non-Operating Revenue
46001:Bond Proceeds 657,500 - - (657,500) 0.00% - 0.00%
Non-Operating Revenue
Total 657,500 - - (657,500) 0.00% - 0.00%
Total Revenue 5,305,750 1,101,348 1,184,253 (4,121,497) 22.32% 82,905 7.53%
STORMWATER EXPENSES:
Operating expenses in the Stormwater Fund include a budget of $6,080,969. Year-to-date
operating expenses total $1,823,223. Operating Capital has a budget of $500,000 for infrastructure
improvements, various drainage and flood mitigation maintenance, and equipment. Year-to-date
operating capital is $15,617, or 3.12% of budget. Year-to-date Operations expense is a 144.9% over the
prior year due to an increase in the allocation to the Joint Services fund for customer care and billing
services and an increase in the cost of mowing contracts due to inflation.
The budget for non-operating expenses total $1,931,435. This includes a CIP expense of $1,381,411
for the construction of curb and gutters as well as drainage improvements and Stormwater
Infrastructure. Debt Service has a budget of $550,024.
950K
1.0M
1.1M
1.1M
1.2M
1.2M
Q1
STORMWATER CHARGES
FY2021 FY2022 FY2023
26
Quarterly Financial Report
Stormwater Services
Quarterly Comparison: Q1
FY23 Budget FY2022 FY2023
FY2023 Year-to-date:
Budget Vs. Actuals Quarterly Comparison
FY2023 YTD Actuals:
Q1 FY22
YTD Actuals:
Q1 FY23 Variance % of Budget Variance % Variance
Operating Expense
Personnel 848,169 131,272 176,118 672,051 20.76% (44,846) 34.16%
Operations 4,054,118 628,307 1,550,461 2,503,657 38.24% (922,155) 146.77%
Operating Capital 500,000 25,260 15,617 484,383 3.12% 9,643 -38.17%
Transfers 678,682 114,930 81,026 597,656 11.94% 33,904 -29.50%
Total Operating Expenses 6,080,969 899,769 1,823,223 4,257,746 29.98% (923,454) 102.63%
Non-Operating Expense
CIP Expense 1,381,411 297,061 123,125 1,258,286 8.91% 173,936 -58.55%
Debt Service 550,024 - 30 549,994 0.01% (30) 0.00%
Non-Operating Expense Total 1,931,435 297,061 123,155 1,808,280 6.38% 173,906 -58.54%
Expense Total 8,012,404 1,196,830 1,946,378 6,066,026 24.29% (749,547) 62.63%
Ending fund balance is budgeted to be $1,768,620 in FY2023 with an operating contingency
reserve of $354,160 and a debt service reserve of $505,926.
27
Quarterly Financial Report
Fund Schedule:
Stormwater Services
Period: Dec-22 Budget Current Period FY2023
FY2023 Year-to-date:
Budget Vs. Actuals
FY2023 Dec-22 YTD Actuals:
Q1 FY23 Variance % of Budget
Beginning Fund Balance 4,475,274 4,475,274 -100.00%
Operating Revenues
41002:Penalties 57,500 5,184 14,503 (42,997) 25.22%
42001:Interest Income 15,300 10,265 26,737 11,437 174.75%
43605:Stormwater Charges 4,575,450 385,286 1,143,012 (3,432,438) 24.98%
Total Operating Revenues 4,648,250 400,735 1,184,253 (3,463,997) 25.48%
Operating Expenses
Personnel 848,169 62,779 176,118 672,051 20.76%
Operations 4,054,118 327,697 1,550,461 2,503,657 38.24%
Operating Capital 500,000 252 15,617 484,383 3.12%
Transfers 678,682 27,333 81,026 597,656 11.94%
Total Operating Expenses 6,080,969 418,061 1,823,223 4,257,746 29.98%
Available Operating Funds (1,432,719) (17,326) (638,970) 793,749 44.60%
Non-Operating Revenues
46001:Bond Proceeds 657,500 - - (657,500) 0.00%
Total Non-Operating Revenues 657,500 - - (657,500) 0.00%
Non-Operating Expenses
CIP Expense 1,381,411 4,000 123,125 1,258,286 8.91%
Debt Service 550,024 - 30 549,994 0.01%
Total Non-Operating Expenses 1,931,435 4,000 123,155 1,808,280 6.38%
Excess (Deficiency) of Total Revenue over
Total Requirements (2,706,654) (21,326) (762,125) 1,944,529 28.16%
Ending Fund Balance 1,768,620 (21,326) 3,713,149 1,944,529 209.95%
Reserves
Contingency Reserve 354,160 413,189 59,029 116.67%
Debt Service Reserve 505,926 486,959 (18,967) 96.25%
Reserves Total 860,086 900,148 40,062 104.66%
Available Fund Balance 908,534 1,731,590 1,904,467 190.59%
28
Quarterly Financial Report
F
GTEC REVENUE:
Operating revenue is comprised of sales tax and
allocated interest. The budget for sales tax
collections for GTEC is $13,666,398. Year-to-date sales
tax revenue totals $1,051,937, or 7.70% of budget.
Through this period, sales tax collections are up
$78,996, or 8.12% over year-to-date collections from
the prior fiscal year. The City continues to see and
monitor the strong performance in sales tax. Staff
will continue to closely monitor economic shifts and
sales tax volatility as FY2023 progresses.
Non-Operating revenue has a budget of
$20,000,000 and is made up of bond proceeds.
GTEC issued debt for Project Diana and Costco in
FY2022. Due to project timing, staff is proposing to not issue debt in the current fiscal year. This
reduction in bond proceeds and associated CIP expense will be brought to Council as part of the
mid-year budget amendment.
GTEC
Quarterly Comparison: Q1 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals Quarterly Comparison
FY2023 YTD Actuals:
Q1 FY22
YTD Actuals:
Q1 FY23 Variance % of Budget Variance % Varaince
Operating Revenue
40002:Sales Taxes 13,666,398 972,941 1,051,937 (12,614,461) 7.70% 78,996 8.12% 42001:Interest Income 31,500 4,017 364,755 333,255 1157.95% 360,738 8980.24% Operating Revenue Total 13,697,898 976,958 1,416,692 (12,281,206) 10.34% 439,734 45.01%
Non-Operating Revenue
45001:Misc Revenue - - 59,400 59,400 0.00% 59,400 0.00% 46001:Bond Proceeds 20,000,000 - - (20,000,000) 0.00% - 0.00%Non-Operating Revenue
Total 20,000,000 -59,400 (19,940,600) 0.30% 59,400 0.00%
Revenue Total 33,697,898 976,958 1,476,092 (32,221,806) 4.38% 499,134 51.09%
GTEC EXPENSES:
Operating expenses year-to-date total $110,395, or 2.97% of budget through the period. Operating
expenses are predominately made up of administrative expenses and transfers to other City funds.
Administrative expenses include the allocation for City staff to support the GTEC fund. Year-to-date
administrative expenses total $110,395, or 25.00% of budget.
Non-Operating expense budget totals $38,389,853. Year-to-date non-operating expenses total
$4,012,865, or 10.45% of budget. Non-Operating expenses include funding for strategic
partnerships, capital improvement projects, and debt service payment. The debt service payment
is made in the summer and aligns with all other debt service payments for the City. CIP expense
budget totals $33,168,744 in the current year. This amount includes the CIP Roll Forward
amendment approved by Council in January.
K
200K
400K
600K
800K
1.0M
1.2M
Q1
SALES TAX REVENUE
FY2021 FY2022 FY2023
29
Quarterly Financial Report
F
GTEC
Quarterly Comparison: Q1
FY23 Budget FY2022 FY2023
FY2023 Year-to-date:
Budget Vs. Actuals Quarterly Comparison
FY2022 YTD Actuals: Q1 FY22 YTD Actuals: Q1 FY23 Variance % Of Budget Variance % Variance
Operating Expense
Operations 441,581 61,854 110,395 331,186 25.00% (48,541) 78.48%
Transfers 3,276,732 3,232,111 - 3,276,732 0.00% 3,232,111 -100.00%
Total Operating Expenses 3,718,313 3,293,965 110,395 3,607,918 2.97% 3,183,570 -96.65% Non-Operating Expense
Operations 4,300,000 - - 4,300,000 0.00% - 0.00%
CIP Expense 33,168,744 957,833 4,012,865 29,155,879 12.10% (3,055,032) 418.95% Debt Service 921,109 - - 921,109 0.00% - 0.00% Total Non-Operating Expenses 38,389,853 957,833 4,012,865 34,376,988 10.45% (3,055,032) 418.95%
Expense Total 42,108,166 4,251,798 4,123,260 37,984,906 9.79% 128,538 -3.02%
Ending fund balance for FY2023 is budgeted to be $39,177,269. After accounting for the
contingency reserve of $3,512,176, and the debt service reserve of $3,994,673, this fund has a
budgeted available fund balance of $31,670,420.
30
Quarterly Financial Report
F
Fund Schedule:
GTEC
Period: Dec-22 Budget Current Period FY2023
FY2023 Year-to-date: Budget
Vs. Actuals
FY2023 Dec-22 YTD Actuals Variance % of Budget
Beginning Fund Balance 47,587,537 47,587,537 - 100.00%
Operating Revenue
40002:Sales Taxes 13,666,398 1,018,448 1,051,937 (12,614,461) 7.70%
42001:Interest Income 31,500 144,672 364,755 333,255 1157.95% Operating Revenue Total 13,697,898 1,163,120 1,416,692 (12,281,206) 10.34% Operating Expense
Operations 441,581 36,798 110,395 331,186 25.00%
Transfers 3,276,732 - - 3,276,732 0.00%
Operating Expense Total 3,718,313 36,798 110,395 3,607,918 2.97%
Net Operations Total 9,979,585 1,126,322 1,306,297 (15,889,124) 13.09%
Non-Operating Revenue
45001:Misc Revenue - 59,400.00 59,400.00 59,400.00 0.00% 46001:Bond Proceeds 20,000,000 - - (20,000,000) 0.00%
Non-Operating Revenue Total 20,000,000 59,400 59,400 (19,940,600) 0.30%
Non-Operating Expense
Operations 4,300,000 - - 4,300,000 0.00% CIP Expense 33,168,744 148 4,012,865 29,155,879 12.10%
Debt Service 921,109 - - 921,109 0.00%
Non-Operating Expense Total 38,389,853 148 4,012,865 34,376,988 10.45%
Excess (Deficiency) of Total Revenue over
Total Requirements (8,410,268) (4,728,754) (3,843,070) 4,567,198 45.69%
Ending Fund Balance 39,177,269 44,940,369 5,763,100 114.71%
Reserves
AFR Adjustment - - - 0.00% Contingency Reserve 3,512,176 3,512,176 - 100.00% Debt Service Reserve 3,994,673 3,994,673 - 100.00%
Reserves Total 7,506,849 7,506,849 - 100.00%
Estimated Operational Roll Forward 13,168,744
Available Fund Balance 31,670,420 24,264,775 (7,405,644) 76.62%
31
Quarterly Financial Report
F
GEDCO REVENUE:
Operating revenue has a total budget of $3,446,599 in
FY2023 and is comprised of sales tax and allocated
interest. The budget for sales tax collections for GEDCO
is $3,416,599. Year-to-date sales tax revenue totals
$262,984, or 7.70% of budget. Through this period, sales
tax collections are up $19,749, or 8.12% over year-to-date
collections from the prior fiscal year. There is a two-
month lag in sales tax collections/reporting. The City
continues to see and monitor the strong performance
in sales tax. Staff are also monitoring economic shifts
and sales tax volatility as FY2023 progresses.
Non-Operating revenue, which typically includes bond
proceeds, is not part of the FY2023 budget.
GEDCO
Quarterly Comparison: Q1
FY23 Budget FY2022 FY2023
FY2023 Year-to-date: Budget
Vs. Actuals Quarterly Comparison
FY2023 YTD Actuals:
Q1 FY22
YTD Actuals:
Q1 FY23 Variance % Variance Variance % Variance
Operating Revenue 40002:Sales Taxes 3,416,599 243,235 262,984 (3,153,615) 7.70% 19,749 8.12% 42001:Interest Income 30,000 1,938 83,468 53,468 278.23% 81,530 4206.79%
Operating Revenue Total 3,446,599 245,173 346,452 (3,100,147) 10.05% 101,279 41.31%
Non-Operating Revenue
Revenue Total 3,446,599 245,173 346,452 (3,100,147) 10.05% 101,279 41.31%
GEDCO EXPENSES:
Operating expenses have a total budget of $1,008,329 for FY2023. Year-to-date operational
expenses incurred total $185,583, or 18.41% of budget. Operating expenses include administrative
expenses, marketing costs, contractual services, subscriptions, and operating transfers to other City
funds. Administrative expenses include the allocation for City staff to support the GEDCO fund.
Year-to-date administrative expense total $146,078, or 25.00% of budget. The GEDCO fund has
dedicated funding to market the City for potential economic development. Year-to-date marketing
efforts total $18,969, or 18.87% of budget. Contractual services include $100,000 budgeted for
consulting in FY2023. GEDCO will transfer out $204,019 to General Debt Service in FY2023.
K
50K
100K
150K
200K
250K
300K
Q1
SALES TAX REVENUE
FY2021 FY2022 FY2023
32
Quarterly Financial Report
F
Non-Operating expense budget totals $6,641,626. Through the quarter there has been $0 of non-
operating expenses. This is due to the timing of approved economic development agreement
expenses. Non-Operating expenses include funding for strategic partnerships and GEDCO’s debt
service payment. GEDCO has a budget of $6,350,000 for economic development agreements in
FY2023. Additionally, non-operating expense is where GEDCO budgets for the fund’s debt service
payment. The debt service payment includes principal reduction of $76,559, and an interest
expense of $14,947. The debt service payment will be reflected in the Q4 report as it aligns with the
City’s annual debt payment.
GEDCO
Quarterly Comparison: Q1 FY23 Budget FY2022 FY2023 FY2023 Year-to-date: Budget Vs. Actuals Quarterly Comparison
FY2023 YTD Actuals:
Q1 FY22
YTD
Actuals: Q1
FY23
Variance % Variance Variance % Variance
Operating Expense
Operations 804,310 150,008 185,583 618,727 23.07% (35,575) 23.72% Transfers 204,019 202,769 - 204,019 0.00% 202,769 -100.00%
Operating Expense Total 1,008,329 352,777 185,583 822,746 18.41% 167,194 -47.39%
Non-Operating Expense Operations 6,550,000 1,000,000 - 6,550,000 0.00% 1,000,000 -100.00% Debt Service 91,626 - - 91,626 0.00% - 0.00% Operating Expense Total 6,641,626 1,000,000 - 6,641,626 0.00% 1,000,000 -100.00%
Expense Total 7,649,955 1,352,777 185,583 7,464,372 2.43% 1,167,194 -86%
Ending fund balance for FY2022 is budgeted at $2,106,696. After accounting for the contingency
reserve of $878,044, and the debt service reserve of $205,519, this fund is budgeted to have an
available fund balance of $1,023,133.
K
100K
200K
300K
400K
500K
600K
51001:Administrative Expense 51003:Marketing & Promotional 51004:Contractual Services 80001:Transfers Out
OPERATING EXPENSE BY LEDGER
FY2022 Actuals FY2022 Budget
33
Quarterly Financial Report
F
Fund Schedule:
GEDCO
Period: Dec-22 Budget Current Period FY2023 FY2023 Year-to-date: Budget Vs. Actuals
FY2023 Dec-22 YTD Actuals: Q1
FY23 Variance % of Budget
Beginning Fund Balance 6,310,052 6,310,052 - 100.00%
Operating Revenue
40002:Sales Taxes 3,416,599 254,612 262,984 (3,153,615) 7.70%
42001:Interest Income 30,000 33,461 83,468 53,468 278.23%
Operating Revenue Total 3,446,599 288,073 346,452 (3,100,147) 10.05%
Operating Expense
Operations 804,310 62,008 185,583 618,727 23.07%
Transfers 204,019 - - 204,019 0.00%
Operating Expense Total 1,008,329 62,008 185,583 822,746 18.41%
Net Operations Total 2,438,270 226,065 160,869 2,277,401 6.60% Non-Operating Revenue
Non-Operating Expense
Operations 6,550,000 - - (6,550,000) 0.00%
Debt Service 91,626 - - (91,626) 0.00%
Non-Operating Expense Total 6,641,626 - - (6,641,626) 0.00%
Excess (Deficiency) of Total Revenue over Total Requirements (4,203,356) 226,065 (532,035) 3,671,321 12.66%
Ending Fund Balance 2,106,696 6,470,921 4,364,225 307.16%
Reserves
AFR Adjustment - - - - 0.00%
Contingency Reserve 878,044 - 878,044 - 100.00%
Debt Service Reserve 205,519 - 205,519 - 100.00%
Reserves Total 1,083,563 - 1,083,563 - 100.00% Available Fund Balance 1,023,133 - 5,387,358 4,364,225 526.55%
34
Quarterly Financial Report
F
VILLAGE PID MONTHLY REPORT AS OF DECEMBER 31, 2023
Village PID Revenues:
Village PID budgeted revenues total $530,845
and are comprised of property tax and allocated
interest. The City receives the bulk of property tax
revenues in January and February. The City
anticipates receiving $529,845 in property tax
revenue this year, as well as $1,000 in allocated
interest.
Through the end of the first quarter of FY2023,
property tax revenue totals $429,875, or 81.13% of
budget. FY2022 Property tax revenue is up 2.77%,
or $11,594 compared to FY2021. Collection rates and protested values can affect property tax
revenue.
Village PID Expenses:
Village PID expenses include administrative charges, capital, contractual services,
insurance, maintenance, and marketing. Year-to-date operational and capital expenses total
$230,328 or 31.95% of budget. The Parks Department has contracted for Parks Capital
Improvements which total $6,100 year to date, leaving a remaining budget of $233,420.
Ending Fund Balance in FY2023 for Village PID is budgeted at $707,571. After accounting for
the contingency reserve of $111,453 and a capital reserve of $40,222, this fund will have a
budgeted available fund balance of $555,896.
K
200K
400K
Q1
PROPERTY TAX
REVENUES
FY2021 FY2022 FY2023
35
Quarterly Financial Report
F
Fund Schedule:
Village PID
Period: Dec-22 Budget Current Period FY2023 Budget Vs. Actuals
FY2023 Dec-22 YTD Actuals Variance % of Budget
Beginning Fund Balance 897,526 897,526 - 100.00%
Revenue
40001:Property Taxes 529,845 395,059 429,875 (99,970) 81.13%
42001:Interest Income 1,000 - - (1,000) 0.00%
Revenue Total 530,845 395,059 429,875 (100,970) 80.98%
Expense
53002:Postage & Freight 427 427 427 - 100.00%
53004:Insurance Expense 1,061 - - 1,061 0.00%
51001:Administrative Expense 46,388 3,866 11,597 34,791 25.00%
51002:Publishing & Printing 1,801 - - 1,801 0.00%
51003:Marketing &
Promotional 5,000 - - 5,000 0.00%
51004:Contractual Services 21,218 1,250 22,500 (1,282) 106.04%
51007:Contracts & Leases 264,053 12,707 144,728 119,325 54.81%
51008:Utilities 67,538 19,281 24,918 42,620 36.89%
52501:Office Supplies 300 58 58 242 19.33%
52509:Maintenance Expense 53,494 - - 53,494 0.00%
60009:Capital Outlay - Improvements 259,520 - 26,100 233,420 10.06%
Expense Total 720,800 37,589 230,328 490,472 31.95%
Excess (Deficiency) of Total
Revenue over Total
Requirements (189,955) 357,470 199,547 (389,502) -105.05%
Ending Fund Balance 707,571 357,470 1,097,073 389,502 155.05%
Reserves Contingency Reserve 111,453 - 111,453 - 100.00% Capital Reserve 40,222 - 40,222 - 100.00%
Reserves Total 151,675 151,675 - 100.00%
Available Fund Balance 555,896 - 945,398 389,502 170.07%
36
Quarterly Financial Report
F
Fund Schedule:
Council Discretionary
Period: Dec-22 Budget
Current
Period
FY2022 Year-to-date:
Budget Vs. Actuals
FY2023 Dec-22 YTD Actuals Variance % of Budget
Beginning Fund Balance 4,963,198 4,963,198 - 100.00%
Revenue
42001:Interest Income 150 11,277 25,372 25,222 16914.83%
Total Revenue 150 11,277 25,372 25,222 16914.83%
Expense
Transfers 2,377,000 - - 2,377,000 0.00%
Total Expense 2,377,000 - - 2,377,000 0.00%
Excess (Deficiency) of Total
Revenue over Total Requirements (2,376,850) 11,277 25,372 2,402,222 -1.07%
Ending Fund Balance 2,586,348 11,277 4,988,570 (2,351,778) 192.88%
Reserves
AFR Adjustment - - - - -
Contingency Reserve - - - - -
Debt Service Reserve - - - - -
Reserves Total - - - - -
Available Fund Balance 2,586,348 - 4,988,570 2,402,222 192.88%
37
Quarterly Financial Report
F
Fund Schedule:
Joint Services
Period: Dec-22 Budget Current Period FY2023
FY2023 Year-to-date:
Budget Vs. Actuals
FY2023 Dec-22 YTD Actuals:
Q1 FY23 Variance % of Budget
Beginning Fund Balance 4,977,655 4,977,655 -100.00%
Revenue
41002:Penalties 25,000 81,676 85,541 60,541 342.16% 42001:Interest Income 7,000 10,975 17,873 10,873 255.32%
43001:Fees 13,000 16,395 105,495 92,495 811.50%
43004:Administrative Charges 27,275,755 2,283,862 6,851,586 (20,424,169) 25.12%
45001:Misc Revenue 30 (1,066) (2,141) (2,171) -7136.67% 45002:Insurance Proceeds 110,000 13,681 34,081 (75,919) 30.98%
45003:Misc Reimbursements 235,200 4,680 19,405 (215,795) 8.25%
45004:Sale of Property - - 14,228 14,228 0.00%
44502:Developer Contributions - - - - 0.00%
Revenue Total 27,665,985 2,410,203 7,126,067 (20,539,918) 25.76%
Expense
CC0001 Non-Departmental 1,230,000 104,115 486,368 743,632 39.54%
CC0302 Finance Administration 1,455,607 163,976 557,348 898,259 38.29%
CC0315 Accounting 1,818,032 121,020 426,207 1,391,825 23.44% CC0317 Purchasing 912,728 88,775 250,141 662,587 27.41%
CC0321 Utility Customer Service 1,196,564 127,533 328,873 867,691 27.48%
CC0322 Utility Customer Billing 1,696,637 143,153 770,697 925,940 45.42%
CC0324 Customer Admin & Data Analytics 6,193,118 448,879 1,300,225 4,892,893 20.99% CC0503 Organizational and Operational
Excellence 867,502 46,551 123,320 744,182 14.22%
CC0524 Metering Services - 2,208 2,208 (2,208) 0.00%
CC0526 Systems Engineering 4,847,843 390,434 752,421 4,095,422 15.52% CC0534 Conservation - 28 76 (76) 0.00%
CC0637 Economic Development 755,571 37,321 123,763 631,808 16.38%
CC0639 Human Resources 1,819,385 157,474 439,135 1,380,250 24.14%
CC0640 Citywide Human Resources 1,581,750 20,603 1,130,604 451,146 71.48% CC0654 Legal 1,584,543 101,026 344,658 1,239,885 21.75%
CC0658 Real Estate Services 399,366 17,253 35,585 363,781 8.91%
Expense Total 26,697,638 1,970,351 7,071,631 19,626,007 26.49%
Excess (Deficiency) of Total Revenue over
Total Requirements 968,347 439,853 54,436 (913,911) 5.62%
Ending Fund Balance 5,946,002 5,032,091 (913,911) 84.63%
Reserves
Contingency Reserve 4,769,331 4,769,331 - 100.00%
Reserves Total 4,769,331 4,769,331 -100.00%
Available Fund Balance 1,176,672 262,760 (913,912) 22.33%
38
Quarterly Financial Report
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 2023
includes the maturing, reinvesting, new investments of financial institution deposits
(CDs) & purchases of treasury/agency securities. Interest rates continued to increase
during this quarter after the FOMC met. We continue to work closely with Valley
View Consulting to select the best investments as the market is changing rapidly.
The FOMC met in November and December and announced multiple increases in
the Fed Funds Rate from 3-3.25% in September 22 to 4.25-4.50% in December 22. The
FOMC will meet again Jan 31-Feb 1 and March 21-22 and are expected to increase
rates again, but in smaller increments. 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 December 31, 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 December 31, 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 42.1%, debt service at .6%, and bond
proceeds/grants/reserved fund at 57.3%.
The City portfolio increased during this quarter due to receiving the first round of
property taxes. 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,
newly purchased cd’s, and treasury/agency securities. Rates on securities have
helped the city diversify the portfolio compared to the prior year’s holdings.
39
Quarterly Financial Report
CITY Market Value GTEC GEDCO
9/30/22 12/31/22 9/30/22 12/31/22 9/30/22 12/31/22
Total cash
and
investments
$731,043,243 $755,055,451 $38,131,640 $43,069,669 $8,733,297 $9,865,349
Quarter
End
Average
Yield
2.08% 3.37% 2.54% 4.00% 2.52% 4.05%
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 Engineering department is hiring a firm to assist with quicker execution of
capital projects. Finance staff are also assisting Economic Development staff with an
updated cash flow model for GEDCO to manage incentive agreement payments and
potential new projects.
The City’s investment portfolio generally includes bank deposits, local government
investment pool balances, money market accounts, financial institution deposits
(CD’s), and securities/agencies. All of these investments meet the safety
requirements of the PFIA. Local Government Investment Pools must maintain a
40
Quarterly Financial Report
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 has transitioned 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 a working group with the goal of
improving work capacity and efficiencies, and ultimately customer service, related to
capital projects. The 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. A Communications and
Public Engagement staff person has also been re-organized to focus on capital
project status updates. 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.
41
CITY
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
December 31, 2022
Prepared by
Valley View Consulting, L.L.C.
________________________________________________________________________
Leigh Wallace Nathan Parras
Finance Director Assistant Finance Director
________________________________________________________________________
Karrie Pursley Elaine Wilson
Treasurer Assistant Finance Director
The investment portfolio of the City of Georgetown is in compliance with the Public Funds Investment Act and
the Investment Policy and Strategies.
Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or
completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from
sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective
of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total
return yields and do not account for investment advisor fees.
42
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Demand Accounts 12,506,553$ 12,506,553 5,700,533$ 5,700,533$ 0.30%
NOW/MMA 32,888,931 32,888,931 29,206,167 29,206,167 3.97%
Pools 373,311,718 373,311,718 320,394,060 320,394,060 3.97%
CDs/Securities 312,336,041 312,250,541 399,924,271 399,754,691 2.89%
Totals 731,043,243$ 730,957,743$ 755,225,031$ 755,055,451$ 3.37%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 3.37%Total Portfolio 3.37%
Rolling Three Month Treasury 4.19%Rolling Three Month Treasury 4.19%
Rolling Six Month Treasury 3.90%Rolling Six Month Treasury 3.90%
TexPool 3.98%TexPool 3.98%
Bank Fees Offset
7,095$
Interest earnings provided in separate report.7,095$
September 30, 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
December 31, 2022
City of Georgetown Valley View Consulting, L.L.C.143
Economic Overview12/31/2022The Federal Open Market Committee (FOMC) raised the Fed Funds target range 0.50% to 4.25% - 4.50% December 14th (Effective Fed Funds are trading +/-4.33%). A 0.25% increase is projected February 1st. Third Quarter GDP jumped to 3.2% in the final number. December Non-Farm Payroll added 223k new jobs with the Three Month Average declining to 247k. Crude oil continues moderating at +/-$75 per barrel. The Stock Markets drifted between +/-15% to +/-19% below the 2021 peak. The yield curve is fully negatively sloped (3 months to 10 years, with peak yield at 6 months) and continues to indicate lower future interest rates. Inflation remained well over the FOMC 2% target (Core PCE +/-5% and CPI +/-6%). International challenges add to economic uncertainty. 02505007501,0001,2501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,0004,2504,5004,7505,0005,250S&P 5000.000.501.001.502.002.503.003.504.004.505.005.50US Treasury Historical Yields - Since Nov 2015Six Month T-BillTwo Year T-NoteTen Year T-Note0.001.002.003.004.005.006.00Treasury Yield CurvesDecember 31, 2021September 30, 2022December 31, 20220.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.244
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.30%01/01/23 12/31/22 5,700,533$ 5,700,533$ 1.00 5,700,533$ 1 0.30%
JPMorgan Chase MMA 1.15%01/01/23 12/31/22 435,297 435,297 1.00 435,297 1 1.15%
Veritex Community Bank MMA 4.17%01/01/23 12/31/22 3,267,942 3,267,942 1.00 3,267,942 1 4.17%
Wells Fargo Bank Cash 0.00%01/01/23 12/31/22 1,416,799 1,416,799 1.00 1,416,799 1 0.00%
Wells Fargo Bank Sweep 4.04%01/01/23 12/31/22 11,481,710 11,481,710 1.00 11,481,710 1 4.04%
NexBank MMA 4.40%01/01/23 12/31/22 12,604,419 12,604,419 1.00 12,604,419 1 4.40%
TexPool AAAm 3.98%01/01/23 12/31/22 66,599,765 66,599,765 1.00 66,599,765 1 3.98%
TexSTAR AAAm 3.97%01/01/23 12/31/22 253,794,295 253,794,295 1.00 253,794,295 1 3.97%
R Bank CD 0.60%01/05/23 06/30/21 1,009,065 1,009,065 100.00 1,009,065 5 0.60%
East West Bank CD 0.42%01/09/23 01/07/22 5,031,223 5,031,223 100.00 5,031,223 9 0.42%
East West Bank CD 0.51%01/20/23 01/20/22 10,048,462 10,048,462 100.00 10,048,462 20 0.51%
Alliance Bank CD 2.80%02/02/23 08/02/22 4,028,230 4,028,230 100.00 4,028,230 33 2.83%
Texas Capital Bank CD 2.80%02/04/23 08/04/22 7,822,869 7,822,869 100.00 7,822,869 35 2.80%
East West Bank CD 3.12%02/07/23 08/11/22 5,937,128 5,937,128 100.00 5,937,128 38 3.17%
East West Bank CD 0.83%02/08/23 02/08/22 8,059,708 8,059,708 100.00 8,059,708 39 0.83%
East West Bank CD 3.12%02/15/23 08/15/22 4,052,958 4,052,958 100.00 4,052,958 46 3.12%
Bank OZK CD 0.18%02/23/23 08/23/21 4,210,154 4,210,154 100.00 4,210,154 54 0.18%
East West Bank CD 1.19%02/27/23 02/25/22 20,203,158 20,203,158 100.00 20,203,158 58 1.20%
Veritex Community Bank CD 0.18%03/09/23 09/09/21 4,009,005 4,009,005 100.00 4,009,005 68 0.18%
East West Bank CD 1.15%03/14/23 03/14/22 15,139,111 15,139,111 100.00 15,139,111 73 1.16%
T-Bill Aaa/AA+0.00%03/16/23 09/15/22 500,000 496,406 99.87 495,780 75 3.56%
T-Bill Aaa/AA+0.00%03/16/23 09/15/22 26,050,000 25,862,766 99.87 25,830,115 75 3.56%
R Bank CD 3.00%03/23/23 09/22/22 4,537,510 4,537,510 100.00 4,537,510 82 3.05%
East West Bank CD 1.29%03/27/23 03/25/22 25,250,406 25,250,406 100.00 25,250,406 86 1.30%
East West Bank CD 4.08%04/12/23 10/12/22 13,469,398 13,469,398 100.00 13,469,398 102 4.16%
East West Bank CD 4.08%04/12/23 10/12/22 20,181,897 20,181,897 100.00 20,181,897 102 4.16%
Prosperity Bank CD 0.20%04/24/23 04/23/21 5,016,711 5,016,711 100.00 5,016,711 114 0.20%
Prosperity Bank CD 0.20%05/01/23 05/25/21 5,015,887 5,015,887 100.00 5,015,887 121 0.20%
Alliance Bank CD 2.95%05/02/23 08/02/22 4,029,742 4,029,742 100.00 4,029,742 122 2.98%
Texas Capital Bank CD 2.90%05/04/23 08/04/22 1,262,175 1,262,175 100.00 1,262,175 124 2.90%
East West Bank CD 3.22%05/10/23 08/10/22 3,046,348 3,046,348 100.00 3,046,348 130 3.27%
FHLB Aaa/AA+4.60%05/10/23 11/10/22 24,000,000 23,610,000 98.44 23,625,418 130 4.60%
East West Bank CD 4.52%05/15/23 11/15/22 5,029,184 5,029,184 100.00 5,029,184 135 4.62%
Bank OZK CD 0.20%06/12/23 06/11/21 5,026,402 5,026,402 100.00 5,026,402 163 0.20%
East West Bank CD 2.99%06/16/23 06/16/22 15,246,518 15,246,518 100.00 15,246,518 167 3.04%
Texas Capital Bank CD 3.42%06/16/23 09/16/22 5,042,813 5,042,813 100.00 5,042,813 167 3.42%
December 31, 2022
City of Georgetown Valley View Consulting, L.L.C.345
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, 2022
East West Bank CD 2.94%06/20/23 06/22/22 2,541,856 2,541,856 100.00 2,541,856 171 2.98%
Alliance Bank CD 5.10%06/27/23 12/27/22 8,000,000 8,000,000 100.00 8,000,000 178 5.20%
FHLB Aaa/AA+0.00%06/29/23 09/16/22 10,000,000 9,807,750 99.72 9,780,388 180 3.97%
R Bank CD 0.73%06/30/23 06/30/21 1,011,020 1,011,020 100.00 1,011,020 181 0.73%
Alliance Bank CD 3.10%07/01/23 07/01/22 4,062,754 4,062,754 100.00 4,062,754 182 3.14%
FHLB Aaa/AA+0.00%07/31/23 10/17/22 5,000,000 4,872,947 97.43 4,871,584 212 4.47%
East West Bank CD 3.05%08/01/23 08/01/22 2,031,744 2,031,744 100.00 2,031,744 213 3.10%
Alliance Bank CD 3.15%08/02/23 08/02/22 1,007,940 1,007,940 100.00 1,007,940 214 3.19%
Bank OZK CD 0.21%08/14/23 11/12/21 5,011,429 5,011,429 100.00 5,011,429 226 0.21%
East West Bank CD 4.56%08/15/23 11/15/22 5,050,589 5,050,589 100.00 5,050,589 227 4.67%
Texas Capital Bank CD 3.30%08/24/23 08/24/22 2,527,727 2,527,727 100.00 2,527,727 236 3.30%
FHLB Aaa/AA+3.63%09/13/23 09/13/22 13,350,000 13,342,228 99.26 13,243,515 256 3.71%
FFCB Aaa/AA+0.22%09/22/23 09/13/22 925,000 902,004 99.23 895,065 265 3.74%
Veritex Community Bank CD 0.25%09/25/23 09/24/21 10,031,278 10,031,278 100.00 10,031,278 268 0.25%
Bank OZK CD 0.20%10/09/23 10/08/21 5,011,742 5,011,742 100.00 5,011,742 282 0.20%
FHLB Aaa/AA+0.00%10/13/23 10/17/22 2,500,000 2,413,406 96.56 2,413,950 286 4.56%
East West Bank CD 4.53%10/19/23 10/19/22 2,523,065 2,523,065 100.00 2,523,065 292 4.63%
Bank OZK CD 0.30%11/13/23 11/12/21 10,032,623 10,032,623 100.00 10,032,623 317 0.30%
FAMCA Aaa/AA+4.75%11/22/23 11/22/22 2,000,000 2,000,000 100.00 1,999,938 326 4.75%
FAMCA Aaa/AA+4.95%12/13/23 12/13/22 10,000,000 10,000,000 99.82 9,982,024 347 4.95%
Alliance Bank CD 5.10%12/27/23 12/27/22 1,000,000 1,000,000 100.00 1,000,000 361 5.20%
Southside Bank CD 3.32%02/02/24 08/02/22 10,083,682 10,083,682 100.00 10,083,682 398 3.32%
T-Note Aaa/AA+0.25%05/15/24 11/22/22 2,000,000 1,882,662 94.14 1,882,813 501 4.72%
Alliance Bank CD 5.10%06/14/24 12/15/22 10,000,000 10,000,000 100.00 10,000,000 531 5.20%
Alliance Bank CD 5.10%06/27/24 12/27/22 13,100,588 13,100,588 100.00 13,100,588 544 5.20%
Alliance Bank CD 5.10%12/13/24 12/15/22 10,000,000 10,000,000 100.00 10,000,000 713 5.20%
TOTALS 756,359,862$ 755,225,031$ 755,055,451$ 97 3.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.446
0–6 Months84%
6–12 Months11%
12–18 Months5%
Current Quarter Maturities
$0
$100,000,000
$200,000,000
$300,000,000
$400,000,000
$500,000,000
$600,000,000
$700,000,000
$800,000,000
03/31/22 06/30/22 09/30/22 12/31/22
Portfolio Balances
Money Market
Local Depository
TexSTAR
TexPool
Certificate of Deposit
Securities
166174166
102
69
90
7375
109104
123
156163
97108
87
51
67
4941
91
73
6154
99
71
124
95100
8070676358
818274
104113123
156
78
97
0
50
100
150
200
# of DaysWeighted Average to Maturity JPMorgan Chase1%Wells Fargo Bank2%
Texas Capital Bank2%Southside Bank 1%Prosperity Bank1%Veritex Community Bank 2%
Bank OZK4%
NexBank2%
TexPool9%
TexSTAR34%Alliance Bank7%
East West Bank22%
R Bank1%
T-Bill3%
T-Note0%
FAMCA2%
FHLB7%
FFCB0%
Portfolio Holdings by Issuer
City of Georgetown Valley View Consulting, L.L.C.
547
City - Book & Market Value Comparison
Issuer/Description Yield Maturity
Date
Book Value
09/30/22 Increases Decreases Book Value
12/31/22
Market Value
09/30/22
Change in
Market Value
Market Value
12/31/22
JPMorgan Chase Cash 0.30%01/01/23 12,506,553$ –$ (6,806,020)$ 5,700,533$ 12,506,553$ (6,806,020)$ 5,700,533$
JPMorgan Chase MMA 1.15%01/01/23 434,470 826 – 435,297 434,470 826 435,297
Veritex Community Bank MMA 4.17%01/01/23 3,238,147 29,795 – 3,267,942 3,238,147 29,795 3,267,942
Wells Fargo Bank Cash 0.00%01/01/23 16,727,590 – (15,310,791) 1,416,799 16,727,590 (15,310,791) 1,416,799
Wells Fargo Bank Sweep 4.04%01/01/23 – 11,481,710 – 11,481,710 – 11,481,710 11,481,710
NexBank MMA 4.40%01/01/23 12,488,723 115,696 – 12,604,419 12,488,723 115,696 12,604,419
TexPool 3.98%01/01/23 31,811,436 34,788,329 – 66,599,765 31,811,436 34,788,329 66,599,765
TexSTAR 3.97%01/01/23 341,500,283 – (87,705,987) 253,794,295 341,500,283 (87,705,987) 253,794,295
Independent Bank CD 0.30%10/18/22 2,562,534 – (2,562,534) – 2,562,534 (2,562,534) – Prosperity Bank CD 0.20%10/24/22 5,014,211 – (5,014,211) – 5,014,211 (5,014,211) –
East West Bank CD 0.21%11/15/22 10,018,428 – (10,018,428) – 10,018,428 (10,018,428) –
Prosperity Bank CD 0.40%11/17/22 2,014,712 – (2,014,712) – 2,014,712 (2,014,712) –
Prosperity Bank CD 0.15%11/23/22 2,003,257 – (2,003,257) – 2,003,257 (2,003,257) –
Prosperity Bank CD 0.15%12/21/22 5,007,505 – (5,007,505) – 5,007,505 (5,007,505) –
Alliance Bank CD 2.52%12/24/22 8,050,411 – (8,050,411) – 8,050,411 (8,050,411) –
East West Bank CD 1.07%12/26/22 12,066,396 – (12,066,396) – 12,066,396 (12,066,396) –
R Bank CD 0.60%01/05/23 1,007,557 1,508 – 1,009,065 1,007,557 1,508 1,009,065
East West Bank CD 0.42%01/09/23 5,025,900 5,323 – 5,031,223 5,025,900 5,323 5,031,223
East West Bank CD 0.51%01/20/23 10,035,553 12,909 – 10,048,462 10,035,553 12,909 10,048,462
Alliance Bank CD 2.83%02/02/23 4,000,000 28,230 – 4,028,230 4,000,000 28,230 4,028,230 Texas Capital Bank CD 2.80%02/04/23 7,768,451 54,417 – 7,822,869 7,768,451 54,417 7,822,869
East West Bank CD 3.17%02/07/23 5,890,623 46,505 – 5,937,128 5,890,623 46,505 5,937,128
East West Bank CD 0.83%02/08/23 8,042,865 16,844 – 8,059,708 8,042,865 16,844 8,059,708
East West Bank CD 3.12%02/15/23 4,021,211 31,747 – 4,052,958 4,021,211 31,747 4,052,958 Bank OZK CD 0.18%02/23/23 4,208,255 1,899 – 4,210,154 4,208,255 1,899 4,210,154
East West Bank CD 1.20%02/27/23 20,142,652 60,507 – 20,203,158 20,142,652 60,507 20,203,158
Veritex Community Bank CD 0.18%03/09/23 4,007,206 1,799 – 4,009,005 4,007,206 1,799 4,009,005
East West Bank CD 1.16%03/14/23 15,095,293 43,818 – 15,139,111 15,095,293 43,818 15,139,111
T-Bill 3.56%03/16/23 491,998 4,408 – 496,406 491,638 4,141 495,780
T-Bill 3.56%03/16/23 25,633,091 229,674 – 25,862,766 25,614,354 215,760 25,830,115
R Bank CD 3.05%03/23/23 4,503,330 34,180 – 4,537,510 4,503,330 34,180 4,537,510
East West Bank CD 1.30%03/27/23 25,168,439 81,967 – 25,250,406 25,168,439 81,967 25,250,406
East West Bank CD 4.16%04/12/23 – 13,469,398 – 13,469,398 – 13,469,398 13,469,398
East West Bank CD 4.16%04/12/23 – 20,181,897 – 20,181,897 – 20,181,897 20,181,897
Prosperity Bank CD 0.20%04/24/23 5,014,211 2,501 – 5,016,711 5,014,211 2,501 5,016,711 Prosperity Bank CD 0.20%05/01/23 5,013,387 2,500 – 5,015,887 5,013,387 2,500 5,015,887
Alliance Bank CD 2.98%05/02/23 4,000,000 29,742 – 4,029,742 4,000,000 29,742 4,029,742
Texas Capital Bank CD 2.90%05/04/23 1,253,082 9,092 – 1,262,175 1,253,082 9,092 1,262,175
East West Bank CD 3.27%05/10/23 3,021,724 24,624 – 3,046,348 3,021,724 24,624 3,046,348 FHLB 4.60%05/10/23 – 23,610,000 – 23,610,000 – 23,625,418 23,625,418
East West Bank CD 4.62%05/15/23 – 5,029,184 – 5,029,184 – 5,029,184 5,029,184
City of Georgetown Valley View Consulting, L.L.C.648
City - Book & Market Value Comparison
Issuer/Description Yield Maturity
Date
Book Value
09/30/22 Increases Decreases Book Value
12/31/22
Market Value
09/30/22
Change in
Market Value
Market Value
12/31/22
Bank OZK CD 0.20%06/12/23 5,023,884 2,518 – 5,026,402 5,023,884 2,518 5,026,402
East West Bank CD 3.04%06/16/23 15,132,051 114,468 – 15,246,518 15,132,051 114,468 15,246,518
Texas Capital Bank CD 3.42%06/16/23 5,000,000 42,813 – 5,042,813 5,000,000 42,813 5,042,813
East West Bank CD 2.98%06/20/23 2,523,090 18,766 – 2,541,856 2,523,090 18,766 2,541,856
Alliance Bank CD 5.20%06/27/23 – 8,000,000 – 8,000,000 – 8,000,000 8,000,000
FHLB 3.97%06/29/23 9,709,489 98,261 – 9,807,750 9,716,191 64,197 9,780,388 R Bank CD 0.73%06/30/23 1,009,182 1,838 – 1,011,020 1,009,182 1,838 1,011,020
Alliance Bank CD 3.14%07/01/23 4,031,255 31,499 – 4,062,754 4,031,255 31,499 4,062,754
FHLB 4.47%07/31/23 – 4,872,947 – 4,872,947 – 4,871,584 4,871,584
East West Bank CD 3.10%08/01/23 2,016,185 15,559 – 2,031,744 2,016,185 15,559 2,031,744 Alliance Bank CD 3.19%08/02/23 1,000,000 7,940 – 1,007,940 1,000,000 7,940 1,007,940
Bank OZK CD 0.21%08/14/23 5,008,794 2,635 – 5,011,429 5,008,794 2,635 5,011,429
East West Bank CD 4.67%08/15/23 – 5,050,589 – 5,050,589 – 5,050,589 5,050,589
Texas Capital Bank CD 3.30%08/24/23 2,507,016 20,710 – 2,527,727 2,507,016 20,710 2,527,727
FHLB 3.71%09/13/23 13,339,436 2,793 – 13,342,228 13,271,236 (27,720) 13,243,515
FFCB 3.74%09/22/23 894,020 7,984 – 902,004 889,114 5,951 895,065
Veritex Community Bank CD 0.25%09/25/23 10,025,029 6,250 – 10,031,278 10,025,029 6,250 10,031,278
Bank OZK CD 0.20%10/09/23 5,009,232 2,511 – 5,011,742 5,009,232 2,511 5,011,742
FHLB 4.56%10/13/23 – 2,413,406 – 2,413,406 – 2,413,950 2,413,950
East West Bank CD 4.63%10/19/23 – 2,523,065 – 2,523,065 – 2,523,065 2,523,065
Bank OZK CD 0.30%11/13/23 10,025,098 7,525 – 10,032,623 10,025,098 7,525 10,032,623 FAMCA 4.75%11/22/23 – 2,000,000 – 2,000,000 – 1,999,938 1,999,938
FAMCA 4.95%12/13/23 – 10,000,000 – 10,000,000 – 9,982,024 9,982,024
Alliance Bank CD 5.20%12/27/23 – 1,000,000 – 1,000,000 – 1,000,000 1,000,000
Southside Bank CD 3.32%02/02/24 10,000,000 83,682 – 10,083,682 10,000,000 83,682 10,083,682 T-Note 4.72%05/15/24 – 1,882,662 – 1,882,662 – 1,882,813 1,882,813
Alliance Bank CD 5.20%06/14/24 – 10,000,000 – 10,000,000 – 10,000,000 10,000,000
Alliance Bank CD 5.20%06/27/24 – 13,100,588 – 13,100,588 – 13,100,588 13,100,588
Alliance Bank CD 5.20%12/13/24 – 10,000,000 – 10,000,000 – 10,000,000 10,000,000
TOTAL / AVERAGE 3.37%731,043,243$ 180,742,039$ (156,560,252)$ 755,225,031$ 730,957,743$ 24,097,708$ 755,055,451$
City of Georgetown Valley View Consulting, L.L.C.749
City - Allocation
Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 GO-
Roads
2015 Revenue
Water WW
2016 GO-
Roads
Garey Park
Donation
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Roads
JPMorgan Chase Cash 5,700,533$ 5,700,533$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 435,297 435,297 – – – – – – – – – – –
Veritex Community Bank MMA 3,267,942 3,267,942 – – – – – – – – – – –
Wells Fargo Bank Cash 1,416,799 1,416,799 – – – – – – – – – – –
Wells Fargo Bank Sweep 11,481,710 11,481,710 – – – – – – – – – – –
NexBank MMA 12,604,419 12,604,419 – – – – – – – – – – –
TexPool 66,599,765 66,599,765 – – – – – – – – – – –
TexSTAR 253,794,295 28,292,274 456,480 4,702,961 139,416 1,874,265 1,555,365 412,069 1,074,756 7,751,060 54,870 327,804 1,466,696
R Bank CD 01/05/23 1,009,065 1,009,065 – – – – – – – – – – –
East West Bank CD 01/09/23 5,031,223 5,031,223 – – – – – – – – – – –
East West Bank CD 01/20/23 10,048,462 10,048,462 – – – – – – – – – – –
Alliance Bank CD 02/02/23 4,028,230 – – – – – – – – – – – –
Texas Capital Bank CD 02/04/23 7,822,869 – – – – – – – – – – – –
East West Bank CD 02/07/23 5,937,128 – – – – – – – – – – – –
East West Bank CD 02/08/23 8,059,708 8,059,708 – – – – – – – – – – –
East West Bank CD 02/15/23 4,052,958 – – – – – – – – – – – –
Bank OZK CD 02/23/23 4,210,154 4,210,154 – – – – – – – – – – –
East West Bank CD 02/27/23 20,203,158 20,203,158 – – – – – – – – – – –
Veritex Community Bank CD 03/09/23 4,009,005 4,009,005 – – – – – – – – – – –
East West Bank CD 03/14/23 15,139,111 15,139,111 – – – – – – – – – – –
T-Bill 03/16/23 496,406 – – – – – – – – – – – –
T-Bill 03/16/23 25,862,766 – – – – – – – – – – – –
R Bank CD 03/23/23 4,537,510 – – – – – – – – – – – –
East West Bank CD 03/27/23 25,250,406 – – – – – – – – – – – –
East West Bank CD 04/12/23 13,469,398 – – – – – – – – – – – –
East West Bank CD 04/12/23 20,181,897 – – – – – – – – – – – –
Prosperity Bank CD 04/24/23 5,016,711 5,016,711 – – – – – – – – – – –
Prosperity Bank CD 05/01/23 5,015,887 5,015,887 – – – – – – – – – – –
Alliance Bank CD 05/02/23 4,029,742 – – – – – – – – – – – –
Texas Capital Bank CD 05/04/23 1,262,175 – – – – – – – – – – – –
East West Bank CD 05/10/23 3,046,348 – – – – – – – – 3,046,348 – – –
FHLB 05/10/23 23,610,000 – – – – – – – – – – – –
East West Bank CD 05/15/23 5,029,184 – – – – – – – – – – – –
Bank OZK CD 06/12/23 5,026,402 5,026,402 – – – – – – – – – – –
East West Bank CD 06/16/23 15,246,518 15,246,518 – – – – – – – – – – –
Texas Capital Bank CD 06/16/23 5,042,813 5,042,813 – – – – – – – – – – –
East West Bank CD 06/20/23 2,541,856 – – – – – – – – – – – –
Alliance Bank CD 06/27/23 8,000,000 – – – – – – – – – – – –
FHLB 06/29/23 9,807,750 9,807,750 – – – – – – – – – – –
R Bank CD 06/30/23 1,011,020 1,011,020 – – – – – – – – – – –
Alliance Bank CD 07/01/23 4,062,754 4,062,754 – – – – – – – – – – –
FHLB 07/31/23 4,872,947 4,872,947 – – – – – – – – – – –
East West Bank CD 08/01/23 2,031,744 – – – – – – – – – – – –
Alliance Bank CD 08/02/23 1,007,940 – – – – – – – – – – – –
Bank OZK CD 08/14/23 5,011,429 5,011,429 – – – – – – – – – – –
East West Bank CD 08/15/23 5,050,589 – – – – – – – – – – – –
Texas Capital Bank CD 08/24/23 2,527,727 2,527,727 – – – – – – – – – – –
FHLB 09/13/23 13,342,228 – – – – – – – – – – – –
FFCB 09/22/23 902,004 – – – – – – – – – – – –
Veritex Community Bank CD 09/25/23 10,031,278 10,031,278 – – – – – – – – – – –
Bank OZK CD 10/09/23 5,011,742 5,011,742 – – – – – – – – – – –
FHLB 10/13/23 2,413,406 2,413,406 – – – – – – – – – – –
East West Bank CD 10/19/23 2,523,065 2,523,065 – – – – – – – – – – –
Bank OZK CD 11/13/23 10,032,623 10,032,623 – – – – – – – – – – –
FAMCA 11/22/23 2,000,000 2,000,000 – – – – – – – – – – –
FAMCA 12/13/23 10,000,000 10,000,000 – – – – – – – – – – –
Alliance Bank CD 12/27/23 1,000,000 1,000,000 – – – – – – – – – – –
Southside Bank CD 02/02/24 10,083,682 – – – – – – – – – – – –
T-Note 05/15/24 1,882,662 1,882,662 – – – – – – – – – – –
Alliance Bank CD 06/14/24 10,000,000 – – – – – – – – – – – –
Alliance Bank CD 06/27/24 13,100,588 13,100,588 – – – – – – – – – – –
Alliance Bank CD 12/13/24 10,000,000 – – – – – – – – – – – –
Totals 755,225,031$ 318,145,949$ 456,480$ 4,702,961$ 139,416$ 1,874,265$ 1,555,365$ 412,069$ 1,074,756$ 10,797,408$ 54,870$ 327,804$ 1,466,696$
Book Value
December 31, 2022
City of Georgetown Valley View Consulting, L.L.C.850
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
Wells Fargo Bank Cash
Wells Fargo Bank Sweep
NexBank MMA
TexPool
TexSTAR
R Bank CD 01/05/23
East West Bank CD 01/09/23
East West Bank CD 01/20/23
Alliance Bank CD 02/02/23
Texas Capital Bank CD 02/04/23
East West Bank CD 02/07/23
East West Bank CD 02/08/23
East West Bank CD 02/15/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
T-Bill 03/16/23
T-Bill 03/16/23
R Bank CD 03/23/23
East West Bank CD 03/27/23
East West Bank CD 04/12/23
East West Bank CD 04/12/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Alliance Bank CD 05/02/23
Texas Capital Bank CD 05/04/23
East West Bank CD 05/10/23
FHLB 05/10/23
East West Bank CD 05/15/23
Bank OZK CD 06/12/23
East West Bank CD 06/16/23
Texas Capital Bank CD 06/16/23
East West Bank CD 06/20/23
Alliance Bank CD 06/27/23
FHLB 06/29/23
R Bank CD 06/30/23
Alliance Bank CD 07/01/23
FHLB 07/31/23
East West Bank CD 08/01/23
Alliance Bank CD 08/02/23
Bank OZK CD 08/14/23
East West Bank CD 08/15/23
Texas Capital Bank CD 08/24/23
FHLB 09/13/23
FFCB 09/22/23
Veritex Community Bank CD 09/25/23
Bank OZK CD 10/09/23
FHLB 10/13/23
East West Bank CD 10/19/23
Bank OZK CD 11/13/23
FAMCA 11/22/23
FAMCA 12/13/23
Alliance Bank CD 12/27/23
Southside Bank CD 02/02/24
T-Note 05/15/24
Alliance Bank CD 06/14/24
Alliance Bank CD 06/27/24
Alliance Bank CD 12/13/24
Totals
Book Value
December 31, 2022
(Continued)
2019 CO-
Streets/
Facilities/
Equip
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
City - 2021 CO
Airport
City - 2021 CO
Fac/Equip/ Parks
City - 2021
GO Parks
City - 2021
GO Roads
City - 2021A
CO Electric
City - 2021A
CO Water/WW
City - 2021A
GO Roads
–$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
6,091,276 2,784,486 606,990 264,917 4,064,654 1,189 3,822,770 710,739 3,584,136 194,080 3,823,080 440,012 8,665,713 10,361,819
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – 4,052,958 – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – 2,520,839 – – – – 2,016,671
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – 5,029,184
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – 2,541,856 –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – 2,031,744 – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – 5,050,589
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
6,091,276$ 2,784,486$ 606,990$ 264,917$ 6,096,398$ 1,189$ 3,822,770$ 710,739$ 10,157,933$ 194,080$ 3,823,080$ 440,012$ 11,207,569$ 22,458,263$ City of Georgetown Valley View Consulting, L.L.C.951
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
Wells Fargo Bank Cash
Wells Fargo Bank Sweep
NexBank MMA
TexPool
TexSTAR
R Bank CD 01/05/23
East West Bank CD 01/09/23
East West Bank CD 01/20/23
Alliance Bank CD 02/02/23
Texas Capital Bank CD 02/04/23
East West Bank CD 02/07/23
East West Bank CD 02/08/23
East West Bank CD 02/15/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
T-Bill 03/16/23
T-Bill 03/16/23
R Bank CD 03/23/23
East West Bank CD 03/27/23
East West Bank CD 04/12/23
East West Bank CD 04/12/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Alliance Bank CD 05/02/23
Texas Capital Bank CD 05/04/23
East West Bank CD 05/10/23
FHLB 05/10/23
East West Bank CD 05/15/23
Bank OZK CD 06/12/23
East West Bank CD 06/16/23
Texas Capital Bank CD 06/16/23
East West Bank CD 06/20/23
Alliance Bank CD 06/27/23
FHLB 06/29/23
R Bank CD 06/30/23
Alliance Bank CD 07/01/23
FHLB 07/31/23
East West Bank CD 08/01/23
Alliance Bank CD 08/02/23
Bank OZK CD 08/14/23
East West Bank CD 08/15/23
Texas Capital Bank CD 08/24/23
FHLB 09/13/23
FFCB 09/22/23
Veritex Community Bank CD 09/25/23
Bank OZK CD 10/09/23
FHLB 10/13/23
East West Bank CD 10/19/23
Bank OZK CD 11/13/23
FAMCA 11/22/23
FAMCA 12/13/23
Alliance Bank CD 12/27/23
Southside Bank CD 02/02/24
T-Note 05/15/24
Alliance Bank CD 06/14/24
Alliance Bank CD 06/27/24
Alliance Bank CD 12/13/24
Totals
Book Value
December 31, 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
City - Impact
Fees - Water
City - Impact
Fees - WW
City - Limited
Tax Note,
Series 2022
–$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
507,308 2,800,971 11,196 425,091 583,384 7,340 100,224,259 7,754,191 39,320,433 4,596,665 4,039,581
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – 4,028,230 – – – – – – –
– – – – 7,822,869 – – – – –
– – – – – 5,937,128 – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – 496,406 – – – – – – – –
– – – – – – 25,862,766 – – – –
– – – – – – – – – – –
– – – – – – – – 25,250,406 – –
– – – – 13,469,398 – – – – – –
– – – – – – 20,181,897 – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – 4,029,742 – – – – – –
– – – – 1,262,175 – – – – – –
– – – – – – – – – – –
– – – – – 3,935,000 19,675,000 – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – 8,000,000 –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– 1,007,940 – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – 13,342,228 – – – – – –
– – – – – 902,004 – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – 10,083,682 – – – –
– – – – – – – – – – –
– – – – – – 10,000,000 – – – –
– – – – – – – – – – –
– – – – – – 10,000,000 – – – –
507,308$ 3,808,910$ 507,603$ 4,453,321$ 40,509,796$ 10,781,472$ 196,027,604$ 7,754,191$ 64,570,839$ 12,596,665$ 4,039,581$ City of Georgetown Valley View Consulting, L.L.C.1052
City - Allocation
December 31, 2022
Market Value Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 GO-
Roads
2015 Revenue
Water WW
2016 GO-
Roads
Garey Park
Donation
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Roads
JPMorgan Chase Cash 5,700,533$ 5,700,533$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 435,297 435,297 – – – – – – – – – – –
Veritex Community Bank MMA 3,267,942 3,267,942 – – – – – – – – – – –
Wells Fargo Bank Cash 1,416,799 1,416,799 – – – – – – – – – – –
Wells Fargo Bank Sweep 11,481,710 11,481,710 – – – – – – – – – – –
NexBank MMA 12,604,419 12,604,419 – – – – – – – – – – –
TexPool 66,599,765 66,599,765 – – – – – – – – – – –
TexSTAR 253,794,295 28,292,274 456,480 4,702,961 139,416 1,874,265 1,555,365 412,069 1,074,756 7,751,060 54,870 327,804 1,466,696
R Bank CD 01/05/23 1,009,065 1,009,065 – – – – – – – – – – –
East West Bank CD 01/09/23 5,031,223 5,031,223 – – – – – – – – – – –
East West Bank CD 01/20/23 10,048,462 10,048,462 – – – – – – – – – – –
Alliance Bank CD 02/02/23 4,028,230 – – – – – – – – – – – –
Texas Capital Bank CD 02/04/23 7,822,869 – – – – – – – – – – – –
East West Bank CD 02/07/23 5,937,128 – – – – – – – – – – – –
East West Bank CD 02/08/23 8,059,708 8,059,708 – – – – – – – – – – –
East West Bank CD 02/15/23 4,052,958 – – – – – – – – – – – –
Bank OZK CD 02/23/23 4,210,154 4,210,154 – – – – – – – – – – –
East West Bank CD 02/27/23 20,203,158 20,203,158 – – – – – – – – – – –
Veritex Community Bank CD 03/09/23 4,009,005 4,009,005 – – – – – – – – – – –
East West Bank CD 03/14/23 15,139,111 15,139,111 – – – – – – – – – – –
T-Bill 03/16/23 495,780 – – – – – – – – – – – –
T-Bill 03/16/23 25,830,115 – – – – – – – – – – – –
R Bank CD 03/23/23 4,537,510 – – – – – – – – – – – –
East West Bank CD 03/27/23 25,250,406 – – – – – – – – – – – –
East West Bank CD 04/12/23 13,469,398 – – – – – – – – – – – –
East West Bank CD 04/12/23 20,181,897 – – – – – – – – – – – –
Prosperity Bank CD 04/24/23 5,016,711 5,016,711 – – – – – – – – – – –
Prosperity Bank CD 05/01/23 5,015,887 5,015,887 – – – – – – – – – – –
Alliance Bank CD 05/02/23 4,029,742 – – – – – – – – – – – –
Texas Capital Bank CD 05/04/23 1,262,175 – – – – – – – – – – – –
East West Bank CD 05/10/23 3,046,348 – – – – – – – – 3,046,348 – – –
FHLB 05/10/23 23,625,418 – – – – – – – – – – – –
East West Bank CD 05/15/23 5,029,184 – – – – – – – – – – – –
Bank OZK CD 06/12/23 5,026,402 5,026,402 – – – – – – – – – – –
East West Bank CD 06/16/23 15,246,518 15,246,518 – – – – – – – – – – –
Texas Capital Bank CD 06/16/23 5,042,813 5,042,813 – – – – – – – – – – –
East West Bank CD 06/20/23 2,541,856 – – – – – – – – – – – –
Alliance Bank CD 06/27/23 8,000,000 – – – – – – – – – – – –
FHLB 06/29/23 9,780,388 9,780,388 – – – – – – – – – – –
R Bank CD 06/30/23 1,011,020 1,011,020 – – – – – – – – – – –
Alliance Bank CD 07/01/23 4,062,754 4,062,754 – – – – – – – – – – –
FHLB 07/31/23 4,871,584 4,871,584 – – – – – – – – – – –
East West Bank CD 08/01/23 2,031,744 – – – – – – – – – – – –
Alliance Bank CD 08/02/23 1,007,940 – – – – – – – – – – – –
Bank OZK CD 08/14/23 5,011,429 5,011,429 – – – – – – – – – – –
East West Bank CD 08/15/23 5,050,589 – – – – – – – – – – – –
Texas Capital Bank CD 08/24/23 2,527,727 2,527,727 – – – – – – – – – – –
FHLB 09/13/23 13,243,515 – – – – – – – – – – – –
FFCB 09/22/23 895,065 – – – – – – – – – – – –
Veritex Community Bank CD 09/25/23 10,031,278 10,031,278 – – – – – – – – – – –
Bank OZK CD 10/09/23 5,011,742 5,011,742 – – – – – – – – – – –
FHLB 10/13/23 2,413,950 2,413,950 – – – – – – – – – – –
East West Bank CD 10/19/23 2,523,065 2,523,065 – – – – – – – – – – –
Bank OZK CD 11/13/23 10,032,623 10,032,623 – – – – – – – – – – –
FAMCA 11/22/23 1,999,938 1,999,938 – – – – – – – – – – –
FAMCA 12/13/23 9,982,024 9,982,024 – – – – – – – – – – –
Alliance Bank CD 12/27/23 1,000,000 1,000,000 – – – – – – – – – – –
Southside Bank CD 02/02/24 10,083,682 – – – – – – – – – – – –
T-Note 05/15/24 1,882,813 1,882,813 – – – – – – – – – – –
Alliance Bank CD 06/14/24 10,000,000 – – – – – – – – – – – –
Alliance Bank CD 06/27/24 13,100,588 13,100,588 – – – – – – – – – – –
Alliance Bank CD 12/13/24 10,000,000 – – – – – – – – – – – –
Totals 755,055,451$ 318,099,881$ 456,480$ 4,702,961$ 139,416$ 1,874,265$ 1,555,365$ 412,069$ 1,074,756$ 10,797,408$ 54,870$ 327,804$ 1,466,696$ City of Georgetown Valley View Consulting, L.L.C.1153
City - Allocation
December 31, 2022
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
Wells Fargo Bank Cash
Wells Fargo Bank Sweep
NexBank MMA
TexPool
TexSTAR
R Bank CD 01/05/23
East West Bank CD 01/09/23
East West Bank CD 01/20/23
Alliance Bank CD 02/02/23
Texas Capital Bank CD 02/04/23
East West Bank CD 02/07/23
East West Bank CD 02/08/23
East West Bank CD 02/15/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
T-Bill 03/16/23
T-Bill 03/16/23
R Bank CD 03/23/23
East West Bank CD 03/27/23
East West Bank CD 04/12/23
East West Bank CD 04/12/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Alliance Bank CD 05/02/23
Texas Capital Bank CD 05/04/23
East West Bank CD 05/10/23
FHLB 05/10/23
East West Bank CD 05/15/23
Bank OZK CD 06/12/23
East West Bank CD 06/16/23
Texas Capital Bank CD 06/16/23
East West Bank CD 06/20/23
Alliance Bank CD 06/27/23
FHLB 06/29/23
R Bank CD 06/30/23
Alliance Bank CD 07/01/23
FHLB 07/31/23
East West Bank CD 08/01/23
Alliance Bank CD 08/02/23
Bank OZK CD 08/14/23
East West Bank CD 08/15/23
Texas Capital Bank CD 08/24/23
FHLB 09/13/23
FFCB 09/22/23
Veritex Community Bank CD 09/25/23
Bank OZK CD 10/09/23
FHLB 10/13/23
East West Bank CD 10/19/23
Bank OZK CD 11/13/23
FAMCA 11/22/23
FAMCA 12/13/23
Alliance Bank CD 12/27/23
Southside Bank CD 02/02/24
T-Note 05/15/24
Alliance Bank CD 06/14/24
Alliance Bank CD 06/27/24
Alliance Bank CD 12/13/24
Totals
(Continued)
2019 CO-
Streets/
Facilities/
Equip
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
City - 2021 CO
Airport
City - 2021 CO
Fac/Equip/ Parks
City - 2021
GO Parks
City - 2021
GO Roads
City - 2021A
CO Electric
City - 2021A
CO Water/WW
City - 2021A
GO Roads
–$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
6,091,276 2,784,486 606,990 264,917 4,064,654 1,189 3,822,770 710,739 3,584,136 194,080 3,823,080 440,012 8,665,713 10,361,819
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – 4,052,958 – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – 2,520,839 – – – – 2,016,671
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – 5,029,184
– – – – – – – – – – – – – –
– – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – 2,541,856 –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – 2,031,744 – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – 5,050,589
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
6,091,276$ 2,784,486$ 606,990$ 264,917$ 6,096,398$ 1,189$ 3,822,770$ 710,739$ 10,157,933$ 194,080$ 3,823,080$ 440,012$ 11,207,569$ 22,458,263$ City of Georgetown Valley View Consulting, L.L.C.1254
City - Allocation
December 31, 2022
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
Wells Fargo Bank Cash
Wells Fargo Bank Sweep
NexBank MMA
TexPool
TexSTAR
R Bank CD 01/05/23
East West Bank CD 01/09/23
East West Bank CD 01/20/23
Alliance Bank CD 02/02/23
Texas Capital Bank CD 02/04/23
East West Bank CD 02/07/23
East West Bank CD 02/08/23
East West Bank CD 02/15/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
T-Bill 03/16/23
T-Bill 03/16/23
R Bank CD 03/23/23
East West Bank CD 03/27/23
East West Bank CD 04/12/23
East West Bank CD 04/12/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Alliance Bank CD 05/02/23
Texas Capital Bank CD 05/04/23
East West Bank CD 05/10/23
FHLB 05/10/23
East West Bank CD 05/15/23
Bank OZK CD 06/12/23
East West Bank CD 06/16/23
Texas Capital Bank CD 06/16/23
East West Bank CD 06/20/23
Alliance Bank CD 06/27/23
FHLB 06/29/23
R Bank CD 06/30/23
Alliance Bank CD 07/01/23
FHLB 07/31/23
East West Bank CD 08/01/23
Alliance Bank CD 08/02/23
Bank OZK CD 08/14/23
East West Bank CD 08/15/23
Texas Capital Bank CD 08/24/23
FHLB 09/13/23
FFCB 09/22/23
Veritex Community Bank CD 09/25/23
Bank OZK CD 10/09/23
FHLB 10/13/23
East West Bank CD 10/19/23
Bank OZK CD 11/13/23
FAMCA 11/22/23
FAMCA 12/13/23
Alliance Bank CD 12/27/23
Southside Bank CD 02/02/24
T-Note 05/15/24
Alliance Bank CD 06/14/24
Alliance Bank CD 06/27/24
Alliance Bank CD 12/13/24
Totals
(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
City - Impact
Fees - Water
City - Impact
Fees - WW
City - Limited
Tax Note,
Series 2022
–$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
507,308 2,800,971 11,196 425,091 583,384 7,340 100,224,259 7,754,191 39,320,433 4,596,665 4,039,581
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – 4,028,230 – – – – – – –
– – – – 7,822,869 – – – – – –
– – – – – 5,937,128 – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – 495,780 – – – – – – – –
– – – – – – 25,830,115 – – – –
– – – – – – – – – – –
– – – – – – – – 25,250,406 – –
– – – – 13,469,398 – – – – – –
– – – – – – 20,181,897 – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – 4,029,742 – – – – – –
– – – – 1,262,175 – – – – – –
– – – – – – – – – – –
– – – – – 3,937,570 19,687,848 – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – 8,000,000 –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– 1,007,940 – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – 13,243,515 – – – – – –
– – – – – 895,065 – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – 10,083,682 – – – –
– – – – – – – – – – –
– – – – – – 10,000,000 – – – –
– – – – – – – – – – –
– – – – – – 10,000,000 – – – –
507,308$ 3,808,910$ 506,976$ 4,453,321$ 40,411,083$ 10,777,103$ 196,007,801$ 7,754,191$ 64,570,839$ 12,596,665$ 4,039,581$ City of Georgetown Valley View Consulting, L.L.C.1355
City - Allocation
Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 GO-
Roads
2015 Revenue
Water WW
2016 GO-
Roads
Garey Park
Donation
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Roads
JPMorgan Chase Cash 12,506,553$ 12,506,553$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,470 434,470 – – – – – – – – – – –
Veritex Community Bank MMA 3,238,147 3,238,147 – – – – – – – – – – –
Wells Fargo Bank Cash 16,727,590 16,727,590 – – – – – – – – – – –
NexBank MMA 12,488,723 12,488,723 – – – – – – – – – – –
TexPool 31,811,436 31,811,436 – – – – – – – – – – –
TexSTAR 341,500,283 28,675,146 452,616 2,934,215 138,208 1,528,939 1,541,884 922,302 1,067,755 7,841,897 57,072 368,747 1,728,899
Independent Bank CD 10/18/22 2,562,534 2,562,534 – – – – – – – – – – –
Prosperity Bank CD 10/24/22 5,014,211 5,014,211 – – – – – – – – – – –
East West Bank CD 11/15/22 10,018,428 – – – – – – – – – – – –
Prosperity Bank CD 11/17/22 2,014,712 2,014,712 – – – – – – – – – – –
Prosperity Bank CD 11/23/22 2,003,257 2,003,257 – – – – – – – – – – –
Prosperity Bank CD 12/21/22 5,007,505 5,007,505 – – – – – – – – – – –
Alliance Bank CD 12/24/22 8,050,411 8,050,411 – – – – – – – – – – –
East West Bank CD 12/26/22 12,066,396 – – – – – – – – – – – –
R Bank CD 12/31/22 1,007,557 1,007,557 – – – – – – – – – – –
East West Bank CD 01/09/23 5,025,900 5,025,900 – – – – – – – – – – –
East West Bank CD 01/20/23 10,035,553 10,035,553 – – – – – – – – – – –
Alliance Bank CD 02/02/23 4,000,000 – – – – – – – – – – – –
Texas Capital Bank CD 02/04/23 7,768,451 – – – – – – – – – – – –
East West Bank CD 02/07/23 5,890,623 – – – – – – – – – – – –
East West Bank CD 02/08/23 8,042,865 8,042,865 – – – – – – – – – – –
East West Bank CD 02/15/23 4,021,211 – – – – – – – – – – – –
Bank OZK CD 02/23/23 4,208,255 4,208,255 – – – – – – – – – – –
East West Bank CD 02/27/23 20,142,652 20,142,652 – – – – – – – – – – –
Veritex Community Bank CD 03/09/23 4,007,206 4,007,206 – – – – – – – – – – –
East West Bank CD 03/14/23 15,095,293 15,095,293 – – – – – – – – – – –
T-Bill 03/16/23 491,998 – – – – – – – – – – – –
T-Bill 03/16/23 25,633,091 – – – – – – – – – – – –
R Bank CD 03/23/23 4,503,330 – – – – – – – – – – – –
East West Bank CD 03/27/23 25,168,439 – – – – – – – – – – – –
Prosperity Bank CD 04/24/23 5,014,211 5,014,211 – – – – – – – – – – –
Prosperity Bank CD 05/01/23 5,013,387 5,013,387 – – – – – – – – – – –
Alliance Bank CD 05/02/23 4,000,000 – – – – – – – – – – – –
Texas Capital Bank CD 05/04/23 1,253,082 – – – – – – – – – – – –
East West Bank CD 05/10/23 3,021,724 – – – – – – – – 3,021,724 – – –
Bank OZK CD 06/12/23 5,023,884 5,023,884 – – – – – – – – – – –
East West Bank CD 06/16/23 15,132,051 15,132,051 – – – – – – – – – – –
Texas Capital Bank CD 06/16/23 5,000,000 5,000,000 – – – – – – – – – – –
East West Bank CD 06/20/23 2,523,090 – – – – – – – – – – – –
FHLB 06/29/23 9,709,489 9,709,489 – – – – – – – – – – –
R Bank CD 06/30/23 1,009,182 1,009,182 – – – – – – – – – – –
Alliance Bank CD 07/01/23 4,031,255 4,031,255 – – – – – – – – – – –
East West Bank CD 08/01/23 2,016,185 – – – – – – – – – – – –
Alliance Bank CD 08/02/23 1,000,000 – – – – – – – – – – – –
Bank OZK CD 08/14/23 5,008,794 5,008,794 – – – – – – – – – – –
Texas Capital Bank CD 08/24/23 2,507,016 2,507,016 – – – – – – – – – – –
FHLB 09/13/23 13,339,436 – – – – – – – – – – – –
FFCB 09/22/23 894,020 – – – – – – – – – – – –
Veritex Community Bank CD 09/25/23 10,025,029 10,025,029 – – – – – – – – – – –
Bank OZK CD 10/09/23 5,009,232 5,009,232 – – – – – – – – – – –
Bank OZK CD 11/13/23 10,025,098 10,025,098 – – – – – – – – – – –
Southside Bank CD 02/02/24 10,000,000 – – – – – – – – – – – –
Totals 731,043,243$ 280,608,602$ 452,616$ 2,934,215$ 138,208$ 1,528,939$ 1,541,884$ 922,302$ 1,067,755$ 10,863,622$ 57,072$ 368,747$ 1,728,899$
September 30, 2022
Book Value
City of Georgetown Valley View Consulting, L.L.C.1456
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
Wells Fargo Bank Cash
NexBank MMA
TexPool
TexSTAR
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
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
Alliance Bank CD 02/02/23
Texas Capital Bank CD 02/04/23
East West Bank CD 02/07/23
East West Bank CD 02/08/23
East West Bank CD 02/15/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
T-Bill 03/16/23
T-Bill 03/16/23
R Bank CD 03/23/23
East West Bank CD 03/27/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Alliance Bank CD 05/02/23
Texas Capital Bank CD 05/04/23
East West Bank CD 05/10/23
Bank OZK CD 06/12/23
East West Bank CD 06/16/23
Texas Capital Bank CD 06/16/23
East West Bank CD 06/20/23
FHLB 06/29/23
R Bank CD 06/30/23
Alliance Bank CD 07/01/23
East West Bank CD 08/01/23
Alliance Bank CD 08/02/23
Bank OZK CD 08/14/23
Texas Capital Bank CD 08/24/23
FHLB 09/13/23
FFCB 09/22/23
Veritex Community Bank CD 09/25/23
Bank OZK CD 10/09/23
Bank OZK CD 11/13/23
Southside Bank CD 02/02/24
Totals
September 30, 2022
Book Value
(Continued)
2019 CO-
Streets/
Facilities/
Equip
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
City - 2021 CO
Airport
City - 2021 CO
Fac/Equip/ Parks
City - 2021
GO Parks
City - 2021
GO Roads
City - 2021A
CO Electric
City - 2021A
CO Water/WW
City - 2021A
GO Roads
–$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
6,190,928 2,760,351 601,729 299,230 4,441,871 508,869 3,789,637 704,578 3,718,059 892,487 4,776,393 746,628 9,815,423 10,970,022
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – 10,018,428
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – 4,021,211 – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – 2,501,850 – – – – 2,001,480
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – 2,523,090 –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – 2,016,185 – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
6,190,928$ 2,760,351$ 601,729$ 299,230$ 6,458,056$ 508,869$ 3,789,637$ 704,578$ 10,241,120$ 892,487$ 4,776,393$ 746,628$ 12,338,513$ 22,989,929$
City of Georgetown Valley View Consulting, L.L.C.1557
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
Wells Fargo Bank Cash
NexBank MMA
TexPool
TexSTAR
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
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
Alliance Bank CD 02/02/23
Texas Capital Bank CD 02/04/23
East West Bank CD 02/07/23
East West Bank CD 02/08/23
East West Bank CD 02/15/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
T-Bill 03/16/23
T-Bill 03/16/23
R Bank CD 03/23/23
East West Bank CD 03/27/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Alliance Bank CD 05/02/23
Texas Capital Bank CD 05/04/23
East West Bank CD 05/10/23
Bank OZK CD 06/12/23
East West Bank CD 06/16/23
Texas Capital Bank CD 06/16/23
East West Bank CD 06/20/23
FHLB 06/29/23
R Bank CD 06/30/23
Alliance Bank CD 07/01/23
East West Bank CD 08/01/23
Alliance Bank CD 08/02/23
Bank OZK CD 08/14/23
Texas Capital Bank CD 08/24/23
FHLB 09/13/23
FFCB 09/22/23
Veritex Community Bank CD 09/25/23
Bank OZK CD 10/09/23
Bank OZK CD 11/13/23
Southside Bank CD 02/02/24
Totals
September 30, 2022
Book Value
(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
City - Impact
Fees - Water
City - Impact
Fees - WW
City - Limited
Tax Note,
Series 2022
–$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
502,911 2,820,758 11,099 630,834 14,035,128 9,707,212 169,195,999 7,915,225 35,202,665 – 4,004,568
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – 12,066,396 –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – 4,000,000 – – – – – – –
– – – – 7,768,451 – – – – –
– – – – – 5,890,623 – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – 491,998 – – – – – – –
– – – – – – 25,633,091 – – – –
– – – – – – – – – – –
– – – – – – – – 25,168,439 – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – 4,000,000 – – – – – –
– – – – 1,253,082 – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– 1,000,000 – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – 13,339,436 – – – – – –
– – – – – 894,020 – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – 10,000,000 – – – –
502,911$ 3,820,758$ 503,097$ 4,630,834$ 40,396,097$ 16,491,855$ 204,829,090$ 7,915,225$ 60,371,104$ 12,066,396$ 4,004,568$
City of Georgetown Valley View Consulting, L.L.C.1658
City - Allocation
September 30, 2022
Market Value Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 GO-
Roads
2015 Revenue
Water WW
2016 GO-
Roads
Garey Park
Donation
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Roads
JPMorgan Chase Cash 12,506,553$ 12,506,553$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,470 434,470 – – – – – – – – – – –
Veritex Community Bank MMA 3,238,147 3,238,147 – – – – – – – – – – –
Wells Fargo Bank Cash 16,727,590 16,727,590 – – – – – – – – – – –
NexBank MMA 12,488,723 12,488,723 – – – – – – – – – – –
TexPool 31,811,436 31,811,436 – – – – – – – – – – –
TexSTAR 341,500,283 28,675,146 452,616 2,934,215 138,208 1,528,939 1,541,884 922,302 1,067,755 7,841,897 57,072 368,747 1,728,899
Independent Bank CD 10/18/22 2,562,534 2,562,534 – – – – – – – – – – –
Prosperity Bank CD 10/24/22 5,014,211 5,014,211 – – – – – – – – – – –
East West Bank CD 11/15/22 10,018,428 – – – – – – – – – – – –
Prosperity Bank CD 11/17/22 2,014,712 2,014,712 – – – – – – – – – – –
Prosperity Bank CD 11/23/22 2,003,257 2,003,257 – – – – – – – – – – –
Prosperity Bank CD 12/21/22 5,007,505 5,007,505 – – – – – – – – – – –
Alliance Bank CD 12/24/22 8,050,411 8,050,411 – – – – – – – – – – –
East West Bank CD 12/26/22 12,066,396 – – – – – – – – – – – –
R Bank CD 12/31/22 1,007,557 1,007,557 – – – – – – – – – – –
East West Bank CD 01/09/23 5,025,900 5,025,900 – – – – – – – – – – –
East West Bank CD 01/20/23 10,035,553 10,035,553 – – – – – – – – – – –
Alliance Bank CD 02/02/23 4,000,000 – – – – – – – – – – – –
Texas Capital Bank CD 02/04/23 7,768,451 – – – – – – – – – – – –
East West Bank CD 02/07/23 5,890,623 – – – – – – – – – – – –
East West Bank CD 02/08/23 8,042,865 8,042,865 – – – – – – – – – – –
East West Bank CD 02/15/23 4,021,211 – – – – – – – – – – – –
Bank OZK CD 02/23/23 4,208,255 4,208,255 – – – – – – – – – – –
East West Bank CD 02/27/23 20,142,652 20,142,652 – – – – – – – – – – –
Veritex Community Bank CD 03/09/23 4,007,206 4,007,206 – – – – – – – – – – –
East West Bank CD 03/14/23 15,095,293 15,095,293 – – – – – – – – – – –
T-Bill 03/16/23 491,638 – – – – – – – – – – – –
T-Bill 03/16/23 25,614,354 – – – – – – – – – – – –
R Bank CD 03/23/23 4,503,330 – – – – – – – – – – – –
East West Bank CD 03/27/23 25,168,439 – – – – – – – – – – – –
Prosperity Bank CD 04/24/23 5,014,211 5,014,211 – – – – – – – – – – –
Prosperity Bank CD 05/01/23 5,013,387 5,013,387 – – – – – – – – – – –
Alliance Bank CD 05/02/23 4,000,000 – – – – – – – – – – – –
Texas Capital Bank CD 05/04/23 1,253,082 – – – – – – – – – – – –
East West Bank CD 05/10/23 3,021,724 – – – – – – – – 3,021,724 – – –
Bank OZK CD 06/12/23 5,023,884 5,023,884 – – – – – – – – – – –
East West Bank CD 06/16/23 2,523,090 – – – – – – – – – – – –
Texas Capital Bank CD 06/16/23 5,000,000 5,000,000 – – – – – – – – – – –
East West Bank CD 06/20/23 15,132,051 15,132,051 – – – – – – – – – – –
FHLB 06/29/23 9,716,191 9,716,191 – – – – – – – – – – –
R Bank CD 06/30/23 1,009,182 1,009,182 – – – – – – – – – – –
Alliance Bank CD 07/01/23 4,031,255 4,031,255 – – – – – – – – – – –
East West Bank CD 08/01/23 2,016,185 – – – – – – – – – – – –
Alliance Bank CD 08/02/23 1,000,000 – – – – – – – – – – – –
Bank OZK CD 08/14/23 5,008,794 5,008,794 – – – – – – – – – – –
Texas Capital Bank CD 08/24/23 2,507,016 2,507,016 – – – – – – – – – – –
FHLB 09/13/23 13,271,236 – – – – – – – – – – – –
FFCB 09/22/23 889,114 – – – – – – – – – – – –
Veritex Community Bank CD 09/25/23 10,025,029 10,025,029 – – – – – – – – – – –
Bank OZK CD 10/09/23 5,009,232 5,009,232 – – – – – – – – – – –
Bank OZK CD 11/13/23 10,025,098 10,025,098 – – – – – – – – – – –
Southside Bank CD 02/02/24 10,000,000 – – – – – – – – – – – –
Totals 730,957,743$ 280,615,304$ 452,616$ 2,934,215$ 138,208$ 1,528,939$ 1,541,884$ 922,302$ 1,067,755$ 10,863,622$ 57,072$ 368,747$ 1,728,899$
City of Georgetown Valley View Consulting, L.L.C.1759
City - Allocation
September 30, 2022
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
Wells Fargo Bank Cash
NexBank MMA
TexPool
TexSTAR
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
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
Alliance Bank CD 02/02/23
Texas Capital Bank CD 02/04/23
East West Bank CD 02/07/23
East West Bank CD 02/08/23
East West Bank CD 02/15/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
T-Bill 03/16/23
T-Bill 03/16/23
R Bank CD 03/23/23
East West Bank CD 03/27/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Alliance Bank CD 05/02/23
Texas Capital Bank CD 05/04/23
East West Bank CD 05/10/23
Bank OZK CD 06/12/23
East West Bank CD 06/16/23
Texas Capital Bank CD 06/16/23
East West Bank CD 06/20/23
FHLB 06/29/23
R Bank CD 06/30/23
Alliance Bank CD 07/01/23
East West Bank CD 08/01/23
Alliance Bank CD 08/02/23
Bank OZK CD 08/14/23
Texas Capital Bank CD 08/24/23
FHLB 09/13/23
FFCB 09/22/23
Veritex Community Bank CD 09/25/23
Bank OZK CD 10/09/23
Bank OZK CD 11/13/23
Southside Bank CD 02/02/24
Totals
(Continued)
2019 CO-
Streets/
Facilities/
Equip
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
City - 2021 CO
Airport
City - 2021 CO
Fac/Equip/ Parks
City - 2021
GO Parks
City - 2021
GO Roads
City - 2021A
CO Electric
City - 2021A
CO Water/WW
City - 2021A
GO Roads
–$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
6,190,928 2,760,351 601,729 299,230 4,441,871 508,869 3,789,637 704,578 3,718,059 892,487 4,776,393 746,628 9,815,423 10,970,022
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – 10,018,428
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – 4,021,211 – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – 2,501,850 – – – – 2,001,480
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – 2,523,090 –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – 2,016,185 – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
– – – – – – – – – – – – – –
6,190,928$ 2,760,351$ 601,729$ 299,230$ 6,458,056$ 508,869$ 3,789,637$ 704,578$ 10,241,120$ 892,487$ 4,776,393$ 746,628$ 12,338,513$ 22,989,929$
City of Georgetown Valley View Consulting, L.L.C.1860
City - Allocation
September 30, 2022
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
Wells Fargo Bank Cash
NexBank MMA
TexPool
TexSTAR
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
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
Alliance Bank CD 02/02/23
Texas Capital Bank CD 02/04/23
East West Bank CD 02/07/23
East West Bank CD 02/08/23
East West Bank CD 02/15/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
T-Bill 03/16/23
T-Bill 03/16/23
R Bank CD 03/23/23
East West Bank CD 03/27/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Alliance Bank CD 05/02/23
Texas Capital Bank CD 05/04/23
East West Bank CD 05/10/23
Bank OZK CD 06/12/23
East West Bank CD 06/16/23
Texas Capital Bank CD 06/16/23
East West Bank CD 06/20/23
FHLB 06/29/23
R Bank CD 06/30/23
Alliance Bank CD 07/01/23
East West Bank CD 08/01/23
Alliance Bank CD 08/02/23
Bank OZK CD 08/14/23
Texas Capital Bank CD 08/24/23
FHLB 09/13/23
FFCB 09/22/23
Veritex Community Bank CD 09/25/23
Bank OZK CD 10/09/23
Bank OZK CD 11/13/23
Southside Bank CD 02/02/24
Totals
(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
City - Impact
Fees - Water
City - Impact
Fees - WW
City - Limited
Tax Note,
Series 2022
–$ –$ –$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
502,911 2,820,758 11,099 630,834 14,035,128 9,707,212 169,195,999 7,915,225 35,202,665 – 4,004,568
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – 12,066,396 –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – 4,000,000 – – – – – – –
– – – – 7,768,451 – – – – – –
– – – – – 5,890,623 – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – 491,638 – – – – – – – –
– – – – – – 25,614,354 – – – –
– – – – – – – – – – –
– – – – – – – – 25,168,439 – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – 4,000,000 – – – – – –
– – – – 1,253,082 – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– 1,000,000 – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – 13,271,236 – – – – – –
– – – – – 889,114 – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – – – – – –
– – – – – – 10,000,000 – – – –
502,911$ 3,820,758$ 502,738$ 4,630,834$ 40,327,897$ 16,486,949$ 204,810,353$ 7,915,225$ 60,371,104$ 12,066,396$ 4,004,568$
City of Georgetown Valley View Consulting, L.L.C.1961
________________________________________________________________________
Leigh Wallace Nathan Parras
Finance Director Assistant Finance Director
________________________________________________________________________
Karrie Pursley Elaine Wilson
Treasurer Assistant Finance Director
Georgetown Economic Development Corporation (GEDCO)
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
December 31, 2022
Prepared by
Valley View Consulting, L.L.C.
The investment portfolio of the Georgetown Economic Development Corporation (GEDCO) is in compliance with
the Texas Public Funds Investment Act and the Investment Policy and Strategies.
Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or
completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from
sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective of
current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total return
yields and do not account for investment advisor fees.
62
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
MMA 2,147,122$ 2,147,122$ 2,166,883$ 2,166,883$ 4.17%
Pools 6,586,175 6,586,175 7,698,466 7,698,466 4.01%
Certificates of Deposit – – – – 0.00%
8,733,297$ 8,733,297$ 9,865,349$ 9,865,349$ 4.05%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 4.05%Total Portfolio 4.05%
Rolling Three Month Treasury 4.19%Rolling Three Month Treasury 4.19%
Rolling Six Month Treasury 3.90%Rolling Six Month Treasury 3.90%
TexPool 3.98%TexPool 3.98%
Interest income provided in separate report.
September 30, 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.
December 31, 2022
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.163
Economic Overview12/31/2022The Federal Open Market Committee (FOMC) raised the Fed Funds target range 0.50% to 4.25% - 4.50% December 14th (Effective Fed Funds are trading +/-4.33%). A 0.25% increase is projected February 1st. Third Quarter GDP jumped to 3.2% in the final number. December Non-Farm Payroll added 223k new jobs with the Three Month Average declining to 247k. Crude oil continues moderating at +/-$75 per barrel. The Stock Markets drifted between +/-15% to +/-19% below the 2021 peak. The yield curve is fully negatively sloped (3 months to 10 years, with peak yield at 6 months) and continues to indicate lower future interest rates. Inflation remained well over the FOMC 2% target (Core PCE +/-5% and CPI +/-6%). International challenges add to economic uncertainty. 02505007501,0001,2501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,0004,2504,5004,7505,0005,250S&P 5000.000.501.001.502.002.503.003.504.004.505.005.50US Treasury Historical Yields - Since Nov 2015Six Month T-BillTwo Year T-NoteTen Year T-Note0.001.002.003.004.005.006.00Treasury Yield CurvesDecember 31, 2021September 30, 2022December 31, 20220.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.264
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 4.17%01/01/23 12/31/22 2,166,883$ 2,166,883$ 1.00 2,166,883$ 1 4.17%
TexasDAILY AAAm 4.13%01/01/23 12/31/22 2,160,146 2,160,146 1.00 2,160,146 1 4.13%
TexSTAR AAAm 3.97%01/01/23 12/31/22 5,538,320 5,538,320 1.00 5,538,320 1 3.97%
9,865,349$ 9,865,349$ 9,865,349$ 1 4.05%
(1)(2)
December 31, 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.365
MMA 22%Pools 78%Certificates of Deposit 0%GEDCO PORTFOLIO COMPOSITION $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,0003/31/2022 6/30/2022 9/30/2022 12/31/2022GEDCO PORTFOLIO BALANCES CD TexasDAILY TexSTAR Money MarketGeorgetown Economic Development Corporation (GEDCO) Valley View Consulting, L.L.C.466
Book & Market Value Comparison
Issuer/Description Yield Maturity
Date
Book Value
09/30/22 Increases Decreases Book Value
12/31/22
Market Value
09/30/22
Change in
Market Value
Market Value
12/31/22
Veritex Bank MMA 4.17%01/01/23 2,147,122$ 19,761$ –$ 2,166,883$ 2,147,122$ 19,761$ 2,166,883$
TexasDAILY 4.13%01/01/23 2,140,620 19,526 – 2,160,146 2,140,620 19,526 2,160,146
TexSTAR 3.97%01/01/23 4,445,555 1,092,765 – 5,538,320 4,445,555 1,092,765 5,538,320
TOTAL / AVERAGE 4.05%8,733,297$ 1,132,052$ –$ 9,865,349$ 8,733,297$ 1,132,052$ 9,865,349$
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.567
Georgetown Transportation Enhancement Corporation (GTEC)
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
December 31, 2022
Prepared byValley View Consulting, L.L.C.
________________________________________________________________________
Leigh Wallace Nathan Parras
Finance Director Assistant Finance Director
________________________________________________________________________
Karrie Pursley Elaine Wilson
Treasurer
The investment portfolio of the Georgetown Transportation Enhancement Corporation (GTEC) is in compliance
with the Texas Public Funds Investment Act and the Investment Policy and Strategies.
Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or
completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from
sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective
of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total
return yields and do not account for investment advisor fees.
68
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Pools/MMAs 33,113,125$ 33,113,125$ 33,147,006$ 33,147,006$ 3.99%
CDs/Securities 5,018,515 5,018,515 9,921,428 9,922,663 4.02%Totals 38,131,640$ 38,131,640$ 43,068,435$ 43,069,669$ 4.00%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 4.00%Total Portfolio 4.00%
Rolling Three Month Treasury 4.19%Rolling Three Month Treasury 4.19%
Rolling Six Month Treasury 3.90%Rolling Six Month Treasury 3.90%
TexPool 3.98%TexPool 3.98%
Interest data provided in separate report.
September 30, 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.
December 31, 2022
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.169
Economic Overview12/31/2022The Federal Open Market Committee (FOMC) raised the Fed Funds target range 0.50% to 4.25% - 4.50% December 14th (Effective Fed Funds are trading +/-4.33%). A 0.25% increase is projected February 1st. Third Quarter GDP jumped to 3.2% in the final number. December Non-Farm Payroll added 223k new jobs with the Three Month Average declining to 247k. Crude oil continues moderating at +/-$75 per barrel. The Stock Markets drifted between +/-15% to +/-19% below the 2021 peak. The yield curve is fully negatively sloped (3 months to 10 years, with peak yield at 6 months) and continues to indicate lower future interest rates. Inflation remained well over the FOMC 2% target (Core PCE +/-5% and CPI +/-6%). International challenges add to economic uncertainty. 02505007501,0001,2501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,0004,2504,5004,7505,0005,250S&P 5000.000.501.001.502.002.503.003.504.004.505.005.50US Treasury Historical Yields - Since Nov 2015Six Month T-BillTwo Year T-NoteTen Year T-Note0.001.002.003.004.005.006.00Treasury Yield CurvesDecember 31, 2021September 30, 2022December 31, 20220.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.270
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 3.98%01/01/23 12/31/22 21,129,290$ 21,129,290$ 1.00 21,129,290$ 1 3.98%
TexSTAR AAAm 3.97%01/01/23 12/31/22 9,283,515 9,283,515 1.00 9,283,515 1 3.97%
Veritex Bank MMA 4.17%01/01/23 12/31/22 2,734,202 2,734,202 1.00 2,734,202 1 4.17%
East West Bank CD 3.12%2/7/2023 08/11/22 2,024,596 2,024,596 100.00 2,024,596 38 3.17%
East West Bank CD 3.21%05/25/23 08/25/22 3,034,227 3,034,227 100.00 3,034,227 145 3.26%
FAMC 0.22%08/11/23 11/10/22 5,000,000 4,862,605 97.28 4,863,840 223 4.84%
TOTALS 43,205,830$ 43,068,435$ 43,069,669$ 38 4.00%
(1)(2)
December 31, 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.371
Pools/MMAs 77%
CDs/Securities 23%
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
$40,000,000
$45,000,000
$50,000,000
3/31/2022 6/30/2022 9/30/2022 12/31/2022
GTEC PORTFOLIO BALANCES
CD
TexPool
TexSTAR
Money Market
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.472
Book & Market Value Comparison
Issuer/Description Yield Maturity
Date
Book Value
09/30/22 Increases Decreases Book Value
12/31/22
Market Value
09/30/22
Change in
Market Value
Market Value
12/31/22
TexPool 3.98%01/01/23 21,549,395$ –$ (420,105)$ 21,129,290$ 21,549,395$ (420,105)$ 21,129,290$
TexSTAR 3.97%01/01/23 8,854,459 429,056 – 9,283,515 8,854,459 429,056 9,283,515
Veritex Bank MMA 4.17%01/01/23 2,709,271 24,931 – 2,734,202 2,709,271 24,931 2,734,202
East West Bank CD 3.17%2/7/2023 2,008,738 15,859 – 2,024,596 2,008,738 15,859 2,024,596
East West Bank CD 3.26%05/25/23 3,009,777 24,450 – 3,034,227 3,009,777 24,450 3,034,227
FAMC 4.84%08/11/23 – 4,862,605 – 4,862,605 – 4,863,840 4,863,840
TOTAL / AVERAGE 4.00%38,131,640$ 5,356,900$ (420,105)$ 43,068,435$ 38,131,640$ 4,938,029$ 43,069,669$
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.573
Department Federal Grantor Pass-Through Agency Identifying Number COG Name/Purpose YTD Expenditures YTD Revenue Recognized
Arts & Culture Texas Commission on the Arts FY22 Performance Grant - Sue Foley 2,250 2,250
Emergency Management US Dept. of the Treasury American Rescue Plan Act
SLFRF Funding
25,100 25,100
Library N/A St. David's Foundation St. David's Grant - 650 20,000
Planning US Department of Housing & Urban Development Williamson County CDBG 21st St Infrastructure - -
Planning US Department of Housing & Urban Development Williamson County CDBG Home Repair (FY21) 4,301 4,301
Police US. Department of Justice N/A TX2460200 Equitable Sharing Agreement - -
Police US. Department of Treasury N/A TX2460200 Equitable Sharing Agreement - -
Public Works Dept. of Transportation /Federal Highway
Administration
Texas Department of
Transportation
CSJ 0914-05-201 Highway Planning &
Construction (Lakeway &
Williams Drive)
293,149 293,149
Electric Dept. of Transportation /Federal Highway
Administration
Texas Department of
Transportation
CSJ 2211-02-019 FM 1460 Road Widening
(ROW Acquisition)*
- 255,775
*Expenses were incurred in FY2014-15, but reported here since TXDOT has now approved for reimbursement.
Division Grantor COG Name/Purpose Status
Reviewed By: Elaine Wilson
CITY OF GEORGETOWN
Grant/Federal Funding Report
as of December 31, 2022
Active
Applications Pending Award
74
City of Georgetown Capital Projects Life to Date Project Budget Total Spend Remaining Budget Percent Remaining
CDBG
PRJ000003 17th Street 193,000 175,137 17,863 9%
PRJ000248 21st W/WW offsite CDBG 97,000 44,882 52,118 54%
CDBG Total 290,000 220,019 69,981 24%
Electric
PRJ000022 Consultant Engineering 271,352 100,825 170,527 63%
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 9,267,103 7,209,710 2,057,393 22%
PRJ000073 Power Quality Improvements 50,000 - 50,000 100%
PRJ000147 Sectionalization Improvements 1,787,531 706,891 1,080,640 60%
PRJ000175 I-35 Mobility Project TxDot 291,544 280,864 10,680 4%
PRJ000189 Ronald Reagan - Glasscock Feeder Extension along Hwy 195 -Phase I 560,000 303,833 256,167 46%
PRJ000192 Ronald Reagan - Glasscock Feeder extension along Hwy 195 - Phase II 591,250 287,020 304,230 51%
PRJ000195 Downtown Overhead Rehab 2,400,000 39,610 2,360,390 98%
PRJ000221 Titan-Aviation Dr to IH35 Infrastructure Addition 1,834,634 1,269,528 565,106 31%
PRJ000225 Chapel Hill, WS-11139 (GEO-45-C.3)558,411 453,110 105,302 19%
PRJ000226 Wolf Ranch West - Section 1AG & 1BG 635,363 500,769 134,594 21%
PRJ000227 Ascend Westinghouse Apartments 444,598 408,915 35,683 8%
PRJ000229 Sun City NH 76 WS-11188 (GEO-18.2-N.51)288,163 205,450 82,713 29%
PRJ000230 Sun City NH 78 296,400 118,796 177,604 60%
PRJ000231 Georgetown Titan Development 1 & 2 140,428 118,222 22,206 16%
PRJ000232 Texas Outdoor Power Building 1 91,414 64,415 26,999 30%
PRJ000234 Summit at Westinghouse Self-Storage 223,812 225,735 (1,924) -1%
PRJ000236 Medcore (Georgetown) Senior Living 330,770 228,423 102,347 31%
PRJ000238 The Oscar at Georgetown 366,351 225,463 140,888 38%
PRJ000239 Wolf Ranch West - Section 3 - Phase 2 865,561 384,889 480,672 56%
PRJ000242 Allora North Georgetown 557,422 335,058 222,364 40%
PRJ000243 Fairfield Inn - WS11346 131,340 43,084 88,256 67%
PRJ000245 Morgan Mays Street Apartments 452,508 321,670 130,838 29%
PRJ000246 Vida Apartments 198,248 181,785 16,464 8%
PRJ000247 Georgetown (Longhorn) Travel Center Rev 193,845 129,463 64,381 33%
PRJ000250 Georgetown Infiniti 135,633 58,275 77,357 57%
PRJ000269 Substation Feeder Exits and Extensions 250,000 - 250,000 100%
PRJ000270 System Improvements - Power Quality 661,650 61,650 600,000 91%
PRJ000271 System Improvements - Capacity Upgrades 8,063,593 104,950 7,958,643 99%
PRJ000272 Wolf Lakes 566,109 556,287 9,823 2%
PRJ000273 The Grove II Townhomes 108,924 43,683 65,241 60%
PRJ000282 ANB Systems - Interconnection Service Portal 80,000 32,963 47,037 59%
PRJ000283 Partners Software and Implementation 120,864 120,864 - 0%
PRJ000284 Woodgate Development 195,933 136,194 59,739 30%
PRJ000285 Titan NorthPark 35 - Building 3 121,842 81,364 40,477 33%
PRJ000286 Wolf Ranch West - Section 2G 489,900 522,413 (32,513) -7%
PRJ000287 Gateway 35 - Building 1 266,676 217,899 48,777 18%
PRJ000288 Round Rock 2 Apartments 509,917 614,445 (104,528) -20%
PRJ000289 Wolf Lakes Offsite Utility 307,445 158,999 148,446 48%
PRJ000290 Windmill Hill Blue Ridge Drive Extension 292,696 166,472 126,224 43%
PRJ000291 Chick-Fil-A Expansion at WR SC 72,396 61,448 10,949 15%
PRJ000292 Aviation Drive Extension - Lift Station 116,456 60,383 56,073 48%
PRJ000296 Sun City NH10 - Phase B 122,543 121,331 1,212 1%
PRJ000299 Wolf Lakes Apartments - Hines Tract 446,777 271,202 175,575 39%
PRJ000300 Wolf Lakes Bella Lago Underground Extension 328,654 346,675 (18,021) -5%
PRJ000301 Titan NorthPark 35 - Building 5 166,073 120,321 45,752 28%
PRJ000302 Somerset Hills - Phase A-B 58,367 58,367 - 0%
PRJ000303 Westinghouse Retail Center at Windmill Hill 69,152 42,798 26,354 38%
PRJ000305 Medical Towers at Georgetown 96,487 68,872 27,614 29%
PRJ000306 Toolman Business Park 168,802 228,625 (59,823) -35%
PRJ000307 Sonrisa MOB, WS-11306, MPN-21-19 200,110 79,207 120,903 60%
PRJ000308 Sun City Neighborhood 77 306,196 246,166 60,030 20%
PRJ000309 Sun City NH 80 166,562 110,947 55,615 33%
PRJ000312 Dutch Bros. Coffee at 1309 W. University 38,354 23,682 14,672 38%
PRJ000313 Rivery Crossing (WS# 11264)156,254 72,490 83,764 54%
PRJ000314 Hewlett Volkswagen 2022 Remodel (MPN# 21-106)43,767 9,395 34,372 79%
PRJ000315 Hope Ranch (MPN# 21-104)118,282 67,139 51,143 43%
PRJ000316 Wolf Lakes HEB (MPN# 21-95)219,543 246,466 (26,923) -12%
PRJ000317 Blue Springs Business Park (MPN# 21-108)474,203 346,358 127,846 27%
PRJ000318 Costco 270,223 215,302 54,921 20%
PRJ000319 Georgetown Logistics (MPN# 21-87)453,870 402,606 51,264 11%
PRJ000320 Amazon Sortation Facility 16,223 16,223 - 0%
PRJ000321 Wolf Lakes - Bella June Extension 201,850 170,065 31,785 16%
PRJ000329 Sun City NH 79 (MPN# 22-14)149,174 127,516 21,658 15%
PRJ000330 2021 Airport Road Upgrade 484,281 - 484,281 100%
PRJ000331 Quail Valley (Phase 1) URD Voltage Conversion 240,344 138,185 102,159 43%
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 72,620 42,092 37%
PRJ000340 Cellink (Gateway35 - Building 1) (MPN# 22-37)1,234,057 730,123 503,934 41%
PRJ000341 Gateway35 Building 3 (MPN# 22-27)276,306 199,841 76,465 28%
PRJ000342 Gateway35 Building 2 (MPN# 22-28)152,469 107,597 44,873 29%
PRJ000343 Gantt Serenada Subdivision (MPN# 22-44)25,414 18,521 6,892 27%
PRJ000345 Baylor Scott & White Expansion 147,236 84,536 62,700 43%
PRJ000346 Novak Chandra Multifamily - Wolf Lakes Village 536,146 40,395 495,751 92%
PRJ000347 Titan NorthPark 35 – Building 6 (MPN# 22-47)377,275 302,233 75,041 20%
PRJ000348 The Summit at Westinghouse (MPN# 22-26)358,809 20,177 338,631 94%
PRJ000349 System Improvements - Operation Technology (SCADA/AMI/Network/Utility Software)1,000,000 63,965 936,035 94%
PRJ000350 System Improvements - Ordinary Replacements 1,000,000 110,957 889,043 89%
PRJ000351 Sun City Neighborhood 66 & 92 - Phase 1 (MPN#22-39)717,139 271,877 445,262 62%
PRJ000360 Windmill Hill – Commerce Blvd Expansion 81,250 63,153 18,097 22%
PRJ000365 Wellhouse Business Park 22-61 243,092 153,766 89,326 37%
75
City of Georgetown Capital Projects Life to Date Project Budget Total Spend Remaining Budget Percent Remaining
PRJ000368 WILCO Children’s Advocacy Center 2022 Addition (MPN# 22-52)47,927 21,001 26,926 56%
PRJ000381 Sun City NH 66 & 92 (MPN#22-39)239,213 80,236 158,977 66%
PRJ000386 Rock Springs Hospital Expansion 2022 (MPN# 22-81)197,284 145,899 51,385 26%
PRJ000390 Georgetown ISD - Future Ready Learning Complex (MPN# 22-50)424,557 322,643 101,915 24%
PRJ000391 Longhorn Junction Logistics Center - ATS Option (MPN# 22-40)815,968 645,146 170,822 21%
PRJ000392 Chapel Hill Phase II 514,996 220,186 294,811 57%
PRJ000393 Georgetown Patio Homes - West Phase (MPN# 22 - 80)681,843 - 681,843 100%
PRJ000394 Home2Suites 94,384 - 94,384 100%
PRJ000395 Chance Leigh Custom Homes 4,923 3,369 1,554 32%
PRJ000397 Joseph Stephens Smooth Current Electric 4,312 3,629 683 16%
PRJ000398 Loram Technologies, Inc (MPN#22-60)354,037 185,329 168,708 48%
PRJ000400 95 DB Wood Rd Traffic Signal 4,050 - 4,050 100%
PRJ000401 1402, 1406, 1410 Country Club Road 31,663 - 31,663 100%
PRJ000402 KL Electric - 3707 Brangus Road 3,283 3,921 (639) -19%
PRJ000407 Woodfield Preserve - Phase 1 (MPN# 22-83)542,498 27,009 515,489 95%
PRJ000408 Fiber Support Hut in Sun City 3,396 - 3,396 100%
PRJ000415 Titan Building 8 1,044,482 - 1,044,482 100%
PRJ000418 Sun City NH65 288,395 - 288,395 100%
PRJ000419 Sun City Ridge Top Well House-Partners 129,784 - 129,784 100%
PRJ000421 Grace Episcopal West Campus 67,612 - 67,612 100%
PRJ000422 Solid Waste Transfer Facility 179,406 - 179,406 100%
PRJ000423 TXDOT Williams at Lakeway 1,619 - 1,619 100%
PRJ000424 TXDOT Traffic Signal DB Wood @ SH29 4,050 - 4,050 100%
PRJ000425 D&L Printing - 552 Stadium Dr 9,003 - 9,003 100%
PRJ000427 Woodfield Preserve - Phase 7 (MPN# 22-84)539,131 - 539,131 100%
PRJ000431 KL Turner Electric 5,645 - 5,645 100%
PRJ000432 Deer Haven Retail 48,443 - 48,443 100%
PRJ000433 Westinghouse Business Park (MPN# 22-90)340,073 - 340,073 100%
PRJ000437 505 West University Ave. – Service Upgrade (MPN# 22-70)68,602 - 68,602 100%
PRJ000439 Tesla Charging Station - WR TC 66,433 - 66,433 100%
PRJ000440 System Improvements - Voltage Conversion 1,000,000 - 1,000,000 100%
Electric Total 54,704,152 24,829,224 29,874,929 55%
Environmental Services
PRJ000116 Transfer Station 11,000,000 1,095,424 9,904,576 90%
Environmental Services Total 11,000,000 1,095,424 9,904,576 90%
Finance
PRJ000038 ERP Project 6,231,654 6,071,083 160,571 3%
Finance Total 6,231,654 6,071,083 160,571 3%
Fire
PRJ000134 SCBA Replacement 1,170,000 840,934 329,066 28%
PRJ000135 Cardiac Monitors 633,517 628,258 5,258 1%
PRJ000354 EMS Stryker Stretchers 193,415 193,415 - 0%
Fire Total 1,996,931 1,662,607 334,324 17%
Fleet
PRJ000124 Radio Replacement 1,565,278 931,675 633,603 40%
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%
PRJ000355 Bond Funded Fire Vehicles - FY23 2,158,750 1,320,238 838,512 39%
PRJ000356 Bond Funded Police Vehicles - FY23 1,466,680 1,446,502 20,178 1%
PRJ000357 PRJ000357 Bond Funded Public Safety Boat 236,500 - 236,500 100%
PRJ000361 Bond Funded Stormwater Street Sweeper 357,500 348,105 9,395 3%
PRJ000366 Electric Bond Funded Vehicles - FY23 1,241,940 - 1,241,940 100%
PRJ000388 Stormwater Vehicles/Equipment - FY 22 280,000 211,147 68,853 25%
Fleet Total 11,656,648 8,317,794 3,338,854 29%
GTEC Department
PRJ000046 FM 971/ Fontana (Nw Bridge)1,209,000 1,206,390 2,610 0%
PRJ000060 Rabbit Hill Road 4,100,000 682,802 3,417,198 83%
PRJ000145 Sh29 Signal, Right Turn Lane, & Hard Median 1,595,000 410,979 1,184,021 74%
PRJ000181 Aviation Drive 10,300,000 10,167,938 132,062 1%
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%
PRJ000362 IH35/SH29 Intersection Improvements 20,000,000 - 20,000,000 100%
GTEC Department Total 41,204,984 14,168,109 27,036,875 66%
Management Services
PRJ000029 Downtown Parking Garage 291,483 142,130 149,354 51%
PRJ000033 Dtwn Landsping & Public Art 5,746 5,746 - 0%
PRJ000131 Fuel Station 1,100,000 108,388 991,613 90%
PRJ000136 GMC Remodel Phase I 560,000 625,060 (65,060) -12%
PRJ000178 Public Safety Operation and Training Center Phase II 6,000,000 5,200,421 799,579 13%
PRJ000179 Recreation Center Teen/Senior Renovation 247,979 2,540 245,439 99%
PRJ000184 Airport Maintenance Facility 1,250,000 115,900 1,134,100 91%
PRJ000191 Georgetown City Center - Festival/Public Space 5,333,036 271,741 5,061,295 95%
PRJ000223 Wayfinding Signage 275,000 90,615 184,385 67%
PRJ000252 Fire Logistics Building 2,550,000 257,000 2,293,000 90%
PRJ000337 Downtown Austin Ave Parking Garage - ARPA 7,800,000 973,150 6,826,850 88%
PRJ000338 Downtown Austin Ave Parking Garage - Bond Funded 7,507,500 100 7,507,400 100%
PRJ000352 Signature Gateway - Downtown 538,500 - 538,500 100%
PRJ000353 Fire Station 1 546,000 - 546,000 100%
PRJ000369 Bollards 60,000 - 60,000 100%
PRJ000389 Tax Note Project Management, Series 2022 4,192,801 - 4,192,801 100%
Management Services Total 38,258,046 7,792,790 30,465,256 80%
Parks
PRJ000048 Garey Park 15,346,730 15,284,927 61,804 0%
76
City of Georgetown Capital Projects Life to Date Project Budget Total Spend Remaining Budget Percent Remaining
PRJ000125 Parks Master Plan 229,998 226,871 3,127 1%
PRJ000126 Regional Trail Development 1,372,684 1,347,362 25,322 2%
PRJ000129 Ada Transition Plan 1,075,982 835,341 240,641 22%
PRJ000190 Heritage Gardens 275,860 248,153 27,707 10%
PRJ000240 South Main Plaza 339,414 435,227 (95,813) -28%
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 669,000 74,900 594,100 89%
PRJ000293 San Gabriel Park - Phase 3 7,813,870 889,476 6,924,394 89%
PRJ000322 Crystal Knoll Park 250,000 138,087 111,913 45%
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 48,400 201,600 81%
PRJ000328 Waypoint Park 200,000 14,500 185,500 93%
PRJ000358 Parks Replacement (Previously SRF)- 42,651 (42,651) 0%
PRJ000359 Parks Safety Improvements 1,057,300 - 1,057,300 100%
PRJ000364 Bark Park Pet Memorial 25,000 6,156 18,844 75%
PRJ000385 Garey Park - Phase II 1,000,000 - 1,000,000 100%
PRJ000441 Garey Park Estate 3,500,000 - 3,500,000 100%
Parks Total 48,517,337 19,754,199 28,763,138 59%
Public Works Department
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,655,771 2,024,207 55%
PRJ000139 Westinghouse - Scenic Lake Traffic Signal 600,000 343,447 256,553 43%
PRJ000140 Austin Ave Bridges 10,184,000 1,055,062 9,128,939 90%
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 2,537,551 15,462,449 86%
PRJ000202 FM 971 5,821,392 5,491,011 330,381 6%
PRJ000207 Northwest Blvd Bridge 5,527,427 11,661,236 (6,133,809) -111%
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%
PRJ000212 2021 High Performance Pavement Seal Project #2 515,698 491,261 24,437 5%
PRJ000214 Intersection Improvements (Traffic Signals)1,650,000 1,287,778 362,222 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 1,186,435 11,316,565 91%
PRJ000255 Rockride Lane 5,776,000 1,347,017 4,428,983 77%
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 2,427,907 18,735,693 89%
PRJ000267 Allocations - Intersections/Bike Lanes/Sidewalks - MB21 10,800,000 - 10,800,000 100%
PRJ000276 2023 HIPR Street Maintenance 4,000,000 578,000 3,422,000 86%
PRJ000277 Intersection Improvements - FY22 1,162,150 - 1,162,150 100%
PRJ000294 2022 HIPR 2,999,466 2,811,059 188,408 6%
PRJ000295 2022 High Performance Pavement Seal 1,245,021 1,228,609 16,412 1%
PRJ000297 Southeast Inner Loop - MB21 32,777,940 3,050,500 29,727,440 91%
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%
PRJ000332 Williams Drive (MB21)10,391,760 - 10,391,760 100%
PRJ000367 Wolf Ranch Parkway 1,000,000 - 1,000,000 100%
PRJ000382 2023 High Performance Pavement Seal 2,500,000 357,100 2,142,900 86%
PRJ000383 2023 Unscheduled Pavement Repair 1,000,000 - 1,000,000 100%
Public Works Department Total 201,581,455 70,539,119 131,042,336 65%
Stormwater
PRJ000004 18th and Hutto Drainage 164,793 8,133 156,660 95%
PRJ000024 2020 Curb & Gutter 1,055,000 720,059 334,941 32%
PRJ000104 Stormwater Infrastructure 347,000 168,506 178,495 51%
PRJ000149 Drainage Improvement/Flood Mitigation Projects 320,000 - 320,000 100%
PRJ000213 2021 Curb & Gutter Project 500,000 872,905 (372,905) -75%
PRJ000274 2022 Curb & Gutter 500,000 65,250 434,750 87%
Stormwater Total 2,886,793 1,834,852 1,051,941 36%
Water
PRJ000014 Berry Creek Inter.49,949,000 3,170,673 46,778,327 94%
PRJ000023 Cr 255 (Wd14-2)1,817,359 319,081 1,498,278 82%
PRJ000057 Lift Station Upgrade 1,073,593 326,103 747,490 70%
PRJ000059 LWTP Raw Water Intake Rehab 6,750,000 5,592,819 1,157,181 17%
PRJ000096 Shell Road Water Line 6,890,000 1,111,260 5,778,740 84%
PRJ000101 Southlake Wtp 278,000,000 195,405,759 82,594,241 30%
PRJ000119 Water Mains 643,855 463,473 180,382 28%
PRJ000150 Carriage Oaks Transmission 5,450,000 430,800 5,019,200 92%
PRJ000152 Hoover Pump Station 13,550,000 6,382,422 7,167,578 53%
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%
PRJ000157 Leander Interconnect 340,245 316,601 23,644 7%
PRJ000160 Round Rock Supply Pump Station And Elevated Storage Tank 10,500,000 6,413,874 4,086,126 39%
PRJ000161 Miscellaneous Line Upgrades 1,374,180 702,109 672,071 49%
PRJ000163 Tank Rehabilitation 4,165,036 431,916 3,733,120 90%
PRJ000165 San Gabriel WWTP Rehabilitation 18,757,307 1,634,500 17,122,807 91%
PRJ000167 San Gabriel Inter SGI -2 4,500,000 912,755 3,587,245 80%
PRJ000168 WWTP Upgrade 681,774 209,000 472,774 69%
PRJ000177 Northlake WTP Phase IV Expansion 15,094,867 14,899,372 195,495 1%
PRJ000185 Cimarron Hills Wastewater Treatment Plant Expansion 6,050,000 799,325 5,250,675 87%
77
City of Georgetown Capital Projects Life to Date Project Budget Total Spend Remaining Budget Percent Remaining
PRJ000218 EARZ Wastewater Rehabilitation Area 2 - 2019 2,559,897 2,310,949 248,948 10%
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 462,176 465,180 (3,004) -1%
PRJ000259 III Forks WWTP 37,856,283 52,200 37,804,083 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 747,017 477,983 39%
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 209,070 1,090,930 84%
PRJ000363 EARZ Combined 3,746,396 2,808,790 937,606 25%
PRJ000370 Northlands Wastewater Treatment Plant 56,000,000 - 56,000,000 100%
PRJ000371 Sunny Trail (Teravista/1460) WW Lift Station 2,200,000 - 2,200,000 100%
PRJ000372 ASR Well Development 10,000,000 - 10,000,000 100%
PRJ000373 Downtown Waterline Upgrades 2,700,000 - 2,700,000 100%
PRJ000374 Phase III Pump Design Costs and Line Assessments 2,500,000 - 2,500,000 100%
PRJ000375 Blue Ridge Waterline 3,400,000 - 3,400,000 100%
PRJ000376 SH 138 Waterline Upgrade 9,500,000 - 9,500,000 100%
PRJ000377 Southwestern & Southeast Inner Loop Waterline 1,850,000 - 1,850,000 100%
PRJ000378 Westside Service Center Building Update 150,000 - 150,000 100%
PRJ000379 Woods Pump Station Remodel 200,000 - 200,000 100%
PRJ000387 IH35 Waterline Connection 2,500,000 160,115 2,339,885 94%
Water Total 632,828,837 255,264,458 377,564,379 60%
Grand Total 1,051,156,838 411,549,678 639,607,160 61%
78