HomeMy WebLinkAboutFY 20 - 2nd_Qtr_Report_RedactedFINANCIAL REPORT AND INVESTMENT REPORT
For the Quarter Ended March 31, 2020
Table of Contents
Executive Summary .......................................................................................................................................... 1
General Fund Schedule .................................................................................................................................... 7
Electric Fund Schedule ..................................................................................................................................... 8
Water Services Fund Schedule ........................................................................................................................ 9
Airport Fund Schedule ................................................................................................................................... 10
Convention & Visitors Bureau Fund Schedule ............................................................................................... 11
Council Discretionary Fund Schedule ............................................................................................................ 12
Georgetown Economic Development Corporation Fund Schedule .............................................................. 13
Georgetown Transportation Enhancement Corporation Fund Schedule ..................................................... 14
Joint Services Fund Schedule ......................................................................................................................... 15
Quarterly Investment Report ‐ City ............................................................................................................... 16
Quarterly Investment Report ‐ GEDCO .......................................................................................................... 40
Quarterly Investment Report ‐ GTEC ............................................................................................................. 46
Grant Activities ............................................................................................................................................... 52
Long‐term Commitments and Other Unfunded Liabilities ............................................................................ 53
APRROVED BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
BEGINNING FUND BALANCE 11,490,900 11,490,900
Revenue
Administrative Charges 2,707,730 226,478 1,358,865 2,707,730
All Other Revenue 2,638,420 129,383 1,740,495 2,638,420
Development and Permit Fees 3,179,250 640,549 2,667,015 3,179,250
Franchise Fees 5,890,270 268,948 2,508,663 5,890,270
Parks and Recreation 2,833,100 289,447 1,208,245 2,833,100
Property Tax 14,900,000 247,351 15,119,538 14,900,000
ROI 8,060,000 716,888 3,856,389 8,060,000
Sales Tax 17,861,875 1,285,760 6,363,461 17,861,875
Sanitation Revenue 9,933,450 843,212 5,047,552 9,933,450
Fire and EMS Revenue 7,176,152 1,509,535 3,506,927 7,176,152
Transfer In 303,634 - 303,634 303,634
Revenue Total 75,483,881 6,157,551 43,680,784 75,483,881
Expense
Administrative Services 1,794,305 201,157 913,829 1,794,306
Animal Services 973,517 124,852 502,493 973,518
Arts & Culture 36,729 7,000 15,705 36,729
City Council 177,608 12,840 83,315 177,608
City Secretary 819,283 83,359 432,484 819,283
Code Compliance 524,382 47,565 217,290 524,383
Communications 684,453 45,605 259,555 684,453
Solid Waste & Recycling Services (Environmental Services)8,525,875 719,500 3,495,734 8,525,875
Community Services 265,732 44,853 97,469 265,732
Fire Emergency Services 14,280,663 1,593,599 7,341,305 14,280,663
Fire Support Services 3,120,344 474,585 1,945,400 3,120,345
Fire EMS 2,847,016 259,662 1,181,530 2,847,016
Garey Park 1,005,187 123,074 638,813 1,005,187
General Gov't Contracts 3,261,450 317,652 2,451,684 3,261,450
Inspections 1,347,040 147,536 683,243 1,347,040
Library 2,778,723 379,328 1,488,317 2,778,723
Municipal Court 664,063 64,820 348,959 664,063
Parks 2,726,868 304,014 1,603,166 2,726,868
Parks Admin 620,893 105,618 334,568 620,893
Planning 1,703,290 231,617 1,031,899 1,703,290
Police Admin 2,427,662 441,130 1,245,700 2,427,662
Police Operations 13,821,657 1,660,847 7,186,526 13,821,657
Public Works 1,469,053 126,659 617,645 1,469,053
Rec Programs 1,359,138 75,916 480,966 1,359,138
Recreation 2,753,284 401,532 1,406,267 2,753,284
Streets 4,400,037 690,805 3,386,409 4,400,037
Tennis Center 460,794 49,965 200,478 460,794
Transfer Out 524,860 - 457,860 524,860
Expense Total 75,373,906 8,735,090 40,048,609 75,373,910
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS 109,975 (2,577,539) 3,632,175 109,971
ENDING FUND BALANCE 109,975 (2,577,539) 3,632,175 109,971
RESERVES
Contingency Reserve 11,200,000 11,200,000
Benefit Payout Reserve 340,000 340,000
Reserve Total 11,540,000 11,540,000
AVAILABLE FUND BALANCE 60,875 60,871
Year-End Projection to Approved: March FY2020
General Fund
7
FY2020 BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR‐END
PROJECTION
BEGINNING FUND BALANCE 5,892,640 5,892,640
Operating Revenue
Electric Revenue (SEE NOTE A)85,509,803 5,870,142 37,702,206 85,509,803
Interest 40,000 79 3,700 40,000
Other Revenue 4,748,616 1,056,003 2,447,328 3,098,616
Developer Contributions 600,000 135,883 1,793,905 2,000,000
Operating Revenue Total 90,898,419 7,062,107 41,947,139 90,648,419
Operating Expenditures
CRR Credits, Net (2,000,000) 281,850 (353,165) (2,000,000)
Georgetown Utility Systems 20,465,330 1,909,979 10,790,607 20,167,271
Purchased Power 61,500,000 4,531,469 27,287,661 61,500,000
Transfers Out‐ROI 4,500,000 398,660 2,328,608 4,500,000
Operating Expenditures Total 84,465,330 7,121,958 40,053,711 84,167,271
Total Net Operations 6,433,089 (59,851) 1,893,428 6,481,148
Non‐Operating Revenue ‐ ‐ ‐ ‐
Renewable Energy Credits ‐ 166,751 382,959 382,959
Grant Revenue ‐ ‐ ‐ ‐
Bond Proceeds 4,010,000 ‐ ‐ 4,010,000
Sale of Property 10,000 49 10,536 10,000
Transfer In‐Other 500,000 ‐ ‐ 500,000
Non‐Operating Revenue Total 4,520,000 166,800 393,495 4,902,959
Non‐Operating Expenditures
CIP 4,010,000 110,908 1,030,860 4,010,000
Debt Service 2,866,312 ‐ 350 2,866,312
Interest Expense 1,224,183 ‐ 590,621 1,224,183
Non‐Operating Expenditures Total 8,100,494 110,908 1,621,831 8,100,494
Total Net Non‐Operations (3,580,494) 55,892 (1,228,336) (3,197,535)
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL
REQUIREMENTS 2,852,595 (3,959) 665,092 3,283,612
ENDING FUND BALANCE 8,745,234 9,176,252
Contingency 4,190,234 4,190,234
Rate Stabilization Reserve 4,555,000 4,521,208
AVAILABLE FUND BALANCE 0 464,810
NOTES:
A. INCLUDES ACCRUAL FOR MARCH REVENUE BILLED THROUGH APRIL 30
Year‐End Projection to Approved: March FY2020
Electric Fund
8
APRROVED BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB) YEAR-END PROJECTION
BEGINNING FUND BALANCE 82,511,169 82,511,169
Operating Revenue
Capital Recovery Fee 14,250,000 4,664,467 15,563,761 14,250,000
Irrigation Utility Revenue 310,000 29,174 197,437 310,000
Other Revenue 3,450,300 864,706 4,064,813 3,450,300
Wastewater Utility Revenue 13,298,825 1,088,654 7,547,465 13,298,825
Water Utility Revenue 30,869,778 2,152,891 12,864,494 30,869,778
Operating Revenue Total 62,178,903 8,799,892 40,237,969 62,178,903
Operating Expenditures
Irrigation 395,450 22,432 151,232 395,450
Transfer Out 399,500 - 399,500 399,500
Transfer Out, ROI 3,300,000 291,913 1,395,304 3,300,000
Wastewater Operations 3,857,654 86,288 1,173,554 3,857,654
Wastewater Plant Management 2,537,076 345,923 2,159,009 2,537,076
Water Administration 23,176,352 2,323,380 12,558,884 23,176,352
Water Distribution 1,995,125 165,361 1,099,057 1,995,125
Water Operations 4,244,971 465,224 2,254,819 4,244,971
Water Plant Management 2,582,017 190,570 1,760,767 2,582,017
Operating Expenditures Total 42,488,144 3,891,092 22,952,126 42,488,144
Total Net Operations 19,690,759 4,908,800 17,285,844 19,690,759
Non-Operating Revenue
Bond Proceeds 18,600,000 - - 18,600,000
Grant Revenue - - - -
Interest 949,500 122,623 950,050 949,500
Sale of Assets 1,500 435,404 1,500
Transfer In-Debt 104,211 - - 104,211
Non-Operating Revenue Total 19,655,211 122,623 1,385,454 19,655,211
Non-Operating Expenditures
CIP 93,789,328 1,227,563 27,248,210 93,789,328
Interest Expense 983,227 19 514,747 983,227
Debt Service 2,394,188 - 1,225 2,394,188
Non-Operating Expenditures Total 97,166,743 1,227,582 27,764,182 97,166,743
Total Net Non-Operations (77,511,532) (1,104,959) (26,378,728) (77,511,532)
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL
REQUIREMENTS (57,820,773) 3,803,841 (9,092,885) (57,820,773)
ENDING FUND BALANCE 24,690,396 24,690,396
Contingency 8,236,379 8,236,379
Non-Operating Contingency 10,000,000 10,000,000
AVAILABLE FUND BALANCE 6,454,017 6,454,017
Year-End Projection to Approved: March FY2020
Water Fund
9
APPROVED
BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
BEGINNING FUND BALANCE 1,451,988 1,451,988
Operating Revenue
Fuel and Terminal Sales 2,901,500 161,479 1,235,845 2,901,500
Interest and Other 51,000 1,361 12,566 51,000
Grant Revenue - - - -
Leases and Rentals 928,500 76,964 461,847 928,500
Operating Revenue Total 3,881,000 239,804 1,710,258 3,881,000
Operating Expenditures
Operations-Fuel 2,270,000 135,617 2,200,832 2,270,000
Operations-Non Fuel 878,327 109,215 392,163 878,327
Personnel 501,098 49,472 243,953 501,098
Operating Expenditures Total 3,649,425 294,304 2,836,948 3,649,425
TOTAL NET OPERATIONS 231,575 (54,500) (1,126,690) 231,575
Non-Operating Revenue
Bond Proceeds 750,000 - - 750,000
Non-Operating Revenue Total 750,000 - - 750,000
Non-Operating Expenditures
Buildings & Improvements 750,000 - - 750,000
Debt Service/Handling Fees 101,358 - 115 101,358
Interest Expense 60,062 - 29,638 60,062
Furniture & Equipment 22,000 - 8,111 22,000
Improvements 266,566 - 12,921 266,566
Pavement Upgrades 35,000 - - 35,000
Non-Operating Expenditure Total 1,234,986 - 50,785 1,234,986
Total Expenditures 4,884,411 294,304 2,887,733 4,884,411
TOTAL NET NON-OPERATIONS (484,986) (294,304) (50,785) (484,986)
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL
REQUIREMENTS (253,411) (348,804) (1,177,475) (253,411)
ENDING FUND BALANCE 1,198,577 1,198,577
RESERVES
Contingency 256,021 256,021
Debt Service Reserve 143,431 143,431
Reserves Total 399,452 399,452
AVAILABLE FUND BALANCE 799,125 799,125
Airport Operations Fund
Year-End Projection to Approved: March FY2020
10
APRROVED BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
BEGINNING FUND BALANCE 1,437,144 - - 1,437,144
Revenue
Hotel/Motel Occupancy Tax Revenues 1,300,000 124,943 570,401 1,300,000
Interest 18,000 1,829 13,741 18,000
Other 18,500 995 11,152 18,500
Poppy Festival 144,283 43,269 85,276 144,283
Revenue Total 1,480,783 171,036 680,570 1,480,783
Expense
Operations 812,015 47,027 504,274 812,014
Personnel 413,567 49,810 225,672 413,567
Poppy Festival 186,700 12,050 12,318 186,700
Transfers Out 28,634 - 28,634 28,634
Expense Total 1,440,916 108,887 770,898 1,440,915
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS 39,867 62,149 (90,328) 39,868
ENDING FUND BALANCE 1,477,011 (90,328) 1,477,012
Year-End Projection to Approved: MAR FY2020
Convention & Visitors Bureau Fund
11
APRROVED
BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
BEGINNING FUND BALANCE 109,415 109,415
Revenue
Interest 2,500 133 1,052 2,500
Transfers In - - - -
Revenue Total 2,500 133 1,052 2,500
Expense
Transfers Out - - - -
Expense Total - - - -
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS 2,500 133 1,052 2,500
ENDING FUND BALANCE 111,915 1,052 111,915
Year End Projections to Approved: March FY 2020
Council Discretionary Fund
12
APPROVED
BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR‐END
PROJECTION
BEGINNING FUND BALANCE 8,305,736 8,305,736
OPERATING REVENUES
Interest 76,000 7,038 65,465 76,000
Sales Tax 1,984,375 142,844 706,920 1,984,375
OPERATING REVENUES Total 2,060,375 149,882 772,385 2,060,375
OPERATING EXPENDITURES
Administrative Charges 244,771 20,398 122,385 244,771
Marketing ‐ 5,000 61,274 61,274
Contractual Services 30,000 ‐ 6,615 30,000
Miscellaneous Expense 50 10,972 2,493 2,500
Travel & Training 500 92 92 500
OPERATING EXPENDITURES Total 275,321 36,462 192,859 338,545
TOTAL NET OPERATIONS 1,785,054 113,420 579,526 1,721,830
NON‐OPERATING EXPENDITURES
Debt Service 291,364 ‐ 41,334 291,364
Interest Expense 20,516 20,516
Economic Development Agreements 510,000 ‐ 356,235 510,000
Strategic Partnerships 8,167,104 ‐ 143,674 143,674
CIP 290,000 290,000
NON‐OPERATING EXPENDITURES Total 9,278,984 ‐ 541,243 1,255,554
TOTAL NET NON‐OPERATIONS (9,278,984) ‐ (541,243) (1,255,554)
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL
REQUIREMENTS (7,493,930) 113,420 38,283 466,276
ENDING FUND BALANCE 811,806 38,283 8,772,012
Georgetown Economic Development Corporation Fund
Year‐End Projections to Approved: March FY2020
13
APPROVED BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB) YEAR-END PROJECTION
BEGINNING FUND BALANCE 20,686,127 - 17,130,653
Operating Revenue
Sales Tax 7,937,500 571,375 2,827,678 7,937,500
Interest 230,000 25,102 213,571 230,000
Other Revenue - - - -
Operating Revenue Total 8,167,500 596,477 3,041,249 8,167,500
Operating Expenditure
Administrative Support 410,223 29,830 204,711 410,223
Operating Expenditure Total 410,223 29,830 204,711 410,223
TOTAL NET OPERATIONS 7,757,277 566,647 2,836,538 7,757,277
Non-Operating Revenue
Debt Proceeds 4,700,000 - - 4,700,000
Transfers In - - - -
Non-Operating Revenue Total 4,700,000 - - 4,700,000
Non-Operating Expenditure
Economic Development Agreements 1,984,375 - - 1,984,375
Strategic Partnerships 2,000,000 - - 2,000,000
CIP Expense 14,431,841 20,878 1,163,061 14,431,841
Debt Service 3,333,921 - 487,575 3,333,921
Non-Operating Expenditure Total 21,750,137 20,878 1,650,636 21,750,137
TOTAL NET NON-OPERATIONS (17,050,137) (20,878) (1,650,636) (17,050,137)
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL
REQUIREMENTS (9,292,860) 545,769 1,185,902 (9,292,860)
ENDING FUND BALANCE 11,393,267 545,769 1,185,902 7,837,793
Georgetown Transportation Enhancement Corporation Fund
Year-End Projections to Approved: March FY2020
14
APRROVED BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
BEGINNING FUND BALANCE 1,394,842 1,394,842
Revenue
Administrative Charges 17,691,145 1,474,262 8,845,572 17,691,145
Interest 25,000 2,586 11,708 25,000
Other 103,000 29,487 123,299 103,000
Transfers In 295,059 - 295,059 295,059
Revenue Total 18,114,204 1,506,335 9,275,638 18,114,204
Expense
Accounting 1,128,153 151,475 614,213 1,128,153
Business System Sevices 1,198,892 121,776 628,812 1,198,892
Citywide Human Resources 1,307,900 18,579 702,567 1,307,900
Conservation 894,920 47,402 265,724 894,920
Customer Care 5,046,552 956,864 2,842,196 5,046,552
Economic Development 663,668 68,560 327,316 663,668
Finance Administration 1,161,128 77,237 644,865 1,161,128
Human Resources 1,446,884 182,988 655,058 1,446,884
Legal 1,063,008 104,627 553,233 1,063,008
Non-departmental 739,171 74,814 765,426 739,171
Organizational and Operational Excellence 329,898 33,680 130,684 329,898
Purchasing 923,989 116,349 465,657 923,989
Systems Engineering 2,492,992 271,234 1,345,955 2,492,992
Expense Total 18,397,157 2,225,585 9,941,706 18,397,157
EXCESS (DEFICIENCY) OF TOTAL REVENUE
OVER TOTAL REQUIREMENTS (282,953) (719,250) (666,068) (282,953)
AVAILABLE FUND BALANCE 1,111,890 (666,068) 1,111,890
Joint Services Fund
Year-End Projection to Approved: Mar FY2020
15
CITY
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
March 31, 2020
Prepared by
Valley View Consulting, L.L.C.
The investment portfolio of the City of Georgetown is in compliance with the Public Funds Investment Act and the
Investment Policy and Strategies.
Disclaimer: These reports were compiled using information provided by the City. No procedures were performed to test the
accuracy or completeness of this information. The market values included in these reports were obtained by Valley View
Consulting, L.L.C. from sources believed to be accurate and represent proprietary valuation. Due to market fluctuations these
levels are not necessarily reflective of current liquidation values. Yield calculations are not determined using standard performance
formulas, are not representative of total return yields and do not account for investment advisor fees.
16
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Demand Accounts 8,947,165$ 8,947,165 10,852,258$ 10,852,258$ 0.23%
NOW/MMA 20,619,316 20,619,316 21,716,013 21,716,013 1.61%
Pools 89,853,153 89,853,153 104,846,720 104,846,720 0.97%
CDs/Securities 84,843,107 84,845,177 83,294,855 83,323,230 2.05%
Totals 204,262,741$ 204,264,811$ 220,709,845$ 220,738,220$ 1.41%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 1.41%Total Portfolio 1.65%
Rolling Three Month Treasury 1.17%Rolling Three Month Treasury 1.38%
Rolling Six Month Treasury 1.39%Rolling Six Month Treasury 1.58%
TexPool 1.00%TexPool 1.31%
Bank Fees Offset
9,483$
Interest income provided in separate report.20,641$
December 31, 2019
(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, 2020
Valley View Consulting, L.L.C.
117
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.23% 04/01/20 03/31/20 10,852,258$ 10,852,258$ 1.00 10,852,258$ 1 0.23%
JPMorgan Chase MMA 0.07% 04/01/20 03/31/20 433,875 433,875 1.00 433,875 1 0.07%
Veritex Bank MMA 1.31% 04/01/20 03/31/20 3,205,333 3,205,333 1.00 3,205,333 1 1.31%
NexBank MMA 0.90% 04/01/20 03/31/20 7,337,623 7,337,623 1.00 7,337,623 1 0.90%
Origin Bank MMA (4)2.25% 04/01/20 03/31/20 10,739,181 10,739,181 1.00 10,739,181 1 2.25%
TexPool AAAm 1.00% 04/01/20 03/31/20 38,781,634 38,781,634 1.00 38,781,634 1 1.00%
TexSTAR AAAm 0.96% 04/01/20 03/31/20 66,065,086 66,065,086 1.00 66,065,086 1 0.96%
East West Bank CD 2.62% 04/01/20 04/01/19 5,252,290 5,252,290 100.00 5,252,290 1 2.65%
T-Bill Aaa/AA+ 0.00% 04/16/20 10/17/19 2,500,000 2,498,236 100.00 2,499,923 16 1.62%
Southside Bank CD 1.82% 04/17/20 10/18/19 2,514,336 2,514,336 100.00 2,514,336 17 1.83%
LegacyTexas Bank CD 2.91% 05/06/20 11/06/18 4,157,776 4,157,776 100.00 4,157,776 36 2.95%
T-Bill Aaa/AA+ 0.00% 05/07/20 11/07/19 4,900,000 4,892,333 99.99 4,899,686 37 1.56%
Southside Bank CD 2.47% 05/11/20 05/10/19 3,056,381 3,056,381 100.00 3,056,381 41 2.49%
BBVA Bank CD 2.51% 06/20/20 06/20/19 4,076,022 4,076,022 100.00 4,076,022 81 2.54%
East West Bank CD 2.48% 07/15/20 04/15/19 5,121,021 5,121,021 100.00 5,121,021 106 2.51%
East West Bank CD 1.72% 08/04/20 02/04/20 6,518,552 6,518,552 100.00 6,518,552 126 1.73%
R Bank CD 2.10% 08/16/20 08/16/19 2,021,284 2,021,284 100.00 2,021,284 138 2.12%
R Bank CD 1.17% 08/16/20 02/26/20 1,010,897 1,010,897 100.00 1,010,897 138 1.17%
LegacyTexas Bank CD 2.66% 08/21/20 02/22/19 6,174,483 6,174,483 100.00 6,174,483 143 2.69%
T-Bill Aaa/AA+ 0.00% 10/08/20 10/17/19 2,500,000 2,479,441 99.95 2,498,775 191 1.60%
Independent Bank CD 1.85% 10/18/20 10/18/19 2,511,652 2,511,652 100.00 2,511,652 201 1.86%
Independent Bank CD 2.56% 11/10/20 05/10/19 1,019,475 1,019,475 100.00 1,019,475 224 2.58%
R Bank CD 1.76% 11/19/20 02/19/20 2,500,000 2,500,000 100.00 2,500,000 233 1.78%
Southside Bank CD 1.72% 11/19/20 11/19/19 3,230,917 3,230,917 100.00 3,230,917 233 1.73%
East West Bank CD 1.71% 12/09/20 12/09/19 4,021,420 4,021,420 100.00 4,021,420 253 1.72%
East West Bank CD 1.71% 01/08/21 01/08/20 3,011,829 3,011,829 100.00 3,011,829 283 1.72%
Independent Bank CD 1.70% 02/05/21 02/05/20 3,100,000 3,100,000 100.00 3,100,000 311 1.71%
R Bank CD 1.81% 02/19/21 02/19/20 4,000,000 4,000,000 100.00 4,000,000 325 1.83%
Bank OZK CD 1.72% 02/26/21 02/27/20 6,007,921 6,007,921 100.00 6,007,921 332 1.73%
Independent Bank CD 1.80% 04/22/21 10/22/19 4,118,590 4,118,590 100.00 4,118,590 387 1.81%
220,739,836$ 220,709,845$ 220,738,220$ 63 1.41%
(1) (2)
March 31, 2020
(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.
(4) Origin Bank MMA - Interest rate fixed until August 2020.
(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.319
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.23% 04/01/20 8,947,165$ 8,947,165$ 1,905,092$ –$ 10,852,258$ 10,852,258$
JPMorgan Chase MMA 0.07% 04/01/20 433,724 433,724 151 433,875 433,875
Veritex Bank MMA 1.31% 04/01/20 3,192,376 3,192,376 12,957 3,205,333 3,205,333
NexBank MMA 0.90% 04/01/20 7,310,083 7,310,083 27,540 7,337,623 7,337,623
Origin Bank MMA (4)2.25% 04/01/20 9,683,133 9,683,133 1,056,048 10,739,181 10,739,181
TexPool 1.00% 04/01/20 32,488,666 32,488,666 6,292,968 38,781,634 38,781,634
TexSTAR 0.96% 04/01/20 57,364,487 57,364,487 8,700,599 66,065,086 66,065,086
WallisBank CD 2.77%01/03/20 3,062,607 3,062,607 (3,062,607)– –
Independent Bank CD 2.88%02/03/20 5,182,915 5,182,915 (5,182,915)– –
East West Bank CD 2.25%02/03/20 4,491,891 4,491,891 (4,491,891)– –
BBVA Bank CD 2.25%02/03/20 2,015,097 2,015,097 (2,015,097)– –
R Bank CD 2.89%02/15/20 6,131,100 6,131,100 (6,131,100)– –
R Bank CD 2.15%02/16/20 1,005,434 1,005,434 (1,005,434)– –
Southside Bank CD 2.65%03/13/20 6,120,594 6,120,594 (6,120,594)– –
East West Bank CD 2.62%04/01/20 5,218,095 5,218,095 34,195 5,252,290 5,252,290
T-Bill 0.00%04/16/20 2,500,000 2,488,200 10,035 2,500,000 2,498,236
Southside Bank CD 1.82%04/17/20 2,500,000 2,500,000 14,336 2,514,336 2,514,336
LegacyTexas Bank CD 2.91%05/06/20 4,127,814 4,127,814 29,961 4,157,776 4,157,776
T-Bill 0.00%05/07/20 4,900,000 4,873,475 18,858 4,900,000 4,892,333
Southside Bank CD 2.47%05/11/20 3,037,471 3,037,471 18,911 3,056,381 3,056,381
BBVA Bank CD 2.51%06/20/20 4,050,654 4,050,654 25,368 4,076,022 4,076,022
East West Bank CD 2.48%07/15/20 5,089,456 5,089,456 31,565 5,121,021 5,121,021
East West Bank CD 1.72%08/04/20 – – 6,518,552 6,518,552 6,518,552
R Bank CD 2.10%08/16/20 2,010,614 2,010,614 10,670 2,021,284 2,021,284
R Bank CD 1.17%08/16/20 – – 1,010,897 1,010,897 1,010,897
LegacyTexas Bank CD 2.66%08/21/20 6,133,814 6,133,814 40,669 6,174,483 6,174,483
T-Bill 0.00%10/08/20 2,500,000 2,469,646 9,795 2,500,000 2,479,441
Independent Bank CD 1.85%10/18/20 2,500,000 2,500,000 11,652 2,511,652 2,511,652
Independent Bank CD 2.56%11/10/20 1,012,947 1,012,947 6,528 1,019,475 1,019,475
R Bank CD 1.76%11/19/20 – – 2,500,000 2,500,000 2,500,000
Southside Bank CD 1.72%11/19/20 3,216,971 3,216,971 13,947 3,230,917 3,230,917
East West Bank CD 1.71%12/09/20 4,004,312 4,004,312 17,108 4,021,420 4,021,420
East West Bank CD 1.71%01/08/21 – – 3,011,829 3,011,829 3,011,829
Independent Bank CD 1.70%02/05/21 – – 3,100,000 3,100,000 3,100,000
R Bank CD 1.81%02/19/21 – – 4,000,000 4,000,000 4,000,000
Bank OZK CD 1.72%02/26/21 – – 6,007,921 6,007,921 6,007,921
Independent Bank CD 1.80%04/22/21 4,100,000 4,100,000 18,590 4,118,590 4,118,590
TOTAL 204,331,420$ 204,262,741$ 44,456,742$ (28,009,638)$ 220,739,836$ 220,709,845$
December 31, 2019 March 31, 2020
Valley View Consulting, L.L.C.521
City - Market Value Comparison
Maturity Face Amount/Market Qtr to Qtr Face Amount/Market
Description Date Par Value Price Market Value Change Par Value Price Market Value
JPMorgan Chase Cash 04/01/20 8,947,165$ 1.00 8,947,165$ 1,905,092$ 10,852,258$ 1.00 10,852,258$
JPMorgan Chase MMA 04/01/20 433,724 1.00 433,724 151 433,875 1.00 433,875
Veritex Bank MMA 04/01/20 3,192,376 1.00 3,192,376 12,957 3,205,333 1.00 3,205,333
NexBank MMA 04/01/20 7,310,083 1.00 7,310,083 27,540 7,337,623 1.00 7,337,623
Origin Bank MMA (4) 04/01/20 9,683,133 1.00 9,683,133 1,056,048 10,739,181 1.00 10,739,181
TexPool 04/01/20 32,488,666 1.00 32,488,666 6,292,968 38,781,634 1.00 38,781,634
TexSTAR 04/01/20 57,364,487 1.00 57,364,487 8,700,599 66,065,086 1.00 66,065,086
WallisBank CD 01/03/20 3,062,607 100.00 3,062,607 (3,062,607)– –
Independent Bank CD 02/03/20 5,182,915 100.00 5,182,915 (5,182,915)– –
East West Bank CD 02/03/20 4,491,891 100.00 4,491,891 (4,491,891)– –
BBVA Bank CD 02/03/20 2,015,097 100.00 2,015,097 (2,015,097)– –
R Bank CD 02/15/20 6,131,100 100.00 6,131,100 (6,131,100)– –
R Bank CD 02/16/20 1,005,434 100.00 1,005,434 (1,005,434)– –
Southside Bank CD 03/13/20 6,120,594 100.00 6,120,594 (6,120,594)– –
East West Bank CD 04/01/20 5,218,095 100.00 5,218,095 34,195 5,252,290 100.00 5,252,290
T-Bill 04/16/20 2,500,000 99.56 2,488,933 10,990 2,500,000 100.00 2,499,923
Southside Bank CD 04/17/20 2,500,000 100.00 2,500,000 14,336 2,514,336 100.00 2,514,336
LegacyTexas Bank CD 05/06/20 4,127,814 100.00 4,127,814 29,961 4,157,776 100.00 4,157,776
T-Bill 05/07/20 4,900,000 99.47 4,873,868 25,818 4,900,000 99.99 4,899,686
Southside Bank CD 05/11/20 3,037,471 100.00 3,037,471 18,911 3,056,381 100.00 3,056,381
BBVA Bank CD 06/20/20 4,050,654 100.00 4,050,654 25,368 4,076,022 100.00 4,076,022
East West Bank CD 07/15/20 5,089,456 100.00 5,089,456 31,565 5,121,021 100.00 5,121,021
East West Bank CD 08/04/20 – – 6,518,552 6,518,552 100.00 6,518,552
R Bank CD 08/16/20 2,010,614 100.00 2,010,614 10,670 2,021,284 100.00 2,021,284
R Bank CD 08/16/20 – – 1,010,897 1,010,897 100.00 1,010,897
LegacyTexas Bank CD 08/21/20 6,133,814 100.00 6,133,814 40,669 6,174,483 100.00 6,174,483
T-Bill 10/08/20 2,500,000 98.82 2,470,590 28,185 2,500,000 99.95 2,498,775
Independent Bank CD 10/18/20 2,500,000 100.00 2,500,000 11,652 2,511,652 100.00 2,511,652
Independent Bank CD 11/10/20 1,012,947 100.00 1,012,947 6,528 1,019,475 100.00 1,019,475
R Bank CD 11/19/20 – – 2,500,000 2,500,000 100.00 2,500,000
Southside Bank CD 11/19/20 3,216,971 100.00 3,216,971 13,947 3,230,917 100.00 3,230,917
East West Bank CD 12/09/20 4,004,312 100.00 4,004,312 17,108 4,021,420 100.00 4,021,420
East West Bank CD 01/08/21 – – 3,011,829 3,011,829 100.00 3,011,829
Independent Bank CD 02/05/21 – – 3,100,000 3,100,000 100.00 3,100,000
R Bank CD 02/19/21 – – 4,000,000 4,000,000 100.00 4,000,000
Bank OZK CD 02/26/21 – – 6,007,921 6,007,921 100.00 6,007,921
Independent Bank CD 04/22/21 4,100,000 100.00 4,100,000 18,590 4,118,590 100.00 4,118,590
TOTAL 204,331,420$ 204,264,811$ 16,473,409$ 220,739,836$ 220,738,220$
December 31, 2019 March 31, 2020
Valley View Consulting, L.L.C.622
City - Allocation
Investment
Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
JPMorgan Chase Cash 10,852,258$ 10,852,258$ –$ –$ –$ –$
JPMorgan Chase MMA 433,875 433,875 – – – –
Veritex Bank MMA 3,205,333 3,205,333 – – – –
NexBank MMA 7,337,623 7,337,623 – – – –
Origin Bank MMA 10,739,181 4,057,314 – – – –
TexPool 38,781,634 38,781,634 – – – –
TexSTAR 66,065,086 16,194,709 583,421 16,064,232 137,104 310,924
East West Bank CD 04/01/20 5,252,290 5,252,290 – – – –
T-Bill 04/16/20 2,498,236 2,498,236 – – – –
Southside Bank CD 04/17/20 2,514,336 2,514,336 – – – –
LegacyTexas Bank CD 05/06/20 4,157,776 4,157,776 – – – –
T-Bill 05/07/20 4,892,333 – – – – –
Southside Bank CD 05/11/20 3,056,381 3,056,381 – – – –
BBVA Bank CD 06/20/20 4,076,022 4,076,022 – – – –
East West Bank CD 07/15/20 5,121,021 5,121,021 – – – –
East West Bank CD 08/04/20 6,518,552 6,518,552 – – – –
R Bank CD 08/16/20 2,021,284 – – – – –
R Bank CD 08/16/20 1,010,897 – – – – –
LegacyTexas Bank CD 08/21/20 6,174,483 6,174,483 – – – –
T-Bill 10/08/20 2,479,441 2,479,441 – – – –
Independent Bank CD 10/18/20 2,511,652 2,511,652 – – – –
Independent Bank CD 11/10/20 1,019,475 1,019,475 – – – –
R Bank CD 11/19/20 2,500,000 2,500,000 – – – –
Southside Bank CD 11/19/20 3,230,917 3,230,917 – – – –
East West Bank CD 12/09/20 4,021,420 4,021,420 – – – –
East West Bank CD 01/08/21 3,011,829 3,011,829 – – – –
Independent Bank CD 02/05/21 3,100,000 3,100,000 – – – –
R Bank CD 02/19/21 4,000,000 4,000,000 – – – –
Bank OZK CD 02/26/21 6,007,921 6,007,921 – – – –
Independent Bank CD 04/22/21 4,118,590 4,118,590 – – – –
Totals 220,709,845$ 156,233,087$ 583,421$ 16,064,232$ 137,104$ 310,924$
Book Value
March 31, 2020
Valley View Consulting, L.L.C.723
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 04/01/20
T-Bill 04/16/20
Southside Bank CD 04/17/20
LegacyTexas Bank CD 05/06/20
T-Bill 05/07/20
Southside Bank CD 05/11/20
BBVA Bank CD 06/20/20
East West Bank CD 07/15/20
East West Bank CD 08/04/20
R Bank CD 08/16/20
R Bank CD 08/16/20
LegacyTexas Bank CD 08/21/20
T-Bill 10/08/20
Independent Bank CD 10/18/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Independent Bank CD 04/22/21
Totals
Book Value
March 31, 2020
(Continued)
2015 GO-
Roads
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
–$ –$ –$ –$ –$ –$
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
2,505,126 1,529,574 68,505 1,449,455 1,502,181 382,155
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
2,505,126$ 1,529,574$ 68,505$ 1,449,455$ 1,502,181$ 382,155$
Valley View Consulting, L.L.C.824
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 04/01/20
T-Bill 04/16/20
Southside Bank CD 04/17/20
LegacyTexas Bank CD 05/06/20
T-Bill 05/07/20
Southside Bank CD 05/11/20
BBVA Bank CD 06/20/20
East West Bank CD 07/15/20
East West Bank CD 08/04/20
R Bank CD 08/16/20
R Bank CD 08/16/20
LegacyTexas Bank CD 08/21/20
T-Bill 10/08/20
Independent Bank CD 10/18/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Independent Bank CD 04/22/21
Totals
Book Value
March 31, 2020
(Continued)
2017 CO
Facilities/ Public
Safety/
Equipment
2017 GO-
Sidewalks
2017 Revenue
Electric
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
–$ –$ –$ –$ –$ –$
– – – – – –
– – – – – –
– – – – – –
– – – 1,001,628 – –
– – – – – –
182,069 380,362 97,239 6,018,195 56,616 924,064
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – 4,892,333 – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – 2,021,284 – –
– – – 1,010,897 – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
182,069$ 380,362$ 97,239$ 14,944,336$ 56,616$ 924,064$
Valley View Consulting, L.L.C.925
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 04/01/20
T-Bill 04/16/20
Southside Bank CD 04/17/20
LegacyTexas Bank CD 05/06/20
T-Bill 05/07/20
Southside Bank CD 05/11/20
BBVA Bank CD 06/20/20
East West Bank CD 07/15/20
East West Bank CD 08/04/20
R Bank CD 08/16/20
R Bank CD 08/16/20
LegacyTexas Bank CD 08/21/20
T-Bill 10/08/20
Independent Bank CD 10/18/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Independent Bank CD 04/22/21
Totals
Book Value
March 31, 2020
(Continued)
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2018 CO-
Stormwater
2018 GO-
Roads
–$ –$ –$ –$ –$
– – – – –
– – – – –
– – – – –
– – 4,716,627 – 963,612
– – – – –
559,850 11,604,502 2,605,474 438,996 2,470,336
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
559,850$ 11,604,502$ 7,322,102$ 438,996$ 3,433,948$
Valley View Consulting, L.L.C.1026
City - Allocation
March 31, 2020
Market Value Investment
Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
JPMorgan Chase Cash 10,852,258$ 10,852,258$ –$ –$ –$ –$
JPMorgan Chase MMA 433,875 433,875 – – – –
Veritex Bank MMA 3,205,333 3,205,333 – – – –
NexBank MMA 7,337,623 7,337,623 – – – –
Origin Bank MMA 10,739,181 4,057,314 – – – –
TexPool 38,781,634 38,781,634 – – – –
TexSTAR 66,065,086 16,194,709 583,421 16,064,232 137,104 310,924
East West Bank CD 04/01/20 5,252,290 5,252,290 – – – –
T-Bill 04/16/20 2,499,923 2,499,923 – – – –
Southside Bank CD 04/17/20 2,514,336 2,514,336 – – – –
LegacyTexas Bank CD 05/06/20 4,157,776 4,157,776 – – – –
T-Bill 05/07/20 4,899,686 – – – – –
Southside Bank CD 05/11/20 3,056,381 3,056,381 – – – –
BBVA Bank CD 06/20/20 4,076,022 4,076,022 – – – –
East West Bank CD 07/15/20 5,121,021 5,121,021 – – – –
East West Bank CD 08/04/20 6,518,552 6,518,552 – – – –
R Bank CD 08/16/20 2,021,284 – – – – –
R Bank CD 08/16/20 1,010,897 – – – – –
LegacyTexas Bank CD 08/21/20 6,174,483 6,174,483 – – – –
T-Bill 10/08/20 2,498,775 2,498,775 – – – –
Independent Bank CD 10/18/20 2,511,652 2,511,652 – – – –
Independent Bank CD 11/10/20 1,019,475 1,019,475 – – – –
R Bank CD 11/19/20 2,500,000 2,500,000 – – – –
Southside Bank CD 11/19/20 3,230,917 3,230,917 – – – –
East West Bank CD 12/09/20 4,021,420 4,021,420 – – – –
East West Bank CD 01/08/21 3,011,829 3,011,829 – – – –
Independent Bank CD 02/05/21 3,100,000 3,100,000 – – – –
R Bank CD 02/19/21 4,000,000 4,000,000 – – – –
Bank OZK CD 02/26/21 6,007,921 6,007,921 – – – –
Independent Bank CD 04/22/21 4,118,590 4,118,590 – – – –
Totals 220,738,220$ 156,254,108$ 583,421$ 16,064,232$ 137,104$ 310,924$
Valley View Consulting, L.L.C.1127
City - Allocation
March 31, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 04/01/20
T-Bill 04/16/20
Southside Bank CD 04/17/20
LegacyTexas Bank CD 05/06/20
T-Bill 05/07/20
Southside Bank CD 05/11/20
BBVA Bank CD 06/20/20
East West Bank CD 07/15/20
East West Bank CD 08/04/20
R Bank CD 08/16/20
R Bank CD 08/16/20
LegacyTexas Bank CD 08/21/20
T-Bill 10/08/20
Independent Bank CD 10/18/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Independent Bank CD 04/22/21
Totals
(Continued)
2015 GO-
Roads
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
–$ –$ –$ –$ –$ –$
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
2,505,126 1,529,574 68,505 1,449,455 1,502,181 382,155
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
2,505,126$ 1,529,574$ 68,505$ 1,449,455$ 1,502,181$ 382,155$
Valley View Consulting, L.L.C.1228
City - Allocation
March 31, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 04/01/20
T-Bill 04/16/20
Southside Bank CD 04/17/20
LegacyTexas Bank CD 05/06/20
T-Bill 05/07/20
Southside Bank CD 05/11/20
BBVA Bank CD 06/20/20
East West Bank CD 07/15/20
East West Bank CD 08/04/20
R Bank CD 08/16/20
R Bank CD 08/16/20
LegacyTexas Bank CD 08/21/20
T-Bill 10/08/20
Independent Bank CD 10/18/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Independent Bank CD 04/22/21
Totals
(Continued)
2017 CO
Facilities/ Public
Safety/
Equipment
2017 GO-
Sidewalks
2017 Revenue
Electric
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
–$ –$ –$ –$ –$ –$
– – – – – –
– – – – – –
– – – – – –
– – – 1,001,628 – –
– – – – – –
182,069 380,362 97,239 6,018,195 56,616 924,064
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – 4,899,686 – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – 2,021,284 – –
– – – 1,010,897 – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
182,069$ 380,362$ 97,239$ 14,951,690$ 56,616$ 924,064$
Valley View Consulting, L.L.C.1329
City - Allocation
March 31, 2020
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
East West Bank CD 04/01/20
T-Bill 04/16/20
Southside Bank CD 04/17/20
LegacyTexas Bank CD 05/06/20
T-Bill 05/07/20
Southside Bank CD 05/11/20
BBVA Bank CD 06/20/20
East West Bank CD 07/15/20
East West Bank CD 08/04/20
R Bank CD 08/16/20
R Bank CD 08/16/20
LegacyTexas Bank CD 08/21/20
T-Bill 10/08/20
Independent Bank CD 10/18/20
Independent Bank CD 11/10/20
R Bank CD 11/19/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
East West Bank CD 01/08/21
Independent Bank CD 02/05/21
R Bank CD 02/19/21
Bank OZK CD 02/26/21
Independent Bank CD 04/22/21
Totals
(Continued)
2018 GO-
Parks
2018 GO-
Roads
2019 CO-
Streets/
Facilities/
Equip
2018 CO-
Stormwater
2018 GO-
Roads
–$ –$ –$ –$ –$
– – – – –
– – – – –
– – – – –
– – 4,716,627 – 963,612
– – – – –
559,850 11,604,502 2,605,474 438,996 2,470,336
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
559,850$ 11,604,502$ 7,322,102$ 438,996$ 3,433,948$
Valley View Consulting, L.L.C.1430
City - Allocation
Investment
Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
JPMorgan Chase Cash 8,947,165$ 8,947,165$ –$ –$ –$ –$
JPMorgan Chase MMA 433,724 433,724 – – – –
Veritex Bank MMA 3,192,376 3,192,376 – – – –
NexBank MMA 7,310,083 7,310,083 – – – –
Origin Bank MMA 9,683,133 4,034,639 – – – –
TexPool 32,488,666 32,488,666 – – – –
TexSTAR 57,364,487 11,821,649 762,547 3,499,073 136,642 597,255
WallisBank CD 01/03/20 3,062,607 3,062,607 – – – –
Independent Bank CD 02/03/20 5,182,915 3,109,620 – – – –
East West Bank CD 02/03/20 4,491,891 – – – – –
BBVA Bank CD 02/03/20 2,015,097 – – – – –
R Bank CD 02/15/20 6,131,100 6,131,100 – – – –
R Bank CD 02/16/20 1,005,434 – – – – –
Southside Bank CD 03/13/20 6,120,594 6,120,594 – – – –
East West Bank CD 04/01/20 5,218,095 5,218,095 – – – –
T-Bill 04/16/20 2,488,200 2,488,200 – – – –
Southside Bank CD 04/17/20 2,500,000 2,500,000 – – – –
LegacyTexas Bank CD 05/06/20 4,127,814 4,127,814 – – – –
T-Bill 05/07/20 4,873,475 – – – – –
Southside Bank CD 05/11/20 3,037,471 3,037,471 – – – –
BBVA Bank CD 06/20/20 4,050,654 4,050,654 – – – –
East West Bank CD 07/15/20 5,089,456 5,089,456 – – – –
R Bank CD 08/16/20 2,010,614 – – – – –
LegacyTexas Bank CD 08/21/20 6,133,814 6,133,814 – – – –
T-Bill 10/08/20 2,469,646 2,469,646 – – – –
Independent Bank CD 10/18/20 2,500,000 2,500,000 – – – –
Independent Bank CD 11/10/20 1,012,947 1,012,947 – – – –
Southside Bank CD 11/19/20 3,216,971 3,216,971 – – – –
East West Bank CD 12/09/20 4,004,312 4,004,312 – – – –
Independent Bank CD 04/22/21 4,100,000 4,100,000 – – – –
Totals 204,262,741$ 136,601,603$ 762,547$ 3,499,073$ 136,642$ 597,255$
December 31, 2019
Book Value
Valley View Consulting, L.L.C.1531
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
WallisBank CD 01/03/20
Independent Bank CD 02/03/20
East West Bank CD 02/03/20
BBVA Bank CD 02/03/20
R Bank CD 02/15/20
R Bank CD 02/16/20
Southside Bank CD 03/13/20
East West Bank CD 04/01/20
T-Bill 04/16/20
Southside Bank CD 04/17/20
LegacyTexas Bank CD 05/06/20
T-Bill 05/07/20
Southside Bank CD 05/11/20
BBVA Bank CD 06/20/20
East West Bank CD 07/15/20
R Bank CD 08/16/20
LegacyTexas Bank CD 08/21/20
T-Bill 10/08/20
Independent Bank CD 10/18/20
Independent Bank CD 11/10/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
Independent Bank CD 04/22/21
Totals
December 31, 2019
Book Value
(Continued)
2015 GO-
Roads
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
–$ –$ –$ –$ –$ –$
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
2,496,695 1,003,886 68,274 1,470,406 1,518,041 382,066
– – – – – –
– 518,421 – – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
2,496,695$ 1,522,307$ 68,274$ 1,470,406$ 1,518,041$ 382,066$
Valley View Consulting, L.L.C.1632
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
WallisBank CD 01/03/20
Independent Bank CD 02/03/20
East West Bank CD 02/03/20
BBVA Bank CD 02/03/20
R Bank CD 02/15/20
R Bank CD 02/16/20
Southside Bank CD 03/13/20
East West Bank CD 04/01/20
T-Bill 04/16/20
Southside Bank CD 04/17/20
LegacyTexas Bank CD 05/06/20
T-Bill 05/07/20
Southside Bank CD 05/11/20
BBVA Bank CD 06/20/20
East West Bank CD 07/15/20
R Bank CD 08/16/20
LegacyTexas Bank CD 08/21/20
T-Bill 10/08/20
Independent Bank CD 10/18/20
Independent Bank CD 11/10/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
Independent Bank CD 04/22/21
Totals
December 31, 2019
Book Value
(Continued)
2017 CO
Facilities/ Public
Safety/
Equipment
2017 GO-
Sidewalks
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
–$ –$ –$ –$ –$ –$
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
182,700 1,014,543 7,535,551 56,425 1,550,576 871,680
– – – – – –
– – – – 1,036,557 518,317
– – – – – –
– – – – – –
– – – – –
– – 1,005,434 – – –
– – –– – –
– – –– – –
– – –– – –
– – –– – –
– – –– – –
– – 4,873,475 – – –
– – –– – –
– – –– – –
– – –– – –
– – 2,010,614 – – –
– – –– – –
– – –– – –
– – –– – –
– – –– – –
– – –– – –
– – –– – –
– – –– – –
182,700$ 1,014,543$ 15,425,074$ 56,425$ 2,587,133$ 1,389,997$
Valley View Consulting, L.L.C.1733
City - Allocation
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
WallisBank CD 01/03/20
Independent Bank CD 02/03/20
East West Bank CD 02/03/20
BBVA Bank CD 02/03/20
R Bank CD 02/15/20
R Bank CD 02/16/20
Southside Bank CD 03/13/20
East West Bank CD 04/01/20
T-Bill 04/16/20
Southside Bank CD 04/17/20
LegacyTexas Bank CD 05/06/20
T-Bill 05/07/20
Southside Bank CD 05/11/20
BBVA Bank CD 06/20/20
East West Bank CD 07/15/20
R Bank CD 08/16/20
LegacyTexas Bank CD 08/21/20
T-Bill 10/08/20
Independent Bank CD 10/18/20
Independent Bank CD 11/10/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
Independent Bank CD 04/22/21
Totals
December 31, 2019
Book Value
(Continued)
2018 GO-
Roads
2018 Revenue
Electric
2019 CO-
Streets/
Facilities/
Equip
2018 CO-
Stormwater
2018 GO-
Roads
–$ –$ –$ –$ –$
– – – – –
– – – – –
– – – – –
– – 4,690,268 – 958,227
– – – – –
12,078,691 393,328 6,593,316 439,030 2,795,200
– – – – –
– – – – –
– – 3,482,477 – 1,009,414
2,015,097 – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
14,093,788$ 393,328$ 14,766,061$ 439,030$ 4,762,840$
Valley View Consulting, L.L.C.1834
City - Allocation
December 31, 2019
Market Value Investment
Total Consolidated 2014 Revenue
Water WW Debt Service
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
JPMorgan Chase Cash 8,947,165$ 8,947,165$ –$ –$ –$ –$
JPMorgan Chase MMA 433,724 433,724 – – – –
Veritex Bank MMA 3,192,376 3,192,376 – – – –
NexBank MMA 7,310,083 7,310,083 – – – –
Origin Bank MMA 9,683,133 4,034,639 – – – –
TexPool 32,488,666 32,488,666 – – – –
TexSTAR 57,364,487 11,821,649 762,547 3,499,073 136,642 597,255
WallisBank CD 01/03/20 3,062,607 3,062,607 – – – –
Independent Bank CD 02/03/20 5,182,915 3,109,620 – – – –
East West Bank CD 02/03/20 4,491,891 – – – – –
BBVA Bank CD 02/03/20 2,015,097 – – – – –
R Bank CD 02/15/20 6,131,100 6,131,100 – – – –
R Bank CD 02/16/20 1,005,434 – – – – –
Southside Bank CD 03/13/20 6,120,594 6,120,594 – – – –
East West Bank CD 04/01/20 5,218,095 5,218,095 – – – –
T-Bill 04/16/20 2,488,933 2,488,933 – – – –
Southside Bank CD 04/17/20 2,500,000 2,500,000 – – – –
LegacyTexas Bank CD 05/06/20 4,127,814 4,127,814 – – – –
T-Bill 05/07/20 4,873,868 – – – – –
Southside Bank CD 05/11/20 3,037,471 3,037,471 – – – –
BBVA Bank CD 06/20/20 4,050,654 4,050,654 – – – –
East West Bank CD 07/15/20 5,089,456 5,089,456 – – – –
R Bank CD 08/16/20 2,010,614 – – – – –
LegacyTexas Bank CD 08/21/20 6,133,814 6,133,814 – – – –
T-Bill 10/08/20 2,470,590 2,470,590 – – – –
Independent Bank CD 10/18/20 2,500,000 2,500,000 – – – –
Independent Bank CD 11/10/20 1,012,947 1,012,947 – – – –
Southside Bank CD 11/19/20 3,216,971 3,216,971 – – – –
East West Bank CD 12/09/20 4,004,312 4,004,312 – – – –
Independent Bank CD 04/22/21 4,100,000 4,100,000 – – – –
Totals 204,264,811$ 136,603,279$ 762,547$ 3,499,073$ 136,642$ 597,255$
Valley View Consulting, L.L.C.1935
City - Allocation
December 31, 2019
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
WallisBank CD 01/03/20
Independent Bank CD 02/03/20
East West Bank CD 02/03/20
BBVA Bank CD 02/03/20
R Bank CD 02/15/20
R Bank CD 02/16/20
Southside Bank CD 03/13/20
East West Bank CD 04/01/20
T-Bill 04/16/20
Southside Bank CD 04/17/20
LegacyTexas Bank CD 05/06/20
T-Bill 05/07/20
Southside Bank CD 05/11/20
BBVA Bank CD 06/20/20
East West Bank CD 07/15/20
R Bank CD 08/16/20
LegacyTexas Bank CD 08/21/20
T-Bill 10/08/20
Independent Bank CD 10/18/20
Independent Bank CD 11/10/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
Independent Bank CD 04/22/21
Totals
(Continued)
2015 GO-
Roads
2015 Revenue
Water WW
2016 CO-
Streets/
Facilities/
Equip
2016 GO-
Roads
2016 Revenue
Water/WW
Garey Park
Donation
–$ –$ –$ –$ –$ –$
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
2,496,695 1,003,886 68,274 1,470,406 1,518,041 382,066
– – – – – –
– 518,421 – – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
– –– – – –
2,496,695$ 1,522,307$ 68,274$ 1,470,406$ 1,518,041$ 382,066$
Valley View Consulting, L.L.C.2036
City - Allocation
December 31, 2019
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
WallisBank CD 01/03/20
Independent Bank CD 02/03/20
East West Bank CD 02/03/20
BBVA Bank CD 02/03/20
R Bank CD 02/15/20
R Bank CD 02/16/20
Southside Bank CD 03/13/20
East West Bank CD 04/01/20
T-Bill 04/16/20
Southside Bank CD 04/17/20
LegacyTexas Bank CD 05/06/20
T-Bill 05/07/20
Southside Bank CD 05/11/20
BBVA Bank CD 06/20/20
East West Bank CD 07/15/20
R Bank CD 08/16/20
LegacyTexas Bank CD 08/21/20
T-Bill 10/08/20
Independent Bank CD 10/18/20
Independent Bank CD 11/10/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
Independent Bank CD 04/22/21
Totals
(Continued)
2017 CO
Facilities/ Public
Safety/
Equipment
2017 GO-
Sidewalks
2017 Revenue
Water WW
2018 CO-
Airport
2018 CO-
Streets/
Facilities/
Equip
2018 GO-
Parks
–$ –$ –$ –$ –$ –$
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
182,700 1,014,543 7,535,551 56,425 1,550,576 871,680
– – – – – –
– – – – 1,036,557 518,317
– – – – – –
– – – – – –
– – – – – –
– – 1,005,434 – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – – – – –
– – 4,873,868 – – –
– – –– – –
– – –– – –
– – –– – –
– – 2,010,614 – – –
– – –– – –
– – –– – –
– – –– – –
– – –– – –
– – –– – –
– – –– – –
– – –– – –
182,700$ 1,014,543$ 15,425,467$ 56,425$ 2,587,133$ 1,389,997$
Valley View Consulting, L.L.C.2137
City - Allocation
December 31, 2019
Market Value
JPMorgan Chase Cash
JPMorgan Chase MMA
Veritex Bank MMA
NexBank MMA
Origin Bank MMA
TexPool
TexSTAR
WallisBank CD 01/03/20
Independent Bank CD 02/03/20
East West Bank CD 02/03/20
BBVA Bank CD 02/03/20
R Bank CD 02/15/20
R Bank CD 02/16/20
Southside Bank CD 03/13/20
East West Bank CD 04/01/20
T-Bill 04/16/20
Southside Bank CD 04/17/20
LegacyTexas Bank CD 05/06/20
T-Bill 05/07/20
Southside Bank CD 05/11/20
BBVA Bank CD 06/20/20
East West Bank CD 07/15/20
R Bank CD 08/16/20
LegacyTexas Bank CD 08/21/20
T-Bill 10/08/20
Independent Bank CD 10/18/20
Independent Bank CD 11/10/20
Southside Bank CD 11/19/20
East West Bank CD 12/09/20
Independent Bank CD 04/22/21
Totals
(Continued)
2018 GO-
Roads
2018 Revenue
Electric
2019 CO-
Streets/
Facilities/
Equip
2018 CO-
Stormwater
2018 GO-
Roads
–$ –$ –$ –$ –$
– – – – –
– – – – –
– – – – –
– – 4,690,268 – 958,227
– – – – –
12,078,691 393,328 6,593,316 439,030 2,795,200
– – – – –
– – – – –
– – 3,482,477 – 1,009,414
2,015,097 – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
– – – – –
14,093,788$ 393,328$ 14,766,061$ 439,030$ 4,762,840$
Valley View Consulting, L.L.C.2238
Georgetown Economic Development Corporation (GEDCO)
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
March 31, 2020
Prepared by
Valley View Consulting, L.L.C.
The investment portfolio of the Georgetown Economic Development Corporation (GEDCO) is in compliance with the
Texas Public Funds Investment Act and the Investment Policy and Strategies.
Disclaimer: These reports were compiled using information provided by the City. No procedures were performed to test the accuracy or
completeness of this information. The market values included in these reports were obtained by Valley View Consulting, L.L.C. from
sources believed to be accurate and represent proprietary valuation. Due to market fluctuations these levels are not necessarily reflective
of current liquidation values. Yield calculations are not determined using standard performance formulas, are not representative of total
return yields and do not account for investment advisor fees.
40
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
MMA 2,116,764$ 2,116,764$ 2,125,358$ 2,125,358$ 1.31%
Pools 6,485,764 6,485,764 4,886,433 4,886,433 1.06%
Certificates of Deposit – – 2,000,000 2,000,000 1.70%
8,602,528$ 8,602,528$ 9,011,792$ 9,011,792$ 1.26%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 1.26%Total Portfolio 1.45%
Rolling Three Month Treasury 1.17%Rolling Three Month Treasury 1.38%
Rolling Six Month Treasury 1.39%Rolling Six Month Treasury 1.58%
TexPool 1.00%TexPool 1.31%
Interest income provided in separate report.
December 31, 2019
(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, 2020
Valley View Consulting, L.L.C.
141
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 1.31% 04/01/20 03/31/20 2,125,358$ 2,125,358$ 1.00 2,125,358$ 1 1.31%
TexasDAILY AAAm 1.20% 04/01/20 03/31/20 2,121,273 2,121,273 1.00 2,121,273 1 1.20%
TexSTAR AAAm 0.96% 04/01/20 03/31/20 2,765,160 2,765,160 1.00 2,765,160 1 0.96%
Independent Bank 1.70% 02/05/21 02/05/20 2,000,000 2,000,000 100.00 2,000,000 311 1.70%
9,011,792$ 9,011,792$ 9,011,792$ 70 1.26%
(1) (2)
March 31, 2020
(1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity.
(2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees
are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds.
Valley View Consulting, L.L.C.343
Book & Market 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
Veritex Bank MMA 1.31% 04/01/20 2,116,764$ 2,116,764$ 8,594$ –$ 2,125,358$ 2,125,358$
TexasDAILY 1.20% 04/01/20 2,113,585 2,113,585 7,688 2,121,273 2,121,273
TexSTAR 0.96% 04/01/20 4,372,178 4,372,178 (1,607,019) 2,765,160 2,765,160
Independent Bank 1.70% 02/05/21 2,000,000 2,000,000 2,000,000
TOTAL 8,602,528$ 8,602,528$ 2,016,282$ (1,607,019)$ 9,011,792$ 9,011,792$
December 31, 2019 March 31, 2020
Valley View Consulting, L.L.C.545
Georgetown Transportation Enhancement Corporation (GTEC)
QUARTERLY INVESTMENT REPORT
For the Quarter Ended
March 31, 2020
Prepared by
Valley 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.
46
Summary
Quarter End Results by Investment Category:
Asset Type Book Value Market Value Book Value Market Value Ave. Yield
Pools/MMAs 16,317,230$ 16,317,230$ 19,994,093$ 19,994,093$ 1.15%
CDs/Securities 5,253,984 5,253,984 3,208,607 3,208,607 1.73%
Totals 21,571,214$ 21,571,214$ 23,202,700$ 23,202,700$ 1.23%
Quarter End Average Yield (1) Fiscal Year-to-Date Average Yield (2)
Total Portfolio 1.23%Total Portfolio 1.59%
Rolling Three Month Treasury 1.17%Rolling Three Month Treasury 1.38%
Rolling Six Month Treasury 1.39%Rolling Six Month Treasury 1.58%
TexPool 1.00%TexPool 1.33%
Interest data provided in separate report.
December 31, 2019
(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, 2020
Valley View Consulting, L.L.C.
147
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 1.00% 04/01/20 03/31/20 6,658,162$ 6,658,162$ 1.00 6,658,162$ 1 1.00%
TexSTAR AAAm 0.96% 04/01/20 03/31/20 8,625,460 8,625,460 1.00 8,625,460 1 0.96%
Origin Bank MMA 2.25% 04/01/20 03/31/20 2,028,657 2,028,657 1.00 2,028,657 1 2.25%
Veritex Bank MMA 1.31% 04/01/20 03/31/20 2,681,814 2,681,814 1.00 2,681,814 1 1.31%
East West Bank CD 1.72% 08/04/20 02/04/20 3,208,607 3,208,607 100.00 3,208,607 126 1.73%
23,202,700$ 23,202,700$ 23,202,700$ 18 1.23%
(1) (2)
March 31, 2020
(1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity.
(2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not
considered. The yield for the reporting month is used for bank accounts, pools, and money market funds.
Valley View Consulting, L.L.C.349
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
TexPool 1.00% 04/01/20 8,228,703$ 8,228,703$ –$(1,570,541)$ 6,658,162$ 6,658,162$
TexSTAR 0.96% 04/01/20 3,400,236 3,400,236 5,225,224 8,625,460 8,625,460
Origin Bank MMA 2.25% 04/01/20 2,017,319 2,017,319 11,337 2,028,657 2,028,657
Veritex Bank MMA 1.31% 04/01/20 2,670,972 2,670,972 10,842 2,681,814 2,681,814
R Bank CD 2.67% 02/21/20 3,213,625 3,213,625 (3,213,625)– –
Southside Bank CD 2.68% 02/21/20 2,040,358 2,040,358 (2,040,358)– –
East West Bank CD 1.72% 08/04/20 – – 3,208,607 3,208,607 3,208,607
TOTAL 21,571,214$ 21,571,214$ 8,456,010$ (6,824,525)$ 23,202,700$ 23,202,700$
Market Value Comparison
Coupon/Maturity Face Amount/Qtr to Qtr Face Amount/
Description Discount Date Par Value Market Value Change Par Value Market Value
TexPool 1.00% 04/01/20 8,228,703$ 8,228,703$ (1,570,541)$ 6,658,162$ 6,658,162$
TexSTAR 0.96% 04/01/20 3,400,236 3,400,236 5,225,224 8,625,460 8,625,460
Origin Bank MMA 2.25% 04/01/20 2,017,319 2,017,319 11,337 2,028,657 2,028,657
Veritex Bank MMA 1.31% 04/01/20 2,670,972 2,670,972 10,842 2,681,814 2,681,814
R Bank CD 2.67% 02/21/20 3,213,625 3,213,625 (3,213,625)– –
Southside Bank CD 2.68% 02/21/20 2,040,358 2,040,358 (2,040,358)– –
East West Bank CD 1.72% 08/04/20 – – 3,208,607 3,208,607 3,208,607
TOTAL 21,571,214$ 21,571,214$ 1,631,486$ 23,202,700$ 23,202,700$
December 31, 2019 March 31, 2020
December 31, 2019 March 31, 2020
Valley View Consulting, L.L.C.551
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
25,247.80 -
Airport Federal Aviation
Administration
Texas Department of
Transportation-Aviation
1814GRGTN Runway 18/36 Rehabilitation-
Engineering
- -
Airport Federal Aviation
Administration
Texas Department of
Transportation-Aviation
1814GEORG Runway 18/36 Rehabilitation-
Construction
- -
Airport Federal Aviation
Administration
Texas Department of
Transportation-Aviation
1914GEORG Taxiway Lighting Project 22,860.00 20,574.00
Fire US Department of Homeland
Security
Federal Emergency
Management Agency
EMW-2017-FH-00496 SAFER 491,656.35 368,742.26
Fire Federal Emergency
Management Agency
Texas Department of Public
Safety - TDEM
TEEX Tracy Ryan Deployment
Urban Search and Rescue
(US&R)
- 12,207.45
Planning US Department of Housing &
Urban Development
Williamson County B-17-UC-48-0502 CDBG Sidewalks and Ramps
along 17th St
123,650.75 123,650.75
Planning US Department of Housing &
Urban Development
Williamson County CDBG Home Repair - -
Police Bureau of Justice Assistance N/A KXPIIIA Bullet Proof Vests - Supply
Police with new vests
- -
Police US. Department of Justice N/A TX2460200 Equitable Sharing Agreement 34,791.00 -
Police US. Department of Treasury N/A TX2460200 Equitable Sharing Agreement 11,117.24 12,339.76
Public Works Dept. of Transportation
/Federal Highway
Administration
Texas Department of
Transportation
CSJ-0914-05-187 Highway Planning &
Construction (Austin Ave
Bridge)
12,140.65 -
Public Works Dept. of Transportation
/Federal Highway
Administration
Texas Department of
Transportation
CSJ-0914-05-200,201,202 Highway Planning &
Construction (Williams Dr
Corridor)
- -
Parks Texas Parks and Wildlife
Department (TPWD)
Federal Highway
Administration
RT017010 Recreation San Gabriel Trails $ 173,682.22 -
CITY OF GEORGETOWN
Grant/Federal Funding Report
as of March 31, 2020
Active
52
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 12/31/19 Status Updates ‐ 3/31/20
Cemetery Special Revenue
Fund
Currently cemetery operations are self‐funded through plot
sales of approximately $50K per year. The cemetery is
managed through Parks Administration. In 2015, Council
elected to reserve $75,000 annually for future costs
associated with maintaining the property. The General
Fund has made this transfer in since FY 2016.
There has been no change during this quarter. No change
Unfunded Actuarial Accrued
Liability (UAAL)
Recognizes the outstanding liability for the City’s employee
retirement plan through TMRS. The City contributes
monthly to fund the UAAL, based on an annual percentage
of payroll. Actual % of payroll costs is recognized within
each fund. The UAAL is provided by TMRS and lags one
year.
As of 9/30/2019, the net pension liability is $28.8 million and is
81.41% funded. The 2020 total combined contribution rate is
12.26%. This increase is due to a change in the discount rate.
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/2019 is $3.3 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/2019 are $7.5 million. This
increase is due to more time being earned than used in FY19. In
FY2020, the budgeted reserve was increased to $340,000.
No change
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.
Purchased Power expenses for the cumulative first quarter are on
track compared to the budget for FY2020. Revenues are also
tracking above budget, helping to restore positive cash flow to the
fund.
No change
CITY OF GEORGETOWN
Long-term Commitments, Reservations, and Other Unfunded Liabilities
3/31/2020
53
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 12/31/19 Status Updates ‐ 3/31/20
Airport Maintenance
Fund on‐going maintenance of the Airport grounds,
runways and taxi ways. Terminal and Tower included in
Facilities ISF. An Airport Master Plan was developed to
address long term capital maintenance project
prioritization.
We have none at this time. No change
Americans with Disabilities Act
(ADA) Compliance Needs
As facilities are built or repurposed, meeting ADA
compliance will be included in Project Costs. Funding for
program expansion will be needed (General Fund sources).
The City has an adopted policy, as required by Federal Law,
that it will make reasonable accommodations and
modifications to ensure that people with disabilities have an
equal opportunity to enjoy its programs, services, and
activities. The City does not maintain a reserve for these
modifications.
There are currently no changes to the ADA plan. No change
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 – Contractor has
installed the 8' sidewalk along 7th street from Myrtle to College.
Sidewalk has also been installed along Ash St, College Street, 6th
Street and 8th Streets. Utility relocations along 7th street between
College and Pine are being scheduled at this time. Estimated
completion of the project is the end of March 2020. Austin Ave
Sidewalks (Leander to Hwy 29) – Project is complete and closed
out.
Old Town NE Sidewalk ‐ Contractor has completed 95% of the
project. All sidewalk and pedestrian ramps are in place. TDLR
inspection and walk‐through to be completed in Mid‐May.
Contractor to address any punch list items.
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.
Funding was provided at $394K in the FY20 budget for capital repair
and maintenace covering the full amount of replacement and repair
needs. Projects are underway to complete the items listed.
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.
Staff is preparing the procurement. No change
54
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates ‐ 12/31/19 Status Updates ‐ 3/31/20
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. No change
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.
The IT Director is updating the annual and forecasted allocation
model to absorb the asset. Staff will present a plan in the FY 2021
budget development process.
No change
55