Item 3B1 - Financial ReportCITY OF
S0UTHLA1<4,,E
MONTHLY FINANCIAL
REPORT
or— 11 1
September 2021 v2
PERFORMANCE AT A GLANCE
Year to Date
3 year Trend
Reference
7G...,.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 11/11/2021
ECONOMIC INDICATORS
NATIONAL ECONOMY
2.0%
FINANCIAL ACTIVITY
GDP is defined as the output of goods and services
produced by labor and property located in the United
States, The Bureau of Labor and Economic Analysis
reported that the "advance" estimated GDP for the 3rd
quarter of 2021 increased at a rate of 2.0%. In the 2nd $250,000,000
quarter of 2021, GDP increased at a rate of 6.7%.
Housing Starts: V 0.0% $200,000,000
Housing starts in September were at a seasonally
adjusted rate of 1,080,000, which is unchanged from
the revised previous month figure of 1,080,000. $150,000,000
UNEMPLOYMENT RATES
National: V 4.6%
The National Unemployment rate for October 2021
decreased to 4.6% when compared to 4.8% in
September 2021.
State-wide: V 5.6%
The Texas Unemployment rate for September 2021
(preliminary) decreased slightly to 5.6% from 5.9% in
August 2021.
DFW Area: 4.4%
The Dallas/Fort Worth/Arlington Metropolitan Area
unemployment rate for September 2021 (preliminary)
decreased to 4.4% when compared to 4.7% in August
2021.
$100,000,000
$50,000,000
2017* 2018* 2019* 2020* 2021*
*October -September ■ New Construction permit values
City of Southlake Monthly Financial Report 2 11/11/2021
GENERAL FUND
OVERALL FUND PERFORMANCE:
GENERAL FUND REVENUE VS EXPENDITURES 2021
FY 2021
FY 2021
FY 2021 REVENUE FY 2021 EXPENDITURE 2020 EXPEND.
REVENUE
EXPENDITURE
VARIANCE
Oct
$ 1,141,203
$ 2,174,348
$
(1,033,145)
$16,000,000
Nov
$ 1,850,321
$ 2,812,519
$
(962,198)
$14,000,000
Dec
$ 7,709,670
$ 4,221,574
$
3,488,096
Jan
$ 14,791,267
$ 2,764,227
$
12,027,040
$12,000,000
Feb
$ 7,203,499
$ 3,290,949
$
3,912,550
Mar
$ 2,085,482
$ 3,281,698
$
(1,196,216)
$10,000,000
Apr
$ 1,690,587
$ 3,115,923
$
(1,425336)
$8,000,000
May
Jun
$ 2,943,568
$ 2,529,282
$ 2,965,278
$ 3,760,196
$
$
(21:710)
(3,230,914)
$6,000,000
Jul
$ 529,282
$ 3,760,196
$
(3,230,914►
Aug
$ 3,528,414
$ 3,214,937
$
313,477
$4,000,000
—
—
Sep
$ 3,907,625
$ 5,364,526
$
(1,456,901)
$2 000,000
Tot $ 49,550,671 $ 40,615,258 $ 8,935,413
CHART OUTLOOK:
POSITIVE
I
Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Aug
Sep
The outlook
for the year is positive as revenues are outpacing expenditures by $8.9M. There are year end expenditures (accurals) that will post over the next couple of weeks as we close the fiscal year financials. At the
end of the fiscal year, the excess revenue
is transferred to the Strategic
Initiative Fund and will assist with funding the approved Capital Improvement Plan and other approved initiatives.
REVENUE ANALYSIS
GENERAL FUND SALES TAX 2021-2019 COMPARISON
FY 2021
FY 2020
FY 2019
FY 2021 FY 2020 FY 2019
Oct
$ 1,299,576
$ 1,278,635
$
1,253,417
$3,000,000
Nov
$ 1,084,677
$ 1,309,584
$
1,140,440
Dec
$ 1,926,407
$ 1,993,686
$
1,613,337
$2,500,000
Jan
$ 1,256,119
$ 1,360,873
$
1,030,047
Feb
$ 978,395
$ 1,011,429
$
1,094,354
$2,000,000
Mar
$ 1,727,925
$ 1,162,936
$
1,321,691
Apr
May
$ 1,470,896
$ 1,262,973
$ 1,038,287
$ 1,153,263
$
$
1,294,023
1,295,321
$1,500,000
,
.
WWW—
.
Jun
$ 2,586,036
$ 1,375,636
$
1,274,338
$1,000,000
Jul
$ 1,449,136
$ 1,190,064
$
1,179,145
Aug
$ 1,427,525
$ 1,233,673
$
1,344,868
$500,000
Sep
$ 1,687,605
$ 1,416,226
$
1,354,327
Tot
$ 18,157,270
$ 15,524,291
$
15,195,307
$-
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
2020 (17.0%)
and FY 2019 (19.5%) collections. June sales were 88% and 103% above June collections for FY 2020 and FY 2019, respectively.
June collections
included a significant
audit adjustment
which represented 38% 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 11/11/2021
REVENUE ANALYSIS (continued)
FY 2021 FY 2020 FY 2019
Oct $ 778,578 $ 790,236 $ 1,151,812
Nov $ 1,582,957 $ 1,426,054 $ 1,552,708
Dec $ 6,036,699 $ 9,161,119 $ 10,397,278
Jan $ 13,167,125 $ 10,088,389 $ 9,985,201
Feb $ 4,445,041 $ 4,237,797 $ 3,385,436
Mar $ 411,151 $ 420,930 $ 395,710
Apr $ 259,058 $ 55,958 $ 156,647
May $ 152,945 $ 105,567 $
Jun $ 389,839 $ 448,670 $ 312,620
Jul * $ (1,365,991) $ (1,457,677) $ (1,295,201)
Aug $ 52,655 $ 52,000 $ 59,318
Sep $ 190,848 $ 28,446 $ 46,464
Tot $ 26,100,905 $ 25,357,489 $ 26,147,993
CHART OUTLOOK: POSITIVE
* Net , transfer of TIF revenues to TIF
GENERAL FUND
PROPERTY TAX 3 YEAR TREND
■ FY 2021 ■ FY 2020 FY 2019
$14,000,000
$12,000,000
$10,000,000
$8,000,000
$6,000,000
$4,000,000
$2,000,000
$- ■�
$(2,000,000) Oct Nov Dec
$(4,000,000)
Jan Feb Mar Apr May Jun Wr Aug
2021 YTD property tax collections ($26,100,905) are approximately 2.9% higher than 2020 YTD ($25,357,489) and 0.2% less and 2019 YTD ($26,147,993) as of September. As indicated on the chart, the majority of
property tax revenue is collected in the first few months of the fiscal year. YTD collections are trending slightly above budget.
FY 2021
FY 2020
FY 2019
Oct
$
50,043
$ 134,067
$
85,534
$700,000
Nov
$
69,734
$ 238,528
$
75,588
Dec
$
102,515
$ 135,168
$
160,859
$600,000
Jan
$
88,737
$ 204,931
$
121,526
Feb
$
76,270
$ 212,195
$
121,533
$500,000
Mar
$
150,142
$ 126,842
$
186,152
Apr
$
124,870
$ 188,968
$
111,970
$400,000
May
$
136,364
$ 128,791
$
601,621
Jun
$
158,786
$ 148,103
$
111,503
$300,000
Jul
$
170,985
$ 152,920
$
163,760
$200,000
Aug
$
217,599
$ 69,101
$
155,328
Sep
$
221,982
$ 246,547
$
474,884
$100,000
Tot
$
1,568,027
$ 1,986,161
$
2,370,258
CHART
OUTLOOK:
POSITIVE
PERMIT REVENUE 2021-2019 COMPARISON
� FY 2021 m FY 2020
FY 2019
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
value of new construction permits ($134.6M+) issued for FY 2021 YTD is approximately 5.7% higher and 56.4% lower when compared to FY 2020 and FY 2019 respectively. FY 2021 collections are 21.1%
% below FY 2020 and 2019, respectively. Permit revenue exceeded the budget for the fiscal year therefore the outlook is considered positive.
City of Southlake Monthly Financial Report 4 11/11/2021
EXPENDITURE ANALYSIS
DEPARTMENTAL EXPENDITURES SUMMARY
AMENDED
FY 2020/2021 YTD
FY 2021 YTD
FY
2020 YTD
FY 2021 BUDGET
VARIANCE
BUDGET VARIANCE
FY 2021 % SPENT
CMO
$ 912,197
$
957,427
$ 946,914
$
45,230
$ 34,717
96.33%
COMM
$ 467,033
$
440,762
$ 502,941
$
(26,271)
$ 35,908
92.86%
CS
$ 5,337,901
$
5,207,342
$ 5,725,834
$
(130,559)
$ 387,933
93.22%
CSO
$ 541,041
$
473,434
$ 560,266
$
(67,607)
$ 19,225
96.57%
DPS
$ 18,242,756
$
16,941,983
$ 18,763,382
$
(1,300,773)
$ 520,626
97.23%
ED
$ 161,419
$
150,056
$ 209,206
$
(11,363)
$ 47,787
77.16%
FIN
$ 2,377,585
$
2,224,249
$ 2,469,509
$
(153,336)
$ 91,924
96.28%
HR
$ 874,081
$
775,106
$ 878,141
$
(98,975)
$ 4,060
99.54%
IT
$ 2,877,470
$
2,742,618
$ 2,973,823
$
(134,852)
$ 96,353
96.76%
PDS
$ 2,203,104
$
2,126,121
$ 2,331,041
$
(76,983)
$ 127,937
94.51%
PW
$ 4,603,559
$
4,587,713
$ 4,858,557
$
(15,846)
$ 254,998
94.75%
SS
$ 2,017,112
$
1,882,416
$ 2,150,336
$
(134,696)
$ 133,224
93.80%
Totals
$ 40,615,258
$
38,509,227
$ 42,369,950
$
(2,106,031)
$ 1,754,692
95.86%
FY 2021 YTD FY 2020 YTD AMENDED FY 2021 BUDGET
$18,000,000
$16,000,000
$14,000,000
$12,000,000
$10,000,000
$8,000,000
$6,000,000
$4,000,000
I
$2,000,000
$-
CMO COMM
CS
CSO
DPS
ED FIN HR
IT PDS PW SS
CHART OUTLOOK:
I POSITIVE
As indicated above, 2021 expenditures are above 2020 expenditures for
the same period with
a increase of 5.47% primarily due to DPS expenditures eligible for CARES/grant funding in FY 2020. The outlook is positive
expenditures are below
budgeted expenditures for the fiscal
year.
City of Southlake Monthly Financial Report 5 11/11/2021
HilitopSecurities
Asset Management -
City of Southlake
Investment Portfolio Summary
CITY OF
SOUTH LAKE
For the Quarter Ended
September 30, 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 - SEPTEMBER 2021:
Covid concerns continued to infect Q3 economic growth, although the month of September showed a
steady decline in the spread. The 7-day average of new COVID-19 cases actually peaked at 161 k on
the first day of September before dropping -55% over the course of the month as another 10 million
Americans received their first vaccine dose, bringing the total above 210 million, or 65% of the U.S.
population. As the virus receded, market focus turned to the mid -month FOMC meeting for indications
of when committee members would begin reeling -in some of the Fed's accommodative monetary
policy. Chairman Powell told reporters in the post -meeting press conference that QE asset purchases
were expected to wind down by mid-2022, and although an official start date has not been set,
tapering will almost certainly begin later this year. The FOMC meeting also brought a fresh "dot plot"
that was a bit more aggressive in terms of future interest rate increases. Of course, all of this is subject
to change depending on labor market and inflation trends.
Non -farm payrolls, tainted by the latest virus wave, rose by just +235k in August, a sharp drop from the
million plus pace of the previous two months, leaving payrolls 5.3 million below the pre -pandemic total.
At first glance, it might appear those jobs are missing, but in reality, it's the workers that are absent.
The July JOLTS survey showed a record 10.9 million available positions, an increase of 4.2 million
since the year began. With federal unemployment benefits ending on September 6th for an estimated
11 million Americans, many experts expect open positions will be filled in the upcoming months. These
jobseekers will be paying higher prices for food, clothing and transportation as inflationary pressures
remained extremely elevated well beyond the "transitory period" Fed officials have widely telegraphed.
On a year -over year -basis, headline CPI was up +5.3% in August, down from +5.4% the previous
month, while core CPI climbed +4.0% on a year -over -year basis following a +4.3% annual increase in
July. The simple fact that the indexes are moving lower may have given investors some comfort, but
inflation remains stubbornly near thirty-year highs. Strong consumer demand paired with severely
challenged global supply chains indicate higher prices could last well into next year.
The Fed typically cools inflation by ratcheting interest rates higher to slow economic growth, but as
monetary stimulus is set to fade, fiscal policy could be on the verge of expanding at an unprecedented
pace. A $1 trillion infrastructure bill that passed the Senate in August did not get a vote in the House
as expected on the last day of September, while opposition to a proposed $3.5 trillion budget
reconciliation bill is garnering hostility on both sides of the isle and an impasse on the debt ceiling adds
to the turmoil. At this point, the Democrats will either raise the debt ceiling themselves and face the
political consequences in the 2022 midterms or put the U.S. Treasury in the unthinkable position of
defaulting on its debt obligations. Either way, politics are likely to drive the markets in October, adding
a big dose of volatility and likely nudging a market yields higher.
Page 2 of 15
J�*
HilltopSecurities
Asset Management_
For the Quarter Ended
September 30, 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 15
J�*
HilltopSecurities
Asset Management..
Beginning Values as of 06130/21
Par Value
Market Value
Book Value
Unrealized Gain /(Loss)
Market Value %
Weighted Avg. YTW
Weighted Avg. YTM
156,768,828.79
157,428,495.50
157,432,208.72
(3,713.22)
100.00%
0.085%
0.085%
■ TEXSTAR
22%
■ US TREAS
19%
■ TEXPOOL
14%
■ LONESTRGOV
7%
■ LONESTRCRP
7%
■ FFCB
6%
■ Other Issuers
25%
Total:
100%
Ending Values as of 09130121
174,147,951.13
174,710,597.67
174,744,008.43
(33,410.76)
99.98%
0.088%
0.088%
60%
50 i
40%
30 %
20%
10%
0%
Overnight 2 - 90 Days 91 - 180 6 - 12 1 - 2 Years 2 - 3 Years
Days Months
Weighted Average Days to Maturity: 137
City of Southlake
Executive Summary
As of 09130121
■ AGCY BULLET
3%
■ AGCY CALL
3%
■ CP
17%
■ LGIP
53%
■ MUNICIPAL
5%
■ TREASURY
19%
Total:
100%
■ A-1 2%
■ A-1+ 15%
■ AA+ 1%
■ AAA 82%
Total: 100%
Print Date: 10/21/2021 Print Time: 10:28 pm
Page 4 of 15
Page 1 of 1
J�w
HilltopSecurities
Asset Management_
1.60%
1.40%
1.20%
1.00%
0.80%
0.60%
0.40%
0.20%
0.00%
Apr-20 May-20 Jun-20 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
�— 1 YR CMT 3-MO CMT 6-MO CMT - TEXPOOL 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.
City of Southlake
Benchmark Comparison
As of 09/30/2021
Print Date: 10/21/2021 Print Time: 10:29 pm Page 1 of 1
Page 5 of 15
J�*
HilltopSecurities
Asset Management.
City of Southlake
Detail of Security Holdings
As of 09/30/2021
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
General Operating M
LNSTCRP
LGIP
LoneStar Corp O/N
12,134,169.48
100.000
12,134,169.48
12,134,169.48
100.000
12,134,169.48
1
0.053
0.053
LNSTGOV
LGIP
LoneStar Gov O/N
12,688,739.98
100.000
12,688,739.98
12,688,739.98
100.000
12,688,739.98
1
0.005
0.005
TEXPOOL
LGIP
TexPool
23,777,000.76
100.000
23,777,000.76
23,777,000.76
100.000
23,777,000.76
1
0.028
0.028
TEXSTAR
LGIP
TexSTAR
39,245,709.25
100.000
39,245,709.25
39,245,709.25
100.000
39,245,709.25
1
0.010
0.010
TXCLASS
LGIP
Texas CLASS
5,317,331.66
100.000
5,317,331.66
5,317,331.66
100.000
5,317,331.66
1
0.044
0.044
48306AX51
04/07/21
CP - DISC
Kaiser Foundation Hospital
10/05/21
5,000,000.00
99.925
4,996,229.17
4,999,916.65
99.998
4,999,919.00
5
0.150
0.150
9128285F3
01/22/21
TREAS NOTE
U.S. Treasury
2.875
10/15/21
5,000,000.00
102.023
5,101,171.88
5,005,316.50
100.108
5,005,386.00
15
0.094
0.094
19865WXL2
06/24/21
CP - DISC
Columbia Univ
10/20/21
5,000,000.00
99.974
4,998,688.89
4,999,788.90
99.994
4,999,694.50
20
0.080
0.080
23506FAC1
07/13/21
CP - INT
DFW Intl Airport
0.130
11/15/21
3,000,000.00
100.000
3,000,000.00
3,000,000.00
99.999
2,999,962.50
46
0.130
0.130
912828RR3
01/15/21
TREAS NOTE
U.S. Treasury
2.000
11/15/21
5,000,000.00
101.578
5,078,906.25
5,011,606.65
100.237
5,011,870.00
46
0.101
0.101
21920NYJ5
08/05/21
CP - DISC
Cornell Univ
11/18/21
5,000,000.00
99.971
4,998,541.67
4,999,333.35
99.984
4,999,183.50
49
0.100
0.100
9128285R7
03/15/21
TREAS NOTE
U.S. Treasury
2.625
12/15/21
5,000,000.00
101.922
5,096,093.75
5,026,162.45
100.528
5,026,397.50
76
0.071
0.071
92181PAC6
07/12/21
CP - DISC
Vanderbilt Univ
01/12/22
3,000,000.00
99.949
2,998,466.67
2,999,141.67
99.962
2,998,873.20
104
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
100.030
2,000,601.20
124
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,998,277.49
99.933
2,997,999.90
160
0.130
0.130
89233HDN1
07/27/21
CP- DISC
Toyota MtrCr
04/22/22
5,000,000.00
99.888
4,994,395.83
4,995,770.85
99.909
4,995,466.50
204
0.150
0.150
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,067,578.25
101.336
5,066,797.00
350
0.085
0.085
3133EMCH3
10/13/20
AGCY CALL
FFCB
0.160
10/13/22 10/13/2021 CONT
5,000,000.00
99.865
4,993,250.00
4,996,508.70
99.997
4,999,870.00
378
13 0.228
0.228
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,084,736.50
101.688
5,084,375.00
411
0.113
0.113
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,691,696.93
107.730
2,693,252.50
592
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,987,589.10
99.825
4,991,246.00
622
0.271
0.271
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,991,025.68
99.734
3,989,375.20
700
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,990,478.80
99.695
3,987,812.40
715
0.247
0.247
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,736,128.83
104.784
4,699,564.64
958
0.400
0.400
Total for General Operating
174,147,951.13
100.610
175,168,271.21
174,744,008.43
100.339
174,710,597.67
137
0.088
0.088
Total for City ofSouthlake
174,147,951.13
100.610
175,168,271.21
174,744,008.43
100.339
174,710,597.67
137
0.088
0.088
Print Date: 10/21/2021 Print Time: 10:29 pm Page 1 of 1
Page 6 of 15
J�*
HilltopSecurities
Asset Management.
City of Southlake
Change in Value
From 0613012021 to 09/30/2021
CUSIP Security Type Security Description 06/30121 Cost of Maturities / Amortization I Realized 09/30121 06/30121 09/30121 Change in
Book Value Purchases Calls I Sales Accretion Gaini(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
91510KUD7
CP - DISC
Univ of TX 0.000 07/13/21
89233GUS3
CP - DISC
Toyota Mir Cr 0.000 07/26/21
2192ONV58
CP - DISC
Cornell Univ 0.000 08/05/21
882724SY4
MUNICIPAL
State of TX 4.000 08/26/21
9128285A4
TREAS NOTE
U.S. Treasury 2.750 09/15/21
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
89233HDN1
CP - DISC
Toyota Mtr Cr 0.000 04/22/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,132,129.35
2,040.13
0.00
0.00
0.00
12,134,169.48
12,132,129.35
12,134,169.48
2,040.13
12,688,576.43
163.55
0.00
0.00
0.00
12,688,739.98
12,688,576.43
12,688,739.98
163.55
20,401,770.72
4,874,667.65
(1,499,437.61)
0.00
0.00
23,777,000.76
20,401,770.72
23,777,000.76
3,375,230.04
39,244,720.08
989.17
0.00
0.00
0.00
39,245,709.25
39,244,720.08
39,245,709.25
989.17
5,316,632.21
699.45
0.00
0.00
0.00
5,317,331.66
5,316,632.21
5,317,331.66
699.45
2,999,880.00
0.00
(3,000,000.00)
120.00
0.00
0.00
2,999,891.70
0.00
(2,999,891.70)
4,999,409.70
0.00
(5,000,000.00)
590.30
0.00
0.00
4,999,761.50
0.00
(4,999,761.50)
4,999,416.65
0.00
(5,000,000.00)
583.35
0.00
0.00
4,999,500.00
0.00
(4,999,500.00)
5,029,008.95
0.00
(5,000,000.00)
(29,008.95)
0.00
0.00
5,030,020.50
0.00
(5,030,020.50)
5,027,514.05
0.00
(5,000,000.00)
(27,514.05)
0.00
0.00
5,027,821.00
0.00
(5,027,821.00)
4,998,000.00
0.00
0.00
1,916.65
0.00
4,999,916.65
4,997,777.00
4,999,919.00
2,142.00
5,040,253.60
0.00
0.00
(34,937.10)
0.00
5,005,316.50
5,040,825.00
5,005,386.00
(35,439.00)
4,998,766.65
0.00
0.00
1,022.25
0.00
4,999,788.90
4,997,822.00
4,999,694.50
1,872.50
0.00
3,000,000.00
0.00
0.00
0.00
3,000,000.00
0.00
2,999,962.50
2,999,962.50
5,035,335.75
0.00
0.00
(23,729.10)
0.00
5,011,606.65
5,035,937.50
5,011,870.00
(24,067.50)
0.00
4,998,541.67
0.00
791.68
0.00
4,999,333.35
0.00
4,999,183.50
4,999,183.50
5,058,255.00
0.00
0.00
(32,092.55)
0.00
5,026,162.45
5,058,398.50
5,026,397.50
(32,001.00)
0.00
2,998,466.67
0.00
675.00
0.00
2,999,141.67
0.00
2,998,873.20
2,998,873.20
2,000,000.00
0.00
0.00
0.00
0.00
2,000,000.00
2,001,085.20
2,000,601.20
(484.00)
0.00
2,997,400.00
0.00
877.49
0.00
2,998,277.49
0.00
2,997,999.90
2,997,999.90
0.00
4,994,395.83
0.00
1,375.02
0.00
4,995,770.85
0.00
4,995,466.50
4,995,466.50
0.00
5,068,164.06
0.00
(585.81)
0.00
5,067,578.25
0.00
5,066,797.00
5,066,797.00
4,995,665.45
0.00
0.00
843.25
0.00
4,996,508.70
5,000,356.50
4,999,870.00
(486.50)
Print Date: 10/21/2021 Print Time: 10:30 pm Page 1 of 2
Page 7 of 15
J�*
HilltopSecurities
Asset Management.
City of Southlake
Change in Value
From 0613012021 to 09/30/2021
CUSIP
Security Type
Security Description
06/30121
Cost of
Maturities /
Amortization I
Realized
09/30121
06/30121
09/30121
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
0.00
5,085,351.56
0.00
(615.06)
0.00
5,084,736.50
0.00
5,084,375.00
5,084,375.00
8821356W1
MUNICIPAL
Texas A&MUniv 5.000 05/15/23
2,721,168.35
0.00
0.00
(29,471.42)
0.00
2,691,696.93
2,722,318.25
2,693,252.50
(29,065.75)
3133EMH96
AGCY BULET
FFCB 0.125 06/14/23
4,985,771.20
0.00
0.00
1,817.90
0.00
4,987,589.10
4,986,620.50
4,991,246.00
4,625.50
91282CCU3
TREAS NOTE
U.S. Treasury 0.125 08/31/23
0.00
3,990,625.00
0.00
400.68
0.00
3,991,025.68
0.00
3,989,375.20
3,989,375.20
91282CAK7
TREAS NOTE
U.S. Treasury 0.125 09/15/23
0.00
3,990,000.00
0.00
478.80
0.00
3,990,478.80
0.00
3,987,812.40
3,987,812.40
88213AKBO
MUNICIPAL
Texas A&MUniv 2.549 05/15/24
4,759,934.58
0.00
0.00
(23,805.75)
0.00
4,736,128.83
4,746,531.56
4,699,564.64
(46,966.92)
Total for General Operating
157,432,208.72
42,001,504.74
(24,499,437.61)
(190,267.42)
0.00
174,744,008.43
157,428,495.50
174,710,597.67
17,282,102.17
Parks Development Corporation w
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
157,432,208.72
42,001,504.74
(24,499,437.61)
(190,267.42)
0.00
174,744,008.43
157,428,495.50
174,710,597.67
17,282,102.17
Print Date: 10/21/2021 Print Time: 10:30 pm Page 2 of 2
Page 8 of 15
J�*
HilltopSecurities
Asset Management..
City of Southlake
Earned Income
From 0613012021 to 09/30/2021
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
2,040.13
2,040.13
0.00
0.00
0.00
2,040.13
LNSTGOV
LGIP
LoneStar Gov O/N
0.00
163.55
163.55
0.00
0.00
0.00
163.55
TEXPOOL
LGIP
TexPool
0.00
1,326.53
1,326.53
0.00
0.00
0.00
1,326.53
TEXSTAR
LGIP
TexSTAR
0.00
989.17
989.17
0.00
0.00
0.00
989.17
TXCLASS
LGIP
Texas CLASS
0.00
699.45
699.45
0.00
0.00
0.00
699.45
91510KUD7
CP - DISC
Univ of TX 0.000 07/13/21
0.00
0.00
0.00
0.00
0.00
120.00
120.00
89233GUS3
CP - DISC
Toyota Mtr Cr 0.000 07/26/21
0.00
0.00
0.00
0.00
0.00
590.30
590.30
2192ONV58
CP - DISC
Cornell Univ 0.000 08/05/21
0.00
0.00
0.00
0.00
0.00
583.35
583.35
882724SY4
MUNICIPAL
State of TX 4.000 08/26/21
165,479.45
30,684.93
196,164.38
0.00
0.00
(29,008.95)
1,675.98
9128285A4
TREAS NOTE
U.S. Treasury 2.750 09/15/21
40,353.26
28,396.74
68,750.00
0.00
0.00
(27,514.05)
882.69
48306AX51
CP - DISC
Kaiser Foundation Hospital 0.000 10/05/21
0.00
0.00
0.00
0.00
0.00
1,916.65
1,916.65
91282851`3
TREAS NOTE
U.S. Treasury 2.875 10/15/21
30,242.49
36,133.88
0.00
0.00
66,376.37
(34,937.10)
1,196.78
19865WXL2
CP - DISC
Columbia Univ 0.000 10/20/21
0.00
0.00
0.00
0.00
0.00
1,022.25
1,022.25
23506FAC1
CP - INT
DFW Intl Airport 0.130 11/15/21
0.00
866.67
0.00
(65.00)
931.67
0.00
866.67
912828RR3
TREAS NOTE
U.S. Treasury 2.000 11/15/21
12,771.74
25,000.00
0.00
0.00
37,771.74
(23,729.10)
1,270.90
21920NYJ5
CP - DISC
Cornell Univ 0.000 11/18/21
0.00
0.00
0.00
0.00
0.00
791.68
791.68
9128285R7
TREAS NOTE
U.S. Treasury 2.625 12/15/21
5,737.70
32,991.81
0.00
0.00
38,729.51
(32,092.55)
899.26
92181 PAC6
CP - DISC
Vanderbilt Univ 0.000 01/12/22
0.00
0.00
0.00
0.00
0.00
675.00
675.00
882669BQ6
MUNICIPAL
TX Pub Fin Auth 0.219 02/01/22
2,287.33
1,095.00
2,652.33
0.00
730.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
877.49
877.49
89233HDN1
CP - DISC
Toyota Mtr Cr 0.000 04/22/22
0.00
0.00
0.00
0.00
0.00
1,375.02
1,375.02
912828YF1
TREAS NOTE
U.S. Treasury 1.500 09/15/22
0.00
621.55
0.00
(2,693.37)
3,314.92
(585.81)
35.74
3133EMCH3
AGCY CALL
FFCB 0.160 10/13/22
1,733.33
2,000.00
0.00
0.00
3,733.33
843.25
2,843.25
912828TY6
TREAS NOTE
U.S. Treasury 1.625 11/15/22
0.00
662.37
0.00
(30,027.17)
30,689.54
(615.06)
47.31
8821356W1
MUNICIPAL
Texas A&MUniv 5.000 05/15/23
15,972.22
31,250.00
0.00
0.00
47,222.22
(29,471.42)
1,778.58
3133EMH96
AGCY BULET
FFCB 0.125 06/14/23
295.14
1,562.50
0.00
0.00
1,857.64
1,817.90
3,380.40
Print Date: 10/21/2021 Print Time: 10:30 pm Page 1 of 2
Page 9 of 15
J�*
HilltopSecurities
Asset Management.
City of Southlake
Earned Income
From 06/30/2021 to 09/30/2021
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
Owperating =
91282CCU3 TREAS NOTE U.S. Treasury 0.125 08/31/23 0.00 428.18 0.00 0.00 428.18 400.68 828.86
91282CAK7 TREAS NOTE U.S. Treasury 0.125 09/15/23 0.00 492.73 2,500.00 (2,228.26) 220.99 478.80 971.53
88213AKBO MUNICIPAL Texas A&M Univ 2.549 05/15/24 14,607.89 28,580.67 0.00 0.00 43,188.56 (23,805.75) 4,774.92
Total for General Operating 289,480.55 225,985.86 275,285.54 (35,013.80) 275,194.67 (190,267.42) 35,718.44
Parks Development Corporation ii
Total for Parks Development Corporation
0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total for City of Southlake 289,480.55 225,985.86 275,285.54 (35,013.80) 275,194.67 (190,267.42) 35,718.44
Print Date: 10/21/2021 Print Time: 10:30 pm Page 2 of 2
Page 10 of 15
J�w
HilltopSecurities
Asset Management.
City of Southlake
Investment Transactions
From 0710112021 to 09/30/2021
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
Maturities
07/13/21
07/13/21
91510KUD7
CP - DISC
Univ of TX
07/13/21
3,000,000.00
100.000
3,000,000.00
0.00
3,000,000.00
0.120
07/26/21
07/26/21
89233GUS3
CP - DISC
Toyota Mtr Cr
07/26/21
5,000,000.00
100.000
5,000,000.00
0.00
5,000,000.00
0.170
08/05/21
08/05/21
2192ONV58
CP - DISC
Cornell Univ
08/05/21
5,000,000.00
100.000
5,000,000.00
0.00
5,000,000.00
0.120
08/26/21
08/26/21
882724SY4
MUNICIPAL
State of TX
4.000
08/26/21
5,000,000.00
100.000
5,000,000.00
0.00
5,000,000.00
0.211
09/15/21
09/15/21
9128285A4
TREAS NOTE
U.S. Treasury
2.750
09/15/21
5,000,000.00
100.000
5,000,000.00
0.00
5,000,000.00
0.084
Total for:
Maturities
23,000,000.00
23,000,000.00
0.00
23,000,000.00
0.143
Purchases
07/09/21
07/12/21
92181 PACE
CP - DISC
Vanderbilt Univ
01/12/22
3,000,000.00
99.949
2,998,466.67
0.00
2,998,466.67
0.100
0.100
07/09/21
07/12/21
92181 PC91
CP - DISC
Vanderbilt Univ
03/09/22
3,000,000.00
99.913
2,997,400.00
0.00
2,997,400.00
0.130
0.130
07/13/21
07/13/21
23506FAC1
CP - INT
DFW Intl Airport
0.130
11/15/21
3,000,000.00
100.000
3,000,000.00
65.00
3,000,065.00
0.130
0.130
07/26/21
07/27/21
89233HDN1
CP - DISC
Toyota Mtr Cr
04/22/22
5,000,000.00
99.888
4,994,395.83
0.00
4,994,395.83
0.150
0.150
08/05/21
08/05/21
21920NYJ5
CP - DISC
Comell Univ
11/18/21
5,000,000.00
99.971
4,998,541.67
0.00
4,998,541.67
0.100
0.100
08/25/21
08/26/21
91282CAK7
TREAS NOTE
U.S. Treasury
0.125
09/15/23
4,000,000.00
99.750
3,990,000.00
2,228.26
3,992,228.26
0.247
0.247
08/25/21
08/31/21
91282CCU3
TREAS NOTE
U.S. Treasury
0.125
08/31/23
4,000,000.00
99.766
3,990,625.00
0.00
3,990,625.00
0.243
0.243
09/27/21
09/28/21
912828YF1
TREAS NOTE
U.S. Treasury
1.500
09/15/22
5,000,000.00
101.363
5,068,164.06
2,693.37
5,070,857.43
0.085
0.085
09/27/21
09/28/21
912828TY6
TREAS NOTE
U.S. Treasury
1.625
11/15/22
5,000,000.00
101.707
5,085,351.56
30,027.17
5,115,378.73
0.113
0.113
Total for:
Purchases
37,000,000.00
37,122,944.79
35,013.80
37,157,958.59
0.143
0.143
Income Payments
08/02121
08/01/21
882669BQ6
MUNICIPAL
TX Pub Fin Auth
0.219
02/01/22
0.00
2,652.33
2,652.33
08/26/21
08/26/21
882724SY4
MUNICIPAL
State of TX
4.000
08/26/21
0.00
196,164.38
196,164.38
09/15/21
09/15/21
9128285A4
TREAS NOTE
U.S. Treasury
2.750
09/15/21
0.00
68,750.00
68,750.00
09/15/21
09/15/21
91282CAK7
TREAS NOTE
U.S. Treasury
0.125
09/15/23
0.00
2,500.00
2,500.00
Total for: Income Payments 0.00 270,066.71 270,066.71
Print Date: 10/21/2021 Print Time: 10:30 pm Page 1 of 2
Page 11 of 15
J�w
HilltopSecurities
Asset Management.
City of Southlake
Investment Transactions
From 0710112021 to 0913012021
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 Maturities 23,000,000.00
Total Purchases 37,000,000.00
Total Income Payments 0.00
23,000,000.00 0.143
37,157,958.59 0.143
270,066.71
0.143
Print Date: 10/21/2021 Print Time: 10:30 pm
Page 12 of 15
Page 2 of 2
J�*
HilltopSecurities
Asset Management.
City of Southlake
Amortization and Accretion
From 0613012021 to 09/30/2021
Orig
Amrt/Accr
Total Amrt/Accr
Remaining
;USIP Settle Date Security Type Security Description Next Call Date Purchase Qty Price Original Cost
for Period
Since Purch
Disc I Prem Book Value
91510KUD7
03/16/21
CP - DISC
Univ of TX 0.000 07/13/21
0.00
99.960
0.00
120.00
0.00
0.00
0.00
89233GUS3
01/27/21
CP - DISC
Toyota Mtr Cr 0.000 07/26/21
0.00
99.915
0.00
590.30
0.00
0.00
0.00
2192ONV58
03/19/21
CP - DISC
Cornell Univ 0.000 08/05/21
0.00
99.954
0.00
583.35
0.00
0.00
0.00
882724SY4
09/02/20
MUNICIPAL
State of TX 4.000 08/26/21
0.00
103.709
0.00
(29,008.95)
0.00
0.00
0.00
9128285A4
01/22/21
TREAS NOTE
U.S. Treasury 2.750 09/15/21
0.00
101.715
0.00
(27,514.05)
0.00
0.00
0.00
48306AX51
04/07/21
CP - DISC
Kaiser Foundation Hospital 0.000 10/05/21
5,000,000.00
99.925
4,996,229.17
1,916.65
3,687.48
83.35
4,999,916.65
9128285F3
01/22/21
TREAS NOTE
U.S. Treasury 2.875 10/15/21
5,000,000.00
102.023
5,101,171.88
(34,937.10)
(95,855.38)
(5,316.50)
5,005,316.50
19865WXL2
06/24/21
CP - DISC
Columbia Univ 0.000 10/20/21
5,000,000.00
99.974
4,998,688.89
1,022.25
1,100.01
211.10
4,999,788.90
23506FAC1
07/13/21
CP - INT
DFW Intl Airport 0.130 11/15/21
3,000,000.00
100.000
3,000,000.00
0.00
0.00
0.00
3,000,000.00
912828RR3
01/15/21
TREAS NOTE
U.S. Treasury 2.000 11/15/21
5,000,000.00
101.578
5,078,906.25
(23,729.10)
(67,299.60)
(11,606.65)
5,011,606.65
21920NYJ5
08/05/21
CP - DISC
Comell Univ 0.000 11/18/21
5,000,000.00
99.971
4,998,541.67
791.68
791.68
666.65
4,999,333.35
9128285R7
03/15/21
TREAS NOTE
U.S. Treasury 2.625 12/15/21
5,000,000.00
101.922
5,096,093.75
(32,092.55)
(69,931.30)
(26,162.45)
5,026,162.45
92181PAC6
07/12/21
CP - DISC
Vanderbilt Univ 0.000 01/12/22
3,000,000.00
99.949
2,998,466.67
675.00
675.00
858.33
2,999,141.67
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
877.49
877.49
1,722.51
2,998,277.49
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,375.02
1,375.02
4,229.15
4,995,770.85
912828YF1
09/28/21
TREAS NOTE
U.S. Treasury 1.500 09/15/22
5,000,000.00
101.363
5,068,164.06
(585.81)
(585.81)
(67,578.25)
5,067,578.25
3133EMCH3
10/13/20
AGCY CALL
FFCB 0.160 10/13/22
10/13/21 5,000,000.00
99.865
4,993,250.00
843.25
3,258.70
3,491.30
4,996,508.70
912828TY6
09/28/21
TREAS NOTE
U.S. Treasury 1.625 11/15/22
5,000,000.00
101.707
5,085,351.56
(615.06)
(615.06)
(84,736.50)
5,084,736.50
8821356W1
10/28/20
MUNICIPAL
Texas A&MUniv 5.000 05/15/23
2,500,000.00
112.026
2,800,650.00
(29,471.42)
(108,953.07)
(191,696.93)
2,691,696.93
3133EMH96
06/25/21
AGCY BULET
FFCB 0.125 06/14/23
5,000,000.00
99.713
4,985,650.00
1,817.90
1,939.10
12,410.90
4,987,589.10
91282CCU3
08/31/21
TREAS NOTE
U.S. Treasury 0.125 08/31/23
4,000,000.00
99.766
3,990,625.00
400.68
400.68
8,974.32
3,991,025.68
91282CAK7
08/26/21
TREAS NOTE
U.S. Treasury 0.125 09/15/23
4,000,000.00
99.750
3,990,000.00
478.80
478.80
9,521.20
3,990,478.80
88213AKBO
09/29/20
MUNICIPAL
Texas A&MUniv 2.549 05/15/24
4,485,000.00
107.731
4,831,735.35
(23,805.75)
(95,606.52)
(251,128.83)
4,736,128.83
Total for General Operating
80,985,000.00
82,005,320.08
(190,267.42)
(424,262.78)
(596,057.30)
81,581,057.30
Total for City
of Southlake
80,985,000.00
82,005,320.08
(190,267.42)
(424,262.78)
(596,057.30)
81,581,057.30
Print Date: 10/21/2021 Print Time: 10:30 pm Page 1 of 1
Page 13 of 15
J�*
HilltopSecurities
Asset Management..
City of Southlake
Projected Cash Flows
Cash Flows for next 180 days from 09/30/2021
CUSIP Security Type Security Description Pay Date Interest Principal Total Amount
General Operating
48306AX51
CP - DISC
Kaiser Foundation Hospital 0.000 10/05/21
10/05/21
0.00
5,000,000.00
5,000,000.00
3133EMCH3
AGCY CALL
FFCB 0.160 10/13/22
10/13/21
4,000.00
0.00
4,000.00
9128285F3
TREAS NOTE
U.S. Treasury 2.875 10/15/21
10/15/21
71,875.00
5,000,000.00
5,071,875.00
19865WXL2
CP - DISC
Columbia Univ 0.000 10/20/21
10/20/21
0.00
5,000,000.00
5,000,000.00
23506FAC1
CP - INT
DFW Intl Airport 0.130 11/15/21
11/15/21
1,419.16
3,000,000.00
3,001,419.16
8821356W1
MUNICIPAL
Texas A&MUniv 5.000 05/15/23
11/15/21
62,500.00
0.00
62,500.00
88213AKBO
MUNICIPAL
Texas A&MUniv 2.549 05/15/24
11/15/21
57,161.32
0.00
57,161.32
912828RR3
TREAS NOTE
U.S. Treasury 2.000 11/15/21
11/15/21
50,000.00
5,000,000.00
5,050,000.00
912828TY6
TREAS NOTE
U.S. Treasury 1.625 11/15/22
11/15/21
40,625.00
0.00
40,625.00
21920NYJ5
CP - DISC
Connell Univ 0.000 11/18/21
11/18/21
0.00
5,000,000.00
5,000,000.00
3133EMH96
AGCY BULET
FFCB 0.125 06/14/23
12/14/21
3,125.00
0.00
3,125.00
9128285R7
TREAS NOTE
U.S. Treasury 2.625 12/15/21
12/15/21
65,625.00
5,000,000.00
5,065,625.00
92181PAC6
CP - DISC
Vanderbilt Univ 0.000 01/12/22
01/12/22
0.00
3,000,000.00
3,000,000.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
91282CAK7
TREAS NOTE
U.S. Treasury 0.125 09/15/23
03/15/22
2,500.00
0.00
2,500.00
Total for General Operating 401,020.48 41,000,000.00 41,401,020.48
Print Date: 10/21/2021 Print Time: 10:30 pm Page 1 of 2
Page 14 of 15
1�*
HilltopSecurities
Asset Management_
City of Southlake
Projected Cash Flows
Cash Flows for next 180 days from 09/30/2021
CUSIP Security Type Security Description Pay Date Interest Principal Total Amount
October 2021
75,875.00
15,000,000.00
15,075,875.00
November 2021
211,705.48
13,000,000.00
13,211,705.48
December 2021
68,750.00
5,000,000.00
5,068,750.00
January 2022
0.00
3,000,000.00
3,000,000.00
February 2022
4,690.00
2,000,000.00
2,004,690.00
March 2022
40,000.00
3,000,000.00
3,040,000.00
Total Projected Cash Flows for City of Southlake 401,020.48 41,000,000.00 41,401,020.48
Print Date: 10/21/2021 Print Time: 10:30 pm Page 2 of 2
Page 15 of 15
9 EXPERIENC
SOUTHLF
October 26, 2021
The Marq Financial Review
CEDC FINANCIAL DASHBOARD
�avzoan sr3orzoz�
asot101262021 4.41 PM
The Marq Rentals Revenue (Net)
MARQ
cc
LH
•CZ-Rentat-Ra—nue LH-RentaLRe—rue
66.29%
72.49%
42.56%
40K
I3�
53.70% 123.45%
61.30% 118.26%
2oK
26.40%
116122°%
Target ATT
Target ATT
Target
ATi
10K
2.50M 3.77M
2.17M 1.79M
332.14K
480.97K
Revenue Expense
Revenue Expense
Revenue
I Expense
OK
,
I
0ct2020 Nov 2020 Oec 2OX Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 Jun 2021 Jul W21 Aug 2021 Sep2U1 OctZ 21
Net Revenue- Current & Previous Year
The Marq Membership Revenue (Net)
GGR L HR --Total Revenue LY
901K
180K
3w
207K
247K
42K
23K
25K
44K
170K
� -
�•
46K 38V(
200K
33K
100K
381( 27K
3SK
law �- 7EBlC'
245K
150K
AOgK
750C 13Eq( 149K
188K 775K
1451C 144H 197K
225K
202K 198i(
140K
130K
UK
i`
120K
Od2020 Nar2020 Dee2020
ka 2121 Feh2021 W-2021 Apr2021 May2021 Jua2021
.M2021 Aug2021 Sep2021 Od2021
0c12029Nor2020 De 2o2o Jan 2021 Feh 2021 Mar 2021 Apr 2021 May 2021 Jun2021 Ad 2021 Aug2021 Sep 2021 Oct 2021
CC MEMBERSHIP TRENDS
V)
Q
s
v
E
w
►]
2800
160
1400
1200
1000
woo2506 2513
2574
260\ 2444 24'
2504 2527 250�
2289
2418
2378 2360
2331 2327 2340
203 227 2
2240 ' 1968 2001
1958 1956 1941 1945 1944 /
2062 /�
� 7� /� / //
1955
1831111,81 791161
3 mg
Ln w N 00 Q1 O TA r-I N N 00 M O r-1 N r-I N M � Ln w N 00 Q1
O O O O O ri rr.' � O O O O O O O O O ri r-I ri O O O O O O O O O
G1 C1 Ql m al cn ' ' O O ' ' ' ' O O O O O O r-I ri r-I ri r-I r q ri ri ri
r-I ri ri ri ri ri N N O O O O N N N N N N N N N N N N N N N
O O O O O O 0 0 O O N N N N 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 N N N N N N N N
Period
400
350
300
250
100
50
9
450
412
400
350 333
300
250
CC Membership Joins vs. Terminations, and Retention Rate (Month -to -Month)
through 9/30/2021
224
201203 206
371
100.0%
95.0%
90.0%
85.0%
306 304
285 80.0%
250 75.0%
231
222 224
70.0%
198
200
187
190
189
65.0%
164 157
157155 153
14
60
150
24
14
138
124
25
20 127
128
28130
60.0%
112
12
12
10
18 113 3
103 188
6
07
101
55.0%
100
6
78
9
8703
63
7
50.0%
50
50
25
45.0%
0
0'
0
40.0%
O� OrO O� Oo O°� r�o ►�� ►�`1' O^ Off' O� Off` Oh OHO o1
Oo O°� ►�O ►�� ►��' O^ Off' O� Off` Oh OHO O� Oo O°�
O' O' O' O' O' O' O' O' O' O' O' O' O' O' O' O' O' O' O' O' �' �' ►�' �' �' �' �' �' �'
O^
ti
O^ O^ O� O� O^ O� O� Off' Off' Off' Off' Off' Off' Off' Off'
ti ti ti ti ti ti ti ti ti ti ti ti ti ti ti
Off' Off' Off' Off' Off' Off' Off' Off' Off' Off' Off' Off' Off'
ti ti ti ti ti ti ti ti ti ti ti ti ti
Joins
Terminations
Retention Rate
CC MEMBERSHIP JOINS VS TERMINATIONS BY MONTH & TYPE
■Adult ■Fain Fain -NC SR mYouth
400
300
200
100
Memberships in
Suspended Status
0 O it
-Z 00
-200
-300
-400
-500
Impact of Covid-19
2n�
— 4 5
s
41
s
1S
9
7
d
57�
35
20
23
25
17
8
13
42
18
.36
-18
-2a
-28
-28
-30
-20
-35
1
-50
-51
--8
-43
f48
38
-12
-12
-7
-4
-11
-10
-d
-94
7
-9
-1 7
-2
-11
28 1$
g 15
16 24 15
74 a2 2a
67
65 - -58 36
3D
'-21) f ..
-49 -39 -2£ I I
-558
-9 -7
_A
-13
u! 3n � tln N in On Gf N 1n in Ch En Yf ir1 En 4n do Elf to ifJ Eh q5 41 i/J to rh En Y1 VJ to to � tln to fn
E E E c E c E E E E E E s E E E E E E E E c E S E E E E E E E
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-2G Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21
EXPERIENCE
SOUTHLAKE
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
so
5
Fiscal Year 2019 Actual Fiscal Year 2020 Actual ■ Fiscal Year 2021 Actual
5
Fiscal Year 2019 Actual Fiscal Year 2020 Actual ■ Fiscal Year 2021 Actual
EXPERIENCE
SOUTHLAI<,.,.,E