HomeMy WebLinkAboutFY 21 - 3rd_Qtr_Report_FY2021_RedactedFINANCIAL REPORT AND INVESTMENT REPORT
For the Quarter Ended June 30, 2021
Table of Contents
Executive Summary .................................................................................................................................. 1-23
General Fund Schedule .......................................................................................................................... 24-25
Electric Fund Schedule ................................................................................................................................ 26
Water Services Fund Schedule .................................................................................................................... 27
Joint Services Fund Schedule ....................................................................................................................... 28
Council Discretionary Fund Schedule .......................................................................................................... 29
Tourism Fund Schedule ............................................................................................................................... 30
Airport Fund Schedule ................................................................................................................................. 31
Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 32
Georgetown Economic Development Corporation Fund Schedule ............................................................. 33
Quarterly Investment Report - City ........................................................................................................ 34-57
Quarterly Investment Report - GEDCO ................................................................................................... 58-63
Quarterly Investment Report - GTEC ...................................................................................................... 64-69
Grant Applications ....................................................................................................................................... 70
Capital Improvement Projects ................................................................................................................ 71-74
Long-term Commitments and Other Unfunded Liabilities ..................................................................... 75-79
II. INVESTMENTS
The investment activity and strategies described in this report comply with the Public Funds Investment
Act (PFIA), the City’s investment policy, and generally accepted accounting principles. Activity for the
third quarter of fiscal year 2021 includes the maturing of financial institution deposits (CDs), reinvestment
of CD’s, investment in a new MMA, receipt of bond proceeds, and investing of consolidated funds in CD’s.
Interest rates for money market accounts, Treasury bills, and CD’s decreased again during this quarter.
We are seeing a decline in rates being submitted for our competitive investment offerings due to no
positive changes in the market. We are also seeing a decline in the number of banks responding to our
investment offerings. The Federal Open Market Committee (FOMC) maintained the Fed Funds target
range at 0.00% to 0.25% (Effective Fed Funds are trading <0.10%), and projects that reduced rates could
remain into 2023. These are the lowest rates we have seen since December 2008. The decrease in
interest from banks was exacerbated in the Third Quarter due to the US Treasury’s release of the billions
of dollars for the American Rescue Plan. The City will continue soliciting for the best rates to improve both
diversity and yield, while keeping in mind safety and liquidity.
The Investment Reports for the quarter ending June 30, 2021, and the supporting schedules are attached.
Valley View Consulting, L.L.C., has prepared the attached investment reports. A component of our
investment advisory services contract includes Valley View preparing the quarterly investment reports on
behalf of the City. A summary of the investment balances as of June 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 63%, debt service at 5%, and bond proceeds at 32%.
CITY Book Value GTEC GEDCO
3/31/21 6/30/21 3/31/21 6/30/21 3/31/21 6/30/21
Total cash
and
investments
$276,385,252 $345,161,582 $33,083,118 $42,427,551 $11,095,498 $11,734,129
Quarter End
Average Yield
.21% .15% .06% .04% .08% .07%
The City’s strategy continues to be matching maturities with cash flow needs, while focusing on the
investment policy’s long‐range goals. The City’s investment strategy is to “ladder” or stagger maturities,
thus minimizing erratic interest rate fluctuations. The City is continuing to manage the yield on bond
proceeds for arbitrage purposes.
The City’s investment portfolio generally includes bank deposits, local government investment pool
balances, money market accounts, and financial institution deposits (CD’s). All of these investments meet
the safety requirements of the PFIA. Local Government Investment Pools must maintain a rating of
AAAm, Securities (Treasury Bills) must have direct or implied backing of the Federal Government and
22
Financial Institution Deposits (CDs and money market accounts) must be collateralized with FDIC
insurance or obligations with an implied backing from the Federal Government. The collateral on all City
investments are monitored monthly to ensure the financial institutions carry minimum collateral of 100%
with a letter of credit or 102% with pledged securities for all of the City’s investments. All securities held
by financial institutions as collateral on behalf of the City have been reviewed and met PFIA‐minimum
rating criteria.
The City continues to work with the City’s depository bank (JPMorgan Chase) to find an average daily
balance that is best to receive the highest yield on the account. These balances earn credit against the
fees charged by the bank. The City will continue to verify depository yield versus investment yield to
achieve the best outcome.
III. CAPITAL IMPROVEMENT PROJECTS
A financial summary of capital improvement projects is attached to this report. With new capability in the
recent financial software implementation, we are providing a Life‐to‐Date picture of all active projects
since many capital projects take multiple fiscal years to construct to completion. With our growing capital
infrastructure implementation portfolio due demand for transportation and water services, City staff
have formed two working groups with the goal of improving work capacity and efficiencies, and
ultimately customer service, related to capital projects. One group is focused on incrementally improving
capital project reporting internally and externally citywide – including financial information as well as
scheduling, geographic location, and other information. The second group is focused on the re‐
organization of development‐related capital improvements from the Systems Engineering department to
the Planning Department. Both groups will continue working through the first quarter of FY2022.
23
General Fund
Period: Jun‐21 Budget Current Period
FY2021 Jun‐21
YTD Actuals w/
Encumbrances 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 461,799 16,323,813 347,308 102.17% 15,996,505 327,309 102.05%
40002:Sales Taxes 18,576,250 2,014,851 13,162,725 (5,413,525) 70.86% 22,924,375 (9,761,650) 57.42%
40005:Franchise Taxes 6,255,270 361,697 4,139,137 (2,116,133) 66.17% 6,182,563 (2,043,426) 66.95%
40008:Other Taxes 400,000 ‐ 150,932 (249,068) 37.73% 410,000 (259,068) 36.81%
41001:Fines 328,392 24,270 188,560 (139,832) 57.42% 290,600 (102,040) 64.89%
41002:Penalties 60,000 8,902 74,664 14,664 124.44% 70,000 4,665 106.66%
42001:Interest Income 75,000 1,967 67,253 (7,747) 89.67% 87,429 (20,176) 76.92%
43001:Fees 7,028,184 802,702 5,349,312 (1,678,872) 76.11% 6,876,306 (1,526,994) 77.79%
43002:Garbage Charges 10,151,764 958,562 8,099,881 (2,051,883) 79.79% 10,300,000 (2,200,120) 78.64%
43003:Permits 4,317,750 447,975 3,927,014 (390,736) 90.95% 4,880,250 (953,237) 80.47%
43004:Administrative Charges 3,396,447 282,708 2,544,376 (852,071) 74.91% 3,396,447 (852,071) 74.91%
43005:Rental Revenue 148,140 16,670 148,231 91 100.06%125,947 22,284 117.69%
45001:Misc Revenue 871,955 2,841 663,347 (208,608) 76.08%804,049 (140,702) 82.50%
45003:Misc Reimbursements ‐ 9,954 9,954 9,954 0.00%‐ 9,954 0.00%
44001:Grant Revenue 679,884 28,530 498,073 (181,811) 73.26%500,000 (1,927) 99.61%
44501:Contribution Revenue ‐ ‐ ‐ ‐ 0.00%‐ ‐ 0.00%
44502:Developer Contributions 423,112 ‐ 423,328 216 100.05% 423,332 (4) 100.00%
44503:Interlocal Agreement Revenue 5,091,091 1,528,738 3,896,283 (1,194,808) 76.53% 5,091,092 (1,194,808) 76.53%
44504:Donations ‐ ‐ ‐ ‐ 0.00% ‐ ‐ 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 895,333 6,821,411 (1,609,964) 80.91% 8,460,467 (1,639,056) 80.63%
Revenue Total 83,206,421 7,847,499 67,483,595 (15,722,826) 81.10% 87,814,662 (20,331,067) 76.85%
Expense
CC0001 Non‐Departmental 1,654,691 1,145 767,545 887,146 46.39% 6,357,848 5,590,303 12.07%
CC0107 Planning 1,978,054 133,648 1,418,785 559,269 71.73% 1,903,216 484,430 74.55%
CC0202 Parks Administration 662,887 50,560 467,925 194,962 70.59% 643,407 175,482 72.73%
CC0210 Library 2,837,904 213,267 2,020,529 817,375 71.20% 2,852,883 832,353 70.82%
CC0211 Parks 2,727,414 202,037 1,970,156 757,257 72.24% 2,640,698 670,541 74.61%
CC0212 Recreation 2,899,381 243,485 2,014,550 884,831 69.48% 2,870,088 855,538 70.19%
CC0213 Tennis Center 442,917 33,390 279,269 163,648 63.05% 421,451 142,182 66.26%
CC0214 Recreation Programs 1,251,370 158,028 602,801 648,569 48.17% 1,093,594 490,793 55.12%
CC0215 Garey Park 982,022 73,291 675,082 306,940 68.74% 974,873 299,791 69.25%
CC0218 Arts and Culture 57,857 4,041 40,250 17,607 69.57% 57,857 17,608 69.57%
CC0316 Municipal Court 585,123 42,324 405,587 179,536 69.32% 556,709 151,122 72.85%
CC0402 Fire Support Services/Administration 4,348,592 295,637 2,806,711 1,541,881 64.54% 3,795,965 989,254 73.94%
CC0422 Fire Emergency Services 15,953,391 1,193,733 11,086,740 4,866,651 69.49% 15,961,522 4,874,782 69.46%
CC0448 EMS 2,580,541 235,756 2,123,373 457,167 82.28% 3,063,614 940,241 69.31%
CC0533 Environmental Services 9,662,924 749,726 6,173,731 3,489,193 63.89% 9,666,349 3,492,618 63.87%
CC0536 Inspection Services 1,547,913 116,593 1,022,357 525,556 66.05% 1,439,273 416,917 71.03%
Year‐End:
Projections Vs. ActualsYear‐to‐Date Actuals Budget Vs. Actuals
24
General Fund
Period: Jun‐21 Budget Current Period
FY2021 Jun‐21
YTD Actuals w/
Encumbrances 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 142,915 1,329,084 564,852 70.18% 1,921,512 592,428 69.17%
CC0605 Community Services 353,889 16,145 299,569 54,320 84.65% 359,411 59,841 83.35%
CC0634 City Council Services 185,734 14,745 145,315 40,419 78.24% 190,992 45,677 76.08%
CC0635 City Secretary Services 1,009,772 93,635 748,123 261,649 74.09% 988,578 240,456 75.68%
CC0638 General Government Contracts 4,774,808 713,681 4,159,360 615,448 87.11% 5,529,569 1,370,209 75.22%
CC0655 Communications/Public Engagement 844,604 43,089 539,039 305,564 63.82% 825,151 286,111 65.33%
CC0702 Police Administration 2,567,848 185,125 1,800,323 767,526 70.11% 2,565,917 765,594 70.16%
CC0742 Police Operations 14,669,105 1,094,080 10,623,277 4,045,829 72.42% 14,508,770 3,885,493 73.22%
CC0744 Animal Services 1,106,702 76,731 681,774 424,928 61.60% 1,046,689 364,914 65.14%
CC0745 Code Compliance 562,740 32,318 359,716 203,024 63.92% 520,890 161,174 69.06%
CC0802 Public Works 1,705,914 77,907 1,342,617 363,297 78.70% 1,632,799 290,182 82.23%
CC0846 Streets 3,137,149 186,463 2,202,440 934,710 70.21% 3,082,495 880,056 71.45%
Expense Total 82,985,180 6,426,702 58,118,749 24,866,431 70.04% 87,477,342 29,358,593 66.44%
Excess (Deficiency) of Total Revenue over Total
Requirements 221,240 1,420,797 9,364,846 9,143,606 4232.89% 337,319 9,027,527 2776.25%
Ending Fund Balance 21,417,850 30,561,456 9,143,606 142.69% 21,533,929 9,027,527 141.92%
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 16,127,141 9,143,606 230.93% 7,099,614 9,027,527 227.16%
25
Electric Services
Period:Jun‐21 Budget Current Period
FY2021 Jun‐21
YTD Actuals w/
Encumbrances 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 354 3,966 (1,034) 79.33% 5,000 (1,034) 79.33%
40005:Franchise Taxes 115,732 ‐ ‐ (115,732) 0.00% ‐ ‐ 0.00%
41002:Penalties 553,724 64,555 596,358 42,634 107.70%547,759 48,599 108.87%
42001:Interest Income 5,000 1,248 27,265 22,265 545.30%20,828 6,437 130.90%
43001:Fees 685,000 53,922 707,437 22,437 103.28%868,887 (161,450) 81.42%
43004:Administrative Charges 3,222,103 268,509 2,416,577 (805,526) 75.00% 3,222,103 (805,526) 75.00%
43601:Electric Charges 78,982,278 7,417,673 56,509,322 (22,472,956) 71.55% 79,081,809 (22,572,487) 71.46%
44502:Developer Contributions 1,500,000 187,411 5,964,069 4,464,069 397.60%6,100,000 (135,930) 97.77%
70001:Transfers In 1,562,058 ‐ 1,379,308 (182,750) 88.30% 1,562,058 (182,750) 88.30%
Total Operating Revenues 86,630,895 7,993,672 67,604,303 (19,026,592) 78.04% 91,408,444 (23,804,141) 73.96%
Operating Expenses
City of Georgetown (Only)‐ ‐ ‐ ‐ 0.00%‐ ‐ 0.00%
CC0001 Non‐Departmental 5,506,375 523,074 4,511,501 (994,874) 81.93% 6,668,720 2,157,219 67.65%
CC0526 Systems Engineering ‐ (94,372) 65,095 65,095 0.00% 80,506 15,411 80.86%
CC0522 Electric Administration 8,738,792 736,433 6,585,076 (2,153,716) 75.35% 8,944,477 2,359,401 73.62%
CC0525 T&D Services 3,122,421 283,469 3,101,351 (21,070) 99.33% 3,089,942 (11,409) 100.37%
CC0537 Electric Resource Management 108,334,393 5,432,568 96,290,644 (12,043,749) 88.88% 108,331,349 12,040,705 88.89%
CC0555 Electric Systems Operations 1,610,228 126,244 1,196,821 (413,407) 74.33% 1,639,454 442,633 73.00%
CC0557 Electrical Engineering 663,952 72,720 762,545 98,593 114.85%715,684 (46,861) 106.55%
CC0521 Electric Technical Services 727,388 48,808 515,431 (211,957) 70.86% 717,148 201,716 71.87%
CC0524 Metering Services 2,022,094 118,649 1,521,811 (500,283) 75.26% 2,029,912 508,100 74.97%
Total Operating Expenses 130,725,643 7,247,593 114,550,276 (16,175,367) 87.63% 132,217,192 17,666,916 86.64%
Net Operations Total (44,094,748) (46,945,973) (2,851,225) 106.47%(40,808,747) (6,137,225) 115.04%
Non‐Operating Revenues
45001:Misc Revenue 35,000 30,430 270,081 235,081 771.66%233,023 37,058 115.90%
45004:Sale of Property 10,000 141,409 1,038,936 1,028,936 10389.36%2,526,604 (1,487,668) 41.12%
46001:Bond Proceeds 54,648,625 6,040,000 54,065,000 (583,625) 98.93% 54,065,000 ‐ 100.00%
46002:Bond Premium ‐ 652,424 652,424 652,424 0.00% 652,424 0 100.00%
Total Non‐Operating Revenues 54,693,625 6,864,264 56,026,441 1,332,816 102.44%57,477,051 (1,450,610) 97.48%
Non‐Operating Expenses
CC0001 Non‐Departmental 4,375,805 37,408 875,370 3,500,435 20.00% 4,373,805 3,498,435 20.01%
CC0526 Systems Engineering ‐ ‐ 2,550 (2,550) 0.00%‐ (2,550) 0.00%
CC0557 Electrical Engineering 8,166,143 290,279 4,546,269 3,619,873 55.67% 8,166,142 3,619,873 55.67%
Total Non‐Operating Expenses 12,541,948 327,686 5,424,189 7,117,759 43.25% 12,539,947 7,115,758 43.26%
Excess (Deficiency) of Total Revenue over Total Requirements (1,943,071) 121,534,979 14,232,296 16,175,367 ‐732.46%4,128,357 10,103,940 344.74%
Ending Fund Balance 26,190,639 31,789,989 5,599,350 121.38%32,262,067 (472,077) 98.54%
Reserves
Rate Stabalization ‐ ‐ ‐ 0.00% 18,600,000 18,600,000 0.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 10,594,999 ‐ 100.00%3,486,903 (7,108,096) 303.85%
Reserves Total 19,062,067 19,062,067 ‐ 100.00%30,553,971 11,491,904 62.39%
Available Fund Balance 7,128,572 12,727,922 5,599,350 178.55%1,708,096 11,019,827 745.15%
Year‐to‐Date
Actuals Budget Vs. Actuals
Year‐End:
Projections Vs. Actuals
26
Water Services Fund
Period: Jun‐21 Budget
FY2021 YTD Actuals w/
Encumbrances 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 364,515 109,515 142.95%355,000 9,515 2.68%
42001:Interest Income 237,250 360,099 122,849 151.78%492,336 (132,237) 73.14%
43001:Fees 4,290,000 7,790,258 3,500,258 181.59% 7,655,000 135,258 101.77%
43005:Rental Revenue 55,000 61,070 6,070 111.04%60,000 1,070 101.78%
43602:Water Charges 32,150,000 26,580,429 (5,569,571) 82.68% 35,100,000 (8,519,571) 75.73%
43603:Wastewater Charges 14,200,000 11,034,529 (3,165,471) 77.71% 14,000,000 (2,965,471) 78.82%
43604:Irrigation Charges 300,000 205,791 (94,209) 68.60%300,000 (94,209) 68.60%
41602:Impact Fees 18,800,000 30,978,300 12,178,300 164.78% 32,500,000 (1,521,700) 95.32%
44502:Developer Contributions 625,000 1,496,239 871,239 239.40% 1,496,239 (0) 100.00%
Total Operating Revenue 70,912,250 78,871,231 7,958,981 111.22%91,958,575 (13,087,344) 85.77%
Operating Expenses
City of Georgetown (Only)‐ ‐ ‐ 0.00% ‐ ‐ 0.00%
CC0001 Non‐Departmental 4,223,814 3,144,556 1,079,258 74.45% 4,713,430 1,568,874 66.71%
CC0526 Systems Engineering ‐ (2,081,558) 2,081,558 0.00%(639,847) 1,441,711 325.32%
CC0532 Irrigation Operations 295,000 104,713 190,287 35.50%295,000 190,287 35.50%
CC0530 Wastewater Operations 896,265 536,658 359,607 59.88%834,706 298,048 64.29%
CC0531 Wastewater Plant Management 4,013,950 2,966,012 1,047,938 73.89% 3,704,111 738,099 80.07%
CC0527 Water Services Administration 26,369,169 19,613,533 6,755,637 74.38% 26,232,898 6,619,365 74.77%
CC0528 Water Distribution 3,207,552 2,807,556 399,996 87.53% 3,911,851 1,104,295 71.77%
CC0529 Water Plant Management 4,326,865 3,129,510 1,197,354 72.33% 3,910,271 780,761 80.03%
CC0553 Water Operations 4,173,316 3,318,486 854,830 79.52% 4,463,681 1,145,195 74.34%
CC0524 Metering Services ‐ 265 (265) 0.00%‐ (265) 0.00%
Operating Expense Total 47,505,930 33,539,731 13,966,199 70.60%47,426,102 13,886,371 70.72%
Available Operating Fund Balance 23,406,320 45,331,500 (6,007,218) 44,532,473 799,026 101.79%
Non‐Operating Revenue
45001:Misc Revenue 1,112,500 183,855 (928,645) 16.53% 1,262,350 (1,078,495) 14.56%
45003:Misc Reimbursements ‐ 10,422 10,422 0.00%‐ 10,422 0.00%
45004:Sale of Property 1,327,774 1,329,336 1,562 100.12% 1,327,774 1,562 100.12%
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 17,913,752 (826,522) 95.59%18,980,264 (1,066,512) 94.38%
Non‐Operating Expenses
CC0001 Non‐Departmental 4,083,411 94,190 3,989,221 2.31% 3,887,651 3,793,461 2.42%
CC0526 Systems Engineering 99,671,405 27,573,842 72,097,563 27.66% 99,630,405 72,056,563 27.68%
CC0532 Irrigation Operations 121,879 9,606 112,273 7.88%121,929 112,323 7.88%
CC0530 Wastewater Operations 3,026,798 533,080 2,493,718 17.61% 3,026,798 2,493,718 17.61%
CC0531 Wastewater Plant Management 2,050,000 ‐ 2,050,000 0.00% 2,050,000 2,050,000 0.00%
CC0527 Water Services Administration ‐ 6,037 (6,037) 0.00%6,037 0 100.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 13,962,363 18,162,210 (4,199,847) 130.08% 13,962,363 (4,199,847) 130.08%
CC0524 Metering Services 750,000 ‐ 750,000 0.00%750,000 750,000 0.00%
Non‐Operating Expense Total 124,828,037 47,160,281 77,667,756 37.78%124,219,256 77,058,975 37.97%
Excess (Deficiency) of Total Revenue over Total
Requirements (82,681,443) (74,722,462) 7,958,981 90.37% (60,706,519) (14,015,943) 123.09%
Ending Fund Balance 42,776,610 141,543,024 98,766,413 330.89%64,751,534 76,791,489 218.59%
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 122,415,282 98,766,413 517.64%45,623,792 76,791,489 268.31%
Year‐to‐Date Actuals Budget Vs. Actuals
Year‐End:
Projections Vs Actuals
27
Joint Services
Period: Jun‐21 Budget Current Period
FY2021 Jun‐21 YTD Actuals w/
Encumbrances 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 ‐ 2,728 23,070 23,070 0.00%25,000 (1,930) 92.28%
42001:Interest Income 6,250 62 6,403 153 102.44%6,250 153 102.44%
43001:Fees 173,600 2,275 14,305 (159,295) 8.24%14,000 305 102.18%
43003:Permits ‐ ‐ ‐ ‐ 0.00%‐ ‐ 0.00%
43004:Administrative Charges 17,912,066 1,483,995 13,467,581 (4,444,485) 75.19% 17,912,066 (4,444,485) 75.19%
43005:Rental Revenue ‐ ‐ 100 100 0.00%100 ‐ 100.00%
45001:Misc Revenue ‐ ‐ 431 431 0.00%431 ‐ 100.00%
45002:Insurance Proceeds ‐ 73,432 139,131 139,131 0.00%70,000 69,131 198.76%
45003:Misc Reimbursements 83,000 7,942 81,222 (1,778) 97.86%91,356 (10,134) 88.91%
70001:Transfers In ‐ ‐ ‐ ‐ 0.00%‐ ‐ 0.00%
Revenue Total 18,174,916 1,570,435 13,732,243 (4,442,673) 75.56% 18,119,203 (4,386,961) 75.79%
Expense
City of Georgetown (Only)‐ ‐ ‐ ‐ 0.00%‐ ‐ 0.00%
CC0001 Non‐Departmental 965,999 96,099 1,046,997 (80,998) 108.38% 1,246,402 199,405 84.00%
CC0302 Finance Administration 1,222,909 58,501 836,147 386,762 68.37% 1,025,554 189,407 81.53%
CC0315 Accounting 1,302,383 94,742 991,663 310,720 76.14% 1,358,423 366,759 73.00%
CC0317 Purchasing 996,521 71,123 693,497 303,025 69.59%937,558 244,062 73.97%
CC0321 Customer Care 5,955,711 473,099 4,427,818 1,527,892 74.35% 5,867,947 1,440,128 75.46%
CC0503 Organizational and Operational Excellence 342,009 24,040 224,904 117,105 65.76%323,516 98,612 69.52%
CC0526 Systems Engineering 2,757,957 201,430 1,960,232 797,724 71.08% 2,755,159 794,927 71.15%
CC0534 Conservation 779,365 42,557 406,344 373,021 52.14%565,331 158,987 71.88%
CC0547 Business System Services ‐ ‐ ‐ ‐ 0.00%‐ ‐ 0.00%
CC0637 Economic Development 593,007 42,682 425,530 167,477 71.76%575,708 150,178 73.91%
CC0639 Human Resources 1,507,953 122,850 1,073,426 434,528 71.18% 1,481,634 408,208 72.45%
CC0640 Citywide Human Resources 1,219,444 38,818 862,177 357,267 70.70% 1,127,024 264,847 76.50%
CC0654 Legal 1,055,716 78,096 786,292 269,424 74.48% 1,037,349 251,057 75.80%
Expense Total 18,698,974 1,344,037 13,735,026 4,963,948 73.45% 18,301,604 4,566,577 75.05%
Excess (Deficiency) of Total Revenue over Total Requirements (524,058) 226,398 (2,784) 521,274 0.53%(182,400) 179,617 1.53%
Ending Fund Balance 1,633,307 2,154,581 521,274 131.92% 1,974,965 179,617 109.09%
Reserves
Contingency Reserve 1,633,307 1,633,307 ‐ 100.00%1,633,307 ‐ 100.00%
Reserves Total 1,633,307 1,633,307 ‐ 100.00%1,633,307 ‐ 100.00%
Available Fund Balance ‐ 521,274 521,274 0.00%341,658 179,617 152.57%
Year‐to‐Date Actuals Budget Vs. Actuals
Year‐End:
Projections Vs. Actuals
28
Council Discretionary
Period: Jun‐21 Budget Current Period
FY2021 Jun‐21
YTD Actuals w/
Encumbrances 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 121 (379) 24.30% 162 (41) 74.80%
70001:Transfers In ‐ ‐ ‐ ‐ 0.00% 4,700,000 (4,700,000) 0.00%
Total Revenue 500 0 121 (379) 24.30% 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,862) (379) 100.34% 4,589,179 (4,700,041) ‐2.42%
Ending Fund Balance ‐ 0 (379) (379) 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 ‐ (379) (379) ‐ 4,700,145 (4,700,524) ‐0.01%
Year‐End:
Projections Vs. Actuals
Year‐to‐Date
Actuals Budget Vs. Actuals
29
Tourism
Period: Jun‐21 Budget Current Period
FY2021 Jun‐21
YTD Actuals w/
Encumbrances 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 185,341 723,371 (176,629) 80.37% 850,000 (126,629) 85.10%
42001:Interest Income 5,000 128 4,311 (689) 86.22% 5,000 (689) 86.22%
45001:Misc Revenue 95,000 2,811 16,950 (78,050) 17.84% 39,850 (22,900) 42.53%
44505:Sponsorship 50,000 ‐ ‐ (50,000) 0.00% 5,000 (5,000) 0.00%
Total Revenue 1,050,000 188,280 744,632 (305,368) 70.92% 899,850 (155,218) 82.75%
Expense
Personnel 435,456 25,586 246,073 189,383 56.51% 355,688 109,615 69.18%
Operations 1,014,085 14,571 452,378 561,707 44.61% 919,987 467,609 49.17%
Transfers 28,634 ‐ 28,634 ‐ 100.00% 28,634 ‐ 100.00%
Total Expense 1,478,175 40,157 727,085 751,091 49.19% 1,304,309 577,224 55.74%
Excess (Deficiency) of Total Revenue over Total
Requirements (428,175) 148,123 17,547 445,722 ‐4.10% (404,459) 422,006 ‐4.34%
Ending Fund Balance 854,742 148,123 1,300,464 445,722 121.73% 1,271,504 28,960 102.28%
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 994,693 445,722 181.19%965,733 28,960 103.00%
Year‐End:
Projections Vs. ActualsYear‐to‐Date Actuals Budget Vs. Actuals
30
Airport Operations
Period: Jun‐21 Budget Current Period
FY2021 Jun‐21
YTD Actuals w/
Encumbrances 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 ‐ ‐ (40,000) 0.00% 57,000 (57,000) 0.00%
42001:Interest Income 3,000 112 3,416 416 113.87% 3,129 287 109.18%
43606:Airport Charges 3,908,500 374,836 2,738,084 (1,170,416) 70.05% 3,754,800 (1,016,716) 72.92%
Total Operating Revenues 3,951,500 374,948 2,741,501 (1,209,999) 69.38% 3,814,930 (1,073,429) 71.86%
Operating Expenses
Personnel 464,472 34,386 312,904 151,568 67.37% 465,860 152,956 67.17%
Operations 3,559,192 309,948 3,988,811 (429,619) 112.07% 3,416,469 (572,342) 116.75%
Operating Capital 404,067 578 19,839 384,228 4.91% 105,255 85,416 18.85%
Total Operating Expenses 4,427,731 344,912 4,321,554 106,177 97.60% 3,987,583 (333,971) 108.38%
Non‐Operating Revenues
45001:Misc Revenue 5,000 ‐ 1,000 (4,000) 20.00%1,000 ‐ 100.00%
44001:Grant Revenue ‐ ‐ ‐ ‐ 0.00%157,000 (157,000) 0.00%
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 ‐ 715,186 10,186 101.44%872,186 (157,000) 82.00%
Non‐Operating Expenses
CIP Expense 750,000 ‐ ‐ 750,000 0.00%750,000 750,000 0.00%
Debt Service 158,931 ‐ 30,873 128,058 19.43%158,931 128,058 19.43%
Total Non‐Operating Expenses 908,931 ‐ 30,873 878,058 3.40%908,931 878,058 3.40%
Excess (Deficiency) of Total Revenue over Total
Requirements (680,162) 30,036 (895,740) (215,578) 131.70%(209,398) (686,342) 427.77%
Ending Fund Balance 783,337 30,036 567,759 (215,578) 72.48% 1,254,101 (686,342) 45.27%
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 93,364 (215,578) 30.22%737,085 (643,721) 12.67%
Year‐End:
Projections Vs. ActualsYear‐to‐Date Actuals Budget Vs. Actuals
31
GTEC
Period: Jun‐21 Budget Current Period
FY2021 Jun‐21
YTD Actuals w/
Encumbrances 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%
Revenue
40002:Sales Taxes 8,255,000 895,369 5,849,118 (2,405,882) 70.86% 10,187,500 (4,338,382) 57.41%
42001:Interest Income 60,000 1,544 21,248 (38,752) 35.41% 24,544 (3,295) 86.57%
46001:Bond Proceeds 8,000,000 ‐ 7,405,000 (595,000) 92.56% 7,405,000 ‐ 100.00%
46002:Bond Premium ‐ ‐ 731,229 731,229 0.00% 731,229 (0) 100.00%
Total Revenue 16,315,000 896,913 14,006,595 (2,308,405) 85.85% 18,348,273 (4,341,678) 76.34%
Expense
Operations 2,387,337 33,514 245,683 2,141,654 10.29% 2,386,565 2,140,882 10.29%
Operating Capital ‐ ‐ 4,140 (4,140) 0.00% 0 (4,140) 2435382.35%
CIP Expense 20,476,813 867,917 3,742,554 16,734,259 18.28% 20,476,813 16,734,259 18.28%
Transfers 2,763,242 ‐ 420,122 2,343,120 15.20% 2,763,242 2,343,120 15.20%
Debt Service 1,053,050 ‐ 155,800 897,250 14.80% 1,053,050 897,250 14.80%
Total Expense 26,680,442 901,431 4,568,299 22,112,143 17.12% 26,679,671 22,111,372 17.12%
Excess (Deficiency) of Total Revenue over Total
Requirements (10,365,442) (4,517) 9,438,296 19,803,738 ‐91.06% (8,331,398) 17,769,694 ‐113.29%
Ending Fund Balance 20,664,256 40,467,994 19,803,738 195.84% 22,698,300 17,769,694 178.29%
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 34,989,387 19,803,738 230.41% 17,219,693 17,769,694 203.19%
Year‐End:
Projections Vs. Actuals
Year‐to‐Date
Actuals Budget Vs. Actuals
32
GEDCO
Period: Jun‐21 Budget Current Period
FY2021 Jun‐21
YTD Actuals w/
Encumbrances 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 223,842 1,462,280 (601,471) 70.86% 2,546,875 (1,084,595) 57.41%
42001:Interest Income 19,000 236 22,975 3,975 120.92% 25,000 (2,026) 91.90%
Total Revenue 2,082,750 224,079 1,485,254 (597,496) 71.31% 2,571,875 (1,086,621) 57.75%
Expense
Operations 8,850,174 20,193 703,533 8,146,641 7.95% 6,028,476 5,324,942 11.67%
Debt Service 90,572 ‐ ‐ 90,572 0.00%90,572 90,572 0.00%
Transfers 1,200,169 ‐ 1,040,084 160,085 86.66% 1,200,169 160,085 86.66%
Total Expense 10,140,915 20,193 1,743,618 8,397,297 17.19% 7,319,217 5,575,599 23.82%
Excess (Deficiency) of Total Revenue over Total
Requirements (8,058,165) 203,885 (258,364) 7,799,801 3.21% (4,747,342) 4,488,979 5.44%
Ending Fund Balance 787,612 203,885 8,587,413 (8,994,793) 1090.31%992,725 (7,594,689) 865.03%
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 7,879,176 7,799,801 9926.52%284,488 7,594,689 2769.60%
Year‐End:
Projections Vs. Actuals
Year‐to‐Date
Actuals Budget Vs. Actuals
33
CITY
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
June 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
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.
34
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Demand Accounts 15,550,035$ 15,550,035 23,547,685$ 23,547,685$ 0.22%
NOW/MMA 11,019,484 11,019,484 23,029,382 23,029,382 0.26%
Pools 144,095,312 144,095,312 174,848,692 174,848,692 0.01%
CDs/Securities 105,720,421 105,720,421 123,735,822 123,735,822 0.31%
Totals 276,385,252$ 276,385,252$ 345,161,582$ 345,161,582$ 0.15%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.15%Total Portfolio 0.24%
Rolling Three Month Treasury 0.02%Rolling Three Month Treasury 0.06%
Rolling Six Month Treasury 0.06%Rolling Six Month Treasury 0.09%
TexPool 0.01%TexPool 0.04%
Bank Fees Offset
11,446$
Interest earnings provided in separate report. 30,125$
March 31, 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
June 30, 2021
City of Georgetown Valley View Consulting, L.L.C.236
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% 07/01/21 06/30/21 23,547,685$ 23,547,685$ 1.00 23,547,685$ 1 0.22%
JPMorgan Chase MMA 0.03% 07/01/21 06/30/21 434,080 434,080 1.00 434,080 1 0.03%
Veritex Bank MMA 0.08% 07/01/21 06/30/21 3,213,925 3,213,925 1.00 3,213,925 1 0.08%
NexBank MMA 0.45% 07/01/21 06/30/21 7,380,457 7,380,457 1.00 7,380,457 1 0.45%
Texas Capital Bank MMA 0.20% 07/01/21 06/30/21 12,000,920 12,000,920 1.00 12,000,920 1 0.20%
TexPool AAAm 0.01%07/01/21 06/30/21 57,019,665 57,019,665 1.00 57,019,665 1 0.01%
TexSTAR AAAm 0.01%07/01/21 06/30/21 117,829,027 117,829,027 1.00 117,829,027 1 0.01%
Prosperity Bank CD 0.60% 07/01/21 07/01/20 4,018,010 4,018,010 100.00 4,018,010 1 0.60%
Prosperity Bank CD 0.70% 07/15/21 07/15/20 5,026,275 5,026,275 100.00 5,026,275 15 0.70%
Prosperity Bank CD 0.15% 08/10/21 02/10/21 3,001,480 3,001,480 100.00 3,001,480 41 0.15%
Prosperity Bank CD 0.40% 08/23/21 08/21/20 6,263,799 6,263,799 100.00 6,263,799 54 0.40%
R Bank CD 0.47% 08/25/21 02/25/21 2,002,293 2,002,293 100.00 2,002,293 56 0.47%
East West Bank CD 0.26% 09/09/21 12/09/20 4,075,095 4,075,095 100.00 4,075,095 71 0.26%
East West Bank CD 0.21% 10/08/21 01/08/21 5,005,008 5,005,008 100.00 5,005,008 100 0.21%
Prosperity Bank CD 0.30% 10/14/21 10/14/20 2,504,993 2,504,993 100.00 2,504,993 106 0.30%
Independent Bank CD 0.40% 10/18/21 10/18/20 2,551,673 2,551,673 100.00 2,551,673 110 0.40%
Prosperity Bank CD 0.30% 11/22/21 11/20/20 3,005,228 3,005,228 100.00 3,005,228 145 0.30%
Texas Regional Bank CD 0.25% 12/07/21 03/12/21 3,001,890 3,001,890 100.00 3,001,890 160 0.25%
East West Bank CD 0.21% 12/30/21 12/30/20 3,003,160 3,003,160 100.00 3,003,160 183 0.21%
East West Bank CD 0.21% 01/07/22 01/08/21 5,005,008 5,005,008 100.00 5,005,008 191 0.21%
Prosperity Bank CD 0.30% 01/21/22 10/21/20 4,007,990 4,007,990 100.00 4,007,990 205 0.30%
East West Bank CD 0.10% 02/01/22 05/10/21 2,000,285 2,000,285 100.00 2,000,285 216 0.10%
Independent Bank CD 0.40% 02/05/22 02/05/21 3,002,905 3,002,905 100.00 3,002,905 220 0.40%
Independent Bank CD 0.40% 02/08/22 02/08/21 5,004,822 5,004,822 100.00 5,004,822 223 0.40%
R Bank CD 0.63% 02/25/22 02/25/21 2,003,075 2,003,075 100.00 2,003,075 240 0.63%
Prosperity Bank CD 0.35% 04/21/22 10/21/20 2,505,827 2,505,827 100.00 2,505,827 295 0.35%
Independent Bank CD 0.30% 04/22/22 04/22/21 4,211,849 4,211,849 100.00 4,211,849 296 0.30%
Independent Bank CD 0.35% 05/09/22 02/08/21 4,003,414 4,003,414 100.00 4,003,414 313 0.35%
Prosperity Bank CD 0.35% 05/17/22 11/17/20 2,004,067 2,004,067 100.00 2,004,067 321 0.35%
Prosperity Bank CD 0.20% 06/13/22 06/11/21 5,000,000 5,000,000 100.00 5,000,000 348 0.20%
Prosperity Bank CD 0.20% 07/25/22 04/23/21 5,001,671 5,001,671 100.00 5,001,671 390 0.20%
Prosperity Bank CD 0.20% 08/01/22 05/25/21 5,000,849 5,000,849 100.00 5,000,849 397 0.20%
Prosperity Bank CD 0.35% 08/22/22 11/20/20 2,505,084 2,505,084 100.00 2,505,084 418 0.35%
Prosperity Bank CD 0.20% 09/12/22 06/11/21 5,000,000 5,000,000 100.00 5,000,000 439 0.20%
June 30, 2021
City of Georgetown Valley View Consulting, L.L.C.337
City - Investment Holdings
Coupon/ Maturity Settlement Face Amount/ Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day) Yield
June 30, 2021
Prosperity Bank CD 0.20% 10/24/22 04/23/21 5,001,671 5,001,671 100.00 5,001,671 481 0.20%
Prosperity Bank CD 0.40% 11/17/22 11/17/20 2,004,649 2,004,649 100.00 2,004,649 505 0.40%
R Bank CD 0.60% 12/31/22 06/30/21 1,000,000 1,000,000 100.00 1,000,000 549 0.60%
Prosperity Bank CD 0.20% 04/24/23 04/23/21 5,001,671 5,001,671 100.00 5,001,671 663 0.20%
Prosperity Bank CD 0.20% 05/01/23 05/25/21 5,000,849 5,000,849 100.00 5,000,849 670 0.20%
Bank OZK CD 0.20% 06/12/23 06/11/21 5,011,230 5,011,230 100.00 5,011,230 712 0.20%
R Bank CD 0.73% 06/30/23 06/30/21 1,000,000 1,000,000 100.00 1,000,000 730 0.73%
TOTALS 345,161,582$ 345,161,582$ 345,161,582$ 104 0.15%
(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.438
City - Book & Market Value Comparison
Issuer/Description Yield
Maturity
Date
Book Value
03/31/21 Increases Decreases
Book Value
06/30/21
Market Value
03/31/21
Change in
Market Value
Market Value
06/30/21
JPMorgan Chase Cash 0.22% 07/01/21 15,550,035$ 7,997,650$ –$ 23,547,685$ 15,550,035$ 7,997,650$ 23,547,685$
JPMorgan Chase MMA 0.03% 07/01/21 434,048 32 – 434,080 434,048 32 434,080
Veritex Bank MMA 0.08% 07/01/21 3,213,253 672 – 3,213,925 3,213,253 672 3,213,925
NexBank MMA 0.45% 07/01/21 7,372,182 8,274 – 7,380,457 7,372,182 8,274 7,380,457
Texas Capital Bank MMA 0.20% 07/01/21 – 12,000,920 – 12,000,920 – 12,000,920 12,000,920
TexPool 0.01% 07/01/21 58,862,442 – (1,842,777) 57,019,665 58,862,442 (1,842,777) 57,019,665
TexSTAR 0.01% 07/01/21 85,232,871 32,596,156 – 117,829,027 85,232,871 32,596,156 117,829,027
Prosperity Bank CD 0.45%04/01/21 4,006,098 – (4,006,098) – 4,006,098 (4,006,098) –
Independent Bank CD 1.81%04/22/21 4,193,238 – (4,193,238) – 4,193,238 (4,193,238) –
Bank OZK CD 0.70%05/10/21 12,070,246 – (12,070,246) – 12,070,246 (12,070,246) –
Southside Bank CD 0.22%06/11/21 5,005,456 – (5,005,456) – 5,005,456 (5,005,456) –
Bank OZK CD 0.30%06/11/21 5,007,443 – (5,007,443) – 5,007,443 (5,007,443) –
Prosperity Bank CD 0.60%07/01/21 4,012,075 5,936 – 4,018,010 4,012,075 5,936 4,018,010
Prosperity Bank CD 0.70%07/15/21 5,017,615 8,661 – 5,026,275 5,017,615 8,661 5,026,275
Prosperity Bank CD 0.15%08/10/21 3,000,345 1,135 – 3,001,480 3,000,345 1,135 3,001,480
Prosperity Bank CD 0.40%08/23/21 6,257,488 6,311 – 6,263,799 6,257,488 6,311 6,263,799
R Bank CD 0.47%08/25/21 2,000,000 2,293 – 2,002,293 2,000,000 2,293 2,002,293
East West Bank CD 0.26%09/09/21 4,072,454 2,641 – 4,075,095 4,072,454 2,641 4,075,095
East West Bank CD 0.21%10/08/21 5,002,388 2,620 – 5,005,008 5,002,388 2,620 5,005,008
Prosperity Bank CD 0.30%10/14/21 2,503,100 1,893 – 2,504,993 2,503,100 1,893 2,504,993
Independent Bank CD 0.40%10/18/21 2,549,159 2,514 – 2,551,673 2,549,159 2,514 2,551,673
Prosperity Bank CD 0.30%11/22/21 3,002,957 2,271 – 3,005,228 3,002,957 2,271 3,005,228
Texas Regional Bank CD 0.25%12/07/21 3,000,000 1,890 – 3,001,890 3,000,000 1,890 3,001,890
East West Bank CD 0.21%12/30/21 3,001,588 1,572 – 3,003,160 3,001,588 1,572 3,003,160
East West Bank CD 0.21%01/07/22 5,002,388 2,620 – 5,005,008 5,002,388 2,620 5,005,008
Prosperity Bank CD 0.30%01/21/22 4,004,960 3,029 – 4,007,990 4,004,960 3,029 4,007,990
East West Bank CD 0.10%02/01/22 – 2,000,285 – 2,000,285 – 2,000,285 2,000,285
Independent Bank CD 0.40%02/05/22 3,000,000 2,905 – 3,002,905 3,000,000 2,905 3,002,905
Independent Bank CD 0.40%02/08/22 5,000,000 4,822 – 5,004,822 5,000,000 4,822 5,004,822
R Bank CD 0.63%02/25/22 2,000,000 3,075 – 2,003,075 2,000,000 3,075 2,003,075
Prosperity Bank CD 0.35%04/21/22 2,503,617 2,209 – 2,505,827 2,503,617 2,209 2,505,827
Independent Bank CD 0.30%04/22/22 – 4,211,849 – 4,211,849 – 4,211,849 4,211,849
Independent Bank CD 0.35%05/09/22 4,000,000 3,414 – 4,003,414 4,000,000 3,414 4,003,414
Prosperity Bank CD 0.35%05/17/22 2,002,300 1,767 – 2,004,067 2,002,300 1,767 2,004,067
Prosperity Bank CD 0.20%06/13/22 – 5,000,000 – 5,000,000 – 5,000,000 5,000,000
Prosperity Bank CD 0.20%07/25/22 – 5,001,671 – 5,001,671 – 5,001,671 5,001,671
Prosperity Bank CD 0.20%08/01/22 – 5,000,849 – 5,000,849 – 5,000,849 5,000,849
Prosperity Bank CD 0.35%08/22/22 2,502,875 2,209 – 2,505,084 2,502,875 2,209 2,505,084
Prosperity Bank CD 0.20%09/12/22 – 5,000,000 – 5,000,000 – 5,000,000 5,000,000
City of Georgetown Valley View Consulting, L.L.C.640
City - Book & Market Value Comparison
Issuer/Description Yield
Maturity
Date
Book Value
03/31/21 Increases Decreases
Book Value
06/30/21
Market Value
03/31/21
Change in
Market Value
Market Value
06/30/21
Prosperity Bank CD 0.20%10/24/22 – 5,001,671 – 5,001,671 – 5,001,671 5,001,671
Prosperity Bank CD 0.40%11/17/22 2,002,629 2,020 – 2,004,649 2,002,629 2,020 2,004,649
R Bank CD 0.60%12/31/22 – 1,000,000 – 1,000,000 – 1,000,000 1,000,000
Prosperity Bank CD 0.20%04/24/23 – 5,001,671 – 5,001,671 – 5,001,671 5,001,671
Prosperity Bank CD 0.20%05/01/23 – 5,000,849 – 5,000,849 – 5,000,849 5,000,849
Bank OZK CD 0.20%06/12/23 – 5,011,230 – 5,011,230 – 5,011,230 5,011,230
R Bank CD 0.73%06/30/23 – 1,000,000 – 1,000,000 – 1,000,000 1,000,000
TOTAL / AVERAGE 0.15% 276,385,252$ 100,901,589$ (32,125,259)$ 345,161,582$ 276,385,252$ 68,776,330$ 345,161,582$
City of Georgetown Valley View Consulting, L.L.C.741
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$
Book Value
June 30, 2021
City of Georgetown Valley View Consulting, L.L.C.842
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
Book Value
June 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,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.943
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
Book Value
June 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
–$ –$ –$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
– – – – – – – – – –
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.1044
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
Book Value
June 30, 2021
(Continued)
City - 2021
CO
Fac/Equip/
Parks
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.1145
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.1246
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.1347
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.1448
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/
Parks
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.1549
City - Allocation
Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
JPMorgan Chase Cash 15,550,035$ 15,550,035$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,048 434,048 – – – – –
Veritex Bank MMA 3,213,253 3,213,253 – – – – –
NexBank MMA 7,372,182 7,372,182 – – – – –
TexPool 58,862,442 58,862,442 – – – – –
TexSTAR 85,232,871 20,153,413 584,286 17,544,854 137,307 93,010 2,508,839
Prosperity Bank CD 04/01/21 4,006,098 4,006,098 – – – – –
Independent Bank CD 04/22/21 4,193,238 4,193,238 – – – – –
Bank OZK CD 05/10/21 12,070,246 10,058,538 – – – – –
Southside Bank CD 06/11/21 5,005,456 5,005,456 – – – – – Bank OZK CD 06/11/21 5,007,443 5,007,443 – – – – –
Prosperity Bank CD 07/01/21 4,012,075 4,012,075 – – – – –
Prosperity Bank CD 07/15/21 5,017,615 5,017,615 – – – – –
Prosperity Bank CD 08/10/21 3,000,345 – – – – – –
Prosperity Bank CD 08/23/21 6,257,488 6,257,488 – – – – – R Bank CD 08/25/21 2,000,000 – – – – – –
East West Bank CD 09/09/21 4,072,454 4,072,454 – – – – –
East West Bank CD 10/08/21 5,002,388 5,002,388 – – – – –
Prosperity Bank CD 10/14/21 2,503,100 2,503,100 – – – – –
Independent Bank CD 10/18/21 2,549,159 2,549,159 – – – – –
Prosperity Bank CD 11/22/21 3,002,957 3,002,957 – – – – –
Texas Regional Bank CD 12/07/21 3,000,000 – – – – – –
East West Bank CD 12/30/21 3,001,588 3,001,588 – – – – – East West Bank CD 01/07/22 5,002,388 5,002,388 – – – – –
Prosperity Bank CD 01/21/22 4,004,960 4,004,960 – – – – –
Independent Bank CD 02/05/22 3,000,000 3,000,000 – – – – –
Independent Bank CD 02/08/22 5,000,000 4,000,000 – – – – –
R Bank CD 02/25/22 2,000,000 – – – – – –
Prosperity Bank CD 04/21/22 2,503,617 2,503,617 – – – – –
Independent Bank CD 05/17/22 4,000,000 4,000,000 – – – – –
Prosperity Bank CD 05/17/22 2,002,300 2,002,300 – – – – – Prosperity Bank CD 08/22/22 2,502,875 2,502,875 – – – – –
Prosperity Bank CD 11/17/22 2,002,629 2,002,629 – – – – –
Totals 276,385,252$ 198,293,742$ 584,286$ 17,544,854$ 137,307$ 93,010$ 2,508,839$
Book Value
March 31, 2021
City of Georgetown Valley View Consulting, L.L.C.1650
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
Book Value
March 31, 2021
(Continued)
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 Revenue
Electric
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,841 68,606 1,429,234 1,420,244 246,565 178,450 97,383
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,841$ 68,606$ 1,429,234$ 1,420,244$ 246,565$ 178,450$ 97,383$
City of Georgetown Valley View Consulting, L.L.C.1751
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
Book Value
March 31, 2021
(Continued)
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,746,916 56,700 672,317 445,286 6,628,059 4,686,290 87,973
– – – – – – –
– – – – – – –
2,011,708 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,000,345 – – – – – –
– – – – – – –
– – – – – 2,000,000 –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
11,758,969$ 56,700$ 672,317$ 445,286$ 6,628,059$ 6,686,290$ 87,973$
City of Georgetown Valley View Consulting, L.L.C.1852
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
Book Value
March 31, 2021
(Continued)
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,247,736 1,910,744 650,627 8,547,474 486,572 6,675,600 4,396,545
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,247,736$ 1,910,744$ 650,627$ 8,547,474$ 486,572$ 6,675,600$ 4,396,545$
City of Georgetown Valley View Consulting, L.L.C.1953
City - Allocation
March 31, 2021
Market Value Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
JPMorgan Chase Cash 15,550,035$ 15,550,035$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,048 434,048 – – – – –
Veritex Bank MMA 3,213,253 3,213,253 – – – – –
NexBank MMA 7,372,182 7,372,182 – – – – –
TexPool 58,862,442 58,862,442 – – – – –
TexSTAR 85,232,871 20,153,413 584,286 17,544,854 137,307 93,010 2,508,839
Prosperity Bank CD 04/01/21 4,006,098 4,006,098 – – – – –
Independent Bank CD 04/22/21 4,193,238 4,193,238 – – – – –
Bank OZK CD 05/10/21 12,070,246 10,058,538 – – – – –
Southside Bank CD 06/11/21 5,005,456 5,005,456 – – – – –
Bank OZK CD 06/11/21 5,007,443 5,007,443 – – – – –
Prosperity Bank CD 07/01/21 4,012,075 4,012,075 – – – – –
Prosperity Bank CD 07/15/21 5,017,615 5,017,615 – – – – –
Prosperity Bank CD 08/10/21 3,000,345 – – – – – –
Prosperity Bank CD 08/23/21 6,257,488 6,257,488 – – – – –
R Bank CD 08/25/21 2,000,000 – – – – – –
East West Bank CD 09/09/21 4,072,454 4,072,454 – – – – –
East West Bank CD 10/08/21 5,002,388 5,002,388 – – – – –
Prosperity Bank CD 10/14/21 2,503,100 2,503,100 – – – – –
Independent Bank CD 10/18/21 2,549,159 2,549,159 – – – – –
Prosperity Bank CD 11/22/21 3,002,957 3,002,957 – – – – –
Texas Regional Bank CD 12/07/21 3,000,000 – – – – – –
East West Bank CD 12/30/21 3,001,588 3,001,588 – – – – –
East West Bank CD 01/07/22 5,002,388 5,002,388 – – – – –
Prosperity Bank CD 01/21/22 4,004,960 4,004,960 – – – – –
Independent Bank CD 02/05/22 3,000,000 3,000,000 – – – – –
Independent Bank CD 02/08/22 5,000,000 4,000,000 – – – – –
R Bank CD 02/25/22 2,000,000 – – – – – –
Prosperity Bank CD 04/21/22 2,503,617 2,503,617 – – – – –
Independent Bank CD 05/17/22 4,000,000 4,000,000 – – – – –
Prosperity Bank CD 05/17/22 2,002,300 2,002,300 – – – – –
Prosperity Bank CD 08/22/22 2,502,875 2,502,875 – – – – –
Prosperity Bank CD 11/17/22 2,002,629 2,002,629 – – – – –
Totals 276,385,252$ 198,293,742$ 584,286$ 17,544,854$ 137,307$ 93,010$ 2,508,839$
City of Georgetown Valley View Consulting, L.L.C.2054
City - Allocation
March 31, 2021
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 Revenue
Electric
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,841 68,606 1,429,234 1,420,244 246,565 178,450 97,383
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,841$ 68,606$ 1,429,234$ 1,420,244$ 246,565$ 178,450$ 97,383$
City of Georgetown Valley View Consulting, L.L.C.2155
City - Allocation
March 31, 2021
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,746,916 56,700 672,317 445,286 6,628,059 4,686,290 87,973
– – – – – – –
– – – – – – –
2,011,708 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,000,345 – – – – – –
– – – – – – –
– – – – – 2,000,000 –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
11,758,969$ 56,700$ 672,317$ 445,286$ 6,628,059$ 6,686,290$ 87,973$
City of Georgetown Valley View Consulting, L.L.C.2256
City - Allocation
March 31, 2021
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,247,736 1,910,744 650,627 8,547,474 486,572 6,675,600 4,396,545
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,247,736$ 1,910,744$ 650,627$ 8,547,474$ 486,572$ 6,675,600$ 4,396,545$
City of Georgetown Valley View Consulting, L.L.C.2357
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
MMA 2,130,611$ 2,130,611$ 2,131,057$ 2,131,057$ 0.08%
Pools 6,964,887 6,964,887 7,601,901 7,601,901 0.02%
Certificates of Deposit 2,000,000 2,000,000 2,001,170 2,001,170 0.24%
11,095,498$ 11,095,498$ 11,734,129$ 11,734,129$ 0.07%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.07%Total Portfolio 0.19%
Rolling Three Month Treasury 0.02%Rolling Three Month Treasury 0.06%
Rolling Six Month Treasury 0.06%Rolling Six Month Treasury 0.09%
TexPool 0.01%TexPool 0.04%
Interest income provided in separate report.
March 31, 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.
June 30, 2021
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.159
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% 07/01/21 06/30/21 2,131,057$ 2,131,057$ 1.00 2,131,057$ 1 0.08%
TexasDAILY AAAm 0.03% 07/01/21 06/30/21 2,125,828 2,125,828 1.00 2,125,828 1 0.03%
TexSTAR AAAm 0.01% 07/01/21 06/30/21 5,476,074 5,476,074 1.00 5,476,074 1 0.01%
Veritex Bank CD 0.24% 08/05/22 02/08/21 2,001,170 2,001,170 100.00 2,001,170 401 0.24%
11,734,129$ 11,734,129$ 11,734,129$ 69 0.07%
(1) (2)
June 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.361
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Pools/MMAs 30,076,153$ 30,076,153$ 39,417,553$ 39,417,553$ 0.02%
CDs/Securities 3,006,965 3,006,965 3,009,998 3,009,998 0.40%
Totals 33,083,118$ 33,083,118$ 42,427,551$ 42,427,551$ 0.04%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.04%Total Portfolio 0.07%
Rolling Three Month Treasury 0.02%Rolling Three Month Treasury 0.06%
Rolling Six Month Treasury 0.06%Rolling Six Month Treasury 0.09%
TexPool 0.01%TexPool 0.04%
Interest data provided in separate report.
March 31, 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.
June 30, 2021
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.165
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.01% 07/01/21 06/30/21 18,186,491$ 18,186,491$ 1.00 18,186,491$ 1 0.01%
TexSTAR AAAm 0.01% 07/01/21 06/30/21 18,542,059 18,542,059 1.00 18,542,059 1 0.01%
Veritex Bank MMA 0.08% 07/01/21 06/30/21 2,689,003 2,689,003 1.00 2,689,003 1 0.08%
Prosperity Bank CD 0.40% 08/23/21 08/21/20 3,009,998 3,009,998 100.00 3,009,998 54 0.40%
TOTALS 42,427,551$ 42,427,551$ 42,427,551$ 5 0.04%
(1) (2)
June 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.367
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
69,904.04 -
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 FEMA TDEM DR-4586 Winter Storm Uri Recovery 2,258,648.00
Emergency Management US Dept. of the Treasury American Rescue Plan Act
SLFRF Funding
65,459.00 4,014,753.00
Fire Department of Health & Human Services CMS (Centers for Medicare &
Medicaid Services)
EMS CARES Round 1 - -
Fire US Department of Homeland Security Federal Emergency
Management Agency
EMW-2017-FH-00496 SAFER 822,918.15 470,104.81
Library National Endowment for the Arts National Endowment for the
Arts
COVID Relief Funding 9,014.11 -
Library Texas Commission on the Arts Touring Artist Fund Grant 4,200.00
Planning US Department of Housing & Urban Development Williamson County CDBG Home Repair 43,059.77 40,920.32
Police US. Department of Justice N/A TX2460200 Equitable Sharing Agreement 25,523.52 34,920.95
Police US. Department of Treasury N/A TX2460200 Equitable Sharing Agreement - -
Public Works Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ-0914-05-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)
- -
CITY OF GEORGETOWN
Grant/Federal Funding Report
as of June 30, 2021
Active
70
Capital Improvement Projects Life to Date Budget vs Spend
Project Budget vs Actuals Total Budget Total Spend Remaining Budget Percent Remaining
Active
Airport
Management Services
PRJ000184 Airport Maintenance Facility 750,000 - 750,000 100%
Management Services Total 750,000 - 750,000 100%
Airport Total 750,000 - 750,000 100%
CDBG
CDBG
PRJ000003 17th Street 193,000 175,137 17,863 9%
CDBG Total 193,000 175,137 17,863 9%
CDBG Total 193,000 175,137 17,863 9%
Electric
Electric
PRJ000022 Consultant Engineering 271,352 87,857 183,495 68%
PRJ000026 Db Wood_Sh29 Intersection 240,000 172,024 67,976 28%
PRJ000036 Electrical System Improvement 100,000 57 99,943 100%
PRJ000040 Fiber Optic 50,000 19,516 30,484 61%
PRJ000062 New Development Projects 4,194,840 5,834,510 (1,639,670) -39%
PRJ000073 Power Quality Improvements 50,000 - 50,000 100%
PRJ000095 Shell Road Feeders 160,000 181,824 (21,824) -14%
PRJ000147 Sectionalization Improvements 100,000 2,550 97,450 97%
PRJ000175 I-35 Mobility Project TxDot 200,000 205,774 (5,774) -3%
PRJ000189 Ronald Reagan - Glasscock Feeder Extension along Hwy 195 -Phase I 560,000 39,859 520,141 93%
PRJ000192 Ronald Reagan - Glasscock Feeder extension along Hwy 195 - Phase II 591,250 208,011 383,239 65%
PRJ000195 Downtown Overhead Rehab 2,400,000 - 2,400,000 100%
PRJ000221 Titan-Aviation Dr to IH35 Infrastructure Addition 1,000,000 254,432 745,568 75%
PRJ000225 Chapel Hill, WS-11139 (GEO-45-C.3)437,577 351,949 85,628 20%
PRJ000226 Wolf Ranch West - Section 1AG & 1BG 479,052 339,435 139,617 29%
PRJ000227 Ascend Westinghouse Apartments 444,598 231,132 213,465 48%
PRJ000229 Sun City NH 76 WS-11188 (GEO-18.2-N.51)274,030 103,520 170,510 62%
PRJ000230 Sun City NH 78 296,400 111,101 185,299 63%
PRJ000231 Georgetown Titan Development 1 & 2 140,428 29,241 111,187 79%
PRJ000232 Texas Outdoor Power Building 1 91,414 58,223 33,191 36%
PRJ000234 Summit at Westinghouse Self-Storage 49,685 26,505 23,180 47%
PRJ000236 Medcore (Georgetown) Senior Living 226,972 202,268 24,703 11%
PRJ000238 The Oscar at Georgetown 366,351 211,520 154,830 42%
PRJ000239 Wolf Ranch West - Section 3 - Phase 2 418,339 - 418,339 100%
PRJ000242 Allora North Georgetown 557,422 - 557,422 100%
PRJ000243 Fairfield Inn - WS11346 131,340 - 131,340 100%
PRJ000245 Morgan Mays Street Apartments 452,508 - 452,508 100%
PRJ000246 Vida Apartments 396,497 - 396,497 100%
Electric Total 14,680,054 8,671,310 6,008,745 41%
Electric Total 14,680,054 8,671,310 6,008,745 41%
GCP
Environmental Services
PRJ000116 Transfer Station 11,000,000 947,801 10,052,199 91%
Environmental Services Total 11,000,000 947,801 10,052,199 91%
Finance
PRJ000038 ERP Project 6,231,654 5,898,066 333,588 5%
Finance Total 6,231,654 5,898,066 333,588 5%
Fire
PRJ000134 SCBA Replacement 870,000 - 870,000 100%
PRJ000135 Cardiac Monitors 483,517 483,517 - 0%
Fire Total 1,353,517 483,517 870,000 64%
71
Capital Improvement Projects Life to Date Budget vs Spend
Project Budget vs Actuals Total Budget Total Spend Remaining Budget Percent Remaining
Fleet
PRJ000124 Radio Replacement 363,278 179,219 184,059 51%
Fleet Total 363,278 179,219 184,059 51%
GTEC Department
PRJ000203 FM1460 Widening 600,984 48,982 552,002 92%
PRJ000206 NB Front Rd (2338 To Lakeway) 216,000 221,766 (5,766) -3%
GTEC Department Total 816,984 270,748 546,236 67%
Management Services
PRJ000028 Downtown Parking Expansion 728,510 701,947 26,564 4%
PRJ000029 Downtown Parking Garage 411,815 411,815 - 0%
PRJ000033 Dtwn Landsping & Public Art 90,000 56,706 33,294 37%
PRJ000037 EOC Siren System 15,525 6,961 8,564 55%
PRJ000042 Fire Station 6 5,500,000 5,330,424 169,576 3%
PRJ000043 Fire Station 7 7,198,744 6,484,206 714,538 10%
PRJ000067 Parking Improvements 68,510 - 68,510 100%
PRJ000131 Fuel Station 1,100,000 61,088 1,038,913 94%
PRJ000136 GMC Remodel Phase I 250,000 30,614 219,386 88%
PRJ000178 Public Safety Operation and Training Center Phase II 4,500,000 91,649 4,408,351 98%
PRJ000179 Recreation Center Teen/Senior Renovation 200,000 - 200,000 100%
PRJ000180 Recreation Center Natatorium HVAC Replacement 700,000 663,596 36,404 5%
PRJ000191 Georgetown City Center - Festival/Public Space 5,400,000 24,124 5,375,876 100%
PRJ000223 City Center Signage 125,000 - 125,000 100%
Management Services Total 26,288,105 13,863,129 12,424,975 47%
Parks
PRJ000048 Garey Park 15,346,730 15,100,250 246,480 2%
PRJ000089 San Gabriel Park Improvement 13,025,000 7,448,252 5,576,748 43%
PRJ000125 Parks Master Plan 229,998 229,998 - 0%
PRJ000126 Regional Trail Development 1,550,000 138,100 1,411,900 91%
PRJ000127 Neighborhood Park Development 1,250,000 240,541 1,009,459 81%
PRJ000129 Ada Transition Plan 1,075,982 695,964 380,018 35%
PRJ000130 Tennis Center Pool Demo 40,002 39,076 926 2%
PRJ000190 Heritage Gardens 274,934 129,840 145,094 53%
Parks Total 32,792,646 24,022,022 8,770,624 27%
Police
PRJ000133 Body Cameras 800,000 737,412 62,588 8%
Police Total 800,000 737,412 62,588 8%
Public Works Department
PRJ000013 Austin Avenue Bridge 2,855,398 1,714,763 1,140,635 40%
PRJ000137 Intersection Improvements (Lakeway @ Williams Drive)1,400,000 252,450 1,147,550 82%
PRJ000138 Downtown Sidewalks 2,000,000 1,435,694 564,306 28%
PRJ000139 Westinghouse - Scenic Lake Traffic Signal 600,000 343,447 256,553 43%
PRJ000141 Southwestern Blvd 4,200,000 866,960 3,333,040 79%
PRJ000143 Leander Rd(Norwood-Swbypass)6,750,000 994,025 5,755,975 85%
PRJ000171 Shell Rd Sidewalk 229,825 203,755 26,070 11%
PRJ000188 DB Wood (SH 29 to Oak Ridge)4,000,000 1,703,636 2,296,364 57%
PRJ000201 Austin Ave. (Sh29-Fm2243)466,000 466,000 - 0%
PRJ000202 FM 971 5,200,998 4,476,983 724,015 14%
PRJ000207 Northwest Blvd Bridge 11,254,320 11,449,791 (195,471) -2%
PRJ000209 Southeast Inner Loop 10,521,000 8,882,549 1,638,451 16%
PRJ000214 Intersection Improvements (Traffic Signals)1,650,000 504,877 1,145,123 69%
72
Capital Improvement Projects Life to Date Budget vs Spend
Project Budget vs Actuals Total Budget Total Spend Remaining Budget Percent Remaining
PRJ000215 2021 Intersection Safety Enhancements (RRFB)150,000 96,450 53,550 36%
PRJ000216 FY21 Downtown Sidewalk Improvements 1,000,000 130,000 870,000 87%
PRJ000217 SW Bypass - Wolf Ranch Extension 1,000,000 633,943 366,057 37%
Public Works Department Total 53,277,541 34,155,324 19,122,218 36%
Right of Way
PRJ000200 Access Rtw To Government Srv 220,000 220,000 - 0%
Right of Way Total 220,000 220,000 - 0%
GCP Total 133,143,724 80,777,237 52,366,487 39%
General Capital Projects
Parks
PRJ000240 South Main Plaza 9,950 9,950 - 0%
PRJ000244 Grace Heritage Plaza 90,000 - 90,000 100%
Parks Total 99,950 9,950 90,000 90%
General Capital Projects Total 99,950 9,950 90,000 90%
GTEC
GTEC Department
PRJ000046 FM 971/ Fontana (Nw Bridge)1,209,000 1,206,390 2,610 0%
PRJ000053 IH 35/ Hwy 29 Intersection Imp 1,800,000 120,066 1,679,934 93%
PRJ000060 Rabbit Hill Road 4,100,000 208,022 3,891,978 95%
PRJ000083 Rivery Tia Improvements 1,179,000 1,110,970 68,030 6%
PRJ000145 Sh29 Signal And Roadway Improvements 1,595,000 379,089 1,215,911 76%
PRJ000181 Aviation Drive 10,300,000 1,252,353 9,047,647 88%
GTEC Department Total 20,183,000 4,276,889 15,906,111 79%
GTEC Total 20,183,000 4,276,889 15,906,111 79%
Stormwater
Stormwater
PRJ000004 18th and Hutto Drainage 50,000 5,969 44,031 88%
PRJ000005 2nd and Rock Pond 625,000 447,151 177,849 28%PRJ000024 2020 Curb & Gutter 1,055,000 766,902 288,098 27%
PRJ000104 Stormwater Infrastructure 347,000 168,506 178,495 51%
PRJ000148 Water Quality Ponds 98,000 - 98,000 100%
PRJ000149 Drainage Improvement/Flood Mitigation Projects 300,000 - 300,000 100%
PRJ000213 2021 Curb & Gutter Project 500,000 64,300 435,700 87%
Stormwater Total 2,975,000 1,452,828 1,522,172 51%
Stormwater Total 2,975,000 1,452,828 1,522,172 51%
Street Tax
Public Works Department
PRJ000172 2020 Street Maintenance High Performance Seal: Bid Package No.1 372,200 293,620 78,580 21%
PRJ000173 2020 Street Maintenance High Performance Seal: Bid Package No. 2 463,195 337,719 125,476 27%
PRJ000174 2020 street maintenance HIPR 1,935,589 1,441,013 494,576 26%
PRJ000210 2021 HIPR Street Maintenance 2,300,000 1,936,885 363,115 16%
PRJ000211 2021 High Performance Pavement Seal Project #1 750,000 94,900 655,100 87%
PRJ000212 2021 High Performance Pavement Seal Project #2 600,000 576,567 23,433 4%
PRJ000237 Northeast Inner Loop (Stadium to FM971) Emergency Repairs 700,000 737,756 (37,756) -5%
Public Works Department Total 7,120,983 5,418,460 1,702,523 24%
Street Tax Total 7,120,983 5,418,460 1,702,523 24%
Water
Water
PRJ000014 Berry Creek Inter.49,949,000 1,534,653 48,414,347 97%
PRJ000016 Braun Est 4,750,000 1,290,458 3,459,542 73%
PRJ000017 Cedar Breaks Est 3,385,000 236,730 3,148,270 93%
PRJ000023 Cr 255 (Wd14-2)1,493,963 323,841 1,170,122 78%
PRJ000025 Db Wood/ Pastor 24 Dedicated 5,286,000 440,726 4,845,274 92%
PRJ000034 Earz 2,326,000 493,493 1,832,507 79%
73
Capital Improvement Projects Life to Date Budget vs Spend
Project Budget vs Actuals Total Budget Total Spend Remaining Budget Percent Remaining
PRJ000057 Lift Station Upgrade 1,173,593 - 1,173,593 100%
PRJ000059 LWTP Raw Water Intake Rehab 6,750,000 6,657,072 92,928 1%
PRJ000066 Park Lift Station & Force Main 3,574,341 2,206,592 1,367,749 38%
PRJ000069 Pecan Branch Ph 2 253,000 238,041 14,959 6%
PRJ000075 Pumps & Storage 1,009,289 9,289 1,000,000 99%
PRJ000076 Rabbit Hill Est 1,826,000 873,294 952,706 52%
PRJ000085 Ronald Reagan/Daniels Mountain 4,400,000 170,580 4,229,420 96%
PRJ000088 San Gabriel Belt Press and Rehab 3,200,000 2,594,238 605,762 19%
PRJ000096 Shell Road Water Line 6,890,000 1,049,455 5,840,545 85%
PRJ000101 Southlake Wtp 100,000,000 12,223,397 87,776,603 88%
PRJ000119 Water Mains 1,537,000 516,275 1,020,725 66%
PRJ000123 WW Interceptors 608,431 - 608,431 100%
PRJ000150 Carriage Oaks Transmission 500,000 - 500,000 100%
PRJ000151 FY2020 CR262 Waterline 500,000 - 500,000 100%
PRJ000152 Hoover Pump Station 6,850,000 855,221 5,994,779 88%
PRJ000154 Stonewall Ranch Pump Station Improvements 500,000 - 500,000 100%
PRJ000155 Southside Water Treatment Plant 2,250,000 1,003,190 1,246,810 55%
PRJ000156 Gatlin/Teravista Improvements 450,000 - 450,000 100%
PRJ000157 Leander Interconnect 515,000 49,495 465,505 90%
PRJ000158 West loop (H-1A)2,119,000 447,385 1,671,615 79%
PRJ000160 Round Rock Supply Pump Station And Elevated Storage Tank 10,500,000 1,427,473 9,072,527 86%
PRJ000161 Miscellaneous Line Upgrades 872,000 721,813 150,187 17%
PRJ000162 South West Bypass Water (H24-1)2,906,000 2,498,026 407,974 14%
PRJ000163 Tank Rehabilitation 2,905,000 455,494 2,449,506 84%
PRJ000164 Council Chamber Water 423,000 15,960 407,040 96%
PRJ000165 San Gabriel WWTP Rehabilitation 2,500,000 98,000 2,402,000 96%
PRJ000167 San Gabriel Inter SGI -2 4,500,000 912,755 3,587,245 80%
PRJ000168 WWTP Upgrade 950,000 160,400 789,600 83%
PRJ000177 Northlake WTP Phase IV Expansion 15,000,000 11,859,923 3,140,077 21%
PRJ000185 Cimarron Hills Wastewater Treatment Plant Expansion 800,000 799,325 675 0%
PRJ000218 EARZ Wastewater Rehabilitation Area 2 - 2019 2,460,360 2,460,360 - 0%
PRJ000219 Southside GST Foundation Improvements 535,678 535,678 - 0%
PRJ000220 AMI Western District Improvements 750,000 - 750,000 100%
PRJ000228 Southside GST Roof Rehab 567,000 547,000 20,000 4%
PRJ000241 2020 - 2021 EARZ - Area 3 1,500,000 378,650 1,121,350 75%
Water Total 259,264,655 56,084,283 203,180,371 78%
Water Total 259,264,655 56,084,283 203,180,371 78%
Active Total 438,410,367 156,866,094 281,544,272 64%
Grand Total 438,410,367 156,866,094 281,544,272 64%
74
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 3/31/21 Status Updates ‐ 6/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 general fund transfer for FY2021 was reduced to
$35,000.
The FY2021 projected ending fund balance is $650,000.
The general fund transfer was restored to the $75,000
in the FY2022 budget.
Unfunded Actuarial Accrued
Liability (UAAL)
Recognizes the outstanding liability for the City’s
employee retirement plan through TMRS. The City
contributes monthly to fund the UAAL, based on an annual
percentage of payroll. Actual % of payroll costs is
recognized within each fund. The UAAL is provided by
TMRS and lags one year.
As of 9/30/2020, the net pension liability is $18.7
million and is 88.97% funded. This decrease in liability
is due to a change in the actuarial assumptions.
No Change
Other Post Employee Benefits
(OPEB)
While the City has no obligation to offer additional retiree
benefits, retirees are eligible to participate in the City’s
health insurance program. That ability represents a
subsidy that impacts health insurance costs to the City.
Retirees pay their monthly premiums to the self insurance
fund, which then processes their health insurance claims.
OPEB liability as of 9/30/2020 is $2.7 million. This is a
combination of sudden death benefits as well as post‐
retirement healthcare.
No Change
Compensated 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
CITY OF GEORGETOWN
Long-term Commitments, Reservations, and Other Unfunded Liabilities
6/30/2021
75
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 3/31/21 Status Updates ‐ 6/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 February Winter Storm Uri, the Electric
Fund incurred an additional $48 million in energy
market costs. The City issued a debt instrument that
will be paid from current PCA rates. There are no
expected changes to Electric reserves.
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.
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.
A competitive sealed bid has been completed for
ADA repairs along the South San Gabriel River
Trail. The contract is in Legal for review.
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.
76
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 3/31/21 Status Updates ‐ 6/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 awarded to Choice Builders.
Construction to begin in May 2021. FY21 Downtown
ADA Sidewalk improvements will be a continuation of
Downtown ADA improvements and closing gaps.
Design for this project will begin in May 2021. The
mobility bond passed in the May election, providing
new funding over the next 7 years for sidewalks.
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.
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.
University Park and Raintree Park equipment and the
outdoor pool slides at the Recreation Center were
scheduled to be completed in FY2020. However,
these were deferred due to financial constraints
related to COVID‐19. These deferrals total $290,000.
Additionally, the general fund transfer for FY2021 was
reduced from $200,000 to $50,000. Scheduled
maintenance equipment and replacement projects for
FY2021 total $402,000 not including the FY2021
deferrals. Staff has evaluated the FY2020 deferrals
and the scheduled FY2021 replacements and
prioritized to complete projects with greatest need.
These total $293,000 and will be completed with the
$50,000 transfer and existing fund balance.
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.
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.
Ordered 22 portable radios for Electric Dept. Ordered
9 mobiles and 4 portables for 911 Communications.
Processing 8 portable radios for Police in Workday.
Still working on the other 35 non‐public safety radios.
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.
77
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 3/31/21 Status Updates ‐ 6/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 Council declined to appropriate any available
fund balance during an April workshop. The February
Winter Storm Uri caused damage to a section of Inner
Loop. The Street Sales Tax Fund will cover the
approximately $700K for repairs. The road is not
eligible for FEMA reimbursement.
The FY2022 budget restores $500,000 General Fund
contribution to street maintenance.
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.
IT has drafted a cost recovery plan for fiber and it is
being evaluated as part of the FY2022 budget
development process.
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.
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.
IT has drafted a cost recovery plan for fiber and it is
being evaluated as part of the FY2022 budget
development process.
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.
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.
Facilities has drafted a cost recovery plan for fund
balance reserves and it is being evaluated as part of
the FY2022 budget development process.
This reserve is $800K short of meeting the reserve
requirement for FY2022.
78
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 3/31/21 Status Updates ‐ 6/30/21
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.
Due to the economic impacts of the pandemic,
reductions were made to General Fund base budgets
in FY2021, including public safety equipment. There is
no anticipated impact to employee safety. The funds
will need to be restored in FY2022, or as soon as
practical.
These funding lines were restored in the FY2022 budget.
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.
Council declined to appropriate any available fund
balance at mid‐year to achieve this goal. The Cost
Allocation Model study was put on hold due to
activities needed to recover from the Winter Storm.
This fund is $1.1M short of meeting the reserve
requirement for FY2022.
79
General Fund
Quarterly Comparison: Q3 FY2021 Budget Actuals
FY2021 YTD Actuals:
Q3 FY2021 Variance % of Budget Projections 2021 Variance
Fav/(Unfav)% of Projection
Planning
Personnel 1,383,026 958,703 424,323 69.32% 1,335,261 376,558 71.80%
Operations 593,976 459,031 134,945 77.28% 564,055 105,024 81.38%
Operating Capital 1,052 1,052 0 99.96%3,900 2,848 26.96%
Planning Total Expense 1,978,054 1,418,785 559,269 71.73% 1,903,216 484,430 74.55%
Library
Personnel 1,798,754 1,236,657 22,884 68.75% 1,828,761 592,103 67.62%
Operations 1,014,150 775,912 26,331 76.51% 1,016,162 240,250 76.36%
Operating Capital 25,000 7,960 (7,960) 31.84%7,960 - 100.00%
Library Total Expense 2,837,904 2,020,529 41,255 71.20% 2,852,883 832,353 70.82%
Parks Administration
Personnel 278,450 205,398 73,053 73.76% 276,737 71,339 74.22%
Operations 384,437 384,437 0.00% 366,670 366,670 0.00%
Parks Administration Total Expense 662,887 467,925 194,962 70.59% 643,407 175,482 72.73%
Parks
Personnel 1,540,835 1,038,579 502,256 67.40% 1,455,988 417,409 71.33%
Operations 1,186,579 913,797 272,782 77.01%1,184,709 270,912 77.13%
Operating Capital - - - 0.00%- - 0.00%
CIP Expense - 17,780 (17,780) 0.00%- (17,780) 0.00%
Parks Total Expense 2,727,414 1,970,156 757,257 72.24% 2,640,698 670,541 74.61%
Recreation
Personnel 1,606,081 1,170,809 435,272 72.90% 1,629,136 458,327 71.87%
Operations 1,293,300 843,741 449,559 65.24% 1,240,952 397,211 67.99%
Recreation Total Expense 2,899,381 2,014,550 884,831 69.48% 2,870,088 855,538 70.19%
Tennis Center
Personnel 235,401 158,646 76,754 67.39% 230,744 72,098 68.75%
Operations 207,516 120,623 86,893 58.13% 190,707 70,085 63.25%
Tennis Center Total Expense 442,917 279,269 163,648 63.05% 421,451 142,182 66.26%
Recreation Programs
Personnel 680,377 277,922 402,455 40.85% 651,365 373,443 42.67%
Operations 570,993 324,879 246,114 56.90% 442,228 117,350 73.46%
Budget Vs. Actuals
Year‐End:
Projections Vs. Actuals
80
General Fund
Quarterly Comparison: Q3 FY2021 Budget Actuals
FY2021 YTD Actuals:
Q3 FY2021 Variance % of Budget Projections 2021 Variance
Fav/(Unfav)% of Projection
Budget Vs. Actuals
Year‐End:
Projections Vs. Actuals
Recreation Programs Total Expense 1,251,370 602,801 648,569 48.17% 1,093,594 490,793 55.12%
Garey Park
Personnel 471,122 327,523 143,599 69.52% 491,455 163,932 66.64%
Operations 510,589 347,649 162,940 68.09% 483,418 135,770 71.91%
Operating Capital 311 (89) 400 -28.69%- 89 0.00%
Garey Park Total Expense 982,022 675,082 306,940 68.74% 974,873 299,791 69.25%
Arts and Culture
Operations 57,857 40,250 17,607 69.57%57,857 17,608 69.57%
Arts and Culture Total Expense 57,857 40,250 17,607 69.57%57,857 17,608 69.57%
Municipal Court
Personnel 484,734 347,942 136,792 71.78% 473,558 125,616 73.47%
Operations 100,389 57,645 42,744 57.42%83,151 25,506 69.33%
Municipal Court Total Expense 585,123 405,587 179,536 69.32% 556,709 151,122 72.85%
Fire Support Services/Administration
Personnel 2,877,376 1,696,517 1,180,859 58.96% 2,361,824 665,307 71.83%
Operations 1,446,067 1,094,374 351,693 75.68% 1,409,421 315,047 77.65%
Operating Capital 25,149 15,820 9,329 62.90%24,720 8,900 64.00%
Fire Support Total Expense 4,348,592 2,806,711 1,541,881 64.54% 3,795,965 989,254 73.94%
Fire Emergency Services
Personnel 13,493,986 9,441,884 4,052,101 69.97% 13,618,867 4,176,982 69.33%
Operations 2,379,405 1,593,357 786,048 66.96% 2,262,655 669,298 70.42%
Operating Capital 80,000 51,499 28,501 64.37%80,000 28,501 64.37%
Fire Emergency Services Total Expense 15,953,391 11,086,740 4,866,651 69.49% 15,961,522 4,874,782 69.46%
EMS
Personnel 1,749,042 1,494,318 254,724 85.44% 2,234,698 740,381 66.87%
Operations 773,749 584,426 189,323 75.53% 771,166 186,740 75.78%
Operating Capital 57,750 44,630 13,120 77.28%57,750 13,120 77.28%
EMS Total Expense 2,580,541 2,123,373 457,167 82.28% 3,063,614 940,241 69.31%
Inspection Services
81
General Fund
Quarterly Comparison: Q3 FY2021 Budget Actuals
FY2021 YTD Actuals:
Q3 FY2021 Variance % of Budget Projections 2021 Variance
Fav/(Unfav)% of Projection
Budget Vs. Actuals
Year‐End:
Projections Vs. Actuals
Personnel 1,366,692 915,051 451,642 66.95% 1,280,873 365,823 71.44%
Operations 181,221 107,306 73,915 59.21% 158,400 51,094 67.74%
Inspection Services Total Expense 1,547,913 1,022,357 525,556 66.05% 1,439,273 416,917 71.03%
Administrative Services
Personnel 1,367,229 995,068 372,161 72.78% 1,394,528 399,460 71.36%
Operations 526,707 334,016 192,691 63.42% 526,984 192,968 63.38%
Administration Services Total Expense 1,893,936 1,329,084 564,852 70.18% 1,921,512 592,428 69.17%
Community Services
Personnel 240,597 200,514 40,083 83.34% 246,932 46,417 81.20%
Operations 113,291 99,055 14,236 87.43% 112,479 13,424 88.07%
Community Services Total Expense 353,889 299,569 54,320 84.65% 359,411 59,841 83.35%
City Secretary
Personnel 524,370 384,362 140,007 73.30% 518,033 133,671 74.20%
Operations 485,402 363,760 121,642 74.94% 470,545 106,785 77.31%
City Secretary Total Expense 1,009,772 748,123 261,649 74.09% 988,578 240,456 75.68%
Communications/ Public Engagement
Personnel 533,969 383,091 150,877 71.74% 545,571 162,479 70.22%
Operations 310,635 155,948 154,687 50.20% 279,580 123,632 55.78%
Communications Total Expense 844,604 539,039 305,564 63.82% 825,151 286,111 65.33%
Police Administration
Personnel 652,285 467,343 184,943 71.65% 652,443 185,100 71.63%
Operations 1,915,563 1,332,980 582,583 69.59% 1,913,474 580,494 69.66%
Police Administration Total Expense 2,567,848 1,800,323 767,526 70.11% 2,565,917 765,594 70.16%
Police Operations
Personnel 12,308,896 9,132,053 3,176,843 74.19% 12,224,416 3,092,363 74.70%
Operations 2,283,105 1,475,217 807,888 64.61% 2,207,250 732,033 66.84%
Operating Capital 77,104 16,007 61,097 20.76%77,104 61,097 20.76%
Police Operations Total Expense 14,669,105 10,623,277 4,045,829 72.42% 14,508,770 3,885,493 73.22%
Animal Services
82
General Fund
Quarterly Comparison: Q3 FY2021 Budget Actuals
FY2021 YTD Actuals:
Q3 FY2021 Variance % of Budget Projections 2021 Variance
Fav/(Unfav)% of Projection
Budget Vs. Actuals
Year‐End:
Projections Vs. Actuals
Personnel 765,898 463,895 302,002 60.57% 707,099 243,203 65.61%
Operations 340,804 217,879 122,925 63.93% 339,590 121,711 64.16%
Animal Services Total Expense 1,106,702 681,774 424,928 61.60% 1,046,689 364,914 65.14%
Code Compliance
Personnel 464,093 283,814 180,278 61.15% 417,009 133,195 68.06%
Operations 95,650 75,901 19,749 79.35% 103,881 27,979 73.07%
Operating Capital 2,997 - 2,997 0.00%- - 0.00%
Code Compliance Total Expense 562,740 359,716 203,024 63.92% 520,890 161,174 69.06%
Public Works
Personnel 608,830 312,313 296,517 51.30% 483,229 170,916 64.63%
Operations 1,097,084 1,025,967 71,117 93.52% 1,149,450 123,483 89.26%
Operating Capital - 4,337 (4,337) 0.00%120 (4,217) 3615.62%
Public Works Total Expense 1,705,914 1,342,617 363,297 78.70% 1,632,799 290,182 82.23%
Streets
Personnel 1,384,302 897,626 486,676 64.84% 1,350,963 453,337 66.44%
Operations 1,752,107 1,283,780 468,327 73.27% 1,718,988 435,208 74.68%
Operating Capital 740 21,033 (20,293) 2842.37%12,544 (8,489) 167.67%
Streets Total Expense 3,137,149 2,202,440 934,710 70.21% 3,082,495 880,056 71.45%
Environmental Services
Operations 9,637,924 6,173,731 3,464,193 64.06% 9,641,349 3,467,618 64.03%
Operating Capital 25,000 - 25,000 0.00%25,000 25,000 0.00%
Environmental Services Total Expense 9,662,924 6,173,731 3,489,193 63.89% 9,666,349 3,492,618 63.87%
Non‐Departmental
Operations - 8,154 (8,154) 0.00%3,157 (4,997) 258.30%
Transfers 1,654,691 759,391 895,300 45.89% 6,354,691 5,595,300 11.95%
Non-Departmental Total Expense 1,654,691 767,545 887,146 46.39% 6,357,848 5,590,303 12.07%
General Government Contracts
Operations 6,024,808 4,159,360 1,865,448 69.04% 5,829,569 1,670,209 71.35%
Personnel (1,250,000) - (1,250,000) 0.00% (300,000) (300,000) 0.00%
General Government Contracts Expense 4,774,808 4,159,360 615,448 87.11% 5,529,569 1,370,209 75.22%
83
General Fund
Quarterly Comparison: Q3 FY2021 Budget Actuals
FY2021 YTD Actuals:
Q3 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 58,118,749 24,866,431 70.04% 87,477,342 29,358,593 66.44%
84