Item 3B2CITY OF
S0UTHLA1<4,,E
MONTHLY FINANCIAL
REPORT
or— 11 1
Janaury 2022
PERFORMANCE AT A GLANCE
Year to Date
3 year Trend
Reference
7G...r.I.FundVs. Rev.
Positive
Positive
Page 3
(2 months prior activity)
Positive
Positive
Page 3
Property Tax Revenue
Positive
Positive
Page 4
Permit Revenues
Positive
Positive
Page 4
Departmental Expenditures Summary
Positive
Positive
Page 5
Positive = Positive variance or negative variance <1 % compared to seasonal trends.
Warning = Negative variance of 14% compared to seasonal trends
Negative = Negative Variance of > 4% compared to seasonal trends.
City of Southlake Monthly Financial Report 1 2/10/2022
ECONOMIC INDICATORS
NATIONAL ECONOMY
FINANCIAL ACTIVITY
DP is defined as the output of goods and services
oduced by labor and property located in the United
ates, The Bureau of Labor and Economic Analysis
ported that the "advance" estimated GDP for the 4th
carter of 2021 increased at a rate of 6.9%. In the 3rd $45,000,000
carter of 2021, GDP increased at a rate of 2.3%.
V -2.3%
Housing starts in December were at a seasonally
adjusted rate of 1,172,000, which is 2.3% below the
revised previous month figure of 1,199,000.
UNEMPLOYMENT RATES
National: V 4.0%
The National Unemployment rate for January 2022
increased to 4.0% when compared to 3.9% in
December 2021.
State-wide: V 5.0%
The Texas Unemployment rate for December 2021
(preliminary) decreased slightly to 5.0% from 5.2% in
November 2021.
DFW Area: 3.6%
The Dallas/Fort Worth/Arlington Metropolitan Area
unemployment rate for December 2021 (preliminary)
decreased to 3.6% when compared to 3.9% in
November 2021.
$40,000,000
$35,000,000
$30,000,000
$25,000,000
$20,000,000
$15,000,000
$10,000,000
$5,000,000
2018* 2019* 2020* 2021* 2022*
*October -January ■ New Construction permit values
City of Southlake Monthly Financial Report 2 2/10/2022
GENERAL FUND
OVERALL FUND PERFORMANCE:
GENERAL FUND REVENUE VS EXPENDITURES 2022
FY 2022
FY 2022
FY 2022 REVENUE FY 2022 EXPENDITURE ---2021 EXPEND.
REVENUE
EXPENDITURE
VARIANCE
Oct $ 1,158,989
$ 2,430,309
$
(1,271,320)
$16,000,000
Nov $ 2,530,286
$ 3,030,028
$
(499,742)
$14,000,000
Dec $ 8,051,473
$ 4,395,374
$
3,656,099
Jan $ 13,910,711
$ 3,110,936
$
10,799,775
$12,000,000
Feb $
$
$
Mar $
$
$
$10,000,000
Apr $
$
$
$8,000,000
May $
$
$
Jun $
$
$
$6,000,000
Jul $
$
$
Aug $ _
$ _
$
_
$4,000,000
Sep $
$
$
$2,000,000
Tot $ 25,651,459 $ 12,966,647 $ 12,684,812
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
CHART OUTLOOK: POSITIVE
The outlook for the year is positive as overall revenues and expenditures are on target with budget. The revenues are higher than expenditures by approximately $12.7M. The significant variance is due to the significant
portion of property tax revenue collected (over 76%) of the
budgeted property tax revenue which is the largest revenue sources for the general fund.
REVENUE ANALYSIS
GENERAL FUND SALES TAX 2022-2020 COMPARISON
FY 2022
FY 2021
FY 2020
FY 2022 FY 2021 FY 2020
Oct $ 1,613,415
$ 1,299,576
$
1,278,635
$3,000,000
Nov $ 1,652,674
$ 1,084,677
$
1,309,584
Dec $ 2,456,532
$ 1,926,407
$
1,993,686
$2,500,000
Jan $ -
$ 1,256,119
$
1,360,873
Feb $
$ 978,395
$
1,011,429
$2,000,000
'
Mar $ -
$ 1,727,925
$
1,162,936
Apr $
$ 1,470,896
$
1,038,287
$1,500,000
■ .
May $ -
$ 1,262,973
$
1,153,263
Jun $
$ 2,586,036
$
1,375,636
$1,000,000
Jul $ -
$ 1,449,136
$
1,190,064
Aug $
$ 1,427,525
$
1,233,673
$500,000
Sep $
$ 1,687,605
$
1,416,226
Tot $ 5,722,621
$ 18,157,270
$
15,524,291
$-
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
CHART OUTLOOK: POSITIVE
Year to date sales tax collections are trending above FY 2021 (32.8%) and FY 2020 (24.9%) collections. December sales were 28% and 19% above December collections for FY 2021 and FY 2020, respectively. November
collections included an
audit adjustment which
represented 12% of collections for the month. Year to date collections are above budget for the year therefore the outlook is considered positive. Staff will continue to closely
monitor collections.
City of Southlake Monthly Financial Report 3 2/10/2022
GENERAL FUND
REVENUE ANALYSIS (continued)
PROPERTY TAX 3 YEAR TREND
FY 2022
FY 2021
FY 2020
■ FY 2022 ■ FY 2021 FY 2020
Oct $ 653,703
$ 778,578 $
790,236
$14,000,000
Nov $ 2,017,203
$ 1,582,957 $
1,426,054
$12,000,000
Dec $ 6,068,454
$ 6,036,699 $
9,161,119
$10,000,000
Jan $ 11,588,414
$ 13,167,125 $
10,088,389
$8,000,000
Feb $ -
$ 4,445,041 $
4,237,797
$6,000,000
Mar $ -
$ 411,151 $
420,930
Apr $
$ 259,058 $
55,958
$4,000,000
May $ -
$ 152,945 $
105,567
$2,000,000 .■
Jun $
$ 389,839 $
448,670
$-
Jul * $ -
$ (1,365,991) $
(1,457,677)
$(2,000,000) Oct Nov Dec Jan Feb Mar Apr May Jun Aug
Aug $
$ 52,655 $
52,000
$(4,000,000)
Sep $
$ 190,848 $
28,446
Tot $ 20,327,774
$ 26,100,905 $
25,357,489
* Net
transfer of TIF revenues to TIF
CHART OUTLOOK:
POSITIVE fund
2022 YTD property tax
collections ($20,327,774)
are approximately 5.7% lower than 2021 YTD ($21,565,359) and 5.3% less and 2020 YTD ($21,465,798) as of January. As indicated on the chart, the majority of the
property tax revenue
is collected in the first
few months of the fiscal year.
YTD collections are trending slightly below budget.
PERMIT REVENUE 2022-2020 COMPARISON
FY 2022
FY 2021
FY 2020
FY 2022 FY 2021 FY 2020
Oct $ 214,445
$ 50,043 $
134,067 $300,000
Nov $ 185,109
$ 69,734 $
238,528
Dec $ 94,663
$ 102,515 $
135,168 $250,000
Jan $ 167,045
$ 88,737 $
204,931
Feb $ -
$ 76,270 $
212,195
Mar $ -
$ 150,142 $
126,842 $200,000
Apr $
$ 124,870 $
188,968
May $ -
$ 136,364 $
128,791 $150,000
Jun $
$ 158,786 $
148,103
Jul $ -
$ 170,985 $
152,920 $100,000
Aug $
$ 217,599 $
69,101
Sep $
$ 221,982 $
246,547 $50,000
Tot $ 661,262
$ 1,568,027 $
1,986,161
$-
T
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
CHART OUTLOOK: POSITIVE
The value of new construction permits ($42.1M+) issued for FY 2022 YTD is approximately 26.6% and 29.7% higher when compared to FY 2021 and FY 2020, respectively. FY 2022 collections are 112.6% higher and
7.2% lower when compared to FY 2021 and 2020, respectively. The permit revenue year to date is trending above budget therefore the outlook is considered positive.
City of Southlake Monthly Financial Report 4 2/10/2022
EXPENDITURE ANALYSIS
DEPARTMENTAL EXPENDITURES SUMMARY
FY 2022 ACTUAL
FY 2021 ACTUAL YTD
FY 2022 BUDGET
FY 2021/2022 YTD
YTD (JANUARY)
(JANUARY)
YTD (JANUARY)
VARIANCE
BUDGET VARIANCE
FY 2022 % SPENT
CIVIC)
$ 336,128
$
250,066
$ 362,038
$
(86,062)
$
25,910
92.84%
COMM
$ 206,301
$
180,638
$ 230,183
$
(25,663)
$
23,882
89.62%
CS
$ 1,737,633
$
1,541,933
$ 2,345,120
$
(195,700)
$
607,487
74.10%
CSO
$ 167,552
$
164,819
$ 223,024
$
(2,733)
$
55,472
75.13%
DPS
$ 5,731,154
$
5,553,044
$ 7,043,576
$
(178,110)
$
1,312,422
81.37%
ED
$ 88,881
$
46,529
$ 98,085
$
(42,352)
$
9,204
90.62%
FIN
$ 816,982
$
637,491
$ 1,002,598
$
(179,491)
$
185,616
81.49%
HR
$ 245,015
$
238,309
$ 313,450
$
(6,706)
$
68,435
78.17%
IT
$ 917,775
$
773,595
$ 1,167,979
$
(144,180)
$
250,204
78.58%
PDS
$ 664,520
$
683,025
$ 845,970
$
18,505
$
181,450
78.55%
PW
$ 1,228,741
$
1,174,584
$ 1,655,643
$
(54,157)
$
426,902
74.22%
SS
$ 825,962
$
787,282
$ 1,052,541
$
(38,680)
$
226,579
78.47%
Totals
$ 12,966,644
$
12,031,315
$ 16,340,207
$
(935,329)
$
3,373,563
79.35%
FY 2022 ACTUAL YTD (JANUARY) FY 2021 ACTUAL YTD (JANUARY) FY 2022 BUDGET YTD (JANUARY)
$18,000,000
$16,000,000
$14,000,000
$12,000,000
$10,000,000
$8,000,000
$6,000,000
$4,000,000
$2,000,000
CMO COMM
CS
CSO
DPS
ED FIN HR
IT PDS
PW SS
CHART OUTLOOK: I POSITIVE
As indicated
above, 2022 expenditures
are above 2021
expenditures for the
same period with a increase of 7.8% primarily due to DPS expenditures eligible for CARES/grant funding,
timing of Tarrant County contract
payment and
reduction in programing cost
in FY 2021.The
outlook is positive expenditures are
below
budgeted expenditures for the fiscal year.
City of Southlake Monthly Financial Report 5 2/10/2022
HilitopSecurities
Asset Management -
City of Southlake
Investment Portfolio Summary
CITY OF
SOUTH LAKE
For the Quarter Ended
December 31, 2021
Prepared by
HilltopSecurities Asset Management
J�*
HilltopSecurities
Asset Management.,
Report Name
Certification Page
Executive Summary
Benchmark Comparison
Detail of Security Holdings
Change in Value
Earned Income
Investment Transactions
Amortization and Accretion
Projected Fixed Income Cash Flows
MARKET RECAP - DECEMBER 2021:
The month of December was a headscratcher. Omicron cases absolutely exploded, becoming the
dominant strain within three weeks of detection, while new daily COVID cases smashed the previous
high from last January and quickly climbed toward the one million new cases per day mark.
Fortunately, hospitalizations and fatalities haven't followed the same trajectory as prior strains, which
supports the belief that the latest variant isn't nearly as severe. The front -loaded holiday spending
season appeared to be solid, and GDP growth improved significantly from the previous quarter as
indicated by the Atlanta's Fed's GDPNow measure of +7.4% as of January 4th. Usually, hiring is well
correlated with economic growth, but the November employment report was a disappointment as only
210k jobs were added to company payrolls. Some of the miss can blamed on faulty seasonal
adjustment factors, but it's becoming clear that the labor market is very tight, which means continued
pressure on wages.
As growth accelerated in the final quarter of another uneven year, and employers paid higher wages to
attract and retain workers, inflation climbed higher. Both the Consumer Price Index (CPI) and Personal
Consumption Expenditures (PCE) climbed to levels not seen since the early 80's, and Fed officials
finally acknowledged that inflationary pressure would not be retreating any time soon. At the
December FOMC meeting, committee members announced a doubling of the taper pace, which would
effectively end asset purchases in mid -March. Fed officials also released an updated "dot plot" that
was significantly more hawkish than the previous rate outlook. September's dot plot showed
committee members were equally split on whether the first 25 bps hike would take place at the end of
2022 or the beginning of 2023. The updated December outlook clearly indicated three 25 bps hikes in
2022, with liftoff occurring as early as the second quarter. The most recent Bloomberg survey showed
forecasts by U.S. economists mirrored Fed expectations. Yields climbed throughout month as the
bond market adjusted to the dramatic shift in the outlook. The two-year Treasury note, trading at a
yield of 0.26% in early October, ended December at 0.73% and would drift higher in the initial days of
2022.
The bond market ended the month of December having priced -in all three expected rate increases for
the year 2022. Although at this point it would be a surprise if the Fed did not begin the tightening
process in May or June, the past two years have introduced quite a few surprises. If inflation were to
rise further in 2022, the Fed could hike more aggressively, but if prices retreat, the Fed would be
afforded patience. Both the FOMC and the nation's economists expect inflationary pressure to fall;
what's far from clear, with CPI at a 40-year high, is when this price moderation will start.
Page 2 of 18
J�*
HilltopSecurities
Asset Management_
For the Quarter Ended
December 31, 2021
City of Southlake
Investment Officers' Certification
This report is prepared for the City of Southlake (the "Entity") in accordance with Chapter 2256 of the Texas Public Funds Investment Act ("PFIA"). Section
2256.023(a) of the PFIA states that: "Not less than quarterly, the investment officer shall prepare and submit to the governing body of the entity a written reporl
of the investment transactions for all funds covered by this chapter for the preceding reporting period." This report is signed by the Entity's investment officers
and includes the disclosures required in the PFIA. To the extent possible, market prices have been obtained from independent pricing sources.
The investment portfolio complied with the PFIA and the Entity's approved Investment Policy and Strategy throughout the period. All investment transactions
made in the portfolio during this period were made on behalf of the Entity and were made in full compliance with the PFIA and the approved Investment Policy.
Officer Names and Titles:
Sharen Jackson
Name: Sharen Jackson Title: Chief Financial Officer
Mary Morgan
Name: Mary Morgan Title: Deputy Director of Finance
Page 3 of 18
J�*
HilltopSecurities
Asset Management..
Beginning Values as of 09130/21
Par Value
Market Value
Book Value
Unrealized Gain /(Loss)
Market Value %
Weighted Avg. YTW
Weighted Avg. YTM
174,147,951.13
174,710,597.67
174,744,008.43
(33,410.76)
99.98%
0.088%
0.088%
■ USTREAS 21%
■ TEXPOOL
18%
■ TEXSTAR
11%
■ LONESTRGOV
7%
■ LONESTRCRP
7%
■ TOYMCC
6%
■ Other Issuers
31%
Total:
100%
Ending Values as of 12131121
180,269,790.95
180,437,661.50
180,676,670.87
(239,009.37)
99.87%
0.162%
0.162%
50%
46%
45%
40%
35 %
30
25% 25%
20%
15%
10%
7%
6%
5% 3%
0%
Overnight 2 - 90 Days 91 - 180 6 - 12 1 - 2 Years 2 - 3 Years
Days Months
Weighted Average Days to Maturity: 212
City of Southlake
Executive Summary
As of 12131121
■ AGCY BULLET
6%
■ AGCY CALL
3%
■ CID
20%
■ LGIP
46%
■ MUNICIPAL
5%
TREASURY
21%
Total:
100%
■ A-1+ 20%
■ AA+ 1%
■ AAA 79%
Total: 100%
Print Date: 1/11/2022 Print Time: 6:59 pm
Page 4 of 18
Page 1 of 1
J�w
HilltopSecurities
Asset Management_
1.20%
1.00%
0.80%
0.60%
0.40%
0.20%
City of Southlake
Benchmark Comparison
As of 1213112021
............................................................................................
. o
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21
1 YR CMT 3-MO CMT 6-MO CMT - TEXPOOL f City of Southlake
Note 1: CMT stands for Constant Maturity Treasury. This data is published in Federal Reserve Statistical Release H.15 and represents an average of all actively traded Treasury securities having that time remaining until maturity. This is a
standard industry benchmark for Treasury securities. The CMT benchmarks are moving averages. The 3-month CMT is the daily average for the previous 3 months, the 6-month CMT is the daily average for the previous 6 months, and the
1-year and 2-year CMTs are the daily averages for the previous 12-months.
Note 2: Benchmark data for TexPool is the monthly average yield.
Print Date: 1/11/2022 Print Time: TOOpm Page 1 of 1
Page 5 of 18
J�*
HilltopSecurities
Asset Management.
City of Southlake
Detail of Security Holdings
As of 1213112021
Settle Purch Mkt Days Days
CUSIP Date Sec. Type Sec. Description CPN Mty Date Next Call Call Type Par Value Price Ong Cost Book Value Price Market Value to Mty to Call YTM YTW
General Operating M
LNSTCRP
LGIP
LoneStar Corp O/N
12,136,428.09
100.000
12,136,428.09
12,136,428.09
100.000
12,136,428.09
1
0.075
0.075
LNSTGOV
LGIP
LoneStar Gov O/N
12,717,299.63
100.000
12,717,299.63
12,717,299.63
100.000
12,717,299.63
1
0.005
0.005
TEXPOOL
LGIP
TexPool
32,866,649.45
100.000
32,866,649.45
32,866,649.45
100.000
32,866,649.45
1
0.038
0.038
TEXSTAR
LGIP
TexSTAR
19,246,337.20
100.000
19,246,337.20
19,246,337.20
100.000
19,246,337.20
1
0.014
0.014
TXCLASS
LGIP
Texas CLASS
5,318,076.58
100.000
5,318,076.58
5,318,076.58
100.000
5,318,076.58
1
0.069
0.069
92181 PAC6
07/12/21
CP - DISC
Vanderbilt Univ
01/12/22
3,000,000.00
99.949
2,998,466.67
2,999,908.32
99.996
2,999,870.10
12
0.100
0.100
882669BQ6
12/23/20
MUNICIPAL
TX Pub Fin Auth
0.219
02/01/22
2,000,000.00
100.000
2,000,000.00
2,000,000.00
99.997
1,999,940.00
32
0.219
0.219
92181 PC91
07/12/21
CP - DISC
Vanderbilt Univ
03/09/22
3,000,000.00
99.913
2,997,400.00
2,999,274.18
99.964
2,998,923.30
68
0.130
0.130
07286NCHO
10/20/21
CP - DISC
Baylor Univ
03/17/22
5,000,000.00
99.959
4,997,944.44
4,998,958.35
99.945
4,997,255.50
76
0.100
0.100
48306BD51
10/05/21
CP - DISC
Kaiser Foundation Hospital
04/05/22
5,000,000.00
99.939
4,996,966.67
4,998,433.35
99.927
4,996,370.00
95
0.120
0.120
89233HDN1
07/27/21
CP- DISC
Toyota MtrCr
04/22/22
5,000,000.00
99.888
4,994,395.83
4,997,687.50
99.945
4,997,245.00
112
0.150
0.150
46640QG13
10/05/21
CP- DISC
J.P.Morgan Sec
07/01/22
5,000,000.00
99.873
4,993,648.61
4,995,726.40
99.812
4,990,620.00
182
0.170
0.170
91512DG13
10/05/21
CP - DISC
Univ of TX
07/01/22
5,000,000.00
99.895
4,994,769.44
4,996,480.55
99.808
4,990,394.50
182
0.140
0.140
89233HHK3
11/23/21
CP - DISC
Toyota Mtr Cr
08/19/22
5,000,000.00
99.768
4,988,418.06
4,990,097.20
99.841
4,992,075.00
231
0.311
0.311
912828YF1
09/28/21
TREAS NOTE
U.S. Treasury
1.500
09/15/22
5,000,000.00
101.363
5,068,164.06
5,049,613.50
100.855
5,042,775.00
258
0.085
0.085
912828TY6
09/28/21
TREAS NOTE
U.S. Treasury
1.625
11/15/22
5,000,000.00
101.707
5,085,351.56
5,065,709.75
101.070
5,053,515.00
319
0.113
0.113
912828ZD5
10/15/21
TREAS NOTE
U.S. Treasury
0.500
03/15/23
5,000,000.00
100.402
5,020,117.19
5,017,062.05
100.039
5,001,955.00
439
0.215
0.215
912828ZH6
10/14/21
TREAS NOTE
U.S. Treasury
0.250
04/15/23
5,000,000.00
100.008
5,000,390.63
5,000,334.30
99.668
4,983,400.00
470
0.245
0.245
8821356W1
10/28/20
MUNICIPAL
Texas A&M Univ
5.000
05/15/23
2,500,000.00
112.026
2,800,650.00
2,662,205.93
106.507
2,662,675.00
500
0.260
0.260
3133EMH96
06/25/21
AGCY BULET
FFCB
0.125
06/14/23
5,000,000.00
99.713
4,985,650.00
4,989,407.50
99.705
4,985,274.00
530
0.271
0.271
912828ZY9
12/15/21
TREAS NOTE
U.S. Treasury
0.125
07/15/23
5,000,000.00
99.359
4,967,968.75
4,968,899.35
99.285
4,964,260.00
561
0.532
0.532
91282CCU3
08/31/21
TREAS NOTE
U.S. Treasury
0.125
08/31/23
4,000,000.00
99.766
3,990,625.00
3,992,214.84
99.129
3,965,156.00
608
0.243
0.243
91282CAK7
08/26/21
TREAS NOTE
U.S. Treasury
0.125
09/15/23
4,000,000.00
99.750
3,990,000.00
3,991,713.68
99.094
3,963,752.00
623
0.247
0.247
91282CAP6
10/14/21
TREAS NOTE
U.S. Treasury
0.125
10/15/23
5,000,000.00
99.535
4,976,757.81
4,979,269.60
99.012
4,950,585.00
653
0.358
0.358
3133ENDR8
11/15/21
AGCY BULET
FFCB
0.400
11/09/23
5,000,000.00
99.713
4,985,665.00
4,986,584.85
99.455
4,972,766.00
678
0.546
0.546
3130AQAFO
12/22/21
AGCY CALL
FHLB
0.800
12/22/23 3/22/2022 QRTLY
5,000,000.00
100.000
5,000,000.00
5,000,000.00
100.034
5,001,685.50
721
81 0.800
0.800
88213AKBO
09/29/20
MUNICIPAL
Texas A&M Univ
2.549
05/15/24
4,485,000.00
107.731
4,831,735.35
4,712,298.72
103.509
4,642,378.65
866
0.400
0.400
Total for General Operating
180,269,790.95
100.398
180,949,876.02
180,676,670.87
100.104
180,437,661.50
212
0.162
0.162
Print Date: 1/11/2022 Print Time: 7:01 pm Page 1 of 2
Page 6 of 18
J�*
HilltopSecurities
Asset Management.
City of Southlake
Detail of Security Holdings
As of 1213112021
Settle Purch Mkt Days Days
CUSIP Date Sec. Type Sec. Description CPN Mty Date Next Call Call Type Par Value Price Orig Cost Book Value Price Market Value to Mty to Call YTM YTW
Total for City of Southlake 180,269,790.95 100.398 180,949,876.02 180,676,670.87 100.104 180,437,661.50 212 0.162 0.162
Print Date: 1/11/2022 Print Time: 7:01 pm Page 2 of 2
Page 7 of 18
J�*
HilltopSecurities
Asset Management.
City of Southlake
Change in Value
From 0913012021 to 1213112021
CUSIP Security Type Security Description 09/30121 Cost of Maturities / Amortization I Realized 12/31121 09/30121 12/31121 Change in
Book Value Purchases Calls I Sales Accretion Gainl(Loss) Book Value Market Value Market Value Mkt Value
Community Enhancement Dev Co�
TEXPOOL LGIP TexPool 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total for Community Enhancement Dev Corp 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Crime Control District
TEXSTAR LGIP TexSTAR 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total for Crime Control District
General Operating
LNSTCRP
LGIP
LoneStar Corp O/N
LNSTGOV
LGIP
LoneStar Gov O/N
TEXPOOL
LGIP
TexPool
TEXSTAR
LGIP
TexSTAR
TXCLASS
LGIP
Texas CLASS
48306AX51
CP - DISC
Kaiser Foundation Hospital 0.000 10/05/21
9128285F3
TREAS NOTE
U.S. Treasury 2.875 10/15/21
19865WXL2
CP - DISC
Columbia Univ 0.000 10/20/21
23506FAC1
CP - INT
DFW Intl Airport 0.130 11/15/21
912828RR3
TREAS NOTE
U.S. Treasury 2.000 11/15/21
21920NYJ5
CP - DISC
Cornell Univ 0.000 11/18/21
9128285R7
TREAS NOTE
U.S. Treasury 2.625 12/15/21
92181 PACE
CP - DISC
Vanderbilt Univ 0.000 01/12/22
882669BQ6
MUNICIPAL
TX Pub Fin Auth 0.219 02/01/22
92181 PC91
CP - DISC
Vanderbilt Univ 0.000 03/09/22
07286NCHO
CP - DISC
Baylor Univ 0.000 03/17/22
48306BD51
CP - DISC
Kaiser Foundation Hospital 0.000 04/05/22
89233HDN1
CP - DISC
Toyota Mtr Cr 0.000 04/22/22
46640QG13
CP - DISC
J.P.Morgan Sec 0.000 07/01/22
91512DG13
CP - DISC
Univ of TX 0.000 07/01/22
89233HHK3
CP - DISC
Toyota Mtr Cr 0.000 08/19/22
912828YF1
TREAS NOTE
U.S. Treasury 1.500 09/15/22
3133EMCH3
AGCY CALL
FFCB 0.160 10/13/22
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
12,134,169.48
2,258.61
0.00
0.00
0.00
12,136,428.09
12,134,169.48
12,136,428.09
2,258.61
12,688,739.98
28,559.65
0.00
0.00
0.00
12,717,299.63
12,688,739.98
12,717,299.63
28,559.65
23,777,000.76
10,001,673.19
(912,024.50)
0.00
0.00
32,866,649.45
23,777,000.76
32,866,649.45
9,089,648.69
39,245,709.25
387.81
(19,999,759.86)
0.00
0.00
19,246,337.20
39,245,709.25
19,246,337.20
(19,999,372.05)
5,317,331.66
744.92
0.00
0.00
0.00
5,318,076.58
5,317,331.66
5,318,076.58
744.92
4,999,916.65
0.00
(5,000,000.00)
83.35
0.00
0.00
4,999,919.00
0.00
(4,999,919.00)
5,005,316.50
0.00
(5,000,000.00)
(5,316.50)
0.00
0.00
5,005,386.00
0.00
(5,005,386.00)
4,999,788.90
0.00
(5,000,000.00)
211.10
0.00
0.00
4,999,694.50
0.00
(4,999,694.50)
3,000,000.00
0.00
(3,000,000.00)
0.00
0.00
0.00
2,999,962.50
0.00
(2,999,962.50)
5,011,606.65
0.00
(5,000,000.00)
(11,606.65)
0.00
0.00
5,011,870.00
0.00
(5,011,870.00)
4,999,333.35
0.00
(5,000,000.00)
666.65
0.00
0.00
4,999,183.50
0.00
(4,999,183.50)
5,026,162.45
0.00
(5,000,000.00)
(26,162.45)
0.00
0.00
5,026,397.50
0.00
(5,026,397.50)
2,999,141.67
0.00
0.00
766.65
0.00
2,999,908.32
2,998,873.20
2,999,870.10
996.90
2,000,000.00
0.00
0.00
0.00
0.00
2,000,000.00
2,000,601.20
1,999,940.00
(661.20)
2,998,277.49
0.00
0.00
996.69
0.00
2,999,274.18
2,997,999.90
2,998,923.30
923.40
0.00
4,997,944.44
0.00
1,013.91
0.00
4,998,958.35
0.00
4,997,255.50
4,997,255.50
0.00
4,996,966.67
0.00
1,466.68
0.00
4,998,433.35
0.00
4,996,370.00
4,996,370.00
4,995,770.85
0.00
0.00
1,916.65
0.00
4,997,687.50
4,995,466.50
4,997,245.00
1,778.50
0.00
4,993,648.61
0.00
2,077.79
0.00
4,995,726.40
0.00
4,990,620.00
4,990,620.00
0.00
4,994,769.44
0.00
1,711.11
0.00
4,996,480.55
0.00
4,990,394.50
4,990,394.50
0.00
4,988,418.06
0.00
1,679.14
0.00
4,990,097.20
0.00
4,992,075.00
4,992,075.00
5,067,578.25
0.00
0.00
(17,964.75)
0.00
5,049,613.50
5,066,797.00
5,042,775.00
(24,022.00)
4,996,508.70
0.00
(5,000,000.00)
3,491.30
0.00
0.00
4,999,870.00
0.00
(4,999,870.00)
Print Date: 1/11/2022 Print Time: 7:01 pm Page 1 of 2
Page 8 of 18
J�*
HilltopSecurities
Asset Management.
City of Southlake
Change in Value
From 0913012021 to 1213112021
CUSIP
Security Type
Security Description
09/30121
Cost of
Maturities /
Amortization I
Realized
12/31121
09/30121
12/31121
Change in
Book Value
Purchases
Calls I Sales
Accretion
Gainl(Loss)
Book Value
Market Value
Market Value
Mkt Value
General Operati
912828TY6
TREAS NOTE
U.S. Treasury 1.625 11/15/22
5,084,736.50
0.00
0.00
(19,026.75)
0.00
5,065,709.75
5,084,375.00
5,053,515.00
(30,860.00)
912828ZD5
TREAS NOTE
U.S. Treasury 0.500 03/15/23
0.00
5,020,117.19
0.00
(3,055.14)
0.00
5,017,062.05
0.00
5,001,955.00
5,001,955.00
912828ZH6
TREAS NOTE
U.S. Treasury 0.250 04/15/23
0.00
5,000,390.63
0.00
(56.33)
0.00
5,000,334.30
0.00
4,983,400.00
4,983,400.00
8821356W1
MUNICIPAL
Texas A&MUniv 5.000 05/15/23
2,691,696.93
0.00
0.00
(29,491.00)
0.00
2,662,205.93
2,693,252.50
2,662,675.00
(30,577.50)
3133EMH96
AGCY BULET
FFCB 0.125 06/14/23
4,987,589.10
0.00
0.00
1,818.40
0.00
4,989,407.50
4,991,246.00
4,985,274.00
(5,972.00)
912828ZY9
TREAS NOTE
U.S. Treasury 0.125 07/15/23
0.00
4,967,968.75
0.00
930.60
0.00
4,968,899.35
0.00
4,964,260.00
4,964,260.00
91282CCU3
TREAS NOTE
U.S. Treasury 0.125 08/31/23
3,991,025.68
0.00
0.00
1,189.16
0.00
3,992,214.84
3,989,375.20
3,965,156.00
(24,219.20)
91282CAK7
TREAS NOTE
U.S. Treasury 0.125 09/15/23
3,990,478.80
0.00
0.00
1,234.88
0.00
3,991,713.68
3,987,812.40
3,963,752.00
(24,060.40)
91282CAP6
TREAS NOTE
U.S. Treasury 0.125 10/15/23
0.00
4,976,757.81
0.00
2,511.79
0.00
4,979,269.60
0.00
4,950,585.00
4,950,585.00
3133ENDRB
AGCY BULET
FFCB 0.400 11/09/23
0.00
4,985,665.00
0.00
919.85
0.00
4,986,584.85
0.00
4,972,766.00
4,972,766.00
313OAQAFO
AGCY CALL
FHLB 0.800 12/22/23
0.00
5,000,000.00
0.00
0.00
0.00
5,000,000.00
0.00
5,001,685.50
5,001,685.50
88213AKBO
MUNICIPAL
Texas A&MUniv 2.549 05/15/24
4,736,128.83
0.00
0.00
(23,830.11)
0.00
4,712,298.72
4,699,564.64
4,642,378.65
(57,185.99)
Total for General Operating
174,744,008.43
64,956,270.78
(58,911,784.36)
(111,823.98)
0.00
180,676,670.87
174,710,597.67
180,437,661.50
5,727,063.83
Parks Development Corporation
TEXPOOL LGIP TexPool
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TEXSTAR LGIP TexSTAR
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total for Parks Development Corporation
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total for City of Southlake
174,744,008.43
64,956,270.78
(58,911,784.36)
(111,823.98)
0.00
180,676,670.87
174,710,597.67
180,437,661.50
5,727,063.83
Print Date: 1/11/2022 Print Time: 7:01 pm Page 2 of 2
Page 9 of 18
J�*
HilltopSecurities
Asset Management..
City of Southlake
Earned Income
From 0913012021 to 1213112021
CUSIP Security Type Security Description Beg. Accrued Interest Earned Interest Rec'd I Interest Purchased Ending Accrued Disc Accr / Net Income
Sold I Matured Prem Amort
Community Enhancement Dev Corp
Total for Community Enhancement Dev Corp
Crime Control District
0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total for Crime Control District
0.00
0.00
0.00
0.00
0.00
0.00
0.00
General Operating
LNSTCRP
LGIP
LoneStar Corp O/N
0.00
1,945.04
1,945.04
0.00
0.00
0.00
1,945.04
LNSTGOV
LGIP
LoneStar Gov O/N
0.00
163.44
163.44
0.00
0.00
0.00
163.44
TEXPOOL
LGIP
TexPool
0.00
2,263.29
2,263.29
0.00
0.00
0.00
2,263.29
TEXSTAR
LGIP
TexSTAR
0.00
627.95
627.95
0.00
0.00
0.00
627.95
TXCLASS
LGIP
Texas CLASS
0.00
744.92
744.92
0.00
0.00
0.00
744.92
48306AX51
CP - DISC
Kaiser Foundation Hospital 0.000 10/05/21
0.00
0.00
0.00
0.00
0.00
83.35
83.35
91282851`3
TREAS NOTE
U.S. Treasury 2.875 10/15/21
66,376.37
5,498.63
71,875.00
0.00
0.00
(5,316.50)
182.13
19865WXL2
CP - DISC
Columbia Univ 0.000 10/20/21
0.00
0.00
0.00
0.00
0.00
211.10
211.10
23506FAC1
CP - INT
DFW Intl Airport 0.130 11/15/21
931.67
487.50
1,419.17
0.00
0.00
0.00
487.50
912828RR3
TREAS NOTE
U.S. Treasury 2.000 11/15/21
37,771.74
12,228.26
50,000.00
0.00
0.00
(11,606.65)
621.61
21920NYJ5
CP - DISC
Cornell Univ 0.000 11/18/21
0.00
0.00
0.00
0.00
0.00
666.65
666.65
9128285R7
TREAS NOTE
U.S. Treasury 2.625 12/15/21
38,729.51
26,895.49
65,625.00
0.00
0.00
(26,162.45)
733.04
92181 PACE
CP - DISC
Vanderbilt Univ 0.000 01/12/22
0.00
0.00
0.00
0.00
0.00
766.65
766.65
882669BQ6
MUNICIPAL
TX Pub Fin Auth 0.219 02/01/22
730.00
1,095.00
0.00
0.00
1,825.00
0.00
1,095.00
92181 PC91
CP - DISC
Vanderbilt Univ 0.000 03/09/22
0.00
0.00
0.00
0.00
0.00
996.69
996.69
07286NCHO
CP - DISC
Baylor Univ 0.000 03/17/22
0.00
0.00
0.00
0.00
0.00
1,013.91
1,013.91
48306BD51
CP - DISC
Kaiser Foundation Hospital 0.000 04/05/22
0.00
0.00
0.00
0.00
0.00
1,466.68
1,466.68
89233HDN1
CP - DISC
Toyota Mtr Cr 0.000 04/22/22
0.00
0.00
0.00
0.00
0.00
1,916.65
1,916.65
46640QG13
CP - DISC
J.P.MorganSec 0.000 07/01/22
0.00
0.00
0.00
0.00
0.00
2,077.79
2,077.79
91512DG13
CP - DISC
Univ of TX 0.000 07/01/22
0.00
0.00
0.00
0.00
0.00
1,711.11
1,711.11
89233HHK3
CP - DISC
Toyota Mtr Cr 0.000 08/19/22
0.00
0.00
0.00
0.00
0.00
1,679.14
1,679.14
912828YF1
TREAS NOTE
U.S. Treasury 1.500 09/15/22
3,314.92
19,060.77
0.00
0.00
22,375.69
(17,964.75)
1,096.02
3133EMCH3
AGCY CALL
FFCB 0.160 10/13/22
3,733.33
266.67
4,000.00
0.00
0.00
3,491.30
3,757.97
912828TY6
TREAS NOTE
U.S. Treasury 1.625 11/15/22
30,689.54
20,484.49
40,625.00
0.00
10,549.03
(19,026.75)
1,457.74
912828ZD5
TREAS NOTE
U.S. Treasury 0.500 03/15/23
0.00
5,386.74
0.00
(2,071.82)
7,458.56
(3,055.14)
2,331.60
912828ZH6
TREAS NOTE
U.S. Treasury 0.250 04/15/23
0.00
2,712.72
6,250.00
(6,215.85)
2,678.57
(56.33)
2,656.39
Print Date: 1/11/2022 Print Time: 7:01 pm Page 1 of 2
Page 10 of 18
J�*
HilltopSecurities
Asset Management..
City of Southlake
Earned Income
From 0913012021 to 1213112021
CUSIP Security Type Security Description Beg. Accrued Interest Earned Interest Rec'd I Interest Purchased Ending Accrued Disc Accr / Net Income
Sold I Matured Prem Amort
General Operating
8821356W1
MUNICIPAL
Texas A&MUniv 5.000 05/15/23
47,222.22
31,250.00
62,500.00
0.00
15,972.22
(29,491.00)
1,759.00
3133EMH96
AGCY BULET
FFCB 0.125 06/14/23
1,857.64
1,562.50
3,125.00
0.00
295.14
1,818.40
3,380.90
912828ZY9
TREAS NOTE
U.S. Treasury 0.125 07/15/23
0.00
288.72
0.00
(2,598.51)
2,887.23
930.60
1,219.32
91282CCU3
TREAS NOTE
U.S. Treasury 0.125 08/31/23
428.18
1,270.72
0.00
0.00
1,698.90
1,189.16
2,459.88
91282CAK7
TREAS NOTE
U.S. Treasury 0.125 09/15/23
220.99
1,270.72
0.00
0.00
1,491.71
1,234.88
2,505.60
91282CAP6
TREAS NOTE
U.S. Treasury 0.125 10/15/23
0.00
1,356.37
3,125.00
(3,107.92)
1,339.29
2,511.79
3,868.16
3133ENDR8
AGCY BULET
FFCB 0.400 11/09/23
0.00
2,555.56
0.00
(333.33)
2,888.89
919.85
3,475.41
313OAQAFO
AGCY CALL
FHLB 0.800 12/22/23
0.00
1,000.00
0.00
0.00
1,000.00
0.00
1,000.00
88213AKBO
MUNICIPAL
Texas A&MUniv 2.549 05/15/24
43,188.56
28,580.66
57,161.33
0.00
14,607.89
(23,830.11)
4,750.55
Total for General Operating 275,194.67 168,996.16 371,450.14 (14,327.43) 87,068.12 (111,823.98) 57,172.18
Parks Development Corpo
Total for Parks Development Corporation 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total for City of Southlake 275,194.67 168,996.16 371,450.14 (14,327.43) 87,068.12 (111,823.98) 57,172.18
Print Date: 1/11/2022 Print Time: 7:01 pm Page 2 of 2
Page 11 of 18
J�w
HilltopSecurities
Asset Management.
City of Southlake
Investment Transactions
From 1010112021 to 1213112021
Trade Settle Security Principal Int Purchased / Realized
Date Date CUSIP Type Security Description Coupon Mty Date Call Date Par Value Price Amount Received Total Amount Gain / Loss YTM YTW
calls
10/12/21
10/13/21
3133EMCH3
AGCY CALL
FFCB
0.160
10/13/22 10/13/21
5,000,000.00
100.000
5,000,000.00
0.00
5,000,000.00
0.228
0.160
Total for:
Calls
5,000,000.00
5,000,000.00
0.00
5,000,000.00
0.228
0.160
Maturities
10/05/21
10/05/21
48306AX51
CP - DISC
Kaiser Foundation Hospital
10/05/21
5,000,000.00
100.000
5,000,000.00
0.00
5,000,000.00
0.150
10/15/21
10/15/21
91282851`3
TREAS NOTE
U.S. Treasury
2.875
10/15/21
5,000,000.00
100.000
5,000,000.00
0.00
5,000,000.00
0.094
10/20/21
10/20/21
19865WXL2
CP - DISC
Columbia Univ
10/20/21
5,000,000.00
100.000
5,000,000.00
0.00
5,000,000.00
0.080
11/15/21
11/15/21
23506FAC1
CP - INT
DFW Intl Airport
0.130
11/15/21
3,000,000.00
100.000
3,000,000.00
1,419.17
3,001,419.17
0.130
11/15/21
11/15/21
912828RR3
TREAS NOTE
U.S. Treasury
2.000
11/15/21
5,000,000.00
100.000
5,000,000.00
0.00
5,000,000.00
0.101
11/18/21
11/18/21
21920NYJ5
CP - DISC
Cornell Univ
11/18/21
5,000,000.00
100.000
5,000,000.00
0.00
5,000,000.00
0.100
12/15/21
12/15/21
9128285R7
TREAS NOTE
U.S. Treasury
2.625
12/15/21
5,000,000.00
100.000
5,000,000.00
0.00
5,000,000.00
0.071
Total for:
Maturities
33,000,000.00
33,000,000.00
1,419.17
33,001,419.17
0.102
Purchases
10/04/21
10/05/21
46640QG13
CP - DISC
J.P.Morgan Sec
07/01/22
5,000,000.00
99.873
4,993,648.61
0.00
4,993,648.61
0.170
0.170
10/04/21
10/05/21
91512DG13
CP - DISC
Univ of TX
07/01/22
5,000,000.00
99.895
4,994,769.44
0.00
4,994,769.44
0.140
0.140
10/05/21
10/05/21
48306BD51
CP - DISC
Kaiser Foundation Hospital
04/05/22
5,000,000.00
99.939
4,996,966.67
0.00
4,996,966.67
0.120
0.120
10/13/21
10/14/21
912828ZH6
TREAS NOTE
U.S. Treasury
0.250
04/15/23
5,000,000.00
100.008
5,000,390.63
6,215.85
5,006,606.48
0.245
0.245
10/13/21
10/14/21
91282CAP6
TREAS NOTE
U.S. Treasury
0.125
10/15/23
5,000,000.00
99.535
4,976,757.81
3,107.92
4,979,865.73
0.358
0.358
10/14/21
10/15/21
912828ZD5
TREAS NOTE
U.S. Treasury
0.500
03/15/23
5,000,000.00
100.402
5,020,117.19
2,071.82
5,022,189.01
0.215
0.215
10/20/21
10/20/21
07286NCHO
CP - DISC
Baylor Univ
03/17/22
5,000,000.00
99.959
4,997,944.44
0.00
4,997,944.44
0.100
0.100
11/12/21
11/15/21
3133ENDR8
AGCY BULET
FFCB
0.400
11/09/23
5,000,000.00
99.713
4,985,665.00
333.33
4,985,998.33
0.546
0.546
11/22/21
11/23/21
89233HHK3
CP - DISC
Toyota Mtr Cr
08/19/22
5,000,000.00
99.768
4,988,418.06
0.00
4,988,418.06
0.311
0.311
12/07/21
12/22/21
3130AGAFO
AGCY CALL
FHLB
0.800
12/22/23 03/22/22
5,000,000.00
100.000
5,000,000.00
0.00
5,000,000.00
0.800
0.800
12/13/21
12/15/21
912828ZY9
TREAS NOTE
U.S. Treasury
0.125
07/15/23
5,000,000.00
99.359
4,967,968.75
2,598.51
4,970,567.26
0.532
0.532
Total for:
Purchases
55,000,000.00
54,922,646.60
14,327.43
54,936,974.03
0.322
0.322
Income Payments
10/13/21
10/13/21
3133EMCH3
AGCY CALL
FFCB
0.160
10/13/22
0.00
4,000.00
4,000.00
10/15/21
10/15/21
91282851`3
TREAS NOTE
U.S. Treasury
2.875
10/15/21
0.00
71,875.00
71,875.00
Print Date: 1/11/2022 Print Time: 7:01 pm Page 1 of 3
Page 12 of 18
J�w
HilltopSecurities
Asset Management.
City of Southlake
Investment Transactions
From 1010112021 to 1213112021
Trade Settle Security Principal Int Purchased / Realized
Date Date CUSIP Type Security Description Coupon Mty Date Call Date Par Value Price Amount Received Total Amount Gain / Loss YTM YTW
Income Payments
10/15/21
10/15/21
912828ZH6
TREAS NOTE
U.S. Treasury
10/15/21
10/15/21
91282CAP6
TREAS NOTE
U.S. Treasury
11/15/21
11/15/21
8821356W1
MUNICIPAL
Texas A&MUniv
11/15/21
11/15/21
88213AKBO
MUNICIPAL
Texas A&MUniv
11/15/21
11/15/21
912828RR3
TREAS NOTE
U.S. Treasury
11/15/21
11/15/21
912828TY6
TREAS NOTE
U.S. Treasury
12/14/21
12/14/21
3133EMH96
AGCY BULET
FFCB
12/15/21
12/15/21
9128285R7
TREAS NOTE
U.S. Treasury
Total for: Income Payments
0.250
04/15/23
0.00
6,250.00
6,250.00
0.125
10/15/23
0.00
3,125.00
3,125.00
5.000
05/15/23
0.00
62,500.00
62,500.00
2.549
05/15/24
0.00
57,161.33
57,161.33
2.000
11/15/21
0.00
50,000.00
50,000.00
1.625
11/15/22
0.00
40,625.00
40,625.00
0.125
06/14/23
0.00
3,125.00
3,125.00
2.625
12/15/21
0.00
65,625.00
65,625.00
0.00 364,286.33 364,286.33
Print Date: 1/11/2022 Print Time: 7:01 pm
Page 13 of 18
Page 2 of 3
J�w
HilltopSecurities
Asset Management.
City of Southlake
Investment Transactions
From 1010112021 to 1213112021
Trade Settle Security Principal Int Purchased 1 Realized
Date Date CUSIP Type Security Description Coupon Mty Date Call Date Par Value Price Amount Received Total Amount Gain I Loss YTM YTW
Transaction Type Quantity Total Amount Realized GIL YTM YTW
Total Calls 5,000,000.00
Total Maturities 33,000,000.00
Total Purchases 55,000,000.00
Total Income Payments 0.00
5,000,000.00 0.228 0.160
33,001,419.17 0.102
54,936,974.03 0.322 0.322
364,286.33
Print Date: 1/11/2022 Print Time: 7:01 pm
Page 14 of 18
Page 3 of 3
J�*
HilltopSecurities
Asset Management.
City of Southlake
Amortization and Accretion
From 0913012021 to 1213112021
Orig
Amrt/Accr
Total Amrt/Accr
Remaining
CUSIP Settle Date Security Type Security Description Next Call Date Purchase City Price Original Cost
for Period
Since Purch
Disc / Prem Book Value
48306AX51
04/07/21
CP - DISC
Kaiser Foundation Hospital 0.000 10/05/21
0.00
99.925
0.00
83.35
0.00
0.00
0.00
91282851`3
01/22/21
TREAS NOTE
U.S. Treasury 2.875 10/15/21
0.00
102.023
0.00
(5,316.50)
0.00
0.00
0.00
19865WXL2
06/24/21
CP - DISC
Columbia Univ 0.000 10/20/21
0.00
99.974
0.00
211.10
0.00
0.00
0.00
23506FAC1
07/13/21
CP - INT
DFW Intl Airport 0.130 11/15/21
0.00
100.000
0.00
0.00
0.00
0.00
0.00
912828RR3
01/15/21
TREAS NOTE
U.S. Treasury 2.000 11/15/21
0.00
101.578
0.00
(11,606.65)
0.00
0.00
0.00
21920NYJ5
08/05/21
CP - DISC
Cornell Univ 0.000 11/18/21
0.00
99.971
0.00
666.65
0.00
0.00
0.00
9128285R7
03/15/21
TREAS NOTE
U.S. Treasury 2.625 12/15/21
0.00
101.922
0.00
(26,162.45)
0.00
0.00
0.00
92181PAC6
07/12/21
CP - DISC
Vanderbilt Univ 0.000 01/12/22
3,000,000.00
99.949
2,998,466.67
766.65
1,441.65
91.68
2,999,908.32
882669BQ6
12/23/20
MUNICIPAL
TX Pub Fin Auth 0.219 02/01/22
2,000,000.00
100.000
2,000,000.00
0.00
0.00
0.00
2,000,000.00
92181 PC91
07/12/21
CP - DISC
Vanderbilt Univ 0.000 03/09/22
3,000,000.00
99.913
2,997,400.00
996.69
1,874.18
725.82
2,999,274.18
07286NCHO
10/20/21
CP - DISC
Baylor Univ 0.000 03/17/22
5,000,000.00
99.959
4,997,944.44
1,013.91
1,013.91
1,041.65
4,998,958.35
48306BD51
10/05/21
CP - DISC
Kaiser Foundation Hospital 0.000 04/05/22
5,000,000.00
99.939
4,996,966.67
1,466.68
1,466.68
1,566.65
4,998,433.35
89233HDN1
07/27/21
CP - DISC
Toyota Mtr Cr 0.000 04/22/22
5,000,000.00
99.888
4,994,395.83
1,916.65
3,291.67
2,312.50
4,997,687.50
46640QG13
10/05/21
CP - DISC
J.P.Morgan Sec 0.000 07/01/22
5,000,000.00
99.873
4,993,648.61
2,077.79
2,077.79
4,273.60
4,995,726.40
91512DG13
10/05/21
CP - DISC
Univ of TX 0.000 07/01/22
5,000,000.00
99.895
4,994,769.44
1,711.11
1,711.11
3,519.45
4,996,480.55
89233HHK3
11/23/21
CP - DISC
Toyota MtrCr 0.000 08/19/22
5,000,000.00
99.768
4,988,418.06
1,679.14
1,679.14
9,902.80
4,990,097.20
912828YF1
09/28/21
TREAS NOTE
U.S. Treasury 1.500 09/15/22
5,000,000.00
101.363
5,068,164.06
(17,964.75)
(18,550.56)
(49,613.50)
5,049,613.50
3133EMCH3
10/13/20
AGCY CALL
FFCB 0.160 10/13/22
10/13/21 0.00
99.865
0.00
3,491.30
0.00
0.00
0.00
912828TY6
09/28/21
TREAS NOTE
U.S. Treasury 1.625 11/15/22
5,000,000.00
101.707
5,085,351.56
(19,026.75)
(19,641.81)
(65,709.75)
5,065,709.75
912828ZD5
10/15/21
TREAS NOTE
U.S. Treasury 0.500 03/15/23
5,000,000.00
100.402
5,020,117.19
(3,055.14)
(3,055.14)
(17,062.05)
5,017,062.05
912828ZH6
10/14/21
TREAS NOTE
U.S. Treasury 0.250 04/15/23
5,000,000.00
100.008
5,000,390.63
(56.33)
(56.33)
(334.30)
5,000,334.30
8821356W1
10/28/20
MUNICIPAL
Texas A&M Univ 5.000 05/15/23
2,500,000.00
112.026
2,800,650.00
(29,491.00)
(138,444.07)
(162,205.93)
2,662,205.93
3133EMH96
06/25/21
AGCY BULET
FFCB 0.125 06/14/23
5,000,000.00
99.713
4,985,650.00
1,818.40
3,757.50
10,592.50
4,989,407.50
912828ZY9
12/15/21
TREAS NOTE
U.S. Treasury 0.125 07/15/23
5,000,000.00
99.359
4,967,968.75
930.60
930.60
31,100.65
4,968,899.35
91282CCU3
08/31/21
TREAS NOTE
U.S. Treasury 0.125 08/31/23
4,000,000.00
99.766
3,990,625.00
1,189.16
1,589.84
7,785.16
3,992,214.84
91282CAK7
08/26/21
TREAS NOTE
U.S. Treasury 0.125 09/15/23
4,000,000.00
99.750
3,990,000.00
1,234.88
1,713.68
8,286.32
3,991,713.68
91282CAP6
10/14/21
TREAS NOTE
U.S. Treasury 0.125 10/15/23
5,000,000.00
99.535
4,976,757.81
2,511.79
2,511.79
20,730.40
4,979,269.60
3133ENDR8
11/15/21
AGCY BULET
FFCB 0.400 11/09/23
5,000,000.00
99.713
4,985,665.00
919.85
919.85
13,415.15
4,986,584.85
313OAQAFO
12/22/21
AGCY CALL
FHLB 0.800 12/22/23
03/22/22 5,000,000.00
100.000
5,000,000.00
0.00
0.00
0.00
5,000,000.00
88213AKBO
09/29/20
MUNICIPAL
Texas A&MUniv 2.549 05/15/24
4,485,000.00
107.731
4,831,735.35
(23,830.11)
(119,436.63)
(227,298.72)
4,712,298.72
Total for General Operating 97,985,000.00 98,665,085.07 (111,823.98) (273,205.15) (406,879.92) 98,391,879.92
Print Date: 1/11/2022 Print Time: 7:01 pm Page 1 of 2
Page 15 of 18
J�*
HilltopSecurities
Asset Management.
City of Southlake
Amortization and Accretion
From 09/30/2021 to 1213112021
Orig
AmrtIAccr
Total AmrtfAccr
Remaining
CUSIP Settle Date Security Type Security Description Next Call Date Purchase Qty Price Original Cost
for Period
Since Purch
Disc 1 Prem Book Value
Total for City of Southlake 97,985,000.00 98,665,085.07 (111,823.98) (273,205.15) (406,879.92) 98,391,879.92
Print Date: 1/11/2022 Print Time: 7:01 pm Page 2 of 2
Page 16 of 18
J�*
HilltopSecurities
Asset Management..
City of Southlake
Projected Cash Flows
Cash Flows for next 180 days from 1213112021
CUSIP Security Type Security Description Pay Date Interest Principal Total Amount
General Operating
11111111�
92181PAC6
CP - DISC
Vanderbilt Univ 0.000 01/12/22
01/12/22
0.00
3,000,000.00
3,000,000.00
912828ZY9
TREAS NOTE
U.S. Treasury 0.125 07/15/23
01/15/22
3,125.00
0.00
3,125.00
882669BQ6
MUNICIPAL
TX Pub Fin Auth 0.219 02/01/22
02/01/22
2,190.00
2,000,000.00
2,002,190.00
91282CCU3
TREAS NOTE
U.S. Treasury 0.125 08/31/23
02/28/22
2,500.00
0.00
2,500.00
92181 PC91
CP - DISC
Vanderbilt Univ 0.000 03/09/22
03/09/22
0.00
3,000,000.00
3,000,000.00
912828YF1
TREAS NOTE
U.S. Treasury 1.500 09/15/22
03/15/22
37,500.00
0.00
37,500.00
912828ZD5
TREAS NOTE
U.S. Treasury 0.500 03/15/23
03/15/22
12,500.00
0.00
12,500.00
91282CAK7
TREAS NOTE
U.S. Treasury 0.125 09/15/23
03/15/22
2,500.00
0.00
2,500.00
07286NCHO
CP - DISC
Baylor Univ 0.000 03/17/22
03/17/22
0.00
5,000,000.00
5,000,000.00
48306BD51
CP - DISC
Kaiser Foundation Hospital 0.000 04/05/22
04/05/22
0.00
5,000,000.00
5,000,000.00
912828ZH6
TREAS NOTE
U.S. Treasury 0.250 04/15/23
04/15/22
6,250.00
0.00
6,250.00
91282CAP6
TREAS NOTE
U.S. Treasury 0.125 10/15/23
04/15/22
3,125.00
0.00
3,125.00
89233HDN1
CP - DISC
Toyota Mtr Cr 0.000 04/22/22
04/22/22
0.00
5,000,000.00
5,000,000.00
3133ENDR8
AGCY BULET
FFCB 0.400 11/09/23
05/09/22
10,000.00
0.00
10,000.00
8821356W1
MUNICIPAL
Texas A&M Univ 5.000 05/15/23
05/15/22
62,500.00
0.00
62,500.00
88213AKBO
MUNICIPAL
Texas A&M Univ 2.549 05/15/24
05/15/22
57,161.32
0.00
57,161.32
912828TY6
TREAS NOTE
U.S. Treasury 1.625 11/15/22
05/15/22
40,625.00
0.00
40,625.00
3133EMH96
AGCY BULET
FFCB 0.125 06/14/23
06/14/22
3,125.00
0.00
3,125.00
313OAQAFO
AGCY CALL
FHLB 0.800 12/22/23
06/22/22
20,000.00
0.00
20,000.00
Total for General Operating 263,101.32 23,000,000.00 23,263,101.32
Print Date: 1/11/2022 Print Time: 7:01 pm Page 1 of 2
Page 17 of 18
1�*
HilltopSecurities
Asset Management_
City of Southlake
Projected Cash Flows
Cash Flows for next 180 days from 1213112021
CUSIP Security Type Security Description Pay Date Interest Principal Total Amount
January 2022
3,125.00
3,000,000.00
3,003,125.00
February 2022
4,690.00
2,000,000.00
2,004,690.00
March 2022
52,500.00
8,000,000.00
8,052,500.00
April 2022
9,375.00
10,000,000.00
10,009,375.00
May 2022
170,286.32
0.00
170,286.32
June 2022
23,125.00
0.00
23,125.00
Total Projected Cash Flows for City of Southlake 263,101.32 23,000,000.00 23,263,101.32
Print Date: 1/11/2022 Print Time: 7:01 pm Page 2 of 2
Page 18 of 18
EXPERIENCE
SOUTHLAKE
January 25, 2022
The Marq Financial Review
MARQ
89.55%
V
65.12% 137.52%
Target A -FT
Loom 1.12M
Revenue Expense
1 U1112421 9h134l2[le2
CC
96.58%
71.01% 136.01%
Target ATT
852.95K 471.61 K
Revenue Expense
Net Revenue: Current &Previous Year
GGR • LHR —Trial Revenue LY
CEDC FINANCIAL DASHBOARD
- of 112512022 4=44 PM
LH
63.25%
44.UD'70
-11" Z70 0
Target
ATT
149.25K
133.09K
Revenue
Expense
mm
a2K
�OK 25K
ME EMS
eau 39K
258 24£iC
220K 211K 220K 2NK 212K
19(1G INK 202K
175K
149C 14M4K 1471C
dC
Jm2021 Fvb2M1 PA.2W1 Apr3121 Nmy2121 J-2121 U2W1 A.p2721 Sp2021 Od2O7 N-2021 U-201 Jan7U22
g GGJZentsl-� u+Re,t.W?ba nue
50K
40K
30K
20K
10K
The Marq Rentals Revenue (Net)
Jan 2021 Feb 2021 Mar2021 AR 21221 May2021 Jm2021 Ad 2021 Aug 2021 Sep 2021 Om Ml Hw2021 Oec2021 Jan 2022
The Mara Membership Revenue (Net)
100K
180K
170K
100K
150K
140K
130K
120K
Jan 2021 Fe62021 Mar2021 Apr 2021 May 2M Jun 2021 Jd 2021 Au02021 Sep 2021 Ot2021 Nw2021 ❑e M21 Jan2M
CHAMPIONS CLUB MEMBERSHIP TRENDS
2800
261
2585
2600 / 25062513 2252/
458/0000
o574 26015 2444 /� 2453
2400
'2504 2527 25 // \ /� //—
� � � 0000
18 228
2378 2360
� 2331 2327 2340
2200 203 240 22 20
1968 2001/
2- 2000 195819561941 19451944
y 2062� — /� / /� /� / /0-00
s 1955
d 1800
� 1 1
1600 1
h
1400 183 188 178 179 186 184 177
142 153
1200
1000 1 24 9 1 1
LO (O � 00 m O N N cl) �t LO O r` W O O N N (M It LO (O � co O O N *_
O O O O O r r O O O O O O O O O r r r O O O O O O O O O
_O O O O O O O O O O {_
N N N N N N N N N N N N N N N N N N N N N
O O O O O O O O N N N N O O O O O O O O O O O O O O O O O O N
N N N N N N O O N N O O O O N N N N N N N N N N N N N N N N N N CD
N
Period
400
350
300
250
N
C
O
N
200
a
N
7
N
150
100
50
0
CC Membership Joins vs. Terminations, and Retention Rate (Month -to -Month) through 12/31/2021
450
4
400
350 333
300
250
200
150
50
371
224
124
01203 206
187
164 157
12
14 138
02
12J24 22 25120 127
1
78
63
0
25
0 _ 0 0'
1 285
i 198
157 155 153
128 28 130
18 109 113
103 10
81 6
306 304
190 1
100.0%
/00000—
95.0%
90.0%
85.0% � Joins
80.0% � Terminations
Retention
250 75.0% Rate
231
222 224
149■
70.0%
197 201
18
170 65.0%
16
tio`l�tio`l^
13
1
60.0%
55.0%
50.0%
45.0%
40.0%
'i 300
0
1 -100
i _2no
_oo
-4SD
1m0—N Cn.fdda
4 8
5
Ywnhr�hyrY — 35
iw(rndwi Suer 2G
CC MEMBERSHIP JOINS VS TERMINATIONS BY MONTH & TYPE
.Adult Fam Fam-HC SR .Youth
28 1S
a :5
24 19
pp 15
13 0 3 13 B2 W
8 ® 7 153 D. , d7 21) 95
57 91 a5 — .315 �4
4M ## 30
3d 29
11 if s I�
f
_25 18 -28 i y Q -2G 3 I'. -20
3 438 -; 26 I I 'I 28
Aa -.10 -d4 -40
-7 -71 -4 -9 -7 �9 I -50 f3 -1P.
7 15 -12
-13_
,2 1 -1-
-13
_sua
G 8 J"s 8 G G G E Jfs 1< G 8 G G G 8I g
G E .G g v G -G a G 8 .G E m i .G i J"r 8 -ra i
v o o a o a o y a o o $ o o $ o o o
Apr-20 May-20 Jun-24 Ju�20 Aug-20 Sep-20 Oct-26 Now-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul•-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21
EXPERIENCE
SOUTHLAKE
k
Three Year Revenue Comparison by Month
$1,000,000
$900,000
$800,000
$700,000
$600,000
$500,000
$400,000
$300,000
$200,000
$100,000
$0
" —
—
I -
�t
�t
o��10
�0
O�G
FISCAL YEAR 2020 ■ FISCAL YEAR 2021 FISCAL YEAR 2022
EXPERIENCE
SOUTHLAI<,.,.,E