HomeMy WebLinkAboutFY 19 - 4th Qtr Report_RedactedFINANCIAL REPORT AND INVESTMENT REPORT
For the Quarter Ended September 30, 2019
Table of Contents
Executive Summary .................................................................................................................................... 1-8
General Fund Schedule ................................................................................................................................. 9
Electric Fund Schedule ................................................................................................................................ 10
Water Services Fund Schedule .................................................................................................................... 11
Joint Services Fund Schedule ....................................................................................................................... 12
Council Discretionary Fund Schedule .......................................................................................................... 13
Convention & Visitors Bureau Fund Schedule ............................................................................................. 14
Airport Fund Schedule ................................................................................................................................. 15
Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 16
Georgetown Economic Development Corporation Fund Schedule ............................................................. 17
Quarterly Investment Report - City ........................................................................................................ 18-46
Quarterly Investment Report - GTEC ...................................................................................................... 47-53
Quarterly Investment Report - GEDCO ................................................................................................... 54-60
Grant Applications ....................................................................................................................................... 61
Capital Improvement Projects ................................................................................................................ 62-63
Long-term Commitments and Other Unfunded Liabilities ..................................................................... 64-66
APRROVED BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
YEAR-END
VARIANCE
FAV(UNFAV)
%YEAR-END
VARIANCE
FAV(UNFAV)
BEGINNING FUND BALANCE 10,917,971 10,946,800 10,946,800 - -
Revenue
Administrative Charges 2,428,000 202,333 2,428,000 2,428,000 - -
All Other Revenue 2,430,500 163,657 2,294,810 2,183,832 110,978 5.08%
Development and Permit Fees 3,307,000 584,658 4,151,850 3,726,935 424,915 11.40%
Franchise Fees 5,434,000 1,469,942 5,646,479 5,589,123 57,356 1.03%
Parks and Rec Fees 2,960,100 192,226 2,668,469 2,708,167 (39,698) -1.47%
Property Tax 13,850,000 (7,060) 13,800,380 13,880,000 (79,620) -0.57%
ROI 7,777,490 2,114,771 7,364,577 7,277,490 87,087 1.20%
Sales Tax 15,924,475 4,117,811 16,581,705 16,734,375 (152,670) -0.91%
Sanitation Revenue 9,448,500 648,982 9,116,394 9,452,750 (336,356) -3.56%
Fire/EMS Revenue 6,926,266 695,640 7,059,204 6,885,370 173,834 2.52%
Transfer In 321,782 88,750 321,783 321,783 - -
Revenue Total 70,808,113 10,271,710 71,433,651 71,187,825 245,826 0.35%
Expense
Administrative Services 1,571,103 153,897 1,605,930 1,571,084 (34,846) -2.22%
Animal Services 926,122 91,148 871,897 888,693 16,796 1.89%
Arts & Culture 37,545 4,444 39,077 37,545 (1,532) -4.08%
City Council 171,395 12,517 168,069 169,595 1,526 0.90%
City Secretary 897,280 104,525 801,804 844,379 42,575 5.04%
Code Enforcement 432,800 42,385 387,844 419,061 31,217 7.45%
Communications 425,160 34,110 399,754 409,718 9,964 2.43%
Environmental Services 7,902,414 1,402,531 7,740,074 7,901,514 161,440 2.04%
Fire Emergency Services 13,181,569 1,369,109 12,859,582 13,177,738 318,156 2.41%
Fire Support Services 3,000,589 297,663 2,892,457 2,973,649 81,192 2.73%
Fire EMS 2,593,697 250,939 2,376,764 2,584,430 207,666 8.04%
Garey Park 948,290 96,529 760,203 842,399 82,196 9.76%
General Gov't Contracts 3,430,401 292,430 4,365,305 3,964,796 (400,509) -10.10%
Inspections 1,277,145 120,509 1,237,826 1,249,703 11,877 0.95%
Library 2,696,579 238,558 2,688,859 2,683,051 (5,808) -0.22%
Municipal Court 635,935 51,169 634,728 634,168 (560) -0.09%
Parks 2,799,674 270,489 2,605,753 2,691,034 85,281 3.17%
Parks Admin 615,051 54,178 600,757 613,715 12,958 2.11%
Planning 1,746,148 167,838 1,369,134 1,507,294 138,160 9.17%
Police Admin 2,355,161 206,855 2,391,132 2,387,527 (3,605) -0.15%
Police Operations 12,450,598 1,094,182 12,397,439 12,575,343 177,904 1.41%
Public Works 1,296,263 138,943 1,050,822 1,196,755 145,933 12.19%
Rec Programs 1,358,009 99,158 1,246,310 1,310,665 64,355 4.91%
Recreation 2,650,888 221,179 2,639,488 2,650,686 11,198 0.42%
Streets 4,688,211 330,695 3,942,701 4,463,819 521,118 11.67%
Tennis Center 463,162 42,318 411,338 449,365 38,027 8.46%
Transfer Out 361,000 - 361,000 446,000 85,000 19.06%
Expense Total 70,912,190 7,188,299 68,846,048 70,643,726 1,797,678 2.54%
EXCESS (DEFICIENCY) OF TOTAL REVENUE
OVER TOTAL REQUIREMENTS (104,077) 3,083,411 2,587,603 544,099 2,043,504 375.58%
ENDING FUND BALANCE 10,813,894 13,534,403 11,490,899 2,043,504 17.78%
RESERVES
Contingency Reserve 9,977,771 9,977,771 9,977,771
Benefit Payout Reserve 255,000 255,000 255,000
Reserve Total 10,232,771 10,232,771 10,232,771
AVAILABLE FUND BALANCE 581,123 3,301,632 1,258,128 2,043,504 162.42%
Preliminary Actuals to Year-End Projection: Sept FY 2019
General Fund
9
APRROVED
BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR‐END
PROJECTION
YEAR‐END
VARIANCE
FAV(UNFAV)
% YEAR‐END
VARIANCE
FAV(UNFAV)
BEGINNING FUND BALANCE 2,103,922 2,103,922 2,103,922 ‐ 0.00%
Operating Revenue
Electric Revenue 79,100,000 9,368,227 80,255,956 80,100,000 155,956 0.19%
Interest 38,000 2,968 78,214 78,214 ‐ ‐
Other Revenue 5,233,546 827,032 5,343,637 5,216,177 127,460 2.44%
Transfer In 95,787 ‐ ‐ ‐ ‐ NA
Operating Revenue Total 84,467,333 10,198,227 85,677,807 85,394,391 283,416 0.33%
Operating Expenditures
CRR Credits (3,000,000) (532,188) (2,821,759) (2,821,759) ‐ ‐
Georgetown Utility Systems 19,337,779 1,870,561 18,897,528 19,347,922 450,394 2.33%
Purchased Power 53,185,477 11,879,286 58,465,559 58,465,559 ‐ ‐
Transfers Out ‐ROI 4,325,000 153,497 3,825,000 3,825,000 ‐ ‐
Operating Expenditures Total 73,848,256 13,371,156 78,366,328 78,816,722 450,394 0.57%
Total Net Operations 10,619,077 (3,172,929) 7,311,479 6,577,669 733,810 11.16%
Non‐Operating Revenue
Renewable Energy Credits ‐ 722,381 722,381 722,381 ‐ ‐
Grant Revenue 100,000 ‐ ‐ ‐ ‐ NA
Transfers In 548,104 2,196,009 2,196,009 2,196,009 ‐ ‐
Sale of Assets 10,000 1,483,867 1,504,207 859,162 645,045 75.08%
Non‐Operating Revenue Total 658,104 4,402,257 4,422,597 3,777,552 645,045 17.08%
Non‐Operating Expenditures
CIP 4,017,007 744,586 3,857,165 3,872,055 14,890 0.38%
Interest Expense 1,386,781 (305,234) 1,081,547 1,081,547 ‐ ‐
Debt Service 3,035,374 (468,725) 2,565,874 2,565,874 ‐ ‐
Non‐Operating Expenditures Total 8,439,162 (29,373) 7,504,586 7,519,476 14,890 0.20%
Total Net Non‐Operations (7,781,058) 4,431,630 (3,081,989) (3,741,924) 659,935 17.64%
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS 2,838,019 1,258,702 4,229,490 2,835,745 1,393,745 49.15%
ENDING FUND BALANCE 4,941,941 6,333,412 4,939,667 1,393,745 28.22%
RESERVES
Contingency 4,082,999 4,082,999 4,082,999
Rate Stabilization Reserve 147,079 2,250,413 856,668
Reserves Total 4,230,078 6,333,412 4,939,667
AVAILABLE FUND BALANCE 711,863 0 0 ‐ ‐
Electric Fund
Preliminary Actuals to Year‐End Projection: Sep FY2019
10
APRROVED
BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
YEAR-END
VARIANCE
FAV(UNFAV)
% YEAR-END
VARIANCE
FAV(UNFAV)BEGINNING FUND BALANCE 89,159,703 89,128,534 89,128,534 - 0.00%
Operating Revenue
Capital Recovery Fee 14,250,000 1,163,198 15,803,197 15,139,255 663,942 4.39%
Interest 569,400 160,456 2,080,718 1,482,998 597,720 40.30%
Irrigation Utility Revenue 301,557 89,338 302,818 301,578 1,241 0.41%
Other Revenue 2,262,146 321,202 5,316,144 3,546,274 1,769,870 49.91%Raw Water Revenue 140,000 132,603 353,873 140,000 213,873 152.77%
Transfer In, Debt 103,725 103,725 103,725 103,725 - 0.00%
Wastewater Utility Revenue 12,975,345 (40,868)12,026,638 13,015,186 (988,548)-7.60%
Water Utility Revenue 29,116,931 5,547,482 31,890,934 29,350,000 2,540,934 8.66%
Operating Revenue Total 59,719,104 7,477,137 67,878,047 63,079,016 4,799,031 7.61%
Operating Expenditures
Irrigation 270,324 21,318 167,875 270,000 102,125 37.82%
Transfer Out, Fleet/Joint Service 245,000 - 245,000 245,000 - 0.00%
Transfer Out, General 275,000 68,750 275,000 275,000 - 0.00%
Transfer Out, ROI 3,200,000 1,842,036 3,286,284 3,200,000 (86,284)-2.70%
Transfer Out, Utilities 95,787 - - - - N/A
Wastewater Distribution 904,415 206,395 713,376 795,050 81,674 10.27%
Wastewater Plant Management 2,705,069 345,293 2,843,610 2,687,676 (155,934)-5.80%
Water Administration 19,923,733 3,272,624 20,251,416 20,981,179 729,763 3.48%
Water Distribution 2,707,265 550,231 2,450,121 2,598,600 148,479 5.71%
Water Operations 4,157,528 384,377 4,241,261 4,252,288 11,027 0.26%
Water Plant Management 2,948,733 399,701 2,588,735 2,909,309 320,573 11.02%Operating Expenditures Total 37,432,854 7,090,725 37,062,678 38,214,102 1,151,424 3.01%
Total Net Operations 22,286,250 386,412 30,815,368 24,864,914 5,950,455 23.93%
Non-Operating Revenue
Bond Proceeds - - - - - N/A
Non-Operating Revenue Total
Non-Operating Expenditures
Transfer Out - 1,562,500 1,562,500 - (1,562,500) N/ACIP 90 85,667,940 2,247,266 28,783,245 40,226,858 11,443,613 28.45%
CIP 91 - - 62,218 - (62,218)N/A
Debt Service 6,250,111 777,759 7,024,771 6,250,111 (774,660)-12.39%
Non-Operating Expenditures Total 91,918,051 4,587,524 37,432,734 46,476,969 9,044,236 19.46%
Total Net Non-Operations (91,918,051) (4,587,524) (37,432,734) (46,476,969) 9,044,236 19.46%
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS (69,631,801) (4,201,112) (6,617,365) (21,612,055) 14,994,690 69.38%
ENDING FUND BALANCE 19,527,902 82,511,169 67,516,479 14,994,690 22.21%
Reserves
Reserved Bond Proceeds 18,000,000 18,000,000
90 Day Operational Contingency 7,498,183 7,498,183 7,498,183 Non-Operational Contingency 9,500,000 9,500,000 9,500,000
Reserves Total 16,998,183 34,998,183 34,998,183
AVAILABLE FUND BALANCE 2,529,719 47,512,986 32,518,296 14,994,690 46.11%
Water Fund
Preliminary Actuals to Year-End Projection: Sep FY2019
11
APRROVED
BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
YEAR-END
VARIANCE
FAV(UNFAV)
%YEAR-END
VARIANCE
FAV(UNFAV)
BEGINNING FUND BALANCE 1,469,434 1,469,434 1,469,434 - -
Revenue
Gedco Admin/Contract Fee 238,622 19,885 238,622 238,622 - -
Gtec Admin/Contract Fee 172,318 14,360 172,318 172,318 - -
Interest 17,503 3,066 21,881 25,000 (3,119) -12.48%
Other 136,153 17,749 166,918 213,412 (46,494) -21.79%
Service Fees - Airport 128,966 10,747 128,966 128,966 - -
Service Fees - Electric 4,615,524 82,983 4,313,880 4,313,880 - -
Service Fees - General 3,573,156 109,236 3,384,629 3,384,629 - -
Service Fees - Stormwater 1,020,427 47,330 982,721 982,721 - -
Service Fees - Water 7,966,284 1,191,735 8,494,162 8,494,162 - -
VPID Admin/Contract Fee 15,924 1,327 15,924 15,924 - -
Revenue Total 17,884,877 1,498,418 17,920,021 17,969,634 (49,613) -0.28%
Expense
Accounting 1,067,433 121,975 1,042,590 1,044,212 1,622 0.16%
BIP 150,085 15,915 132,497 127,117 (5,380) -4.23%
City Wide Hr 415,500 64,843 335,868 382,500 46,632 12.19%
Conservation 766,699 77,230 645,400 704,374 58,974 8.37%
Customer Care 4,701,266 407,970 4,665,988 4,696,447 30,459 0.65%
Economic Development 635,768 52,314 575,053 609,899 34,846 5.71%
Engineering 2,430,052 233,283 2,257,510 2,258,637 1,127 0.05%
Engineering Support 1,147,160 98,543 1,102,642 1,131,488 28,846 2.55%
Finance Administration 975,583 134,370 957,379 960,951 3,573 0.37%
Gus Administration 1,476,541 122,981 1,419,084 1,490,841 71,757 4.81%
Human Resources 1,003,190 105,905 983,696 991,779 8,083 0.81%
In-House Legal 1,038,782 158,884 1,067,373 1,031,103 (36,270) -3.52%
Insurance & Legal 752,000 10,095 658,146 727,249 69,103 9.50%
Joint Svcs Con 598,775 436,611 1,250,595 960,000 (290,595) -30.27%
Purchasing 811,459 153,987 763,425 770,628 7,203 0.93%
Transfer Out 157,000 100,000 157,000 157,000 - -
Expense Total 18,127,293 2,294,908 18,014,245 18,044,225 29,980 0.17%
EXCESS (DEFICIENCY) OF TOTAL REVENUE
OVER TOTAL REQUIREMENTS (242,416) (796,489) (94,224) (74,591) (19,633)-26.32%
ENDING FUND BALANCE 1,227,018 1,375,210 1,394,843 (19,633) -1.41%
RESERVES
Contingency 1,227,018 1,227,018 1,227,018
Reserves Total 1,227,018 1,227,018 1,227,018
AVAILABLE FUND BALANCE - 148,192 167,825 (19,633) -11.70%
Joint Services Fund
Preliminary Actuals to Year-End Projection: Sep FY2019
12
APRROVED
BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
YEAR-END
VARIANCE
FAV(UNFAV)
%YEAR-END
VARIANCE
FAV(UNFAV)
BEGINNING FUND BALANCE 131,914 131,915 131,915 - 0.00%
Revenue
Interest 10,000 227 2,468 2,500 (32) -1.27%
Transfer In, General Fund - - - - - - Revenue Total 10,000 227 2,468 2,500 (32) -1.27%
Expense
Transfer Out, GCP - - - - - -
Transfer Out, General Fund 25,000 20,000 25,000 25,000 - -
Transfer Out, Joint Services - - - - - - Expense Total 25,000 20,000 25,000 25,000 - -
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS (15,000) (19,773) (22,532) (22,500) (32) 0.14%
ENDING FUND BALANCE 116,914 109,383 109,415 (32) -0.03%
Preliminary Actuals to Year-End Projection: Sep FY2019
Council Discretionary Fund
13
APRROVED BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
YEAR-END
VARIANCE
FAV(UNFAV)
%YEAR-END
VARIANCE
FAV(UNFAV)
BEGINNING FUND BALANCE 1,170,801 1,301,054 1,301,054 - -
Revenue
Hotel/Motel Occupancy Tax Revenues 1,350,000 119,749 1,393,228 1,300,000 93,228 7.17%
Interest 5,000 2,593 23,784 18,000 5,784 32.14%
Other 23,500 929 20,847 18,500 2,347 12.69%
Poppy Festival 136,150 749 134,883 144,283 (9,400) -6.52%
Revenue Total 1,514,650 124,020 1,572,742 1,480,783 91,959 6.21%
ExpenseOperations 713,831 69,990 689,559 703,729 14,170 2.01%
Personnel 369,492 32,487 378,505 371,704 (6,801) -1.83%
Poppy Festival 165,200 - 161,522 165,200 3,678 2.23%
Transfer to Facilities 49,507 4,126 49,507 49,507 - -
Transfer to Fleet 5,048 421 5,048 5,048 - -
Transfer to General Fund 21,783 - 21,783 21,783 - - Transfer to Information Technology 27,722 2,310 27,722 27,722 - - Expense Total 1,352,583 109,334 1,333,645 1,344,693 11,048 0.82%
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS 162,067 14,686 239,097 136,090 103,007 75.69%
ENDING FUND BALANCE 1,332,868 1,540,151 1,437,144 103,007 7.17%
RESERVES
Contingency 271,189 271,189 271,189 Reserved for Capital 1,061,680 1,061,680 1,061,680
Reserves Total 1,332,869 1,332,869 1,332,869
AVAILABLE FUND BALANCE (1) 207,282 104,275 103,007 98.78%
Preliminary Actuals to Year-End Projection: Sep FY2019
Convention & Visitors Bureau Fund
14
APPROVED
BUDGET CURRENT PERIOD
YEAR YO DATE
(W/ENCUMB)
YEAR‐END
PROJECTION
YEAR‐END
VARIANCE
FAV(UNFAV)
% YEAR‐END
VARIANCE
FAV(UNFAV)
BEGINNING FUND BALANCE 1,298,256 1,298,256 1,298,256 ‐ ‐
Operating Revenue
Fuel and Terminal Sales 2,907,450 214,113 2,446,977 2,751,500 (304,523) ‐11.07%
Interest and Other 80,260 35,551 84,372 86,000 (1,628) ‐1.89%
Leases and Rentals 863,952 73,083 865,655 859,940 5,715 0.66%
Operating Revenue Total 3,851,662 322,747 3,397,004 3,697,440 (300,436) ‐8.13%
Operating Expenditures
Operations‐Fuel 2,389,550 186,185 1,934,792 2,200,000 265,208 12.05%
Operations‐Non Fuel 743,171 80,664 737,735 726,748 (10,987) ‐1.51%
Personnel 417,348 52,860 381,938 371,525 (10,413) ‐2.80%
Operating Expenditures Total 3,550,069 319,709 3,054,464 3,298,273 243,809 7.39%
TOTAL NET OPERATIONS 301,593 3,037 342,539 399,167 (56,627) ‐14.19%
Non‐Operating Revenue
Bond Proceeds 465,000 ‐ 472,813 465,000 7,813 1.68%
Grants 40,000 ‐ 55,870 40,000 15,870 39.68%
Non‐Operating Revenue Total 505,000 ‐ 528,683 505,000 23,683 4.69%
Non‐Operating Expenditures
Airport Master Plan ‐ ‐ 5,870 ‐ (5,870) ‐
Debt Service 147,975 27 139,886 147,975 8,089 5.47%
Edge Lighting 150,000 (128,760) ‐ 150,000 150,000 100.00%
Hangar Upgrades 75,000 12,331 75,000 75,000 ‐ 0.00%
Pavement Upgrades 15,000 ‐ (10,744) 15,000 25,744 171.63%
Runway Rehab 516,500 475,677 475,677 516,500 40,823 7.90%
Wildfire Management 35,000 7,200 31,801 35,000 3,199 9.14%
Non‐Operating Expenditure Total 939,475 366,475 717,491 939,475 221,984 23.63%
TOTAL NET NON‐OPERATIONS (434,475) (366,475) (188,807) (434,475) 245,668 56.54%
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL
REQUIREMENTS (132,882) (363,439) 153,732 (35,308) 189,040 535.40%
ENDING FUND BALANCE 1,165,374 1,451,988 1,262,948 189,040 14.97%
RESERVES
Contingency 264,442 264,442 264,442
Reserves Total 264,442 264,442 264,442
AVAILABLE FUND BALANCE 900,932 1,187,546 998,506 189,040 18.93%
Airport Operations Fund
Preliminary Actuals to Year‐End Projection: Sep FY2019
15
APPROVED
BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
YEAR-END
VARIANCE
FAV(UNFAV)
% YEAR-END
VARIANCE
FAV(UNFAV)
BEGINNING FUND BALANCE 18,539,789 18,539,789 18,539,789 - -
Operating Revenue
Sales Tax 7,073,100 1,830,139 7,369,645 7,437,500 (67,855) -0.91%
Interest 190,000 26,909 480,236 308,317 171,919 55.76%
Operating Revenue Total 7,263,100 1,857,048 7,849,881 7,745,817 104,064 1.34%
Operating Expenditure
Administrative Support 391,697 32,575 391,018 391,197 (179) -0.05%Operating Expenditure Total 391,697 32,575 391,018 391,197 (179) -0.05%
TOTAL NET OPERATIONS 6,871,403 1,824,473 7,458,863 7,354,620 103,885 1.41%
Non-Operating Expenditure
Pecan Center Dr to Airport Rd (FY15)2,445,036 - (331) 386,000 386,331 100.09%
Arterial SE1: Inner Loop/SH130 - - - - - -
Rivery TIA Improvements 359,496 4,140 299,630 359,496 59,866 16.65%
FM 971 / Fontana 63,102 23,396 14,767 63,102 48,335 76.60%
Rivery-Extension Williams Dr to NW Blvd (FY16)730,635 797 475,883 730,635 254,752 34.87%
IH 35 / HWY29 Intersection 606,653 141 160,825 606,648 445,823 73.49%
NB Frontage 2338 to Lakeway 51,631 - 18,705 51,631 32,926 63.77%
SW Bypass 2243 to IH35 128,144 - - 13,071 13,071 100.00%
FM1460 Widening 500,783 - 60 500,784 500,724 99.99%
Wolf Ranch Pkwy Extension 283,350 - - 11,000 11,000 100.00%
Mays St 4,500,000 - 67,395 1,000,000 932,605 93.26%
Available for Projects TBD 1,716,644 - - 1,716,644 1,716,644 100.00%
SE Inner Loop Widening (Rock Ride ROW)900,000 - 948,251 948,251 - -
Debt Service 3,324,747 603 3,327,340 3,324,747 (2,593) -0.08%
Non-Operating Expenditure Total 15,610,221 29,077 5,312,525 9,712,009 4,399,484 45.30%
TOTAL NET NON-OPERATIONS (15,610,221) (29,077) (5,312,525) (9,712,009) 4,399,484 45.30%
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER
TOTAL REQUIREMENTS (8,738,818) 1,795,396 2,146,338 (2,357,389) 4,503,369 191.03%
ENDING FUND BALANCE 9,800,971 20,686,127 16,182,400 4,503,369 27.83%
RESERVES
Contingency 1,768,275 1,768,275 1,768,275
Reserved Bond Proceeds - 2,500,000 2,500,000
Reserves Total 1,768,275 4,268,275 4,268,275
AVAILABLE FUND BALANCE 8,032,696 16,417,852 11,914,125 4,503,727 37.80%
Georgetown Transportation Enhancement Corporation Fund
Preliminary Actuals to Year-End Projection September 2019
16
APPROVED
BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
YEAR-END
VARIANCE
FAV(UNFAV)
% YEAR-END
VARIANCE
FAV(UNFAV)
BEGINNING FUND BALANCE 6,853,073 6,972,637 6,972,637 - -
OPERATING REVENUES
Interest 40,300 14,494 178,542 119,000 59,542 50.04%
Sales Tax 1,768,275 457,535 1,842,411 1,859,375 (16,964) -0.91%
OPERATING REVENUES Total 1,808,575 472,029 2,020,953 1,978,375 42,578 2.15%
OPERATING EXPENDITURES
Joint Services Allocation 238,622 19,885 238,622 238,622 - -
Miscellaneous Expense 50 - - 50 50 100.00%
Promotional & Marketing Program 100,000 14,997 97,324 100,000 2,676 2.68%
Special Services 30,000 12,493 12,843 30,000 17,157 57.19%
Travel & Training 500 - - - - -
OPERATING EXPENDITURES Total 369,172 47,375 348,789 368,672 19,883 5.39%
TOTAL NET OPERATIONS 1,439,403 424,654 1,672,164 1,609,703 (62,462) -3.88%
NON-OPERATING EXPENDITURES
Principal Reduction 80,568 80,568 80,568 80,568 - -
Debt Service 205,069 120 205,189 205,069 (120) -0.06%
Interest Expense 23,157 23,157 23,157 23,157 - -
Atmos Energy 146,096 - 151 225,000 224,849 99.93%
DisperSol 50,000 - 30,000 30,000 - -
Economic Development Projects -Undetermined 7,000,517 - - - - -
Holt Cat 185,000 - - - - -
Radiation Detection Company 150,000 - - - - -
NON-OPERATING EXPENDITURES Total 7,840,407 103,845 339,065 563,794 224,729 39.86%
TOTAL NET NON-OPERATIONS (7,840,407) (103,845) (339,065) (563,794) (224,729) 39.86%
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL
REQUIREMENTS (6,401,004) 320,809 1,333,099 1,045,909 287,190 27.46%
ENDING FUND BALANCE 452,069 8,305,736 8,018,546 287,190 3.58%
RESERVES
Contingency 442,069 442,069 442,069
Reserves Total 442,069 442,069 442,069
AVAILABLE FUND BALANCE 10,000 7,863,667 7,576,477 287,190 3.79%
Georgetown Economic Development Corporation Fund
Preliminary Actuals to Year-End Projection: Sep FY2019
17
FYE Results by Investment Category:
Asset Type Ave. Yield Book Value Market Value Ave. Yield Book Value Market Value
Demand Accounts 0.34% 12,430,730$ 12,430,730$ 0.52% 6,140,421$ 6,140,421$
NOW/MMA 2.33% 10,191,154 10,191,154 2.21% 20,080,071 20,080,071
Pools 2.00% 48,966,731 48,966,731 2.12% 80,054,900 80,054,900
CDs/Securities 2.28% 108,457,058 108,455,269 2.65% 72,607,471 72,611,429
Totals 180,045,674$ 180,043,885$ 178,882,862$178,886,821$
Fourth Quarter-End Yield 2.07%2.29%
Average Quarter-End Yields (1):
2018 Fiscal Year 2019 Fiscal Year
Georgetown-City 1.30%2.36%
Rolling Three Month Treasury 1.23%2.30%
Rolling Six Month Treasury 1.26%2.37%
TexPool 1.18%2.31%
(1)Average Quarterly Yield calculated using quarter-end report average yield and adjusted book value.
September 30, 2018
Annual Comparison of Portfolio Performance
September 30, 2019
Valley View Consulting, L.L.C.Page 1.19
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Demand Accounts 5,585,797$ 5,585,797 6,140,421$ 6,140,421$ 0.52%
NOW/MMA 10,387,689 10,387,689 20,080,071 20,080,071 2.21%
Pools 95,580,912 95,580,912 80,054,900 80,054,900 2.12%
CDs/Securities 93,415,689 93,422,519 72,607,471 72,611,429 2.65%
Totals 204,970,088$ 204,976,917$ 178,882,862$ 178,886,821$
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 2.29%Total Portfolio 2.36%
Rolling Three Month Treasury 2.02%Rolling Three Month Treasury 2.30%
Rolling Six Month Treasury 2.17%Rolling Six Month Treasury 2.37%
TexPool 2.16%TexPool 2.31%
Bank Fees Offset
9,926$
Interest income provided in separate report.51,762$
June 30, 2019
(1) 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.
(2) Fiscal Year-to-Date Average Yields calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or
account for advisory fees.
Quarterly Bank Fees Offset
Year-to-date Bank Fees Offset
September 30, 2019
Valley View Consulting, L.L.C.
Page 2.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.52% 10/01/19 09/30/19 6,140,421$ 6,140,421$ 1.00 6,140,421$ 1 0.52%
Veritex Bank MMA 2.25% 10/01/19 09/30/19 3,176,587 3,176,587 1.00 3,176,587 1 2.25%
NexBank MMA 2.15% 10/01/19 09/30/19 7,275,059 7,275,059 1.00 7,275,059 1 2.15%
Origin Bank MMA 2.25% 10/01/19 09/30/19 9,628,425 9,628,425 1.00 9,628,425 1 2.25%
TexPool AAAm 2.16% 10/01/19 09/30/19 19,406,369 19,406,369 1.00 19,406,369 1 2.16%
TexSTAR AAAm 2.11% 10/01/19 09/30/19 60,648,531 60,648,531 1.00 60,648,531 1 2.11%
LegacyTexas Bank CD 2.84% 10/23/19 10/23/18 4,105,507 4,105,507 100.00 4,105,507 23 2.88%
T-Bill Aaa/AA+2.43% 11/07/19 02/07/19 5,000,000 4,987,201 99.82 4,991,160 38 2.51%
Southside Bank CD 2.76% 11/19/19 11/19/18 3,194,266 3,194,266 100.00 3,194,266 50 2.76%
R Bank CD 2.55% 12/07/19 06/07/19 2,012,896 2,012,896 100.00 2,012,896 68 2.58%
WallisBank CD 2.77% 01/03/20 01/04/19 3,041,365 3,041,365 100.00 3,041,365 95 2.80%
Independent Bank CD 2.88% 02/03/20 08/03/18 5,145,563 5,145,563 100.00 5,145,563 126 2.91%
East West Bank CD 2.25% 02/03/20 08/02/19 4,466,489 4,466,489 100.00 4,466,489 126 2.28%
BBVA Bank CD 2.25% 02/03/20 08/02/19 2,003,825 2,003,825 100.00 2,003,825 126 2.28%
R Bank CD 2.89% 02/15/20 02/15/19 6,086,603 6,086,603 100.00 6,086,603 138 2.93%
R Bank CD 2.15% 02/16/20 08/16/19 1,000,000 1,000,000 100.00 1,000,000 139 2.17%
Southside Bank CD 2.65% 03/13/20 03/13/19 6,080,421 6,080,421 100.00 6,080,421 165 2.68%
East West Bank CD 2.62% 04/01/20 04/01/19 5,183,750 5,183,750 100.00 5,183,750 184 2.65%
LegacyTexas Bank CD 2.91% 05/06/20 11/06/18 4,098,011 4,098,011 100.00 4,098,011 219 2.95%
Southside Bank CD 2.47% 05/11/20 05/10/19 3,018,677 3,018,677 100.00 3,018,677 224 2.49%
BBVA Bank CD 2.51% 06/20/20 06/20/19 4,025,386 4,025,386 100.00 4,025,386 264 2.54%
East West Bank CD 2.48% 07/15/20 04/15/19 5,057,743 5,057,743 100.00 5,057,743 289 2.51%
R Bank CD 2.10% 08/16/20 08/16/19 2,000,000 2,000,000 100.00 2,000,000 321 2.12%
LegacyTexas Bank CD 2.66% 08/21/20 02/22/19 6,093,315 6,093,315 100.00 6,093,315 326 2.69%
Independent Bank CD 2.56% 11/10/20 05/10/19 1,006,453 1,006,453 100.00 1,006,453 407 2.58%
178,895,661$ 178,882,862$ 178,886,821$702.29%
(1) (2)
September 30, 2019
(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.
Valley View Consulting, L.L.C.Page 4.22
City - Book Value Comparison
Coupon/ Maturity Face Amount/Purchases/ Sales/Adjust/ Face Amount/
Description Discount Date Par Value Book Value Adjustments Call/Maturity Par Value Book Value
JPMorgan Chase Cash 0.52% 10/01/19 5,585,797$ 5,585,797$ 554,623$ –$ 6,140,421$ 6,140,421$
Veritex Bank MMA 2.25% 10/01/19 3,157,291 3,157,291 19,297 3,176,587 3,176,587
NexBank MMA 2.15% 10/01/19 7,230,398 7,230,398 44,660 7,275,059 7,275,059
Origin Bank MMA 2.25% 10/01/19 – – 9,628,425 9,628,425 9,628,425
TexPool 2.16% 10/01/19 14,288,253 14,288,253 5,118,115 19,406,369 19,406,369
TexSTAR 2.11% 10/01/19 81,292,659 81,292,659 (20,644,127) 60,648,531 60,648,531
East West Bank CD 2.20%08/01/19 3,089,921 3,089,921 (3,089,921)– –
BTH Bank CD 2.58%08/03/19 3,065,092 3,065,092 (3,065,092)– –
Independent Bank CD 2.75%08/03/19 18,372,777 18,372,777 (18,372,777)– –
East West Bank CD 2.66%08/06/19 1,010,623 1,010,623 (1,010,623)– –
East West Bank CD 2.70%08/13/19 6,144,625 6,144,625 (6,144,625)– –
Origin Bank CD 2.72%08/13/19 3,019,897 3,019,897 (3,019,897)– –
LegacyTexas Bank CD 2.84%10/23/19 4,076,258 4,076,258 29,249 4,105,507 4,105,507
T-Bill 2.43%11/07/19 5,000,000 4,956,215 30,986 5,000,000 4,987,201
Southside Bank CD 2.76%11/19/19 3,172,198 3,172,198 22,068 3,194,266 3,194,266
R Bank CD 2.55%12/07/19 2,000,000 2,000,000 12,896 2,012,896 2,012,896
WallisBank CD 2.77%01/03/20 3,020,498 3,020,498 20,867 3,041,365 3,041,365
Independent Bank CD 2.88%02/03/20 5,108,479 5,108,479 37,083 5,145,563 5,145,563
East West Bank CD 2.25%02/03/20 – – 4,466,489 4,466,489 4,466,489
BBVA Bank CD 2.25%02/03/20 – – 2,003,825 2,003,825 2,003,825
R Bank CD 2.89%02/15/20 6,042,429 6,042,429 44,174 6,086,603 6,086,603
R Bank CD 2.15%02/16/20 – – 1,000,000 1,000,000 1,000,000
Southside Bank CD 2.65%03/13/20 6,040,077 6,040,077 40,344 6,080,421 6,080,421
East West Bank CD 2.62%04/01/20 5,149,632 5,149,632 34,119 5,183,750 5,183,750
LegacyTexas Bank CD 2.91%05/06/20 4,068,099 4,068,099 29,912 4,098,011 4,098,011
Southside Bank CD 2.47%05/11/20 3,000,000 3,000,000 18,677 3,018,677 3,018,677
BBVA Bank CD 2.51%06/20/20 – – 4,025,386 4,025,386 4,025,386
East West Bank CD 2.48%07/15/20 5,026,227 5,026,227 31,516 5,057,743 5,057,743
R Bank CD 2.10%08/16/20 – – 2,000,000 2,000,000 2,000,000
LegacyTexas Bank CD 2.66%08/21/20 6,052,643 6,052,643 40,672 6,093,315 6,093,315
Independent Bank CD 2.56%11/10/20 1,000,000 1,000,000 6,453 1,006,453 1,006,453
TOTAL 205,013,872$ 204,970,088$ 29,259,837$ (55,347,062)$ 178,895,661$ 178,882,862$
June 30, 2019 September 30, 2019
Valley View Consulting, L.L.C.Page 5.23
City - Market Value Comparison
Coupon/ Maturity Face Amount/ Qtr to Qtr Face Amount/
Description Discount Date Par Value Market Value Change Par Value Market Value
JPMorgan Chase Cash 0.52% 10/01/19 5,585,797$ 5,585,797$ 554,623$ 6,140,421$ 6,140,421$
Veritex Bank MMA 2.25% 10/01/19 3,157,291 3,157,291 19,297 3,176,587 3,176,587
NexBank MMA 2.15% 10/01/19 7,230,398 7,230,398 44,660 7,275,059 7,275,059
Origin Bank MMA 2.25% 10/01/19 – – 9,628,425 9,628,425 9,628,425
TexPool 2.16% 10/01/19 14,288,253 14,288,253 5,118,115 19,406,369 19,406,369
TexSTAR 2.11% 10/01/19 81,292,659 81,292,659 (20,644,127) 60,648,531 60,648,531
East West Bank CD 2.20% 08/01/19 3,089,921 3,089,921 (3,089,921)– –
BTH Bank CD 2.58% 08/03/19 3,065,092 3,065,092 (3,065,092)– –
Independent Bank CD 2.75% 08/03/19 18,372,777 18,372,777 (18,372,777)– –
East West Bank CD 2.66% 08/06/19 1,010,623 1,010,623 (1,010,623)– –
East West Bank CD 2.70% 08/13/19 6,144,625 6,144,625 (6,144,625)– –
Origin Bank CD 2.72% 08/13/19 3,019,897 3,019,897 (3,019,897)– –
LegacyTexas Bank CD 2.84% 10/23/19 4,076,258 4,076,258 29,249 4,105,507 4,105,507
T-Bill 2.43% 11/07/19 5,000,000 4,963,045 28,115 5,000,000 4,991,160
Southside Bank CD 2.76% 11/19/19 3,172,198 3,172,198 22,068 3,194,266 3,194,266
R Bank CD 2.55% 12/07/19 2,000,000 2,000,000 12,896 2,012,896 2,012,896
WallisBank CD 2.77% 01/03/20 3,020,498 3,020,498 20,867 3,041,365 3,041,365
Independent Bank CD 2.88% 02/03/20 5,108,479 5,108,479 37,083 5,145,563 5,145,563
East West Bank CD 2.25% 02/03/20 – – 4,466,489 4,466,489 4,466,489
BBVA Bank CD 2.25% 02/03/20 – – 2,003,825 2,003,825 2,003,825
R Bank CD 2.89% 02/15/20 6,042,429 6,042,429 44,174 6,086,603 6,086,603
R Bank CD 2.15% 02/16/20 – – 1,000,000 1,000,000 1,000,000
Southside Bank CD 2.65% 03/13/20 6,040,077 6,040,077 40,344 6,080,421 6,080,421
East West Bank CD 2.62% 04/01/20 5,149,632 5,149,632 34,119 5,183,750 5,183,750
LegacyTexas Bank CD 2.91% 05/06/20 4,068,099 4,068,099 29,912 4,098,011 4,098,011
Southside Bank CD 2.47% 05/11/20 3,000,000 3,000,000 18,677 3,018,677 3,018,677
BBVA Bank CD 2.51% 06/20/20 – – 4,025,386 4,025,386 4,025,386
East West Bank CD 2.48% 07/15/20 5,026,227 5,026,227 31,516 5,057,743 5,057,743
R Bank CD 2.10% 08/16/20 – – 2,000,000 2,000,000 2,000,000
LegacyTexas Bank CD 2.66% 08/21/20 6,052,643 6,052,643 40,672 6,093,315 6,093,315
Independent Bank CD 2.56% 11/10/20 1,000,000 1,000,000 6,453 1,006,453 1,006,453
TOTAL 205,013,872$ 204,976,917$ (26,090,096)$ 178,895,661$ 178,886,821$
September 30, 2019June 30, 2019
Valley View Consulting, L.L.C.Page 6.24
City - Allocation
Investment
Total Consolidated
2013 GO-
Parks/Public
Safety
2014 CO-
Downtown
Parks
2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
JPMorgan Chase Cash 6,140,421$ 6,140,421$ –$ –$ –$ –$ –$
Veritex Bank MMA 3,176,587 3,176,587 – – – – –
NexBank MMA 7,275,059 7,275,059 – – – – – Origin Bank MMA 9,628,425 4,011,844 – – – – –
TexPool 19,406,369 19,406,369 – – – – –
TexSTAR 60,648,531 9,570,642 157,987 59,667 944,180 1,985,069 121,638
LegacyTexas Bank CD 10/23/19 4,105,507 4,105,507 – – – – –
T-Bill 11/07/19 4,987,201 – – – – – –
Southside Bank CD 11/19/19 3,194,266 3,194,266 – – – – – R Bank CD 12/07/19 2,012,896 2,012,896 – – – – –
WallisBank CD 01/03/20 3,041,365 3,041,365 – – – – –
Independent Bank CD 02/03/20 5,145,563 3,069,396 – – – – –
East West Bank CD 02/03/20 4,466,489 – – – – – – BBVA Bank CD 02/03/20 2,003,825 – – – – – –
R Bank CD 02/15/20 6,086,603 6,086,603 – – – – –
R Bank CD 02/16/20 1,000,000 – – – – – – Southside Bank CD 03/13/20 6,080,421 6,080,421 – – – – –
East West Bank CD 04/01/20 5,183,750 5,183,750 – – – – –
LegacyTexas Bank CD 05/06/20 4,098,011 4,098,011 – – – – –
Southside Bank CD 05/11/20 3,018,677 3,018,677 – – – – – BBVA Bank CD 06/20/20 4,025,386 4,025,386 – – – – –
East West Bank CD 07/15/20 5,057,743 5,057,743 – – – – –
R Bank CD 08/16/20 2,000,000 – – – – – – LegacyTexas Bank CD 08/21/20 6,093,315 6,093,315 – – – – –
Independent Bank CD 11/10/20 1,006,453 1,006,453 – – – – –
Totals 178,882,862$ 105,654,710$ 157,987$ 59,667$ 944,180$ 1,985,069$ 121,638$
Book Value
September 30, 2019
Valley View Consulting, L.L.C.Page 8.26
City - Allocation
JPMorgan Chase Cash
Veritex Bank MMA
NexBank MMAOrigin Bank MMA
TexPool
TexSTAR
LegacyTexas Bank CD 10/23/19
T-Bill 11/07/19
Southside Bank CD 11/19/19R Bank CD 12/07/19
WallisBank CD 01/03/20
Independent Bank CD 02/03/20
East West Bank CD 02/03/20BBVA Bank CD 02/03/20
R Bank CD 02/15/20
R Bank CD 02/16/20Southside Bank CD 03/13/20
East West Bank CD 04/01/20
LegacyTexas Bank CD 05/06/20
Southside Bank CD 05/11/20BBVA Bank CD 06/20/20
East West Bank CD 07/15/20
R Bank CD 08/16/20LegacyTexas Bank CD 08/21/20
Independent Bank CD 11/10/20
Totals
Book Value
September 30, 2019
(Continued)
2015 CO-
Stormwater
2015 CO-
Water
2015 GO-
Roads
2015 Revenue
Water WW
2016 CO-
Rivery TIRZ
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
610,175 14,428 2,486,163 999,652 4,330 55,861 1,512,621
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – 532,498 – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
610,175$ 14,428$ 2,486,163$ 1,532,149$ 4,330$ 55,861$ 1,512,621$
Valley View Consulting, L.L.C.Page 9.27
City - Allocation
JPMorgan Chase Cash
Veritex Bank MMA
NexBank MMAOrigin Bank MMA
TexPool
TexSTAR
LegacyTexas Bank CD 10/23/19
T-Bill 11/07/19
Southside Bank CD 11/19/19R Bank CD 12/07/19
WallisBank CD 01/03/20
Independent Bank CD 02/03/20
East West Bank CD 02/03/20BBVA Bank CD 02/03/20
R Bank CD 02/15/20
R Bank CD 02/16/20Southside Bank CD 03/13/20
East West Bank CD 04/01/20
LegacyTexas Bank CD 05/06/20
Southside Bank CD 05/11/20BBVA Bank CD 06/20/20
East West Bank CD 07/15/20
R Bank CD 08/16/20LegacyTexas Bank CD 08/21/20
Independent Bank CD 11/10/20
Totals
Book Value
September 30, 2019
(Continued)
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 GO-
Parks
2017 GO-
Sidewalks
2017 Revenue
Electric
2017 Revenue
Water WW
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
2,065,612 385,898 193,554 75,482 943,007 96,503 7,444,101
– – – – – – –
– – – – – – 4,987,201
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – –
– – – – – – 1,000,000 – – – – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – 2,000,000 – – – – – – –
– – – – – – –
2,065,612$ 385,898$ 193,554$ 75,482$ 943,007$ 96,503$ 15,431,302$
Valley View Consulting, L.L.C.Page 10.28
City - Allocation
JPMorgan Chase Cash
Veritex Bank MMA
NexBank MMAOrigin Bank MMA
TexPool
TexSTAR
LegacyTexas Bank CD 10/23/19
T-Bill 11/07/19
Southside Bank CD 11/19/19R Bank CD 12/07/19
WallisBank CD 01/03/20
Independent Bank CD 02/03/20
East West Bank CD 02/03/20BBVA Bank CD 02/03/20
R Bank CD 02/15/20
R Bank CD 02/16/20Southside Bank CD 03/13/20
East West Bank CD 04/01/20
LegacyTexas Bank CD 05/06/20
Southside Bank CD 05/11/20BBVA Bank CD 06/20/20
East West Bank CD 07/15/20
R Bank CD 08/16/20LegacyTexas Bank CD 08/21/20
Independent Bank CD 11/10/20
Totals
Book Value
September 30, 2019
(Continued)
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2018 Revenue
Electric
2019 CO-
Airport
2019 CO-
Streets/
Facilities/
Equip
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – – – – – – – – 4,663,768
– – – – – – –
154,588 2,769,635 1,127,886 12,084,681 1,525,298 1,070 9,471,437
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– 1,025,524 518,145 – – – –
– – – – – – 3,462,784 – – – 2,003,825 – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
154,588$ 3,795,159$ 1,646,031$ 14,088,506$ 1,525,298$ 1,070$ 17,597,989$
Valley View Consulting, L.L.C.Page 11.29
City - Allocation
JPMorgan Chase Cash
Veritex Bank MMA
NexBank MMAOrigin Bank MMA
TexPool
TexSTAR
LegacyTexas Bank CD 10/23/19
T-Bill 11/07/19
Southside Bank CD 11/19/19R Bank CD 12/07/19
WallisBank CD 01/03/20
Independent Bank CD 02/03/20
East West Bank CD 02/03/20BBVA Bank CD 02/03/20
R Bank CD 02/15/20
R Bank CD 02/16/20Southside Bank CD 03/13/20
East West Bank CD 04/01/20
LegacyTexas Bank CD 05/06/20
Southside Bank CD 05/11/20BBVA Bank CD 06/20/20
East West Bank CD 07/15/20
R Bank CD 08/16/20LegacyTexas Bank CD 08/21/20
Independent Bank CD 11/10/20
Totals
Book Value
September 30, 2019
(Continued)
2018 CO-
Stormwater
2018 GO-
Roads
–$ –$
– –
– – – 952,813
– –
721,434 3,065,932
– –
– –
– – – –
– –
– –
– 1,003,705
– –
– –
– – – –
– –
– –
– – – –
– –
– – – –
– –
721,434$ 5,022,450$
Valley View Consulting, L.L.C.Page 12.30
City - Allocation
September 30, 2019
Market Value Investment
Total Consolidated
2013 GO-
Parks/Public
Safety
2014 CO-
Downtown
Parks
2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
JPMorgan Chase Cash 6,140,421$ 6,140,421$ –$ –$ –$ –$
Veritex Bank MMA 3,176,587 3,176,587 – – – – –
NexBank MMA 7,275,059 7,275,059 – – – – –
Origin Bank MMA 9,628,425 4,011,844 – – – – – TexPool 19,406,369 19,406,369 – – – – –
TexSTAR 60,648,531 9,570,642 157,987 59,667 944,180 1,985,069 121,638
LegacyTexas Bank CD 10/23/19 4,105,507 4,105,507 – – – – –
T-Bill 11/07/19 4,991,160 – – – – – –
Southside Bank CD 11/19/19 3,194,266 3,194,266 – – – – –
R Bank CD 12/07/19 2,012,896 2,012,896 – – – – – WallisBank CD 01/03/20 3,041,365 3,041,365 – – – – –
Independent Bank CD 02/03/20 5,145,563 3,069,396 – – – – –
East West Bank CD 02/03/20 4,466,489 – – – – – –
BBVA Bank CD 02/03/20 2,003,825 – – – – – – R Bank CD 02/15/20 6,086,603 6,086,603 – – – – –
R Bank CD 02/16/20 1,000,000 – – – – – –
Southside Bank CD 03/13/20 6,080,421 6,080,421 – – – – – East West Bank CD 04/01/20 5,183,750 5,183,750 – – – – –
LegacyTexas Bank CD 05/06/20 4,098,011 4,098,011 – – – – –
Southside Bank CD 05/11/20 3,018,677 3,018,677 – – – – –
BBVA Bank CD 06/20/20 4,025,386 4,025,386 – – – – – East West Bank CD 07/15/20 5,057,743 5,057,743 – – – – –
R Bank CD 08/16/20 2,000,000 – – – – – –
LegacyTexas Bank CD 08/21/20 6,093,315 6,093,315 – – – – – Independent Bank CD 11/10/20 1,006,453 1,006,453 – – – – –
Totals 178,886,821$ 105,654,710$ 157,987$ 59,667$ 944,180$ 1,985,069$ 121,638$
Valley View Consulting, L.L.C.Page 13.31
City - Allocation
September 30, 2019
Market Value
JPMorgan Chase Cash
Veritex Bank MMA
NexBank MMA
Origin Bank MMATexPool
TexSTAR
LegacyTexas Bank CD 10/23/19
T-Bill 11/07/19
Southside Bank CD 11/19/19
R Bank CD 12/07/19WallisBank CD 01/03/20
Independent Bank CD 02/03/20
East West Bank CD 02/03/20
BBVA Bank CD 02/03/20R Bank CD 02/15/20
R Bank CD 02/16/20
Southside Bank CD 03/13/20East West Bank CD 04/01/20
LegacyTexas Bank CD 05/06/20
Southside Bank CD 05/11/20
BBVA Bank CD 06/20/20East West Bank CD 07/15/20
R Bank CD 08/16/20
LegacyTexas Bank CD 08/21/20Independent Bank CD 11/10/20
Totals
(Continued)
2015 CO-
Stormwater
2015 CO-
Water
2015 GO-
Roads
2015 Revenue
Water WW
2016 CO-
Rivery TIRZ
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
610,175 14,428 2,486,163 999,652 4,330 55,861 1,512,621
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – 532,498 – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
610,175$ 14,428$ 2,486,163$ 1,532,149$ 4,330$ 55,861$ 1,512,621$
Valley View Consulting, L.L.C.Page 14.32
City - Allocation
September 30, 2019
Market Value
JPMorgan Chase Cash
Veritex Bank MMA
NexBank MMA
Origin Bank MMATexPool
TexSTAR
LegacyTexas Bank CD 10/23/19
T-Bill 11/07/19
Southside Bank CD 11/19/19
R Bank CD 12/07/19WallisBank CD 01/03/20
Independent Bank CD 02/03/20
East West Bank CD 02/03/20
BBVA Bank CD 02/03/20R Bank CD 02/15/20
R Bank CD 02/16/20
Southside Bank CD 03/13/20East West Bank CD 04/01/20
LegacyTexas Bank CD 05/06/20
Southside Bank CD 05/11/20
BBVA Bank CD 06/20/20East West Bank CD 07/15/20
R Bank CD 08/16/20
LegacyTexas Bank CD 08/21/20Independent Bank CD 11/10/20
Totals
(Continued)
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 GO-
Parks
2017 GO-
Sidewalks
2017 Revenue
Electric
2017 Revenue
Water WW
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
2,065,612 385,898 193,554 75,482 943,007 96,503 7,444,101
– – – – – – –
– – – – – – 4,991,160
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – 1,000,000
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – 2,000,000
– – – – – – – – – – – – – –
2,065,612$ 385,898$ 193,554$ 75,482$ 943,007$ 96,503$ 15,435,261$
Valley View Consulting, L.L.C.Page 15.33
City - Allocation
September 30, 2019
Market Value
JPMorgan Chase Cash
Veritex Bank MMA
NexBank MMA
Origin Bank MMATexPool
TexSTAR
LegacyTexas Bank CD 10/23/19
T-Bill 11/07/19
Southside Bank CD 11/19/19
R Bank CD 12/07/19WallisBank CD 01/03/20
Independent Bank CD 02/03/20
East West Bank CD 02/03/20
BBVA Bank CD 02/03/20R Bank CD 02/15/20
R Bank CD 02/16/20
Southside Bank CD 03/13/20East West Bank CD 04/01/20
LegacyTexas Bank CD 05/06/20
Southside Bank CD 05/11/20
BBVA Bank CD 06/20/20East West Bank CD 07/15/20
R Bank CD 08/16/20
LegacyTexas Bank CD 08/21/20Independent Bank CD 11/10/20
Totals
(Continued)
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2018 Revenue
Electric
2019 CO-
Airport
2019 CO-
Streets/
Facilities/
Equip
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – 4,663,768 – – – – – – –
154,588 2,769,635 1,127,886 12,084,681 1,525,298 1,070 9,471,437
– – – – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– 1,025,524 518,145 – – – –
– – – – – – 3,462,784
– – – 2,003,825 – – – – – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
154,588$ 3,795,159$ 1,646,031$ 14,088,506$ 1,525,298$ 1,070$ 17,597,989$
Valley View Consulting, L.L.C.Page 16.34
City - Allocation
September 30, 2019
Market Value
JPMorgan Chase Cash
Veritex Bank MMA
NexBank MMA
Origin Bank MMATexPool
TexSTAR
LegacyTexas Bank CD 10/23/19
T-Bill 11/07/19
Southside Bank CD 11/19/19
R Bank CD 12/07/19WallisBank CD 01/03/20
Independent Bank CD 02/03/20
East West Bank CD 02/03/20
BBVA Bank CD 02/03/20R Bank CD 02/15/20
R Bank CD 02/16/20
Southside Bank CD 03/13/20East West Bank CD 04/01/20
LegacyTexas Bank CD 05/06/20
Southside Bank CD 05/11/20
BBVA Bank CD 06/20/20East West Bank CD 07/15/20
R Bank CD 08/16/20
LegacyTexas Bank CD 08/21/20Independent Bank CD 11/10/20
Totals
(Continued)
2018 CO-
Stormwater
2018 GO-
Roads
–$ –$
– –
– –
– 952,813 – –
721,434 3,065,932
– –
– –
– –
– – – –
– –
– 1,003,705
– –
– –
– –
– – – –
– –
– –
– – – –
– –
– – – –
721,434$ 5,022,450$
Valley View Consulting, L.L.C.Page 17.35
City - Allocation
Investment
Total Consolidated
2013 GO-
Parks/Public
Safety
2014 CO-
Downtown
Parks
2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
JPMorgan Chase Cash 5,585,797$ 5,585,797$ –$ –$ –$ –$ –$
Veritex Bank MMA 3,157,291 3,157,291 – – – – –
NexBank MMA 7,230,398 7,230,398 – – – – – TexPool 14,288,253 14,288,253 – – – – –
TexSTAR 81,292,659 17,498,406 157,111 59,336 1,617,652 14,986,361 189,283
East West Bank CD 08/01/19 3,089,921 3,089,921 – – – – –
BTH Bank CD 08/03/19 3,065,092 – – – – – –
Independent Bank CD 08/03/19 18,372,777 – – – – – –
East West Bank CD 08/06/19 1,010,623 – – – – – – East West Bank CD 08/13/19 6,144,625 6,144,625 – – – – –
Origin Bank CD 08/13/19 3,019,897 – – – – – –
LegacyTexas Bank CD 10/23/19 4,076,258 4,076,258 – – – – –
T-Bill 11/07/19 4,956,215 – – – – – – Southside Bank CD 11/19/19 3,172,198 3,172,198 – – – – –
R Bank CD 12/07/19 2,000,000 2,000,000 – – – – –
WallisBank CD 01/03/20 3,020,498 3,020,498 – – – – – Independent Bank CD 02/03/20 5,108,479 3,047,276 – – – – –
R Bank CD 02/15/20 6,042,429 6,042,429 – – – – –
Southside Bank CD 03/13/20 6,040,077 6,040,077 – – – – –
East West Bank CD 04/01/20 5,149,632 5,149,632 – – – – – LegacyTexas Bank CD 05/06/20 4,068,099 4,068,099 – – – – –
Southside Bank CD 05/11/20 3,000,000 3,000,000 – – – – –
East West Bank CD 07/15/20 5,026,227 5,026,227 – – – – – LegacyTexas Bank CD 08/21/20 6,052,643 6,052,643 – – – – –
Independent Bank CD 11/10/20 1,000,000 1,000,000 – – – – –
Totals 204,970,088$ 108,690,028$ 157,111$ 59,336$ 1,617,652$ 14,986,361$ 189,283$
June 30, 2019
Book Value
Valley View Consulting, L.L.C.Page 18.36
City - Allocation
JPMorgan Chase Cash
Veritex Bank MMA
NexBank MMATexPool
TexSTAR
East West Bank CD 08/01/19
BTH Bank CD 08/03/19
Independent Bank CD 08/03/19
East West Bank CD 08/06/19East West Bank CD 08/13/19
Origin Bank CD 08/13/19
LegacyTexas Bank CD 10/23/19
T-Bill 11/07/19Southside Bank CD 11/19/19
R Bank CD 12/07/19
WallisBank CD 01/03/20Independent Bank CD 02/03/20
R Bank CD 02/15/20
Southside Bank CD 03/13/20
East West Bank CD 04/01/20LegacyTexas Bank CD 05/06/20
Southside Bank CD 05/11/20
East West Bank CD 07/15/20LegacyTexas Bank CD 08/21/20
Independent Bank CD 11/10/20
Totals
June 30, 2019
Book Value
(Continued)
2015 CO-
Stormwater
2015 CO-
Water
2015 GO-
Roads
2015 Revenue
Water WW
2016 CO-
Rivery TIRZ
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – – – – – – – – –
629,787 14,348 2,472,379 10,949 4,306 55,551 1,525,813
– – – – – – –
– – – – – – –
– – – 1,020,710 – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – – – – – 528,660 – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
629,787$ 14,348$ 2,472,379$ 1,560,318$ 4,306$ 55,551$ 1,525,813$
Valley View Consulting, L.L.C.Page 19.37
City - Allocation
JPMorgan Chase Cash
Veritex Bank MMA
NexBank MMATexPool
TexSTAR
East West Bank CD 08/01/19
BTH Bank CD 08/03/19
Independent Bank CD 08/03/19
East West Bank CD 08/06/19East West Bank CD 08/13/19
Origin Bank CD 08/13/19
LegacyTexas Bank CD 10/23/19
T-Bill 11/07/19Southside Bank CD 11/19/19
R Bank CD 12/07/19
WallisBank CD 01/03/20Independent Bank CD 02/03/20
R Bank CD 02/15/20
Southside Bank CD 03/13/20
East West Bank CD 04/01/20LegacyTexas Bank CD 05/06/20
Southside Bank CD 05/11/20
East West Bank CD 07/15/20LegacyTexas Bank CD 08/21/20
Independent Bank CD 11/10/20
Totals
June 30, 2019
Book Value
(Continued)
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 GO-
Parks
2017 GO-
Sidewalks
2017 Revenue
Electric
2017 Revenue
Water WW
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – – – – – – – – –
931,743 385,940 334,995 75,064 1,243,158 95,968 4,648,515
– – – – – – –
– – – – – – 3,065,092
4,082,839 – – – – – –
– – – – – – – – – – – – – –
– – – – – – 3,019,897
– – – – – – –
– – – – – – 4,956,215 – – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
5,014,582$ 385,940$ 334,995$ 75,064$ 1,243,158$ 95,968$ 15,689,718$
Valley View Consulting, L.L.C.Page 20.38
City - Allocation
JPMorgan Chase Cash
Veritex Bank MMA
NexBank MMATexPool
TexSTAR
East West Bank CD 08/01/19
BTH Bank CD 08/03/19
Independent Bank CD 08/03/19
East West Bank CD 08/06/19East West Bank CD 08/13/19
Origin Bank CD 08/13/19
LegacyTexas Bank CD 10/23/19
T-Bill 11/07/19Southside Bank CD 11/19/19
R Bank CD 12/07/19
WallisBank CD 01/03/20Independent Bank CD 02/03/20
R Bank CD 02/15/20
Southside Bank CD 03/13/20
East West Bank CD 04/01/20LegacyTexas Bank CD 05/06/20
Southside Bank CD 05/11/20
East West Bank CD 07/15/20LegacyTexas Bank CD 08/21/20
Independent Bank CD 11/10/20
Totals
June 30, 2019
Book Value
(Continued)
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2018 Revenue
Electric
2019 CO-
Airport
2019 CO-
Streets/
Facilities/
Equip
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – – – – – – – – –
153,731 509,167 741,707 5,312,952 2,301,797 1,064 19,208,081
– – – – – – –
– – – – – – –
– 3,368,342 1,020,710 8,880,175 – – –
– – – 1,010,623 – – – – – – – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – – – 1,018,133 514,410 – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
153,731$ 4,895,643$ 2,276,828$ 15,203,750$ 2,301,797$ 1,064$ 19,208,081$
Valley View Consulting, L.L.C.Page 21.39
City - Allocation
JPMorgan Chase Cash
Veritex Bank MMA
NexBank MMATexPool
TexSTAR
East West Bank CD 08/01/19
BTH Bank CD 08/03/19
Independent Bank CD 08/03/19
East West Bank CD 08/06/19East West Bank CD 08/13/19
Origin Bank CD 08/13/19
LegacyTexas Bank CD 10/23/19
T-Bill 11/07/19Southside Bank CD 11/19/19
R Bank CD 12/07/19
WallisBank CD 01/03/20Independent Bank CD 02/03/20
R Bank CD 02/15/20
Southside Bank CD 03/13/20
East West Bank CD 04/01/20LegacyTexas Bank CD 05/06/20
Southside Bank CD 05/11/20
East West Bank CD 07/15/20LegacyTexas Bank CD 08/21/20
Independent Bank CD 11/10/20
Totals
June 30, 2019
Book Value
(Continued)
2018 CO-
Stormwater
2018 GO-
Roads
–$ –$
– –
– – – –
782,294 5,345,200
– –
– –
– –
– – – –
– –
– –
– –
– –
– –
– – – –
– –
– –
– – – –
– –
– – – –
– –
782,294$ 5,345,200$
Valley View Consulting, L.L.C.Page 22.40
City - Allocation
June 30, 2019
Market Value Investment
Total Consolidated
2013 GO-
Parks/Public
Safety
2014 CO-
Downtown
Parks
2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
JPMorgan Chase Cash 5,585,797$ 5,585,797$ –$ –$ –$ –$
Veritex Bank MMA 3,157,291 3,157,291 – – – – –
NexBank MMA 7,230,398 7,230,398 – – – – –
TexPool 14,288,253 14,288,253 – – – – – TexSTAR 81,292,659 17,498,406 157,111 59,336 1,617,652 14,986,361 189,283
East West Bank CD 08/01/19 3,089,921 3,089,921 – – – – –
BTH Bank CD 08/03/19 3,065,092 – – – – – –
Independent Bank CD 08/03/19 18,372,777 – – – – – –
East West Bank CD 08/06/19 1,010,623 – – – – – –
East West Bank CD 08/13/19 6,144,625 6,144,625 – – – – – Origin Bank CD 08/13/19 3,019,897 – – – – – –
LegacyTexas Bank CD 10/23/19 4,076,258 4,076,258 – – – – –
T-Bill 11/07/19 4,963,045 – – – – – –
Southside Bank CD 11/19/19 3,172,198 3,172,198 – – – – – R Bank CD 12/07/19 2,000,000 2,000,000 – – – – –
WallisBank CD 01/03/20 3,020,498 3,020,498 – – – – –
Independent Bank CD 02/03/20 5,108,479 3,047,276 – – – – – R Bank CD 02/15/20 6,042,429 6,042,429 – – – – –
Southside Bank CD 03/13/20 6,040,077 6,040,077 – – – – –
East West Bank CD 04/01/20 5,149,632 5,149,632 – – – – –
LegacyTexas Bank CD 05/06/20 4,068,099 4,068,099 – – – – – Southside Bank CD 05/11/20 3,000,000 3,000,000 – – – – –
East West Bank CD 07/15/20 5,026,227 5,026,227 – – – – –
LegacyTexas Bank CD 08/21/20 6,052,643 6,052,643 – – – – – Independent Bank CD 11/10/20 1,000,000 1,000,000 – – – – –
Totals 204,976,917$ 108,690,028$ 157,111$ 59,336$ 1,617,652$ 14,986,361$ 189,283$
Valley View Consulting, L.L.C.Page 23.41
City - Allocation
June 30, 2019
Market Value
JPMorgan Chase Cash
Veritex Bank MMA
NexBank MMA
TexPoolTexSTAR
East West Bank CD 08/01/19
BTH Bank CD 08/03/19
Independent Bank CD 08/03/19
East West Bank CD 08/06/19
East West Bank CD 08/13/19Origin Bank CD 08/13/19
LegacyTexas Bank CD 10/23/19
T-Bill 11/07/19
Southside Bank CD 11/19/19R Bank CD 12/07/19
WallisBank CD 01/03/20
Independent Bank CD 02/03/20R Bank CD 02/15/20
Southside Bank CD 03/13/20
East West Bank CD 04/01/20
LegacyTexas Bank CD 05/06/20Southside Bank CD 05/11/20
East West Bank CD 07/15/20
LegacyTexas Bank CD 08/21/20Independent Bank CD 11/10/20
Totals
(Continued)
2015 CO-
Stormwater
2015 CO-
Water
2015 GO-
Roads
2015 Revenue
Water WW
2016 CO-
Rivery TIRZ
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – – 629,787 14,348 2,472,379 10,949 4,306 55,551 1,525,813
– – – – – – –
– – – – – – –
– – – 1,020,710 – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – 528,660 – – – – – – – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
629,787$ 14,348$ 2,472,379$ 1,560,318$ 4,306$ 55,551$ 1,525,813$
Valley View Consulting, L.L.C.Page 24.42
City - Allocation
June 30, 2019
Market Value
JPMorgan Chase Cash
Veritex Bank MMA
NexBank MMA
TexPoolTexSTAR
East West Bank CD 08/01/19
BTH Bank CD 08/03/19
Independent Bank CD 08/03/19
East West Bank CD 08/06/19
East West Bank CD 08/13/19Origin Bank CD 08/13/19
LegacyTexas Bank CD 10/23/19
T-Bill 11/07/19
Southside Bank CD 11/19/19R Bank CD 12/07/19
WallisBank CD 01/03/20
Independent Bank CD 02/03/20R Bank CD 02/15/20
Southside Bank CD 03/13/20
East West Bank CD 04/01/20
LegacyTexas Bank CD 05/06/20Southside Bank CD 05/11/20
East West Bank CD 07/15/20
LegacyTexas Bank CD 08/21/20Independent Bank CD 11/10/20
Totals
(Continued)
2016 Revenue
Water/WW
Garey Park
Donation
2017 CO
Facilities/ Public
Safety/
Equipment
2017 GO-
Parks
2017 GO-
Sidewalks
2017 Revenue
Electric
2017 Revenue
Water WW
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – – 931,743 385,940 334,995 75,064 1,243,158 95,968 4,648,515
– – – – – – –
– – – – – – 3,065,092
4,082,839 – – – – – –
– – – – – – –
– – – – – – – – – – – – – 3,019,897
– – – – – – –
– – – – – – 4,963,045
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
5,014,582$ 385,940$ 334,995$ 75,064$ 1,243,158$ 95,968$ 15,696,548$
Valley View Consulting, L.L.C.Page 25.43
City - Allocation
June 30, 2019
Market Value
JPMorgan Chase Cash
Veritex Bank MMA
NexBank MMA
TexPoolTexSTAR
East West Bank CD 08/01/19
BTH Bank CD 08/03/19
Independent Bank CD 08/03/19
East West Bank CD 08/06/19
East West Bank CD 08/13/19Origin Bank CD 08/13/19
LegacyTexas Bank CD 10/23/19
T-Bill 11/07/19
Southside Bank CD 11/19/19R Bank CD 12/07/19
WallisBank CD 01/03/20
Independent Bank CD 02/03/20R Bank CD 02/15/20
Southside Bank CD 03/13/20
East West Bank CD 04/01/20
LegacyTexas Bank CD 05/06/20Southside Bank CD 05/11/20
East West Bank CD 07/15/20
LegacyTexas Bank CD 08/21/20Independent Bank CD 11/10/20
Totals
(Continued)
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
2018 GO-
Roads
2018 Revenue
Electric
2019 CO-
Airport
2019 CO-
Streets/
Facilities/
Equip
–$ –$ –$ –$ –$ –$ –$
– – – – – – –
– – – – – – –
– – – – – – – 153,731 509,167 741,707 5,312,952 2,301,797 1,064 19,208,081
– – – – – – –
– – – – – – –
– 3,368,342 1,020,710 8,880,175 – – –
– – – 1,010,623 – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– 1,018,133 514,410 – – – – – – – – – – –
– – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
– – – – – – –
– – – – – – – – – – – – – –
153,731$ 4,895,643$ 2,276,828$ 15,203,750$ 2,301,797$ 1,064$ 19,208,081$
Valley View Consulting, L.L.C.Page 26.44
City - Allocation
June 30, 2019
Market Value
JPMorgan Chase Cash
Veritex Bank MMA
NexBank MMA
TexPoolTexSTAR
East West Bank CD 08/01/19
BTH Bank CD 08/03/19
Independent Bank CD 08/03/19
East West Bank CD 08/06/19
East West Bank CD 08/13/19Origin Bank CD 08/13/19
LegacyTexas Bank CD 10/23/19
T-Bill 11/07/19
Southside Bank CD 11/19/19R Bank CD 12/07/19
WallisBank CD 01/03/20
Independent Bank CD 02/03/20R Bank CD 02/15/20
Southside Bank CD 03/13/20
East West Bank CD 04/01/20
LegacyTexas Bank CD 05/06/20Southside Bank CD 05/11/20
East West Bank CD 07/15/20
LegacyTexas Bank CD 08/21/20Independent Bank CD 11/10/20
Totals
(Continued)
2018 CO-
Stormwater
2018 GO-
Roads
–$ –$
– –
– –
– – 782,294 5,345,200
– –
– –
– –
– –
– – – –
– –
– –
– –
– –
– –
– – – –
– –
– –
– – – –
– –
– – – –
782,294$ 5,345,200$
Valley View Consulting, L.L.C.Page 27.45
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 120,110.95 50,000.00
Airport Federal Aviation Administration Texas Department of Transportation-Aviation 16MPGRGTN Airport Master Plan Update 5,870.00 5,870.00
Airport Federal Aviation
Administration
Texas Department of
Transportation-Aviation
1814GRGTN Runway 18/36 Rehabilitation-
Engineering
458,400.00 412,560.00
Airport Federal Aviation Administration Texas Department of Transportation-Aviation 1814GEORG Runway 18/36 Rehabilitation-Construction 4,298,372.42 3,868,535.18
Airport Federal Aviation Administration Texas Department of Transportation-Aviation 1914GEORG Taxiway Lighting Project -
-$
Fire US Department of Homeland Security Federal Emergency Management Agency EMW-2017-FH-00496 SAFER 474,551.90 355,627.84
Library Institute of Museum & Library Services Texas State Library & Archives Commission LS-00-18-0044-18 TSL Resource Coordinator - 3rd year (Patrick Lloyd)71,657.34 69,743.00
Planning US Department of Housing &
Urban Development
Williamson County B-17-UC-48-0502 CDBG Sidewalks and Ramps
along 17th St
19,760.00 19,760.00
Police Bureau of Justice Assistance N/A KXPIIIA Bullet Proof Vests - Supply
Police with new vests
3,560.85 1,780.44
Police US. Department of Justice N/A TX2460200 Equitable Sharing Agreement 30,808.54 40,228.65
Police US. Department of Treasury N/A TX2460200 Equitable Sharing Agreement 51,536.26 -
Public Works Dept. of Transportation
/Federal Highway
Administration
Texas Department of
Transportation
CSJ-0914-05-187 Highway Planning &
Construction (Austin Ave
Bridge)
89,033.08 -
Public Works Dept. of Transportation
/Federal Highway
Administration
Texas Department of
Transportation
CSJ-0914-05-200,201,202 Highway Planning &
Construction (Austin Ave
Bridge)
- -
Parks Texas Parks and Wildlife Department (TPWD)Federal Highway Administration RT017010 Recreation San Gabriel Trails $ 16,239.73 $-
Division Grantor Status
Gus - Electric Department of Energy (DOE)Battery Storage Project Pending discussion between Opus One and new Electric
Manager before taking to
council (as of 10/8/19)
Planning Williamson County/CDBG Home Repair No agreement with HUD until after 10/1/2019Planning Williamson County/CDBG Scenic Dr Sidewalk Alternate Project, likely will not be awarded.
CITY OF GEORGETOWN
Grant/Federal Funding Report
as of September 30, 2019
COG Name/Purpose
Active
Applications Pending Award
61
CIP Quarterly Report - Q4 FY2019 Budget
Year-todate
(W/Encum)Remaining Balance
AIRPORT OPERATIONS
600-5-0636-52-140 DESIGN RUNWAY REHAB 516,500 475,677 40,823
600-5-0636-52-141 HANGAR UPGRADES 75,000 75,000 -
600-5-0636-52-142 PAVEMENT UPGRADES 15,000 (10,744) 25,744
600-5-0636-52-145 WILDLIFE MANAGEMENT 35,000 31,801 3,199
600-5-0636-52-161 AIRPORT MASTER PLAN - 5,870 (5,870)
600-9-0636-52-144 TAXIWAY EDGE LIGHTING 150,000 - 150,000
AIRPORT OPERATIONS Total 791,500 577,605 213,895
CDBG GRANTS
215-9-0880-90-003 17TH STREET 206,824 23,830 182,994
215-9-0880-90-004 MAPLE STREET 80,784 - 80,784
CDBG GRANTS Total 287,608 23,830 263,778
DOWNTOWN TIRZ
293-9-0602-90-002 PARKING IMPROVEMENTS 106,902 830 106,072
293-9-0602-90-003 DTWN LANDSPING & PUBLC ART 45,000 79,205 (34,205)
293-9-0602-90-007 GRACE HERITAGE PLAZA 139,100 - 139,100
DOWNTOWN TIRZ Total 291,002 80,035 210,967
ELECTRIC SERVICES
610-9-0580-90-007 I35 MOBILITY TXDOT PROJECT - 4,450 (4,450)
610-9-0580-90-134 HWY 195 - 903 (903)
610-9-0580-90-137 RONALD REAGAN - 303 (303)
610-9-0580-90-142 DOWNTOWN WEST 227,536 100,888 126,648
610-9-0580-90-143 SHELL ROAD FEEDERS - 13,545 (13,545)
610-9-0580-90-256 GEO. EAST T2 VOLTAGE CHANGE 23,757 5,350 18,407
610-9-0580-90-260 DB WOOD_SH29 INTERSECTION 145,445 52,420 93,025
610-9-0580-90-263 LEANDER RD_IH35 INTERSECTION 10,000 - 10,000
610-9-0580-90-264 NORTHWEST BLVD WIDENING - (0) 0
610-9-0580-90-266 RIVERY EXTENSION 49,269 24,713 24,557
610-9-0580-90-267 UNIVERSITY_MAYS WIDENING 154,000 2,104 151,896
610-9-0580-90-310 POWER QUALITY IMPROVEMENTS 40,000 - 40,000
610-9-0580-90-320 SECTIONALIZATION IMPROVEMENTS 50,000 - 50,000
610-9-0580-90-350 RELOCATION PROJECTS REIMBURSED - 16,585 (16,585)
610-9-0580-90-410 NEW DEVELOPMENT PROJECTS 3,023,000 3,445,057 (422,057)
610-9-0580-90-430 STREET LIGHTING 44,000 226 43,774
610-9-0580-90-500 CONSULTANT ENGINEERING 150,000 158,916 (8,916)
610-9-0580-90-701 FIBER OPTIC 50,000 11,706 38,294
610-9-0580-90-702 FIBER TO SIGNAL LIGHTS 50,000 - 50,000
610-9-0580-91-105 CIS SYSTEM - 20,000 (20,000)
ELECTRIC SERVICES Total 4,017,007 3,857,165 159,842
GATEWAY TIRZ
295-9-0602-90-001 CAPITAL IMPROVEMENTS 120,000 - 120,000
GATEWAY TIRZ Total 120,000 - 120,000
GENERAL CAPITAL PROJECTS
120-9-0280-90-031 NEIGHBORHOOD PARK DEVELOPMENT 250,000 97,867 152,133
120-9-0280-90-035 VFW PARK 175,000 163,325 11,675
120-9-0280-90-045 SAN GABRIEL PARK IMPROVEMENT 834,288 532,381 301,907
120-9-0280-90-046 GAREY PARK 370,000 28,470 341,530
120-9-0280-90-047 SIDEWALKS 142,858 87,659 55,199
120-9-0280-90-051 LIBRARY CANOPY 75,934 75,934 0
120-9-0280-90-060 ADA PARKS 450,405 - 450,405
120-9-0280-90-066 KATY CROSSING TRAIL 240,313 - 240,313
120-9-0380-90-048 FIRE STATION ASSESSMENTS 30,000 30,000 -
120-9-0380-90-080 DOWNTOWN PARKING GARAGE 5,000,000 55,971 4,944,029
120-9-0380-90-159 FIRE STATION 7 6,471,601 5,405,623 1,065,978
120-9-0380-90-160 EOC SIREN SYSTEM 6,631 - 6,631
120-9-0380-90-163 FIRE STATION 6 5,499,725 4,834,842 664,883
120-9-0380-90-166 DATA CENTER - PSOTC 100,676 158,220 (57,544)
120-9-0380-90-168 TRANSFER STATION/LANDFILL 1,011,337 44,201 967,136
120-9-0380-90-169 ERP PROJECT 5,366,384 5,268,880 97,504
62
CIP Quarterly Report - Q4 FY2019 Budget
Year-todate
(W/Encum)Remaining Balance
120-9-0380-90-170 FACILITY EFFICIENCY STUDY 78,734 91,234 (12,500)
120-9-0381-90-022 RADIO REPLACEMENT PUB SAFETY 500,000 500,000 -
120-9-0381-91-016 FIRE SCBA 290,000 - 290,000
120-9-0381-91-022 RADIO REPLACEMENT 500,000 500,000 -
120-9-0680-90-008 CVB REDESIGN 175,000 - 175,000
120-9-0680-90-012 DOWNTOWN WEST 560,897 583,128 (22,231)
120-9-0680-90-013 DOWNTOWN WEST SIGNAGE 125,000 - 125,000
120-9-0680-90-014 DOWNTOWN PARKING EXPANSION 600,000 74,764 525,236
120-9-0880-90-038 LEANDER RD(NORWOOD-SWBYPASS)2,000,000 1,211,749 788,251
120-9-0880-90-041 BLUE HOLE PARKING LOT/SIDEWALK 100,000 - 100,000
120-9-0880-90-050 NB FRONTAGE RD 150,000 3 149,997
120-9-0880-90-054 AUSTIN AVENUE BRIDGE 238,132 155,161 82,971
120-9-0880-90-065 SOUTHWESTERN BLVD 1,550,000 509,485 1,040,515
120-9-0880-90-066 SHELL ROAD SIDEWALK 180,000 - 180,000
120-9-0880-90-086 SW BYPASS LEANDER TO I35 - (1,000) 1,000
120-9-0880-90-087 FM 971 3,900,000 18,665 3,881,335
120-9-0880-90-088 FM 1460 900,000 - 900,000
120-9-0880-90-091 SW BYPASS/WOLF RANCH PKWY 1,717,771 715,647 1,002,124
120-9-0880-90-092 SOUTHEAST INNER LOOP 1,200,000 855,318 344,682
120-9-0880-90-105 NORTHWEST BLVD BRIDGE 10,307,612 2,701,389 7,606,223
120-9-0880-90-106 LEANDER RD(SW BYPASS)1,550,000 - 1,550,000
120-9-0880-90-107 ROCK ST-6TH TO 9TH ST 273,000 - 273,000
120-9-0880-90-108 RIVERY EXTENSION - 56,187 (56,187)
120-9-0880-90-109 SE INNER LOOP ROCKRIDE IMPRV 115,000 - 115,000
120-9-0880-91-001 10TH ST (MAIN-ROCK)168,880 168,880 -
120-9-0880-91-002 11TH ST. (MAIN-ROCK)236,130 236,130 -
120-9-0880-91-006 AUSTIN AVE. (SH29-FM2243)492,300 494,445 (2,145)
120-9-0880-91-008 OLD TOWN NORTHEAST 826,445 2,017 824,428
120-9-0880-91-009 PH 1 SIGNAL & CURB RAMP IMPR.308,837 - 308,837
GENERAL CAPITAL PROJECTS Total 55,068,890 25,656,574 29,412,316
STORMWATER CAPITAL IMPROVEMENT
640-9-0880-90-005 CURB & GUTTER 527,504 122,853 404,651
640-9-0880-90-020 STORMWATER INFASTRUCTURE 200,000 41,100 158,900
640-9-0880-90-040 SPOILS FACILITY 100,000 - 100,000
640-9-0880-90-064 POND REHAB-2ND AND ROCK 450,000 24,205 425,795
640-9-0880-90-078 18TH AND HUTTO DRAINAGE 184,367 25,544 158,823
640-9-0880-90-079 2ND AND ROCK POND - 894 (894)
640-9-0880-90-081 VILLAGE PID INLET 75,000 - 75,000
STORMWATER CAPITAL IMPROVEMENT Total 1,536,871 214,596 1,322,275
STREET TAX SRF
203-9-0880-90-071 STREET MAINTENANCE 5,443,616 5,101,569 342,047
STREET TAX SRF Total 5,443,616 5,101,569 342,047
WATER SERVICES
660-9-0580-90-071 TANK REHAB PROJECTS 480,000 55,455 424,545
660-9-0580-90-076 DB WOOD/ PASTOR 24 DEDICATED 5,285,667 3,015,549 2,270,118
660-9-0580-90-077 RABBIT HILL WATERLINE 1,050,000 - 1,050,000
660-9-0580-90-078 RONALD REAGAN/DANIELS MOUNTAIN 6,425,959 6,177,625 248,334
660-9-0580-90-079 ROCK SUPPLY LINE 1,100,000 - 1,100,000
660-9-0580-90-080 RADIO REPLACEMENT 153,670 153,670 -
660-9-0580-90-097 SUN CITY ELEVATED STORAGE TANK - 3,327 (3,327)
660-9-0580-90-125 SHELL ROAD WATER LINE 6,033,651 - 6,033,651
660-9-0580-90-146 LWTP - DEWATERING FACILITY - 29,879 (29,879)
660-9-0580-90-166 LEANDER INTERCONNECT 225,000 - 225,000
660-9-0580-90-167 WEST LOOP (H-1A)2,119,000 854,862 1,264,138
660-9-0580-90-168 LWTP RAW WATER INTAKE REHAB 13,450,000 2,884,761 10,565,239
660-9-0580-90-170 CR 255 (WD14-2)1,493,963 - 1,493,963
660-9-0580-90-171 DOMEL PS IMPROVEMENTS (216,892) (216,892) -
660-9-0580-90-175 BRAUN EST 4,350,731 3,528,453 822,278
660-9-0580-90-176 MISC. LINE UPGRADES 393,899 22,049 371,850
660-9-0580-90-177 PARK WTP CLEARWELL 170,000 - 170,000
660-9-0580-90-178 S. LAKE WTP 2018 6,950,260 3,179,544 3,770,716
660-9-0580-90-179 SW BYPASS WATER H24-1 500,000 - 500,000
660-9-0580-90-180 TANK REHABILITATION 480,000 - 480,000
660-9-0580-90-200 WATER MAINS 2,208,325 821,777 1,386,548
660-9-0580-91-102 ASSET MANAGEMENT - 24,565 (24,565)
660-9-0580-91-105 CIS SYSTEM - 37,653 (37,653)
660-9-0581-90-051 PECAN BRANCH PH 2 - 1,264 (1,264)
660-9-0581-90-160 BERRY CREEK INTER (BC 4-6)20,714,161 5,791,223 14,922,938
660-9-0581-90-162 BERRY CREEK INTER (BC 1-3)- 42,318 (42,318)
660-9-0581-90-163 SAN GABRIEL BELT PRESS 1,900,932 58,500 1,842,432
660-9-0581-90-164 PARK LIFT STATION & FORCE MAIN 3,585,740 11,400 3,574,340
660-9-0581-90-166 EARZ 2,000,000 1,173,688 826,312
660-9-0581-90-167 SAN GABRIEL INTER SGI-2 2,500,000 1,037,700 1,462,300
660-9-0581-90-200 WW INTERCEPTORS 613,874 5,444 608,430
660-9-0581-90-210 WWTP UPGRADE/EXP 1,150,000 148,815 1,001,185
660-9-0581-90-220 LIFT STATION UPGRADE 550,000 2,835 547,165
WATER SERVICES Total 85,667,940 28,845,463 56,822,477
Grand Total 153,224,434 64,356,836 88,867,598
63
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 6/30/19 Status Updates ‐ 9/30/19
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.
Continue to request the $75,000 be added to the reserves for future
maintenance costs. There has been no change during this quarter.
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 12/31/2017, the net pension liability (NPL) is $17.3 million and
is 87.8% funded. The 2019 TMRS total combined contribution rate
is 12.36%.
As of 12/31/2018, the net pension liability is $22.3 million and is
85.6% funded. The 2020 total combined contribution rate is
12.26%. This decrease is due to a decrease in payroll growth.
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.
This is an actuarial calculation based on current and future
employees on future City health insurance costs and Life insurance
benefits, which has numerous and complex factors in its calculation.
Retirees pay their own premiums, and thus the liability is
considered “pay as you go”. With additional employees being
added, potential future retiree impacts increase. The 2018 current
OPEB liability is
$2,182,012 for healthcare benefits and $1,091,292 for Life
insurance benefits.
No change. Staff will review the 2019 OPEB calculation and present
it with the audited financial statements.
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 current amount of the Benefit Payout Reserve is $255,000. Will be updated when FY 19 audit is completed.
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 PCA was increased in June of 2019 to recover additional costs
for purchased power. The 90 day contingency reserve is projected
to be met at the end of FY2019. The June PCA is scheduled to
remain in effect during the FY2020 budget.
Purchased Power prices continued to affect the fund balance. The
City sold several assets as detailed in the Executive Summary of this
report in order to improve cash flow and begin to recover the rate
stabilization reserve. The City is on track to approve a contract in
December to manage the power portfolio in FY2020. The June PCA
will remain in effect in FY2020.
CITY OF GEORGETOWN
Long-term Commitments, Reservations, and Other Unfunded Liabilities
September 30, 2019
64
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 6/30/19 Status Updates ‐ 9/30/19
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.
There is a new paving project that will begin the last week of
August.
Terminal Drive was paved in late August 2019. That is the only
paving project that I know of here. We did have the runway rehab
project, but that was a TxDOT/FAA funded project.
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.
No change.There are currently no changes to 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.
Debt funded projects: Old Town NE Sidewalk – Approval has been
received from TCEQ. Design is completed. All easements have been
secured. Bid opening held on July 16th. GTAB approved award to
Choice Builders on August 9th. City Council will consider award on
August 27th 2019. Austin Ave Sidewalks (Leander to Hwy 29) –
Patin Construction has installed all sidewalk and pedestrian ramps
throughout the project. Contractor is completing steel plate work in
3 areas and working to have pedestrian activated signs installed at
16th and Austin Ave. All striping work is being scheduled.
Debt funded projects: Old Town NE Sidewalk – GTAB approved
award to Choice Builders on August 9th. City Council approved
award on August 27th 2019. Notice to proceed issued for 10‐7‐19,
groundbreaking held on 10‐8‐19. Contractor has begun working on
the est end of the project near Southwestern University. Austin Ave
Sidewalks (Leander to Hwy 29) – Patin Construction has installed all
sidewalk and pedestrian ramps throughout the project. Striping
work and pedestrian signs are in place. Contractor addressing
punch list and TDLR review items in October. Project to close out
end of October to Mid November.
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.
Projects in the FY 19 budget continue to be underway. There is an
increase of $97,000 proposed for the FY 20 budget to help fund the
projects identified for 2020.
Asset replacement needs for FY20 totaled $394K. Funding was
received through the budget process for $297K leading to $97K
being deferred to a future year.
Radio Equipment Replacement
Communication system consisting of 500 on‐body and in‐
vehicle radios for Police, Fire, parks and utilities.
Replacement radios are compatible with newer technology.
The replacement takes place over 5 years due to cost and is
funded with certificate of obligation debt.
Radios ordered on 7/17/19. On 8/12 and 8/13, we received three
pallets of radio equipment. Asset management process has begun.
The T1 to Ethernet conversion is scheduled to be completed by
9/15. NICE Recording Solution has a longer implementation process.
The goal is to have the installation completed by 12/31/19.
The first payment of $867,334.90 is being made October 17th. The
FY2020 budget includes $129,000 for year 4 of the project.
65
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 6/30/19 Status Updates ‐ 9/30/19
Street Maintenance
The City funds street maintenance in the General Fund,
supplemented by a 1/8th Street Sales Tax special revenue
fund. In 2017 and 2018, the Council and GTAB reviewed
various methods for enhanced street maintenance and
costs. Direction from Council is to use high performance
surface seals and pavement wearing courses and begin
programmatically addressing the street network's deferred
maintenance backlog, creating a need for approximately $2
million more per year for street maintenance.
The Hot In Place Asphalt recycling is currently on‐going in the Old
Town Area should be complete next week, then the Hot In Place
Asphalt recycling will move out to Berry Creek. In regards to the
High Performance Sealant Projects, application of the sealant has
started in University Park and Raintree Subdivisions. The contractor
should start in Sun City on Monday, August 19th and then
application of the sealant will begin the 1st week of September in
Georgetown Village.
Hot In Place Recycling (HIPR) is scheduled for Berry creek
Subdivision and Park View estates in FY 2020. High Performance
Surface Seal is scheduled for Sun City, Park View Estates
subdivisions and areas near San Gabriel Park FY 2020.
66