HomeMy WebLinkAboutFY 21 - 4th_Qtr_Report_FY2021_RedactedFINANCIAL REPORT AND INVESTMENT REPORT
For the Quarter Ended September 30, 2021
Table of Contents
Executive Summary .................................................................................................................................. 1-23
General Fund Schedule .......................................................................................................................... 24-25
General Fund Schedule by Cost Center .................................................................................................. 26-30
Electric Fund Schedule ................................................................................................................................ 31
Water Services Fund Schedule .................................................................................................................... 32
Joint Services Fund Schedule ....................................................................................................................... 33
Council Discretionary Fund Schedule .......................................................................................................... 34
Convention & Visitors Bureau Fund Schedule ............................................................................................. 35
Airport Fund Schedule ................................................................................................................................. 36
Stormwater Fund Schedule ......................................................................................................................... 37
Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 38
Georgetown Economic Development Corporation Fund Schedule ............................................................. 39
Quarterly Investment Report - City ........................................................................................................ 40-64
Quarterly Investment Report - GEDCO ................................................................................................... 65-71
Quarterly Investment Report - GTEC ...................................................................................................... 72-78
Grant Applications ....................................................................................................................................... 79
Capital Improvement Projects ................................................................................................................ 80-83
Long-term Commitments and Other Unfunded Liabilities ..................................................................... 84-88
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
fourth quarter of fiscal year 2021 includes the maturing, reinvesting, and new investments of financial
institution deposits (CDs), receipt of the first tranche of the 2021 mobility bond, and payment of
outstanding bonds. Interest rates continue to be low for money market accounts, Treasury bills, and
CD’s. We are seeing a decline in the number of banks responding to our investment offerings. The
decrease in interest from banks was exacerbated due to the US Treasury’s release of the billions of dollars
for the American Rescue Plan in the 3rd quarter.
The FOMC met September 21st and 22nd. Upon adjournment they announced that the Fed Funds rate
would remain unchanged at a range of 0% to 0.25% and that the program to purchase $120 billion in
Treasury/Agency assets each month to add liquidity would also remain in effect. However, the
announcement and the subsequent Press Conference clarified that the Committee discussed “tapering”
or the winding down of the amount of monthly Treasury/Agency purchases. They will gradually decrease
the amount of monthly purchases. Chair Powell went so far as to discuss a timeline for tapering and the
ultimate end of this stimulus tool. The FOMC discussed beginning the taper as soon as the next meeting
(in early November) and anticipated that the wind-down would end around mid-2022 as long as the
economy continued to recover near the current pace. The FOMC forecasts that a Fed Funds Rate increase
could come in mid-2022 followed by two more increases in 2023. The current FOMC expectation is for
the Fed Funds rate to reach 1.8% in 2024. The City will continue soliciting for the best rates to improve
both diversity and yield, while keeping in mind safety and liquidity.
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 September 30,
2021, compared to the prior quarter, is shown below for the City, as well as Georgetown Transportation
Enhancement Corporation (GTEC) and Georgetown Economic Development Corporation (GEDCO).
Included in the City portfolio are debt service, consolidated funds, and bond proceeds. The breakdown of
the City’s portfolio is consolidated at 66.5%, debt service at .5%, and bond proceeds at 33%. The City’s
portfolio had a net increase from the third quarter due to the receipt of mobility bond proceeds sold in
August. GTEC and GEDCO’s portfolios decreased from the third quarter due to principal and interest
payments made in August. CITY Book Value GTEC GEDCO
6/30/21 9/30/21 6/30/21 9/30/21 6/30/21 9/30/21
Total cash
and
investments
$345,161,582 $377,319,060 $42,427,551 $37,764,985 $11,734,129 $9,649,850
Quarter
End Average
Yield
.15% .13% .04% .03% .07% .08%
22
General Fund
Period: Sep-21 Budget Current Period
FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance
Fav/(Unfav)% of Projection
Beginning Fund Balance 21,196,610 21,196,610 - 100.00%21,196,610 - 100.00%
Revenue
40001:Property Taxes 15,976,505 (247,798) 15,893,725 (82,780) 99.48%15,996,505 (102,780) 99.36%
40002:Sales Taxes 18,576,250 6,329,769 23,895,422 5,319,172 128.63%22,924,375 971,047 104.24%
40005:Franchise Taxes 6,255,270 866,794 6,183,295 (71,975) 98.85%6,182,563 731 100.01%
40008:Other Taxes 400,000 275,633 481,489 81,489 120.37%410,000 71,489 117.44%
41001:Fines 328,392 25,560 270,205 (58,187) 82.28%290,600 (20,395) 92.98%
41002:Penalties 60,000 10,340 104,967 44,967 174.95%70,000 34,968 149.95%
42001:Interest Income 75,000 3,468 81,050 6,050 108.07%87,429 (6,379) 92.70%
43001:Fees 7,028,184 728,626 7,532,037 503,853 107.17%6,876,306 655,731 109.54%
43002:Garbage Charges 10,151,764 927,027 10,867,148 715,385 107.05%10,300,000 567,148 105.51%
43003:Permits 4,317,750 303,635 4,781,179 463,429 110.73%4,880,250 (99,071) 97.97%
43004:Administrative Charges 3,396,447 282,708 3,392,501 (3,946) 99.88%3,396,447 (3,946) 99.88%
43005:Rental Revenue 148,140 15,222 199,449 51,309 134.64%125,947 73,503 158.36%
45001:Misc Revenue 871,955 55,490 717,891 (154,064) 82.33%804,049 (86,158) 89.28%
45003:Misc Reimbursements - 844 13,521 13,521 0.00%- 13,521 0.00%
44001:Grant Revenue 679,884 278,882 914,494 234,610 134.51%500,000 414,495 182.90%
44501:Contribution Revenue - - - - 0.00%- - 0.00%
44502:Developer Contributions 423,112 (193,646) 229,682 (193,430) 54.28%423,332 (193,650) 54.26%
44503:Interlocal Agreement Revenue 5,091,091 1,183,773 5,093,767 2,676 100.05%5,091,092 2,675 100.05%
44504:Donations - - 6,238 6,238 0.00%- 6,238 0.00%
70001:Transfers In 995,302 - 995,302 - 100.00%995,302 - 100.00%
70002:Transfers In - Payment in Lieu of Taxes (PILOT)8,431,375 543,352 9,022,128 590,753 107.01%8,460,467 561,661 106.64%
Revenue Total 83,206,421 11,389,678 90,675,491 7,469,070 108.98%87,814,662 2,860,829 103.26%
Expense
City of Georgetown (Only)- - (140) (140) 0.00%- (140) 0.00%
CC0001 Non-Departmental 1,654,691 1,891 1,369,493 285,198 82.76%6,357,848 4,988,355 21.54%
CC0107 Planning 1,978,054 216,912 1,750,470 227,584 88.49%1,903,216 152,746 91.97%
CC0202 Parks Administration 662,887 63,769 630,335 32,552 95.09%643,407 13,072 97.97%
CC0210 Library 2,837,904 288,598 2,699,109 138,795 95.11%2,852,883 153,773 94.61%
CC0211 Parks 2,727,414 290,717 2,583,064 144,350 94.71%2,640,698 57,634 97.82%
CC0212 Recreation 2,899,381 302,758 2,755,929 143,452 95.05%2,870,088 114,159 96.02%
CC0213 Tennis Center 442,917 38,625 386,537 56,380 87.27%421,451 34,914 91.72%
CC0214 Recreation Programs 1,251,370 75,566 948,688 302,682 75.81%1,093,594 144,906 86.75%
CC0215 Garey Park 982,022 82,028 857,934 124,088 87.36%974,873 116,939 88.00%
CC0218 Arts and Culture 57,857 16,203 82,372 (24,515) 142.37%57,857 (24,515) 142.37%
CC0316 Municipal Court 585,123 65,392 554,822 30,301 94.82%556,709 1,887 99.66%
CC0402 Fire Support Services/Administration 4,348,592 443,646 3,766,322 582,269 86.61%3,795,965 29,643 99.22%
CC0422 Fire Emergency Services 15,953,391 2,507,752 15,520,210 433,180 97.28%15,961,522 441,312 97.24%
CC0448 EMS 2,580,541 394,010 2,879,530 (298,989) 111.59%3,063,614 184,085 93.99%
CC0533 Environmental Services 9,662,924 1,715,348 9,587,669 75,256 99.22%9,666,349 78,680 99.19%
CC0536 Inspection Services 1,547,913 204,296 1,459,857 88,056 94.31%1,439,273 (20,584) 101.43%
Year-End:
Projections Vs. ActualsYear-to-Date Actuals Budget Vs. Actuals
24
General Fund
Period: Sep-21 Budget Current Period
FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance
Fav/(Unfav)% of Projection
Year-End:
Projections Vs. ActualsYear-to-Date Actuals Budget Vs. Actuals
CC0602 Administrative Services 1,893,936 159,190 1,694,473 199,463 89.47%1,921,512 227,039 88.18%
CC0605 Community Services 353,889 19,357 350,621 3,268 99.08%359,411 8,790 97.55%
CC0634 City Council Services 185,734 12,664 184,733 1,001 99.46%190,992 6,259 96.72%
CC0635 City Secretary Services 1,009,772 116,091 981,238 28,533 97.17%988,578 7,340 99.26%
CC0637 Economic Development - (107) - - 0.00%1,625 1,625 0.00%
CC0638 General Government Contracts 4,774,808 349,683 5,211,164 (436,356) 109.14%5,529,569 318,404 94.24%
CC0639 Human Resources - - - - 0.00%3,599 3,599 0.00%
CC0655 Communications/Public Engagement 844,604 85,183 704,633 139,971 83.43%825,151 120,518 85.39%
CC0702 Police Administration 2,567,848 221,070 2,365,080 202,768 92.10%2,565,917 200,837 92.17%
CC0742 Police Operations 14,669,105 1,639,424 14,763,085 (93,979) 100.64%14,508,770 (254,315) 101.75%
CC0744 Animal Services 1,106,702 117,309 934,970 171,732 84.48%1,046,689 111,719 89.33%
CC0745 Code Compliance 562,740 73,639 483,750 78,990 85.96%520,890 37,140 92.87%
CC0802 Public Works 1,705,914 188,192 1,365,719 340,194 80.06%1,632,799 267,080 83.64%
CC0845 Stormwater - (4,684) - - 0.00%- - 0.00%
CC0846 Streets 3,137,149 342,135 2,872,098 265,051 91.55%3,082,495 210,398 93.17%
Expense Total 82,985,180 10,026,658 79,743,765 3,241,415 96.09%87,477,342 7,733,577 91.16%
Excess (Deficiency) of Total Revenue over Total
Requirements 221,240 1,363,020 10,931,725 10,710,485 4941.11%337,319 10,594,406 3240.76%
Ending Fund Balance 21,417,850 32,128,335 10,710,485 150.01%21,533,929 10,594,406 149.20%
Reserves
AFR Adjustment - - - 0.00%- - 0.00%
Benefit Payout Reserve 340,000 340,000 - 100.00%340,000 - 100.00%
Contingency Reserve 12,626,752 12,626,752 - 100.00%12,626,752 - 100.00%
Economic Stability Reserve 1,467,563 1,467,563 - 100.00%1,467,563 - 100.00%
Reserves Total 14,434,315 14,434,315 - 100.00%14,434,315 - 100.00%
Available Fund Balance 6,983,535 17,694,020 10,710,485 253.37%7,099,614 10,594,406 249.23%
25
General Fund
Quarterly Comparison: Q4 FY2021 Budget Actuals
FY2021 YTD Actuals:
Q4 FY2021 Variance % of Budget Projections 2021 Variance
Fav/(Unfav)% of Projection
Planning
Personnel 1,383,026 1,342,756 40,270 97.09% 1,335,261 (7,495) 100.56%
Operations 593,976 406,662 187,314 68.46% 564,055 157,393 72.10%
Operating Capital 1,052 1,052 0 99.96%3,900 2,848 26.96%
Planning Total Expense 1,978,054 1,750,470 227,584 88.49% 1,903,216 152,746 91.97%
Library
Personnel 1,798,754 1,686,347 (90,100) 93.75% 1,828,761 142,414 92.21%
Operations 1,010,650 1,004,209 70,111 99.36% 1,016,162 11,953 98.82%
Operating Capital 28,500 8,553 (8,553) 30.01%7,960 (593) 107.46%
Library Total Expense 2,837,904 2,699,109 (28,543) 95.11% 2,852,883 153,773 94.61%
Parks Administration
Personnel 278,450 280,793 (2,343) 100.84% 276,737 (4,056) 101.47%
Operations 384,437 384,437 0.00% 366,670 366,670 0.00%
Parks Administration Total Expense 662,887 630,335 32,552 95.09% 643,407 13,072 97.97%
Parks
Personnel 1,540,835 1,453,737 87,097 94.35% 1,455,988 2,251 99.85%
Operations 1,186,579 1,129,327 57,252 95.17% 1,184,709 55,383 95.33%
Operating Capital - - - 0.00%- - 0.00%
CIP Expense - - - 0.00%- - 0.00%
Parks Total Expense 2,727,414 2,583,064 144,350 94.71% 2,640,698 57,634 97.82%
Recreation
Personnel 1,606,081 1,584,967 21,114 98.69% 1,629,136 44,169 97.29%
Operations 1,293,300 1,150,994 142,306 89.00% 1,240,952 89,957 92.75%
Operating Capital - 19,968 (19,968) 0.00%- (19,968) #DIV/0!
Recreation Total Expense 2,899,381 2,755,929 143,452 95.05% 2,870,088 114,159 96.02%
Tennis Center
Personnel 235,401 226,269 9,131 96.12% 230,744 4,474 98.06%
Operations 207,516 160,268 47,248 77.23% 190,707 30,440 84.04%
Tennis Center Total Expense 442,917 386,537 56,380 87.27% 421,451 34,914 91.72%
Recreation Programs
Personnel 680,377 493,066 187,311 72.47% 651,365 158,299 75.70%
Budget Vs. Actuals
Year‐End:
Projections Vs. Actuals
26
General Fund
Quarterly Comparison: Q4 FY2021 Budget Actuals
FY2021 YTD Actuals:
Q4 FY2021 Variance % of Budget Projections 2021 Variance
Fav/(Unfav)% of Projection
Budget Vs. Actuals
Year‐End:
Projections Vs. Actuals
Operations 570,993 455,622 115,371 79.79% 442,228 (13,393) 103.03%
Recreation Programs Total Expense 1,251,370 948,688 302,682 75.81% 1,093,594 144,906 86.75%
Garey Park
Personnel 471,122 436,640 34,483 92.68% 491,455 54,815 88.85%
Operations 510,589 421,384 89,205 82.53% 483,418 62,035 87.17%
Operating Capital 311 (89) 400 -28.69%- 89 0.00%
Garey Park Total Expense 982,022 857,934 124,088 87.36% 974,873 116,939 88.00%
Arts and Culture
Operations 57,857 60,265 (2,408) 104.16%57,857 (2,407) 104.16%
Personnel - 22,108 (22,108) 0.00%- (22,108) #DIV/0!
Arts and Culture Total Expense 57,857 82,372 (24,515) 142.37%57,857 (24,515) 142.37%
Municipal Court
Personnel 484,734 476,716 8,019 98.35% 473,558 (3,158) 100.67%
Operations 100,389 78,106 22,283 77.80%83,151 5,044 93.93%
Municipal Court Total Expense 585,123 554,822 30,301 94.82% 556,709 1,887 99.66%
Fire Support Services/Administration
Personnel 2,877,376 2,370,610 506,765 82.39% 2,361,824 (8,786) 100.37%
Operations 1,446,067 1,380,436 65,631 95.46% 1,409,421 28,985 97.94%
Operating Capital 25,149 15,276 9,873 60.74%24,720 9,444 61.80%
Fire Support Total Expense 4,348,592 3,766,322 582,269 86.61% 3,795,965 29,643 99.22%
Fire Emergency Services
Personnel 13,493,986 13,163,820 330,166 97.55% 13,618,867 455,047 96.66%
Operations 2,379,405 2,280,147 99,258 95.83% 2,262,655 (17,491) 100.77%
Operating Capital 80,000 76,244 3,756 95.30%80,000 3,756 95.30%
Fire Emergency Services Total Expense 15,953,391 15,520,210 433,180 97.28% 15,961,522 441,312 97.24%
EMS
Personnel 1,749,042 2,137,655 (388,614) 122.22% 2,234,698 97,043 95.66%
Operations 773,749 714,482 59,267 92.34% 771,166 56,684 92.65%
Operating Capital 57,750 27,392 30,358 47.43%57,750 30,358 47.43%
EMS Total Expense 2,580,541 2,879,530 (298,989) 111.59% 3,063,614 184,085 93.99%
27
General Fund
Quarterly Comparison: Q4 FY2021 Budget Actuals
FY2021 YTD Actuals:
Q4 FY2021 Variance % of Budget Projections 2021 Variance
Fav/(Unfav)% of Projection
Budget Vs. Actuals
Year‐End:
Projections Vs. Actuals
Inspection Services
Personnel 1,366,692 1,318,950 47,743 96.51% 1,280,873 (38,076) 102.97%
Operations 181,221 140,908 40,313 77.75% 158,400 17,492 88.96%
Inspection Services Total Expense 1,547,913 1,459,857 88,056 94.31% 1,439,273 (20,584) 101.43%
Administrative Services
Personnel 1,367,229 1,334,303 32,926 97.59% 1,394,528 60,225 95.68%
Operations 526,707 360,170 166,537 68.38% 526,984 166,814 68.35%
Administration Services Total Expense 1,893,936 1,694,473 199,463 89.47% 1,921,512 227,039 88.18%
Community Services
Personnel 240,597 238,741 1,856 99.23% 246,932 8,191 96.68%
Operations 113,291 111,880 1,411 98.75% 112,479 599 99.47%
Community Services Total Expense 353,889 350,621 3,268 99.08% 359,411 8,790 97.55%
City Secretary
Personnel 524,370 527,909 (3,540) 100.68% 518,033 (9,876) 101.91%
Operations 485,402 453,329 32,073 93.39% 470,545 17,217 96.34%
City Secretary Total Expense 1,009,772 981,238 28,533 97.17% 988,578 7,340 99.26%
Communications/ Public Engagement
Personnel 533,969 531,186 2,783 99.48% 545,571 14,385 97.36%
Operations 310,635 173,447 137,188 55.84% 279,580 106,133 62.04%
Communications Total Expense 844,604 704,633 139,971 83.43% 825,151 120,518 85.39%
Police Administration
Personnel 652,285 637,301 14,984 97.70% 652,443 15,142 97.68%
Operations 1,915,563 1,727,779 187,784 90.20% 1,913,474 185,695 90.30%
Police Administration Total Expense 2,567,848 2,365,080 202,768 92.10% 2,565,917 200,837 92.17%
Police Operations
Personnel 12,308,896 12,589,801 (280,904) 102.28% 12,224,416 (365,384) 102.99%
Operations 2,283,105 2,153,916 129,189 94.34% 2,207,250 53,334 97.58%
Operating Capital 77,104 19,368 57,736 25.12%77,104 57,736 25.12%
Police Operations Total Expense 14,669,105 14,763,085 (93,979) 100.64% 14,508,770 (254,315) 101.75%
28
General Fund
Quarterly Comparison: Q4 FY2021 Budget Actuals
FY2021 YTD Actuals:
Q4 FY2021 Variance % of Budget Projections 2021 Variance
Fav/(Unfav)% of Projection
Budget Vs. Actuals
Year‐End:
Projections Vs. Actuals
Animal Services
Personnel 765,898 664,371 101,526 86.74% 707,099 42,727 93.96%
Operations 340,804 270,598 70,206 79.40% 339,590 68,992 79.68%
Animal Services Total Expense 1,106,702 934,970 171,732 84.48% 1,046,689 111,719 89.33%
Code Compliance
Personnel 464,093 389,597 74,496 83.95% 417,009 27,412 93.43%
Operations 95,650 94,153 1,497 98.43% 103,881 9,728 90.64%
Operating Capital 2,997 - 2,997 0.00%- - 0.00%
Code Compliance Total Expense 562,740 483,750 78,990 85.96% 520,890 37,140 92.87%
Public Works
Personnel 608,830 489,619 119,212 80.42% 483,229 (6,389) 101.32%
Operations 1,097,084 871,299 225,785 79.42% 1,149,450 278,151 75.80%
Operating Capital - 4,802 (4,802) 0.00%120 (4,682) 4003.54%
Public Works Total Expense 1,705,914 1,365,719 340,194 80.06% 1,632,799 267,080 83.64%
Streets
Personnel 1,384,302 1,262,357 121,945 91.19% 1,350,963 88,606 93.44%
Operations 1,752,107 1,598,367 153,740 91.23% 1,718,988 120,621 92.98%
Operating Capital 740 11,373 (10,633) 1537.00%12,544 1,171 90.67%
Streets Total Expense 3,137,149 2,872,098 265,051 91.55% 3,082,495 210,398 93.17%
Environmental Services
Operations 9,637,924 9,587,669 50,256 99.48%9,641,349 53,680 99.44%
Operating Capital 25,000 - 25,000 0.00%25,000 25,000 0.00%
Environmental Services Total Expense 9,662,924 9,587,669 75,256 99.22% 9,666,349 78,680 99.19%
Non‐Departmental
Operations - 12,577 (12,577) 0.00%3,157 (9,420) 398.40%
Transfers 1,654,691 1,356,916 297,775 82.00% 6,354,691 4,997,775 21.35%
Non-Departmental Total Expense 1,654,691 1,369,493 285,198 82.76% 6,357,848 4,988,355 21.54%
General Government Contracts
Operations 6,024,808 5,211,164 813,644 86.50% 5,829,569 618,404 89.39%
Personnel (1,250,000) - (1,250,000) 0.00% (300,000) (300,000) 0.00%
General Government Contracts Expense 4,774,808 5,211,164 (436,356) 109.14% 5,529,569 318,404 94.24%
29
General Fund
Quarterly Comparison: Q4 FY2021 Budget Actuals
FY2021 YTD Actuals:
Q4 FY2021 Variance % of Budget Projections 2021 Variance
Fav/(Unfav)% of Projection
Budget Vs. Actuals
Year‐End:
Projections Vs. Actuals
General Fund Total Expenses 82,985,180 79,743,765 3,241,415 96.09% 87,477,342 7,733,577 91.16%
30
Electric Services
Period: Sep-21 Budget Current Period
FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance
Fav/(Unfav)% of Projection
Beginning Fund Balance 28,133,710 28,133,710 - 100.00%28,133,710 - 100.00%
Operating Revenues
40002:Sales Taxes 5,000 611 5,863 863 117.25%5,000 863 117.25%
40005:Franchise Taxes 115,732 - - (115,732) 0.00%- - 0.00%
41002:Penalties 553,724 86,995 848,000 294,276 153.14%547,759 300,241 154.81%
42001:Interest Income 5,000 1,909 33,570 28,570 671.40%20,828 12,742 161.18%
43001:Fees 685,000 243,875 1,036,657 351,657 151.34%868,887 167,770 119.31%
43004:Administrative Charges 3,222,103 268,509 3,222,103 (0) 100.00%3,222,103 (0) 100.00%
43601:Electric Sales Charges 78,982,278 7,701,095 80,933,053 1,950,775 102.47%79,081,809 1,851,244 102.34%
44502:Developer Contributions 1,500,000 425,911 7,828,988 6,328,988 521.93%6,100,000 1,728,988 128.34%
70001:Transfers In 1,562,058 - 1,562,058 - 100.00%1,562,058 - 100.00%
Total Operating Revenues 86,630,895 8,728,904 95,470,292 8,839,397 110.20%91,408,444 4,061,848 104.44%
Operating Expenses
City of Georgetown (Only)- - - - 0.00%- - 0.00%
CC0001 Non-Departmental 5,506,375 1,263,669 6,520,044 (1,013,669) 118.41%6,668,720 148,676 97.77%
CC0526 Systems Engineering - - - - 0.00%80,506 80,506 0.00%
CC0522 Electric Administration 8,738,792 922,184 8,868,267 (129,476) 101.48%8,944,477 76,210 99.15%
CC0525 T&D Services 3,122,421 524,750 4,185,597 (1,063,176) 134.05%3,089,942 (1,095,655) 135.46%
CC0537 Electric Resource Management 108,334,393 3,572,953 109,900,806 (1,566,413) 101.45%108,331,349 (1,569,457) 101.45%
CC0555 Electric Systems Operations 1,610,228 172,830 1,579,253 30,976 98.08%1,639,454 60,202 96.33%
CC0557 Electrical Engineering 663,952 149,386 1,070,057 (406,104) 161.16%715,684 (354,372) 149.52%
CC0521 Electric Technical Services 727,388 68,728 670,962 56,426 92.24%717,148 46,186 93.56%
CC0524 Metering Services 2,022,094 157,972 1,939,497 82,597 95.92%2,029,912 90,414 95.55%
Total Operating Expenses 130,725,643 6,832,471 134,738,524 (4,012,881) 103.07%132,217,192 (2,521,332) 101.91%
Net Operations Total (44,094,748) (39,268,232) 12,852,277 89.05%(40,808,747) 1,540,515 96.23%
Non-Operating Revenues
45001:Misc Revenue 35,000 116,172 523,214 488,214 1494.90%233,023 290,191 224.53%
45004:Sale of Property 10,000 669,987 4,127,598 4,117,598 41275.98%2,526,604 1,600,994 163.37%
44001:Grant Revenue - - - - 0.00%- - 0.00%
46001:Bond Proceeds 54,648,625 - 54,065,000 (583,625) 98.93%54,065,000 - 100.00%
46002:Bond Premium - - 652,424 652,424 0.00%652,424 0 100.00%
Total Non-Operating Revenues 54,693,625 786,159 59,368,236 4,674,611 108.55%57,477,051 1,891,185 103.29%
Non-Operating Expenses
CC0001 Non-Departmental 4,375,805 - 4,298,971 76,834 98.24%4,373,805 74,834 98.29%
CC0526 Systems Engineering - - - - 0.00%- - 0.00%
CC0557 Electrical Engineering 8,166,143 728,287 3,386,145 4,779,997 41.47%8,166,142 4,779,997 41.47%
Total Non-Operating Expenses 12,541,948 728,287 7,685,116 4,856,831 61.28%12,539,947 4,854,831 61.29%
Excess (Deficiency) of Total Revenue over Total Requirements (1,943,071) 121,950,101 12,414,888 14,357,959 -638.93%4,128,357 8,286,532 300.72%
Ending Fund Balance 26,190,639 40,548,598 14,357,959 154.82%32,262,067 8,286,532 125.69%
Reserves
Rate Stabalization - 18,600,000 18,600,000 0.00%18,600,000 - 100.00%
Reserve for Bond Proceeds 4,448,314 4,448,314 - 100.00%4,448,314 - 100.00%
Contingency Reserve 4,018,754 4,018,754 - 100.00%4,018,754 - 100.00%
Non-Operating Reserve 10,594,999 3,486,903 (7,108,096) 32.91%3,486,903 - 100.00%
Reserves Total 19,062,067 30,553,971 11,491,904 160.29%30,553,971 - 100.00%
Available Fund Balance 7,128,572 9,994,627 2,866,055 140.21%1,708,096 8,286,532 585.13%
Year-to-Date Actuals Budget Vs. Actuals Year-End: Projections Vs. Actuals
31
Water Services Fund
Period: Sep-21 Budget Current Period
FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance
Fav/(Unfav)% of Projection
Beginning Fund Balance 125,458,053 125,458,053 - 100.00%125,458,053 - 100.00%
Operating Revenue
41002:Penalties 255,000 54,861 513,447 258,447 201.35%355,000 158,447 44.63%
42001:Interest Income 237,250 19,335 427,758 190,508 180.30%492,336 (64,577) 86.88%
43001:Fees 4,290,000 525,550 9,598,958 5,308,958 223.75%7,655,000 1,943,958 125.39%
43005:Rental Revenue 55,000 46,430 112,975 57,975 205.41%60,000 52,975 188.29%
43602:Water Charges 32,150,000 5,697,888 41,143,198 8,993,198 127.97%35,100,000 6,043,198 117.22%
43603:Wastewater Charges 14,200,000 1,346,460 15,125,001 925,001 106.51%14,000,000 1,125,001 108.04%
43604:Irrigation Charges 300,000 72,113 360,002 60,002 120.00%300,000 60,002 120.00%
41602:Impact Fees 18,800,000 3,668,562 40,034,496 21,234,496 212.95%32,500,000 7,534,496 123.18%
44502:Developer Contributions 625,000 - 1,490,202 865,202 238.43%1,496,239 (6,037) 99.60%
Total Operating Revenue 70,912,250 11,431,199 108,806,038 37,893,788 153.44%91,958,575 16,847,463 118.32%
Operating Expenses
City of Georgetown (Only)- - - - 0.00%- - 0.00%
CC0001 Non-Departmental 4,223,814 942,511 5,131,684 (907,870) 121.49%4,713,430 (418,254) 108.87%
CC0526 Systems Engineering - - (1,836,056) (1,836,056) 0.00%(639,847) 1,196,209 286.95%
CC0532 Irrigation Operations 295,000 11,987 139,285 155,715 47.22%295,000 155,715 47.22%
CC0530 Wastewater Operations 896,265 45,966 547,171 349,094 61.05%834,706 287,535 65.55%
CC0531 Wastewater Plant Management 4,013,950 289,802 3,516,184 497,766 87.60%3,704,111 187,927 94.93%
CC0527 Water Services Administration 26,369,169 2,078,728 24,491,296 1,877,873 92.88%26,232,898 1,741,602 93.36%
CC0528 Water Distribution 3,207,552 224,030 3,176,051 31,501 99.02%3,911,851 735,800 81.19%
CC0529 Water Plant Management 4,326,865 379,014 3,479,406 847,459 80.41%3,910,271 430,866 88.98%
CC0553 Water Operations 4,173,316 458,338 4,377,488 (204,172) 104.89%4,463,681 86,193 98.07%
CC0524 Metering Services - (265) - - 0.00%- - 0.00%
Operating Expense Total 47,505,930 4,430,111 43,022,509 4,483,421 90.56%47,426,102 4,403,593 90.71%
Available Operating Fund Balance 23,406,320 65,783,529 33,410,367 44,532,473 21,251,056 147.72%
Non-Operating Revenue
45001:Misc Revenue 1,112,500 1,073,450 1,312,616 200,116 117.99%1,262,350 50,266 103.98%
45003:Misc Reimbursements - - 10,422 10,422 0.00%- 10,422 0.00%
45004:Sale of Property 1,327,774 - 1,330,463 2,689 100.20%1,327,774 2,689 100.20%
44001:Grant Revenue - - - - 0.00%- - 0.00%
46001:Bond Proceeds 16,300,000 - 14,975,000 (1,325,000) 91.87%14,975,000 - 100.00%
46002:Bond Premium - - 1,415,140 1,415,140 0.00%1,415,140 (0) 100.00%
Non-Operating Revenue Total 18,740,274 1,073,450 19,043,639 303,365 101.62%18,980,264 63,375 100.33%
Non-Operating Expenses
CC0001 Non-Departmental 4,083,411 - 92,665 3,990,746 2.27%3,887,651 3,794,986 2.38%
CC0526 Systems Engineering 99,509,468 2,895,483 13,900,168 85,609,300 13.97%99,630,405 85,730,237 13.95%
CC0532 Irrigation Operations 121,879 - 121,994 (115) 100.09%121,929 (65) 100.05%
CC0530 Wastewater Operations 3,026,798 137,163 3,160,381 (133,583) 104.41%3,026,798 (133,583) 104.41%
CC0531 Wastewater Plant Management 2,050,000 - - 2,050,000 0.00%2,050,000 2,050,000 0.00%
CC0527 Water Services Administration - - - - 0.00%6,037 6,037 0.00%
CC0528 Water Distribution 1,159,424 - 781,316 378,108 67.39%781,316 - 100.00%
CC0529 Water Plant Management 2,757 - - 2,757 0.00%2,757 2,757 0.00%
CC0553 Water Operations 14,124,300 126,666 11,704,343 2,419,957 82.87%13,962,363 2,258,021 83.83%
CC0524 Metering Services 750,000 - - 750,000 0.00%750,000 750,000 0.00%
Non-Operating Expense Total 124,828,037 3,159,313 29,760,867 95,067,170 23.84%124,219,256 94,458,389 23.96%
Excess (Deficiency) of Total Revenue over Total
Requirements (82,681,443) (142,162,493) 55,066,302 137,747,744 -66.60%(60,706,519) 115,772,820 -90.71%
Ending Fund Balance 42,776,610 180,524,355 137,747,744 422.02%64,751,534 115,772,820 278.80%
Reserves
Contingency Reserve 9,127,742 9,127,742 - 100.00%9,127,742 - 100.00%
Non-Operating Reserve 10,000,000 10,000,000 - 100.00%10,000,000 - 100.00%
Reserves Total 19,127,742 19,127,742 - 100.00%19,127,742 - 100.00%
Available Fund Balance 23,648,868 161,396,613 137,747,744 682.47%45,623,792 115,772,820 353.76%
Year-to-Date Actuals Budget Vs. Actuals
Year-End: Projections Vs
Actuals
32
Joint Services
Period: Sep-21 Budget Current Period
FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance
Fav/(Unfav)% of Projection
Beginning Fund Balance 2,157,365 2,157,365 - 100.00%2,157,365 - 100.00%
Revenue
41002:Penalties - 643 27,968 27,968 0.00%25,000 2,968 111.87%
42001:Interest Income 6,250 242 7,416 1,166 118.66%6,250 1,166 118.66%
43001:Fees 173,600 360 19,825 (153,775) 11.42%14,000 5,825 141.61%
43003:Permits - - - - 0.00%- - 0.00%
43004:Administrative Charges 17,912,066 1,483,995 17,919,566 7,500 100.04%17,912,066 7,500 100.04%
43005:Rental Revenue - - 100 100 0.00%100 - 100.00%
45001:Misc Revenue - - 431 431 0.00%431 - 100.00%
45002:Insurance Proceeds - 3,262 176,186 176,186 0.00%70,000 106,186 251.69%
45003:Misc Reimbursements 83,000 10,749 135,251 52,251 162.95%91,356 43,895 148.05%
44001:Grant Revenue - - - - 0.00%- - 0.00%
70001:Transfers In - - - - 0.00%- - 0.00%
Revenue Total 18,174,916 1,499,250 18,286,743 111,827 100.62%18,119,203 167,539 100.92%
Expense
City of Georgetown (Only)- - - - 0.00%- - 0.00%
CC0001 Non-Departmental 965,999 134,114 1,351,283 (385,284) 139.88%1,246,402 (104,881) 108.41%
CC0302 Finance Administration 1,222,909 155,116 1,031,741 191,168 84.37%1,025,554 (6,188) 100.60%
CC0315 Accounting 1,302,383 153,803 1,317,455 (15,072) 101.16%1,358,423 40,968 96.98%
CC0317 Purchasing 996,521 109,835 932,518 64,003 93.58%937,558 5,040 99.46%
CC0321 Customer Care 5,955,711 559,160 5,693,772 261,939 95.60%5,867,947 174,175 97.03%
CC0503 Organizational and Operational Excellence 342,009 38,095 310,835 31,174 90.88%323,516 12,681 96.08%
CC0526 Systems Engineering 2,757,957 293,657 2,586,589 171,368 93.79%2,755,159 168,570 93.88%
CC0534 Conservation 779,365 89,325 553,103 226,262 70.97%565,331 12,228 97.84%
CC0547 Business System Services - - - - 0.00%- - 0.00%
CC0637 Economic Development 593,007 63,238 570,646 22,361 96.23%575,708 5,062 99.12%
CC0639 Human Resources 1,507,953 174,281 1,484,953 23,001 98.47%1,481,634 (3,319) 100.22%
CC0640 Citywide Human Resources 1,219,444 116,343 1,082,035 137,409 88.73%1,127,024 44,988 96.01%
CC0654 Legal 1,055,716 163,694 1,126,034 (70,318) 106.66%1,037,349 (88,685) 108.55%
Expense Total 18,698,974 2,050,661 18,040,964 658,011 96.48%18,301,604 260,640 98.58%
Excess (Deficiency) of Total Revenue over Total Requirements (524,058) (551,411) 245,779 769,837 -46.90%(182,400) 428,179 -134.75%
Ending Fund Balance 1,633,307 2,403,144 769,837 147.13%1,974,965 428,179 121.68%
Reserves
Contingency Reserve 1,633,307 1,633,307 0 100.00%1,633,307 - 100.00%
Reserves Total 1,633,307 1,633,307 0 100.00%1,633,307 - 100.00%
Available Fund Balance - 769,837 769,837 0.00%341,658 428,179 225.32%
Year-to-Date Actuals Budget Vs. Actuals
Year-End:
Projections Vs. Actuals
33
Council Discretionary
Period: Sep-21 Budget Current Period
FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance
Fav/(Unfav)% of Projection
Beginning Fund Balance 110,483 110,483 - 100.00%110,966 (483) 100.44%
Revenue
42001:Interest Income 500 0 122 (378) 24.31%162 (41) 74.83%
70001:Transfers In - - - - 0.00%4,700,000 (4,700,000) 0.00%
Total Revenue 500 0 122 (378) 24.31%4,700,162 (4,700,041) 0.00%
Expense
Transfers 110,983 - 110,983 - 100.00%110,983 - 100.00%
Total Expense 110,983 - 110,983 - 100.00%110,983 - 100.00%
Excess (Deficiency) of Total Revenue over Total
Requirements (110,483) 0 (110,861) (378) 100.34%4,589,179 (4,700,041) -2.42%
Ending Fund Balance - 0 (378) (378) 0.00%4,700,145 (4,700,524) -0.01%
Reserves
AFR Adjustment - - - - - - 0.00%
Contingency Reserve - - - - - - 0.00%
Debt Service Reserve - - - - - - 0.00%
Reserves Total - - - - - - 0.00%
Available Fund Balance - (378) (378) - 4,700,145 (4,700,524) -0.01%
Year-End:
Projections Vs. ActualsYear-to-Date Actuals Budget Vs. Actuals
34
Tourism
Period: Sep-21 Budget Current Period
FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance
Fav/(Unfav)% of Projection
Beginning Fund Balance 1,282,917 1,282,917 - 100.00%1,675,963 (393,046) 130.64%
Revenue
40008:Other Taxes 900,000 301,775 1,247,146 347,146 138.57%850,000 397,146 146.72%
42001:Interest Income 5,000 184 5,057 57 101.15%5,000 57 101.14%
45001:Misc Revenue 95,000 13,230 40,531 (54,469) 42.66%39,850 682 101.71%
45003:Misc Reimbursements - - - - 0.00%- - 0.00%
44001:Grant Revenue - - 4,200 4,200 0.00%- 4,200 0.00%
44504:Donations - - - - 0.00%- - 0.00%
44505:Sponsorship 50,000 - - (50,000) 0.00%5,000 (5,000) 0.00%
Total Revenue 1,050,000 315,189 1,296,934 246,934 123.52%899,850 397,084 144.13%
Expense
Personnel 435,456 64,875 358,771 76,685 82.39%355,688 (3,083) 100.87%
Operations 1,014,085 161,469 683,827 330,258 67.43%919,987 236,160 74.33%
Transfers 28,634 - 28,634 - 100.00%28,634 - 100.00%
Total Expense 1,478,175 226,344 1,071,232 406,944 72.47%1,304,309 233,077 82.13%
Excess (Deficiency) of Total Revenue over Total
Requirements (428,175) 88,845 225,702 653,878 -52.71%(404,459) 630,161 -55.80%
Ending Fund Balance 854,742 88,845 1,508,619 653,878 151.05%1,271,504 237,115 118.65%
Reserves
AFR Adjustment - - - 0.00%- - 0.00%
Contingency Reserve 305,771 305,771 - 100.00%305,771 - 100.00%
Reserves Total 305,771 305,771 - 100.00%305,771 - 100.00%
Available Fund Balance 548,971 1,202,848 653,878 219.11%965,733 237,115 124.55%
Year-End:
Projections Vs. ActualsYear-to-Date Actuals Budget Vs. Actuals
35
Airport Operations
Period: Sep-21 Budget Current Period
FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance
Fav/(Unfav)% of Projection
Beginning Fund Balance 1,463,499 1,463,499 - 100.00%1,463,499 - 100.00%
Operating Revenues
40001:Property Taxes 40,000 59,423 59,423 19,423 148.56%57,000 2,423 104.25%
42001:Interest Income 3,000 179 4,082 1,082 136.08%3,129 953 130.47%
43606:Airport Charges 3,908,500 408,263 3,908,279 (221) 99.99%3,754,800 153,479 104.09%
Total Operating Revenues 3,951,500 467,866 3,971,785 20,285 100.51%3,814,930 156,855 104.11%
Operating Expenses
Personnel 464,472 57,447 447,529 16,943 96.35%465,860 18,331 96.07%
Operations 3,559,192 439,871 3,177,144 382,048 89.27%3,416,469 239,325 92.99%
Operating Capital 404,067 80,724 100,563 303,504 24.89%105,255 4,692 95.54%
Total Operating Expenses 4,427,731 578,041 3,725,236 702,495 84.13%3,987,583 262,347 93.42%
Non-Operating Revenues
45001:Misc Revenue 5,000 - 2,250 (2,750) 45.00%1,000 1,250 225.00%
44001:Grant Revenue - 50,000 206,980 206,980 0.00%157,000 49,980 131.83%
46001:Bond Proceeds 700,000 - 650,000 (50,000) 92.86%650,000 - 100.00%
46002:Bond Premium - - 64,186 64,186 0.00%64,186 0 100.00%
Total Non-Operating Revenues 705,000 50,000 923,417 218,417 130.98%872,186 51,231 105.87%
Non-Operating Expenses
CIP Expense 750,000 - - 750,000 0.00%750,000 750,000 0.00%
Debt Service 158,931 (179) 147,341 11,590 92.71%158,931 11,590 92.71%
Total Non-Operating Expenses 908,931 (179) 147,341 761,590 16.21%908,931 761,590 16.21%
Excess (Deficiency) of Total Revenue over Total
Requirements (680,162) (59,996) 1,022,625 1,702,786 -150.35%(209,398) 1,232,023 -488.36%
Ending Fund Balance 783,337 (59,996) 2,486,124 1,702,786 317.38%1,254,101 1,232,023 198.24%
Reserves
AFR Adjustment - - - 0.00%- - 0.00%
Contingency Reserve 332,917 332,917 - 100.00%332,917 - 100.00%
Reserves for Debt Service 141,478 141,478 - 100.00%184,099 42,621 76.85%
Reserves Total 474,395 474,395 - 100.00%517,016 42,621 91.76%
Available Fund Balance 308,942 2,011,729 1,702,786 651.17%737,085 1,274,644 272.93%
Year-End:
Projections Vs. ActualsYear-to-Date Actuals Budget Vs. Actuals
36
Stormwater Services
Period: Sep-21 Budget Current Period
FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance % of Projection
Beginning Fund Balance 3,478,178 3,478,178 - 100.00%3,478,178 - 100.00%
Operating Revenues
41002:Penalties - 5,187 44,537 44,537 0.00%35,000 9,536 127.25%
42001:Interest Income 10,000 330 9,516 (484) 95.16%7,591 1,925 125.35%
43605:Stormwater Charges 3,820,000 340,579 4,164,869 344,869 109.03%3,833,100 331,769 108.66%
Total Operating Revenues 3,830,000 346,096 4,218,922 388,922 110.15%3,875,692 343,230 108.86%
Operating Expenses
Personnel 626,032 64,260 549,478 76,554 87.77%599,666 50,187 91.63%
Operations 1,960,720 212,634 1,839,411 121,309 93.81%1,874,552 35,142 98.13%
Operating Capital 11,429 2 505 10,924 4.42%47,848 47,343 1.06%
Transfers 301,000 24,204 315,557 (14,557) 104.84%305,767 9,790 103.20%
Total Operating Expenses 2,899,181 301,100 2,704,951 194,230 93.30%2,827,833 122,882 95.65%
Available Operating Funds 930,819 44,996 1,513,971 583,152 162.65%1,047,859 466,112 144.48%
Non-Operating Revenues
45001:Misc Revenue 21,000 - - (21,000) 0.00%- - 0.00%
45004:Sale of Property - - - - 0.00%- - 0.00%
44001:Grant Revenue - - - - 0.00%- - 0.00%
46001:Bond Proceeds - - - - 0.00%- - 0.00%
Total Non-Operating Revenues 21,000 - - (21,000) 0.00%- - 0.00%
Non-Operating Expenses
CIP Expense 1,722,749 137,087 381,902 1,340,847 22.17%1,722,749 1,340,847 22.17%
Debt Service 501,360 - 485,441 15,919 96.82%501,360 15,920 96.82%
Total Non-Operating Expenses 2,224,109 137,087 867,342 1,356,767 39.00%2,224,109 1,356,767 39.00%
Excess (Deficiency) of Total Revenue over Total
Requirements (1,272,290) (92,091) 646,628 1,918,918 -50.82%(1,176,251) 1,822,879 -54.97%
Ending Fund Balance 2,205,888 (92,091) 4,124,806 1,918,918 186.99%2,301,927 1,822,879 179.19%
Reserves
AFR Adjustment - - - 0.00%- - 0.00%
Contingency Reserve 389,470 389,470 - 100.00%389,470 - 100.00%
Debt Service Reserve 480,662 480,662 - 100.00%480,662 - 100.00%
Reserves Total 870,132 870,132 - 100.00%870,132 - 100.00%
Available Fund Balance 1,335,756 3,254,674 1,918,918 243.66%1,431,795 1,822,879 227.31%
Year-End:
Projections Vs. ActualsYear-to-Date Actuals Budget Vs. Actuals
37
GTEC
Period: Sep-21 Budget Current Period
FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance
Fav/(Unfav)% of Projection
Beginning Fund Balance 31,029,698 31,029,698 - 100.00%31,029,698 - 100.00%
Operating Revenue
40002:Sales Taxes 8,255,000 2,813,103 10,618,823 2,363,823 128.64%10,187,500 431,323 104.23%
42001:Interest Income 60,000 1,081 25,704 (34,296) 42.84%24,544 1,161 104.73%
Operating Revenue Total 8,315,000 2,814,184 10,644,527 2,329,527 128.02%10,212,044 432,484 104.24%
Operating Expense
Operations 402,962 33,514 346,223 56,739 85.92%402,190 55,967 86.08%
Operating Capital - - - - 0.00%0 0 0.00%
Transfers 2,763,242 - 2,758,343 4,899 99.82%2,763,242 4,899 99.82%
Operating Expense Total 3,166,204 33,514 3,104,567 61,637 98.05%3,165,433 60,866 98.08%
Net Operations Total 5,148,796 2,780,671 7,539,961 2,267,890 146.44%7,046,611 371,618 107.00%
Non-Operating Revenue
46001:Bond Proceeds 8,000,000 - 7,405,000 (595,000) 92.56%7,405,000 - 0.00%
46002:Bond Premium - - 731,229 731,229 0.00%731,229 (0) 0.00%
Non-Operating Revenue Total 8,000,000 - 8,136,229 136,229 101.70%8,136,229 (0) 0.00%
Non-Operating Expense
Operations 1,984,375 - - 1,984,375 0.00%1,984,375 (1,984,375) -100.00%
CIP Expense 20,476,813 (832,504) 4,027,459 16,449,354 19.67%20,476,813 (16,449,354) -80.33%
Debt Service 1,053,050 (2,040) 883,535 169,515 83.90%1,053,050 (169,515) -16.10%
Non-Operating Expense Total 23,514,238 (834,544) 4,910,994 18,603,244 20.89%23,514,238 (18,603,244) -79.11%
Excess (Deficiency) of Total Revenue over Total
Requirements (10,365,442) (7,232,752) 6,329,801 16,695,243 -61.07%(12,212,576) 18,542,377 -51.83%
Ending Fund Balance 20,664,256 41,794,893 21,130,638 202.26%22,698,300 19,096,593 184.13%
Reserves
AFR Adjustment - - - 0.00%- - 0.00%
Contingency Reserve 1,984,375 1,984,375 - 100.00%1,984,375 - 100.00%
Debt Service Reserve 3,494,232 3,494,232 - 100.00%3,494,232 - 100.00%
Reserves Total 5,478,607 5,478,607 - 100.00%5,478,607 - 100.00%
Available Fund Balance 15,185,649 36,316,286 21,130,638 239.15%17,219,693 19,096,593 210.90%
Year-End:
Projections Vs. ActualsYear-to-Date Actuals Budget Vs. Actuals
38
GEDCO
Period: Sep-21 Budget Current Period
FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance
Fav/(Unfav)% of Projection
Beginning Fund Balance 8,845,777 8,845,777 - 100.00%5,740,067 3,105,710 64.89%
Revenue
40002:Sales Taxes 2,063,750 703,276 2,654,706 590,956 128.64%2,546,875 107,831 104.23%
42001:Interest Income 19,000 218 24,863 5,863 130.86%25,000 (137) 99.45%
Total Revenue 2,082,750 703,493 2,679,569 596,819 128.66%2,571,875 107,694 104.19%
Expense
Operations 8,850,174 46,960 803,071 8,047,103 9.07%6,028,476 5,225,405 13.32%
Debt Service 90,572 - - 90,572 0.00%90,572 90,572 0.00%
Transfers 1,200,169 - 1,200,284 (115) 100.01%1,200,169 (114) 100.01%
Total Expense 10,140,915 46,960 2,003,355 8,137,560 19.76%7,319,217 5,315,862 27.37%
Excess (Deficiency) of Total Revenue over Total
Requirements (8,058,165) 656,533 676,214 8,734,379 -8.39%(4,747,342) 5,423,556 -14.24%
Ending Fund Balance 787,612 656,533 9,521,991 (7,540,741) 1208.97%992,725 (8,529,266) 959.18%
Reserves
AFR Adjustment - - - 0.00%- - 0.00%
Contingency Reserve 505,468 505,468 - 100.00%505,468 - 100.00%
Debt Service Reserve 202,769 202,769 - 100.00%202,769 - 100.00%
Reserves Total 708,237 708,237 - 100.00%708,237 - 100.00%
Available Fund Balance 79,375 8,813,754 8,734,379 11103.94%284,488 8,529,266 3098.12%
Year-End:
Projections Vs. ActualsYear-to-Date Actuals Budget Vs. Actuals
39
CITY
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
September 30, 2021
Prepared by
Valley View Consulting, L.L.C.
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.
40
FYE Results by Investment Category:
Asset Type Ave. Yield Book Value Market Value Ave. Yield Book Value Market Value
Demand Accounts 0.26%9,505,298$ 9,505,298$ 0.22%22,970,725$ 22,970,725$
NOW/MMA 0.87%15,087,991 15,087,991 0.24%23,043,557 23,043,557
Pools 0.14%103,065,896 103,065,896 0.02%194,658,236 194,658,236
CDs/Securities 0.89%112,639,369 112,640,201 0.25%136,646,542 136,646,542
Totals 240,298,554$ 240,299,385$ 377,319,060$ 377,319,060$
Fourth Quarter-End Yield 0.54%0.13%
Average Quarter-End Yields (1):
2021 Fiscal Year 2021 Fiscal Year
Georgetown-City 1.15%0.21%
Rolling Three Month Treasury 0.76%0.06%
Rolling Six Month Treasury 0.99%0.08%
TexPool 0.75%0.04%
(1) Average Quarterly Yield calculated using quarter-end report average yield and adjusted book value.
September 30, 2020
Annual Comparison of Portfolio Performance
September 30, 2021
City of Georgetown Valley View Consulting, L.L.C.141
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Demand Accounts 23,547,685$ 23,547,685 22,970,725$ 22,970,725$ 0.22%
NOW/MMA 23,029,382 23,029,382 23,043,557 23,043,557 0.24%
Pools 174,848,692 174,848,692 194,658,236 194,658,236 0.02%
CDs/Securities 123,735,822 123,735,822 136,646,542 136,646,542 0.25%Totals 345,161,582$ 345,161,582$ 377,319,060$ 377,319,060$ 0.13%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.13%Total Portfolio 0.21%
Rolling Three Month Treasury 0.05%Rolling Three Month Treasury 0.06%
Rolling Six Month Treasury 0.05%Rolling Six Month Treasury 0.08%
TexPool 0.03%TexPool 0.04%
Bank Fees Offset
12,388$
Interest earnings provided in separate report.42,513$
June 30, 2021
(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
September 30, 2021
City of Georgetown Valley View Consulting, L.L.C.242
City - Investment Holdings
Coupon/ Maturity Settlement Face Amount/ Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day) Yield
JPMorgan Chase Cash (3)0.22% 10/01/21 09/30/21 22,970,725$ 22,970,725$ 1.00 22,970,725$ 1 0.22%
JPMorgan Chase MMA 0.03% 10/01/21 09/30/21 434,113 434,113 1.00 434,113 1 0.03%
Veritex Community Bank MMA 0.08% 10/01/21 09/30/21 3,214,573 3,214,573 1.00 3,214,573 1 0.08%
NexBank MMA 0.40% 10/01/21 09/30/21 7,387,900 7,387,900 1.00 7,387,900 1 0.40%
Texas Capital Bank MMA 0.20% 10/01/21 09/30/21 12,006,970 12,006,970 1.00 12,006,970 1 0.20%
TexPool AAAm 0.03%10/01/21 09/30/21 66,870,729 66,870,729 1.00 66,870,729 1 0.03%
TexSTAR AAAm 0.01%10/01/21 09/30/21 127,787,508 127,787,508 1.00 127,787,508 1 0.01%
East West Bank CD 0.21% 10/08/21 01/08/21 5,007,658 5,007,658 100.00 5,007,658 8 0.21%
Prosperity Bank CD 0.30% 10/14/21 10/14/20 2,506,888 2,506,888 100.00 2,506,888 14 0.30%
Independent Bank CD 0.40% 10/18/21 10/18/20 2,554,218 2,554,218 100.00 2,554,218 18 0.40%
Prosperity Bank CD 0.30% 11/22/21 11/20/20 3,007,501 3,007,501 100.00 3,007,501 53 0.30%
Texas Regional Bank CD 0.25% 12/07/21 03/12/21 3,003,782 3,003,782 100.00 3,003,782 68 0.25%
East West Bank CD 0.21% 12/30/21 12/30/20 3,004,750 3,004,750 100.00 3,004,750 91 0.21%
East West Bank CD 0.21% 01/07/22 01/08/21 5,007,658 5,007,658 100.00 5,007,658 99 0.21%
Prosperity Bank CD 0.30% 01/21/22 10/21/20 4,011,021 4,011,021 100.00 4,011,021 113 0.30%
East West Bank CD 0.10% 02/01/22 05/10/21 2,000,789 2,000,789 100.00 2,000,789 124 0.10%
Independent Bank CD 0.40% 02/05/22 02/05/21 3,005,933 3,005,933 100.00 3,005,933 128 0.40%
Independent Bank CD 0.40% 02/08/22 02/08/21 5,009,868 5,009,868 100.00 5,009,868 131 0.40%
Prosperity Bank CD 0.15% 02/10/22 08/10/21 3,002,615 3,002,615 100.00 3,002,615 133 0.15%
R Bank CD 0.63% 02/25/22 02/25/21 2,006,258 2,006,258 100.00 2,006,258 148 0.63%
Prosperity Bank CD 0.15% 03/21/22 09/21/21 5,000,000 5,000,000 100.00 5,000,000 172 0.15%
Prosperity Bank CD 0.35% 04/21/22 10/21/20 2,508,038 2,508,038 100.00 2,508,038 203 0.35%
Independent Bank CD 0.30% 04/22/22 04/22/21 4,215,000 4,215,000 100.00 4,215,000 204 0.30%
Independent Bank CD 0.35% 05/09/22 02/08/21 4,006,945 4,006,945 100.00 4,006,945 221 0.35%
Prosperity Bank CD 0.35% 05/17/22 11/17/20 2,005,835 2,005,835 100.00 2,005,835 229 0.35%
Prosperity Bank CD 0.20% 06/13/22 06/11/21 5,002,521 5,002,521 100.00 5,002,521 256 0.20%
Prosperity Bank CD 0.20% 07/01/22 07/01/21 4,025,388 4,025,388 100.00 4,025,388 274 0.20%
Prosperity Bank CD 0.20% 07/25/22 04/23/21 5,004,193 5,004,193 100.00 5,004,193 298 0.20%
Prosperity Bank CD 0.20% 08/01/22 05/25/21 5,003,371 5,003,371 100.00 5,003,371 305 0.20%
Prosperity Bank CD 0.35% 08/22/22 11/20/20 2,507,294 2,507,294 100.00 2,507,294 326 0.35%
Prosperity Bank CD 0.20% 09/12/22 06/11/21 5,002,521 5,002,521 100.00 5,002,521 347 0.20%
Prosperity Bank CD 0.20% 10/24/22 04/23/21 5,004,193 5,004,193 100.00 5,004,193 389 0.20%
Prosperity Bank CD 0.40% 11/17/22 11/17/20 2,006,670 2,006,670 100.00 2,006,670 413 0.40%
Prosperity Bank CD 0.15% 11/23/22 08/23/21 2,000,255 2,000,255 100.00 2,000,255 419 0.15%
Prosperity Bank CD 0.15% 12/21/22 09/21/21 5,000,000 5,000,000 100.00 5,000,000 447 0.15%
R Bank CD 0.60% 12/31/22 06/30/21 1,001,530 1,001,530 100.00 1,001,530 457 0.60%
September 30, 2021
City of Georgetown Valley View Consulting, L.L.C.444
City - Investment Holdings
Coupon/ Maturity Settlement Face Amount/ Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day) Yield
September 30, 2021
Bank OZK CD 0.18% 02/23/23 08/23/21 4,200,646 4,200,646 100.00 4,200,646 511 0.18%
Veritex Community Bank CD 0.18% 03/09/23 09/09/21 4,000,000 4,000,000 100.00 4,000,000 525 0.18%
Prosperity Bank CD 0.20% 04/24/23 04/23/21 5,004,193 5,004,193 100.00 5,004,193 571 0.20%
Prosperity Bank CD 0.20% 05/01/23 05/25/21 5,003,371 5,003,371 100.00 5,003,371 578 0.20%
Bank OZK CD 0.20% 06/12/23 06/11/21 5,013,797 5,013,797 100.00 5,013,797 620 0.20%
R Bank CD 0.73% 06/30/23 06/30/21 1,001,842 1,001,842 100.00 1,001,842 638 0.73%
Veritex Community Bank CD 0.25% 09/25/23 09/24/21 10,000,000 10,000,000 100.00 10,000,000 725 0.25%
TOTALS 377,319,060$ 377,319,060$ 377,319,060$ 113 0.13%
(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.545
City - Book & Market Value Comparison
Issuer/Description Yield Maturity
Date
Book Value
06/30/21 Increases Decreases Book Value
09/30/21
Market Value
06/30/21
Change in
Market Value
Market Value
09/30/21
JPMorgan Chase Cash 0.22%10/01/21 23,547,685$ –$ (576,960)$ 22,970,725$ 23,547,685$ (576,960)$ 22,970,725$
JPMorgan Chase MMA 0.03%10/01/21 434,080 33 – 434,113 434,080 33 434,113
Veritex Community Bank M 0.08%10/01/21 3,213,925 648 – 3,214,573 3,213,925 648 3,214,573
NexBank MMA 0.40%10/01/21 7,380,457 7,444 – 7,387,900 7,380,457 7,444 7,387,900
Texas Capital Bank MMA 0.20%10/01/21 12,000,920 6,050 – 12,006,970 12,000,920 6,050 12,006,970
TexPool 0.03%10/01/21 57,019,665 9,851,064 – 66,870,729 57,019,665 9,851,064 66,870,729
TexSTAR 0.01%10/01/21 117,829,027 9,958,481 – 127,787,508 117,829,027 9,958,481 127,787,508
Prosperity Bank CD 0.60%07/01/21 4,018,010 – (4,018,010) – 4,018,010 (4,018,010) –
Prosperity Bank CD 0.70%07/15/21 5,026,275 – (5,026,275) – 5,026,275 (5,026,275) –
Prosperity Bank CD 0.15%08/10/21 3,001,480 – (3,001,480) – 3,001,480 (3,001,480) –
Prosperity Bank CD 0.40%08/23/21 6,263,799 – (6,263,799) – 6,263,799 (6,263,799) –
R Bank CD 0.47%08/25/21 2,002,293 – (2,002,293) – 2,002,293 (2,002,293) –
East West Bank CD 0.26%09/09/21 4,075,095 – (4,075,095) – 4,075,095 (4,075,095) –
East West Bank CD 0.21%10/08/21 5,005,008 2,650 – 5,007,658 5,005,008 2,650 5,007,658
Prosperity Bank CD 0.30%10/14/21 2,504,993 1,895 – 2,506,888 2,504,993 1,895 2,506,888
Independent Bank CD 0.40%10/18/21 2,551,673 2,545 – 2,554,218 2,551,673 2,545 2,554,218
Prosperity Bank CD 0.30%11/22/21 3,005,228 2,273 – 3,007,501 3,005,228 2,273 3,007,501
Texas Regional Bank CD 0.25%12/07/21 3,001,890 1,892 – 3,003,782 3,001,890 1,892 3,003,782
East West Bank CD 0.21%12/30/21 3,003,160 1,590 – 3,004,750 3,003,160 1,590 3,004,750
East West Bank CD 0.21%01/07/22 5,005,008 2,650 – 5,007,658 5,005,008 2,650 5,007,658
Prosperity Bank CD 0.30%01/21/22 4,007,990 3,031 – 4,011,021 4,007,990 3,031 4,011,021
East West Bank CD 0.10%02/01/22 2,000,285 504 – 2,000,789 2,000,285 504 2,000,789
Independent Bank CD 0.40%02/05/22 3,002,905 3,028 – 3,005,933 3,002,905 3,028 3,005,933
Independent Bank CD 0.40%02/08/22 5,004,822 5,046 – 5,009,868 5,004,822 5,046 5,009,868
Prosperity Bank CD 0.15%02/10/22 – 3,002,615 – 3,002,615 – 3,002,615 3,002,615
R Bank CD 0.63%02/25/22 2,003,075 3,183 – 2,006,258 2,003,075 3,183 2,006,258
Prosperity Bank CD 0.15%03/21/22 – 5,000,000 – 5,000,000 – 5,000,000 5,000,000
Prosperity Bank CD 0.35%04/21/22 2,505,827 2,211 – 2,508,038 2,505,827 2,211 2,508,038
Independent Bank CD 0.30%04/22/22 4,211,849 3,150 – 4,215,000 4,211,849 3,150 4,215,000
Independent Bank CD 0.35%05/09/22 4,003,414 3,532 – 4,006,945 4,003,414 3,532 4,006,945
Prosperity Bank CD 0.35%05/17/22 2,004,067 1,768 – 2,005,835 2,004,067 1,768 2,005,835
Prosperity Bank CD 0.20%06/13/22 5,000,000 2,521 – 5,002,521 5,000,000 2,521 5,002,521
Prosperity Bank CD 0.20%07/01/22 – 4,025,388 – 4,025,388 – 4,025,388 4,025,388
Prosperity Bank CD 0.20%07/25/22 5,001,671 2,522 – 5,004,193 5,001,671 2,522 5,004,193
Prosperity Bank CD 0.20%08/01/22 5,000,849 2,521 – 5,003,371 5,000,849 2,521 5,003,371
Prosperity Bank CD 0.35%08/22/22 2,505,084 2,211 – 2,507,294 2,505,084 2,211 2,507,294
Prosperity Bank CD 0.20%09/12/22 5,000,000 2,521 – 5,002,521 5,000,000 2,521 5,002,521
Prosperity Bank CD 0.20%10/24/22 5,001,671 2,522 – 5,004,193 5,001,671 2,522 5,004,193
Prosperity Bank CD 0.40%11/17/22 2,004,649 2,022 – 2,006,670 2,004,649 2,022 2,006,670
City of Georgetown Valley View Consulting, L.L.C.747
City - Allocation
Investment
Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
JPMorgan Chase Cash 22,970,725$ 22,970,725$ –$ –$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,113 434,113 – – – – – – –
Veritex Community Bank MMA 3,214,573 3,214,573 – – – – – – –
NexBank MMA 7,387,900 7,387,900 – – – – – – –
Texas Capital Bank MMA 12,006,970 12,006,970 – – – – – – –
TexPool 66,870,729 66,870,729 – – – – – – –
TexSTAR 127,787,508 20,259,237 493,387 2,003,757 137,314 19,522 2,055,756 1,531,919 -
East West Bank CD 10/08/21 5,007,658 5,007,658 – – – – – – –
Prosperity Bank CD 10/14/21 2,506,888 2,506,888 – – – – – – –
Independent Bank CD 10/18/21 2,554,218 2,554,218 – – – – – – –
Prosperity Bank CD 11/22/21 3,007,501 3,007,501 – – – – – – –
Texas Regional Bank CD 12/07/21 3,003,782 – – – – – – – – East West Bank CD 12/30/21 3,004,750 3,004,750 – – – – – – –
East West Bank CD 01/07/22 5,007,658 5,007,658 – – – – – – – Prosperity Bank CD 01/21/22 4,011,021 4,011,021 – – – – – – –
East West Bank CD 02/01/22 2,000,789 – – – – – – – –
Independent Bank CD 02/05/22 3,005,933 3,005,933 – – – – – – –
Independent Bank CD 02/08/22 5,009,868 4,007,894 – – – – – – –
Prosperity Bank CD 02/10/22 3,002,615 – – – – – – – –
R Bank CD 02/25/22 2,006,258 – – – – – – – –
Prosperity Bank CD 03/21/22 5,000,000 5,000,000 – – – – – – –
Prosperity Bank CD 04/21/22 2,508,038 2,508,038 – – – – – – –
Independent Bank CD 04/22/22 4,215,000 4,215,000 – – – – – – – Independent Bank CD 05/09/22 4,006,945 4,006,945 – – – – – – –
Prosperity Bank CD 05/17/22 2,005,835 2,005,835 – – – – – – –
Prosperity Bank CD 06/13/22 5,002,521 5,002,521 – – – – – – –
Prosperity Bank CD 07/01/22 4,025,388 4,025,388 – – – – – – –
Prosperity Bank CD 07/25/22 5,004,193 5,004,193 – – – – – – –
Prosperity Bank CD 08/01/22 5,003,371 5,003,371 – – – – – – –
Prosperity Bank CD 08/22/22 2,507,294 2,507,294 – – – – – – –
Prosperity Bank CD 09/12/22 5,002,521 5,002,521 – – – – – – –
Prosperity Bank CD 10/24/22 5,004,193 5,004,193 – – – – – – – Prosperity Bank CD 11/17/22 2,006,670 2,006,670 – – – – – – –
Prosperity Bank CD 11/23/22 2,000,255 2,000,255 – – – – – – – Prosperity Bank CD 12/21/22 5,000,000 5,000,000 – – – – – – –
R Bank CD 12/31/22 1,001,530 1,001,530 – – – – – – –
Bank OZK CD 02/23/23 4,200,646 4,200,646 – – – – – – –
Veritex Community Bank CD 03/09/23 4,000,000 4,000,000 – – – – – – –
Prosperity Bank CD 04/24/23 5,004,193 5,004,193 – – – – – – –
Prosperity Bank CD 05/01/23 5,003,371 5,003,371 – – – – – – –
Bank OZK CD 06/12/23 5,013,797 5,013,797 – – – – – – –
R Bank CD 06/30/23 1,001,842 1,001,842 – – – – – – –
Veritex Community Bank CD 09/25/23 10,000,000 10,000,000
Totals 377,319,060$ 258,775,372$ 493,387$ 2,003,757$ 137,314$ 19,522$ 2,055,756$ 1,531,919$ –$
Book Value
September 30, 2021
City of Georgetown Valley View Consulting, L.L.C.949
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
NexBank MMA
Texas Capital Bank MMA
TexPool
TexSTAR
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
East West Bank CD 02/01/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
Prosperity Bank CD 02/10/22
R Bank CD 02/25/22
Prosperity Bank CD 03/21/22
Prosperity Bank CD 04/21/22
Independent Bank CD 04/22/22
Independent Bank CD 05/09/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 06/13/22
Prosperity Bank CD 07/01/22
Prosperity Bank CD 07/25/22
Prosperity Bank CD 08/01/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 09/12/22
Prosperity Bank CD 10/24/22
Prosperity Bank CD 11/17/22
Prosperity Bank CD 11/23/22
Prosperity Bank CD 12/21/22
R Bank CD 12/31/22
Bank OZK CD 02/23/23
Veritex Community Bank CD 03/09/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Bank OZK CD 06/12/23
R Bank CD 06/30/23
Veritex Community Bank CD 09/25/23
Totals
Book Value
September 30, 2021
(Continued)
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 Revenue
Electric
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
–$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
1,416,150 270,991 246,578 53,200 97,389 4,761,278 56,703 576,846 349,300
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – 3,003,782 – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – 1,001,974 – – –
– – – – – 3,002,615 – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
1,416,150$ 270,991$ 246,578$ 53,200$ 97,389$ 11,769,648$ 56,703$ 576,846$ 349,300$
City of Georgetown Valley View Consulting, L.L.C.1050
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
NexBank MMA
Texas Capital Bank MMA
TexPool
TexSTAR
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
East West Bank CD 02/01/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
Prosperity Bank CD 02/10/22
R Bank CD 02/25/22
Prosperity Bank CD 03/21/22
Prosperity Bank CD 04/21/22
Independent Bank CD 04/22/22
Independent Bank CD 05/09/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 06/13/22
Prosperity Bank CD 07/01/22
Prosperity Bank CD 07/25/22
Prosperity Bank CD 08/01/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 09/12/22
Prosperity Bank CD 10/24/22
Prosperity Bank CD 11/17/22
Prosperity Bank CD 11/23/22
Prosperity Bank CD 12/21/22
R Bank CD 12/31/22
Bank OZK CD 02/23/23
Veritex Community Bank CD 03/09/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Bank OZK CD 06/12/23
R Bank CD 06/30/23
Veritex Community Bank CD 09/25/23
Totals
Book Value
September 30, 2021
(Continued)
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
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
–$ –$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
1,926,217 6,518,325 – 822,100 1,600,026 488,674 5,402,091 1,646,143 4,156,465 700,025
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – 2,000,789 – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – 2,006,258 – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
1,926,217$ 6,518,325$ -$ 2,828,358$ 1,600,026$ 488,674$ 7,402,880$ 1,646,143$ 4,156,465$ 700,025$
City of Georgetown Valley View Consulting, L.L.C.1151
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
NexBank MMA
Texas Capital Bank MMA
TexPool
TexSTAR
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
East West Bank CD 02/01/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
Prosperity Bank CD 02/10/22
R Bank CD 02/25/22
Prosperity Bank CD 03/21/22
Prosperity Bank CD 04/21/22
Independent Bank CD 04/22/22
Independent Bank CD 05/09/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 06/13/22
Prosperity Bank CD 07/01/22
Prosperity Bank CD 07/25/22
Prosperity Bank CD 08/01/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 09/12/22
Prosperity Bank CD 10/24/22
Prosperity Bank CD 11/17/22
Prosperity Bank CD 11/23/22
Prosperity Bank CD 12/21/22
R Bank CD 12/31/22
Bank OZK CD 02/23/23
Veritex Community Bank CD 03/09/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Bank OZK CD 06/12/23
R Bank CD 06/30/23
Veritex Community Bank CD 09/25/23
Totals
Book Value
September 30, 2021
(Continued)
City - 2021 CO
Fac/Equip/Par
ks
City - 2021
GO Parks
City - 2021
GO Roads
City - 2021A
CO Electric
City - 2021A
CO
Water/WW
City - 2021A
GO Roads
City -
American
Rescue Plan
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
12,533,816 1,000,035 6,264,002 4,983,087 13,402,129 28,000,176 4,014,869
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
12,533,816$ 1,000,035$ 6,264,002$ 4,983,087$ 13,402,129$ 28,000,176$ 4,014,869$
City of Georgetown Valley View Consulting, L.L.C.1252
City - Allocation
September 30, 2021
Market Value Investment
Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
JPMorgan Chase Cash 22,970,725$ 22,970,725$ –$ –$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,113 434,113 – – – – – – –
Veritex Community Bank MMA 3,214,573 3,214,573 – – – – – – –
NexBank MMA 7,387,900 7,387,900 – – – – – – –
Texas Capital Bank MMA 12,006,970 12,006,970 – – – – – – –
TexPool 66,870,729 66,870,729 – – – – – – –
TexSTAR 127,787,508 20,259,237 493,387 2,003,757 137,314 19,522 2,055,756 1,531,919 -
East West Bank CD 10/08/21 5,007,658 5,007,658 – – – – – – –
Prosperity Bank CD 10/14/21 2,506,888 2,506,888 – – – – – – –
Independent Bank CD 10/18/21 2,554,218 2,554,218 – – – – – – –
Prosperity Bank CD 11/22/21 3,007,501 3,007,501 – – – – – – –
Texas Regional Bank CD 12/07/21 3,003,782 – – – – – – – –
East West Bank CD 12/30/21 3,004,750 3,004,750 – – – – – – –
East West Bank CD 01/07/22 5,007,658 5,007,658 – – – – – – –
Prosperity Bank CD 01/21/22 4,011,021 4,011,021 – – – – – – –
East West Bank CD 02/01/22 2,000,789 – – – – – – – –
Independent Bank CD 02/05/22 3,005,933 3,005,933 – – – – – – –
Independent Bank CD 02/08/22 5,009,868 4,007,894 – – – – – – –
Prosperity Bank CD 02/10/22 3,002,615 – – – – – – – –
R Bank CD 02/25/22 2,006,258 – – – – – – – –
Prosperity Bank CD 03/21/22 5,000,000 5,000,000 – – – – – – –
Prosperity Bank CD 04/21/22 2,508,038 2,508,038 – – – – – – –
Independent Bank CD 04/22/22 4,215,000 4,215,000 – – – – – – –
Independent Bank CD 05/09/22 4,006,945 4,006,945 – – – – – – –
Prosperity Bank CD 05/17/22 2,005,835 2,005,835 – – – – – – –
Prosperity Bank CD 06/13/22 5,002,521 5,002,521 – – – – – – –
Prosperity Bank CD 07/01/22 4,025,388 4,025,388 – – – – – – –
Prosperity Bank CD 07/25/22 5,004,193 5,004,193 – – – – – – –
Prosperity Bank CD 08/01/22 5,003,371 5,003,371 – – – – – – –
Prosperity Bank CD 08/22/22 2,507,294 2,507,294 – – – – – – –
Prosperity Bank CD 09/12/22 5,002,521 5,002,521 – – – – – – –
Prosperity Bank CD 10/24/22 5,004,193 5,004,193 – – – – – – –
Prosperity Bank CD 11/17/22 2,006,670 2,006,670 – – – – – – –
Prosperity Bank CD 11/23/22 2,000,255 2,000,255 – – – – – – –
Prosperity Bank CD 12/21/22 5,000,000 5,000,000 – – – – – – –
R Bank CD 12/31/22 1,001,530 1,001,530 – – – – – – –
Bank OZK CD 02/23/23 4,200,646 4,200,646 – – – – – – –
Veritex Community Bank CD 03/09/23 4,000,000 4,000,000 – – – – – – –
Prosperity Bank CD 04/24/23 5,004,193 5,004,193 – – – – – – –
Prosperity Bank CD 05/01/23 5,003,371 5,003,371 – – – – – – –
Bank OZK CD 06/12/23 5,013,797 5,013,797 – – – – – – –
R Bank CD 06/30/23 1,001,842 1,001,842 – – – – – – –
Veritex Community Bank CD 09/25/23 10,000,000 10,000,000 – – – – – – –
Totals 377,319,060$ 258,775,372$ 493,387$ 2,003,757$ 137,314$ 19,522$ 2,055,756$ 1,531,919$ –$
City of Georgetown Valley View Consulting, L.L.C.1353
City - Allocation
September 30, 2021
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
NexBank MMA
Texas Capital Bank MMA
TexPool
TexSTAR
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
East West Bank CD 02/01/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
Prosperity Bank CD 02/10/22
R Bank CD 02/25/22
Prosperity Bank CD 03/21/22
Prosperity Bank CD 04/21/22
Independent Bank CD 04/22/22
Independent Bank CD 05/09/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 06/13/22
Prosperity Bank CD 07/01/22
Prosperity Bank CD 07/25/22
Prosperity Bank CD 08/01/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 09/12/22
Prosperity Bank CD 10/24/22
Prosperity Bank CD 11/17/22
Prosperity Bank CD 11/23/22
Prosperity Bank CD 12/21/22
R Bank CD 12/31/22
Bank OZK CD 02/23/23
Veritex Community Bank CD 03/09/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Bank OZK CD 06/12/23
R Bank CD 06/30/23
Veritex Community Bank CD 09/25/23
Totals
(Continued)
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 Revenue
Electric
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
–$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
1,416,150 270,991 246,578 53,200 97,389 4,761,278 56,703 576,846 349,300
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – 3,003,782 – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – 1,001,974 – – –
– – – – – 3,002,615 – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
1,416,150$ 270,991$ 246,578$ 53,200$ 97,389$ 11,769,648$ 56,703$ 576,846$ 349,300$
City of Georgetown Valley View Consulting, L.L.C.1454
City - Allocation
September 30, 2021
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
NexBank MMA
Texas Capital Bank MMA
TexPool
TexSTAR
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
East West Bank CD 02/01/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
Prosperity Bank CD 02/10/22
R Bank CD 02/25/22
Prosperity Bank CD 03/21/22
Prosperity Bank CD 04/21/22
Independent Bank CD 04/22/22
Independent Bank CD 05/09/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 06/13/22
Prosperity Bank CD 07/01/22
Prosperity Bank CD 07/25/22
Prosperity Bank CD 08/01/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 09/12/22
Prosperity Bank CD 10/24/22
Prosperity Bank CD 11/17/22
Prosperity Bank CD 11/23/22
Prosperity Bank CD 12/21/22
R Bank CD 12/31/22
Bank OZK CD 02/23/23
Veritex Community Bank CD 03/09/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Bank OZK CD 06/12/23
R Bank CD 06/30/23
Veritex Community Bank CD 09/25/23
Totals
(Continued)
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
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
–$ –$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – –
1,926,217 6,518,325 - 822,100 1,600,026 488,674 5,402,091 1,646,143 4,156,465 700,025
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – 2,000,789 – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – 2,006,258 – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
1,926,217$ 6,518,325$ –$ 2,828,358$ 1,600,026$ 488,674$ 7,402,880$ 1,646,143$ 4,156,465$ 700,025$
City of Georgetown Valley View Consulting, L.L.C.1555
City - Allocation
September 30, 2021
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Community Bank MMA
NexBank MMA
Texas Capital Bank MMA
TexPool
TexSTAR
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
East West Bank CD 02/01/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
Prosperity Bank CD 02/10/22
R Bank CD 02/25/22
Prosperity Bank CD 03/21/22
Prosperity Bank CD 04/21/22
Independent Bank CD 04/22/22
Independent Bank CD 05/09/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 06/13/22
Prosperity Bank CD 07/01/22
Prosperity Bank CD 07/25/22
Prosperity Bank CD 08/01/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 09/12/22
Prosperity Bank CD 10/24/22
Prosperity Bank CD 11/17/22
Prosperity Bank CD 11/23/22
Prosperity Bank CD 12/21/22
R Bank CD 12/31/22
Bank OZK CD 02/23/23
Veritex Community Bank CD 03/09/23
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Bank OZK CD 06/12/23
R Bank CD 06/30/23
Veritex Community Bank CD 09/25/23
Totals
(Continued)
City - 2021 CO
Fac/Equip/Par
ks
City - 2021
GO Parks
City - 2021
GO Roads
City - 2021A
CO Electric
City - 2021A
CO
Water/WW
City - 2021A
GO Roads
City -
American
Rescue Plan
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
12,533,816 1,000,035 6,264,002 4,983,087 13,402,129 28,000,176 4,014,869
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
12,533,816$ 1,000,035$ 6,264,002$ 4,983,087$ 13,402,129$ 28,000,176$ 4,014,869$
City of Georgetown Valley View Consulting, L.L.C.1656
City - Allocation
Investment
Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
JPMorgan Chase Cash 23,547,685$ 23,547,685$ –$ –$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,080 434,080 – – – – – – –
Veritex Bank MMA 3,213,925 3,213,925 – – – – – – –
NexBank MMA 7,380,457 7,380,457 – – – – – – –
Texas Capital Bank MMA 12,000,920 12,000,920 – – – – – – –
TexPool 57,019,665 57,019,665 – – – – – – –
TexSTAR 117,829,027 12,317,440 501,925 17,705,596 137,311 41,309 2,508,904 1,531,881 67,908
Prosperity Bank CD 07/01/21 4,018,010 4,018,010 – – – – – – –
Prosperity Bank CD 07/15/21 5,026,275 5,026,275 – – – – – – –
Prosperity Bank CD 08/10/21 3,001,480 – – – – – – – –
Prosperity Bank CD 08/23/21 6,263,799 6,263,799 – – – – – – –
R Bank CD 08/25/21 2,002,293 – – – – – – – – East West Bank CD 09/09/21 4,075,095 4,075,095 – – – – – – –
East West Bank CD 10/08/21 5,005,008 5,005,008 – – – – – – – Prosperity Bank CD 10/14/21 2,504,993 2,504,993 – – – – – – –
Independent Bank CD 10/18/21 2,551,673 2,551,673 – – – – – – –
Prosperity Bank CD 11/22/21 3,005,228 3,005,228 – – – – – – –
Texas Regional Bank CD 12/07/21 3,001,890 – – – – – – – –
East West Bank CD 12/30/21 3,003,160 3,003,160 – – – – – – –
East West Bank CD 01/07/22 5,005,008 5,005,008 – – – – – – –
Prosperity Bank CD 01/21/22 4,007,990 4,007,990 – – – – – – –
East West Bank CD 02/01/22 2,000,285 – – – – – – – –
Independent Bank CD 02/05/22 3,002,905 3,002,905 – – – – – – – Independent Bank CD 02/08/22 5,004,822 4,003,858 – – – – – – –
R Bank CD 02/25/22 2,003,075 – – – – – – – –
Prosperity Bank CD 04/21/22 2,505,827 2,505,827 – – – – – – –
Independent Bank CD 04/22/22 4,211,849 4,211,849 – – – – – – –
Independent Bank CD 05/09/22 4,003,414 4,003,414 – – – – – – –
Prosperity Bank CD 05/17/22 2,004,067 2,004,067 – – – – – – –
Prosperity Bank CD 06/13/22 5,000,000 5,000,000 – – – – – – –
Prosperity Bank CD 07/25/22 5,001,671 5,001,671 – – – – – – –
Prosperity Bank CD 08/01/22 5,000,849 5,000,849 – – – – – – – Prosperity Bank CD 08/22/22 2,505,084 2,505,084 – – – – – – –
Prosperity Bank CD 09/12/22 5,000,000 5,000,000 – – – – – – – Prosperity Bank CD 10/24/22 5,001,671 5,001,671 – – – – – – –
Prosperity Bank CD 11/17/22 2,004,649 2,004,649 – – – – – – –
R Bank CD 12/31/22 1,000,000 1,000,000 – – – – – – –
Prosperity Bank CD 04/24/23 5,001,671 5,001,671 – – – – – – –
Prosperity Bank CD 05/01/23 5,000,849 5,000,849 – – – – – – –
Bank OZK CD 06/12/23 5,011,230 5,011,230 – – – – – – –
R Bank CD 06/30/23 1,000,000 1,000,000 – – – – – – –
Totals 345,161,582$ 226,640,008$ 501,925$ 17,705,596$ 137,311$ 41,309$ 2,508,904$ 1,531,881$ 67,908$
June 30, 2021
Book Value
City of Georgetown Valley View Consulting, L.L.C.1757
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Texas Capital Bank MMA
TexPool
TexSTAR
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
East West Bank CD 02/01/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 04/22/22
Independent Bank CD 05/09/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 06/13/22
Prosperity Bank CD 07/25/22
Prosperity Bank CD 08/01/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 09/12/22
Prosperity Bank CD 10/24/22
Prosperity Bank CD 11/17/22
R Bank CD 12/31/22
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Bank OZK CD 06/12/23
R Bank CD 06/30/23
Totals
June 30, 2021
Book Value
(Continued)
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 Revenue
Electric
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
–$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
1,429,271 1,096,157 246,572 178,455 97,386 4,761,158 56,701 661,264 407,723
– – – – – – – – –
– – – – – – – – –
– – – – – 3,001,480 – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – 3,001,890 – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – 1,000,964 – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
1,429,271$ 1,096,157$ 246,572$ 178,455$ 97,386$ 11,765,493$ 56,701$ 661,264$ 407,723$
City of Georgetown Valley View Consulting, L.L.C.1858
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Texas Capital Bank MMA
TexPool
TexSTAR
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
East West Bank CD 02/01/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 04/22/22
Independent Bank CD 05/09/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 06/13/22
Prosperity Bank CD 07/25/22
Prosperity Bank CD 08/01/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 09/12/22
Prosperity Bank CD 10/24/22
Prosperity Bank CD 11/17/22
R Bank CD 12/31/22
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Bank OZK CD 06/12/23
R Bank CD 06/30/23
Totals
June 30, 2021
Book Value
(Continued)
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
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
–$ –$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
2,373,950 4,571,252 56,100 1,216,369 1,613,640 650,644 6,362,479 4,593,882 4,396,659 700,007
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– 2,002,293 – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – 2,000,285 – – –
– – – – – – – – – –
– – – – – – – – – –
– – – 2,003,075 – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
2,373,950$ 6,573,545$ 56,100$ 3,219,443$ 1,613,640$ 650,644$ 8,362,764$ 4,593,882$ 4,396,659$ 700,007$
City of Georgetown Valley View Consulting, L.L.C.1959
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Texas Capital Bank MMA
TexPool
TexSTAR
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
East West Bank CD 02/01/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 04/22/22
Independent Bank CD 05/09/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 06/13/22
Prosperity Bank CD 07/25/22
Prosperity Bank CD 08/01/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 09/12/22
Prosperity Bank CD 10/24/22
Prosperity Bank CD 11/17/22
R Bank CD 12/31/22
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Bank OZK CD 06/12/23
R Bank CD 06/30/23
Totals
June 30, 2021
Book Value
(Continued)
City - 2021 CO
Fac/Equip/Par
ks
City - 2021
GO Parks
City - 2021
GO Roads
City - 2021A
CO Electric
City - 2021A
CO
Water/WW
City -
American
Rescue Plan
–$ –$ –$ –$ –$ –$
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
12,883,708 1,000,010 6,698,429 6,650,049 16,300,121 4,014,767
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
12,883,708$ 1,000,010$ 6,698,429$ 6,650,049$ 16,300,121$ 4,014,767$
City of Georgetown Valley View Consulting, L.L.C.2060
City - Allocation
June 30, 2021
Market Value Investment
Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
JPMorgan Chase Cash 23,547,685$ 23,547,685$ –$ –$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,080 434,080 – – – – – – –
Veritex Bank MMA 3,213,925 3,213,925 – – – – – – –
NexBank MMA 7,380,457 7,380,457 – – – – – – –
Texas Capital Bank MMA 12,000,920 12,000,920 – – – – – – –
TexPool 57,019,665 57,019,665 – – – – – – –
TexSTAR 117,829,027 12,317,440 501,925 17,705,596 137,311 41,309 2,508,904 1,531,881 67,908
Prosperity Bank CD 07/01/21 4,018,010 4,018,010 – – – – – – –
Prosperity Bank CD 07/15/21 5,026,275 5,026,275 – – – – – – –
Prosperity Bank CD 08/10/21 3,001,480 – – – – – – – –
Prosperity Bank CD 08/23/21 6,263,799 6,263,799 – – – – – – –
R Bank CD 08/25/21 2,002,293 – – – – – – – –
East West Bank CD 09/09/21 4,075,095 4,075,095 – – – – – – –
East West Bank CD 10/08/21 5,005,008 5,005,008 – – – – – – –
Prosperity Bank CD 10/14/21 2,504,993 2,504,993 – – – – – – –
Independent Bank CD 10/18/21 2,551,673 2,551,673 – – – – – – –
Prosperity Bank CD 11/22/21 3,005,228 3,005,228 – – – – – – –
Texas Regional Bank CD 12/07/21 3,001,890 – – – – – – – –
East West Bank CD 12/30/21 3,003,160 3,003,160 – – – – – – –
East West Bank CD 01/07/22 5,005,008 5,005,008 – – – – – – –
Prosperity Bank CD 01/21/22 4,007,990 4,007,990 – – – – – – –
East West Bank CD 02/01/22 2,000,285 – – – – – – – –
Independent Bank CD 02/05/22 3,002,905 3,002,905 – – – – – – –
Independent Bank CD 02/08/22 5,004,822 4,003,858 – – – – – – –
R Bank CD 02/25/22 2,003,075 – – – – – – – –
Prosperity Bank CD 04/21/22 2,505,827 2,505,827 – – – – – – –
Independent Bank CD 04/22/22 4,211,849 4,211,849 – – – – – – –
Independent Bank CD 05/09/22 4,003,414 4,003,414 – – – – – – –
Prosperity Bank CD 05/17/22 2,004,067 2,004,067 – – – – – – –
Prosperity Bank CD 06/13/22 5,000,000 5,000,000 – – – – – – –
Prosperity Bank CD 07/25/22 5,001,671 5,001,671 – – – – – – –
Prosperity Bank CD 08/01/22 5,000,849 5,000,849 – – – – – – –
Prosperity Bank CD 08/22/22 2,505,084 2,505,084 – – – – – – –
Prosperity Bank CD 09/12/22 5,000,000 5,000,000 – – – – – – –
Prosperity Bank CD 10/24/22 5,001,671 5,001,671 – – – – – – –
Prosperity Bank CD 11/17/22 2,004,649 2,004,649 – – – – – – –
R Bank CD 12/31/22 1,000,000 1,000,000 – – – – – – –
Prosperity Bank CD 04/24/23 5,001,671 5,001,671 – – – – – – –
Prosperity Bank CD 05/01/23 5,000,849 5,000,849 – – – – – – –
Bank OZK CD 06/12/23 5,011,230 5,011,230 – – – – – – –
R Bank CD 06/30/23 1,000,000 1,000,000 – – – – – – –
Totals 345,161,582$ 226,640,008$ 501,925$ 17,705,596$ 137,311$ 41,309$ 2,508,904$ 1,531,881$ 67,908$
City of Georgetown Valley View Consulting, L.L.C.2161
City - Allocation
June 30, 2021
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Texas Capital Bank MMA
TexPool
TexSTAR
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
East West Bank CD 02/01/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 04/22/22
Independent Bank CD 05/09/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 06/13/22
Prosperity Bank CD 07/25/22
Prosperity Bank CD 08/01/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 09/12/22
Prosperity Bank CD 10/24/22
Prosperity Bank CD 11/17/22
R Bank CD 12/31/22
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Bank OZK CD 06/12/23
R Bank CD 06/30/23
Totals
(Continued)
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 Revenue
Electric
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
–$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
1,429,271 1,096,157 246,572 178,455 97,386 4,761,158 56,701 661,264 407,723
– – – – – – – – –
– – – – – – – – –
– – – – – 3,001,480 – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – 3,001,890 – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – 1,000,964 – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
– – – – – – – – –
1,429,271$ 1,096,157$ 246,572$ 178,455$ 97,386$ 11,765,493$ 56,701$ 661,264$ 407,723$
City of Georgetown Valley View Consulting, L.L.C.2262
City - Allocation
June 30, 2021
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Texas Capital Bank MMA
TexPool
TexSTAR
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
East West Bank CD 02/01/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 04/22/22
Independent Bank CD 05/09/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 06/13/22
Prosperity Bank CD 07/25/22
Prosperity Bank CD 08/01/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 09/12/22
Prosperity Bank CD 10/24/22
Prosperity Bank CD 11/17/22
R Bank CD 12/31/22
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Bank OZK CD 06/12/23
R Bank CD 06/30/23
Totals
(Continued)
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
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
–$ –$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – –
2,373,950 4,571,252 56,100 1,216,369 1,613,640 650,644 6,362,479 4,593,882 4,396,659 700,007
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– 2,002,293 – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – 2,000,285 – – –
– – – – – – – – – –
– – – – – – – – – –
– – – 2,003,075 – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
2,373,950$ 6,573,545$ 56,100$ 3,219,443$ 1,613,640$ 650,644$ 8,362,764$ 4,593,882$ 4,396,659$ 700,007$
City of Georgetown Valley View Consulting, L.L.C.2363
City - Allocation
June 30, 2021
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Texas Capital Bank MMA
TexPool
TexSTAR
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
East West Bank CD 02/01/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 04/22/22
Independent Bank CD 05/09/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 06/13/22
Prosperity Bank CD 07/25/22
Prosperity Bank CD 08/01/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 09/12/22
Prosperity Bank CD 10/24/22
Prosperity Bank CD 11/17/22
R Bank CD 12/31/22
Prosperity Bank CD 04/24/23
Prosperity Bank CD 05/01/23
Bank OZK CD 06/12/23
R Bank CD 06/30/23
Totals
(Continued)
City - 2021 CO
Fac/Equip/Par
ks
City - 2021
GO Parks
City - 2021
GO Roads
City - 2021A
CO Electric
City - 2021A
CO
Water/WW
City -
American
Rescue Plan
–$ –$ –$ –$ –$ –$
– – – – – –
– – – – – –
– – – – – –
– – – – – –
12,883,708 1,000,010 6,698,429 6,650,049 16,300,121 4,014,767
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
12,883,708$ 1,000,010$ 6,698,429$ 6,650,049$ 16,300,121$ 4,014,767$
City of Georgetown Valley View Consulting, L.L.C.2464
Georgetown Economic Development Corporation (GEDCO)
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
September 30, 2021
Prepared by
Valley View Consulting, L.L.C.
The investment portfolio of the Georgetown Economic Development Corporation (GEDCO) is in compliance with
the Texas Public Funds Investment Act and the Investment Policy and Strategies.
Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or
completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from
sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective of
current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total return
yields and do not account for investment advisor fees.
65
Annual Comparison of Portfolio Performance
FYE Results by Investment Category:
Asset Type Ave. Yield Book Value Market Value Ave. Yield Book Value Market Value
MMA 0.20%2,129,054$ 2,129,054$ 0.08%2,131,487$ 2,131,487$
Pools 0.14%5,746,114 5,746,114 0.01%5,515,983 5,515,983
Certificates of Deposit 1.70%2,016,943 2,016,943 0.24%2,002,381 2,002,381
Totals 9,892,111$ 9,892,111$ 9,649,850$ 9,649,850$
Fourth Quarter-End Yield 0.47%0.08%
Average Quarter-End Yields (1):
2020 Fiscal Year 2021 Fiscal Year
GEDCO 0.98%0.16%
Rolling Three Month Treasury 0.76%0.06%
Rolling Six Month Treasury 0.99%0.08%
TexPool 0.75%0.04%
(1) Average Quarterly Yield calculated using quarter-end report average yield and adjusted book value.
September 30, 2020 September 30, 2021
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.166
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
MMA 2,131,057$ 2,131,057$ 2,131,487$ 2,131,487$ 0.08%
Pools 7,601,901 7,601,901 5,515,983 5,515,983 0.01%
Certificates of Deposit 2,001,170 2,001,170 2,002,381 2,002,381 0.24%
11,734,129$ 11,734,129$ 9,649,850$ 9,649,850$ 0.08%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.08%Total Portfolio 0.16%
Rolling Three Month Treasury 0.05%Rolling Three Month Treasury 0.06%
Rolling Six Month Treasury 0.05%Rolling Six Month Treasury 0.08%
TexPool 0.03%TexPool 0.04%
Interest income provided in separate report.
June 30, 2021
(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.
September 30, 2021
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.267
Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
Veritex Bank MMA 0.08%10/01/21 09/30/21 2,131,487$ 2,131,487$ 1.00 2,131,487$ 1 0.08%
TexasDAILY AAAm 0.02%10/01/21 09/30/21 2,125,934 2,125,934 1.00 2,125,934 1 0.02%
TexSTAR AAAm 0.01%10/01/21 09/30/21 3,390,049 3,390,049 1.00 3,390,049 1 0.01%
Veritex Bank CD 0.24%8/5/2022 02/08/21 2,002,381 2,002,381 100.00 2,002,381 309 0.24%
9,649,850$ 9,649,850$ 9,649,850$ 65 0.08%
(1)(2)
September 30, 2021
(1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity.
(2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees
are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds.
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.469
Georgetown Transportation Enhancement Corporation (GTEC)
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
September 30, 2021
Prepared byValley View Consulting, L.L.C.
The investment portfolio of the Georgetown Transportation Enhancement Corporation (GTEC) is in compliance
with the Texas Public Funds Investment Act and the Investment Policy and Strategies.
Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or
completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from
sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective
of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total
return yields and do not account for investment advisor fees.
72
FYE Results by Investment Category:
Asset Type Ave. Yield Book Value Market Value Ave. Yield Book Value Market Value
Pools/MMAs 0.15%26,283,802$ 26,283,802$ 0.02%34,752,525$ 34,752,525$
CDs/Securities 0.40%3,001,377 3,001,377 0.15%3,012,460 3,012,460
Totals 29,285,179$ 29,285,179$ 37,764,985$ 37,764,985$
Fourth Quarter-End Yield 0.17%0.03%
Average Quarter-End Yields (1):
2021 Fiscal Year 2021 Fiscal Year
GTEC 0.97%0.06%
Rolling Three Month Treasury 0.76%0.06%
Rolling Six Month Treasury 0.99%0.08%
TexPool 0.76%0.04%
(1) Average Quarterly Yield calculated using quarter-end report average yield and adjusted book value.
Annual Comparison of Portfolio Performance
September 30, 2020 September 30, 2021
Georgetown Transportation Enhancement Corporation (GTEC) Valley View Consulting, L.L.C.
173
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Pools/MMAs 39,417,553$ 39,417,553$ 34,752,525$ 34,752,525$ 0.02%
CDs/Securities 3,009,998 3,009,998 3,012,460 3,012,460 0.15%Totals 42,427,551$ 42,427,551$ 37,764,985$ 37,764,985$ 0.03%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.03%Total Portfolio 0.06%
Rolling Three Month Treasury 0.05%Rolling Three Month Treasury 0.06%
Rolling Six Month Treasury 0.05%Rolling Six Month Treasury 0.08%
TexPool 0.03%TexPool 0.04%
Interest data provided in separate report.
June 30, 2021
(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.
September 30, 2021
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.274
Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
TexPool AAAm 0.03%10/01/21 09/30/21 16,970,004$ 16,970,004$ 1.00 16,970,004$ 1 0.03%
TexSTAR AAAm 0.01%10/01/21 09/30/21 15,092,976 15,092,976 1.00 15,092,976 1 0.01%
Veritex Bank MMA 0.08%10/01/21 09/30/21 2,689,545 2,689,545 1.00 2,689,545 1 0.08%
Prosperity Bank CD 0.15%08/23/22 08/23/21 3,012,460 3,012,460 100.00 3,012,460 327 0.15%
TOTALS 37,764,985$ 37,764,985$ 37,764,985$ 27 0.03%
(1)(2)
September 30, 2021
(1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity.
(2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not
considered. The yield for the reporting month is used for bank accounts, pools, and money market funds.
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.476
Department Federal Grantor Pass-Through Agency Identifying Number COG Name/Purpose YTD Expenditures YTD Revenue Recognized
Airport N/A Texas Department of Transportation-Aviation M1914GEOR RAMP Grant - Routine Airport Maintenance Program 108,353.80 50,000.00
Airport FEMA Texas Department of
Transportation - Aviation
Airport CARES Funding 156,980.34 156,980.34
Emergency Management FEMA Williamson County WILCO Forward - CARES
Funding for COVID-19
96,260.00 96,260.00
Emergency Management US Dept. of the Treasury American Rescue Plan Act SLFRF Funding 87,771.00 87,771.00
Fire Department of Health & Human Services CMS (Centers for Medicare &
Medicaid Services)
EMS CARES Round 1 76,182.00 -
Fire FEMA Travis County EMW-2019-FG-01607 FY2019 Assistance to Firefighters Grant 347,130.26 315,573.00
Fire US Department of Homeland Security Federal Emergency
Management Agency
EMW-2017-FH-00496 SAFER 1,078,589.29 467,718.59
Library National Endowment for the Arts National Endowment for the
Arts
COVID Relief Funding 9,534.00 3,990.11
Planning US Department of Housing & Urban Development Williamson County CDBG Home Repair 43,059.77 40,920.32
Police US. Department of Justice N/A TX2460200 Equitable Sharing Agreement 25,523.52 34,920.95
Police US. Department of Justice Texas Office of the Attorney General 2018-MC-FX-K065 Internet Crimes Against Children 23,583.00 23,583.00
Public Works Dept. of Transportation /Federal Highway
Administration
Texas Department of
Transportation
CSJ-0914-05-187 Highway Planning &
Construction (Austin Ave
Bridge)
15,763.61 -
Public Works Dept. of Transportation /Federal Highway
Administration
Texas Department of
Transportation
CSJ-0914-05-200,201,202 Highway Planning &
Construction (Williams Dr
Corridor)
- -
Division Grantor COG Name/Purpose Status
Emergency Management FEMA TDEM DR-4586 Winter Storm Uri Recovery
CITY OF GEORGETOWN
Grant/Federal Funding Report
as of September 30, 2021
Active
Applications Pending Award
Under FEMA Review
79
CITY OF GEORGETOWN CIP Project Budget Total Spend Remaining Budget Percent Remaining
Airport
Airport - Self Managed
PRJ000197 Hangar Mainenance 240,000 - 240,000 100.00%
PRJ000198 Pavement Maintenance 60,000 - 60,000 100.00%
PRJ000199 Wildlife Management 150,000 18,000 132,000 88.00%
Airport - Self Managed Total 450,000 18,000 432,000 288.00%
Management Services
PRJ000184 Airport Maintenance Facility 750,000 - 750,000 100.00%
Management Services Total 750,000 - 750,000 100.00%
Airport Total 1,200,000 18,000 1,182,000 388.00%
CDBG
CDBG
PRJ000003 17th Street 193,000 175,137 17,863 9.26%
PRJ000144 Maple Street (Inactive) 80,784 - 80,784 100.00%
PRJ000248 21st W/WW offsite CDBG 97,000 - 97,000 100.00%
CDBG Total 370,784 175,137 195,647 209.26%
CDBG Total 370,784 175,137 195,647 209.26%
Downtown TIRZ
Parks
PRJ000050 Grace Heritage Plaza (Inactive) 139,100 45,900 93,200 67.00%
Parks Total 139,100 45,900 93,200 67.00%
Downtown TIRZ Total 139,100 45,900 93,200 67.00%
Electric Services
Electric
PRJ000022 Consultant Engineering 271,352 68,754 202,599 74.66%
PRJ000026 Db Wood Sh29 Intersection 240,000 170,413 69,587 77.63%
PRJ000036 Electrical System Improvement 100,000 20,045 79,955 79.96%
PRJ000040 Fiber Optic (Inactive) 19,516 19,516 - 0.00%
PRJ000062 New Development Projects 9,851,744 5,777,709 4,074,035 53.18%
PRJ000073 Power Quality Improvements 50,000 - 50,000 100.00%
PRJ000095 Shell Road Feeders (Inactive)160,000 181,545 (21,545) 50.97%
PRJ000147 Sectionalization Improvements 1,100,000 - 1,100,000 100.00%
PRJ000175 I-35 Mobility Project TxDot 200,000 269,118 (69,118) -14.64%
PRJ000189 Ronald Reagan - Glasscock Feeder Extension along Hwy 195 -Phase I 560,000 32,284 527,716 94.24%
PRJ000192 Ronald Reagan - Glasscock Feeder extension along Hwy 195 - Phase II 591,250 249,738 341,512 57.76%
PRJ000195 Downtown Overhead Rehab 2,400,000 70,907 2,329,093 97.05%
PRJ000221 Titan-Aviation Dr to IH35 Infrastructure Addition 1,000,000 263,697 736,303 73.63%
PRJ000222 Electric Design Software Replacement 80,000 - 80,000 100.00%
PRJ000225 Chapel Hill, WS-11139 (GEO-45-C.3)437,577 57,523 380,054 86.85%
PRJ000226 Wolf Ranch West - Section 1AG & 1BG 479,052 33,405 445,647 93.03%
PRJ000227 Ascend Westinghouse Apartments 444,598 29,165 415,432 93.44%
PRJ000229 Sun City NH 76 WS-11188 (GEO-18.2-N.51)274,030 191,672 82,359 30.05%
PRJ000230 Sun City NH 78 296,400 19,601 276,799 93.39%
PRJ000231 Georgetown Titan Development 1 & 2 140,428 107,537 32,891 23.42%
PRJ000232 Texas Outdoor Power Building 1 91,414 62,745 28,669 31.36%
PRJ000234 Summit at Westinghouse Self-Storage 49,685 5,855 43,830 88.22%
PRJ000236 Medcore (Georgetown) Senior Living 226,972 202,637 24,334 10.72%
PRJ000238 The Oscar at Georgetown 366,351 19,689 346,661 94.63%
PRJ000239 Wolf Ranch West - Section 3 - Phase 2 418,339 24,554 393,786 94.13%
PRJ000242 Allora North Georgetown 557,422 34,792 522,630 93.76%
PRJ000243 Fairfield Inn - WS11346 131,340 40,979 90,362 68.80%
PRJ000245 Morgan Mays Street Apartments 452,508 - 452,508 100.00%
PRJ000246 Vida Apartments 198,248 - 198,248 100.00%
PRJ000250 Georgetown Infiniti 135,633 - 135,633 100.00%
PRJ000272 Wolf Lakes - 43,764 (43,764) 0.00%
PRJ000273 The Grove II Townhomes 108,924 - 108,924 100.00%
PRJ000282 ANB Systems - Interconnection Service Portal 80,000 4,991 75,009 93.76%
Electric Total 21,512,783 8,002,635 13,510,147 2339.99%
Electric Services Total 21,512,783 8,002,635 13,510,147 2339.99%
General Capital Projects
Environmental Services
PRJ000116 Transfer Station 11,000,000 795,541 10,204,459 92.77%
Environmental Services Total 11,000,000 795,541 10,204,459 92.77%
Finance
PRJ000038 ERP Project 6,231,654 5,895,528 336,126 5.39%
Finance Total 6,231,654 5,895,528 336,126 5.39%
Fire
PRJ000134 SCBA Replacement 1,170,000 - 1,170,000 100.00%
PRJ000135 Cardiac Monitors 483,517 483,517 - 0.00%
Fire Total 1,653,517 483,517 1,170,000 100.00%
Fleet
PRJ000124 Radio Replacement 938,278 179,219 759,059 80.90%
80
CITY OF GEORGETOWN CIP Project Budget Total Spend Remaining Budget Percent Remaining
Fleet Total 938,278 179,219 759,059 80.90%
GTEC Department
PRJ000203 FM1460 Widening 300,984 - 300,984 100.00%
PRJ000206 NB Front Rd (2338 To Lakeway)216,000 221,766 (5,766) -2.67%
GTEC Department Total 516,984 221,766 295,218 97.33%
Management Services
PRJ000028 Downtown Parking Expansion 712,776 701,947 10,830 8.86%
PRJ000029 Downtown Parking Garage 291,483 118,340 173,143 59.40%
PRJ000033 Dtwn Landsping & Public Art (Inactive) 5,746 5,746 - 0.00%
PRJ000037 EOC Siren System 15,525 (8,564) 24,089 155.16%
PRJ000042 Fire Station 6 5,500,000 5,322,599 177,401 3.23%
PRJ000043 Fire Station 7 7,198,744 6,463,450 735,295 10.21%
PRJ000067 Parking Improvements 68,510 - 68,510 100.00%
PRJ000131 Fuel Station 1,100,000 21,381 1,078,619 98.06%
PRJ000136 GMC Remodel Phase I 500,000 130,635 369,365 73.87%
PRJ000178 Public Safety Operation and Training Center Phase II 4,500,000 14,690 4,485,310 99.67%
PRJ000179 Recreation Center Teen/Senior Renovation 215,525 - 215,525 100.00%
PRJ000180 Recreation Center Natatorium HVAC Replacement 700,000 667,546 32,454 4.64%
PRJ000191 Georgetown City Center - Festival/Public Space 5,400,000 30,524 5,369,476 99.44%
PRJ000223 City Center Signage 125,000 - 125,000 100.00%
Management Services Total 26,333,310 13,468,293 12,865,016 912.55%
Parks
PRJ000048 Garey Park 15,346,730 15,100,250 246,480 1.61%
PRJ000089 San Gabriel Park Improvement 13,025,000 7,384,382 5,640,618 43.31%
PRJ000125 Parks Master Plan 229,998 137,883 92,115 40.05%
PRJ000126 Regional Trail Development 1,275,000 88,551 1,186,449 93.05%
PRJ000127 Neighborhood Park Development (Inactive) 240,541 240,541 - 0.00%
PRJ000129 Ada Transition Plan 1,075,982 469,851 606,131 56.33%
PRJ000130 Tennis Center Pool Demo (Inactive) 39,076 - 39,076 100.00%
PRJ000190 Heritage Gardens 275,860 63,810 212,050 76.87%
PRJ000205 Katy Crossing Trail (Inactive)700,000 500,181 199,819 28.55%
PRJ000240 South Main Plaza 272,450 9,950 262,500 96.35%
PRJ000244 Grace Heritage Plaza 90,000 90,000 - 0.00%
Parks Total 32,570,638 24,085,399 8,485,238 536.11%
Police
PRJ000133 Body Cameras 800,000 737,412 62,588 13.49%
Police Total 800,000 737,412 62,588 13.49%
Public Works - Self Managed Department
PRJ000204 Historic District Street Signs - - - 0.00%
Public Works - Self Managed Department Total - - - 0.00%
Public Works Department
PRJ000013 Austin Avenue Bridge 2,855,398 1,717,047 1,138,351 74.81%
PRJ000137 Intersection Improvements (Lakeway @ Williams Drive)1,400,000 222,710 1,177,290 84.09%
PRJ000138 Downtown Sidewalks 2,579,978 811,788 1,768,190 68.54%
PRJ000139 Westinghouse - Scenic Lake Traffic Signal 600,000 157,063 442,937 73.82%
PRJ000140 Austin Ave Bridges 10,184,000 - 10,184,000 100.00%
PRJ000141 Southwestern Blvd 4,200,000 722,527 3,477,473 82.80%
PRJ000143 Leander Rd(Norwood-Swbypass)6,750,000 260,777 6,489,223 96.14%
PRJ000171 Shell Rd Sidewalk (Inactive)229,825 203,755 26,070 11.34%
PRJ000188 DB Wood (SH 29 to Oak Ridge)18,000,000 692,087 17,307,913 96.16%
PRJ000201 Austin Ave. (Sh29-Fm2243)466,000 466,000 - 0.00%
PRJ000202 FM 971 5,821,392 5,262,842 558,550 9.59%
PRJ000207 Northwest Blvd Bridge 12,418,528 11,502,297 916,231 14.88%
PRJ000208 Old Town Northeast 906,159 906,159 - 0.00%
PRJ000209 Southeast Inner Loop 10,521,000 7,966,721 2,554,279 56.08%
PRJ000214 Intersection Improvements (Traffic Signals)1,650,000 303,211 1,346,789 81.62%
PRJ000215 2021 Intersection Safety Enhancements (RRFB)150,000 82,100 67,900 45.27%
PRJ000216 FY21 Downtown Sidewalk Improvements 1,000,000 21,850 978,150 97.82%
PRJ000217 SW Bypass - Wolf Ranch Extension 1,000,000 35,523 964,477 96.45%
PRJ000254 Shell Road 12,503,000 - 12,503,000 100.00%
PRJ000255 Rockride Lane 5,776,000 - 5,776,000 100.00%
PRJ000256 Westinghouse Road 8,200,000 - 8,200,000 100.00%
PRJ000257 Sam Houston Ave Ext/SE1/Wilco Corridor 4,000,000 - 4,000,000 100.00%
PRJ000297 Southeast Inner Loop - MB21 32,061,000 - 32,061,000 100.00%
Public Works Department Total 143,272,279 31,334,457 111,937,822 1589.40%
Right of Way
PRJ000200 Access Rtw To Government Srv 220,000 220,000 - 0.00%
Right of Way Total 220,000 220,000 - 0.00%
General Capital Projects Total 223,536,659 77,421,132 146,115,527 3427.94%
General Fund
Parks
PRJ000055 Katy Crossing Trail (Inactive) 700,000 - 700,000 100.00%
Parks Total 700,000 - 700,000 100.00%
Public Works Department
81
CITY OF GEORGETOWN CIP Project Budget Total Spend Remaining Budget Percent Remaining
PRJ000012 Austin Ave. (Sh29-Fm2243) (Inactive)466,000 - 466,000 100.00%
Public Works Department Total 466,000 - 466,000 100.00%
Right of Way
PRJ000007 Access Rtw To Government Srv 220,000 - 220,000 100.00%
Right of Way Total 220,000 - 220,000 100.00%
General Fund Total 1,386,000 - 1,386,000 300.00%
GTEC
GTEC Department
PRJ000046 FM 971/ Fontana (Nw Bridge) 1,209,000 1,206,390 2,610 0.22%
PRJ000053 IH 35/ Hwy 29 Intersection Imp 1,800,000 120,066 1,679,934 93.33%
PRJ000060 Rabbit Hill Road 4,100,000 134,261 3,965,739 96.73%
PRJ000083 Rivery Tia Improvements 1,179,000 1,094,839 84,161 7.14%
PRJ000092 Se Inner Loop Widening (Inactive) 8,148,000 - 8,148,000 100.00%
PRJ000145 Sh29 Signal And Roadway Improvements 1,595,000 385,134 1,209,866 75.85%
PRJ000146 Wolf Ranch Parkway Extension (Inactive)1,100,000 - 1,100,000 100.00%
PRJ000181 Aviation Drive 10,300,000 1,519,716 8,780,284 97.59%
PRJ000182 Capella 1,500,000 - 1,500,000 100.00%
PRJ000183 Costco 2,000,000 - 2,000,000 100.00%
GTEC Department Total 32,931,000 4,460,407 28,470,593 770.86%
GTEC Total 32,931,000 4,460,407 28,470,593 770.86%
Stormwater
Stormwater
PRJ000004 18th and Hutto Drainage 50,000 5,969 44,031 88.06%
PRJ000005 2nd and Rock Pond (Inactive) 625,000 447,151 177,849 28.46%
PRJ000024 2020 Curb & Gutter 1,055,000 588,673 466,327 44.20%
PRJ000104 Stormwater Infrastructure 347,000 132,438 214,562 61.83%
PRJ000148 Water Quality Ponds (Inactive) 98,000 - 98,000 100.00%
PRJ000149 Drainage Improvement/Flood Mitigation Projects 300,000 - 300,000 100.00%
PRJ000213 2021 Curb & Gutter Project 500,000 46,785 453,215 90.64%
Stormwater Total 2,975,000 1,221,017 1,753,983 513.20%
Stormwater Total 2,975,000 1,221,017 1,753,983 513.20%
Street Tax
Public Works Department
PRJ000172 2020 Street Maintenance High Performance Seal: Bid Package No.1 372,200 349,542 22,658 6.09%
PRJ000173 2020 Street Maintenance High Performance Seal: Bid Package No. 2 463,195 337,719 125,476 27.09%
PRJ000174 2020 street maintenance HIPR 1,935,589 1,191,547 744,042 38.44%
PRJ000210 2021 HIPR Street Maintenance 2,300,000 1,613,020 686,980 29.87%
PRJ000211 2021 High Performance Pavement Seal Project #1 750,000 73,414 676,586 90.21%
PRJ000212 2021 High Performance Pavement Seal Project #2 600,000 56,600 543,400 90.57%
PRJ000237 Northeast Inner Loop (Stadium to FM971) Emergency Repairs 700,000 681,858 18,142 2.59%
Public Works Department Total 7,120,983 4,303,699 2,817,284 284.86%
Street Tax Total 7,120,983 4,303,699 2,817,284 284.86%
Transportation
GTEC Department
PRJ000047 FM1460 Widening (Inactive) 794,000 - 794,000 100.00%
PRJ000061 NB Front Rd (2338 To Lakeway) (Inactive)366,000 - 366,000 200.00%
GTEC Department Total 1,160,000 - 1,160,000 300.00%
Public Works Department
PRJ000045 FM 971 - (26,684) 26,684 0.00%
PRJ000063 Northwest Blvd Bridge 3,509,094 421,578 3,087,516 87.99%
PRJ000065 Old Town Northeast (Inactive) 855,021 (19,064) 874,085 102.23%
PRJ000100 Southeast Inner Loop - - - 0.00%
Public Works Department Total 4,364,115 375,830 3,988,285 190.22%
Transportation Total 5,524,115 375,830 5,148,285 490.22%
Village PID
Parks
PRJ000249 GVPID Landscape Improvements - 21,720 (21,720) 0.00%
Parks Total - 21,720 (21,720) 0.00%
Village PID Total - 21,720 (21,720) 0.00%
Water Services
Water
PRJ000014 Berry Creek Inter.49,949,000 1,301,561 48,647,439 119.39%
PRJ000016 Braun Est (Inactive)1,290,458 1,290,458 - 0.00%
PRJ000017 Cedar Breaks Est 3,385,000 - 3,385,000 100.00%
PRJ000023 Cr 255 (Wd14-2)1,493,963 - 1,493,963 100.00%
PRJ000025 Db Wood/ Pastor 24 Dedicated 440,726 440,726 - 0.00%
PRJ000027 Domel PS Improvements (Inactive)5,816,000 - 5,816,000 100.00%
PRJ000034 Earz 2,326,000 359,655 1,966,345 84.54%
PRJ000057 Lift Station Upgrade 1,723,593 8,593 1,715,000 99.50%
PRJ000059 LWTP Raw Water Intake Rehab 6,750,000 5,369,068 1,380,932 20.46%
82
CITY OF GEORGETOWN CIP Project Budget Total Spend Remaining Budget Percent Remaining
PRJ000066 Park Lift Station & Force Main 3,574,341 2,109,334 1,465,007 40.99%
PRJ000069 Pecan Branch Ph 2 (Inactive) 238,041 238,041 - 0.00%
PRJ000075 Pumps & Storage 9,289 9,289 - 0.00%
PRJ000076 Rabbit Hill Est (Inactive) 1,826,000 873,294 952,706 100.00%
PRJ000085 Ronald Reagan/Daniels Mountain 140,989 140,989 - 0.00%
PRJ000087 S. Lake Wtp 2018 (Inactive) 6,950,000 - 6,950,000 100.00%
PRJ000088 San Gabriel Belt Press and Rehab (Inactive)2,594,238 2,591,167 3,071 0.12%
PRJ000096 Shell Road Water Line 6,890,000 949,010 5,940,990 86.23%
PRJ000101 Southlake Wtp 100,000,000 6,064,878 93,935,122 156.22%
PRJ000103 Stonehedge Ls & Fm (Inactive)150,000 - 150,000 100.00%
PRJ000108 Sun City Elevated Storage Tank (Inactive)3,224,000 - 3,224,000 100.98%
PRJ000110 Sw Bypass Waterline 1,106,000 - 1,106,000 100.00%
PRJ000115 Use PRJ000163 for Tank Rehab (Inactive)- - - 0.00%
PRJ000119 Water Mains 1,536,750 463,125 1,073,625 69.86%
PRJ000121 Westinghouse Ls & Fm (Inactive)3,299,000 - 3,299,000 100.00%
PRJ000122 Westside Facility (Inactive)505,500 - 505,500 100.00%
PRJ000123 WW Interceptors - - - 0.00%
PRJ000150 Carriage Oaks Transmission 600,000 - 600,000 100.00%
PRJ000151 FY2020 CR262 Waterline (Inactive)- - - 0.00%
PRJ000152 Hoover Pump Station 6,850,000 158,986 6,691,014 97.68%
PRJ000153 FY2020 Round Rock Supply Line (Inactive)300,000 - 300,000 100.00%
PRJ000154 Stonewall Ranch Pump Station Improvements 3,100,000 - 3,100,000 100.00%
PRJ000155 Southside Water Treatment Plant 6,426,706 542,693 5,884,013 91.56%
PRJ000156 Gatlin/Teravista Improvements 450,000 - 450,000 100.00%
PRJ000157 Leander Interconnect 340,245 250,745 89,500 26.30%
PRJ000158 West loop (H-1A)447,385 447,385 - 191.11%
PRJ000160 Round Rock Supply Pump Station And Elevated Storage Tank 10,500,000 635,286 9,864,714 100.46%
PRJ000161 Miscellaneous Line Upgrades 1,372,000 568,081 803,919 78.13%
PRJ000162 South West Bypass Water (H24-1)2,906,000 2,184,007 721,993 24.84%
PRJ000163 Tank Rehabilitation 3,372,536 403,437 2,969,099 88.04%
PRJ000164 Council Chamber Water 423,000 15,960 407,040 151.31%
PRJ000165 San Gabriel WWTP Rehabilitation 3,257,307 98,000 3,159,307 96.99%
PRJ000167 San Gabriel Inter SGI -2 4,500,000 - 4,500,000 123.07%
PRJ000168 WWTP Upgrade 950,000 214,907 735,093 93.06%
PRJ000169 FY2020 Lift Station Upgrade (Inactive)- - - 0.00%
PRJ000177 Northlake WTP Phase IV Expansion 15,000,000 2,446,072 12,553,928 83.69%
PRJ000185 Cimarron Hills Wastewater Treatment Plant Expansion 5,300,000 186,205 5,113,795 96.49%
PRJ000186 Water Oak 24" Waterline (Inactive)- - - 0.00%
PRJ000218 EARZ Wastewater Rehabilitation Area 2 - 2019 2,460,360 1,740,295 720,065 29.27%
PRJ000219 Southside GST Foundation Improvements 535,678 - 535,678 100.00%
PRJ000228 Southside GST Roof Rehab 567,000 - 567,000 100.00%
PRJ000241 2020 - 2021 EARZ - Area 3 1,500,000 190,173 1,309,827 87.32%
Water Total 276,377,104 32,291,419 244,085,686 3737.60%
Water Operations
PRJ000220 AMI Western District Improvements 750,000 - 750,000 100.00%
Water Operations Total 750,000 - 750,000 100.00%
Water Services Total 277,127,104 32,291,419 244,835,686 3837.60%
Grand Total 573,823,528 128,336,896 445,486,632 12628.91%
83
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 6/30/21 Status Updates ‐ 9/30/21
Cemetery Special Revenue
Fund Perpetual Reserve
Currently cemetery operations are self‐funded through plot
sales of approximately $50K per year. The cemetery is
managed through Parks Administration. In 2015, Council
elected to transfer $75,000 annually for future costs
associated with maintaining the property. The General Fund
has made this transfer in since FY 2016. While the perpetual
reserve has grown slowly, it is not on pace to sustain the
Cemetery Fund long‐term. The fund is estimated to need a
$5 million balance to be self‐sustaining on interest earnings
and cemetery revenue.
The FY2021 projected ending fund balance is $650,000.
The general fund transfer was restored to the $75,000 in
the FY2022 budget.
No Change. Council gave no direction during the Fiscal
Policy update on reserves not in compliance.
Unfunded Actuarial Accrued
Liability (UAAL)
Recognizes the outstanding liability for the City’s employee
retirement plan through TMRS. The City contributes
monthly to fund the UAAL, based on an annual percentage
of payroll. Actual % of payroll costs is recognized within each
fund. The UAAL is provided by TMRS and lags one year.
As of 9/30/2020, the net pension liability is $18.7 million
and is 88.97% funded. This decrease in liability is due to a
change in the actuarial assumptions.
No change, this report is not yet available.
Other Post Employee Benefits
(OPEB)
While the City has no obligation to offer additional retiree
benefits, retirees are eligible to participate in the City’s
health insurance program. That ability represents a subsidy
that impacts health insurance costs to the City. Retirees pay
their monthly premiums to the self insurance fund, which
then processes their health insurance claims.
OPEB liability as of 9/30/2020 is $2.7 million. This is a
combination of sudden death benefits as well as post‐
retirement healthcare.
No change, this report is not yet available.
Compensated Absence
Future costs associated with benefits such as vacation, and
sick leave for City employees. Compensated Absence is
accrued annually to each proprietary fund type on a GAAP
basis and accounted for on the balance sheet of each fund.
For governmental funds (and for budgetary basis), the
expense is recognized when due and payable. The City
keeps a reserve in the General Fund to help offset large
payouts for long‐term employees. The reserve is used as
needed, and annually replenished or increased based on
known risk.
Compensated absences as of 9/30/2020 are $8.2 million.
More time was earned than used during FY2020 as many
plans were changed related to the pandemic. The City did
not extend any vacation cap carry overs in general. As
with any year, specific requests for carryover are
considered and approved by the City Manager.
No change, this report is not yet available.
CITY OF GEORGETOWN
Long-term Commitments, Reservations, and Other Unfunded Liabilities
9/30/2021
84
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 6/30/21 Status Updates ‐ 9/30/21
Electric Fund Rate Stabilization
Reserve
Intended to mitigate potential rate impacts due to increased
purchased power costs or other external factors. The RSR is
maintained within the Electric Fund.
During the annual review of fiscal policies for the FY2022
budget, Finance and Electric staff recommended updating
the Electric Rate Stabilization Reserve Policy. GGAF and
Council agreed to change the reserve target from 10% of
purchased power costs, to an average of 3 months of
purchased power costs. The Electric Fund FY2021
projected ending fund balance is $32.3 million. Of that,
$18.6 million is reserve for Rate Stabilization, which is a
fully funded reserve.
FY2021 preliminary year‐end fund balance is $40.5
million. The Electric Fund experienced accelerated new
development capital projects and will need a year‐end
budget amendment for 2021 and a revised budget for
2022. After accounting for reserves and capital project
roll forwards, available ending fund balance is projected
to be $3.9 million.
Airport Maintenance
Fund on‐going maintenance of the Airport grounds, runways
and taxi ways. Terminal and Tower included in Facilities ISF.
An Airport Master Plan was developed to address long term
capital maintenance project prioritization.
Continued maintenance on buildings and pavement
surfaces. We will have to do pavement sealing on
Taxiway A to prevent early deterioration. This will include
a seal coat and repainting of all markings. We have
prepared all documentation and supporting evidence for
CRRSA (the 2nd relief grant) for reimbursement. We are
waiting on TxDOT to establish the process. This will be
~$57K. The relief grant has yet to be established by the
FAA. We expect to get another award for that as well.
No change.
Americans with Disabilities Act
(ADA) Compliance Needs
As facilities are built or repurposed, meeting ADA
compliance will be included in Project Costs. Funding for
program expansion will be needed (General Fund sources).
The City has an adopted policy, as required by Federal Law,
that it will make reasonable accommodations and
modifications to ensure that people with disabilities have an
equal opportunity to enjoy its programs, services, and
activities. The City does not maintain a reserve for these
modifications.
ADA trail improvements along the South San Gabriel
Trail have begun and consist of replacement of non‐
compliant sections of trail from Chandler Park to
just west of Interstate 35. ADA improvements to
Summercrest Park, Old Town Park, Edwards Park,
and Bark Park have been completed.
ADA trail improvements along the San Gabriel River
are nearing completion. Planning and design is
underway for areas along the South San Gabriel
River Trail. The final trail and park ADA
improvements are scheduled to be completed in
FY22.
85
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 6/30/21 Status Updates ‐ 9/30/21
Sidewalk Maintenance &
Masterplan
Currently, new sidewalks are built as development occurs.
Repairs are funded as needed or if funding is available,
when major roads are repaired. Useful life of a sidewalk is
estimated at 40 to 50 years. The largest revenue source
comes from the City’s General Fund, but there has been
some debt funding as well.
Rock Sidewalk/FY 20 Downtown ADA Sidewalk
Improvements. Project is in construction. Contractor
working along Rock Street at this time. Should be
completed with the Rock Street area from 9th to 7th by
the end of August and then moving east of Austin Ave on
7th. FY21 Downtown ADA Sidewalk improvements will
be a continuation of Downtown ADA improvements and
closing gaps. Design for this project will begin in May
2021. The mobility bond passed in the May election,
providing new funding over the next 7 years for
sidewalks.
Rock Sidewalk/FY 20 Downtown ADA Sidewalk
Improvements. Project is in construction. Contractor
wrapped up most work along Rock Street. Currently
working at 7th and 8th streets at Austin Ave. Will move
over to 7th and Main area next. FY21 Downtown ADA
Sidewalk improvements will be a continuation of
Downtown ADA improvements and closing gaps.
Design/survey work has begun. The mobility bond passed
in the May election, providing new funding over the next
7 years for sidewalks.
Park Equipment Maintenance
& Replacement
Over the past 5 years, funding for Park Maintenance and
Replacement has increased. $200K transfer from General
Fund included in FY2018 budget. Staff has listed all assets &
developed replacement schedule funded by the General
Fund.
Staff has begun the planning process for redevelopment
of University Park to include playground replacement,
landscape improvements and additional site amenities. A
survey was sent to neighborhood residents and is
currently being reviewed by staff. A neighborhood public
meeting will be scheduled to discuss the survey results in
September. The project budget totals $110,000.
Park maintenance and replacement is funded for
$297,000 in FY22 through a general fund transfer into the
Parks Restricted SRF. Identified repair and replacement
needs total $409,000. Capital repair and maintenance
projects at the Recreation Center, Pinnacle Park and
Raintree Park are scheduled to be completed later in
FY22. Identified repair and replacement costs for FY23
and FY24 are $780,700 and $455,800 respectively.
Radio Equipment Replacement
Communication system consisting of 500 on‐body and in‐
vehicle radios for Police, Fire, parks and utilities.
Replacement radios are compatible with newer technology.
The replacement takes place over 5 years due to cost and is
funded with certificate of obligation debt.
Radios for the Electric, 911 Comms, and GPD have been
received and in the process of issued out to the
departments. Finalizing the radio type (mobile or
portable) for the remaining 35 radio replacements. These
will be ordered by late August early September.
Due to the unexpected retirement of Fleet staff, we were
unable to spend the remaining funds and have asked for
these funds to roll forward to FY22 which was approved.
86
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 6/30/21 Status Updates ‐ 9/30/21
Street Maintenance
The City funds street maintenance in the General Fund,
supplemented by a 1/8th Street Sales Tax special revenue
fund. In 2017 and 2018, the Council and GTAB reviewed
various methods for enhanced street maintenance and
costs. Direction from Council is to use high performance
surface seals and pavement wearing courses and begin
programmatically addressing the street network's deferred
maintenance backlog, creating a need for approximately $2
million more per year for street maintenance.
The FY2022 budget restores $500,000 General Fund
contribution to street maintenance.
Staff received direction from Council on potential uses of
available Street Maintenance sales tax dollars and will
make these updates in an FY2022 budget amendment.
Fiber Asset Allocation
Network fiber infrastructure is installed across the City.
Traditionally, the Electric Fund has installed and maintained
the network. In reviewing all costs for the Electric Fund, the
City has begun moving the fiber asset to the IT Fund. Staff
must develop a multi‐year strategy to complete the asset
transfer and allocate costs for maintenance.
Cost recovery for the Fiber asset transfer was continued
in the FY 2022 budget, with $665,000 being transferred
from the IT internal service fund to the Electric fund.
No change
IT Capital Replacement
Reserve
The purpose of this reserve is to fund the maintenance and
replacement of computer network and other technology
systems. A reserve will be established within the ISF for
replacement of major systems and will be funded over time
through excess revenues within the Fund. The targeted
amount is the average (1/5th) of the next five years on the
replacement schedule.
The IT allocation model continues to be structured in a
way that establishes and maintains a reserve in the ISF.
This fund is $270K short of meeting the reserve
requirement for FY2022.
No Change. Council gave no direction during the Fiscal
Policy update on reserves not in compliance.
87
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 6/30/21 Status Updates ‐ 9/30/21
Facilities Maintenance Reserve
The City has established an on‐going maintenance program,
which includes major repairs, equipment, as well as
contracts for maintaining City facilities. The City has
anticipated a useful life of such equipment and established a
means of charging those costs to the various departments in
order to recognize the City’s continuing costs of maintaining
its facilities. Determination for facility repairs is based on
useful life of the various elements of each facility. A
proportional cost for each element is expensed within the
budget for capital replacement. The targeted replacement
reserve amount is the average (1/5th) of the next five years
on the replacement schedule.
This reserve is $800K short of meeting the reserve
requirement for FY2022.
No Change. Council gave no direction during the Fiscal
Policy update on reserves not in compliance.
Public Safety Equipment
Recurring Line Item Budgets
As part of the City’s on‐going maintenance program, the
City also recognizes the need to regularly maintain and
replace specialized equipment in Police and Fire. Separate
replacement and maintenance schedules will be maintained
for these items including but not limited to for Fire: SCBA’s
and other firefighting equipment and protective gear; and
for Police: bullet proof vests, armaments and other tactical
equipment. The City’s goal is to provide level on‐going
funding to ensure proper protection for employees and
residents. The current funding level is an annual
appropriation in the General Fund of $80,000 for Fire and
$88,000 for Police.
These funding lines were restored in the FY2022 budget. No Change.
Joint Services Fund 90 Day
Operational Contingency
Reserve
A minimum ninety (90) days of operating expenses will be
reserved for unexpected delays in revenue or emergency
expenses.
This fund is $1.1M short of meeting the reserve
requirement for FY2022.
FY2021 preliminary year‐end fund balance is estimated to
be $2.4 million. Council gave no direction during the
Fiscal Policy update on reserves not in compliance. In
FY2022, several staff and services re‐organizations are
shifting costs out of the Joint Services Fund and into the
General Fund and Water Fund. The allocation
methodology and reserve calculations will be updated.
These shifts will help reduce the burden on the unmet
reserve. The Cost Allocation Study results will be
presented to Council in early 2022, which options on how
to fully fund the reserve.
88