HomeMy WebLinkAboutAudit Committee-Agenda Packets-04/20/2021City 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, April 20, 2021
5:00 p.m.
City Manager’s Conference Room
Third Floor – City Hall
1.CALL TO ORDER
2. APPROVAL OF MINUTES
February 2, 2021
3.REPORTS
Quarterly Investment Report for the quarter ended March 31, 2021
4.ADJOURNMENT
I hereby certify this agenda was posted on City Hall bulletin boards Friday, April
16, 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, February 2, 2021
4:45 p.m.
City Manager’s Conference Room
Third Floor – City Hall
1.CALL TO ORDER
City Secretary Christine Loven called the Audit Committee to order at 4:45 p.m.
on February 2, 2021.
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
December 1, 2020
The minutes were approved as presented.
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
Finance Director Kyle Lester introduced Jennifer Ripka, partner, Weaver and
Tidwell, the City’s auditing firm who gave a high-level overview of the audit. Ms.
Ripka stated the City received an unmodified audit opinion (Independent Auditor's
Report), which is the most favorable audit opinion an entity can receive. Ms. Ripka
noted there were no adjustments or deficiencies, and the City was compliant with
the Single Audit regarding Coronavirus aid, which means the City complied with
the Treasury Department and internal controls.
The Committee thanked Ms. Ripka. There was general discussion of the Single
Audit and Ms. Ripka stated Karen Hines, Kyle Lester, and their staff are good to
work with and do a great job.
4. REPORTS
4a Presentation of the Quarterly Investment Report for the quarter ended
December 31, 2020
City of Colleyville Page 2
Audit Committee Minutes February 2, 2021
Director Lester reviewed the investment report, noting interest earnings have
declined and 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.
5.ADJOURNMENT
The meeting was adjourned at 5:23 p.m.
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 Agenda Date 4/20/2021 Number
Type Report
Department Finance
Title
Quarterly Investment Report for the quarter ended March 31, 2021
Explanation
Cash and Cash Equivalents (local government investment pools) totaled
$58,048,313. Colleyville’s complete portfolio was valued at $75,903,887, and was
allocated as follows:
Instrument Current as of
3/31/2021
Last Quarter as of
12/31/2020
Cash $ 12,001,929 $ 12,748,011
LOGIC (CP Permissible)$ 2,495,425 $ 2,494,641
Other Governmental
Pools
$ 43,550,959 $ 40,143,995
CD’s $ 12,751,375 $ 10,988,173
CDARS $ 1,604,198 $ 1,604,198
Agencies $ 3,500,000 $ 3,500,000
Total Cash & Investments $ 75,903,887 $ 71,489,017
Instrument Current Yield as of
9/30/2020
LOGIC (CP Permissible)0.11 %
Other Governmental
Pools
0.05 %
CD’s 0.68 %
CDARS 0.50 %
Agencies 0.18 %
Total Consolidated Yield 0.20 %
Benchmark Yield: 0.05%
Interest earnings for the quarter were $29,774 compared to $39,784 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.
Attachments
1.Investment Report - March 2021
2.March 2021 Committee Copy
3/31/2021
City of Colleyville, TX
Quarterly Investment Report
Quarterly Investment Report City of Colleyville, TX 3/31/2021
Weighted
12/31/2020 3/31/2021 Change Maturity
Cash 12,748,011$ 12,001,929$ (746,082)$ Liquid
Sweep Account -$ -$ -$ Liquid
LOGIC (CP Permiss.)2,494,641$ 2,495,425$ 785$ Liquid
Other Gov't Pools 40,143,995$ 43,550,959$ 3,406,964$ Liquid
Subtotal 55,386,647$ 58,048,313$ 2,661,667$
CD's 10,998,173$ 12,751,375$ 1,753,202$ 355 days
CDARS 1,604,198$ 1,604,198$ -$ 162 days
Agencies 3,500,000$ 3,500,000$ -$ 582 days
Subtotal 16,102,371$ 17,855,573$ 1,753,202$ 382 days
Total Resources 71,489,017$ 75,903,887$ 4,414,869$
Criteria
Met?
Policy Max 12/31/2020 3/31/2021
U.S. Treasuries 100%0%0%
U.S. Agencies 75%5%5%
CD's 75%15%17%
Local Gov't Pools 75%60%61%
CDARs 75%2%2%
Tri-Pty Repurchase 75%0%0%
Cash/Sweep N/A 18%16%
Where is Colleyville's cash?
Diversity Snapshot vs. Policy Requirements
0%0%10%SEC Registered, No-
Load Mutual Funds
Cash/
Equivalents
Bonds/CDs/Ag
encies
Investments on the move…
Since our last investment report,the City has had four CD's mature,totaling $992,000 in funds.These
CD's had a weighted averagematurity of 398 days and an average return of 1.57%.In response,staff
reinvested all of those proceeds and more in six separate CD's,totaling $2,739,000.Those CD's have a
weighted average maturity of 530 days and an average return of 0.165%.Pool rates are more or less on
par with the 13-week treasury,meaning they're returns are at levels not seen since 2009.Staff will
continue to look for opportunities to maximize cash in our reserve funds by moving them away from
pools.However,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.The Federal Reserve
has indicated their intention to keep interbank borrowing rates low through 2022/2023.
2
Quarterly Investment Report City of Colleyville, TX 3/31/2021
Benchmark =13-Week TreasuryHow do our returns compare?
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.
The City's total consolidated return is 0.20%as of March 31,2021.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 as liquidity needs allow.
0.05%
0.20%
0.05%
0.68%
0.50%
0.18%
0.00%
0.10%
0.20%
0.30%
0.40%
0.50%
0.60%
0.70%
0.80%
13-Wk T Consolidated
Return
Pools CD's CDARS Agencies
3/31/2021
$-
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
3/1/2020 6/1/2020 9/1/2020 12/1/2020 3/1/2021
0.0%
0.2%
0.4%
0.6%
0.8%
1.0%
1.2%
1.4%
1.6%
Historical Return
Return Rate Interest Earned
3
Quarterly Investment Report City of Colleyville, TX 3/31/2021
12/31/2020 3/31/2020
Thru Thru
3/31/2021 3/31/2021
What have we earned the past three months? For the past year?
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 24 months.These CD rates have generally led
our market in that time,although some select callable agencies are beginning to look attractive as well.
The rates on CD's and even some agencies has prompted staff to look closer at those instruments
recently.
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.
$29,774; 0.20%$58,564; 0.37%
Current Total Quarterly Average
How has our portfolio changed over time?
36%
22%24%16%
32%61%58%
61%
10%17%
6%
3%
2%2%
26%
14%5%5%
2018 2019 2020 2021
PORTFOLIO COMPOSITION
Bank Pools CD's CDARS Agencies
4
Quarterly Investment Report City of Colleyville, TX 3/31/2021
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:
What influences our rate of return?
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.
-
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 3/31/2021
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$
Brokered CD (FDIC #58243)250,000$ 10/4/2019 1/19/2021 1.70%4,250$
Brokered CD (FDIC #26876)250,000$ 2/28/2020 3/10/2021 1.40%3,500$
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$
Total Matured 15,543,184$ 1.99%300,271$
APPENDIX
Purchase
Date
Maturity
DatePar Amount
Yield to
Maturity
Total
ReturnInvestment
6
Quarterly Investment Report City of Colleyville, TX 3/31/2021
What have we purchased within the last 12 months?
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$
Brokered CD (NCUA #619)246,000$ 2/21/2021 2/13/2023 0.15%369$
Brokered CD (FDIC #58979)246,000$ 2/19/2021 2/21/2023 0.15%369$
Brokered CD (FDIC #19008)249,000$ 3/30/2021 3/30/2023 0.20%498$
Brokered CD (FDIC #57742)249,000$ 3/30/2021 3/30/2023 0.20%498$
Brokered CD (FDIC #57873)249,000$ 3/31/2021 3/31/2023 0.15%374$
Frost Bank Jumbo CD 1,500,000$ 2/25/2021 2/25/2022 0.16%2,400$
Total Purchased 17,605,474$ 0.55%93,555$
Weighted Average Maturity 520 days
Investment Par Amount
Purchase
Date
Maturity
Date
Yield to
Maturity Total Return
APPENDIX
7
Quarterly Investment Report City of Colleyville, TX 3/31/2021
Full Investment Listing
Brokered CD (FDIC 3511)249,000$ 10/4/2019 4/19/2021 1.90%7,297$
Spirit of Texas Bank CD 1,025,023$ 10/24/2019 4/24/2021 1.85%28,470$
Brokered CD (FDIC #27389)249,000$ 2/11/2020 2/22/2022 1.70%8,605$
Brokered CD (FDIC #57803)247,000$ 2/12/2020 1/31/2022 1.70%8,271$
Brokered CD (FDIC #110)249,000$ 2/14/2020 5/14/2021 1.65%5,122$
Brokered CD (FDIC #34742)249,000$ 2/28/2020 3/21/2022 1.40%7,182$
Brokered CD (FDIC #58665)249,000$ 2/28/2020 9/7/2021 1.55%5,890$
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 (FDIC #19581)250,000$ 3/6/2020 3/21/2022 0.90%4,592$
Brokered CD (NCUA #68712)249,000$ 3/10/2020 9/20/2021 1.00%3,813$
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$
Brokered CD (FDIC #17739)240,204$ 8/28/2020 8/29/2022 0.200%962$
Spirit of Texas Jumbo CD 1,504,091$ 9/9/2020 9/9/2021 0.65%9,777$
CDARS - Worthington 1,604,198$ 9/9/2020 9/9/2021 0.50%8,021$
Brokered CD (FDIC #32992)244,201$ 10/1/2020 4/2/2022 0.186%682$
FFCB Note (3133EMCU4)2,000,000$ 10/13/2020 10/13/2022 0.190%7,600$
Brokered CD (FDIC #148)245,000$ 10/14/2020 10/14/2022 0.150%735$
Brokered CD (NCUA #17587)247,000$ 10/29/2020 10/28/2022 0.25%1,233$
Brokered CD (FDIC #16022)247,000$ 11/9/2020 11/9/2022 0.20%988$
Brokered CD (FDIC #34953)249,000$ 11/16/2020 11/16/2022 0.20%996$
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,019,479$ 12/11/2020 12/10/2021 0.55%5,592$
FFCB Note (3133EMHE5)1,500,000$ 12/11/2020 11/30/2022 0.170%5,023$
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 #8120)247,000$ 12/23/2020 12/23/2022 0.20%988$
Brokered CD (FDIC #58979)246,000$ 2/19/2021 2/21/2023 0.150%66$
Brokered CD (NCUA #619)246,000$ 2/21/2021 2/13/2023 0.150%66$
Frost Bank Jumbo CD 1,500,000$ 2/25/2021 2/25/2022 0.160%71$
Brokered CD (FDIC #19008)249,000$ 3/30/2021 3/30/2023 0.200%89$
Brokered CD (FDIC #57742)249,000$ 3/30/2021 3/30/2023 0.200%89$
Brokered CD (FDIC #57873)249,000$ 3/31/2021 3/31/2023 0.150%66$
Investment Par Amount
Purchase
Date
Maturity
Date
Yield to
Maturity Total Return
APPENDIX
8
Quarterly Investment Report City of Colleyville, TX 3/31/2021
Full Investment Listing (Continued)
Total 17,855,449$ 0.57%152,534$
Weighted Average Maturity 382 days
Investment Par Amount Purchase Date Maturity Date Yield to Maturity Total Return
9
Quarterly Investment Report City of Colleyville, TX 3/31/2021
Mark-to-Market
12/31/2020 3/31/2021
Market Value Market Value
Brokered CD (FDIC #34742)249,000$ 253,064$ 252,185$ 3,185$
Brokered CD (FDIC #27389)249,000$ 253,661$ 252,611$ 3,611$
Brokered CD (FDIC #110)249,000$ 250,489$ 249,488$ 488$
Brokered CD (FDIC #58665)249,000$ 251,577$ 250,626$ 1,626$
Brokered CD (FDIC #57803)247,000$ 251,397$ 250,374$ 3,374$
Brokered CD (FDIC #35546)249,000$ 253,592$ 252,613$ 3,613$
Brokered CD (FDIC #58978)248,000$ 251,023$ 250,386$ 2,386$
Brokered CD (FDIC #33555)248,000$ 250,840$ 250,225$ 2,225$
Brokered CD (FDIC #57565)249,000$ 251,784$ 251,159$ 2,159$
Brokered CD (NCUA #68712)249,000$ 250,723$ 250,113$ 1,113$
Brokered CD (FDIC #19581)250,000$ 252,630$ 251,979$ 1,979$
Brokered CD (FDIC #3511)249,000$ 250,399$ 249,244$ 244$
Spirit of Texas Bank CD 1,019,479$ 1,018,097$ 1,019,479$ -$
Brokered CD (NCUA #60269)249,000$ 249,872$ 249,630$ 630$
Brokered CD (FDIC #23623)250,000$ 250,344$ 250,273$ 273$
Brokered CD (FDIC #33686)249,000$ 249,675$ 249,463$ 463$
Spirit of Texas Jumbo CD 1,504,091$ 1,502,432$ 1,504,091$ -$
CDARS - Worthington 1,604,198$ 1,604,198$ 1,604,198$ -$
Brokered CD (FDIC #16022)247,000$ 247,479$ 247,269$ 269$
Brokered CD (FDIC #8120)247,000$ 247,193$ 247,091$ 91$
Brokered CD (FDIC #33954)256,586$ 256,934$ 255,410$ (1,175)$
Brokered CD (FDIC #4297)256,481$ 256,934$ 255,410$ (1,070)$
Brokered CD (FDIC #34953)249,000$ 249,483$ 249,271$ 271$
Brokered CD (NCUA #17587)247,000$ 247,704$ 247,042$ 42$
Brokered CD (FDIC #845)249,187$ 249,451$ 249,286$ 100$
Brokered CD (FDIC #35141)249,000$ 249,486$ 249,269$ 269$
Spirit of Texas Jumbo CD 1,025,023$ 1,021,861$ 1,025,023$ -$
FFCB Note (3133EMHE5)1,500,000$ 1,499,715$ 1,499,655$ (345)$
FFCB Note (3133EMCU4)2,000,000$ 1,999,300$ 2,000,000$ -$
Brokered CD (FDIC #32992)244,201$ 248,145$ 247,305$ 3,104$
Brokered CD (FDIC #17739)240,204$ 240,451$ 240,276$ 72$
Brokered CD (FDIC #148)245,000$ 245,252$ 245,086$ 86$
Brokered CD (FDIC #58979)246,000$ N/A 245,995$ (5)$
Brokered CD (NCUA #619)246,000$ N/A 246,002$ 2$
Frost Bank Jumbo CD 1,500,000$ N/A 1,500,000$ -$
Brokered CD (FDIC #19008)249,000$ N/A 249,212$ 212$
Brokered CD (FDIC #57742)249,000$ N/A 249,209$ 209$
Brokered CD (FDIC #57873)249,000$ N/A 248,960$ (40)$
Total 17,855,449$ 15,155,184$ 17,884,910$ 29,460$
Unrealized
Gain/(Loss) since
Purchase
APPENDIX
Investment Par Amount
10
Quarterly Investment Report City of Colleyville, TX 3/31/2021
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
11
Quarterly Investment Report
March 2021
April 20, 2021
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.05%
0.20%
0.05%
0.68%
0.50%
0.18%
3/31/2021
13-Wk T Consolidated
Return
Pools CD's CDARS Agencies
0.00%
0.10%
0.20%
0.30%
0.40%
0.50%
0.60%
0.70%
0.80%
12/31/2020:
[VALUE]
03/31/2021:
[VALUE]
Rate of
Return
0.00%
0.05%
0.10%
0.15%
0.20%
0.25%
0.30%
Return Summary
Historical
Return
43891 43983 44075 44166 44256
0.0%
0.5%
1.0%
1.5%
2.0%
$ -
$ 50,000
$ 100,000
$ 150,000
$ 200,000
$ 250,000
$ 300,000
$ 350,000
Return Rate Interest Earned Influence of Federal Funds Rate on
Fixed Income Market
4139441547416984184842001421524230542457426104276342914430674321843371435244367443827439794413244283 -
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 03/31 Value Total Gain (loss) on
Purchase Price
$ 17,855,449 $ 17,884,910 $ 29,460
Questions/Comments