HomeMy WebLinkAboutAudit Committee-Agenda Packets-02/04/2020City 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 4, 2020
5:00 p.m.
City Manager’s Conference Room
Third Floor – City Hall
1.CALL TO ORDER
2.APPROVAL OF MINUTES
August 20, 2019
November 19, 2019
3.REGULAR AGENDA ITEMS
3a Discuss preliminary draft of FY19 Comprehensive Annual Financial
Report
4.REPORTS
Presentation of the Quarterly Investment Report for the quarter
ended December 30, 2019
5.ADJOURNMENT
I hereby certify this agenda was posted on City Hall bulletin boards Friday,
January 31, 2020, 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, August 20, 2019
5:00 p.m.
City Manager’s Conference Room
Third Floor – City Hall
1. CALL TO ORDER
Accounting Manager Karen Hines called the Audit Committee to order on August
20, 2019 at 5:03 p.m.
ROLL CALL: Committee members present George Dodson, Kathy Wheat, Bobby
Lindamood arrived at 5:09 p.m.
Absent: Susan Mathisen, Bobby Lindamood
Also Present: Accounting Manager Karen Hines City Manager Jerry Ducay,
Assistant City Manager Mark Wood, and City Secretary Christine Loven
2. APPROVAL OF MINUTES
March 5, 2019
May 14, 2019
As there was not a quorum present, this item was passed over until 5:16 p.m. –
after member Bobby Lindamood’s arrival.
Member Dodson moved to approve the March 5 and May 14, 2019 minutes;
seconded by member Wheat, passed unanimously.
3. REGULAR AGENDA ITEMS
3a Discuss the Fiscal Year September 30, 2019 audit which will be conducted
by the City’s audit firm Weaver and Tidwell
Manager Hines stated the auditors are in City offices this week performing an
interim audit and testing internal controls, and will return in November to begin
the full audit.
Member Bobby Lindamood arrived during discussion of this item at 5:09 p.m.
3b Presentation of the Quarterly Investment Report for the quarter ended
June 30, 2019
Manager Hines provided an overview of the investment report and noted the new
Finance Director Kyle Lester will begin in September and will be looking over the
City of Colleyville Page 2
Audit Committee Agenda August 20, 2019
investments. Manager Hines stated since the changes in investment strategies,
the funds have earned an additional $70,000 in interest.
There was general discussion of agencies, CDARs, CDs, and FDIC mortgages.
Manager Hines stated the next meeting will be November 19, 2019.
3. ADJOURNMENT
The meeting was adjourned at 5:18 p.m.
Minutes approval was passed over at the November 19, 2019, meeting due to lack
of quorum.
MINUTES APPROVED THE 4TH DAY OF FEBRUARY 2020.
Minutes taken and prepared by:
Christine Loven, TRMC
City Secretary
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, November 19, 2019
5:00 p.m.
City Manager’s Conference Room
Third Floor – City Hall
1. CALL TO ORDER
City Secretary called the Christine Loven called the meeting to order on November
19, 2019 at 5:00 p.m. and advised the committee they could not take action on
the minutes, as there was not a quorum present. She advised the Committee is
advisory in nature and the presentations can be covered.
ROLL CALL: Committee members present George Dodson, Kathy Wheat
Absent: Susan Mathisen, Bobby Lindamood
Also Present: Finance Director Kyle Lester, Accounting Manager Karen Hines,
Assistant City Manager Mark Wood, and City Secretary Christine Loven
2. APPROVAL OF MINUTES
August 20, 2019
No action taken.
3. REGULAR AGENDA ITEMS
3a Quarterly Investment Report for the quarter ended September 30, 2019
Finance Director Kyle Lester introduced Kristen Derryberry, principal with Weaver
and Tidwell, the City’s auditing firm who updated the Committee on the Audit
process, noting the staff is easy to work with and the field work in running ahead
of schedule.
Director Lester stated this review allows him the opportunity to explain how much
cash we have and where it is located. He noted there was a decrease of
approximately $2.2 million, over last quarter, which is expected due to this report
being the end of the year report. He noted the City has been very liquid with the
largest share of the investments being in Sweeps and Pools.
There was general discussion regarding the Market to Market accounts, future
investment strategy considerations, and collateralization.
City of Colleyville Page 2
Audit Committee Minutes November 19, 2019
3b Investment Policy Update
Director Lester reviewed the recommended edits to the investment policy, stating
He was hoping to streamline the policy and had consulted with Valley View.
Director Lester stated the policy is designed to: keep funds safe, direct
investments for best liquidity and yield performance, and addresses delegation of
authority
The meeting was adjourned at 5:30 p.m.
PASSED BY A VOTE OF AYES, NAYS, AND ABSTENTIONS, THIS 4TH DAY OF
FEBRUARY 2020.
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/4/2020 Number
Type Regular Agenda Items
Department Finance
Title
Discuss preliminary draft of FY19 Comprehensive Annual Financial Report
Explanation
Representatives from Colleyville's audit firm, Weaver, will be in attendance to
discuss the draft of the Fiscal Year September 30, 2019 audit.
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 Agenda Date 2/4/2020 Number
Type Presentation and Discussion
Department Finance
Title
Presentation of the Quarterly Investment Report for the quarter ended December
30, 2019
Explanation
Cash and Cash Equivalents (local government investment pools) totaled $80.2
million. Colleyville’s complete portfolio was valued at $93.45 million, and was
allocated as follows:
Instrument Current as of
12/31/2019
Last Quarter as of
9/30/2019
Cash $ 4,910,609 $ 4,002,473
Sweep Account $ 17,768,763 $ 15,146,458
LOGIC (CP Permissible)$ 2,476,415 $ 2,464,552
Other Governmental
Pools
$ 55,025,170 $ 54,728,977
CD’s $ 6,197,675 $ 2,469,675
CDARS $ 1,575,617 $ 1,575,617
Agencies $ 5,499,022 $ 10,582,778
Total Cash & Investments $ 93,453,270 $ 90,970,530
Instrument Current Yield as of
12/31/2019
Sweep Account 1.57 %
LOGIC (CP Permissible)1.91 %
Other Governmental
Pools
2.24 %
CD’s 1.73 %
CDARS 1.80 %
Agencies 1.96 %
Total Consolidated Yield 1.73 %
Benchmark Yield: 1.60%
Interest earnings for the quarter were $367,388 compared to $459,993 in the
previous quarter. This decrease of $92,604 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
Audit Committee Agenda Briefing
City of Colleyville Page 2
an emphasis on keeping these funds safe while earning as strong a yield as
possible.
Attachments
1.Investment Report - December 2019
2.Cash Report December 2019
Local Gov't Pools
CDARs
Tri-Pty Repurchase
Cash/Sweep
12/31/2019
City of Colleyville, TX
Quarterly Investment Report
Quarterly Investment Report City of Colleyville, TX 12/31/2019
Weighted
9/30/2019 12/31/2019 Change Maturity
Cash 4,002,473$ 4,910,609$ 908,135$ Liquid
Sweep Account 15,146,458$ 17,768,763$ 2,622,306$ Liquid
LOGIC (CP Permiss.)2,464,552$ 2,476,415$ 11,863$ Liquid
Other Gov't Pools 54,728,977$ 55,025,170$ 296,192$ Liquid
Subtotal 76,342,460$ 80,180,957$ 3,838,497$
CD's 2,469,675$ 6,197,675$ 3,728,000$ 314 days
CDARS 1,575,617$ 1,575,617$ -$ 261 days
Agencies 10,582,778$ 5,499,022$ (5,083,756)$ 266 days
Subtotal 14,628,070$ 13,272,314$ (1,355,756)$ 288 days
Total Resources 90,970,530$ 93,453,270$ 2,482,741$
Criteria
Met?
Policy Max 9/30/2019 12/31/2019
U.S. Treasuries 100%0%0%
U.S. Agencies 75%12%6%
CD's 75%3%7%
Local Gov't Pools 75%63%62%
CDARs 75%2%2%
Tri-Pty Repurchase 75%0%0%
Cash/Sweep N/A 21%24%
Where is Colleyville's cash?
Diversity Snapshot vs. Policy Requirements
0%0%10%SEC Registered, No-
Load Mutual Funds
Since our last investment report, the City has had six agency securities, totaling $7.1 million in
investments, come to maturity. Looking at our cash flow needs, staff determined $5.7 million of
those maturities could be reinvested, most of which for a period of 12 months. These funds were all
invested in brokered certificates of deposit, two CD's with Spirit of Texas Bank in Colleyville (non-
brokered), and a callable agency security, as those instruments carries with them the highest
possible yield, while meeting the City's diversity and liquidity needs. To see a summary of
maturities and purchases since September 2019, please turn to the back of this report.
Cash/
Equivalents
Bonds/CDs/Ag
encies
2
Investments on the move…
Quarterly Investment Report City of Colleyville, TX 12/31/2019
Benchmark =13-Week Treasury
Colleyville's investment returns have been climbing steadily since 2016, primary due to to more active
investment practices. Recently, however, rate cuts at the Federal Reserve have brought down fixed
income returns, resulting in declines in the last two quarters. The Fed has indicated that rates will not
change in the near future, hopefully stabilizing our returns. 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 1.73% as of the end of December 2019. This compares favorably
with the 13-week treasury note benchmark put in place by Colleyville's investment policy. However,
our consolidated return has decreased substantially from last quarter. The biggest reason for this is a
rate cut at the Federal Reserve affecting our pool and sweep account rates, which are our biggest
investment vehicles. Still, we managed to offload some low-earning agency bonds and reinvest the
proceeds in favorable CD rates to help offset this somewhat. We will continue to look for ways to
maximize our return on investment.
How do our returns compare?
1.60%1.73%
1.57%
1.74%1.89%1.80%1.96%
0.00%
0.50%
1.00%
1.50%
2.00%
2.50%
13-Wk T Consolidated
Return
Sweep Pools CD's CDARS Agencies
12/31/2019
$-
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
0.0%
0.5%
1.0%
1.5%
2.0%
2.5%
Historical Return
Return Rate Interest Earned
3
Quarterly Investment Report City of Colleyville, TX 12/31/2019
9/30/2019 1/1/2019
Thru Thru
12/31/2019 12/31/2019
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, but appear to be stabilizing in recent weeks. To help offset this effect,
staff has been able to reinvest some agency maturities in CD's with favorable rates. However, it may
be that rates remain at this level through the next quarter. Regardless, staff will always monitor the
market and manage Colleyville's portfolio with emphasis on diversity and cash-flow needs.
$367,388; 1.73%$440,128; 2.09%
Current Total Quarterly Average
What have we earned the past three months? For the past year?
How has our portfolio changed over time?
As the graph above shows, the City has moved its investments away from agency securities and more
toward local government pools. Money stored in these pools tends to earn a decent return compared to
market while also having the benefit of 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 begun to seek out these instruments as diversity and liquidity needs have allowed. Similarly, with
agency debt dropping as a percentage of our portfolio, it may be advantageous to seek out those
instruments as well, from a diversity standpoint.
32%36%
22%24%
33%32%58%62%
1%
7%
6%6%
3%
2%
29%26%17%
6%
2016 2017 2018 2019
PORTFOLIO COMPOSITION
Bank Pools CD's CDARS Agencies
4
Quarterly Investment Report City of Colleyville, TX 12/31/2019
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?
Per State law, Colleyville is only permitted to invest in certain fixed income securities, whose
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 a total of three times in 2019, with expectations that it will
remain steady for the near future.
This investment report is in compliance with the Public Funds Investment Act as well as the City of
Colleyville's investment policy and procedures.
-
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/2019
What has matured this calendar year?
FFCB NOTE (3133EHHN6)1,000,000$ 5/3/2017 5/2/2019 1.35%26,963$
FHLMC NOTE(3137EAEH8)500,000$ 7/31/2017 8/15/2019 1.48%15,053$
FHLB NOTE(313380FB8)1,000,000$ 8/29/2017 9/13/2019 1.38%28,065$
CDARS (Indep Bank)512,577$ 9/21/2017 9/19/2019 0.58%5,930$
CDARS (Worthington Bank)1,543,297$ 9/19/2018 9/19/2019 2.08%32,075$
FHLMC NOTE(3137EADM8)1,000,000$ 9/14/2017 10/2/2019 1.25%12,508$
FHLMC NOTE(3137EADM8)900,000$ 10/13/2017 10/2/2019 1.25%11,275$
FHLB NOTE(3130ACLS1)2,200,000$ 10/26/2017 10/11/2019 1.55%34,100$
FFCB NOTE(3133EHP98)1,000,000$ 11/6/2017 11/6/2019 1.60%16,000$
FFCB NOTE(3133EHV75)750,000$ 12/8/2017 11/21/2019 1.73%12,978$
FFCB NOTE(3133EGJ30)1,255,000$ 12/29/2017 11/18/2019 1.11%13,895$
Total Matured 11,660,874$ 1.46%208,840$
What have we purchased this calendar year?
Brokered CD: FDIC 16571 247,000$ 9/19/2019 10/20/2020 1.80%4,836$
Brokered CD: FDIC 35141 247,000$ 9/19/2019 10/27/2020 1.85%5,058$
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 2270 247,000$ 9/19/2019 12/24/2020 1.80%5,628$
Brokered CD: FDIC 16022 249,675$ 9/18/2019 9/11/2020 1.75%4,297$
CDARS (Worthington Bank)1,575,617$ 9/18/2019 9/17/2020 1.80%28,361$
FHLB NOTE (313383HU8)500,000$ 8/16/2019 6/12/2020 1.75%7,216$
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 3511 249,000$ 10/4/2019 4/19/2021 1.90%4,731$
Brokered CD: FDIC 57777 245,000$ 10/4/2019 10/16/2020 1.75%4,288$
Brokered CD: FDIC 58243 250,000$ 10/4/2019 1/19/2021 1.70%4,250$
Spirit of Texas Bank CD 1,000,000$ 10/24/2019 4/24/2021 1.85%18,500$
Spirit of Texas Bank CD 1,000,000$ 12/5/2019 12/5/2020 1.79%17,900$
FAMCA NOTE (3130A94N8)2,000,000$ 12/4/2019 8/25/2021 1.71%34,203$
Total Purchased 9,529,292$ 1.78%170,096$
Weighted Average Maturity 450 days
APPENDIX
Maturity
Date
Yield to
Maturity
Total
Return
Purchase
Date
Maturity
DatePar Amount
Yield to
Maturity
Total
ReturnInvestment
Investment Par Amount
Purchase
Date
6
Quarterly Investment Report City of Colleyville, TX 12/31/2019
Full Investment Listing
Purchase
Price
FFCB NOTE(3133EJCN7)1,000,000$ 2/14/2018 2/14/2020 2.07%41,400$
FHLB NOTE(3130ADN32)997,834$ 3/7/2018 2/11/2020 2.13%41,103$
Brokered CD: FDIC 7213 248,000$ 3/29/2018 3/30/2020 2.50%12,434$
FFCB NOTE(3133EJHL6)1,001,430$ 4/9/2018 3/27/2020 2.30%45,244$
Brokered CD: FDIC 33124 248,000$ 4/11/2018 4/13/2020 2.55%12,700$
Brokered CD: FDIC 26610 248,000$ 9/14/2018 3/16/2020 2.55%9,512$
FHLB NOTE (313383HU8)500,159$ 8/16/2019 6/12/2020 1.75%7,216$
Brokered CD: FDIC 16022 249,675$ 9/18/2019 9/11/2020 1.75%4,297$
CDARS (Worthington Bank)1,575,617$ 9/18/2019 9/17/2020 1.80%28,361$
Brokered CD: FDIC 16571 247,000$ 9/19/2019 10/20/2020 1.80%4,836$
Brokered CD: FDIC 35141 247,000$ 9/19/2019 10/27/2020 1.85%5,058$
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 2270 247,000$ 9/19/2019 12/24/2020 1.80%5,628$
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 3511 249,000$ 10/4/2019 4/19/2021 1.90%4,731$
Brokered CD: FDIC 57777 245,000$ 10/4/2019 10/16/2020 1.75%4,288$
Brokered CD: FDIC 58243 250,000$ 10/4/2019 1/19/2021 1.70%4,250$
Spirit of Texas Bank CD 1,000,000$ 10/24/2019 4/24/2021 1.85%18,500$
Spirit of Texas Bank CD 1,000,000$ 12/5/2019 12/5/2020 1.79%17,900$
FAMCA NOTE (3130A94N8)1,999,600$ 12/4/2019 8/25/2021 1.71%34,203$
13,272,314$ 1.91%332,488$
Weighted Average Maturity 288 days
APPENDIX
Investment
Purchase
Date
Maturity
Date
Yield to
Maturity Total Return
7
Quarterly Investment Report City of Colleyville, TX 12/31/2019
Mark-to-Market
9/30/2019 12/31/2019
Market Value Market Value
FFCB NOTE(3133EJCN7)1,000,000$ 1,000,865$ 1,000,787$ 787$
FHLB NOTE(3130ADN32)997,834$ 1,000,724$ 1,000,527$ 2,693$
Brokered CD: FDIC 7213 248,000$ 248,822$ 248,516$ 516$
FFCB NOTE(3133EJHL6)1,001,430$ 1,002,718$ 1,001,925$ 495$
Brokered CD: FDIC 33124 248,000$ 248,944$ 248,632$ 632$
Brokered CD: FDIC 26610 248,000$ 248,801$ 248,473$ 473$
FHLB NOTE (313383HU8)500,159$ 499,642$ 500,140$ (18)$
Brokered CD: FDIC 16022 249,675$ 249,625$ 250,161$ 486$
CDARS (Worthington Bank)1,575,617$ 1,575,617$ 1,575,617$ -$
Brokered CD: FDIC 16571 247,000$ 247,000$ 247,294$ 294$
Brokered CD: FDIC 35141 247,000$ 247,133$ 247,400$ 400$
Brokered CD: FDIC 32992 245,000$ 245,000$ 245,265$ 265$
Brokered CD: FDIC 34221 245,000$ 245,000$ 245,265$ 265$
Brokered CD: FDIC 34775 245,000$ 245,120$ 245,353$ 353$
Brokered CD: FDIC 2270 247,000$ 247,002$ 247,331$ 331$
Brokered CD: FDIC 58647 245,000$ N/A 245,184$ 184$
Brokered CD: FDIC 27237 245,000$ N/A 245,184$ 184$
Brokered CD: FDIC 12855 245,000$ N/A 245,184$ 184$
Brokered CD: FDIC 58658 249,000$ N/A 249,197$ 197$
Brokered CD: FDIC 3511 249,000$ N/A 249,715$ 715$
Brokered CD: FDIC 57777 245,000$ N/A 245,186$ 186$
Brokered CD: FDIC 58243 250,000$ N/A 250,095$ 95$
Spirit of Texas Bank CD 1,000,000$ N/A 1,001,571$ 1,571$
Spirit of Texas Bank CD 1,000,000$ N/A 1,001,520$ 1,520$
FAMCA NOTE (3130A94N8)1,999,600$ N/A 2,000,240$ 640$
13,272,314$ 7,552,013$ 13,285,762$ 13,448$
APPENDIX
Investment Purchase Price
Unrealized
Gain/(Loss) since
Purchase
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.
8
CASH & SWEEP CP POOLS GOV. POOLS*INVESTMENTS CDARS CD'S
001 GENERAL FUND (2,472,390) 305,153 9,977,893 1,000,000 1,575,617 744,000 11,130,273
036 STRATEGIC INITIATIVE 128,498 - 393,391 - - - 521,890
004 DEBT SERVICE FUND 1,145,943 - 35,944 - - - 1,181,887
003 CAPITAL PROJECTS 8,706,029 835,878 7,208,802 1,999,600 - 499,000 19,249,310
012 PARK LAND DEDICATION 641,335 - 256,554 610,308 - - 1,508,198
032 VEHICLE AND CAPITAL REPLACEMENT 660,143 - 1,206,623 - - - 1,866,765
034 COLLEYVILLE TOMORROW (357,518) - 1,920,466 - - 1,000,000 2,562,948
035 PARKS TOMORROW 269,289 - 809,979 - - - 1,079,268
005 VOLUNTARY PARK FUND 887,379 - 461,263 - - - 1,348,642
007 DONATIONS FUND 46,791 - - - - - 46,791
011 VOLUNTARY LIBRARY FUND 156,563 - 343,515 - - - 500,078
015 POLICE ASSET FORFEITURE 2,664 - 17,088 - - - 19,752
016 GRANTS (ADVANCE PAYMENTS)(281,683) - - - - - (281,683)
018 TREE PRESERVATION 14,963 - 242,697 - - - 257,661
019 LIBRARY DONATION 58,734 - - - - - 58,734
020 RECREATIONAL EVENT 15,791 - - - - - 15,791
023 LEOSE 1,134 - - - - - 1,134
027 CRIME DISTRICT 566,093 - 603,218 - - - 1,169,311
028 KIDSVILLE MAINTENANCE 15 - - - - - 15
029 COURT TECHNOLOGY 4,133 - 6,094 - - - 10,227
030 COURT SECURITY 7,893 - 34,481 - - - 42,374
033 PUBLIC ART 2,027 - 6,062 - - - 8,089
037 JUVENILE CASE MANAGER (3,457) - 11,779 - - - 8,322
038 HOTEL / MOTEL FUND 211,672 - 282,037 - - - 493,709
002 UTILITY FUND 3,873,939 - 3,566,872 - - 1,725,675 9,166,486
039 UTILITY CAPITAL PROJECTS FUND 2,829,299 488,286 9,842,554 - - - 13,160,140
017 DRAINAGE FEE 552,715 33,339 335,849 - - - 921,903
041 DRAINAGE CAPITAL PROJECTS FUND 493,974 - 1,313,309 - - - 1,807,282 -
006 SESQUICENTINIAL FUND 18,417 - 3,308 - - - 21,725
008 EMPLOYEE ACTIVITY 1,925 - - - - - 1,925
040 INSURANCE TRUST FUND (ADV PMNT)(25,294) - - - - - (25,294)
026 TIF FUND 2,908,216 813,742 16,145,392 387,525 - 1,229,000 21,483,875
21,065,233 2,476,399 55,025,170 3,997,434 1,575,617 5,197,675 89,337,527
024 CEDC 1,614,139 16 - 1,501,588 - 1,000,000 4,115,743
22,679,372 2,476,415 55,025,170 5,499,022 1,575,617 6,197,675 93,453,270
Cash and cash equivalents are just one aspect of the City’s overall financial status, and it is necessary to look at the complete financial statements/CAFR for a comprehensive assessment.
This is a management report prepared not in accordance with GASB
GOVERNMENTAL FUNDS
COLOR CODE
CITY OF COLLEYVILLE
ALL FUNDS CASH & INVESTMENT REPORT - TOTAL BY FUND
CASH & INVESTMENT
ENTERPRISE FUNDS
FIDUCIARY FUNDS
COMPONENT UNIT
COLLEYVILLE ECON DEV CORP
GRAND TOTAL
AS OF DECEMBER 30,
2019
DEBT SERVICE FUNDS
CAPITAL PROJECT FUNDS
SPECIAL REVENUE FUNDS
ENTERPRISE FUNDS
FIDUCIARY FUNDS
1