HomeMy WebLinkAboutAudit Committee-Agenda Packets-02/02/2021
City of Colleyville Page 1
City of Colleyville
Audit Committee
Agenda
City Hall
100 Main Street
Colleyville, Texas 76034
817.503.1000
www.colleyville.com
Tuesday, February 2, 2021
4:45 p.m.
City Manager’s Conference Room
Third Floor – City Hall
1. CALL TO ORDER
2. APPROVAL OF MINUTES
December 1, 2020
3. REGULAR AGENDA ITEMS
3a Discuss preliminary draft of FY20 Comprehensive Annual Financial
Report and Federal Single Audit Reports for Year Ended September
30, 2020
4. REPORTS
4a Presentation of the Quarterly Investment Report for the quarter
ended December 30, 2020
5. ADJOURNMENT
I hereby certify this agenda was posted on City Hall bulletin boards Friday,
January 29, 2021, by 5:00 p.m.
Christine Loven, TRMC
City Secretary
A quorum of the Colleyville City Council and/or any other Colleyville Board,
Commission, or Committee may be in attendance at this meeting.
Any matter on this agenda may, at the discretion of the governing body, be
opened for public comment and discussion.
If you plan to attend this public meeting and have a disability that requires special
accommodations, please advise Executive Secretary at least 48 hours in advance
at 817.503.1111, and reasonable accommodations will be made to assist you.
City of Colleyville Page 1
City of Colleyville
Audit Committee
Minutes
City Hall
100 Main Street
Colleyville, Texas 76034
817.503.1000
www.colleyville.com
Tuesday, December 1, 2020 City Manager’s Conference Room
4:30 p.m. Third Floor – City Hall
1.CALL TO ORDER
City Secretary Christine Loven called the meeting to order at 4:30 p.m.
ROLL CALL: Committee members present George Dodson, Bobby Lindamood and
Chuck Kelley.
Also Present: Finance Director Kyle Lester, Accounting Manager Karen Hines, City
Manager Jerry Ducay, Assistant City Manager Mark Wood, and City Secretary
Christine Loven
2. APPROVAL OF MINUTES
July 21, 2020
The minutes were motioned for approval by Member Dodson, seconded by Member
Lindamood and passed unanimously.
3.REGULAR AGENDA ITEMS
3a Approval of the annual review and updates to the City of
Colleyville Investment Policy
Finance Director Kyle Lester stated the Public Funds Investment Act requires the
City, as the governing body of a public entity, review the investment strategy and
adopt a written instrument by resolution stating it has reviewed the investment
policy and investment strategies. Director Lester noted during his review of the
Investment Policy, he discovered one change, which was overlooked for deletion
in the previous policy, which is the SEC, registered, no load money market
mutual funds listed under the Diversification of Portfolio by Instrument. He
explained the Local Government Investment Pools fall under the category of a
"money market mutual fund". Because they are specifically mentioned in the
diversification section, it is not necessary to include money market mutual funds
as a category.
The members agreed with the recommendation and then discussed
recommending reducing the maximum percentage of repurchase agreements to
15%. Director Lester stated the 15% is reasonable and will advise City Council of
the recommendation.
3b Quarterly Investment Report for the quarter ended September 30,
City of Colleyville Page 2
Audit Committee Minutes December 1, 2020
2020
Finance Director Kyle Lester reviewed the quarterly investment report and noted
rates are still falling due to the pandemic, but the City is stilling doing well.
There was general discussion regarding the sweep accounts, investments in CD’s,
and pools.
There was a recommendation the City review if there would be a substantial
saving interest is the CEDC bond was called. Director Lester said he would
investigate the strategy.
3c Update from the City's auditors
Kristen Derryberry, Senior Manager, Weaver and Tidwell, the City’s auditors,
provided an update on the audit. Ms. Derryberry thanked Finance Director Kyle
Lester and Account Manager Karen Hines, and the Finance Department staff for
consistently working with them efficiently and effectively.
Ms. Derryberry stated the draft preliminary audit would be presented to the Audit
Committee in February 2021.
4.ADJOURNMENT
The meeting was adjourned at 4:59 p.m.
PASSED BY A VOTE OF AYES, NAYS, AND ABSTENTIONS, THIS 2ND DAY OF
FEBRUARY 2021.
Minutes taken and prepared by:
Christine Loven, TRMC
City Secretary
City of Colleyville Page 1
City of Colleyville
Audit Committee
Agenda Briefing
City Hall
100 Main Street
Colleyville, Texas 76034
www.colleyville.com
Agenda Number 3a Agenda Date 2/2/2021 Number
Type Regular Agenda Items
Department Finance
Title
Discuss preliminary draft of FY20 Comprehensive Annual Financial Report
and Federal Single Audit Reports for Year Ended September 30, 2020
Explanation
This item provides for an update from the auditor on the preliminary draft of FY20
Comprehensive Annual Financial Report and Federal Single Audit Reports for Year
Ended September 30, 2020.
Attachments
City of Colleyville Page 1
City of Colleyville
Audit Committee
Agenda Briefing
City Hall
100 Main Street
Colleyville, Texas 76034
www.colleyville.com
Agenda Number 4a Agenda Date 2/2/2021 Number
Type Report
Department Finance
Title
Presentation of the Quarterly Investment Report for the quarter ended December
31, 2020
Explanation
Cash and Cash Equivalents (local government investment pools) totaled
$64,016,191. Colleyville’s complete portfolio was valued at $75,846,200, and was
allocated as follows:
Instrument Current as of
12/31/2020
Last Quarter as of
9/30/2020
Cash $ 12,748,011 $ 9,888,128
LOGIC (CP Permissible)$ 2,494,641 $ 2,493,914
Other Governmental
Pools
$ 40,143,995 $ 51,634,149
CD’s $ 10,988,173 $ 10,225,854
CDARS $ 1,604,198 $ 1,604,155
Agencies $ 3,500,000 $ -
Total Cash & Investments $ 71,489,017 $ 75,846,200
Instrument Current Yield as of
9/30/2020
LOGIC (CP Permissible)0.17 %
Other Governmental
Pools
0.11 %
CD’s 0.89 %
CDARS 0.50 %
Agencies 0.18 %
Total Consolidated Yield 0.27 %
Benchmark Yield: 0.09%
Interest earnings for the quarter were $39,784 compared to $60,990 in the
previous quarter. This decrease is reflective of a declining interest rate market as
well as several maturities coming due in the last quarter. Staff will continue to
examine cash-flow needs and place our resources in instruments with an emphasis
on keeping these funds safe while earning as strong a yield as possible.
Audit Committee Agenda Briefing 4a
City of Colleyville Page 2
Attachments
1.December 2020 Committee Copy
2.Investment Report - December 2020
Quarterly Investment Report
December 2020
December 1, 2020
As required by the Public Funds Investment Act, §2256.023
Cash Position Overview
[PERCENTAGE
]
[PERCENTAGE
]
[PERCENTAGE
]
[PERCENTAGE
]
Cash/Sweep Pools CD/CDARS Agencies
Return Summary
0.09%
0.27%
0.11%
0.89%
0.50%
0.18%
12/31/2020
13-Wk T Consolidated
Return
Pools CD's CDARS Agencies
0.00%
0.20%
0.40%
0.60%
0.80%
1.00%
9/30/2020:
[VALUE]
12/31/2020:
[VALUE]
Rate of
Return
0.00%
0.05%
0.10%
0.15%
0.20%
0.25%
0.30%
0.35%
0.40%
Return Summary
Historical
Return
43800 43891 43983 44075 44166
0.0%
0.5%
1.0%
1.5%
2.0%
$ -
$ 50,000
$ 100,000
$ 150,000
$ 200,000
$ 250,000
$ 300,000
$ 350,000
$ 400,000
Return Rate Interest Earned
Influence of Federal Funds Rate on Fixed
Income Market
4130441455416084175941912420634221342366425184267142822429754312843279434324358343736438894404044193 -
0.50
1.00
1.50
2.00
2.50
3.00
13-Wk Coupon Fed Funds Rate Avg Pools
Mark-to-Market
Public Funds Investment Act Requirement
Mark-to-Market: A snapshot of what our investments would sell at compared to
what we purchased them for.
•Purpose is to show our overall portfolio value
•We hold our investments until maturity (“buy and hold” strategy)
•Gains and losses shown in this analysis are unrealized
Par Value 12/31 Value Total Gain (loss) on
Purchase Price
$ 16,102,247 $ 16,149,593 $ 47,346
Questions/Comments
12/31/2020
City of Colleyville, TX
Quarterly Investment Report
Quarterly Investment Report City of Colleyville, TX 12/31/2020
Weighted
9/30/2020 12/31/2020 Change Maturity
Cash 9,888,128$ 12,748,011$ 2,859,883$ Liquid
Sweep Account -$ -$ -$ Liquid
LOGIC (CP Permiss.)2,493,914$ 2,494,641$ 726$ Liquid
Other Gov't Pools 51,634,149$ 40,143,995$ (11,490,154)$ Liquid
Subtotal 64,016,191$ 55,386,647$ (8,629,544)$
CD's 10,225,854$ 10,998,173$ 772,319$ 372 days
CDARS 1,604,155$ 1,604,198$ 43$ 252 days
Agencies -$ 3,500,000$ 3,500,000$ 672 days
Subtotal 11,830,009$ 16,102,371$ 4,272,362$ 425 days
Total Resources 75,846,200$ 71,489,017$ (4,357,182)$
Criteria
Met?
Policy Max 9/30/2020 12/31/2020
U.S. Treasuries 100%0%0%
U.S. Agencies 75%0%5%
CD's 75%13%15%
Local Gov't Pools 75%71%60%
CDARs 75%2%2%
Tri-Pty Repurchase 75%0%0%
Cash/Sweep N/A 13%18%
Cash/
Equivalents
Bonds/CDs/Ag
encies
Investments on the move…
Since our last investment report,the City has had nine CD's mature,including a jumbo CD held with
Spirit of Texas Bank.In total,$2.98 million in investments matured at a weighted average rate of 1.78%.
In response,staff reinvested $6.5 million in CD's and two agency bonds at a weighted average rate of
0.25%.In the current rate environment,the returns were as competitive as staff could find.With the
City's cash-funded capital improvement program in its early stages,the City is expected to transition to
higher liquidity,meaning lower balances in investments.Agencies and CD's will be sought out for
operating funds,but the large dollar amounts sitting in our capital funds will need to be in investment
pools or the bank.With the Federal Reserve indicating they will keep interbank borrowing rates low
through 2022/2023, we expect low returns over the next few years.
Diversity Snapshot vs. Policy Requirements
0%0%10%SEC Registered, No-
Load Mutual Funds
Where is Colleyville's cash?
2
Quarterly Investment Report City of Colleyville, TX 12/31/2020
Benchmark =13-Week Treasury
The City's total consolidated return is 0.27%as of December 31,2020.While low,this does compare
favorably with the 13-week treasury note benchmark put in place by Colleyville's investment policy.
The biggest reason for this is the COVID-19 pandemic,which prompted a a rate cut at the Federal
Reserve affecting our pool and sweep account rates.Additionally,stock market volatility urged
investors to flock to the fixed income markets,which further decreased returns.While currently heavily
invested in pools, staff will seek out agencies to diversify our portfolio.
Before the recent downturn Colleyville's investment returns had been climbing steadily since 2016,
primary due to to more active investment practices.Although we are in a down-cycle in terms of
returns,we've still been able to stay ahead of our 13-week treasury benchmark.Most importantly,
Colleyville's funds are safe.While staff will continue to seek a solid yield on the portfolio,the highest
value is placed on maintaining a low risk in order to ensure the safety and liquidity of the funds
entrusted to us.
How do our returns compare?
0.09%
0.27%
0.11%
0.89%
0.50%
0.18%
0.00%
0.20%
0.40%
0.60%
0.80%
1.00%
13-Wk T Consolidated
Return
Pools CD's CDARS Agencies
12/31/2020
$-
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
12/1/2019 3/1/2020 6/1/2020 9/1/2020 12/1/2020
0.0%
0.2%
0.4%
0.6%
0.8%
1.0%
1.2%
1.4%
1.6%
1.8%
2.0%
Historical Return
Return Rate Interest Earned
3
Quarterly Investment Report City of Colleyville, TX 12/31/2020
9/30/2020 1/1/2020
Thru Thru
12/31/2020 12/31/2020
Compared to the average quarterly return for the past 12 months,the most recent quarter is showing a
substantial decrease in both the rate of return and actual dollars earned.As noted,fixed-income rates
have come down considerably as investors have flocked to the fixed income market amidst the global
pandemic.Additionally,a robust,5-year capital improvement plan has begun,necessitating higher
liquidity than in previous years.Hopefully we won't see rates dip much lower,although there is no
guarantee.Regardless,staff will always monitor the market and manage Colleyville's portfolio with
emphasis on diversity and cash-flow needs.
$39,784; 0.27%$128,504; 0.68%
Current Total Quarterly Average
How has our portfolio changed over time?
As the graph above shows,the City had begun moving its investments away from agency securities and
more toward local government pools from 2017 through 2019.Money stored in these pools tended to
earn a decent return compared to market while also being considered "liquid",as the City can withdraw
its funds within 24 hours in most cases.However,the past two years has also brought a resurgence of
higher certificate of deposit returns.While not heavily invested in CD's from a percentage standpoint,
staff has been seeking out these instruments in the past 12 months.These CD rates have generally led
our market in that time,although callable agencies are beginning to look more attractive.The rates on
CD's and even some agencies has prompted staff to look closer at those instruments recently.
What have we earned the past three months? For the past year?
36%
22%24%18%
32%58%62%
60%
7%15%
6%
3%
2%2%
26%17%
6%5%
2017 2018 2019 2020
PORTFOLIO COMPOSITION
Bank Pools CD's CDARS Agencies
4
Quarterly Investment Report City of Colleyville, TX 12/31/2020
For any questions or comments on this report, please contact Also included:
Kyle Lester, CGFO Maturities/Purchases
City of Colleyville, TX Investment Listing
Finance Director 817-503-1014 Mark-to-Market
klester@colleyville.com
Signed:
This investment report is in compliance with the Public Funds Investment Act as well as the City of
Colleyville's investment policy and procedures.
Per State law,Colleyville is only permitted to invest in certain fixed income securities,whos
performance ties closely with the Federal Funds rate.As the chart above shows,the rates of our 13-
week treasury benchmark as well as our pools tend to move in lock-step with the Federal Reserve's
rate actions.This rate was cut five times in the past year and now remains at close to 0.How long it
will remain there depends on the duration of our decreased economic activity,although we can
likely expect very low rates through 2022 and potentially 2023.
What influences our rate of return?
-
0.50
1.00
1.50
2.00
2.50
3.00
Influence of Federal Funds Rate on Fixed Income Market
13-Wk Coupon Fed Funds Rate Avg Pools
5
Quarterly Investment Report City of Colleyville, TX 12/31/2020
What has matured in the last 12 months?
FFCB Note(3133EJCN7)1,000,000$ 2/14/2018 2/14/2020 2.07%20,700$
FHLB Note(3130ADN32)1,000,000$ 3/7/2018 2/11/2020 2.13%21,273$
FFCB Note(3133EJHL6)1,000,000$ 4/9/2018 3/27/2020 2.30%22,984$
Brokered CD (FDIC #26610)248,000$ 9/14/2018 3/16/2020 2.55%6,324$
Brokered CD (FDIC #7213)248,000$ 3/29/2018 3/30/2020 2.50%6,200$
Brokered CD (FDIC #33214)248,000$ 4/11/2018 4/13/2020 2.55%12,700$
FHLB Note (313383HU8)500,000$ 8/16/2019 6/12/2020 1.75%7,216$
Brokered CD (FDIC #32992)245,000$ 9/19/2019 9/25/2020 1.80%4,495$
Brokered CD (FDIC #34221)245,000$ 9/19/2019 9/25/2020 1.80%4,495$
Brokered CD (FDIC #34775)245,000$ 9/19/2019 9/25/2020 1.85%4,619$
Brokered CD (FDIC #16022)249,675$ 9/18/2019 9/11/2020 1.75%4,297$
State of Texas Note (882724PY7)2,515,325$ 3/23/2020 8/27/2020 2.50%27,059$
CDARS - Worthington 1,575,617$ 9/18/2019 9/17/2020 1.80%28,361$
FAMCA Note (3130A94N8)2,000,000$ 12/4/2019 5/25/2020 1.71%59,030$
Brokered CD (FDIC #628)248,000$ 2/11/2020 7/31/2020 1.75%1,784$
Brokered CD (FDIC #16571)247,000$ 9/19/2019 10/20/2020 1.80%4,446$
Brokered CD (FDIC #35141)247,000$ 9/19/2019 10/27/2020 1.85%4,570$
Brokered CD (FDIC #2270)247,000$ 9/19/2019 12/24/2020 1.80%4,446$
Brokered CD (FDIC #58647)245,000$ 10/4/2019 10/9/2020 1.75%4,288$
Brokered CD (FDIC #27237)245,000$ 10/4/2019 10/9/2020 1.75%4,288$
Brokered CD (FDIC #12855)245,000$ 10/4/2019 10/9/2020 1.75%4,288$
Brokered CD (FDIC #58658)249,000$ 10/4/2019 10/9/2020 1.75%4,358$
Brokered CD (FDIC #57777)245,000$ 10/4/2019 10/16/2020 1.75%4,288$
Spirit of Texas Jumbo CD 1,013,567$ 12/5/2019 12/5/2020 1.79%18,143$
Total Matured 14,551,184$ 2.01%284,649$
APPENDIX
Purchase
Date
Maturity
DatePar Amount
Yield to
Maturity
Total
ReturnInvestment
6
Quarterly Investment Report City of Colleyville, TX 12/31/2020
What have we purchased within the last 12 months?
Brokered CD (FDIC #26876)250,000$ 2/28/2020 3/10/2021 1.40%3,500$
Brokered CD (FDIC #34742)249,000$ 2/28/2020 3/21/2022 1.40%3,486$
Brokered CD (FDIC #628)248,000$ 2/11/2020 1/31/2022 1.75%4,340$
Brokered CD (FDIC #27389)249,000$ 2/11/2020 2/22/2022 1.70%4,233$
Brokered CD (FDIC #110)249,000$ 2/14/2020 5/14/2021 1.65%4,109$
Brokered CD (FDIC #58665)249,000$ 2/28/2020 9/7/2021 1.55%3,860$
Brokered CD (FDIC #57803)247,000$ 2/12/2020 1/31/2022 1.70%4,199$
Brokered CD (FDIC #58577)246,000$ 2/6/2020 2/12/2021 1.60%3,936$
Brokered CD (FDIC #18503)246,000$ 2/6/2020 2/12/2021 1.60%3,936$
Brokered CD (FDIC #35546)249,000$ 2/28/2020 3/28/2022 1.55%3,860$
Brokered CD (FDIC #58978)248,000$ 3/6/2020 3/28/2022 1.05%2,604$
Brokered CD (FDIC #33555)248,000$ 3/6/2020 3/21/2022 0.98%2,418$
Brokered CD (FDIC #57565)249,000$ 3/6/2020 3/11/2022 1.00%2,490$
Brokered CD (NCUA #68712)249,000$ 3/10/2020 9/20/2021 1.00%2,490$
Brokered CD (FDIC #19581)250,000$ 3/6/2020 3/21/2022 0.90%2,250$
State of Texas Note (882724PY7)2,515,325$ 3/23/2020 8/27/2020 1.71%42,896$
Brokered CD (NCUA #60269)249,000$ 8/10/2020 8/18/2022 0.30%1,510$
Brokered CD (FDIC #23623)250,000$ 8/24/2020 2/24/2022 0.20%752$
Brokered CD (FDIC #33686)249,000$ 8/26/2020 8/26/2022 0.20%996$
Spirit of Texas Jumbo CD 1,502,432$ 9/9/2020 9/9/2021 0.65%9,750$
CDARS - Worthington 1,604,198$ 9/9/2020 9/9/2021 0.50%8,021$
Brokered CD (FDIC #16022)247,000$ 11/9/2020 11/9/2022 0.20%494$
Brokered CD (FDIC #8120)247,000$ 12/23/2020 12/23/2022 0.20%494$
Brokered CD (FDIC #33954)256,586$ 12/22/2020 10/12/2022 0.20%513$
Brokered CD (FDIC #4297)256,481$ 12/22/2020 10/12/2022 0.20%513$
Brokered CD (FDIC #34953)249,000$ 11/16/2020 11/16/2022 0.20%498$
Brokered CD (NCUA #17587)247,000$ 10/29/2020 10/28/2022 0.25%618$
Brokered CD (FDIC #845)249,187$ 11/20/2020 6/27/2022 0.20%498$
Brokered CD (FDIC #35141)249,000$ 11/20/2020 11/21/2022 0.20%498$
Spirit of Texas Jumbo CD 1,021,861$ 12/11/2020 12/10/2021 0.55%5,600$
FFCB Note (3133EMHE5)1,500,000$ 12/11/2020 11/30/2022 0.170%2,550$
FFCB Note (3133EMCU4)2,000,000$ 10/13/2020 10/13/2022 0.190%3,800$
Brokered CD (FDIC #32992)244,201$ 10/1/2020 4/2/2022 0.186%454$
Brokered CD (FDIC #17739)240,204$ 8/28/2020 8/29/2022 0.200%480$
Brokered CD (FDIC #148)245,000$ 10/14/2020 10/14/2022 0.150%368$
Total Purchased 17,348,474$ 0.75%133,013$
Weighted Average Maturity 527 days
APPENDIX
Investment Par Amount
Purchase
Date
Maturity
Date
Yield to
Maturity Total Return
7
Quarterly Investment Report City of Colleyville, TX 12/31/2020
Full Investment Listing
Brokered CD (FDIC #26876)250,000$ 2/28/2020 3/10/2021 1.40%3,605$
Brokered CD (FDIC #34742)249,000$ 2/28/2020 3/21/2022 1.40%7,182$
Brokered CD (FDIC #27389)249,000$ 2/11/2020 2/22/2022 1.70%8,605$
Brokered CD (FDIC #110)249,000$ 2/14/2020 5/14/2021 1.65%5,122$
Brokered CD (FDIC #58665)249,000$ 2/28/2020 9/7/2021 1.55%5,890$
Brokered CD (FDIC #57803)247,000$ 2/12/2020 1/31/2022 1.70%8,271$
Brokered CD (FDIC #58577)246,000$ 2/6/2020 2/12/2021 1.60%4,011$
Brokered CD (FDIC #18503)246,000$ 2/6/2020 2/12/2021 1.60%4,011$
Brokered CD (FDIC #35546)249,000$ 2/28/2020 3/28/2022 1.55%8,026$
Brokered CD (FDIC #58978)248,000$ 3/6/2020 3/28/2022 1.05%5,365$
Brokered CD (FDIC #33555)248,000$ 3/6/2020 3/21/2022 0.98%4,935$
Brokered CD (FDIC #57565)249,000$ 3/6/2020 3/11/2022 1.00%5,014$
Brokered CD (NCUA #68712)249,000$ 3/10/2020 9/20/2021 1.00%3,813$
Brokered CD (FDIC #19581)250,000$ 3/6/2020 3/21/2022 0.90%4,592$
Brokered CD (FDIC 3511)249,000$ 10/4/2019 4/19/2021 1.90%7,297$
Brokered CD (FDIC 58243)250,000$ 10/4/2019 1/19/2021 1.70%5,508$
Spirit of Texas Bank CD 1,018,097$ 10/24/2019 4/24/2021 1.85%28,278$
Brokered CD (NCUA #60269)249,000$ 8/10/2020 8/18/2022 0.30%1,510$
Brokered CD (FDIC #23623)250,000$ 8/24/2020 2/24/2022 0.20%752$
Brokered CD (FDIC #33686)249,000$ 8/26/2020 8/26/2022 0.20%996$
Spirit of Texas Jumbo CD 1,502,432$ 9/9/2020 9/9/2021 0.65%9,766$
CDARS - Worthington 1,604,198$ 9/9/2020 9/9/2021 0.50%8,021$
Brokered CD (FDIC #16022)247,000$ 11/9/2020 11/9/2022 0.20%988$
Brokered CD (FDIC #8120)247,000$ 12/23/2020 12/23/2022 0.20%988$
Brokered CD (FDIC #33954)256,586$ 12/22/2020 10/12/2022 0.20%927$
Brokered CD (FDIC #4297)256,481$ 12/22/2020 10/12/2022 0.20%926$
Brokered CD (FDIC #34953)249,000$ 11/16/2020 11/16/2022 0.20%996$
Brokered CD (NCUA #17587)247,000$ 10/29/2020 10/28/2022 0.25%1,233$
Brokered CD (FDIC #845)249,187$ 11/20/2020 6/27/2022 0.20%797$
Brokered CD (FDIC #35141)249,000$ 11/20/2020 11/21/2022 0.20%997$
Spirit of Texas Jumbo CD 1,021,861$ 12/11/2020 12/10/2021 0.55%5,605$
FFCB Note (3133EMHE5)1,500,000$ 12/11/2020 11/30/2022 0.170%5,023$
FFCB Note (3133EMCU4)2,000,000$ 10/13/2020 10/13/2022 0.190%7,600$
Brokered CD (FDIC #32992)244,201$ 10/1/2020 4/2/2022 0.186%682$
Brokered CD (FDIC #17739)240,204$ 8/28/2020 8/29/2022 0.200%962$
Brokered CD (FDIC #148)245,000$ 10/14/2020 10/14/2022 0.150%735$
16,102,247$ 0.70%169,032$
Weighted Average Maturity 425 days
APPENDIX
Total ReturnInvestmentPar Amount
Purchase
Date
Maturity
Date
Yield to
Maturity
8
Quarterly Investment Report City of Colleyville, TX 12/31/2020
Mark-to-Market
9/30/2020 12/31/2020
Market Value Market Value
Brokered CD (FDIC #26876)250,000$ 251,489$ 250,936$ 936$
Brokered CD (FDIC #34742)249,000$ 253,721$ 253,064$ 4,064$
Brokered CD (FDIC #27389)249,000$ 254,518$ 253,661$ 4,661$
Brokered CD (FDIC #110)249,000$ 251,440$ 250,489$ 1,489$
Brokered CD (FDIC #58665)249,000$ 252,416$ 251,577$ 2,577$
Brokered CD (FDIC #57803)247,000$ 252,278$ 251,397$ 4,397$
Brokered CD (FDIC #58577)246,000$ 247,417$ 246,455$ 455$
Brokered CD (FDIC #18503)246,000$ 247,417$ 246,455$ 455$
Brokered CD (FDIC #35546)249,000$ 254,336$ 253,592$ 4,592$
Brokered CD (FDIC #58978)248,000$ 251,467$ 251,023$ 3,023$
Brokered CD (FDIC #33555)248,000$ 251,244$ 250,840$ 2,840$
Brokered CD (FDIC #57565)249,000$ 252,197$ 251,784$ 2,784$
Brokered CD (NCUA #68712)249,000$ 251,214$ 250,723$ 1,723$
Brokered CD (FDIC #19581)250,000$ 252,897$ 252,630$ 2,630$
Brokered CD (FDIC 3511)249,000$ 251,515$ 250,399$ 1,399$
Brokered CD (FDIC 58243)250,000$ 251,241$ 250,563$ 563$
Spirit of Texas Bank CD 1,018,097$ 1,017,163$ 1,018,097$ -$
Brokered CD (NCUA #60269)249,000$ 249,759$ 249,872$ 872$
Brokered CD (FDIC #23623)250,000$ 250,317$ 250,344$ 344$
Brokered CD (FDIC #33686)249,000$ 249,525$ 249,675$ 675$
Spirit of Texas Jumbo CD 1,502,432$ 1,500,000$ 1,502,432$ -$
CDARS - Worthington 1,604,198$ 1,604,155$ 1,604,198$ -$
Brokered CD (FDIC #16022)247,000$ N/A 247,479$ 479$
Brokered CD (FDIC #8120)247,000$ N/A 247,193$ 193$
Brokered CD (FDIC #33954)256,586$ N/A 256,934$ 349$
Brokered CD (FDIC #4297)256,481$ N/A 256,934$ 454$
Brokered CD (FDIC #34953)249,000$ N/A 249,483$ 483$
Brokered CD (NCUA #17587)247,000$ N/A 247,704$ 704$
Brokered CD (FDIC #845)249,187$ N/A 249,451$ 264$
Brokered CD (FDIC #35141)249,000$ N/A 249,486$ 486$
Spirit of Texas Jumbo CD 1,021,861$ N/A 1,021,861$ -$
FFCB Note (3133EMHE5)1,500,000$ N/A 1,499,715$ (285)$
FFCB Note (3133EMCU4)2,000,000$ N/A 1,999,300$ (700)$
Brokered CD (FDIC #32992)244,201$ N/A 248,145$ 3,944$
Brokered CD (FDIC #17739)240,204$ 240,204$ 240,451$ 247$
Brokered CD (FDIC #148)245,000$ N/A 245,252$ 252$
16,102,247$ 9,137,931$ 16,149,593$ 47,346$
APPENDIX
Investment Par Amount
Unrealized
Gain/(Loss) since
Purchase
9
Quarterly Investment Report City of Colleyville, TX 12/31/2020
Note about mark-to-market:This analysis takes a snapshot look at each of the securities Colleyville
holds and values them based on what the market would pay for them today.An unrealized gain in
market value would indicate the security's value has gone up since the last mark-to-market,and an
unrealized loss would indicate the value has gone down.However,the City of Colleyville's strategy is to
buy securities and hold them to maturity to receive the agreed-upon interest payments (known as "buy
and hold").Therefore,any change in market value will not be realized by the City.The primary purpose
of this analysis,as required by the Public Funds Investment Act,is to demonstrate the current market
value of the City's portfolio should we need to liquidate it in the case of an emergency.This scenario is
extremely unlikely,given the prudence Colleyville's leaders have shown in their financial decisions.It is
important to remember this when looking at our quarterly mark-to-market analysis.
APPENDIX
10