Item 3B3 - Financial ReportCITY OF
S0UTHLA1<4,,E
MONTHLY FINANCIAL
REPORT
or— 11 1
April 2022
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 5/12/2022
ECONOMIC INDICATORS
NATIONAL ECONOMY
1.40%
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 1st
quarter of 2022 decreased at a rate of 1.4%. In the 4th
$100,000,000
quarter of 2021, GDP increased at a rate of 6.9%.
$90,000,000
$80,000,000
Housing Starts: V 0.3%
Housing starts in March were at a seasonally adjusted
$70,000,000
rate of 1,793,000, which is 0.3% above the revised
previous month figure of 1,788,000.
$60,000,000
$50,000,000
$40,000,000
UNEMPLOYMENT RATES
National: V 3.6%
The National Unemployment rate for April 2022
remained unchanged at 3.6% when compared to March
$30,000,000
2022.
$20,000,000
State-wide: 4.4%
The Texas Unemployment rate for March 2022
$10,000,000
(preliminary) decreased slightly to 4.4% from 4.7% in
February 2022.
$-
FINANCIAL ACTIVITY
DFW Area: V 3.4% 1 2018* 2019* 2020* 2021* 2022*
The Dallas/Fort Worth/Arlington Metropolitan Area
*October - April ■ New Construction permit values
unemployment rate for March 2022 (preliminary)
decreased to 3.4% when compared to 4.1 % in February
City of Southlake Monthly Financial Report 2 5/12/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,878,168
$
3,110,936
$
10,767,232
$12,000,000
Feb
$ 9,221,772
$
3,292,649
$
5,929,123
Mar
$ 3,062,209
$
3,845,975
$
(783,766)
$10,000,000
Apr
$ 2,606,899
$
3,280,619
$
(673,720)
$8,000,000
May
$ -
$
-
$
Jun
$
$
$
$6,000,000
—
Jul
$
$
$
Aug
$ -
$
-
$
_
$4,000,000
Sep
$
$
$
$2,000,000
Tot
$ 40,509,796
$
23,385,890
$
17,123,906
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
CHART OUTLOOK: I POSITIVE
The outlook for the
year is positive as overall revenues
are exceeding budget projections and expenditures are on target to be below budget. The revenues are higher than expenditures by approximately $17.1 M. The
significant variance
is due to the significant
portion of property tax revenue collected (over 90%) 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,602,323
$
1,256,119
$
1,360,873
Feb
$ 1,388,859
$
978,395
$
1,011,429
$2,000,000
'
Mar
$ 1,975,175
$
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
$ 10,688,978
$
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 (29.2%) and FY 2020 (31.2%) collections. The most recent collection for March sales were 14.3% and 41.1% above March 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 5/12/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 $ 5,872,247
$ 4,445,041 $ 4,237,797
$6,000,000
Mar $ 584,684
$ 411,151 $ 420,930
Apr $ 554,247
$ 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 $ 27,338,952
$ 26,100,905 $ 25,357,489
* Net transfer of TIF
revenues to TIF
CHART OUTLOOK:
POSITIVE fund
2022 YTD property tax
collections ($27,338,952) are higher
than 2021 YTD ($26,680,609) and 2020 YTD ($26,180,483).as of April. 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 $ 111,545
$ 76,270 $ 212,195
Mar $ 154,046
$ 150,142 $ 126,842
$200,000
Apr $ 277,691
$ 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 $ 1,204,544 $ 1,568,027 $ 1,986,161
CHART OUTLOOK:
POSITIVE
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
The value of new construction permits ($80.OM+) issued for FY 2022 YTD is approximately 53.2% and 48.4% higher when compared to FY 2021 and FY 2020, respectively. FY 2022 collections are 81.9% higher and 2.9%
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 5/12/2022
EXPENDITURE ANALYSIS
DEPARTMENTAL EXPENDITURES SUMMARY
FY 2022 ACTUAL
FY 2021 ACTUAL YTD
FY 2022 BUDGET
FY 2021/2022 YTD
YTD (APRIL)
(APRIL)
YTD (APRIL)
VARIANCE
BUDGET VARIANCE FY 2022 % SPENT
CIVIC)
$ 592,457
$
462,618
$ 601,430
$
(129,839)
$
8,973
98.51%
COMM
$ 291,022
$
275,110
$ 345,985
$
(15,912)
$
54,963
84.11%
CS
$ 3,074,964
$
2,747,095
$ 3,819,147
$
(327,869)
$
744,183
80.51%
CSO
$ 302,103
$
290,187
$ 351,628
$
(11,916)
$
49,525
85.92%
DPS
$ 10,498,585
$
9,676,929
$ 11,510,796
$
(821,656)
$
1,012,211
91.21%
ED
$ 171,970
$
87,576
$ 158,999
$
(84,394)
$
(12,971)
108.16%
FIN
$ 1,451,603
$
1,402,317
$ 1,595,371
$
(49,286)
$
143,768
90.99%
HR
$ 436,737
$
470,968
$ 514,010
$
34,231
$
77,273
84.97%
IT
$ 1,934,439
$
1,672,617
$ 2,209,195
$
(261,822)
$
274,756
87.56%
PDS
$ 1,186,168
$
1,197,562
$ 6,344,573
$
11,394
$
5,158,405
18.70%
PW
$ 2,355,159
$
2,276,283
$ 2,859,339
$
(78,876)
$
504,180
82.37%
SS
$ 1,090,684
$
1,172,479
$ 1,362,630
$
81,795
$
271,946
80.04%
Totals
$ 23,385,891
$
21,731,741
$ 31,673,103
$
(1,654,150)
$
8,287,212
73.84%
FY 2022 ACTUAL YTD (APRIL)
FY 2021 ACTUAL YTD (APRIL) FY 2022 BUDGET YTD (APRIL)
$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.1 % primarily due to DPS expenditures eligible for CARES/grant funding and reduction in programing cost in FY
2021.The outlook is positive expenditures
are below budgeted expenditures for the fiscal year.
mu
-
City of Southlake Monthly Financial Report 5 5/12/2022
HilitopSecurities
Asset Management -
City of Southlake
Investment Portfolio Summary
CITY OF
SOUTHLAKE
For the Quarter Ended
March 31, 2022
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 - MARCH 2O22:
The first quarter of 2022, capped by a dramatic March, brought substantial changes to the financial
landscape. However, the change wasn't due to a shift in the economy's performance but rather a
begrudging acknowledgement by policy makers that inflation has become a problem that must be
dealt with. February's consumer price index, based entirely on conditions that predate Russia's actions
in Ukraine, was up +7.9% year -over -year with the core rate up +6.4%. Both were 40-year highs that
will track even higher in the months ahead as Russia's invasion of Ukraine has exacerbated
inflationary pressures that were already boiling over. Russia is the world's second leading producer of
oil behind the United States and the third leading wheat producer, with Ukraine checking in at #9.
Ukraine is also a major corn producer, and the world's leader in sunflower production (Russian is #2).
The war, together with sanctions against Russia, have taken much of that supply out of the market and
sent prices skyward. The S&P GSCI, a global commodities price index, rose 29% in the first quarter
and is up 55% over the last year.
Meanwhile, U.S. employment conditions show no signs of moderating. The economy added another
678k jobs during February, taking the six-month tally to 3.5 million and pulling the unemployment rate
down to 3.8%. Initial claims for unemployment benefits set new record lows during March while the
Job Openings and Labor Turnover survey logged a third straight month with job openings above the
11 million mark. There are now 1.8 job openings for every officially unemployed American actively
seeking work.
On March 16th, the Federal Reserve's FOMC finally raised the fed funds target rate, though only by a
modest 25 basis points, and also projected at least a 25 basis point rate hike at all six of the year's
remaining meetings, while cracking open the door for larger increases if necessary. A few days later,
Chair Powell blew the door open in a speech, saying, "The labor market is very strong, and inflation is
much too high." He added, "There is an obvious need to move expeditiously to return the stance of
monetary policy to a more neutral level, and then to move to more restrictive levels if that is what is
required to restore price stability." Near the end of his speech, Powell was even more clear: "If the
committee concludes that it is appropriate to move more aggressively by raising the federal funds rate
by more than 25 bps at a meeting or meetings, we will do so." In the days that followed, Powell's
hawkish message was repeated by a parade of Fed speakers, all indicating in one way or another that
they were either in favor of, or open to, a series of larger 50 basis point hikes.
Bond markets, already worried about inflation, were sent reeling by the Fed's abrupt shift to inflation
fighting hawks. When the year began, fed funds futures were calling for a mere 75 basis points of
hikes this year. By the end of March, fed funds futures were pricing in another 200 basis points of rate
hikes and an implied fed funds rate of 2.40% by year end. The yield on the two-year Treasury note,
which is very sensitive to monetary policy, shot up 90 basis points from 1.43% at the end of February
to 2.34% at the end of March. The 10-year note rose 51 basis points to close at 2.34%. The first
quarter will go down as one of the worst bond market performances ever.
Page 2 of 17
J�*
HilltopSecurities
Asset Management_
For the Quarter Ended
March 31, 2022
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 17
J�*
HilltopSecurities
Asset Management..
Beginning Values as of 12131/21
Par Value
Market Value
Book Value
Unrealized Gain /(Loss)
Market Value %
Weighted Avg. YTW
Weighted Avg. YTM
180,269,790.95
180,437,661.50
180,676,670.87
(239,009.37)
99.87%
0.162%
0.162%
■ US TREAS 26%
■ TEXPOOL 18%
■ TEXSTAR 10%
■ LONESTRGOV 7%
■ LONESTRCRP 6%
■ TOYMCC 5%
■ Other Issuers 28%
Total: 100%
Ending Values as of 03131122
191,850,585.86
190,876,044.88
192,190,771.04
(1,314,726.16)
99.32%
0.289%
0.289%
45%
40%
35%
30 %
25%
21%
20%
15% 10% 8%
5%
0% td
Overnight 2 - 90 Days 91 - 180 6 - 12 1 - 2 Years 2 - 3 Years
Days Months
Weighted Average Days to Maturity: 179
City of Southlake
Executive Summary
As of 03/31/22
■ AGCY BULLET
5%
■ AGCY CALL
3%
■ CID
19%
■ LGIP
44%
■ MUNICIPAL
4%
■ TREASURY
26%
Total:
100%
■ A-1+ 19%
■ AAA 81%
Total: 100%
Print Date: 4/25/2022 Print Time: 9:11 pm
Page 4 of 17
Page 1 of 1
J�w
HilltopSecurities
Asset Management_
0.70%
0.60%
0.50%
0.40%
0.30%
0.20%
0.10%
City of Southlake
Benchmark Comparison
As of 0313112022
r
. o
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 Jan-22 Feb-22 Mar-22
�— 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: 4/25/2022 Print Time: 9:12 pm Page 1 of 1
Page 5 of 17
J�*
HilltopSecurities
Asset Management.
City of Southlake
Detail of Security Holdings
As of 0313112022
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,140,957.26
100.000
12,140,957.26
12,140,957.26
100.000
12,140,957.26
1
0.245
0.245
LNSTGOV
LGIP
LoneStar Gov O/N
12,718,791.62
100.000
12,718,791.62
12,718,791.62
100.000
12,718,791.62
1
0.113
0.113
TEXPOOL
LGIP
TexPool
34,437,129.97
100.000
34,437,129.97
34,437,129.97
100.000
34,437,129.97
1
0.154
0.154
TEXSTAR
LGIP
TexSTAR
19,248,402.33
100.000
19,248,402.33
19,248,402.33
100.000
19,248,402.33
1
0.107
0.107
TXCLASS
LGIP
Texas CLASS
5,320,304.68
100.000
5,320,304.68
5,320,304.68
100.000
5,320,304.68
1
0.286
0.286
48306BD51
10/05/21
CP - DISC
Kaiser Foundation Hospital
04/05/22
5,000,000.00
99.939
4,996,966.67
4,999,933.35
99.995
4,999,754.00
5
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,999,562.50
99.972
4,998,594.50
22
0.150
0.150
07286NFG9
03/17/22
CP - DISC
Baylor Univ
06/16/22
5,000,000.00
99.810
4,990,520.83
4,992,083.35
99.850
4,992,514.00
77
0.751
0.751
46640QG13
10/05/21
CP - DISC
J.P.Morgan Sec
07/01/22
5,000,000.00
99.873
4,993,648.61
4,997,851.40
99.747
4,987,363.00
92
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,998,230.55
99.762
4,988,116.50
92
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,993,972.20
99.540
4,977,009.00
141
0.311
0.311
92181PJE3
01/12/22
CP - DISC
Vanderbilt Univ
09/14/22
3,000,000.00
99.728
2,991,833.33
2,994,466.68
99.402
2,982,047.40
167
0.401
0.401
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,032,091.95
100.238
5,011,914.00
168
0.085
0.085
912828YKO
02/10/22
TREAS NOTE
U.S. Treasury
1.375
10/15/22
5,000,000.00
100.449
5,022,460.94
5,017,911.75
100.121
5,006,054.50
198
0.707
0.707
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,046,941.65
100.211
5,010,547.00
229
0.113
0.113
92181PM17
03/09/22
CP - DISC
Vanderbilt Univ
12/01/22
3,000,000.00
99.184
2,975,525.00
2,977,633.32
98.761
2,962,841.70
245
1.109
1.109
912828YW4
02/10/22
TREAS NOTE
U.S. Treasury
1.625
12/15/22
5,000,000.00
100.684
5,034,179.69
5,028,628.40
100.191
5,009,570.50
259
0.810
0.810
91282CBG5
02/02/22
TREAS NOTE
U.S. Treasury
0.125
01/31/23
2,000,000.00
99.344
1,986,875.00
1,988,985.42
98.816
1,976,328.20
306
0.789
0.789
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,013,547.05
98.906
4,945,312.50
349
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,270.10
98.465
4,923,242.00
380
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,632,696.20
103.726
2,593,142.75
410
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,991,227.75
97.838
4,891,897.00
440
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,973,900.15
97.605
4,880,273.50
471
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,993,371.84
97.289
3,891,562.40
518
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,992,918.28
97.160
3,886,406.40
533
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,982,131.35
96.918
4,845,898.50
563
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,988,384.60
97.369
4,868,436.00
588
0.546
0.546
313OAQAFO
12/22/21
AGCY CALL
FHLB
0.800
12/22/23 6/22/2022 QRTLY
5,000,000.00
100.000
5,000,000.00
5,000,000.00
97.944
4,897,192.50
631
83 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,688,445.34
99.988
4,484,441.17
776
0.400
0.400
Total for General Operating 191,850,585.86 100.375 192,538,254.61 192,190,771.04 99.497 190,876,044.88 179 0.289 0.289
Print Date: 4/25/2022 Print Time: 9:13 pm Page 1 of 2
Page 6 of 17
J�*
HilltopSecurities
Asset Management.
City of Southlake
Detail of Security Holdings
As of 03/31/2022
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 191,850,585.86 100.375 192,538,254.61 192,190,771.04 99.497 190,876,044.88 179 0.289 0.289
Print Date: 4/25/2022 Print Time: 9:13 pm Page 2 of 2
Page 7 of 17
J�*
HilltopSecurities
Asset Management.
City of Southlake
Change in Value
From 1213112021 to 03/31/2022
CUSIP Security Type Security Description 12/31121 Cost of Maturities / Amortization I Realized 03/31122 12/31121 03/31122 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
92181 PACE
CP - DISC
Vanderbilt Univ 0.000 01/12/22
8826691306
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
07286NFG9
CP - DISC
Baylor Univ 0.000 06/16/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
92181 PJE3
CP - DISC
Vanderbilt Univ 0.000 09/14/22
912828YF1
TREAS NOTE
U.S. Treasury 1.500 09/15/22
912828YKO
TREAS NOTE
U.S. Treasury 1.375 10/15/22
912828TY6
TREAS NOTE
U.S. Treasury 1.625 11/15/22
92181PM17
CP - DISC
Vanderbilt Univ 0.000 12/01/22
912828YW4
TREAS NOTE
U.S. Treasury 1.625 12/15/22
91282CBG5
TREAS NOTE
U.S. Treasury 0.125 01/31/23
912828ZD5
TREAS NOTE
U.S. Treasury 0.500 03/15/23
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
12,136,428.09
4,529.17
0.00
0.00
0.00
12,140,957.26
12,136,428.09
12,140,957.26
4,529.17
12,717,299.63
1,491.99
0.00
0.00
0.00
12,718,791.62
12,717,299.63
12,718,791.62
1,491.99
32,866,649.45
13,505,852.59
(11,935,372.07)
0.00
0.00
34,437,129.97
32,866,649.45
34,437,129.97
1,570,480.52
19,246,337.20
2,065.13
0.00
0.00
0.00
19,248,402.33
19,246,337.20
19,248,402.33
2,065.13
5,318,076.58
2,228.10
0.00
0.00
0.00
5,320,304.68
5,318,076.58
5,320,304.68
2,228.10
2,999,908.32
0.00
(3,000,000.00)
91.68
0.00
0.00
2,999,870.10
0.00
(2,999,870.10)
2,000,000.00
0.00
(2,000,000.00)
0.00
0.00
0.00
1,999,940.00
0.00
(1,999,940.00)
2,999,274.18
0.00
(3,000,000.00)
725.82
0.00
0.00
2,998,923.30
0.00
(2,998,923.30)
4,998,958.35
0.00
(5,000,000.00)
1,041.65
0.00
0.00
4,997,255.50
0.00
(4,997,255.50)
4,998,433.35
0.00
0.00
1,500.00
0.00
4,999,933.35
4,996,370.00
4,999,754.00
3,384.00
4,997,687.50
0.00
0.00
1,875.00
0.00
4,999,562.50
4,997,245.00
4,998,594.50
1,349.50
0.00
4,990,520.83
0.00
1,562.52
0.00
4,992,083.35
0.00
4,992,514.00
4,992,514.00
4,995,726.40
0.00
0.00
2,125.00
0.00
4,997,851.40
4,990,620.00
4,987,363.00
(3,257.00)
4,996,480.55
0.00
0.00
1,750.00
0.00
4,998,230.55
4,990,394.50
4,988,116.50
(2,278.00)
4,990,097.20
0.00
0.00
3,875.00
0.00
4,993,972.20
4,992,075.00
4,977,009.00
(15,066.00)
0.00
2,991,833.33
0.00
2,633.35
0.00
2,994,466.68
0.00
2,982,047.40
2,982,047.40
5,049,613.50
0.00
0.00
(17,521.55)
0.00
5,032,091.95
5,042,775.00
5,011,914.00
(30,861.00)
0.00
5,022,460.94
0.00
(4,549.19)
0.00
5,017,911.75
0.00
5,006,054.50
5,006,054.50
5,065,709.75
0.00
0.00
(18,768.10)
0.00
5,046,941.65
5,053,515.00
5,010,547.00
(42,968.00)
0.00
2,975,525.00
0.00
2,108.32
0.00
2,977,633.32
0.00
2,962,841.70
2,962,841.70
0.00
5,034,179.69
0.00
(5,551.29)
0.00
5,028,628.40
0.00
5,009,570.50
5,009,570.50
0.00
1,986,875.00
0.00
2,110.42
0.00
1,988,985.42
0.00
1,976,328.20
1,976,328.20
5,017,062.05
0.00
0.00
(3,515.00)
0.00
5,013,547.05
5,001,955.00
4,945,312.50
(56,642.50)
Print Date: 4/25/2022 Print Time: 9:13 pm Page 1 of 2
Page 8 of 17
J�*
HilltopSecurities
Asset Management.
City of Southlake
Change in Value
From 1213112021 to 03/31/2022
CUSIP
Security Type
Security Description
12/31121
Cost of
Maturities /
Amortization I
Realized
03/31122
12/31121
03/31122
Change in
Book Value
Purchases
Calls I Sales
Accretion
Gainl(Loss)
Book Value
Market Value
Market Value
Mkt Value
General Operatin
912828ZH6
TREAS NOTE
U.S. Treasury 0.250 04/15/23
5,000,334.30
0.00
0.00
(64.20)
0.00
5,000,270.10
4,983,400.00
4,923,242.00
(60,158.00)
8821356W1
MUNICIPAL
Texas A&MUniv 5.000 05/15/23
2,662,205.93
0.00
0.00
(29,509.73)
0.00
2,632,696.20
2,662,675.00
2,593,142.75
(69,532.25)
3133EMH96
AGCY BULET
FFCB 0.125 06/14/23
4,989,407.50
0.00
0.00
1,820.25
0.00
4,991,227.75
4,985,274.00
4,891,897.00
(93,377.00)
912828ZY9
TREAS NOTE
U.S. Treasury 0.125 07/15/23
4,968,899.35
0.00
0.00
5,000.80
0.00
4,973,900.15
4,964,260.00
4,880,273.50
(83,986.50)
91282CCU3
TREAS NOTE
U.S. Treasury 0.125 08/31/23
3,992,214.84
0.00
0.00
1,157.00
0.00
3,993,371.84
3,965,156.00
3,891,562.40
(73,593.60)
91282CAK7
TREAS NOTE
U.S. Treasury 0.125 09/15/23
3,991,713.68
0.00
0.00
1,204.60
0.00
3,992,918.28
3,963,752.00
3,886,406.40
(77,345.60)
91282CAP6
TREAS NOTE
U.S. Treasury 0.125 10/15/23
4,979,269.60
0.00
0.00
2,861.75
0.00
4,982,131.35
4,950,585.00
4,845,898.50
(104,686.50)
3133ENDR8
AGCY BULET
FFCB 0.400 11/09/23
4,986,584.85
0.00
0.00
1,799.75
0.00
4,988,384.60
4,972,766.00
4,868,436.00
(104,330.00)
313OAQAFO
AGCY CALL
FHLB 0.800 12/22/23
5,000,000.00
0.00
0.00
0.00
0.00
5,000,000.00
5,001,685.50
4,897,192.50
(104,493.00)
88213AKBO
MUNICIPAL
Texas A&M Univ 2.549 05/15/24
4,712,298.72
0.00
0.00
(23,853.38)
0.00
4,688,445.34
4,642,378.65
4,484,441.17
(157,937.48)
Total for General Operating
180,676,670.87
36,517,561.77
(24,935,372.07)
(68,089.53)
0.00
192,190,771.04
180,437,661.50
190,876,044.88
10,438,383.38
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 South lake
180,676,670.87
36,517,561.77
(24,935,372.07)
(68,089.53)
0.00
192,190,771.04
180,437,661.50
190,876,044.88
10,438,383.38
Print Date: 4/25/2022 Print Time: 9:13 pm Page 2 of 2
Page 9 of 17
J�*
HilltopSecurities
Asset Management..
City of Southlake
Earned Income
From 1213112021 to 03/31/2022
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
4,529.17
4,529.17
0.00
0.00
0.00
4,529.17
LNSTGOV
LGIP
LoneStar GovO/N
0.00
1,491.99
1,491.99
0.00
0.00
0.00
1,491.99
TEXPOOL
LGIP
TexPool
0.00
7,696.73
7,696.73
0.00
0.00
0.00
7,696.73
TEXSTAR
LGIP
TexSTAR
0.00
2,065.13
2,065.13
0.00
0.00
0.00
2,065.13
TXCLASS
LGIP
Texas CLASS
0.00
2,228.10
2,228.10
0.00
0.00
0.00
2,228.10
92181 PAC6
CP - DISC
Vanderbilt Univ 0.000 01/12/22
0.00
0.00
0.00
0.00
0.00
91.68
91.68
882669BQ6
MUNICIPAL
TX Pub Fin Auth 0.219 02/01/22
1,825.00
365.00
2,190.00
0.00
0.00
0.00
365.00
92181 PC91
CP - DISC
Vanderbilt Univ 0.000 03/09/22
0.00
0.00
0.00
0.00
0.00
725.82
725.82
07286NCHO
CP - DISC
Baylor Univ 0.000 03/17/22
0.00
0.00
0.00
0.00
0.00
1,041.65
1,041.65
48306BD51
CP - DISC
Kaiser Foundation Hospital 0.000 04/05/22
0.00
0.00
0.00
0.00
0.00
1,500.00
1,500.00
89233HDN1
CP - DISC
Toyota Mtr Cr 0.000 04/22/22
0.00
0.00
0.00
0.00
0.00
1,875.00
1,875.00
07286NFG9
CP - DISC
Baylor Univ 0.000 06/16/22
0.00
0.00
0.00
0.00
0.00
1,562.52
1,562.52
46640QG13
CP - DISC
J.P.MorganSec 0.000 07/01/22
0.00
0.00
0.00
0.00
0.00
2,125.00
2,125.00
91512DG13
CP - DISC
Univ of TX 0.000 07/01/22
0.00
0.00
0.00
0.00
0.00
1,750.00
1,750.00
89233HHK3
CP - DISC
Toyota Mtr Cr 0.000 08/19/22
0.00
0.00
0.00
0.00
0.00
3,875.00
3,875.00
92181 PJE3
CP - DISC
Vanderbilt Univ 0.000 09/14/22
0.00
0.00
0.00
0.00
0.00
2,633.35
2,633.35
912828YF1
TREAS NOTE
U.S. Treasury 1.500 09/15/22
22,375.69
18,588.98
37,500.00
0.00
3,464.67
(17,521.55)
1,067.43
912828YKO
TREAS NOTE
U.S. Treasury 1.375 10/15/22
0.00
9,443.68
0.00
(22,287.09)
31,730.77
(4,549.19)
4,894.49
912828TY6
TREAS NOTE
U.S. Treasury 1.625 11/15/22
10,549.03
20,200.28
0.00
0.00
30,749.31
(18,768.10)
1,432.18
92181PM17
CP - DISC
Vanderbilt Univ 0.000 12/01/22
0.00
0.00
0.00
0.00
0.00
2,108.32
2,108.32
912828YW4
TREAS NOTE
U.S. Treasury 1.625 12/15/22
0.00
11,160.72
0.00
(12,723.21)
23,883.93
(5,551.29)
5,609.43
91282CBG5
TREAS NOTE
U.S. Treasury 0.125 01/31/23
0.00
400.55
0.00
(13.81)
414.36
2,110.42
2,510.97
912828ZD5
TREAS NOTE
U.S. Treasury 0.500 03/15/23
7,458.56
6,196.33
12,500.00
0.00
1,154.89
(3,515.00)
2,681.33
912828ZH6
TREAS NOTE
U.S. Treasury 0.250 04/15/23
2,678.57
3,090.66
0.00
0.00
5,769.23
(64.20)
3,026.46
8821356W1
MUNICIPAL
Texas A&MUniv 5.000 05/15/23
15,972.22
31,250.00
0.00
0.00
47,222.22
(29,509.73)
1,740.27
3133EMH96
AGCY BULET
FFCB 0.125 06/14/23
295.14
1,562.50
0.00
0.00
1,857.64
1,820.25
3,382.75
Print Date: 4/25/2022 Print Time: 9:13 pm Page 1 of 2
Page 10 of 17
J�*
HilltopSecurities
Asset Management.
City of Southlake
Earned Income
From 1213112021 to 03/31/2022
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
912828ZY9
TREAS NOTE
U.S. Treasury 0.125 07/15/23
2,887.23
1,549.92
3,125.00
0.00
1,312.15
5,000.80
6,550.72
91282CCU3
TREAS NOTE
U.S. Treasury 0.125 08/31/23
1,698.90
1,235.88
2,500.00
0.00
434.78
1,157.00
2,392.88
91282CAK7
TREAS NOTE
U.S. Treasury 0.125 09/15/23
1,491.71
1,239.27
2,500.00
0.00
230.98
1,204.60
2,443.87
91282CAP6
TREAS NOTE
U.S. Treasury 0.125 10/15/23
1,339.29
1,545.33
0.00
0.00
2,884.62
2,861.75
4,407.08
3133ENDR8
AGCY BULET
FFCB 0.400 11/09/23
2,888.89
5,000.00
0.00
0.00
7,888.89
1,799.75
6,799.75
3130AGAFO
AGCY CALL
FHLB 0.800 12/22/23
1,000.00
10,000.00
0.00
0.00
11,000.00
0.00
10,000.00
88213AKBO
MUNICIPAL
Texas A&MUniv 2.549 05/15/24
14,607.89
28,580.67
0.00
0.00
43,188.56
(23,853.38)
4,727.29
Total for General Operating 87,068.12 169,420.89 78,326.12 (35,024.11) 213,187.00 (68,089.53) 101,331.36
Parks Development Corporation M
Total for Parks Development Corporation 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total for City of Southlake 87,068.12 169,420.89 78,326.12 (35,024.11) 213,187.00 (68,089.53) 101,331.36
Print Date: 4/25/2022 Print Time: 9:13 pm Page 2 of 2
Page 11 of 17
J�w
HilltopSecurities
Asset Management.
City of Southlake
Investment Transactions
From 0110112022 to 03/31/2022
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
01/12/22
01/12/22
92181PAC6
CP - DISC
Vanderbilt Univ
01/12/22
3,000,000.00
100.000
3,000,000.00
0.00
3,000,000.00
0.100
02/01/22
02/01/22
882669BQ6
MUNICIPAL
TX Pub Fin Auth
0.219
02/01/22
2,000,000.00
100.000
2,000,000.00
0.00
2,000,000.00
0.219
03/09/22
03/09/22
92181 PC91
CP - DISC
Vanderbilt Univ
03/09/22
3,000,000.00
100.000
3,000,000.00
0.00
3,000,000.00
0.130
03/17/22
03/17/22
07286NCHO
CP - DISC
Baylor Univ
03/17/22
5,000,000.00
100.000
5,000,000.00
0.00
5,000,000.00
0.100
Total for: Maturities
13,000,000.00
13,000,000.00
0.00
13,000,000.00
0.125
Purchases
01/12/22
01/12/22
92181PJE3
CP - DISC
Vanderbilt Univ
09/14/22
3,000,000.00
99.728
2,991,833.33
0.00
2,991,833.33
0.401
0.401
02/01/22
02/02/22
91282CBG5
TREAS NOTE
U.S. Treasury
0.125
01/31/23
2,000,000.00
99.344
1,986,875.00
13.81
1,986,888.81
0.789
0.789
02/09/22
02/10/22
912828YKO
TREAS NOTE
U.S. Treasury
1.375
10/15/22
5,000,000.00
100.449
5,022,460.94
22,287.09
5,044,748.03
0.707
0.707
02/09/22
02/10/22
912828YW4
TREAS NOTE
U.S. Treasury
1.625
12/15/22
5,000,000.00
100.684
5,034,179.69
12,723.21
5,046,902.90
0.810
0.810
03/09/22
03/09/22
92181PM17
CP - DISC
Vanderbilt Univ
12/01/22
3,000,000.00
99.184
2,975,525.00
0.00
2,975,525.00
1.109
1.109
03/17/22
03/17/22
07286NFG9
CP - DISC
Baylor Univ
06/16/22
5,000,000.00
99.810
4,990,520.83
0.00
4,990,520.83
0.751
0.751
Total for: Purchases
23,000,000.00 23,001,394.79
35,024.11
23,036,418.90 0.759 0.759
Income Payments
01/18/22 01/15/22
912828ZY9
TREAS NOTE
U.S. Treasury
0.125
07/15/23
0.00
3,125.00
3,125.00
02/01/22 02/01/22
882669BQ6
MUNICIPAL
TX Pub Fin Auth
0.219
02/01/22
0.00
2,190.00
2,190.00
02/28/22 02/28/22
91282CCU3
TREAS NOTE
U.S. Treasury
0.125
08/31/23
0.00
2,500.00
2,500.00
03/15/22 03/15/22
912828YF1
TREAS NOTE
U.S. Treasury
1.500
09/15/22
0.00
37,500.00
37,500.00
03/15/22 03/15/22
912828ZD5
TREAS NOTE
U.S. Treasury
0.500
03/15/23
0.00
12,500.00
12,500.00
03/15/22 03/15/22
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 60,315.00 60,315.00
Print Date: 4/25/2022 Print Time: 9:13 pm
Page 12 of 17
Page 1 of 2
J�w
HilltopSecurities
Asset Management.
City of Southlake
Investment Transactions
From 0110112022 to 03/31/2022
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 13,000,000.00
Total Purchases 23,000,000.00
Total Income Payments 0.00
13,000,000.00 0.125
23,036,418.90 0.759
60,315.00
0.759
Print Date: 4/25/2022 Print Time: 9:13 pm
Page 13 of 17
Page 2 of 2
J�*
HilltopSecurities
Asset Management.
City of Southlake
Amortization and Accretion
From 1213112021 to 03/31/2022
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 I Prem Book Value
92181 PAC6
07/12/21
CP - DISC
Vanderbilt Univ 0.000 01/12/22
0.00
99.949
0.00
91.68
0.00
0.00
0.00
882669BQ6
12/23/20
MUNICIPAL
TX Pub Fin Auth 0.219 02/01/22
0.00
100.000
0.00
0.00
0.00
0.00
0.00
92181 PC91
07/12/21
CP - DISC
Vanderbilt Univ 0.000 03/09/22
0.00
99.913
0.00
725.82
0.00
0.00
0.00
07286NCHO
10/20/21
CP - DISC
Baylor Univ 0.000 03/17/22
0.00
99.959
0.00
1,041.65
0.00
0.00
0.00
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,500.00
2,966.68
66.65
4,999,933.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,875.00
5,166.67
437.50
4,999,562.50
07286NFG9
03/17/22
CP - DISC
Baylor Univ 0.000 06/16/22
5,000,000.00
99.810
4,990,520.83
1,562.52
1,562.52
7,916.65
4,992,083.35
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,125.00
4,202.79
2,148.60
4,997,851.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,750.00
3,461.11
1,769.45
4,998,230.55
89233HHK3
11/23/21
CP - DISC
Toyota Mtr Cr 0.000 08/19/22
5,000,000.00
99.768
4,988,418.06
3,875.00
5,554.14
6,027.80
4,993,972.20
92181 PJE3
01/12/22
CP - DISC
Vanderbilt Univ 0.000 09/14/22
3,000,000.00
99.728
2,991,833.33
2,633.35
2,633.35
5,533.32
2,994,466.68
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,521.55)
(36,072.11)
(32,091.95)
5,032,091.95
912828YKO
02/10/22
TREAS NOTE
U.S. Treasury 1.375 10/15/22
5,000,000.00
100.449
5,022,460.94
(4,549.19)
(4,549.19)
(17,911.75)
5,017,911.75
912828TY6
09/28/21
TREAS NOTE
U.S. Treasury 1.625 11/15/22
5,000,000.00
101.707
5,085,351.56
(18,768.10)
(38,409.91)
(46,941.65)
5,046,941.65
92181PM17
03/09/22
CP - DISC
Vanderbilt Univ 0.000 12/01/22
3,000,000.00
99.184
2,975,525.00
2,108.32
2,108.32
22,366.68
2,977,633.32
912828YW4
02/10/22
TREAS NOTE
U.S. Treasury 1.625 12/15/22
5,000,000.00
100.684
5,034,179.69
(5,551.29)
(5,551.29)
(28,628.40)
5,028,628.40
91282CBG5
02/02/22
TREAS NOTE
U.S. Treasury 0.125 01/31/23
2,000,000.00
99.344
1,986,875.00
2,110.42
2,110.42
11,014.58
1,988,985.42
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,515.00)
(6,570.14)
(13,547.05)
5,013,547.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
(64.20)
(120.53)
(270.10)
5,000,270.10
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,509.73)
(167,953.80)
(132,696.20)
2,632,696.20
3133EMH96
06/25/21
AGCY BULET
FFCB 0.125 06/14/23
5,000,000.00
99.713
4,985,650.00
1,820.25
5,577.75
8,772.25
4,991,227.75
912828ZY9
12/15/21
TREAS NOTE
U.S. Treasury 0.125 07/15/23
5,000,000.00
99.359
4,967,968.75
5,000.80
5,931.40
26,099.85
4,973,900.15
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,157.00
2,746.84
6,628.16
3,993,371.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,204.60
2,918.28
7,081.72
3,992,918.28
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,861.75
5,373.54
17,868.65
4,982,131.35
3133ENDRB
11/15/21
AGCY BULET
FFCB 0.400 11/09/23
5,000,000.00
99.713
4,985,665.00
1,799.75
2,719.60
11,615.40
4,988,384.60
313OAQAFO
12/22/21
AGCY CALL
FHLB 0.800 12/22/23
06/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,853.38)
(143,290.01)
(203,445.34)
4,688,445.34
Total for General Operating 107,985,000.00 108,672,668.75 (68,089.53) (347,483.57) (340,185.18) 108,325,185.18
Print Date: 4/25/2022 Print Time: 9:13 pm Page 1 of 2
Page 14 of 17
J�w
HilltopSecurities
Asset Management_
City of Southlake
Amortization and Accretion
From 1213112021 to 03/31/2022
Orig
AmrtIAccr
Total Amrt/Accr
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 107,985,000.00 108,672,668.75 (68,089.53) (347,483.57) (340,185.18) 108,325,185.18
Print Date: 4/25/2022 Print Time: 9:13 pm Page 2 of 2
Page 15 of 17
J�*
HilltopSecurities
Asset Management..
City of Southlake
Projected Cash Flows
Cash Flows for next 180 days from 03/31/2022
CUSIP
Security Type
Security Description
Pay Date
Interest
Principal
Total Amount
General Operating
11111111�
48306BD51
CP - DISC
Kaiser Foundation Hospital 0.000 04/05/22
04/05/22
0.00
5,000,000.00
5,000,000.00
912828YKO
TREAS NOTE
U.S. Treasury 1.375 10/15/22
04/15/22
34,375.00
0.00
34,375.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&MUniv 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
912828YW4
TREAS NOTE
U.S. Treasury 1.625 12/15/22
06/15/22
40,625.00
0.00
40,625.00
07286NFG9
CP - DISC
Bavlor Univ 0.000 06/16/22
06/16/22
0.00
5,000,000.00
5,000,000.00
313OAQAFO
AGCY CALL
FHLB 0.800 12/22/23
06/22/22
20,000.00
0.00
20,000.00
46640QG13
CP - DISC
J.P.Morgan Sec 0.000 07/01/22
07/01/22
0.00
5,000,000.00
5,000,000.00
91512DG13
CP - DISC
Univ of TX 0.000 07/01/22
07/01/22
0.00
5,000,000.00
5,000,000.00
912828ZY9
TREAS NOTE
U.S. Treasury 0.125 07/15/23
07/15/22
3,125.00
0.00
3,125.00
91282CBG5
TREAS NOTE
U.S. Treasury 0.125 01/31/23
07/31/22
1,250.00
0.00
1,250.00
89233HHK3
CP - DISC
Tovota Mtr Cr 0.000 08/19/22
08/19/22
0.00
5,000,000.00
5,000,000.00
91282CCU3
TREAS NOTE
U.S. Treasury 0.125 08/31/23
08/31/22
2,500.00
0.00
2,500.00
92181PJE3
CP - DISC
Vanderbilt Univ 0.000 09/14/22
09/14/22
0.00
3,000,000.00
3,000,000.00
912828YF1
TREAS NOTE
U.S. Treasury 1.500 09/15/22
09/15/22
37,500.00
5,000,000.00
5,037,500.00
912828ZD5
TREAS NOTE
U.S. Treasury 0.500 03/15/23
09/15/22
12,500.00
0.00
12,500.00
91282CAK7
TREAS NOTE
U.S. Treasury 0.125 09/15/23
09/15/22
2,500.00
0.00
2,500.00
Total for General Operating 337,161.32 38,000,000.00 38,337,161.32
Print Date: 4/25/2022 Print Time: 9:13 pm Page 1 of 2
Page 16 of 17
1�*
HilltopSecurities
Asset Management_
City of Southlake
Projected Cash Flows
Cash Flows for next 180 days from 03/31/2022
CUSIP Security Type Security Description Pay Date Interest Principal Total Amount
April 2022
43,750.00
10,000,000.00
10,043,750.00
May 2022
170,286.32
0.00
170,286.32
June 2022
63,750.00
5,000,000.00
5,063,750.00
July 2022
4,375.00
10,000,000.00
10,004,375.00
August 2022
2,500.00
5,000,000.00
5,002,500.00
September 2022
52,500.00
8,000,000.00
8,052,500.00
Total Projected Cash Flows for City of Southlake 337,161.32 38,000,000.00 38,337,161.32
Print Date: 4/25/2022 Print Time: 9:13 pm Page 2 of 2
Page 17 of 17