HomeMy WebLinkAboutFY 21 - 1st_Qtr_Report_FY2021_RedactedFINANCIAL REPORT AND INVESTMENT REPORT
For the Quarter Ended December 31, 2020
Table of Contents
Executive Summary .................................................................................................................................... 1-9
General Fund Schedule ............................................................................................................................... 10
Electric Fund Schedule ................................................................................................................................ 11
Water Services Fund Schedule .................................................................................................................... 12
Joint Services Fund Schedule ....................................................................................................................... 13
Council Discretionary Fund Schedule .......................................................................................................... 14
Convention & Visitors Bureau Fund Schedule ............................................................................................. 15
Airport Fund Schedule ................................................................................................................................. 16
Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 17
Georgetown Economic Development Corporation Fund Schedule ............................................................. 18
Quarterly Investment Report - City ........................................................................................................ 19-44
Quarterly Investment Report - GEDCO ................................................................................................... 45-50
Quarterly Investment Report - GTEC ...................................................................................................... 51-56
Grant Applications ....................................................................................................................................... 57
Capital Improvement Projects ................................................................................................................ 58-59
Long-term Commitments and Other Unfunded Liabilities ..................................................................... 60-63
COG ‐ General Fund Financial Report
Period: Dec‐20
Budget Period
FY2021 Dec‐20
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 15,548,923 ‐ 15,548,923 ‐ 100.00%
Revenue
40001:Property Taxes 15,976,505 7,435,713 9,241,457 (6,735,048) 57.84%
40002:Sales Taxes 18,576,250 1,761,889 1,825,349 (16,750,901) 9.83%
40005:Franchise Taxes 6,255,270 252,527 842,126 (5,413,144) 13.46%
40008:Other Taxes 400,000 51,779 51,779 (348,221) 12.94%
41001:Fines 328,392 13,918 42,799 (285,593) 13.03%
41002:Penalties 60,000 8,744 24,740 (35,260) 41.23%
42001:Interest Income 75,000 5,406 24,864 (50,136) 33.15%
43001:Fees 7,028,184 593,872 1,686,945 (5,341,239) 24.00%
43002:Garbage Charges 10,151,764 959,235 2,756,982 (7,394,782) 27.16%
43003:Permits 4,317,750 378,921 1,235,458 (3,082,292) 28.61%
43004:Administrative Charges 3,396,447 282,708 848,125 (2,548,322) 24.97%
43005:Rental Revenue 148,140 2,819 67,516 (80,624) 45.58%
45001:Misc Revenue 871,955 6,941 62,844 (809,111) 7.21%
44001:Grant Revenue 679,884 64,720 191,687 (488,197) 28.19%
44502:Developer Contributions ‐ 141 216 216 0.00%
44503:Interlocal Agreement Revenue 5,091,091 1,183,773 1,183,773 (3,907,318) 23.25%
44504:Donations ‐ 1,400 4,776 4,776 0.00%
70001:Transfers In 995,302 995,302 995,302 ‐ 100.00%
70002:Transfers In ‐ ROI 8,431,375 693,380 2,253,819 (6,177,556) 26.73%
Revenue Total 82,783,309 14,693,188 23,340,556 (59,442,752) 28.19%
Expense
CC0001 Non‐Departmental 1,353,191 653,191 653,191 700,000 48.27%
CC0107 Planning 1,860,789 126,548 414,497 1,446,292 22.28%
CC0202 Parks Administration 662,224 56,783 159,379 502,845 24.07%
CC0210 Library 2,837,904 233,541 696,447 2,141,457 24.54%
CC0211 Parks 2,721,425 235,666 772,513 1,948,912 28.39%
CC0212 Recreation 2,895,675 235,756 674,609 2,221,066 23.30%
CC0213 Tennis Center 442,917 33,673 88,581 354,335 20.00%
CC0214 Recreation Programs 1,239,636 50,802 155,286 1,084,350 12.53%
CC0215 Garey Park 979,961 70,002 296,425 683,536 30.25%
CC0218 Arts and Culture 57,857 4,373 16,845 41,012 29.11%
CC0316 Municipal Court 585,123 50,720 131,341 453,782 22.45%
CC0402 Fire Support Services/Administration 4,254,731 334,350 938,144 3,316,587 22.05%
CC0422 Fire Emergency Services 15,932,476 1,373,496 3,636,467 12,296,009 22.82%
CC0448 EMS 2,579,106 202,511 748,753 1,830,352 29.03%
CC0533 Environmental Services 9,633,924 765,221 1,487,499 8,146,425 15.44%
CC0536 Inspection Services 1,519,534 115,273 312,111 1,207,423 20.54%
CC0602 Administrative Services 1,893,883 148,307 505,511 1,388,372 26.69%
CC0605 Community Services 353,889 22,955 90,358 263,531 25.53%
CC0634 City Council Services 185,734 19,349 48,501 137,233 26.11%
CC0635 City Secretary Services 1,000,047 76,278 212,883 787,163 21.29%
CC0638 General Government Contracts 4,774,808 348,814 1,676,765 3,098,043 35.12%
CC0655 Communications/Public Engagement 844,604 51,530 195,180 649,423 23.11%
CC0702 Police Administration 2,559,766 194,124 645,551 1,914,215 25.22%
CC0742 Police Operations 14,335,833 1,369,863 3,453,952 10,881,881 24.09%
CC0744 Animal Services 1,106,702 78,116 235,584 871,117 21.29%
CC0745 Code Compliance 562,584 38,110 112,709 449,874 20.03%
CC0802 Public Works 1,641,292 46,120 727,704 913,587 44.34%
CC0846 Streets 3,086,124 191,625 948,748 2,137,377 30.74%
Expense Total 81,751,737 7,127,094 20,035,395 61,716,342 24.51%
Excess (Deficiency) of Total Revenue over Total
Requirements 1,031,571 7,566,094 3,305,161 4,336,732 320.40%
Ending Fund Balance 16,580,494 18,854,084 2,273,590 113.71%
Reserves
Contingency Reserve 12,626,752 ‐ 12,626,752 ‐ 100.00%
Benefit Payout Reserve 340,000 ‐ 340,000 ‐ 100.00%
Economic Stability Reserve 1,467,563 ‐ 1,467,563 ‐ 100.00%
Reserve Total 14,434,315 ‐ 14,434,315 ‐ 100.00%
Avaiable Fund Balance 2,146,179 4,419,769 2,273,590 205.94%
Actuals Budget vs. Actuals
10
COG ‐ Electric Services Financial Report
Period: Dec‐20
Budget Period
FY2021 Dec‐20
YTD Actuals
w/Encumbrances Variance % Variance
Beginning Fund Balance 19,702,705 19,702,705 19,702,705 ‐ 100.00%
Operating Revenue
40002:Sales Taxes 5,000 291 872 (4,128) 17.43%
40005:Franchise Taxes 115,732 ‐ ‐ (115,732) 0.00%
41002:Penalties 553,724 69,854 223,636 (330,088) 40.39%
42001:Interest Income 5,000 2,133 14,536 9,536 290.72%
43001:Fees 685,000 45,213 299,611 (385,389) 43.74%
43004:Administrative Charges 3,222,103 268,509 805,526 (2,416,577) 25.00%
43601:Electric Charges 78,982,278 6,410,100 18,996,014 (59,986,264) 24.05%
44502:Developer Contributions 1,500,000 115,415 2,142,271 642,271 142.82%
70001:RC0225 Transfer In ‐ GEDCO 1,000,000 ‐ ‐ (1,000,000) 0.00%
70001:RC0241 Transfer In ‐ South TIRZ 379,308 379,308 379,308 ‐ 100.00%
Operating Revenue Total 86,448,145 7,290,824 22,861,772 (63,586,373) 26.45%
Opearating Expense
CC0001 Non‐Departmental 5,506,375 1,131,209 2,009,251 3,497,124 36.49%
CC0521 Electric Technical Services 711,765 53,546 168,894 542,871 23.73%
CC0522 Electric Administration 8,738,050 680,149 2,078,471 6,659,579 23.79%
CC0524 Metering Services 2,009,379 138,619 433,163 1,576,216 21.56%
CC0525 T&D Services 3,048,996 369,631 864,733 2,184,263 28.36%
CC0537 Electric Resource Management 60,334,393 5,103,105 17,028,177 43,306,216 28.22%
CC0555 Electric Systems Operations 1,448,902 136,482 360,807 1,088,095 24.90%
CC0557 Electrical Engineering 636,869 88,589 211,783 425,087 33.25%
Operating Expense Total 82,434,729 7,701,329 23,155,279 59,279,451 28.09%
Net Operations Total 4,013,416 (410,505) (293,507) (4,306,922) ‐7.31%
Non‐Operating Revenue
45001:Misc Revenue 35,000 248 16,586 (18,414) 47.39%
45004:Sale of Property 10,000 ‐ 2,559 (7,441) 25.59%
46001:Bond Proceeds 6,648,625 ‐ ‐ (6,648,625) 0.00%
Non‐Operating Revenue Total 6,693,625 248 19,145 (6,674,480) 0.29%
Non‐Operating Expenses
CC0001 Non‐Departmental 4,152,805 ‐ ‐ 4,152,805 0.00%
CC0557 Electrical Engineering 8,166,143 178,756 869,269 7,296,874 10.64%
Non‐Operating Expense Total 12,318,948 178,756 869,269 11,449,679 7.06%
Net Non‐Operations Total (5,625,323) (178,508) (850,124) 4,775,199 15.11%
Excess (Deficiency) of Total Revenue over Total Requirements (1,611,907) (589,013) (1,143,630) (2,755,537) 70.95%
Ending Fund Balance 18,090,798 19,113,692 18,559,075 468,276 102.59%
Reserves
Contingency Reserve 4,018,754 ‐ 4,018,754 ‐ 100.00%
Non‐Operational Reserve 10,594,999 ‐ 10,594,999 ‐ 100.00%
Bond Proceeds Reserve 3,477,046 ‐ 3,477,046 ‐ 100.00%
Reserves Total 18,090,799 18,090,799 ‐ 100.00%
Available Fund Balance 0 468,276 (468,276) 0.00%
YTD Actuals Budget vs. Actuals
11
COG ‐ Water Services Financial Report
Period: Dec‐20
Budget Period
FY2021 Dec‐20
YTD Actuals
w/Encumbrances Variance % Variance
Beginning Fund Balance 115,511,818 ‐ 115,511,818 ‐ 100.00%
Operating Revenue
41002:Penalties 255,000 48,012 136,031 (118,969) 53.35%
42001:Interest Income 237,250 29,446 161,120 (76,130) 67.91%
43001:Fees 4,290,000 786,031 2,305,932 (1,984,068) 53.75%
43005:Rental Revenue 55,000 ‐ 48,294 (6,706) 87.81%
43602:Water Charges 32,150,000 2,579,846 8,724,206 (23,425,794) 27.14%
43603:Wastewater Charges 14,200,000 1,169,178 3,448,001 (10,751,999) 24.28%
43604:Irrigation Charges 300,000 22,868 91,370 (208,630) 30.46%
41602:Impact Fees 18,800,000 2,969,163 6,500,314 (12,299,686) 34.58%
44502:Developer Contributions 625,000 ‐ ‐ (625,000) 0.00%
Operating Revenue Total 70,912,250 7,604,543 21,415,267 (49,496,983) 30.20%
Opearating Expense
CC0001 Non‐Departmental 4,041,064 577,881 1,212,948 2,828,116 30.02%
CC0527 Water Services Administration 26,385,392 1,515,094 8,368,710 18,016,682 31.72%
CC0528 Water Distribution 2,717,500 268,730 862,351 1,855,149 31.73%
CC0529 Water Plant Management 4,261,242 158,140 1,290,823 2,970,418 30.29%
CC0530 Wastewater Operations 896,100 58,441 255,426 640,674 28.50%
CC0531 Wastewater Plant Management 3,956,455 263,528 984,422 2,972,033 24.88%
CC0532 Irrigation Operations 295,000 16,108 57,213 237,787 19.39%
CC0553 Water Operations 3,916,787 356,321 974,772 2,942,015 24.89%
Operating Expense Total 46,469,539 3,214,243 14,006,666 32,462,873 30.14%
Net Operations Total 24,442,711 4,390,300 7,408,601 (17,034,110) 30.31%
Non‐Operating Revenue
45001:Misc Revenue 1,112,500 ‐ 220 (1,112,280) 0.02%
46001:Bond Proceeds 16,300,000 ‐ ‐ (16,300,000) 0.00%
Non‐Operating Revenue Total 17,412,500 ‐ 220 (17,412,280) 0.00%
Non‐Operating Expenses
CC0001 Non‐Departmental 4,083,411 ‐ ‐ 4,083,411 0.00%
CC0524 Metering Services 750,000 ‐ ‐ 750,000 0.00%
CC0526 Systems Engineering 114,152,192 219,991 22,386,283 91,765,909 19.61%
CC0528 Water Distribution ‐ ‐ 456,600 (456,600) 0.00%
CC0529 Water Plant Management 2,757 ‐ ‐ 2,757 0.00%
CC0530 Wastewater Operations 3,026,798 ‐ ‐ 3,026,798 0.00%
CC0531 Wastewater Plant Management 2,650,000 ‐ ‐ 2,650,000 0.00%
CC0532 Irrigation Operations 121,879 ‐ ‐ 121,879 0.00%
CC0553 Water Operations ‐ 967,044 10,953,288 (10,953,288) 0.00%
Non‐Operating Expense Total 124,787,037 1,187,034 33,796,171 90,990,866 27.08%
Net Non‐Operations Total (107,374,537) (1,187,034) (33,795,951) 73,578,586 31.47%
Excess (Deficiency) of Total Revenue over Total Requirements (82,931,826) 3,203,266 (26,387,350) (109,319,175) 31.82%
Ending Fund Balance 32,579,992 3,203,266 89,124,468 56,544,476 273.56%
Reserves
Contingency Reserve 9,127,742 ‐ 9,127,742 ‐ 100.00%
Debt Service Reserve 10,000,000 ‐ 10,000,000 ‐ 100.00%
19,127,742 ‐ 19,127,742 ‐ 100.00%
Available Fund Balance 13,452,250 69,996,726 83,448,977 520.33%
YTD Actuals Budget vs. Actuals
12
COG ‐ Joint Services Financial Report
Period: Dec‐20
Budget Period
FY2021 Dec‐20
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 2,032,470 ‐ 2,032,470 ‐ 100.00%
Revenue
41002:Penalties ‐ 4,287 8,877 8,877 0.00%
42001:Interest Income 6,250 406 3,661 (2,589) 58.58%
43001:Fees 173,600 2,220 3,690 (169,910) 2.13%
43004:Administrative Charges 17,967,880 1,497,575 4,492,724 (13,475,156) 25.00%
43005:Rental Revenue ‐ 100 100 100 0.00%
45001:Misc Revenue ‐ ‐ 431 431 0.00%
45002:Insurance Proceeds ‐ 5,675 27,409 27,409 0.00%
45003:Misc Reimbursements 83,000 6,232 22,432 (60,569) 27.03%
Revenue Total 18,230,730 1,516,494 4,559,324 (13,671,406) 25.01%
Expense
CC0001 Non‐Departmental 609,999 148,792 353,097 256,902 57.88%
CC0302 Finance Administration 1,253,909 119,960 398,561 855,348 31.79%
CC0315 Accounting 1,264,484 109,186 373,113 891,372 29.51%
CC0317 Purchasing 1,001,969 82,209 221,865 780,105 22.14%
CC0321 Customer Care 5,986,413 507,609 1,391,485 4,594,927 23.24%
CC0503 Organizational and Operational Excellence 342,009 24,804 69,160 272,849 20.22%
CC0526 Systems Engineering 2,752,912 225,781 697,520 2,055,392 25.34%
CC0534 Conservation 806,212 43,594 190,273 615,939 23.60%
CC0547 Business System Services ‐ ‐ 904 (904) 0.00%
CC0637 Economic Development 568,690 41,320 123,773 444,917 21.76%
CC0639 Human Resources 1,502,553 125,809 340,133 1,162,420 22.64%
CC0640 Citywide Human Resources 1,219,444 (153,810) 589,742 629,702 48.36%
CC0654 Legal 1,047,947 102,336 285,819 762,129 27.27%
Expense Total 18,356,541 1,377,592 5,035,445 13,321,096 27.43%
Excess (Deficiency) of Total Revenue over Total
Requirements (125,811) 138,902 (476,121) (601,933) 378.44%
Ending Fund Balance 1,906,659 1,556,349
Reserves
Reserve Total ‐ ‐ 1,906,658 ‐ ‐
Avaiable Fund Balance 1,906,658 (350,310)
Actuals Budget vs. Actuals
13
COG ‐ Council Discretionary Financial Report
Period: Dec‐20
Budget Period
FY2021 Dec‐20
YTD Actuals
w/Encumbrances Variance % Variance
Beginning Fund Balance 111,172 111,172 ‐ 100.00%
Revenue
42001:Interest Income 500 0 121 (379) 24.27%
Revenue Total 500 0 121 (379) 24.27%
Expense
Transfers 110,983 110,983 110,983 ‐ 100.00%
Expense Total 110,983 110,983 110,983 ‐ 100.00%
Excess (Deficiency) of Total Revenue over Total
Requirements (110,483) (110,983) (110,862) (221,345) 100.34%
Ending Fund Balance 689 310
Reserves
Contingency Reserve ‐ ‐
Reserve Total ‐ ‐ ‐ ‐ ‐
Avaiable Fund Balance 689 310
Actuals Budget vs. Actuals
14
COG ‐ Tourism Financial Report
Period: Dec‐20
Budget Period
FY2021 Dec‐20
YTD Actuals
w/Encumbrances Variance % Variance
Beginning Fund Balance 1,282,917 1,282,917 ‐ 100.00%
Revenue
40008:Other Taxes 900,000 67,695 141,184 (758,816) 15.69%
42001:Interest Income 5,000 343 2,110 (2,890) 42.20%
45001:Misc Revenue 95,000 2,038 4,307 (90,693) 4.53%
44505:Sponsorship 50,000 ‐ ‐ (50,000) 0.00%
Revenue Total 1,050,000 70,076 147,601 (902,399) 14.06%
Expense
Personnel 435,456 33,670 81,125 354,331 18.63%
Operations 1,014,085 31,823 252,374 761,711 24.89%
Transfers 28,634 28,634 28,634 ‐ 100.00%
Expense Total 1,478,175 94,127 362,133 1,116,042 24.50%
Excess (Deficiency) of Total Revenue over Total
Requirements (428,175) (24,051) (214,532) (642,707) 50.10%
Ending Fund Balance 854,742 1,068,385
Reserves
Contingency Reserve 305,771 305,771
Reserve Total 305,771 ‐ 305,771 ‐ ‐
Avaiable Fund Balance 548,971 762,614
Actuals Budget vs. Actuals
15
COG ‐ Airport Operations Financial Report
Period: Dec‐20
Budget Period
FY2021 Dec‐20
YTD Actuals
w/Encumbrances Variance % Variance
Beginning Fund Balance 1,428,114 1,428,114 ‐ 100.00%
Operating Revenue
40001:Property Taxes 40,000 ‐ (57,018) (97,018) ‐142.54%
42001:Interest Income 3,000 270 1,577 (1,423) 52.58%
43606:Airport Charges 3,408,500 275,873 841,470 (2,567,030) 24.69%
Operating Revenue Total 3,451,500 276,142 786,030 (2,665,470) 22.77%
Operarting Expense
Personnel 429,433 37,492 97,868 331,565 22.79%
Operations 3,138,013 ‐ 3,402,441 (264,428) 108.43%
Operating Capital 354,067 1,006 1,006 353,061 0.28%
Operating Expense Total 3,921,513 249,906 3,712,722 208,791 94.68%
Total Net Operations (470,013) 26,236 (2,926,692) (2,874,260) 622.68%
Non‐Operating Revenue
45001:Misc Revenue 5,000 ‐ ‐ (5,000) 0.00%
46001:Bond Proceeds 700,000 ‐ ‐ (700,000) 0.00%
Non‐Operating Revenue Total 705,000 ‐ ‐ (705,000) 0.00%
Non‐Operating Expense
CIP Expense 750,000 ‐ ‐ 750,000 0.00%
Debt Service 158,931 ‐ ‐ 158,931 0.00%
Non‐Operating Expense Total 908,931 ‐ ‐ 908,931 0.00%
Net Non‐Operations Total (203,931) ‐ ‐ 203,931 0.00%
Excess (Deficiency) of Total Revenue over Total Requirements (673,944) 26,236 (2,926,692) (3,600,636) 534.26%
Ending Fund Balance 754,170 26,236 (1,498,578) (744,408) ‐50.33%
Reserves
Contingency Reserve 332,917 332,917 332,917 ‐ 100%
Debt Service Reserve 141,478 141,478 141,478 ‐ 100%
Reserves Total 474,395 474,395 474,395 ‐ 100%
Available Fund Balance 279,775 (1,972,973) (2,252,749) ‐14.18%
YTD Actuals Budget Vs. Actuals
16
COG ‐ GTEC Financial Report
Period: Dec‐20
Budget Period
FY2021 Dec‐20
YTD Actuals
w/Encumbrances Variance % Variance
Beginning Fund Balance 26,022,482 26,022,482 26,022,482 ‐ 100.00%
Operating Revenue
40002:Sales Taxes 8,255,000 782,980 811,070 (7,443,930) 9.83%
42001:Interest Income 60,000 3,027 10,194 (49,806) 16.99%
Operating Revenue Total 8,315,000 786,006 821,264 (7,493,736) 9.88%
Operarting Expense
Operations 402,962 33,514 240,817 162,145 59.76%
Operating Capital ‐ ‐ 4,140 (4,140) 0.00%
Transfers 2,763,242 ‐ ‐ 2,763,242 0.00%
Operating Expense Total 3,166,204 33,514 244,957 2,921,247 7.74%
1% #DIV/0!
Total Net Operations 5,148,796 752,493 576,307 (10,414,983) 11.19%
Non‐Operating Revenue
46001:Bond Proceeds 10,600,000 ‐ ‐ (10,600,000) 0.00%
Non‐Operating Revenue Total 10,600,000 ‐ ‐ (10,600,000) 0.00%
Non‐Operating Expense
Operations 1,984,375 ‐ ‐ 1,984,375 0.00%
CIP Expense 23,076,813 115,414 328,802 22,748,012 1.42%
Debt Service 1,053,050 ‐ ‐ 1,053,050 0.00%
Non‐Operating Expense Total 26,114,238 115,414 328,802 25,785,437 1.26%
Net Non‐Operations Total (15,514,238) (115,414) (328,802) 15,185,437 2.12%
Excess (Deficiency) of Total Revenue over Total Requirements (10,365,442) 637,079 247,505 (10,117,937) 97.61%
Ending Fund Balance 15,657,040 26,659,561 26,269,987 41,927,027 59.60%
Reserves
Contingency Reserve 1,984,375 1,984,375 1,984,375 ‐ 100%
Debt Service Reserve 3,494,232 3,494,232 3,494,232 ‐ 100%
Reserves Total 5,478,607 5,478,607 5,478,607 ‐ 100%
Available Fund Balance 10,178,433 20,791,380 10,612,947 48.96%
YTD Actuals Budget Vs. Actuals
17
COG ‐ GEDCO Financial Report
Period: Dec‐20
Budget Period
FY2021 Dec‐20
YTD Actuals
w/Encumbrances Variance % Variance
Beginning Fund Balance 8,845,777 8,845,777 8,845,777 ‐ 100.00%
Operating Revenue
40002:Sales Taxes 2,063,750 195,745 202,767 (1,860,983) 9.83%
42001:Interest Income 19,000 630 10,897 (8,103) 57.35%
Operating Revenue Total 2,082,750 196,375 213,664 (1,869,086) 10.26%
Operarting Expense
Operations 593,783 29,649 146,368 447,415 24.65%
Transfers 1,200,169 ‐ ‐ 1,200,169 0.00%
Operating Expense Total 1,793,952 29,649 146,368 1,647,584 8.16%
Total Net Operations 288,798 166,726 67,297 (3,516,670) 23.30%
Non‐Operating Revenue
Non‐Operating Expense
Operations 8,256,391 ‐ ‐ 8,256,391 0.00%
Debt Service 90,572 ‐ ‐ 90,572 0.00%
Non‐Operating Expense Total 8,346,963 ‐ ‐ 8,346,963 0.00%
Net Non‐Operations Total (8,346,963) ‐ ‐ 8,346,963 0.00%
Excess (Deficiency) of Total Revenue over Total Requirements (8,058,165) 166,726 67,297 (7,990,869) 99.16%
Ending Fund Balance 787,612 9,012,503 8,913,074 9,700,686 8.84%
Reserves
Contingency Reserve 505,468 505,468 505,468 ‐ 100%
Debt Service Reserve 413,087 413,087 413,087 ‐ 100%
Non‐Operational Reserve (210,318) ‐ (210,318) ‐ 100%
Reserves Total 708,237 918,555 708,237 ‐ 100%
Available Fund Balance 79,375 8,204,837 8,125,462 0.97%
YTD Actuals Budget Vs. Actuals
18
CITY
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
December 31, 2020
Prepared by
Valley View Consulting, L.L.C.
The investment portfolio of the City of Georgetown is in compliance with the Public Funds Investment Act and
the Investment Policy and Strategies.
Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or
completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from
sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective
of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total
return yields and do not account for investment advisor fees.
19
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Demand Accounts 9,505,298$ 9,505,298 15,461,481$ 15,461,481$ 0.27%
NOW/MMA 15,087,991 15,087,991 12,024,426 12,024,426 0.31%
Pools 103,065,896 103,065,896 108,820,032 108,820,032 0.08%
CDs/Securities 112,639,369 112,640,201 122,010,850 122,010,850 0.65%Totals 240,298,554$ 240,299,385$ 258,316,790$ 258,316,790$ 0.37%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.37%Total Portfolio 0.37%
Rolling Three Month Treasury 0.09%Rolling Three Month Treasury 0.09%
Rolling Six Month Treasury 0.12%Rolling Six Month Treasury 0.12%
TexPool 0.09%TexPool 0.09%
Bank Fees Offset
8,111$
Interest earnings provided in separate report.8,111$
September 30, 2020
(1) Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not
considered. The yield for the reporting month is used for bank, pool, and money market balances.
(2) Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return
analysis or account for advisory fees.
Quarterly Bank Fees Offset
Year-to-date Bank Fees Offset
December 31, 2020
City of Georgetown Valley View Consulting, L.L.C.20
City - Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
JPMorgan Chase Cash (3)0.27%01/01/21 12/31/20 15,461,481$ 15,461,481$ 1.00 15,461,481$ 1 0.27%
JPMorgan Chase MMA 0.03%01/01/21 12/31/20 434,016 434,016 1.00 434,016 1 0.03%
Veritex Bank MMA 0.14%01/01/21 12/31/20 3,212,254 3,212,254 1.00 3,212,254 1 0.14%
NexBank MMA 0.45%01/01/21 12/31/20 7,364,008 7,364,008 1.00 7,364,008 1 0.45%
Origin Bank MMA 0.00%01/01/21 12/31/20 1,014,148 1,014,148 1.00 1,014,148 1 0.00%
TexPool AAAm 0.09%01/01/21 12/31/20 44,199,066 44,199,066 1.00 44,199,066 1 0.09%
TexSTAR AAAm 0.07%01/01/21 12/31/20 64,620,967 64,620,967 1.00 64,620,967 1 0.07%
East West Bank CD 1.71%01/08/21 01/08/20 3,050,882 3,050,882 100.00 3,050,882 8 1.72%
Independent Bank CD 1.70%02/05/21 02/05/20 3,139,621 3,139,621 100.00 3,139,621 36 1.71%
Independent Bank CD 0.60%02/08/21 05/08/20 11,033,296 11,033,296 100.00 11,033,296 39 0.60%
East West Bank CD 0.32%02/18/21 08/18/20 9,010,737 9,010,737 100.00 9,010,737 49 0.32%
R Bank CD 1.81%02/19/21 02/19/20 4,054,719 4,054,719 100.00 4,054,719 50 1.83%
Bank OZK CD 1.72%02/26/21 02/27/20 6,086,273 6,086,273 100.00 6,086,273 57 1.73%
Southside Bank CD 0.21%03/11/21 09/11/20 5,002,618 5,002,618 100.00 5,002,618 70 0.21%
Bank OZK CD 0.25%03/11/21 09/11/20 1,500,935 1,500,935 100.00 1,500,935 70 0.25%
East West Bank CD 0.29%03/15/21 09/14/20 3,503,032 3,503,032 100.00 3,503,032 74 0.29%
Prosperity Bank CD 0.45%04/01/21 07/01/20 4,006,098 4,006,098 100.00 4,006,098 91 0.45%
Independent Bank CD 1.80%04/22/21 10/22/19 4,174,339 4,174,339 100.00 4,174,339 112 1.81%
Bank OZK CD 0.70%05/10/21 05/08/20 12,049,407 12,049,407 100.00 12,049,407 130 0.70%
Southside Bank CD 0.22%06/11/21 09/11/20 5,002,742 5,002,742 100.00 5,002,742 162 0.22%
Bank OZK CD 0.30%06/11/21 09/11/20 5,003,741 5,003,741 100.00 5,003,741 162 0.30%
Prosperity Bank CD 0.60%07/01/21 07/01/20 4,006,033 4,006,033 100.00 4,006,033 182 0.60%
Prosperity Bank CD 0.70%07/15/21 07/15/20 5,008,798 5,008,798 100.00 5,008,798 196 0.70%
East West Bank CD 0.32%08/18/21 08/18/20 2,002,386 2,002,386 100.00 2,002,386 230 0.32%
Prosperity Bank CD 0.40%08/23/21 08/21/20 6,251,322 6,251,322 100.00 6,251,322 235 0.40%
East West Bank CD 0.26%09/09/21 12/09/20 4,069,844 4,069,844 100.00 4,069,844 252 0.26%
Prosperity Bank CD 0.30%10/14/21 10/14/20 2,501,250 2,501,250 100.00 2,501,250 287 0.30%
Independent Bank CD 0.40%10/18/21 10/18/20 2,546,598 2,546,598 100.00 2,546,598 291 0.40%
Prosperity Bank CD 0.30%11/22/21 11/20/20 3,000,738 3,000,738 100.00 3,000,738 326 0.30%
East West Bank CD 0.21%12/30/21 12/30/20 3,000,035 3,000,035 100.00 3,000,035 364 0.21%
Prosperity Bank CD 0.30%01/21/22 10/21/20 4,002,000 4,002,000 100.00 4,002,000 386 0.30%
Prosperity Bank CD 0.35%04/21/22 10/21/20 2,501,459 2,501,459 100.00 2,501,459 476 0.35%
December 31, 2020
City of Georgetown Valley View Consulting, L.L.C.22
City - Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
December 31, 2020
Prosperity Bank CD 0.35%05/17/22 11/17/20 2,000,574 2,000,574 100.00 2,000,574 502 0.35%
Prosperity Bank CD 0.35%08/22/22 11/20/20 2,500,717 2,500,717 100.00 2,500,717 599 0.35%
Prosperity Bank CD 0.40%11/17/22 11/17/20 2,000,656 2,000,656 100.00 2,000,656 686 0.40%
TOTALS 258,316,790$ 258,316,790$ 258,316,790$ 82 0.37%
(1)(2)
(2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not
considered. The yield for the reporting month is used for bank accounts, pools, and money market funds.
(1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity.
(3) Earnings Credit - The City's depository accounts provide an earnings credit on balances which is used to offset bank fees.
City of Georgetown Valley View Consulting, L.L.C.23
City - Book & Market Value Comparison
Issuer/Description Yield Maturity
Date
Book Value
09/30/20 Increases Decreases Book Value
12/31/20
Market Value
09/30/20
Change in
Market Value
Market Value
12/31/20
JPMorgan Chase Cash 0.27%01/01/21 9,505,298$ 5,956,183$ –$ 15,461,481$ 9,505,298$ 5,956,183$ 15,461,481$
JPMorgan Chase MMA 0.03%01/01/21 433,983 33 – 434,016 433,983 33 434,016
Veritex Bank MMA 0.14%01/01/21 3,210,906 1,348 – 3,212,254 3,210,906 1,348 3,212,254
NexBank MMA 0.45%01/01/21 7,355,685 8,324 – 7,364,008 7,355,685 8,324 7,364,008
Origin Bank MMA 0.00%01/01/21 4,087,417 – (3,073,268) 1,014,148 4,087,417 (3,073,268) 1,014,148
TexPool 0.09%01/01/21 28,793,102 15,405,963 – 44,199,066 28,793,102 15,405,963 44,199,066
TexSTAR 0.07%01/01/21 74,272,794 – (9,651,827) 64,620,967 74,272,794 (9,651,827) 64,620,967
T-Bill 1.60%10/08/20 2,499,139 – (2,499,139) – 2,499,970 (2,499,970) –
Independent Bank CD 1.86%10/18/20 2,534,811 – (2,534,811) – 2,534,811 (2,534,811) –
East West Bank CD 0.55%11/09/20 3,006,607 – (3,006,607) – 3,006,607 (3,006,607) –
Independent Bank CD 2.58%11/10/20 1,032,494 – (1,032,494) – 1,032,494 (1,032,494) –
R Bank CD 1.78%11/19/20 2,521,930 – (2,521,930) – 2,521,930 (2,521,930) –
Southside Bank CD 1.73%11/19/20 3,258,686 – (3,258,686) – 3,258,686 (3,258,686) –
East West Bank CD 1.72%12/09/20 4,056,045 – (4,056,045) – 4,056,045 (4,056,045) –
East West Bank CD 1.72%01/08/21 3,037,761 13,121 – 3,050,882 3,037,761 13,121 3,050,882
Independent Bank CD 1.71%02/05/21 3,126,261 13,359 – 3,139,621 3,126,261 13,359 3,139,621
Independent Bank CD 0.60%02/08/21 11,016,636 16,661 – 11,033,296 11,016,636 16,661 11,033,296
East West Bank CD 0.32%02/18/21 9,003,472 7,265 – 9,010,737 9,003,472 7,265 9,010,737
R Bank CD 1.83%02/19/21 4,036,263 18,456 – 4,054,719 4,036,263 18,456 4,054,719
Bank OZK CD 1.73%02/26/21 6,060,233 26,040 – 6,086,273 6,060,233 26,040 6,086,273
Southside Bank CD 0.21%03/11/21 5,000,000 2,618 – 5,002,618 5,000,000 2,618 5,002,618
Bank OZK CD 0.25%03/11/21 1,500,000 935 – 1,500,935 1,500,000 935 1,500,935
East West Bank CD 0.29%03/15/21 3,500,473 2,560 – 3,503,032 3,500,473 2,560 3,503,032
Prosperity Bank CD 0.45%04/01/21 4,004,525 1,574 – 4,006,098 4,004,525 1,574 4,006,098
Independent Bank CD 1.81%04/22/21 4,155,537 18,802 – 4,174,339 4,155,537 18,802 4,174,339
Bank OZK CD 0.70%05/10/21 12,028,372 21,034 – 12,049,407 12,028,372 21,034 12,049,407
Southside Bank CD 0.22%06/11/21 5,000,000 2,742 – 5,002,742 5,000,000 2,742 5,002,742
Bank OZK CD 0.30%06/11/21 5,000,000 3,741 – 5,003,741 5,000,000 3,741 5,003,741
Prosperity Bank CD 0.60%07/01/21 4,006,033 – – 4,006,033 4,006,033 – 4,006,033
Prosperity Bank CD 0.70%07/15/21 5,007,459 1,339 – 5,008,798 5,007,459 1,339 5,008,798
East West Bank CD 0.32%08/18/21 2,000,772 1,614 – 2,002,386 2,000,772 1,614 2,002,386
Prosperity Bank CD 0.40%08/23/21 6,245,860 5,463 – 6,251,322 6,245,860 5,463 6,251,322
East West Bank CD 0.26%09/09/21 – 4,069,844 – 4,069,844 – 4,069,844 4,069,844
Prosperity Bank CD 0.30%10/14/21 – 2,501,250 – 2,501,250 – 2,501,250 2,501,250
Independent Bank CD 0.40%10/18/21 – 2,546,598 – 2,546,598 – 2,546,598 2,546,598
Prosperity Bank CD 0.30%11/22/21 – 3,000,738 – 3,000,738 – 3,000,738 3,000,738
East West Bank CD 0.21%12/30/21 – 3,000,035 – 3,000,035 – 3,000,035 3,000,035
Prosperity Bank CD 0.30%01/21/22 – 4,002,000 – 4,002,000 – 4,002,000 4,002,000
Prosperity Bank CD 0.35%04/21/22 – 2,501,459 – 2,501,459 – 2,501,459 2,501,459
City of Georgetown Valley View Consulting, L.L.C.25
City - Allocation
Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
JPMorgan Chase Cash 15,461,481$ 15,461,481$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,016 434,016 – – – – –
Veritex Bank MMA 3,212,254 3,212,254 – – – – –
NexBank MMA 7,364,008 7,364,008 – – – – –
Origin Bank MMA 1,014,148 – – – – – –
TexPool 44,199,066 44,199,066 – – – – –
TexSTAR 64,620,967 8,950,006 584,231 3,875,899 137,294 93,001 2,508,604
East West Bank CD 01/08/21 3,050,882 3,050,882 – – – – –
Independent Bank CD 02/05/21 3,139,621 3,139,621 – – – – –
Independent Bank CD 02/08/21 11,033,296 8,024,216 – – – – –
East West Bank CD 02/18/21 9,010,737 3,003,579 – – – – –
R Bank CD 02/19/21 4,054,719 4,054,719 – – – – –
Bank OZK CD 02/26/21 6,086,273 6,086,273 – – – – –
Southside Bank CD 03/11/21 5,002,618 5,002,618 – – – – –
Bank OZK CD 03/11/21 1,500,935 1,500,935 – – – – –
East West Bank CD 03/15/21 3,503,032 3,503,032 – – – – –
Prosperity Bank CD 04/01/21 4,006,098 4,006,098 – – – – –
Independent Bank CD 04/22/21 4,174,339 4,174,339 – – – – –
Bank OZK CD 05/10/21 12,049,407 10,041,172 – – – – –
Southside Bank CD 06/11/21 5,002,742 5,002,742 – – – – –
Bank OZK CD 06/11/21 5,003,741 5,003,741 – – – – –
Prosperity Bank CD 07/01/21 4,006,033 4,006,033 – – – – –
Prosperity Bank CD 07/15/21 5,008,798 5,008,798 – – – – –
East West Bank CD 08/18/21 2,002,386 – – – – – –
Prosperity Bank CD 08/23/21 6,251,322 6,251,322 – – – – –
East West Bank CD 09/09/21 4,069,844 4,069,844 – – – – –
Prosperity Bank CD 10/14/21 2,501,250 2,501,250 – – – – –
Independent Bank CD 10/18/21 2,546,598 2,546,598 – – – – –
Prosperity Bank CD 11/22/21 3,000,738 3,000,738 – – – – –
East West Bank CD 12/30/21 3,000,035 3,000,035 – – – – –
Prosperity Bank CD 01/21/22 4,002,000 4,002,000 – – – – –
Prosperity Bank CD 04/21/22 2,501,459 2,501,459 – – – – –
Prosperity Bank CD 05/17/22 2,000,574 2,000,574 – – – – –
Prosperity Bank CD 08/22/22 2,500,717 2,500,717 – – – – –
Prosperity Bank CD 11/17/22 2,000,656 2,000,656 – – – – –
Totals 258,316,790$ 188,604,822$ 584,231$ 3,875,899$ 137,294$ 93,001$ 2,508,604$
Book Value
December 31, 2020
City of Georgetown Valley View Consulting, L.L.C.27
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
East West Bank CD 09/09/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
East West Bank CD 12/30/21
Prosperity Bank CD 01/21/22
Prosperity Bank CD 04/21/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
Book Value
December 31, 2020
(Continued)
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 GO-
Sidewalks
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698 68,600 1,429,101 1,456,708 254,936 178,433 –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698$ 68,600$ 1,429,101$ 1,456,708$ 254,936$ 178,433$ –$
City of Georgetown Valley View Consulting, L.L.C.28
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
East West Bank CD 09/09/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
East West Bank CD 12/30/21
Prosperity Bank CD 01/21/22
Prosperity Bank CD 04/21/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
Book Value
December 31, 2020
(Continued)
2017 Revenue
Electric
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– 1,014,148 – – – – -
– – – – – – –
97,374 3,241,881 56,694 672,254 482,661 9,137,064 3,936,963
– – – – – – –
– – – – – – –
– 3,009,081 – – – – –
– 3,003,579 – – – – 3,003,579
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– 2,008,234 – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
97,374$ 12,276,924$ 56,694$ 672,254$ 482,661$ 9,137,064$ 6,940,543$
City of Georgetown Valley View Consulting, L.L.C.29
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
East West Bank CD 09/09/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
East West Bank CD 12/30/21
Prosperity Bank CD 01/21/22
Prosperity Bank CD 04/21/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
Book Value
December 31, 2020
(Continued)
2019 CO-
Stormwater
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
113,952 1,961,455 2,602,887 650,566 8,708,689 1,241,086 7,169,062 3,479,865
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– 2,002,386 – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
113,952$ 3,963,841$ 2,602,887$ 650,566$ 8,708,689$ 1,241,086$ 7,169,062$ 3,479,865$
City of Georgetown Valley View Consulting, L.L.C.30
City - Allocation
December 31, 2020
Market Value Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
JPMorgan Chase Cash 15,461,481$ 15,461,481$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,016 434,016 – – – – –
Veritex Bank MMA 3,212,254 3,212,254 – – – – –
NexBank MMA 7,364,008 7,364,008 – – – – –
Origin Bank MMA 1,014,148 - – – – – –
TexPool 44,199,066 44,199,066 – – – – –
TexSTAR 64,620,967 8,950,006 584,231 3,875,899 137,294 93,001 2,508,604
East West Bank CD 01/08/21 3,050,882 3,050,882 – – – – –
Independent Bank CD 02/05/21 3,139,621 3,139,621 – – – – –
Independent Bank CD 02/08/21 11,033,296 8,024,216 – – – – –
East West Bank CD 02/18/21 9,010,737 3,003,579 – – – – –
R Bank CD 02/19/21 4,054,719 4,054,719 – – – – –
Bank OZK CD 02/26/21 6,086,273 6,086,273 – – – – –
Southside Bank CD 03/11/21 5,002,618 5,002,618 – – – – –
Bank OZK CD 03/11/21 1,500,935 1,500,935 – – – – –
East West Bank CD 03/15/21 3,503,032 3,503,032 – – – – –
Prosperity Bank CD 04/01/21 4,006,098 4,006,098 – – – – –
Independent Bank CD 04/22/21 4,174,339 4,174,339 – – – – –
Bank OZK CD 05/10/21 12,049,407 10,041,172 – – – – –
Southside Bank CD 06/11/21 5,002,742 5,002,742 – – – – –
Bank OZK CD 06/11/21 5,003,741 5,003,741 – – – – –
Prosperity Bank CD 07/01/21 4,006,033 4,006,033 – – – – –
Prosperity Bank CD 07/15/21 5,008,798 5,008,798 – – – – –
East West Bank CD 08/18/21 2,002,386 – – – – – –
Prosperity Bank CD 08/23/21 6,251,322 6,251,322 – – – – –
East West Bank CD 09/09/21 4,069,844 4,069,844 – – – – –
Prosperity Bank CD 10/14/21 2,501,250 2,501,250 – – – – –
Independent Bank CD 10/18/21 2,546,598 2,546,598 – – – – –
Prosperity Bank CD 11/22/21 3,000,738 3,000,738 – – – – –
East West Bank CD 12/30/21 3,000,035 3,000,035 – – – – –
Prosperity Bank CD 01/21/22 4,002,000 4,002,000 – – – – –
Prosperity Bank CD 04/21/22 2,501,459 2,501,459 – – – – –
Prosperity Bank CD 05/17/22 2,000,574 2,000,574 – – – – –
Prosperity Bank CD 08/22/22 2,500,717 2,500,717 – – – – –
Prosperity Bank CD 11/17/22 2,000,656 2,000,656 – – – – –
Totals 258,316,790$ 188,604,822$ 584,231$ 3,875,899$ 137,294$ 93,001$ 2,508,604$
City of Georgetown Valley View Consulting, L.L.C.31
City - Allocation
December 31, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
East West Bank CD 09/09/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
East West Bank CD 12/30/21
Prosperity Bank CD 01/21/22
Prosperity Bank CD 04/21/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 GO-
Sidewalks
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698 68,600 1,429,101 1,456,708 254,936 178,433 –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698$ 68,600$ 1,429,101$ 1,456,708$ 254,936$ 178,433$ –$
City of Georgetown Valley View Consulting, L.L.C.32
City - Allocation
December 31, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
East West Bank CD 09/09/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
East West Bank CD 12/30/21
Prosperity Bank CD 01/21/22
Prosperity Bank CD 04/21/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2017 Revenue
Electric
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– 1,014,148 – – – – –
– – – – – – –
97,374 3,241,881 56,694 672,254 482,661 9,137,064 3,936,963
– – – – – – –
– – – – – – –
– 3,009,081 – – – – –
– 3,003,579 – – – – 3,003,579
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– 2,008,234 – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
97,374$ 12,276,924$ 56,694$ 672,254$ 482,661$ 9,137,064$ 6,940,543$
City of Georgetown Valley View Consulting, L.L.C.33
City - Allocation
December 31, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
East West Bank CD 09/09/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
East West Bank CD 12/30/21
Prosperity Bank CD 01/21/22
Prosperity Bank CD 04/21/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2019 CO-
Stormwater
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$ –$ –$ –$ –$ –$ –$
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
113,952 1,961,455 2,602,887 650,566 8,708,689 1,241,086 7,169,062 3,479,865
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– 2,002,386 – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
– – – – – – – –
113,952$ 3,963,841$ 2,602,887$ 650,566$ 8,708,689$ 1,241,086$ 7,169,062$ 3,479,865$
City of Georgetown Valley View Consulting, L.L.C.34
City - Allocation
Investment
Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
JPMorgan Chase Cash 9,505,298$ 9,505,298$ –$ –$ –$ –$
JPMorgan Chase MMA 433,983 433,983 – – – –
Veritex Bank MMA 3,210,906 3,210,906 – – – –
NexBank MMA 7,355,685 7,355,685 – – – –
Origin Bank MMA 4,087,417 1,025,806 – – – –
TexPool 28,793,102 28,793,102 – – – –
TexSTAR 74,272,794 9,714,325 584,095 2,180,032 137,262 111,001
T-Bill 10/08/20 2,499,139 2,499,139 – – – –
Independent Bank CD 10/18/20 2,534,811 2,534,811 – – – –
East West Bank CD 11/09/20 3,006,607 3,006,607 – – – –
Independent Bank CD 11/10/20 1,032,494 1,032,494 – – – –
R Bank CD 11/19/20 2,521,930 2,521,930 – – – –
Southside Bank CD 11/19/20 3,258,686 3,258,686 – – – –
East West Bank CD 12/09/20 4,056,045 4,056,045 – – – –
East West Bank CD 01/08/21 3,037,761 3,037,761 – – – –
Independent Bank CD 02/05/21 3,126,261 3,126,261 – – – –
Independent Bank CD 02/08/21 11,016,636 8,012,099 – – – –
East West Bank CD 02/18/21 9,003,472 3,001,157 – – – –
R Bank CD 02/19/21 4,036,263 4,036,263 – – – –
Bank OZK CD 02/26/21 6,060,233 6,060,233 – – – –
Southside Bank CD 03/11/21 5,000,000 5,000,000 – – – –
Bank OZK CD 03/11/21 1,500,000 1,500,000 – – – –
East West Bank CD 03/15/21 3,500,473 3,500,473 – – – –
Prosperity Bank CD 04/01/21 4,004,525 4,004,525 – – – –
Independent Bank CD 04/22/21 4,155,537 4,155,537 – – – –
Bank OZK CD 05/10/21 12,028,372 10,023,644 – – – –
Southside Bank CD 06/11/21 5,000,000 5,000,000 – – – –
Bank OZK CD 06/11/21 5,000,000 5,000,000 – – – –
Prosperity Bank CD 07/01/21 4,006,033 4,006,033 – – – –
Prosperity Bank CD 07/15/21 5,007,459 5,007,459 – – – –
East West Bank CD 08/18/21 2,000,772 – – – – –
Prosperity Bank CD 08/23/21 6,245,860 6,245,860 – – – –
Totals 240,298,554$ 159,666,122$ 584,095$ 2,180,032$ 137,262$ 111,001$
September 30, 2020
Book Value
City of Georgetown Valley View Consulting, L.L.C.35
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
T-Bill 10/08/20
Independent Bank CD 10/18/20
East West Bank CD 11/09/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
Totals
September 30, 2020
Book Value
(Continued)
2015 GO-
Roads
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,508,021 1,531,341 68,584 1,451,130 1,503,917 318,392 178,392
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,508,021$ 1,531,341$ 68,584$ 1,451,130$ 1,503,917$ 318,392$ 178,392$
City of Georgetown Valley View Consulting, L.L.C.36
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
T-Bill 10/08/20
Independent Bank CD 10/18/20
East West Bank CD 11/09/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
Totals
September 30, 2020
Book Value
(Continued)
2017 GO-
Sidewalks
2017 Revenue
Electric
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – 1,009,942 – – – –
– – – – – – –
– 97,352 3,839,337 56,681 672,097 497,544 11,241,692
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – 3,004,537 – – – –
– – 3,001,157 – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – 2,004,729 – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
–$ 97,352$ 12,859,703$ 56,681$ 672,097$ 497,544$ 11,241,692$
City of Georgetown Valley View Consulting, L.L.C.37
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
T-Bill 10/08/20
Independent Bank CD 10/18/20
East West Bank CD 11/09/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
Totals
September 30, 2020
Book Value
(Continued)
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
2,051,669 – – – – – –
– – – – – – –
2,645,268 113,926 2,003,965 2,603,558 650,415 8,955,332 3,501,541
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,001,157 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – 2,000,772 – – – –
– – – – – – –
7,698,094$ 113,926$ 4,004,737$ 2,603,558$ 650,415$ 8,955,332$ 3,501,541$
City of Georgetown Valley View Consulting, L.L.C.38
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
T-Bill 10/08/20
Independent Bank CD 10/18/20
East West Bank CD 11/09/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
Totals
September 30, 2020
Book Value
(Continued)
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$
– –
– –
– –
– –
– –
7,447,141 9,660,452
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
7,447,141$ 9,660,452$
City of Georgetown Valley View Consulting, L.L.C.39
City - Allocation
September 30, 2020
Market Value Investment
Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
JPMorgan Chase Cash 9,505,298$ 9,505,298$ –$ –$ –$ –$
JPMorgan Chase MMA 433,983 433,983 – – – –
Veritex Bank MMA 3,210,906 3,210,906 – – – –
NexBank MMA 7,355,685 7,355,685 – – – –
Origin Bank MMA 4,087,417 1,025,806 – – – –
TexPool 28,793,102 28,793,102 – – – –
TexSTAR 74,272,794 9,714,325 584,095 2,180,032 137,262 111,001
T-Bill 10/08/20 2,499,970 2,499,970 – – – –
Independent Bank CD 10/18/20 2,534,811 2,534,811 – – – –
East West Bank CD 11/09/20 3,006,607 3,006,607 – – – –
Independent Bank CD 11/10/20 1,032,494 1,032,494 – – – –
R Bank CD 11/19/20 2,521,930 2,521,930 – – – –
Southside Bank CD 11/19/20 3,258,686 3,258,686 – – – –
East West Bank CD 12/09/20 4,056,045 4,056,045 – – – –
East West Bank CD 01/08/21 3,037,761 3,037,761 – – – –
Independent Bank CD 02/05/21 3,126,261 3,126,261 – – – –
Independent Bank CD 02/08/21 11,016,636 8,012,099 – – – –
East West Bank CD 02/18/21 9,003,472 3,001,157 – – – –
R Bank CD 02/19/21 4,036,263 4,036,263 – – – –
Bank OZK CD 02/26/21 6,060,233 6,060,233 – – – –
Southside Bank CD 03/11/21 5,000,000 5,000,000 – – – –
Bank OZK CD 03/11/21 1,500,000 1,500,000 – – – –
East West Bank CD 03/15/21 3,500,473 3,500,473 – – – –
Prosperity Bank CD 04/01/21 4,004,525 4,004,525 – – – –
Independent Bank CD 04/22/21 4,155,537 4,155,537 – – – –
Bank OZK CD 05/10/21 12,028,372 10,023,644 – – – –
Southside Bank CD 06/11/21 5,000,000 5,000,000 – – – –
Bank OZK CD 06/11/21 5,000,000 5,000,000 – – – –
Prosperity Bank CD 07/01/21 4,006,033 4,006,033 – – – –
Prosperity Bank CD 07/15/21 5,007,459 5,007,459 – – – –
East West Bank CD 08/18/21 2,000,772 – – – – –
Prosperity Bank CD 08/23/21 6,245,860 6,245,860 – – – –
Totals 240,299,385$ 159,666,953$ 584,095$ 2,180,032$ 137,262$ 111,001$
City of Georgetown Valley View Consulting, L.L.C.40
City - Allocation
September 30, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
T-Bill 10/08/20
Independent Bank CD 10/18/20
East West Bank CD 11/09/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
Totals
(Continued)
2015 GO-
Roads
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,508,021 1,531,341 68,584 1,451,130 1,503,917 318,392 178,392
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,508,021$ 1,531,341$ 68,584$ 1,451,130$ 1,503,917$ 318,392$ 178,392$
City of Georgetown Valley View Consulting, L.L.C.41
City - Allocation
September 30, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
T-Bill 10/08/20
Independent Bank CD 10/18/20
East West Bank CD 11/09/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
Totals
(Continued)
2017 GO-
Sidewalks
2017 Revenue
Electric
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – 1,009,942 – – – –
– – – – – – –
– 97,352 3,839,337 56,681 672,097 497,544 11,241,692
– – – – – – –
– – – – – – –
– – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – 3,004,537 – – – –
– – 3,001,157 – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – 2,004,729 – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
–$ 97,352$ 12,859,703$ 56,681$ 672,097$ 497,544$ 11,241,692$
City of Georgetown Valley View Consulting, L.L.C.42
City - Allocation
September 30, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
T-Bill 10/08/20
Independent Bank CD 10/18/20
East West Bank CD 11/09/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
Totals
(Continued)
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
2,051,669 – – – – – –
– – – – – – –
2,645,268 113,926 2,003,965 2,603,558 650,415 8,955,332 3,501,541
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,001,157 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – 2,000,772 – – – –
– – – – – – –
7,698,094$ 113,926$ 4,004,737$ 2,603,558$ 650,415$ 8,955,332$ 3,501,541$
City of Georgetown Valley View Consulting, L.L.C.43
City - Allocation
September 30, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
T-Bill 10/08/20
Independent Bank CD 10/18/20
East West Bank CD 11/09/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
Independent Bank CD 02/08/21
East West Bank CD 02/18/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Southside Bank CD 03/11/21
Bank OZK CD 03/11/21
East West Bank CD 03/15/21
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
East West Bank CD 08/18/21
Prosperity Bank CD 08/23/21
Totals
(Continued)
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$
– –
– –
– –
– –
– –
7,447,141 9,660,452
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
– –
7,447,141$ 9,660,452$
City of Georgetown Valley View Consulting, L.L.C.44
Georgetown Economic Development Corporation (GEDCO)
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
December 31, 2020
Prepared by
Valley View Consulting, L.L.C.
The investment portfolio of the Georgetown Economic Development Corporation (GEDCO) is in compliance with
the Texas Public Funds Investment Act and the Investment Policy and Strategies.
Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or
completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C. from
sources believed to be accurate and represent proprietary valuation. Due to market fluctuations these levels are not necessarily reflective of
current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total return
yields and do not account for investment advisor fees.
45
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
MMA 2,129,054$ 2,129,054$ 2,129,948$ 2,129,948$ 0.14%
Pools 5,746,114 5,746,114 6,006,030 6,006,030 0.08%
Certificates of Deposit 2,016,943 2,016,943 2,025,562 2,025,562 1.70%
9,892,111$ 9,892,111$ 10,161,540$ 10,161,540$ 0.41%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.41%Total Portfolio 0.41%
Rolling Three Month Treasury 0.09%Rolling Three Month Treasury 0.09%
Rolling Six Month Treasury 0.12%Rolling Six Month Treasury 0.12%
TexPool 0.09%TexPool 0.09%
Interest income provided in separate report.
September 30, 2020
(1) Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not
considered. The yield for the reporting month is used for bank, pool, and money market balances.
(2) Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total return
analysis or account for advisory fees.
December 31, 2020
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.46
Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
Veritex Bank MMA 0.14%01/01/21 12/31/20 2,129,948$ 2,129,948$ 1.00 2,129,948$ 1 0.14%
TexasDAILY AAAm 0.09%01/01/21 12/31/20 2,125,306 2,125,306 1.00 2,125,306 1 0.09%
TexSTAR AAAm 0.07%01/01/21 12/31/20 3,880,724 3,880,724 1.00 3,880,724 1 0.07%
Independent Bank 1.70%02/05/21 02/05/20 2,025,562 2,025,562 100.00 2,025,562 36 1.70%
10,161,540$ 10,161,540$ 10,161,540$ 8 0.41%
(1)(2)
December 31, 2020
(1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity.
(2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees
are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds.
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.48
Georgetown Transportation Enhancement Corporation (GTEC)
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
December 31, 2020
Prepared byValley View Consulting, L.L.C.
The investment portfolio of the Georgetown Transportation Enhancement Corporation (GTEC) is in compliance
with the Texas Public Funds Investment Act and the Investment Policy and Strategies.
Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or
completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from
sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective
of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total
return yields and do not account for investment advisor fees.
51
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Pools/MMAs 26,283,802$ 26,283,802$ 28,689,653$ 28,689,653$ 0.09%
CDs/Securities 3,001,377 3,001,377 3,004,002 3,004,002 0.40%Totals 29,285,179$ 29,285,179$ 31,693,655$ 31,693,655$ 0.12%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.12%Total Portfolio 0.12%
Rolling Three Month Treasury 0.09%Rolling Three Month Treasury 0.09%
Rolling Six Month Treasury 0.12%Rolling Six Month Treasury 0.12%
TexPool 0.09%TexPool 0.09%
Interest data provided in separate report.
September 30, 2020
(1) Quarter End Average Yield - based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not
considered. The yield for the reporting month is used for bank, pool, and money market balances.
(2) Fiscal Year-to-Date Average Yield - calculated using quarter end report yields and adjusted book values and does not reflect a total
return analysis or account for advisory fees.
December 31, 2020
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.52
Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
TexPool AAAm 0.09%01/01/21 12/31/20 13,146,323$ 13,146,323$ 1.00 13,146,323$ 1 0.09%
TexSTAR AAAm 0.07%01/01/21 12/31/20 12,855,726 12,855,726 1.00 12,855,726 1 0.07%
Veritex Bank MMA 0.14%01/01/21 12/31/20 2,687,605 2,687,605 1.00 2,687,605 1 0.14%
Prosperity Bank CD 0.40%08/23/21 08/21/20 3,004,002 3,004,002 100.00 3,004,002 235 0.40%
TOTALS 31,693,655$ 31,693,655$ 31,693,655$ 23 0.12%
(1)(2)
December 31, 2020
(1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity.
(2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not
considered. The yield for the reporting month is used for bank accounts, pools, and money market funds.
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.54
Department Federal Grantor Pass-Through Agency Identifying Number COG Name/Purpose YTD Expenditures YTD Revenue Recognized
Airport N/A Texas Department of
Transportation-Aviation
M1914GEOR RAMP Grant - Routine Airport
Maintenance Program
1,119.55
Airport FEMA Texas Department of Transportation - Aviation Airport CARES Funding - -
Emergency Management FEMA Williamson County WILCO Forward - CARES
Funding for COVID-19
14,814.52 14,814.52
Fire Department of Health & Human Services CMS (Centers for Medicare & Medicaid Services)EMS CARES Round 1 - -
Fire US Department of Homeland Security Federal Emergency
Management Agency
EMW-2017-FH-00496 SAFER 279,088.21 209,316.16
Library National Endowment for the Arts National Endowment for the
Arts
COVID Relief Funding 9,014.11 -
Library Texas Commission on the Arts Touring Artist Fund Grant 4,200.00
Planning US Department of Housing & Urban Development Williamson County CDBG Home Repair 43,059.77 40,920.32
Police US. Department of Justice N/A TX2460200 Equitable Sharing Agreement 5,176.77 -
Police US. Department of Treasury N/A TX2460200 Equitable Sharing Agreement 20,346.75 -
Public Works Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ-0914-05-187 Highway Planning & Construction (Austin Ave
Bridge)
2,003.66 -
Public Works Dept. of Transportation /Federal Highway
Administration
Texas Department of
Transportation
CSJ-0914-05-200,201,202 Highway Planning &
Construction (Williams Dr
Corridor)
- -
CITY OF GEORGETOWN
Grant/Federal Funding Report
as of December 31, 2020
Active
57
Capital Improvement Projects Report Q1 2021
Projects Project Budget Encumbrances Total Spend
Remaining
Budget
% of Remaining
Budget
Active Project
Airport
PRJ000197 Hangar Mainenance 240,000 - - 240,000 100.00%
PRJ000198 Pavement Maintenance 60,000 - - 60,000 100.00%
PRJ000199 Wildlife Management 150,000 - - 150,000 100.00%
Airport Total 450,000 - - 450,000 100.00%
CDBG
PRJ000003 17th Street 193,000 - 175,137 17,863 9.26%
CDBG Total 193,000 - 175,137 17,863 9.26%
Electric
PRJ000022 Consultant Engineering 150,000 - 21,352 128,648 85.77%
PRJ000026 Db Wood_Sh29 Intersection 240,000 1,612 172,024 67,976 28.32%
PRJ000036 Electrical System Improvement 100,000 - 57 99,943 99.94%
PRJ000040 Fiber Optic 50,000 - 19,516 30,484 60.97%
PRJ000062 New Development Projects 4,984,180 94,970 4,418,411 565,769 11.35%
PRJ000073 Power Quality Improvements 50,000 - - 50,000 100.00%
PRJ000095 Shell Road Feeders 160,000 279 167,982 (7,982) -4.99%
PRJ000147 Sectionalization Improvements 100,000 - - 100,000 100.00%PRJ000175 I-35 Mobility Project TxDot 200,000 6,770 149,976 50,024 25.01%
PRJ000189 Ronald Reagan - Glasscock Feeder Extension along Hwy 195 -Phase I 560,000 - 1,383 558,617 99.75%
PRJ000192 Ronald Reagan - Glasscock Feeder extension along Hwy 195 - Phase II 591,250 9,000 10,423 580,828 98.24%
PRJ000195 Downtown Overhead Rehab 2,400,000 - - 2,400,000 100.00%
Electric Total 9,585,430 112,630 4,961,125 4,624,305 48.24%
Environmental Services
PRJ000116 Transfer Station 10,838,185 272,420 944,201 9,893,984 91.29%
Environmental Services Total 10,838,185 272,420 944,201 9,893,984 91.29%
Finance
PRJ000038 ERP Project 6,231,654 26,213 5,887,091 344,563 5.53%
Finance Total 6,231,654 26,213 5,887,091 344,563 5.53%
Fire
PRJ000134 SCBA Replacement 880,000 - - 880,000 100.00%
PRJ000135 Cardiac Monitors 483,517 - 483,517 - 0.00%
Fire Total 1,363,517 - 483,517 880,000 64.54%
Fleet
PRJ000124 Radio Replacement 363,278 - - 363,278 100.00%
Fleet Total 363,278 - - 363,278 100.00%
Management Services
PRJ000028 Downtown Parking Expansion 728,510 - 701,947 26,564 3.65%
PRJ000029 Downtown Parking Garage 411,815 297,205 411,815 - 0.00%
PRJ000033 Dtwn Landsping & Public Art 90,000 50,960 56,706 33,294 36.99%PRJ000037 EOC Siren System 15,525 15,525 15,525 - 0.00%
PRJ000042 Fire Station 6 5,861,202 33,993 5,339,145 522,056 8.91%
PRJ000043 Fire Station 7 8,510,469 57,625 6,469,602 2,040,867 23.98%
PRJ000067 Parking Improvements 68,510 - - 68,510 100.00%
PRJ000131 Fuel Station 1,100,000 - - 1,100,000 100.00%
PRJ000136 GMC Remodel Phase I 250,000 - - 250,000 100.00%
PRJ000178 Public Safety Operation and Training Center Phase II 4,500,000 - - 4,500,000 100.00%
PRJ000179 Recreation Center Teen/Senior Renovation 200,000 - - 200,000 100.00%
PRJ000180 Recreation Center Natatorium HVAC Replacement 700,000 586,721 622,163 77,837 11.12%
PRJ000184 Airport Maintenance Facility 700,000 - - 700,000 100.00%
PRJ000191 Georgetown City Center - Festival/Public Space 5,400,000 - - 5,400,000 100.00%
PRJ000223 City Center Signage 125,000 - - 125,000 100.00%
Management Services Total 28,661,031 1,042,029 13,616,903 15,044,128 52.49%
Parks
PRJ000048 Garey Park 15,344,472 - 15,100,250 244,222 1.59%
PRJ000050 Grace Heritage Plaza 139,100 - 45,900 93,200 67.00%
PRJ000089 San Gabriel Park Improvement 13,025,000 115,404 7,448,252 5,576,748 42.82%
PRJ000125 Parks Master Plan 200,000 - - 200,000 100.00%PRJ000126 Regional Trail Development 2,775,000 84,522 128,600 2,646,400 95.37%
PRJ000127 Neighborhood Park Development 1,250,000 - 237,541 1,012,459 81.00%
PRJ000129 Ada Transition Plan 900,405 - 275,982 624,423 69.35%
PRJ000130 Tennis Center Pool Demo 70,000 - 36,576 33,424 47.75%PRJ000190 Heritage Gardens 250,000 - 7,470 242,530 97.01%
PRJ000205 Katy Crossing Trail 700,000 17,780 517,961 182,039 26.01%
Parks Total 34,653,977 217,706 23,798,533 10,855,444 31.33%
Police
PRJ000133 Body Cameras 802,000 - 737,412 64,588 8.05%
Police Total 802,000 - 737,412 64,588 8.05%
Right of Way
PRJ000200 Access Rtw To Government Srv 220,000 - 220,000 - 0.00%
Right of Way Total 220,000 - 220,000 - 0.00%
Stormwater
PRJ000004 18th and Hutto Drainage 50,000 - 5,969 44,031 88.06%
PRJ000005 2nd and Rock Pond 625,000 - 447,151 177,849 28.46%
PRJ000104 Stormwater Infrastructure 347,000 109,558 168,506 178,495 51.44%
PRJ000148 Water Quality Ponds 98,000 - - 98,000 100.00%
PRJ000149 Drainage Improvement/Flood Mitigation Projects 300,000 - - 300,000 100.00%
PRJ000213 2021 Curb & Gutter Project 763,925 50,850 380,147 383,778 50.24%
58
Capital Improvement Projects Report Q1 2021
Projects Project Budget Encumbrances Total Spend
Remaining
Budget
% of Remaining
Budget
Stormwater Total 2,183,925 160,408 1,001,773 1,182,152 54.13%
Water
PRJ000014 Berry Creek Inter.49,949,000 19,031 126,902 49,822,098 99.75%
PRJ000016 Braun Est 4,750,000 - 1,202,760 3,547,240 74.68%
PRJ000017 Cedar Breaks Est 3,385,000 - - 3,385,000 100.00%
PRJ000023 Cr 255 (Wd14-2)1,493,963 - - 1,493,963 100.00%
PRJ000025 Db Wood/ Pastor 24 Dedicated 5,286,000 0 423,726 4,862,274 91.98%
PRJ000034 Earz 2,326,000 129,479 433,423 1,892,577 81.37%
PRJ000057 Lift Station Upgrade 1,100,000 - - 1,100,000 100.00%
PRJ000059 LWTP Raw Water Intake Rehab 18,750,000 1,833,498 4,250,998 14,499,002 77.33%
PRJ000066 Park Lift Station & Force Main 3,574,341 884,897 2,097,586 1,476,755 41.32%
PRJ000069 Pecan Branch Ph 2 253,000 - 232,521 20,479 8.09%
PRJ000075 Pumps & Storage 1,000,000 - 9,289 990,711 99.07%
PRJ000076 Rabbit Hill Est 1,826,000 - - 1,826,000 100.00%
PRJ000085 Ronald Reagan/Daniels Mountain 4,400,000 29,592 167,638 4,232,362 96.19%PRJ000088 San Gabriel Belt Press and Rehab 3,200,000 74,902 2,522,973 677,027 21.16%
PRJ000096 Shell Road Water Line 6,890,000 - 856,000 6,034,000 87.58%
PRJ000101 Southlake Wtp 100,000,000 5,286,539 7,201,000 92,799,000 92.80%
PRJ000119 Water Mains 1,637,000 19,872 386,765 1,250,235 76.37%PRJ000123 WW Interceptors 608,431 - - 608,431 100.00%
PRJ000150 Carriage Oaks Transmission 500,000 - - 500,000 100.00%
PRJ000151 FY2020 CR262 Waterline 500,000 - - 500,000 100.00%
PRJ000152 FY2020 Hoover Pump Station 855,221 761,343 855,221 - 0.00%
PRJ000154 FY2020 Stonewall Ranch Ps Improvements 500,000 - - 500,000 100.00%
PRJ000155 FY2020 Southside Water Treatment Plant 2,250,000 - - 2,250,000 100.00%
PRJ000156 FY2020 Gatlin/Teravista Improvements 450,000 - - 450,000 100.00%
PRJ000157 Leander Interconnect 450,000 10,564 49,495 400,505 89.00%
PRJ000158 West loop (H-1A)2,119,000 - 447,385 1,671,615 78.89%
PRJ000160 FY2020 Round Rock Supply Pump Station And Elevated Storage Tank 9,200,000 915,602 1,427,473 7,772,527 84.48%
PRJ000161 Miscellaneous Line Upgrades 872,000 247,173 636,126 235,874 27.05%
PRJ000162 South West Bypass Water (H24-1)2,906,000 23,998 1,314,809 1,591,191 54.76%
PRJ000163 Tank Rehabilitation 2,905,000 267,748 406,056 2,498,944 86.02%
PRJ000164 Council Chamber Water 423,000 - 15,960 407,040 96.23%
PRJ000165 San Gabriel Wwtp Rehab 2,500,000 12,325 98,000 2,402,000 96.08%
PRJ000167 San Gabriel Inter SGI -2 4,500,000 912,755 912,755 3,587,245 79.72%
PRJ000168 WWTP Upgrade 1,150,000 - - 1,150,000 100.00%
PRJ000177 Northlake WTP Phase IV Expansion 15,000,000 11,762,116 11,859,923 3,140,077 20.93%
PRJ000185 Cimarron Hills Wastewater Treatment Plant Expansion 600,000 - - 600,000 100.00%
PRJ000186 Water Oak 24" Waterline 3,500,000 - - 3,500,000 100.00%
PRJ000218 EARZ Wastewater Rehabilitation Area 2 - 2019 2,460,360 2,460,360 2,460,360 - 0.00%
PRJ000220 AMI Western District Improvements 750,000 - - 750,000 100.00%
Water Total 264,819,316 25,651,791 40,395,143 224,424,173 84.75%
GTEC
PRJ000046 FM 971/ Fontana (Nw Bridge)1,209,000 - 1,193,000 16,000 1.32%
PRJ000053 IH 35/ Hwy 29 Intersection Imp 1,800,000 - 120,066 1,679,934 93.33%PRJ000060 Rabbit Hill Road 4,100,000 - 88,429 4,011,571 97.84%
PRJ000083 Rivery Tia Improvements 1,179,000 16,131 1,110,970 68,030 5.77%
PRJ000145 Sh29 Signal And Roadway Improvements 1,595,000 105,366 312,671 1,282,329 80.40%
PRJ000181 Aviation Drive 10,300,000 - - 10,300,000 100.00%
PRJ000182 Confido III 600,000 - - 600,000 100.00%
PRJ000183 Big C Project 2,000,000 - - 2,000,000 100.00%
PRJ000203 FM1460 Widening 20,000 - - 20,000 100.00%
PRJ000206 NB Front Rd (2338 To Lakeway)216,000 - 221,766 (5,766) -2.67%
GTEC Total 23,019,000 121,497 3,046,902 19,972,098 86.76%
Public Works
PRJ000013 Austin Avenue Bridge 2,855,398 10,626 1,711,203 1,144,195 40.07%
PRJ000100 Southeast Inner Loop 3,321,000 - - 3,321,000 100.00%
PRJ000137 Intersection Improvements (Lakeway @ Williams Drive)1,400,000 76,200 252,450 1,147,550 81.97%
PRJ000138 Downtown Sidewalks 2,000,000 29,910 470,719 1,529,281 76.46%
PRJ000139 Westinghouse - Scenic Lake Traffic Signal 600,000 21,959 59,820 540,180 90.03%
PRJ000141 Southwestern Blvd 4,000,000 195,133 866,960 3,133,040 78.33%
PRJ000143 Leander Rd(Norwood-Swbypass)6,750,000 899,044 994,025 5,755,975 85.27%
PRJ000171 Shell Rd Sidewalk 229,825 - 203,755 26,070 11.34%
PRJ000172 2020 Street Maintenance High Performance Seal: Bid Package No.1 372,200 78,580 372,200 - 0.00%
PRJ000173 2020 Street Maintenance High Performance Seal: Bid Package No. 2 463,195 144,495 482,214 (19,020) -4.11%
PRJ000174 2020 street maintenance HIPR 1,935,589 249,466 1,441,013 494,576 25.55%
PRJ000188 DB Wood (SH 29 to Oak Ridge)4,000,000 - 120,492 3,879,508 96.99%PRJ000201 Austin Ave. (Sh29-Fm2243)466,000 - 466,000 - 0.00%
PRJ000202 FM 971 4,853,000 4,885 1,042,014 3,810,986 78.53%
PRJ000204 Historic District Street Signs 26,000 - - 26,000 100.00%
PRJ000207 Northwest Blvd Bridge 11,254,320 2,079,367 8,735,845 2,518,475 22.38%
PRJ000208 Old Town Northeast 1,050,000 18,656 924,407 125,593 11.96%
PRJ000209 Southeast Inner Loop 10,521,000 3,821,590 8,798,602 1,722,398 16.37%
PRJ000210 2021 HIPR Street Maintenance 2,300,000 72,430 274,700 2,025,300 88.06%
PRJ000211 2021 High Performance Pavement Seal Project #1 600,000 60,840 94,900 505,100 84.18%
PRJ000212 2021 High Performance Pavement Seal Project #2 600,000 57,820 90,700 509,300 84.88%
PRJ000214 Intersection Improvements (Traffic Signals)1,650,000 81,225 141,050 1,508,950 91.45%
PRJ000215 2021 Intersection Safety Enhancements (RRFB)150,000 52,300 96,450 53,550 35.70%
PRJ000216 FY21 Downtown Sidewalk Improvements 1,000,000 130,000 130,000 870,000 87.00%
PRJ000217 SW Bypass - Wolf Ranch Extension 1,000,000 734,411 756,776 243,224 24.32%
Public Works Total 63,397,527 8,818,937 28,526,297 34,871,229 55.00%
Active Project Total 446,781,839 36,423,631 123,794,034 322,987,804 72.29%
Grand Total 446,781,839 36,423,631 123,794,034 322,987,804 72.29%
59
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 9/30/20 Status Updates ‐ 12/31/20
Cemetery Special Revenue
Fund
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 reserve $75,000 annually for future costs
associated with maintaining the property. The General
Fund has made this transfer in since FY 2016.
The general fund transfer for FY2021 was reduced to $35,000. No Change
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/2019, the net pension liability is $28.8 million and is
81.41% funded. The 2020 total combined contribution rate is
12.26%. This increase is due to a change in the discount rate.
As of 9/30/2020, the net pension liability is $18.7
million and is 88.97% funded. This decrease in liability
is due to a change in the actuarial assumptions.
Other Post Employee Benefits
(OPEB)
While the City has no obligation to offer additional retiree
benefits, retirees are eligible to participate in the City’s
health insurance program. That ability represents a
subsidy that impacts health insurance costs to the City.
Retirees pay their monthly premiums to the self insurance
fund, which then processes their health insurance claims.
OPEB liability as of 9/30/2019 is $3.3 million. This is a combination
of sudden death benefits as well as post‐retirement healthcare.
OPEB liability as of 9/30/2020 is $2.7 million. This is a
combination of sudden death benefits as well as post‐
retirement healthcare.
Compensated 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/2019 are $7.5 million. This
increase is due to more time being earned than used in FY19. In
FY2020, the budgeted reserve was increased to $340,000.
Compensated absences as of 9/30/2020 are $8.2
million. More time was earned than used during
FY2020 as many plans were changed related to the
pandemic. The City did not extend any vacation cap
carry overs in general. As with any year, specific
requests for carryover are considered and approved
by the City Manager.
Electric Fund Rate
Stabilization Reserve
Intended to mitigate potential rate impacts due to
increased fuel costs or other external factors. The RSR is
maintained within the Electric Fund.
The sale of transformer and fiber assets were booked to the 4th
Quarter. Net Purchased Power also ended the year on budget.
FY2020 ending fund balance is projected to fully fund the 90 day
contingency of $4.1 million, and begin to restore the rate
stabilization reserve.
During the FY2021 CIP Roll Forward and Other
Operating Amendments approved by Council, the PCA
revenue was lowered by $5 million. Budgeted ending
fund balance covers $4M in 90 day contingency
reserve, $10.6M in non‐operating or rate stabilization
reserve, and $3.4M in restricted proceeds from the
transformer sale.
CITY OF GEORGETOWN
Long-term Commitments, Reservations, and Other Unfunded Liabilities
12/31/2020
60
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 9/30/20 Status Updates ‐ 12/31/20
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.
Staff will be working on three (3) CARES Act purchases: 1)
Emergency Generator, 2) Solar Powered Taxiway lights, and 3)
Cattleguards for the North and South Gates to mitigate wildlife
entering the airfield. These projects were unfunded, but will be
reimbursed through TxDOT from the CARES Act grant from the
FAA. We are also going to be looking at Land Lease buildings that
will be reverting back to Airport Ownership within the next 5
years. These reversions will impact the budget bottom line as we
will have to do some maintenance on the buildings. These charges
will be off‐set by the increased revenue from the increased Facility
Lease Rates.
CARES Act purchases will be changed to airport Utility
charges FY 20 & FY21, along with other maintenance
charges from FY21. We are still reviewing Land Lease
buildings that will be reverting back to Airport
Ownership within the next 5 years. These reversions
will impact the budget bottom line as we will have to
do some maintenance on the buildings. These charges
will be off‐set by the increased revenue from the
increased Facility Lease Rates.
Americans with Disabilities
Act (ADA) Compliance 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.
FY2021 budget and debt sale includes $150,000
for the ADA plan.
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.
In design is the Rock Sidewalk/FY20 Downtown ADA Sidewalk
Improvements. This project will construct new and rehab/replace
non‐ADA compliant sidewalks and pedestrian ramps. Project will
bid mid to late November with construction starting after the new
year.
In design is the Rock Sidewalk/FY20 Downtown ADA
Sidewalk Improvements. This project will construct
new and rehab/replace non‐ADA compliant sidewalks
and pedestrian ramps. Currently reviewing 95% plans.
Advertising and Bidding to start end of January 2021.
The Council is considering a mobility bond for May
2021 that would include additional debt capacity for
sidewalk projects.
Park Equipment Maintenance
& 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.
No Change
61
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 9/30/20 Status Updates ‐ 12/31/20
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.
FY2021 Budget will fund the radios deferred in FY2020.
Additionally, the Electric Fund plans to fund 10 radios that were
deferred for several years to reduce costs. The Electric Fund has
improved its financial position, and the equipment needs to be
replaced for employee safety.
The audit shows there are 301 radios that still need to
be replaced before September 2023. Non‐Public
Safety ‐ 39 portable radios; 72 mobile radios. Some of
those mobiles may be replaced with portables. Police ‐
71 portable radios; 82 mobile radios. 911 Comms ‐ 4
portable radios; 9 mobile radios. Fire ‐ 12 portable
radios; 12 mobile radios. The FY2021 budget and debt
sale includes $363K in funding.
Street 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.
Due to the COVID‐19 pandemic, the Street Maintenance budget in
the General Fund was reduced in FY2021. The Streets Special
Revenue Fund will pick up some of the expenses, but not all.
No change. After the FY2020 audit is completed and
all available General Fund balance reviewed, there
may be dollars available to allocate to street
maintenance or other priorities.
Fiber Asset 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.
Fiber staff will be moved into IT at beginning of FY 21. Also in FY
2021, Fiber costs will be allocated across departments according to
the IT allocation process. The second installment to acquire the
asset will be paid in FY2020, and there is a plan to assume
additional installments over the next 4 years. The IT Fund will need
to increase cost recovery rates to complete the acquisition.
No change.
IT Capital Replacement
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.
During the FY2021 budget adoption process, the IT capital
replacement reserve was drawn down in order to purchase a
portion of the fiber asset from the Electric utility. In FY2022, IT
Allocation revenues will need to increase citywide to recover the
fund balance and continue with the remaining fiber asset
purchase.
No change.
Facilities Maintenance
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.
During the FY2021 budget adoption process, the Facilities cost
allocation revenue was not increased. This provided some
economic relief throughout major funds due to COVID economic
uncertainty. Therefore, no incremental progress was made to fund
this reserve. In FY2022 or future years, rates will need to increase
to fund this reserve.
No change.
62
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 9/30/20 Status Updates ‐ 12/31/20
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.
No change.
Joint Services Fund 90 Day
Operational Contingency
Reserve
A minimum ninety (90) days of operating expenses will be
reserved for unexpected delays in revenue or emergency
expenses.
Due to the economic impact of the pandemic, the City is not
increasing recovery rates to build this reserve. It is estimated to
take approximately 3 years to build the reserve to 90 days. The
FY2021 budget provide funding to hire a consultant to review and
recommend updates to the City's joint services cost allocation
model.
No change.
63