HomeMy WebLinkAboutFY 21 - 2nd_Qtr_Report_FY2021_RedactedFINANCIAL REPORT AND INVESTMENT REPORT
For the Quarter Ended March 31, 2021
Table of Contents
Executive Summary .................................................................................................................................. 1-11
General Fund Schedule ............................................................................................................................... 12
Electric Fund Schedule ................................................................................................................................ 13
Water Services Fund Schedule .................................................................................................................... 14
Joint Services Fund Schedule ....................................................................................................................... 15
Council Discretionary Fund Schedule .......................................................................................................... 16
Convention & Visitors Bureau Fund Schedule ............................................................................................. 17
Airport Fund Schedule ................................................................................................................................. 18
Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 19
Georgetown Economic Development Corporation Fund Schedule ............................................................. 20
Quarterly Investment Report - City ........................................................................................................ 21-44
Quarterly Investment Report - GEDCO ................................................................................................... 45-50
Quarterly Investment Report - GTEC ...................................................................................................... 51-56
Grant Applications ....................................................................................................................................... 57
Capital Improvement Projects ................................................................................................................ 58-63
Long-term Commitments and Other Unfunded Liabilities ..................................................................... 64-67
COG ‐ General Fund Financial Report
Period: Mar‐21 Budget Period
FY2021 Mar‐21
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 315,215 16,427,813 451,308 102.82%
40002:Sales Taxes 18,576,250 1,585,830 7,431,798 (11,144,452) 40.01%
40005:Franchise Taxes 6,255,270 311,590 2,783,150 (3,472,120) 44.49%
40008:Other Taxes 400,000 17,858 87,386 (312,614) 21.85%
41001:Fines 328,392 29,515 107,775 (220,617) 32.82%
41002:Penalties 60,000 9,962 48,624 (11,376) 81.04%
42001:Interest Income 75,000 (273) 43,091 (31,909) 57.46%
43001:Fees 7,028,184 634,010 3,294,925 (3,733,259) 46.88%
43002:Garbage Charges 10,151,764 1,031,222 5,316,194 (4,835,570) 52.37%
43003:Permits 4,317,750 377,405 2,562,111 (1,755,639) 59.34%
43004:Administrative Charges 3,396,447 282,708 1,696,251 (1,700,196) 49.94%
43005:Rental Revenue 148,140 12,067 86,772 (61,368) 58.57%
44001:Grant Revenue 679,884 241,317 433,004 (246,880) 63.69%
44502:Developer Contributions ‐ 253,798 423,328 423,328 0.00%
44503:Interlocal Agreement Revenue 5,091,091 1,183,773 2,367,546 (2,723,546) 46.50%
45001:Misc Revenue 871,955 83,456 398,441 (473,514) 45.70%
70001:Transfers In 995,302 ‐ 995,302 ‐ 100.00%
70002:Transfers In ‐ ROI 8,431,375 782,613 4,354,647 (4,076,728) 51.65%
Revenue Total 82,783,309 7,152,065 48,858,157 (33,925,152) 59.02%
Expense
CC0001 Non‐Departmental 1,353,191 980 762,585 590,606 56.35%
CC0107 Planning 1,860,789 68,685 789,558 1,071,232 42.43%
CC0202 Parks Administration 662,224 38,834 305,057 357,168 46.07%
CC0210 Library 2,837,904 139,250 1,371,235 1,466,669 48.32%
CC0211 Parks 2,721,425 149,038 1,361,495 1,359,930 50.03%
CC0212 Recreation 2,897,351 152,822 1,333,703 1,563,648 46.03%
CC0213 Tennis Center 442,917 23,390 180,507 262,410 40.75%
CC0214 Recreation Programs 1,237,960 38,229 288,675 949,285 23.32%
CC0215 Garey Park 979,961 50,983 477,289 502,672 48.70%
CC0218 Arts and Culture 57,857 4,832 28,093 29,764 48.56%
CC0316 Municipal Court 585,123 29,002 264,871 320,253 45.27%
CC0402 Fire Support Services/Administration 4,254,731 209,053 1,815,670 2,439,060 42.67%
CC0422 Fire Emergency Services 15,932,476 658,855 7,230,849 8,701,626 45.38%
CC0448 EMS 2,579,106 130,215 1,417,575 1,161,530 54.96%
CC0533 Environmental Services 9,662,924 757,899 3,775,444 5,887,481 39.07%
CC0536 Inspection Services 1,519,534 62,115 633,417 886,118 41.68%
CC0602 Administrative Services 1,893,883 78,346 876,168 1,017,715 46.26%
CC0605 Community Services 353,889 13,420 201,966 151,922 57.07%
CC0634 City Council Services 185,734 23,593 99,423 86,311 53.53%
CC0635 City Secretary Services 1,000,047 83,695 473,228 526,818 47.32%
CC0638 General Government Contracts 4,774,808 353,655 2,729,217 2,045,591 57.16%
CC0655 Communications/Public Engagement 844,604 31,700 398,261 446,343 47.15%
CC0702 Police Administration 2,559,766 193,991 1,235,898 1,323,869 48.28%
CC0742 Police Operations 14,335,833 645,197 6,934,948 7,400,885 48.37%
CC0744 Animal Services 1,106,702 50,600 460,114 646,588 41.58%
CC0745 Code Compliance 562,584 25,977 229,168 333,416 40.73%
CC0802 Public Works 1,462,292 333,850 1,032,233 430,059 70.59%
CC0846 Streets 3,086,124 162,828 1,474,794 1,611,330 47.79%
Expense Total 81,751,737 4,511,034 38,181,440 43,570,297 46.70%
Excess (Deficiency) of Total Revenue over Total Requirements 1,031,571 2,641,031 10,676,717 11,708,288 1035.00%
Ending Fund Balance 16,580,494 26,225,640 9,645,145 158.17%
Reserves
Contingency 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%
Reserves Total 14,434,315 14,434,315 ‐ 100.00%
Available Fund Balance 2,146,179 11,791,325 9,645,145 549.41%
YTD Actuals Budget vs. Actuals
12
COG ‐ Electric Services Financial Report
Period: Mar‐21
Budget Period
FY2021 Mar‐21
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 19,702,705 ‐ 19,702,705 ‐ 100.00%
Operating Revenue
40002:Sales Taxes 5,000 387 2,389 (2,611) 47.77%
40005:Franchise Taxes 115,732 ‐ ‐ (115,732) 0.00%
41002:Penalties 553,724 87,911 415,395 (138,329) 75.02%
42001:Interest Income 5,000 95 20,765 15,765 415.30%
43001:Fees 685,000 65,060 525,563 (159,437) 76.72%
43004:Administrative Charges 3,222,103 268,509 1,611,051 (1,611,052) 50.00%
43601:Electric Sales Revenue 78,982,278 6,277,631 36,867,522 (42,114,756) 46.68%
44502:Developer Contributions 1,500,000 896,117 3,266,695 1,766,695 217.78%
70001:RC0225 Transfer In ‐ GEDCO 1,000,000 ‐ 1,000,000 ‐ 100.00%
70001:RC0241 Transfer In ‐ South TIRZ 379,308 ‐ 379,308 ‐ 100.00%
Operating Revenue Total 86,448,145 7,595,710 44,088,688 (42,359,457) 51.00%
Opearating Expense
CC0001 Non‐Departmental 5,506,375 616,009 3,366,496 2,139,879 61.14%
CC0521 Electric Technical Services 711,765 32,596 322,812 388,953 45.35%
CC0522 Electric Administration 8,738,050 712,730 4,432,996 4,305,053 50.73%
CC0524 Metering Services 2,009,379 142,210 1,072,252 937,127 53.36%
CC0525 T&D Services 2,918,996 258,852 2,093,770 825,226 71.73%
CC0526 Systems Engineering ‐ ‐ 166,831 (166,831) 0.00%
CC0537 Electric Resource Management 60,334,393 8,207,405 86,341,401 (26,007,008) 143.10%
CC0555 Electric Systems Operations 1,578,902 60,823 779,240 799,663 49.35%
CC0557 Electrical Engineering 636,869 68,341 507,406 129,463 79.67%
Operating Expense Total 82,434,729 10,098,967 99,083,205 (16,648,476) 120.20%
Net Operations Total 4,013,416 (2,503,258) (54,994,517) (59,007,933) ‐1370.27%
Non‐Operating Revenue
45001:Misc Revenue 35,000 53,977 76,471 (41,471) 218.49%
45004:Sale of Property 10,000 736,303 892,773 (882,773) 8927.73%
46001:Bond Proceeds 6,648,625 ‐ ‐ 6,648,625 0.00%
Non‐Operating Revenue Total 6,693,625 790,280 969,245 (5,724,380) 14.48%
Non‐Operating Expenses
CC0001 Non‐Departmental 4,152,805 ‐ 614,762 3,538,043 14.80%
CC0557 Electrical Engineering 8,166,143 215,458 2,569,283 5,596,859 31.46%
Non‐Operating Expense Total 12,318,948 215,458 3,184,045 9,134,903 25.85%
Net Non‐Operations Total (5,625,323) 574,822 (2,214,800) 3,410,522 39.37%
Excess (Deficiency) of Total Revenue over Total Requirements (1,611,907) (1,928,436) (57,209,317) (58,821,224) 3549.17%
Ending Fund Balance 18,090,798 (1,928,436) (37,506,612) (55,597,410) ‐207.32%
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 (55,597,411) 55,597,411 0.00%
YTD Actuals Budget vs. Actuals
13
COG ‐ Water Services Financial Report
Period: Mar‐21
Budget Period
FY2021 Mar‐21
YTD Actuals
w/Encumbrances Variance % of Budget
Beginning Fund Balance 115,511,818 ‐ 115,511,818 ‐ 100.00%
Operating Revenue
41002:Penalties 255,000 46,303 242,368 (12,632) 95.05%
42001:Interest Income 237,250 1,712 250,606 (13,356) 105.63%
43001:Fees 4,290,000 915,470 4,747,148 (457,148) 110.66%
43005:Rental Revenue 55,000 3,650 55,594 (594) 101.08%
43602:Water Charges 32,150,000 3,102,651 16,574,767 15,575,233 51.55%
43603:Wastewater Charges 14,200,000 1,453,604 7,127,251 7,072,749 50.19%
43604:Irrigation Charges 300,000 11,121 136,188 163,812 45.40%
41602:Impact Fees 18,800,000 3,899,006 19,965,449 (1,165,449) 106.20%
44502:Developer Contributions 625,000 ‐ ‐ 625,000 0.00%
Operating Revenue Total 70,912,250 9,433,517 49,099,372 21,812,878 69.24%
Operating Expense
CC0001 Non‐Departmental 4,041,064 352,305 2,096,476 1,944,588 51.88%
CC0526 Systems Engineering ‐ 5,064 409,649 (409,649) 0.00%
CC0527 Water Services Administration 26,385,392 2,058,444 14,541,823 11,843,569 55.11%
CC0528 Water Distribution 2,717,500 563,004 1,813,594 903,906 66.74%
CC0529 Water Plant Management 4,261,242 239,904 2,083,147 2,178,095 48.89%
CC0530 Wastewater Operations 896,100 51,208 386,775 509,325 43.16%
CC0531 Wastewater Plant Management 3,956,455 338,064 2,060,124 1,896,331 52.07%
CC0532 Irrigation Operations 295,000 2,590 77,896 217,104 26.41%
CC0553 Water Operations 3,916,787 170,195 2,212,220 1,704,566 56.48%
Operating Expense Total 46,469,539 3,780,776 25,681,704 20,787,835 55.27%
Net Operations Total 24,442,711 5,652,740 23,417,668 (1,025,043) 95.81%
Non‐Operating Revenue
45001:Misc Revenue 1,112,500 8,759 43,583 (1,068,917) 3.92%
46001:Bond Proceeds 16,300,000 ‐ ‐ (16,300,000) 0.00%
Non‐Operating Revenue Total 17,412,500 8,759 43,583 (17,368,917) 0.25%
Non‐Operating Expenses
CC0001 Non‐Departmental 4,083,411 ‐ 534,920 3,548,491 13.10%
CC0524 Metering Services 750,000 ‐ ‐ 750,000 0.00%
CC0526 Systems Engineering 99,630,405 2,239,837 22,949,004 76,681,401 23.03%
CC0528 Water Distribution 1,159,424 ‐ 781,316 378,108 67.39%
CC0529 Water Plant Management 2,757 ‐ ‐ 2,757 0.00%
CC0530 Wastewater Operations 3,026,798 ‐ 533,080 2,493,718 17.61%
CC0531 Wastewater Plant Management 2,050,000 ‐ ‐ 2,050,000 0.00%
CC0532 Irrigation Operations 121,879 ‐ 9,606 112,273 7.88%
CC0553 Water Operations 13,962,363 950,148 12,748,682 1,213,681 91.31%
Non‐Operating Expenses Total 124,787,037 3,184,921 37,146,959 87,640,078 29.77%
Net Non‐Operations Total (107,374,537) (3,176,162) (37,103,376) 70,271,161 34.56%
Excess (Deficiency) of Total Revenue over Total Requirements (82,931,826) 2,476,579 (13,685,708) (96,617,534) 16.50%
Ending Fund Balance 32,579,992 2,476,579 101,826,110 69,246,118 312.54%
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 82,698,368 69,246,118 614.75%
YTD Actuals Budget vs. Actuals
14
CITY
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
March 31, 2021
Prepared by
Valley View Consulting, L.L.C.
The investment portfolio of the City of Georgetown is in compliance with the Public Funds Investment Act and
the Investment Policy and Strategies.
Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or
completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from
sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective
of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total
return yields and do not account for investment advisor fees.
21
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Demand Accounts 15,461,481$ 15,461,481 15,550,035$ 15,550,035$ 0.22%
NOW/MMA 12,024,426 12,024,426 11,019,484 11,019,484 0.33%
Pools 108,820,032 108,820,032 144,095,312 144,095,312 0.02%
CDs/Securities 122,010,850 122,010,850 105,720,421 105,720,421 0.45%Totals 258,316,790$ 258,316,790$ 276,385,252$ 276,385,252$ 0.21%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.21%Total Portfolio 0.29%
Rolling Three Month Treasury 0.06%Rolling Three Month Treasury 0.08%
Rolling Six Month Treasury 0.09%Rolling Six Month Treasury 0.10%
TexPool 0.02%TexPool 0.05%
Bank Fees Offset
10,568$
Interest earnings provided in separate report.18,679$
December 31, 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
March 31, 2021
City of Georgetown Valley View Consulting, L.L.C.23
City - Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
JPMorgan Chase Cash (3)0.22%04/01/21 03/31/21 15,550,035$ 15,550,035$ 1.00 15,550,035$ 1 0.22%
JPMorgan Chase MMA 0.03%04/01/21 03/31/21 434,048 434,048 1.00 434,048 1 0.03%
Veritex Bank MMA 0.10%04/01/21 03/31/21 3,213,253 3,213,253 1.00 3,213,253 1 0.10%
NexBank MMA 0.45%04/01/21 03/31/21 7,372,182 7,372,182 1.00 7,372,182 1 0.45%
TexPool AAAm 0.02%04/01/21 03/31/21 58,862,442 58,862,442 1.00 58,862,442 1 0.02%
TexSTAR AAAm 0.02%04/01/21 03/31/21 85,232,871 85,232,871 1.00 85,232,871 1 0.02%
Prosperity Bank CD 0.45%04/01/21 07/01/20 4,006,098 4,006,098 100.00 4,006,098 1 0.45%
Independent Bank CD 1.80%04/22/21 10/22/19 4,193,238 4,193,238 100.00 4,193,238 22 1.81%
Bank OZK CD 0.70%05/10/21 05/08/20 12,070,246 12,070,246 100.00 12,070,246 40 0.70%
Southside Bank CD 0.22%06/11/21 09/11/20 5,005,456 5,005,456 100.00 5,005,456 72 0.22%
Bank OZK CD 0.30%06/11/21 09/11/20 5,007,443 5,007,443 100.00 5,007,443 72 0.30%
Prosperity Bank CD 0.60%07/01/21 07/01/20 4,012,075 4,012,075 100.00 4,012,075 92 0.60%
Prosperity Bank CD 0.70%07/15/21 07/15/20 5,017,615 5,017,615 100.00 5,017,615 106 0.70%
Prosperity Bank CD 0.15%08/10/21 02/10/21 3,000,345 3,000,345 100.00 3,000,345 132 0.15%
Prosperity Bank CD 0.40%08/23/21 08/21/20 6,257,488 6,257,488 100.00 6,257,488 145 0.40%
R Bank CD 0.47%08/25/21 02/25/21 2,000,000 2,000,000 100.00 2,000,000 147 0.47%
East West Bank CD 0.26%09/09/21 12/09/20 4,072,454 4,072,454 100.00 4,072,454 162 0.26%
East West Bank CD 0.21%10/08/21 01/08/21 5,002,388 5,002,388 100.00 5,002,388 191 0.21%
Prosperity Bank CD 0.30%10/14/21 10/14/20 2,503,100 2,503,100 100.00 2,503,100 197 0.30%
Independent Bank CD 0.40%10/18/21 10/18/20 2,549,159 2,549,159 100.00 2,549,159 201 0.40%
Prosperity Bank CD 0.30%11/22/21 11/20/20 3,002,957 3,002,957 100.00 3,002,957 236 0.30%
Texas Regional Bank CD 0.25%12/07/21 03/12/21 3,000,000 3,000,000 100.00 3,000,000 251 0.25%
East West Bank CD 0.21%12/30/21 12/30/20 3,001,588 3,001,588 100.00 3,001,588 274 0.21%
East West Bank CD 0.21%01/07/22 01/08/21 5,002,388 5,002,388 100.00 5,002,388 282 0.21%
Prosperity Bank CD 0.30%01/21/22 10/21/20 4,004,960 4,004,960 100.00 4,004,960 296 0.30%
Independent Bank CD 0.40%02/05/22 02/05/21 3,000,000 3,000,000 100.00 3,000,000 311 0.40%
Independent Bank CD 0.40%02/08/22 02/08/21 5,000,000 5,000,000 100.00 5,000,000 314 0.40%
R Bank CD 0.63%02/25/22 02/25/21 2,000,000 2,000,000 100.00 2,000,000 331 0.63%
Prosperity Bank CD 0.35%04/21/22 10/21/20 2,503,617 2,503,617 100.00 2,503,617 386 0.35%
Independent Bank CD 0.35%05/09/22 02/08/21 4,000,000 4,000,000 100.00 4,000,000 404 0.35%
March 31, 2021
City of Georgetown Valley View Consulting, L.L.C.24
City - Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
March 31, 2021
Prosperity Bank CD 0.35%05/17/22 11/17/20 2,002,300 2,002,300 100.00 2,002,300 412 0.35%
Prosperity Bank CD 0.35%08/22/22 11/20/20 2,502,875 2,502,875 100.00 2,502,875 509 0.35%
Prosperity Bank CD 0.40%11/17/22 11/17/20 2,002,629 2,002,629 100.00 2,002,629 596 0.40%
TOTALS 276,385,252$ 276,385,252$ 276,385,252$ 74 0.21%
(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.25
City - Book & Market Value Comparison
Issuer/Description Yield Maturity
Date
Book Value
12/31/20 Increases Decreases Book Value
03/31/21
Market Value
12/31/20
Change in
Market Value
Market Value
03/31/21
JPMorgan Chase Cash 0.22%04/01/21 15,461,481$ 88,554$ –$ 15,550,035$ 15,461,481$ 88,554$ 15,550,035$
JPMorgan Chase MMA 0.03%04/01/21 434,016 32 – 434,048 434,016 32 434,048
Veritex Bank MMA 0.10%04/01/21 3,212,254 1,000 – 3,213,253 3,212,254 1,000 3,213,253
NexBank MMA 0.45%04/01/21 7,364,008 8,174 – 7,372,182 7,364,008 8,174 7,372,182
Origin Bank MMA 0.00%04/01/21 1,014,148 – (1,014,148) - 1,014,148 (1,014,148) -
TexPool 0.02%04/01/21 44,199,066 14,663,376 – 58,862,442 44,199,066 14,663,376 58,862,442
TexSTAR 0.02%04/01/21 64,620,967 20,611,904 – 85,232,871 64,620,967 20,611,904 85,232,871
East West Bank CD 1.72%01/08/21 3,050,882 – (3,050,882) – 3,050,882 (3,050,882) –
Independent Bank CD 1.71%02/05/21 3,139,621 – (3,139,621) – 3,139,621 (3,139,621) –
Independent Bank CD 0.60%02/08/21 11,033,296 – (11,033,296) – 11,033,296 (11,033,296) –
East West Bank CD 0.32%02/18/21 9,010,737 – (9,010,737) – 9,010,737 (9,010,737) –
East West Bank CD 0.32%02/18/21 2,002,386 – (2,002,386) – 2,002,386 (2,002,386) –
R Bank CD 1.83%02/19/21 4,054,719 – (4,054,719) – 4,054,719 (4,054,719) –
Bank OZK CD 1.73%02/26/21 6,086,273 – (6,086,273) – 6,086,273 (6,086,273) –
Southside Bank CD 0.21%03/11/21 5,002,618 – (5,002,618) – 5,002,618 (5,002,618) –
Bank OZK CD 0.25%03/11/21 1,500,935 – (1,500,935) – 1,500,935 (1,500,935) –
East West Bank CD 0.29%03/15/21 3,503,032 – (3,503,032) – 3,503,032 (3,503,032) –
Prosperity Bank CD 0.45%04/01/21 4,006,098 – –4,006,098 4,006,098 – 4,006,098
Independent Bank CD 1.81%04/22/21 4,174,339 18,899 – 4,193,238 4,174,339 18,899 4,193,238
Bank OZK CD 0.70%05/10/21 12,049,407 20,839 – 12,070,246 12,049,407 20,839 12,070,246
Southside Bank CD 0.22%06/11/21 5,002,742 2,714 – 5,005,456 5,002,742 2,714 5,005,456
Bank OZK CD 0.30%06/11/21 5,003,741 3,702 – 5,007,443 5,003,741 3,702 5,007,443
Prosperity Bank CD 0.60%07/01/21 4,006,033 6,042 – 4,012,075 4,006,033 6,042 4,012,075
Prosperity Bank CD 0.70%07/15/21 5,008,798 8,817 – 5,017,615 5,008,798 8,817 5,017,615
Prosperity Bank CD 0.15%08/10/21 – 3,000,345 – 3,000,345 – 3,000,345 3,000,345
Prosperity Bank CD 0.40%08/23/21 6,251,322 6,166 – 6,257,488 6,251,322 6,166 6,257,488
R Bank CD 0.47%08/25/21 – 2,000,000 – 2,000,000 – 2,000,000 2,000,000
East West Bank CD 0.26%09/09/21 4,069,844 2,610 – 4,072,454 4,069,844 2,610 4,072,454
East West Bank CD 0.21%10/08/21 – 5,002,388 – 5,002,388 – 5,002,388 5,002,388
Prosperity Bank CD 0.30%10/14/21 2,501,250 1,850 – 2,503,100 2,501,250 1,850 2,503,100
Independent Bank CD 0.40%10/18/21 2,546,598 2,561 – 2,549,159 2,546,598 2,561 2,549,159
Prosperity Bank CD 0.30%11/22/21 3,000,738 2,219 – 3,002,957 3,000,738 2,219 3,002,957
Texas Regional Bank CD 0.25%12/07/21 – 3,000,000 – 3,000,000 – 3,000,000 3,000,000
East West Bank CD 0.21%12/30/21 3,000,035 1,554 – 3,001,588 3,000,035 1,554 3,001,588
East West Bank CD 0.21%01/07/22 – 5,002,388 – 5,002,388 – 5,002,388 5,002,388
Prosperity Bank CD 0.30%01/21/22 4,002,000 2,960 – 4,004,960 4,002,000 2,960 4,004,960
Independent Bank CD 0.40%02/05/22 – 3,000,000 – 3,000,000 – 3,000,000 3,000,000
Independent Bank CD 0.40%02/08/22 – 5,000,000 – 5,000,000 – 5,000,000 5,000,000
R Bank CD 0.63%02/25/22 – 2,000,000 – 2,000,000 – 2,000,000 2,000,000
City of Georgetown Valley View Consulting, L.L.C.27
City - Allocation
Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
JPMorgan Chase Cash 15,550,035$ 15,550,035$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,048 434,048 – – – – –
Veritex Bank MMA 3,213,253 3,213,253 – – – – –
NexBank MMA 7,372,182 7,372,182 – – – – –
TexPool 58,862,442 58,862,442 – – – – –
TexSTAR 85,232,871 20,153,413 584,286 17,544,854 137,307 93,010 2,508,839
Prosperity Bank CD 04/01/21 4,006,098 4,006,098 – – – – –
Independent Bank CD 04/22/21 4,193,238 4,193,238 – – – – –
Bank OZK CD 05/10/21 12,070,246 10,058,538 – – – – –
Southside Bank CD 06/11/21 5,005,456 5,005,456 – – – – – Bank OZK CD 06/11/21 5,007,443 5,007,443 – – – – –
Prosperity Bank CD 07/01/21 4,012,075 4,012,075 – – – – –
Prosperity Bank CD 07/15/21 5,017,615 5,017,615 – – – – –
Prosperity Bank CD 08/10/21 3,000,345 – – – – – –
Prosperity Bank CD 08/23/21 6,257,488 6,257,488 – – – – – R Bank CD 08/25/21 2,000,000 – – – – – –
East West Bank CD 09/09/21 4,072,454 4,072,454 – – – – –
East West Bank CD 10/08/21 5,002,388 5,002,388 – – – – –
Prosperity Bank CD 10/14/21 2,503,100 2,503,100 – – – – –
Independent Bank CD 10/18/21 2,549,159 2,549,159 – – – – –
Prosperity Bank CD 11/22/21 3,002,957 3,002,957 – – – – –
Texas Regional Bank CD 12/07/21 3,000,000 – – – – – –
East West Bank CD 12/30/21 3,001,588 3,001,588 – – – – – East West Bank CD 01/07/22 5,002,388 5,002,388 – – – – –
Prosperity Bank CD 01/21/22 4,004,960 4,004,960 – – – – –
Independent Bank CD 02/05/22 3,000,000 3,000,000 – – – – –
Independent Bank CD 02/08/22 5,000,000 4,000,000 – – – – –
R Bank CD 02/25/22 2,000,000 – – – – – –
Prosperity Bank CD 04/21/22 2,503,617 2,503,617 – – – – –
Independent Bank CD 05/17/22 4,000,000 4,000,000 – – – – –
Prosperity Bank CD 05/17/22 2,002,300 2,002,300 – – – – – Prosperity Bank CD 08/22/22 2,502,875 2,502,875 – – – – –
Prosperity Bank CD 11/17/22 2,002,629 2,002,629 – – – – –
Totals 276,385,252$ 198,293,742$ 584,286$ 17,544,854$ 137,307$ 93,010$ 2,508,839$
Book Value
March 31, 2021
City of Georgetown Valley View Consulting, L.L.C.29
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
Book Value
March 31, 2021
(Continued)
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 Revenue
Electric
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,841 68,606 1,429,234 1,420,244 246,565 178,450 97,383
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,841$ 68,606$ 1,429,234$ 1,420,244$ 246,565$ 178,450$ 97,383$
City of Georgetown Valley View Consulting, L.L.C.30
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
Book Value
March 31, 2021
(Continued)
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,746,916 56,700 672,317 445,286 6,628,059 4,686,290 87,973
– – – – – – –
– – – – – – –
2,011,708 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,000,345 – – – – – –
– – – – – – –
– – – – – 2,000,000 –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
11,758,969$ 56,700$ 672,317$ 445,286$ 6,628,059$ 6,686,290$ 87,973$
City of Georgetown Valley View Consulting, L.L.C.31
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
Book Value
March 31, 2021
(Continued)
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,247,736 1,910,744 650,627 8,547,474 486,572 6,675,600 4,396,545
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,247,736$ 1,910,744$ 650,627$ 8,547,474$ 486,572$ 6,675,600$ 4,396,545$
City of Georgetown Valley View Consulting, L.L.C.32
City - Allocation
March 31, 2021
Market Value Investment Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 GO-
Roads
JPMorgan Chase Cash 15,550,035$ 15,550,035$ –$ –$ –$ –$ –$
JPMorgan Chase MMA 434,048 434,048 – – – – –
Veritex Bank MMA 3,213,253 3,213,253 – – – – –
NexBank MMA 7,372,182 7,372,182 – – – – –
TexPool 58,862,442 58,862,442 – – – – –
TexSTAR 85,232,871 20,153,413 584,286 17,544,854 137,307 93,010 2,508,839
Prosperity Bank CD 04/01/21 4,006,098 4,006,098 – – – – –
Independent Bank CD 04/22/21 4,193,238 4,193,238 – – – – –
Bank OZK CD 05/10/21 12,070,246 10,058,538 – – – – –
Southside Bank CD 06/11/21 5,005,456 5,005,456 – – – – –
Bank OZK CD 06/11/21 5,007,443 5,007,443 – – – – –
Prosperity Bank CD 07/01/21 4,012,075 4,012,075 – – – – –
Prosperity Bank CD 07/15/21 5,017,615 5,017,615 – – – – –
Prosperity Bank CD 08/10/21 3,000,345 – – – – – –
Prosperity Bank CD 08/23/21 6,257,488 6,257,488 – – – – –
R Bank CD 08/25/21 2,000,000 – – – – – –
East West Bank CD 09/09/21 4,072,454 4,072,454 – – – – –
East West Bank CD 10/08/21 5,002,388 5,002,388 – – – – –
Prosperity Bank CD 10/14/21 2,503,100 2,503,100 – – – – –
Independent Bank CD 10/18/21 2,549,159 2,549,159 – – – – –
Prosperity Bank CD 11/22/21 3,002,957 3,002,957 – – – – –
Texas Regional Bank CD 12/07/21 3,000,000 – – – – – –
East West Bank CD 12/30/21 3,001,588 3,001,588 – – – – –
East West Bank CD 01/07/22 5,002,388 5,002,388 – – – – –
Prosperity Bank CD 01/21/22 4,004,960 4,004,960 – – – – –
Independent Bank CD 02/05/22 3,000,000 3,000,000 – – – – –
Independent Bank CD 02/08/22 5,000,000 4,000,000 – – – – –
R Bank CD 02/25/22 2,000,000 – – – – – –
Prosperity Bank CD 04/21/22 2,503,617 2,503,617 – – – – –
Independent Bank CD 05/17/22 4,000,000 4,000,000 – – – – –
Prosperity Bank CD 05/17/22 2,002,300 2,002,300 – – – – –
Prosperity Bank CD 08/22/22 2,502,875 2,502,875 – – – – –
Prosperity Bank CD 11/17/22 2,002,629 2,002,629 – – – – –
Totals 276,385,252$ 198,293,742$ 584,286$ 17,544,854$ 137,307$ 93,010$ 2,508,839$
City of Georgetown Valley View Consulting, L.L.C.33
City - Allocation
March 31, 2021
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 Revenue
Electric
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,841 68,606 1,429,234 1,420,244 246,565 178,450 97,383
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,841$ 68,606$ 1,429,234$ 1,420,244$ 246,565$ 178,450$ 97,383$
City of Georgetown Valley View Consulting, L.L.C.34
City - Allocation
March 31, 2021
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,746,916 56,700 672,317 445,286 6,628,059 4,686,290 87,973
– – – – – – –
– – – – – – –
2,011,708 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,000,345 – – – – – –
– – – – – – –
– – – – – 2,000,000 –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
11,758,969$ 56,700$ 672,317$ 445,286$ 6,628,059$ 6,686,290$ 87,973$
City of Georgetown Valley View Consulting, L.L.C.35
City - Allocation
March 31, 2021
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
TexPool
TexSTAR
Prosperity Bank CD 04/01/21
Independent Bank CD 04/22/21
Bank OZK CD 05/10/21
Southside Bank CD 06/11/21
Bank OZK CD 06/11/21
Prosperity Bank CD 07/01/21
Prosperity Bank CD 07/15/21
Prosperity Bank CD 08/10/21
Prosperity Bank CD 08/23/21
R Bank CD 08/25/21
East West Bank CD 09/09/21
East West Bank CD 10/08/21
Prosperity Bank CD 10/14/21
Independent Bank CD 10/18/21
Prosperity Bank CD 11/22/21
Texas Regional Bank CD 12/07/21
East West Bank CD 12/30/21
East West Bank CD 01/07/22
Prosperity Bank CD 01/21/22
Independent Bank CD 02/05/22
Independent Bank CD 02/08/22
R Bank CD 02/25/22
Prosperity Bank CD 04/21/22
Independent Bank CD 05/17/22
Prosperity Bank CD 05/17/22
Prosperity Bank CD 08/22/22
Prosperity Bank CD 11/17/22
Totals
(Continued)
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,247,736 1,910,744 650,627 8,547,474 486,572 6,675,600 4,396,545
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,000,000 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
3,247,736$ 1,910,744$ 650,627$ 8,547,474$ 486,572$ 6,675,600$ 4,396,545$
City of Georgetown Valley View Consulting, L.L.C.36
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 – – – – –
East West Bank CD 02/18/21 2,002,386 – – – – – –
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 – – – – –
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$
December 31, 2020
Book Value
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
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
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
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
December 31, 2020
Book Value
(Continued)
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 Revenue
Electric
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698 68,600 1,429,101 1,456,708 254,936 178,433 97,374
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698$ 68,600$ 1,429,101$ 1,456,708$ 254,936$ 178,433$ 97,374$
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
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
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
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
December 31, 2020
Book Value
(Continued)
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
1,014,148 – – – – – –
– – – – – – –
3,241,881 56,694 672,254 482,661 9,137,064 3,936,963 113,952
– – – – – – –
– – – – – – –
3,009,081 – – – – – –
3,003,579 – – – – 3,003,579 –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,008,234 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
12,276,924$ 56,694$ 672,254$ 482,661$ 9,137,064$ 6,940,543$ 113,952$
City of Georgetown Valley View Consulting, L.L.C.39
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
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
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
December 31, 2020
Book Value
(Continued)
2019 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,961,455 2,602,887 650,566 8,708,689 1,241,086 7,169,062 3,479,865
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,002,386 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
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.40
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 – – – – –
East West Bank CD 02/18/21 2,002,386 – – – – – –
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 – – – – –
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.41
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
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
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 Revenue
Electric
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698 68,600 1,429,101 1,456,708 254,936 178,433 97,374
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,531,698$ 68,600$ 1,429,101$ 1,456,708$ 254,936$ 178,433$ 97,374$
City of Georgetown Valley View Consulting, L.L.C.42
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
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
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
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2019 CO-
Stormwater
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
1,014,148 – – – – – –
– – – – – – –
3,241,881 56,694 672,254 482,661 9,137,064 3,936,963 113,952
– – – – – – –
– – – – – – –
3,009,081 – – – – – –
3,003,579 – – – – 3,003,579 –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,008,234 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
12,276,924$ 56,694$ 672,254$ 482,661$ 9,137,064$ 6,940,543$ 113,952$
City of Georgetown Valley View Consulting, L.L.C.43
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
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
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 GO-
Roads
2020 CO-
Facilities/
Equip/Parks
2020 CO-
Stormwater
2020 GO-
Roads
2020
Revenue-
Electric
2020
Revenue-
Water/WW
Electric-LCRA
Transformers
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
1,961,455 2,602,887 650,566 8,708,689 1,241,086 7,169,062 3,479,865
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
2,002,386 – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – –
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.44
Georgetown Economic Development Corporation (GEDCO)
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
March 31, 2021
Prepared by
Valley View Consulting, L.L.C.
The investment portfolio of the Georgetown Economic Development Corporation (GEDCO) is in compliance with
the Texas Public Funds Investment Act and the Investment Policy and Strategies.
Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or
completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from
sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective of
current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total return
yields and do not account for investment advisor fees.
45
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
MMA 2,129,948$ 2,129,948$ 2,130,611$ 2,130,611$ 0.10%
Pools 6,006,030 6,006,030 6,964,887 6,964,887 0.03%
Certificates of Deposit 2,025,562 2,025,562 2,000,000 2,000,000 0.24%
10,161,540$ 10,161,540$ 11,095,498$ 11,095,498$ 0.08%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.08%Total Portfolio 0.25%
Rolling Three Month Treasury 0.06%Rolling Three Month Treasury 0.08%
Rolling Six Month Treasury 0.09%Rolling Six Month Treasury 0.10%
TexPool 0.02%TexPool 0.05%
Interest income provided in separate report.
December 31, 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.
March 31, 2021
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.10%04/01/21 03/31/21 2,130,611$ 2,130,611$ 1.00 2,130,611$ 1 0.10%
TexasDAILY AAAm 0.05%04/01/21 03/31/21 2,125,613 2,125,613 1.00 2,125,613 1 0.05%
TexSTAR AAAm 0.02%04/01/21 03/31/21 4,839,274 4,839,274 1.00 4,839,274 1 0.02%
Veritex Bank CD 0.24%08/05/22 02/08/21 2,000,000 2,000,000 100.00 2,000,000 492 0.24%
11,095,498$ 11,095,498$ 11,095,498$ 90 0.08%
(1)(2)
March 31, 2021
(1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity.
(2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees
are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds.
Georgetown Economic Development Corporation (GEDCO)Valley View Consulting, L.L.C.48
Georgetown Transportation Enhancement Corporation (GTEC)
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
March 31, 2021
Prepared byValley View Consulting, L.L.C.
The investment portfolio of the Georgetown Transportation Enhancement Corporation (GTEC) is in compliance
with the Texas Public Funds Investment Act and the Investment Policy and Strategies.
Disclaimer:These reports were compiled using information provided by the City.No procedures were performed to test the accuracy or
completeness of this information.The market values included in these reports were obtained by Valley View Consulting,L.L.C.from
sources believed to be accurate and represent proprietary valuation.Due to market fluctuations these levels are not necessarily reflective
of current liquidation values.Yield calculations are not determined using standard performance formulas,are not representative of total
return yields and do not account for investment advisor fees.
51
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Pools/MMAs 28,689,653$ 28,689,653$ 30,076,153$ 30,076,153$ 0.03%
CDs/Securities 3,004,002 3,004,002 3,006,965 3,006,965 0.40%Totals 31,693,655$ 31,693,655$ 33,083,118$ 33,083,118$ 0.06%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.06%Total Portfolio 0.09%
Rolling Three Month Treasury 0.06%Rolling Three Month Treasury 0.08%
Rolling Six Month Treasury 0.09%Rolling Six Month Treasury 0.10%
TexPool 0.02%TexPool 0.05%
Interest data provided in separate report.
December 31, 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.
March 31, 2021
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.02%04/01/21 03/31/21 15,639,313$ 15,639,313$ 1.00 15,639,313$ 1 0.02%
TexSTAR AAAm 0.02%04/01/21 03/31/21 11,748,398 11,748,398 1.00 11,748,398 1 0.02%
Veritex Bank MMA 0.10%04/01/21 03/31/21 2,688,441 2,688,441 1.00 2,688,441 1 0.10%
Prosperity Bank CD 0.40%08/23/21 08/21/20 3,006,965 3,006,965 100.00 3,006,965 145 0.40%
TOTALS 33,083,118$ 33,083,118$ 33,083,118$ 14 0.06%
(1)(2)
March 31, 2021
(1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity.
(2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not
considered. The yield for the reporting month is used for bank accounts, pools, and money market funds.
Georgetown Transportation Enhancement Corporation (GTEC)Valley View Consulting, L.L.C.54
Capital Improvement Projects Life to Tade Budget vs Spend
Row Labels Total Budget Total Spend Remaining Budget Percent Remaining
Airport
Airport - Self Managed
PRJ000197 Hangar Mainenance 240,000 - 240,000 100%
PRJ000198 Pavement Maintenance 60,000 - 60,000 100%
PRJ000199 Wildlife Management 150,000 - 150,000 100%
Airport - Self Managed Total 450,000 - 450,000 300%
Management Services
PRJ000184 Airport Maintenance Facility 750,000 - 750,000 100%
Management Services Total 750,000 - 750,000 100%
Airport Total 1,200,000 - 1,200,000 400%
CDBG
CDBG
PRJ000003 17th Street 193,000 175,137 17,863 9%
PRJ000144 Maple Street (Inactive)80,784 - 80,784 100%
CDBG Total 273,784 175,137 98,647 109%
CDBG Total 273,784 175,137 98,647 109%
Downtown TIRZ
Parks
PRJ000050 Grace Heritage Plaza 139,100 45,900 93,200 67%
Parks Total 139,100 45,900 93,200 67%
Downtown TIRZ Total 139,100 45,900 93,200 67%
Electric
Electric
PRJ000022 Consultant Engineering 271,352 71,352 200,000 74%
PRJ000026 Db Wood_Sh29 Intersection 240,000 172,024 67,976 28%
PRJ000036 Electrical System Improvement 100,000 57 99,943 100%
PRJ000040 Fiber Optic 50,000 19,516 30,484 61%
PRJ000062 New Development Projects 5,019,335 5,334,015 (314,680) -6%
PRJ000073 Power Quality Improvements 50,000 - 50,000 100%
PRJ000095 Shell Road Feeders 160,000 181,824 (21,824) -14%
PRJ000147 Sectionalization Improvements 100,000 - 100,000 100%
PRJ000175 I-35 Mobility Project TxDot 200,000 183,627 16,373 8%
PRJ000189 Ronald Reagan - Glasscock Feeder Extension along Hwy 195 -Phase I 560,000 39,310 520,690 93%
PRJ000192 Ronald Reagan - Glasscock Feeder extension along Hwy 195 - Phase II 591,250 133,847 457,403 77%
PRJ000195 Downtown Overhead Rehab 2,400,000 - 2,400,000 100%
PRJ000221 Titan-Aviation Dr to IH35 Infrastructure Addition 1,000,000 67,349 932,651 93%
PRJ000225 Chapel Hill, WS-11139 (GEO-45-C.3)437,577 345,842 91,735 21%
PRJ000226 Wolf Ranch West - Section 1AG & 1BG 479,052 33,405 445,647 93%
PRJ000227 Ascend Westinghouse Apartments 444,598 29,165 415,432 93%
PRJ000229 Sun City NH 76 WS-11188 (GEO-18.2-N.51)274,030 103,520 170,510 62%
PRJ000230 Sun City NH 78 296,400 111,101 185,299 63%
PRJ000231 Georgetown Titan Development 1 & 2 140,428 - 140,428 100%
PRJ000232 Texas Outdoor Power Building 1 91,414 - 91,414 100%
PRJ000234 Summit at Westinghouse Self-Storage 49,685 - 49,685 100%
58
Row Labels Total Budget Total Spend Remaining Budget Percent Remaining
PRJ000236 Medcore (Georgetown) Senior Living 226,972 20,134 206,837 91%
PRJ000238 The Oscar at Georgetown 366,351 - 366,351 100%
PRJ000239 Wolf Ranch West - Section 3 - Phase 2 418,339 - 418,339 100%
Electric Total 13,966,782 6,846,089 7,120,693 1738%
Electric Total 13,966,782 6,846,089 7,120,693 1738%
GCP
Environmental Services
PRJ000116 Transfer Station 11,000,000 947,801 10,052,199 91%
Environmental Services Total 11,000,000 947,801 10,052,199 91%
Finance
PRJ000038 ERP Project 6,231,654 5,898,066 333,588 5%
Finance Total 6,231,654 5,898,066 333,588 5%
Fire
PRJ000134 SCBA Replacement 870,000 - 870,000 100%
PRJ000135 Cardiac Monitors 483,517 483,517 - 0%
Fire Total 1,353,517 483,517 870,000 100%
Fleet
PRJ000124 Radio Replacement 363,278 - 363,278 100%
Fleet Total 363,278 - 363,278 100%
GTEC Department
PRJ000203 FM1460 Widening 948,982 48,982 900,000 95%
PRJ000206 NB Front Rd (2338 To Lakeway)216,000 221,766 (5,766) -3%
GTEC Department Total 1,164,982 270,748 894,234 92%
Management Services
PRJ000028 Downtown Parking Expansion 728,510 701,947 26,564 4%
PRJ000029 Downtown Parking Garage 411,815 411,815 - 0%
PRJ000033 Dtwn Landsping & Public Art 90,000 56,706 33,294 37%
PRJ000037 EOC Siren System 15,525 15,525 - 0%
PRJ000042 Fire Station 6 5,500,000 5,330,405 169,595 3%
PRJ000043 Fire Station 7 8,550,000 6,457,667 2,092,333 24%
PRJ000067 Parking Improvements 68,510 - 68,510 100%
PRJ000131 Fuel Station 1,100,000 - 1,100,000 100%
PRJ000136 GMC Remodel Phase I 250,000 30,614 219,386 88%
PRJ000178 Public Safety Operation and Training Center Phase II 4,500,000 - 4,500,000 100%
PRJ000179 Recreation Center Teen/Senior Renovation 200,000 - 200,000 100%
PRJ000180 Recreation Center Natatorium HVAC Replacement 700,000 656,176 43,824 6%
PRJ000191 Georgetown City Center - Festival/Public Space 5,400,000 14,099 5,385,901 100%
PRJ000223 City Center Signage 125,000 - 125,000 100%
Management Services Total 27,639,360 13,674,954 13,964,406 762%
59
Row Labels Total Budget Total Spend Remaining Budget Percent Remaining
Parks
PRJ000048 Garey Park 15,346,730 15,100,250 246,480 2%
PRJ000089 San Gabriel Park Improvement 13,025,000 7,448,252 5,576,748 43%
PRJ000125 Parks Master Plan 229,998 229,998 - 0%
PRJ000126 Regional Trail Development 1,550,000 138,100 1,411,900 91%
PRJ000127 Neighborhood Park Development 1,250,000 240,541 1,009,459 81%
PRJ000129 Ada Transition Plan 1,075,982 276,682 799,300 74%
PRJ000130 Tennis Center Pool Demo 40,002 39,076 926 2%
PRJ000190 Heritage Gardens 274,934 81,400 193,534 70%
PRJ000205 Katy Crossing Trail 700,000 500,181 199,819 29%
Parks Total 33,492,646 24,054,481 9,438,165 392%
Police
PRJ000133 Body Cameras 800,000 737,412 62,588 8%
Police Total 800,000 737,412 62,588 8%
Public Works - Self Managed Department
PRJ000204 Historic District Street Signs 26,000 - 26,000 100%
Public Works - Self Managed Department Total 26,000 - 26,000 100%
Public Works Department
PRJ000013 Austin Avenue Bridge 2,855,398 1,711,629 1,143,769 40%
PRJ000137 Intersection Improvements (Lakeway @ Williams Drive) 1,400,000 252,450 1,147,550 82%
PRJ000138 Downtown Sidewalks 2,000,000 470,719 1,529,281 76%
PRJ000139 Westinghouse - Scenic Lake Traffic Signal 600,000 87,028 512,972 85%
PRJ000141 Southwestern Blvd 4,200,000 866,960 3,333,040 79%
PRJ000143 Leander Rd(Norwood-Swbypass)6,750,000 994,025 5,755,975 85%
PRJ000171 Shell Rd Sidewalk 229,825 203,755 26,070 11%
PRJ000188 DB Wood (SH 29 to Oak Ridge)4,000,000 1,703,636 2,296,364 57%
PRJ000201 Austin Ave. (Sh29-Fm2243)466,000 466,000 - 0%
PRJ000202 FM 971 4,853,000 1,113,617 3,739,383 77%
PRJ000207 Northwest Blvd Bridge 11,254,320 11,372,616 (118,296) -1%
PRJ000208 Old Town Northeast 1,050,000 923,818 126,182 12%
PRJ000209 Southeast Inner Loop 10,521,000 8,884,343 1,636,657 16%
PRJ000214 Intersection Improvements (Traffic Signals)1,650,000 159,863 1,490,137 90%
PRJ000215 2021 Intersection Safety Enhancements (RRFB)150,000 96,450 53,550 36%
PRJ000216 FY21 Downtown Sidewalk Improvements 1,000,000 130,000 870,000 87%
PRJ000217 SW Bypass - Wolf Ranch Extension 1,000,000 633,943 366,057 37%
Public Works Department Total 53,979,543 30,070,852 23,908,691 871%
Right of Way
PRJ000200 Access Rtw To Government Srv 220,000 220,000 - 0%
Right of Way Total 220,000 220,000 - 0%
GCP Total 136,270,980 76,357,831 59,913,149 2521%
60
Row Labels Total Budget Total Spend Remaining Budget Percent Remaining
General Fund Projects
Parks
PRJ000055 Katy Crossing Trail 700,000 17,780 682,220 97%
Parks Total 700,000 17,780 682,220 97%
Public Works Department
PRJ000012 Austin Ave. (Sh29-Fm2243) (Inactive) 466,000 - 466,000 100%
Public Works Department Total 466,000 - 466,000 100%
Right of Way
PRJ000007 Access Rtw To Government Srv 220,000 - 220,000 100%
Right of Way Total 220,000 - 220,000 100%
General Fund Projects Total 1,386,000 17,780 1,368,220 297%
GTEC
GTEC Department
PRJ000046 FM 971/ Fontana (Nw Bridge) 1,209,000 1,193,000 16,000 1%
PRJ000053 IH 35/ Hwy 29 Intersection Imp 1,800,000 120,066 1,679,934 93%
PRJ000060 Rabbit Hill Road 4,100,000 179,757 3,920,243 96%
PRJ000083 Rivery Tia Improvements 1,179,000 1,110,970 68,030 6%
PRJ000092 Se Inner Loop Widening (Inactive) 8,148,000 - 8,148,000 100%
PRJ000145 Sh29 Signal And Roadway Improvements 1,595,000 312,671 1,282,329 80%
PRJ000146 Wolf Ranch Parkway Extension (Inactive) 1,100,000 - 1,100,000 100%
PRJ000181 Aviation Drive 10,300,000 275,868 10,024,132 97%
PRJ000182 Confido III 600,000 - 600,000 100%
PRJ000183 Big C Project 2,000,000 - 2,000,000 100%
GTEC Department Total 32,031,000 3,192,332 28,838,668 774%
GTEC Total 32,031,000 3,192,332 28,838,668 774%
Stormwater
Stormwater
PRJ000004 18th and Hutto Drainage 50,000 6,356 43,644 87%
PRJ000005 2nd and Rock Pond 625,000 447,151 177,849 28%
PRJ000024 2020 Curb & Gutter 1,055,000 337,047 717,953 68%
PRJ000104 Stormwater Infrastructure 347,000 168,506 178,495 51%
PRJ000148 Water Quality Ponds 98,000 - 98,000 100%
PRJ000149 Drainage Improvement/Flood Mitigation Projects 300,000 - 300,000 100%
PRJ000213 2021 Curb & Gutter Project 500,000 53,100 446,900 89%
Stormwater Total 2,975,000 1,012,160 1,962,840 525%
Stormwater Total 2,975,000 1,012,160 1,962,840 525%
61
Row Labels Total Budget Total Spend Remaining Budget Percent Remaining
Street Tax
Public Works Department
PRJ000172 2020 Street Maintenance High Performance Seal: Bid Package No.1 372,200 372,200 - 0%
PRJ000173 2020 Street Maintenance High Performance Seal: Bid Package No. 2 463,195 482,214 (19,020) -4%
PRJ000174 2020 street maintenance HIPR 1,935,589 1,441,013 494,576 26%
PRJ000210 2021 HIPR Street Maintenance 2,300,000 274,700 2,025,300 88%
PRJ000211 2021 High Performance Pavement Seal Project #1 600,000 94,900 505,100 84%
PRJ000212 2021 High Performance Pavement Seal Project #2 600,000 90,700 509,300 85%
PRJ000237 Northeast Inner Loop (Stadium to FM971) Emergency Repairs 700,000 695,456 4,544 1%
Public Works Department Total 6,970,983 3,451,183 3,519,800 279%
Street Tax Total 6,970,983 3,451,183 3,519,800 279%
Transportation
GTEC Department
PRJ000047 FM1460 Widening (Inactive)794,000 - 794,000 100%
PRJ000061 NB Front Rd (2338 To Lakeway) (Inactive)366,000 - 366,000 100%
GTEC Department Total 1,160,000 - 1,160,000 200%
Public Works Department
PRJ000045 FM 971 2,000 (26,684) 28,684 1434%
PRJ000063 Northwest Blvd Bridge 21,743,000 421,578 21,321,422 98%
PRJ000065 Old Town Northeast (Inactive)855,021 (19,064) 874,085 102%
PRJ000100 Southeast Inner Loop 3,321,000 - 3,321,000 100%
Public Works Department Total 25,921,021 375,830 25,545,190 1734%
Transportation Total 27,081,021 375,830 26,705,190 1934%
62
Row Labels Total Budget Total Spend Remaining Budget Percent Remaining
Water
Water
PRJ000014 Berry Creek Inter.49,949,000 701,486 49,247,514 99%
PRJ000016 Braun Est 4,750,000 1,202,760 3,547,240 75%
PRJ000017 Cedar Breaks Est 3,385,000 236,730 3,148,270 93%
PRJ000023 Cr 255 (Wd14-2)1,493,963 323,841 1,170,122 78%
PRJ000025 Db Wood/ Pastor 24 Dedicated 5,286,000 423,726 4,862,274 92%
PRJ000027 Domel PS Improvements (Inactive) 5,816,000 - 5,816,000 100%
PRJ000034 Earz 2,326,000 469,283 1,856,717 80%
PRJ000057 Lift Station Upgrade 1,173,593 - 1,173,593 100%
PRJ000059 LWTP Raw Water Intake Rehab 6,750,000 5,506,976 1,243,024 18%
PRJ000066 Park Lift Station & Force Main 3,574,341 2,115,836 1,458,505 41%
PRJ000069 Pecan Branch Ph 2 253,000 232,521 20,479 8%
PRJ000075 Pumps & Storage 1,009,289 9,289 1,000,000 99%
PRJ000076 Rabbit Hill Est 1,826,000 873,294 952,706 52%
PRJ000085 Ronald Reagan/Daniels Mountain 4,400,000 167,638 4,232,362 96%
PRJ000087 S. Lake Wtp 2018 (Inactive) 6,950,000 - 6,950,000 100%
PRJ000088 San Gabriel Belt Press and Rehab 3,200,000 2,580,279 619,721 19%
PRJ000096 Shell Road Water Line 6,890,000 992,205 5,897,795 86%
PRJ000101 Southlake Wtp 100,000,000 8,590,093 91,409,907 91%
PRJ000103 Stonehedge Ls & Fm (Inactive) 150,000 - 150,000 100%
PRJ000108 Sun City Elevated Storage Tank (Inactive) 3,224,000 - 3,224,000 100%
PRJ000110 Sw Bypass Waterline (Inactive) 1,106,000 - 1,106,000 100%
PRJ000119 Water Mains 1,537,000 433,498 1,103,502 72%
PRJ000121 Westinghouse Ls & Fm (Inactive) 3,299,000 - 3,299,000 100%
PRJ000122 Westside Facility (Inactive)505,500 - 505,500 100%
PRJ000123 WW Interceptors 608,431 - 608,431 100%
PRJ000150 Carriage Oaks Transmission 500,000 - 500,000 100%
PRJ000151 FY2020 CR262 Waterline 500,000 - 500,000 100%
PRJ000152 Hoover Pump Station 6,850,000 855,221 5,994,779 88%
PRJ000153 FY2020 Round Rock Supply Line (Inactive)300,000 17,345 282,655 94%
PRJ000154 FY2020 Stonewall Ranch Ps Improvements 500,000 - 500,000 100%
PRJ000155 Southside Water Treatment Plant 2,250,000 21,840 2,228,160 99%
PRJ000156 Gatlin/Teravista Improvements 450,000 - 450,000 100%
PRJ000157 Leander Interconnect 515,000 49,495 465,505 90%
PRJ000158 West loop (H-1A)2,119,000 447,385 1,671,615 79%
PRJ000160 Round Rock Supply Pump Station And Elevated Storage Tank 10,500,000 1,427,473 9,072,527 86%
PRJ000161 Miscellaneous Line Upgrades 872,000 655,875 216,125 25%
PRJ000162 South West Bypass Water (H24-1) 2,906,000 2,301,498 604,502 21%
PRJ000163 Tank Rehabilitation 2,905,000 445,994 2,459,006 85%
PRJ000164 Council Chamber Water 423,000 15,960 407,040 96%
PRJ000165 San Gabriel Wwtp Rehab 2,500,000 98,000 2,402,000 96%
PRJ000167 San Gabriel Inter SGI -2 4,500,000 912,755 3,587,245 80%
PRJ000168 WWTP Upgrade 950,000 - 950,000 100%
PRJ000177 Northlake WTP Phase IV Expansion 15,000,000 11,859,923 3,140,077 21%
PRJ000185 Cimarron Hills Wastewater Treatment Plant Expansion 800,000 - 800,000 100%
PRJ000218 EARZ Wastewater Rehabilitation Area 2 - 2019 2,460,360 2,460,360 - 0%
PRJ000219 Southside GST Foundation Improvements 535,678 - 535,678 100%
PRJ000228 Southside GST Roof Rehab 567,000 - 567,000 100%
Water Total 278,365,155 46,428,578 231,936,576 3759%
Water Operations
PRJ000220 AMI Western District Improvements 750,000 - 750,000 100%
Water Operations Total 750,000 - 750,000 100%
Water Total 279,115,155 46,428,578 232,686,576 3859%
Grand Total 501,409,805 137,902,820 363,506,985 12504%
63
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21
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/2020, the net pension liability is $18.7
million and is 88.97% funded. This decrease in liability
is due to a change in the actuarial assumptions.
No change.
Other Post Employee Benefits
(OPEB)
While the City has no obligation to offer additional retiree
benefits, retirees are eligible to participate in the City’s
health insurance program. That ability represents a
subsidy that impacts health insurance costs to the City.
Retirees pay their monthly premiums to the self insurance
fund, which then processes their health insurance claims.
OPEB liability as of 9/30/2020 is $2.7 million. This is a
combination of sudden death benefits as well as post‐
retirement healthcare.
No change.
Compensated Absence
Future costs associated with benefits such as vacation, and
sick leave for City employees. Compensated Absence is
accrued annually to each proprietary fund type on a GAAP
basis and accounted for on the balance sheet of each fund.
For governmental funds (and for budgetary basis), the
expense is recognized when due and payable. The City
keeps a reserve in the General Fund to help offset large
payouts for long‐term employees. The reserve is used as
needed, and annually replenished or increased based on
known risk.
Compensated absences as of 9/30/2020 are $8.2
million. More time was earned than used during
FY2020 as many plans were changed related to the
pandemic. The City did not extend any vacation cap
carry overs in general. As with any year, specific
requests for carryover are considered and approved
by the City Manager.
No change.
CITY OF GEORGETOWN
Long-term Commitments, Reservations, and Other Unfunded Liabilities
3/31/2021
64
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21
Electric Fund Rate
Stabilization Reserve
Intended to mitigate potential rate impacts due to
increased purchased power costs or other external factors.
The RSR is maintained within the Electric Fund.
During the 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.
During the February Winter Storm Uri, the Electric
Fund incurred an additional $48 million in energy
market costs. The City issued a debt instrument that
will be paid from current PCA rates. There are no
expected changes to Electric reserves.
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.
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.
Continued maintenance on buildings and pavement
surfaces. We will have to do pavement sealing on
Taxiway A to prevent early deterioration. This will
include a seal coat and repainting of all markings. We
have prepared all documentation and supporting
evidence for CRRSA (the 2nd relief grant) for
reimbursement. We are waiting on TxDOT to
establish the process. This will be ~$57K. The relief
grant has yet to be established by the FAA. We expect
to get another award for that as well.
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.
A competitive sealed bid has been completed for
ADA repairs along the South San Gabriel River
Trail. The contract is in Legal for review.
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. 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.
Rock Sidewalk/FY 20 Downtown ADA Sidewalk
Improvements. Project is awarded to Choice Builders.
Construction to begin in May 2021. FY21 Downtown
ADA Sidewalk improvements will be a continuation of
Downtown ADA improvements and closing gaps.
Design for this project will begin in May 2021. The
mobility bond passed in the May election, providing
new funding over the next 7 years for sidewalks.
65
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21
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.
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.
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.
Ordered 22 portable radios for Electric Dept. Ordered
9 mobiles and 4 portables for 911 Communications.
Processing 8 portable radios for Police in Workday.
Still working on the other 35 non‐public safety radios.
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.
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.
The Council declined to appropriate any available
fund balance during an April workshop. The February
Winter Storm Uri caused damage to a section of Inner
Loop. The Street Sales Tax Fund will cover the
approximately $700K for repairs. The road is not
eligible for FEMA reimbursement.
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.
IT has drafted a cost recovery plan for fiber and it is
being evaluated as part of the FY2022 budget
development process.
66
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 12/31/20 Status Updates ‐ 3/31/21
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.
IT has drafted a cost recovery plan for fiber and it is
being evaluated as part of the FY2022 budget
development process.
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.
Facilities has drafted a cost recovery plan for fund
balance reserves and it is being evaluated as part of
the FY2022 budget development process.
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.
Council declined to appropriate any available fund
balance at mid‐year to achieve this goal. The Cost
Allocation Model study was put on hold due to
activities needed to recover from the Winter Storm.
67